Invrea's Scenarios plugin generates possible scenarios in a process that runs alongside Excel called its inference engine. This means that Excel functions need to be duplicated in Scenarios' inference engine so that Scenarios can use them quickly. The Excel functions that have been reimplemented in this way - well over 100 of them - are listed below. Note that Scenarios can also call Excel functions that are not implemented, along with user-defined functions or macros written in Visual Basic. However, including these will cause scenario generation to be substantially slower; if possible, stick to using the functions listed below.
If you have a function you'd particularly like us to speed up and add to this list, whether or not it's a default function in Excel, contact us here.
INDEX, in Scenarios, is only allowed to take three arguments: a range, a row number, and a column number. The optional fourth argument, an area number, is not supported in Scenarios. (↩)
2. These primitives are wrapped as standard distributions in Scenarios, thereby making them suitable for use in
ACTUAL statements as well. However, this makes them unsuitable for some features of Scenarios, such as locking and seeding. (↩)
3. Only supported when there is only one dependent variable
Y (i.e. input is a row or column range). (↩)