Spreadsheet: 778423d1651060261-date-range-and-average-formula-data-dashboard-averages
Sheet: Sheet1

Date Range | 2022-01-03 00:00:00
Average
Project Ref. | Date of Insp. | Score | 1. Inspections/Reporting | 2. Documentation | 3. Coordination of H&S | 4. Competency | 5. Welfare Arrangements | 6. First Aid | 7. Protecting the Public & Corporate Image | 8. Housekeeping & Workplace Access | 9. Storage ([NAME]. Haz Substances) | 10. Emergencies | 11. Risk Assessment/Method Statements (RAMS) | 12. Permits | 13. Confined Spaces | 14. Excavations | 15. Work at Height | 16. Scaffold | 17. Lifting Equipment & Operations | 18. Powered Access Equipment | 19. Vehicles/Vehicular Movements | 20. Portable Tools | 21. Services | 22. Traffic Management | 23. Plant & Machinery | 24. [NAME] | 25. Noise & Vibration | 26. Temporary Works | 27. Hazardous Substances | 28. Control of Subcontractors | 29. Protective Clothing PPE | 30. Offices |  | Reds | Ambers | Greens | n/a
BD960 | 2019-01-31 00:00:00 |  | 1 | 2 | 1 | 2 | 1 | 1 | 1 | 2 | 2 | 1 | 1 | 1 | n/a | 1 | n/a | n/a | 1 | n/a | 2 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 |  | 0 | 5 | 95
BD960 | 2019-03-06 00:00:00 |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 2 | 1 | 1 | 1 | n/a | 1 | n/a | n/a | 1 | n/a | 1 | 1 | 1 | 1 | 1 | 1 | 2 | 1 | 2 | 1 | 1 | 1 |  | 0 | 3 | 97
C990 | 2020-07-20 00:00:00 |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | n/a | 1 | n/a | n/a | 1 | n/a | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | n/a | 1 | 1 |  | 0 | 0 | 82
C978 | 2021-02-23 00:00:00 |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 2 | 1 | 1 | 1 | n/a | 1 | n/a | n/a | 1 | n/a | 1 | 1 | 1 | 1 | 2 | 1 | 1 | 1 | 2 | n/a | 3 | 2 |  | 1
C978 | 2021-02-23 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 5 | 95
C978 | 2021-03-25 00:00:00 |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 2 | 1 | 1 | 1 | n/a | 1 | n/a | n/a | 1 | n/a | 1 | 1 | 1 | 1 | 2 | 1 | 1 | 1 | 2 | n/a | 1 | 2 |  | 0 | 3 | 78
C978 | 2021-03-25 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 3 | 97
C978 | 2021-06-18 00:00:00 |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 2 | 1 | 1 | 1 | 1 | n/a | 2 | 2 | n/a | 1 | n/a | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | n/a | 1 | 1 |  | 0 | 3 | 82
C978 | 2021-06-18 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 82
C978 | 2021-08-10 00:00:00 |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 2 | 1 | 1 | 1 | 1 | n/a | 1 | 1 | n/a | 2 | n/a | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | n/a | 1 | 1 |  | 0 | 2 | 83
C978 | 2021-08-10 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
RC1013 | 2022-02-16 00:00:00 |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 2 | n/a | 1 | 1 | 1 | n/a | 2 | 2 | n/a | n/a | n/a | n/a | 1 | 1 | 1 | n/a | 1 | n/a | 1 | n/a | n/a | 1 | 1 |  | 0 | 4 | 63
RC1013 | 2022-02-16 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 3 | 78
RC1013 | 2022-03-17 00:00:00 |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 2 | 1 | 1 | n/a | 1 | 1 | 1 | 1 | n/a | 1 | 1 | 1 | 1 | n/a | 1 | 1 | 1 | 1 | n/a | 1 | 1 |  | 0 | 1 | 86
RC1013 | 2022-03-16 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 3 | 82
RC1013 | 2022-04-01 00:00:00 |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | n/a | 1 | 1 | 1 | 1 | n/a | 1 | 1 | 1 | 1 | n/a | 1 | 1 | 1 | 1 | n/a | 1 | 1 |  | 0 | 0 | 86
Test | 2022-04-02 00:00:00 |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 |  | 0 | 0 | 100 | 1
RC1013 | 2022-04-03 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 2 | 83
Test | 2022-04-04 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 4 | 63
RC1013 | 2022-04-05 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 1 | 86
Test | 2022-04-06 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 86
RC1013 | 2022-04-07 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 100 | 1