Help
Help center
Everything you need to set up a Metricvalley workbook, check where it has been tested, and get help if something doesn't work as described.
Setup guides
Step-by-step instructions for each template, written for the version you download today. The times given are estimates.
- Client Profitability Tracker setup From download to your first Dashboard: unzip, open, fill in Setup, list your clients, add the month's rates, log the month and pick the report month. About 10 minutes, plus about 1 minute per client project. Includes where the settings moved to Setup and how to move 1.x rows across.
- Retainer Burn & Capacity Planner setup From download to your first Dashboard: your settings on Setup, your team, your retainers and this month's hours. About 10 minutes, plus about 1 minute per retainer.
- Cash & Runway Planner setup From download to months covered: your settings on Setup (start month, opening cash and buffer), money in, money out, then the scenarios. About 10 minutes, plus about 1 minute per row.
- Project Quote Calculator setup From download to a printed quote: your business details and pricing policy on Setup, team rates, a first quote and the page you send. About 10 minutes, plus about 1 minute per role and scope line.
- Client Profitability Report Pack setup From download to the six pages in Power BI Desktop: open the template, paste the path to your tracker and refresh. About 5 minutes once Power BI Desktop is installed.
- Freelancer Cash at a Glance setup From download to your first weekly check: your settings on Setup, your balance, your invoices and bills, then Needs attention on At a Glance. About 5 minutes, plus about 1 minute per row.
- Maker Pricing Calculator setup From download to your first prices: your rate and overheads on Setup, materials, channels, products and recipes, then the Dashboard. About 10 minutes, plus about 3 minutes per product.
- Bills & Renewals Tracker setup (Weeksheet by Metricvalley) From download to your first weekly check: your settings on Setup, your bills, then the Dashboard. About 5 minutes, plus about 1 minute per bill.
- Safe-to-Spend Budget setup (Weeksheet by Metricvalley) From download to your first weekly check: your settings and payday on Setup, your balance, then the bills and savings. About 5 minutes, plus about 1 minute per bill.
- Paperwork & Deadlines Tracker setup (Weeksheet by Metricvalley) From download to your first weekly check: your settings on Setup, your documents and deadlines, and the date to start on each one. About 5 minutes, plus about 1 minute per item.
- Day-Rate & Docket Reconciliation setup From download to your first reconciled month: your settings on Setup, your rate card and POs, the roster, the signed dockets, then the Dashboard. About 15 minutes, plus about 1 minute per roster line and 20 seconds per docket.
More guides will be added here as each new template is released.
Compatibility
- Where our templates are tested Which spreadsheet apps each release has been tested in, with version and date. Every environment is marked "tested" or "not yet tested". "Probably works" is never listed as compatible.
- Changelog What changed in each version, and what is in progress.
Frequently asked questions
Read the FAQ for answers about contribution, Excel versions, currencies, the Google Sheets edition, licenses, updates, refunds and support.
Three quick answers:
- Which file do I open? The file ending in
-blank.xlsx. Keep the-worked-example.xlsxfile as a reference. - Which cells do I type in? Yellow cells: you type. Leave every other cell to the workbook.
- What does "Review" mean? A row with a missing detail, a duplicate or a missing exchange rate. It stays visible and is left out of the totals until you fix it. The check columns on the Work Log name the problem.
Contact support
We reply to every message within 1 business day. Business days are Monday to Friday, Australian Eastern time. A message sent on a Friday afternoon in the US arrives on Saturday in Australia, so expect a reply by the end of Monday, Australian Eastern time.
- Use the support form, or
- Email [email protected]
To get a useful answer on the first reply, include:
- The template and version. The version number is on Start Here. The Client Fees & Delivery Tracker 1.x files have no Start Here sheet; their version is in the file name (for example
v1.1.0-rc1). - Your Excel version and build, from File > Account > About Excel (Windows) or Excel > About Excel (Mac).
- The sheet and row, what you expected and what you saw.
Send demo or redacted data only. Leave out payment details, passwords and real client records.
Included: help getting the workbook working as described, and fixes for anything that doesn't. Not included: custom setup, importing your data, redesigning formulas, or accounting and tax advice.
Bought on Etsy? Message us from your Etsy order page so your order and messages stay together.