Macro for Registering and Analyzing Subspreadsheets


Macro for Registering and Analyzing Subspreadsheets
Objective: Create a macro that automates the process of registering 6 subspreadsheets from the main spreadsheet and performing statistical analyzes on each of them.


1. Registration of Subspreadsheets:

Select cell A1 on the main worksheet.

Run the macro.

The macro will create 6 new subsheets with the following names:

Worksheet 1 - PTT
Worksheet 2 - PTM
Worksheet 3 - PT
Worksheet 4 - PTV
Worksheet 5 - PTN
Worksheet 6 - OWL
2. Statistical Analysis:

In each subsheet, the macro will perform the following analyses:

Counting digits from 0 to 9: The macro will count how many times each digit from 0 to 9 appears in the drawn numbers.
Pattern Count: The macro will count how many times each of the following patterns appears in the drawn numbers:
Pair: 0, 2, 4, 6, 8
Odd: 1, 3, 5, 7, 9
High: 5, 6, 7, 8, 9
Low: 0, 1, 2, 3, 4
Presentation of results: The macro will present the results of the analyzes in a table next to the list of draws.
well you asked for an example, we then have 6 results from pick3 and 4 in a spreadsheet, the results are For example, they will be changed and placed every week, but the macro can give you the limit of 10 thousand draws
in the list of 0 to 9 is to see how many of each digit was drawn, and another list and put in descending order from the most drawn to the least drawn
Ha, you can do these statistics by adding the 6 spreadsheets too, do you have any doubts


hello, in my pick3 I have 6 draws per day, you can add more statistical items or filters to each of the 6 sheets, what is done on the 1st sheet has to be done the same on the 5 sheets. In other words, in the 6 sheets the tracking is all the same, the aim was to register and do some basic statistics