Welcome Guest
Log In | Register )
You last visited January 16, 2017, 11:54 pm
All times shown are
Eastern Time (GMT-5:00)

Vtracs 102

Topic closed. 165 replies. Last post 11 years ago by tntea.

Page 6 of 12
PrintE-mailLink
hypersoniq's avatar - 8ball
Pennsylvania
United States
Member #1340
April 6, 2003
2450 Posts
Offline
Posted: November 28, 2005, 8:07 pm - IP Logged

Quote paurths:

"My software works on MS Access tables. (and connection to SQL-server, but i doubt anyone around here has that...)
The problem with access is, it rapidly grows very big, becoming pretty slow.

As  long as you keep the data ordered there will no problem when you decide to transfer the data between excel and access..
Excel has better (faster) calculationfunctions, but access is what it is, a relational database..."

I have had a great deal of experience with MS SQL 7 while studying for the MCDBA. But I never got the opportunity to run one in the real world. I used to teach excel/access/word/front-page at the school I was in for MCSE/MCDBA, and I set up a class intranet, which had a message board in php that used access as the back-end (SQL was overkill for the amount of traffic).

excel may have faster formulae, but nothing beats the flexibility of a good query. :-)

Playing more than one ticket per game is betting against yourself.

    tntea's avatar - Lottery-059.jpg

    United States
    Member #5344
    June 30, 2004
    23641 Posts
    Offline
    Posted: November 28, 2005, 9:13 pm - IP Logged

    Quote tntea:
    "I could use some lessons on that..."

    pulling draw data from state websites? anytime... we all owe you big!

    I never hesitate to give back to the LP community with excel when I can... I learned ALOT about excel here in the forums. there are a bunch of tech-savvy excel wizards on the LP doing some very creative things, and I thank them all for what I have gained skill-wise.

    Got a few questions here..

    First let me warn you .. I am computer  illiterate or should I say... excel illiterate.

    People in the past have sent me some info on excel.. and it remains as it was sent.. Did not have clue to what I was suppose to do with it..

      question.. is there an excel program I have to have to work with before I can use what is sent?

     This stupidity of excel had made me forget my other question.. ( or it could be age..)

    tntea...

    if you have excel, clicking the windows "START" button, then the RUN button that pops up when you click START will open a dialog box... in that, type EXCEL and click O.K. ... this will cause excel to launch.

    if you get a message indicating that excel is a bad/missing file or command, then you do not have it.

    you can install a free excel viewer, but this is a viewer, not allowing changes to be made. you can find that here

    http://www.microsoft.com/downloads/details.aspx

    excel workbook files end with .xls

    did as you suggested and got a message as you warned..

    I do ave microsoft works on the computer that contains a spreadsheet.. Can I start from there or is this something totally different?

         OLD/Vtrac   Lottery Bible         Double Warnings      Thumbs Up TN F34/F44

      Avatar

      United States
      Member #351
      May 15, 2002
      78 Posts
      Offline
      Posted: November 28, 2005, 9:24 pm - IP Logged

      Tntea

      Yes, I have read 101 and 102.  Still don't know what numbers to play.

      Nov 26 evening 530 Vtrac 141

      Nov 27 evening 650 Vtrac 211

      Do I need to use the midday numbers too.  So what would be my numbers to play tonight?

       

      Joi8830

        tntea's avatar - Lottery-059.jpg

        United States
        Member #5344
        June 30, 2004
        23641 Posts
        Offline
        Posted: November 28, 2005, 9:36 pm - IP Logged

        034,084,039,089,534,584,589,539  MO evening for Tuesday.. 

             OLD/Vtrac   Lottery Bible         Double Warnings      Thumbs Up TN F34/F44

          tntea's avatar - Lottery-059.jpg

          United States
          Member #5344
          June 30, 2004
          23641 Posts
          Offline
          Posted: November 28, 2005, 9:37 pm - IP Logged

          Tntea

          Yes, I have read 101 and 102.  Still don't know what numbers to play.

          Nov 26 evening 530 Vtrac 141

          Nov 27 evening 650 Vtrac 211

          Do I need to use the midday numbers too.  So what would be my numbers to play tonight?

           

          Cannot tell by only two draws.. What state?

           

               OLD/Vtrac   Lottery Bible         Double Warnings      Thumbs Up TN F34/F44

            Avatar

            United States
            Member #351
            May 15, 2002
            78 Posts
            Offline
            Posted: November 28, 2005, 9:44 pm - IP Logged

            Tntea

            Indiana.  How many draws do you need?

            Joi8830

              hypersoniq's avatar - 8ball
              Pennsylvania
              United States
              Member #1340
              April 6, 2003
              2450 Posts
              Offline
              Posted: November 28, 2005, 11:27 pm - IP Logged

              tntea:

              microsoft works spreadsheet should do fine. although you may need to have separate files to import data. I have taken the strings chart and saved it as a CSV (comma separated value) file that works should be able to open.

              Playing more than one ticket per game is betting against yourself.

                hypersoniq's avatar - 8ball
                Pennsylvania
                United States
                Member #1340
                April 6, 2003
                2450 Posts
                Offline
                Posted: November 28, 2005, 11:38 pm - IP Logged

                I wonder if I can just paste it here...

                v111    000    005    050    055    500    505    550    555
                v112    001    006    051    056    501    506    551    556
                v113    002    007    052    057    502    507    552    557
                v114    003    008    053    058    503    508    553    558
                v115    004    009    054    059    504    509    554    559
                v121    010    015    060    065    510    515    560    565
                v122    011    016    061    066    511    516    561    566
                v123    012    017    062    067    512    517    562    567
                v124    013    018    063    068    513    518    563    568
                v125    014    019    064    069    514    519    564    569
                v131    020    025    070    075    520    525    570    575
                v132    021    026    071    076    521    526    571    576
                v133    022    027    072    077    522    527    572    577
                v134    023    028    073    078    523    528    573    578
                v135    024    029    074    079    524    529    574    579
                v141    030    035    080    085    530    535    580    585
                v142    031    036    081    086    531    536    581    586
                v143    032    037    082    087    532    537    582    587
                v144    033    038    083    088    533    538    583    588
                v145    034    039    084    089    534    539    584    589
                v151    040    045    090    095    540    545    590    595
                v152    041    046    091    096    541    546    591    596
                v153    042    047    092    097    542    547    592    597
                v154    043    048    093    098    543    548    593    598
                v155    044    049    094    099    544    549    594    599
                v211    100    105    150    155    600    605    650    655
                v212    101    106    151    156    601    606    651    656
                v213    102    107    152    157    602    607    652    657
                v214    103    108    153    158    603    608    653    658
                v215    104    109    154    159    604    609    654    659
                v221    110    115    160    165    610    615    660    665
                v222    111    116    161    166    611    616    661    666
                v223    112    117    162    167    612    617    662    667
                v224    113    118    163    168    613    618    663    668
                v225    114    119    164    169    614    619    664    669
                v231    120    125    170    175    620    625    670    675
                v232    121    126    171    176    621    626    671    676
                v233    122    127    172    177    622    627    672    677
                v234    123    128    173    178    623    628    673    678
                v235    124    129    174    179    624    629    674    679
                v241    130    135    180    185    630    635    680    685
                v242    131    136    181    186    631    636    681    686
                v243    132    137    182    187    632    637    682    687
                v244    133    138    183    188    633    638    683    688
                v245    134    139    184    189    634    639    684    689
                v251    140    145    190    195    640    645    690    695
                v252    141    146    191    196    641    646    691    696
                v253    142    147    192    197    642    647    692    697
                v254    143    148    193    198    643    648    693    698
                v255    144    149    194    199    644    649    694    699
                v311    200    205    250    255    700    705    750    755
                v312    201    206    251    256    701    706    751    756
                v313    202    207    252    257    702    707    752    757
                v314    203    208    253    258    703    708    753    758
                v315    204    209    254    259    704    709    754    759
                v321    210    215    260    265    710    715    760    765
                v322    211    216    261    266    711    716    761    766
                v323    212    217    262    267    712    717    762    767
                v324    213    218    263    268    713    718    763    768
                v325    214    219    264    269    714    719    764    769
                v331    220    225    270    275    720    725    770    775
                v332    221    226    271    276    721    726    771    776
                v333    222    227    272    277    722    727    772    777
                v334    223    228    273    278    723    728    773    778
                v335    224    229    274    279    724    729    774    779
                v341    230    235    280    285    730    735    780    785
                v342    231    236    281    286    731    736    781    786
                v343    232    237    282    287    732    737    782    787
                v344    233    238    283    288    733    738    783    788
                v345    234    239    284    289    734    739    784    789
                v351    240    245    290    295    740    745    790    795
                v352    241    246    291    296    741    746    791    796
                v353    242    247    292    297    742    747    792    797
                v354    243    248    293    298    743    748    793    798
                v355    244    249    294    299    744    749    794    799
                v411    300    305    350    355    800    805    850    855
                v412    301    306    351    356    801    806    851    856
                v413    302    307    352    357    802    807    852    857
                v414    303    308    353    358    803    808    853    858
                v415    304    309    354    359    804    809    854    859
                v421    310    315    360    365    810    815    860    865
                v422    311    316    361    366    811    816    861    866
                v423    312    317    362    367    812    817    862    867
                v424    313    318    363    368    813    818    863    868
                v425    314    319    364    369    814    819    864    869
                v431    320    325    370    375    820    825    870    875
                v432    321    326    371    376    821    826    871    876
                v433    322    327    372    377    822    827    872    877
                v434    323    328    373    378    823    828    873    878
                v435    324    329    374    379    824    829    874    879
                v441    330    335    380    385    830    835    880    885
                v442    331    336    381    386    831    836    881    886
                v443    332    337    382    387    832    837    882    887
                v444    333    338    383    388    833    838    883    888
                v445    334    339    384    389    834    839    884    889
                v451    340    345    390    395    840    845    890    895
                v452    341    346    391    396    841    846    891    896
                v453    342    347    392    397    842    847    892    897
                v454    343    348    393    398    843    848    893    898
                v455    344    349    394    399    844    849    894    899
                v511    400    405    450    455    900    905    950    955
                v512    401    406    451    456    901    906    951    956
                v513    402    407    452    457    902    907    952    957
                v514    403    408    453    458    903    908    953    958
                v515    404    409    454    459    904    909    954    959
                v521    410    415    460    465    910    915    960    965
                v522    411    416    461    466    911    916    961    966
                v523    412    417    462    467    912    917    962    967
                v524    413    418    463    468    913    918    963    968
                v525    414    419    464    469    914    919    964    969
                v531    420    425    470    475    920    925    970    975
                v532    421    426    471    476    921    926    971    976
                v533    422    427    472    477    922    927    972    977
                v534    423    428    473    478    923    928    973    978
                v535    424    429    474    479    924    929    974    979
                v541    430    435    480    485    930    935    980    985
                v542    431    436    481    486    931    936    981    986
                v543    432    437    482    487    932    937    982    987
                v544    433    438    483    488    933    938    983    988
                v545    434    439    484    489    934    939    984    989
                v551    440    445    490    495    940    945    990    995
                v552    441    446    491    496    941    946    991    996
                v553    442    447    492    497    942    947    992    997
                v554    443    448    493    498    943    948    993    998
                v555    444    449    494    499    944    949    994    999

                Playing more than one ticket per game is betting against yourself.


                  United States
                  Member #23383
                  October 11, 2005
                  485 Posts
                  Offline
                  Posted: November 29, 2005, 12:06 am - IP Logged

                  wow!!...Now that's a list of vtracs....


                    United States
                    Member #23383
                    October 11, 2005
                    485 Posts
                    Offline
                    Posted: November 29, 2005, 12:10 am - IP Logged

                    Tntea

                    Indiana.  How many draws do you need?

                    Have you completed all the lessons up to this point???  If so, you would have seen that tntea said to get your states past drawas back to 11/01..seperate them in 2 columns..( midday and evening) and other instructions.......We have a few lessons left and hopefully that will tell us how to pick our numbers....Good Luck...

                    PS: Tntea gave out the mirror states fo IN..it's on page 1 of vtrac 101 chapter 2....your state is IN.. it mirrors .. IL, FL, GA, CA , TX

                    Dman

                      paurths's avatar - underground
                      Switching between Fairfax, VA and Belgium
                      Belgium
                      Member #19287
                      July 29, 2005
                      2254 Posts
                      Offline
                      Posted: November 30, 2005, 1:46 am - IP Logged

                      Cool, vtracks travelled from New York numbers to GA cash3,  and they went boxed, just as expected
                      got me a piece of it! Banana

                      400574311/29/054,8,7Y11/29/05GA$0.25L$0.00
                      400574211/29/054,8,2Y11/29/05GA$0.25L$0.00
                      400574111/29/054,3,7Y11/29/05GA$0.25W$37.50
                      400574011/29/054,3,2Y11/29/05GA$0.25L$0.00
                      400573911/29/058,8,7Y11/29/05GA$0.25L$0.00
                      400573811/29/058,8,2Y11/29/05GA$0.25L$0.00
                      400573711/29/058,3,7Y11/29/05GA$0.25L$0.00
                      400573611/29/058,3,2Y11/29/05GA$0.25L$0.00
                      400573511/29/053,8,7Y11/29/05GA$0.25L$0.00
                      400573411/29/053,8,2Y11/29/05GA$0.25L$0.00
                      400573311/29/053,3,7Y11/29/05GA$0.25L$0.00
                      400573211/29/053,3,2Y11/29/05GA$0.25L$0.00


                      400569811/29/057,4,8N11/29/05GA$0.25L$0.00
                      400569711/29/058,4,2N11/29/05GA$0.25L$0.00
                      400569611/29/057,4,3N11/29/05GA$0.25W$225.00
                      400569511/29/053,2,4N11/29/05GA$0.25L$0.00
                      400569411/29/057,8,8N11/29/05GA$0.25L$0.00
                      400569311/29/058,8,2N11/29/05GA$0.25L$0.00
                      400569211/29/053,8,7N11/29/05GA$0.25L$0.00
                      400569111/29/053,2,8N11/29/05GA$0.25L$0.00
                      400569011/29/057,3,8N11/29/05GA$0.25L$0.00
                      400568911/29/052,3,8N11/29/05GA$0.25L$0.00
                      400568811/29/057,3,3N11/29/05GA$0.25L$0.00
                      400568711/29/053,2,3N11/29/05GA$0.25L$0.00
                        powerplayer's avatar - Lottery-022.jpg

                        United States
                        Member #17834
                        June 28, 2005
                        2083 Posts
                        Offline
                        Posted: November 30, 2005, 2:07 am - IP Logged

                         

                         

                        WTG!!!

                        paurths

                        Party

                         

                         

                        Good luck to everyone!!!

                          js1237's avatar - scenery water_mountains.jpg
                          NEW YORK
                          United States
                          Member #3100
                          December 23, 2003
                          334 Posts
                          Offline
                          Posted: November 30, 2005, 2:07 am - IP Logged

                          Cool, vtracks travelled from New York numbers to GA cash3,  and they went boxed, just as expected
                          got me a piece of it! Banana

                          400574311/29/054,8,7Y11/29/05GA$0.25L$0.00
                          400574211/29/054,8,2Y11/29/05GA$0.25L$0.00
                          400574111/29/054,3,7Y11/29/05GA$0.25W$37.50
                          400574011/29/054,3,2Y11/29/05GA$0.25L$0.00
                          400573911/29/058,8,7Y11/29/05GA$0.25L$0.00
                          400573811/29/058,8,2Y11/29/05GA$0.25L$0.00
                          400573711/29/058,3,7Y11/29/05GA$0.25L$0.00
                          400573611/29/058,3,2Y11/29/05GA$0.25L$0.00
                          400573511/29/053,8,7Y11/29/05GA$0.25L$0.00
                          400573411/29/053,8,2Y11/29/05GA$0.25L$0.00
                          400573311/29/053,3,7Y11/29/05GA$0.25L$0.00
                          400573211/29/053,3,2Y11/29/05GA$0.25L$0.00


                          400569811/29/057,4,8N11/29/05GA$0.25L$0.00
                          400569711/29/058,4,2N11/29/05GA$0.25L$0.00
                          400569611/29/057,4,3N11/29/05GA$0.25W$225.00
                          400569511/29/053,2,4N11/29/05GA$0.25L$0.00
                          400569411/29/057,8,8N11/29/05GA$0.25L$0.00
                          400569311/29/058,8,2N11/29/05GA$0.25L$0.00
                          400569211/29/053,8,7N11/29/05GA$0.25L$0.00
                          400569111/29/053,2,8N11/29/05GA$0.25L$0.00
                          400569011/29/057,3,8N11/29/05GA$0.25L$0.00
                          400568911/29/052,3,8N11/29/05GA$0.25L$0.00
                          400568811/29/057,3,3N11/29/05GA$0.25L$0.00
                          400568711/29/053,2,3N11/29/05GA$0.25L$0.00

                          So does GA also mirror NY???  TNTEA said that NJ mirrors NY...Thanks, JS..

                            paurths's avatar - underground
                            Switching between Fairfax, VA and Belgium
                            Belgium
                            Member #19287
                            July 29, 2005
                            2254 Posts
                            Offline
                            Posted: November 30, 2005, 3:17 pm - IP Logged

                            Cool, vtracks travelled from New York numbers to GA cash3,  and they went boxed, just as expected
                            got me a piece of it! Banana

                            400574311/29/054,8,7Y11/29/05GA$0.25L$0.00
                            400574211/29/054,8,2Y11/29/05GA$0.25L$0.00
                            400574111/29/054,3,7Y11/29/05GA$0.25W$37.50
                            400574011/29/054,3,2Y11/29/05GA$0.25L$0.00
                            400573911/29/058,8,7Y11/29/05GA$0.25L$0.00
                            400573811/29/058,8,2Y11/29/05GA$0.25L$0.00
                            400573711/29/058,3,7Y11/29/05GA$0.25L$0.00
                            400573611/29/058,3,2Y11/29/05GA$0.25L$0.00
                            400573511/29/053,8,7Y11/29/05GA$0.25L$0.00
                            400573411/29/053,8,2Y11/29/05GA$0.25L$0.00
                            400573311/29/053,3,7Y11/29/05GA$0.25L$0.00
                            400573211/29/053,3,2Y11/29/05GA$0.25L$0.00


                            400569811/29/057,4,8N11/29/05GA$0.25L$0.00
                            400569711/29/058,4,2N11/29/05GA$0.25L$0.00
                            400569611/29/057,4,3N11/29/05GA$0.25W$225.00
                            400569511/29/053,2,4N11/29/05GA$0.25L$0.00
                            400569411/29/057,8,8N11/29/05GA$0.25L$0.00
                            400569311/29/058,8,2N11/29/05GA$0.25L$0.00
                            400569211/29/053,8,7N11/29/05GA$0.25L$0.00
                            400569111/29/053,2,8N11/29/05GA$0.25L$0.00
                            400569011/29/057,3,8N11/29/05GA$0.25L$0.00
                            400568911/29/052,3,8N11/29/05GA$0.25L$0.00
                            400568811/29/057,3,3N11/29/05GA$0.25L$0.00
                            400568711/29/053,2,3N11/29/05GA$0.25L$0.00

                            So does GA also mirror NY???  TNTEA said that NJ mirrors NY...Thanks, JS..

                            I'm still in the process of exploring the movements of vtracks between states.
                            I don't have much states imported in my db yet (15 so far).
                            If anyone is interested, here's an excel with some information on where the VTracks that hit in NYnumbers & GA cash3 come from;  VTracks-chart for GA cash3 and NY numbers

                            Any questions, just fire at will.

                              GBSSR's avatar - spider
                              PA
                              United States
                              Member #4284
                              April 8, 2004
                              999 Posts
                              Offline
                              Posted: November 30, 2005, 4:34 pm - IP Logged

                              Do we play the same v-trac  that previously hit in our mirror state?  If so for how long ? And do we play v-tracs mid to mid, or mid to evening? I can't recognize v-trac patterns to play yet. PA v-trac 523 last night and it's mirror state Delaware had 253 mid today.

                                 
                                Page 6 of 12