log in or register to remove this ad

 

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

Halivar

First Post
skullking said:
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.
 

log in or register to remove this ad

Saben

First Post
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

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

Rafe

First Post
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

First Post
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).
 


Halivar

First Post
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

First Post
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

First Post
npiccini said:
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

First Post
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:
Code:
=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:
Code:
=ROUNDDOWN(B52/2,0)

Surge Value:
Code:
=ROUNDDOWN(B52/4,0)

Surges/Day:
Code:
=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.
 

Halivar

First Post
Thanks Colawley. Your formulas looks just like the ones in my development version, except for the class formulas: I used a range lookup, so you can actually add new classes to the data table on separate "Data" sheet, and it will get added to the drop-down automatically (along with the appropriate values being shoved into the calculations for other fields).

What's the hold up with 2.0? Well, I am waiting to get my copy of the PHB to get the appropriate values for weapons + armor for drop-downs. I am not going to reference the PDF's for this task (as I am not downloading it), so 2.0 is going to have to wait for at least another week until my Amazon pre-order shows up.
 




I was going to try and teach myself how to do all of this in excel, but I'll just wait for yours, as it's much better than what I could do.

Question though, are you going to make race, class, etc. drop down boxes?
 


Darkthorne

First Post
Stat mod error

Halivar,you want to change the formula in cell R30 to "=rounddown((c30/2),0)-5" A 9 in a stat should be -1 mod. Also for the armor I would do a hidden sheet so when the armor is chosen it (cell) populates either light or heavy, name the range (for this example "armortypechosen") so the formula would read =if(armortypechosen="Light",Max(DexMod,IntMod),0). As you can see I'm BIG into named ranges. The other reason for this (pardon me if you already know) if you decide to alter later less chance of you screwing up a formula and having to research the spreadsheet over. BTW Looks very nice!
 

Darkthorne

First Post
One more ting!

If you created a seperate sheet for powers, you could use conditional formatting to color code each power as their proper color type
 

Halivar

First Post
Thanks for the stat formula help, Darkthorne. As for the range lookups, you're clairevoyant because that's how I have them implemented in v.2.0, mostly for the ease of updating.
 

Darkthorne

First Post
Your Welcome. I figured going with "light","Heavy" bit may help if a modifier does not always work with the greater than aspect. Also are you aware you can create a "named" value for a formula? If not I can explain how to do so.
 

Advertisement2

Advertisement4

Top