Designers Tracked
—
this period
Studio Avg Weekly Score
—
Avg Utilization
—
logged vs expected
Weeks of Data
—
No weekly data yet
Go to Weekly Data Entry to get started.
Total Projects
—
Avg Client Score
—
external score avg
Avg Budget Adherence
—
Score Mismatches
—
internal vs client gap >1.5
No project data yet
Add projects or upload your project management sheet.
📤 Step 1 — Upload Timely CSV
Drop Timely CSV here
Logged hours auto-populate per designer
📅 Step 2 — Week Details
ℹ️ Date range and week number are auto-detected from your Timely CSV. Click any date to adjust manually.
W1 = first week of January
No range selected
✏️ Step 3 — Scores Per Designer
ℹ️ Logged hours auto-fill from Timely CSV filtered to selected date range. Enter declared days, leaves, and 3 metric scores. Expected hours = (Declared Days − Leaves) × 8.6
Studio Declared Days this week:
Applies to all designers — override individually per row if needed. Resets each week.
| Designer | Declared Days | Leaves | Expected Hrs | Logged Hrs | Learning (1–5) | Collab (1–5) | Upskilling (1–5) | Remarks |
|---|
📤 Upload MS Forms (Client Feedback)
Drop MS Forms Excel here
Client ratings matched by job number
📤 Upload Project Management Sheet
Drop Project Management Sheet here
Auto-fills project name, client, AM, category by job number
➕ Add / Close a Project
Job Details (AM Entry)
Select designer(s)
Select AM
Manual — not in Timely export
Job Ratings (Raksha / Sheetal)
Timely Data
Client Feedback (MS Forms)
➕ Add Team Member
ℹ️ Data Integrity
✅ Names capitalised automatically
✅ Duplicates blocked
✅ Ex-employees hidden from dropdowns, data preserved
⚠️ Members with data cannot be deleted — use Ex-Employee
✏️ Rename updates all records automatically
Team Members
| Name | Role | Status | Data Records | Actions |
|---|
🟢 RAG Thresholds — Weekly Score
Set the score boundaries that determine whether a designer's weekly score is Green, Amber or Red. Changes apply immediately across all views and historical data.
Score at or above this = 🟢 Strong
Score below this = 🔴 Needs Support
Preview
🟢 RAG Thresholds — Project Score
Set the score boundaries for project scores. These are applied independently from weekly score thresholds.
Score at or above this = 🟢 Strong
Score below this = 🔴 Needs Support
Preview
⚠️ About Changing Thresholds
• Threshold changes apply immediately to all data — including historical records. A designer who was green last month may become amber after a threshold change.
• This is intentional — it means you can calibrate thresholds as you collect more data and understand what scores are realistic for your team.
• Recommended approach: Start with the defaults (Green ≥ 4.0, Red < 2.5) for the first 6–8 weeks, then review once you have a realistic distribution of scores.
• Thresholds are saved in the browser and persist between sessions.
⏱ Timely CSV
Upload Timely CSV
.csv · weekly export
📋 MS Forms Excel
Upload MS Forms Excel
.xlsx · client feedback
📊 Project Management Sheet
Upload Project Management Sheet
.xlsx · re-upload weekly
📦 Data Status
Weekly records—
Project records—
Active team members—
Client responses loaded—
Project mgmt rows—