Install Probistica

Probistica is an add-in for 64-bit Excel for Windows. Install it with the setup program. The setup installs the add-in for the current Windows user only. You need no administrator rights. A free trial installs only with the setup program.

IT staff and developers can also load the add-in manually (see "Other ways for IT staff").

Before you install

  1. Read System requirements.
  2. Save your work and close all Excel windows. The setup program refuses to change anything while an Excel process runs.
  3. Extract all files of the ZIP file into one folder. Do not start the setup program from inside the ZIP file.

Install with the setup program

  1. In the folder, double-click Probistica-setup.exe.
  2. The window "Probistica setup" opens. It shows what the setup will do, and it changes nothing yet.
  3. Click Install. The window shows each step.
  4. Click Close.
  5. Start Excel. The Probistica tab appears.

Windows can show a warning before the setup starts, for example for a program from the internet. The file manifest.txt of the package tells you whether the setup program is signed. The line signature: unsigned means that it is not signed; then Windows can show "Unknown publisher". Otherwise the line names the certificate. We did not test which warning Windows shows for Probistica.

If Windows, Smart App Control, or a company rule blocks the setup, do not load the add-in file by hand. Send the text of the message to support@probistica.com, or ask your IT department.

The setup does these steps:

  • It saves a copy of Excel's options key, which holds the add-in list, in %TEMP%\Probistica-install-options-<time>.reg.
  • It copies itself to %LOCALAPPDATA%\Programs\Probistica\Probistica-setup.exe.
  • It adds the entry "Probistica" to Settings > Apps > Installed apps.
  • It copies Probistica64.xll to %APPDATA%\Microsoft\AddIns\Probistica64.xll. The copy is a new file without the download mark ("Mark of the Web"), so Excel does not block it for that reason.
  • It adds the add-in to the list of add-ins that Excel loads at each start.
  • It copies the pages of the folder docs (the .md files) to %LOCALAPPDATA%\Programs\Probistica\docs. The Help button of the Probistica tab shows them. If this copy fails, the add-in stays installed. Run the install again.

When the add-in is registered already, the setup copies the file and keeps the registration as it is.

Other ways for IT staff

Do not use these ways for a trial. They do not add the entry "Probistica" to Settings > Apps.

Install manually in Excel

Excel blocks an XLL file that has the download mark. Remove the mark first:

  1. In File Explorer, right-click Probistica64.xll and click Properties.
  2. On the General tab, select Unblock, if it is there. Click OK.

Then load the add-in:

  • For one session: in Excel, click File > Open > Browse, select the file, and click Open. If Excel shows a security notice, select "Enable this add-in for this session only". The Probistica tab appears.
  • For every session: click File > Options > Add-ins. At "Manage", select Excel Add-ins and click Go. Click Browse, select the file, and click OK.

Do not move or delete the file that you selected while it is in the add-in list.

The first run

  1. Start Excel. The Probistica tab appears.
  2. Look at the button in the License group. Its label shows the license status, for example Unlicensed or Licensed. In a Product build, a new run needs a license; see Your Probistica license.
  3. In a new workbook, type these cells:

    CellContent
    B1=SIM.NORMAL(1000,150)
    B2=SIM.UNIFORM(400,600)
    B3=SIM.OUTPUT("Profit")+B1-B2
  1. On the Probistica tab, click Run. The status bar shows the progress.
  2. Probistica adds the sheet "Probistica Results 1". It shows the statistics of the output "Profit".

The user guide tells you more about models and results.

Update to a new version

  1. Close all Excel windows.
  2. Extract the new ZIP file into a new folder.
  3. Start the new Probistica-setup.exe and click Install.

The setup replaces %APPDATA%\Microsoft\AddIns\Probistica64.xll with the new file. It keeps the registration in the add-in list, and it updates the entry in Settings > Apps. The setup also replaces the pages in %LOCALAPPDATA%\Programs\Probistica\docs.

After a manual install, close Excel and replace the file in the folder from which Excel loads it.

Uninstall

Close all Excel windows first. Then use the way that matches the install:

  • Setup program: open Settings > Apps > Installed apps. Find "Probistica", click ... > Uninstall, and confirm. The window "Probistica setup" opens and removes the add-in and the pages in %LOCALAPPDATA%\Programs\Probistica\docs. Click Close. Then the setup deletes its installed copy.
  • Manual install: in Excel, click File > Options > Add-ins, select Excel Add-ins, and click Go. Clear the check box of Probistica and click OK.

The setup program removes only the values and the files of Probistica. They keep these items:

  • Your license files and the folder %LOCALAPPDATA%\Probistica\Licenses.
  • Any unsent error or support reports in %LOCALAPPDATA%\Probistica\ErrorReports.
  • Your settings of the Define Distribution window (Favorites, Predefined distributions, Recently Used, and defaults) in %APPDATA%\Probistica\define-distribution.xml.
  • The copies of Excel's options key in %TEMP%\Probistica-install-options-<time>.reg.
  • Another Probistica64.xll that Excel loads from another folder.
  • A file in %LOCALAPPDATA%\Programs\Probistica\docs that is not a page (.md). The setup then keeps the folder.

Workbooks without the add-in

When Probistica is not loaded, each cell with a SIM.* function shows #NAME?. Before you send a workbook to a person without Probistica, click Swap Out and save a copy. Swap Out replaces the SIM functions with the values that they show. It does not change a cell with an array formula: its message counts these cells after skipped=. Check this count and the copy before you send it. Swap In brings the functions back (user guide, section 7b).