Help needed, calculations on Mirror and Flipping

Reply #36

Frl88p — Wed, 07 May 2025 19:29:41 GMT

Hi everyone, sorry for the extremely late reply. I wasnt well, but Im recovering.Firstly, thank you all so much who have contributed and are contributing towards the understanding of this mechanism. I from my part have certainly been able to understand the ways better and it is helping me get there, to the promise land where I can understand how the calculations work. Off late, I have been experimenting with working with 2 digits alone while using the numbers 8 and 9 as stand alone numbers in th... [ More ]

Reply #35

tokecap — Fri, 02 May 2025 20:04:12 GMT

Another way

Example Base Number: 347

We ll use the Flip1 column to generate additive values (you could use Mirror, Carry, or Flip2 too but let s pick Flip1 for this example).

Step 1: Look up Flip1 for each digit

Digit Flip1

3 6

4 7

7 0

Step 2: Add original + Flip1 (mod 10 if needed)

Digit Flip1 Add (Digit + Flip1) Result (mod 10)

3 6 3 + 6 = 9 9

4 7 4 + 7 = 11 1

7 0 7 + 0 = 7 7

Final Result: 917

So:

Original: 347

Reply #34

hypersoniq — Fri, 02 May 2025 12:04:41 GMT

The Thompson chart is a good example of a static replacement chart. It can be directly implemented as written with Excel XLookup.

A thorough back test of a static replacement chart will show it's limitations. Static is the keyword... when you use a static replacement strategy, the number you are swapping for still only has a ten percent chance of appearing. You are ending with the same 10,000 to 1 odds you started with (for a Pick 4). Not that it can't match, just that it happens too infrequ... [ More ]

Reply #33

dr san — Fri, 02 May 2025 09:38:37 GMT

hello=

Okay, the user is asking about the best tables and graphs for Pick 3 and Pick 4 lotteries. Let me start by recalling what these games are. Pick 3 and Pick 4 are lottery games where players choose three or four digits, and there are various ways to win based on matching the drawn numbers in order or in combination.

First, I need to think about what kind of data analysis would be useful here. Since these are number-based games, frequency analysis is probably important. Players

Reply #32

ERRP — Fri, 02 May 2025 05:10:28 GMT

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

6 7 8 9 0 1 2 3 4 5

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

4 5 6 7 8 9 0 1 2 3

Reply #31

grwurston — Fri, 02 May 2025 01:10:00 GMT

Good Question.

Reply #30

winsumloosesum — Fri, 02 May 2025 00:37:36 GMT

Why do we make things so complicated for such a simple game

Reply #29

dr san — Thu, 01 May 2025 20:12:01 GMT

Step by Step to Cross the Tables

Definition of Structures

Thomson Chart (Hexagon):

Organize the numbers from 0 to 9 in a hexagon, connecting opposite points and creating intersections that generate pairs or combinations. Example:

0

1 9

2 8

3 7

4

5 6

*Lines connect 0-6,1-7,2-8,3-9,4-0, etc.*

Tic Tac Toe Table (3x3):

Use a magic square adapted for numbers 0-8 (ignoring the 9 or including it in the center):

4 9 2

3 5 7

8 1 6

Rows, columns and diag... [ More ]

Reply #28

dr san — Thu, 01 May 2025 20:07:48 GMT

hello winsum=

Okay, the user wants to combine the Thomson graph table with the Tic Tac Toe grid in the context of Pick4. Let me start by recalling what each of these elements is.

First, the Thomson graph, or Thomsen's theorem, is a method in projective geometry that uses a hexagonal graph to connect points, creating intersections that can represent numbers. It's often used in lottery systems like Pick3 or Pick4 to map numbers onto geometric patterns. The Tic Tac Toe grid is a 3x3 gr... [ More ]

Reply #27

dr san — Wed, 30 Apr 2025 21:22:15 GMT

hello frl88p and winsum= ex=

Advanced Spreadsheet for Frequency Analysis in Thomson Chart (Pick-4)

Objective: Track the frequency of each digit (0-9) in each position (D1, D2, D3, D4) over time, with analysis in blocks of 10, 20, 30... draws.

1. Spreadsheet Structure (Tabs)

Tab Name Content

Draws Historical record of all draws (order, date, digits).

Frequencies Absolute and relative frequency tables (%) by position.

Ranges Frequency analysis in intervals (last 10, 20, 30..... [ More ]

Reply #26

dr san — Wed, 30 Apr 2025 21:08:27 GMT

hello win sum , there is no spreadsheet or program, we have to create it, that is, the program or spreadsheet does not exist, I will see some directives to create the spreadsheet in excel

Reply #25

dr san — Wed, 30 Apr 2025 15:26:00 GMT

hello I tried to put the macro, the forum page doesn't accept it, but winsum, the I.A

can find a way

Reply #24

dr san — Wed, 30 Apr 2025 15:22:36 GMT

vba

Copy

Download

Option ExplicitSub ThomsonPick4Analysis() Dim ws As Worksheet Dim lastDraw As Long Dim numDraws As Long Dim i As Long, j As Long, k As Long Dim dataRange As Range Dim rawData() As Variant Dim frequencyArray(1 To 4, 0 To 9) As Long Dim chartObj As ChartObject Dim cht As Chart Dim ser As Series Dim position As Integer, number As Integer ' Create new worksheet for results Set ws = Worksheets.Add ws.Name = ThomsonPick4_ Format(Now, ddmmyy_hhmmss ) ' Get user input lastD... [ More ]

Reply #23

dr san — Wed, 30 Apr 2025 15:19:08 GMT

hello ok! winsum

Exemplo de Macro para Excel (VBA)

vba

Copy

Download

Option ExplicitSub ThomsonPick4() Dim ws As Worksheet Dim ultimoSorteio As Long Dim qtdeSorteios As Long Dim i As Long, j As Long, k As Long Dim rngDados As Range Dim arrDados() As Variant Dim arrFrequencias(1 To 4, 0 To 9) As Long Dim chartObj As ChartObject Dim cht As Chart Dim ser As Series Dim pos As Integer, num As Integer ' Cria uma nova planilha para os resultados Set ws = Worksheets.Add ws.Name = T... [ More ]

Reply #22

winsumloosesum — Wed, 30 Apr 2025 12:26:59 GMT

Dr San can you post an example and program on what your suggesting

Reply #21

dr san — Wed, 30 Apr 2025 09:08:05 GMT

the macro must be made to use a reference, such as the last draw and also how many draws to be used to calculate the frequency in each position = ex = 20 draws or 30 or 100 etc.

Reply #20

dr san — Wed, 30 Apr 2025 08:58:25 GMT

hello=

you need a database of lottery records, to calculate the frequency graph, you will need to connect to a real source of historical results

Lotteries are fundamentally random - historical patterns do not guarantee future results

The Thompson chart is just one analysis tool among many

You can expand this macro by adding more features such as pair analysis, specific position analysis, or integration with real results APIs.

Reply #19

winsumloosesum — Wed, 30 Apr 2025 01:44:46 GMT

https://u.pcloud.link/publink/show?code=XZsAkb5ZMABCOI96jVpoEkUe2NPt3Ly8XWfy

1 Enter a Pick 4 Set in cell D10

2 Mirror calculations for positions 1 through 4 in cell D13.

3 Carry calculations for positions 1 through 4 in cell D16.

4 Flip 1 calculations for positions 1 through 4 in cell D19.

5 Flip2 calculations for positions 1 through 4 in cell D22.

6 You can create a Custom pick 4 set by adjusting the cells F24, H24, J24, L24 to any variation of M, C, F1, or F2

Cust... [ More ]

Reply #18

tokecap — Tue, 29 Apr 2025 22:48:03 GMT

Thompson Chart exe.file

Reply #17

ethanl — Tue, 29 Apr 2025 21:00:36 GMT

sure can crate an exe if you like, or if you have your own programing code i can convert it for you

Reply #16

tokecap — Tue, 29 Apr 2025 16:01:46 GMT

Please

Could you generate a exe fil .

Thanks

Reply #15

Frl88p — Tue, 29 Apr 2025 15:28:56 GMT

Thank you so much Ethan, this does shed some light on what Im looking for, though theres stills some unanswered questions, but nevertheless, thank you so much, I appreciate the thought and work you put in to help me!!

Im still working on the right formula for this grid, I havent fully found one yet, but I sure hope, with everyones help,I can.

Reply #14

ethanl — Tue, 29 Apr 2025 14:21:56 GMT

so to brake down the Thompson Chart uses fixed digit transformations based on mapping rules . Each rule is designed to shift or mirror digits to create alternative sets of numbers

Here are the most frequently used transformation modes in the Thompson Chart :

Digit Mirror Carry Flip1 Flip2

0 5 4 3 7

1 6 5 4 8

2 7 6 5 9

3 8 7 6 0

4 9 8 7 1

5 0 9 8 2

6 1 0 9 3

7 2 1 0 4

8 3 2 1 5

9 4 3 2 6

What the columns mean:

Mirror

Reply #13

Frl88p — Tue, 29 Apr 2025 13:31:56 GMT

In terms of the colours, I havent found any. So far I noticed only this, the odds and evens issues, and what I believe is the need for mirror numbers conversion.

Also what I found out is, the chart also works well slightly when you place a pick 4 sum into the app.

Even that, the sums part, im looking to find out how does this work. From your point of view, shall I go with (use) ths 4d-2222+6666 method or are there anything else which I can use

Reply #12

hypersoniq — Tue, 29 Apr 2025 12:54:17 GMT

The second grid you posted, with 3 5 7 9 in the middle, has the easiest solution.

The top number given is 1 3 5 7, which is 3 5 7 9 - 2 2 2 2

The bottom number given is 9 1 3 5, which (when wrapping around is considered) is 3 5 7 9 + 6 6 6 6

That addition and subtraction of even numbers explains why you will only get odd numbers when starting with an odd number. The same would work for starting with even numbers and ending up with all evens.

The problem? The other posted grids do... [ More ]

Reply #11

Frl88p — Tue, 29 Apr 2025 04:36:38 GMT

You are right, its not the Thomson Chart that I need to look into for, for answers. Heres what I do know from my research,

Firstly, what I am searching for is a method of calculation that can answer why the numbers come out the way they do for the top and bottom based on the base number that is placed in the middle.

The problem is when I key in the number, it only produces most numbers based on the base middle number, like if the base has more odd numbers, then ill only get odd numbers abo... [ More ]

Reply #10

hypersoniq — Mon, 28 Apr 2025 00:17:05 GMT

Let's get a better understanding of what you are looking for first. The samples provided do not match up with the Thompson chart.

You also have to account for lottery math , because if you +4 a 9 for example, that is 13, but in lottery numbers it is 3. Same goes for a -4 on a 1... 1-4 = -3, but you are looking for a 7.

I am confident in being able to put it in spreadsheet form, but I need to understand what you are trying to get to with the examples.

Reply #9

Frl88p — Sun, 27 Apr 2025 10:54:00 GMT

Could you demonstrate for me please

Reply #8

hypersoniq — Sun, 27 Apr 2025 10:37:35 GMT

You could implement that Thomson chart as an Xlookup in Excel. Just differentiate the 2 flip columns... maybe as flip_down and flip_up.

The carry is obviously mirror - 1

The first flip column is mirror - 2

The second flip column is mirror + 2

Reply #7

Frl88p — Sun, 27 Apr 2025 06:11:35 GMT

Hi, can you help me please

Reply #6

Frl88p — Thu, 24 Apr 2025 12:44:34 GMT

Im trying to base it out of this chart, but Im hoping someone could help me figure how to use this too,

Reply #5

Frl88p — Thu, 24 Apr 2025 12:40:29 GMT

Sorry, Im supposed to have said, the starting value is from the middle number, from the middle, it goes to the top and bottom. What I need to know is, the formula to flip or to get the top and bottom row numbers. Im guessing its by flipping them, and Im sure theres a calculation method for it, thats what im trying to figure out. Im trying some rundowns, but its not accurate, I am trying some +4, its also not working. Can you help me find out how to do this please

Reply #4

winsumloosesum — Thu, 24 Apr 2025 11:53:29 GMT

I just used the 1st 2 examples you posted.

What is the starting values in your new post? 1-3-5-0

Are you flipping/mirroring these 4 numbers above 1-3-5-0

Reply #3

Frl88p — Thu, 24 Apr 2025 03:05:50 GMT

Hi, thank you so much for helping me out, I really appreciate it, however, I still dont understand how these calculations work, are you telling me they are calculated from the numbers above, +4 to every digit ?

Look at this grid and tell me how to work this out please,

Reply #2

winsumloosesum — Wed, 23 Apr 2025 17:34:45 GMT

Posted a download link to my Blog.

The link contains an Excel file

Also added a video link with instructions

https://www.lotterypost.com/blogentry/190751

Reply #1

Frl88p — Wed, 23 Apr 2025 08:07:44 GMT

Here are more pictures of this grid,

Help needed, calculations on Mirror and Flipping

Frl88p — Wed, 23 Apr 2025 08:06:52 GMT

Hi, I need help in this mirror/flip number formula method.

I have been searching high and low for this, but I cant find it, does anyone know how to do this, how to solve this grid