IACA: Ventilation Rate Scratch Pad

	A	B	C	D	E	F	G	H	I
1	Indoor Air Care Advocates - Ventilation Units Scratch Pad
2
3	This spreadsheet was created to accompany the blog at iaqadvocates.org/post/clearing-up-conversion-confusion
4	Below is a scratch pad/calculator for various units used to quantify ventilation rates.
5
6	To use this spreadsheet, click File ▶ Make a Copy or File ▶ Download and then adjust values as needed.
7
8	For any given unit of airflow, adjust the value to see equivalent values in other units for the hypothetical room dimensions and occupancy.
9
10	See the slide titled Equations for information on how these quantities have been converted.
11	See the slide titled Survey of Ventilation Recommendations for detailed information on the recommendations used as default values here.
12
13	Hypothetical Room Dimensions and Occupancy
14
15	Adjust hypothetical room dimensions and occupancy as needed to meet your scenario.
16	Occupants here are assumed to be one adult teacher and N-1 students under 12 years of age.
17	Initial values are the average of anecdotal minimum and maximum dimensions/occupants reported by parents and facilities managers.
18
19	Room size [sqft]:	700			Occupants:	25
20	Ceilings [ft]:	10.5
21	V [cu ft] (calculated):	7350
22
23	Constants
24
25	Outdoor CO2	415	ppm	May vary locally; reference: https://gml.noaa.gov/ccgg/trends/
26	R[CO2] <12yo	0.0066	cfm	Reference: https://schools.forhealth.org/wp-content/uploads/sites/19/2021/09/Harvard-Healthy-Buildings-program.How-to-assess-classroom-ventilation.11-17-2020.pdf
27	R[CO2] teacher	0.013	cfm	Reference: https://schools.forhealth.org/wp-content/uploads/sites/19/2021/09/Harvard-Healthy-Buildings-program.How-to-assess-classroom-ventilation.11-17-2020.pdf
28
29	Scratch Pad
30
31		Average of the 6-12 ACH recommended by ASHRAE-ACGIH, AIHA, CDPH, etc.
32		⬇		Lancet; Joseph Allen
33		⬇		⬇		World Health Organization
34		⬇		⬇		⬇		CDC, UK SAGE
35		⬇		⬇		⬇		⬇
36	Set values in this row ➡	9	ACH	30	cfm/person	10	L/s/person	800	ppm CO2
37	Requisite Outdoor Airflow	1103	cfm	750	cfm	530	cfm	445	cfm
38	Calculated ACH	-		6.1	ACH	4.3	ACH	3.6	ACH
39	Calculated cfm/person	44	cfm/person	-		21	cfm/person	18	cfm/person
40	Calculated L/s/person	21	L/s/person	14	L/s/person	-		8.4	L/s/person
41	Calculated ppm CO2	570	ppm CO2	644	ppm CO2	739	ppm CO2	-
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100