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.
| Row | A | B | C | D | Remove |
|---|---|---|---|---|---|
| 1 | Project | Done | Total | Rate | |
| 2 | 100.0% | ||||
| 3 | 0.0% | ||||
| 4 | Team | 1 | 10 | 10.0% |
- Share of tasks actually done
- 10.0%
- What averaging the percentages says
- 50.0%
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.
- Sample data
Small enough to check by eye, with the right answer worked out first.
- Run it
SQL on three databases, formulas in HyperFormula, an independent spreadsheet engine.
- Compare
Results must match the table on the page, or the build refuses to publish.
- Date it
Published and updated dates on every guide. Prices and plans get a next-check date.
Latest guides
New and updated
Each card says how far the guide was tested, so you know how much to trust it. Everything that changed
- Google SheetsNormalize CRM Email Addresses Before a CSV ImportWhat normalizing email addresses means, why it stops duplicate contacts in your CRM, and a Google Sheets formula that does it, step by step.Read the guide
- SlackSet Up a Recurring Weekly Check-In Reminder in SlackUse the Slack /remind command to post a weekly async check-in prompt in a channel, with a reply template and the reminder phrasings that repeat correctly.Read the guide
- SQLCalculate a Dashboard Completion Rate Without Averaging PercentagesCalculate a task-weighted SQL completion rate by dividing summed completed tasks by summed total tasks, keeping NULL for teams with no tasks.Read the guide
Tools
The small jobs that eat an afternoon
Timesheets, working days, Gmail searches and list cleanup. Most show the spreadsheet formula that does the same job.
See all 23 tools- Gmail search builderFill in sender, words, attachments, size and dates, and get a Gmail search to paste, with a plain-English reading of what it finds.
- Completion rate calculatorRolls project counts up into one correct percentage and shows how far an average of percentages would be off.
- Business days between two datesCounts working days between two dates, skipping weekends and your holiday list.
- Weekly timesheet calculatorTotals a week of start and end times with breaks, and splits regular hours from overtime.
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 .