Home | Webstore
Latest News: OOTP Update 20.8 - OOTP 20 Available - FHM 6 Available


Go Back   OOTP Developments Forums > Front Office Football > FOF - General Discussions

FOF - General Discussions Discuss the upcoming Front Office Football by OOTP Developments here.

Thread Tools
Old 11-25-2019, 08:26 PM   #1
Bat Boy
Join Date: Jan 2019
Posts: 5
Thanks: 0
Thanked 7x in 2 posts
Football sim modding tool: The Squeakquel

Dear god, what have you done this time?

Excel file (25MB) download link: https://drive.google.com/open?id=1s9...WcfJNFYSBG-pxx

I know, I know. I probably should have stopped, but I didnít. After putting together all of the biographical information in my previous version (seen here) I have gone through it again, line by line (now 23,459 records), correcting for errors and adding player ratings. Thatís right, all players between 1983 and 2018 now have CORRECTED SPEELLING! And a potential rating based on a byzntine mix of their career statistics, draft position, college career, assumed potential, what I can remember about them, any injury derailment, draft profiles I could find and how much I liked their names (You better believe Prince McJunkins and Kai-Erick Lyck got a little boost). Keep in mind this is a potential rating at time of draft, so I had to balance how the player was seen coming out of college with how well he did after that. Injury proneness ratings are included, but they are separate from skills. For example players like Ki-Jana Carter are going to be rated pretty highly compared to their career output, but are very likely to miss significant time to injury. Donít like how I rated them? Think that Tom Brady deserves to have 99s all across the board? TOO BAD!

And by TOO BAD I mean I went ahead and built an automatic ratings adjuster I call the Calculatrix. Just change the number in the ďRatingĒ column, and the She-Devil of Numbers will recalculate all of the players skill ratings, and add some randomization for spice. Players are also defined by several archetypes, IE, QBs can be game managers or long bombers, allowing for a little more customization. Donít like how I calculated the ratings difference between a bomber and a manager? Change it yourself, Iím not your dad! Seriously though, those formulas are set up so you donít have to dig into the weeds to change the relative skill of every long bomber in the league.

Currently, though, the roles are hardcoded to each player. So if for whatever reason you wanted to change Trent Dilfer from a game manager to a long bomber, itís a bit more complicated. Iíd love to have that be a one button push, but I canít think of a way to do that without a whole ball of If/Then statements. Maybe in Calculatrix 3.0.

What? How the heck do I use this? Oh. I guess you just change whatever data you might want to fiddle with in the ďPlayerDataĒ tab (though why you would do this is confusing, itís perfect as is). Then go to the ďFOF OutputĒ tab and enter the draft year you want to generate in the A1 space. Calculatrix will do her sexy Dance of the Seven Formulae and there you have it. Cut and paste this into a CSV file (being sure to remove the top row and the ID column) and youíve got a draft class ready for import into Front Office Football.

Weaknesses and flaws? Oh boy I got em.

There arenít quite enough players per draft class just yet, at least in a way that FOF likes it. I mean there are, but there arenít. As is, Iím averaging somewhere between 600 and 700 prospects per class, and I want that to be above 800. Iíve added some AFL players, but Iíll maybe need to add more (and some college guys who never played pro) to get those rookie numbers up. If you run draft classes out of what I have now, you might end up with too few long snappers in some years.

Just like my last release, my info is only as good as my sources and my brain, which are both well past their warranty. Also Calculatrix doesnít watch football, so individual ratings on some players might not pass the sniff test (IE, Peyton Manningís scrambling ability will seem abnormally high because itís based on his QB ability rating times a standard modifier. We all know Peyton was not a standard scrambler.) She also only rates players based on their primary position, so players who are crap at receiver but excellent return men have to be manually accounted for and players who have switched positions or have a secondary position are also not dealt with. My plan after this is to put Calculatrix through her paces (when the wife isnít watching) to make my own custom draft classes with the players I know better given more carefully curated ratings.

The 2019 draft class remains incomplete. Bio data is in there, but I havenít rated most of them yet. Itís also not big enough, so Iíll try to add all of the UDFAs that are playing this season. I figured Iíd give them all at least a year before dooming them, but youíre not required to be so kind.

Positional rating balance was only considered internally, meaning when I rated Willie Roaf, I rated him against the likes of Walter Jones, Bryan Bulaga and Marvel Smith. I did not consider the rating of Neil Smith or Warren Sapp. My hope is that equivalently rated players of different positions will match well head on, but Iíll have to do some playtesting to see if that means Iím in for seasons with 10 or 1000 total sacks per team. I also did nothing to balance ratings for each seasonís draft, but I think that is how it should be. 1996 is going to be great for WRs, but bull**** for QBs, etc.

From a programming standpoint Iíve tried to toe the line between ďBlack-box, donít touch ANYTHINGĒ and ďGet your hands dirty and change stuff if you wantĒ to a useful happy medium, and hopefully nothing is broken. Iíve left comments in the excel sheet to guide users, but if you donít have any idea how Excel works maybe just stick to the inputs and outputs. Well, I guess thatís it. 2,000 hours of my life, frittered away. Have fun! Or donít. As stated before, not your dad.

Warning: Calculatrix is a thirsty lover, and I recommend running your Excel calculations (Options>Formulas>Calculation options) in manual mode or else the RNG will recalculate every time you make a change. At around 40-50 formula per player, weíre looking somewhere in the neighborhood of a million calculations every time you change something.

Double Warning: Calculatrix is untested on 99.9999999% of computers, so there is no warranty, stated or implied. Just hope I got everything right, ok?
Wudu44 is offline   Reply With Quote
2 thanks for this post:
gbmoore121 (12-03-2019), Hootowl9 (12-02-2019)


Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

All times are GMT -4. The time now is 02:06 AM.


Major League Baseball trademarks and copyrights are used with permission of MLB Advanced Media, L.P. Minor League Baseball trademarks and copyrights are used with the permission of Minor League Baseball. All rights reserved.

The Major League Baseball Players Association (www.MLBPLAYERS.com ) is the collective bargaining representative for all professional baseball players of the thirty Major League Baseball teams and serves as the exclusive group licensing agent for commercial and licensing activities involving active Major League baseball players. On behalf of its members, it operates the Players Choice licensing program and the Players Choice Awards, which benefit the needy through the Major League Baseball Players Trust, a charitable foundation established and run entirely by Major League baseball players. Follow: @MLB_Players; @MLBPAClubhouse; @MLBPlayersTrust

Out of the Park Baseball is a registered trademark of Out of the Park Developments GmbH & Co. KG

Google Play is a trademark of Google Inc.

Apple, iPhone, iPod touch and iPad are trademarks of Apple Inc., registered in the U.S. and other countries.



Powered by vBulletin® Version 3.8.10
Copyright ©2000 - 2020, vBulletin Solutions, Inc.
Copyright © 2020 Out of the Park Developments