XP calculation

Im making an auto-fill excel spreadsheet for D&D next, but Im having one hang up. I can not figure out the equasion for the XP table. Anyone know this?

A spreadsheet for what? Monsters?
A spreadsheet for what? Monsters?

No, Im making an excel spreadsheet for players. Including what level you are, and it auto populates the "XP for next level" section. I just cant figure out the XP equasion for D&DN.

I did work as an Excel expert for a while, so it'll hopefully be very fleshed out.

I have tried to derive a formula from that table, but it seems completely arbitrary. The gap between some levels is much bigger or smaller than others, as a linear or quadratic function it makes no sense.
I think your going to have to store the xp chart into an array. I don't think there is a formula.


The Redacted Files Podcast (http://www.theredactedfiles.com/)

Miskatonic Society semi-organized play (https://miskatonic-society.obsidianportal.com/)

My blog of random stuff

"It is a general popular error to imagine the loudest complainers for the publick to be the most anxious for its welfare" (Burke & Langford 154).

Link back to Product and General D&D Discussions -- because the website is bad.

Link back to Dungeon Master Help -- because the website is bad.

I think you're both right. I do think its arbitrary....It was just the way the numbers "looked" I thought there would be a table. Oh well, no biggie. Array time. Thanks for the look-see.

Were you ever successful at creating your spreadsheet?  Would you be willing to share?
Sign In to post comments