Results 1 to 11 of 11
-
2011-09-29, 09:13 AM (ISO 8601)
- Join Date
- Sep 2011
Because I hate updating all my numbers.
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?
-
2011-09-29, 09:34 AM (ISO 8601)
- Join Date
- Nov 2006
- Location
- Stuck in a bottle.
- Gender
Re: Because I hate updating all my numbers.
Last edited by Djinn_in_Tonic; 2011-09-29 at 09:35 AM.
Ingredients
2oz Djinn
5oz Water
1 Lime Wedge
Instructions
Pour Djinn and tonic water into a glass filled with ice cubes. Stir well. Garnish with lime wedge. Serve.
-
2011-09-29, 09:43 AM (ISO 8601)
- Join Date
- Oct 2009
Re: Because I hate updating all my numbers.
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.Last edited by Emmerask; 2011-09-29 at 10:05 AM.
-
2011-09-29, 10:17 AM (ISO 8601)
- Join Date
- Sep 2011
-
2011-09-29, 12:31 PM (ISO 8601)
- Join Date
- Mar 2008
- Gender
Re: Because I hate updating all my numbers.
are you going to post it when you are finished?
-
2011-09-29, 01:20 PM (ISO 8601)
- Join Date
- Sep 2011
Re: Because I hate updating all my numbers.
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!Last edited by the_fencer0; 2011-09-29 at 02:25 PM.
-
2011-09-29, 02:40 PM (ISO 8601)
- Join Date
- May 2010
- Gender
Re: Because I hate updating all my numbers.
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.
-
2011-09-29, 02:50 PM (ISO 8601)
- Join Date
- Sep 2011
Re: Because I hate updating all my numbers.
-
2011-09-29, 03:05 PM (ISO 8601)
- Join Date
- May 2010
- Gender
Re: Because I hate updating all my numbers.
-
2011-09-29, 03:16 PM (ISO 8601)
- Join Date
- Sep 2011
Re: Because I hate updating all my numbers.
-
2011-09-29, 03:17 PM (ISO 8601)
- Join Date
- Aug 2011