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




What's on your mind?

+ Log in or register to post
Page 1 of 9 123456789 LastLast
Results 1 to 15 of 135
  1. #1
    Registered User
    Enchanter (Lvl 12)

    Halivar's Avatar

    Join Date
    Dec 2002
    Location
    Augusta, GA
    Posts
    2,619
    Blog Entries
    1

    Ignore Halivar
    My communities:

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

    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 by Halivar; Saturday, 14th June, 2008 at 01:36 PM.

    My D&D Class:
    Lawful Good Human Paladin

    My Robin Law's Game Style:
    100% Method Actor, 100% Storyteller, 83% Butt-Kicker, 75% Specialist, 75% Power Gamer, 67% Tactician, 0% Casual Gamer

    Look what I made!
    OSRIC Henchmen Generator

    PBP Characters

    Darvus Andar, paladin (Living PF) - Currently in Return to Boar's Ridge


 

  • #2
    Writing TimeWatch!
    The Grand Druid (Lvl 20)

    Piratecat's Avatar

    Join Date
    Jan 2002
    Location
    Boston, MA
    Posts
    26,809

    Ignore Piratecat
    My communities:

    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.
    - Piratecat, EN World Admin. Now writing TimeWatch, an investigative time travel game.

  • #3
    Registered User
    Enchanter (Lvl 12)

    Halivar's Avatar

    Join Date
    Dec 2002
    Location
    Augusta, GA
    Posts
    2,619
    Blog Entries
    1

    Ignore Halivar
    My communities:

    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 by Halivar; Friday, 23rd May, 2008 at 05:39 AM.

    My D&D Class:
    Lawful Good Human Paladin

    My Robin Law's Game Style:
    100% Method Actor, 100% Storyteller, 83% Butt-Kicker, 75% Specialist, 75% Power Gamer, 67% Tactician, 0% Casual Gamer

    Look what I made!
    OSRIC Henchmen Generator

    PBP Characters

    Darvus Andar, paladin (Living PF) - Currently in Return to Boar's Ridge


  • #4
    Registered User
    Enchanter (Lvl 12)

    Halivar's Avatar

    Join Date
    Dec 2002
    Location
    Augusta, GA
    Posts
    2,619
    Blog Entries
    1

    Ignore Halivar
    My communities:

    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.

    My D&D Class:
    Lawful Good Human Paladin

    My Robin Law's Game Style:
    100% Method Actor, 100% Storyteller, 83% Butt-Kicker, 75% Specialist, 75% Power Gamer, 67% Tactician, 0% Casual Gamer

    Look what I made!
    OSRIC Henchmen Generator

    PBP Characters

    Darvus Andar, paladin (Living PF) - Currently in Return to Boar's Ridge


  • #5
    THIS SHEET IS AWESOME will you have my babies?

  • #6
    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.

  • #7
    Registered User
    Enchanter (Lvl 12)

    Halivar's Avatar

    Join Date
    Dec 2002
    Location
    Augusta, GA
    Posts
    2,619
    Blog Entries
    1

    Ignore Halivar
    My communities:

    Thanks, ZetaStriker! I've uploaded v. 1.3 to fix this.

    My D&D Class:
    Lawful Good Human Paladin

    My Robin Law's Game Style:
    100% Method Actor, 100% Storyteller, 83% Butt-Kicker, 75% Specialist, 75% Power Gamer, 67% Tactician, 0% Casual Gamer

    Look what I made!
    OSRIC Henchmen Generator

    PBP Characters

    Darvus Andar, paladin (Living PF) - Currently in Return to Boar's Ridge


  • #8
    Registered User
    Acolyte (Lvl 2)

    Belorin's Avatar

    Join Date
    Jun 2005
    Location
    the Gray Vale
    Posts
    429

    Ignore Belorin
    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
    Originally Posted by WotC_RichBaker
    In related news, I'm afraid I'm going to have to confiscate your 3.5 rulebooks, and force you to convert to the new edition. Where do you live?

  • #9
    Registered User
    Enchanter (Lvl 12)

    Halivar's Avatar

    Join Date
    Dec 2002
    Location
    Augusta, GA
    Posts
    2,619
    Blog Entries
    1

    Ignore Halivar
    My communities:

    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.

    My D&D Class:
    Lawful Good Human Paladin

    My Robin Law's Game Style:
    100% Method Actor, 100% Storyteller, 83% Butt-Kicker, 75% Specialist, 75% Power Gamer, 67% Tactician, 0% Casual Gamer

    Look what I made!
    OSRIC Henchmen Generator

    PBP Characters

    Darvus Andar, paladin (Living PF) - Currently in Return to Boar's Ridge


  • #10
    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!

  • #11
    Registered User
    Acolyte (Lvl 2)

    Belorin's Avatar

    Join Date
    Jun 2005
    Location
    the Gray Vale
    Posts
    429

    Ignore Belorin
    Quote Originally Posted by Halivar
    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
    Originally Posted by WotC_RichBaker
    In related news, I'm afraid I'm going to have to confiscate your 3.5 rulebooks, and force you to convert to the new edition. Where do you live?

  • #12
    1.4 is working much better, but I don't see anywhere for equipment and whatnot.

  • #13
    Great, great job, Halivar!

    And it helps people understand the mechanic 'hands on'

  • #14
    Registered User
    Enchanter (Lvl 12)

    Halivar's Avatar

    Join Date
    Dec 2002
    Location
    Augusta, GA
    Posts
    2,619
    Blog Entries
    1

    Ignore Halivar
    My communities:

    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.

    My D&D Class:
    Lawful Good Human Paladin

    My Robin Law's Game Style:
    100% Method Actor, 100% Storyteller, 83% Butt-Kicker, 75% Specialist, 75% Power Gamer, 67% Tactician, 0% Casual Gamer

    Look what I made!
    OSRIC Henchmen Generator

    PBP Characters

    Darvus Andar, paladin (Living PF) - Currently in Return to Boar's Ridge


  • #15
    Registered User
    Novice (Lvl 1)



    Join Date
    Mar 2008
    Location
    Armpit of Texas
    Posts
    6

    Ignore WalnutNinja

    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?
    Disclaimer: The opinions, statements, or nonsensical blabber stated above do not necessarily represent the views or thoughts of the poster. I have a brain/finger barrier disorder.

  • + Log in or register to post
    Page 1 of 9 123456789 LastLast

    Similar Threads

    1. Anyone know of a non-calculating excel/openoffice character sheet?
      By grickherder in forum House Rules, Homebrews, & Conversion Library
      Replies: 0
      Last Post: Saturday, 21st February, 2009, 09:34 PM
    2. Character Sheet - condensed, reorganized, editable, auto-calculating (PDF)
      By Fungah in forum House Rules, Homebrews, & Conversion Library
      Replies: 15
      Last Post: Saturday, 21st June, 2008, 09:57 PM
    3. D&D 3.5 Self-Calculating Character Sheet (Excel 2000)
      By RiTz21 in forum House Rules, Homebrews, & Conversion Library
      Replies: 29
      Last Post: Friday, 6th August, 2004, 05:09 AM
    4. D20M Auto-Calculating Character Sheet
      By Danzilla in forum House Rules, Homebrews, & Conversion Library
      Replies: 10
      Last Post: Saturday, 25th January, 2003, 07:08 PM
    5. D20M Auto Calculating Character Sheet
      By Danzilla in forum House Rules, Homebrews, & Conversion Library
      Replies: 10
      Last Post: Sunday, 15th December, 2002, 08:04 PM

    Posting Permissions

    • You may not post new threads
    • You may not post replies
    • You may not post attachments
    • You may not edit your posts
    •