It all starts with the number of times an Option is Drawn and the Number of Options from which it is Drawn. That History is a listing of all Options drawn in each Draw in Each Game. That is a Grid and perfect for a Spread Sheet.
Excel is a Spread Sheet Program. Maintaining an updated Historical Grid serves as a platform from which to look back. The look back increases the number of columns in the grid. Excel has a pretty good set of functions to analyze and group the data. Excel maintains Statistical Data.
One of the more powerful Functions in Excel is the Indirect Function. This function allows for its Address Range to be based on a formula.
Macros for me are a repetitions Filter Settings “On”, “Off”, ”Option Values”=>Filter Sequences. After setting the Games Number, the Macro runs and logs another Grid of data on the performance of the Filter Sequence over the specified number of games.
This is Basic Stuff really. Maybe a bit eccentric from a “Break Down” perspective with a One Trick Pony that says Next and proceeds to log the result.
Excel is Giant Grid. Finding What If in that Grid is What it does. Macros, at least my Steppers, usually come into play when the number of columns in the history that are needed to generate a Data Idea is too large to fit in the Grid and or takes too long to calculate in cell formulas. Not to mention unstable.
Regarding Macros,
Can anyone tell me or share what a macro should do beyond my baby steps.
What Grid are you looking at beyond the numbers themselves? What Column of numbers are you focused on? Where does the grid come from? If the macro sets up the basic grid formulas why? And what’s the difference? Every time we open up our file, it recalculates all of the formulas. My Step Macros record the Values of the formulas in the game History to a summarized a set of fixed Values. Next is the How? Excel can calculate a large number of running formulas in a pretty large grid. Cell Formulas can be made to respond to a change in a filter Value in another cell and be analyzed historically when the grid recalculates. You don’t need a Macro for any of it.
I guess I like to set things in piles right there on my screen. Then I like to step back and watch the piles move when I change a Value somewhere that generates a web of If Then statements dispersed thru out a grid. A Macro just lets me stop typing or clicking the mouse while if creates a fixed value log of a summary of the data Block when a Filter Value was applied. What else can a Macro really do?
I would really like to know.