Dashboard Overview
Google Sheets Integration Ready
Wire this interface to your Google Sheet for collaborative planning. Load custom Projects, Resources, Day Rates, and Allocations. Setup in seconds in the Data Integration tab.
📅 Rows represent projects. Expand rows to drill down into week-by-week resources, placeholder allocations, and forecast day rate calculations.
👥 Rows represent individual personnel and unfilled hiring gaps. Cumulative capacity over-allocations (>100%) are highlighted automatically in Glowing Red.
| Role / Individual Override | Classification Type | GBP Day Rate | Est. Weekly Cost (5-Day) |
|---|
Setup Guide: How to connect your Google Sheet
For this client-side app to access your sheet without OAuth tokens, publish it as a web link:
- Open your Google Sheet and click File > Share > Publish to Web.
- Select the respective sheet tab (e.g.
Projects) and format as Comma-separated values (.csv). - Copy the generated CSV link and paste it into the matching form field below.
- Ensure the sheet's header columns match the expected names exactly (case-sensitive!).
Import Named Resources directly into the active browser memory session via CSV files. Perfect for fast testing without configuring Google Sheets.
Expected CSV format headers:
Name,JobTitle,Type,Role,Status,Notes