Reply to thread

Message: [QUOTE="JRRRJ, post: 5353367, member: 1303"] The new workbook is linked [URL='http://www.jackromanowicz.com/downloads/Per 40 Pivot Stats Consolidated.xlsx']here[/URL]. 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. [/QUOTE]

Verification: First name of men's bb coach

Forum statistics

Threads: 164,773

Messages: 4,410,236

Members: 10,233

Latest member: pws1974