JRRRJ
Chief Didacticist
- Joined
- Sep 5, 2011
- Messages
- 1,561
- Reaction Score
- 5,600
Download it here.
Haven't done it for a while, so here's a primer on some of the pivot table's features for those not familiar with them.
1. You can select individual opponents, venues, dates and starter/not starter from the drop-down lists at the top of the Per-40 page and all 3 tables (Data, Per 40, Per game) will recalculate to include only what you've selected. You can make multiple selections at once, like non-starters in games during December.
2. If you double-click on a numeric entry in the Data table, a new tab will open with all the detailed stats for the player whose row you clicked on. Then you can sort those stats any way you like to look for trends.
3. The Detail tab contains the box score data for all games, and a few data items that don't show on the Per-40 tab (e.g. conference Y/N).
The above info is also on the Info tab of the workbook.
Note: The 2FG% column has been moved from the Per-40 table to the per-game table and a ORB% column has been added to the per-game table, but only for team results.
Not enough minutes to be eligible for the per-40 table yet, but Aubrey's current numbers are among the leaders for ORB, DRB, TRB, assists, and blocks.
Per-40 rate rankings:
Haven't done it for a while, so here's a primer on some of the pivot table's features for those not familiar with them.
1. You can select individual opponents, venues, dates and starter/not starter from the drop-down lists at the top of the Per-40 page and all 3 tables (Data, Per 40, Per game) will recalculate to include only what you've selected. You can make multiple selections at once, like non-starters in games during December.
2. If you double-click on a numeric entry in the Data table, a new tab will open with all the detailed stats for the player whose row you clicked on. Then you can sort those stats any way you like to look for trends.
3. The Detail tab contains the box score data for all games, and a few data items that don't show on the Per-40 tab (e.g. conference Y/N).
The above info is also on the Info tab of the workbook.
Note: The 2FG% column has been moved from the Per-40 table to the per-game table and a ORB% column has been added to the per-game table, but only for team results.
Not enough minutes to be eligible for the per-40 table yet, but Aubrey's current numbers are among the leaders for ORB, DRB, TRB, assists, and blocks.
Per-40 rate rankings:
| Points | Paige 26.21 | Sarah 24.66 | Azzi 20.06 | Ashlynn/Jana ~14.0 |
| ORB | Jana 3.69 | Sarah 2.46 | Ice/Morgan 2.01 | Q 1.55 |
| DRB | Jana 9.45 | Sarah 8.80 | Ice/Q/Morgan ~ 5.4 | Paige 4.97 |
| TRB | Jana 13.14 | Sarah 11.26 | Ice 7.49 | Morgan 7.17 |
| Assists | Kaitlyn 6.11 | Paige 5.72 | KK/Sarah ~ 5.2 | Ice 4.58 |
| Blocks | Jana/Sarah ~ 1.8 | Ice/Azzi/Q ~0.7 | Paige 0.55 | kk 0.25 |
| Steals | Sarah 3.43 | Ashlynn/KK ~3.0 | Paige 2.69 | Ice/Kaitlyn ~1.7 |
| TOs | Ashlynn/Allie ~1.0 | Azzi/Morgan ~1.6 | Sarah 2.01 | KK 2.10 |
| Fouls | Allie 0.87 | Azzi 1.12 | Paige 1.38 | Ashlynn 1.66 |
| Made FT | Paige 3.17 | Sarah/KK ~2.1 | Jana 1.61 | Ice 1.34 |
Last edited: