User Pass
Home Sign Up Contact Log In
Forum > Goal Line Blitz > GLB Player Planning Spreadsheet Released
Page:
 
pnewtonjr
offline
Link
 
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
Last edited Aug 2, 2008 22:32:11
 
maz621
offline
Link
 
damn wish i had excel
 
excalibur143
offline
Link
 
Very nice. Thanks man. Happy to have you on our team and happy to see this out in the hands of people who can use it.
 
jonbaker22
offline
Link
 
It is very nice, thanks.
 
RTJakarta
offline
Link
 
I'mma check it out.
 
LordEvil
offline
Link
 
sweet , takes a while to load up if you dont save it then open it.
 
BobJoeJim
offline
Link
 
Just out of curiosity, why does it go to level 63? I mean why not to 60, or 65, or any other number?

More importantly, awesome sheet, thanks!
Last edited Jul 19, 2008 01:37:27
 
Binestar
offline
Link
 
Originally posted by maz621
damn wish i had excel


http://www.openoffice.org
 
Lifeblood
offline
Link
 
Thanks for this, really great application.
 
maizenhops
offline
Link
 
how do i know my original roll?
 
Firenze
offline
Link
 
Originally posted by kalkmanc
how do i know my original roll?


and what levels I put SP into attributes, or SA's?
 
AlexKingston
offline
Link
 
Originally posted by kalkmanc
how do i know my original roll?


I think this might be for people that are just starting a new player
 
pnewtonjr
offline
Link
 
Originally posted by AlexKingston
Originally posted by kalkmanc

how do i know my original roll?


I think this might be for people that are just starting a new player


You can use it to continue a current player by putting adjusting numbers in the 'Training' column directly before your player's current level and adjusting the skill points left by using the 'other' box.



 
Zsirvone28
offline
Link
 
Wow, I really like that.
 
pnewtonjr
offline
Link
 
I'm getting a couple of PMs saying that this won't work with Open Office. I'm going to download OO tonight and work on it this week.



Thanks to everyone for trying it out.
 
Page:
 


You are not logged in. Please log in if you want to post a reply.