Results 1 to 7 of 7

Thread: Need to perform interpolation or forecasting for the remaining portion of the matrix

  1. #1

    Need to perform interpolation or forecasting for the remaining portion of the matrix



    Register for a FREE account, and/
    or Log in to avoid these ads!

    hi

    I am in a unique situation where i have to develop an excel where i have to update the remaining portion of the table based on the details already provided in the excel. Can anyone of you please take a look and let me know if any formula can help in developing the data for the missing cell. I am attaching the spreadsheet for your reference.

    Thanks,
    Amit
    Attached Files Attached Files

  2. #2
    Conjurer CheshireCat's Avatar
    Join Date
    Dec 2011
    Location
    Victoria, Canada
    Posts
    121
    Articles
    0
    Excel Version
    Microsoft Excel 2013

  3. #3
    Acolyte eisayev's Avatar
    Join Date
    Oct 2012
    Location
    Baku, Azerbaijan
    Posts
    33
    Articles
    0
    I am not sure but u can use =forecast() function

  4. #4
    Quote Originally Posted by eisayev View Post
    I am not sure but u can use =forecast() function
    forecast wont work as it can accomodate only 2 variables instead of 3 varaibales that i hav now...

  5. #5
    Acolyte eisayev's Avatar
    Join Date
    Oct 2012
    Location
    Baku, Azerbaijan
    Posts
    33
    Articles
    0
    Quote Originally Posted by dabohra View Post
    forecast wont work as it can accomodate only 2 variables instead of 3 varaibales that i hav now...
    Yesterday I used forecast function. I compared the results to known values and it seems right. There are different values in every row which means its value changing dependent on third variable (the numbers in column). I think it worths to try

  6. #6
    can u pls share the formula so that i can check if it is working fine....

  7. #7
    Acolyte eisayev's Avatar
    Join Date
    Oct 2012
    Location
    Baku, Azerbaijan
    Posts
    33
    Articles
    0
    Quote Originally Posted by dabohra View Post
    can u pls share the formula so that i can check if it is working fine....
    For example. For the first row (average floor area =1000)
    =FORECAST(F2;B3:E3;B2:E2)
    Follow the same logic for other rows

Posting Permissions

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