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