Logarithmic Growth Version 2

 

Choose First Step: L1
Choose Last Step: LL
Choose # of Steps: N
R = LL – L1
i = increment 1 to N
Y = (i – 1) / (N – 1)
Value(i) = ({(10 ^ [log10(101) * Y]) – 1} * R * .01) + L1
Example
L1 LL N R
0.25 30 10 29.75
i y Value
1 0.000 0.25
2 0.111 0.45
3 0.222 0.78
4 0.333 1.34
5 0.444 2.27
6 0.556 3.82
7 0.667 6.40
8 0.778 10.73
9 0.889 17.95
10 1 30.00

Manually:

L1 LL N R log10(101)
0.25 30 10 29.75 2.0043
a i 1 2 3 4 5 6 7 8 9 10
b i-1 0 1 2 3 4 5 6 7 8 9
c b/(N-1) 0 0.11 0.22 0.33 0.44 0.56 0.67 0.78 0.89 1
d c*2.0043 0 0.2 0.5 0.7 0.9 1.1 1.4 1.6 1.8 2
e 10^d 1 1.7 2.8 4.7 7.8 13 21.7 36.2 60.5 101
f e-1 0 0.7 1.8 3.7 6.8 12 20.7 35.2 59.5 100
g f*R*.01 0 0.2 0.5 1.1 2.0 3.6 6.2 10.5 17.7 29.8
h g+L1 .25 0.5 0.8 1.3 2.3 3.8 6.4 10.7 18 30

 

Advertisements

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s