Search the Community
Showing results for tags 'excel yo'.
Found 1 result
-
Yo, welcome to the next installment of me whining. Today's topic is game matrix/matrices, can we please get one? It makes reading games not a ball busting chore, plus it is much faster based on the fact that you won't have to deal with the crippling load time of the website (seriously guys what gives? It isn't the mid 2000s cache that shit already). No idea what a game matrix is? No problem famalam, feast your eyes on this... Basically it gives you a quick visual overview of how each team is doing, showing individual head to heads. Simple, intuitive, quick and well made. How do we do that now? NHLgamer -> leagues -> elite -> Wait a few seconds -> Schedule drop down box, select team -> Wait for swooshing random stuff that doesn't add anything of note -> yay, you're in one team's schedule, but that's it. You can search theirs to see matchups but you can't see other head to heads without wasting a further 10-15s on, quite honestly, pointless waiting. Solution? MATRICES! Boi, in my midnight stupor of cs rage and procrastination from my dissertation (seriously, who doesn't love talking about semantic memory lateralisation / localisation within the pre-frontal cortex / parietal lobes while factoring in semantic relatedness? This fucker thats who) I decided to take on the 'daunting task'. Truth be told I just wanted to make it for NOR and teams around, but when I realised how simple it would be I decided to batten down the hatches and go full hog, momma didn't raise no bitch I tell you. Instructions: Read from left to right, starting on the team (Y axis) you want to compare against others. Follow the row of the team across the bottom (X axis) to see their result(s) against 'x' opponent. E.g.: If I want to see how Carlsberg did against Sjukstugan, I start at either CAR or 112 on the left hand axis, then follow the row across until I meet the column of either 112 or CAR respectively. Sounds simple? That's because it is. Red = Double loss Blue = Win and loss Green = Double win ---------------------------- **Disclaimers: It's 4am right now, momma did raise a sleepy fuck. So bare in mind this is a 1st draft of the idea, take it as a proof of concept if you will. Some results are straight up missing (looking at you NN and SSG / TIK). Thirdly, I discovered a bug in the system (?) that when a game is still needing stats or press conferences it doesn't show up as an OT game in the schedule, even if it was. Just an observation, don't crucify me but that really shouldn't be there. Soooo some 'OT's may be missing from some matchups. ----------------------------------------------------------------------------------------------------------------------------------------- Hopefully people can see the usefulness in something like this going forward for future ecls. For instance you can see that the elite division has engaged in some sort of 4D underwater low gravity rock paper dildo where NL > KAT > MUK > WRT , therefore NL > WRT naturally. All in all this matrix took me roughly two hours to compile, that's with manual retrieval of stats, something that would be fixed if this was to be a feature on the site somewhere as it would be automatic once games are submitted. In addition to this the code used to make this for elite could ofc be ported across so that pro / lite divisions can have their teams substituted in. Either way, let's go and make stats great again! MSGA
