Business Analytics Multiplatform Add-in
Latest Version: 0.0.38
Windows Installation
To install the add-in on Windows, download the add-in installer and run it.
That's it! The add-in is now installed. This can be verified by noting that a new ribbon appears in the Toolbox.
If you have a corporate computer that doesn't allow you to run a .exe file, see this page.
Mac Installation
- Make sure Excel is not running.
- Go to
/Applications
and create a folder named cbs_ba_multiplatform
if it doesn't already exist (if the folder exists and you are updating the add-in, delete the file in that folder).
- Download the following file:
CBS_BA_Multiplatform_add_in.xlam
and move it to the newly created folder.
- Go to Tools → Excel Add-ins
- In the Add-ins available dialog, click on the Browse button
- Select the correct add-in file from the pop-up, and click on Open. For complete functionality, also select the Solver Add-in.
- Make sure the selected add-in is enabled in the list, and disable any old versions of the same add-in that were previously enabled. The list should look as above, with only the latest version enabled.
- Click on OK.
The add-in is now installed. This can be verified by noting that a new ribbon appears in the Toolbox.
Documentation
The user manual for the add-in is available
here.
In addition, here are some example files to get you familiarized with the add-in functions:
- Linear and Logistic Regression
- Monte Carlo Simulation
- Classification, KNN, Misc
Troubleshooting
- When downloading a file which uses the add-in from another computer (e.g., practice problem solution files from Courseworks), links to the add-in functions may be broken. To fix them, go to
CBS BA Add-in
Fix Links to Add-In.
- If you get an error saying "Compile Error: Can't find project or library", this is because the add-in uses Solver add-in internally, and some versions of Excel complain if Solver is not enabled at startup. To fix this, open the add-in available dialog by following the instructions for Windows/Mac above and enable the Solver add-in. Then restart Excel. The error should now be gone.
- Normally, you can get guidance for Excel functions by typing the function in a cell and clicking on the formula button (or typing Shift+F3). This, however, does not work well with add-in functions in Excel for Mac. To get proper guidance for add-in functions, go to Formulas -> Insert functions and type the name of the function in the search box of the Formula Builder dialog that opens. When you select the function from the search results, you will receive help on the function and its arguments.
- Always make sure to keep the add-in updated to the latest version. To check the installed version, type Ctrl+Shift+V when Excel is open. You can also go to "CBS BA Add-in" -> "Version Info". If your version is older than the one on this website, you can download the add-in file from here and follow the installation instructions to update to the latest version.
- Installing the add-in requires a version of Excel that is activated. If you are not able to install it on your Excel, try to reinstall Excel - reach out to ITG if you need help.
- This add-in does not work well with the old (C++/Windows only) BA Excel add-in. If the old add-in is already installed, make sure you disable it and then follow the installation instructions above.