SWC National Projects v3

SWC National Projects

Tender & EOI Tracking · Staff Allocation · Phase Planner · v3

📊

Drop .xlsm + involvement .xlsx here

Multiple files accepted · Stays on your computer — nothing uploaded

Drop your xlsm + involvement xlsx, or to auto-load on open.
Involvement + manual projects are saved inside the involvement xlsx — no data leaves your browser.

Nat. Projects

—

Staff Active

—

Overloaded

—

Avg Load (pts)

—

Peak Month

—

Filter:

EOI

RFT / Tender / ECI

Award

Involvement:

L

M

H

= opacity shows involvement level

Click "Edit ✏" to set phase involvement

SharePoint / Auto-Refresh

URLs saved in this browser only — nothing is sent to any server

Main file — SharePoint direct download URL (.xlsm)

SharePoint → open file → ⋮ → Details → "Direct link" or copy download URL

Involvement file — SharePoint direct download URL (.xlsx)

Save involvement once, upload to SharePoint, then paste its download URL here

Involvement folder — SharePoint folder URL

After saving, this folder opens in a new tab so you can upload the involvement file

ℹ Dashboard auto-loads from SharePoint whenever the xlsm URL is set above. Clear the URL to disable.

Add Live Project

Not linked to xlsm — stored in browser only

Project Name *

Client

Start Date *

End Date *

Staff & Involvement