Results 1 to 2 of 2

Thread: Interpolating between two graphs

  1. #1

    Interpolating between two graphs



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

    Hi

    I have scatter graphs created from reading taken from one off the books used to design crotch plates ( see attached). I have managed to do interpolation for various dt values at angles given by each graph. However I have a problem interpolating for an angle other than the one given a different degrees (eg. 53 degrees). The ultimate solution that I am looking for is to get dt value for any degree between 30 and 90 degrees.

    Regards
    Justmcd
    Attached Files Attached Files

  2. #2
    Acolyte Andy Pope's Avatar
    Join Date
    Mar 2011
    Location
    London, England
    Posts
    41
    Articles
    0
    Excel Version
    2016
    You need to do the same thing with the angles as you have done with the db values.

    I extended/repeated the last column in the lookup table to avoid any errors in formula.
    Attached Files Attached Files
    Cheers
    Andy

    www.andypope.info

Posting Permissions

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