Ver Demo
Model Analyzer for Excel en accion
Vea: - Como realizar analisis sensitivo usando la herramienta What-if Analysis Manager. - Como puede analizar y administrar mulptiples escenarios usando la funcion Multi Scenarios Manager. - Como realizar un analisis Goal Seek aprovechando la herramienta Goal Seeker Analyzer. - Aprenda como usar la funcion Chart Analyzer para ver la produccion de multiples variables. - Y mas....
(Disponible solo en Ingles)
Multi Scenarios Manager
With this tool you will be able to manage scenarios' sheets created with the scenarios' sheet wizard.
You can manage all three types of scenarios' sheets: BASIC, TABLES and COMBINED.
With the Scenarios module, you can create three types of Scenarios Sheets: BASIC, TABLES and COMBINED.
This functionality can be only applied to BASIC scenarios' sheet created with the scenarios wizard.
If you want to apply a Goal Seek analysis directly on the model use the Goal Seek tool integrated in the Model Analyzer for Excel.
What if analysis
Spider Analysis Option: Use this option to analyze how the selected Output varies as each input does.
Tornado Analysis Option: Use this option to analyze how the selected Output varies as each selected input does, with input ranges depicted as horizontal bars.
Sensitivity Tables Option: Use this option to do "What if" analysis.
With this dialog you can manage previously created and saved What-If type models.
Select the sensitivity model category from the drop-down list.
Goal Seeker Analysis
If you want some output variables in your model to reach specific target or desired values, this tool will help you and make your life easier. It is based on simple principles, but is very powerful at getting the goals sought.
Use this tool to find the breakeven point for your output variables. This will save you a lot of time.
Miscellaneous
Do you need to manage many folders, workbooks and worksheets in one place? Use this powerful tool to select and manage them all.
We often lose valuable time doing repetitive tasks -if, for example, we want to hide the headings in several sheets of the Workbook, we will have to do it one at a time.
This powerful tool has been crated to do away with such loss of time.
How To (online videos)
 Model Analyzer for excel
Multi Scenarios Manager
What-if Analysis
Goal seeker Analysis
|
