D&D 5E Encounter Builder Spreadsheet

I use this spread sheet all the time. It is a fantastic tool for sizing up your encounters with your current player group. Built from the data in the DMG, it simply tells you if your plan will kill them or not--and what the XP would be. I like to open up the DMG and go through the monster lists and just plug in encounter levels to see how many of fill-in-the-blank they can take. The best tactic is to aim for "medium" and go from there. It takes away all of the headaches around constructing balanced encounters.

It is also scalable--so if you lose a player for a session you can easily recalculate your encounter and not enter a TPK. 

I'm not a programmer--this would be better served as a java script thing, but since I know Excel here you go. Also, there could be errors--if you find any, let me know. Enjoy!

P.S. Try not to type over any of the formula fields and leave the hidden columns hidden--they are just there to do math.