expanding numbers?

[severndigital]

I'm not sure how to title this post. But this is what i want to do.

 

I need to take two variable numbers say 75 and 30000.

 

Then I need to step out the difference over a variable amount of cells. in

this case say 20 cells.

 

the output should look something like this.

 

75

80

93

123

178

320

...

...

...

30000

 

I'm not even really sure where to start other than the incoming variables.

 

thanks in advance.

 

 

 

 

 

[Orio]

I can't see the pattern in here:

75

80

93

123

178

320

...

...

...

30000

 

How do you want to get 80,93,123... ?

 

Orio.

[severndigital]

there is no pattern .. at least in my example.

 

all i want to do is input the following

 

$start = 75;

$end  = 30000;

$steps = 20;

 

I want the code to get from 75 to 30000 in 20 steps.

 

whatever the numbers may be.

 

 

The more I work on this, I think I will have to also input a rate or some sort of min / max for each cell increase.

 

for example

 

$minrate =  3;

$maxrate = 500;

 

this would state that when stepping out the numbers the current number cannot be less than 3 percent of the next number and no more than 500 percent of the preceeding number.

 

 

 

[Orio]

If you are using PHP5, you can simply use range() with the $step parameter.

If you have PHP<5, use one of the functions that can be found in the user's notes, in range().

 

Orio.

[btherl]

What you've stated is a range of solutions .. it's much easier to work with something precise.

 

For example:

 

1.  Spread the gaps so that each is exactly 1.7 times the previous gap, allowing for fractional numbers

2.  Round each fraction to the nearest number.

 

Then you'll get something which is within your tolerance range (well I haven't checked this, I just picked 1.7 at random), but is exactly specified, and therefore easy to program.

 

Does that kind of thing sound suitable?  If so, we can look at deriving a formula that takes start, end, number of steps, and the multiplier (1.7 in the example) and produces the steps.