Project Delivery Dashboard

Team Members

Assignees for weekly actions.

Program Managers

PMs available when adding projects.

Utilisation Sheet URL

Link the Employees Timesheet Status Google Sheet. This powers the Utilisation view on the Dashboard.

Available Hours

Used to calculate total available hours in the utilisation section.

Hours per week

Working days/month

These can be overridden per month in the utilisation filter.

Data

All data is stored in Cloudflare KV — persistent across sessions and deployments.

✓ Connected to Cloudflare KV

Billable Hours (weekly)

Committed billable hours per project, entered manually by week. This is what powers the Billable % in Weekly Utilisation — a project's billable hours don't drop just because someone's on leave that week, so it has to be set here rather than derived from logged time. Leave a cell blank for 0.

Month:

Slack Notifications

When a new action is assigned on a project, a message posts to the Slack channel your Incoming Webhook is connected to, tagging the assignee.

Requires SLACK_WEBHOOK_URL set as a Worker env var (one-time, in Cloudflare — see chat for setup steps). To get real @mentions rather than plain text, map each team member to their Slack Member ID below — find it via their Slack profile → ⋯ More → Copy member ID. Anyone left unmapped still gets tagged by name, just without a real ping.

Sends a test ping to confirm the webhook URL is wired up. If it fails you'll see the exact error in a toast.