Scribd
Upload
16 views2 pages

Standard Operating Procedure

This Standard Operating Procedure outlines the steps for downloading, consolidating, and generating reports from Axestrack Dashboard and MTR Report data. It includes processes for cleaning data, preparing zone files, populating them with relevant information, and verifying maintenance records. The final deliverables are zone-wise reports that include offline data, trip data, and a summary.

Uploaded by

Mickey virus
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
16 views2 pages

Standard Operating Procedure

This Standard Operating Procedure outlines the steps for downloading, consolidating, and generating reports from Axestrack Dashboard and MTR Report data. It includes processes for cleaning data, preparing zone files, populating them with relevant information, and verifying maintenance records. The final deliverables are zone-wise reports that include offline data, trip data, and a summary.

Uploaded by

Mickey virus
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd

Standard Operating Procedure (SOP)

Process Steps

Step Responsibil
Activity Description / Action Output
No. ity

Download Two raw data files


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

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

Generate Trip Refreshed Trip


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

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
Create Working overall. Working File with
5 Data Analyst
File Rename column “Oops Remark” → “Zone” Apply VLOOKUP for Zone against Company Zone mapping
& Plant name from the trip data to get the zone for the plant.

Prepare Zone Zone files ready


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

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

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

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

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

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

 Zone-wise Reports containing:

o Offline Data

o Trip Data

o Summary

You might also like