Help Creating a d&d EXP tracker

Hiya! I’ve been using Coda to sort my d&d characters for d&d 3.5 for some time now- but I’m absolutely hopeless with tables. They’re the bane of my existance, and partly why I came to Coda instead of Exel, becuase it’s a bit more user friendly. I understand the concepts, but don’t know the terminoligy to get what I want.

What I’m essentially trying to do here is have this:

A table “tracker” where I can input the value of EXP we get each session. I can add things like date for record keeping, but this shouldn’t effect anything else.

From there, I have it summerized as “Current EXP,” which shows the Sum. This is where I get lost.

What I want is for the Sum total of Current EXP to be compared against the “EXP” chart (the one on the left) to tell me exactly what level that equals. This seems like a really easy thing to do in theory, but I don’t know the theory. (sob)

So, in this example, with the three entries in the tracker I have, the Sum being “10,392,” If I have a “Current Level:” Formula, it should say “5”, as per the EXP chart on the left.

That’s the main thing I’m after

Beyond that, I also want to know if I can make a “Progress tracker” between the level I’m on and the next level (So the amount of EXP required between two levels). Again, it feels like it might be a very simple formula I’m after, I just don’t know it. (Please ignore the 753 in there. It doesn’t mean anything. In theory, right now this should be a scale between 10,000 and 15,000, where the total is 10,392 at the moment.)

Any help you can offer would be amazing, whether it be more thorough or just a video you can direct me to to learn this specific solution. Thanks in advance!!

1 Like

It’s much easier for me and others to help you if you share your doc with us. We can take a look into the formulas and everyone can make a copy of the document so we don’t get in the way of each other.

Best regards
Jannis

3 Likes

If you ensure that the EXP table is sorted by level, then get all levels that have a minimum exp greater than your current, and then chose the first row, you’ll get the `Next Level Row`:

``````EXP.Sort(True, Level).Filter([Min. EXP] > [Current EXP]).First()
``````

From there, getting your current level row is much easier:

``````EXP.Filter(Level=[Next Level Row].Level - 1).First()
``````

Once you have your current, and next level rows, you access their `Min. EXP` values to construct your xp bar

Oh, thank you, Jannis, that feels obvious in retrospect, haha.

Here’s the link! any help you can offer would be amazing, since I’m a little clueless right now.

I really wish this made more sense to me, I’m so sorry, thanks for your help, though.

The Current EXP: text that have there at the moment is just that- and it’s next to a ‘table summary’, so this formula isn’t picking up on it. I’m not sure if making a new table or something similar would be better?

Otherwise, these formulas you’ve written, are they to make a new row in the existing table? I’m sorry, it’s probably obvious with context to people who know what they’re doing.

I’ve linked the actual page above if you don’t mind having a look, but no stress either way. Thanks again.

No worries, you’ll get the hang of it!

These formulas can be anywhere, in a canvas formula (like your current exp), in a table column, or a button that creates a new row, it depends on your desired setup.

If you add a name to your current exp you can re-use it, I assumed you had named it to `Current EXP`

Then add the `Next Level Row` canvas formula below

Then the `Current Level Row`

Then your xp bar could be something like this for the max value

And add a formula for the value of the xp bar

2 Likes

This was amazing!! Thank you so so much for taking the time to explain it in detail for me! I feel like I’ve already learned a bit from it, haha. With this, going forth and adventuring will be so much easier.

Only question now: is there a way to make the “progress bar” show the difference between current level and next level in it’s text? Or maybe just another formula to show how much EXP is “needed” to get to the next level.

Simplest way would be to add another column to the right of the xp bar, with the same formula as we use for the max value