• NOW LIVE! Into the Woods--new character species, eerie monsters, and haunting villains to populate the woodlands of your D&D games.

Excel Gamesheet

NoviceGM

First Post
I made a pretty handy Excel sheet that can do quite a lot. It can track up to 12 PCs(or NPCs) and 36 enemies. It calculates HP in battle, initiatives, and loads creatures from either the SRD or a custom database. It does status effects, weather effects, weights, monies, and much more. It took me a better part of a year to make it! I want to share it, but I don't know how to post it for other people. It is 14.4 Mb unzipped.

I was hoping somebody could give it a look over for me, and help me get it available. I might be good at excel, but I suck at the internet.

Thanks!
(P.S. This is my first post so I apologize if I didnt post correctly)
 

log in or register to remove this ad


I used Save File

I hope this works!

Keep in mind it is still a little rough on a few of the edges, and I may have weird notes to myself in the calculating areas. Generally the left side of each sheet is where you'll be hanging out, unless you like to fiddle with settings. Good luck and I hope I get some responses for improvements! Let me know what you guys think.
{new link below}


its towards the bottom.

(I forgot to clear out the PCs in the sheet so it comes with 12 PCS, you'll have to delete them to get started. I might have missed a few other things... I was rather high all day ;) )
 
Last edited:

I fixed the to hit,(it was busted at 1st level).
Included an exerience calc(using the math from the DMG).
and will have the magic item gen on by sunday night. I'll update it then. More advice is welcome: Makoseraph at yahoo (dot) com , I'll try to add something if you want.
 
Last edited:

I have updated and smoothed out everything, I have a little left to do but only minor things...
Since last update I have included:

PC sheet clear macro
Exp gen & tracker
Beyond first level gen (equipment gen in progress)
Complete set of time tracking tools
Sunrise/ sunset & lunar trackers
"Add roll" and "Subtract roll" macro buttons for +/- dice rolls on the battle sheet
Customizable dice roller
Treasure gen
Encounter gen based on party level with overrides and room to add new creatures to the gen
Turn undead calc
Fixed all known errors, and fixed limitations on inputs that end in error
Urban encounter gen
track, wall, and door calculator for DCs
Movement Calculators and Weather visibility

In progress/To do
District gen for city gen
Wilderness encounter gen
NPC gen (will be general, probably a by level stat block database with race mods)
Light effects
Flight calc

Let me know if anything else is needed

http://www.savefile.com/files/314427
 

Into the Woods

Remove ads

Top