RuneScape Leveling in Excel

Earth · **Posted:** June 26th, 2010, 8:47 am

I am going for 99 Crafting and I want Excel to tell me what level I will be in magic(as I am charging my own orbs) when I am done.
I have how much exp I will have when I'm done and stuff finished, that bit was easy. The only problem I'm having is getting it to accept that x=y when x= all of the values of say, level 90, which would be all of the numbers from 5,346,332 to 5,902,830 and y is the level, in this example 90.
Any ideas? If this doesn't make sense tell me and I will try to clarify.

Adbot · **Posted:** June 26th, 2010, 8:47 am

Aquw VettelS 776 · **Posted:** June 26th, 2010, 8:51 am

I think I understand you correctly that you want a formula to calculate level from experience? Good news- this formula exists. Bear with me and I'll dig it out

Earth · **Posted:** June 26th, 2010, 8:56 am

Aquw VettelS 776 wrote:

I think I understand you correctly that you want a formula to calculate level from experience? Good news- this formula exists. Bear with me and I'll dig it out

That is EXACTLY what I need!

Bryan · **Posted:** June 26th, 2010, 9:29 am

So is THAT why you were ***** to get me online yesterday?

I know Excel well, but, like I've said before. If something DOES exist, you don't need me for it.

Aquw VettelS 776 · **Posted:** June 26th, 2010, 9:44 am

http://rsdo.net/RSDOnline/Guides/Experience%20formula.html

At the top is the complete formula. However because Excel cannot handle calculus, you'll have to make do with an approximate formula:

experience = (level + 300 * 2^level/7) / 4

Using a language like PHP, you're able to use calculus, thus achieving very accurate calculations.