boozallen / argo

Other
46 stars 19 forks source link

ARRAYROW #41

Open carlosgso opened 3 years ago

carlosgso commented 3 years ago

I have a fairly simple model with three triangular distributions and one uniform. When I try to run de simulation it gives me the following message: "The following functions are not supported in RealTime Analytics mode: ARRAYROW Please remove the functions or switch the Spreadsheet Interpreter mode to Native Excel in the Argo Options panel and rerun the simulation."

I can run the simulation in Native Excel mode but it is too slow.

Do you know which functions in excel might be arrayrow so I can change them?

The formulas involved in the model are mainly sums and multiplications so i dont understand what might be happening.