Benford Pick 3 Excel Files - All StatesPrev TopicNext Topic

• winsumloosesum

  

  Philadelpia/Pennsylvania
  United States
  Member #2,218
  September 1, 2003
  6,802 Posts
  Offline
  Dec 19, 2014, 4:54 pm

  ▲▼

  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
• scottjackie59

  

  Fountain Inn, SC
  United States
  Member #161,529
  December 2, 2014
  32 Posts
  Offline
  Dec 19, 2014, 10:13 pm

  ▲▼

  thank u
• lotaluck67

  

  Peru, New York
  United States
  Member #91,239
  May 13, 2010
  55 Posts
  Offline
  Dec 26, 2014, 7:20 pm

  ▲▼
  In response to winsumloosesum

  Quote: Originally posted by winsumloosesum on Dec 19, 2014

  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)