View Single Post
Old 01-27-2024, 05:23 PM   #2
darkcloud4579
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.
darkcloud4579 is offline   Reply With Quote