Multiple Interpolations

[tonii4516]

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.

 

[Eric W]

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).

 

[tonii4516]

 

[SpillerBD]

Interpolation or iteration?
Circular references may seem like a non-no, but Excel can do them. If your calculations seems impossible without cicurlar reference, proceed with it and turn on the iterative calcaulations through the Options.
https://support.office.com/en-us/ar...recision-73fc7dac-91cf-4d36-86e8-67124f6bcce4

 

[Eric W]

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.

 

[tonii4516]

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

 

[Eric W]

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.

 

[tonii4516]

https://drive.google.com/open?id=1l-EeW-ux4uE2QOQgC9dbjFtlRMwGm2M-

Here is the link for a table that can be open in google sheets.

I hope that helps.

Thank you for your time.

 

[Eric W]

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

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V
Wet Temperature
Total Capacity	Sensible ratio	Total Capacity	Sensible ratio	Total Capacity	Sensible ratio	Total Capacity	Sensible Ratio
Dry Temperature	Dry Temperature	Dry Temperature	Dry Temperature
cfm	kBtuh	75°F	80°F	85°F	kBtuh	75°F	80°F	85°F	kBtuh	75°F	80°F	85°F	kBtuh	75°F	80°F	85°F
63°F
67°F
71°F
CFM	Total Capacity
Wet Temp
Dry Temp	Sensible ratio
Outdoor Temp
Total Capacity	Sensible ratio
Dry Temperature	Dry Temp
kBtuh	kBtuh	Sensible Ratio
Outdoor Temps	Dry Temp	Wet Temp	cfm

<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.

 

[tonii4516]

Thank you Erick,

My email is emilianoayala4516@gmail.com