|Posted: April 30, 2010, 12:26 am - IP Logged|
Can you check this and let me know if I did it right ?
I saw a couple discrepencies in directions so I want to be sure its okay..
This is after I entered todays mid draw.
OK, you entered today's Florida Midday Pick 3 - 035
Add a new sheet by right clicking any one of the Tab at the bottom. Doesn't matter which one. So right click any tab and then select "Insert" from the list of options. The a window will open then select "Worksheet" then click OK. You should now have a new sheet added. Might be sheet1, sheet2 it doesn't matter. This is where we will copy and paste our new combinations.
Go to the Tab labeled "Pick3Dueness" and enter the number 20 in cell B4.
Next, go to the Tab labeled "Pick3HitSkipChart" and enter the number 20 in cell B4
Next, staying in the same Tab "Pick3HitSkipChart" go to cell B12 and click cell b12 and hold down your left mouse button and while holding down your left mouse button move your mouse so it highlights over to cell F12. Keep holding your left mouse button down and move your mouse down and highlight all the way down to cell F1011. Let go of the left mouse button. OK so now cell range B12 through F1011 should now be highlighted. Use the scroll bar on the extreme right side and push the scroll bar all the way to the top. Next, go to cell B12 and using your mouse right-click and select Copy. Next, go to the new sheet you created above and click the Tab of the new sheet. Go to cell A1 and right click your mouse and select Paste Special. Then from the next screen select Special. You should now have 4 columns of data in cell columns A through F. Next, click cell G1.
OK, take you mouse and hover over the "C" in column C. As soon as the "cross hairs" turns into a "down arrow" click the letter C. This will highlight the entire column C. Next click the delete key on your keyboard. We don't need the data in column C.
Next, take your mouse and click column E to highlight the entire column. Take your mouse and right click. Then select "Format Cells". A Format Cells window will open. You will see Tabs at the top of this new window. Clcik the Tab labeled "Number". Go to the bottom of the list in the "Category" column and look for the word "Custom" and click the word "Custom". You will see the box to the right become active. Look for the "0" (zero) and click it. A 0 (zero) will appear under the word "Type". Enter 2 more zeros next to the first one so you shoul now have a total of 3 zeroes. (000) Then clcik the OK button. All the combinations in cell column E will be formatted with three places.
Next, click column B to highlight the entire column. Right Click using your mouse and select "Format". Click the Tab labeled "Number". To the right where you see "Decimal Places" change the decimal places from a 2 to a 5 then click the OK button.
Next, take your mouse and highlight cell columns A through F by going to the A in cell column A and holding down your left mouse drag your mouse to highlight columns A through F. Let go of your mouse button. Cell columns A through F should now be highlighted. Go the top and click the "Center" formatting Icon. Just like the Icon in Word. To the right to the Bold Italic and Underline Icons. Ok so cell columns A through F are still highlighted and now centered. Now go to the top of the Main Menu and select "Data", then select "Sort", a window will open. In the "Sort By" use the drop down to select "Column A" and to the right select "Ascending" then click the OK button. In column A you should see all the "1" for 46 total combinations. Copy and paste all 46 combinations in cell column "E" and paste them to a new column. Then sort by number group like you did in you previous post.
Should look like this:
The new list should look like the image above. We added 3 new combinations 079, 579, and 956. We lost 5 highlighted in yellow. 422, 447, 462, 513, 661. Of course the 513 hit straight. What I did was compare the new list to the last list I originally posted. You should have all the combinations with the exception of the combinations highlighted in yellow.
Here is the new Excel file with the Midday draw from today Thursday April 29 2010.