Pick3 Tab Instructions

Reply #11

winsumloosesum — Tue, 30 Dec 2008 19:44:42 GMT

The morefunc addin should already imbedded into this file.

I should have deleted these columns. They really have no bearing on the file.

Below is a link to a Word doc that contains a blank workout sheet.

http://www.mediafire.com/?kgez1hma0ye

Reply #10

Raven62 — Tue, 30 Dec 2008 18:18:23 GMT

Some spreadsheet cells use funtions that are not part of Excel. The freeware addin Morefunc can be downloaded and installed to get these missing functions (mconcat, vsort, intvector):

Download Here

Reply #9

mglsr — Tue, 30 Dec 2008 14:40:28 GMT

Problem solved

Reply #8

mglsr — Tue, 30 Dec 2008 13:46:27 GMT

That didn't work Libra Dave

Reply #7

reddog — Tue, 30 Dec 2008 08:48:37 GMT

https://www.lotterypost.com/thread/186609

Reply #6

js1237 — Tue, 30 Dec 2008 04:18:31 GMT

Where is the other thread...Thanks...JS...

Reply #5

libra — Tue, 30 Dec 2008 04:05:56 GMT

Hi mglsr

##### usually means that that column is not wide enough for what needs to go in it. Highlight that column and then go up to Format, click on column and then on Autofit Selection. That should take care of it.

Good Luck Libra Dave

Reply #4

mglsr — Tue, 30 Dec 2008 03:35:35 GMT

HL4 and HY4 have the

Reply #3

reddog — Tue, 30 Dec 2008 02:10:30 GMT

Never mind. I didn't read the other thread first.

Reply #2

reddog — Tue, 30 Dec 2008 02:07:37 GMT

What work out sheet are you refering too? Where

Reply #1

winsumloosesum — Tue, 30 Dec 2008 01:44:59 GMT

When your states draw is completed check your 8 combinations.

The next step is to update the tab Pick3History draw.

Click the Toolbar Copy 250 Draws

Go to the Tab labeled BL11, BM11, BN11 and write down the first number from each of the 3 digits.

Example. If in cell BL11 the 3 digit number is 134 take the 1.

Take the 3 numbers and go to the Tab labeled VTRAC Conversion and enter the 3 numbers in cell range F5, G5, and H5.

The 8 straight Pick 3 combinations will be in cell J5.

Pick3 Tab Instructions

winsumloosesum — Tue, 30 Dec 2008 00:59:41 GMT

You should have a printout of the Workout Sheet from the PrintChart tab.

Click the Pick3 Tab.

Scroll over to cell range BF1 through BO4.

Notice in cell range BG1:BO1

You see the Movements -4, -3, -2, -1, 0, 1, 2, 3, 4

Next, go to cell BD2

Here is where you will enter the VTRAC number 1, 2, 3, 4, 5

In Cell BD2 enter the VTRAC number 1.

Notice the values change in cell range BG2 through BO4.

Go to Cell range BG2:BO2 and look for the top 3 movements for VTRAC 1 for D1.