Continuation of my previous post on lottery math. I need help from my friends on LPPrev Topic Next Topic

Hungus

American
United States
Member #215,243
May 10, 2021
75 Posts
Offline

Jan 4, 2022, 8:05 am

data column A

3

0

4

5

6

7

5

2

3

4

5

6

9

8

1

2

Take all the data in column A plus or minus any number, for example, add 6, we will get the following result

data column A Result

3 9

0 6

4 0

5 1

6 2

7 3

5 1

2 8

3 9

4 0

5 1

6 6

9 5

8 4

1 7

2 8

And vice versa, if it is a minus sign for any number, for example 7, the result will be

data column A Result

3 6

0 3

4 7

5 8

6 9

7 0

5 8

2 5

3 6

4 7

5 8

6 9

9 2

8 1

1 4

2 5

I need an EXCEL formula that can be calculated once for such a result.

garyo1954

Texas
United States
Member #4,549
May 2, 2004
4,230 Posts
Offline

Jan 4, 2022, 1:19 pm

Quote: Originally posted by Hungus on Jan 4, 2022

data column A
3
0
4
5
6
7
5
2
3
4
5
6
9
8
1
2

Take all the data in column A plus or minus any number, for example, add 6, we will get the following result

data column A	Result
3	9
0	6
4	0
5	1
6	2
7	3
5	1
2	8
3	9
4	0
5	1
6	6
9	5
8	4
1	7
2	8

And vice versa, if it is a minus sign for any number, for example 7, the result will be

data column A	Result
3	6
0	3
4	7
5	8
6	9
7	0
5	8
2	5
3	6
4	7
5	8
6	9
9	2
8	1
1	4
2	5

I need an EXCEL formula that can be calculated once for such a result.

The formulas you need are:

=MOD((A1-0),10)

=MOD((A1+0),10)

You have the change the A1 and the parameters to whatever you need.
Subtracting 1 is the same as adding 9. Subtract 1 from 0, you get 9; Add 9 to 0, you get 9.

In this chart all you have to do is enter the last draw where the red numbers are and it calculates the next play using a =MOD() formula.
For example in the first column below the red 2 we have (pretend its block A1).......

=MOD((A1-0),10)
=MOD((A1-1),10)
=MOD((A1-2),10)


N1	N2	N3
2	6	1
2	6	0
2	6	9
1	6	0
1	6	9
1	5	1
1	5	9
1	4	0
1	4	9
0	6	9
0	5	1
0	5	0
0	5	9

Simple as that. You decide whether you want to add or subtract in each block.

G

I'm probably here unless I'm not.
Dreaming would be a perfectly useless function if it's only purpose was to entertain.

Speler

Belgium
Member #214,858
April 17, 2021
2,445 Posts
Offline

Jan 4, 2022, 3:37 pm

Yes, fine! Where is the mathematics to find the correct result of the future next drawing?
garyo1954

Texas
United States
Member #4,549
May 2, 2004
4,230 Posts
Offline

Jan 4, 2022, 3:45 pm

Quote: Originally posted by Speler on Jan 4, 2022
Yes, fine! Where is the mathematics to find the correct result of the future next drawing?

This is not the working worksheet I posted several years ago. In those you posted the last draw in the blocks where the RED numbers were and the sheet automatically did the calculations. This is a recreation of how it worked.

G

I'm probably here unless I'm not.
Dreaming would be a perfectly useless function if it's only purpose was to entertain.
garyo1954

Texas
United States
Member #4,549
May 2, 2004
4,230 Posts
Offline

Jan 4, 2022, 4:28 pm

Oh, if you're asking what the reasoning for this type play, (mostly box) draws never change more than 1 or 2 places, or a repeat.
Yes, there are exceptions but on the whole you can take a number from tonight's draw +/-1, or +/-2, and come up with a number from the next draw.

If you're looking at a 5, +1 gives you 6 and -1 gives you 4.
If you have three different numbers, +1/-1 and +/-2 give you 6 totally new numbers (that didn't hit the last draw).
With those odds you're bound to hit one or two, and sometime all three!

Okay, stupid idea. But it works (at times)!
Never works with triples.

And you never have to add or subtract more than 5.
Want to go -7? Add 3. Same thing.

G

I'm probably here unless I'm not.
Dreaming would be a perfectly useless function if it's only purpose was to entertain.
Speler

Belgium
Member #214,858
April 17, 2021
2,445 Posts
Offline

Jan 5, 2022, 8:16 am

That offset -1 to +1 can also do some prizemoney in jackpotgames like lotto or keno. There you avoid doubles, that is done by the filter.
Speler

Belgium
Member #214,858
April 17, 2021
2,445 Posts
Offline

Jan 5, 2022, 8:26 am

I had a look at the last drawings. There was a playable case.

2021-12-25 4 9 10 18 26 45
2021-12-29 4 10 11 18 19 23

3 4 5
8 9 10 11
17 18 19
25 26 27
44 45

Pick 6 full set, lightly filtered, to 3 if 5 condition.

3 4 19 26 27 45
3 5 17 19 26 44
3 8 9 10 19 44
3 11 18 25 44 45
4 5 9 11 18 27
4 8 10 17 25 27
5 8 9 10 17 45
8 11 18 19 25 26
10 18 25 26 27 44

A cheaper wheel.

3 8 18 19 25 27

3 10 11 17 26 45

4 5 9 17 26 44

4 8 10 19 44 45

5 9 10 11 18 27

Lucky line.
Speler

Belgium
Member #214,858
April 17, 2021
2,445 Posts
Offline

Jan 5, 2022, 11:31 am

A riddle for our Texan. Do 45+1 for the local lotto!

garyo1954

Texas
United States
Member #4,549
May 2, 2004
4,230 Posts
Offline

Jan 5, 2022, 12:28 pm

Using MOD(10) the 4 doesn't change unless you MOD(10) both positions.

Two different MOD(10) uses.....the one on the right uses the last two draws or a seed number............

0	4	5	0	4	5
1	6	2	3	5	4
9	6	8	3	9	1
9	2	2	7	9	9
1	6	8	7	9	1
9	6	2	3	9	9
9	2	8	7	9	1
1	2	8	7	9	9
1	2	2	3	9	9
			3	9	1

MOD(10) is only concerned with 0-9 in a single position. It doesn't carry to the next position.

G

I'm probably here unless I'm not.
Dreaming would be a perfectly useless function if it's only purpose was to entertain.

New Topic New Poll

Subscribe to this topic

Continuation of my previous post on lottery math. I need help from my friends on LPPrev TopicNext Topic

Continuation of my previous post on lottery math. I need help from my friends on LPPrev Topic Next Topic