Download your local merger analysis results as an Excel workbook, ready to share or include in a submission. You choose which scenarios go in and how much detail to include, which also controls how large the file is and how long it takes to create.

Step 1 - Open Download settings

On the Scenarios page, click the Download results icon at the top right. The Download settings window opens.

Step 2 - Choose what to include

• Scenarios to include - the scenario you're viewing is selected. Add other saved scenarios to download several in one workbook, for example to compare catchment sizes side by side.

• File name - pre-filled from the project and scenario name. Change it if you like.

• Always included - every download contains an Overview, All results and a Methodology sheet.

Then tick the Download options you need:

• Risk rating - flags each local market by its risk rating. Shown when you've set up metrics in the Metrics & risk panel.

• Individual market results - a detailed sheet for each overlapping local market. The number of sheets is shown next to it.

• Site data & distances - the raw data for every site and every distance analysed.

• Include sources - adds source references and, with site data selected, a Site sources sheet.

Step 3 - Add maps and charts (optional)

When Individual market results is ticked, choose its Content:

• Tables only (faster) - just the figures.

• Tables + maps & charts - adds a map and charts to each market sheet.

Maps and charts make the file larger and slower to create, so you can limit them with Limit maps & charts to: all overlap markets, high risk only, medium & high risk, or low & above risk. Sloc shows a Large file size warning when your selection is big.

Step 4 - Generate and download

Click Generate results. Small files are ready in seconds; click Download results to save the workbook.

Larger files can take a few minutes. While they're being prepared, choose Notify when ready to get an email when the file is ready, and carry on working in the meantime.

Pro tips

• For the quickest download, leave Individual market results unticked, or choose Tables only (faster).

• Add maps and charts only for the markets you'll discuss in detail, e.g. High risk only.

• Save your scenarios first, so you can include several of them in the same download.