Been a while since I was last here! See some familiar names kicking around still.
Before the league re-alignment, I had a pretty killer NHL sheet setup, but it was full of inefficient nested "if" statements.
It took a few years of tweaking and it was really a work in progress..
Anyway, my new job requires Excel and so I've gotten back into it.
I decided to hone my skills again last night and came up with a brand new sheet.
You can download it free from here: www.filedropper.com/nhlpicker
I had to upload it this way because this silly forum has capped my attachment size at 294kb, whereas this sheet is 366kb.
I assure you there are no viruses or any bullshit.. Just a spreadsheet.
It took me 5 hours to do on this sheet what I could not do in 4 years with my old one (didn't realize VLOOKUP and INDEX/MATCH were so easy... even threw in some CONCATENATE to kill the 256 character nested "if" statements i once used!)
It basically grabs the team stats from NHL.com onto their own individual sheets.
I've applied some half-assed, arbitrary calculations and come up with some fancy looking percentages which are supposed to be "the play".
***** NOTE *****
I am not actually playing these.. I just did this as practice for Excel.
This sheet does however have some use, and for those of you who are proficient in Excel, you may find it a handy starting place to set up your own sheet.
The information is all there, it just needs to be manipulated.
Before the league re-alignment, I had a pretty killer NHL sheet setup, but it was full of inefficient nested "if" statements.
It took a few years of tweaking and it was really a work in progress..
Anyway, my new job requires Excel and so I've gotten back into it.
I decided to hone my skills again last night and came up with a brand new sheet.
You can download it free from here: www.filedropper.com/nhlpicker
I had to upload it this way because this silly forum has capped my attachment size at 294kb, whereas this sheet is 366kb.
I assure you there are no viruses or any bullshit.. Just a spreadsheet.
It took me 5 hours to do on this sheet what I could not do in 4 years with my old one (didn't realize VLOOKUP and INDEX/MATCH were so easy... even threw in some CONCATENATE to kill the 256 character nested "if" statements i once used!)
It basically grabs the team stats from NHL.com onto their own individual sheets.
I've applied some half-assed, arbitrary calculations and come up with some fancy looking percentages which are supposed to be "the play".
***** NOTE *****
I am not actually playing these.. I just did this as practice for Excel.
This sheet does however have some use, and for those of you who are proficient in Excel, you may find it a handy starting place to set up your own sheet.
The information is all there, it just needs to be manipulated.
What is required?
| |||||
| Then after the games are over, enter the scores, and update the sheets with the "REFRESH" button.. the updates are automated as is the record keeping. I figured this could be useful to someone. If I were using it to bet with, I'd be particularly interested in the Underdog +$$$$ plays. Use this at your own risk... I don't mean virus-wise... Don't bet everything it suggests please.. don't be a retard.. It's a statistical analysis tool, not a Golden Egg-laying Goose... It just brings all the stats to you. Of course, as the season progresses, you may find the plays a bit predictable since the numbers will approach normal levels, but it should be interesting to see how the useless %'s I've come up with relate to ML odds set by the bookmakers, and the results that follow. Perhaps the most eye-opening aspect of this will be to identify where lines are inflated based on public perception, not on any kind of statistical edge... Anyway, I hope someone can get some use out of this.. If you have any questions, give'r.. Just keep in mind, I'm no excel expert, and even less of a statistician. enjoy. | |||||
