The time is now 6:04 am
You last visited
April 30, 2024, 5:35 am
All times shown are
Eastern Time (GMT-5:00)
Using the Morefunc Add-In formula for Excel 2002:
=EVAL(SUBSTITUTE(A1,"-","+"))
Where cell A1 has the following: 1,2,3,4,5
Sum would equal 15
Google "Morefunc" English version to download Free Morefunc Add-In
Found this website with cool Excel programs:
https://sites.google.com/a/madrocketscientist.com/jerrybeaucaires-excelassistant/files
Below are instructions in Word and Pdf format on how to update the excel file "P3StateDraws.xls".
The Word doc and Pdf have the exact same instructions. Their is a download link in both the Word doc and Pdf for the Excel file P3StateDraws.xls for those who are interested.
The main purpose I created this excel file is to have a history of all Pick 3 drawings for each state. Hopefully in the near future we can place online bets. For those who live in a country that allows online betting maybe this file will help. If you have a good handle on using Excel you can create other workbooks for analyzing the Pick 3 games and use the draw history from this Excel file.
The Excel file is version 2002 so I don't know how it will behave in other versions newer or older.
Word doc download link:
http://www.box.net/shared/vzfozaucc5
PDF doc download link:
http://www.box.net/shared/36i199rsbj
Excel file download link in both the Word doc and PDF:
http://www.box.net/shared/liqqovu76y
Post any questions or comments!! (or PM me)
I will update my copy of the Excel file P3StateDraws.xls file and post the download links in the comments of this blog posting.
Good Luck!!
Updated Pick 3 drawings through Jan 6 2010
Replace exisiting excel file with this one:
This is a thank you to DavidT from Compulotto and as a member of the old lottery forum "eLotteryUniverse".
The "neighbors" and "VTRAC" Excel files was David's idea. I just modified it a bit.
Again the thanks goes to DavidT for explaining VTRACs a number of years ago.
Download link to zip file for "Pick 3 drawings fro Pick 3 Neighbors System":
Download zip file > Unzip Excel file to your folder "Pick3NeighborsSystem" > When prompted YES to replace existing file.
Download link to zip file containing "P3StateDraws.xls" Excel file for "Pick 3 Neighbors System" folder.
Contains updates to drawings from Sunday Jan. 3, 2010
Download zip file > Unzip into Pick3 Neighbors System Folder > Click YES when prompted tot replace exisitng file.
http://www.box.net/shared/pt3kfohbl4
Good Luck!!
Updated 2 Excel files. "Pick3Neighbors.xls" and "Pick3VTRAC.xls"
The following zip file conatins all 4 Excel files. Just download and unzip the contents of the zip file into your folder C:\Pick3NeighborSystem
Here is the download link to the zip file:
http://www.box.net/shared/0ze6tsk8u4
Created a new Word document for creating custom "neighbor" combinations based on "movements". Also in pdf format.
Here is the download link:
I put together a Word document and Pdf on "Getting Started Using Neighbors & VTRAC Excel Files.
Hopefully the Instructions will answer any questions.
The Instructions will just get you started. For more information read the Blog posts.
The Word document and Pdf have the same information in 1 zip file.
Here is the link:
Below is the image of what the next drawing suggestions for Wednesday December 30, 2009 for Florida Midday drawing. This does not include Evening drawings as combined. So just using Midday drawings only.
The suggested "neighbor" selections are in cells CD19, CE19, and CF19.
We want to play the "neighbor" combo "431" for 8 combinations.
Go to the Tab labeled "WheelNeighbors125" See image below
The entries in cells B3, C3, and D3 are taken from the "NeighborCalc" sheet. Don't delete these cells.
If you are in the Tab labeled "WheelNeighbors125" (see image above, scroll over to cell range i2 through K4. These are the TOP 2 "neighbor" digits by position that are wheeled into 64 combinations. If you scroll over to cell range AE2 through AG5. These are the TOP 3 "neighbor" digits by position that are wheeled into 216 combinations.
There is another Tab labeled "WheelNeighbors1000" that is similar to the "WheelNeighbors125" tab. The "WheelNeighbors1000" Tab are wheels based on TOP "movements" of "neighbor" digits calculating ALL of the last 1000 draws or total number of draws in your particular states draw history.
There is a 3rd Tab labeled "WheelNeighborsCustom" where you can enter you own "neighbor" digit selections in the cells highlighted in yellow. So for example you could enter your "neighbor" digit selections for 8 combinations in cells B3, C3, and D3 or If you wanted to wheel 64 combinations you would enter your "neighbor" digit selections in cell range i3 through K4, or if you wanted to wheel 216 combinations enter your "neighbor" digit selections in cell range AE3 through AG5.
In the next Blog post I will explain how to create your own "custom" neigbor calculations.....
The image below is taken from the Tab labeled "NeighborCalc"
This is the update with Florida Midday Tuesday's drawing 1-9-3
In the image above is the update to the Florida Midday drawing (not combined).
In cell CC20 is the actual drawing of 1-9-3 and the "neighbor" combo equivalent 0-4-1 in cell CG20
In cell CG20 is the "neighbor" equivalent of 1-9-3 which is 0-4-1 (Position 1 - Digit 1 = Neighbor Digits 0&1, Poisiont 2 - Digit 9 = Neighbor Digits 8&9, and Position 3 - Digit 3 = Neighbor Digits 2&3. 193 = 041)
In cell CD20 are the 3 TOP "neighbor" digits 302 for Postion 1.
In cell CE20 are the 3 TOP "neighbor" digits 041 for Postion 2.
In cell CF20 are the 3 TOP "neighbor" digits 142 for Postion 3.
==============================================
In cell CH20 the "2" represents the "neighbor" digit "0" in 302 from cell CD20 for Postion 1. (2nd TOP 3 Movements for Position 1)
In cell Ci20 the "2" represents the "neighbor" digit "4" in 041 fromcell CE20 for Postion 2. (2nd TOP 3 Movements for Position 2)
In cell CJ20 the "1" represents the "neighbor" digit "1" in 142 fromcell CF20 for Postion 3. (1st TOP 3 Movements for Position 3)
===========================================================================================
In cell CL20 is 221 which is the result of the drawing. Taken from cells CH20, Ci20, and CJ20.
In CM20 a "STRAIGHT" is calculated because all 3 "neighbor" digits are from the TOP 3 "neighbor" digits in cells CD20, CE20, and CF20.
==============================================================================================
In cell CM20 the 46 represents 46 "STRAIGHT" picks from the last 125 drawings.
The 125 past draws are how the "movements are calculated. Of course we would want to play the least amount of combinations. Ideally we would want to play only 8 combinations and see the TOP 3 "neighbor" digits drawn. In cell CL20 the 221 would have required a total of 64 straight combinations. If 111 was in CL20 then it would have only required 8 combinations.
The image below is from the "Pick3Neighbors" Excel file and the Tab labeled "PositionalStraightSkipChart" (3rd Tab)
The calculations from the above chart are taken from the "NeighborCalc" Tab Cell column CL (starting in column 20)
The "positional" combos in column C in th above image show the HITS in column B and the "Current Skips" in column D and last 15 Skips starting in column F
The "111" is highighted in yellow. This would indicate the 1st digit of each position (Cell CH, CI, and CJ) in cell CD, CE, and CF columns of the "NeighborCalc" Tab
I also circled the top hits of 10 for "122" and "223"
In the image above is the Skip Chart for the "movements" for Position 1, Position 2, and Position 3.
The calculations are taken from the Tab labeled "NeighborCalc" worksheet columns BF, BE, and BF
In this part we will show the area of the "NeighborsCalc" spreadsheet that has the suggested "neighbors" digit combinations to play for the next drawing.
This area of the "NeighborCalc" spreadsheet is based on 125 past draws.
In the image above in cell range CD19 through CF19 there is the TOP 3 "neighbors" digits for each position.
Cell CD19 the TOP 3 "neighbor" digits for Position 1 are 201
Cell CE19 the TOP 3 "neighbor" digits for Position 2 are 041
Cell CF19 the TOP 3 "neighbor" digits for Position 3 are 130
These are the suggested "neighbor digits for the next drawing for December 26, 2009.
Let's look at the next line of suggested "neighbor" digits.
Cell CD20 the TOP 3 "neighbor" digits for Position 1 are 413
Cell CE20 the TOP 3 "neighbor" digits for Position 2 are 024
Cell CF20 the TOP 3 "neighbor" digits for Position 3 are 130
In the next cell CG20 you see the "neighbor" combo 124 converted from the actual drawing on December 25, 2009 which was 2-4-9
In cell CH20 you see the number 2. This represents the 2nd "neighbor" digit for Position 1 in cell CD20 which is 413.
In cell Ci20 you see the number 2. This represents the 2nd "neighbor" digit for Position 2 in cell CE20 which is 024.
In cell CJ20 the cell is blank because there were NO TOP 3 "neighbor" digits from cell CF20 which was 130. Remember the "neighbor" combo 124. The 4 (3rd Position) was not in the suggested picks or the TOP 3 "movement" neighbor digits of 130 in CF20.
Look at the image above at lines 46 and 47. You see a "1" in Position 1, Position 2, and Position 3. This means that the TOP "movement" neighbor digit was drawn in all 3 positions. So in cell CH46 you see the number 1, cell Ci46 has a number "1", and cell CJ46 has a number "1". The "neighbor" combo in cell CG46 was 4-3-1. The 4 was the 1st digit from cell CD46 (413), the 3 was the 1st digit from cell CE46 (310), and the 1 was the 1st digit from cell CF46 (142). In cell CL46 and CL47 you see 111. Also you see in cells CM46 and CM47 you see "STRAIGHT" in each cell.
Anytime you see a "STRAIGHT" in column CM the "neighbor" combo had 1 digit from each position drawn from the TOP 3 "movements". Either a 1, 2, or 3.
So the key is to play a limited number of combinations. If you play just the TOP 1 "neighbor" digit in each position you end up playing 8 combinations. If you play the TOP 2 "neighbor" digits from each position you would be playing 64 combinations. All 3 from each position would be 216 combinations.
If you scroll over to cell columns DA19 through DJ20. This is the same information as explianed above. The only difference is that the "neighbor" digit selections are calculated from 1000 drawings (or the total of draw history for your state) In the Florida Midday draw history it would represent 585 Total Midday drawings not 1000.
If you scroll over to cell columns CO19 through CW20. The cells are blank. This is left blank if you want to create your own set of "neighbor" combos.
In the next section of the "NeighborCalc" worksheet I will explain the "neighbor combination" calculations.
Scroll over to cell EO1 (see image below)
In the above charts I will just explian "N - Zero". The remaining "neighbos" are calculated the same way.
In cell EO2 you see the "N - Zero" which represents "neighbor" zero (0).
To the right in cell range EQ2 through ES2 are the TOP 3 "neigbors" digits. These are calculated by taking the numbers in cells EC2, ED2, and EE2 and adding them to EP2.
So for example, in cell EC2 we have a 4. We add the 4 to the "neighbor" digit 0 (zero) in cell EP2 which gives us the the "neighbor" digit 4 in cell EQ2. Continue the same calculations for the remaing Position 1 in cell ER2 and ES2, then Position 2 in cells EU2, EV2, and EW2, and finally for Position 3 in cells EY2, EZ2, and FA2.
Now look at cell FD2 in the image above for Position 1. You see 413 which is taken from EQ2, ER2, and ES2. Now look at cell FE2 in the image above for Position 2. You see 024 which is taken from EU2, EV2, and EW2. Now look at cell FF2 in the image above for Position 3. You see 031 which is taken from EY2, EZ2, and FA2.
So based on 125 past drawings the TOP 3 "neighbor" combinations for Position 1 is 412, Position 2 is 024, and Position 3 is 031. You can see the remaining "neighbors" calculations on lines 3, 4, 5, and 6.
In Part 4 - G I will explain the most important section of the "NeighborCalc" worksheet.....
In the next section of the "NeighborCalc" worksheet I will explain the "Movement" calculations. The following charts are based on 125 past drawings and 1000 past drawings (if your state has 1000 past drawings then it will calculate what is in the data history)
Scroll over to cell EB1 in the "NeighborCalc" Tab
In the charts above these are the calculations for the "movements" of the "neighbor" digits.
The top 3 charts in cell range EB1 through EM6 are calculations based on 125 past draws
The middle charts in cell range EB8 through EM13 are custom charts for manual entries
The bottom charts in cell range EB15 through EM20 are calculations for 1000 past drawings (if your draw history has less than 1000 past draws the calculations are based on the number of draws in your states draw history)
We will concentrate on cell range EB1 through EM6 for now.
In cell EM2 through EM6 you see "N - Zero", "N - One", "N - Two", etc. The "N" is short for "Neighbor" and the "zero" is the "Neighbor" digit.
In cells EC1, ED1, EE1 you see P1. This represents "Position 1". The reason for 3 P1's in cells EC1, ED1, and EE1 is that we are calculation the TOP 3 movements for each "Neighbor" digit.
So for example in cell EC2, the TOP "movement" for "neighbor" zero (0) is 4, the 2nd for Position 1 for "neighbor" 0 (zero) in cell ED2 is 1, and finally the 3rd is for Position 1 for "neighbor" 0 (zero) is 3.
So for Position 1 for "Neighbor" 0 (zero) the TOP 3 "movements" are 4, 1, and 3.
Scroll over to the right to cell range EG1 through Ei6 you see the chart for Position 2, and fo cell range EK1 through EM6 for Position 3.
So for "neighbor" 1 (0) the TOP 3 "movements" for Position 1 are: 4, 1, 3, Position 2 are 0, 2, 4 and Position 3 are 0, 3, 1
To get the calculations for these charts you need to click the Tab at the bottom and look for the Tab labeled "WorkoutSheetZero". This workheet is the calculations for "neighbor" 0 (zero)
In this Tab "WorkoutSheetZero" the top chart is calculations for the past 125 draws and the bottom is for calculations for 1000 past draws (if your state has this many draws)
Notice in cell M8, M9, and M10 you see the TOP 3 "movements' for "neighbor' 0 (zero) for Position 1 which are 4, 1, 3
Notice in cell P8, P9, and P10 you see the TOP 3 "movements' for "neighbor' 0 (zero) for Position 2 which are 0, 2, 4
Notice in cell S8, S9, and S10 you see the TOP 3 "movements' for "neighbor' 0 (zero) for Position 3 which are 0, 3, 1
These are the calculations from this worksheet that are in the "NeigborCalc" worksheet.
Notice in the image above there are additional worksheets for "WorkoutSheetOne", "WorkoutSheetTwo", "WorkoutSheetThree", and "WorkoutSheetFour". These are used to calculate the "movements" for "neighbors" 1, 2, 3, and 4 in the "NeighborCalc" worksheet.
So for example, you click the worksheet "WorkoutSheetOne". In cell range M8, M9, and M10 you will see TOP movements for Position 1 at 1, -1, and 0 (zero). If you click the Tab labeled "NeighborCalc" and scroll over to cell range EC3 through EE3 you see for Position 1 1, -1, and 0 (zero)
So you can see how each "neigbor" movement for Positions 1, 2, and 3 are calculated using the other worksheets "WorkoutSheetZero", "WorkoutSheetOne", "WorkoutSheetTwo", "WorkoutSheetThree", and "WorkoutSheetFour".
In Part 4 - F I will explain how we take the TOP "movements" and convert them to "neighbor" combos.....
