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
- Read System requirements.
- Save your work and close all Excel windows. The setup program refuses to change anything while an Excel process runs.
- 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
- In the folder, double-click
Probistica-setup.exe. - The window "Probistica setup" opens. It shows what the setup will do, and it changes nothing yet.
- Click Install. The window shows each step.
- Click Close.
- 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.xllto%APPDATA%\. The copy is a new file without the download mark ("Mark of the Web"), so Excel does not block it for that reason.Microsoft\ AddIns\ Probistica64.xll - 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%\. The Help button of the Probistica tab shows them. If this copy fails, the add-in stays installed. Run the install again.Programs\ Probistica\ docs
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:
- In File Explorer, right-click
Probistica64.xlland click Properties. - 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
- Start Excel. The Probistica tab appears.
- Look at the button in the License group. Its label shows the license status, for example
UnlicensedorLicensed. In a Product build, a new run needs a license; see Your Probistica license. In a new workbook, type these cells:
Cell Content B1 =SIM.NORMAL(1000,150)B2 =SIM.UNIFORM(400,600)B3 =SIM.OUTPUT("Profit")+B1-B2
- On the Probistica tab, click Run. The status bar shows the progress.
- 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
- Close all Excel windows.
- Extract the new ZIP file into a new folder.
- Start the new
Probistica-setup.exeand click Install.
The setup replaces %APPDATA%\ 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%\.
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%\. Click Close. Then the setup deletes its installed copy.Programs\ Probistica\ docs - 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.xllthat Excel loads from another folder. - A file in
%LOCALAPPDATA%\that is not a page (.md). The setup then keeps the folder.Programs\ Probistica\ docs
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).