I'm testing out the new sheet right now (building a Diabolist to see how it works).
One thing I immediately noticed is that the Initiative bonus for being a Divination-school wizard isn't added in (it's 1/2 your wizard level, minimum +1).
Also, where do I add in my favored class bonus (+1 hp or +1 skill rank)?
The bonuses to a ranger's favored enemies and terrains are not being found in the Class Abilities Summary (and therefore not displayed on the Abilities and Feats page). Ditto with the Ranger Combat Style feats.
First up, thanks for the quick test, and glad you are liking it!
I did some quick testing of the custom race and class. Overall they are nice improvements. I have the following comments:
* Ability points spent on Getting Started tab does not handle high values (try putting in a value of 21, it shows NA for "Cost" and "Spent" has ### error). This happens whether or not I have selected custom.
Needed to add a bit of logic to keep the calculations flowing. Fixed...
* New BAB and save input on custom classes works for me. Easy to change for classes that have custom progressions.
Hmm, it actually doesn't flow through if you change bits down in the table--those are there just to remind folks. I'll think about how to accommodate custom BAB and save progressions.
* Don't know if you want to deal with this, but what about custom classes that progress in more than one type of spell level (like Mystic Thaumaturge). One of my test characters has a custom prestige class that goes up one level of arcane or divine; and 1/2 level in the other. I think this could be handled with a new column ("2nd Caster Inc.") and box ("2nd Caster Level Increase Applies to:"). I can set every-other "2nd Caster Inc" to map the 1/2 level advancement.
Good suggestion, added this...
* Not sure if my perception modifiers were being correctly calculated (between using a custom race that had +2 and an Owl familiar who should add conditional +3). Have you automated that aspect of the familiars yet?
I put the familiar automation in place for today's iteration. However, it won't catch the conditional modifiers from the hawk and owl--I'd place that manually in the Conditional Mods section on the Front.
I was wondering the same thing, as my Druid friend has a non-standard companion.
* Speaking of animal companions and familiars, are you planning on adding a customization space (either on the tab or in the DataCompanions area)?
Something I do need to get in place, although I'm not sure it will make the cut off for v.0.8
I'm testing out the new sheet right now (building a Diabolist to see how it works).
One thing I immediately noticed is that the Initiative bonus for being a Divination-school wizard isn't added in (it's 1/2 your wizard level, minimum +1).
Also, where do I add in my favored class bonus (+1 hp or +1 skill rank)?
I've added the divination bonus for today's release. The Favored Class input area is on the Getting Started tab, right under the Favored Class block in Step 2.
The bonuses to a ranger's favored enemies and terrains are not being found in the Class Abilities Summary (and therefore not displayed on the Abilities and Feats page). Ditto with the Ranger Combat Style feats.
Ah, the tables gotten misaligned. Fixed (and used MATCH so they won't break again)
Thanks all, keep testing!
The Favored Class input area is on the Getting Started tab, right under the Favored Class block in Step 2.
I know how to declare my favored class. I was referring to each individual character level, where so long as you're taking a level of your favored class, you get to choose either +1 hp or +1 skill ranks (and you can make a different choice for each level). Where do you declare that? It seems like it should be under Step 3, contingent on the class you're taking a level in being the same as your favored class.
The Favored Class input area is on the Getting Started tab, right under the Favored Class block in Step 2.I know how to declare my favored class. I was referring to each individual character level, where so long as you're taking a level of your favored class, you get to choose either +1 hp or +1 skill ranks (and you can make a different choice for each level). Where do you declare that? It seems like it should be under Step 3, contingent on the class you're taking a level in being the same as your favored class.
You just put the values in the HP and SP boxes right below the favored class selector. It keeps a total of points you've allocated, so you know if you went over, and it filters those points to HP or skills as appropriate. So, for instance, if you had Ranger as a favored class and selected 8 levels of Ranger in Step 3, then the Points total in Step 2 goes to 8.
I'll put a box around this whole sub-section so it will hopefully be more clear.
KenderKin - click on Erien's profile pic and you'll see it.
Erian:
Consider making a separate sheet with macros that does the following:
1) Allows you to pull an old character sheet
2) Copies the contents of that old character sheet into a temp storage area.
3) Writes the information to the new character sheet.
This will require that cell references between the temp area from the copying sheet and the new character sheet remain identical, and it will need to be smart enough to put values copied from an old sheet into the right cells of the new sheet.
This keeps the macros fairly light weight.
I can send a sample of this sort of work (and one of my Excel atrocities) if you're interested. I would recommend making the cut off on 'oldest sheet format you can import from' version 8.
Okay, some preliminary feedback on the Diabolist.
- None of the Diabolist Class Abilities "wrap" (so part of each sentence gets cut off).
- Where can the imp companion be found? It shouldn't be rolled into the Familiar information, since technically a wizard can have both a familiar and an imp companion (plus the imp companion follows its own set of rules, modified by the druid Animal Companion Base Statistics table--it doesn't follow the standard familiar rules).
- The Damned ability doesn't seem to be "updating." Note that the Damned ability, gained at 1st level, is modified/supplanted by Hellish Soul at 5th level. Basically, once you hit 5th level, you lose the Damned ability and gain Hellish Soul.
Once you add in the imp functionality I'll test that. Thanks!
|
First off: Thanks for all your hard work on this beast! I had attempted something like this on my own and fell before the might of the data entry to accomplish this, so my hat's off to you on this endeavor.
Secondly, on the most recent sheet 7.18, with just messing around a little while on my lunch break at work I noticed that you can enter in Fighter bonus feats willy-nilly and they are incorporated into the workbook. I checked the Feats_Bonus_Fighter (Getting Started cell X104) cell and the check on that is =if(Lvl_Ftr>0,...) so it will accept anything placed in the bonus feat cells. I don't know if there is an easy fix to do a fighter level check so that it only accepts selections when the appropriate level is achieved or not.
I know it's not a complicated bug or formatting issue, but you've asked for input on this workbook so here's my 2cp.
Thanks again for all your hard work on this!! I know more people are using this than are thanking you so on behalf of all those without voice I thank you once again.
One other general thing I noticed: on your sheet a negative Con modifier can result in 0 hit points being gained per level. That is, if my Con modifier is -2 and I roll 2 hit points for the new level, your sheet is calculating this as 0. It should be 1; you can never "not gain" hit points by leveling up (same goes for skill points).
Two more on class customization:
* There is a bug on BAB for prestige classes, the pull-down does not change the progression (stuck on Mid).
* I am sure you have thought about this, but I was thinking about all the work you have done with automation, and how to take advantage of it on the custom classes. I think it is safe to say that most of the custom class abilities either already exist for other classes or map to existing feats. My suggestion then looks something like this:
Each level of the custom class gets three "ability pulldowns" (3 because that is the usual maximum, short of things like the Monk's first level). The ability pulldown allows selection of any existing class ability or feat (feats ignore normal prereqs). Any ability that is truly custom (e.g. not already existing in the official areas) can be entered as a custom feat.
Is that somewhat like what you were already planning?
I hadn't thought too much toward custom class ability automation as yet. I added some explanatory text to the fields to help folks out, but it's nothing as elaborate as the above. I'll think some more on it...
where is the most up to date sheet?
As AAG noted, the latest version is always linked in my profile...
Consider making a separate sheet with macros that does the following:
1) Allows you to pull an old character sheet
2) Copies the contents of that old character sheet into a temp storage area.
3) Writes the information to the new character sheet.This will require that cell references between the temp area from the copying sheet and the new character sheet remain identical, and it will need to be smart enough to put values copied from an old sheet into the right cells of the new sheet.
This keeps the macros fairly light weight.
I can send a sample of this sort of work (and one of my Excel atrocities) if you're interested. I would recommend making the cut off on 'oldest sheet format you can import from' version 8.
Sure, shoot that my way and I'll give it a look. Probably not anything I can get created for this release (and even then I'll likey maintain the baseline as macro-free). Thanks!
Just some notes on the witch class, the witch gets a hex at 1, 2 and then every even number, as well as at 10, get both a hex and a major hex.
I think I'm reading the hexes a bit differently for the Major and Grand hexes--since the abilities read "a witch can choose one of the following [TYPE] hexes whenever she could select a new hex" that says to me they choose the major hex in place of a new standard hex. Any other thoughts on this (or an "official" ruling)?
Also the witch gets bonus's for having a familier that aren't reflected on the character sheet (that I could see) like alertness feat, and skill bonuses.
I added the familiar bonuses in today, so they'll start showing up.
Hallo,
first i want to thank you for this very good und complete chargen.
Thanks for trying it out. I'm always happy to help new folks, and definitely appreciate bug reports!
But while crating an BETA Oracle i found 1 mistake.
On the P-Abilities & Feats Sheet the Revelations are not printed, because in the Class Abilities Sheet cell E437 is pointing to wrong cells in the Getting startet sheet.
I think I16x schould be replaced with V201, V203-V205 and AM203-AM205 (each line pointing to the next number)thanks
Ah, I needed to name those fields for use in calculation, actually. Fixed it!
Okay, some preliminary feedback on the Diabolist.
- None of the Diabolist Class Abilities "wrap" (so part of each sentence gets cut off).
- Where can the imp companion be found? It shouldn't be rolled into the Familiar information, since technically a wizard can have both a familiar and an imp companion (plus the imp companion follows its own set of rules, modified by the druid Animal Companion Base Statistics table--it doesn't follow the standard familiar rules).
- The Damned ability doesn't seem to be "updating." Note that the Damned ability, gained at 1st level, is modified/supplanted by Hellish Soul at 5th level. Basically, once you hit 5th level, you lose the Damned ability and gain Hellish Soul.
Once you add in the imp functionality I'll test that. Thanks!
For the wrapping, is it every ability, or only certain ones? Does this happen with any other classes (used to be a problem with bards)?
Good catch on the Hellish Soul, I've modified that.
No imp for this round, unfortunately. Had they gone with standard familiar or animal companion mechanics, I could have worked that in. As it is, I'll need to build the imp into the same format as the animal companion, but with separate mechanics. That'll take longer than I've got for this week given the push to get v.0.8 complete.
First off: Thanks for all your hard work on this beast! I had attempted something like this on my own and fell before the might of the data entry to accomplish this, so my hat's off to you on this endeavor.
It's definitely a lot of work, but I really enjoy it (I'm sick like that) and it actually helps me dig into the rules/mechanics for when I GM!
Secondly, on the most recent sheet 7.18, with just messing around a little while on my lunch break at work I noticed that you can enter in Fighter bonus feats willy-nilly and they are incorporated into the workbook. I checked the Feats_Bonus_Fighter (Getting Started cell X104) cell and the check on that is =if(Lvl_Ftr>0,...) so it will accept anything placed in the bonus feat cells. I don't know if there is an easy fix to do a fighter level check so that it only accepts selections when the appropriate level is achieved or not.
I know it's not a complicated bug or formatting issue, but you've asked for input on this workbook so here's my 2cp.
Thanks again for all your hard work on this!! I know more people are using this than are thanking you so on behalf of all those without voice I thank you once again.
This one comes in two parts, and the first one is an item I can't readily address at this time (it's one reason I bill this as a "character sheet" more than a "character generator"). Basically, I don't track specifically when a feat is taken at this time, and so the qualification formulas only consider total class level/BAB/feats gained/etc. rather than looking at specifically when the qualification was met. The other part--controlling the data validation--is something I've worked into the next iteration, so thanks for that suggestion!
One other general thing I noticed: on your sheet a negative Con modifier can result in 0 hit points being gained per level. That is, if my Con modifier is -2 and I roll 2 hit points for the new level, your sheet is calculating this as 0. It should be 1; you can never "not gain" hit points by leveling up (same goes for skill points).
Hmm, I had that in place at one point--must have overwritten the logic. I add a check to ensure that HP is at least equal to Character Level.
I am trying to add the mole prestige class from dragon # 310
It only has 5 levels.The name is on the front, I am getting BAB's etc.
The name mole appears under class abilities
but I can't get the abilities listed on the sheet....
So what am I doing wrong?
Had a copy/paste error from one of the things I moved down from the Custom Base Class area. Fixed it!
For the wrapping, is it every ability, or only certain ones? Does this happen with any other classes (used to be a problem with bards)?
All of the Diabolist abilities need wrapping. I'm not sure about other classes, though the Wizard ones seem fine.
I add a check to ensure that HP is at least equal to Character Level.
Note that this fix may not work (unless I'm misunderstanding your logic). Specifically, you need to verify that [current level rolled/generated hp] + [Con modifier] is never lower than 1. The favored class bonus adds on top of this, of course (but isn't figured into the "minimum"). That means the lowest hp you can gain per level for a favored class (where you choose to put your bonus into hp) is 2.
Wayfinder, PaizoCon Founder
|
Consider making a separate sheet with macros that does the following:1) Allows you to pull an old character sheet
2) Copies the contents of that old character sheet into a temp storage area.
3) Writes the information to the new character sheet.This will require that cell references between the temp area from the copying sheet and the new character sheet remain identical, and it will need to be smart enough to put values copied from an old sheet into the right cells of the new sheet.
This keeps the macros fairly light weight.
I can send a sample of this sort of work (and one of my Excel atrocities) if you're interested. I would recommend making the cut off on 'oldest sheet format you can import from' version 8.
THIS +1. Oh, how I would love this.
For all, I've completed bug fixes for all reported items, plus finished reformatting the rest of the Customization tab. I need to link the custom fields to the right locations for everything beyond race and class, then I'll have a release for today.
All of the Diabolist abilities need wrapping. I'm not sure about other classes, though the Wizard ones seem fine.
That's weird. Anyone else seeing this? Can you try a few other classes and see if they have a problem (specifically the bard). There was an issue with an earlier release doing this, but it had to do with using older versions of Excel and having text blocks longer than 255 characters. The latter does not apply to the Diabolist, however...
Note that this fix may not work (unless I'm misunderstanding your logic). Specifically, you need to verify that [current level rolled/generated hp] + [Con modifier] is never lower than 1. The favored class bonus adds on top of this, of course (but isn't figured into the "minimum"). That means the lowest hp you can gain per level for a favored class (where you choose to put your bonus into hp) is 2.
I calculate things like favored class, Toughness, familiars, etc. outside the standard section, so they will all lump on top of the minimum. I think this will work properly, but let me know if not.
Okay, the next iteration is ready:
Landscape Character Sheet File: PRPG_CS_L_v_0_7_19.zip
This one completes the reformat of the Customization tab and incorporates all the bug fixes noted to date. Hammer away!
Okay, I plugged my sample Diabolist into the new sheet (7.19).
- Hit points still aren't working quite right. For my example Wiz5/Diab10, I rolled 6,2,3,2,2,2,2,2,2,2,2,2,2,2,2. I have a Con modifier of -2, the Toughness feat, and all five levels of Wizard use the +1 hp favored class option.
Given that, since you can't "roll" less than 1 hp per level (before other modifiers), my rolls are effectively 4,1,1,1,1,1,1,1,1,1,1,1,1,1,1. Add in +15 hp from Toughness and +5 hp from the favored class option and the total should be 38. The character sheet is instead showing 35. Subtracting Toughness and the favored class option leaves 15, which is equal to my hit dice.
I think your calculations are allowing individual rolls per level to go below 1 so long as the total is equal to or greater than my HD/character level. You need to have your calculations look at each individual level's hp gain, not the total.
- Diabolist abilities still aren't wrapping on the "Abilities & Feats" screen. Additionally, the Wizard "Spellbooks" ability isn't wrapping (though the other Wizard abilities are).
- Still no imp (yeah, yeah, I had to mention it).
- Using the Improved Familiar feat, celestial animals don't seem to have SR (they should have SR equal to their CR/HD +5).
- This may affect any prestige class that adds levels to another spellcasting class. On the "Abilities & Feats" screen, under Wizard abilities, the number of spells per day per spell level (and their DCs) is listed. This list doesn't seem to be modified by the additional spellcasting levels added by the prestige class (in this case, Diabolist). Perhaps this is by design and beyond the scope of what you're trying to do.
- Racial abilities run together in a huge paragraph rather than being broken out as a list (like class abilities and feats).
- The equipment screen seems to already have information filled in (such as the backpack, pouch, and holy symbol). Perhaps only fill in class-specific equipment, such as a spell component pouch, spellbook, or holy symbol.
- Is there a way to distinguish between class skills from various classes? That is, as soon as you take a second class or a prestige class, is there a way to tell which skills are class skills for your various classes and prestige classes?
|
|
While "cleaning up" the file to have all blank entries to start with I discovered that if you manually enter in a blank selection on the Favored Class dropdowns and also have not entered a class in the level list that you get a free 20 pts to work with in the hp/sp option of the Favored Class section since you technically have 20 levels of your Favored Class - that being a "Blank" class.
There may be a more elegant way of fixing this, but I got it to work by adding the IF statements below to Getting Started Y14 and AA14 just before the COUNTIF statement:
Y14=IF(Favored_Class_1="",0,COUNTIF(List_Classes_Taken,Favored_Class_1))
AA14=IF(Favored_Class_2="",0,COUNTIF(List_Classes_Taken,Favored_Class_2))
That's all I've noticed in the first 10 min or so of working on the sheet today. (working with 7.19)
Any hope on including some way of applying the Half-* templates from the Bestiary? One of my BBEG's just gained the Half-Fiend template and the math is starting to hurt my brain. Using your sheet would be awesome for writing him up.
|
|
Okay, the next iteration is ready:
Landscape Character Sheet File: PRPG_CS_L_v_0_7_19.zip
This one completes the reformat of the Customization tab and incorporates all the bug fixes noted to date. Hammer away!
Will the landscape version be the only one updated from now on?
Hit points still aren't working quite right.
Hmm, I can't think of a good way to solve this at present. The problem with looking at HP gained each level is that the Con modifier is dynamic throughout the character's life, so the values may not stay valid. I'll think on this some more.
Diabolist abilities still aren't wrapping on the "Abilities & Feats" screen. Additionally, the Wizard "Spellbooks" ability isn't wrapping (though the other Wizard abilities are).
I've tested with Windows XP using both Excel 2007 and OpenOffice 3.1.1 and I cannot find any problem, so I've got no good fix for this right now. What OS/app are you using again?
Still no imp (yeah, yeah, I had to mention it).
Using the Improved Familiar feat, celestial animals don't seem to have SR (they should have SR equal to their CR/HD +5).
Yeah, the imp will be a bit down the road...
For the SR, I think this one should be good to go now.
This may affect any prestige class that adds levels to another spellcasting class. On the "Abilities & Feats" screen, under Wizard abilities, the number of spells per day per spell level (and their DCs) is listed. This list doesn't seem to be modified by the additional spellcasting levels added by the prestige class (in this case, Diabolist). Perhaps this is by design and beyond the scope of what you're trying to do.
Yes, the ability only describes what that actual class grants. The bumps would be noted in the prestige class information, but only as a static +X level. Once I get the Spell tab more automated, it will handle this much better.
Racial abilities run together in a huge paragraph rather than being broken out as a list (like class abilities and feats).
Yeah, I need to shorten the various racial ability descriptions to make this format better.
The equipment screen seems to already have information filled in (such as the backpack, pouch, and holy symbol). Perhaps only fill in class-specific equipment, such as a spell component pouch, spellbook, or holy symbol.
Those are just some standard items suggested by a user a while back. They are static/text entries and not auto-populated at all.
Is there a way to distinguish between class skills from various classes? That is, as soon as you take a second class or a prestige class, is there a way to tell which skills are class skills for your various classes and prestige classes?
Not at this time. Since it is no longer specifically relevant when a class skill is attained, this is not something I track.
While "cleaning up" the file to have all blank entries to start with I discovered that if you manually enter in a blank selection on the Favored Class dropdowns and also have not entered a class in the level list that you get a free 20 pts to work with in the hp/sp option of the Favored Class section since you technically have 20 levels of your Favored Class - that being a "Blank" class.
Ah, good one. I tweaked the class lists and data validation to preclude entering a blank.
Any hope on including some way of applying the Half-* templates from the Bestiary? One of my BBEG's just gained the Half-Fiend template and the math is starting to hurt my brain. Using your sheet would be awesome for writing him up.
I haven't looked into adding templates as yet, but it should be possible. I'll think on it as an item for the next big release.
Will the landscape version be the only one updated from now on?
No, I've only been doing the Landscape one as maintaining two versions through all the bug fixes would be a nightmare. As I'm wrapping up v.0.8, I'll be creating both Landscape and Portrait versions for the final release. That's actually what I'm doing now...
What OS/app are you using again?
I'm running Excel 2003 (fully patched, if that matters).
Okay folks, here's v.0.8, in both Landscape and Portrait formats:
Landscape Character Sheet File: PRPG_CS_L_v_0_8.zip
Portrait Character Sheet File: PRPG_CS_P_v_0_8.zip
All right, just started playing with .8 and... this... this is a thing of beauty, honetly. Cheers. Now, I've a question for you, we touched on this before. The magic items that give Int bonusus, and then have skills attached to them (to be specific, the Headband of Vast Intellect +4, gives a bonus of +4 to Int, and then has two skills attached to it). Curiousity requires me to ask, how are you planning on getting this? I mean, the Int bonus which wouldn't give overall skill points I can see, no problem. And, as the system works right now, it's fairly easy to set it, put the ranks given in the Misc Bonus column and note on the back page what.... ah but that's a problem.... say one of the skills needs a certain rank level for a prestige class... now you could of course just put them in the rank column and set the red flag... *checking*.. yeah that might work. It just red flags the skills column as you stand right now. So I'm just wondering what you're thinking on that.
|
|
Okay folks, here's v.0.8, in both Landscape and Portrait formats:
Landscape Character Sheet File: PRPG_CS_L_v_0_8.zip
Portrait Character Sheet File: PRPG_CS_P_v_0_8.zip
Love the sheet!!! I can only imagine the time you've put into this, and all for free...one very grateful user here!
Awesome. I'm liking the clean layout. I see Heirloom Weapon and the rest of the Adventurer's Armory traits in the Traits sheet, but they're showing up as a series of blank entries in the getting started tab.
Zo
EDIT: Interestingly, if I add Heirloom Weapon to the customization/custom traits sheet and select it in the getting started sheet, the correct entry from the traits sheet shows up instead.
All right, just started playing with .8 and... this... this is a thing of beauty, honetly. Cheers. Now, I've a question for you, we touched on this before. The magic items that give Int bonusus, and then have skills attached to them (to be specific, the Headband of Vast Intellect +4, gives a bonus of +4 to Int, and then has two skills attached to it). Curiousity requires me to ask, how are you planning on getting this? I mean, the Int bonus which wouldn't give overall skill points I can see, no problem. And, as the system works right now, it's fairly easy to set it, put the ranks given in the Misc Bonus column and note on the back page what.... ah but that's a problem.... say one of the skills needs a certain rank level for a prestige class... now you could of course just put them in the rank column and set the red flag... *checking*.. yeah that might work. It just red flags the skills column as you stand right now. So I'm just wondering what you're thinking on that.
Yep, that's going to be a tricky one. I'm thinking on how to build the logic so that it bumps up the total skill points available by the appropriate amount, but requires the points be used in a specific skill. We'll see where it lands!
Love the sheet!!! I can only imagine the time you've put into this, and all for free...one very grateful user here!
Thanks! Hopefully better things yet are still to come...
And I do have a request for any fans of the sheet. Head over to the Pathfinder Database and let your opinion be known with a vote! Heck, check out all the sheets over there and vote on them as well. There are some other really nice ones there and I think people generally benefit from seeing how well others like a particular offering.
Awesome. I'm liking the clean layout. I see Heirloom Weapon and the rest of the Adventurer's Armory traits in the Traits sheet, but they're showing up as a series of blank entries in the getting started tab.
Zo
EDIT: Interestingly, if I add Heirloom Weapon to the customization/custom traits sheet and select it in the getting started sheet, the correct entry from the traits sheet shows up instead.
Nuts, there's my first bug fix...I forgot to add in the logic for creating the dynamic drop-downs on those entries. Fixed for v.0.8.1
I am trying to get a Sorcerer 1st/Cleric 1st/Rogue 1st/Monk 2nd Lvl combo but I'm having problems with the Spell Tab, it has the level of 5, with 0 level spells as the Sorcerer and the Bonus as the Cleric.
Can we have a button to select which Spell caster aaplys for that sheet? That way we can copy to a new sheet then sleet the other spell caster on the 2nd sheet and then change the ability stat that applys for the 2nd caster.
ex. Spells Tab - Cleric, Spells 2 Tab - Sorcerer
The Spells tab is not automated to align with any character classes--you set the Caster Level and Key Ability manually (the "5" and "Wis" entries in the current release are left over from some playtesting but ironically matched your character somewhat). The route you suggest is exactly what I'll be doing with the sheet in future iterations...
Sorry for the confusion!
Rogue tricks are not showing up on the Ability sheet/tab (the fact that the rogue has a trick does--followed by a colon00but none of the trick-specific information does).
Rogue tricks are not showing up on the Ability sheet/tab (the fact that the rogue has a trick does--followed by a colon00but none of the trick-specific information does).
Hmm, looks like the Shadow Dancer rogue talent summary got deleted at some point. Fixed for the next iteration...
Class Abilities tab, Ranger's Hunter's Bond (companions option). The bonus is showing up as +0 instead of half of the ranger's normal favored enemy bonus.
Same page, Ranger's Combat style feats. The description in cell E138 is pointing to the wrong cells on the Getting started page (Z159, etc instead of V135, etc)
On the Back tab, the "Value" label for each magic item slot is not formatted correctly. Some of them are over the correct cell, while others are shifted over.
Portrait Character Sheet File: PRPG_CS_P_v_0_8.zip
This is awesome by the way. I can't rave enough about it.
Slight issue: it doesn't look like Speed is picking up modifications. I don't know enough about Excel to troubleshoot it. But I created a barbarian with light encumbrance and he is still showing a 30' movement rate, even when I add a +10' in the MOD: field. I actually tried adding +60' in the MOD field and it had no effect at all.
CJ
Class Abilities tab, Ranger's Hunter's Bond (companions option). The bonus is showing up as +0 instead of half of the ranger's normal favored enemy bonus.
Same page, Ranger's Combat style feats. The description in cell E138 is pointing to the wrong cells on the Getting started page (Z159, etc instead of V135, etc)
Got it, thanks!
I also tried this:
I reset the printing area to include the first 96 rows (so I expected that the print was correct)but again it didn't print the last rows.
Hmm, I'll fiddle around with OO a bit and see what I can come up with. I don't actually have any A4 paper on hand for a test, however...
On the Back tab, the "Value" label for each magic item slot is not formatted correctly. Some of them are over the correct cell, while others are shifted over.
Thanks, picked that up from the above report as well and so have corrected this issue.
This is awesome by the way. I can't rave enough about it.
Slight issue: it doesn't look like Speed is picking up modifications. I don't know enough about Excel to troubleshoot it. But I created a barbarian with light encumbrance and he is still showing a 30' movement rate, even when I add a +10' in the MOD: field. I actually tried adding +60' in the MOD field and it had no effect at all.
CJ
Looks like the Move_Mod_Total field got erased in the portrait version. I'm working to combine the two display/print format files into one, and so this should be okay in the next iteration. Note that it works correctly right now in the landscape version.
|
I was updating my character into your portrait sheet version and found a few oddity's.
1. Animal Companion sheet shows all zeros in the feat drop down boxes.
2. At the 6th level ranger combat style feat box it is only showing the second level options.
3. 5th weapon slot is not showing attack bonuses.
A few things i like to ask for customization.
1. any thought of adding a place for bonus skill points so that if someone gets awarded a bonus rank in a skill it does not cause the skill point count to go red?
2. I was able to use a feat that allowed my ranger and rogue levels to stack for favored enemy's. Is there a entry in the class ability tab that i can make that modification?
I'll be starting a new character for Legacy of Fire this weekend.
Think you'll have 8_1 up before then? (I vastly prefer the Landscape)
I was updating my character into your portrait sheet version and found a few oddity's.
1. Animal Companion sheet shows all zeros in the feat drop down boxes.
Problem with the dynamic list structure--fixed!
2. At the 6th level ranger combat style feat box it is only showing the second level options.
Problem with the data validation--fixed!
3. 5th weapon slot is not showing attack bonuses.
Problem with the formula copy/paste--fixed!
A few things i like to ask for customization.
1. any thought of adding a place for bonus skill points so that if someone gets awarded a bonus rank in a skill it does not cause the skill point count to go red?
You'll find this on the sheet already--it's the SP Mod field right above the Armor Check entry in the Skills title bar.
2. I was able to use a feat that allowed my ranger and rogue levels to stack for favored enemy's. Is there a entry in the class ability tab that i can make that modification?
This one would be a trickier bit of work. The various 3.5 feats that allowed one class to stack with another for specific class abilities would basically require custom tweaks in the abilities to stack the levels. Since those feats aren't OGC, I can't actually add them to the sheet officially. What you can do is modify the data validation for the Favored Enemy selectors--something like this:
=IF(Lvl_Rgr<$AL159,$AL$155,List_Favored_Enemies)
becomes
=IF(Lvl_Rgr+Lvl_Rog<$AL159,$AL$155,List_Favored_Enemies)
For any class ability related to Ranger level, you can search the sheet for Lvl_Rgr and, if appropriate, add in the tweaks.
I'll be starting a new character for Legacy of Fire this weekend.
Think you'll have 8_1 up before then? (I vastly prefer the Landscape)
Yes, I should actually have v.0.8.2 out, actually. I sent v.0.8.1 up to the Pathfinder DB to correct that issue with the Equipment traits. The next iteration will have Landscape as the base/data entry sheet, and most of the Portrait sheets as useable forms. The Front tab will have a "print" portrait version that pulls info from the landscape Front tab. All are done (along with all the bug fixes and adding the Jotunnar class/race) except the Front tab and I'll be working on that tomorrow.
Finally pulled down the .8 release and things have definitely changed for the better. Really like what you have done with the sheets and the organizational changes you've made.
I was playing with the Customization section and in particular the class and custom feats sections.
First, I was playing with a feat from SGG to Feats of Battle and it has several criteria including several feat pre-reqs. I wrote part of the validation, but couldn't figure out how to get it to do validations for three different feats. It told me the formula was too long or some such thing. Is there a way to do this in the customization piece.
Second, I added a custom class on the customization page, adding the names of the various level abilities for each level. All worked fine, but then when I got to adding the class to the character sheet it was fine, but then I went to the back page I think it is, and where it shows the class abilities, it showed #REF. Did I do something incorrectly on the custom class section?
Thanks.
Finally pulled down the .8 release and things have definitely changed for the better. Really like what you have done with the sheets and the organizational changes you've made.
Thanks! The discussions on this thread have been instrumental in shaping the current version...
I was playing with the Customization section and in particular the class and custom feats sections.
First, I was playing with a feat from SGG to Feats of Battle and it has several criteria including several feat pre-reqs. I wrote part of the validation, but couldn't figure out how to get it to do validations for three different feats. It told me the formula was too long or some such thing. Is there a way to do this in the customization piece.
Hmm, copy the formula here and I can take a look. Also, I've acquired many of the SGG PDFs and plan to incorporate the material officially, including Feats of Battle. If you are already working on these, I could jumpstart my work from that...
Second, I added a custom class on the customization page, adding the names of the various level abilities for each level. All worked fine, but then when I got to adding the class to the character sheet it was fine, but then I went to the back page I think it is, and where it shows the class abilities, it showed #REF. Did I do something incorrectly on the custom class section?
Thanks.
Sounds like the Abilities and Feats tab had a hiccup. I believe that is from a Reference error I already corrected for v.0.8.2, so you should be good to go once I get that iteration out (hopefully tomorrow). Do give it another test run, though, and let me know if you run into the problem again.
Hi Erian,
I was just adding a couple of feats on the Customization tab just to see how it worked. I didn't actually save anything on the one or two I added. I was just following the example that shows in the comments piece when you click on the qualified cell.
And you were right it was the Abilities and Feats tab. I wrote this late last night and I didn't have the file in front of me.
That's very cool about adding in the SGG stuff. Looks like they have done some nice work. Now to convince my DM to let me use some of it....
Edit: Looking at your feats tab, I see how you added multiple feats known criteria. I didn't add enough And's/Or's/IsNumber's.
Hi Erian,
I was just adding a couple of feats on the Customization tab just to see how it worked. I didn't actually save anything on the one or two I added. I was just following the example that shows in the comments piece when you click on the qualified cell.
And you were right it was the Abilities and Feats tab. I wrote this late last night and I didn't have the file in front of me.
That's very cool about adding in the SGG stuff. Looks like they have done some nice work. Now to convince my DM to let me use some of it....
Edit: Looking at your feats tab, I see how you added multiple feats known criteria. I didn't add enough And's/Or's/IsNumber's.
Ah, good deal. There are various ways you can arrive at the logic--using the nest AND/OR/ISNUMBER approach generally works well but be sure the ISNUMBER criteria is unique. On the feats tab, I sometimes just point directly at the TAKEN field and you could do the same.
SGG supported my efforts to bring in 3rd Party OGC very early on with their contribution of the Shaman class. I found their approach their very interesting and distinct from most other "make it a spontaneous druid" takes on the concept, so I gladly purchase and allow their material. I'll eventually have all material from SGG in the sheet, as well as material from 4 Winds Fantasy Gaming, Alluria Publishing, and Rite Publishing. I'm looking at material from other publsihers as well, like LPJ Games, Reality Deviants, etc.