Installing RiffynFunctions & RealStats AddIns

Download the AddIns (same files for Windows or Mac)

  • Download RiffynFunctionsYYYY-MM.xlam and RealStats.xlam (links at bottom of this article)

 

On Windows with Excel 2016 (may need to be adjusted for your version of Excel for Windows)

Install the AddIns

  1. Copy RiffynFunctionsYYYY-MM.xlam and RealStats.xlam to C:\Users\YourUserName\AppData\Roaming\Microsoft\AddIns. ('YYYY-MM' is the year & month of that version of the file.)
  2. Restart Excel
  3. Select File->Options
  4. Click on the "Add-ins" menu item in the left-side of the modal window
  5. At the bottom of the window under "Manage:", select "Excel Add-ins" from the drop down and click "Go…"
  6. Select the tick boxes next to "Solver Add-in", "Realstats" and "Riffynfunctions2017-01". Click OK

Adjust security settings

  1. Select File->Options
  2. Click on the "Trust Center" menu item in the left-side of the modal window
  3. Click on the "Trust Center Settings..." button on the right
  4. Click on the "Trusted Locations" menu item in the left-side of the modal window
  5. Click on the "Add new location…" button at the bottom right
  6. Add: "C:\Users\YourUserName\AppData\Roaming\Microsoft\AddIns\" to the Path: form field
  7. Click OK to close the window
  8. Click OK to close out of all the modal windows

 

On a Mac (MS Office 2016)

  1. Open the Tools-> Excel Add-ins… menu and browse to the RiffynFunctionsYYYY-MM.xlam file and open it.  ('YYYY-MM' is the year & month of that version of the file.)
  2. Repeat for the RealStats.xlam.
  3. Restart Excel
  4. Select Tools->Add-Ins menu item in Excel
  5. Make sure the RiffynFunctions tick box is selected
  6. You should see a toolbar appear in the bottom left corner of your screen with a "Stack" button on it.

 

On a Mac (MS Office 2011)

  1. Copy RiffynFunctionsYYYY-MM.xlam and RealStats.xlam AddIns to /Applications/Microsoft Office 2011/Office/Add-Ins. ('YYYY-MM' is the year & month of that version of the file.)
  2. Restart Excel
  3. Select Tools->Add-Ins menu item in Excel
  4. Select the RiffynFunctions tick box
  5. You should see a toolbar appear in the bottom left corner of your screen with a "Stack" button on it.

 

Downloads

  • Download RealStats AddIn from http://www.real-statistics.com/free-download/.  RealStats (unaffiliated with Riffyn) was developed by and provided for free by Charles Zaiontz.  Thanks Charles! 
  • Download RiffynFunctions below.
Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request