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.

SYNTAX:

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. 

EXAMPLES

=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

VIDEOS: https://youtu.be/NK0019Br0-E