Macro enabled files are not allowed on the site so
Last update: 17/12/2019 7h00 UTC (v3/3.2) -- Not documented here but some improvements for the DD4 sheet. I'm now using it on a regular basis and "should" prove useful to keep track of your players.
Check file history at bottom to see what's changed!
The color.png files are needed for the heroquest dice roller to show the pictures and must be in the same folder as the excel file! If not present the dice roller will work but no picture will be shown...
v2.0 adds a new sheet more geared toward D&D. It's still WIP so expect bugs and missing features, but I think it merits the detour ^^
v2.6 adds a partial translation (you can choose English/Français) and allows for more translations to be added! Added a quick overview manual too!
I try to update here as well but note that the most up-to date version will always be on mediafire!
Do not hesitate to leave a comment if you find this useful or not, if you'd like something more or if you find a nasty bug I'm always open
Below, the readme ^^
What is this?
Last modification: 17 Dec 2019
Link: DM tools
This tool is provided as is, I’ve put quite some time in it (I'm only a beginner in VBA but anyway I'm quite proud of it). The code is not password protected so you can check that there is no malicious things in there…
I made this sheet for my own pleasure so don't comment on "hey you use shitty tabletop rules" or "this mechanic is broken", after all code is open so change what you don't like! If someone build something better and/or for another system I’d like to see it, you’re free to do whatever you please, just give credit for the original work!!
This sheet was made to help me DM things easily with a custom rules system for my kids (if some of you know the Phantasy Star IV game on genesis) but with some tweaks in the code, can accommodate to D&D or other tabletop RPG rules (you will need a bit of vba knowledge though).
Major update 2.0: A second sheet is now available in the package, tweaked to be used with D&D 4th edition but is still WIP for now, so expect some bugs!
Major update 2.6: Translation is only partially done at this point (223 strings done) and concern buttons and labels only for now (and some are still missing but will come later). More languages may be added rather easily!
Major update 2.10: version 2.10 adds many little improvements from the previous version, such as handling recharge power, healing surges partially, support for multiple currencies (cp, sp, gp, pp) for rewards, and a bunch of bugfixes!
Final update 2.12: this version should be considered the last for the base DM-tools sheet for now, I probably won’t add much more features except bugfixes if any. Now started building a little game with the PS4 sheet as an addon that you can check as a WIP in the current version.
QoL update 3.0: Some bugfixes and QoL upgrades (mainly for DD4)
How to use the sheet:
The battle sheet is the main sheet you'll need to use. Every macro of this workbook is there, so be sure to use the buttons!!
The Main menu allows you to do many things like level up, rest, setup skills, powers and equipment for your characters, add/remove monsters or party members, edit objects from the database, edit your campaign, etc...
If you don't know what you're doing, YOU DO NOT NEED TO EDIT A SHEET MANUALLY!!!!
The Combat manager, well help you to manage combat. The “Main menu” is also accessible from here to allow you to edit things on the fly, adding monster or changing equipment during a battle for example. The data/stats are refreshed as soon as you exit the main menu and return back to the combat manager. You can switch between “Combat manager”, “Dice roller” and “Campaign view” screens and have all of them open at the same time. Others forms like the main menu and the various editors have to be closed to do anything else.
The Dice roller, well is a dice roller, also includes Heroquest dices with colored variants!
The Save/Load menu allows you to save a party or an encounter with a description (each with 100 slots who would need more than that?) to load for later use, allowing you to switch between multiple party/campaign by using the same sheet (useful if you put some time to add new data to the database as everything will be available whatever the campaign/party you’re using!)
The Campaign editor/viewer allows you to keep track of your campaigns (you can store up to 16384 campaigns with
Note: Only the path of the pictures/links are stored in the sheet to avoid too large file size. When you select your file from the editor the full path will be stored but the sheet will look at multiple places for your file (to allow for easier portability for example on an USB stick). The sheet looks first for the full path, then for the sheet/data/ path, then at the sheet root path. So to keep your pictures/links available you can set whatever path from your desktop computer when setting up the sheet for example and then just copy the pictures/linked files with the sheet on a USB stick to use it later on another computer.
Using the “Battle sheet”:
From the main menu, you can first use the “Database Editor” to add/edit/delete characters, monsters, items and powers from the database. This will be the first step to customize the data for your needs!
From there, you can use the “Encounter Editor” to add/remove characters and monsters from the current encounter sheet (“Battle sheet”), “Equipment”, “Stats/Gold”, “Powers/Skills” editor will allow you to customize further the various characters from the encounter.
The “LevelUp” and “Rest” menus will allow you to level up characters, and rest the party.
Last, the “Random Generator” will, errrrr, generate random things… It requires you to set up random tables though.
Note: Only the “Database Editor” will change the data from the various data sheets! “Equipment” and “Power/skills” editors can edit things in the database too if you select the corresponding option button, otherwise all other editors will change the characters on the “Battle sheet” only! You must always save/apply the changes you make for an entry if you want to select/edit another one and keep your changes, otherwise if you select another item, values will be reset to those previously saved!
Note: For the “Fantasy” sheet, classes are fantasy one, based on characters from the PSIV video game, as are rules mixed with others parts here and there. It’s a bit of a mess, but I want to make the sheet to adapt to more styles…
The “Table data” sheet:
This sheet is used to generate random things (anything that you may think of in fact) with the random generator found in the main menu.
To add a new list or edit an existing list, you can simply use the integrated database editor from the main menu. There’s no limit to the number of items you can add to a list (unless you hit the row limit that is greater than 1000000!)
-->This list would be named “ExampleList” in the generator and Monomate may drop 5 times more than Antidote.
The sheet is built using Office 2013 x64. It “should” be compatible with other versions down to 2007 (not 100% sure about that though). The code is almost complete [for the fantasy sheet], almost anything may be edited without even touching the sheet, excepted random tables.
NEVER TOUCH THE GREYED OUT CELLS IN "BATTLE SHEET", "PARTY DATA", "MONSTER DATA" as they contain formulas!!!
Note1: This is NOT a character sheet designer, I mean if you want to build a character, you’ll have to put their stats manually from a user form. It’s a tool to help DM keeping the data at hand for everyone around the table, not a character creation tool!
Note2: When loading, the sheet will modify the excel option "decimal separator", but will restore your default value when you close the workbook.
Note3: Sometime, hyperlinks added through the campaign editor may cause an error and refuse to open the file. If you have this problem you can use the file “RéinitialisationHypertexteOffice.reg” and add it to your registry, hyperlinks will then work for all your office documents.
Notes about the D&D version: For now some things are not done automatically, but are WIP.
Current list is:
(1) Only cover, concealment, marked and ongoing damage must be tracked manually!
This list may seem huge, but I’m going to improve the sheet and implement more features!
The sheet is a bit of a mess and contains things that are not from 4th edition (I could have made them hidden but I’m a bit lazy) as I want the sheet to be easily customized for another system with only a few tweaks (after all d20 is always d20, only data usage change between editions but underlying mechanics remains similar). That way one (or myself if I get to this point) can change the sheet with ease to work with Pathfinder/Starfinder or 3.5/5th editions.
Technical digression [Fantasy sheet only]:
For those interested without digging into the code:
Contrary to the PSIV game, there are 6 “base” stats rather than only 4 (For = Strength, Con = Constitution, Dex = Dexterity, Agi = Agility, Int = Intelligence, Men = Mental/Wisdom). I’ve done that to have an easier time converting the sheet to D&D rules.
Other 4 stats are derived from the base (Att = Attack, Mag = Magic power, Def = Defense, Mdf = Magic defense)
Strength improves damage (whatever the weapon) and chance to hit/critical in melee.
Constitution improves defense, thus reduce damage taken
Dexterity improves chance to hit/critical at range
Agility improves the chance to avoid being hit and contributes to initiative
Intelligence increase tech/magic damage
Mental increase magic defense
The various stats column in the sheet are as follow:
“Stat name”: The total stat that is used with formula (the greyed out cell)
“B-Stat name”: The base (natural for monsters) stat, the one that increase by leveling up
“E-Stat name”: The bonus/malus from equipped items
“M-Stat name”: The temporary bonus/malus from spells (always reset to 0 when you start the combat manager)
Factor is the element resistance for the character (I’ve added 24 of them just for completeness)
The main formula used for hitting things is:
1d100 + (offense stat + bonus) x factor – (defense stat + bonus) vs target/critical value
The main formula for damage is:
Min damage = ((offense stat + bonus) x factor – (defense stat + bonus)) x (100 - variance)
Max damage = ((offense stat + bonus) x factor – (defense stat + bonus)) x (100 + variance)
Minimum damage is set to 1 unless factor is set to 0 or negative. A negative factor will reverse the effects (boost will damage and damage will boost), a factor of 0 will negate damage/effectiveness of the attack.
Skill check formula is (skill rank + stat *1/4 + bonus) vs opposing skill against a target value
If you choose “NoSkill” value is set to 0, it means it only checks for selected skill against target value.
Roll between 1 and half the best character’s agility from the sheet and add the number to agility (thus a character with twice the agility of another one should always be first). Ties check against agility stat, then dexterity stat, then roll 1d100.
v1.0: initial release.
v1.1: corrected minor bug in monster editor, minor changes in some Userform layout.
v1.2: improvement for the various editors, added character and stats editor, improved readme, dice roller and combat manager now show in non-modal form, allowing you to switch between the two with both open.
v1.3: removed inability to exit Userforms by using the regular close option (you can now quit by clicking on the “X”), experiments with resizing Userforms with various screen resolutions (those that are on laptops will have problems otherwise), added some tooltips.
v1.4: corrected a bug with combat manager not initialized as it should the first time it was run, cleanup of vba code making the file smaller, disabled again exit from Userforms by using the “X” button as it could cause unexpected (though small) bugs it should not be a problem anymore with the resizing with smaller resolutions.
v1.5: added option to select multiple targets at once for an action in the combat manager, minor bug correction in various menus.
v1.6: caught a bug that could crash a macro while refreshing dead monster stats, ability to edit character class with editor (even though you can level up by choosing another one you’re free to do so).
v1.7: added ability to sort data tables through editor menu (“misc” tab), added a basic campaign editor/viewer with map/picture display, added more tooltips to the various menus, allowed the dice roller history to scroll if text is getting too long.
v1.8: added ability to add a full directory as hyperlink (choice when set up between file or directory), added external module to import pictures as png without crashing the macro, added ability to link pictures to characters and monsters in the editor, added picture display in the combat manager next to info display, minor bugs correction (the bug that was crashing the sheet while checking dead monster was still there :/), greatly improved the speed of the macro that check for dead monsters after an action (it was slow if there was dead monsters about 2-3s, now is almost instant).
v1.9: added “halve action value on failure” option to the combat manager, checking the option “action has critical range” allows for critical failure too (set at 10% of critical success target value), reversed the action formula (it’s still the same, just rolling higher=better now), a natural roll of 1 is always a critical failure/failure, a roll of 100 is always a critical success/success, more detailed message box for the result of an action, added option to check for skills, power/skills editor and equipment editor now also works for database entries, made sheet easier to share on another computer by checking for alternate path for hyperlinks, pictures and maps (The sheet will first search the file or directory in the set path, then search in \data\pictures for pictures, \data\maps for maps and \data\docs for hyperlinks, starting from the workbook location. If all fails it will last search at the root of the workbook location. This allows the sheet to be used on an usb stick with the links still working by putting the files with the workbook), removed some unused values, additional tweaks here and there.
v1.10: corrected a critical bug with power/skills editor, new design for power/skills editor.
v1.11: small correction to attack formula, correction with damage formula for negative/null factor, minor bugfixes.
v1.12: code optimization, minor bugfixes.
v1.13: added “filter only available powers” in combat manager and power editor, minor bugfixes.
v1.14: PRNG now use Mersenne twister (vba translation by Jerry Wang) instead of vba built-in PRNG, implemented a Heroquest dice roller (because I play Heroquest too sometimes).
D&D sheet was introduced here!!
v2.0: corrected a very minor bug in code, removed unused variables from code, added party perception check in combat manager, and finally added a second sheet tweaked for D&D 4th edition (WIP for now, expect some bugs!!). D&D sheet only: ammunition can now be tracked automatically when using a ranged weapon, added corresponding equipment slot, better descriptions in combat manager.
v2.1: as always fast update after the first release, corrected some critical bugs in hit and damage formulas, implement and proficiency bonus are now added automatically when making an action that include them, damage formula now accounts for critical hits, much better descriptions for attack and damage rolls, the D&D sheet “should” now be at least useable!
v2.2: improved macro speed when deleting individual characters from the sheet with encounter editor, corrected a bug in power editor, corrected implement not adding damage, some status effects now add their bonus automatically, level up menu more adapted to D&D style, added secondary attack on failure to handle reliable powers, skill check penalty from armor/shield is now applied automatically.
v2.3: added “Delay” as an action type, creature added/removed with main menu when combat manager is open are now automatically added/removed from initiative list, added ability to add skills and feats through database editor (feats are just for display and/or reference), minor bugs corrected.
v2.4: added ability to edit random tables directly from the database editor, added error checker if invalid values are entered in database editor, corrected a bug in character editor (fortitude and reflex stats were inverted).
v2.5: replaced initiative and information labels in combat manager with scrollable textboxes (in case the text becomes too long for the box), added some of the DD4 sheet improvements to the PS4 sheet, corrected some new bugs.
v2.6: added a language selector with French/English choice (more translations may be added by looking at the sheet “Translation data”, just add a column after the two already there with your language name and translated strings below, if a string is not translated it will default to the original string in the worksheet [mixed English/French], note that translation is not completely done for now and tooltips/comboboxes will probably remain in their original form), corrected damage so that hp can go negative up to bloodied value, added a “Quick Notes” button.
v2.7: corrected a bug with encounter editor (a character and a monster could have the same name and could mess with the way name are handled by the code), more strings translated.
v2.8: added “About” tab, added backpack listing to the equipment menu, more error checking for quick encounter editor, corrected an error in the skill check and ability check formulas, added a very beta feature in MapTool import (it “should” allow to import tokens from a MapTool campaign file with a little setup: add a property called “DM-Tools” to your NPC tokens property sets in MapTool campaign preference, associate this property with a string referencing a monster in the database of the spreadsheet and save your campaign file).
v2.9: import from MapTool will now display the name of the map where the token is located to help choose which token you want to import, corrected a bug in the campaign file parser (token/object that have been edited at least once even with an empty “DM-tool” string would appear in the list).
v2.10: import from MapTool are now sorted by name and by map, tokens marked as “Dead” won’t show in the list, character editor now displays a full character summary to get an overview, possibility to add gold individually using pp/gp/sp/cp, skill list in information display now includes ability/level bonuses and armor penalty and always display at least the perception skill (even if character has no ranks), two handed weapons now add +1 damage automatically, recharge powers for monsters are now handled automatically, tracking of healing surges and action points, reminder for ongoing damage, status immunities, and possibility to add a tooltip for almost anything in the database (characters, creatures, items, powers and feats). Tooltips allow for copy/paste a full stat block and will be displayed when your mouse hover over the picture of a character in the combat manager. It allows to go through each power, item and feat the character knows and display information about them too! And as always bugfixes (many of them)!!
v2.11: added a basic stat block parser in monster editor (very basic for now, will only parse Name, Level, Hit points, Ability scores, Defenses, Initiative, Speed and XP value) that will work with English pdf, corrected some minor bugs with database editor and tooltip display, added an autosave option (can be disabled) that will save the workbook every time you save a change in the database editor.
v2.12: started hidden modifications to allow for 3rd edition/Pathfinder conversion, added a reminder to combat manager that allows to set notes to popup at a later round (by typing in the form “round:note”), improved performance of some frequently used functions (and removed some limits in the same time, now loading menus and editing data even with more than 25000 items in each database won’t take more than a few seconds), added an option to setup backup equipment for characters allowing to quickly switch a weapon during combat, updated manual with more recent screenshots.
v2.12bis: OK not really an update, but having some time to lose (and inspired by the Arena game made on excel) I started to build a game with the PS4 sheet… It’s only in a very beta state but for those who love the universe and turn by turn battles it contains a basic AI, random battles, useable items, etc… No story yet but getting the basic framework done and at least “playable” for the first few levels! Everything is fully compatible with DM-tools and don’t alter the basic functionality of the sheet (it’s just a sort of add-on). Item and monster data must still be added and edited to build something coherent, but it should give a good overview of what’s possible.
v3.0: added DD3 version (very beta for now, still need to convert/implement more features for the sheet to be useable), new form for dice roller that saves custom dice expressions entered (up to 6 custom expressions and 4 custom ranges to roll from), replaced manual damage/healing button in combat manager with manual edit (allow to quickly edit temporary stats bonus and status of selected character, for manual combat handling), handling of sneak attack damage. WIP files included in specific folder (unstable).
V3.2: DD4 version only improvements, bug fixes and tweaks (Note that import power does not work for now!)
You may sent comments, criticism, suggestions, bug report or anything to email@example.com ("about DM-sheet" in the mail subject).
Screenshot for DM-tools:
Screenshot for PS4-beta game: