Add-in Solution Finder in Excel 2007 is not standard. It is intended for complex calculations when there is more than one unknown. Therefore, it is not included in the usual set of program parameters. But if there is a need for it, then it is able to offer the user effective work and high productivity.
What is a solution search?
Finding solutions in Excel 2007 is an add-in to the program. This means that in the normal configuration issued by the manufacturer, this package is not installed. It needs to be downloaded and configured separately. The fact is that most often users do without it. Also, the add-in is often called the "Solver", because it is able to conduct accurate and fast calculations, often regardless of how difficult the task is presented to it.
If the version of Microsoft Office is original, then there will be no installation problems. The user needs to make several transitions:Options → Tools → Add-ins → Manage → Excel Add-ins.
A window will open in which there is a transition button. After clicking on it, a list of all the proposed add-ons, both installed and unused, will appear on the screen. Now you need to find the Solution Search, then check the box. The tool is activated, you can use it at any time.
Why is a solver needed?
Why can I use Solution Finder in Excel 2007, and is it worth it to install? When the user has an objective function that depends on several parameters, the add-in will select solutions to the problem in accordance with the source data. These may be a variable, unknown, or, for example, the final value. That is, the user can have initial characteristics and an answer, and the program will select the course of the solution and provide a formula.
Thus, through the add-in you can find:- Successful distribution of work resources in order to achieve maximum profit in the course of the company or a separate department or branch.
- Distribution of investments with minimized risks.
- , ( , ).
- . , .
- , , .
, .
?
, Excel , . , . , .
Finding solutions in Excel 2007 is used for the most complex tasks, where there are several unknowns, variables are often found. In a general statement, they can be formulated as follows:- Find unknowns → several “x”.
- Provided that → a formula or function.
- Under restrictions → here, inequality is usually indicated here, or minimum / maximum values.
You also need to point to the cells with which to perform calculations. It is possible to solve several different problems if you set the program the appropriate parameters.
Configure Decision Finder
In order for the Solution Search function in Excel 2007 to work as the user needs, the correct parameters must be entered. Usually they are limited to 1-3 characteristics, but with more complex tasks, global configuration will be required.
The options in the Office Excel 2007 Solution Finder may be the following:- The maximum time is the number of seconds that the user allocates to the program for the solution. It depends on the complexity of the task.
- The maximum number of integrations. This is the number of moves that the program makes on the way to solving the problem. If it increases, then no response will be received.
- Accuracy or accuracy is most often used in decimal fractions (for example, up to 0.0001).
- Tolerance. Used when working with interest.
- Non-negative values. It is applied when a function with two correct answers is solved (for example, +/- X).
- Display of integration results. Such a setting is indicated if not only the result of the decisions is important, but also their progress.
- – . « ».
, .
, Excel, . . . « » . , . .
« ». , . , , .
Excel
There is an obligatory element, without which the Search for Solutions add-in in Excel 2007 - formulas cannot work. They are an expression that performs a particular calculation. Without equality of formulas does not exist. Therefore, the program will not begin to recognize one when the corresponding sign is missing.
The formula may include the following:- Function. This is a standard formula, where there is a certain and specific order of actions, which cannot be changed.
- Link. It indicates the number of cells to be solved. In this case, the cells can be arranged randomly or in a certain order.
- Operator. This is a character that defines the type of calculation (+ - addition, * - multiplication, etc.).
- Constant. A constant value that never changes. Also, to obtain it, you do not need to perform calculations.
The solution of formulas is carried out from left to right, subject to all mathematical rules.
Create Formula
Formulas are equations that facilitate the execution of program calculations. If you do not enter those, then Solution Search in Excel will not work. Tasks, respectively, will not be solved either. Therefore, for the successful completion of the task it is necessary to enter the formula correctly.
The calculation begins with an equal sign. For example, if “= ROOT (cell number)” is indicated in the cell, the corresponding function will be used.
After the basic formula with the “=” sign has been printed, you need to indicate the data with which it will interact. It can be one or several cells. If the formula is suitable for 2-3 cells, then you can combine them using the “+” sign., . , «A», . , .
Excel 2007 . . , .
, , , , . .