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!
So awesome... :D
Maybe I'm missing something here, but it seems the Weapon Focus drop-down box has the same listing as the Exotic Weapon Proficiency box.
Maybe I'm missing something here, but it seems the Weapon Focus drop-down box has the same listing as the Exotic Weapon Proficiency box.
Yep, I haven't gotten to automation for that one yet, so when I built those entries I used the Exotic Weapon Proficiency as a stand-in for data validation. I'll be adding the full list in my next release.
And as a note, I've now seen the LSJ feats and there's a bunch of them! It'll take me a bit to cover that and I do want to complete the "standard" feats first. If, as in the past, any folks want to help out with data entry, that will speed the process along...
|
Erian, you may want to consider a method to allow people to expand on the datasets without messing up your existing sheet structure.
For example, if each PrC were on a separate sheet then a single sheet could be exported and read back in by someone else -- without losing any of your basic sheet functionality. What I'm thinking of is someone who's done a lot of work extending your sheet only to find out that they're 3 revisions behind and they want to update!
I've not done any large-scale spreadsheet work in quite some time. But if you had a naming convention for the individual sheets, that would probably suffice. For example, all weapon data goes on a sheet called "WeaponData:Base" but the macros actually search all sheets whose names match "WeaponData:*". This would require true macros, not just cell formulas AFAICT.
Great work, btw. I'm working on an HTML-based version of something like this but it won't have all of the data that this thing has! Certainly not at the beginning. :)
Erian, you may want to consider a method to allow people to expand on the datasets without messing up your existing sheet structure.
For example, if each PrC were on a separate sheet then a single sheet could be exported and read back in by someone else -- without losing any of your basic sheet functionality. What I'm thinking of is someone who's done a lot of work extending your sheet only to find out that they're 3 revisions behind and they want to update!
I agree. As it is now you can select the PrCs as you advance levels, but you don't gain any abilities, feats, etc. yet. Granted you probably just haven't gotten that far, but it is something to keep in mind. And then you can have it set up so that accessing the different PrCs are located on one page similar to your setup for the core classes.
BTW, what is the "Use alternate class ability" for? Am I missing something from the PFRPG or is this a PFS thing?
Thanks for the input! Expandability is definitely something I have in mind, and to that end have been continually moving away from my first model (all data not on the sheets was on the Table tab) to "themed" tabs. Class Abilities for instance will actually all be on that single tab, for base and PrC alike. I am looking to split the Tables tab into multiple sets of data, including at least Spells, Races, Skills, and Class Info (basic info like HD and saves, as distinct from Class Abilities). Each table will have an area at the bottom for easy expansion. I'm not keen on going to the one-tab-per-class model as it would involve macros and I'm aiming to keep the sheet simpler than that (so folks can take it apart if they want and build it a different way). I should have the basic splits for these done in the next release, so definitely take a look and let me know your continued thoughts.
As for the Prestige Classes, their class abilities are indeed incomplete at this time. I'm focusing on base classes and core feats first, then can shift back to the prestige classes, continue with Golarion feats, or move on to something like Spell automation.
Oh, and the alternate class ability is specifically from the Pathfinder Chronicles Campaign Setting book and basically gives a twist to each character class. Fighters can give up their 1st level combat feat for 4 skill points/level. Clerics can give up their domains for fighter BAB and HD. Rogues can give up trapfinding for poison use. Etc. As the sheet expands to accommodate other campaign settings, I'll make that more distinct.
And as an update, only 50 more feats and I'll have all the core ones complete!
And as a note, I've now seen the LSJ feats and there's a bunch of them! It'll take me a bit to cover that and I do want to complete the "standard" feats first. If, as in the past, any folks want to help out with data entry, that will speed the process along...
I can do that sometime during the week. I'll make an LSJ section in the existing feat table. I should be able to figure out the Qualified column from the other examples.
I can do that sometime during the week. I'll make an LSJ section in the existing feat table. I should be able to figure out the Qualified column from the other examples.
And as a note, I've now seen the LSJ feats and there's a bunch of them! It'll take me a bit to cover that and I do want to complete the "standard" feats first. If, as in the past, any folks want to help out with data entry, that will speed the process along...
Thanks! Coordinate with Jay, as I'm getting help there as well. Y'all can cover other aspects, like races and alternate class abilities, and I'll be happy to work those in as well. I'll be checking out the PDF over my vacation so I properly integrate any changes and also to help me figure out a good approach for campaign customization.
Eric,
Not sure if this has been asked (been quickly skimming and looking for updates), but will the "final" be self-populating?
And are there any plans to have it keep track of the number of class specific and "general" feats?
I really like it so far!
Eric,
Not sure if this has been asked (been quickly skimming and looking for updates), but will the "final" be self-populating?
And are there any plans to have it keep track of the number of class specific and "general" feats?
I really like it so far!
Not sure what you mean by self-populating? The sheet already fills out everything for the core races and classes.
Working on feat automation now. For class feats, those are selected with each class so they are already distinguished there (vs. the level-based feats gained). Are you wanting them distinguished on the Abilities and Feats tab as well?
I guess I'm looking for it to tell me how many of each I have to pick/remaining (for the games that you start at higher than 1st level (especially for feats)
I guess I'm looking for it to tell me how many of each I have to pick/remaining (for the games that you start at higher than 1st level (especially for feats)
You mean feats specifically? The way the sheet is structure, you selecting everything level-by-level. So, for instance, if you are a Fighter 5 then you'd select feats at 1st, 3rd, and 5th in the generic Level section on Character Options, then in the Fighter block you'd select the bonus combat feats for 1st (assuming you don't use the alternate class ability), 2nd, and 4th. If you're playing a human or half-elf, you'd also select a racial bonus feat (right below the ability selection area).
|
Erian,
I'm keeping up to date with all the new versions you're releasing and I like what you're doing with the feat automation and layout tweaks. I've spotted a few very minor errors in the latest version. Some of them have been around for a few versions but I haven't had a chance to let you know about them.
1. I added a custom race via the Customization tab. The custom race abilities didn't appear on the Feats and Abilities tab. The race abilities summary needs to populate through to the Ability Summary cell (BI12) on tables tab.
2. I entered a custom feat and selected it as the character's 1st level feat. It didn't appear on the Feats and Abilities tab.
3. For a Neutral cleric the "Chaotic, Evil, Good and Lawful Spells" description on the Feats and Abilities tab reads "Cannot cast spells with these descriptor(s): FALSEFALSE". This text works fine for LG, CG, LE and CG clerics but any neutral element in the alignment causes one or two "FALSE"s to appear.
4. I reordered the Skill list on Front tab to combine the general skills and the trained-only skills into a single ordered list. The skills all still worked OK but the Senses box above it showed "#NA" for the perception skill. I don't think the VLOOKUP it uses works when skills are reordered.
5. A bard can make all knowledge skills untrained and also gets a bonus of half his level to knowledge skills. Any chance of including that in the skill list?
|
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...
Cool! I hope that you didn't see this as being "overly critical". A good example of dropdown menus can be seen here. This might give you an idea or two! :-)
|
|
Hello,
My DnD group is converting over to Pathfinder and I've been playing around with the Character Generator for my bard. I like the new format, however, I did find some problems.
I don't know if these have been address yet, but here I go:
1) I like having my skills in alphabetical order, and the Senses box does not readjust when Perception skill is in the 78th row or below in the skills table.
2) Scribe Scroll is not a bonus feat for a bard, which was listed in the feats list.
3) For the bardic Performance rounds/day, its ((lvl_Brd-1)*2)
4) For the Fascinate, the number of targets is ((Lvl_Brd-1)/3)
5) Bard spells known in the Tables tab is not consistent with Table 3-4 (pg 37 in the rule book); I noticed in the Abilities & Feats Tab under the Class Abilities Window
Also, I was wondering, if there was another way to adjust the print scaling of the Front Character sheet in Open Office. I noticed that there isn't a definitive print scale like the Back Page and Abilities and Feats. Also, the slide bar in the print preview doesn't make an exact "fit to page".
Thanks
Is there a link or website where I can download the latest version of the ERIAN_7 character sheet?
I like to check in once and a while and see how it's coming along.
The last "released" version is always at the Pathfinder Database. The latest version is always on this thread. I'll also start posting it in my profile.
The last "released" version is always at the Pathfinder Database. The latest version is always on this thread. I'll also start posting it in my profile.
Cool. Posing it on your profile is a great idea. Very easy to find.
First up, thanks for those still finding issues. I'll be getting to those soon, though right now y'all are playing second to my Disney fun time!
Cool! I hope that you didn't see this as being "overly critical". A good example of dropdown menus can be seen here. This might give you an idea or two! :-)
Pretty much unless someone jumps on the thread and pans the whole idea as the worst thing ever, I don't see any criticism as over the top. I'm a one-man show doing this in my spare time, so I know that basically means I'll have errors and other folks will think of things I haven't considered. I also readily admit I'm not an Excel expert (though I'm definitely sure of my skills). So, you guys all help me to make this better. Now, that said, I am trying to walk the thin line between keeping this as a character sheet versus becoming a true character generator (which I think there are plenty of already). A sheet should be fast and accommodating, but not constrain you to stay perfectly "within the lines" so to speak. Adding equipment drop downs won't do this too much, but it does potentially limit the open nature of the sheet. Of course, the same is true for races, classes, etc. So, a lot of rambling just to say it's definitely no problem, please keep the comments coming, and know that when I can I'll explain myself to better solidify what this sheet is aiming for...
Thanks!
Thanks! I'm very pleased with how the sheet is coming together...still running lean and mean but pulling off some pretty nice automation. And a lot of that is thanks to all the folks on this thread giving me ideas and chunks of innovation to incorporate. Keep it coming!
I finished up the Paladin and have also now copied in the full feat text for the core feats (thanks again to Full Bleed and laurence lagnese for the help!). This version has renatsdale's excellent suggestions on incorporating some of the creation/advancement options on the sidebar of the Front page, so now the Character Options tab is completely focused on classes (I guess I should rename it Class Options in a later version) and cleaned up to look nicer. As I never intend to have this thing be a full-blown character generator (there are several XLS-based attempts already in the works, plus great tools like Hero Labs, PCGen, etc. for that), this approach will really help keep the focus on a character sheet feel while more intuitively helping folks through the creation and advancement process. At least that's my hope!
With the Ranger and Rogue wrapping up tomorrow, I hope to also have the first shot at a Feat and Class Ability summary page. This will be formatted to a single sheet, with the left-hand column summarizing all class abilities (including the auto-calculating update summaries for each) and the right hand summarizing feats (no automation on feats for now). That should give us something to chew on for formatting and such. I still want to have this thing produce card-sized summaries for these as well, but haven't wrapped my brain around that one as yet...
For some technical stuff, I only hit 615 KB with all that in place, so I'm now fairly certain I'll pull this off and stay under a 1 MB file size. I switched over to using the FLOOR function rather than ROUNDDOWN. It's only a few characters difference between the two, but over time it should shave some file size off. I also revamped the encumbrance mechanics to use a VLOOKUP now for...
The link is broken :(
|
|
Expandability is definitely something I have in mind, and to that end have been continually moving away from my first model (all data not on the sheets was on the Table tab) to "themed" tabs. Class Abilities for instance will actually all be on that single tab, for base and PrC alike. I am looking to split the Tables tab into multiple sets of data, including at least Spells, Races, Skills, and Class Info (basic info like HD and saves, as distinct from Class Abilities). Each table will have an area at the bottom for easy expansion. I'm not keen on going to the one-tab-per-class model as it would involve macros and I'm aiming to keep the sheet simpler than that (so folks can take it apart if they want and build it a different way).
So what is your proposed technique for updating? Let's say I have added two templates and a couple of prestige classes, along with their attendant racial abilities and class abilities.
I find that I'm three patchlevels behind, so I grab the latest from you. What process do I go through?
I'm just trying to clarify how much work it will be to update if I've made a bunch of changes...
Thanks again!
The link is broken :(
Looks like you're trying to hit one that's several versions old. As of this week, I've always got a link to the latest one in my profile.
The link is broken :(Looks like you're trying to hit one that's several versions old. As of this week, I've always got a link to the latest one in my profile.
I eventually got the working link. I just forgot to come back and mention it, thanks.
I eventually got the working link. I just forgot to come back and mention it, thanks.The link is broken :(Looks like you're trying to hit one that's several versions old. As of this week, I've always got a link to the latest one in my profile.
Ah, that's good!
So what is your proposed technique for updating? Let's say I have added two templates and a couple of prestige classes, along with their attendant racial abilities and class abilities.
I find that I'm three patchlevels behind, so I grab the latest from you. What process do I go through?
I'm just trying to clarify how much work it will be to update if I've made a bunch of changes...
Thanks again!
I'm going to have three sections in each data sheet, the first for "official" data that comes with the release, the second for custom data fed from the Customization tab (for folks that just want to tweak a little bit), and the third for expansion. End-users can copy there material in the expansion area, then cut-and-paste when new version come out. This will be good for folks that want to put in a lot of non-OGC material, for instance, since I won't be including such in my released versions. Of course, I'm open to alternate ideas!
And as a general note, we're wrapping up our vacation and heading home tomorrow, so I'll be back to posting regular updates soon. Thought I might do some during this break, but that didn't happen...
Have the races, familiars, and animal companions from the Pathfinder Bestiary been included?
I just downloaded the latest version of the sheet and I can't seem to choose a race.
Have the races, familiars, and animal companions from the Pathfinder Bestiary been included?
Not yet. I'm working on getting the core races, classes, and feats in place before expanding to the new races. As for familiars and animal companions, I haven't included any specific automation for those as yet. Since I don't have my Bestiary PDF yet, I also haven't checked out any new lists for these. I can readily add creatures to the selections once I know what they are.
I just downloaded the latest version of the sheet and I can't seem to choose a race.
Can you describe what you're doing, as that will help me figure out any problems? I'm assuming you're on the Character Options tab and not the Front tab, for instance.
Hi Erian: Very good job with this sheet. We're loving it so far. One of my players has found something that might be a bug (although it might be our fault too). When you select the Toughness feat, it doesn't seem to add any HP at all. Is anybody else having this problem too...?
Thanks! That one's not a bug/problem, actually...I simply haven't gotten down to the feat automation for Toughness as yet. I've got about 50 feats left of the core, and these will be out in v.0.6.4 (along with the LSJ stuff--meshing these together right now).
Pardon my ignorance but what is "LSJ"?
Legends of the Shining Jewel - a "Living" campaign that has converted over to using Pathfinder as its rule set. See discussions earlier on this page and the previous page.
I haven't seen many postings on this in a while.
I was wondering if you had started putting in the other prestige classes available for Pathfinder Society in the next updated version?
Great stuff
Thanks! I've been catching up on real life after my family vacation, so my usual pace of an update or so week is down. I expected to have v.0.6.4 out last week, but my RL job had a few turns I had to sort out (finished today!). So, I should be back in my usual pace this week. For the PFS stuff, I already have all the basics of the core PRCs in, but haven't automated their class abilities. Once I finish up the core feats (this week's release) I'll be turning my attention to other areas. Completing the core prestige class automation seems to be high on folks' lists so I can definitely see that being in the next big release.
Okay folks, I've finished up the core feats and also integrated the LSJ material that was submitted. Check it out and let me know of any bugs. Since there was such a long gap between this version and the last, I may not have corrected some bugs that were reported--if you posted something please check it again and don't feel shy about pinging any lingering problems.
As per some previous discussions, I want to improve the usability of the sheet in terms of major expansions, so I'm going to turn to that as my next step for v.0.6.5, along with finishing out the core prestige class abilities. I'd also like to know folks thoughts on having the full text for things like class abilities and feats in the sheet, even though they are not used. Removing them will cut out a fair chunk of file size, I think, but they may have future use (and I sometimes use them as a handy sort/filter reference guide).
Okay folks, I've finished up the core feats and also integrated the LSJ material that was submitted. Check it out and let me know of any bugs. Since there was such a long gap between this version and the last, I may not have corrected some bugs that were reported--if you posted something please check it again and don't feel shy about pinging any lingering problems.
As per some previous discussions, I want to improve the usability of the sheet in terms of major expansions, so I'm going to turn to that as my next step for v.0.6.5, along with finishing out the core prestige class abilities. I'd also like to know folks thoughts on having the full text for things like class abilities and feats in the sheet, even though they are not used. Removing them will cut out a fair chunk of file size, I think, but they may have future use (and I sometimes use them as a handy sort/filter reference guide).
Great update, thanks! i've really gotten a lot of use out of this and it's great. I immediately noticed the Skill Focus (Skill) additions and the similar changes to Weapon Focus, etc. Good job!
hate to immediately drop something on you but the Weapon Focus Selections dropdown only has exotic weapons listed. and when I open the file it says that a link can't be updated. Seems to work fine though. thanks again!
hate to immediately drop something on you but the Weapon Focus Selections dropdown only has exotic weapons listed. thanks again!
Aww nuts...I forgot to add in the full weapons list...item number one to fix for v.0.6.5!
I did add all the Bestiary animals to the Animal Companions list. Now I just need to add automation for animal companions...
figured it out. the Bard Fort formula was looking at the Skill point column.
Ah, thanks. Looks like several of the calcs didn't shift properly with the new additions. Corrected.
A quick view of the progress--sheets have been rebuilt to better support customization, with separate Data tabs for classes, races, skills, equipment, etc. And yep, that equipment tabs means automation of weapons and armor is in place...I'm now alternating between updating the core PrCs and adding in 3PP material (I've had a very good response, so the next version will have OGC material supporting LSJ, Alluria, 4 Winds Fantasy, and OtherWorld Creations--if you're 3PP publisher of choice isn't on the list, give 'em a poke and let them know I'll support their products). Oh, and I remembered to update my profile to the latest version...
I tried to recreate my 9th level 1/2 elf monk using version 6-4 and it calculates the Fort save as a base 36 (nice for the PC but..). What is wrong here?
Also the weapon focus selection table does not contain the normal weapon list, i.e., unarmed combat.
Can you help?
Thanks
Bear
The first issue is exactly what was mentioned above regarding the bard and has been fixed. For the second, apparently I'm having a brain blip as I thought I had corrected that. Given the far-reaching impacts from the first item, I've decided an interim release is the best route since it'll be hard to test other aspects of the character sheet. So, here's v.0.6.4.1!
This looks absolutely terrific so far, nice job.
Found issues in Open Office 3.1
Issue1
Character Options tab, Favored Class
No longer functions
Issue2
Front tab, multiple boxes
Appear as ## or ###:
Armor,Shield,Dex Mod,Other,Touch AC,Other,Acrobatics,Climb,Escape Artist,Fly,Ride,Stealth,Swim
Appear as #N/A:
Encumberance,AC,Flatfooted AC,CMD Total,Various Weapon description boxes
It appears all of these share Str or Dex as the common factor. Probably just a missing ] or ( somewhere in the cross-tabulation.
I tried to recreate my 9th level 1/2 elf monk using version 6-4 and it calculates the Fort save as a base 36 (nice for the PC but..). What is wrong here?
Also the weapon focus selection table does not contain the normal weapon list, i.e., unarmed combat.
Can you help?
Thanks
Bear
The first issue is exactly what was mentioned above regarding the bard and has been fixed. For the second, apparently I'm having a brain blip as I thought I had corrected that. Given the far-reaching impacts from the first item, I've decided an interim release is the best route since it'll be hard to test other aspects of the character sheet. So, here's v.0.6.4.1!
Wow that's great! thanks for doing this release. Fixed the little issues that I had brought up (Weapon Focus list now has all weapons and its not saying there is a broken link)
Wow that's great! thanks for doing this release. Fixed the little issues that I had brought up (Weapon Focus list now has all weapons and its not saying there is a broken link)I tried to recreate my 9th level 1/2 elf monk using version 6-4 and it calculates the Fort save as a base 36 (nice for the PC but..). What is wrong here?
Also the weapon focus selection table does not contain the normal weapon list, i.e., unarmed combat.
Can you help?
Thanks
Bear
The first issue is exactly what was mentioned above regarding the bard and has been fixed. For the second, apparently I'm having a brain blip as I thought I had corrected that. Given the far-reaching impacts from the first item, I've decided an interim release is the best route since it'll be hard to test other aspects of the character sheet. So, here's v.0.6.4.1!
Uh oh :) Favored Class dropdowns contain no choices now
This looks absolutely terrific so far, nice job.
Found issues in Open Office 3.1
Issue1
Character Options tab, Favored Class
No longer functions
Looks like the List_Classes_Base is messed up. You can do a quick fix on this by changing the Data Validation for those fields to =List_Classes instead. Fixed for the next version
Issue2
Front tab, multiple boxesAppear as ## or ###:
Armor,Shield,Dex Mod,Other,Touch AC,Other,Acrobatics,Climb,Escape Artist,Fly,Ride,Stealth,SwimAppear as #N/A:
Encumberance,AC,Flatfooted AC,CMD Total,Various Weapon description boxesIt appears all of these share Str or Dex as the common factor. Probably just a missing ] or ( somewhere in the cross-tabulation.
Was it this way as soon as you opened it? The reason I ask is that sounds more like a piece of data somewhere is missing and if you can tell me what you entered it will help track down any issues.
This looks absolutely terrific so far, nice job.
Found issues in Open Office 3.1
Issue1
Character Options tab, Favored Class
No longer functionsLooks like the List_Classes_Base is messed up. You can do a quick fix on this by changing the Data Validation for those fields to =List_Classes instead. Fixed for the next version
Was it this way as soon as you opened it? The reason I ask is that sounds more like a piece of data somewhere is missing and if you can tell me what you entered it will help track down any issues.Issue2
Front tab, multiple boxesAppear as ## or ###:
Armor,Shield,Dex Mod,Other,Touch AC,Other,Acrobatics,Climb,Escape Artist,Fly,Ride,Stealth,SwimAppear as #N/A:
Encumberance,AC,Flatfooted AC,CMD Total,Various Weapon description boxesIt appears all of these share Str or Dex as the common factor. Probably just a missing ] or ( somewhere in the cross-tabulation.
Thanks that took care of it
I would vote to put back in the sample weapons entries. I've used the sheet enough now that I don't need it but it was a big help the first time I looked at it