BuzzerBeater Forums

Hi!
Some time ago, after seeing various topics in the help forum asking if a player is "capped" or not, I decided to create a spreadsheet to indicate this, together with an approximation of what the player charged after upgrading wage.

This application is based on estimates and approximations from manager Josef Ka (Thank you again for your work), which I adapted slightly.
Slowly try to debug more salary calculation, I still think that is not far from the truth.
I would appreciate if you can, test and reply me if you see errors, something not well understood or something you think could improve him.

3 fictitious players initially appear, one should be "capped", another is close to it and the third still has to reach that potential cap. You can delete them without any problem.
On the right side of the spreadsheet are some clarifications about their use and content.
At the bottom is a note to copy all your roster at once.

Excel 2007:
http://dl.dropbox.com/u/23400410/Salary%20and%20cap%20cal...

Excel 1997/2003:
http://dl.dropbox.com/u/23400410/Salary%20and%20cap%20cal...

Open Office:
http://dl.dropbox.com/u/23400410/Salary%20and%20cap%20cal...


Regards and thanks if you decide to try and comment on.

Sorry for my mistakes

Great stuff!

but you should probably add salaries for different positions, so one could see if player will switch positions, when certain skill is improved too much(max free skills).

Sounds good, thank you! I will add it soon

Also, I didn't understand the meaning of numbers ex. for mvp 26-28?

In this spreadsheet this numbers are not useful. They are a value cap you see in other applications.
My colum cap is X/2-5 where this X is the value arround 26-28 in case of a MVP "capped". But I prefer to use a value up to 11 (all-time great potential), because as I see it more reasonable.



Last edited by iversen at 1/27/2013 11:25:52 AM

+1 nice work...

Very Nice Work
Thank You

great work man :)