You are not logged in.
Hi All
I need to be able to calculate values with a given value starting value gradually increasing values with a specific number of iterations to a required cumulative total....
For example start at 1000, calculate 5 additional values gradually increasing from 1000 that will give a cumulative total of 7500 and will look on a chart as a curve.
This is not to say I want to gradually increase 1000 to end up at 7500, but to end with a cumulative total of 7500.
I'm stumped so any help would be really very much appreciated.
Thanks
Offline
I know I said I'd like a curve but even a straight diagonal line would be ok as long as the total is the cumulative requirement.
So for my simple example the result would be 1000, 1100,1200,1300,1400,1500.
Thanks
Last edited by domski74 (2010-05-26 07:06:58)
Offline
If you're ok with a straight line it's pretty easy. Let S be your starting value, T be your cumulative total, c be the number of additional values you're going to add, and x is the increment size. This will give you the equation
For your example we have S = 1000, T = 7500, and c = 5, so
Wrap it in bacon
Offline
If you're interested in a more curvy increase you can modify the equation to
So your example becomes
You then add x*1^2, x*2^2, x*3^2, etc. for each successive term. So the series for you example is 1000, 1000 + 27.2727... = 1027.2727..., 1000 + 4*27.2727... = 1109.0909..., 1000 + 9*27.2727... = 1245.4545..., 1436.3636..., 1681.8181...
Wrap it in bacon
Offline