Cooling Performance Correction of Air-Conditioners and Air-to-Air Heat Pumps - See HVAC Simplified (Kavanaugh, 20

Input Requirements in Yellow Cells - Output in Blue Cells

This program corrects the nominal condition cooling performance of the air-conditioners and air-to-air pumps to actual condtions (outdoor ai
flow rate). Values used are those presented in Table 5.3 of HVAC Simplified. The program can be modified to correct the equipment perfor
changing the published nominal capacity, demand and air flow rate values in the 'MgfData' worksheet.

HPCap 3 Ton Input Cells Output Cells Do not type in Output Cells
Nominal Cooling to Actual Correction Factors
Performance @ Nominal Conditions OAT cfm wb db
TCNom 35.8 kBtu/h TC 1.000 0.998 0.934 NA
SCNom 26.4 kBtu/h SC 1.005 1.000 NA #VALUE!
kWNom 2.97 kW kW 1.002 0.999 0.972 NA
SHRNom 0.74
EERNom 12.1 Btu/w-hr Corrected Cooling Conditions and Performance
Cooling Nominal Conditions Actual Conditions (sea level) Performance @ Actual Conditions
EATNom 95 ºF OATemp 95 ºF (outdoor) TCcor 33.4 kBtu/h
cfmNom 1200 cfm AirFlow 1200 cfm (indoor) SCcor #VALUE! kBtu/h
DBNom 80 ºF DryBulb 75 ºF (indoor) kWcor 2.89 kW
WBNom 67 ºF WetBulb 63 ºF (indoor) SHRcor #VALUE!
RHNom #VALUE! % RelHumid ### % (indoor) EERcor 11.5 Btu/w-hr

Heating Nominal Conditions

EAThNom 70 ºF
CFMhNom 1200 cfm
OAThNom 17 ºF Corrected Heating Conditions and Performance
HCap17 22.6 kBtu/h OATempH 20 ºF (outdoor) Hcap 22.1 kBtu/h
kW17 2.76 kW AirFlowH 1200 cfm (indoor) kWheat 2.86 kW
COP17 2.40 InAirTempH 70 ºF (indoor) COP* 2.3
DefrostPen 3.0% % *COP does not include auxiliary heat.

If Macro security level is set at high, this program will result in For 2007 Office products, the terminology "t
errors in the cells [NAME?]. To reset the security level (Office 2003 and the procedure has been changed (as yo
and earlier), the "trust" settings:
1. Close the program.
2. Click on "Tools" on the main tool bar, select "Macro", select Open Excel
"Security. Click the Office Button (top left corner of scr
3. Reset security level to Medium (recommended) or Low Click on "Excel Options" button @ the botto
4. Exit Excel Click on "Trust Center"
5. Re-Open Excel Click on "Trust Center Settings"
6. Run program Click on "◘ Enable all macros.."
Open and Run the programs
An option would be to reset the trust setting
and,
Click on "◘ Disable macros with notification
 Simplified (Kavanaugh, 2006) available from ASHRAE.

to actual condtions (outdoor air temperature, indoor air temperature, air

to correct the equipment performance of other manufacturers by

Nominal Heating to Actual Correction Factors

OAT cfm IAT
Hcap 1.01 1.00 1
kWHeat 1.00 1.00 1

ude auxiliary heat.

oducts, the terminology "trust" has replaced "security"

has been changed (as you might expect). To change
s:

utton (top left corner of screen)

ptions" button @ the bottom of the pop-up window
nter"
nter Settings"
all macros.."
programs
e to reset the trust setting by repeating steps 1 thru 5

e macros with notification"

 Input nominal perfomance @ 95ºF OAT & 80º/67ºF IAT
2 ton 2.5 ton 3 ton 3.5 ton 4 ton 5 ton
Tot Cap (MBtu/h) 24.7 31.2 35.8 43.6 50 57.6
Sen Cap (MBtu/h) 18.3 24.2 26.4 32 35.7 42
Tot Power (kW) 1.9 2.6 2.97 3.51 4.1 5.08
Air Flow (cfm) 800 1100 1200 1300 1400 1700

Heat Cap @ 17F 12.1 19.2 22.6 28.7 31 35.7

kW In @ 17F 1.5 2.5 2.76 3.08 3.31 4.07
 40
EAT TC SC kW
85 37.2 27 2.69 35 f(x) = 0.00050x^2 - 0.23000x + 53.13750
TC
95 35.8 26.4 2.97 30 Polynomia
105 34.5 25.9 3.31 l (TC)
25 f(x) = - 0.00200x^2 + 0.32000x SC
+ 14.20000
115 33.3 24.5 3.66
20 Polynomia
kw l (SC)
EAT TCcf SCcf kWcf 15 kW
85 1.039 1.023 0.906 Polynomia
95 1.000 1.000 1.000 10 l (kW)
105 0.964 0.981 1.114 5
115 0.930 0.928 1.232 0 f(x) = 0.000175x^2 - 0.002500x + 1.635625
50 60 70 80 90 100 110 120

EAT= 95 ºF
TC= 35.8 MBtu/h
SC= 26.6 MBtu/h
kW= 2.98 kW 1.200
f(x) = 0.0000589x^2 - 0.0008418x + 0.5507155

1.100

f(x) = 0.0000140x^2 - 0.0064246x + 1.4842877

1.000 f(x) = - 0.0000758x^2 + 0.0121212x + 0.5378788

0.900

0.800
50 60 70 80 90 100 110 120
 oat hc kw
000x + 53.13750 57 41.5 3.21
TC
Polynomia 47 36.8 3.1 #NAME?
l (TC) 37 26 2.85
000x SC
+ 14.20000 27 24.3 2.8
Polynomia 17 22.6 2.76 1.000579
l (SC)
kW
Polynomia
l (kW) oat cfHC cfKW
57 1.836 1.163
500x + 1.635625 47 1.628 1.123
37 1.150 1.033
27 1.075 1.014
17 1.000 1.000

AAHP - OAT Correction Factors

CFHC & CFKW

8x + 0.5507155
2.000

1.800 f(x) = 0.000477x^2 - 0.013059x + 1.072456

6x + 1.4842877 1.600 cfHC

2x + 0.5378788 Polynomial
(cfHC)
1.400 cfKW
Polynomial
1.200 (cfKW)

f(x) = 0.0000880x^2 - 0.0021636x + 1.0086594

1.000

110 120 0.800

15 20 25 30 35 40 45 50 55 60
Out Air Temp (F)
 C o rre c tio n F a c to r
cfm% TCcf SCcf kWcf
85 0.975 0.93 0.98
95 0.99 0.98 0.99
1.1
105 1.005 1.02 1.01
115 1.015 1.07 1.03
1.05 f(x) = 0.0000x^2 + 0.0046x + 0.5400
TCcf
Polynom
f(x) = 0.000025x^2 - 0.003300x (TCcf)
+ 1.079
1 f(x) = - 0.0000125x^2 + 0.0038500x + 0.7378
SCcf
Polynom
(SCcf)
0.95 kWcf
Polynom
(kWcf)
0.9

0.85
75 85 95 105 115 125
% Rated Cfm
1.06

cfm HC kWheat 1.04 f(x) = - 0.225x + 1.2283333333

0.8 0.98 1.05 1.02
1 1 1 f(x) = 0.1x + 0.9
1.2 1.02 0.96 1
0.98
0.96
0.94
0.92
0.9
0.7 0.8 0.9 1 1.1 1.2 1.3
 0.0046x + 0.5400
TCcf
Polynomial
2 - 0.003300x (TCcf)
+ 1.079375
+ 0.0038500x + 0.7378125
SCcf
Polynomial
(SCcf)
kWcf
Polynomial
(kWcf)

5 125
 Corr. Fac
1.2
wb TCcf kWcf
61 0.91 0.96 1.1 TCc
64 0.95 0.98 f(x) = 0.0009252x^2 - 0.1032463x + 3.76
Poly
67 1 1 (TC
1 f(x) = 0.0002772x^2 - 0.0286847x + 1.67
kWc
71 1.1 1.04 Poly
(kW
0.9

0.8
60 62 64 66 68 70 72
EA Wet Bulb Temp(F)
60 65 70 75
70 0.943 0.797
75 1.067 0.952 0.697
80 1.192 1.106 0.82 0.637
85 1.261 0.944 0.817
1.3
90
95
1.067
1.2
0.983
1.159
Chart Title
f(x) = 0.0249x
0.03092x- -0.8001666667
1.3673
60
1.2
f(x) = 0.02506x - 1.1845 Linea
1.025 f(x) = 0.03464x - 2.132 (60)
1.1
SCcf

1.02 65
f(x) = - 0.002x + 1.14 Linea
iath HC 1.015 1 (65)
1.01
60
65
1.02
1.01 1.005 0.9
Chart Title 70
Linea
70 1 (70)
1.061 75
75 0.99 0.995 0.8
1.04 Linea
0.99 f(x) = 0.008x + 0.44 (75)
1.02 0.7
0.985
1
0.98
0.98 0.6
iath kWheat 0.975 60 65 70 75 80 85 90 95 100
0.96 db
60 0.92 58 60 62 64 66 68 70 72 74 76
0.94
65 0.96
0.92
70 1
75 1.04 0.9
0.88
0.86
58 60 62 64 66 68 70 72 74 76
 TCcf
52x^2 - 0.1032463x + 3.7660413
Polynomial
(TCcf)
72x^2 - 0.0286847x + 1.6786976
kWcf
Polynomial
(kWcf)

68 70 72
Temp(F)

Title
001666667
3673
60
1.1845 Linear
3464x - 2.132 (60)
65
Linear
(65)
Title 70
Linear
(70) HC
75 Linear
Linear (HC)
(75)

0 95 100 kWheat
Linear
70 72 74 76 (kWheat)

72 74 76