rrwoods
2015-09-21, 11:10 PM
Excel 2013 -- http://userpages.umbc.edu/~woorich1/Alth%20Shrenan%20character%20sheet%20(level%203).x lsx
Last things first: This is made for Excel 2013 (2010 may work but I haven't tried it). No, this won't port to Google Drive. Heavy use of array formulas that isn't going anywhere anytime soon, and Google's array formula representation is completely unlike Excel's. Sorry. LibreOffice 5 appears to handle this sheet just fine!
With that out of the way...
Blue is for you (to type into), white is for me (to display to you) (but I haven't locked edits on any of it).
This is my character sheet for D&D 3.5. It is currently filled out with a level 3 swordsage's stats, as that is the character I'm currently playing. (Comments on the character are welcome too :-P) It occurred to me recently that I might share this sheet, as I haven't really seen anything like it anywhere else. (EDIT: I have seen something like it, actually, as I was very recently reminded, and I was quite impressed by it. That one has class data and such baked in, which is just something I'd rather not have, especially since it keeps me from sharing it here.)
I've tried to insert comments where possible to make it easier to use, but I know my way around it pretty well, so it's very likely some of it won't be clear. The "Spells" tab in particular prooooobably sucks pretty hard, because I massively prefer printed spell cards to keep track of my spells, but there's still some nifty stuff happening there.
There are a few things I Just Don't Like about it, from a programmer's perspective... but not many. I don't like that the sheet just reads the effects table for effects turned on that are named Two-Weapon Fighting, Improved Two-Weapon Fighting, Greater Two-Weapon Fighting, and Far Shot, for example. But I don't see a way around it really. Also I don't make near enough use of named ranges, because I didn't know they existed until embarrassingly recently.
Things this sheet does well:
Numerical effects and the stacking rules. I believe this implements the stacking rules 100% correctly, including for conditional saves (like saves vs fear, etc). This is the primary reason this sheet even exists in the first place; I got tired of buffstacks resulting in me needing to refigure my attack bonus every round, and oh, how does that speed increase affect my jump checks again? What's that, my being encumbered affects max dex to AC (which came about because of that strength damage I took)? All handled no sweat. With no macros.
Multiple forms. Say it with me: Wild Shape. This is the second reason this sheet even exists in the first place. I was playing a Hengeyokai character, and the number of things you need to "just remember" that change (or make little scribbles all over a physical sheet) is enormous. It should be pretty easy to add many, many forms to your character and have everything propagate correctly when you select the new form from the "Current form" dropdown on the Summary sheet.
This does support skill groups, in the style where putting a rank in a group gets you ranks in all the skills in it, but the skill checks are still keyed off different abilities and can be affected separately. In fact, the character filled out here exemplifies that: Hide and Move Silently are grouped, but there is a racial effect on Hide and a circumstance bonus to Move Silently.
Let you edit the stupid thing. On the only other sheet I've used (and paid for!), I was sorely missing the fact that I couldn't dig into the nitty gritty and just change stuff. Houserules happen, and needing to write effects for houserules is not something I'm a huge fan of. If you need to, on my sheet, you can crack open the hidden columns/rows and just change what you want. Further, if you need (for example) more weapon slots than I've given you, you can insert some rows on the Weapons sheet, insert some cells on the Summary sheet, autofill the relevant values and be good to go. (*coughsixisnotenoughweaponslotscough*) Or, if you don't like the way some stuff is laid out, just move it around! I'm not locking you into anything here.
Oh yeah, it's pretty good at being free, too.
Things this sheet does not do:
There is (deliberately) NO data specific to any given class, item, race, spell, etc. I don't want the bloat of storing all that stuff. What there is (or should be anyway!), however, is a solid framework in which you can type that stuff in for whatever classes/items/race/spells your character needs.
This sheet doesn't keep track of maneuvers. I really really really prefer physical maneuver cards, especially given that you refresh them between encounters. This character's maneuvers known are in a separate document (namely, the one that has the maneuver cards I print up to play it). You could easily just add a sheet for your maneuvers known if you wanted to, or type them in the Summary sheet.
This is NOT laid out like a WotC character sheet, at all. Conceivably you could change that, if you wanted, but I was much more focused on organizing the data to be easy to use on a computer than on familiarity with the physical sheets.
Things I still want to do soon:
* Allow effects that add damage dice (probably easy).
* Create weapon groups so that I don't need to do that horrid thing where I specify every Shadow Hand weapon individually (twice) (ugh this is hard).
* Somehow make only one effects input sheet without creating any circular references (pretty sure this is impossible).
I'll update this post as I receive suggestions or think of things I forgot.
Updates 2015/09/22
Most recent fixes:
Some stray text eliminated
Nuked some undefined references in effects in (size, speed, abl.) sheet
Extra attack effects weren't working
Most recent features:
Can say e.g. [entangles] for damage die and it won't render the damage bonus/type/crits/etc
Size category input has a dropdown (thanks Giles!)
Other dropdowns added on Class data sheet
Last things first: This is made for Excel 2013 (2010 may work but I haven't tried it). No, this won't port to Google Drive. Heavy use of array formulas that isn't going anywhere anytime soon, and Google's array formula representation is completely unlike Excel's. Sorry. LibreOffice 5 appears to handle this sheet just fine!
With that out of the way...
Blue is for you (to type into), white is for me (to display to you) (but I haven't locked edits on any of it).
This is my character sheet for D&D 3.5. It is currently filled out with a level 3 swordsage's stats, as that is the character I'm currently playing. (Comments on the character are welcome too :-P) It occurred to me recently that I might share this sheet, as I haven't really seen anything like it anywhere else. (EDIT: I have seen something like it, actually, as I was very recently reminded, and I was quite impressed by it. That one has class data and such baked in, which is just something I'd rather not have, especially since it keeps me from sharing it here.)
I've tried to insert comments where possible to make it easier to use, but I know my way around it pretty well, so it's very likely some of it won't be clear. The "Spells" tab in particular prooooobably sucks pretty hard, because I massively prefer printed spell cards to keep track of my spells, but there's still some nifty stuff happening there.
There are a few things I Just Don't Like about it, from a programmer's perspective... but not many. I don't like that the sheet just reads the effects table for effects turned on that are named Two-Weapon Fighting, Improved Two-Weapon Fighting, Greater Two-Weapon Fighting, and Far Shot, for example. But I don't see a way around it really. Also I don't make near enough use of named ranges, because I didn't know they existed until embarrassingly recently.
Things this sheet does well:
Numerical effects and the stacking rules. I believe this implements the stacking rules 100% correctly, including for conditional saves (like saves vs fear, etc). This is the primary reason this sheet even exists in the first place; I got tired of buffstacks resulting in me needing to refigure my attack bonus every round, and oh, how does that speed increase affect my jump checks again? What's that, my being encumbered affects max dex to AC (which came about because of that strength damage I took)? All handled no sweat. With no macros.
Multiple forms. Say it with me: Wild Shape. This is the second reason this sheet even exists in the first place. I was playing a Hengeyokai character, and the number of things you need to "just remember" that change (or make little scribbles all over a physical sheet) is enormous. It should be pretty easy to add many, many forms to your character and have everything propagate correctly when you select the new form from the "Current form" dropdown on the Summary sheet.
This does support skill groups, in the style where putting a rank in a group gets you ranks in all the skills in it, but the skill checks are still keyed off different abilities and can be affected separately. In fact, the character filled out here exemplifies that: Hide and Move Silently are grouped, but there is a racial effect on Hide and a circumstance bonus to Move Silently.
Let you edit the stupid thing. On the only other sheet I've used (and paid for!), I was sorely missing the fact that I couldn't dig into the nitty gritty and just change stuff. Houserules happen, and needing to write effects for houserules is not something I'm a huge fan of. If you need to, on my sheet, you can crack open the hidden columns/rows and just change what you want. Further, if you need (for example) more weapon slots than I've given you, you can insert some rows on the Weapons sheet, insert some cells on the Summary sheet, autofill the relevant values and be good to go. (*coughsixisnotenoughweaponslotscough*) Or, if you don't like the way some stuff is laid out, just move it around! I'm not locking you into anything here.
Oh yeah, it's pretty good at being free, too.
Things this sheet does not do:
There is (deliberately) NO data specific to any given class, item, race, spell, etc. I don't want the bloat of storing all that stuff. What there is (or should be anyway!), however, is a solid framework in which you can type that stuff in for whatever classes/items/race/spells your character needs.
This sheet doesn't keep track of maneuvers. I really really really prefer physical maneuver cards, especially given that you refresh them between encounters. This character's maneuvers known are in a separate document (namely, the one that has the maneuver cards I print up to play it). You could easily just add a sheet for your maneuvers known if you wanted to, or type them in the Summary sheet.
This is NOT laid out like a WotC character sheet, at all. Conceivably you could change that, if you wanted, but I was much more focused on organizing the data to be easy to use on a computer than on familiarity with the physical sheets.
Things I still want to do soon:
* Allow effects that add damage dice (probably easy).
* Create weapon groups so that I don't need to do that horrid thing where I specify every Shadow Hand weapon individually (twice) (ugh this is hard).
* Somehow make only one effects input sheet without creating any circular references (pretty sure this is impossible).
I'll update this post as I receive suggestions or think of things I forgot.
Updates 2015/09/22
Most recent fixes:
Some stray text eliminated
Nuked some undefined references in effects in (size, speed, abl.) sheet
Extra attack effects weren't working
Most recent features:
Can say e.g. [entangles] for damage die and it won't render the damage bonus/type/crits/etc
Size category input has a dropdown (thanks Giles!)
Other dropdowns added on Class data sheet