{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["Instructions","Assumptions","Background Noise","Sound Transmission (Isolation)","Reverberation Time","Noise Reduction Coefficient","Speech Privacy","Acoustical Finishes","Summary D+C","Summary SCH","Summary HC"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":15,"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":53,"n_cols":9,"rows_kept":53,"cut":false,"hidden":false,"merged":[[46,4,46,5],[2,4,2,5],[5,4,5,5],[45,4,45,5],[13,4,13,5],[19,4,19,5],[37,4,37,5],[34,4,34,5],[20,4,20,5],[29,4,29,5]]}
[]
[]
[null,null,null,null,"Acoustic Performance Calculator\nLEED v4 EQ Prerequisite Minimum Acoustic Performance and EQ Credit Acoustic 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","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,"Complete the following tabs:"]
[null,null,null,null,"Background Noise"]
[null,null,null,null,"Sound Transmission  (Isolation)"]
[null,null,null,null,"Reverberation Time"]
[]
[]
[null,null,null,null,"For Schools projects"]
[null,null,null,null,"For classrooms and core learning spaces less than 20,000 cu ft (566 cu m)"]
[null,null,null,null,"Option 1. Complete the following tabs:"]
[null,null,null,null,"Background Noise"]
[null,null,null,null,"Noise Reduction Coefficient"]
[]
[null,null,null,null,"Option 2. Complete the following tabs:"]
[null,null,null,null,"Background Noise"]
[null,null,null,null,"Reverberation Time"]
[]
[null,null,null,null,"For classrooms and core learning spaces greater than or equal to 20,000 cu ft (566 cu m)"]
[null,null,null,null,"Complete the following tabs:"]
[null,null,null,null,"Background Noise"]
[null,null,null,null,"Reverberation Time"]
[]
[null,null,null,null,"For projects attempting EQ Credit Acoustic Performance, complete the Sound Transmission tab."]
[]
[]
[null,null,null,null,"For Healthcare projects"]
[null,null,null,null,"Option 1. Complete the following tabs:"]
[null,null,null,null,"Background Noise"]
[null,null,null,null,"Sound Transmission (Isolation)"]
[null,null,null,null,"Speech Privacy"]
[]
[null,null,null,null,"Option 2. Complete the Acoustical Finishes tab."]
[]
[null,null,null,null,"Step 4. "]
[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,null,null,null,null,null,null,"UOM"]
[null,null,null,null,null,null,"V02",null,{"$f":"IF(F10=\"IP units\",1,2)","v":1}]
[null,null,null,null,null,null,"Copyright © 2012",null,"IP = 1, SI = 2"]
[null,null,null,null,null,null,"U.S. Green Building Council"]
[null,null,null,null,null,null,"All Rights Reserved"]

{"sheet":"Assumptions","index":1,"n_rows":149,"n_cols":11,"rows_kept":149,"cut":false,"hidden":false,"merged":[[5,1,6,2],[5,3,5,6],[137,3,137,4],[138,3,138,4],[124,6,124,7],[125,1,138,1],[124,3,124,4],[125,3,125,4],[126,3,126,4],[127,3,127,4],[128,3,128,4],[129,3,129,4],[130,3,130,4],[131,3,131,4],[132,3,132,4],[133,3,133,4],[134,3,134,4],[135,3,135,4],[136,3,136,4],[103,1,120,1],[75,3,75,5],[76,3,76,5],[77,3,77,5],[99,3,99,5],[63,1,79,1],[63,3,63,5],[64,3,64,5],[65,3,65,5],[66,3,66,5],[67,3,67,5],[68,3,68,5],[69,3,69,5],[70,3,70,5],[71,3,71,5],[91,3,91,5],[92,3,92,5],[78,3,78,5],[79,3,79,5],[72,3,72,5],[73,3,73,5],[74,3,74,5],[86,3,86,5],[87,3,87,5],[88,3,88,5],[85,3,85,5],[90,3,90,5],[7,1,38,1],[39,1,50,1],[54,3,54,5],[61,3,61,5],[54,1,62,1],[58,3,58,5],[59,3,59,5],[60,3,60,5],[55,3,55,5],[57,3,57,5],[80,1,99,1],[56,3,56,5],[142,1,148,1],[98,3,98,5],[97,3,97,5],[89,3,89,5],[62,3,62,5],[80,3,80,5],[81,3,81,5],[82,3,82,5],[93,3,93,5],[94,3,94,5],[95,3,95,5],[96,3,96,5],[83,3,83,5],[84,3,84,5]]}
[]
[null,"Assumptions"]
[]
[]
[null,"Background Noise"]
[null,"Space Type",null,"Sound Rating Method"]
[null,null,null,"NC/RC","dBA","dBC","RC (N)"]
[null,"2011 ASHRAE (Chapter 48, Table 1) and AHRI 885-2008 (Table 15)","Rooms with intrusion from outdoor noise sources - Traffic noise","n/a",45,70,"n/a"]
[null,null,"Rooms with intrusion from outdoor noise sources - Aircraft flyovers","n/a",45,70,"n/a"]
[null,null,"Residences, apartments, condominiums - Living areas",30,35,60,35]
[null,null,"Residences, apartments, condominiums - Bathrooms, kitchens, utility rooms",35,40,60,35]
[null,null,"Hotels/motels - Individual rooms or suites",30,35,60,35]
[null,null,"Hotels/motels - Meeting/banquet rooms",30,35,60,35]
[null,null,"Hotels/motels - Corridors and lobbies",40,45,65,45]
[null,null,"Hotels/motels - Service/support areas",40,45,65,45]
[null,null,"Office buildings - Executive and private offices",30,35,60,35]
[null,null,"Office buildings - Conference rooms",30,35,60,35]
[null,null,"Office buildings - Teleconference rooms",25,30,55,25]
[null,null,"Office buildings - Open-plan offices",40,45,65,40]
[null,null,"Office buildings - Corridors and lobbies",40,45,65,45]
[null,null,"Courtrooms - Unamplified speech",30,35,60,35]
[null,null,"Courtrooms - Amplified speech",35,40,60,40]
[null,null,"Performing arts spaces - Drama theaters, concert and recital halls",20,25,50,25]
[null,null,"Performing arts spaces - Music teaching studios",25,30,55,25]
[null,null,"Performing arts spaces - Music practice rooms",30,35,60,35]
[null,null,"Hospitals and clinics - Patient rooms",30,35,60,35]
[null,null,"Hospitals and clinics - Wards",35,40,60,40]
[null,null,"Hospitals and clinics - Operating and procedure rooms",35,40,60,35]
[null,null,"Hospitals and clinics - Corridors and lobbies",40,45,65,40]
[null,null,"Laboratories - Testing/research with minimal speech communication",50,55,75,55]
[null,null,"Laboratories - Extensive phone use and speech communication",45,50,70,50]
[null,null,"Laboratories - Group teaching",35,40,60,45]
[null,null,"Churches, mosques, synagogues - General assembly with critical music programs",25,30,55,35]
[null,null,"Schools - Classrooms",30,35,60,30]
[null,null,"Schools - Large lecture rooms with speech amplification",30,35,60,30]
[null,null,"Schools - Large lecture rooms without speech amplification",25,30,55,25]
[null,null,"Libraries - Libraries",30,35,60,40]
[null,null,"Indoor Stadiums, gymnasium - Gymnasiums and natatoriums",45,50,60,50]
[null,null,"Indoor Stadiums, gymnasium - Large-seating-capacity spaces with speech amplification",50,55,75,55]
[null,"2010 FGI Guidelines (Table 1.2-2)","Patient rooms",40,45,"n/a",40]
[null,null,"Multiple occupant patient care areas",45,50,"n/a",45]
[null,null,"NICU",35,40,"n/a",35]
[null,null,"Operating rooms",45,50,"n/a",45]
[null,null,"Corridors and public spaces",45,50,"n/a",45]
[null,null,"Testing/research lab, minimal speech",55,60,"n/a",55]
[null,null,"Research lab, extensive speech",50,55,"n/a",50]
[null,null,"Group teaching lab",45,50,"n/a",45]
[null,null,"Doctor's offices, exam rooms",40,45,"n/a",40]
[null,null,"Conference rooms",35,40,"n/a",35]
[null,null,"Teleconferencing rooms",25,30,"n/a",25]
[null,null,"Auditoriums, large lecture rooms",30,35,"n/a",30]
[]
[null,"Sound Transmission (Isolation)"]
[null,null,"Adjacency Combinations",null,null,null,"STC \nRating",null,null,"Unique Space Types"]
[null,"Rating System (Table 1)","Residence (within a multifamily residence), hotel, or motel room","Residence, hotel or motel room",null,null,55,null,null,"Residence (within a multifamily residence), hotel, or motel room"]
[null,null,"Residence, hotel or motel room","Common hallway, stairway",null,null,50,null,null,"Residence, hotel or motel room"]
[null,null,"Residence, hotel or motel room","Retail",null,null,60,null,null,"Retail"]
[null,null,"Retail","Retail",null,null,50,null,null,"Standard office"]
[null,null,"Standard office","Standard office",null,null,45,null,null,"Executive office"]
[null,null,"Executive office","Executive office",null,null,50,null,null,"Conference room"]
[null,null,"Conference room","Conference room",null,null,50,null,null,"Office, conference room"]
[null,null,"Office, conference room","Hallway, stairway",null,null,50,null,null,"Mechanical equipment room"]
[null,null,"Mechanical equipment room","Occupied area",null,null,60,null,null,"Classroom or other core learning space"]
[null,"ANSI S12.60–2010 Part 1 (Table 4)","Classroom or other core learning space","Other enclosed or open-plan core learning space",null,null,50,null,null,"Patient room"]
[null,null,"Classroom or other core learning space","Therapy room",null,null,50,null,null,"NICU room"]
[null,null,"Classroom or other core learning space","Health care room",null,null,50,null,null,"NICU "]
[null,null,"Classroom or other core learning space","Other space requiring a high degree of acoustical privacy",null,null,50,null,null,"Exam room"]
[null,null,"Classroom or other core learning space","Common-use and public-use toilet room",null,null,53,null,null,"Treatment room"]
[null,null,"Classroom or other core learning space","Common-use and public-use bathing room",null,null,53,null,null,"Toilet room"]
[null,null,"Classroom or other core learning space","Corridor",null,null,45,null,null,"Consultation room"]
[null,null,"Classroom or other core learning space","Staircase",null,null,45,null,null,"Public space"]
[null,null,"Classroom or other core learning space","Office",null,null,45]
[null,null,"Classroom or other core learning space","Conference room",null,null,45]
[null,null,"Classroom or other core learning space","Music room",null,null,60]
[null,null,"Classroom or other core learning space","Music performance space",null,null,60]
[null,null,"Classroom or other core learning space","Auditorium",null,null,60]
[null,null,"Classroom or other core learning space","Mechanical equipment room",null,null,60]
[null,null,"Classroom or other core learning space","Cafeteria",null,null,60]
[null,null,"Classroom or other core learning space","Gymnasium",null,null,60]
[null,null,"Classroom or other core learning space","Indoor swimming pool",null,null,60]
[null,"2010 FGI Guidelines (Table 1.2-3)","Patient room","Patient room (wall - same floor)",null,null,45]
[null,null,"Patient room","Patient room (floor-to-floor)",null,null,50]
[null,null,"Patient room","Corridor (with entrance)",null,null,35]
[null,null,"Patient room","Public space",null,null,50]
[null,null,"Patient room","Service area",null,null,60]
[null,null,"Patient room","MRI room",null,null,60]
[null,null,"NICU room","Patient room",null,null,50]
[null,null,"NICU ","Corridor",null,null,50]
[null,null,"Exam room","Corridor (with entrance)",null,null,35]
[null,null,"Exam room","Public space",null,null,50]
[null,null,"Exam room","MRI room",null,null,60]
[null,null,"Exam room","Exam room (no electronic masking)",null,null,50]
[null,null,"Exam room","Exam room (with electronic masking)",null,null,40]
[null,null,"Treatment room","Room",null,null,50]
[null,null,"Treatment room","Corridor",null,null,35]
[null,null,"Toilet room","Public space",null,null,45]
[null,null,"Consultation room","Public space",null,null,50]
[null,null,"Consultation room","Patient room",null,null,50]
[null,null,"Consultation room","Corridor (with entrance)",null,null,35]
[null,null,"Public space","MRI room",null,null,50]
[]
[null,"Reverberation Time"]
[null,null,"Room and Application Type","T60 (sec)"]
[null,"Rating System (Table 2)","Apartment and condominium",0.6]
[null,null,"Hotel/motel - individual room or suite",0.6]
[null,null,"Hotel/motel - meeting or banquet room",0.8]
[null,null,"Office building - executive or private office",0.6]
[null,null,"Office building - conference room",0.6]
[null,null,"Office building - teleconference room",0.6]
[null,null,"Office building - open-plan office without sound masking",0.8]
[null,null,"Office building - open-plan office with sound masking",0.8]
[null,null,"Courtroom - unamplified speech",0.7]
[null,null,"Courtroom - amplified speech",1]
[null,null,"Performing arts space - drama theaters, concert and recital halls","(specify)"]
[null,null,"Laboratories - testing or research with minimal speech communication",1]
[null,null,"Laboratories - extensive phone use and speech communication",0.6]
[null,null,"Church, mosque, synagogue - general assembly with critical music program","(specify)"]
[null,null,"Library",1]
[null,null,"Indoor stadium, gymnasium - gymnasium and natatorium",2]
[null,null,"Indoor stadium, gymnasium - large-capacity space with speech amplification",1.5]
[null,null,"Classroom",0.6]
[null,null,"For Schools: Classroom and other core learning space","(specify)"]
[]
[null,"Speech Privacy"]
[null,null,"Enclosed or Open","Speech Privacy Goal",null,"Design Criteria","Threshold",null,null,"Enclosed","Open"]
[null,"2010 FGI Guidelines (Table 1.2-4)","Enclosed","Normal",null,"PI",">",85,null,"Normal","Normal (non-intrusive)"]
[null,null,"Enclosed","Normal",null,"AI","<",0.15,null,"Confidential","Confidential"]
[null,null,"Enclosed","Normal",null,"STI","<",0.19,null,"Secure"]
[null,null,"Enclosed","Normal",null,"SII","<",0.2]
[null,null,"Enclosed","Confidential",null,"PI",">",95]
[null,null,"Enclosed","Confidential",null,"AI","<",0.05]
[null,null,"Enclosed","Confidential",null,"STI","<",0.12]
[null,null,"Enclosed","Confidential",null,"SII","<",0.1]
[null,null,"Enclosed","Secure",null,"n/a",null,0]
[null,null,"Open","Normal (non-intrusive)",null,"PI",">",80]
[null,null,"Open","Normal (non-intrusive)",null,"AI","<",0.2]
[null,null,"Open","Normal (non-intrusive)",null,"STI","<",0.23]
[null,null,"Open","Normal (non-intrusive)",null,"SII","<",0.25]
[null,null,"Open","Confidential",null,"n/a",null,0]
[]
[null," Acoustical Finishes"]
[null,null,"Space Type","Design Coefficient"]
[null,"2010 FGI Guidelines \n(Table 1.2-1)","Private patient room",0.15]
[null,null,"Multi-bed patient room",0.15]
[null,null,"Corridor",0.15]
[null,null,"Waiting area room",0.25]
[null,null,"Atrium",0.1]
[null,null,"Physician's office",0.15]
[null,null,"Treatment room",0.15]

{"sheet":"Background Noise","index":2,"n_rows":20,"n_cols":14,"rows_kept":20,"cut":false,"hidden":false,"merged":[[5,4,5,7],[5,9,5,13],[4,1,4,13],[18,2,18,12],[19,2,19,12],[18,1,19,1],[5,1,6,1],[5,2,6,2],[17,2,17,6]]}
[]
[null,"Background Noise"]
[]
[]
[null,"For New Construction, Data Centers, Warehouses and Distribution Centers, and Hospitality projects:  Complete the table to demonstrate that the background noise requirements will be met in all occupied spaces. Include background noise from all HVAC systems.  Include all acoustically critical spaces/room types or worst case combinations of room assemblies and noise sources.\n\nFor Schools projects: Complete the table to demonstrate that the background noise requirements will be met in all classrooms and other core learning spaces.  Include background noise from all HVAC systems.  Include all acoustically critical spaces/room types or worst case combinations of room assemblies and noise sources.\n\nFor Healthcare projects:  Complete the table to demonstrate that the background noise requirements will be met in all occupied spaces. Include background noise from all building mechanical-electrical-plumbing systems, air distribution systems and other noise sources under the purview of the project team.   Include all acoustically critical spaces/room types or worst case combinations of room assemblies and noise sources."]
[null,"Space ID","Space Type",null,"For all except Schools projects",null,null,null,null,"For Schools projects"]
[null,null,null,null,"Sound Rating Method","Maximum Allowed Background Noise Level","Background Noise Level","Background Noise Compliance",null,"Prerequisite\nMaximum Allowed Background Noise Level \n(dBA)","Credit\nMaximum Allowed Background Noise Level \n(dBA)","Background Noise Level (dBA)","Background Noise Level\nPrerequisite Compliance","Background Noise Level Credit Compliance"]
[{"$f":"IF(B8>=0,0,1)","v":0},null,null,null,null,{"$f":"IFERROR(VLOOKUP(C8,Assumptions!$C$7:$G$51, MATCH(E8, Assumptions!$C$7:$G$7, 0), FALSE),0)","v":0},null,{"$f":"IF(G8=\"\",\"N/A\",IF(F8>=G8,\"Yes\",\"No\"))","v":"N/A"},null,{"$f":"IF(A8>0,40,40)","v":40},{"$f":"IF(A8>0,35,35)","v":35},null,{"$f":"IF(L8=\"\",\"N/A\",IF(J8>=L8,\"Yes\",\"No\"))","v":"N/A"},{"$f":"IF(L8=\"\",\"N/A\",IF(K8>=L8,\"Yes\",\"No\"))","v":"N/A"}]
[{"$f":"IF(B9>=0,0,1)","v":0},null,null,null,null,{"$f":"IFERROR(VLOOKUP(C9,Assumptions!$C$7:$G$51, MATCH(E9, Assumptions!$C$7:$G$7, 0), FALSE),0)","v":0},null,"N/A",null,40,35,null,"N/A","N/A"]
[{"$f":"IF(B10>=0,0,1)","v":0},null,null,null,null,{"$f":"IFERROR(VLOOKUP(C10,Assumptions!$C$7:$G$51, MATCH(E10, Assumptions!$C$7:$G$7, 0), FALSE),0)","v":0},null,"N/A",null,40,35,null,"N/A","N/A"]
[0,null,null,null,null,{"$f":"IFERROR(VLOOKUP(C11,Assumptions!$C$7:$G$51, MATCH(E11, Assumptions!$C$7:$G$7, 0), FALSE),0)","v":0},null,"N/A",null,40,35,null,"N/A","N/A"]
[0,null,null,null,null,{"$f":"IFERROR(VLOOKUP(C12,Assumptions!$C$7:$G$51, MATCH(E12, Assumptions!$C$7:$G$7, 0), FALSE),0)","v":0},null,"N/A",null,40,35,null,"N/A","N/A"]
[0,null,null,null,null,{"$f":"IFERROR(VLOOKUP(C13,Assumptions!$C$7:$G$51, MATCH(E13, Assumptions!$C$7:$G$7, 0), FALSE),0)","v":0},null,"N/A",null,40,35,null,"N/A","N/A"]
[0,null,null,null,null,{"$f":"IFERROR(VLOOKUP(C14,Assumptions!$C$7:$G$51, MATCH(E14, Assumptions!$C$7:$G$7, 0), FALSE),0)","v":0},null,"N/A",null,40,35,null,"N/A","N/A"]
[0,null,null,null,null,{"$f":"IFERROR(VLOOKUP(C15,Assumptions!$C$7:$G$51, MATCH(E15, Assumptions!$C$7:$G$7, 0), FALSE),0)","v":0},null,"N/A",null,40,35,null,"N/A","N/A"]
[null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(C16,Assumptions!$C$7:$G$51, MATCH(E16, Assumptions!$C$7:$G$7, 0), FALSE),0)","v":0},null,"N/A",null,40,35,null,"N/A","N/A"]
[null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(C17,Assumptions!$C$7:$G$51, MATCH(E17, Assumptions!$C$7:$G$7, 0), FALSE),0)","v":0},null,"N/A",null,40,35,null,"N/A","N/A"]
["A","For all except Schools projects","The background noise levels in all spaces do not exceed the maximum background noise level",null,null,null,null,{"$f":"IF(COUNTIF(H8:H17,\"No\"),\"No\",IF(COUNTIF(H8:H17,\"Yes\"),\"Yes\",\"N/A\"))","v":"N/A"}]
[null,"For Schools \nprojects","Prerequisite: The background noise levels in all spaces do not exceed 40 dBA",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNTIF(M8:M17,\"No\"),\"No\",IF(COUNTIF(M8:M17,\"Yes\"),\"Yes\",\"N/A\"))","v":"N/A"}]
[null,null,"Credit: The background noise levels in all spaces do not exceed 35 dBA ",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNTIF(N8:N17,\"No\"),\"No\",IF(COUNTIF(N8:N17,\"Yes\"),\"Yes\",\"N/A\"))","v":"N/A"}]

{"sheet":"Sound Transmission (Isolation)","index":3,"n_rows":17,"n_cols":10,"rows_kept":17,"cut":false,"hidden":false,"merged":[[16,1,16,8],[4,1,4,9]]}
[]
[null,"Sound Transmission (Isolation)"]
[]
[]
[null,"For all except Schools projects:  Complete the table to demonstrate that the sound transmission requirements will be met in all occupied spaces.  Include all acoustically critical spaces/room types or worst case combinations of room assemblies. \n\nFor Schools projects: Complete the table to demonstrate that the sound transmission requirements will be met in all classrooms and other core learning spaces.  Include all acoustically critical spaces/room types or worst case combinations of room assemblies. \n"]
[null,"Room ID","Assembly ID","Assembly \nDescription","Assembly \nLocation","Space Type","Adjacent \nSpace Type","Minimum Required \nSTC Rating","STC \nRating","Sound Transmission Compliance"]
[{"$f":"IF(B7>=0,0,1)","v":0},null,null,null,null,null,null,{"$f":"IFERROR(LOOKUP(2,1/((Assumptions!$C$55:$C$100='Sound Transmission (Isolation)'!F7)*(Assumptions!$D$55:$F$100='Sound Transmission (Isolation)'!G7)),Assumptions!$G$55:$G$100),0)","v":0},null,{"$f":"IF(ISBLANK(F7),\"N/A\",IF(AND($I7<>\"\",$I7>=H7),\"Yes\",\"No\"))","v":"N/A"}]
[{"$f":"IF(B8>=0,0,1)","v":0},null,null,null,null,null,null,{"$f":"IFERROR(LOOKUP(2,1/((Assumptions!$C$55:$C$100='Sound Transmission (Isolation)'!F8)*(Assumptions!$D$55:$F$100='Sound Transmission (Isolation)'!G8)),Assumptions!$G$55:$G$100),0)","v":0},null,{"$f":"IF(ISBLANK(F8),\"N/A\",IF(AND($I8<>\"\",$I8>=H8),\"Yes\",\"No\"))","v":"N/A"}]
[{"$f":"IF(B9>=0,0,1)","v":0},null,null,null,null,null,null,{"$f":"IFERROR(LOOKUP(2,1/((Assumptions!$C$55:$C$100='Sound Transmission (Isolation)'!F9)*(Assumptions!$D$55:$F$100='Sound Transmission (Isolation)'!G9)),Assumptions!$G$55:$G$100),0)","v":0},null,{"$f":"IF(ISBLANK(F9),\"N/A\",IF(AND($I9<>\"\",$I9>=H9),\"Yes\",\"No\"))","v":"N/A"}]
[0,null,null,null,null,null,null,{"$f":"IFERROR(LOOKUP(2,1/((Assumptions!$C$55:$C$100='Sound Transmission (Isolation)'!F10)*(Assumptions!$D$55:$F$100='Sound Transmission (Isolation)'!G10)),Assumptions!$G$55:$G$100),0)","v":0},null,"N/A"]
[0,null,null,null,null,null,null,{"$f":"IFERROR(LOOKUP(2,1/((Assumptions!$C$55:$C$100='Sound Transmission (Isolation)'!F11)*(Assumptions!$D$55:$F$100='Sound Transmission (Isolation)'!G11)),Assumptions!$G$55:$G$100),0)","v":0},null,"N/A"]
[0,null,null,null,null,null,null,{"$f":"IFERROR(LOOKUP(2,1/((Assumptions!$C$55:$C$100='Sound Transmission (Isolation)'!F12)*(Assumptions!$D$55:$F$100='Sound Transmission (Isolation)'!G12)),Assumptions!$G$55:$G$100),0)","v":0},null,"N/A"]
[0,null,null,null,null,null,null,{"$f":"IFERROR(LOOKUP(2,1/((Assumptions!$C$55:$C$100='Sound Transmission (Isolation)'!F13)*(Assumptions!$D$55:$F$100='Sound Transmission (Isolation)'!G13)),Assumptions!$G$55:$G$100),0)","v":0},null,"N/A"]
[0,null,null,null,null,null,null,{"$f":"IFERROR(LOOKUP(2,1/((Assumptions!$C$55:$C$100='Sound Transmission (Isolation)'!F14)*(Assumptions!$D$55:$F$100='Sound Transmission (Isolation)'!G14)),Assumptions!$G$55:$G$100),0)","v":0},null,"N/A"]
[null,null,null,null,null,null,null,{"$f":"IFERROR(LOOKUP(2,1/((Assumptions!$C$55:$C$100='Sound Transmission (Isolation)'!F15)*(Assumptions!$D$55:$F$100='Sound Transmission (Isolation)'!G15)),Assumptions!$G$55:$G$100),0)","v":0},null,{"$f":"IF(ISBLANK(F15),\"N/A\",IF(AND($I15<>\"\",$I15>=H15),\"Yes\",\"No\"))","v":"N/A"}]
[null,null,null,null,null,null,null,{"$f":"IFERROR(LOOKUP(2,1/((Assumptions!$C$55:$C$100='Sound Transmission (Isolation)'!F16)*(Assumptions!$D$55:$F$100='Sound Transmission (Isolation)'!G16)),Assumptions!$G$55:$G$100),0)","v":0},null,{"$f":"IF(ISBLANK(F16),\"N/A\",IF(AND($I16<>\"\",$I16>=H16),\"Yes\",\"No\"))","v":"N/A"}]
["A","The sound transmission requirements are met for each space",null,null,null,null,null,null,null,{"$f":"IF(COUNTIF(J7:J16,\"No\"),\"No\",IF(COUNTIF(J7:J16,\"Yes\"),\"Yes\",\"N/A\"))","v":"N/A"}]

{"sheet":"Reverberation Time","index":4,"n_rows":24,"n_cols":19,"rows_kept":24,"cut":false,"hidden":false,"merged":[[20,14,20,15],[21,14,21,15],[22,14,22,15],[6,16,6,18],[7,16,7,18],[19,14,19,17],[6,14,6,15],[7,14,7,15],[6,8,6,9],[6,10,6,12],[7,8,7,9],[7,10,7,12],[19,8,19,11],[4,1,4,6],[6,4,7,6],[6,1,8,1],[6,2,8,2],[6,3,8,3],[20,8,20,9],[21,8,21,9],[22,8,22,9],[23,1,23,6],[19,1,19,6],[20,1,20,6],[21,1,21,6],[22,1,22,6]]}
[]
[null,"Reverberation Time"]
[]
[]
[null,"Complete the table with calculations or measurements for all acoustically critical spaces/room types or worst case combinations of room assemblies. Rooms may be grouped into a single room type if their floor assemblies, ceiling assemblies, wall assemblies and adjacent spaces are identical.  For each space, all surface materials and their associated surface area must be listed."]
[null,null,null,null,null,null,null,null,0,null,null,null,null,null,0]
[null,"Material ID","Description of Material","Manufacturer or Vendor Name","Sound Absorption Coefficient",null,null,null,"Space ID",null,null,null,null,null,"Space ID"]
[null,null,null,null,null,null,null,null,"Space and Application Type",null,null,null,null,null,"Space and Application Type"]
[null,null,null,null,"500 Hz","1000 Hz","2000 Hz",null,{"$f":"IF(Instructions!$I$50=1,\"Surface Area \n(sq ft)\",\"Surface Area \n(sq m)\")","v":"Surface Area \n(sq ft)"},"Material \nLocation","Equivalent \nSound Absorption \nat 500 Hz","Equivalent \nSound Absorption \nat 1000 Hz","Equivalent \nSound Absorption \nat 2000 Hz",null,{"$f":"IF(Instructions!$I$50=1,\"Surface Area \n(sq ft)\",\"Surface Area \n(sq m)\")","v":"Surface Area \n(sq ft)"},"Material \nLocation","Equivalent \nSound Absorption \nat 500 Hz","Equivalent \nSound Absorption \nat 1000 Hz","Equivalent \nSound Absorption \nat 2000 Hz"]
[{"$f":"IF(B10>=0,0,1)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"$E10*I10","v":0},{"$f":"$F10*I10","v":0},{"$f":"$G10*I10","v":0},null,null,null,{"$f":"$E10*O10","v":0},{"$f":"$F10*O10","v":0},{"$f":"$G10*O10","v":0}]
[0,null,null,null,null,null,null,null,null,null,0,0,0,null,null,null,0,0,0]
[0,null,null,null,null,null,null,null,null,null,0,0,0,null,null,null,0,0,0]
[0,null,null,null,null,null,null,null,null,null,0,0,0,null,null,null,0,0,0]
[0,null,null,null,null,null,null,null,null,null,0,0,0,null,null,null,0,0,0]
[0,null,null,null,null,null,null,null,null,null,0,0,0,null,null,null,0,0,0]
[0,null,null,null,null,null,null,null,null,null,0,0,0,null,null,null,0,0,0]
[0,null,null,null,null,null,null,null,null,null,0,0,0,null,null,null,0,0,0]
[null,null,null,null,null,null,null,null,null,null,0,0,0,null,null,null,0,0,0]
[null,null,null,null,null,null,null,null,null,null,0,0,0,null,null,null,0,0,0]
["A",{"$f":"IF(Instructions!I50=1,\"Room volume (cubic feet)\",\"Room volume (cubic meters)\")","v":"Room volume (cubic feet)"}]
[null,"Total sound absorbing units (sabins) ",null,null,null,null,null,null,null,null,{"$f":"SUM(K10:K19)","v":0},{"$f":"SUM(L10:L19)","v":0},{"$f":"SUM(M10:M19)","v":0},null,null,null,{"$f":"SUM(Q10:Q19)","v":0},{"$f":"SUM(R10:R19)","v":0},{"$f":"SUM(S10:S19)","v":0}]
[null,"Reverberation time requirement (s)",null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(K$8,Assumptions!$C$104:$D$122,2,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(K$8,Assumptions!$C$104:$D$122,2,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(K$8,Assumptions!$C$104:$D$122,2,FALSE),0)","v":0},null,null,null,{"$f":"IFERROR(VLOOKUP(Q$8,Assumptions!$C$104:$D$122,2,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(Q$8,Assumptions!$C$104:$D$122,2,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(Q$8,Assumptions!$C$104:$D$122,2,FALSE),0)","v":0}]
[null,"Reverberation time (s)",null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(Instructions!$I$50=1,0.049*M20/K21,0.161*M20/K21),0)","v":0},{"$f":"IFERROR(IF(Instructions!$I$50=1,0.049*M20/L21,0.161*M20/L21),0)","v":0},{"$f":"IFERROR(IF(Instructions!$I$50=1,0.049*M20/M21,0.161*M20/M21),0)","v":0},null,null,null,{"$f":"IFERROR(IF(Instructions!$I$50=1,0.049*S20/Q21,0.161*S20/Q21),0)","v":0},{"$f":"IFERROR(IF(Instructions!$I$50=1,0.049*S20/R21,0.161*S20/R21),0)","v":0},{"$f":"IFERROR(IF(Instructions!$I$50=1,0.049*S20/S21,0.161*S20/S21),0)","v":0}]
[null,"The reverberation time was not exceeded",null,null,null,null,null,null,0,null,null,null,{"$f":"IF(M20>0,IF(AND(K23<=K22,L23<=L22,M23<=M22,K22<>\"\",L22<>\"\",M22<>\"\"),\"Yes\",\"No\"),\"N/A\")","v":"N/A"},null,0,null,null,null,{"$f":"IF(S20>0,IF(AND(Q23<=Q22,R23<=R22,S23<=S22,Q22<>\"\",R22<>\"\",S22<>\"\"),\"Yes\",\"No\"),\"N/A\")","v":"N/A"}]

{"sheet":"Noise Reduction Coefficient","index":5,"n_rows":22,"n_cols":14,"rows_kept":22,"cut":false,"hidden":false,"merged":[[19,1,19,4],[20,1,20,4],[21,1,21,4],[5,1,5,4],[7,1,8,1],[7,2,8,2],[7,3,8,3],[7,4,8,4]]}
[]
[null,"Noise Reduction Coefficient"]
[null,"For Schools projects only"]
[]
[]
[null,"Complete the table. Rooms may be grouped into a single core learning space/model if their construction is identical. Only the materials that demonstrate compliance with the requirements must be listed."]
[null,null,null,null,null,null,0,null,null,0,null,null,0]
[null,"Material ID","Description of Material","Manufacturer or Vendor Name","NRC ",null,"Space ID",null,null,"Space ID",null,null,"Space ID"]
[null,null,null,null,null,null,{"$f":"IF(Instructions!$I$50=1,\"Area of \nMaterial \n(sq ft)\",\"Area of \nMaterial \n(sq m)\")","v":"Area of \nMaterial \n(sq ft)"},"NRC Compliance",null,{"$f":"IF(Instructions!$I$50=1,\"Area of \nMaterial \n(sq ft)\",\"Area of \nMaterial \n(sq m)\")","v":"Area of \nMaterial \n(sq ft)"},"NRC Compliance",null,{"$f":"IF(Instructions!$I$50=1,\"Area of \nMaterial \n(sq ft)\",\"Area of \nMaterial \n(sq m)\")","v":"Area of \nMaterial \n(sq ft)"},"NRC Compliance"]
[{"$f":"IF(B10>=0,0,1)","v":0},null,null,null,null,null,null,{"$f":"IF(G10<>\"\",IF($E10>=0.7,\"Yes\",\"No\"),\"N/A\")","v":"N/A"},null,null,{"$f":"IF(J10<>\"\",IF($E10>=0.7,\"Yes\",\"No\"),\"N/A\")","v":"N/A"},null,null,{"$f":"IF(M10<>\"\",IF($E10>=0.7,\"Yes\",\"No\"),\"N/A\")","v":"N/A"}]
[0,null,null,null,null,null,null,{"$f":"IF(G11<>\"\",IF($E11>=0.7,\"Yes\",\"No\"),\"N/A\")","v":"N/A"},null,null,{"$f":"IF(J11<>\"\",IF($E11>=0.7,\"Yes\",\"No\"),\"N/A\")","v":"N/A"},null,null,{"$f":"IF(M11<>\"\",IF($E11>=0.7,\"Yes\",\"No\"),\"N/A\")","v":"N/A"}]
[0,null,null,null,null,null,null,"N/A",null,null,"N/A",null,null,"N/A"]
[0,null,null,null,null,null,null,"N/A",null,null,"N/A",null,null,"N/A"]
[0,null,null,null,null,null,null,"N/A",null,null,"N/A",null,null,"N/A"]
[0,null,null,null,null,null,null,"N/A",null,null,"N/A",null,null,"N/A"]
[0,null,null,null,null,null,null,"N/A",null,null,"N/A",null,null,"N/A"]
[0,null,null,null,null,null,null,"N/A",null,null,"N/A",null,null,"N/A"]
[null,null,null,null,null,null,null,"N/A",null,null,"N/A",null,null,"N/A"]
[null,null,null,null,null,null,null,"N/A",null,null,"N/A",null,null,"N/A"]
["A",{"$f":"IF(Instructions!$I$50=1,\"Total ceiling area, excluding lights, diffusers, and grilles (sq ft)\",\"Total ceiling area, excluding lights, diffusers, and grilles (sq m)\")","v":"Total ceiling area, excluding lights, diffusers, and grilles (sq ft)"}]
[null,{"$f":"IF(Instructions!$I$50=1,\"Area of qualifying material with NRC of 0.70 or higher (sq ft)\",\"Area of qualifying material with NRC of 0.70 or higher (sq m)\")","v":"Area of qualifying material with NRC of 0.70 or higher (sq ft)"},null,null,null,null,null,{"$f":"SUMIF(H10:H19,\"Yes\",G10:G19)","v":0},null,null,{"$f":"SUMIF(K10:K19,\"Yes\",J10:J19)","v":0},null,null,{"$f":"SUMIF(N10:N19,\"Yes\",M10:M19)","v":0}]
[null,"The sound absorptive materials requirement is met for each space",null,null,null,null,null,{"$f":"IF(H21>0,IF(AND(H21>=H20,H20<>\"\"),\"Yes\",\"No\"),\"N/A\")","v":"N/A"},null,null,{"$f":"IF(K21>0,IF(AND(K21>=K20,K20<>\"\"),\"Yes\",\"No\"),\"N/A\")","v":"N/A"},null,null,{"$f":"IF(N21>0,IF(AND(N21>=N20,N20<>\"\"),\"Yes\",\"No\"),\"N/A\")","v":"N/A"}]

{"sheet":"Speech Privacy","index":6,"n_rows":19,"n_cols":10,"rows_kept":19,"cut":false,"hidden":false,"merged":[[19,1,19,5],[19,7,19,8],[5,1,5,9],[6,9,7,9],[18,1,18,8],[6,3,7,3],[6,5,7,5],[6,4,7,4],[6,1,7,1],[6,2,7,2],[6,8,7,8],[6,6,7,7]]}
[]
[null,"Speech Privacy "]
[null,"For Healthcare projects only"]
[]
[]
[null,"Complete the table with either calculations or measurements for all acoustically critical spaces/room types or worst case combinations of room assemblies and noise sources."]
[null,"Space \nName or ID","Space Type","Enclosed or \nOpen-plan","Speech Privacy \nGoal","Design \nCriteria","Minimum or \nMaximum \nAccepted \nValue",null,"Speech \nPrivacy \nValue","Speech \nPrivacy Compliance"]
[]
[{"$f":"IF(B9>=0,0,1)","v":0},null,null,null,null,null,{"$f":"IF(F9<>\"\",IF(H9=0,\"\",IF(F9=\"PI\",\">\",\"<\")),\"\")","v":""},{"$f":"IF(OR(ISBLANK(F9),ISBLANK(E9)),\"\",SUMIFS(Assumptions!$H$126:$H$139,Assumptions!$C$126:$C$139,D9,Assumptions!$D$126:$D$139,E9,Assumptions!$F$126:$F$139,F9))","v":""},null,{"$f":"IF(I9<>\"\",IF(F9=\"PI\",IF(I9>=H9,\"Yes\",\"No\"),IF(I9<=H9,\"Yes\",\"No\")),\"N/A\")","v":"N/A"}]
[0,null,null,null,null,null,"",{"$f":"IF(OR(ISBLANK(F10),ISBLANK(E10)),\"\",SUMIFS(Assumptions!$H$126:$H$139,Assumptions!$C$126:$C$139,D10,Assumptions!$D$126:$D$139,E10,Assumptions!$F$126:$F$139,F10))","v":""},null,"N/A"]
[0,null,null,null,null,null,"",{"$f":"IF(OR(ISBLANK(F11),ISBLANK(E11)),\"\",SUMIFS(Assumptions!$H$126:$H$139,Assumptions!$C$126:$C$139,D11,Assumptions!$D$126:$D$139,E11,Assumptions!$F$126:$F$139,F11))","v":""},null,"N/A"]
[0,null,null,null,null,null,"",{"$f":"IF(OR(ISBLANK(F12),ISBLANK(E12)),\"\",SUMIFS(Assumptions!$H$126:$H$139,Assumptions!$C$126:$C$139,D12,Assumptions!$D$126:$D$139,E12,Assumptions!$F$126:$F$139,F12))","v":""},null,"N/A"]
[0,null,null,null,null,null,"",{"$f":"IF(OR(ISBLANK(F13),ISBLANK(E13)),\"\",SUMIFS(Assumptions!$H$126:$H$139,Assumptions!$C$126:$C$139,D13,Assumptions!$D$126:$D$139,E13,Assumptions!$F$126:$F$139,F13))","v":""},null,"N/A"]
[0,null,null,null,null,null,"",{"$f":"IF(OR(ISBLANK(F14),ISBLANK(E14)),\"\",SUMIFS(Assumptions!$H$126:$H$139,Assumptions!$C$126:$C$139,D14,Assumptions!$D$126:$D$139,E14,Assumptions!$F$126:$F$139,F14))","v":""},null,"N/A"]
[0,null,null,null,null,null,"",{"$f":"IF(OR(ISBLANK(F15),ISBLANK(E15)),\"\",SUMIFS(Assumptions!$H$126:$H$139,Assumptions!$C$126:$C$139,D15,Assumptions!$D$126:$D$139,E15,Assumptions!$F$126:$F$139,F15))","v":""},null,"N/A"]
[0,null,null,null,null,null,"",{"$f":"IF(OR(ISBLANK(F16),ISBLANK(E16)),\"\",SUMIFS(Assumptions!$H$126:$H$139,Assumptions!$C$126:$C$139,D16,Assumptions!$D$126:$D$139,E16,Assumptions!$F$126:$F$139,F16))","v":""},null,"N/A"]
[null,null,null,null,null,null,"",{"$f":"IF(OR(ISBLANK(F17),ISBLANK(E17)),\"\",SUMIFS(Assumptions!$H$126:$H$139,Assumptions!$C$126:$C$139,D17,Assumptions!$D$126:$D$139,E17,Assumptions!$F$126:$F$139,F17))","v":""},null,"N/A"]
[null,null,null,null,null,null,"",{"$f":"IF(OR(ISBLANK(F18),ISBLANK(E18)),\"\",SUMIFS(Assumptions!$H$126:$H$139,Assumptions!$C$126:$C$139,D18,Assumptions!$D$126:$D$139,E18,Assumptions!$F$126:$F$139,F18))","v":""},null,"N/A"]
["A","Speech privacy criteria has been met for all spaces",null,null,null,null,null,null,null,{"$f":"IF(COUNTIF(J9:J18,\"Yes\"),IF(COUNTIF(J9:J18,\"No\"),\"No\",\"Yes\"),\"N/A\")","v":"N/A"}]

{"sheet":"Acoustical Finishes","index":7,"n_rows":24,"n_cols":14,"rows_kept":24,"cut":false,"hidden":false,"merged":[[7,15,8,15],[5,1,5,4],[23,1,23,4],[22,1,22,4],[21,1,21,4],[7,1,9,1],[7,2,9,2],[7,3,9,3],[7,4,9,4],[20,1,20,4]]}
[]
[null,"Acoustical Finishes"]
[null,"For Healthcare projects only"]
[]
[]
[null,"Complete the table for all acoustically critical spaces/room types or worst case combinations of room assemblies. Rooms may be grouped into a single room type if their floor assemblies, ceiling assemblies, and wall assemblies are identical.  "]
[null,null,null,null,null,null,0,null,null,0,null,null,0]
[null,"Material or \nSurface ID","Description of \nMaterial or Surface","Manufacturer or \nVendor Name\n(for materials only)","NRC \n(α)",null,"Room ID",null,null,"Room ID",null,null,"Room ID"]
[null,null,null,null,null,null,"Room Type",null,null,"Room Type",null,null,"Room Type"]
[null,null,null,null,null,null,{"$f":"CONCATENATE(\"Surface Area \n\",IF(Instructions!$I$50=1,\"(sq ft)\",\"(sq m)\"))","v":"Surface Area \n(sq ft)"},"Sα",null,{"$f":"CONCATENATE(\"Surface Area \n\",IF(Instructions!$I$50=1,\"(sq ft)\",\"(sq m)\"))","v":"Surface Area \n(sq ft)"},"Sα",null,{"$f":"CONCATENATE(\"Surface Area \n\",IF(Instructions!$I$50=1,\"(sq ft)\",\"(sq m)\"))","v":"Surface Area \n(sq ft)"},"Sα"]
[{"$f":"IF(B11>=0,0,1)","v":0},null,null,null,null,null,null,{"$f":"IF(G11>0,G11*$E11,\"\")","v":""},null,null,{"$f":"IF(J11>0,J11*$E11,\"\")","v":""},null,null,{"$f":"IF(M11>0,M11*$E11,\"\")","v":""}]
[0,null,null,null,null,null,null,{"$f":"IF(G12>0,G12*$E12,\"\")","v":""},null,null,{"$f":"IF(J12>0,J12*$E12,\"\")","v":""},null,null,{"$f":"IF(M12>0,M12*$E12,\"\")","v":""}]
[0,null,null,null,null,null,null,"",null,null,"",null,null,""]
[0,null,null,null,null,null,null,"",null,null,"",null,null,""]
[0,null,null,null,null,null,null,"",null,null,"",null,null,""]
[0,null,null,null,null,null,null,"",null,null,"",null,null,""]
[0,null,null,null,null,null,null,"",null,null,"",null,null,""]
[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,null,null,null,null,"",null,null,"",null,null,""]
["A",{"$f":"CONCATENATE(\"Total room surface area \",IF(Instructions!$I$50=1,\"(sq ft)\",\"(sq m)\"))","v":"Total room surface area (sq ft)"},null,null,null,null,null,{"$f":"SUM(G11:G20)","v":0},null,null,{"$f":"SUM(J11:J20)","v":0},null,null,{"$f":"SUM(M11:M20)","v":0}]
[null,"Recommended design room sound absorption coefficient (αdesign)",null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(H$9,Assumptions!$C$143:$D$149,2,FALSE),\"\")","v":""},null,null,{"$f":"IFERROR(VLOOKUP(K$9,Assumptions!$C$143:$D$149,2,FALSE),\"\")","v":""},null,null,{"$f":"IFERROR(VLOOKUP(N$9,Assumptions!$C$143:$D$149,2,FALSE),\"\")","v":""}]
[null,"Average sound absorption coefficient (αaverage)",null,null,null,null,null,{"$f":"IFERROR(SUM(H11:H20)/H21,0)","v":0},null,null,{"$f":"IFERROR(SUM(K11:K20)/K21,0)","v":0},null,null,{"$f":"IFERROR(SUM(N11:N20)/N21,0)","v":0}]
[null,"Acoustical finishes criteria have been met for each space",null,null,null,null,null,{"$f":"IF(H21>0,IF(H23>=H22,\"Yes\",\"No\"),\"N/A\")","v":"N/A"},null,null,{"$f":"IF(K21>0,IF(K23>=K22,\"Yes\",\"No\"),\"N/A\")","v":"N/A"},null,null,{"$f":"IF(N21>0,IF(N23>=N22,\"Yes\",\"No\"),\"N/A\")","v":"N/A"}]

{"sheet":"Summary D+C","index":8,"n_rows":16,"n_cols":8,"rows_kept":16,"cut":false,"hidden":false,"merged":[[2,2,2,7],[7,2,7,5]]}
[]
[]
[null,null,"Summary"]
[null,null,"Note: All information on this tab is READ-ONLY. To edit, see the previous tabs."]
[]
[null,null,"Background Noise"]
[]
[null,null,"The background noise levels in all spaces do not exceed the maximum background noise level",null,null,null,null,{"$f":"'Background Noise'!H18","v":"N/A"}]
[]
[null,null,"Sound Transmission"]
[]
[null,null,"The sound transmission requirements are met for each space",null,null,null,null,{"$f":"IF(COUNTIF('Sound Transmission (Isolation)'!17:17,\"No\"),\"No\",IF(COUNTIF('Sound Transmission (Isolation)'!17:17,\"Yes\"),\"Yes\",\"N/A\"))","v":"N/A"}]
[]
[null,null,"Reverberation Time"]
[]
[null,null,"The reverberation time for each space was not exceeded",null,null,null,null,{"$f":"IF(COUNTIF('Reverberation Time'!24:24,\"No\"),\"No\",IF(COUNTIF('Reverberation Time'!24:24,\"Yes\"),\"Yes\",\"N/A\"))","v":"N/A"}]

{"sheet":"Summary SCH","index":9,"n_rows":35,"n_cols":8,"rows_kept":35,"cut":false,"hidden":false,"merged":[[34,2,34,5],[30,2,30,5],[10,2,10,5],[16,2,17,5],[19,2,19,5]]}
[]
[]
[null,null,"Summary for Schools"]
[null,null,"Note: All information on this tab is READ-ONLY. To edit, see the previous tabs."]
[]
[]
[null,null,"EQ Prerequisite Minimum Acoustic Performance"]
[]
[null,null,"HVAC Background Noise"]
[]
[null,null,"The background noise levels in all spaces do not exceed 40 dBA",null,null,null,null,{"$f":"'Background Noise'!N19","v":"N/A"}]
[]
[null,null,"Reverberation Time"]
[]
[null,null,"For classrooms and core learning spaces less than 20,000 cu ft (566 cu m)"]
[]
[null,null,"Option 1. The sound absorptive materials requirement is met for each space (Noise Reduction Coefficient tab)",null,null,null,null,{"$f":"IF(COUNTIF('Noise Reduction Coefficient'!1:1,\"No\"),\"No\",IF(COUNTIF('Noise Reduction Coefficient'!1:1,\"Yes\"),\"Yes\",\"N/A\"))","v":"N/A"}]
[]
[]
[null,null,"Option 2. The reverberation time for each space was not exceeded (Reverberation Time tab)",null,null,null,null,{"$f":"IF(COUNTIF('Reverberation Time'!4:4,\"No\"),\"No\",IF(COUNTIF('Reverberation Time'!4:4,\"Yes\"),\"Yes\",\"N/A\"))","v":"N/A"}]
[]
[null,null,"For classrooms and core learning spaces greater than or equal to 20,000 cu ft (566 cu m)"]
[]
[null,null,"The reverberation time for each space was not exceeded (Reverberation Time tab)",null,null,null,null,{"$f":"IF(COUNTIF('Reverberation Time'!4:4,\"No\"),\"No\",IF(COUNTIF('Reverberation Time'!4:4,\"yes\"),\"Yes\",\"N/A\"))","v":"N/A"}]
[]
[]
[null,null,"EQ Credit Acoustic Performance"]
[]
[null,null,"HVAC Background Noise"]
[]
[null,null,"The background noise levels in all spaces do not exceed 35 dBA ",null,null,null,null,{"$f":"'Background Noise'!N20","v":"N/A"}]
[]
[null,null,"Sound Transmission"]
[]
[null,null,"The sound transmission requirements are met for each space",null,null,null,null,{"$f":"IF(COUNTIF('Sound Transmission (Isolation)'!17:17,\"No\"),\"No\",IF(COUNTIF('Sound Transmission (Isolation)'!17:17,\"Yes\"),\"Yes\",\"N/A\"))","v":"N/A"}]

{"sheet":"Summary HC","index":10,"n_rows":24,"n_cols":8,"rows_kept":24,"cut":false,"hidden":false,"merged":[[17,2,17,5]]}
[]
[]
[null,null,"Summary for Healthcare"]
[null,null,"Note: All information on this tab is READ-ONLY. To edit, see the previous tabs."]
[]
[null,null,"Option 1. Speech Privacy, Sound Isolation, and Background Noise"]
[]
[null,null,"Speech Privacy"]
[]
[null,null,"Speech privacy criteria has been met for each space",null,null,null,null,{"$f":"'Speech Privacy'!J19","v":"N/A"}]
[]
[null,null,"Sound Isolation"]
[]
[null,null,"The sound transmission requirements are met for each space",null,null,null,null,{"$f":"'Sound Transmission (Isolation)'!J17","v":"N/A"}]
[]
[null,null,"Background Noise"]
[]
[null,null,"The background noise levels in all spaces do not exceed the maximum background noise level",null,null,null,null,{"$f":"'Background Noise'!H18","v":"N/A"}]
[]
[null,null,"Option 2. Acoustical Finishes and Site Exterior Noise"]
[]
[null,null,"Acoustical Finishes "]
[]
[null,null,"Acoustical finishes criteria have been met for each space",null,null,null,null,{"$f":"IF(COUNTIF('Acoustical Finishes'!24:24,\"No\"),\"No\",IF(COUNTIF('Acoustical Finishes'!24:24,\"Yes\"),\"Yes\",\"N/A\"))","v":"N/A"}]