|Posted: July 26, 2014, 6:29 pm - IP Logged|
Excel file download link:
Instructions: Example using Pick 3 number 7-4-7 (-1,1,1) and Pick 4 number 7-4-7-0 (-1,1,1,1)
This is an older Excel file I had. Not sure if this is what you wanted.
Open the Excel file "Plus Minus System.xlsm
Click the tab at the bottom labeled "Pick3"
Enter your Pick 3 number in cells A2, A3, A4
Enter your Position 1 number in cell range C10 through U10 (select only 1 corresponding to the +/-)
Enter your Position 2 number in cell range C13 through U13 (select only 1 corresponding to the +/-)
Enter your Position 3 number in cell range C16 through U16 (select only 1 corresponding to the +/-)
Click the Toolbar in cell range W2 through AG4 labeled "Click To Sort Positions"
Your calculations will appear in cell range BK10 through BK20 (straights)
Your calculations will appear in cell range BL10 through BL20 (boxed)
And also in cells BN10 and BN11
Use the same instructions for Pick 4 Tab.