NBA:League Spreadsheet: Difference between revisions
Row labels as table header cells |
Grammar: serial commas throughout, plus assorted fixes |
||
| Line 1: | Line 1: | ||
{{1TC NBA rules}} | {{1TC NBA rules}} | ||
The '''[https://docs.google.com/spreadsheets/d/1B9SprZLJTFl9mfawuaprVdjhAMul1IlRs3JU30CPVIQ/edit?gid=1991165606#gid=1991165606 league spreadsheet] is the source of truth.''' Every player contract, every waiver and every draft pick in the league is recorded there. | The '''[https://docs.google.com/spreadsheets/d/1B9SprZLJTFl9mfawuaprVdjhAMul1IlRs3JU30CPVIQ/edit?gid=1991165606#gid=1991165606 league spreadsheet] is the source of truth.''' Every player contract, every waiver, and every draft pick in the league is recorded there. | ||
It is a single Google Sheet with many tabs. [[NBA:League Structure|TAB]] maintains it. | It is a single Google Sheet with many tabs. [[NBA:League Structure|TAB]] maintains it. | ||
| Line 37: | Line 37: | ||
! Tab | ! Tab | ||
|- | |- | ||
| Your roster, contracts, picks and cap | | Your roster, contracts, picks, and cap | ||
| Your team's | | Your team's | ||
|- | |- | ||
| Line 68: | Line 68: | ||
Open the blue tab carrying your team's abbreviation. It shows, season by season: | Open the blue tab carrying your team's abbreviation. It shows, season by season: | ||
'''A summary block''' — your roster, Injured Reserve, G League and re-sign counts against their maxima, plus payroll, cap hits and cap space. Counts outside a limit are flagged, so you can see at a glance if you are over the roster maximum or the cap. | '''A summary block''' — your roster, Injured Reserve, G League, and re-sign counts against their maxima, plus payroll, cap hits, and cap space. Counts outside a limit are flagged, so you can see at a glance if you are over the roster maximum or the cap. | ||
'''Your players''', grouped into Active, Injured Reserve and G League, with each contract laid out across the years it runs, re-signs marked, and <code>UFA</code> in the season the player becomes a free agent. | '''Your players''', grouped into Active, Injured Reserve, and G League, with each contract laid out across the years it runs, re-signs marked, and <code>UFA</code> in the season the player becomes a free agent. | ||
'''Draft picks''' you own, by year and round. | '''Draft picks''' you own, by year and round. | ||
Revision as of 20:26, 7 October 2026
| Reference | Contracts · Rosters · Salary Cap · League Spreadsheet |
| Transactions | Waivers · Trades · Options · Re-Signing · Draft · Free Agency · G League · Injured Reserve |
| Timeline | Off-Season · In-Season |
| Governance | League Structure · GM Responsibilities · Rule Changes |
| Tools | Re-Sign Calculator · Free Agency Bid Calculator |
The league spreadsheet is the source of truth. Every player contract, every waiver, and every draft pick in the league is recorded there.
It is a single Google Sheet with many tabs. TAB maintains it.
How it is organized
Tabs are color-coded by group:
| Group | Tabs | What they hold |
|---|---|---|
| Red | Players, Teams, Picks | Every player contract, every team, and every draft pick in the league |
| Yellow | Off-Season, UFA, Options | Rebuilt each off-season — the schedule, that year's free agent list, and that year's option decisions |
| Green | Standings, Rosters, Waivers, Draft | Standings and lottery odds, roster and cap totals for all 30 teams, current waiver priority, and the results of the most recent draft |
| Blue | ATL, BOS, …
|
One tab per team, labeled with its abbreviation |
Where to look
| To check | Tab |
|---|---|
| Your roster, contracts, picks, and cap | Your team's |
| Who is available to bid on | UFA |
| Every option decision in the league | Options |
| This year's off-season dates | Off-Season |
| Current waiver priority | Waivers |
| Standings and lottery odds | Standings |
| The most recent draft's results | Draft |
| Every team's roster count and cap total | Rosters |
The UFA tab is where you check who can be bid on ahead of free agency.
Your team tab
Open the blue tab carrying your team's abbreviation. It shows, season by season:
A summary block — your roster, Injured Reserve, G League, and re-sign counts against their maxima, plus payroll, cap hits, and cap space. Counts outside a limit are flagged, so you can see at a glance if you are over the roster maximum or the cap.
Your players, grouped into Active, Injured Reserve, and G League, with each contract laid out across the years it runs, re-signs marked, and UFA in the season the player becomes a free agent.
Draft picks you own, by year and round.
Cap hits from players you have waived.
Your forum page and Discord profile, linked — this is how other GMs reach you with a trade offer.
In the off-season
Your team tab also lists your upcoming free agents and option decisions at the bottom, so you can see what you need to decide before the option and re-sign windows.
Keep your roster post aligned
Your forum roster post must match the spreadsheet.
If the two disagree, the spreadsheet is right — and if something on it looks wrong, contact TAB rather than working around it. See GM Responsibilities.
See also
- Rosters — your forum roster post and what it should contain
- Salary Cap — how the cap figures are calculated
- Option Years — the option window
- Free Agency — bidding on players from the UFA list
- Off-Season — the stages the yellow tabs track
- League Structure — TAB, who maintains the spreadsheet