{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Introduction","6.2 Core Documentation Req.","5.3 Specific Documentation","5.4 Specific Documentation"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":0,"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":"Introduction","index":0,"n_rows":36,"n_cols":5,"rows_kept":36,"cut":false,"hidden":false,"merged":[[29,1,30,1],[6,2,6,4],[11,2,11,4],[14,2,14,4],[17,2,17,4],[29,2,30,2],[29,3,30,3],[29,4,30,4],[20,2,21,4],[22,2,22,4]]}
[]
[]
[]
[null,null,"INTRODUCTION"]
[]
[]
[null,null,"This tool facilitates compliance with ASHRAE Standard 55 Section 6.2, ensuring buildings are used as intended by their representative occupants. The tool documents design conditions for mechanically ventilated (Section 5.3) and naturally ventilated (Section 5.4) spaces. "]
[]
[null,null,"The tool is divided into the following tabs:"]
[]
[null,null,"1. 6.2 Core Documentation Requirements "]
[null,null,"This tab focuses on the core requirements that are applicable to both mechanically and naturally ventilated spaces. Here the user will be able to define the compliance method used for each space. For occupant-controlled naturally conditioned spaces, select Section 5.4 methodolgy. Otherwise, proceed with Section 5.3 methodology. Use the Add/Remove Rows buttons to document all required design comfort conditions."]
[]
[null,null,"2. 5.3 Specific Documentation"]
[null,null,"Adhere to the instructions provided in each column to accurately complete the required information."]
[]
[null,null,"3. 5.4 Specific Documentation "]
[null,null,"This applies only to spaces that are naturally conditioned. Adhere to the instructions provided in each column to accurately complete the required information."]
[]
[null,null,"NOTE:"]
[null,null,"If any reasonably predictable representative occupants are excluded from compliance, they shall be identified along with the rationale for their exclusion in the table below. This includes exclusion of representative occupants whose clothing and/or metabolic rate fall outside the applicable bounds of the standard as well as transitory or temporary occupants."]
[]
[null,null,"Similarly any spaces that are excluded because they are unoccupied shall be listed in the table below."]
[]
[]
[]
[]
[null,"EXCLUDED SPACES AND OCCUPANTS"]
[]
[null,null,"Enclosed Space ","Excluded Representative Occupant","Design Comfort Condition "]
[]
[null,null,"Description of the enclosed space\n\nDescribe Enclosed spaces which shall be excluded from full compliance or Spaces which have representative occupants which shall be exclued. ","Detailed Description of the Representative Occupant","Describe the rationale for their exclusion. This includes exclusion of representative occupants whose clothing and/or metabolic rate fall outside the applicable bounds of the standard as well as transitory or temporary occupants."]
[null,"EG 1","Telephone Closet","NA","Not considered occupied "]
[null,"EG 2 ","Gymnasium ","Person Working Out ","Met rate above 1.6 "]
[null,1]
[null,2]

{"sheet":"6.2 Core Documentation Req.","index":1,"n_rows":11,"n_cols":37,"rows_kept":11,"cut":false,"hidden":false,"merged":[[4,10,4,32],[4,33,4,34],[4,35,5,36],[5,6,5,7],[5,8,5,9],[5,12,5,19],[5,20,5,32],[5,33,5,34],[3,1,3,2],[3,6,3,9],[3,10,3,32],[3,33,3,34],[3,35,3,36],[4,1,5,2],[4,3,5,3],[4,4,5,4],[4,6,4,7],[4,8,4,9]]}
[]
[null,"ASHRAE SSPC 55  2023 COMPLIANCE DOCUMENTATION TEMPLATE FOR THERMAL COMFORT ",null,null,null,null,null,null,null,null,"IP units"]
[]
[]
[null,"Space",null,"Representative Occupant and their Location ","Design Comfort Condition","Method of Design Compliance","Clothing Insulation",null,"Metabolic Rate",null,"Direct-Beam Solar Radiation",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Thermal Environmental Control ",null,"Compliance"]
[null,null,null,null,null,"Mechanicaly ventilated or Occupant-controlled naturally conditioned spaces","clo rate",null,"met rate",null,"Does the Occupant Experience Direct Beam Solar Radiation?","Method of Compliance","Prescriptive\nProvide documentation to satisfy conditions for using a mean radiant temperature that is 2.8°C (5°F) higher than average air temperature \n",null,null,null,null,null,null,null,"Performance\nCalculate and document per Section 5.3.3",null,null,null,null,null,null,null,null,null,null,null,null,"Document environmental controls for the occupant"]
[null,"Unique Identifier","Description of the space or location","Detailed Description and location within the Space of the Representative Occupant","Describe the Design Comfort Conditions Assessed such as heating, cooling or other including natural ventiation modes, high solar gains, event timings","Per Section 5.3 or Section 5.4 ","Per Section 5.2.1.2 \nInclude any tolerance or expected range(s)","Notes ","Per Section 5.2.2.2 \nInclude any tolerance or expected range(s)","Notes ","(YES or NO)","(PRESCTIPTIVE or PERFORMANCE)","Air temperature stratification  meets the requirements of Section 5.3.5.3.","Space does not have active radiant surfaces.","Building envelope opaque surfaces of the space meet U-factor prescriptive requirement of ASHRAE/IES Standard 90.12","Outdoor air temperature is less than  110°F (43°C).","Vertical fenestration has less than 9 ft (3 m) of total height","No skylights are present","The space complies with all requirements in a single row of Table 5-6, 5-7, 5-8, or 5-9","Enter Mean Radiant Temperature (Only Use If All Conditions Are Met)","Posture","Air temperature","Solar altitude above horizon (0 - 90°) [β]","Solar horizontal angle relative to front of person [SHARP]","Direct beam (normal) solar radiation [Idir]","Total solar transmittance [Tsol]","Sky vault view fraction [fsvv]","Fraction of body exposed to sun [fbes]","Average shortwave absorptivity [α]","ERF ","Long-wave mean radiant temperature [trlw] ","Short-wave mean radiant temperature [trsw] ","Mean radiant temperature [tr] ","Classification Level as per table 6.1","Documentation/ Calculations","Does the space meet the standard?","Note times/conditions that the standard is not met "]
[null,"EG1","Office","Office Desk Worker Sitting in a West facing Window Seat in a west facing office in direct sunlight with mechnanical cooling running  ","Mech cooling ",5.3,"x clo-y clo\n\n(or)\n\nx +/- y clo",null,"x MET-y MET\n\n(or)\n\nx +/- y ME",null,"YES","PERFORMANCE",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,null,"YES"]
[null,"EG2","Office","Office Desk Worker Siting in the Window Seat in a west facing office during natural ventilation mode ","Natural Ventilation",5.4,"x clo-y clo\n\n(or)\n\nx +/- y clo",null,"x MET-y MET\n\n(or)\n\nx +/- y ME",null,"NO","PERFORMANCE",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,null,"YES"]
[null,1]
[null,2]

{"sheet":"5.3 Specific Documentation","index":2,"n_rows":11,"n_cols":26,"rows_kept":11,"cut":false,"hidden":false,"merged":[[4,10,4,11],[4,12,4,19],[4,20,4,25],[6,6,6,7],[6,8,6,9],[6,10,6,11],[5,12,5,13],[5,14,5,15],[5,16,5,17],[5,18,5,19],[5,20,5,21],[5,22,5,25],[3,1,3,2],[3,6,3,7],[3,8,3,11],[3,12,3,19],[3,20,3,25],[4,1,5,2],[4,3,5,3],[4,4,5,4],[4,6,4,7],[4,8,4,9]]}
[]
[null," 5.3 Mechanically Conditioned Spaces",null,null,"IP units"]
[]
[]
[null,"Space",null,"Representative Occupant and their Location ","Design Comfort Condition","Method of Design Compliance","Design Operative Temperature",null,"Design Humidity (RH)",null,"Average Air Speed",null,"Local Thermal Discomfort",null,null,null,null,null,null,null,"Elevated Air Speed Adjustment"]
[null,null,null,null,null,"Mechanicaly ventilated or Occupant-controlled naturally conditioned spaces","Cooling (°F)","Heating (°F)","Cooling (%)","Heating (%)","Cooling (fpm)","Heating (fpm)","Radiant Temperature Asymmetry",null,"Vertical Air Temperature Difference",null,"Floor Surface Temperature",null,"Draft",null,"Are there any limits to air speed inputs in the elevated air speed comfort zone?",null,"Documentation \n(Avg air speed limits as per Section 5.3.2)"]
[null,"Unique Identifier","Description of the space or location","Detailed Description and location within the Space of the Representative Occupant","Describe the Design Comfort Conditions Assessed such as heating, cooling or other including natural ventiation modes, high solar gains, event timings","Per Section 5.3 or Section 5.4 ","Include any tolerance or expected range(s)",null,"Include any tolerance or expected range(s)",null,"Include any tolerance or expected range(s)",null,"Not Likely","Calculation Performed / Explanation","Not Likely","Calculation Performed / Explanation","Not Likely","Calculation Performed / Explanation","Not Likely","Calculation Performed / Explanation"," Representative occupants' clothing insulation greater than 0.7 clo\n(OR)\nRepresentative occupants' metabolic rate is greater than 1.3 met","Is there occupant control over the air speed as defined in 5.3.1?","Method","Equipment","Air Speed","Zones of Influence"]
[null,{"$f":"IF('6.2 Core Documentation Req.'!B8=0,\"\",'6.2 Core Documentation Req.'!B8)","v":"EG1"},{"$f":"IF('6.2 Core Documentation Req.'!C8=0,\"\",'6.2 Core Documentation Req.'!C8)","v":"Office"},{"$f":"IF('6.2 Core Documentation Req.'!D8=0,\"\",'6.2 Core Documentation Req.'!D8)","v":"Office Desk Worker Sitting in a West facing Window Seat in a west facing office in direct sunlight with mechnanical cooling running  "},{"$f":"IF('6.2 Core Documentation Req.'!E8=0,\"\",'6.2 Core Documentation Req.'!E8)","v":"Mech cooling "},{"$f":"IF('6.2 Core Documentation Req.'!F8=0,\"\",'6.2 Core Documentation Req.'!F8)","v":5.3},"x°F-y°F\n(or)\nx +/- y°F \n(or)\nNA","x°F-y°F\n(or)\nx +/- y°F \n(or)\nNA","x%-y%\n(or)\nx +/- y%\n(or)\nNA","x%-y%\n(or)\nx +/- y%\n(or)\nNA","x fpm-y fpm\n(or)\nx +/- y fpm\n(or)\nNA","x fpm-y fpm\n(or)\nx +/- y fpm\n(or)\nNA",null,null,null,null,null,null,null,null,"NO","NO"]
[null,{"$f":"IF('6.2 Core Documentation Req.'!B9=0,\"\",'6.2 Core Documentation Req.'!B9)","v":"EG2"},{"$f":"IF('6.2 Core Documentation Req.'!C9=0,\"\",'6.2 Core Documentation Req.'!C9)","v":"Office"},{"$f":"IF('6.2 Core Documentation Req.'!D9=0,\"\",'6.2 Core Documentation Req.'!D9)","v":"Office Desk Worker Siting in the Window Seat in a west facing office during natural ventilation mode "},{"$f":"IF('6.2 Core Documentation Req.'!E9=0,\"\",'6.2 Core Documentation Req.'!E9)","v":"Natural Ventilation"},{"$f":"IF('6.2 Core Documentation Req.'!F9=0,\"\",'6.2 Core Documentation Req.'!F9)","v":5.4},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NO","NO"]
[null,{"$f":"IF('6.2 Core Documentation Req.'!B10=0,\"\",'6.2 Core Documentation Req.'!B10)","v":1},{"$f":"IF('6.2 Core Documentation Req.'!C10=0,\"\",'6.2 Core Documentation Req.'!C10)","v":""},{"$f":"IF('6.2 Core Documentation Req.'!D10=0,\"\",'6.2 Core Documentation Req.'!D10)","v":""},{"$f":"IF('6.2 Core Documentation Req.'!E10=0,\"\",'6.2 Core Documentation Req.'!E10)","v":""},{"$f":"IF('6.2 Core Documentation Req.'!F10=0,\"\",'6.2 Core Documentation Req.'!F10)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NO","NO"]
[null,{"$f":"IF('6.2 Core Documentation Req.'!B11=0,\"\",'6.2 Core Documentation Req.'!B11)","v":2},{"$f":"IF('6.2 Core Documentation Req.'!C11=0,\"\",'6.2 Core Documentation Req.'!C11)","v":""},{"$f":"IF('6.2 Core Documentation Req.'!D11=0,\"\",'6.2 Core Documentation Req.'!D11)","v":""},{"$f":"IF('6.2 Core Documentation Req.'!E11=0,\"\",'6.2 Core Documentation Req.'!E11)","v":""},{"$f":"IF('6.2 Core Documentation Req.'!F11=0,\"\",'6.2 Core Documentation Req.'!F11)","v":""}]

{"sheet":"5.4 Specific Documentation","index":3,"n_rows":11,"n_cols":34,"rows_kept":11,"cut":false,"hidden":false,"merged":[[3,10,3,33],[4,1,5,2],[4,3,5,3],[4,4,5,4],[4,6,4,33],[5,28,5,33],[5,6,5,9],[5,10,5,15],[5,16,5,21],[5,22,5,27]]}
[]
[null,"5.4 NATURALLY VENTILATED SPACES",null,null,"IP units"]
[]
[null,null,null,null,null,null,"(c), (d), (e)",null,null,null,"(a), (b), (f), (g)"]
[null,"Space",null,"Representative Occupant and their Location ","Design Comfort Condition","Method of Design Compliance","Naturally Conditioned Spaces"]
[null,null,null,null,null,"Mechanicaly ventilated or Occupant-controlled naturally conditioned spaces","Verify Criteria",null,null,null,"Time Period 1",null,null,null,null,null,"Time Period 2",null,null,null,null,null,"Time Period 3",null,null,null,null,null,"Time Period 4"]
[null,"Unique Identifier","Description of the space or location","Detailed Description and location within the Space of the Representative Occupant","Describe the Design Comfort Conditions Assessed such as heating, cooling or other including natural ventiation modes, high solar gains, event timings","Per Section 5.3 or Section 5.4 ","There is no mechanical heating/cooling system","Occupants have METs ranging from 1.0 to 1.5 met","Occupants can adapt their clothing by at least 0.5 to 1.0 clo","The prevailing mean outdoor temperature > 50°F & < 92.3°F","Compliance time period(s) for Section 5.4 applicability","Predicted Operative Temperature ","Prevailing mean outdoor design temperature for each compliance time period."," Upper 80% acceptability limit (°F) \n(From Section 5.4.2.2. or Fig 5.8)","Lower 80% acceptability limit (°F) \n(From Section 5.4.2.2. or Fig 5.8)","Increased air speed adjustment to upper operative temp limit based on table 5-13","Compliance time period(s) for Section 5.4 applicability","Predicted Operative Temperature ","Prevailing mean outdoor design temperature for each compliance time period."," Upper 80% acceptability limit (°F) \n(From Section 5.4.2.2. or Fig 5.8)","Lower 80% acceptability limit (°F) \n(From Section 5.4.2.2. or Fig 5.8)","Increased air speed adjustment to upper operative temp limit based on table 5-13","Compliance time period(s) for Section 5.4 applicability","Predicted Operative Temperature ","Prevailing mean outdoor design temperature for each compliance time period."," Upper 80% acceptability limit (°F) \n(From Section 5.4.2.2. or Fig 5.8)","Lower 80% acceptability limit (°F) \n(From Section 5.4.2.2. or Fig 5.8)","Increased air speed adjustment to upper operative temp limit based on table 5-13","Compliance time period(s) for Section 5.4 applicability","Predicted Operative Temperature ","Prevailing mean outdoor design temperature for each compliance time period."," Upper 80% acceptability limit (°F) \n(From Section 5.4.2.2. or Fig 5.8)","Lower 80% acceptability limit (°F) \n(From Section 5.4.2.2. or Fig 5.8)","Increased air speed adjustment to upper operative temp limit based on table 5-13"]
[null,{"$f":"IF('6.2 Core Documentation Req.'!B8=0,\"\",'6.2 Core Documentation Req.'!B8)","v":"EG1"},{"$f":"IF('6.2 Core Documentation Req.'!C8=0,\"\",'6.2 Core Documentation Req.'!C8)","v":"Office"},{"$f":"IF('6.2 Core Documentation Req.'!D8=0,\"\",'6.2 Core Documentation Req.'!D8)","v":"Office Desk Worker Sitting in a West facing Window Seat in a west facing office in direct sunlight with mechnanical cooling running  "},{"$f":"IF('6.2 Core Documentation Req.'!E8=0,\"\",'6.2 Core Documentation Req.'!E8)","v":"Mech cooling "},{"$f":"IF('6.2 Core Documentation Req.'!F8=0,\"\",'6.2 Core Documentation Req.'!F8)","v":5.3},null,null,null,null,"Define time period here",null,55,{"$f":"IF(M8=0,\"\",(0.31*M8)+60.5)","v":77.55},{"$f":"IF(M8=0,\"\",(0.31*M8)+47.9)","v":64.95},null,"Define time period here",null,65,{"$f":"IF(S8=0,\"\",(0.31*S8)+60.5)","v":80.650000000000006},{"$f":"IF(S8=0,\"\",(0.31*S8)+47.9)","v":68.05},null,"Define time period here",null,null,{"$f":"IF(Y8=0,\"\",(0.31*Y8)+60.5)","v":""},{"$f":"IF(Y8=0,\"\",(0.31*Y8)+47.9)","v":""},null,"Define time period here",null,null,{"$f":"IF(AE8=0,\"\",(0.31*AE8)+60.5)","v":""},{"$f":"IF(AE8=0,\"\",(0.31*AE8)+47.9)","v":""}]
[null,{"$f":"IF('6.2 Core Documentation Req.'!B9=0,\"\",'6.2 Core Documentation Req.'!B9)","v":"EG2"},{"$f":"IF('6.2 Core Documentation Req.'!C9=0,\"\",'6.2 Core Documentation Req.'!C9)","v":"Office"},{"$f":"IF('6.2 Core Documentation Req.'!D9=0,\"\",'6.2 Core Documentation Req.'!D9)","v":"Office Desk Worker Siting in the Window Seat in a west facing office during natural ventilation mode "},{"$f":"IF('6.2 Core Documentation Req.'!E9=0,\"\",'6.2 Core Documentation Req.'!E9)","v":"Natural Ventilation"},{"$f":"IF('6.2 Core Documentation Req.'!F9=0,\"\",'6.2 Core Documentation Req.'!F9)","v":5.4},null,null,null,null,"Define time period here",null,80,{"$f":"IF(M9=0,\"\",(0.31*M9)+60.5)","v":85.3},{"$f":"IF(M9=0,\"\",(0.31*M9)+47.9)","v":72.7},null,"Define time period here",null,75,{"$f":"IF(S9=0,\"\",(0.31*S9)+60.5)","v":83.75},{"$f":"IF(S9=0,\"\",(0.31*S9)+47.9)","v":71.150000000000006},null,"Define time period here",null,null,{"$f":"IF(Y9=0,\"\",(0.31*Y9)+60.5)","v":""},{"$f":"IF(Y9=0,\"\",(0.31*Y9)+47.9)","v":""},null,"Define time period here",null,null,{"$f":"IF(AE9=0,\"\",(0.31*AE9)+60.5)","v":""},{"$f":"IF(AE9=0,\"\",(0.31*AE9)+47.9)","v":""}]
[null,{"$f":"IF('6.2 Core Documentation Req.'!B10=0,\"\",'6.2 Core Documentation Req.'!B10)","v":1},{"$f":"IF('6.2 Core Documentation Req.'!C10=0,\"\",'6.2 Core Documentation Req.'!C10)","v":""},{"$f":"IF('6.2 Core Documentation Req.'!D10=0,\"\",'6.2 Core Documentation Req.'!D10)","v":""},{"$f":"IF('6.2 Core Documentation Req.'!E10=0,\"\",'6.2 Core Documentation Req.'!E10)","v":""},{"$f":"IF('6.2 Core Documentation Req.'!F10=0,\"\",'6.2 Core Documentation Req.'!F10)","v":""},null,null,null,null,null,null,null,{"$f":"IF(M10=0,\"\",(0.31*M10)+60.5)","v":""},{"$f":"IF(M10=0,\"\",(0.31*M10)+47.9)","v":""},null,null,null,null,{"$f":"IF(S10=0,\"\",(0.31*S10)+60.5)","v":""},{"$f":"IF(S10=0,\"\",(0.31*S10)+47.9)","v":""},null,null,null,null,{"$f":"IF(Y10=0,\"\",(0.31*Y10)+60.5)","v":""},{"$f":"IF(Y10=0,\"\",(0.31*Y10)+47.9)","v":""},null,null,null,null,{"$f":"IF(AE10=0,\"\",(0.31*AE10)+60.5)","v":""},{"$f":"IF(AE10=0,\"\",(0.31*AE10)+47.9)","v":""}]
[null,{"$f":"IF('6.2 Core Documentation Req.'!B11=0,\"\",'6.2 Core Documentation Req.'!B11)","v":2},{"$f":"IF('6.2 Core Documentation Req.'!C11=0,\"\",'6.2 Core Documentation Req.'!C11)","v":""},{"$f":"IF('6.2 Core Documentation Req.'!D11=0,\"\",'6.2 Core Documentation Req.'!D11)","v":""},{"$f":"IF('6.2 Core Documentation Req.'!E11=0,\"\",'6.2 Core Documentation Req.'!E11)","v":""},{"$f":"IF('6.2 Core Documentation Req.'!F11=0,\"\",'6.2 Core Documentation Req.'!F11)","v":""},null,null,null,null,null,null,null,{"$f":"IF(M11=0,\"\",(0.31*M11)+60.5)","v":""},{"$f":"IF(M11=0,\"\",(0.31*M11)+47.9)","v":""},null,null,null,null,{"$f":"IF(S11=0,\"\",(0.31*S11)+60.5)","v":""},{"$f":"IF(S11=0,\"\",(0.31*S11)+47.9)","v":""},null,null,null,null,{"$f":"IF(Y11=0,\"\",(0.31*Y11)+60.5)","v":""},{"$f":"IF(Y11=0,\"\",(0.31*Y11)+47.9)","v":""},null,null,null,null,{"$f":"IF(AE11=0,\"\",(0.31*AE11)+60.5)","v":""},{"$f":"IF(AE11=0,\"\",(0.31*AE11)+47.9)","v":""}]