Clarity Pick3 (Testing State Florida)Prev Topic Next Topic

New Topic New Poll

Ricklou

South Africa
Member #129,816
June 28, 2012
1,704 Posts
Offline

Feb 11, 2017, 3:35 pm

A good test for my software on Florida state 's Pick3

I will need Florida's data in the folowing format saved in a .txt file. Need about 200 Draws data should be good.

12/04/16 2 6 2
12/05/16 5 3 1
12/06/16 8 4 8
12/07/16 8 8 0
12/08/16 4 5 7
12/09/16 2 0 5
12/12/16 3 5 2
12/11/16 7 0 3
12/12/16 5 2 2
12/13/16 4 6 0
12/14/16 9 1 7
12/15/16 8 8 5
12/16/16 8 8 9
12/17/16 6 3 5
12/18/16 7 3 6

To get the data splitted I would recommend using Excel to split the data in 3 columns.For this test I will only do the Evenings draw.....as per Amber. So Florida people kindly email me the data and I will run live tests on Floridas data.

You may use the following Vba code to split the pick3 numbers in 3 columns. You will need to have Excel for this

Ricklou

Sub split_Amber()
Dim rng As Range, c As Range
Dim x As Integer, y As Integer

Set rng = ThisWorkbook.Sheets(1).Range("A:A")

x = 2
For Each c In rng
For y = 1 To Len(c.Value)
rng(c.Row, x) = Mid(c.Value, y, 1)
x = x + 1
Next y
x = 2
Next c

End Sub

Instructions

Open excel

Make sure you work on Sheet1 otherwise change code to refect the sheet/or name of the sheet

copy Floridas data in Column A (the numbers only you want to split example 452)

Press alt F11

Click on this thisworkbook then right click insert module

Copy and paste the code above in it

Go back to workbook (top left) click excel green icon

You will be back in workbook

Alt F8

Click on split_Amber

Run

Congratulations you have just split a Number string in Vba

Your pick 3 data will be split in 3 columns in Column B C D.......Now you can copy that to notepad in the format I gave u

Do the unthinkable, impossible don't exist
Sunglasses

Belgium
Member #173,925
March 26, 2016
1,396 Posts
Offline

Feb 11, 2017, 6:18 pm

use mid() instead
amber123

United States
Member #164,719
March 12, 2015
3,506 Posts
Offline

Feb 11, 2017, 9:53 pm

Thanks, I got it in the Excel in the email, but have no clue what to do. Also, a message came up saying this is macros so some functionality will not work.
winsumloosesum

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

Feb 11, 2017, 10:42 pm

Quote: Originally posted by Ricklou on Feb 11, 2017
A good test for my software on Florida state 's Pick3

I will need Florida's data in the folowing format saved in a .txt file. Need about 200 Draws data should be good.

12/04/16 2 6 2
12/05/16 5 3 1
12/06/16 8 4 8
12/07/16 8 8 0
12/08/16 4 5 7
12/09/16 2 0 5
12/12/16 3 5 2
12/11/16 7 0 3
12/12/16 5 2 2
12/13/16 4 6 0
12/14/16 9 1 7
12/15/16 8 8 5
12/16/16 8 8 9
12/17/16 6 3 5
12/18/16 7 3 6

To get the data splitted I would recommend using Excel to split the data in 3 columns.For this test I will only do the Evenings draw.....as per Amber. So Florida people kindly email me the data and I will run live tests on Floridas data.

You may use the following Vba code to split the pick3 numbers in 3 columns. You will need to have Excel for this

Ricklou

Sub split_Amber()
Dim rng As Range, c As Range
Dim x As Integer, y As Integer

Set rng = ThisWorkbook.Sheets(1).Range("A:A")

x = 2
For Each c In rng
For y = 1 To Len(c.Value)
rng(c.Row, x) = Mid(c.Value, y, 1)
x = x + 1
Next y
x = 2
Next c

End Sub

Instructions

Open excel

Make sure you work on Sheet1 otherwise change code to refect the sheet/or name of the sheet

copy Floridas data in Column A (the numbers only you want to split example 452)

Press alt F11

Click on this thisworkbook then right click insert module

Copy and paste the code above in it

Go back to workbook (top left) click excel green icon

You will be back in workbook

Alt F8

Click on split_Amber

Run

Congratulations you have just split a Number string in Vba

Your pick 3 data will be split in 3 columns in Column B C D.......Now you can copy that to notepad in the format I gave u

Florida Combined Draws:

https://my.pcloud.com/publink/show?code=XZkOGlZm9ImAG4jdiu03KJpI4FhvXS6blF7

Text File:

https://my.pcloud.com/publink/show?code=XZsOGlZHN7UH90OCHuyO8FGBpeB7b3mknXk
amber123

United States
Member #164,719
March 12, 2015
3,506 Posts
Offline

Feb 11, 2017, 11:59 pm

Quote: Originally posted by winsumloosesum on Feb 11, 2017
Florida Combined Draws:

https://my.pcloud.com/publink/show?code=XZkOGlZm9ImAG4jdiu03KJpI4FhvXS6blF7

Text File:

https://my.pcloud.com/publink/show?code=XZsOGlZHN7UH90OCHuyO8FGBpeB7b3mknXk

You are awesome. Let me know where to make the donation.
amber123

United States
Member #164,719
March 12, 2015
3,506 Posts
Offline

Feb 12, 2017, 12:04 am

Quote: Originally posted by amber123 on Feb 11, 2017
You are awesome. Let me know where to make the donation.

I have a problem Houston...lol

When I copy and pasta, it's format changes to a paragraph and not a list.
Coffo

United States
Member #139,487
February 24, 2013
71 Posts
Offline

Feb 12, 2017, 12:43 am

y0u only need 4/5 day pair and 8/9 day pairs
Ricklou

South Africa
Member #129,816
June 28, 2012
1,704 Posts
Offline

Feb 12, 2017, 3:22 am

Quote: Originally posted by winsumloosesum on Feb 11, 2017
Florida Combined Draws:

https://my.pcloud.com/publink/show?code=XZkOGlZm9ImAG4jdiu03KJpI4FhvXS6blF7

Text File:

https://my.pcloud.com/publink/show?code=XZsOGlZHN7UH90OCHuyO8FGBpeB7b3mknXk

Winsome thank you very much for the data but I am afraid I only need the Evenings data. Unfortunately I cannot use a combined draws data as every line gets checked by the software and it will give inaccurate numbers so it must be ONLY evening data. I will look into the facility to incorporate multiple draws as currently only 1 draw is supported by the software. There is one thing pick3 players(majority not all) dont fully understand which draws are calling which possible numbers...this is exactly what will throw out the data you supplied thats combined......so all evening data should be together as that will have a huge impact what numbers will come out. I will explain more when I get the correct single Evening Draw. For the purposes of this test I will only do the evening Draw.

Thanks

Do the unthinkable, impossible don't exist
Ricklou

South Africa
Member #129,816
June 28, 2012
1,704 Posts
Offline

Feb 12, 2017, 3:42 am

I hope screaming Midget can post the same post he posted in the Pyramid thread......I want to check something as my software will also work out the skips....I got a feeling could be wrong my data will look different.So Screamingmidget please post that same post here if you dont mind -thank you

Do the unthinkable, impossible don't exist
Ricklou

South Africa
Member #129,816
June 28, 2012
1,704 Posts
Offline

Feb 12, 2017, 4:28 am

Quote: Originally posted by amber123 on Feb 11, 2017
Thanks, I got it in the Excel in the email, but have no clue what to do. Also, a message came up saying this is macros so some functionality will not work.

Amber I am sure you will need Excel for it to work it wont work in other programs so yip sorry

Do the unthinkable, impossible don't exist
winsumloosesum

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

Feb 12, 2017, 8:17 am

I created a new Excel file for the Florida Pick 3 games.

The Excel file you can update the Midday, Evening, and Combined draws.

You can select how many past draws to use. (The limit is around 400 or so for the Midday and Evening draws and twice as many for the Combined draws)

I have the total draws at 200.

Oldest draw at the top. Most current draw at the bottom.

Here is the link to the Excel file:

https://my.pcloud.com/publink/show?code=XZkvvlZIzKYED3RKFY7XlQTNRoRBF7zlrgy

Text Files:

Midday: FL3D.txt

https://my.pcloud.com/publink/show?code=XZ5vvlZ0lFxrvWksy8mohrhaBL7cHWyWMF7

Evening: FL3E.txt

https://my.pcloud.com/publink/show?code=XZHvvlZ0SfocunlCBzad6UcWurOszAMSn1X

Combined: FL3C.txt

https://my.pcloud.com/publink/show?code=XZLvvlZVFD3m6o0OcRiMVxom42XgVOzzcDy

Note: The Combined draws uses bogus dates since you mentioned that you can not use duplicate draw dates.

Instructions:

1>Create a new folder on your computer and name it "FLPick3Draws" (without the quotes)

My computer drive designation letter is "C"

2>Open the Excel file from the download link above: "FloridaPick3Draws.xlsm".

Note: You may be prompted to enable macros. You may need to adjust the security levels in your version of Excel to allow the macros to run properly.

3>There are 5 tabs at the bottom. Just use the 1st 4 tabs.

FL3D - Contains the Florida Pick 3 Midday Draws

FL3E - Contains the Florida Pick 3 Evening Draws

FL3C - Contains the Florida Pick 3 Combined Draws

CopyDraws - Creates a text (.txt) file for each of the Florida Pick 3 games

Click the tab at the bottom labeled "FL3D" (Florida Pick 3 Midday Draws)

To add a new drawing click the Toolbar labeled "Add New Drawing". This will add a new entry on line 20. Just enter the Pick 3 drawing in cell H20.

To delete the last drawing click the Toolbar labeled "Delete Last Drawing". This will delete the last drawing from line 20.

All drawings are on line 20.

The tabs at the bottom FL3E and FL3C use the same instructions for adding and deleting draw(s)

4> Click the tab at the bottom labeled "CopyDraws".

Go to cell B18 and select the drive letter for your computer. My drive letter is "C". If you drive letter is "C" do not change cell B18. If your drive is other than "C", click cell B18, to the right you should see a drop-down arrow, click the arrow and select the drive letter for your computer.

You should have created a new folder on your hard drive and named it "FLPick3Draws"

a>Click cell B5. Select the game you want to use. FloridaPick3Midday, FloridaPick3Evening, FloridaPick3Combined. I selected "FloridaPick3Midday" game. Click the drop-down arrow and select the Florida Pick 3 game.

b>Cell B11 indicates the total number of draws in the game selected in cell B5. Currently for the total draws for the Midday game is 408. I do not have the entire draw histories for each game. Midday & Evening.

c>Cell E1 and E2 you enter the total draws for creating the text (.txt) file. I currently have cell E1 set to 1 and cell E2 set to 200. So by entering these 2 values we will be creating a text (.txt) file with 200 draws for the Florida Midday Pick 3 Game.

d>To create the text file click Toolbar located in cell range B2:B4 labeled "Click to Create Text File".

Clicking the Toolbar will create the text file "FL3D.txt" and place it in the folder C:\FLPick3Draws\. The name of the text file is located in cell B8

Open the folder FLPick3Draws and you should see the new text file FL3D.txt

Let me know if the formatting is correct.

As I mentioned above the Combined Pick 3 draws uses bogus dates and do not contain duplicate dates.

Post any questions, corrections, etc.

Thanks
Ricklou

South Africa
Member #129,816
June 28, 2012
1,704 Posts
Offline

Feb 12, 2017, 9:42 am

Quote: Originally posted by winsumloosesum on Feb 12, 2017
I created a new Excel file for the Florida Pick 3 games.

The Excel file you can update the Midday, Evening, and Combined draws.

You can select how many past draws to use. (The limit is around 400 or so for the Midday and Evening draws and twice as many for the Combined draws)

I have the total draws at 200.

Oldest draw at the top. Most current draw at the bottom.

Here is the link to the Excel file:

https://my.pcloud.com/publink/show?code=XZkvvlZIzKYED3RKFY7XlQTNRoRBF7zlrgy

Text Files:

Midday: FL3D.txt

https://my.pcloud.com/publink/show?code=XZ5vvlZ0lFxrvWksy8mohrhaBL7cHWyWMF7

Evening: FL3E.txt

https://my.pcloud.com/publink/show?code=XZHvvlZ0SfocunlCBzad6UcWurOszAMSn1X

Combined: FL3C.txt

https://my.pcloud.com/publink/show?code=XZLvvlZVFD3m6o0OcRiMVxom42XgVOzzcDy

Note: The Combined draws uses bogus dates since you mentioned that you can not use duplicate draw dates.

Instructions:

1>Create a new folder on your computer and name it "FLPick3Draws" (without the quotes)

My computer drive designation letter is "C"

2>Open the Excel file from the download link above: "FloridaPick3Draws.xlsm".

Note: You may be prompted to enable macros. You may need to adjust the security levels in your version of Excel to allow the macros to run properly.

3>There are 5 tabs at the bottom. Just use the 1st 4 tabs.

FL3D - Contains the Florida Pick 3 Midday Draws

FL3E - Contains the Florida Pick 3 Evening Draws

FL3C - Contains the Florida Pick 3 Combined Draws

CopyDraws - Creates a text (.txt) file for each of the Florida Pick 3 games

Click the tab at the bottom labeled "FL3D" (Florida Pick 3 Midday Draws)

To add a new drawing click the Toolbar labeled "Add New Drawing". This will add a new entry on line 20. Just enter the Pick 3 drawing in cell H20.

To delete the last drawing click the Toolbar labeled "Delete Last Drawing". This will delete the last drawing from line 20.

All drawings are on line 20.

The tabs at the bottom FL3E and FL3C use the same instructions for adding and deleting draw(s)

4> Click the tab at the bottom labeled "CopyDraws".

Go to cell B18 and select the drive letter for your computer. My drive letter is "C". If you drive letter is "C" do not change cell B18. If your drive is other than "C", click cell B18, to the right you should see a drop-down arrow, click the arrow and select the drive letter for your computer.

You should have created a new folder on your hard drive and named it "FLPick3Draws"

a>Click cell B5. Select the game you want to use. FloridaPick3Midday, FloridaPick3Evening, FloridaPick3Combined. I selected "FloridaPick3Midday" game. Click the drop-down arrow and select the Florida Pick 3 game.

b>Cell B11 indicates the total number of draws in the game selected in cell B5. Currently for the total draws for the Midday game is 408. I do not have the entire draw histories for each game. Midday & Evening.

c>Cell E1 and E2 you enter the total draws for creating the text (.txt) file. I currently have cell E1 set to 1 and cell E2 set to 200. So by entering these 2 values we will be creating a text (.txt) file with 200 draws for the Florida Midday Pick 3 Game.

d>To create the text file click Toolbar located in cell range B2:B4 labeled "Click to Create Text File".

Clicking the Toolbar will create the text file "FL3D.txt" and place it in the folder C:\FLPick3Draws\. The name of the text file is located in cell B8

Open the folder FLPick3Draws and you should see the new text file FL3D.txt

Let me know if the formatting is correct.

As I mentioned above the Combined Pick 3 draws uses bogus dates and do not contain duplicate dates.

Post any questions, corrections, etc.

Thanks

Awesome I am now sorted 100% Winsome thank you for all your help. I will now set this up and report back to you and fellow people of Florida. This is for the Evening Draw only

Regards

Ricklou

Do the unthinkable, impossible don't exist
Ricklou

South Africa
Member #129,816
June 28, 2012
1,704 Posts
Offline

Feb 12, 2017, 9:52 am

ScreamingMidget did not post here yet...Winsome can you perhaps tell what does Floridas skips look like if you have that perhaps.....This is South-Africa's Pick3 skips just to show you.Just showing you an example.The software will work this out for me it would be only interesting to see if the skips will be the same....possible it will be...we will see in a while though

Numbers Skips

1 10

2 3

3 1

4 0

5 6

6 1

7 0

8 1

9 2

0 3

Do the unthinkable, impossible don't exist
Ricklou

South Africa
Member #129,816
June 28, 2012
1,704 Posts
Offline

Feb 12, 2017, 10:26 am

Having problems uploading photos onto this website....copy and paste quickly

Floridas skips Evening

Numbers Skips

1 1

2 0

3 6

4 0

5 4

6 3

7 7

8 0

9 1

0 3

Now lets get technical the 3 highest skips 6 4 7 =17.....Playing over 17 your a loser as the highest skips are 17. You will be throwing money into the water

Go compare that to Loftsoftpro's Data

Do the unthinkable, impossible don't exist
winsumloosesum

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

Feb 12, 2017, 10:28 am

Quote: Originally posted by Ricklou on Feb 12, 2017
Having problems uploading photos onto this website....copy and paste quickly

Floridas skips Evening

Numbers Skips

1 1

2 0

3 6

4 0

5 4

6 3

7 7

8 0

9 1

0 3

Now lets get technical the 3 highest skips 6 4 7 =17.....Playing over 17 your a loser as the highest skips are 17. You will be throwing money into the water

Go compare that to Loftsoftpro's Data

Added skips chart to the CopyDraw tab

https://my.pcloud.com/publink/show?code=XZkvvlZIzKYED3RKFY7XlQTNRoRBF7zlrgy

New Topic New Poll

Subscribe to this topic

Clarity Pick3 (Testing State Florida)Prev TopicNext Topic

Clarity Pick3 (Testing State Florida)Prev Topic Next Topic