Spreadsheet: 887282d1737518796-countif-function-prex
Sheet: Astron

Week | Date Reported | [NAME] | Jobs   Started | Site Name | Tech | Asst | Asst | Asst | Asst | Asst | Problem | Job     Card | Jobs | Date Completed | K/M      travelled | Labour Hours hm | Average hours on the road at an estimated 70km/h speed | Ave Completion Time | Hours per day
 | 2025-01-04 00:00:00 | 2025-01-04 00:00:00 | 2025-01-04 00:00:00 | AUTOFIT RICHIES | DOLF |  |  |  |  |  | CHECK I CON CONTROLER ALL GOOD, CHECK PUMPS ALL GOOD, CABLE FROM 1&2 TO 3&4 DAMAGED NEEDS TO BE REPLACED, REPLACE CABLE | 3432 | 1 | 2025-01-04 00:00:00 | 672 | 7
 | 2025-01-07 00:00:00 | 2025-01-07 00:00:00 | 2025-01-08 00:00:00 | YACOOBS | DOLF | THATO |  |  |  |  | [NAME], WORKING FINE | 3434 | 1 | 2025-01-08 00:00:00 | 498 | 1
 | 2025-01-07 00:00:00 | 2025-01-07 00:00:00 | 2025-01-08 00:00:00 | VAU | DOLF | THATO |  |  |  |  | PUMP 7/8 THE INTERFASE CARD IS BROKEN. RETAILER WILL REPLACE CARD WHEN JAUN FROM IPM WILL SEND IT. | 3435 | 1 | 2025-01-08 00:00:00 | 252 | 1
 | 2025-01-08 00:00:00 | 2025-01-08 00:00:00 | 2025-01-08 00:00:00 | MEGA MOTORS | DOLF |  |  |  |  |  | RESET ICON CONTROLER, RESET PUMPS, RESET POS SYSTEM | 3437 | 1 | 2025-01-08 00:00:00 | 304 | 1
 | 2025-01-08 00:00:00 | 2025-01-08 00:00:00 | 2025-01-09 00:00:00 | VAU EVANDER | GALELA |  |  |  |  |  | REPLACE A NOZZLE AND KEY PAD | 3467 | 1 | 2025-01-09 00:00:00 | 194 | 2
 | 2025-01-09 00:00:00 | 2025-01-09 00:00:00 | 2025-01-09 00:00:00 | BAPSFONTEIN | DOLF | THATO |  |  |  |  | CHECK PMA ALL GOOD, LONG LEAD OKAY, CAPS AND JOINTS ALL GOOD, DB BOARD ALL OKAY, VEEDER ROOT CABLE LOOSE IN TRUNKING, TIGHTEN CABLE ALL WORKING WELL | 3439 | 1 | 2025-01-09 00:00:00 | 500 | 3
 | 2025-01-08 00:00:00 | 2025-01-08 00:00:00 | 2025-01-10 00:00:00 | LEANDRA | ELVIS | TUMI |  |  |  |  | FIX LEAKING ROOF THREE AREAS WAS LEAKING TO THE INSIDE OF THE SHOP, STORE ROOM AND KIOSK. | 2999 | 1 | 2025-01-10 00:00:00 | 218 | 2
 | 2025-01-10 00:00:00 | 2025-01-10 00:00:00 | 2025-01-10 00:00:00 | AUTO FIT RICHIES | DOLF | THATO |  |  |  |  | BRAKER TO STP WAS TRIPPED, RESET AND ALL WORKING WELL. PUMP 3, REPLACE LEAKING HOSE. | 3440 | 1 | 2025-01-10 00:00:00 | 336 | 1
 | 2025-01-13 00:00:00 | 2025-01-13 00:00:00 | 2025-01-14 00:00:00 | BAPSFONTEIN | DOLF | CARLOS |  |  |  |  | REPLACE KEY SWITCH | 3445 | 1 | 2025-01-14 00:00:00 | 200 | 1
 | 2025-01-14 00:00:00 | 2025-01-14 00:00:00 | 2025-01-14 00:00:00 | VAU | DOLF | CARLOS |  |  |  |  | REPLACE A GLOBE, NOZZLE | 3444 | 1 | 2025-01-14 00:00:00 | 216 | 1
 | 2025-01-14 00:00:00 | 2025-01-14 00:00:00 | 2025-01-15 00:00:00 | AJ MOTORS | GALELA | XOLANI |  |  |  |  | PUMP 5: BORROW A SCREEN DISPLAY ON PUMP 10, | 3482 | 1 | 2025-01-15 00:00:00 | 140 | 2
 | 2025-01-15 00:00:00 | 2025-01-15 00:00:00 | 2025-01-15 00:00:00 | NIGEL | GALELA | XOLANI |  |  |  |  | PUMP [NAME]: HOOKED THE CLIP/PIN ON THE SHEAR VALVE THE NOZZLE ARE NOW DISPENSING. | 3483 | 1 | 2025-01-15 00:00:00 | 150 | 1
 | 2025-01-13 00:00:00 | 2025-01-13 00:00:00 | 2025-01-15 00:00:00 | [NAME] | GALELA |  |  |  |  |  | PUMP 2 ULP 93: DID MASTER RESET ON THE PUMP, PUMP 2 ULP93 IS NOW WORKING FINE | 3484 | 1 | 2025-01-15 00:00:00 | 182 | 1
 | 2025-01-15 00:00:00 | 2025-01-15 00:00:00 | 2025-01-16 00:00:00 | BALFOUR | GALELA | XOLANI |  |  |  |  | PUMP 6: REPLACE A FAULTY PC BOARD AND TAG LOOP CARD. PUMP 6 ULP95: REPLACE A LEAKING NOZZLE | 3486 | 1 | 2025-01-16 00:00:00 | 195 | 1
 | 2025-01-20 00:00:00 | 2025-01-20 00:00:00 | 2025-01-20 00:00:00 | VAU | DOLF | CARLOS |  |  |  |  | REPLACE A SCREEN ON PUMP 3 NEED ANOTHER SCREEN FOR PUMP 6 - DRESSER WAYNE | 3448 | 1 | 2025-01-20 00:00:00 | 252 | 1
 | 2025-01-17 00:00:00 | 2025-01-17 00:00:00 | 2025-01-20 00:00:00 | MINNAARS/DIPNORA | GALELA |  |  |  |  |  | PUMP 9: KEY PAD NOT WORKING, REPLACE A KEY PAD. PUMP 5: REPLACE 2 MODULE CARDS AND REWIRE THE CABLE CONNECTING TO THE PC BOARD | 3488 | 1 | 2025-01-20 00:00:00 | 140 | 2
 | 2025-01-20 00:00:00 | 2025-01-20 00:00:00 | 2025-01-20 00:00:00 | NIGEL | GALELA |  |  |  |  |  | PUMP 3 DIESEL: NOZZLE PULLED BY CUSTOMER. REPLACE THE NOZZLE AND A SWIVEL BRAKEAWAY. | 3489 | 1 | 2025-01-20 00:00:00 | 70 | 1