Easily perform risk analysis using Monte Carlo simulation in your spreadsheet. Go beyond what-if to see the full range of outcomes.
Listing updated:March 6, 2023
Works with:
92K+
Overview
Use Risk Solver Add-on from Frontline Systems to perform risk analysis using Monte Carlo simulation in your spreadsheet.  This Add-on includes key features from Frontline Systems' Risk Solver Pro add-in for Microsoft Excel.

-- Point and click to insert probability distributions into cells representing uncertain inputs in your model, and set their parameters.
-- Choose from 30 different continuous distribution, from Beta to Weibull, and 8 discrete distributions, from Bernoulli to Poisson. 
-- Point and click to mark cells computing results that you want to monitor during the simulation.

Click to run and in a few seconds, you'll have results from 1,000 Monte Carlo trials, with charts and statistics:

-- Frequency histograms
-- Sensitivity (tornado) charts
-- Scatter plots
-- Summary statistics such as mean and standard deviation
-- Percentiles

Copy statistics and percentiles into a worksheet cell range with one click.  You can even step through the Monte Carlo trials and see each result calculated on your worksheet.

Risk Solver Add-on helps you go beyond what-if analysis to perform realistic risk analysis.  Move from simple average-best-worst case analysis to see the full range of possible outcomes, and quantify your downside risk and upside potential.  For applications in pharmaceuticals, oil and gas, finance and insurance, and manufacturing quality control, this type of risk analysis is essential.
 
This free Add-on supports up to 24 uncertain inputs and 12 uncertain outputs, and 1,000 Monte Carlo trials.  Simulations are performed on Frontline's backend Solver Server, running on Windows Azure. This server has a finite capacity, as currently provisioned (and paid for) by Frontline Systems, so at times there can be delays. To run simulations with more (even thousands of) uncertain inputs and outputs, and more (even hundreds of thousands of) Monte Carlo trials, please contact Frontline Systems about using Risk Solver Add-on with Risk Solver Pro.
Additional information
PricingNot available
Developer
Privacy policy
Terms of service
Risk Solver will ask for the permissions shown below. Learn more
Risk Solver will need access to your Google account
This will allow Risk Solver to :
See, edit, create, and delete all of your Google Drive files
See, edit, create, and delete all your Google Sheets spreadsheets
Display and run third-party web content in prompts and sidebars inside Google applications
Connect to an external service
Allow this application to run when you are not present
See your primary Google Account email address
See your personal info, including any personal info you've made publicly available
Reviews
Language:
Sort by:
Google doesn't verify reviews or ratings. Learn more about reviews
Profile Picture
Matthew Royal
September 21, 2023
Found this plugin while searching for a linear optimizer. It must not be general enough to provide this functionality -- documentation is also not good enough to run their out-of-the box example.
Is this review helpful?
Yes
No
Profile Picture
A User of Risk Solver
April 1, 2018
Has some extreme privileges but is needed due to calculations being done remotely. Unfortunately even the example spreadsheet stops updating after a few runs. So after setting all your relationships up, you'll be lucky if you can even run it. It also does not appear to allow statistics of the random variables to be written to cells.
Is this review helpful?
Yes
No
Profile Picture
matt b
February 21, 2020
It's great, and a good stand in for @Risk. I'd like to see a licensing model around how to use more of this specifically in Sheets.
Is this review helpful?
Yes
No
Profile Picture
A User of Risk Solver
May 27, 2020
I loaded the App ... it does not work
Is this review helpful?
Yes
No
Profile Picture
A User of Risk Solver
June 2, 2020
doesnt work
Is this review helpful?
Yes
No
Profile Picture
A User of Risk Solver
November 3, 2014
Very easy to use.
Is this review helpful?
Yes
No
Profile Picture
A User of Risk Solver
November 4, 2014
great easy to use app!
Is this review helpful?
Yes
No
Profile Picture
A User of Risk Solver
November 4, 2014
Very nice user interface!
Is this review helpful?
Yes
No
1-8 of 8
Search
Clear search
Close search
Google apps
Main menu