Spreadsheet: 729959d1619456090-countifs-a-range-is-not-blank-master-mi-v8-dummy-data-
Sheet: Reports

 |  |  |  |  |  |  |  |  | SPLIT |  |  |  |  | TOOL |  |  |  |  |  | STANDARD |  |  |  |  |  |  |  |  | CUSTOM |  |  |  |  |  |  |  |  |  |  |  | 3PD |  |  |  |  |  |  | DATA SOURCE
 |  |  | Each row = 1 document |  |  |  |  | (Hours)
 | GV Ref | DW Shortname | Client Name | Report Name | Expert | Frequency | Cycle | Prod Time | Division | Department | Location | Custom Grouping | Custom Filter | PBI | SSRS | MI Tool | [NAME] v5 | Manual | Refreshable SLA | Exec Summary | [NAME] | Referral Activity | HAQ Activity | FME | ICD, WR & EQA | Trends & Benches | DNA & Canx | SLA | Health Surveillance | Primary Care | Headcount & Referral Rate | Re-Referrals | Triage Breakdown | Sickness & Absence | Mental Health | Gender & Age | Test Outcomes | Financials | Scope Of Works | Deferred Pension | D & A Testing | VITA EAP Stats | RONA Stats | Physio | Dental | Intranet Hits | Survey Results | HMLO: [HMLDB1].[dbHM] | DW: [HMLSQLDW01].[dbHMLDWH] | Ohpera: [HMLDB1].[OhperaV2] | Meddbase: [HMLSQLDW01].[dbPrimaryCareLnd] | LFB: [HMLDB1].[LFBdbHM ] | CSM | Client | Finance | Clinical Operations | [NAME] | In [NAME] | Survey Monkey | VITA | Column1 | Column8 | Column2 | Column3 | Column4 | Column5 | Column6 | Column7
 | 1003822 | RADIA
 | 1000051 | ACCEN |  |  |  |  |  |  |  | 1 |  |  |  |  | X |  |  |  |  | X |  | X | X | X | X | X |  | H |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | X
 | 1000137 | AIRPR |  |  |  |  |  |  |  |  | X |  |  |  | X |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | X
 | 1000137 | AIRPR |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | X |  |  |  |  |  |  |  |  |  |  | H |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | X
 | 1000137 | AIRPR |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | X |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | H |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | X
 | 1000350 | Atkin |  |  |  |  |  |  |  |  |  |  |  | X |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | X
 | 1000350 | Atkin |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | X |  |  |  |  |  |  |  |  | H |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | X
 | 1000429 | [NAME]
 | 1000448 | BNY |  |  |  |  |  |  | 2 |  | 1 |  |  |  |  | X |  | X | X | X | X | X |  |  | X | X |  | X |  |  |  | H |  | H |  |  |  |  |  |  |  |  |  |  |  |  |  | X
 | 1000588 | Blab
 | 1000605 | C3Blo
 | 1000623 | BOCD
 | 1000755 | BT001 |  |  |  |  |  |  |  |  |  |  |  |  |  | X |  | X | X |  |  |  |  |  |  |  |  |  |  |  |  | H |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | X
 | 1000755 | BT001 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | X |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | H |  |  |  |  |  |  |  | X
 | 1000755 | BT001
 | 1000755 | BT001 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | X |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | H |  |  |  |  |  |  |  |  |  |  |  | X
 | 1000800 | CAD |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | H |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | X
 | 1000800 | CAD |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | H |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | X
 | 1000800 | CAD |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | H | H |  |  |  |  |  | X |  |  |  |  |  |  |  |  | X |  |  | X
 | 1000800 | CAD |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | H | H |  |  |  |  |  | X |  |  |  |  |  |  |  |  | X |  |  | X
 | 1000823 | CAMBS
 | 1000894 | catch
 | 1000894 | catch
 | 1001050 | CITB
 | 1001070 | COLC
 | 1001075 | [NAME]
 | 1001080 | Civil
 | 1001186 | CCBC |  |  |  |  |  |  | X |  |  |  |  |  |  | X |  | X | X | X |  | X | X | X | X | X |  | X |  |  |  |  | H |  |  | H |  |  |  |  |  |  |  |  |  |  |  | X
 | 1001186 | CCBC |  |  |  |  |  |  | 1 | 2 |  | X | X |  |  | X |  | X |  | X |  | X | X | X | X | X |  |  |  |  |  |  |  |  |  | H |  |  |  |  |  |  |  |  |  |  |  | X
 | 1001254 | C3CS |  |  |  |  |  |  | X |  |  |  |  |  |  | X |  | X |  | H | X | X |  |  | X | X |  |  |  |  |  |  |  |  | H |  |  |  | H |  |  |  |  |  |  |  |  | X |  |  |  |  | X
 | 1001254 | C3CS |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | X |  |  |  |  |  |  |  |  | X |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | X
 | 1001348 | DBCAR |  |  |  |  |  |  |  | X |  |  |  |  |  |  | X |  | X | X | X | H |  | X | X | X |  | X |  |  |  |  |  |  |  |  | H |  |  |  |  |  |  |  |  |  |  | X
 | 1001353 | DLR |  |  |  |  |  |  |  | X |  | X | X |  |  | X |  | X | X | X | X | X | X | H | X | X |  | X |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | X
 | 1001356 | DMU
 | 1001389 | DFE |  |  |  |  |  |  | 1 | 2 |  |  |  |  |  | X |  | X | X | X | X | H |  | X | H | X |  | X |  |  | H |  |  | H |  |  |  |  |  |  |  |  |  |  |  |  |  | X |  |  |  |  |  |  |  |  |  | X
 | 1001391 | DOT
 | 1001393 | DOH |  |  |  |  |  |  | X |  |  | X | X |  |  | X |  | X |  | X |  | X |  | H | X | X |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | X
 | 1001393 | DOH |  |  |  |  |  |  | X |  |  | X |  |  |  | X |  | X |  | X |  | X |  | H | H | H |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | X
 | 1001440 | DIXON
 | 1001440 | DIXON
 | 1001504 | DVSA
 | 1001545 | EBC |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | X |  |  |  |  |  |  |  |  | X |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | X
 | 1001571 | [NAME]
 | 1001581 | EDVAC
 | 1001582 | EVEVW |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | X |  |  |  |  |  |  |  |  |  | H |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | X
 | 1001719 | Farr
 |  | 0
 |  | 0
 | 1001982 | TSOL
 | 1002026 | GROS |  |  |  |  |  |  |  | X |  |  |  |  | X |  |  | X |  | X |  | X | X | X | X | X |  | X | H | H | H |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | X |  |  | X |  |  |  |  | X |  | X
 | 1002114 | HD |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | X |  |  |  |  |  |  |  |  | X |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | X
 | 1002169 | IPS |  |  |  |  |  |  |  | 2 | 1 |  |  |  |  | X |  | X | X | H |  | H | X | H | X | X |  |  |  |  |  | H |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | X |  |  |  |  | X
 | 1002171 | B&HCa
 | 1002172 | [NAME]
 | 1002230 | LREG |  |  |  |  |  |  |  |  | X |  |  |  |  | X | X |  | X | X |  | X |  | H | X | X |  | X |  | H |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | X |  |  |  |  |  |  |  |  |  | X
 | 1002230 | LREG |  |  |  |  |  |  |  |  |  |  |  |  |  | X |  |  |  |  |  |  |  |  |  |  | X |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | X
 | 1002253 | HOHQ |  |  |  |  |  |  |  |  | 1 | X | X |  |  | X |  |  |  | H |  | H | X | H | X | X |  |  |  |  |  | H |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | X |  |  |  |  | X
 |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | X |  |  |  |  |  |  |  |  | H |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | X
 | 1002376 | ICO
 | 1002432 | IMG
 | 1002435 | INTSE |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | X |  |  |  |  |  |  |  |  | X |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | X
 | 1002436 | Inti |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | X |  |  |  |  |  |  |  |  | X |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | X
 | 1002437 | INTCO |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | X |  |  |  |  |  |  |  |  | X |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | X
 | 1002535 | Johns |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | X |  | H |  |  |  |  |  |  |  |  | H |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | X |  | X
 | 1002535 | Johns |  |  |  |  |  |  |  | 2 | 1 |  |  |  |  | X |  | X | X | X |  | H | X | X | X | X |  | H |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | X
 | 1002548 | JLL
 | 1002559 | JUD |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | X |  |  |  |  |  |  |  |  |  | H |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | X |  |  |  |  |  |  |  |  |  |  | X
 | 1002599 | KAM |  |  |  |  |  |  |  | 1 |  |  |  |  |  | X |  |  | X | X |  | H | X | H | X | X |  | X |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | X
 | 1002607 | KFC
 | 1002724 | LGMH1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | X |  |  |  |  |  |  |  |  | X |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | X
 | 1002727 | Lcity
 | 1002729 | Leic
 | 1002729 | Leic
 | 1002757 | LTC |  |  |  |  |  |  | 1 |  |  |  |  |  | X | X |  | X |  | X |  | H | X | X | X | X |  | H |  |  |  |  |  | H |  |  |  |  |  |  |  |  |  |  |  |  |  | X
 | 1002759 | LFR |  |  |  |  |  |  |  | 1 |  |  |  |  | X | X |  | X |  | X |  | H | X | X | X | X |  | H |  |  |  |  |  | H |  |  |  |  |  |  |  |  |  |  |  |  |  | X
 | 1002766 | C3LL |  |  |  |  |  |  |  |  |  |  |  |  |  | X |  | X |  | X |  | H |  |  | X | X |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | X
 | 1002772 | [NAME]
 | 1002773 | LIV
 | 1002815 | LBH |  |  |  |  |  |  | 1 | 2 |  |  |  |  | X |  |  |  |  | X | X | X | X | X | X | X |  | X |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | X
 | 1002820 | LBHil
 | 1002821 | LBOHW |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | X |  |  |  |  |  |  |  |  | X |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | X
 | 1002837 | LonBC
 | 1002842 | LFB |  |  |  |  |  |  |  |  |  |  |  | X |  |  |  | X |  |  |  |  |  |  |  |  | X | H |  |  |  |  |  | H |  |  |  |  |  |  | H |  |  |  |  |  |  |  |  |  |  | X | X | X
 | 1002842 | LFB |  |  |  |  |  |  |  |  |  |  |  | X
 | 1002842 | LFB |  |  |  |  |  |  |  |  |  |  |  | X
 | 1002896 | Mac
 | 1002901 | MB
 | 1002941 | MaCu
 | 1002943 | [NAME]
 | 1002953 | MARRH
 | 1002963 | C3Mar
 | 1002998 | MDU
 | 1003013 | MeBC
 | 1003032 | MERAI |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  | X |  | X |  | X |  |  |  | X | X |  | X |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | X
 | 1003040 | MET
 | 1003095 | MOJ |  |  |  |  |  |  |  | X | X |  |  |  | X | X |  | X |  | X | X | X | X | X | X | X |  | X |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | X
 | 1003095 | MOJ |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | X | X |  |  |  |  |  |  |  |  | X |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | X
 | 1005488 | MTREL
 | 1003189 | NAO
 | 1003200 | NGOH
 | 1003200 | NGOH
 | 1003201 | NatGr
 | 1003214 | TRUST |  |  |  |  |  |  | 1 | 2 | X |  |  |  |  | X |  | X |  | X |  | X | X | X | H | X |  | H |  |  |  |  |  |  |  |  |  | H |  |  |  |  |  |  |  |  |  | X |  |  |  |  |  |  | X
 | 1003214 | TRUST |  |  |  |  |  |  |  |  |  |  |  |  |  | X |  |  |  |  |  |  |  |  |  |  | X |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | X
 | 1004675 | ENSER
 | 1003279 | NHSE |  |  |  |  |  |  | 1 | 2 |  |  |  |  | X |  |  |  |  | X | X | X | X | X | X | X |  | X |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | X
 | 1003347 | NLANC
 | 1003371 | NCC
 | 1003371 | NCC
 | 1003401 | NWL
 | 1003474 | Ofst1
 | 1003474 | Ofst1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | H |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | X
 | 1003475 | Ofst2
 | 1003493 | OpUni
 | 1003498 | Opteg
 | 1003519 | ORR |  |  |  |  |  |  |  |  | X |  |  |  |  | X |  |  |  |  | X | X | X | X | X | X |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | X
 | 1003673 | PM |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | X |  |  |  |  |  |  |  |  |  |  |  | H |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | X
 | 1003673 | PM |  |  |  |  |  |  | X |  |  |  |  |  |  | X |  |  |  | H | X | X | X |  | X | X |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | X
 | 1003678 | PIZZD
 | 1003680 | pizza
 | 1003761 | PromE
 | # No Acc | RPBTP
 | 1003838 | RB
 | 1003838 | RB
 | 1003982 | RMC |  |  |  |  |  |  |  |  |  |  |  | X |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | X
 | 1003982 | RMC |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | X |  |  |  |  |  |  |  |  | X |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | X
 | 1003999 | RCN
 | 1004012 | RMSPS
 | 1004054 | RYDER
 | 1004176 | Serco
 |  | 0
 | 1004297 | SOP
 | 1004335 | SWWL1 |  |  |  |  |  |  |  | X | X |  |  |  |  | X |  | X | X | H |  | X | X | H | H | X |  | X | H |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | X |  |  |  |  | X
 | 1004335 | SWWL1 |  |  |  |  |  |  |  |  |  |  |  |  |  | X |  |  |  |  |  |  |  |  |  |  | X |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | X
 | 1004414 | StJOH
 | 1004436 | SDRAI |  |  |  |  |  |  |  |  |  |  |  | X |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | X
 | 1004436 | SDRAI |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | X |  |  |  |  |  |  |  |  | X |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | X
 | 1004446 | LIFE
 | 1005409 | SLP
 | 1004582 | TATE
 | 1004628 | THALE
 | 1004647 | TheBr
 | 1004694 | MILT
 | 1004698 | TNA
 | 1004711 | TPI
 | 1004860 | TRW
 | 1004890 | UBS
 | 1004890 | UBS
 | 1004890 | UBS |  |  |  |  |  |  |  |  |  |  |  |  |  | X | X |  |  | X | X |  |  |  | X |  |  | X |  | X |  |  |  |  |  |  |  |  |  |  |  |  |  | X | X | X |  | X |  |  | X |  | X
 | 1004915 | ULVR
 | 1004915 | ULVR
 | 1004937 | UniUK
 | 1002137 | UnivL
 | 1002137 | UnivL
 | 1004986 | TUOS
 | 1005009 | UPS |  |  |  |  |  |  | X |  |  |  |  |  |  | X |  |  | X | H |  | X | X | X | X | X |  | H |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | X |  |  |  |  | X
 | 1005052 | VC
 | 1005052 | VC
 | 1005053 | VMed
 | 1005053 | VMed
 | 1005057 | Viriw |  |  |  |  |  |  | X | X |  |  |  |  |  | X |  | X | X | H |  | X | X | H | H | X |  | X | H |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | X |  |  |  |  | X
 | 1005057 | Viriw |  |  |  |  |  |  |  |  |  |  |  |  |  | X |  |  |  |  |  |  |  |  |  |  | X |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | X
 | 1005109 | WARBU
 | 1005109 | WARBU
 | 1005109 | WARBU
 | 1005109 | WARBU
 | 1005109 | WARBU
 | 1005109 | WARBU
 | 1000078 | ADDAC |  |  |  |  |  |  |  | X |  |  |  |  | X |  |  |  |  | X |  | X | X | X | X | X |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | X
 | 1005184 | WECC
 | 1005231 | WH
 | 1005243 | INSPA
 | 1005244 | Wilso
 | 1005249 | WIN
 | 1005249 | WIN
 | 1005264 | [NAME]
 | 1005311 | Xerox |  |  |  |  |  |  | X |  |  |  |  |  |  | X |  |  |  | H | X | X | X | H | H | X |  | X |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | X
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0