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.
Phases:
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.
Bookmarks