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

Apply Goal Seeker in Scenarios' Sheet

Microsoft Excel - From Beginner to Expert in 6 Hours/ EXCEL DASHBOARD REPORTS

 

Back To Excel Model Analyzer Start & Demos

Apply Goal Seek in Active Scenarios' Sheet  
 
Use this tool to quickly find the values input variables should take to get a desired result
(output variable value.)

For example, If your current gross margin is $5,000.00 but you want to increase this margin to $9,000.00, how much should your
sales amount to?

This tool works only for input and output variables in the scenarios sheet which have
been created with the Scenarios' Sheet Wizard tool.

In this example, consider the following output variables:

Retained Profit for the Year
Net Operating Profit (NOP)
Gross Margin

 
 
Assign values to them as in the screenshot:

Retained Profit for the Year ($ 30,000.00 , $ 50,000.00 , $ 90,000.00)
Net Operating Profit (NOP) ($ 50,000.00 , $ 70,000.00 , $ 120,000.00)
Gross Margin ( $ 150,000.00 , $ 180,000.00 , $ 210,000.00)

The tool automatically recognizes output variables and loads them into the form
so you can assign actual values to them.

Choose the destination where the results will be located, either in a new
sheet or in a specific range of the active sheet.

 
 
If you do not want to analyze all variable outputs, uncheck the appropriate checkbox(es)
at the right of each variable you want to omit. Then click OK.
 

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