Installing RiffynFunctions & RealStats AddIns

Download the AddIns (same files for Windows or Mac)

  • Download RiffynFunctions.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 RiffynFunctions.xlam and RealStats.xlam to  a directory on your computer.  Somewhere where it will stick around and not get deleted by accident.  For example C:\Users\YourUserName\ExcelAddIns (or C:\Users\YourUserName\AppData\Roaming\Microsoft\AddIns). 
  2. Open 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. Click the Browse... button and find the "RiffynFunctions" AddIn that you just saved.
  7. Click the Browse button again; this time finding the "RealStats" AddIn that you just saved.
  8. Select the tick boxes next to "Realstats" and "Riffynfunctions". Click OK.
  9. Restart Excel
  10. Navigate to the "Add-ins" tab in an Excel workbook.
  11. You should see a toolbar appear in the top left corner of your screen with "1 - Stack" and "2 - Stack Multiple" buttons on it.

Adjust security settings (this may not be necessary)

  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 the directory where you saved the AddIn above 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 Excel
  2. Open the Tools-> Excel Add-ins… menu and browse to the RiffynFunctions.xlam file and open it. 
  3. Repeat for the RealStats.xlam.
  4. Restart Excel
  5. Select Tools->Add-Ins menu item in Excel
  6. Make sure the RiffynFunctions tick box is selected
  7. Navigate to the "Add-ins" tab in an Excel workbook.
  8. You should see a toolbar appear in the top left corner of your screen with "1 - Stack" and "2 - Stack Multiple" buttons on it.

 

On a Mac (MS Office 2011)

  1. Copy RiffynFunctions.xlam and RealStats.xlam AddIns to /Applications/Microsoft Office 2011/Office/Add-Ins. 
  2. Restart Excel
  3. Select Tools->Add-Ins menu item in Excel
  4. Select the RiffynFunctions tick box
  5. Navigate to the "Add-ins" tab in an Excel workbook.
  6. You should see a toolbar appear in the top left corner of your screen with "1 - Stack" and "2 - Stack Multiple" buttons 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