Monthly Archives: September 2014

D&D (or Any Other Level-based game) Session Experience Calculator

Had a great family vacation, and got a 93 in my online Java class, but now I’m back to focusing on writing and game design. For example:

To compensate for my memory issues and to save a lot of work for non-mathophile GMs, I created a spreadsheet that will calculate how much experience I need to award each player at the end of each session of D&D Encounters.

Using it couldn’t be easier. Type the number of players into the appropriate box at the top of the sheet. Below that you will a list of all of the non-unique monsters that appear in the Tyranny of Dragons season of D&D Encounters. Each row below that is a separate encounter. Simply type in the number of each monster you used in the encounter, and the spreadsheet will do the rest.

It looks up the appropriate amount of experience points (XP) for that monster using the table on the “Data” tab (you can easily add your own, as long as the list doesn’t exceed 50 in all), then uses that to add up the total experience for the encounter. The XP totals for each encounter are added together, then divided by the number of players.

Since quest XP rewards are specified per player rather than as an amount to be subdivided, I have provided a space especially for those. Next to the blue box that tells you how much XP to give each player you’ll see a long red box. Put each quest reward in its own cell within that box, and the spreadsheet will add their sum to the amount in the blue box.

If you understand lookup tables, it is trivially easy to use more than 50 entries in the data table, but I was required to set a limit. I tried to allow more than 15 monsters on the table, but i kept getting an error telling me my formula was longer than OpenOffice could handle. If you know a way around the problem, I’d be happy to hear it.

Naturally, this can be used for any level-based game (as I will for for my HackMaster 5e campaign); it’s just pre-filled out with the monsters for DnD Encounters: Tyranny of Dragons.