Back

How to download divestment results

A divestment plan exports as a spreadsheet, and there are two of them: the divestment summary, which is the remedy itself, and the post-remedy results, which are the local markets as they'd stand once the plan is carried out. Most cases need both - one says what you're giving up, the other shows that it works.

With a plan on screen, click the download icon at the top right and choose which one to build.

The download icon on the Divestments page, with its two exports
The divestment summary

This is the remedy as a document. It always includes a Contents sheet, Problem scope, the Proposed remedy, the Methodology behind the solve and the Risk rating that defined a problem in the first place.

Download divestment summary, with the sheets it always includes

Individual cluster results adds a sheet per problem cluster - the markets in it, the sites given up and the sites kept. The window says how many sheets that is. Worth including whenever someone will question a particular town rather than the plan as a whole.

The post-remedy results

This is the scenario re-stated after the remedy: an Overview, All results and the Methodology, with every local market as it would be once the divested sites are gone.

Download post-remedy results, with the risk rating and data options

Then choose what to add:

  • Risk rating - flags each market by its rating, so the sheet reads the way the screen does. On by default.

  • Individual market results - a sheet per overlapping market. On a plan that clears every overlap there may be none left to write, and the count will say so.

  • Site data & distances - the underlying sites and the distances between them. The window says how many sites and distances that covers.

Name the file, click Generate results or Generate summary, and download it when it's ready.

Pro tips
  • Save the plan before you download. The file is named after it, which matters once three remedies are sitting in the same folder.

  • Download the summary and the post-remedy results from the same plan, in one go. A summary that doesn't match the results it's filed with is an easy thing to be caught out on.

  • An empty Individual market results count is good news - it means no overlapping markets survive the remedy.

  • Leave Site data & distances out of anything circulated widely; it's the full underlying data, not a summary.