Hi Erian
possibly a bug: "DataSkills" sheet, F26 formula should contains "Half-Orc" (capitalized initials) instead of "Half-orc" to trigger +2 racial bonus, when such race is chosen.my 2c, thanks for updating in your next drop if I'm not missing anything...and THANKS for the great work, really very useful to myself + team!
Good eye...fixed it for the next release!
Hi Erian, great looking sheet. I DL'ed a previous version but I have not had a chance to use it. Today, a few minutes ago actually, I clicked on the above link and I am getting a message saying that the site is not here. Looking at all the postings in this thread Wouldn't give the impression that it was down. Is this just an error on my end?Thanks! We're actually up to v.0.7.10, and as I was running low on space I removed the old files. You can always find a link to my latest version in my Paizo profile.
Thank you very much!
Adding a custom feat on the Customization tab automatically adds that feat to the "Abilities & Feats" tab, "Feats" section. The Feat text Logic in the "Feats" tab (Cells O317 through O321) needs to be modified. If I copy the formula from one of the other pre-existing feats, everything works as normal. But if I copy this formula to a row without any feat data, the Feat Logic Cell spits out ":-". Something like this should work:
=IF(A317="","",IF(ISNUMBER(FIND(A317,Feats_Known)),"- "&A317&": "&H317,""))
When adding a Custom PrC to the Customization tab, the Class and Class Abilities are always entered on the "Abilities & Feats" tab, "Class Abilities" section. This is probably not a bug, seeing as how I suspect that most users won't be entering in a custom PrC that their character won't use. And I don't know how to fix this without writing some Qualification formulae in the "Class Abilities" tab.
I'm hoping to create a custom sheet for my campaign, pre-entering all of the allowed PrC's, feats, etc. But it looks like I won't be able to do that without writing a bunch of stuff, similar to how the other PrC's are hard-coded. Doing this for every revision is a drag, but I'm willing to do it.
And adding the "manual Bonus Feats" is a winner for me, as I used to add that myself for the previous revisions. This saved me some time and effort.
Thanks for everything!
Adding a custom feat on the Customization tab automatically adds that feat to the "Abilities & Feats" tab, "Feats" section. The Feat text Logic in the "Feats" tab (Cells O317 through O321) needs to be modified. If I copy the formula from one of the other pre-existing feats, everything works as normal. But if I copy this formula to a row without any feat data, the Feat Logic Cell spits out ":-". Something like this should work:
=IF(A317="","",IF(ISNUMBER(FIND(A317,Feats_Known)),"- "&A317&": "&H317,""))
Excellent suggestion--modified for the next release!
When adding a Custom PrC to the Customization tab, the Class and Class Abilities are always entered on the "Abilities & Feats" tab, "Class Abilities" section. This is probably not a bug, seeing as how I suspect that most users won't be entering in a custom PrC that their character won't use. And I don't know how to fix this without writing some Qualification formulae in the "Class Abilities" tab.
Yes, my assumption is anything entered on the Custom tab is going to be something the character actually has. I want to put some more thought/effort into the custom class ability functionality, as it is indeed a complex little bit of work, but that'll have to wait until I've got this next major release complete.
I'm hoping to create a custom sheet for my campaign, pre-entering all of the allowed PrC's, feats, etc. But it looks like I won't be able to do that without writing a bunch of stuff, similar to how the other PrC's are hard-coded. Doing this for every revision is a drag, but I'm willing to do it.
My suggestion for folks with large amounts of custom data is to add it in at the bottom of a table or data set. If it's kept all together, you can just cut that section out and move it to the next release. There is some complication for this in the feats and class abilities due to how the data is compiled for display--one of the limitations of not using any VBA/macros and instead manually compiling the info. If anyone has a better method that is more friendly to customization, do let me know!
And adding the "manual Bonus Feats" is a winner for me, as I used to add that myself for the previous revisions. This saved me some time and effort.
Thanks for everything!
Thanks for the feedback! Having some simple manual overrides seems like an easy way to achieve customization without too much fiddling on the other tabs.
"Customization" Tab, under "Custom Prestige Class", the Data Validation for the Saving Throws should be 7 and 8, not 5 and 6. 7 and 8 refer back to Table_Level_Dependent for Prestige Class Saving Throw Progression while 5 and 6 refer to the Base Class Save Progression.
The Class Skills for Custom PrC's are not being entered into the DataClasses tab. And if you copy the existing logic from another class into each cell, they all return "1".
Suggestion:
=IF(Customization!W11=0,"",IF(ISNUMBER(FIND($B$68,Class)),1,0))
You will need to change "W11" to "X11", "Y11", etc for each skill as appropriate. This formula will return a #FALSE for the first "IF" statement if the Custom PrC cell is blank OR "0", giving the desired result no matter what.
Thanks, I'll work these fixes into the next release.
Also, Dustin seems to be having a problem with the text in the Class Abilities section of the Abilities and Feats tab--it is not wrapping for him. I've been unable to duplicate this error, but he's using Excel 2003 SP3 versus my Excel 2007. Are any other users seeing a wrapping issue on that tab (or any tab for that matter!)?
Three Glitches found:
Back tab, cell AQ2: The statement that pulls the XP progression has
ISNUMBER(FIND("Medium",XP_Progression)
which should be
ISNUMBER(FIND("XP Med",XP_Progression)
The cells where MONEY is labeled need to be centered and merged (cells AC135)
Not all of the cells in column O on the Feats tab have their requisite formula for pulling information in - this can be fixed with a simple copy and paste. For example, cell O240 is blank, rather than holding this equation:
=IF(ISNUMBER(FIND(A240,Feats_Known)),"
- "&A240&": "&H240,"")
Hey folks, I haven't forgotten about you...lots of work and baby stuff, so not much progress in the last few days. However, with the release of the consolidated/updated APG preview, I'll be updating the new classes with the latest info.
hope the family is well and your getting some sleep (been there done that)
Was wondering if a new release would be coming soon and if it would incorporate all new classes since the final playtest for the advanced player guide pdf is out?
Again, thanks for all the excellent work
Do remember that the PDF is still a playtest version and could be changed (either a little or a lot) between now and the final version prior to publication. So while it is nice to have the playtest classes in the form, minuscule changes can be overlooked if we depend on the way we look at them now.
|
Do remember that the PDF is still a playtest version and could be changed (either a little or a lot) between now and the final version prior to publication. So while it is nice to have the playtest classes in the form, minuscule changes can be overlooked if we depend on the way we look at them now.hope the family is well and your getting some sleep (been there done that)
Was wondering if a new release would be coming soon and if it would incorporate all new classes since the final playtest for the advanced player guide pdf is out?
Again, thanks for all the excellent work
I agree with you.
I understand putting the energy into creating the sheet with beta might seem wasted since changes will occure. I would argue haveing even just the playtest/Beta versions on the sheet actually helps the playtest.
I have ran a oracle for the last few months and while it does have a few bugs, I can correct those once I print out a sheet.
Data sheets in general are so useful because it speeds up character creation and then gameplay. I love this sheet because it is in the format that I like.
Howdy! I am indeed intending to get the APG classes updated--did you possibly miss my post right before yours? ;^)
Time frames are sketchy--the sleep deprivation has caught up with me, so I'm finding it difficult to concentrate properly on the modifications I need to make after also putting in an 8 hour day at the office slogging through contracts and budgets. However, the baby has been successfully sleeping in her crib for several nights now, which promises a new "day" in sleep opportunities for us!
EDIT: Oh, and all issues reported to date have been resolved. Thanks!
Howdy! I am indeed intending to get the APG classes updated--did you possibly miss my post right before yours? ;^)
Time frames are sketchy--the sleep deprivation has caught up with me, so I'm finding it difficult to concentrate properly on the modifications I need to make after also putting in an 8 hour day at the office slogging through contracts and budgets. However, the baby has been successfully sleeping in her crib for several nights now, which promises a new "day" in sleep opportunities for us!
Is there anything we can do to assist with the project?
We have "retired" my youngest daughters pacifier (we call them dummies in Australia). So Sleep has been broken while she gets used to not having one. So I can sympathise with the lack of sleep.
|
|
I feel your pain. My two girls (3 1/2 and 2). While they quickly made it to sleeping through the night, my oldest is now getting up at midnight or 3 am and turning on tv and watching cartoons. arg!!!!
Sorry I missed the post. In my head I had a few games coming up and new ideas. Wanted to pop in, look, if no update...ask, then go back to errands.
Again, thanks for everything
Hey, no need to apologize. It just struck my funny bone...of course that may have again be the lack of sleep! :^D
We've got a son turning 6 next month and he's definitely gone through phases--not sleeping, then sleeping all night, then waking up at 2 AM every morning wanting someone to sleep with him, then sleeping all night but waking up at 6 to watch cartoons and drink "choci milk" with some snuggles! We've rolled with it, knowing that at some point here soon he'll likely be in the "I don't need mom and dad" phase...
As for assistance, I'd take all sorts. Depending on level of skill, my primary focus right now is feat and trait automation (requires pretty deep skill in Excel) and getting the classes in place (for both the APG and LSJ; requires entering the classes in the DataClasses tab (pretty easy), copying the class abilities into separate cells (easy), then building the formulas to use the class abilities (moderate), and finally automating the actual class abilities (complex).
I'm working feat automation right now, so work on any of the other items would not conflict with my efforts unless a bug is reported for a fix. Anyone interested in the above, let me know and we can talk more via email (don't want to clutter folks up here!).
Thanks!
Found a Name error trying to create a wizard. No class abilities display in the Abilities & Feats summary. It seems to originate from Class Abilities E94 (I'm an Excel amateur) with a reference to a non-existant Table_Spells_Per_Day_Wizard.
Any idea how I can fix this until corrected by version?
Thanks for the great work!
Found a Name error trying to create a wizard. No class abilities display in the Abilities & Feats summary. It seems to originate from Class Abilities E94 (I'm an Excel amateur) with a reference to a non-existant Table_Spells_Per_Day_Wizard.
Any idea how I can fix this until corrected by version?
Thanks for the great work!
Ah, good catch. The problem is in the Cantrips formula (in cell E194). Change it to the following and you should be good to go:
=VLOOKUP(CL_Wizard,Table_Spells_Per_Day_Max,2,0)&" cantrips per day (DC "&10+Int_Mod_Current&"), cast like any other spell, but do not expend any slots and may be used again (cantrip from opposition school uses up two of available slots)"
|
|
I like the design on this.
Found a couple errors, I think. When setting the XP speed, XP Med shows up as the PFS stat of 3 at 1st level, 6 at 2nd, etc.
Also, not sure if this is an error or not, but the skills limit points to spend, but I can choose languages to fill the boxes without anything stopping me, including Druidic which is supposed to be a secret language known only by Druids.
Keep up the good work. This is the best one of these I've found so far.
I like the design on this.
Found a couple errors, I think. When setting the XP speed, XP Med shows up as the PFS stat of 3 at 1st level, 6 at 2nd, etc.
Also, not sure if this is an error or not, but the skills limit points to spend, but I can choose languages to fill the boxes without anything stopping me, including Druidic which is supposed to be a secret language known only by Druids.
Keep up the good work. This is the best one of these I've found so far.
Thanks for the notes! I've corrected the XP issue (bad references in the VLOOKUP formulas).
For the Languages, I do not have any restrictions placed on it at present--basically a GM would have to verify the character is properly built in this regard. I could build in a Skill Ranks + Int Mod limiter, but I'd have to fix the Int mod to its 1st level value. Should be able to work something up for that...
Quick post to let folks know I'm down to 50 Paizo OGC feats left to automate. Once I complete that (tonight or tomorrow) I'll be posting an incremental release with all the fixes. I'm shifting then to trait automation, and will wrap up with the APG classes. I'm going to bundle that as the next major release, then shift entirely into 3PP support (feats, classes, bloodlines, and domains--esp. the LSJ material) plus hammering out the animal companion/familiar/eidolon page(s).
Yay, it's done!
Lot's of testing/verification needed for this pass for any of those folks looking to volunteer some time...I have, I believe, captured and automated every OGC feat Paizo has produced for Pathfinder and Golarion. So, need verifications on the automation, plus verification that I didn't miss any feats anywhere! You can work up an Aldori Dueling Master and it should work, as should a Thunder and Fang Shoanti from the Axe Clan. The various houses of Cheliax are in place, etc.
So, I'm obviously eager to have folks check this one! It should also incorporate all fixes for issues noted to date.
Now, off to bed...
Character Options Tab, Cell N37 (Name=Weapon_Focus_1). The Data Validation points to the wrong list (List_Weapon_Prof_Exotic instead of List_Weapon_Feats)
And what about the PF Beta Feats?
Thanks, fixed that...
For the PRPG Beta, I just added the missing feats were Backswing, Devastating Blow, and Overhand Chop. Any more in there I missed?
|
Hi erian_7,
Sorry if I missed this in the thread, but Spell Focus (Conjuration) is still not showing up in the Abilities and Feat tab when I select it as a feat for my Wizard. I tried selecting it as a Manual Bonus Feat, a Selected Bonus Feat, and as a regular Feat.
Also, Pathfinder Society Wizards receive Spell Focus as their bonus feat instead of Scribe Scroll. Any plans to add this as an option?
As always, great application. My group loves it.
Didn't even know that was broken! I fixed it, along with a host of other feats that were missing their summary description formulas.
I also added in the PFS variant for wizards.
Oh, and I've got all the Race traits automated (at least those I can--conditional items like "get +X while on a boat" are still a manual thing...).
|
On the front tab the languages showed a 1 for starting languages when i should of had 2. Looked up the Int_Starting formula and it only was selecting the score in the initial attributes and didn't take in to consideration racial mods.
Edit: Tried to modify the formula but adds other int formulas wrong i need to look into it further
On the front tab the languages showed a 1 for starting languages when i should of had 2. Looked up the Int_Starting formula and it only was selecting the score in the initial attributes and didn't take in to consideration racial mods.
Edit: Tried to modify the formula but adds other int formulas wrong i need to look into it further
Ah, I forgot to add the racial Int modifier in the formula. It should read:
=VLOOKUP(Int_Starting+Race_Int,Table_Ability_Mod,MATCH("Modifier",Header_Ab ilities,0),0)+Skill_Ranks_Linguistics
|
|
What a wonderful tool! Thanks you so much Erian and everyone else whose working on this.
I have a couple of questions (I assume they're not problems with the sheet, just me not knowing how to use it).
1. I'm building a rogue with the Finesse Rogue and Weapon Training talents. I select them 2nd and 4th level from the rogue options menu. Then what? They don't seem to be registering as feats. When I look at the Abilities & Feats tab, they list as talents have, but the corresponding feats don't show up as feats, and I don't get the benefits, so I think there is something else I need to do to actually get them as feats. What? [Note: when I choose Weapon Finesse from the little DM-granted feats menu, it does show up and I do get it calculated in.]
1A. I see the Weapon Training box at the bottom of the rogue options menu, and it has Weapon Focus [] as a choice, which I've selected, but I can't figure out how to add rapier.
2. On skills, I want to take some ranks in Profession (gambler). I see Profession []/ How do I add the word "gamble" to that? I tried just typing it between the brackets but I got an error message.
2A. Because I've multiclassed, skills are out of alphabetical order. Do I just use Excel's sort function to alphabetize them?
3. The hit point column in the level-by-level progression list. My total hit points are showing up correctly on the Front character sheet, but the level-by-level HP column is blank. Is that how it supposed to work? Is this column only supposed to be used to over-ride for rolled HP or something? Just curious.
Thanks again.
BTW - Sorry for the how-to questions if this is meant to be just a development thread.
What a wonderful tool! Thanks you so much Erian and everyone else whose working on this.
I have a couple of questions (I assume they're not problems with the sheet, just me not knowing how to use it).
1. I'm building a rogue with the Finesse Rogue and Weapon Training talents. I select them 2nd and 4th level from the rogue options menu. Then what? They don't seem to be registering as feats. When I look at the Abilities & Feats tab, they list as talents have, but the corresponding feats don't show up as feats, and I don't get the benefits, so I think there is something else I need to do to actually get them as feats. What? [Note: when I choose Weapon Finesse from the little DM-granted feats menu, it does show up and I do get it calculated in.]
This one I don't know - never built a rogue with this before.
1A. I see the Weapon Training box at the bottom of the rogue options menu, and it has Weapon Focus [] as a choice, which I've selected, but I can't figure out how to add rapier.
2. On skills, I want to take some ranks in Profession (gambler). I see Profession []/ How do I add the word "gamble" to that? I tried just typing it between the brackets but I got an error message.
Both of these are handled in the Character Options Tab. N37 is the start of where you enter the block for Weapon Focus and Improved Critical feats. D38 is where you enter professions and have them show up on your list.
2A. Because I've multiclassed, skills are out of alphabetical order. Do I just use Excel's sort function to alphabetize them?
Yes. Though the skills are automatically sorted in a very useful way - they're sorted alphabetically first by those that can be used untrained, and then those that can't be used untrained.
3. The hit point column in the level-by-level progression list. My total hit points are showing up correctly on the Front character sheet, but the level-by-level HP column is blank. Is that how it supposed to work? Is this column only supposed to be used to over-ride for rolled HP or something? Just curious.
Click on cell J5, and it will explain which of four hit point options the sheet will use. The default is option 1, which is full HP at 1st level and half plus one thereafter. Option 4 lets you manually input whatever you rolled for each level.
BTW - Sorry for the how-to questions if this is meant to be just a development thread.
It's only by people using it that we make it better.
- Ken (Sometime contributor to this sheet.)
Thanks for the assist, Ken! Looks like you covered most everything. For the Rogue, Ken's directions on the Weapon Focus issue will get you going there. Once you select a weapon in cell N37, you can then select Weapon Focus [Whatever you put in N37] for Weapon Trick. It's not as smooth as I'd like and I'm thinking on a better way...For Finesse Rogue, mine seems to be working fine. I'm assuming you are using the latest version of the sheet?
For the skill sorting, as Ken points out I've got them sorted by default to have all the Trained Only skills at the bottom. I do this personally so that after I've made a character I can delete all of the lines in the skill section I don't need (which is usually a lot of the Trained Only lines) and reuse that space for something else--say a Special Notes section for often used abilities/spells/etc. You can definitely sort them any way you'd like, but I'd recommend setting them up manually (i.e. changing each skill in the drop-down menu) rather than an Excel sort as I don't think Excel will play very nice with that heavily-formatted area. Once you've got the skills in an order you like, save that copy for future use. Even when I put out a new version, you can just copy the skill names from the old sheet to the new and it will be ready to go.
And definitely bring on the questions! User interface is something I want to really focus on as I move into the latter phases of this effort, so that sort of feedback is very useful. I'd really like to put together a users guide or some such eventually. This sheet will do tons of stuff that many folks may not even realize since it's little tweaks and twists that may not be as obvious as I assume...
Thanks!
|
|
Both of these are handled in the Character Options Tab. N37 is the start of where you enter the block for Weapon Focus and Improved Critical feats. D38 is where you enter professions and have them show up on your list.1A. I see the Weapon Training box at the bottom of the rogue options menu, and it has Weapon Focus [] as a choice, which I've selected, but I can't figure out how to add rapier.
2. On skills, I want to take some ranks in Profession (gambler). I see Profession []/ How do I add the word "gamble" to that? I tried just typing it between the brackets but I got an error message.
Okay, I tried these, with mixed success. Once I selected "rapier" from the drop-down list in N38 I was able to select "Weapon Focus [rapier]" for my rogue weapon training. However, when I look at the stat block for my rapier on the Front tab, I'm not seeing the +1 to hit reflected. And it doesn't show up on my feat list on the Back tab; it shows that I have the rogue talent that gives it to me as a bonus feat, but doesn't show the feat. Also, N38 and N39 seem to offer the full list of weapons to choose from, while N37 only offers exotic weapons. Is that intentional?
On skills, once I entered "gambler" in D39, I was then able to type "gambler between the brackets of "Profession []" in the skills list. So that works, but is there any particular reason you didn't just make this a drop-down list? Typing it in twice works, and is probably a fine solution for oddball professions that people create themselves, but there is a finite (albeit long) list in the core rules. Your drop-downs just seem more ... elegant.
2A. Because I've multiclassed, skills are out of alphabetical order. Do I just use Excel's sort function to alphabetize them?Yes. Though the skills are automatically sorted in a very useful way - they're sorted alphabetically first by those that can be used untrained, and then those that can't be used untrained.
Just personal preference - I like 'em alphabetical. But I see Erian's point about not sorting - those are some complicated fields and they're TINY and it'd be hard to know which one to sort by. So I'll go with manual. I just noticed that the skills are also drop-down menus, so I can just select which feat I want where. If anyone else does this, just jot down your skill ranks first 'cause they won't port with the skill (not that they should, I just didn't think of it before I started re-ordering them).
Question (and not a criticism) - Any reason not to give skills their own tab? I'm used to using PCGen, which does have a separate skill tab. It's kinda handy 'cause you can sort skills by alpha, ranks, or total bonus while adding skill points, but they always show up in a fixed order on the character sheet. Again, not a criticism, just food for thought.
3. The hit point column in the level-by-level progression list. My total hit points are showing up correctly on the Front character sheet, but the level-by-level HP column is blank. Is that how it supposed to work? Is this column only supposed to be used to over-ride for rolled HP or something? Just curious.Click on cell J5, and it will explain which of four hit point options the sheet will use. The default is option 1, which is full HP at 1st level and half plus one thereafter. Option 4 lets you manually input whatever you rolled for each level.
Right, I see that. I picked Option 1. I guess - because of the blank column - I expected to see little HPs showing up at each level, even the 1/2+1. Certainly not necessary, and like I said, the total comes out fine, that empty column just looks a little lonely :)
4. And my Weapon Finesse is definitely NOT showing up. Do I need to do something to trigger it? I'm trying to get it via Finesse Rogue, not as a feat. If I select it as a regular feat, it works. When I select Finesses Rogue, I get Finesse Rogue, but not the feat effects. And like Weapon Training/Weapon Focus, it doesn't show up on my feat list on the Back tab; it shows that I have the rogue talent that gives it to me as a bonus feat, but doesn't show the feat.
BTW- Erian asked, I'm using version 0.7.11. And please take any nit-picking in the context of my utmost appreciation for the fine character builder you've put together and a recognition of the hours of work you've put into this. Thanks again.
Pick away--it's the best way for me to find the little problems I might otherwise miss!
Now, something screwy must be going on with this, so let me walk through the steps that I'm doing and see if that works for you. This is from a clean copy of v.0.7.11:
.
- Select Starting Abilities (I used a standard array as follows).
STRENGTH--12
DEXTERITY--14
CONSTITUTION--10
INTELLIGENCE--15
WISDOM--8
CHARISMA--13
- Select Race (I chose Human).
- Select Ability bonus (I chose Dexterity)
- Select Favored Class (I chose Rogue)
- Select Bonus Feat (I chose Dodge)
- Set Craft, Perform, and Profession skills if required (I set Profession to gambler)
- I did not set any Manual Class Skill or Bonus Feat overrides
- Select Class levels (I set Rogue for levels 1-4)
- Select Feats by level (I chose Mobility and Point-Blank Shot)
- Select Character Traits and Racial Skill Bonus if required (I skipped these for now)
- Set Weapon Focus (I selected Rapier)
- In the Base Class Options, set class options as needed (I set Rogue level 2 to Finesse Rogue, Rogue Level 4 to Weapon Training, and Weapon Training to Weapon Focus [Rapier]
At this point, the Abilities & Feats tab shows Finesse Rogue and Weapon Training in the Class Abilities section and Weapon Finesse and Weapon Focus [Rapier] in the Feats section.
On the Front tab, if I set a Weapon block to Rapier (with Combat Options set to 1-Handed). I have a total attack bonus of +7 (+3 BAB, +3 Dex, +1 Weapon Focus). If I go back and change the rogue talents to remove Finesse Rogue and Weapon Training, the Rapier total attack bonus resets to +4 (+3 BAB, +1 Str).
Now, in going through this process I did find a few things I want to clean up (such as qualifiers in the Feats_Bonus_Rogue field to exclude fields if the relevant talent is not in the Rogue_Talents field) but the actual desired effect--a rogue with Weapon Finesse and Weapon Focus [Rapier]--is definitely successful. Are you doing something similar to the above? Are you typing in the selections rather than using the drop-down (I ask because I noticed I don't have the Ignore Blank option selected on the Data Validation, which means you can type an entry and a misspelled word would result in the talent not being recognized).
For your other findings, the selector issue in cell N37 was reported earlier and will be fixed in v.0.7.12 (you can fix it now by simply copying N38 to N37).
For the reasoning behind the Profession (and Craft) entries being free-text, I use Data Validation to create drop-downs for cells where the data has to be a certain way in order to trigger other events. Data Validation, however, restricts the cell to only showing the options listed unless the Ignore Blank option is selected (as with the Rogue Talents issue above). Since both Craft and Profession can be set to almost anything the player thinks up, I didn't want players thinking they are restricted to the given list. I'm not opposed to actually using a list with the Ignore Blank feature selected, and it could actually help for certain feats/traits to function off specific Craft/Profession options. I could include instructions in the data validation display text telling folks to manually enter if necessary. Any thoughts from others on this?
For the separate Skills tab, that is an option to consider. The current functionality is from one of my original design goals--keep as much functionality as possible on the actual character sheet so that it can be used "live" in a game session. Thus the skills are in the traditional character sheet location for both display and function. Beyond this, if I pull the skill information in from another source (as I do with the Feats, for instance, on the Abilities and Feats tab) then I'll have to have a set size for the display area. I didn't mind this for the feats, since that whole sheet is dedicated to the display, but for skills it could mean a lot of wasted space for characters that don't use many skills. Anyone else have thoughts on this one?
Keep skills as they are is my vote.
Thanks ceer78, I'll check on those issues.
As a general note, I've been reworking the Class Options to more intelligently handle selections, and have also automated some more class features (finally got Trap Finding in place, automated the Weapon Group attack/damage bonus, automated Arcane Archer attack/damage w/ bows).
Okay, next release is ready for review. I'm pretty excited about this one, as I completed a full revamp on the traits to make automation much easier. All feasible traits have now been automated, and all that contain items I can't automate display a note regarding such on the Abilities and Feats tab. This release of course also includes all fixes for issues noted to date, plus adds automation for the fighter weapon group attack/damage bonuses, adds in the Trap Finding sub-skill as a selection in the Skills list, and adds a lot of user-interface improvements on the Character Options tab. I've also locked the pages (as it would be in a full release) so you guys can help me find the inevitable cells that I modified and Excel "conveniently" locked in the process.
So, hammer away!
Character Sheet File: PRPG_CS_v_0_7_12.zip
|
|
Hi Erian. I tried the finesse/weapon training build an a fresh sheet and it worked fine. Then I built my guy on a fresh sheet, and it worked fine too. I must have accidentally erased something in those rogue talent cells to make them stop working.
New observations:
1) Bards can use all Knowledge skills untrained. That's not showing up automatically. I found the code for that on the DataSkils tab and changed it for my bard, but it should probably get built into the sheet.
2) I added a light crossbow and it seems to be adding my Str bonus when I hold it one handed and 1.5 Str bonus when I hold it two handed. But crossbow shouldn't get Str bonuses. Right now they're working like melee weapons.
2.5) I added a longbow just to see what happens, and it did the same thing. I don't know bows as well, but I think that's only supposed to happen if you get a strength bow.
Oh, and I tried Sorting just the skill name column (and not the modifiers and everything) and it seems to be working fine; all the modifiers auto fill based on the skill name.
I look forward to playing with the new version! Thanks
Hi Erian. I tried the finesse/weapon training build an a fresh sheet and it worked fine. Then I built my guy on a fresh sheet, and it worked fine too. I must have accidentally erased something in those rogue talent cells to make them stop working.
Good deal, glad to know it's working!
1) Bards can use all Knowledge skills untrained. That's not showing up automatically. I found the code for that on the DataSkils tab and changed it for my bard, but it should probably get built into the sheet.
Hmm, that was definitely working before. I must have broken those formulas when I was rebuilding the DataClass and DataSkills tabs. Fixed it! The Pathfinder Chronicler also grants this ability...I use the following formula to do this, in the Untrained column on the DataSkills tab:
=IF(OR(AND(Lvl_Brd>0,Alt_Class_Features_Brd="No"),Lvl_PathChro>0),1,0 )
2) I added a light crossbow and it seems to be adding my Str bonus when I hold it one handed and 1.5 Str bonus when I hold it two handed. But crossbow shouldn't get Str bonuses. Right now they're working like melee weapons.2.5) I added a longbow just to see what happens, and it did the same thing. I don't know bows as well, but I think that's only supposed to happen if you get a strength bow.
Do you have the Weapon set to Ranged rather than Melee (there's a little selector right above the weapon name field)? Both crossbows and bows should be set to Ranged, while spears, slings, bolas, etc. should be set to Thrown. I'm working on a more elegant solution for that, but this sounds like the problem. Composite bows will indeed at a Str bonus to damage.
Oh, and I tried Sorting just the skill name column (and not the modifiers and everything) and it seems to be working fine; all the modifiers auto fill based on the skill name.
I look forward to playing with the new version! Thanks
Thanks, and I look forward to more feedback!
Great work! One comment: On my druid, sheet was not auto-calculating nature sense (+2 knowledge nature and survival) on skills section or allowing me to list Druidic as a free language. Also can't select or fill in manually armor (weird!) on Excel program.
Great work! One comment: On my druid, sheet was not auto-calculating nature sense (+2 knowledge nature and survival) on skills section or allowing me to list Druidic as a free language.
Fixed and fixed. Thanks!
Also can't select or fill in manually armor (weird!) on Excel program.
This is the "locked cell" issue I mentioned above--basically sometimes in my work I rebuild merged cells. If, in the process, I incorporate a cell that was previously locked, then the entire merged cell becomes locked. I understand why excel makes this decision, but it sure is annoying...Fixed!
As I'm on a laptop I don't normally use, I uploaded the fixes as a new v.0.7.12--anyone that's downloaded so far can snag a new copy to pick up these bug fixes immediately. Yes, I know, bad version control on my part...it's late and I need more sleep!
Request:
When I build a fighter/wizard, I get both the Simple Weapon Proficiency and the Wizard List showing up under Feats. It also doesn't show "All Martial Weapons" as a proficiency.
Would it be possible to A) clone the bit that says "Simple Weapon proficiency" and B) make it show "Martial Weapon Proficiency", and if either of those shows up, have them override the weird class-based proficiency lists if both are present.
It's kind of disconcerting to see my fighter/mage turn up with a meagre handful of weapon proficiencies on the back of the sheet.
Request:
When I build a fighter/wizard, I get both the Simple Weapon Proficiency and the Wizard List showing up under Feats. It also doesn't show "All Martial Weapons" as a proficiency.
Would it be possible to A) clone the bit that says "Simple Weapon proficiency" and B) make it show "Martial Weapon Proficiency", and if either of those shows up, have them override the weird class-based proficiency lists if both are present.
It's kind of disconcerting to see my fighter/mage turn up with a meagre handful of weapon proficiencies on the back of the sheet.
Yeah, displaying that info has been a handle. I'll work on some better logic, perhaps building a block similar to what's at the start of each class ability description in the books...
Yeah, displaying that info has been a handle. I'll work on some better logic, perhaps building a block similar to what's at the start of each class ability description in the books...Request:
When I build a fighter/wizard, I get both the Simple Weapon Proficiency and the Wizard List showing up under Feats. It also doesn't show "All Martial Weapons" as a proficiency.
Would it be possible to A) clone the bit that says "Simple Weapon proficiency" and B) make it show "Martial Weapon Proficiency", and if either of those shows up, have them override the weird class-based proficiency lists if both are present.
It's kind of disconcerting to see my fighter/mage turn up with a meagre handful of weapon proficiencies on the back of the sheet.
The long bow, shortbow, and favored weapon proficiency is not working for the Inquisitor. I know it is beta. I tried to adjust the field but I am not that good with excel to fix the right field. Plus it should have hand crossbow added.
While I am at it need a spot to select the domain for the Inquisitor. That could be what is throwing off the "Other" weapon proficiency.
The "Is this a class skill" check in the Data Classes tab (cell BV28 through BV66, and the column next to it - BW) has a formula that just pulls the contents of something from the Customization page.
That formula returns a 0 if the Customization page cell is blank, and apparently you're using "blank" as a trigger for "not used".
I see two fixes - one relatively simple, one that may make more sense long term.
Simple one: Replace the formula in BV26 with =IF(Customization!E15="","",0), which will get the blank cells that you need for the class skills to show up.
Longer term:
Switch the nomenclature on this tab to 0 for not a class skill and 1 for a class skill (or 3 for a class skill and do double duty) and revamp everything that's dependent on it.
This will reduce the number of extraneous IF statements needed and, long term, make this entire tab easier to maintain.
Also, this tab needs more rows for additional classes and a better way to enter more classes in without the sheet maintainer plucking his eyes out with a fork. :)
Thanks for the prompt response!! Question: how to input custom light armor (hide shirt from RotRL)? Do not see armor under customization tab. Later!
|
|
Do you have the Weapon set to Ranged rather than Melee (there's a little selector right above the weapon name field)? Both crossbows and bows should be set to Ranged, while spears, slings, bolas, etc. should be set to Thrown. I'm working on a more elegant solution for that, but this sounds like the problem.
Yup, that was it. I guess ideally it would do that automatically, but it's also nice to be able to select melee vs. thrown for some weapons. Actually, being able to create multiple stat blocks for the same weapon used in different ways is one of the chief advantages of your spreadsheet vs. the program I've used in the past - that and all the Golarion-specific data.
Hey guys, I got some good work in today fixing the various items noted above (see specifics after this blurb) and also automating the 3PP feats. I'm almost through the Alluria Publishing Remarkable Races and will be starting on the LSJ items next. Jay, have y'all had any decision on how to handle the LSJ feats that are now duplicates of the core feats? My assumption is to remove them and use core. If they are to remain, I'll have to rename them so the VLOOKUP functions work properly.
Once I've got all the 3PP feats automated, I'm going to hit the bloodlines and domains. That should get all the existing material fully automated so I can move on to new things like the APG and LSJ classes.
The long bow, shortbow, and favored weapon proficiency is not working for the Inquisitor. I know it is beta. I tried to adjust the field but I am not that good with excel to fix the right field. Plus it should have hand crossbow added.
While I am at it need a spot to select the domain for the Inquisitor. That could be what is throwing off the "Other" weapon proficiency.
Okay, I put some thought into this whole display issue and have come up with, I think, a good solution. I rebuilt the formulas that look for weapon/armor proficiency to account for either class-granted proficiency or having taken a feat. I then moved all of the class-granted proficiencies to only display in the appropriate boxes on the Back tab. End result for the Abilities and Feats tab is it will only show armor/weapon proficiencies when you actually take a feat to gain such. The specific class lists for various classes like the bard, wizrd, monk (and inquisitor, which I've fixed) have been fixed so that they only show weapons not already covered by full class proficiency. This should greatly reduce the weapons displayed in the Other Weapons list with multi-class options like fighter/wizard and fighter/rogue.
The "Is this a class skill" check in the Data Classes tab (cell BV28 through BV66, and the column next to it - BW) has a formula that just pulls the contents of something from the Customization page.
That formula returns a 0 if the Customization page cell is blank, and apparently you're using "blank" as a trigger for "not used".
I see two fixes - one relatively simple, one that may make more sense long term.
Simple one: Replace the formula in BV26 with =IF(Customization!E15="","",0), which will get the blank cells that you need for the class skills to show up.
Longer term:
Switch the nomenclature on this tab to 0 for not a class skill and 1 for a class skill (or 3 for a class skill and do double duty) and revamp everything that's dependent on it.
This will reduce the number of extraneous IF statements needed and, long term, make this entire tab easier to maintain.
Also, this tab needs more rows for additional classes and a better way to enter more classes in without the sheet maintainer plucking his eyes out with a fork. :)
I've been working on that tab, actually, with the Other Weapons clean-up noted above. In the process, I streamlined how the class skill calculations work, so a NULL or 0 value will work. I've also formatted that tab in preparation for adding new stuff (not sure if y'all saw my post in the 3PP boards--I've got lots of new PDFs to play with...). Let me know what you think with the next release. Definitely alway slooking for better ways to do things!
Thanks for the prompt response!! Question: how to input custom light armor (hide shirt from RotRL)? Do not see armor under customization tab. Later!
Huh, I just missed that entirely. You can, of course, go to the DataEquipment table and add it directly,but I'll also add in a place on the Customization tab. However, my eventual goal is actually to include all Golarion/Pathfinder armor in the list. As such, I'll stick the hide shirt in as a standard item in the sheet.
Yup, that was it. I guess ideally it would do that automatically, but it's also nice to be able to select melee vs. thrown for some weapons. Actually, being able to create multiple stat blocks for the same weapon used in different ways is one of the chief advantages of your spreadsheet vs. the program I've used in the past - that and all the Golarion-specific data.
Yes, being able to set multiple "switches" on a weapon to get it to do different things is one of my required features--I use it in-game to change out how the weapons are working. Now, to improve on this without removing the functionality, I've expanded the scripting a bit so it will now tell you if you are trying to wield a Ranged weapon as Melee, etc. This will be great for me, actually, as I'm always forgetting to flip that particular switch...