Spreadsheet: 115068d1310701194-if_true-false-cicihk_if_truefalse
Sheet: NOV pivot

 |  |  |  |  |  | E. Coli | TBC | LD | Total | Fail  Rate | E. Coli | TBC | LD | E. Coli | TBC | LD | TOTAL Extra Cost
 |  |  |  |  | No. of Pass
 |  |  |  |  | No. of Fail |  |  |  |  |  | 100 | 130 | 395
 |  |  |  |  | No. of Testing
Site | ALS | Multiple Work Orders | E. coli | [NAME] | Heterotrophic Plate Count (35°C) | Heterotrophic Plate Count (35°C)2 | Total Legionella Count | Total Legionella Count2 | Technician
113 ARYGLE STREET CT | HK1026746 | 2010-11-10 00:00:00 |  |  | 8 | Pass |  |  | Fai
APB CENTRE - CT | HK1026513 | 2010-11-08 00:00:00 |  |  | 140000 | Fail |  |  | Yiu
 | HK1027510 | 2010-11-17 00:00:00 |  |  | 22 | Pass |  |  | Yiu
CABOT CT-A | HK1026253 | 2010-11-05 00:00:00 |  |  |  |  | <10 | Pass | [NAME]
CABOT CT-B | HK1026254 | 2010-11-05 00:00:00 |  |  |  |  | <10 | Pass | [NAME]
CABOT CT-C | HK1026255 | 2010-11-05 00:00:00 |  |  |  |  | <10 | Pass | [NAME]
CABOT CT-D | HK1026256 | 2010-11-05 00:00:00 |  |  |  |  | <10 | Pass | [NAME]
CABOT CT-E | HK1026257 | 2010-11-05 00:00:00 |  |  |  |  | <10 | Pass | [NAME]
CARITAS MEDICAL CENTRE CT- | HK1025705 | 2010-11-01 00:00:00 |  |  | 92000 | Pass |  |  | Shing
 | HK1025706 | 2010-11-01 00:00:00 |  |  |  |  | <10 | Pass | Shing
CHI LIN CT | HK1026310 | 2010-11-05 00:00:00 |  |  | 1 | Pass |  |  | Fai
 | HK1026321 | 2010-11-05 00:00:00 |  |  |  |  | <10 | Pass | Fai
CHI LIN CT - BLEED OFF | HK1026317 | 2010-11-05 00:00:00 | <1 | Pass |  |  |  |  | Fai
CHUNG ON CT | HK1026141 | 2010-11-04 00:00:00 |  |  | 3600 | Pass |  |  | [NAME]
CREDIT SUISSE APAC DATA CENTRE | HK1028444 | 2010-11-30 00:00:00 |  |  |  |  |  |  | [NAME]
CROWNE PLAZA CT | HK1026126 | 2010-11-03 00:00:00 |  |  | 16000 | Pass |  |  | Shing
CUSTOM HQ - BLEED OFF | HK1027516 | 2010-11-15 00:00:00 | <1 | Pass |  |  |  |  | Yiu
CUSTOM HQ - CT | HK1026514 | 2010-11-09 00:00:00 |  |  | 3 | Pass |  |  | Yiu
 | HK1027519 | 2010-11-15 00:00:00 |  |  |  |  | <10 | Pass | Yiu
CUSTOM HQ-CT | HK1027509 | 2010-11-15 00:00:00 |  |  | 4 | Pass |  |  | Yiu
EAST POINT CENTRE CT | HK1026657 | 2010-11-09 00:00:00 |  |  | 5 | Pass |  |  | Shing
 | HK1026674 | 2010-11-09 00:00:00 |  |  |  |  | <10 | Pass | Shing
EAST POINT CENTRE CT BLEED OFF | HK1026671 | 2010-11-09 00:00:00 | <1 | Pass |  |  |  |  | Shing
EAST POINT OLD WING CT | HK1026670 | 2010-11-09 00:00:00 |  |  | 1 | Pass |  |  | Shing
 | HK1026672 | 2010-11-09 00:00:00 | <1 | Pass |  |  |  |  | Shing
 | HK1026673 | 2010-11-09 00:00:00 |  |  |  |  | <10 | Pass | Shing
EMPIRE THEATRE CT | HK1026744 | 2010-11-10 00:00:00 |  |  | <1 | Pass |  |  | Fai
FU TUNG - CT | HK1026138 | 2010-11-03 00:00:00 |  |  | 6000 | Pass |  |  | Yiu
GLC CT | HK1025914 | 2010-11-01 00:00:00 |  |  | 17 | Pass |  |  | Fai
 | HK1025918 | 2010-11-01 00:00:00 |  |  |  |  | <10 | Pass | Fai
GLC CT - BLEED OFF | HK1025917 | 2010-11-01 00:00:00 | <1 | Pass |  |  |  |  | Fai
GUANG DONG HOTEL CT | HK1025911 | 2010-11-02 00:00:00 |  |  | 4 | Pass |  |  | [NAME]
 | HK1025920 | 2010-11-02 00:00:00 |  |  |  |  | 10 | Fail | [NAME]
HAECO - CT | HK1026316 | 2010-11-05 00:00:00 |  |  | 32000 | Pass |  |  | Yiu
HAECO CT | HK1027629 | 2010-11-19 00:00:00 |  |  | 470000 | Fail |  |  | Yiu
HAECO HANGER 3 - BLEED OFF | HK1027976 | 2010-11-24 00:00:00 | <1 | Pass |  |  |  |  | Yiu
HAECO HANGER 3 - CT | HK1027975 | 2010-11-24 00:00:00 |  |  | 26 | Pass |  |  | Yiu
 | HK1027977 | 2010-11-24 00:00:00 |  |  |  |  | <10 | Pass | Yiu
HARBOUR GRAND HOTEL CT | HK1027514 | 2010-11-17 00:00:00 |  |  | 460 | Pass |  |  | Fai
 | HK1027518 | 2010-11-17 00:00:00 |  |  |  |  | <10 | Pass | Fai
HARBOUR GRAND HOTEL CT - | HK1027515 | 2010-11-17 00:00:00 | <1 | Pass |  |  |  |  | Fai
HARBOURFRONT HORIZON CT | HK1026511 | 2010-11-09 00:00:00 |  |  | 180 | Pass |  |  | [NAME]
HARBOURVIEW HORIZON CT | HK1026512 | 2010-11-09 00:00:00 |  |  | 880 | Pass |  |  | [NAME]
 | HK1026516 | 2010-11-09 00:00:00 | 5 | Fail |  |  |  |  | [NAME]
 | HK1026517 | 2010-11-09 00:00:00 |  |  |  |  | <10 | Pass | [NAME]
HGC CT-A | HK1026135 | 2010-11-03 00:00:00 |  |  | 420000 | Fail |  |  | Shing
 | HK1027511 | 2010-11-17 00:00:00 |  |  | 4 | Pass |  |  | Shing
HGC CT-B | HK1026136 | 2010-11-03 00:00:00 |  |  | 360000 | Fail |  |  | Shing
 | HK1027512 | 2010-11-17 00:00:00 |  |  | 2 | Pass |  |  | Shing
HKJC HQ CT | HK1026134 | 2010-11-03 00:00:00 |  |  | 280000 | Fail |  |  | Shing
 | HK1027610 | 2010-11-18 00:00:00 |  |  | 2 | Pass |  |  | Shing
HSBC WASTE WATER | HK1028387 | 2010-11-26 00:00:00 |  |  |  |  |  |  | Fai
 | HK1028388 | 2010-11-26 00:00:00 |  |  |  |  |  |  | Fai
 | HK1028389 | 2010-11-26 00:00:00 |  |  |  |  |  |  | Fai
ISLAND PLACE - BLEED OFF | HK1025854 | 2010-11-02 00:00:00 | <1 | Pass |  |  |  |  | Yiu
ISLAND PLACE - CT 1 | HK1025846 | 2010-11-02 00:00:00 |  |  | 440000 | Fail |  |  | Yiu
 | HK1025855 | 2010-11-02 00:00:00 |  |  |  |  | <10 | Pass | Yiu
ISLAND PLACE - CT 2 | HK1025849 | 2010-11-02 00:00:00 |  |  | 350 | Pass |  |  | Yiu
 | HK1025857 | 2010-11-02 00:00:00 |  |  |  |  | <10 | Pass | Yiu
ISLAND PLACE - MAKE-UP | HK1025853 | 2010-11-02 00:00:00 |  |  | <1 | Pass |  |  | Yiu
I-TECH TOWER CT | HK1026012 | 2010-11-03 00:00:00 |  |  | 940 | Pass |  |  | [NAME]
J D MALL CT | HK1025704 | 2010-11-01 00:00:00 |  |  | 220000 | Fail |  |  | Shing
 | HK1027017 | 2010-11-15 00:00:00 |  |  | 540 | Pass |  |  | Shing
KING ROAD 625 - BLEED OFF | HK1025865 | 2010-11-02 00:00:00 | <1 | Pass |  |  |  |  | Yiu
KING ROAD 625 - CT | HK1025859 | 2010-11-02 00:00:00 |  |  | 580 | Pass |  |  | Yiu
KING ROAD 625 - MAKE-UP | HK1025863 | 2010-11-02 00:00:00 |  |  | 2 | Pass |  |  | Yiu
KING ROAD 625-CT | HK1025864 | 2010-11-02 00:00:00 |  |  |  |  | <10 | Pass | Yiu
LANDMARK EAST CENTRAL POOL | HK1026315 | 2010-11-05 00:00:00 |  |  | <1 | Pass |  |  | Fai
 | HK1026319 | 2010-11-05 00:00:00 | <1 | Pass |  |  |  |  | Fai
 | HK1026326 | 2010-11-05 00:00:00 |  |  |  |  | <10 | Pass | Fai
LOK FU - CT | HK1025858 | 2010-11-01 00:00:00 |  |  | 32000 | Pass |  |  | Yiu
MEGABOX OFFICE TOWER 1 | HK1026013 | 2010-11-03 00:00:00 |  |  | 1400 | Pass |  |  | [NAME]
 | HK1026018 | 2010-11-03 00:00:00 |  |  |  |  | <10 | Pass | [NAME]
MEGABOX OFFICE TOWER 1 CT | HK1026016 | 2010-11-03 00:00:00 | <1 | Pass |  |  |  |  | [NAME]
MEGABOX SHOPPING MALL CT | HK1026014 | 2010-11-03 00:00:00 |  |  | 1200 | Pass |  |  | [NAME]
 | HK1026017 | 2010-11-03 00:00:00 |  |  |  |  | <10 | Pass | [NAME]
MEGABOX SHOPPING MALL CT BLEED | HK1026015 | 2010-11-03 00:00:00 | <1 | Pass |  |  |  |  | [NAME]
OCEAN PARK CT | HK1026125 | 2010-11-03 00:00:00 |  |  | 140000 | Fail |  |  | Shing
 | HK1027513 | 2010-11-17 00:00:00 |  |  | 1 | Pass |  |  | Shing
OCEAN TERMINAL CT | HK1025912 | 2010-11-02 00:00:00 |  |  | 4 | Pass |  |  | [NAME]
OI TUNG CT | HK1025913 | 2010-11-01 00:00:00 |  |  | 11000 | Pass |  |  | Fai
ORIENTAL PRESS BDG CT-1 | HK1026246 | 2010-11-05 00:00:00 |  |  | 74000 | Pass |  |  | [NAME]
ORIENTAL PRESS BDG CT-2 | HK1026247 | 2010-11-05 00:00:00 |  |  | 11000 | Pass |  |  | [NAME]
ORIENTAL PRESS BDG CT-3 | HK1026248 | 2010-11-05 00:00:00 |  |  | 49000 | Pass |  |  | [NAME]
ORIENTAL PRESS BDG CT-5 | HK1026249 | 2010-11-05 00:00:00 |  |  | 9 | Pass |  |  | [NAME]
ORIENTAL PRESS BDG CTR-1 | HK1026250 | 2010-11-05 00:00:00 |  |  | 26000 | Pass |  |  | [NAME]
ORIENTAL PRESS BDG CTR-2 | HK1026251 | 2010-11-05 00:00:00 |  |  | 18000 | Pass |  |  | [NAME]
ORIENTAL PRESS BDG CTR-3 | HK1026252 | 2010-11-05 00:00:00 |  |  | 20000 | Pass |  |  | [NAME]
SCIENCE PARK CT - BLDG 1&2 | HK1026306 | 2010-11-05 00:00:00 |  |  | 54 | Pass |  |  | Shing
SCIENCE PARK CT - BLDG 10 | HK1026771 | 2010-11-11 00:00:00 |  |  | <1 | Pass |  |  | Shing
SCIENCE PARK CT - BLDG 13 | HK1026772 | 2010-11-11 00:00:00 |  |  | 1 | Pass |  |  | Shing
SCIENCE PARK CT - BLDG 4A | HK1026307 | 2010-11-05 00:00:00 |  |  | 300000 | Fail |  |  | Shing
SCIENCE PARK CT - BLDG 4B | HK1026308 | 2010-11-05 00:00:00 |  |  | 5500 | Pass |  |  | Shing
SCIENCE PARK CT - BLDG 5 | HK1026393 | 2010-11-08 00:00:00 |  |  | 340 | Pass |  |  | Shing
SCIENCE PARK CT - BLDG 7 | HK1026395 | 2010-11-08 00:00:00 |  |  | 6400 | Pass |  |  | Shing
SCIENCE PARK CT - BLDG 8 | HK1026309 | 2010-11-05 00:00:00 |  |  | 1200 | Pass |  |  | Shing
SCIENCE PARK CT-BLDG 10 | HK1025866 | 2010-11-02 00:00:00 |  |  | 260000 | Fail |  |  | Shing
SCIENCE PARK CT-BLDG 13 | HK1025867 | 2010-11-02 00:00:00 |  |  | 100000 | Fail |  |  | Shing
SCIENCE PARK CT-BLDG 4A | HK1027713 | 2010-11-22 00:00:00 |  |  | <1 | Pass |  |  | Shing
SCIENCE PARK CT-BLDG 6 | HK1025869 | 2010-11-02 00:00:00 |  |  | 380 | Pass |  |  | Shing
SCIENCE PARK CT-BLDG 9 | HK1025870 | 2010-11-02 00:00:00 |  |  | 1000 | Pass |  |  | Shing
SHEUNG TAK SHOPPING CENTRE | HK1026318 | 2010-11-05 00:00:00 | <1 | Pass |  |  |  |  | Fai
SHEUNG TAK SHOPPING CENTRE CT | HK1026311 | 2010-11-05 00:00:00 |  |  | 180 | Pass |  |  | Fai
 | HK1026322 | 2010-11-05 00:00:00 |  |  |  |  | <10 | Pass | Fai
TAI PO MEGA MALL CT | HK1026140 | 2010-11-04 00:00:00 |  |  | 3500 | Pass |  |  | [NAME]
 | HK1026154 | 2010-11-04 00:00:00 | <1 | Pass |  |  |  |  | [NAME]
 | HK1026164 | 2010-11-04 00:00:00 |  |  |  |  | <10 | Pass | [NAME]
TIN CHAK SHOPPING CENTRE CT | HK1026745 | 2010-11-09 00:00:00 |  |  | 3 | Pass |  |  | Fai
TRADE & INDUSTRY CT | HK1026743 | 2010-11-10 00:00:00 |  |  | 2 | Pass |  |  | Fai
TSING YI POLICE STATION | HK1026940 | 2010-11-11 00:00:00 |  |  | 240 | Pass |  |  | Yiu
TSING YI POLICE STATION - | HK1026948 | 2010-11-11 00:00:00 | <1 | Pass |  |  |  |  | Yiu
TSING YI POLICE STATION - CT | HK1026952 | 2010-11-11 00:00:00 |  |  |  |  | <10 | Pass | Yiu
TUNG CHUNG LIBRARY - BLEED OFF | HK1026155 | 2010-11-03 00:00:00 | <1 | Pass |  |  |  |  | Yiu
TUNG CHUNG LIBRARY - CT | HK1026137 | 2010-11-03 00:00:00 |  |  | 46 | Pass |  |  | Yiu
 | HK1026156 | 2010-11-03 00:00:00 |  |  |  |  | <10 | Pass | Yiu
TVB - CT | HK1026327 | 2010-11-05 00:00:00 |  |  |  |  | <10 | Pass | Yiu
UCH - CT 1.2 BLEED OFF | HK1026146 | 2010-11-04 00:00:00 | <1 | Pass |  |  |  |  | Yiu
UCH - CT 1-1.2 | HK1026142 | 2010-11-04 00:00:00 |  |  | 1 | Pass |  |  | Yiu
 | HK1026157 | 2010-11-04 00:00:00 |  |  |  |  | <10 | Pass | Yiu
UCH - CT 2-1.2 | HK1026143 | 2010-11-04 00:00:00 |  |  | <1 | Pass |  |  | Yiu
 | HK1026158 | 2010-11-04 00:00:00 |  |  |  |  | <10 | Pass | Yiu
UCH - CT 3.4 BLEED OFF | [NAME] | 2010-11-04 00:00:00 | <1 | Pass |  |  |  |  | Yiu
UCH - CT 3-1.2 | HK1026144 | 2010-11-04 00:00:00 |  |  | <1 | Pass |  |  | Yiu
 | HK1026159 | 2010-11-04 00:00:00 |  |  |  |  | <10 | Pass | Yiu
UCH - CT 4-1.2 | HK1026145 | 2010-11-04 00:00:00 |  |  | <1 | Pass |  |  | Yiu
 | HK1026160 | 2010-11-04 00:00:00 |  |  |  |  | <10 | Pass | Yiu
W SQUARE - BLEED OFF | HK1026945 | 2010-11-12 00:00:00 | <1 | Pass |  |  |  |  | Yiu
W SQUARE - CT | HK1026943 | 2010-11-12 00:00:00 |  |  | 82000000 | Fail |  |  | Yiu
W SQUARE - CT1 | HK1026950 | 2010-11-12 00:00:00 |  |  |  |  | <10 | Pass | Yiu
 | HK1027969 | 2010-11-23 00:00:00 |  |  | <1 | Pass |  |  | Yiu
 | HK1027971 | 2010-11-23 00:00:00 |  |  |  |  | <10 | Pass | Yiu
W SQUARE - CT2.3 | HK1026944 | 2010-11-12 00:00:00 |  |  | 230000 | Fail |  |  | Yiu
 | HK1026951 | 2010-11-12 00:00:00 |  |  |  |  | 10 | Fail | Yiu
 | HK1027970 | 2010-11-23 00:00:00 |  |  | 1 | Pass |  |  | Yiu
 | HK1027974 | 2010-11-23 00:00:00 |  |  |  |  | <10 | Pass | Yiu
[NAME] | HK1026312 | 2010-11-05 00:00:00 |  |  | 10 | Pass |  |  | Fai
 | HK1026324 | 2010-11-05 00:00:00 |  |  |  |  | <10 | Pass | Fai
WACOAL CT2 | HK1026314 | 2010-11-05 00:00:00 |  |  | 2 | Pass |  |  | Fai
 | HK1026325 | 2010-11-05 00:00:00 |  |  |  |  | <10 | Pass | Fai
[NAME] | HK1026942 | 2010-11-12 00:00:00 |  |  | 120 | Pass |  |  | Yiu
 | HK1026947 | 2010-11-12 00:00:00 | <1 | Pass |  |  |  |  | Yiu
WILSON HOUSE CT - BLEED OFF | HK1026372 | 2010-11-08 00:00:00 | <1 | Pass |  |  |  |  | Fai
WILSON HOUSE CTA | HK1026374 | 2010-11-08 00:00:00 |  |  | 6100 | Pass |  |  | Fai
 | HK1026378 | 2010-11-08 00:00:00 |  |  |  |  | <10 | Pass | Fai
WILSON HOUSE CTB | HK1026377 | 2010-11-08 00:00:00 |  |  | 1400 | Pass |  |  | Fai
 | HK1026380 | 2010-11-08 00:00:00 |  |  |  |  | <10 | Pass | Fai
WO CHE CT | HK1026139 | 2010-11-04 00:00:00 |  |  | 4600 | Pass |  |  | [NAME]
 | HK1026163 | 2010-11-04 00:00:00 |  |  |  |  | <10 | Pass | [NAME]
WO CHE CT BLEED OFF WATER | HK1026153 | 2010-11-04 00:00:00 | <1 | Pass |  |  |  |  | [NAME]
YAN CHAI HOSPITAL CT | HK1026773 | 2010-11-11 00:00:00 |  |  | 52 | Pass |  |  | Fai
(blank) | 2010-12-10 00:00:00 | Results | (blank) | Result | (blank) | Result | (blank) | Result | (blank)
 | (blank) | (blank) | CFU/100mL | (blank) | CFU/mL | (blank) | CFU/mL | (blank) | (blank)