Okay, I've gone through every worksheet and scrubbed them all for errant formatting, so hopefully we've got a clean version here for the older versions of Excel. This version also has the composite bow and crossbow items discussed above.
Skill table is still broken.
I'll see if I can figure out what's wrong with it to give you an easy fix.
That did fix the older excel cell formatting issue.
But yeah, the skill table is broken.
Found the problem. It's an easy fix.
In cell FrontBF40 (the check box for Acrobatis), replace the formula that's there:
=IF(VLOOKUP(BH40,Table_Skills,7,0),"Q","£")
with this
=IF(VLOOKUP(BH40,Table_Skills,11,0),"Q","£")
I'm not quite sure what that IF statement is matching, but the column number on the table that it was pulling from changed from column 7 to column 11.
Once you've replaced the formula in that cell, you can copy and past that cell all the way down column BF, and it will show the right check boxes.
The Calc Mod column is calculating everything correctly, insofar as I can tell.
Mmhmm, that's a place where I started to use the MATCH function to avoid issues like this, then got distracted. Fixed for the next version, and the skill section now uses the MATCH function throughout to avoid future breaks.
Anything else so far?
|
Hi erian_7,
I just started using your application and I love it. Great job!
One issue I found was that the value of cantrips known for Sorcerers is incorrect (row 179 on Class Abilities sheet).
Changing the table to Table_Spells_Known_Sorcerer fixes the problem.
=VLOOKUP(CL_Sorcerer,Table_Spells_Known_Sorcerer,2,0)&" cantrips known (DC "&10+Cha_Mod_Current&"), cast like any other spell, but do not consume any slots and may be used again)"
Hi Mo - something you can do to help Erian fix these faster is to report bugs like this:
Sheet!CelRef, What It Currently Is, What It Should Be.
For example:
Class Abilities!E179
Currently is:
=VLOOKUP(CL_Sorcerer,Table_Spells_Per_Day_Sorcerer,2,0)&" cantrips known (DC "&10+Cha_Mod_Current&"), cast like any other spell, but do not consume any slots and may be used again)"
and should be
=VLOOKUP(CL_Sorcerer,Table_Spells_Known_Sorcerer,2,0)&" cantrips known (DC "&10+Cha_Mod_Current&"), cast like any other spell, but do not consume any slots and may be used again)"
It's a tiny bit more work on your part (since you've got everything in front of you), but it saves a LOT of work on Erian's part in finding the place to make the change.
It's the standard I try to hit when I find a problem.
|
|
Hi Mo - something you can do to help Erian fix these faster is to report bugs like this:
Sheet!CelRef, What It Currently Is, What It Should Be.
For example:
Class Abilities!E179
Currently is:
=VLOOKUP(CL_Sorcerer,Table_Spells_Per_Day_Sorcerer,2,0)&" cantrips known (DC "&10+Cha_Mod_Current&"), cast like any other spell, but do not consume any slots and may be used again)"
and should be
=VLOOKUP(CL_Sorcerer,Table_Spells_Known_Sorcerer,2,0)&" cantrips known (DC "&10+Cha_Mod_Current&"), cast like any other spell, but do not consume any slots and may be used again)"
It's a tiny bit more work on your part (since you've got everything in front of you), but it saves a LOT of work on Erian's part in finding the place to make the change.
It's the standard I try to hit when I find a problem.
Good idea. Thanks for the tip!
Maybe I'm just not seeing it but it appears that the Medusa's Wrath feat is missing from the feat selection table.
Maybe I'm just not seeing it but it appears that the Medusa's Wrath feat is missing from the feat selection table.
Hmm, nope, you're right--it is indeed missing. Adding it in for the next release.
Error with sorcerer cantrips also fixed. Thanks!
Seems that it's not calculating the Bardic Performance rounds/day correctly. It's calculating the "+2 rounds/level beyond 1st" at "+2 rounds/level"
Same thing appears to be happening with rounds of Barbarian rage.
Fixed both the Bbn and Brd calcs.
Check to see if it's doing the same problem with other "Level grants N units of ability Y", like Monk Ki points.
Check to see if the Sorcerer's cantrip issue is replicated with the Wizard as well.
Check to see if it's doing the same problem with other "Level grants N units of ability Y", like Monk Ki points.
Yep, checked those and didn't find any other issues
Check to see if the Sorcerer's cantrip issue is replicated with the Wizard as well.
The sorcerer issue was a hold-over from the table itself being built incorrectly. I had fixed the "big spells" levels 1-9 but missed the cantrips. Wizards/Clerics/Druids don't have the same issue as they don't have a Spells Known table. It did affect the Oracle, which I did correct.
Well I have only just started using your latest version but for my needs it is damned near perfect!
Good to see you around again! Got lots of nice shiny bits on this thing lately, and I've just finished automating the Golarion feats down through Fury's Snare...
Okay,
What is first step to create the Minotaur Druid 4th level.
Step 1: Race
Step 2: ?
Step 3: ?
Step N:Druid 4 + Minotaur Race and on the "Front" tab, char "lvl" has
2=Character_Level+Race_CR
Step 1: Select Minotaur as Race
Step 2: Add 6 levels of Monstrous HumanoidStep 3: Add 4 levels of Druid
At this point, CHAR LVL on the front should show 8 (CR 4 creature + 4 levels of Druid). Everything else should be pretty standard, but do let me know if you run into any other problems.
As y'all have probably noticed, I've taken to making more frequent releases rather than holding things to once or so per week. While I don't want folks to get jarred by so many releases, I also know that as soon as Baby arrives you'll get nothing, and whatever I was working on at the time will be stuck in Limbo for a bit...So, here's v.0.7.6! All the fixes discussed to date, of course, plus feat automation that includes some nifty things like Dervish Dance, the various "Cornugon..." feats, and Dilettante. Enjoy, and do let me know if you spot any issues with the new feats.
7_6 looks good so far on Excel 2002.
Thanks for all your hard work :)
Found another level based class ability glitch.
Cell is Class Abilities!E123 (Paladin Channel Energy)
It's currently:
="Standard Action (no AoO); spend 2 lay on hands uses and present holy symbol to cause 30' radius positive energy burst that affects all undead or living creatures (may exclude self), dealing/healing "&IF(Lvl_Pal>19,(1+FLOOR(Lvl_Pal/2,1))*6,1+FLOOR(Lvl_Pal/2,1)&"d 6")&" dmg; Will save half (DC "&10+FLOOR(Lvl_Pal/2,1)+ Cha_Mod_Current&")"
It should be
="Standard Action (no AoO); spend 2 lay on hands uses and present holy symbol to cause 30' radius positive energy burst that affects all undead or living creatures (may exclude self), dealing/healing "&IF(Lvl_Pal>19,(FLOOR(Lvl_Pal/2,1))*6,1+FLOOR(Lvl_Pal/2,1)&"d6" )&" dmg; Will save half (DC "&10+FLOOR(Lvl_Pal/2,1)+ Cha_Mod_Current&")"
(This removes the "1+" before the FLOOR function based on half the Paladin's level. The Paladin should not be doing more healing from this than from Lay On Hands.)
Class_Abilities!E125 through E128 and Class Abilities!E144 through E147
Both the CL_Paladin and CL_Ranger variables used in the formulas to drive the table lookup for spells per day need to refer to Lvl_Pal and Lvl_Rgr instead, as this provides the correct row for the spells per day lookup.
(This removes the "1+" before the FLOOR function based on half the Paladin's level. The Paladin should not be doing more healing from this than from Lay On Hands.)
Ah, good catch. Fixed!
Class_Abilities!E125 through E128 and Class Abilities!E144 through E147
Both the CL_Paladin and CL_Ranger variables used in the formulas to drive the table lookup for spells per day need to refer to Lvl_Pal and Lvl_Rgr instead, as this provides the correct row for the spells per day lookup.
I ended up changing the lookup table rather than the CL_Paladin reference as that named call is a combination of the paladin's level (-3 of course) and any increase to the caster levels from prestige classes. I originally ran those class ability functions off of level, but changed it when I came up with the Caster Level fix for all the other classes. However, I forgot about how the table was structured...in any case, fixed!
Hi folks, just wanted to note that Ken/AdAstraGames has volunteered to carry on general maintenance of the sheet in the event that I disappear for an extended period of time with the baby. I'd say if I don't post for 2 days, then you'll know I'm out for a bit...
Also, while I intend to get all the non-core feats automated for my next big release, I also started working on another element I want to include--companions. To that end, I have gotten the Animal Companion rules mostly in place (still working on formatting/presentation) and will hit Familiars next. My current plan is to have a half-sheet for each that somewhat mirrors the Front/Back tabs for the main character, with selectors for feats/skills, etc. I'm having to build in the feat/skill automation separately from the main sheet so it doesn't get confused with the character's actual feats, so for now the list is limited to those feats/skills appropriate for Int 2 or lower animal companions.
So, for those that have been looking for animal companions and familiars for your character...Merry Christmas!
Sorry if this has been said earlier in the thread but, i was wondering why you have the skills ordered the way they are. i would think that would be better if they were in alphabetical order, but that is just my opinion.
otherwise i really like what you are doing with the sheet.
Asked on the previous page, actually, but I don't mind stating it again...
They are grouped by "usable untrained" vs. "trained only", then sorted alphabetically. I do this personally so that I can then delete the "trained only" skills not applicable to a specific character and reuse all that wasted space for something else (like a Special Notes section for commonly used spells, special abilities, etc.).
Note that you can of course re-order them any way you want with the drop-downs. You can even do this once, then copy your sort order into any new versions to minimize effort. This can be handy as some folks like them sorted by Class/Non-Class, some by Combat/Non-Combat, some by Key Ability, etc.
And there are some things on the sheet that I don't understand how Eric/Erian has made work...so there will be some things I can fix, and some things that will go into the "When Eric has time to fold changes in."
I believe that I have found a simple error, the spreadsheet doesn't give rogues composite shortbow proficiency. This is in the PRPG_CS_v_0_7_6 version.
Ah, good catch. I need to set the Proficient logic for composite bows to trigger off the parent bow. Fixed!
I tried opening up 7_6 version with Excel 2002, but the program keeps crashing when I open the file.. Any ideas??
Can you tell me what error(s) you are getting? That'll help me figure out what's what...
Posting v.0.7.7 so folks can see how the animal companion is shaping up--any feedback is welcome, of course. Note that at present only the alligator has it's attacks automated to work with Improved Natural Attack and Weapon Focus. Most of the other feats are fairly automated at this point. Still need to build in Tricks, fill out data for the Bestiary creatures, and automate all the attack modifications from feats/leveling.
Oh, and of course all issues noted to date have been corrected.
The link doesn't work -- it seems you uploaded the .xls file, rather than in .zip-format.
Ditto for me too.
Ah thanks, fixed it...
Okay. I just got the latest version. Moving and an online convention has kept me pretty busy and this is the first opportunity to check things in a while. :-)
Had a problem initially inputting stats on the Character Options tab. I had to resave the sheet in 2007 (actually, I'm working in 2010 Beta).
You have to actually input feats and stat ability increases. These used to be drop down menus.
On the front page, the drop down menu for conditions_1 is appearing as a Character_Name option. You can't input your character name. Likewise with conditions_2 and Player_Name.
Can't seem to get the "Not Wielded" words to change to the proper Total Attack Bonus. Is there a check box or something that I'm missing here?
On the back page, same problem with the armor special materials drop down appearing for the XP_Total.
Some of the feats and class abilities no longer wrap on the Abilities & Feats page.
I know you are working hard on the Beta Test stuff, but I was curious as to what I could do to move along the rest of the LSJ stuff into the sheet (Prestige Classes, cleric class adjustments, etc.).
Thanks! :)
Jay
I love the work.
Is there no way to put a reset button on the set-up, to clear it of selections?
Not without going into Excel macros, which will pretty effectively keep anyone from using it on a Mac or in Open Office.
|
|
Okay. I just got the latest version. Moving and an online convention has kept me pretty busy and this is the first opportunity to check things in a while. :-)
Had a problem initially inputting stats on the Character Options tab. I had to resave the sheet in 2007 (actually, I'm working in 2010 Beta).
You have to actually input feats and stat ability increases. These used to be drop down menus.
On the front page, the drop down menu for conditions_1 is appearing as a Character_Name option. You can't input your character name. Likewise with conditions_2 and Player_Name.
Can't seem to get the "Not Wielded" words to change to the proper Total Attack Bonus. Is there a check box or something that I'm missing here?
On the back page, same problem with the armor special materials drop down appearing for the XP_Total.
Some of the feats and class abilities no longer wrap on the Abilities & Feats page.
I know you are working hard on the Beta Test stuff, but I was curious as to what I could do to move along the rest of the LSJ stuff into the sheet (Prestige Classes, cleric class adjustments, etc.).
Thanks! :)
Jay
Feats and stat ability increases are still dropdowns for me in v0.7.7.
Feats and abilities wrap correctly for me on the A&F page.
I also don't see the same bugs you're getting with the condition dropdowns and armour special materials. I'm using Excel 2007 so I wonder if you're seeing a bug caused by using Excel 2010 beta?
To get the "not wielded" wording to be replaced by the attack bonus you need to pick a value in the first combat option dropdown under the weapon (the one that defaults to "wielded as?").
Hope this helps.
Phil
Not without going into Excel macros, which will pretty effectively keep anyone from using it on a Mac or in Open Office.I love the work.
Is there no way to put a reset button on the set-up, to clear it of selections?
Yep, macros are the only way to accomplish this, and with my commitment to compatibility it's not a path I'm likely to pursue. There are several macro-enabled sheets (Kor's got one in alpha that's under discussion in this forum, and there's the subscription-fee-based TOS+) that could accommodate this.
I know you are working hard on the Beta Test stuff, but I was curious as to what I could do to move along the rest of the LSJ stuff into the sheet (Prestige Classes, cleric class adjustments, etc.).
Thanks! :)
Jay
I'm planning to automate the LSJ feats in this pass, as well as complete the class ability automation for aristocrats, nobles, and the temptress. If someone can do the leg-work of data entry for the prestige classes I could definitely do the final work to tie them all in as options (probably could do everything except class ability automation).
Feats and stat ability increases are still dropdowns for me in v0.7.7.
Feats and abilities wrap correctly for me on the A&F page.
I also don't see the same bugs you're getting with the condition dropdowns and armour special materials. I'm using Excel 2007 so I wonder if you're seeing a bug caused by using Excel 2010 beta?
To get the "not wielded" wording to be replaced by the attack bonus you need to pick a value in the first combat option dropdown under the weapon (the one that defaults to "wielded as?").
Hope this helps.
Phil
As Phil notes, I'm thinking this may be a problem in the 2010 beta, as I've not had anybody else report issues that are this extensive. That said, can anybody else confirm having similar problems?
Are you doing anything in the data source for data validation for drop downs that involves =INDIRECT(), Eric?
(Whenever there's a new version of Excel out, I always worry that they're going to change how INDIRECT works and break it in data validation.)
Are you doing anything in the data source for data validation for drop downs that involves =INDIRECT(), Eric?
(Whenever there's a new version of Excel out, I always worry that they're going to change how INDIRECT works and break it in data validation.)
Nope, I haven't gotten that fancy as yet.
I also don't see the same bugs you're getting with the condition dropdowns and armour special materials. I'm using Excel 2007 so I wonder if you're seeing a bug caused by using Excel 2010 beta?Phil
That's exactly what the problem was. I'm now on 2007 and everything is working fine and where it is supposed to be. Thanks!
I did, however, find an omission. The 8th level granted ability for the Charm Domain is missing. There's a blank area on the Abilities and Feats page (where it probably could go as all other aspects of the class is continuous), but it isn't there. I checked the Domains tab and it isn't there either.
Jay
On the Spells tab: The cell with the Spell_Ability_Modifier number (Cell CS38) does not take into account temporary ability modifiers.
Here is my modification:
=IF(CO38="Int",(IF(ISNUMBER(Int_Mod_Temp),Int_Mod_Temp,Int_Mod)),(IF(CO38=" Wis",(IF(ISNUMBER(Wis_Mod_Temp),Wis_Mod_Temp,Wis_Mod)),(IF(CO38="Cha",(IF(I SNUMBER(Cha_Mod_Temp),Cha_Mod_Temp,Cha_Mod)),0)))))
I also don't see the same bugs you're getting with the condition dropdowns and armour special materials. I'm using Excel 2007 so I wonder if you're seeing a bug caused by using Excel 2010 beta?Phil
That's exactly what the problem was. I'm now on 2007 and everything is working fine and where it is supposed to be. Thanks!
I did, however, find an omission. The 8th level granted ability for the Charm Domain is missing. There's a blank area on the Abilities and Feats page (where it probably could go as all other aspects of the class is continuous), but it isn't there. I checked the Domains tab and it isn't there either.
Jay
The following should be in cell D9 on the Domain tab:
Charming Smile (Sp) - Swift Action, cast charm person (Will save DC "&10+FLOOR(A1/2,1)+Wis_Mod_Current&"), for up to "&A1&" rnds/day (dismiss as Free Action)"
Is this not present in yours? If so, that's very odd. I've confirmed it definitely shows up in the build currently being worked, so I know it'll be good by tonight (when I publish this version).
On the Spells tab: The cell with the Spell_Ability_Modifier number (Cell CS38) does not take into account temporary ability modifiers.
Here is my modification:
=IF(CO38="Int",(IF(ISNUMBER(Int_Mod_Temp),Int_Mod_Temp,Int_Mod)),(IF(CO38=" Wis",(IF(ISNUMBER(Wis_Mod_Temp),Wis_Mod_Temp,Wis_Mod)),(IF(CO38="Cha",(IF(I SNUMBER(Cha_Mod_Temp),Cha_Mod_Temp,Cha_Mod)),0)))))
Ah, good catch. I've got a named cell that actually takes care of this logic for other calcs like class ability DCs (). So you can use thisL:
=IF(CQ38="Int",Int_Mod_Current,(IF(CQ38="Wis",Wis_Mod_Current,(IF(CQ38="Cha ",Cha_Mod_Current,0)))))
The following should be in cell D9 on the Domain tab:Charming Smile (Sp) - Swift Action, cast charm person (Will save DC "&10+FLOOR(A1/2,1)+Wis_Mod_Current&"), for up to "&A1&" rnds/day (dismiss as Free Action)"
Is this not present in yours? If so, that's very odd. I've confirmed it definitely shows up in the build currently being worked, so I know it'll be good by tonight (when I publish this version).
Actually I found it. The problem was that the LSJ Domains aren't fully automated. So the description for the 8th level ability for the Sensation domain was simply copied whereas in the Charm domain it was limited to the cleric level (the sheet is setup as a cleric 5/tempt 5).
Thanks!
Jay
Actually I found it. The problem was that the LSJ Domains aren't fully automated. So the description for the 8th level ability for the Sensation domain was simply copied whereas in the Charm domain it was limited to the cleric level (the sheet is setup as a cleric 5/tempt 5).
Thanks!
Jay
Yeah, that would make sense. LSJ domains are another area I want to automate before the v.0.8 release...
Update for tonight. not too much in this one as I had to actually work at work today...mostly just bug fixes that were reported.
Any thoughts on the animal companion thus far (I know it's still in rough draft, just figured getting direction before I create the thing is better than after...)