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
Tech Specs
- • Type: Google Sheets Add-on
- • Latest Version: 18
- • Price: Freeware
- • Offline: No
- • Developer: nickbritz
User Reviews
- • 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
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