Results 1 to 7 of 7

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
    Seeker jpr73's Avatar
    Join Date
    Apr 2011
    Location
    France
    Posts
    15
    Articles
    0
    Hi,
    See attached the expect result of dt value for any degree between 30 and 90 degrees
    Hope this will helps
    Attached Files Attached Files

  3. #3
    Quote Originally Posted by jpr73 View Post
    Hi,
    See attached the expect result of dt value for any degree between 30 and 90 degrees
    Hope this will helps

    Hi jpr73

    thanks for you prompt responce. loooking at you spreadsheet when I change db to 2 inches at 53 degrees, I get N/A. it does not interpolate dt for 2 inches. The example i have for a 2 inches at 53 degree gives out a dt value of 15 inches with the db of 31 inches. the answer does not have to be exact but around 15 inches.

    Once again thanks for help.

    Regards
    justmcd

  4. #4
    Seeker jpr73's Avatar
    Join Date
    Apr 2011
    Location
    France
    Posts
    15
    Articles
    0
    Hi,
    Sorry I misunderstand your post : interpolate in 2 dimensions
    See attached the result with any angle and base depth
    Note : the formulas are not working for the extreme value of angle and base depth
    Hope this helps
    Best regards
    Attached Files Attached Files

  5. #5
    Quote Originally Posted by jpr73 View Post
    Hi,
    Sorry I misunderstand your post : interpolate in 2 dimensions
    See attached the result with any angle and base depth
    Note : the formulas are not working for the extreme value of angle and base depth
    Hope this helps
    Best regards
    Hi jpr73

    Thanks a million. You are a life saver.

    Thanks once again

    Regards

  6. #6
    Hi jpr73,
    I need your kind help for a similar problem, please could you tell me how to modify the spreadsheet to interpolate between similar set of curves (centrifugal compressor performance curves . I can upload the curve data which is flow vs head for different speeds (70% -105%) i need to know head for a arbitrary speed and know flow (x-axis).
    Thanks and regards,
    Arun

    Click image for larger version. 

Name:	map.jpg 
Views:	66 
Size:	57.9 KB 
ID:	1234

  7. #7
    Seeker jpr73's Avatar
    Join Date
    Apr 2011
    Location
    France
    Posts
    15
    Articles
    0
    Hi aeroarun,
    It would be better to create a new post.
    Please upload the curve data and formula, I'm not the only one who can solve the problem
    Best regards

Posting Permissions

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