Skip to content

No account required

Start a project

Field guide

Better decisions start with a checked number.

Practical methods for your own money, a client’s export, or the next business review. Every guide includes checks you can use without buying a tool.
Guides
51
Each answers
one question
Tool required
none

Start with your question.

All field guides

Guide

Why two people get different totals from the same spreadsheet.

It is almost never arithmetic. It is nearly always one of four structural problems, and each leaves a signature you can look for.

6 min read

Guide

How to tell a real finding from a coincidence.

Most findings that fall apart do so for one of four reasons, and all four can be checked in minutes.

7 min read

Guide

Five things to check before you trust a dashboard.

A dashboard is a set of decisions someone made and then hid. These are the five worth surfacing before you act on one.

5 min read

Guide

Finding duplicates that Remove Duplicates will not find.

The built-in tool compares cells. Real duplicates disagree in every field, which is exactly why they survived.

6 min read

Guide

Why Excel changes your numbers, and how to stop it.

Separate a display change from a damaged identifier, then protect the original value before import.

7 min read

Guide

Comparing two versions of a spreadsheet without drowning in false changes.

Three things break a file comparison, and all three make it report far more changes than happened, or far fewer.

6 min read

Guide

Dates in more than one format, and why it is worse than it looks.

A date column in two formats silently misplaces rows in every period comparison, and about a third of them cannot be recovered at all.

6 min read

Guide

Why your CSV opens as one column, and what that means.

The most common CSV complaint has nothing to do with the file, and the second most common one is invisible until somebody searches for a customer.

5 min read

Guide

Numbers stored as text, and the total that is quietly short.

The most dangerous data problem is the one whose symptom is a number that looks about right.

5 min read

Guide

Joining two spreadsheets, and the match rate nobody reports.

The join usually works. What goes wrong is that nobody checks how much of it worked.

6 min read

Guide

When the average describes nobody.

The mean is the right answer to a narrower question than most people are asking when they compute one.

5 min read

Guide

Six ways a chart misleads without containing a false number.

Almost every misleading chart contains only true numbers. The misleading part is the encoding.

6 min read

Guide

The data dictionary, and why inheriting a file without one costs a week.

The cheapest document in analytics to produce, and the one whose absence causes the most repeated work.

5 min read

Guide

Analysing survey results without measuring who answered.

Sample size does not fix a systematic absence, and it is the absence that breaks most survey conclusions.

7 min read

Guide

Why two dashboards give different numbers for the same thing.

Two people are usually both right about a number, and disagreeing about which number it is.

5 min read

Guide

Analysing survey results in Excel when half the answers are words.

A survey export mixes ratings, tick-boxes and sentences in one grid, and each of the three needs different handling before any of them can be averaged.

6 min read

Guide

Cleaning a messy spreadsheet in the order that saves the most work.

Order matters more than effort. Each repair done out of sequence has to be done again after the one it depended on.

6 min read

Guide

Turning a Power BI report into a presentation without screenshotting it.

A dashboard is built for monitoring and a meeting needs an argument. The move between them starts from the data model, not from the screen.

6 min read

Guide

The messy-file test: a reproducible way to check whether a data tool gets the numbers right

Most AI data tool reviews compare speed, price and charts. This one tests whether the numbers are correct.

9 min read

Guide

We compute every figure twice. Here is what happens when the two answers differ.

A language model may decide what to compute. It never decides what the answer is.

8 min read

Guide

Eight things that are actually wrong with your messy CSV

A CSV is not messy in general. It is usually broken in one of eight recognizable ways.

9 min read

Guide

A dashboard is not a set of charts

A dashboard is not a set of charts. It is a small number of decisions, each backed by a number someone can verify.

7 min read

Guide

A deck built from a spreadsheet has to survive being questioned

A data deck succeeds in the meeting after the one where it was presented, when somebody asks where a number came from.

7 min read

Guide

The famous spreadsheet errors were not arithmetic errors

The famous failures were not bad maths. They were correct calculations performed on the wrong rows, ranges or types.

9 min read

Guide

Julius AI alternatives, and the four questions that actually decide between them

Nearly every comparison is written by one of the products on it. This one says so, and includes the cases where the competitor is the better choice.

9 min read

Guide

A close that balances is not the same as a close that is right

A close that balances can still be wrong. These checks catch the structural failures a trial balance cannot see.

8 min read

Guide

The question is not whether the model is clever. It is whether it is allowed to decide the answer.

The important question is not whether the model is clever. It is whether the model is allowed to decide the answer.

9 min read

Guide

Budget vs actual: explain the gap before you change the plan

Separate a real performance gap from timing, mapping errors, and missing transactions.

4 min read

Guide

Which freelance clients are actually profitable?

Find the clients that use your capacity well, with revisions and admin included.

4 min read

Guide

Build an executive KPI report that leads to a decision

A concise operating review with a revenue bridge the reader can check.

4 min read

Guide

Turn a bank CSV into a cash-flow picture you can trust

Separate real spending from transfers, refunds, and card settlements.

4 min read

Guide

Build an accounts receivable aging report from an export

Distinguish unpaid invoices, overdue balances, and allocation exceptions.

4 min read

Guide

Customer retention cohorts: compare customers of the same age

Compare returning customers against the group that had a chance to return.

4 min read

Guide

Calculate a reorder point without confusing sales with demand

A reorder point is a trigger, with assumptions you should be able to inspect.

4 min read

Guide

ROAS is a revenue ratio. Check contribution before scaling spend.

A revenue multiple does not tell you what the included orders contributed.

4 min read

Guide

Why multiple-response survey percentages can exceed 100%

Choose whether the chart describes people or selections before calculating it.

4 min read

Guide

Did sales grow because of price, volume, or product mix?

An increasing average selling price does not prove any individual price rose.

4 min read

Guide

Measure donor retention without counting gifts as people

Separate returning relationships from transaction counts and gift revenue.

4 min read

Guide

Employee turnover rates: make the denominator explicit

Compare workforce movement only after the event, population, and period agree.

4 min read

Guide

CSV UTF-8 or CSV: which should you use?

Choose the right CSV encoding and delimiter in Excel. Preserve accented names, test an import, and avoid overwriting a damaged source file.

4 min read

Guide

Keep leading zeros and long IDs.

Import postal codes, account numbers, and long IDs as text in Excel. Learn which repairs are possible and how to verify a safe round trip.

4 min read

Guide

Combine monthly CSVs without counting twice.

Append monthly CSV exports with a repeatable schema, source-file tracking, and overlap checks. Includes a worked reconciliation and failure checklist.

4 min read

Guide

Why your PivotTable total is wrong.

Find PivotTable total errors caused by Count versus Sum, incomplete ranges, duplicates, and averaged percentages. Includes a denominator example.

4 min read

Guide

Weighted percentages need the right base.

Calculate weighted percentages from counts or SUMPRODUCT in Excel. See why averaging rates can mislead and how to handle zero or missing bases.

4 min read

Guide

Blank or zero? The difference changes the result.

Keep missing values separate from real zeros. Compare available-case and zero-filled averages, report coverage, and avoid misleading charts.

4 min read

Guide

Likert results: show the whole distribution.

Analyze ordered survey responses with distributions, clear bases, and careful score assumptions. Includes a worked satisfaction example and small-group checks.

3 min read

Guide

Survey response and completion use different bases.

Distinguish survey participation, completion, and item response. Work through clear denominators, open-link limitations, and missing eligibility data.

4 min read

Guide

Match Stripe payouts to the bank.

Match Stripe settlement batches to bank deposits using payout IDs, signed activity, fees, refunds, and timing. Includes a synthetic reconciliation.

4 min read

Guide

Why Shopify sales and payouts differ.

Understand why Shopify sales and payouts differ. Check report definitions, fees, refunds, timing, payment providers, and order-line duplication.

4 min read

Guide

Read a GA4 export without double-counting.

Check GA4 CSV scope, totals, nonadditive users, and rate denominators before charting. Distinguish report exports from raw event data.

4 min read

Guide

Open a Parquet file without Python.

Inspect Parquet without writing Python. Preserve column types, check nested data and memory limits, and understand the risks of converting to CSV.

4 min read