Spreadsheet: 889025d1739693789-to-count-the-number-of-vehicles-fleet-performance-report-jan-2025
Sheet: RAW DATA 2025

Month | Org_unit | Veh No | Cost Code | Org_unit - Dept. | Veh_Type | KM | Idle hours | Fuel | Maintenance
2025-01-01 00:00:00 | Supply Chain | 248099 |  | SCM - New Warehouse 905 |  | 2456.817 | 1 day, 3:38:59.704000 | 434.02 | 321
2025-01-01 00:00:00 | HO & Admin | 389817 |  | [NAME] |  | 1243.93 | 10:34:33 | 345.34 | 0
2025-01-01 00:00:00 | Retail | 142902 |  | RET - Mega Mart MOQ |  | 7958.99 | 2 days, 14:25:37 | 3043.85 | 3051
2025-01-01 00:00:00 | Commerce | 823743 |  | Commerce - Pharmacy |  | 2211.75 | 1 day, 7:21:17 | 416.36 | 86
2025-01-01 00:00:00 | Commerce | 252122 |  | Commerce - Pharmacy |  | 3795.140000000001 | 2 days, 12:42:00 | 1225.44 | 160
2025-01-01 00:00:00 | Commerce | 806858 |  | Commerce - Wholesale Foodstuff |  | 1897.67 | 20:54:34 | 310.84 | 0
2025-01-01 00:00:00 | Commerce | 317154 |  | Commerce - Wholesale Foodstuff |  | 3395.87 | 2 days, 22:42:49 | 1173.8 | 110
2025-01-01 00:00:00 | Commerce | 772209 |  | Commerce - Wholesale Foodstuff |  | 2937.380000000001 | 22:59:41 | 465.72 | 120
2025-01-01 00:00:00 | Commerce | 772214 |  | Commerce - Wholesale Foodstuff |  | 2562.9 | 1 day, 12:30:45 | 528.44 | 95
2025-01-01 00:00:00 | Commerce | 590381 |  | Commerce - Wholesale Foodstuff |  | 1168.82 | 10:58:36 | 240.14 | 0
2025-01-01 00:00:00 | Commerce | 590392 |  | Commerce - Wholesale Foodstuff |  | 2435.25 | 1 day, 2:47:49 | 393.36 | 40
2025-01-01 00:00:00 | Commerce | 302527 |  | Commerce - Wholesale Foodstuff |  | 339.8100000000001 | 2:28:37 | 1097.79 | 11112
2025-01-01 00:00:00 | Commerce | 272681 |  | Commerce - Wholesale Foodstuff |  | 3171.17 | 2 days, 0:02:08 | 843.53 | 95
2025-01-01 00:00:00 | Commerce | 725604 |  | Commerce - Wholesale Foodstuff |  | 3489.95 | 1 day, 12:35:35 | 703.14 | 7038
2025-01-01 00:00:00 | Commerce | 798455 |  | Commerce - Wholesale Foodstuff |  | 1948.46 | 17:14:20 | 401.89 | 0
2025-01-01 00:00:00 | Commerce | 725605 |  | Commerce - Wholesale Foodstuff |  | 2755.69 | 1 day, 16:11:32 | 456.5599999999999 | 580
2025-01-01 00:00:00 | Commerce | 240325 |  | Commerce - Wholesale Foodstuff |  | 2854.510000000001 | 3 days, 8:08:12 | 876.44 | 95
2025-01-01 00:00:00 | Commerce | 836624 |  | Commerce - Wholesale Foodstuff |  | 3126.98 | 1 day, 6:19:33 | 428.1 | 95
2025-01-01 00:00:00 | Commerce | 511765 |  | Commerce - Wholesale Foodstuff |  | 2542.87 | 15:38:31 | 361.92 | 145
2025-01-01 00:00:00 | Commerce | 511773 |  | Commerce - Wholesale Foodstuff |  | 1013.75 | 9:40:49 | 153.86 | 460
2025-01-01 00:00:00 | Commerce | 547915 |  | Commerce - Wholesale Foodstuff |  | 3903.65 | 19:37:13 | 630.1300000000001 | 0
2025-01-01 00:00:00 | Commerce | 548781 |  | Commerce - Wholesale Foodstuff |  | 3351.6 | 22:14:33 | 544.6899999999999 | 0
2025-01-01 00:00:00 | Commerce | 787104 |  | Commerce - Wholesale Foodstuff |  | 1852.259999999999 | 14:10:38 | 346.71 | 50
2025-01-01 00:00:00 | Commerce | 580236 |  | Commerce - Wholesale Foodstuff |  | 1981.06 | 13:15:26 | 312.26 | 0
2025-01-01 00:00:00 | Commerce | 580237 |  | Commerce - Wholesale Foodstuff |  | 2169.72 | 1 day, 3:26:25 | 461.37 | 515
2025-01-01 00:00:00 | Commerce | 580238 |  | Commerce - Wholesale Foodstuff |  | 3454.52 | 1 day, 7:29:28 | 486.0400000000001 | 6865
2025-01-01 00:00:00 | Commerce | 580239 |  | Commerce - Wholesale Foodstuff |  | 1927.67 | 20:28:58 | 363.62 | 135
2025-01-01 00:00:00 | Commerce | 231883 |  | Commerce - Wholesale Foodstuff |  | 3145.78 | 16:05:47 | 438.74 | 1825
2025-01-01 00:00:00 | Commerce | 100187 |  | Commerce - Wholesale Foodstuff |  | 2968.55 | 2 days, 3:15:00 | 839.9000000000001 | 145
2025-01-01 00:00:00 | Commerce | 705719 |  | Commerce - Wholesale Foodstuff |  | 517.52 | 4:21:59 | 145.91 | 0
2025-01-01 00:00:00 | HO & Admin | 774651 |  | Human Resources |  | 752.6600000000002 | 5:15:09 | 82.36 | 50
2025-01-01 00:00:00 | HO & Admin | 103493 |  | GM's Office |  | 440.6199999999999 | 5:15:22 | 106.76 | 2310
2025-01-01 00:00:00 | Supply Chain | 237098 |  | SCM - New Warehouse 905 |  | 1486.75 | 11:27:08 | 409.39 | 0
2025-01-01 00:00:00 | HO & Admin | 772183 |  | Human Resources |  | 2315.73 | 1 day, 4:34:44 | 691.1500000000001 | 425
2025-01-01 00:00:00 | HO & Admin | 774637 |  | [NAME] |  | 970.0199999999999 | 10:50:09 | 242.52 | 195
2025-01-01 00:00:00 | Retail | 675947 |  | RET - Management Corporate |  | 1530.49 | 8:38:59 | 317.12 | 175
2025-01-01 00:00:00 | Retail | 54273 |  | RET - Mega Mart 01 Mall |  | 1014.57 | 1 day, 17:55:34 | 466.82 | 537
2025-01-01 00:00:00 | Retail | 263547 |  | RET - Mega Mart 01 Mall |  | 3457.410000000001 | 1 day, 18:29:05 | 1600.3 | 4825
2025-01-01 00:00:00 | Retail | 72047 |  | RET - Mega Mart 01 Mall |  | 3473.97 | 1 day, 10:56:08 | 1237.54 | 740
2025-01-01 00:00:00 | Retail | 95422 |  | RET - Mega Mart Centre Mall |  | 2277.32 | 1 day, 21:28:46 | 933.17 | 0
2025-01-01 00:00:00 | Retail | 211722 |  | RET - Mega Mart Centre Mall |  | 2495.899 | 1 day, 18:14:59.389000 | 997.5399999999998 | 0
2025-01-01 00:00:00 | Retail | 15491 |  | RET - Mega Mart Centre Mall |  | 2301.159999999999 | 2 days, 23:21:15 | 1181.28 | 8690
2025-01-01 00:00:00 | Retail | 82512 |  | RET - Mega Mart Centre Mall |  | 580.83 | 6:35:56 | 611.67 | 5791
2025-01-01 00:00:00 | Retail | 176447 |  | RET - Mega Mart Gate Mall |  | 2423.82 | 2 days, 0:12:09 | 890.5400000000001 | 160
2025-01-01 00:00:00 | Retail | 317964 |  | RET - Mega Mart Gate Mall |  | 7371.146444444445 | 3 days, 15:22:35.315000 | 2344.24 | 3764
2025-01-01 00:00:00 | Retail | 332753 |  | RET - Mega Mart Lussail |  | 3015.31 | 2 days, 10:02:42 | 1140.08 | 0
2025-01-01 00:00:00 | Retail | 317966 |  | RET - Mega Mart Q Mall & Xpress |  | 8952.160000000002 | 3 days, 5:01:17 | 2389.99 | 6486
2025-01-01 00:00:00 | Retail | 38184 |  | RET - Mega Mart Xpress |  | 3450.36 | 2 days, 2:17:50 | 1220.42 | 0
2025-01-01 00:00:00 | Retail | 86841 |  | RET - Mega Mart Xpress |  | 0 | 0:00:00 | 0 | 0
2025-01-01 00:00:00 | Retail | 774648 |  | RET - Procurement |  | 1676.36 | 14:30:10 | 408.79 | 399
2025-01-01 00:00:00 | Retail | 54210 |  | RET - Shop Rite Ummsaeed |  | 10259.7 | 1 day, 8:41:07 | 3017.180000000001 | 680
2025-01-01 00:00:00 | Retail | 323643 |  | RET - Shop Rite Ummsaeed |  | 4785.240000000002 | 1 day, 1:15:04 | 1697.1 | 1861
2025-01-01 00:00:00 | Retail | 101971 |  | RET - Shoprite Airport Road |  | 3197.23 | 1 day, 17:43:57 | 937.6999999999999 | 2913
2025-01-01 00:00:00 | Retail | 159209 |  | RET - Shoprite Airport Road |  | 1805.128333333333 | 1 day, 12:11:17.370000 | 606.25 | 1175
2025-01-01 00:00:00 | Retail | 208366 |  | RET - Shoprite Airport Road |  | 1778.85 | 20:28:14 | 553.3 | 80
2025-01-01 00:00:00 | Retail | 176448 |  | RET - Mega Mart MOQ |  | 2993.744666666666 | 1 day, 7:36:48.704000 | 1360.19 | 7342
2025-01-01 00:00:00 | Supply Chain | 143438 |  | SCM - New Warehouse 905 |  | 3937.29 | 1 day, 15:25:17 | 1459.87 | 2755
2025-01-01 00:00:00 | Retail | 216851 |  | RET - Mega Mart Barwa |  | 2487.57 | 2 days, 7:22:17 | 938.1899999999999 | 3064
2025-01-01 00:00:00 | Retail | 290163 |  | RET - Mega Mart Barwa |  | 6791.239999999999 | 3 days, 3:40:27 | 3136.44 | 295
2025-01-01 00:00:00 | Supply Chain | 185450 |  | SCM - New Warehouse 905 |  | 1887.99 | 1 day, 9:55:12 | 1461.99 | 13462
2025-01-01 00:00:00 | Supply Chain | 311640 |  | SCM - New Warehouse 905 |  | 2372.05 | 2 days, 13:43:30 | 1966.09 | 430
2025-01-01 00:00:00 | Supply Chain | 221314 |  | SCM - New Warehouse 905 |  | 2287.620000000001 | 3 days, 18:38:32 | 1322.79 | 150
2025-01-01 00:00:00 | Supply Chain | 216317 |  | SCM - New Warehouse 905 |  | 3401.65 | 3 days, 15:14:35 | 1177.54 | 190
2025-01-01 00:00:00 | Supply Chain | 237668 |  | SCM - New Warehouse 905 |  | 2735.04 | 1 day, 21:24:12 | 749.3399999999999 | 4528
2025-01-01 00:00:00 | Supply Chain | 148734 |  | SCM - New Warehouse 905 |  | 4055.940000000001 | 2 days, 13:58:41 | 1794.78 | 440
2025-01-01 00:00:00 | Supply Chain | 185449 |  | SCM - New Warehouse 905 |  | 1527.67 | 20:49:13 | 557.58 | 140
2025-01-01 00:00:00 | Supply Chain | 103408 |  | SCM - New Warehouse 905 |  | 2351.81 | 1 day, 2:07:28 | 2504.71 | 0
2025-01-01 00:00:00 | Supply Chain | 20178 |  | SCM - New Warehouse 905 |  | 2213.61 | 4 days, 22:23:25 | 1349.37 | 1370
2025-01-01 00:00:00 | Supply Chain | 63152 |  | SCM - New Warehouse 905 |  | 2663.17 | 2 days, 15:46:10 | 975.2499999999998 | 50
2025-01-01 00:00:00 | Commerce | 256613 |  | Commerce - Wholesale Foodstuff |  | 1746.05 | 1 day, 0:02:37 | 539.26 | 0
2025-01-01 00:00:00 | Supply Chain | 151050 |  | SCM - New Warehouse 905 |  | 3228.49 | 23:32:44 | 2049.98 | 340
2025-01-01 00:00:00 | Supply Chain | 193526 |  | SCM - Old Warehouse 901 |  | 2457.99 | 21:40:30 | 2460.49 | 410
2025-01-01 00:00:00 | Supply Chain | 113522 |  | SCM - New Warehouse 905 |  | 2480.88 | 1 day, 9:47:17 | 1494.19 | 3433
2025-01-01 00:00:00 | Supply Chain | 281459 |  | SCM - Old Warehouse 901 |  | 3330.530000000001 | 1 day, 23:32:00 | 984.72 | 3654
2025-01-01 00:00:00 | Supply Chain | 224272 |  | SCM - New Warehouse 905 |  | 415.04 | 1 day, 7:29:33 | 219.25 | 1765
2025-01-01 00:00:00 | Supply Chain | 140709 |  | SCM - New Warehouse 905 |  | 1990.2 | 1 day, 4:39:24 | 1967.45 | 0
2025-01-01 00:00:00 | Supply Chain | 216318 |  | SCM - Old Warehouse 901 |  | 2826.55 | 1 day, 3:47:52 | 2315.74 | 1513
2025-01-01 00:00:00 | Supply Chain | 238530 |  | SCM - New Warehouse 905 |  | 3963.459999999999 | 5 days, 1:06:01 | 1835.4 | 0
2025-01-01 00:00:00 | Supply Chain | 291983 |  | SCM - Old Warehouse 901 |  | 2276.59 | 22:51:55 | 807.91 | 391
2025-01-01 00:00:00 | Supply Chain | 291984 |  | SCM - New Warehouse 905 |  | 2197.24 | 1 day, 23:50:01 | 1034.4 | 2658
2025-01-01 00:00:00 | Commerce | 99847 |  | Commerce - Wholesale Foodstuff |  | 2861.44 | 4 days, 18:47:05 | 1026.7 | 0
2025-01-01 00:00:00 | Supply Chain | 124158 |  | SCM - St # 3 Warehouse |  | 3855.150000000001 | 5 days, 3:26:30 | 1563.28 | 100
2025-01-01 00:00:00 | Supply Chain | 236783 |  | SCM - St # 3 Warehouse |  | 3527.62 | 2 days, 15:54:37 | 2498.62 | 475
2025-01-01 00:00:00 | Supply Chain | 72012 |  | SCM - New Warehouse 905 |  | 3397.81 | 3 days, 1:48:01 | 1558.46 | 1205
2025-01-01 00:00:00 | Supply Chain | 81320 |  | SCM - New Warehouse 905 |  | 2337.090000000001 | 1 day, 0:53:03 | 1015.43 | 1495
2025-01-01 00:00:00 | Supply Chain | 125367 |  | SCM - New Warehouse 905 |  | 3692.48 | 3 days, 14:41:12 | 1461.85 | 1053
2025-01-01 00:00:00 | Supply Chain | 13824 |  | SCM - New Warehouse 905 |  | 2132.11 | 1 day, 11:03:23 | 594.52 | 785
2025-01-01 00:00:00 | Supply Chain | 312276 |  | SCM - New Warehouse 905 |  | 5901.21 | 2 days, 22:22:05 | 1821.92 | 160
2025-01-01 00:00:00 | HO & Admin | 185626 |  | HEAD OFFICE |  | 1488.44 | 22:48:21 | 1031.71 | 150
2025-01-01 00:00:00 | Retail | 151208 |  | RET - Mega Mart Pearl |  | 4195.820000000001 | 1 day, 14:33:59 | 1052.55 | 1166
2025-01-01 00:00:00 | Commerce | 957853 |  | Commerce - Wholesale Foodstuff |  | 3891.87 | 2 days, 11:10:46 | 671.7500000000001 | 0
2025-01-01 00:00:00 | Commerce | 957854 |  | Commerce - Wholesale Foodstuff |  | 2995.439999999999 | 1 day, 1:47:39 | 524.81 | 0
2025-01-01 00:00:00 | Commerce | 207653 |  | Commerce - Wholesale Foodstuff |  | 0 | 0:00:00 | 0 | 0
2025-01-01 00:00:00 | Commerce | 207654 |  | Commerce - Wholesale Foodstuff |  | 0 | 0:00:00 | 81.69 | 0
2025-01-01 00:00:00 | Commerce | 220709 |  | Commerce - Wholesale Foodstuff |  | 0 | 0:00:00 | 114 | 0
2025-01-01 00:00:00 | Commerce | 220383 |  | Commerce - Wholesale Foodstuff |  | 0 | 0:00:00 | 67.55 | 0