| 13 people marked this as a favorite. |
Character sheet
Hi folks,
For the past six months or so, my party has been using this Excel character sheet to generate their characters. I created it after our first session, as I saw that the process of creating a character can be quite overwhelming to a new player.
Overtime the character sheet grew to include some helpful features. It contains and calculates most of the data in the Core Rule Book. It abbreviates information regarding abilities and feats, creates an exact number of check boxes for each per day/per round ability so you can mark it off during the game. It also produces printable spell cards for each selected spell. Finally it contains a store that allows you to calculate equipment purchases and a gear creator for creating magic weapons and armor.
The sheet itself consists of two pages for non-spell casters, plus two extra pages for spell casters (four total). The first page is designed to look similar to the Paizo's official character sheet with a little extra information (resistances, immunities, etc.).
The second page includes all of your character's special abilities, feats and equipment.
The third page is divided into two halves. The top half contains spell caster information as well as spell slots, while the bottom half has space for your familiar/animal companion/mount.
The fourth and final page is a simple Wizard's spell book.
Right now the sheet is limited to Core Rules and allows for multi-classing up to 4 classes, I do find bugs occasionally, but it's at a state where we use it in our campaign regularly. As a GM, I found that it speeds NPC creation by a significant amount.
Links:
Go to Screenshot of sheet
Go to Checkbox panel view
Go to Character Sheet Download
-------
GM Tools
This is an Excel workbook that I've created to aid me in making and running the adventure.
It contains:
- A GM Screen – The screen that I run from my laptop during the game. It allows me to track initiative and damage. Game time and effect duration (through a special clock that counts rounds). It also contains a dynamic stat block which brings up all of the information regarding a selected monster. In the center of the page is a panel that describes the current area that the PCs are visiting.
- An encounter designer – Calculates encounter XP and treasure.
- An areas database – here you can enter all of the information for your areas and bring them up in the GM Screen.
- A monster data base – Here you can enter your own monsters and then reference them throughout the workbook.
- A party rewards tab – This tab keeps track of all the XP and treasure that your party has collected. It references the monster and area data base for this information. It can divide these rewards according to the number of your players.
I've used the GM screen in only two adventures thus far, it has been a great help, but it still needs a lot of work. I've included a version here that is completely blank, as well as a version with data already entered from Paizo's adventure "Voice in the Void", so you can have an example of how to fill it out.
If you download these sheets, please let me know what you think, let me know if something is broken and tell me if you have any suggestions or ideas or requests (I know... APG contenct :)).
Links:
Go to GM Tools
Go to GM Tools - Voice in the Void Example
-------
You need Excel 2007 or newer to use these. They do not work very well in Open Office. I suggest that for each character/adventure you start with a blank file.
Dotted
I've taken this for a spin and so far things look like they work pretty well.
Here are a few bugs I noticed:
*Under fighter weapon training, the descriptions for light and heavy blades are mixed up. For heavy blades it lists the light blades and vice versa. But the bonus seems to be applied correctly for weapons that are actually used.
*Barding costs and weights seem wrong. For a large creature (e.g. horse), a chain shirt is stated as costing 4200 gp and weighing 550lbs. As far as I can tell (from the PRD) it should cost 400gp and weigh 50 lbs (4x cost, double weight).
*Intimidate is listed as having STR as its key attribute rather than CHA. I can understand if you want to house-rule this, but it does rather defeat the purpose of the Intimidating Prowess feat.
*Weapon Focus doesn't seem to be working properly. It lets me select feats based off it, but none of them (including WF) seem to be applied. Under the WF description it keeps telling me to add a weapon in the Weapon Focus Feat selector, despite the fact that I've already added it there. If I enter weapons in all three of the WF options, it displays N/A in the description above.
Correction to the above: After changing my Human Bonus feat from Power Attack to Quick-Draw, having WF as my level 1 feat now works. And it works when I switch the Bonus Feat back to Power Attack.
*It's a little odd that you have to enter all your equipment TWICE. Once in the store, and once in the equipment inventory on the Character Sheet. Is there any reason why it doesn't transfer from one to the other?
* There doesn't seem to be a tally of your skill points. I guess the fields turn from yellow to white/gray when you've used all your available points, but it doesn't tell you something is wrong if you add more ranks.
Things I would love to see added:
*Feats from the APG. I know this would be time-consuming, but some of them are ubiquitous, like Furious Focus. (ETA: I just noticed that you were aware of this desire. I don't mean to harp on about it :) )
* Along the lines of this, the ability to enter custom feats (that don't necessarily have constant game-mechanical effects). At the moment the sheet complains pretty loudly if you try to enter a custom feat.
*Tweaks to HP calculation. A pretty common method is to give full HP at level 1, and then average or rolled values beyond that. Having that as an option would be really nice.
Overall, this is an excellent sheet. I personally tend to prefer an actual paper and pencil sheet for myself, but there are people in my group who will be extremely excited to have this to use. They were complaining quite a bit about moving to PF from 3.5 because they're used to using HeroForge (I think?) to create and maintain their characters. I'll definitely be passing it on to them.
I haven't tried taking a look at the GM tools, but I'll pass them on to my GM, who may be quite excited about trying it out.
Incidentally, my list of bugs is not intended as a critique. I'm just hoping to help you improve this, and finding bugs is something I seem to be very good at. Now if I were as good at eliminating them as I am at finding them, I'd be set...
*DOINK!*
Not to besmirch the obviously INSANE amount of work that has gone into this, have you looked at all at the RPTools apps? I've not used them for Pathfinder, but to my knowledge, they are very comprehensive, and being Java apps, largely platform independent.
dotted
One other thing I noticed is that your grop seems to use 100sp = 1gp and 100cp = 1sp.
While there's nothing wrong with a houserule like that, I wouldn't include it in a sheet for general consumption :)
Standard rules are 100cp=10sp=1gp.
ETA: I'm trying to see how to change this back to the normal ratio and I'm having a little bit of trouble, I must admit. I haven't played around with Excel at this level before, so it's not intuitively obvious to me how to change it, or how difficult it would be to do so.
The Character Tool for RPTools doesn't seem to work with Pathfinder. I downloaded it and it's complaining about missing library files.
These look... dead sexy. I'm utterly devastated I have Excel 2003. Props to you.
I did not do everything, but I did toy around with it in Open Office. I did not have any issues? What problems came up on your end and what version of open office did you use?
One thing that seems to be missing is "Perception" under skills - but maybe I'm blind
One thing that seems to be missing is "Perception" under skills - but maybe I'm blind
Perception got its own little box right of the hitpoints. Considering how often you need perception, giving it a special place seems like a great idea.
Personally, I like the character sheet but I'm not too fond of editing my characters on a PC. Too much hassle printing a new one every time something changes. Any chance you could add a blank version of the character sheet?
But other than that, this file is pure awesome. I'll definitely use it for planning character. Thanks for sharing! :)
Edit: Some option to freely chose domains (and favored weapon) for clerics would be nice. Could be useful for clerics without a deity or the servants of minor gods.
I just stumbled over this when I tried to create a cleric of Milani.
On a similar (minor) note, it would also be nice if changing the deity of the character would clear the domain slots.
And the dwarven hardy racial trait adds a +2vs poison note to the saves, but notthe +2vs spells and SLA.
After tinkering around a bit more, I got a few more suggestions/bugs:
1. Add a blank entry to all dropdown menus. Having no option to undo a mis-click (while creating a custom weapon for example) is a bit annoying.
2. Something seems to be off with custom items and their special qualities. I made a Mithral Full Plate for my cleric (he has the feat) and for some reason, the -3 armor check penalty is applied to his attack rolls. Doesn't happen with a normal full plate. Just checked Adamantine: Same bug as with mithral, too.
As someone who is using a mac, I much appreciate an excel utility that does not use VB macros, since they don't work on my machine :)
As someone who is using a mac, I much appreciate an excel utility that does not use VB macros, since they don't work on my machine :)
Having something for mac would be great yeah!
As someone who is using a mac, I much appreciate an excel utility that does not use VB macros, since they don't work on my machine :)
In fact, ONLY people who have paid for Excel can use them. Macro'd books don't work in Open Office/Libre Office either.
I don't see why no one tries to make a real program.
As someone who is using a mac, I much appreciate an excel utility that does not use VB macros, since they don't work on my machine :)In fact, ONLY people who have paid for Excel can use them. Macro'd books don't work in Open Office/Libre Office either.
I don't see why no one tries to make a real program.
I've paid for Office for the mac. But I still can't run VB scripts/macros. The original sheet being discussed in this thread does in fact work on Excel 2008 for OS X, which is why I'm rather excited about it getting fixed and upgraded.
As someone who is using a mac, I much appreciate an excel utility that does not use VB macros, since they don't work on my machine :)In fact, ONLY people who have paid for Excel can use them. Macro'd books don't work in Open Office/Libre Office either.
I don't see why no one tries to make a real program.
While there are limitations, there is a limitation with everything. I think this is a great utility with a lot of potential to cut down on the tedium that can come with character/game generation. Doesn't hurt that it's free either.
However, you could be the first to make a "real" progam.
I removed a post. Please don't advocate illegal activities on our messageboards.
Hi everyone. Thank you all for the comments and support.
Here you can find the latest version of the sheet which includes most of the features and fixes that people requested:
*Under fighter weapon training, the descriptions for light and heavy blades are mixed up. For heavy blades it lists the light blades and vice versa. But the bonus seems to be applied correctly for weapons that are actually used.
*Fixed*
*Barding costs and weights seem wrong. For a large creature (e.g. horse), a chain shirt is stated as costing 4200 gp and weighing 550lbs. As far as I can tell (from the PRD) it should cost 400gp and weigh 50 lbs (4x cost, double weight).
*Fixed*
*Intimidate is listed as having STR as its key attribute rather than CHA. I can understand if you want to house-rule this, but it does rather defeat the purpose of the Intimidating Prowess feat.
*Fixed* It is true that in our campaign we used STR as the intimidation bonus and have intimidating prowess double your STR bonus. Otherwise our gnome sorcerer is scarier than the half-orc barbarian. For this version it's changed back to Charisma for you folks. I knew there was a left-over house rule in there somewhere.
*Weapon Focus doesn't seem to be working properly. It lets me select feats based off it, but none of them (including WF) seem to be applied. Under the WF description it keeps telling me to add a weapon in the Weapon Focus Feat selector, despite the fact that I've already added it there. If I enter weapons in all three of the WF options, it displays N/A in the description above.
For this to work, you actually need to select the weapon first, then select the feat. If you change the weapon, you need to re-select the feat. I made a note on the feat selector to make it clear. Let me know if it's not clear enough.
*It's a little odd that you have to enter all your equipment TWICE. Once in the store, and once in the equipment inventory on the Character Sheet. Is there any reason why it doesn't transfer from one to the other?
I was deliberating whether or not I should link the store to the equipment. My hesitation was that I like to put the gear straight in the character sheet and I only use the store for calculations. If enough people think differently though, or any one makes a strong argument, it is an easy fix and I can add it in the next version.
* There doesn't seem to be a tally of your skill points. I guess the fields turn from yellow to white/gray when you've used all your available points, but it doesn't tell you something is wrong if you add more ranks.
There should be a a little green number at the top left of the skill table next to SKILL POINTS LEFT, it displays how many ranks you have left.. As you put in ranks the number will decrease and disappear when you don't have any points left. SKILL LEFT will then change to SKILLS.
Anyways, I made it clearer now as the Skill bar will turn red if you put too many points in.* Along the lines of this, the ability to enter custom feats (that don't necessarily have constant game-mechanical effects). At the moment the sheet complains pretty loudly if you try to enter a custom feat.
*Fixed* Why didn't I think of that? Added now! In the feat selector, above the feat planner is a table where you can enter custom feats.
*Tweaks to HP calculation. A pretty common method is to give full HP at level 1, and then average or rolled values beyond that. Having that as an option would be really nice.
If you look in the start here tab, you will see a cell named HP calculation. Here you can select one of three methods of HP calculation: Average, Max or Roll. If you select roll, you need to enter hit points per level in each cell. Let me know if you are having trouble with this.
One other thing I noticed is that your grop seems to use 100sp = 1gp and 100cp = 1sp.
While there's nothing wrong with a houserule like that, I wouldn't include it in a sheet for general consumption :)
Standard rules are 100cp=10sp=1gp.
*Fixed*This was actually a mistake, fixed now.
I did not do everything, but I did toy around with it in Open Office. I did not have any issues? What problems came up on your end and what version of open office did you use?
I am not certain which open office I've used, it was a while back. I recall it had problems reading excel's array formulas. If it's working in the current open office that's pretty great. Though I must say that I am surprised.
One thing that seems to be missing is "Perception" under skills - but maybe I'm blind
What Blave said is correct. However, if you would like to add it to the skill list, you can simply click on any of the skills and a drop down menu will appear that will let you change the skill. You can even delete skills that you are not using with the delete key.
Personally, I like the character sheet but I'm not too fond of editing my characters on a PC. Too much hassle printing a new one every time something changes. Any chance you could add a blank version of the character sheet?
Check this out:
Go to Blank Excel Sheet.Go to Blank PDF Sheet (this one is a little chunky).
Edit: Some option to freely chose domains (and favored weapon) for clerics would be nice. Could be useful for clerics without a deity or the servants of minor gods.
I just stumbled over this when I tried to create a cleric of Milani.
*Fixed* You can now do this in the class options tab, under Cleric Options.
On a similar (minor) note, it would also be nice if changing the deity of the character would clear the domain slots.
This if not possible without Macros. For now, you can just select the deity or domain and simply hit delete to clear a slot out manually.
And the dwarven hardy racial trait adds a +2vs poison note to the saves, but notthe +2vs spells and SLA.
*Fixed* I changed it to +2vs all poisons. Since there is simply not enough room for spells and SLA in that little box. It can get very croweded at higher levels.
However, you could be the first to make a "real" progam.
I have recently looked into coding a full blown utility in Unity3d. It shouldn't be to difficult, just time consuming. So if I do start it soon, it will take a while as I do have to work in order to eat as well. Hunting cats was just made illegal in my neighborhood :(.
Google around for Pathfinder-sCoreGen-b54.003 -- most of this work has already been done (feats from the Advanced Players Guide are in v.003).
I think both of these sheets offer different features. One of the big advantages that my sheet provides is that it doesn't require VB or macros to run among other things. I do admire the amount of work that goes into RPG Engine, there is a lot I can learn from it.
It's fun to create something that is entirely your own.
That's right! It really is. Plus it gives me direct control over the features that we need in our game.
Great! Thanks for the update! I'm totally gonne use your sheet for my next character :)
I'll just repost another issue in case you didn't see it the first time.
Something seems to be off with custom items and their special qualities. I made a Mithral Full Plate for my cleric (he has the feat) and for some reason, the -3 armor check penalty is applied to his attack rolls. Doesn't happen with a normal full plate. Just checked Adamantine: Same bug as with mithral, too.
Still happens in v21. I don't get the penalty with a mithral breastplate on a cleric an I don't get it with the mithralfull plate when I switch my class to figher. So I guess the bug comes from the special material in combinatin with the feat.
I'll let you know if I stumble over other bugs. As of now, this is the best charcter generator sheets I've seen so far. And I've seen quite a lot. Again, thanks for sharing :)
Just placing my dot for now. Looks great.
The fixes all seem good :)
A few more bugs:
Knowledge: Nobility is listed as a Ranger class skill.
Perception lists the class bonus even if one does not have ranks in it.
I'll try a few different builds to see what else I can turn up.
Nifty, dot-worthy, thanks!
As someone who is using a mac, I much appreciate an excel utility that does not use VB macros, since they don't work on my machine :)In fact, ONLY people who have paid for Excel can use them. Macro'd books don't work in Open Office/Libre Office either.
I don't see why no one tries to make a real program.
While there are limitations, there is a limitation with everything. I think this is a great utility with a lot of potential to cut down on the tedium that can come with character/game generation. Doesn't hurt that it's free either.
However, you could be the first to make a "real" progam.
I have some GUI and some basic code, mostly to calculate point buy. Really, the program is the easy part. The back-end is the hard part. What's holding me up is the best way to define character lay out using an XML ruleset. My idea was using a XML ruleset makes everything much simpler both in creation, saving, and character sheet generation. If anyone wants to help do that, I'll get right on finishing a character creator. However, it will be limited to Windows (possibly Linux depending on user) at first.
I am running Windows 7 with microsoft office and when I open the links it does not open correctly. How do I fix this in order to procure the great looking sheets?
A few more minor issues:
- Use Magic Device is missing the * for trained only.
- Silver as a weapon material always adds 90 gp to the price. Should be 20 gp for light weapons, 90 for one-handed and 180 for two-handed weapons.
- Ammunition costs are off. Could be a house rule, but they are all way cheaper than they are supposed to be. 20 arrows should be 1 gp, not 5 cp, 10 bolts should be 1 gp instead of 1 sp and so on. Might want to check those again.
- Likewise, the costs for adding special materials to arrows are off, too. 20 Adamantine arrows should cost 1201 gp (1 gp base +60 per missile) instead of 3000, silver arrows would be 3 gp and cold iron 2 gp.
- In the store tab, a few item slots don't add the cost of the item to the row. I checked all and unless I missed some, the issue should affect Equipment 1 and 18 for the character, equipment 8 for the mount and magic item 10.
- Encumberance (either light, medium or heavy) by weigth is determined incorrectly. It only shows medium load once you are above the maximum for medium load. Same goes for heavy load.
I.e. a character with STR 10 should have 0-33 lb light load, 34-66 medium, and 67-100 heavy. Instead, he has light load from 0 to 66, medium from 67 to 100, and heavy above 100.
This bug affects both the store and the equipment section of the character sheet.
I can't wait to try this out once my laptop has internet access again, so I'm dotting for now!
Hi Folks,
Thank you for all the feedback.
Here is the latest version of the sheet:
Go to mikhaels_PFcharacterSheet_v22.xlsx.
Pretty much all of the reported bugs have been fixed.
Something seems to be off with custom items and their special qualities. I made a Mithral Full Plate for my cleric (he has the feat) and for some reason, the -3 armor check penalty is applied to his attack rolls. Doesn't happen with a normal full plate. Just checked Adamantine: Same bug as with mithral, too.
*Fixed* Forgot about that one, thanks.
Knowledge: Nobility is listed as a Ranger class skill.
Perception lists the class bonus even if one does not have ranks in it.
*Fixed*
I am running Windows 7 with microsoft office and when I open the links it does not open correctly. How do I fix this in order to procure the great looking sheets?
Mr. the Rogue, what version of MS Office are you running? Also, are you downloading the files to your hard drive first, or opening them straight through your browser? Let me know how you are opening them and we'll figure it out.
Use Magic Device is missing the * for trained only.
*Fixed*
Silver as a weapon material always adds 90 gp to the price. Should be 20 gp for light weapons, 90 for one-handed and 180 for two-handed weapons.
Likewise, the costs for adding special materials to arrows are off, too. 20 Adamantine arrows should cost 1201 gp (1 gp base +60 per missile) instead of 3000, silver arrows would be 3 gp and cold iron 2 gp.
*Fixed* Along with a few other weapon material calculations that I found.
Likewise, the costs for adding special materials to arrows are off, too. 20 Adamantine arrows should cost 1201 gp (1 gp base +60 per missile) instead of 3000, silver arrows would be 3 gp and cold iron 2 gp.
Encumberance (either light, medium or heavy) by weigth is determined incorrectly. It only shows medium load once you are above the maximum for medium load. Same goes for heavy load.
I.e. a character with STR 10 should have 0-33 lb light load, 34-66 medium, and 67-100 heavy. Instead, he has light load from 0 to 66, medium from 67 to 100, and heavy above 100.
This bug affects both the store and the equipment section of the character sheet.
*Fixed*
I would really love to see examples of characters that you guys make with this sheet if you can post them.
Cheers
Thanks for the many (and fast) fixes!
Checking the encumberance in the new version, I noticed that the speed of my dwarf is reduced when he carries medium or heavy load. The slow and steady racial ability should prevent his speed from ever dropping below 20 ft, regardless of encumerance by weight or armor.
I switched my race to human for testing purpose and noticed that you apply the encumberance penalty to speed from both armor and weight. I.e. a human with medium/heavy armor has his base speed reduced to 20. And if you add heavy load, his speed becomes 15.
However - as far as my rule understanding goes - only the bigger of the two penalties should ever apply. You are either encumberd by weight OR by medium/heavy armor. I'm pretty sure a human shouldn't have less than 20 ft movement speed.
Here's the quote from the PRD:
If your character is wearing armor, use the worse figure (from armor or from load) for each category. Do not stack the penalties.
Oh, and I don't want to put you under any kind of preasure, but you ARE going to add the APG at some point, right? ;)
Trying to build a paladin fighting with weapon and shield (TWF) uncovered more bugs:
- Smite evil says it deals tripple damage (+3/level) against outsider, undead and dragons. This should only be double damage (+2/level).
- The Shield focus feat adds +2 points of armor to the shield. Should only be +1.
- Custom shields don't show up as weapon choices on the first page of the character sheet. Makes using them offensively impossible.
- Likewise, I couldn't find an option to have magic shield spikes affect my shield. This might be hard to fix because you need to distinguish between the actual armor enhancement bonus and the enhancement bonus of the spikes.
- The Shield Master feat is all wrong. It adds the total AC of the shield (base AC, enhancement bonus and even the bonus from shield focus) to attack and damage of both shield and main hand weapon. It should only add the magic enhancement bonus of the sheild and only to the shield's attack and damage.
- Special magic abilities on weapons, armor and shields (like flaming, bashing, fortification and so on) add a flat bonus to the cost of custom magic equipment. Instead, they should add a cost based on the total enhancement the item has.
A +1 flaming longsword should cost 8315. 15 for the sword, 300 for masterwork and 8000 for the total enhancement bonus of +2 (+1 normal enhancement, +1 for flaming).
However, right now it costs only 4315, 15 for the sword, 300 for masterwork, and 2*2000 for the enchantments.
The second weapon entry on the character sheet has 20 entered in the ammunition box in the second half of the box. It's not calculating this value from anywhere, so I'm assuming it's safe to just delete it, but I thought I'd mention it anyway.
One idea I had for the store vs equipment idea would be to maybe have a checkbox you can select on either the character sheet or store sheet which would let you synchronize the two, so to speak. That way you could choose whether you wanted them to be the same or not.
I am runnung the newest version of Windows 7 and Microsoft Office. When I save link to my hard drive it looks like this when I open it. Please help!
<?xml version="1.0" encoding="UTF-8" standalone="yes" ?>
- <worksheet xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main" xmlns:r="http://schemas.openxmlformats.org/officeDocument/2006/relationship s">
- <sheetPr codeName="Sheet18">
<tabColor theme="0" />
</sheetPr>
<dimension ref="A1:CHN136" />
- <sheetViews>
- <sheetView view="pageBreakPreview" zoomScale="60" zoomScaleNormal="200" zoomScalePageLayoutView="80" workbookViewId="0">
<selection activeCell="BP170" sqref="BP170" />
</sheetView>
</sheetViews>
<sheetFormatPr defaultColWidth="1" defaultRowHeight="5.25" customHeight="1" />
- <cols>
<col min="8" max="8" width="1" customWidth="1" />
<col min="92" max="92" width="1" customWidth="1" />
</cols>
- <sheetData>
- <row r="1" spans="1:2250" ht="5.25" customHeight="1">
- <c r="A1" s="3061" t="s">
<v>7147</v>
</c>
<c r="B1" s="3062" />
<c r="C1" s="3062" />
<c r="D1" s="3062" />
<c r="E1" s="3062" />
<c r="F1" s="3062" />
<c r="G1" s="3062" />
That's odd. Try downloading it again, and then open it from within Excel. That's the best I can offer, probably.
That's the XML (Office 2007 files are XML based), make sure you are opening it with Excel.
Hm, this makes me think. Made I should use the rules people are defining for these sheets to help me define the ruleset for my XML backing data..
That's the XML (Office 2007 files are XML based), make sure you are opening it with Excel.
Hm, this makes me think. Made I should use the rules people are defining for these sheets to help me define the ruleset for my XML backing data..
I am runnung Office 2010 and it helped to open those files after I opened excel. There are so many files to open! Which one is for the character sheet?
Latest version of the sheet can be downloaded here.
Checking the encumberance in the new version, I noticed that the speed of my dwarf is reduced when he carries medium or heavy load. The slow and steady racial ability should prevent his speed from ever dropping below 20 ft, regardless of encumerance by weight or armor.
I switched my race to human for testing purpose and noticed that you apply the encumberance penalty to speed from both armor and weight. I.e. a human with medium/heavy armor has his base speed reduced to 20. And if you add heavy load, his speed becomes 15.
However - as far as my rule understanding goes - only the bigger of the two penalties should ever apply. You are either encumberd by weight OR by medium/heavy armor. I'm pretty sure a human shouldn't have less than 20 ft movement speed.
*Fixed*
- Smite evil says it deals tripple damage (+3/level) against outsider, undead and dragons. This should only be double damage (+2/level).
- The Shield focus feat adds +2 points of armor to the shield. Should only be +1.
- Custom shields don't show up as weapon choices on the first page of the character sheet. Makes using them offensively impossible.
*Fixed*
Likewise, I couldn't find an option to have magic shield spikes affect my shield. This might be hard to fix because you need to distinguish between the actual armor enhancement bonus and the enhancement bonus of the spikes.
Try creating two separate shields, one in the custom shield and one as a custom weapon. You can select Light Shield, Light Spiked Shield, Heavy Shield and Heavy Spiked Shield as weapon/custom weapon. Let me know if this solves your problem.
- The Shield Master feat is all wrong. It adds the total AC of the shield (base AC, enhancement bonus and even the bonus from shield focus) to attack and damage of both shield and main hand weapon. It should only add the magic enhancement bonus of the sheild and only to the shield's attack and damage.
- Special magic abilities on weapons, armor and shields (like flaming, bashing, fortification and so on) add a flat bonus to the cost of custom magic equipment. Instead, they should add a cost based on the total enhancement the item has.
A +1 flaming longsword should cost 8315. 15 for the sword, 300 for masterwork and 8000 for the total enhancement bonus of +2 (+1 normal enhancement, +1 for flaming).
However, right now it costs only 4315, 15 for the sword, 300 for masterwork, and 2*2000 for the enchantments.
*Fixed* You were right, in fact, the prices of all the custom gear was way off. Fixed now.
The second weapon entry on the character sheet has 20 entered in the ammunition box in the second half of the box. It's not calculating this value from anywhere, so I'm assuming it's safe to just delete it, but I thought I'd mention it anyway.
*Fixed* Yeah, I forgot to delete that thanks.
One idea I had for the store vs equipment idea would be to maybe have a checkbox you can select on either the character sheet or store sheet which would let you synchronize the two, so to speak. That way you could choose whether you wanted them to be the same or not.
*Fixed* That would actually require a macro to do. But here is what I did: I programmed it so that when you buy any equipment in the store (except for weapons and armor), it would now appear on the character sheet, just like you asked. Alternatively, You can also choose the items straight from the character sheet, or go ahead and change them at a later time. However, once you change and item in the character sheet, you will break the connection from the store. So if you want to keep the connection, always change it at the store.
I think it works quite nicely without resorting to macros, but please let me know what you think of this solution.
Hm, this makes me think. Made I should use the rules people are defining for these sheets to help me define the ruleset for my XML backing data..
In the monster tab there is a big data table where you can enter the monster information. Usually I just copy the monster data from the bestiary and change it to my liking. Once you have monsters in the data table, you can bring them up in the GM screen by clicking on the header of the stat block. Let me know if you are having any more problems and I’ll try to help.
So maybe I'm having a doofus moment, but where do the "Monsters" come from under the "Encounter Structure"?
Cartigan, let me know if you need any help with your XML program, I might be able to contribute.
I am runnung Office 2010 and it helped to open those files after I opened excel. There are so many files to open! Which one is for the character sheet?
Glad you can open them now. You only need one or two files, depending on what you are interested in. You want the file at the top of this post, that one is the character sheet.
If you are interested in the GM Tools, check my first post for the link.I love this spreadsheet, thanks alot for the work!
Any chance of a section for custom spells? In our campaign, we're using Rite Publishing's 101 Spells, and would like to be able to enter in those spell names.
I'm _not_ asking you to add those spells to the lists (though if you want to, that would be great!), but, like for the custom magic items, etc., a spot for custom spell names.
thanks.
*Fixed* Thanks :)! You should now be able to type your own spells in the spell slots. No spell cards will be created at this time, but I will add that feature later.
Are skills entered directly on the sheet or is there a tab for that?
Skills are entered directly in the sheet.
~~~
As for all the APG requests, it will be a while before I get to them, as I develop this sheet on my off-time after work. Most of the stuff should be pretty easy to add. The Archetypes and Base Classes will probably come last as they will be the most time consuming.
Content from other books after the APG… let’s get the APG done first; it’s a feat within itself!
for anyone that's still having trouble opening the sheet/tools, take the .zip file and open it directly with excel, don't unzip it first.
for anyone that's still having trouble opening the sheet/tools, take the .zip file and open it directly with excel, don't unzip it first.
Zip file? I'm uploading them as .xlsx files. Are you guys seeing them as zip files?