Spider Chart Step2
Microsoft Excel - From Beginner to Expert in 6 Hours
/ EXCEL DASHBOARD REPORTS
Back To Excel Model Analyzer Start & Demos
Spider step 2
Assign change percentages to input variables.
By default, these percentages are Start 50%, Step 10% and Stop 150%
1. Click on Save Model to save this analysis model, so you can apply it
directly at any time without having to create it again.
2.Click on the Execute button to get the following result: Notice that the inputs chosen are: Sales, Cost of Goods Sold and Sales, General and Admin. Overheads
The first Table shows input variations. Inputs values range from 50% to 150% of the original value.
The second Table shows how Output varies as each input -expressed as a percentage of the initial value- does.
The third Table shows the same as the second one, with Output values expressed as percentages of the initial
value rather than absolute values.
In addition, the above data may be charted to have a pictorial representation of variable behavior.Back To Excel Model Analyzer Start & Demos
Model Analyzer for Excel
Secure Payment Options
Special! Free Choice of Complete Excel Training Course AND Excel Add-ins Collection on all purchases of Model Analyzer for Excel
1 Personal License $139.95 USD 2 - 5 Personal Licenses $118.95 USD 6 - 10 Personal Licenses $104.95 USD 11+ Personal Licenses $69.95 USD Microsoft � and Microsoft Excel � are registered trademarks of Microsoft Corporation. OzGrid is in no way associated with Microsoft.
Contact Us
