Version 0.3
This is the third version of the Dungeons & Dragons 4th Edition Numbers Character spreadsheet.
More automation based on race has been added to make it easier to create a character.
It allows you to use Numbers as a character sheet to manage your DnD4e characters, from creation to combat.
Version 0.3 Updates:
- Created CONDITIONS table to make it easy to reference conditions (based on www.dragonavenue.com cards)
- Added vlookup to populate the CONDITIONS details
- Created CLASS dropdown
- Added vlookup to automatically populate the DEFENCES race row based on CLASS
- Moved LEVELS table to the REFERENCE SHEET
- Moved EXPERIENCE TRACKER table to the NOTES SHEET
- Moved LOAD VALUES table to the REFERENCE SHEET
- Added CLASS HEALTH TABLE
- Added vlookup & formula to automatically populate the HEALTH BOX based on CLASS and LEVEL
- Added vlookup automatically populate the HEALING SURGES PER DAY based on CLASS
To Do:
- Add in basic melee and ranged attacks
- Add in level one encounter powers for classes
- Make encounter powers easier to generate
Chris says...
August 9th, 2010
1:59 am
It looks like a great set up. The only things I see that are missing are some of the classes i.e. Avengers, Bards, Invokers, Shamans, Barbarian, Sorcerer, Warden and Druid from PHB2 and their Heroic, Epic, and Paragon features etc. etc.. When I loaded it up there were a lot of errors.
a.bird says...
August 9th, 2010
11:27 am
Do you know if this will work with Numbers for the iPad?
stewartcurry says...
August 9th, 2010
12:32 pm
@a.bird – Not in its current state – Numbers for iPad strips out sliders, tickboxes and lots of other things this is built around. An iPad version would need to be a lot simpler and require manual updating – more like a pen and paper character sheet.
stewartcurry says...
August 9th, 2010
12:38 pm
@Chris – Thanks for that – I’m adding missing classes and classes from the PHB3 as well. This is very much a way to teach myself a bit about DnD and Numbers, so apologies for all the mistakes – if you could tell me any massive blunders then please do! I would like to add more to it but it does get very complicated – Numbers doesn’t seem to have any if/else functionality which would make life easier for me.
Dorus says...
August 27th, 2010
2:05 am
I have a problem with some ability modifiers, which also influences the skills table: in case of an ability score of 9, the spreadsheet autocalculates a modifier of 0 instead of -1 (zee PHB). the same goes for an ability score of 7 (modifier: -1 instead of -2).
stewartcurry says...
August 27th, 2010
12:35 pm
Oh dear, that’s no good! I’m adding the PHB3 characters to an update, I will check my maths on the ability scores while I am at it