I need a fantasy hockey spread sheet:
- Be able to copy and paste top players' stats from [login to view URL] by position,
- Also be able to sort players and their stats by any of these columns: GP, G, A, Pts, +/-, PIM, Hits, BkS, PPG, PPA, SHG, SHA, GW, SOG, Pct.
- Once these columns are made, I need to be able to input my fantasy league's scoring structure to project how many points each individual player would've made for my fantasy league with their NHL stats.
(Example: Scoring Table
Forwards
Goal/Assist: 2 points
PP Point: +2 point
SH Point: +2 points
OT Point: +2 points
GWG: +2 points
PIM: 2 point per minute
+/- : 2 points per each + rating
Defence
Goal/Assist: 2 points
PP Point: +1 point
SH Point: +3 points
OT Point: +2 points
GWG: +3 points
PIM: 1 point per minute
+/- : 2 points per each + rating
Goaltenders
Win: 10 points
OTL: 5 points
SO: +10 points
Goal: 99 points
Assist: 10 points
PIM = 1 point per minute
)
- I need to be able to do this point projection method for atleast the 3 latest seasons (example: 2011-2010-2009)
- I need to be able to average these three seasons to be able to compare players and see who has had the best performance over the years
Hello, I am very much interested on your project. I have read your requirements and I am quite confident that I will be able to get your work done within the given time.I am very keen to discuss further. You can reach me at any time on online but make sure you notify me. Thank You Very Much Indeed.