Prudai for Excel

Prudai for Excel is an Office add-in that does two things at once:

1. a task pane with the Prudai assistant next to your worksheet, with the same chat, case files, and source citations as the web app;
2. a set of worksheet functions you use in your cells like any other Excel formula: =PRUDAI.WETTELIJKERENTE, =PRUDAI.CONTANTEWAARDE, =PRUDAI.KAPITALISATIEFACTOR, =PRUDAI.HANDELSRENTE, and =PRUDAI.LIQUIDATIETARIEF.

Also available: Word add-in and Prudai for Outlook.

The assistant in the task pane

Open Excel and click Prudai voor Excel in the Prudai group on the Home tab. The task pane opens on the right with the full chat: your case files, your knowledge sources, and your settings. See Chat and Projects.

Placing a table into your worksheet

When an answer contains a table, that answer gets a “Place in Excel” action:

1. You first see a preview, including the number of rows and columns.
2. Nothing is written until you confirm.
3. After you confirm, the table lands on a new, highlighted worksheet, so your existing cells are never overwritten.

If you do not see the action, the answer contains no table, or you are viewing the chat outside the add-in.

The worksheet functions (=PRUDAI.*)

This is what makes Excel distinct within Prudai. The =PRUDAI.* functions are not AI estimates: they are fixed, deterministic calculations. The same input always yields the same amount, tomorrow as well, and on a colleague’s machine as well. The calculation runs inside Excel itself, so your cell contents are not sent to a server.

Just as important is what the functions do not do: where the underlying table has not been verified, they fail with an error instead of producing a plausible-looking number. You can check an empty answer; you cannot check an invented one.

Function	What it does
=PRUDAI.WETTELIJKERENTE(hoofdsom, vanaf, tot)	Dutch statutory (non-commercial) interest on a principal, art. 6:119 BW, with annual compounding and the fixed historical rate table. Returns the interest amount. Dates may be Excel dates or text in YYYY-MM-DD form.
=PRUDAI.CONTANTEWAARDE(jaarbedrag, looptijdJaren, rentePct)	Present value of a fixed annual amount over a term, discounted at the rate you supply (payment at year end).
=PRUDAI.KAPITALISATIEFACTOR(looptijdJaren, rentePct)	Capitalisation factor: the present value of 1 euro per year over the term, at the supplied discount rate. A useful building block in your own damages calculation.
=PRUDAI.HANDELSRENTE(hoofdsom, vanaf, tot)	Dutch statutory commercial interest, art. 6:119a BW. Refuses by design: there is no verified half-yearly rate table, so the function returns an error instead of an estimate.
=PRUDAI.LIQUIDATIETARIEF(belang, punten, instantie)	Cost award under the Dutch liquidatietarief. Refuses by design: no verified points or bracket table is included.

The function names are Dutch because the calculations are Dutch legal concepts. In a Dutch-language Excel the argument separator is a semicolon instead of a comma.

You supply the discount rate yourself

CONTANTEWAARDE and KAPITALISATIEFACTOR fill in no default rate. Leave the percentage out and you get an error, not a silent assumption. That is deliberate: in a damages calculation the discount rate is a point of debate between parties, not a product setting. Preferably work through a scenario range (for instance three columns with different percentages).

Shelf life of the rates

WETTELIJKERENTE uses a fixed historical rate table. It is verified through 30 June 2026. If your calculation period runs past that date, check yourself whether the rate has changed since, because Dutch statutory interest can change every six months. The worksheet function returns a number only and does not warn about this separately.

Getting started

Deployment (administrators)

The add-in is made available by your administrator, via one of two routes:

• central deployment in the Microsoft 365 Admin Center (Settings → Integrated apps → Upload custom apps, app type Office Add-in, Provide link to manifest file);
• sideloading the manifest in Excel, for instance for a pilot or a test group.

The production manifest URL is:

https://app.prudai.com/excel-addin/manifest.production.xml

The steps in the Admin Center are otherwise identical to the Outlook ones, including the assignment choice and the wait of sometimes up to 24 hours before everyone sees the add-in. See the administrator guide for Prudai for Outlook and enter the Excel manifest URL there.

What the manifest requests:

• Office permission ReadWriteDocument (read from and write to the workbook, for instance for “Place in Excel”),
• requirement set SharedRuntime 1.1: the task pane and the worksheet functions run in the same long-lived runtime, so you only have to sign in once,
• the function namespace PRUDAI, under which the five functions are registered.

Current manifest version: 1.0.0.0.

Network access: allow outbound HTTPS to app.prudai.com (the add-in itself) and login.prudai.com (Prudai sign-in).

Signing in

1. Click Sign in in the task pane.
2. A separate dialog window opens. SSO logins often cannot run inside embedded frames, hence the pop-up.
3. Sign in with your Prudai account, the same account as for the web app.

Which personas you see in the task pane depends on your organization’s licenses. See Sign-in & persona selection. Your administrator can also switch features off for the whole organization; what that means is covered in the quick start.

Supported Excel clients

• Excel for Windows and Mac (desktop): task pane plus the ribbon button on the Home tab.
• Excel on the web: excel.cloud.microsoft is listed among the add-in’s allowed domains.

The =PRUDAI.* functions are not tied to a ribbon button and work wherever the add-in is loaded.

Troubleshooting

Symptom	Likely cause	Fix
Excel does not recognize =PRUDAI.… (#NAME?)	Add-in not deployed, or not yet loaded in this workbook	Check whether Prudai appears on the Home tab; if not, ask your administrator to deploy it
Error saying the value was “niet geraden” (not guessed) from HANDELSRENTE or LIQUIDATIETARIEF	These functions refuse by design as long as there is no verified rate table	Verify the rate yourself and enter the amount, or use =PRUDAI.WETTELIJKERENTE
Error that the discount rate is mandatory	rentePct not supplied to CONTANTEWAARDE or KAPITALISATIEFACTOR	Pass the percentage explicitly; the function fills in nothing
Error about an invalid date	Date not recognized	Use a real Excel date or text in YYYY-MM-DD form
Task pane stays blank	Glitchy Office webview or cache	Close and reopen the pane, restart Excel, clear the Office cache if needed; check that app.prudai.com is reachable
”Place in Excel” missing on an answer	The answer contains no table, or you are viewing the chat outside the add-in	Ask explicitly for a table, and work from the task pane inside Excel

More: Word add-in · Prudai for Outlook · Chat · Troubleshooting & support.