WSU Water Conservation

Water Conservation Meeting Dashboard • WSU Facilities Services

Restricted Access

Enter the dashboard password to continue.

Loading water data...

Water Conservation Meeting Dashboard

Anomaly Review & Task Tracking • WSU Facilities Services

Campus Metering Steam Plant Operations Energy Cost Projection Folder Map
Dark Mode

All Sites

Shows all metered building/service pairs. Click any row to expand year-over-year charts. Spike anomalies flag months with >100% usage increase vs neighbor-month average (irrigation season excluded). Winter irrigation flags any usage Nov–Feb. Use Anomalies Only to filter to flagged buildings.
Issue ID Bldg # Building Name Service Status Assigned To Description Action Note Entry Date WO# Actions

Meeting Workflow

The Water Conservation Task Force meets monthly. This dashboard replaces the old side-by-side SkySpark report + Smartsheet workflow with a single screen.

1
Before the Meeting

Update water data from SkySpark (see "Updating Data" below). Export the task list from Smartsheet as CSV and import it into the Task Tracker tab. Check the Data Info tab to verify data quality.

2
During the Meeting

Review anomalies on the Anomaly Review tab. Create tasks for new issues. Update existing tasks with status changes, assignments, and notes.

3
After the Meeting

Export updated tasks to CSV from the Task Tracker tab. Upload the CSV to Smartsheet. Optionally print meeting minutes with Ctrl+P.

Updating Data from SkySpark

Water data is exported from the SkySpark wsumeters project at skyspark.fais.wsu.edu. Run these commands in the SkySpark Shell to refresh the data files:

Export Commands

FileSkySpark Shell Command
domestic_water.jsonview_water(2024-01-01..2026-02-28, "Site", "Domestic", "Export Format")
irrigation.jsonview_water(2024-01-01..2026-02-28, "Site", "Irrigation", "Export Format")
Tip: Update the end date in each command to include the latest complete month. For example, if it's March 2026, change the end date to 2026-03-31.

After Export

  1. Save the Domestic export as domestic_water.json
  2. Save the Irrigation export as irrigation.json
  3. Upload both files to the data/ folder on GitHub (replace existing files)
  4. Wait ~1 minute for GitHub Pages to deploy, then hard-refresh the dashboard (Ctrl+Shift+R)
Note: Both files are shared with the Campus Metering dashboard. Updating them here updates metering data too. See the Data Info tab for data quality checks and verification after uploading.

Smartsheet Sync (Import / Export)

Tasks are synced between this dashboard and Smartsheet via CSV files. Follow this cycle each meeting:

  1. Open Smartsheet and export the task list as a CSV file
  2. On the Task Tracker tab, click "Import from Smartsheet" and select the CSV
  3. Review the import summary (e.g., "12 updated, 35 unchanged, 0 new")
  4. During the meeting, create new tasks and update existing ones on the dashboard
  5. After the meeting, click "Export to Smartsheet" to download the updated CSV
  6. Open Smartsheet and import the downloaded CSV to sync changes back
Important: Tasks are stored in your browser's local storage. If you clear browser data, tasks will be lost. Always export to CSV after each meeting as a backup.

Tab Guide

Anomaly Review The main meeting screen. Shows all metered building/service pairs with KPI summary cards. Click any row to expand year-over-year charts and data tables. Use Anomalies Only to filter to flagged buildings. Create tasks directly from any row.
Task Tracker Manage all water conservation tasks. Filter by status, search by building or assignee, edit tasks inline, and import/export CSV files for Smartsheet sync.
Historical Trends Campus-wide domestic and irrigation water trends with anomaly markers. Includes a top-10 buildings chart for identifying the biggest consumers.
Building Index Searchable directory of all buildings with domestic and irrigation water badges. Click any building to expand its monthly usage detail.
Data Info Data source details, SkySpark export commands, unit conversions, file inventory, and automated data quality checks with integrity verification.

Anomaly Types Explained

Spike Anomalies

A building's monthly usage is compared to the average of the same month in prior years (Year-over-Year). If usage is more than 100% higher than that average, it's flagged as a spike. This approach accounts for normal seasonal patterns on a university campus.

SeverityColorThreshold
HighRed left borderMore than 200% above neighbor average
MediumOrange left border100% – 200% above neighbor average
Irrigation season exclusion: Spikes on irrigation meters during May through September are intentionally excluded. Usage ramp-up during irrigation season is expected and not anomalous. Only off-season irrigation spikes are flagged.

Winter Irrigation Alerts

Any irrigation water usage during November, December, January, or February is flagged. Irrigation systems should be winterized during these months, so any usage may indicate a leak or a valve left open.

TypeColorWhat It Means
Winter IrrigationGreen left borderIrrigation usage detected in a winter month — investigate for leaks or open valves

Task Status Guide

Use these statuses consistently to match the Smartsheet task tracker shared with the committee.

StatusWhen to Use
Open – Not StartedNew task, not yet investigated
Open – In ProgressSomeone is actively working on it (e.g., meter check scheduled, work order submitted)
Open – MonitorInvestigation done, watching for changes (e.g., usage came down after repair, monitoring for recurrence)
Closed – ResolvedIssue fixed (e.g., leak repaired, meter corrected, multiplier fixed)
Closed – Not ResolvedIssue investigated but no fix needed (e.g., usage explained by occupancy changes, seasonal patterns, or construction)

Quick Tips

📈

Expand anomaly rows — Click any row in the anomaly table to reveal a line chart and monthly data table for that building.

🔍

Sort & filter columns — Click a column header to sort. Click the menu icon (☰) on a column to filter by specific values.

💾

Tasks auto-save — All task changes save automatically to your browser. But always export to CSV as a backup before closing!

🌙

Dark mode — Use the slider toggle in the header to switch between light and dark themes. Your preference is saved.

🖨

Print meeting minutes — Press Ctrl+P (or Cmd+P on Mac) from any tab. The print layout shows the anomaly table and open tasks in landscape format.

🛠

Bulk task creation — On the Anomaly Review tab, click "Create Tasks for All New Anomalies" to generate tasks for every unassigned anomaly at once.

Troubleshooting

Dashboard shows "Error loading data"
Verify that domestic_water.json and irrigation.json exist in the data/ folder on GitHub and contain valid JSON with a "rows" array.
Import shows "0 rows imported"
Check that the CSV has 11 columns with exact case-sensitive headers, and is comma-separated (not tab or semicolon). If exported from Excel, save as "CSV (Comma delimited)".
Tasks disappeared after clearing browser data
Tasks are stored in browser localStorage. Import your most recent CSV backup: Task Tracker tab → "Import from Smartsheet".
No anomalies detected
Data may have fewer than 3 months, or no buildings have spikes exceeding 100% of their neighbor-month average. Irrigation spikes during May–Sep are excluded by design.
Filter shows "No anomalies match"
Click "All Services" to reset the filter bar, then check each column header for active filters (highlighted menu icon). Clear column filters to see all anomalies.

Data Sources

Data Period: Loading...

Source: SkySpark wsumeters project at skyspark.fais.wsu.edu

Export Method: Existing view_water function with Export Format, run via Shell

Export Commands

Run these in the SkySpark Shell to refresh data:

view_water(2024-01-01..2026-02-28, "Site", "Domestic", "Export Format")

view_water(2024-01-01..2026-02-28, "Site", "Irrigation", "Export Format")

After export: Save each file as domestic_water.json and irrigation.json, then upload to the data/ folder on GitHub.

Unit Conversions

Raw values exported in gallons. Conversion applied in this dashboard:

  • Domestic Water: gal ÷ 1,000 = kGal
  • Irrigation: gal ÷ 1,000 = kGal

File Inventory

FileRowsDescription

Data Quality & Verification

Integrity Checks

CheckResult

KPI Cross-Check

Independent recalculation from raw data vs. dashboard KPIs

UtilityRaw SumConvertedDashboard KPIMatch

Per-Utility Breakdown

UtilityRowsValidNA/InvalidNegativeZeroBuildingsDate Range

WSU Water Conservation Meeting Minutes

Anomalies Reviewed

Open Tasks

Next Meeting Date: _________________________     Notes: _________________________