Dec 23, 2014, 3:04 pm

I am in need of some help my excel data. What I would like to do is find out how many times a specific number is followed by a specific number.

Example would be; how many times was the number 5 followed by number 6.

Thank you all,

Merry Christmas,

Ted

Dec 23, 2014, 4:24 pm

Here you go:

https://app.box.com/s/on4qzn08h1oyzg5425df

Instructions:

Excel file contains 4 Tabs at the bottom.

Use the Tabs for CA3D (California Midday Draws), CA3E (California Evening Draws), and CA3C (California Combined Draws)

I'll use the CA3D Tab as the example. Same applies to the other 2 Tabs CA3E and CA3C

Click the Tab labeled CA3D

Notice there are 2 Toolbars in cell Column B1:B13

Toolbar 1 "Click To Add New Drawing". Clicking this toolbar will add a new date on Row 20. Just enter your new Pick 3 draw in cell F20

Toolbar 2 "Click To Delete Last Drawing". Clicking this toolbar will delete the most current entry on Row 20

In cell X2 you see the number 3091. This represents the total number of California Midday Pick 3 draws. I did not include every drawing. You can adjust the number in cell X2 to whatever you like. Example, 100, 200, 300, etc. This number will represent how many drawings to analyze.

In cell H14 notice the number 6. If you click cell H14 you will notice a drop down arrow to the right. You can select any number from 0 through 9. I chose the number 6 since it was the last digit drawn for Position 1 in cell H20. Notice the selections made in cells K14 and N14

In cell range Q1 through U15 are the Totals based on what you selected in Cells H14, K14, and N14. (6, 3, 2)

Cell range S13 through S15 are the 3 highest total number of Hits. So for example, in Position 1 the highest totals are 39, 35, and 34. If you go to cell S5 you will see the number 39. The 39 tells us that the number "3" (cell Q5) has hit a total of 39 times when a 6 is drawn. The remaining digits would be 8 and 9. You would look at the remaining Positions 2 and 3 using the same example.

Dec 23, 2014, 5:57 pm

California Combined Draws

Tab = CA3C

Updated the Midday drawing 9-8-1 by clicking the toolbar "Add New Drawing"

Entered 981 in cell F20

Total Draws Used = 6183 (Cell X3)

Last Draw Midday 12/23/2014 9-8-1

Select 9 cell H14

Select 8 cell K14

Select 1 cell N14

Top Digits - Note: Numbers in parenthesis are the total number of hits

(9) Top 3 Digits Position 1 = 0, 4, 5 (72), (72), (72)

(8) Top 3 Digits Position 2 = 6, 4, 8 (75), (64), (60)

(1) Top 3 Digits Position 3 = 8, 4, 5 (77), (75), (69)

Also updated the CA3D Tab > Add New Drawing > entered 981 in cell F20

Dec 23, 2014, 6:49 pm

In response to winsumloosesum

**Quote:** Originally posted by winsumloosesum on Dec 23, 2014

Here you go:

https://app.box.com/s/on4qzn08h1oyzg5425df

Instructions:

Excel file contains 4 Tabs at the bottom.

Use the Tabs for CA3D (California Midday Draws), CA3E (California Evening Draws), and CA3C (California Combined Draws)

I'll use the CA3D Tab as the example. Same applies to the other 2 Tabs CA3E and CA3C

Click the Tab labeled CA3D

Notice there are 2 Toolbars in cell Column B1:B13

Toolbar 1 "Click To Add New Drawing". Clicking this toolbar will add a new date on Row 20. Just enter your new Pick 3 draw in cell F20

Toolbar 2 "Click To Delete Last Drawing". Clicking this toolbar will delete the most current entry on Row 20

In cell X2 you see the number 3091. This represents the total number of California Midday Pick 3 draws. I did not include every drawing. You can adjust the number in cell X2 to whatever you like. Example, 100, 200, 300, etc. This number will represent how many drawings to analyze.

In cell H14 notice the number 6. If you click cell H14 you will notice a drop down arrow to the right. You can select any number from 0 through 9. I chose the number 6 since it was the last digit drawn for Position 1 in cell H20. Notice the selections made in cells K14 and N14

In cell range Q1 through U15 are the Totals based on what you selected in Cells H14, K14, and N14. (6, 3, 2)

Cell range S13 through S15 are the 3 highest total number of Hits. So for example, in Position 1 the highest totals are 39, 35, and 34. If you go to cell S5 you will see the number 39. The 39 tells us that the number "3" (cell Q5) has hit a total of 39 times when a 6 is drawn. The remaining digits would be 8 and 9. You would look at the remaining Positions 2 and 3 using the same example.

Hi win,

Thank you, exactly what I had in mind.

Merry Christmas,

Ted

Dec 23, 2014, 7:19 pm

In response to theo1946

**Quote:** Originally posted by theo1946 on Dec 23, 2014

Hi win,

Thank you, exactly what I had in mind.

Merry Christmas,

Ted

Your welcome!!

These 2 Excel files include all states draws.

https://app.box.com/s/wbi688upw1ewcwxymnpp

https://app.box.com/s/hxdykstj1nz78mfi1h7c

I post a video later on how to use the Excel files.

Dec 24, 2014, 9:07 am

In response to winsumloosesum

**Quote:** Originally posted by winsumloosesum on Dec 23, 2014

Your welcome!!

These 2 Excel files include all states draws.

https://app.box.com/s/wbi688upw1ewcwxymnpp

https://app.box.com/s/hxdykstj1nz78mfi1h7c

I post a video later on how to use the Excel files.

Thank you Steve.

Merry Christmas

Neener

TopEnd of thread (1 page)

© 2021 Speednet Group LLC Lottery Post is a registered trademark of Speednet Group. |

Welcome Guest

Your last visit: Thu, Sep 16, 2021, 10:50 pm