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

 | COL HEADERS CLEANED UP |  |  |  |  |  |  | CUSTOMER |  |  |  | WORKSHOP
 | JOB # | MGR | ENG | CUSTOMER | PART NUMBER | [NAME] | QTY | PO DATE | DUE DATE | A | TO GO | A DATE | A DAYS | P DATE | R | [NAME] | D.O.T | ON T | % | 1 | 2 | 3 | CC | STATUS | IN-HOUSE | SUB-CON | P | NOTES
 | 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
 | 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
 | 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
 | 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
 | 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
 | 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
 | 12347 | HP | SC | ABC Ltd | ABC123456791 | Widget | 10 | 2021-01-01 00:00:00 | 2021-02-15 00:00:00
 | 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-03-20 00:00:00 |  |  |  |  |  |  | 2021-03-15 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
 | 12399 | HP | SC | ABC Ltd | [NAME] | Widget | 27
 | 12400 | HP | SC | ABC Ltd | ABC123456844 | Widget | 28
 | 12401 | HP | SC | ABC Ltd | ABC123456845 | Widget | 29
 | 12402 | HP | SC | ABC Ltd | ABC123456846 | Widget | 30
 | 12403 | HP | SC | ABC Ltd | ABC123456847 | Widget | 31
 | 12404 | HP | SC | ABC Ltd | ABC123456848 | Widget | 32
 | 12405 | HP | SC | ABC Ltd | ABC123456849 | Widget | 33
 | 12406 | HP | SC | ABC Ltd | ABC123456850 | Widget | 34
 | 12407 | HP | SC | ABC Ltd | ABC123456851 | Widget | 35
 | 12408 | HP | SC | ABC Ltd | ABC123456852 | Widget | 36
 | 12409 | HP | SC | ABC Ltd | ABC123456853 | Widget | 37
 | 12410 | HP | SC | ABC Ltd | ABC123456854 | Widget | 38
 | 12411 | HP | SC | ABC Ltd | ABC123456855 | Widget | 39
 | 12412 | HP | SC | ABC Ltd | ABC123456856 | Widget | 40
 | 12413 | HP | SC | ABC Ltd | ABC123456857 | Widget | 41
 | 12414 | HP | SC | ABC Ltd | ABC123456858 | Widget | 42
 | 12415 | HP | SC | ABC Ltd | ABC123456859 | Widget | 43
 | 12416 | HP | SC | ABC Ltd | ABC123456860 | Widget | 44
 | 12417 | HP | SC | ABC Ltd | ABC123456861 | Widget | 45
 | 12418 | HP | SC | ABC Ltd | ABC123456862 | Widget | 46
 | 12419 | HP | SC | ABC Ltd | ABC123456863 | Widget | 47
 | 12420 | HP | SC | ABC Ltd | ABC123456864 | Widget | 48
 | 12421 | HP | SC | ABC Ltd | ABC123456865 | Widget | 49
 | 12422 | HP | SC | ABC Ltd | ABC123456866 | Widget | 50
 | 12423 | HP | SC | ABC Ltd | ABC123456867 | Widget | 51
 | 12424 | HP | SC | ABC Ltd | ABC123456868 | Widget | 52
 | 12425 | HP | SC | ABC Ltd | ABC123456869 | Widget | 53
 | 12426 | HP | SC | ABC Ltd | ABC123456870 | Widget | 54
 | 12427 | HP | SC | ABC Ltd | ABC123456871 | Widget | 55
 | 12428 | HP | SC | ABC Ltd | ABC123456872 | Widget | 56
 | 12429 | HP | SC | ABC Ltd | ABC123456873 | Widget | 57
 | 12430 | HP | SC | ABC Ltd | ABC123456874 | Widget | 58
 | 12431 | HP | SC | ABC Ltd | ABC123456875 | Widget | 59
 | 12432 | HP | SC | ABC Ltd | ABC123456876 | Widget | 60
 | 12433 | HP | SC | ABC Ltd | ABC123456877 | Widget | 61
 | 12434 | HP | SC | ABC Ltd | ABC123456878 | Widget | 62