Major modification to per-40 workbook -- opinions wanted

[JRRRJ]

The new workbook is linked here.

It contains the years from 2018 to 2025. When you first open it, it will display the per-40 stats for every player since 2018. There's a new drop-down filter on the Pivot tab which allows to select the year or years you want to include in the Per 40 and Per Game tab tables.

You can still double-click on an entry in the Pivot tab table to see the Detail tab table data rows that went into the entries for that Pivot table row. It will appear in a new tab.

Be aware that not all the selections in the filters are available at all times. For example, if you select '2023' in the Year filter 'AAC Tourney' will still appear in the Venue filter, even though there were no AAC Tourney games in that year.

The TEAM, UConn and Opponent rows will always be at the top of the consolidated tables rather than the bottom.

If you want to sort a table, to e.g. find out who had the best per-40 ORB rate in 2020-2022 away games, you'll need to select your filters, then copy the per-40 table and paste it in a new tab to sort it.

I think there are some games missing from the end of the 2018 year. I'll research that and add them if I can.

This was a large undertaking and I'm sure there are errors in data or formulae to be found. If you find some, please let me know.

I also wonder if it's too complex for some user and I should maintain bot the consolidated and single-year versions in parallel.

Have fun! Let me know what you think.

 

[EricLA]

My only suggestion if possible would be to list them in order of PPG. It would make it much easier... and maybe move the PPG to the left just after the "minutes". PPG is usually the first thing i look for, but maybe that doesn't matter.

Regardless, great job. fun to check this stuff out and see who's doing what.

The per 40 is fun. One of the biggest bang for your buck was Griffin - almost 16 points per 40. Jana was almost 13 and Allie, of all players, was almost 14! Good for them! The lowest was Morgan Cheli followed by Q and Ice - all under 10 points per 40.

 

[Centerstream]

The new workbook is linked here.

It contains the years from 2018 to 2025. When you first open it, it will display the per-40 stats for every player since 2018. There's a new drop-down filter on the Pivot tab which allows to select the year or years you want to include in the Per 40 and Per Game tab tables.

You can still double-click on an entry in the Pivot tab table to see the Detail tab table data rows that went into the entries for that Pivot table row. It will appear in a new tab.

Be aware that not all the selections in the filters are available at all times. For example, if you select '2023' in the Year filter 'AAC Tourney' will still appear in the Venue filter, even though there were no AAC Tourney games in that year.

The TEAM, UConn and Opponent rows will always be at the top of the consolidated tables rather than the bottom.

If you want to sort a table, to e.g. find out who had the best per-40 ORB rate in 2020-2022 away games, you'll need to select your filters, then copy the per-40 table and paste it in a new tab to sort it.

I think there are some games missing from the end of the 2018 year. I'll research that and add them if I can.

This was a large undertaking and I'm sure there are errors in data or formulae to be found. If you find some, please let me know.

I also wonder if it's too complex for some user and I should maintain bot the consolidated and single-year versions in parallel.

Have fun! Let me know what you think.

Looking forward to "playing" with your latest iteration.
Thank you.