GMExcel 24 - Single-player financial tool for OOTP

[darkcloud4579]

The most popular financial mod in OOTP history is back after a long absence.

I still have more tinkering to do with this, but I didn't want to play around with it anymore without letting humans use it. The goal from the past versions of GMExcel was to make it less tedious to use year after year and ultimately, to make the game more challenging and/or interesting to solo players by making some of the finances fun but also a bit more random.

I have more I want to do with it, but for now, I just wanted to share it as it's been a very long time since I released a version. This does not include market size calculators, mostly because the work involved in making one of those isn't really worth it for OOTP when you can kind of eyeball that yourself.

[darkcloud4579]

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

[darkcloud4579]

Here's a link: https://docs.google.com/spreadsheets...it?usp=sharing

Because of the limited audience of stuff like this, it's mostly made for me. I'm going to already work on a simplified version of this, but I just felt like I was working at it that I wanted to share what I had so far.

[darkcloud4579]

The current spreadsheet template has 3 different financial mods..

GMBeta is a simplified version of the GMExcel tool, meant to make a more immersive single-player experience, but without lots of input. It randomizes some aspects of things to make the finances of managing a team a bit harder than just using the in-game setup, but it easy to manage as a solo player not needing to input all of the league's teams to make it work well.

GMExcel combines the essence of past versions of the tool into a modern version that actually borrows from the FOBL system because I like aspects of it. It still works for a single player -- doesn't require the whole league input -- but does need more information. It also gives you credit for more success in ways the simplified version doesn't. I'm still working out the kinks of the structure, but...it's a worthy successor to the past version of my financial mods.

The FOBL one is from the old FOBL league that used to exist in the early part of the 21st century, it was weird because we had our own financial system that existed outside of OOTP (the finances were essentially a closed system) a hard salary cap and rules that essentally made it a parity-driven exercise.

We never had a spreadsheet that calculated the financial system though, until now.

[darkcloud4579]

Introducing Front Office Manager: Your OOTP25 Ownership Assistant!

Do you need help managing your OOTP25 team from an owner's perspective? Look no further! Front Office Manager is here to assist you with realistic goals, budgets, and market size calculations to keep your franchise on track.

Features:

• []Realistic Owner Goals and Budgets: Front Office Manager sets annual goals and budgets based on your team's data and performance.
  []Market Size Calculations: Accurately determines market size for cities, ranging from 1-20, considering population and DMA media market. Global cities like New York, London, Los Angeles, Chicago, and most of India fall within the 10-20 range.
  []Fan Interest and Loyalty: Calculates fan interest, loyalty, and season ticket sales percentage based on market size, fan interest, and loyalty.
  []Performance-Based Tone: Varies the tone based on team performance—disappointed and firm for poorly performing teams, balanced and rational otherwise.
  []Pithy and Conversational Communication: Keeps responses concise, easy to understand, and more like a human dialogue.
  []Interview Simulations: Offers to simulate the interview process for another team if you're in commissioner mode.
• Annual Owner Goals: Provides 2-3 realistic owner goals, including short, medium, and long-term objectives (up to 3-5 years).

How It Works:
Front Office Manager uses the GMExcel24 tool for calculations, ensuring all values are rational and grounded in market realities. You can ask questions about team performance, historical data, and average league attendance to get tailored advice.

Sample Interaction:

User: Can you help set the budget for my team?
Front Office Manager: Sure! Based on your team's performance last season and current market size, I'd recommend a budget of $150 million for this year. This should help cover necessary expenses and allow for some flexibility in player acquisitions.

Get Started:
Simply ask Front Office Manager about your team's needs, and you'll receive expert advice tailored to your specific situation.

Optimize your OOTP25 ownership experience with Front Office Manager today!