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
| Runescape Bits & Bytes https://www.rsbandb.com/forums/ |
|
| RuneScape Leveling in Excel https://www.rsbandb.com/forums/viewtopic.php?f=14&t=79173 |
Page 1 of 1 |
| Author: | Earth [ June 26th, 2010, 8:47 am ] |
| Post subject: | RuneScape Leveling in Excel |
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. |
|
| Author: | Adbot [ June 26th, 2010, 8:47 am ] |
| Post subject: | Register and login to get these in-post ads to disappear |
| Author: | Aquw VettelS 776 [ June 26th, 2010, 8:51 am ] |
| Post subject: | Re: RuneScape Leveling in Excel |
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
|
|
| Author: | Earth [ June 26th, 2010, 8:56 am ] |
| Post subject: | Re: RuneScape Leveling in Excel |
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! |
|
| Author: | Bryan [ June 26th, 2010, 9:29 am ] |
| Post subject: | Re: RuneScape Leveling in Excel |
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. 
|
|
| Author: | Aquw VettelS 776 [ June 26th, 2010, 9:44 am ] |
| Post subject: | Re: RuneScape Leveling in Excel |
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. |
|
| Page 1 of 1 | All times are UTC - 7 hours |
| Powered by phpBB® Forum Software © phpBB Group http://www.phpbb.com/ |
|