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
The character sheet I always use for 3.5E is an Excel spreadsheet I downloaded and heavily modified to suit my liking. Since there isn't one for 4E, I decided to write one up because I am soon to have need of it. It is based as closely as possible to the official 4E character sheet.

I don't use Microsoft Office, so I wrote it in OpenOffice.org Calc and exported it to Office XP. I can only guarantee that both versions work in Oo_O. Download it, give it a test-drive, and tell me why you wouldn't want to touch it so I can fix it . ;)

EDIT 2.0: Wow. It's now fully-functional for what I want. I owe a LOT of people for this. If you see bugs, please report them! Thanks.
EDIT 2.01: Forgot some stupid bugs; belorin pointed them out a week ago, and my friend Owen just reminded me. Stupid mistake!
EDIT 2.02: Fixed armor and shields. Info was based on pre-release info and had to update as per PHB. Also added masterwork armors.
EDIT 2.03: Fixed some formatting stuff and a bug related to weapons with parenthesis in Oo_Org.

Halivar's 4th Ed. Character Sheet 2.03 (Excel)
Halivar's 4th Ed. Character Sheet 2.03 (OpenOffice.org Calc)
Halivar's 4th Ed. Character Sheet 2.0 (blank PDF)
 
Last edited:

log in or register to remove this ad

Piratecat

Writing Fantasy Gumshoe!
Thanks for posting this. Odd, the top bit is coming through as solid black. Is it for you?

I've got a nifty one as well, similar to yours in some places, but there's some stuff I auto-filled in that's covered by a NDA. I'll post it as soon as I can.
 

Halivar

First Post
You know, it may be that Excel doesn't do the auto-contrast thing I got on mine (must be Oo_O). I'll try explicitly setting all the letters on black to white.

EDIT: It may also be the font: Georgia. It's supposed to be standard on Windows, but I may have been wrong. Is there a graphic I can use (legally) instead?

EDIT: Got a version 1.1 that I think fixes your problem PC. Just a simple image I did up in GIMP.
 
Last edited:

Halivar

First Post
Added a 1.2 revision to get rid of blue backgrounds on input fields; now I protect the whole sheet except for input fields. I think it looks better this way.

I've also verified that the Excel version works... you know... in Excel. :cool:
 


ZetaStriker

First Post
One problem: the defenses are calculated wrong. It takes the best of Str or Con for Fort, Int or Dex for Ref, and Wis or Cha for Will. It forces just Con, Dex and Wis into those spots.
 


Belorin

Explorer
I'm getting hashmarks (####) in any skill that has n/a in the ACP column, is this something I can fix? I tried changing it, but it says it's protected. Also the Race Features section header has black font color on a black background. Great sheet otherwise!

Bel
 

Halivar

First Post
Hey Belorin, sorry about that. Oo_Org doesn't try to add text in math formulas, which I copy n' pasted. I cut out the "n/a" column from the formula to fix it, and changed the "Race Features" title to show up.

I've uploaded 1.4. Thanks!

EDIT: I also took off document protection because I think that's going to be more of a pain that is worth it.
 

ZetaStriker

First Post
Nice, Halivar, I'm glad to see this coming along. Hopefully it's about final now, but it's already looking to be a top notch tool. Thanks for making and uploading it for us! :D
 

Belorin

Explorer
Halivar said:
Hey Belorin, sorry about that. Oo_Org doesn't try to add text in math formulas, which I copy n' pasted. I cut out the "n/a" column from the formula to fix it, and changed the "Race Features" title to show up.

I've uploaded 1.4. Thanks!

EDIT: I also took off document protection because I think that's going to be more of a pain that is worth it.
Thanks very much!
Works excellent now.

Bel
 



Halivar

First Post
Vikingking, I want to add extra pages for inventory and powers. I wanted to wait until I got some game time under my belt so I can better gage how that information is best presented. When I get these sheets ready, I'll be bumping the version number to 2.0.
 

WalnutNinja

First Post
Blank

Halivar, this sheet is exactly what I've been looking for since I bought KotS. Is there any way to print blank sheets? Or could you perhaps provide a blank copy for those of us who like to pencil stuff in?
 

Vikingkingq

First Post
Halivar said:
Vikingking, I want to add extra pages for inventory and powers. I wanted to wait until I got some game time under my belt so I can better gage how that information is best presented. When I get these sheets ready, I'll be bumping the version number to 2.0.

Rock on. I'll be waiting.
 

Halivar

First Post
WalnutNinja, I've uploaded a blank PDF for printing and filling in. I will be keeping this document concurrent with the Excel and ODF versions.

BTW, guys, how do those lines print out? I've got a color laser printer that has no problems with those 1-pixel boxes, but I'm afraid they may be too thin for inkjet printers (which most people use these days). What do they look like for you?
 
Last edited:

Saben

First Post
Halivar, from my understanding a better formula for cell AS21 would be:
=IF(BE21>3,0,IF(R36>R39,R36,R39))

You get int or dex added to your AC (whichever is higher) but only if you are wearing hide armour (+3 AC) or less.

Also currently if someone takes a -1 speed penalty from wearing scale this penalty also is being applied to ACP even though -2 should be applied (-4 for plate).

Personally I added a new formula in CG20 =IF(BE21>3,-1,0)

Then in the ACP cells I added the formula:
=IF($BE$21=8,-4,IF($BE$21=7,-2,IF($BE$21=6,-1,0)))

Of course it may be easier to add a drop down for armour later then automatically fill in all the armour related cells. For now it works purely off the armour value given in BE21.

(reference: http://www.dnd4.com/phb#20 under armor; or the PrRC)
 

Halivar

First Post
Saben, where did the info on that website come from? I'm prepared to make all the changes described, but one thing that has me vexed is adding the shield AC bonus to the Reflex defense. The official 4th character sheet has no shield field under Reflex AC.

PS: Yeah, I definitely want to put in a drop-down of some kind. That will be in the 2.0 version with the equipment on the second sheet.

EDIT: Saben, you're spot on. I also found that WotC was using the second "MISC" field for shields. I added a "shield" category for both AC and Reflex, and implemented all the formula suggestions you made in 1.5 (which is up).

Thanks!
 
Last edited:

skullking

First Post
On he Excel sheet (I have not looked at the others) the Initiative not only adds ½ the character level but also the ability modifer that also includes half of the character level (ref cell Z36). This means that half the level is double counted. Cell R36 should be referenced instead.

Cheers.
 

Advertisement2

Advertisement4

Top