erian_7's Excel-based Character Sheet


Homebrew and House Rules

851 to 900 of 1,732 << first < prev | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | next > last >>
Sovereign Court

I agree with change isn't bad. I will freely admit that I like slow change from things I see as already pretty good.

That being said, I feel lots of great changes are in this page and many more to come. Just the skills section alone is worth mentioning and the weapon blocks are tremendous.

I was leary about losing all the hard black lines (I think borders are so so good) but now as I see this new version I like it alot. I still think the weapon blocks could use more "borders" or hard lines, ect.. to keep info clear.

All in all though I think it looks great, awesome work everyone!

I'm still working on getting used to the names and character info block in middle though.


Witch is done, except for the familiar. I'm going to do the Companions tab before releasing v.0.8, but I probably won't get it complete this weekend. As this otherwise wraps up all of the APG Beta classes, everyone please take a big hammer to this to rattle out any bugs before I finalize it. Once the Companion tab is done, I'm basically going to build in a portrait print view in the Landscape version, update the Portrait version to include the new features (and include a landscape print view) and call it done.

Landscape Character Sheet File: PRPG_CS_L_v_0_7_15_6.zip

Sovereign Court

Do you have a paypal account? I'd love to pay you for your work on this. I tried buying something off your wishlist but it wanted to ship it to me instead of you.

I can be contacted at markusdark@hotmail.com in case you want to chat privately about this stuff.

Thanks for ALL your work here!


Markusdark wrote:

Do you have a paypal account? I'd love to pay you for your work on this. I tried buying something off your wishlist but it wanted to ship it to me instead of you.

I can be contacted at markusdark@hotmail.com in case you want to chat privately about this stuff.

Thanks for ALL your work here!

And thank you for the support! I actually don't take any payment, both because I enjoy giving back to the community and because the Paizo Community Use Policy (which is what let's me use Golarion proper names and such in the sheet) prohibits accepting payment for the work.

Now, with that said there is actually one way anyone can support the sheet--I very much believe in the Open Game License (OGL) and Open Game Content (OGC). It's what allows me to include the fine material from publishers like 4 Winds Fantasy Gaming, Alluria Publishing, Otherworldy Creations/Super Genius Games, and Rite Publishing. I mention all of these specifically because they have in the past provided me with content for the sheet free-of-charge. On my last "hey I've got a little extra money" break I managed to purchase a few more PDFs that will soon be gracing the sheet, things like the Tome of Secrets from Adamant, plus almost everything the above publishers had available at the time. Of course, now they've published more stuff and I'm tapped on the extra RPG budget (you reminded me to update my Wish List with the stuff I don't have yet from these guys).

So...short story long I would encourage anyone that likes this work to go to support 3rd Party Publishers by purchasing their products--that's the best way to keep the OGL alive and kicking. Send your favorite publishers a note and tell them you think they've done a fine job. If you want to mention my work in the process, and if they are interested in contributing to the effort I have a thread ( Open Call To 3rd Party Publishers - I'll Support Your PRPG OGC) where they can jump in and ask questions or let me know their thoughts.

Thanks again!


erian_7 wrote:
Good stuff

- As you Americans say "you are da bomb!"


Hello Erian 7

A bug report

PC, Windows Vista, Excel 2002 SP3.

I am making a 5th level human witch with epic points.
Str 10
Dex 14
Con 10
Int 16 +2 for bonus, +1 for level (19)
wis 14
Cha 14

Primary Class - Witch - all bonus points are skill points

Hexes - Cauldron, Evil Eye, and Flight

Feats - Spell Focus Enchantment(race feat), Greater spell focus Enchantment, Magical Aptitude, Skill focus Alchemy.

The stats on the "front page" tab aren't adding up properly they are subtracting one from the physical stats and adding one to the mental stats.

Str 9
Dex 13
Con 9
Int 20
wis 15
Cha 15


The 8th Dwarf wrote:

Hello Erian 7

A bug report

PC, Windows Vista, Excel 2002 SP3.

I am making a 5th level human witch with epic points.
Str 10
Dex 14
Con 10
Int 16 +2 for bonus, +1 for level (19)
wis 14
Cha 14

Primary Class - Witch - all bonus points are skill points

Hexes - Cauldron, Evil Eye, and Flight

Feats - Spell Focus Enchantment(race feat), Greater spell focus Enchantment, Magical Aptitude, Skill focus Alchemy.

The stats on the "front page" tab aren't adding up properly they are subtracting one from the physical stats and adding one to the mental stats.

Str 9
Dex 13
Con 9
Int 20
wis 15
Cha 15

Your old. Check your age...of your character I mean. Age effects characters in exactly the way you are describing.


Jeff Collins wrote:
Your old. Check your age...of your character I mean. Age effects characters in exactly the way you are describing.

Yep, that's definitely the Age modifier. Your character must be somewhere between the ages of 35 and 52.


erian_7 wrote:
Jeff Collins wrote:
Your old. Check your age...of your character I mean. Age effects characters in exactly the way you are describing.
Yep, that's definitely the Age modifier. Your character must be somewhere between the ages of 35 and 52.

Ha 35 years old :-)

bummer

In RL both my mental and physical stats have gone down. :-)


The 8th Dwarf wrote:

Ha 35 years old :-)

bummer

In RL both my mental and physical stats have gone down. :-)

Note you can tweak the racial age categories on the DataRaces tab to shift the ages around (or of course just leave the Age blank).

Sovereign Court

Hi !

Update on my problem : It's just that the text doesn't wrap up. and my FTP really is out of order :(

It's fine in the beginning (Bard Spells, Bardic Knowledge), then comes Bardic Performance : fine until it comes to Countersong. It says "... or save if higher; creatures already under effect..." and the end of that line/sentence is not visible.

Then come all the other Bardic Performances (from Distraction to Inspire Competence) and all of them are truncated in the end (though they are displaying on several lines when needed, but each time the last words of each line are not visible.

Same for the next entries (Cantrips and Versatile Performance).

I may have found another small error : Its says I have 3 cantrips known, when The Book tells me I have 4 at lvl 1 and then 2 more at lvl 6. ^^

(I'm still with version 0 7 14 1 L, btw).

And thanks for all your good work :)

Sovereign Court

oh just moving my old characters over to the current sheet.

The shield bonus isn't appearing in AC.

Inquisitor is proficient in short bow either.

As for comments and notes.

I liked the little "note box" that used to be there in the AC section. I like the additions to the AC box, but with space restrictions I know the note box was cut. it was very useful.

Weapons. I know there isn't right now a way for more weapon box's but I think it might need to be worked. I do like them just need more.
Having a two-weapon fighter takes out half the box's right there.

Gotta say, very nice though as I'm putting my character, very nice indeed.

gotta add about notes to Saves would be great. looks like they were there but ran out of room and cut.

Travel domain doesn't add the 10' to speed. and when I go to add in misc. box it also doesn't add in.


Lynx wrote:

.

The shield bonus isn't appearing in AC.

Make sure the shield is wielded/readied in the Shield box. It used to be in the AC area, it's now in the shield area.


Next iteration. I've started reformatting the Companions tab to match the style of the Front tab.

Landscape Character Sheet File: PRPG_CS_L_v_0_7_15_7.zip

Solitude wrote:

Hi !

Update on my problem : It's just that the text doesn't wrap up. and my FTP really is out of order :(

Well, this is just driving me nuts. I cannot replicate this problem in either Excel 2007 or OpenOffice 3.1.1 and so am at a loss. I have tried one thing in this latest version, turning the text entry into a formula that concatenates the paragraph together. I did this only for Countersong, so let me know if it works...

Solitude wrote:

I may have found another small error : Its says I have 3 cantrips known, when The Book tells me I have 4 at lvl 1 and then 2 more at lvl 6. ^^

(I'm still with version 0 7 14 1 L, btw).

And thanks for all your good work :)

I believe the Bard was at one point referencing the Spells Per Day table rather than Spells Known, but I fixed this in one of the future iterations. Should be good to go

Lynx wrote:

oh just moving my old characters over to the current sheet.

The shield bonus isn't appearing in AC.

As noted, make sure the shield is Readied. If it is and you still see a problem, let me know...

Lynx wrote:
Inquisitor is proficient in short bow either.

Ah thanks, needed to update the Weapon_Prof_Other field to include the new classes.

Lynx wrote:
I liked the little "note box" that used to be there in the AC section. I like the additions to the AC box, but with space restrictions I know the note box was cut. it was very useful.

I've added a box in General Combat beside Init and above the AC. Do you think that will work for your needs?

Lynx wrote:

Weapons. I know there isn't right now a way for more weapon box's but I think it might need to be worked. I do like them just need more.

Having a two-weapon fighter takes out half the box's right there.

Gotta say, very nice though as I'm putting my character, very nice indeed.

Thanks! For the weapon blocks, my general approach for characters is to cut lines out of the Skills section as needed and put more info there. But I know that gets into modifying the overall sheet and not everyone wants to get into that. One thing I could do is create a Weapons sheet that wouldn't directly interact with the Front tab, but would serve as a place to make some other weapon combos and print them on, say, a half page format.

Lynx wrote:
gotta add about notes to Saves would be great. looks like they were there but ran out of room and cut.

The notes are actually functional. This is a "formula" cell, so you don't edit it directly. It pulls in information from races right now, as well as the "Improved..." save feats. I want to integrate traits in there as well. For your own notes, you enter these on the Character Options tab in the Save Conditional Modifiers area. I put a note in the comments for the Misc value right above these as a pointer for folks.

Lynx wrote:

Travel domain doesn't add the 10' to speed. and when I go to add in misc. box it also doesn't add in.

You knocked out two problems there...the Cleric_Domains cell formula had somehow gotten deleted, so no domain powers would be showing up anywhere, and the MV_Mod_Other name needed to be shifted over one cell.

Lantern Lodge

I've just played a little with your sheet and I think I found a little bug in the calculation of the Attack Bonus when you use thrown weapons and two weapons fighting.

The Attack bonus of the off-hand weapon doesn't seem to be right. It seems the dexterity modifier isn't added properly.

I think I corrected it on my end by replacing "Melee-Str_Mod_Current" by "IF(O78="Melee";Melee-Str_Mod_Current;Ranged", but using this method will only work on Office 2007 or laster versions due to the global size of the formula. Creating a cell with the value "IF(O78="Melee";Melee-Str_Mod_Current;Ranged" and using it should be a good work around.

Also, the Paladin with the Divine Mount should also have a animal compagnon.

Hope that help a little.


Ushoran wrote:

I've just played a little with your sheet and I think I found a little bug in the calculation of the Attack Bonus when you use thrown weapons and two weapons fighting.

The Attack bonus of the off-hand weapon doesn't seem to be right. It seems the dexterity modifier isn't added properly.

I think I corrected it on my end by replacing "Melee-Str_Mod_Current" by "IF(O78="Melee";Melee-Str_Mod_Current;Ranged", but using this method will only work on Office 2007 or laster versions due to the global size of the formula. Creating a cell with the value "IF(O78="Melee";Melee-Str_Mod_Current;Ranged" and using it should be a good work around.

Ah, good one--I hadn't tested that particular combo. Fixed for the next iteration

Ushoran wrote:

Also, the Paladin with the Divine Mount should also have a animal compagnon.

Hope that help a little.

The paladin's mount will be one of the options for selection on the Companion tab...

Sovereign Court

erian_7 wrote:
I cannot replicate this problem in either Excel 2007 or OpenOffice 3.1.1 and so am at a loss. I have tried one thing in this latest version, turning the text entry into a formula that concatenates the paragraph together. I did this only for Countersong, so let me know if it works...

It does... but only for Countersong ^^

It's worse for the 4 other powers, as they don't even try anymore to be written on two lines when there's not enough room.
Same for the 3 other bard abilities that are listed after.

And thanx for fixing the cantrips :)

Lantern Lodge

While I'm at it, I also encounter those bugs :

The selection of the Paladin mercies don't take the paladin level into account, it's an easy fix.

The healing/damage of the channel energy for Clerics and Paladins isn't calculated properly. Should be (Lvl + 1) / 2 and not (Lvl / 2).

You've done a very good job with this sheet, thanks a lot.


Solitude wrote:
erian_7 wrote:
I cannot replicate this problem in either Excel 2007 or OpenOffice 3.1.1 and so am at a loss. I have tried one thing in this latest version, turning the text entry into a formula that concatenates the paragraph together. I did this only for Countersong, so let me know if it works...

It does... but only for Countersong ^^

It's worse for the 4 other powers, as they don't even try anymore to be written on two lines when there's not enough room.
Same for the 3 other bard abilities that are listed after.

And thanx for fixing the cantrips :)

Okay, so the problem is in displaying pure text fields that exceed 255 characters...I should be able to fix that, and it's good to finally have some idea of what is going on. I still can't figure out why it only seems to be a problem on certain folk's computers...

Ushoran wrote:

While I'm at it, I also encounter those bugs :

The selection of the Paladin mercies don't take the paladin level into account, it's an easy fix.

I'm not sure what you mean--can you give an example? This should be working, although I am going to switch it over to the dynamic list display like I'm now using with the rage powers and rogue talents so the list looks nicer.

Ushoran wrote:

The healing/damage of the channel energy for Clerics and Paladins isn't calculated properly. Should be (Lvl + 1) / 2 and not (Lvl / 2).

You've done a very good job with this sheet, thanks a lot.

Huh, looks like I got in the middle of updating that to use the standard Channel_Level field but didn't finish the Class Abilities automation. Fixed...

Thanks!

Lantern Lodge

My english is a little rusty, sorry...

For the mercies, for exemple, at lvl 3, the Paladin shouldn't be able to take Paralyze as a mercy. It's only available at level 12 if I remember correctly.

But, It's not a very big problem.


Ushoran wrote:

My english is a little rusty, sorry...

For the mercies, for exemple, at lvl 3, the Paladin shouldn't be able to take Paralyze as a mercy. It's only available at level 12 if I remember correctly.

But, It's not a very big problem.

Ah, I see what you are saying now--the Qualified formula on those should be incrementing the required Paladin level, but was set at the base of Lvl_Pal>2. Fixed it!


In creating a 9th level monk I having trouble getting the Flurry of Blows calculation work. In the weapon section of the sheet I select melee, unarmed strike, one-handed (though I have tried all variations of this pull-down), and Flurry of Blows. The Total Attack bonus returned is the value for a full normal attack (i.e., 1st attack=full attack bonus, 2nd attack= full attack bonus-5).

Am I doing something wrong.

Thanks

Bear


in the "back" sheet in the cell BD31 there's a formula with all the description of magic item.
the formula is "=B15&B19&B23&B27&B31&B35&B39&AC15&AC19& ;AC23&AC27&AC31&AC35&AC39"

the cell is very small so you see a tiny letter only, I've moved the formula on the box "magic items note" to solve the problem, but I don't know if this is what you had in mind.

p.s.
I like the new layout, is much better than before (imho) thank you.


Stephen Black 831 wrote:

In creating a 9th level monk I having trouble getting the Flurry of Blows calculation work. In the weapon section of the sheet I select melee, unarmed strike, one-handed (though I have tried all variations of this pull-down), and Flurry of Blows. The Total Attack bonus returned is the value for a full normal attack (i.e., 1st attack=full attack bonus, 2nd attack= full attack bonus-5).

Am I doing something wrong.

Thanks

Bear

Bear, did you remember to also select the second weapon block for your off hand?


Just a small note while I was prepping some baddies with the spreadsheet. Hobgoblin's Stealth bonus was not being calculated in.


Bear, did you remember to also select the second weapon block for your off hand?

I tried this, but I get the same return for a 9th level monk with a +4 STR, I get +10/+5 attacks on BOTH weapon blocks.

By my calculations I should be getting two +11 attacks for Flurry of Blows. Am I right?

Bear


Antonio Sciancalepore wrote:

in the "back" sheet in the cell BD31 there's a formula with all the description of magic item.

the formula is "=B15&B19&B23&B27&B31&B35&B39&AC15&AC19& ;AC23&AC27&AC31&AC35&AC39"

the cell is very small so you see a tiny letter only, I've moved the formula on the box "magic items note" to solve the problem, but I don't know if this is what you had in mind.

p.s.
I like the new layout, is much better than before (imho) thank you.

That is actually a named cell--Magic_Item_Summary--that I set up real quick to support the calculations done on the DataMagicItems tab. That is all a precursor to my ideas on automating magic items, basically. There's no real need to see the contents of the cell itself, since it'll just be the concatenated names of any magic items in those slots.

And thanks for the feedback on the layout!

Geeky Frignit wrote:
Just a small note while I was prepping some baddies with the spreadsheet. Hobgoblin's Stealth bonus was not being calculated in.

Thanks for catching that. Fixed for the next iteration!

Stephen Black 831 wrote:


AdAstraGames wrote:
Bear, did you remember to also select the second weapon block for your off hand?

I tried this, but I get the same return for a 9th level monk with a +4 STR, I get +10/+5 attacks on BOTH weapon blocks.

By my calculations I should be getting two +11 attacks for Flurry of Blows. Am I right?

Bear

A 9th level monk using flurry of blows would get +7/+7/+2/+2, as noted in the table for monk class abilities. With a Str of 18-19 granting a +4 modifier, this would increase to +11/+11/+6/+6. I just ran through a human monk with this configuration and got the expected results. Do you have both weapon blocks set to Flurry of Blows, with one as 2-Wpn Primary and the other as 2-Wpn Off-Hand?


Buckler isn't showing up on the list of available shield types.


Hi, I know you are working on the companions page. Just wanted to be sure you were going to allow for a familiar and an animal companion. I have a multi-class Druid/Wizard and the rules are pretty clear that these are supposed to be separate animals.

While dealing with custom nature-bond and wizard schools, I noticed you are still missing schools on the customization tab. I of course had no trouble modifying in the schools tab, but I suspect this is not your intention.

Finally there was no direct method I could find to customize druid's nature-bond. The work around is to use the Additional Domain Feat (which is fine so long as you don't need an additional domain feat). I think a better solution is to add custom domains to the Nature Bond pull-down. I looked around to see if I could do that myself in the short term, but this part of the spreadsheet is beyond my meager skills.

Finally, I noticed a few peculiarities when it comes to skills and custom classes. On an older sheet (7.8), diplomacy does not shows up as a class skill, even when checked for a prestige class I've taken several levels of. Testing this on 7.15.6, I found any skills with a 1 on the prestige class were counted even when I had not taken any levels of that prestige class yet. This is probably no big deal (how many people are going to input a custom prestige class before they start using it?), but it was a bit unexpected.


seaan wrote:


Finally, I noticed a few peculiarities when it comes to skills and custom classes. On an older sheet (7.8), diplomacy does not shows up as a class skill, even when checked for a prestige class I've taken several levels of. Testing this on 7.15.6, I found any skills with a 1 on the prestige class were counted even when I had not taken any levels of that prestige class yet. This is probably no big deal (how many people are going to input a custom prestige class before they start using it?), but it was a bit unexpected.

Hmm, this is what comes from trying to hurry up a late night post. I meant to say that the current sheets shows any skill chosen on the prestige class form as a class skill even if no levels of the prestige class have been taken.

As to the other typo, just call me "Finally, Finally, Seaan" :-)
(reference to Nicely Nicely Johnson from Guys and Dolls)


AdAstraGames wrote:
Buckler isn't showing up on the list of available shield types.

Hmm, this is showing on mine. Anybody else missing the buckler?

seaan wrote:
Hi, I know you are working on the companions page. Just wanted to be sure you were going to allow for a familiar and an animal companion. I have a multi-class Druid/Wizard and the rules are pretty clear that these are supposed to be separate animals.

Yes, you'll be able to have multiple companions. My current thinking is to get the Companions tab to show 2 companions, printing one per half page. Ideally, you could also copy the tab infintely, but I'll have to ensure any named cells are properly focused on just the tab itself rather than the whole worksheet.

seaan wrote:
While dealing with custom nature-bond and wizard schools, I noticed you are still missing schools on the customization tab. I of course had no trouble modifying in the schools tab, but I suspect this is not your intention.

Ah yes, I do need to add a section for Custom Schools...

seaan wrote:
Finally there was no direct method I could find to customize druid's nature-bond. The work around is to use the Additional Domain Feat (which is fine so long as you don't need an additional domain feat). I think a better solution is to add custom domains to the Nature Bond pull-down. I looked around to see if I could do that myself in the short term, but this part of the spreadsheet is beyond my meager skills.

I need to work on the Nature Bond class ability, actually, so that it properly displays the domain powers and such if selected. I'll see about adding in the custom domains in the process.

seaan wrote:
Finally, I noticed a few peculiarities when it comes to skills and custom classes. On an older sheet (7.8), diplomacy does not shows up as a class skill, even when checked for a prestige class I've taken several levels of. Testing this on 7.15.6, I found any skills with a 1 on the prestige class were counted even when I had not taken any levels of that prestige class yet. This is probably no big deal (how many people are going to input a custom prestige class before they start using it?), but it was a bit unexpected.

Yep, I need to come up with a slicker way of handling custom skills with custom classes...


I gotta say - this thing rocks. I've got my entire party using it now.

Perhaps I'm just missing something, but I'm not sure how to get double weapons to show up correctly using the most recent sheet.

If you have two-weapon fighting and armed with a two-bladed sword, for instance, you should have -2 to each attack and +STR damage for one end and +1/2 STR for the other.

If I put it in as a single weapon, it doesn't give me any penalties to attack and +1.5 STR (if a two-handed weapon) or +STR (if two-weapon primary). If I try to put it again under another weapon heading, it gives me -4 to attacks since the "off-hand" weapon is not light (though it gets the damage right). Of course, it also counts the weight of the item twice for encumberance as well.

Any thoughts?


Tem wrote:

I gotta say - this thing rocks. I've got my entire party using it now.

Perhaps I'm just missing something, but I'm not sure how to get double weapons to show up correctly using the most recent sheet.

If you have two-weapon fighting and armed with a two-bladed sword, for instance, you should have -2 to each attack and +STR damage for one end and +1/2 STR for the other.

If I put it in as a single weapon, it doesn't give me any penalties to attack and +1.5 STR (if a two-handed weapon) or +STR (if two-weapon primary). If I try to put it again under another weapon heading, it gives me -4 to attacks since the "off-hand" weapon is not light (though it gets the damage right). Of course, it also counts the weight of the item twice for encumberance as well.

Any thoughts?

The formulas for handling Off-Hand Double Weapons as light have gotten screwy. You should basically have 1 weapon block as Primary and one as Off-hand. My next iteration will correct this...

For the multiple counts on weight, set the Quantity (QTY) to 0 and that should be fixed.

As a general note for all, I've got the basic Animal Companions mostly done (still need to enter the Bestiary options) and am hammering out the Familiars now. Should have something for y'all to review this evening...


my english is not that good...

I add to your worksheet 2 things: Calculator and CalculatorDATA

It's common to see a lot of topics discussing the best combat-build char with different types of classes/races combination…
So I make it easier to do math and ref the damage calc, attack odds, and etc..
How can I send to you?

The layout is not so good but that should be easy for you….


Verbek wrote:
my english is not that good...

Heh, no worries...many folks would say my English ain't so great either! One of the joys of being native to the Southern U.S.A.

Verbek wrote:

I add to your worksheet 2 things: Calculator and CalculatorDATA

It's common to see a lot of topics discussing the best combat-build char with different types of classes/races combination…
So I make it easier to do math and ref the damage calc, attack odds, and etc..
How can I send to you?

The layout is not so good but that should be easy for you….

Shoot it to my email address:

Spoiler:
erian dot 7 at gmail dot com

And I'm finishing up the mephits now, so expect a new version within the hour...


Well, a little more than an hour, but I decided to finish off the paladin and cavalier mounts while I was at it.

Landscape Character Sheet File: PRPG_CS_L_v_0_7_15_8.zip

Note that for now the Improved... and Weapon Focus... feats for natural attacks don't actually raise the values of the attacks--I'll have to work that in later, as it currently looks to be a lot of coding. I expect with this much functionality coming in at once, there will definitely be issues and I'm also not entirely happy with the interface/layout right now. So, hammer away!

This just leaves the eidolon to complete the overall companions mechanic, so I'm hoping that means v.0.8 will be ready for the Pathfinder DB this week. As such, feel free to pester me with any and every problem you can find so we have as clean a version as possible going "official" to the DB.

Also in this iteration, I fixed the double weapon issue. I also simplified the damage for double weapons to either the fixed amount (for those with only one value) or I created one entry for each damage type (e.g. the gnome hooked hammer).

And as a special bonus for anyone running Legacy of Fire, the pugwampi is now a playable race...just set the 1st class level as Fey and you're good to go! I've got the gnolls in there as well, and will be adding flinds, janni, etc. Gotta keep the support on for my home game!

Sovereign Court Wayfinder, PaizoCon Founder

Hey, this is looking great! I just reentered my drow noble for SKR's game, since we leveled to 14th. Good to see the inquisitor all in there! Thanks!

Couple things: in calculating my Melee and Ranged totals, there were "2"'s in the Size boxes. I have no idea why. Also, the calculations for my weapons "to hit" totals were off. I am thinking that the multiclassing with assassin (3) and inquisitor (11) levels didn't help, but I was getting an extra +3 to hit after accounting for the multiclassing issue.

Hey, not that I don't like a higher "to hit" bonus, but I'm not really seeing where that extra bonus is coming from.

Outside of that, and slight adjustments to the print area (clipping on the right), this spreadsheet version is very nice, and I'm looking forward to using my print outs next session!

Tim


Timitius wrote:

Hey, this is looking great! I just reentered my drow noble for SKR's game, since we leveled to 14th. Good to see the inquisitor all in there! Thanks!

Couple things: in calculating my Melee and Ranged totals, there were "2"'s in the Size boxes. I have no idea why. Also, the calculations for my weapons "to hit" totals were off. I am thinking that the multiclassing with assassin (3) and inquisitor (11) levels didn't help, but I was getting an extra +3 to hit after accounting for the multiclassing issue.

Hey, not that I don't like a higher "to hit" bonus, but I'm not really seeing where that extra bonus is coming from.

Outside of that, and slight adjustments to the print area (clipping on the right), this spreadsheet version is very nice, and I'm looking forward to using my print outs next session!

Tim

Thanks!

Now, I just put in a Inq 11 / Ass 3 and got a BAB of 10 (which is what I'd expect). Is it possible you had either Enlarge or Reduce selected in the Spells & Effects section? This would alter your size, and thus the Size modifier to attacks. Combine this with the fact that in checking this I noticed the Size table got skewed by adding the Fly skill adjustment from size and some odd numbers were showing up. Beyond that, I don't currently see anything that would have caused an issue. If this is not the problem, could you either (a) walk me through the steps you used for entering the character or (b) shoot the sheet to me for a look?

For the print area issue, which sheet is showing this problem? I checked them all and except for the Spells sheet they looked good.


erian_7 wrote:
For the print area issue, which sheet is showing this problem? I checked them all and except for the Spells sheet they looked good.

I have this issue too. To print the full "Front" sheet, I have to scale it down slightly to fit the page. I'm using MS Office 2008 on Mac OS X.


Logan Voralius wrote:
erian_7 wrote:
For the print area issue, which sheet is showing this problem? I checked them all and except for the Spells sheet they looked good.
I have this issue too. To print the full "Front" sheet, I have to scale it down slightly to fit the page. I'm using MS Office 2008 on Mac OS X.

I should also add that the last sheet version I used was 0.7.15.7.

Lantern Lodge

Very nice work with the new character sheet.

Just two or three things I saw while testing the animal companions :
I didn't find how to input the ability boosts the animal should have at level 4, 9, 14 and 20.
The intelligence of the Paladin Mount should be 6 not 10.
The skill points by level of an animal companion with 10 in intelligence should be 2 for each DV not 1.


Logan Voralius wrote:
erian_7 wrote:
For the print area issue, which sheet is showing this problem? I checked them all and except for the Spells sheet they looked good.
I have this issue too. To print the full "Front" sheet, I have to scale it down slightly to fit the page. I'm using MS Office 2008 on Mac OS X.

Hmm, that's odd. Must be a difference in how the OS handles page layout. I'll switch the scale to 1 page by 1 page rather than automatic and see if that works.

Ushoran wrote:

Very nice work with the new character sheet.

Just two or three things I saw while testing the animal companions :
I didn't find how to input the ability boosts the animal should have at level 4, 9, 14 and 20.
The intelligence of the Paladin Mount should be 6 not 10.
The skill points by level of an animal companion with 10 in intelligence should be 2 for each DV not 1.

Good catches. I've fixed the Intelligence and skill point issues and will look into the best place to put those ability boosts.

Sovereign Court Wayfinder, PaizoCon Founder

erian_7 wrote:

Thanks!

Beyond that, I don't currently see anything that would have caused an issue. If this is not the problem, could you either (a) walk me through the steps you used for entering the character or (b) shoot the sheet to me for a look?

For the print area issue, which sheet is showing this problem? I checked them all and except for the Spells sheet they looked good.

Of course, I will "shoot the sheet" with you! ;-)

I'll send you my file later today. I suspect it is partially that size table issue. My solution was to simply delete that cell, but that doesn't really help you.

Heaped up on that is a keen rapier +2, being a drow noble, and having several combat feats to boot. So, yeah, I'll send it to you for a better look-see.

The print issue was on the Front sheet, to the right. It clipped off about half of that far right column on conditional modifiers for skills. It was no biggie...I just adjusted it with page break preview. The Spells page was a bit worse; it divided that page into 4 pages...again, a page break preview adjustment, and all was good.

I should add that I am using Excel 2007.


THE problem I've got is that Excel crashes whenever I attempt to open the last few versions of the sheet I've downloaded (0.7.15.5., 0.7.15.6. & 0.7.15.8) but they seem to work fine in Open Office 3.2.


Morgan Champion wrote:
THE problem I've got is that Excel crashes whenever I attempt to open the last few versions of the sheet I've downloaded (0.7.15.5., 0.7.15.6. & 0.7.15.8) but they seem to work fine in Open Office 3.2.

What version of Excel are you using? Does it return any errors, or just fails to open?

For all, I've got the framework of the eidolon complete and am about 25% through automating the evolutions. Once that's done, we should be good to go for the various companion-type creatures.


Erian: Doing large scale page layout in Excel is the road to madness.

Here's why.

Excel on Windows is completely, blissfully, unaware of the printable area of the data in any kind of outside measuring system.

When you size a column, it gives you two numbers. One of them is pizels (based on your current screen resolution), and the other is a mystery number.

That mystery number is the multiple of the width of the 0 character in whatever font Excel has listed as its default setting. This was Arial 10 point in 2003 and earlier, and Callibri 11 point in 2007. Even worse, there are four different versions of Arial that Microsoft has distributed with Windows, each with slightly different kerning.

Couple that with variance in how whatever printer is hooked up handles printable area on the page and life gets unpleasant.

Excel for Mac actually gives dimensions in points, because the display and rendering in MacOS X is built off of display Postscript. (This is also why Macs can make PDFs natively from a lot of applications; it's taking a postscript screen shot.)

I know this because I've been bitten on it, badly.


A couple minor bugs to note:

My wizard has a 10% spell failure chance and the text box seems too small to display it correctly.

For some reason "FALSE" shows up just before the cantrips in my class abilities (I'm a universalist if that makes a difference)

When selecting the Arcane Duelist option, Scribe Scroll should be removed from the list of known feats.


Tem wrote:

A couple minor bugs to note:

My wizard has a 10% spell failure chance and the text box seems too small to display it correctly.

For some reason "FALSE" shows up just before the cantrips in my class abilities (I'm a universalist if that makes a difference)

When selecting the Arcane Duelist option, Scribe Scroll should be removed from the list of known feats.

Heh, everybody's been fiddling so much with the fancy new classes the poor universalist wizard has been neglected...fixed all of these!

AAG, I'm hoping that setting the page layout to an actual limit rather than Automatic will help, since this apparently only happened on the two pages previously set to Automatic. Have you ever tried that route with any success?

And for all, my OCD kicked in and I decided to clean up the Character Options feat selection process a bit. That led to 3 hours rebuilding the overall functionality so that you can now show only qualified feats or all feats in the drop-down. You can also set each non-core source as available for use or not. If you set a source to "No" the feat is marked non-qualified. Since folks might want to use the qualified-only list but also look around at feats, I also built a little "feat checker" that will show you both the summary description and prerequisites.

Landscape Character Sheet File: PRPG_CS_L_v_0_7_15_9.zip

No, I'm off to bed--I'll focus on the eidolon evolutions tomorrow (you can fiddle with the current functionality, but I don't have the evolutions in any sort of drop-down as yet) and should have a "final" draft out for everyone to check over the weekend. I'm close enough now that I think I can reliably set Monday as the target for getting the next version up to the Pathfinder DB, so eveyone keeping hammering until that time!

851 to 900 of 1,732 << first < prev | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | next > last >>
Community / Forums / Pathfinder / Pathfinder First Edition / Homebrew and House Rules / erian_7's Excel-based Character Sheet All Messageboards

Want to post a reply? Sign in.