Close
Close
Advanced Search

Dungeon Master Excel ToolkitClick to magnify

Dungeon Master Excel Toolkit

ADD TO WISHLIST >
Suggested Price $7.00

In development since 2017 with over 13000 downloads!

"I've always been fully committed to good notes, pen, paper, dice and a DM screen. However, after one session, I'm completely converted to these excel worksheets and have ditched the DM screen for the laptop. This tool is fantastic!" ~Brad L.

"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 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 comment in the discussion area of this title, and taken time to leave your kind words in the review section. This project is a labor of love and i really appreciate the feedback.


Encounter Builder 2.16 - Updated 05/17/2023

  • 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 & Tavern Generator - 1.1 - Updated 07/03/2021
  • Random NPCs with:
    • Name generator using XGE and other sources
    • Race randomization based on demographic percentages
    • Gender
    • Weighted Occupation
    • Appearance generator using a custom algorithm
      • Supports all official races at time of release with unique descriptions
    • Talents
    • Mannerisms
    • Interactions with others
    • Ideal
    • Flaws or Secrets
  • Procedurally generated inns and taverns with:
    • Random name generator
    • Randomized bartender/concierge
    • Quality settings
    • Descriptions ready to be read to your players
    • Detailed exteriors, interiors, and basic atmosphere for your most frequented establishments
  • The descriptions are generated ready to read to players and have all the information that you need to generate on the fly and have fresh interesting tavers and inns for your players!
  • Everything is customizable if you dive into the data sheets, or you can use as it is!
Character Builder 2.6 - Updated 12/30/2022
  • 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!

For a number of reasons i've really slowed down development on this project and i don't think i'll be making any major updates in the future. This content is published under the Dungeon Masters Guild Community Content Agreement, but if you are interested in GPL-3.0 Licensed versions both the Encounter Builder and NPC & Tavern Generator are available on my Github. the Encounter Builder can be found here, and the NPC & Tavern Generator is available here. They are missing a huge number of entries so the GitHub versions are really only to license out the code that i wrote as open source. The versions here are fully featured. If you decide to take any version of the sheet to make your own version I'd love to see the improvements you make!

Excel 2013 or greater required for full functionality. For Apple users i believe this most recent update removed the last of the ActiveX so the sheet should run just fine for you now!

pixel_trans.gif
 
 More from this Title's Contributors
pixel_trans.gif
 
 Customers Who Bought this Title also Purchased
pixel_trans.gif
pixel_trans.gif
Reviews (12)
Discussions (59)
Customer avatar
Nathaniel S May 09, 2023 3:13 am UTC
PURCHASER
Hi -- as a few others have mentioned below, I recently purchased this toolkit and, on my Mac, I can only open some of the Excel files as Read-Only due to a lack of ActiveX support. Is this something that is actively being worked on? The sheets look beautiful; it's a shame I can't use them.
Reply
Customer avatar
Lincoln S May 17, 2023 4:16 pm UTC
CREATOR
Hey! Yeah, sorry about that. I thought i had fixed it, but i guess there are still some activex buttons lingering around... I dont have a mac to test with so it's a bit trial and error with these bug reports. Since it looks like more mac users are trying to use it recently (or maybe more folks are just reporting errors) I'll make it a higher priority.
Reply
Customer avatar
Lincoln S May 18, 2023 1:51 am UTC
CREATOR
Just fixed this today! Try out the new version and definitely let me know if the issue persists!
Reply
Customer avatar
Nathaniel S May 21, 2023 7:27 pm UTC
PURCHASER
Thank you so much!! Yes, the new version works perfectly, I'm very excited to try these tools out :)
Customer avatar
Kerry M April 16, 2023 6:09 pm UTC
PURCHASER
I purchased the "Dungeon Master Excel Toolkit" yesterday and am running the "Encounter Builder 2.15.xlsm" in Excel 2013. It appears that there are problems with the macros used in the "Character Manager" tab for the 3rd, 6th, 8th, 9th & 10th characters. I begin from a clean spreadsheet using the Clear Palyer Data "Clear" button. The "Current Hit Points does not autopopulate for the 3rd, 6th, 8th, 9th & 10th characters. The "Encounter" tab does not list the 3rd, 6th, 8th, 9th & 10th characters. Is there an update to the program? Also is there a FAQ or users guide? Thanks the program looks like it will be very helpful to running a session.
Reply
Customer avatar
Lincoln S May 17, 2023 4:20 pm UTC
CREATOR
Ooooo good catch. Yeah i'll take a look at this. I'm guessing i added a row or something at some point and it messed up the clear function. I'll post an update once i've had a change to take a look, it has been awhile since i've done a release...
Reply
Customer avatar
Lincoln S May 17, 2023 4:22 pm UTC
CREATOR
Oh! and no, there's no user guide at this point and i don't know when/if i will get around to it. I try to make it intuitive, but i'm somewhat constrained by it being an excel sheet.
Reply
Customer avatar
Lincoln S May 17, 2023 4:58 pm UTC
CREATOR
Hey, I just went in to verify and I think I know the issue. After clearing the sheet and populating new player information did you ready the encounter from the encounter builder? The encounter sheet only updates combatants after you ready an encounter. Because in the example player data the 3rd, 6th, 8th, 9th & 10th characters are not "Active" so they don't show up in the encounter until you re-ready the encounter.

If I've pieced this together correctly this is a feature, not a bug. You can use the active check box to signify if a player is at the table that session or not and this signals the rest of the sheet to include their character or not in encounters.
Reply
Customer avatar
Lincoln S May 18, 2023 1:55 am UTC
CREATOR
Hey! I had an idea to just add a bunch of tool tips and a quick start guide in the version today! Hopefully that helps!
Customer avatar
Sean C March 12, 2023 8:08 pm UTC
PURCHASER
Mac is showing problems. I see notes about it here, but no fixes. It says you need "ActiveX". Seems this isn't (and more than likely won't be) available for Mac.
Reply
Customer avatar
Lincoln S May 17, 2023 4:15 pm UTC
CREATOR
Yeah, I need to go in and replace all of the buttons with non activex buttons. I thought i had gotten all of them fixed, but i guess not. I don't have a mac to test on so i have to rely on bug reports like this to fix. I'll try and get it fixed soon here since it looks like there are more and more mac users trying to use the tool.
Reply
Customer avatar
Lincoln S May 18, 2023 1:52 am UTC
CREATOR
Just fixed this today! Try out the new version and definitely let me know if the issue persists!
Customer avatar
John W March 06, 2023 9:52 pm UTC
PURCHASER
Hello, I downloaded this content and it seems to have problems working on a Mac computer. Is this typical? I get a runtime error when I try to use any of the automated functions. Thanks for all you have done to make this amazing spreadsheet! I am using Excel version 16.63.1 on Mac.
Reply
Customer avatar
John W March 12, 2023 7:02 pm UTC
PURCHASER
Never mind! I figured it out. Thanks for the amazing resource!
Reply
Customer avatar
Lincoln S May 17, 2023 4:13 pm UTC
CREATOR
Great to hear! What was the issue in case anyone else is having problems?
Customer avatar
JR H September 25, 2022 7:45 am UTC
Hi Lincoln S,
Found your App, I am interested in exchange of idea's and even possible contribution. I have a general interest in professional Excel development (Even more than rpg itself). Small hack here as demonstration of my interest...https://www.youtube.com/watch?v=N3NYnNNAQmk
(please feel free to remove this comment, but I have no idea how to contact you directly)
Reply
Customer avatar
Lincoln S October 14, 2022 6:38 pm UTC
CREATOR
Hey JR,

The best way to get ahold of me for this type of stuff is honestly probably my Reddit account: Linc3000. Thanks for commenting! I'm not looking for contributors at this point, but I'm always happy to hear from other folks with enthusiasm for data management and TTRPGs.
Customer avatar
sara R August 26, 2022 10:37 pm UTC
PURCHASER
I just purchased this content and when I go to use the NPC generator the only race available is 'Duergar'??? I downloaded the file twice and it was the same for both downloads. Am I missing something to enable all other races? When I look in the Bulk NPC area there isn't anything there other than various Duergar either.
Reply
Customer avatar
Donald B September 11, 2022 5:39 am UTC
PURCHASER
I'm currently having a similar problem with all of the programs on this. None of the dropdowns will load any of their options.
Reply
Customer avatar
Lincoln S October 14, 2022 6:23 pm UTC
CREATOR
Donald and Sara,

Thanks for reaching out about the issue. I am not able to replicate the error on my side though so i have a few troubleshooting questions for you:

-What version of the sheet are you running?
-What version of Excel are you running?
-Have you tried redownloading?
-Are you on mac or PC?

The more info you can give me the better! hopefully i can get this fixed up for you.

Thanks!
Reply
Customer avatar
John W March 12, 2023 8:12 pm UTC
PURCHASER
Sara and Donald, I was experiencing the same thing, but then realized it was user error. You just need to bulk generate NPCs from the first sheet and then it will give you the option to either overwrite the Duergar sample page, or create a new one. Happy GMing!
Reply
Customer avatar
Lincoln S May 17, 2023 4:17 pm UTC
CREATOR
Ah ha! Thanks for sharing. I try not to ever assume user error, but that makes sense. Yeah, John is right. Give that a shot!
Customer avatar
Rick V August 16, 2022 1:51 am UTC
PURCHASER
Loving the encounter builder but running into a problem. Anytime I add a new creature to the enemy library (using the button on the sheet) it seems to work ok. After I add that new creature to the Encounter Builder table and click "ready" I get a Run Time Error 6 "Buffer Overflow" error. When I click debug it highlights this code "Numb = SplitHP(Dice, 0)". I tried re-downloading the file but see the same result. I am running this on Excel 365 (desktop install) on Win 10. Any thoughts? I have the default Excel security settings - do I need to change something there?
Reply
Customer avatar
Lincoln S September 01, 2022 7:53 pm UTC
CREATOR
Hey Richard,

I'm glad you're enjoying it! what are you putting in for the hp of the custom creature? I am not able to replicate the error. Usually that error only comes up if you exceed the max value for the variable type. I'm using an integer for Numb so you should be able to go up to 32,767 hp before running into that error.

Thanks!
Linc.
Customer avatar
Coleton D July 14, 2022 9:45 pm UTC
PURCHASER
Hello! You'll need to forgive me as I am a complete Excel noob, but I am having some issues opening/using the doc. I'm a Mac user just fyi.

So when I go to open the file, it tells me my version of Excel doesn't support ActiveX. When I try to open Read-Only, I can't use a lot of the features. I don't understand as I have the latest version of Excel, and I can't seem to find anything through a Google search about "enabling" ActiveX or whatever that is.
Reply
Customer avatar
Lincoln S May 18, 2023 1:57 am UTC
CREATOR
Just fixed this today! Try out the new version and definitely let me know if the issue persists!
Customer avatar
Alec P April 20, 2022 2:32 am UTC
PURCHASER
Sorry for "spamming" the comment section, I don't know why i can't respond to my own comment.

*Update on my own comment*

After more than an hour trying to fix some problems (few hours before writing the comment and an hour after writing it) I fixed a couple of issues by my own. I just want to say that my errors are in the encounter builder excel document.

1. "The first one is that when I change the condition on the encounter page, the player manager doesn't update with the condition."
For some reason, the command line was deleted so reinstalled the excel sheet and copied and pasted the line.

2. "The Size column also doesn't work, it only reading Medium Humanoid when I have a 7"8' Goliath."
I don't know how your sheet work, I think it take the info of the race that we choose. I have played a bit with it and its seems to work.

3. "I also had some problems with Names of the player in the Encouter...See more
Customer avatar
Alec P April 20, 2022 1:32 am UTC
PURCHASER
Hey, first of all, great document for DMing but ive found a couple of problems at least on my document.

The first one is that when I change the condition on the encounter page, the player manager doesn't update with the condition.

Also, the clear defeated enemies button doesn't work on the encounter page.

The Size column also doesn't work, it only reading Meduim Humanoid when I have a 7"8' Goliath.

I also had some problems with Names of the player in the Encouter page. I put my player size to 5 and when I changed the names on the 3th player it showed up 0 "zero" as is name. I checked the active mark.

In the Xanathar's encouter builder and the Encounter Builed page, when I add some creature, the CR and Individual EXP show up ok but the groupe EXP and % of total have 0 and 0%. Also the math on the Group EXP look werid. I am 5 in my party and the rat exp is 10 per player but the Group EXP is only 40EXP.

The Encounter Difficulty...See more
Customer avatar
Chris W December 19, 2021 11:14 am UTC
PURCHASER
Hey, I have tried downloading the file and it is saying that the source file is not found. Tried direct download and dropbox
Reply
Customer avatar
Lincoln S January 03, 2022 10:23 pm UTC
CREATOR
That might be a DMs guild issue. Are you downloading the newest 07/05/2021 release?
Customer avatar
Lisa E December 06, 2021 11:34 pm UTC
PURCHASER
I'm having a problem where the Current HP is not displayed at all on the Player Manager Tab. No errors, it just does not show. I have tried redownloading the file and using it, and I am on Office 365.
Reply
Customer avatar
Lincoln S January 03, 2022 10:40 pm UTC
CREATOR
Lisa,

So first of all thank you for telling me! and Second it's not your fault! I missed that after I added a column I didn't go back an update the column number in the sheet. If you want to fix it in the interim the current HP formula just needs to have the 5 changed to a 6 and it should work fine! Otherwise I will be publishing an update to fix it in the near future.

Thanks again!
Reply
Customer avatar
Lisa E June 25, 2022 9:48 pm UTC
PURCHASER
Thank you! This fix worked perfectly.
Customer avatar
Carlos S November 06, 2021 12:46 pm UTC
PURCHASER
Greetings, love the sheet. I was using an older version and there was an initiative tracker tab. when i downloaded the newest version that tab is not there. Is this user error?
Reply
Customer avatar
Lincoln S November 15, 2021 4:14 pm UTC
CREATOR
Great question! No user error, the initiative sheet has been ingratiated into the encounter tab! updating is slightly less automated, but now you only need to use 1 tab while running an encounter!
Customer avatar
Andrés M November 03, 2021 12:49 am UTC
PURCHASER
Hey! I'm having a problem where the Current HP is not displayed at all on the Player Manager Tab.

This is the error that pops up on my excel sheet.

=_xlfn.IFNA(AK19-INDICE(Encounter;COINCIDIR(AK11;Encounter[Creature];0);5);"")

I'm using excel 2010 if that helps. I hope you can tell what may be wrong. I'm sorry I don't know enough excel to be of help.
Reply
Customer avatar
Lincoln S November 15, 2021 4:10 pm UTC
CREATOR
Ah, there's the issue. I will update the description, but it looks like the IFNA function is only supported in excel 2013 and beyond. Unfortunately there isn't an easy way for me to rework my code to avoid that function so the only fix that I can recommend would be moving to a newer version of excel.

I apologize for the inconvenience, and I will update the description with that new compatibility information.
Customer avatar
Matt C September 11, 2021 9:50 pm UTC
PURCHASER
Lincoln, in my download the current hit points and condition on 'player manager' are not updating when changed on the encounter page. It seems that the index isn't getting a match.
Also the AC didn't match my players AC when they calculated it with the "book" method

Running my first ever campaign DM tonight and will be using the spreadsheet, I'll tell you how it goes. I'm super stoked with this!
Reply
Customer avatar
Lincoln S September 14, 2021 8:42 pm UTC
CREATOR
First of all, I hope your game went well! How was

I've got a few troubleshooting questions for you!

-What version of the sheet are you running?
-What version of Excel are you running?
-Have you tried redownloading and trying it on a fresh sheet?
-What was the discrepancy that you were seeing on the AC calc? What modifiers did the character have?

Hopefully I can help! And if there's a bug I'm guessing it's an easy fix.

Thanks for reaching out!
Reply
Customer avatar
Matt C September 25, 2021 11:57 pm UTC
PURCHASER
Good Afternoon Lincoln!

It went great I am running the Death Pit of Moloch tonight. I'm pretty stocked for this new hobby its so much fun!!!!!
I am using encounter builder 2.14.1, excel version 2108 (build 1426.20404 click to run)

I think the AC Modifier didn't work for only one player a Drow Elf, her "book" AC was 2 higher then calculated.

That didn't play much into the overall game play.
Sorry for the late reply, I guess I haven't set my account up for email notifications.

If you would like any help in some VBA I would like to offer any help, if you don't have a larger team :)
Reply
Customer avatar
Lincoln S October 02, 2021 5:23 pm UTC
CREATOR
Glad to hear it went well! I'll do a little sleuthing and see why it didn't calculate correctly. Would you be able to post the calculation for the drow and all of the modifiers according to the book? That would really help me narrow things down.

It's just me working on this! I appreciate the offer and I'll keep that in mind if I'm ever looking to grow the team!
Customer avatar
Spartan S July 25, 2021 2:28 pm UTC
PURCHASER
Good job on the spreadsheets dude! It's clear you've put a lot of work into this, and it shows. I have one minor request: Can you add in Halfling as a race? I've done it manually on my copy but it'd be useful for the other folk.

I have a major request too, but would totally understand if you don't want to go this route. It's a huge ask with a lot of hours to put in. Basically, I'd like to view average damage output per round from both players vs the monster. In addition to finding how many ally and enemy combatants there are to determine who will most likely win, comparing average damage output versus average health is another way to determine which side will likely win. Obviously that doesn't count for special abilities or tactics, but it's a tool I've used in the past to help figure out if my party can handle an encounter or not.
Reply
Customer avatar
Lincoln S August 01, 2021 3:54 pm UTC
CREATOR
Thanks Jason! It's a labor of love.

Halfling is already included on a sub race basis like the other races with sub races. Currently there are Lightfoot, Stout, Lotusden, and Ghostwise halflings available in the dropdown as those are the sub races that have been published by WoTC.

As for your major request, that is a big ask! I'll keep it in mind, but I can't promise it'll be added any time soon.

Thanks for the feedback, I'm glad you're enjoying the tool!
See 16 more
Narrow Results
$ to $
 Follow Your Favorites!
NotificationsSign in to get custom notifications of new products!
 Recent History















Product Information
Platinum seller
Community Content
Author(s)
Rules Edition(s)
Format
Original electronic Click for more information
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.
pixel_trans.gif
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 17, 2023
This title was added to our catalog on September 07, 2017.