Infrastructure Project Dashboard

General Project Information

Project Name

Work Code / Job No.

Division

Admin Approval (AA) (₹)

AA Ref No. & Date

Technical Sanction (TS) (₹)

TS Ref No. & Date

Tendered Amount (₹)

Contractor Name

Commencement Date

Stipulated Completion

1. Master TS Components

Component Name

TS Amount (₹)

Action

2. RA Bill Entries

3. Cumulative Summary

Description	TS Amount	Expended	Balance	Status

Infrastructure Project Dashboard – Technical Explanation

This application is a comprehensive project monitoring and expenditure tracking system designed for infrastructure works. It integrates project data management, bill tracking, and financial control into a single dashboard using browser-based storage.

1. Objective of the System

Manage project-level administrative and financial data
Track Technical Sanction (TS) components
Monitor RA (Running Account) bills
Provide real-time expenditure vs budget comparison
Enable backup and restoration of project data

2. General Project Information

The system captures key administrative details:

Project Name, Work Code, Division
Administrative Approval (AA)
Technical Sanction (TS)
Tendered Amount
Contractor Details
Project Timeline (Start & Completion)

These parameters form the base for financial and progress tracking.

3. Master TS Components

The project is divided into multiple components such as:

Civil Work
Royalty
Insurance
Other custom components

Each component includes:

Component Name + TS Amount

This defines the maximum allowable expenditure for each category.

4. RA Bill Management

The system allows multiple RA bills, each containing:

Bill Name (e.g., 1st RA, 2nd RA)
Component-wise expenditure
Remarks for each entry

Each bill dynamically links to master components:

Selected Component → Fetch TS Limit → Enter Current Amount

5. Real-Time Synchronization Logic

The core function syncAll() performs:

Updates dropdown options from master list
Displays TS limits dynamically
Aggregates expenditure across all bills

Total Expended = Σ (All RA Bills for each component)

6. Cumulative Summary Calculation

For each component:

Balance = TS Amount - Total Expended

Status is determined as:

If Balance < 0 → OVER (Budget Exceeded) Else → OK

Negative balance indicates overspending and requires immediate attention.

7. Data Storage (IndexedDB)

All project data is stored in browser database:

Database: PWD_Blogger_DB Store: projects Key: id = "p1"

Stored data includes:

Project details
Master components
All RA bills
Item-wise expenditure

8. Save & Load Mechanism

Saving Data

objectStore.put(projectData)

Ensures persistent storage within browser.

Loading Data

objectStore.get("p1")

Automatically restores previous session data.

9. Import / Export Feature

Export

Project data is exported as JSON:

JSON.stringify(data, null, 2)

Import

The system:

Reads JSON file
Validates structure
Saves to IndexedDB
Reloads dashboard

10. Workflow Summary

Enter project details
Define TS components
Add RA bills
Input expenditure values
System calculates totals and balances
Monitor status (OK / OVER)
Save data or export backup

11. Engineering & Management Benefits

Real-time budget monitoring
Prevents overspending
Centralized project tracking
Improves transparency and accountability
Reduces manual errors

12. Assumptions

All TS values are fixed and approved
RA bills are cumulative in nature
No variation orders considered
Single-user environment

13. Limitations

No cloud synchronization
No multi-user collaboration
No approval workflow
No integration with accounting systems

14. Conclusion

This dashboard functions as a powerful project expenditure tracking tool, combining financial control with ease of use. It is especially useful for engineers, project managers, and administrative authorities handling infrastructure works.

Future enhancements may include cloud integration, real-time collaboration, and advanced analytics dashboards.

YogiPWD

Expenditure Tracker