Spring 2020 UR Basketball Lineup Project

By Will Stone, Tirdod Behbehani, Tom Mattson

In the spreadsheet below is our work we did last Spring in helping build a data analysis tool for the UR Men's Basketball team. The goal of the project was to compare and contrast different lineups using a series of common offensive and defensive metrics. For instance, do certain lineups (singles, pairs, triads, quads, and quins) have a greater impact on team performance than other lineups? To answer this question, we did the following: (1) We downloaded the play by play tables for the UR’s men’s basketball team from the public (freely available) stats.ncaa.org website. (2) We parsed, grouped, and calculated game level and lineup specific metrics using a custom Python script. (3) We then exported that parsed data into an Excel workbook. (4) Finally, we created a custom user interface in Excel for the coaches to select and filter the data based on whatever lineup they are interested in analyzing. The end-users (coaches) only see the final Excel workbook with the interactive functionality. We replaced the players names with their jersey numbers for confidentiality reasons.

Click below to download the excel spreadsheet