Spreadsheet: 838027d1690629869-office-365-return-last-entered-value-based-on-multiple-conditions-zpc-daily-oil-top-up-service-report-july-v2
Sheet: RAW DATA

DATE | VEH CATEGORY | FLEET NO (ID) | KM/HRS | TRANS TYPE | COMPONENT | OIL TYPE | TRANS VOL (LTRS) | COMMENTS
01.07.2023 | MILOTO | MT-25 | 51307 | TOPUP | ENGINE | 10W40 | 6 | TOP UP DUE TO LOW LEVEL
01.07.2023 | MILOTO | MT-87 | 986396 | TOPUP | ATF | WM11D | 4 | TOPPED UP AFTER CHANGING STEERING BOX
01.07.2023 | MILOTO | MT-40 | 1260966 | TOPUP | ATF | WM11D | 2 | TOPPED UP AFTER CHANGING ATF BROKEN PIPE
03.07.2023 | MILOTO | MT-41 | 10895186 | TOPUP | ATF | WM11D | 4 | TOPPED UP AFTER WORKING ON A LEAK FROM THE ATF PIPE
03.07.2023 | MILOTO | MT-31 | NA | TOPUP | ENGINE | 10W40 | 3 | TOP UP DUE TO LOW LEVEL
05.07.2023 | MILOTO | MT-56 | 988918 | TOPUP | ATF | WM11D | 3 | TOPPED UP AFTER CHANGING ATF BROKEN PIPE
05.07.2023 | MILOTO | MT-20 | 1425 | TOPUP | ENGINE | 10W40 | 5 | TOPPED UP AFTER TIGHTING A LOSE BOLTS
05.07.2023 | MILOTO | MT-50 | 1008365 | TOPUP | ENGINE | 10W40 | 6 | TOPPED DUE TO LOW LEVELS
05.06.2023 | MILOTO | MT-71 | 1011781 | TOPUP | ENGINE | 10W40 | 4 | TOP UP DUE TO LOW LEVEL
06.07.2023 | MILOTO | MT-74 | 835658 | TOPUP | ATF | WM11D | 2 | TOPPED UP AFTER TIGHTING A LOSE PIPE
06.07.2023 | MILOTO | MT-12 | 91713 | TOPUP | ENGINE | 10W40 | 8 | TOPPED UP AFTER CHANGING THE CREAKED TAPPET COVER
06.07.2023 | MILOTO | MT-46 | 1262014 | TOPUP | ENGINE | 10W40 | 5 | TOPPED DUE TO LOW LEVELS
06.07.2023 | MILOTO | MT-03 | 207400 | TOPUP | ENGINE | 10W40 | 9 | TOP UP DUE TO LOW LEVEL
06.07.2023 | MILOTO | MT-79 | 848251 | TOPUP | ENGINE | 10W40 | 7 | TOPPED DUE TO LOW LEVELS
06.07.2023 | MILOTO | MT-19 | NA | TOPUP | DEGREASER | WM PENN | 2 | WASHED ENGINE
06.07.2023 | MILOTO | [NAME] | 1061666 | TOPUP | DEGREASER | WM PENN | 2 | WASHED BRAKE SHOES
06.07.2023 | MILOTO | MT-53 | NA | TOPUP | ATF | WM11D | 5 | TOPPED UP AFTER REPLACING A BROKEN PIPE
06.07.2023 | MILOTO | MT-15 | 104768 | TOPUP | ENGINE | 10W40 | 8 | TOPPED DUE TO LOW LEVELS
06.07.2023 | MILOTO | MT-15 | 104768 | TOPUP | ATF | WM11D | 2
06.07.2023 | MILOTO | MT-14 | 8155 | TOPUP | ENGINE | 10W40 | 4 | TOPPED DUE TO LOW LEVELS
07.07.2023 | MILOTO | MT-04 | NA | TOPUP | DEGREASER | WM PENN | 5 | WASHED CYLINDER HEAD
07.07.2023 | MILOTO | MT-21 | 56114 | TOPUP | ENGINE | 10W40 | 8 | TOPPED UP DUE TO LOW LEVELS
08.07.2023 | MILOTO | MT-24 | 828878 | TOPUP | ENGINE | 10W40 | 4 | TOP UP DUE TO LOW LEVEL
08.07.2023 | MILOTO | MT-68 | 1062735 | TOPUP | ENGINE | 10W40 | 5 | TOP UP DUE TO LOW LEVEL
08.07.2023 | MILOTO | MT-12 | 4669 | TOPUP | ENGINE | 10W40 | 11 | TOPPED UP AFTER TIGHTING TAPPED COVER BOLTS
10.07.2023 | MILOTO | MT-03 | 207542 | TOPUP | ENGINE | 10W40 | 5 | TOPPED DUE TO LOW LEAVES
10.07.2023 | MILOTO | MT-72 | 1051158 | SERVICE | COOLANT | LL50 | 10 | REPLENISHED WITH COOLANT AFTER DRAINING WATER
10.07.2023 | MILOTO | MT-75 | 828180 | SERVICE | COOLANT | LL50 | 10 | REPLENISHED WITH COOLANT AFTER DRAINING WATER
10.07.2023 | MILOTO | MT-49 | NA | TOPUP | ENGINE | 10W40 | 3 | TOPPED DUE TO LOW LEVELS
10.07.2023 | MILOTO | MT-33 | 116538 | TOPUP | DEGREASER | WM PENN | 5 | WASHED OIL PAN
10.07.2023 | MILOTO | MT-35 | NA | TOPUP | ATF | WM11D | 2 | TOPPED UP AFTER CHANGING THE SEAL FROM CABIN JACK
10.07.2023 | MILOTO | MT-33 | 116538 | SERVICE | ENGINE | 10W40 | 45 | TOPPED UP AFTER CHANGING OIL PAN
11.07.2023 | MILOTO | MT-78 | 9113075 | TOPUP | COOLANT | LL50 | 5 | REPLENISHED WITH COOLANT AFTER DRAINING WATER
11.07.2023 | MILOTO | MT-78 | 9113075 | TOPUP | ATF | WM11D | 2 | TOPPED UP  AFTER REPLACING A LEAKING PIPE
11.07.2023 | MILOTO | MT-53 | 1001039 | TOPUP | ENGINE | 10W40 | 5 | TOPPED UP  DUE TO LOW LEVEL
11.07.2023 | MILOTO | MT-22 | 10011 | TOPUP | ENGINE | 10W40 | 6 | TOPPED UP  DUE TO LOW LEVEL
11.07.2023 | MILOTO | [NAME] | 1132077 | TOPUP | ENGINE | 10W40 | 10 | TOPPED  UP DUE TO LOW LEVEL
11.07.2023 | MILOTO | MT-68 | 1063457 | TOPUP | ATF | WM11D | 2 | TOPPED UP AFTER REPLACING A BROKEN PIPE
11.07.2023 | MILOTO | MT-15 | 105130 | SERVICE | [NAME] | 80W90 | 18 | TOPPED UP AFTER  CHANGING GEAR BOX
11.07.2023 | MILOTO | MT-15 | 105130 | TOPUP | DEGREASER | WM PENN | 6 | WASHED GEAR BOX
12.07.2023 | MILOTO | MT-01 | 1118182.1 | TOPUP | ATF | WM11D | 2 | TOPPED UP AFTER  WORKING ON A LEAKING ATF TANK
13.07.2023 | MILOTO | MT-04 | 156510 | TOPUP | DEGREASER | WM PENN | 7 | WASHED ENGINE
13.07.2023 | MILOTO | MT-05 | 1116519 | TOPUP | ENGINE | 10W40 | 5 | TOP UP DUE TO LOW LEVEL
13.07.2023 | MILOTO | MT-78 | 192032 | TOPUP | DEGREASER | WM PENN | 6 | WASHED ENGINE
13.07.2023 | MILOTO | MT-32 | 88257 | TOPUP | DEGREASER | WM PENN | 10 | WASHED DIFF
13.07.2023 | MILOTO | MT-80 | 825602 | TOPUP | ENGINE | 10W40 | 5 | TOP UP DUE TO LOW LEVEL
13.07.2023 | MILOTO | [NAME] | 798769.8 | TOPUP | ENGINE | 10W40 | 4 | TOP UP DUE TO LOW LEVEL
14.07.2023 | MILOTO | MT-89 | 1265450 | SERVICE | [NAME] | MC80W90 | 20 | REPLACED GEARBOX DUE TO ITS FAILURE TO ENGAGE GEARS
14.07.2023 | MILOTO | MT-32 | 188277 | SERVICE | ENGINE | 10W40 | 45 | REPLACED COMPONENT OILS AS PER WEARCHECK RESULTS
14.07.2023 | MILOTO | MT-32 | 188277 | SERVICE | RE_DIFF | 85W140 | 36 | REPLACED COMPONENT OILS AS PER WEARCHECK RESULTS
14.07.2023 | MILOTO | MT-32 | 188277 | SERVICE | [NAME] | 80W90 | 18 | REPLACED COMPONENT OILS AS PER WEARCHECK RESULTS
14.07.2023 | MILOTO | MT-06 | 1279582 | SERVICE | ENGINE | 10W40 | 40 | REPLACED INJECTOR SEALS & REPLACED ENG OIL DUE TO WEARCHECK RESLUTS
15.07.2023 | MILOTO | MT-38 | 1568724 | TOPUP | ENGINE | 10W40 | 6 | TOPPED UP DUE TO LOW LEVELS
15.07.2023 | MILOTO | MT-04 | 156510 | SERVICE | ENGINE | 10W40 | 45 | CHANGED ENGINE OIL AFTER OVERHAULING THE ENGINE
17.07.2023 | MILOTO | MT-12 | NP | TOPUP | ENGINE | 10W40 | 5 | TOPPED UP DUE TO LOW LEVELS
17.07.2023 | MILOTO | MT-01 | 1118292 | TOPUP | DEGREASER | WM PENN | 6 | WASHED ENGINE
17.07.2023 | MILOTO | MT-48 | 52501 | SERVICE | ENGINE | 10W40 | 20 | SERVICED TRUCK
17.07.2023 | MILOTO | MT-16 | 7984 | TOPUP | ENGINE | 10W40 | 8 | REPAIRED LEAKAGE OFF TAPPET COVER AND REPLACED WORNOUT ATF STEERING BOX SEAL.
17.07.2023 | MILOTO | MT-16 | 7984 | TOPUP | ATF | WM11D | 3 | REPAIRED LEAKAGE OFF TAPPET COVER AND REPLACED WORNOUT ATF STEERING BOX SEAL.
17.07.2023 | MILOTO | MT-21 | NP | TOPUP | ENGINE | 10W40 | 7 | TOPPED UP DUE TO LOW LEVELS
17.07.2023 | MILOTO | MT-15 | 105747 | TOPUP | ENGINE | 10W40 | 5 | TOPPED UP DUE TO LOW LEVELS
18.07.2023 | MILOTO | MT-30 |  | TOPUP | ATF | WM11D | 3 | TOPPED UP AFTER REPLACING THE STEERING PUMP
19.07.2023 | MILOTO | MT-47 | 1211470 | SERVICE | FR_DIFF | 85W140 | 48 | REPLACED DIFFERENTIAL OIL AS PER WEARCHECK RESULTS
19.07.2023 | MILOTO | MT-53 | 1002950 | TOPUP | DEGREASER | WM PENN | 9 | WASHED SPARE DIFF & STEERING BOX
19.07.2023 | MILOTO | MT-03 | 1031 | TOPUP | ENGINE | 10W40 | 15 | REPLACED WORNOUT DIPSTICK SEAL
19.07.2023 | MILOTO | MT-63 | NP | TOPUP | DEGREASER | WM PENN | 5 | WASHED HUBS
19.07.2023 | MILOTO | MT-22 | 11123 | TOPUP | ENGINE | 10W40 | 5 | TOPPED UP DUE TO LOW LEVELS
19.07.2023 | MILOTO | MT-09 | 1483048 | TOPUP | ATF | WM11D | 1 | TOPPED UP DUE TO LOW LEVELS
19.07.2023 | MILOTO | MT-89 | 1266089 | TOPUP | ENGINE | 10W40 | 6 | TOPPED UP DUE TO LOW LEVELS
19.07.2023 | MILOTO | MT-27 | 1197535 | SERVICE | COOLANT | LL50 | 10 | REPLENISHED COOLANT AFTER DRAINING WATER
19.07.2023 | MILOTO | MT-27 | 1197535 | TOPUP | [NAME] | MC80W90 | 2 | REPLACED GEARBOX COOLER PIPE
19.07.2023 | MILOTO | MT-63 | 1017015 | TOPUP | RE_DIFF | 85W140 | 7 | REPLACED WORNOUT HUB SEAL
20.07.2023 | MILOTO | MT-71 | 1014815 | TOPUP | ATF | WM11D | 1 | TOPPED DUE TO LOW LEAVES
20.07.2023 | MILOTO | MT-53 | 1002940 | SERVICE | ENGINE | 10W40 | 40 | REPLACED ENGINE OIL AS PER WEARCHECK RESULTS
20.07.2023 | MILOTO | MT-53 | 1002940 | SERVICE | FR_DIFF | 85W140 | 48 | REPLACED DIFFERENTIAL OIL AS PER WEARCHECK RESULTS
20.07.2023 | MILOTO | MT-20 | 14277512 | TOPUP | DEGREASER | WM PENN | 5 | WAHED ENGINE
20.07.2023 | MILOTO | MT-28 | 125594 | TOPUP | ATF | WM11D | 4 | TOPPED UP AFTER REPLACING STEERING PUMP
21.07.2023 | MILOTO | MT-20 | NP | TOPUP | ENGINE | 10W40 | 2 | TOPPED UP ENGINE OIL AFTER REPAIRS ON STEERING
21.07.2023 | MILOTO | MT-20 | NP | TOPUP | ATF | WM11D | 2 | TOPPED UP ENGINE OIL AFTER REPAIRS ON STEERING