I have a table in Excel:
If I inserted rows to show every hour between 36 and 68, what equation would extrapolate the corresponding Project Value values? An example of the new table would be:
I figured out an equation to extrapolate from 0 hours to 36. It would be:
But this equation will not work when the base Project Value is not 0 (going from 0 to 10000). In my case, the base Project Value is 10000 (going from 10000 to 25000). I assume I somehow need to have a multiplier in the equation to convert down to a base of 0. Probably so it can be a percentage 0 to 100.
Project Value | Hours |
10000 | 36 |
25000 | 68 |
If I inserted rows to show every hour between 36 and 68, what equation would extrapolate the corresponding Project Value values? An example of the new table would be:
Project Value | Hours |
10000 | 36 |
? | 37 |
? | 38 |
? | etc. |
? | 66 |
? | 67 |
25000 | 68 |
I figured out an equation to extrapolate from 0 hours to 36. It would be:
Project Value | Hours |
=(0/36)*10000 | 0 |
=(1/36)*10000 | 1 |
=(2/36)*10000 | 2 |
etc. | etc. |
=(34/36)*10000 | 34 |
=(35/36)*10000 | 35 |
10000 | 36 |
But this equation will not work when the base Project Value is not 0 (going from 0 to 10000). In my case, the base Project Value is 10000 (going from 10000 to 25000). I assume I somehow need to have a multiplier in the equation to convert down to a base of 0. Probably so it can be a percentage 0 to 100.