Ozgrid, Experts in Microsoft Excel Spreadsheets
Javascript DHTML Drop Down Menu Powered by dhtml-menu-builder.com

Active DataXL - Download


AnalyserXL - Download


DownloaderXL - Download


Smart VBA - Download


TraderXL - Download

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