Interpolating between two graphs

justmcd

New member
Joined
Jan 3, 2012
Messages
39
Reaction score
0
Points
0
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
 

Attachments

  • Crotch plate.xlsm
    20.1 KB · Views: 25

Andy Pope

New member
Joined
Mar 22, 2011
Messages
43
Reaction score
0
Points
0
Location
London, England
Website
www.andypope.info
Excel Version(s)
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.
 

Attachments

  • Crotch plate2.xlsm
    22.4 KB · Views: 29
Top