Front Office Football Central  

Go Back   Front Office Football Central > Main Forums > FOF/TCY Discussion
Register FAQ Members List Calendar Mark Forums Read Statistics


Reply
 
Thread Tools
Old 07-18-2012, 05:52 AM   #1
aston217
High School Varsity
 
Join Date: Sep 2010
A small offering: FOF contracts spreadsheet

LINK (Google Docs)
When I renegotiate, I often find myself doing the same sort of calculations over and over. So I created a spreadsheet that does some calculations I consider useful for me, and lays it out in an easy-to-see way.

This way, I know how a hypothetical offer stacks up to what the player is demanding. And when a player rejects a lowball offer, I have the last contract offered to him saved in the spreadsheet to go back and refer to. For your convenience...



USAGE
Really self-explanatory...but for the sake of completeness.
0) Make a copy of the file to your own Google Docs/Drive, or download it as a spreadsheet.
1) Enter the requested total bonus, length of contract, total value, and year 1 salary in the ORANGE cells.
2) Enter your proposed contract's total bonus, length, total value, and salary breakdown in the GRAY cells.

The "year 1%" compares the player's requested year 1 bonus+salary with the same from your offer. It doesn't factor in any previous bonus still being paid out.

The "overall %" compares the total value of your offer compared with the total value of the requested offer - with the requested offer adjusted if the contract lengths between offered & requested are different.

The BLUE cells offer two suggestions: bonus and salary. The suggested bonus just gives exactly what the player wants adjusted by any difference in contract length. The suggested salary assumes equal salary every year (it's what I usually try to do...) and uses a target "overall %" depending on how much you want to lowball. Note that it uses your desired offered bonus (in the gray) and *not* the suggested bonus to do its calculation.

--

Copy & paste the whole block of cells to add another player.
__________________
OSFL CFL
Float likeabutterflysting likeabee.



aston217 is online now   Reply With Quote
Sponsors (you can remove these ads by registering or logging in)

Register or login to remove these ads and many more.
Old 07-18-2012, 04:58 PM   #2
chinaski
College Prospect
 
Join Date: Nov 2003
Location: Portland, Oregon
Awesome, thanks aston!
chinaski is offline   Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is On
Forum Jump


All times are GMT -5. The time now is 08:53 PM.



Powered by vBulletin Version 3.6.0
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.