Click or drag to resize

MONTE.BUFFER

Buffer rows to ouput range from the top.

Description

Over the course of a simulation it is useful to make the results of previous calculations available. Monte does not store any results but you can make them available in your Excel worksheet. This function buffers as many rows as the array output you specify.

Sweep out a range of cells with as many columns as the row to buffer and with as many rows of previous calculations you want to see. This is an array function so you need to use Ctrl-Shift-Enter instead of just Enter.

Over the course of the simulation each row will be pushed to the top row of the output range.

Syntax

MONTE.BUFFER(Row)

  • Row is a row of cells to be buffered.