Spreadsheet: 74302d1274847860-how-to-work-out-percentages-from-specific-primary-secondary-items-in-lists-etc-dummy-sheet
Sheet: Sheet1

Item Reference | Year Lodged | Department | Sub Group | Last Year Check | Category | Response | On Track? | Not On Track?
874 | 1900-07-01 00:00:00 | Apples | Research | 1902-07-01 00:00:02 | Service - TypeB | 4 Months | 1 | 0
643 | 1900-07-02 00:00:00 | Oranges | Development | 1902-07-02 00:00:02 | Incident - Type B | 4 Months | 0 | 1
419 | 1900-07-03 00:00:00 | Apples | Sales | 1902-07-03 00:00:02 | Incident - Type A | 5 Months | 1 | 0
642 | 1900-07-04 00:00:00 | Oranges | Delivery | 1902-07-04 00:00:02 | Service - Type A | 6 Months | 1 | 0
557 | 1900-07-05 00:00:00 | Grapes | Research | 1902-07-05 00:00:02 | Service - Type A | 7 Months | 1 | 0
959 | 1900-07-06 00:00:00 | Grapes | Development | 1902-07-06 00:00:02 | Incident - Type B | 8 Months | 1 | 0
500 | 1900-07-07 00:00:00 | Pears | Sales | 1902-07-07 00:00:02 | Incident - Type B | 9 Months | 1 | 0
884 | 1900-07-08 00:00:00 | Bannanas | Delivery | 1902-07-08 00:00:02 | Incident - Type B | 10 Months | 1 | 0
932 | 1900-07-09 00:00:00 | Peaches | Research | 1902-07-09 00:00:02 | Service - Type B | 11 Months | 1 | 0
790 | 1900-07-10 00:00:00 | Bannanas | Development | 1902-07-10 00:00:02 | Service - Type A | 12 Months | 0 | 1
864 | 1900-07-11 00:00:00 | Peaches | Sales | 1902-07-11 00:00:02 | Incident - Type B | 13 Months | 0 | 1
801 | 1900-07-12 00:00:00 | Apples | Delivery | 1902-07-12 00:00:02 | Incident - Type B | 14 Months | 0 | 1
849 | 1900-07-13 00:00:00 | Oranges | Research | 1902-07-13 00:00:02 | Incident - Type B | 15 Months | 1 | 0
404 | 1900-07-14 00:00:00 | Oranges | Development | 1902-07-14 00:00:02 | Incident - Type A | 16 Months | 0 | 1
465 | 1900-07-15 00:00:00 | Apples | Sales | 1902-07-15 00:00:02 | Incident - Type B | 17 Months | 0 | 1
544 | 1900-07-16 00:00:00 | Oranges | Delivery | 1902-07-16 00:00:02 | Service - Type A | 18 Months | 0 | 1
488 | 1900-07-17 00:00:00 | Apples | Research | 1902-07-17 00:00:02 | Service - Type B | 19 Months | 0 | 1
592 | 1900-07-18 00:00:00 | Oranges | Development | 1902-07-18 00:00:02 | Service - Type B | 20 Months | 1 | 0
744 | 1900-07-19 00:00:00 | Grapes | Sales | 1902-07-19 00:00:02 | Service - Type A | 21 Months | 0 | 1
411 | 1900-07-20 00:00:00 | Grapes | Delivery | 1902-07-20 00:00:02 | Service - Type B | 22 Months | 0 | 1
638 | 1900-07-21 00:00:00 | Pears | Research | 1902-07-21 00:00:02 | Service - Type A | 23 Months | 0 | 1
901 | 1900-07-22 00:00:00 | Bannanas | Development | 1902-07-22 00:00:02 | Service - Type B | 24 Months | 0 | 1
443 | 1900-07-23 00:00:00 | Peaches | Sales | 1902-07-23 00:00:02 | Incident - Type A | 25 Months | 1 | 0
971 | 1900-07-24 00:00:00 | Bannanas | Delivery | 1902-07-24 00:00:02 | Incident - Type B | 26 Months | 0 | 1
696 | 1900-07-25 00:00:00 | Peaches | Research | 1902-07-25 00:00:02 | Incident - Type A | 27 Months | 0 | 1
592 | 1900-07-26 00:00:00 | Apples | Development | 1902-07-26 00:00:02 | Incident - Type B | 28 Months | 1 | 0
739 | 1900-07-27 00:00:00 | Oranges | Sales | 1902-07-27 00:00:02 | Incident - Type B | 29 Months | 1 | 0
857 | 1900-07-28 00:00:00 | Oranges | Delivery | 1902-07-28 00:00:02 | Service - Type B | 30 Months | 1 | 0
616 | 1900-07-29 00:00:00 | Apples | Research | 1902-07-29 00:00:02 | Incident - Type B | 31 Months | 1 | 0
833 | 1900-07-30 00:00:00 | Oranges | Development | 1902-07-30 00:00:02 | Service - Type B | 32 Months | 1 | 0
724 | 1900-07-31 00:00:00 | Apples | Sales | 1902-07-31 00:00:02 | Incident - Type B | 33 Months | 0 | 1
586 | 1900-08-01 00:00:00 | Oranges | Delivery | 1902-08-01 00:00:02 | Service - Type B | 34 Months | 1 | 0
451 | 1900-08-02 00:00:00 | Grapes | Research | 1902-08-02 00:00:02 | Incident - Type A | 35 Months | 1 | 0
404 | 1900-08-03 00:00:00 | Grapes | Development | 1902-08-03 00:00:02 | Service - Type B | 36 Months | 1 | 0
442 | 1900-08-04 00:00:00 | Pears | Sales | 1902-08-04 00:00:02 | Incident - Type B | 37 Months | 1 | 0
864 | 1900-08-05 00:00:00 | Bannanas | Delivery | 1902-08-05 00:00:02 | Service - Type B | 38 Months | 1 | 0
876 | 1900-08-06 00:00:00 | Peaches | Research | 1902-08-06 00:00:02 | Incident - Type A | 39 Months | 1 | 0
584 | 1900-08-07 00:00:00 | Bannanas | Development | 1902-08-07 00:00:02 | Service - Type B | 40 Months | 0 | 1
996 | 1900-08-08 00:00:00 | Peaches | Sales | 1902-08-08 00:00:02 | Service - Type A | 41 Months | 0 | 1
528 | 1900-08-09 00:00:00 | Apples | Delivery | 1902-08-09 00:00:02 | Incident - Type B | 42 Months | 1 | 0
426 | 1900-08-10 00:00:00 | Oranges | Sales | 1902-08-10 00:00:02 | Service - Type B | 43 Months | 0 | 1
817 | 1900-08-11 00:00:00 | Oranges | Delivery | 1902-08-11 00:00:02 | Service - Type A | 44 Months | 1 | 0