log in or register to remove this ad

 

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

skullking

First Post
Healing Surge value. This should be 7 not 6 for clerics on the excel (DATA) sheet, all the other values are correct.

Keep up the good work :)
 

log in or register to remove this ad

beej

First Post
Kralin Thornberry said:
Since my excel-fu is puny and minor (or some would say non-existant), how do I access the hidden data sheets?

I'm seconding this query. Excel-fu is not a trained skill. :/
 

Halivar

First Post
Ah! I don't know how to do it in Excel (because I don't have Excel). In Oo_Org, you look in the menu under Format | Sheets | Show. You get a list of sheets to unhide.
 


tristan_tewksbury

First Post
Add my kudos to the list!

I really love the sheet, but have a bit of feedback.

Someone already caught the surge error for Clerics, but the weapons table is a bit odd.

Throwing Hammer appears first on line 74, showing as a :ranged: weapon but combined with all the :melee: weapons. It then appears again on line 94, among the :ranged: weapons. The version on 74 has no range value, while the version on 94 has a range value. Unfortunately, when entering a weapon via a drop-down, the Range formula under the weapon listing uses the first "Throwing Hammer" it finds, which is the one with no range value. As a result the range is 0. Is the version on line 74 supposed to be removed, or should it just have the 5/10 added to the range field?

Also, why are there blank lines separating the ranged from melee weapons? They are not two different tables, but by having so many blank lines I stopped looking for weapons when I encountered blank lines in the drop-down.

I understand your view on Feats as a general rule, but it would be nice if Jack of All Trades were incorporated into the skills table such that if the skill was not trained, you got the +2. But then I am lazy ;)
 

the_redbeard

Explorer
Dig the sheet!

What I like best about it is that it _doesn't_ have much space for powers. I intend to use power cards for the details.

What I'm looking for on the front of a sheet is stuff I need to mark and conditional modifiers.

What is missing from this one:
Ways to indicate which items I've used, and if I've used my Daily magic item power, and if I've gotten a milestone to use another Daily magic item power.

Thanks!
 

Hawke

First Post
Any suggestions about how to modify this to allow for more power autocalculation? After playing a few sessions, I'd really love to. Even if I had to unhide the data sheet (in excel, right click a tab and do unhide, btw) and add more lines for specific powers manually.

I'm okay with excel usually, but I'm unfamiliar with how to add those drop-downs in Excel 2007 and how best to setup a searchable index... if it comes down to it, I might try my hand at my own sheet
 

Brain

First Post
After trying every 4e sheet that I could find, I prefer your Open Office version. Nicely done. I did modify it a bit to allow space for power descriptions.

Thanks for the sheet!
 

Wonka

First Post
Love the sheet, its fantastic! Got a few (minor) suggestions. I was rolling up a minotaur fighter and noticed no large weapons, easy enough to add in on the data sheet though I figure, so I just added Maul (Large) :D Same kind of deal for a rogue using a shuriken, rogues throw them as 1d6, not 1d4. Again, just added Shuriken(Rogue). However I realize I have no idea how to edit the formulas, as Im an excel/OO calc extreme novice, and im sure Im not the only one! So it might be worth adding a Size toggle? Again, just a very minor nitpick, its easy enough to fix by manully overriding the damage die. Also, have you considered distributing the file as a template? (.ots file) This way people wont accidentally save over the base file when making characters, I know ive done it more than once :D Only other thing I can think of is a power workspace for frequently used powers (at-wills mostly) with lables like the weapons have so you can load them in the basic attacks area. Ok thats al I have right now, i just wante to say thanks again to everyone involved, this is esaily my fave sheet now! More comments possibly when I have gotten the correct ammount of sleep!
 

Bagpuss

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

Surge Value should look for "Dragonborn" in the race field and add the Con Modifier. Something like....

Code:
=ROUNDDOWN(B52/4,0)+IF(B12="Dragonborn",R33,0)

Of course that relies on them getting the Race field spelt correctly.

Couldn't Race be added as a drop down box like Class?
 

Brain

First Post
Surge Value should look for "Dragonborn" in the race field and add the Con Modifier. Something like....

Code:
=ROUNDDOWN(B52/4,0)+IF(B12="Dragonborn",R33,0)

Of course that relies on them getting the Race field spelt correctly.

Couldn't Race be added as a drop down box like Class?

That code didnt work for me. This works, though:

Code:
=IF(B12="Dragonborn";INT(R33+(B52/4));INT(B52/4))

I used the INT function rather than rounddown because we're only interested in integer values.
 

Arbanax

First Post
HI All

love using the sheet, just a couple of questions, firs to all can we get a low ink formatted version, black out boxes being put in clear solid line boxes for those of us who are feeling the credit crunch ;).

Second I noticed that when i was typing in some states the basic attack added in weapon prof and preferred weapon bonus to damage as well as attack. As far as I can determine damage on a basic attack should only be the Dex or Str Mod if applicable.

Just on format, there is less space for at will than Encounter and daily can this be changed some characters have more at will and trying to type on the different powers in such a small space is not easy.

Great work, oh someone mentioned optimizing the sheet for letter, when i go to print that is how it is, but I think they were saying it was already optimized for A4 any chance us Europhiles can have it in A4 as it is there is a lot stuff on here and anything that can be printed up is a great thing.

Otherwise the best sheet I have seen (and I've been through pretty much them all) hands down so far, thanks a lot/

Ab
 

Hawke

First Post
If you update this sheet anytime in the future, I'd love an update that had both front & back in a single tab so I can double sided print it with a quick click. Thanks so much for the hard work... really enjoying the sheet.
 

jlac

First Post
Great character sheet...thanks for the hard work! I created a Dragonborn Fighter with an 18 Strength, and I equipped him with a Battleaxe and Dagger (not Thrown Dagger). On page one under Basic Attacks, the Battleaxe is showing 1d10+4 damage and the Dagger is showing 1d4+2 damage. Shouldn't it show 1d4+4 damage (Using my Strength bonus of +4)? Thanks!
 

thsmalley

First Post
Max HP value?

First I would like to say thank you for putting this all together, I can tell a lot of time and effort when in to this and it is really appreciated!! However, I do have a question about the Max HP field. By default, the Char sheet is fo a 1st level Cleric with all 10s for abilities, according to the sheet this would give that character a max HP of 22. That doesn't seem right to me, if I read the PHB a Cleric would have 12 + Con mod at 1st, or 12 HP with a Con of 10. Am I missing something (entirely possible!), forgive me if this has already been discussed, I started reading all of the threads but then gave up. :erm:

The formula for the field is "=DATA!B34+C33+(AH9-1)*DATA!C34+U55". The Con field is a merge of C33 and C34 (along with D, E and F), I am not an Excel wizard, but it seems to be pulling info from the same field twice...? As I say, I could be mising something really simple, if so please enlighten me.

Thanks!!
 

thsmalley

First Post
I'm seconding this query. Excel-fu is not a trained skill. :/

To Unhide tabs in Excel, right click on one of the current Tabs. This will bring up a pop up menu, one of the choices will be to Unhide items and you can choose the sheets you want to show.
 

Brain

First Post
if I read the PHB a Cleric would have 12 + Con mod at 1st, or 12 HP with a Con of 10. Am I missing something (entirely possible!), forgive me if this has already been discussed, I started reading all of the threads but then gave up. :erm:

All characters get their con score, not mod to hp at first level. re-check your phb
 


To Unhide tabs in Excel, right click on one of the current Tabs. This will bring up a pop up menu, one of the choices will be to Unhide items and you can choose the sheets you want to show.

This instruction above doesn't work on my version. (97)

however, the same thing can be achieved with format/sheet/unhide.

==============================================

There is some excel-ent work here. Many thanks for all the hard work.

Having a drop down list for races*, and an auto-fill for racial abilites would be good....as would a picksheet for class powers.

Having the power discriptions isn't as important to me though, I'll be using cards.

(edit: * Realised that this wasn't done because the Stat line would need to be self-editting. To get around this try adding another tab "Pick sheet" before the actual sheet to allow for inital choices (Race, level, Class., Feats, Powers etc. This will allow for an easy stat adjustment on the main sheet without ruining the basic format). You would then only edit the stats from the "Pick Sheet".)
 
Last edited:

I've made some of the adjustments I suggested above...

A "pick sheet" now allows the auto-inclusion of racial stat modifiers, (picking) of level stat increases, and tier stat increases.

Also a formula to calculate "points buy".

Currently, doing the same sort of thing to create drop down lists for selecting skills, feats (dependant upon on class/qualifying stats) and powers.

Not sure if Halivar's was working on this type of modification...but I'm quite lazy and like not having to refer to books when I'm pregenerating bunches of characters quickly.
 
Last edited:

Advertisement2

Advertisement4

Top