Results 1 to 3 of 3
  1. - Top - End - #1
    Bugbear in the Playground
     
    molten_dragon's Avatar

    Join Date
    Apr 2010
    Location
    The State of Denial
    Gender
    Male

    Default Auto-Updating combat stats sheet

    This project was inspired partly by this thread. When I read it, I got to thinking. I'm currently playing a gish, and it's a real pain to be constantly recalculating my stats as I have different buffs on me at various times. So something like what Vrigar is working on would be really helpful.

    However, I'm not very patient, and I need something like that now, so I decided to throw something together in excel. It took me about 3 hours last night, and it's still pretty rough, but it works pretty well. I thought others might be interested in using it, so I thought I'd post it here. You can download it here if you're interested in checking it out.

    The sheet can auto-calculate your ability scores, armor class(es), saves, attack bonus with various weapons, and skill bonuses. This all happens on the sheet named "Sheet". Cells highlighted in green are ones where you need to enter a value. Cells highlighted in grey are ones that you shouldn't put anything in, because that thing doesn't apply to whatever calculation is happening (Armor check penalty to most skills for example).

    You would enter any buffs you have on the sheet called "buffs". It won't actually apply the buff until you tell it the buff is active by picking yes from the little drop down menu. It works best if you enter your magic items and class features as "buffs" as well, since for buffs that overlap but don't stack, it is able to pick only the largest to be active.

    The sheet labeled "code" just has the choices for the various drop-down menus that the sheet uses, so you should probably leave that alone.

    As I mentioned, I put this together pretty fast, so it's not the greatest thing in the world yet, but I wanted something that I could use for our session tonight. If you have improvement suggestions, or questions on how it works, feel free to ask and I'll try to answer them/implement them. I want to try to get an Open Office version working soon too, and if I do I'll post that as well. If you like it, please feel free to download it and change it/share it as much as you want.
    Last edited by molten_dragon; 2012-08-12 at 06:38 AM.
    If build a man a fire, he'll be warm for a day.

    If you set a man on fire, he'll be warm for the rest of his life.

    My Homebrew

  2. - Top - End - #2
    Ogre in the Playground
     
    danzibr's Avatar

    Join Date
    Mar 2010
    Location
    CoMo
    Gender
    Male

    Default Re: Auto-Updating combat stats sheet

    At a glance, this looks... really awesome. I'll totally use this in a campaign I'm in where buffs are constantly flying around (I'm a buffer Bard, another player is a buffer Favored Soul).

    Thanks!
    My one and only handbook: My Totemist Handbook
    My one and only homebrew: Book of Flux
    Spoiler
    Show
    A comment on tiers, by Prime32
    Quote Originally Posted by KillianHawkeye View Post
    As a DM, I deal with character death by cheering and giving a fist pump, or maybe a V-for-victory sign. I would also pat myself on the back, but I can't really reach around like that.
      /l、
    ゙(゚、 。 7
     l、゙ ~ヽ
     じしf_, )ノ

  3. - Top - End - #3
    Bugbear in the Playground
     
    molten_dragon's Avatar

    Join Date
    Apr 2010
    Location
    The State of Denial
    Gender
    Male

    Default Re: Auto-Updating combat stats sheet

    I loaded the excel sheet into open office, and checked it over, and it looks like everything transferred just fine. As far as I can tell nothing broke, so tentatively, I'm just going to leave the excel version up, and if you have open office instead, you should just be able to use it as is. If anyone notices otherwise, please let me know.
    If build a man a fire, he'll be warm for a day.

    If you set a man on fire, he'll be warm for the rest of his life.

    My Homebrew

Posting Permissions

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