19-20 Team Strength

[Chris-Suffolk]

I know I have a lot of questions lately...that's because there aren't answers that are sufficient yet...

Here's another question...Can you please tell me how the "Team Strength for 2019-20" is determined?

I have been paying some attention to this throughout the season to see where I stand and for other reasons. The reason I ask, I see that Hartford ( and I mean no disrespect at all ) is currently 6th overall in strength for next year, but as I look at the NHL stats for Hartford, they do not represent a 6th overall team.

So, I a wondering, how the calculations are formed, and if there were a way that the "Overall Score" of each team could be placed beneath each teams "NHL Stats Page"?

For ex: If each of these categories could be tallied on that page
GP G A Pts +/- PIM PP SH GW Shot TOI PtsPG

This may be a productive tool to see the strengths in each category for a GM, or weaknesses to address.

Another reason I ask is that I'd like to see just how close or far apart teams are in strength.

[Jon-Seattle]

I think you should learn to program, compile these stats, work out an algorithm to adjust for TOI and GP. You can add your findings to the page and enlighten us all.

[Chris-Suffolk]

LOL...I'm lucky ( you guys, not so much ) that I can figure out how to post on this forum. I still don't know how to post pics or links....and I've learned and forgotten how to do those things several times.

But, fortunately, that's what Glenn does...and all you have to do is ask.

[Glenn-Philadelphia]

From what I recall, and that reminds me u still need to add a parameter in there for next years available cap space as well, it looks at guys you will have next year, (doesn't count ufas) and comes up with a ranking for combined goalie save percentage and offensive production and joins these values together. It is used to give a rough approximation of potential team strengths next year bit doesn't factor in D in its present incarnation. It also doesn't factor in guys not showing on the stats page because of them having AHL card IDs (like McKenzie Blackwood for me)

[Chris-Suffolk]

Ah, very good then ole chap.

Is there a possibility to add the totals for the categories which are already there?

( GP G A Pts +/- PIM PP SH GW Shot TOI PtsPG )

[Glenn-Philadelphia]

Actual table names have been changed to protect the innocent...


delete from dbo.[RESULTS_TABLE]

--OFF
select
a.teamid, d.teamcity, d.logopic, sum(g) as G, Sum(a) as A, sum(gp) as GP, count(a.thnid) as Cnt, ((1+(count(a.thnid)-20)*.05)) * ((1.3 *(sum(g)) + sum(a)) /sum(gp)) * 100 as Score
into #T1
from [CONTRACTS_TABLE] as a
left join [MASTER_TABLE] as b on a.thnid = b.thnid
left join [SKATERS_STAT_TABLE] as c on a.thnid = c.thnid
left join [TEAMS_TABLE] as d on a.teamid = d.teamkey
where
((conendyear = 2019 and contractshad < 2) or (conendyear > 2019))
and c.thnid is not null
group by teamid, teamcity, logopic
order by ((1+(count(a.thnid)-20)*.05)) * ((1.3 *(sum(g)) + sum(a)) /sum(gp)) desc



--GOALIES
select teamid, (gscore*factorx)*100 as GScore
into #T2
from
(select a.teamid, d.teamcity, d.logopic, sum(sha) as SHA, Sum(GA) as GA, sum(gp) as GP, e.agp, 1.00 - (sum(ga) / sum(sha)) as GScore,
case
when sum(gp) >= AGP then 1.0
else sum(gp)/AGP
end as Factorx
from [CONTRACTS_TABLE] as a
left join [MASTER_TABLE] as b on a.thnid = b.thnid
left join [GOALIES_STAT_TABLE] as c on a.thnid = c.thnid
left join [TEAMS_TABLE] as d on a.teamid = d.teamkey
left join (select sum(gp)/31 as AGP from [GOALIES_STAT_TABLE]) as e on 1=1
where
((conendyear = 2019 and contractshad < 2) or (conendyear > 2019))
and c.thnid is not null
group by teamid, teamcity, logopic, AGP) as x


select avg(gscore*factorx)*100 as GScoreAvg
into #T3
from
(select a.teamid, d.teamcity, d.logopic, sum(sha) as SHA, Sum(GA) as GA, sum(gp) as GP, e.agp, 1.00 - (sum(ga) / sum(sha)) as GScore,
case
when sum(gp) >= AGP then 1.0
else sum(gp)/AGP
end as Factorx
from [CONTRACTS_TABLE] as a
left join [MASTER_TABLE] as b on a.thnid = b.thnid
left join [GOALIES_STAT_TABLE] as c on a.thnid = c.thnid
left join [TEAMS_TABLE] as d on a.teamid = d.teamkey
left join (select sum(gp)/31 as AGP from [GOALIES_STAT_TABLE]) as e on 1=1
where
((conendyear = 2019 and contractshad < 2) or (conendyear > 2019))
and c.thnid is not null
group by teamid, teamcity, logopic, AGP) as x



insert into dbo.[RESULTS_TABLE]
select
row_number() OVER(ORDER BY a.score + 0 + isnull(b.gscore, GscoreAvg) desc, teamcity) as ordval,
a.teamid,
a.teamcity,
a.logopic,
a.score as OScore,
0 as DScore,
isnull(b.gscore, GscoreAvg) as GScore,
a.score + 0 + isnull(b.gscore, GscoreAvg) as TScore
from #T1 as a
left join #T2 as b on a.teamid = b.teamid
left join #T3 as c on 1=1
order by a.score + 0 + isnull(b.gscore, GscoreAvg) desc

[Chris-Suffolk]

Adirondack Aces 18-19 NHL Stats through and including 1/2/2019
Name POS Status ConEnd Tm GP G A Pts +/- PIM PP SH GW Shot TOI PtsPG
Beagle, Jay C UFA 2020 Van 19 1 3 4 2 4 0 1 0 14 14:08 0.21
Beleskey, Matt LW UFA 2099 NYR 4 1 0 1 1 5 0 0 0 3 7:22 0.25
Brown, Dustin RW UFA 2020 LA 31 11 11 22 2 6 4 1 3 88 21:02 0.71
Carey, Paul C MIN 2099 Ott 5 0 0 0 0 0 0 0 0 1 9:08 0.00
Carpenter, Ryan C RFA 2020 VGK 39 2 7 9 -6 2 0 1 0 56 12:46 0.23
Clendening, Adam D UFA 2099 CBJ 4 0 0 0 1 0 0 0 0 3 10:39 0.00
Coyle, Charlie C UFA 2021 Min 38 6 12 18 6 10 1 1 1 74 17:00 0.47
DelZotto, Michael D UFA 2019 Van 22 1 3 4 4 8 0 0 0 20 18:13 0.18
Deslauriers, Nicolas LW UFA 2021 Mtl 27 2 1 3 -2 13 0 1 0 29 10:14 0.11
Dotchin, Jake D UFA 2021 Ana 16 0 1 1 -3 37 0 0 0 7 12:01 0.06
Ekholm, Mattias D UFA 2020 Nas 40 3 22 25 15 31 0 0 1 67 22:59 0.63
Eller, Lars C UFA 2024 Wsh 38 5 11 16 -7 25 0 0 1 75 16:55 0.42
Forsberg, Filip LW UFA 2022 Nas 26 14 8 22 11 14 3 1 2 86 18:54 0.85
Girardi, Dan D UFA 2020 TB 39 3 9 12 7 8 0 0 0 47 17:28 0.31
Grabner, Michael LW UFA 2024 Ari 25 6 5 11 -1 8 0 4 1 41 14:05 0.44
Greene, Andy D UFA 2019 NJ 39 2 10 12 2 12 0 0 0 48 20:55 0.31
Grubauer, Philipp G UFA 2020 Col 18 0 0 0 0 0 0 0 0 0 53:12 0.00
Hamilton, Dougie D UFA 2020 Car 38 3 7 10 -15 20 1 0 0 126 20:04 0.26
Johnsson, Andreas LW RFA 2020 Tor 34 8 9 17 12 14 1 0 1 54 12:44 0.50
Mangiapane, Andrew LW RFA 2020 Cgy 7 0 0 0 -4 2 0 0 0 8 11:32 0.00
McElhinney, Curtis G UFA 2020 Car 14 0 0 0 0 0 0 0 0 0 59:54 0.00
Miller, J.T. C UFA 2020 TB 38 7 19 26 1 12 3 0 2 58 15:10 0.68
Nelson, Brock C UFA 2020 NYI 38 13 12 25 13 12 0 1 2 79 18:01 0.66
Quenneville, John W RFA 2020 NJ 15 0 0 0 0 4 0 0 0 12 11:13 0.00
Rychel, Kerby LW UFA 2021 Cgy 2 0 0 0 -1 0 0 0 0 1 9:11 0.00
Shore, Devin LW RFA 2019 Dal 37 5 12 17 1 7 0 1 3 39 13:28 0.46
Simmonds, Wayne RW UFA 2024 Phi 39 11 6 17 -14 49 3 0 1 93 16:39 0.44
Stecher, Troy D RFA 2020 Van 39 1 11 12 10 20 0 0 0 43 17:05 0.31

XXXXXXXXX XXX XXX XXXX XXX TOT TOT TOT TOT TOT TOT TOT TOT TOT TOT TOT

So, you saying that you can't add in the TOTAL's for each of these categories? But you can get pissed off when I ask something. Because you are well aware that I am ignorant when it comes to computer coding, but not sarcasm.

[Glenn-Philadelphia]

Lol. I am not pissed off. I provided the guts that create the data that is populated in that table. That is after explaining it at high level in layman's terms this morning for your, and other non computer literate folks benefit.

[Scott-New York]

It's a cute little feature. Too many variables in a season for this to be a predictor of next years season. As a matter of fact, I'll gp out on a very feeble branch and predict that it won't predict much concerning the GHL. Don't get me wrong, as I said, cool feature to have a little peek into the teams' talent level but that's all I see this as.

[Jedediah-Hartford]

Jan 2, 2019 16:18:29 GMT -5 Chris-Suffolk said:

I know I have a lot of questions lately...that's because there aren't answers that are sufficient yet...

Here's another question...Can you please tell me how the "Team Strength for 2019-20" is determined?

I have been paying some attention to this throughout the season to see where I stand and for other reasons. The reason I ask, I see that Hartford ( and I mean no disrespect at all ) is currently 6th overall in strength for next year, but as I look at the NHL stats for Hartford, they do not represent a 6th overall team.

So, I a wondering, how the calculations are formed, and if there were a way that the "Overall Score" of each team could be placed beneath each teams "NHL Stats Page"?

For ex: If each of these categories could be tallied on that page
GP G A Pts +/- PIM PP SH GW Shot TOI PtsPG

This may be a productive tool to see the strengths in each category for a GM, or weaknesses to address.

Another reason I ask is that I'd like to see just how close or far apart teams are in strength.

None taken

[Glenn-Philadelphia]

Jan 4, 2019 7:53:50 GMT -5 Scott-New York said:

It's a cute little feature. Too many variables in a season for this to be a predictor of next years season. As a matter of fact, I'll gp out on a very feeble branch and predict that it won't predict much concerning the GHL. Don't get me wrong, as I said, cool feature to have a little peek into the teams' talent level but that's all I see this as.

I will try to remember to get a snapshot of this before next season so we can compare next years results as they play out.

If it was truly refined it would take the top 12 forwards, 6 defense and 2 goalies when doing the calculation as well as factoring in D somehow. That being said, it does have 2 of the 3 legs of the triad (OFF/GOALIE) so I wouldn't be surprised if it was pretty accurate.

[Dane-Hamilton]

Only thing that could really swing top teams and bottom teams a lot is UFA/Draft. Yea teams can sign the best UFA to move up from bottom feeders or a team like Cincy could draft Dahlen, Petersen etc and become an instant playoff contender.

Looking at it I think it's fairly safe to say teams over 150 should put up 100 points next year, and teams below 75 will struggle to hit 60 points. In between that its a crap shoot I think Hartford is a bit over rated (not a superb goalie and good but not great forwards) and I think any of the middle teams with a goalie can threaten 100 with no moves made.

[Chris-Suffolk]

@dane, et al, Yeah, that is exactly why I questioned the premise/design of this feature. I was curious specifically how the strength was determined because I feel the same as Dane.

I thought it was a "Team Strength" for next year. Thinking that it encompassed all players with NHL stats on a particular GHL team. That's why I thought/think it would be beneficial for us to have the running totals for the categories I asked. This way, we could get some idea of our teams Goals For prowess, GA, Shots, PP, SH, etc...

[Scott-New York]

One huge factor that isn't and can't be taken into account is how teams set their lines, some have proven they are proficient in this category while others simply are not. Just something I've noticed over the years and yes, it makes a difference.

[Phil-Cornwall]

Christopher...ya gotta lotta spastic holiday energy it seems. Tackle some more useful threads such as UFA retention. You'll get more mileage there.