Quote:
Originally Posted by weeqat
1st off, I'll echo everyone else to say thanks for the great work on this!
|
Many thanks
Quote:
Originally Posted by weeqat
I'm trying to use FHM for an offline league where I sim and upload all the results to a site using the converter, and we plan to do an inaugural draft so I want to give everyone a single spreadsheet to use for the draft. Problem is, none of the csv files that the game exports have the calculated "ability" rating for each category (mental/physical/offense/defense), just the individual component ratings.
I'm wondering how you were able to capture those top-line numbers, did the developers give you access to hidden tables, or (more likely, since the html coding is being done on the user device rather than a server where you could do a lookup) they must have shared the formula for weighting those component numbers to derive the total ability score?
I suppose I could unlock it via trial and error by editing a player category by category to see by what factor the overall number changes, but I'm already working way too hard on this ;-), so if you don't mind letting me know how the secret sauce is made it would be a big help. Thanks!
|
The ability ratings the converter uses are a very close approximation, as (like you mentioned) they are not in the CSV exports. If they become available in a future version I will update the converter to use them, and leave in the current solution as a fall back, to support prior versions. I did something similar with goaltender game starts which are now available in FHM 11 CSV exports. For prior versions (7 to 10) I came up with a solution to calculate game starts from box score data.
For all of the ability totals (mental, physical, offence, defence), the converter simply adds all of the individual category ratings together and then multiplies that total by 7.1 to get the ability. For the goalie ability total, 4.6 is the multiplier (exact ability totals are only available within FHM).