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

What you get: This page is the working piece.
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.
Formula: SUM([Actual Hours]) - SUM([Planned Hours])
Uses: Actual Hours, Planned Hours
Formula: SUM([Actual Hours] * [Cost Rate]) / SUM([Planned Hours] * [Billable Rate])
Uses: Actual Hours, Cost Rate, Planned Hours, Billable Rate
Formula: SUM(([Actual Hours] - [Billable Hours]) * [Billable Rate])
Uses: Actual Hours, Billable Hours, Billable Rate
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
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
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
Formula: SUM([Billable Hours]) / SUM([Actual Hours])
Uses: Billable Hours, Actual Hours
Formula: SUM([Billable Hours] * [Billable Rate]) / SUM([Actual Hours])
Uses: Billable Hours, Billable Rate, Actual Hours
| Column | Type | Role |
|---|---|---|
Project Name | string | dimension |
Client | string | dimension |
Project Manager | string | dimension |
Status | string | dimension |
Planned Start Date | date | dimension |
Planned End Date | date | dimension |
Actual End Date | date | dimension |
Planned Hours | real | measure |
Actual Hours | real | measure |
Billable Hours | real | measure |
Billable Rate | real | measure |
Cost Rate | real | measure |
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
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 — $12Need more than this one? ReadyStack Pass opens all 679 files and 561 full versions — $29/month or $199/year. See the Pass →
Point it at your own export; 8 calculated fields do the maths.
The preview on this page is free. The full version ($12) adds: This page is the working piece.
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.
One question, answered by the person who built it. Your email only if you want the answer sent.
For a team or company: for an invoice with your company details, a quote or several licences, write to [email protected].
Restaurant Inventory SpreadsheetFilled example inside: 8 weeks of a made-up bistro with 43 items and 10 dishes – the Variance sheet finds 12.5 lb of ribeye ($236.25) that…FreeFull version $11.99
Tableau Sales Dashboard Template — Margin, Target Attainment and Rep RankingPoint it at your own CSV export and every calculation is already written: a Tableau consultant bills 110-150 USD per hour and a starter…FreeFull version $120
Wedding Planning Template for US Couples Booking a Catered Reception — Guest List, Budget and True Cost per Guest (Excel & Google Sheets; CSV imports into Airtable)The per-plate price on a catering quote is not what you pay: the venue's service charge is added on top of it, and in many US states the…FreeFull version $143.99
Amazon FBA Profit & Margin CalculatorSee your real net profit per unit after Amazon's 15% referral fee (min $0.30), FBA and storage - before you order stock that sells at a…FreeFull version $60
Cold Email Laws by Country: Client List Consent CalculatorWriting cold outreach for clients in several countries? US and UK company contacts run on opt-out rules; Canada (CASL, up to $10 million…FreeFull version $21
Dual Subtitles Study Hours Calculator: Real FSI HoursDual subtitles study hours: FSI counts 23 class + 17 self-study hours a week. Spanish = 1,200 hours. See the weeks your daily watching…FreeFull version $21ReadyStack
Calculators, templates and deadlines for the rules that change every year — free in your browser.