01-27-2024, 05:23 PM
|
#2
|
Hall Of Famer
Join Date: Jun 2003
Posts: 8,658
|
GMExcel24 Column Instructional Guide
- []Year: Input the year for financial data calculation.
[]Stad. Cap. (Stadium Capacity): Enter your team's stadium capacity.
[]Salary Cap: Input the league's salary cap for the year.
[]Runs Scored (RS): Enter total runs scored by your team.
[]Runs Allowed (RA): Enter total runs allowed by your team.
[]WPCT (Winning Percentage): Input your team's winning percentage.
[]LSW (Last Season Wins): Input wins from the last season.
[]2SW (Wins Two Seasons Ago): Input wins from two seasons ago.
[]3SW (Wins Three Seasons Ago): Input wins from three seasons ago.
[]OPS Rank: Enter your team's OPS ranking.
[]ERA+ Rank: Enter your team's ERA+ ranking.
[]League Average Payroll: Input the league's average payroll.
[]Expected Wins (EW): Calculated based on RS and RA.
[]Current Performance (CP): Calculated from actual and expected performance.
[]SCC (SportsCenter Component): Calculated from OPS and ERA+ ranks.
[]Bandwagon: Calculated based on past three seasons' wins.
[]Postseason Shares: Input revenue from postseason games.
[]Playoff Bonus Pool: Input bonuses from postseason success.
[]PAYROLL: Input current season's total payroll.
[]NX BDGET (Next Budget): Projected next season's budget.
[]CASH (Cash Bank): Input available cash reserves.
[]FLEX: Wanna "go for it?" This is the FLEX you're allowed to spend at...there's gonna be a punitive feature here so you don't do it every. year but i haven't gotten there yet.
[]REMAIN (Remaining Budget): Displays remaining flex cash (i need to work on this category more...)
[]OWNER CAP: Maximum budget set by the owner.
[]Season Tickets: This figure is generated to make things interesting based on stadium capacity and other factors
[]4W% (Four-Year Winning Percentage): Calculated average winning percentage.
- EW, EWF, PLY, DIV, PEN, WS: Expected Wins, Expected Win Factor (both autocalc'd), PLY = playoff appearance DIV = division title PEN = league pennant WS = World Series
Last edited by darkcloud4579; 01-27-2024 at 05:26 PM.
|
|
|