Close
Close
Advanced Search

Dungeon Master Excel Toolkit

Dungeon Master Excel Toolkit

ADD TO WISHLIST >
ZIP File
$
Suggested Price $2.40

Over 2 years of development, 3500+ downloads, and 20 ratings with an average rating of 4.9 stars!!!


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.9

  • 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.
  • 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
    • 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.
  • 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
  • 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.1
  • 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
  • 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.3
  • Includes basic race and class info
  • Gives race and class matchups based on modifiers
  • This is a good starting point, but this should not be used in place of the book info.

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 (6)
Discussions (14)
Customer avatar
Harry S August 03, 2019 9:33 pm UTC
PURCHASER
Hi there! I purchased this thing hoping it would help but I am completely Excel illiterate. I am trying to use the encounter builder sheet and everything seemed to be working until I got to character race. The drop down menu won't display anything and when I try to type the race it tells me "A user has restricted values that can be entered into this cell." Any clue what I am doing wrong? Thanks in advance.
Customer avatar
Lincoln S August 04, 2019 1:47 am UTC
CREATOR
Huh, so I am not sure what the problem is but maybe I can help troubleshoot with you. What version of excel are you using? Did you enable macros when prompted when you first opened the sheet? Which version of the sheet are you using? Have you tried re-downloading the sheet?
Customer avatar
Harry S August 04, 2019 10:22 pm UTC
PURCHASER
Sorry if I'm not much help. I don't know how to enable macros, so that may well be the problem. I'll do a Google search to see how to do that and let you know if that fixes it.
Version is Excel 2002 10.2614.2625 if that helps. Thanks for replying!
Customer avatar
Harry S August 04, 2019 10:45 pm UTC
PURCHASER
I found out how to enable macros but nothing has changed. I can input player name, character name, level, and everything until I get to Race. There is an arrow for a drop down but nothing happens when I click it, and no matter what race I type into the box, it throws that error.
I re-downloaded everything and unzipped the files. Opened up the Encounter Builder 2.8 sheet and it prompted me to enable macros, which I did. Then a Visual Basic window popped up and gave me: "Compile error: Method or data member not found." The script looks like it has something to do with the window sizing??? This only happens with the 2.8 version. 2.7 doesn't bring up the VB error.

Do you know if this will work in OpenOffice or Google Docs? Thanks.

Edit: On the "Trusted Sources" tab, the "Tryst access to Visual Basic Project" box is unchecked. I'll try that and see it anything changes.
Nevermind. It didn't help. =(
Customer avatar
Harry S August 05, 2019 10:54 am UTC
PURCHASER
I can indeed open it in OpenOffice but the same thing occurs. I can enable macros, but when I try to input Race it gives me "Error 502" which is "Invalid argument A function argument has an invalid value, e.g. a negative number for the root function." Any ideas what is causing this? Thanks.
Customer avatar
Lincoln S August 08, 2019 3:50 am UTC
CREATOR
Well I think we may have gotten to the bottom of it here. According to the compatibility report i just ran on the sheet you need to be using at least Excel 2010 for it to work properly (2007 works also but some of the conditional formatting will break.)

Excel 2003 and earlier cannot handle the table references that are critical to the function of this sheet (including the race cells.) I have never used OpenOffice, but it looks like that program only supports limited Macro usage and unfortunately these sheets use macros extensively so I can't support Open Office... I can however, confirm that this definitely will not work on google docs. I wish I could make this tool excel independent, and while I am working on teaching myself C# my skills are far too limited to fully replicate this tool at this time.

Sorry I wasn't able to help! I hope you can work something out, just remember that if you do decide to upgrade excel version 2010 appears to be the minimum compatible version.
Customer avatar
Harry S September 03, 2019 10:24 pm UTC
PURCHASER
Thanks for the info. Work has been busy so my campaign and everything associated with it have been on hold. I'll see about getting Excel upgraded. Thanks again!
Customer avatar
Lincoln S September 04, 2019 4:48 pm UTC
CREATOR
No problem! Glad I could answer your questions!
Customer avatar
Trym S July 08, 2019 9:42 pm UTC
PURCHASER
Hi, thanks a bunch for a great tool! I read through the discussions and I am aware that there are some errors on Mac, but perhaps you know a fix to my problem. In the player Manager sheet, when i try to look up items I get the following error: Run-time error (380) - could not set rowsource properly. invalid property value. Im using the the latest excel version for mac. I also have the same problem when i click view/load on build encounter sheet although a different error message: Run-time error -2147352571 (80020005):
Could not set columnWidths property. Could not complete the operation due to error 80020005.

Hope you can help, when you have the time :)
Thanks again for a great product.
Customer avatar
Lincoln S July 19, 2019 1:18 pm UTC
CREATOR
Hey Trym!

First of all, I saw your review and I appreciate the 5 stars even with the glitches, but unfortunately I don't have great news for you... As you know you're not the first person to have this bug. This is because the Mac version of Excel does not have the rowsource property in VBA and I didn't know this when I was coding the forms. There's nothing to fix on your end (unless you wanted to get in there and fix my code,) I have to do some re-coding on my end to fix this.

It's on my agenda, but I don't know when I'll be able to get in and fix everything. Hang tight, I'm traveling for work for the next three weeks and I might have some time in the hotel room to work on it! Ever since I graduated and started a full time job I haven't had as much time to work on the encounter manager now that I have so many other projects.
Customer avatar
Lincoln S July 27, 2019 2:37 am UTC
CREATOR
Hey Trym!

Great news! I've hopefully fixed all compatibility issues with the release of 2.8! Let me know if you still have problems.

Thanks again!
Customer avatar
Trym S August 30, 2019 3:39 pm UTC
PURCHASER
Thats great ill test it out and confirm
Customer avatar
Chas M July 07, 2019 11:48 pm UTC
PURCHASER
Just found this tool - just what I was hoping for. I use Excel 2016 for Mac. When I click "view/load" on the encounter builder, I get an error: "Run-time error '380'. Could not set the RowSource property. Invalid property value." When I debug, it goes to the "loadem" macro and highlights in yellow "EncounterBrowser.Show" under "Public Sub BrowseEncounters()" at bottom of code. I know very little about macros/VBA. I saw the tip about changing the list value with range(), but I did not see this text in the macros that I scanned. Can you help?
Customer avatar
Lincoln S July 19, 2019 1:11 pm UTC
CREATOR
Yeah, hey chase.

First of all, I'm glad to hear it's what you're looking for, but unfortunately I don't have great news for you. So you're not the first person to have this bug. This is because the Mac version of Excel does not have the rowsource attribute in VBA and I didn't know this when I was coding the forms. There's nothing to fix on your end, I have to do some re-coding to fix this.

It's on my agenda, but I don't know when I'll be able to get in and fix everything. Hang tight, I'm traveling for work for the next three weeks and I might have some time in the hotel room to work on it!
Customer avatar
Lincoln S July 27, 2019 2:37 am UTC
CREATOR
Hey Chas!

Great news! I've hopefully fixed all compatibility issues with the release of 2.8! Let me know if you still have problems.

Thanks again!

(p.s. sorry for calling you chase in my last comment!)
Customer avatar
Chas M August 21, 2019 1:21 pm UTC
PURCHASER
It works beautifully on my Mac - thank you! Great product, quick response. I purchased it for $5 based on the excellent customer support and attention to us Mac users. I have an Office 365 subscription, so the most recent version of Excel.
Customer avatar
Lincoln S August 27, 2019 9:13 pm UTC
CREATOR
Hey I appreciate it! You're helping fund my next DnD book purchase! Let me know if anything else goes wrong with it!
Customer avatar
Michael F May 20, 2019 12:56 am UTC
PURCHASER
This is just amazing work. I know very little about excel capabilities and coding. I have attempted to use this on excel with my tablet but it appears Microsoft do not allow the use of VBA functions in excel on Android or IOS devices.
Is there any alternative program that would allow the spreadsheet to function as intended in its current state on android devices?
Customer avatar
Lincoln S May 23, 2019 1:59 pm UTC
CREATOR
Unfortunately short of creating a standalone app (which is well outside my wheelhouse) there is no way that i know of to run this outside of desktop excel....

Sorry about that! It would be pretty convenient to run off of a tablet though so i can see the appeal.

Also, thanks for the compliment! I appreciate it!
Customer avatar
Baelin D April 16, 2019 12:07 am UTC
PURCHASER
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.

I'm encountering an odd bug when I attempt to edit data in the sheet. The excel program on my laptop crashes (2018 laptop, i7 8th gen processor, Win 10) every time I attempt to save the file after editing it. I have no clue what's causing this issue, and have tried clearing out some of the formatting and deleting unnecessary images or macros to try and trim down the sheet (even though it physically pains me to alter any aspect of this glorious project).

Any suggestions regarding fixing this crashing issue?
Customer avatar
Lincoln S April 18, 2019 2:31 pm UTC
CREATOR
Yeah, so which sheet are you trying to alter? What version of Excel are you using? Is it when you alter specific data, or any data? Does it save successfully when you don't change anything? Which version of the sheet are you using? Have you tried re-downloading?

I can try my best to help!
Customer avatar
Rob. G March 30, 2019 2:00 pm UTC
PURCHASER
Very good work. As a suggestion, I could recommend some things for the Initiavite Tracker sheet (Encounter Builder).

Maybe you could implement a little square of rounds counter on that sheet, with 2 buttons (to add or subtract 1 each time you click), you have space under the Players cell. Maybe another little square of time counter below to add hours and minutes with buttons (this would make it easy to control the DM a record of how many hours have passed and what time of the day they are ... the DM according to the event that is being completed can be adding or substracting minutes or hours, and so you can control better when controlling the duration of the spells of the players)

Next to the "Order" cell, you could put another cell with the name maybe "Monster Tracker hp" ..... with 4 squares "Name", "Total hp", "Current hp" and "Injuries" for example. In the box of Injuries you could put a function of autosum (each time you...See more
Customer avatar
Lincoln S April 03, 2019 7:37 pm UTC
CREATOR
Thanks a million for the feedback! I wish I could get feedback from all of my users!

To address some of the comments:

Concerning passive perception: YES! That's actually a bug! I'll fix it in the next rev.

As for STR, DEX Proficiency bonus, Height, etc: I leave those in because I play with a lot of newbies so I don't want to be constantly asking them what their carry capacity, AC, etc. But also because i like to reference stuff like height, weight, or the type of armor they're wearing for when i'm describing a short hallway, or if the players need you lift another PC, or what have you.

If you want to get rid of stuff just go to view>Show headers>highlight the rows you want hidden>right click>hide. With that said, I think in the next rev I'll make a menu to select what information you want shown on the player handler. Good feedback!

It might be a bit though, because I am working on a 3.0 version of the NPC generator right now and I recently...See more
Customer avatar
Ronald P March 28, 2019 3:02 pm UTC
PURCHASER
Is there a way to add homebrew creations to the encounter builder?
Customer avatar
Lincoln S April 03, 2019 7:14 pm UTC
CREATOR
Yes! You can just add more rows to the Creature library! Let me know if it's not working!
Customer avatar
Tyler B February 19, 2019 9:33 pm UTC
PURCHASER
Would it be possible for you to publish a short 'How to' video on utilizing all the awesome features of the Toolkit? (Specifically the Encounter Builder) I love what you've done here, but I feel I could get more out of the toolkit if I properly knew how to use it but I'm not super Excel savvy.
Customer avatar
Lincoln S February 20, 2019 10:08 pm UTC
CREATOR
I'm glad you like it!

I never thought about that... Ummmmmm... maybe? It'll be awhile before I get around to it, but now that you've suggested it it's on my radar!

For now, do you have any specific questions that I could answer? I really try to make it as intuitive as possible.
Customer avatar
Cody L December 04, 2018 2:40 am UTC
PURCHASER
So i have been using this alot since i purchased it, however I just moved to a Mac laptop and apparently rowsource does not work on macs so the encounter sheet is unusable on Macs.. any plans to make a compatible version? I've been trying desperately to alter the code to allow it to work on my mac but three days in and I have been unable to get it to work
Customer avatar
Lincoln S December 05, 2018 7:13 pm UTC
CREATOR
Oh jeez! I had no idea! Let me look into it. Which aspects aren't working? That should only effect a couple of user forms, which ones are failing?
Customer avatar
Werner S January 26, 2019 9:10 am UTC
PURCHASER
VBA on OS X misses functionality that is available on Windows, but fortunately there is an easy work-around for the RowSource() problem. Simply explicitly set the List property of the control to the named range using the Range() function. For example

Replace:
LstEncounters.RowSource = "SavedEncounters"

With:
LstEncounters.List = Range("SavedEncounters").Value
Customer avatar
Lincoln S February 04, 2019 12:34 am UTC
CREATOR
Thanks! I'll fix this in the next version. I want it to be as universally compatible as possible.
Customer avatar
Sebastian W October 19, 2018 5:50 pm UTC
PURCHASER
Hey! I'm in love with this tool, but! I am having a huge problem. When i hit the View/Load Button on the Encounter Builder it gives me an error code 80020005, and something with ColumnWidth.

In VBA, when i try to debug it shows that something is wrong with this string:

Public Sub PullLoadView()
EncounterBrowser.Show
End Sub

Where string number 2 ( EncounterBrowser.Show) is highlighted :)
Customer avatar
Lincoln S October 26, 2018 4:25 am UTC
CREATOR
I'm glad you like it!!! I worked hard to make it decent!

Thanks for all the info. Have you saved any other encounters? Hopefully I can have this fixed by the next release!
Customer avatar
Louis R January 27, 2019 1:51 pm UTC
PURCHASER
Hey there ! Had the same problem but the solution is quite easy. Just change your Excel language settings to English (if it's not the case already). Apparently it messes up with the column width if you don't use the same parameters as those used for the creation of the document. It fixed it for me ! Hope it works for you ^^
Customer avatar
Lincoln S February 04, 2019 12:33 am UTC
CREATOR
Thanks for investigating this, and thanks for posting it here!
Customer avatar
Jared D October 11, 2018 5:31 am UTC
PURCHASER
This looks like it took a lot of work. Great job!

I do have some issues though with the Encounter Builder 2.5.1 sheet.

1. In the Encounter Builder tab it is very difficult to find the monster you want to select. You have to click the arrow to scroll through them manually. Scrolling causes it to jump down, and you cannot type in the monster name and have it auto-complete. In addition, whenever you select a monster, it shows N/A for CR level.

2. In the Readied Encounter tab it accurately pulls out the CR level like it should on the Encounter Builder tab. However, B2, the Difficulty cell, gives an invalid name error and doesn't show the difficulty rating. That same Invalid Name Error pops up in H15 on the Encounter Builder tab.

3. In the Player Manager tab you have an Invalid Name error on the cells that are supposed to show Exp Until Level Up.
Customer avatar
Lincoln S October 17, 2018 9:33 pm UTC
CREATOR
Oh jeez! I will get right on fixing those bugs. Thanks for letting me know!

Unfortunately, there's not a ton that I can do for the drop-down thing due to excel limitations, though I will take another look and see if I can't find a better solution.
Customer avatar
Lincoln S October 17, 2018 9:47 pm UTC
CREATOR
Jared, What monster are you selecting that is causing the error? Also, you may want to try redownloading the file because I am not seeing the player-manager tab but at all. I will be publishing a 2.5.2 version with more bug fixes soon, but I want to make sure that the bugs that you are seeing have been addressed first.
Customer avatar
Ezra H October 04, 2018 3:54 am UTC
PURCHASER
Does this have to be used through Excel? I'm using a different program that can run the file and some of the cells appear to be calling on things that don't exist and it's causing errors. For example despite putting in a character's Dex the Initiative modifier cell doesn't update.
EDIT: It seems to be an issue with trying to call upon formulas that were not downloaded with the file
Customer avatar
Lincoln S October 04, 2018 8:21 pm UTC
CREATOR
I built it using Excel 2016 and haven't tested it with any other programs. It relies very heavily on custom VBA formulas so if the program can't run vba the whole sheet will fall apart. What is the program you are using? I can always look into it.

Also, make sure your sheet is set to automatically calculate rather than manually calculate.
Customer avatar
Cody L October 03, 2018 9:28 pm UTC
PURCHASER
The award EXP button keeps throwing a runtime error 9 subscript out of range.
Debugger is identifying this line "If CDbl(splitit(1)) >= 5 Then"
Customer avatar
Lincoln S October 04, 2018 8:27 pm UTC
CREATOR
Fixed! It was an error with my custom rounding function that would break if the exp value was already a whole number. Try it in version 2.5.1.

Thanks for reporting the bug! I appreciate it.
Customer avatar
Paul H September 08, 2017 4:00 am UTC
PURCHASER
The "Active" Cell on the Player's tab doesn't work. Drop down list doesn't pull up and when your right click to force the list, the choices don't make any sense. I would think it would be "Yes/No" but it pulls up a bunch of random seeming stuff, including the players name. Concentration and Shield cells also doesn't seem to work properly. This is great looking product but there are a couple of initial bugs.
Customer avatar
Lincoln S September 27, 2017 11:27 pm UTC
CREATOR
Thanks for the feedback! I will fix this in the next rev!
Customer avatar
Lincoln S September 29, 2017 5:18 am UTC
CREATOR
Updated! The issues are hopefully fixed!
Narrow Results
 Follow Your Favorites!
NotificationsSign in to get custom notifications of new products!
 Recent History











Product Information
Electrum 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:
August 08, 2019
This title was added to our catalog on September 07, 2017.