Excel Combat Tracker and Encounter Builder

[xarimus]

Hi all,

I went looking for an excel based combat tracker a while back and couldn't find one that did everything I would like so I made one! Hoping to get some feedback and critique (suggestions) from some other DMs. Also if anyone who is VBA savvy could take a look at the code, this is my first vba project so I'm sure it's a little sloppy.

Some instructions:
Mostly pretty straightforward, the only area that can be prone to errors (that I'm aware of) is when importing an encounter to the tracker. If there is not a picture on the encounter sheet that has the same name for each unique name in the C column (monsters only) then it will error out.

Other than that, when adding status effects you can put anything in the S column and it will prompt you to save at the end of the turn. If the effect lasts until the start/end of a turn then you can put the respective numbers at the top in the R and T columns to have the effect automatically drop off at the appropriate time. It will automatically attempt to add the dying status to any player that drops to 0 or lower and increment the number in the S column if they fail to save.

It's got a sample encounter already loaded about halfway through round 5.

Edit: apparently I can not post links because I am new, if someone wants to take a look at it please PM me for the link.

 

[Jan van Leyden]

If you're not too close friends with Excel you might want to have a look at D&D 4e Combat Manager. It's after all these years still my favourite tool for the task.

I'd want to have a look at your code, but have to admit that I couldn't really start before August...

 

[xarimus]

Thanks, I will check that out. I was a little hesitant to try anything I needed to install (I want to be able to tinker with encounters at work and I like to tinker with the code if I want something to work differently). However the ability to import directly from .monster and character builder files sounds awesome.