I have fixed the issue and updated the file.

Please review for any you see with questions

- a brief explanation on the error

Yahoo added more stats to my import and it was causing SOG to be looking at SHG and therefore any player with a SHG had a huge bump!

found another small bug, has been fixed

Attached Files

Salary 2011 v2 as of Feb 25_2011.zip (16.6 KB, 22 views)

__________________
The Comish's Dynasty Pool - YR1 Dual Champ!
G,A,+/-,PPP,PIM,SOG,W,GAA,SVS
3C- Toews $74, , Lecavalier $119, Madden $29
3L- McDonald (C) $65, Avery $60, MacArthur $22
3R- Semin $108, C.Stewart $5, Kopecky $12
4D- Phaneuf $107, Wisniewski $35, Goligoski $5, Robidas $50
1U- Ja.Williams $51
1G- Emery $5

BN- B.Stuart(D) $20, C.Bourque(LW) $5, Pickard(G) $5, Abdelkader(LW) $5, Conklin(G) $45, Y.Weber(D) $5, Leighton(G) $5

IR- Burish $17, Lupul $66, Hemsky, Bieksa

Cap hit $927

Here i go, i will do my best!

Salaries are calculated based off calculated percentages (i will explain below) of the players performance over the past 3 years. The Current/Most recent year is worth 50%, the previous year is worth 35% and 15% for the oldest year.

A players calculated percentage is calculated based on a players rating for that year(see below) as a percentage of the best for that year, the percentage from that calculation is what is used in the above description

A players rating is calculated based on his performance in each stat we track against the best in that stat category, then 1/6th of that (6 stats) added up to get a total.

example
for F and D
the max for each stat this season is currently the following
G - 41
A - 59
PPP - 33
+/- - 54 (high is 26, low is -28, all +/- numbers get shifted up by 28 to go from 0 to 54)
PIM - 219
SOG - 285

D. Sedin this year has 32/47/33/+24/24/194 (G/A/PPP/+/-/PIM/SOG)
That gets him ratings of 0.78/0.80/1.00/0.96/0.11/0.68 for a total of 0.72 when you take 1/6th of all the numbers

his 0.72 is then calculated to a percentage of the top guy for the year which happens to be himself so he gets a 100% for this year

take 50% of that and then 35% of his previous year (68.26%) and 15% of the previous year(70.67%) and he gets a 3 year total of 84.49%, which then gets calculated into a salary that will never exceed $200 per player.

This system also provides a bit of a salary cap on rookies and 2nd year players as they don't have numbers to fill in all the years but like real players come yr 4 they could be worth a ton!

Sorry if this went in circles, it isn't easy to explain, please ask more questions if something isn't clear, it took a lot to develop but if i do say so myself is quite impressive and detailed for a real 3yr performance based salary!

__________________
The Comish's Dynasty Pool - YR1 Dual Champ!
G,A,+/-,PPP,PIM,SOG,W,GAA,SVS
3C- Toews $74, , Lecavalier $119, Madden $29
3L- McDonald (C) $65, Avery $60, MacArthur $22
3R- Semin $108, C.Stewart $5, Kopecky $12
4D- Phaneuf $107, Wisniewski $35, Goligoski $5, Robidas $50
1U- Ja.Williams $51
1G- Emery $5

BN- B.Stuart(D) $20, C.Bourque(LW) $5, Pickard(G) $5, Abdelkader(LW) $5, Conklin(G) $45, Y.Weber(D) $5, Leighton(G) $5

IR- Burish $17, Lupul $66, Hemsky, Bieksa

Cap hit $927

it's the best system i've come across, man.

__________________
@matsthomassen

thanks

i should also add the the final percentage is converted to a $ by the following calculation

the players % is then fit into a calculation that takes the top rating (+5% to make sure no one ever hits $200) and the min rating (500ish player, currently about 21%) with every percentage assigned a $ amount between $5 and $200

currently $200 = 98% and 21% = $5

a bit more!
the full calculation to go from a % to a Salary is

Min Sal +(((Player %-Min%)*(Max Sal-Min Sal))/(Max%-Min%) *hopefully that works out

__________________
The Comish's Dynasty Pool - YR1 Dual Champ!
G,A,+/-,PPP,PIM,SOG,W,GAA,SVS
3C- Toews $74, , Lecavalier $119, Madden $29
3L- McDonald (C) $65, Avery $60, MacArthur $22
3R- Semin $108, C.Stewart $5, Kopecky $12
4D- Phaneuf $107, Wisniewski $35, Goligoski $5, Robidas $50
1U- Ja.Williams $51
1G- Emery $5

BN- B.Stuart(D) $20, C.Bourque(LW) $5, Pickard(G) $5, Abdelkader(LW) $5, Conklin(G) $45, Y.Weber(D) $5, Leighton(G) $5

IR- Burish $17, Lupul $66, Hemsky, Bieksa

Cap hit $927

Thanks Chinny. Definitely complicated and I appreciate the explanation AND especially the time you put into calculating all of these. Great stuff

Now let's make some trades. I have lots of cap room for those looking to shed some

__________________

Hey,

Just wondering since the season is over if we can possibly get some updated salaries in the near future?? Wouldn't mind having a look see and being planning for next season's roster

Thanks!

__________________
24 Team / 3 Tier Roto League
G|A|+/-|PIM|PPP|SOG
W|GAA|SV

Tier 3
C: Backstrom, Roy, Anisimov
LW: Zetterberg, JvR, Paajarvi
RW: C.Stewart, Okposo, Voracek
D: Shattenkirk, Enstrom, Hamonic, Bouwmeester
UTIL: Lupul
G: Quick
Bench: Johansen, Hanzal, Toffoli, Howden, Upshall, Kubalik,
Watson, Chiasson, Faulk, Kampfer, Dubnyk, Endras

sorry for the delay

i didn't spend anytime checking for errors, please point them out to me!

Attached Files

Salary structure Final 2011.zip (49.3 KB, 4 views)

__________________
The Comish's Dynasty Pool - YR1 Dual Champ!
G,A,+/-,PPP,PIM,SOG,W,GAA,SVS
3C- Toews $74, , Lecavalier $119, Madden $29
3L- McDonald (C) $65, Avery $60, MacArthur $22
3R- Semin $108, C.Stewart $5, Kopecky $12
4D- Phaneuf $107, Wisniewski $35, Goligoski $5, Robidas $50
1U- Ja.Williams $51
1G- Emery $5

BN- B.Stuart(D) $20, C.Bourque(LW) $5, Pickard(G) $5, Abdelkader(LW) $5, Conklin(G) $45, Y.Weber(D) $5, Leighton(G) $5

IR- Burish $17, Lupul $66, Hemsky, Bieksa

Cap hit $927

Found an issue
here it is with that fixed.

please continue to check for issues

Attached Files

Salary structure Final 2011.zip (49.4 KB, 32 views)

__________________
The Comish's Dynasty Pool - YR1 Dual Champ!
G,A,+/-,PPP,PIM,SOG,W,GAA,SVS
3C- Toews $74, , Lecavalier $119, Madden $29
3L- McDonald (C) $65, Avery $60, MacArthur $22
3R- Semin $108, C.Stewart $5, Kopecky $12
4D- Phaneuf $107, Wisniewski $35, Goligoski $5, Robidas $50
1U- Ja.Williams $51
1G- Emery $5

BN- B.Stuart(D) $20, C.Bourque(LW) $5, Pickard(G) $5, Abdelkader(LW) $5, Conklin(G) $45, Y.Weber(D) $5, Leighton(G) $5

IR- Burish $17, Lupul $66, Hemsky, Bieksa

Cap hit $927

Sorry, I was reminded i haven't posted these yet this year.
Here are the projected salaries for the Comish Dynasty League

Again feel free to post about any players you disagree with and i will look into the player for you!

Attached Files

Salary 2012 v1 excel Mar 15.zip (31.9 KB, 21 views)

__________________
The Comish's Dynasty Pool - YR1 Dual Champ!
G,A,+/-,PPP,PIM,SOG,W,GAA,SVS
3C- Toews $74, , Lecavalier $119, Madden $29
3L- McDonald (C) $65, Avery $60, MacArthur $22
3R- Semin $108, C.Stewart $5, Kopecky $12
4D- Phaneuf $107, Wisniewski $35, Goligoski $5, Robidas $50
1U- Ja.Williams $51
1G- Emery $5

BN- B.Stuart(D) $20, C.Bourque(LW) $5, Pickard(G) $5, Abdelkader(LW) $5, Conklin(G) $45, Y.Weber(D) $5, Leighton(G) $5

IR- Burish $17, Lupul $66, Hemsky, Bieksa

Cap hit $927

Thanks Chinny!

__________________
24GMs Dynasty (G A +- PIM PPP SOG W SV GAA / 4C, 4LW, 4RW, 6D, 1G)
Cap hit: $1188 out of $1250

C-Malkin $157,Schwartz $5,Granlund $5,Shaw $5,Rinaldo $5,Cervenka $5,Schroeder $5,Galchenyuk $5
LW-Hartnell $136,Nash $115,Leino $29,Kulemin $49,Gagne $32,Paajarvi $5,MFoligno $5,Joensuu $5
RW-Brown $115,Jagr $14,Grabner $40,Gallagher $5,Knight $5,Radulov $5
D-Karlsson $105,Edler $83,McDonagh $18,Bogosian $27,Mitchell $22,REllis $5,Salvador $5,Hamilton $5
G-Halak $127,Montoya $24,Bishop $5,Fasth $5,Allen $5