Reply to thread

Message

<blockquote data-quote="Traveon Wyvernspur" data-source="post: 4419572" data-attributes="member: 73201">Here's my second version of a DM combat log, initiative tracker, and character tracker. This is my attempt in an Excel spreadsheet to keep everything organized in combat. You will notice on the sheet that there are 4 tabs at the bottom. <ul>
<li data-xf-list-type="ul">The first tab is for auto-filling a ton of stats from all the monsters/creatures in the 4e monster manual. This does so by using a drop-down box in the creature name sections and auto-fills the stats from there.</li>
<li data-xf-list-type="ul">The second tab has the same drop-down, but doesn't fill out the stats, this is in case you want to create your own NPC &quot;bosses&quot;, monsters, or whatever.</li>
<li data-xf-list-type="ul">The third tab is an encounter/experience tracker. This will auto-fill the experience and level according to your encounters as you add them in.</li>
<li data-xf-list-type="ul">The fourth tab is the Monster Table, with almost everything from the monster manual as far as stats go.</li>
</ul>It's still a work in progress as I keep thinking of new things to add to it, and I've been working on getting the information into the huge monster table for two weeks now, and just finished today. Other things that this spreadsheet does:<ul>
<li data-xf-list-type="ul">Drop downs for Effects.</li>
<li data-xf-list-type="ul">Drop downs for Initiative.</li>
<li data-xf-list-type="ul">Drop downs for Rounds.</li>
<li data-xf-list-type="ul">Drop downs on the second tab for &quot;size&quot; of creatures.</li>
</ul>I'd like any constructive comments that come to mind, or any way that I might improve it. I've used formulas, but no macros (haven't really worked with them much yet). I've got it attached here in a zip file that has both versions of Excel 2007 and the previous for those who can't see the 2007 stuff. Enjoy!&nbsp;-Trav&nbsp;&nbsp;EDIT: Took off the 2.0 version and replaced with version 2.1 below.</blockquote>

[QUOTE="Traveon Wyvernspur, post: 4419572, member: 73201"] Here's my second version of a DM combat log, initiative tracker, and character tracker. This is my attempt in an Excel spreadsheet to keep everything organized in combat. You will notice on the sheet that there are 4 tabs at the bottom. [LIST] [*]The first tab is for auto-filling a ton of stats from all the monsters/creatures in the 4e monster manual. This does so by using a drop-down box in the creature name sections and auto-fills the stats from there. [*]The second tab has the same drop-down, but doesn't fill out the stats, this is in case you want to create your own NPC "bosses", monsters, or whatever. [*]The third tab is an encounter/experience tracker. This will auto-fill the experience and level according to your encounters as you add them in. [*]The fourth tab is the Monster Table, with almost everything from the monster manual as far as stats go. [/LIST]It's still a work in progress as I keep thinking of new things to add to it, and I've been working on getting the information into the huge monster table for two weeks now, and just finished today. Other things that this spreadsheet does: [LIST] [*]Drop downs for Effects. [*]Drop downs for Initiative. [*]Drop downs for Rounds. [*]Drop downs on the second tab for "size" of creatures. [/LIST]I'd like any constructive comments that come to mind, or any way that I might improve it. I've used formulas, but no macros (haven't really worked with them much yet). I've got it attached here in a zip file that has both versions of Excel 2007 and the previous for those who can't see the 2007 stuff. Enjoy! -Trav EDIT: Took off the 2.0 version and replaced with version 2.1 below. [/QUOTE]

Verification