{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Instructions","Multiple Zone","100% OA","Single Zone","Summary"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":26,"comments":3,"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":"Instructions","index":0,"n_rows":305,"n_cols":16,"rows_kept":305,"cut":false,"hidden":false,"merged":[[65,2,65,9],[66,2,66,9],[57,2,57,4],[58,2,58,4],[62,2,62,9],[63,2,63,9],[70,13,71,13],[38,2,38,4],[38,5,38,9],[39,2,39,4],[40,2,40,4],[41,2,41,4],[42,2,42,4],[43,2,43,4],[44,2,44,4],[45,2,45,4],[46,2,46,4],[47,2,47,4],[48,2,48,4],[64,2,64,9],[56,2,56,4],[39,5,39,9],[40,5,40,9],[41,5,41,9],[2,4,2,10],[5,4,5,7],[25,4,25,10],[32,4,32,10],[29,4,29,10],[55,2,55,4],[42,5,42,9],[43,5,43,9],[44,5,44,9],[45,5,45,9],[46,5,46,9],[52,2,52,4],[47,5,47,9],[48,5,48,9],[53,2,53,4],[54,2,54,4],[109,2,109,5],[70,2,71,5],[70,6,70,7],[70,8,70,9],[70,10,71,10]]}
[]
[]
[null,null,null,null,"Minimum Indoor Air Quality Performance Calculator\nLEED 2009 and v4 EQ Prerequisite Minimum Indoor Air Quality Performance"]
[]
[null,null,null,null,"Step 1."]
[null,null,null,null,"Enable macros."]
[null,null,null,null,"Note: This calculator is for use with Excel for Mac 2011 and Excel 2007 or later."]
[]
[null,null,null,null,"Step 2. "]
[null,null,null,null,"Unit of measurement",null,null,null,null,null,"IP units"]
[null,null,null,null,"Note: This selection must match the unit of measurement chosen during project registration."]
[]
[null,null,null,null,"Step 3. "]
[null,null,null,null,"LEED rating system version",null,null,null,null,null,"LEED v4"]
[null,null,null,null,"Note: This selection must match project registration."]
[]
[null,null,null,null,"Step 4. "]
[null,null,null,null,"Increase breathing zone outdoor airflow by 30%?",null,null,null,null,null,"No"]
[null,null,null,null,{"$f":"IF(LEED=1,\"Select if attempting EQ Credit Increased Ventilation.\",\"Select if attempting EQ Credit Enhanced Indoor Air Quality Strategies, Option 2, Strategy B: Increased Ventilation.\")","v":"Select if attempting EQ Credit Enhanced Indoor Air Quality Strategies, Option 2, Strategy B: Increased Ventilation."}]
[]
[null,null,null,null,"Step 5. "]
[null,null,null,null,"Single Zone Systems"]
[null,null,null,null,"Does the project include single zone systems?",null,null,null,null,null,"No"]
[]
[null,null,null,null,"Multiple Zone and 100% Outdoor Air Systems"]
[null,null,null,null,"Add a tab for each multiple zone and 100% outdoor air system in the project using the \"Add System\" button below."]
[]
[]
[null,null,null,null,"Step 6."]
[null,null,null,null,"Complete the ventilation rate procedure (VRP) for each ventilation system, at the specified analysis condition.  "]
[]
[null,null,null,null,"Step 7."]
[null,null,null,null,"Upload the completed spreadsheet to LEED Online.  Complete any related summary fields in the LEED credit form with the results of the calculator."]
[]
[]
[]
[null,null,"Assumptions"]
[null,null,"Zone Air Distribution Effectiveness (Ez)"]
[null,null,"Code",null,null,"Air Distribution Configuration",null,null,null,null,"Ez"]
[null,null,"CS",null,null,"Ceiling supply of cool air",null,null,null,null,1]
[null,null,"CSFR",null,null,"Ceiling supply of warm air and floor return",null,null,null,null,1]
[null,null,"CSCRH",null,null,"Ceiling supply of warm air 15°F (8°C) or more above space temperature and ceiling return",null,null,null,null,0.8]
[null,null,"CSCRW ",null,null,"Ceiling supply of warm air less than 15°F (8°C) above space temperature and ceiling return provided that the 150 fpm (0.8 m/s) supply air jet reaches to within 4.5 ft (1.4 m) of floor level. Note: For lower velocity supply air, Ez = 0.8.",null,null,null,null,1]
[null,null,"FSCR ",null,null,"Floor supply of cool air and ceiling return provided that the 150 fpm (0.8 m/s) supply jet reaches 4.5 ft (1.4 m) or more above the floor. Note: Most underfloor air distribution systems comply with this proviso.",null,null,null,null,1]
[null,null,"FSCR-LV",null,null,"Floor supply of cool air and ceiling return, provided low-velocity displacement ventilation achieves unidirectional flow and thermal stratification",null,null,null,null,1.2]
[null,null,"FSFR",null,null,"Floor supply of warm air and floor return",null,null,null,null,1]
[null,null,"FSCRW",null,null,"Floor supply of warm air and ceiling return",null,null,null,null,0.7]
[null,null,"MUEX",null,null,"Makeup supply drawn in on the opposite side of the room from the exhaust and/or return",null,null,null,null,0.8]
[null,null,"MU-EX",null,null,"Makeup supply drawn in near to the exhaust and/or return location",null,null,null,null,0.5]
[null,null,"Source: ASHRAE 62.1, Table 6-2"]
[]
[null,null,"System Ventilation Efficiency (Ev)"]
[null,null,"Max Zp",null,null,"Ev"]
[null,null,"<=0.15",null,null,1]
[null,null,"<=0.25",null,null,0.9]
[null,null,"<=0.35",null,null,0.8]
[null,null,"<=0.45",null,null,0.7]
[null,null,"<=0.55",null,null,0.6]
[null,null,">0.55",null,null,"user-entered"]
[null,null,"Source: ASHRAE 62.1, Table 6-3"]
[]
[null,null,"Zone Secondary Recirculation Fraction (Er)"]
[null,null,"System Configuration",null,null,null,null,null,null,null,"Er"]
[null,null,"Plenum return systems with secondary recirculation (e.g., fan-powered VAV with plenum return)",null,null,null,null,null,null,null,"<1.0"]
[null,null,"Ducted return systems with secondary recirculation (e.g., fan-powered VAV with ducted return)",null,null,null,null,null,null,null,0]
[null,null,"Systems with system-level recirculation (e.g., dual-fan dual-duct systems with ducted return)",null,null,null,null,null,null,null,1]
[null,null,"Other system types",null,null,null,null,null,null,null,0.75]
[null,null,"Source: ASHRAE 62.1, Section A1.2.2"]
[]
[null,null,"Occupancy"]
[null,null,"Occupancy \nCategory ",null,null,null,"People OA Rate",null,"Area OA Rate",null,"Default Occupant Density ",null,null,"9= 2009 only\n4=v4 only\nB= Both"]
[null,null,null,null,null,null,"(cfm per person)","(l/s per person)","(cfm per sq ft) ","(l/s per sq m)"]
[null,null,"Art classroom ",null,null,null,10,5,0.18,0.9,20,null,null,"B"]
[null,null,"Auditorium seating area ",null,null,null,5,2.5,0.06,0.3,150,null,null,"B"]
[null,null,"Bank vault / safe deposit ",null,null,null,5,2.5,0.06,0.3,5,null,null,"B"]
[null,null,"Banks or bank lobbies",null,null,null,7.5,3.8,0.06,0.3,15,null,null,4]
[null,null,{"$f":"IF($O$165=1,\"Barber shop\",\"Barbershop\")","v":"Barbershop"},null,null,null,7.5,3.8,0.06,0.3,25,null,null,"B"]
[null,null,"Barracks sleeping areas ",null,null,null,5,2.5,0.06,0.3,20,null,null,"B"]
[null,null,"Bars / cocktail lounges ",null,null,null,7.5,3.8,0.18,0.9,100,null,null,"B"]
[null,null,"Beauty and nail salon ",null,null,null,20,10,0.12,0.6,25,null,null,"B"]
[null,null,"Bedroom / living room ",null,null,null,5,2.5,0.06,0.3,10,null,null,"B"]
[null,null,"Booking / waiting ",null,null,null,7.5,3.8,0.06,0.3,50,null,null,"B"]
[null,null,"Bowling alley (seating)",null,null,null,10,5,0.12,0.6,40,null,null,"B"]
[null,null,"Break rooms (general)",null,null,null,5,2.5,0.06,0.3,25,null,null,"B"]
[null,null,"Breakrooms (office buildings)",null,null,null,5,2.5,0.12,0.6,50,null,null,4]
[null,null,"Cafeteria / fast food dining ",null,null,null,7.5,3.8,0.18,0.9,100,null,null,"B"]
[null,null,"Cell",null,null,null,5,2.5,0.12,0.6,25,null,null,"B"]
[null,null,"Classrooms (age 9 plus)",null,null,null,10,5,0.12,0.6,35,null,null,"B"]
[null,null,"Classrooms (ages 5-8)",null,null,null,10,5,0.12,0.6,25,null,null,"B"]
[null,null,"Coffee stations",null,null,null,5,2.5,0.06,0.3,20,null,null,"B"]
[null,null,"Coin-operated laundries ",null,null,null,7.5,3.8,{"$f":"IF($O$165=1,\"0.06\",\"0.12\")","v":"0.12"},{"$f":"IF($O$165=1,\"0.3\",\"0.6\")","v":"0.6"},20,null,null,"B"]
[null,null,"Common corridors",null,null,null,0,0,0.06,0.3,0,null,null,"B"]
[null,null,"Computer (not printing ) ",null,null,null,5,2.5,0.06,0.3,4,null,null,"B"]
[null,null,"Computer lab",null,null,null,10,5,0.12,0.6,25,null,null,"B"]
[null,null,"Conference / meeting ",null,null,null,5,2.5,0.06,0.3,50,null,null,"B"]
[null,null,"Corridors ",null,null,null,0,0,0.06,0.3,0,null,null,"B"]
[null,null,"Courtrooms ",null,null,null,5,2.5,0.06,0.3,70,null,null,"B"]
[null,null,"Day room ",null,null,null,5,2.5,0.06,0.3,30,null,null,"B"]
[null,null,"Daycare (through age 4)",null,null,null,10,5,0.18,0.9,25,null,null,"B"]
[null,null,"Daycare sickroom",null,null,null,10,5,0.18,0.9,25,null,null,9]
[null,null,"Disco / dance floors ",null,null,null,20,10,0.06,0.3,100,null,null,"B"]
[null,null,"Dwelling unit",null,null,null,5,2.5,0.06,0.3,"n/a",null,null,9]
[null,null,"Dwelling unit - studio or one-bedroom",null,null,null,5,2.5,0.06,0.3,2,null,null,4]
[null,null,"Dwelling unit - three-bedroom",null,null,null,5,2.5,0.06,0.3,4,null,null,4]
[null,null,"Dwelling unit - two-bedroom",null,null,null,5,2.5,0.06,0.3,3,null,null,4]
[null,null,"Electrical equipment rooms",null,null,null,0,0,0.06,0.3,0,null,null,9]
[null,null,"Elevator machine rooms",null,null,null,0,0,0.12,0.6,0,null,null,9]
[null,null,"Gambling casinos ",null,null,null,7.5,3.8,0.18,0.9,120,null,null,"B"]
[null,null,"Game arcades ",null,null,null,7.5,3.8,0.18,0.9,20,null,null,"B"]
[null,null,"General manufacturing (excludes heavy \nindustrial and processes using chemicals)",null,null,null,10,5,0.18,0.9,7,null,null,4]
[null,null,"Guard stations",null,null,null,5,2.5,0.06,0.3,15,null,null,"B"]
[null,null,"Gym, stadium (play area)",null,null,null,0,0,0.3,1.5,30,null,null,"B"]
[null,null,"Health club / aerobics",null,null,null,20,10,0.06,0.3,40,null,null,"B"]
[null,null,"Health club / weight",null,null,null,20,10,0.06,0.3,10,null,null,"B"]
[null,null,"Kitchen (cooking)",null,null,null,7.5,3.8,0.12,0.6,20,null,null,4]
[null,null,"Laundry rooms within dwelling units",null,null,null,5,2.5,0.12,0.6,10,null,null,"B"]
[null,null,"Laundry rooms, central",null,null,null,5,2.5,0.12,0.6,10,null,null,"B"]
[null,null,"Lecture classroom ",null,null,null,7.5,3.8,0.06,0.3,65,null,null,"B"]
[null,null,"Lecture hall (fixed seats)",null,null,null,7.5,3.8,0.06,0.3,150,null,null,"B"]
[null,null,"Legislative chambers ",null,null,null,5,2.5,0.06,0.3,50,null,null,"B"]
[null,null,"Libraries ",null,null,null,5,2.5,0.12,0.6,10,null,null,"B"]
[null,null,"Lobbies ",null,null,null,5,2.5,0.06,0.3,150,null,null,"B"]
[null,null,"Lobbies / prefunction ",null,null,null,7.5,3.8,0.06,0.3,30,null,null,"B"]
[null,null,"Main entry lobbies ",null,null,null,5,2.5,0.06,0.3,10,null,null,"B"]
[null,null,"Mall common areas ",null,null,null,7.5,3.8,0.06,0.3,40,null,null,"B"]
[null,null,"Media center ",null,null,null,10,5,0.12,0.6,25,null,null,"B"]
[null,null,"Multi-purpose assembly ",null,null,null,5,2.5,0.06,0.3,120,null,null,"B"]
[null,null,"Multi-use assembly ",null,null,null,7.5,3.8,0.06,0.3,100,null,null,"B"]
[null,null,"Museums (children's)",null,null,null,7.5,3.8,0.12,0.6,40,null,null,"B"]
[null,null,"Museums / galleries ",null,null,null,7.5,3.8,0.06,0.3,40,null,null,"B"]
[null,null,"Music / theater/ dance ",null,null,null,10,5,0.06,0.3,35,null,null,"B"]
[null,null,"Occupiable storage rooms for dry materials",null,null,null,5,2.5,0.06,0.3,2,null,null,4]
[null,null,"Occupiable storage rooms for liquids or gels",null,null,null,5,2.5,0.12,0.6,2,null,null,4]
[null,null,"Office space ",null,null,null,5,2.5,0.06,0.3,5,null,null,"B"]
[null,null,{"$f":"IF($O$165=1,\"Pet shops\",\"Pet shops (animal areas)\")","v":"Pet shops (animal areas)"},null,null,null,7.5,3.8,0.18,0.9,10,null,null,"B"]
[null,null,"Pharmacy (prep, area)",null,null,null,5,2.5,0.18,0.9,10,null,null,"B"]
[null,null,"Photo studios",null,null,null,5,2.5,0.12,0.6,10,null,null,"B"]
[null,null,"Places of religious worship",null,null,null,5,2.5,0.06,0.3,120,null,null,"B"]
[null,null,"Reception areas ",null,null,null,5,2.5,0.06,0.3,30,null,null,"B"]
[null,null,"Restaurant dining rooms ",null,null,null,7.5,3.8,0.18,0.9,70,null,null,"B"]
[null,null,"Sales ",null,null,null,7.5,3.8,0.12,0.6,15,null,null,"B"]
[null,null,"Science laboratories",null,null,null,10,5,0.18,0.9,25,null,null,"B"]
[null,null,"Shipping / receiving ",null,null,null,{"$f":"IF($O$165=1,\"0\",\"10\")","v":"10"},{"$f":"IF($O$165=1,\"0\",\"5\")","v":"5"},0.12,0.6,{"$f":"IF($O$165=1,\"0\",\"2\")","v":"2"},null,null,"B"]
[null,null,"Sorting, packing, light assembly",null,null,null,7.5,3.8,0.12,0.6,7,null,null,4]
[null,null,"Spectator areas ",null,null,null,7.5,3.8,0.06,0.3,150,null,null,"B"]
[null,null,"Sports arena (play area)",null,null,null,0,0,0.3,1.5,0,null,null,"B"]
[null,null,"Stages, studios ",null,null,null,10,5,0.06,0.3,70,null,null,"B"]
[null,null,"Storage rooms ",null,null,null,0,0,0.12,0.6,0,null,null,9]
[null,null,"Supermarket ",null,null,null,7.5,3.8,0.06,0.3,8,null,null,"B"]
[null,null,"Swimming (pool & deck)",null,null,null,0,0,0.48,2.4,0,null,null,"B"]
[null,null,"Telephone / data entry ",null,null,null,5,2.5,0.06,0.3,60,null,null,"B"]
[null,null,"Telephone closets",null,null,null,0,0,0,0,0,null,null,4]
[null,null,"Transportation waiting",null,null,null,7.5,3.8,0.06,0.3,100,null,null,"B"]
[null,null,"University / college laboratories",null,null,null,10,5,0.18,0.9,25,null,null,4]
[null,null,"Warehouses",null,null,null,{"$f":"IF($O$165=1,\"0\",\"10\")","v":"10"},{"$f":"IF($O$165=1,\"0\",\"5\")","v":"5"},0.06,0.3,0,null,null,"B"]
[null,null,"Wood / metal shop ",null,null,null,10,5,0.18,0.9,20,null,null,"B"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"v2.1"]
[null,null,null,null,null,null,null,null,null,null,null,"Copyright © 2012"]
[null,null,null,null,null,null,null,null,null,null,null,"U.S. Green Building Council"]
[null,null,null,null,null,null,null,null,null,null,null,"All Rights Reserved"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"UOM","LEED","Credit"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(K10=\"IP units\",1,2)","v":1},{"$f":"IF(K14=\"LEED 2009\",1,2)","v":2},{"$f":"IF(K18=\"Yes\",1,2)","v":2}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"1 = IP, 2 = SI","1 = 2009, 2 = v4","1 = yes, 2 = no"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"LEED2009","LEEDv4","Single Zone"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Art classroom ","Art classroom ",{"$f":"IF(K23=\"Yes\",1,2)","v":2}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Auditorium seating area ","Auditorium seating area ","1 = yes, 2 = no"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Bank vault / safe deposit ","Bank vault / safe deposit "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Barber shop","Banks or bank lobbies"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Barracks sleeping areas ","Barbershop"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Bars / cocktail lounges ","Barracks sleeping areas "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Beauty and nail salon ","Bars / cocktail lounges "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Bedroom / living room ","Beauty and nail salon "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Booking / waiting ","Bedroom / living room "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Bowling alley (seating)","Booking / waiting "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Break rooms (general)","Bowling alley (seating)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Cafeteria / fast food dining ","Break rooms (general)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Cell","Breakrooms (office buildings)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Classrooms (age 9 plus)","Cafeteria / fast food dining "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Classrooms (ages 5-8)","Cell"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Coffee stations","Classrooms (age 9 plus)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Coin-operated laundries ","Classrooms (ages 5-8)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Common corridors","Coffee stations"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Computer (not printing ) ","Coin-operated laundries "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Computer lab","Common corridors"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Conference / meeting ","Computer (not printing ) "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Corridors ","Computer lab"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Courtrooms ","Conference / meeting "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Day room ","Corridors "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Daycare (through age 4)","Courtrooms "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Daycare sickroom","Day room "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Disco / dance floors ","Daycare (through age 4)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Dwelling unit","Disco / dance floors "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Electrical equipment rooms","Dwelling unit - studio or one-bedroom"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Elevator machine rooms","Dwelling unit - three-bedroom"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Gambling casinos ","Dwelling unit - two-bedroom"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Game arcades ","Gambling casinos "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Guard stations","Game arcades "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Gym, stadium (play area)","General manufacturing (excludes heavy \nindustrial and processes using chemicals)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Health club / aerobics","Guard stations"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Health club / weight","Gym, stadium (play area)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Laundry rooms within dwelling units","Health club / aerobics"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Laundry rooms, central","Health club / weight"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Lecture classroom ","Kitchen (cooking)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Lecture hall (fixed seats)","Laundry rooms within dwelling units"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Legislative chambers ","Laundry rooms, central"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Libraries ","Lecture classroom "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Lobbies ","Lecture hall (fixed seats)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Lobbies / prefunction ","Legislative chambers "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Main entry lobbies ","Libraries "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Mall common areas ","Lobbies "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Media center ","Lobbies / prefunction "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Multi-purpose assembly ","Main entry lobbies "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Multi-use assembly ","Mall common areas "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Museums (children's)","Media center "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Museums / galleries ","Multi-purpose assembly "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Music / theater/ dance ","Multi-use assembly "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Office space ","Museums (children's)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Pet shops","Museums / galleries "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Pharmacy (prep, area)","Music / theater/ dance "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Photo studios","Occupiable storage rooms for dry materials"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Places of religious worship","Occupiable storage rooms for liquids or gels"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Reception areas ","Office space "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Restaurant dining rooms ","Pet shops (animal areas)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Sales ","Pharmacy (prep, area)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Science laboratories","Photo studios"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Shipping / receiving ","Places of religious worship"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Spectator areas ","Reception areas "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Sports arena (play area)","Restaurant dining rooms "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Stages, studios ","Sales "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Storage rooms ","Science laboratories"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Supermarket ","Shipping / receiving "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Swimming (pool & deck)","Sorting, packing, light assembly"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Telephone / data entry ","Spectator areas "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Transportation waiting","Sports arena (play area)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Warehouses","Stages, studios "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Wood / metal shop ","Supermarket "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Swimming (pool & deck)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Telephone / data entry "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Telephone closets"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Transportation waiting"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"University / college laboratories"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Warehouses"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Wood / metal shop "]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"max Zpz","Ev"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,1.1499999999999999]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.01,1.1399999999999999]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.02,1.1299999999999999]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.03,1.1200000000000001]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.04,1.1100000000000001]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.05,1.1000000000000001]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.06,1.0900000000000001]
[null,null,null,null,null,null,null,null,null,null,null,null,null,7.0000000000000007E-2,1.08]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.08,1.07]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.09,1.06]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.1,1.05]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.11,1.04]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.12,1.03]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.13,1.02]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.14000000000000001,1.01]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.15,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.16,0.99]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.17,0.98]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.18,0.97]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.19,0.96]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.2,0.95]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.21,0.94]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.22,0.92999999999999994]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.23,0.91999999999999993]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.24,0.90999999999999992]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.25,0.89999999999999991]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.26,0.8899999999999999]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.27,0.87999999999999989]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.28000000000000003,0.86999999999999988]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.28999999999999998,0.85999999999999988]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.3,0.84999999999999987]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.31,0.83999999999999986]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.32,0.82999999999999985]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.33,0.81999999999999984]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.34,0.80999999999999983]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.35,0.79999999999999982]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.36,0.78999999999999981]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.37,0.7799999999999998]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.38,0.7699999999999998]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.39,0.75999999999999979]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.4,0.74999999999999978]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.41,0.73999999999999977]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.42,0.72999999999999976]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.43,0.71999999999999975]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.44,0.70999999999999974]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.45,0.69999999999999973]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.46,0.68999999999999972]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.47,0.67999999999999972]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.48,0.66999999999999971]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.49,0.6599999999999997]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.5,0.64999999999999969]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.51,0.63999999999999968]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.52,0.62999999999999967]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.53,0.61999999999999966]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.54,0.60999999999999965]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.55000000000000004,0.59999999999999964]

{"sheet":"Multiple Zone","index":1,"n_rows":38,"n_cols":36,"rows_kept":38,"cut":false,"hidden":true,"merged":[[29,1,29,3],[5,1,5,2],[6,1,6,2],[12,2,12,3],[15,2,15,3],[14,2,14,3],[7,1,7,2],[9,10,10,10],[9,1,11,1],[9,2,11,3],[9,5,11,5],[16,2,16,3],[9,9,10,9],[13,2,13,3]]}
[]
[null,"Multiple zone",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Floor area","Population","Rp","Ra","D","Ez average","Ev","Vps","Xs","Required Vot","Actual"]
[null,{"$f":"REPLACE(CELL(\"filename\",A1),1,FIND(\"]\",CELL(\"filename\",A1)),\"\")","v":"Multiple Zone"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Area","v":0},{"$f":"$E$21","v":0},{"$f":"IFERROR(IF(Allzones=\"Yes\",(SUM($J14:$J17)/SUM($G14:$G17)),$E$24),0)","v":0},{"$f":"IFERROR(IF(Allzones=\"Yes\",(SUM($K14:$K17)/Area),$E$25),0)","v":0},{"$f":"$E$23","v":0},{"$f":"IFERROR(AVERAGEIF($M$14:$M$17,\"<>0\"),0)","v":0},{"$f":"Ev","v":0},{"$f":"Airflow_cz","v":0},{"$f":"$E$28","v":0},{"$f":"ROUND(E36,0)","v":0},{"$f":"ROUND(E38,0)","v":0}]
[]
[null,"Show simple view",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,true]
[null,"System name and number",null,{"$f":"B3","v":"Multiple Zone"}]
[null,"Condition analyzed (impacts Ez, Vdz, Vpz and Vps)"]
[null,"All zones are included in the VRP calculation"]
[]
[null,"Zone Name \nand Number","Occupancy \nCategory",null,"Zone \nFloor Area","Are you using default value for zone population?","Zone \nPopulation","People \nOutdoor \nAir Rate ","Area\nOutdoor\nAir Rate","Breathing \nZone Outdoor Airflow\n(people related portion)","Breathing\nZone Outdoor\nAirflow\n(area related portion)","Breathing \nZone Outdoor Airflow","Zone Air Distribution Effectiveness","Zone \nOutdoor \nAirflow","Zone \nDischarge Airflow","Zone \nPrimary \nAirflow","Primary Outdoor Air Fraction","Zone Secondary Recirculation Fraction","Zone Primary Air Fraction","Supply Air Fraction","Mixed Air Fraction","Outdoor Air Fraction","Zone Ventilation Efficiency (Appendix A)",null,"Default Pz","Nondefault\nPz","Occupant Density","Zone name for critical zone lookup"]
[null,null,null,null,"Az",null,"Pz","Rp","Ra",null,null,"Vbz","Ez","Voz","Vdz","Vpz","Zpz","Er","Ep","Fa","Fb","Fc","Evz"]
[null,null,null,null,{"$f":"IF(Instructions!$N$165=1,\"(sq ft)\",\"(sq m)\")","v":"(sq ft)"},null,"(people)",{"$f":"IF(Instructions!$N$165=1,Instructions!$G$72,Instructions!$H$72)","v":"(cfm per person)"},{"$f":"IF(Instructions!$N$165=1,Instructions!$I$72,Instructions!$J$72)","v":"(cfm per sq ft) "},{"$f":"IF(Instructions!$N$165=1,\"(cfm)\",\"(l/s)\")","v":"(cfm)"},{"$f":"IF(Instructions!$N$165=1,\"(cfm)\",\"(l/s)\")","v":"(cfm)"},{"$f":"IF(Instructions!$N$165=1,\"(cfm)\",\"(l/s)\")","v":"(cfm)"},null,{"$f":"IF(Instructions!$N$165=1,\"(cfm)\",\"(l/s)\")","v":"(cfm)"},{"$f":"IF(Instructions!$N$165=1,\"(cfm)\",\"(l/s)\")","v":"(cfm)"},{"$f":"IF(Instructions!$N$165=1,\"(cfm)\",\"(l/s)\")","v":"(cfm)"},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Instructions!$N$165=1,\"(occupants per 1,000 sq ft)\",\"(occupants per 100 sq m)\")","v":"(occupants per 1,000 sq ft)"}]
["A",null,null,null,null,null,null,null,null,"Rp Pz","Ra Az",{"$f":"IF(credit=1,\"(Rp Pz + Ra Az)*1.3\",\"Rp Pz + Ra Az\")","v":"Rp Pz + Ra Az"},null,"Vbz / Ez",null,null,"Voz / Vpz",null,null,"Ep + (1-Ep) Er","Ep","1-(1-Ez)(1-Er)(1-Ep)","(Fa+Xs * Fb-Zpz *Ep*Fc)/Fa"]
[{"$f":"IF(C14=0,0,0)","v":0},null,null,null,null,null,null,{"$f":"IFERROR(IF(Instructions!$N$165=1,VLOOKUP(C14,Instructions!$C$73:$K$156,5,FALSE),VLOOKUP(C14,Instructions!$C$73:$K$156,6,FALSE)),0)","v":0},{"$f":"IFERROR(IF(Instructions!$N$165=1,VLOOKUP(C14,Instructions!$C$73:$K$156,7,FALSE),VLOOKUP(C14,Instructions!$C$73:$K$156,8,FALSE)),0)","v":0},{"$f":"IFERROR(H14*G14,0)","v":0},{"$f":"IFERROR(I14*E14,0)","v":0},{"$f":"IFERROR(IF(credit=2,SUM(J14:K14),SUM(J14:K14)*1.3),0)","v":0},null,{"$f":"IFERROR(L14/M14,0)","v":0},null,null,{"$f":"IFERROR(ROUND(N14/P14,2),0)","v":0},null,null,{"$f":"IFERROR(S14+(1-S14)*R14,0)","v":0},{"$f":"S14","v":0},{"$f":"IFERROR(1-(1-M14)*(1-R14)*(1-S14),0)","v":0},{"$f":"IFERROR(IF($E$28>0,(T14+$E$28 * U14-Q14 * S14 * V14)/T14,0),0)","v":0},null,{"$f":"IFERROR(IF(Instructions!$N$165=1,($AA14/1000)*$E14,($AA14/100)*$E14),0)","v":0},null,{"$f":"IFERROR(VLOOKUP($C14,Instructions!$C$73:$K$156,9,FALSE),0)","v":0},{"$f":"B14","v":0}]
[{"$f":"IF(C15=0,0,0)","v":0},null,null,null,null,null,null,{"$f":"IFERROR(IF(Instructions!$N$165=1,VLOOKUP(C15,Instructions!$C$73:$K$156,5,FALSE),VLOOKUP(C15,Instructions!$C$73:$K$156,6,FALSE)),0)","v":0},{"$f":"IFERROR(IF(Instructions!$N$165=1,VLOOKUP(C15,Instructions!$C$73:$K$156,7,FALSE),VLOOKUP(C15,Instructions!$C$73:$K$156,8,FALSE)),0)","v":0},{"$f":"IFERROR(H15*G15,0)","v":0},{"$f":"IFERROR(I15*E15,0)","v":0},0,null,{"$f":"IFERROR(L15/M15,0)","v":0},null,null,{"$f":"IFERROR(ROUND(N15/P15,2),0)","v":0},null,null,{"$f":"IFERROR(S15+(1-S15)*R15,0)","v":0},{"$f":"S15","v":0},{"$f":"IFERROR(1-(1-M15)*(1-R15)*(1-S15),0)","v":0},{"$f":"IFERROR(IF($E$28>0,(T15+$E$28 * U15-Q15 * S15 * V15)/T15,0),0)","v":0},null,{"$f":"IFERROR(IF(Instructions!$N$165=1,($AA15/1000)*$E15,($AA15/100)*$E15),0)","v":0},null,{"$f":"IFERROR(VLOOKUP($C15,Instructions!$C$73:$K$156,9,FALSE),0)","v":0},{"$f":"B15","v":0}]
[0,null,null,null,null,null,null,{"$f":"IFERROR(IF(Instructions!$N$165=1,VLOOKUP(C16,Instructions!$C$73:$K$156,5,FALSE),VLOOKUP(C16,Instructions!$C$73:$K$156,6,FALSE)),0)","v":0},{"$f":"IFERROR(IF(Instructions!$N$165=1,VLOOKUP(C16,Instructions!$C$73:$K$156,7,FALSE),VLOOKUP(C16,Instructions!$C$73:$K$156,8,FALSE)),0)","v":0},0,0,0,null,0,null,null,0,null,null,0,0,{"$f":"IFERROR(1-(1-M16)*(1-R16)*(1-S16),0)","v":0},0,null,{"$f":"IFERROR(IF(Instructions!$N$165=1,($AA16/1000)*$E16,($AA16/100)*$E16),0)","v":0},null,{"$f":"IFERROR(VLOOKUP($C16,Instructions!$C$73:$K$156,9,FALSE),0)","v":0},{"$f":"B16","v":0}]
[0,null,null,null,null,null,null,{"$f":"IFERROR(IF(Instructions!$N$165=1,VLOOKUP(C17,Instructions!$C$73:$K$156,5,FALSE),VLOOKUP(C17,Instructions!$C$73:$K$156,6,FALSE)),0)","v":0},{"$f":"IFERROR(IF(Instructions!$N$165=1,VLOOKUP(C17,Instructions!$C$73:$K$156,7,FALSE),VLOOKUP(C17,Instructions!$C$73:$K$156,8,FALSE)),0)","v":0},0,0,0,null,{"$f":"IFERROR(L17/M17,0)","v":0},null,null,0,null,null,{"$f":"IFERROR(S17+(1-S17)*R17,0)","v":0},{"$f":"S17","v":0},{"$f":"IFERROR(1-(1-M17)*(1-R17)*(1-S17),0)","v":0},0,null,{"$f":"IFERROR(IF(Instructions!$N$165=1,($AA17/1000)*$E17,($AA17/100)*$E17),0)","v":0},null,{"$f":"IFERROR(VLOOKUP($C17,Instructions!$C$73:$K$156,9,FALSE),0)","v":0},{"$f":"B17","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"all zones","critical zones"]
[null,"System area","As",{"$f":"IF(Instructions!$N$165=1,\"(sq ft)\",\"(sq m)\")","v":"(sq ft)"},null,{"$f":"IF(D8=\"Yes\",\"Net occupiable floor area served by the ventilation system\", \"∑Az\")","v":"∑Az"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM($E14:$E17)","v":0}]
[null,"System population","Ps","(people)"]
[null,"Sum of zone population","sum of Pz","(people)",{"$f":"SUM(G14:G17)","v":0},"∑Pz"]
[null,"Occupant diversity","D",null,{"$f":"IFERROR(E21/E22,0)","v":0},"Ps / ∑Pz"]
[null,"People outdoor air rate for system","Rp system",{"$f":"IF(Instructions!$N$165=1,Instructions!$G$72,Instructions!$H$72)","v":"(cfm per person)"}]
[null,"Area outdoor air rate for system","Ra system",{"$f":"IF(Instructions!$N$165=1,Instructions!$I$72,Instructions!$J$72)","v":"(cfm per sq ft) "}]
[null,"Uncorrected outdoor air intake","Vou",{"$f":"IF(Instructions!$N$165=1,\"(cfm)\",\"(l/s)\")","v":"(cfm)"},{"$f":"IF(ISBLANK($E$21),0,IF(credit=2,IF(D8=\"No\",E24*E21+E25*E20,E23*SUM(J14:J17)+SUM(K14:K17)),IF(D8=\"No\",(E24*E21+E25*E20)*1.3,(E23*SUM(J14:J17)+SUM(K14:K17))*1.3)))","v":0},{"$f":"IF(credit=1,IF($D$8=\"Yes\",\"(D ∑ (Rp Pz) + ∑(Ra Az))*1.3\",\"((Rp system Ps) + (Ra system As))*1.3\"),IF($D$8=\"Yes\",\"D ∑ (Rp Pz) + ∑(Ra Az)\",\"(Rp system Ps) + (Ra system As)\"))","v":"(Rp system Ps) + (Ra system As)"}]
[null,"System primary airflow (at condition analyzed)","Vps",{"$f":"IF(Instructions!$N$165=1,\"(cfm)\",\"(l/s)\")","v":"(cfm)"}]
[null,"Average outdoor air fraction","Xs",null,{"$f":"IFERROR(E26/Airflow_cz,0)","v":0},"Vou / Vps"]
[null,""]
[null,"Which method from ASHRAE 62.1 is being used to determine system ventilation efficiency (Ev)?"]
[null,"Max (Zpz)","Max Zpz",null,{"$f":"MAX($Q$14:$Q$17)","v":0}]
[null,"Zone ventilation efficiency (Table 6-3)","Evz",null,{"$f":"IF(E31>0,IF(E31=0,1.15,IF(E31>0.55,\"Use Appendix A\",VLOOKUP(E31,Instructions!$N$251:$O$305,2,TRUE))),0)","v":0}]
[null,"Minimum (Evz)",null,null,{"$f":"MIN(IF($C$14:$D$17>0,$W$14:$W$17))","v":0}]
[null,"Critical zone",null,null,{"$f":"VLOOKUP(E31,Q14:AB17,12,FALSE)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Not other","Other"]
[null,"Ventilation efficiency","Ev",null,null,{"$f":"IF(AND(E30<>\"Table 6-3\",E30<>\"Appendix A\"),\" \", \"Ventilation efficiency from critical zone\")","v":" "},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($E30=\"Table 6-3\",$E32,$E33)","v":0}]
[null,{"$f":"IF(credit=1,\"Outdoor air intake flow (30% above 62.1 requirement)\",\"Outdoor air intake flow (required by 62.1)\")","v":"Outdoor air intake flow (required by 62.1)"},"Vot",{"$f":"IF(Instructions!$N$165=1,\"(cfm)\",\"(l/s)\")","v":"(cfm)"},{"$f":"IFERROR(E26/E35,0)","v":0},"Vou / Ev"]
[]
[null,"Outdoor air intake flow provided (measured or design)",null,{"$f":"IF(Instructions!$N$165=1,\"(cfm)\",\"(l/s)\")","v":"(cfm)"}]

{"sheet":"100% OA","index":2,"n_rows":24,"n_cols":36,"rows_kept":24,"cut":false,"hidden":true,"merged":[[8,9,9,9],[8,10,9,10],[8,15,11,15],[8,17,10,17],[8,2,10,3],[11,2,11,3],[8,16,11,16],[12,2,12,3],[8,1,10,1],[8,5,10,5],[16,2,16,3],[15,2,15,3],[14,2,14,3],[13,2,13,3]]}
[]
[null,"100% Outdoor air",null,null,null,null,null,null,null,null,null,null,null,null,null,">>>>",">>>>",">>>>",">>>>",">>>>",">>>>",">>>>",">>>>",">>>>",">>>>","Floor area","Population","Rp","Ra","D","Ez average","Ev","Vps","Xs","Required Vot","Actual"]
[null,{"$f":"REPLACE(CELL(\"filename\",A1),1,FIND(\"]\",CELL(\"filename\",A1)),\"\")","v":"100% OA"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$E$20","v":0},{"$f":"$E$21","v":0},{"$f":"IFERROR(SUM($J$13:$J$17)/$E$21,0)","v":0},{"$f":"IFERROR(SUM($K$13:$K$17)/$E$20,0)","v":0},"n/a",{"$f":"IFERROR(AVERAGEIF($M$13:$M$17,\"<>0\"),0)","v":0},"n/a","n/a","n/a",{"$f":"ROUND($E$22,0)","v":0},{"$f":"ROUND($E$24,0)","v":0}]
[]
[null,"Show simple view",null,null,null,null,null,null,null,null,null,null,null,null,null,true]
[null,"System name and number",null,{"$f":"B3","v":"100% OA"}]
[null,"Condition analyzed (impacts Ez)"]
[]
[null,"Zone Name \nand Number","Occupancy\nCategory",null,"Zone \nFloor Area","Are you using default value for zone population?","Zone\nPopulation","People\nOutdoor \nAir Rate","Area\nOutdoor \nAir Rate","Breathing \nZone Outdoor Airflow\n(people related portion)","Breathing\nZone Outdoor\nAirflow\n(area related portion)","Breathing \nZone Outdoor Airflow","Zone Air Distribution Effectiveness","Zone \nOutdoor \nAirflow",null,"Default Pz","Default Pz","Occupant Density"]
[null,null,null,null,"Az",null,"Pz","Rp","Ra",null,null,"Vbz","Ez","Voz"]
["B",null,null,null,{"$f":"IF(Instructions!$N$165=1,\"(sq ft)\",\"(sq m)\")","v":"(sq ft)"},null,"(people)",{"$f":"IF(Instructions!$N$165=1,Instructions!$G$72,Instructions!$H$72)","v":"(cfm per person)"},{"$f":"IF(Instructions!$N$165=1,Instructions!$I$72,Instructions!$J$72)","v":"(cfm per sq ft) "},{"$f":"IF(Instructions!$N$165=1,\"(cfm)\",\"(l/s)\")","v":"(cfm)"},{"$f":"IF(Instructions!$N$165=1,\"(cfm)\",\"(l/s)\")","v":"(cfm)"},{"$f":"IF(Instructions!$N$165=1,\"(cfm)\",\"(l/s)\")","v":"(cfm)"},null,{"$f":"IF(Instructions!$N$165=1,\"(cfm)\",\"(l/s)\")","v":"(cfm)"}]
["A",null,null,null,null,null,null,null,null,"Rp Pz","Ra Az",{"$f":"IF(credit=1,\"(Rp Pz + Ra Az)*1.3\",\"Rp Pz + Ra Az\")","v":"Rp Pz + Ra Az"},null,"Vbz / Ez",null,null,null,{"$f":"IF(Instructions!N165=1,\"(occupants per 1,000 sq ft)\",\"(occupants per 100 sq m)\")","v":"(occupants per 1,000 sq ft)"}]
[{"$f":"IF(C13=0,0,0)","v":0},null,null,null,null,null,null,{"$f":"IFERROR(IF(Instructions!$N$165=1,VLOOKUP(C13,Instructions!$C$73:$K$156,5,FALSE),VLOOKUP(C13,Instructions!$C$73:$K$156,6,FALSE)),0)","v":0},{"$f":"IFERROR(IF(Instructions!$N$165=1,VLOOKUP(C13,Instructions!$C$73:$K$156,7,FALSE),VLOOKUP(C13,Instructions!$C$73:$K$156,8,FALSE)),0)","v":0},{"$f":"H13*G13","v":0},{"$f":"I13*E13","v":0},{"$f":"IF(credit=1,(J13+K13)*1.3,J13+K13)","v":0},null,{"$f":"IFERROR(L13/M13,0)","v":0},null,{"$f":"IFERROR(IF(Instructions!$N$165=1,($R13/1000)*$E13,($R13/100)*$E13),0)","v":0},null,{"$f":"IFERROR(VLOOKUP($C13,Instructions!$C$73:$K$156,9,FALSE),0)","v":0}]
[{"$f":"IF(C14=0,0,0)","v":0},null,null,null,null,null,null,{"$f":"IFERROR(IF(Instructions!$N$165=1,VLOOKUP(C14,Instructions!$C$73:$K$156,5,FALSE),VLOOKUP(C14,Instructions!$C$73:$K$156,6,FALSE)),0)","v":0},{"$f":"IFERROR(IF(Instructions!$N$165=1,VLOOKUP(C14,Instructions!$C$73:$K$156,7,FALSE),VLOOKUP(C14,Instructions!$C$73:$K$156,8,FALSE)),0)","v":0},0,0,0,null,0,null,{"$f":"IFERROR(IF(Instructions!$N$165=1,($R14/1000)*$E14,($R14/100)*$E14),0)","v":0},null,{"$f":"IFERROR(VLOOKUP($C14,Instructions!$C$73:$K$156,9,FALSE),0)","v":0}]
[{"$f":"IF(C15=0,0,0)","v":0},null,null,null,null,null,null,{"$f":"IFERROR(IF(Instructions!$N$165=1,VLOOKUP(C15,Instructions!$C$73:$K$156,5,FALSE),VLOOKUP(C15,Instructions!$C$73:$K$156,6,FALSE)),0)","v":0},{"$f":"IFERROR(IF(Instructions!$N$165=1,VLOOKUP(C15,Instructions!$C$73:$K$156,7,FALSE),VLOOKUP(C15,Instructions!$C$73:$K$156,8,FALSE)),0)","v":0},0,0,0,null,0,null,{"$f":"IFERROR(IF(Instructions!$N$165=1,($R15/1000)*$E15,($R15/100)*$E15),0)","v":0},null,{"$f":"IFERROR(VLOOKUP($C15,Instructions!$C$73:$K$156,9,FALSE),0)","v":0}]
[0,null,null,null,null,null,null,{"$f":"IFERROR(IF(Instructions!$N$165=1,VLOOKUP(C16,Instructions!$C$73:$K$156,5,FALSE),VLOOKUP(C16,Instructions!$C$73:$K$156,6,FALSE)),0)","v":0},{"$f":"IFERROR(IF(Instructions!$N$165=1,VLOOKUP(C16,Instructions!$C$73:$K$156,7,FALSE),VLOOKUP(C16,Instructions!$C$73:$K$156,8,FALSE)),0)","v":0},0,0,0,null,0,null,{"$f":"IFERROR(IF(Instructions!$N$165=1,($R16/1000)*$E16,($R16/100)*$E16),0)","v":0},null,{"$f":"IFERROR(VLOOKUP($C16,Instructions!$C$73:$K$156,9,FALSE),0)","v":0}]
[0,null,null,null,null,null,null,{"$f":"IFERROR(IF(Instructions!$N$165=1,VLOOKUP(C17,Instructions!$C$73:$K$156,5,FALSE),VLOOKUP(C17,Instructions!$C$73:$K$156,6,FALSE)),0)","v":0},{"$f":"IFERROR(IF(Instructions!$N$165=1,VLOOKUP(C17,Instructions!$C$73:$K$156,7,FALSE),VLOOKUP(C17,Instructions!$C$73:$K$156,8,FALSE)),0)","v":0},0,0,0,null,0,null,{"$f":"IFERROR(IF(Instructions!$N$165=1,($R17/1000)*$E17,($R17/100)*$E17),0)","v":0},null,{"$f":"IFERROR(VLOOKUP($C17,Instructions!$C$73:$K$156,9,FALSE),0)","v":0}]
[]
[]
[null,{"$f":"CONCATENATE(\"System area \",IF(Instructions!$N$165=1,\"(sq ft)\",\"(sq m)\"))","v":"System area (sq ft)"},"As",{"$f":"IF(Instructions!$N$165=1,\"(sq ft)\",\"(sq m)\")","v":"(sq ft)"},{"$f":"SUM(E13:E17)","v":0},"∑Az"]
[null,"System population","Ps","(people)",{"$f":"SUM(G13:G17)","v":0},"∑Pz"]
[null,{"$f":"IF(credit=1,\"Outdoor air intake flow (30% above 62.1 requirement)\",\"Outdoor air intake flow (required by 62.1)\")","v":"Outdoor air intake flow (required by 62.1)"},"Vot",{"$f":"IF(Instructions!$N$165=1,\"(cfm)\",\"(l/s)\")","v":"(cfm)"},{"$f":"SUM(N13:N17)","v":0},"∑Voz"]
[null,""]
[null,"Outdoor air intake flow provided (measured or design)",null,{"$f":"IF(Instructions!$N$165=1,\"(cfm)\",\"(l/s)\")","v":"(cfm)"}]

{"sheet":"Single Zone","index":3,"n_rows":13,"n_cols":17,"rows_kept":13,"cut":false,"hidden":true,"merged":[[6,14,9,14],[6,16,7,16],[8,16,9,16],[6,1,8,1],[6,2,8,2],[6,3,8,3],[6,12,7,12],[6,5,8,5],[6,15,9,15]]}
[]
[null,"Single zone"]
[null,"Single Zone"]
[]
[null,"Show simple view",null,null,null,null,null,null,null,null,null,null,null,null,true]
[]
[null,"System Name \nand Number","Condition\nAnalyzed (impacts Ez)","Occupancy \nCategory ","Zone \nFloor Area","Are you using default value for zone population?","Zone \nPopulation","People \nOutdoor \nAir Rate","Area\nOutdoor\nAir Rate","Breathing \nZone Outdoor Airflow","Zone Air Distribution Effectiveness","Zone \nOutdoor \nAirflow","Outdoor air intake flow provided (measured or design)",null,"Default Pz","Nondefault\nPz","Occupant Density"]
[null,null,null,null,"Az",null,"Pz","Rp","Ra","Vbz","Ez","Voz"]
["B",null,null,null,{"$f":"IF(Instructions!$N$165=1,\"(sq ft)\",\"(sq m)\")","v":"(sq ft)"},null,"people",{"$f":"IF(Instructions!$N$165=1,Instructions!$G$72,Instructions!$H$72)","v":"(cfm per person)"},{"$f":"IF(Instructions!$N$165=1,Instructions!$I$72,Instructions!$J$72)","v":"(cfm per sq ft) "},{"$f":"IF(Instructions!$N$165=1,\"(cfm)\",\"(l/s)\")","v":"(cfm)"},null,{"$f":"IF(Instructions!$N$165=1,\"(cfm)\",\"(l/s)\")","v":"(cfm)"},{"$f":"IF(Instructions!$N$165=1,\"(cfm)\",\"(l/s)\")","v":"(cfm)"},null,null,null,{"$f":"IF(Instructions!N165=1,\"Occupants \nper \n1,000 sq ft\",\"Occupants \nper \n100 sq m\")","v":"Occupants \nper \n1,000 sq ft"}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(credit=1,\"(Rp Pz + Ra Az)*1.3\",\"Rp Pz + Ra Az\")","v":"Rp Pz + Ra Az"},null,"Vbz / Ez"]
[null,"HIDDEN SPACER FOR SUMMARY"]
[{"$f":"IF(B12=0,0,0)","v":0},null,null,null,null,null,null,{"$f":"IFERROR(IF(Instructions!$N$165=1,VLOOKUP(D12,Instructions!$C$73:$K$156,5,FALSE),VLOOKUP(D12,Instructions!$C$73:$K$156,6,FALSE)),0)","v":0},{"$f":"IFERROR(IF(Instructions!$N$165=1,VLOOKUP(D12,Instructions!$C$73:$K$156,7,FALSE),VLOOKUP(D12,Instructions!$C$73:$K$156,8,FALSE)),0)","v":0},{"$f":"IF(credit=1,((I12*E12)+(H12*G12))*1.3,(I12*E12)+(H12*G12))","v":0},null,{"$f":"IFERROR(J12/K12,0)","v":0},null,null,{"$f":"IFERROR(IF(Instructions!$N$165=1,(Q12/1000)*$E12,($Q12/100)*$E12),0)","v":0},null,{"$f":"IFERROR(VLOOKUP($D12,Instructions!$C$73:$K$156,9,FALSE),0)","v":0}]
[{"$f":"IF(B13=0,0,0)","v":0},null,null,null,null,null,null,{"$f":"IFERROR(IF(Instructions!$N$165=1,VLOOKUP(D13,Instructions!$C$73:$K$156,5,FALSE),VLOOKUP(D13,Instructions!$C$73:$K$156,6,FALSE)),0)","v":0},{"$f":"IFERROR(IF(Instructions!$N$165=1,VLOOKUP(D13,Instructions!$C$73:$K$156,7,FALSE),VLOOKUP(D13,Instructions!$C$73:$K$156,8,FALSE)),0)","v":0},{"$f":"IF(credit=1,((I13*E13)+(H13*G13))*1.3,(I13*E13)+(H13*G13))","v":0},null,{"$f":"IFERROR(J13/K13,0)","v":0},null,null,{"$f":"IFERROR(IF(Instructions!$N$165=1,(Q13/1000)*$E13,($Q13/100)*$E13),0)","v":0},null,{"$f":"IFERROR(VLOOKUP($D13,Instructions!$C$73:$K$156,9,FALSE),0)","v":0}]

{"sheet":"Summary","index":4,"n_rows":21,"n_cols":22,"rows_kept":21,"cut":false,"hidden":false,"merged":[[20,3,20,6],[7,3,9,3],[7,4,9,4],[7,5,9,5],[7,6,9,6],[7,14,9,14],[7,15,9,15],[7,16,9,16],[7,18,9,18],[7,10,8,10],[7,11,9,11]]}
[]
[null,null,1]
[null,null,1,"Summary"]
[null,null,1,"Note: All information on this tab is READ-ONLY. To edit, see the previous tab(s). "]
[null,null,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,true]
[null,null,1,null,"Show simple view"]
[null,null,1]
[null,null,1,"System Name \nand Number","System \nType","All zones included \nin the VRP calculation?","Condition\nAnalyzed","System \nFloor Area","System Population",{"$f":"IF(credit=1,\"Outdoor Air \nIntake Flow \n(30% above 62.1 requirement)\",\"Outdoor Air \nIntake Flow \n(required by 62.1)\")","v":"Outdoor Air \nIntake Flow \n(required by 62.1)"},"Outdoor Air Intake Flow Provided\n(measured or design)","Outdoor air \nintake flow provided \nmeets or exceeds Vot?","People \nOutdoor \nAir Rate for System","Area\nOutdoor\nAir Rate for System","Occupant Diversity\nD","Average \nZone Air Distribution Effectiveness\nEz average","Ventilation\nEfficiency\nEv","System \nPrimary Airflow \n(at condition analyzed)","Average Outdoor Air Fraction\nXs"]
["B",null,null,null,null,null,null,"As","Ps","Vot",null,null,"Rp system","Ra system",null,null,null,"Vps"]
[null,null,1,null,null,null,null,{"$f":"IF(Instructions!$N$165=2,\"(sq m)\",\"(sq ft)\")","v":"(sq ft)"},"(people)",{"$f":"IF(Instructions!$N$165=2,\"(L/s)\",\"(cfm)\")","v":"(cfm)"},{"$f":"IF(Instructions!$N$165=2,\"(L/s)\",\"(cfm)\")","v":"(cfm)"},null,{"$f":"IF(Instructions!$N$165=1,Instructions!$G$72,Instructions!$H$72)","v":"(cfm per person)"},{"$f":"IF(Instructions!$N$165=1,Instructions!$I$72,Instructions!$J$72)","v":"(cfm per sq ft) "},null,null,null,{"$f":"IF(Instructions!$N$165=1,\"(cfm)\",\"(l/s)\")","v":"(cfm)"}]
[null,null,null,"Single Zone Systems"]
[null,null,null,{"$f":"'Single Zone'!$B12","v":0},{"$f":"'Single Zone'!$B$2","v":"Single zone"},{"$f":"IF(E12=\"Single zone\",\"n/a\",\"\")","v":"n/a"},{"$f":"'Single Zone'!$C12","v":0},{"$f":"'Single Zone'!$E12","v":0},{"$f":"'Single Zone'!G12","v":0},{"$f":"ROUND('Single Zone'!L12,0)","v":0},{"$f":"ROUND('Single Zone'!M12,0)","v":0},{"$f":"IF(AND(K12>0,J12>0,K12>=J12),\"Yes\",\"No\")","v":"No"},{"$f":"'Single Zone'!H12","v":0},{"$f":"'Single Zone'!I12","v":0},{"$f":"IF($E12=\"Single zone\",\"n/a\",\"\")","v":"n/a"},{"$f":"'Single Zone'!K12","v":0},{"$f":"IF($E12=\"Single zone\",\"n/a\",\"\")","v":"n/a"},"n/a","n/a"]
[null,null,null,{"$f":"'Single Zone'!$B13","v":0},{"$f":"'Single Zone'!$B$2","v":"Single zone"},{"$f":"IF(E13=\"Single zone\",\"n/a\",\"\")","v":"n/a"},{"$f":"'Single Zone'!$C13","v":0},{"$f":"'Single Zone'!$E13","v":0},{"$f":"'Single Zone'!G13","v":0},{"$f":"ROUND('Single Zone'!L13,0)","v":0},{"$f":"ROUND('Single Zone'!M13,0)","v":0},{"$f":"IF(AND(K13>0,J13>0,K13>=J13),\"Yes\",\"No\")","v":"No"},{"$f":"'Single Zone'!H13","v":0},{"$f":"'Single Zone'!I13","v":0},"n/a",{"$f":"'Single Zone'!K13","v":0},"n/a","n/a","n/a"]
[]
[null,null,null,"Multiple Zone Systems"]
[null,null,{"$f":"IFERROR(IF(OR(,D16=\"Multiple Zone\",D16=\"100% OA\",D16=\"Summary\",D16=\"Single Zone\",E16=\"100% Outdoor Air\"),0,1),0)","v":1},{"$f":"INDEX(MID(Sheets,FIND(\"]\",Sheets)+1,255),ROW(A1),1)","v":"Instructions"},{"$f":"INDIRECT(\"'\"&D16&\"'!$B$2\")","v":0},{"$f":"IF(E16=\"Multiple Zone\",INDIRECT(\"'\"&D16&\"'!$D$8\"),\"n/a\")","v":"n/a"},{"$f":"INDIRECT(\"'\"&D16&\"'!$D$7\")","v":0},{"$f":"INDIRECT(\"'\"&D16&\"'!$Z$3\")","v":0},{"$f":"INDIRECT(\"'\"&D16&\"'!$AA$3\")","v":0},{"$f":"INDIRECT(\"'\"&D16&\"'!$AI$3\")","v":0},{"$f":"INDIRECT(\"'\"&D16&\"'!$AJ$3\")","v":0},{"$f":"IF(AND(K16>0,J16>0,K16>=J16),\"Yes\",\"No\")","v":"No"},{"$f":"INDIRECT(\"'\"&D16&\"'!$AB$3\")","v":0},{"$f":"INDIRECT(\"'\"&D16&\"'!$AC$3\")","v":0},{"$f":"INDIRECT(\"'\"&D16&\"'!$AD$3\")","v":0},{"$f":"INDIRECT(\"'\"&D16&\"'!$AE$3\")","v":0},{"$f":"INDIRECT(\"'\"&D16&\"'!$AF$3\")","v":0},{"$f":"INDIRECT(\"'\"&D16&\"'!$AG$3\")","v":0},{"$f":"INDIRECT(\"'\"&D16&\"'!$AH$3\")","v":0}]
["A"]
[null,null,null,"100% Outdoor Air Systems"]
[null,null,{"$f":"IFERROR(IF(OR(D19=\"Multiple Zone\",D19=\"100% OA\",D19=\"Summary\",D19=\"Single Zone\",E19=\"Multiple Zone\"),0,1),0)","v":1},{"$f":"INDEX(MID(Sheets,FIND(\"]\",Sheets)+1,255),ROW(A1),1)","v":"Instructions"},{"$f":"INDIRECT(\"'\"&D19&\"'!$B$2\")","v":0},{"$f":"IF(E19=\"Multiple Zone\",INDIRECT(\"'\"&D19&\"'!$D$8\"),\"n/a\")","v":"n/a"},{"$f":"INDIRECT(\"'\"&D19&\"'!$D$7\")","v":0},{"$f":"INDIRECT(\"'\"&D19&\"'!$Z$3\")","v":0},{"$f":"INDIRECT(\"'\"&D19&\"'!$AA$3\")","v":0},{"$f":"INDIRECT(\"'\"&D19&\"'!$AI$3\")","v":0},{"$f":"INDIRECT(\"'\"&D19&\"'!$AJ$3\")","v":0},{"$f":"IF(AND(K19>0,J19>0,K19>=J19),\"Yes\",\"No\")","v":"No"},{"$f":"INDIRECT(\"'\"&D19&\"'!$AB$3\")","v":0},{"$f":"INDIRECT(\"'\"&D19&\"'!$AC$3\")","v":0},{"$f":"INDIRECT(\"'\"&D19&\"'!$AD$3\")","v":0},{"$f":"INDIRECT(\"'\"&D19&\"'!$AE$3\")","v":0},{"$f":"INDIRECT(\"'\"&D19&\"'!$AF$3\")","v":0},{"$f":"INDIRECT(\"'\"&D19&\"'!$AG$3\")","v":0},{"$f":"INDIRECT(\"'\"&D19&\"'!$AH$3\")","v":0}]
["C"]
[null,null,null,"Totals",null,null,null,{"$f":"SUM(H11:H20)","v":0},{"$f":"SUM(I11:I20)","v":0},{"$f":"SUM(J11:J20)","v":0},{"$f":"SUM(K11:K20)","v":0},null,null,null,null,null,null,{"$f":"SUM(R11:R20)","v":0}]