Think you can build out the perfect Bears roster? Now you can prove it and show it off for everyone to see. Just open the Google Docs link below, save the workbook onto your device, and get a head start on your interview prep to be the next Bears GM!
I have added screenshots below for guidance. The rules are simple. Any section highlighted in yellow allows you to select a choice from a drop-down box, or type in free form.
Step 1: Choose Who to Cut or Trade from the Bears Roster
The first step to any Bears offseason is creating the baseline for your roster and cap space. This is the section where you get to do that. Want to trade Cairo Santos for the No. 1 overall pick? You can! But let’s try to keep this realistic. The screenshots show my quick example. No need to analyze what I did here because I was mostly just testing the model and setting up easy examples.
The sections highlighted in yellow are the areas you should edit in the document. Each place that is yellow in the sheet features either a dropdown box that you can choose from or is a free cell that you can type in. The options under the “Status” column are “Cut Pre-6/1”, “Cut Post 6/1”, “Trade Pre 6/1”, and “Trade Post 6/1”. Each option will generate the resulting cap implications for you. All cap data was pulled from overthecap.com.
In my example, I cut the following players:
- Jeremiah Attaochu
- Eddie Goldman
- Danny Trevathan (Post 6/1)
- Tarik Cohen
I also traded Nick Foles to the Jets for the 161st pick in the draft. This may not be realistic, or maybe it is. Regardless, I just wanted to show an example of a trade. When you make a trade, it can only be for draft picks. You will select the draft pick you traded for in the “Trade Return” column, and if you desire you can select the team you traded with on the right side in the “Trade Team” column.
Step 2: Add Free Agents and Rookies to the Bears Roster
On the left side of the spreadsheet, you will choose the free agents you would like to sign. Their year 1 cap hits are determined by how long their projected contracts run for. In a two-year deal, their year 1 cap hit will be 90% of the contract AAV. If it is a three-year deal, the year one cap hit will be 80% of the contract AAV. And so on. If you want to further backload the contract, you have the option to do so.
Additionally, you can review available free agents under the “FREE AGENTS” tab. Here, you can see each free agent, their projected contract, and the source or comp used to determine that contract. If you choose to do so, you can adjust the contract metrics yourself.
You can also run a mock draft before or after selecting free agents. In the top right corner of the "FA + Draft" tab, I have included links to three different mock draft simulators. Once you complete the draft, be sure to fill in the draft columns and write in who your picks were. Aside from draft picks, the rest of the table on the right will auto-fill as you make your free-agent signings on the left.
A quick tip for mock drafts: if you choose to trade up or down in the draft, you can go back to the “Cuts and Trades” tab and input those picks you traded for into the draft pick column. This will allow you to include the cap hit that comes with those draft picks you acquired. In my example, I traded down from pick 185 with Indianapolis, acquiring picks 215 and 233. To make sure these cap hits are reflected, I added them next to Jaylon Johnson and Duke Shelley on the “Cuts and Trades” tab. And because I traded pick 185, I simply did not select it from the dropdown options. Scout's honor here.
The goal is to reach 51 players on the roster without going over the salary cap. If you go over the cap, the “SUPER BEARS SUPER BOWL” graphic will change colors and have a quick message for you to try again.
Step 3: Build Your Depth Chart
Drop-down boxes of your rostered players, free agent signings, and draft picks (i.e. pick 39 rather than the player you selected) are available on this page for you to fill in the depth chart with. Each player's 2021 PFF grade will autofill into the chart, and give you a verdict on the offense, defense, and team average PFF grades.
Enjoy, and nail down the Bears roster so the new GM doesn't have to!
P.S. Good luck on the Bears GM interviews! If you have any issues whatsoever, let me know on Twitter @ButkusStats.