GoalSeekResult module
- class GoalSeekResult.GoalSeekResult
Bases:
SpireObjectRepresents the result of a Goal Seek operation in Excel.
This class encapsulates the results of a Goal Seek analysis, including information about the target and variable cells, the number of iterations performed, the target value, and the calculated result. It provides methods to determine if the operation was successful and to access the results of the calculation.
- Determine()
Determines if the Goal Seek operation was successful.
This method evaluates the results of the Goal Seek operation to determine if it successfully found a solution that achieves the target value within acceptable tolerance.
- property GuessResult: float
Gets the calculated result value for the variable cell.
- Returns:
The value found for the variable cell that best achieves the target value.
- Return type:
float
- property Iterations: int
Gets the number of iterations performed during the Goal Seek operation.
- Returns:
The number of iterations performed.
- Return type:
int
- property TargetCellName: str
Gets the name or address of the target cell used in the Goal Seek operation.
- Returns:
The name or address of the target cell.
- Return type:
str
- property TargetValue: float
Gets the target value that was specified for the Goal Seek operation.
- Returns:
The target value that the operation attempted to achieve.
- Return type:
float
- property VariableCellName: str
Gets the name or address of the variable cell used in the Goal Seek operation.
- Returns:
The name or address of the variable cell.
- Return type:
str