{"text_format":"1","workbook":"xlsx","n_sheets":34,"sheets":["Color legend","Schedules - Assembly","Schedules - Office","Schedules - Retail","Schedules - Dwelling Unit","Version Control","1,2,3 Information","3d. LL97 GHG Summary","4. Compliance","5a. Baseline Rotations","5b. Usage Summary","5a. Description of Project","6a. Ext. Wall Areas","6b. Fenestration","6c1. Wall Types","6c2. Wall Types - Add'l Rows","6d.1 Interior LPD-Space Method","6d.2 Interior LPD-Bldg  Method","6e. Ext LPD","6f. Process Equip.","6g. Service HW","Instructions for HVAC_Cover","HVAC_Cover","Lists","HVAC Air-side","6j. HVAC Water-side CHW  ","6k. HVAC Water-side CW&CT","6l. HVAC Water-side HW&Steam","6m. HVAC- Geothermal","6n. CHP","Lists-Areas","Lighting Lookup","Lighting Zones","Raw Data"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":5,"defined_names":97,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Color legend","index":0,"n_rows":12,"n_cols":1,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
["WORKBOOK COLOR LEGEND"]
["Do not edit:  information"]
["Do not edit:  formulas"]
["Do not edit:  error"]
["User edit:  required information"]
["User edit:  drop-down menu"]
["User edit: drop-down menu (only for use with Appendix G)"]
["User edit: formula + drop-down menu"]
["User edit:  fill in box"]

{"sheet":"Schedules - Assembly","index":1,"n_rows":30,"n_cols":16,"rows_kept":30,"cut":false,"hidden":true,"merged":[[0,0,2,0],[1,1,1,3],[0,4,0,6],[1,4,1,6],[0,10,0,12],[1,10,1,12],[0,13,0,15],[1,13,1,15],[0,7,1,9],[28,1,28,3],[29,1,29,3],[0,1,0,3],[28,7,28,9],[29,7,29,9],[28,10,28,12],[29,10,29,12],[28,13,28,15],[29,13,29,15],[28,4,28,6],[29,4,29,6]]}
["Hour of Day (Time)","Schedule for Occupancy",null,null,"Schedule for Lighting/Receptacle",null,null,"Schedule for HVAC System",null,null,"Schedule for Service Hot Water",null,null,"Schedule for Elevator"]
[null,"Percent of Maximum  Load",null,null,"Percent of Maximum  Load",null,null,null,null,null,"Percent of Maximum  Load",null,null,"Percent of Maximum  Load"]
[null,"Wk","Sat","Sun","Wk","Sat","Sun","Wk","Sat","Sun","Wk","Sat","Sun","Wk","Sat","Sun"]
["1 (12-1am)",0,0,0,5,5,5,"Off","Off","Off",0,0,0,0,0,0]
["2 (1-2am)",0,0,0,5,5,5,"Off","Off","Off",0,0,0,0,0,0]
["3 (2-3am)",0,0,0,5,5,5,"Off","Off","Off",0,0,0,0,0,0]
["4 (3-4am)",0,0,0,5,5,5,"Off","Off","Off",0,0,0,0,0,0]
["5 (4-5am)",0,0,0,5,5,5,"Off","Off","Off",0,0,0,0,0,0]
["6 (5-6am)",0,0,0,5,5,5,"On","Off","Off",0,0,0,0,0,0]
["7 (6-7am)",0,0,0,"35/40",5,5,"On","On","On",0,0,0,0,0,0]
["8 (7-8am)",0,0,0,"35/40",30,30,"On","On","On",0,0,0,0,0,0]
["9 (8-9am)",20,20,10,"35/40",30,30,"On","On","On",0,0,0,0,0,0]
["10 (9-10am)",20,20,10,"65/75","40/50",30,"On","On","On",5,5,5,0,0,0]
["11 (10-11am)",20,20,10,"65/75","40/50",30,"On","On","On",5,5,5,0,0,0]
["12 (11-12pm)",80,60,10,"65/75","40/50",30,"On","On","On",35,20,10,0,0,0]
["13 (12-1pm)",80,60,10,"65/75","40/50","55/65","On","On","On",5,0,0,0,0,0]
["14 (1-2pm)",80,60,70,"65/75","40/50","55/65","On","On","On",5,0,0,0,0,0]
["15 (2-3pm)",80,60,70,"65/75","40/50","55/65","On","On","On",5,0,0,0,0,0]
["16 (3-4pm)",80,60,70,"65/75","40/50","55/65","On","On","On",5,0,0,0,0,0]
["17 (4-5pm)",80,60,70,"65/75","40/50","55/65","On","On","On",5,0,0,0,0,0]
["18 (5-6pm)",80,60,70,"65/75","40/50","55/65","On","On","On",0,0,0,0,0,0]
["19 (6-7pm)",20,60,70,"65/75","40/50","55/65","On","On","On",0,0,0,0,0,0]
["20 (7-8pm)",20,60,70,"65/75","40/50","55/65","On","On","On",0,65,65,0,0,0]
["21 (8-9pm)",20,60,70,"65/75","40/50","55/65","On","On","On",0,30,30,0,0,0]
["22 (9-10pm)",20,80,70,"65/75","40/50","55/65","On","On","On",0,0,0,0,0,0]
["23 (10-11pm)",10,10,20,25,"40/50","55/65","On","On","On",0,0,0,0,0,0]
["24 (11-12am)",0,0,0,5,5,5,"Off","Off","Off",0,0,0,0,0,0]
["Total/Day",{"$f":"SUM(B4:B27)","v":710},{"$f":"SUM(C4:C27)","v":750},700,"1010/1155","660/800","745/845",1800,1700,1700,70,125,115,0,0,0]
["Total/Week",{"$f":"((B28/100)*5+C28/100+D28/100)","v":50},null,null,"64.55/74.2",null,null,{"$f":"((H28/100)*5+I28/100+J28/100)","v":124},null,null,{"$f":"((K28/100)*5+L28/100+M28/100)","v":5.9},null,null,{"$f":"((N28/100)*5+O28/100+P28/100)","v":0}]
["Total/Year",{"$f":"B29*52.14","v":2607},null,null,"3357/3869",null,null,{"$f":"H29*52.14","v":6465.36},null,null,{"$f":"K29*52.14","v":307.62600000000003},null,null,{"$f":"N29*52.14","v":0}]

{"sheet":"Schedules - Office","index":2,"n_rows":30,"n_cols":16,"rows_kept":30,"cut":false,"hidden":true,"merged":[[0,13,0,15],[1,1,1,3],[1,4,1,6],[1,10,1,12],[1,13,1,15],[0,0,2,0],[0,1,0,3],[0,4,0,6],[0,7,1,9],[0,10,0,12],[28,13,28,15],[29,13,29,15],[28,4,28,6],[29,4,29,6],[28,1,28,3],[29,1,29,3],[28,7,28,9],[29,7,29,9],[28,10,28,12],[29,10,29,12]]}
["Hour of Day (Time)","Schedule for Occupancy",null,null,"Schedule for Lighting/Receptacle",null,null,"Schedule for HVAC System",null,null,"Schedule for Service Hot Water",null,null,"Schedule for Elevator"]
[null,"Percent of Maximum  Load",null,null,"Percent of Maximum  Load",null,null,null,null,null,"Percent of Maximum  Load",null,null,"Percent of Maximum  Load"]
[null,"Wk","Sat","Sun","Wk","Sat","Sun","Wk","Sat","Sun","Wk","Sat","Sun","Wk","Sat","Sun"]
["1 (12-1am)",0,0,0,5,5,5,"Off","Off","Off",5,5,4,0,0,0]
["2 (1-2am)",0,0,0,5,5,5,"Off","Off","Off",5,5,4,0,0,0]
["3 (2-3am)",0,0,0,5,5,5,"Off","Off","Off",5,5,4,0,0,0]
["4 (3-4am)",0,0,0,5,5,5,"Off","Off","Off",5,5,4,0,0,0]
["5 (4-5am)",0,0,0,5,5,5,"Off","Off","Off",5,5,4,0,0,0]
["6 (5-6am)",0,0,0,10,5,5,"Off","Off","Off",8,8,7,0,0,0]
["7 (6-7am)",10,10,5,10,10,5,"On","On","Off",7,7,4,0,0,0]
["8 (7-8am)",20,10,5,30,10,5,"On","On","Off",19,11,4,35,16,0]
["9 (8-9am)",95,30,5,"65/95",30,5,"On","On","Off",35,15,4,69,14,0]
["10 (9-10am)",95,30,5,"65/95",30,5,"On","On","Off",38,21,4,43,21,0]
["11 (10-11am)",95,30,5,"65/95",30,5,"On","On","Off",39,19,4,37,18,0]
["12 (11-12pm)",95,30,5,"65/95",30,5,"On","On","Off",47,23,6,43,25,0]
["13 (12-1pm)",50,10,5,"55/80",15,5,"On","On","Off",57,20,6,58,21,0]
["14 (1-2pm)",95,10,5,"65/95",15,5,"On","On","Off",54,19,9,48,13,0]
["15 (2-3pm)",95,10,5,"65/95",15,5,"On","On","Off",34,15,6,37,8,0]
["16 (3-4pm)",95,10,5,"65/95",15,5,"On","On","Off",33,12,4,37,4,0]
["17 (4-5pm)",95,10,5,"65/95",15,5,"On","On","Off",44,14,4,46,5,0]
["18 (5-6pm)",30,5,5,"35/50",5,5,"On","On","Off",26,7,4,62,6,0]
["19 (6-7pm)",10,5,0,30,5,5,"On","Off","Off",21,7,4,20,0,0]
["20 (7-8pm)",10,0,0,30,5,5,"On","Off","Off",15,7,4,12,0,0]
["21 (8-9pm)",10,0,0,20,5,5,"On","Off","Off",17,7,4,4,0,0]
["22 (9-10pm)",10,0,0,20,5,5,"On","Off","Off",8,9,7,4,0,0]
["23 (10-11pm)",5,0,0,10,5,5,"Off","Off","Off",5,5,4,0,0,0]
["24 (11-12am)",5,0,0,5,5,5,"Off","Off","Off",5,5,4,0,0,0]
["Total/Day",{"$f":"SUM(B4:B27)","v":920},{"$f":"SUM(C4:C27)","v":200},60,"800/1040",280,120,1600,1200,0,537,256,113,555,151,0]
["Total/Week",{"$f":"((B28/100)*5+C28/100+D28/100)","v":48.6},null,null,"44.00/56.00",null,null,{"$f":"((H28/100)*5+I28/100+J28/100)","v":92},null,null,{"$f":"((K28/100)*5+L28/100+M28/100)","v":30.54},null,null,{"$f":"((N28/100)*5+O28/100+P28/100)","v":29.26}]
["Total/Year",{"$f":"B29*52.14","v":2534.0039999999999},null,null,"2288/2920",null,null,{"$f":"H29*52.14","v":4796.88},null,null,{"$f":"K29*52.14","v":1592.3555999999999},null,null,{"$f":"N29*52.14","v":1525.6164000000001}]

{"sheet":"Schedules - Retail","index":3,"n_rows":30,"n_cols":16,"rows_kept":30,"cut":false,"hidden":true,"merged":[[0,13,0,15],[1,1,1,3],[1,4,1,6],[1,10,1,12],[1,13,1,15],[0,0,2,0],[0,1,0,3],[0,4,0,6],[0,7,1,9],[0,10,0,12],[29,1,29,3],[29,4,29,6],[29,7,29,9],[29,10,29,12],[29,13,29,15],[28,1,28,3],[28,4,28,6],[28,7,28,9],[28,10,28,12],[28,13,28,15]]}
["Hour of Day (Time)","Schedule for Occupancy",null,null,"Schedule for Lighting/Receptacle",null,null,"Schedule for HVAC System",null,null,"Schedule for Service Hot Water",null,null,"Schedule for Elevator"]
[null,"Percent of Maximum  Load",null,null,"Percent of Maximum  Load",null,null,null,null,null,"Percent of Maximum  Load",null,null,"Percent of Maximum  Load"]
[null,"Wk","Sat","Sun","Wk","Sat","Sun","Wk","Sat","Sun","Wk","Sat","Sun","Wk","Sat","Sun"]
["1 (12-1am)",0,0,0,5,5,5,"Off","Off","Off",4,11,7,0,0,0]
["2 (1-2am)",0,0,0,5,5,5,"Off","Off","Off",5,10,7,0,0,0]
["3 (2-3am)",0,0,0,5,5,5,"Off","Off","Off",5,8,7,0,0,0]
["4 (3-4am)",0,0,0,5,5,5,"Off","Off","Off",4,6,6,0,0,0]
["5 (4-5am)",0,0,0,5,5,5,"Off","Off","Off",4,6,6,0,0,0]
["6 (5-6am)",0,0,0,5,5,5,"Off","Off","Off",4,6,6,0,0,0]
["7 (6-7am)",0,0,0,5,5,5,"On","On","Off",4,7,7,0,0,0]
["8 (7-8am)",10,10,0,20,10,5,"On","On","Off",15,20,10,12,9,0]
["9 (8-9am)",20,20,0,50,30,10,"On","On","On",23,24,12,22,21,0]
["10 (9-10am)",50,50,10,"85/90","55/60",10,"On","On","On",32,27,14,64,56,11]
["11 (10-11am)",50,60,20,"85/90","85/90",40,"On","On","On",41,42,29,74,66,13]
["12 (11-12pm)",70,80,20,"85/90","85/90",40,"On","On","On",57,54,31,68,68,35]
["13 (12-1pm)",70,80,40,"85/90","85/90","55/60","On","On","On",62,59,36,68,68,37]
["14 (1-2pm)",70,80,40,"85/90","85/90","55/60","On","On","On",61,60,36,71,69,37]
["15 (2-3pm)",70,80,40,"85/90","85/90","55/60","On","On","On",50,49,34,72,70,39]
["16 (3-4pm)",80,80,40,"85/90","85/90","55/60","On","On","On",45,48,35,72,69,41]
["17 (4-5pm)",70,80,40,"85/90","85/90","55/60","On","On","On",46,47,37,73,66,38]
["18 (5-6pm)",50,60,20,"85/90","85/90",40,"On","On","Off",47,46,34,68,58,34]
["19 (6-7pm)",50,20,10,"55/60",50,20,"On","On","Off",42,44,25,68,47,3]
["20 (7-8pm)",30,20,0,"55/60",30,5,"On","On","Off",34,36,27,58,43,0]
["21 (8-9pm)",30,20,0,50,30,5,"On","On","Off",33,29,21,54,43,0]
["22 (9-10pm)",0,10,0,20,10,5,"Off","On","Off",23,22,16,0,8,0]
["23 (10-11pm)",0,0,0,5,5,5,"Off","Off","Off",13,16,10,0,0,0]
["24 (11-12am)",0,0,0,5,5,5,"Off","Off","Off",8,13,6,0,0,0]
["Total/Day",{"$f":"SUM(B4:B27)","v":720},{"$f":"SUM(C4:C27)","v":750},280,"1060/1155","940/985","500/525",1500,1600,900,662,690,459,844,761,288]
["Total/Week",{"$f":"((B28/100)*5+C28/100+D28/100)","v":46.3},null,null,"67.40/70.85",null,null,{"$f":"((H28/100)*5+I28/100+J28/100)","v":100},null,null,{"$f":"((K28/100)*5+L28/100+M28/100)","v":44.59},null,null,{"$f":"((N28/100)*5+O28/100+P28/100)","v":52.69}]
["Total/Year",{"$f":"B29*52.14","v":2414.0819999999999},null,null,"3505/3694",null,null,{"$f":"H29*52.14","v":5214},null,null,{"$f":"K29*52.14","v":2324.9226000000003},null,null,{"$f":"N29*52.14","v":2747.2565999999997}]

{"sheet":"Schedules - Dwelling Unit","index":4,"n_rows":30,"n_cols":12,"rows_kept":30,"cut":false,"hidden":true,"merged":[[0,12,0,14],[1,1,1,3],[1,4,1,6],[1,9,1,11],[1,12,1,14],[0,0,2,0],[0,1,0,3],[0,4,0,6],[0,7,1,8],[0,9,0,11]]}
["Hour of Day (Time)","Schedule for Occupancy",null,null,"Schedule for Lighting/Receptacle",null,null,"Daily Thermostat Schedule",null,"Schedule for Service Hot Water"]
[null,"Percent of Maximum  Load",null,null,"Percent of Maximum  Load",null,null,null,null,"Percent of Maximum  Load"]
[null,"Wk","Sat","Sun","Wk","Sat","Sun","Cooling","Heating","Wk","Sat","Sun"]
["1 (12-1am)",1.6,1.6,1.6,5,5,5,70,78,5,5,5]
["2 (1-2am)",1.6,1.6,1.6,5,5,5,70,78,5,5,5]
["3 (2-3am)",1.6,1.6,1.6,5,5,5,70,78,5,5,5]
["4 (3-4am)",1.6,1.6,1.6,5,5,5,70,78,5,5,5]
["5 (4-5am)",1.6,1.6,1.6,5,5,5,70,78,5,5,5]
["6 (5-6am)",1.6,1.6,1.6,5,5,5,70,78,5,5,5]
["7 (6-7am)",7.7,7.7,7.7,5,5,5,72,78,30,30,30]
["8 (7-8am)",14,14,14,5,5,5,72,78,50,50,50]
["9 (8-9am)",14,14,14,50,50,50,72,78,40,40,40]
["10 (9-10am)",10.8,10.8,10.8,50,50,50,72,80,30,30,30]
["11 (10-11am)",10.8,10.8,10.8,50,50,50,72,80,30,30,30]
["12 (11-12pm)",10.8,10.8,10.8,50,50,50,72,80,35,35,35]
["13 (12-1pm)",7.7,7.7,7.7,30,30,30,72,80,40,40,40]
["14 (1-2pm)",7.7,7.7,7.7,50,50,50,72,80,35,35,35]
["15 (2-3pm)",7.7,7.7,7.7,50,50,50,72,80,35,35,35]
["16 (3-4pm)",7.7,7.7,7.7,50,50,50,72,78,30,30,30]
["17 (4-5pm)",7.7,7.7,7.7,50,50,50,72,78,30,30,30]
["18 (5-6pm)",10.8,10.8,10.8,50,50,50,72,78,50,50,50]
["19 (6-7pm)",21.7,21.7,21.7,35,35,35,72,78,50,50,50]
["20 (7-8pm)",21.7,21.7,21.7,5,5,5,72,78,40,40,40]
["21 (8-9pm)",21.7,21.7,21.7,5,5,5,72,78,35,35,35]
["22 (9-10pm)",21.7,21.7,21.7,5,5,5,72,78,45,45,45]
["23 (10-11pm)",18.600000000000001,18.600000000000001,18.600000000000001,5,5,5,72,78,30,30,30]
["24 (11-12am)",1.6,1.6,1.6,5,5,5,70,78,5,5,5]
["Total/Day",{"$f":"SUM(B4:B27)","v":233.99999999999994},{"$f":"SUM(C4:C27)","v":233.99999999999994},233.99999999999994,{"$f":"SUM(E4:E27)","v":580},{"$f":"SUM(F4:F27)","v":580},{"$f":"SUM(G4:G27)","v":580},null,null,670,670,670]
["Total/Week",{"$f":"((B28/100)*5+C28/100+D28/100)","v":16.379999999999995},null,null,{"$f":"((E28/100)*5+F28/100+G28/100)","v":40.599999999999994},null,null,null,null,{"$f":"((J28/100)*5+K28/100+L28/100)","v":46.900000000000006}]
["Total/Year",{"$f":"B29*52.14","v":854.05319999999972},null,null,{"$f":"E29*52.14","v":2116.8839999999996},null,null,null,null,{"$f":"J29*52.14","v":2445.3660000000004}]

{"sheet":"Version Control","index":5,"n_rows":24,"n_cols":3,"rows_kept":24,"cut":false,"hidden":true,"merged":[]}
["Version #","Issue Date","Fixes"]
["Version 1","2020-05-12"]
["Version 2","2020-05-14","1,2,3. - edit cell B7, add dropdown cell C7"]
[null,null,"3d. - edit cell/formula in D18"]
[null,null,"4. - unlock cell D17"]
[null,null,"5b. - edit cells C18:L18"]
[null,null,"6c. - unlock ability to add rows"]
[null,null,"6d.1 - align with spaces/lpd (not blg area)"]
[null,null,"6f. - add formulas to C20:D21"]
[null,null,"6g. - add formula for baseline "]
["Version 3","2020-05-22","6b. - add more fenestration rows"]
[null,null,"6b. - fixed cell M22 for no skylight"]
[null,null,"6c1. - rename tab, remove ability to add rows"]
[null,null,"6c2. - add new tab for additional opaque rows"]
[null,null,"6d.1 - align all rows with spaces/lpd (not blg area)"]
[null,null,"6d.1 - edit formula for cell B31"]
[null,null,"Instructions for HVAC_Cover - added Items 5 & 6"]
["Version 4","2020-10-21","4. - edited H19:I20 to consistant units of kBTU, instead of kwh and therm"]
[null,null,"5b. - added missing formula to cell d11"]
["Version 5","2020-12-10","UNPROTECT WORKBOOK"]
["Version 6","2023-05-11","Edited \"Lighting Lookup\" tab for Multifamily Dwelling Unit LPD from 0.70 to 1.07 (per  Table G3.7)  "]
[null,"2023-05-17","Edited 6d.1 & 6d.2, corrected sum formula for building and space areas"]
["Verson 7","2023-08-10","Unprotected \"HVAC Air-side\" tab"]
[null,null,"Protected \"HVAC_Cover\" tab"]

{"sheet":"1,2,3 Information","index":6,"n_rows":37,"n_cols":9,"rows_kept":37,"cut":false,"hidden":false,"merged":[[4,0,6,0],[5,4,5,5],[24,1,24,3],[14,1,14,5],[24,6,24,8],[10,0,14,0],[10,1,10,2],[10,3,10,7],[11,1,11,4],[11,5,11,8],[12,1,12,4],[19,1,19,4],[17,1,17,8],[19,5,19,8],[14,6,14,8],[5,6,5,7],[37,2,37,3],[31,2,31,3],[32,2,32,3],[33,2,33,3],[34,2,34,3],[28,2,28,3],[29,2,29,3],[30,2,30,3],[6,2,6,7],[3,1,3,7],[4,2,4,7],[9,1,9,8],[12,5,12,8],[13,2,13,3],[13,4,13,6],[13,7,13,8],[39,2,39,3],[25,2,25,3],[18,1,18,2],[18,3,18,7],[36,1,36,3],[20,1,20,4],[20,5,20,8],[21,2,21,3],[21,4,21,6],[21,7,21,8],[25,6,28,6],[29,6,32,6],[26,2,26,3],[27,2,27,3],[33,6,36,6],[38,2,38,3]]}
[]
["Enter information for sections 1, 2 and 3 - incorporate in the drawing set."]
["            Must be typewritten"]
[1,"Location Information"]
[null,"House No(s)   530","Street Name "]
[null,"Borough  Manhattan","Block","Lot","BIN  3283595",null,"CB No."]
[null,"Job Type (NB, Alt, etc.)"]
[]
[]
["2a","Applicant Information"]
[null,"Last Name",null,"First Name",null,null,null,null,"Middle Initial"]
[null,"Business Name",null,null,null,"Business Email"]
[null,"Business Address",null,null,null,"Business Telephone"]
[null,"City  ","State",null,"Zip  "]
[null,"Email ",null,null,null,null,"License Number"]
[]
[]
["2b","Modeling Firm"]
[null,"Last Name (lead modeler)",null,"First Name (lead modeler)",null,null,null,null,"Middle Initial"]
[null,"Business Name",null,null,null,"Email (lead modeler)"]
[null,"Business Address",null,null,null,"Telephone (lead modeler)"]
[null,"City  ","State",null,"Zip  "]
[]
[]
["3a","Energy Modeling Information",null,null,null,"3b","Energy Modeling Information per Modeled Square Feet"]
[null,"Modeling Protocol (Sect 11 or Apx G)",{"$f":"IF(Path=\"\",\"Select Path on tab 4. Compliance\",Path)","v":"Section 11 ECB"},null,null,null,"Proposed ","Total Energy Cost ($/sf)",{"$f":"'4. Compliance'!G12/'1,2,3 Information'!C32","v":{"$error":"#VALUE!"}}]
[null,"Modeling Software & version",null,null,null,null,null,"Site EUI (kBtu/sf)",{"$f":"('5b. Usage Summary'!G17*3.412+'5b. Usage Summary'!H17*100)/'1,2,3 Information'!C32","v":{"$error":"#DIV/0!"}}]
[null,"Weather File",null,null,null,null,null,"Source EUI (kBtu/sf)",{"$f":"('5b. Usage Summary'!G17*3.412*2.55+'5b. Usage Summary'!H17*100*1.05)/'1,2,3 Information'!C32","v":{"$error":"#DIV/0!"}}]
[null,"Proposed Unmet Load Hours",null,null,null,null,null,"GHG (tCO2e/sf)",{"$f":"'3d. LL97 GHG Summary'!E33/'1,2,3 Information'!C32","v":{"$error":"#DIV/0!"}}]
[null,"Baseline Unmet Load Hours",null,null,null,null,"Baseline","Total Energy Cost ($/sf)",{"$f":"'4. Compliance'!E12/'1,2,3 Information'!C32","v":{"$error":"#VALUE!"}}]
[null,"Gross Square Feet",null,null,null,null,null,"Site EUI (kBtu/sf)",{"$f":"('5b. Usage Summary'!C17*3.412+'5b. Usage Summary'!D17*100)/'1,2,3 Information'!C32","v":{"$error":"#DIV/0!"}}]
[null,"Modeled Square Feet",null,null,null,null,null,"Source EUI (kBtu/sf)",{"$f":"('5b. Usage Summary'!C17*3.412*2.55+'5b. Usage Summary'!D17*100*1.05)/'1,2,3 Information'!C32","v":{"$error":"#DIV/0!"}}]
[null,"Conditioned Square Feet",null,null,null,null,null,"GHG (tCO2e/sf)",{"$f":"SUM('3d. LL97 GHG Summary'!J24:J28)/'1,2,3 Information'!C32","v":{"$error":"#DIV/0!"}}]
[null,"Semi-heated Square Feet",null,null,null,null,"% Savings","Total Energy Cost ($/sf)",{"$f":"(I30-I26)/I30","v":{"$error":"#VALUE!"}}]
[null,"Unconditioned Square Feet",null,null,null,null,null,"Site EUI (kBtu/sf)",{"$f":"(I31-I27)/I31","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,"Source EUI (kBtu/sf)",{"$f":"(I32-I28)/I32","v":{"$error":"#DIV/0!"}}]
["3c","List all Job Numbers Associated with this Model",null,null,null,null,null,"GHG (tCO2e/sf)",{"$f":"(I33-I29)/I33","v":{"$error":"#DIV/0!"}}]

{"sheet":"3d. LL97 GHG Summary","index":7,"n_rows":36,"n_cols":10,"rows_kept":36,"cut":false,"hidden":false,"merged":[[10,7,10,8],[10,3,10,4],[11,7,11,8],[12,7,12,8],[8,3,8,4],[9,5,9,6],[10,5,10,6],[35,2,37,7],[33,4,34,7],[32,4,32,7],[31,6,31,7],[30,6,30,7],[30,4,30,5],[31,4,31,5],[33,2,34,3],[31,2,31,3],[32,2,32,3],[21,6,21,9],[11,5,11,6],[12,5,12,6],[2,0,4,9],[9,3,9,4],[17,3,17,8],[18,5,18,6],[13,7,13,8],[11,3,11,4],[12,3,12,4],[13,3,13,4],[7,2,7,8],[8,5,8,6],[13,5,13,6],[8,7,8,8],[9,7,9,8],[29,2,29,7],[30,2,30,3],[14,3,14,4],[15,3,15,4],[16,3,16,4],[16,5,16,6],[14,7,14,8],[15,7,15,8],[16,7,16,8],[14,5,14,6],[15,5,15,6],[18,7,18,8],[19,5,19,8],[19,2,19,4],[21,2,21,5],[18,2,18,4]]}
[]
[]
["FOR INFORMATIONAL PURPOSES ONLY: NOT REQUIRED FOR ENERGY CODE COMPLIANCE"]
[]
[]
[]
[]
[null,"3d","Carbon Emissions Limit (LL97)"]
[null,null,"Occupancy","Total Gross SQFT per occupancy",null,"tCO2e limit (2024)",null,"tCO2e limit (2030)"]
[null,null,null,null,null,{"$f":"IF(C10=\"\",\"\",VLOOKUP(C10,Lists!A134:B143,2,FALSE))","v":""},null,{"$f":"IF(C10=\"\",\"\",VLOOKUP(C10,Lists!$A$133:$C$143,3,FALSE))","v":""}]
[null,null,null,null,null,{"$f":"IF(C11=\"\",\"\",VLOOKUP(C11,Lists!$A$134:$F$144,2,FALSE))","v":""},null,{"$f":"IF(C11=\"\",\"\",VLOOKUP(C11,Lists!$A$133:$C$143,3,FALSE))","v":""}]
[null,null,null,null,null,{"$f":"IF(C12=\"\",\"\",VLOOKUP(C12,Lists!$A$134:$F$144,2,FALSE))","v":""},null,{"$f":"IF(C12=\"\",\"\",VLOOKUP(C12,Lists!$A$133:$C$143,3,FALSE))","v":""}]
[null,null,null,null,null,{"$f":"IF(C13=\"\",\"\",VLOOKUP(C13,Lists!$A$134:$F$144,2,FALSE))","v":""},null,{"$f":"IF(C13=\"\",\"\",VLOOKUP(C13,Lists!$A$133:$C$143,3,FALSE))","v":""}]
[null,null,null,null,null,{"$f":"IF(C14=\"\",\"\",VLOOKUP(C14,Lists!$A$134:$F$144,2,FALSE))","v":""},null,{"$f":"IF(C14=\"\",\"\",VLOOKUP(C14,Lists!$A$133:$C$143,3,FALSE))","v":""}]
[null,null,null,null,null,{"$f":"IF(C15=\"\",\"\",VLOOKUP(C15,Lists!$A$134:$F$144,2,FALSE))","v":""},null,{"$f":"IF(C15=\"\",\"\",VLOOKUP(C15,Lists!$A$133:$C$143,3,FALSE))","v":""}]
[null,null,null,null,null,{"$f":"IF(C16=\"\",\"\",VLOOKUP(C16,Lists!$A$134:$F$144,2,FALSE))","v":""},null,{"$f":"IF(C16=\"\",\"\",VLOOKUP(C16,Lists!$A$133:$C$143,3,FALSE))","v":""}]
[null,null,null,null,null,{"$f":"IF(C17=\"\",\"\",VLOOKUP(C17,Lists!$A$134:$F$144,2,FALSE))","v":""},null,{"$f":"IF(C17=\"\",\"\",VLOOKUP(C17,Lists!$A$133:$C$143,3,FALSE))","v":""}]
[null,null,"TOTAL",{"$f":"IF(D10=\"\",\"\",IF(SUM(D10:E17)='1,2,3 Information'!C31,SUM(D10:E17),\"Total area does not align with GROSS FLOOR AREA of the building\"))","v":""}]
[null,null,"GHG Building Emission Limits",null,null,{"$f":"SUMPRODUCT(D10:D17,F10:F17)","v":0},null,{"$f":"SUMPRODUCT(D10:D17,H10:H17)","v":0}]
[null,null,"Proposed Building GHG (estimated from model)",null,null,{"$f":"SUM(F24:F28)","v":0}]
[]
[null,"3e","Carbon Emissions Proposed Building (LL97)",null,null,null,"Carbon Emissions Baseline Building (LL97)"]
[null,null,null,"(kBTU)","tCO2e per kBTU","tCO2e",null,"(kBTU)","tCO2e per kBTU","tCO2e"]
[null,null,"Electricity (kwh)",{"$f":"IF('5b. Usage Summary'!$G$17=\"\",\"\",'5b. Usage Summary'!$G$17)","v":0},2.8896199999999998E-4,{"$f":"IF(D24=\"\",\"\",E24*D24)","v":0},"Electricity (kwh)",{"$f":"IF('5b. Usage Summary'!$C$17=\"\",\"\",'5b. Usage Summary'!$C$17)","v":0},2.8896199999999998E-4,{"$f":"IF(H24=\"\",\"\",I24*H24)","v":0}]
[null,null,"Natural Gas",{"$f":"IF('5b. Usage Summary'!$H$17=\"\",\"\",'5b. Usage Summary'!$H$17*100)","v":0},5.3109999999999998E-5,{"$f":"IF(D25=\"\",\"\",E25*D25)","v":0},"Natural Gas",{"$f":"IF('5b. Usage Summary'!$D$17=\"\",\"\",'5b. Usage Summary'!$D$17*100)","v":0},5.3109999999999998E-5,{"$f":"IF(H25=\"\",\"\",I25*H25)","v":0}]
[null,null,"#2 Fuel Oil",null,7.4209999999999996E-5,{"$f":"IF(D26=\"\",\"\",E26*D26)","v":""},"#2 Fuel Oil",null,7.4209999999999996E-5,{"$f":"IF(H26=\"\",\"\",I26*H26)","v":""}]
[null,null,"#4 Fuel Oil",null,7.5290000000000006E-5,{"$f":"IF(D27=\"\",\"\",E27*D27)","v":""},"#4 Fuel Oil",null,7.5290000000000006E-5,{"$f":"IF(H27=\"\",\"\",I27*H27)","v":""}]
[null,null,"District Steam",null,4.4929999999999998E-5,{"$f":"IF(D28=\"\",\"\",E28*D28)","v":""},"District Steam",null,4.4929999999999998E-5,{"$f":"IF(H28=\"\",\"\",I28*H28)","v":""}]
[]
[null,"3e","Carbon Emissions Information (LL97)"]
[null,null,null,null,"tCO2e Limits for 2024-2029",null,"tCO2e Limits for 2030-2034"]
[null,null,"tCO2e Limit (LL97)",null,{"$f":"IF('3d. LL97 GHG Summary'!F19=\"\",\"\",'3d. LL97 GHG Summary'!F19)","v":0},null,{"$f":"IF('3d. LL97 GHG Summary'!H19=\"\",\"\",'3d. LL97 GHG Summary'!H19)","v":0}]
[null,null,"tCO2e for this Building",null,{"$f":"IF('5b. Usage Summary'!G17=\"\",\"\",SUM('3d. LL97 GHG Summary'!F24:F28))","v":0}]
[null,null,"Does this building comply with LL97?",null,{"$f":"IF(E33=\"\",\"\",IF(E33=\"\",\"\",IF(AND(E33<E32,E33<G32),\"This building is subject to meeting LL97 of 2019. The proposed design is estimated to comply with the Carbon Limits for 2024-2029 & 2030-2035.\",IF(AND(E33<E32,E33>G32),\"This building is subject to meeting LL97 of 2019. By 2030, this proposed design may not comply with the requirements of LL97 based on the estimated carbon emissions.\",\"This building is subject to meeting LL97 of 2019. By 2024, this proposed design may not comply with the requirements of LL97 based on the estimated carbon emissions.\"))))","v":"This building is subject to meeting LL97 of 2019. By 2024, this proposed design may not comply with the requirements of LL97 based on the estimated carbon emissions."}]
[]
[null,null,"**Total carbon emissions (tCO2e) for this building is an estimate for informational purposes based on the proposed occupancy, gross square footage, and modeled annual energy usage. The performance of the building will be affected by construction quality, occupancy, and operational impacts.  Actual carbon emissions may be higher or lower than this estimate. **"]

{"sheet":"4. Compliance","index":8,"n_rows":35,"n_cols":9,"rows_kept":35,"cut":false,"hidden":false,"merged":[[34,0,34,1],[23,0,23,1],[22,1,22,2],[22,6,22,8],[23,5,23,7],[24,5,24,7],[24,0,24,1],[26,0,26,1],[31,0,31,1],[32,0,32,1],[33,0,33,1],[29,0,29,1],[2,1,2,3],[17,0,17,1],[18,0,18,1],[20,0,20,1],[19,0,19,1],[16,0,16,1],[14,1,14,3],[11,0,11,1],[5,1,5,8],[6,0,6,1],[7,0,7,1],[8,0,8,1],[14,6,14,8],[16,5,16,6],[3,1,3,3],[9,0,9,1],[10,0,10,6],[15,5,15,6],[27,0,27,1],[30,0,30,1],[28,0,28,1],[18,5,18,6],[25,0,25,1],[27,3,29,3],[17,5,17,6],[19,5,19,6],[20,5,20,6],[15,0,15,1]]}
[]
[]
["4a.","Energy Modeling Protocol (select)"]
[null,"Section 11 ECB"]
[]
["4b.","Purchased Energy Rates & Compliance Documentation"]
["Fuel",null,"Utility Rate Provider/Rate Structure (i.e ConEd)","Virtual Utility Rate ($/unit)","Baseline Design\nTotal Charge ($)","Virtual Utility Rate ($/unit)","Proposed Design Total Charge ($)","Supporting Doc. Location","Model Output Report"]
["Electric",null,null,null,{"$f":"'5a. Baseline Rotations'!O23","v":""}]
["Gas/Steam",null,null,null,{"$f":"'5a. Baseline Rotations'!O24","v":""}]
["Other - ($/kBTU)",null,null,null,{"$f":"'5a. Baseline Rotations'!O25","v":""}]
[null,null,null,null,null,null,null,"COST SAVINGS","COMPLIES?"]
["TOTAL",null,null,null,{"$f":"IF(SUM(E8:E10)=0,\"\",SUM(E8:E10))","v":""},null,{"$f":"IF(SUM(G8:G10)=0,\"\",SUM(G8:G10))","v":""},{"$f":"IF(E12=\"\",\"\",E12-G12)","v":""},{"$f":"IF(E12=\"\",\"\",IF(B4=\"Section 11 ECB\",IF(G12<E12,\"COMPLIES\",\"DOES NOT COMPLY\"),IF(D21<C21,\"COMPLIES\",\"DOES NOT COMPLY\")))","v":""}]
[]
[]
["4c.","Performance Cost Index - Appendix G ONLY",null,null,null,"4d.","Performance Source Energy  Index - Appendix G ONLY"]
[null,null,"Baseline Building","Proposed Building",null,null,null,"Baseline Building","Proposed Building"]
["Building Performance Factor",null,{"$f":"IF(D17=\"\",\"\",IF(D17=\"Weighted Average\",D25,VLOOKUP(D17,Lists!M13:N22,2)))","v":""},null,null,"Building Performance Factor",null,{"$f":"IF(I17=\"\",\"\",IF(I17=\"Weighted Average\",D27,VLOOKUP(I17,Lists!M13:O22,3)))","v":""},{"$f":"IF(D17=\"\",\"\",D17)","v":""}]
["Baseline Regulated Cost",null,{"$f":"IF(B4=\"Section 11 ECB\",\"\",IF(C20=\"\",\"\",C20-C19))","v":""},{"$f":"IF(B4=\"Section 11 ECB\",\"\",IF(D20=\"\",\"\",D20-D19))","v":""},null,"Baseline Regulated Source Energy",null,{"$f":"IF(B4=\"Section 11 ECB\",\"\",IF(I17=\"\",\"\",H20-H19))","v":""},{"$f":"IF(B4=\"Section 11 ECB\",\"\",IF(I17=\"\",\"\",I20-I19))","v":""}]
["Baseline Unregulated Cost",null,{"$f":"('5b. Usage Summary'!$C$7)*D8+('5b. Usage Summary'!$D$7)*D9","v":{"$error":"#VALUE!"}},{"$f":"('5b. Usage Summary'!$G$7)*F8+('5b. Usage Summary'!$H$7)*F9","v":0},null,"Baseline Unregulated Source Energy",null,{"$f":"('5b. Usage Summary'!$C$7)*3.412*2.55+('5b. Usage Summary'!$D$7)*100*1.05","v":{"$error":"#VALUE!"}},{"$f":"('5b. Usage Summary'!$G$7)*3.412*2.55+('5b. Usage Summary'!$H$7)*100*1.05","v":0}]
["Total Energy Cost",null,{"$f":"IF(B4=\"Section 11 ECB\",\"\",E12)","v":""},{"$f":"IF(B4=\"Section 11 ECB\",\"\",G12)","v":""},null,"Total Source Energy",null,{"$f":"IF(B4=\"Section 11 ECB\",\"\",IF(I17=\"\",\"\",SUM('5b. Usage Summary'!C17*3.412*2.55,'5b. Usage Summary'!D17*100*1.05)))","v":""},{"$f":"IF(B4=\"Section 11 ECB\",\"\",IF(I17=\"\",\"\",SUM('5b. Usage Summary'!G17*3.412*2.55,'5b. Usage Summary'!H17*100*1.05)))","v":""}]
["Performance Cost Index",null,{"$f":"IF(C20=\"\",\"\",(C19+(C18*C17))/C20)","v":""},{"$f":"IF(D20=\"\",\"\",D20/C20)","v":""},null,"Performance Source Energy Index",null,{"$f":"IF(H20=\"\",\"\",(H19+(H18*H17))/H20)","v":""},{"$f":"IF(I20=\"\",\"\",I20/H20)","v":""}]
[]
["4e.","Weighted BPF",null,null,null,"4f.","Weighted Envelope Backstop (results from ComCheck)"]
["Space Classification",null,"Modeled Area","Weighted BPF (energy cost)",null,"Allowable Margin (baseline)"]
["All Other",null,null,{"$f":"IF(AND(D17=\"Weighted Average\",SUM(C25:C34)<>0),SUMPRODUCT(C25:C34,Lists!N13:N22)/SUM(C25:C34),\"Input modeled areas for each space classification\")","v":"Input modeled areas for each space classification"},null,"Envelope Design (proposed)"]
["Dormitory",null,null,"Weighted BPF (source energy)"]
["Healthcare/\nhospital",null,null,{"$f":"IF(AND(I17=\"Weighted Average\",SUM(C25:C34)<>0),SUMPRODUCT(C25:C34,Lists!O13:O22)/SUM(C25:C34),\"Input modeled areas for each space classification\")","v":"Input modeled areas for each space classification"}]
["Hotel/motel"]
["Multifamily",null,7000]
["Office"]
["Restaurant"]
["Retail"]
["School"]
["Warehouse"]
["TOTAL",null,{"$f":"IF(SUM(C25:C34)<>'1,2,3 Information'!C32,\"NOT EQUAL TO MODELED AREA\",SUM(C25:C34))","v":"NOT EQUAL TO MODELED AREA"}]

{"sheet":"5a. Baseline Rotations","index":9,"n_rows":26,"n_cols":18,"rows_kept":26,"cut":false,"hidden":false,"merged":[[29,0,46,17],[25,8,25,10],[22,11,22,13],[23,11,23,13],[24,11,24,13],[25,11,25,13],[23,8,23,10],[24,8,24,10],[22,14,22,16],[23,14,23,16],[24,14,24,16],[25,14,25,16],[22,2,22,4],[22,8,22,10],[25,0,25,1],[22,0,22,1],[1,0,2,17],[16,0,16,1],[17,0,17,1],[18,0,18,1],[20,0,20,17],[19,0,19,1],[15,0,15,1],[10,0,10,1],[3,1,3,17],[5,0,5,1],[8,0,8,1],[6,0,6,17],[4,0,4,17],[5,2,5,4],[5,5,5,7],[5,8,5,10],[5,11,5,13],[5,14,5,16],[9,0,9,1],[11,0,11,1],[12,0,12,1],[22,5,22,7],[23,5,23,7],[24,5,24,7],[25,5,25,7],[23,2,23,4],[24,2,24,4],[23,0,23,1],[24,0,24,1],[13,0,13,1],[14,0,14,1],[25,2,25,4]]}
[]
["INSTRUCTIONS:  If the modeling parameters call for averaging 4 rotations, enter the data into each of the white columns.  If the modeling protocol does not require averaging the 4 rotations, enter the data into only the column labeled \"0'\" (do not enter '0' into the columns labeled 90, 180, 270)."]
[]
["5a","Baseline Rotations "]
["Baseline Model"]
[null,null,"0'",null,null,"90'",null,null,"180'",null,null,"270'",null,null,"Average of 4 rotations",null,null,"Model Output Location (Report)"]
["Annual usage (kwh/therm/kBTU)"]
[null,null,"kwh","therm","kBTU","kwh","therm","kBTU","kwh","therm","kBTU","kwh","therm","kBTU","kwh","therm","kBTU"]
["Interior Lighting",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C9=\"\",\"\",IF(F9=0,C9,AVERAGE(C9,F9,I9,L9)))","v":""},{"$f":"IF(D9=\"\",\"\",IF(G9=0,D9,AVERAGE(D9,G9,J9,M9)))","v":""},{"$f":"IF(E9=\"\",\"\",IF(H9=0,E9,AVERAGE(E9,H9,K9,N9)))","v":""}]
["Misc. Equip. Unregulated",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C10=\"\",\"\",IF(F10=0,C10,AVERAGE(C10,F10,I10,L10)))","v":""},{"$f":"IF(D10=\"\",\"\",IF(G10=0,D10,AVERAGE(D10,G10,J10,M10)))","v":""},{"$f":"IF(E10=\"\",\"\",IF(H10=0,E10,AVERAGE(E10,H10,K10,N10)))","v":""}]
["Misc. Equip. Regulated",null,null,null,null,null,null,null,null,null,null,null,null,null,"","",""]
["Space Heat",null,null,null,null,null,null,null,null,null,null,null,null,null,"","",""]
["Space Cool",null,null,null,null,null,null,null,null,null,null,null,null,null,"","",""]
["Heat Rejection",null,null,null,null,null,null,null,null,null,null,null,null,null,"","",""]
["Pumps & Misc",null,null,null,null,null,null,null,null,null,null,null,null,null,"","",""]
["Vent Fans",null,null,null,null,null,null,null,null,null,null,null,null,null,"","",""]
["Dom. Hot Water",null,null,null,null,null,null,null,null,null,null,null,null,null,"","",""]
["Exterior Lighting",null,null,null,null,null,null,null,null,null,null,null,null,null,"","",""]
["Exterior Misc.",null,null,null,null,null,null,null,null,null,null,null,null,null,"","",""]
["TOTAL",null,{"$f":"IF(SUM(C9:C19)=0,\"\",SUM(C9:C19))","v":""},{"$f":"IF(SUM(D9:D19)=0,\"\",SUM(D9:D19))","v":""},"","","","","","","","","","","","",""]
["Annual cost ($)"]
[]
["Electric",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C23=\"\",\"\",IF(F23=\"\",C23,AVERAGE(C23:M23)))","v":""}]
["Gas/Steam",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C24=\"\",\"\",IF(F24=\"\",C24,AVERAGE(C24:M24)))","v":""}]
["Other",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C25=\"\",\"\",IF(F25=\"\",C25,AVERAGE(C25:M25)))","v":""}]
["TOTAL",null,{"$f":"IF(C23=\"\",\"\",SUM(C23:D25))","v":""},null,null,{"$f":"IF(F23=\"\",\"\",SUM(F23:G25))","v":""},null,null,{"$f":"IF(I23=\"\",\"\",SUM(I23:J25))","v":""},null,null,{"$f":"IF(L23=\"\",\"\",SUM(L23:M25))","v":""},null,null,{"$f":"IF(O23=\"\",\"\",SUM(O23:P25))","v":""}]

{"sheet":"5b. Usage Summary","index":10,"n_rows":46,"n_cols":13,"rows_kept":46,"cut":false,"hidden":false,"merged":[[45,7,47,7],[45,8,47,12],[21,8,23,12],[24,8,26,12],[27,8,29,12],[30,8,32,12],[33,8,35,12],[36,8,38,12],[39,8,41,12],[42,8,44,12],[42,7,44,7],[42,0,44,1],[42,2,44,6],[45,0,47,1],[45,2,47,6],[21,7,23,7],[24,7,26,7],[27,7,29,7],[21,0,23,1],[21,2,23,6],[24,0,26,1],[24,2,26,6],[27,0,29,1],[27,2,29,6],[30,0,32,1],[30,2,32,6],[33,0,35,1],[36,0,38,1],[36,2,38,6],[39,0,41,1],[39,2,41,6],[30,7,32,7],[33,7,35,7],[36,7,38,7],[39,7,41,7],[7,0,7,1],[18,1,18,12],[19,0,20,6],[19,7,20,12],[3,2,3,5],[3,6,3,9],[1,1,1,12],[3,10,3,12],[16,0,16,1],[3,0,3,1],[15,0,15,1],[4,0,4,1],[13,0,13,1],[5,0,5,1],[6,0,6,1],[8,0,8,1],[9,0,9,1],[10,0,10,1],[2,0,2,12],[11,0,11,1],[12,0,12,1],[14,0,14,1]]}
[]
["5b","Energy Modeling Usage Summary"]
[{"$f":"CONCATENATE(\"Compliance based on \",IF(Path=\"\",\"\",Path))","v":"Compliance based on Section 11 ECB"}]
[null,null,"Baseline Model",null,null,null,"Proposed Model"]
[null,null,"Electric Usage (kwh)","Gas/Steam Usage (Therm)","Other (i.e. chilled water) (kBTU)","% Usage","Electric Usage (kwh)","Gas/Steam Usage (Therm)","Other (i.e. chilled water) (kBTU)","% Usage","Energy Savings Per End Use (%)","Cost Savings per End Use (%)","Model Output Location (Report)"]
["Interior Lighting",null,{"$f":"IF('5a. Baseline Rotations'!O9=\"\",\"\",'5a. Baseline Rotations'!O9)","v":""},{"$f":"IF('5a. Baseline Rotations'!P9=\"\",\"\",'5a. Baseline Rotations'!P9)","v":""},{"$f":"IF('5a. Baseline Rotations'!Q9=\"\",\"\",'5a. Baseline Rotations'!Q9)","v":""},{"$f":"IF(C6=\"\",\"\",(C6*3.412+D6*100+E6)/($C$17*3.412+$D$17*100+$E$17))","v":""},null,null,null,{"$f":"IF(G6=\"\",\"\",(G6*3.412+H6*100+I6)/($G$17*3.412+$H$17*100+$I$17))","v":""},{"$f":"IF(AND(C6=\"\",D6=\"\"),\"\",((C6-G6)*3.412+(D6-H6)*100+(E6-I6))/(($C$17-$G$17)*3.412+($D$17-$H$17)*100+($E$17-$I$17)))","v":""},{"$f":"IF(AND(C6=\"\",D6=\"\"),\"\",(($C6-$G6)*'4. Compliance'!$F$8+($D6-$H6)*'4. Compliance'!$F$9+($E6-$I6)*'4. Compliance'!$F$10)/(($C$17-$G$17)*'4. Compliance'!$F$8+($D$17-$H$17)*'4. Compliance'!$F$9+($E$17-$I$17)*'4. Compliance'!$F$10))","v":""}]
["Misc. Equip. Unregulated",null,{"$f":"IF('5a. Baseline Rotations'!O10=\"\",\"\",'5a. Baseline Rotations'!O10)","v":""},{"$f":"IF('5a. Baseline Rotations'!P10=\"\",\"\",'5a. Baseline Rotations'!P10)","v":""},{"$f":"IF('5a. Baseline Rotations'!Q10=\"\",\"\",'5a. Baseline Rotations'!Q10)","v":""},{"$f":"IF(C7=\"\",\"\",(C7*3.412+D7*100+E7)/($C$17*3.412+$D$17*100+$E$17))","v":""},null,null,null,{"$f":"IF(G7=\"\",\"\",(G7*3.412+H7*100+I7)/($G$17*3.412+$H$17*100+$I$17))","v":""},{"$f":"IF(AND(C7=\"\",D7=\"\"),\"\",((C7-G7)*3.412+(D7-H7)*100+(E7-I7))/(($C$17-$G$17)*3.412+($D$17-$H$17)*100+($E$17-$I$17)))","v":""},{"$f":"IF(AND(C7=\"\",D7=\"\"),\"\",(($C7-$G7)*'4. Compliance'!$F$8+($D7-$H7)*'4. Compliance'!$F$9+($E7-$I7)*'4. Compliance'!$F$10)/(($C$17-$G$17)*'4. Compliance'!$F$8+($D$17-$H$17)*'4. Compliance'!$F$9+($E$17-$I$17)*'4. Compliance'!$F$10))","v":""}]
["Misc. Equip. Regulated",null,{"$f":"IF('5a. Baseline Rotations'!O11=\"\",\"\",'5a. Baseline Rotations'!O11)","v":""},{"$f":"IF('5a. Baseline Rotations'!P11=\"\",\"\",'5a. Baseline Rotations'!P11)","v":""},{"$f":"IF('5a. Baseline Rotations'!Q11=\"\",\"\",'5a. Baseline Rotations'!Q11)","v":""},"",null,null,null,"","",{"$f":"IF(AND(C8=\"\",D8=\"\"),\"\",(($C8-$G8)*'4. Compliance'!$F$8+($D8-$H8)*'4. Compliance'!$F$9+($E8-$I8)*'4. Compliance'!$F$10)/(($C$17-$G$17)*'4. Compliance'!$F$8+($D$17-$H$17)*'4. Compliance'!$F$9+($E$17-$I$17)*'4. Compliance'!$F$10))","v":""}]
["Space Heat",null,{"$f":"IF('5a. Baseline Rotations'!O12=\"\",\"\",'5a. Baseline Rotations'!O12)","v":""},{"$f":"IF('5a. Baseline Rotations'!P12=\"\",\"\",'5a. Baseline Rotations'!P12)","v":""},{"$f":"IF('5a. Baseline Rotations'!Q12=\"\",\"\",'5a. Baseline Rotations'!Q12)","v":""},"",null,null,null,"","",{"$f":"IF(AND(C9=\"\",D9=\"\"),\"\",(($C9-$G9)*'4. Compliance'!$F$8+($D9-$H9)*'4. Compliance'!$F$9+($E9-$I9)*'4. Compliance'!$F$10)/(($C$17-$G$17)*'4. Compliance'!$F$8+($D$17-$H$17)*'4. Compliance'!$F$9+($E$17-$I$17)*'4. Compliance'!$F$10))","v":""}]
["Space Cool",null,{"$f":"IF('5a. Baseline Rotations'!O13=\"\",\"\",'5a. Baseline Rotations'!O13)","v":""},{"$f":"IF('5a. Baseline Rotations'!P13=\"\",\"\",'5a. Baseline Rotations'!P13)","v":""},{"$f":"IF('5a. Baseline Rotations'!Q13=\"\",\"\",'5a. Baseline Rotations'!Q13)","v":""},"",null,null,null,"","",{"$f":"IF(AND(C10=\"\",D10=\"\"),\"\",(($C10-$G10)*'4. Compliance'!$F$8+($D10-$H10)*'4. Compliance'!$F$9+($E10-$I10)*'4. Compliance'!$F$10)/(($C$17-$G$17)*'4. Compliance'!$F$8+($D$17-$H$17)*'4. Compliance'!$F$9+($E$17-$I$17)*'4. Compliance'!$F$10))","v":""}]
["Heat Rejection",null,{"$f":"IF('5a. Baseline Rotations'!O14=\"\",\"\",'5a. Baseline Rotations'!O14)","v":""},{"$f":"IF('5a. Baseline Rotations'!P14=\"\",\"\",'5a. Baseline Rotations'!P14)","v":""},{"$f":"IF('5a. Baseline Rotations'!Q14=\"\",\"\",'5a. Baseline Rotations'!Q14)","v":""},"",null,null,null,"","",{"$f":"IF(AND(C11=\"\",D11=\"\"),\"\",(($C11-$G11)*'4. Compliance'!$F$8+($D11-$H11)*'4. Compliance'!$F$9+($E11-$I11)*'4. Compliance'!$F$10)/(($C$17-$G$17)*'4. Compliance'!$F$8+($D$17-$H$17)*'4. Compliance'!$F$9+($E$17-$I$17)*'4. Compliance'!$F$10))","v":""}]
["Pumps & Misc",null,{"$f":"IF('5a. Baseline Rotations'!O15=\"\",\"\",'5a. Baseline Rotations'!O15)","v":""},{"$f":"IF('5a. Baseline Rotations'!P15=\"\",\"\",'5a. Baseline Rotations'!P15)","v":""},{"$f":"IF('5a. Baseline Rotations'!Q15=\"\",\"\",'5a. Baseline Rotations'!Q15)","v":""},"",null,null,null,"","",{"$f":"IF(AND(C12=\"\",D12=\"\"),\"\",(($C12-$G12)*'4. Compliance'!$F$8+($D12-$H12)*'4. Compliance'!$F$9+($E12-$I12)*'4. Compliance'!$F$10)/(($C$17-$G$17)*'4. Compliance'!$F$8+($D$17-$H$17)*'4. Compliance'!$F$9+($E$17-$I$17)*'4. Compliance'!$F$10))","v":""}]
["Vent Fans",null,{"$f":"IF('5a. Baseline Rotations'!O16=\"\",\"\",'5a. Baseline Rotations'!O16)","v":""},{"$f":"IF('5a. Baseline Rotations'!P16=\"\",\"\",'5a. Baseline Rotations'!P16)","v":""},{"$f":"IF('5a. Baseline Rotations'!Q16=\"\",\"\",'5a. Baseline Rotations'!Q16)","v":""},"",null,null,null,"","",{"$f":"IF(AND(C13=\"\",D13=\"\"),\"\",(($C13-$G13)*'4. Compliance'!$F$8+($D13-$H13)*'4. Compliance'!$F$9+($E13-$I13)*'4. Compliance'!$F$10)/(($C$17-$G$17)*'4. Compliance'!$F$8+($D$17-$H$17)*'4. Compliance'!$F$9+($E$17-$I$17)*'4. Compliance'!$F$10))","v":""}]
["Dom. Hot Water",null,{"$f":"IF('5a. Baseline Rotations'!O17=\"\",\"\",'5a. Baseline Rotations'!O17)","v":""},{"$f":"IF('5a. Baseline Rotations'!P17=\"\",\"\",'5a. Baseline Rotations'!P17)","v":""},{"$f":"IF('5a. Baseline Rotations'!Q17=\"\",\"\",'5a. Baseline Rotations'!Q17)","v":""},"",null,null,null,"","",{"$f":"IF(AND(C14=\"\",D14=\"\"),\"\",(($C14-$G14)*'4. Compliance'!$F$8+($D14-$H14)*'4. Compliance'!$F$9+($E14-$I14)*'4. Compliance'!$F$10)/(($C$17-$G$17)*'4. Compliance'!$F$8+($D$17-$H$17)*'4. Compliance'!$F$9+($E$17-$I$17)*'4. Compliance'!$F$10))","v":""}]
["Exterior Lighting",null,{"$f":"IF('5a. Baseline Rotations'!O18=\"\",\"\",'5a. Baseline Rotations'!O18)","v":""},{"$f":"IF('5a. Baseline Rotations'!P18=\"\",\"\",'5a. Baseline Rotations'!P18)","v":""},{"$f":"IF('5a. Baseline Rotations'!Q18=\"\",\"\",'5a. Baseline Rotations'!Q18)","v":""},"",null,null,null,"","",{"$f":"IF(AND(C15=\"\",D15=\"\"),\"\",(($C15-$G15)*'4. Compliance'!$F$8+($D15-$H15)*'4. Compliance'!$F$9+($E15-$I15)*'4. Compliance'!$F$10)/(($C$17-$G$17)*'4. Compliance'!$F$8+($D$17-$H$17)*'4. Compliance'!$F$9+($E$17-$I$17)*'4. Compliance'!$F$10))","v":""}]
["Exterior Misc.",null,{"$f":"IF('5a. Baseline Rotations'!O19=\"\",\"\",'5a. Baseline Rotations'!O19)","v":""},{"$f":"IF('5a. Baseline Rotations'!P19=\"\",\"\",'5a. Baseline Rotations'!P19)","v":""},{"$f":"IF('5a. Baseline Rotations'!Q19=\"\",\"\",'5a. Baseline Rotations'!Q19)","v":""},"",null,null,null,"","",{"$f":"IF(AND(C16=\"\",D16=\"\"),\"\",(($C16-$G16)*'4. Compliance'!$F$8+($D16-$H16)*'4. Compliance'!$F$9+($E16-$I16)*'4. Compliance'!$F$10)/(($C$17-$G$17)*'4. Compliance'!$F$8+($D$17-$H$17)*'4. Compliance'!$F$9+($E$17-$I$17)*'4. Compliance'!$F$10))","v":""}]
["TOTAL",null,{"$f":"IF(SUM(C6:C16)=0,0,SUM(C6:C16))","v":0},{"$f":"IF(SUM(D6:D16)=0,0,SUM(D6:D16))","v":0},{"$f":"IF(SUM(E6:E16)=0,0,SUM(E6:E16))","v":0},{"$f":"IF(SUM(F6:F16)=0,0,SUM(F6:F16))","v":0},{"$f":"IF(SUM(G6:G16)=0,0,SUM(G6:G16))","v":0},{"$f":"IF(SUM(H6:H16)=0,0,SUM(H7:H16))","v":0},{"$f":"IF(SUM(I6:I16)=0,0,SUM(I7:I16))","v":0},{"$f":"SUM(J6:J16)","v":0},{"$f":"SUM(K6:K16)","v":0},{"$f":"SUM(L6:L16)","v":0}]
[]
["5c","Energy Related Design Features"]
["List energy related features in the design that exceed the mandatory/prescriptive requirements under each category.",null,null,null,null,null,null,"List energy related features in the design that do not meet the prescriptive requirements under each category."]
[]
["Opaque Envelope",null,null,null,null,null,null,"Opaque Envelope"]
[]
[]
["Fenestration & WWR",null,null,null,null,null,null,"Fenestration & WWR"]
[]
[]
["Ventilation Systems",null,null,null,null,null,null,"Ventilation Systems"]
[]
[]
["Cooling Systems",null,null,null,null,null,null,"Cooling Systems"]
[]
[]
["Heating Systems",null,null,null,null,null,null,"Heating Systems"]
[]
[]
["Service Water Heating",null,null,null,null,null,null,"Service Water Heating"]
[]
[]
["Lighting Power",null,null,null,null,null,null,"Lighting Power"]
[]
[]
["Lighting Controls",null,null,null,null,null,null,"Lighting Controls"]
[]
[]
["Other",null,null,null,null,null,null,"Other"]

{"sheet":"5a. Description of Project","index":11,"n_rows":20,"n_cols":11,"rows_kept":20,"cut":false,"hidden":true,"merged":[[19,0,44,10],[12,0,12,1],[13,0,13,1],[14,0,14,1],[15,0,15,1],[16,6,16,8],[18,1,18,10],[11,0,11,1],[2,1,2,10],[3,0,3,1],[3,2,3,4],[3,5,3,9],[4,0,4,1],[5,0,5,1],[6,0,6,1],[7,0,7,1],[8,0,8,1],[9,0,9,1],[10,0,10,1]]}
[]
[]
[5,"Energy Modeling Usage Summary"]
[null,null,"Baseline Model",null,null,"Proposed Model"]
[null,null,"Electric Usage (kwh)","Gas/Steam Usage (Therm)","Other Usage (i.e. chilled water)\n(indicate units)","Electric Usage (kwh)","Gas/Steam Usage (Therm)","Other Usage (i.e. chilled water)\n(indicate units)","Energy Savings Per End Use (%)","Cost Savings per End Use (%)","Model Output Location (Report)"]
["Interior Lighting",null,1745801.25,0,0,1556051,null,null,{"$f":"IF(AND(C6=\"\",D6=\"\"),\"\",((C6-F6)*0.0341214+(D6-G6))/(($C$16-$F$16)*0.0341214+($D$16-$G$16)))","v":0.17052565521478644},{"$f":"IF(AND(C6=\"\",D6=\"\"),\"\",(($C6-$F6)*'4. Compliance'!$F$8+($D6-$G6)*'4. Compliance'!$F$9)/(($C$16-$F$16)*'4. Compliance'!$F$8+($D$16-$G$16)*'4. Compliance'!$F$9))","v":{"$error":"#DIV/0!"}},"BEPU"]
["Misc. Equip.",null,1392190,0,0,1392190,null,null,{"$f":"IF(AND(C7=\"\",D7=\"\"),\"\",((C7-F7)*0.00341214+(D7-G7)*0.1)/(($C$16-$F$16)*0.00341214+($D$16-$G$16)*0.1))","v":0},{"$f":"IF(AND(C7=\"\",D7=\"\"),\"\",(($C7-$F7)*'4. Compliance'!$F$8+($D7-$G7)*'4. Compliance'!$F$9)/(($C$16-$F$16)*'4. Compliance'!$F$8+($D$16-$G$16)*'4. Compliance'!$F$9))","v":{"$error":"#DIV/0!"}},"BEPU"]
["Space Heat",null,531458.5,109038,0,368529,126064,null,{"$f":"IF(AND(C8=\"\",D8=\"\"),\"\",((C8-F8)*0.0341214+(D8-G8))/(($C$16-$F$16)*0.0341214+($D$16-$G$16)))","v":-0.30200619282574098},{"$f":"IF(AND(C8=\"\",D8=\"\"),\"\",(($C8-$F8)*'4. Compliance'!$F$8+($D8-$G8)*'4. Compliance'!$F$9)/(($C$16-$F$16)*'4. Compliance'!$F$8+($D$16-$G$16)*'4. Compliance'!$F$9))","v":{"$error":"#DIV/0!"}},"BEPU"]
["Space Cool",null,1303419.25,0,0,1113250,null,null,{"$f":"IF(AND(C9=\"\",D9=\"\"),\"\",((C9-F9)*0.0341214+(D9-G9))/(($C$16-$F$16)*0.0341214+($D$16-$G$16)))","v":0.17090220412333856},{"$f":"IF(AND(C9=\"\",D9=\"\"),\"\",(($C9-$F9)*'4. Compliance'!$F$8+($D9-$G9)*'4. Compliance'!$F$9)/(($C$16-$F$16)*'4. Compliance'!$F$8+($D$16-$G$16)*'4. Compliance'!$F$9))","v":{"$error":"#DIV/0!"}},"BEPU"]
["Heat Rejection",null,35071.5,0,0,8053,null,null,{"$f":"IF(AND(C10=\"\",D10=\"\"),\"\",((C10-F10)*0.0341214+(D10-G10))/(($C$16-$F$16)*0.0341214+($D$16-$G$16)))","v":2.4281113808391333E-2},{"$f":"IF(AND(C10=\"\",D10=\"\"),\"\",(($C10-$F10)*'4. Compliance'!$F$8+($D10-$G10)*'4. Compliance'!$F$9)/(($C$16-$F$16)*'4. Compliance'!$F$8+($D$16-$G$16)*'4. Compliance'!$F$9))","v":{"$error":"#DIV/0!"}},"BEPU"]
["Pumps & Misc",null,757739,0,0,510815,null,null,0.22190683220842092,{"$f":"IF(AND(C11=\"\",D11=\"\"),\"\",(($C11-$F11)*'4. Compliance'!$F$8+($D11-$G11)*'4. Compliance'!$F$9)/(($C$16-$F$16)*'4. Compliance'!$F$8+($D$16-$G$16)*'4. Compliance'!$F$9))","v":{"$error":"#DIV/0!"}},"BEPU"]
["Vent Fans",null,1224198.25,0,0,1262322,null,null,-3.426123258332843E-2,{"$f":"IF(AND(C12=\"\",D12=\"\"),\"\",(($C12-$F12)*'4. Compliance'!$F$8+($D12-$G12)*'4. Compliance'!$F$9)/(($C$16-$F$16)*'4. Compliance'!$F$8+($D$16-$G$16)*'4. Compliance'!$F$9))","v":{"$error":"#DIV/0!"}},"BEPU"]
["Dom. Hot Water",null,0,214343,0,null,186222,null,0.74064703502197471,{"$f":"IF(AND(C13=\"\",D13=\"\"),\"\",(($C13-$F13)*'4. Compliance'!$F$8+($D13-$G13)*'4. Compliance'!$F$9)/(($C$16-$F$16)*'4. Compliance'!$F$8+($D$16-$G$16)*'4. Compliance'!$F$9))","v":{"$error":"#DIV/0!"}},"BEPU"]
["Exterior Lighting",null,33575,0,0,24668,null,null,8.0045850321572836E-3,{"$f":"IF(AND(C14=\"\",D14=\"\"),\"\",(($C14-$F14)*'4. Compliance'!$F$8+($D14-$G14)*'4. Compliance'!$F$9)/(($C$16-$F$16)*'4. Compliance'!$F$8+($D$16-$G$16)*'4. Compliance'!$F$9))","v":{"$error":"#DIV/0!"}},"BEPU"]
["Exterior Misc.",null,0,0,0,0,0,null,0,{"$f":"IF(AND(C15=\"\",D15=\"\"),\"\",(($C15-$F15)*'4. Compliance'!$F$8+($D15-$G15)*'4. Compliance'!$F$9)/(($C$16-$F$16)*'4. Compliance'!$F$8+($D$16-$G$16)*'4. Compliance'!$F$9))","v":{"$error":"#DIV/0!"}},"BEPU"]
["TOTAL",null,{"$f":"IF(SUM(C6:C15)=0,\"\",SUM(C6:C15))","v":7023452.75},323381,"",{"$f":"IF(SUM(F6:F15)=0,\"\",SUM(F6:F15))","v":6235878},{"$f":"IF(SUM(G7:G15)=0,\"\",SUM(G7:G15))","v":312286},"",1,{"$f":"IF(AND(C16=\"\",D16=\"\"),\"\",(($C16-$F16)*'4. Compliance'!$F$8+($D16-$G16)*'4. Compliance'!$F$9)/(($C$16-$F$16)*'4. Compliance'!$F$8+($D$16-$G$16)*'4. Compliance'!$F$9))","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,{"$f":"IF(J17=\"\",\"\",IF(J17='4. Compliance'!E12-'4. Compliance'!G12,\"Aligns with Section 4\",\"Does Not Align with Section 4\"))","v":{"$error":"#VALUE!"}},null,null,{"$f":"($C$16-$F$16)*'4. Compliance'!$F$8+($D$16-$G$16)*'4. Compliance'!$F$9","v":0}]
[]
["5a","Energy Related Design Features"]
["List energy related features that are included in the design and contribute to the energy savings in Section 5."]

{"sheet":"6a. Ext. Wall Areas","index":12,"n_rows":16,"n_cols":12,"rows_kept":16,"cut":false,"hidden":false,"merged":[[6,5,6,6],[8,2,8,3],[9,2,9,3],[13,10,14,10],[13,11,14,11],[13,0,15,1],[15,2,15,3],[13,8,13,9],[13,2,14,4],[13,5,13,6],[13,7,14,7],[2,1,2,11],[4,10,7,10],[4,11,7,11],[4,4,4,6],[6,0,12,1],[5,4,5,6],[4,7,5,9],[6,8,6,9],[6,7,7,7],[10,2,10,3],[11,2,11,3],[12,2,12,3],[6,2,7,3],[6,4,7,4],[4,0,5,3],[3,0,3,11]]}
[]
[]
["6a ","Above-Grade Wall & Fenestration Areas"]
[{"$f":"CONCATENATE(\"Compliance based on \",IF(Path=\"\",\"\",Path))","v":"Compliance based on Section 11 ECB"}]
[null,null,null,null,"Baseline Case",null,null,"Proposed Case",null,null,"Supporting Doc. Location","Model Output Report"]
[null,null,null,null,"Other"]
["Above-Grade Wall & Vertical Glazing Area by Orientation",null,"Orientation",null,"Window + Wall Area (ft2)","Vertical Glazing Area",null,"Window + Wall Area (ft2)","Vertical Glazing Area"]
[null,null,null,null,null,"(ft2)","(%)",null,"(ft2)","(%)"]
[null,null,"North",null,null,null,{"$f":"IF(AND(E9=\"\",F9=\"\"),\"\",F9/E9*100)","v":""},null,null,{"$f":"IF(AND(H9=\"\",I9=\"\"),\"\",I9/H9*100)","v":""},"EN-002","LV-D"]
[null,null,"East",null,null,null,{"$f":"IF(AND(E10=\"\",F10=\"\"),\"\",F10/E10*100)","v":""},null,null,{"$f":"IF(AND(H10=\"\",I10=\"\"),\"\",I10/H10*100)","v":""},"EN-002","LV-D"]
[null,null,"South",null,null,null,{"$f":"IF(AND(E11=\"\",F11=\"\"),\"\",F11/E11*100)","v":""},null,null,{"$f":"IF(AND(H11=\"\",I11=\"\"),\"\",I11/H11*100)","v":""},"EN-002","LV-D"]
[null,null,"West",null,null,null,{"$f":"IF(AND(E12=\"\",F12=\"\"),\"\",F12/E12*100)","v":""},null,null,{"$f":"IF(AND(H12=\"\",I12=\"\"),\"\",I12/H12*100)","v":""},"EN-002","LV-D"]
[null,null,"Total",null,{"$f":"IF(SUM(E9:E12)=0,\"\",SUM(E9:E12))","v":""},{"$f":"IF(SUM(F9:F12)=0,\"\",SUM(F9:F12))","v":""},{"$f":"IF(AND(E13=\"\",F13=\"\"),\"\",F13/E13*100)","v":""},{"$f":"IF(SUM(H9:H12)=0,\"\",SUM(H9:H12))","v":""},{"$f":"IF(SUM(I9:I12)=0,\"\",SUM(I9:I12))","v":""},{"$f":"IF(AND(H13=\"\",I13=\"\"),\"\",I13/H13*100)","v":""},"EN-002","LV-D"]
["Roof & Skylight Area",null,"Roof + Skylight Area (ft2)",null,null,"Skylight Area",null,"Roof + Skylight Area (ft2)","Skylight Area",null,"Supporting Doc. Location","Model Output Report"]
[null,null,null,null,null,"(ft2)","(%)",null,"(ft2)","(%)"]
[null,null,"Total",null,null,null,{"$f":"IF(AND(E16=\"\",F16=\"\"),\"\",F16/E16*100)","v":""},null,null,{"$f":"IF(AND(H16=\"\",I16=\"\"),\"\",I16/H16*100)","v":""}]

{"sheet":"6b. Fenestration","index":13,"n_rows":22,"n_cols":15,"rows_kept":22,"cut":false,"hidden":false,"merged":[[20,0,21,2],[20,13,21,13],[20,14,21,14],[20,3,20,5],[20,6,20,7],[21,3,21,5],[21,6,21,7],[20,8,21,10],[2,1,2,14],[6,0,6,1],[7,0,7,1],[8,0,8,1],[9,0,9,1],[3,0,3,14],[4,8,4,12],[17,0,17,1],[18,0,18,1],[19,0,19,1],[4,13,5,13],[4,14,5,14],[11,0,11,1],[4,0,5,1],[4,2,5,2],[4,4,4,7],[10,0,10,1],[12,0,12,1],[13,0,13,1],[14,0,14,1],[15,0,15,1],[16,0,16,1]]}
[]
[]
["6b","Vertical Fenestration"]
[{"$f":"CONCATENATE(\"Compliance based on \",IF(Path=\"\",\"\",Path))","v":"Compliance based on Section 11 ECB"}]
["Model Input Parameter",null,"Category (Res/Non-Res)",null,"Baseline Case",null,null,null,"Proposed Case",null,null,null,null,"Supporting Doc. Location","Model Output Report"]
[null,null,null,"Item #","Description\n(from ASHRAE)","U-factor","SHGC","VLT","Description (from design)","U-factor","SHGC","VLT","% Overall Wall/Roof Area"]
["Vertical  ",null,null,1,null,{"$f":"IF(C7=\"\",\"\",IF(E7=\"\",\"\",IF('4. Compliance'!$B$4=\"Section 11 ECB\",INDEX(Lists!$A$4:$D$11,(MATCH($E7,Lists!$A$4:$A$11,0)),(MATCH($C7,Lists!$A$4:$D$4,0))),INDEX(Lists!$F$4:$I$11,(MATCH($E7,Lists!$F$4:$F$11,0)),(MATCH($C7,Lists!$F$4:$I$4,0))))))","v":""},{"$f":"IF(C7=\"\",\"\",IF(E7=\"\",\"\",IF('4. Compliance'!$B$4=\"Section 11 ECB\",INDEX(Lists!$A$13:$D$20,(MATCH($E7,Lists!$A$13:$A$20,0)),(MATCH($C7,Lists!$A$13:$D$13,0))),INDEX(Lists!$F$13:$I$20,(MATCH($E7,Lists!$F$13:$F$20,0)),(MATCH($C7,Lists!$F$13:$I$13,0))))))","v":""},{"$f":"IF(L7=\"\",\"\",L7)","v":""}]
["Vertical  ",null,null,2,null,{"$f":"IF(C8=\"\",\"\",IF(E8=\"\",\"\",IF('4. Compliance'!$B$4=\"Section 11 ECB\",INDEX(Lists!$A$4:$D$11,(MATCH($E8,Lists!$A$4:$A$11,0)),(MATCH($C8,Lists!$A$4:$D$4,0))),INDEX(Lists!$F$4:$I$11,(MATCH($E8,Lists!$F$4:$F$11,0)),(MATCH($C8,Lists!$F$4:$I$4,0))))))","v":""},{"$f":"IF(C8=\"\",\"\",IF(E8=\"\",\"\",IF('4. Compliance'!$B$4=\"Section 11 ECB\",INDEX(Lists!$A$13:$D$20,(MATCH($E8,Lists!$A$13:$A$20,0)),(MATCH($C8,Lists!$A$13:$D$13,0))),INDEX(Lists!$F$13:$I$20,(MATCH($E8,Lists!$F$13:$F$20,0)),(MATCH($C8,Lists!$F$13:$I$13,0))))))","v":""},{"$f":"IF(L8=\"\",\"\",L8)","v":""}]
["Vertical  ",null,null,3,null,{"$f":"IF(C9=\"\",\"\",IF(E9=\"\",\"\",IF('4. Compliance'!$B$4=\"Section 11 ECB\",INDEX(Lists!$A$4:$D$11,(MATCH($E9,Lists!$A$4:$A$11,0)),(MATCH($C9,Lists!$A$4:$D$4,0))),INDEX(Lists!$F$4:$I$11,(MATCH($E9,Lists!$F$4:$F$11,0)),(MATCH($C9,Lists!$F$4:$I$4,0))))))","v":""},{"$f":"IF(C9=\"\",\"\",IF(E9=\"\",\"\",IF('4. Compliance'!$B$4=\"Section 11 ECB\",INDEX(Lists!$A$13:$D$20,(MATCH($E9,Lists!$A$13:$A$20,0)),(MATCH($C9,Lists!$A$13:$D$13,0))),INDEX(Lists!$F$13:$I$20,(MATCH($E9,Lists!$F$13:$F$20,0)),(MATCH($C9,Lists!$F$13:$I$13,0))))))","v":""},""]
["Vertical  ",null,null,4,null,{"$f":"IF(C10=\"\",\"\",IF(E10=\"\",\"\",IF('4. Compliance'!$B$4=\"Section 11 ECB\",INDEX(Lists!$A$4:$D$11,(MATCH($E10,Lists!$A$4:$A$11,0)),(MATCH($C10,Lists!$A$4:$D$4,0))),INDEX(Lists!$F$4:$I$11,(MATCH($E10,Lists!$F$4:$F$11,0)),(MATCH($C10,Lists!$F$4:$I$4,0))))))","v":""},{"$f":"IF(C10=\"\",\"\",IF(E10=\"\",\"\",IF('4. Compliance'!$B$4=\"Section 11 ECB\",INDEX(Lists!$A$13:$D$20,(MATCH($E10,Lists!$A$13:$A$20,0)),(MATCH($C10,Lists!$A$13:$D$13,0))),INDEX(Lists!$F$13:$I$20,(MATCH($E10,Lists!$F$13:$F$20,0)),(MATCH($C10,Lists!$F$13:$I$13,0))))))","v":""},""]
["Vertical  ",null,null,5,null,{"$f":"IF(C11=\"\",\"\",IF(E11=\"\",\"\",IF('4. Compliance'!$B$4=\"Section 11 ECB\",INDEX(Lists!$A$4:$D$11,(MATCH($E11,Lists!$A$4:$A$11,0)),(MATCH($C11,Lists!$A$4:$D$4,0))),INDEX(Lists!$F$4:$I$11,(MATCH($E11,Lists!$F$4:$F$11,0)),(MATCH($C11,Lists!$F$4:$I$4,0))))))","v":""},{"$f":"IF(C11=\"\",\"\",IF(E11=\"\",\"\",IF('4. Compliance'!$B$4=\"Section 11 ECB\",INDEX(Lists!$A$13:$D$20,(MATCH($E11,Lists!$A$13:$A$20,0)),(MATCH($C11,Lists!$A$13:$D$13,0))),INDEX(Lists!$F$13:$I$20,(MATCH($E11,Lists!$F$13:$F$20,0)),(MATCH($C11,Lists!$F$13:$I$13,0))))))","v":""},""]
["Vertical  ",null,null,6,null,{"$f":"IF(C12=\"\",\"\",IF(E12=\"\",\"\",IF('4. Compliance'!$B$4=\"Section 11 ECB\",INDEX(Lists!$A$4:$D$11,(MATCH($E12,Lists!$A$4:$A$11,0)),(MATCH($C12,Lists!$A$4:$D$4,0))),INDEX(Lists!$F$4:$I$11,(MATCH($E12,Lists!$F$4:$F$11,0)),(MATCH($C12,Lists!$F$4:$I$4,0))))))","v":""},{"$f":"IF(C12=\"\",\"\",IF(E12=\"\",\"\",IF('4. Compliance'!$B$4=\"Section 11 ECB\",INDEX(Lists!$A$13:$D$20,(MATCH($E12,Lists!$A$13:$A$20,0)),(MATCH($C12,Lists!$A$13:$D$13,0))),INDEX(Lists!$F$13:$I$20,(MATCH($E12,Lists!$F$13:$F$20,0)),(MATCH($C12,Lists!$F$13:$I$13,0))))))","v":""},""]
["Vertical  ",null,null,7,null,{"$f":"IF(C13=\"\",\"\",IF(E13=\"\",\"\",IF('4. Compliance'!$B$4=\"Section 11 ECB\",INDEX(Lists!$A$4:$D$11,(MATCH($E13,Lists!$A$4:$A$11,0)),(MATCH($C13,Lists!$A$4:$D$4,0))),INDEX(Lists!$F$4:$I$11,(MATCH($E13,Lists!$F$4:$F$11,0)),(MATCH($C13,Lists!$F$4:$I$4,0))))))","v":""},{"$f":"IF(C13=\"\",\"\",IF(E13=\"\",\"\",IF('4. Compliance'!$B$4=\"Section 11 ECB\",INDEX(Lists!$A$13:$D$20,(MATCH($E13,Lists!$A$13:$A$20,0)),(MATCH($C13,Lists!$A$13:$D$13,0))),INDEX(Lists!$F$13:$I$20,(MATCH($E13,Lists!$F$13:$F$20,0)),(MATCH($C13,Lists!$F$13:$I$13,0))))))","v":""},{"$f":"IF(L13=\"\",\"\",L13)","v":""}]
["Vertical  ",null,null,8,null,{"$f":"IF(C14=\"\",\"\",IF(E14=\"\",\"\",IF('4. Compliance'!$B$4=\"Section 11 ECB\",INDEX(Lists!$A$4:$D$11,(MATCH($E14,Lists!$A$4:$A$11,0)),(MATCH($C14,Lists!$A$4:$D$4,0))),INDEX(Lists!$F$4:$I$11,(MATCH($E14,Lists!$F$4:$F$11,0)),(MATCH($C14,Lists!$F$4:$I$4,0))))))","v":""},{"$f":"IF(C14=\"\",\"\",IF(E14=\"\",\"\",IF('4. Compliance'!$B$4=\"Section 11 ECB\",INDEX(Lists!$A$13:$D$20,(MATCH($E14,Lists!$A$13:$A$20,0)),(MATCH($C14,Lists!$A$13:$D$13,0))),INDEX(Lists!$F$13:$I$20,(MATCH($E14,Lists!$F$13:$F$20,0)),(MATCH($C14,Lists!$F$13:$I$13,0))))))","v":""},""]
["Vertical  ",null,null,9,null,{"$f":"IF(C15=\"\",\"\",IF(E15=\"\",\"\",IF('4. Compliance'!$B$4=\"Section 11 ECB\",INDEX(Lists!$A$4:$D$11,(MATCH($E15,Lists!$A$4:$A$11,0)),(MATCH($C15,Lists!$A$4:$D$4,0))),INDEX(Lists!$F$4:$I$11,(MATCH($E15,Lists!$F$4:$F$11,0)),(MATCH($C15,Lists!$F$4:$I$4,0))))))","v":""},{"$f":"IF(C15=\"\",\"\",IF(E15=\"\",\"\",IF('4. Compliance'!$B$4=\"Section 11 ECB\",INDEX(Lists!$A$13:$D$20,(MATCH($E15,Lists!$A$13:$A$20,0)),(MATCH($C15,Lists!$A$13:$D$13,0))),INDEX(Lists!$F$13:$I$20,(MATCH($E15,Lists!$F$13:$F$20,0)),(MATCH($C15,Lists!$F$13:$I$13,0))))))","v":""},""]
["Vertical  ",null,null,10,null,{"$f":"IF(C16=\"\",\"\",IF(E16=\"\",\"\",IF('4. Compliance'!$B$4=\"Section 11 ECB\",INDEX(Lists!$A$4:$D$11,(MATCH($E16,Lists!$A$4:$A$11,0)),(MATCH($C16,Lists!$A$4:$D$4,0))),INDEX(Lists!$F$4:$I$11,(MATCH($E16,Lists!$F$4:$F$11,0)),(MATCH($C16,Lists!$F$4:$I$4,0))))))","v":""},{"$f":"IF(C16=\"\",\"\",IF(E16=\"\",\"\",IF('4. Compliance'!$B$4=\"Section 11 ECB\",INDEX(Lists!$A$13:$D$20,(MATCH($E16,Lists!$A$13:$A$20,0)),(MATCH($C16,Lists!$A$13:$D$13,0))),INDEX(Lists!$F$13:$I$20,(MATCH($E16,Lists!$F$13:$F$20,0)),(MATCH($C16,Lists!$F$13:$I$13,0))))))","v":""},""]
["Vertical  ",null,null,11,null,{"$f":"IF(C17=\"\",\"\",IF(E17=\"\",\"\",IF('4. Compliance'!$B$4=\"Section 11 ECB\",INDEX(Lists!$A$4:$D$11,(MATCH($E17,Lists!$A$4:$A$11,0)),(MATCH($C17,Lists!$A$4:$D$4,0))),INDEX(Lists!$F$4:$I$11,(MATCH($E17,Lists!$F$4:$F$11,0)),(MATCH($C17,Lists!$F$4:$I$4,0))))))","v":""},{"$f":"IF(C17=\"\",\"\",IF(E17=\"\",\"\",IF('4. Compliance'!$B$4=\"Section 11 ECB\",INDEX(Lists!$A$13:$D$20,(MATCH($E17,Lists!$A$13:$A$20,0)),(MATCH($C17,Lists!$A$13:$D$13,0))),INDEX(Lists!$F$13:$I$20,(MATCH($E17,Lists!$F$13:$F$20,0)),(MATCH($C17,Lists!$F$13:$I$13,0))))))","v":""},""]
["Vertical  ",null,null,12,null,{"$f":"IF(C18=\"\",\"\",IF(E18=\"\",\"\",IF('4. Compliance'!$B$4=\"Section 11 ECB\",INDEX(Lists!$A$4:$D$11,(MATCH($E18,Lists!$A$4:$A$11,0)),(MATCH($C18,Lists!$A$4:$D$4,0))),INDEX(Lists!$F$4:$I$11,(MATCH($E18,Lists!$F$4:$F$11,0)),(MATCH($C18,Lists!$F$4:$I$4,0))))))","v":""},{"$f":"IF(C18=\"\",\"\",IF(E18=\"\",\"\",IF('4. Compliance'!$B$4=\"Section 11 ECB\",INDEX(Lists!$A$13:$D$20,(MATCH($E18,Lists!$A$13:$A$20,0)),(MATCH($C18,Lists!$A$13:$D$13,0))),INDEX(Lists!$F$13:$I$20,(MATCH($E18,Lists!$F$13:$F$20,0)),(MATCH($C18,Lists!$F$13:$I$13,0))))))","v":""},""]
["Skylight",null,null,1,null,{"$f":"IF(C19=\"\",\"\",IF(E19=\"\",\"\",IF('4. Compliance'!$B$4=\"Section 11 ECB\",INDEX(Lists!$A$22:$D$24,(MATCH($E19,Lists!$A$22:$A$24,0)),(MATCH($C19,Lists!$A$22:$D$22,0))),INDEX(Lists!$F$22:$I$24,(MATCH($E19,Lists!$F$22:$F$24,0)),(MATCH($C19,Lists!$F$22:$I$22,0))))))","v":""},{"$f":"IF(C19=\"\",\"\",IF(E19=\"\",\"\",IF('4. Compliance'!$B$4=\"Section 11 ECB\",INDEX(Lists!$A$26:$D$28,(MATCH($E19,Lists!$A$26:$A$28,0)),(MATCH($C19,Lists!$A$26:$D$26,0))),INDEX(Lists!$F$26:$I$28,(MATCH($E19,Lists!$F$26:$F$28,0)),(MATCH($C19,Lists!$F$26:$I$26,0))))))","v":""},""]
["Skylight",null,null,2,null,{"$f":"IF(C20=\"\",\"\",IF(E20=\"\",\"\",IF('4. Compliance'!$B$4=\"Section 11 ECB\",INDEX(Lists!$A$22:$D$24,(MATCH($E20,Lists!$A$22:$A$24,0)),(MATCH($C20,Lists!$A$22:$D$22,0))),INDEX(Lists!$F$22:$I$24,(MATCH($E20,Lists!$F$22:$F$24,0)),(MATCH($C20,Lists!$F$22:$I$22,0))))))","v":""},{"$f":"IF(C20=\"\",\"\",IF(E20=\"\",\"\",IF('4. Compliance'!$B$4=\"Section 11 ECB\",INDEX(Lists!$A$26:$D$28,(MATCH($E20,Lists!$A$26:$A$28,0)),(MATCH($C20,Lists!$A$26:$D$26,0))),INDEX(Lists!$F$26:$I$28,(MATCH($E20,Lists!$F$26:$F$28,0)),(MATCH($C20,Lists!$F$26:$I$26,0))))))","v":""},""]
["Shading Devices",null,null,"Shading projections, manual shading devices, or self-shading have been modeled.",null,null,null,null,"List any permanent or auto-controlled shading devices:",null,null,"Total % WWR",{"$f":"IF(M7=\"\",\"\",IF(AND('6a. Ext. Wall Areas'!J13/100<(SUM(M7:M18)+SUM(M7:M18)*0.01),'6a. Ext. Wall Areas'!J13/100>(SUM(M7:M18)-SUM(M7:M18)*0.01)),SUM(M7:M18),\"WWR does not equal tab 6a.\"))","v":""}]
[null,null,null,"Any shading by adjacent structures has been modeled identically to the proposed case.",null,null,null,null,null,null,null,"Total % skylt ",{"$f":"IF(M19=\"\",\"\",IF(AND('6a. Ext. Wall Areas'!J16/100<(SUM(M19:M20)+SUM(M19:M20)*0.01),'6a. Ext. Wall Areas'!J16/100>(SUM(M19:M20)-SUM(M19:M20)*0.01)),SUM(M19:M20),\"WWR does not equal tab 6a.\"))","v":""}]

{"sheet":"6c1. Wall Types","index":14,"n_rows":26,"n_cols":10,"rows_kept":26,"cut":false,"hidden":false,"merged":[[2,0,2,9],[1,1,1,9],[19,0,20,0],[9,0,18,0],[23,0,24,0],[3,0,4,0],[3,9,4,9],[5,0,8,0],[5,1,6,1],[5,2,6,2],[5,8,6,8],[5,9,6,9],[7,1,8,1],[7,2,8,2],[7,8,8,8],[7,9,8,9],[3,1,4,1],[3,2,4,2],[3,5,3,6],[3,8,4,8],[3,3,3,4]]}
[]
["6c","Opaque Elements"]
[{"$f":"CONCATENATE(\"Compliance based on \",IF(Path=\"\",\"\",Path))","v":"Compliance based on Section 11 ECB"}]
["Model Input Parameter","Space-Conditioning Category ","Item #","Baseline Case",null,"Proposed Case",null,null,"Supporting Doc Location","Model Output Report"]
[null,null,null,"Description","U-factor/ C-factor/ F-factor","Description","Assembly U-factor/ C-factor/ F-factor","% of above-grade wall"]
["Roof Construction",null,1,null,{"$f":"IF(B6=\"\",\"\",IF(D6=\"\",\"\",IF('4. Compliance'!$B$4=\"Section 11 ECB\",INDEX(Lists!$A$30:$D$33,(MATCH($D6,Lists!$A$30:$A$33,0)),(MATCH($B6,Lists!$A$30:$D$30,0))),INDEX(Lists!$F$30:$I$33,(MATCH($D6,Lists!$F$30:$F$33,0)),(MATCH($B6,Lists!$F$30:$I$30,0))))))","v":""}]
[null,null,null,"Solar Reflectance","SR ="]
[null,null,2,null,{"$f":"IF(B8=\"\",\"\",IF(D8=\"\",\"\",IF('4. Compliance'!$B$4=\"Section 11 ECB\",INDEX(Lists!$A$30:$D$33,(MATCH($D8,Lists!$A$30:$A$33,0)),(MATCH($B8,Lists!$A$30:$D$30,0))),INDEX(Lists!$F$30:$I$33,(MATCH($D8,Lists!$F$30:$F$33,0)),(MATCH($B8,Lists!$F$30:$I$30,0))))))","v":""}]
[null,null,null,"Solar Reflectance","SR ="]
["Above-Grade Exterior Wall Construction \n(Values on this tab should align with modeled inputs. For additional rows, use tab 6c2) ",null,1,null,{"$f":"IF(B10=\"\",\"\",IF(D10=\"\",\"\",IF('4. Compliance'!$B$4=\"Section 11 ECB\",INDEX(Lists!$A$34:$D$38,(MATCH($D10,Lists!$A$34:$A$38,0)),(MATCH($B10,Lists!$A$34:$D$34,0))),INDEX(Lists!$F$34:$I$38,(MATCH($D10,Lists!$F$34:$F$38,0)),(MATCH($B10,Lists!$F$34:$I$34,0))))))","v":""}]
[null,null,2,null,{"$f":"IF(B11=\"\",\"\",IF(D11=\"\",\"\",IF('4. Compliance'!$B$4=\"Section 11 ECB\",INDEX(Lists!$A$34:$D$38,(MATCH($D11,Lists!$A$34:$A$38,0)),(MATCH($B11,Lists!$A$34:$D$34,0))),INDEX(Lists!$F$34:$I$38,(MATCH($D11,Lists!$F$34:$F$38,0)),(MATCH($B11,Lists!$F$34:$I$34,0))))))","v":""}]
[null,null,3,null,{"$f":"IF(B12=\"\",\"\",IF(D12=\"\",\"\",IF('4. Compliance'!$B$4=\"Section 11 ECB\",INDEX(Lists!$A$34:$D$38,(MATCH($D12,Lists!$A$34:$A$38,0)),(MATCH($B12,Lists!$A$34:$D$34,0))),INDEX(Lists!$F$34:$I$38,(MATCH($D12,Lists!$F$34:$F$38,0)),(MATCH($B12,Lists!$F$34:$I$34,0))))))","v":""}]
[null,null,4,null,{"$f":"IF(B13=\"\",\"\",IF(D13=\"\",\"\",IF('4. Compliance'!$B$4=\"Section 11 ECB\",INDEX(Lists!$A$34:$D$38,(MATCH($D13,Lists!$A$34:$A$38,0)),(MATCH($B13,Lists!$A$34:$D$34,0))),INDEX(Lists!$F$34:$I$38,(MATCH($D13,Lists!$F$34:$F$38,0)),(MATCH($B13,Lists!$F$34:$I$34,0))))))","v":""}]
[null,null,5,null,{"$f":"IF(B14=\"\",\"\",IF(D14=\"\",\"\",IF('4. Compliance'!$B$4=\"Section 11 ECB\",INDEX(Lists!$A$34:$D$38,(MATCH($D14,Lists!$A$34:$A$38,0)),(MATCH($B14,Lists!$A$34:$D$34,0))),INDEX(Lists!$F$34:$I$38,(MATCH($D14,Lists!$F$34:$F$38,0)),(MATCH($B14,Lists!$F$34:$I$34,0))))))","v":""}]
[null,null,6]
[null,null,7]
[null,null,8,null,{"$f":"IF(B17=\"\",\"\",IF(D17=\"\",\"\",IF('4. Compliance'!$B$4=\"Section 11 ECB\",INDEX(Lists!$A$34:$D$38,(MATCH($D17,Lists!$A$34:$A$38,0)),(MATCH($B17,Lists!$A$34:$D$34,0))),INDEX(Lists!$F$34:$I$38,(MATCH($D17,Lists!$F$34:$F$38,0)),(MATCH($B17,Lists!$F$34:$I$34,0))))))","v":""}]
[null,null,9,null,{"$f":"IF(B18=\"\",\"\",IF(D18=\"\",\"\",IF('4. Compliance'!$B$4=\"Section 11 ECB\",INDEX(Lists!$A$34:$D$38,(MATCH($D18,Lists!$A$34:$A$38,0)),(MATCH($B18,Lists!$A$34:$D$34,0))),INDEX(Lists!$F$34:$I$38,(MATCH($D18,Lists!$F$34:$F$38,0)),(MATCH($B18,Lists!$F$34:$I$34,0))))))","v":""}]
[null,null,10,null,{"$f":"IF(B19=\"\",\"\",IF(D19=\"\",\"\",IF('4. Compliance'!$B$4=\"Section 11 ECB\",INDEX(Lists!$A$34:$D$38,(MATCH($D19,Lists!$A$34:$A$38,0)),(MATCH($B19,Lists!$A$34:$D$34,0))),INDEX(Lists!$F$34:$I$38,(MATCH($D19,Lists!$F$34:$F$38,0)),(MATCH($B19,Lists!$F$34:$I$34,0))))))","v":""}]
["Below-Grade Exterior Wall Construction",null,1,null,{"$f":"IF(B20=\"\",\"\",IF(D20=\"\",\"\",IF('4. Compliance'!$B$4=\"Section 11 ECB\",INDEX(Lists!$A$39:$D$40,(MATCH($D20,Lists!$A$39:$A$40,0)),(MATCH($B20,Lists!$A$39:$D$39,0))),INDEX(Lists!$F$39:$I$40,(MATCH($D20,Lists!$F$39:$F$40,0)),(MATCH($B20,Lists!$F$39:$I$39,0))))))","v":""}]
[null,null,2,null,{"$f":"IF(B21=\"\",\"\",IF(D21=\"\",\"\",IF('4. Compliance'!$B$4=\"Section 11 ECB\",INDEX(Lists!$A$39:$D$40,(MATCH($D21,Lists!$A$39:$A$40,0)),(MATCH($B21,Lists!$A$39:$D$39,0))),INDEX(Lists!$F$39:$I$40,(MATCH($D21,Lists!$F$39:$F$40,0)),(MATCH($B21,Lists!$F$39:$I$39,0))))))","v":""}]
["Exposed Floor Construction",null,1,null,{"$f":"IF(B22=\"\",\"\",IF(D22=\"\",\"\",IF('4. Compliance'!$B$4=\"Section 11 ECB\",INDEX(Lists!$A$41:$D$44,(MATCH($D22,Lists!$A$41:$A$44,0)),(MATCH($B22,Lists!$A$41:$D$41,0))),INDEX(Lists!$F$41:$I$44,(MATCH($D22,Lists!$F$41:$F$44,0)),(MATCH($B22,Lists!$F$41:$I$41,0))))))","v":""}]
[" Slab-On-Grade Floors",null,1,null,{"$f":"IF(B23=\"\",\"\",IF(D23=\"\",\"\",IF('4. Compliance'!$B$4=\"Section 11 ECB\",INDEX(Lists!$A$45:$D$47,(MATCH($D23,Lists!$A$45:$A$47,0)),(MATCH($B23,Lists!$A$45:$D$45,0))),INDEX(Lists!$F$45:$I$47,(MATCH($D23,Lists!$F$45:$F$47,0)),(MATCH($B23,Lists!$F$45:$I$45,0))))))","v":""}]
["Opaque Doors",null,1,null,{"$f":"IF(B24=\"\",\"\",IF(D24=\"\",\"\",IF('4. Compliance'!$B$4=\"Section 11 ECB\",INDEX(Lists!$A$48:$D$50,(MATCH($D24,Lists!$A$48:$A$50,0)),(MATCH($B24,Lists!$A$48:$D$48,0))),INDEX(Lists!$F$48:$I$50,(MATCH($D24,Lists!$F$48:$F$50,0)),(MATCH($B24,Lists!$F$48:$I$48,0))))))","v":""}]
[null,null,2,null,{"$f":"IF(B25=\"\",\"\",IF(D25=\"\",\"\",IF('4. Compliance'!$B$4=\"Section 11 ECB\",INDEX(Lists!$A$48:$D$50,(MATCH($D25,Lists!$A$48:$A$50,0)),(MATCH($B25,Lists!$A$48:$D$48,0))),INDEX(Lists!$F$48:$I$50,(MATCH($D25,Lists!$F$48:$F$50,0)),(MATCH($B25,Lists!$F$48:$I$48,0))))))","v":""}]
[null,null,null,null,null,null,"Total % Opaque Wall",{"$f":"IF(H10=\"\",\"\",IF(AND(((100-'6a. Ext. Wall Areas'!J13)/100)<(SUM(H10:H19)+SUM(H10:H19)*0.01),((100-'6a. Ext. Wall Areas'!J13)/100)>(SUM(H10:H19)-SUM(H10:H19)*0.01)),SUM(H10:H19),\"Above grade % does not equal tab 6a.\"))","v":""}]

{"sheet":"6c2. Wall Types - Add'l Rows","index":15,"n_rows":49,"n_cols":10,"rows_kept":49,"cut":false,"hidden":false,"merged":[[5,0,11,0],[12,0,46,0],[1,1,1,9],[2,0,2,9],[3,0,4,0],[3,1,4,1],[3,2,4,2],[3,3,3,4],[3,5,3,6],[3,8,4,8],[3,9,4,9]]}
[]
["6c","Opaque Elements - Weighted Average"]
[{"$f":"CONCATENATE(\"Compliance based on \",IF(Path=\"\",\"\",Path))","v":"Compliance based on Section 11 ECB"}]
["Model Input Parameter","Space-Conditioning Category ","Item #","Baseline Case",null,"Proposed Case",null,null,"Supporting Doc Location","Model Output Report"]
[null,null,null,"Description","U-factor/ C-factor/ F-factor","Description","Assembly U-factor/ C-factor/ F-factor","% of above-grade wall"]
["Roof Construction",null,1,null,{"$f":"IF(B6=\"\",\"\",IF(D6=\"\",\"\",IF('4. Compliance'!$B$4=\"Section 11 ECB\",INDEX(Lists!$A$30:$D$33,(MATCH($D6,Lists!$A$30:$A$33,0)),(MATCH($B6,Lists!$A$30:$D$30,0))),INDEX(Lists!$F$30:$I$33,(MATCH($D6,Lists!$F$30:$F$33,0)),(MATCH($B6,Lists!$F$30:$I$30,0))))))","v":""}]
[null,null,2,null,{"$f":"IF(B7=\"\",\"\",IF(D7=\"\",\"\",IF('4. Compliance'!$B$4=\"Section 11 ECB\",INDEX(Lists!$A$30:$D$33,(MATCH($D7,Lists!$A$30:$A$33,0)),(MATCH($B7,Lists!$A$30:$D$30,0))),INDEX(Lists!$F$30:$I$33,(MATCH($D7,Lists!$F$30:$F$33,0)),(MATCH($B7,Lists!$F$30:$I$30,0))))))","v":""}]
[null,null,3,null,{"$f":"IF(B8=\"\",\"\",IF(D8=\"\",\"\",IF('4. Compliance'!$B$4=\"Section 11 ECB\",INDEX(Lists!$A$30:$D$33,(MATCH($D8,Lists!$A$30:$A$33,0)),(MATCH($B8,Lists!$A$30:$D$30,0))),INDEX(Lists!$F$30:$I$33,(MATCH($D8,Lists!$F$30:$F$33,0)),(MATCH($B8,Lists!$F$30:$I$30,0))))))","v":""}]
[null,null,4,null,{"$f":"IF(B9=\"\",\"\",IF(D9=\"\",\"\",IF('4. Compliance'!$B$4=\"Section 11 ECB\",INDEX(Lists!$A$30:$D$33,(MATCH($D9,Lists!$A$30:$A$33,0)),(MATCH($B9,Lists!$A$30:$D$30,0))),INDEX(Lists!$F$30:$I$33,(MATCH($D9,Lists!$F$30:$F$33,0)),(MATCH($B9,Lists!$F$30:$I$30,0))))))","v":""}]
[null,null,5,null,{"$f":"IF(B10=\"\",\"\",IF(D10=\"\",\"\",IF('4. Compliance'!$B$4=\"Section 11 ECB\",INDEX(Lists!$A$30:$D$33,(MATCH($D10,Lists!$A$30:$A$33,0)),(MATCH($B10,Lists!$A$30:$D$30,0))),INDEX(Lists!$F$30:$I$33,(MATCH($D10,Lists!$F$30:$F$33,0)),(MATCH($B10,Lists!$F$30:$I$30,0))))))","v":""}]
[null,null,6,null,{"$f":"IF(B11=\"\",\"\",IF(D11=\"\",\"\",IF('4. Compliance'!$B$4=\"Section 11 ECB\",INDEX(Lists!$A$30:$D$33,(MATCH($D11,Lists!$A$30:$A$33,0)),(MATCH($B11,Lists!$A$30:$D$30,0))),INDEX(Lists!$F$30:$I$33,(MATCH($D11,Lists!$F$30:$F$33,0)),(MATCH($B11,Lists!$F$30:$I$30,0))))))","v":""}]
[null,null,7,null,{"$f":"IF(B12=\"\",\"\",IF(D12=\"\",\"\",IF('4. Compliance'!$B$4=\"Section 11 ECB\",INDEX(Lists!$A$30:$D$33,(MATCH($D12,Lists!$A$30:$A$33,0)),(MATCH($B12,Lists!$A$30:$D$30,0))),INDEX(Lists!$F$30:$I$33,(MATCH($D12,Lists!$F$30:$F$33,0)),(MATCH($B12,Lists!$F$30:$I$30,0))))))","v":""}]
["Above-Grade Opaque Wall Construction",null,1,null,{"$f":"IF(B13=\"\",\"\",IF(D13=\"\",\"\",IF('4. Compliance'!$B$4=\"Section 11 ECB\",INDEX(Lists!$A$34:$D$38,(MATCH($D13,Lists!$A$34:$A$38,0)),(MATCH($B13,Lists!$A$34:$D$34,0))),INDEX(Lists!$F$34:$I$38,(MATCH($D13,Lists!$F$34:$F$38,0)),(MATCH($B13,Lists!$F$34:$I$34,0))))))","v":""}]
[null,null,2,null,{"$f":"IF(B14=\"\",\"\",IF(D14=\"\",\"\",IF('4. Compliance'!$B$4=\"Section 11 ECB\",INDEX(Lists!$A$34:$D$38,(MATCH($D14,Lists!$A$34:$A$38,0)),(MATCH($B14,Lists!$A$34:$D$34,0))),INDEX(Lists!$F$34:$I$38,(MATCH($D14,Lists!$F$34:$F$38,0)),(MATCH($B14,Lists!$F$34:$I$34,0))))))","v":""}]
[null,null,3,null,{"$f":"IF(B15=\"\",\"\",IF(D15=\"\",\"\",IF('4. Compliance'!$B$4=\"Section 11 ECB\",INDEX(Lists!$A$34:$D$38,(MATCH($D15,Lists!$A$34:$A$38,0)),(MATCH($B15,Lists!$A$34:$D$34,0))),INDEX(Lists!$F$34:$I$38,(MATCH($D15,Lists!$F$34:$F$38,0)),(MATCH($B15,Lists!$F$34:$I$34,0))))))","v":""}]
[null,null,4,null,{"$f":"IF(B16=\"\",\"\",IF(D16=\"\",\"\",IF('4. Compliance'!$B$4=\"Section 11 ECB\",INDEX(Lists!$A$34:$D$38,(MATCH($D16,Lists!$A$34:$A$38,0)),(MATCH($B16,Lists!$A$34:$D$34,0))),INDEX(Lists!$F$34:$I$38,(MATCH($D16,Lists!$F$34:$F$38,0)),(MATCH($B16,Lists!$F$34:$I$34,0))))))","v":""}]
[null,null,5,null,{"$f":"IF(B17=\"\",\"\",IF(D17=\"\",\"\",IF('4. Compliance'!$B$4=\"Section 11 ECB\",INDEX(Lists!$A$34:$D$38,(MATCH($D17,Lists!$A$34:$A$38,0)),(MATCH($B17,Lists!$A$34:$D$34,0))),INDEX(Lists!$F$34:$I$38,(MATCH($D17,Lists!$F$34:$F$38,0)),(MATCH($B17,Lists!$F$34:$I$34,0))))))","v":""}]
[null,null,6,null,{"$f":"IF(B18=\"\",\"\",IF(D18=\"\",\"\",IF('4. Compliance'!$B$4=\"Section 11 ECB\",INDEX(Lists!$A$34:$D$38,(MATCH($D18,Lists!$A$34:$A$38,0)),(MATCH($B18,Lists!$A$34:$D$34,0))),INDEX(Lists!$F$34:$I$38,(MATCH($D18,Lists!$F$34:$F$38,0)),(MATCH($B18,Lists!$F$34:$I$34,0))))))","v":""}]
[null,null,7,null,{"$f":"IF(B19=\"\",\"\",IF(D19=\"\",\"\",IF('4. Compliance'!$B$4=\"Section 11 ECB\",INDEX(Lists!$A$34:$D$38,(MATCH($D19,Lists!$A$34:$A$38,0)),(MATCH($B19,Lists!$A$34:$D$34,0))),INDEX(Lists!$F$34:$I$38,(MATCH($D19,Lists!$F$34:$F$38,0)),(MATCH($B19,Lists!$F$34:$I$34,0))))))","v":""}]
[null,null,8,null,{"$f":"IF(B20=\"\",\"\",IF(D20=\"\",\"\",IF('4. Compliance'!$B$4=\"Section 11 ECB\",INDEX(Lists!$A$34:$D$38,(MATCH($D20,Lists!$A$34:$A$38,0)),(MATCH($B20,Lists!$A$34:$D$34,0))),INDEX(Lists!$F$34:$I$38,(MATCH($D20,Lists!$F$34:$F$38,0)),(MATCH($B20,Lists!$F$34:$I$34,0))))))","v":""}]
[null,null,9,null,{"$f":"IF(B21=\"\",\"\",IF(D21=\"\",\"\",IF('4. Compliance'!$B$4=\"Section 11 ECB\",INDEX(Lists!$A$34:$D$38,(MATCH($D21,Lists!$A$34:$A$38,0)),(MATCH($B21,Lists!$A$34:$D$34,0))),INDEX(Lists!$F$34:$I$38,(MATCH($D21,Lists!$F$34:$F$38,0)),(MATCH($B21,Lists!$F$34:$I$34,0))))))","v":""}]
[null,null,10,null,{"$f":"IF(B22=\"\",\"\",IF(D22=\"\",\"\",IF('4. Compliance'!$B$4=\"Section 11 ECB\",INDEX(Lists!$A$34:$D$38,(MATCH($D22,Lists!$A$34:$A$38,0)),(MATCH($B22,Lists!$A$34:$D$34,0))),INDEX(Lists!$F$34:$I$38,(MATCH($D22,Lists!$F$34:$F$38,0)),(MATCH($B22,Lists!$F$34:$I$34,0))))))","v":""}]
[null,null,11,null,{"$f":"IF(B23=\"\",\"\",IF(D23=\"\",\"\",IF('4. Compliance'!$B$4=\"Section 11 ECB\",INDEX(Lists!$A$34:$D$38,(MATCH($D23,Lists!$A$34:$A$38,0)),(MATCH($B23,Lists!$A$34:$D$34,0))),INDEX(Lists!$F$34:$I$38,(MATCH($D23,Lists!$F$34:$F$38,0)),(MATCH($B23,Lists!$F$34:$I$34,0))))))","v":""}]
[null,null,12,null,{"$f":"IF(B24=\"\",\"\",IF(D24=\"\",\"\",IF('4. Compliance'!$B$4=\"Section 11 ECB\",INDEX(Lists!$A$34:$D$38,(MATCH($D24,Lists!$A$34:$A$38,0)),(MATCH($B24,Lists!$A$34:$D$34,0))),INDEX(Lists!$F$34:$I$38,(MATCH($D24,Lists!$F$34:$F$38,0)),(MATCH($B24,Lists!$F$34:$I$34,0))))))","v":""}]
[null,null,13,null,{"$f":"IF(B25=\"\",\"\",IF(D25=\"\",\"\",IF('4. Compliance'!$B$4=\"Section 11 ECB\",INDEX(Lists!$A$34:$D$38,(MATCH($D25,Lists!$A$34:$A$38,0)),(MATCH($B25,Lists!$A$34:$D$34,0))),INDEX(Lists!$F$34:$I$38,(MATCH($D25,Lists!$F$34:$F$38,0)),(MATCH($B25,Lists!$F$34:$I$34,0))))))","v":""}]
[null,null,14,null,{"$f":"IF(B26=\"\",\"\",IF(D26=\"\",\"\",IF('4. Compliance'!$B$4=\"Section 11 ECB\",INDEX(Lists!$A$34:$D$38,(MATCH($D26,Lists!$A$34:$A$38,0)),(MATCH($B26,Lists!$A$34:$D$34,0))),INDEX(Lists!$F$34:$I$38,(MATCH($D26,Lists!$F$34:$F$38,0)),(MATCH($B26,Lists!$F$34:$I$34,0))))))","v":""}]
[null,null,15,null,{"$f":"IF(B27=\"\",\"\",IF(D27=\"\",\"\",IF('4. Compliance'!$B$4=\"Section 11 ECB\",INDEX(Lists!$A$34:$D$38,(MATCH($D27,Lists!$A$34:$A$38,0)),(MATCH($B27,Lists!$A$34:$D$34,0))),INDEX(Lists!$F$34:$I$38,(MATCH($D27,Lists!$F$34:$F$38,0)),(MATCH($B27,Lists!$F$34:$I$34,0))))))","v":""}]
[null,null,16,null,{"$f":"IF(B28=\"\",\"\",IF(D28=\"\",\"\",IF('4. Compliance'!$B$4=\"Section 11 ECB\",INDEX(Lists!$A$34:$D$38,(MATCH($D28,Lists!$A$34:$A$38,0)),(MATCH($B28,Lists!$A$34:$D$34,0))),INDEX(Lists!$F$34:$I$38,(MATCH($D28,Lists!$F$34:$F$38,0)),(MATCH($B28,Lists!$F$34:$I$34,0))))))","v":""}]
[null,null,17,null,{"$f":"IF(B29=\"\",\"\",IF(D29=\"\",\"\",IF('4. Compliance'!$B$4=\"Section 11 ECB\",INDEX(Lists!$A$34:$D$38,(MATCH($D29,Lists!$A$34:$A$38,0)),(MATCH($B29,Lists!$A$34:$D$34,0))),INDEX(Lists!$F$34:$I$38,(MATCH($D29,Lists!$F$34:$F$38,0)),(MATCH($B29,Lists!$F$34:$I$34,0))))))","v":""}]
[null,null,18,null,{"$f":"IF(B30=\"\",\"\",IF(D30=\"\",\"\",IF('4. Compliance'!$B$4=\"Section 11 ECB\",INDEX(Lists!$A$34:$D$38,(MATCH($D30,Lists!$A$34:$A$38,0)),(MATCH($B30,Lists!$A$34:$D$34,0))),INDEX(Lists!$F$34:$I$38,(MATCH($D30,Lists!$F$34:$F$38,0)),(MATCH($B30,Lists!$F$34:$I$34,0))))))","v":""}]
[null,null,19,null,{"$f":"IF(B31=\"\",\"\",IF(D31=\"\",\"\",IF('4. Compliance'!$B$4=\"Section 11 ECB\",INDEX(Lists!$A$34:$D$38,(MATCH($D31,Lists!$A$34:$A$38,0)),(MATCH($B31,Lists!$A$34:$D$34,0))),INDEX(Lists!$F$34:$I$38,(MATCH($D31,Lists!$F$34:$F$38,0)),(MATCH($B31,Lists!$F$34:$I$34,0))))))","v":""}]
[null,null,20,null,{"$f":"IF(B32=\"\",\"\",IF(D32=\"\",\"\",IF('4. Compliance'!$B$4=\"Section 11 ECB\",INDEX(Lists!$A$34:$D$38,(MATCH($D32,Lists!$A$34:$A$38,0)),(MATCH($B32,Lists!$A$34:$D$34,0))),INDEX(Lists!$F$34:$I$38,(MATCH($D32,Lists!$F$34:$F$38,0)),(MATCH($B32,Lists!$F$34:$I$34,0))))))","v":""}]
[null,null,21,null,{"$f":"IF(B33=\"\",\"\",IF(D33=\"\",\"\",IF('4. Compliance'!$B$4=\"Section 11 ECB\",INDEX(Lists!$A$34:$D$38,(MATCH($D33,Lists!$A$34:$A$38,0)),(MATCH($B33,Lists!$A$34:$D$34,0))),INDEX(Lists!$F$34:$I$38,(MATCH($D33,Lists!$F$34:$F$38,0)),(MATCH($B33,Lists!$F$34:$I$34,0))))))","v":""}]
[null,null,22,null,{"$f":"IF(B34=\"\",\"\",IF(D34=\"\",\"\",IF('4. Compliance'!$B$4=\"Section 11 ECB\",INDEX(Lists!$A$34:$D$38,(MATCH($D34,Lists!$A$34:$A$38,0)),(MATCH($B34,Lists!$A$34:$D$34,0))),INDEX(Lists!$F$34:$I$38,(MATCH($D34,Lists!$F$34:$F$38,0)),(MATCH($B34,Lists!$F$34:$I$34,0))))))","v":""}]
[null,null,23,null,{"$f":"IF(B35=\"\",\"\",IF(D35=\"\",\"\",IF('4. Compliance'!$B$4=\"Section 11 ECB\",INDEX(Lists!$A$34:$D$38,(MATCH($D35,Lists!$A$34:$A$38,0)),(MATCH($B35,Lists!$A$34:$D$34,0))),INDEX(Lists!$F$34:$I$38,(MATCH($D35,Lists!$F$34:$F$38,0)),(MATCH($B35,Lists!$F$34:$I$34,0))))))","v":""}]
[null,null,24,null,{"$f":"IF(B36=\"\",\"\",IF(D36=\"\",\"\",IF('4. Compliance'!$B$4=\"Section 11 ECB\",INDEX(Lists!$A$34:$D$38,(MATCH($D36,Lists!$A$34:$A$38,0)),(MATCH($B36,Lists!$A$34:$D$34,0))),INDEX(Lists!$F$34:$I$38,(MATCH($D36,Lists!$F$34:$F$38,0)),(MATCH($B36,Lists!$F$34:$I$34,0))))))","v":""}]
[null,null,25,null,{"$f":"IF(B37=\"\",\"\",IF(D37=\"\",\"\",IF('4. Compliance'!$B$4=\"Section 11 ECB\",INDEX(Lists!$A$34:$D$38,(MATCH($D37,Lists!$A$34:$A$38,0)),(MATCH($B37,Lists!$A$34:$D$34,0))),INDEX(Lists!$F$34:$I$38,(MATCH($D37,Lists!$F$34:$F$38,0)),(MATCH($B37,Lists!$F$34:$I$34,0))))))","v":""}]
[null,null,26,null,{"$f":"IF(B38=\"\",\"\",IF(D38=\"\",\"\",IF('4. Compliance'!$B$4=\"Section 11 ECB\",INDEX(Lists!$A$34:$D$38,(MATCH($D38,Lists!$A$34:$A$38,0)),(MATCH($B38,Lists!$A$34:$D$34,0))),INDEX(Lists!$F$34:$I$38,(MATCH($D38,Lists!$F$34:$F$38,0)),(MATCH($B38,Lists!$F$34:$I$34,0))))))","v":""}]
[null,null,27,null,{"$f":"IF(B39=\"\",\"\",IF(D39=\"\",\"\",IF('4. Compliance'!$B$4=\"Section 11 ECB\",INDEX(Lists!$A$34:$D$38,(MATCH($D39,Lists!$A$34:$A$38,0)),(MATCH($B39,Lists!$A$34:$D$34,0))),INDEX(Lists!$F$34:$I$38,(MATCH($D39,Lists!$F$34:$F$38,0)),(MATCH($B39,Lists!$F$34:$I$34,0))))))","v":""}]
[null,null,28,null,{"$f":"IF(B40=\"\",\"\",IF(D40=\"\",\"\",IF('4. Compliance'!$B$4=\"Section 11 ECB\",INDEX(Lists!$A$34:$D$38,(MATCH($D40,Lists!$A$34:$A$38,0)),(MATCH($B40,Lists!$A$34:$D$34,0))),INDEX(Lists!$F$34:$I$38,(MATCH($D40,Lists!$F$34:$F$38,0)),(MATCH($B40,Lists!$F$34:$I$34,0))))))","v":""}]
[null,null,29,null,{"$f":"IF(B41=\"\",\"\",IF(D41=\"\",\"\",IF('4. Compliance'!$B$4=\"Section 11 ECB\",INDEX(Lists!$A$34:$D$38,(MATCH($D41,Lists!$A$34:$A$38,0)),(MATCH($B41,Lists!$A$34:$D$34,0))),INDEX(Lists!$F$34:$I$38,(MATCH($D41,Lists!$F$34:$F$38,0)),(MATCH($B41,Lists!$F$34:$I$34,0))))))","v":""}]
[null,null,30,null,{"$f":"IF(B42=\"\",\"\",IF(D42=\"\",\"\",IF('4. Compliance'!$B$4=\"Section 11 ECB\",INDEX(Lists!$A$34:$D$38,(MATCH($D42,Lists!$A$34:$A$38,0)),(MATCH($B42,Lists!$A$34:$D$34,0))),INDEX(Lists!$F$34:$I$38,(MATCH($D42,Lists!$F$34:$F$38,0)),(MATCH($B42,Lists!$F$34:$I$34,0))))))","v":""}]
[null,null,31,null,{"$f":"IF(B43=\"\",\"\",IF(D43=\"\",\"\",IF('4. Compliance'!$B$4=\"Section 11 ECB\",INDEX(Lists!$A$34:$D$38,(MATCH($D43,Lists!$A$34:$A$38,0)),(MATCH($B43,Lists!$A$34:$D$34,0))),INDEX(Lists!$F$34:$I$38,(MATCH($D43,Lists!$F$34:$F$38,0)),(MATCH($B43,Lists!$F$34:$I$34,0))))))","v":""}]
[null,null,32,null,{"$f":"IF(B44=\"\",\"\",IF(D44=\"\",\"\",IF('4. Compliance'!$B$4=\"Section 11 ECB\",INDEX(Lists!$A$34:$D$38,(MATCH($D44,Lists!$A$34:$A$38,0)),(MATCH($B44,Lists!$A$34:$D$34,0))),INDEX(Lists!$F$34:$I$38,(MATCH($D44,Lists!$F$34:$F$38,0)),(MATCH($B44,Lists!$F$34:$I$34,0))))))","v":""}]
[null,null,33,null,{"$f":"IF(B45=\"\",\"\",IF(D45=\"\",\"\",IF('4. Compliance'!$B$4=\"Section 11 ECB\",INDEX(Lists!$A$34:$D$38,(MATCH($D45,Lists!$A$34:$A$38,0)),(MATCH($B45,Lists!$A$34:$D$34,0))),INDEX(Lists!$F$34:$I$38,(MATCH($D45,Lists!$F$34:$F$38,0)),(MATCH($B45,Lists!$F$34:$I$34,0))))))","v":""}]
[null,null,34,null,{"$f":"IF(B46=\"\",\"\",IF(D46=\"\",\"\",IF('4. Compliance'!$B$4=\"Section 11 ECB\",INDEX(Lists!$A$34:$D$38,(MATCH($D46,Lists!$A$34:$A$38,0)),(MATCH($B46,Lists!$A$34:$D$34,0))),INDEX(Lists!$F$34:$I$38,(MATCH($D46,Lists!$F$34:$F$38,0)),(MATCH($B46,Lists!$F$34:$I$34,0))))))","v":""}]
[null,null,35,null,{"$f":"IF(B47=\"\",\"\",IF(D47=\"\",\"\",IF('4. Compliance'!$B$4=\"Section 11 ECB\",INDEX(Lists!$A$34:$D$38,(MATCH($D47,Lists!$A$34:$A$38,0)),(MATCH($B47,Lists!$A$34:$D$34,0))),INDEX(Lists!$F$34:$I$38,(MATCH($D47,Lists!$F$34:$F$38,0)),(MATCH($B47,Lists!$F$34:$I$34,0))))))","v":""}]
[null,null,null,null,null,null,"Total % Opaque Roof",{"$f":"IF(H6=\"\",\"\",IF(AND(((100-'6a. Ext. Wall Areas'!J16)/100)<(SUM(H6:H12)+SUM(H6:H12)*0.01),((100-'6a. Ext. Wall Areas'!J16)/100)>(SUM(H6:H12)-SUM(H6:H12)*0.01)),SUM(H6:H12),\"Opaque roof % does not equal tab 6a.\"))","v":""}]
[null,null,null,null,null,null,"Total % Opaque Wall",{"$f":"IF(H14=\"\",\"\",IF(AND(((100-'6a. Ext. Wall Areas'!J14)/100)<(SUM(H14:H48)+SUM(H14:H48)*0.01),((100-'6a. Ext. Wall Areas'!J14)/100)>(SUM(H14:H48)-SUM(H14:H48)*0.01)),SUM(H14:H48),\"Above grade % does not equal tab 6a.\"))","v":""}]

{"sheet":"6d.1 Interior LPD-Space Method","index":16,"n_rows":31,"n_cols":13,"rows_kept":31,"cut":false,"hidden":false,"merged":[[3,0,5,0],[3,1,5,1],[4,5,5,5],[4,7,5,7],[1,1,1,12],[3,7,3,12],[3,2,3,4],[4,11,5,11],[4,12,5,12],[4,8,5,8],[3,5,3,6],[4,2,5,2],[4,3,5,3],[2,0,2,12]]}
[]
["6d.1","Interior LPD: Space-by-Space Method "]
[{"$f":"CONCATENATE(\"Compliance based on \",IF(Path=\"\",\"\",Path))","v":"Compliance based on Section 11 ECB"}]
["Space Type (Table 9.6.1) ","Total Area  Space/Blg Type (ft2)","Baseline Case",null,null,"Additional Power Allowance?",null,"Proposed Case"]
[null,null,"Auto. Controls (Yes/No)","Daylight Ctrls (Yes/No)","Baseline LPD","Type","Add'l LPD","Auto. Controls (Yes/No)","Daylight Ctrls (Yes/No)","Proposed LPD","Add'l LPD","Supporting Doc. Location","Model Output Report"]
[null,null,null,null,"(W/ft2)",null,"(W/ft2)",null,null,"(W/ft2)","(W/ft2)"]
[null,null,null,null,{"$f":"IF($A7=\"\",\"\",IF($B7=\"\",\"\",IF('4. Compliance'!$B$4=\"Section 11 ECB\",VLOOKUP($A7,'Lighting Lookup'!$E$2:$G$108,2),VLOOKUP($A7,'Lighting Lookup'!$E$2:$G$108,3))))","v":""}]
[null,null,null,null,{"$f":"IF($A8=\"\",\"\",IF($B8=\"\",\"\",IF('4. Compliance'!$B$4=\"Section 11 ECB\",VLOOKUP($A8,'Lighting Lookup'!$E$2:$G$108,2),VLOOKUP($A8,'Lighting Lookup'!$E$2:$G$108,3))))","v":""}]
[null,null,null,null,{"$f":"IF($A9=\"\",\"\",IF($B9=\"\",\"\",IF('4. Compliance'!$B$4=\"Section 11 ECB\",VLOOKUP($A9,'Lighting Lookup'!$E$2:$G$108,2),VLOOKUP($A9,'Lighting Lookup'!$E$2:$G$108,3))))","v":""}]
[null,null,null,null,{"$f":"IF($A10=\"\",\"\",IF($B10=\"\",\"\",IF('4. Compliance'!$B$4=\"Section 11 ECB\",VLOOKUP($A10,'Lighting Lookup'!$E$2:$G$108,2),VLOOKUP($A10,'Lighting Lookup'!$E$2:$G$108,3))))","v":""}]
[null,null,null,null,{"$f":"IF($A11=\"\",\"\",IF($B11=\"\",\"\",IF('4. Compliance'!$B$4=\"Section 11 ECB\",VLOOKUP($A11,'Lighting Lookup'!$E$2:$G$108,2),VLOOKUP($A11,'Lighting Lookup'!$E$2:$G$108,3))))","v":""}]
[null,null,null,null,{"$f":"IF($A12=\"\",\"\",IF($B12=\"\",\"\",IF('4. Compliance'!$B$4=\"Section 11 ECB\",VLOOKUP($A12,'Lighting Lookup'!$E$2:$G$108,2),VLOOKUP($A12,'Lighting Lookup'!$E$2:$G$108,3))))","v":""}]
[null,null,null,null,{"$f":"IF($A13=\"\",\"\",IF($B13=\"\",\"\",IF('4. Compliance'!$B$4=\"Section 11 ECB\",VLOOKUP($A13,'Lighting Lookup'!$E$2:$G$108,2),VLOOKUP($A13,'Lighting Lookup'!$E$2:$G$108,3))))","v":""}]
[null,null,null,null,{"$f":"IF($A14=\"\",\"\",IF($B14=\"\",\"\",IF('4. Compliance'!$B$4=\"Section 11 ECB\",VLOOKUP($A14,'Lighting Lookup'!$E$2:$G$108,2),VLOOKUP($A14,'Lighting Lookup'!$E$2:$G$108,3))))","v":""}]
[null,null,null,null,{"$f":"IF($A15=\"\",\"\",IF($B15=\"\",\"\",IF('4. Compliance'!$B$4=\"Section 11 ECB\",VLOOKUP($A15,'Lighting Lookup'!$E$2:$G$108,2),VLOOKUP($A15,'Lighting Lookup'!$E$2:$G$108,3))))","v":""}]
[null,null,null,null,{"$f":"IF($A16=\"\",\"\",IF($B16=\"\",\"\",IF('4. Compliance'!$B$4=\"Section 11 ECB\",VLOOKUP($A16,'Lighting Lookup'!$E$2:$G$108,2),VLOOKUP($A16,'Lighting Lookup'!$E$2:$G$108,3))))","v":""}]
[null,null,null,null,{"$f":"IF($A17=\"\",\"\",IF($B17=\"\",\"\",IF('4. Compliance'!$B$4=\"Section 11 ECB\",VLOOKUP($A17,'Lighting Lookup'!$E$2:$G$108,2),VLOOKUP($A17,'Lighting Lookup'!$E$2:$G$108,3))))","v":""}]
[null,null,null,null,{"$f":"IF($A18=\"\",\"\",IF($B18=\"\",\"\",IF('4. Compliance'!$B$4=\"Section 11 ECB\",VLOOKUP($A18,'Lighting Lookup'!$E$2:$G$108,2),VLOOKUP($A18,'Lighting Lookup'!$E$2:$G$108,3))))","v":""}]
[null,null,null,null,{"$f":"IF($A19=\"\",\"\",IF($B19=\"\",\"\",IF('4. Compliance'!$B$4=\"Section 11 ECB\",VLOOKUP($A19,'Lighting Lookup'!$E$2:$G$108,2),VLOOKUP($A19,'Lighting Lookup'!$E$2:$G$108,3))))","v":""}]
[null,null,null,null,{"$f":"IF($A20=\"\",\"\",IF($B20=\"\",\"\",IF('4. Compliance'!$B$4=\"Section 11 ECB\",VLOOKUP($A20,'Lighting Lookup'!$E$2:$G$108,2),VLOOKUP($A20,'Lighting Lookup'!$E$2:$G$108,3))))","v":""}]
[null,null,null,null,{"$f":"IF($A21=\"\",\"\",IF($B21=\"\",\"\",IF('4. Compliance'!$B$4=\"Section 11 ECB\",VLOOKUP($A21,'Lighting Lookup'!$E$2:$G$108,2),VLOOKUP($A21,'Lighting Lookup'!$E$2:$G$108,3))))","v":""}]
[null,null,null,null,{"$f":"IF($A22=\"\",\"\",IF($B22=\"\",\"\",IF('4. Compliance'!$B$4=\"Section 11 ECB\",VLOOKUP($A22,'Lighting Lookup'!$E$2:$G$108,2),VLOOKUP($A22,'Lighting Lookup'!$E$2:$G$108,3))))","v":""}]
[null,null,null,null,{"$f":"IF($A23=\"\",\"\",IF($B23=\"\",\"\",IF('4. Compliance'!$B$4=\"Section 11 ECB\",VLOOKUP($A23,'Lighting Lookup'!$E$2:$G$108,2),VLOOKUP($A23,'Lighting Lookup'!$E$2:$G$108,3))))","v":""}]
[null,null,null,null,{"$f":"IF($A24=\"\",\"\",IF($B24=\"\",\"\",IF('4. Compliance'!$B$4=\"Section 11 ECB\",VLOOKUP($A24,'Lighting Lookup'!$E$2:$G$108,2),VLOOKUP($A24,'Lighting Lookup'!$E$2:$G$108,3))))","v":""}]
[null,null,null,null,{"$f":"IF($A25=\"\",\"\",IF($B25=\"\",\"\",IF('4. Compliance'!$B$4=\"Section 11 ECB\",VLOOKUP($A25,'Lighting Lookup'!$E$2:$G$108,2),VLOOKUP($A25,'Lighting Lookup'!$E$2:$G$108,3))))","v":""}]
[null,null,null,null,{"$f":"IF($A26=\"\",\"\",IF($B26=\"\",\"\",IF('4. Compliance'!$B$4=\"Section 11 ECB\",VLOOKUP($A26,'Lighting Lookup'!$E$2:$G$108,2),VLOOKUP($A26,'Lighting Lookup'!$E$2:$G$108,3))))","v":""}]
[null,null,null,null,{"$f":"IF($A27=\"\",\"\",IF($B27=\"\",\"\",IF('4. Compliance'!$B$4=\"Section 11 ECB\",VLOOKUP($A27,'Lighting Lookup'!$E$2:$G$108,2),VLOOKUP($A27,'Lighting Lookup'!$E$2:$G$108,3))))","v":""}]
[null,null,null,null,{"$f":"IF($A28=\"\",\"\",IF($B28=\"\",\"\",IF('4. Compliance'!$B$4=\"Section 11 ECB\",VLOOKUP($A28,'Lighting Lookup'!$E$2:$G$108,2),VLOOKUP($A28,'Lighting Lookup'!$E$2:$G$108,3))))","v":""}]
[null,null,null,null,{"$f":"IF($A29=\"\",\"\",IF($B29=\"\",\"\",IF('4. Compliance'!$B$4=\"Section 11 ECB\",VLOOKUP($A29,'Lighting Lookup'!$E$2:$G$108,2),VLOOKUP($A29,'Lighting Lookup'!$E$2:$G$108,3))))","v":""}]
[null,null,null,null,{"$f":"IF($A30=\"\",\"\",IF($B30=\"\",\"\",IF('4. Compliance'!$B$4=\"Section 11 ECB\",VLOOKUP($A30,'Lighting Lookup'!$E$2:$G$108,2),VLOOKUP($A30,'Lighting Lookup'!$E$2:$G$108,3))))","v":""}]
["Total",{"$f":"SUM(B7:B30)","v":0},null,null,{"$f":"IF(B31=\"\",\"\",SUMPRODUCT(B7:B30,E7:E30)/B31)","v":{"$error":"#DIV/0!"}},null,null,null,null,{"$f":"IF(J7=\"\",\"\",SUMPRODUCT(B7:B30,J7:J30)/B31)","v":""}]

{"sheet":"6d.2 Interior LPD-Bldg  Method","index":17,"n_rows":30,"n_cols":10,"rows_kept":30,"cut":false,"hidden":false,"merged":[[0,1,0,9],[30,0,41,9],[2,0,4,0],[2,1,4,1],[2,2,2,4],[2,5,2,9],[3,2,4,2],[3,3,4,3],[3,5,4,5],[3,6,4,6],[3,8,4,8],[3,9,4,9],[1,0,1,9]]}
["6d.2","Interior LPD: Building Area Method"]
[{"$f":"CONCATENATE(\"Compliance based on \",IF(Path=\"\",\"\",Path))","v":"Compliance based on Section 11 ECB"}]
["Building Area Type (Table 9.5.1)","Total Area  Space/Blg Type (ft2)","Baseline Case",null,null,"Proposed Case"]
[null,null,"Auto. Controls (Yes/No)","Daylight Ctrls (Yes/No)","Modeled LPD","Auto. Controls (Yes/No)","Daylight Ctrls (Yes/No)","Modeled LPD","Supporting Doc. Location","Model Output Report"]
[null,null,null,null,"(W/ft2)",null,null,"(W/ft2)"]
[null,null,null,null,{"$f":"IF($A6=\"\",\"\",IF($B6=\"\",\"\",IF('4. Compliance'!$B$4=\"Section 11 ECB\",VLOOKUP($A6,'Lighting Lookup'!$A$2:$C$33,2),VLOOKUP($A6,'Lighting Lookup'!$A$2:$C$33,3))))","v":""}]
[null,null,null,null,{"$f":"IF($A7=\"\",\"\",IF($B7=\"\",\"\",IF('4. Compliance'!$B$4=\"Section 11 ECB\",VLOOKUP($A7,'Lighting Lookup'!$A$2:$C$33,2),VLOOKUP($A7,'Lighting Lookup'!$A$2:$C$33,3))))","v":""}]
[null,null,null,null,{"$f":"IF($A8=\"\",\"\",IF($B8=\"\",\"\",IF('4. Compliance'!$B$4=\"Section 11 ECB\",VLOOKUP($A8,'Lighting Lookup'!$A$2:$C$33,2),VLOOKUP($A8,'Lighting Lookup'!$A$2:$C$33,3))))","v":""}]
[null,null,null,null,{"$f":"IF($A9=\"\",\"\",IF($B9=\"\",\"\",IF('4. Compliance'!$B$4=\"Section 11 ECB\",VLOOKUP($A9,'Lighting Lookup'!$A$2:$C$33,2),VLOOKUP($A9,'Lighting Lookup'!$A$2:$C$33,3))))","v":""}]
[null,null,null,null,{"$f":"IF($A10=\"\",\"\",IF($B10=\"\",\"\",IF('4. Compliance'!$B$4=\"Section 11 ECB\",VLOOKUP($A10,'Lighting Lookup'!$A$2:$C$33,2),VLOOKUP($A10,'Lighting Lookup'!$A$2:$C$33,3))))","v":""}]
[null,null,null,null,{"$f":"IF($A11=\"\",\"\",IF($B11=\"\",\"\",IF('4. Compliance'!$B$4=\"Section 11 ECB\",VLOOKUP($A11,'Lighting Lookup'!$A$2:$C$33,2),VLOOKUP($A11,'Lighting Lookup'!$A$2:$C$33,3))))","v":""}]
[null,null,null,null,{"$f":"IF($A12=\"\",\"\",IF($B12=\"\",\"\",IF('4. Compliance'!$B$4=\"Section 11 ECB\",VLOOKUP($A12,'Lighting Lookup'!$A$2:$C$33,2),VLOOKUP($A12,'Lighting Lookup'!$A$2:$C$33,3))))","v":""}]
[null,null,null,null,{"$f":"IF($A13=\"\",\"\",IF($B13=\"\",\"\",IF('4. Compliance'!$B$4=\"Section 11 ECB\",VLOOKUP($A13,'Lighting Lookup'!$A$2:$C$33,2),VLOOKUP($A13,'Lighting Lookup'!$A$2:$C$33,3))))","v":""}]
[null,null,null,null,{"$f":"IF($A14=\"\",\"\",IF($B14=\"\",\"\",IF('4. Compliance'!$B$4=\"Section 11 ECB\",VLOOKUP($A14,'Lighting Lookup'!$A$2:$C$33,2),VLOOKUP($A14,'Lighting Lookup'!$A$2:$C$33,3))))","v":""}]
[null,null,null,null,{"$f":"IF($A15=\"\",\"\",IF($B15=\"\",\"\",IF('4. Compliance'!$B$4=\"Section 11 ECB\",VLOOKUP($A15,'Lighting Lookup'!$A$2:$C$33,2),VLOOKUP($A15,'Lighting Lookup'!$A$2:$C$33,3))))","v":""}]
[null,null,null,null,{"$f":"IF($A16=\"\",\"\",IF($B16=\"\",\"\",IF('4. Compliance'!$B$4=\"Section 11 ECB\",VLOOKUP($A16,'Lighting Lookup'!$A$2:$C$33,2),VLOOKUP($A16,'Lighting Lookup'!$A$2:$C$33,3))))","v":""}]
[null,null,null,null,{"$f":"IF($A17=\"\",\"\",IF($B17=\"\",\"\",IF('4. Compliance'!$B$4=\"Section 11 ECB\",VLOOKUP($A17,'Lighting Lookup'!$A$2:$C$33,2),VLOOKUP($A17,'Lighting Lookup'!$A$2:$C$33,3))))","v":""}]
[null,null,null,null,{"$f":"IF($A18=\"\",\"\",IF($B18=\"\",\"\",IF('4. Compliance'!$B$4=\"Section 11 ECB\",VLOOKUP($A18,'Lighting Lookup'!$A$2:$C$33,2),VLOOKUP($A18,'Lighting Lookup'!$A$2:$C$33,3))))","v":""}]
[null,null,null,null,{"$f":"IF($A19=\"\",\"\",IF($B19=\"\",\"\",IF('4. Compliance'!$B$4=\"Section 11 ECB\",VLOOKUP($A19,'Lighting Lookup'!$A$2:$C$33,2),VLOOKUP($A19,'Lighting Lookup'!$A$2:$C$33,3))))","v":""}]
[null,null,null,null,{"$f":"IF($A20=\"\",\"\",IF($B20=\"\",\"\",IF('4. Compliance'!$B$4=\"Section 11 ECB\",VLOOKUP($A20,'Lighting Lookup'!$A$2:$C$33,2),VLOOKUP($A20,'Lighting Lookup'!$A$2:$C$33,3))))","v":""}]
[null,null,null,null,{"$f":"IF($A21=\"\",\"\",IF($B21=\"\",\"\",IF('4. Compliance'!$B$4=\"Section 11 ECB\",VLOOKUP($A21,'Lighting Lookup'!$A$2:$C$33,2),VLOOKUP($A21,'Lighting Lookup'!$A$2:$C$33,3))))","v":""}]
[null,null,null,null,{"$f":"IF($A22=\"\",\"\",IF($B22=\"\",\"\",IF('4. Compliance'!$B$4=\"Section 11 ECB\",VLOOKUP($A22,'Lighting Lookup'!$A$2:$C$33,2),VLOOKUP($A22,'Lighting Lookup'!$A$2:$C$33,3))))","v":""}]
[null,null,null,null,{"$f":"IF($A23=\"\",\"\",IF($B23=\"\",\"\",IF('4. Compliance'!$B$4=\"Section 11 ECB\",VLOOKUP($A23,'Lighting Lookup'!$A$2:$C$33,2),VLOOKUP($A23,'Lighting Lookup'!$A$2:$C$33,3))))","v":""}]
[null,null,null,null,{"$f":"IF($A24=\"\",\"\",IF($B24=\"\",\"\",IF('4. Compliance'!$B$4=\"Section 11 ECB\",VLOOKUP($A24,'Lighting Lookup'!$A$2:$C$33,2),VLOOKUP($A24,'Lighting Lookup'!$A$2:$C$33,3))))","v":""}]
[null,null,null,null,{"$f":"IF($A25=\"\",\"\",IF($B25=\"\",\"\",IF('4. Compliance'!$B$4=\"Section 11 ECB\",VLOOKUP($A25,'Lighting Lookup'!$A$2:$C$33,2),VLOOKUP($A25,'Lighting Lookup'!$A$2:$C$33,3))))","v":""}]
[null,null,null,null,{"$f":"IF($A26=\"\",\"\",IF($B26=\"\",\"\",IF('4. Compliance'!$B$4=\"Section 11 ECB\",VLOOKUP($A26,'Lighting Lookup'!$A$2:$C$33,2),VLOOKUP($A26,'Lighting Lookup'!$A$2:$C$33,3))))","v":""}]
[null,null,null,null,{"$f":"IF($A27=\"\",\"\",IF($B27=\"\",\"\",IF('4. Compliance'!$B$4=\"Section 11 ECB\",VLOOKUP($A27,'Lighting Lookup'!$A$2:$C$33,2),VLOOKUP($A27,'Lighting Lookup'!$A$2:$C$33,3))))","v":""}]
[null,null,null,null,{"$f":"IF($A28=\"\",\"\",IF($B28=\"\",\"\",IF('4. Compliance'!$B$4=\"Section 11 ECB\",VLOOKUP($A28,'Lighting Lookup'!$A$2:$C$33,2),VLOOKUP($A28,'Lighting Lookup'!$A$2:$C$33,3))))","v":""}]
[null,null,null,null,{"$f":"IF($A29=\"\",\"\",IF($B29=\"\",\"\",IF('4. Compliance'!$B$4=\"Section 11 ECB\",VLOOKUP($A29,'Lighting Lookup'!$A$2:$C$33,2),VLOOKUP($A29,'Lighting Lookup'!$A$2:$C$33,3))))","v":""}]
["Total",{"$f":"SUM(B6:B29)","v":0},null,null,{"$f":"IF(B30=\"\",\"\",SUMPRODUCT(B6:B29,E6:E29)/B30)","v":{"$error":"#DIV/0!"}},null,null,{"$f":"IF(H6=\"\",\"\",SUMPRODUCT(B6:B29,H6:H29)/B30)","v":""}]

{"sheet":"6e. Ext LPD","index":18,"n_rows":37,"n_cols":18,"rows_kept":37,"cut":false,"hidden":false,"merged":[[7,0,7,1],[2,0,2,5],[22,1,24,1],[1,1,1,5],[3,0,3,1],[4,0,4,1],[5,0,5,1],[6,0,6,1],[14,1,21,1],[9,2,9,7],[10,2,10,7],[14,2,14,6],[13,2,13,6],[15,2,15,6],[16,2,16,6],[20,2,20,6],[12,10,12,11],[18,2,18,6],[28,0,36,0],[28,1,31,1],[33,2,33,6],[34,2,34,6],[35,2,35,6],[36,2,36,6],[30,5,30,6],[31,2,31,3],[31,5,31,6],[32,2,32,3],[12,2,12,6],[17,2,17,6],[19,2,19,6],[24,2,24,6],[13,0,27,0],[26,1,27,1],[23,2,23,6],[25,2,25,6],[32,10,32,11],[29,2,29,3],[29,5,29,6],[30,2,30,3],[28,2,28,3],[28,5,28,6],[26,2,26,6],[27,2,27,6],[21,2,21,6],[22,2,22,6]]}
[]
["6e","Exterior Lighting  Power"]
[{"$f":"CONCATENATE(\"Compliance based on \",IF(Path=\"\",\"\",Path))","v":"Compliance based on Section 11 ECB"}]
[null,null,"Baseline Design (Watts)","Proposed Design (Watts)","Supporting Doc. Location","Model Output Report"]
["Tradable Lighting Power",null,{"$f":"IF(SUM('6e. Ext LPD'!J14:J28)=0,\"\",SUM('6e. Ext LPD'!J14:J28))","v":""},{"$f":"IF(SUM('6e. Ext LPD'!I14:I28)=0,\"\",SUM('6e. Ext LPD'!I14:I28))","v":""}]
["Non-Tradable Lighting Power",null,{"$f":"IF(SUM('6e. Ext LPD'!J29:J37)=0,\"\",SUM('6e. Ext LPD'!J29:J37))","v":""},{"$f":"IF(SUM('6e. Ext LPD'!I29:I37)=0,\"\",SUM('6e. Ext LPD'!I29:I37))","v":""}]
["Base Site Allowance",null,{"$f":"IF(AND(C5=\"\",C6=\"\"),\"\",'6e. Ext LPD'!B11)","v":""}]
["Total Lighting Power",null,{"$f":"IF(AND(C5=\"\",C6=\"\"),\"\",SUM(C5:C6)+'6e. Ext LPD'!B11)","v":""},{"$f":"IF(AND(D5=\"\",D6=\"\"),\"\",SUM(D5:D6))","v":""}]
[]
[null,3,{"$f":"IF(B10=\"\",\"\",LOOKUP(B10,LZ,LZDEC))","v":"M districts, except MX; C districts, except C5, C6 and C overlays on R"}]
[null,{"$f":"IF(B10=\"\",\"\",IF($B10=\"\",\"\",IF('4. Compliance'!$B$4=\"Section 11 ECB\",VLOOKUP(B10,'Lighting Zones'!B1:D6,3),0)))","v":500},"Base Site Allowance (watts)"]
[]
[null,"Area Type","Area Parameters",null,null,null,null,"Length or Area (FT or SQFT)","Proposed Watts","Baseline Watts","Unit Allowances"]
["Tradable Surfaces","Uncovered Parking Areas","Total area of uncovered parking and drive areas (sq.ft):",null,null,null,null,null,null,{"$f":"IF(H14=\"\",\"\",H14*K14)","v":""},{"$f":"IF($B$10<>\"\",IF($B$10=0,0,IF($B10=\"\",\"\",IF('4. Compliance'!$B$4=\"Section 11 ECB\",IF($B$10=1,0.03,IF($B$10=2,0.04,IF($B$10=3,0.05,0.05))),0.15))))","v":0.05},"W/SF"]
[null,"Building Grounds","Length of walkways less than 10' wide ",null,null,null,null,null,null,"",{"$f":"IF($B$10<>\"\",IF($B$10=0,0,IF($B10=\"\",\"\",IF('4. Compliance'!$B$4=\"Section 11 ECB\",IF($B$10=1,0.5,IF($B$10=2,0.5,IF($B$10=3,0.6,0.7))),1))))","v":0.6},"W/SF"]
[null,null,"Area of walkways greater than 10' wide",null,null,null,null,null,null,"",{"$f":"IF($B$10<>\"\",IF($B$10=0,0,IF($B10=\"\",\"\",IF('4. Compliance'!$B$4=\"Section 11 ECB\",IF($B$10=1,0.1,IF($B$10=2,0.1,IF($B$10=3,0.11,0.14))),0.2))))","v":0.11},"W/SF"]
[null,null,"Plaza areas (sqft)",null,null,null,null,null,null,"",{"$f":"IF($B$10<>\"\",IF($B$10=0,0,IF($B10=\"\",\"\",IF('4. Compliance'!$B$4=\"Section 11 ECB\",IF($B$10=1,0.1,IF($B$10=2,0.1,IF($B$10=3,0.11,0.14))),0.2))))","v":0.11},"W/SF"]
[null,null,"Special feature areas (sqft)",null,null,null,null,null,null,"",{"$f":"IF($B$10<>\"\",IF($B$10=0,0,IF($B10=\"\",\"\",IF('4. Compliance'!$B$4=\"Section 11 ECB\",IF($B$10=1,0.1,IF($B$10=2,0.1,IF($B$10=3,0.11,0.14))),0.2))))","v":0.11},"W/SF"]
[null,null,"Dining ares (sqft)",null,null,null,null,null,null,"",{"$f":"IF($B$10<>\"\",IF($B$10=0,0,IF($B10=\"\",\"\",IF('4. Compliance'!$B$4=\"Section 11 ECB\",IF($B$10=1,0.65,IF($B$10=2,0.65,IF($B$10=3,0.75,0.95))),IF(I19=\"\",\"\",I19/H19)))))","v":0.75},"W/SF"]
[null,null,"Area of stairways (sqft)",null,null,null,null,null,null,"",{"$f":"IF($B$10<>\"\",IF($B$10=0,0,IF($B10=\"\",\"\",IF('4. Compliance'!$B$4=\"Section 11 ECB\",IF($B$10=1,0.6,IF($B$10=2,0.7,IF($B$10=3,0.7,0.7))),1))))","v":0.7},"W/SF"]
[null,null,"Area of pedestrian tunnels (sqft)",null,null,null,null,null,null,"",{"$f":"IF($B$10<>\"\",IF($B$10=0,0,IF($B10=\"\",\"\",IF('4. Compliance'!$B$4=\"Section 11 ECB\",IF($B$10=1,0.12,IF($B$10=2,0.12,IF($B$10=3,0.14,0.21))),IF(H21=\"\",\"\",I21/H21)))))","v":0.14000000000000001},"W/SF"]
[null,null,"Area of landscaping (sq.ft):",null,null,null,null,null,null,"",{"$f":"IF($B$10<>\"\",IF($B$10=0,0,IF($B11=\"\",\"\",IF('4. Compliance'!$B$4=\"Section 11 ECB\",IF($B$10=1,0.12,IF($B$10=2,0.12,IF($B$10=3,0.14,0.21))),IF(H22=\"\",\"\",I22/H22)))))","v":0.14000000000000001},"W/SF"]
[null,"Building Entrances & Exits","Total door width of pedestrian and vehicular entrances and exits  (ft):",null,null,null,null,null,null,"",{"$f":"IF($B$10<>\"\",IF($B$10=0,0,IF($B10=\"\",\"\",IF('4. Compliance'!$B$4=\"Section 11 ECB\",IF($B$10=1,12.6,IF($B$10=2,12.6,IF($B$10=3,20,20))),30))))","v":20},"W/FT"]
[null,null,"Area of entry canopies (sq.ft):",null,null,null,null,null,null,"",{"$f":"IF($B$10<>\"\",IF($B$10=0,0,IF($B13=\"\",\"\",IF('4. Compliance'!$B$4=\"Section 11 ECB\",IF($B$10=1,0.12,IF($B$10=2,0.12,IF($B$10=3,0.14,0.21))),IF(H24=\"\",\"\",I24/H24)))))","v":0.14000000000000001},"W/SF"]
[null,null,"Loading Docks (sq.ft):",null,null,null,null,null,null,"",{"$f":"IF($B$10<>\"\",IF($B$10=0,0,IF($B14=\"\",\"\",IF('4. Compliance'!$B$4=\"Section 11 ECB\",IF($B$10=1,0.12,IF($B$10=2,0.12,IF($B$10=3,0.14,0.21))),IF(H25=\"\",\"\",I25/H25)))))","v":0.14000000000000001},"W/SF"]
[null,"Sales canopies","Free standing and attached (sq.ft): ",null,null,null,null,null,null,"",{"$f":"IF($B$10<>\"\",IF($B$10=0,0,IF($B15=\"\",\"\",IF('4. Compliance'!$B$4=\"Section 11 ECB\",IF($B$10=1,0.12,IF($B$10=2,0.12,IF($B$10=3,0.14,0.21))),IF(H26=\"\",\"\",I26/H26)))))","v":0.14000000000000001},"W/SF"]
[null,"Outdoor sales areas","Open areas (including vehicle sales and lots) (sq.ft):",null,null,null,null,null,null,"",{"$f":"IF($B$10<>\"\",IF($B$10=0,0,IF($B10=\"\",\"\",IF('4. Compliance'!$B$4=\"Section 11 ECB\",IF($B$10=1,0.2,IF($B$10=2,0.2,IF($B$10=3,0.35,0.5))),0.5))))","v":0.35},"W/SF"]
[null,null,"Total length of street frontage for vehicle sales (ft):",null,null,null,null,null,null,"",{"$f":"IF($B$10<>\"\",IF($B$10=0,0,IF($B10=\"\",\"\",IF('4. Compliance'!$B$4=\"Section 11 ECB\",IF($B$10=1,0,IF($B$10=2,7,IF($B$10=3,7,21))),20))))","v":7},"W/FT"]
["Non Tradable Surfaces","Building façades","Area of façade #1 (sqft)",null,null,"Length of façade #1 (ft)",null,null,null,{"$f":"IF(AND(E29=\"\",H29=\"\"),\"\",IF(Path=\"Section 11 ECB\",E29*O29+H29*P29,I29))","v":""},{"$f":"IF(Path=\"Section 11 ECB\",IF($B$10<>\"\",IF($B$10=0,0,IF($B$10=1,0,IF($B$10=2,IF(Q29>R29,O29,P29),IF($B$10=3,IF(Q29>R29,O29,P29),IF(Q29>R29,O29,P29))))),\"\"),\"\")","v":3.75},{"$f":"IF($B$10<>\"\",IF($B$10=0,0,IF($B$10=1,0,IF($B$10=2,IF(Q29>R29,\"W/SF\",\"W/FT\"),IF($B$10=3,IF(Q29>R29,\"W/SF\",\"W/FT\"),IF(Q29>R29,\"W/SF\",\"W/FT\"))))),\"\")","v":"W/FT"},null,null,{"$f":"IF($B$10<>\"\",IF($B$10=0,0,IF($B$10=\"\",\"\",IF('4. Compliance'!$B$4=\"Section 11 ECB\",IF($B$10=1,0,IF($B$10=2,0.1,IF($B$10=3,0.15,0.2))),E29))))","v":0.15},{"$f":"IF($B$10<>\"\",IF($B$10=0,0,IF($B$10=\"\",\"\",IF('4. Compliance'!$B$4=\"Section 11 ECB\",IF($B$10=1,0,IF($B$10=2,2.5,IF($B$10=3,3.75,5))),H29))))","v":3.75},{"$f":"O29*E29","v":0},{"$f":"H29*P29","v":0}]
[null,null,"Area of façade #2 (sqft)",null,null,"Length of façade #2 (ft)",null,null,null,{"$f":"IF(AND(E30=\"\",H30=\"\"),\"\",IF(Path=\"Section 11 ECB\",E30*O30+H30*P30,I30))","v":""},{"$f":"IF(Path=\"Section 11 ECB\",IF($B$10<>\"\",IF($B$10=0,0,IF($B$10=1,0,IF($B$10=2,IF(Q30>R30,O30,P30),IF($B$10=3,IF(Q30>R30,O30,P30),IF(Q30>R30,O30,P30))))),\"\"),\"\")","v":3.75},{"$f":"IF($B$10<>\"\",IF($B$10=0,0,IF($B$10=1,0,IF($B$10=2,IF(Q30>R30,\"W/SF\",\"W/FT\"),IF($B$10=3,IF(Q30>R30,\"W/SF\",\"W/FT\"),IF(Q30>R30,\"W/SF\",\"W/FT\"))))),\"\")","v":"W/FT"},null,null,{"$f":"IF($B$10<>\"\",IF($B$10=0,0,IF($B$10=\"\",\"\",IF('4. Compliance'!$B$4=\"Section 11 ECB\",IF($B$10=1,0,IF($B$10=2,0.1,IF($B$10=3,0.15,0.2))),E30))))","v":0.15},{"$f":"IF($B$10<>\"\",IF($B$10=0,0,IF($B$10=\"\",\"\",IF('4. Compliance'!$B$4=\"Section 11 ECB\",IF($B$10=1,0,IF($B$10=2,2.5,IF($B$10=3,3.75,5))),H30))))","v":3.75},{"$f":"O30*E30","v":0},{"$f":"H30*P30","v":0}]
[null,null,"Area of façade #3 (sqft)",null,null,"Length of façade #3 (ft)",null,null,null,{"$f":"IF(AND(E31=\"\",H31=\"\"),\"\",IF(Path=\"Section 11 ECB\",E31*O31+H31*P31,I31))","v":""},{"$f":"IF(Path=\"Section 11 ECB\",IF($B$10<>\"\",IF($B$10=0,0,IF($B$10=1,0,IF($B$10=2,IF(Q31>R31,O31,P31),IF($B$10=3,IF(Q31>R31,O31,P31),IF(Q31>R31,O31,P31))))),\"\"),\"\")","v":3.75},{"$f":"IF($B$10<>\"\",IF($B$10=0,0,IF($B$10=1,0,IF($B$10=2,IF(Q31>R31,\"W/SF\",\"W/FT\"),IF($B$10=3,IF(Q31>R31,\"W/SF\",\"W/FT\"),IF(Q31>R31,\"W/SF\",\"W/FT\"))))),\"\")","v":"W/FT"},null,null,{"$f":"IF($B$10<>\"\",IF($B$10=0,0,IF($B$10=\"\",\"\",IF('4. Compliance'!$B$4=\"Section 11 ECB\",IF($B$10=1,0,IF($B$10=2,0.1,IF($B$10=3,0.15,0.2))),E31))))","v":0.15},{"$f":"IF($B$10<>\"\",IF($B$10=0,0,IF($B$10=\"\",\"\",IF('4. Compliance'!$B$4=\"Section 11 ECB\",IF($B$10=1,0,IF($B$10=2,2.5,IF($B$10=3,3.75,5))),H31))))","v":3.75},{"$f":"O31*E31","v":0},{"$f":"H31*P31","v":0}]
[null,null,"Area of façade #4 (sqft)",null,null,"Length of façade #4 (ft)",null,null,null,{"$f":"IF(AND(E32=\"\",H32=\"\"),\"\",IF(Path=\"Section 11 ECB\",E32*O32+H32*P32,I32))","v":""},{"$f":"IF(Path=\"Section 11 ECB\",IF($B$10<>\"\",IF($B$10=0,0,IF($B$10=1,0,IF($B$10=2,IF(Q32>R32,O32,P32),IF($B$10=3,IF(Q32>R32,O32,P32),IF(Q32>R32,O32,P32))))),\"\"),\"\")","v":3.75},{"$f":"IF($B$10<>\"\",IF($B$10=0,0,IF($B$10=1,0,IF($B$10=2,IF(Q32>R32,\"W/SF\",\"W/FT\"),IF($B$10=3,IF(Q32>R32,\"W/SF\",\"W/FT\"),IF(Q32>R32,\"W/SF\",\"W/FT\"))))),\"\")","v":"W/FT"},null,null,{"$f":"IF($B$10<>\"\",IF($B$10=0,0,IF($B$10=\"\",\"\",IF('4. Compliance'!$B$4=\"Section 11 ECB\",IF($B$10=1,0,IF($B$10=2,0.1,IF($B$10=3,0.15,0.2))),E32))))","v":0.15},{"$f":"IF($B$10<>\"\",IF($B$10=0,0,IF($B$10=\"\",\"\",IF('4. Compliance'!$B$4=\"Section 11 ECB\",IF($B$10=1,0,IF($B$10=2,2.5,IF($B$10=3,3.75,5))),5))))","v":3.75},{"$f":"O32*E32","v":0},{"$f":"H32*P32","v":0}]
[null,"ATMs","# of Locations:",null,null,null,"Total # of ATMs:",null,null,"",{"$f":"IF(Path=\"Section 11 ECB\",IF($B$10<>\"\",IF($B$10=0,\"No allowance\",\"Allowance = 135W per location plus 45W per additional ATM per location.\"),\"\"),\"\")","v":"Allowance = 135W per location plus 45W per additional ATM per location."}]
[null,"Guarded facility entrances","Area of uncovered entrances and gatehouse inspection areas at guarded facilities (sq.ft):",null,null,null,null,null,null,"",{"$f":"IF($B$10<>\"\",IF($B$10=0,0,IF($B10=\"\",\"\",IF(Path=\"Section 11 ECB\",IF($B$10=1,0.12,IF($B$10=2,0.12,IF($B$10=3,0.14,0.21))),\"\"))))","v":0.14000000000000001},{"$f":"IF($B$10<>\"\",IF($B$10=0,0,IF($B$10=1,0,IF($B$10=2,IF(Q34>R34,\"W/SF\",\"W/FT\"),IF($B$10=3,IF(Q34>R34,\"W/SF\",\"W/FT\"),IF(Q34>R34,\"W/SF\",\"W/FT\"))))),\"\")","v":"W/FT"}]
[null,"Emergency Vehicle Loading Area","Area of uncovered loading areas for emergency service vehicles (sq.ft):",null,null,null,null,null,null,"",{"$f":"IF($B$10<>\"\",IF($B$10=0,0,IF($B10=\"\",\"\",IF(Path=\"Section 11 ECB\",IF($B$10=1,0.12,IF($B$10=2,0.12,IF($B$10=3,0.14,0.21))),\"\"))))","v":0.14000000000000001},{"$f":"IF($B$10<>\"\",IF($B$10=0,0,IF($B$10=1,0,IF($B$10=2,IF(Q35>R35,\"W/SF\",\"W/FT\"),IF($B$10=3,IF(Q35>R35,\"W/SF\",\"W/FT\"),IF(Q35>R35,\"W/SF\",\"W/FT\"))))),\"\")","v":"W/FT"}]
[null,"Drive-throughs","# of drive-throughs:",null,null,null,null,null,null,"",{"$f":"IF($B$10<>\"\",IF($B$10=0,0,IF(Path=\"Section 11 ECB\",IF($B$10=1,200,IF($B$10=2,200,IF($B$10=3,200,400))),\"\")))","v":200},"Watts/drive thru"]
[null,"Parking near 24-hour retail entrances (main only)","# of main entrances:",null,null,null,null,null,null,"",{"$f":"IF($B$10<>\"\",IF($B$10=0,0,IF(Path=\"Section 11 ECB\",IF($B$10=1,400,IF($B$10=2,400,IF($B$10=3,400,400))),\"\")))","v":400},"Watts/entrance"]

{"sheet":"6f. Process Equip.","index":19,"n_rows":43,"n_cols":9,"rows_kept":43,"cut":false,"hidden":false,"merged":[[35,0,35,1],[9,0,9,1],[10,0,10,1],[11,0,11,1],[41,0,41,1],[34,0,34,1],[42,0,42,1],[16,1,16,8],[2,1,2,8],[23,0,23,1],[37,0,37,1],[38,0,38,1],[39,0,39,1],[40,0,40,1],[20,0,20,1],[21,0,21,1],[7,0,7,1],[8,0,8,1],[22,0,22,1],[17,0,18,1],[19,0,19,1],[5,0,5,1],[3,0,4,1],[24,0,24,1],[25,0,25,1],[36,0,36,1],[14,0,14,1],[6,0,6,1],[13,0,13,1],[12,0,12,1],[26,0,26,1],[27,0,27,1],[28,0,28,1],[29,0,29,1],[30,0,30,1],[31,0,31,1],[32,0,32,1],[33,0,33,1]]}
[]
[]
["6f.1","Miscellaneous Equipment - Regulated"]
["Space Type (or Equipment Type)",null,"Space Area (or # Equip.)","Equipment Power Density (W/SF) or (Equip Demand)","Annual kwh","Modeling Parameters/\nSchedule","Baseline Modeled Identically? (Yes/No)","Supporting Doc. Location","Model Output Report"]
[null,null,"#",{"$f":"IF(C5=\"\",\"\",IF(C5=\"#\",\"kW\",\"W/SF\"))","v":"kW"},"kwh"]
["Elevators"]
["Escalators"]
["Comm. Kitchen Equip"]
["Office Receptacles"]
[]
[]
[]
[]
[]
["TOTAL",null,{"$f":"IF(SUM(C6:C14)=0,\"\",SUM(C6:C14))","v":""},{"$f":"IF(SUM(D6:D14)=0,\"\",IF(D5=\"W/SF\",SUMPRODUCT($C$6:$C$14,$D$6:$D$14)/1000,SUMPRODUCT($C$6:$C$14,$D$6:$D$14)))","v":""},{"$f":"IF(E6=\"\",\"\",SUM(E14))","v":""}]
[]
["6f.2","Miscellaneous Equipment - Un-Regulated"]
["Space Type (or Equipment Type)",null,"Space Area (or # Equip.)","Equipment Power Density (W/SF) or (Equip Demand)","Annual kwh","Modeling Parameters/\nSchedule","Baseline Modeled Identically? (Yes/No)","Supporting Doc. Location","Model Output Report"]
[null,null,"SQFT",{"$f":"IF(C19=\"\",\"\",IF(C19=\"#\",\"kW\",\"W/SF\"))","v":"W/SF"},"kwh"]
[null,null,{"$f":"IF('6d.1 Interior LPD-Space Method'!B7<>\"\",'6d.1 Interior LPD-Space Method'!B7,\"\")","v":""}]
[{"$f":"IF('6d.1 Interior LPD-Space Method'!A8<>\"\",'6d.1 Interior LPD-Space Method'!A8,\"\")","v":""},null,{"$f":"IF('6d.1 Interior LPD-Space Method'!B8<>\"\",'6d.1 Interior LPD-Space Method'!B8,\"\")","v":""}]
[{"$f":"IF('6d.1 Interior LPD-Space Method'!A9<>\"\",'6d.1 Interior LPD-Space Method'!A9,\"\")","v":""},null,{"$f":"IF('6d.1 Interior LPD-Space Method'!B9<>\"\",'6d.1 Interior LPD-Space Method'!B9,\"\")","v":""}]
[{"$f":"IF('6d.1 Interior LPD-Space Method'!A10<>\"\",'6d.1 Interior LPD-Space Method'!A10,\"\")","v":""},null,{"$f":"IF('6d.1 Interior LPD-Space Method'!B10<>\"\",'6d.1 Interior LPD-Space Method'!B10,\"\")","v":""}]
[{"$f":"IF('6d.1 Interior LPD-Space Method'!A11<>\"\",'6d.1 Interior LPD-Space Method'!A11,\"\")","v":""},null,{"$f":"IF('6d.1 Interior LPD-Space Method'!B11<>\"\",'6d.1 Interior LPD-Space Method'!B11,\"\")","v":""}]
[{"$f":"IF('6d.1 Interior LPD-Space Method'!A12<>\"\",'6d.1 Interior LPD-Space Method'!A12,\"\")","v":""},null,{"$f":"IF('6d.1 Interior LPD-Space Method'!B12<>\"\",'6d.1 Interior LPD-Space Method'!B12,\"\")","v":""}]
[{"$f":"IF('6d.1 Interior LPD-Space Method'!A13<>\"\",'6d.1 Interior LPD-Space Method'!A13,\"\")","v":""},null,{"$f":"IF('6d.1 Interior LPD-Space Method'!B13<>\"\",'6d.1 Interior LPD-Space Method'!B13,\"\")","v":""}]
[{"$f":"IF('6d.1 Interior LPD-Space Method'!A14<>\"\",'6d.1 Interior LPD-Space Method'!A14,\"\")","v":""},null,{"$f":"IF('6d.1 Interior LPD-Space Method'!B14<>\"\",'6d.1 Interior LPD-Space Method'!B14,\"\")","v":""}]
[{"$f":"IF('6d.1 Interior LPD-Space Method'!A15<>\"\",'6d.1 Interior LPD-Space Method'!A15,\"\")","v":""},null,{"$f":"IF('6d.1 Interior LPD-Space Method'!B15<>\"\",'6d.1 Interior LPD-Space Method'!B15,\"\")","v":""}]
[{"$f":"IF('6d.1 Interior LPD-Space Method'!A16<>\"\",'6d.1 Interior LPD-Space Method'!A16,\"\")","v":""},null,{"$f":"IF('6d.1 Interior LPD-Space Method'!B16<>\"\",'6d.1 Interior LPD-Space Method'!B16,\"\")","v":""}]
[{"$f":"IF('6d.1 Interior LPD-Space Method'!A17<>\"\",'6d.1 Interior LPD-Space Method'!A17,\"\")","v":""},null,{"$f":"IF('6d.1 Interior LPD-Space Method'!B17<>\"\",'6d.1 Interior LPD-Space Method'!B17,\"\")","v":""}]
[{"$f":"IF('6d.1 Interior LPD-Space Method'!A18<>\"\",'6d.1 Interior LPD-Space Method'!A18,\"\")","v":""},null,{"$f":"IF('6d.1 Interior LPD-Space Method'!B18<>\"\",'6d.1 Interior LPD-Space Method'!B18,\"\")","v":""}]
[{"$f":"IF('6d.1 Interior LPD-Space Method'!A19<>\"\",'6d.1 Interior LPD-Space Method'!A19,\"\")","v":""},null,{"$f":"IF('6d.1 Interior LPD-Space Method'!B19<>\"\",'6d.1 Interior LPD-Space Method'!B19,\"\")","v":""}]
[{"$f":"IF('6d.1 Interior LPD-Space Method'!A20<>\"\",'6d.1 Interior LPD-Space Method'!A20,\"\")","v":""},null,{"$f":"IF('6d.1 Interior LPD-Space Method'!B20<>\"\",'6d.1 Interior LPD-Space Method'!B20,\"\")","v":""}]
[{"$f":"IF('6d.1 Interior LPD-Space Method'!A21<>\"\",'6d.1 Interior LPD-Space Method'!A21,\"\")","v":""},null,{"$f":"IF('6d.1 Interior LPD-Space Method'!B21<>\"\",'6d.1 Interior LPD-Space Method'!B21,\"\")","v":""}]
[{"$f":"IF('6d.1 Interior LPD-Space Method'!A22<>\"\",'6d.1 Interior LPD-Space Method'!A22,\"\")","v":""},null,{"$f":"IF('6d.1 Interior LPD-Space Method'!B22<>\"\",'6d.1 Interior LPD-Space Method'!B22,\"\")","v":""}]
[{"$f":"IF('6d.1 Interior LPD-Space Method'!A23<>\"\",'6d.1 Interior LPD-Space Method'!A23,\"\")","v":""},null,{"$f":"IF('6d.1 Interior LPD-Space Method'!B23<>\"\",'6d.1 Interior LPD-Space Method'!B23,\"\")","v":""}]
[{"$f":"IF('6d.1 Interior LPD-Space Method'!A24<>\"\",'6d.1 Interior LPD-Space Method'!A24,\"\")","v":""},null,{"$f":"IF('6d.1 Interior LPD-Space Method'!B24<>\"\",'6d.1 Interior LPD-Space Method'!B24,\"\")","v":""}]
[{"$f":"IF('6d.1 Interior LPD-Space Method'!A25<>\"\",'6d.1 Interior LPD-Space Method'!A25,\"\")","v":""},null,{"$f":"IF('6d.1 Interior LPD-Space Method'!B25<>\"\",'6d.1 Interior LPD-Space Method'!B25,\"\")","v":""}]
[{"$f":"IF('6d.1 Interior LPD-Space Method'!A26<>\"\",'6d.1 Interior LPD-Space Method'!A26,\"\")","v":""},null,{"$f":"IF('6d.1 Interior LPD-Space Method'!B26<>\"\",'6d.1 Interior LPD-Space Method'!B26,\"\")","v":""}]
[{"$f":"IF('6d.1 Interior LPD-Space Method'!A27<>\"\",'6d.1 Interior LPD-Space Method'!A27,\"\")","v":""},null,{"$f":"IF('6d.1 Interior LPD-Space Method'!B27<>\"\",'6d.1 Interior LPD-Space Method'!B27,\"\")","v":""}]
[{"$f":"IF('6d.1 Interior LPD-Space Method'!A28<>\"\",'6d.1 Interior LPD-Space Method'!A28,\"\")","v":""},null,{"$f":"IF('6d.1 Interior LPD-Space Method'!B28<>\"\",'6d.1 Interior LPD-Space Method'!B28,\"\")","v":""}]
[{"$f":"IF('6d.1 Interior LPD-Space Method'!A29<>\"\",'6d.1 Interior LPD-Space Method'!A29,\"\")","v":""},null,{"$f":"IF('6d.1 Interior LPD-Space Method'!B29<>\"\",'6d.1 Interior LPD-Space Method'!B29,\"\")","v":""}]
["TOTAL",null,{"$f":"IF(SUM(C20:C42)=0,\"\",SUM(C20:C42))","v":""},{"$f":"IF(SUM(D20:D42)=0,\"\",IF(D19=\"W/SF\",SUMPRODUCT($C$6:$C$14,$D$6:$D$14)/1000,SUMPRODUCT($C$6:$C$14,$D$6:$D$14)))","v":""},{"$f":"IF(E20=\"\",\"\",SUM(E24))","v":""}]

{"sheet":"6g. Service HW","index":20,"n_rows":16,"n_cols":8,"rows_kept":16,"cut":false,"hidden":false,"merged":[[16,0,34,7],[15,0,15,1],[4,2,4,3],[3,0,4,1],[9,0,9,1],[13,4,13,5],[13,2,13,3],[12,0,12,1],[13,0,13,1],[15,2,15,7],[1,1,1,7],[5,0,5,1],[5,2,5,3],[10,0,10,1],[11,0,11,1],[5,4,5,5],[6,0,6,1],[7,0,7,1],[8,0,8,1],[2,0,2,7]]}
[]
["6g.","Service Hot Water Systems"]
[{"$f":"CONCATENATE(\"Compliance based on \",IF(Path=\"\",\"\",Path))","v":"Compliance based on Section 11 ECB"}]
["Model Input Parameter",null,"Baseline Design","Units","Proposed Design","Units","Supporting Doc Location","Model Output Report"]
[null,null,"Multifamily"]
["System Type & Fuel",null,{"$f":"IF(E6=\"\",\"\",IF($C$5=\"\",\"\",IF(Path=\"Section 11 ECB\",E6,VLOOKUP(C5,Lists!$A$95:$B$128,2))))","v":""},null,null,null,null,"PV-A"]
["Input Rating",null,null,"kBtu/h",null,"kBtu/h",null,"PV-A"]
["Efficiency",null,null,"EF",null,"Et",null,"PV-A"]
["Storage Volume",null,null,"Gal",null,"Gal",null,"PV-A"]
["Storage Temperature",null,null,"°F",null,"°F",null,"PV-A"]
["Peak HW Demand",null,null,"GPM",null,"GPM",null,"PV-A"]
["Number of Primary DHW pumps",null,null,"#",null,"#",null,"PV-A"]
["Primary DHW Pump Power",null,null,"kW",null,"kW",null,"PV-A"]
["Primary DHW Pump Control",null,null,null,null,null,null,"PV-A"]
[]
["6h    HVAC and SHW Narrative",null,"Please provide a narrative of the building's heating, cooling, ventilation & service hot water systems"]

{"sheet":"Instructions for HVAC_Cover","index":21,"n_rows":44,"n_cols":13,"rows_kept":44,"cut":false,"hidden":false,"merged":[[6,12,6,16],[7,12,7,16],[8,12,8,16],[9,12,9,16],[1,0,5,9],[1,12,1,16],[2,12,2,16],[3,12,3,16],[4,12,4,16],[5,12,5,16]]}
[]
["Overview: The HVAC portion of this table is partially automated by using Excel Macros. It is important that the information is entered completely and sequentially. The Macro will create HVAC Air-side Sheets for each Row of HVAC information. For example, the information input on Row 4 will be transferred to a newly created HVAC Air-side Tab. Once there is no information in a Row, the program will stop running.",null,null,null,null,null,null,null,null,null,null,null,"WORKBOOK COLOR LEGEND"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Do not edit:  information"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Do not edit:  formulas"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Do not edit:  error"]
[null,null,null,null,null,null,null,null,null,null,null,null,"User edit:  required information"]
[null,null,null,null,null,null,null,null,null,null,null,null,"User edit:  drop-down menu"]
[null,null,null,null,null,null,null,null,null,null,null,null,"User edit: drop-down menu (only for use with Appendix G)"]
["1.       Clear all data fields",null,null,null,null,null,null,null,null,null,null,null,"User edit: formula + drop-down menu"]
["a.       Clear the HVAC Cover sheet by pressing on the ‘Reset’ button (cell G15)",null,null,null,null,null,null,null,null,null,null,null,"User edit:  fill in box"]
["b.       After the prompt “This will erase everything you have filled in. Are you sure?” Click Yes"]
["c.       This will erase all data fields in ‘HVAC Cover’ and ‘HVAC Air-side’ tabs"]
["2.       Filling in System information (Section 11)"]
["a.       The first proposed system must be input on Row 4."]
["b.       Select the proposed system type from the drop down list in Column C  - this will automatically populate the ‘Proposed Building Classification’ and ‘Baseline Systems’ (columns G, H, I & J)"]
["c.       Check the information in Columns G, H & I – if the pre-populated information is not correct, select the correct information from the drop-down list in each column"]
["d.       Input the name of the HVAC system that corresponds with the M-dwgs into Column D"]
["e.       Input the name of the HVAC system that corresponds to the Baseline system in the modeling reports into Column E"]
["f.        Input the name of the HVAC system that corresponds to the Proposed system in the modeling reports into Column F"]
["g.       Repeat steps b through f until all proposed systems are input. Leaving spaces between rows will cause an error."]
["3.       Filling in System information (Appendix G)"]
["a.       The first proposed system must be input on Row 4."]
["b.       Select the Building Area Type in Column B associated with the proposed system."]
["c.       Select the proposed system type from the drop down list in Column C  - this will automatically populate the ‘Proposed Building Classification’ and ‘Baseline Systems’ (columns G, H, I & J)"]
["d.       Check the information in Columns G, H & I – if the pre-populated information is not correct, select the correct information from the drop-down list in each column"]
["e.       Input the name of the HVAC system that corresponds with the M-dwgs into Column D"]
["f.        Input the name of the HVAC system that corresponds to the Baseline system in the modeling reports into Column E"]
["g.       Input the name of the HVAC system that corresponds to the Proposed system in the modeling reports into Column F"]
["h.       Repeat steps b through f until all proposed systems are input. Leaving spaces between rows will cause an error."]
["4.       Creating HVAC Air-Side Tabs"]
["a.       After all of the proposed systems are entered correctly into Rows 4 through 13, click on the ‘Create New HVAC’ button."]
["b.       After the prompt “Are you done filling in system types?” Click Yes."]
["c.    The tab 'HVAC Air-Side' will be filled out with information from Row 5. New HVAC Air-side tabs will be created and filled out.    "]
["5.  Adding new systems to HVAC_Cover Tab after running the Macro (Steps 1-4 above)"]
["a.   Once the button \"Create New HVAC\" is pressed, it will generate an \"HVAC Air-side\" tab for each individual system"]
["b.   If a new HVAC system must be added to HVAC_Cover, after the \"Create New HVAC\" button is pressed, it will create ALL of the HVAC systems again"]
["c.   For example, initially HVAC systems 1 through 4 were list on HVAC_Cover and generated new tabs HVAC Air-side 1, 2, 3, and 4. If you now need to add an HVAC system 5 to "]
["HVAC_Cover, the program will generate HVAC Air-side 1, 2, 3, 4 and 5, and you will have duplicates of the initially generated HVAC 1, 2, 3, and 4.  One of each of the "]
["d.  To manually delete a tab, right click on the tab name, select 'Delete'. This will need to be performed for each of the duplicate air-side tabs."]
["e.   DO NOT DELETE the tab titled \"HVAC Air-Side\" (located to the right of \"HVAC_Cover\") - this will cause the Macro to crash and you will have to start over."]
["6. Additional Important Information"]
["a.   To rename an HVAC Air-Side generated tab, right click on the tab name, select 'Rename', and type in the new name."]
["b.   DO NOT RENAME the tab titled \"HVAC Air-Side\" (located to the right of \"HVAC_Cover\") - this will cause the Macro to crash and you may have to start over ."]
["c.    DO NOT RENAME the tab titled \"HVAC_Cover\" - this will cause the Macro to crash and you may have to start over."]

{"sheet":"HVAC_Cover","index":22,"n_rows":25,"n_cols":11,"rows_kept":25,"cut":false,"hidden":false,"merged":[[1,6,1,8],[1,9,2,9],[1,1,1,5]]}
[]
[null,"HVAC Cover Sheet",null,null,null,null,"Proposed Building Classification (auto-populated + drop-down)",null,null,{"$f":"CONCATENATE(\"Baseline systems correspond to \",IF(Path=\"\",\"\",Path))","v":"Baseline systems correspond to Section 11 ECB"}]
[null,{"$f":"IF(Path=\"Appendix G PRM\", \"Building Area Type (Only used for Appendix G)\", \"This column not used for Section 11 projects\")","v":"This column not used for Section 11 projects"},"Proposed System Design","System Name in Mechanical Schedule","System Name in Model Reports (baseline)","System Name in Model Reports (proposed)",{"$f":"IF(TRUE, \"Condenser Cooling Source\", \"Section 11 Column\")","v":"Condenser Cooling Source"},"Heating System Classifcation","Zone Classification",null,{"$f":"Path","v":"Section 11 ECB"}]
[null,null,null,null,null,null,{"$f":"IFERROR(IF(TRUE, VLOOKUP($C4,Lists!$J$75:$O$88,4,FALSE),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(TRUE, VLOOKUP($C4,Lists!$J$75:$O$88,6,FALSE),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(TRUE, VLOOKUP($C4,Lists!$J$75:$O$88,5,FALSE),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(Path=\"Appendix G PRM\", VLOOKUP($B4,Lists!$A$73:$B$81,2,FALSE),IFERROR(VLOOKUP(CONCATENATE(G:G,H:H,I:I), Lists!$S$81:$W$98,5,FALSE),\"\")),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IFERROR(IF(TRUE, VLOOKUP($C5,Lists!$J$75:$O$88,4,FALSE),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(TRUE, VLOOKUP($C5,Lists!$J$75:$O$88,6,FALSE),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(TRUE, VLOOKUP($C5,Lists!$J$75:$O$88,5,FALSE),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(Path=\"Appendix G PRM\", VLOOKUP($B5,Lists!$A$73:$B$81,2,FALSE),IFERROR(VLOOKUP(CONCATENATE(G:G,H:H,I:I), Lists!$S$81:$W$98,5,FALSE),\"\")),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IFERROR(IF(TRUE, VLOOKUP($C6,Lists!$J$75:$O$88,4,FALSE),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(TRUE, VLOOKUP($C6,Lists!$J$75:$O$88,6,FALSE),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(TRUE, VLOOKUP($C6,Lists!$J$75:$O$88,5,FALSE),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(Path=\"Appendix G PRM\", VLOOKUP($B6,Lists!$A$73:$B$81,2,FALSE),IFERROR(VLOOKUP(CONCATENATE(G:G,H:H,I:I), Lists!$S$81:$W$98,5,FALSE),\"\")),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IFERROR(IF(TRUE, VLOOKUP($C7,Lists!$J$75:$O$88,4,FALSE),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(TRUE, VLOOKUP($C7,Lists!$J$75:$O$88,6,FALSE),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(TRUE, VLOOKUP($C7,Lists!$J$75:$O$88,5,FALSE),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(Path=\"Appendix G PRM\", VLOOKUP($B7,Lists!$A$73:$B$81,2,FALSE),IFERROR(VLOOKUP(CONCATENATE(G:G,H:H,I:I), Lists!$S$81:$W$98,5,FALSE),\"\")),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IFERROR(IF(TRUE, VLOOKUP($C8,Lists!$J$75:$O$88,4,FALSE),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(TRUE, VLOOKUP($C8,Lists!$J$75:$O$88,6,FALSE),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(TRUE, VLOOKUP($C8,Lists!$J$75:$O$88,5,FALSE),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(Path=\"Appendix G PRM\", VLOOKUP($B8,Lists!$A$73:$B$81,2,FALSE),IFERROR(VLOOKUP(CONCATENATE(G:G,H:H,I:I), Lists!$S$81:$W$98,5,FALSE),\"\")),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IFERROR(IF(TRUE, VLOOKUP($C9,Lists!$J$75:$O$88,4,FALSE),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(TRUE, VLOOKUP($C9,Lists!$J$75:$O$88,6,FALSE),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(TRUE, VLOOKUP($C9,Lists!$J$75:$O$88,5,FALSE),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(Path=\"Appendix G PRM\", VLOOKUP($B9,Lists!$A$73:$B$81,2,FALSE),IFERROR(VLOOKUP(CONCATENATE(G:G,H:H,I:I), Lists!$S$81:$W$98,5,FALSE),\"\")),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IFERROR(IF(TRUE, VLOOKUP($C10,Lists!$J$75:$O$88,4,FALSE),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(TRUE, VLOOKUP($C10,Lists!$J$75:$O$88,6,FALSE),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(TRUE, VLOOKUP($C10,Lists!$J$75:$O$88,5,FALSE),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(Path=\"Appendix G PRM\", VLOOKUP($B10,Lists!$A$73:$B$81,2,FALSE),IFERROR(VLOOKUP(CONCATENATE(G:G,H:H,I:I), Lists!$S$81:$W$98,5,FALSE),\"\")),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IFERROR(IF(TRUE, VLOOKUP($C11,Lists!$J$75:$O$88,4,FALSE),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(TRUE, VLOOKUP($C11,Lists!$J$75:$O$88,6,FALSE),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(TRUE, VLOOKUP($C11,Lists!$J$75:$O$88,5,FALSE),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(Path=\"Appendix G PRM\", VLOOKUP($B11,Lists!$A$73:$B$81,2,FALSE),IFERROR(VLOOKUP(CONCATENATE(G:G,H:H,I:I), Lists!$S$81:$W$98,5,FALSE),\"\")),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IFERROR(IF(TRUE, VLOOKUP($C12,Lists!$J$75:$O$88,4,FALSE),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(TRUE, VLOOKUP($C12,Lists!$J$75:$O$88,6,FALSE),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(TRUE, VLOOKUP($C12,Lists!$J$75:$O$88,5,FALSE),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(Path=\"Appendix G PRM\", VLOOKUP($B12,Lists!$A$73:$B$81,2,FALSE),IFERROR(VLOOKUP(CONCATENATE(G:G,H:H,I:I), Lists!$S$81:$W$98,5,FALSE),\"\")),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IFERROR(IF(TRUE, VLOOKUP($C13,Lists!$J$75:$O$88,4,FALSE),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(TRUE, VLOOKUP($C13,Lists!$J$75:$O$88,6,FALSE),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(TRUE, VLOOKUP($C13,Lists!$J$75:$O$88,5,FALSE),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(Path=\"Appendix G PRM\", VLOOKUP($B13,Lists!$A$73:$B$81,2,FALSE),IFERROR(VLOOKUP(CONCATENATE(G:G,H:H,I:I), Lists!$S$81:$W$98,5,FALSE),\"\")),\"\")","v":""}]
[]
[null,"Baseline System","Minimum Efficiencies ","Fan Power",{"$f":"IF(TRUE, \"Heating System Classification\", \"Section 11 Column\")","v":"Heating System Classification"}]
[null,{"$f":"IFERROR(IF(Path=\"Appendix G PRM\", VLOOKUP($B4,Lists!$A$73:$B$81,2,FALSE),J4),\"\")","v":""},{"$f":"IFERROR(IF(Path=\"Section 11 ECB\", VLOOKUP($B16,Lists!$W$81:$Z$98,3,FALSE),VLOOKUP($B16,Table3[#All],6,FALSE)),\"\")","v":""},{"$f":"IFERROR(IF(Path=\"Section 11 ECB\", VLOOKUP($B16,Lists!$W$81:$Z$98,2,FALSE),VLOOKUP($B16,Table3[#All],7,FALSE)),\"\")","v":""},{"$f":"IFERROR(IF(Path=\"Section 11 ECB\", VLOOKUP($B16,Lists!$W$81:$AA$98,5,FALSE),VLOOKUP($B16,Table3[#All],5,FALSE)),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(Path=\"Appendix G PRM\", VLOOKUP($B5,Lists!$A$73:$B$81,2,FALSE),J5),\"\")","v":""},{"$f":"IFERROR(IF(Path=\"Section 11 ECB\", VLOOKUP($B17,Lists!$W$81:$Z$98,3,FALSE),VLOOKUP($B17,Table3[#All],6,FALSE)),\"\")","v":""},{"$f":"IFERROR(IF(Path=\"Section 11 ECB\", VLOOKUP($B17,Lists!$W$81:$Z$98,2,FALSE),VLOOKUP($B17,Table3[#All],7,FALSE)),\"\")","v":""},{"$f":"IFERROR(IF(Path=\"Section 11 ECB\", VLOOKUP($B17,Lists!$W$81:$AA$98,5,FALSE),VLOOKUP($B17,Table3[#All],5,FALSE)),\"\")","v":""},null,"System Count"]
[null,{"$f":"IFERROR(IF(Path=\"Appendix G PRM\", VLOOKUP($B6,Lists!$A$73:$B$81,2,FALSE),J6),\"\")","v":""},{"$f":"IFERROR(IF(Path=\"Section 11 ECB\", VLOOKUP($B18,Lists!$W$81:$Z$98,3,FALSE),VLOOKUP($B18,Table3[#All],6,FALSE)),\"\")","v":""},{"$f":"IFERROR(IF(Path=\"Section 11 ECB\", VLOOKUP($B18,Lists!$W$81:$Z$98,2,FALSE),VLOOKUP($B18,Table3[#All],7,FALSE)),\"\")","v":""},{"$f":"IFERROR(IF(Path=\"Section 11 ECB\", VLOOKUP($B18,Lists!$W$81:$AA$98,5,FALSE),VLOOKUP($B18,Table3[#All],5,FALSE)),\"\")","v":""},null,{"$f":"ROWS(C4:C13)-COUNTBLANK(C4:C13)","v":0}]
[null,{"$f":"IFERROR(IF(Path=\"Appendix G PRM\", VLOOKUP($B7,Lists!$A$73:$B$81,2,FALSE),J7),\"\")","v":""},{"$f":"IFERROR(IF(Path=\"Section 11 ECB\", VLOOKUP($B19,Lists!$W$81:$Z$98,3,FALSE),VLOOKUP($B19,Table3[#All],6,FALSE)),\"\")","v":""},{"$f":"IFERROR(IF(Path=\"Section 11 ECB\", VLOOKUP($B19,Lists!$W$81:$Z$98,2,FALSE),VLOOKUP($B19,Table3[#All],7,FALSE)),\"\")","v":""},{"$f":"IFERROR(IF(Path=\"Section 11 ECB\", VLOOKUP($B19,Lists!$W$81:$AA$98,5,FALSE),VLOOKUP($B19,Table3[#All],5,FALSE)),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(Path=\"Appendix G PRM\", VLOOKUP($B8,Lists!$A$73:$B$81,2,FALSE),J8),\"\")","v":""},{"$f":"IFERROR(IF(Path=\"Section 11 ECB\", VLOOKUP($B20,Lists!$W$81:$Z$98,3,FALSE),VLOOKUP($B20,Table3[#All],6,FALSE)),\"\")","v":""},{"$f":"IFERROR(IF(Path=\"Section 11 ECB\", VLOOKUP($B20,Lists!$W$81:$Z$98,2,FALSE),VLOOKUP($B20,Table3[#All],7,FALSE)),\"\")","v":""},{"$f":"IFERROR(IF(Path=\"Section 11 ECB\", VLOOKUP($B20,Lists!$W$81:$AA$98,5,FALSE),VLOOKUP($B20,Table3[#All],5,FALSE)),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(Path=\"Appendix G PRM\", VLOOKUP($B9,Lists!$A$73:$B$81,2,FALSE),J9),\"\")","v":""},{"$f":"IFERROR(IF(Path=\"Section 11 ECB\", VLOOKUP($B21,Lists!$W$81:$Z$98,3,FALSE),VLOOKUP($B21,Table3[#All],6,FALSE)),\"\")","v":""},{"$f":"IFERROR(IF(Path=\"Section 11 ECB\", VLOOKUP($B21,Lists!$W$81:$Z$98,2,FALSE),VLOOKUP($B21,Table3[#All],7,FALSE)),\"\")","v":""},{"$f":"IFERROR(IF(Path=\"Section 11 ECB\", VLOOKUP($B21,Lists!$W$81:$AA$98,5,FALSE),VLOOKUP($B21,Table3[#All],5,FALSE)),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(Path=\"Appendix G PRM\", VLOOKUP($B10,Lists!$A$73:$B$81,2,FALSE),J10),\"\")","v":""},{"$f":"IFERROR(IF(Path=\"Section 11 ECB\", VLOOKUP($B22,Lists!$W$81:$Z$98,3,FALSE),VLOOKUP($B22,Table3[#All],6,FALSE)),\"\")","v":""},{"$f":"IFERROR(IF(Path=\"Section 11 ECB\", VLOOKUP($B22,Lists!$W$81:$Z$98,2,FALSE),VLOOKUP($B22,Table3[#All],7,FALSE)),\"\")","v":""},{"$f":"IFERROR(IF(Path=\"Section 11 ECB\", VLOOKUP($B22,Lists!$W$81:$AA$98,5,FALSE),VLOOKUP($B22,Table3[#All],5,FALSE)),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(Path=\"Appendix G PRM\", VLOOKUP($B11,Lists!$A$73:$B$81,2,FALSE),J11),\"\")","v":""},{"$f":"IFERROR(IF(Path=\"Section 11 ECB\", VLOOKUP($B23,Lists!$W$81:$Z$98,3,FALSE),VLOOKUP($B23,Table3[#All],6,FALSE)),\"\")","v":""},{"$f":"IFERROR(IF(Path=\"Section 11 ECB\", VLOOKUP($B23,Lists!$W$81:$Z$98,2,FALSE),VLOOKUP($B23,Table3[#All],7,FALSE)),\"\")","v":""},{"$f":"IFERROR(IF(Path=\"Section 11 ECB\", VLOOKUP($B23,Lists!$W$81:$AA$98,5,FALSE),VLOOKUP($B23,Table3[#All],5,FALSE)),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(Path=\"Appendix G PRM\", VLOOKUP($B12,Lists!$A$73:$B$81,2,FALSE),J12),\"\")","v":""},{"$f":"IFERROR(IF(Path=\"Section 11 ECB\", VLOOKUP($B24,Lists!$W$81:$Z$98,3,FALSE),VLOOKUP($B24,Table3[#All],6,FALSE)),\"\")","v":""},{"$f":"IFERROR(IF(Path=\"Section 11 ECB\", VLOOKUP($B24,Lists!$W$81:$Z$98,2,FALSE),VLOOKUP($B24,Table3[#All],7,FALSE)),\"\")","v":""},{"$f":"IFERROR(IF(Path=\"Section 11 ECB\", VLOOKUP($B24,Lists!$W$81:$AA$98,5,FALSE),VLOOKUP($B24,Table3[#All],5,FALSE)),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(Path=\"Appendix G PRM\", VLOOKUP($B13,Lists!$A$73:$B$81,2,FALSE),J13),\"\")","v":""},{"$f":"IFERROR(IF(Path=\"Section 11 ECB\", VLOOKUP($B25,Lists!$W$81:$Z$98,3,FALSE),VLOOKUP($B25,Table3[#All],6,FALSE)),\"\")","v":""},{"$f":"IFERROR(IF(Path=\"Section 11 ECB\", VLOOKUP($B25,Lists!$W$81:$Z$98,2,FALSE),VLOOKUP($B25,Table3[#All],7,FALSE)),\"\")","v":""},{"$f":"IFERROR(IF(Path=\"Section 11 ECB\", VLOOKUP($B25,Lists!$W$81:$AA$98,5,FALSE),VLOOKUP($B25,Table3[#All],5,FALSE)),\"\")","v":""}]

{"sheet":"Lists","index":23,"n_rows":143,"n_cols":27,"rows_kept":143,"cut":false,"hidden":true,"merged":[]}
["Non-Residential","Yes ",null,null,null,"Regulated",null,null,null,"New Building",null,null,40,"Yes",null,null,"kW","#","kW"]
["Residential","No ",null,null,null,"Unregulated",null,null,null,"New Building w/ Existing Elements (\"Big Alt\")",null,null,null,"No",null,null,"kBtu/h","SQFT","W/SF"]
["Semiheated","N/A",null,null,null,null,null,null,null,"Addition"]
[null,"Non-Residential","Residential","Semiheated",null,null,"Non-Residential","Residential","Semiheated","Alteration",null,null,null,"Section 11 ECB",null,null,"EF","kBTU/h","EER","Et"]
["Nonmetal framing (all)","U-0.28","U-0.28","U-0.51",null,"Nonmetal framing (all)","U-0.57","U-0.57","U-1.22","Addition + Alteration",null,null,null,"Appendix G PRM",null,null,"SL","BTU/h","SEER","Ec"]
["Metal framing (fixed), below 95ft","U-0.30","U-0.30","U-0.73",null,"Metal framing (fixed), below 95ft","U-0.57","U-0.57","U-1.22",null,null,null,null,null,null,null,"Et","tons",null,"AFUE"]
["Metal framing (fixed), 95ft and above","U-0.36","U-0.36","U-0.70",null,"Metal framing (fixed), 95ft and above","U-0.57","U-0.57","U-1.22",null,null,null,null,null,null,null,"COP","kW",null,"COP"]
["Metal framing (operable), below 95ft","U-0.40","U-0.40","U-0.81",null,"Metal framing (operable), below 95ft","U-0.57","U-0.57","U-1.22",null,null,null,null,null,null,null,null,null,null,"HSPF"]
["Metal framing (operable), 95ft and above","U-0.42","U-0.42","U-0.81",null,"Metal framing (operable), 95ft and above","U-0.57","U-0.57","U-1.22"]
["Curtainwall fixed","U-0.36","U-0.36","U-0.73",null,"Curtainwall fixed","U-0.57","U-0.57","U-1.22"]
["Metal framing (entrance door)","U-0.77","U-0.68","U-0.77",null,"Metal framing (entrance door)","U-0.57","U-0.57","U-1.22"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Cost","Source"]
[null,"Non-Residential","Residential","Semiheated",null,null,"Non-Residential","Residential","Semiheated",null,null,null,"All Other",0.53,0.55000000000000004]
["Nonmetal framing (all)",0.36,0.36,"NR",null,"Nonmetal framing (all)",0.39,0.39,"NR",null,null,null,"Dormitory",0.53,0.55000000000000004]
["Metal framing (fixed), below 95ft",0.36,0.36,"NR",null,"Metal framing (fixed), below 95ft",0.39,0.39,"NR",null,null,null,"Healthcare/hospital",0.54,0.56000000000000005]
["Metal framing (fixed), 95ft and above",0.36,0.36,"NR",null,"Metal framing (fixed), 95ft and above",0.39,0.39,"NR",null,null,null,"Hotel/motel",0.62,0.62]
["Metal framing (operable), below 95ft",0.36,0.36,"NR",null,"Metal framing (operable), below 95ft",0.39,0.39,"NR",null,null,null,"Multifamily",0.67,0.68]
["Metal framing (operable), 95ft and above",0.36,0.36,"NR",null,"Metal framing (operable), 95ft and above",0.39,0.39,"NR",null,null,null,"Office",0.54,0.55000000000000004]
["Curtainwall fixed",0.36,0.36,"NR",null,"Curtainwall fixed",0.39,0.39,"NR",null,null,null,"Restaurant",0.56000000000000005,0.63]
["Metal framing (entrance door)",0.36,0.36,"NR",null,"Metal framing (entrance door)",0.39,0.39,"NR",null,null,null,"Retail",0.45,0.45]
[null,null,null,null,null,null,null,null,null,null,null,null,"School",0.45,0.45]
["Skylights","Non-Residential","Residential","Semiheated",null,"Skylights","Non-Residential","Residential","Semiheated",null,null,null,"Warehouse",0.42,0.44]
["0% - 3.0%","U-0.48","U-0.48","U-1.15",null,"0% - 2.0%","U-0.69","U-0.58","U-1.36",null,null,null,"Weighted Average"]
["3.0%+","U-0.48","U-0.48","U-1.15",null,"2.1%+","U-0.69","U-0.58","U-1.36"]
[]
["Skylights","Non-Residential","Residential","Semiheated",null,"Skylights","Non-Residential","Residential","Semiheated"]
["0% - 3.0%",0.38,0.38,"NR",null,"0% - 2.0%",0.49,0.36,"NR"]
["3.0%+",0.38,0.38,"NR",null,"2.1%+",0.39,0.19,"NR",null,null,null,"Grocery Store",7]
[null,null,null,null,null,null,null,null,null,null,null,null,"Healthcare (hospital)",21]
[null,"Non-Residential","Residential","Semiheated",null,null,"Non-Residential","Residential","Semiheated",null,null,null,"Hospital",27]
["Insulation Entirely Above Deck","U-0.030","U-0.030","U-0.093",null,"Insulation Entirely Above Deck","U-0.063","U-0.063","U-0.218",null,null,null,"Hotel/motel (< 75 rooms)",24]
["Metal Building","U-0.035","U-0.035","U-0.082",null,"Metal Building","ERROR","ERROR","ERROR",null,null,null,"Hotel/motel (> 75 rooms)",34]
["Attic and Other","U-0.020","U-0.020","U-0.034",null,"Attic and Other","ERROR","ERROR","ERROR",null,null,null,"Multifamily"]
[null,"Non-Residential","Residential","Semiheated",null,null,"Non-Residential","Residential","Semiheated",null,null,null,"Office (< 5000 ft2)",19]
["Mass","U-0.099","U-0.086","U-0.580",null,"Mass","ERROR","ERROR","ERROR",null,null,null,"Office (> 50,000 ft2)",40]
["Metal Building","U-0.048","U-0.048","U-0.162",null,"Metal Building","ERROR","ERROR","ERROR",null,null,null,"Office (5000 - 50,000 ft2)",31]
["Steel-Framed","U-0.061","U-0.061","U-0.124",null,"Steel-Framed","U-0.124","U-0.064","U-0.124",null,null,null,"Other"]
["Wood-Framed and Other","U-0.061","U-0.061","U-0.089",null,"Wood-Framed and Other","ERROR","ERROR","ERROR",null,null,null,"Restaurant (full service)",24]
[null,"Non-Residential","Residential","Semiheated",null,null,"Non-Residential","Residential","Semiheated",null,null,null,"Restaurant (quick service)",34]
["Below-Grade Wall","C-0.119","C-0.092","C-1.140",null,"Below-Grade Wall","C-1.140","C-1.140","C-1.140",null,null,null,"Retail ( strip mall)",20]
[null,"Non-Residential","Residential","Semiheated",null,null,"Non-Residential","Residential","Semiheated",null,null,null,"Retail (Stand alone)",11]
["Mass","U-0.057","U-0.051","U-0.107",null,"Mass","ERROR","ERROR","ERROR",null,null,null,"School (primary)",22]
["Steel-Joist","U-0.033","U-0.033","U-0.052",null,"Steel-Joist","U-0.052","U-0.038","U-0.069",null,null,null,"School (secondary and university)",22]
["Wood-Framed and Other","U-0.033","U-0.033","U-0.051",null,"Wood-Framed and Other","ERROR","ERROR","ERROR",null,null,null,"Warehouse (nonrefrigerated)",6]
[null,"Non-Residential","Residential","Semiheated",null,null,"Non-Residential","Residential","Semiheated"]
["Unheated","F-0.520","F-0.520","F-0.730",null,"Unheated","F-0.520","F-0.730","F-0.7300"]
["Heated","F-0.63","F-0.63","F-0.900",null,"Heated","ERROR","ERROR","ERROR"]
[null,"Non-Residential","Residential","Semiheated",null,null,"Non-Residential","Residential","Semiheated"]
["Swinging","U-0.370","U-0.370","U-0.370",null,"Swinging","U-0.700","U-0.700","U-0.700"]
["Nonswinging","U-0.310","U-0.310","U-0.360",null,"Nonswinging","U-1.450","U-0.500","U-1.450"]
[]
[]
[null,null,null,null,null,null,"Shivanie"]
["System 1: VAV with PFP boxes","VAV"]
["System 10: PTAC","Single-speed fan",null,null,null,null,"S11 system "]
["System 11: Packaged rooftop AC","Single- or two-speed fan",null,null,null,null,"Water/ Ground","Electric Res.","Single Zone Residential System"]
["System 2: VAV with reheat","VAV",null,null,null,null,"Air/ None","Heat Pump ","Single Zone Non-Residential System"]
["System 3: Packaged VAV with PFP boxes","VAV",null,null,null,null,null,"Fossil Fuel ","Other"]
["System 4: Packaged VAV with reheat","VAV"]
["System 5: Two-pipe fan-coil","Single- or two-speed fan",null,null,null,null,null,null,null,"G3.1.1-4",null,null,null,null,null,null,null,"Sizes "]
["System 6: Water-source HP","Single- or two-speed fan",null,null,null,null,"obsolete w new cover",null,null,"System No. ","System Type","Fan Control","Cooling Type","Heating Type","Efficiency","Fan Power G3.1.2.9 [W]",null,"<17,000"]
["System 7: Four-pipe fan-coil","Single- or two-speed fan",null,null,null,null,"Combo","System",null,"System 1: PTAC","Packaged terminal air conditioner","Constant volume","Direct expansion","Hot-water fossil fuel boiler","Cool: 3.2 COP -- Heat: Boiler","Supply CFM * .3 ",null,">=17,000 and <65,000"]
["System 8: PTHP","Single-speed fan",null,null,null,null,"Air/ NoneElectric Res.Other","System 10 ",null,"System 12: Single-zone, CV-HW","Single-zone system","Constant volume","Chilled water","Hot-water fossil fuel boiler","Cool: Chiller -- Heat: Boiler","bhp * 746 / fan motor efficiency",null,">=65,000 and <135,000"]
["System 9: Packaged rooftop HP","Single- or two-speed fan",null,null,null,null,"Air/ NoneElectric Res.Single Zone Non-Residential System","System 8",null,"System 3: PSZ-AC","Packaged rooftop air conditioner","Constant volume","Direct expansion","Fossil fuel furnace","Cool: Table G3.5.1 -- Heat: Table G3.5.5","bhp * 746 / fan motor efficiency",null,">=135,000 and <240,000"]
[null,null,null,null,null,null,"Air/ NoneElectric Res.Single Zone Residential System","System 8",null,"System 5: Packaged VAV with Reheat","Packaged rooftop VAV with reheat","VAV","Direct expansion","Hot-water fossil fuel boiler","Cool: Table G3.5.1 -- Heat: boiler","bhp * 746 / fan motor efficiency",null,">= 240,000 and <760,000"]
[null,null,null,null,null,null,"Air/ NoneFossil Fuel Other","System 4",null,"System 7: VAV with reheat","VAV with reheat","VAV","Chilled water","Hot-water fossil fuel boiler","Cool: Chiller -- Heat: Boiler","bhp * 746 / fan motor efficiency",null,">=760,000"]
[null,null,null,null,null,null,"Air/ NoneFossil Fuel Single Zone Non-Residential System","System 3",null,"System 9: Heating and Ventilation","Warm air furnace, gas fired","Constant volume","None","Fossil fuel furnace","Cool: none -- Heat: G3.5.5","Supply CFM x .3, if  non mechanical cooling fan req: CFMnmc * .054"]
[null,null,null,null,null,null,"Air/ NoneFossil Fuel Single Zone Residential System","System 3"]
[null,null,null,null,null,null,"Air/ NoneHeat Pump Other","System 11"]
[null,null,null,null,null,null,"Air/ NoneHeat Pump Single Zone Non-Residential System","System 9 "]
[null,null,null,null,null,null,"Air/ NoneHeat Pump Single Zone Residential System","System 9 "]
["App. G ",null,null,null,null,null,"Water/ GroundElectric Res.Other","System 7"]
["Heated-only storage","System 9: Heating and Ventilation","Constant Volume","Fossil fuel furnace",null,null,"Water/ GroundElectric Res.Single Zone Non-Residential System","System 6",null,"Section 11"]
["Nonresidential - < 3 floors and < 25,000 ft2","System 3: PSZ-AC","Constant Volume","Fossil fuel furnace",null,null,"Water/ GroundElectric Res.Single Zone Residential System","System 5",null,"Proposed","Baseline Section 11","Fan Power s.11","Cooler Condensing Source","Budget System Type","Heating System Classification","Efficiencies",null,null,"Master Value List"]
["Nonresidential - < 5 floors and 25,000 - 150,000 ft2","System 5: Packaged VAV with Reheat","VAV","Hot-water fossil fuel boiler",null,null,"Water/ GroundFossil Fuel Other","System 2",null,"Two-pipe fan coil","System 5: Two-pipe fan-coil","Refer to 6.5.3.1 ","Water/Ground","Single-Zone Residential ","Electric Resistance ","Cool: Chiller -- Heat: Electric Resistance "]
["Nonresidential - > 5 floors or > 150,000 ft2","System 7: VAV with reheat","VAV","Hot-water fossil fuel boiler",null,null,"Water/ GroundFossil Fuel Single Zone Non-Residential System","System 6",null,"VAV with parallel fan-powered boxes","System 1: VAV with PFP boxes","Refer to 6.5.3.1 ","Water/Ground","Other","Electric Resistance ","Cool: Chiller -- Heat: Electric Resistance ",null,null,"KEY","Variable #1","Variable #2","Variable #3","System Type","Fan Power","Efficiencies","Fan Airflow","Heating Type"]
["Nonresidential - 4-5 floors and < 25,000 ft2","System 5: Packaged VAV with Reheat","VAV","Hot-water fossil fuel boiler",null,null,"Water/ GroundFossil Fuel Single Zone Residential System","System 1",null,"Water-source heat pump ","System 6: Water-source HP","Refer to 6.5.3.1 ","Water/Ground","Single-Zone Residential ","Heat Pump","Refer to Table 6.8.1-2 [Water to Air] (automated)",null,null,{"$f":"CONCATENATE(T:T,U:U,V:V)","v":"Water/GroundElectric Resistance Single-Zone Residential "},"Water/Ground","Electric Resistance ","Single-Zone Residential "]
["Public Assembly < 120,000 ft2","System 3: PSZ-AC","Constant Volume","Fossil fuel furnace",null,null,"Water/ GroundHeat Pump Other","System 7",null,"Four-pipe fan coil ","System 7: Four-pipe fan-coil","Refer to 6.5.3.1 ","Water/Ground","Single-Zone Non-Residential ","Fossil Fuel ","Cool: Chiller -- Heat: Boiler",null,null,"Air/NoneHeat PumpSingle-Zone Non-Residential ","Air/None","Heat Pump","Single-Zone Non-Residential "]
["Public Assembly > 120,000 ft2","System 12: Single-zone, CV-HW","Constant Volume","Hot-water fossil fuel boiler",null,null,"Water/ GroundHeat Pump Single Zone Non-Residential System","System 6",null,"VAV with reheat","System 2: VAV with reheat","Refer to 6.5.3.1 ","Water/Ground","Other","Fossil Fuel ","Cool: Chiller -- Heat: Boiler",null,null,"Fossil Fuel Other",null,"Fossil Fuel ","Other"]
["Residential","System 1: PTAC","Constant Volume","Hot-water fossil fuel boiler",null,null,"Water/ GroundHeat Pump Single Zone Residential System","System 5",null,"Packaged terminal heat pump \n","System 8: PTHP","Refer to 6.5.3.1 ","Air/None","Single-Zone Residential ","Heat Pump","Refer to Table 6.8.1-4 (automated)",null,null,""]
["Retail - < 2 floors","System 3: PSZ-AC","Constant Volume","Fossil fuel furnace",null,null,null,null,null,"Packaged/split-system heat pump ","System 9: Packaged rooftop HP","Refer to 6.5.3.1 ","Air/None","Single-Zone Non-Residential ","Heat Pump","Refer to Table 6.8.1-2 ",null,null,"Water/GroundElectric Resistance Single-Zone Residential ","Water/Ground","Electric Resistance ","Single-Zone Residential ","System 5: Two-pipe fan-coil","Refer to 6.5.3.1 ","Cool: Chiller -- Heat: Electric Resistance ","Single- or two-speed fan","Electric Resistance "]
[null,null,null,null,null,null,null,null,null,"Packaged VAV with parallel fan-powered boxes","System 3: Packaged VAV with PFP boxes","Refer to 6.5.3.1 ","Air/None","Other","Fossil Fuel ","Cool: Table 6.8.1-1 -- Heat: Electric Resistance ",null,null,"Water/GroundElectric Resistance Single-Zone Non-Residential ","Water/Ground","Electric Resistance ","Single-Zone Non-Residential ","System 5: Two-pipe fan-coil","Refer to 6.5.3.1 ","Cool: Chiller -- Heat: Electric Resistance ","Single- or two-speed fan","Electric Resistance "]
[null,null,null,null,null,null,null,null,null,"Packaged terminal air conditioner\n","System 10: PTAC","Refer to 6.5.3.1 ","Air/None","Single-Zone Residential ","Fossil Fuel ","Refer to Table 6.8.1-4 (automated)",null,null,"Water/GroundElectric Resistance Other","Water/Ground","Electric Resistance ","Other","System 1: VAV with PFP boxes","Refer to 6.5.3.1 ","Cool: Chiller -- Heat: Electric Resistance ","VAV","Electric Resistance "]
[null,"System 1: PTAC","Constant Volume",null,null,null,null,null,null,"Packaged/split-system air conditioner","System 11: Packaged rooftop AC","Refer to 6.5.3.1 ","Air/None","Single-Zone Non-Residential ","Fossil Fuel ","Cool: Table 6.8.1-1  -- Heat: Table 6.8.1-5 ",null,null,"Water/GroundHeat PumpSingle-Zone Residential ","Water/Ground","Heat Pump","Single-Zone Residential ","System 6: Water-source HP","Refer to 6.5.3.1 ","Refer to Table 6.8.1-2 [Water to Air] (automated)","Single- or two-speed fan","Electric Heat Pump and boiler"]
[null,"System 12: Single-zone, CV-HW","Constant Volume",null,null,null,null,null,null,"Packaged VAV with reheat ","System 4: Packaged VAV with reheat","Refer to 6.5.3.1 ","Air/None","Other","Fossil Fuel ","Cool: Table 6.8.1-1 -- Heat: Boiler",null,null,"Water/GroundHeat PumpSingle-Zone Non-Residential ","Water/Ground","Heat Pump","Single-Zone Non-Residential ","System 6: Water-source HP","Refer to 6.5.3.1 ","Refer to Table 6.8.1-2 [Water to Air] (automated)","Single- or two-speed fan","Electric Heat Pump and boiler"]
[null,"System 3: PSZ-AC","Constant Volume",null,null,null,null,null,null,"VRF  ","System 9: Packaged rooftop HP","Refer to 6.5.3.1 ","Air/None","Single-Zone Residential ","Heat Pump","Refer to Table 6.8.1-2 ",null,null,"Water/GroundHeat PumpOther","Water/Ground","Heat Pump","Other","System 6: Water-source HP","Refer to 6.5.3.1 ","Refer to Table 6.8.1-2 [Water to Air] (automated)","Single- or two-speed fan","Electric Heat Pump and boiler"]
[null,"System 3: PSZ-AC","Constant Volume",null,null,null,null,null,null,"Unit heaters ","System 11: Packaged rooftop AC","Refer to 6.5.3.1 ","Air/None","Single-Zone Non-Residential ","Fossil Fuel ","Cool: Table 6.8.1-1  -- Heat: Table 6.8.1-5 ",null,null,"Water/GroundFossil Fuel Single-Zone Residential ","Water/Ground","Fossil Fuel ","Single-Zone Residential ","System 7: Four-pipe fan-coil","Refer to 6.5.3.1 ","Cool: Chiller -- Heat: Boiler","Single- or two-speed fan","Hot-water fossil fuel boiler"]
[null,"System 3: PSZ-AC","Constant Volume",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Water/GroundFossil Fuel Single-Zone Non-Residential ","Water/Ground","Fossil Fuel ","Single-Zone Non-Residential ","System 7: Four-pipe fan-coil","Refer to 6.5.3.1 ","Cool: Chiller -- Heat: Boiler","VAV","Hot-water fossil fuel boiler"]
[null,"System 5: Packaged VAV with Reheat","VAV",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Water/GroundFossil Fuel Other","Water/Ground","Fossil Fuel ","Other","System 2: VAV with reheat","Refer to 6.5.3.1 ","Cool: Chiller -- Heat: Boiler","VAV","Hot-water fossil fuel boiler"]
[null,"System 5: Packaged VAV with Reheat","VAV",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Air/NoneElectric Resistance Single-Zone Residential ","Air/None","Electric Resistance ","Single-Zone Residential ","System 8: PTHP","Refer to 6.5.3.1 ","Refer to Table 6.8.1-4 (automated)","Single-speed fan","Electric Heat Pump  "]
[null,"System 7: VAV with reheat","VAV",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Air/NoneElectric Resistance Single-Zone Non-Residential ","Air/None","Electric Resistance ","Single-Zone Non-Residential ","System 9: Packaged rooftop HP","Refer to 6.5.3.1 ","Refer to Table 6.8.1-2 ","Single- or two-speed fan","Electric Heat Pump"]
[null,"System 9: Heating and Ventilation","Constant Volume",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Air/NoneElectric Resistance Other","Air/None","Electric Resistance ","Other","System 3: Packaged VAV with PFP boxes","Refer to 6.5.3.1 ","Cool: Table 6.8.1-1 -- Heat: Electric Resistance ","VAV","Electric Resistance "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Air/NoneHeat PumpSingle-Zone Residential ","Air/None","Heat Pump","Single-Zone Residential ","System 8: PTHP","Refer to 6.5.3.1 ","Refer to Table 6.8.1-4 (automated)","Single-speed fan","Electric Heat Pump"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Air/NoneHeat PumpSingle-Zone Non-Residential ","Air/None","Heat Pump","Single-Zone Non-Residential ","System 9: Packaged rooftop HP","Refer to 6.5.3.1 ","Refer to Table 6.8.1-2 ","Single- or two-speed fan","Electric Heat Pump"]
["All Others","Gas Storage Water Heater",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Air/NoneHeat PumpOther","Air/None","Heat Pump","Other","System 3: Packaged VAV with PFP boxes","Refer to 6.5.3.1 ","Cool: Table 6.8.1-1 -- Heat: Electric Resistance ","VAV","Electric Resistance "]
["Automotive facility","Gas Storage Water Heater",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Air/NoneFossil Fuel Single-Zone Residential ","Air/None","Fossil Fuel ","Single-Zone Residential ","System 10: PTAC","Refer to 6.5.3.1 ","Refer to Table 6.8.1-4 (automated)","Single-speed fan","Hot-water fossil fuel boiler"]
["Convenience Store","Electric Resistance Storage Water Heater",null,null,null,null,null,null,null,{"$f":"CONCATENATE(K:K,L:L,M:M)","v":""},null,null,null,null,null,null,null,null,"Air/NoneFossil Fuel Single-Zone Non-Residential ","Air/None","Fossil Fuel ","Single-Zone Non-Residential ","System 11: Packaged rooftop AC","Refer to 6.5.3.1 ","Cool: Table 6.8.1-1  -- Heat: Table 6.8.1-5 ","Single- or two-speed fan","Fossil Fuel Furnace"]
["Convention center","Electric Resistance Storage Water Heater",null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,"Air/NoneFossil Fuel Other","Air/None","Fossil Fuel ","Other","System 4: Packaged VAV with reheat","Refer to 6.5.3.1 ","Cool: Table 6.8.1-1 -- Heat: Boiler","VAV","Hot-water fossil fuel boiler"]
["Courthouse","Electric Resistance Storage Water Heater",null,null,null,null,null,null,null,""]
["Dining: bar lounge/leisure","Gas Storage Water Heater",null,null,null,null,null,null,null,""]
["Dining: cafeteria/fast food","Gas Storage Water Heater",null,null,null,null,null,null,null,""]
["Dining: family","Gas Storage Water Heater",null,null,null,null,null,null,null,""]
["Dormitory","Gas Storage Water Heater",null,null,null,null,null,null,null,""]
["Exercise center","Gas Storage Water Heater",null,null,null,null,null,null,null,""]
["Fire station","Gas Storage Water Heater",null,null,null,null,null,null,null,""]
["Gymnasium","Gas Storage Water Heater",null,null,null,null,null,null,null,""]
["Health-care clinic","Electric Resistance Storage Water Heater",null,null,null,null,null,null,null,""]
["Hospital and outpatient surgery center","Gas Storage Water Heater",null,null,null,null,null,null,null,""]
["Hotel/Motel","Gas Storage Water Heater"]
["Library","Electric Resistance Storage Water Heater",null,null,null,null,null,null,null,{"$f":"CONCATENATE(K:K,L:L,M:M)","v":""}]
["Manufacturing facility","Gas Storage Water Heater",null,null,null,null,null,null,null,{"$f":"CONCATENATE(K:K,L:L,M:M)","v":""}]
["Motion picture theater","Electric Resistance Storage Water Heater",null,null,null,null,null,null,null,{"$f":"CONCATENATE(K:K,L:L,M:M)","v":""}]
["Multifamily","Gas Storage Water Heater",null,null,null,null,null,null,null,{"$f":"CONCATENATE(K:K,L:L,M:M)","v":""}]
["Museum","Electric Resistance Storage Water Heater"]
["Office","Electric Resistance Storage Water Heater"]
["Parking garage","Electric Resistance Storage Water Heater"]
["Penitentiary","Gas Storage Water Heater"]
["Performing arts theater","Gas Storage Water Heater"]
["Police station","Electric Resistance Storage Water Heater"]
["Post office","Electric Resistance Storage Water Heater"]
["Religious facility","Electric Resistance Storage Water Heater"]
["Retail","Electric Resistance Storage Water Heater"]
["School/university","Gas Storage Water Heater"]
["Sports arena","Gas Storage Water Heater"]
["Town hall","Electric Resistance Storage Water Heater"]
["Transportation","Electric Resistance Storage Water Heater"]
["Warehouse","Electric Resistance Storage Water Heater"]
["Workshop","Electric Resistance Storage Water Heater"]
[]
[]
["Local Law 97"]
[null,2024,2030]
["Occupancy Classification","CO2 limit/sf"]
["Group A",1.074E-2,4.1999999999999997E-3,null,"Fuel Use","tCO2e per kbtu"]
["Group B",8.4600000000000005E-3,4.5300000000000002E-3,null,"Electricity",2.8896199999999998E-4]
["Group E & I-4",7.5799999999999999E-3,3.4399999999999999E-3,null,"Natural Gas",5.3109999999999998E-5]
["Group I-1",1.1379999999999999E-2,5.9800000000000001E-3,null,"#2 Fuel Oil",7.4209999999999996E-5]
["Group F",5.7400000000000003E-3,1.67E-3,null,"#4 Fuel Oil",7.5290000000000006E-5]
["Group B, H, I-2 and I-3",2.3810000000000001E-2,1.3299999999999999E-2,null,"District Steam",4.4929999999999998E-5]
["Group M",1.1809999999999999E-2,4.0299999999999997E-3]
["Group R-1",9.8700000000000003E-3,5.2599999999999999E-3]
["Group R-2",6.7499999999999999E-3,4.0699999999999998E-3]
["Group S and U",4.2599999999999999E-3,1.1000000000000001E-3]

{"sheet":"HVAC Air-side","index":24,"n_rows":36,"n_cols":10,"rows_kept":36,"cut":false,"hidden":false,"merged":[[20,0,20,1],[21,0,22,1],[20,2,20,4],[20,5,20,7],[21,2,22,4],[21,5,22,7],[4,0,6,1],[4,5,6,7],[4,2,4,4],[5,2,6,4],[1,1,1,9],[36,0,43,9],[12,0,12,1],[12,2,12,3],[2,2,2,4],[7,2,7,4],[7,0,7,1],[8,0,8,1],[9,0,9,1],[10,0,10,1],[11,0,11,1],[11,2,11,3],[11,5,11,6],[7,5,7,7],[12,5,12,6],[14,0,14,1],[14,2,14,3],[8,2,8,4],[8,5,8,7],[9,2,9,3],[9,5,9,6],[10,2,10,3],[13,0,13,1],[13,2,13,3],[13,5,13,6],[10,5,10,7],[14,5,14,7],[19,0,19,1],[19,2,19,4],[19,5,19,7],[15,0,15,1],[15,2,15,3],[15,5,15,6],[16,0,16,1],[16,2,16,4],[17,0,17,1],[17,2,17,3],[17,5,17,6],[18,0,18,1],[18,2,18,3],[18,5,18,6],[16,5,16,6],[23,0,23,1],[23,2,23,4],[23,5,23,7],[24,0,24,1],[24,2,24,4],[24,5,24,7],[33,5,33,7],[32,0,32,1],[33,0,33,1],[29,0,29,1],[29,2,29,3],[29,5,29,6],[30,0,30,1],[30,2,30,3],[30,5,30,6],[34,0,34,1],[35,0,35,1],[3,5,3,6],[3,2,3,3],[2,5,2,9],[2,0,3,1],[34,2,34,4],[34,5,34,7],[35,2,35,4],[35,5,35,7],[31,0,31,1],[31,2,31,3],[31,5,31,6],[32,2,32,4],[32,5,32,7],[33,2,33,4],[26,0,26,1],[26,2,26,3],[26,5,26,6],[25,0,25,1],[25,2,25,3],[25,5,25,6],[28,0,28,1],[28,2,28,3],[28,5,28,6],[27,0,27,1],[27,2,27,3],[27,5,27,6]]}
[]
["6i","Air-Side HVAC "]
[null,null,"HVAC System / Group (BASELINE DESIGN)",null,null,"HVAC System / Group (PROPOSED DESIGN)"]
[null,null," Description",null,"Units"," Description",null,"Units","Supporting Doc. Location","Model Output Report"]
["System Description "]
[]
[]
["System Name in Model"]
["# of Similar Systems"]
["Total Cooling Capacity ",null,null,null,"BTU / h",null,null,"BTU/h"]
["*Table 6.8.1 Unitary Cooling Capacity Range",null,null,null,"BTU / h"," "]
["*Unitary Cooling Eff.",null,null,null,"EER",null,null,"EER"]
["*Unitary Cooling Part-load Eff. (if applicable) ",null,null,null,"IEER",null,null,"IEER"]
["Total Heating Capacity ",null,null,null,"BTU/h",null,null,"BTU/h"]
["*Table 6.8.1 Unitary Heating Capacity Range",null,null,null,"Et",null,null,"Et"]
["*Unitary Heating Efficiency ",null,null,null,"NA",null,null,"COP"]
["*Fan Control",null,"Single- or two-speed fan"]
["Supply Airflow",null,null,null,"cfm",null,null,"cfm"]
[{"$f":"IF(AND(C19 <> F19,F19 <> \"\"),\"OUTDOOR AIRFLOW\",\"Outdoor Airflow\")","v":"Outdoor Airflow"},null,null,null,"cfm",null,null,"cfm"]
["*Demand Control Ventilation",null,"No",null,null,"No"]
["Economizer provided?"]
["*Economizer High-Limit Shutoff (°F)"]
[]
["Exhaust Air Energy Recovery System Provided?",null,"No",null,null,"No"]
["*Exhaust Air Energy Recovery Effectiveness",null,{"$f":"IF(C24=\"Yes\",\"50%\",\"\")","v":""},null,null,{"$f":"IF(F24=\"Yes\",\"INPUT ERV EFFECTIVENESS\",\"\")","v":""}]
["Fan Brake Horsepower ",null,null,null,"hp",null,null,"hp"]
["Fan Motor Efficiency ",null,null,null,"%",null,null,"%"]
["Supply Fan Power",null,null,null,"kW",null,null,"kW"]
["Return Fan Power ",null,null,null,"kW",null,null,"kW"]
["Exhaust Fan Power",null,null,null,"kW",null,null,"kW"]
["Relief Fan Power",null,null,null,"kW",null,null,"kW"]
[{"$f":"IF(OR((SUM(C28:D31)<>C32),(SUM(F28:G31)<>F32)),\"Allowed/Total Fan Power:\",\"Allowed/Total FAN POWER:\")","v":"Allowed/Total FAN POWER:"},null,null,null,"kW",null,null,"kW"]
["EIR",null,{"$f":"IF(OR(C12=\"\",C12=\"NA- chiller dependent\"),\"\",3.412/C12)","v":""},null,null,{"$f":"IF(OR(F12=\"\",F12=\"NA- chiller dependent\"),\"\",3.412/F12)","v":""}]
["HIR",null,{"$f":"IF(OR(C16=\"\",C16=\"NA- boiler dependent\"),\"\",1/C16)","v":""},null,null,{"$f":"IF(OR(F16=\"\",F16=\"NA- boiler dependent\"),\"\",1/F16)","v":""}]
["% OA",null,{"$f":"IF(C19=\"\",\"\",C19/cfm)","v":""},null,null,{"$f":"IF(F19=\"\",\"\",F19/cfm)","v":""}]
["Other (describe)"]

{"sheet":"6j. HVAC Water-side CHW  ","index":25,"n_rows":27,"n_cols":8,"rows_kept":27,"cut":false,"hidden":false,"merged":[[1,2,1,7],[27,1,36,7],[4,2,4,3],[4,4,4,5],[20,2,20,3],[20,4,20,5],[2,4,2,6],[5,2,5,3],[5,4,5,5],[2,2,2,3],[16,2,16,3],[16,4,16,5],[12,2,12,3],[12,4,12,5],[11,2,11,3],[11,4,11,5]]}
[]
[null,"6j","Water-Side HVAC - Chilled Water"]
[null,"Model Input Parameter","HVAC System / Group (BASELINE DESIGN)",null,"HVAC System / Group (PROPOSED DESIGN)"]
[null,null,"Description","Units","Description","Units","Supporting Doc. Location","Model Output Report"]
[null,"System Designation(s)"]
[null,"# and Type of Chillers (and capacity of chiller if more than 1 type or size)"]
[null,"Total Chiller Capacity"]
[null,"Chiller Efficiency - Full Load"]
[null,"Chiller Efficiency - Part Load"]
[null,"Chilled Water (CHW) Supply Temp",null,"°F",null,"°F"]
[null,"CHW ΔT",null,"°F",null,"°F"]
[null,"CHW Supply Temp Reset Parameters"]
[null,"CHW Loop Configuration"]
[null,"Number of Primary CHW Pumps",null,"#",null,"#"]
[null,"Primary CHW Pump Power"]
[null,"Primary CHW Pump Flow",null,"gpm",null,"gpm"]
[null,"Primary CHW Pump Control"]
[null,"Number of Secondary CHW Pumps",null,"#",null,"#"]
[null,"Secondary CHW Pump Power"]
[null,"Secondary CHW Pump Flow",null,"gpm",null,"gpm"]
[null,"Secondary CHW Pump Control"]
[null,"Water-Side Economizer"]
[null,"Water-Side Energy Recovery"]
[null,"Other (describe)"]
[null,"Other (describe)"]
[null,"Other (describe)"]
[null,"Other (describe)"]

{"sheet":"6k. HVAC Water-side CW&CT","index":26,"n_rows":20,"n_cols":8,"rows_kept":20,"cut":false,"hidden":false,"merged":[[1,2,1,7],[20,1,31,7],[14,2,14,3],[14,4,14,5],[2,2,2,3],[2,4,2,6],[5,2,5,3],[5,4,5,5],[10,2,10,3],[10,4,10,5],[4,2,4,3],[4,4,4,5]]}
[]
[null,"6k","Water-Side HVAC - Cooling Tower and Condenser Water"]
[null,"Model Input Parameter","HVAC System / Group (BASELINE DESIGN)",null,"HVAC System / Group (PROPOSED DESIGN)"]
[null,null,"Description","Units","Description","Units","Supporting Doc. Location","Model Output Report"]
[null,"System Designation(s)"]
[null,"Number of Cooling Towers/Fluid Coolers"]
[null,"Cooling Tower Fan Power"]
[null,"Cooling Tower Fan Control"]
[null,"Condenser Water (CW) Leaving Temp",null,"°F",null,"°F"]
[null,"CW ΔT",null,"°F",null,"°F"]
[null,"CW Loop Temp Reset Parameters"]
[null,"Number of CW Pumps",null,"#",null,"#"]
[null,"CW Pump Power"]
[null,"CW Pump Flow",null,"gpm",null,"gpm"]
[null,"CW Pump Control"]
[null,"Performance",null,"gpm/hp",null,"gpm/hp"]
[null,"Other (describe)"]
[null,"Other (describe)"]
[null,"Other (describe)"]
[null,"Other (describe)"]

{"sheet":"6l. HVAC Water-side HW&Steam","index":27,"n_rows":24,"n_cols":8,"rows_kept":24,"cut":false,"hidden":false,"merged":[[24,1,34,7],[10,2,10,3],[10,4,10,5],[1,1,1,7],[2,2,2,3],[2,4,2,6],[5,2,5,3],[5,4,5,5],[4,2,4,3],[4,4,4,5],[11,2,11,3],[11,4,11,5],[15,2,15,3],[15,4,15,5],[19,2,19,3],[19,4,19,5]]}
[null,"6l"]
[null,"Water-Side HVAC: Hot Water or Steam"]
[null,"Model Input Parameter","HVAC System / Group (BASELINE DESIGN)",null,"HVAC System / Group (PROPOSED DESIGN)"]
[null,null,"Description","Units","Description","Units","Supporting Doc. Location","Model Output Report"]
[null,"System Designation(s)"]
[null,"Number and Type of Boilers"]
[null,"Total Boiler Capacity"]
[null,"Boiler Efficiency"]
[null,"Hot Water or Steam (HHW) Supply Temp",null,"°F",null,"°F"]
[null,"HHW ΔT",null,"°F",null,"°F"]
[null,"HHW Temp Reset Parameters"]
[null,"HHW Loop Configuration"]
[null,"Number of Primary HHW Pumps",null,"#",null,"#"]
[null,"Primary HHW Pump Power"]
[null,"Primary HHW Pump Flow",null,"gpm",null,"gpm"]
[null,"Primary HHW Pump Control"]
[null,"Number of Secondary HHW Pumps",null,"#",null,"#"]
[null,"Secondary HHW Pump Power"]
[null,"Secondary HHW Pump Flow",null,"gpm",null,"gpm"]
[null,"Secondary HHW Pump Control"]
[null,"Other (describe)"]
[null,"Other (describe)"]
[null,"Other (describe)"]
[null,"Other (describe)"]

{"sheet":"6m. HVAC- Geothermal","index":28,"n_rows":23,"n_cols":8,"rows_kept":23,"cut":false,"hidden":false,"merged":[[23,1,34,7],[1,1,1,7],[2,2,2,3],[2,4,2,6],[5,2,5,3],[5,4,5,5],[4,2,4,3],[4,4,4,5],[11,4,11,5],[15,2,15,3],[15,4,15,5],[19,2,19,3],[19,4,19,5],[12,4,12,5],[14,2,14,3],[13,2,13,3],[12,2,12,3],[6,2,6,3],[20,2,20,3],[21,2,21,3],[22,2,22,3],[18,2,18,3],[17,2,17,3],[16,2,16,3],[11,2,11,3],[10,2,10,3],[9,2,9,3],[8,2,8,3],[7,2,7,3]]}
[null,"6m"]
[null,"Geothermal Systems"]
[null,"Model Input Parameter","HVAC System / Group (BASELINE DESIGN)",null,"HVAC System / Group (PROPOSED DESIGN)"]
[null,null,"Description","Units","Description","Units","Supporting Doc. Location","Model Output Report"]
[null,"System Designation(s)"]
[null,"Type of Geothermal system","NA"]
[null,"Soil Conductivity (if applicable)","NA"]
[null,"Geothermal source design temperature - summer","NA",null,null,"°F"]
[null,"Geothermal source design temperature - winter","NA",null,null,"°F"]
[null,"Geoexchange loop design fluid supply temperature - cooling","NA",null,null,"°F"]
[null,"Geoexchange loop design fluid supply temperature -heating","NA",null,null,"°F"]
[null,"Geoexchange loop - operating temperature","NA"]
[null,"Geothermal energy transfer effect","NA"]
[null,"Geothermal Loop Pumping Configuration","NA"]
[null,"Number of Geothermal Loop Pumps","NA",null,null,"#"]
[null,"Geothermal Loop Pump Control","NA"]
[null,"Geothermal Pump Power ","NA",null,null,"W/gpm"]
[null,"Geothermal Loop Flow","NA",null,null,"gpm"]
[null,"Geothermal Air-side Efficiency curves","NA"]
[null,"Other (describe)","NA"]
[null,"Other (describe)","NA"]
[null,"Other (describe)","NA"]
[null,"Other (describe)","NA"]

{"sheet":"6n. CHP","index":29,"n_rows":18,"n_cols":8,"rows_kept":18,"cut":false,"hidden":false,"merged":[[18,1,29,7],[1,2,1,7],[10,4,10,5],[2,2,2,3],[2,4,2,6],[4,2,4,3],[4,4,4,5],[5,2,5,3],[6,2,6,3],[7,2,7,3],[8,2,8,3],[9,2,9,3],[10,2,10,3],[16,2,16,3],[17,2,17,3],[5,4,5,5],[9,4,9,5],[12,4,12,5],[13,4,13,5],[15,4,15,5],[16,4,16,5],[17,4,17,5],[14,2,14,3],[14,4,14,5],[15,2,15,3],[11,2,11,3],[11,4,11,5],[12,2,12,3],[13,2,13,3]]}
[]
[null,"6n","Combined  Heat & Power Systems"]
[null,"Model Input Parameter","HVAC System / Group (BASELINE DESIGN)",null,"HVAC System / Group (PROPOSED DESIGN)"]
[null,null,"Description","Units","Description","Units","Supporting Doc. Location","Model Output Report"]
[null,"CHP: Type of generator","NA"]
[null,"Quantity of CHP generators","NA"]
[null,"Total capacity of CHP generators (kW) at design conditions","NA",null,null,"kW"]
[null,"CHP: Thermal efficiency (%) at design conditions","NA",null,null,"%"]
[null,"CHP: Electrical efficiency (%) at design conditions","NA",null,null,"%"]
[null,"CHP: Controls / Schedule","NA"]
[null,"CHP: Fuel Source","NA"]
[null,"CHP: Where is the recovered heat used? (e.g. gas absorption chillers, hot water distribution loop, etc.)","NA"]
[null,"CHP: Backup heat source when waste heat from CHP is unavailable? (e.g. fossil fuel boilers)","NA"]
[null,"CHP: Parasitic losses (e.g. air handling unit to cool the intake air)","NA"]
[null,"Other (describe)","NA"]
[null,"Other (describe)","NA"]
[null,"Other (describe)","NA"]
[null,"Other (describe)","NA"]

{"sheet":"Lists-Areas","index":30,"n_rows":31,"n_cols":8,"rows_kept":31,"cut":false,"hidden":true,"merged":[]}
[]
["BPF weighted avg","Envelope Backstop weighted avg","WWR weighted avg"]
["All Other","All other","Grocery Store"]
["All Other","All other","All Other",null,null,null,"Group A","Assembly"]
["All Other","Dormitory","All Other",null,null,null,"Group B","office"]
["Healthcare/\nhospital","All other","Healthcare (hospital)",null,null,null,"Group E & I-4","Education"]
["Healthcare/\nhospital","All other","Hospital",null,null,null,"Group I-4"]
["Hotel/motel","Hotel/motel","Hotel/motel (< 75 rooms)",null,null,null,"Group I-1"]
["Hotel/motel","Hotel/motel","Hotel/motel (> 75 rooms)",null,null,null,"Group F"]
["Multifamily","Multifamily","Multifamily",null,null,null,"Group B, H, I-2 and I-3"]
["Office","All other","Office (< 5000 ft2)",null,null,null,"Group H"]
["Office","All other","Office (> 50,000 ft2)",null,null,null,"Group I-2"]
["Office","All other","Office (5000 - 50,000 ft2)",null,null,null,"Group I-3"]
["Restaurant","All other","Restaurant (full service)",null,null,null,"Group M"]
["Restaurant","All other","Restaurant (quick service)",null,null,null,"Group R-1"]
["Retail","All other","Retail ( strip mall)",null,null,null,"Group R-2"]
["Retail","All other","Retail (Stand alone)",null,null,null,"Group S and U"]
["School","All other","School (primary)"]
["School","All other","School (secondary and university)"]
["Warehouse","All other","Warehouse (nonrefrigerated)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Other"]

{"sheet":"Lighting Lookup","index":31,"n_rows":108,"n_cols":9,"rows_kept":108,"cut":false,"hidden":true,"merged":[]}
["Building Area Method Categories","Table 9.5.1 LPD (W/sf)","Table G",null,"Space by Space Categories","Table 9.6.1 LPD (W/sf)",null,null,"Additional Controls"]
["Automotive facility",0.64,0.9,null,"Atrium - first 40ft in height",0.03,3.7499999999999999E-2,null,"None"]
["Convention center",0.7,1.2,null,"Atrium - height above 40ft",0.03,3.7499999999999999E-2,null,"Decorative"]
["Courthouse",0.74,1.2,null,"Audience/seating area - all other",0.43,0.9,null,"Retail Display"]
["Dining: bar lounge/leisure",0.69,1.3,null,"Audience/seating area - auditorium",0.63,0.9,null,"Room Cavity Ratio"]
["Dining: cafeteria/fast food",0.66,1.4,null,"Audience/seating area - convention center",0.65,0.7,null,"Control Allowance"]
["Dining: family",0.61,1.6,null,"Audience/seating area - exercise center",0.43,0.3]
["Dormitory",0.52,1,null,"Audience/seating area - gymnasium",0.43,0.4]
["Exercise center",0.65,1,null,"Audience/seating area - motion picture theater",0.64,1.2]
["Fire station",0.5,1,null,"Audience/seating area - penitentiary",0.28000000000000003,0.7]
["Gymnasium",0.67,1.1000000000000001,null,"Audience/seating area - performing arts theater",2.0299999999999998,2.6]
["Health-care clinic",0.68,1,null,"Audience/seating area - religious facility",1.53,1.7]
["Hospital",0.86,1.2,null,"Audience/seating area - sports arena",0.42,0.4]
["Hotel/Motel",0.7,1.0900000000000001,null,"Audience/seating area - transportation facility",0.4,0.5]
["Library",0.78,1.3,null,"Automotive",0.53,0.7]
["Manufacturing facility",0.6,1.17,null,"Banking Activity Area",0.79,1.5]
["Motion picture theater",0.62,1.2,null,"Classroom/lecture/training - all other",0.74,1.4]
["Multifamily",0.49,0.7,null,"Classroom/lecture/training - penitentiary",1.06,1.3]
["Museum",0.68,1.1000000000000001,null,"Computer Room",1.1599999999999999,2.14]
["Office",0.69,1,null,"Conference/meeting/multipurpose",0.93,1.3]
["Parking garage",0.12,0.3,null,"Confinement Cells",0.52,0.9]
["Penitentiary",0.67,1,null,"Convention Center-Exhibit Space",0.69,1.3]
["Performing arts theater",0.85,1.6,null,"Copy/Print Room",0.5,0.9]
["Police station",0.68,1,null,"Corridor - all other",0.57999999999999996,0.5]
["Post office",0.62,1.1000000000000001,null,"Corridor - facility for visually impaired",0.81,1.1499999999999999]
["Religious facility",0.72,1.3,null,"Corridor - hospital",0.81,1]
["Retail",0.91,1.5,null,"Corridor - manufacturing facility",0.28000000000000003,0.5]
["School/university",0.67,1.2,null,"Courtroom",1.06,1.9]
["Sports arena",0.76,1.1000000000000001,null,"Dining Area - all other",0.53,0.9]
["Town hall",0.72,1.1000000000000001,null,"Dining Area - Bar Lounge/Leisure Dining",0.62,1.4]
["Transportation",0.51,1,null,"Dining Area - cafeteria/fast food",0.53,0.9]
["Warehouse",0.41,0.8,null,"Dining Area - facility for visually impaired",1.48,3.32]
["Workshop",0.83,1.4,null,"Dining Area - Family Dining",0.54,2.1]
[null,null,null,null,"Dining Area - penitentiary",0.72,1.3]
[null,null,null,null,"Dormitory - living quarters",0.46,1.1100000000000001]
[null,null,null,null,"Electrical/Mechanical",0.39,1.5]
[null,null,null,null,"Emergency Vehicle Garage",0.41,0.8]
[null,null,null,null,"Facility for Visually Impaired - in a chapel",0.89,2.77]
[null,null,null,null,"Facility for Visually Impaired - in a rec room/common living rm",1.53,3.02]
[null,null,null,null,"Fire station - sleeping quarters",0.19,0.3]
[null,null,null,null,"Food Preparation Area",0.92,1.2]
[null,null,null,null,"Guest Room",0.75,1.1399999999999999]
[null,null,null,null,"Gymnasium/Exercise Center-Playing Area",0.75,1.4]
[null,null,null,null,"Gymnasium/Fitness Center - exercise area",0.5,0.9]
[null,null,null,null,"Healthcare facility - exam treatment room",1.1599999999999999,1.5]
[null,null,null,null,"Healthcare facility - imaging room",0.98,0.4]
[null,null,null,null,"Healthcare facility - medical supply room",0.54,1.4]
[null,null,null,null,"Healthcare facility - nursery",0.94,0.6]
[null,null,null,null,"Healthcare facility - nurse's station",0.75,1]
[null,null,null,null,"Healthcare facility - Operating Room",1.87,2.2000000000000002]
[null,null,null,null,"Healthcare facility - Patient Room",0.45,0.7]
[null,null,null,null,"Healthcare facility - Physical Therapy",0.84,0.9]
[null,null,null,null,"Healthcare facility - Recovery",0.89,0.8]
[null,null,null,null,"Laboratory - in or as a classroom",1.04,1.4]
[null,null,null,null,"Laboratory - other",1.45,1.4]
[null,null,null,null,"Laundry/Washing Area",0.43,0.6]
[null,null,null,null,"Library - Reading Area",0.77,1.2]
[null,null,null,null,"Library - Stacks",1.2,1.7]
[null,null,null,null,"Loading Dock, Interior",0.51,0.59]
[null,null,null,null,"Lobby - all other",0.9,1.3]
[null,null,null,null,"Lobby - Elevator",0.52,0.8]
[null,null,null,null,"Lobby - facility for visually impaired",2.0299999999999998,2.2599999999999998]
[null,null,null,null,"Lobby - Hotel",0.68,1.1000000000000001]
[null,null,null,null,"Lobby - Motion Picture Theater",0.38,1.1000000000000001]
[null,null,null,null,"Lobby - Performing Arts Theater",0.82,3.3]
[null,null,null,null,"Locker Room",0.45,0.6]
[null,null,null,null,"Lounge/Breakroom - all other",0.44,1.2]
[null,null,null,null,"Lounge/Breakroom - healthcare facility",0.53,0.8]
[null,null,null,null,"Manufacturing-Detailed Manufacturing",0.86,2.1]
[null,null,null,null,"Manufacturing-Equipment Room",0.61,1.2]
[null,null,null,null,"Manufacturing-Extra High Bay (>50ft floor to ceiling ht)",0.73,1.32]
[null,null,null,null,"Manufacturing-High Bay (25-50ft floor to ceiling ht)",0.57999999999999996,1.7]
[null,null,null,null,"Manufacturing-Low Bay (<25ft floor to ceiling ht)",0.61,1.2]
[null,null,null,null,"Multifamily Dwelling Unit",0.49,1.07]
[null,null,null,null,"Museum-General Exhibition",0.61,1]
[null,null,null,null,"Museum-Restoration",0.77,1.7]
[null,null,null,null,"Office - Enclosed and < 250 sqft",0.85,1.1000000000000001]
[null,null,null,null,"Office - Enclosed and > 250 sqft",0.85,1.1000000000000001]
[null,null,null,null,"Office - Open Plan",0.78,1.1000000000000001]
[null,null,null,null,"Parking Area, Interior",0.11,0.2]
[null,null,null,null,"Performing Arts Theater - dressing room",0.35]
[null,null,null,null,"Pharmacy Area",1.23,1.2]
[null,null,null,null,"Post Office-Sorting Area",0.66,1.2]
[null,null,null,null,"Religious Buildings-Fellowship Hall",0.54,0.9]
[null,null,null,null,"Religious Buildings-Worship Pulpit, Choir",0.98,2.4]
[null,null,null,null,"Restroom - all other",0.75,0.9]
[null,null,null,null,"Restroom - visually impaired",0.81,1.52]
[null,null,null,null,"Retail-Dressing/Fitting Room",0.49,0.89]
[null,null,null,null,"Retail-Mall Concourse",0.79,1.7]
[null,null,null,null,"Sales Area",1.06,1.7]
[null,null,null,null,"Seating Area, General",0.38,0.68]
[null,null,null,null,"Sports Arena-Court Sports Area-Class 1",2.2599999999999998,4.6100000000000003]
[null,null,null,null,"Sports Arena-Court Sports Area-Class 2",1.45,3.01]
[null,null,null,null,"Sports Arena-Court Sports Area-Class 3",1.08,2.2599999999999998]
[null,null,null,null,"Sports Arena-Court Sports Area-Class 4",0.72,1.5]
[null,null,null,null,"Stairwell",0.5,0.6]
[null,null,null,null,"Storage room - all other",0.43,0.8]
[null,null,null,null,"Storage room - hospital",0.43,0.9]
[null,null,null,null,"Storage room < 50 sqft",0.43,0.8]
[null,null,null,null,"Storage room < 50 sqft and < 1000 sqft",0.43,0.8]
[null,null,null,null,"Transportation facility - airport concourse",0.31,0.6]
[null,null,null,null,"Transportation facility - baggage/carousel area",0.4,1]
[null,null,null,null,"Transportation facility - terminal ticket counter",0.48,1.5]
[null,null,null,null,"Unfinished: Post construction buildout",0.2,0.2]
[null,null,null,null,"Vehicular Maintenance Area",0.53,0.7]
[null,null,null,null,"Warehouse storage - medium to bulky, palletized items",0.27,0.9]
[null,null,null,null,"Warehouse storage - smaller, hand-carried items",0.65,1.4]
[null,null,null,null,"Workshop",1.0900000000000001,1.9]

{"sheet":"Lighting Zones","index":32,"n_rows":12,"n_cols":4,"rows_kept":12,"cut":false,"hidden":true,"merged":[]}
[null,"Lighting Zone","Description","Base Site Allowance (watts)"]
[1,0,"Undeveloped areas within national and state parks, forest land and rural areas and other undeveloped areas as approved by the AHJ",0]
[2,1,"Park Land",350]
[3,2,"R districts, R districts with C overlays and MX districts",400]
[4,3,"M districts, except MX; C districts, except C5, C6 and C overlays on R",500]
[5,4,"C5 and C6 districts",900]
[]
[]
[]
[]
[null,"YES"]
[null,"NO"]

{"sheet":"Raw Data","index":33,"n_rows":24,"n_cols":30,"rows_kept":24,"cut":false,"hidden":true,"merged":[[0,3,0,7],[0,8,0,12],[0,18,0,22],[0,23,0,27]]}
[null,null,null,"Area Allowance (watts/sq.ft)",null,null,null,null,"Linear Allowance (watts/linear foot)",null,null,null,null,null,null,null,null,null,"Area Allowance (watts/sq.ft)",null,null,null,null,"Linear Allowance (watts/linear foot)"]
["Surface","Surface Type","Type","LZ0","LZ1","LZ2","LZ3","LZ4","LZ0","LZ1","LZ2","LZ3","LZ4","Base Allowance","Unit Allowance",null,"Surface2","Surface Type","LZ0","LZ1","LZ2","LZ3","LZ4","LZ0","LZ1","LZ2","LZ3","LZ4","Base Allowance","Unit Allowance"]
["ATM or Night Depository","Nontradable",1,null,null,null,null,null,null,null,null,null,null,{"$f":"AC19","v":135},{"$f":"AD19","v":45},null,"Uncovered parking areas and drives","Tradable",0,0.03,0.04,0.05,0.05]
["Building façade","Nontradable",null,{"$f":"S18","v":0},0,0.1,0.15,0.2,{"$f":"X18","v":0},{"$f":"Y18","v":0},{"$f":"Z18","v":2.5},{"$f":"AA18","v":3.75},{"$f":"AB18","v":5},null,null,null,"Walkways less than 10' wide","Tradable",null,null,null,null,null,0,0.5,0.5,0.6,0.7]
["Drive-thrus","Nontradable",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AD22","v":200},null,"Walkways >= 10' wide","Tradable",0,0.1,0.1,0.11,0.14000000000000001]
["Entrances and gatehouse inspection at guarded facilities (uncovered)","Nontradable",null,{"$f":"S20","v":0},{"$f":"T20","v":0.5},{"$f":"U20","v":0.5},{"$f":"V20","v":0.5},{"$f":"W20","v":0.5},null,null,null,null,null,null,null,null,"Plaza areas","Tradable",0,0.1,0.1,0.11,0.14000000000000001]
["Entry canopies","Tradable",null,{"$f":"S13","v":0},{"$f":"T13","v":0.2},{"$f":"U13","v":0.25},{"$f":"V13","v":0.4},{"$f":"W13","v":0.4},null,null,null,null,null,null,null,null,"Special feature areas","Tradable",0,0.1,0.1,0.11,0.14000000000000001]
["Landscaping","Tradable",null,{"$f":"S11","v":0},{"$f":"T11","v":0.03},{"$f":"U11","v":0.04},{"$f":"V11","v":0.04},{"$f":"W11","v":0.04},null,null,null,null,null,null,null,null,"Dining areas","Tradable",0,0.65,0.65,0.75,0.95]
["Loading area for emergency service vehicles (uncovered)","Nontradable",null,{"$f":"S21","v":0},{"$f":"T21","v":0.35},{"$f":"U21","v":0.35},{"$f":"V21","v":0.35},{"$f":"W21","v":0.35},null,null,null,null,null,null,null,null,"Stairways","Tradable",0,0.6,0.7,0.7,0.7]
["Loading docks","Tradable",null,{"$f":"S14","v":0},{"$f":"T14","v":0.35},{"$f":"U14","v":0.35},{"$f":"V14","v":0.35},{"$f":"W14","v":0.35},null,null,null,null,null,null,null,null,"Pedestrian tunnels","Tradable",0,0.12,0.12,0.14000000000000001,0.21]
["Other entrances/exits","Tradable",null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,"Landscaping","Tradable",0,0.03,0.04,0.04,0.04]
["Outdoor sales area","Tradable",null,{"$f":"S16","v":0},{"$f":"T16","v":0.2},{"$f":"U16","v":0.2},{"$f":"V16","v":0.35},{"$f":"W16","v":0.5},null,null,null,null,null,null,null,null,"Pedestrian and vehicular entrances and exits","Tradable",null,null,null,null,null,0,12.6,12.6,20,20]
["Parking near 24-hour retail entrances (main only)","Nontradable",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AD23","v":400},null,"Entry canopies","Tradable",0,0.2,0.25,0.4,0.4]
["Pedestrian tunnels","Tradable",null,{"$f":"S10","v":0},{"$f":"T10","v":0.12},{"$f":"U10","v":0.12},{"$f":"V10","v":0.14000000000000001},{"$f":"W10","v":0.21},null,null,null,null,null,null,null,null,"Loading docks","Tradable",0,0.35,0.35,0.35,0.35]
["Plaza areas","Tradable",null,{"$f":"S6","v":0},{"$f":"T6","v":0.1},{"$f":"U6","v":0.1},{"$f":"V6","v":0.11},{"$f":"W6","v":0.14000000000000001},null,null,null,null,null,null,null,null,"Sales canopy","Tradable",0,0.4,0.4,0.6,0.7]
["Primary building entrances","Tradable",null,null,null,null,null,null,{"$f":"X12","v":0},{"$f":"Y12","v":12.6},{"$f":"Z12","v":12.6},{"$f":"AA12","v":20},{"$f":"AB12","v":20},null,null,null,"Outdoor sales area","Tradable",0,0.2,0.2,0.35,0.5]
["Roadway/parking, entry, trailhead, toilet facility","Nontradable",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AD24","v":0},null,"Street frontage for vehicle sales","Tradable",null,null,null,null,null,0,0,7,7,21]
["Sales canopy","Tradable",null,{"$f":"S15","v":0},{"$f":"T15","v":0.4},{"$f":"U15","v":0.4},{"$f":"V15","v":0.6},{"$f":"W15","v":0.7},null,null,null,null,null,null,null,null,"Building façade","Nontradable",0,0,0.1,0.15,0.2,0,0,2.5,3.75,5]
["Special feature areas","Tradable",null,{"$f":"S7","v":0},{"$f":"T7","v":0.1},{"$f":"U7","v":0.1},{"$f":"V7","v":0.11},{"$f":"W7","v":0.14000000000000001},null,null,null,null,null,null,null,null,"ATM or Night Depository","Nontradable",null,null,null,null,null,null,null,null,null,null,135,45]
["Stairways","Tradable",null,{"$f":"S9","v":0},{"$f":"T9","v":0.6},{"$f":"U9","v":0.7},{"$f":"V9","v":0.7},{"$f":"W9","v":0.7},null,null,null,null,null,null,null,null,"Entrances and gatehouse inspection at guarded facilities (uncovered)","Nontradable",0,0.5,0.5,0.5,0.5]
["Street frontage for vehicle sales","Tradable",null,null,null,null,null,null,{"$f":"X17","v":0},{"$f":"Y17","v":0},{"$f":"Z17","v":7},{"$f":"AA17","v":7},{"$f":"AB17","v":21},null,null,null,"Loading area for emergency service vehicles (uncovered)","Nontradable",0,0.35,0.35,0.35,0.35]
["Uncovered parking areas and drive","Tradable",null,{"$f":"S3","v":0},{"$f":"T3","v":0.03},{"$f":"U3","v":0.04},{"$f":"V3","v":0.05},{"$f":"W3","v":0.05},null,null,null,null,null,null,null,null,"Drive-thrus","Nontradable",null,null,null,null,null,null,null,null,null,null,null,200]
["Walkways >= 10' wide","Tradable",null,{"$f":"S5","v":0},{"$f":"T5","v":0.1},{"$f":"U5","v":0.1},{"$f":"V5","v":0.11},{"$f":"W5","v":0.14000000000000001},null,null,null,null,null,null,null,null,"Parking near 24-hour retail entrances (main only)","Nontradable",null,null,null,null,null,null,null,null,null,null,null,400]
["Walkways less than 10' wide","Tradable",null,null,null,null,null,null,{"$f":"X4","v":0},{"$f":"Y4","v":0.5},{"$f":"Z4","v":0.5},{"$f":"AA4","v":0.6},{"$f":"AB4","v":0.7},null,null,null,"Roadway/parking, entry, trailhead, toilet facility","Nontradable",null,null,null,null,null,null,null,null,null,null,null,0]