Sensitivity Macro

Sensitivity Macro 18 CRX for Google Sheets

A Free Business Tools Add-on

Published By nickbritz

Sensitivity Macro (kdmhkpflemcfpkkmaajfpggfhoeeffie): Create "data tables", "tornado", and Monte Carlo sensitivities. Also, type "<hide>" in Row 1 or Column A to group rows and columns.... Read More > or Download Now >

Sensitivity Macro for Google Sheets

Download CRX

Download

7.40 KB

Chrome Store

Tech Specs

  • • Type: Google Sheets Add-on
  • • Latest Version: 18
  • • Price: Freeware
  • • Offline: No
  • • Developer: nickbritz

User Reviews

  • 36 Votes, Average: 3.53 out of 5
  • • Rating Average
  • 3.53 out of 5
  • • Rating Users
  • 36

Download Count

  • • Total Downloads
  • 19
  • • Current Version Downloads
  • 19
  • • Updated: March 29, 2017

Sensitivity Macro is a free Business Tools Add-on for Google Sheets. You could download the latest version crx file and install it.

More About Sensitivity Macro

Supercharge data analytics with sensitivities.

Create sensitivity tables and analysis for any model. The functionality is similar to that of the "data table" function in Excel. Build Tornado charts and run Monte Carlo simulations similar to Crystal Ball or @Risk.

Additional functionality to automatically hide rows and columns (similar to "group rows" in Excel) by typing "<hide>" in the first row or column which you would like to hide (Add-ons->Sensitivity Macro->Hide Rows)

Example Directions:
(1) Create a Monte Carlo tab from the pull down menu (Add-ons->Sensitivity Macro->Create Monte Carlo tab)
(2) Create a simple multi-variable model on another tab (for example "ModelSheet")
(3) Write the text names of reference cells of the model inputs in the upper left of the Monte Carlo tab in "A1 notation" (for example: to use cell c5 in ModelSheet as an input, type "ModelSheet!C5" in the Monte Carlo tab cell 'Monte Carlo 1'!C3)
(4) Set your distributions and ranges in the Monte Carlo tab between F3:K7 depending on how many variables you have
(5) Run it from the menu (Add-ons->Sensitivity Macro->Run Monte Carlo)

Tips:
- Try running the sensitivity with the "Example Model" on the tab before linking to a new model
- Useful for valuation models
- Avoid spaces in tab names
- Don't insert rows or columns in sensitivity tabs (else risk breaking the tool)
- Remember to use the text of the reference cell for your model rather than linking
- Keep your model on a separate tab

Coming Next:
- Step-by-step instructions

Download Sensitivity Macro 18

More Add-ons to Consider (Similar or Related)