Staff deliverables tracker
Staff maintained grant, geography, timing, status, program area, ownership, and month-by-month deliverables in one working document.
Operational inputSoftware engineering internship · Jun–Sep 2025
A shared view of Hawaiʻi’s wildfire work
Explore the workstream inventoryThe coordination problem
One working tracker.
One usable program picture.
HWMO’s staff tracker held dozens of deliverables across grants, islands, program areas, years, and stages of work.
I turned that operational spreadsheet into a cleaner reporting layer. The public reconstruction below keeps the real workstream names and deliverables while removing staff assignments, workload notes, and partner-contact fields.
- Role
- Software Engineering Intern
- Organization
- Hawaii Wildfire Management Organization
- Stack
- Python · Flask · Google Sheets · HTML/CSS/JS
The operational picture
The tracker became a navigable view of the work.
Every figure is calculated from the original 2025 staff-deliverables tracker. These are workload and status counts—not invented funding or impact claims.
84tracked deliverables
27grants and workstreams
46deliverables in progress
6geographic groupings
How the system worked
From staff planning to a clear coordination view
The spreadsheet remained familiar to staff. The application handled the work required to make those records consistent, safe to publish, and easy to explore.
Shared Google Sheet
The source contained 84 action rows across 45 columns, including planning years from 2025 through 2028.
Single source of truthNormalization and privacy
Python maps shorthand into stable statuses, programs, regions, and years; groups related actions by workstream; and removes all staff and contact fields.
Validation layerFlask reporting layer
A sanitized local snapshot powers fast filters, distributions, and expandable workstream records without exposing the operational sheet or depending on Google at request time.
Reliable public viewWhat the product made visible
Questions that required scanning 45 columns became immediate.
01
Where is work happening?
See statewide, island-specific, and USAPI or Guam deliverables without decoding the tracker’s geography shorthand.
02
What stage is each action in?
Separate in-progress work, items needing plans, completed deliverables, and pending contracts.
03
How does the work connect?
Open any grant or workstream to see each genuine deliverable, its program area, timing, geography, and planning year.
Working reconstruction
Explore the real workstream inventory.
Search all 27 workstreams and open the 84 underlying deliverables preserved from the original tracker.
Open the dashboard