Spreadsheet: 685655d1594130570-counting-conditionally-formatted-cells-which-are-blank-config
Sheet: Config 1

Task | Job Family | Inspect | Check | Clean | Survey | Tag out | Remove | [NAME] | Limited overhaul | Top overhaul | Refurbish | Refurbish pipework | Install | Renew | Replace | Pressure and endurance test | Shop Test | Load Test | Operational Test | Set to work | Report | Adjust | Assemble | Calibrate | Dismantle | Push/Purge | Functional Test | Isolate | Preservation | Rectify | Renew coatings | Represerve | Lock | Off | Test | UxE | Work in way | Deep cleaning | Limited set to work | Weigh
 | Inspect | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
 | Check |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
 | Clean |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
 | Survey |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
 | Tag out |  |  |  |  | 1
 | Remove |  |  |  |  | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  |  | 1
 | [NAME] |  |  |  |  | 1 | 1 | 1 |  |  |  |  | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  |  |  |  |  |  |  |  |  | 1
 | Limited overhaul |  |  |  |  | 1 | 1 |  | 1 |  |  |  | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  |  |  |  |  |  |  |  |  | 1
 | Top overhaul |  |  |  |  | 1 | 1 |  |  | 1 |  |  | 1 |  |  |  |  | 1 |  | 1 | 1 |  |  |  |  |  |  |  |  |  |  | 1
 | Refurbish |  |  |  |  | 1 | 1 |  |  |  | 1 |  | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  |  |  |  |  |  |  |  |  | 1
 | Refurbish pipework |  |  |  |  | 1 | 1 |  |  |  |  | 1 | 1 |  |  |  |  |  |  | 1 | 1 |  |  |  |  |  |  |  |  |  |  | 1
 | Install |  |  |  |  | 1 | 1 |  |  |  |  |  | 1 |  |  |  |  |  |  | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
 | Renew |  |  |  |  | 1 | 1 |  |  |  |  |  |  | 1 |  | 1 |  |  |  | 1 | 1
 | Replace |  |  |  |  | 1 | 1 |  |  |  |  |  |  |  | 1 | 1 |  |  |  | 1 | 1
 | Pressure and endurance test |  |  |  |  | 1 |  |  |  |  |  |  |  |  |  | 1 |  |  |  | 1 | 1 |  |  |  |  | 1 |  | 3
 | Shop Test |  |  |  |  | 1 | 1 |  |  |  |  |  | 1 |  |  |  | 1 |  |  | 1 | 1
 | Load Test |  |  |  |  |  | 1 |  |  |  |  |  |  |  | 1 |  |  | 1 |  |  | 1
 | Operational Test |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  | 1
 | Set to work |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1
 | Report |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
 | Adjust |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1
 | Assemble |  |  |  |  |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  | 1 | 1 |  | 1
 | Calibrate |  |  |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  |  | 1 |  |  |  | 1
 | Dismantle |  |  |  |  | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  |  |  | 1 |  |  | 1
 | Push/Purge |  |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  | 1
 | Functional Test |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  |  |  |  |  | 1
 | Isolate |  |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
 | Preservation |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  | 1
 | Rectify |  | 1 |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  | 1
 | Renew coatings |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  |  |  |  |  | 1
 | Represerve |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  |  |  |  | 1
 | Lock |  |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
 | Off |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
 | Test |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
MSM supply | UxE |  |  |  |  | 1 | 1 |  |  |  |  |  | 1 |  |  |  |  |  |  | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
 | Work in way |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
 | Deep cleaning |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
 | Limited set to work |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
 | Weigh |  |  |  |  |  | 1 |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1