Need help from someone with crazy math skills...

Nytmare said:

It does?

Click to expand...

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.

Guyanthalas said:

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.

Click to expand...

Not exactly. Level 11 and Level 21 are 'special' and screw any mathmatically clean progression.

Jhaelen said:

Not exactly. Level 11 and Level 21 are 'special' and screw any mathmatically clean progression.

Click to expand...

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.

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))

Guyanthalas said:

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.

Click to expand...

True - I was thinking about xp required to gain the next level.

Excel? I thought you wanted math skills. Today, I calculated the max height an arrow with a rope tied to it can be fired straight up (roomate asked me to do it for a game he's running on PbP). That's math skills, boyo.

Eldorian said:

Excel? I thought you wanted math skills. Today, I calculated the max height an arrow with a rope tied to it can be fired straight up (roomate asked me to do it for a game he's running on PbP). That's math skills, boyo.

Click to expand...

unless there is something straight up for said arrow to stick into... would it ever really be wise to do that? =)

Eldorian said:

Excel? I thought you wanted math skills. Today, I calculated the max height an arrow with a rope tied to it can be fired straight up (roomate asked me to do it for a game he's running on PbP). That's math skills, boyo.

Click to expand...

Projectile motion isn't exactly complicated math.

MadLordOfMilk said:

Projectile motion isn't exactly complicated math.

Click to expand...

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.

Eldorian said:

Excel? I thought you wanted math skills. Today, I calculated the max height an arrow with a rope tied to it can be fired straight up (roomate asked me to do it for a game he's running on PbP). That's math skills, boyo.

Click to expand...

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...