another gift away to playing around pick 3/4Prev TopicNext Topic

• sysp34

  

  Heroic City
  Indonesia
  Member #31,688
  February 2, 2006
  1,153 Posts
  Offline
  Oct 15, 2006, 6:15 am

  ▲▼

  hi pick 3/4 player

  just another gift away or idea to playing around pick 3/4.

  all parameter converted into vtract mode.

  download link:

  http://rapidshare.de/files/36064911/Pick3.rar.html (2134 KB) i hope this link still valid

  http://rapidshare.de/files/36813158/Pick4.rar.html (3015 KB)

  to download just click free account and wait a minute for generated code
  ps: use 7zip software to extract the files

  and thanks to people who contribute on Lottery System.

  Carbob for skips formula without his formula this spreadsheet won't be available.

  Sirmetro also for skips formula

  Fernando for filters technique and 4x3x3 matrix (known as OCS, HML, XYZ)

  Ricky for great freewheelpick4, freewheelpick and Pick4_NumbersFrom6_ways (work as design)

  Harmen for profilter pick3 (work as design)

  Dough for boxed pick 4 numbers.

  Win D and CalifDude for Last Digit Rootsum

  TNTEA for vtracts learning center.

  Todd for greatest lottery site, unique and lottery information

  All folks who contribute on Lottery Systems

  THANK YOU ALL, and good luck folks

  sysp34
• EXCALIBUR

  

  United States
  Member #2,460
  October 7, 2003
  766 Posts
  Offline
  Oct 15, 2006, 11:33 am

  ▲▼

  As always, thanks a lot Ragwi.
• sysp34

  

  Heroic City
  Indonesia
  Member #31,688
  February 2, 2006
  1,153 Posts
  Offline
  Oct 16, 2006, 8:09 am

  ▲▼

  Fernando and anyone who interest with the workout

  i just found major errata cause by vlookup (i'm forget to replace col_index_num)  :)

  here is a fixed pick 4 workout

  download link:
  http://rapidshare.de/files/36944923/Pick4A.rar.html

  well for you who have download the pick 4 workout here is the major errata and how to fixed it

  LELOHEHO, most hit 4222, max skips 4222, max skips 3322, own 4222, own 3322

  for LELOHEHO go to Q3117
  and copy this formula =VLOOKUP(Q3116,$R$3125:$S$3128,2)
  then copy the formula to R3117, S3117, T3117

  for most hit 4222 go to Q3140
  and copy this formula =VLOOKUP(Q3139,$R$3148:$S$3151,2)
  then copy the formula to R3140, S3140, T3140

  for max skips 4222 go to Q3163
  and copy this formula =VLOOKUP(Q3162,$R$3171:$S$3174,2)
  then copy the formula to R3163, S3163, T3163

  for max skips 3322 go to Q3186
  and copy this formula =VLOOKUP(Q3185,$R$3194:$S$3197,2)
  then copy the formula to R3186, S3186, T3186

  for own series 4222 go to Q3209
  and copy this formula =VLOOKUP(Q3208,$R$3217:$S$3220,2)
  then copy the formula to R3209, S3209, T3209

  for own series 3322 go to Q3232
  and copy this formula =VLOOKUP(Q3231,$R$3240:$S$3243,2)
  then copy the formula to R3232, S3232, T3232

  *******
  for LELOHEHO go to Q3275
  and copy this formula =VLOOKUP(Q3274,$R$3283:$S$3286,2)
  then copy the formula to R3275, S3275, T3275

  for most hit 4x2x2x2 go to Q3298
  and copy this formula =VLOOKUP(Q3297,$R$3306:$S$3309,2)
  then copy the formula to R3298, S3298, T3298

  for max skips 4x2x2x2 go to Q3321
  and copy this formula =VLOOKUP(Q3320,$R$3329:$S$3332,2)
  then copy the formula to R3321, S3321, T3321

  for max skips 3x3x2x2 go to Q3344
  and copy this formula =VLOOKUP(Q3343,$R$3352:$S$3355,2)
  then copy the formula to R3344, S3344, T3344

  for own series 4x2x2x2 go to Q3367
  and copy this formula =VLOOKUP(Q3366,$R$3375:$S$3378,2)
  then copy the formula to R3367, S3367, T3367

  for own series 3x3x2x2 go to Q3390
  and copy this formula =VLOOKUP(Q3389,$R$3398:$S$3401,2)
  then copy the formula to R3390, S3390, T3390

  *******
  for Vtract D & E (own vtracts)

  vtract D
  go to DD2241 and replace =VLOOKUP(B152,$Q$2229:$V$2238,4) with =VLOOKUP(B152,$Q$2229:$V$2238,5)
  then copy to DE2241, DF2241, DG2241

  vtract E (own vtracts)
  go to EH2241 and replace =VLOOKUP(B152,$Q$2229:$V$2238,5) with =VLOOKUP(B152,$Q$2229:$V$2238,6)
  then copy to EI2241, EJ2241, EK2241

  after replacing the VLOOKUP then copy column DD2241 to FK2241 and paste until row 2340

  this will fix vtracts D & E

  *******

  sorry folks for this miscalculation i guess i'm too fast creating this spreadsheet.

  i hope it help to make the right calculation.

  good luck

  sysp34
• EXCALIBUR

  

  United States
  Member #2,460
  October 7, 2003
  766 Posts
  Offline
  Oct 16, 2006, 11:05 pm

  ▲▼

  Ragwi

  Thanks a lot again.
• elaine

  

  United States
  Member #69
  December 30, 2001
  41 Posts
  Offline
  Oct 17, 2006, 1:53 pm

  ▲▼

  sysp34, I downloaded your files, when I try to paste my state's numbers it says the sheet is protected and it ask for a password.

   

  Elaine
• sysp34

  

  Heroic City
  Indonesia
  Member #31,688
  February 2, 2006
  1,153 Posts
  Offline
  Oct 18, 2006, 8:42 am

  ▲▼

  well maybe i'm forget to open the lock sheet

  just use goodluck (small letter) to open the protected worksheet.

  well good luck