Product
Features
Probistica puts the steps of a Monte Carlo analysis into one Excel tab: build the model, run it, read the results, and test decisions.
Simulation and distributions
Put more than 50 distribution functions in cells. Add correlations and copulas. Run with Monte Carlo or Latin Hypercube sampling.
Read moreDistribution fitting
Fit distributions to your data. Probistica ranks the families and writes the formula of the fit that you choose.
Read moreSensitivity and charts
See histograms, tornado, spider, scatter, and convergence charts. Find the inputs that drive each output.
Read moreWhat-If, stress, and Goal Seek
Change inputs step by step. Stress the tails. Find the input value that gives a target statistic.
Read moreOptimization under uncertainty
Find the values of decision cells that give the best statistic of an output, with hard and soft constraints.
Read moreTime series
Fit 13 time-series models to a data series and simulate forecast paths in the workbook.
Read moreAutomation and VBA
Run models from VBA, run your own macros during a simulation, and control Probistica from .NET code.
Read moreReports and BI export
Write reports to sheets or PDF. Export samples and statistics to CSV files or a SQLite file for a BI tool.
Read moreHow Probistica works
A model is a normal workbook
Some cells hold uncertainty, for example =SIM.TRIANGULAR(20,25,35). Other cells are outputs, marked with SIM.OUTPUT. In Excel, a distribution cell shows its mean.
A run draws new values in each trial
Probistica draws a value for each input, calculates the model, and keeps the outputs. In the default mode, the engine calculates the trials itself when it can, and it can use all processor cores.
Results go into the workbook
Probistica adds a results sheet with statistics, sensitivity, and convergence. Result functions show a statistic in any cell, for example SIM.MEAN.
Checks, repeatable runs, and local data
Checks before a run
The Issues list checks the model before a run. When a formula is outside the supported set, the run stops and names the cell. Probistica never guesses a value.
Repeatable runs
A fixed seed gives the same results again with the same model, engine version, runtime, method, and trial count. The run details record the seed, the method, and the timings.
Your data stays on your computer
Probistica sends no workbook data and has no telemetry. Daily use needs no internet connection.
Work with others
Share a workbook
Swap Out replaces the SIM functions with their values, so a person without Probistica can open the copy. It does not change a cell with an array formula. Swap In brings the functions back.
20 example models
Click Examples to make a new workbook from an example, with numbered steps on the sheet. See the list.
Workbooks of another risk add-in
Probistica can convert a copy of a workbook made for one other risk add-in to SIM functions. The original file does not change. A cell that does not convert keeps its formula and is listed. A converted copy can still hold formulas that Probistica does not calculate. The random draws are not the same as in the other add-in, so the results can be different.
Known limits. Probistica calculates a documented subset of Excel formulas. Probistica refuses some array formulas that Excel calculates, and names the cell. It uses the conventions "." for decimals and "," for thousands. It does not import project schedules, and it has no AI assistant. Always verify results on your own models. The user guide (shipped in the release package; section outline online) lists each limit.