nickbritz
•  912
Overview
Create "data tables", "tornado", and Monte Carlo sensitivities. Also, type "<hide>" in Row 1 or Column A to group rows and columns.
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
Reviews
Language:
Sort by:
A User of Sensitivity Macro
April 14, 2020
Does the model need to be on the same tab as the DataTable1 tab? I have the model in another tab and am getting this following error: We're sorry, a server error occurred. Please wait a bit and try again.
Is this review helpful?
Yes
No
A User of Sensitivity Macro
July 27, 2018
This add-on used to work great; still does. But recently, it's not possible to install it on any google user account. When trying to authorize it, the following message is displayed: "Sign in with Google temporarily disabled for this app. This app has not been verified yet by Google in order to use Google Sign In."
Is this review helpful?
Yes
No
A user of Sensitivity Macro
May 11, 2020
Same issue
A user of Sensitivity Macro
April 16, 2020
04/16/20 - same issue. Not fixed yet.
Michael Hazilias
April 12, 2020
Did anyone solve this? I'm having the same issue.
A user of Sensitivity Macro
March 11, 2020
I am having the same issue. what do i do?
Nicholas Britz
December 18, 2019
I think it's working now; please give it a shot
A user of Sensitivity Macro
August 11, 2018
I am having the same issue
Mel A
May 8, 2018
Shows potential but is error'ing out on me for basic inputs.
Is this review helpful?
Yes
No
A user of Sensitivity Macro
April 12, 2020
I'm getting the same error - did anyone overcome it?
A user of Sensitivity Macro
March 11, 2020
Im getting this issue: "Sign in with Google temporarily disabled for this app. This app has not been verified yet by Google in order to use Google Sign In."
A user of Sensitivity Macro
July 1, 2019
Same problem as Jack T.
A user of Sensitivity Macro
June 18, 2018
Can't submit my own review, since I when I try to download this add-on, I'm prompted with: "Sign in with Google temporarily disabled for this app. This app has not been verified yet by Google in order to use Google Sign In." Anyone know how to get past this?
Devin Byrne
April 9, 2018
Easy to use and straight forward!
Is this review helpful?
Yes
No
A User of Sensitivity Macro
January 24, 2018
Works fine. I'm using it to run some Data Tables with good success. Quick questions tho: 1. can we have multiple tables or is it capped to one per file? 2. Is there a way to abort the macro or we need to wait before changing something and rerunning? Thanks
Is this review helpful?
Yes
No
Nicholas Britz
February 8, 2018
Thanks - 1. You can make as many tabs with a single table as you'd like :) however it doesn't support multiple tables within a tab 2. Not an easy way to abort; will look for a way to add in next version
A User of Sensitivity Macro
December 28, 2017
me too. There's nothing coming out of the Sensitivity Macro menu other than help. Give me my 30 minutes back.
Is this review helpful?
Yes
No
A user of Sensitivity Macro
January 2, 2018
try a quick refresh. will work.
Jeremy Pippin
November 22, 2017
I get nothing in Add-ons > Sensitivity Macro menu except "Help"
Is this review helpful?
Yes
No
A user of Sensitivity Macro
January 2, 2018
try a quick refresh. will work.
1-7 of 7
Additional information
nickbritz
Terms of Service
Search
Clear search
Close search
Google apps
Main menu