This report is a deep dive on vehicles of APCO giving actionable insights.
These 163 vehicles have been completely dead, and need to be taken off the asset list if they are not being used.
| Vehicle | Terminal ID | Last seen on | Days Since OFF | Last Fuel level |
|---|---|---|---|---|
| Dumper | ||||
| UP64T 1262_Dumper | 1134000367 | 2021-09-20 | 183 | 0.1 |
| D-1-829_Dumper_gkpr | 1079002040 | 2021-11-25 | 116 | 190.4 |
| UP25AT 5003_Dumper | 1134000318 | 2021-12-01 | 110 | 169.4 |
| D-1-802_Dumper_gkpr | 1079001999 | 2021-12-07 | 104 | 256.6 |
| UP42AT 9717_Dumper | 1079000922 | 2021-12-10 | 101 | 0.7 |
| UP32LN 9682_Dumper | 1134000405 | 2021-12-18 | 94 | 215.6 |
| UP32NN 5162_Dumper | 1079001251 | 2021-12-20 | 92 | 1.6 |
| UP32NN 0499_Dumper | 1079001464 | 2021-12-27 | 85 | 4.6 |
| UP32NN 5101_Dumper | 1079001235 | 2021-12-28 | 83 | 1.6 |
| UP32NN 5102_Dumper | 1079001245 | 2021-12-28 | 83 | 36.5 |
| D-1-822_Dumper_gkpr | 1079002008 | 2022-01-04 | 77 | 151.0 |
| UP32LN 9665_Dumper | 1134000282 | 2022-01-12 | 69 | 65.3 |
| UP42AT 9711_Dumper | 1134000346 | 2022-01-12 | 69 | 0.7 |
| UP25BT 0691_Dumper | 1134000368 | 2022-01-12 | 68 | 44.8 |
| UP25AT 8364_Dumper | 1134000369 | 2022-01-13 | 68 | 75.8 |
| UP25AT 8630_Dumper | 1134000371 | 2022-01-13 | 67 | 45.3 |
| UP32JN 8034_Dumper | 1134000375 | 2022-01-16 | 65 | 1.2 |
| UP25AT 5014_Dumper_gkpr | 1079001430 | 2022-01-17 | 63 | 208.3 |
| UP25AT 8626_Dumper | 1134000325 | 2022-01-18 | 63 | 125.6 |
| UP32NN 5097_Dumper | 1079001241 | 2022-01-25 | 56 | 121.5 |
| UP32MN 0605_Dumper | 1079000915 | 2022-01-26 | 54 | 249.3 |
| UP25AT 5001_Dumper | 1134000303 | 2022-01-27 | 53 | 82.1 |
| UP42BT 1138_Dumper_gkpr | 1079002512 | 2022-01-28 | 52 | 2.4 |
| UP25BT 0676_Dumper | 1134000376 | 2022-01-28 | 52 | 140.2 |
| UP32NN 5165_Dumper | 1079001236 | 2022-01-29 | 52 | 127.6 |
| UP32NN 5095_Dumper | 1079001248 | 2022-01-29 | 51 | 1.1 |
| UP32NN 3906_Dumper | 1079001098 | 2022-01-31 | 49 | 42.9 |
| UP32NN 5106_Dumper | 1079001238 | 2022-02-01 | 49 | 2.4 |
| UP32NN 5096_Dumper | 1079001256 | 2022-02-03 | 46 | 113.6 |
| UP32LN 9679_Dumper | 1134000281 | 2022-02-05 | 44 | 0.7 |
| UP32JN 7321_Dumper | 1079001454 | 2022-02-08 | 42 | 204.1 |
| UP32JN 7317_Dumper | 1079000276 | 2022-02-09 | 41 | 196.2 |
| UP25AT 8343_Dumper_gkpr | 1079001540 | 2022-02-14 | 35 | 103.4 |
| UP32LN 7519_Dumper | 1134000247 | 2022-02-18 | 31 | 164.6 |
| UP42BT 3767_Dumper | 1134000309 | 2022-02-23 | 26 | 0.7 |
| UP25AT-8627_Dumper | 1079001344 | 2022-02-26 | 23 | 0.7 |
| UP25AT 5008_Dumper_gkpr | 1079001496 | 2022-03-03 | 18 | 1.5 |
| D-1-674_Dumper_gkpr1 | 1079001165 | 2022-03-04 | 17 | 1.2 |
| Excavator | ||||
| B-1-013_Cat Excavator | 1134000123 | 2021-11-26 | 115 | 0.5 |
| B-1-009_Cat Excavator | 1134000414 | 2022-01-24 | 57 | 94.3 |
| B-1-051_Cat Excavator | 1134000118 | 2022-02-18 | 31 | 1.7 |
| Roller-Soil Compactor | ||||
| B-6-005_Roller | 1079000970 | 2021-11-30 | 111 | 7.7 |
| B-7-011_Tandem roller | 1134000415 | 2022-01-29 | 52 | 4.3 |
| Excavator123 | ||||
| B-1-061_Cat Excavator | 1079000200 | 2021-11-30 | 111 | 174.0 |
| Apco Aligarh Kanpur | ||||
| UP32GT 1481_Bolero | 1134000504 | 2021-12-03 | 108 | 2.0 |
| B-7-06_Tandem roller | 1079001022 | 2022-01-05 | 76 | 0.0 |
| B-4-016_Loader | 1079001029 | 2022-01-14 | 67 | 241.3 |
| UP25AT 8356_Dumper | 1134000480 | 2022-01-27 | 54 | 70.0 |
| B-6-013_Roller | 1134000499 | 2022-01-27 | 53 | 34.6 |
| B-1-008_Cat Excavator | 1079000999 | 2022-01-29 | 52 | 10.0 |
| B-1-004_Excavator | 1134000487 | 2022-01-31 | 50 | 95.3 |
| B-1-014_Cat Excavator | 1134000498 | 2022-02-05 | 44 | 0.5 |
| B-10-004_Paver | 1134000506 | 2022-02-08 | 41 | 0.2 |
| B-1-025_Cat Excavator | 1134000501 | 2022-02-12 | 37 | 194.4 |
| UP25BT 2204_Dumper | 1079001026 | 2022-02-17 | 33 | 0.1 |
| UP32MN 1027_Water Tanker | 1134000482 | 2022-02-19 | 30 | 233.3 |
| UP25AT 8639_Transit Mixer | 1134000481 | 2022-02-22 | 28 | 90.7 |
| B-4-058_Loader | 1134000326 | 2022-03-04 | 17 | 1.9 |
| Transit Mixer | ||||
| UP32MN 1966_Transit Mixer | 1134000426 | 2021-12-05 | 107 | 126.2 |
| UP32MN 1967_Transit Mixer | 1134000429 | 2021-12-07 | 104 | 2.6 |
| UP32LN 4501_Transit Mixer | 1134000387 | 2021-12-24 | 87 | 0.3 |
| UP42AT 8656_Transit Mixer | 1134000408 | 2021-12-30 | 82 | 75.1 |
| UP32MN 1965_Transit Mixer | 1134000439 | 2021-12-31 | 80 | 218.1 |
| UP42AT 8663_Transit Mixer | 1134000463 | 2022-01-24 | 57 | 7.1 |
| UP32LN 4513_Transit Mixer | 1079999831 | 2022-01-24 | 56 | 40.2 |
| UP42BT 3755_Transit Mixer | 1134000349 | 2022-02-01 | 49 | 0.1 |
| UP42AT 8662_Tranit Mixer_gkpr | 1079002513 | 2022-02-06 | 43 | 169.7 |
| UP42CT 0912_Transit Mixer | 1079002292 | 2022-02-12 | 38 | 1.5 |
| UP32LN 4514_Transit Mixer | 1079999830 | 2022-02-22 | 27 | 26.9 |
| UP32LN 4509_Transit Mixer | 1079000224 | 2022-02-25 | 24 | 0.7 |
| UP25BT 6127_Transit Mixer | 1134000342 | 2022-02-26 | 24 | 0.1 |
| UP32LN 4504_Transit Mixer | 1134000390 | 2022-02-26 | 23 | 1.1 |
| UP42BT 5953_Transit Mixer | 1134000329 | 2022-02-26 | 23 | 115.7 |
| UP32LN 4497_Transit Mixer | 1134000386 | 2022-02-28 | 22 | 35.5 |
| UP25BT 6129_Transit Mixer | 1079001106 | 2022-03-02 | 20 | 228.5 |
| UP42BT 3760_Transit Mixer | 1079001311 | 2022-03-03 | 19 | 221.6 |
| Dumpers | ||||
| UP32LN 4913_Dumper | 1134000120 | 2021-12-07 | 105 | 148.4 |
| UP25BT 2141_Dumper | 1079999277 | 2022-01-01 | 79 | 62.7 |
| UP42BT 1134_Dumper | 1079000274 | 2022-01-29 | 52 | 0.3 |
| UP25BT 2232_Dumper | 1079000301 | 2022-02-19 | 31 | 0.0 |
| Apco Gola Shahjahanpur | ||||
| B-4-006_Loader | 1079001508 | 2021-12-10 | 101 | 10.0 |
| UP42BT 5954_Water Tanker | 1079001330 | 2021-12-23 | 88 | 15.2 |
| B-5-009 | 1079001372 | 2021-12-24 | 88 | 4.5 |
| B-05-027_Grader | 1134000486 | 2021-12-27 | 85 | 0.7 |
| B-2-005_JCB Backhoe Loader | 1079001368 | 2022-01-06 | 75 | 6.9 |
| B-6-011_Roller | 1079001341 | 2022-01-08 | 72 | 3.6 |
| B-1-010_Excavator | 1079001345 | 2022-01-12 | 68 | 8.6 |
| B-5-050_Grader | 1079001361 | 2022-01-18 | 62 | 285.1 |
| B-1-006_Excavator | 1079001291 | 2022-02-06 | 44 | 230.4 |
| B-4-003_Loader | 1079001501 | 2022-02-06 | 43 | 171.6 |
| UP32DN-2625_Diesel Browser | 1079001343 | 2022-02-07 | 43 | 3.8 |
| UP25BT 2610_Dumper | 1079001287 | 2022-02-08 | 42 | 56.4 |
| B-13-004_Air Compressor | 1079001360 | 2022-02-14 | 36 | 33.4 |
| B-10-030_Paver | 1079001030 | 2022-02-14 | 35 | 1.0 |
| EXC 010_Volvo Excavator | 1079001366 | 2022-02-22 | 27 | 302.7 |
| B-5-004_Grader | 1079001370 | 2022-03-01 | 20 | 1.7 |
| Apco Bundelkhand Expressway | ||||
| UP25AT 6144_Dumper | 1134000485 | 2021-12-12 | 100 | 3.0 |
| UP25AT 8629_Dumper | 1079999835 | 2022-02-27 | 23 | 0.3 |
| Backhoe loader | ||||
| B2-011_CAT Backhoe loader | 1134000290 | 2021-12-13 | 99 | 1.0 |
| B-2-037_backhoe loader | 1134000373 | 2022-01-24 | 56 | 2.0 |
| Camper/Bolero | ||||
| UP32JL 4534_Bolero | 1134000156 | 2021-12-14 | 97 | 41.0 |
| UP42AP 6225_Bolero | 1134000144 | 2021-12-30 | 82 | 5.5 |
| UP32KN 0386_Camper | 1079000290 | 2022-01-09 | 71 | 0.1 |
| UP32JD 0866_Bolero | 1134000137 | 2022-01-22 | 58 | 4.0 |
| UP32JN 2165_Camper | 1134000141 | 2022-01-24 | 57 | 0.1 |
| UP32JD 0865_Bolero | 1134000157 | 2022-02-06 | 43 | 7.7 |
| Grader123 | ||||
| B5-008_CAT Grader | 1134000250 | 2021-12-16 | 96 | 227.1 |
| B-5-006_Cat Grader | 1079000067 | 2022-01-11 | 70 | 127.8 |
| B-5-010_Cat Grader | 1079000197 | 2022-01-13 | 68 | 136.7 |
| Trailer | ||||
| UP32MN 8143_Trailer | 1134000434 | 2021-12-18 | 93 | 304.9 |
| UP32LN 3847_Trailer | 1134000312 | 2022-02-02 | 48 | 0.3 |
| UP25AT 8637_Trailer | 1134000301 | 2022-02-03 | 46 | 5.3 |
| Apco-Delhi Vadodara Expressway1 | ||||
| C-2-034_Light Mast_Sh1 | 1079002128 | 2021-12-19 | 92 | 0.6 |
| B-13-019_Air Compressor_Sh1 | 1079001654 | 2021-12-22 | 90 | 29.3 |
| C-2-005_Light Mast_Sh1 | 1079001713 | 2022-01-04 | 77 | 6.8 |
| B-5-035_Grader_Sh1 | 1079001642 | 2022-01-22 | 59 | 2.5 |
| D-1-564_HR55AH 4198_Dumper_Sh1 | 1079001638 | 2022-01-22 | 59 | 124.0 |
| C-2-035_Light Mast_Sh1 | 1079001691 | 2022-02-19 | 30 | 4.4 |
| D-1-579_HR55AH 7055_Dumper_Sh1 | 1079001656 | 2022-02-22 | 27 | 3.0 |
| B-13-022_Air Compressor_Sh1 | 1079001655 | 2022-03-02 | 19 | 0.2 |
| Water Tanker | ||||
| UP42AT 8573_Water tanker | 1134000315 | 2021-12-20 | 91 | 340.2 |
| UP32MN 1028_Water Tanker | 1134000279 | 2022-01-09 | 72 | 79.0 |
| UP42BT 2818_Water Tanker | 1134000169 | 2022-02-13 | 37 | 0.1 |
| UP42BT 2552_Water Tanker | 1134000036 | 2022-02-22 | 28 | 0.2 |
| UP32LN 0451_Water Tanker | 1134000343 | 2022-02-28 | 22 | 69.6 |
| Camper | ||||
| UP42CT 0445_Camper_gkpr | 1079001523 | 2021-12-21 | 91 | 2.1 |
| UP32KN 7531_Camper | 1134000336 | 2022-02-22 | 28 | 0.1 |
| UP42CT 0644_Camper_gkpr | 1079001409 | 2022-02-23 | 26 | 24.6 |
| Bolero-Camper | ||||
| UP32MN 2044_Camper | 1134000456 | 2021-12-26 | 85 | 53.2 |
| UP42BB 2413_Bolero | 1079000925 | 2021-12-28 | 84 | 33.2 |
| UP42AT 8850_Camper | 1134000389 | 2022-01-02 | 78 | 0.1 |
| UP42AK 1710_Bolero | 1134000403 | 2022-01-25 | 56 | 27.7 |
| UP32MN 5316_Camper | 1134000294 | 2022-02-02 | 48 | 37.1 |
| Grader | ||||
| B-5-044_Cat Grader | 1079000212 | 2022-01-01 | 80 | 163.7 |
| B-5-012_Grader. | 1134000467 | 2022-01-06 | 74 | 17.2 |
| Light Mast-welder | ||||
| 20122_Light Mast | 1079000981 | 2022-01-01 | 79 | 0.4 |
| Dumper123 | ||||
| UP42BT 6285_Dumper | 1079000063 | 2022-01-08 | 73 | 3.1 |
| DG | ||||
| C-1-224_DG | 1079001552 | 2022-01-09 | 72 | 22.8 |
| C-1-006_125KVA DG | 1134000410 | 2022-01-17 | 64 | 156.5 |
| C-1-259_DG 40KVA_gkpr | 1079001438 | 2022-02-15 | 34 | 0.2 |
| C-1-257_DG 125KVA_gkpr | 1079001440 | 2022-02-17 | 32 | 192.8 |
| Bitumen Sprayer | ||||
| UP32MN 1023_Bitumen Sprayer | 1134000285 | 2022-01-10 | 71 | 66.1 |
| Water Tanker123 | ||||
| UP42AT 8430_Water Tanker | 1079000079 | 2022-01-14 | 67 | 1.3 |
| UP32LN 0431_Water Tanker | 1079000075 | 2022-01-20 | 61 | 136.5 |
| Delhi Vadodara Expressway Pkg2 | ||||
| C-2-024_Light Mast_Sh2 | 1079002410 | 2022-01-15 | 66 | 0.1 |
| B-12-004_Karb Paver_Sh2 | 1079001902 | 2022-02-07 | 43 | 6.0 |
| HR55AG 1378_Transit Mixer_Sh2 | 1079001827 | 2022-02-07 | 43 | 1.3 |
| B-5-018_Grader_Sh2 | 1079001876 | 2022-02-21 | 29 | 149.5 |
| B-6-018_Roller_Sh2 | 1079001863 | 2022-03-04 | 17 | 1.8 |
| Diesel Browser | ||||
| E426CDLF324288_Diesel Browser | 1079001101 | 2022-01-19 | 61 | 1.5 |
| Transit Mixers | ||||
| UP25BT 4376_Transit Mixer | 1134000104 | 2022-01-22 | 59 | 2.5 |
| UP25BT 7482_Transit Mixer | 1134000167 | 2022-02-18 | 31 | 0.1 |
| UP 25BT 8665_Transit Mixer.. | 1134000183 | 2022-02-26 | 23 | 0.1 |
| Asian Paints | ||||
| UP32BT 2628_Diesel Browser | 1134000232 | 2022-01-23 | 58 | 0.1 |
| B-05-042_CAT Grader | 1079000053 | 2022-01-26 | 55 | 109.0 |
| UP25BT 6135_Dumper | 1079999801 | 2022-02-26 | 24 | 26.2 |
| Roller | ||||
| B-8-003_PT Roller | 1134000089 | 2022-01-27 | 54 | 146.8 |
| Compressor | ||||
| 70743_Compressor | 1079001550 | 2022-01-30 | 51 | 1.7 |
| 70770_Air Compressor | 1079001558 | 2022-03-01 | 20 | 1.7 |
| Light Mast | ||||
| C-2-072_Light Mast_gkpr | 1079001448 | 2022-02-03 | 46 | 44.5 |
| Soil Compactor/Roller | ||||
| B6-024_Soil Compactor | 1134000264 | 2022-02-21 | 29 | 75.5 |
| Trailor | ||||
| UP 32CZ 5675_Trailer. | 1134000116 | 2022-02-24 | 25 | 23.9 |
| Transit Mixer123 | ||||
| UP25BT 6131_Transit Mixer | 1134000249 | 2022-03-04 | 17 | 223.2 |
These 20 vehicles have sent very few observations (less than 20) and are more likely to be last seen recently. These may be also not in use or heavily malfunctioning.
| Vehicle | Terminal ID | Last seen on | Days Since OFF | Last Fuel level |
|---|---|---|---|---|
| Dumper | ||||
| UP32NN 4578_Dumper_gkpr1 | 1079001156 | 2022-03-06 09:28:17 | 16 | 78.5 |
| UP25BT 6138_Dumper | 1134000441 | 2022-03-15 18:13:30 | 6 | 8.8 |
| UP42AT 8592_Dumper | 1134000263 | 2022-03-08 07:44:33 | 14 | 0.7 |
| UP32NN 3914_Dumper. | 1079002276 | 2022-03-16 23:23:56 | 5 | 1.6 |
| UP32LN 5061_Dumper | 1079999824 | 2022-03-12 11:03:27 | 10 | 0.3 |
| UP32LN 9661_Dumper | 1134000338 | 2022-03-17 14:45:05 | 4 | 0.3 |
| UP32NN 3922_Dumper | 1079001097 | 2022-03-13 12:38:25 | 9 | 1.1 |
| UP32LN 9668_Dumper | 1134000407 | 2022-03-10 17:22:39 | 11 | 0.3 |
| UP32LN 4907_Dumper | 1079999943 | 2022-03-12 14:14:36 | 9 | 3.0 |
| UP25BT 2175_Dumper | 1134000313 | 2022-03-16 18:14:59 | 5 | 0.0 |
| UP32NN 3905_Dumper | 1079001081 | 2022-02-28 14:55:10 | 21 | 168.8 |
| UP25AT 8702_Dumper | 1079999841 | 2022-03-16 19:14:49 | 5 | 0.3 |
| UP32JN 8039_Dumper | 1134000449 | 2022-03-15 04:48:43 | 7 | 0.3 |
| UP42AT 9715_Dumper | 1134000347 | 2022-03-14 10:05:57 | 8 | 3.8 |
| UP42AT 9006_Dumper | 1079999630 | 2022-03-16 15:19:57 | 5 | 0.3 |
| Grader | ||||
| B-5-034_Cat Grader | 1134000090 | 2022-03-09 14:05:56 | 12 | 0.1 |
| Excavator | ||||
| B-1-050_Cat Excavator | 1134000126 | 2022-03-19 17:02:18 | 2 | 0.5 |
| B-1-065_CAT Excavator | 1134000460 | 2022-03-12 21:27:35 | 9 | 2.9 |
| Transit Mixer | ||||
| UP25BT 6110_Transit Mixer | 1134000297 | 2022-03-06 15:59:47 | 15 | 0.2 |
| UP32MN 1962_Transit Mixer | 1134000425 | 2022-03-09 16:12:01 | 12 | 0.6 |
| UP42BT 3754_Transit Mixer | 1079999948 | 2022-03-06 02:06:54 | 16 | 67.8 |
| Bolero-Camper | ||||
| UP25AT 8163_Camper | 1134000333 | 2022-03-16 07:45:43 | 6 | 0.1 |
| UP32LN 9570_Camper | 1134000465 | 2022-03-15 18:38:33 | 6 | 10.1 |
| Concrete Pump123 | ||||
| UP25BT 6085_Schwing Concrete pump | 1079000209 | 2022-03-16 09:22:21 | 6 | 0.1 |
| Apco Gola Shahjahanpur | ||||
| UP42AT 9716_Dumper | 1134000339 | 2022-03-08 07:43:35 | 14 | 22.0 |
| UP42BT-7424_Service Van | 1079001347 | 2022-03-06 21:15:09 | 15 | 6.5 |
| Camper/Bolero | ||||
| UP32JB 6850_Bolero | 1134000150 | 2022-03-17 09:35:18 | 5 | 2.0 |
| UP42BT 0743_Camper | 1134000149 | 2022-03-16 08:57:06 | 6 | 0.1 |
| UP32KN 0251_Camper | 1134000164 | 2022-03-08 17:33:36 | 13 | 14.7 |
| UP32JN 1006_Camper | 1134000132 | 2022-03-14 15:56:03 | 7 | 0.1 |
| Concrete Pump/Boomplacer | ||||
| B-15-009_Concrete Mixer_gkpr | 1079001418 | 2022-03-09 18:38:18 | 12 | 2.7 |
| Loader | ||||
| B-02-022_JCB backhoe loader | 1134000037 | 2022-03-13 16:06:44 | 8 | 0.8 |
| Water Tanker | ||||
| UP42BT 2817_Water Tanker | 1134000019 | 2022-03-10 15:47:50 | 11 | 0.1 |
| Dumpers | ||||
| UP32LN 4914_Dumper | 1079000284 | 2022-03-14 11:09:21 | 8 | 1.5 |
| UP32LN 4910_Dumper | 1079000281 | 2022-03-06 03:13:24 | 16 | 0.3 |
| Trailer123 | ||||
| UP42AT 8438_Trailer | 1079999828 | 2022-03-17 16:40:27 | 4 | 0.2 |
| DG | ||||
| C-1-147_DG | 1134000355 | 2022-03-20 13:27:00 | 1 | 51.3 |
| C-1-157_DG | 1134000335 | 2022-03-17 14:47:43 | 4 | 170.3 |
| Delhi Vadodara Expressway Pkg2 | ||||
| HR55AJ 3897_Bitumen Tanker_Sh2 | 1079001814 | 2022-03-06 17:23:28 | 15 | 1.0 |
The following reports predict possible malfunctioning sensors that are sending data more often but in an erratic fashion. We deploy multiple algorithms to predict their malfunctioning.
The first algorithm tests each fuel sensor level against sudden drops. Following sensors show a yoyo effect on fuel levels, which means their fuel level plummets every few hours. These vehicles must be attended at the highest priority, as they would be giving a false sense of measurement, while theft can be easily hidden in the yoyo fuel levels.
| Possible Sensor Input Voltage Issue | ||||||||||
|---|---|---|---|---|---|---|---|---|---|---|
| Vehicle | termid | Number of Fuel Spikes |
Average Fuel Spike value (Lits.) |
Refuel | Drain | Maximum Time break |
Total break in fuel data | Observation Start |
Observation End |
Observation Days |
| Dumper | ||||||||||
| UP32JN 7314_Dumper. | 1079000237 | 9 | 23.0 | 99.8 | -106.9 | 343620s (~3.98 days) | 681336s (~1.13 weeks) | 2021-12-25 | 2022-03-18 | 81 |
| UP25BT 2220_Dumper | 1134000397 | 131 | 3.5 | 146.5 | -56.7 | 142488s (~1.65 days) | 962784s (~1.59 weeks) | 2022-03-02 | 2022-03-19 | 17 |
| UP32NN 5169_Dumper | 1079001247 | 337 | 13.8 | 154.3 | -151.9 | 130212s (~1.51 days) | 1073844s (~1.78 weeks) | 2022-03-02 | 2022-03-21 | 18 |
| UP25BT 6145_Dumper | 1134000440 | 71 | 5.0 | 103.4 | -41.4 | 355896s (~4.12 days) | 1224756s (~2.03 weeks) | 2022-03-05 | 2022-03-19 | 13 |
| UP32NN 3903_Dumper | 1079001095 | 271 | 9.4 | 143.9 | -138.2 | 140724s (~1.63 days) | 1120068s (~1.85 weeks) | 2022-03-05 | 2022-03-20 | 14 |
| UP32NN 3921_Dumper | 1079001085 | 131 | 17.6 | 119.7 | -146.5 | 284544s (~3.29 days) | 1198944s (~1.98 weeks) | 2022-03-05 | 2022-03-21 | 14 |
| UP32NN 5113_Dumper | 1079001252 | 351 | 14.0 | 186.6 | -172.4 | 143244s (~1.66 days) | 1172988s (~1.94 weeks) | 2022-03-05 | 2022-03-21 | 15 |
| UP32NN 4570_Dumper_gkpr1 | 1079001146 | 367 | 15.6 | 318.0 | -316.1 | 194868s (~2.26 days) | 1131408s (~1.87 weeks) | 2022-03-05 | 2022-03-21 | 14 |
| MH28BB 2018_Dumper_gkpr | 1235002233 | 267 | 8.3 | 121.2 | -179.6 | 186336s (~2.16 days) | 1179180s (~1.95 weeks) | 2022-03-05 | 2022-03-21 | 14 |
| UP32NN 0599_Dumper | 1079001466 | 165 | 5.9 | 180.8 | -179.6 | 356436s (~4.13 days) | 1180620s (~1.95 weeks) | 2022-03-05 | 2022-03-17 | 10 |
| UP32NN 3923_Dumper | 1079001080 | 377 | 14.8 | 167.8 | -150.3 | 129672s (~1.5 days) | 1081944s (~1.79 weeks) | 2022-03-05 | 2022-03-21 | 15 |
| UP32LN 5055_Dumper | 1079999988 | 91 | 8.0 | 111.1 | -158.0 | 345060s (~3.99 days) | 1220256s (~2.02 weeks) | 2022-03-05 | 2022-03-18 | 12 |
| MH28BB 2005_Dumper_gkpr | 1235002214 | 279 | 11.1 | 293.6 | -271.3 | 297072s (~3.44 days) | 1146420s (~1.9 weeks) | 2022-03-05 | 2022-03-18 | 11 |
| MH28BB 2024_Dumper_gkpr | 1235002230 | 121 | 10.0 | 20.8 | -265.9 | 415836s (~4.81 days) | 1197252s (~1.98 weeks) | 2022-03-05 | 2022-03-16 | 10 |
| MH28BB 2034_Dumper_gkpr | 1235002229 | 259 | 9.9 | 287.2 | -271.6 | 308556s (~3.57 days) | 1174464s (~1.94 weeks) | 2022-03-05 | 2022-03-17 | 11 |
| UP32NN 5161_Dumper | 1079001254 | 291 | 13.2 | 161.6 | -173.2 | 142020s (~1.64 days) | 1157868s (~1.91 weeks) | 2022-03-05 | 2022-03-21 | 14 |
| MH28BB 2023_Dumper_gkpr | 1235002236 | 283 | 8.5 | 272.1 | -265.8 | 308052s (~3.57 days) | 941580s (~1.56 weeks) | 2022-03-08 | 2022-03-18 | 8 |
| MH28BB 2019_Dumper_gkpr | 1235002239 | 279 | 6.8 | 203.5 | -205.8 | 150480s (~1.74 days) | 918756s (~1.52 weeks) | 2022-03-08 | 2022-03-20 | 11 |
| Transit Mixer | ||||||||||
| UP32NN 5046_Transit Mixer | 1079001572 | 181 | 14.3 | 285.3 | -178.7 | 125964s (~1.46 days) | 1103652s (~1.82 weeks) | 2022-01-02 | 2022-03-21 | 77 |
| UP32MN 1961_Transit Mixer | 1134000461 | 83 | 13.5 | 167.3 | -454.9 | 379692s (~4.39 days) | 1369296s (~2.26 weeks) | 2022-03-04 | 2022-03-21 | 16 |
| D-4-015_UP42CT 1225_ Transit Mixer | 1079001574 | 35 | 14.5 | 234.6 | -236.8 | 332136s (~3.84 days) | 1096056s (~1.81 weeks) | 2022-03-05 | 2022-03-17 | 11 |
| UP32NN 4355_Transit Mixer | 1079002263 | 319 | 12.4 | 182.0 | -184.1 | 119880s (~1.39 days) | 1111284s (~1.84 weeks) | 2022-03-05 | 2022-03-21 | 14 |
| UP32NN 0760_Transit Mixer | 1079001498 | 63 | 8.3 | 114.7 | -113.3 | 565488s (~6.54 days) | 1228428s (~2.03 weeks) | 2022-03-05 | 2022-03-20 | 13 |
| UP25BT 2686_Transit Mixer | 1134000345 | 31 | 10.7 | 119.0 | -85.4 | 338112s (~3.91 days) | 832680s (~1.38 weeks) | 2022-03-05 | 2022-03-17 | 10 |
| UP32NN 4356_Transit Mixer | 1079001117 | 289 | 16.7 | 165.5 | -160.3 | 128916s (~1.49 days) | 821844s (~1.36 weeks) | 2022-03-05 | 2022-03-17 | 11 |
| UP32NN 4390_Transit Mixer | 1079001120 | 141 | 22.2 | 120.8 | -125.6 | 185832s (~2.15 days) | 1173240s (~1.94 weeks) | 2022-03-05 | 2022-03-21 | 14 |
| DG | ||||||||||
| C-1-137_300KV DG | 1134000184 | 115 | 30.6 | 950.0 | -938.0 | 65268s (~18.13 hours) | 397836s (~4.6 days) | 2022-02-16 | 2022-03-21 | 32 |
| Transit Mixer123 | ||||||||||
| UP32LN 4512_Transit Mixer | 1079999822 | 3 | 100.0 | 300.0 | 0.0 | 1647612s (~2.72 weeks) | 2109528s (~3.49 weeks) | 2022-02-21 | 2022-03-15 | 21 |
| Delhi Vadodara Expressway Pkg2 | ||||||||||
| B-1-072_Excavator_Sh2 | 1079001871 | 105 | 23.4 | 360.6 | -362.3 | 165420s (~1.91 days) | 1175868s (~1.94 weeks) | 2022-03-05 | 2022-03-21 | 14 |
| Apco Gola Shahjahanpur | ||||||||||
| C-1-100_DG | 1079001383 | 239 | 19.8 | 491.2 | -485.1 | 113220s (~1.31 days) | 1186956s (~1.96 weeks) | 2022-03-05 | 2022-03-21 | 14 |
| Grader | ||||||||||
| B-5-015_Grader. | 1134000507 | 81 | 12.1 | 129.5 | -97.3 | 251460s (~2.91 days) | 1235988s (~2.04 weeks) | 2022-03-05 | 2022-03-18 | 12 |
| B-5-033_Grader_gkpr | 1235002253 | 299 | 33.1 | 267.5 | -266.1 | 229752s (~2.66 days) | 909720s (~1.5 weeks) | 2022-03-08 | 2022-03-21 | 12 |
We use another algorithm to find vehicles with wild variations in fuel. These are top 30 vehicles that have no data breaks but have lot of ups and downs. To be investigated.
| Wild Ups and Downs | |||
|---|---|---|---|
| Vehicle | Terminal ID | Observations | Standard Dev. Differences |
| Dumper | |||
| UP32LN 9667_Dumper | 1134000379 | 4680 | 8.919357 |
| UP32NN 3915_Dumper | 1079001096 | 3822 | 8.663227 |
| UP32NN 5173_Dumper | 1079001246 | 3764 | 17.987498 |
| UP25AT 8347_Dumper | 1134000273 | 3816 | 39.014721 |
| UP25BT 2236_Dumper. | 1079001571 | 4880 | 13.831268 |
| UP32NN 5112_Dumper | 1079001239 | 3753 | 6.863527 |
| Delhi Vadodara Expressway Pkg2 | |||
| B-1-044_Excavator | 1134000489 | 3967 | 9.228069 |
| HR55AJ 4099_Transit Mixer_Sh2 | 1079001807 | 5467 | 12.874771 |
| B-4-084_Loader_Sh2 | 1079001971 | 5007 | 10.164083 |
| B-5-053_Grader_Sh2 | 1079001794 | 3696 | 31.674876 |
| 9096767304_Air Compressor_Sh2 | 1079001842 | 3876 | 13.502144 |
| B-5-057_Grader_Sh2 | 1079002398 | 4124 | 29.868213 |
| B-4-078_Loader_Sh2 | 1079001972 | 5216 | 10.268657 |
| B-4-056_Loader_Sh2 | 1079001970 | 4582 | 7.604304 |
| Concrete Pump/Boomplacer | |||
| D-12-28_UP32NN 7037_Boomplacer_gkpr | 1079002024 | 3731 | 10.348448 |
| Diesel Browser | |||
| UP32MN 8551_Diesel Browser | 1079000923 | 3718 | 15.807242 |
| Water Tanker | |||
| UP32MN 8353_Water Tanker_gkpr | 1079001424 | 4834 | 34.878906 |
| UP42BT 1627_Water Tanker_gkpr | 1079002016 | 3774 | 14.975311 |
| UP32NN 4126_Water Tanker | 1079001111 | 5363 | 22.539457 |
| UP42BT 2553_Water Tanker | 1079999954 | 4388 | 17.678453 |
| UP42BT 4612_Water Tanker | 1134000474 | 5003 | 22.876540 |
| Apco-Delhi Vadodara Expressway1 | |||
| B-4-062_Loader_Sh1 | 1079001743 | 4012 | 7.311034 |
| B-4-057_ Loader_Sh1 | 1079002126 | 3898 | 8.433812 |
| Bolero | |||
| UP32LD 6442_Bolero | 1079001458 | 5019 | 19.046978 |
| DG123 | |||
| C-1-0010_DG125KVA | 1079000111 | 3692 | 80.525437 |
| Soil Compactor/Roller | |||
| B-6-023_Roller_gkpr | 1079002503 | 5963 | 127.060390 |
| Loader | |||
| B-4-65_Loader_gkpr | 1079002166 | 4396 | 6.819359 |
| Apco Bundelkhand Expressway | |||
| UP25BT 7479_Transit Mixer | 1079001105 | 5473 | 16.248205 |
| Excavator | |||
| B-1-088_Excavator_gkpr1 | 1079001201 | 4850 | 51.053109 |
| Loader123 | |||
| B4_046_Liugong loader | 1134000256 | 4479 | 7.226667 |
Sensors with data disrupted for one long period are inspected here. Those sensors that have appreciable fuel level difference across their downtime are only included here.
| Long Breaks in sensor Data | ||||||||||
|---|---|---|---|---|---|---|---|---|---|---|
| Vehicle | termid | Number of Fuel Spikes |
Average Fuel Spike value (Lits.) |
refuel | drain | Maximum Time break |
Total break in fuel data | Observation Start |
Observation End |
Observation Days |
| Dumper | ||||||||||
| UP32LN 4860_Dumper | 1079000211 | 25 | 7.3 | 12.4 | -122.3 | 657036s (~1.09 weeks) | 1476216s (~2.44 weeks) | 2022-03-03 | 2022-03-20 | 16 |
| D-1-799_Dumper_gkpr | 1079001996 | 203 | 6.9 | 40.0 | -113.2 | 318168s (~3.68 days) | 1176048s (~1.94 weeks) | 2022-03-05 | 2022-03-21 | 15 |
| D-1-797_Dumper_gkpr | 1079001991 | 169 | 5.6 | 23.7 | -135.0 | 341172s (~3.95 days) | 1176552s (~1.95 weeks) | 2022-03-05 | 2022-03-21 | 14 |
| UP32MN 0608_Dumper | 1079000957 | 301 | 5.3 | 68.6 | -157.7 | 273564s (~3.17 days) | 1194480s (~1.98 weeks) | 2022-03-05 | 2022-03-21 | 14 |
| UP32LN 5059_Dumper | 1079000216 | 43 | 7.8 | 62.4 | -56.7 | 310068s (~3.59 days) | 821448s (~1.36 weeks) | 2022-03-05 | 2022-03-16 | 10 |
| MH28BB 2196_Dumper_gkpr | 1235002231 | 379 | 7.5 | 27.2 | -193.3 | 278028s (~3.22 days) | 1144260s (~1.89 weeks) | 2022-03-05 | 2022-03-21 | 14 |
| MH28BB 2035_Dumper_gkpr | 1235002212 | 91 | 8.2 | 215.1 | -200.3 | 268560s (~3.11 days) | 1132020s (~1.87 weeks) | 2022-03-05 | 2022-03-17 | 10 |
| Apco-Delhi Vadodara Expressway1 | ||||||||||
| HR55AG 2278_Transit Mixer_Sh1 | 1079002125 | 289 | 4.1 | 122.3 | -100.3 | 311292s (~3.6 days) | 1123092s (~1.86 weeks) | 2022-03-05 | 2022-03-17 | 11 |
| B-4-059_Loader_Sh1 | 1079002118 | 179 | 8.6 | 98.7 | -170.4 | 509256s (~5.89 days) | 1203300s (~1.99 weeks) | 2022-03-05 | 2022-03-21 | 15 |
| C-1-165_DG125KVA_Sh1 | 1079001684 | 69 | 21.9 | 105.7 | -183.7 | 306504s (~3.55 days) | 1164636s (~1.93 weeks) | 2022-03-05 | 2022-03-18 | 11 |
| Delhi Vadodara Expressway Pkg2 | ||||||||||
| HR55AJ 0296_Transit Mixer_Sh2 | 1079001831 | 9 | 32.7 | 75.3 | -73.8 | 547236s (~6.33 days) | 1255392s (~2.08 weeks) | 2022-03-05 | 2022-03-20 | 14 |
| HR55AJ 7102_Dumper_Sh2 | 1235002112 | 139 | 4.4 | 115.4 | -68.8 | 272700s (~3.16 days) | 1114020s (~1.84 weeks) | 2022-03-05 | 2022-03-17 | 11 |
| HR55AHJ 9146_Dumper_Sh2 | 1079001792 | 101 | 4.9 | 50.5 | -50.3 | 319248s (~3.69 days) | 1216692s (~2.01 weeks) | 2022-03-05 | 2022-03-17 | 11 |
| HR55AJ 8533_Dumper_Sh2 | 1079001892 | 111 | 4.3 | 61.2 | -62.4 | 276624s (~3.2 days) | 1192860s (~1.97 weeks) | 2022-03-05 | 2022-03-21 | 14 |
| HR55AJ 5608_Water Tanker_Sh2 | 1079001828 | 5 | 31.1 | 99.9 | -53.8 | 297756s (~3.45 days) | 606132s (~1 weeks) | 2022-03-05 | 2022-03-13 | 7 |
| B-5-036_Cat Grader | 1134000135 | 197 | 5.7 | 125.3 | -98.9 | 318744s (~3.69 days) | 1205496s (~1.99 weeks) | 2022-03-05 | 2022-03-17 | 11 |
| KCC Buildcon Alwar | ||||||||||
| RJ02GC 0195_Dumper | 1079001228 | 199 | 4.6 | 15.3 | -142.0 | 272412s (~3.15 days) | 1170684s (~1.94 weeks) | 2022-03-05 | 2022-03-18 | 11 |
| Water Tanker | ||||||||||
| UP42BT 1627_Water Tanker_gkpr | 1079002016 | 291 | 9.2 | 114.9 | -128.3 | 323820s (~3.75 days) | 1162188s (~1.92 weeks) | 2022-03-05 | 2022-03-17 | 11 |
| Paver | ||||||||||
| B-10-049_Paver_gkpr | 1079002002 | 53 | 8.1 | 76.1 | -86.7 | 328248s (~3.8 days) | 1213488s (~2.01 weeks) | 2022-03-05 | 2022-03-17 | 11 |
| Apco Gola Shahjahanpur | ||||||||||
| L-1-013_Case baby roller | 1134000176 | 7 | 16.4 | 56.2 | 0.0 | 441828s (~5.11 days) | 1257840s (~2.08 weeks) | 2022-03-05 | 2022-03-16 | 9 |
| Apco Bundelkhand Expressway | ||||||||||
| UP32LN 4862_Dumper | 1079999825 | 43 | 8.7 | 27.7 | -65.0 | 274824s (~3.18 days) | 1200600s (~1.99 weeks) | 2022-03-05 | 2022-03-18 | 11 |
| UP32LN 4864_Dumper | 1079999819 | 77 | 3.2 | 19.0 | -74.5 | 263484s (~3.05 days) | 1220436s (~2.02 weeks) | 2022-03-05 | 2022-03-18 | 12 |
| UP32LN 4866_Dumper | 1079999817 | 57 | 6.7 | 36.5 | -143.1 | 401544s (~4.65 days) | 1236744s (~2.04 weeks) | 2022-03-05 | 2022-03-17 | 11 |
| Transit Mixer123 | ||||||||||
| UP79T 0753_Transit Mixer | 1079000081 | 37 | 9.5 | 55.1 | -56.6 | 429876s (~4.98 days) | 983556s (~1.63 weeks) | 2022-03-05 | 2022-03-17 | 11 |
| DG | ||||||||||
| C-1-053_250KV DG | 1134000179 | 169 | 18.3 | 110.2 | -255.8 | 275292s (~3.19 days) | 1195236s (~1.98 weeks) | 2022-03-05 | 2022-03-18 | 11 |
| C-1-057_125KV DG | 1134000174 | 17 | 27.1 | 79.2 | -183.6 | 769392s (~1.27 weeks) | 1242504s (~2.05 weeks) | 2022-03-05 | 2022-03-12 | 6 |
| DG123 | ||||||||||
| B1-149_DG 250KVA | 1079000110 | 27 | 22.1 | 72.6 | -141.4 | 358308s (~4.15 days) | 1239552s (~2.05 weeks) | 2022-03-05 | 2022-03-17 | 10 |
| C-1-153_DGH 125KVA | 1079000108 | 15 | 28.2 | 242.9 | -17.9 | 528768s (~6.12 days) | 1244448s (~2.06 weeks) | 2022-03-05 | 2022-03-20 | 14 |
| Asian Paints | ||||||||||
| UP25BT 5679_Transit Mixer | 1134000257 | 51 | 7.8 | 124.6 | -58.9 | 533844s (~6.18 days) | 1002960s (~1.66 weeks) | 2022-03-05 | 2022-03-18 | 12 |
| Transit Mixer | ||||||||||
| UP32NN 0778_Transit Mixer_gkpr1 | 1235002244 | 127 | 7.6 | 148.3 | -110.0 | 655236s (~1.08 weeks) | 959976s (~1.59 weeks) | 2022-03-08 | 2022-03-13 | 4 |
And these are top 5 vehicles with high data breaks.
This is the starting of reports for APCO. Will need validations as I go along creating more and more useful reports. If above data is useful but needs a different template, or more vehicles, let’s bring all of it now.