CSV to HTML Box Score Converter

[daigle91]

update... added (3) more stats to the 3-Star stats player pop-up.
- 3-Star selection Pct. (3-Star GP/all GP).
- most Stars vs one team.
- most Stars in a month.

[sgrondin98]

Nice good addon to your tool. Im still using your tool and im waiting the 0.60 update with all the big addon

Great job nice to see someone who want to help admin to have a tool to help

thank you.

[daigle91]

Originally Posted by sgrondin98

Nice good addon to your tool. Im still using your tool and im waiting the 0.60 update with all the big addon

Great job nice to see someone who want to help admin to have a tool to help

Glad to hear it is helping you. Still no ETA yet for 0.6b, but the to-do list is getting smaller.

Originally Posted by sgrondin98

thank you.

Your welcome

[hurricanekevin]

Very very cool! Good work!

[daigle91]

Originally Posted by hurricanekevin

Very very cool! Good work!

Much appreciated.

With these new stats (and various others), version 0.6b will offer a whole new lens from which to evaluate your league's players and teams.

[daigle91]

update... here is the new and improved final layout for the main roster page in its entirety.

changes from version 0.55b,

- team record now displayed.
- players in top 10% of league (TP) now have their rank highlighted.
- 2nd player in scoring on a team will show a gap difference (both % and TP) behind the top scorer if greater than 20%.
- players who have played (or goalies who have played/dressed) for all of their team's games have their GP stat highlighted.
- new stats for goalies: GS (games started), GSb (games started as backup), cGP (complete games played), sGP (split games played), GD0 (games dressed with 0 minutes played), P (games pulled), TGD (total games dressed), EN (empty net goals).
- goalies TOI format now matches the skaters TOI format (MM:SS).
- FO% and Offensive/Defensive ratings are now highlighted for better viewing.
- players not currently on the roster but who have played at some point during the season, are now visible (and highlighted).
- realignment of HTML tables (column widths are now locked).

click image to enlarge

[sgrondin98]

Fantastic

Im not sure if i alreay ask you this but if i have a AHL league is it possible to have the same stats/info for my AHL or its for the NHL league only ??

[daigle91]

Originally Posted by sgrondin98

Fantastic

Im not sure if i alreay ask you this but if i have a AHL league is it possible to have the same stats/info for my AHL or its for the NHL league only ??

Yes, that will definitely work. In fact it will work with any non-NHL league that has a schedule (pre-season, regular season, or playoffs) in the schedule.csv file. I have tested it in a large setup of 25 leagues, and they all work great. The only limitation is with prospect tournaments, which have do have schedules in the schedule.csv file, but don't have any exported box score data (for those games, the converter will show results and standings only).

[daigle91]

update... added option in config.txt for adjustable leaderboard sizes (attached image shows option for all goaltenders).

click image to enlarge.

[sgrondin98]

Yesssss good news.

Another question: Is it possible to get the stats/team reports from season #1 to actual season ?

Like this: HF20_reg_35-36_Leaderboards_Seattle_Kraken

But i want to know if i can have these reports but from season to season

Like this: HF20_reg_20-21_Leaderboards_Seattle_Kraken
Like this: HF20_reg_21-22_Leaderboards_Seattle_Kraken
Like this: HF20_reg_22-23_Leaderboards_Seattle_Kraken

???

[daigle91]

Originally Posted by sgrondin98

Yesssss good news.

Another question: Is it possible to get the stats/team reports from season #1 to actual season ?

Like this: HF20_reg_35-36_Leaderboards_Seattle_Kraken

But i want to know if i can have these reports but from season to season

Like this: HF20_reg_20-21_Leaderboards_Seattle_Kraken
Like this: HF20_reg_21-22_Leaderboards_Seattle_Kraken
Like this: HF20_reg_22-23_Leaderboards_Seattle_Kraken

???

I could put an option in the config.txt file where you could choose how many seasons worth of leaderboards (team and league) you wish to have access to from the current season.
Great idea, I will see what I can come with.

[daigle91]

Originally Posted by sgrondin98

Yesssss good news.

Another question: Is it possible to get the stats/team reports from season #1 to actual season ?

Like this: HF20_reg_35-36_Leaderboards_Seattle_Kraken

But i want to know if i can have these reports but from season to season

Like this: HF20_reg_20-21_Leaderboards_Seattle_Kraken
Like this: HF20_reg_21-22_Leaderboards_Seattle_Kraken
Like this: HF20_reg_22-23_Leaderboards_Seattle_Kraken

???

The attached image shows optional hyperlinks added to the bottom of the page for access to team roster stats for previous seasons if selected in the config.txt file (the same can be done for league leaderboards as well).

[sgrondin98]

You have done it

Yessss

Thanx i can dl the new tool and i will have this option in your config.txt files

Many thanx for this its going to help me a lot.

[daigle91]

Originally Posted by sgrondin98

You have done it

Yessss

Thanx i can dl the new tool and i will have this option in your config.txt files

Many thanx for this its going to help me a lot.

Your welcome, and many thanks for the great idea.

I also implemented this option for standings as well,

[sgrondin98]

Another great addon.

You are a genius

Again thanx for all the great works.

0.6 will be HUGE !!!

[daigle91]

Originally Posted by sgrondin98

Another great addon.

You are a genius

Again thanx for all the great works.

0.6 will be HUGE !!!

many thanks sgrondin98.

update... added projection stats to the export roster page. The projection stats are calculated using the player's export stats if available, or else with their full season stats if export stats are not available.
The attached example takes advantage of the recency bias of export stats, and projects them upon any remaining games in the season that a player has left, then adding those totals to the player's current stats. For improved accuracy I set a minimum required sample size of 8 GP worth of export data, or else the converter will fall back to using whole season averages to make the projection. If export stats are available, but a player hasn't played a game during that time frame, the converter will use their current stats as their projected stats (see Bobby Schmautz, and Howie Menard in the attached example).

[daigle91]

Updated the new box score layout.

[daigle91]

Originally Posted by JeffR

The first content update for FHM11, version 11.2.31, has just been released.


-in the csv exports, we've added to player_master.csv a "Rookie" column, that's set to 1 if the player meets the "rookie" qualifications for the league he's currently in (as defined in the rookie option for the search filter) or 0 otherwise (or if he doesn't have a league)

Implemented this into the converter, many thanks.

Originally Posted by JeffR

-the Central Hockey League is now playable in historical mode.

Great league to add, used it for the attached example

click image to enlarge

[daigle91]

update... added some basic series commentary to the box score reports.

As well, the converter is now able to adapt to multi length series within a playoff season if any (for example, playoffs start with a best 2 of 3 in the 1st round, and then changes to a best 4 of 7 format for the finals etc.). It even works with the early era, two-game, total-goals type series.

[daigle91]

update... added some more stats to the player's 3-Star pop-up,

3-Star, non-3-Star,
- TOI, +/-, shots, game rating

3-Star analytics,
- Shot quality average (Shot attempts)
- Shots/Shot attempts %
- Shots attempts/GP, Shots/GP
- 3-Star TP/GP to non-3-Star TP/GP ratio

In the example below, Gretzky's average TOI spiked by almost two minutes for games in which he was given a 3-Star selection.