Programme Dashboard
Total Projects
0
Active portfolio
Completed
0
0%
In Progress
0
Active execution
Delayed / Overdue
0
Requires action
Total Tasks
0
0 complete
Total Budget (TTD)
$0
$0 spent
Average Progress
0%
Across all projects
Team Members
0
Assigned resources
Procurement Pipeline KPIs
Total Solicitations
0
PSIP + General
Not Yet Issued
0
Pipeline awaiting issue
Closing Soon
0
Within 7 days
In Procurement
0
Issued / eval / payment
Completed / Awarded
0
0%
Project Status Distribution
Priority Mix
Budget vs Actual by Category
Progress Curve (Cumulative %)
Task Completion by Owner
Top 10 Projects by Budget
Procurement Tracker (PSIP & General/Recurrent)
| # | Description | Location | Linked Projects | Scope Submitted | Issued to Proponent | Closing | Proc → Dept Evaluation | Dept → Proc Evaluation Complete | Project Lead Dept. | Proposed Start Date | Proposed Completion Date | Status | Comments |
|---|
Projects Register - Grouped by District
| ID | Project Name | Category | District | Location | Manager | Start | End | Actual Start | Actual Completion | Status | Priority | Progress % | Budget | Variation | Revised Budget | Spent | Paid to Date | Variance | Tenders |
|---|
Task Register
| ID | Project | Task | Owner | Start | End | Days | Status | Priority | Progress % |
|---|
Gantt Chart
Status:
Not Started
In Progress
Complete
On Hold
Delayed
Today
Task / Project
Owner
Days
Procurement Pipeline Summary
Status Distribution
Projects by Section
Urgency Timeline
Active tenders by days to closing
Velocity Tracker (6 months)
Section Scorecard
Progress by section
Breakdown by Section
| Section | Total | Not Issued | Issued | Closing | Eval Done | Complete | Progress |
|---|
Team Members
| ID | Name | Role / Title | Department | Phone | Active Tasks | Completed | Workload % |
|---|
Calculations & Formulas
Live formulas the dashboard uses. Each card mirrors a calculation from the source workbook.
Settings & Lookups
Status Values
Priority Values
Project Categories
Departments
Procurement Sections
Procurement Statuses
Organization Profile
Cloud Sync (Google Sheets)
Auto-syncs after every save. Use Pull to fetch others' changes; use Push if you've been working offline.
Data Operations
Data persists in browser localStorage on this device and auto-syncs to Google Sheets.
Admin Panel
Only Premium Admins see this tab. Create Super Admin accounts (full edit access, no user management) or Viewer accounts (read-only).
| Username | Full Name | Role | Status | Created | Last Sign-In |
|---|
Role Capabilities
| Capability | Premium Admin | Super Admin | Viewer |
|---|---|---|---|
| View Dashboard / Projects / Tasks / Gantt / Procurement | Y | Y | Y |
| Add / edit / delete projects, tasks, procurement, team | Y | Y | - |
| Edit lookups, settings & sections | Y | Y | - |
| Export CSV / PDF Report | Y | Y | Y |
| Import data / reset | Y | Y | - |
| Manage users and passwords | Y | - | - |
| View audit log | Y | - | - |
Audit Log
Timestamp
User
Action
Details