Project portfolio (sample)
Past due
4 open items past their date| Name | Owner | Due | Late by | Status |
|---|---|---|---|---|
| CRM migration | Omar | Sep 29 | 19 days | Red |
| SSO rollout | Kim | Sep 30 | 18 days | Amber |
| Data warehouse | Priya | Oct 2 | 16 days | Amber |
| Billing revamp | Chris | Oct 2 | 16 days | Red |
What this file says
6 findings, most important firstOpen projects
By statusNowBefore (thin)
Due next
Open, soonest first- Oct 21Pricing page testsMayain 3 days
- Oct 30Security auditKimin 12 days
- Nov 4Staff trainingAnain 17 days
- Nov 6Expense toolChrisin 19 days
- Nov 13Customer researchSamin 26 days
Overdue projects
NowBefore (thin)
Spend against budget
Line: 100%NowBefore (thin)
Spend on open projects
NowBefore (thin)
Rows read
18 counted6 left out
- Rows in the file
- 26
- Title rows skipped
- 1
- Totals rows skipped
- 1
- Archived
- 2
- Outside the definition
- 4
- Blank counted cells
- 0
Archived: rows 25, 26
Three weeks
| Week | Open projects | Overdue projects | Projects at Red | Spend on open projects |
|---|---|---|---|---|
| Oct 4 | 19 | 4 | 2 | $2.44M |
| Oct 11 | 19 | 4 | 3 | $2.58M |
| Oct 18 | 18 | 4 | 3 | $2.54M |
Projects at Red
NowBefore (thin)
Why this screen: Due date marks when each project is due, and an empty Done date shows what's still open, so the screen leads with what's late.