Spreadsheet: 701936d1603992935-sumproduct-with-multiple-criteria-and-slicers-incident-tracker-test-
Sheet: Injury Tracker

 | INCIDENT TRACKER
 | OSHA Recordable? |  |  | Area Affected |  |  | OSHA-Recordability Factor |  |  | Time on Job Category
 | Yes |  |  | Head |  |  | Lost Work Days |  |  | Less than Three Months
 | No |  |  | Face |  |  | Restricted Duty |  |  | Three to Eleven Months
 |  |  |  | Neck |  |  | Medical Treatment |  |  | One to Five Years
 | Shift |  |  | Eyes |  |  | First Aid |  |  | Over Five Years
 | Day |  |  | Back |  |  | Report Only
 | Night |  |  | Trunk |  |  |  |  |  | Incident Type
 |  |  |  | Shoulders |  |  | Department |  |  | Contusion
 |  |  |  | Arms |  |  | Contracting |  |  | Foreign Object
 |  |  |  | Elbows |  |  | Fire Department |  |  | Illness / Other
 |  |  |  | Wrists |  |  | [NAME] |  |  | Laceration
 |  |  |  | Hands / Fingers |  |  | Logistics |  |  | Puncture
 |  |  |  | Knees |  |  | Maintenance |  |  | Slip & Fall
 |  |  |  | Multiple |  |  | R&D |  |  | Strain
 |  |  |  | Illness / Other |  |  | Security
 |  |  |  | Ankles
 |  |  |  | Feet / Toes
 | Incident Date | FY | Month | Incident Type | Area Affected | OSHA Recordable? | OSHA-Recordability Factor | Department | Shift | Job Description | Location | Employee Name | Hire Date | Time on the Job When Injured | Time on the Job Category | SUMMARY FROM INITIAL REPORT | CLAIM #
 | 2020-10-18 00:00:00 | FY21 | OCT | Illness / Other | Multiple | No | Report Only | R&D | Night | Scientist | Hill Valley, CA | [NAME], [NAME] | 1955-10-25 00:00:00 |  | Over Five Years | Employee reports multiple issues including dizziness, nausea, and blurred vision from time displacement. | WC-0010025
 | 2020-10-16 00:00:00 | FY21 | OCT | Strain | Back | No | Report Only | R&D | Night | Astronaut | Acidalia Planitia, Mars | Watney, [NAME] | 2015-10-02 00:00:00 |  | One to Five Years | Employee reports he was opening the hatch on the rover when he felt pain in his back. | WC-0010024
 | 2020-10-09 00:00:00 | FY21 | OCT | Laceration | Head | No | Report Only | Logistics | Day | Nuclear Technician | The State | THX-1138 | 1971-03-11 00:00:00 |  | Over Five Years | Employee reports he was shaving head when he cut his scalp; not work-related. | WC-0010023
 | 2020-09-04 00:00:00 | FY21 | SEP | Strain | Back | No | First Aid | [NAME] | Day | [NAME] | Bespin | Skywalker, [NAME] | 1977-03-25 00:00:00 |  | Over Five Years | Strained back falling onto escape hatch of Millennium Falcon. | WC-0010022
 | 2020-08-27 00:00:00 | FY21 | AUG | Strain | Back | Yes | Restricted Duty | Security | Day | Road Warrior | Australia | Rockatansky, [NAME] | 1980-03-21 00:00:00 |  | Over Five Years | Strained back while lying on floor of gyro-copter. | WC-0010021
 | 2020-03-18 00:00:00 | FY20 | MAR | Laceration | Hands / Fingers | No | First Aid | Logistics | Night | Cargo Loader | USCSS Nostromo | Ripley, [NAME] | 1979-06-22 00:00:00 |  | Over Five Years | Xenomorph bite on left hand. | WC-0010020
 | 2020-03-06 00:00:00 | FY20 | MAR | Contusion | Arms | No | Report Only | R&D | Day | Hitchhiker | London, UK | Prefect, Ford | 2005-04-29 00:00:00 |  | Over Five Years | Slammed left forearm in door of spaceship. | WC-0010019
 | 2020-02-21 00:00:00 | FY20 | FEB | Strain | Shoulders | No | Report Only | Contracting | Night | Mercenary | New York, NY | [NAME], Snake | 1981-07-10 00:00:00 |  | Over Five Years | Strained right shoulder picking up machine gun. | WC-0010018
 | 2020-02-16 00:00:00 | FY20 | FEB | Strain | Back | Yes | Restricted Duty | Maintenance | Night | Telecommunications Technician | Muncie, IN | Neary, [NAME] | 1977-12-14 00:00:00 |  | One to Five Years | Employee reports he was climbing Devil's Tower when he felt a pain in his back. | WC-0010017
 | 2020-02-12 00:00:00 | FY20 | FEB | Contusion | Ankles | Yes | Restricted Duty | Fire Department | Day | Fireman | Los Angeles, CA | Montag, [NAME] | 1966-11-14 00:00:00 |  | Over Five Years | Employee reports while burning books, a bookshelf collapsed onto his left ankle. | WC-0010016
 | 2020-01-24 00:00:00 | FY20 | JAN | Strain | Back | Yes | Restricted Duty | Security | Night | Immigration Agent | New York, NY | [NAME], Agent | 1997-07-02 00:00:00 |  | Over Five Years | Strained back being swallowed by giant cockroach. | WC-0010015
 | 2020-01-13 00:00:00 | FY20 | JAN | Slip & Fall | Wrists | No | Report Only | Security | Night | [NAME] | Los Angeles, CA | Deckard, [NAME] | 1982-06-25 00:00:00 |  | Over Five Years | Stepped out of flying car before landing was complete and fell on his left writs, causing pain. | [NAME]
 | 2020-01-02 00:00:00 | FY20 | JAN | Strain | Shoulders | Yes | Restricted Duty | R&D | Day | Scientist | Hill Valley, CA | [NAME], [NAME] | 1955-10-25 00:00:00 |  | Over Five Years | Strained left shoulder opening time machine door. | WC-0010013
 | 2019-12-05 00:00:00 | FY20 | DEC | Laceration | Trunk | Yes | Medical Treatment | R&D | Day | Astronaut | Acidalia Planitia, Mars | Watney, [NAME] | 2015-10-02 00:00:00 |  | One to Five Years | Shrapnel from hydrogen explosion lacerated abdomen. | WC-0010012
 | 2019-11-13 00:00:00 | FY20 | NOV | Illness / Other | Illness / Other | No | Report Only | Logistics | Day | Nuclear Technician | The State | THX-1138 | 1971-03-11 00:00:00 |  | Over Five Years | Employee reports a dizzy feeling after working with uranium rods. | WC-0010011
 | 2019-11-13 00:00:00 | FY20 | NOV | Laceration | Hands / Fingers | Yes | Lost Work Days | [NAME] | Day | [NAME] | Bespin | Skywalker, [NAME] | 1977-03-25 00:00:00 |  | Over Five Years | Employee reports losing right hand during lightsaber fight. | WC-0010010
 | 2019-11-05 00:00:00 | FY20 | NOV | Strain | Back | No | Report Only | Security | Day | Road Warrior | Australia | Rockatansky, [NAME] | 1980-03-21 00:00:00 |  | Over Five Years | Was stepping out of Interceptor when he felt a twinge in his lower back. | WC-0010009
 | 2019-10-29 00:00:00 | FY20 | OCT | Illness / Other | Illness / Other | No | Report Only | Logistics | Night | Cargo Loader | USCSS Nostromo | Ripley, [NAME] | 1979-06-22 00:00:00 |  | Over Five Years | Employee reports feeling nauseous after awakening from cryosleep. | WC-0010008
 | 2019-09-12 00:00:00 | FY20 | SEP | Strain | Hands / Fingers | No | Report Only | R&D | Day | Hitchhiker | London, UK | Prefect, Ford | 2005-04-29 00:00:00 |  | Over Five Years | Strained right thumb while hitching a ride on a Vogon ship. | WC-0010007
 | 2019-08-13 00:00:00 | FY20 | AUG | Strain | Back | Yes | Restricted Duty | Contracting | Night | Mercenary | New York, NY | [NAME], Snake | 1981-07-10 00:00:00 |  | Over Five Years | Was carrying the President out of Manhattan when he felt a pain in his back. | WC-0010006
 | 2019-08-09 00:00:00 | FY20 | AUG | Foreign Object | Eyes | No | Report Only | Maintenance | Night | Telecommunications Technician | Muncie, IN | Neary, [NAME] | 1977-12-14 00:00:00 |  | Over Five Years | Looking up at UFOs when something got in his right eye. | WC-0010005
 | 2019-08-07 00:00:00 | FY20 | AUG | Illness / Other | Illness / Other | No | Report Only | Security | Night | Immigration Agent | New York, NY | [NAME], Agent | 1997-07-02 00:00:00 |  | Over Five Years | Memory loss; not work-related. | WC-0010004
 | 2019-07-11 00:00:00 | FY20 | JUL | Contusion | Ankles | Yes | Lost Work Days | Fire Department | Day | Fireman | Los Angeles, CA | Montag, [NAME] | 1966-11-14 00:00:00 |  | Over Five Years | Strained right ankle stepping off fire truck. | WC-0010003
 | 2019-06-11 00:00:00 | FY19 | JUN | Laceration | Hands / Fingers | Yes | Restricted Duty | Security | Night | [NAME] | Los Angeles, CA | Deckard, [NAME] | 1982-06-25 00:00:00 |  | Over Five Years | Cut left index finger on flying car door. | WC-0010002
 | 2019-06-10 00:00:00 | FY19 | JUN | Contusion | Ankles | No | Report Only | R&D | Day | Scientist | Hill Valley, CA | [NAME], [NAME] | 1955-10-25 00:00:00 |  | Over Five Years | Was climbing into time machine and slammed door on ankle. | WC-0010001