hello=
--
## 🧩 OBJECTIVE
To create a **panel for analyzing endings (0-9)** by **position (P1-P6)**, highlighting the **highest incidences (blue)** and **allowing for the generation of bets** based on the detected patterns.
---
## ⚙️ STEP 1 – Basic Structure
Open a new Excel file and create this structure:
| Row | P1 | P2 | P3 | P4 | P5 | P6 |
| :---- | -- | -- | -- | -- | -- | -- |
| 0 | | | | | | |
| 1 | | | | | | |
| 2 | | | | | | |
| 3 | | | | | | |
| 4 | | | | | | |
| 5 | | | | | | |
| 6 | | | | | | |
| 7 | | | | | | |
| 8 | | | | | | |
| 9 | | | | | | |
💡 Tip: In column A (where it says “Line”), write **0–9**, representing the endings.
---
## ⚙️ STEP 2 – Insert the history
Right below (or in another spreadsheet), place the **draw history** of Lottery 6/49, **in ascending order** in the 6 positions:
| Draw | P1 | P2 | P3 | P4 | P5 | P6 |
| :------ | --- | --- | --- | --- | --- | -- |
| 1 | 3 | 11 | 24 | 31 | 45 | 47 |
| 2 | 5 | 9 | 17 | 28 | 37 | 43 |
| 3 | 2 | 8 | 10 | 26 | 35 | 49 |
| ... | ... | ... | ... | ... | ... | |
💡 Tip: Use at least **100 to 500 draws** for a reliable baseline.
---
## ⚙️ STEP 3 – Calculate endings
Create another table (or in the right corner) to extract the **ending of each number**:
| Draw | T1 | T2 | T3 | T4 | T5 | T6 |
| :------ | -------------- | -------------- | -- | -- | -- | -- |
| 1 | =RIGHT(B2;1) | =RIGHT(C2;1) | … | … | … | … |
👉 The formula in Portuguese (Excel PT-BR):
```excel
=RIGHT(B2;1)
```
Copy this to all positions (P1–P6) and all draws.
This shows the **final digit (0–9)** of each drawn number.
---
## ⚙️ STEP 4 – Frequency count by position
Now, go back to the **first table (0–9 x P1–P6)** and count **how many times each ending appears in each position**.
In cell **B2 (row 0, P1)**, use:
```excel
=SUMPRODUCT(($T1:$T100=0)*($P1:$P100="P1"))
```
But since Excel doesn't understand the position name directly, we use a practical way:
In cell **B2** (row 0, P1):
```excel
=COUNTIFS(Table_T1:Table_T1;0)
```
Even better, if the data is organized by fixed columns:
* P1 → column B (original numbers)
* T1 → column H (terminals of P1)
Then:
* In B2 (row 0, P1):
```excel
=COUNTIF(H$2:H$500;A2)
```
* Copy to all columns (P2–P6) and rows (0–9).
This counts **how many times the ending 0 appears in position 1**, then 1, 2, etc.
---
## 🎨 STEP 5 – Automatic Colors (Conditional Formatting)
Select the entire table **(0–9 x P1–P6)** → Go to:
> **Home → Conditional Formatting → Color Scale**
Choose:
* Blue for higher values
* Yellow for medium values
* White for lower values
👉 Now the visual graph will show the **“heat map” of the endings**, as in the example image you sent.
---
## 🧠 STEP 6 – Generating Smart Combinations
Create a new tab called **“Generator”**, with:
| Position | Dominant Ending | Alternative |
| :------ | :------------------- | :---------- |
| P1 | 7 | 8 |
| P2 | 3 | 2 |
| P3 | 2 | 7 |
| P4 | 1 | 0 |
| P5 | 4 | 1 |
| P6 | 7 | 9 |
Then, below, use a formula like this to generate random combinations:
```excel
=CHOOSE(RANDBETWEEN(1;2);B2;C2)
```
This randomly chooses between the dominant and the alternative.
Then combine the endings with real tens (e.g., endings 7 → 7, 17, 27, 37, 47).
---
## 🧩 STEP 7 – Final Result
You will have:
✅ A colored map of the dominant endings.
✅ Automatic counting by position.
✅ Tool for generating bets based on statistical patterns.
---
Philadelpia/Pennsylvania
