Spreadsheet: 144790d1331138228-sumproduct-with-multiple-citeria-and-between-dates-accident-reporting
Sheet: Data

Formatted up to Row 300 |  |  |  |  |  | Total Employees
FY | Period | Year | Wk # | Form # | Date of Occurrence | Time of Occurrence | Full Name (Surname Firstname) | ID Badge # | Hourly/ Salary/Agency/ Contractor | Date Reported | Time Reported | Manager [NAME] | Site | Department | Accident/ Incident /Near Miss/ Major/Ill Health | Nature of Occurrence | Brief Description of Occurrence | Date Form Passed To L/Leader | Date Form Passed to Occ Health | Date Form Copied to H&S Coord | Days Lost | Trackable Incident | Reportable to HSE | Date Reported to HSE | Date Form Sent For Insurance Purposes
#N/A | #N/A | 2012 | #N/A | S12 | 2012-01-03 00:00:00 | 01:20:00 | Name 1 | 55420 | Hourly | 2012-01-04 00:00:00 | 06:00:00 | Manager 1 | Holton F1 | Deboning | Accident | Exposed to, or in contact with a harmful substance | Chemical in eye | 2012-01-04 00:00:00 | 2012-01-04 00:00:00 | 2012-01-04 00:00:00 | 7 | Yes | Yes | 2012-08-12 00:00:00
#N/A | #N/A | 2012 | #N/A | S30 | 2012-01-16 00:00:00 | 05:00:00 | Name 2 | 101774 | Salaried | 2012-01-16 00:00:00 | 05:15:00 | Manager 2 | Holton F2 | Engineering | Incident | Manual handling, lifting or carrying | Strained back | 2012-01-16 00:00:00 |  |  | 2
#N/A | #N/A | 2012 | #N/A | S50 | 2012-01-21 00:00:00 | 15:00:00 | Name 3 | 105412 | Salaried | 2012-01-21 00:00:00 | 16:00:00 | Manager 3 | Other | Fryline | Near Miss | Other | Part of ceiling fell | 2012-01-21 00:00:00 |  | 2012-01-21 00:00:00 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Dropdown lists
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Site |  | acc Type
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Emp Type |  | Holton F1 |  | Accident
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | HS Acc Nature |  | Hourly |  | Holton F2 |  | Incident
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Contact with machinery or material being machined |  | Salaried |  | Other |  | Near Miss
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Cuts / Lacerations |  | Contractor |  |  |  | Property Damage
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Drowned or asphyxiated |  | Agency |  |  |  | Major
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Exposed to fire, heat, hot surface and/or explosion |  |  |  |  |  | Ill Health
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Exposed to, or in contact with a harmful substance |  |  |  | Dept
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Fall from height less than 2 metres |  |  |  | Ancillary
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Fall from height more than 2 metres |  |  |  | Deboning
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Hand tools (power or hand operated) |  |  |  | Despatch
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Hit by a moving, flying or falling object |  |  |  | Engineering
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Hit by moving vehicle |  |  |  | EV
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Hit something fixed or stationary |  |  |  | FP
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Manual handling, lifting or carrying |  |  |  | Fresh
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Physically assaulted by a person |  |  |  | Fryline
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Slipped, tripped or fell on the same level |  |  |  | Kill
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Transport accident |  |  |  | Sanitation
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Trapped by something collapsing |  |  |  | Trimming
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Other