Login

Blastmeaway · 06-18-2019, 04:30 AM

In the spirit of trying to show some of what goes on in the updating world of the SHL. Back in S42 @Dude and I developed a Spreadsheet to help fast track updating. While some things have changed from the users perspective, like The Marius Rule. Some things have not changed like updating a whole season’s worth in an update, if you do this please try not to do this during the offseason. The offseason is our busiest time between assisting new users learn the ropes, regression, and 22.80-31.18% of the total updates done over the course of the season.

Prior to S44, the way that updates were process with the updaters looked something like this:

Code:
Tigole Bitties - C

PH = Puck Handling: 98

Wyatt Wollker - D

CK** = Checking: 48

FG = Fighting: 26

DI = Discipline: 64

SK* = Skating: 93

ST = Strength: 89

EN = Endurance: 87

DU = Durability: 50

PH* = Puck Handling: 92

FO = Face Offs: 40

PA = Passing: 85

SC* = Scoring: 93

DF = Defense: 90

PS = Penalty Shot: 41

Teodors Cukurs - C

CK = Checking: 65

Chippy Chiclets - D

CK = Checking: 62

FG = Fighting: 25

DI = Discipline: 69

SK = Skating: 84

ST = Strength: 60

EN = Endurance: 80

DU = Durability: 50

PH = Puck Handling: 91

FO = Face Offs: 40

PA = Passing: 85

SC = Scoring: 99

DF = Defense: 90

PS = Penalty Shot: 40

Michael McFadden - G

PH = Puck Handling: 95

Cory Knouse - LW

CK = Checking: 63

FG = Fighting: 25

DI = Discipline: 67

SK = Skating: 99

ST = Strength: 90

EN = Endurance: 90

PH = Puck Handling: 90

FO = Face Offs: 53

PA = Passing: 99

SC = Scoring: 90

DF = Defense: 99

PS = Penalty Shot: 70

Nikolaus Scholz - C

CK = Checking: 40

FG = Fighting: 25

DI = Discipline: 62

SK = Skating: 90

ST = Strength: 90

EN = Endurance: 80

DU = Durability: 50

PH = Puck Handling: 90

FO = Face Offs: 90

PA = Passing: 95

SC = Scoring: 85

DF = Defense: 90

PS = Penalty Shot: 40

Theo Kane - RW

SC = Scoring: 93

Connor Tanner - D

PH = Puck Handling: 93

Teddy Cuddles - RW

CK = Checking: 72

FG = Fighting: 25

DI = Discipline: 62

SK = Skating: 90 

ST = Strength: 85

EN = Endurance: 80 

DU = Durability: 50

PH = Puck Handling: 88

FO = Face Offs: 40

PA = Passing: 91

SC = Scoring: 78

DF = Defense: 90

PS = Penalty Shot: 40

Tor Tuck - D

CK = Checking: 82

FG = Fighting: 30

DI = Discipline: 62

SK = Skating: 91

ST = Strength: 70

EN = Endurance: 80

DU = Durability: 50

PH = Puck Handling: 85

FO = Face Offs: 40

PA = Passing: 91

SC = Scoring: 82

DF = Defense: 94

PS = Penalty Shot: 40

Hercules Rockefeller - LW

CK = Checking: 40

FG = Fighting: 25

DI = Discipline: 62

SK = Skating: 86

ST = Strength: 85

EN = Endurance: 80

DU = Durability: 50

PH = Puck Handling: 85

FO = Face Offs: 40

PA = Passing: 80

SC = Scoring: 95

DF = Defense: 90

PS = Penalty Shot: 40

Brady McIntyre - D

CK = Checking: 40

FG = Fighting: 25

DI = Discipline: 62

SK = Skating: 86

ST = Strength: 81

EN = Endurance: 71

DU = Durability: 50

PH = Puck Handling: 90

FO = Face Offs: 40

PA = Passing: 81

SC = Scoring: 76

DF = Defense: 90

PS = Penalty Shot: 40

If a player updated only 1-2 stats we would only list those attributes, anything more and we had to list the entire set. The Simmer would then spend their sunday evening/monday morning inputting every single update for every single player.

With the development of the Spreadsheet we now use, the updaters copy your build over from your Player Page into the spreadsheet. Along with that there is a calculator that will calculate how much TPE you have spent on attributes. This will then compare it to the amount of TPE you have actually earned, it matches your Player Page.
[Image: 243RFFSD1.png?width=400&height=193]

[Image: 243RFFSD1.png?width=400&height=193]

As for the Simmer, their workload consists of simply downloading the ‘Ratings Page’, which is what STHS understands, as a Comma-Seperated Values (.csv). They then upload it into STHS for it to process and export as a Rating Pack. The Simmer, then uploads this file once again into STHS and then the Sim is updated with the weekly updates. This is why the IIHF Tournament now has the most recent updated before the start of the tournament. Acording to the former SHL & IIHF Simmer, her workload used to be 15-45 minutes a week depending on the amount of updates. With the new system it dropped to about 2 minutes.

Over my time spent on this site I have learned a tremendous amount about the power of spreadsheets. My main partner in crime at this point is the awesome @LukeTD. Together we have been collecting all sorts of data with the power of this spreadsheet.

Since S44, I have been keeping stats on how many players are being updated, each week and season. Over the last four seasons, 33 weeks, a cast of over 27 different users has process over 7,330 updates. Some of the longest working team members are guys like Tomen (S30-S35, S41-now), Zombiewolf (S36-now). Spartan Gibbles has been with the team since the last week of S45, he has racked up 723 updates in the last two seasons! Hell, even at one point Pingy was an updater, if this noot noot machine can understand it and help others, you can too. After being appointed as Head, after GCool decided to take a break from the site, I appointed ml002 as the Co. ml and Tomen are both absolute role models in the updating community and are also both quick to respond and help anyone with any sort of issue, not necessarily just updating. Coincidentally, they are Co-GMs of Division Rivals, Toronto & Buffalo.

User---------------Updated
BadWolf------------14
bbjygm-------------60
bk1689-------------599
Blastmeaway-----66
Bobby Watson----81
Citizen of Adraa--25
DanbyRem---------604
Dude-----------------13
eggy216--------------32
esilverm-------------314
Flareon4043--------329
GCool-----------------73
gillon------------------97
LukeTD---------------242
micool132-----------587
Mika_Kandinsky----22
ml002-----------------684
Nerio------------------185
Nictox-----------------270
pingypingu----------180
SlashACM--------------29
Snussu-----------------295
SpartanGibbles-----729
StamkosFan---------136
Tomen-----------------574
Tommysalami--------399
Zombiewolf-----------693

*Italics indicate current updater*

Below in the first group on the left is a breakdown by season at the number of teams, amount of players updated each week, the percent of players updated from the previous week, and lastly a look at the percentage of players updated that week from the whole season. The right three grouping columns these are broken down by difference in teams across those seasons, difference in players updated, percent of players updated in the later season vs the earlier season, and percent of the difference of the total players updated between the two seasons.

[Image: 243RFFSD2.png?width=400&height=276]

[Image: 243RFFSD2.png?width=400&height=276]

Sincerely,
Blast

Shout out to ml002, schultzy, slashacm, tedward!
[Image: blastmeaway.gif]

I

I

I

I

09-05-2018, 10:04 PMBeaver Wrote: Wow look what the PT affiliation has done to our pristine league.

12-19-2018, 12:31 AMBeaver Wrote: I personally blame the PT affiliation for handing out massive amounts of free TPE to all these players, inflating the TPE they're at when they get called up.

[Image: Capture21.PNG?width=400&height=90]

Flareon · 06-18-2019, 05:04 AM

06-18-2019, 04:30 AMBlastmeaway Wrote: Some things have not changed like updating a whole season’s worth in an update, if you do this please try not to do this during the offseason. The offseason is our busiest time between assisting new users learn the ropes, regression, and 22.80-31.18% of the total updates done over the course of the season.

Thanks blast and ml for your hard work at the head of this department!

***DrunkenTeddy*** · 06-18-2019, 09:47 AM

Damn, we need automated updates...

|

caltroit_red_flames · 06-18-2019, 10:23 AM

06-18-2019, 09:47 AMDrunkenTeddy Wrote: Damn, we need automated updates...

Maybe we should make a server with a bunch of programmers and start working on that

***luke*** · 06-18-2019, 10:42 AM

06-18-2019, 10:23 AMcaltroit_red_flames Wrote:
06-18-2019, 09:47 AMDrunkenTeddy Wrote: Damn, we need automated updates...

Maybe we should make a server with a bunch of programmers and start working on that

maybe you should send me the test site that you can test the automated updates in too

**.bojo** · 06-18-2019, 10:45 AM

06-18-2019, 10:42 AMluketd Wrote:
06-18-2019, 10:23 AMcaltroit_red_flames Wrote: Maybe we should make a server with a bunch of programmers and start working on that

maybe you should send me the test site that you can test the automated updates in too

Maybe even tie it into the banking system we got going on

caltroit_red_flames · 06-18-2019, 10:50 AM

06-18-2019, 10:42 AMluketd Wrote:
06-18-2019, 10:23 AMcaltroit_red_flames Wrote: Maybe we should make a server with a bunch of programmers and start working on that

maybe you should send me the test site that you can test the automated updates in too

You're gonna have to talk to Tedward about that

@DrunkenTeddy

caltroit_red_flames · 06-18-2019, 10:59 AM

06-18-2019, 10:45 AM.bojo Wrote:
06-18-2019, 10:42 AMluketd Wrote: maybe you should send me the test site that you can test the automated updates in too

Maybe even tie it into the banking system we got going on

And maybe add a trading card game to that?

Dude · 06-18-2019, 12:47 PM

06-18-2019, 10:23 AMcaltroit_red_flames Wrote:
06-18-2019, 09:47 AMDrunkenTeddy Wrote: Damn, we need automated updates...

Maybe we should make a server with a bunch of programmers and start working on that

Can't tell if this is a serious suggestion or a joke about the last time you tried getting a dev team together lol

Clint Eastwood, Jun 10 2018, 09:36 AM Wrote:Can't buy love, but love can buy a lot.

caltroit_red_flames · 06-18-2019, 01:24 PM

06-18-2019, 12:47 PMDude Wrote:
06-18-2019, 10:23 AMcaltroit_red_flames Wrote: Maybe we should make a server with a bunch of programmers and start working on that

Can't tell if this is a serious suggestion or a joke about the last time you tried getting a dev team together lol

It's already happening, you should see what's been done so far

SlashACM · 06-18-2019, 01:53 PM

06-18-2019, 01:24 PMcaltroit_red_flames Wrote:
06-18-2019, 12:47 PMDude Wrote: Can't tell if this is a serious suggestion or a joke about the last time you tried getting a dev team together lol

It's already happening, you should see what's been done so far

Bring back the NSHL

Bruins10 · 06-18-2019, 02:01 PM

Amazing insight on what its like to be on the updating team. I cant speak for everyone but for myself, i can definitely say that your work does not go unnoticed

I have worked in the past in sim leagues (the VHL as a commish and a GM) and now im a GFX grader here. I can see you guys work harder than what ive done in the past and the present

Props to the whole updating team, you do a wonderful job

Blastmeaway · 06-18-2019, 02:17 PM

06-18-2019, 12:47 PMDude Wrote:
06-18-2019, 10:23 AMcaltroit_red_flames Wrote: Maybe we should make a server with a bunch of programmers and start working on that

Can't tell if this is a serious suggestion or a joke about the last time you tried getting a dev team together lol

they're trying to run me out of a job.

[Image: giphy.gif]

Shout out to ml002, schultzy, slashacm, tedward!
[Image: blastmeaway.gif]

I

09-05-2018, 10:04 PMBeaver Wrote: Wow look what the PT affiliation has done to our pristine league.

12-19-2018, 12:31 AMBeaver Wrote: I personally blame the PT affiliation for handing out massive amounts of free TPE to all these players, inflating the TPE they're at when they get called up.

**.bojo** · 06-18-2019, 02:36 PM

06-18-2019, 02:17 PMBlastmeaway Wrote:
06-18-2019, 12:47 PMDude Wrote: Can't tell if this is a serious suggestion or a joke about the last time you tried getting a dev team together lol

they're trying to run me out of a job.

Believe in the SHL robot.

caltroit_red_flames · 06-18-2019, 02:43 PM

06-18-2019, 01:53 PMSlashACM Wrote:
06-18-2019, 01:24 PMcaltroit_red_flames Wrote: It's already happening, you should see what's been done so far

Bring back the NSHL

Find me a sim engine and I'd be happy to

Navigation

Extra Menu

About us