Standard Operating Procedure (SOP)

Process Steps

Step
Activity Description / Action Responsibility Output
No.

Download Two raw data files

1 Download Axestrack Dashboard and MTR Report (Yesterday Date) Data Analyst
Source Files downloaded

Consolidate into
2 Copy data into Master File (Base Data) containing: Dashboard, Trip Data, Mail Format, MTR Data Analyst Updated Master File
Master File

Generate Trip
3 Run Dashboard_New macro in Dashboard sheet → generates trip data report Data Analyst Refreshed Trip Data
Data Report

4 Clean Data Use shortcut Ctrl + T → removes N/A values and deletes empty cells Data Analyst Clean Trip Data

New Excel created with: • Sheet 1 → Trip Data Overall • Sheet 2 → Dashboard Data overall.
Create Working Working File with
5 Rename column “Oops Remark” → “Zone” Apply VLOOKUP for Zone against Company & Plant name Data Analyst
File Zone mapping
from the trip data to get the zone for the plant.

Prepare Zone Zone files ready for

6 Open 8 Zone files: Central, East, North1, North2, South1, South2, West1, West2 Data Analyst
Files update

Populate Zone From Mail Format sheet in Master File → Using pivot filters (Zone + Plant wise) → Data is Created → Zone-wise Plant data
7 Data Analyst
Files Output → Copy & paste outputs (Values only) into respective Zone Files updated

In New File Created to Store Dashboard and Trip data file apply filters: • Status = “Unreachable” • Zone
Offline Data Zone-wise Offline &
8 = selected. Copy & paste filtered data to Offline (Dashboard Data) and Trip Data sheets of Trip data Data Analyst
Preparation Trip Data updated
from zone wise report

9 Repetition The Process will be repeated for all the zone wise plnat

Cross Verify from: • Cement Inventory Sheet → Maintenance done by Technician • Master Tracker Sheet → Verified maintenance
10 Data Analyst
Verification Installation done by Tracker & installation

Final Zone-wise
11 Save Reports Save each Zone File with format: ZoneName_Report_DDMMYYYY.xlsx (Yesterday’s date) Data Analyst
Reports
Deliverables

• Zone-wise Reports containing:

o Offline Data

o Trip Data

o Summary