Lakerbens pick 3 combo
Instructions:
1. Enter your Pick 3 number in cell C5 (example, 867)
2. Enter +/- in cell range H5 through J5 (example, -1, -1, -1)
I modified the +/- so you could enter any +/- value in cell range H5:J5 (example, 1, -1, -2, +1, +5, -5, etc.)
If you are using a negative value make sure you enter the "-" before the value in cell range H5 though J5. (example, -1, -2, -3, -4, -5, -6, -7, -8, -9)
Added the option of either using the Root times Sum Method or using the Pick 3 number from cell C5.
Here's how it works:
1. Enter your Pick 3 combo in cell C5
2. Click cell F5. You will see a drop-down arrow to the right. Select either "A" or "B".
"A" = The Root * Sum calculation method.
"B" = Using the Pick 3 combo in cell C5.
3. Click inside Cell H5. You will see a drop-down arrow to the right. Select the +/- value for Position 1
Click inside Cell I5. You will see a drop-down arrow to the right. Select the +/- value for Position 2
Click inside Cell J5. You will see a drop-down arrow to the right. Select the +/- value for Position 3
Note: You can also select "0" in cells H5, I5, or J5. This will not change the value for that particular Position.
Here are the new download links:
Excel versions 1997 - 2003
https://www.box.com/s/j9x2468w08cqa9swbgv3
Excel versions 2007 - 2010
https://www.box.com/s/zxw8b72ktt60i9crq5hz
|
I uploaded this to Google Docs:
https://docs.google.com/spreadsheet/ccc?key=0AinNorl305O8dG5kNF96N0dpeWgzR1pVbFhub0Ixamc#gid=0
|