UV sterilizer dose calculator.xlsx

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X
1	UV Dose Calculator using the Keitz equation: Irradiance (E) = P/(2LDπ²)*(2α+Sin2α). This table will give the UVc dose at the midpoint between the quartz tube and the reactor wall. Note that the UVc emmited by the lamp is not the same as its standard power consumption rating, you need to look up the lamp specifications to find this.
2	System Info				Input parameters									Formulae								Output
3	System description		UV model	Lamp model	UVc output of lamp (watts)	Lamp arc length (cm)	Inner diameter of chamber wall (cm)	Outer diameter of quartz tube (cm)	Water volume of unit (litres) as measured directly	Number of units	Total volume of units (litres)	Flow rate (litres per minute)	OptionalMax system volume (litres)	UV contact time (seconds)	Distance from quartz tube to chamber wall (cm)	Arc length of lamp (meters) (L)	Midpoint between quartz tube and chamber wall) (meters) (D)	UVc power (watts) (P)	ArcTan L/2D (α)	Dose (Watts/m²) (E)	Dose µWatt/cm²	Total dose (µJ/cm²) new lamp	Total dose (µJ/cm²) end of lamp life (1 year, 85% UV power)	System turnover rate per hour
4	Blue system killifish C3	Current system flow	TMC Vecton Titan 850	G25T8	6.9	40	4.6	3	0.3	1	0.3	16	300	1.125	0.8	0.4	0.019	6.9	1.476080581	144.4439198	14444.39198	16249.9	13812.4	3.2
5			TMC commercial P1 55	G55T8	18	84	5.65	3	1.25	1	1.25	33.3	1800	2.252252252	1.325	0.84	0.021625	18	1.519353658	157.7001675	15770.01675	35518.1	30190.3	1.1
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
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