Double header drafts tonight! S55 VHLM Draft at 9 EST and the S55 VHL Entry Draft at 9:30 EST.

Sign in to follow this  
Followers 0
Victor

VHL Career Stats (Updated for S54)

95 posts in this topic

Mike did as a one off and doesn't intend to again. Higgins said something vague to me about a month ago and then I left.

Share this post


Link to post
Share on other sites

Hey yo, these are updated!

 

I only did the skaters, though. I don't know who gets the credit for having updated goalie stats, but my guess is that it was Higgins.

Edited by Hustles
Higgins and Strtlght like this

Share this post


Link to post
Share on other sites

Yes I believe it was Higgins. He's also better aware than me probably if the current TPE payout for this.

Mucho gracias however, much appreciated.

Share this post


Link to post
Share on other sites

Who usually does this and how?

I had been the one who did it for a while, then I stopped being active so I didn't care as much. If you're still curious about how, I'll inform you of my process, step by step (which takes about 1-1.5 hours per update; note: that isn't per season, so if I update multiple seasons at once, it's not much longer of a process).

 

Short version: Make a .csv file with the stats to be updated, import that file into a spreadsheet, and combine the numbers that need to be combined.

 

More detailed version:

 

1) Copy the stats from the team scoring page and make a .csv file that looks like thisIEi05fe.png

2) Import that file into a spreadsheet

3) Remove all the shitty stats and align the columns so they match up with the career stats

4) Copy/paste those numbers into the career stats file as new rows

5) Sort the stats by name so duplicates will be next to each other

6) Add a row beneath any player whose stats need to be combined (previous stats+any new stats from seasons being updated)

7) Add the rows for each player, deleting the text in the first name cell for all rows that will have incorrect stats (either the rows from the previous file or the seasons that are being added)

8) Copy all the cells and paste values only

9) Sort by first name in order to bunch together all of the rows that need to be deleted. Proceed to delete said rows.

10) Recalculate the points/game and minutes/game, because those can't simply be added. This could be done earlier, I just choose to do it at this point....at least I did this time, but I think it'd be more efficient to do it earlier when you are adding the rows.

11) Copy/paste the new stats into each sheet and sort

 

That's how.

Edited by Hustles
Victor and Strtlght like this

Share this post


Link to post
Share on other sites

Hmm, Chekhov was actually my best goalie stat wise. I figured it would be Young. Guess he didn't play quite as well as I remembered.

Share this post


Link to post
Share on other sites

Why not both?

What are the benefits for you? Cause there's definitely none for me.

1) Easier to see active career leaders and stuff

2) I don't have to work in spreadsheets that are hundreds of rows large

 

Ultimately, I don't know if it will be more or less work for me, and maybe if I realize it's not working out I'll change it back.

Edited by Streetlight

Share this post


Link to post
Share on other sites

Nah, actually I changed my mind. I'm not going to do it. I hate going through and re-sorting all the tabs, and this would just make me have to do that two times. And if Victor doesn't think having active players in their own spreadsheet, then I guess it's not worth it.

Share this post


Link to post
Share on other sites

I felt defencemen didn't get enough love around here so I made a separate spreadsheet just for them (in OP and here: https://docs.google.com/spreadsheets/d/1gCAmcJIqYzrkq8CrpRauI9DmmJAbdm9xC6aAzpEUAgw/edit?usp=sharing)

Obviously bulk of the work done by Streetlight, I just copied those who were defencemen.

I may have missed some, I also didn't do all, and will update more active players in when they get more seasons in.

Was surprised to find Low has the best point-per-game ratio by any dman ever.

Share this post


Link to post
Share on other sites

Scott Boulet 2? :/

When I update for S42, I'll fix it so Scott Boulet 2 is correctly identified as the shitty second coming of Scott Boulet.

 

S41 is updated though. Regular season and playoffs for skaters and goalies.

Victor likes this

Share this post


Link to post
Share on other sites

Hoping to make the hof again this time around I have an outside chance of getting the shutout record but shutouts are way down this season.

Share this post


Link to post
Share on other sites

Hoping to make the hof again this time around I have an outside chance of getting the shutout record but shutouts are way down this season.

You and Wahl should also finish with 300 wins and every goalie with 300 wins is in.

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!


Register a new account

Sign in

Already have an account? Sign in here.


Sign In Now
Sign in to follow this  
Followers 0