For people who run the office

AI can write the formula. Here's how to know it's right.

Working formulas, queries and scripts for Excel, Google Sheets, SQL, HubSpot and Slack. Each one is worked through on sample data with a known answer, and says how it was checked.

  • CheckedRun on sample data, not just written.
  • DatedPrices re-checked at least every 3 months.
  • PrivateTools run in your browser. Nothing is uploaded.
=SUM(B2:B3)/SUM(C2:C3)
RowABCDRemove
1ProjectDoneTotalRate
2100.0%
30.0%
4Team11010.0%
Share of tasks actually done
10.0%
What averaging the percentages says
50.0%
Type over any shaded cell, add your own projects, or paste rows from a spreadsheet.Read the guide

Covers the software you already use

Guides by software

Pick the one you're stuck in. Each list has every guide for it, newest first.

In numbers

A small site, checked properly

Every number here is counted when the site is built, not typed in by hand.

  • 37guides, each ending with a note on how it was checked
  • 4SQL guides whose queries run on DuckDB, MySQL and PostgreSQL
  • 23free tools that run in your browser
  • 0overdue price checks across 2 guides that name a plan. The build stops before one can go live.

How a guide is checked

Four steps before a guide goes live

The note at the end of each guide says which of these it passed.

  1. Sample data

    Small enough to check by eye, with the right answer worked out first.

  2. Run it

    SQL on three databases, formulas in HyperFormula, an independent spreadsheet engine.

  3. Compare

    Results must match the table on the page, or the build refuses to publish.

  4. Date it

    Published and updated dates on every guide. Prices and plans get a next-check date.

Questions

Common questions

Short answers. About has the long ones.

Why not just ask an AI for the formula?

Do, and then check it. AI is good at writing formulas and poor at noticing when a plausible one gives the wrong total. Each guide here comes with sample data and the answer it should produce, so you can test what you were given.

Has every guide been run?

No, and each guide says which. SQL runs on three databases, and many formulas run in an independent spreadsheet engine. Apps Script is reviewed against Google's documentation but usually not run in a live account.

How current are prices and plan details?

A guide that names a plan shows when it was checked and when it will be checked next, at most three months apart. The build refuses to publish once a check is overdue. How prices are kept current

Do the tools upload my data?

No. They run in your browser. The completion rate tool can keep your rows in this browser so they're there next time. Nothing is sent to Producfy.

What's checked next

The guides and tools planned for the next three months, and the price checks due. Last updated .

Esc