About Producfy

Producfy is an independent site of how-to guides for people who run work from a laptop: remote team leads, office managers and small business owners. Most of them have a spreadsheet that almost does what they need. We write the missing formula, query or script and show it working on sample data.

Who runs Producfy

Producfy is run by Nick Casey, a technical product entrepreneur with an IEEE-accredited BSc in Internet Technology from the University of Portsmouth. He writes the guides and is responsible for what they say.

Nick has never stuck to one lane. He writes the software and keeps the servers running, then sells the product, markets it and makes the tea. If a job needs doing, he picks it up, from the database to the sales call.

Doing every job means seeing a business from every side. Nick's career runs from startups with a handful of people, through small and medium-sized companies, to enterprises including Kelkoo, Yahoo, ValueClick and United Internet Media. The same problems turn up at every size: a report that doesn't add up, a reminder nobody sends, a contact list full of duplicates. What changes is who fixes them. A large company has a team for it. At a ten-person company it falls to whoever noticed, on top of their real job.

Producfy is written for that person. The guides fix the operations work that falls between job titles, in the software the business already pays for, and show enough of the working that you can check the result and get back to your day.

Why this site exists

If you aren't an expert, how do you know the AI didn't get it wrong? That question is why Producfy exists.

The answer is to test it against something where you already know the right answer. Every guide here does that for you: sample data small enough to check by hand, with the awkward rows left in, the code, and the output it should give. You see the formula, query or script work before you trust it with your own data, and you learn enough to check the next one yourself.

Small teams run a surprising amount of their work on spreadsheets and scripts, often written by whoever had the time, and now often by AI. A snippet on its own rarely shows whether it did the right thing. A worked example does.

Why bother, when AI can write the query?

AI can write a formula or a query in seconds, and Producfy uses it to help draft guides. Someone still has to know whether the answer is right. When the report doesn't add up, the script stops halfway, or the AI gives a confident answer that doesn't work and can't tell you why, the person who understands how the thing works is the one who fixes it.

You only get that understanding by making things yourself. That is why every guide shows its working: the sample data, the code and the result, with the reason each part is there. The next time, you can write it, check it or fix it without asking again and hoping.

Nick thinks this matters most for entrepreneurs. Running a small company means doing a bit of everything, and the people who can turn their hand to anything are the ones who solve the problems nobody else owns. Leaving all of it to AI works until the day it gets something wrong.

StarTalk, Neil deGrasse Tyson's show, put it in five words in the title of a clip: "Surrendering our Capabilities to AI". That is the trade Producfy is written to help you avoid.

David Krakauer, the Santa Fe Institute complexity scientist who has joined Tyson on StarTalk, has a name for the difference. Some tools, like the abacus, are complementary: practised users end up doing the sums in their heads, so they are better off even without it. Others, like the calculator, are competitive. Of those he writes, "when we are deprived of their use, we are no better than when we started." Producfy tries to be the first kind: every guide shows its working so you keep the skill after you close the tab.

How guides are written and checked

Guides are drafted with AI assistance, then reviewed before publication. Each one ends with a note saying how that guide was checked, because the checks differ:

  • SQL: the main queries are run against the published sample data in DuckDB, MySQL and PostgreSQL, and the results are compared with the tables on the page. Where a database needs different syntax, the guide shows that version too.
  • Formulas: several are evaluated on the sample data in HyperFormula, an independent spreadsheet engine. It isn't Google Sheets or Excel, so results there could differ. Others have only been reviewed.
  • Apps Script: scripts are syntax-checked and reviewed against the published API documentation. Unless a note says otherwise, they haven't been run in a live account, so try them on test data first.

These checks run again whenever the site is rebuilt, so a query or formula that stops matching its published output blocks the update.

How often new guides and tools appear

Producfy didn't launch empty. Before it went live, Nick chose a starting set of guides and tools and loaded them in a couple of weeks, so the first visitors would have something to use. That's why so many are dated November 2026.

From here the pace is slower and steadier: the aim is one or two new guides or tools a week. What's planned for the next few months is on Coming up, and everything that has been added or changed is on What's new.

How prices and plans are kept current

Software prices and plan limits change more often than formulas do. Any guide that names a price, a plan or an edition says, under "How this guide was checked", the date those details were checked against the vendor's own pages and the date of the next check.

That next check is never more than three months away. If a vendor announces a price or plan change before then, the affected guides are checked that week. The date is enforced, not just promised: the site's build refuses to publish once a guide's check is overdue, so a stale price can't sit on a page unnoticed. Changes show up on the What's new page.

We don't publish roundups of "best" apps, and no vendor pays for a guide or sees it before publication.

What we leave out

Producfy doesn't give tax, legal, accounting or investment advice. A guide about invoice files covers where the files go and what they are called, and stops there.

How the site makes money

Producfy is supported by advertising. Ads are served by third parties and don't influence what we cover. The privacy policy explains how ad cookies work and how to opt out.

Get in touch

Corrections are the most useful thing you can send. Use the contact form.

Esc