erian_7's Excel-based Character Sheet


Homebrew and House Rules

201 to 250 of 1,732 << first < prev | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | next > last >>

erian_7 wrote:


Did you select the fighter and monk bonus feats on the Character Options tab? They would go there rather than the general feat selection area. Note this is subject to change as I work out the feat automation, so suggestions are welcome!

Oh, I see I've jumped the gun, you're not done yet with that, sorry. I used the back sheet because I wanted the feats to be listed on the printed character sheet. If I understand correctly then, the intent must be for all feats to be listed on the abilities and feats tab, not on the back sheet. As nothing was showing up there I tried to use only the back sheet, my mistake...

Also, you probably already are aware that if you select a prerequisite feat on the Character Options tab, feats that depend on it show up in red on the back sheet. For example, select dodge as a monk 1 feat, and try to select mobility on the back sheet. It shows up in red.

Edit: I see now that feats selected under character options show up under the class abilities column. That is unexpected. If possible, I'd rather have all feats under the "feats" column.

Edit 2: As a matter of personal preference, I'd rather have the "other notes", "racial abilities" and "armor and weapon proficiencies" sections in what is currently the "abilities and feats" tab, and use the space on the back sheet to copy the feats from the character options. That would avoid duplication of the feats between the back sheet and the abilities and feats tab, and it's where I'd expect to find them, next to the traits.

Liberty's Edge

Thanks for working on the character sheet. I can't wait to see the final version with all the bugs worked out.

Do you have a website where you post the updated versions? or do we just have to check the messageboards?

Keep up the fantastic work.


addy grete wrote:
erian_7 wrote:


Did you select the fighter and monk bonus feats on the Character Options tab? They would go there rather than the general feat selection area. Note this is subject to change as I work out the feat automation, so suggestions are welcome!

Oh, I see I've jumped the gun, you're not done yet with that, sorry. I used the back sheet because I wanted the feats to be listed on the printed character sheet. If I understand correctly then, the intent must be for all feats to be listed on the abilities and feats tab, not on the back sheet. As nothing was showing up there I tried to use only the back sheet, my mistake...

Also, you probably already are aware that if you select a prerequisite feat on the Character Options tab, feats that depend on it show up in red on the back sheet. For example, select dodge as a monk 1 feat, and try to select mobility on the back sheet. It shows up in red.

Yep, for my initial release, the various class bonus feats, racial bonus feats, and feats selected by level will all appear over on the Abilities and Feats tab. I'm still thinking on the best way to do some selections (like Weapon Focus, with a sub-selection for each feat).

The red is supposed to indicate when a feat is selected without meeting the prereqs (I've got that fixed better for the next release).

As soon as I come up with a good way of displaying the feat text, I'll have v.0.6.1 out for folks to test. In addition to correcting bugs identified to date, it contains initial feat automation. Oh, and I included the PFS experience progression option (meant to have that in the v.0.6 release).

PJOsano wrote:

Thanks for working on the character sheet. I can't wait to see the final version with all the bugs worked out.

Do you have a website where you post the updated versions? or do we just have to check the messageboards?

Keep up the fantastic work.

Thanks for trying it out! I post all the updates here on the boards as I progress through a major build, then post the final over at the Pathfinder Database for general use.


addy grete wrote:

Edit: I see now that feats selected under character options show up under the class abilities column. That is unexpected. If possible, I'd rather have all feats under the "feats" column.

Edit 2: As a matter of personal preference, I'd rather have the "other notes", "racial abilities" and "armor and weapon proficiencies" sections in what is currently the "abilities and feats" tab, and use the space on the back sheet to copy the feats from the character options. That would avoid duplication of the feats between the back sheet and the abilities and feats tab, and it's where I'd expect to find them, next to the traits.

The feats displaying on the Class Abilities are just the names of the feats themselves. The full feat list will be the feat name, plus a dynamic (i.e. auto-calculating when necessary) feat summary. The reason I'm looking to put the feats on the Abilities and Feats tab is because I expect this information will be more than can be readily displayed on the Back tab. However, if that proves not to be the case, I do thinks I could move the Racial Abilities off the Back and over to a new Class and Race Abilities tab, then have the Back tab be largely for Equipment and Traits/Feats.

And to help with this conceptualization, I give you v.0.6.1. As noted, it includes the beginnings of feat automation (I've gotten down through Command Undead), as well as bug fixes and the PFS experience change. If everyone can review how the feats (from class, race, leveling, etc.) will roll over to the Abilities and Feats tab, then let me know if you think this will be better on the Back tab, I can plan that change for v.0.6.2

PFRPG_CS_v_0_6_1.xls


Quick question. Is there an override to the automation? For dealing with houserules and such?


erian_7 wrote:


let me know if you think this will be better on the Back tab, I can plan that change for v.0.6.2

Having it on the "abilities and feats" tab works. The idea was just to avoid printing duplicate feat information, so alternatively the feats on the back tab could be put somewhere that doesn't get printed (I don't know where). Perhaps there could be a "green zone" (like on the front sheet) in the "abilities and feats" tab to select those feats. It's a minor point anyway.

Thanks


kyrt-ryder wrote:
Quick question. Is there an override to the automation? For dealing with houserules and such?

My override is to simply unprotect the sheet (they are not password-protected) and type directly into the cells, but if you can give me some specific examples, I'll try to give better recommendations. There are cells on the Tables tab to add custom skills, races, and classes to some extent. I'll be adding some fields on the Feats tab to do the same.

addy grete wrote:
erian_7 wrote:


let me know if you think this will be better on the Back tab, I can plan that change for v.0.6.2

Having it on the "abilities and feats" tab works. The idea was just to avoid printing duplicate feat information, so alternatively the feats on the back tab could be put somewhere that doesn't get printed (I don't know where). Perhaps there could be a "green zone" (like on the front sheet) in the "abilities and feats" tab to select those feats. It's a minor point anyway.

Thanks

Placing the feat selection on a non-printing tab is actually something I've been considering, although I was thinking the Character Options tab. I do want to maximize space on what is actually printed and used, so having redundant information for the feats on both the Back and Abilities and Feats tab doesn't make sense, so I do have to come up with something. As with some of my previous builds, perhaps I'll put out some alternatives and you all can drive the results.


The feat Acrobatic is only giving the bonus to Acrobatics, not to Fly...


Conan wrote:
The feat Acrobatic is only giving the bonus to Acrobatics, not to Fly...

Hmm, looks like I missed updating that formula on the Tables tab. Corrected for the next version.


erian_7 wrote:
Conan wrote:
The feat Acrobatic is only giving the bonus to Acrobatics, not to Fly...
Hmm, looks like I missed updating that formula on the Tables tab. Corrected for the next version.

The primary melle weapon example came with the damage already putted and without the choise to change...


Conan wrote:
The primary melle weapon example came with the damage already putted and without the choise to change...

Ah, that was part of an experiment I forgot to clean up..fixed now.

And speaking of experiments, this next version is a big one! I've rebuilt the Character Options, Back, and Abilities and Feats tabs to bring more focus to the purpose for each. the Front tab "side bar" items as well as feat and trait selection from the Back tab have been moved to Character Options (a reversal of the "sidebar" and something I want feedback on specifically). This frees up the Back tab to be more focused on equipment, so I've moved the Armor/Shield/Protective Item blocks there. This freed up space on the Front for another weapon and I also rebuilt the Special Notes to focus on Skill Notes and Languages. The big deal, however, is the Abilities and Feats tab. It now displays all Racial and Class ability summaries, plus feats and traits. Feat automation is also complete through Great Fortitude.

Looking forward to lots of feedback for this one, as it represents a possible direction for the future and could end up being the "final" format. So, bring it on!

PFRPG_CS_v_0_6_2.zip


Nice work. I haven't cracked open 0.6.2 yet, but have just finished putting my wife's Monk into 0.6.1. I think going forward I'll continue to use these instead of maintaining my own Excel docs. Couple thoughts though - sorry if any of these were covered, I haven't read all the pages yet.

1) Is there currently a built-in way I missed for displaying a monk's Flurry of Blows sequence? I ended up unlocking and replacing one attack row's to-hit bonus with my own hack.

2) I wanted to add text to Scorpion Style to display the # of rounds and DC dynamically so it's always immediately clear when looking at the character sheet, like: ... speed is reduced to 5' for "&Wis_Mod_Current&" rounds unless it makes a Fort save (DC" & ROUNDDOWN(10 + 1/2*Level_1+Wis_Mod_Current,0) & ")." -- however, note that to use this properly, "Level_1" would clearly have to be some mechanism that actually means "monk levels" or whatnot.

3) While on the Feats tab, I noticed Tiring Critical has some texts copied from Toughness, unless I accidentally caused that.

4) The equipment section on the Back tab could use some quantity columns. I'm not sure why people tend to neglect a quantity column when building these sheets, as they are incredibly handy. For instance, if I have 7 cure light wounds potions, I should only have to type 7 in the first column, then it's a simple matter of typing 6 while that cell is selected if my character quaffs a potion; GP value of the gear and total weight automatically adjusts to reflect the changes instead of requiring a sometimes annoying manual recalculation. Munitions, especially magic ones, can be quite handy to treat this way, and the QTY column just gets ignored by the user for most rows. (Basically the easy way I usually implement QTY is to have some extra columns which are unseen that calculate total GP and WGT for that row only, assume a QTY of 1 if no QTY is supplied, and SUM against the hidden columns instead of the user columns.)

~ Karak


Karak wrote:
Nice work. I haven't cracked open 0.6.2 yet, but have just finished putting my wife's Monk into 0.6.1. I think going forward I'll continue to use these instead of maintaining my own Excel docs. Couple thoughts though - sorry if any of these were covered, I haven't read all the pages yet.

Thanks! The next iteration is a pretty big step from v.0.6.1, so I'm definitely interested in hearing your opinion on the changes.

Karak wrote:
1) Is there currently a built-in way I missed for displaying a monk's Flurry of Blows sequence? I ended up unlocking and replacing one attack row's to-hit bonus with my own hack.

I will be adding this when I complete the automation for the Two-Weapon Fighting feat, as they are functionally the same. My current approach is to add some selectors for the weapons that will allow TWF, power attack, weapon finesse, etc. Having the extra space on the Front tab in v.0.6.2 is the first step in that plan.

Karak wrote:
2) I wanted to add text to Scorpion Style to display the # of rounds and DC dynamically so it's always immediately clear when looking at the character sheet, like: ... speed is reduced to 5' for "&Wis_Mod_Current&" rounds unless it makes a Fort save (DC" & ROUNDDOWN(10 + 1/2*Level_1+Wis_Mod_Current,0) & ")." -- however, note that to use this properly, "Level_1" would clearly have to be some mechanism that actually means "monk levels" or whatnot.

This is the type of automation I'm adding as I work through the iterations, i.e. when i say I'm done through Great Fortitude it means (1) that the feat summary appearing on the Abilities and Feats tab will auto-updated based on character level and (2) that relevant game mechanics auto-update when the feat is selected. I've completed Gorgon's Fist, so I took at and show the update for Scorpion Style below as an example.

="Standard Action; make single unarmed melee attack to dmg as normal and also reduce foe's base land speed by 5' for "&Wis_Mod_Current&" rnds (Fort DC "&10+FLOOR(Character_Level/2,1)+Wis_Mod_Current&" negs)"

Note that the feat is based on character level, not class level, so I don't need to make a distinction. However, when this becomes relevant I use something like:

IF(Class_1="Monk",Level_1,IF(Class_2="Monk",Level_2,IF(Class_3="Monk",Level _3,0)))

Karak wrote:
3) While on the Feats tab, I noticed Tiring Critical has some texts copied from Toughness, unless I accidentally caused that.

There are several feats that apparently got out of sequence during a sort. I'm correcting these as I go along, but do let me know if you find anything from a feat I've already passed (i.e. at this time anything before Great Fortitude in v.0.6.2).

Karak wrote:

4) The equipment section on the Back tab could use some quantity columns. I'm not sure why people tend to neglect a quantity column when building these sheets, as they are incredibly handy. For instance, if I have 7 cure light wounds potions, I should only have to type 7 in the first column, then it's a simple matter of typing 6 while that cell is selected if my character quaffs a potion; GP value of the gear and total weight automatically adjusts to reflect the changes instead of requiring a sometimes annoying manual recalculation. Munitions, especially magic ones, can be quite handy to treat this way, and the QTY column just gets ignored by the user for most rows. (Basically the easy way I usually implement QTY is to have some extra columns which are unseen that calculate total GP and WGT for that row only, assume a QTY of 1 if no QTY is supplied, and SUM against the hidden columns instead of the user columns.)

~ Karak

A very good suggestion--it'll be in v.0.6.3!

Thanks for taking the time to take a look, and let me know what else you come across...


Two minor things, is there a way to list the Wizard's prohibited schools, and specify a school for Spell Focus?


vagrant-poet wrote:
Two minor things, is there a way to list the Wizard's prohibited schools, and specify a school for Spell Focus?

Prohibited schools are listed on the Spells tab. I am considering putting that on the Character Options tab instead, so feedback there would be good.

For Spell Focus, when I get the automation going for that there will be individual feats for each school (see Alignment Channel as an example of one I've completed).


Excellent, and yeah, I had thought it was supposed to be on the Character options page alongside the choice of school.

Thanks for the rapid answers!


I chose Wizard for favorite class and chose Paladin for the real class, and continued to gain the benefit of HP.

For a Half-Elf, the bonus feat is Skill Focus, but the tab shows Feats in substitution of skills.

I like this new form... It is diferent, it took me some time to real like it, but I think it is real good now...


Conan wrote:

I chose Wizard for favorite class and chose Paladin for the real class, and continued to gain the benefit of HP.

For a Half-Elf, the bonus feat is Skill Focus, but the tab shows Feats in substitution of skills.

I like this new form... It is diferent, it took me some time to real like it, but I think it is real good now...

The favored class HP/skill points are manual at this time. I'm thinking on fixes for that, but at this time the only "alert" is that the cells will turn red if they exceed character level. The fix for this might also remove the 3-classes-only support barrier as well...

For the Skill Focus, I'll be fixing that as part of the automation for that feat--there will be a separate Skill Focus for each skill and the list for half-elves will then pull from the specific feat list.

And thanks for the feedback on the new format! I do think refining the focus for each tab will increase the utility of the sheet overall.


Hi - first time poster. I started with the 5.7a sheet and just now came back to see things have progressed. Let me start with saying that I really appreciate the amount of work that you have put into this. If nothing else I'm learning a bit more about how Excel formulas work :-)

I found a few bugs with 5.7a, but it looks like you fixed all of them with 6.2. But right off the bat I did run into a potential bug? in 6.2. This is so obvious, I wonder if I'm missing something: the ability bump is not getting applied to either the "front" abilities" or the table below (starting at 25M in the "character options tab"). I'm using the "custom" point-buy option (but a quick experiment changing the option did not seem to affect it).

I figured out how to add a new prestige class to the 5.7a sheet, took a while the first time, but additional ones look to be pretty easy. Does not look like 6.2 changed much in that area. I did have one question - is there any automation for the spell caster levels for the new classes? And of course things get even more complicated when you have multiple spells types (say the Mystic Teurge for example). I'm guessing not, but just wanted to make sure I had not missed anything.

Last question/suggestion. I have a friend who is doing a Japanese variant of Pathfinder, and as usual for this type of game, he has a whole mess of new feats. I've looked over the tables, but am not sure I have a handle on how they are being used. Any tips for adding a bunch of new feats (which tables need to be updated, etc.)? I was thinking I might just replace all the feats in the Golarion table (and than figure out how to rename it :-)

But that leads to a suggestion, at least three GM's I've talked to about your spreadsheet wanted to know how they could add more feats. I think it would not be hard to create a new expandable feat table. Just include feat name and a description; with a simple enable/disable switch somewhere. If the switch is enabled, display the feats from this table on all feat pull-down menus. I think that would be a quick and easy way for people to add house-rule feats.

Well, thanks again for all the work you have done. I'll work a bit more on testing 6.2, and let you know if I come up with any bugs.


My friend noticed a minor error - prestige classes are not supposed to be an option for "favored class". Not a big deal, but thought you might like to know.


Erian as usual you have exceeded yourself with the new version - well done.

Just for usability can you put the choose a race drop down in the character options tab.


First off, great to see new folks joining in the fun! I just got the spreadsheet posted up on another site (http://www.nzcomputers.net/heroforge) along with a link back to this discussion thread, so that will hopefully broaden the exposure and increase feedback even more.

For the new folks, I'm open to any and all comments, questions, and (constructive) criticism. Several aspects of the current sheet are the direct result of folks like you making suggestions or even adding content directly...so thanks!

seaan wrote:
I found a few bugs with 5.7a, but it looks like you fixed all of them with 6.2. But right off the bat I did run into a potential bug? in 6.2. This is so obvious, I wonder if I'm missing something: the ability bump is not getting applied to either the "front" abilities" or the table below (starting at 25M in the "character options tab"). I'm using the "custom" point-buy option (but a quick experiment changing the option did not seem to affect it).

The change will be on the Front tab, i.e. the "final" score after things like the starting score, level bumps, and racial modifications are considered. If this is not working for you, definitely let me know and I'll dig a bit further into the specifics of your case.

seaan wrote:
I figured out how to add a new prestige class to the 5.7a sheet, took a while the first time, but additional ones look to be pretty easy. Does not look like 6.2 changed much in that area. I did have one question - is there any automation for the spell caster levels for the new classes? And of course things get even more complicated when you have multiple spells types (say the Mystic Teurge for example). I'm guessing not, but just wanted to make sure I had not missed anything.

Spell automation is likely my next major leap after I complete feat automation. My goal will be similar to what I'm doing with feats--have all variables auto-updated based on the appropriate caster level. This will take some work, as the sheet at present really only accommodates one caster level and much of the Spells tab is manual.

seaan wrote:

Last question/suggestion. I have a friend who is doing a Japanese variant of Pathfinder, and as usual for this type of game, he has a whole mess of new feats. I've looked over the tables, but am not sure I have a handle on how they are being used. Any tips for adding a bunch of new feats (which tables need to be updated, etc.)? I was thinking I might just replace all the feats in the Golarion table (and than figure out how to rename it :-)

But that leads to a suggestion, at least three GM's I've talked to about your spreadsheet wanted to know how they could add more feats. I think it would not be hard to create a new expandable feat table. Just include feat name and a description; with a simple enable/disable switch somewhere. If the switch is enabled, display the feats from this table on all feat pull-down...

I've actually been working on a Customization tab that will consolidate the fields necessary to create new races, classes, feats, and traits. Once that's in place it would be a one-stop-shop for these types of changes and will be as "code free" as possible. Some pieces, like automated class abilities/feats/traits, would still require Excel knowledge...

So, your suggestion is not only accepted, but is in progress!

seaan wrote:
My friend noticed a minor error - prestige classes are not supposed to be an option for "favored class". Not a big deal, but thought you might like to know.

Ah, true. I just used my List_Classes reference, but now that I've added prestige classes to that list I need a List_Classes_Base. Thanks!

The 8th Dwarf wrote:

Erian as usual you have exceeded yourself with the new version - well done.

Just for usability can you put the choose a race drop down in the character options tab.

This is actually the second suggestion for this I've had in the past 2 days...it will definitely be in v.0.6.3...

Liberty's Edge

First off, the latest version of your sheet totally rocks! However, I would still like to see (as I have mentioned before) drop down menus for weapons, armor and shields with stats already added to the approprite areas. Furthermore I would like to see a check mark (or something like that) for a weapon to be a chracter's deity's "favored weapon" also a dropdwon menu could be added to the cleric table for favored weapon.


Kevida wrote:
First off, the latest version of your sheet totally rocks! However, I would still like to see (as I have mentioned before) drop down menus for weapons, armor and shields with stats already added to the approprite areas. Furthermore I would like to see a check mark (or something like that) for a weapon to be a chracter's deity's "favored weapon" also a dropdwon menu could be added to the cleric table for favored weapon.

Thanks, as always! Your continued encouragement inspires me to continually tweak the thing and make it the best it can be.

Favored Weapon is definitely a good idea, so I'll get that in v.0.6.3. I can also work in the automation for favored weapon in the weapon stat blocks as I work in things like Power Attack and Weapon Finesse.

I'm not sure I can get the equipment drop downs in for this version, but now that I've got some better thoughts on working in customization I should be able to cover that in the next version or so...


The saving bonus for Paladin's Divine Grace isn't working...


Conan wrote:

The saving bonus for Paladin's Divine Grace isn't working...

Ah, missed adding that automation to the Other field for the saves. Fixed. Thanks!


I definitely have problems with the abilities in 6.2. I'm using Excel 2007 with the latest updates. I re-downloaded the file to make sure I had not accidentally changed anything.

1) Can't get Ability Bump to be applied (the abilities in the Front tab don't change). I tried this with a variety of races, classes, and levels.

2) When race is empty, entering different values for the starting abilities (character options tab) does not subtract from the points. Setting of the flag (standard, high, etc.) changes the total shown below but does not reflect the current remaining points. Once I select a race, it works fine (but does not help with the ability bump).

Back to the feat customization - I had read about your plans for customization (sounds pretty neat too). My actual suggestion was a scaled back feat customization until the the real customization work gets done. Basically just ignore the automation, and provide a simple two column table for feat-name and description. If the table is enabled, than append the feat-names to all feat pulldown menus. Perhaps this is too inelegant for you :-) but I thought it would be relatively simple to implement as a short term workaround.


seaan wrote:

I definitely have problems with the abilities in 6.2. I'm using Excel 2007 with the latest updates. I re-downloaded the file to make sure I had not accidentally changed anything.

1) Can't get Ability Bump to be applied (the abilities in the Front tab don't change). I tried this with a variety of races, classes, and levels.

2) When race is empty, entering different values for the starting abilities (character options tab) does not subtract from the points. Setting of the flag (standard, high, etc.) changes the total shown below but does not reflect the current remaining points. Once I select a race, it works fine (but does not help with the ability bump).

Back to the feat customization - I had read about your plans for customization (sounds pretty neat too). My actual suggestion was a scaled back feat customization until the the real customization work gets done. Basically just ignore the automation, and provide a simple two column table for feat-name and description. If the table is enabled, than append the feat-names to all feat pulldown menus. Perhaps this is too inelegant for you :-) but I thought it would be relatively simple to implement as a short term workaround.

What he said, and I dont see a place to put in my armor or adjust AC.


concerro wrote:
seaan wrote:

I definitely have problems with the abilities in 6.2. I'm using Excel 2007 with the latest updates. I re-downloaded the file to make sure I had not accidentally changed anything.

1) Can't get Ability Bump to be applied (the abilities in the Front tab don't change). I tried this with a variety of races, classes, and levels.

2) When race is empty, entering different values for the starting abilities (character options tab) does not subtract from the points. Setting of the flag (standard, high, etc.) changes the total shown below but does not reflect the current remaining points. Once I select a race, it works fine (but does not help with the ability bump).

What he said, and I dont see a place to put in my armor or adjust AC.

This is an odd one--perhaps I fixed the error some time after uploading the file and forgot about it...In any case, try out the new version below and see if that helps. I created a human monk, ran him up through the levels just to make sure, and it seemed like everything worked fine.

As for the AC, those are on the Back tab. Play around there and let me know if you have questions.

seaan wrote:

Back to the feat customization - I had read about your plans for customization (sounds pretty neat too). My actual suggestion was a scaled back feat customization until the the real customization work gets done. Basically just ignore the automation, and provide a simple two column table for feat-name and description. If the table is enabled, than append the feat-names to all feat pulldown menus. Perhaps this is too inelegant for you :-) but I thought it would be relatively simple to implement as a short term workaround.

Not inelegant at all--it's actually similar to how I had the sheet configured before I moved the feats off the Back tab. This last update side-tracked me a bit (you'll see when I go over the changes) but I expect the feat automation will go rather quickly now. If that proves not to be the case, I can indeed switch the Ability and Feats summary to start pulling the non-automated text.

And now for the update! This one is a major step forward in flexibility! I've revamped the class selection, so you can now chose any number of classes for levels 1-20 (prestige classes are still not fully functional for class ability automation). I have also add a Customization tab where you can directly enter new feats, traits, races, classes, and skills. That tab auto-populates the relevant fields in the Tables and other tabs to make the sheet function, so you don't have to dig all over trying to figure out how to tweak stuff. I'm excited to see how this one goes over, as I think it will be a huge leap forward for ease of use for folks in the area of customization. And, as always, I've incorporated all the suggestions and bug fixes noted since the last version. And even with all that, the sheet is actually slightly smaller due to the efficiency of the new class selection functions. I wanted to get the classes specifically nailed down this way before I moved too much further into the feats, as I realized I'd just be creating rework otherwise. With these changes made, I plan on shifting back to the feat automation almost full-time.

PFRPG_CS_v_0_6_3.zip

As a note, I'm going on vacation starting Saturday and so will be less active for a week or so (although I'll have my laptop and so may get a post in at a hot spot).

As always, thanks for the dedication and assistance!


Very nice! One quick, small comment.

When you select the race for your character on the first (character options) tab, the racial mods for the selected race show up immediately in the ability score boxes second (front) tab.

It would be helpful to see those effects on the Character Option tab as well. Otherwise there is a difference between the stats on the Character Option tab and the Front tab. You then have to click back and forth between Character Options and 'Front' to see where the final stats.


Basilforth wrote:

Very nice! One quick, small comment.

When you select the race for your character on the first (character options) tab, the racial mods for the selected race show up immediately in the ability score boxes second (front) tab.

It would be helpful to see those effects on the Character Option tab as well. Otherwise there is a difference between the stats on the Character Option tab and the Front tab. You then have to click back and forth between Character Options and 'Front' to see where the final stats.

Good suggestion, and I should be able to work that in fairly easily.

Thanks!


I must be overlooking something that should be obvious, but I'm having issues with Skils. The sheet tracks how many points I'm allowed and have spent, but doesn't mark class skills for my class, doesn't allow me to mark them manually, and doesn't apply the +3 bonus to class skills.


Pathfinder Rulebook Subscriber
erian_7 wrote:
Quote:

I definitely have problems with the abilities in 6.2. I'm using Excel 2007 with the latest updates. I re-downloaded the file to make sure I had not accidentally changed anything.

1) Can't get Ability Bump to be applied (the abilities in the Front tab don't change). I tried this with a variety of races, classes, and levels.

This is an odd one--perhaps I fixed the error some time after uploading the file and forgot about it...In any case, try out the new version below and see if that helps. I created a human monk, ran him up through the levels just to make sure, and it seemed like everything worked fine.

The first ability bump works fine. The remaining ones don't register into the equation. Perhaps because the abilities (Str, Dex, etc) are spelled out at the level 4 option and are abbreviated in the remaining options.

Also, would it be possible for you to include customization of ability bumps for all levels as well? This could help incorporate the use of specific magic items and/or other campaign (or even future) options.

(I'm using version 0.63)

Thanks!


Damon Griffin wrote:
I must be overlooking something that should be obvious, but I'm having issues with Skils. The sheet tracks how many points I'm allowed and have spent, but doesn't mark class skills for my class, doesn't allow me to mark them manually, and doesn't apply the +3 bonus to class skills.

Oops, I broke that with a last minute change I didn't test well enough. Posting v.0.6.3.1 to correct it so folks can test properly...

Jay Fisher - LSJ Coordinator wrote:

The first ability bump works fine. The remaining ones don't register into the equation. Perhaps because the abilities (Str, Dex, etc) are spelled out at the level 4 option and are abbreviated in the remaining options.

Also, would it be possible for you to include customization of ability bumps for all levels as well? This could help incorporate the use of specific magic items and/or other campaign (or even future) options.

(I'm using version 0.63)

Thanks!

Ah, I didn't switch the Data Validation for the remaining fields. Corrected that...

For the other ability bumps, at present I use the Other Mods field below each ability (on the Front tab) to enter these. I'll think on a means of expanding the "ability bump by level" concept to support different level breaks, but I'll likely keep that separate from the magic item/other mods type of information. I've been considering adding another big box for each ability that would more visibly accommodate things like "permanent" Enhancement bonuses and such. I'd like for this to work properly with stacking rules so, for instance, a person with a "permanent" +2 Enhancement bonus item that gets a temporary +4 Enhancement bonus from a spell would end up with a +4 without having to overwrite the previous +2.

And that quick-fix new version I mentioned:

PFRPG_CS_v_0_6_3_1.zip


erian_7 wrote:


PFRPG_CS_v_0_6_3_1.zip

The new layout is excellent IMO.

Augment summoning can't be selected (shows up red). It has spell focus (conjuration) as prerequisite but selecting the feat "spell focus" doesn't help.


addy grete wrote:
erian_7 wrote:


PFRPG_CS_v_0_6_3_1.zip

The new layout is excellent IMO.

Augment summoning can't be selected (shows up red). It has spell focus (conjuration) as prerequisite but selecting the feat "spell focus" doesn't help.

Yes, until I get the Spell Focus automation in place (and thus have a conjuration option to select...) the Qualified field always shows as false. That will be corrected likely by the next version.


Any chance of including the LSJ campaign feats (from the campaign guide in the Paizo store)?


Natural Spell shows up red for a lvl 5 druid.

Edit: I wonder if there might be a way for us to provide you with sample test characters that could be imported into every new version you have. This way you could get a test suite which could be engineered to cover classes, races, feats, etc... in a systematic manner.

As a bonus, it would allow us to not have to retype everything when you have a new version, we could just import our set of test characters and see what happens. :D

Edit 2: In the spells tab, the save DC calculation doesn't take wisdom into account for a druid.


addy grete wrote:

Natural Spell shows up red for a lvl 5 druid.

Edit: I wonder if there might be a way for us to provide you with sample test characters that could be imported into every new version you have. This way you could get a test suite which could be engineered to cover classes, races, feats, etc... in a systematic manner.

As a bonus, it would allow us to not have to retype everything when you have a new version, we could just import our set of test characters and see what happens. :D

Do you have Wis set to 13 or higher? It shows up good on mine so that's the only thing I can think of...

I would like to support some sort of import feature, but haven't thought of a good way to handle that as yet...

addy grete wrote:
Any chance of including the LSJ campaign feats (from the campaign guide in the Paizo store)?

My focus at present is on Pathfinder feats specifically. If the feats are Open Game Content and specifically built for PRPG however, it could make sense to include them. Note that at present I do not own this material.


erian_7 wrote:


Do you have Wis set to 13 or higher? It shows up good on mine so that's the only thing I can think of...

I would like to support some sort of import feature, but haven't thought of a good way to handle that as yet...

Wis is 18.

I got it, in the front tab, over "Base classes" if you replace the formula and type "Druid" then Natural Spell becomes green. The formula writes "Drd 5", it seems that's not recognized for the feat eligibility.


Pathfinder Rulebook Subscriber
addy grete wrote:
Any chance of including the LSJ campaign feats (from the campaign guide in the Paizo store)?

I'm definitely willing to work with Erian to get this done. And not just the feats, but ALL aspects of the campaign guide. :)

Erian, contact me offlist at lsj-coord@theshiningjewel.com if you would.

Thanks!
Jay


addy grete wrote:
erian_7 wrote:


Do you have Wis set to 13 or higher? It shows up good on mine so that's the only thing I can think of...

I would like to support some sort of import feature, but haven't thought of a good way to handle that as yet...

Wis is 18

That is odd. What else do you have set? Maybe there's some interaction I haven't considered. The qualification logic is simply:

=AND(Wis>12,ISNUMBER(FIND("Druid",Class)))

So if you've got a high enough Wis score and the word "Druid" shows up anywhere in the Class field it should show as qualified.

Jay Fisher - LSJ Coordinator wrote:
addy grete wrote:
Any chance of including the LSJ campaign feats (from the campaign guide in the Paizo store)?

I'm definitely willing to work with Erian to get this done. And not just the feats, but ALL aspects of the campaign guide. :)

Erian, contact me offlist at lsj-coord@theshiningjewel.com if you would.

Thanks!
Jay

Sure, I'll shoot you a message. One of the things I've been thinking about lately is making sure this sheet supports other Pathfinder material. This is both to help out the users, but also support any 3rd party creators that are standing behind Paizo in helping this become a successful system.

So, I guess a general note to any Pathfinder publishers out there--I'm willing to support your material so long as I can access it!


erian_7 wrote:


That is odd. What else do you have set? Maybe there's some interaction I haven't considered. The qualification logic is simply:

=AND(Wis>12,ISNUMBER(FIND("Druid",Class)))

So if you've got a high enough Wis score and the word "Druid" shows up anywhere in the Class field it should show as qualified.

I got it, in the front tab, over "Base classes" if you replace the formula and type "Druid" then Natural Spell becomes green. The formula writes "Drd 5", it seems that's not recognized for the feat eligibility.


addy grete wrote:
I got it, in the front tab, over "Base classes" if you replace the formula and type "Druid" then Natural Spell becomes green. The formula writes "Drd 5", it seems that's not recognized for the feat eligibility.

Ah, looks like you've got v.0.6.3 rather than v.0.6.3.1!

AS noted above, I was experimenting with the sheet right before I sent out v.0.6.3 and didn't test it quite enough. v.0.6.3.1 fixes this problem be reverting the Class to full names for each.


erian_7 wrote:


Ah, looks like you've got v.0.6.3 rather than v.0.6.3.1!

AS noted above, I was experimenting with the sheet right before I sent out v.0.6.3 and didn't test it quite enough. v.0.6.3.1 fixes this problem be reverting the Class to full names for each.

Sorry about that.

201 to 250 of 1,732 << first < prev | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 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.