|
||||
|
10-07-2009, 12:22 PM | #1 | |
Hall Of Famer
|
GMEXcel - (Formerly MarketCalc)
Today I'm releasing an updated version of MarketCalc for OOTPX. I haven't made any real improvements to it since last year, but there might be some to come later, as I can think of a few things I'd like to do with it, integrating some of the things from MarketCalc8 into the new version to allow people running fictional leagues to do more. In any case, here's what it does: Quote:
What I mean by "real life" is, I wanted to be able to play in New York and see the modern day, non-revenue sharing effects of that largess versus say, playing in Portland, Maine or Winnemucca, Nevada. OOTP doesn't do this naturally, you have to tweak it to make it work. It's for use in Excel, but OpenOffice also opens .xls files. BUT WAIT, THERE'S MORE! Included in GMEXcel is a little tool called Fire MGR X. It's basically a tool for solo players to determine owner confidence. Want to find out when you're not doing well enough and need to fire yourself and get a new job? This tool does just that. It comes with instructions and is easy to use. Basically, you get awarded points for regular season performance and post-season appearances. But the better you get, the more challenging it is to keep your job if you start to slack over a period of time. Future improvements for this will eventually allow you to figure what sort of teams you can take over and other house rule calculations to make solo play more immersive. Let me know if you have questions and enjoy! EDIT HERE'S THE LATEST VERSION OF GMEXCEL[/B] Here's GMExcel 10.75
__________________
Godfather of Fast-Sim OOTP My Mods: GMExcel 24 Major League Women's Baseball (OOTP24) quickstart Indian Premier League | 300+ years of baseball quickstart | Expatriate League quickstart | Off-Field Injuries Update | Women's Name File for OOTP | My (outdated) market calculator & financial spreadsheets Last edited by darkcloud4579; 10-27-2011 at 05:28 PM. |
|
10-08-2009, 10:11 AM | #2 |
OOTP Roster Team
Join Date: Feb 2002
Posts: 1,516
|
Good stuff!
When do we need to "fire" ourselves? When the confidence is negative? |
10-08-2009, 11:08 AM | #3 | |
Hall Of Famer
|
Quote:
I've worked on an update to allow it to tell you when you go to a new team, too. You can check out the "beta" of that on the dynasty in my signature if you're interested. |
|
10-11-2009, 01:27 AM | #4 |
Hall Of Famer
|
Here's an updated version of GMEXcel. It's really the product of a bunch of updated to the FIREMGR tool.
I've updated this file to the newest version of GMEXcel, which is FireMgr 2.0, including some tweaks to the formula for how you fire a manager, has a new algorithm that allows you to see when you can go to a new team, as well. You input the number of wins that team has into the following season's box and it'll tell you where you can go. I've been tweaking it for the past two days and it seems to work as intended and the formula for what teams you can go to, etc., seems to work without a hitch too. Lemme know if you have problems, if you check out this updated version (and you should, the older one has a wonky formula.) Post any questions you have and I'll answer them for you. |
10-12-2009, 01:21 PM | #5 |
Hall Of Famer
Join Date: Aug 2002
Posts: 16,843
|
Thanks for the contribution, darkcloud. I opened up the program yesterday for a brief initial look-see and thought it looked great. Question here. Maybe I'm overlooking the application read-me or just missing the avenue altogether. Can I, with my fictional league mostly based in very small communities, with some metro exceptions, plug these in individually and adapt it to my world? I tried with a couple, and it let me locate the column where the population is extrapolated, but ran into problems trying to use the dropdown in the DMA (?) section as the corresponding areas were not listed there.
Do you have a step by step for replacing the existing teams with fictional teams, but with real market locations? Thanks in advance. FWIW, I'll give you one example. Bridgewater, IA. I'd probably use the Des Moines area data as it's the largest metro area, but how would I complete the process?
__________________
"Try again. Fail again. Fail better." -- Samuel Beckett _____________________________________________ |
10-12-2009, 02:46 PM | #6 |
Hall Of Famer
|
You have to use the drop down to find the metropolitan area you're looking for in terms of population and TV market size. It's really not a particular super great tool for people looking for small communities, in that, it was really designed for people operating MLB-like leagues trying to get fairly realistic market data for the years. The TV market data is only real world, I couldn't go back and do it for the past, because well...it'd have been a lot. So, instead, the only thing that alters backwards is the population stuff.
But yeah, the only information/cities in the tool are metropolitan areas, so you usually have to search for the MSA that city is within in order to get a good gauge of what to do. Another idea is to perhaps use a percentage, so if a particular area is a 10, then make it a 5 to simulate the smaller area you've chosen. Hope that helps a little bit. |
10-29-2009, 03:18 AM | #7 |
Hall Of Famer
|
I've updated GMeXcel to a new version called GMeXcel Suite v10.5
It comes equipped with a few tools: MarketCalc 10 helps you figure out modern media and TV market numbers. It's not particularly useful for using it for anything other than modern numbers, though it will adjust market size numbers backwards for older years, it's really a modern tool meant for a modern age. FireMGR is a ultimate solo management tool. Instead of jumping from team to team across your career or staying in a job well after you've stunk up the joint, FireMGR forces you to win or go home. When your Owner Confidence score is lower than zero, you have to fire yourself. A great new way to keep your solo games interesting. NEW! Accountant X: This is a return to MarketCalc's roots. I've integrated the MarketCalc 8 historical tool into the modern suite of GMeXcel with some improvements. Accountant X will revive your solo play by giving you a budget and cash to work with annually, which factors in your market size and team success. Best of all, Accountant X works for every year from 1901 until 2100! You just enter the year you want to play into the AcctXYear tab and the numbers will automatically adjust for the proper generation. (Props to ctorg for building this functionality into MarketCalc 8.) If you've already used the latest edition of GMExcel, then this is just like it, but with all of the updates to FireMGR and the new addition of Accountant X, that has a ton of improvements from the old version that was released probably about two years ago now. Let me know if you have questions and enjoy! Last edited by darkcloud4579; 10-29-2009 at 03:35 AM. |
10-29-2009, 10:59 AM | #8 |
Hall Of Famer
|
I managed to screw up something that you can fix yourself. I put WIN PCT, LAST YEAR AND 2 YEARS AGO, but the actual figure is wins, not win percentage. So you shouldn't input a % because it'll still work, but it won't work how it's intended.
__________________
Godfather of Fast-Sim OOTP My Mods: GMExcel 24 Major League Women's Baseball (OOTP24) quickstart Indian Premier League | 300+ years of baseball quickstart | Expatriate League quickstart | Off-Field Injuries Update | Women's Name File for OOTP | My (outdated) market calculator & financial spreadsheets |
11-03-2009, 02:28 PM | #9 |
Hall Of Famer
Join Date: Sep 2008
Location: with my army of orangutans
Posts: 2,943
|
Can the FIREMGR file be configured for a schedule other than 162 games?
__________________
Last edited by damientheomen3; 11-06-2009 at 11:13 PM. |
11-03-2009, 09:34 PM | #10 |
Hall Of Famer
Join Date: Sep 2008
Location: with my army of orangutans
Posts: 2,943
|
Another question. Is it possible to extend the FireMGR slots to more than 24?
__________________
Last edited by damientheomen3; 11-06-2009 at 11:13 PM. |
11-11-2009, 02:39 AM | #11 | |
Hall Of Famer
|
Quote:
So it might be a week or might not be until OOTP XI. Just depends on my motivation to figure it out. I've attached a new copy for you that has more than 24 slots. Now there should be +/- 100 slots. Last edited by darkcloud4579; 11-11-2009 at 03:20 AM. |
|
11-12-2009, 05:59 PM | #12 |
Hall Of Famer
|
Ok, I've made an update that should solve your problem though it's just a bandaid.
This new version has another tool called WINEQ which will take your win pct and turn it into a win total that you can then use in the FIREMGR to equiv. the number of wins you'd have in the normal 162-game setup that I originally based this off of. Should help a bit. Last edited by darkcloud4579; 11-14-2009 at 04:27 PM. |
11-14-2009, 04:47 PM | #14 |
Hall Of Famer
Join Date: Apr 2008
Posts: 2,464
|
Thank you for this. As I'm trying to advance the financial aspect of my Pastime Baseball League, this is a welcome tool.
|
11-14-2009, 07:32 PM | #15 |
Hall Of Famer
Join Date: Sep 2008
Location: with my army of orangutans
Posts: 2,943
|
whenever I enter a value in the WINswap section, the can/no section always says no
|
11-20-2009, 08:38 PM | #16 |
Hall Of Famer
|
I found a math problem with my initial calculation that apparently gets out of whack over time or if you do certain kinds of scenarios. I need to fix the tool completely it seems. I'm working on it.
__________________
Godfather of Fast-Sim OOTP My Mods: GMExcel 24 Major League Women's Baseball (OOTP24) quickstart Indian Premier League | 300+ years of baseball quickstart | Expatriate League quickstart | Off-Field Injuries Update | Women's Name File for OOTP | My (outdated) market calculator & financial spreadsheets |
11-21-2009, 05:26 PM | #17 |
Major Leagues
Join Date: Mar 2002
Location: GA, USA
Posts: 453
|
Apparently I am getting something wrong. Trying to use Marketcalc, and it is giving me some numbers as high as 74 for Market Size, while the game tells me that the market size # should be between 0 - 20.
|
11-24-2009, 11:55 AM | #18 |
Hall Of Famer
Join Date: Apr 2008
Posts: 2,464
|
What does the Bandwagon number mean? Am I supposed to enter that somewhere?
|
11-29-2009, 03:18 AM | #19 |
Minors (Double A)
Join Date: Oct 2002
Location: Terrapin Station
Posts: 112
|
Is the formulas under 'bandwagon' correct?
What i see now is Code:
=(3*B4+2*B5+B6/6) Did you mean to take 3*B4 + 2*B5 + B6 And then divide all of that by 6 to get it back to an average win per season weighted towards the most recent season. Currently, it just takes the 3 years ago wins and divides them by 6 and then adds that to 3*current wins and 2* last years wins. That just looks odd to me, but then I don't know what you were trying to do with this. And I guess some more instructions might help. Why are there two teams listed in ACCTX? Is that workspace for two teams? Or, am I supposed to enter my team in one and some other team in the other area? Or just use one of the areas for my team and ignore the other one? |
12-21-2009, 06:33 PM | #20 |
Hall Of Famer
Join Date: Apr 2008
Posts: 2,464
|
Am I correct that after first doing this for the teams I don't have to run it each yet to reset the budget? Or should be running this to establish the budget at the end of each season?
|
Bookmarks |
|
|