Sign in to continue. Usage (login, time spent, tabs viewed) is logged.
Dashboard developed by Parag Jiwani
Gap Report Dashboard
Upload filesBusiness day = 06:00 to next-day 05:59. Transaction Report(s) give D1N1–D2N2 and Automation; the Sales Tracker (sheet “Master”) gives MIS and the station list – upload the tracker of every month your transactions cover (select several files together, or upload them one after another; they are combined until you press Reset). The report follows whichever days and months are in the uploaded data. Co-ordinators are matched by ERP from the sample-format file.
Gap Report
Daily Automation vs MISLitres, with gap % on the right axis
Co-ordinator gap (Automation − MIS)Litres
Month-wise summaryMonths covered by the uploaded data
Date-wise summaryAll stations in the current filter
State-wise summary
Co-ordinator-wise summary
Remarks summaryRows by remark category
Automation lower than MISLargest shortfalls (top 25)
Automation higher than MISLargest excess (top 25)
MIS reported but no automation salesPossible automation/communication failure (top 25 by MIS)
Automation sales but MIS missingMIS blank in Sales Tracker (top 25)
Business-day coverageEach day runs 06:00 to next-day 05:59; first/last day flagged if the file starts/ends inside the window
Data checks
Usage by userSessions and active time (time counts only while the tab is visible)