High marks will go to a model which follows the design principles of the module, as laid out in the workshop documentation and described during the lectures.

The model should be intuitive and easy to use and not be more complicated than it needs to be, particularly in terms of speed, data management, sheet count and colour use. The model should also be able to handle input errors, and not crash or bug out if the user attempts to use the model inappropriately.

Deliverable

• Upload to moodle an Excel file that operates successfully using Excel 2019. VBA can be used

with a target value of 123 ...then there is no mathematical solution to this problem. In this case, the smallest difference would be 1, with the following arrangement: difference is: target - calculated 123-122 = 1 4 5 - 6 4 result: 1 7 8 6 2 8 9 7 2 9