Welcome Guest
Log In | Register )
You last visited December 10, 2016, 5:39 am
All times shown are
Eastern Time (GMT-5:00)

another gift away to playing around pick 3/4

Topic closed. 5 replies. Last post 10 years ago by sysp34.

Page 1 of 1
PrintE-mailLink
sysp34's avatar - Lottery-062.jpg
Heroic City
Indonesia
Member #31689
February 2, 2006
1153 Posts
Offline
Posted: October 15, 2006, 6:15 am - IP Logged

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

    Avatar

    United States
    Member #2460
    October 7, 2003
    766 Posts
    Offline
    Posted: October 15, 2006, 11:33 am - IP Logged

    As always, thanks a lot Ragwi.

      sysp34's avatar - Lottery-062.jpg
      Heroic City
      Indonesia
      Member #31689
      February 2, 2006
      1153 Posts
      Offline
      Posted: October 16, 2006, 8:09 am - IP Logged

      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

        Avatar

        United States
        Member #2460
        October 7, 2003
        766 Posts
        Offline
        Posted: October 16, 2006, 11:05 pm - IP Logged

        Ragwi

        Thanks a lot again.

          Avatar

          United States
          Member #69
          December 30, 2001
          41 Posts
          Offline
          Posted: October 17, 2006, 1:53 pm - IP Logged

          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's avatar - Lottery-062.jpg
            Heroic City
            Indonesia
            Member #31689
            February 2, 2006
            1153 Posts
            Offline
            Posted: October 18, 2006, 8:42 am - IP Logged

            well maybe i'm forget to open the lock sheet

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

            well good luck