FREE Pick 3/4 Excel Sheets

I have created several free spreadsheet resources for lottery players who like to track statistics and work with past drawing data in Excel. You will be pleasantly surprised to find all the formulas are unlocked, so you can freely copy and paste elements from these sheets into your own workbooks. These Excel books do not contain macros. If you want to share them, please point people to this website where they can find the links to download them from the cloud. Thank you! -Boyd French

--------------------------------------------------------------------------------------------

FREE PICK 3 SUMS, POWERS, MIRRORS, & MORE EXCEL WORKBOOK

This free Excel book contains spreadsheets for computing the sums of Pick 3 numbers, digital root sums, mirrors, base changes, powers, and more. You can download it here: https://my.pcloud.com/publink/show?code=XZ5WJWkZG8YIcTstVtXwcd6M7wHkqupiTmrV

--------------------------------------------------------------------------------------------

FREE PICK 3 STATS EXCEL WORKBOOK

Do you track Pick 3 statistics with Excel but struggle with using formulas? Download this free Pick 3 Excel book with unlocked formulas that you can modify and copy-paste to track your own Pick 3 stats and test any systems that you've devised. The sheets in this Excel book contain formulas that allow you to
  • Convert a 3-digit number to its separate digits in their own columns. E.g., "012" into "0," "1," and "2."
  • Convert 3 separate digits into a single 3-digit number. E.g., "0," "1," and "2" into "012."
  • Track the frequencies of digits in the first, middle, and last positions and calculate the chi-squared p-value (critical value) to test if the distribution of digits is uniform or skewed.
  • Track frequencies of digits in all positions and calculate p-value.
  • Track frequencies of evens (0, 2, 4, 6, 8) and odds (1, 3, 5, 7, 9) by position and calculate the p-value.
  • Track frequencies of high (5, 6, 7, 8, 9) and low (0, 1, 2, 3, 4) digits by position and calculate the p-value
  • Track frequencies of singles, doubles, and triples and calculate the p-value.
  • Convert a digit into its mirror forms and vtrac form
  • Convert a 3-digit number into its reduced box form, that is, rearrange the digits in increasing order. This allows you to track when box combos hit.
You can download it here: https://my.pcloud.com/publink/show?code=XZ4yB2kZYTty0PxDtqRGVNwRNrdl1RS9v3JX

--------------------------------------------------------------------------------------------

FREE EXPECTED RETURNS WORKBOOK

Use these sheets to work out the expected returns for various prize levels in Pick 3 and Pick 4 for base games and add-on games. You can download it here: https://my.pcloud.com/publink/show?code=XZVrYWkZ1rCTdwiUDxYrq9wjIikoqHaHJcEV

--------------------------------------------------------------------------------------------

FREE DIGITS OF PI, E, SQRT 2 EXCEL WORKBOOK

For math lovers or lottery enthusiasts who like to use unusual systems to pick randomish numbers, this Excel book has 10000 digits of the irrational numbers pi, e, sqrt(2), sqrt(3), golden mean, and natural logarithm of 2 in an easy to search format. You can download it here: https://my.pcloud.com/publink/show?code=XZ0VB2kZCsda9Q93LwbBuud8PCW0lhNy2avy