View Full Version : Because I hate updating all my numbers.

the_fencer0

2011-09-29, 09:13 AM

I'm working on a spreadsheet document that will autocalculate pretty much all the random bonuses a character gets. I'm getting stuck, however, on how to have it calculate my level from my current exp total.

From my limited understanding, it would have to be something like:

IF=(exp total = number between value x and value y), display level z

Then repeating the proccess to one incredibly long string of function code. Has anyone else done this before, or can help me get the right coding for it?

Djinn_in_Tonic

2011-09-29, 09:34 AM

I'm working on a spreadsheet document that will autocalculate pretty much all the random bonuses a character gets. I'm getting stuck, however, on how to have it calculate my level from my current exp total.

From my limited understanding, it would have to be something like:

IF=(exp total = number between value x and value y), display level z

Then repeating the proccess to one incredibly long string of function code. Has anyone else done this before, or can help me get the right coding for it?

For 3.5e D&D, the formula would be something as follows:

If Total XP = (sum of all levels [so 1 + 2 + 3 + 4+...] x 1,000), Level = Level + 1

That's just mathematical though...I don't use spreadsheet programs enough to know the conversion.

Emmerask

2011-09-29, 09:43 AM

level = floor[(1+sqrt(XP/125 + 1))/2]

http://en.wikipedia.org/wiki/Floor_function

Or if you want to know how far you have progressed in the level leave the floor function out then you get x.y level

in excel for example this would look something like this:

A2 := Floor(1+Sqrt((A1/125 +1)/2),1)

In A1 you put in the amount of xp, A2 then displays the level.

the_fencer0

2011-09-29, 10:17 AM

level = floor[(1+sqrt(XP/125 + 1))/2]

http://en.wikipedia.org/wiki/Floor_function

Or if you want to know how far you have progressed in the level leave the floor function out then you get x.y level

in excel for example this would look something like this:

A2 := Floor(1+Sqrt((A1/125 +1)/2),1)

In A1 you put in the amount of xp, A2 then displays the level.

So, if I put that into excel/open office calc, all I'd need to do is route A1 to the XP total, and make modifications or a specific system (99 levels, xp need to level is 500xlevel)?

Nohwl

2011-09-29, 12:31 PM

are you going to post it when you are finished?

the_fencer0

2011-09-29, 01:20 PM

are you going to post it when you are finished?

I was hoping someone had already accomplished it and would post it for me! Alas, it looks like I'll be doing the math myself. The current sheet I'm working on it is for the Returners FFRGP (hence needing a formula for 99 levels) but I'm sure I could easily adjust it to DnD.

Edit: I guess I misread this a bit -- I do hope to post the finalized sheet. The formula Emmerask put up is the right one, I just need to do some adjustments for the Returners and the DnD. Will be working on this tonight!

Lord Vampyre

2011-09-29, 02:40 PM

The D&D equation is: = floor(.5+sqrt(A1/500 + .25),1)

Unfortunately, I'm not familiar with the xp progression of the Returners FFRPG.

the_fencer0

2011-09-29, 02:50 PM

The D&D equation is: = floor(.5+sqrt(A1/500 + .25),1)

Unfortunately, I'm not familiar with the xp progression of the Returners FFRPG.

The XP needed for a level is up this formula:

level*500, so it looks something like this:

Level XP Required Total XP

1 0 0

2 500 500

3 1000 1500

4 1500 3000

5 2000 5000

6 2500 7500

7 3000 10500

8 3500 14000

9 4000 18000

10 4500 22500

so on and so forth.

Lord Vampyre

2011-09-29, 03:05 PM

The XP needed for a level is up this formula:

level*500, so it looks something like this:

Level XP Required Total XP

1 0 0

2 500 500

3 1000 1500

4 1500 3000

5 2000 5000

6 2500 7500

7 3000 10500

8 3500 14000

9 4000 18000

10 4500 22500

so on and so forth.

That makes it simple to convert from 3.5 then. Since D&D 3.5 requires a 1000 xp per level, thus changing the equation from A2/500 to A2/250 should be enough to convert it.

Giving you this equation: = floor(.5+sqrt(A1/250 + .25),1)

I hope that helps.

the_fencer0

2011-09-29, 03:16 PM

That makes it simple to convert from 3.5 then. Since D&D 3.5 requires a 1000 xp per level, thus changing the equation from A2/500 to A2/250 should be enough to convert it.

Giving you this equation: = floor(.5+sqrt(A1/250 + .25),1)

I hope that helps.

You have no idea how happy that makes me. ^_^

Thanks a bunch, Vampyre and Emmerask for the help! I'll be sure to submit the finished product (And make one for DnD to boot in the next few weeks, assuming someone hasn't done so already)

suhkkaet

2011-09-29, 03:17 PM

Giving you this equation: = floor(.5+sqrt(A1/250 + .25),1)

I hope that helps.

This is the equation. Tested it all the way to 99. (Was working it out on my own, but I was too slow!)

Powered by vBulletin® Copyright © 2020 vBulletin Solutions, Inc. All rights reserved.