Paizo Top Nav Branding
  • Hello, Guest! |
  • Sign In |
  • My Account |
  • Shopping Cart |
  • Help/FAQ
About Paizo Messageboards News Paizo Blog Help/FAQ
Pathfinder Roleplaying Game
Pathfinder Society

Pathfinder Beginner Box

Pathfinder Adventure Card Game

Pathfinder Comics

Pathfinder Legends

RPG Superstar 2015

erian_7's Excel-based Character Sheet


Suggestions/House Rules/Homebrew

1,201 to 1,250 of 1,732 << first < prev | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | next > last >>

Request: could we get a couple more weapons and attacks modules in the nonprintable area of the front sheet? The more, the merrier.

Zo


Trying out a new character with version 0.8.9, I found that at least in one case the sheet fails to acknowledge "minimum of 1."

Under the class abilities printable box, the 1st level Cleric Ability Touch of Darkness says it lasts for 0rounds for a 1st level Cleric.

I suspect there are others like that.


Running 8.9 now, and I see the Headband of Vast Intellect and how you handled the granted skills, and I like it, quite elegant. But there's a problem. 16 Base INT + 4 for the headband gives a 20 INT. Bonus spells on your Spells page still only show a bonus to cast per day for an INT 16. Does the Headband not increase that, or did I misread a rule somewhere?


Hi Erian_7,
I'm new to all this, great job, really.

I started today using your tool for a 2 characters, a witch and a summoner.

Everything runs smoothly but 2 small things:
1) the cloak of resistance +1 doesn't increase saves
2) about the Large Eidolon: I think it's matter of adding:
+IF(Eidolon_Size="Large",8,0) for Str, and the others skill + NA, at least that's what I did and it's ok...

Now, I don't know if these suggestions are the kind of things you need for your feedback or we must be more specific, or we should try to correct and send you a solution... just tell me.

Thanks

Dark Archive

I built a 1st level monk and tried to equip a hanbo. It gave a -4 penalty to attacks. I tried with a temple sword and it gave -4 penalty to attacks. I then looked at the data_equipment tab and found that all non-core monk weapons were coming up as false. Is there a button I'm supposed to click or box to check to fix this?

Liberty's Edge

Pathfinder Adventure Path Subscriber

Did your character have exotic weapon prof in them? They are "monk" weapons, but are not default weapon proficiencies for the starting monk. That weapon list remained unchanged.

I encountered this when it was just the Temple Sword from the campaign setting. It turned out that "monk weapon" just means you can flurry with it, not that you automatically are proficient.


KSAC wrote:
KSAC wrote:

Hello there. We're just starting up a Kingmaker campaign and I'm amazed of what you've been able to accomplish in Excel. Wow.

Anyway, here's my questions:

1) I am creating a first level Summoner. Unfortunately on both my P-Abilities & Feat tabs and L-Abilities & Feat tabs, the Class Abilities says "#NAME?"

2) For my Eidolon, when I select Improved Bite Damage, it changes the die for my CLAWS from d4 to d6. Instead it should change the BITE damage from d6 to d8.

Any idea what can I do to fix these issues?

I forgot to mention that I'm using version 0_8_9

If erian_7 hasn't tracked it down yet, here's a fix (I think it's in fact *the* fix) for 1):

If you are using Windows Excel, change the formula in 'Class Abilities'!D449 by putting double quotes around the upper-case I in the next-to-last IF() function:
i.e. change the substring
IF(Lvl_Sum>2,"II",I)
to
IF(Lvl_Sum>2,"II","I")

I don't know about Open Office or Mac, but I expect the fix is very similar.


David Empey wrote:
KSAC wrote:
KSAC wrote:

Hello there. We're just starting up a Kingmaker campaign and I'm amazed of what you've been able to accomplish in Excel. Wow.

Anyway, here's my questions:

1) I am creating a first level Summoner. Unfortunately on both my P-Abilities & Feat tabs and L-Abilities & Feat tabs, the Class Abilities says "#NAME?"

2) For my Eidolon, when I select Improved Bite Damage, it changes the die for my CLAWS from d4 to d6. Instead it should change the BITE damage from d6 to d8.

Any idea what can I do to fix these issues?

I forgot to mention that I'm using version 0_8_9

If erian_7 hasn't tracked it down yet, here's a fix (I think it's in fact *the* fix) for 1):

If you are using Windows Excel, change the formula in 'Class Abilities'!D449 by putting double quotes around the upper-case I in the next-to-last IF() function:
i.e. change the substring
IF(Lvl_Sum>2,"II",I)
to
IF(Lvl_Sum>2,"II","I")

I don't know about Open Office or Mac, but I expect the fix is very similar.

That was perfect. Any idea about #2?


KSAC wrote:
David Empey wrote:
KSAC wrote:
KSAC wrote:

Hello there. We're just starting up a Kingmaker campaign and I'm amazed of what you've been able to accomplish in Excel. Wow.

Anyway, here's my questions:

[snip]

2) For my Eidolon, when I select Improved Bite Damage, it changes the die for my CLAWS from d4 to d6. Instead it should change the BITE damage from d6 to d8.

Any idea what can I do to fix these issues?

[snip]

[snip]Any idea about #2?

I can't quite figure out what you're seeing. Where is the CLAW damage for the eidolon listed? I only see bite damage, in the "Attacks" cell on the P-Eidolons sheet. Admittedly this doesn't change when I pick improved bite. I must not be using the same settings you are.

Lantern Lodge

So I'm having few issues with the spread sheet so far that I'm wondering if any one else has worked around and how?

1) Barbarian Rage? Anyone figured a way toggle rage on and off and be level appropriate?
2) Barbarian Damage Reduction/Speed are not appearing on the character sheet?

Shadow Lodge

Hello Erian,

In v0_8_9 I'm not seeing "Sawtooth Sabre [Light]" listed in the drop menu/textbox for "Exotic Weapon Proficiencies". The list starts with "Swordbreaker Dagger" and goes from there, but I'm not seeing Sawtooth Sabre[Light]. However, it does appear on the (Portrait) Front page as a Weapon Selection "Sawtooth Sabre [Light]", and it's showing up as a "Martial Weapon Proficiency (Sawtooth Sabre [Light]).


On the portrait sheet, the Misc 2 and Misc 3 AC fields aren't functional. Misc 1 works fine.

Zo

Sovereign Court

Solitude wrote:
What would make me happier is a "how to" for adding more magical items : I tried adding more in the "DataMagicItems" sheet, but they don't appear in the choices by type (ex : I added a "body slot" magic item, but can't see it in the dropdown menu for Body magic items).

Upping my question... :D


Herr Malthus wrote:


1) the cloak of resistance +1 doesn't increase saves

I quote myself...

Found why, it works in Landscape character sheet but not in the Portrait one.

Now, it seems that you want to have these 2 visualization (Portrait and Landscape) and probably you prefer the L-one since it seems to be the most updated in terms of formulae.
Keeping both up to date requires double work.
I'm not sure if this is a trivial suggestion (I mean, I don't know well the mechanics of your sheet) but if you would just work on the L-one and for the P-one you'd just do (for each cell) P_cell = L_cell, this could make you just work on the L-one...

Example for Reflex save, 'OTHER' field:
L-Front cell is the BS53
P-Front cell is BP33
in BP33 P-Front cell you put ='L-Front'!BS53 and it's done once for all...

If this is a stupid non-sense, please forgive me...


Solitude wrote:
Solitude wrote:
What would make me happier is a "how to" for adding more magical items : I tried adding more in the "DataMagicItems" sheet, but they don't appear in the choices by type (ex : I added a "body slot" magic item, but can't see it in the dropdown menu for Body magic items).
Upping my question... :D

Solitude, my guess is that you probably need to add items by inserting a row *above* the last row of items, and putting the item info in the new blank row. This should automatically update the magic item range names to include all the items. You'll want to check you can still pick Wings of Flying, though.


Hi all, wanted to pop in so you don't think I've fallen of the face of the planet!

Between my home game this past weekend double-booked with our local meet-up, a room make-over at our house, tons of work that is all due at the same time, and a nasty cold I'm not making any headway on the sheet...

Now, I'm getting tired of my own excuses for not having things updated, so I know y'all can't be happy campers. I will hopefully have a flurry of productivity on the sheet over the next week or so to make up lost time.

And of course I'll be looking into all reported bugs.

Thanks!

Liberty's Edge

Pathfinder Adventure Path Subscriber

One thing I have noted. I used the portrait one exclusively and noticed that the shield bonus never shows up on the AC on the front sheet. I have the shield set as readied on the back sheet. I don't know enough about the excel stuff to locate the problem.


Bug: I have taken the dodge feat, but it is not showing up as calculated in my AC.


CulinaryMadman wrote:
Running 8.9 now, and I see the Headband of Vast Intellect and how you handled the granted skills, and I like it, quite elegant. But there's a problem. 16 Base INT + 4 for the headband gives a 20 INT. Bonus spells on your Spells page still only show a bonus to cast per day for an INT 16. Does the Headband not increase that, or did I misread a rule somewhere?

The headband should increase bonus spells if it is worn for more than 24 hours (which we assume it is). http://www.d20pfsrd.com/basics-ability-scores/ability-scores#TOC-Ability-Sc ore-Bonuses

Fix:
Change L-Front:AV34 from "=Int_L-MAX(Enhancement_Int_L,Magic_Item_Ability_Enhancement_Int)"
to "=Int_L - IF(Enhancement_Int_L>Magic_Item_Ability_Enhancement_Int,Enhancement_Int_ L-Magic_Item_Ability_Enhancement_Int,0)"

and P-Front:I25 from "=Int_P_14-MAX(Enhancement_Int_P_14,Magic_Item_Ability_Enhancement_Int)"
to "=Int_P_14 - IF(Enhancement_Int_P_14>Magic_Item_Ability_Enhancement_Int,Enhancement_I nt_P_14-Magic_Item_Ability_Enhancement_Int,0)"

Another issue: for Mithril (and Darkwood) items, the cost is being calculated incorrectly, as (base cost) + (base cost) * 500 for mithril. (there is also a correction for the free MW, but that is correct.) Here's the fix, as applied to K74 on P-Front:
=(IF(W75="Cold Iron",VLOOKUP(B75,Table_Weapons,MATCH("Cost",Header_Weapon,0),0)*2,VLOOKUP( B75,Table_Weapons,MATCH("Cost",Header_Weapon,0),0))+IF(T75="",0,VLOOKUP(T75 ,Table_Weapon_Benefit,2,0))+IF(AND(W75="Cold Iron",AND(ISNUMBER(T75),T75>0)),2000,0)+IF(W75="Silver",IF(N81="Light",2 0,IF(N81="1-handed",90,IF(N81="2-handed",180,0))))+IF(W75="Mithral",Max(VLO OKUP(B75,Table_Weapons,MATCH("Weight",Header_Weapon,0),0)*IF(AD75="",1,VLOO KUP(AD75,Table_Size,MATCH("Wgt",Header_Size,0),0))*500-300,200),0)+IF(W75=" Darkwood",VLOOKUP(B75,Table_Weapons,MATCH("Weight",Header_Weapon,0),0)*IF(A D75="",1,VLOOKUP(AD75,Table_Size,MATCH("Wgt",Header_Size,0),0))*10,0)+IF(W7 5="Adamantine",2700,0))*AI75

I made a judgement call which is not explicitly stated in the rules: a mithral weapon, no matter how light, always costs at least 500 more than the base weapon (i.e. 200 more than the masterwork item).


Okay, I've completed all the core rules slotted magic items (I think, let me know if I missed one...). Next pass will focus on non-slotted items, adding new feats/traits from my latest books, and of course bug fixes...Once the core magic items are in, I'll release v.0.9 and move to the Spells & Effects work.

Also, all issues reported to date have been addressed. Specifically:

  • Boon Companion added to Animal_Companion_Level and Familiar_Level calcs.
  • feat pre-reqs now look for Animal_Companion_Level or Familiar_Level
  • consolidated all channel energy entries to use Channel_DC field
  • corrected Touch of Darkness minimum rounds
  • refined logic for temporary versus “permanent” Enhancement bonuses (e.g. Int should now properly flow through to grant bonus spells)
  • consolidated Other modifiers for saves to master entry (flows properly to L and P sheets)
  • corrected Summoner Summon Monster class ability formula (thanks for the quick-fix David!)
  • corrected Barbarian movement bonus when unarmored
  • List_Weapon_Prof_Exotic corrected
  • corrected Misc 2 and Misc 3 AC field usage on P-Front
  • corrected Shield bonus on P-Front
  • corrected mithral and darkwood weapon costs (thanks Brendan!)

EDIT: Hmm, my FTP server is down, or at least I can't connect to it. I'll have v.0.8.10 uploaded with all these changes as soon as I get back into the server...

DigMarx wrote:

A suggestion for the future: in the customization tab, add an drop-down menu to fill the fields with a preexisting item (TOS+ calls it "quickfill). This would make it easier to base custom classes, armor, etc. on existing ones.

Zo

I can’t do this one, because it would require macros to auto-fill cells…

Xyemox wrote:

Tired using the Perm Mod field on the Front as you recommended, but it did not work right. several of the bonuses are calculated from the "getting started" page so none of the added Perm Mods get added correctly. This includes attack bonuses, Saves, CMB, and CMD, there could be others but I stopped using the form at that point and went back to manual creation.

It works great for everything else I have tried it for. keep up the good work and thank you. I could not have figured out how to do something like this if my life depended on it.

Thanks, although I’m not sure what you mean exactly…adding a value to the Perm Mod field definitely flows through to all of these fields. Did you, perhaps, use the Portrait sheet, but had the Getting Started Active Sheet selector set to Landscape?

xevious573 wrote:

I really like your character sheet here. I caught a few things so far you might want to take a look at. v0.8.9

1st - When I was making a monk and I set my unarmed attack on Landscape Front Page and I set it so flurry of blows was activated, it didn't register as full BAB with a -2 penalty nor did it show the extra attacks. I have some thoughts what I may have been missing and if you could alert me of that that'd be appreciated

2nd - I could be wrong on this, but it says that monks unarmed strikes count as both natural and manufactured weapon for spells and effects that increase damage and such. This makes me under the impression that Monks can benefit from Improved Natural Attack (unarmed strike). I could of course be wrong on this point though I don't think I am.

See the FAQ page on Flurry of Blows—I’m betting you only had one weapon block set? Flurry works just like two-weapon fighting and requires to weapon blocks. As for Improved Natural Attack, “official” ruling at present from Paizo is that it does not apply.

xevious573 wrote:

3rd - When making a summoner's Eidolon, my quadrupedal is unable to select claw attacks. I checked the logic for this and it seems it's checking for either bipedal (which has arms) or the arms evolution. Quadrupeds can get claws but if they want any more pairs after the first they need to start taking arm evolutions as leg evolutions can only hold one pair of claws.

3rd - The Eidolon is have some issues with size changes and recognizing when the huge or large is or isn't selected. In addition it doesn't modify the stats properly when the size of the creatures is increased. Damage of natural attacks is increased but these only kinda (this being very important here) take into account the Improved Natural Attack feat and/or Improved Claw or Bite evolution.

4th - If you could increase amount of boxes in the following areas (The manual bonus feat slots, the boxes available for eidolon evolutions, the box listing the number of attacks an eidolon can have (keep in mind they can have a maximum of 8 attacks)

Anyway you're doing an excellent job and I appreciate what you're doing.

Items noted for future work on the eidolon—I’m not doing too much with it as yet since the APG will be out soon and I can put in the final data vs. beta…

Harkaelian wrote:
Falcata = X3 crit. multiplier not X2

The Adventurer’s Armory entry (the update for PRPG) reduces it to x2.

DigMarx wrote:

Request: could we get a couple more weapons and attacks modules in the nonprintable area of the front sheet? The more, the merrier.

Zo

Sure. I’m actually looking into how these can be properly written so you can replicate as many as you want…

Herr Malthus wrote:

Now, I don't know if these suggestions are the kind of things you need for your feedback or we must be more specific, or we should try to correct and send you a solution... just tell me.

Thanks

I work with whatever info you can provide—no need to necessarily solve the problem, but giving specifics does sometimes help me diagnose trickier issues. If I come to something I can’t figure out, however, I’ll always ask for more info. So don’t worry about fixing the problem unless you just enjoy that sort of thing…

Galnörag wrote:

So I'm having few issues with the spread sheet so far that I'm wondering if any one else has worked around and how?

1) Barbarian Rage? Anyone figured a way toggle rage on and off and be level appropriate?
2) Barbarian Damage Reduction/Speed are not appearing on the character sheet?

I’ll be adding Rage as one of the effects you can select in the Spells & Effects section to automate it…

I corrected the speed issue (I’m guessing you hadn’t used any armor?) but note that the DR field is open for any data entry—there are so many ways to get DR that I haven’t automated anything there as yet.

Herr Malthus wrote:

I quote myself...

Found why, it works in Landscape character sheet but not in the Portrait one.

Now, it seems that you want to have these 2 visualization (Portrait and Landscape) and probably you prefer the L-one since it seems to be the most updated in terms of formulae.
Keeping both up to date requires double work.
I'm not sure if this is a trivial suggestion (I mean, I don't know well the mechanics of your sheet) but if you would just work on the L-one and for the P-one you'd just do (for each cell) P_cell = L_cell, this could make you just work on the L-one...

Example for Reflex save, 'OTHER' field:
L-Front cell is the BS53
P-Front cell is BP33
in BP33 P-Front cell you put ='L-Front'!BS53 and it's done once for all...

If this is a stupid non-sense, please forgive me...

That’s actually close to what I’m doing—for all values common to both sheets, I am creating a master value and referencing that. For all values that might be sheet-dependent, I’m working to ensure you can do all the data entry on the appropriate sheet, rather than having to flip between the two. For the Ref saves, for instance, both the L and P Front tabs now point to the Ref_Other field.

David Empey wrote:
Solitude wrote:
Solitude wrote:
What would make me happier is a "how to" for adding more magical items : I tried adding more in the "DataMagicItems" sheet, but they don't appear in the choices by type (ex : I added a "body slot" magic item, but can't see it in the dropdown menu for Body magic items).
Upping my question... :D
Solitude, my guess is that you probably need to add items by inserting a row *above* the last row of items, and putting the item info in the new blank row. This should automatically update the magic item range names to include all the items. You'll want to check you can still pick Wings of Flying, though.

This is correct. If you want to add magic items, you’ll simply follow the format on that table, but you must make sure the data is above the last line on the table. This is because the named lists/tables will otherwise not pick up your new entries.

whiter73 wrote:
Bug: I have taken the dodge feat, but it is not showing up as calculated in my AC.

Did you type the word “Dodge” or “DODGE” in the field? As noted, certain feats must currently be entered in ALL-CAPS due to other feats containing the same name, such as Dodge and Swarm Dodger…


Brendan Furneaux wrote:
CulinaryMadman wrote:
Running 8.9 now, and I see the Headband of Vast Intellect and how you handled the granted skills, and I like it, quite elegant. But there's a problem. 16 Base INT + 4 for the headband gives a 20 INT. Bonus spells on your Spells page still only show a bonus to cast per day for an INT 16. Does the Headband not increase that, or did I misread a rule somewhere?

The headband should increase bonus spells if it is worn for more than 24 hours (which we assume it is). http://www.d20pfsrd.com/basics-ability-scores/ability-scores#TOC-Ability-Sc ore-Bonuses

Fix:
Change L-Front:AV34 from "=Int_L-MAX(Enhancement_Int_L,Magic_Item_Ability_Enhancement_Int)"
to "=Int_L - IF(Enhancement_Int_L>Magic_Item_Ability_Enhancement_Int,Enhancement_Int_ L-Magic_Item_Ability_Enhancement_Int,0)"

and P-Front:I25 from "=Int_P_14-MAX(Enhancement_Int_P_14,Magic_Item_Ability_Enhancement_Int)"
to "=Int_P_14 - IF(Enhancement_Int_P_14>Magic_Item_Ability_Enhancement_Int,Enhancement_I nt_P_14-Magic_Item_Ability_Enhancement_Int,0)"

Should the same changes be made for STR, CON, DEX, WIS, and CHA?


David Empey wrote:
Should the same changes be made for STR, CON, DEX, WIS, and CHA?

The new sheet uses the same approach for all abilities. It looks like AT&T has changed something on my service, so now I can't FTP into my own freaking site!

I wonder if they're trying to save bandwidth for the iPhone 4 folks...

Anyway, this pretty much does it for me and AT&T's site, I think. I'm looking into switching over to something else right now, and will have the new file up shortly...


erian_7 wrote:
David Empey wrote:
Should the same changes be made for STR, CON, DEX, WIS, and CHA?

The new sheet uses the same approach for all abilities. It looks like AT&T has changed something on my service, so now I can't FTP into my own freaking site!

I wonder if they're trying to save bandwidth for the iPhone 4 folks...

Anyway, this pretty much does it for me and AT&T's site, I think. I'm looking into switching over to something else right now, and will have the new file up shortly...

You might want to take a look at the formula for computing Eidolon Evolution Descriptions, in P-Eidolons!A46, where I think you have an erroneous IF() clause, specifically IF(ISTEXT(BH14), which I think should be IF(BH14="",""

As it stands, the formula gives a result of FALSE when no evolutions are selected.


David Empey wrote:
erian_7 wrote:
David Empey wrote:
Should the same changes be made for STR, CON, DEX, WIS, and CHA?

The new sheet uses the same approach for all abilities. It looks like AT&T has changed something on my service, so now I can't FTP into my own freaking site!

I wonder if they're trying to save bandwidth for the iPhone 4 folks...

Anyway, this pretty much does it for me and AT&T's site, I think. I'm looking into switching over to something else right now, and will have the new file up shortly...

You might want to take a look at the formula for computing Eidolon Evolution Descriptions, in P-Eidolons!A46, where I think you have an erroneous IF() clause, specifically IF(ISTEXT(BH14), which I think should be IF(BH14="",""

As it stands, the formula gives a result of FALSE when no evolutions are selected.

Thanks, I'll look into that along with the other eidolon revisions I need to do. The biggest work for both eidolons and familiars is that they should have full access to far more feats...

And now, the new sheet via Google Sites:

PRPG_CS_v_0_8_10.zip

Liberty's Edge

Yes!!! You are still alive :p

Thanks for the newest version and Google FTW!


Thanks are due yet again. So...thanks!

Zo


This is my first time playing around with your spreadsheet. I noticed a few bugs.

#1: Dex related feats are unavailable even though my prototype has a 15 Dex (I have only confirmed this with Two-Weapon Fighting and Dodge.
#2: Providing a Strength of 17 (point buy), +2 from Human, and +1 from 4th level only yields a Strength of 19. (The error appears to be the level adjustment, but I am not well versed in Excel)
#3: The stats provided on the Getting started tab are not reflected on the L-Front tab. Is it the intention we update that ourself?

Otherwise, I like the usability of the sheet so far.

Lantern Lodge

Quote:

Galnörag wrote:

So I'm having few issues with the spread sheet so far that I'm wondering if any one else has worked around and how?
1) Barbarian Rage? Anyone figured a way toggle rage on and off and be level appropriate?
2) Barbarian Damage Reduction/Speed are not appearing on the character sheet?

I’ll be adding Rage as one of the effects you can select in the Spells & Effects section to automate it…
I corrected the speed issue (I’m guessing you hadn’t used any armor?) but note that the DR field is open for any data entry—there are so many ways to get DR that I haven’t automated anything there as yet.

Was this in the most recent release or coming soon?


PJOsano wrote:

Yes!!! You are still alive :p

Thanks for the newest version and Google FTW!

DigMarx wrote:

Thanks are due yet again. So...thanks!

Zo

Yes, I'm still here, although this week was, I think, trying to kill me! And my thanks to you both for the continued support! As for Google, yep...I'm not sure why I've stuck with that AT&T server for so long. Habit I guess.

Torinath wrote:

This is my first time playing around with your spreadsheet. I noticed a few bugs.

#1: Dex related feats are unavailable even though my prototype has a 15 Dex (I have only confirmed this with Two-Weapon Fighting and Dodge.
#2: Providing a Strength of 17 (point buy), +2 from Human, and +1 from 4th level only yields a Strength of 19. (The error appears to be the level adjustment, but I am not well versed in Excel)
#3: The stats provided on the Getting started tab are not reflected on the L-Front tab. Is it the intention we update that ourself?

Otherwise, I like the usability of the sheet so far.

Hmm, these are odd, so I may need a little more info. I just opened the latest release and did the following:

  • Set STR to 17
  • Set Dex to 15
  • Set race to Human
  • Set Ability Bonus to Str
  • Added 4 levels of Fighter
  • Set 1st level feat to Two-Weapon Fighting
  • Set 4th level ability bump to Strength

After this, L-Front shows Str 20, Dex 15. Everything seems to be working as expected, so there's definitely something wonky going on with yours.

So, a few questions/suggestions...did you do anything other than the above? Can you walk through just these steps and see if it works? What application and OS are you using? After digging in a bit, I may be able to figure out what's causing the issues (and of course fix it if it is indeed a bug!).

Thanks for trying out the sheet, and definitely keep the feedback coming!

Galnörag wrote:
Quote:

I’ll be adding Rage as one of the effects you can select in the Spells & Effects section to automate it…

I corrected the speed issue (I’m guessing you hadn’t used any armor?) but note that the DR field is open for any data entry—there are so many ways to get DR that I haven’t automated anything there as yet.
Was this in the most recent release or coming soon?

Coming soon. Specifically in the next major iteration (i.e. v.0.9.x) when I shift to working on the spells and effects. Now, I might fiddle around with something if I get a chance, so it could be sooner. But getting class-related effects in place is one of my first goals for the .9 set.


2 requests for v.9: implement the Travel domain movement bonus so that it works with haste and eventually other effects. I might have mentioned this before, so disregard if I did. Also, add a "shield readied" selector (checkbox or drop-down) to the AC section for laptop use (or perhaps just flag 2-handed weapons w/ red text rather than "cannot wield") as this would make it much more convenient. Ideally, most aspects of combat could be run from one sheet.

Zo

Liberty's Edge

Request for future version:

I tend to use the portrait orientation for the character sheets and I noticed that the description for feats, class abilities, etc. are set for the landscape; The portrait version has some of the descriptors run outside of the box.

Thanks


PJOsano wrote:

Request for future version:

I tend to use the portrait orientation for the character sheets and I noticed that the description for feats, class abilities, etc. are set for the landscape; The portrait version has some of the descriptors run outside of the box.

Thanks

I've mentioned this problem to Erian_7 before and he's working on it. Are you using Excel 2003 like I am? My wife's got 2007 on her laptop and it doesn't have the same issue.

Zo


DigMarx wrote:

2 requests for v.9: implement the Travel domain movement bonus so that it works with haste and eventually other effects. I might have mentioned this before, so disregard if I did. Also, add a "shield readied" selector (checkbox or drop-down) to the AC section for laptop use (or perhaps just flag 2-handed weapons w/ red text rather than "cannot wield") as this would make it much more convenient. Ideally, most aspects of combat could be run from one sheet.

Zo

Yep, ideally all of the class abilities will be selectable (only when available to that character) and will interact with spells and such.

For the shield selector, I started to say it's already running from one sheet since the selector is in the shield section, but I'm guessing you are using the portrait view (the landscape view is "optimized" for laptop use as it's dimensions more closely match the size of a laptop screen)? I could move it up to the AC section somewhere--let me check on how much space is available.

DigMarx wrote:
PJOsano wrote:

Request for future version:

I tend to use the portrait orientation for the character sheets and I noticed that the description for feats, class abilities, etc. are set for the landscape; The portrait version has some of the descriptors run outside of the box.

Thanks

I've mentioned this problem to Erian_7 before and he's working on it. Are you using Excel 2003 like I am? My wife's got 2007 on her laptop and it doesn't have the same issue.

Zo

Yep, and right now I have absolutely no idea how to easily fix this. Something about Excel 2003 is causing the text to not wrap properly. It seems to be tied to a overall character count for the cell, as the text wraps fine up to a point. Very irritating...


Eidolon - Tentacle evolutions dont show the attacks in the attack box.
If you have bite attack and 3x tentacle attacks, the attack box only shows bite attack.

Version 0.8.10


Thanks, I think I may have saved it in the wrong format. I redownloaded it and it worked fine. I have another question.

Where do we input the Fighter Bonus Feats?


erian_7 wrote:


DigMarx wrote:
PJOsano wrote:

Request for future version:

I tend to use the portrait orientation for the character sheets and I noticed that the description for feats, class abilities, etc. are set for the landscape; The portrait version has some of the descriptors run outside of the box.

Thanks

I've mentioned this problem to Erian_7 before and he's working on it. Are you using Excel 2003 like I am? My wife's got 2007 on her laptop and it doesn't have the same issue.

Zo

Yep, and right now I have absolutely no idea how to easily fix this. Something about Excel 2003 is causing the text to not wrap properly. It seems to be tied to a overall character count for the cell, as the text wraps fine up to a point. Very irritating...

It's not exactly "easy", but I have a set of formulas that can break up a long string into pieces of N letters or less, breaking on spaces or line-feeds (i.e. between words). You could use this to put the abilities summary string into a column of cells, instead of one big merged cell. You'd need two more columns of cells plus a couple more single cells to hold the formulas.


erian_7 wrote:
...shield selector...portrait view...landscape view is "optimized" for laptop use

Yeah, I should really quit waffling and pick one view. I've been using the portrait view on my laptop as I like to have a printed copy at hand in case I'm using the laptop to look something up or run the initiative tracker I use. You know what, this isn't really an issue (unless others feel the same way) so don't worry about it, I'm sure you've got a bajillion other things to do.

However :) at some distant point in the future it'd be super cool if entries in L-Front showed up in P-Front, etc.

Zo


Oops, forgot to add that on P-front, AC section, the Misc 2 and 3 boxes don't modify "Other". Misc 1 seems fine.

Zo


hjorvar ingi haraldsson wrote:

Eidolon - Tentacle evolutions dont show the attacks in the attack box.

If you have bite attack and 3x tentacle attacks, the attack box only shows bite attack.

Version 0.8.10

Yet another item for the Summoner/eidolon update. I'm going to have to dedicate a whole sub-version just to that class!

Torinath wrote:

Thanks, I think I may have saved it in the wrong format. I redownloaded it and it worked fine. I have another question.

Where do we input the Fighter Bonus Feats?

Ah, that's good to hear--I like an easy fix!

For the fighter bonus feats, on the Getting Started tab you'll find a Class Options section down below the Skills section (there's a little + out to the side that expands the sections). Inside that, you'll find a sub-section for the Fighter.

David Empey wrote:
It's not exactly "easy", but I have a set of formulas that can break up a long string into pieces of N letters or less, breaking on spaces or line-feeds (i.e. between words). You could use this to put the abilities summary string into a column of cells, instead of one big merged cell. You'd need two more columns of cells plus a couple more single cells to hold the formulas.

Hmm, I would indeed be interested! If it'll fix my problem, I'm up for the work...

DigMarx wrote:

Yeah, I should really quit waffling and pick one view. I've been using the portrait view on my laptop as I like to have a printed copy at hand in case I'm using the laptop to look something up or run the initiative tracker I use. You know what, this isn't really an issue (unless others feel the same way) so don't worry about it, I'm sure you've got a bajillion other things to do.

However :) at some distant point in the future it'd be super cool if entries in L-Front showed up in P-Front, etc.

Zo

I was a hold-out on portrait views for a long time. After using the landscape for a while now, I definitely prefer it. But it took a lot to break 25 years of gaming instinct!

As for the stats showing from one sheet to the other, I am working to have as many common data items as possible cross-populate. The variance will come in selectable items like weapons, conditions, etc. since having those dynamic is a key feature for me...

DigMarx wrote:

Oops, forgot to add that on P-front, AC section, the Misc 2 and 3 boxes don't modify "Other". Misc 1 seems fine.

Zo

Must have missed those when I fixed the other fields. I'll get it!

Thanks one and all!


erian_7 wrote:


DigMarx wrote:

Yeah, I should really quit waffling and pick one view. I've been using the portrait view on my laptop as I like to have a printed copy at hand in case I'm using the laptop to look something up or run the initiative tracker I use. You know what, this isn't really an issue (unless others feel the same way) so don't worry about it, I'm sure you've got a bajillion other things to do.

However :) at some distant point in the future it'd be super cool if entries in L-Front showed up in P-Front, etc.

Zo

I was a hold-out on portrait views for a long time. After using the landscape for a while now, I definitely prefer it. But it took a lot to break 25 years of gaming instinct!

So, Erian: Do I get to withdraw one "I Told You So" from petty cash? :)

Even when playing with printed sheets, the Landscape config is easier to use.

(For those who weren't around 300+ messages ago, I kinda badgered Erian into a Landscape mode. Then badgered him again to do the Landscape mode corr... er, in a more ergonomic way. :) )


erian_7 wrote:


David Empey wrote:
It's not exactly "easy", but I have a set of formulas that can break up a long string into pieces of N letters or less, breaking on spaces or line-feeds (i.e. between words). You could use this to put the abilities summary string into a column of cells, instead of one big merged cell. You'd need two more columns of cells plus a couple more single cells to hold the formulas.

Hmm, I would indeed be interested! If it'll fix my problem, I'm up for the work...

Formulas:

long_text = a range with a long string of text to be word-wrapped.
wrap_length = a range holding the maximum line length.
(Potentially you could have a separate line length for every line, if you wanted that much control.)
I put those cells in A1 and B1 in my worksheet, so I start the actual formulas at row 2.
A2: 0
B2: =MID(long_text,A2+1,wrap_length)&CHAR(10)
C2: =LEN(B2)-LEN(SUBSTITUTE(B2," ",""))
D2: =MIN(FIND(CHAR(10),B2),IF(LEN(long_text)-A2<wrap_length,LEN(long_text)-A 2,IF(C2=0,wrap_length,FIND("|",SUBSTITUTE(B2," ","|",C2)))))
E2: =MID(long_text,A2+1,D2)
A3: =A2+D2
Columns B-E same as row 2 (but referring to row 3, of course)

Explanation:

Column A will hold the running total of how many characters we have processed, so in A2 we put the value 0, meaning we haven't processed anything yet.

B2: =MID(long_text,A2+1,wrap_length)&CHAR(10)
This is the next bit of long_text to process. The CHAR(10) at the end will be used later.

C2: =LEN(B2)-LEN(SUBSTITUTE(B2," ",""))
Counts the spaces in B2.

D2: =MIN(FIND(CHAR(10),B2),IF(LEN(long_text)-A2<wrap_length,LEN(long_text)-A 2,IF(C2=0,wrap_length,FIND("|",SUBSTITUTE(B2," ","|",C2)))))
This formula finds the first occurrence in B2 of either the next line-feed or the last space before the wrap_length.
Working from the inside out, the last Find function,
FIND("|",SUBSTITUTE(B2," ","|",C2)),
finds the location of the last space in B2. It assumes that "|" does not occur in B2. SUBSTITUTE() changes the C2-th space, i.e. the last space, to a "|", and FIND() finds the location of the "|", i.e. of the last space.
IF(C2=0, then there are no spaces and we just wrap at wrap_length, otherwise do the FIND.
IF(LEN(long_text...) takes care of the case where the last part of the long_text is shorter than the wrap_length.
FIND(CHAR(10),B2), finds the next line-feed, if any. If there's no line-feed, then it finds the end of B2, thanks to the CHAR(10) added to the end of B2.
MIN() picks the earliest of the next line-feed (if any) and the last space.

E2:=MID(long_text,A2+1,D2)
This gives the "wrapped" text.

Next line:
A3:=A2+D2
Computes how many characters have been processed.

etc.

Sovereign Court

Thanx David & Erian, I'll try that and confirm it works :)


AdAstraGames wrote:
So, Erian: Do I get to withdraw one "I Told You So" from petty cash? :)

Nope, I deny all knowledge of anything. Ever.

;^)

David Empey wrote:
Formulas...

Interesting...I'll try this out on a test run and see what's what...

Solitude wrote:
Thanx David & Erian, I'll try that and confirm it works :)

Thanks. And do let me know if you have more questions!


erian_7 wrote:


David Empey wrote:
Formulas...

Interesting...I'll try this out on a test run and see what's what...

One disadvantage is that this won't necessarily break the line on the last space before hitting the cell border. It might break too soon, if the line has a lot of narrow letters, or too late, if the line has wide letters. You could use a fixed-width font, but those look pretty ugly, especially when combined with proportional fonts.

Sovereign Court

I noticed a couple of things on my cavalier mount when working through your sheet.

Alertness doesn't appear on the list of feats it can take.

Josh Frost has stated that you get 4.5 HP per HD at level one. So a mount should have 2x4.5 + 2xCON HP at level one.

Liberty's Edge

i noticed an error on 8.10 yesterday and forgot to post it. languages seem to me off. i've got a tiefling rogue that's got an +4 INT modifier at lvl 1. so his base for INT before the racial modifiers is a +3. when you look at the languages and linguistics area, it says i only have 3 languages. a couple levels later i put a point in linguistics and it raised it to 4 available languages.

i'm by no means an expert in excel, but what it looks like to me is that the sheet is checking the INT modifier before racials are applied to determine the number of known languages.

Sovereign Court

Thunder and Fang style is not letting you equip the Klar as a shield. The Klar is properly recognized as a light weapon when used this way, but changing the option under armor to say the Klar is readied throws up red flags.


Animal companions are missing the weapon finesse feat. There was a typographical error in the first PDF that left it out.

For a sling, I can't find how to specify I'm using bullets (1d6), it's stuck at 1d4.

A few more strength ratings for composite bows would be nice.

Thanks


Animal companions with an Int of 3 can choose any skill


RtrnofdMax wrote:

I noticed a couple of things on my cavalier mount when working through your sheet.

Alertness doesn't appear on the list of feats it can take.

Josh Frost has stated that you get 4.5 HP per HD at level one. So a mount should have 2x4.5 + 2xCON HP at level one.

Yep, I've got lots of work necessary on the companions--including feats, skills, etc...

Morikyri wrote:

i noticed an error on 8.10 yesterday and forgot to post it. languages seem to me off. i've got a tiefling rogue that's got an +4 INT modifier at lvl 1. so his base for INT before the racial modifiers is a +3. when you look at the languages and linguistics area, it says i only have 3 languages. a couple levels later i put a point in linguistics and it raised it to 4 available languages.

i'm by no means an expert in excel, but what it looks like to me is that the sheet is checking the INT modifier before racials are applied to determine the number of known languages.

You are correct...fixed it!

RtrnofdMax wrote:
Thunder and Fang style is not letting you equip the Klar as a shield. The Klar is properly recognized as a light weapon when used this way, but changing the option under armor to say the Klar is readied throws up red flags.

I'm actually working on Thunder and Fang, Aldori Dueling, and Coprnugan Shield, as all three feats at present assume use of the Landscape view.

addy grete wrote:

Animal companions are missing the weapon finesse feat. There was a typographical error in the first PDF that left it out.

For a sling, I can't find how to specify I'm using bullets (1d6), it's stuck at 1d4.

A few more strength ratings for composite bows would be nice.

Thanks

Yes, I'm fixing the Weapon Finesse along with other items noted in the latest errata

As for the sling, I'm not sure what you mean? Medium slings deal 1d4 damage. This is with a bullet. Using a rock would actually deal 1d3 damage and suffer a -1 attack penalty. I'm not aware of any bullet that deals 1d6 for a Medium sling.

Adding some more composite bow strengths shouldn't be a problem.

addy grete wrote:
Animal companions with an Int of 3 can choose any skill

Yep, this is one of the things (as noted above) I need to work on with companions...

1,201 to 1,250 of 1,732 << first < prev | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | next > last >>
Paizo / Messageboards / Paizo Publishing / Pathfinder® / Pathfinder RPG / Suggestions/House Rules/Homebrew / erian_7's Excel-based Character Sheet All Messageboards

Want to post a reply? Sign in.

©2002–2014 Paizo Inc.®. Need help? Email customer.service@paizo.com or call 425-250-0800 during our business hours: Monday–Friday, 10 AM–5 PM Pacific Time. View our privacy policy. Paizo Inc., Paizo, the Paizo golem logo, Pathfinder, the Pathfinder logo, Pathfinder Society, GameMastery, and Planet Stories are registered trademarks of Paizo Inc., and Pathfinder Roleplaying Game, Pathfinder Campaign Setting, Pathfinder Adventure Path, Pathfinder Adventure Card Game, Pathfinder Player Companion, Pathfinder Modules, Pathfinder Tales, Pathfinder Battles, Pathfinder Online, PaizoCon, RPG Superstar, The Golem's Got It, Titanic Games, the Titanic logo, and the Planet Stories planet logo are trademarks of Paizo Inc. Dungeons & Dragons, Dragon, Dungeon, and Polyhedron are registered trademarks of Wizards of the Coast, Inc., a subsidiary of Hasbro, Inc., and have been used by Paizo Inc. under license. Most product names are trademarks owned or used under license by the companies that publish those products; use of such names without mention of trademark status should not be construed as a challenge to such status.