ForeSheet
Monte Carlo in a spreadsheet, in the browser. Put a distribution in any cell, mark the outputs and run the model on our servers.
How It Works
Build the Model
A spreadsheet grid with formats, conditional formatting, validation, tables, named ranges, protection, pivot tables and charts.
Add Uncertainty
Over 1,250 functions for distributions, correlation, time series and more.
Mark Outputs
Mark the cells you want results for.
Run
Run in the session, or as a background job for a larger run.
Read Results
The Results Viewer shows each output’s distribution and statistics. Compare runs and export the results.
Details
What You Get
- Over 1,250 Functions.
- Fit distributions to data, rank the fits and insert one, including time series and correlations.
- Start from a template in the gallery.
- Versions and backups of each model.
- Push results to a risk or to Reports.
- Create a model from a QRA cost model with Model in ForeSheet.
- Export the results report to PDF, Excel, PowerPoint and Word.
- Import an .xlsx workbook built with @RISK, Crystal Ball or ModelRisk: its distributions, outputs, correlations and statistics functions become ForeSheet functions, and a report lists what was converted.
- Crystal Ball assumptions, forecasts and correlations set in its dialogs come in as ForeSheet formulas. Its decision variables keep their values for the Decision Table and Optimiser.
- Convert Workbook converts @RISK, Crystal Ball and ModelRisk formulas added to a model later, after a report of each cell. Undo puts them back.
- Convert a folder of workbooks at once into new .xlsx files, with a conversion report.
Limits and Conditions
- ForeSheet comes with Ultra and Enterprise and is an add-on on Starter and Pro. It is not in the Demo.
- Building and running models needs an analyst seat.
- Workbook imports up to 20 MB.
- Co-editing is not available.
- Functions that cannot be converted stay in their cells and are listed with the cell.
- Older .xls workbooks need saving as .xlsx first.
Analysis Tools
Tools that answer a question about the model: which input matters, what value hits a target, which decision is better.
- Find Target: find the input value that brings an output’s mean or percentile to a target.
- Find Drivers: move each input to its extremes and rank inputs by how much they move an output.
- Stress Test: hold chosen inputs at an extreme and see what the outputs do.
- Decision Table: simulate an output over a grid of one or two decision cells’ values.
- Optimiser: search the decision cells’ values to maximise or minimise a statistic of an output, within constraints.
- 2D Simulation: separate uncertainty from variability with an inner simulation for each draw.
- Forecast: forecast a time series by smoothing, moving averages or regression.
- Totals: the total of an uncertain number of uncertain amounts.
Related Features
- QRA Engine
Cost Model
Build the project’s cost model next to the schedule: elements with uncertainty, costs tied to activity durations, formulas, and risks mapped to costs.
- Decisions and Analytics
Reports
Build a report across the folders you pick from register cards and QRA results, save it as a template for the organisation, and export the Summary to PDF.