Hey all, obviously I didn't get that version posted...
However, I should have a good block of time tomorrow and I'm going to use it to (a) hit the bugs reported to date, (2) hopefully finish out the favored class racial automation, and (3) do some quick-hits for the core class alternates (those of you wanting the bloodlines and domains should be very happy...).
|
On the display on the front side, did you make sure that the type of output sheet you selected on Getting Started was the one you used?EG, if it's still set to Landscape and you're using Portrait, it's going to not show up on portrait.
I cannot replicate your problem with the line 'going away'. Erian, can you look into that one?
Yes, made sure I was in the correct output sheet, landscape in this case. This is in Excel 2007. And to try and show what I mean, this is what I see after choosing the feat but before selecting a weapon in the L-Abilities and Feats tab:
- Weapon Focus [select weapon]: +1 bonus on attack rolls with- Weapon Focus [select weapon]: +1 bonus on attack rolls with
- Weapon Focus [select weapon]: +1 bonus on attack rolls with
After selecting the weapon, this is what I a see:
- Weapon Focus [select weapon]: +1 bonus on attack rolls with
- Weapon Focus [select weapon]: +1 bonus on attack rolls with
The actual feat description with the weapon attached is not visible at all and as I said, the +1 is not automatically added to the weapon block in the L-Front tab. It appears to not work in the P-tabs with portrait selected as well.
Erian,
You have done an absolutely amazing job. I know you've heard this before, but bravo! You've basically replicated the core rulebook plus tons of additional content into a fully automated machine, and legally, too! I can't imagine how much time you've put into this.
Sadly though, I'll have to ask for just a touch more of your time. As you're no doubt aware, the Magus base class beta recently ran, and though I will purchase the book when it becomes available, I am attempting to use the class now.
I've created a custom class, and all the values are showing correctly and automating save the BAB fields. I'm in the correct orientation, and have selected the "mid" range BAB from the drop-down menu. Str adds to my melee and Dex to my ranged, but BAB is not reflecting in either on the "L-Front" tab. They do if I change one of my four Magus levels to Fighter, however. Is there something special I need to do for the custom class? Thanks in advance!
This sounds like you didn't reselect the proper feat after you selected a weapon for weapon focus. One of the Weapon Focus select weapons disappeared from the feat list because you added a weapon to the list, generating the new feat Weapon Focus [the weapon you picked]. You have to replace the Weapon Focus [select weapon] with Weapon Focus [the weapon you picked] on your list of selected feats.
Unless of course you've actually done that already, then I've got nothing.
This is my current assessment as well, as I'm unable to break the Weapon Focus feat selection. Do this for me and see what happens:
On the Getting Started tab, go to cell AX62 (named Weapon_Focus_1) in the FEAT SETTINGS section of ABILITIES, RACE, CLASSES, & FEATS. Select a weapon. Now in the Feat Checker right next to this (specifically cell BG55) use the drop-down to find Weapon Focus. There should now be an entry with the weapon you chose. If this doesn't work, we'll have to dig further. Also, if you've done some other things for character creation and then this doesn't work, let me know. There may be some crazy formula interaction somewhere that I'm not finding...
For the other reports, I'm happy to say that both the Bard and Dragon Disciple errors are corrected. For the Bard, somehow the entire bardic performance table got overwritten with the DataGeneral data. It goes back that way at least as far as v.0.9. I snagged the data from an early version and it's now good to go. For the Dragon Disciple it was even easier. At some point, I must have done a global replace of the _Mod_Current named cell references. In doing so, several of them became _Mod_Current_Current. I axed the redundant _Current and they're good to go.
For the issue with the Magus, I've been unable to replicated the BAB not working. When I send out v.0.9.4 it'll have the Magus loaded as the Custom Class, so try that one out and see if it still breaks down...
Thanks!
Thanks!
Im assuming that the Bard and Dragon Disciple errors are referring to the issues I explained?
Wonderful work as always.
Nik
Yep. And it actually reminded me of another half-finished effort in replacing all the legacy references that are hard-coded to the Landscape sheet. Should have those all taken care of tonight I think.
I'll be posting v.0.9.4 tomorrow with all the APG bloodlines and domains in place, plus a surface implementation of the racial favored classes and alternate traits. By superficial I mean that the behind-the-scenes automation is not fully complete as yet. Still working out the best way to do that and may wrap it into fixing the Class Abilities table when I implement the archetypes.
Look forward to it accomodating my power-ranger :p
Wow, just wow. You're amazing. Most companies aren't as responsive as you, and I'm PAYING for their products. I'm not an excel guru, but if there's anything simple (or tedious, or whatever) that I can do, please let me know! Thanks again!
Heh, thanks...at least most companies hopefully don't randomly disappear for chunks of time like I do! Or, if they do I wouldn't give them any more money!
It's taking longer to do the subdomains (man, there are a lot of subdomains!), but I've at least got them all in place. Most are not fully automated for the domain powers, but everything else should work. All the bloodlines should be good to go as well. I should be able to get in the domain power automation and rage powers in my next run, then I'm looking at tackling the mountain that is archetypes.
So, bang away and let me know what you find!
Character Sheet File: PRPG_CS_v_0_9_4.zip
|
Hi there. Great work. I love how this thing has evolved over the last few months. I may have spotted something weird. I'm using version 9.4 so maybe it's already changed/fixed. I'm stating up a ranger/rogue w/ high Dex so I took Weapon Finesse. When I add a weapon (rapier), if I don't select anything for M/R/T (melee/ranged/thrown), my Dex modifier is used to calculate the attack bonus as it should, but my Str bonus isn't applied to damage. So I select "Melee." The Str bonus is now added to damage, but Weapon Finesse isn't in effect anymore; the sheet reverts to using Str to calculate attack bonuses instead of Dex. Just by selecting "Melee" I can watch my attack bonus drop from the correct number to one that matches another, non-Finesse weapon.
0.9.4 is working great! Thanks for the custom Magus, the BAB issue I was having is no longer a problem. Curiously, the AC, Touch, and Flatfooted values returned a value of "NAME?," but as I didn't want to break anything, I merely copied the formulae from version 0.9.3, and that cleared everything right up. I added in a few more of the class features (by name only), and I'll let you know if I can find anything else! Thanks again!
Also, I like the fact that the favored section is now immediately right of your class selection, making it easy to find if you chose to split your bonus points between HP and skill ranks. Good move!
I did run across one more thing, even after recreating the character from scratch. My human bonus feat is not available in the drop down list (literally "unavailable"), so I simply slapped Toughness in the Manual Override. Awesome foresight on your part, by the way. Four slots worth of override should do just fine even well into epic levels, no matter how crazy the campaign.
I've gotta say, this is the most favorable experience I have ever had changing games. My DM convinced / coerced us to switch from 3.5, and the community here is awesome. Not that it wasn't on Wizards, but here even more so. Game on!
|
|
Hi, I am constantly amazed at how much work you put in to this sheet and how great it is. I just pulled down the 9.4 version and saw the spaces for the Oracle's extra revelations but I can't seem to get it to let me add one. I've chosen the feat extra revelation 1, but down in the spaces for the oracle, it still says unavailable. Is there something else I need to check to make it work?
|
Erian once again wanted to let you know what a great job you've done on this sheet!!
A couple of things...
1.) On a fresh load of version 0.9.4 the landscape AC is not calculating correctly as the formulas used to calculate the totals for AC, Touch, and Flat-Footed are all reporting an incorrect name error. The culprit is "...+AC_Size+..." in the formula. It is missing what sheet it is referencing and should read "...+AC_Size_L+..." The Portrait view has the correct distinction in the formula so no worries there.
2.) The campaign trait "Sword Scion" is causing an erroneous Fort save bonus to ocurr when selected. The problem traces from Landscape Front cell BS49 "Fort Save - Other"; trace the precedent back to "Fort_Other" on DataCharacter tab cell G3. Evaluated the formula there and found where the bonus was coming from "Traits_Bonus_Fort" found in Traits tab cell H3. Slid down the column and found the bonus to be coming from the Sword Scion trait. The formula in cell H130 should just be erased to leave a blank cell and that will solve the problem. The cells above and below both reference the Fort Save, but not the Sword Scion Trait.
3.) The Sword Scion trait is doing the same thing for the Swim Skill. Same fix, just delete the formula in that column/row.
Again, loving what this sheet is doing for me and my group at the game table! Thanks for all the hard work, time and effort put into the sheet!
|
|
Corzat (above) actually introduced me to this sheet, as I was trying to write my own epic Excel character sheet...yours is much better! So, first off, thanks for this rockin' piece of gear!
One thing I've found...
While wielding a shield, the sheet does not calculate attacks with a lance, b/c the lance reads as a 2-handed weapon, even while mounted. I fixed my sheet by simply adding an "if" formula on the DataEquipment tab. [=IF('L-Front'!P38="Mounted", "1-handed", "2-handed")] However, that only fixes it for the specific conditions in which I use my lance. Others will have to modify it for their own use. I'm not sure how to make it happen automatically for all instances of lance use.
Other than that, the sheet is killer! Keep up the great work, and many thanks again!
|
|
I did run across one more thing, even after recreating the character from scratch. My human bonus feat is not available in the drop down list (literally "unavailable"),
I had the same problem but if you look in the racial options make sure you don't have anything in the "Alternate Racial Traits" boxes, that should fix it.
I had the same problem but if you look in the racial options make sure you don't have anything in the "Alternate Racial Traits" boxes, that should fix it.
Thanks for the tip, Kochean. I tried, and cleared all text boxes in the racial traits section (even for the non-human races), but still have the same problem. Because of your tip, though, I simply moved Toughness from manual override to the Bonus Feat section under Human Racial Options. Still calculates without the need for override. Thanks!
Glitches found:
Getting Started: The drop downs in AE39 and AE40 should be removed; their functionality is subsumed into the race options drop down.
L-Front: The cells that calculate AC, Touch AC and Flat Footed AC are all referring to AC_Size, not AC_Size_L.
Schools: Half of the school special abilities that refer to caster level are returning #NAME errors, probably tied to a variable changing names.
L-Spells: The lookups in cell CX19 (and similar lookups for other spell levels) are not working. I'm not sure why.
P-Spells: Same error as above.
Lots of little glitches based on names of named ranges changing.
Hey all, thanks for the bug reports. I'm working on the fixes for these in v.0.9.5 and have a few solved already. As always, thanks for the well-wishes and encouragement!
Hi there. Great work. I love how this thing has evolved over the last few months. I may have spotted something weird. I'm using version 9.4 so maybe it's already changed/fixed. I'm stating up a ranger/rogue w/ high Dex so I took Weapon Finesse. When I add a weapon (rapier), if I don't select anything for M/R/T (melee/ranged/thrown), my Dex modifier is used to calculate the attack bonus as it should, but my Str bonus isn't applied to damage. So I select "Melee." The Str bonus is now added to damage, but Weapon Finesse isn't in effect anymore; the sheet reverts to using Str to calculate attack bonuses instead of Dex. Just by selecting "Melee" I can watch my attack bonus drop from the correct number to one that matches another, non-Finesse weapon.
I tried this one and didn't get an error. I did the following to test: Open up a clean copy of v.0.9.4. Set Str to 14, Dex to 16, Race to Human, Ability Bonus to Dex, Class to Ranger 1, Feat to Weapon Finesse. On the L-Front tab, I then set the first weapon block to Rapier, M/R/T to Melee, and Wielded As? to 1-Handed. After doing this, I have the Rapier with a +5 attack bonus and damage of 1d6+2.
Can you try this out and let me know what happens?
0.9.4 is working great! Thanks for the custom Magus, the BAB issue I was having is no longer a problem. Curiously, the AC, Touch, and Flatfooted values returned a value of "NAME?," but as I didn't want to break anything, I merely copied the formulae from version 0.9.3, and that cleared everything right up. I added in a few more of the class features (by name only), and I'll let you know if I can find anything else! Thanks again!
As noted by several others, this is due to a missing _L in the named references in a few cells. Fixed for the next version.
Also, I like the fact that the favored section is now immediately right of your class selection, making it easy to find if you chose to split your bonus points between HP and skill ranks. Good move!
Yes, I think this will really help in getting the favored class bonuses applied correctly. I'm still working through the flow to make sure everything goes to the proper place, so let me know if you see any issues!
I did run across one more thing, even after recreating the character from scratch. My human bonus feat is not available in the drop down list (literally "unavailable"), so I simply slapped Toughness in the Manual Override. Awesome foresight on your part, by the way. Four slots worth of override should do just fine even well into epic levels, no matter how crazy the campaign.
This is a legacy of the Bonus Feat showing up in the first section and also in the new Races section. For any race with a specific Race section (like Humans) you select the bonus feat down below. The section at the top will be going away once I get all the Race sections in place, but I can't remove it right now since some non-Core races need the Bonus Feat and Skill selectors as well.
I've gotta say, this is the most favorable experience I have ever had changing games. My DM convinced / coerced us to switch from 3.5, and the community here is awesome. Not that it wasn't on Wizards, but here even more so. Game on!
Glad you're enjoying it! I'm obviously a big fan of Pathfinder...
Hi, I am constantly amazed at how much work you put in to this sheet and how great it is. I just pulled down the 9.4 version and saw the spaces for the Oracle's extra revelations but I can't seem to get it to let me add one. I've chosen the feat extra revelation 1, but down in the spaces for the oracle, it still says unavailable. Is there something else I need to check to make it work?
Hmm, looks like my selection logic is a bit off. I'll fix that for the next release...
Erian once again wanted to let you know what a great job you've done on this sheet!!
A couple of things...
1.) On a fresh load of version 0.9.4 the landscape AC is not calculating correctly as the formulas used to calculate the totals for AC, Touch, and Flat-Footed are all reporting an incorrect name error. The culprit is "...+AC_Size+..." in the formula. It is missing what sheet it is referencing and should read "...+AC_Size_L+..." The Portrait view has the correct distinction in the formula so no worries there.
2.) The campaign trait "Sword Scion" is causing an erroneous Fort save bonus to ocurr when selected. The problem traces from Landscape Front cell BS49 "Fort Save - Other"; trace the precedent back to "Fort_Other" on DataCharacter tab cell G3. Evaluated the formula there and found where the bonus was coming from "Traits_Bonus_Fort" found in Traits tab cell H3. Slid down the column and found the bonus to be coming from the Sword Scion trait. The formula in cell H130 should just be erased to leave a blank cell and that will solve the problem. The cells above and below both reference the Fort Save, but not the Sword Scion Trait.
3.) The Sword Scion trait is doing the same thing for the Swim Skill. Same fix, just delete the formula in that column/row.
Again, loving what this sheet is doing for me and my group at the game table! Thanks for all the hard work, time and effort put into the sheet!
Got the AC error fixed as noted earlier. For the Sword Scion, it looks like some copy/paste issues. I'll clean that up for the next release. It is a good illustration of how you can add new traits--building them into that table with the correct formula will auto-flow to the right skills/mechanics.
Corzat (above) actually introduced me to this sheet, as I was trying to write my own epic Excel character sheet...yours is much better! So, first off, thanks for this rockin' piece of gear!
One thing I've found...
While wielding a shield, the sheet does not calculate attacks with a lance, b/c the lance reads as a 2-handed weapon, even while mounted. I fixed my sheet by simply adding an "if" formula on the DataEquipment tab. [=IF('L-Front'!P38="Mounted", "1-handed", "2-handed")] However, that only fixes it for the specific conditions in which I use my lance. Others will have to modify it for their own use. I'm not sure how to make it happen automatically for all instances of lance use.
Other than that, the sheet is killer! Keep up the great work, and many thanks again!
Yes, the mounted lance wielder is problematic. I've been trying to figure out the best way to handle that one...
Glitches found:
Getting Started: The drop downs in AE39 and AE40 should be removed; their functionality is subsumed into the race options drop down.
I can't take thee out quite yet (as noted above, there are non-Core races that still need this). I'm thinking on ways to streamline the race selectors and possibly have things more compact and customized based on race selection.
L-Front: The cells that calculate AC, Touch AC and Flat Footed AC are all referring to AC_Size, not AC_Size_L.
Got this one, thanks!
Schools: Half of the school special abilities that refer to caster level are returning #NAME errors, probably tied to a variable changing names.
Ah, this is another clean-up issue. The references to Int_Mod should be Int_Mod_Permanent.
L-Spells: The lookups in cell CX19 (and similar lookups for other spell levels) are not working. I'm not sure why.
P-Spells: Same error as above.
Hmm, looks like the Header_Abilities MATCH is broken. I'll fix that...
Lots of little glitches based on names of named ranges changing.
Send'em my way!
Thanks all!
I think your character sheet is awesome! I have no idea how you had the patience to put this all together.
Do you have plans to add the archtypes from the APG? Sorry if this has already been answered.
Yes - we do. There are hooks in place for them. Erian and I are hashing out the data format and data entry tasks.
great work and ty but just a quick question could u automate the masterworked backpack?
great work and ty but just a quick question could u automate the masterworked backpack?
Hmm, the masterwork backpack would be an interesting bit to handle. That's something I'd try to tackle at the earliest after getting the archetypes and such in place.
something else i was curious about is do are you going to include monster templates? such as half-dragon or werewolf
|
something else i was curious about is do are you going to include monster templates? such as half-dragon or werewolf
Actually, on a related question, as a DM I have need to quickly create character levels on some monsters -- lizardfolk recently. Is there an easy(ish) way to do that with your sheet? Make a leveled hill giant or gnoll or whatever?
|
|
something else i was curious about is do are you going to include monster templates? such as half-dragon or werewolf
Actually, on a related question, as a DM I have need to quickly create character levels on some monsters -- lizardfolk recently. Is there an easy(ish) way to do that with your sheet? Make a leveled hill giant or gnoll or whatever?
I do intend to implement templates at some point. Once I get the Races functionality rebuilt for the APG stuff it will actually be much easier to add the templates.
As for adding classes to other races, that is possible as well. I've got the pugwampi and gnoll in the mix right now, for instance. You select Race as expected, then select a number of class levels in the appropriate race "class" (e.g. 1 level of Fey for the pugwampi or 2 levels of Humanoid (gnoll) for the gnoll). Then you add classes as desired. To make this work for non-Humanoids is pretty simple, as the race "class" doesn't change much. The Humanoids require a bit more since the subtypes have different mechanics. Eventually I'm sure I'll get in lots of monsters, but right now I basically add them on request. It's not hard to do for anyone with a bit of Excel skill, so others can follow the same process.
So, basically if there's a specific race you need, I can usually bang that out in between major updates. Or else you can look at the DataRace and DataClass tabs for how the Gnoll is structure and follow that example.
Hello E7
Top class work.
Just a couple of things:
Using Excel 2002 SP3
I get #N/A in the spells per day and bonus spells slot for an 8th level witch with a 20 int on the L Spells page
Also same class and level with slumber as the level 8 hex - On the L-Abilities & Feats tab the feat displays as "&lvl_wit&"rnds
I have also noticed for the cell that it displays in the wrap does not work and the text runs off the page. I have tried resetting the word wrap but this does not work.
EDIT:
I am also getting the light armor proficiency from somewhere.. not sure where and AC on the LFront is showing as ###
|
|
The AC formula is broken, but easily fixed. just select the AC cell that has the ## in it, and up in the formula bar click on size bonus which should be gray. Then choose the size bonus box for it, then hit enter. Should take care of it.
Are the alternate base class features in APG a planned update?
|
|
So, basically if there's a specific race you need, I can usually bang that out in between major updates. Or else you can look at the DataRace and DataClass tabs for how the Gnoll is structure and follow that example.
I may try and look at how you did some of the coding for races, but until then...
I would like to see (as a DM)...
Bugbear, Troll, Ogre, Lizardfolk, Morlock, Harpy, Sahuagin, Satyr, and Rakshasa. Hill, Frost, Stone, & Fire Giants might be nice as well.
For some of these higher base HD monsters, it may be possible to go past 20 HD. Might need to add a few lines...
Thanks for all your work on this.
|
|
I'm playing a summoner in our campaign and I'm finding all kinds of problems with the Eidolon.
Evolution points used are not adding up.
Not all the evolutions are showing up (I changed the formula to "ROW()-230" to make it work).
Claws were not an option for the Quadruped.
Improved Claw Damage didn't improve the damage.
Ability boosts are 5th, 10th, and 15th (I believe).
If you take the Tail evolution, the Sting attack isn't available.
It's hard for me to tell where your tables are or where they are getting their information all the time. I'm generally forcing it but it would be nice if it calculated it right so that I knew I was doing it correctly.
Thanks for all your work on this. Wish I knew more about Excel than I apparently do so that I could help troubleshoot better.
and just to explain b4 when i was talking about stone plate being 10 ac i got it confused with mountain plate :/ lol
maybe its just that i messed something up or this may have been reported but the bonus spells for the witch is broke
|
|
great work and ty but just a quick question could u automate the masterworked backpack?Hmm, the masterwork backpack would be an interesting bit to handle. That's something I'd try to tackle at the earliest after getting the archetypes and such in place.
I just went to the Light_Load formula and typed "+1" at the end of the INDIRECT line that goes looking for STR score... I tried an "if" statement that looked at the cell where I listed "backpack, masterwork" in my gear, but I was using Open Office and I guess the IF formulaes are not the same with that program, as it kept producing an error...
|
|
Lots of little glitches based on names of named ranges changing.
Send'em my way!
Thanks all!
last night I had a rogue built up with weapon finesse and weapon focus rapier (via weapon training talent) and I tried swapping focus rapier to focus short sword and while the drop-down successfully turned over to "short sword", the front sheet wasn't showing registering the added +1 in the first weapon block...
thanks for all the great work guys
Hey guys, been sidelined by a lot of things, some not so cool (yet another round of family sickness, plus crazy-time at work again) and some very cool (we've started our process to adopt, taxes look like we'll get a bit more back this year (which we'll need for the adoption...), and I got my Adam on Thursday!). I should be caught up on work stuff tomorrow or Thursday and have already started looking at some of the reported issues. I'm also continuing to chug through the automation for the APG pieces I've got in place so far. And of course, seeing how well this thing will work on the Adam...
I'll be posting about the Adam over here for interested folks.
Erian_7: This is just off the top of my head; I haven't read upthread to see if you've addressed this at all, but what are your thoughts on providing a bit of documentation on the structure of the sheet? I've been playing around with Excel and I think I'm starting to get the hang of things. I know a few of the other posters are contributing to the development of the sheet as well, so perhaps if you (or someone) could provide a list of relevant cell names, preferred methods of implementing automation, a to-do list, and other important bits it'd be easier to turn the sheet into more of a community project.
Just a thought,
Zo
Erian, if you can take the Barbarian and Bard archetype stuff I sent in, and format it exactly the way you want it (especially the Bard stuff), I will turn it into a Google Docs sheet and let other people tackle the data entry on it while I manage them, then extract from Google Docs and send it to you when it's done.
Oh yes, I'd definitely love to make this a more community-based effort! We've been trying to get something like that going for a while now.
Ken, I shot that spreadsheet with the layout your way.
Thanks!
P.S. No luck on tests on the Adam--the file size is to large for Quickoffice. I'll have to do some sit-down time to figure it out, but that would be after the APG material is done.
I would help but i have no idea how to lol XD
There's no technical aspect to a lot of the work needed--it's basically just taking the APG material and putting it into separate fields. So you'd have a line on a table that has a separate field for the ability name, summary description, archetype, class, level gained, and ability replaced.
I take that and build in the logic, table structures/lookups, etc. to make everything work. The slow part of the APG, basically, is the massive amount of new data to get in the system. It's comparable to adding the entire PHB again...
|
|
can't wait for the new update erian. i'd like to point out a problem i noticed with v9.4. lingering performance doesn't post what the feat does in the feat section when selected.
i selected lingering performance as a 1st lvl bard, and all i get in the abilities and feats tab is "-Lingering Performance:" after the colon, it's all blank.
also, each time i save a new character with v9.4, i get an error saying that i'll have significant data loss. i haven't noticed a problem yet, but it happens everytime i open the base file and save it as a new file with changes.