{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["INSTRUCTION","INPUT","OUTPUT"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":10,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"INSTRUCTION","index":0,"n_rows":279,"n_cols":22,"rows_kept":279,"cut":false,"hidden":false,"merged":[[249,16,250,18],[257,8,257,11],[258,8,259,11],[128,12,128,13],[139,17,139,19],[140,17,141,19],[153,8,153,11],[154,8,155,11],[248,16,248,18]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"SAMPLE DATA I"]
[null,"Carrier Two-Speed Electric Heat Pump: SYNERGY 38YDA"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Indoor Fan Power",null,510,"W"]
[]
[null,null,null,null,null,null,null,"Capacity and Power data at various temperatures and rated flow rate.  This data is",null,null,null,null,null,null,null,"Capacity and Power Data at various supply air flow rates and rated temperatures. "]
[null,"Manufacturer's Data",null,null,null,null,null,"used to generate Capacity and EIR curves as a function of temperatures.",null,null,null,null,null,null,null," This data is used to generate Capacity and EIR curves as a flow fraction."]
[null,null,null,null,null,null,null,null,null,null,null,null,"Corrected",null,null,null,null,null,null,"Corrected",null,"Corrected"]
[null,"CFM","TWB, °F","TDB, °F","CAP, kBtuh","Total POWER, kW",null,"CFM","TWB, °F","TDB, °F","CAP, kBTuh","Total POWER, kW","GROSS CAP, kBtuh","POWER, kW",null,"CFM","TWB, °F","TDB, °F","CAP, kBtuh","Gross CAP, kBtuh","POWER, kW","Power (Compressor + Outdoor Coil Fan), kW"]
[null,800,72,85,43.6,3.29,null,1100,72,85,46.9,3.41,{"$f":"$K131+($R$125*3.4121/1000)","v":48.640170999999995},{"$f":"$L131-$R$125/1000","v":2.9000000000000004},null,800,67,95,37.200000000000003,{"$f":"$S131+($R$125*3.412/1000)","v":38.94012},3.41,{"$f":"$U131-$R$125/1000","v":2.9000000000000004}]
[null,800,67,85,39.4,3.19,null,1100,67,85,42.5,3.31,{"$f":"$K132+($R$125*3.4121/1000)","v":44.240171000000004},{"$f":"$L132-$R$125/1000","v":2.8},null,900,67,95,38.299999999999997,{"$f":"$S132+($R$125*3.412/1000)","v":40.040119999999995},3.46,{"$f":"$U132-$R$125/1000","v":2.95}]
[null,800,63,85,36.4,3.11,null,1100,63,85,39.299999999999997,3.23,41.040171000000001,2.7199999999999998,null,990,67,95,39.200000000000003,40.94012,3.5,2.99]
[null,800,62,85,35.6,3.09,null,1100,62,85,38.6,3.21,40.340170999999998,2.7,null,1100,67,95,40,41.740119999999997,3.54,3.0300000000000002]
[null,800,57,85,32.4,3,null,1100,57,85,37,3.17,38.740171000000004,2.66,null,1225,67,95,40.799999999999997,42.540119999999995,3.58,3.0700000000000003]
[null,900,72,85,44.9,3.33,null,1100,72,95,44.2,3.66,45.940171000000007,3.1500000000000004]
[null,900,67,85,40.6,3.23,null,1100,67,95,40,3.54,41.740171000000004,3.0300000000000002]
[null,900,63,85,37.6,3.16,null,1100,63,95,37,3.45,38.740171000000004,2.9400000000000004]
[null,900,62,85,36.700000000000003,3.13,null,1100,62,95,36.200000000000003,3.43,37.940171000000007,2.92]
[null,900,57,85,34.1,3.07,null,1100,57,95,35.200000000000003,3.39,36.940171000000007,2.88,null,null,null,"Format Required By the Tool"]
[null,990,72,85,45.9,3.37,null,1100,72,105,41.4,3.9,43.140170999999995,3.3899999999999997,null,null,null,"INPUT DATA FOR CAP AND EIR AS A FUNCTION OF FLOW"]
[null,990,67,85,41.6,3.27,null,1100,67,105,37.5,3.76,39.240171000000004,3.25]
[null,990,63,85,38.5,3.19,null,1100,63,105,34.5,3.65,36.240171000000004,3.1399999999999997,null,null,null,"CFM","CAP, kBtuh","POWER, kW"]
[null,990,62,85,37.6,3.17,null,1100,62,105,33.9,3.63,35.640170999999995,3.12,null,null,null,{"$f":"P131","v":800},{"$f":"T131","v":38.94012},{"$f":"V131","v":2.9000000000000004}]
[null,990,57,85,35.5,3.12,null,1100,57,105,33.4,3.61,35.140170999999995,3.0999999999999996,null,null,null,{"$f":"P132","v":900},{"$f":"T132","v":40.040119999999995},{"$f":"V132","v":2.95}]
[null,1100,72,85,46.9,3.41,null,1100,72,115,38.700000000000003,4.13,40.440171000000007,3.62,null,null,null,{"$f":"P133","v":990},{"$f":"T133","v":40.94012},{"$f":"V133","v":2.99}]
[null,1100,67,85,42.5,3.31,null,1100,67,115,34.9,3.97,36.640170999999995,3.46,null,null,null,{"$f":"P134","v":1100},{"$f":"T134","v":41.740119999999997},{"$f":"V134","v":3.0300000000000002}]
[null,1100,63,85,39.299999999999997,3.23,null,1100,63,115,32.1,3.85,33.840170999999998,3.34,null,null,null,{"$f":"P135","v":1225},{"$f":"T135","v":42.540119999999995},{"$f":"V135","v":3.0700000000000003}]
[null,1100,62,85,38.6,3.21,null,1100,62,115,31.6,3.82,33.340170999999998,3.3099999999999996]
[null,1100,57,85,37,3.17,null,1100,57,115,31.5,3.82,33.240171000000004,3.3099999999999996]
[null,1225,72,85,47.8,3.44]
[null,1225,67,85,43.4,3.35]
[null,1225,63,85,40.200000000000003,3.27]
[null,1225,62,85,39.4,3.25,null,null,"Format Required By the Tool"]
[null,1225,57,85,38.5,3.23,null,null,"INPUT DATA FOR CAP AND EIR AS A FUNCTION OF TEMPERATURE"]
[null,800,72,95,41.2,3.53]
[null,800,67,95,37.200000000000003,3.41,null,null,"TWB, °F","TDB, °F","CAP, kBtuh","Power, kW"]
[null,800,63,95,34.299999999999997,3.32,null,null,{"$f":"I131","v":72},{"$f":"J131","v":85},{"$f":"M131","v":48.640170999999995},{"$f":"N131","v":2.9000000000000004}]
[null,800,62,95,33.6,3.29,null,null,{"$f":"I132","v":67},85,{"$f":"M132","v":44.240171000000004},{"$f":"N132","v":2.8}]
[null,800,57,95,30.9,3.21,null,null,{"$f":"I133","v":63},85,41.040171000000001,2.7199999999999998]
[null,900,72,95,42.4,3.58,null,null,{"$f":"I134","v":62},85,40.340170999999998,2.7]
[null,900,67,95,38.299999999999997,3.46,null,null,{"$f":"I135","v":57},85,38.740171000000004,2.66]
[null,900,63,95,35.4,3.37,null,null,{"$f":"I136","v":72},95,45.940171000000007,3.1500000000000004]
[null,900,62,95,34.6,3.34,null,null,{"$f":"I137","v":67},95,41.740171000000004,3.0300000000000002]
[null,900,57,95,32.5,3.28,null,null,{"$f":"I138","v":63},95,38.740171000000004,2.9400000000000004]
[null,990,72,95,43.2,3.62,null,null,{"$f":"I139","v":62},95,37.940171000000007,2.92]
[null,990,67,95,39.200000000000003,3.5,null,null,{"$f":"I140","v":57},95,36.940171000000007,2.88]
[null,990,63,95,36.200000000000003,3.41,null,null,{"$f":"I141","v":72},105,43.140170999999995,3.3899999999999997]
[null,990,62,95,35.4,3.38,null,null,{"$f":"I142","v":67},105,39.240171000000004,3.25]
[null,990,57,95,33.799999999999997,3.33,null,null,{"$f":"I143","v":63},105,36.240171000000004,3.1399999999999997]
[null,1100,72,95,44.2,3.66,null,null,{"$f":"I144","v":62},105,35.640170999999995,3.12]
[null,1100,67,95,40,3.54,null,null,{"$f":"I145","v":57},105,35.140170999999995,3.0999999999999996]
[null,1100,63,95,37,3.45,null,null,{"$f":"I146","v":72},115,40.440171000000007,3.62]
[null,1100,62,95,36.200000000000003,3.43,null,null,{"$f":"I147","v":67},115,36.640170999999995,3.46]
[null,1100,57,95,35.200000000000003,3.39,null,null,{"$f":"I148","v":63},115,33.840170999999998,3.34]
[null,1225,72,95,45,3.7,null,null,{"$f":"I149","v":62},115,33.340170999999998,3.3099999999999996]
[null,1225,67,95,40.799999999999997,3.58,null,null,{"$f":"I150","v":57},115,33.240171000000004,3.3099999999999996]
[null,1225,63,95,37.700000000000003,3.49]
[null,1225,62,95,37,3.47]
[null,1225,57,95,36.6,3.46]
[null,800,72,105,38.799999999999997,3.76]
[null,800,67,105,34.9,3.62]
[null,800,63,105,32.200000000000003,3.52]
[null,800,62,105,31.5,3.49]
[null,800,57,105,29.4,3.4]
[null,900,72,105,39.9,3.81]
[null,900,67,105,36,3.68]
[null,900,63,105,33.200000000000003,3.57]
[null,900,62,105,32.4,3.54]
[null,900,57,105,30.9,3.48]
[null,990,72,105,40.6,3.86]
[null,990,67,105,36.700000000000003,3.72]
[null,990,63,105,33.9,3.61]
[null,990,62,105,33.200000000000003,3.58]
[null,990,57,105,32.1,3.54]
[null,1100,72,105,41.4,3.9]
[null,1100,67,105,37.5,3.76]
[null,1100,63,105,34.5,3.65]
[null,1100,62,105,33.9,3.63]
[null,1100,57,105,33.4,3.61]
[null,1225,72,105,42.2,3.94]
[null,1225,67,105,38.1,3.81]
[null,1225,63,105,35.200000000000003,3.7]
[null,1225,62,105,34.700000000000003,3.68]
[null,1225,57,105,34.700000000000003,3.68]
[null,800,72,115,36.299999999999997,3.99]
[null,800,67,115,32.700000000000003,3.83]
[null,800,63,115,30.1,3.7]
[null,800,62,115,29.4,3.67]
[null,800,57,115,27.8,3.6]
[null,900,72,115,37.299999999999997,4.04]
[null,900,67,115,33.6,3.88]
[null,900,63,115,30.9,3.76]
[null,900,62,115,30.2,3.73]
[null,900,57,115,29.2,3.68]
[null,990,72,115,37.9,4.08]
[null,990,67,115,34.200000000000003,3.92]
[null,990,63,115,31.5,3.8]
[]
[]
[null,"SAMPLE DATA II"]
[null,"PACKAGED HEAT PUMP"]
[null,"LENNOX KH Landmark RoofTop Unit: Model KHA036S4"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Outdoor Coil Fan Power: ",null,null,{"$f":"250","v":250},"W"]
[]
[null,"Manufacturer's Data",null,null,null,null,null,"Capacity and Power data at various temperatures and rated flow rate.  This data",null,null,null,null,null,null,"Capacity and Power Data at various supply air flow rates and rated temperatures. "]
[null,null,null,null,null,null,null," is used to generate Capacity and EIR curves as a function of temperatures.",null,null,null,null,null,null," This data is used to generate Capacity and EIR curves as a flow fraction."]
[null,"TWB, °F","TDB, °F","CFM","GROSS CAP, kBtuh","Power, kW",null,"TWB, °F","TDB, °F","GROSS CAP, kBtuh","Comp. Power, kW","Power, kW",null,null,"TWB, °F","TDB, °F","CFM","Gross CAP, kBtuh","Comp. Power, kW","Power, kW"]
[null,63,{"$f":"85","v":85},960,35.200000000000003,2.2599999999999998,null,63,85,36.700000000000003,2.27,{"$f":"$K244+$R$239/1000","v":2.52},null,null,67,95,960,35.799999999999997,2.58,{"$f":"$S244+$R$239/1000","v":2.83}]
[null,63,{"$f":"85","v":85},1200,36.700000000000003,2.27,null,67,85,39,2.2799999999999998,{"$f":"$K245+$R$239/1000","v":2.5299999999999998},null,null,67,95,1200,37.1,2.59,{"$f":"$S245+$R$239/1000","v":2.84}]
[null,63,{"$f":"85","v":85},1440,37.9,2.2799999999999998,null,71,85,41.5,2.31,2.56,null,null,67,95,1440,37.9,2.6,2.85]
[null,67,{"$f":"85","v":85},960,37.6,2.2799999999999998,null,63,95,34.9,2.58,2.83]
[null,67,{"$f":"85","v":85},1200,39,2.2799999999999998,null,67,95,37.1,2.59,2.84]
[null,67,{"$f":"85","v":85},1440,39.9,2.29,null,71,95,39.5,2.62,2.87,null,null,null,null,"Format Required By the Tool"]
[null,71,{"$f":"85","v":85},960,40.200000000000003,2.2999999999999998,null,63,105,33.1,2.93,3.18,null,null,null,null,"INPUT DATA FOR CAP AND EIR AS A FUNCTION OF FLOW"]
[null,71,{"$f":"85","v":85},1200,41.5,2.31,null,67,105,35,2.94,3.19]
[null,71,{"$f":"85","v":85},1440,42.4,2.31,null,71,105,37.4,2.97,3.22,null,null,null,null,"Flow, CFM","CAP, kBtuh","Power, kW"]
[null,63,95,960,33.6,2.57,null,63,115,31.2,3.34,3.59,null,null,null,null,{"$f":"Q244","v":960},35.799999999999997,{"$f":"T244","v":2.83}]
[null,63,95,1200,34.9,2.58,null,67,115,32.799999999999997,3.35,3.6,null,null,null,null,1200,37.1,{"$f":"T245","v":2.84}]
[null,63,95,1440,36.299999999999997,2.59,null,71,115,35,3.37,3.62,null,null,null,null,1440,37.9,{"$f":"T246","v":2.85}]
[null,67,95,960,35.799999999999997,2.58]
[null,67,95,1200,37.1,2.59]
[null,67,95,1440,37.9,2.6,null,null,"Format Required By the Tool"]
[null,71,95,960,38.299999999999997,2.61,null,null,"INPUT DATA FOR CAP AND EIR AS A FUNCTION OF TEMPERATURE"]
[null,71,95,1200,39.5,2.62]
[null,71,95,1440,40.299999999999997,2.62,null,null,"TWB, °F","TDB, °F","Gross CAP, kBtuh","Power, kW"]
[null,63,{"$f":"105","v":105},960,31.7,2.92,null,null,{"$f":"H244","v":63},85,{"$f":"J244","v":36.700000000000003},{"$f":"L244","v":2.52}]
[null,63,{"$f":"105","v":105},1200,33.1,2.93,null,null,67,85,39,{"$f":"L245","v":2.5299999999999998}]
[null,63,{"$f":"105","v":105},1440,34.6,2.94,null,null,71,85,41.5,2.56]
[null,67,{"$f":"105","v":105},960,33.9,2.93,null,null,63,95,34.9,2.83]
[null,67,{"$f":"105","v":105},1200,35,2.94,null,null,67,95,37.1,2.84]
[null,67,{"$f":"105","v":105},1440,35.799999999999997,2.95,null,null,71,95,39.5,2.87]
[null,71,{"$f":"105","v":105},960,36.299999999999997,2.96,null,null,63,105,33.1,3.18]
[null,71,{"$f":"105","v":105},1200,37.4,2.97,null,null,67,105,35,3.19]
[null,71,{"$f":"105","v":105},1440,38.1,2.98,null,null,71,105,37.4,3.22]
[null,63,{"$f":"115","v":115},960,29.8,3.33,null,null,63,115,31.2,3.59]
[null,63,{"$f":"115","v":115},1200,31.2,3.34,null,null,67,115,32.799999999999997,3.6]
[null,63,{"$f":"115","v":115},1440,32.700000000000003,3.34,null,null,71,115,35,3.62]
[null,67,{"$f":"115","v":115},960,31.8,3.34]
[null,67,{"$f":"115","v":115},1200,32.799999999999997,3.35]
[null,67,{"$f":"115","v":115},1440,33.5,3.36]
[null,71,{"$f":"115","v":115},960,34,3.36]
[null,71,{"$f":"115","v":115},1200,35,3.37]
[null,71,{"$f":"115","v":115},1440,35.6,3.38]

{"sheet":"INPUT","index":1,"n_rows":34,"n_cols":5,"rows_kept":34,"cut":false,"hidden":false,"merged":[]}
[]
[]
["DX Coil Type: ","Cooling"]
["Independent Variable: ","Temperature"]
["Curve Type: ","Biquadratic"]
["Units: ","SI"]
[]
["Curve Object Name: ","HP"]
[]
["Rated Data:  ","Rated Indoor Air Wet-Bulb Temperature","Rated Outdoor Air Dry-Bulb Temperature","Rated Gross Total Cooling Capacity","Rated Compressor Plus Outdoor Coil Fan Power"]
[null,19.444444000000001,35]
[]
["Performance Data:  ","Indoor Air Wet-Bulb Temperature","Outdoor Air Dry-Bulb Temperature","Gross Total Cooling Capacity","Compressor Plus Outdoor Coil Fan Power"]
[null,"oC","oC","W","W"]
[null,72,85,48.640170999999995,2.9000000000000004]
[null,67,85,44.240171000000004,2.8]
[null,63,85,41.040171000000001,2.7199999999999998]
[null,62,85,40.340170999999998,2.7]
[null,57,85,38.740171000000004,2.66]
[null,72,95,45.940171000000007,3.1500000000000004]
[null,67,95,41.740171000000004,3.0300000000000002]
[null,63,95,38.740171000000004,2.9400000000000004]
[null,62,95,37.940171000000007,2.92]
[null,57,95,36.940171000000007,2.88]
[null,72,105,43.140170999999995,3.3899999999999997]
[null,67,105,39.240171000000004,3.25]
[null,63,105,36.240171000000004,3.1399999999999997]
[null,62,105,35.640170999999995,3.12]
[null,57,105,35.140170999999995,3.0999999999999996]
[null,72,115,40.440171000000007,3.62]
[null,67,115,36.640170999999995,3.46]
[null,63,115,33.840170999999998,3.34]
[null,62,115,33.340170999999998,3.3099999999999996]
[null,57,115,33.240171000000004,3.3099999999999996]

{"sheet":"OUTPUT","index":2,"n_rows":43,"n_cols":3,"rows_kept":43,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Output File Name: "]
[null,"Output File Path: "]
[]
[]
[null,"! 0.9957","R Squared"]
[null,"Curve:Biquadratic"]
[null,"HPCoolingCAPFTemp","!- Name"]
[null,1.4071404545999999,"!- Coefficient1 Constant"]
[null,-5.3135346E-2,"!- Coefficient2 x"]
[null,2.6360200999999998E-3,"!- Coefficient3 x**2"]
[null,-1.6726232999999999E-3,"!- Coefficient4 y"]
[null,-7.7623000000000002E-6,"!- Coefficient5 y**2"]
[null,-4.4455729999999999E-4,"!- Coefficient6 x*y"]
[null,13.89,"!- Minimum Value of x"]
[null,22.22,"!- Maximum Value of x"]
[null,29.44,"!- Minimum Value of y"]
[null,46.11,"!- Maximum Value of y"]
[null,0.7964,"!- Minimum Curve Output"]
[null,1.1653,"!- Maximum Curve Output"]
[null,"Temperature","!- Input Unit Type for X"]
[null,"Temperature","!- Input Unit Type for Y"]
[null,"Dimensionless","!- Output Unit Type"]
[]
[]
[null,"! 0.9984","R Squared"]
[null,"Curve:Biquadratic"]
[null,"HPCoolingEIRFTemp","!- Name"]
[null,0.14556900380000001,"!- Coefficient1 Constant"]
[null,4.5092728200000001E-2,"!- Coefficient2 x"]
[null,-1.5553886E-3,"!- Coefficient3 x**2"]
[null,1.0709694299999999E-2,"!- Coefficient4 y"]
[null,2.343511E-4,"!- Coefficient5 y**2"]
[null,-1.4138470000000001E-4,"!- Coefficient6 x*y"]
[null,13.89,"!- Minimum Value of x"]
[null,22.22,"!- Maximum Value of x"]
[null,29.44,"!- Minimum Value of y"]
[null,46.11,"!- Maximum Value of y"]
[null,0.82130000000000003,"!- Minimum Curve Output"]
[null,1.3717999999999999,"!- Maximum Curve Output"]
[null,"Temperature","!- Input Unit Type for X"]
[null,"Temperature","!- Input Unit Type for Y"]
[null,"Dimensionless","!- Output Unit Type"]