SVPC Space Utilization Dashboard

Interactive Plotly dashboards showing room and building utilization at Silicon Valley Probiotic Club (SVPC), deployed via GitHub Pages.

All charts are self-contained HTML files — no server required. Share them by email or open docs/index.html locally.

---

Live Dashboard

View the dashboards on GitHub Pages

---

What's Inside

Utilization Reports

Chart	File	Description
Weekly Utilization by Building	weekly_dashboard.html	Stacked bar chart of utilization % by building (or individual room) broken down by day of week. Week and room dropdowns.
Room Utilization Over Time	time_series.html	Line chart of per-room utilization since January 2025. Toggle between weekly and daily granularity; filter by building or room.

Forecasting

Chart	File	Description
Prophet 6-Week Daily Forecast	prophet_forecast.html	Facebook Prophet with US federal holidays, summer break (Jun 12–Aug 18), weekly + annual seasonality, and widening 95% confidence bands from 1,000 posterior samples. Recommended.
Weekly Utilization Forecast	forecast.html	Holt-Winters exponential smoothing (4-week seasonality), 12-week horizon, 95% prediction intervals.
Daily Utilization Forecast	daily_forecast.html	Holt-Winters with 7-day seasonality, 30-day horizon per room.

People & Headcount Analysis

Chart	File	Description
Event Headcount Histogram	people_histogram.html	Distribution of event headcounts (#People) per room with summary statistics.
People Capacity Utilization	people_capacity.html	Daily person-density % = actual person-hours ÷ max possible person-hours. Includes Prophet 42-day forecast.
Benford's Law Analysis	benfords.html	First-digit distribution of headcounts vs. Benford expected frequencies. KS statistic + chi-square test per room.

---

Data

• Source: eSpace scheduling system export (2025-2026_espace_crop.tsv) — not committed to this repo
• Cutoff: April 12, 2026 (future bookings excluded)
• Rooms: 11 selected rooms across 5 buildings

Building	Rooms
Building 200	203 Fireside Room
Building 300	304 All Purpose Room, Fellowship Hall
Building 500	501 Soule Hall
Phoenix Center	701 Kitchen, 702 Coleman Room, 703 Gym, 750 Youth Room, 751, 752 Children's Room
Sanctuary	Sanctuary

---

Tech Stack

Layer	Tools
Language	Python 3.11+
Data	Polars
Forecasting	Facebook Prophet, statsmodels (Holt-Winters)
Visualization	Plotly (CDN, self-contained HTML)
Package management	uv
Linting / types	ruff, mypy
Testing	pytest

---

Running the Pipeline

Requires the raw 2025-2026_espace_crop.tsv source file (not in this repo).

# Install dependencies
uv sync

# Run the full pipeline: clean → analyze → generate charts
uv run space-use

# Run tests
uv run pytest

The pipeline:

1. Loads and cleans the eSpace TSV (deduplication, room filtering, category mapping, hour-block expansion)
2. Computes utilization metrics and people-density metrics
3. Fits forecasting models (Holt-Winters + Prophet per room)
4. Writes 8 self-contained HTML charts to docs/

---

Project Structure

src/space_use/
  analysis/         # Utilization metrics, forecasting, people analysis
  ingestion/        # Raw TSV loader
  pipelines/        # Orchestration (cleaning pipeline)
  transforms/       # Dedup, filtering, hour-block expansion, building assignment
  utils/            # Logging
  visualization/    # 8 chart generators (custom HTML + Plotly)
  cli.py            # Typer CLI entry point
tests/unit/         # 29 unit tests
configs/            # settings.toml (paths, hour range, building map)
docs/               # Generated HTML — GitHub Pages root