Back to research & projects Fig. 01 · Schematic
Web dashboardIn progress2026
Integrated Project Monitoring System
An interactive dashboard for the Tamakoshi V Hydroelectric Project that reads the team’s Excel trackers and Primavera P6 schedules live from cloud storage, bringing progress, finance, tunnelling, claims, manpower and equipment into one view.
Overview
A multi-panel web dashboard for the Tamakoshi V Hydroelectric Project (99.8 MW). It visualises the project tracking data the team already maintains in Excel workbooks and Primavera P6 schedules, rather than asking anyone to re-enter it.
Approach
A static HTML, CSS and JavaScript front end with ECharts for the charts. A Vercel serverless function fetches the latest files from cloud storage over WebDAV, parses them with SheetJS, and returns clean JSON to the browser.
Features
- Panels for executive summary, financial, schedule and progress, tunnel, claims and variations, inventory, quality control, insurance, manpower and equipment.
- A Refresh button pulls the latest workbooks without redeploying the site.
- Reads Primavera P6 (XER) schedule exports alongside the Excel trackers.
- Sign-in with admin-managed access.