Plain excel Pick-3 wheel and hit/skip statistics for few statesPrev Topic Next Topic

New Topic New Poll

Rakster

Saskatchewan
Canada
Member #19,991
August 9, 2005
2,960 Posts
Offline

Jun 11, 2017, 8:07 pm

Can you do WESTERN CANADA?

We are all Lucky... just some of us don't realize it!
thamizhpayan

United States
Member #173,010
February 13, 2016
1,629 Posts
Offline

Jun 13, 2017, 12:46 am

Quote: Originally posted by Rakster on Jun 11, 2017
Can you do WESTERN CANADA?

Here are the Pick-3 workbooks for Western Canada with draws updated till 06/12/2017 evening

https://drive.google.com/open?id=0B4Qt2_2g3zs5MnQ4TXJZdllWbm8

Good Luck
thamizhpayan

United States
Member #173,010
February 13, 2016
1,629 Posts
Offline

Jun 18, 2017, 12:32 pm

A new member asked for an excel sheet to create straight combos from straight pairs.

Here is a small utility to create combinations from pairs(FP,BP,SP). As usual it's a simple HTML/JS/CSS based utility. You just extract into a folder and open in your browser. You can also put in your web server folder if you serve apps/utilities in personal/hosted web servers.

https://drive.google.com/open?id=0B4Qt2_2g3zs5dWkzeUUwa2cyMTg

You enter pairs in at least two columns or all three as needed. Then click on "Get Combos" to get the list of pick-3 combos to play...

It maps pairs if they match straight e.g., if you have 18X = FP, X89= BP, 89X = SP

The tool will only give 189 i.e., you wont get other combinations which don't match straight(no box pair matches only straight).

even if you input pairs like this, the tool will still parse

12, 23
34,
45
56,,,
78,
90

56

67

If you find it useful and need some minor enhancements, let me know.

Thanks and Good Luck
thamizhpayan

United States
Member #173,010
February 13, 2016
1,629 Posts
Offline

Jul 1, 2017, 6:40 pm

Here are Pick 3 and Pick 4 statistics workbooks for IOWA(IA) updated with draws till 06/30/2017 Evening draw
LINK :
https://drive.google.com/open?id=0B4Qt2_2g3zs5MXcydzZUNUwxZTA

Please read through older posts in this thread to utilize it.

Good Luck
thamizhpayan

United States
Member #173,010
February 13, 2016
1,629 Posts
Offline

Jul 7, 2017, 10:09 am

Here are Indiana Pick-3/4 statistics sheets for reference :

Since Iowa uses Indiana draws, I feel it's better to track Indiana draws directly.

https://drive.google.com/open?id=0B4Qt2_2g3zs5dkYxYm9wRWZxT00

Important threads:
https://www.lotterypost.com/thread/311426/5024000
https://www.lotterypost.com/thread/311426/5024509

https://www.lotterypost.com/thread/311426/5060068
https://www.lotterypost.com/thread/311426/5088157
https://www.lotterypost.com/thread/311426/5129989

Good Luck
lakerben

50

New Mexico
United States
Member #86,096
January 29, 2010
24,863 Posts
Offline

Jul 7, 2017, 10:30 am

Very nice I'll give it a try.

I'm sitting here listening to Merle Haggard sipping some coffee!
MonEl

United States
Member #132,094
August 26, 2012
1,243 Posts
Offline

Jul 7, 2017, 11:45 am

thamizhpayan

Thanks very much for the straight pairs combination software, you make very nice software!

Hello!

You know how there are states that have 2, 3 and or 4 draws each day?

Well Tx has 4 draws a day Mon to Sat, that is 6 times a week.

Is there a way to combine TEXT LINES so if you have 4 SETS-COLUMNS of TEXT that they can be combined into 1 TEXT, that is 1 COLUMN of TEXT?

It can be ANY KIND of TEXT not just lottery draws.

The software would have 4 blank spaces or containers where a person would enter or paste the text, like container 1, 2, 3 and 4.

If a person only uses 1 and 2 then that is all the text that would be combined, if a person uses 3 then 3, if a person uses 4 then all 4 would be combined into 1 text file.

For example: A person can get the text from the Lottery Post here:

https://www.lotterypost.com/results?hasFlash=false

Column # 1 Morning pick 3 draws: This line would not be a part of the text.

Thu, Jul 6, 2017 9-1-5, Sum It Up: 15
Wed, Jul 5, 2017 7-3-0, Sum It Up: 10
Tue, Jul 4, 2017 7-3-2, Sum It Up: 12
Mon, Jul 3, 2017 1-1-3, Sum It Up: 5

Column # 2 Day pick 3 draws: This line is not really here.

Thu, Jul 6, 2017 1-3-7, Sum It Up: 11
Wed, Jul 5, 2017 3-2-3, Sum It Up: 8
Tue, Jul 4, 2017 0-0-0, Sum It Up: 0
Mon, Jul 3, 2017 9-0-9, Sum It Up: 18

Column # 3 Evening pick 3 draws: this line is not really here.

Thu, Jul 6, 2017 6-9-6, Sum It Up: 21
Wed, Jul 5, 2017 2-3-4, Sum It Up: 9
Tue, Jul 4, 2017 7-6-6, Sum It Up: 19
Mon, Jul 3, 2017 9-5-7, Sum It Up: 21

Column # 4 Night pick 3 draws: This line is not here.

Thu, Jul 6, 2017 4-8-7, Sum It Up: 19
Wed, Jul 5, 2017 1-1-9, Sum It Up: 11
Tue, Jul 4, 2017 7-9-2, Sum It Up: 18
Mon, Jul 3, 2017 0-9-3, Sum It Up: 12

And you would get something like this:

Mon, Jul 3, 2017 1-1-3, Sum It Up: 5
Mon, Jul 3, 2017 9-0-9, Sum It Up: 18
Mon, Jul 3, 2017 9-5-7, Sum It Up: 21
Mon, Jul 3, 2017 0-9-3, Sum It Up: 12
Tue, Jul 4, 2017 7-3-2, Sum It Up: 12
Tue, Jul 4, 2017 0-0-0, Sum It Up: 0
Tue, Jul 4, 2017 7-6-6, Sum It Up: 19
Tue, Jul 4, 2017 7-9-2, Sum It Up: 18
Wed, Jul 5, 2017 7-3-0, Sum It Up: 10
Wed, Jul 5, 2017 3-2-3, Sum It Up: 8
Wed, Jul 5, 2017 2-3-4, Sum It Up: 9
Wed, Jul 5, 2017 1-1-9, Sum It Up: 11
Thu, Jul 6, 2017 9-1-5, Sum It Up: 15
Thu, Jul 6, 2017 1-3-7, Sum It Up: 11
Thu, Jul 6, 2017 6-9-6, Sum It Up: 21
Thu, Jul 6, 2017 4-8-7, Sum It Up: 19

------------Or:

Mon, Jul 3, 2017 1-1-3, Sum It Up: 5
Mon, Jul 3, 2017 9-0-9, Sum It Up: 18
Mon, Jul 3, 2017 9-5-7, Sum It Up: 21
Mon, Jul 3, 2017 0-9-3, Sum It Up: 12
Tue, Jul 4, 2017 7-3-2, Sum It Up: 12
Tue, Jul 4, 2017 0-0-0, Sum It Up: 0
Tue, Jul 4, 2017 7-6-6, Sum It Up: 19
Tue, Jul 4, 2017 7-9-2, Sum It Up: 18
Wed, Jul 5, 2017 7-3-0, Sum It Up: 10
Wed, Jul 5, 2017 3-2-3, Sum It Up: 8
Wed, Jul 5, 2017 2-3-4, Sum It Up: 9
Wed, Jul 5, 2017 1-1-9, Sum It Up: 11
Thu, Jul 6, 2017 9-1-5, Sum It Up: 15
Thu, Jul 6, 2017 1-3-7, Sum It Up: 11
Thu, Jul 6, 2017 6-9-6, Sum It Up: 21
Thu, Jul 6, 2017 4-8-7, Sum It Up: 19

The 4 daily draws can be made up to being just one game and they really are, one game with 4 draws a day, long ago I saw that.

Christian Radio Bible ParishesOnline Daily Mass1 Daily Mass2 Notre Dame Mass Simon Jude

Mass Last Week's Mass Church Services I AM GONE, FOR A WHILE.

"Ten measures of beauty descended to the world, nine were taken by Jerusalem." Hava Nagila
thamizhpayan

United States
Member #173,010
February 13, 2016
1,629 Posts
Offline

Jul 7, 2017, 11:49 am

Quote: Originally posted by MonEl on Jul 7, 2017
thamizhpayan

Thanks very much for the straight pairs combination software, you make very nice software!

Hello!

You know how there are states that have 2, 3 and or 4 draws each day?

Well Tx has 4 draws a day Mon to Sat, that is 6 times a week.

Is there a way to combine TEXT LINES so if you have 4 SETS-COLUMNS of TEXT that they can be combined into 1 TEXT, that is 1 COLUMN of TEXT?

It can be ANY KIND of TEXT not just lottery draws.

The software would have 4 blank spaces or containers where a person would enter or paste the text, like container 1, 2, 3 and 4.

If a person only uses 1 and 2 then that is all the text that would be combined, if a person uses 3 then 3, if a person uses 4 then all 4 would be combined into 1 text file.

For example: A person can get the text from the Lottery Post here:

https://www.lotterypost.com/results?hasFlash=false

Column # 1 Morning pick 3 draws: This line would not be a part of the text.

Thu, Jul 6, 2017 9-1-5, Sum It Up: 15
Wed, Jul 5, 2017 7-3-0, Sum It Up: 10
Tue, Jul 4, 2017 7-3-2, Sum It Up: 12
Mon, Jul 3, 2017 1-1-3, Sum It Up: 5

Column # 2 Day pick 3 draws: This line is not really here.

Thu, Jul 6, 2017 1-3-7, Sum It Up: 11
Wed, Jul 5, 2017 3-2-3, Sum It Up: 8
Tue, Jul 4, 2017 0-0-0, Sum It Up: 0
Mon, Jul 3, 2017 9-0-9, Sum It Up: 18

Column # 3 Evening pick 3 draws: this line is not really here.

Thu, Jul 6, 2017 6-9-6, Sum It Up: 21
Wed, Jul 5, 2017 2-3-4, Sum It Up: 9
Tue, Jul 4, 2017 7-6-6, Sum It Up: 19
Mon, Jul 3, 2017 9-5-7, Sum It Up: 21

Column # 4 Night pick 3 draws: This line is not here.

Thu, Jul 6, 2017 4-8-7, Sum It Up: 19
Wed, Jul 5, 2017 1-1-9, Sum It Up: 11
Tue, Jul 4, 2017 7-9-2, Sum It Up: 18
Mon, Jul 3, 2017 0-9-3, Sum It Up: 12

And you would get something like this:

Mon, Jul 3, 2017 1-1-3, Sum It Up: 5
Mon, Jul 3, 2017 9-0-9, Sum It Up: 18
Mon, Jul 3, 2017 9-5-7, Sum It Up: 21
Mon, Jul 3, 2017 0-9-3, Sum It Up: 12
Tue, Jul 4, 2017 7-3-2, Sum It Up: 12
Tue, Jul 4, 2017 0-0-0, Sum It Up: 0
Tue, Jul 4, 2017 7-6-6, Sum It Up: 19
Tue, Jul 4, 2017 7-9-2, Sum It Up: 18
Wed, Jul 5, 2017 7-3-0, Sum It Up: 10
Wed, Jul 5, 2017 3-2-3, Sum It Up: 8
Wed, Jul 5, 2017 2-3-4, Sum It Up: 9
Wed, Jul 5, 2017 1-1-9, Sum It Up: 11
Thu, Jul 6, 2017 9-1-5, Sum It Up: 15
Thu, Jul 6, 2017 1-3-7, Sum It Up: 11
Thu, Jul 6, 2017 6-9-6, Sum It Up: 21
Thu, Jul 6, 2017 4-8-7, Sum It Up: 19

------------Or:

Mon, Jul 3, 2017 1-1-3, Sum It Up: 5
Mon, Jul 3, 2017 9-0-9, Sum It Up: 18
Mon, Jul 3, 2017 9-5-7, Sum It Up: 21
Mon, Jul 3, 2017 0-9-3, Sum It Up: 12
Tue, Jul 4, 2017 7-3-2, Sum It Up: 12
Tue, Jul 4, 2017 0-0-0, Sum It Up: 0
Tue, Jul 4, 2017 7-6-6, Sum It Up: 19
Tue, Jul 4, 2017 7-9-2, Sum It Up: 18
Wed, Jul 5, 2017 7-3-0, Sum It Up: 10
Wed, Jul 5, 2017 3-2-3, Sum It Up: 8
Wed, Jul 5, 2017 2-3-4, Sum It Up: 9
Wed, Jul 5, 2017 1-1-9, Sum It Up: 11
Thu, Jul 6, 2017 9-1-5, Sum It Up: 15
Thu, Jul 6, 2017 1-3-7, Sum It Up: 11
Thu, Jul 6, 2017 6-9-6, Sum It Up: 21
Thu, Jul 6, 2017 4-8-7, Sum It Up: 19

The 4 daily draws can be made up to being just one game and they really are, one game with 4 draws a day, long ago I saw that.

Hi MonEL,

Thank you

Yes we can. I will give you a small tool this weekend.

Good Luck
MonEl

United States
Member #132,094
August 26, 2012
1,243 Posts
Offline

Jul 7, 2017, 11:56 am

Quote: Originally posted by thamizhpayan on Jul 7, 2017
Hi MonEL,

Thank you

Yes we can. I will give you a small tool this weekend.

Good Luck

thamizhpayan

Thanks very very much!

Fernando.

I am getting back into the lottery thing again, after years of being away from it.

State lotteries, Beware!

All state games are the same, no matter, mechanical or RNG, none of them are safe, once long ago I predicted daily for many of them for some time, I saw that they were all exactly the same, no matter what, pre, post draws or not.

Christian Radio Bible ParishesOnline Daily Mass1 Daily Mass2 Notre Dame Mass Simon Jude

Mass Last Week's Mass Church Services I AM GONE, FOR A WHILE.

"Ten measures of beauty descended to the world, nine were taken by Jerusalem." Hava Nagila
lakerben

50

New Mexico
United States
Member #86,096
January 29, 2010
24,863 Posts
Offline

Jul 7, 2017, 1:46 pm

I downloaded it but I only get what I input no different combos.

I'm sitting here listening to Merle Haggard sipping some coffee!
thamizhpayan

United States
Member #173,010
February 13, 2016
1,629 Posts
Offline

Jul 7, 2017, 4:57 pm

Quote: Originally posted by lakerben on Jul 7, 2017
I downloaded it but I only get what I input no different combos.

Are you referring to the tool or the excel sheets with statistics?

Let me know
MonEl

United States
Member #132,094
August 26, 2012
1,243 Posts
Offline

Jul 7, 2017, 6:07 pm

Quote: Originally posted by lakerben on Jul 7, 2017
I downloaded it but I only get what I input no different combos.

If you are talking about the pairs tool, I get the same results as in the sample when I input exactly the same pairs as in the sample, try them:

Front Pairs:

12
23
34
45
56
78
90

Back Pairs:

21
31
45
67
32
90
51

Split Pairs:

11
23
12
55
66
76

---------

Input the pairs with Copy and Paste where they go on the software.

Copy and paste and then Lth Click with Mouse on "Get Combos"

Christian Radio Bible ParishesOnline Daily Mass1 Daily Mass2 Notre Dame Mass Simon Jude

Mass Last Week's Mass Church Services I AM GONE, FOR A WHILE.

"Ten measures of beauty descended to the world, nine were taken by Jerusalem." Hava Nagila
lakerben

50

New Mexico
United States
Member #86,096
January 29, 2010
24,863 Posts
Offline

Jul 7, 2017, 6:21 pm

Quote: Originally posted by MonEl on Jul 7, 2017
If you are talking about the pairs tool, I get the same results as in the sample when I input exactly the same pairs as in the sample, try them:

Front Pairs:

12
23
34
45
56
78
90

Back Pairs:

21
31
45
67
32
90
51

Split Pairs:

11
23
12
55
66
76

---------

Input the pairs with Copy and Paste where they go on the software.

Copy and paste and then Lth Click with Mouse on "Get Combos"

I'll try it gain later. Its essentially a wheel correct?

I'm sitting here listening to Merle Haggard sipping some coffee!
MonEl

United States
Member #132,094
August 26, 2012
1,243 Posts
Offline

Jul 7, 2017, 6:28 pm

Quote: Originally posted by lakerben on Jul 7, 2017
I'll try it gain later. Its essentially a wheel correct?

Well, Yes!

But only "complementary" pairs can be wheeled, complementary pairs are pairs that have digits in common, for example:

37 70 = 370

---------

By the way I was wondering about thamizhpayan's software and I found this:

I don't know anything about that, but maybe somebody younger than me would like to read it.

https://www.w3schools.com/js/js_intro.asp

https://www.w3schools.com/html/default.asp

https://www.w3schools.com/css/default.asp

https://www.w3schools.com/js/default.asp

----------------------------------------------------------------

Top 10 Tutorials
HTML Tutorial
CSS Tutorial
JavaScript Tutorial
W3.CSS Tutorial
Bootstrap Tutorial
SQL Tutorial
PHP Tutorial
jQuery Tutorial
Angular Tutorial
XML Tutorial

Top 10 References
HTML Reference
CSS Reference
JavaScript Reference
W3.CSS Reference
Browser Statistics
PHP Reference
HTML Colors
HTML Character Sets
jQuery Reference
AngularJS Reference

Top 10 Examples
HTML Examples
CSS Examples
JavaScript Examples
W3.CSS Examples
HTML DOM Examples
PHP Examples
ASP Examples
jQuery Examples
Angular Examples
XML Examples

Web Certificates
HTML Certificate
CSS Certificate
JavaScript Certificate
jQuery Certificate
PHP Certificate
Bootstrap Certificate
XML Certificate

Christian Radio Bible ParishesOnline Daily Mass1 Daily Mass2 Notre Dame Mass Simon Jude

Mass Last Week's Mass Church Services I AM GONE, FOR A WHILE.

"Ten measures of beauty descended to the world, nine were taken by Jerusalem." Hava Nagila
lakerben

50

New Mexico
United States
Member #86,096
January 29, 2010
24,863 Posts
Offline

Jul 7, 2017, 9:42 pm

Quote: Originally posted by MonEl on Jul 7, 2017
Well, Yes!

But only "complementary" pairs can be wheeled, complementary pairs are pairs that have digits in common, for example:

37 70 = 370

---------

By the way I was wondering about thamizhpayan's software and I found this:

I don't know anything about that, but maybe somebody younger than me would like to read it.

https://www.w3schools.com/js/js_intro.asp

https://www.w3schools.com/html/default.asp

https://www.w3schools.com/css/default.asp

https://www.w3schools.com/js/default.asp

----------------------------------------------------------------

Top 10 Tutorials
HTML Tutorial
CSS Tutorial
JavaScript Tutorial
W3.CSS Tutorial
Bootstrap Tutorial
SQL Tutorial
PHP Tutorial
jQuery Tutorial
Angular Tutorial
XML Tutorial

Top 10 References
HTML Reference
CSS Reference
JavaScript Reference
W3.CSS Reference
Browser Statistics
PHP Reference
HTML Colors
HTML Character Sets
jQuery Reference
AngularJS Reference

Top 10 Examples
HTML Examples
CSS Examples
JavaScript Examples
W3.CSS Examples
HTML DOM Examples
PHP Examples
ASP Examples
jQuery Examples
Angular Examples
XML Examples

Web Certificates
HTML Certificate
CSS Certificate
JavaScript Certificate
jQuery Certificate
PHP Certificate
Bootstrap Certificate
XML Certificate

Fp

12

72

44

BP

33

55

66

Sp

29

27

41

Shouldn't the results be:

123

726

441

447

Etc..

I'm sitting here listening to Merle Haggard sipping some coffee!

New Topic New Poll

Subscribe to this topic

Plain excel Pick-3 wheel and hit/skip statistics for few statesPrev TopicNext Topic

Plain excel Pick-3 wheel and hit/skip statistics for few statesPrev Topic Next Topic