Results 1 to 5 of 5

20060615, 19:41 #1
 Join Date
 May 2005
 Posts
 124
 Thanks
 0
 Thanked 0 Times in 0 Posts
Extrapolating data in a table (excel 2000)
Hi excel masters
I have a table, which I am want to fill out with some numbers at different points

20060615, 21:42 #2
 Join Date
 Jul 2002
 Location
 Pittsburgh, Pennsylvania, USA
 Posts
 11,225
 Thanks
 14
 Thanked 342 Times in 335 Posts
Re: Extrapolating data in a table (excel 2000)
I do not understand what you are trying to calculate exactly or what your spread sheet does.
Could you elaborate on what you are trying to do?
Steve

20060616, 03:46 #3
 Join Date
 May 2005
 Posts
 124
 Thanks
 0
 Thanked 0 Times in 0 Posts
Re: Extrapolating data in a table (excel 2000)
Yes I hav made this attached spread sheet color coded to help explain my issue.
What i have is a yellow area.
This is mostly calculated.
in column C I type the starting point of fluid
used per stage.
so for stage 1 :starts at 0 to 100
stage 2 100 to 1000
column D is simply the amount of fluid in the stage
Column E is the loading of chemical to concentrate the fluid gallons per thousands
Column F is the the calculate amount of chemical that should be pumped
column G is the cum of each stage
Column H
Here I take a measurement at each stage from the storage tank
for stage 1 100 bbl of fluid is pumped to I look at the measurement
on the side of the storage container an see the fluid level is at
993.
You will notice in C3 a starting guage. This is the volumn of fluid started with.
so its a constant.
ex.
Stage 1 = the fluid is level at 993 after 100 bbl of fluid.
995 gal  993 gal = 2 gal
this is Column I
At column J I am taking the variance of what was pumped vs what was calculated
so 2.1 gal was calculated but I pumped only 2.0 so .1 gal is the difference
then in column K I am getting the % variance.
WHat I am trying to do now is the table F4:H4
Each row is the Job broken down in quarters. This will Kinda give me a number that is useful to tune the pumps
so I want to be able to know where the chemicals were at 1/4 through the Job, half way through and 3/4 through vs the calculate
so some how I need to break the job down to quarters and calculate the amount of chemical used at quater and the the variance to what is calculated
But I am unsure of how to calculate this correctly with excel.
I hope this can help explain.

20060616, 03:47 #4
 Join Date
 May 2005
 Posts
 124
 Thanks
 0
 Thanked 0 Times in 0 Posts
Re: Extrapolating data in a table (excel 2000)
<P ID="nt"><font size=1>(No Text)</font>

20060616, 10:58 #5
 Join Date
 Jul 2002
 Location
 Pittsburgh, Pennsylvania, USA
 Posts
 11,225
 Thanks
 14
 Thanked 342 Times in 335 Posts
Re: Extrapolating data in a table (excel 2000)
Is this what you are after?
I moved F2:F4 to E2:E4 (and actually put the numbers 0.250.75 in them formatted ast 1/43/4)
In F2:F4 I put what Stage was completed (calculated from the values in G2:G4)
I changed the values G2:G4 to use the value in E2:E4.
The values in H2:H4, I get from interpolation (not extrapolation) since they are within the range of the data. This doesn't show much since at those fractions your variance were all 0. It will be different if the actual and calculated will vary...
The calculation uses TREND to interpolate how far (eg) the calculated gallons at 1/4 of max, is in that stage and estimates the number in the actual cum gallons in that stage would be.
Steve