Page 5 of 5
Re: Spreadsheets (2015-2016)
PostedCOLON Sun Oct 04, 2015 9:40 am
by Handsome&FairMike
^good point. had to make a couple small changes.
Re: Spreadsheets (2015-2016)
PostedCOLON Sun Oct 04, 2015 9:31 pm
by foofnik
Florida Chris wroteCOLONHey 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.
Re: Spreadsheets (2015-2016)
PostedCOLON Sun Oct 04, 2015 10:39 pm
by Bruyns
foofnik wroteCOLONFlorida Chris wroteCOLONHey 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
Re: Spreadsheets (2015-2016)
PostedCOLON Sun Oct 04, 2015 10:55 pm
by hong57
Florida Chris wroteCOLONHey 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.
Re: Spreadsheets (2015-2016)
PostedCOLON Mon Oct 05, 2015 8:51 am
by 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)
Re: Spreadsheets (2015-2016)
PostedCOLON Mon Oct 05, 2015 12:24 pm
by Mike
I didn't fix conditional formatting, so over 69 it gives you red
Re: Spreadsheets (2015-2016)
PostedCOLON Mon Oct 05, 2015 12:25 pm
by KapG
Thanks for getting those spreads ready for us all Mike
Re: Spreadsheets (2015-2016)
PostedCOLON Mon Oct 05, 2015 12:27 pm
by CAM
agree. they look great.