UPDATED 8/2/08 - Version 1.10 fixes a problem with the level 22 formula and adds a 'notes' section.
I created this spreadsheet which will help with planning out the development of your player a while ago and have been using it for a couple of seasons now. It seems to work pretty well so I'm releasing it to everyone tonight with a few minor changes so that I could protect the important cells just in case.
http://www.brooklynffl.com/glb/glbplayersv110.xls
The workbook contains a master sheet and four player sheets to start with, I'm sure there are a lot of people who will need to copy more over.
To start, type in your player's name in the top-left corner and then select his position from the drop-down box. Selecting the position should automatically fill in both the special ability box titles and should also fill in the amount of partial skill points in each ability score that the player will get from leveling. (Note - I have the decreased ability scores in for level 23+, but if there is another time when it decreases further I will have to adjust).
You can then input your player's ability scores from the original roll (before spending your first 15 skill points) in the green spaces.
Every character level has 4 columns associated with it. The first column is headed by the player's level and contains the current ability and SA scores for the player.
The column labeled 'Training' is a column where the user can enter the ability score increases from training until the next level. (Also, this is where you will have to enter small adjustments to ability scores (usually .01) due to rounding in both the game and Excel).
The column labeled 'Level Up' is a protected column that will automatically add the ability points that your player will get when he levels up, depending upon his position.
The column labeled 'Skill Points' is where you can enter any skill points that you spend while you are that level. For instance, after rolling your character there is a column to enter the original fifteen skill points that you receive before the 'Level 1' column.
Also, in the 'Skill Points' column, there is a cell highlighted in yellow and labeled 'other'. This is where you should put any extra skill points that something has cost you. ie) If you are a QB, the first time that you purchase the Field General SA it will cost you two skill points -- Put a 1 in the SA row and put the other 1 in the 'other' row. This is VERY important so the sheet can track your current build correctly. This goes for ability scores over 48.07, also.
The spreadsheet will keep a running total of the skill points that you have/will have available to you at any time. This is both for the slow builders and because, sooner or later, you will have to start saving skill points in order to accomplish the goals of your player's build.
Please let me know of any bugs you find or suggestions that you might have to improve the spreadsheet.
Lastly, I'm not that great at explaining things by typing so if there is any confusion (especially to the 'other' row) would someone who does understand the spreadsheet please try to explain.
Thanks
Paul
I created this spreadsheet which will help with planning out the development of your player a while ago and have been using it for a couple of seasons now. It seems to work pretty well so I'm releasing it to everyone tonight with a few minor changes so that I could protect the important cells just in case.

http://www.brooklynffl.com/glb/glbplayersv110.xls
The workbook contains a master sheet and four player sheets to start with, I'm sure there are a lot of people who will need to copy more over.
To start, type in your player's name in the top-left corner and then select his position from the drop-down box. Selecting the position should automatically fill in both the special ability box titles and should also fill in the amount of partial skill points in each ability score that the player will get from leveling. (Note - I have the decreased ability scores in for level 23+, but if there is another time when it decreases further I will have to adjust).
You can then input your player's ability scores from the original roll (before spending your first 15 skill points) in the green spaces.
Every character level has 4 columns associated with it. The first column is headed by the player's level and contains the current ability and SA scores for the player.
The column labeled 'Training' is a column where the user can enter the ability score increases from training until the next level. (Also, this is where you will have to enter small adjustments to ability scores (usually .01) due to rounding in both the game and Excel).
The column labeled 'Level Up' is a protected column that will automatically add the ability points that your player will get when he levels up, depending upon his position.
The column labeled 'Skill Points' is where you can enter any skill points that you spend while you are that level. For instance, after rolling your character there is a column to enter the original fifteen skill points that you receive before the 'Level 1' column.
Also, in the 'Skill Points' column, there is a cell highlighted in yellow and labeled 'other'. This is where you should put any extra skill points that something has cost you. ie) If you are a QB, the first time that you purchase the Field General SA it will cost you two skill points -- Put a 1 in the SA row and put the other 1 in the 'other' row. This is VERY important so the sheet can track your current build correctly. This goes for ability scores over 48.07, also.
The spreadsheet will keep a running total of the skill points that you have/will have available to you at any time. This is both for the slow builders and because, sooner or later, you will have to start saving skill points in order to accomplish the goals of your player's build.
Please let me know of any bugs you find or suggestions that you might have to improve the spreadsheet.
Lastly, I'm not that great at explaining things by typing so if there is any confusion (especially to the 'other' row) would someone who does understand the spreadsheet please try to explain.
Thanks
Paul
Last edited Aug 2, 2008 22:32:11





























