|
Yes, I did select an arcane school and the opposition schools.Hmm, that's the only thing for wizards that I know of that can cause an N/A in the display. Can you try this for me--on a fresh copy of v.0.7.12, set the Race to Elf, Class to Wizard, and then set the schools. After doing just those three, the Class Abilities displays properly for me. Does this work for you?
Hi, I did as you asked and this time it worked. Don't know what the difference is but I am good now. Thanks.
New Challenge.
How do I adjust the DC's for my spells. It is not automatically adjusting them and in the lastest sheet I cannot enter the box to adjust them manually as I could in past sheets. I know there is a trick here someplace.
Thanks
For now, you can simply unprotect the sheet (Review-->Unprotect Sheet in Excel 2007). The DC cell at present calculates solely from the level and related ability score and I lock calculated cells be default so folks don't accidentally modify/delete something unintentionally. I could add a field for customization, however, if that would be helpful.
For the conditions, a check box scenario is possible versus the drop-downs. Right now, I've gone with the drop-down interface because it allows me to pull list data from another tab for lookups and it's also easier to handle reformatting/rebuilding the character sheet. Going with check boxes would move this information off the Front tab, as I'd need a large area to display all the options. I see the benefits in this, but is it worth moving the functionality off the main tab? I'm definitely open for discussion on this.
Drop-down sounds fine to me, I can see your point about fitting on the Front tab. The issue to me is immediacy and usability. The TOS+ laptop tab is robust, allows the use of feats and such, but IMO you have to wade through a lot of extraneous choices to get to what you want. Customization would take care of much of that, I assume.
Zo
Is anyone else having a problem with the Traits not being listed properly in the Abilities & Feats tab when using Open Office (v.3.2.0)? It just say #N/A or something like that. However, when using Microsoft Excel 2004 for Mac (v.11.4.1), the trait is listed fine.
Yep, this is an issue that was reported fr v.0.7.12. Basically, the text I added to explain that some contingent trait features can't be automated breaks the trait display. If you select a trait in all four areas it will display properly. Will be fixed in my next release
Drop-down sounds fine to me, I can see your point about fitting on the Front tab. The issue to me is immediacy and usability. The TOS+ laptop tab is robust, allows the use of feats and such, but IMO you have to wade through a lot of extraneous choices to get to what you want. Customization would take care of much of that, I assume.
Zo
I'm working out a format in my head that would basically shift the Front and Back tabs to be in landscape format rather than portrait. The primary purpose is to display better for computer-based use, but I want to preserve a portrait format for those that prefer such. Any thoughts from folks on this? If I go this route, should the landscape or portrait view be the default (i.e. where you enter all the data and it flows over to the other view)?
If you can implement buff/debuff effects in a check box fashion similar to Heroforge, that'd be icing on the cake as far as I'm concerned. I use your sheet for PC records as a DM, but as a player I use TOS+ for my character's buffs/effects. It's decent but I'd personally rather have a Heroforge-style check box sheet just for ongoing effects. I found it more immediate, less complicated.
Thanks again,
ZoPS: My bad for overlooking the +3 enhancement on the shield section.
No problem on the shield--it took me a while to find it myself!
For the conditions, a check box scenario is possible versus the drop-downs. Right now, I've gone with the drop-down interface because it allows me to pull list data from another tab for lookups and it's also easier to handle reformatting/rebuilding the character sheet. Going with check boxes would move this information off the Front tab, as I'd need a large area to display all the options. I see the benefits in this, but is it worth moving the functionality off the main tab? I'm definitely open for discussion on this.
Erian, if you can find a way to do check boxes that does NOT require VBA to handle the form inputs, I would be very interested in learning the trick. I don't know that it can be done - I've been looking for that trick for over two years now, and I think one of the strengths of this sheet is that it's macro free and cross platform compatible because of it.
I'm working out a format in my head that would basically shift the Front and Back tabs to be in landscape format rather than portrait. The primary purpose is to display better for computer-based use, but I want to preserve a portrait format for those that prefer such. Any thoughts from folks on this? If I go this route, should the landscape or portrait view be the default (i.e. where you enter all the data and it flows over to the other view)?
My suggestion is to rename the current Front and Back tabs PrintFront and PrintBack, and put in two new tabs for LandscapeFront and Landscape back.
EG, it should not REPLACE the existing ones, but should give another display option pulling from the same data sources.
I'd rather do the data entry in the landscape tabs. (Even better if the landscape tabs can be printer friendly. I much prefer landscape sheets at the gaming table because they interfere less with the miniatures map.)
I'm working out a format in my head that would basically shift the Front and Back tabs to be in landscape format rather than portrait. The primary purpose is to display better for computer-based use, but I want to preserve a portrait format for those that prefer such. Any thoughts from folks on this? If I go this route, should the landscape or portrait view be the default (i.e. where you enter all the data and it flows over to the other view)?
I can only speak on the other two mature excel based sheets I've used: TOS+ and Heroforge (now obsolete). Heroforge has a portrait view and TOS+ has a landscape view using a portrait view printable area for turning out hard copy. Both work well as far as I'm concerned.
The advantage of using a laptop based sheet at the table is that it reduces the hassle of tracking stats in combat (primarily). To that end the UI should be as streamlined as possible, something I think Heroforge accomplished by having the names of buffs/debuffs laid out logically, by level (though alphabetically would work as well) and requiring at most a click and/or a simple data entry.
As a laptop user, I would like to see two things in your implementation: a consistent UI and as simple a buff/debuff/feat/whatever system as possible while maintaining completeness and future expandability. When it comes to printing, I personally like a "pretty" yet orthodox (portrait) sheet. What you've got going on now is superlative as far as I'm concerned.
Zo
|
How-to Question:
I'm trying to create a Spell-less Ranger from Kobold Quarterly #11. It has a few more class abilities in exchange for no spells. So to do it I inserted a row on the Class Abilities tab between two other Ranger class abilities of the appropriate level. I named the ability in cell A138, used the same Qualify and Taken formulas in B138 and C138, left D138 blank, and wrote what seems to be an appropriate description in E138. So far so good (neither ability requires a formula or calculations). I also copied the formula in F138 [=IF(C143,"- "&A143&": "&E143,"")]. The problem is they aren't showing up once I qualify for them on the abilities list on the Abilities & Feats tab.
Is there any easy way you can explain what I need to do to get them to show up?
|
|
Okay, so I kept fiddlin' with it this morning and got them to show up.
Before, I had done Add Row between row 137 and 138. Whatever formula controls the Class_Ability_Summary list didn't seem to like that. This time, I tried adding the new abilities I needed by overwriting level 20 Ranger abilities I wasn't going to need (I'm multi-classing - although, come to think of it, for a Spell-less Ranger, I could overwrite the 5 Ranger Spells lines...). That worked and the abilities now show up on the Abilities & Feats tab.
BTW- I also tried overwriting some Paladin abilities ('cause I won't need those), but my new Ranger abilities showed up as Paladin abilities, even when I moved the Class_Ability_Summary_Rgr tag in column G up; that tag's location seems to be hard coded into a formula somewhere.
So I guess I have it figured out well enough at this point. My only question, I guess, would be if there is an easier way to add abilities to existing classes (for variant classes and such)?
Sheet DataSkills cell G29. Are you adding Bardic Knowledge to Linguistics?
Also, you are not adding Bard's Jack-of-All-Trades to the Untrained Column (at 5th level the bard can use any skill, even untrained); and to the class skills (at 16th level all skills are treated as class skills)-> DataClasses Sheet?.
Greetings to all, and many thanks to erian7 for putting this marvelous tool together. I have a slight problem, I don't know if anyone else has already brought this up (my old eyes aren't quite as sharp as they used to be), but in the 7.12 release... all right let me try this way. I have a halfling rogue that I'd put together using 7.10. Among his equipment, recently acquired, he now has a +1 Rapier (and that still goes in as normal, never fear there) that's Giantbane. Now, in 7.10, I was able to put that note into the Special Properties line on the weapon. In 7.12, however, that field is blocked/protected. Is that a minor glitch or did I forget something? I am using 7.12 and Open Office 3.2, if that makes any difference.
|
|
Not sure if it's been mentioned (only checked last couple of pages) but the Oracle listing in the DataClasses tab for version 7.12 is really messed up. It's referencing the wrong lines when it comes to itself and checking for class skills.
Example: Cell AE44 reads: =IF(ISNUMBER(FIND($B$42,Class)),1,0)
Should read: =IF(ISNUMBER(FIND($B$44,Class)),1,0).
Example: Cell AA44 reads: =IF(AND(Lvl_Ora>0,ISNUMBER(FIND(AA28,Oracle_Class_Skills))),1,0)
Should read: =IF(AND(Lvl_Ora>0,ISNUMBER(FIND(AA27,Oracle_Class_Skills))),1,0)
Not sure if all of the skill checks are in the right place either - I don't think they are.
Looks like the Cavalier has the same issue.
Also check the Class total cell of T29 - it doesn't have some in there - such as the Oracle.
* Flurry of Blows is not yielding the correct number of attacks; I would expect an 11th level monk with a flurry selection to show as for instance "+13/+13/+8/+8/+3" (at which point it might make sense to have a function strip the plusses when the length is getting out of hand, to fit better? I'd precalc the long text to a different cell and string replace plusses with nothing, if excel can do that.) I'm not sure what's supposed to go in 'wielded as?' for that, but none of them worked. EDIT: Actually after pasting in 7 attacks just to see how small the text would be, I wouldn't worry about trying to shrink it, given how much room there currently is for that field.Flurry of Blows works functionally the same as 2-weapon fighting, so you should designate one attack as 2-Wpn Primary and another as 2-Wpn Off-Hand. I have it this way on purpose, both to mirror the TWF functions and also to allow for mixing in, say, a sai or quarterstaff with unarmed strikes. Now, I did need to tweak the sheet a bit to display the flurry with the "off-hand" properly and also not decrease the damage. Also, I've interpreted the Monk BAB a little differently in that it affects the attack roll but doesn't grant another iterative attack. I'll have to think about that one...
Any update on this (my emphasis in bold), bro? This is from early December.
Customization tab, under the custom weapon section: The Data Validation in the Critical Threat cell (Cell P42) only lets you enter a single number. You can't enter a range (19-20 or 18-20, for example). I can force this by going to the DataEquipment tab, but that sort of defeats the purpose of the Customization tab.
Hey guys. Ran into a batch of strep throat in our household, so I've been side-tracked for the past week. I'm starting to look at all the items reported above right now...
|
|
Hey guys. Ran into a batch of strep throat in our household, so I've been side-tracked for the past week. I'm starting to look at all the items reported above right now...
Any way we can donate to the cause? I tried this out over the weekend and found it to be AWESOME! Workes twenty times better than anything else I have tried, including Heroforge and PCGen.
|
Is there any to way quickly add the Swashbuckler from the Tome of Secrets? I had been playing a Swahbuckler in a 3.5 campaign and the DM wants to convert it to Pathfinder this weekend. Since no shee except TOS+ has it and I'm not wantting to subscribe to that sheet at this time, is there anyway it can be added to an Excel sheet quickly. I can supply the info for the Swashbucker if needed.
Thanks
Well, medical issues are sure sidelining my work on this--for any new folks, please note that I'm generally very responsive and committed to getting out about one release per week!
So, I ended up having minor surgery today. Nothing major, it was outpatient, and I should be good to go in a few days. I think it may actually be beneficial in that the doc has said I need to take it easy for a while, i.e. can't pick up the baby and must sit/lay around. That will hopefully give me some time to focus on this project!
To keep all you folks waiting on bug fixes from having to wait any longer, here's PRPG_CS_v_0_7_13.zip!
Hi,
I selected Augment Summoning as my 3rd level feat as a Wizard, but the cell is red.
I selected Spell Focus (conjuration) as my PFS bonus feat.
I noticed that Augment Summoning is still FALSE under Qualified on the Feats sheet.
Thanks!
Fixed it! The formula has "Spell Focus (conjuration)" instead of "Spell Focus [Conjuration]" to match the actual feat name.
Erian, if you can find a way to do check boxes that does NOT require VBA to handle the form inputs, I would be very interested in learning the trick. I don't know that it can be done - I've been looking for that trick for over two years now, and I think one of the strengths of this sheet is that it's macro free and cross platform compatible because of it.
Heh, my solution is actually is that the "check box" would be a data validation drop down in a cell next to the item being selected. So, it would function similar to the VBA, but not be as pretty...The greater concern I have is the amount of real-estate such a solution will require in order to list all the conditions and effects (see below).
My suggestion is to rename the current Front and Back tabs PrintFront and PrintBack, and put in two new tabs for LandscapeFront and Landscape back.
EG, it should not REPLACE the existing ones, but should give another display option pulling from the same data sources.
I'd rather do the data entry in the landscape tabs. (Even better if the landscape tabs can be printer friendly. I much prefer landscape sheets at the gaming table because they interfere less with the miniatures map.)
That's pretty much what I was thinking--I definitely don't want to lose the portrait format. For a release in the near future, I'll probably do two versions, one using a portrait input screen and one using landscape. Then folks can try them out and give feedback on the best one. Given the proportions of a typical monitor, I'm pretty sure landscape will win out.
I can only speak on the other two mature excel based sheets I've used: TOS+ and Heroforge (now obsolete). Heroforge has a portrait view and TOS+ has a landscape view using a portrait view printable area for turning out hard copy. Both work well as far as I'm concerned.
The advantage of using a laptop based sheet at the table is that it reduces the hassle of tracking stats in combat (primarily). To that end the UI should be as streamlined as possible, something I think Heroforge accomplished by having the names of buffs/debuffs laid out logically, by level (though alphabetically would work as well) and requiring at most a click and/or a simple data entry.
As a laptop user, I would like to see two things in your implementation: a consistent UI and as simple a buff/debuff/feat/whatever system as possible while maintaining completeness and future expandability. When it comes to printing, I personally like a "pretty" yet orthodox (portrait) sheet. What you've got going on now is superlative as far as I'm concerned.
Zo
Very good thoughts that I'll keep in mind through the redesign for a landscape view. Getting to that perfect UI for tabletop use is definitely a goal, so I look forward to continued feedback on any shifts I come up with for the future!
How-to Question:
I'm trying to create a Spell-less Ranger from Kobold Quarterly #11. It has a few more class abilities in exchange for no spells. So to do it I inserted a row on the Class Abilities tab between two other Ranger class abilities of the appropriate level. I named the ability in cell A138, used the same Qualify and Taken formulas in B138 and C138, left D138 blank, and wrote what seems to be an appropriate description in E138. So far so good (neither ability requires a formula or calculations). I also copied the formula in F138 [=IF(C143,"- "&A143&": "&E143,"")]. The problem is they aren't showing up once I qualify for them on the abilities list on the Abilities & Feats tab.
Is there any easy way you can explain what I need to do to get them to show up?
Okay, so I kept fiddlin' with it this morning and got them to show up.
Before, I had done Add Row between row 137 and 138. Whatever formula controls the Class_Ability_Summary list didn't seem to like that. This time, I tried adding the new abilities I needed by overwriting level 20 Ranger abilities I wasn't going to need (I'm multi-classing - although, come to think of it, for a Spell-less Ranger, I could overwrite the 5 Ranger Spells lines...). That worked and the abilities now show up on the Abilities & Feats tab.
BTW- I also tried overwriting some Paladin abilities ('cause I won't need those), but my new Ranger abilities showed up as Paladin abilities, even when I moved the Class_Ability_Summary_Rgr tag in column G up; that tag's location seems to be hard coded into a formula somewhere.
So I guess I have it figured out well enough at this point. My only question, I guess, would be if there is an easier way to add abilities to existing classes (for variant classes and such)?
The short answer is that character classes are the single most complex aspect of the sheet--I am shooting for an easier process but staying macro/VBA free means I can't rely on some of the fancier processes to gather up and display data.
What you've basically got is a series of concatenated fields in the various Class_Ability_Summary_CLASSNAME fields. This named field looks at each cell for data (the individual class abilities having already been formatted and displayed based on line-by-line formulas) and displays what's there. All of these roll up to the Class_Ability_Summary field, which then displays over on the Abilities and Feats tab. To change an existing line, you simply do as you did and the summary rolls up. To add a new class ability line item, be sure to (1) put the proper formula in column F of the line item to display it individually (can likely cut-and-paste from another line item for this) and (2) add the new line item's display cell as a concatenation to the appropriate Class_Ability_Summary_CLASSNAME field.
I am definitely open to any ideas for improving this process!
I would prefer the default view being portrait.
Definitely noted. When I get the landscape version out, do some fiddling and see if it works out any better. Do you use the sheet actively during a game, or just create a character to print?
Sheet DataSkills cell G29. Are you adding Bardic Knowledge to Linguistics?
Not that I can tell. Are you seeing an anomaly? The only class adding to linguistics is the Pathfinder Chronicler level.
Also, you are not adding Bard's Jack-of-All-Trades to the Untrained Column (at 5th level the bard can use any skill, even untrained); and to the class skills (at 16th level all skills are treated as class skills)-> DataClasses Sheet?.
Ah, good catch. I've corrected both of these.
Greetings to all, and many thanks to erian7 for putting this marvelous tool together. I have a slight problem, I don't know if anyone else has already brought this up (my old eyes aren't quite as sharp as they used to be), but in the 7.12 release... all right let me try this way. I have a halfling rogue that I'd put together using 7.10. Among his equipment, recently acquired, he now has a +1 Rapier (and that still goes in as normal, never fear there) that's Giantbane. Now, in 7.10, I was able to put that note into the Special Properties line on the weapon. In 7.12, however, that field is blocked/protected. Is that a minor glitch or did I forget something? I am using 7.12 and Open Office 3.2, if that makes any difference.
Thanks! I enjoying doing a bit to give the RPG community and 3PP folks some free support...
v.0.7.12 has the cells protected as I'd normally do for a release, so folks won't inadvertently overwrite formulas. You can unprotect the sheet and replace the formula with custom entries. Alternately, you can create a custom weapon and put the notes in the Special field. These flow directly to the Special Properties entries for the weapons, so they would show up no matter where you put the weapon (nice for having multiple iterations of the same weapon displayed).
Not sure if it's been mentioned (only checked last couple of pages) but the Oracle listing in the DataClasses tab for version 7.12 is really messed up. It's referencing the wrong lines when it comes to itself and checking for class skills.
Example: Cell AE44 reads: =IF(ISNUMBER(FIND($B$42,Class)),1,0)
Should read: =IF(ISNUMBER(FIND($B$44,Class)),1,0).Example: Cell AA44 reads: =IF(AND(Lvl_Ora>0,ISNUMBER(FIND(AA28,Oracle_Class_Skills))),1,0)
Should read: =IF(AND(Lvl_Ora>0,ISNUMBER(FIND(AA27,Oracle_Class_Skills))),1,0)Not sure if all of the skill checks are in the right place either - I don't think they are.
Looks like the Cavalier has the same issue.
Also check the Class total cell of T29 - it doesn't have some in there - such as the Oracle.
Thanks all around! The APG classes definitely need some attention. I've corrected these issues, and am looking to complete all the APG classes with my next release.
Any update on this (my emphasis in bold), bro? This is from early December.
Ah yes, forgot to get back on this. I was looking at the Sajan pre-gen from Second Darkness at the time and apparently hadn't noticed it seems inconsistent with the class description.
As the iconic obviously is not the rules, I'm looking to rebuild this. However, it'll take a bit for me to figure out the best way to work it into the formula...
Customization tab, under the custom weapon section: The Data Validation in the Critical Threat cell (Cell P42) only lets you enter a single number. You can't enter a range (19-20 or 18-20, for example). I can force this by going to the DataEquipment tab, but that sort of defeats the purpose of the Customization tab.
Looks like I copied a data validation over from another field. Corrected!
Any way we can donate to the cause? I tried this out over the weekend and found it to be AWESOME! Workes twenty times better than anything else I have tried, including Heroforge and PCGen.
Why thanks! It gets better and better with each person that comes in and brings ideas, so join the fun! What I really need is data entry--I've now got a ton of 3PP material I want to get entered, and of course, I want to stay on top of bug fixes and support for core/Paizo material...
Is there any to way quickly add the Swashbuckler from the Tome of Secrets? I had been playing a Swahbuckler in a 3.5 campaign and the DM wants to convert it to Pathfinder this weekend. Since no shee except TOS+ has it and I'm not wantting to subscribe to that sheet at this time, is there anyway it can be added to an Excel sheet quickly. I can supply the info for the Swashbucker if needed.
Thanks
You can add a class fairly quickly on the Customization tab. The tricky bit is class ability automation, but if you add the abilities in directly without worrying about formulas that shouldn't be a problem. I did acquire the Tome of Secrets recently along with the other 3PP mentioned above and will be adding all OGC material from it to the sheet once I get the time...
|
In the new 0.7.13 version, on the Front tab, when I put in Ranged, Net, and 1-Handed for the first weapon, in the Total Attack Bonus box, it just lists some gibberish formula instead of an actual value. I tried it again using Melee, Guisarme, 2-handed and got the same thing. Interestingly, when I do the same thing on the next weapon, it lists the Total Attack Bonus correctly. Which makes me wonder if it's something weird about that first weapon slot? For what it's worth, I'm using Open Office Calc 3.2.0.
I want to search for "Custom Race" on this message board but I don't see any search functions, where do you keep the examples for "Custom Race", "Custom Class", etc..
I'm not sure exactly what you mean? On these forums, you won't find anything particular to the Custom options in my sheet outside of this particular thread. Are you just looking to read past conversations in this thread about this topic? You'll probably be better off just asking any questions you might have about the fields, since past conversations may not even be relevant any more given the evolution of that tab.
In the new 0.7.13 version, on the Front tab, when I put in Ranged, Net, and 1-Handed for the first weapon, in the Total Attack Bonus box, it just lists some gibberish formula instead of an actual value. I tried it again using Melee, Guisarme, 2-handed and got the same thing. Interestingly, when I do the same thing on the next weapon, it lists the Total Attack Bonus correctly. Which makes me wonder if it's something weird about that first weapon slot? For what it's worth, I'm using Open Office Calc 3.2.0.
Yeah, I was fiddling around with the formula in cell AC78 (it's overly complicated and needs a severe make-over in order to facilitate future changes. I got into it as I was messing with the Melee/Thrown/Ranged switch trying to work out the display.
You can copy cell AC89 up to it, then change any reference from Weapon2 to Weapon1 and it'll work.
angelroble wrote:
Sheet DataSkills cell G29. Are you adding Bardic Knowledge to Linguistics?Not that I can tell. Are you seeing an anomaly? The only class adding to linguistics is the Pathfinder Chronicler level.
Maybe I copied the formula from the cell above. Anyway, it is right in the last version.
Just one little thing on bonus to knowledges: I think Bard and Pathfinder Chronicle classes should be added before being divided by 2, instead of adding the bonuses. Thus, a level 9th lvl bard / 3rd lvl Path grants a bonus of 12/2 = +6, instead +4+1 = +5.Loremaster class, on the contrary, add the bonus.
angelroble wrote:
Sheet DataSkills cell G29. Are you adding Bardic Knowledge to Linguistics?Not that I can tell. Are you seeing an anomaly? The only class adding to linguistics is the Pathfinder Chronicler level.
Maybe I copied the formula from the cell above. Anyway, it is right in the last version.
Just one little thing on bonus to knowledges: I think Bard and Pathfinder Chronicle classes should be added before being divided by 2, instead of adding the bonuses. Thus, a level 9th lvl bard / 3rd lvl Path grants a bonus of 12/2 = +6, instead +4+1 = +5.
Loremaster class, on the contrary, add the bonus.
Agreed on adding the levels before dividing. I've updated (and simplified) the formula.
Greetinks. Found another oddity here. Playing with the rogue halfling again, who carries around a sling. Nothing fancy about it, just your ordinary everyday bullet-throwing sling. I set it in the second weapon slot, set it to "Ranged", set "Wielded as?" to "1-Handed" and it gives me a Total Attack Bonus as "Set to Thrown". What gives here now? Thing is when I do set the weapon to Thrown, it gives me the correct TAB. Is a sling considered a thrown weapon, am I missing something here? I guess it might be as I'm "throwing" a sling bullet? Is that it and I'm too daft to realize I just answered my own question?
(Edit: D'oh just looked. It's a Thrown group weapon, ai yah... yep, I was daft.)
Oh, just to be sure, when you suggested copying AC89 to AC78 to fix the TAB there, changing the Weapon2 to Weapon1 notifications in the formula, I assume you meant to change all of the cell references by reducing them by 11? That's what I did and it worked. (Sorry, don't quite grok Excel programming maybe as well as I ought).
Lastly, and this may be a special case. The halfling got a set of "leafweave" studded leather armor during the campaign he's in currently. From what I was told by my GM, leaveweave adds a +1 enhancement bonus to the standard armor bonus (making it a +4 rather than studded leather's +3), increases the Max Dex by one (making the Max Dex a +6), and grants an SR of 13. Is there any way to add a special material tab outside of the four you already have listed or do I need to add that armor in manually altogether?
Greetinks. Found another oddity here. Playing with the rogue halfling again, who carries around a sling. Nothing fancy about it, just your ordinary everyday bullet-throwing sling. I set it in the second weapon slot, set it to "Ranged", set "Wielded as?" to "1-Handed" and it gives me a Total Attack Bonus as "Set to Thrown". What gives here now? Thing is when I do set the weapon to Thrown, it gives me the correct TAB. Is a sling considered a thrown weapon, am I missing something here? I guess it might be as I'm "throwing" a sling bullet? Is that it and I'm too daft to realize I just answered my own question?
(Edit: D'oh just looked. It's a Thrown group weapon, ai yah... yep, I was daft.)
For the game mechanical reasoning, slings add the Str mod to damage just like throwing a spear and unlike other purely ranged weapons (excepting composite bows).
Oh, just to be sure, when you suggested copying AC89 to AC78 to fix the TAB there, changing the Weapon2 to Weapon1 notifications in the formula, I assume you meant to change all of the cell references by reducing them by 11? That's what I did and it worked. (Sorry, don't quite grok Excel programming maybe as well as I ought).
Hmm, not quite. The formula has three occurrences of the field name WeaponX_Combat_Options. You want to put a number in place of the X to match the weapon block in use (they are numbered 1-5 from the top down).
Lastly, and this may be a special case. The halfling got a set of "leafweave" studded leather armor during the campaign he's in currently. From what I was told by my GM, leaveweave adds a +1 enhancement bonus to the standard armor bonus (making it a +4 rather than studded leather's +3), increases the Max Dex by one (making the Max Dex a +6), and grants an SR of 13. Is there any way to add a special material tab outside of the four you already have listed or do I need to add that armor in manually altogether?
I am looking at expanding the special materials to include other OGC options. The quickest way for now, however, is indeed to add it in manually. As I still haven't put in the Custom Armor fields on the Customization tab (note to self to fix that...) you can go to the DataEquipment tab, copy the line for studded leather (row 236), paste it in the *** Custom *** area, then tweak the the appropriate fields.
Erian_7: I'm creating a Google site for my current PF campaign. Would you mind if I linked to your sheet, and do you have a persistent URL for the newest (released) version?
Zo
For the game mechanical reasoning, slings add the Str mod to damage just like throwing a spear and unlike other purely ranged weapons (excepting composite bows).
Yeah, and it even says that in the base book. As I say, daft I was.
Hmm, not quite. The formula has three occurrences of the field name WeaponX_Combat_Options. You want to put a number in place of the X to match the weapon block in use (they are numbered 1-5 from the top down).
I found the instances then and changed them accordingly, but am I wrong in thinking that the cell references needed to be tweaked as well? I'm thinking the cell refs, if left alone, would be referring to the second weapon on the list when they're supposed to be looking for the first?
I am looking at expanding the special materials to include other OGC options. The quickest way for now, however, is indeed to add it in manually. As I still haven't put in the Custom Armor fields on the Customization tab (note to self to fix that...) you can go to the DataEquipment tab, copy the line for studded leather (row 236), paste it in the *** Custom *** area, then tweak the the appropriate fields.
Ah yes of course, silly of me. But while I'm thinking about it, would it then be possible to add an additional row to the custom weapons section without screwing up the other pages? I only ask because there may come a time when a person is carrying more than one specialized shiny pokey bit.
Erian_7: I'm creating a Google site for my current PF campaign. Would you mind if I linked to your sheet, and do you have a persistent URL for the newest (released) version?
Zo
Best thing is to point folks at the link for my profile (http://paizo.com/people/erian7) or at the Pathfinder Database Character Sheets for the last "official" release (http://www.pathfinderdb.com/character-sheets)
I found the instances then and changed them accordingly, but am I wrong in thinking that the cell references needed to be tweaked as well? I'm thinking the cell refs, if left alone, would be referring to the second weapon on the list when they're supposed to be looking for the first?
That will depend on how you copied the formula. I select the cell, then copy-and-paste. Excel auto-changes all the cell references to correct for a change in row and column position. So, the only thing I have to change after that is the hard-coded bits (one reason I try to avoid hard-coding when feasible). If, however, you go into the cell itself, select the text of the formula, then copy-and-paste that, Excel will not change the cell references and you would indeed have to manually adjust the bits.
Ah yes of course, silly of me. But while I'm thinking about it, would it then be possible to add an additional row to the custom weapons section without screwing up the other pages? I only ask because there may come a time when a person is carrying more than one specialized shiny pokey bit.
I can indeed. My primary concern with adding too many Custom Weapons on the Customization tab is that each new row adds a blank at the top of the weapon selector when no custom weapon is present (I put it at the top with the assumption that if you've got a custom weapon you'd want to select it first). Now, there are multiple rows of custom weapon options in the Table_Weapons array, in each section of weapon types (Simple, Martial, Exotic) and I've been working from the assumption that a user needing multiple weapons would place them there versus on the Customization tab.
That's pretty dang nifty! I've been fiddling around with another method AdAstra pointed me toward, but the implementation has been something I haven't quite wrapped my brain around. I just tried your method out with the general weapon and armor drop-downs, and I can definitely move to this method until I work through fully implementing that Dependent List structure.
Thanks!
Well, there's definitely some crazy stuff in that other method, and it's arguably a better approach to the last step in my method, but I think what it comes down to is that he and I were addressing somewhat different problems. I was more concerned with filtering out items from lists than setting them to the right length; the last part was just a bit of cleanup to make the list easier to scroll through.
Dynamically defined names... this has potential.
Using both methods, we can do things like:
Feat Type: Combat
Feat: <list of available combat feats in drop-down>The only difficulty with merging the two techniques is that, unfortunately, I can't make use of the COUNTA function because a formula that evaluates to "" counts as 1 while an empty cell counts as 0, like with the ISBLANK function. Hence the current use of COUNTIF(<blah>,"NULL").
Yes, it's that dynamic defined name aspect that I'm most interested in--could greatly enhance functionality while keeping me VBA/macro free...
I'm always open to any suggestions for improvements (in no way do I consider myself an Excel expert, and I've learned everything i currently know by following other folks' great ideas!) so keep any such suggestions coming!
Erian_7,
Problem! Excel 2k3(the version I am using) has a limit on formula length of 1024 characters and as of version 0_7_13, you have exceeded that limit on at least one formula (AC78). I don't know if you intend to continue to support 2k3, but in case you do, I thought you might want to know.
Hmm, I wonder why the compatibility checker didn't catch that? In any case, I'm working on those very fields right now, as I want to both simplify the overall formula as well as properly accommodate the monk's flurry of blows mechanics. As such, this will definitely be addressed in v.0.7.14 and I hope to have it out within a few days.
The dwarven racial abilities don't fit well into the racial abilities field, and the font size isn't directly editable. When the field is unprotected and the font size decreased, the text doesn't wrap in a legible fashion.
Ideally the racial traits could be dealt with in a "bullet point" fashion similar to what you've done with the feats and class abilities, as they're quite difficult to read now.
I can't speak for anyone else, but the racial saving throw modifiers and other conditional bonuses are generally one of the hardest things for me to remember in a frantic combat. Therefore having an easy-to-read list is pretty crucial, since +2 to save vs. enchantment can really save your bacon when the evil wizard's throwing Confusion around.
Zo
EDIT: I've also noticed that the Total Attack Bonus of the first weapon slot returns code rather than the bonus itself when a wielding option is picked. I can try to clarify further if that's not clear.
It's likely because you are using Excel 2k3. I ran into the same issue, and he is currently working on it.Edit: This is in reference to your problem with the weapon total attack bonus.
I am indeed using Office 2003. Apologies for my redundant post.
Zo
Just discovered that your Armor and Weapon proficiency detection has gone wonky. On the DataClasses tabs, you have changed the values to display as true or false, but the formulas on the back tab are still checking for > 0
Good catch, fixed it!
The dwarven racial abilities don't fit well into the racial abilities field, and the font size isn't directly editable. When the field is unprotected and the font size decreased, the text doesn't wrap in a legible fashion.
Ideally the racial traits could be dealt with in a "bullet point" fashion similar to what you've done with the feats and class abilities, as they're quite difficult to read now.
I can't speak for anyone else, but the racial saving throw modifiers and other conditional bonuses are generally one of the hardest things for me to remember in a frantic combat. Therefore having an easy-to-read list is pretty crucial, since +2 to save vs. enchantment can really save your bacon when the evil wizard's throwing Confusion around.
Zo
An error on my part when setting the sheet protection (it should be set to allow "Select locked cells" and Format cells" but it's not right now). I have been considering reducing the overall text that is presented for the racial descriptions from the current "everything in the PRD" to a more concise format. This would definitely help on the dwarf, which is the biggest offender to text block crowding. Anyone opposed to this approach (and any volunteers to go into those cells to do the summary!)?
For the racial save bonuses specifically, I did want to note that those appear automatically on the Front tab in the Conditional Modifiers block beside the saves. Now, the text is small (set to Shrink to Fit) in order to accommodate getting it on a single line. So, I expanded that line into the next two (which were free-text blocks for direct data entry right now). I set up some an area on the Character Options tab to allow for user entry of conditional modifiers and have that concatenate in a formula. This will actually help out with Traits, since I haven't currently automated their conditional save modifiers.
I just found an error on the prerequisite checking for the Arcane Armor Training feat. The text string it is searching for has too many spaces between the comma and the word Light.
Another good catch, fixed it!
It's likely because you are using Excel 2k3. I ran into the same issue, and he is currently working on it.Edit: This is in reference to your problem with the weapon total attack bonus.
I am indeed using Office 2003. Apologies for my redundant post.
Zo
This was indeed the problem, as reported, and I've now fixed both the display issues and the 1024 character limit (while also revamping the monk flurry of blows to properly accommodate their changing BAB).
My goal is to get a Landscape view completed, then get a release out for everyone to consider. I just realized it's been months and months since my last "official" release at the Pathfinder DB, so I'm going to shoot for getting the APG classes working and then post V.0.8. Subsequent iterations will address continuing feat automation, addition of new 3PP material (including Rite Publishings 101 Feats--I'm very happy to be adding them as official contributors to the effort!). And then there's the Companion tab. And the magic items. And the spell effects...Wee!
so I'm going to shoot for getting the APG classes working and then post V.0.8.
:-) happy
Yep, APG and Kingmaker items (I'll be running the campaign, so need the support...) will be in the next test version, then I'll release v.0.8.
Here are two versions for you guys to test out. Functionality is identical, with the Landscape version now using a wide view for data entry and a (still rough draft) long view for printing. I would definitely like feedback on this, as I'm not currently intending to support two versions of the sheet simultaneously...
In addition, please hammer on the Monk flurry of blows a bit, and check out Magical Knack. Beyond that, I believe I've addressed all reported bugs to date.
Thanks!
Landscape Character Sheet File: PRPG_CS_v_0_7_14_Landscape.zip
Portrait Character Sheet File: PRPG_CS_v_0_7_14_Portrait.zip
Yep, APG and Kingmaker items (I'll be running the campaign, so need the support...) will be in the next test version, then I'll release v.0.8.
Here are two versions for you guys to test out. Functionality is identical, with the Landscape version now using a wide view for data entry and a (still rough draft) long view for printing. I would definitely like feedback on this, as I'm not currently intending to support two versions of the sheet simultaneously...
In addition, please hammer on the Monk flurry of blows a bit, and check out Magical Knack. Beyond that, I believe I've addressed all reported bugs to date.
Thanks!
Landscape Character Sheet File: PRPG_CS_v_0_7_14_Landscape.zip
Portrait Character Sheet File: PRPG_CS_v_0_7_14_Portrait.zip
Heya Erian - Reporting some errors.
I opened the sheet directly from the zip file into Excel 2002 SP3
I got a too many cell formats error 3 times.
Then the following message: Damage to the file was so extensive that repairs were not possible. Excel attempted to recover your formulas and values, but some data may have been lost or corrupted.
Microsoft Excel File Repair Log
Errors were detected in file 'C:\Users\Brad\AppData\Local\Temp\Rar$DI00.086\PRPG_CS_v_0_7_14_Landscape.x ls'
The following is a list of repairs:
Damage to the file was so extensive that repairs were not possible. Excel attempted to recover your formulas and values, but some data may have been lost or corrupted.
I retested executing the file direct from my desk top same error as above.
There have been no errors with the portrait version.
I hope this helps
Hmm, well that's no good. I'll give it a check when I get home. Any chance it referenced a tab/cell with those "too many cell formats" errors? that one in particular bugs me because it's so hard to track down...
Hmm, well that's no good. I'll give it a check when I get home. Any chance it referenced a tab/cell with those "too many cell formats" errors? that one in particular bugs me because it's so hard to track down...
Just a pop up with the error message.
Heya Erian - Reporting some errors.
I opened the sheet directly from the zip file into Excel 2002 SP3
I got a too many cell formats error 3 times.
There have been no errors with the portrait version.
+1
Office 2k3 sp3, winxp sp3Zo