log in or register to remove this ad

 

Resource icon

Zio's ChimeraTool for campaign management 20.08.12

No permission to download
What is this?

Last modification:
18 August 2020 (changelog at end of file, please read!)

See the included manual in pdf for how to use this!


Link to the tool: DM tools

Link to optional pictures: Optional-Pictures

Links to my other tools for RPG (templates for magic set editor):

MSEtemplate152dpi

MSEtemplate254dpi

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). The sheet then evolved and a second one was created for D&D 4th edition. The sheet is perfectly useable for other systems as well if you use it only to store campaign infos and data or use the random generator and dice roller. Now a 5th edition version is currently available as a WIP.


New version scheme: Starting from the end of 2019, the version now use the English date as version number (YY.MM.DD). Readme is not updated as often as before and some added features and bugfixes may not be listed here. See full changelog at the end of this file!


File history:

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.12b: 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!), improved random generator.

V++: Version number now use last modified English date, Translations for worksheet controls and a couple more strings, Ability to edit number of failed death saving throw from combat manager (edit character/target), Reworked some utility functions, Minor bugfixes, Random generator may now read pictures from table in addition to standard text and may now simulate a card draw from a table (by removing picked element) via an option box. HQ and DD3 sheets are “almost” functional now. Ability to set wound, fear and exhaustion levels as a house rule (no effect on stats but act as a reminder that a player is wounded for example if you use that kind of house rule), Ability to add powers that are not in the database to a character (can be useful to track number of uses manually if you don’t use automated attacks and don’t want to enter each power in the database), other minor enhancements…

20.02.08: Quick correction for a bug in the campaign viewer, removed ability to erase essential values from the database (Empty item, Manual attack power, NoSkill skill, etc…), included updated PS4 script file in the package.

20.03.07: Some functions modifications and bugfixes in file linking (version number not changed in sheet!)

20.03.09: Very quick bug catch, Ability to view more than 5 characters and to view enemy group in “Party View” userform

20.03.12: Quick update for encounter management

20.03.17: Added “Game master apprentice” cards support in random generator

20.04.02: New parameters for random table generation allowing to do complete sentences including random elements from tables! Other small improvements here and there and more bugfixes…

20.05.12: WIP sheet for D&D 5th edition included. Contains monsters, spells and items from compendium already imported (monsters with armor are unequipped in the database so AC is only dex modifier, monsters with natural armor have their full AC). Combat manager is NOT up-to date for 5th edition but combat may be handled manually (by editing stats directly from userform!). Many options from previous editions still remain (such as damage reduction, healing surge, action points, etc…) but are not problematic (they may even be useful if you use house rules ;) ). If you get a crash while using compendium viewer check that the file “c:\windows\system32\msxml6.dll” exists in your system directory!). File was built with office 2013 x64, and thus I do not ensure it will be compatible with previous versions of Excel (even if I take care to declare some API functions for 32bits as well as 64bits systems). All others functions such as dice roller, saves, campaign viewer, etc…. should work as previous versions!

20.05.17: Spellbook now imported for compendium creatures, correction for the ‘randomize hp” formulas of compendium creatures (removed con bonus from hd), range set for ranged weapons imported from compendium. Still a WIP as battle formula won’t work, but anyway useable to track hp and initiative during battle as well as much more! Added compendium option for 4th edition too (dirty reading from sql files but anyway allow access to useful info from a simple menu).

20.06.08: D&D 5th edition improvements only: all skill modifiers and resistances are now imported for compendium creatures, new and simplified combat manager reading actions and saving throw directly from monsters stat block (if monster has no stat block can still enter numbers manually though) include damage type and resistance (still wip)

All sheets: minor bugfix preventing unwanted crash in equipment manager, added ability to sort and rename chapters from a campaign in campaign editor, new version of campaign editor and viewer with tabs, added ability to zoom map in campaign view (with slider or directly by double click on the map, you may move zoomed map by clicking on a point), new simpler design for encounter manager, added ability to draw “Encounter building cards” in random generator for those who own the product.

20.06.15: Random generator from table now may now use expressions like the solo generator tables: [XdY] or [X@Y] to roll dice or range, optional parameter “h” to hide expression in result ([1d6] will return “1d6: random number”, [1d6h] will return “random number” only), [T] to roll on another table (must use a name with no space!!) ([T]Name will roll once from the table “Name” resulting in “Name: rolled item” , [T:1d6]Name will roll 1d6 items from table “Name” resulting in “Name: result1, result2,…”, [T:h] or [T:1d3h] will hide the table name displaying only results), some creatures spellbook were not correctly imported in DD5-sheet (fixed), reverted xml library to v3.0 (more compatibility for compendium view), quick update of the manual pdf.

20.06.18: Added buttons to roll individual skill and saving throws in DD5 sheet, small corrections to a few imported creatures in DD5 sheet, new update to the manual, playerview file now reads DD5 campaigns too.

20.06.26: DD5 sheet: now includes a very basic random Character/NPC generator [idea and some data taken from Emirikol’s random character generator sheet, permission was asked via MP, only basic data is included for now] and allows to save generated data to the database, the generator is NOT finished for now!!!

DD4 sheet: ability to import directly from a Masterplan creature exported to html, importing monster from a Masterplan statblock in the data editor will now import skills and resistances, implemented a basic attack parser that will parse from an imported statblock (parse attack vs defense and damage, only Masterplan statblocks will work!)

Some minor bugs and incoherencies were also corrected

20.07.15: Corrected some very minor bugs, ability to sort tables alphabetically in data editor (DD4 only for now), very little improvement in DD5 combat manager, most userform that don’t edit data are now useable in a non-modal form allowing to have multiple screens open (random generator, campaign view, dice roller, etc…), started working on a random hex generator (data still to add!), added more data to random solo generator (you can add your own data just look how tables are done!)

20.08.12: Improvement in random generator speed and formulas (new options to roll from other tables, new format is [R:number:eek:ptions]Tablename to roll on a table or just [number:eek:ptions] to roll dices and return a value. Number represents a number or a dice roll (in the form XdY+Z or X@Y). Available options are h (hide formula and table name), p, u or l (proper, upper or lower case formatted result). Implemented a name generator using Markov algorithm (possibility to add you own lists as always, sample lists taken with permission from Wolph42’s generator in MapTools!). Spell slot tracking in DD5 sheet, spell filtering in spellbook editor, option to quickly add multiple creatures at once from encounter editor, option to randomize spellbook of creatures from encounter editor in DD5 (beta), other minor improvements and corrections I’ve lost track of!


Still To-do: ability to edit resistances for 5th edition, level-up algorithm, rework data editor for 5th edition and remove old unused parameters, change status effect to those in use in 5th edition, allow for data translation too.

Contact:

You may sent comments, criticism, suggestions, bug report or anything to krevett62@hotmail.com ("about DM-sheet" in the mail subject), or discord krevett62#8809.

A few screenshots:
Image1.png

Image2.png

Image3.png

Image4.png

Image5.png
Author
Zio_the_dark
Downloads
15
Views
1,988
First release
Last update
Rating
0.00 star(s) 0 ratings

Latest updates

  1. 20.08.12 update

    Improvement in random generator speed and formulas (new options to roll from other tables, new...
  2. Seeking help for random tables

    Hi if some of you have taken a look at this, there's some random generator in there that allows...
  3. New improvements

    Corrected some very minor bugs, ability to sort tables alphabetically in data editor (DD4 only...
Top