CT - Returns the CT Required for Inactivation of Giardia Cysts for a given Disinfectant, Log Inactivation, Temperature, pH, and Disinfectant Residual from the EPA lookup tables.
CT(InactivationOf, Disinfectant, LogInactivation, Temp, pH, Cl2)
InactivationOf –Giardia or Viruses. Set to string "Giardia" or "Viruses". Note you can use 1 for Giardia or 2 for Viruses.
Disinfectant – Sets the disinfectant used. Can be set by string (i.e. “Free Chlorine”) or by number (i.e. 1)
1 – Free Chlorine
2 - Chlorine Dioxide
3 – Chloramine
4 – Ozone
Log Inactivation - .5, 1, 1.5, 2, 2.5,3, or 4 (4 only applies to inactivation of Viruses)
Temperature – Water Temperature in Deg C
pH – pH of the water (only required for Inactivation of Giardia by Free Chlorine)
Cl2 – Chlorine Residual at end of disinfection segment in mg/L. Only used for Inactivation of Giardia by Free Chlorine, for all other lookups use -1 to indicate not used.
=CT("GIARDIA",1,2,15,7.5,1) returns 60 from EPA CT Table C-4.
=CT(1,2,3,15,7.5,-1) returns 19 from EPA Table C-8. CT Required for 3 Log Inactivation of Giardia (1) by Chlorine Dioxide (2) at 15 Deg C with a pH between 6 and 9 (7.5).
SEE ALSO: CTR3LGC, CT Tables, Calculating CT in WIMS