Well, took a bit longer than I wanted due to a hectic day...
Mentsguard, it looks like Full Bleed has the schools covered, but I've stuck a template up for the bloodlines:
Heck, I'm in a groove. I'll do the Bloodlines too.
UPDATE: Schools and Bloodlines done.
Any new news?
Yes indeed! This week was a bit heavy,so I didn't get as far as I would have liked. However, I have completed pretty much everything for the classes through Fighter, excepting the Domains for Clerics. I've got the data for Domains, Schools, and Bloodlines in the file now, but haven't worked in any formulas or selection logic. You can, however, select Alternate Class Features from the PCCS to get, for instance, a d10 full BAB cleric or a 4 skill point fighter. The Character Options tab is not pretty yet, but it is functional. So you can select a bard's versatile performance types, a fighters weapon groups, etc. as well. The class ability summaries pull all this information together nicely and, at least from my tests, is calculating all the bonuses properly at various levels. I've decided to go with the class ability and feat descriptions on a separate sheet in order to have enough room, and so I've returned the Back tab to it's v.0.5 state. This view will list class abilities and feats, but not the summary of effects. My plan is to put these onto a tab with card-sized print boxes, though I'm still working out how to populate this nicely. For now, the big tests I need would be around running through the various classes and seeing that the summary effects are calculating/displaying properly.
Thanks, as always, for all the support, and a special thanks to Full Bleed for getting all the extra caster data in place for me!
Oh, and of course, here's the file...
Hi! Great Job you've been doing here! It's the best sheet for pathfinder all over internet!
I've sent you an e-mail with a really small sugestion, I hope you appreciate it!
Keep up with this work! All my friends are using it!!!
Hi! Great Job you've been doing here! It's the best sheet for pathfinder all over internet!
I've sent you an e-mail with a really small sugestion, I hope you appreciate it!
Keep up with this work! All my friends are using it!!!
Hey, I do like that change! Odd I hadn't considered it before, as I already have Wealth By Level tracked on the Tables tab. I've used your suggestion to modify v.0.5.5 and it will include functionality to compare both Starting Wealth vs. expenditures as well as Wealth By Level vs. character "value."
Thanks!
P.S. I'm aiming to get through Monk, Paladin, Ranger, and Rogue with v.0.5.5 before posting it, then will hit Sorcerer and Wizard along with Domains, Schools, and Bloodlines with v.0.5.6--at least that's the current plan...
I have downloaded this file, but the point count portion and +2 human ability bonus does not work. Is this because I am using Open Office instead of Excel?
-- david
Papa.DRB
Oh, and of course, here's the file...
I have downloaded this file, but the point count portion and +2 human ability bonus does not work. Is this because I am using Open Office instead of Excel?
-- david
Papa.DRB
Hmm, looks like the formula got dropped out of the Spent cell. Try putting the following in cell CY7 and see if that fixes the problems.
=IF(ISTEXT(Race),I17+I21+I25+I29+I33+I37,0)
I've corrected this for v.0.5.5, but if any other issues persist I'll look into them as well.
I know that it is not commom to use, but could you please put also a table with the aging effects?
Nope, get an error.
-- david
Papa.DRB
No problem, I'll just wait till the next version.
Hmm, looks like the formula got dropped out of the Spent cell. Try putting the following in cell CY7 and see if that fixes the problems.=IF(ISTEXT(Race),I17+I21+I25+I29+I33+I37,0)
I've corrected this for v.0.5.5, but if any other issues persist I'll look into them as well.
I know that it is not commom to use, but could you please put also a table with the aging effects?
Yep, I've got the Age field on the Front for that very reason and will be adding this functionality at some point. Usually what happens is I get tired of slogging through the class ability formulas and add on a few little tweaks as a break. Yes, I take a break from Excel by doing other stuff in Excel...I'm a bit weird like that.
Nope, get an error.
-- david
Papa.DRBNo problem, I'll just wait till the next version.
Dang...what is the error? That definitely should work in OpenOffice from what I can tell. Anyone else with OpenOffice having an issue?
I know that it is not commom to use, but could you please put also a table with the aging effects?Yep, I've got the Age field on the Front for that very reason and will be adding this functionality at some point. Usually what happens is I get tired of slogging through the class ability formulas and add on a few little tweaks as a break. Yes, I take a break from Excel by doing other stuff in Excel...I'm a bit weird like that.
Dang...what is the error? That definitely should work in OpenOffice from what I can tell. Anyone else with OpenOffice having an issue?Nope, get an error.
-- david
Papa.DRBNo problem, I'll just wait till the next version.
I think he meanss that Human, Half-Elf and Half-Orc racial modifier (+2 to any ability) is not working. Indeed. As well level advacenement extra ability points each 4 levels... nothing that important right now but something to look over after.
Add them yourself? How exactly do you want the spreadsheet to know which one to pick?
Add them yourself? How exactly do you want the spreadsheet to know which one to pick?
I believe it´s suposed to be the ability bônus box on the side bar to the right of the front tab. And It´s working on the v 0.5.4!!!
So, if you choose Human, Half-Elf or Half-Orc, you have to select there wich ability gains the bonus.
The only thing I haven't found is an option for the ability progression each 4 levels.
The character sheet is missing a few traits.
For example, the "Shingle Runner" and "Sable Company Marine" traits from the Curse of the Crimson Throne Player's Guide are not listed on the "Traits" tab of the worksheet.
Is there a reason these were not included?
There may be other traits missing as well.
I don't have all the guides, so I wasn't able to check.
Add them yourself? How exactly do you want the spreadsheet to know which one to pick?I believe it´s suposed to be the ability bônus box on the side bar to the right of the front tab. And It´s working on the v 0.5.4!!!
So, if you choose Human, Half-Elf or Half-Orc, you have to select there wich ability gains the bonus.
The only thing I haven't found is an option for the ability progression each 4 levels.
Yes, you have to select the ability you want to gain the bonus in the drop-down on the right-hand side of the Front tab. Once you do that, some folks expect the ability to increase, but it doesn't work quite that way. Instead it changes the points spent to reflect the change (i.e. you should end up with 17 points to spend under Standard point buy rather than 15).
For the ability progression every 4 levels, at present I add those (along with bumps from magic items) in the Other Mods field directly below each ability name. So, if you bump Strength at 4th level, put a 1 in the Other Mods field below Strength.
My ultimate design will put these choices over on the Character Options tab along with Feat selection.
Now, all that said if either of the above are not functioning properly, do please let me know.
The character sheet is missing a few traits.
For example, the "Shingle Runner" and "Sable Company Marine" traits from the Curse of the Crimson Throne Player's Guide are not listed on the "Traits" tab of the worksheet.
Is there a reason these were not included?There may be other traits missing as well.
I don't have all the guides, so I wasn't able to check.
These are both feats rather than traits. Sable Company Marine is a the version from Guide to Korvosa (unlike the Player's Guide version, it requires Ride 3 ranks which makes sense to me considering the nature of the feat). It does look like I missed Shingle Runner so I've added it now. The file should contain all OGC traits and feats, so if you do find I've missed any others please let me know!
|
I am not sure if this has been addressed or not but the "Favored Class" needs a drop down menu as opposed to just typing the class in as well as a calculation of either bonus HP or bonus skill point automatically figured in when a character advances in aforementioned Favored Class(es). It's not an "Earth Shattering" thing but, it is something to look into!
I am not sure if this has been addressed or not but the "Favored Class" needs a drop down menu as opposed to just typing the class in as well as a calculation of either bonus HP or bonus skill point automatically figured in when a character advances in aforementioned Favored Class(es). It's not an "Earth Shattering" thing but, it is something to look into!
I do want to put a drop-down there, so...done!
For the bonus HP/skill points, I've got that as free text because I've interpreted the rules as meaning a player can select either HP or a skill point at each level up. The specific rule is:
The choice of favored class cannot be changed once the character is created, and the choice of gaining a hit point or a skill rank each time a character gains a level (including his first level) cannot be changed once made for a particular level.
So I take "the choice of gaining a hit point or a skill rank each time a character gains a level (including his first level) cannot be changed once made for a particular level" to mean that the choice is made at each level. You can't change it afterward (something the sheet currently doesn't enforce--I'll need to move this over to the Character Options tab to do a better job on enforcement), but you don't for instance decide to take HP at 1st level and are stuck with that for all levels.
These are both feats rather than traits.
(Smacks head) Duh! Sorry about that!
Instead it changes the points spent to reflect the change (i.e. you should end up with 17 points to spend under Standard point buy rather than 15).
The point buy system though is a diminishing return, so that won't let a lv1 wizard with 16 int say change his Int up +2 from his human racial bonus to 18, hell it won't even let him get to 17 which costs 3 points more under the point buy system.
Unless I'm misinterpreting.
Instead it changes the points spent to reflect the change (i.e. you should end up with 17 points to spend under Standard point buy rather than 15).The point buy system though is a diminishing return, so that won't let a lv1 wizard with 16 int say change his Int up +2 from his human racial bonus to 18, hell it won't even let him get to 17 which costs 3 points more under the point buy system.
Unless I'm misinterpreting.
Correct. I've captured the data for the point buy system in a table (on the Tables tab) reflecting all the ranges noted in the PRPG. When you change the ability scores on the sheet, the Spent field on the right-hand side uses this chart to calculate how much you've spent. If you select a Human, then select Intelligence as your Ability Bonus, the Spent field changes to -2 (i.e. it gives you points back, so you've got 17 to spend). If you then change Intelligence to 13, the Spent field changes to 1 (you've used the 2 extra points from the Ability Bonus, and then spent another point to get to 13). On the chart, going from 13 to 14 would normally cost another 2 points. However, as you've selected Intelligence as your Ability Bonus, you can actually go up to 15 at a 1-for-1 cost. So, you've got Intelligence 15 now and the Spent field shows 3--you've got 12 points left to spend. Going up to 16 and 17 now costs 2-for-1, so a 17 Intelligence shows 7 Spent and 8 points left. Go to 18, and you are at 10 Spent, 5 left to spend. You can even push it 1 point further (under Standard point buy) to Intelligence 19 for a cost of 13 points. You'll then have 2 points left to spend somewhere else if you like (can't go into Intelligence, as the next step up costs 17 points total).
Now, all that said do please test this out. I may have the logic wrong somewhere and need to fix it. However, in the tests I've run this all seems to work properly.
|
|
I am not sure if this has been addressed or not but the "Favored Class" needs a drop down menu as opposed to just typing the class in as well as a calculation of either bonus HP or bonus skill point automatically figured in when a character advances in aforementioned Favored Class(es). It's not an "Earth Shattering" thing but, it is something to look into!I do want to put a drop-down there, so...done!
For the bonus HP/skill points, I've got that as free text because I've interpreted the rules as meaning a player can select either HP or a skill point at each level up. The specific rule is:
The choice of favored class cannot be changed once the character is created, and the choice of gaining a hit point or a skill rank each time a character gains a level (including his first level) cannot be changed once made for a particular level.So I take "the choice of gaining a hit point or a skill rank each time a character gains a level (including his first level) cannot be changed once made for a particular level" to mean that the choice is made at each level. You can't change it afterward (something the sheet currently doesn't enforce--I'll need to move this over to the Character Options tab to do a better job on enforcement), but you don't for instance decide to take HP at 1st level and are stuck with that for all levels.
I forgot to add one more thing.
Great work!
Now, all that said do please test this out. I may have the logic wrong somewhere and need to fix it. However, in the tests I've run this all seems to work properly.
That sounds great, and I will do. Thanks again for all the great work!
This is a fantastic product!! I've got 4 PFRPG sheets/files and this one far exceeds them all.
Thank you.
Okay folks, important update here--not because I completed the classes I wanted to (I'm woefully behind) but because I finally fixed the drop-down display issue so you can see feats/traits/races/etc. when selecting. Shamefully, I must have been in brain-lock on this one, as all I had to do was reduce my cell size by 50% and do the same to font size. You can then view the sheet at 100% and the drop-downs show up fine...
8^U <-- Me, realizing I should have thought of this about 5 minutes after I first had the problem...
With this resolved, I need some feedback on what direction to go with the Character Options tab. I was building it to take care of things like class options--these will remain--and also feat and trait selection. As the last two are now more visible on the Back sheet, should I drop them from the Character Options tab, add more stuff to that tab, etc.? I can see value in having at least the feats on the Character Option tab--you can then see exactly when any feat was selected if such becomes important. The Back tab feat display at that point would become a summary list similar to what I will do with class abilities. I really do want to keep this sheet as close to a "build it on the sheet" focus as possible, though, and selecting feats elsewhere breaks that model. Of course, I don't want to hang on to a concept when something better is at hand...
So, check it out and let me know what you think. Right now, feats show on both the Character Options and Back tabs for selection--one or the other has to go! This version also has the Wealth by Level logic integrated (thanks to renatsdale for that!), cleans up the Movement Rate calculations (armor modification to speed is now simply a Yes/No), fixes the Spent field for point-buy, and provides ability bump level in a more obvious way, adds the Shingle Runner feat and all the PFS faction traits, adds a drop-down selector for Favored Class(es), and probably some other stuff I can't think of right this minute... And even with all the new features, this version is 23 KB smaller than the last one...
EDIT: Hey, fans popped in while I was typing...Glad you like it and let me know if you think of anything you'd like to see! That type of feedback only makes the product better...
I can see value in having at least the feats on the Character Option tab--you can then see exactly when any feat was selected if such becomes important.
And it can be for fighters who can swap feats, but only fighter combat feats. Should the character option thread display the available class features, rogue talents, barbarian rage power etc, and everything chosen as part of the character's class not automatic, a feat, spell or skill.
My vote is to keep feats on the back tab.
I can see value in having at least the feats on the Character Option tab--you can then see exactly when any feat was selected if such becomes important.And it can be for fighters who can swap feats, but only fighter combat feats. Should the character option thread display the available class features, rogue talents, barbarian rage power etc, and everything chosen as part of the character's class not automatic, a feat, spell or skill.
My vote is to keep feats on the back tab.
Yes, having the class feature selections on the Character Options tab is my primary goal there. I've got the Barbarian's rage powers, the Bard's versatile performance, etc. on there now. I was thinking last night after posting that I should treat the Fighter, Monk, and Ranger bonus feats the same way--the become selections under each class on the Character Options tab. So, I could go that route, but leave the feats gained by virtue of character level over on the Back tab. Alternately I could go that route and leave the feats gained by virtue of character level on the Character Options tab. This might actually be a little cleaner on the Back tab, as with the first route I end up with one section of selectable feats and another section of auto-gained/class option feats.
Thanks for the feedback, and keep it coming!
erian_7 great job - I have noticed that the dex is not adding to the AC.
Ah, error in the calculation to account for the Maximum Dexterity limits from armor and shields...
You can copy this into the AC_Dex_Mod cell to correct it until the next version comes out:
.
.
.
=MIN(Dex_Mod_Current,MIN(IF(Max_Dex_Armor="",100,Max_Dex_Armor),IF(Max_Dex_ Shield="",100,Max_Dex_Shield)),IF(Encumbrance="Medium",3,IF(Encumbrance="He avy",1,IF(Encumbrance="Overload",0,Dex_Mod_Current))))
Thanks for testing!
Great stuff - appreciate all the effort you're putting into this.
AJC
Ah, error in the calculation to account for the Maximum Dexterity limits from armor and shields...
You can copy this into the AC_Dex_Mod cell to correct it until the next version comes out:
.
.
.
=MIN(Dex_Mod_Current,MIN(IF(Max_Dex_Armor="",100,Max_Dex_Armor),IF(Max_Dex_ Shield="",100,Max_Dex_Shield)),IF(Encumbrance="Medium",3,IF(Encumbrance="He avy",1,IF(Encumbrance="Overload",0,Dex_Mod_Current))))Thanks for testing!
For my friends in the fórum using Portuguese BR excell, I´ve translated the AC_Dex_Mod formula, so:
=MÍNIMO(Dex_Mod_Current;MÍNIMO(SE(Max_Dex_Armor="";100;Max_Dex_Armor);SE(Ma x_Dex_Shield="";100;Max_Dex_Shield));SE(Encumbrance="Medium";3;SE(Encumbran ce="Heavy";1;SE(Encumbrance="Overload";0;Dex_Mod_Current))))
Thanks Eric!
For my friends in the fórum using Portuguese BR excell, I´ve translated the AC_Dex_Mod formula, so:
=MÍNIMO(Dex_Mod_Current;MÍNIMO(SE(Max_Dex_Armor="";100;Max_Dex_Armor);SE(Ma x_Dex_Shield="";100;Max_Dex_Shield));SE(Encumbrance="Medium";3;SE(Encumbran ce="Heavy";1;SE(Encumbrance="Overload";0;Dex_Mod_Current))))
Thanks Eric!
Hey, my first alternate language version! You're obviously welcome to all the translating you'd like to do...
Thanks!
Hey, my first alternate language version! You're obviously welcome to all the translating you'd like to do...
Thanks!
Hi Eric!
I´m kind of sick today so I´ve spent all day reviewing the Front, Back and Characte Options tabs.
I´ve tried to keep the most important settings for character creation and progression in the right hand of the Front tab and I also like the feat selection in the Back tab as the others here in the forum.
So I´ve put point buy and starting points in the right hand menu, as well ability bump and Hit Points progression all in front tab's right hand menu.
Doing this, I believe U can concentrate Racial, Class Options, Money and XPs in the Character Options tab.
I believe I´ve made all references for the changes so the excell can calculate the changes without error.
For example: new Str_Score cell name (since the original is now in the right-hand menu and it I´ll always show the starting points) so carrying capacity can follow the Strength progression.
Now, when you select wich ability to bump, it changes the Str_Score and not the Point-Buy. I could explain better but I believe U will understand in five minutes.
I´ll be sending to your e-mail as usual. I´ll send my Fighter Lvl4 also, if you need an example.
Than you can decide to post here this changes or not, afterall, it´s your rights reserved! =)
Hi Eric!
I´m kind of sick today so I´ve spent all day reviewing the Front, Back and Characte Options tabs.
I´ve tried to keep the most important settings for character creation and progression in the right hand of the Front tab and I also like the feat selection in the Back tab as the others here in the forum.
So I´ve put point buy and starting points in the right hand menu, as well ability bump and Hit Points progression all in front tab's right hand menu.
Doing this, I believe U can concentrate Racial, Class Options, Money and XPs in the Character Options tab.
I believe I´ve made all references for the changes so the excell can calculate the changes without error.
For example: new Str_Score cell name (since the original is now in the right-hand menu and it I´ll always show the starting points) so carrying capacity can follow the Strength progression.
Now, when you select wich ability to bump, it changes the Str_Score and not the Point-Buy. I could explain better but I believe U will understand in five minutes.
I´ll be sending to your e-mail as usual. I´ll send my Fighter Lvl4 also, if you need an example.
Than you can decide to post here this changes or not, afterall, it´s your rights reserved! =)
Thanks, I like the direction you took here and will incorporate this into my next release!
I also thought through the AC_Dex_Mod logic a bit more and came to the conclusion that I should be using a simple table and vlookup for all encumbrance effects...
This will, of course, also be in v.0.5.6...
I am interested in helping out in any data entry you might need.
If you could give me an objective I will do my best to have it done as soon as possible.
All I ask is what format will be most useful for you according to what you are doing.
Great! I'll tell you a big one looming is Feats. Right now, the Feats tab only has the Summary information for all the core feats. I need the info from the rules put into the Benefit, Normal, and Special cells for each. My eventual goal for the Summary field is to have any calculations there, so it auto-updates as appropriate. Of course, I also need Summary information for all the non-core feats, but I figure I'd create that as I did any necessary formulas.
Another area is the Class Abilities for the core rules prestige classes. Again, the format is already in the file--I'd be looking for the Class Ability and Full Description fields to be completed. I work from there to generate the prerequisite formulas and Basic Summary.
Really long term goal is a Spells tab that breaks out all the spell info. That'll be a really big job, however, and isn't on my radar until I complete the classes and feats. Anybody really interested in that let me know--I've got a 3.5 spell XLS I can provide as a guide.
Another thing I'd like to do is review all of the Traits and non-core Feats for compatibility with PRPG. I've changed some, but I really should have noted the changes and archived the original in case folks have questions. Of course, this is more than data entry and so may be outside what you're looking to do...
if someone else might wanna volunteer maybe they start at M that way we dont overlap our work.
I'm working on M+.
Actually, I have a question...
Should we be copying HTML links to the PRD? And if so, how do we do that? When I copy and paste into the character sheet the links are not maintained.
Edit: To answer one of my own questions here, I don't think we should be linking to the PRD. If the site changes or links change then the character sheet will become full of broken links. I believe that the sheet should be more self-contained.
Feats M-Z are done.
Got 'em both, thanks guys!
For the prestige classes, having the class abilities separate out into Class Ability name and Full Description let's me start right in on coding things in the Summary, so it's definitely helpful.
Wrapping up the Paladin tonight, and I'll publish v.0.5.6 after that since I've cleaned up some of the Encumbrance and Armor Check Penalty formulas in addition to working on the classes. I've also streamlined the existing formulas even more, so we're still around 600 KB.
Very very excited for Monk class abilities.
My group is running Rise of the Runelords and we're officially converting to PF final rules for the next meeting (in ~2 weeks, on a bit of a break), and your sheet is easily better looking than anything else I've come across.
Cheers!
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 things like Max Dex, Armor Check Penalty, and Speed Reduction. This does mean I need folks to be on the look-out for errors and bugs as well as compatibility issues in things like OpenOffice, but from my research we should be good to go for compatibility. My research also found that someone had been working on an OpenOffice solution for the IFERROR function, but it looks like it got abandoned back in 2008. A compatibility check run against older versions of Excel only found minor loss of fidelity in 13 cells (can't figure out where they are right now or I'd fix those too!).
And so, without further blabbing from me, v.0.5.6!
Some of the formatting into cells seems to have been messed up with the new feat data. I don't think the cells are wrapping the text properly.
I was hoping that we could get an intro on "How to Use the Sheet" somewhere, maybe on the first page. I'd also like to see all the "Legal" stuff be more conveniently "hidden." Can it be behind a button or something?
As for how to use the sheet, I must be doing something wrong on step 1 when I am at the "Front" page and I set the point buy to "Epic" then start putting stats in the starting abilities. I don't see "spent" update. Should it? I suppose there are going to be varying ways to use the sheet but a basic method to direct people through setting up a character would be nice.
I could see a per class "How to" option in the future, but something simple for now would be useful.
Maybe have a version Change-log on the first page too?
And, finally, is there an easy way to convert a character sheet from an earlier version of the sheet to a new version?