Close
Close
Advanced Search

Dungeon Master Excel Toolkit

Dungeon Master Excel Toolkit

ADD TO WISHLIST >
ZIP File
$
Suggested Price $3.75

Over 2 years of development, 6300+ downloads, and 30+ ratings with an average rating of 4.8 stars!!!

"Everything I needed was right there, and I didn't have to do math on the fly, just record what was happening and it all worked like magic." ~ Jennifer L.

"This tool alone has single-handedly given me the ability to create intresting encounters for entire dungeon runs in a fraction of my average time" ~  Trym S.

"This tool is a DM's best friend! It has never been easier to capture ciritcal player stats, set up a sequence of encounters, balance them for your party, track initiative and HP, assign experience points, and so much more." ~Austin T.

"First off, I want to say that this is AMAZING. I essentially work in Excel full-time for my job and this spreadsheet is a work of art." ~Baelin D.

Thanks to everyone who has taken time to provide feedback in the discussion area of this title, and taken time to leave your kind words in the review section. Working on this project has been awesome, and I don't plan on stopping development anytime soon!


Encounter Builder 2.11 - Updated 05/15/2020

  • Simplified UI
    • Plain grey color scheme allows the color to really pop and grab your attention for quick browsing of information
  • Character Management
    • Handles up to 10 players
    • Automatic calculations of carrying capacity and push/drag/lift limits, as well as other commonly used information, are present for easy PC management.
  • Loot Tables
    • Adventurers carry misc. adventuring goods, why wouldn't their enemies?
    • Populate loot tables with lists of items that can be randomly pulled from to give looting enemies more depth and utility than just "you get 50 gp from the corpses"
    • Several pre-built loot tables are included by default.
  • Powerful encounter manager
    • Automates creature health randomization according to MM health rolling rules
    • Pages for encounter building using the rules from the DMG and XGE
  • Initiative Tracker
    • Automatically sorting initiative order tracker
    • Automatically roll creature initiatives with a button push
    • Detects creature health and factors that when rolling initiatives
  • Includes basic monster information for all WoTC monsters
    • If you find a monster I missed or misnamed, or an error please let me know!
    • You are able to add homebrew monsters to the monster library using the built in form
    • Includes basic reference information for all WotC creatures, and creatures from Matt Colville's Strongholds & Followers 5e supplement. There is not enough information to fully run an encounter, so the source books are still necessary for attacks and movement.
  • Quick Reference search windows
    • Using Excel's Userform interface allows for easy search
      • Status Effects
      • Magic Items
      • Mundane Items
      • Chance Encounters
        • Many encounters courtesy of Ivan Cannon
      • Spell Lookup
      • Light, Weather, and hazardous terrain look up
    • Allows for random choices of all items, and chance encounters
    • Hotkey Enabled
      • Ctrl + l to open window
NPC Generator 3.2 - Currently working on a version 4.0, stay tuned...
  • Random
    • Name generator using XGE and other sources
    • Race randomization based on demographic percentages
    • Gender
    • Weighted Occupation
    • Appearance generator using a custom algorithm
      • Supports all races with unique descriptions
    • Talents
    • Mannerisms
    • Interactions with others
    • Ideal
    • Flaws or Secrets
  • Location storage
  • Can save NPCs for future reference
  • The descriptions are generated ready to read to players and only has the information that you need!
  • Everything is customizable if you dive into the data sheets, or you can use as it is!
  • In version 3.0 I finally gave the generator the attention it needed.
Inn and Tavern Generator 1.2 - Currently working on a version 2.0, stay tuned...
  • Procedurally generated inns and taverns are now at your fingertips
  • this generator creates detailed exteriors, interiors, and basic atmosphere for your most frequented establishments.
  • Editable name gnerator is also included
  • Best when paired with the NPC generator to create patrons, bartenders, and waitstaff.
Character Builder 2.4 - Updated 05/15/2020
  • Includes basic race and class info
  • Gives race and class matchups based on modifiers
  • I use this when i'm trying to get ideas together for a new character, it's also helpful for new players to see it listed out like this!

Excel 2010 or greater required for full functionality with limited support available going back to excel 2007. Mac users may experience bugs, but I think i've ironed out the kinks for y'all.

 
 More from this Title's Contributors
 
 Customers Who Bought this Title also Purchased
Reviews (10)
Discussions (31)
Customer avatar
Ryan A August 06, 2020 3:51 pm UTC
PURCHASER
Hi there!

Im trying to find something that includes the class "The Lingering Soul" We would like to be able to use deceased characters in our campaign and this seems like a really cool and fun option. I haven't been able to find any character builders out there that include it. SO far this is the BEST excel sheet I have been able to find for detail and reliability. Is there a way I can edit this to include The Lingering Soul class? I'm not an excel wizard so I might need some help. Thanks!!
Customer avatar
Ryan A August 06, 2020 4:04 pm UTC
PURCHASER
Forgot to mention above, Is there a Character sheet builder that comes with this as well?
Customer avatar
Lincoln S August 19, 2020 8:54 pm UTC
CREATOR
Which sheets are you looking to add it to? If you just want to add it to the encounter builder you can just enter whatever you want in the race and class sections as long as you're on the newest version!
Customer avatar
daniel F July 19, 2020 9:48 am UTC
PURCHASER
Hey there, have a quick question. Is there a way to build an encounter and load that into the Readied encounter, as to be able to build encounters ahead of time and load them right into the initiative tracker? Amazing amazing work truly, once I get the hang of this, I will absolutely purchase. It is astonishing the amount of effort you have put into this.
Customer avatar
Karla A July 19, 2020 2:56 pm UTC
PURCHASER
Daniel, on the right side of the Encounter Builder tab (below the image and to the right of the encounter Total field) there are 4 buttons/cells. You can Save an encounter that you've created here, which will add it to the Saved Encounters tab. You can also click Ready to move the information to the Readied Encounter tab.

The View/Load will allow you to access previously saved encounters on the Builder tab where you can make updates.

All of this lets you build them ahead of time and update as needed!
Customer avatar
daniel F July 19, 2020 11:34 pm UTC
PURCHASER
Ahhhh! This is very exciting and works so seamlessly, clicking ready brings those into the initiative tracker. This is such a great tool!
Customer avatar
Lincoln S July 22, 2020 4:58 pm UTC
CREATOR
Daniel,

Glad to hear you got it worked out! Thanks for the kind words. Feel free to reach out if you have any more questions!

Karla,

Thanks for helping Daniel out! You got to his question before i even saw it!
Customer avatar
Karla A July 17, 2020 7:49 pm UTC
PURCHASER
Hello! Thank you for making this, it's made my life as a new DM significantly easier! I also have a question about using it. Is there a way to generate magical loot? I see the ability to add my own loot lists, but there's also a magical items library and I'm curious about linking them together. For example, my players are going to a mafia wedding where a lot of mafia members are pretty skilled with magic. I'd love to have random things that they could pickpocket or find - is there a way to generate this?
Customer avatar
Lincoln S July 22, 2020 4:56 pm UTC
CREATOR
Hey Karla!

I'm glad to hear that you like the tool, and i love hearing that you're using the new loot table feature! Even though the magic items don't show up in the dropdown when configuring your loot table you can manually enter the magic items. Unfortunately their properties won't show up in the loot table generator, but they will roll just like any other item. Adding full magic item integration is on my list of planned improvements, but i have had very little time to work on this project recently.

Technically you can add any value you want to the loot tables, including random key mashing. Though, If it's not a mundane item it won't populate the value and properties automatically.

Thanks for reaching out!
Customer avatar
ignace V May 26, 2020 9:58 pm UTC
PURCHASER
Great DM tool! I purchased it today and while happily exploring the features I stumbled on a minor bug in the Character Builder 2.4. When awarding the EXP to the active players on the Readied Encounter sheet and you’re using Excel with a “,” (comma) as a decimal separator (Europe, I know :-) ), you will get a “subscript out of range” in the RoundRight module as you hardcoded the Split function with a “.” (dot). Easily fixed if you change it to “Application.DecimalSeparator” Keep up the good work!!!
Customer avatar
Lincoln S May 27, 2020 3:10 pm UTC
CREATOR
Oh hey! Good note, I never would've thought of that! I will fix that in the next revision.

Thanks for giving me a heads up! I'm glad that you are otherwise enjoying the tool.
Customer avatar
Donny R May 25, 2020 10:25 am UTC
PURCHASER
Is there a walkthrough/ manual available ?
Customer avatar
Lincoln S May 25, 2020 9:58 pm UTC
CREATOR
Not yet! I've been meaning to get around to it for awhile, but there's only so much time in the day. Are you wondering about anything in specific?

Thanks for reaching out!
Customer avatar
Donny R May 30, 2020 6:56 am UTC
PURCHASER
Hi Lincoln,
I've been trying to ready encounters but I get an error message Error -2147352571 (80020005) during execution.
Cannot set the property Collumnwidths , type does not match.
Created encounters are being saved but I cannot view or load them.
So if you could walk me through the process of saving/ editing that would be great!
Customer avatar
Lincoln S June 02, 2020 2:16 pm UTC
CREATOR
Hey Donny! I have a few basic troubleshooting questions that i need to ask quick.

-Are you on Mac or Windows?
-What version of the encounter manager are you using?
-Have you tried re-downloading the sheet fresh? Does the problem persist?
-Does this only happen when you try to view and ready saved encounters, or does it happen with manually populated encounters as well?
-What are you doing right before the error shows up? What button do you click, what sheet are you on?
Customer avatar
Donny R June 13, 2020 11:41 am UTC
PURCHASER
I am on windows and am using version 2.11 (downloaded it again, but the problem persists)
It happens when i'm trying to view or load encounters. Readying encounters is no problem, but I have to manually iinput the monsters before I can generate a new encounter (e.g. I cannot load pre created encounters from the Saved encounters list).
It happens when I'm on the Encounter Builder and Xanathars encounter builder tabs. No buttons pushed in advance
Customer avatar
Donny R June 18, 2020 12:54 pm UTC
PURCHASER
Problem solved.
Column width values in the form 'EncounterBrowser' are seperated by a coma.
For some reason, european notation uses semi colons instead of coma's.
So replaced the seperators and the form worked!

Customer avatar
Lincoln S July 08, 2020 2:52 pm UTC
CREATOR
Oh good to hear you got it working! Another user had a similar issue so it will be fixed in the next revision! Thanks for following up and letting me know. Enjoy!
Customer avatar
derek R May 20, 2020 1:47 am UTC
PURCHASER
Great job on this. It really is nice. Is there any way to add a custom Class to the class list?
Customer avatar
Lincoln S May 21, 2020 2:07 pm UTC
CREATOR
Yep! On v2.11 If you go to the player manager and scroll to the bottom left of the data there is a button that says "Modify dropdown Lists." if you click that it'll take you to the sheet where all of the stuff from the player sheet pulls from. Just find the class list and add a new value!

I'm glad you're enjoying the tool! Thanks!
Customer avatar
Marc M May 07, 2020 6:16 am UTC
PURCHASER
Great piece of work, gives a DM a better insight in mechanics of D&D.
Saw typo: Character builder 2.3.1 / classes/ armour proficiencies … change Sheilds to Shields.
Customer avatar
Lincoln S May 10, 2020 5:35 am UTC
CREATOR
Great catch, thanks for passing it along!
Customer avatar
Scott S April 18, 2020 6:46 pm UTC
PURCHASER
Blech. Same - opened on Mac, immediately crashed.
Customer avatar
Lincoln S April 21, 2020 7:11 pm UTC
CREATOR
Hey Scott,

I'd really like to help out here. I don't own a mac so i have to rely on y'all to tell me what's not working. I have a few troubleshooting questions that could really help me get this working for you.

What, if any, error message did the computer give you?
What version of excel are you on?
Which sheet crashed on you?
Which version of the sheet were you trying to open?
Have you tried re downloading the sheet?

Let me know what you find and we can get you squared away!
Customer avatar
Giuseppe C March 15, 2020 11:14 am UTC
PURCHASER
hey the product looks great, but i keep getting automation error when opening on my mac. any ideas?
Customer avatar
Lincoln S March 16, 2020 9:20 pm UTC
CREATOR
Hey Guiseppe,

Let's see if we can't crack this. There's some questions that i ask everyone that's having some trouble to start with so let's get that out of the way.

What version of excel are you on?
Which spreadsheet are you opening?
What is the version number on that sheet?
Have you tried re downloading the sheet and starting clean?
What is the specific error that you are getting?

If you can tell me all that we will be off to a good start.

Thanks for reaching out!
Customer avatar
Jennifer L February 25, 2020 5:00 pm UTC
PURCHASER
Hey! I am trying to use the NPC generator on a Mac (MacOS 10.15.3, excel version 16.34), and I am getting the message "runtime error 6: Overflow" for every option (No/Cancel/Yes) after it displays the result from "Generate NPC". Any chance you would help me debug this? I'd like to use your tool, particularly because we have all custom races so the online NPC generators are useless for me, but I've never used visual basic.
Customer avatar
Lincoln S March 05, 2020 3:20 pm UTC
CREATOR
Hey Jennifer!

Yeah, hopefully we can get to the bottom of this. Have you changed anything on the sheet, or does this happen on first open? Have you tried redownloading it and starting fresh?
Customer avatar
Joe T June 02, 2020 5:35 pm UTC
PURCHASER
Hi both, I'm experiencing the exact same issue on MacOS with the NPC Generator and the Tavern Generator. In answer to your question, this is happening before editing anything on the file. I've tried downloading and starting fresh and the issue persists.
Customer avatar
Lincoln S June 02, 2020 6:57 pm UTC
CREATOR
Hmmmmmmmm....... So i will dig into this a bit to see if i can find out what the issue is, but i'm actually working on a combined version of both files coded completely from scratch so once that releases you'll have to let me know if you still experience the same issue.

I'll keep you posted!
Customer avatar
Joe T June 02, 2020 8:27 pm UTC
PURCHASER
Thank you!
Customer avatar
Lincoln S June 08, 2020 8:39 pm UTC
CREATOR
No problem. Sorry i don't have a clean bugfix for you yet!
Customer avatar
Jennifer L February 17, 2020 9:41 pm UTC
PURCHASER
Wow. This is amazing. Thank you so much. I downloaded it to check it out yesterday, and I'm back to buy you an expensive coffee or a cheap beer. :-)

One question- is there a way to auto-populate the "readied encounter" tab with monsters from a saved encounter, or do I have to type them in? (MacOS 10.15.3, excel 16.34) Thanks!!!
Customer avatar
Jennifer L February 19, 2020 5:10 am UTC
PURCHASER
I went back to look today and found the "Ready" button on the "Encounter Builder" tab. "Clear" and "Ready" buttons on the "Readied Encounter" tab would be awesome!
Customer avatar
Lincoln S February 24, 2020 4:43 pm UTC
CREATOR
I'm glad you were able to find it! And I certainly appreciate that you came back to purchase!

I will look into that for future revisions, thank you for the feedback!
Customer avatar
jamie B February 08, 2020 6:32 pm UTC
PURCHASER
I keep getting a run error 1004?

Great resource though, love it
Customer avatar
Lincoln S February 17, 2020 2:47 pm UTC
CREATOR
Thanks, glad you like it! Let's see if we can't get that fixed.

Which sheet are you getting that on?
Which version of the sheet are you using?
What do you do right before the error comes up?
What version of Excel are you using?
Have you tried re-downloading the sheet and starting fresh?
Customer avatar
Kevin W January 14, 2020 5:03 pm UTC
PURCHASER
Really love this tool set, I don't know how I would run my game without it. I do have a question though. What is the drop down menu under the picture on the Encounter Builder for?
Customer avatar
Lincoln S January 14, 2020 5:15 pm UTC
CREATOR
Thanks for saying that! I appreciate it. That dropdown is for looking up creature names that you don't quite remember.

Excel data validation is very picky and doesn't autofill so I tried to replace all of those cells with combo boxes, but that was too laggy. Long story short, the dropdown below the picture is to help with looking up monsters because it autofills and is more userfriendly, but it's an imperfect solution.
Customer avatar
Kevin W January 14, 2020 5:40 pm UTC
PURCHASER
Ahh, yes that makes perfect sense. Thanks for the quick reply.
Customer avatar
Lincoln S January 16, 2020 1:45 pm UTC
CREATOR
No problem! Let me know if you need anything else.
Customer avatar
Anthony V December 05, 2019 5:27 am UTC
PURCHASER
hey guys. Having a brain fart. I cant alter any of the cells in the excel sheets. any help?
Customer avatar
Lincoln S December 10, 2019 10:06 pm UTC
CREATOR
When you first launched the sheet did you click "enable content"? That's the only thing I can think of right away that would prevent you from editing. None of the sheets should be protected either.

Did you try redownloading the sheet? Which sheets are giving you trouble? What version of the sheets? What version of excel are you using?

Thanks for dropping a line so I can help!
Customer avatar
Glen P October 28, 2019 5:55 pm UTC
PURCHASER
Hi!
First of all, want to say what a brilliant tool this is! Thank you for your hard work!
I come with a slight annoyance however, in that, when rolling the initiative, it automatically sorts PCs into order yet doesn't function for monsters? Any way I can resolve this?

Thanks in advance!
Customer avatar
Glen P October 28, 2019 6:05 pm UTC
PURCHASER
For further understanding of my issue, the roll button does not carry out its function, and manually entering numbers for initiative does not rectify the initiative order. Thanks
Customer avatar
Lincoln S October 29, 2019 4:01 pm UTC
CREATOR
Hey Glen!

What version of the spreadsheet are you using? Can you check to see what the "calculation options" on the formulas tab is set to? When you press f9 does the order update? When you say that the roll button doesn't work what happens when you press it?

Have you tried re downloading the sheet? Does the issue persist?

Let me know what you find!

Thanks for the nice review by the way!
Customer avatar
Glen P October 29, 2019 6:36 pm UTC
PURCHASER
Hi Lincoln!
Thank you for getting back to me. I re-downloaded the sheets and this time it works perfectly. I am wondering, however, that the time I attempted to use the function, I had loaded a saved encounter yet when I tried it without one it works perfectly. Also, I had added monsters to the library so maybe this has something to do with it?

Thanks
Customer avatar
Glen P October 29, 2019 7:52 pm UTC
PURCHASER
Lincoln,
Just to let you know and I don't understand Excel anywhere near enough, but the initiative for monsters works perfectly on non-saved encounters. I have added enemies to the library and it rolls and sorts for them, but not on any pre-redied encounter.
Hope this helps!

Thanks
Customer avatar
Gary J October 21, 2019 11:04 pm UTC
PURCHASER
If I want to add a custom race (or class) how would I go about getting it into the encounter builder?
Customer avatar
Lincoln S October 22, 2019 3:20 pm UTC
CREATOR
Unfortunately it's maybe not as easy as you were hoping. Admittedly, I have been meaning to add in an easy way to do this, but I keep putting it off. I'll make it a priority for the next version!

That being said, if you right click a tab (like the player manager tab for example) and click unhide you can unhide the "Character Lists" sheet. On that sheet there is a table for race and class. to add more races and classes you can enter it to the table here.

That's sort of a back end way to do it.
Customer avatar
Lincoln S November 18, 2019 8:48 pm UTC
CREATOR
Hey Gary! I added a button to unhide the sheet with all of the races and classes (as well as other stuff) for easy customization in version 2.10.

Let me know what you think!
See 16 more
Narrow Results
 Follow Your Favorites!
NotificationsSign in to get custom notifications of new products!
 Recent History











Product Information
Gold seller
Community Content
Author(s)
Rules Edition(s)
Format
Original electronic
Scanned image
These products were created by scanning an original printed edition. Most older books are in scanned image format because original digital layout files never existed or were no longer available from the publisher.

For PDF download editions, each page has been run through Optical Character Recognition (OCR) software to attempt to decipher the printed text. The result of this OCR process is placed invisibly behind the picture of each scanned page, to allow for text searching. However, any text in a given book set on a graphical background or in handwritten fonts would most likely not be picked up by the OCR software, and is therefore not searchable. Also, a few larger books may be resampled to fit into the system, and may not have this searchable text background.

For printed books, we have performed high-resolution scans of an original hardcopy of the book. We essentially digitally re-master the book. Unfortunately, the resulting quality of these books is not as high. It's the problem of making a copy of a copy. The text is fine for reading, but illustration work starts to run dark, pixellating and/or losing shades of grey. Moiré patterns may develop in photos. We mark clearly which print titles come from scanned image books so that you can make an informed purchase decision about the quality of what you will receive.
Original electronic format
These ebooks were created from the original electronic layout files, and therefore are fully text searchable. Also, their file size tends to be smaller than scanned image books. Most newer books are in the original electronic format. Both download and print editions of such books should be high quality.
File Last Updated:
May 15, 2020
This title was added to our catalog on September 07, 2017.