ENGINEERING DOCUMENTATION & EXCEL-BASED CONTROL SYSTEM

Data-Driven Documentation & Project Control

The Aimers Construction implements a structured Excel-based Engineering Documentation & Data Management System designed for PSU, EPC, Railway, Metro, and Infrastructure Projects, ensuring:

• Real-time tracking

• Audit-ready records

• BOQ & billing accuracy

• Full traceability

Our system is aligned with IS Codes, MoRTH Specifications, RDSO Guidelines, CPWD Manual & ISO Documentation Standards.

MASTER DOCUMENT CONTROL SYSTEM (EXCEL)

Centralized Master Tracker

We maintain a Master Excel Dashboard containing:

• Document ID / Numbering System

• Drawing Register

• QA/QC Documents (PQP, ITP, Method Statements)

• Material Submittals & Approvals

• Inspection Requests (IR) Status

• NCR Tracker

• Test Reports (Field + Lab)

Features:

• Unique Document Coding System

• Revision Control (Rev-0, Rev-1, Rev-2…)

• Approval Workflow Tracking (Client / PMC / Consultant)

• Status: Pending / Approved / Rejected / Closed

QA/QC DOCUMENTATION TRACKER (EXCEL)

Records Maintained:

• Inspection Request (IR) Log

• Pour Card Register

• Cube Casting & Test Register

• Field Test Register (FDD, SPT, PLT)

• Material Test Report (MTR) Tracker

📐 Standards:

• IS 456, IS 516, IS 2386

• MoRTH Section 900

• RDSO Quality Compliance

🔷 3. NCR & CAPA TRACKING SYSTEM

Non-Conformance Management:

• NCR Number & Description

• Location & Activity

• Root Cause Analysis (RCA)

• Corrective & Preventive Action (CAPA)

• Closure Status & Approval

Objective:

• Zero repeat defects

• Audit-ready compliance

BILLING & QUANTITY TRACKER (EXCEL)

Billing Control System:

• BOQ Item Tracking

• Executed Quantity vs BOQ Quantity

• RA Bill Status

• JMR (Joint Measurement Record) Tracking

• Quantity Reconciliation

Features:

• Automatic Quantity Calculation

• Rate-wise billing summary

• Payment tracking

MATERIAL MANAGEMENT & CONSUMPTION TRACKER

Registers:

• Cement Consumption Register

• Aggregate Register

• Sand Register

• Steel Consumption Tracker

Features:

• Theoretical vs Actual Consumption

• Wastage Analysis

• Stock Monitoring

SURVEY & LEVEL DATA TRACKER

Survey Excel Logs:

• Benchmark (BM) Register

• Reduced Level (RL) Data Sheet

• Coordinate Tracking (Easting, Northing)

• Layout Records

Integration:

• AutoCAD / Survey Data

• Field Verification Records

PILING & FOUNDATION RECORD SYSTEM

Registers:

• Pile Register (Depth, Dia, Concrete, Reinforcement)

• Pile Load Test Record

• Bentonite Test Log

• Pile Integrity Test Reports

DAILY & WEEKLY PROGRESS TRACKER

Monitoring System:

• Daily Progress Report (DPR)

• Weekly Progress Dashboard

• Look-Ahead Planning Sheet

• Resource & Manpower Tracking

AUDIT & COMPLIANCE DOCUMENTATION

Audit-Ready Files:

• CAG / PSU Audit Records

• RDSO Inspection Files

• Third Party Inspection Reports

• Calibration Records

Excel Control:

• Checklist-based audit tracker

• Document availability status

 ADVANCED EXCEL FEATURES (MNC LEVEL)

System Capabilities:

• Pivot Tables & Dashboards

• Auto Calculations & Formulas

• Conditional Formatting (Delay / Risk Highlight)

• Data Validation (Error Control)

• Hyperlink-based Document Access

We deploy a fully integrated Excel-based engineering documentation system to ensure real-time project control, audit-ready compliance, accurate billing, and complete traceability across all construction activities.

Sheet Names:

1. Master Tracker

2. Drawing Register

3. IR Log

4. NCR Tracker

5. Cube Register

6. FDD / Field Test

7. Material Register

8. BOQ & Billing

9. Pile Register

10. Survey Data

11. Daily Progress

12. Hinderance Register

13. Material Passing Register

14. POUR LOG SHEET

Example (NCR Tracker Columns)

• NCR No

• Date

• Location

• Activity

• Description

• Root Cause

• Action Taken

• Status

• Closed Date

📋 Example (BOQ Sheet)

• Item No

• Description

• Unit

• BOQ Qty

• Executed Qty

• Balance

• Rate

• Amount

Example (Cube Register)

• Date

• Location

• Grade

• Cube No

• 7 Days Strength

• 28 Days Strength

• Result