1IKing's page

My my, I've been preparing to boot up the ol' pathfinder campaign again, so of course I downloaded the latest version of the ogre sheet and I was blown away. An incredible amount of improvement over what was already a great product.

Alpha testing stuff:

The Cleric Domain Scalykind is listed as one of the domains available to Caiden.

Ranged touch attacks and ray attacks use Strength for their to hit modifier. Touch attacks use strength as a damage modifier.

If I find anything else, I'll post it.

In Pathfinder, Paladin spellcasting characteristic changed from WIS to CHA.

The Sling weapon is marked as 2 handed, which gives it a 2 handed strength bonus to damage. So a strength 18 character gets 1d4 + 6 damage, instead of 1d4 + 4.

Good job on getting the rage powers to work. The land speed of the Travel Domain/Barbarian is working perfectly now too.

Some minor errors on the Arms sheet. A Keen greatsword is presented as having a crit range of 18-20 instead of 17-20.

And if on Row 137 of the Arms_DATA sheet, the formula assumes all ranged weapons are composite longbows to calculate the -2 penalty. Which leads to a -1 strength bonus sorcerer to have a -2 bonus on his ranged touch attack.

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.

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.

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?

!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?

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.

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.

Version Alpha 0.19 is now out, fixing some of the small errors I found.

http://www.pathfinderportal.com/ogresheet.html

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.

This had my Gnomish Paladin Lord Chestnut the Brave buckling under the weight of his armor, shield and sword, all of which weighed twice as much as they should.

Table: Armor for Unusual Creatures
Size Humanoid Nonhumanoid
Cost Weight Cost Weight
Small ×1 ×1/2 ×2 ×1/2
Medium ×1 ×1 ×2 ×1
Large ×2 ×2 ×4 ×2
Huge ×4 ×5 ×8 ×5
Gargantuan ×8 ×8 ×16 ×8
Colossal ×16 ×12 ×32 ×12

Otherwise this is a very nifty excel sheet. I love the thoroughness and the intricacy of the code.

Kudos.