Guyanthalas
First Post
Yes, but its hard to express mathmatically.
Starting with a baseline of lvl 1 = 100xp, it increases once a level.
2-5 by 25, 6-10 by 50....
Every 4 levels the increase doubles.
Need help from someone with crazy math skills...
- Thread starter JVisgaitis
- Start date
Yes, but its hard to express mathmatically.
Starting with a baseline of lvl 1 = 100xp, it increases once a level.
2-5 by 25, 6-10 by 50....
Every 4 levels the increase doubles.
Not exactly. Level 11 and Level 21 are 'special' and screw any mathmatically clean progression.
Guyanthalas
First Post
11? That conforms just fine with the progression, but you have a point about 22. While it still follows the "bracket of 4" concept, it does not double the prior gain, until you get to level 26.
MadLordOfMilk
First Post
Working on an equation. For the first 21 levels it goes up by..
25 * 2^int[(x-1)/4]
Where x is the level. So going to 2nd level it goes up by 25, going to 6th level it goes up by 50, etc. The only problem is the easiest way to utilize this equation would be sigma notation but I'm not familiar with excel formulas so I'm not sure how useful that'd be in terms of a spreadsheet.
I have to play with it a tiny bit more but I'm getting somewhere. From 21->22->23->24->25 it goes up by 950 instead of 800 then it jumps to going up by 2000 instead of 1900, but then it follows a 2^x growth again (2000 then 4000 then 8000 then 16000 per level), though it's "disconnected" from the first because it's all cumulative. So, it's probably gonna end up as a piecewise function.
::EDIT::
OK so technically this doesn't work for level one but it'll cover levels 2-21. Too lazy to mess with all the numbers just so it gets a proper value for lv1, someone else can do that
But here's the equation for the first half of the chart.
Keep in mind the brackets [] mean greatest integer. You should be able to modify this to fit the lv25-40 section, and 22-25, though I'm 99% sure there's no way to make it all one (non-piecewise) function.
::edit2::
BTW, the equation entered into a TI-84+ is written as follows, I'm not sure how much it'd help with excel: Y1=100+sum(seq(2^int((X-2)/4)*25,X,2,X,1))
25 * 2^int[(x-1)/4]
Where x is the level. So going to 2nd level it goes up by 25, going to 6th level it goes up by 50, etc. The only problem is the easiest way to utilize this equation would be sigma notation but I'm not familiar with excel formulas so I'm not sure how useful that'd be in terms of a spreadsheet.
I have to play with it a tiny bit more but I'm getting somewhere. From 21->22->23->24->25 it goes up by 950 instead of 800 then it jumps to going up by 2000 instead of 1900, but then it follows a 2^x growth again (2000 then 4000 then 8000 then 16000 per level), though it's "disconnected" from the first because it's all cumulative. So, it's probably gonna end up as a piecewise function.
::EDIT::
OK so technically this doesn't work for level one but it'll cover levels 2-21. Too lazy to mess with all the numbers just so it gets a proper value for lv1, someone else can do that
But here's the equation for the first half of the chart.Keep in mind the brackets [] mean greatest integer. You should be able to modify this to fit the lv25-40 section, and 22-25, though I'm 99% sure there's no way to make it all one (non-piecewise) function.
::edit2::
BTW, the equation entered into a TI-84+ is written as follows, I'm not sure how much it'd help with excel: Y1=100+sum(seq(2^int((X-2)/4)*25,X,2,X,1))
Attachments
Last edited:
True - I was thinking about xp required to gain the next level.
unless there is something straight up for said arrow to stick into... would it ever really be wise to do that? =)
MadLordOfMilk
First Post
Projectile motion isn't exactly complicated math.
Eldorian
First Post
Projectile motion isn't exactly complicated math.
Ah, but the mass of the arrow changes as it goes up, due to adding more rope =P
Also, I had to figure out the initial velocity of an arrow based on how far an arrow could be fired. (no where on the internet could we find the initial velocity of an arrow fired by an English longbow)
Sure, it's not complicated, but it was interesting.
Guyanthalas
First Post
In my defense, boyo
, I consider Excel at least semi-mathmatical. I cannot nor have ever been able to do basic arithmatic without screwing up royally. However, I usually have a good understand and grasp of formula and equations. So, I use Excel to do the arithmatic part, while i take care of the equation. Unless I post the equation on forums for others to take care of... 
