CSV to HTML Box Score Converter

[weeqat]

1st off, I'll echo everyone else to say thanks for the great work on this!

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!

[daigle91]

Originally Posted by weeqat

1st off, I'll echo everyone else to say thanks for the great work on this!

Many thanks

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).

[weeqat]

Got it, thanks! That's exactly what I needed.

[daigle91]

update... added home/away stats for players.

[daigle91]

update... added shifts, shifts/GP, shift length, OZ starts, NZ starts, DZ starts to the player pop-up.

[daigle91]

Originally Posted by sgrondin98

1- Most important for me i have the same idea of seeing the up and down with the color of the ability but if its possible to have all the info on 1 page because right now you have to click on every player to see if he up or drop on his ability...

update... started working on this

[sgrondin98]

OMG

Another great option to have And thanx for that.

I know a ask you a lot of thing , i give you idea but maybe some other members have some idea too ?

Thanx a lot again again and again lololo

[daigle91]

Originally Posted by sgrondin98

OMG

Another great option to have And thanx for that.

I know a ask you a lot of thing , i give you idea but maybe some other members have some idea too ?

Thanx a lot again again and again lololo

Many thanks for your great ideas

update... added two new options in the config.txt file (for version 0.7b).

- build_website=2, when building a website, this option will cut the overall conversion time in half, as local .html files will not be built.

- expanded_highlights=1 (for hits, SB, GvA, TkA, and FO%). GvA and TkA highlights are based on ratios against each other, rather than in a per GP format (RED indicating if a player is giving away the puck considerably more than taking it away, and GREEN indicating if a player is taking away the puck considerably more than giving it away).

[sgrondin98]

Yes it take me about 45min to update everyday lolol its goig to cut half of the time

- build_website=2, when building a website, this option will cut the overall conversion time in half, as local .html files will not be built.

[daigle91]

update... added a newspaper box score style, where all daily box scores are on the same page for quick viewing. It has a monochrome newsprint color scheme with highly compact box scores (scaled down font size, and just the basic stats). They are accessible from a new hyperlink on the league's Schedule/Results page. Added support for a multi-column (1, 2 or 3) newspaper layout in the config.txt file.