Results 1 to 5 of 5
  1. #1
    2 Star Lounger
    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

  2. #2
    WS Lounge VIP sdckapr's Avatar
    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

  3. #3
    2 Star Lounger
    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.

  4. #4
    2 Star Lounger
    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>

  5. #5
    WS Lounge VIP sdckapr's Avatar
    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.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
  •