Jump to content

NBA:League Spreadsheet: Difference between revisions

From 1TC Rules
Grammar: serial commas throughout, plus assorted fixes
Link targets and wording
 
(4 intermediate revisions by the same user not shown)
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, waiver, and draft pick is recorded there. [[NBA:League Structure#Commissioner and TAB|TAB]] maintains it.
 
It is a single Google Sheet with many tabs. [[NBA:League Structure|TAB]] maintains it.


== How it is organized ==
== How it is organized ==
Line 16: Line 14:
! Red
! Red
| Players, Teams, Picks
| Players, Teams, Picks
| Every player contract, every team, and every draft pick in the league
| Every player contract, team, and draft pick in the league
|-
|-
! Yellow
! Yellow
Line 43: Line 41:
| [https://docs.google.com/spreadsheets/d/1B9SprZLJTFl9mfawuaprVdjhAMul1IlRs3JU30CPVIQ/edit?gid=1304251873#gid=1304251873 UFA]
| [https://docs.google.com/spreadsheets/d/1B9SprZLJTFl9mfawuaprVdjhAMul1IlRs3JU30CPVIQ/edit?gid=1304251873#gid=1304251873 UFA]
|-
|-
| Every [[NBA:Option Years|option decision]] in the league
| Every [[NBA:Options|option decision]] in the league
| [https://docs.google.com/spreadsheets/d/1B9SprZLJTFl9mfawuaprVdjhAMul1IlRs3JU30CPVIQ/edit?gid=198840718#gid=198840718 Options]
| [https://docs.google.com/spreadsheets/d/1B9SprZLJTFl9mfawuaprVdjhAMul1IlRs3JU30CPVIQ/edit?gid=198840718#gid=198840718 Options]
|-
|-
| This year's [[NBA:Off-Season|off-season]] dates
| This year's [[NBA:Off-Season|off-season]] dates
| Off-Season
| [https://docs.google.com/spreadsheets/d/1B9SprZLJTFl9mfawuaprVdjhAMul1IlRs3JU30CPVIQ/edit?gid=1385332490#gid=1385332490 Off-Season]
|-
|-
| Current [[NBA:Waivers#Waiver priority|waiver priority]]
| Current [[NBA:Waivers#Waiver priority|waiver priority]]
| Waivers
| [https://docs.google.com/spreadsheets/d/1B9SprZLJTFl9mfawuaprVdjhAMul1IlRs3JU30CPVIQ/edit?gid=189370647#gid=189370647 Waivers]
|-
|-
| Standings and [[NBA:Draft#The lottery|lottery odds]]
| Standings and [[NBA:Draft#The lottery|lottery odds]]
| Standings
| [https://docs.google.com/spreadsheets/d/1B9SprZLJTFl9mfawuaprVdjhAMul1IlRs3JU30CPVIQ/edit?gid=1991165606#gid=1991165606 Standings]
|-
|-
| The most recent draft's results
| The most recent draft's results
| Draft
| [https://docs.google.com/spreadsheets/d/1B9SprZLJTFl9mfawuaprVdjhAMul1IlRs3JU30CPVIQ/edit?gid=88725143#gid=88725143 Draft]
|-
|-
| Every team's roster count and cap total
| Every team's roster count and cap total
| Rosters
| [https://docs.google.com/spreadsheets/d/1B9SprZLJTFl9mfawuaprVdjhAMul1IlRs3JU30CPVIQ/edit?gid=789437837#gid=789437837 Rosters]
|}
|}
The '''UFA tab is where you check who can be bid on''' ahead of [[NBA:Free Agency|free agency]].


== Your team tab ==
== Your team tab ==
Line 76: Line 72:
'''Cap hits''' from players you have waived.
'''Cap hits''' from players you have waived.


'''Your forum page and Discord profile''', linked — this is how other GMs reach you with a [[NBA:Trades|trade]] offer.
'''Your forum page and Discord profile''', linked — this is how other GMs reach you with a [[NBA:Trades#How to post|trade]] offer.


=== In the off-season ===
=== 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 [[NBA:Off-Season|option and re-sign windows]].
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 [[NBA:Off-Season#This year's dates|option and re-sign windows]].


== Keep your roster post aligned ==
== Keep your roster post aligned ==
Line 86: Line 82:
Your [[NBA:Rosters#How to post|forum roster post]] must match the spreadsheet.
Your [[NBA:Rosters#How to post|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 [[NBA:GM Responsibilities|GM Responsibilities]].
'''If the two disagree, the spreadsheet is right''' — and if something on it looks wrong, contact TAB rather than working around it.


== See also ==
== See also ==
Line 92: Line 88:
* [[NBA:Rosters|Rosters]] — your forum roster post and what it should contain
* [[NBA:Rosters|Rosters]] — your forum roster post and what it should contain
* [[NBA:Salary Cap|Salary Cap]] — how the cap figures are calculated
* [[NBA:Salary Cap|Salary Cap]] — how the cap figures are calculated
* [[NBA:Option Years|Option Years]] — the option window
* [[NBA:Options|Options]] — the option window
* [[NBA:Free Agency|Free Agency]] — bidding on players from the UFA list
* [[NBA:Free Agency|Free Agency]] — bidding on players from the UFA list
* [[NBA:Off-Season|Off-Season]] — the stages the yellow tabs track
* [[NBA:Off-Season|Off-Season]] — the stages the yellow tabs track

Latest revision as of 05:04, 8 October 2026

The league spreadsheet is the source of truth. Every player contract, waiver, and draft pick is recorded there. 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, team, and 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

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 also