erian_7's page

Quote:

I'm considering adding a "Shield Used" field on the front so you can flip it on and off fast without having to go to the Back tab. You can then dynamically see what effect(s) shields have on weapons.

I'd like to see this - any chance it can be in a beta build in the next 23 hours? :)

Tower Shields give you a -2 penalty when used in combat due to encumbrance. It is not recognizing this to be the case, neither did build .52 of Pathfinder/Hero Forge.

They both say "You have no penalties because you are proficient with Tower Shields." (My test build was a 1st level Dwarf Fighter with a 16 STR, Weapon Focus and Dazzling Display. Not sure if that has any bearing on it at all.)

If this IS actually the case, PLEASE tell me what page that bit of goodness is on! Cuz I want it! :D

Speaking of effects, I'll also be building in Conditions so the sheet auto-calcs impacts from things like Fatigue and Nauseated.

Does Pathfinder use the same 10/11 rule, and if so, does that mean Nymph as a character got that much stronger without a challenge rating increase? Or is there some new system for figuring out an Ability Score adjustment of a monster?

Ability Scores: The creature's ability scores are listed here. Unless otherwise indicated, a creature's ability scores represent the baseline of its racial modifiers applied to scores of 10 or 11. Creatures with NPC class levels have stats in the standard array (13, 12, 11, 10, 9, 8), while creatures with character class levels have the elite array (15, 14, 12, 11, 10, 8); in both cases, the creature's ability score modifiers are listed at the end of its description.

And on a side note, how would you adjust the challenge rating of a monster that has as many levels of spells as it's challenge rating if you removed all those spells and gave it a different class in a story? For example, what would a Nymph's Challenge rating be with no spells but everything else?

Thanks.

No I understand. What I'm saying though is that I don't want to steal any hits away from pathfinderdb.com. Maybe I'll create another page with links to off-site resources and then redirect people over to him. I didn't want to manage posting updated copies anyway so I was just going to give you access so you could post updates whenever you made them lol

erian_7 wrote:

Sure, you've done some great work there and I'd be happy to have a presence. The "official" version is up at the Pathfinder Database right now, so feel free to download from there and stick it on your site as appropriate. Thanks!

Ah, I didn't realize you were already on pathfinderdb. I don't want to have multiple different versions floating around so if you are already set up there I say just stick with one place. I don't need to be stealing any traffic from Tahsin!

erian_7 wrote:

a great sheet

Hey Erian - I'd love to host your sheet on d20pfsrd.com. Let me know if you'd be interested. Email me or post back here and let me know.

Thanks!

A good summary of the standard types (3.5, but carries over to PRPG):

http://www.d20srd.org/srd/theBasics.htm#modifierTypes

I'm going to be going to my local Pathfinder game this Sunday.

If you've got a new build of the sheet ready to run by 10 AM Central on Sunday, I'll re-key my character into it (only 2nd level, so not much re-keying) and give her a whirl.

Else, I'll use the one I sent you by email a few days ago.

I'll add my support to Erian_7's recommendation to look at the Remarkable Races Series from Alluria publishing available at Paizo or DrivethruRPG. There are 15 in all, all now available, with subraces for anumus and entobians. Each book features backstory, description, game mechanics, associated feats, an associated PrC, magic, equipment and/or associated creatures. Plenty of ideas. Note I am not in any way affiliated with Alluria publishing. I just like this series.

The Anumus could actually be fitted reasonably easily into PF and Golarion given their particular creation method and other races from the series could be added reasonably easily with appropriate adjustment of the provided backstory.

If a creature only has 1 HD of say humanoid, you replace that HD with their class HD. I'm not looking at a beastiary so my numbers could be off, just get the idea. A goblin with 1 HD of humanoid (1d8) is replaced if it takes a level of barbarian and it is a 1 HD creature with (1d12) as hit's hit dice

A minotaur with a base 4HD would start with 4d8(10?) plus it's first class level of barbarian's 1d12 and as such would be treated higher level than a 1 goblin barbarian.

A mite or vegepygmy on the other hand is a 1 HD creature. If you add class levels, you do not take away that 1 racial HD at all, but rather add the class levels to the 1 racial HD.

Perfect! That's exactly the passage I had been unable to find. Thanks so much for all your help. I just thought of one last question I had, and I think if anybody can answer it, all my monster PC concerns are absolved, but what happens if you play a race that casts as a 7th-level sorcerer or a 5th-level cleric, or whathaveyou, and then you start taking class levels in sorcerer or cleric, respectively. Do the racial levels stack with the class levels for spellcasting? I'm not sure I even have a strong intuition on this one.

(By the way, this is petalred. After I started this thread, I got around to setting up my profile. Just wanted to make sure it didn't seem like I was somebody else hijacking this thread. I'm the original poster)

Step 2: Add Class Levels

Once you have determined the creature's role, it's time to add class levels. The first step of this process is to modify the creature's ability scores. Creatures with class levels receive +4, +4, +2, +2, +0, and –2 adjustments to their ability scores, assigned in a manner that enhances their class abilities. Creatures with NPC class levels do not receive adjustments to their ability scores.

Next, add the class levels to the monster, making all of the necessary additions to its HD, hit points, BAB, CMB, CMD, feats, skills, spells, and class features. If the creature possesses class features (such as spellcasting or sneak attack) for the class that is being added, these abilities stack. This functions just like adding class levels to a character without racial Hit Dice.

I do medium to high level atrocities in Excel roughly every week for my own game company. To me, this is kind of a 'ooh, I get to relax' project that I can poke at when I feel like it.

(I've already had one customer ask if I'm the same person as runs Ad Astra Games and does horrifying things with Excel. The answer is 'yes'. *grin*)

You realize that once you've got the data laid out in your two page format that adding a landscape view layout a'la Kor's is a fairly modest investment in time and work...

I personally find that landscape view is much easier to deal with on the gaming table. :)

For the landscape view, that is indeed one of the drivers for moving the calculations/named cells over to data tabs, although I'm thinking about it from a laptop use perspective (easier to see the whole sheet). Once I've got that, I can have views for landscape, portrait, low-res monitors, compressed stat blocks, etc. That's a it longer term, as I'd definitely like to get the core functionality nailed and the non-core content at least mostly automated.

Just wanted to chime in with some applause for how great this sheet is. It's clear a ton of work is going into this for the good of the community. Kudos to you and all who are helping!

How about some Paizo recognition as the "Official Automated Character Sheet of the Pathfinder RPG" or some such? :)

However, I will say that if you like it and haven't already done so, head over to the Pathfinder Database and rate it as you see fit. I definitely appreciate the encouragement, support, and insight/recommendations from everyone on the thread, as the project has progressed much more rapidly thanks to you all!

Just remember that both Combat Expertise and Power Attack can be 'turned off' as needed. (I habitually make characters with both - Combat Expertise to combine with Dodge/Mobility to run up to the enemy wizard, Power Attack to put him out of his misery.)

I think it would be neat to have a generic shifter-like race with 2 main branches: animalistic humanoids, and animal-headed humanoids.

There would be several different subraces included in the main race, to represent canids (fox, wolf, jackal, coyote, hyena), feline (cat, tiger, lion, leopard), corvids (crow, raven, jackdaw), ursine (black bear, grizzly), porcine (boar, pig, warthog), bovine (ox, bull), cervid (deer, stag, moose, elk), etc. etc.

The animalistic humanoids would have limited shifting ability, granting a small bonus to a physical ability score and a single special ability.

The animal-headed humanoids would have more permanent abilities, but lack some ease of interaction with regular humanoid folk due to their weird appearance.

Maybe include a sub-race that is small for small animals, like mice, rats, etc.

And maybe include a sub-race that is quadrupedal, but with humanoid heads, like sphinxes.

You can check out the OGC material from this PDF (along with 10 other Alluria published races) in my character sheet (the Pathfinder Character Excelerator posted at the Pathfinder Database.

That makes a lot of sense.

Does anyone have any other thoughts on the ability racial modifiers issue? If the entries are mostly using the elite array, is there any way to figure out conclusively which numbers are corresponding to which ability scores? I mean, a 13 could be a 13, or an 11 with a +2 racial mod, or a 15 with a -2 racial mod. There's nothing more concrete about determining a monster's racial ability modifiers?

Ability Scores: The creature's ability scores are listed here. Unless otherwise indicated, a creature's ability scores represent the baseline of its racial modifiers applied to scores of 10 or 11. Creatures with NPC class levels have stats in the standard array (13, 12, 11, 10, 9, 8), while creatures with character class levels have the elite array (15, 14, 12, 11, 10, 8); in both cases, the creature's ability score modifiers are listed at the end of its description.[/url]

I'd say it needs to be on the front, myself. I'd give up the extra weapon block for it in a heartbeat.

While you're on the Power Attack automation, can you do anything with the Combat Expertise side of things and AC, like a drop down box that incorporates it into both the weapon blocks and AC?

You'll find the conversion guide here...

As for getting any of these officially, Paizo has stated farily certainly that such is not going to happen--they want to plow new ground and also respect the IP of WotC. Just changing the name and stats a bit can put Paizo in questionable legal ground, which is not something they'd want to do I believe.

Now, there are various fan threads on these forums for converting things like the hexblade and warlock. That's as close as you're going to get to anything "official" from Paizo.

Sent.

You can edit your post to get your email addy out of it now.

For Ammunition, I'm bouncing between moving it entirely to the Back sheet vs. removing one of the weapon stat blocks and using that space. Moving it to the Back is easiest, but also puts it a page-flip away from general combat info (which I've found leads to forgetting to track it). Any thoughts on this?

I'm still exploring my options as to how to incorporate the traits into the design. The easy way would just to add a seperate traits page, however I suspect in most cases characters would only ever be starting with just 2 traits, and probably never acquire any more, so based on that, I have a plan on how to implement them. Buying additional traits via a feat through the Levels page will be very easy to implement. If I rely solely on my Levels page for traits entry, then the most traits I could make available at 1st level is 3 -- does anyone foresee any problems with this?

Keep in mind that other publishers can use the OGL and Pathfinder Compatibility license to create new races for the Pathfinder RPG...

Alluria Publishing has already published 15 new races.

Got a place where I can email you my modded sheet so you can cut and paste?

The difference is in the creature's themselves. Take the Mite, for instance. It is a Fey with 1 HD. If you add classes to a Mite, it will still be a 1 HD Fey, but with class levels. A few entries away you have the merfolk. These are Humanoids, but they have no HD. The entry in the book is actually for a Merfolk Warrior 1--if you take away the level in Warrior, the creature isn't a 1 HD Humanoid at all (if you want a "basic" Merfolk, it would probably be a Commoner 1).

Well, I'm obviously on the right track for my major updates in v.0.8...you guys are asking questions about all the focus areas (weapon, feat, and trait automation)!

I am having trouble adding the Galorian specific feats (big game hunter et al). They come up red and I have no idea on what I am missing! By the way this sheet is superb as always. As I get the time to fiddle with it some more I will see about the areas to help you kick the awesome factor up a notch!

James Wyant wrote:

I just started checking out the product and I like what I see so far but I have found one flaw that should be very easy to fix. The melee weapon damage doesn't calculate in the strength modifier. The character I am using to check it out has a 15 strength and a +1 long sword but the only addition it gives for the damage is the +1 from the sword.

To the top right of the weapon block you select how much, if any of your strength modifier to apply. It defaults to zero. This way you can take into account wielding one hand weapons with two hands, offhand, etc.

Hello,

Love the sheet by the way. Here are a few issues I found on the copy of the file I downloaded for PRPG_CS_v_0_7. I am using Excel 2003 if it makes a difference.

On the Customization tab.

The Custom Skills header position AD14 is mapped as "=D9", should be "=A9"
The Custom Skills header position AE14 is mapped as "=D11", should be "=A11"

On the DataSkills tab.

The Custom Skills section is on line 53 and 54 skip the mappings for "=Z15" which is shifting the last few maps over 1. You go from "=Y15" to "=AA15"

Everything else so far looks awesome. The only thing I would like to see specifically added is if you could pre-build the skill roll for Concentration...though its not treated as a skill in Pathfinder, it follows basically the format as a skill roll.

In DataSkills tab, your code for the custom skills section looks like its missing quotation marks in the if statements.

Cell CE25 should have its formula updated to:

=MIN(0,VLOOKUP(BP22,Table_Armor,6,0)+IF(CT22="",0,1)+IF(OR(CM28="Mithral",C M28="Darkwood"),2,0))

(It doesn't check for Darkwood when figuring the skill rank penalty)

I created a Carried drop down that limits to Yes/No, and a quantity drop down that limits to 1 through 6 (for things like throwing javelins).

Both modify the weight of the weapon appropriately - if carried is set to "N", weight is 0. If the quantity carried is greater than 1, it multiplies the weight by the quantity carried.

Downloaded the latest version; I'll be poking at it a few more times.

Do you have an estimate on when you want to push out the next version, so I can focus my efforts on a deadline?

The stunt for 'dynamic' dropdowns is this:

<<Good Stuff>>

Also, look seriously into converting your VLOOKUPS into INDEX and MATCH workups. They're computationally less intensive and MUCH MUCH easier to maintain once you've learned them.

Are calculations on the spells tab planned for a future release? stuff like save DC's, spells known, etc.

Looking good!

I don't know what you or your competitors can actually do about that, because I can appreciate the reluctance to add the whole damn Bestiary.. but if some character builder would actually look at the AP's and see what races are really getting character levels, that would be awesome.

Not sure if any of the campaign traits are meant to be automated, but just in case I wanted to let you know that the Westcrown Firebrand is not applying +1 to Initiative

if it applies to both (as read) it does not account for the damage...only the to hit in the program. :)

The feat dervish dance. I was wondering, does it apply both dex mod to hit and damage or just to hit. It factors in just to hit, but states it does both hit and damage.

Linkified...

Lost Classes of Fantasy: Thief Acrobat (PFRPG) PDF

I've documented the following so far (gathering data to include OGC in my character sheet XLS):

Ashvawg Tamer (Druid), Alt, RotRL 5 - 71
Balanced Scales of Abadar, PrC, DM - 54
Brightness Seeker, PrC, EoG - 28
Chevalier, PrC, SD 2 - 62
Daivrat, PrC, QGttE - 20
Demonic Initiate, PrC, SD 3 - 62
Diabolist, PrC, PoD - 44
Genie Binder, PrC, LoF 4 - 52
Harrower, PrC, PCCS - 224
Inheritor's Crusader, PrC, CoT 2 - 71
Justiciar, PrC, CotCT 2 - 69
Lion Blade, PrC, TEoG - 22
Living Monolith, PrC, OLoP - 22
Low Templar, PrC, PCCS - 226
Pathfinder Chronicler, PrC, PCCS - 228
Pathfinder Delver, PrC, SoS - 58
Pathfinder Savant, PrC, SoS - 60
Red Mantis Assassin, PrC, CotCT 3 - 69
Red Mantis Assassin, PrC, PCCS - 230
Shackles Pirate, PrC, PCCS - 232
Spherewalker, PrC, RotRL 2 - 73
Student of War, PrC, SoS - 62

CoT - Council of Thieves (PRPG)
CotCT - Curse of the Crimson Throne
DM - Dark Markets
EoG - Elves of Golarion
LoF - Legacy of Fire
OLoP - Osirion Land of Pharaohs
PCCS - Pathfinder Chronicles Campaign Setting
PoD - Princes of Darkness (PRPG)
QGttE - Qadira Gateway to the East (PRPG)
RotRL - Rise of the Rune Lords
SD - Second Darkness
SoS - Seekers of Secrets (PRPG)
TEoG - Taldor Echoes of Glory

Only the ones marked PRPG are "officially" Pathfinder products, but the others are all 3.5 OGC and can be used with minor conversions.

And for anyone that notices I've missed a prestige (or alternate) class somewhere, let me know!

Thanks for mentioning this. I did try to download the 2007 version and the link and file work fine for me. If anyone else has a problem downloading this file (or if they have successfully downloaded it) could you please post your results here. Thanks.

I have sent the "final" file with material from all contributing publishers up to the Pathfinder DB for posting. Of course, it's still a beta and I'll happily incorporate any future contributions. This exercise did stretch the sheet a bit--it now accommodates races from Fine to Colossal (thanks to the kval...) for instance. So, thanks to all that have contributed to date, and please any new (or previous) interested parties feel free to contact me regarding adding OGC to the next release.

PRPG_CS_v_0_7.zip

Okay, I've sent v.0.7 up to the Pathfinder DB as the new BETA baseline. Biggest change from the last test version is that I expanded the Table_Size to incorporate all sizes from Fine to Colossal. This way I can just use a VLOOKUP to calculate weight for armor and weapons as neeeded. So, all sizes are now supported. It also properly halves the Armor bonus for sizes smaller than Small (never noticed that before!).

PRPG_CS_v_0_7.zip

Wanted to let you know that it looks like the GP Variance calculation is off. It looks to be subtracting Total GP Value from 1000 and ignoring what is entered in Starting Gold.

FYI: fellow Paizonian erian_7 has been working on an excel based character sheet with fields that auto-fill and auto-calculate.

You can download it on his profile page: link

It runs in Excel or Open Office (which is free).
It seems pretty comprehensive, although I did find it slightly overwhelming.

It's still underdevelopment, but he's constantly updating up.
I like to use it to easily calculate ability scores for NPCs.
Check it out.

Okay, final cut (hopefully) before I post v.0.7 to the Pathfinder DB:

PRPG_CS_v_0_6_8.zip

Oh, and as it looks like the APG classes are going to be OGC during playtest, I will indeed incorporate them into a future version. They will be clearly marked as BETA.

Thanks!

I know of a non-VBA method of getting dynamic dropdowns to work; this could be used to greatly reduce the sorting clutter on selecting weapons from the drop downs, and from pulling feats from limited feat lists.

I'm making a character with 2 levels of Sorc and the rest in fighter, and on the Sorcerer Abilities Summary, it's showing the 3rd level Bloodline Power.

When I select any of the Bloodlines after Lycanthropic, it shows the entire list of Bloodline powers, rather than whatever's appropriate to the Lvl_Sor variable.

The rest of your suggestions are great, just what I need to really refine the sheet. I'm glad I didn't updload it as v.0.7 to the Pathfinder DB as yet. I'll give it to the end of the week before I post anything. That'll also give me some more time to work out the 3rd party automation...

I am loving this sheet. I created a character with a version a couple back and it is the best sheet I have ever used.

Again, great job on everything.

Will you be adding the soon to be out new base classes for Pathfinder? The playtest will start with Cavalier and Oracle.

I'd suggest an exact place for that to go in, but I think you're going to have to define another named variable in this - and that's beyond the scope of changes I'll make in someone else's sheet sans permission.

As for reserving comments/other changes without permission, please feel free! I by no means claim to be an Excel expert and what skills I have come from copying/studying better solutions than whatever I've cobbled together in the past. So long as it doesn't "break" the sheet for compatibility with Mac/Linux, OpenOffice, and older versions of Excel I'm all for it...

Thanks!

EDIT: To state that more specifically, I wouldn't care if you recommended changes for every cell in the spreadsheet if it'll make this a better tool!

I tried to design my sheet to run on Excel 2002 and up, so I did not use any "IFERROR" statements (so I used a whole lot of "IF(ISERROR)" statements so hopefully that should not cause problems.

It seems the request for traits is growing, so I will likely move them up in the priority list. Sure, I would appreciate the list you have.

To hopefully save some time on testing, I think you'll find the XLSM/XLSX/XLSB formats all function oddly in OpenOffice. At least that's what I've found so far in testing for my sheet. The XLS format seems to work fine, but there are some Excel functions (like IFERROR) that will not function in OpenOffice no matter the format.

And perhaps another time saver if you do decide to add trait functionality--I've got all the traits in my sheet in a single table, so you could rip it out and add the data in. It includes all traits released as OGC by Paizo to date, so that should be a big leg-up on data entry.

All, please note I'm looking to finalize v.0.7 to upload to the Pathfinder DB tonight. Please post any findings before that time and I'll work to get any required fixes in place. I am particularly interested in hearing fr my Mac, Linux, and OpenOffice folks to ensure everything is looking good on these various platforms. Thanks!

I am unsure if the Skill Focus feat grants you an additional +3 (to +6) when you have 10 ranks in that specific skill...

Not sure if its just me or the sheet, but if you take Eldritch knight, it gives you an extra spell progression at level 1.

Ah monkey-nuggets...messed up one of the fields by adding descriptive text. Incremental update to fix...

PRPG_CS_v_0_6_7.zip

The character sheet is great and almost exactly what I was looking for, but is there a way to increase the size of the Racial Abilities box? The last few lines of info about my Dwarven Cleric of Torag is missing!

Hi all, I wanted to let those interested know that I'm gearing up for another release of my Excel-based sheet. This one incorporates all the PRPG core classes and prestige classes, all core feats, core and Bestiary "playable" races, all the OGC content from Paizo for feats and traits, and to top it all off I now have several 3rd-party Publishers that are providing content as well (new bloodlines, domains, feats, and even the Shaman class). I've also started incorporating support for both the Pathfinder Society and Legend of the Shing Jewel living campaigns. I'm looking for a nice test on my final draft before finalizing this version and getting it up to the PFDB. You can join us in the discussion thread, or alternately I always keep a link to the latest version in my profile...

Thanks!

erian_7's Excel-based Character Sheet