EPC project status Obligation

Project Management (Database)

-- Select Project from IndexedDB --

Primary Details

Project Name

Length (km)

AA Cost (Cr)

Appointment Date

Estimate (Cr)

Accepted Tender (Cr)

Variation %

Work Period

Contractor

Authority Engineer

1. Consultants & Personnel

Consultants & Personnel	Sub. Date	Rem. Date	Status	Remarks	Action
Design Consultant			PendingSubmittedApprovedReverted
Proof Consultant			PendingSubmittedApprovedReverted
Safety Consultant			PendingSubmittedApprovedReverted
Project Manager			PendingSubmittedApprovedReverted
Surveyor			PendingSubmittedApprovedReverted
Site Supervisor			PendingSubmittedApprovedReverted
Material Engineer			PendingSubmittedApprovedReverted

2. Mandatory Submissions

Mandatory Submissions	Sub. Date	Rem. Date	Status	Remarks	Action
Land Memorandom			PendingSubmittedApprovedReverted
Schedule H			PendingSubmittedApprovedReverted
Schedule F Permits (20 Days)			PendingSubmittedApprovedReverted
Project Implementation Schedule or Construction program– In line with Schedule-J along with approved Schedule-J			PendingSubmittedApprovedReverted
Workzone Safety Plan (20 Days)			PendingSubmittedApprovedReverted
Environment Management Plan (20 Days)			PendingSubmittedApprovedReverted
Work Programme (30 Days)			PendingSubmittedApprovedReverted
QAP (30 Days)			PendingSubmittedApprovedReverted
Insurance Policy (CAR)			PendingSubmittedApprovedReverted
Comprehensive workman insurance Policy.			PendingSubmittedApprovedReverted

3. Engineering Documents

Structural Drawings	Sub. Date	Rem. Date	Status	Remarks	Action
Plan and Profile			PendingSubmittedApprovedReverted
Traffic Diversion Plan			PendingSubmittedApprovedReverted
Drone Videography as per 11.16 every calender Quarter			PendingSubmittedApprovedReverted
Construction Methodology			PendingSubmittedApprovedReverted
MPR & QPR no latter than 10 Days after the close of easch month as per clause 11.7			PendingSubmittedApprovedReverted
HPC			PendingSubmittedApprovedReverted
Minor Bridge			PendingSubmittedApprovedReverted
Major Bridge			PendingSubmittedApprovedReverted
Slab drain			PendingSubmittedApprovedReverted
Retaining wall			PendingSubmittedApprovedReverted
Footway Drain			PendingSubmittedApprovedReverted
Rigid Pavement			PendingSubmittedApprovedReverted
Anti Crash barrier			PendingSubmittedApprovedReverted
List of TBMs			PendingSubmittedApprovedReverted
Drainage Plan			PendingSubmittedApprovedReverted
Hydraulic Calculations			PendingSubmittedApprovedReverted
Flexible Pavement Design			PendingSubmittedApprovedReverted

4. Statutory Approvals

Approvals	Sub. Date	Rem. Date	Status	Remarks	Action
Environmental Clearance			PendingSubmittedApprovedReverted
MPCB			PendingSubmittedApprovedReverted
Forest Clearance			PendingSubmittedApprovedReverted
Tree Cutting Permission			PendingSubmittedApprovedReverted
Explosive License			PendingSubmittedApprovedReverted
Village Panchayat NOC for borrow area.			PendingSubmittedApprovedReverted
Drawing water from River/Reservoir			PendingSubmittedApprovedReverted
WC Policy			PendingSubmittedApprovedReverted
Quarry Agreements/Permission for Lease			PendingSubmittedApprovedReverted
Fire Policy			PendingSubmittedApprovedReverted
Camp Office – Copy of Lease/Rent Deed/Conveyance Deed.			PendingSubmittedApprovedReverted
Availability of infrastructure like electricity, water, fuel etc. i.e., Bill copies			PendingSubmittedApprovedReverted
Insurance of assets mobilised site.			PendingSubmittedApprovedReverted
Comprehensive project risk policy (Natural calamities)			PendingSubmittedApprovedReverted
Comprehensive workman insurance Policy.			PendingSubmittedApprovedReverted

5. Material Approval

Material	Sub. Date	Rem. Date	Status	Remarks	Action
Aggregates			PendingSubmittedApprovedReverted
Soil			PendingSubmittedApprovedReverted
Fly Ash			PendingSubmittedApprovedReverted
Cement			PendingSubmittedApprovedReverted
Steel			PendingSubmittedApprovedReverted
Bitumen			PendingSubmittedApprovedReverted
GSB			PendingSubmittedApprovedReverted
WMM			PendingSubmittedApprovedReverted
GGBS			PendingSubmittedApprovedReverted
Admixture 1			PendingSubmittedApprovedReverted
Admixture 2			PendingSubmittedApprovedReverted
Water			PendingSubmittedApprovedReverted
Hume Pipe/Arcoduct			PendingSubmittedApprovedReverted
Bituminous Mix Designs			PendingSubmittedApprovedReverted
Concrete Mix Designs			PendingSubmittedApprovedReverted
Trial Patch			PendingSubmittedApprovedReverted
CTE and CTO (All Plants and Crushers)			PendingSubmittedApprovedReverted

6. Details of site mobilization including details of base camp, list of construction equipment, Manpower to be deployed etc.

Mobilization	Sub. Date	Rem. Date	Status	Remarks	Action
Ready Mix Plant			PendingSubmittedApprovedReverted
Batch mix Plant			PendingSubmittedApprovedReverted
Drum mix Plant			PendingSubmittedApprovedReverted
Crusher			PendingSubmittedApprovedReverted
Lab Setup			PendingSubmittedApprovedReverted
Calbration Certificate			PendingSubmittedApprovedReverted
Machinery			PendingSubmittedApprovedReverted
Manpower			PendingSubmittedApprovedReverted
Camp Office – Copy of Lease/Rent Deed/Conveyance Deed.			PendingSubmittedApprovedReverted

EPC Project Monitoring & Management Tool

This advanced HTML + JavaScript based Project Monitoring Tool is designed for Engineering, Procurement, and Construction (EPC) projects, particularly suited for PWD / Highway / Infrastructure Projects. It provides a structured, database-driven interface to manage project data, track submissions, monitor approvals, and generate reports.

---

🔷 Key Features

• 📂 Project storage using IndexedDB (Browser Database)
• 📊 Multi-section compliance tracking (6 structured tables)
• 📥 JSON Import & 📤 JSON Backup system
• 📄 One-click CSV report generation
• ➕ Dynamic row addition & deletion
• ⚡ Real-time variation calculation (Estimate vs Tender)
• 🧠 Fully client-side (No server required)

---

1. Project Database Management

The tool uses IndexedDB to store multiple projects locally in the browser.

• Select Project: Load saved project from dropdown
• Save to DB: Stores complete project including all tables
• Delete Project: Permanently removes project data
• Refresh/New: Clears screen for new entry

Each project is uniquely identified using Project Name as Key.

---

2. Primary Project Details

This section captures essential project metadata required for reporting and tracking:

• Project Name
• Road Length (km)
• Administrative Approval Cost (AA Cost)
• Appointment Date
• Estimate Cost vs Accepted Tender
• Work Period
• Contractor & Authority Engineer

📊 Variation Calculation

The tool automatically calculates variation using:

Variation (%) = ((Tender - Estimate) / Estimate) × 100
    

Output indicates whether the tender is Above or Below the estimate.

---

3. Structured Monitoring Tables

The system is divided into 6 major monitoring sections, each representing a critical EPC compliance domain.

📁 Sections Included:

1. Consultants & Personnel
2. Mandatory Submissions
3. Engineering Documents
4. Statutory Approvals
5. Material Approvals
6. Site Mobilization

📌 Table Structure

Each table follows a standardized format:

• Description
• Submission Date
• Remark Date
• Status (Pending / Submitted / Approved / Reverted)
• Remarks

➕ Dynamic Row Feature

• Add unlimited rows using + button
• Delete rows using 🗑️ button
• Ensures flexible project tracking

---

4. Data Persistence Logic

💾 Save Function

The saveToDB() function:

• Collects all input values
• Loops through all 6 tables (table_0 to table_5)
• Stores structured array data in IndexedDB

📂 Load Function

The loadSelectedProject() function:

• Retrieves project data
• Populates form fields
• Dynamically rebuilds all tables

---

5. Import & Backup System

📥 Import JSON

• Upload previously exported backup file
• Automatically merges projects into database

📤 Export JSON Backup

• Exports all projects in structured JSON format
• Filename includes current date
• Ensures data portability & backup safety

---

6. CSV Report Generation

The Export CSV feature generates a complete project monitoring report:

• Includes project summary
• Exports all 6 sections
• Each table becomes a structured section
• Compatible with Excel

Special handling ensures:

• Commas inside text are safely managed
• Each row is exported as a single clean line

---

7. Status Tracking System

Each activity is tracked through lifecycle stages:

• ⏳ Pending
• 📤 Submitted
• ✅ Approved
• 🔁 Reverted

This enables real-time monitoring of project compliance and delays.

---

8. Technical Architecture

• Frontend: HTML + CSS
• Logic: Vanilla JavaScript
• Database: IndexedDB (Client-side)
• File Handling: Blob API + FileReader

---

9. Advantages

• ✔ No internet required (Offline tool)
• ✔ No installation needed
• ✔ Highly customizable
• ✔ Suitable for site engineers & project managers
• ✔ Eliminates manual tracking in Excel