Pick 3 ALL States - VTRAC - Excel ProgramPrev Topic Next Topic

New Topic New Poll

winsumloosesum

Philadelpia/Pennsylvania
United States
Member #2,218
September 1, 2003
6,802 Posts
Offline

Aug 26, 2014, 11:46 am

Note: You can only use Excel 2007, 2010, and 2013

Instructions:

Create a new folder and name it anything you want. Example, Pick3VTRAC

Download the following 2 Excel files and place them into your new folder

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

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

Excel file #1 - P3StateDrawsVTRAC.xlsm

Excel file #2 - Step1.xlsm
winsumloosesum

Philadelpia/Pennsylvania
United States
Member #2,218
September 1, 2003
6,802 Posts
Offline

Aug 26, 2014, 11:52 am

1st Open the Excel file P3StateDrawsVTRAC.xlsm

Once this Excel file opens you will see a pop-up window reminding you to change the date in cell F1.

Since the draws have been updated through August 25, 2014 you can just close this window.

I normally update this Excel file every morning and will post the update link from box.com

You have the option however to update this file yourself. You can update this Excel file after all the Midday draws are completed for August 26, 2014. (Since all the draws are already updated through August 25, 2014). And then update the Evening draws for August 26, 2014.

I will explain how to do this in a video and post the Youtube link in the next thread.....
winsumloosesum

Philadelpia/Pennsylvania
United States
Member #2,218
September 1, 2003
6,802 Posts
Offline

Aug 26, 2014, 1:33 pm

Youtube Video 1 - P3StateDrawsVTRAC.xlsm "How to Update the Draw History"

https://www.youtube.com/watch?v=xRVnLpqqkTA

Recommendation is to use Google Chrome as your browser.

Depending on your operating system (Windows 8, 7, Vista, XP, etc.) using the above browser should work OK when copy and pasting.

I have Windows 7 and using Mozilla Firefox which works OK for me.

Make sure you follow the instructions in the video.
LottoBux

25

Ontario
Canada
Member #109,238
April 9, 2011
60,878 Posts
Offline

Aug 26, 2014, 1:41 pm

Quote: Originally posted by winsumloosesum on Aug 26, 2014
Note: You can only use Excel 2007, 2010, and 2013

Instructions:

Create a new folder and name it anything you want. Example, Pick3VTRAC

Download the following 2 Excel files and place them into your new folder

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

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

Excel file #1 - P3StateDrawsVTRAC.xlsm

Excel file #2 - Step1.xlsm

Thanks Steve And Have A Happy Birthday.
winsumloosesum

Philadelpia/Pennsylvania
United States
Member #2,218
September 1, 2003
6,802 Posts
Offline

Aug 26, 2014, 2:32 pm

Here is Youtube Video 2:

https://www.youtube.com/watch?v=IGdRMnX3nx0

This video explains the Draws tab worksheet located in the Step1.xlsm Excel file.

One thing I should mention is when or if you update the draw histories for the P3StateDrawsVTRAC.xlsm Excel file do NOT have both Excel files opened.

Close the Step1.xlsm file and only keep the P3StateDrawsVTRAC.xlsm file open when updating draws.

Next video 3 I will explain the "134Numbers" Tab.....
LottoBux

25

Ontario
Canada
Member #109,238
April 9, 2011
60,878 Posts
Offline

Aug 26, 2014, 4:28 pm

Quote: Originally posted by winsumloosesum on Aug 26, 2014
Here is Youtube Video 2:

https://www.youtube.com/watch?v=IGdRMnX3nx0

This video explains the Draws tab worksheet located in the Step1.xlsm Excel file.

One thing I should mention is when or if you update the draw histories for the P3StateDrawsVTRAC.xlsm Excel file do NOT have both Excel files opened.

Close the Step1.xlsm file and only keep the P3StateDrawsVTRAC.xlsm file open when updating draws.

Next video 3 I will explain the "134Numbers" Tab.....

Hi winsum,

When I Open The Step 1 File I Noticed That None Of The Results From Aug 25th To Aug 9th Are Populated.

I Don't See Any Dropdowns Where I Can Adjust The Amount Of Draws.

In The Video They Are There.

The Only Draws Showing Are From The 1st Of The Month To The 8th Of Each Of The Months.
winsumloosesum

Philadelpia/Pennsylvania
United States
Member #2,218
September 1, 2003
6,802 Posts
Offline

Aug 26, 2014, 6:25 pm

Quote: Originally posted by LottoBux on Aug 26, 2014
Hi winsum,

When I Open The Step 1 File I Noticed That None Of The Results From Aug 25th To Aug 9th Are Populated.

I Don't See Any Dropdowns Where I Can Adjust The Amount Of Draws.

In The Video They Are There.

The Only Draws Showing Are From The 1st Of The Month To The 8th Of Each Of The Months.

Not sure why your data is incorrect.

What version of Excel are you using?

You have a number of empty cells that should have data.

What is the date in cell B1. That is what is the format? MM/DD/YYYY

I have 8/25/2014 in cell B1

Your correct, you don't have any cells to adjust the day.

Anyone else who downloaded and opened the Step1.xlsm Excel file show the same errors?
LottoBux

25

Ontario
Canada
Member #109,238
April 9, 2011
60,878 Posts
Offline

Aug 26, 2014, 6:34 pm

Quote: Originally posted by winsumloosesum on Aug 26, 2014
Not sure why your data is incorrect.

What version of Excel are you using?

You have a number of empty cells that should have data.

What is the date in cell B1. That is what is the format? MM/DD/YYYY

I have 8/25/2014 in cell B1

Your correct, you don't have any cells to adjust the day.

Anyone else who downloaded and opened the Step1.xlsm Excel file show the same errors?

I'm Using Excel 2010

At First I Had Them In The Same Folder (Pick3 System)As Most Of The Other Excel Files.

I Then Created A New Folder Just With Those 2 Files(Not In The Pick3 System Folder)

I Can Try Re Downloading The Pick3 VTrac State Draws File Since I D/L'ed It Before You Had The Started The Thread.

It Was With The Pick 3 And Pick 4 Excel Files.

EDIT..The Date In B1 Is 8/25/2014
winsumloosesum

Philadelpia/Pennsylvania
United States
Member #2,218
September 1, 2003
6,802 Posts
Offline

Aug 26, 2014, 6:55 pm

OK,

I made a few enhancements to both Excel files.

Delete what you currently have and re-download using the same links from the opening thread.

Same as below:

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

https://app.box.com/s/gdtqocvqhncvfjna8d06
LottoBux

25

Ontario
Canada
Member #109,238
April 9, 2011
60,878 Posts
Offline

Aug 26, 2014, 7:12 pm

Quote: Originally posted by winsumloosesum on Aug 26, 2014
OK,

I made a few enhancements to both Excel files.

Delete what you currently have and re-download using the same links from the opening thread.

Same as below:

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

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

It Looks The Same As The Other File.Still No Data In Those Cells.

I Guess We'll Have To See If Anyone Else Has Downloaded The File.
winsumloosesum

Philadelpia/Pennsylvania
United States
Member #2,218
September 1, 2003
6,802 Posts
Offline

Aug 26, 2014, 7:46 pm

Not sure why your Excel files are showing incorrect data. I just downloaded the same files and placed them in a 2nd test folder just to see if maybe the files became corrupt but opened and worked OK

I placed the 2 Excel files into a zip folder and uploaded them to box.com

Try downloading the zip file and see what happens:

https://app.box.com/s/gxuwebau5dpxhtma0pfg
LottoBux

25

Ontario
Canada
Member #109,238
April 9, 2011
60,878 Posts
Offline

Aug 26, 2014, 8:13 pm

Quote: Originally posted by winsumloosesum on Aug 26, 2014
Not sure why your Excel files are showing incorrect data. I just downloaded the same files and placed them in a 2nd test folder just to see if maybe the files became corrupt but opened and worked OK

I placed the 2 Excel files into a zip folder and uploaded them to box.com

Try downloading the zip file and see what happens:

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

No Difference.I'll Just Leave It For The Time Being.
Gwoof

Horwood NL
Canada
Member #70,611
February 6, 2009
725 Posts
Offline

Aug 26, 2014, 9:32 pm

Quote: Originally posted by winsumloosesum on Aug 26, 2014
OK,

I made a few enhancements to both Excel files.

Delete what you currently have and re-download using the same links from the opening thread.

Same as below:

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

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

Just to let you know, I have downloaded the first set of excel files and your latest set of files and both work for me. Just waiting for next video.
winsumloosesum

Philadelpia/Pennsylvania
United States
Member #2,218
September 1, 2003
6,802 Posts
Offline

Aug 27, 2014, 3:23 am

Quote: Originally posted by winsumloosesum on Aug 26, 2014
OK,

I made a few enhancements to both Excel files.

Delete what you currently have and re-download using the same links from the opening thread.

Same as below:

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

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

I updated the P2StateDrawsVTRAC.xlsm with Tuesday's drawings and Step1.xlsm Excel files.

Use the same links in the reply.

I'll post a video 3 later today.
winsumloosesum

Philadelpia/Pennsylvania
United States
Member #2,218
September 1, 2003
6,802 Posts
Offline

Aug 28, 2014, 2:38 am

I updated the P2StateDrawsVTRAC.xlsm with Wednesday's drawings.

Step1.xlsm Excel file has also been updated.

Delete any previous version you have.

Use the same links.

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

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

I'll post a video 3 today.

New Topic New Poll

Subscribe to this topic

Pick 3 ALL States - VTRAC - Excel ProgramPrev TopicNext Topic

Pick 3 ALL States - VTRAC - Excel ProgramPrev Topic Next Topic