D&D 4E Halivar's 4E auto-calculating character sheet v.2.03 (OpenOffice, Excel & blank PDF)

[Halivar]

This means that half the level is double counted.

I don't think that's the case. In all the other places on the official char sheet where they add the ability modifier to half the character level, the label is "mod + 1/2 lvl" or "abil mod + 1/2 lvl". I think it's just using the base dex mod, here, and adding the 1/2 level explicitly. The effect is the same. Your cumulative initiative bonus is your Dex mod plus half your level.

 

[Saben]

I think you misunderstand, Halivar. You are right that your cumulative initiative should be your dex mod plus half your level. But you are adding cell P20 (which is the ability mod+1/2 level from cell Z36- should be R36) to cell S20 (half level).

You end up adding ability mod+ half level+ half level if you trace it back. Change cell P20 to =R36 instead of =Z36 and it's right.

 

[Halivar]

DOH! Please accept my apologies, skulking, I completely misunderstood you. I'll get this fixed and uploaded after work.

 

[Rafe]

Thanks for all your work, Halivar!

However, in the Excel sheet, I'm getting -5 all over the place. In skills, mostly (in the Bonus and 1/2 level mod columns).


...... hmmm... I just clicked on a few of those fields, and now those -5s are gone. Anyone else seeing this? Is this a normal function if a sheet is not completely filled in? (If so, sorry for bringing it up!)

 

[Halivar]

All your skills will be -5 until you fill in your character level and ability scores. If your character level and ability scores are all zero, -5 is the result (ability score modifiers are calculated as in 3.5E: [ability-10]/2).

 

[Rafe]

That explains it. Perfect, thanks! It's great that you made it for both Excel and OpenOffice.

 

[Halivar]

2.0 changes are going to be HUGE. I've finally gotten the hang of drop-downs and indexed tables, so classes and armor are going to be drop-downs. That means defenses and HP are going to be calculated based on what you put for your armor+shields and class, respectively. The goal is to handle as much calculation for the player as possible. There may be some changes to the front sheet as I work on weapons, so that basic attacks are more readily available.

Also, I'm going to be including instructions on adding new classes to the table, so you can add homebrew classes and WotC classes from supplements.

 

[npiccini]

Halivar,

great work! Im not a skilled EXCEL user so this provides me with a huge time saver. I always felt that an interactive spreadsheet was a huge missing component from the earlier versions of the game. I wonder though, is DDi going to be doing all this work for you? Certainly this is still useful until WoC produces such an engine, but it isn't clear to me anywhere in the press about DDi whether or not they are producing an interactive character sheet beyond the character imager revealed in the previews

 

[Halivar]

I wonder though, is DDi going to be doing all this work for you?

I imagine it will. My experience is that I prefer not using web-apps when local apps are available; this is especially true when I have my laptop at a game without wi-fi. Also, I usually need a lot of per-character customization that is incredibly difficult on a character generator (like PCGen).

Also, I don't plan on getting a DDI subscription.

 

[Colawley]

Personally I think this sheet is great for how much information there is to put it together at this time. I would recommend maybe added some formulas to calculate HP, Healing Surges, and Bloodied.

You could setup a drop-down list for Class and then use the following formulas:

Max HP:

=SUM(IF(AO9="Cleric",IF(AH9>1,C33+12+((AH9-1)*5),C33+12),0),IF(AO9="Fighter",IF(AH9>1,C33+15+((AH9-1)*6),C33+15),0),IF(AO9="Paladin",IF(AH9>1,C33+15+((AH9-1)*6),C33+15),0),IF(AO9="Ranger",IF(AH9>1,C33+12+((AH9-1)*5),C33+12),0),IF(AO9="Rogue",IF(AH9>1,C33+12+((AH9-1)*5),C33+12),0),IF(AO9="Warlock",IF(AH9>1,C33+12+((AH9-1)*5),C33+12),0),IF(AO9="Warlord",IF(AH9>1,C33+12+((AH9-1)*5),C33+12),0),IF(AO9="Wizard",IF(AH9>1,C33+10+((AH9-1)*4),C33+10),0))

Bloodied:

=ROUNDDOWN(B52/2,0)

Surge Value:

=ROUNDDOWN(B52/4,0)

Surges/Day:

=SUM(IF(AO9="Cleric",7+R33,0),IF(AO9="Fighter",9+R33,0),IF(AO9="Paladin",10+R33,0),IF(AO9="Ranger",6+R33,0),IF(AO9="Rogue",6+R33,0),IF(AO9="Warlock",6+R33,0),IF(AO9="Warlord",7+R33,0),IF(AO9="Wizard",6+R33,0))

I was able to set this up in Excel in about 45 minutes of playing around. It takes the value of the Class box and uses it to fill in the amounts. It also uses the value of the level field to add HP each level you gain.

I will continue to play around with it to find what else can be automated.