CSV to HTML Box Score Converter

[daigle91]

Originally Posted by drummerJ99

Awesome stuff as always. Only addition that I'd like to see added if possible would be team records in the box scores.

Originally Posted by sgrondin98

Good point drummer good addition.

Thanx for your reply i appreciated that you are listening us.

My league want to thanx your for your good work they all love the new tool you have made.

I am glad you like it, and many thanks for all the great ideas

I was working on a couple of box score variants a while back that had team records listed, which will definitely be in version 0.6b . This one here I will expand upon and put in the series record between the two teams (great for playoffs) as well as their league record with overall ranking (will also add GF, GA).

[daigle91]

for version 0.6b I thought it would be fun to add a hockey card option to the menu (an alternate way for viewing team rosters). The sample I created below is a hybrid photo/Blender rendering (with the font work, the merging of the head photo to the rendered jersey from Blender, done in my graphics editor). Inspired by the 'tallboy' cards from the 1960's (credit to Wabba for the jersey/logos).

(Click image to enlarge)

[sgrondin98]

Its a good idea before i choose my players bio/stats age

http://hf.hockeyhq.net/HockeyFederat...ieDarwitz.html

http://hf.hockeyhq.net/HockeyFederat...Draisaitl.html

I was looking for a hockey card style with all info but it was very complicated and i opt for my bio/stats pages.

But good idea

[daigle91]

update... implementing team records and season series records into the box score report. After the regular season is complete, Season Series will switch to Playoff Series. Made some changes to the color coding for shot quality, penalty minutes, and milestones like 50 goals etc. Introducing rare event tags via braces or "curly brackets"... { clutch } for clutch goals (various criteria), { 9 } for Gordie Howe hat trick (tag assigned to whatever the last fulfilled requirement for the trifecta was... goal, assist or fight).

[drummerJ99]

Originally Posted by daigle91

update ... implementing team records and season series records into the box score report.

Awesome stuff as always!

[daigle91]

update... tweaked the lower section of the box score report. The 3 Stars of the game are now aligned horizontally. Added highlighting to a few stats that surpass a certain threshold.

Shots/ShA >= 65% (this is a new stat)
SQA >= 1.8
SA/60 >= 50
QoO >= 100 (opposing SQA x SA/60, only viewable if goalie faced all opposing shots)
Rating = 100

[daigle91]

version 0.51b is now available for download.

[drummerJ99]

So a very weird game just happened for me. A total of 12 goals scored with all 4 goalies getting playtime. I'm pretty sure I know who started for each team but if possible would be nice to add that to the boxscore for the odd chance games like this happen.

[daigle91]

Originally Posted by drummerJ99

So a very weird game just happened for me. A total of 12 goals scored with all 4 goalies getting playtime. I'm pretty sure I know who started for each team but if possible would be nice to add that to the boxscore for the odd chance games like this happen.

That's a great idea, I will implement that in the next version
(will also add which goaltender got the Win and which got the Loss).

[sgrondin98]

I will test the new version on the next season

But thanx again for the updates and can i ask you what are your next idea/plan for the futur ?

[daigle91]

Originally Posted by sgrondin98

I will test the new version on the next season

But thanx again for the updates and can i ask you what are your next idea/plan for the futur ?

I am currently working on an optional add-on program for the converter that will allow it interface with a mini screen/POS display, that will display all of the stats from the Box Score Converter.

[sgrondin98]

Look cool old school retro style.

Can i propose you some idea of what i want and maybe some other will give you some idea too ?

Thanx for your answer.

[daigle91]

Originally Posted by sgrondin98

Look cool old school retro style.

Can i propose you some idea of what i want and maybe some other will give you some idea too ?

Thanx for your answer.

That would be great

[daigle91]

Originally Posted by drummerJ99

So a very weird game just happened for me. A total of 12 goals scored with all 4 goalies getting playtime. I'm pretty sure I know who started for each team but if possible would be nice to add that to the boxscore for the odd chance games like this happen.

Looked into this, and noticed starting goalies, Win/Loss info is not exported in the boxscore_goalie_summary.csv.

However it can be deduced by looking at the goalies TOI and seeing if the opposing team scored at that time because that's typically when a goalie would be pulled (an injury would be another possibility).

So upon first inspection of your example, it would appear that both Dan Cloutier and Curtis Sanford were the starting goalies (based initially on their very low SV% and very high GAA)

To confirm that, I would have the converter check that VAN scored at 19:55 of the 1st period, and CBJ scored at 6:51 of the 3rd period (however, goalies being pulled for an extra attacker on a delayed penalty, would throw this reasoning off, as their TOI will no longer match the time of an opposing team's goal)

[drummerJ99]

Originally Posted by daigle91

Looked into this, and noticed starting goalies, Win/Loss info is not exported in the boxscore_goalie_summary.csv.

However it can be deduced by looking at the goalies TOI and seeing if the opposing team scored at that time because that's typically when a goalie would be pulled (an injury would be another possibility).

So upon first inspection of your example, it would appear that both Dan Cloutier and Curtis Sanford were the starting goalies (based initially on their very low SV% and very high GAA)

To confirm that, I would have the converter check that VAN scored at 19:55 of the 1st period, and CBJ scored at 6:51 of the 3rd period (however, goalies being pulled for an extra attacker on a delayed penalty, would throw this reasoning off, as their TOI will no longer match the time of an opposing team's goal)

Not a big deal either way, didn’t know if the box score csv exported that. I mean that situation rarely happens as it is. If I was simming in classic I could look at play by play log but with 2d it doesn’t save one for some reason.


Sent from my iPhone using Tapatalk

[daigle91]

Originally Posted by sgrondin98

You can take a look at the forum and all the stats- rosters etc... link on the top of the forum

https://www.hockeyfederation.com/

Great job integrating the converters output into your website

It looks like I need to add an additional option in the config.txt to accommodate for multiple domain names so the [ Home page ] link will work under that scenario.

[sgrondin98]

Lolol no thanx to you to gave us this nice tool to use for our league.

Here are some idea some people ask me

- Roster with evolution like green if an abilities upgrade and red if something downgrade like Passing 16 - 17

- With your DB have access to a page where we can search player if hes playing and is yes in which team he his.

- Career stats for players and for teams. Like in your roster page you have a link to the player card or player abilites page with his career stats , actual stats and which team he play. Same as if you go like in thew standings page if you click on a team you have access to the career victory - defeat - points and actual season.

- Records stats for players and for teams

At this moment the DG in my league ask for this....

Thanx again and have a great week-end.

[drummerJ99]

Would it be possible for to add a 5 day sim option? Or even the ability for it to be X and us to fill it out how many days? The old league I was in was 7 day sims, my new one is 5. I can always just copy the html to excel and remove stats form any games played on the two days that were actually part of the last sim. But figured I'd ask.

But I kinda got spoiled with the converter, so now I'm lazy. LOL

[daigle91]

Originally Posted by sgrondin98

Lolol no thanx to you to gave us this nice tool to use for our league.

Here are some idea some people ask me

- Roster with evolution like green if an abilities upgrade and red if something downgrade like Passing 16 - 17

- With your DB have access to a page where we can search player if hes playing and is yes in which team he his.

- Career stats for players and for teams. Like in your roster page you have a link to the player card or player abilites page with his career stats , actual stats and which team he play. Same as if you go like in thew standings page if you click on a team you have access to the career victory - defeat - points and actual season.

- Records stats for players and for teams

At this moment the DG in my league ask for this....

Thanx again and have a great week-end.

I will have some of this in the next major update (ver. 0.6b).
This update is also going to have another box score style... many thanks to landru22 for permission to include an exact replica from the FHM7 html Boxscore Creator.

Originally Posted by drummerJ99

Would it be possible for to add a 5 day sim option? Or even the ability for it to be X and us to fill it out how many days? The old league I was in was 7 day sims, my new one is 5. I can always just copy the html to excel and remove stats form any games played on the two days that were actually part of the last sim. But figured I'd ask.

But I kinda got spoiled with the converter, so now I'm lazy. LOL

I am going to do a minor update soon (ver. 0.52b), so I will put that option in.

[daigle91]

update... here is what the color coded points per game (TP/GP) stat looks like (blue is for improvement, red is for a decline),