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

Any spreadsheet available?

Topic closed. 6 replies. Last post 2 years ago by ftdsn244.

Page 1 of 1
PrintE-mailLink
Avatar
ohio
United States
Member #105832
February 7, 2011
35 Posts
Offline
Posted: July 20, 2014, 12:15 pm - IP Logged

I'm looking to compare pick 4 numbers. In one column Paste my numbers and in the other column paste the winning numbers. Then have it tell me if any numbers match in any straight or boxed combination? Anything floating around? I know nothing about this formula stuff? Thank You

    MzDuffleBaglady's avatar - Lottery-018.jpg

    United States
    Member #81314
    October 16, 2009
    18985 Posts
    Offline
    Posted: July 20, 2014, 12:21 pm - IP Logged

    I'm looking to compare pick 4 numbers. In one column Paste my numbers and in the other column paste the winning numbers. Then have it tell me if any numbers match in any straight or boxed combination? Anything floating around? I know nothing about this formula stuff? Thank You

    Hello:

     

    You can go to your states web page and download all the pick 4 numbers in spreadsheet format.

     

    Good Luck.

    The Struggle is real!

      Avatar
      bowling Green ky
      United States
      Member #154383
      April 14, 2014
      1406 Posts
      Offline
      Posted: July 20, 2014, 12:24 pm - IP Logged

      Mzdufflebag can you please post Kentucky a spreadsheet.  Please

        Avatar
        bowling Green ky
        United States
        Member #154383
        April 14, 2014
        1406 Posts
        Offline
        Posted: July 20, 2014, 12:24 pm - IP Logged

        Mzdufflebag can you please post Kentucky a spreadsheet.  Please

          MzDuffleBaglady's avatar - Lottery-018.jpg

          United States
          Member #81314
          October 16, 2009
          18985 Posts
          Offline
          Posted: July 20, 2014, 12:25 pm - IP Logged

          Hello:

          I will go to their site and see if it's in spreadsheet format.

           

          Good Luck.

           

          This is what I found, I didn't find a link to download it as a spreadsheet.

          Go to your site and click on past numbers.

          Midday Drawing

          Drawing DateWinning NumbersTotal PayoutWinners
          07/19/20145 - 5 - 0$82,720481
          07/18/20145 - 2 - 6$128,990966
          07/17/20145 - 3 - 7$158,7101,713
          07/16/20143 - 0 - 6$110,3301,000
          07/15/20146 - 8 - 0$44,140523
          07/14/20145 - 4 - 7$63,220700
          07/13/2014No Drawing Today
          07/12/20146 - 8 - 9$108,130816
          07/11/20148 - 8 - 8$676,4402,298
          07/10/20141 - 6 - 6$56,670363
          07/09/20141 - 5 - 0$54,830677
          07/08/20147 - 9 - 1$73,020667
          07/07/20149 - 0 - 3$47,930468
          07/06/2014No Drawing Today
          07/05/20148 - 3 - 5$53,980677
          07/04/20142 - 6 - 1$106,6701,499
          07/03/20140 - 1 - 2$110,2501,335
          07/02/20146 - 3 - 4$68,090540
          07/01/20141 - 3 - 9$82,570894
          06/30/20143 - 0 - 2$63,410546
          06/29/2014No Drawing Today
          06/28/20140 - 5 - 9$51,650632
          06/27/20144 - 4 - 0$182,3301,011
          06/26/20143 - 6 - 2$78,9301,047
          06/25/20146 - 2 - 3$159,3601,164
          06/24/20144 - 1 - 9$111,020730
          06/23/20146 - 2 - 0$95,170693
          06/22/2014No Drawing Today
          06/21/20142 - 0 - 6$76,740803
          06/20/20141 - 1 - 8$165,260805
          06/19/20149 - 2 - 4$82,380668
          06/18/20146 - 1 - 7$123,950857
          06/17/20146 - 5 - 4$118,1101,246
          06/16/20141 - 6 - 6$122,170886
          06/15/2014No Drawing Today
          06/14/20144 - 5 - 9$45,030434
          06/13/20146 - 4 - 0$92,380691
          06/12/20143 - 0 - 1$161,5301,429
          06/11/20141 - 1 - 1$634,8602,199
          06/10/20140 - 7 - 6$37,080409
          06/09/20146 - 4 - 9$31,170325
          06/08/2014No Drawing Today
          06/07/20147 - 7 - 9$65,510495
          06/06/20142 - 6 - 7$90,990866
          06/05/20140 - 5 - 3$86,7101,380
          06/04/20143 - 3 - 2$78,400520
          06/03/20144 - 2 - 6$236,5401,796
          06/02/20149 - 3 - 5$32,820368
          06/01/2014No Drawing Today
          05/31/20149 - 0 - 8$60,990515
          05/30/20144 - 5 - 5$41,570272
          05/29/20144 - 8 - 8$53,750340
          05/28/20140 - 3 - 2$46,180618
          05/27/20140 - 1 - 5$56,620766
          05/26/20148 - 9 - 2$39,200528
          05/25/2014No Drawing Today
          05/24/20143 - 9 - 0$66,160740
          05/23/20148 - 0 - 3$109,740887
          05/22/20149 - 8 - 3$26,710332
          05/21/20144 - 2 - 1$142,8701,317
          05/20/20146 - 3 - 6$45,610260
          05/19/20148 - 0 - 0$60,390325
          05/18/2014No Drawing Today
          05/17/20145 - 8 - 9$49,130492
          05/16/20143 - 9 - 2$49,380694
          05/15/20143 - 4 - 4$53,790320
          05/14/20148 - 2 - 9$72,140617
          05/13/20145 - 7 - 5$53,590302
          05/12/20143 - 8 - 9$47,230385
          05/11/2014No Drawing Today
          05/10/20141 - 2 - 5$157,8401,220
          05/09/20144 - 8 - 7$58,830609
          05/08/20144 - 4 - 6$59,440350
          05/07/20144 - 7 - 7$68,050481
          05/06/20142 - 6 - 9$109,380900
          05/05/20148 - 0 - 9$81,010701
          05/04/2014No Drawing Today
          05/03/20143 - 5 - 3$72,370386
          05/02/20144 - 8 - 1$123,7301,460
          05/01/20146 - 8 - 0$69,910784
          04/30/20141 - 8 - 0$57,410840
          04/29/20148 - 1 - 5$101,130754
          04/28/20146 - 9 - 8$58,150587
          04/27/2014No Drawing Today
          04/26/20143 - 5 - 9$59,010462
          04/25/20140 - 0 - 6$160,0801,034
          04/24/20140 - 0 - 9$83,990545
          04/23/20140 - 7 - 7$100,650579
          04/22/20149 - 2 - 4$84,260738
          04/21/20147 - 4 - 3$48,740564
          04/20/2014No Drawing Today
          04/19/20145 - 0 - 2$123,710990
          04/18/20141 - 9 - 1$324,5002,147
          04/17/20140 - 3 - 5$91,7101,265
          04/16/20142 - 8 - 5$83,330859
          04/15/20141 - 5 - 1$109,240710
          04/14/20143 - 3 - 9$54,940302
          04/13/2014No Drawing Today
          04/12/20149 - 7 - 3$53,360581
          04/11/20147 - 6 - 6$75,150420
          04/10/20140 - 5 - 6$48,280568
          04/09/20145 - 1 - 1$180,2301,033
          04/08/20141 - 5 - 2$115,3401,323
          04/07/20144 - 1 - 1$224,4701,122
          04/06/2014No Drawing Today
          04/05/20142 - 7 - 2$143,500927
          04/04/20148 - 2 - 0$170,3401,302
          04/03/20145 - 4 - 6$166,2801,936
          04/02/20146 - 4 - 6$53,850295
          04/01/20142 - 3 - 3$87,040544
          03/31/20140 - 0 - 0$1,181,1004,045
          03/30/2014No Drawing Today
          03/29/20140 - 2 - 2$86,540559
          03/28/20148 - 1 - 8$96,390442
          03/27/20143 - 1 - 1$300,0001,661
          03/26/20142 - 9 - 5$85,830864
          03/25/20149 - 1 - 9$78,960386
          03/24/20143 - 9 - 6$98,040970
          03/23/2014No Drawing Today
          03/22/20143 - 2 - 4$231,4401,935
          03/21/20144 - 2 - 2$110,650574
          03/20/20148 - 6 - 1$57,570629
          03/19/20146 - 3 - 7$49,960454
          03/18/20140 - 4 - 2$50,540642
          03/17/20142 - 2 - 6$189,660843
          03/16/2014No Drawing Today
          03/15/20142 - 7 - 2$147,040981
          03/14/20142 - 4 - 5$124,9401,256
          03/13/20148 - 1 - 1$171,620992
          03/12/20149 - 6 - 3$101,4701,179
          03/11/20146 - 3 - 3$53,300316
          03/10/20145 - 8 - 3$79,210788
          03/09/2014No Drawing Today
          03/08/20147 - 1 - 6$95,570836
          03/07/20144 - 0 - 8$107,350744
          03/06/20146 - 0 - 8$82,750650
          03/05/20141 - 7 - 5$95,860959
          03/04/20140 - 7 - 2$67,120922
          03/03/20143 - 3 - 0$182,8401,014
          03/02/2014No Drawing Today
          03/01/20140 - 4 - 1$76,7401,090
          02/28/20149 - 3 - 2$65,320865
          02/27/20148 - 8 - 6$38,990235
          02/26/20147 - 4 - 3$62,230703
          02/25/20144 - 7 - 3$86,850903
          02/24/20147 - 9 - 6$54,080619
          02/23/2014No Drawing Today
          02/22/20142 - 6 - 3$138,9501,563
          02/21/20141 - 1 - 6$180,390982
          02/20/20145 - 7 - 3$85,7101,189
          02/19/20147 - 1 - 2$279,3102,796
          02/18/20141 - 2 - 3$1,022,7905,607
          02/17/20141 - 0 - 1$246,5301,200
          02/16/2014No Drawing Today
          02/15/20148 - 3 - 7$34,860304
          02/14/20142 - 4 - 1$263,4203,250
          02/13/20140 - 7 - 9$48,910582
          02/12/20147 - 1 - 3$128,870982
          02/11/20147 - 0 - 0$67,130386
          02/10/20143 - 5 - 7$261,9801,291
          02/09/2014No Drawing Today
          02/08/20142 - 7 - 2$133,940899
          02/07/20145 - 5 - 3$70,800450
          02/06/20142 - 5 - 0$65,630680
          02/05/20141 - 6 - 0$64,930846
          02/04/20149 - 1 - 6$85,870748
          02/03/20145 - 7 - 4$52,890509
          02/02/2014No Drawing Today
          02/01/20141 - 8 - 1$124,460780
          01/31/20140 - 2 - 2$86,470577
          01/30/20144 - 0 - 4$104,490458
          01/29/20148 - 8 - 9$38,150196
          01/28/20142 - 8 - 9$57,980515
          01/27/20147 - 4 - 8$44,070405
          01/26/2014No Drawing Today
          01/25/20143 - 7 - 9$52,090416
          01/24/20147 - 3 - 0$49,540420
          01/23/20147 - 2 - 8$86,660593
          01/22/20147 - 2 - 3$64,680618
          01/21/20140 - 2 - 5$29,540415

          Evening Drawing

          Drawing DateWinning NumbersTotal PayoutWinners
          07/19/20146 - 6 - 6$536,2201,827
          07/18/20147 - 5 - 1$101,9201,312
          07/17/20149 - 3 - 7$80,040747
          07/16/20145 - 7 - 2$134,5001,903
          07/15/20142 - 2 - 5$156,900788
          07/14/20149 - 6 - 9$67,080346
          07/13/20145 - 4 - 2$100,5601,084
          07/12/20144 - 1 - 8$164,6401,160
          07/11/20148 - 8 - 6$82,640488
          07/10/20145 - 0 - 7$67,300656
          07/09/20143 - 8 - 7$48,450502
          07/08/20148 - 9 - 4$41,170468
          07/07/20146 - 4 - 8$96,960751
          07/06/20141 - 5 - 8$74,640800
          07/05/20146 - 6 - 7$48,710273
          07/04/20146 - 3 - 4$62,930599
          07/03/20146 - 3 - 0$249,2101,586
          07/02/20147 - 9 - 1$86,210926
          07/01/20149 - 0 - 3$96,870992
          06/30/20142 - 9 - 0$51,120756
          06/29/20141 - 7 - 8$71,220868
          06/28/20141 - 2 - 5$196,8901,490
          06/27/20146 - 9 - 5$51,410514
          06/26/20140 - 0 - 4$157,2401,063
          06/25/20141 - 6 - 7$70,920771
          06/24/20143 - 3 - 7$86,710439
          06/23/20142 - 4 - 5$118,3401,125
          06/22/20142 - 5 - 5$100,840611
          06/21/20141 - 1 - 5$239,5901,087
          06/20/20141 - 1 - 4$241,8501,155
          06/19/20147 - 4 - 2$181,4601,876
          06/18/20141 - 6 - 6$89,600653
          06/17/20142 - 4 - 7$211,3901,766
          06/16/20148 - 7 - 7$51,300276
          06/15/20144 - 4 - 0$180,670995
          06/14/20143 - 0 - 3$195,970921
          06/13/20146 - 0 - 6$233,0001,013
          06/12/20147 - 9 - 1$110,3001,289
          06/11/20143 - 1 - 4$167,1701,479
          06/10/20143 - 2 - 9$105,700793
          06/09/20141 - 5 - 8$87,060858
          06/08/20140 - 7 - 4$43,220558
          06/07/20143 - 4 - 2$121,9601,669
          06/06/20142 - 5 - 0$105,3901,045
          06/05/20149 - 4 - 6$48,080513
          06/04/20142 - 0 - 3$85,620899
          06/03/20141 - 8 - 1$153,570940
          06/02/20140 - 3 - 1$111,5801,369
          06/01/20141 - 1 - 7$269,0001,354
          05/31/20148 - 1 - 3$198,0401,577
          05/30/20140 - 3 - 6$95,1301,192
          05/29/20147 - 9 - 3$56,200577
          05/28/20148 - 1 - 4$148,5601,063
          05/27/20147 - 4 - 1$154,9001,786
          05/26/20140 - 7 - 4$35,760428
          05/25/20147 - 1 - 1$364,7301,723
          05/24/20145 - 7 - 1$83,9901,115
          05/23/20140 - 1 - 0$126,040829
          05/22/20148 - 7 - 9$182,1001,865
          05/21/20147 - 0 - 4$70,500593
          05/20/20144 - 0 - 9$99,090634
          05/19/20147 - 7 - 6$39,560217
          05/18/20146 - 1 - 9$195,8301,408
          05/17/20149 - 6 - 6$47,580299
          05/16/20146 - 3 - 0$201,0801,388
          05/15/20147 - 2 - 2$175,2701,026
          05/14/20142 - 0 - 6$94,440798
          05/13/20146 - 8 - 9$64,630545
          05/12/20147 - 3 - 7$63,140357
          05/11/20140 - 0 - 8$69,290464
          05/10/20140 - 7 - 5$56,560740
          05/09/20149 - 9 - 4$49,490341
          05/08/20148 - 1 - 7$127,3401,000
          05/07/20142 - 9 - 6$74,050980
          05/06/20148 - 1 - 1$174,450963
          05/05/20140 - 3 - 3$122,340790
          05/04/20149 - 8 - 7$210,1702,158
          05/03/20146 - 9 - 6$67,960367
          05/02/20144 - 5 - 9$97,510925
          05/01/20145 - 8 - 1$87,4101,001
          04/30/20146 - 4 - 8$133,7801,050
          04/29/20143 - 2 - 5$187,0901,320
          04/28/20148 - 9 - 2$60,080753
          04/27/20149 - 3 - 7$65,240556
          04/26/20144 - 9 - 6$66,770660
          04/25/20142 - 1 - 0$186,2001,588
          04/24/20140 - 8 - 0$102,350672
          04/23/20143 - 0 - 0$127,730572
          04/22/20148 - 0 - 4$76,190622
          04/21/20140 - 5 - 7$56,200746
          04/20/20147 - 0 - 5$76,660631
          04/19/20145 - 0 - 6$102,050784
          04/18/20147 - 5 - 0$67,850572
          04/17/20147 - 0 - 9$74,390611
          04/16/20149 - 6 - 7$70,280795
          04/15/20147 - 0 - 9$76,820655
          04/14/20146 - 9 - 1$79,9101,095
          04/13/20145 - 1 - 3$302,8502,099
          04/12/20145 - 3 - 8$78,610867
          04/11/20145 - 9 - 2$80,3101,001
          04/10/20148 - 6 - 7$82,780884
          04/09/20144 - 3 - 8$86,810888
          04/08/20141 - 9 - 8$93,4201,123
          04/07/20147 - 7 - 1$126,400834
          04/06/20145 - 9 - 7$66,240786
          04/05/20140 - 7 - 0$119,970768
          04/04/20140 - 0 - 1$177,3001,144
          04/03/20142 - 0 - 7$111,2401,154
          04/02/20148 - 1 - 3$178,5401,592
          04/01/20145 - 4 - 5$74,320478
          03/31/20148 - 4 - 8$52,590285
          03/30/20144 - 4 - 2$144,170842
          03/29/20143 - 0 - 1$215,9101,881
          03/28/20143 - 6 - 5$147,8501,226
          03/27/20149 - 4 - 5$70,140689
          03/26/20147 - 5 - 2$162,6701,965
          03/25/20143 - 5 - 1$126,4601,454
          03/24/20144 - 6 - 6$95,330562
          03/23/20149 - 6 - 0$56,410678
          03/22/20140 - 7 - 8$47,310517
          03/21/20149 - 1 - 3$155,1601,211
          03/20/20145 - 8 - 7$57,660569
          03/19/20145 - 9 - 9$54,850329
          03/18/20147 - 2 - 2$205,7801,157
          03/17/20143 - 1 - 5$334,6402,358
          03/16/20143 - 6 - 1$234,9202,430
          03/15/20147 - 9 - 4$71,230754
          03/14/20147 - 7 - 1$121,170845
          03/13/20148 - 9 - 4$36,420427
          03/12/20141 - 0 - 8$217,2901,376
          03/11/20147 - 2 - 0$123,9701,043
          03/10/20146 - 6 - 6$424,5301,452
          03/09/20145 - 9 - 4$73,660910
          03/08/20148 - 9 - 5$66,210774
          03/07/20140 - 6 - 1$95,4301,309
          03/06/20140 - 1 - 2$113,9901,339
          03/05/20143 - 3 - 6$86,670517
          03/04/20145 - 4 - 8$109,5401,083
          03/03/20140 - 5 - 2$54,010765
          03/02/20141 - 1 - 1$1,500,0005,081
          03/01/20149 - 3 - 3$99,720564
          02/28/20147 - 6 - 8$107,9001,188
          02/27/20148 - 4 - 2$92,3501,108
          02/26/20148 - 0 - 9$94,320696
          02/25/20144 - 2 - 0$111,970785
          02/24/20147 - 7 - 4$77,750529
          02/23/20140 - 4 - 2$68,680960
          02/22/20141 - 4 - 7$158,1801,827
          02/21/20141 - 6 - 2$141,2301,976
          02/20/20148 - 9 - 9$51,940330
          02/19/20145 - 9 - 6$60,370590
          02/18/20149 - 9 - 7$51,520313
          02/17/20146 - 1 - 7$141,4501,048
          02/16/20144 - 5 - 2$93,7901,231
          02/15/20143 - 3 - 2$121,070785
          02/14/20143 - 4 - 9$86,850589
          02/13/20148 - 1 - 3$185,8801,637
          02/12/20140 - 6 - 3$103,5201,288
          02/11/20148 - 6 - 3$49,250548
          02/10/20147 - 6 - 7$43,750249
          02/09/20140 - 1 - 9$85,3501,128
          02/08/20149 - 3 - 5$59,110644
          02/07/20141 - 0 - 9$169,6301,186
          02/06/20143 - 5 - 5$56,610322
          02/05/20141 - 3 - 0$151,5501,479
          02/04/20144 - 2 - 3$159,3301,389
          02/03/20146 - 5 - 5$70,100370
          02/02/20142 - 2 - 9$122,770649
          02/01/20148 - 7 - 4$58,330682
          01/31/20148 - 4 - 8$49,460270
          01/30/20146 - 4 - 4$68,350373
          01/29/20143 - 8 - 0$55,170656
          01/28/20141 - 5 - 7$113,6801,128
          01/27/20140 - 5 - 2$46,240658
          01/26/20147 - 5 - 4$63,100665
          01/25/20146 - 5 - 8$54,880503
          01/24/20145 - 5 - 1$90,000569
          01/23/20146 - 8 - 3$56,050581
          01/22/20149 - 1 - 3$140,180936
          01/21/20148 - 5 - 5$59,900287


          The Struggle is real!

            Avatar
            bowling Green ky
            United States
            Member #154383
            April 14, 2014
            1406 Posts
            Offline
            Posted: July 20, 2014, 12:33 pm - IP Logged

            What site would that be? I don't know how to figure it out.

              Avatar
              ohio
              United States
              Member #105832
              February 7, 2011
              35 Posts
              Offline
              Posted: July 20, 2014, 12:41 pm - IP Logged

              Thanks for the reply. But I will be comparing all states. I found a couple sheets that might work but they only match exact order not boxed. I'd be comparing about 40 or so of my numbers to almost all states winning numbers so about 40 or 50 winning numbers. Would like something that is able to hightlight or match the winning numbers boxed or straight.