The latest version (Alpha 0.18) is out. The sheet appears to be working well at this time. I had to do quite a few fixes to bloodlines. The Dragon Disciple PrC "should" now be fully functional. This PrC was a good exercise for me as it can either enhance an existing draconic bloodline, or it essentially gives you a second bloodline. I have run a few tests with this PrC and everything appears to be running properly.
On the plus side the remaining PrC's should be a lot easier/quicker to add in.
All previously identified errors should have been fixed now. As usual, please let me know of any problems you encounter.
Thanks.
Darn, I already found a few minor tweaks needed. (i.e. Flat foot AC does not subtract Dodge bonus). Touch AC calcs are also wrong. I will fix this tomorrow.
Version Alpha 0.19 is now out, fixing some of the small errors I found.
http://www.pathfinderportal.com/ogresheet.html
Version Alpha 0.19 is now out, fixing some of the small errors I found.
Well it seems that I have come to a major roadblock right now. I have a weird type of circular error, that's very hard to diagnose. It seems to only be related to calculations based on Charisma modifiers (such as some cleric and paladin abilities).
This is going to be a couple days delay I think, as I thought I had circumvented it in the past... but I have not. I have over 10 hours type put into trying to resolve this. I am now hoping that some expert at Mr. Excel can help me, because otherwise I'm at a dead stop. (Well, I can non-automate certain abilities, but that sort of defeats the purpose of the sheet.)
One more error regarding the weight of weapons and armor. Your table_armorDATA_weight table on the armor_data worksheet reflects the modifiers to the cost of the armor, not the weight. This also means there is no need to differentiate between humanoid and non humanoid, because the weight modifiers are the same for both.
Otherwise this is a very nifty excel sheet. I love the thoroughness and the intricacy of the code.
Kudos.
Thank you for finding this error and taking the time to look over the sheet. I'll have that fixed on the next release.
Just noticed something, minor error in enhancement bonuses. +2 to dex was also added to strength. other than that running fairly smooth, Doing a Great Job!
Thanks for noticing this. It looks like I forgot to make a change after a copy & paste. It will be fixed on the release that should be coming out tonight.
The latest version is out (Alpha v.20).
Many behind the scenes fixes on this one, and the completion of all the Prestige Classes.
Please give it a run and let me know if everything is working good. There were a couple of processes that I had to re-design, but I'm fairly certain I have eliminated my "dread circular error" problem.
With the PrC's finished now, and with the Holidays approaching, I may not introduce much new content. I will be focusing on just doing fixes until the new year, but with the help of all of you, I think almost everything that needed to be fixed has been identified.
Another small error. Right now Paladin Divine Grace is active even when the character is not a lvl 2 Paladin.
On my sheet I fixed this by changing Classes_DATA2!L272 to =IF(Attributes_DATA!I301="yes",IF(cell_chamod>0,cell_chamod,0),0).
Again, following the bouncing ball through the excel sheets, I am in awe of the work that went into this. Thank you. It makes character creation a snap.
Thanks for finding this. This was one of the changes I had to do to get around a circular error, and I forgot to link it back to class level. Its fixed now, and Alpha v0.21 is now available for download.
http://www.pathfinderportal.com/ogresheet.html
I never really thought the sheet would take as long as it did to create and develop. Ever since using Heroforge, I thought there had to be an easier and quicker way to implement character creation. I always wanted to try this approach with d20, but the plethora of d20 resources out made the task a daunting and ominous one. This offered me a chance to reasonably keep pace with Paizo, so I jumped on it.
New release - Alpha v0.22
A few more fixes, particularly to barbarians and monks.
Been working with the spreadsheet for the last hour or two, recreating my PFS Rogue 11. I am loving the input scheme, particularly the feats page. I will have to adjust a bit to the different character sheet style (if I could start a wish list, it would be for a traditional character sheet option). I found a few things to mention though -
- I couldn't find the minor magic, major magic, and dispelling attack (advanced) Rogue talents.
- Adding a +5 Competence bonus to Perception on the bonuses tab results in it appearing as both a +5 magic bonus and a +5 misc bonus on the skills tab.
- I couldn't find where to specify that I was using a composite bow, but I was able to add the extra damage.
- On the arms tab, wielded is spelled wrong. It was also awkward in how primary and off-hand weapons were chosen for two weapon fighting, but that could be me. I wasn't sure how to denote the off-hand weapon, but choosing both as "primary - light off-hand" resulted in the correct calculations.
- I have Uncanny Dodge, but this isn't being taken into account for flat footed AC.
- I added magic items bonuses on the bonus tab. Would have preferred specific item choices so they showed up on the equipment list on pg 3 (unless I missed something), so I guess that's a wish list item.
For reference, I am using Excel 2003 on Windows Vista.
Great job!!!
Whoops! I broke the sheet in a big way. I will have a fix out soon.
Been working with the spreadsheet for the last hour or two, recreating my PFS Rogue 11. I am loving the input scheme, particularly the feats page. I will have to adjust a bit to the different character sheet style (if I could start a wish list, it would be for a traditional character sheet option). I found a few things to mention though -
- I couldn't find the minor magic, major magic, and dispelling attack (advanced) Rogue talents.
That was due to a minor error I made just before the release. It will be fixed on the next release later tonight.
- Adding a +5 Competence bonus to Perception on the bonuses tab results in it appearing as both a +5 magic bonus and a +5 misc bonus on the skills tab.
Okay, found this now and fixed it.
- I couldn't find where to specify that I was using a composite bow, but I was able to add the extra damage.
For any feat, like weapon focus or weapon specialization, you only need to select either shortbow or longbow. Either of those will give you the same benefits with a composite bow (which was recently a rule that I learned, which was even in 3.5).
- On the arms tab, wielded is spelled wrong.
I remember noticing that in the past too, but forgot to change it. All fixed now.
- I have Uncanny Dodge, but this isn't being taken into account for flat footed AC.
I haven't yet decided how best to record this, since it is sort of a situational benefit (its not gained when immobilized). I will either add it into the flat-footed calculations and then add a note in the defense note section, or I will not change the flat-footed total, and just note that a +Dex bonus when flat-footed in the skill notes. I will make a choice on the next revision.
- I added magic items bonuses on the bonus tab. Would have preferred specific item choices so they showed up on the equipment list on pg 3 (unless I missed something), so I guess that's a wish list item.
Yes, I will be working on an item selection page.
It was also awkward in how primary and off-hand weapons were chosen for two weapon fighting, but that could be me. I wasn't sure how to denote the off-hand weapon, but choosing both as "primary - light off-hand" resulted in the correct calculations.
Yes, I have even confused myself with that too. I have to keep the description short though so I am sort of limited with what can be displayed. "Two weapons (primary - light off hand)", means that the weapon you are selected is in your primary hand, and that your off-hand weapon is light. Your secondary hand weapon would then be selected as "Two-weapons (off-hand)". I will have to revisit these titles at some point though, as I agree that they are a little confusing.
Thanks a lot for testing this out and posting the errors. In about 1 hour you should be able to rebuild your rogue error free :) *crosses fingers*
I will have to adjust a bit to the different character sheet style (if I could start a wish list, it would be for a traditional character sheet option).
It is something that I may consider in the future, and I have built a character sheet data page that will make it easy for me to do. I originally was trying to format this on a portrait/vertical layout, and I struggled to get everything looking right. Although it took me awhile to convert my preference from portrait to landscape, my preference did indeed change. I also find that when space is crowded on a gaming table its easier to manage a landscape formatted sheet. And it doubles as a place-mat when eating at the table :)
Creating a vertical layout will likely happen sometime in the future, but it will be awhile.
- I have Uncanny Dodge, but this isn't being taken into account for flat footed AC.I haven't yet decided how best to record this, since it is sort of a situational benefit (its not gained when immobilized). I will either add it into the flat-footed calculations and then add a note in the defense note section, or I will not change the flat-footed total, and just note that a +Dex bonus when flat-footed in the skill notes. I will make a choice on the next revision.
Actually, it occurred to me that any imobilizing condition like helpless or paralyzed negates dex bonuses, so as long as I show it as a dex bonus under the Flat-Footed totals, all should be good, and I shouldn't even need to make a special defense note about it. Thanks for helping me make up my mind :)
I continue to look forward to each update for this completely fantastic excel Pathfinder PC generator. In your next update could you please add the two following areas for Elves: Celwynvian and Mordant Spire. As an aside, could you also add those options to the Sub-Race section? The options could be Celwynvian, Mordant, Kyonian, and Forlorn (this one could cover those elves who grew up in other areas like Varisia). Great job!
Okay is it just me or is the entire "Arms" sheet missing in this update?
Okay is it just me or is the entire "Arms" sheet missing in this update?
<laughs> Yeah, it sure is!
Okay is it just me or is the entire "Arms" sheet missing in this update?
Whoops, I accidentally hid the Arms sheet.
I continue to look forward to each update for this completely fantastic excel Pathfinder PC generator. In your next update could you please add the two following areas for Elves: Celwynvian and Mordant Spire. As an aside, could you also add those options to the Sub-Race section? The options could be Celwynvian, Mordant, Kyonian, and Forlorn (this one could cover those elves who grew up in other areas like Varisia). Great job!
Sure thing. I have some other Pathfinder 3.5 material that is in the spreadsheet that I should activate, such as the elven deities. The only downside is that Findeladlara clerics loose on 1 domain, since PFRPG doesn't have the Creation domain.
I continue to look forward to each update for this completely fantastic excel Pathfinder PC generator. In your next update could you please add the two following areas for Elves: Celwynvian and Mordant Spire. As an aside, could you also add those options to the Sub-Race section? The options could be Celwynvian, Mordant, Kyonian, and Forlorn (this one could cover those elves who grew up in other areas like Varisia). Great job!Sure thing. I have some other Pathfinder 3.5 material that is in the spreadsheet that I should activate, such as the elven deities. The only downside is that Findeladlara clerics loose on 1 domain, since PFRPG doesn't have the Creation domain.
Just curious, but do you have the PFCS book to draw from or no? If so, why don't you just use that?
Just curious, but do you have the PFCS book to draw from or no? If so, why don't you just use that?I continue to look forward to each update for this completely fantastic excel Pathfinder PC generator. In your next update could you please add the two following areas for Elves: Celwynvian and Mordant Spire. As an aside, could you also add those options to the Sub-Race section? The options could be Celwynvian, Mordant, Kyonian, and Forlorn (this one could cover those elves who grew up in other areas like Varisia). Great job!Sure thing. I have some other Pathfinder 3.5 material that is in the spreadsheet that I should activate, such as the elven deities. The only downside is that Findeladlara clerics loose on 1 domain, since PFRPG doesn't have the Creation domain.
Yes, I do have that. I have some of that material in the sheet as well, although most of it is not activated right now.
New release - Alpha v0.24
A little bit more added content.
That's awesome to hear. Definitely looking forward to the shop in the future. Just wanted to let you know, I was tinkering with creating an Kyonian Elf Ranger and on Page 2 under "Racial Traits" it says the following for Weapon Familiarity: Gain familiarity in battle axes, heavy picks, and warhammers. "Dwarven" weapons are treated as martial weapons.
That's awesome to hear. Definitely looking forward to the shop in the future. Just wanted to let you know, I was tinkering with creating an Kyonian Elf Ranger and on Page 2 under "Racial Traits" it says the following for Weapon Familiarity: Gain familiarity in battle axes, heavy picks, and warhammers. "Dwarven" weapons are treated as martial weapons.
Page 2 of which resource? I thought you might be referring to the Elves of Golarion, but it doesn't appear in it.
That's awesome to hear. Definitely looking forward to the shop in the future. Just wanted to let you know, I was tinkering with creating an Kyonian Elf Ranger and on Page 2 under "Racial Traits" it says the following for Weapon Familiarity: Gain familiarity in battle axes, heavy picks, and warhammers. "Dwarven" weapons are treated as martial weapons.Page 2 of which resource? I thought you might be referring to the Elves of Golarion, but it doesn't appear in it.
The tab on your excel sheet labeled Page 2. Sorry I wasn't clearer.
The tab on your excel sheet labeled Page 2. Sorry I wasn't clearer.That's awesome to hear. Definitely looking forward to the shop in the future. Just wanted to let you know, I was tinkering with creating an Kyonian Elf Ranger and on Page 2 under "Racial Traits" it says the following for Weapon Familiarity: Gain familiarity in battle axes, heavy picks, and warhammers. "Dwarven" weapons are treated as martial weapons.Page 2 of which resource? I thought you might be referring to the Elves of Golarion, but it doesn't appear in it.
Thanks for mentioning this. I had some duplicate named racial abilities. All fixed now. (I was congnizant to not do that with class abilities, but somehow the races slipped my mind.)
Something I just noticed myself. Pathfinder changed the armor class values of the different armors. The char sheet still has the old d20 values.
http://www.d20pfsrd.com/equipment---final/armor
Plate Armor for example gives you 9 armor class.
Thanks, I have adjusted them. I was also going to adjust the values for the Campaign Setting's, Stoneplate and Field plate armors each by 1, but then I really don't want to alter any print material, unless there is an official change made.
!Domains_DATA$D140 should read "Travel Domain Power" instead of "Travel Domain", otherwise you get N/A errors all over the sheet if you select Travel Domain as a Cleric.
Are there any plans to automate animal companion stats?
Thanks for noticing that.
I do plan to automate animal companion and familiar stats in the future.
And I think !Domains_DATA$V128 should probably read "=ROUNDDOWN(J128/5,0)+1" I think the J column reflects the Cleric Level.
I'm trying to figure out how to get the Travel Domain power of extra base speed to show up on my character sheet too. Will this require an extra column on the Bonuses_DATA sheet?
Hrmm... yes I think its best that I use the character's level (in J) to calculate that instead of the page number :)
Until I release the revision, there are 2 ways to bring in the extra speed.
#1
On DomainsDATA worksheet, in cell U140. Change addMOVEGROUND to LANDbase
#2
On the Bonuses tab, select under ==Movement (base), Ground Speed (base)
More stuff:
I noticed the Barbarian rage powers at level 2 weren't all represented.
My nephew wanted Scent and it wasn't on the drop down list.I fixed this by going to the Classes_Data2 sheet and copying E43 and F43 to all cells down to E70 and F70.
I'm getting to know the workbook a little better, and again, I'm amazed at how much work went into this.
Copying that down could potentially be problematic since some of the formulas (which appear in purple squares) are cell specific. These are mainly checking for pre-requisites or rage powers that can be selected multiple times. There are several that are missing the formulas though, so I will fix them.
The only other problem I have encountered with both rage powers and rogue talents, is that if you make a high level character, all of the available rage powers / rogue talents are available for selection. (i.e. If you make a 15th level barbarian, you will be able to select an 8th level rage power, before level 8, because the check that it performs is based on your current barbarian level (which is 15).
The way to eliminate this concern, is to advance each level 1 at a time. (Go to the CLASSES page, select your first level, then go to the LEVELS page and make your selections, then continue doing this for each level.) Sadly this approach is a little tedious, but I'm unsure if there is anyway to get around this, using my level advancement system.
I really like the simplicity of your sheet. Any plans of adding a box for a character illustration?
What if you keep track of the number of rage/rogue powers already selected. You could make that a prerequisite of the higher level rage/rogue powers. After all, we know exactly how many powers a barbarian is supposed to have at a certain level.
I should be able to do this. (I think when I tried it once, I ran into a circular error, but I believe I have a way around that now). Thanks.
I really like the simplicity of your sheet. Any plans of adding a box for a character illustration?
Thanks.
I really wish I could find some room for a character illustration box, and even a "spell effects" box for players to write down any current in-game spell effects on their character. Sadly, I have completely maximized the space on all the sheets. I would also really like to have a bigger notes section on all of the note areas (combat/saves/defenses/skills). One of my plans (albeit in the distant future) is to make a hybrid sheet that is sort of like a stat block (which I plan to have too), but will appear more like the iconic character summaries that appear in the back of the Pathfinder Adventure Paths. This will definitely have a box for a character illustration.
Missing the ironwood special material for metal armor, jut a side note really but easier if its included.
That's a good note. Its too bad the rulebook doesn't allot any kind of market value to ironwood, but I will include it as an option. I also noticed that I limited the Special Material box for shields to only the drop down list, where-as it should allow for the user to put in any name they want, like in armor.
Great sheet - truly humbled by the amount of work in it.
Question though - and for the record I'm using the latest release of OpenOffice 3.1 on Windows Vista with all relevant updates.
I'm building a level 1 fighter. Human.
I put in all the pertinent information on the stats page.
Base Ability Scores, Age, Height, Sex, Race, Favored Class, etc.I go to the Classes section and fill in my first level, choose how the hit points are done, and pick my favored class bonus.
All of this works fine to this point.
I go to levels and try picking my feats. The human +2 to str shows up fine on the stats page. But when I try to choose something like Weapon Focus - I get Err:502 as the only selection in the Feature Selection drop downs.
I also try picking Power Attack instead. I can't choose Cleave after I do this as well. It may be an issue with OO but I don't know.
One other not - none of the clear sheets buttons work. I always get an error when I click them indicating the function doesn't exist.
I'm not familiar with OpenOffice at all, but it does not appear that OpenOffice supports macros / visual basic code. That is why the buttons and some other functions do not work.
I believe someone else also tried using OpenOffice and found these similar problems.
I tried to save the sheet in an OpenDocument Spreadsheet format (I don't know if that is the same as OpenOffice), but again all the macros were lost.
As far as I know, this sheet is only usable with most any version of Microsoft Excel. I have specifically avoided using a lot of the nifty new Excel features, to ensure backward compatibility to much older versions of Excel.
Thanks for mentioning this though, at least I know fairly certainly now, that it is not OO compatible. Unfortunately there is not anything I can do to make it OO compatible either because of how the sheet is set up -- which sadly prevents a lot of people from using it.
New release - Alpha v0.26
Some more various fixes. I accidentally left the Hellknight listed as a PrC, which I have not really started on yet -- so it won't be functional when you select it. (Well, level 1 might be).
All the errors noted in this thread since last patch should be fixed, as well as some fixes with Composite bows and the addition of override att/dmg totals on the Arms sheet.
I am currently working on the Items worksheets, and these are taking some time.
Hey Kor, if you want to point the OO folks my way, I've started pointing the macro folks your way (I had a request for a "clear the sheet" button, which I can't do since I'm avoiding VBA/macros in order to maintain OO and Mac/Linux compatibility).
Hey Kor, if you want to point the OO folks my way, I've started pointing the macro folks your way (I had a request for a "clear the sheet" button, which I can't do since I'm avoiding VBA/macros in order to maintain OO and Mac/Linux compatibility).
Sure thing. I will do that.