A new version of the spreadsheet has been uploaded at the same url. 01/06/2012
I added a few things such as a separate equipment area for items not carried by the PC (and therefore not included in ENC.) Also added an area to calculate total current CA's, and Movement Rate on the CharSht-Combat tab.
danskmacabre said:
Movement is only defined for Humans.
Noble warrior is entered twice
Combat manoeuvres for unarmed should include GRIP and TAKE WEAPON.
Thanks for these!
The Legend Core Rulebook is the only book I have, and the only Movement I see in it is for Humans. I would gladly add Races & Movement rates if I had them. (Or am I just missing it somewhere?)
edit...Oh wait...I see that to which you are referring now. I listed "Dwarf", "Elf", and "Halfling" in the drop-down list for Race, but did not include movement rates. Sorry about that...I threw those in for filler for the table, figuring that I would eventually be adding more races to the list. Not sure if the races would end up being the ones I listed, but just wanted placeholders for the data.
Noble Warrior duplication fixed.
Combat manoeuvres Grip & Take weapon added for Unarmed.
jwpacker said:
do you have any intention of having the skills that you automatically get, and don't have to select from, that are associated with your background or profession, be filled in automatically? I would be a horrendous set of nested IF statements, I'm afraid, but it sure would be nice. You know, when you're next on holiday.
I debated doing this before I posted the first version. I agree that this becomes a tedious part of the character creation when you have to do it over and over. This
is possible and I don't think it would be a hard as you might think. It might take a little time to setup the data tables, but probably not too bad. The reasons I left this out (at least so far) is 1) I think it allows for easier customization for gaming groups who use their own cultures or professions or who like to tweak which skills get bonuses or don't (especially if they are not well-versed in Excel); and 2) I try to be somewhat careful how much information to include in the spreadsheet. I don't want to include too much information in the spreadsheet and give people a reason to not purchase the books. I might make a second sheet with this once this one gets refined a bit.
GamingGlen said:
Assume your users are dummies (am I stating the obvious? ) and put in checks, such as '=IF (ISBLANK(cell), "", <show data or do the calculations>)' . ISNUMBER(cell) is another useful check. (FYI in case you do not know about these things.)
I did try to do this to some degree. After seeing your post, I went thru and cleaned up places where I saw the ugly #### and N/A and #VALUE type cells that show-up when data are missing. I also added validation to some cells to restrict the input. For example, you can now only enter whole numbers for the characteristics; alpha characters will not be accepted. Please let me know if there are any specific tabs/cells where you see problems or would like parameters set.
Thanks to everybody for their input! Keep 'em coming! :mrgreen: