Why Excelerant

The flexibility of Excel, the control of a production system, and the model stays with the people who understand it.

Compared with Excel on its own

The same workbook, under control

Important models often start in Excel, and for good reason: the people who understand the business can build and change them themselves, without waiting for IT.

The trouble starts when a workbook becomes part of a process. It gets copied, e-mailed and changed by whoever has it open, and nobody can say for sure which version produced a number. That is why IT and management want such workbooks replaced. Excelerant keeps the workbook and adds the controls instead.

TopicExcel on its ownWith Excelerant
FilesCopies on laptops and shared drives, sent around by e-mailOne central place, used in the browser or through the API
FormulasAnyone with the file can change a formula, often without anyone noticingUsers can only enter inputs. Formulas and VBA change only through a new, checked-in version
MacrosRun on one person’s PC, with Excel openRun on the server without Excel, started from the browser or from Excel
Versionsmodel_v7_final2.xlsx, somewhere in a folderEvery version kept, so any figure can be reproduced
ChangesHard to tell what changed between two filesCompare any two versions: sheets, cells, formulas and VBA
Read and write rightsWhoever has the file can see and change everythingRead and write rules per role or person, down to a sheet or a range of cells
Audit trailNo record of who calculated what, or with which versionEvery calculation logged: who, when and with which version
Other systemsResults copied in by handOther systems call the workbook through the REST API

Nothing about the workbook itself changes. The people who built it keep working in Excel, and IT gets what it expects from any production system: one released version, access control, an audit trail and results it can reproduce.

Compared with AI-written code

What about AI?

The other way to get a workbook under control is to rewrite it as software. That used to take months, which is why many models never made it. AI can now do it in hours, and the code may well be good. The difference is who owns the model afterwards.

TopicExcel rewritten as code by AIYour workbook on Excelerant
Source of truthThe generated codeThe workbook itself
ResultsAsk twice and you may get different code, so every version has to be checked against the workbookThe workbook itself runs, so the results match Excel
OwnershipMoves to IT, who maintain and test the code from then onStays with the people who built the workbook
Changing a formulaA development task: new code, tests and a releaseChange the workbook and check in a new version
Audit and historyBuilt separately, often app by appVersion management and audit trail built in

Generated code is also only the calculation. Sign-in, hosting, version management and an audit trail still have to be built around it, model by model.

Where AI does help is in building and improving the workbook itself. The result is still a workbook the business can read, check and take anywhere, not a black box that has to be maintained and tested.

In short

Keep the flexibility, add the control

You don’t have to choose between the flexibility of Excel and the control of a production system. The business keeps building and changing its models in Excel, with AI’s help if it likes. IT gets one released version, access control and an audit trail. And every figure can be reproduced, at any later date.

See it working on your own workbook.

Or e-mail us at info@excelerant.nl