Project Dashboard Template for Agency & Consulting Project Managers — Tableau .twb with Budget Burn, Unbilled Value, Days Past Due and RAG Rating from Your Own Timesheet Export

Point it at your own export; 8 calculated fields do the maths.

Project Dashboard Template for Agency & Consulting Project Managers — Tableau .twb with Budget Burn, Unbilled Value, Days Past Due and RAG Rating from Your Own Timesheet Export
Preview of the file you get

Full version · $12 →

How it works
  1. Look at the preview of the file below.
  2. Pay once and download the file right away.
  3. Open it and fill in your own details.

What you get: This page is the working piece.

Full version →

Point it at your own export; 8 calculated fields do the maths. Budget burn against contracted value, unbilled value, gross margin on your cost rate, days past due, and a red-amber-green rating that only rates live work. Tableau Desktop's free trial runs 14 days — hand-writing these formulas is what eats it. 5 views and 1 dashboard, and the .twb carries no data: it reads the CSV sitting next to it, so the hours you worked but never billed stop hiding inside a 4,000-row export.

Calculated fields included (8)

Hours Variance (actual minus planned)

Formula: SUM([Actual Hours]) - SUM([Planned Hours])

Uses: Actual Hours, Planned Hours

Budget Burn Ratio (delivery cost over contracted value; above 1.00 the project costs more than it sells for)

Formula: SUM([Actual Hours] * [Cost Rate]) / SUM([Planned Hours] * [Billable Rate])

Uses: Actual Hours, Cost Rate, Planned Hours, Billable Rate

Unbilled Value (worked hours that never reached an invoice, priced at your own rate)

Formula: SUM(([Actual Hours] - [Billable Hours]) * [Billable Rate])

Uses: Actual Hours, Billable Hours, Billable Rate

Gross Margin Ratio (billed value minus delivery cost, over billed value)

Formula: (SUM([Billable Hours] * [Billable Rate]) - SUM([Actual Hours] * [Cost Rate])) / SUM([Billable Hours] * [Billable Rate])

Uses: Billable Hours, Billable Rate, Actual Hours, Cost Rate

Days Past Due (finished work against its baseline; live work against today, negative means days still left)

Formula: IF [Status] = 'Complete' THEN DATEDIFF('day', [Planned End Date], [Actual End Date]) ELSE DATEDIFF('day', [Planned End Date], TODAY()) END

Uses: Status, Planned End Date, Actual End Date

Delivery RAG (rates live work only; edit 0.85 to your own amber gate)

Formula: IF [Status] = 'Complete' THEN 'Closed' ELSEIF [Planned Hours] = 0 THEN 'Grey - no baseline' ELSEIF [Actual Hours] > [Planned Hours] THEN 'Red - over hour baseline' ELSEIF [Days Past Due] > 0 THEN 'Red - past due date' ELSEIF [Actual Hours] >= [Planned Hours] * 0.85 THEN 'Amber - 85 percent of hours used' ELSE 'Green - on plan' END

Uses: Status, Planned Hours, Actual Hours

Utilisation Ratio (billable hours over hours actually worked)

Formula: SUM([Billable Hours]) / SUM([Actual Hours])

Uses: Billable Hours, Actual Hours

Realised Rate per Hour (billed value over every hour worked; the gap to your rate card is what the unbilled hours cost)

Formula: SUM([Billable Hours] * [Billable Rate]) / SUM([Actual Hours])

Uses: Billable Hours, Billable Rate, Actual Hours

Columns your CSV must have (12)

ColumnTypeRole
Project Namestringdimension
Clientstringdimension
Project Managerstringdimension
Statusstringdimension
Planned Start Datedatedimension
Planned End Datedatedimension
Actual End Datedatedimension
Planned Hoursrealmeasure
Actual Hoursrealmeasure
Billable Hoursrealmeasure
Billable Raterealmeasure
Cost Raterealmeasure

CSV header row

Project Name,Client,Project Manager,Status,Planned Start Date,Planned End Date,Actual End Date,Planned Hours,Actual Hours,Billable Hours,Billable Rate,Cost Rate

File you connect: project_time_and_budget.csv

Worksheets (5)

Dashboards (1)

Get the complete version $120

This page is the working piece. The full pack has everything below.

Point it at your own export; 8 calculated fields do the maths. Budget burn against contracted value, unbilled value, gross margin on your cost rate, days past due, and a red-amber-green rati

Two figures you can check before you buy, both published by Tableau itself. Tableau Desktop is offered as a 14-day free trial, and Tableau Public is free with no time limit — so the software is not the cost here, the person who wr

Buy the full version — $12

Need more than this one? ReadyStack Pass opens all 679 files and 561 full versions — $29/month or $199/year. See the Pass →

Email me this result
A copy of what you see above, in your inbox — the tool stays free, nothing here is locked.
ENDEJAESPT

Find a tool

Questions and answers

What does this page do?

Point it at your own export; 8 calculated fields do the maths.

Is it free?

The preview on this page is free. The full version ($12) adds: This page is the working piece.

How do I use it?

1. Look at the preview of the file below. 2. Pay once and download the file right away. 3. Open it and fill in your own details.

Ask about this tool

One question, answered by the person who built it. Your email only if you want the answer sent.

Privacy: your e-mail is used only to send you the answer. A question appears on this page only after it is answered, without your e-mail.

For a team or company: for an invoice with your company details, a quote or several licences, write to [email protected].

More in Planners & spreadsheets See all →