JRRRJ
Chief Didacticist
- Joined
- Sep 5, 2011
- Messages
- 1,484
- Reaction Score
- 5,074
A major revision to the workbook. I gave it a new name so it won't overwrite the old version in case you don't like the new paradigm.
Rather than a single sheet to enter the YTD figures, there is a summary sheet that aggregates individual game sheets you (or I, if you can wait that long) create.
This allows you to get summary and per-40-min stats on any arbitrary group of games and every individual game, allowing more refined trend detection.
And I think it would allow the same features with charting, but I'm not enough of an Excel guru to state that definitely.
Cleaned up the formulas so they deal more intelligently with blank cells and also don't try to divide by zero any more.
Download it from here.
Rather than a single sheet to enter the YTD figures, there is a summary sheet that aggregates individual game sheets you (or I, if you can wait that long) create.
This allows you to get summary and per-40-min stats on any arbitrary group of games and every individual game, allowing more refined trend detection.
And I think it would allow the same features with charting, but I'm not enough of an Excel guru to state that definitely.
Cleaned up the formulas so they deal more intelligently with blank cells and also don't try to divide by zero any more.
Download it from here.
