Spreadsheet: 719642d1613746536-conditional-formatting-programming-performance-targets-etaf-pvt-
Sheet: Jobs

 |  |  |  |  |  |  |  | CUSTOMER |  |  |  | WORKSHOP |  |  |  |  |  |  |  | PERF | PERF | PERF
 | JOB |  |  |  |  |  |  | PO | DUE | DAYS | DAYS | ARRIVAL | DAYS | PLANNED | DAYS | DATE | ON TIME |  |  | Flag | Flag | Flag
 | # | MGR | ENG | CUSTOMER | PART NUMBER | [NAME] | QTY | DATE | DATE2 | A | TO GO | DATE3 | A4 | DATE5 | R | [NAME] | DAYS | Column6 | % | 50% | 70% | 90%
 | JOB | MGR | ENG | CUSTOMER | PART NUMBER | [NAME] | QTY | Cust PO Date | DUE | DAYSA | DAYS TG | WORKSHOP | DAYS A-WS | PLANNED | DAYS R | DATE COMP | OT DAYS | OT | OT % | PERF1 | Perf2 | Perf3
 | 12346 | HP | SC | ABC Ltd | ABC123456790 | Widget | 50 | 2021-01-05 00:00:00 | 2021-02-05 00:00:00 |  |  |  |  |  |  | 2021-01-09 00:00:00 |  |  |  |  |  |  |  | I’m sorry etaf, my explanation is rubbish.
 | 12347 | HP | SC | ABC Ltd | ABC123456791 | Widget | 10 | 2021-01-01 00:00:00 | 2021-01-21 00:00:00 |  |  |  |  |  |  | 2021-01-11 00:00:00
 | 12346 | HP | SC | ABC Ltd | ABC123456790 | Widget | 50 | 2021-01-01 00:00:00 | 2021-01-11 00:00:00 |  |  |  |  |  |  | 2021-01-10 00:00:00 |  |  |  |  |  |  |  | I was hoping not to have to use any manual inputs.
 | 12347 | HP | SC | ABC Ltd | ABC123456791 | Widget | 10 | 2021-01-01 00:00:00 | 2021-01-31 00:00:00 |  |  |  |  |  |  | 2021-01-21 00:00:00 |  |  |  |  |  |  |  | Jobs tab U, V, W were only to show my thought process and were to be deleted.
 | 12346 | HP | SC | ABC Ltd | ABC123456790 | Widget | 50 | 2021-01-01 00:00:00 | 2021-01-21 00:00:00 |  |  |  |  |  |  | 2021-01-16 00:00:00 |  |  |  |  |  |  |  | I was hoping the formulas in Results I4-K15 could;
 | 12347 | HP | SC | ABC Ltd | ABC123456791 | Widget | 10 | 2021-01-01 00:00:00 | 2021-01-21 00:00:00 |  |  |  |  |  |  | 2021-01-10 00:00:00 |  |  |  |  |  |  |  | Look at Jobs col I, and reference only those dates that match the month in Results H4-H15
 | 12346 | HP | SC | ABC Ltd | ABC123456790 | Widget | 50 | 2021-01-01 00:00:00 | 2021-01-18 00:00:00 |  |  |  |  |  |  | 2021-01-18 00:00:00 |  |  |  |  |  |  |  | Then look at the corresponding rows for that month in Jobs col T and count the % that match results I3, J3 and K3 respectfully. (50%, 70%, 90%).
 | 12347 | HP | SC | ABC Ltd | ABC123456791 | Widget | 10 | 2021-01-01 00:00:00 | 2021-02-15 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Then if you change, say, [NAME] to 30% then Results K8 would return 1 because of the 13% in Jobs T5, the only item that month below the 30%
 | 12344 | HP | SC | ABC Ltd | ABC123456788 | Widget | 100 | 2021-02-01 00:00:00 | 2021-02-21 00:00:00 |  |  |  |  |  |  | 2021-02-11 00:00:00
 | 12348 | HP | SC | ABC Ltd | [NAME] | Widget | 250 | 2021-02-05 00:00:00 | 2021-03-05 00:00:00 |  |  |  |  |  |  | 2021-02-17 00:00:00
 | 12345 | HP | SC | ABC Ltd | ABC123456789 | Widget | 2000 | 2021-02-09 00:00:00 | 2021-03-09 00:00:00 |  |  |  |  |  |  | 2021-02-18 00:00:00
 | 12349 | HP | SC | ABC Ltd | ABC123456793 | Widget | 3 | 2021-02-10 00:00:00 | 2021-03-10 00:00:00 |  |  |  |  |  |  | 2021-03-18 00:00:00
 | 12350 | HP | SC | ABC Ltd | ABC123456794 | Widget | 25 | 2021-02-15 00:00:00 | 2021-03-15 00:00:00 |  |  |  |  |  |  | 2021-03-12 00:00:00
 | 12351 | HP | SC | ABC Ltd | ABC123456795 | Widget | 71 | 2021-02-20 00:00:00 | 2021-03-20 00:00:00 |  |  |  |  |  |  | 2021-03-20 00:00:00
 | 12352 | HP | SC | ABC Ltd | ABC123456796 | Widget | 1 | 2021-02-25 00:00:00 | 2021-03-25 00:00:00 |  |  |  |  |  |  | 2021-04-21 00:00:00
 | 12353 | HP | SC | ABC Ltd | ABC123456797 | Widget | 1 | 2021-03-02 00:00:00 | 2021-03-30 00:00:00 |  |  |  |  |  |  | 2021-04-22 00:00:00
 | 12354 | HP | SC | ABC Ltd | ABC123456798 | Widget | 2 | 2021-03-07 00:00:00 | 2021-04-04 00:00:00
 | 12355 | HP | SC | ABC Ltd | ABC123456799 | Widget | 8 | 2021-03-12 00:00:00 | 2021-04-09 00:00:00 |  |  |  |  |  |  | 2021-04-24 00:00:00
 | 12356 | HP | SC | ABC Ltd | ABC123456800 | Widget | 20 | 2021-03-17 00:00:00 | 2021-04-14 00:00:00 |  |  |  |  |  |  | 2021-04-25 00:00:00
 | 12357 | HP | SC | ABC Ltd | ABC123456801 | Widget | 50 | 2021-03-22 00:00:00 | 2021-04-19 00:00:00 |  |  |  |  |  |  | 2021-04-15 00:00:00
 | 12358 | HP | SC | ABC Ltd | ABC123456802 | Widget | 100 | 2021-03-27 00:00:00 | 2021-04-24 00:00:00 |  |  |  |  |  |  | 2021-04-27 00:00:00
 | 12359 | HP | SC | ABC Ltd | ABC123456803 | Widget | 5 | 2021-04-01 00:00:00 | 2021-04-29 00:00:00 |  |  |  |  |  |  | 2021-04-28 00:00:00
 | 12360 | HP | SC | ABC Ltd | ABC123456804 | Widget | 5 | 2021-04-06 00:00:00 | 2021-05-04 00:00:00 |  |  |  |  |  |  | 2021-04-29 00:00:00
 | 12361 | HP | SC | ABC Ltd | ABC123456805 | Widget | 5 | 2021-04-11 00:00:00 | 2021-05-09 00:00:00 |  |  |  |  |  |  | 2021-05-15 00:00:00
 | 12362 | HP | SC | ABC Ltd | ABC123456806 | Widget | 5 | 2021-04-16 00:00:00 | 2021-05-14 00:00:00
 | 12363 | HP | SC | ABC Ltd | ABC123456807 | Widget | 5 | 2021-04-21 00:00:00 | 2021-05-19 00:00:00
 | 12364 | HP | SC | ABC Ltd | ABC123456808 | Widget | 5 | 2021-04-26 00:00:00 | 2021-05-24 00:00:00 |  |  |  |  |  |  | 2021-05-03 00:00:00
 | 12365 | HP | SC | ABC Ltd | ABC123456809 | Widget | 5 | 2021-05-01 00:00:00 | 2021-05-29 00:00:00 |  |  |  |  |  |  | 2021-05-04 00:00:00
 | 12366 | HP | SC | ABC Ltd | ABC123456810 | Widget | 5 | 2021-05-06 00:00:00 | 2021-06-03 00:00:00 |  |  |  |  |  |  | 2021-06-18 00:00:00
 | 12367 | HP | SC | ABC Ltd | ABC123456811 | Widget | 5 | 2021-05-11 00:00:00 | 2021-06-08 00:00:00 |  |  |  |  |  |  | 2021-07-20 00:00:00
 | 12368 | HP | SC | ABC Ltd | ABC123456812 | Widget | 5 | 2021-05-16 00:00:00 | 2021-06-13 00:00:00
 | 12369 | HP | SC | ABC Ltd | ABC123456813 | Widget | 5 | 2021-05-21 00:00:00 | 2021-06-18 00:00:00 |  |  |  |  |  |  | 2021-05-08 00:00:00
 | 12370 | HP | SC | ABC Ltd | ABC123456814 | Widget | 5 | 2021-05-26 00:00:00 | 2021-06-23 00:00:00 |  |  |  |  |  |  | 2021-05-09 00:00:00
 | 12371 | HP | SC | ABC Ltd | ABC123456815 | Widget | 5 | 2021-05-31 00:00:00 | 2021-06-28 00:00:00 |  |  |  |  |  |  | 2021-05-10 00:00:00
 | 12372 | HP | SC | ABC Ltd | ABC123456816 | Widget | 5 | 2021-06-05 00:00:00 | 2021-07-03 00:00:00
 | 12373 | HP | SC | ABC Ltd | ABC123456817 | Widget | 5 | 2021-06-10 00:00:00 | 2021-07-08 00:00:00 |  |  |  |  |  |  | 2021-07-15 00:00:00
 | 12374 | HP | SC | ABC Ltd | ABC123456818 | Widget | 5 | 2021-06-15 00:00:00 | 2021-07-13 00:00:00 |  |  |  |  |  |  | 2021-05-13 00:00:00
 | 12375 | HP | SC | ABC Ltd | ABC123456819 | Widget | 5 | 2021-06-20 00:00:00 | 2021-07-18 00:00:00 |  |  |  |  |  |  | 2021-07-20 00:00:00
 | 12376 | HP | SC | ABC Ltd | ABC123456820 | Widget | 5 | 2021-06-25 00:00:00 | 2021-07-23 00:00:00 |  |  |  |  |  |  | 2021-05-15 00:00:00
 | 12377 | HP | SC | ABC Ltd | ABC123456821 | Widget | 5 | 2021-06-30 00:00:00 | 2021-07-28 00:00:00 |  |  |  |  |  |  | 2021-06-30 00:00:00
 | 12378 | HP | SC | ABC Ltd | [NAME] | Widget | 6 | 2021-07-10 00:00:00 | 2021-08-10 00:00:00 |  |  |  |  |  |  | 2021-05-17 00:00:00
 | 12379 | HP | SC | ABC Ltd | ABC123456823 | Widget | 7 | 2021-07-20 00:00:00 | 2021-08-20 00:00:00 |  |  |  |  |  |  | 2021-08-21 00:00:00
 | 12380 | HP | SC | ABC Ltd | ABC123456824 | Widget | 8 | 2021-07-30 00:00:00 | 2021-08-30 00:00:00 |  |  |  |  |  |  | 2021-05-19 00:00:00
 | 12381 | HP | SC | ABC Ltd | ABC123456825 | Widget | 9 | 2021-08-09 00:00:00 | 2021-09-09 00:00:00 |  |  |  |  |  |  | 2021-10-15 00:00:00
 | 12382 | HP | SC | ABC Ltd | ABC123456826 | Widget | 10 | 2021-08-19 00:00:00 | 2021-09-19 00:00:00 |  |  |  |  |  |  | 2021-09-21 00:00:00
 | 12383 | HP | SC | ABC Ltd | ABC123456827 | Widget | 11 | 2021-08-29 00:00:00 | 2021-09-29 00:00:00 |  |  |  |  |  |  | 2021-05-22 00:00:00
 | 12384 | HP | SC | ABC Ltd | ABC123456828 | Widget | 12 | 2021-09-08 00:00:00 | 2021-10-09 00:00:00 |  |  |  |  |  |  | 2021-05-23 00:00:00
 | 12385 | HP | SC | ABC Ltd | ABC123456829 | Widget | 13 | 2021-09-18 00:00:00 | 2021-10-19 00:00:00 |  |  |  |  |  |  | 2021-05-24 00:00:00
 | 12386 | HP | SC | ABC Ltd | ABC123456830 | Widget | 14 | 2021-09-28 00:00:00 | 2021-10-29 00:00:00 |  |  |  |  |  |  | 2021-05-25 00:00:00
 | 12387 | HP | SC | ABC Ltd | ABC123456831 | Widget | 15 | 2021-10-08 00:00:00 | 2021-11-08 00:00:00 |  |  |  |  |  |  | 2021-05-26 00:00:00
 | 12388 | HP | SC | ABC Ltd | ABC123456832 | Widget | 16 | 2021-10-18 00:00:00 | 2021-11-18 00:00:00 |  |  |  |  |  |  | 2021-05-27 00:00:00
 | 12388 | HP | SC | ABC Ltd | ABC123456832 | Widget | 16 | 2021-10-18 00:00:00 | 2021-11-18 00:00:00 |  |  |  |  |  |  | 2021-10-18 00:00:00
 | 12389 | HP | SC | ABC Ltd | ABC123456833 | Widget | 17 | 2021-10-28 00:00:00 | 2021-11-28 00:00:00 |  |  |  |  |  |  | 2021-12-05 00:00:00
 | 12390 | HP | SC | ABC Ltd | ABC123456834 | Widget | 18 | 2021-11-07 00:00:00 | 2021-12-08 00:00:00 |  |  |  |  |  |  | 2021-11-10 00:00:00
 | 12391 | HP | SC | ABC Ltd | ABC123456835 | Widget | 19 | 2021-11-17 00:00:00 | 2021-12-18 00:00:00 |  |  |  |  |  |  | 2021-12-20 00:00:00
 | 12392 | HP | SC | ABC Ltd | ABC123456836 | Widget | 20 | 2021-11-27 00:00:00 | 2021-12-28 00:00:00 |  |  |  |  |  |  | 2022-01-20 00:00:00
 | 12393 | HP | SC | ABC Ltd | ABC123456837 | Widget | 21 | 2021-12-01 00:00:00 | 2021-12-21 00:00:00 |  |  |  |  |  |  | 2021-12-16 00:00:00
 | 12394 | HP | SC | ABC Ltd | ABC123456838 | Widget | 22 | 2021-12-01 00:00:00 | 2021-12-21 00:00:00 |  |  |  |  |  |  | 2021-12-11 00:00:00
 | 12395 | HP | SC | ABC Ltd | ABC123456839 | Widget | 23 | 2021-12-01 00:00:00 | 2021-12-21 00:00:00 |  |  |  |  |  |  | 2022-01-10 00:00:00
 | 12396 | HP | SC | ABC Ltd | ABC123456840 | Widget | 24 | 2021-12-01 00:00:00 | 2021-12-21 00:00:00 |  |  |  |  |  |  | 2021-12-21 00:00:00
 | 12397 | HP | SC | ABC Ltd | ABC123456841 | Widget | 25 | 2021-12-01 00:00:00 | 2021-12-21 00:00:00 |  |  |  |  |  |  | 2021-12-22 00:00:00
 | 12398 | HP | SC | ABC Ltd | ABC123456842 | Widget | 26 | 2021-12-01 00:00:00 | 2021-12-21 00:00:00 |  |  |  |  |  |  | 2021-12-23 00:00:00
 | 12399 | HP | SC | ABC Ltd | [NAME] | Widget | 27 | 2021-12-01 00:00:00 | 2021-12-21 00:00:00 |  |  |  |  |  |  | 2021-12-24 00:00:00
 | 12400 | HP | SC | ABC Ltd | ABC123456844 | Widget | 28 | 2021-12-01 00:00:00 | 2021-12-21 00:00:00 |  |  |  |  |  |  | 2021-12-25 00:00:00
 | 12401 | HP | SC | ABC Ltd | ABC123456845 | Widget | 29 | 2021-12-01 00:00:00 | 2021-12-21 00:00:00 |  |  |  |  |  |  | 2021-12-26 00:00:00
 | 12402 | HP | SC | ABC Ltd | ABC123456846 | Widget | 30 | 2021-12-01 00:00:00 | 2021-12-21 00:00:00 |  |  |  |  |  |  | 2021-12-27 00:00:00
 | 12403 | HP | SC | ABC Ltd | ABC123456847 | Widget | 31 | 2021-12-01 00:00:00 | 2021-12-21 00:00:00 |  |  |  |  |  |  | 2021-12-28 00:00:00
 | ETAF | HP | SC | ABC Ltd | ABC123456790 | Widget | 50 | 2022-01-05 00:00:00 | 2022-02-05 00:00:00 |  |  |  |  |  |  | 2022-01-09 00:00:00
 | ETAF | HP | SC | ABC Ltd | ABC123456791 | Widget | 10 | 2022-01-01 00:00:00 | 2022-01-21 00:00:00 |  |  |  |  |  |  | 2022-01-11 00:00:00
 | ETAF | HP | SC | ABC Ltd | ABC123456790 | Widget | 50 | 2022-01-01 00:00:00 | 2022-01-11 00:00:00 |  |  |  |  |  |  | 2022-01-14 00:00:00
 | ETAF | HP | SC | ABC Ltd | ABC123456791 | Widget | 10 | 2022-01-01 00:00:00 | 2022-01-31 00:00:00 |  |  |  |  |  |  | 2022-01-21 00:00:00
 | ETAF | HP | SC | ABC Ltd | ABC123456790 | Widget | 50 | 2022-01-01 00:00:00 | 2022-01-21 00:00:00 |  |  |  |  |  |  | 2022-01-28 00:00:00
 | ETAF | HP | SC | ABC Ltd | ABC123456791 | Widget | 10 | 2022-01-01 00:00:00 | 2022-01-21 00:00:00 |  |  |  |  |  |  | 2022-01-10 00:00:00
 | ETAF | HP | SC | ABC Ltd | ABC123456790 | Widget | 50 | 2022-01-01 00:00:00 | 2022-01-18 00:00:00 |  |  |  |  |  |  | 2022-01-18 00:00:00
 | ETAF | HP | SC | ABC Ltd | ABC123456791 | Widget | 10 | 2022-01-01 00:00:00 | 2022-02-15 00:00:00
 | etaf | hp | sc