I am trying to make a spreadsheet to track encounters, and I was wondering if there is any generalised formula I can use to calculate the average XP for any given Challenge Rating, or is it like character advancement in that there's no consistent formula for such? An approximation is also acceptible.
dnd-5e – How to Convert Monster CR into XP: Generalized Formulas
cr-calculationdnd-5eexperience-points
Best Answer
As pointed out by @Thomas Markov, the Table is odd. I expect that some rounding occurred to get "nice-looking" numbers, plus 2 bumps (CR 17 and CR 20), and an acceleration of the growth rate post CR 20.
I expected a quadratic curve, so went looking for an arithmetic progression, and it turns out that the increase from CR N-1 to CR N is close to
(N + N / 7) * 100
, using integer division on N.With an offset, we get the closed formula for CR N:
.
From there on, however, the formula gets much more inaccurate:
I suppose further tweaks to the formula could fold in the bumps and increase in rate of growth, but at this point I expect it's just easier to use a look-up table.