Designing Excel model

If you want to access to current batch index in your Excel formulas use MM_BATCHINDEX function (MM_BATCHINDEX function‍)

If a table should keep results from each batch that has run add the flag /BatchResult to the grid name.

Setup batch run

First, click on the settings button in the action top bar.

Then turn on batch run, choose a number of batches to run then if you want to run All batches or only selected one.

Launch your calculations, as usual, you will just see next to progress percentage which is the current batch calculating.