Making a Dungeons and Dragons Encounter Tool in Excel - An XLOOKUP Tutorial

Figuring out how to make encounters in Dungeons and Dragons the right amount of difficulty is a challenging task, involving a lot of trial and error and repetitive math.

Here I walk you through creating an Excel spreadsheet to automate this process, starting with a blank file and ending with a fully-functional and well-polished tool.

This spreadsheet relies heavily on XLOOKUP, so this tutorial is a great way to learn more about how XLOOKUP works, including some of its advanced features.

Additional Links:

Rockstar Excel website: https://rockstarexcel.com/

Newsletter for free tips on using Excel to make your life easier: https://rockstarexcel.com/newsletter/

Book a free consultation: https://rockstarexcel.com/book-a-free-discovery-session/

Download the spreadsheet from this video: https://rockstarexcel.com/wp-content/uploads/Rockstar-Excel-D-and-D-Encounter-Tool.xlsx

Video on cleaning data: https://youtu.be/hkeruv3T_lI
Videos on using absolute, relative, and mixed references to build complex spreadsheets extremely quickly:
Part 1: https://youtu.be/PrJF5cYKZhk
Part 2: https://youtu.be/hotGj69Qd-w
Video on Center Across Selection: https://youtu.be/XTWT8vGQIG0

Instructions on building combat encounters from D&D Beyond: https://www.dndbeyond.com/sources/basic-rules/building-combat-encounters

Видео Making a Dungeons and Dragons Encounter Tool in Excel - An XLOOKUP Tutorial канала Rockstar Excel