# Thread: Extrapolating data in a table (excel 2000)

1. ## 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

2. ## 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

3. ## 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.

4. ## Re: Extrapolating data in a table (excel 2000)

<P ID="nt"><font size=-1>(No Text)</font>

5. ## 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.25-0.75 in them formatted ast 1/4-3/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

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•