Skip to content
Back to research & projects
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.

Fig. 01 · Schematic

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.