Multiple Interpolations

tonii4516

New Member
Joined
Jun 22, 2018
Messages
13
Can someone explain to me the easiest way to implement mulitple interpolations, I have two unknowns that depend on temperatures given and cfm given. Total I am given 3 different temperatures and one cfm which makes it complicated to find a way to make a formula to find this unknown values when the temperatures aren't the exact ones given in the table.
It sounds confusing and it because it is. Any help will be greatly appreciated.
 

Excel Facts

What is the last column in Excel?
Excel columns run from A to Z, AA to AZ, AAA to XFD. The last column is XFD.
Can you show an example of your table, and a sample input and expected output? You can use the HTML Maker in my signature to show a screen print of your spreadsheet, or just use the table tool in the Advanced editor (although that can be more tedious).
 
Upvote 0
Capture.PNG
 
Upvote 0
Sorry, you can't upload a picture directly to the forum. You can upload it to a file-sharing service, then include the link. However, even that is not recommended, since no can can copy/paste your sample data to work with. If you just include a picture, people will have to manually type in your data to work with, and many people won't take the time. That's why the other 2 methods I suggested are preferred.
 
Upvote 0
Hello, I have optimize the question in a way I can provide an example. I copy the image to a file in google drive. Hopefully, it will work if not i'll find another way to share the table.

How to get an interpolation for multiple variables. CFM, Outdoor Temperature, Wet Temperature, and Dry Temperature are given. Trying to get an interpolation for Total Capacity and Sensible Ratio. So an example would be, what is the Total Capacity and Sensible ratio when CFM=1100, Wet Temperature is 65F, Dry Temperature is 78F, and Outdoor Temperature is 100F.

https://drive.google.com/file/d/1bMHU0VTt_TJbF6sCR_626zCeU2UYimUR/view?usp=sharing
 
Upvote 0
I'm not sure what to tell you. First, your image is a picture, which can't be copied into a test workbook. You're not going to find many people who will spend the time to type all that in. Second, I've done 1-d interpolation, and 2-d interpolation. 4-d interpolation in theory should just merely be an extension of that. However, in looking at your table, the functions of the various dimensions are clearly not linear. That might be tolerable in a 2-d table, but I suspect that any formula I could come up with would likely be wildly inaccurate in some places. I'll think about it a bit more and let you know if I come up with something.
 
Upvote 0
I must be a bit of a masochist, because I figured it out. I hope that's your exact table, since if it's not, adapting it will be tricky. But here goes:

Excel 2012
ABCDEFGHIJKLMNOPQRSTUV
Wet Temperature
Total CapacitySensible ratioTotal CapacitySensible ratioTotal CapacitySensible ratioTotal CapacitySensible Ratio
Dry TemperatureDry TemperatureDry TemperatureDry Temperature
cfmkBtuh75°F80°F85°FkBtuh75°F80°F85°FkBtuh75°F80°F85°FkBtuh75°F80°F85°F
63°F
67°F
71°F
CFMTotal Capacity
Wet Temp
Dry TempSensible ratio
Outdoor Temp
Total CapacitySensible ratio
Dry TemperatureDry Temp
kBtuhkBtuhSensible Ratio
Outdoor TempsDry TempWet Tempcfm

<colgroup><col style="width: 25pxpx"><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col></colgroup><thead>
</thead><tbody>
[TD="align: center"]1[/TD]

[TD="align: right"][/TD]
[TD="align: center"]Outdoor Temperature[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]

[TD="align: center"]2[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: center"]85°F[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]95°F[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]105°F[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]115°F[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]

[TD="align: center"]3[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"][/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"][/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"][/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"][/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]4[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]5[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]6[/TD]
[TD="align: right"][/TD]

[TD="align: right"][/TD]

[TD="align: right"][/TD]

[TD="align: right"][/TD]

[TD="align: right"][/TD]

[TD="align: center"]7[/TD]

[TD="align: right"]960[/TD]
[TD="align: right"]36.5[/TD]
[TD="align: right"][/TD]
[TD="align: right"]0.69[/TD]
[TD="align: right"]0.85[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]34.3[/TD]
[TD="align: right"][/TD]
[TD="align: right"]0.7[/TD]
[TD="align: right"]0.87[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]32[/TD]
[TD="align: right"][/TD]
[TD="align: right"]0.71[/TD]
[TD="align: right"]0.89[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]29.5[/TD]
[TD="align: right"][/TD]
[TD="align: right"]0.72[/TD]
[TD="align: right"]0.92[/TD]
[TD="align: right"]1[/TD]

[TD="align: center"]8[/TD]
[TD="align: right"][/TD]
[TD="align: right"]1200[/TD]
[TD="align: right"]38.6[/TD]
[TD="align: right"][/TD]
[TD="align: right"]0.75[/TD]
[TD="align: right"]0.94[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]36.3[/TD]
[TD="align: right"][/TD]
[TD="align: right"]0.77[/TD]
[TD="align: right"]0.97[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]33.9[/TD]
[TD="align: right"][/TD]
[TD="align: right"]0.78[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]31.5[/TD]
[TD="align: right"][/TD]
[TD="align: right"]0.8[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]

[TD="align: center"]9[/TD]
[TD="align: right"][/TD]
[TD="align: right"]1440[/TD]
[TD="align: right"]40.4[/TD]
[TD="align: right"][/TD]
[TD="align: right"]0.82[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]38.2[/TD]
[TD="align: right"][/TD]
[TD="align: right"]0.83[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]36[/TD]
[TD="align: right"][/TD]
[TD="align: right"]0.86[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]33.6[/TD]
[TD="align: right"][/TD]
[TD="align: right"]0.89[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]

[TD="align: center"]10[/TD]

[TD="align: right"]960[/TD]
[TD="align: right"]39[/TD]
[TD="align: right"][/TD]
[TD="align: right"]0.54[/TD]
[TD="align: right"]0.67[/TD]
[TD="align: right"]0.81[/TD]
[TD="align: right"]36.8[/TD]
[TD="align: right"][/TD]
[TD="align: right"]0.54[/TD]
[TD="align: right"]0.68[/TD]
[TD="align: right"]0.83[/TD]
[TD="align: right"]34.4[/TD]
[TD="align: right"][/TD]
[TD="align: right"]0.54[/TD]
[TD="align: right"]0.69[/TD]
[TD="align: right"]0.85[/TD]
[TD="align: right"]31.8[/TD]
[TD="align: right"][/TD]
[TD="align: right"]0.54[/TD]
[TD="align: right"]0.7[/TD]
[TD="align: right"]0.88[/TD]

[TD="align: center"]11[/TD]
[TD="align: right"][/TD]
[TD="align: right"]1200[/TD]
[TD="align: right"]41.1[/TD]
[TD="align: right"][/TD]
[TD="align: right"]0.57[/TD]
[TD="align: right"]0.73[/TD]
[TD="align: right"]0.9[/TD]
[TD="align: right"]38.8[/TD]
[TD="align: right"][/TD]
[TD="align: right"]0.58[/TD]
[TD="align: right"]0.74[/TD]
[TD="align: right"]0.93[/TD]
[TD="align: right"]36.3[/TD]
[TD="align: right"][/TD]
[TD="align: right"]0.58[/TD]
[TD="align: right"]0.76[/TD]
[TD="align: right"]0.96[/TD]
[TD="align: right"]33.6[/TD]
[TD="align: right"][/TD]
[TD="align: right"]0.59[/TD]
[TD="align: right"]0.78[/TD]
[TD="align: right"]0.99[/TD]

[TD="align: center"]12[/TD]
[TD="align: right"][/TD]
[TD="align: right"]1440[/TD]
[TD="align: right"]42.7[/TD]
[TD="align: right"][/TD]
[TD="align: right"]0.61[/TD]
[TD="align: right"]0.79[/TD]
[TD="align: right"]0.99[/TD]
[TD="align: right"]40.2[/TD]
[TD="align: right"][/TD]
[TD="align: right"]0.62[/TD]
[TD="align: right"]0.81[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]37.5[/TD]
[TD="align: right"][/TD]
[TD="align: right"]0.62[/TD]
[TD="align: right"]0.83[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]34.9[/TD]
[TD="align: right"][/TD]
[TD="align: right"]0.63[/TD]
[TD="align: right"]0.86[/TD]
[TD="align: right"]1[/TD]

[TD="align: center"]13[/TD]

[TD="align: right"]960[/TD]
[TD="align: right"]41.4[/TD]
[TD="align: right"][/TD]
[TD="align: right"]0.4[/TD]
[TD="align: right"]0.53[/TD]
[TD="align: right"]0.65[/TD]
[TD="align: right"]39.1[/TD]
[TD="align: right"][/TD]
[TD="align: right"]0.4[/TD]
[TD="align: right"]0.53[/TD]
[TD="align: right"]0.65[/TD]
[TD="align: right"]36.7[/TD]
[TD="align: right"][/TD]
[TD="align: right"]0.38[/TD]
[TD="align: right"]0.53[/TD]
[TD="align: right"]0.67[/TD]
[TD="align: right"]34.1[/TD]
[TD="align: right"][/TD]
[TD="align: right"]0.38[/TD]
[TD="align: right"]0.53[/TD]
[TD="align: right"]0.68[/TD]

[TD="align: center"]14[/TD]
[TD="align: right"][/TD]
[TD="align: right"]1200[/TD]
[TD="align: right"]43.7[/TD]
[TD="align: right"][/TD]
[TD="align: right"]0.42[/TD]
[TD="align: right"]0.56[/TD]
[TD="align: right"]0.71[/TD]
[TD="align: right"]41.3[/TD]
[TD="align: right"][/TD]
[TD="align: right"]0.41[/TD]
[TD="align: right"]0.57[/TD]
[TD="align: right"]0.72[/TD]
[TD="align: right"]38.7[/TD]
[TD="align: right"][/TD]
[TD="align: right"]0.41[/TD]
[TD="align: right"]0.57[/TD]
[TD="align: right"]0.74[/TD]
[TD="align: right"]36.1[/TD]
[TD="align: right"][/TD]
[TD="align: right"]0.4[/TD]
[TD="align: right"]0.58[/TD]
[TD="align: right"]0.75[/TD]

[TD="align: center"]15[/TD]
[TD="align: right"][/TD]
[TD="align: right"]1440[/TD]
[TD="align: right"]45.3[/TD]
[TD="align: right"][/TD]
[TD="align: right"]0.43[/TD]
[TD="align: right"]0.6[/TD]
[TD="align: right"]0.77[/TD]
[TD="align: right"]42.8[/TD]
[TD="align: right"][/TD]
[TD="align: right"]0.43[/TD]
[TD="align: right"]0.61[/TD]
[TD="align: right"]0.79[/TD]
[TD="align: right"]40.1[/TD]
[TD="align: right"][/TD]
[TD="align: right"]0.43[/TD]
[TD="align: right"]0.61[/TD]
[TD="align: right"]0.81[/TD]
[TD="align: right"]37.3[/TD]
[TD="align: right"][/TD]
[TD="align: right"]0.42[/TD]
[TD="align: right"]0.63[/TD]
[TD="align: right"]0.83[/TD]

[TD="align: center"]16[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]17[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]18[/TD]

[TD="align: right"]1100[/TD]
[TD="align: right"][/TD]

[TD="align: right"]35.5125[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]19[/TD]

[TD="align: right"]65[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]20[/TD]

[TD="align: right"]78[/TD]
[TD="align: right"][/TD]

[TD="align: right"]0.761083[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]21[/TD]

[TD="align: right"]100[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]22[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]23[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"][/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]24[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]25[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]26[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"][/TD]
[TD="align: right"]75[/TD]
[TD="align: right"]80[/TD]
[TD="align: right"]85[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]78[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]27[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]33.15[/TD]
[TD="align: right"][/TD]
[TD="align: right"]0.705[/TD]
[TD="align: right"]0.88[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]0.81[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]34.375[/TD]
[TD="align: right"]0.7185[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]28[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]35.1[/TD]
[TD="align: right"][/TD]
[TD="align: right"]0.775[/TD]
[TD="align: right"]0.985[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"][/TD]

[TD="align: right"][/TD]
[TD="align: right"]0.901[/TD]
[TD="align: right"][/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]36.325[/TD]
[TD="align: right"]0.7915[/TD]
[TD="align: right"][/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]29[/TD]
[TD="align: right"]85[/TD]
[TD="align: right"]95[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]37.1[/TD]
[TD="align: right"][/TD]
[TD="align: right"]0.845[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"][/TD]
[TD="align: right"]75[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0.938[/TD]
[TD="align: right"][/TD]
[TD="align: right"]63[/TD]
[TD="align: right"]63[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]37.975[/TD]
[TD="align: right"]0.839[/TD]
[TD="align: right"][/TD]
[TD="align: right"]960[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"][/TD]

[TD="align: center"]30[/TD]
[TD="align: right"]95[/TD]
[TD="align: right"]105[/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]35.6[/TD]
[TD="align: right"][/TD]
[TD="align: right"]0.54[/TD]
[TD="align: right"]0.685[/TD]
[TD="align: right"]0.84[/TD]
[TD="align: right"][/TD]
[TD="align: right"]80[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0.627[/TD]
[TD="align: right"][/TD]
[TD="align: right"]67[/TD]
[TD="align: right"]67[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]1200[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"][/TD]

[TD="align: center"]31[/TD]
[TD="align: right"]105[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]37.55[/TD]
[TD="align: right"][/TD]
[TD="align: right"]0.58[/TD]
[TD="align: right"]0.75[/TD]
[TD="align: right"]0.945[/TD]
[TD="align: right"][/TD]
[TD="align: right"]85[/TD]
[TD="align: right"][/TD]
[TD="align: right"]0.682[/TD]
[TD="align: right"][/TD]
[TD="align: right"]71[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]1440[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]32[/TD]
[TD="align: right"]115[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]38.85[/TD]
[TD="align: right"][/TD]
[TD="align: right"]0.62[/TD]
[TD="align: right"]0.82[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]0.74[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]33[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]37.9[/TD]
[TD="align: right"][/TD]
[TD="align: right"]0.39[/TD]
[TD="align: right"]0.53[/TD]
[TD="align: right"]0.66[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]0.474[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]34[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]40[/TD]
[TD="align: right"][/TD]
[TD="align: right"]0.41[/TD]
[TD="align: right"]0.57[/TD]
[TD="align: right"]0.73[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]0.506[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]35[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]41.45[/TD]
[TD="align: right"][/TD]
[TD="align: right"]0.43[/TD]
[TD="align: right"]0.61[/TD]
[TD="align: right"]0.8[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]0.538[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

</tbody>
Sheet2

[TABLE="width: 85%"]
<tbody>[TR]
[TD]Worksheet Formulas[TABLE="width: 100%"]
<thead>[TR="bgcolor: #DAE7F5"]
[TH="width: 10px"]Cell[/TH]
[TH="align: left"]Formula[/TH]
[/TR]
</thead><tbody>[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]E18[/TH]
[TD="align: left"]=FORECAST(B18,OFFSET(Q27:Q28,U29,0),OFFSET(T29:T30,U29,0))[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]E20[/TH]
[TD="align: left"]=FORECAST(B18,OFFSET(R27:R28,U29,0),OFFSET(T29:T30,U29,0))[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]B29[/TH]
[TD="align: left"]=VLOOKUP(B21,A29:A32,1)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]C29[/TH]
[TD="align: left"]=(MATCH(B21,A29:A32)-1)*5[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]B30[/TH]
[TD="align: left"]=INDEX(A29:A32,MATCH(B29,A29:A32,0)+1)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]C30[/TH]
[TD="align: left"]=C29+5[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]D27[/TH]
[TD="align: left"]=(OFFSET(C7,0,$C$30)-OFFSET(C7,0,$C$29))/($B$30-$B$29)*($B$21-$B$29)+OFFSET(C7,0,$C$29)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]K29[/TH]
[TD="align: left"]=MATCH(B20,J29:J31)-1[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]K30[/TH]
[TD="align: left"]=K29+1[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]L26[/TH]
[TD="align: left"]=B20[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]L27[/TH]
[TD="align: left"]=FORECAST($B$20,OFFSET(F27:G27,0,$K$29),OFFSET($F$26:$G$26,0,$K$29))[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]O29[/TH]
[TD="align: left"]=LOOKUP(B19,N29:N31)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]P29[/TH]
[TD="align: left"]=(MATCH(O29,N29:N31,0)-1)*3[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]O30[/TH]
[TD="align: left"]=INDEX(N29:N31,MATCH(O29,N29:N31,0)+1)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]P30[/TH]
[TD="align: left"]=(MATCH(O30,N29:N31,0)-1)*3[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]Q27[/TH]
[TD="align: left"]=(OFFSET(D27,$P$30,0)-OFFSET(D27,$P$29,0))/($O$30-$O$29)*($B$19-$O$29)+OFFSET(D27,$P$29,0)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]R27[/TH]
[TD="align: left"]=(OFFSET(L27,$P$30,0)-OFFSET(L27,$P$29,0))/($O$30-$O$29)*($B$19-$O$29)+OFFSET(L27,$P$29,0)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]U29[/TH]
[TD="align: left"]=MATCH(B18,T29:T31)-1[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]U30[/TH]
[TD="align: left"]=U29+1[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]



The D27 formula should be copied to D27:D35 and to F27:H35. The L27 formula should be copied to L28:L35, Q27 copied through Q29, R27 though R29. All other formulas are individual, all other cells are constants copied from other places in your table.

Each section is an individual interpolation. The D26:H35 section interpolates the outdoor temperature table from the 4 subtables above. L27:L35 uses the dry temperature to interpolate the sensible ratio from F27:H35. Q27:Q29 interpolates capacity from wet temperature, R27:R29 interpolates sensible ratio from wet temperature. Finally E18 and E20 interpolate ratio and capacity from Q27:R29 and cfm.

So put your values in B18:B21, and the results will be in E18 and E20. If you use a value at one of the upper extremes, like a wet temperature of 71 degrees, use 70.9 instead or the formulas will fail.

Hope this helps! If you send me your email address in a PM, I'll send you a copy of the workbook.
 
Upvote 0

Forum statistics

Threads
1,223,958
Messages
6,175,637
Members
452,663
Latest member
MEMEH

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top