Batch Runner · Excel add-in for Windows

Work you do a hundred times. Pressed once.

Small, sharp tools for spreadsheet analysis, document generation and contract drafting. Buy one, keep it forever — no seat count, no renewal, no expiring licence.

Paid download · No free version or trial · Windows & Excel 2016+

Batch Runner · Scenario grid Illustration
Scenario Rate Exit IRR DSCR Max bid
Base5.2%4.5%11.4%1.414,391,270
Rates +100bp6.2%4.5%9.6%1.223,908,004
Rates −100bp4.2%4.5%13.7%1.634,902,118
Yield soft5.2%5.0%8.7%1.283,714,900
Yield firm5.2%4.0%14.2%1.625,050,431
Recession6.5%5.5%5.9%1.133,102,760
Soft landing5.5%5.0%9.1%1.31—
Rent boom5.2%4.5%——pending
Illustrative example — not live data
30 × 30
Inputs & outputs per run
Built for Microsoft Excel Works on your files — nothing uploaded Written manual with every tool No account, no sign-up
The product

What Batch Runner is and what it does.

Excel changes one input and shows you one answer. Batch Runner runs your whole scenario table through the model and lays every result out beside the assumptions that produced it. One press. Every row calculated, every result recorded, your model put back as it was.

What it is

An Excel add-in with macros

A macro-enabled Excel workbook (.xlsm) containing a VBA macro. You drop it into your own workbook, or work in the copy provided. It is not a web app and not a service.

What arrives

Two files, by email

The tool (Excel_Scenario_Runner.xlsm, approx. 190 KB) and the manual (PDF). The .xlsm already contains a working example model wired to Batch Runner, so you can see it working the moment you open it.

What you need

Windows & Excel 2016 or newer

Desktop Microsoft Excel on Windows, 2016 or newer, with macros enabled. Not supported on Excel for Mac, Excel on the web, or the mobile apps. Heureka Tools is independent and not affiliated with Microsoft.

How you get it

€29, paid once

A paid download — there is no free version, trial or free tier. Payment is taken first, then the files are sent. One payment including VAT, processed by Lemon Squeezy as reseller of record.

A full walkthrough on a real model — setup, a batch run, and Goal Seek solving every scenario to its own target. Watch on YouTube

How it works, in five steps

01

Point at the inputs you want changed

Link the cells in your model that should change. Your model itself stays untouched.

Show me how+

On the control sheet, link to each cell in your model that Batch Runner should drive — type =, click the cell, press Enter. That is the whole setup. Nothing inside your model is edited or rebuilt.

Control sheet
Input 1='Model'!$C$5
Input 2='Model'!$C$8
Input 3='Model'!$C$12
… as many as you need · your model untouched
02

Point at the outputs you want read

Link the results you want captured. Every link is checked before anything runs.

Show me how+

The same way, link to the results you care about — IRR, margin, headroom, whatever your model produces. Every link is checked before anything runs, and a broken one is flagged with the reason rather than silently ignored.

Control sheet · link check
Output 1='Model'!$B$41YES
Output 2='Model'!$B$42YES
Output 3='Mdel'!$B$43NO — sheet
broken links are named, never skipped
03

Write your scenarios

One row per case. Fill only what changes; blank cells keep your model's own values.

Show me how+

One row per case, as many as you like. Fill in only the inputs that change from one scenario to the next — anything you leave blank simply keeps whatever your model already has.

Scenarios
Input 1Input 2Input 3
27 0005.2%4.5%
25 0006.0%5.0%
27 0006.5%blank
31 0005.2%4.0%
blank = your model's own value · unlimited rows
04

Choose how the run works

Either read the outputs, or let Goal Seek solve each row to its own target.

Show me how+

Two options, and Goal Seek is entirely optional. Read the outputs. The model calculates on your inputs and the results are recorded. This is the normal mode.

Or solve for a target. Turn Goal Seek on, nominate one output as the target and one input as the variable to move, and give each scenario its own goal. Batch Runner works out what that input has to be, then records the outputs as usual.

Option · read the outputs
your inputs
model calculates
outputs recorded
the normal mode
Option · solve for a target
your inputs + a goal
input moved until it hits
outputs recorded
each scenario gets its own goal
05

Press run and read the table

Results land beside the inputs that produced them, ready to sort and chart.

Show me how+

Batch Runner works through the scenarios in turn, telling you which one it is on. Results land beside the inputs that produced them, so the finished block sorts, filters and charts like any other range. When the run ends, your model's original inputs are put back.

Run · scenario 4 of 4 · finished
27 000 · 5.2%11.4%2.60x1.41
25 000 · 6.0%5.9%1.92x1.13
27 000 · 6.5%8.7%2.31x1.28
31 000 · 5.2%14.2%3.24x1.62
results sit on the same row as their inputs
30 × 30
Inputs and outputs per run
∞
Scenario rows, one press
Every row
Gets its own Goal Seek target
Zero
Changes to your model
Checked
Every link, before it runs
No code
Just links between cells
The pricing

Software you own, not software you rent.

Most tools now bill monthly for work you do occasionally. A tool you use twice a quarter should not appear on your card twelve times a year.

The usual way

€19 / month

Year one€228
Year three€684
Year five€1,140
If you stopaccess ends
€19 / month, forever
HEUREKA TOOLS

Heureka Tools

€29 once

Year one€29
Year three€0
Year five€0
If we vanishit still runs
€29 once

Yours from the moment you download it. Keep using it in ten years, on any machine you own.

The catalogue

One tool today. More on the way.

Nothing here is a suite. Every tool does one job that people currently do by hand, over and over, and get wrong under time pressure. Buy only the one you need.

01 — Spreadsheets · ExcelIllustration
ScenarioRateIRRDSCRState
Base5.2%11.4%1.41Done
Rates +100bp6.2%9.6%1.22Done
Recession6.5%5.9%1.13Done
Available now · for Microsoft Excel

Batch Runner

Run your model across hundreds of input scenarios in one press, and collect every output beside the inputs that produced it — including a Goal Seek solve on every row.

  • ✓Unlimited scenarios, up to 30 inputs and 30 outputs
  • ✓Batch Goal Seek — solve every row to its own target
  • ✓Puts your model's original inputs back when the run ends
  • ✓Links checked before the run, with the reason when one fails
€29 Pay once
Buy Batch Runner
Next · in build

More tools are coming

Spreadsheets · documents · contracts. Each one removes a different repetitive afternoon. Currently on the bench:

  • Batch Runner for Google Sheetsthe same tool without the Windows requirement
  • Contract Forgeone template plus a data table into hundreds of finished contracts
  • Document Mergebulk-generate reports and letters from a spreadsheet
Tell me which and it moves up the queue →
What arrives

A working example, not a bare file.

Two files, and the first one already shows you the tool running on a real model. Most people are running their own model within twenty minutes.

Inside the download

  • 01 · The tool, with a model already attachedOne .xlsm file containing Batch Runner and a complete working example model wired to it. Open it, press run, and watch the whole thing work before you touch anything of your own.
  • 02 · A real manualSetup, control sheet layout, worked examples and a troubleshooting table. Written, not generated.
  • 03 · Direct supportReply to your receipt and it reaches the person who built it. Not a queue.

Straight answers

Does "pay once" really mean forever?+

Yes. One payment, and the tool is yours on any machine you own, for as long as you keep the file. There is no subscription, no licence to renew and no account that can expire. If a future version is a genuinely new product, it will be priced as one — and the version you bought will keep working regardless.

Will it work with my model?+

Batch Runner attaches to any model by pointing at cells you choose — you link inputs and outputs with ordinary formulas, so nothing inside your model has to change. It does not care how your model is built, only which cells you want driven and which you want read. If you are unsure it fits your file, email hello@heurekatools.com before buying and you will get an honest answer.

Do my files leave my computer?+

No. Batch Runner runs inside Excel on your own machine, on your own data. Nothing is uploaded, nothing is sent anywhere, and there is no account to create.

What are the system requirements?+

Batch Runner needs desktop Excel on Windows (2016 or newer) and the file must stay macro-enabled (.xlsm). It is not supported on Excel for Mac, Excel on the web, or the mobile apps. If you work on a Mac, do not buy it yet — a version for Google Sheets is in build.

What if I get stuck?+

Email hello@heurekatools.com and describe what you are seeing. Questions come to the person who built the tool, so you get a real answer rather than a template — and if something turns out to be a genuine bug, it tends to end up fixed in the next version.

Can I use it at work, or for client projects?+

Yes. A single purchase covers one person, including commercial and client work. If several people at your company need it, there is a team licence — just get in touch.

Who buys these

Analysts & modellers

You already build the model. You just need to see it under two hundred sets of assumptions before Thursday.

Lawyers & contract teams

The template is agreed. What remains is producing ninety versions of it without a single wrong name or date.

Consultants & finance leads

You need the answer, the sensitivity around it, and the paper trail — today, not after a procurement cycle.