{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["About","Project Summary","1. HVAC Design Review","2. Total Duct Leakage","3. Blower Fan Airflow","4. Blower Fan Watt Draw","5. Refrigerant Charge","Data Export"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":1,"defined_names":69,"comments":2,"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":"About","index":0,"n_rows":53,"n_cols":6,"rows_kept":53,"cut":false,"hidden":false,"merged":[[22,1,31,1],[33,1,38,1],[40,1,54,1],[1,2,20,14],[1,1,20,1],[23,3,23,4],[23,5,23,12],[46,5,49,12],[52,5,53,12],[50,5,51,12]]}
["Standard 310 Data Tool: About"]
[null,"Introduction","This spreadsheet is intended to aid in data collection, and associated calculations, for tasks contained within ANSI/RESNET/ACCA Standard 310-2020 Standard for Grading the Installation of HVAC Systems. \n\nThe standard is comprised of five tasks - a design review, a total duct leakage test, a Blower Fan volumetric airflow test, a Blower Fan watt draw test, and a non-invasive evaluation of refrigerant charge. The five tasks are designed to be completed in sequence. With the completion of each task, the results are evaluated for compliance with specified thresholds. For Task 1, these thresholds are design tolerances. For Tasks 2 through 5, the thresholds are installation quality grades. Furthermore, for Tasks 1 through 3, specified thresholds must be satisfied or the subsequent tasks cannot be completed. A visual representation of the workflow and the diagnostic test methods is shown in Figure 1.\n\n                                                                    Figure 1 Illustration of Workflow and Diagnostic Test Methods\n"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Table of Contents"]
[null,null,null,"Tab Name",null,"Tab Description"]
[null,null,null,"Project Summary",null,"Summary of project information and critical inputs and outputs for each Task. "]
[null,null,null,"1. HVAC Design Review",null,"Plan and field review inputs and calculations for Task 1 HVAC Design Review."]
[null,null,null,"2. Total Duct Leakage",null,"Field inputs and calculations for Task 2 Total Duct Leakage."]
[null,null,null,"3. Blower Fan Airflow",null,"Field inputs and calculations for Task 3 Blower Fan Airflow."]
[null,null,null,"4. Blower Fan Watt Draw",null,"Field inputs and calculations for Task 4 Blower Fan Watt Draw."]
[null,null,null,"5. Refrigerant Charge",null,"Field inputs and calculations for Task 5. Refrigerant Charge."]
[null,null,null,"Data Export",null,"Table of all raw inputs and outputs of the spreadsheet. "]
[]
[]
[null,"Formatting Legend"]
[null,null,null,123,"User Input"]
[null,null,null,123,"User input is out of range specified by the standard"]
[null,null,null,123,"Calculated value"]
[null,null,null,123,"Likely ERI software input (Project Summary tab)"]
[]
[]
[null,"Version History"]
[null,null,null,"Current Version: ",null,{"$f":"\"v\"&D53","v":"v1.3"}]
[]
[null,null,null,"Version","Date","Updates"]
[null,null,null,1,"2020-04-27","Original"]
[null,null,null,1.1000000000000001,"2020-06-09","Added formatting for rating software inputs to Project Summary tab"]
[null,null,null,1.2,"2021-02-19","Updated '1. HVAC Design Review' tab to include both a Plan Review and Field Review section. Combined, these two sections encompass all requirements of the Std. 310 design review task. Prior versions only included the field review criteria. As a result, the name of the tool has been updated from the \"Std 310 Field Data Tool\" to the \"Std 310 Data Tool\"."]
[]
[]
[]
[null,null,null,"1.2.1","2021-02-25","Fixed small bug on Blower Fan Airflow tab. Duct leakage grade results in cell H4 had been hard-coded and now properly reference the results from the prior tab."]
[]
[null,null,null,1.3,"2021-04-01","On '3. Blower Fan Airflow' tab, added ability for users to enter pressure measurements in either IWC or Pa."]

{"sheet":"Project Summary","index":1,"n_rows":54,"n_cols":6,"rows_kept":54,"cut":false,"hidden":false,"merged":[[18,3,18,4],[25,3,25,4],[1,1,7,1],[9,1,12,1],[14,1,16,1],[15,3,15,4],[11,4,11,5],[10,4,10,5],[6,4,6,5],[5,4,5,5],[4,4,4,5],[3,4,3,5],[2,4,2,5],[17,1,23,1],[24,1,33,1],[21,3,21,4],[34,1,39,1],[40,1,54,1],[27,3,27,4],[26,3,26,4],[22,3,22,4],[53,3,53,4],[52,3,52,4],[51,3,51,4],[50,3,50,4],[49,3,49,4],[48,3,48,4],[47,3,47,4],[46,3,46,4],[45,3,45,4],[44,3,44,4],[43,3,43,4],[42,3,42,4],[41,3,41,4],[20,3,20,4],[19,3,19,4],[38,3,38,4],[37,3,37,4],[36,3,36,4],[35,3,35,4],[32,3,32,4],[31,3,31,4],[30,3,30,4],[29,3,29,4],[28,3,28,4]]}
["Standard 310 Data Tool: Project Summary"]
[null,"Project Information"]
[null,null,null,"Home Address:"]
[null,null,null,"City:"]
[null,null,null,"State:"]
[null,null,null,"Permit Date:"]
[null,null,null,"Inspection Date:"]
[]
[]
[null,"Rater Information"]
[null,null,null,"Rater Company Name: "]
[null,null,null,"Rater Employee: "]
[]
[]
[null,"1. HVAC Design Review"]
[null,null,null,"Meets all tolerances? ",null,{"$f":"'1. HVAC Design Review'!P151","v":"No"}]
[]
[null,"2. Total Duct Leakage"]
[null,null,null,"Was total duct leakage test exemption taken?",null,{"$f":"'2. Total Duct Leakage'!H12","v":"No"}]
[null,null,null,"Total duct leakage normalized by CFA served by system (CFM25/100 Sq. Ft.)",null,{"$f":"'2. Total Duct Leakage'!H17","v":{"$error":"#DIV/0!"}}]
[null,null,null,"Testing at rough-in or final?",null,{"$f":"'2. Total Duct Leakage'!H13","v":"Rough-in"}]
[null,null,null,"Number of returns in the system",null,{"$f":"'2. Total Duct Leakage'!H14","v":0}]
[null,null,null,"Total Duct Leakage Grade Designation",null,{"$f":"'2. Total Duct Leakage'!H19","v":"Grade III"}]
[]
[null,"3. Blower Fan Airflow"]
[null,null,null,"Was blower fan airflow test exemption taken?",null,{"$f":"'3. Blower Fan Airflow'!H19","v":"No"}]
[null,null,null,"Airflow test method",null,{"$f":"'3. Blower Fan Airflow'!H21","v":"Flow Hood"}]
[null,null,null,"Design-specified blower fan airflow (CFM)",null,{"$f":"'3. Blower Fan Airflow'!H12","v":0}]
[null,null,null,"Blower fan airflow at operating conditions (CFM)",null,{"$f":"'3. Blower Fan Airflow'!H72","v":"Prereq Not Met"}]
[null,null,null,"Observed fan-speed setting",null,{"$f":"'3. Blower Fan Airflow'!H54","v":0}]
[null,null,null,"Pressure difference for OEM Static Pressure Table (IWC)",null,{"$f":"'3. Blower Fan Airflow'!H65","v":0}]
[null,null,null,"Blower fan volumetric airflow grade",null,{"$f":"'3. Blower Fan Airflow'!H74","v":"Grade III"}]
[null,null,null,"Airflow Fault (%)",null,{"$f":"'3. Blower Fan Airflow'!H73","v":"Prereq Not Met"}]
[]
[null,"4. Blower Fan Watt Draw"]
[null,null,null,"Test method for measuring blower fan watt draw",null,{"$f":"'4. Blower Fan Watt Draw'!H11","v":"Portable Plug-In Watt Meter"}]
[null,null,null,"Watt draw of blower fan (W)",null,{"$f":"'4. Blower Fan Watt Draw'!H31","v":"Prereq Not Met"}]
[null,null,null,"Blower fan efficiency (W/CFM)",null,{"$f":"'4. Blower Fan Watt Draw'!H32","v":"Prereq Not Met"}]
[null,null,null,"Blower fan watt draw grade",null,{"$f":"'4. Blower Fan Watt Draw'!H33","v":"Grade III"}]
[]
[null,"5. Refrigerant Charge"]
[null,null,null,"Test method for assessing refrigerant charge",null,{"$f":"'5. Refrigerant Charge'!H11","v":"Weigh-In"}]
[null,null,null,"Metering device type",null,{"$f":"'5. Refrigerant Charge'!H20","v":"Piston/Cap. Tube"}]
[null,null,null,"Measured outdoor air dry-bulb temperature (F)",null,{"$f":"'5. Refrigerant Charge'!H27","v":0}]
[null,null,null,"Measured suction line temperature (F)",null,{"$f":"'5. Refrigerant Charge'!H29","v":0}]
[null,null,null,"Measured liquid line temperature (F)",null,{"$f":"'5. Refrigerant Charge'!H30","v":0}]
[null,null,null,"Target suction line temp (F)",null,{"$f":"'5. Refrigerant Charge'!H51","v":"N/A"}]
[null,null,null,"Difference DTD (F)",null,{"$f":"'5. Refrigerant Charge'!H52","v":"N/A"}]
[null,null,null,"Target liquid line temp (F)",null,{"$f":"'5. Refrigerant Charge'!H59","v":30}]
[null,null,null,"DifferenceCTOA (F)",null,{"$f":"'5. Refrigerant Charge'!H60","v":30}]
[null,null,null,"Total anticipated refrigerant weight (oz)",null,{"$f":"'5. Refrigerant Charge'!H79","v":0}]
[null,null,null,"Total reported refrigerant weight (oz)",null,{"$f":"'5. Refrigerant Charge'!H80","v":0}]
[null,null,null,"Deviation btw total anticipated and \ntotal reported refrigerant weight (%)",null,{"$f":"'5. Refrigerant Charge'!H81","v":"N/A"}]
[null,null,null,"Refrigerant charge grade designation",null,{"$f":"IF('5. Refrigerant Charge'!H11=\"Weigh-In\",'5. Refrigerant Charge'!H99,IF('5. Refrigerant Charge'!H20=\"Piston/Cap. Tube\",'5. Refrigerant Charge'!H84,'5. Refrigerant Charge'!H90))","v":{"$error":"#VALUE!"}}]

{"sheet":"1. HVAC Design Review","index":2,"n_rows":151,"n_cols":22,"rows_kept":151,"cut":false,"hidden":false,"merged":[[130,1,131,5],[41,1,43,5],[16,1,17,5],[65,1,66,5],[45,1,47,5],[71,1,71,5],[76,1,77,5],[34,1,34,5],[40,1,40,5],[55,1,56,5],[86,8,86,10],[86,13,86,15],[0,11,1,11],[2,1,4,16],[5,1,6,16],[13,8,13,10],[13,13,13,15],[61,8,61,10],[61,13,61,15],[38,8,38,10],[38,13,38,15],[22,1,22,5],[27,1,28,5],[9,4,9,8]]}
["Standard 310 Data Tool:"]
["Evaluation of the Design",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Formatting Legend"]
[null,"1) This tab encompasses all required design review criteria, divided into a Plan Review section, which contains all of the criteria, and the Field Review section, which contains the subset that can only be fully verified in the field. Ultimately, the Home as constructed must meet the required criteria. However, completing the Plan Review section will ensure the project is on track and will fully satisfy the subset of criteria that can be fully verified prior to construction.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,123,"User Input"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Incomplete required user input"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,123,"User input is out of range specified by the standard"]
[null,"2) The term \"Home\" is shorthand for the Dwelling, Townhouse, Dwelling Unit, or Sleeping Unit being rated. For the Plan Review section, this is represented by the architectural plan, spec sheets, and/or the energy model; for the Field Review section, this is represented by the actual constructed structure.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,123,"Calculated value"]
[]
[null,"3) Note that two sections must be completed - 1) the section applicable to the specific home type being rated and 2) the section applicable to all home types."]
[]
[null,"Home Type:",null,null,"Dwelling or townhouse or unit within"]
[]
["For A Dwelling or Townhouse, or Dwelling / Sleeping Unit Within (e.g. Duplex)",null,null,null,null,null,null,null,null,null,null,null,null,"Complete this section?",null,{"$f":"IF($E$10=\"Dwelling or townhouse or unit within\",\"Yes\",\"No\")","v":"Yes"},null,null,"Section Reference"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Required data inputs provided? ",{"$f":"IF(P12=\"No\",\"N/A\",IF(ISBLANK(I21)+ISBLANK(N22)+ISBLANK(I26)+ISBLANK(N27)>0,\"No\",\"Yes\"))","v":"No"}]
[null,null,null,null,null,null,null,null,"Plan Review",null,null,null,null,"Field Review"]
[null,"Architectural Plan & Options"]
[null,"Does the name of the plan or address for the Home match the HVAC design?",null,null,null,null,null,null,null,null,"Yes",null,null,null,null,"Yes",null,null,"4.3.1.1"]
[null,"Do the options used in the Home match those in the HVAC design, \nor are they listed in the options the HVAC design can be used with?",null,null,null,null,null,null,null,null,"Yes",null,null,null,null,"Yes",null,null,"4.3.1.2"]
[]
[]
[null,"Conditioned Floor Area of Heating / Cooling Zones",null,null,null,null,null,null,"Zone 1","Zone 2","Zone 3",null,null,"Zone 1","Zone 2","Zone 3",null,null,"4.3.1.3"]
[null,"HVAC Design",null,null,null,null,null,null,null,null,null,null,null,{"$f":"I21","v":0},{"$f":"J21","v":0},{"$f":"K21","v":0},null,"Sq. Ft. "]
[null,"Home",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sq. Ft. "]
[null,"Home is between 300 sq. ft. smaller & 100 sq. ft.  larger than HVAC design?",null,null,null,null,null,null,{"$f":"IF(OR((I22-I21)<-300,(I22-I21)>100)=TRUE,\"No\",\"Yes\")","v":"Yes"},{"$f":"IF(OR((J22-J21)<-300,(J22-J21)>100)=TRUE,\"No\",\"Yes\")","v":"Yes"},{"$f":"IF(OR((K22-K21)<-300,(K22-K21)>100)=TRUE,\"No\",\"Yes\")","v":"Yes"},null,null,{"$f":"IF(OR((N22-N21)<-300,(N22-N21)>100)=TRUE,\"No\",\"Yes\")","v":"Yes"},{"$f":"IF(OR((O22-O21)<-300,(O22-O21)>100)=TRUE,\"No\",\"Yes\")","v":"Yes"},{"$f":"IF(OR((P22-P21)<-300,(P22-P21)>100)=TRUE,\"No\",\"Yes\")","v":"Yes"}]
[]
[null,"Window Area of Heating / Cooling Zones",null,null,null,null,null,null,"Zone 1","Zone 2","Zone 3",null,null,"Zone 1","Zone 2","Zone 3",null,null,"4.3.1.4"]
[null,"HVAC Design",null,null,null,null,null,null,null,null,null,null,null,{"$f":"I26","v":0},{"$f":"J26","v":0},{"$f":"K26","v":0},null,"Sq. Ft. "]
[null,"Home",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sq. Ft. "]
[null,"Home is between 60 sq. ft. smaller & 15 sq. ft. larger than HVAC design, \nor for zones with > 500 sq. ft. of windows, between 12% smaller and 3% larger?",null,null,null,null,null,null,{"$f":"IF(I27<=500,IF(OR((I27-I26)<-60,(I27-I26)>15)=TRUE,\"No\",\"Yes\"),IF(OR((I27-I26)/I26<-12%,(I27-I26)/I26>3%)=TRUE,\"No\",\"Yes\"))","v":"Yes"},{"$f":"IF(J27<=500,IF(OR((J27-J26)<-60,(J27-J26)>15)=TRUE,\"No\",\"Yes\"),IF(OR((J27-J26)/J26<-12%,(J27-J26)/J26>3%)=TRUE,\"No\",\"Yes\"))","v":"Yes"},{"$f":"IF(K27<=500,IF(OR((K27-K26)<-60,(K27-K26)>15)=TRUE,\"No\",\"Yes\"),IF(OR((K27-K26)/K26<-12%,(K27-K26)/K26>3%)=TRUE,\"No\",\"Yes\"))","v":"Yes"},null,null,{"$f":"IF(N27<=500,IF(OR((N27-N26)<-60,(N27-N26)>15)=TRUE,\"No\",\"Yes\"),IF(OR((N27-N26)/N26<-12%,(N27-N26)/N26>3%)=TRUE,\"No\",\"Yes\"))","v":"Yes"},{"$f":"IF(O27<=500,IF(OR((O27-O26)<-60,(O27-O26)>15)=TRUE,\"No\",\"Yes\"),IF(OR((O27-O26)/O26<-12%,(O27-O26)/O26>3%)=TRUE,\"No\",\"Yes\"))","v":"Yes"},{"$f":"IF(P27<=500,IF(OR((P27-P26)<-60,(P27-P26)>15)=TRUE,\"No\",\"Yes\"),IF(OR((P27-P26)/P26<-12%,(P27-P26)/P26>3%)=TRUE,\"No\",\"Yes\"))","v":"Yes"}]
[]
[]
[null,"Heating / Cooling Loads Methodology and Orientations",null,null,null,null,null,null,"Zone 1","Zone 2","Zone 3",null,null,"Zone 1","Zone 2","Zone 3"]
[null,"In HVAC Design, is the max. minus min. total heat gain across orientations ≤ 6 kBtuh?",null,null,null,null,null,null,"N/A","N/A","N/A",null,null,{"$f":"I32","v":"N/A"},{"$f":"J32","v":"N/A"},{"$f":"K32","v":"N/A"},null,null,"4.3.1.6"]
[]
[null,"Does front orientation of the Home match one of the orientations in the HVAC design?",null,null,null,null,null,null,null,null,"Yes",null,null,null,null,"Yes",null,null,"4.3.1.5"]
[null,"In HVAC Design, have heating and cooling loads have been calculated room-by-room?",null,null,null,null,null,null,null,null,"Yes",null,null,null,null,{"$f":"K35","v":"Yes"},null,null,"4.3.1.7"]
[]
["For A Dwelling / Sleeping Unit in a Multifamily Building w/ Heat Gain ≤18 kBTUh & Heat Loss ≤35 kBTUh",null,null,null,null,null,null,null,null,null,null,null,null,"Complete this section?",null,{"$f":"IF($E$10=\"Unit in a multifamily building w/ heat gain ≤18 kBTUh & heat loss ≤35 kBTUh\",\"Yes\",\"No\")","v":"No"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Required data inputs provided? ",{"$f":"IF(P37=\"No\",\"N/A\",IF(ISBLANK(I51)+ISBLANK(N52)>0,\"No\",\"Yes\"))","v":"N/A"}]
[null,null,null,null,null,null,null,null,"Plan Review",null,null,null,null,"Field Review"]
[null,"Building ID, Architectural Plan, & Options"]
[null,"Does the unique identifier for the building that the Home is in match the HVAC design?",null,null,null,null,null,null,null,null,"Yes",null,null,null,null,"Yes",null,null,"4.3.2.1"]
[null,"Does name of the plan for the Home either: a) match the HVAC design or b) is it included in the list of plans that the HVAC design can be used with AND the plan used in the HVAC design has the largest conditioned floor area among the plans listed?",null,null,null,null,null,null,null,null,"Yes",null,null,null,null,"Yes",null,null,"4.3.2.2"]
[]
[]
[]
[null,"Do the options used in the Home either: a) match those in the HVAC design, or b) are they listed in the options the HVAC design can be used with AND the options used in the HVAC design have the largest conditioned floor area among the options listed?",null,null,null,null,null,null,null,null,"Yes",null,null,null,null,"Yes",null,null,"4.3.2.3"]
[]
[]
[]
[null,"Window Area of Heating / Cooling Zones",null,null,null,null,null,null,"Zone 1","Zone 2","Zone 3",null,null,"Zone 1","Zone 2","Zone 3",null,null,"4.3.2.4"]
[null,"HVAC Design",null,null,null,null,null,null,null,null,null,null,null,{"$f":"I51","v":0},{"$f":"J51","v":0},{"$f":"K51","v":0},null,"Sq. Ft. "]
[null,"Home",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sq. Ft. "]
[null,"Home is less than or equal to HVAC design?",null,null,null,null,null,null,{"$f":"IF(I52-I51>0=TRUE,\"No\",\"Yes\")","v":"Yes"},{"$f":"IF(J52-J51>0=TRUE,\"No\",\"Yes\")","v":"Yes"},{"$f":"IF(K52-K51>0=TRUE,\"No\",\"Yes\")","v":"Yes"},null,null,{"$f":"IF(N52-N51>0=TRUE,\"No\",\"Yes\")","v":"Yes"},{"$f":"IF(O52-O51>0=TRUE,\"No\",\"Yes\")","v":"Yes"},{"$f":"IF(P52-P51>0=TRUE,\"No\",\"Yes\")","v":"Yes"}]
[]
[null,"Home Location in Building & Orientation of Heating / Cooling Loads"]
[null,"Does the Home location (e.g., top, middle, bottom floor; corner or middle unit) match the HVAC design, or is the location of the HVAC Design a top floor and corner unit?",null,null,null,null,null,null,null,null,"Yes",null,null,null,null,"Yes",null,null,"4.3.2.5"]
[]
[null,"Have orientation-specific total heat gains been documented for all eight orientations?",null,null,null,null,null,null,null,null,"Yes",null,null,null,null,{"$f":"K58","v":"Yes"},null,null,"4.3.2.6"]
[]
["For A Dwelling / Sleeping Unit in a Multifamily Building w/ Heat Gain >18 kBTUh or Heat Loss >35 kBTUh",null,null,null,null,null,null,null,null,null,null,null,null,"Complete this section?",null,{"$f":"IF($E$10=\"Unit in a multifamily building w/ heat gain >18 kBTUh or heat loss >35 kBTUh\",\"Yes\",\"No\")","v":"No"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Required data inputs provided? ",{"$f":"IF(P60=\"No\",\"N/A\",IF(ISBLANK(I70)+ISBLANK(N71)+ISBLANK(I75)+ISBLANK(N76)>0,\"No\",\"Yes\"))","v":"N/A"}]
[null,null,null,null,null,null,null,null,"Plan Review",null,null,null,null,"Field Review"]
[null,"Building ID, Architectural Plan, & Options"]
[null,"Does the unique identifier for the building that the Home is in match the HVAC design?",null,null,null,null,null,null,null,null,"Yes",null,null,null,null,"Yes",null,null,"4.3.3.1"]
[null,"Does the name of the plan for the Home match the HVAC design?",null,null,null,null,null,null,null,null,"Yes",null,null,null,null,"Yes",null,null,"4.3.3.2"]
[null,"Do the options used in the Home match those in the HVAC design, \nor are they listed in the options the HVAC design can be used with?",null,null,null,null,null,null,null,null,"Yes",null,null,null,null,"Yes",null,null,"4.3.3.3"]
[]
[]
[null,"Conditioned Floor Area of Heating / Cooling Zones",null,null,null,null,null,null,"Zone 1","Zone 2","Zone 3",null,null,"Zone 1","Zone 2","Zone 3",null,null,"4.3.3.4"]
[null,"HVAC Design",null,null,null,null,null,null,null,null,null,null,null,{"$f":"I70","v":0},{"$f":"J70","v":0},{"$f":"K70","v":0},null,"Sq. Ft. "]
[null,"Home",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sq. Ft. "]
[null,"Home is between 300 sq. ft. smaller & 100 sq. ft.  larger than HVAC design?",null,null,null,null,null,null,{"$f":"IF(OR((I71-I70)<-300,(I71-I70)>100)=TRUE,\"No\",\"Yes\")","v":"Yes"},{"$f":"IF(OR((J71-J70)<-300,(J71-J70)>100)=TRUE,\"No\",\"Yes\")","v":"Yes"},{"$f":"IF(OR((K71-K70)<-300,(K71-K70)>100)=TRUE,\"No\",\"Yes\")","v":"Yes"},null,null,{"$f":"IF(OR((N71-N70)<-300,(N71-N70)>100)=TRUE,\"No\",\"Yes\")","v":"Yes"},{"$f":"IF(OR((O71-O70)<-300,(O71-O70)>100)=TRUE,\"No\",\"Yes\")","v":"Yes"},{"$f":"IF(OR((P71-P70)<-300,(P71-P70)>100)=TRUE,\"No\",\"Yes\")","v":"Yes"}]
[]
[null,"Window Area of Heating / Cooling Zones",null,null,null,null,null,null,"Zone 1","Zone 2","Zone 3",null,null,"Zone 1","Zone 2","Zone 3",null,null,"4.3.3.5"]
[null,"HVAC Design",null,null,null,null,null,null,null,null,null,null,null,{"$f":"I75","v":0},{"$f":"J75","v":0},{"$f":"K75","v":0},null,"Sq. Ft. "]
[null,"Home",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sq. Ft. "]
[null,"Home is between 60 sq. ft. smaller & 15 sq. ft. larger than HVAC design, \nor for zones with > 500 sq. ft. of windows, between 12% smaller and 3% larger?",null,null,null,null,null,null,{"$f":"IF(I76<=500,IF(OR((I76-I75)<-60,(I76-I75)>15)=TRUE,\"No\",\"Yes\"),IF(OR((I76-I75)/I75<-12%,(I76-I75)/I75>3%)=TRUE,\"No\",\"Yes\"))","v":"Yes"},{"$f":"IF(J76<=500,IF(OR((J76-J75)<-60,(J76-J75)>15)=TRUE,\"No\",\"Yes\"),IF(OR((J76-J75)/J75<-12%,(J76-J75)/J75>3%)=TRUE,\"No\",\"Yes\"))","v":"Yes"},{"$f":"IF(K76<=500,IF(OR((K76-K75)<-60,(K76-K75)>15)=TRUE,\"No\",\"Yes\"),IF(OR((K76-K75)/K75<-12%,(K76-K75)/K75>3%)=TRUE,\"No\",\"Yes\"))","v":"Yes"},null,null,{"$f":"IF(N76<=500,IF(OR((N76-N75)<-60,(N76-N75)>15)=TRUE,\"No\",\"Yes\"),IF(OR((N76-N75)/N75<-12%,(N76-N75)/N75>3%)=TRUE,\"No\",\"Yes\"))","v":"Yes"},{"$f":"IF(O76<=500,IF(OR((O76-O75)<-60,(O76-O75)>15)=TRUE,\"No\",\"Yes\"),IF(OR((O76-O75)/O75<-12%,(O76-O75)/O75>3%)=TRUE,\"No\",\"Yes\"))","v":"Yes"},{"$f":"IF(P76<=500,IF(OR((P76-P75)<-60,(P76-P75)>15)=TRUE,\"No\",\"Yes\"),IF(OR((P76-P75)/P75<-12%,(P76-P75)/P75>3%)=TRUE,\"No\",\"Yes\"))","v":"Yes"}]
[]
[]
[null,"Heating / Cooling Loads Methodology and Orientations",null,null,null,null,null,null,"Zone 1","Zone 2","Zone 3",null,null,"Zone 1","Zone 2","Zone 3"]
[null,"In HVAC Design, is the max. minus min. total heat gain across orientations ≤ 6 kBtuh?",null,null,null,null,null,null,"N/A","N/A","N/A",null,null,{"$f":"I81","v":"N/A"},{"$f":"J81","v":"N/A"},{"$f":"K81","v":"N/A"},null,null,"4.3.3.7"]
[]
[null,"Does front orientation of the Home match one of the orientations in the HVAC design?",null,null,null,null,null,null,null,null,"Yes",null,null,null,null,"Yes",null,null,"4.3.3.6"]
[]
["For All Dwellings, Townhouses, Dwelling Units, and Sleeping Units",null,null,null,null,null,null,null,null,null,null,null,null,"Complete this section?",null,"Yes"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Required data inputs provided? ",{"$f":"IF(P85=\"No\",\"N/A\",IF(ISBLANK(K96)+ISBLANK(P97)+ISBLANK(I102)+ISBLANK(N103)+ISBLANK(I107)+ISBLANK(N108)+ISBLANK(I112)+ISBLANK(N113)+ISBLANK(I128)+ISBLANK(I129)+ISBLANK(I139)+AND(I118=\"\",I123=\"N/A\")+AND(N119=\"\",N124=\"\")>0,\"No\",\"Yes\"))","v":"No"}]
[null,null,null,null,null,null,null,null,"Plan Review",null,null,null,null,"Field Review"]
[null,"Design Documentation"]
[null,"Has all required design documentation been collected, or an IVR obtained? ",null,null,null,null,null,null,null,null,"Yes",null,null,null,null,{"$f":"K89","v":"Yes"},null,null,4.3]
[]
[null,"Design Temperatures"]
[null,"Are indoor design temps in HVAC design 70°F for heating season & 75°F for cooling season?",null,null,null,null,null,null,null,null,"Yes",null,null,null,null,{"$f":"K92","v":"Yes"},null,null,"4.3.5"]
[null,"Are outdoor design temps in HVAC design within limits defined in Appendix A?",null,null,null,null,null,null,null,null,"Yes",null,null,null,null,{"$f":"K93","v":"Yes"},null,null,"4.3.6"]
[]
[null,"Number of Occupants",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"4.3.7"]
[null,"Number of occupants used in HVAC design across all zones:",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"K96","v":0}]
[null,"Number of bedrooms in Home:"]
[null,"Number of occupants in Home:",null,null,null,null,null,null,null,null,{"$f":"K97+1","v":1},null,null,null,null,{"$f":"P97+1","v":1}]
[null,"Number of occupants in Home within ±2 of occupants in HVAC Design?",null,null,null,null,null,null,null,null,{"$f":"IF(ABS(K96-K98)<=2,\"Yes\",\"No\")","v":"Yes"},null,null,null,null,{"$f":"IF(ABS(P96-P98)<=2,\"Yes\",\"No\")","v":"Yes"}]
[]
[null,"Window SHGC",null,null,null,null,null,null,"Zone 1","Zone 2","Zone 3",null,null,"Zone 1","Zone 2","Zone 3",null,null,"4.3.8"]
[null,"Predominant window SHGC in HVAC design",null,null,null,null,null,null,null,null,null,null,null,{"$f":"I102","v":0},{"$f":"J102","v":0},{"$f":"K102","v":0}]
[null,"Predominant window SHGC in Home"]
[null,"Home is within ±0.1 of HVAC design?",null,null,null,null,null,null,{"$f":"IF(ABS(I103-I102)>0.1,\"No\",\"Yes\")","v":"Yes"},{"$f":"IF(ABS(J103-J102)>0.1,\"No\",\"Yes\")","v":"Yes"},{"$f":"IF(ABS(K103-K102)>0.1,\"No\",\"Yes\")","v":"Yes"},null,null,{"$f":"IF(ABS(N103-N102)>0.1,\"No\",\"Yes\")","v":"Yes"},{"$f":"IF(ABS(O103-O102)>0.1,\"No\",\"Yes\")","v":"Yes"},{"$f":"IF(ABS(P103-P102)>0.1,\"No\",\"Yes\")","v":"Yes"}]
[]
[null,"Above-Grade Wall Nominal R-Value",null,null,null,null,null,null,"Zone 1","Zone 2","Zone 3",null,null,"Zone 1","Zone 2","Zone 3",null,null,"4.3.9"]
[null,"Predominant wall R-value in HVAC design",null,null,null,null,null,null,null,null,null,null,null,{"$f":"I107","v":0},{"$f":"J107","v":0},{"$f":"K107","v":0}]
[null,"Predominant wall R-value in Home"]
[null,"Home is within ±R-2 of HVAC design?",null,null,null,null,null,null,{"$f":"IF(ABS(I108-I107)>2,\"No\",\"Yes\")","v":"Yes"},{"$f":"IF(ABS(J108-J107)>2,\"No\",\"Yes\")","v":"Yes"},{"$f":"IF(ABS(K108-K107)>2,\"No\",\"Yes\")","v":"Yes"},null,null,{"$f":"IF(ABS(N108-N107)>2,\"No\",\"Yes\")","v":"Yes"},{"$f":"IF(ABS(O108-O107)>2,\"No\",\"Yes\")","v":"Yes"},{"$f":"IF(ABS(P108-P107)>2,\"No\",\"Yes\")","v":"Yes"}]
[]
[null,"Ceiling Nominal R-Value",null,null,null,null,null,null,"Zone 1","Zone 2","Zone 3",null,null,"Zone 1","Zone 2","Zone 3",null,null,"4.3.10"]
[null,"Predominant ceiling R-value in HVAC design",null,null,null,null,null,null,null,null,null,null,null,{"$f":"I112","v":0},{"$f":"J112","v":0},{"$f":"K112","v":0}]
[null,"Predominant ceiling R-value in Home"]
[null,"Home is within ±R-4 of HVAC design?",null,null,null,null,null,null,{"$f":"IF(ABS(I113-I112)>4,\"No\",\"Yes\")","v":"Yes"},{"$f":"IF(ABS(J113-J112)>4,\"No\",\"Yes\")","v":"Yes"},{"$f":"IF(ABS(K113-K112)>4,\"No\",\"Yes\")","v":"Yes"},null,null,{"$f":"IF(ABS(N113-N112)>4,\"No\",\"Yes\")","v":"Yes"},{"$f":"IF(ABS(O113-O112)>4,\"No\",\"Yes\")","v":"Yes"},{"$f":"IF(ABS(P113-P112)>4,\"No\",\"Yes\")","v":"Yes"}]
[]
[null,"Infiltration Rate",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"4.3.11"]
[null,"Using Quantitative HVAC Design Value",null,null,null,null,null,null,"Zone 1","Zone 2","Zone 3",null,null,"Zone 1","Zone 2","Zone 3"]
[null,"Infiltration rate used in HVAC design",null,null,null,null,null,null,null,null,null,null,null,{"$f":"I118","v":0},{"$f":"J118","v":0},{"$f":"K118","v":0},null,"ACH50"]
[null,"Infiltration rate of Home",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ACH50"]
[null,"Home is within ±2.0 of HVAC design?",null,null,null,null,null,null,{"$f":"IF(ABS(I119-I118)>2,\"No\",\"Yes\")","v":"Yes"},{"$f":"IF(ABS(J119-J118)>2,\"No\",\"Yes\")","v":"Yes"},{"$f":"IF(ABS(K119-K118)>2,\"No\",\"Yes\")","v":"Yes"},null,null,{"$f":"IF(ABS(N119-N118)>2,\"No\",\"Yes\")","v":"Yes"},{"$f":"IF(ABS(O119-O118)>2,\"No\",\"Yes\")","v":"Yes"},{"$f":"IF(ABS(P119-P118)>2,\"No\",\"Yes\")","v":"Yes"}]
[]
[null,"Using Qualitative HVAC Design Value",null,null,null,null,null,null,"Zone 1","Zone 2","Zone 3",null,null,"Zone 1","Zone 2","Zone 3"]
[null,"Infiltration rate used in HVAC design",null,null,null,null,null,null,"N/A","N/A","N/A",null,null,{"$f":"I123","v":"N/A"},{"$f":"J123","v":"N/A"},{"$f":"K123","v":"N/A"}]
[null,"Infiltration rate of Home",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ACH50"]
[null,"Home is within Table 1 tolerance for input used in HVAC design?",null,null,null,null,null,null,{"$f":"IF(AND(I123=\"Tight\",I124>=0,I124<=4),\"Yes\",IF(AND(I123=\"Semi-Tight\",I124>=1,I124<=5),\"Yes\",IF(AND(I123=\"Average\",I124>=3,I124<=7),\"Yes\",IF(AND(I123=\"Semi-Leaky\",I124>=7,I124<=11),\"Yes\",IF(AND(I123=\"Leaky\",I124>=11),\"Yes\",IF(I123=\"N/A\",\"N/A\",\"No\"))))))","v":"N/A"},{"$f":"IF(AND(J123=\"Tight\",J124>=0,J124<=4),\"Yes\",IF(AND(J123=\"Semi-Tight\",J124>=1,J124<=5),\"Yes\",IF(AND(J123=\"Average\",J124>=3,J124<=7),\"Yes\",IF(AND(J123=\"Semi-Leaky\",J124>=7,J124<=11),\"Yes\",IF(AND(J123=\"Leaky\",J124>=11),\"Yes\",IF(J123=\"N/A\",\"N/A\",\"No\"))))))","v":"N/A"},"N/A",null,null,{"$f":"IF(AND(N123=\"Tight\",N124>=0,N124<=4),\"Yes\",IF(AND(N123=\"Semi-Tight\",N124>=1,N124<=5),\"Yes\",IF(AND(N123=\"Average\",N124>=3,N124<=7),\"Yes\",IF(AND(N123=\"Semi-Leaky\",N124>=7,N124<=11),\"Yes\",IF(AND(N123=\"Leaky\",N124>=11),\"Yes\",IF(N123=\"N/A\",\"N/A\",\"No\"))))))","v":"N/A"},"N/A","N/A"]
[]
[null,"Mechanical Ventilation System Design Airflow Rate",null,null,null,null,null,null,"Zone 1","Zone 2","Zone 3",null,null,"Zone 1","Zone 2","Zone 3",null,null,"4.3.12"]
[null,"HVAC design's time-averaged vent. rate, for each ventilation zone",null,null,null,null,null,null,null,null,null,null,null,{"$f":"I128","v":0},0,0]
[null,"HVAC design's time-averaged vent. rate used in loads, for each heating / cooling zone ",null,null,null,null,null,null,null,null,null,null,null,0,0,0]
[]
[null,"Is the sum of the time-averaged design vent. rate across all vent. zones equal to the sum of the time-averaged design vent. rate used in the loads across all heated / cooled zones?",null,null,null,null,null,null,null,null,{"$f":"IF(SUM(I128:K128)=SUM(I129:K129),\"Yes\",\"No\")","v":"Yes"},null,null,null,null,{"$f":"K131","v":"Yes"}]
[]
[]
[null,"HVAC System Equipment Types and Heating / Cooling Zones Served"]
[null,"Does each HVAC system in the Home serve the zone(s) specified in the HVAC design?",null,null,null,null,null,null,null,null,"Yes",null,null,null,null,"Yes",null,null,"4.3.13"]
[null,"Does each HVAC System in Home match the equipment type specified in the HVAC design?",null,null,null,null,null,null,null,null,"Yes",null,null,null,null,"Yes",null,null,"4.3.14"]
[]
[null,"Design Airflows",null,null,null,null,null,null,"System 1","System 2","System 3",null,null,"System 1","System 2","System 3"]
[null,"In HVAC design, sum of design airflows across all rooms",null,null,null,null,null,null,null,null,null,null,null,{"$f":"I139","v":0},0,0,null,"CFM","4.3.15"]
[null,"In HVAC design, design airflow of system in cooling mode (if applicable)",null,null,null,null,null,null,null,null,null,null,null,0,0,0,null,"CFM"]
[null,"In HVAC design, design airflow of system in heating mode (if applicable)",null,null,null,null,null,null,null,null,null,null,null,0,0,0,null,"CFM"]
[null,"Does the sum of design airflows across all rooms equal airflow of mode with higher airflow?",null,null,null,null,null,null,{"$f":"IF(I139=MAX(I140:I141),\"Yes\",\"No\")","v":"Yes"},{"$f":"IF(J139=MAX(J140:J141),\"Yes\",\"No\")","v":"Yes"},"Yes",null,null,{"$f":"I142","v":"Yes"},{"$f":"J142","v":"Yes"},"Yes"]
[]
["Compliance with Design Review Criteria"]
[]
[null,"Have all required design review criteria been verified for:"]
[null,null,"A dwelling or townhouse or unit within (e.g., duplex)",null,null,null,null,null,"For plan review:",null,{"$f":"IF($E$10=\"Dwelling or townhouse or unit within\",IF(COUNTIF(H16:K35,\"No\")>0,\"No\",\"Yes\"),\"N/A\")","v":"Yes"},null,null,"For field review:",null,{"$f":"IF($E$10=\"Dwelling or townhouse or unit within\",IF(COUNTIF(M13:P35,\"No\")>0,\"No\",\"Yes\"),\"N/A\")","v":"No"}]
[null,null,"A unit in a multifamily building w/ heat gain ≤18 kBTUh & heat loss ≤35 kBTUh",null,null,null,null,null,"For plan review:",null,{"$f":"IF($E$10=\"Unit in a multifamily building w/ heat gain ≤18 kBTUh & heat loss ≤35 kBTUh\",IF(COUNTIF(H41:K58,\"No\")>0,\"No\",\"Yes\"),\"N/A\")","v":"N/A"},null,null,"For field review:",null,{"$f":"IF($E$10=\"Unit in a multifamily building w/ heat gain ≤18 kBTUh & heat loss ≤35 kBTUh\",IF(COUNTIF(M38:P58,\"No\")>0,\"No\",\"Yes\"),\"N/A\")","v":"N/A"}]
[null,null,"A unit in a multifamily building w/ heat gain >18 kBTUh or heat loss >35k BTUh",null,null,null,null,null,"For plan review:",null,{"$f":"IF($E$10=\"Unit in a multifamily building w/ heat gain >18 kBTUh or heat loss >35 kBTUh\",IF(COUNTIF(H64:K83,\"No\")>0,\"No\",\"Yes\"),\"N/A\")","v":"N/A"},null,null,"For field review:",null,{"$f":"IF($E$10=\"Unit in a multifamily building w/ heat gain >18 kBTUh or heat loss >35 kBTUh\",IF(COUNTIF(M61:P83,\"No\")>0,\"No\",\"Yes\"),\"N/A\")","v":"N/A"}]
[null,null,"All Dwellings, Townhouses, Dwelling Units, and Sleeping Units",null,null,null,null,null,"For plan review:",null,{"$f":"IF(COUNTIF(I89:K142,\"No\")>0,\"No\",\"Yes\")","v":"Yes"},null,null,"For field review:",null,{"$f":"IF(COUNTIF(N86:P142,\"No\")>0,\"No\",\"Yes\")","v":"No"}]
[null,"Is design review complete?",null,null,null,null,null,null,"For plan review:",null,{"$f":"IF(K150=\"No\",\"No\",IF(E10=\"Dwelling or townhouse or unit within\",IF(K147=\"No\",\"No\",\"Yes\"),IF(E10=\"Unit in a multifamily building w/ heat gain ≤18 kBTUh & heat loss ≤35 kBTUh\",IF(K148=\"No\",\"No\",\"Yes\"),IF(E10=\"Unit in a multifamily building w/ heat gain >18 kBTUh or heat loss >35 kBTUh\",IF(K149=\"No\",\"No\",\"Yes\"),\"Error\"))))","v":"Yes"},null,null,"For field review:",null,{"$f":"IF(P150=\"No\",\"No\",IF(E10=\"Dwelling or townhouse or unit within\",IF(P147=\"No\",\"No\",\"Yes\"),IF(E10=\"Unit in a multifamily building w/ heat gain ≤18 kBTUh & heat loss ≤35 kBTUh\",IF(P148=\"No\",\"No\",\"Yes\"),IF(E10=\"Unit in a multifamily building w/ heat gain >18 kBTUh or heat loss >35 kBTUh\",IF(P149=\"No\",\"No\",\"Yes\"),\"Error\"))))","v":"No"}]

{"sheet":"2. Total Duct Leakage","index":3,"n_rows":25,"n_cols":13,"rows_kept":25,"cut":false,"hidden":false,"merged":[[20,2,21,3],[7,1,8,6],[0,9,1,9],[3,1,4,6]]}
["Standard 310 Data Tool:",null,null,null,null,null,null,null,null,"Section Reference"]
["Evaluation of the Total Duct Leakage",null,null,null,null,null,null,null,null,null,null,"Formatting Legend"]
["Prerequisites",null,null,null,null,null,null,null,null,null,null,123,"User Input"]
[null,"All required design documentation collected, reviewed, and verified to be in accordance with Section 4.3, or an IVR obtained.",null,null,null,null,null,{"$f":"'1. HVAC Design Review'!P151","v":"No"},null,5.2,null,123,"User input is out of range specified by the standard"]
[null,null,null,null,null,null,null,null,null,null,null,123,"Calculated value"]
[]
["Test Method"]
[null,"Does the system have a total amount of supply ductwork or distribution building cavities that is > 10 total linear feet?",null,null,null,null,null,"Yes",null,5.3]
[]
[null,"Is the system entirely in Conditioned Space Volume?",null,null,null,null,null,"No",null,5.3]
[null,"Is testing required?",null,null,null,null,null,{"$f":"IF(AND(H8=\"No\",H10=\"Yes\"),\"No\",\"Yes\")","v":"Yes"},null,5.3]
[null,"Was total duct leakage test exemption taken?",null,null,null,null,null,"No",null,5.3]
[null,"Did testing occur at rough-in or final?",null,null,null,null,null,"Rough-in",null,5.3]
[null,"Enter the number of returns in the system",null,null,null,null,null,null,null,5.3]
[null,"Enter the Conditioned Floor Area served by the system",null,null,null,null,null,null,"Sq. Ft. "]
[null,"Enter the total duct leakage of the system",null,null,null,null,null,null,"CFM25",5.3]
[null,"Total duct leakage per 100 sq. ft. of CFA served by system",null,null,null,null,null,{"$f":"H16/(H15/100)","v":{"$error":"#DIV/0!"}},"CFM25/100 Sq. Ft."]
[]
[null,"Total Duct Leakage Grade Designation:",null,null,null,null,null,{"$f":"IF(AND(H4=\"Yes\",H8=\"No\",H10=\"Yes\",H12=\"Yes\"),\"Grade I\",IF(AND(H4=\"Yes\",H16<=C23),\"Grade I\",IF(AND(H4=\"Yes\",H16<=C24),\"Grade II\",\"Grade III\")))","v":"Grade III"}]
[]
[null,null,"Leakage Limit for This System"]
[null,"Grade"]
[null,"I",{"$f":"IF($H$14<3,IF($H$13=\"Rough-in\",MAX(40,4*$H$15/100),MAX(80,8*$H$15/100)),IF($H$13=\"Rough-in\",MAX(60,6*$H$15/100),MAX(120,12*$H$15/100)))","v":40},"CFM25"]
[null,"II",{"$f":"IF($H$14<3,IF($H$13=\"Rough-in\",MAX(60,6*$H$15/100),MAX(100,10*$H$15/100)),IF($H$13=\"Rough-in\",MAX(80,8*$H$15/100),MAX(140,14*$H$15/100)))","v":60},"CFM25"]
[null,"III",{"$f":"C24","v":60},"CFM25"]

{"sheet":"3. Blower Fan Airflow","index":4,"n_rows":79,"n_cols":13,"rows_kept":79,"cut":false,"hidden":false,"merged":[[20,7,20,8],[60,1,63,6],[66,1,68,6],[44,1,45,3],[0,9,1,9],[14,1,15,6],[50,1,52,6]]}
["Standard 310 Data Tool:",null,null,null,null,null,null,null,null,"Section Reference"]
["Evaluation of the Blower Fan Volumetric Airflow ",null,null,null,null,null,null,null,null,null,null,"Formatting Legend"]
["Prerequisites",null,null,null,null,null,null,null,null,null,null,123,"User Input"]
[null,"Did total duct leakage achieve Grade I or II designation?",null,null,null,null,null,{"$f":"IF(OR('2. Total Duct Leakage'!H19=\"Grade I\",'2. Total Duct Leakage'!H19=\"Grade II\"),\"Yes\",\"No\")","v":"No"},null,"6.2.1",null,123,"User input is out of range specified by the standard"]
[null,"HVAC equipment is operational & matches specification?",null,null,null,null,null,"Yes",null,"6.2.2.1",null,123,"Calculated value"]
[null,"If specified, mech. vent. system is operational & matches specification?",null,null,null,null,null,"Yes",null,"6.2.2.2"]
[null,"If specified, distribution system installed, including registers & grilles?",null,null,null,null,null,"Yes",null,"6.2.2.3"]
[null,"If specified, filter installed & matches specified performance rating?",null,null,null,null,null,"Yes",null,"6.2.2.4"]
[null,"Have prerequisites been met?",null,null,null,null,null,{"$f":"IF(OR(H5=\"No\",H4=\"No\",H6=\"No\",H7=\"No\",H8=\"No\"),\"No\",\"Yes\")","v":"No"}]
[]
["Information from HVAC Design Report"]
[null,"Enter design-specified blower fan airflow (Qdesign)",null,null,null,null,null,null,"CFM","4.2.5.5.1"]
[]
["Test Method Selection"]
[null,"Does the system have a total amount of supply ductwork or distribution building cavities that is > 10 total linear feet?",null,null,null,null,null,{"$f":"'2. Total Duct Leakage'!H8","v":"Yes"},null,"6.3.1.1"]
[]
[null,"Is the system entirely in Conditioned Space Volume?",null,null,null,null,null,{"$f":"'2. Total Duct Leakage'!H10","v":"No"},null,"6.3.1.1"]
[null,"Is testing required?",null,null,null,null,null,{"$f":"IF(AND(H15=\"No\",H17=\"Yes\"),\"No\",\"Yes\")","v":"Yes"},null,"6.3.1.1"]
[null,"Was blower fan airflow test exemption taken?",null,null,null,null,null,"No",null,"6.3.1.1"]
[null,"What Grade designation did total duct leakage achieve (I or II)?",null,null,null,null,null,{"$f":"'2. Total Duct Leakage'!H19","v":"Grade III"}]
[null,"If testing is required and pre-reqs met, select one airflow test method.",null,null,null,null,null,"Flow Hood",null,"6.3.1.3"]
[]
["Dwelling and Forced-Air HVAC System Set Up"]
[null,"Dwelling and forced-air HVAC system set up per Section 6.4?",null,null,null,null,null,"Yes",null,6.4]
[null,"Enter mode that forced-air HVAC system was tested in",null,null,null,null,null,"Cooling",null,"6.4.5"]
[]
["Complete One of Four Test Methods, Per Selection Above"]
[null,"Pressure Matching Method - Rater Measurements & Calculation"]
[null,"Enter Psop - pressure of the supply-side under normal operation",null,null,null,null,null,null,"Pa","6.5.2.4"]
[null,"Was there turbulence (fluctuations >0.05 IWC) when measuring Psop?",null,null,null,null,null,"No",null,"6.5.2.4"]
[null,"Enter Fan Flowmeter location (at blower compartment or at return grille)",null,null,null,null,null,"Return Grille",null,"6.5.2.5"]
[null,"Enter Ptest - pressure of the supply-side during test",null,null,null,null,null,null,"Pa","6.5.2.7"]
[null,"Enter Qtest - the airflow through Fan Flowmeter",null,null,null,null,null,null,"CFM","6.5.2.7"]
[null,"Blower fan airflow at operating conditions (Qop)",null,null,null,null,null,{"$f":"H33*((IF(I29=\"Pa\",H29*0.0040146,H29)/IF(I32=\"Pa\",H32*0.0040146,H32))^0.5)","v":{"$error":"#DIV/0!"}},"CFM","6.5.2.8"]
[]
[null,"Flow Grid - Rater Measurements & Calculation"]
[null,"Enter Psop - pressure of the supply-side under normal operation",null,null,null,null,null,null,"Pa","6.6.2.4"]
[null,"Was there turbulence (fluctuations >0.05 IWC) when measuring Psop?",null,null,null,null,null,"No",null,"6.6.2.4"]
[null,"Enter Ptest - pressure of the supply-side during test",null,null,null,null,null,null,"Pa","6.6.2.6"]
[null,"Enter Qtest - the airflow through Flow Grid",null,null,null,null,null,null,"CFM","6.6.2.7"]
[null,"Blower fan airflow at operating conditions (Qop)",null,null,null,null,null,{"$f":"H40*((IF(I37=\"Pa\",H37*0.0040146,H37)/IF(I39=\"Pa\",H39*0.0040146,H39))^0.5)","v":{"$error":"#DIV/0!"}},"CFM","6.6.2.8"]
[]
[null,"Flow Hood - Rater Measurements & Calculation"]
[null,"Enter Qtest - Airflow through Airflow Meter",null,null,null,null,"Return #1",null,"CFM","6.7.2.1.2"]
[null,"(# entries should correspond with # of returns for system under test)",null,null,null,null,"Return #2",null,"CFM"]
[null,null,null,null,null,null,"Return #3",null,"CFM"]
[null,null,null,null,null,null,"Return #4",null,"CFM"]
[null,"Blower fan airflow at operating conditions (Qop)",null,null,null,null,null,{"$f":"SUM(H44:H47)","v":0},"CFM","6.7.2.2"]
[]
[null,"OEM Static Pressure Table Method - Rater Measurements & Calculation"]
[null,"Blower fan motor type. \nNote: ECM/Other fan types can only be used at elevations >2,500 Ft if OEM provides instructions to account for elevation.",null,null,null,null,null,"PSC",null,"6.8.3.1"]
[]
[]
[null,"Enter observed fan-speed setting",null,null,null,null,null,null,null,"6.8.3.2"]
[null,"Enter Psop - pressure of the supply-side under normal operation",null,null,null,null,null,null,"Pa","6.8.3.7"]
[null,"Was there turbulence (fluctuations >0.05 IWC) when measuring Psop?",null,null,null,null,null,"Yes",null,"6.8.3.7"]
[null,"Enter Prop - pressure of the return-side under normal operation",null,null,null,null,null,null,"Pa","6.8.3.9"]
[null,"Was there turbulence (fluctuations >0.05 IWC) when measuring Prop?",null,null,null,null,null,"Yes",null,"6.8.3.9"]
[null,"Elevation above sea level",null,null,null,null,null,null,"Ft","6.8.3.10"]
[null,"Elevation Adjustment Factor (Padj)",null,null,null,null,null,{"$f":"IF(H51=\"PSC\",0.07517/(0.07517*(1-(0.0035666*H59)/528)^5.2553),1)","v":1},null,"6.8.3.10"]
[null,"Enter filter pressure drop accounted for in OEM Static Pressure Table (Pfilter). Enter 0 if Table does not account for filter, or is unclear about presence of filter. Enter 0.1 IWC if Table accounts for filter, but pressure drop is not specified.",null,null,null,null,null,null,"IWC","6.8.3.11"]
[]
[]
[]
[null,"Pressure difference for OEM Static Pressure Table (Ptop)",null,null,null,null,null,{"$f":"H60*(ABS(IF(I55=\"Pa\",H55*0.0040146,H55))+ABS(IF(I57=\"Pa\",H57*0.0040146,H57))-ABS(H61))","v":0},"IWC","6.8.3.11"]
[null,"Enter blower fan airflow at operating conditions (Qop)",null,null,null,null,null,null,"CFM","6.8.3.12"]
[null,"(Determine by looking up airflow on OEM Static Pressure Table using observed fan-speed setting (6.8.3.2) and Ptop (6.8.3.11), interpolating as necessary)"]
[]
[]
[]
["Fault and Grade Calculations"]
[null,"Final Blower fan airflow at operating conditions (Qop)",null,null,null,null,null,{"$f":"IF(H9=\"Yes\",IF(AND(H18=\"No\",H19=\"Yes\"),0,IF(H21=\"Pressure Matching\",(H34),IF(H21=\"Flow Grid\",(H41),IF(H21=\"Flow Hood\",(H48),IF(H21=\"Static Pressure Table\",(H66)))))),\"Prereq Not Met\")","v":"Prereq Not Met"},"CFM"]
[null,"FAF (i.e., Fault)",null,null,null,null,null,{"$f":"IF(H9=\"Yes\",IF(AND(H18=\"No\",H19=\"Yes\"),0,IF(H21=\"Pressure Matching\",(H34-H12)/H12,IF(H21=\"Flow Grid\",(H41-H12)/H12,IF(H21=\"Flow Hood\",(H48-H12)/H12,IF(H21=\"Static Pressure Table\",(H66-H12)/H12))))),\"Prereq Not Met\")","v":"Prereq Not Met"},null,"6.9.1"]
[null,"Blower fan volumetric airflow grade",null,null,null,null,null,{"$f":"IF(AND(H18=\"No\",H19=\"Yes\"),\"Grade I\",IF(H9=\"Yes\",IF(ABS(H73)<H77/100,\"Grade I\",IF(ABS(H73)<H78/100,\"Grade II\",\"Grade III\")),\"Grade III\"))","v":"Grade III"},null,"6.9.2"]
[]
[null,"Grade","Range",null,null,null,null,"Qdev Max"]
[null,"I","≤ 0 and > -15%",null,null,"or","≥ 0 and < +15%",15]
[null,"II","≤ -15% and > -25%",null,null,"or","≥ +15% and < +25%",25]
[null,"III","≤ -25%",null,null,"or","≥ +25%","n/a"]

{"sheet":"4. Blower Fan Watt Draw","index":5,"n_rows":38,"n_cols":13,"rows_kept":38,"cut":false,"hidden":false,"merged":[[10,7,10,8],[0,9,1,9],[14,9,15,9],[17,9,18,9]]}
["Standard 310 Data Tool:",null,null,null,null,null,null,null,null,"Section Reference"]
["Evaluation of the Blower Fan Watt Draw",null,null,null,null,null,null,null,null,null,null,"Formatting Legend"]
["Prerequisites",null,null,null,null,null,null,null,null,null,null,123,"User Input"]
[null,"Did blower fan airflow achieve Grade I or II designation?",null,null,null,null,null,{"$f":"IF('3. Blower Fan Airflow'!H74=\"Grade III\",\"No\",\"Yes\")","v":"No"},null,7.2,null,123,"User input is out of range specified by the standard"]
[null,null,null,null,null,null,null,null,null,null,null,123,"Calculated value"]
["Dwelling and Forced-Air HVAC System Set Up"]
[null,"Dwelling and forced-air HVAC system set up per Section 7.3?",null,null,null,null,null,"Yes",null,7.3]
[null,"Enter mode that forced-air HVAC system was tested in",null,null,null,null,null,"Cooling",null,"7.3.2"]
[]
["Test Method Selection"]
[null,"Select one test method for measuring blower fan watt draw",null,null,null,null,null,"Portable Plug-In Watt Meter"]
[]
["Complete One of Four Test Methods, Per Selection Above"]
[null,"Portable Plug-In Watt Meter"]
[null,"Enter Wfan, watt draw of blower fan",null,null,null,null,null,null,"Watts","7.4.2.3"]
[]
[null,"Clamp-On Watt Meter"]
[null,"Enter Wfan, watt draw of blower fan",null,null,null,null,null,null,"Watts","7.5.2.4.1.3 or 7.5.2.4.2.3"]
[]
[null,"Utility Revenue Meter"]
[null,"Enter Kh factor on revenue meter",null,null,null,null,null,null,null,"7.6.2.3"]
[null,"Enter Nrev - number of revolutions during period",null,null,null,null,null,null,"Revs.","7.6.2.4"]
[null,"Enter Trev - duration of period (must be ≥ 90 seconds)",null,null,null,null,null,null,"Seconds","7.6.2.4"]
[null,"Blower fan watt draw at operating conditions (Wfan)",null,null,null,null,null,{"$f":"H21*H22*3600/H23","v":{"$error":"#DIV/0!"}},"Watts","7.6.2.5"]
[]
[null,"Digital Utility Revenue Meter"]
[null,"Enter Wfan, watt draw of blower fan",null,null,null,null,null,null,"Watts","7.7.2.3"]
[]
["Fault and Grade Calculations"]
[null,"Blower fan airflow",null,null,null,null,null,{"$f":"IF('3. Blower Fan Airflow'!H21:I21=\"Pressure Matching\",'3. Blower Fan Airflow'!H34,IF('3. Blower Fan Airflow'!H21:I21=\"Flow Grid\",'3. Blower Fan Airflow'!H41,IF('3. Blower Fan Airflow'!H21:I21=\"Flow Hood\",'3. Blower Fan Airflow'!H48,IF('3. Blower Fan Airflow'!H21:I21=\"Static Pressure Table\",'3. Blower Fan Airflow'!H66))))","v":0},"CFM","7.8.1"]
[null,"Final Blower fan watt draw at operating conditions (Wfan)",null,null,null,null,null,{"$f":"IF(AND(H4=\"Yes\",'3. Blower Fan Airflow'!H73<>\"Prereq Not Met\"),IF(H11=\"Portable Plug-In Watt Meter\",H15,IF(H11=\"Clamp-On Watt Meter\",H18,IF(H11=\"Utility Revenue Meter\",H24,IF(H11=\"Digital Utility Revenue Meter\",H27,)))),\"Prereq Not Met\")","v":"Prereq Not Met"},"Watts"]
[null,"Blower fan efficiency",null,null,null,null,null,{"$f":"IF(AND(H4=\"Yes\",'3. Blower Fan Airflow'!H73<>\"Prereq Not Met\"),IF(H11=\"Portable Plug-In Watt Meter\",H15,IF(H11=\"Clamp-On Watt Meter\",H18,IF(H11=\"Utility Revenue Meter\",H24,IF(H11=\"Digital Utility Revenue Meter\",H27,))))/H30,\"Prereq Not Met\")","v":"Prereq Not Met"},"W / CFM","7.8.1"]
[null,"Blower fan watt draw grade",null,null,null,null,null,{"$f":"IF(H4=\"Yes\",IF(H32>F37,\"Grade III\",IF(H32>F36,\"Grade II\",\"Grade I\")),\"Grade III\")","v":"Grade III"},null,"7.8.2"]
[]
[null,"Grade","Range",null,null,"Max Eff."]
[null,"I",{"$f":"\"≤ \"&F36","v":"≤ 0.45"},null,null,0.45]
[null,"II",{"$f":"\"> \"&F36&\" and ≤ \"&F37","v":"> 0.45 and ≤ 0.58"},null,null,0.57999999999999996]
[null,"III",{"$f":"\"> \"&F37","v":"> 0.58"},null,null,"n/a"]

{"sheet":"5. Refrigerant Charge","index":6,"n_rows":106,"n_cols":13,"rows_kept":106,"cut":false,"hidden":false,"merged":[[86,3,86,4],[87,3,87,4],[91,3,91,4],[92,3,92,4],[93,3,93,4],[0,9,1,9],[21,9,22,9],[30,1,32,6],[66,1,67,6],[85,3,85,4]]}
["Standard 310 Data Tool:",null,null,null,null,null,null,null,null,"Section Reference"]
["Evaluation of the Refrigerant Charge",null,null,null,null,null,null,null,null,null,null,"Formatting Legend"]
["Prerequisites",null,null,null,null,null,null,null,null,null,null,123,"User Input"]
[null,"Did blower fan airflow achieve Grade I or II designation?",null,null,null,null,null,{"$f":"IF(OR('3. Blower Fan Airflow'!H74=\"Grade I\",'3. Blower Fan Airflow'!H74=\"Grade II\"),\"Yes\",\"No\")","v":"No"},null,"8.2.1",null,123,"User input is out of range specified by the standard"]
[null,null,null,null,null,null,null,null,null,null,null,123,"Calculated value"]
["Test Method Selection"]
[null,"For Non-Invasive Method, enter measured outdoor air dry-bulb temperature",null,null,null,null,null,null,"F","8.3.2.1.1"]
[null,"For Non-Invasive Method, enter forced-air HVAC system type",null,null,null,null,null,"Other",null,"8.3.2.1.2"]
[null,"For Non-Invasive Method, enter equipment rated SEER",null,null,null,null,null,null,"SEER","8.3.2.1.3"]
[null,"Have prerequisites been met to use Non-Invasive Method?",null,null,null,null,null,{"$f":"IF(OR(AND(H8=\"Other\",H9<17,H7>=70,H7<=115),AND(H8=\"Other\",H9>=17,H7>=75,H7<=115)),\"Yes\",\"No\")","v":"No"},null,"8.3.2.1.4"]
[null,"Select test method",null,null,null,null,null,"Weigh-In",null,8.3000000000000007]
[]
["Non-Invasive Method"]
[null,"Dwelling and Forced-Air HVAC System Set Up"]
[null,"Dwelling and forced-air HVAC system set up per Section 8.4.1?",null,null,null,null,null,"Yes",null,"8.4.1"]
[]
[null,"Information from HVAC Design Report"]
[null,"Enter design cooling blower fan volumetric airflow",null,null,null,null,null,null,"CFM","8.4.3.8.1"]
[null,"Enter maximum total heat gain",null,null,null,null,null,null,"BTU/hr","8.4.3.8.1"]
[null,"Enter metering device",null,null,null,null,null,"Piston/Cap. Tube",null,"8.4.3.9"]
[null,"If metering device is TXV/EEV, then enter Target Subcooling",null,null,null,null,null,null,"F","8.4.3.10.1"]
[]
[null,"Enter Rater Field Measurements"]
[null,"Enter measured return air dry-bulb temperature",null,null,null,null,null,null,"F","8.4.3.3"]
[null,"Enter measured return air wet-bulb temperature",null,null,null,null,null,null,"F","8.4.3.3"]
[null,"Return air temperature measurements meet criteria? ",null,null,null,null,null,{"$f":"IF(AND(H24>=70,H24<=80,H25>=50),\"Yes\",\"No\")","v":"No"},null,"8.4.3.5"]
[null,"Enter measured outdoor air dry-bulb temperature",null,null,null,null,null,null,"F","8.4.3.6.1"]
[null,"Outdoor air temperature measurement meets criteria? ",null,null,null,null,null,{"$f":"IF(OR(AND(H9<17,H27>=70,H27<=115),AND(H9>=17,H27>=75,H27<=115)),\"Yes\",\"No\")","v":"No"},null,"8.4.3.6.1"]
[null,"Enter measured suction line temperature",null,null,null,null,null,null,"F","8.4.3.6.2"]
[null,"Enter measured liquid line temperature",null,null,null,null,null,null,"F","8.4.3.6.3"]
[null,"If metering device is Piston/Capillary Tube, then enter Target Superheat using OEM superheat chart or Std 310 Appendix B, for the given return air wet-bulb temp and outdoor air dry-bulb temp",null,null,null,null,null,null,"F","8.4.3.9.1"]
[]
[]
[]
[null,"If Available, Enter Contractor-Provided Commissioning Values"]
[null,"Did contractor provide site-specific installation values? ",null,null,null,null,null,"No"]
[null,"If Yes, enter their return air dry bulb temperature",null,null,null,null,null,null,"F","8.4.3.8.3"]
[null,"If Yes, enter their suction line saturation temperature",null,null,null,null,null,null,"F","8.4.3.8.3"]
[null,"If Yes, and metering device is TXV/EEV, then enter the following:",null,null,null,null,null,null,null,"8.4.3.10.2.2"]
[null,"Their outdoor air dry bulb temperature",null,null,null,null,null,null,"F","8.4.3.10.2.2"]
[null,"Their liquid line condensing temperature",null,null,null,null,null,null,"F","8.4.3.10.2.2"]
[]
[null,"Calculations for All Metering Devices"]
[null,"Qnorm - normalized airflow",null,null,null,null,null,{"$f":"(H18/H19)*12000","v":{"$error":"#DIV/0!"}},"CFM","8.4.3.8.1"]
[null,"DTD - Design Temp Difference",null,null,null,null,null,{"$f":"IF(H36=\"No\",IF(H44<375,40,IF(H44<=425,35,30)),IF(ABS(IF(H44<375,40,IF(H44<=425,35,30))-(H37-H38))<=3,H37-H38,IF(H44<375,40,IF(H44<=425,35,30))))","v":{"$error":"#DIV/0!"}},"F","8.4.3.8.4"]
[]
[null,"Calculations for Piston/Capillary Tube Metering Devices"]
[null,"Min liquid line temp",null,null,null,null,null,{"$f":"H27+3","v":3},"F","8.4.3.9.2"]
[null,"Max liquid line temp",null,null,null,null,null,{"$f":"H27+12","v":12},"F","8.4.3.9.3"]
[null,"Liquid line within target?",null,null,null,null,null,{"$f":"IF(OR(H30<H48,H30>H49),\"No\",\"Yes\")","v":"No"},null,"8.4.3.9.4"]
[null,"Target suction line temp",null,null,null,null,null,{"$f":"IFERROR(H24-H45+H31,\"N/A\")","v":"N/A"},"F","8.4.3.9.5"]
[null,"Difference DTD - delta btw target & measured suction line temp",null,null,null,null,null,{"$f":"IFERROR(H51-H29,\"N/A\")","v":"N/A"},"F","8.4.3.9.6"]
[]
[null,"Calculations for TXV/EEV Metering Devices"]
[null,"CTOA - Condensing Temp Over Ambient",null,null,null,null,null,{"$f":"IF(H36=\"No\",IF(H9<=9,30,IF(H9<=12,25,IF(H9<=16,20,15))),IF(ABS(IF(H9<=9,30,IF(H9<=12,25,IF(H9<=16,20,15)))-(H41-H40))<=3,H41-H40,IF(H9<=9,30,IF(H9<=12,25,IF(H9<=16,20,15)))))","v":30},"F","8.4.3.10.2.3"]
[null,"Min suction line temp",null,null,null,null,null,{"$f":"H24-H45+3","v":{"$error":"#DIV/0!"}},"F","8.4.3.10.3"]
[null,"Max suction line temp",null,null,null,null,null,{"$f":"H24-H45+26","v":{"$error":"#DIV/0!"}},"F","8.4.3.10.4"]
[null,"Suction line within target?",null,null,null,null,null,{"$f":"IF(OR(H29>65,H29<H56,H29>H57),\"No\",\"Yes\")","v":{"$error":"#DIV/0!"}},null,"8.4.3.10.5"]
[null,"Target liquid line temp",null,null,null,null,null,{"$f":"H27+H55-H21","v":30},"F","8.4.3.10.6"]
[null,"DifferenceCTOA - delta btw target & measured liquid line temp",null,null,null,null,null,{"$f":"H59-H30","v":30},"F","8.4.3.10.7"]
[]
["Weigh-In Method"]
[null,"Contractor-Provided Commissioning Values"]
[null,"The total weight of refrigerant added to or removed from the system",null,null,null,null,null,null,"Oz.","8.5.2.1.1"]
[null,"Refrigerant added or removed? ",null,null,null,null,null,"Added"]
[null,"Was factory charge removed first? ",null,null,null,null,null,"No"]
[null,"Was time-stamped geotagged photo(s) collected, showing scale with \namount of refrigerant added or removed?",null,null,null,null,null,"Yes",null,"8.5.2.1.2"]
[]
[null,"The total length of the liquid line",null,null,null,null,null,null,"Ft.","8.5.2.1.3"]
[null,"The outside diameter of the liquid line",null,null,null,null,null,"3/8\"","In.","8.5.2.1.4"]
[null,"The length of liquid line accounted for in the factory-supplied ",null,null,null,null,null,null,"Ft.","8.5.2.1.5"]
[null,"The weight of the factory-supplied refrigerant ",null,null,null,null,null,null,"Oz.","8.5.2.1.6"]
[null,"The weight of refrigerant added for specific components (other than line length)",null,null,null,null,null,null,"Oz.","8.5.2.1.7"]
[null,"Enter Rater Field Measurements"]
[null,"Enter the total length of the liquid line",null,null,null,null,null,null,"Ft.","8.5.3.1"]
[null,"Enter the outside diameter of the liquid line",null,null,null,null,null,"3/8\"","In.","8.5.3.3"]
[null,"Delta liquid line length",null,null,null,null,null,{"$f":"H75-H71","v":0},"Ft.","8.5.3.2"]
[null,"Weight of the refrigerant required for the incremental liquid line length",null,null,null,null,null,{"$f":"VLOOKUP(H76,$B$103:$D$106,3,FALSE)","v":0},"Oz.","8.5.3.4"]
[null,"Total anticipated refrigerant weight ",null,null,null,null,null,{"$f":"H78+H73+H72","v":0},"Oz.","8.5.3.5"]
[null,"Total reported refrigerant weight",null,null,null,null,null,{"$f":"IF(H66=\"Yes\",H64,H64+H73+H72)","v":0},"Oz.","8.5.3.6"]
[null,"Deviation between the total anticipated and total reported refrigerant weight ",null,null,null,null,null,{"$f":"IFERROR((H80-H79)/H79,\"N/A\")","v":"N/A"},null,"8.5.3.7"]
[]
["Fault and Grade Calculations"]
[null,"Refrigerant Charge Grade for Non-Invasive Method: Piston/Capillary Tube",null,null,null,null,null,{"$f":"IF(H11=\"Non-Invasive\",IF(H4=\"Yes\",IF(H20=\"Piston/Cap. Tube\",IF(H50=\"No\",\"Grade III\",IF(H52>D87,\"Grade I\",\"Grade III\")),\"N/A\"),\"Prereq Not Met\"),\"N/A\")","v":"N/A"},null,"8.6.2.1"]
[]
[null,"Grade","Range","Tdifference Max"]
[null,"I","> -8 F",-8]
[null,"III","≤ -8 F","n/a"]
[]
[null,"Refrigerant Charge Grade for Non-Invasive Method: TXV/EEV",null,null,null,null,null,{"$f":"IF(H11=\"Non-Invasive\",IF(H4=\"Yes\",IF(H20=\"TXV/EEV\",IF(H58=\"No\",\"Grade III\",IF(H60>D93,\"Grade I\",\"Grade III\")),\"N/A\"),\"Prereq Not Met\"),\"N/A\")","v":"N/A"},null,"8.6.2.2"]
[]
[null,"Grade","Range","Tdifference Max"]
[null,"I","> -6 F",-6]
[null,"III","≤ -6 F","n/a"]
[]
[null,"Refrigerant Charge Grade for Weigh-In Method"]
[null,"Does the location of the geotagged photo provided in Section 8.5.2.1.2 ",null,null,null,null,null,"Yes",null,"8.6.2.1.2"]
[null,"match the location of the Forced-Air HVAC System under test?"]
[null,"Grade Designation",null,null,null,null,null,{"$f":"IF(H11=\"Weigh-In\",IF(AND(H67=\"Yes\",H97=\"Yes\",ABS(H81)<=0.05),\"Grade I\",\"Grade III\"),\"N/A\")","v":{"$error":"#VALUE!"}},null,"8.6.3"]
[]
[null,"Table C1 – Verification Weight (ounces)"]
[null,"Diameter","Coeff.","Oz. "]
[null,"1/4\"",0.3,{"$f":"C103*$H$77","v":0}]
[null,"5/16\"",0.4,{"$f":"C104*$H$77","v":0}]
[null,"3/8\"",0.6,0]
[null,"1/2\"",1.2,0]

{"sheet":"Data Export","index":7,"n_rows":447,"n_cols":6,"rows_kept":447,"cut":false,"hidden":false,"merged":[]}
["Standard 310 Data Tool: Data Export"]
[null,"Tab","Field","Value","Units","Section Ref."]
[null,{"$f":"MID(CELL(\"filename\",INDIRECT(RIGHT(_xlfn.FORMULATEXT(D3),LEN(_xlfn.FORMULATEXT(D3))-1),TRUE)),FIND(\"]\",CELL(\"filename\",INDIRECT(RIGHT(_xlfn.FORMULATEXT(D3),LEN(_xlfn.FORMULATEXT(D3))-1),TRUE)))+1,255)","v":"1. HVAC Design Review"},{"$f":"'1. HVAC Design Review'!A12&'1. HVAC Design Review'!N12","v":"For A Dwelling or Townhouse, or Dwelling / Sleeping Unit Within (e.g. Duplex)Complete this section?"},{"$f":"'1. HVAC Design Review'!P12","v":"Yes"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!A12&'1. HVAC Design Review'!O13","v":"For A Dwelling or Townhouse, or Dwelling / Sleeping Unit Within (e.g. Duplex)Required data inputs provided? "},{"$f":"'1. HVAC Design Review'!P13","v":"No"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$B$16&\"_Plan\"","v":"Does the name of the plan or address for the Home match the HVAC design?_Plan"},{"$f":"'1. HVAC Design Review'!K16","v":"Yes"},null,{"$f":"'1. HVAC Design Review'!$S$16","v":"4.3.1.1"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$B$17&\"_Plan\"","v":"Do the options used in the Home match those in the HVAC design, \nor are they listed in the options the HVAC design can be used with?_Plan"},{"$f":"'1. HVAC Design Review'!K17","v":"Yes"},null,{"$f":"'1. HVAC Design Review'!$S$17","v":"4.3.1.2"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$B$20&'1. HVAC Design Review'!$B$21&\"Zone 1\"&\"_Plan\"","v":"Conditioned Floor Area of Heating / Cooling ZonesHVAC DesignZone 1_Plan"},{"$f":"'1. HVAC Design Review'!I21","v":0},{"$f":"'1. HVAC Design Review'!$R$21","v":"Sq. Ft. "},{"$f":"'1. HVAC Design Review'!$S$20","v":"4.3.1.3"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$B$20&'1. HVAC Design Review'!$B$22&\"Zone 1\"&\"_Plan\"","v":"Conditioned Floor Area of Heating / Cooling ZonesHomeZone 1_Plan"},{"$f":"'1. HVAC Design Review'!I22","v":0},{"$f":"'1. HVAC Design Review'!$R$22","v":"Sq. Ft. "},{"$f":"'1. HVAC Design Review'!$S$20","v":"4.3.1.3"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$B$20&'1. HVAC Design Review'!$B$23&\"Zone 1\"&\"_Plan\"","v":"Conditioned Floor Area of Heating / Cooling ZonesHome is between 300 sq. ft. smaller & 100 sq. ft.  larger than HVAC design?Zone 1_Plan"},{"$f":"'1. HVAC Design Review'!I23","v":"Yes"},null,{"$f":"'1. HVAC Design Review'!$S$20","v":"4.3.1.3"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$B$20&'1. HVAC Design Review'!$B$21&\"Zone 2\"&\"_Plan\"","v":"Conditioned Floor Area of Heating / Cooling ZonesHVAC DesignZone 2_Plan"},{"$f":"'1. HVAC Design Review'!J21","v":0},{"$f":"'1. HVAC Design Review'!$R$21","v":"Sq. Ft. "},{"$f":"'1. HVAC Design Review'!$S$20","v":"4.3.1.3"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$B$20&'1. HVAC Design Review'!$B$22&\"Zone 2\"&\"_Plan\"","v":"Conditioned Floor Area of Heating / Cooling ZonesHomeZone 2_Plan"},{"$f":"'1. HVAC Design Review'!J22","v":0},{"$f":"'1. HVAC Design Review'!$R$22","v":"Sq. Ft. "},{"$f":"'1. HVAC Design Review'!$S$20","v":"4.3.1.3"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$B$20&'1. HVAC Design Review'!$B$23&\"Zone 2\"&\"_Plan\"","v":"Conditioned Floor Area of Heating / Cooling ZonesHome is between 300 sq. ft. smaller & 100 sq. ft.  larger than HVAC design?Zone 2_Plan"},{"$f":"'1. HVAC Design Review'!J23","v":"Yes"},null,{"$f":"'1. HVAC Design Review'!$S$20","v":"4.3.1.3"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$B$20&'1. HVAC Design Review'!$B$21&\"Zone 3\"&\"_Plan\"","v":"Conditioned Floor Area of Heating / Cooling ZonesHVAC DesignZone 3_Plan"},{"$f":"'1. HVAC Design Review'!K21","v":0},{"$f":"'1. HVAC Design Review'!$R$21","v":"Sq. Ft. "},{"$f":"'1. HVAC Design Review'!$S$20","v":"4.3.1.3"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$B$20&'1. HVAC Design Review'!$B$22&\"Zone 3\"&\"_Plan\"","v":"Conditioned Floor Area of Heating / Cooling ZonesHomeZone 3_Plan"},{"$f":"'1. HVAC Design Review'!K22","v":0},{"$f":"'1. HVAC Design Review'!$R$22","v":"Sq. Ft. "},{"$f":"'1. HVAC Design Review'!$S$20","v":"4.3.1.3"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$B$20&'1. HVAC Design Review'!$B$23&\"Zone 3\"&\"_Plan\"","v":"Conditioned Floor Area of Heating / Cooling ZonesHome is between 300 sq. ft. smaller & 100 sq. ft.  larger than HVAC design?Zone 3_Plan"},{"$f":"'1. HVAC Design Review'!K23","v":"Yes"},null,{"$f":"'1. HVAC Design Review'!$S$20","v":"4.3.1.3"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$B$25&'1. HVAC Design Review'!$B$26&\"Zone 1\"&\"_Plan\"","v":"Window Area of Heating / Cooling ZonesHVAC DesignZone 1_Plan"},{"$f":"'1. HVAC Design Review'!I26","v":0},{"$f":"'1. HVAC Design Review'!$R$26","v":"Sq. Ft. "},{"$f":"'1. HVAC Design Review'!$S$25","v":"4.3.1.4"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$B$25&'1. HVAC Design Review'!$B$22&\"Zone 1\"&\"_Plan\"","v":"Window Area of Heating / Cooling ZonesHomeZone 1_Plan"},{"$f":"'1. HVAC Design Review'!I27","v":0},{"$f":"'1. HVAC Design Review'!$R$27","v":"Sq. Ft. "},{"$f":"'1. HVAC Design Review'!$S$25","v":"4.3.1.4"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$B$25&'1. HVAC Design Review'!$B$23&\"Zone 1\"&\"_Plan\"","v":"Window Area of Heating / Cooling ZonesHome is between 300 sq. ft. smaller & 100 sq. ft.  larger than HVAC design?Zone 1_Plan"},{"$f":"'1. HVAC Design Review'!I28","v":"Yes"},null,{"$f":"'1. HVAC Design Review'!$S$25","v":"4.3.1.4"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$B$25&'1. HVAC Design Review'!$B$26&\"Zone 2\"&\"_Plan\"","v":"Window Area of Heating / Cooling ZonesHVAC DesignZone 2_Plan"},{"$f":"'1. HVAC Design Review'!J26","v":0},{"$f":"'1. HVAC Design Review'!$R$26","v":"Sq. Ft. "},{"$f":"'1. HVAC Design Review'!$S$25","v":"4.3.1.4"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$B$25&'1. HVAC Design Review'!$B$22&\"Zone 2\"&\"_Plan\"","v":"Window Area of Heating / Cooling ZonesHomeZone 2_Plan"},{"$f":"'1. HVAC Design Review'!J27","v":0},{"$f":"'1. HVAC Design Review'!$R$27","v":"Sq. Ft. "},{"$f":"'1. HVAC Design Review'!$S$25","v":"4.3.1.4"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$B$25&'1. HVAC Design Review'!$B$23&\"Zone 2\"&\"_Plan\"","v":"Window Area of Heating / Cooling ZonesHome is between 300 sq. ft. smaller & 100 sq. ft.  larger than HVAC design?Zone 2_Plan"},{"$f":"'1. HVAC Design Review'!J28","v":"Yes"},null,{"$f":"'1. HVAC Design Review'!$S$25","v":"4.3.1.4"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$B$25&'1. HVAC Design Review'!$B$26&\"Zone 3\"&\"_Plan\"","v":"Window Area of Heating / Cooling ZonesHVAC DesignZone 3_Plan"},{"$f":"'1. HVAC Design Review'!K26","v":0},{"$f":"'1. HVAC Design Review'!$R$26","v":"Sq. Ft. "},{"$f":"'1. HVAC Design Review'!$S$25","v":"4.3.1.4"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$B$25&'1. HVAC Design Review'!$B$22&\"Zone 3\"&\"_Plan\"","v":"Window Area of Heating / Cooling ZonesHomeZone 3_Plan"},{"$f":"'1. HVAC Design Review'!K27","v":0},{"$f":"'1. HVAC Design Review'!$R$27","v":"Sq. Ft. "},{"$f":"'1. HVAC Design Review'!$S$25","v":"4.3.1.4"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$B$25&'1. HVAC Design Review'!$B$23&\"Zone 3\"&\"_Plan\"","v":"Window Area of Heating / Cooling ZonesHome is between 300 sq. ft. smaller & 100 sq. ft.  larger than HVAC design?Zone 3_Plan"},{"$f":"'1. HVAC Design Review'!K28","v":"Yes"},null,{"$f":"'1. HVAC Design Review'!$S$25","v":"4.3.1.4"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$B$31&'1. HVAC Design Review'!$B$32&\"Zone 1\"&\"_Plan\"","v":"Heating / Cooling Loads Methodology and OrientationsIn HVAC Design, is the max. minus min. total heat gain across orientations ≤ 6 kBtuh?Zone 1_Plan"},{"$f":"'1. HVAC Design Review'!I32","v":"N/A"},null,{"$f":"'1. HVAC Design Review'!$S$32","v":"4.3.1.6"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$B$31&'1. HVAC Design Review'!$B$32&\"Zone 2\"&\"_Plan\"","v":"Heating / Cooling Loads Methodology and OrientationsIn HVAC Design, is the max. minus min. total heat gain across orientations ≤ 6 kBtuh?Zone 2_Plan"},{"$f":"'1. HVAC Design Review'!J32","v":"N/A"},null,{"$f":"'1. HVAC Design Review'!$S$32","v":"4.3.1.6"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$B$31&'1. HVAC Design Review'!$B$32&\"Zone 3\"&\"_Plan\"","v":"Heating / Cooling Loads Methodology and OrientationsIn HVAC Design, is the max. minus min. total heat gain across orientations ≤ 6 kBtuh?Zone 3_Plan"},{"$f":"'1. HVAC Design Review'!K32","v":"N/A"},null,{"$f":"'1. HVAC Design Review'!$S$32","v":"4.3.1.6"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$B$34","v":"Does front orientation of the Home match one of the orientations in the HVAC design?"},{"$f":"'1. HVAC Design Review'!K34","v":"Yes"},null,{"$f":"'1. HVAC Design Review'!$S$34","v":"4.3.1.5"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$B$35","v":"In HVAC Design, have heating and cooling loads have been calculated room-by-room?"},{"$f":"'1. HVAC Design Review'!K35","v":"Yes"},null,{"$f":"'1. HVAC Design Review'!$S$35","v":"4.3.1.7"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$B$16&\"_Field\"","v":"Does the name of the plan or address for the Home match the HVAC design?_Field"},{"$f":"'1. HVAC Design Review'!P16","v":"Yes"},null,{"$f":"'1. HVAC Design Review'!$S$16","v":"4.3.1.1"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$B$17&\"_Field\"","v":"Do the options used in the Home match those in the HVAC design, \nor are they listed in the options the HVAC design can be used with?_Field"},{"$f":"'1. HVAC Design Review'!P17","v":"Yes"},null,{"$f":"'1. HVAC Design Review'!$S$17","v":"4.3.1.2"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$B$20&'1. HVAC Design Review'!$B$21&\"Zone 1\"&\"_Field\"","v":"Conditioned Floor Area of Heating / Cooling ZonesHVAC DesignZone 1_Field"},{"$f":"'1. HVAC Design Review'!N21","v":0},{"$f":"'1. HVAC Design Review'!$R$21","v":"Sq. Ft. "},{"$f":"'1. HVAC Design Review'!$S$20","v":"4.3.1.3"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$B$20&'1. HVAC Design Review'!$B$22&\"Zone 1\"&\"_Field\"","v":"Conditioned Floor Area of Heating / Cooling ZonesHomeZone 1_Field"},{"$f":"'1. HVAC Design Review'!N22","v":0},{"$f":"'1. HVAC Design Review'!$R$22","v":"Sq. Ft. "},{"$f":"'1. HVAC Design Review'!$S$20","v":"4.3.1.3"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$B$20&'1. HVAC Design Review'!$B$23&\"Zone 1\"&\"_Field\"","v":"Conditioned Floor Area of Heating / Cooling ZonesHome is between 300 sq. ft. smaller & 100 sq. ft.  larger than HVAC design?Zone 1_Field"},{"$f":"'1. HVAC Design Review'!N23","v":"Yes"},null,{"$f":"'1. HVAC Design Review'!$S$20","v":"4.3.1.3"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$B$20&'1. HVAC Design Review'!$B$21&\"Zone 2\"&\"_Field\"","v":"Conditioned Floor Area of Heating / Cooling ZonesHVAC DesignZone 2_Field"},{"$f":"'1. HVAC Design Review'!O21","v":0},{"$f":"'1. HVAC Design Review'!$R$21","v":"Sq. Ft. "},{"$f":"'1. HVAC Design Review'!$S$20","v":"4.3.1.3"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$B$20&'1. HVAC Design Review'!$B$22&\"Zone 2\"&\"_Field\"","v":"Conditioned Floor Area of Heating / Cooling ZonesHomeZone 2_Field"},{"$f":"'1. HVAC Design Review'!O22","v":0},{"$f":"'1. HVAC Design Review'!$R$22","v":"Sq. Ft. "},{"$f":"'1. HVAC Design Review'!$S$20","v":"4.3.1.3"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$B$20&'1. HVAC Design Review'!$B$23&\"Zone 2\"&\"_Field\"","v":"Conditioned Floor Area of Heating / Cooling ZonesHome is between 300 sq. ft. smaller & 100 sq. ft.  larger than HVAC design?Zone 2_Field"},{"$f":"'1. HVAC Design Review'!O23","v":"Yes"},null,{"$f":"'1. HVAC Design Review'!$S$20","v":"4.3.1.3"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$B$20&'1. HVAC Design Review'!$B$21&\"Zone 3\"&\"_Field\"","v":"Conditioned Floor Area of Heating / Cooling ZonesHVAC DesignZone 3_Field"},{"$f":"'1. HVAC Design Review'!P21","v":0},{"$f":"'1. HVAC Design Review'!$R$21","v":"Sq. Ft. "},{"$f":"'1. HVAC Design Review'!$S$20","v":"4.3.1.3"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$B$20&'1. HVAC Design Review'!$B$22&\"Zone 3\"&\"_Field\"","v":"Conditioned Floor Area of Heating / Cooling ZonesHomeZone 3_Field"},{"$f":"'1. HVAC Design Review'!P22","v":0},{"$f":"'1. HVAC Design Review'!$R$22","v":"Sq. Ft. "},{"$f":"'1. HVAC Design Review'!$S$20","v":"4.3.1.3"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$B$20&'1. HVAC Design Review'!$B$23&\"Zone 3\"&\"_Field\"","v":"Conditioned Floor Area of Heating / Cooling ZonesHome is between 300 sq. ft. smaller & 100 sq. ft.  larger than HVAC design?Zone 3_Field"},{"$f":"'1. HVAC Design Review'!P23","v":"Yes"},null,{"$f":"'1. HVAC Design Review'!$S$20","v":"4.3.1.3"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$B$25&'1. HVAC Design Review'!$B$26&\"Zone 1\"&\"_Field\"","v":"Window Area of Heating / Cooling ZonesHVAC DesignZone 1_Field"},{"$f":"'1. HVAC Design Review'!N26","v":0},{"$f":"'1. HVAC Design Review'!$R$26","v":"Sq. Ft. "},{"$f":"'1. HVAC Design Review'!$S$25","v":"4.3.1.4"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$B$25&'1. HVAC Design Review'!$B$22&\"Zone 1\"&\"_Field\"","v":"Window Area of Heating / Cooling ZonesHomeZone 1_Field"},{"$f":"'1. HVAC Design Review'!N27","v":0},{"$f":"'1. HVAC Design Review'!$R$27","v":"Sq. Ft. "},{"$f":"'1. HVAC Design Review'!$S$25","v":"4.3.1.4"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$B$25&'1. HVAC Design Review'!$B$23&\"Zone 1\"&\"_Field\"","v":"Window Area of Heating / Cooling ZonesHome is between 300 sq. ft. smaller & 100 sq. ft.  larger than HVAC design?Zone 1_Field"},{"$f":"'1. HVAC Design Review'!N28","v":"Yes"},null,{"$f":"'1. HVAC Design Review'!$S$25","v":"4.3.1.4"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$B$25&'1. HVAC Design Review'!$B$26&\"Zone 2\"&\"_Field\"","v":"Window Area of Heating / Cooling ZonesHVAC DesignZone 2_Field"},{"$f":"'1. HVAC Design Review'!O26","v":0},{"$f":"'1. HVAC Design Review'!$R$26","v":"Sq. Ft. "},{"$f":"'1. HVAC Design Review'!$S$25","v":"4.3.1.4"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$B$25&'1. HVAC Design Review'!$B$22&\"Zone 2\"&\"_Field\"","v":"Window Area of Heating / Cooling ZonesHomeZone 2_Field"},{"$f":"'1. HVAC Design Review'!O27","v":0},{"$f":"'1. HVAC Design Review'!$R$27","v":"Sq. Ft. "},{"$f":"'1. HVAC Design Review'!$S$25","v":"4.3.1.4"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$B$25&'1. HVAC Design Review'!$B$23&\"Zone 2\"&\"_Field\"","v":"Window Area of Heating / Cooling ZonesHome is between 300 sq. ft. smaller & 100 sq. ft.  larger than HVAC design?Zone 2_Field"},{"$f":"'1. HVAC Design Review'!O28","v":"Yes"},null,{"$f":"'1. HVAC Design Review'!$S$25","v":"4.3.1.4"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$B$25&'1. HVAC Design Review'!$B$26&\"Zone 3\"&\"_Field\"","v":"Window Area of Heating / Cooling ZonesHVAC DesignZone 3_Field"},{"$f":"'1. HVAC Design Review'!P26","v":0},{"$f":"'1. HVAC Design Review'!$R$26","v":"Sq. Ft. "},{"$f":"'1. HVAC Design Review'!$S$25","v":"4.3.1.4"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$B$25&'1. HVAC Design Review'!$B$22&\"Zone 3\"&\"_Field\"","v":"Window Area of Heating / Cooling ZonesHomeZone 3_Field"},{"$f":"'1. HVAC Design Review'!P27","v":0},{"$f":"'1. HVAC Design Review'!$R$27","v":"Sq. Ft. "},{"$f":"'1. HVAC Design Review'!$S$25","v":"4.3.1.4"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$B$25&'1. HVAC Design Review'!$B$23&\"Zone 3\"&\"_Field\"","v":"Window Area of Heating / Cooling ZonesHome is between 300 sq. ft. smaller & 100 sq. ft.  larger than HVAC design?Zone 3_Field"},{"$f":"'1. HVAC Design Review'!P28","v":"Yes"},null,{"$f":"'1. HVAC Design Review'!$S$25","v":"4.3.1.4"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$B$31&'1. HVAC Design Review'!$B$32&\"Zone 1\"&\"_Field\"","v":"Heating / Cooling Loads Methodology and OrientationsIn HVAC Design, is the max. minus min. total heat gain across orientations ≤ 6 kBtuh?Zone 1_Field"},{"$f":"'1. HVAC Design Review'!N32","v":"N/A"},null,{"$f":"'1. HVAC Design Review'!$S$32","v":"4.3.1.6"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$B$31&'1. HVAC Design Review'!$B$32&\"Zone 2\"&\"_Field\"","v":"Heating / Cooling Loads Methodology and OrientationsIn HVAC Design, is the max. minus min. total heat gain across orientations ≤ 6 kBtuh?Zone 2_Field"},{"$f":"'1. HVAC Design Review'!O32","v":"N/A"},null,{"$f":"'1. HVAC Design Review'!$S$32","v":"4.3.1.6"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$B$31&'1. HVAC Design Review'!$B$32&\"Zone 3\"&\"_Field\"","v":"Heating / Cooling Loads Methodology and OrientationsIn HVAC Design, is the max. minus min. total heat gain across orientations ≤ 6 kBtuh?Zone 3_Field"},{"$f":"'1. HVAC Design Review'!P32","v":"N/A"},null,{"$f":"'1. HVAC Design Review'!$S$32","v":"4.3.1.6"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$B$34","v":"Does front orientation of the Home match one of the orientations in the HVAC design?"},{"$f":"'1. HVAC Design Review'!P34","v":"Yes"},null,{"$f":"'1. HVAC Design Review'!$S$34","v":"4.3.1.5"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$B$35","v":"In HVAC Design, have heating and cooling loads have been calculated room-by-room?"},{"$f":"'1. HVAC Design Review'!P35","v":"Yes"},null,{"$f":"'1. HVAC Design Review'!$S$35","v":"4.3.1.7"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!A37&'1. HVAC Design Review'!N37","v":"For A Dwelling / Sleeping Unit in a Multifamily Building w/ Heat Gain ≤18 kBTUh & Heat Loss ≤35 kBTUhComplete this section?"},{"$f":"'1. HVAC Design Review'!P37","v":"No"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!A37&'1. HVAC Design Review'!O38","v":"For A Dwelling / Sleeping Unit in a Multifamily Building w/ Heat Gain ≤18 kBTUh & Heat Loss ≤35 kBTUhRequired data inputs provided? "},{"$f":"'1. HVAC Design Review'!P38","v":"N/A"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$B$41&\"_Plan\"","v":"Does the unique identifier for the building that the Home is in match the HVAC design?_Plan"},{"$f":"'1. HVAC Design Review'!K41","v":"Yes"},null,{"$f":"'1. HVAC Design Review'!$S$41","v":"4.3.2.1"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!B42&\"_Plan\"","v":"Does name of the plan for the Home either: a) match the HVAC design or b) is it included in the list of plans that the HVAC design can be used with AND the plan used in the HVAC design has the largest conditioned floor area among the plans listed?_Plan"},{"$f":"'1. HVAC Design Review'!K42","v":"Yes"},null,{"$f":"'1. HVAC Design Review'!$S$42","v":"4.3.2.2"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!B46&\"_Plan\"","v":"Do the options used in the Home either: a) match those in the HVAC design, or b) are they listed in the options the HVAC design can be used with AND the options used in the HVAC design have the largest conditioned floor area among the options listed?_Plan"},{"$f":"'1. HVAC Design Review'!K46","v":"Yes"},null,{"$f":"'1. HVAC Design Review'!S46","v":"4.3.2.3"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$B$50&'1. HVAC Design Review'!$B$51&\"Zone 1\"&\"_Plan\"","v":"Window Area of Heating / Cooling ZonesHVAC DesignZone 1_Plan"},{"$f":"'1. HVAC Design Review'!I51","v":0},{"$f":"'1. HVAC Design Review'!$R$51","v":"Sq. Ft. "},{"$f":"'1. HVAC Design Review'!$S$50","v":"4.3.2.4"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$B$50&'1. HVAC Design Review'!$B$52&\"Zone 1\"&\"_Plan\"","v":"Window Area of Heating / Cooling ZonesHomeZone 1_Plan"},{"$f":"'1. HVAC Design Review'!I52","v":0},{"$f":"'1. HVAC Design Review'!$R$52","v":"Sq. Ft. "},{"$f":"'1. HVAC Design Review'!$S$50","v":"4.3.2.4"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$B$50&'1. HVAC Design Review'!$B$53&\"Zone 1\"&\"_Plan\"","v":"Window Area of Heating / Cooling ZonesHome is less than or equal to HVAC design?Zone 1_Plan"},{"$f":"'1. HVAC Design Review'!I53","v":"Yes"},{"$f":"'1. HVAC Design Review'!$R$52","v":"Sq. Ft. "},{"$f":"'1. HVAC Design Review'!$S$50","v":"4.3.2.4"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$B$50&'1. HVAC Design Review'!$B$51&\"Zone 2\"&\"_Plan\"","v":"Window Area of Heating / Cooling ZonesHVAC DesignZone 2_Plan"},{"$f":"'1. HVAC Design Review'!J51","v":0},{"$f":"'1. HVAC Design Review'!$R$52","v":"Sq. Ft. "},{"$f":"'1. HVAC Design Review'!$S$50","v":"4.3.2.4"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$B$50&'1. HVAC Design Review'!$B$52&\"Zone 2\"&\"_Plan\"","v":"Window Area of Heating / Cooling ZonesHomeZone 2_Plan"},{"$f":"'1. HVAC Design Review'!J52","v":0},{"$f":"'1. HVAC Design Review'!$R$52","v":"Sq. Ft. "},{"$f":"'1. HVAC Design Review'!$S$50","v":"4.3.2.4"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$B$50&'1. HVAC Design Review'!$B$53&\"Zone 2\"&\"_Plan\"","v":"Window Area of Heating / Cooling ZonesHome is less than or equal to HVAC design?Zone 2_Plan"},{"$f":"'1. HVAC Design Review'!J53","v":"Yes"},{"$f":"'1. HVAC Design Review'!$R$52","v":"Sq. Ft. "},{"$f":"'1. HVAC Design Review'!$S$50","v":"4.3.2.4"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$B$50&'1. HVAC Design Review'!$B$51&\"Zone 3\"&\"_Plan\"","v":"Window Area of Heating / Cooling ZonesHVAC DesignZone 3_Plan"},{"$f":"'1. HVAC Design Review'!K51","v":0},{"$f":"'1. HVAC Design Review'!$R$52","v":"Sq. Ft. "},{"$f":"'1. HVAC Design Review'!$S$50","v":"4.3.2.4"}]
[null,{"$f":"MID(CELL(\"filename\",INDIRECT(RIGHT(_xlfn.FORMULATEXT(D67),LEN(_xlfn.FORMULATEXT(D67))-1),TRUE)),FIND(\"]\",CELL(\"filename\",INDIRECT(RIGHT(_xlfn.FORMULATEXT(D67),LEN(_xlfn.FORMULATEXT(D67))-1),TRUE)))+1,255)","v":"1. HVAC Design Review"},{"$f":"'1. HVAC Design Review'!$B$50&'1. HVAC Design Review'!$B$52&\"Zone 3\"&\"_Plan\"","v":"Window Area of Heating / Cooling ZonesHomeZone 3_Plan"},{"$f":"'1. HVAC Design Review'!K52","v":0},{"$f":"'1. HVAC Design Review'!$R$52","v":"Sq. Ft. "},{"$f":"'1. HVAC Design Review'!$S$50","v":"4.3.2.4"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$B$50&'1. HVAC Design Review'!$B$53&\"Zone 3\"&\"_Plan\"","v":"Window Area of Heating / Cooling ZonesHome is less than or equal to HVAC design?Zone 3_Plan"},{"$f":"'1. HVAC Design Review'!K53","v":"Yes"},{"$f":"'1. HVAC Design Review'!$R$52","v":"Sq. Ft. "},{"$f":"'1. HVAC Design Review'!$S$50","v":"4.3.2.4"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$B$56&\"_Plan\"","v":"Does the Home location (e.g., top, middle, bottom floor; corner or middle unit) match the HVAC design, or is the location of the HVAC Design a top floor and corner unit?_Plan"},{"$f":"'1. HVAC Design Review'!K56","v":"Yes"},null,{"$f":"'1. HVAC Design Review'!$S$56","v":"4.3.2.5"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$B$58&\"_Plan\"","v":"Have orientation-specific total heat gains been documented for all eight orientations?_Plan"},{"$f":"'1. HVAC Design Review'!K58","v":"Yes"},null,{"$f":"'1. HVAC Design Review'!$S$58","v":"4.3.2.6"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$B$41&\"_Field\"","v":"Does the unique identifier for the building that the Home is in match the HVAC design?_Field"},{"$f":"'1. HVAC Design Review'!P41","v":"Yes"},null,{"$f":"'1. HVAC Design Review'!$S$41","v":"4.3.2.1"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!B56&\"_Field\"","v":"Does the Home location (e.g., top, middle, bottom floor; corner or middle unit) match the HVAC design, or is the location of the HVAC Design a top floor and corner unit?_Field"},{"$f":"'1. HVAC Design Review'!P42","v":"Yes"},null,{"$f":"'1. HVAC Design Review'!$S$42","v":"4.3.2.2"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!B46&\"_Field\"","v":"Do the options used in the Home either: a) match those in the HVAC design, or b) are they listed in the options the HVAC design can be used with AND the options used in the HVAC design have the largest conditioned floor area among the options listed?_Field"},{"$f":"'1. HVAC Design Review'!P46","v":"Yes"},null,{"$f":"'1. HVAC Design Review'!S46","v":"4.3.2.3"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$B$50&'1. HVAC Design Review'!$B$51&\"Zone 1\"&\"_Field\"","v":"Window Area of Heating / Cooling ZonesHVAC DesignZone 1_Field"},{"$f":"'1. HVAC Design Review'!N51","v":0},{"$f":"'1. HVAC Design Review'!$R$51","v":"Sq. Ft. "},{"$f":"'1. HVAC Design Review'!$S$50","v":"4.3.2.4"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$B$50&'1. HVAC Design Review'!$B$52&\"Zone 1\"&\"_Field\"","v":"Window Area of Heating / Cooling ZonesHomeZone 1_Field"},{"$f":"'1. HVAC Design Review'!N52","v":0},{"$f":"'1. HVAC Design Review'!$R$52","v":"Sq. Ft. "},{"$f":"'1. HVAC Design Review'!$S$50","v":"4.3.2.4"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$B$50&'1. HVAC Design Review'!$B$53&\"Zone 1\"&\"_Field\"","v":"Window Area of Heating / Cooling ZonesHome is less than or equal to HVAC design?Zone 1_Field"},{"$f":"'1. HVAC Design Review'!N53","v":"Yes"},{"$f":"'1. HVAC Design Review'!$R$52","v":"Sq. Ft. "},{"$f":"'1. HVAC Design Review'!$S$50","v":"4.3.2.4"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$B$50&'1. HVAC Design Review'!$B$51&\"Zone 2\"&\"_Field\"","v":"Window Area of Heating / Cooling ZonesHVAC DesignZone 2_Field"},{"$f":"'1. HVAC Design Review'!O51","v":0},{"$f":"'1. HVAC Design Review'!$R$52","v":"Sq. Ft. "},{"$f":"'1. HVAC Design Review'!$S$50","v":"4.3.2.4"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$B$50&'1. HVAC Design Review'!$B$52&\"Zone 2\"&\"_Field\"","v":"Window Area of Heating / Cooling ZonesHomeZone 2_Field"},{"$f":"'1. HVAC Design Review'!O52","v":0},{"$f":"'1. HVAC Design Review'!$R$52","v":"Sq. Ft. "},{"$f":"'1. HVAC Design Review'!$S$50","v":"4.3.2.4"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$B$50&'1. HVAC Design Review'!$B$53&\"Zone 2\"&\"_Field\"","v":"Window Area of Heating / Cooling ZonesHome is less than or equal to HVAC design?Zone 2_Field"},{"$f":"'1. HVAC Design Review'!O53","v":"Yes"},{"$f":"'1. HVAC Design Review'!$R$52","v":"Sq. Ft. "},{"$f":"'1. HVAC Design Review'!$S$50","v":"4.3.2.4"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$B$50&'1. HVAC Design Review'!$B$51&\"Zone 3\"&\"_Field\"","v":"Window Area of Heating / Cooling ZonesHVAC DesignZone 3_Field"},{"$f":"'1. HVAC Design Review'!P51","v":0},{"$f":"'1. HVAC Design Review'!$R$52","v":"Sq. Ft. "},{"$f":"'1. HVAC Design Review'!$S$50","v":"4.3.2.4"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$B$50&'1. HVAC Design Review'!$B$52&\"Zone 3\"&\"_Field\"","v":"Window Area of Heating / Cooling ZonesHomeZone 3_Field"},{"$f":"'1. HVAC Design Review'!P52","v":0},{"$f":"'1. HVAC Design Review'!$R$52","v":"Sq. Ft. "},{"$f":"'1. HVAC Design Review'!$S$50","v":"4.3.2.4"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$B$50&'1. HVAC Design Review'!$B$53&\"Zone 3\"&\"_Field\"","v":"Window Area of Heating / Cooling ZonesHome is less than or equal to HVAC design?Zone 3_Field"},{"$f":"'1. HVAC Design Review'!P53","v":"Yes"},{"$f":"'1. HVAC Design Review'!$R$52","v":"Sq. Ft. "},{"$f":"'1. HVAC Design Review'!$S$50","v":"4.3.2.4"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$B$56&\"_Field\"","v":"Does the Home location (e.g., top, middle, bottom floor; corner or middle unit) match the HVAC design, or is the location of the HVAC Design a top floor and corner unit?_Field"},{"$f":"'1. HVAC Design Review'!P56","v":"Yes"},null,{"$f":"'1. HVAC Design Review'!$S$56","v":"4.3.2.5"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$B$58&\"_Field\"","v":"Have orientation-specific total heat gains been documented for all eight orientations?_Field"},{"$f":"'1. HVAC Design Review'!P58","v":"Yes"},null,{"$f":"'1. HVAC Design Review'!$S$58","v":"4.3.2.6"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$A$60&'1. HVAC Design Review'!$N$60","v":"For A Dwelling / Sleeping Unit in a Multifamily Building w/ Heat Gain >18 kBTUh or Heat Loss >35 kBTUhComplete this section?"},{"$f":"'1. HVAC Design Review'!P60","v":"No"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$A$60&'1. HVAC Design Review'!$O$61","v":"For A Dwelling / Sleeping Unit in a Multifamily Building w/ Heat Gain >18 kBTUh or Heat Loss >35 kBTUhRequired data inputs provided? "},{"$f":"'1. HVAC Design Review'!P61","v":"N/A"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$B$64","v":"Does the unique identifier for the building that the Home is in match the HVAC design?"},{"$f":"'1. HVAC Design Review'!K64","v":"Yes"},null,{"$f":"'1. HVAC Design Review'!$S$64","v":"4.3.3.1"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$B$65","v":"Does the name of the plan for the Home match the HVAC design?"},{"$f":"'1. HVAC Design Review'!K65","v":"Yes"},null,{"$f":"'1. HVAC Design Review'!$S$65","v":"4.3.3.2"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$B$66","v":"Do the options used in the Home match those in the HVAC design, \nor are they listed in the options the HVAC design can be used with?"},{"$f":"'1. HVAC Design Review'!K66","v":"Yes"},null,{"$f":"'1. HVAC Design Review'!$S$66","v":"4.3.3.3"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$B$20&'1. HVAC Design Review'!$B$21&\"Zone 1\"&\"_Plan\"","v":"Conditioned Floor Area of Heating / Cooling ZonesHVAC DesignZone 1_Plan"},{"$f":"'1. HVAC Design Review'!I70","v":0},{"$f":"'1. HVAC Design Review'!$R$70","v":"Sq. Ft. "},{"$f":"'1. HVAC Design Review'!$S$69","v":"4.3.3.4"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$B$20&'1. HVAC Design Review'!$B$22&\"Zone 1\"&\"_Plan\"","v":"Conditioned Floor Area of Heating / Cooling ZonesHomeZone 1_Plan"},{"$f":"'1. HVAC Design Review'!I71","v":0},{"$f":"'1. HVAC Design Review'!$R$71","v":"Sq. Ft. "},{"$f":"'1. HVAC Design Review'!$S$69","v":"4.3.3.4"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$B$20&'1. HVAC Design Review'!$B$23&\"Zone 1\"&\"_Plan\"","v":"Conditioned Floor Area of Heating / Cooling ZonesHome is between 300 sq. ft. smaller & 100 sq. ft.  larger than HVAC design?Zone 1_Plan"},{"$f":"'1. HVAC Design Review'!I72","v":"Yes"},null,{"$f":"'1. HVAC Design Review'!$S$69","v":"4.3.3.4"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$B$20&'1. HVAC Design Review'!$B$21&\"Zone 2\"&\"_Plan\"","v":"Conditioned Floor Area of Heating / Cooling ZonesHVAC DesignZone 2_Plan"},{"$f":"'1. HVAC Design Review'!J70","v":0},{"$f":"'1. HVAC Design Review'!$R$70","v":"Sq. Ft. "},{"$f":"'1. HVAC Design Review'!$S$69","v":"4.3.3.4"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$B$20&'1. HVAC Design Review'!$B$22&\"Zone 2\"&\"_Plan\"","v":"Conditioned Floor Area of Heating / Cooling ZonesHomeZone 2_Plan"},{"$f":"'1. HVAC Design Review'!J71","v":0},{"$f":"'1. HVAC Design Review'!$R$71","v":"Sq. Ft. "},{"$f":"'1. HVAC Design Review'!$S$69","v":"4.3.3.4"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$B$20&'1. HVAC Design Review'!$B$23&\"Zone 2\"&\"_Plan\"","v":"Conditioned Floor Area of Heating / Cooling ZonesHome is between 300 sq. ft. smaller & 100 sq. ft.  larger than HVAC design?Zone 2_Plan"},{"$f":"'1. HVAC Design Review'!J72","v":"Yes"},null,{"$f":"'1. HVAC Design Review'!$S$69","v":"4.3.3.4"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$B$20&'1. HVAC Design Review'!$B$21&\"Zone 3\"&\"_Plan\"","v":"Conditioned Floor Area of Heating / Cooling ZonesHVAC DesignZone 3_Plan"},{"$f":"'1. HVAC Design Review'!K70","v":0},{"$f":"'1. HVAC Design Review'!$R$70","v":"Sq. Ft. "},{"$f":"'1. HVAC Design Review'!$S$69","v":"4.3.3.4"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$B$20&'1. HVAC Design Review'!$B$22&\"Zone 3\"&\"_Plan\"","v":"Conditioned Floor Area of Heating / Cooling ZonesHomeZone 3_Plan"},{"$f":"'1. HVAC Design Review'!K71","v":0},{"$f":"'1. HVAC Design Review'!$R$71","v":"Sq. Ft. "},{"$f":"'1. HVAC Design Review'!$S$69","v":"4.3.3.4"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$B$20&'1. HVAC Design Review'!$B$23&\"Zone 3\"&\"_Plan\"","v":"Conditioned Floor Area of Heating / Cooling ZonesHome is between 300 sq. ft. smaller & 100 sq. ft.  larger than HVAC design?Zone 3_Plan"},{"$f":"'1. HVAC Design Review'!K72","v":"Yes"},null,{"$f":"'1. HVAC Design Review'!$S$69","v":"4.3.3.4"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$B$25&'1. HVAC Design Review'!$B$26&\"Zone 1\"&\"_Plan\"","v":"Window Area of Heating / Cooling ZonesHVAC DesignZone 1_Plan"},{"$f":"'1. HVAC Design Review'!I75","v":0},{"$f":"'1. HVAC Design Review'!$R$75","v":"Sq. Ft. "},{"$f":"'1. HVAC Design Review'!$S$74","v":"4.3.3.5"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$B$25&'1. HVAC Design Review'!$B$22&\"Zone 1\"&\"_Plan\"","v":"Window Area of Heating / Cooling ZonesHomeZone 1_Plan"},{"$f":"'1. HVAC Design Review'!I76","v":0},{"$f":"'1. HVAC Design Review'!$R$76","v":"Sq. Ft. "},{"$f":"'1. HVAC Design Review'!$S$74","v":"4.3.3.5"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$B$25&'1. HVAC Design Review'!$B$77&\"Zone 1\"&\"_Plan\"","v":"Window Area of Heating / Cooling ZonesHome is between 60 sq. ft. smaller & 15 sq. ft. larger than HVAC design, \nor for zones with > 500 sq. ft. of windows, between 12% smaller and 3% larger?Zone 1_Plan"},{"$f":"'1. HVAC Design Review'!I77","v":"Yes"},null,{"$f":"'1. HVAC Design Review'!$S$74","v":"4.3.3.5"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$B$25&'1. HVAC Design Review'!$B$26&\"Zone 2\"&\"_Plan\"","v":"Window Area of Heating / Cooling ZonesHVAC DesignZone 2_Plan"},{"$f":"'1. HVAC Design Review'!J75","v":0},{"$f":"'1. HVAC Design Review'!$R$75","v":"Sq. Ft. "},{"$f":"'1. HVAC Design Review'!$S$74","v":"4.3.3.5"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$B$25&'1. HVAC Design Review'!$B$22&\"Zone 2\"&\"_Plan\"","v":"Window Area of Heating / Cooling ZonesHomeZone 2_Plan"},{"$f":"'1. HVAC Design Review'!J76","v":0},{"$f":"'1. HVAC Design Review'!$R$76","v":"Sq. Ft. "},{"$f":"'1. HVAC Design Review'!$S$74","v":"4.3.3.5"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$B$25&'1. HVAC Design Review'!$B$77&\"Zone 2\"&\"_Plan\"","v":"Window Area of Heating / Cooling ZonesHome is between 60 sq. ft. smaller & 15 sq. ft. larger than HVAC design, \nor for zones with > 500 sq. ft. of windows, between 12% smaller and 3% larger?Zone 2_Plan"},{"$f":"'1. HVAC Design Review'!J77","v":"Yes"},null,{"$f":"'1. HVAC Design Review'!$S$74","v":"4.3.3.5"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$B$25&'1. HVAC Design Review'!$B$26&\"Zone 3\"&\"_Plan\"","v":"Window Area of Heating / Cooling ZonesHVAC DesignZone 3_Plan"},{"$f":"'1. HVAC Design Review'!K75","v":0},{"$f":"'1. HVAC Design Review'!$R$75","v":"Sq. Ft. "},{"$f":"'1. HVAC Design Review'!$S$74","v":"4.3.3.5"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$B$25&'1. HVAC Design Review'!$B$22&\"Zone 3\"&\"_Plan\"","v":"Window Area of Heating / Cooling ZonesHomeZone 3_Plan"},{"$f":"'1. HVAC Design Review'!K76","v":0},{"$f":"'1. HVAC Design Review'!$R$76","v":"Sq. Ft. "},{"$f":"'1. HVAC Design Review'!$S$74","v":"4.3.3.5"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$B$25&'1. HVAC Design Review'!$B$77&\"Zone 3\"&\"_Plan\"","v":"Window Area of Heating / Cooling ZonesHome is between 60 sq. ft. smaller & 15 sq. ft. larger than HVAC design, \nor for zones with > 500 sq. ft. of windows, between 12% smaller and 3% larger?Zone 3_Plan"},{"$f":"'1. HVAC Design Review'!K77","v":"Yes"},null,{"$f":"'1. HVAC Design Review'!$S$74","v":"4.3.3.5"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$B$31&'1. HVAC Design Review'!$B$81&\"Zone 1\"&\"_Plan\"","v":"Heating / Cooling Loads Methodology and OrientationsIn HVAC Design, is the max. minus min. total heat gain across orientations ≤ 6 kBtuh?Zone 1_Plan"},{"$f":"'1. HVAC Design Review'!I81","v":"N/A"},null,{"$f":"'1. HVAC Design Review'!$S$81","v":"4.3.3.7"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$B$31&'1. HVAC Design Review'!$B$81&\"Zone 2\"&\"_Plan\"","v":"Heating / Cooling Loads Methodology and OrientationsIn HVAC Design, is the max. minus min. total heat gain across orientations ≤ 6 kBtuh?Zone 2_Plan"},{"$f":"'1. HVAC Design Review'!J81","v":"N/A"},null,{"$f":"'1. HVAC Design Review'!$S$81","v":"4.3.3.7"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$B$31&'1. HVAC Design Review'!$B$81&\"Zone 3\"&\"_Plan\"","v":"Heating / Cooling Loads Methodology and OrientationsIn HVAC Design, is the max. minus min. total heat gain across orientations ≤ 6 kBtuh?Zone 3_Plan"},{"$f":"'1. HVAC Design Review'!K81","v":"N/A"},null,{"$f":"'1. HVAC Design Review'!$S$81","v":"4.3.3.7"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$B$83","v":"Does front orientation of the Home match one of the orientations in the HVAC design?"},{"$f":"'1. HVAC Design Review'!K83","v":"Yes"},null,{"$f":"'1. HVAC Design Review'!S83","v":"4.3.3.6"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$B$64&\"_Plan\"","v":"Does the unique identifier for the building that the Home is in match the HVAC design?_Plan"},{"$f":"'1. HVAC Design Review'!P64","v":"Yes"},null,{"$f":"'1. HVAC Design Review'!$S$64","v":"4.3.3.1"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$B$65&\"_Plan\"","v":"Does the name of the plan for the Home match the HVAC design?_Plan"},{"$f":"'1. HVAC Design Review'!P65","v":"Yes"},null,{"$f":"'1. HVAC Design Review'!$S$65","v":"4.3.3.2"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$B$66&\"_Plan\"","v":"Do the options used in the Home match those in the HVAC design, \nor are they listed in the options the HVAC design can be used with?_Plan"},{"$f":"'1. HVAC Design Review'!P66","v":"Yes"},null,{"$f":"'1. HVAC Design Review'!$S$66","v":"4.3.3.3"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$B$20&'1. HVAC Design Review'!$B$21&\"Zone 1\"&\"_Plan\"","v":"Conditioned Floor Area of Heating / Cooling ZonesHVAC DesignZone 1_Plan"},{"$f":"'1. HVAC Design Review'!N70","v":0},{"$f":"'1. HVAC Design Review'!$R$70","v":"Sq. Ft. "},{"$f":"'1. HVAC Design Review'!$S$69","v":"4.3.3.4"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$B$20&'1. HVAC Design Review'!$B$22&\"Zone 1\"&\"_Plan\"","v":"Conditioned Floor Area of Heating / Cooling ZonesHomeZone 1_Plan"},{"$f":"'1. HVAC Design Review'!N71","v":0},{"$f":"'1. HVAC Design Review'!$R$71","v":"Sq. Ft. "},{"$f":"'1. HVAC Design Review'!$S$69","v":"4.3.3.4"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$B$20&'1. HVAC Design Review'!$B$23&\"Zone 1\"&\"_Plan\"","v":"Conditioned Floor Area of Heating / Cooling ZonesHome is between 300 sq. ft. smaller & 100 sq. ft.  larger than HVAC design?Zone 1_Plan"},{"$f":"'1. HVAC Design Review'!N72","v":"Yes"},null,{"$f":"'1. HVAC Design Review'!$S$69","v":"4.3.3.4"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$B$20&'1. HVAC Design Review'!$B$21&\"Zone 2\"&\"_Plan\"","v":"Conditioned Floor Area of Heating / Cooling ZonesHVAC DesignZone 2_Plan"},{"$f":"'1. HVAC Design Review'!O70","v":0},{"$f":"'1. HVAC Design Review'!$R$70","v":"Sq. Ft. "},{"$f":"'1. HVAC Design Review'!$S$69","v":"4.3.3.4"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$B$20&'1. HVAC Design Review'!$B$22&\"Zone 2\"&\"_Plan\"","v":"Conditioned Floor Area of Heating / Cooling ZonesHomeZone 2_Plan"},{"$f":"'1. HVAC Design Review'!O71","v":0},{"$f":"'1. HVAC Design Review'!$R$71","v":"Sq. Ft. "},{"$f":"'1. HVAC Design Review'!$S$69","v":"4.3.3.4"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$B$20&'1. HVAC Design Review'!$B$23&\"Zone 2\"&\"_Plan\"","v":"Conditioned Floor Area of Heating / Cooling ZonesHome is between 300 sq. ft. smaller & 100 sq. ft.  larger than HVAC design?Zone 2_Plan"},{"$f":"'1. HVAC Design Review'!O72","v":"Yes"},null,{"$f":"'1. HVAC Design Review'!$S$69","v":"4.3.3.4"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$B$20&'1. HVAC Design Review'!$B$21&\"Zone 3\"&\"_Plan\"","v":"Conditioned Floor Area of Heating / Cooling ZonesHVAC DesignZone 3_Plan"},{"$f":"'1. HVAC Design Review'!P70","v":0},{"$f":"'1. HVAC Design Review'!$R$70","v":"Sq. Ft. "},{"$f":"'1. HVAC Design Review'!$S$69","v":"4.3.3.4"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$B$20&'1. HVAC Design Review'!$B$22&\"Zone 3\"&\"_Plan\"","v":"Conditioned Floor Area of Heating / Cooling ZonesHomeZone 3_Plan"},{"$f":"'1. HVAC Design Review'!P71","v":0},{"$f":"'1. HVAC Design Review'!$R$71","v":"Sq. Ft. "},{"$f":"'1. HVAC Design Review'!$S$69","v":"4.3.3.4"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$B$20&'1. HVAC Design Review'!$B$23&\"Zone 3\"&\"_Plan\"","v":"Conditioned Floor Area of Heating / Cooling ZonesHome is between 300 sq. ft. smaller & 100 sq. ft.  larger than HVAC design?Zone 3_Plan"},{"$f":"'1. HVAC Design Review'!P72","v":"Yes"},null,{"$f":"'1. HVAC Design Review'!$S$69","v":"4.3.3.4"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$B$25&'1. HVAC Design Review'!$B$26&\"Zone 1\"&\"_Plan\"","v":"Window Area of Heating / Cooling ZonesHVAC DesignZone 1_Plan"},{"$f":"'1. HVAC Design Review'!N75","v":0},{"$f":"'1. HVAC Design Review'!$R$75","v":"Sq. Ft. "},{"$f":"'1. HVAC Design Review'!$S$74","v":"4.3.3.5"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$B$25&'1. HVAC Design Review'!$B$22&\"Zone 1\"&\"_Plan\"","v":"Window Area of Heating / Cooling ZonesHomeZone 1_Plan"},{"$f":"'1. HVAC Design Review'!N76","v":0},{"$f":"'1. HVAC Design Review'!$R$76","v":"Sq. Ft. "},{"$f":"'1. HVAC Design Review'!$S$74","v":"4.3.3.5"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$B$25&'1. HVAC Design Review'!$B$77&\"Zone 1\"&\"_Plan\"","v":"Window Area of Heating / Cooling ZonesHome is between 60 sq. ft. smaller & 15 sq. ft. larger than HVAC design, \nor for zones with > 500 sq. ft. of windows, between 12% smaller and 3% larger?Zone 1_Plan"},{"$f":"'1. HVAC Design Review'!N77","v":"Yes"},null,{"$f":"'1. HVAC Design Review'!$S$74","v":"4.3.3.5"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$B$25&'1. HVAC Design Review'!$B$26&\"Zone 2\"&\"_Plan\"","v":"Window Area of Heating / Cooling ZonesHVAC DesignZone 2_Plan"},{"$f":"'1. HVAC Design Review'!O75","v":0},{"$f":"'1. HVAC Design Review'!$R$75","v":"Sq. Ft. "},{"$f":"'1. HVAC Design Review'!$S$74","v":"4.3.3.5"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$B$25&'1. HVAC Design Review'!$B$22&\"Zone 2\"&\"_Plan\"","v":"Window Area of Heating / Cooling ZonesHomeZone 2_Plan"},{"$f":"'1. HVAC Design Review'!O76","v":0},{"$f":"'1. HVAC Design Review'!$R$76","v":"Sq. Ft. "},{"$f":"'1. HVAC Design Review'!$S$74","v":"4.3.3.5"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$B$25&'1. HVAC Design Review'!$B$77&\"Zone 2\"&\"_Plan\"","v":"Window Area of Heating / Cooling ZonesHome is between 60 sq. ft. smaller & 15 sq. ft. larger than HVAC design, \nor for zones with > 500 sq. ft. of windows, between 12% smaller and 3% larger?Zone 2_Plan"},{"$f":"'1. HVAC Design Review'!O77","v":"Yes"},null,{"$f":"'1. HVAC Design Review'!$S$74","v":"4.3.3.5"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$B$25&'1. HVAC Design Review'!$B$26&\"Zone 3\"&\"_Plan\"","v":"Window Area of Heating / Cooling ZonesHVAC DesignZone 3_Plan"},{"$f":"'1. HVAC Design Review'!P75","v":0},{"$f":"'1. HVAC Design Review'!$R$75","v":"Sq. Ft. "},{"$f":"'1. HVAC Design Review'!$S$74","v":"4.3.3.5"}]
[null,{"$f":"MID(CELL(\"filename\",INDIRECT(RIGHT(_xlfn.FORMULATEXT(D131),LEN(_xlfn.FORMULATEXT(D131))-1),TRUE)),FIND(\"]\",CELL(\"filename\",INDIRECT(RIGHT(_xlfn.FORMULATEXT(D131),LEN(_xlfn.FORMULATEXT(D131))-1),TRUE)))+1,255)","v":"1. HVAC Design Review"},{"$f":"'1. HVAC Design Review'!$B$25&'1. HVAC Design Review'!$B$22&\"Zone 3\"&\"_Plan\"","v":"Window Area of Heating / Cooling ZonesHomeZone 3_Plan"},{"$f":"'1. HVAC Design Review'!P76","v":0},{"$f":"'1. HVAC Design Review'!$R$76","v":"Sq. Ft. "},{"$f":"'1. HVAC Design Review'!$S$74","v":"4.3.3.5"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$B$25&'1. HVAC Design Review'!$B$77&\"Zone 3\"&\"_Plan\"","v":"Window Area of Heating / Cooling ZonesHome is between 60 sq. ft. smaller & 15 sq. ft. larger than HVAC design, \nor for zones with > 500 sq. ft. of windows, between 12% smaller and 3% larger?Zone 3_Plan"},{"$f":"'1. HVAC Design Review'!P77","v":"Yes"},null,{"$f":"'1. HVAC Design Review'!$S$74","v":"4.3.3.5"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$B$31&'1. HVAC Design Review'!$B$81&\"Zone 1\"&\"_Plan\"","v":"Heating / Cooling Loads Methodology and OrientationsIn HVAC Design, is the max. minus min. total heat gain across orientations ≤ 6 kBtuh?Zone 1_Plan"},{"$f":"'1. HVAC Design Review'!N81","v":"N/A"},null,{"$f":"'1. HVAC Design Review'!$S$81","v":"4.3.3.7"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$B$31&'1. HVAC Design Review'!$B$81&\"Zone 2\"&\"_Plan\"","v":"Heating / Cooling Loads Methodology and OrientationsIn HVAC Design, is the max. minus min. total heat gain across orientations ≤ 6 kBtuh?Zone 2_Plan"},{"$f":"'1. HVAC Design Review'!O81","v":"N/A"},null,{"$f":"'1. HVAC Design Review'!$S$81","v":"4.3.3.7"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$B$31&'1. HVAC Design Review'!$B$81&\"Zone 3\"&\"_Plan\"","v":"Heating / Cooling Loads Methodology and OrientationsIn HVAC Design, is the max. minus min. total heat gain across orientations ≤ 6 kBtuh?Zone 3_Plan"},{"$f":"'1. HVAC Design Review'!P81","v":"N/A"},null,{"$f":"'1. HVAC Design Review'!$S$81","v":"4.3.3.7"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$B$83&\"_Plan\"","v":"Does front orientation of the Home match one of the orientations in the HVAC design?_Plan"},{"$f":"'1. HVAC Design Review'!P83","v":"Yes"},null,{"$f":"'1. HVAC Design Review'!$S$83","v":"4.3.3.6"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$B$64&\"_Field\"","v":"Does the unique identifier for the building that the Home is in match the HVAC design?_Field"},{"$f":"'1. HVAC Design Review'!P89","v":"Yes"},null,{"$f":"'1. HVAC Design Review'!$S$64","v":"4.3.3.1"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$B$65&\"_Field\"","v":"Does the name of the plan for the Home match the HVAC design?_Field"},{"$f":"'1. HVAC Design Review'!P90","v":0},null,{"$f":"'1. HVAC Design Review'!$S$65","v":"4.3.3.2"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$B$66&\"_Field\"","v":"Do the options used in the Home match those in the HVAC design, \nor are they listed in the options the HVAC design can be used with?_Field"},{"$f":"'1. HVAC Design Review'!P91","v":0},null,{"$f":"'1. HVAC Design Review'!$S$66","v":"4.3.3.3"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$B$20&'1. HVAC Design Review'!$B$21&\"Zone 1\"&\"_Field\"","v":"Conditioned Floor Area of Heating / Cooling ZonesHVAC DesignZone 1_Field"},{"$f":"'1. HVAC Design Review'!N95","v":0},{"$f":"'1. HVAC Design Review'!$R$70","v":"Sq. Ft. "},{"$f":"'1. HVAC Design Review'!$S$69","v":"4.3.3.4"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$B$20&'1. HVAC Design Review'!$B$22&\"Zone 1\"&\"_Field\"","v":"Conditioned Floor Area of Heating / Cooling ZonesHomeZone 1_Field"},{"$f":"'1. HVAC Design Review'!N96","v":0},{"$f":"'1. HVAC Design Review'!$R$71","v":"Sq. Ft. "},{"$f":"'1. HVAC Design Review'!$S$69","v":"4.3.3.4"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$B$20&'1. HVAC Design Review'!$B$23&\"Zone 1\"&\"_Field\"","v":"Conditioned Floor Area of Heating / Cooling ZonesHome is between 300 sq. ft. smaller & 100 sq. ft.  larger than HVAC design?Zone 1_Field"},{"$f":"'1. HVAC Design Review'!N97","v":0},null,{"$f":"'1. HVAC Design Review'!$S$69","v":"4.3.3.4"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$B$20&'1. HVAC Design Review'!$B$21&\"Zone 2\"&\"_Field\"","v":"Conditioned Floor Area of Heating / Cooling ZonesHVAC DesignZone 2_Field"},{"$f":"'1. HVAC Design Review'!O95","v":0},{"$f":"'1. HVAC Design Review'!$R$70","v":"Sq. Ft. "},{"$f":"'1. HVAC Design Review'!$S$69","v":"4.3.3.4"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$B$20&'1. HVAC Design Review'!$B$22&\"Zone 2\"&\"_Field\"","v":"Conditioned Floor Area of Heating / Cooling ZonesHomeZone 2_Field"},{"$f":"'1. HVAC Design Review'!O96","v":0},{"$f":"'1. HVAC Design Review'!$R$71","v":"Sq. Ft. "},{"$f":"'1. HVAC Design Review'!$S$69","v":"4.3.3.4"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$B$20&'1. HVAC Design Review'!$B$23&\"Zone 2\"&\"_Field\"","v":"Conditioned Floor Area of Heating / Cooling ZonesHome is between 300 sq. ft. smaller & 100 sq. ft.  larger than HVAC design?Zone 2_Field"},{"$f":"'1. HVAC Design Review'!O97","v":0},null,{"$f":"'1. HVAC Design Review'!$S$69","v":"4.3.3.4"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$B$20&'1. HVAC Design Review'!$B$21&\"Zone 3\"&\"_Field\"","v":"Conditioned Floor Area of Heating / Cooling ZonesHVAC DesignZone 3_Field"},{"$f":"'1. HVAC Design Review'!P95","v":0},{"$f":"'1. HVAC Design Review'!$R$70","v":"Sq. Ft. "},{"$f":"'1. HVAC Design Review'!$S$69","v":"4.3.3.4"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$B$20&'1. HVAC Design Review'!$B$22&\"Zone 3\"&\"_Field\"","v":"Conditioned Floor Area of Heating / Cooling ZonesHomeZone 3_Field"},{"$f":"'1. HVAC Design Review'!P96","v":0},{"$f":"'1. HVAC Design Review'!$R$71","v":"Sq. Ft. "},{"$f":"'1. HVAC Design Review'!$S$69","v":"4.3.3.4"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$B$20&'1. HVAC Design Review'!$B$23&\"Zone 3\"&\"_Field\"","v":"Conditioned Floor Area of Heating / Cooling ZonesHome is between 300 sq. ft. smaller & 100 sq. ft.  larger than HVAC design?Zone 3_Field"},{"$f":"'1. HVAC Design Review'!P97","v":0},null,{"$f":"'1. HVAC Design Review'!$S$69","v":"4.3.3.4"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$B$25&'1. HVAC Design Review'!$B$26&\"Zone 1\"&\"_Field\"","v":"Window Area of Heating / Cooling ZonesHVAC DesignZone 1_Field"},{"$f":"'1. HVAC Design Review'!N100","v":0},{"$f":"'1. HVAC Design Review'!$R$75","v":"Sq. Ft. "},{"$f":"'1. HVAC Design Review'!$S$74","v":"4.3.3.5"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$B$25&'1. HVAC Design Review'!$B$22&\"Zone 1\"&\"_Field\"","v":"Window Area of Heating / Cooling ZonesHomeZone 1_Field"},{"$f":"'1. HVAC Design Review'!N101","v":"Zone 1"},{"$f":"'1. HVAC Design Review'!$R$76","v":"Sq. Ft. "},{"$f":"'1. HVAC Design Review'!$S$74","v":"4.3.3.5"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$B$25&'1. HVAC Design Review'!$B$77&\"Zone 1\"&\"_Field\"","v":"Window Area of Heating / Cooling ZonesHome is between 60 sq. ft. smaller & 15 sq. ft. larger than HVAC design, \nor for zones with > 500 sq. ft. of windows, between 12% smaller and 3% larger?Zone 1_Field"},{"$f":"'1. HVAC Design Review'!N102","v":0},null,{"$f":"'1. HVAC Design Review'!$S$74","v":"4.3.3.5"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$B$25&'1. HVAC Design Review'!$B$26&\"Zone 2\"&\"_Field\"","v":"Window Area of Heating / Cooling ZonesHVAC DesignZone 2_Field"},{"$f":"'1. HVAC Design Review'!O100","v":0},{"$f":"'1. HVAC Design Review'!$R$75","v":"Sq. Ft. "},{"$f":"'1. HVAC Design Review'!$S$74","v":"4.3.3.5"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$B$25&'1. HVAC Design Review'!$B$22&\"Zone 2\"&\"_Field\"","v":"Window Area of Heating / Cooling ZonesHomeZone 2_Field"},{"$f":"'1. HVAC Design Review'!O101","v":"Zone 2"},{"$f":"'1. HVAC Design Review'!$R$76","v":"Sq. Ft. "},{"$f":"'1. HVAC Design Review'!$S$74","v":"4.3.3.5"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$B$25&'1. HVAC Design Review'!$B$77&\"Zone 2\"&\"_Field\"","v":"Window Area of Heating / Cooling ZonesHome is between 60 sq. ft. smaller & 15 sq. ft. larger than HVAC design, \nor for zones with > 500 sq. ft. of windows, between 12% smaller and 3% larger?Zone 2_Field"},{"$f":"'1. HVAC Design Review'!O102","v":0},null,{"$f":"'1. HVAC Design Review'!$S$74","v":"4.3.3.5"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$B$25&'1. HVAC Design Review'!$B$26&\"Zone 3\"&\"_Field\"","v":"Window Area of Heating / Cooling ZonesHVAC DesignZone 3_Field"},{"$f":"'1. HVAC Design Review'!P100","v":0},{"$f":"'1. HVAC Design Review'!$R$75","v":"Sq. Ft. "},{"$f":"'1. HVAC Design Review'!$S$74","v":"4.3.3.5"}]
[null,{"$f":"MID(CELL(\"filename\",INDIRECT(RIGHT(_xlfn.FORMULATEXT(D156),LEN(_xlfn.FORMULATEXT(D156))-1),TRUE)),FIND(\"]\",CELL(\"filename\",INDIRECT(RIGHT(_xlfn.FORMULATEXT(D156),LEN(_xlfn.FORMULATEXT(D156))-1),TRUE)))+1,255)","v":"1. HVAC Design Review"},{"$f":"'1. HVAC Design Review'!$B$25&'1. HVAC Design Review'!$B$22&\"Zone 3\"&\"_Field\"","v":"Window Area of Heating / Cooling ZonesHomeZone 3_Field"},{"$f":"'1. HVAC Design Review'!P101","v":"Zone 3"},{"$f":"'1. HVAC Design Review'!$R$76","v":"Sq. Ft. "},{"$f":"'1. HVAC Design Review'!$S$74","v":"4.3.3.5"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$B$25&'1. HVAC Design Review'!$B$77&\"Zone 3\"&\"_Field\"","v":"Window Area of Heating / Cooling ZonesHome is between 60 sq. ft. smaller & 15 sq. ft. larger than HVAC design, \nor for zones with > 500 sq. ft. of windows, between 12% smaller and 3% larger?Zone 3_Field"},{"$f":"'1. HVAC Design Review'!P102","v":0},null,{"$f":"'1. HVAC Design Review'!$S$74","v":"4.3.3.5"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$B$31&'1. HVAC Design Review'!$B$81&\"Zone 1\"&\"_Field\"","v":"Heating / Cooling Loads Methodology and OrientationsIn HVAC Design, is the max. minus min. total heat gain across orientations ≤ 6 kBtuh?Zone 1_Field"},{"$f":"'1. HVAC Design Review'!N106","v":"Zone 1"},null,{"$f":"'1. HVAC Design Review'!$S$81","v":"4.3.3.7"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$B$31&'1. HVAC Design Review'!$B$81&\"Zone 2\"&\"_Field\"","v":"Heating / Cooling Loads Methodology and OrientationsIn HVAC Design, is the max. minus min. total heat gain across orientations ≤ 6 kBtuh?Zone 2_Field"},{"$f":"'1. HVAC Design Review'!O106","v":"Zone 2"},null,{"$f":"'1. HVAC Design Review'!$S$81","v":"4.3.3.7"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$B$31&'1. HVAC Design Review'!$B$81&\"Zone 3\"&\"_Field\"","v":"Heating / Cooling Loads Methodology and OrientationsIn HVAC Design, is the max. minus min. total heat gain across orientations ≤ 6 kBtuh?Zone 3_Field"},{"$f":"'1. HVAC Design Review'!P106","v":"Zone 3"},null,{"$f":"'1. HVAC Design Review'!$S$81","v":"4.3.3.7"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$B$83&\"_Field\"","v":"Does front orientation of the Home match one of the orientations in the HVAC design?_Field"},{"$f":"'1. HVAC Design Review'!P108","v":0},null,{"$f":"'1. HVAC Design Review'!$S$83","v":"4.3.3.6"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$A$85&'1. HVAC Design Review'!$N$85","v":"For All Dwellings, Townhouses, Dwelling Units, and Sleeping UnitsComplete this section?"},{"$f":"'1. HVAC Design Review'!P85","v":"Yes"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$A$85&'1. HVAC Design Review'!$O$86","v":"For All Dwellings, Townhouses, Dwelling Units, and Sleeping UnitsRequired data inputs provided? "},{"$f":"'1. HVAC Design Review'!P86","v":"No"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$B$89&\"_Plan\"","v":"Has all required design documentation been collected, or an IVR obtained? _Plan"},{"$f":"'1. HVAC Design Review'!K89","v":"Yes"},null,{"$f":"'1. HVAC Design Review'!$S$89","v":4.3}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$B$92&\"_Plan\"","v":"Are indoor design temps in HVAC design 70°F for heating season & 75°F for cooling season?_Plan"},{"$f":"'1. HVAC Design Review'!K92","v":"Yes"},null,{"$f":"'1. HVAC Design Review'!$S$92","v":"4.3.5"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$B$93&\"_Plan\"","v":"Are outdoor design temps in HVAC design within limits defined in Appendix A?_Plan"},{"$f":"'1. HVAC Design Review'!K93","v":"Yes"},null,{"$f":"'1. HVAC Design Review'!$S$93","v":"4.3.6"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$B$96&\"_Plan\"","v":"Number of occupants used in HVAC design across all zones:_Plan"},{"$f":"'1. HVAC Design Review'!K96","v":0},null,{"$f":"'1. HVAC Design Review'!$S$95","v":"4.3.7"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$B$97&\"_Plan\"","v":"Number of bedrooms in Home:_Plan"},{"$f":"'1. HVAC Design Review'!K97","v":0},null,{"$f":"'1. HVAC Design Review'!$S$95","v":"4.3.7"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$B$98&\"_Plan\"","v":"Number of occupants in Home:_Plan"},{"$f":"'1. HVAC Design Review'!K98","v":1},null,{"$f":"'1. HVAC Design Review'!$S$95","v":"4.3.7"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$B$99&\"_Plan\"","v":"Number of occupants in Home within ±2 of occupants in HVAC Design?_Plan"},{"$f":"'1. HVAC Design Review'!K99","v":"Yes"},null,{"$f":"'1. HVAC Design Review'!$S$95","v":"4.3.7"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$B$101&'1. HVAC Design Review'!$B$102&\"Zone 1\"&\"_Plan\"","v":"Window SHGCPredominant window SHGC in HVAC designZone 1_Plan"},{"$f":"'1. HVAC Design Review'!I102","v":0},null,{"$f":"'1. HVAC Design Review'!$S$101","v":"4.3.8"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$B$101&'1. HVAC Design Review'!$B$103&\"Zone 1\"&\"_Plan\"","v":"Window SHGCPredominant window SHGC in HomeZone 1_Plan"},{"$f":"'1. HVAC Design Review'!I103","v":0},null,{"$f":"'1. HVAC Design Review'!$S$101","v":"4.3.8"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$B$101&'1. HVAC Design Review'!$B$104&\"Zone 1\"&\"_Plan\"","v":"Window SHGCHome is within ±0.1 of HVAC design?Zone 1_Plan"},{"$f":"'1. HVAC Design Review'!I104","v":"Yes"},null,{"$f":"'1. HVAC Design Review'!$S$101","v":"4.3.8"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$B$101&'1. HVAC Design Review'!$B$102&\"Zone 2\"&\"_Plan\"","v":"Window SHGCPredominant window SHGC in HVAC designZone 2_Plan"},{"$f":"'1. HVAC Design Review'!J102","v":0},null,{"$f":"'1. HVAC Design Review'!$S$101","v":"4.3.8"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$B$101&'1. HVAC Design Review'!$B$103&\"Zone 2\"&\"_Plan\"","v":"Window SHGCPredominant window SHGC in HomeZone 2_Plan"},{"$f":"'1. HVAC Design Review'!J103","v":0},null,{"$f":"'1. HVAC Design Review'!$S$101","v":"4.3.8"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$B$101&'1. HVAC Design Review'!$B$104&\"Zone 2\"&\"_Plan\"","v":"Window SHGCHome is within ±0.1 of HVAC design?Zone 2_Plan"},{"$f":"'1. HVAC Design Review'!J104","v":"Yes"},null,{"$f":"'1. HVAC Design Review'!$S$101","v":"4.3.8"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$B$101&'1. HVAC Design Review'!$B$102&\"Zone 3\"&\"_Plan\"","v":"Window SHGCPredominant window SHGC in HVAC designZone 3_Plan"},{"$f":"'1. HVAC Design Review'!K102","v":0},null,{"$f":"'1. HVAC Design Review'!$S$101","v":"4.3.8"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$B$101&'1. HVAC Design Review'!$B$103&\"Zone 3\"&\"_Plan\"","v":"Window SHGCPredominant window SHGC in HomeZone 3_Plan"},{"$f":"'1. HVAC Design Review'!K103","v":0},null,{"$f":"'1. HVAC Design Review'!$S$101","v":"4.3.8"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$B$101&'1. HVAC Design Review'!$B$104&\"Zone 3\"&\"_Plan\"","v":"Window SHGCHome is within ±0.1 of HVAC design?Zone 3_Plan"},{"$f":"'1. HVAC Design Review'!K104","v":"Yes"},null,{"$f":"'1. HVAC Design Review'!$S$101","v":"4.3.8"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$B$106&'1. HVAC Design Review'!$B$107&\"Zone 1\"&\"_Plan\"","v":"Above-Grade Wall Nominal R-ValuePredominant wall R-value in HVAC designZone 1_Plan"},{"$f":"'1. HVAC Design Review'!I107","v":0},null,{"$f":"'1. HVAC Design Review'!$S$106","v":"4.3.9"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$B$106&'1. HVAC Design Review'!$B$108&\"Zone 1\"&\"_Plan\"","v":"Above-Grade Wall Nominal R-ValuePredominant wall R-value in HomeZone 1_Plan"},{"$f":"'1. HVAC Design Review'!I108","v":0},null,{"$f":"'1. HVAC Design Review'!$S$106","v":"4.3.9"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$B$106&'1. HVAC Design Review'!$B$109&\"Zone 1\"&\"_Plan\"","v":"Above-Grade Wall Nominal R-ValueHome is within ±R-2 of HVAC design?Zone 1_Plan"},{"$f":"'1. HVAC Design Review'!I109","v":"Yes"},null,{"$f":"'1. HVAC Design Review'!$S$106","v":"4.3.9"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$B$106&'1. HVAC Design Review'!$B$107&\"Zone 2\"&\"_Plan\"","v":"Above-Grade Wall Nominal R-ValuePredominant wall R-value in HVAC designZone 2_Plan"},{"$f":"'1. HVAC Design Review'!J107","v":0},null,{"$f":"'1. HVAC Design Review'!$S$106","v":"4.3.9"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$B$106&'1. HVAC Design Review'!$B$108&\"Zone 2\"&\"_Plan\"","v":"Above-Grade Wall Nominal R-ValuePredominant wall R-value in HomeZone 2_Plan"},{"$f":"'1. HVAC Design Review'!J108","v":0},null,{"$f":"'1. HVAC Design Review'!$S$106","v":"4.3.9"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$B$106&'1. HVAC Design Review'!$B$109&\"Zone 2\"&\"_Plan\"","v":"Above-Grade Wall Nominal R-ValueHome is within ±R-2 of HVAC design?Zone 2_Plan"},{"$f":"'1. HVAC Design Review'!J109","v":"Yes"},null,{"$f":"'1. HVAC Design Review'!$S$106","v":"4.3.9"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$B$106&'1. HVAC Design Review'!$B$107&\"Zone 3\"&\"_Plan\"","v":"Above-Grade Wall Nominal R-ValuePredominant wall R-value in HVAC designZone 3_Plan"},{"$f":"'1. HVAC Design Review'!K107","v":0},null,{"$f":"'1. HVAC Design Review'!$S$106","v":"4.3.9"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$B$106&'1. HVAC Design Review'!$B$108&\"Zone 3\"&\"_Plan\"","v":"Above-Grade Wall Nominal R-ValuePredominant wall R-value in HomeZone 3_Plan"},{"$f":"'1. HVAC Design Review'!K108","v":0},null,{"$f":"'1. HVAC Design Review'!$S$106","v":"4.3.9"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$B$106&'1. HVAC Design Review'!$B$109&\"Zone 3\"&\"_Plan\"","v":"Above-Grade Wall Nominal R-ValueHome is within ±R-2 of HVAC design?Zone 3_Plan"},{"$f":"'1. HVAC Design Review'!K109","v":"Yes"},null,{"$f":"'1. HVAC Design Review'!$S$106","v":"4.3.9"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$B$111&'1. HVAC Design Review'!$B$112&\"Zone 1\"&\"_Plan\"","v":"Ceiling Nominal R-ValuePredominant ceiling R-value in HVAC designZone 1_Plan"},{"$f":"'1. HVAC Design Review'!I112","v":0},null,{"$f":"'1. HVAC Design Review'!$S$111","v":"4.3.10"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$B$111&'1. HVAC Design Review'!$B$113&\"Zone 1\"&\"_Plan\"","v":"Ceiling Nominal R-ValuePredominant ceiling R-value in HomeZone 1_Plan"},{"$f":"'1. HVAC Design Review'!I113","v":0},null,{"$f":"'1. HVAC Design Review'!$S$111","v":"4.3.10"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$B$111&'1. HVAC Design Review'!$B$114&\"Zone 1\"&\"_Plan\"","v":"Ceiling Nominal R-ValueHome is within ±R-4 of HVAC design?Zone 1_Plan"},{"$f":"'1. HVAC Design Review'!I114","v":"Yes"},null,{"$f":"'1. HVAC Design Review'!$S$111","v":"4.3.10"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$B$111&'1. HVAC Design Review'!$B$112&\"Zone 2\"&\"_Plan\"","v":"Ceiling Nominal R-ValuePredominant ceiling R-value in HVAC designZone 2_Plan"},{"$f":"'1. HVAC Design Review'!J112","v":0},null,{"$f":"'1. HVAC Design Review'!$S$111","v":"4.3.10"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$B$111&'1. HVAC Design Review'!$B$113&\"Zone 2\"&\"_Plan\"","v":"Ceiling Nominal R-ValuePredominant ceiling R-value in HomeZone 2_Plan"},{"$f":"'1. HVAC Design Review'!J113","v":0},null,{"$f":"'1. HVAC Design Review'!$S$111","v":"4.3.10"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$B$111&'1. HVAC Design Review'!$B$114&\"Zone 2\"&\"_Plan\"","v":"Ceiling Nominal R-ValueHome is within ±R-4 of HVAC design?Zone 2_Plan"},{"$f":"'1. HVAC Design Review'!J114","v":"Yes"},null,{"$f":"'1. HVAC Design Review'!$S$111","v":"4.3.10"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$B$111&'1. HVAC Design Review'!$B$112&\"Zone 3\"&\"_Plan\"","v":"Ceiling Nominal R-ValuePredominant ceiling R-value in HVAC designZone 3_Plan"},{"$f":"'1. HVAC Design Review'!K112","v":0},null,{"$f":"'1. HVAC Design Review'!$S$111","v":"4.3.10"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$B$111&'1. HVAC Design Review'!$B$113&\"Zone 3\"&\"_Plan\"","v":"Ceiling Nominal R-ValuePredominant ceiling R-value in HomeZone 3_Plan"},{"$f":"'1. HVAC Design Review'!K113","v":0},null,{"$f":"'1. HVAC Design Review'!$S$111","v":"4.3.10"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$B$111&'1. HVAC Design Review'!$B$114&\"Zone 3\"&\"_Plan\"","v":"Ceiling Nominal R-ValueHome is within ±R-4 of HVAC design?Zone 3_Plan"},{"$f":"'1. HVAC Design Review'!K114","v":"Yes"},null,{"$f":"'1. HVAC Design Review'!$S$111","v":"4.3.10"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$B$117&'1. HVAC Design Review'!$B$118&\"Zone 1\"&\"_Plan\"","v":"Using Quantitative HVAC Design ValueInfiltration rate used in HVAC designZone 1_Plan"},{"$f":"'1. HVAC Design Review'!I118","v":0},{"$f":"'1. HVAC Design Review'!$R$118","v":"ACH50"},{"$f":"'1. HVAC Design Review'!$S$116","v":"4.3.11"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$B$117&'1. HVAC Design Review'!$B$119&\"Zone 1\"&\"_Plan\"","v":"Using Quantitative HVAC Design ValueInfiltration rate of HomeZone 1_Plan"},{"$f":"'1. HVAC Design Review'!I119","v":0},{"$f":"'1. HVAC Design Review'!$R$119","v":"ACH50"},{"$f":"'1. HVAC Design Review'!$S$116","v":"4.3.11"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$B$117&'1. HVAC Design Review'!$B$120&\"Zone 1\"&\"_Plan\"","v":"Using Quantitative HVAC Design ValueHome is within ±2.0 of HVAC design?Zone 1_Plan"},{"$f":"'1. HVAC Design Review'!I120","v":"Yes"},null,{"$f":"'1. HVAC Design Review'!$S$116","v":"4.3.11"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$B$117&'1. HVAC Design Review'!$B$118&\"Zone 2\"&\"_Plan\"","v":"Using Quantitative HVAC Design ValueInfiltration rate used in HVAC designZone 2_Plan"},{"$f":"'1. HVAC Design Review'!J118","v":0},{"$f":"'1. HVAC Design Review'!$R$118","v":"ACH50"},{"$f":"'1. HVAC Design Review'!$S$116","v":"4.3.11"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$B$117&'1. HVAC Design Review'!$B$119&\"Zone 2\"&\"_Plan\"","v":"Using Quantitative HVAC Design ValueInfiltration rate of HomeZone 2_Plan"},{"$f":"'1. HVAC Design Review'!J119","v":0},{"$f":"'1. HVAC Design Review'!$R$119","v":"ACH50"},{"$f":"'1. HVAC Design Review'!$S$116","v":"4.3.11"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$B$117&'1. HVAC Design Review'!$B$120&\"Zone 2\"&\"_Plan\"","v":"Using Quantitative HVAC Design ValueHome is within ±2.0 of HVAC design?Zone 2_Plan"},{"$f":"'1. HVAC Design Review'!J120","v":"Yes"},null,{"$f":"'1. HVAC Design Review'!$S$116","v":"4.3.11"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$B$117&'1. HVAC Design Review'!$B$118&\"Zone 3\"&\"_Plan\"","v":"Using Quantitative HVAC Design ValueInfiltration rate used in HVAC designZone 3_Plan"},{"$f":"'1. HVAC Design Review'!K118","v":0},{"$f":"'1. HVAC Design Review'!$R$118","v":"ACH50"},{"$f":"'1. HVAC Design Review'!$S$116","v":"4.3.11"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$B$117&'1. HVAC Design Review'!$B$119&\"Zone 3\"&\"_Plan\"","v":"Using Quantitative HVAC Design ValueInfiltration rate of HomeZone 3_Plan"},{"$f":"'1. HVAC Design Review'!K119","v":0},{"$f":"'1. HVAC Design Review'!$R$119","v":"ACH50"},{"$f":"'1. HVAC Design Review'!$S$116","v":"4.3.11"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$B$117&'1. HVAC Design Review'!$B$120&\"Zone 3\"&\"_Plan\"","v":"Using Quantitative HVAC Design ValueHome is within ±2.0 of HVAC design?Zone 3_Plan"},{"$f":"'1. HVAC Design Review'!K120","v":"Yes"},null,{"$f":"'1. HVAC Design Review'!$S$116","v":"4.3.11"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$B$122&'1. HVAC Design Review'!$B$123&\"Zone 1\"&\"_Plan\"","v":"Using Qualitative HVAC Design ValueInfiltration rate used in HVAC designZone 1_Plan"},{"$f":"'1. HVAC Design Review'!I123","v":"N/A"},null,{"$f":"'1. HVAC Design Review'!$S$116","v":"4.3.11"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$B$122&'1. HVAC Design Review'!$B$124&\"Zone 1\"&\"_Plan\"","v":"Using Qualitative HVAC Design ValueInfiltration rate of HomeZone 1_Plan"},{"$f":"'1. HVAC Design Review'!I124","v":0},{"$f":"'1. HVAC Design Review'!$R$124","v":"ACH50"},{"$f":"'1. HVAC Design Review'!$S$116","v":"4.3.11"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$B$122&'1. HVAC Design Review'!$B$125&\"Zone 1\"&\"_Plan\"","v":"Using Qualitative HVAC Design ValueHome is within Table 1 tolerance for input used in HVAC design?Zone 1_Plan"},{"$f":"'1. HVAC Design Review'!I125","v":"N/A"},null,{"$f":"'1. HVAC Design Review'!$S$116","v":"4.3.11"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$B$122&'1. HVAC Design Review'!$B$123&\"Zone 2\"&\"_Plan\"","v":"Using Qualitative HVAC Design ValueInfiltration rate used in HVAC designZone 2_Plan"},{"$f":"'1. HVAC Design Review'!J123","v":"N/A"},null,{"$f":"'1. HVAC Design Review'!$S$116","v":"4.3.11"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$B$122&'1. HVAC Design Review'!$B$124&\"Zone 2\"&\"_Plan\"","v":"Using Qualitative HVAC Design ValueInfiltration rate of HomeZone 2_Plan"},{"$f":"'1. HVAC Design Review'!J124","v":0},{"$f":"'1. HVAC Design Review'!$R$124","v":"ACH50"},{"$f":"'1. HVAC Design Review'!$S$116","v":"4.3.11"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$B$122&'1. HVAC Design Review'!$B$125&\"Zone 2\"&\"_Plan\"","v":"Using Qualitative HVAC Design ValueHome is within Table 1 tolerance for input used in HVAC design?Zone 2_Plan"},{"$f":"'1. HVAC Design Review'!J125","v":"N/A"},null,{"$f":"'1. HVAC Design Review'!$S$116","v":"4.3.11"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$B$122&'1. HVAC Design Review'!$B$123&\"Zone 3\"&\"_Plan\"","v":"Using Qualitative HVAC Design ValueInfiltration rate used in HVAC designZone 3_Plan"},{"$f":"'1. HVAC Design Review'!K123","v":"N/A"},null,{"$f":"'1. HVAC Design Review'!$S$116","v":"4.3.11"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$B$122&'1. HVAC Design Review'!$B$124&\"Zone 3\"&\"_Plan\"","v":"Using Qualitative HVAC Design ValueInfiltration rate of HomeZone 3_Plan"},{"$f":"'1. HVAC Design Review'!K124","v":0},{"$f":"'1. HVAC Design Review'!$R$124","v":"ACH50"},{"$f":"'1. HVAC Design Review'!$S$116","v":"4.3.11"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$B$122&'1. HVAC Design Review'!$B$125&\"Zone 3\"&\"_Plan\"","v":"Using Qualitative HVAC Design ValueHome is within Table 1 tolerance for input used in HVAC design?Zone 3_Plan"},{"$f":"'1. HVAC Design Review'!K125","v":"N/A"},null,{"$f":"'1. HVAC Design Review'!$S$116","v":"4.3.11"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$B$127&'1. HVAC Design Review'!$B$128&\"Zone 1\"&\"_Plan\"","v":"Mechanical Ventilation System Design Airflow RateHVAC design's time-averaged vent. rate, for each ventilation zoneZone 1_Plan"},{"$f":"'1. HVAC Design Review'!I128","v":0},null,{"$f":"'1. HVAC Design Review'!$S$127","v":"4.3.12"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$B$127&'1. HVAC Design Review'!$B$129&\"Zone 1\"&\"_Plan\"","v":"Mechanical Ventilation System Design Airflow RateHVAC design's time-averaged vent. rate used in loads, for each heating / cooling zone Zone 1_Plan"},{"$f":"'1. HVAC Design Review'!I129","v":0},null,{"$f":"'1. HVAC Design Review'!$S$127","v":"4.3.12"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$B$127&'1. HVAC Design Review'!$B$128&\"Zone 2\"&\"_Plan\"","v":"Mechanical Ventilation System Design Airflow RateHVAC design's time-averaged vent. rate, for each ventilation zoneZone 2_Plan"},{"$f":"'1. HVAC Design Review'!J128","v":0},null,{"$f":"'1. HVAC Design Review'!$S$127","v":"4.3.12"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$B$127&'1. HVAC Design Review'!$B$129&\"Zone 2\"&\"_Plan\"","v":"Mechanical Ventilation System Design Airflow RateHVAC design's time-averaged vent. rate used in loads, for each heating / cooling zone Zone 2_Plan"},{"$f":"'1. HVAC Design Review'!J129","v":0},null,{"$f":"'1. HVAC Design Review'!$S$127","v":"4.3.12"}]
[null,{"$f":"MID(CELL(\"filename\",INDIRECT(RIGHT(_xlfn.FORMULATEXT(D220),LEN(_xlfn.FORMULATEXT(D220))-1),TRUE)),FIND(\"]\",CELL(\"filename\",INDIRECT(RIGHT(_xlfn.FORMULATEXT(D220),LEN(_xlfn.FORMULATEXT(D220))-1),TRUE)))+1,255)","v":"1. HVAC Design Review"},{"$f":"'1. HVAC Design Review'!$B$127&'1. HVAC Design Review'!$B$128&\"Zone 3\"&\"_Plan\"","v":"Mechanical Ventilation System Design Airflow RateHVAC design's time-averaged vent. rate, for each ventilation zoneZone 3_Plan"},{"$f":"'1. HVAC Design Review'!K128","v":0},null,{"$f":"'1. HVAC Design Review'!$S$127","v":"4.3.12"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$B$127&'1. HVAC Design Review'!$B$129&\"Zone 3\"&\"_Plan\"","v":"Mechanical Ventilation System Design Airflow RateHVAC design's time-averaged vent. rate used in loads, for each heating / cooling zone Zone 3_Plan"},{"$f":"'1. HVAC Design Review'!K129","v":0},null,{"$f":"'1. HVAC Design Review'!$S$127","v":"4.3.12"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$B$131&\"_Plan\"","v":"Is the sum of the time-averaged design vent. rate across all vent. zones equal to the sum of the time-averaged design vent. rate used in the loads across all heated / cooled zones?_Plan"},{"$f":"'1. HVAC Design Review'!K131","v":"Yes"},null,{"$f":"'1. HVAC Design Review'!$S$127","v":"4.3.12"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$B$135&\"_Plan\"","v":"Does each HVAC system in the Home serve the zone(s) specified in the HVAC design?_Plan"},{"$f":"'1. HVAC Design Review'!K135","v":"Yes"},null,{"$f":"'1. HVAC Design Review'!$S$135","v":"4.3.13"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$B$136&\"_Plan\"","v":"Does each HVAC System in Home match the equipment type specified in the HVAC design?_Plan"},{"$f":"'1. HVAC Design Review'!K136","v":"Yes"},null,{"$f":"'1. HVAC Design Review'!$S$136","v":"4.3.14"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$B$138&'1. HVAC Design Review'!$B$139&\"Zone 1\"&\"_Plan\"","v":"Design AirflowsIn HVAC design, sum of design airflows across all roomsZone 1_Plan"},{"$f":"'1. HVAC Design Review'!I139","v":0},{"$f":"'1. HVAC Design Review'!$R$139","v":"CFM"},{"$f":"'1. HVAC Design Review'!$S$139","v":"4.3.15"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$B$138&'1. HVAC Design Review'!$B$140&\"Zone 1\"&\"_Plan\"","v":"Design AirflowsIn HVAC design, design airflow of system in cooling mode (if applicable)Zone 1_Plan"},{"$f":"'1. HVAC Design Review'!I140","v":0},{"$f":"'1. HVAC Design Review'!$R$139","v":"CFM"},{"$f":"'1. HVAC Design Review'!$S$139","v":"4.3.15"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$B$138&'1. HVAC Design Review'!$B$141&\"Zone 1\"&\"_Plan\"","v":"Design AirflowsIn HVAC design, design airflow of system in heating mode (if applicable)Zone 1_Plan"},{"$f":"'1. HVAC Design Review'!I141","v":0},{"$f":"'1. HVAC Design Review'!$R$139","v":"CFM"},{"$f":"'1. HVAC Design Review'!$S$139","v":"4.3.15"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$B$138&'1. HVAC Design Review'!$B$142&\"Zone 1\"&\"_Plan\"","v":"Design AirflowsDoes the sum of design airflows across all rooms equal airflow of mode with higher airflow?Zone 1_Plan"},{"$f":"'1. HVAC Design Review'!I142","v":"Yes"},null,{"$f":"'1. HVAC Design Review'!$S$139","v":"4.3.15"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$B$138&'1. HVAC Design Review'!$B$139&\"Zone 2\"&\"_Plan\"","v":"Design AirflowsIn HVAC design, sum of design airflows across all roomsZone 2_Plan"},{"$f":"'1. HVAC Design Review'!J139","v":0},{"$f":"'1. HVAC Design Review'!$R$139","v":"CFM"},{"$f":"'1. HVAC Design Review'!$S$139","v":"4.3.15"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$B$138&'1. HVAC Design Review'!$B$140&\"Zone 2\"&\"_Plan\"","v":"Design AirflowsIn HVAC design, design airflow of system in cooling mode (if applicable)Zone 2_Plan"},{"$f":"'1. HVAC Design Review'!J140","v":0},{"$f":"'1. HVAC Design Review'!$R$139","v":"CFM"},{"$f":"'1. HVAC Design Review'!$S$139","v":"4.3.15"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$B$138&'1. HVAC Design Review'!$B$141&\"Zone 2\"&\"_Plan\"","v":"Design AirflowsIn HVAC design, design airflow of system in heating mode (if applicable)Zone 2_Plan"},{"$f":"'1. HVAC Design Review'!J141","v":0},{"$f":"'1. HVAC Design Review'!$R$139","v":"CFM"},{"$f":"'1. HVAC Design Review'!$S$139","v":"4.3.15"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$B$138&'1. HVAC Design Review'!$B$142&\"Zone 2\"&\"_Plan\"","v":"Design AirflowsDoes the sum of design airflows across all rooms equal airflow of mode with higher airflow?Zone 2_Plan"},{"$f":"'1. HVAC Design Review'!J142","v":"Yes"},null,{"$f":"'1. HVAC Design Review'!$S$139","v":"4.3.15"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$B$138&'1. HVAC Design Review'!$B$139&\"Zone 3\"&\"_Plan\"","v":"Design AirflowsIn HVAC design, sum of design airflows across all roomsZone 3_Plan"},{"$f":"'1. HVAC Design Review'!K139","v":0},{"$f":"'1. HVAC Design Review'!$R$139","v":"CFM"},{"$f":"'1. HVAC Design Review'!$S$139","v":"4.3.15"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$B$138&'1. HVAC Design Review'!$B$140&\"Zone 3\"&\"_Plan\"","v":"Design AirflowsIn HVAC design, design airflow of system in cooling mode (if applicable)Zone 3_Plan"},{"$f":"'1. HVAC Design Review'!K140","v":0},{"$f":"'1. HVAC Design Review'!$R$139","v":"CFM"},{"$f":"'1. HVAC Design Review'!$S$139","v":"4.3.15"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$B$138&'1. HVAC Design Review'!$B$141&\"Zone 3\"&\"_Plan\"","v":"Design AirflowsIn HVAC design, design airflow of system in heating mode (if applicable)Zone 3_Plan"},{"$f":"'1. HVAC Design Review'!K141","v":0},{"$f":"'1. HVAC Design Review'!$R$139","v":"CFM"},{"$f":"'1. HVAC Design Review'!$S$139","v":"4.3.15"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$B$138&'1. HVAC Design Review'!$B$142&\"Zone 3\"&\"_Plan\"","v":"Design AirflowsDoes the sum of design airflows across all rooms equal airflow of mode with higher airflow?Zone 3_Plan"},{"$f":"'1. HVAC Design Review'!K142","v":"Yes"},null,{"$f":"'1. HVAC Design Review'!$S$139","v":"4.3.15"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$B$89&\"_Field\"","v":"Has all required design documentation been collected, or an IVR obtained? _Field"},{"$f":"'1. HVAC Design Review'!P89","v":"Yes"},null,{"$f":"'1. HVAC Design Review'!$S$89","v":4.3}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$B$92&\"_Field\"","v":"Are indoor design temps in HVAC design 70°F for heating season & 75°F for cooling season?_Field"},{"$f":"'1. HVAC Design Review'!P92","v":"Yes"},null,{"$f":"'1. HVAC Design Review'!$S$92","v":"4.3.5"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$B$93&\"_Field\"","v":"Are outdoor design temps in HVAC design within limits defined in Appendix A?_Field"},{"$f":"'1. HVAC Design Review'!P93","v":"Yes"},null,{"$f":"'1. HVAC Design Review'!$S$93","v":"4.3.6"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$B$96&\"_Field\"","v":"Number of occupants used in HVAC design across all zones:_Field"},{"$f":"'1. HVAC Design Review'!P96","v":0},null,{"$f":"'1. HVAC Design Review'!$S$95","v":"4.3.7"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$B$97&\"_Field\"","v":"Number of bedrooms in Home:_Field"},{"$f":"'1. HVAC Design Review'!P97","v":0},null,{"$f":"'1. HVAC Design Review'!$S$95","v":"4.3.7"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$B$98&\"_Field\"","v":"Number of occupants in Home:_Field"},{"$f":"'1. HVAC Design Review'!P98","v":1},null,{"$f":"'1. HVAC Design Review'!$S$95","v":"4.3.7"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$B$99&\"_Field\"","v":"Number of occupants in Home within ±2 of occupants in HVAC Design?_Field"},{"$f":"'1. HVAC Design Review'!P99","v":"Yes"},null,{"$f":"'1. HVAC Design Review'!$S$95","v":"4.3.7"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$B$101&'1. HVAC Design Review'!$B$102&\"Zone 1\"&\"_Field\"","v":"Window SHGCPredominant window SHGC in HVAC designZone 1_Field"},{"$f":"'1. HVAC Design Review'!N102","v":0},null,{"$f":"'1. HVAC Design Review'!$S$101","v":"4.3.8"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$B$101&'1. HVAC Design Review'!$B$103&\"Zone 1\"&\"_Field\"","v":"Window SHGCPredominant window SHGC in HomeZone 1_Field"},{"$f":"'1. HVAC Design Review'!N103","v":0},null,{"$f":"'1. HVAC Design Review'!$S$101","v":"4.3.8"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$B$101&'1. HVAC Design Review'!$B$104&\"Zone 1\"&\"_Field\"","v":"Window SHGCHome is within ±0.1 of HVAC design?Zone 1_Field"},{"$f":"'1. HVAC Design Review'!N104","v":"Yes"},null,{"$f":"'1. HVAC Design Review'!$S$101","v":"4.3.8"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$B$101&'1. HVAC Design Review'!$B$102&\"Zone 2\"&\"_Field\"","v":"Window SHGCPredominant window SHGC in HVAC designZone 2_Field"},{"$f":"'1. HVAC Design Review'!O102","v":0},null,{"$f":"'1. HVAC Design Review'!$S$101","v":"4.3.8"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$B$101&'1. HVAC Design Review'!$B$103&\"Zone 2\"&\"_Field\"","v":"Window SHGCPredominant window SHGC in HomeZone 2_Field"},{"$f":"'1. HVAC Design Review'!O103","v":0},null,{"$f":"'1. HVAC Design Review'!$S$101","v":"4.3.8"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$B$101&'1. HVAC Design Review'!$B$104&\"Zone 2\"&\"_Field\"","v":"Window SHGCHome is within ±0.1 of HVAC design?Zone 2_Field"},{"$f":"'1. HVAC Design Review'!O104","v":"Yes"},null,{"$f":"'1. HVAC Design Review'!$S$101","v":"4.3.8"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$B$101&'1. HVAC Design Review'!$B$102&\"Zone 3\"&\"_Field\"","v":"Window SHGCPredominant window SHGC in HVAC designZone 3_Field"},{"$f":"'1. HVAC Design Review'!P102","v":0},null,{"$f":"'1. HVAC Design Review'!$S$101","v":"4.3.8"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$B$101&'1. HVAC Design Review'!$B$103&\"Zone 3\"&\"_Field\"","v":"Window SHGCPredominant window SHGC in HomeZone 3_Field"},{"$f":"'1. HVAC Design Review'!P103","v":0},null,{"$f":"'1. HVAC Design Review'!$S$101","v":"4.3.8"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$B$101&'1. HVAC Design Review'!$B$104&\"Zone 3\"&\"_Field\"","v":"Window SHGCHome is within ±0.1 of HVAC design?Zone 3_Field"},{"$f":"'1. HVAC Design Review'!P104","v":"Yes"},null,{"$f":"'1. HVAC Design Review'!$S$101","v":"4.3.8"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$B$106&'1. HVAC Design Review'!$B$107&\"Zone 1\"&\"_Field\"","v":"Above-Grade Wall Nominal R-ValuePredominant wall R-value in HVAC designZone 1_Field"},{"$f":"'1. HVAC Design Review'!N107","v":0},null,{"$f":"'1. HVAC Design Review'!$S$106","v":"4.3.9"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$B$106&'1. HVAC Design Review'!$B$108&\"Zone 1\"&\"_Field\"","v":"Above-Grade Wall Nominal R-ValuePredominant wall R-value in HomeZone 1_Field"},{"$f":"'1. HVAC Design Review'!N108","v":0},null,{"$f":"'1. HVAC Design Review'!$S$106","v":"4.3.9"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$B$106&'1. HVAC Design Review'!$B$109&\"Zone 1\"&\"_Field\"","v":"Above-Grade Wall Nominal R-ValueHome is within ±R-2 of HVAC design?Zone 1_Field"},{"$f":"'1. HVAC Design Review'!N109","v":"Yes"},null,{"$f":"'1. HVAC Design Review'!$S$106","v":"4.3.9"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$B$106&'1. HVAC Design Review'!$B$107&\"Zone 2\"&\"_Field\"","v":"Above-Grade Wall Nominal R-ValuePredominant wall R-value in HVAC designZone 2_Field"},{"$f":"'1. HVAC Design Review'!O107","v":0},null,{"$f":"'1. HVAC Design Review'!$S$106","v":"4.3.9"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$B$106&'1. HVAC Design Review'!$B$108&\"Zone 2\"&\"_Field\"","v":"Above-Grade Wall Nominal R-ValuePredominant wall R-value in HomeZone 2_Field"},{"$f":"'1. HVAC Design Review'!O108","v":0},null,{"$f":"'1. HVAC Design Review'!$S$106","v":"4.3.9"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$B$106&'1. HVAC Design Review'!$B$109&\"Zone 2\"&\"_Field\"","v":"Above-Grade Wall Nominal R-ValueHome is within ±R-2 of HVAC design?Zone 2_Field"},{"$f":"'1. HVAC Design Review'!O109","v":"Yes"},null,{"$f":"'1. HVAC Design Review'!$S$106","v":"4.3.9"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$B$106&'1. HVAC Design Review'!$B$107&\"Zone 3\"&\"_Field\"","v":"Above-Grade Wall Nominal R-ValuePredominant wall R-value in HVAC designZone 3_Field"},{"$f":"'1. HVAC Design Review'!P107","v":0},null,{"$f":"'1. HVAC Design Review'!$S$106","v":"4.3.9"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$B$106&'1. HVAC Design Review'!$B$108&\"Zone 3\"&\"_Field\"","v":"Above-Grade Wall Nominal R-ValuePredominant wall R-value in HomeZone 3_Field"},{"$f":"'1. HVAC Design Review'!P108","v":0},null,{"$f":"'1. HVAC Design Review'!$S$106","v":"4.3.9"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$B$106&'1. HVAC Design Review'!$B$109&\"Zone 3\"&\"_Field\"","v":"Above-Grade Wall Nominal R-ValueHome is within ±R-2 of HVAC design?Zone 3_Field"},{"$f":"'1. HVAC Design Review'!P109","v":"Yes"},null,{"$f":"'1. HVAC Design Review'!$S$106","v":"4.3.9"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$B$111&'1. HVAC Design Review'!$B$112&\"Zone 1\"&\"_Field\"","v":"Ceiling Nominal R-ValuePredominant ceiling R-value in HVAC designZone 1_Field"},{"$f":"'1. HVAC Design Review'!N112","v":0},null,{"$f":"'1. HVAC Design Review'!$S$111","v":"4.3.10"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$B$111&'1. HVAC Design Review'!$B$113&\"Zone 1\"&\"_Field\"","v":"Ceiling Nominal R-ValuePredominant ceiling R-value in HomeZone 1_Field"},{"$f":"'1. HVAC Design Review'!N113","v":0},null,{"$f":"'1. HVAC Design Review'!$S$111","v":"4.3.10"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$B$111&'1. HVAC Design Review'!$B$114&\"Zone 1\"&\"_Field\"","v":"Ceiling Nominal R-ValueHome is within ±R-4 of HVAC design?Zone 1_Field"},{"$f":"'1. HVAC Design Review'!N114","v":"Yes"},null,{"$f":"'1. HVAC Design Review'!$S$111","v":"4.3.10"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$B$111&'1. HVAC Design Review'!$B$112&\"Zone 2\"&\"_Field\"","v":"Ceiling Nominal R-ValuePredominant ceiling R-value in HVAC designZone 2_Field"},{"$f":"'1. HVAC Design Review'!O112","v":0},null,{"$f":"'1. HVAC Design Review'!$S$111","v":"4.3.10"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$B$111&'1. HVAC Design Review'!$B$113&\"Zone 2\"&\"_Field\"","v":"Ceiling Nominal R-ValuePredominant ceiling R-value in HomeZone 2_Field"},{"$f":"'1. HVAC Design Review'!O113","v":0},null,{"$f":"'1. HVAC Design Review'!$S$111","v":"4.3.10"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$B$111&'1. HVAC Design Review'!$B$114&\"Zone 2\"&\"_Field\"","v":"Ceiling Nominal R-ValueHome is within ±R-4 of HVAC design?Zone 2_Field"},{"$f":"'1. HVAC Design Review'!O114","v":"Yes"},null,{"$f":"'1. HVAC Design Review'!$S$111","v":"4.3.10"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$B$111&'1. HVAC Design Review'!$B$112&\"Zone 3\"&\"_Field\"","v":"Ceiling Nominal R-ValuePredominant ceiling R-value in HVAC designZone 3_Field"},{"$f":"'1. HVAC Design Review'!P112","v":0},null,{"$f":"'1. HVAC Design Review'!$S$111","v":"4.3.10"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$B$111&'1. HVAC Design Review'!$B$113&\"Zone 3\"&\"_Field\"","v":"Ceiling Nominal R-ValuePredominant ceiling R-value in HomeZone 3_Field"},{"$f":"'1. HVAC Design Review'!P113","v":0},null,{"$f":"'1. HVAC Design Review'!$S$111","v":"4.3.10"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$B$111&'1. HVAC Design Review'!$B$114&\"Zone 3\"&\"_Field\"","v":"Ceiling Nominal R-ValueHome is within ±R-4 of HVAC design?Zone 3_Field"},{"$f":"'1. HVAC Design Review'!P114","v":"Yes"},null,{"$f":"'1. HVAC Design Review'!$S$111","v":"4.3.10"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$B$117&'1. HVAC Design Review'!$B$118&\"Zone 1\"&\"_Field\"","v":"Using Quantitative HVAC Design ValueInfiltration rate used in HVAC designZone 1_Field"},{"$f":"'1. HVAC Design Review'!N118","v":0},{"$f":"'1. HVAC Design Review'!$R$118","v":"ACH50"},{"$f":"'1. HVAC Design Review'!$S$116","v":"4.3.11"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$B$117&'1. HVAC Design Review'!$B$119&\"Zone 1\"&\"_Field\"","v":"Using Quantitative HVAC Design ValueInfiltration rate of HomeZone 1_Field"},{"$f":"'1. HVAC Design Review'!N119","v":0},{"$f":"'1. HVAC Design Review'!$R$119","v":"ACH50"},{"$f":"'1. HVAC Design Review'!$S$116","v":"4.3.11"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$B$117&'1. HVAC Design Review'!$B$120&\"Zone 1\"&\"_Field\"","v":"Using Quantitative HVAC Design ValueHome is within ±2.0 of HVAC design?Zone 1_Field"},{"$f":"'1. HVAC Design Review'!N120","v":"Yes"},null,{"$f":"'1. HVAC Design Review'!$S$116","v":"4.3.11"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$B$117&'1. HVAC Design Review'!$B$118&\"Zone 2\"&\"_Field\"","v":"Using Quantitative HVAC Design ValueInfiltration rate used in HVAC designZone 2_Field"},{"$f":"'1. HVAC Design Review'!O118","v":0},{"$f":"'1. HVAC Design Review'!$R$118","v":"ACH50"},{"$f":"'1. HVAC Design Review'!$S$116","v":"4.3.11"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$B$117&'1. HVAC Design Review'!$B$119&\"Zone 2\"&\"_Field\"","v":"Using Quantitative HVAC Design ValueInfiltration rate of HomeZone 2_Field"},{"$f":"'1. HVAC Design Review'!O119","v":0},{"$f":"'1. HVAC Design Review'!$R$119","v":"ACH50"},{"$f":"'1. HVAC Design Review'!$S$116","v":"4.3.11"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$B$117&'1. HVAC Design Review'!$B$120&\"Zone 2\"&\"_Field\"","v":"Using Quantitative HVAC Design ValueHome is within ±2.0 of HVAC design?Zone 2_Field"},{"$f":"'1. HVAC Design Review'!O120","v":"Yes"},null,{"$f":"'1. HVAC Design Review'!$S$116","v":"4.3.11"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$B$117&'1. HVAC Design Review'!$B$118&\"Zone 3\"&\"_Field\"","v":"Using Quantitative HVAC Design ValueInfiltration rate used in HVAC designZone 3_Field"},{"$f":"'1. HVAC Design Review'!P118","v":0},{"$f":"'1. HVAC Design Review'!$R$118","v":"ACH50"},{"$f":"'1. HVAC Design Review'!$S$116","v":"4.3.11"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$B$117&'1. HVAC Design Review'!$B$119&\"Zone 3\"&\"_Field\"","v":"Using Quantitative HVAC Design ValueInfiltration rate of HomeZone 3_Field"},{"$f":"'1. HVAC Design Review'!P119","v":0},{"$f":"'1. HVAC Design Review'!$R$119","v":"ACH50"},{"$f":"'1. HVAC Design Review'!$S$116","v":"4.3.11"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$B$117&'1. HVAC Design Review'!$B$120&\"Zone 3\"&\"_Field\"","v":"Using Quantitative HVAC Design ValueHome is within ±2.0 of HVAC design?Zone 3_Field"},{"$f":"'1. HVAC Design Review'!P120","v":"Yes"},null,{"$f":"'1. HVAC Design Review'!$S$116","v":"4.3.11"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$B$122&'1. HVAC Design Review'!$B$123&\"Zone 1\"&\"_Field\"","v":"Using Qualitative HVAC Design ValueInfiltration rate used in HVAC designZone 1_Field"},{"$f":"'1. HVAC Design Review'!N123","v":"N/A"},null,{"$f":"'1. HVAC Design Review'!$S$116","v":"4.3.11"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$B$122&'1. HVAC Design Review'!$B$124&\"Zone 1\"&\"_Field\"","v":"Using Qualitative HVAC Design ValueInfiltration rate of HomeZone 1_Field"},{"$f":"'1. HVAC Design Review'!N124","v":0},{"$f":"'1. HVAC Design Review'!$R$124","v":"ACH50"},{"$f":"'1. HVAC Design Review'!$S$116","v":"4.3.11"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$B$122&'1. HVAC Design Review'!$B$125&\"Zone 1\"&\"_Field\"","v":"Using Qualitative HVAC Design ValueHome is within Table 1 tolerance for input used in HVAC design?Zone 1_Field"},{"$f":"'1. HVAC Design Review'!N125","v":"N/A"},null,{"$f":"'1. HVAC Design Review'!$S$116","v":"4.3.11"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$B$122&'1. HVAC Design Review'!$B$123&\"Zone 2\"&\"_Field\"","v":"Using Qualitative HVAC Design ValueInfiltration rate used in HVAC designZone 2_Field"},{"$f":"'1. HVAC Design Review'!O123","v":"N/A"},null,{"$f":"'1. HVAC Design Review'!$S$116","v":"4.3.11"}]
[null,{"$f":"MID(CELL(\"filename\",INDIRECT(RIGHT(_xlfn.FORMULATEXT(D284),LEN(_xlfn.FORMULATEXT(D284))-1),TRUE)),FIND(\"]\",CELL(\"filename\",INDIRECT(RIGHT(_xlfn.FORMULATEXT(D284),LEN(_xlfn.FORMULATEXT(D284))-1),TRUE)))+1,255)","v":"1. HVAC Design Review"},{"$f":"'1. HVAC Design Review'!$B$122&'1. HVAC Design Review'!$B$124&\"Zone 2\"&\"_Field\"","v":"Using Qualitative HVAC Design ValueInfiltration rate of HomeZone 2_Field"},{"$f":"'1. HVAC Design Review'!O124","v":0},{"$f":"'1. HVAC Design Review'!$R$124","v":"ACH50"},{"$f":"'1. HVAC Design Review'!$S$116","v":"4.3.11"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$B$122&'1. HVAC Design Review'!$B$125&\"Zone 2\"&\"_Field\"","v":"Using Qualitative HVAC Design ValueHome is within Table 1 tolerance for input used in HVAC design?Zone 2_Field"},{"$f":"'1. HVAC Design Review'!O125","v":"N/A"},null,{"$f":"'1. HVAC Design Review'!$S$116","v":"4.3.11"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$B$122&'1. HVAC Design Review'!$B$123&\"Zone 3\"&\"_Field\"","v":"Using Qualitative HVAC Design ValueInfiltration rate used in HVAC designZone 3_Field"},{"$f":"'1. HVAC Design Review'!P123","v":"N/A"},null,{"$f":"'1. HVAC Design Review'!$S$116","v":"4.3.11"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$B$122&'1. HVAC Design Review'!$B$124&\"Zone 3\"&\"_Field\"","v":"Using Qualitative HVAC Design ValueInfiltration rate of HomeZone 3_Field"},{"$f":"'1. HVAC Design Review'!P124","v":0},{"$f":"'1. HVAC Design Review'!$R$124","v":"ACH50"},{"$f":"'1. HVAC Design Review'!$S$116","v":"4.3.11"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$B$122&'1. HVAC Design Review'!$B$125&\"Zone 3\"&\"_Field\"","v":"Using Qualitative HVAC Design ValueHome is within Table 1 tolerance for input used in HVAC design?Zone 3_Field"},{"$f":"'1. HVAC Design Review'!P125","v":"N/A"},null,{"$f":"'1. HVAC Design Review'!$S$116","v":"4.3.11"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$B$127&'1. HVAC Design Review'!$B$128&\"Zone 1\"&\"_Field\"","v":"Mechanical Ventilation System Design Airflow RateHVAC design's time-averaged vent. rate, for each ventilation zoneZone 1_Field"},{"$f":"'1. HVAC Design Review'!N128","v":0},null,{"$f":"'1. HVAC Design Review'!$S$127","v":"4.3.12"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$B$127&'1. HVAC Design Review'!$B$129&\"Zone 1\"&\"_Field\"","v":"Mechanical Ventilation System Design Airflow RateHVAC design's time-averaged vent. rate used in loads, for each heating / cooling zone Zone 1_Field"},{"$f":"'1. HVAC Design Review'!N129","v":0},null,{"$f":"'1. HVAC Design Review'!$S$127","v":"4.3.12"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$B$127&'1. HVAC Design Review'!$B$128&\"Zone 2\"&\"_Field\"","v":"Mechanical Ventilation System Design Airflow RateHVAC design's time-averaged vent. rate, for each ventilation zoneZone 2_Field"},{"$f":"'1. HVAC Design Review'!O128","v":0},null,{"$f":"'1. HVAC Design Review'!$S$127","v":"4.3.12"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$B$127&'1. HVAC Design Review'!$B$129&\"Zone 2\"&\"_Field\"","v":"Mechanical Ventilation System Design Airflow RateHVAC design's time-averaged vent. rate used in loads, for each heating / cooling zone Zone 2_Field"},{"$f":"'1. HVAC Design Review'!O129","v":0},null,{"$f":"'1. HVAC Design Review'!$S$127","v":"4.3.12"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$B$127&'1. HVAC Design Review'!$B$128&\"Zone 3\"&\"_Field\"","v":"Mechanical Ventilation System Design Airflow RateHVAC design's time-averaged vent. rate, for each ventilation zoneZone 3_Field"},{"$f":"'1. HVAC Design Review'!P128","v":0},null,{"$f":"'1. HVAC Design Review'!$S$127","v":"4.3.12"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$B$127&'1. HVAC Design Review'!$B$129&\"Zone 3\"&\"_Field\"","v":"Mechanical Ventilation System Design Airflow RateHVAC design's time-averaged vent. rate used in loads, for each heating / cooling zone Zone 3_Field"},{"$f":"'1. HVAC Design Review'!P129","v":0},null,{"$f":"'1. HVAC Design Review'!$S$127","v":"4.3.12"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$B$131&\"_Field\"","v":"Is the sum of the time-averaged design vent. rate across all vent. zones equal to the sum of the time-averaged design vent. rate used in the loads across all heated / cooled zones?_Field"},{"$f":"'1. HVAC Design Review'!P131","v":"Yes"},null,{"$f":"'1. HVAC Design Review'!$S$127","v":"4.3.12"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$B$135&\"_Field\"","v":"Does each HVAC system in the Home serve the zone(s) specified in the HVAC design?_Field"},{"$f":"'1. HVAC Design Review'!P135","v":"Yes"},null,{"$f":"'1. HVAC Design Review'!$S$135","v":"4.3.13"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$B$136&\"_Field\"","v":"Does each HVAC System in Home match the equipment type specified in the HVAC design?_Field"},{"$f":"'1. HVAC Design Review'!P136","v":"Yes"},null,{"$f":"'1. HVAC Design Review'!$S$136","v":"4.3.14"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$B$138&'1. HVAC Design Review'!$B$139&\"Zone 1\"&\"_Field\"","v":"Design AirflowsIn HVAC design, sum of design airflows across all roomsZone 1_Field"},{"$f":"'1. HVAC Design Review'!N139","v":0},{"$f":"'1. HVAC Design Review'!$R$139","v":"CFM"},{"$f":"'1. HVAC Design Review'!$S$139","v":"4.3.15"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$B$138&'1. HVAC Design Review'!$B$140&\"Zone 1\"&\"_Field\"","v":"Design AirflowsIn HVAC design, design airflow of system in cooling mode (if applicable)Zone 1_Field"},{"$f":"'1. HVAC Design Review'!N140","v":0},{"$f":"'1. HVAC Design Review'!$R$139","v":"CFM"},{"$f":"'1. HVAC Design Review'!$S$139","v":"4.3.15"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$B$138&'1. HVAC Design Review'!$B$141&\"Zone 1\"&\"_Field\"","v":"Design AirflowsIn HVAC design, design airflow of system in heating mode (if applicable)Zone 1_Field"},{"$f":"'1. HVAC Design Review'!N141","v":0},{"$f":"'1. HVAC Design Review'!$R$139","v":"CFM"},{"$f":"'1. HVAC Design Review'!$S$139","v":"4.3.15"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$B$138&'1. HVAC Design Review'!$B$142&\"Zone 1\"&\"_Field\"","v":"Design AirflowsDoes the sum of design airflows across all rooms equal airflow of mode with higher airflow?Zone 1_Field"},{"$f":"'1. HVAC Design Review'!N142","v":"Yes"},null,{"$f":"'1. HVAC Design Review'!$S$139","v":"4.3.15"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$B$138&'1. HVAC Design Review'!$B$139&\"Zone 2\"&\"_Field\"","v":"Design AirflowsIn HVAC design, sum of design airflows across all roomsZone 2_Field"},{"$f":"'1. HVAC Design Review'!O139","v":0},{"$f":"'1. HVAC Design Review'!$R$139","v":"CFM"},{"$f":"'1. HVAC Design Review'!$S$139","v":"4.3.15"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$B$138&'1. HVAC Design Review'!$B$140&\"Zone 2\"&\"_Field\"","v":"Design AirflowsIn HVAC design, design airflow of system in cooling mode (if applicable)Zone 2_Field"},{"$f":"'1. HVAC Design Review'!O140","v":0},{"$f":"'1. HVAC Design Review'!$R$139","v":"CFM"},{"$f":"'1. HVAC Design Review'!$S$139","v":"4.3.15"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$B$138&'1. HVAC Design Review'!$B$141&\"Zone 2\"&\"_Field\"","v":"Design AirflowsIn HVAC design, design airflow of system in heating mode (if applicable)Zone 2_Field"},{"$f":"'1. HVAC Design Review'!O141","v":0},{"$f":"'1. HVAC Design Review'!$R$139","v":"CFM"},{"$f":"'1. HVAC Design Review'!$S$139","v":"4.3.15"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$B$138&'1. HVAC Design Review'!$B$142&\"Zone 2\"&\"_Field\"","v":"Design AirflowsDoes the sum of design airflows across all rooms equal airflow of mode with higher airflow?Zone 2_Field"},{"$f":"'1. HVAC Design Review'!O142","v":"Yes"},null,{"$f":"'1. HVAC Design Review'!$S$139","v":"4.3.15"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$B$138&'1. HVAC Design Review'!$B$139&\"Zone 3\"&\"_Field\"","v":"Design AirflowsIn HVAC design, sum of design airflows across all roomsZone 3_Field"},{"$f":"'1. HVAC Design Review'!P139","v":0},{"$f":"'1. HVAC Design Review'!$R$139","v":"CFM"},{"$f":"'1. HVAC Design Review'!$S$139","v":"4.3.15"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$B$138&'1. HVAC Design Review'!$B$140&\"Zone 3\"&\"_Field\"","v":"Design AirflowsIn HVAC design, design airflow of system in cooling mode (if applicable)Zone 3_Field"},{"$f":"'1. HVAC Design Review'!P140","v":0},{"$f":"'1. HVAC Design Review'!$R$139","v":"CFM"},{"$f":"'1. HVAC Design Review'!$S$139","v":"4.3.15"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$B$138&'1. HVAC Design Review'!$B$141&\"Zone 3\"&\"_Field\"","v":"Design AirflowsIn HVAC design, design airflow of system in heating mode (if applicable)Zone 3_Field"},{"$f":"'1. HVAC Design Review'!P141","v":0},{"$f":"'1. HVAC Design Review'!$R$139","v":"CFM"},{"$f":"'1. HVAC Design Review'!$S$139","v":"4.3.15"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$B$138&'1. HVAC Design Review'!$B$142&\"Zone 3\"&\"_Field\"","v":"Design AirflowsDoes the sum of design airflows across all rooms equal airflow of mode with higher airflow?Zone 3_Field"},{"$f":"'1. HVAC Design Review'!P142","v":"Yes"},null,{"$f":"'1. HVAC Design Review'!$S$139","v":"4.3.15"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$B$146&'1. HVAC Design Review'!$C$147&\"_Plan\"","v":"Have all required design review criteria been verified for:A dwelling or townhouse or unit within (e.g., duplex)_Plan"},{"$f":"'1. HVAC Design Review'!K147","v":"Yes"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$B$146&'1. HVAC Design Review'!$C$148&\"_Plan\"","v":"Have all required design review criteria been verified for:A unit in a multifamily building w/ heat gain ≤18 kBTUh & heat loss ≤35 kBTUh_Plan"},{"$f":"'1. HVAC Design Review'!K148","v":"N/A"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$B$146&'1. HVAC Design Review'!$C$149&\"_Plan\"","v":"Have all required design review criteria been verified for:A unit in a multifamily building w/ heat gain >18 kBTUh or heat loss >35k BTUh_Plan"},{"$f":"'1. HVAC Design Review'!K149","v":"N/A"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$B$146&'1. HVAC Design Review'!$C$150&\"_Plan\"","v":"Have all required design review criteria been verified for:All Dwellings, Townhouses, Dwelling Units, and Sleeping Units_Plan"},{"$f":"'1. HVAC Design Review'!K150","v":"Yes"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$B$146&'1. HVAC Design Review'!$C$151&\"_Plan\"","v":"Have all required design review criteria been verified for:_Plan"},{"$f":"'1. HVAC Design Review'!K151","v":"Yes"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$B$146&'1. HVAC Design Review'!$C$147&\"_Field\"","v":"Have all required design review criteria been verified for:A dwelling or townhouse or unit within (e.g., duplex)_Field"},{"$f":"'1. HVAC Design Review'!P147","v":"No"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$B$146&'1. HVAC Design Review'!$C$148&\"_Field\"","v":"Have all required design review criteria been verified for:A unit in a multifamily building w/ heat gain ≤18 kBTUh & heat loss ≤35 kBTUh_Field"},{"$f":"'1. HVAC Design Review'!P148","v":"N/A"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$B$146&'1. HVAC Design Review'!$C$149&\"_Field\"","v":"Have all required design review criteria been verified for:A unit in a multifamily building w/ heat gain >18 kBTUh or heat loss >35k BTUh_Field"},{"$f":"'1. HVAC Design Review'!P149","v":"N/A"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$B$146&'1. HVAC Design Review'!$C$150&\"_Field\"","v":"Have all required design review criteria been verified for:All Dwellings, Townhouses, Dwelling Units, and Sleeping Units_Field"},{"$f":"'1. HVAC Design Review'!P150","v":"No"}]
[null,"1. HVAC Design Review",{"$f":"'1. HVAC Design Review'!$B$146&'1. HVAC Design Review'!$C$151&\"_Field\"","v":"Have all required design review criteria been verified for:_Field"},{"$f":"'1. HVAC Design Review'!P151","v":"No"}]
[null,{"$f":"MID(CELL(\"filename\",INDIRECT(RIGHT(_xlfn.FORMULATEXT(D320),LEN(_xlfn.FORMULATEXT(D320))-1),TRUE)),FIND(\"]\",CELL(\"filename\",INDIRECT(RIGHT(_xlfn.FORMULATEXT(D320),LEN(_xlfn.FORMULATEXT(D320))-1),TRUE)))+1,255)","v":"2. Total Duct Leakage"},{"$f":"'2. Total Duct Leakage'!B4","v":"All required design documentation collected, reviewed, and verified to be in accordance with Section 4.3, or an IVR obtained."},{"$f":"'2. Total Duct Leakage'!H4","v":"No"},"-",{"$f":"'2. Total Duct Leakage'!J4","v":5.2}]
[null,"2. Total Duct Leakage",{"$f":"'2. Total Duct Leakage'!B8","v":"Does the system have a total amount of supply ductwork or distribution building cavities that is > 10 total linear feet?"},{"$f":"'2. Total Duct Leakage'!H8","v":"Yes"},"-",{"$f":"'2. Total Duct Leakage'!J8","v":5.3}]
[null,"2. Total Duct Leakage",{"$f":"'2. Total Duct Leakage'!B10","v":"Is the system entirely in Conditioned Space Volume?"},{"$f":"'2. Total Duct Leakage'!H10","v":"No"},"-",{"$f":"'2. Total Duct Leakage'!J10","v":5.3}]
[null,"2. Total Duct Leakage",{"$f":"'2. Total Duct Leakage'!B11","v":"Is testing required?"},{"$f":"'2. Total Duct Leakage'!H11","v":"Yes"},"-",{"$f":"'2. Total Duct Leakage'!J11","v":5.3}]
[null,"2. Total Duct Leakage",{"$f":"'2. Total Duct Leakage'!B12","v":"Was total duct leakage test exemption taken?"},{"$f":"'2. Total Duct Leakage'!H12","v":"No"},"-",{"$f":"'2. Total Duct Leakage'!J12","v":5.3}]
[null,{"$f":"MID(CELL(\"filename\",INDIRECT(RIGHT(_xlfn.FORMULATEXT(D325),LEN(_xlfn.FORMULATEXT(D325))-1),TRUE)),FIND(\"]\",CELL(\"filename\",INDIRECT(RIGHT(_xlfn.FORMULATEXT(D325),LEN(_xlfn.FORMULATEXT(D325))-1),TRUE)))+1,255)","v":"2. Total Duct Leakage"},{"$f":"'2. Total Duct Leakage'!B13","v":"Did testing occur at rough-in or final?"},{"$f":"'2. Total Duct Leakage'!H13","v":"Rough-in"},"-",{"$f":"'2. Total Duct Leakage'!J13","v":5.3}]
[null,"2. Total Duct Leakage",{"$f":"'2. Total Duct Leakage'!B14","v":"Enter the number of returns in the system"},{"$f":"'2. Total Duct Leakage'!H14","v":0},"-",{"$f":"'2. Total Duct Leakage'!J14","v":5.3}]
[null,"2. Total Duct Leakage",{"$f":"'2. Total Duct Leakage'!B15","v":"Enter the Conditioned Floor Area served by the system"},{"$f":"'2. Total Duct Leakage'!H15","v":0},{"$f":"'2. Total Duct Leakage'!I15","v":"Sq. Ft. "},"-"]
[null,"2. Total Duct Leakage",{"$f":"'2. Total Duct Leakage'!B16","v":"Enter the total duct leakage of the system"},{"$f":"'2. Total Duct Leakage'!H16","v":0},{"$f":"'2. Total Duct Leakage'!I16","v":"CFM25"},{"$f":"'2. Total Duct Leakage'!J16","v":5.3}]
[null,"2. Total Duct Leakage",{"$f":"'2. Total Duct Leakage'!B17","v":"Total duct leakage per 100 sq. ft. of CFA served by system"},{"$f":"'2. Total Duct Leakage'!H17","v":{"$error":"#DIV/0!"}},{"$f":"'2. Total Duct Leakage'!I17","v":"CFM25/100 Sq. Ft."},"-"]
[null,"2. Total Duct Leakage",{"$f":"'2. Total Duct Leakage'!B19","v":"Total Duct Leakage Grade Designation:"},{"$f":"'2. Total Duct Leakage'!H19","v":"Grade III"},"-","-"]
[null,"3. Blower Fan Airflow",{"$f":"'3. Blower Fan Airflow'!B4","v":"Did total duct leakage achieve Grade I or II designation?"},{"$f":"'3. Blower Fan Airflow'!H4","v":"No"},"-",{"$f":"'3. Blower Fan Airflow'!J4","v":"6.2.1"}]
[null,{"$f":"MID(CELL(\"filename\",INDIRECT(RIGHT(_xlfn.FORMULATEXT(D332),LEN(_xlfn.FORMULATEXT(D332))-1),TRUE)),FIND(\"]\",CELL(\"filename\",INDIRECT(RIGHT(_xlfn.FORMULATEXT(D332),LEN(_xlfn.FORMULATEXT(D332))-1),TRUE)))+1,255)","v":"3. Blower Fan Airflow"},{"$f":"'3. Blower Fan Airflow'!B5","v":"HVAC equipment is operational & matches specification?"},{"$f":"'3. Blower Fan Airflow'!H5","v":"Yes"},"-",{"$f":"'3. Blower Fan Airflow'!J5","v":"6.2.2.1"}]
[null,"3. Blower Fan Airflow",{"$f":"'3. Blower Fan Airflow'!B6","v":"If specified, mech. vent. system is operational & matches specification?"},{"$f":"'3. Blower Fan Airflow'!H6","v":"Yes"},"-",{"$f":"'3. Blower Fan Airflow'!J6","v":"6.2.2.2"}]
[null,"3. Blower Fan Airflow",{"$f":"'3. Blower Fan Airflow'!B7","v":"If specified, distribution system installed, including registers & grilles?"},{"$f":"'3. Blower Fan Airflow'!H7","v":"Yes"},"-",{"$f":"'3. Blower Fan Airflow'!J7","v":"6.2.2.3"}]
[null,"3. Blower Fan Airflow",{"$f":"'3. Blower Fan Airflow'!B8","v":"If specified, filter installed & matches specified performance rating?"},{"$f":"'3. Blower Fan Airflow'!H8","v":"Yes"},"-",{"$f":"'3. Blower Fan Airflow'!J8","v":"6.2.2.4"}]
[null,"3. Blower Fan Airflow",{"$f":"'3. Blower Fan Airflow'!B9","v":"Have prerequisites been met?"},{"$f":"'3. Blower Fan Airflow'!H9","v":"No"},"-","-"]
[null,"3. Blower Fan Airflow",{"$f":"'3. Blower Fan Airflow'!B12","v":"Enter design-specified blower fan airflow (Qdesign)"},{"$f":"'3. Blower Fan Airflow'!H12","v":0},{"$f":"'3. Blower Fan Airflow'!I12","v":"CFM"},{"$f":"'3. Blower Fan Airflow'!J12","v":"4.2.5.5.1"}]
[null,"3. Blower Fan Airflow",{"$f":"'3. Blower Fan Airflow'!B15","v":"Does the system have a total amount of supply ductwork or distribution building cavities that is > 10 total linear feet?"},{"$f":"'3. Blower Fan Airflow'!H15","v":"Yes"},"-",{"$f":"'3. Blower Fan Airflow'!J15","v":"6.3.1.1"}]
[null,"3. Blower Fan Airflow",{"$f":"'3. Blower Fan Airflow'!B17","v":"Is the system entirely in Conditioned Space Volume?"},{"$f":"'3. Blower Fan Airflow'!H17","v":"No"},"-",{"$f":"'3. Blower Fan Airflow'!J17","v":"6.3.1.1"}]
[null,"3. Blower Fan Airflow",{"$f":"'3. Blower Fan Airflow'!B18","v":"Is testing required?"},{"$f":"'3. Blower Fan Airflow'!H18","v":"Yes"},"-",{"$f":"'3. Blower Fan Airflow'!J18","v":"6.3.1.1"}]
[null,"3. Blower Fan Airflow",{"$f":"'3. Blower Fan Airflow'!B19","v":"Was blower fan airflow test exemption taken?"},{"$f":"'3. Blower Fan Airflow'!H18","v":"Yes"},"-",{"$f":"'3. Blower Fan Airflow'!J19","v":"6.3.1.1"}]
[null,{"$f":"MID(CELL(\"filename\",INDIRECT(RIGHT(_xlfn.FORMULATEXT(D342),LEN(_xlfn.FORMULATEXT(D342))-1),TRUE)),FIND(\"]\",CELL(\"filename\",INDIRECT(RIGHT(_xlfn.FORMULATEXT(D342),LEN(_xlfn.FORMULATEXT(D342))-1),TRUE)))+1,255)","v":"3. Blower Fan Airflow"},{"$f":"'3. Blower Fan Airflow'!B20","v":"What Grade designation did total duct leakage achieve (I or II)?"},{"$f":"'3. Blower Fan Airflow'!H20","v":"Grade III"},"-","-"]
[null,"3. Blower Fan Airflow",{"$f":"'3. Blower Fan Airflow'!B21","v":"If testing is required and pre-reqs met, select one airflow test method."},{"$f":"'3. Blower Fan Airflow'!H21","v":"Flow Hood"},"-",{"$f":"'3. Blower Fan Airflow'!J21","v":"6.3.1.3"}]
[null,"3. Blower Fan Airflow",{"$f":"'3. Blower Fan Airflow'!B24","v":"Dwelling and forced-air HVAC system set up per Section 6.4?"},{"$f":"'3. Blower Fan Airflow'!H24","v":"Yes"},"-",{"$f":"'3. Blower Fan Airflow'!J24","v":6.4}]
[null,"3. Blower Fan Airflow",{"$f":"'3. Blower Fan Airflow'!B25","v":"Enter mode that forced-air HVAC system was tested in"},{"$f":"'3. Blower Fan Airflow'!H25","v":"Cooling"},"-",{"$f":"'3. Blower Fan Airflow'!J25","v":"6.4.5"}]
[null,"3. Blower Fan Airflow",{"$f":"\"Pressure Matching - \"&'3. Blower Fan Airflow'!B29","v":"Pressure Matching - Enter Psop - pressure of the supply-side under normal operation"},{"$f":"'3. Blower Fan Airflow'!H29","v":0},{"$f":"'3. Blower Fan Airflow'!I29","v":"Pa"},{"$f":"'3. Blower Fan Airflow'!J29","v":"6.5.2.4"}]
[null,"3. Blower Fan Airflow",{"$f":"\"Pressure Matching - \"&'3. Blower Fan Airflow'!B30","v":"Pressure Matching - Was there turbulence (fluctuations >0.05 IWC) when measuring Psop?"},{"$f":"'3. Blower Fan Airflow'!H30","v":"No"},"-",{"$f":"'3. Blower Fan Airflow'!J30","v":"6.5.2.4"}]
[null,"3. Blower Fan Airflow",{"$f":"\"Pressure Matching - \"&'3. Blower Fan Airflow'!B31","v":"Pressure Matching - Enter Fan Flowmeter location (at blower compartment or at return grille)"},{"$f":"'3. Blower Fan Airflow'!H31","v":"Return Grille"},"-",{"$f":"'3. Blower Fan Airflow'!J31","v":"6.5.2.5"}]
[null,"3. Blower Fan Airflow",{"$f":"\"Pressure Matching - \"&'3. Blower Fan Airflow'!B32","v":"Pressure Matching - Enter Ptest - pressure of the supply-side during test"},{"$f":"'3. Blower Fan Airflow'!H32","v":0},{"$f":"'3. Blower Fan Airflow'!I32","v":"Pa"},{"$f":"'3. Blower Fan Airflow'!J32","v":"6.5.2.7"}]
[null,"3. Blower Fan Airflow",{"$f":"\"Pressure Matching - \"&'3. Blower Fan Airflow'!B33","v":"Pressure Matching - Enter Qtest - the airflow through Fan Flowmeter"},{"$f":"'3. Blower Fan Airflow'!H33","v":0},{"$f":"'3. Blower Fan Airflow'!I33","v":"CFM"},{"$f":"'3. Blower Fan Airflow'!J33","v":"6.5.2.7"}]
[null,"3. Blower Fan Airflow",{"$f":"\"Pressure Matching - \"&'3. Blower Fan Airflow'!B34","v":"Pressure Matching - Blower fan airflow at operating conditions (Qop)"},{"$f":"'3. Blower Fan Airflow'!H34","v":{"$error":"#DIV/0!"}},{"$f":"'3. Blower Fan Airflow'!I34","v":"CFM"},{"$f":"'3. Blower Fan Airflow'!J34","v":"6.5.2.8"}]
[null,"3. Blower Fan Airflow",{"$f":"\"Flow Grid - \"&'3. Blower Fan Airflow'!B37","v":"Flow Grid - Enter Psop - pressure of the supply-side under normal operation"},{"$f":"'3. Blower Fan Airflow'!H37","v":0},{"$f":"'3. Blower Fan Airflow'!I37","v":"Pa"},{"$f":"'3. Blower Fan Airflow'!J37","v":"6.6.2.4"}]
[null,"3. Blower Fan Airflow",{"$f":"\"Flow Grid - \"&'3. Blower Fan Airflow'!B38","v":"Flow Grid - Was there turbulence (fluctuations >0.05 IWC) when measuring Psop?"},{"$f":"'3. Blower Fan Airflow'!H38","v":"No"},"-",{"$f":"'3. Blower Fan Airflow'!J38","v":"6.6.2.4"}]
[null,"3. Blower Fan Airflow",{"$f":"\"Flow Grid - \"&'3. Blower Fan Airflow'!B39","v":"Flow Grid - Enter Ptest - pressure of the supply-side during test"},{"$f":"'3. Blower Fan Airflow'!H39","v":0},{"$f":"'3. Blower Fan Airflow'!I39","v":"Pa"},{"$f":"'3. Blower Fan Airflow'!J39","v":"6.6.2.6"}]
[null,"3. Blower Fan Airflow",{"$f":"\"Flow Grid - \"&'3. Blower Fan Airflow'!B40","v":"Flow Grid - Enter Qtest - the airflow through Flow Grid"},{"$f":"'3. Blower Fan Airflow'!H40","v":0},{"$f":"'3. Blower Fan Airflow'!I40","v":"CFM"},{"$f":"'3. Blower Fan Airflow'!J40","v":"6.6.2.7"}]
[null,"3. Blower Fan Airflow",{"$f":"\"Flow Grid - \"&'3. Blower Fan Airflow'!B41","v":"Flow Grid - Blower fan airflow at operating conditions (Qop)"},{"$f":"'3. Blower Fan Airflow'!H41","v":{"$error":"#DIV/0!"}},{"$f":"'3. Blower Fan Airflow'!I41","v":"CFM"},{"$f":"'3. Blower Fan Airflow'!J41","v":"6.6.2.8"}]
[null,"3. Blower Fan Airflow",{"$f":"\"Flow Hood - \"&'3. Blower Fan Airflow'!G44","v":"Flow Hood - Return #1"},{"$f":"'3. Blower Fan Airflow'!H44","v":0},{"$f":"'3. Blower Fan Airflow'!I44","v":"CFM"},{"$f":"'3. Blower Fan Airflow'!J44","v":"6.7.2.1.2"}]
[null,"3. Blower Fan Airflow",{"$f":"\"Flow Hood - \"&'3. Blower Fan Airflow'!G45","v":"Flow Hood - Return #2"},{"$f":"'3. Blower Fan Airflow'!H45","v":0},{"$f":"'3. Blower Fan Airflow'!I45","v":"CFM"},"-"]
[null,"3. Blower Fan Airflow",{"$f":"\"Flow Hood - \"&'3. Blower Fan Airflow'!G46","v":"Flow Hood - Return #3"},{"$f":"'3. Blower Fan Airflow'!H46","v":0},{"$f":"'3. Blower Fan Airflow'!I46","v":"CFM"},"-"]
[null,"3. Blower Fan Airflow",{"$f":"\"Flow Hood - \"&'3. Blower Fan Airflow'!G47","v":"Flow Hood - Return #4"},{"$f":"'3. Blower Fan Airflow'!H47","v":0},{"$f":"'3. Blower Fan Airflow'!I47","v":"CFM"},"-"]
[null,"3. Blower Fan Airflow",{"$f":"\"Flow Hood - \"&'3. Blower Fan Airflow'!B48","v":"Flow Hood - Blower fan airflow at operating conditions (Qop)"},{"$f":"'3. Blower Fan Airflow'!H48","v":0},{"$f":"'3. Blower Fan Airflow'!I48","v":"CFM"},{"$f":"'3. Blower Fan Airflow'!J48","v":"6.7.2.2"}]
[null,"3. Blower Fan Airflow",{"$f":"\"OEM Table - \"&'3. Blower Fan Airflow'!B51","v":"OEM Table - Blower fan motor type. \nNote: ECM/Other fan types can only be used at elevations >2,500 Ft if OEM provides instructions to account for elevation."},{"$f":"'3. Blower Fan Airflow'!H51","v":"PSC"},"-",{"$f":"'3. Blower Fan Airflow'!J51","v":"6.8.3.1"}]
[null,"3. Blower Fan Airflow",{"$f":"\"OEM Table - \"&'3. Blower Fan Airflow'!B54","v":"OEM Table - Enter observed fan-speed setting"},{"$f":"'3. Blower Fan Airflow'!H54","v":0},"-",{"$f":"'3. Blower Fan Airflow'!J54","v":"6.8.3.2"}]
[null,"3. Blower Fan Airflow",{"$f":"\"OEM Table - \"&'3. Blower Fan Airflow'!B55","v":"OEM Table - Enter Psop - pressure of the supply-side under normal operation"},{"$f":"'3. Blower Fan Airflow'!H55","v":0},{"$f":"'3. Blower Fan Airflow'!I55","v":"Pa"},{"$f":"'3. Blower Fan Airflow'!J55","v":"6.8.3.7"}]
[null,"3. Blower Fan Airflow",{"$f":"\"OEM Table - \"&'3. Blower Fan Airflow'!B56","v":"OEM Table - Was there turbulence (fluctuations >0.05 IWC) when measuring Psop?"},{"$f":"'3. Blower Fan Airflow'!H56","v":"Yes"},"-",{"$f":"'3. Blower Fan Airflow'!J56","v":"6.8.3.7"}]
[null,"3. Blower Fan Airflow",{"$f":"\"OEM Table - \"&'3. Blower Fan Airflow'!B57","v":"OEM Table - Enter Prop - pressure of the return-side under normal operation"},{"$f":"'3. Blower Fan Airflow'!H57","v":0},{"$f":"'3. Blower Fan Airflow'!I57","v":"Pa"},{"$f":"'3. Blower Fan Airflow'!J57","v":"6.8.3.9"}]
[null,"3. Blower Fan Airflow",{"$f":"\"OEM Table - \"&'3. Blower Fan Airflow'!B58","v":"OEM Table - Was there turbulence (fluctuations >0.05 IWC) when measuring Prop?"},{"$f":"'3. Blower Fan Airflow'!H58","v":"Yes"},"-",{"$f":"'3. Blower Fan Airflow'!J58","v":"6.8.3.9"}]
[null,"3. Blower Fan Airflow",{"$f":"\"OEM Table - \"&'3. Blower Fan Airflow'!B59","v":"OEM Table - Elevation above sea level"},{"$f":"'3. Blower Fan Airflow'!H59","v":0},{"$f":"'3. Blower Fan Airflow'!I59","v":"Ft"},{"$f":"'3. Blower Fan Airflow'!J59","v":"6.8.3.10"}]
[null,"3. Blower Fan Airflow",{"$f":"\"OEM Table - \"&'3. Blower Fan Airflow'!B60","v":"OEM Table - Elevation Adjustment Factor (Padj)"},{"$f":"'3. Blower Fan Airflow'!H60","v":1},"-",{"$f":"'3. Blower Fan Airflow'!J60","v":"6.8.3.10"}]
[null,"3. Blower Fan Airflow",{"$f":"\"OEM Table - \"&'3. Blower Fan Airflow'!B61","v":"OEM Table - Enter filter pressure drop accounted for in OEM Static Pressure Table (Pfilter). Enter 0 if Table does not account for filter, or is unclear about presence of filter. Enter 0.1 IWC if Table accounts for filter, but pressure drop is not specified."},{"$f":"'3. Blower Fan Airflow'!H61","v":0},{"$f":"'3. Blower Fan Airflow'!I61","v":"IWC"},{"$f":"'3. Blower Fan Airflow'!J61","v":"6.8.3.11"}]
[null,"3. Blower Fan Airflow",{"$f":"\"OEM Table - \"&'3. Blower Fan Airflow'!B65","v":"OEM Table - Pressure difference for OEM Static Pressure Table (Ptop)"},{"$f":"'3. Blower Fan Airflow'!H65","v":0},{"$f":"'3. Blower Fan Airflow'!I65","v":"IWC"},{"$f":"'3. Blower Fan Airflow'!J65","v":"6.8.3.11"}]
[null,"3. Blower Fan Airflow",{"$f":"\"OEM Table - \"&'3. Blower Fan Airflow'!B66","v":"OEM Table - Enter blower fan airflow at operating conditions (Qop)"},{"$f":"'3. Blower Fan Airflow'!H66","v":0},{"$f":"'3. Blower Fan Airflow'!I66","v":"CFM"},{"$f":"'3. Blower Fan Airflow'!J66","v":"6.8.3.12"}]
[null,"3. Blower Fan Airflow",{"$f":"'3. Blower Fan Airflow'!B72","v":"Final Blower fan airflow at operating conditions (Qop)"},{"$f":"'3. Blower Fan Airflow'!H72","v":"Prereq Not Met"},{"$f":"'3. Blower Fan Airflow'!I72","v":"CFM"},"-"]
[null,{"$f":"MID(CELL(\"filename\",INDIRECT(RIGHT(_xlfn.FORMULATEXT(D374),LEN(_xlfn.FORMULATEXT(D374))-1),TRUE)),FIND(\"]\",CELL(\"filename\",INDIRECT(RIGHT(_xlfn.FORMULATEXT(D374),LEN(_xlfn.FORMULATEXT(D374))-1),TRUE)))+1,255)","v":"3. Blower Fan Airflow"},{"$f":"'3. Blower Fan Airflow'!B73","v":"FAF (i.e., Fault)"},{"$f":"'3. Blower Fan Airflow'!H73","v":"Prereq Not Met"},"-",{"$f":"'3. Blower Fan Airflow'!J73","v":"6.9.1"}]
[null,"3. Blower Fan Airflow",{"$f":"'3. Blower Fan Airflow'!B74","v":"Blower fan volumetric airflow grade"},{"$f":"'3. Blower Fan Airflow'!H74","v":"Grade III"},"-",{"$f":"'3. Blower Fan Airflow'!J74","v":"6.9.2"}]
[null,"4. Blower Fan Watt Draw",{"$f":"'4. Blower Fan Watt Draw'!B4","v":"Did blower fan airflow achieve Grade I or II designation?"},{"$f":"'4. Blower Fan Watt Draw'!H4","v":"No"},"-",{"$f":"'4. Blower Fan Watt Draw'!J4","v":7.2}]
[null,"4. Blower Fan Watt Draw",{"$f":"'4. Blower Fan Watt Draw'!B7","v":"Dwelling and forced-air HVAC system set up per Section 7.3?"},{"$f":"'4. Blower Fan Watt Draw'!H7","v":"Yes"},"-",{"$f":"'4. Blower Fan Watt Draw'!J7","v":7.3}]
[null,"4. Blower Fan Watt Draw",{"$f":"'4. Blower Fan Watt Draw'!B8","v":"Enter mode that forced-air HVAC system was tested in"},{"$f":"'4. Blower Fan Watt Draw'!H8","v":"Cooling"},"-",{"$f":"'4. Blower Fan Watt Draw'!J8","v":"7.3.2"}]
[null,"4. Blower Fan Watt Draw",{"$f":"'4. Blower Fan Watt Draw'!B11","v":"Select one test method for measuring blower fan watt draw"},{"$f":"'4. Blower Fan Watt Draw'!H11","v":"Portable Plug-In Watt Meter"},"-","-"]
[null,"4. Blower Fan Watt Draw",{"$f":"\"Plug-In Watt Meter - \"&'4. Blower Fan Watt Draw'!B15","v":"Plug-In Watt Meter - Enter Wfan, watt draw of blower fan"},{"$f":"'4. Blower Fan Watt Draw'!H15","v":0},{"$f":"'4. Blower Fan Watt Draw'!I15","v":"Watts"},{"$f":"'4. Blower Fan Watt Draw'!J15","v":"7.4.2.3"}]
[null,"4. Blower Fan Watt Draw",{"$f":"\"Plug-In Watt Meter - \"&'4. Blower Fan Watt Draw'!B18","v":"Plug-In Watt Meter - Enter Wfan, watt draw of blower fan"},{"$f":"'4. Blower Fan Watt Draw'!H18","v":0},{"$f":"'4. Blower Fan Watt Draw'!I18","v":"Watts"},{"$f":"'4. Blower Fan Watt Draw'!J18","v":"7.5.2.4.1.3 or 7.5.2.4.2.3"}]
[null,"4. Blower Fan Watt Draw",{"$f":"\"Utility Revenue Meter - \"&'4. Blower Fan Watt Draw'!B21","v":"Utility Revenue Meter - Enter Kh factor on revenue meter"},{"$f":"'4. Blower Fan Watt Draw'!H21","v":0},"-",{"$f":"'4. Blower Fan Watt Draw'!J21","v":"7.6.2.3"}]
[null,"4. Blower Fan Watt Draw",{"$f":"\"Utility Revenue Meter - \"&'4. Blower Fan Watt Draw'!B22","v":"Utility Revenue Meter - Enter Nrev - number of revolutions during period"},{"$f":"'4. Blower Fan Watt Draw'!H22","v":0},{"$f":"'4. Blower Fan Watt Draw'!I22","v":"Revs."},{"$f":"'4. Blower Fan Watt Draw'!J22","v":"7.6.2.4"}]
[null,"4. Blower Fan Watt Draw",{"$f":"\"Utility Revenue Meter - \"&'4. Blower Fan Watt Draw'!B23","v":"Utility Revenue Meter - Enter Trev - duration of period (must be ≥ 90 seconds)"},{"$f":"'4. Blower Fan Watt Draw'!H23","v":0},{"$f":"'4. Blower Fan Watt Draw'!I23","v":"Seconds"},{"$f":"'4. Blower Fan Watt Draw'!J23","v":"7.6.2.4"}]
[null,"4. Blower Fan Watt Draw",{"$f":"\"Utility Revenue Meter - \"&'4. Blower Fan Watt Draw'!B24","v":"Utility Revenue Meter - Blower fan watt draw at operating conditions (Wfan)"},{"$f":"'4. Blower Fan Watt Draw'!H24","v":{"$error":"#DIV/0!"}},{"$f":"'4. Blower Fan Watt Draw'!I24","v":"Watts"},{"$f":"'4. Blower Fan Watt Draw'!J24","v":"7.6.2.5"}]
[null,"4. Blower Fan Watt Draw",{"$f":"\"Digital Utility Revenue Meter - \"&'4. Blower Fan Watt Draw'!B27","v":"Digital Utility Revenue Meter - Enter Wfan, watt draw of blower fan"},{"$f":"'4. Blower Fan Watt Draw'!H27","v":0},{"$f":"'4. Blower Fan Watt Draw'!I27","v":"Watts"},{"$f":"'4. Blower Fan Watt Draw'!J27","v":"7.7.2.3"}]
[null,"4. Blower Fan Watt Draw",{"$f":"'4. Blower Fan Watt Draw'!B30","v":"Blower fan airflow"},{"$f":"'4. Blower Fan Watt Draw'!H30","v":0},{"$f":"'4. Blower Fan Watt Draw'!I30","v":"CFM"},{"$f":"'4. Blower Fan Watt Draw'!J30","v":"7.8.1"}]
[null,"4. Blower Fan Watt Draw",{"$f":"'4. Blower Fan Watt Draw'!B31","v":"Final Blower fan watt draw at operating conditions (Wfan)"},{"$f":"'4. Blower Fan Watt Draw'!H31","v":"Prereq Not Met"},{"$f":"'4. Blower Fan Watt Draw'!I31","v":"Watts"},"-"]
[null,"4. Blower Fan Watt Draw",{"$f":"'4. Blower Fan Watt Draw'!B32","v":"Blower fan efficiency"},{"$f":"'4. Blower Fan Watt Draw'!H32","v":"Prereq Not Met"},{"$f":"'4. Blower Fan Watt Draw'!I32","v":"W / CFM"},{"$f":"'4. Blower Fan Watt Draw'!J32","v":"7.8.1"}]
[null,"4. Blower Fan Watt Draw",{"$f":"'4. Blower Fan Watt Draw'!B33","v":"Blower fan watt draw grade"},{"$f":"'4. Blower Fan Watt Draw'!H33","v":"Grade III"},"-",{"$f":"'4. Blower Fan Watt Draw'!J33","v":"7.8.2"}]
[null,"5. Refrigerant Charge",{"$f":"'5. Refrigerant Charge'!B4","v":"Did blower fan airflow achieve Grade I or II designation?"},{"$f":"'5. Refrigerant Charge'!H4","v":"No"},"-",{"$f":"'5. Refrigerant Charge'!J4","v":"8.2.1"}]
[null,"5. Refrigerant Charge",{"$f":"'5. Refrigerant Charge'!B7","v":"For Non-Invasive Method, enter measured outdoor air dry-bulb temperature"},{"$f":"'5. Refrigerant Charge'!H7","v":0},{"$f":"'5. Refrigerant Charge'!I7","v":"F"},{"$f":"'5. Refrigerant Charge'!J7","v":"8.3.2.1.1"}]
[null,"5. Refrigerant Charge",{"$f":"'5. Refrigerant Charge'!B8","v":"For Non-Invasive Method, enter forced-air HVAC system type"},{"$f":"'5. Refrigerant Charge'!H8","v":"Other"},"-",{"$f":"'5. Refrigerant Charge'!J8","v":"8.3.2.1.2"}]
[null,"5. Refrigerant Charge",{"$f":"'5. Refrigerant Charge'!B9","v":"For Non-Invasive Method, enter equipment rated SEER"},{"$f":"'5. Refrigerant Charge'!H9","v":0},{"$f":"'5. Refrigerant Charge'!I9","v":"SEER"},{"$f":"'5. Refrigerant Charge'!J9","v":"8.3.2.1.3"}]
[null,"5. Refrigerant Charge",{"$f":"'5. Refrigerant Charge'!B10","v":"Have prerequisites been met to use Non-Invasive Method?"},{"$f":"'5. Refrigerant Charge'!H10","v":"No"},"-",{"$f":"'5. Refrigerant Charge'!J10","v":"8.3.2.1.4"}]
[null,"5. Refrigerant Charge",{"$f":"'5. Refrigerant Charge'!B11","v":"Select test method"},{"$f":"'5. Refrigerant Charge'!H11","v":"Weigh-In"},"-",{"$f":"'5. Refrigerant Charge'!J11","v":8.3000000000000007}]
[null,{"$f":"MID(CELL(\"filename\",INDIRECT(RIGHT(_xlfn.FORMULATEXT(D397),LEN(_xlfn.FORMULATEXT(D397))-1),TRUE)),FIND(\"]\",CELL(\"filename\",INDIRECT(RIGHT(_xlfn.FORMULATEXT(D397),LEN(_xlfn.FORMULATEXT(D397))-1),TRUE)))+1,255)","v":"5. Refrigerant Charge"},{"$f":"\"Non-Invasive Method - \"&'5. Refrigerant Charge'!B15","v":"Non-Invasive Method - Dwelling and forced-air HVAC system set up per Section 8.4.1?"},{"$f":"'5. Refrigerant Charge'!H15","v":"Yes"},"-",{"$f":"'5. Refrigerant Charge'!J15","v":"8.4.1"}]
[null,"5. Refrigerant Charge",{"$f":"\"Non-Invasive Method - \"&'5. Refrigerant Charge'!B18","v":"Non-Invasive Method - Enter design cooling blower fan volumetric airflow"},{"$f":"'5. Refrigerant Charge'!H18","v":0},{"$f":"'5. Refrigerant Charge'!I18","v":"CFM"},{"$f":"'5. Refrigerant Charge'!J18","v":"8.4.3.8.1"}]
[null,"5. Refrigerant Charge",{"$f":"\"Non-Invasive Method - \"&'5. Refrigerant Charge'!B19","v":"Non-Invasive Method - Enter maximum total heat gain"},{"$f":"'5. Refrigerant Charge'!H19","v":0},{"$f":"'5. Refrigerant Charge'!I19","v":"BTU/hr"},{"$f":"'5. Refrigerant Charge'!J19","v":"8.4.3.8.1"}]
[null,"5. Refrigerant Charge",{"$f":"\"Non-Invasive Method - \"&'5. Refrigerant Charge'!B20","v":"Non-Invasive Method - Enter metering device"},{"$f":"'5. Refrigerant Charge'!H20","v":"Piston/Cap. Tube"},"-",{"$f":"'5. Refrigerant Charge'!J20","v":"8.4.3.9"}]
[null,"5. Refrigerant Charge",{"$f":"\"Non-Invasive Method - \"&'5. Refrigerant Charge'!B21","v":"Non-Invasive Method - If metering device is TXV/EEV, then enter Target Subcooling"},{"$f":"'5. Refrigerant Charge'!H21","v":0},{"$f":"'5. Refrigerant Charge'!I21","v":"F"},{"$f":"'5. Refrigerant Charge'!J21","v":"8.4.3.10.1"}]
[null,"5. Refrigerant Charge",{"$f":"\"Non-Invasive Method - \"&'5. Refrigerant Charge'!B24","v":"Non-Invasive Method - Enter measured return air dry-bulb temperature"},{"$f":"'5. Refrigerant Charge'!H24","v":0},{"$f":"'5. Refrigerant Charge'!I24","v":"F"},{"$f":"'5. Refrigerant Charge'!J24","v":"8.4.3.3"}]
[null,"5. Refrigerant Charge",{"$f":"\"Non-Invasive Method - \"&'5. Refrigerant Charge'!B25","v":"Non-Invasive Method - Enter measured return air wet-bulb temperature"},{"$f":"'5. Refrigerant Charge'!H25","v":0},{"$f":"'5. Refrigerant Charge'!I25","v":"F"},{"$f":"'5. Refrigerant Charge'!J25","v":"8.4.3.3"}]
[null,"5. Refrigerant Charge",{"$f":"\"Non-Invasive Method - \"&'5. Refrigerant Charge'!B26","v":"Non-Invasive Method - Return air temperature measurements meet criteria? "},{"$f":"'5. Refrigerant Charge'!H26","v":"No"},"-",{"$f":"'5. Refrigerant Charge'!J26","v":"8.4.3.5"}]
[null,"5. Refrigerant Charge",{"$f":"\"Non-Invasive Method - \"&'5. Refrigerant Charge'!B27","v":"Non-Invasive Method - Enter measured outdoor air dry-bulb temperature"},{"$f":"'5. Refrigerant Charge'!H27","v":0},{"$f":"'5. Refrigerant Charge'!I27","v":"F"},{"$f":"'5. Refrigerant Charge'!J27","v":"8.4.3.6.1"}]
[null,"5. Refrigerant Charge",{"$f":"\"Non-Invasive Method - \"&'5. Refrigerant Charge'!B28","v":"Non-Invasive Method - Outdoor air temperature measurement meets criteria? "},{"$f":"'5. Refrigerant Charge'!H28","v":"No"},"-",{"$f":"'5. Refrigerant Charge'!J28","v":"8.4.3.6.1"}]
[null,"5. Refrigerant Charge",{"$f":"\"Non-Invasive Method - \"&'5. Refrigerant Charge'!B29","v":"Non-Invasive Method - Enter measured suction line temperature"},{"$f":"'5. Refrigerant Charge'!H29","v":0},{"$f":"'5. Refrigerant Charge'!I29","v":"F"},{"$f":"'5. Refrigerant Charge'!J29","v":"8.4.3.6.2"}]
[null,"5. Refrigerant Charge",{"$f":"\"Non-Invasive Method - \"&'5. Refrigerant Charge'!B30","v":"Non-Invasive Method - Enter measured liquid line temperature"},{"$f":"'5. Refrigerant Charge'!H30","v":0},{"$f":"'5. Refrigerant Charge'!I30","v":"F"},{"$f":"'5. Refrigerant Charge'!J30","v":"8.4.3.6.3"}]
[null,"5. Refrigerant Charge",{"$f":"\"Non-Invasive Method - \"&'5. Refrigerant Charge'!B31","v":"Non-Invasive Method - If metering device is Piston/Capillary Tube, then enter Target Superheat using OEM superheat chart or Std 310 Appendix B, for the given return air wet-bulb temp and outdoor air dry-bulb temp"},{"$f":"'5. Refrigerant Charge'!H31","v":0},{"$f":"'5. Refrigerant Charge'!I31","v":"F"},{"$f":"'5. Refrigerant Charge'!J31","v":"8.4.3.9.1"}]
[null,"5. Refrigerant Charge",{"$f":"\"Non-Invasive Method - \"&'5. Refrigerant Charge'!B36","v":"Non-Invasive Method - Did contractor provide site-specific installation values? "},{"$f":"'5. Refrigerant Charge'!H36","v":"No"},"-","-"]
[null,"5. Refrigerant Charge",{"$f":"\"Non-Invasive Method - \"&'5. Refrigerant Charge'!B37","v":"Non-Invasive Method - If Yes, enter their return air dry bulb temperature"},{"$f":"'5. Refrigerant Charge'!H37","v":0},{"$f":"'5. Refrigerant Charge'!I37","v":"F"},{"$f":"'5. Refrigerant Charge'!J37","v":"8.4.3.8.3"}]
[null,"5. Refrigerant Charge",{"$f":"\"Non-Invasive Method - \"&'5. Refrigerant Charge'!B38","v":"Non-Invasive Method - If Yes, enter their suction line saturation temperature"},{"$f":"'5. Refrigerant Charge'!H38","v":0},{"$f":"'5. Refrigerant Charge'!I38","v":"F"},{"$f":"'5. Refrigerant Charge'!J38","v":"8.4.3.8.3"}]
[null,"5. Refrigerant Charge",{"$f":"\"Non-Invasive Method - \"&'5. Refrigerant Charge'!B40","v":"Non-Invasive Method - Their outdoor air dry bulb temperature"},{"$f":"'5. Refrigerant Charge'!H40","v":0},{"$f":"'5. Refrigerant Charge'!I40","v":"F"},{"$f":"'5. Refrigerant Charge'!J40","v":"8.4.3.10.2.2"}]
[null,"5. Refrigerant Charge",{"$f":"\"Non-Invasive Method - \"&'5. Refrigerant Charge'!B41","v":"Non-Invasive Method - Their liquid line condensing temperature"},{"$f":"'5. Refrigerant Charge'!H41","v":0},{"$f":"'5. Refrigerant Charge'!I41","v":"F"},{"$f":"'5. Refrigerant Charge'!J41","v":"8.4.3.10.2.2"}]
[null,"5. Refrigerant Charge",{"$f":"\"Non-Invasive Method - \"&'5. Refrigerant Charge'!B44","v":"Non-Invasive Method - Qnorm - normalized airflow"},{"$f":"'5. Refrigerant Charge'!H44","v":{"$error":"#DIV/0!"}},{"$f":"'5. Refrigerant Charge'!I44","v":"CFM"},{"$f":"'5. Refrigerant Charge'!J44","v":"8.4.3.8.1"}]
[null,"5. Refrigerant Charge",{"$f":"\"Non-Invasive Method - \"&'5. Refrigerant Charge'!B45","v":"Non-Invasive Method - DTD - Design Temp Difference"},{"$f":"'5. Refrigerant Charge'!H45","v":{"$error":"#DIV/0!"}},{"$f":"'5. Refrigerant Charge'!I45","v":"F"},{"$f":"'5. Refrigerant Charge'!J45","v":"8.4.3.8.4"}]
[null,"5. Refrigerant Charge",{"$f":"\"Non-Invasive Method - \"&'5. Refrigerant Charge'!B48","v":"Non-Invasive Method - Min liquid line temp"},{"$f":"'5. Refrigerant Charge'!H48","v":3},{"$f":"'5. Refrigerant Charge'!I48","v":"F"},{"$f":"'5. Refrigerant Charge'!J48","v":"8.4.3.9.2"}]
[null,"5. Refrigerant Charge",{"$f":"\"Non-Invasive Method - \"&'5. Refrigerant Charge'!B49","v":"Non-Invasive Method - Max liquid line temp"},{"$f":"'5. Refrigerant Charge'!H49","v":12},{"$f":"'5. Refrigerant Charge'!I49","v":"F"},{"$f":"'5. Refrigerant Charge'!J49","v":"8.4.3.9.3"}]
[null,"5. Refrigerant Charge",{"$f":"\"Non-Invasive Method - \"&'5. Refrigerant Charge'!B50","v":"Non-Invasive Method - Liquid line within target?"},{"$f":"'5. Refrigerant Charge'!H50","v":"No"},"-",{"$f":"'5. Refrigerant Charge'!J50","v":"8.4.3.9.4"}]
[null,"5. Refrigerant Charge",{"$f":"\"Non-Invasive Method - \"&'5. Refrigerant Charge'!B51","v":"Non-Invasive Method - Target suction line temp"},{"$f":"'5. Refrigerant Charge'!H51","v":"N/A"},{"$f":"'5. Refrigerant Charge'!I51","v":"F"},{"$f":"'5. Refrigerant Charge'!J51","v":"8.4.3.9.5"}]
[null,"5. Refrigerant Charge",{"$f":"\"Non-Invasive Method - \"&'5. Refrigerant Charge'!B52","v":"Non-Invasive Method - Difference DTD - delta btw target & measured suction line temp"},{"$f":"'5. Refrigerant Charge'!H52","v":"N/A"},{"$f":"'5. Refrigerant Charge'!I52","v":"F"},{"$f":"'5. Refrigerant Charge'!J52","v":"8.4.3.9.6"}]
[null,"5. Refrigerant Charge",{"$f":"\"Non-Invasive Method - \"&'5. Refrigerant Charge'!B55","v":"Non-Invasive Method - CTOA - Condensing Temp Over Ambient"},{"$f":"'5. Refrigerant Charge'!H55","v":30},{"$f":"'5. Refrigerant Charge'!I55","v":"F"},{"$f":"'5. Refrigerant Charge'!J55","v":"8.4.3.10.2.3"}]
[null,"5. Refrigerant Charge",{"$f":"\"Non-Invasive Method - \"&'5. Refrigerant Charge'!B56","v":"Non-Invasive Method - Min suction line temp"},{"$f":"'5. Refrigerant Charge'!H56","v":{"$error":"#DIV/0!"}},{"$f":"'5. Refrigerant Charge'!I56","v":"F"},{"$f":"'5. Refrigerant Charge'!J56","v":"8.4.3.10.3"}]
[null,"5. Refrigerant Charge",{"$f":"\"Non-Invasive Method - \"&'5. Refrigerant Charge'!B57","v":"Non-Invasive Method - Max suction line temp"},{"$f":"'5. Refrigerant Charge'!H57","v":{"$error":"#DIV/0!"}},{"$f":"'5. Refrigerant Charge'!I57","v":"F"},{"$f":"'5. Refrigerant Charge'!J57","v":"8.4.3.10.4"}]
[null,"5. Refrigerant Charge",{"$f":"\"Non-Invasive Method - \"&'5. Refrigerant Charge'!B58","v":"Non-Invasive Method - Suction line within target?"},{"$f":"'5. Refrigerant Charge'!H58","v":{"$error":"#DIV/0!"}},"-",{"$f":"'5. Refrigerant Charge'!J58","v":"8.4.3.10.5"}]
[null,"5. Refrigerant Charge",{"$f":"\"Non-Invasive Method - \"&'5. Refrigerant Charge'!B59","v":"Non-Invasive Method - Target liquid line temp"},{"$f":"'5. Refrigerant Charge'!H59","v":30},{"$f":"'5. Refrigerant Charge'!I59","v":"F"},{"$f":"'5. Refrigerant Charge'!J59","v":"8.4.3.10.6"}]
[null,"5. Refrigerant Charge",{"$f":"\"Non-Invasive Method - \"&'5. Refrigerant Charge'!B60","v":"Non-Invasive Method - DifferenceCTOA - delta btw target & measured liquid line temp"},{"$f":"'5. Refrigerant Charge'!H60","v":30},{"$f":"'5. Refrigerant Charge'!I60","v":"F"},{"$f":"'5. Refrigerant Charge'!J60","v":"8.4.3.10.7"}]
[null,"5. Refrigerant Charge",{"$f":"\"Weigh-In Method - \"&'5. Refrigerant Charge'!B64","v":"Weigh-In Method - The total weight of refrigerant added to or removed from the system"},{"$f":"'5. Refrigerant Charge'!H64","v":0},{"$f":"'5. Refrigerant Charge'!I64","v":"Oz."},{"$f":"'5. Refrigerant Charge'!J64","v":"8.5.2.1.1"}]
[null,"5. Refrigerant Charge",{"$f":"\"Weigh-In Method - \"&'5. Refrigerant Charge'!B65","v":"Weigh-In Method - Refrigerant added or removed? "},{"$f":"'5. Refrigerant Charge'!H65","v":"Added"},"-","-"]
[null,"5. Refrigerant Charge",{"$f":"\"Weigh-In Method - \"&'5. Refrigerant Charge'!B66","v":"Weigh-In Method - Was factory charge removed first? "},{"$f":"'5. Refrigerant Charge'!H66","v":"No"},"-","-"]
[null,"5. Refrigerant Charge",{"$f":"\"Weigh-In Method - \"&'5. Refrigerant Charge'!B67","v":"Weigh-In Method - Was time-stamped geotagged photo(s) collected, showing scale with \namount of refrigerant added or removed?"},{"$f":"'5. Refrigerant Charge'!H67","v":"Yes"},"-",{"$f":"'5. Refrigerant Charge'!J67","v":"8.5.2.1.2"}]
[null,"5. Refrigerant Charge",{"$f":"\"Weigh-In Method - \"&'5. Refrigerant Charge'!B69","v":"Weigh-In Method - The total length of the liquid line"},{"$f":"'5. Refrigerant Charge'!H69","v":0},{"$f":"'5. Refrigerant Charge'!I69","v":"Ft."},{"$f":"'5. Refrigerant Charge'!J69","v":"8.5.2.1.3"}]
[null,"5. Refrigerant Charge",{"$f":"\"Weigh-In Method - \"&'5. Refrigerant Charge'!B70","v":"Weigh-In Method - The outside diameter of the liquid line"},{"$f":"'5. Refrigerant Charge'!H70","v":"3/8\""},{"$f":"'5. Refrigerant Charge'!I70","v":"In."},{"$f":"'5. Refrigerant Charge'!J70","v":"8.5.2.1.4"}]
[null,"5. Refrigerant Charge",{"$f":"\"Weigh-In Method - \"&'5. Refrigerant Charge'!B71","v":"Weigh-In Method - The length of liquid line accounted for in the factory-supplied "},{"$f":"'5. Refrigerant Charge'!H71","v":0},{"$f":"'5. Refrigerant Charge'!I71","v":"Ft."},{"$f":"'5. Refrigerant Charge'!J71","v":"8.5.2.1.5"}]
[null,"5. Refrigerant Charge",{"$f":"\"Weigh-In Method - \"&'5. Refrigerant Charge'!B72","v":"Weigh-In Method - The weight of the factory-supplied refrigerant "},{"$f":"'5. Refrigerant Charge'!H72","v":0},{"$f":"'5. Refrigerant Charge'!I72","v":"Oz."},{"$f":"'5. Refrigerant Charge'!J72","v":"8.5.2.1.6"}]
[null,"5. Refrigerant Charge",{"$f":"\"Weigh-In Method - \"&'5. Refrigerant Charge'!B73","v":"Weigh-In Method - The weight of refrigerant added for specific components (other than line length)"},{"$f":"'5. Refrigerant Charge'!H73","v":0},{"$f":"'5. Refrigerant Charge'!I73","v":"Oz."},{"$f":"'5. Refrigerant Charge'!J73","v":"8.5.2.1.7"}]
[null,"5. Refrigerant Charge",{"$f":"\"Weigh-In Method - \"&'5. Refrigerant Charge'!B75","v":"Weigh-In Method - Enter the total length of the liquid line"},{"$f":"'5. Refrigerant Charge'!H75","v":0},{"$f":"'5. Refrigerant Charge'!I75","v":"Ft."},{"$f":"'5. Refrigerant Charge'!J75","v":"8.5.3.1"}]
[null,"5. Refrigerant Charge",{"$f":"\"Weigh-In Method - \"&'5. Refrigerant Charge'!B76","v":"Weigh-In Method - Enter the outside diameter of the liquid line"},{"$f":"'5. Refrigerant Charge'!H76","v":"3/8\""},{"$f":"'5. Refrigerant Charge'!I76","v":"In."},{"$f":"'5. Refrigerant Charge'!J76","v":"8.5.3.3"}]
[null,"5. Refrigerant Charge",{"$f":"\"Weigh-In Method - \"&'5. Refrigerant Charge'!B77","v":"Weigh-In Method - Delta liquid line length"},{"$f":"'5. Refrigerant Charge'!H77","v":0},{"$f":"'5. Refrigerant Charge'!I77","v":"Ft."},{"$f":"'5. Refrigerant Charge'!J77","v":"8.5.3.2"}]
[null,"5. Refrigerant Charge",{"$f":"\"Weigh-In Method - \"&'5. Refrigerant Charge'!B78","v":"Weigh-In Method - Weight of the refrigerant required for the incremental liquid line length"},{"$f":"'5. Refrigerant Charge'!H78","v":0},{"$f":"'5. Refrigerant Charge'!I78","v":"Oz."},{"$f":"'5. Refrigerant Charge'!J78","v":"8.5.3.4"}]
[null,"5. Refrigerant Charge",{"$f":"\"Weigh-In Method - \"&'5. Refrigerant Charge'!B79","v":"Weigh-In Method - Total anticipated refrigerant weight "},{"$f":"'5. Refrigerant Charge'!H79","v":0},{"$f":"'5. Refrigerant Charge'!I79","v":"Oz."},{"$f":"'5. Refrigerant Charge'!J79","v":"8.5.3.5"}]
[null,"5. Refrigerant Charge",{"$f":"\"Weigh-In Method - \"&'5. Refrigerant Charge'!B80","v":"Weigh-In Method - Total reported refrigerant weight"},{"$f":"'5. Refrigerant Charge'!H80","v":0},{"$f":"'5. Refrigerant Charge'!I80","v":"Oz."},{"$f":"'5. Refrigerant Charge'!J80","v":"8.5.3.6"}]
[null,"5. Refrigerant Charge",{"$f":"\"Weigh-In Method - \"&'5. Refrigerant Charge'!B81","v":"Weigh-In Method - Deviation between the total anticipated and total reported refrigerant weight "},{"$f":"'5. Refrigerant Charge'!H81","v":"N/A"},"-",{"$f":"'5. Refrigerant Charge'!J81","v":"8.5.3.7"}]
[null,"5. Refrigerant Charge",{"$f":"'5. Refrigerant Charge'!B84","v":"Refrigerant Charge Grade for Non-Invasive Method: Piston/Capillary Tube"},{"$f":"'5. Refrigerant Charge'!H84","v":"N/A"},"-",{"$f":"'5. Refrigerant Charge'!J84","v":"8.6.2.1"}]
[null,"5. Refrigerant Charge",{"$f":"'5. Refrigerant Charge'!B90","v":"Refrigerant Charge Grade for Non-Invasive Method: TXV/EEV"},{"$f":"'5. Refrigerant Charge'!H90","v":"N/A"},"-",{"$f":"'5. Refrigerant Charge'!J90","v":"8.6.2.2"}]
[null,"5. Refrigerant Charge",{"$f":"\"Weigh-In Method - \"&'5. Refrigerant Charge'!B97","v":"Weigh-In Method - Does the location of the geotagged photo provided in Section 8.5.2.1.2 "},{"$f":"'5. Refrigerant Charge'!H97","v":"Yes"},"-",{"$f":"'5. Refrigerant Charge'!J97","v":"8.6.2.1.2"}]
[null,"5. Refrigerant Charge",{"$f":"\"Weigh-In Method - \"&'5. Refrigerant Charge'!B99","v":"Weigh-In Method - Grade Designation"},{"$f":"'5. Refrigerant Charge'!H99","v":{"$error":"#VALUE!"}},"-",{"$f":"'5. Refrigerant Charge'!J99","v":"8.6.3"}]