It is crucial to understand that changes may be made to the Solver parameters or to the performed method at any time.
Optimization
Dealing with Optimization Problems
What is Excel Solver?
To activate Solver Add-In:
The Excel Solver Add-In
To copy a sheet in Excel:
Then, we must open the Excel file that contains the tourist visits data for the year 2019 in a sheet called "2019".
Find the Problematic Cell Values
To use Solver with no constraints:
Use Solver with no constraints
To calculate the difference:
Assess the Results
To calculate the difference: Month
So, to continue working in the same Excel file, we will create another copy of the sheet "2019",
So, given the fact that our initial Solver results are not completely satisfactory,
Tourist visits values for 2019 and data after Solver
Now we are ready to take a look to our sheet and assess the results. Taking a closer look at the Solver values for June, July and September, we observe that they are are now extremely high.
Calculate the average
To calculate the average:
Calculate the Average
Arithmetic mean
Use Solver with constraints
To use Solver with constraints:
Solver with Constraints
Constraint
To set the Solver parameters:
To set the constraints:
Set the Solver parameters
In conclusion, the results of the Solver with constraints show that a holistic tourism campaign should be designed in order to increase tourist visits in every month of the year,
Tourist trips values for 2019 and data after Solver with constraints
Assess the Solver with Constraints Results
Read the sentences and tick True or False.
Apply the Solver function in order to design your tourism campaign for the year 2023. Can we use this data for such a purpose? Justify your answer.
Compare the Solver function with no constraints and the Solver function with constraints. Write down two of their basic differences.
Assess the results of the exercise 4 and compare them with the results described in the lesson. Which results do you consider more suitable for designing your tourism campaign? Justify your a
Assess the results of the Solver function that you used in exercise 3, and explain if they are realistic or not? What other solutions do you have in order to obtain better results and why? Ju