Spreadsheet: 717246d1612540658-sumproduct-numbers-only-in-a-filtered-range-20210112_stages-of-files_o-new-2
Sheet: SysFolder

Validation Tables | Scheme | Category | OPPT Department | Management | OPTAG | Scheme Defence | External | Status | Registered By | Bank Holidays |  | File Locations
 | WPS | Abatement | Management | [NAME] | [NAME] | [NAME] | Dr Braidwood | Stage 1 | [NAME] | 2015-01-01 00:00:00 | New Year’s Day | 6421 Cab 1 | 1 | 6326 B1
 | AFCS | AFBSS | OPTAG | [NAME] | [NAME] | JaneThompson | MA - Other | Stage 2 | [NAME] | 2015-04-03 00:00:00 | Good Friday | 6421 Cab 2 | 1 | 6326 [NAME]
 | Spanning | AFIP | SchemeDefence | [NAME] | [NAME] | [NAME] |  | Stage 3 | [NAME] | 2015-04-06 00:00:00 | Easter Monday | 6421 Cab 3 | 1 | 6326 B21
 | Other | Compensation | External |  | [NAME] | [NAME] |  | Stage 4 | [NAME] | 2015-05-04 00:00:00 | Early May bank holiday | 6421 Cab 4 | 1 | 6326 B22
 |  | CICO |  |  | [NAME] | [NAME] |  | Stage 5 | [NAME] | 2015-05-25 00:00:00 | Spring bank holiday | 6421 PP | 1 | 6326 B23
 |  | Civil Litigation |  |  | [NAME] | [NAME] |  |  | [NAME] | 2015-08-31 00:00:00 | Summer bank holiday | A16 / Dr Braidwood | 2 | 6326 PP
 |  | Exercise M |  |  | [NAME] |  |  |  |  | 2015-12-25 00:00:00 | Christmas Day | N/A File not required | 3
 |  | Exercises |  |  | [NAME] |  |  |  |  | 2015-12-28 00:00:00 | Boxing Day (substitute day)
 |  | GIP Calculations |  |  | [NAME] |  |  |  |  | 2016-01-01 00:00:00 | New Year’s Day
 |  | ICP |  |  |  |  |  |  |  | 2016-03-25 00:00:00 | Good Friday
 |  | FTT Monitoring |  |  |  |  |  |  |  | 2016-03-28 00:00:00 | Easter Monday
 |  | Mental Health |  |  |  |  |  |  |  | 2016-05-02 00:00:00 | Early May bank holiday
 |  | Meso Claims |  |  |  |  |  |  |  | 2016-05-30 00:00:00 | Spring bank holiday
 |  | Mod Civil Compensation |  |  |  |  |  |  |  | 2016-08-29 00:00:00 | Summer bank holiday
 |  | Ombudsman Cases |  |  |  |  |  |  |  | 2016-12-26 00:00:00 | Boxing Day
 |  | Other |  |  |  |  |  |  |  | 2016-12-27 00:00:00 | Christmas Day (substitute day)
 |  | PA Appeals |  |  |  |  |  |  |  | 2017-01-02 00:00:00 | New Year’s Day (substitute day)
 |  | PA Claims |  |  |  |  |  |  |  | 2017-04-14 00:00:00 | Good Friday
 |  | PA Commencing Dates |  |  |  |  |  |  |  | 2017-04-17 00:00:00 | Easter Monday
 |  | PA Entitlement |  |  |  |  |  |  |  | 2017-05-01 00:00:00 | Early May bank holiday
 |  | PA Fraud |  |  |  |  |  |  |  | 2017-05-29 00:00:00 | Spring bank holiday
 |  | PA Payments |  |  |  |  |  |  |  | 2017-08-28 00:00:00 | Summer bank holiday
 |  | PA Reconsideration |  |  |  |  |  |  |  | 2017-12-25 00:00:00 | Christmas Day
 |  | PA Reviews |  |  |  |  |  |  |  | 2017-12-26 00:00:00 | Boxing Day
 |  | PA Spanning |  |  |  |  |  |  |  | 2018-01-01 00:00:00 | New Year’s Day
 |  | PA Supplementary Allowances |  |  |  |  |  |  |  | 2018-03-30 00:00:00 | Good Friday
 |  | PA Surviving Dependents |  |  |  |  |  |  |  | 2018-04-02 00:00:00 | Easter Monday
 |  | PA Treatment |  |  |  |  |  |  |  | 2018-05-07 00:00:00 | Early May bank holiday
 |  | Radiation |  |  |  |  |  |  |  | 2018-05-28 00:00:00 | Spring bank holiday
 |  | Solicitors Case |  |  |  |  |  |  |  | 2018-08-27 00:00:00 | Summer bank holiday
 |  | Special Projects |  |  |  |  |  |  |  | 2018-12-25 00:00:00 | Christmas Day
 |  | TPC |  |  |  |  |  |  |  | 2018-12-26 00:00:00 | Boxing Day
 |  | Training Development |  |  |  |  |  |  |  | 2019-01-01 00:00:00 | New Year’s Day
 |  | VAPC |  |  |  |  |  |  |  | 2019-04-19 00:00:00 | Good Friday
 |  |  |  |  |  |  |  |  |  | 2019-04-22 00:00:00 | Easter Monday
 |  |  |  |  |  |  |  |  |  | 2019-05-06 00:00:00 | Early May bank holiday
 |  |  |  |  |  |  |  |  |  | 2019-05-27 00:00:00 | Spring bank holiday
 |  |  |  |  |  |  |  |  |  | 2019-08-26 00:00:00 | Summer bank holiday
 |  |  |  |  |  |  |  |  |  | 2019-12-25 00:00:00 | Christmas Day
 |  |  |  |  |  |  |  |  |  | 2019-12-26 00:00:00 | Boxing Day
 |  |  |  |  |  |  |  |  |  | 2020-01-01 00:00:00 | New Year’s Day
 |  |  |  |  |  |  |  |  |  | 2020-04-10 00:00:00 | Good Friday
 |  |  |  |  |  |  |  |  |  | 2020-04-13 00:00:00 | Easter Monday
 |  |  |  |  |  |  |  |  |  | 2020-05-08 00:00:00 | Early May bank holiday (VE day)
 |  |  |  |  |  |  |  |  |  | 2020-05-25 00:00:00 | Spring bank holiday
 |  |  |  |  |  |  |  |  |  | 2020-08-31 00:00:00 | Summer bank holiday
 |  |  |  |  |  |  |  |  |  | 2020-12-25 00:00:00 | Christmas Day
 |  |  |  |  |  |  |  |  |  | 2020-12-28 00:00:00 | Boxing Day (substitute day)
 |  |  |  |  |  |  |  |  |  | 2021-01-01 00:00:00 | New Year’s Day
 |  |  |  |  |  |  |  |  |  | 2021-04-02 00:00:00 | Good Friday
 |  |  |  |  |  |  |  |  |  | 2021-04-05 00:00:00 | Easter Monday
 |  |  |  |  |  |  |  |  |  | 2021-05-03 00:00:00 | Early May bank holiday
 |  |  |  |  |  |  |  |  |  | 2021-05-31 00:00:00 | Spring bank holiday
 |  |  |  |  |  |  |  |  |  | 2021-08-30 00:00:00 | Summer bank holiday
 |  |  |  |  |  |  |  |  |  | 2021-12-27 00:00:00 | Christmas Day (substitute day)
 |  |  |  |  |  |  |  |  |  | 2021-12-28 00:00:00 | Boxing Day (substitute day)