Advanced (?) Mathematic problem

[Unknown_Warrior]

Basically, I need to make a formula for x with this data.

 

 

 

y is a variable given.

 

 

 

y = (x+300*2^(x/7))/4

 

 

 

Any ideas? The best I got still had x in the formula.

[manitstinks]

Is this like your math homework...?

[josh181830]

Wrong forums, I could've done that last year, but now I forgot Logs :lol:

[Unknown_Warrior]

No, it's RuneScape level and experience calculator.

 

 

 

y = experience for next lvl (once rounded down) and x = current lvl-1

 

 

 

I want to Excel to calculate my current lvl based on xp I put in.

[craven_range]

You can't remove X from this formula, as x is varliable, and y is dependant on x.

[wioneo]

You can't remove X from this formula, as x is varliable, and y is dependant on x.

 

 

 

Not true, well probably not true, the fact that he's mixed up X and Y doesn't really effect the equation. You could always just switch them back to their proper relationship if it made you feel better. I can't really remember all the rules dealing with "not base 2" radicals, and I would much rather avoid putting in the effort to remember it...you could always just use Tip.It's calculators :thumbsup: or maybe someone will show you the source coding, it would most likely have this function embedded in it somewhere, or maybe they took the easy way out and made the XP for each level a constant, I have no idea, and this is a run on sentence so I'll just leave now...

[Unknown_Warrior]

You can't remove X from this formula, as x is varliable, and y is dependant on x.

 

 

 

So it's impossible to get an x= formula?

[wioneo]

You can't remove X from this formula, as x is varliable, and y is dependant on x.

 

 

 

So it's impossible to get an x= formula?

 

 

 

You can call the variables whatever you want :wall: Might as well switch out all the X's and Y's in your initial post to avoid confusion.

[craven_range]

You can't remove X from this formula, as x is varliable, and y is dependant on x.

 

 

 

So it's impossible to get an x= formula?

 

 

 

It's possible to get x = (your level)

 

But somewhere you are giong to have to input your xp, leaving you with x=y.

 

Do you understand that? You are always going to have an x and a y

[wioneo]

You can't remove X from this formula, as x is varliable, and y is dependant on x.

 

 

 

So it's impossible to get an x= formula?

 

 

 

It's possible to get x = (your level)

 

But somewhere you are giong to have to input your xp, leaving you with x=y.

 

Do you understand that? You are always going to have an x and a y

 

 

 

Well he could fix that by making the variable that represents his current level based off of the variable that he sets to his experience, so then he would only have 1 input variable. I'm betting that the XP values follow a formula, but I honestly never bothered to find it out.

[craven_range]

He only has one input variable and one output variable, i believe? Or am i reading it wrong.. how can you have two input varliables without an output variable?

 

If you do have two input variables, then of course you can get rid of one of them.

[Unknown_Warrior]

Let's just put it like this:

 

 

 

I need a formula you can enter in excel that calculates your current level for you based on an input xp amount.

[craven_range]

Let's just put it like this:

 

 

 

I need a formula you can enter in excel that calculates your current level for you based on an input xp amount.

 

 

 

Ok, no problem. I'll make you one now. Your formula is giving the xp amount of a certain level. For example, if i input X = 99 i get y = 1,356,729 your formula isn't quite accurate, you need to times it by ten. I'll play with it a bit.

[Unknown_Warrior]

I know, all it does know is calculate the xp needed to lvl up. It uses B*+formula, however this is dependant on former equations and isn't dynamic.

 

 

 

I only just realised that. #-o

[josh181830]

I'll solve it for you if you can make the equation look better (I can't tell some parts about it)

 

 

 

Is this what it is supposed to look like?

 

 

 

(x + 300) (2^(x/7))

 

y = --------------------------

 

4

 

 

 

Like above? Is that the equation? And you are trying to solve for x right?

[Xena_Dragon]

Why not create a

and use the data found in the XP Table to lookup the level ?

[craven_range]

Why not create a

and use the data found in the XP Table to lookup the level ?

 

 

 

True. I can't be bothered watching that link, but you could use Excel web queries to get your xp and level. I do it with a few automated G E Calculators i have. If you can't work it out i'll gladly set the sheet up for you, if you pm me.

[xSxqPowerx]

Apparently I've forgotten how to math, or I would do it for you.

[Unknown_Warrior]

Why not create a

and use the data found in the XP Table to lookup the level ?

 

 

 

That guy gets on my nerves...

 

 

 

Also, the VLOOKUP messes up when using 2 tables consisting solely of numbers. I can't download his guides either.

 

 

 

Edit: Nevermind, perfected it.

[craven_range]

Why not create a

and use the data found in the XP Table to lookup the level ?

 

 

 

That guy gets on my nerves...

 

 

 

Also, the VLOOKUP messes up when using 2 tables consisting solely of numbers. I can't download his guides either.

 

 

 

Edit: Nevermind, perfected it.

 

 

 

Data>Web Queries>Put in web adress>Go>Import

 

:D

[green9090]

Apparently I've forgotten how to math, or I would do it for you.

 

Same lol. I know I could have done it in about a minute when I was a Sophomore in high school... but that was four years ago now. I should learn math again >_>

[J35u5_M4]

What does the ^ means :x

[green9090]

What does the ^ means :x

 

"To the," like an exponent (5^2 = five to the second = 5x5 = 25). If you don't know what that means, it means you have no hope of solving the problem. You undo it with logarithms... somehow.

[craven_range]

What does the ^ means :x

 

"To the," like an exponent (5^2 = five to the second = 5x5 = 25). If you don't know what that means, it means you have no hope of solving the problem. You undo it with logarithms... somehow.

 

 

 

5^2=5x5=25

 

5^3=5x5x5=125

 

5^4=5x5x5x5=625

 

 

 

and so on..

 

 

 

normally, it's notated as 5^n, and you can solve for n with the forumla

 

n=ln(1+FV*i/R)/ln(1+i)

 

 

 

it means you have no hope of solving the problem.

 

 

 

There is no problem to solve

[green9090]

There is no problem to solve

 

Oh, sorry, is "I don't know how to plug this formula into excell" not a problem? Because, you know, I thought that was the whole point of the thread.