To get started with the contents of the zip file, follow these steps:
: The sheet calculates an "Estimated Spread" and "Total" based on efficiency ratings (Offensive/Defensive efficiency) and pace of play [3]. BBcaps.zip
: Because the spreadsheet uses automated scripts to pull data, you must click "Enable Content" or "Enable Macros" when you first open the file in Excel [4]. To get started with the contents of the
The tool is designed to automate the heavy lifting of basketball data analysis: It often lacks functionality in Google Sheets or
: This tool works best on the Desktop version of Microsoft Excel . It often lacks functionality in Google Sheets or Excel Online due to the complex VBA macros required for data scraping [3].
: Most versions allow you to select specific matchups from a dropdown menu or by entering team names [4].