Kor
Playing around with the sheet yesterday (trying to create a master DM display sheet for my game this weekend) I noticed a problem with the way information is displayed on the Arm_DATA tab.
You can end up with a negative BAB being shown as +-N due to the logic surrounding cells that work out your melee BAB (CX5 through to DB5) and ranged BAB (DG5 through to DK5).
Just thought I would flag it up to you in case you had not spotted it.
Thanks, I had not noticed that. I also noticed now that I have a problem with how a negative CMB is shown so I have fixed that too.
Hi Kor,
first of all wanted to say thumbs up!! for the great work you have done with this sheet, tried with some basic chars and seems to work very well (great job by testers too as I read :D) and has very nice looks.
What I wanted to ask is if you plan in the near future to include prestige classes and the new base classes from the Advanced Manual (I see you have it included but greyed out) for character creation.
Keep up the awesome job!
Thorg
Thanks for trying out the sheet.
I am hoping to start adding Advanced Player Guide Content by November.
*------------------------------------*
====== New Revision =======
*------------------------------------*
The latest release is now available at www.d20.ca
Alpha version 0.75cy
Revised:
- oohhh... so many changes
- I have completely overhauled the Arms, Items and Custom pages.
- Arms now allows for selection up to 12 Arms.
- I have added some armor and shields from the Armory & APG, but I have only added their base stats. I have not added in any of their special uses that may apply as indicated in their descriptive text. This will be added in the future.
Feedback Requested:
- I have (temporarily?) added an alternative Page3 display (which allows for up to 12 weapons to be displayed). My options right now are:
#1. Scrap the alternative Page 3, and just add another page similar to the existing Page 3 (but without the arms & shield areas) which would display if more than 6 weapons are selected on the Arms Page.
#2. Default to the existing Page 3, but similar to the Page 4 toggle, allow people to toggle to the alternative Page 3 instead of the existing Page 3
#3. Scrap the existing Page 3 and use only the new alternative Page 3.
Please let me know if you have a preference weapon display as noted in the above listed Feedback.
Thanks.
Next Revision:
- I now have to continue my overhaul with the spells area. I am hoping to have this done in about 1 week.
This character generator is a life saver. Thanks so much!
BUG: You have level 5 summon spells listed as IX, should be V. The higher level ones that follow are also wrong. Quick fix though.
I have found that when you are looking at equipping general equipment, after you have selected the item type (in cell F6 for example), when you actually try to select the specific item, the drop down list that should appear in cell G6 under 'item name' is absent.
I have now tested this with all 8 types of general equipment and I have not encountered any error. Each different type does bring up the correct respective list.
Has anyone else noticed this problem?
You are unable to enter a caster level for scrolls (cell BY6 for example). Is this an oversight or deliberate? Likewise, you cannot enter a caster level for wands.
Ack! This is due to some column moves I did on the spells sheet. Scrolls/Wands are sort of broken now. I also notice that when selecting a "class" for a scroll, that it is not showing spells only for that particular class. I have now fixed all this and it will be in the next revision.
You can only select 10 charges for a staff and 50 charges for a wand. Is this too deliberate?I just have "50" as a quick toggle. You can type in any amount of charges in though. Sometimes clicking is quicker than typing though, so I will likely add a full list of all 50 numbers to pick from, descending from 50.
Re feedback on weapons display - I would like to scrap the new style page three and have a second page three appear, should you take more than six weapons.
Thanks for the feedback on this.
This character generator is a life saver. Thanks so much!
BUG: You have level 5 summon spells listed as IX, should be V. The higher level ones that follow are also wrong. Quick fix though.
Thanks for noticing this. The same problem existed for Summon Nature's Ally too.
Side Note: the SpellsList page it not working completely error free right now, however I am completely rebuilding it so it will be fixed.
Kor
I must be missing something, but I cannot seem to select ANY individual items of equipment in the General Equipment section? I can select the eight sub- categories, but the next drop down box ( under item name) is always empty.
What am I doing wrong?
Cheers
Alan
Weird.
Lets try diagnosing that. Firstly, what version of Excel are you using?
Kor
I must be missing something, but I cannot seem to select ANY individual items of equipment in the General Equipment section? I can select the eight sub- categories, but the next drop down box ( under item name) is always empty.
What am I doing wrong?
Cheers
Alan
Actually, here's an experiment I would like you to try please:
Unprotect the Items Sheet
Display Column & Row Headings
Unhide Column EF
Change the formulas in EF as follows:
=IF(F6=0,"",VLOOKUP(F6,table_itemsDATA2_type,2,0))
to
=IF(F6="","",VLOOKUP(F6,table_itemsDATA2_type,2,0))
(Basically replace the 0 with "" )
Copy and paste fhat from EF6 all the way down to EF53.
Then see if that changes. Although this works fine to for me, I do recall there being some "read blanks as zeros" option or something like that which can be set in Excel. If this is the case, then I will have to be more diligent in ensuring whether my target field should be a value of 0 or ""
Alan, I'm fairly positive the above will fix the problem you are experiencing, since all my other reference columns for Items look for "", instead of 0.
Kor
I am using excel2007.
I have found the issue.
When looking at cell G6 on the Items tab, using Data Validation, the source is listed as =INDIRECT(XAN6). If you change this to =INDIRECT(EF6) everything works fine.
This error is appearing all the cells in column G in this section.
Cheers
Alan
There is stil something odd about this though, as when I look at the source, it is =INDIRECT(EF6) and not =INDIRECT(XAN6). I'm not sure at all why that would be showing up like that.
Kor
I grabbed another copy of the sheet straight from your website and it still has the bum reference on it.
I found the error, but I am completely stumped as to why it is occuring.
This happens only on the .xlsx sheet.
To ensure total compatability I work with a .xls sheet. When I am ready to upload it, then I save a copy as a .xlsx sheet. The .xls sheet still shows the proper reference, however the .xlsx sheet for some reason changes the reference. I have no idea why it does this, or even it if is doing it to other references.
I'm going to post on Mr Excel to see if anyone has ever seen such a thing. I will also try to lock the column reference with a $ in the INDIRECT to see if that stops its from happening.
EDIT:
I just tested it after locking the column with $, and it works good now. It will be fixed on the next version. Thanks for your help in identifying this problem. I'll have to go through all the columns now to make sure they are all "locked down".
Ok so you work on xls, then save an xlsx version from that.
So would you suggest that we rather download the xls version then if we work with Excel 2007?
There won't be any different features in the xlsx file right?
Tried it (the current 0.75 version xlsm) out today - very nice stuff!
Some bugs:
Animal companion:
- Tried to enter a bear (small) as animal companion:
- Hitpoints (2HD): should receive CON-Bonus per HitDie, currently gets only 1 time bonus (+1 instead of +2)
- The bear does not get its DEX-Bonus to AC (has AC 13, should get: 10+1(size)+2(Dex)+2 Natural Armor = AC 15)
Found no bugs with my Druid, only with the companion.
Ok so you work on xls, then save an xlsx version from that.
So would you suggest that we rather download the xls version then if we work with Excel 2007?
There won't be any different features in the xlsx file right?
In theory, the .xlsx should be fine. (Hopefully this odd Excel bug has not manifested itself elsewhere.) Only because of this bug though, the .xls would probably be more reliable. Both files are exactly the same.
Tried it (the current 0.75 version xlsm) out today - very nice stuff!
Some bugs:
Animal companion:
- Tried to enter a bear (small) as animal companion:
- Hitpoints (2HD): should receive CON-Bonus per HitDie, currently gets only 1 time bonus (+1 instead of +2)
- The bear does not get its DEX-Bonus to AC (has AC 13, should get: 10+1(size)+2(Dex)+2 Natural Armor = AC 15)Found no bugs with my Druid, only with the companion.
Thanks for reporting these problems.
I have now added an additional line for 1st HD. Although animals start at 2 HD, I thought someone could potentially forget to enter the doubled amount of HP for the first HP entry. (Just as I forgot to double the Con bonus for the 2nd HD to account for not listing the 1st HD).
I had an error with checking for Dex mod reduction for armor. I have now fixed that.
Thanks again.
Kor
My first level sorcerer having the third level bloodline bonus spells show up on his spell list and I cannot fathom why.
Cheers
Alan
I noticed this too yesterday while revamping the SpellList sheet. It will be fixed on the new SpellList sheet. I'm hoping to have it out by Friday. This revision will also include the ability to print off a spell list which will list all your memorized/known spells along with all the essential spell info (components, duration, range, etc)
Kor
My first level wizard is not proficient with unarmed strikes, rays, and both kinds of touch attack. I thought all characters were proficient with these by default?
Adding them to cell Bg18 on the classes_DATA tab would solve this.
By the way the sheet has worked very well for my group, turning character creation into a breeze.
Cheers
Alan
Thanks for catching that. I have now added those in for all classes that don't get Simple Weapon proficiency.
I'm happy to hear the sheet it working well for your group. I'm looking forward to using it when I start DM'ing later this year... making npc's might actually be fun now :)
Kor
I was doing more messing around with a 1st level Wizard and have come up with a work around for the Hand of the Apprentice special ability.
Thanks for mentioning this. I remember DM'ing a campaign where the wizard use this several times each session, and indeed would warrant inclusion on the weapons display.
I think I'm going to add it in as a Wielded type, since it seems right in place with other special attack types like, Flurry of Blows.
I have tried this on several different builds/options but I am unable to make any selection for the Magical Talent Trait. Traits is selected and I am using the correct number of traits.
I found some bugs.
On Tab Page2 Power Attack reads "Primal" when it should read "Primary", if the Power Attack feat is selected.
On Tab Page2 Armor Training seems to have a formatting error that causes the words "For any armor worn" on the next line when it should be on the same, when a fighter has enough levels to have have the Armor Training class feature.
The armor check penitently for fighters with both Armor Training wearing master work armor seems to be one too high.
On tab Page1 the bonus from Weapon Training to CMD vs. certain types of weapons doe not show on page one, Combat Notes section; when a fighter is high enough level to have Weapon Training.
On tab Page1 the bonus from Weapon Training to CMB with certain weapon types does not show on page one, Combat Notes section; when a fighter is high enough level to have Weapon Training.
On the tab Arms Two Bladed Swords don't get the proper bonus for a fighter who selects Double Weapons as his Weapons training, only if they select Heavy Blades; when a fighter is high enough level to have Weapon Training.
On the tab Items the cost for the second head of a weapon doesn't seem to add to the unit cost.
On the Levels Tab the word "Favored Class" is formatted in such a ways as to cut off the 2nd "s".
On Custom Magic Items with the hands slot the GP number is reflected, not the weight slot number, on the Worn Magic Items on tab Page4(a).
On the tab "Languages" Druidic can be selected by non Druids if they spend skill point(s) in the Linguistics skill, without any override.
Type Reads "Humanoid" instead of "Humanoid (Human)" on Tab Page1; if the race selected is Human.
On Tab Page2 feat when selected the feat Improved Two Weapon Fighting reads "gain a third attack with your off hand..."; this could be counted as a 2nd attack with your off hand or a forth attack for the round (since you do have to have BAB 6) to take the feat. I don't see anyway it can count as a third attack.
I have some questions.
Is there a reason that a weapon can't have more then 3 special abilities?
Is there a reason that there is no place to see a normal mount's stats?
The following is just my two cents and I understand you might have bigger fish to fry.
I'd love a way to type in notes on the Various Combat Notes and Skill Notes sections, just a simple blank open cell as the bottom half.
I think it would be great if there was a custom bonus option for Weapon Training, Bravery, and Armor Training.
You could stream line a bit my making the rings into two separate slots - right ring and left ring.
EDIT = fixed typo.
Kor
I think I have found the bug concerning Armour proficiency (light)
Should cell AE112 on the Attributes DATA Tab have Armour proficiency light in it.
Thanks for finding that... it saved me from spending a lot of time trying to figure it out :)
Having a bit of trouble seemingly with the 75cy version with regard to the spell lists. I know you are working on changing the way all of it works, but thought I would let you know.
The DC on the spell list page, when I create a 5th level druid, comes up with #VALUE and the same with the summary page. Standard build of a Druid. Human, high wisdom, took the Druid Domain and Augment summoning and Spell focus conjuration.
Seems to be a problem with cleric and I think wizard as well. Didn't test all the spell casting classes.
Small thing perhaphs:
- Item Tab->General Equipment->After choosing Item Type, the Item Dropdown doesn't display anything, hence you can't select the items.
- There is a trait (Sacred ...?!) that should add +1 to the DC of Clerics Channel power (damaging undead), this Bonus isn't added yet (or at least not displayed on Page 2 that lists the abilities).
Having a bit of trouble seemingly with the 75cy version with regard to the spell lists. I know you are working on changing the way all of it works, but thought I would let you know.
The DC on the spell list page, when I create a 5th level druid, comes up with #VALUE and the same with the summary page. Standard build of a Druid. Human, high wisdom, took the Druid Domain and Augment summoning and Spell focus conjuration.
Seems to be a problem with cleric and I think wizard as well. Didn't test all the spell casting classes.
Yes, the spells are getting a complete overhaul. I found a few other errors as well, but so far my new sheet is working 100% solid with all classes and has metamagic selections working properly now.
Thanks for letting me know though.
Small thing perhaphs:
- Item Tab->General Equipment->After choosing Item Type, the Item Dropdown doesn't display anything, hence you can't select the items.
- There is a trait (Sacred ...?!) that should add +1 to the DC of Clerics Channel power (damaging undead), this Bonus isn't added yet (or at least not displayed on Page 2 that lists the abilities).
The Item Tab was identified by someone a few days ago and I have fixed it now. (I know... its been a long time for an update :)
I have fixed the Sacred Conduit trait now.
Thanks for letting me know about these errors.
I have tried this on several different builds/options but I am unable to make any selection for the Magical Talent Trait. Traits is selected and I am using the correct number of traits.
Thanks for reporting this.
I have fixed for the next update now.
I found some bugs.
I'll say you did! Thanks for reporting them all.
On Tab Page2 Armor Training seems to have a formatting error that causes the words "For any armor worn" on the next line when it should be on the same, when a fighter has enough levels to have have the Armor Training class feature.
I checked this and there isn't anything specific wrong that I can find in the text. Due to how excel works, the formatting of the Page 2 will appear differently for everyone depending on what printer they use.
The armor check penitently for fighters with both Armor Training wearing master work armor seems to be one too high.
I'll test this some more, but I haven't found a problem on my initial tests.
On tab Page1 the bonus from Weapon Training to CMD vs. certain types of weapons doe not show on page one, Combat Notes section; when a fighter is high enough level to have Weapon Training.
Thanks, I completely forgot about this.
On the tab Arms Two Bladed Swords don't get the proper bonus for a fighter who selects Double Weapons as his Weapons training, only if they select Heavy Blades; when a fighter is high enough level to have Weapon Training.
It is working correctly on my current version. I have done so many fixes already though, maybe this was one of them. If you still notice issues with this after the next release, please let me know.
On the tab Items the cost for the second head of a weapon doesn't seem to add to the unit cost.
Similar to the above, it is working for me, but maybe I fixed it already.
On the Levels Tab the word "Favored Class" is formatted in such a ways as to cut off the 2nd "s".
This is another one of those Excel annoyances where it depends on your computer resolution and your zoom level. I could fix it, but when I add in APG content, I am moving favored class to level selection fields.
On Custom Magic Items with the hands slot the GP number is reflected, not the weight slot number, on the Worn Magic Items on tab Page4(a).
Thanks for noticing this. I also noticed that the gp amount for worn custom items is not tallying.
Type Reads "Humanoid" instead of "Humanoid (Human)" on Tab Page1; if the race selected is Human.
I did this on purpose for all Humanoids as I felt it was repetitive to have their sub-type showing when it matched their race. However, I have now changed my mind and am showing the full descriptors as you have indicated.
On Tab Page2 feat when selected the feat Improved Two Weapon Fighting reads "gain a third attack with your off hand..."; this could be counted as a 2nd attack with your off hand or a forth attack for the round (since you do have to have BAB 6) to take the feat. I don't see anyway it can count as a third attack.
Thanks for catching the typo... it should reference only "second".
Is there a reason that a weapon can't have more then 3 special abilities?
Throughout the sheet I have had to make certain compromises, while trying to allow for the most possible options. I decided that 3 would be a good amount, as I have rarely seen more than that. (But I don't play in a lot of high level campaigns.) In the future I could look into expanding it.
Is there a reason that there is no place to see a normal mount's stats?
Currently there is no real "good" place to put them. Plus it would take a lot more work to generate all of that. (Although I can use the animal companion as the framework). Something that just occurred to me now though, is that I could just have one big area where Familias and Animal Companions are listed. If I combine all of that into a single display area, then I would probably be able to list several combinations of animals/animal companions and familiars.
I'd love a way to type in notes on the Various Combat Notes and Skill Notes sections, just a simple blank open cell as the bottom half.
This option exists on the Custom / Notes page.
I think it would be great if there was a custom bonus option for Weapon Training, Bravery, and Armor Training.
Me too :) Eventually, I want to do this with pretty much every class ability. I do plan to do this in the distant future as I take on allowing more options for customized classes. (Right now, customized classes are really not all that functional).
You could stream line a bit my making the rings into two separate slots - right ring and left ring.
If you mean, by making two selections for rings such as:
Should Items
Feet Items
Left Ring
Right Ring
I had thought about doing that too, but the problem is, is that then you are carrying two seperate inventories for rings. It is much easier to just have 1 inventory pool for rings, and allow people to assign a hand to the rings. The down side of course for this, is that I had to default all items to "No" for worn status to accomidate the different selections of "left" and "right" for the rings.
*------------------------------------*
====== Status Update =======
*------------------------------------*
I've completed rebuilding the spell list selection page and am now continuing work on my spell list generator. I should likely be done in about 3 days.
Sorry for the delay on the revision, but I really had to tear the sheet apart and have only put it back into working order today.
I really like my printed spell list format so far and I don't think there is anything else out there that matches what I have done.
Even including Herolabs. Which brings me to a side note... and more of a rambling at that. After buying my copy of Herolabs at Gencon, I thought, hey if this is so good maybe I can get some of my life back and cancel the Ogre Sheet.
Well, I have learnt how to use Herolabs pretty well now. I have a LOT of critisms now against Herolabs. There is so much that needs to be done to clean it up and make it fully user friendly that I would have to spend a week writing it all out to submit it to them. (I was going to do that anyways, but then that's a week of time not being spent on this sheet). Character generation I find is somewhat slow as well... It takes me 3 times as long. But I guess it was only $30, but to have Paizo's backing on it, I expected so much more.
Don't get me wrong, a LOT of time has gone into it and at the end of the day it produces an average result... maybe bordering on above average... but not quite. I just know that if I had the programming capabilities that such a program has (in which you have so few limitations) then the sky is pretty much the limit -- and it feels like to me that they are barely off the ground.
Oh well, that's just my general orcish rambling of the day. I respect the time they have put into it, so I don't feel right critiquing the product in their forums, so I just thought I'd bury my little rant here in this thread :)
(Well, also when I showed up at their booth at GenCon, they really didn't seem too interested in hearing my plethora ideas and immediately discounted several. Although, I only had 4 hours sleep from the night before and they probably thought I was some raving, rambling lunatic... much like this post is starting sound as well :)
I checked this and there isn't anything specific wrong that I can find in the text. Due to how excel works, the formatting of the Page 2 will appear differently for everyone depending on what printer they use.
Okay, it looked like it was set to have the number on a line all by itself regardless of everything else I'll recheck.
The armor check penitently for fighters with both Armor Training wearing master work armor seems to be one too high.
By Armor check penitently I meant max dexterity bonus. Sorry I guess I rolled one in real life there. What I am having is fighters who have Armor training while wearing master work armor seem to get the best of the two when from my understanding they should stack.
On the tab Arms Two Bladed Swords don't get the proper bonus for a fighter who selects Double Weapons as his Weapons training, only if they select Heavy Blades; when a fighter is high enough level to have Weapon Training.
On the tab Items the cost for the second head of a weapon doesn't seem to add to the unit cost.
I'll test this some more, but I haven't found a problem on my initial tests.
It is working correctly on my current version. I have done so many fixes already though, maybe this was one of them. If you still notice issues with this after the next release, please let me know.
I just recheck the Two Bladed Sword with Double Weapons issue and it was still there, I'll recheck next version. Same for the second head issues.
I noticed a few other bugs/issues.
It is possible to put skill ranks into Profession General, Craft General, and Preform General. Since you can't really put ranks into them that seems like a bug. Also why aren't they just called untrained?
Once Hand of Glory is selected there is now way/place to select the third (usable) ring.
By Armor check penitently I meant max dexterity bonus. Sorry I guess I rolled one in real life there. What I am having is fighters who have Armor training while wearing master work armor seem to get the best of the two when from my understanding they should stack.
Strike that part.
I noticed a few other bugs/issues.
It is possible to put skill ranks into Profession General, Craft General, and Preform General. Since you can't really put ranks into them that seems like a bug. Also why aren't they just called untrained?
Once Hand of Glory is selected there is now way/place to select the third (usable) ring.
Thanks for the skill group ideas. I have now changed these to be worded as (untrained) and they will no longer show rank entry boxes.
The Hand of Glory is a tricky one. It requires quite a bit of a work around for a singe item. I may likely attempt a solution for this in the future, but there are no immediate plans for this.
*curse those dang items that have to always be an exception to the normal rules!*
Another rather small thing:
- Animal Sheet: "Improved Natural Attack" seems to increase the dice by 2 steps (e.g. from 1d4 to 1d8 or from 1d6 to 2d6). I checked it with Bite and Clas.
- Page 1: Skill notes: My human druid displays a "-4 racial bonus on acrobatic jump checks"? where does this originate from?!
Thanks for the skill group ideas. I have now changed these to be worded as (untrained) and they will no longer show rank entry boxes.
The Hand of Glory is a tricky one. It requires quite a bit of a work around for a singe item. I may likely attempt a solution for this in the future, but there are no immediate plans for this.
*curse those dang items that have to always be an exception to the normal rules!*
Glad to help, it's my favorite character sheet.
With Hand of Glory you could have multiple versions on the neck drop down as you do now with the Amulets of Natural Armor; one for each standard ring, one with no ring, and with a custom ring each as separate options on the neck slot, even including wight and cost. The custom ring would be using the values from the custom slot.
And cursed items are already a type of exception to normal rules.
- Page 1: Skill notes: My human druid displays a "-4 racial bonus on acrobatic jump checks"? where does this originate from?!
Is there speed reduced to 20 feet for some reason? If so that's why they have it lowered (and it is correct).
Another rather small thing:
- Animal Sheet: "Improved Natural Attack" seems to increase the dice by 2 steps (e.g. from 1d4 to 1d8 or from 1d6 to 2d6). I checked it with Bite and Clas.
- Page 1: Skill notes: My human druid displays a "-4 racial bonus on acrobatic jump checks"? where does this originate from?!
Animal Sheet - Thanks for catching that. I have it fixed now for the next update.
Skill Notes - As dunelord has mentioned, I suspect you have something that affecting your weight and giving you a speed of 20'. I'm guessing you are wearing Hide Armor?
damn it, you're right concerning the -4 because of the hide armor. If i remember correctly (I dont have the sheet at hand) it does display a "-4 RACIAL bonus", that was it what made it somehow mysterious. Perhaps this should be corrected.
500th!
It's just like saying first only 500 times better!