Spreadsheets (2015-2016)

[Handsome&FairMike]

^good point. had to make a couple small changes.

[foofnik]

Hey guys General Fanager is awesome, but when you go through the team, remember the money value it shows it Cap Hit. To get the players AAV you have to click on the player. In many of my players the Cap Hit and the AAV are quite different. Since reading we are using AAV I had to change a quite a few players salaries on my spreadsheet.

For example when I click on Edmonton's page it says Griffin Reinharts cap as 832,500, but his AAV is 3,213,333.

Players who's contracts end in UFA you don't have to look into, only RFA players.

[Bruyns]

Hey guys General Fanager is awesome, but when you go through the team, remember the money value it shows it Cap Hit. To get the players AAV you have to click on the player. In many of my players the Cap Hit and the AAV are quite different. Since reading we are using AAV I had to change a quite a few players salaries on my spreadsheet.

For example when I click on Edmonton's page it says Griffin Reinharts cap as 832,500, but his AAV is 3,213,333.

Players who's contracts end in UFA you don't have to look into, only RFA players.

Some old guys like Jagr, Zidlicky, etc. have a different AAV too

[hong57]

Hey guys General Fanager is awesome, but when you go through the team, remember the money value it shows it Cap Hit. To get the players AAV you have to click on the player. In many of my players the Cap Hit and the AAV are quite different. Since reading we are using AAV I had to change a quite a few players salaries on my spreadsheet.

For example when I click on Edmonton's page it says Griffin Reinharts cap as 832,500, but his AAV is 3,213,333.

so his cap hit in bbkl is 3213333 right? i went over the cap with AAV and had to make some deals to stay within the cap.. i hope everyone realise we use AAV and not put the "cap" number by accident.

[kyuss]

what's up with the red number for the total salary number even when it's lower than 71.4?

Maybe colour is still set on last year cap? (69M)

[Mike]

I didn't fix conditional formatting, so over 69 it gives you red

[KapG]

Thanks for getting those spreads ready for us all Mike

[CAM]

agree. they look great.