Spreadsheet: 74325d1274872056-how-to-work-out-percentages-from-specific-primary-secondary-items-in-lists-etc-copy-of-dummy-sheet
Sheet: Sheet1

Item Reference | Year Lodged | Department | Sub Group | Last Year Check | Category | Response | On Track? | Not On Track?
692 | 1900-07-01 00:00:00 | Apples | Research | 1902-07-01 00:00:02 | Service - TypeB | 4 Months | 1 | 0
730 | 1900-07-02 00:00:00 | Oranges | Development | 1902-07-02 00:00:02 | Incident - Type B | 4 Months | 0 | 1
671 | 1900-07-03 00:00:00 | Apples | Sales | 1902-07-03 00:00:02 | Incident - Type A | 5 Months | 1 | 0
529 | 1900-07-04 00:00:00 | Oranges | Delivery | 1902-07-04 00:00:02 | Service - Type A | 6 Months | 1 | 0
751 | 1900-07-05 00:00:00 | Grapes | Research | 1902-07-05 00:00:02 | Service - Type A | 7 Months | 1 | 0
847 | 1900-07-06 00:00:00 | Grapes | Development | 1902-07-06 00:00:02 | Incident - Type B | 8 Months | 1 | 0
626 | 1900-07-07 00:00:00 | Pears | Sales | 1902-07-07 00:00:02 | Incident - Type B | 9 Months | 1 | 0
839 | 1900-07-08 00:00:00 | Bannanas | Delivery | 1902-07-08 00:00:02 | Incident - Type B | 10 Months | 1 | 0
497 | 1900-07-09 00:00:00 | Peaches | Research | 1902-07-09 00:00:02 | Service - Type B | 11 Months | 1 | 0
710 | 1900-07-10 00:00:00 | Bannanas | Development | 1902-07-10 00:00:02 | Service - Type A | 12 Months | 0 | 1
928 | 1900-07-11 00:00:00 | Peaches | Sales | 1902-07-11 00:00:02 | Incident - Type B | 13 Months | 0 | 1
608 | 1900-07-12 00:00:00 | Apples | Delivery | 1902-07-12 00:00:02 | Incident - Type B | 14 Months | 0 | 1
991 | 1900-07-13 00:00:00 | Oranges | Research | 1902-07-13 00:00:02 | Incident - Type B | 15 Months | 1 | 0
689 | 1900-07-14 00:00:00 | Oranges | Development | 1902-07-14 00:00:02 | Incident - Type A | 16 Months | 0 | 1
877 | 1900-07-15 00:00:00 | Apples | Sales | 1902-07-15 00:00:02 | Incident - Type B | 17 Months | 0 | 1
895 | 1900-07-16 00:00:00 | Oranges | Delivery | 1902-07-16 00:00:02 | Service - Type A | 18 Months | 0 | 1
951 | 1900-07-17 00:00:00 | Apples | Research | 1902-07-17 00:00:02 | Service - Type B | 19 Months | 0 | 1
476 | 1900-07-18 00:00:00 | Oranges | Development | 1902-07-18 00:00:02 | Service - Type B | 20 Months | 1 | 0
579 | 1900-07-19 00:00:00 | Grapes | Sales | 1902-07-19 00:00:02 | Service - Type A | 21 Months | 0 | 1
651 | 1900-07-20 00:00:00 | Grapes | Delivery | 1902-07-20 00:00:02 | Service - Type B | 22 Months | 0 | 1
687 | 1900-07-21 00:00:00 | Pears | Research | 1902-07-21 00:00:02 | Service - Type A | 23 Months | 0 | 1
628 | 1900-07-22 00:00:00 | Bannanas | Development | 1902-07-22 00:00:02 | Service - Type B | 24 Months | 0 | 1
406 | 1900-07-23 00:00:00 | Peaches | Sales | 1902-07-23 00:00:02 | Incident - Type A | 25 Months | 1 | 0
588 | 1900-07-24 00:00:00 | Bannanas | Delivery | 1902-07-24 00:00:02 | Incident - Type B | 26 Months | 0 | 1
492 | 1900-07-25 00:00:00 | Peaches | Research | 1902-07-25 00:00:02 | Incident - Type A | 27 Months | 0 | 1
540 | 1900-07-26 00:00:00 | Apples | Development | 1902-07-26 00:00:02 | Incident - Type B | 28 Months | 1 | 0
823 | 1900-07-27 00:00:00 | Oranges | Sales | 1902-07-27 00:00:02 | Incident - Type B | 29 Months | 1 | 0
402 | 1900-07-28 00:00:00 | Oranges | Delivery | 1902-07-28 00:00:02 | Service - Type B | 30 Months | 1 | 0
501 | 1900-07-29 00:00:00 | Apples | Research | 1902-07-29 00:00:02 | Incident - Type B | 31 Months | 1 | 0
784 | 1900-07-30 00:00:00 | Oranges | Development | 1902-07-30 00:00:02 | Service - Type B | 32 Months | 1 | 0
849 | 1900-07-31 00:00:00 | Apples | Sales | 1902-07-31 00:00:02 | Incident - Type B | 33 Months | 0 | 1
407 | 1900-08-01 00:00:00 | Oranges | Delivery | 1902-08-01 00:00:02 | Service - Type B | 34 Months | 1 | 0
835 | 1900-08-02 00:00:00 | Grapes | Research | 1902-08-02 00:00:02 | Incident - Type A | 35 Months | 1 | 0
432 | 1900-08-03 00:00:00 | Grapes | Development | 1902-08-03 00:00:02 | Service - Type B | 36 Months | 1 | 0
794 | 1900-08-04 00:00:00 | Pears | Sales | 1902-08-04 00:00:02 | Incident - Type B | 37 Months | 1 | 0
404 | 1900-08-05 00:00:00 | Bannanas | Delivery | 1902-08-05 00:00:02 | Service - Type B | 38 Months | 1 | 0
504 | 1900-08-06 00:00:00 | Peaches | Research | 1902-08-06 00:00:02 | Incident - Type A | 39 Months | 1 | 0
678 | 1900-08-07 00:00:00 | Bannanas | Development | 1902-08-07 00:00:02 | Service - Type B | 40 Months | 0 | 1
782 | 1900-08-08 00:00:00 | Peaches | Sales | 1902-08-08 00:00:02 | Service - Type A | 41 Months | 0 | 1
920 | 1900-08-09 00:00:00 | Apples | Delivery | 1902-08-09 00:00:02 | Incident - Type B | 42 Months | 1 | 0
463 | 1900-08-10 00:00:00 | Oranges | Sales | 1902-08-10 00:00:02 | Service - Type B | 43 Months | 0 | 1
836 | 1900-08-11 00:00:00 | Oranges | Delivery | 1902-08-11 00:00:02 | Service - Type A | 44 Months | 1 | 0