real time diesel tracking system
TRANSCRIPT
Confidential – C204/09/23- Circle Monthly Review.pptx
Real Time Diesel Fill Tracking – Short code SMSReal Time Diesel Fill Tracking – Short code SMS
Gujarat CircleGujarat Circle
Confidential – C204/09/23- Circle Monthly Review.pptx
ObjectiveObjectiveObjectiveObjective
2
Real Time Diesel Filling Tracking
Better Control on Diesel Usage (OME’s)
DG Hr Meter Reading & CPH calculations
Tracking Diesel filled on EB/NEB sites
Making Diesel Filler More accountable
Real Time Diesel Filling Tracking
Better Control on Diesel Usage (OME’s)
DG Hr Meter Reading & CPH calculations
Tracking Diesel filled on EB/NEB sites
Making Diesel Filler More accountable
Confidential – C204/09/23- Circle Monthly Review.pptx
ProcessProcessProcessProcess
3
Diesel Filler fills Diesel on the site & sends SMS in prescribed Format to Short code – 51619
SMS Format – FMS – Fuel Management SystemIN-ID – Site Indus IdQty – Quantity of Diesel filledMtr Reading – DG Hour Meter ReadingSite Type – EB site or NEB siteSend it to 51619
Example – FMS IN-1234567 200 4321 NEB 51619
System Response on correct entry - Your FMS request has been successfully registered
System Response for in correct entry - You have entered incorrect Keyword, please resend in following format “ FMS IN-ID Qtyfilled DGHrMtr EB/NEB”
Confidential – C204/09/23- Circle Monthly Review.pptx
Raw Data
MSISDNPARAM1 SMS_DT9601296247 IN-1077260 100 1065.15 EB 9/1/2009 12:14:28 AM9601296247 IN-1105896 75 334.8 EB 9/1/2009 1:30:47 AM9601297068 IN-1076570 200 1194 EB 9/1/2009 9:15:21 AM9601297068 IN-1041028 100 323 EB 9/1/2009 9:27:57 AM9601297152 IN-1046019 50 263 EB 9/1/2009 9:38:44 AM9601297152 IN-1067076 50 101 EB 9/1/2009 9:40:43 AM9601296401 IN-1003490 200 1500.40 EB 9/1/2009 9:46:33 AM9601296401 IN-1040960 100 231.32 EB 9/1/2009 9:50:01 AM9601296287 IN-1040941 50 1550 EB 9/1/2009 9:53:33 AM9601297191 IN-1003102 150 367 EB 9/1/2009 10:12:24 AM9601296649 IN-1122000 200 2645.5 NEB 9/1/2009 10:37:24 AM9601296399 IN-1071643 65 973 EB 9/1/2009 10:43:03 AM9601296280 IN-1011566 200 2106.55 EB 9/1/2009 10:43:19 AM9601297191 IN-1040883 150 6146 NEB9/1/2009 10:45:50 AM
RAW data received from system
Confidential – C204/09/23- Circle Monthly Review.pptx
Processed data
Mobile no. Message Indus ID Cluster Diesel Filled
HMR reading Site Status SMS Date SMS Time
9601297013 IN-1003051 1439 50 EB IN-1003051 Ahmedabad 50 1439 EB 9/11/2009 6:15:20 PM
9601297013 IN-1098819 50 565 EB IN-1098819 Ahmedabad 50 565 EB 9/11/2009 7:45:58 PM
9601297068 IN-1040062 50 534 EB IN-1040062 Ahmedabad 50 534 EB 9/11/2009 12:32:23 PM
9601297068 IN-1040137 50 1475 EB IN-1040137 Ahmedabad 50 1475 EB 9/11/2009 12:57:56 PM
9601297083 IN-1039485 150 7717 NEB IN-1039485 Ahmedabad 150 7717 NEB 9/11/2009 3:48:35 PM
9601297087 IN-1039686 100 709 EB IN-1039686 Ahmedabad 100 709 EB 9/11/2009 3:25:59 PM
9601297087 IN-1123166 50 2889 NEB IN-1123166 Ahmedabad 50 2889 NEB 9/11/2009 3:24:01 PM
9601297138 IN-1002861 50 1760 EB IN-1002861 Ahmedabad 50 1760 EB 9/11/2009 5:24:45 PM
9601297138 IN-1085503 50 1799 EB IN-1085503 Ahmedabad 50 1799 EB 9/11/2009 4:00:51 PM
9601297138 IN-1011570 50 601 EB IN-1011570 Ahmedabad 50 601 EB 9/11/2009 5:28:52 PM
9601297138 IN-1040805 50 349 EB IN-1040805 Ahmedabad 50 349 EB 9/11/2009 4:40:59 PM
Processed data
Confidential – C204/09/23- Circle Monthly Review.pptx
Type of Analysis…..(1) Diesel filled/no of
SMS per day
Date Ahmedabad Baroda Rajkot Surat Grand Total
9/11/2009 3075 10270 6507 9500 29352
9/12/2009 6475 8545 9050 7200 31270
9/13/2009 3675 4265 5060 5480 18480
9/14/2009 5250 7785 9097 9000 31132
Grand Total 18475 30865 29714 31180 110234
SMS Date Ahmedabad Baroda Rajkot Surat Grand Total
9/11/2009 45 94 60 85 284
9/12/2009 89 81 84 79 333
9/13/2009 42 36 53 50 181
9/14/2009 65 94 80 90 329
Grand Total 241 305 277 304 1127
Diesel Filled Quantity
SMS Count for Diesel Filled
Confidential – C204/09/23- Circle Monthly Review.pptx
Cluster
Site with EB On DG site
No of SMS - Diesel Filled Qty of Diesel Filled No of SMS - Diesel Filled Qty of Diesel Filled
Ahmedabad 172 9975 69 8500
Baroda 212 16105 93 14760
Rajkot 245 24684 32 5030
Surat 191 13680 113 17500
Grand Total 820 64444 307 45790
Type of Analysis…..(3) Diesel filled Captured
Cluster Xtra Power Diesel Sold (11-14 Sept) SMS Diesel Captured (11-14 Sept) % diesel captured
Ahmedabad 24344 18475 76%
Baroda 33471 30865 92%
Rajkot 30702 29714 97%
Surat 35301 31180 88%
Grand Total 123818 110234 89%
% Diesel Captured by SMS
Diesel Distribution at EB and NEB Site
Confidential – C204/09/23- Circle Monthly Review.pptx
Type of Analysis…..(2) Time period of filling
Cluster Total SMS Received (11-14 Sept) SMS Received between 10 PM to 6 AM % diesel filled at Night
Ahmedabad 241 13 4.94%
Baroda 305 25 7.53%
Rajkot 277 14 4.95%
Surat 304 25 8.04%
Grand Total 1127 77 6.83%
Diesel Filled at Night
Confidential – C204/09/23- Circle Monthly Review.pptx
SMS coverage trend line
Cluster % diesel Captured August (16-31) % diesel Captured Sept (1-10) % diesel Captured Sept (11-14)
Ahmedabad 43.91% 61.21% 76%
Baroda 20.16% 55.38% 92%
Rajkot 25.17% 86.02% 97%
Surat 55.27% 55.85% 88%
Total 35.69% 63.51% 89%
Confidential – C204/09/23- Circle Monthly Review.pptx
ChallengesChallengesChallengesChallenges
10
Apart from bringing the Diesel fillers to this level of 100% entries, another challenge lies in capturing the Hour meter data for each site for which all faulty DG hour meters need to be replaced
We have got approx 2600 such sites with faulty hour meters
Once these two things are successfully complied with, we will be able to work out Diesel CPH with fairly good accuracy for each site
All Diesel Fillers should be Short Code service provider subscribers (Airtel in Our Case)
Atleast 2Hr of time is required for extracting meaningful MIS from Raw data
Apart from bringing the Diesel fillers to this level of 100% entries, another challenge lies in capturing the Hour meter data for each site for which all faulty DG hour meters need to be replaced
We have got approx 2600 such sites with faulty hour meters
Once these two things are successfully complied with, we will be able to work out Diesel CPH with fairly good accuracy for each site
All Diesel Fillers should be Short Code service provider subscribers (Airtel in Our Case)
Atleast 2Hr of time is required for extracting meaningful MIS from Raw data
Confidential – C204/09/23- Circle Monthly Review.pptx
Support RequiredSupport RequiredSupport RequiredSupport Required
11
Daily SMS Dump sharing –service provider FTP/SFTP location for sharing daily SMS dump – Indus Intelligent Reporting from system – service provider
Daily SMS Dump sharing –service provider FTP/SFTP location for sharing daily SMS dump – Indus Intelligent Reporting from system – service provider
Confidential – C204/09/23- Circle Monthly Review.pptx 12
Thank you!Thank you!