Logic & Automation

Excel gives you SUM, VLOOKUP and IF. What it can’t give you is a function that works the way your business works.

So you build elaborate nested formulas. Copy the same logic across thousands of rows. Train people on “the cell in column F that you must never touch”.

LAMBDA functions change that. They let you define business logic once and reuse it everywhere. That starts with deciding what should be automated and what should stay flexible.

From there, the LAMBDAs are designed to make spreadsheets behave the way you expect them to.

That might mean a single function that applies your exact pricing logic. One that validates data before it creates problems downstream. Or one that handles the edge cases your team runs into every week.

The result is formulas people can read. Calculations that stay consistent. And time back where it belongs.

Compatibility

» Requires Excel 365. Also works in some Excel 2021 versions (depending on build).
» Not sure? Type =LAMBDA in any cell to check. If Excel recognizes it, you’re set.
» Don’t have it? No problem. I can build the same logic in VBA instead.

I map the logic before anything is automated.

I work with you to trace the rule or calculation end to end. Then, we look into what inputs it needs. What happens at the edges. What it should do when something goes wrong. I document the logic until there is no ambiguity.

I build, you test, we refine.

I develop the LAMBDA function using your real scenarios. You test it against actual data and the edge cases your business sees. When something doesn’t behave as expected, we document why so you understand not just what the function does, but what it assumes, where it might fail and when to revisit it. We iterate until it behaves correctly in practice, not just in theory.

I deliver and stay close.

You receive a ready-to-use LAMBDA function with clear documentation explaining what it does and how to apply it. I walk your team through its use and remain available as questions come up in the first weeks, so it settles into real work without problems.

⬤ Single LAMBDA function: €247
⬤ Three-function package: €675
⬤ Complex LAMBDA suite (10+ functions): €1,273 – €1,676

Typical delivery takes 3–10 days, depending on complexity.

All engagements are covered by a confidentiality agreement. Nothing is shared without your written consent.

Pro bono work is offered to nonprofits (see “About Me”).

Most LAMBDA functions are written to impress. Mine are written for the people who inherit the file and use it daily.

With me, you get:

⬤ Help deciding which logic to automate (and which to keep flexible).
⬤ Code structured so you can modify it when business logic changes (without breaking what already works).
⬤ Functions that document not just how they work, but why they work this way and what assumptions are built in.

This is Phronesis. The practical wisdom to know which rules belong in code, which need to stay flexible and how to structure both so your team can maintain them.