ABCDEFGHIJKLMNOPQRSTUVWXYZAA
1
TopicTabDescriptionStatus
2
Competitive Balance TaxCompetitive Balance Tax CalcThe projected Competitive Balance Tax calculation for 2024-2026. Updated real-time during the season to account for any and all transactions, performance bonuses, etc.REVAMP
Look into smart sheet, flourish chart capabilities
3
Competitive Balance TaxPre-Arb SummaryA full list of all the pre-arb salaries, which feeds into the CBT calc.REVAMP AND LAYER INTO DATA DUMP
CONSIDER EXCEL COPILOT
4
Competitive Balance TaxMiLB DealsA list of notable MiLB deals, along with specific details on each contract, such as split contract salaries and opt-out dates.REVAMP AND LAYER INTO DATA DUMP
5
Competitive Balance Tax40-man MiLB SalariesA calculation of estimated MiLB salaries for players on the 40-man roster.REVAMP AND LAYER INTO DATA DUMP
6
Competitive Balance TaxPerformance BonusesA list of player contracts with performance bonus clauses, which is tracked real-time and built into the CBT calculation.REVAMP AND LAYER INTO DATA DUMP
7
8
Offseason AnalysisOffseason 40-man AnalysisA rought draft of the 40-man heading into the early parts of the offseasonREVAMP AND COMBINE WITH DEPTH CHART
9
Offseason AnalysisOffseason Depth ChartA rought draft of the 2024 depth chartREVAMP AND COMBINE WITH 40-MAN
10
Offseason AnalysisFree Agent TrackerThis contains the list of the "top 100" Free Agents, along with players that had recently been non-tendered or DFA'd. Contract estimates were pulled in via FanGraphs and MLBTradeRumors for reference. Players are crossed off upon signing, but remain on the list for contract references.REVAMP AND COMBINE WITH FA TARGETS
11
Offseason AnalysisFree Agent TargetsFree Agents were bucketed into various groups that the team had needs for. Signed players have been since deleted in order to show the current state of what players are available on the open market. Bolded players are the players in a particular bucket that appear to be a good fit for the team.REVAMP AND COMBINE WITH FA TRACKER
12
Offseason AnalysisOffseason Trade TargetsPlayers that have been reported or rumored to be on the trade market are included on this tab. Not much additional analysis included here since it is unknown which players are actually available to trade for.FILL OUT
13
Offseason AnalysisOffseason Trade ChipsAnalysis of players that can be used as potential trade chipsFILL OUT
14
Offseason AnalysisYamamoto Posting FeeA calculation of a potential posting fee for YamamotoCOMPLETED
15
Offseason AnalysisAgency DatabaseA list of agents for all playersCOMPLETED
16
17
2024 In-Season AnalysisDepth ChartA general depth chart of the 26-man roster, as well as any MiLB players (40-man or non-40 man) that could potentially get called up at some point this year.LEVERAGE REVAMPED OFFSEASON DEPTH CHART & 40-MAN
18
2024 In-Season AnalysisOptions CounterA summary of MiLB options remaining for the seasonLAYER INTO REVAMPED DEPTH CHART & 40-MAN
19
2024 In-Season AnalysisPitching Staff TrackerA real-time tracker of pitcher usage for both the rotation and bullpen, along with minor league arms on the 40-man; this will help provide a preview of which pitchers may be unavailable at times or which pitchers may be the best fit for call-ups.N/A UNTIL OPENING DAY
20
2024 In-Season AnalysisInjury UpdatesStatus update of players on the IL.N/A UNTIL OPENING DAY
21
2024 In-Season AnalysisUpcoming TransactionsA preview of upcoming transactions in order to monitor the 40-man and 26-man roster crunch as players return from the IL.N/A UNTIL OPENING DAY
22
23
2024 Trade Deadline AnalysisTrade Targets (if Buy)Will search for trade targets among selling teamsN/A UNTIL TRADE DEADLINE
24
2024 Trade Deadline AnalysisTrade Chips (if Buy)Analysis of players that can be used as potential trade chipsN/A UNTIL TRADE DEADLINE
25
2024 Trade Deadline AnalysisTrade Block (if Sell)Analysis of players to potentially trade away at the trade deadlineN/A UNTIL TRADE DEADLINE
26
27
Contract & Trade AnalysisCBT Open ItemsCBT Open Items to attempt to confirm via sourcesCLEAN-UP AND ADD TO WORD DOC SUMMARY
28
Contract & Trade AnalysisCBT Notes for ReferenceCBT Notes for reference - pending the new CBA for full analysis.CLEAN-UP AND ADD TO WORD DOC SUMMARY
29
Contract & Trade AnalysisCBT PenaltiesA summary of the various penalties for exceeding the CBT thresholdsADD TO WORD DOC SUMMARY
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100