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

Benford Pick 3 Excel Files - All States

Topic closed. 2 replies. Last post 2 years ago by lotaluck67.

Page 1 of 1
51
PrintE-mailLink
winsumloosesum's avatar - Lottery-060.jpg
Pennsylvania
United States
Member #2218
September 1, 2003
5387 Posts
Offline
Posted: December 19, 2014, 4:54 pm - IP Logged

I put together an All States Benford Excel files.

I have received many PM's for individual states and it is too time consuming to create a game for each state request.

The Excel files are for version 2007, 2010, and 2013

Instructions:

Create a new folder and name it whatever you like. Example, BenfordPick3

Download the following 2 Excel files and place them into you new folder created above.

https://app.box.com/s/36zcuy2ksxdslswstr6h

https://app.box.com/s/ase6zzu6121bhvobw91t

Open the Excel file P3StateDraws.xlsm.  This Excel file contains all the draw histories of each state including the Canadian Pick 3 draws.

Keep the P3StateDraws.xlsm open then click File > Open and browse to the folder where you saved the Excel files and open the 2nd Excel file BenfordPick3.xlsm.  It may take about 30 seconds for the 2nd Excel file to calculate all the formulas.

Click the tab at the bottom labeled "Dashboard"

Click cell G4.  You should see a drop-down arrow to the right.  Click the drop-down arrow and select your states game from the list.

Give the file a few seconds again to recalculate your states draws.

I will put together a short video on how to use the other Tabs

    Avatar
    Fountain Inn, SC
    United States
    Member #161536
    December 2, 2014
    32 Posts
    Offline
    Posted: December 19, 2014, 10:13 pm - IP Logged

    thank u

      lotaluck67's avatar - DiscoBallGlowing
      Peru, New York
      United States
      Member #91243
      May 13, 2010
      54 Posts
      Offline
      Posted: December 26, 2014, 7:20 pm - IP Logged

      I put together an All States Benford Excel files.

      I have received many PM's for individual states and it is too time consuming to create a game for each state request.

      The Excel files are for version 2007, 2010, and 2013

      Instructions:

      Create a new folder and name it whatever you like. Example, BenfordPick3

      Download the following 2 Excel files and place them into you new folder created above.

      https://app.box.com/s/36zcuy2ksxdslswstr6h

      https://app.box.com/s/ase6zzu6121bhvobw91t

      Open the Excel file P3StateDraws.xlsm.  This Excel file contains all the draw histories of each state including the Canadian Pick 3 draws.

      Keep the P3StateDraws.xlsm open then click File > Open and browse to the folder where you saved the Excel files and open the 2nd Excel file BenfordPick3.xlsm.  It may take about 30 seconds for the 2nd Excel file to calculate all the formulas.

      Click the tab at the bottom labeled "Dashboard"

      Click cell G4.  You should see a drop-down arrow to the right.  Click the drop-down arrow and select your states game from the list.

      Give the file a few seconds again to recalculate your states draws.

      I will put together a short video on how to use the other Tabs

      Hello again winsum...hope you had a nice Christmas...i am not comprehending your instructions after downloading the two excel files and i opened states draw files and all cells have #N/A in them...i have been on computer 5.5 hours and am so discouraged...any and all help you can give me to get started is greatly appreciated

      thanking you in advance

      Lotaluck67(George)