extrapolate

  1. M

    vb to extrapolate data

    I have 2 columns of data in a workbook and need to use VBA to extrapolate data. I need to know Y for any value of X. I have a range of known Ys and Xs (as below) The trickier part here might be that I only want to consider part of the range to extrapolate (say the middle 6 values) - I then to...
  2. J

    Extrapolation over random blank lines

    Hi all, Please can someone offer me some help? I have the following spreadsheet (below), it has a list of times with associated ranges, the time goes up in seconds (every second) the range if whatever is measured, always decreasing. Every so often the data received is missed, so I get blank...
  3. E

    Difference/Spread Between Two Line Graphs when Data does not Align.

    Hello! I have a set of data similar to the following plotted as two line graphs, one for Bills, one for Coups. As any point between the two lines, I would like to find the difference. The problem is, the data points do not line up, so I can't simply take Coups minus Bills. Is there a way to...
  4. Prevost

    Linearly Extrapolate between values in column

    Hi There. So I have my Supply and Return water temperatures and I am trying to calculate heat output using those. However, the temperature values do not have any decimal points which is an issue. What I want to do is basically linearly extrapolate to obtain temperature values with decimal...
  5. M

    Estimating Remaining Sales Given a Target (dynamic chart)

    Hello, I would be grateful if someone could help me create formulas to determine how much sales must happen going forward (for the month, or for the quarter or for the year) based on YTD, Week-to-date or Quarter-to-date actual sales and a target for the year, the month, and the quarter (simple...

Some videos you may like

This Week's Hot Topics

  • Finding issue in If elseif else with For each Loop
    Finding issue in If elseif else with For each Loop I have tried this below code but i'm getting in Y column filled with W005. Colud you please...
  • MsgBox Error
    Hi Guys, I have the below error show up when i try and run my macro in File1 but works fine if i copy and paste the same code into file2. [ATTACH...
  • CELL FORMAT - IF CONDITION
    My Cell Format is [B]""0.00" Cr". [/B]But in the cell, it is showing 123.00 for editing. (123 is entry figure). (Data imported from other...
  • Show numbers nearly the same
    Is this possible. I have a number that can change very time eg 0.00001234 Then I have a lot of numbers 0.0000001, 0.0000002, 0.00000004...
  • Please i need your help to create formula
    I need a formula in cell B8 to do this >>if b1=1 then multiply ( cell b8) by 10% ,if b1=2 multiply by 20%,if=3 multiply by 30%. Thank you in...
  • Got error while adding column and filter
    Got error while adding column and filter In column Z has some like "Success" and "Error". I want to add column in AA if the Z cell value is...
Top