The best advice I can give you, Erian, is to pay attention to the pixel counts for column widths and row heights - sum them up for all of the cells in the printable area.
Make sure that the aspect ratio is as close to 8.5 high by 11 wide as you can.
I have not tried making an absolute limit on a page layout. Where does that command live?
Perram's Spellbook is definitely good stuff. I was fretting over how best to integrate a "spell book" function into my sheet, but for now I'm just going to point folks his way.
I saw this on the other thread and had a notion that perhaps you could somehow pass a list of spells from the sheet to the web app. A page of drag-down boxes similar to adVance, with a "send to Perram's Spellbook" button, or something. Just a thought...
Zo
Brilliant work here, erian_7, truly. Got a question, and man I suspect I know the answer which makes me feel the utter fool. I bump Intelligence by two points at levels four and eight. This is base Intelligence, obviously, not through a magic item. Do I get the additional skill points as a result of that Intelligence boost, as I would the additional hit points with a Constitution boost?
I do have one more, the Spell page doesn't seem to be populating with spells per day/spells known numbers at all, am I missing something?
Edit the First: As to the first question: I did a bit of Googling and found my answer. Skill Points are in fact retroactive. So yes, I do in fact feel like an utter fool.
General note, I'm about 75% through the eidolon evolutions. Almost there!
The best advice I can give you, Erian, is to pay attention to the pixel counts for column widths and row heights - sum them up for all of the cells in the printable area.
Make sure that the aspect ratio is as close to 8.5 high by 11 wide as you can.
I have not tried making an absolute limit on a page layout. Where does that command live?
Yeah, I try to do that on all the pages, but apparently my best-laid plans go awry sometimes...
For the automatic bit, in Excel 2007 on the Page Layout tab, the Scaling section apparently defaults to Automatic height and width, and then it has a % scale beneath those. All of the pages being reported with problems printing were set to Automatic, while the proper pages are set to 1 page in both height and width. So, in the last iteration I switch the problem pages. I'm interested to see if that fixes the problem...
Perram's Spellbook is definitely good stuff. I was fretting over how best to integrate a "spell book" function into my sheet, but for now I'm just going to point folks his way.I saw this on the other thread and had a notion that perhaps you could somehow pass a list of spells from the sheet to the web app. A page of drag-down boxes similar to adVance, with a "send to Perram's Spellbook" button, or something. Just a thought...
Zo
Hmm, I don't know exactly how much could be automated, but I'll check in with him. I might be able to generate a text string that he could then read into his site from a copy/paste...
Brilliant work here, erian_7, truly. Got a question, and man I suspect I know the answer which makes me feel the utter fool. I bump Intelligence by two points at levels four and eight. This is base Intelligence, obviously, not through a magic item. Do I get the additional skill points as a result of that Intelligence boost, as I would the additional hit points with a Constitution boost?
I do have one more, the Spell page doesn't seem to be populating with spells per day/spells known numbers at all, am I missing something?
Thanks! For the skill points, they are indeed retroactive. This is actually a little problematic when you get to things like the headbands and enhancement spells. The former should only grant bonus ranks in predetermined skills and the latter don't grant ranks at all. I'll be putting some better controls around this in v.0.8, which will have a major focus on automating spell effects and magic items.
The Spell tab at present is not very automated at all. As with the above, I'll be putting a lot more work into it for v.0.8. I'm thinking the sheet would be copyable, so you could make as many as needed for multi-class characters. It will have a drop-down for available casting classes, and once selected it will auto-populate the various sections as appropriate. Some of the current sections, like familiars, are now unnecessary due to other areas of the sheet, so I'll be "reclaiming" that space for other use.
One more thing I'd noticed. Skill points. The points spent box, when it is not zero, is always red, even if I've got down exactly the number of ranks that I'm allowed. Is this a glitch of some kind?
Edit: I have another one. Sorcerer, Draconic Bloodline (5th level) + Dragon Disciple (7th level). If I am reading the rules correctly (and from what I've read on the forums, I think I have a confirmation) the total natural armor bonus should be +5 (getting +2 for Sorcerer "9th" level, since the DD levels count as sorcerer levels for the purposes of determining bloodline powers, and getting +3 for DD Level 7). I'm only showing +3 in the Natural Armor box. Am I missing something?
Second Edit: Ah, am I reading this correctly then:
=Race_NA+Improved_NA+MIN(3;CEILING(Lvl_DragDis/2;1;1))+IF(ISNUMBER(FIND("Hi story of Scars";Feats_Known));2;0)+IF(ISNUMBER(FIND("Twisted Flesh";Feats_Known));1;0)+Magic_Item_NA
...doesn't seem to have a mechanic to check for Sorcerer, Draconic bloodline?
Wow, I'm nitpicky today, sorry.
...a notion that perhaps you could somehow pass a list of spells from the sheet to the web app. A page of drag-down boxes similar to adVance, with a "send to Perram's Spellbook" button, or something. Just a thought...
Zo
Hmm, I don't know exactly how much could be automated, but I'll check in with him. I might be able to generate a text string that he could then read into his site from a copy/paste...
Yeah, something like that would be cool. It's not a "must have" by any means but using your sheet to keep track of a spell list and his app to generate the "spellbook" itself would be pretty sweet. I'm sure you've got your hands full at the moment. It was just a thought. Keep up the good work!
Zo
One more thing I'd noticed. Skill points. The points spent box, when it is not zero, is always red, even if I've got down exactly the number of ranks that I'm allowed. Is this a glitch of some kind?
Edit: I have another one. Sorcerer, Draconic Bloodline (5th level) + Dragon Disciple (7th level). If I am reading the rules correctly (and from what I've read on the forums, I think I have a confirmation) the total natural armor bonus should be +5 (getting +2 for Sorcerer "9th" level, since the DD levels count as sorcerer levels for the purposes of determining bloodline powers, and getting +3 for DD Level 7). I'm only showing +3 in the Natural Armor box. Am I missing something?
Second Edit: Ah, am I reading this correctly then:
=Race_NA+Improved_NA+MIN(3;CEILING(Lvl_DragDis/2;1;1))+IF(ISNUMBER(FIND("Hi story of Scars";Feats_Known));2;0)+IF(ISNUMBER(FIND("Twisted Flesh";Feats_Known));1;0)+Magic_Item_NA
...doesn't seem to have a mechanic to check for Sorcerer, Draconic bloodline?
Wow, I'm nitpicky today, sorry.
Good catch on the natural armor--fixed that! For the skills, this seems to be working for me. Check it in the latest version and then let me know again...
And not nit picky at all. I want to fix every little bit I can!
So, here's the newest version. I'm shooting for this to be the final draft before sending up a v.0.8 to the Pathfinder DB. The storms moving through the southeast delayed me a bit, so I'm going to leave this open for review through Wednesday. The eidolon is mostly done, but I realized a full implementation will have to wait a bit--since they can take any feat, that means full feat and skill automation is more complex than I expected.
As I'm shooting for this to be the "final" for layout as well, I've rebuilt the various tabs intended for printing to be landscape. I also took the opportunity to automate the Spell tab a bit.
Landscape Character Sheet File: PRPG_CS_L_v_0_7_16.zip
When selecting a longbow as a weapon, I get #NUM! errors in both Attacks and the right part of the "Damage" box. Any thoughts?
This is working right now for me, but maybe we can drill down to the problem. You have "Longbow" as the weapon, with "Ranged" and "2-Handed" selected correct? Anything else set in the weapon block?
|
When selecting a longbow as a weapon, I get #NUM! errors in both Attacks and the right part of the "Damage" box. Any thoughts?This is working right now for me, but maybe we can drill down to the problem. You have "Longbow" as the weapon, with "Ranged" and "2-Handed" selected correct? Anything else set in the weapon block?
Nope, that's how I have it...nothing else is in there. I did get it to work on another character I pulled up, so I guess I'll just scrap the one it isn't working on and start over and see if that doesn't fix it.
Nope, that's how I have it...nothing else is in there. I did get it to work on another character I pulled up, so I guess I'll just scrap the one it isn't working on and start over and see if that doesn't fix it.
If you'd like, you can email that sheet to me and I'll check it out...
Yeah, something like that would be cool. It's not a "must have" by any means but using your sheet to keep track of a spell list and his app to generate the "spellbook" itself would be pretty sweet. I'm sure you've got your hands full at the moment. It was just a thought. Keep up the good work!
Zo
Working on this now. I've inserted a link at the top of the Spell tab to Perram's Spellbook, and have started discussions with him about the best way to get a data-dump that would facilitate automating the process. I'll of course be working to keep it in line with my cross-platform compatibility goals, but I think we should be able to work something out...
From erian_7:
Good catch on the natural armor--fixed that! For the skills, this seems to be working for me. Check it in the latest version and then let me know again...
Well, not quite... same scenario as before I'm only showing +4 in the box, so you got part of it but not both. Though the listing in the Abilities and Feats tab is correct, so I think there's something still missing in the formula. I think the formula is only counting Sorcerer levels as 5 for effective level and not "Effective sorcerer level 9" maybe? Again, you have it listed in the Abilities and Feats correctly (that shows it as the correct effective level, showing under Sorcerer as Resist Fire 10 and Nat Armor +2).
As for the skill points box, yes it is now working as it should... but for some reason now the languages count box is constantly red. With an Int 16 I should have three additional languages, right? But for some reason as soon as I put one in it goes red. Doesn't matter what language is selected, or which box it's put in, I get a red in the Languages count box.
Well, not quite... same scenario as before I'm only showing +4 in the box, so you got part of it but not both. Though the listing in the Abilities and Feats tab is correct, so I think there's something still missing in the formula. I think the formula is only counting Sorcerer levels as 5 for effective level and not "Effective sorcerer level 9" maybe? Again, you have it listed in the Abilities and Feats correctly (that shows it as the correct effective level, showing under Sorcerer as Resist Fire 10 and Nat Armor +2).
Ah, found it--I needed to tweak the formula on both the Bloodline tab and the Front. Fixed for v.0.8! I also cleaned up some of the higher level dragon disciple class abilities--looks like I got distracted and missed a few in my first pass.
As for the skill points box, yes it is now working as it should... but for some reason now the languages count box is constantly red. With an Int 16 I should have three additional languages, right? But for some reason as soon as I put one in it goes red. Doesn't matter what language is selected, or which box it's put in, I get a red in the Languages count box.
I found that the conditional formatting rule was pointing at the wrong cell for languages. Fixed.
Thanks!
Yes, I actually like spreadsheet based spell sheets as well, but specifically because I can then put formulas in place to automatically calculate all the spell variables. This will likely become functional in this character sheet at some point, but it's well into the future. As such, I figure giving folks some options for now is better than nothing...
For all, I've corrected all issues reported to date. I have also reformatted the Character Options tab to a new Getting Started tab. I think the layout and grouping should make building a character much easier, but want to get some feedback from my folks on other platforms. I did a quick check in OO and it seemed okay. I have also added a FAQ tab to start answering those questions that keep popping up (flurry of blows is on there now, along with adding non-OGC material). I plan on putting out a fix per day leading up to v.0.8 on Friday.
Let me know what you think!
Landscape Character Sheet File: PRPG_CS_L_v_0_7_17.zip
Working on this now. I've inserted a link at the top of the Spell tab to Perram's Spellbook, and have started discussions with him about the best way to get a data-dump that would facilitate automating the process. I'll of course be working to keep it in line with my cross-platform compatibility goals, but I think we should be able to work something out...
That is fantastic.
FWIW - I prefer spreadsheet based spell lists over spell cards. Perhaps I have just played too many characters with a lot of spells. The general idea is to have each spell description per line (or at most 2 lines).
There's a fully functional Excel spell sheet for Pathfinder called adVance out there that does just that. No need for Erian to go to all that work recoding the same functionality for hundreds of spells in his sheet, right?
Zo
I just wanted to drop in to say that I REALLY look forward to seeing the eighth iteration.... this tool is absofreakinglutely Schweeet!
Is this the same as the HeroForge Pathfinder character sheet?
Hmm, oddly enough my last reply is not showing. Reposting...
For all, I've corrected all issues reported to date. I have also reformatted the Character Options tab to a new Getting Started tab. I think the layout and grouping should make building a character much easier, but want to get some feedback from my folks on other platforms. I did a quick check in OO and it seemed okay. I have also added a FAQ tab to start answering those questions that keep popping up (flurry of blows is on there now, along with adding non-OGC material). I plan on putting out a fix per day leading up to v.0.8 on Friday.
Let me know what you think!
Landscape Character Sheet File: PRPG_CS_L_v_0_7_17.zip
Thanks for the tip, looks like the adVance sheet is pretty much what I was looking for. In case anyone else is interested, I'll save you the search: http://www.ashmead.net/~angel/sCore/Pathfinder-adVance-b29.zip (linked from http://chargen.motime.com/).
Just to be clear - I was not asking Erian to do something, just giving some feedback now that he is more seriously trying to figure out how to deal with spells.
Finally, on a related subject, does anyone know of a similar spreadsheet for the Spell Compendium (free or paid)? Just looking to save some typing.
Yes, I actually like spreadsheet based spell sheets as well, specifically because I can then put formulas in place to automatically calculate all the spell variables. This will likely become functional in this character sheet at some point, but it's well into the future. As such, I figure giving folks some options for now is better than nothing...
And note that I absolutely WANT you to ask me for things--that's exactly how the sheet keeps getting better and better! As for the Spell Compendium, that one is not OGC, so anything you find technically isn't legal...
I just wanted to drop in to say that I REALLY look forward to seeing the eighth iteration.... this tool is absofreakinglutely Schweeet!
Well, I think you'll be very happy indeed--I've been thinking on the condition, effect, and magic item automation and I believe I'll be able to get that running very quickly.
And a happy note for all, Rite Publishing has jumped on board with support for getting their OGC content in. I've now got so much material from 3PP Pathfinder supporting companies that it will likely double the current number of feats, races, and classes.
Is this the same as the HeroForge Pathfinder character sheet?
The HeroForge folks did indeed post a link to my work. I haven't checked in a while to see if they are keeping up with the test releases. When I send a copy up to the Pathfinder DB I also send a note out to several folks that like to keep the latest baseline versions posted, and the HF folks are on that list.
Any chance on getting the Diabolist prestige class into the sheet?
Hmm, I cant input any numbers into the starting scores for the abilities on v 7.17 . It says its not a valid value no matter what. Ive never had this issue before.
Yep, the data validation for those cells got broke--I've fixed it and considering the critical nature of that issue for testing am uploading a new version...
Landscape Character Sheet File: PRPG_CS_L_v_0_7_17_1.zip
Note this one also has a tweak for handling the ability bonuses added on the Front. There are now boxes for Permanent Bonuses (i.e. like something from a tome or manual) and Other Bonuses (which won't count for things like Skill Points). This is in part to set things up for handling magic item automation, since headbands of intellect and the like must be handled separate from a "real" Intelligence boost.
Any chance on getting the Diabolist prestige class into the sheet?
Absolutely! One of the things I'm aiming at for the next iteration is to cover the rest of the Paizo prestige classes, and the Diabolist will come in with those.
Do you know when the next iteration would be? I hope I'm not seeming pushy here...
Lots of crazy stuff
Sorry, cross post from another thread...
Do you know when the next iteration would be? I hope I'm not seeming pushy here...
By next iteration, you mean the one with the diabolist, I assume?
;^)
Right now, I'm focused on getting v.0.8 wrapped up and over to the Pathfinder DB. I basically try to work in "chunks" and post major releases every 3-6 months over there. Here on this thread, I post a new version about 1/week, but this week I'll be posting a version 1/day (or more if necessary) in order to get v.0.8 ready. Once that is done on Friday, I'll be shifting gears to my v.0.9 release, and that is when I'll be getting the diabolist and other PrCs in place. So, it could be in as early as next week...
Awesome; our new campaign won't be starting up for a few weeks yet. There are some excellent PF character sheets out there (yours included), but none seem to include some of this more peripheral stuff.
Looking now at 1.17.1.... on the Getting Started tab (fantastic idea by thy way, this will definitely streamline a bit)... you have Bonus HP listed twice, but the second box is supposed to be Bonus SP I am assuming? It's a simple thing, thought you ought to know. I think that everything else I'd found (including the Sorc/DD natural armor bonuses) are now where they ought to be. I can't hear my own thoughts over the sound of the awesome here. Cheers to you, erian_7!
Looking now at 1.17.1.... on the Getting Started tab (fantastic idea by thy way, this will definitely streamline a bit)... you have Bonus HP listed twice, but the second box is supposed to be Bonus SP I am assuming? It's a simple thing, thought you ought to know.
Ah yes, the joys of copy/paste...fixed it!
I think that everything else I'd found (including the Sorc/DD natural armor bonuses) are now where they ought to be. I can't hear my own thoughts over the sound of the awesome here. Cheers to you, erian_7!
8^D
Thanks!
Erian- I've sent a sheet with some minor formatting changes, and a fix that I've wanted on the 'Getting Started' page for quite some time.
The formulas are:
'Getting Started'!K21
=K9+K11+K13+K15+K17+K19
'Getting Started'!M21
=IF(AND(H6<>"Custom",K21>P6),ABS(P6-K21)&" Points Over",(IF(K21<P6,P6-K21&" Points Left","")))
I also added conditional formatting to change the color of the text to red if you're over budget.
=AND(H6<>"Custom",K21>P6) is the formatting trigger, and it makes the text red and bold to catch the eye, while telling you how MANY points over you are.
From UI and work flow perspective, I would move the Other Details and Game Settings above the area where Traits and Manual Settings are selected.
On the P-Front tab, I made the formatting for the headers for armor and shield consistent with the formatting for the headers for the weapon blocks.
I have added the following conditional formatting rules:
=$AA$13+$AJ$13>$AC$13 (AJ13, AA13) on Getting Started. If true, it makes the text red and bold.
I also updated the label in cell AE13 to Bonus SP.
I didn't intend to imply a sheet-based spell list wouldn't be welcome. I use adVance myself, though the TOS+ spell sheet is useful too. Took a brief look at the new getting started sheet and it's looking pretty good. Can't wait for the portrait sheet to get updated!
Zo
FAQ item:
Q: "Why aren't the skills straight alphabetical? I can never find anything..."
A: The skills are sorted into two lists and are alphabetical within that list. The two lists are 'skills that can be used without putting a rank in them' and 'skills that can't be used untrained.'
(If it's possible, I'd recommend putting a toggle on the Getting Started page that swaps the order that the skills show up in, from your split listings to the 'straight alphabetical' listing and back.)
Here are some review comments on 7_17_1:
* I can't get the plus to expand on the Getting Started tab (like the one on line 61) unless I unprotect the sheet. Using Excel 2007.
Hmm, I can't find a fix to this. Looks like I'll have to leave the sheet unprotected.
* Custom schools still have not made it to the Customization Tab
* Had a number of feats come up red (like Craft Wand). I think this is because most of the character's magic levels are in a custom prestige class. In the custom prestige class I have put "1" for arcane caster level, is this being taken into account when checking for feat validity?
You are indeed correct on the caster level check for pre-reqs. I'm looking to show some love to the Customization tab today, and will hit these in the process.
* There are a number of "how do you do this questions" that should be added to the FAQ or put in notes (I would like answers now for the first 2):
- How do you fill in natural armor class? (it is no longer fillable)
- For custom feats, what values should I place in the Qualified column?
- Steps to selecting weapons for Weapon Focus, etc. I found this one (slightly different, but improved since v7.8).I had a few more, but the browser ate them (retyped the above from memory - serves me right for using the browser for composing :-( ). I will do some more testing later...
Good ones. I'll add these to the FAQ. For manual entry of Natural Armor (and soon Deflection) you'll use the Misc 1, 2, and 3 boxes to cover these. The cells above will be used for effects and magic items.
For Qualified on Custom Feats, you've got the easy route--just state TRUE or FALSE for the character in question--and the harder route of writing the logic necessary, such as:
=AND(Dex>14,ISNUMBER(FIND("Nimble Moves",Feats_Known)))
To renew a past (favorite) request, is there anyway to make it easier to transfer characters to a newer version of a sheet. Especially when dealing with high level characters using a number of customer items, it takes quite a bit of time to do manually transfer.
I don't have any good means of handling this at the moment since I don't use macros. I'll put an entry in the FAQ to cover this.
Good stuff on formatting
All incorporated for today's release. Thanks as always!
I didn't intend to imply a sheet-based spell list wouldn't be welcome. I use adVance myself, though the TOS+ spell sheet is useful too. Took a brief look at the new getting started sheet and it's looking pretty good. Can't wait for the portrait sheet to get updated!
Zo
I aim to get the Customization tab standardized today, and assuming both that I finish that and no major issues are reported, I'll also be building the Portrait view. I want to keep that build as close to the release as possible, as otherwise maintaining two versions will be a bear...
FAQ item:
Q: "Why aren't the skills straight alphabetical? I can never find anything..."
A: The skills are sorted into two lists and are alphabetical within that list. The two lists are 'skills that can be used without putting a rank in them' and 'skills that can't be used untrained.'
(If it's possible, I'd recommend putting a toggle on the Getting Started page that swaps the order that the skills show up in, from your split listings to the 'straight alphabetical' listing and back.)
Good one, I'll add that. I'm not sure how I'd get a toggle to work without macros, though. Any thoughts? I could include alternate sort orders as text blocks folks could copy.
Skill Sorting
Make the following table:
Column #1 has the skills in your order
Column #2 has the skills in the default order
Column #3 has the skills in an order specified by the user somewhere in the customization tab.
In the 'Getting Started' tab in the "Game Setting" area, put a drop down where the player can select which of the three options is in use.
Then pull all the other information in the skills area by VLOOKUPS driven from the name pulled.
Hmm, that approach will require adding formulas to the skill selectors on the Front tab, which I'm a bit hesitant to do. Of course, I can leave the cells unlocked to people can change them if they like, but I've found people are reluctant to change cells containing formulas, so it might get folks thinking they can't use the drop-downs on the Front.
What do other folks think?
I don't know where you are currently at with the Companions tab, but the feat drop downs are all broken for me. All I get are a bunch of selectable 0's. I got the names to show up by changing the formula in column CP from INDIRECT("CF" to INDIRECT("CK".
I can't wait for the full version so I can migrate my entire party to it. They are all digging on the landscape layout. Keep up the good work!
Yep, looks like the rows got shifted while I was working on the page layout. Fixed it!
Okay all you Customizers out there, I've got half your release ready...
Landscape Character Sheet File: PRPG_CS_L_v_0_7_18.zip
The Customization tab has started its transformation, and I believe you'll find the races and classes much easier to work. This shows off what I'll be doing with the rest of the customization areas, so let me know what you thinkg. I tested these out in between formatting, so I think they are pretty solid.
Oh, and the Diabolist is indeed a playable class with this release, since I used it as the basis for testing the custom PrC.
Perhaps I ran into a bug then - I tried the simple route of just putting "TRUE" here, but the custom feat still came up red. Tried FALSE, "0", and "1" for good measure - always ended-up red.
For Qualified on Custom Feats, you've got the easy route--just state TRUE or FALSE for the character in question--and the harder route of writing the logic necessary, such as:=AND(Dex>14,ISNUMBER(FIND("Nimble Moves",Feats_Known)))
Okay, I haven't gotten to that section yet, but I'll kick the tires and see what's what...
Sorry dont have time to sort through this Thread at work right now.
Does this Heroforge Pathfinder work with the CORE pathfinder new rulebook? CMB CMDs and all?
Does it incorporate the new class structures?
What extended book material does it incorporate?
What does it NOT do?
Does it work on Open Office? or is it Excel (macros) only.
This sheet is designed from the ground up using the Pathfinder RPG rules, so it does indeed cover CMB/CMD, sorcerer bloodlines, etc. While it was inspired by HeroForge many years ago, it's not from the same folks.
All classes and prestige classes from the core rules are in place, as are the Advanced Player's Guide beta classes. I'm also adding 3rd party classes as I get them. Beyond that, as I'm a subscriber to Paizo's lines, I incorporate all OGC from their releases. I also incorporate OGC from publishers that are producing new material for Pathfinder RPG. I don't specifically incorporate any older 3.5 or d20 material--this is strictly PRPG. The sheet is built to be used in-game, live during play, and also as a printed sheet.
What it does not do is some of the fancy stuff of other sheets. I don't use macros or VBA, so the sheet stays compatible with a large array of operating systems and applications. However, this limitation does mean I can't offer things like an "auto-reset" to clear data or an import/export option to move between versions of the sheet.
After this major release (coming Friday), I'm shifting over to automation of conditions, effects, and magic items (along with incorporating my back-log of OGC).
I'm sure I've missed some things, but if you have any other questions feel free to ask.