Microsoft Excel is a powerful tool for solving problems in many disiplines. It does, however, have its limitations; there are simply some problems that should not be solved in Excel. This is the first post in a new series in which we ignore these shortcomings and push Excel to its limits to solve problems that it was never meant for.

Microsoft Excel is an incredibly powerful and easy to use tool for data analysis and OR. In this post, I introduce a highly generalised and complex coverage problem and walk through my solving process; from formulation, to model-building.