Skip to main content

Work with scenario comparison reports

Download a scenario comparison report as a Microsoft Excel workbook with tables and charts to compare plan scenarios.

The report includes the following sheets:

  • About—Includes a link to the plan, the export date, and the spreadsheet version.

  • Metrics—Compares the metric values across all scenarios in the plan.

  • Metric Potential (land-use plans only)—Compares the potential metric values across all scenarios in the plan.

  • Zoning Area (zoning plans only)—Compares the zoning area across all scenarios in the plan.

  • Land Use Area (land-use plans only)—Compares the land-use area across all scenarios in the plan.

  • Space Use Area—Compares the space-use area across all scenarios in the plan. This sheet shows the total space-use area, including all development statuses (new, repurposed, and unchanged).

  • Supporting data sheets—Include the raw data for the sheets above.

Note:

  • The scenario comparison report is compatible with Microsoft Excel 2010 or later.

  • Only new metrics are included in the report. See Work with the dashboard to learn more about metrics.

Download a scenario comparison report

To download a scenario comparison report, complete the following steps:

  1. Open the plan editor.

  2. Expand the drop-down menu named after the plan.

  3. Click Download scenario comparison report.

    An Excel workbook is downloaded.

Work with the scenario comparison report in Microsoft Excel

The scenario comparison report is an Excel workbook that contains interactive sheets based on PivotTables. To interact with the report and compare scenario data in Excel, complete the following steps:

  1. Open the downloaded .xlsx file in Microsoft Excel 2010 or later.

    The report opens on the Metrics sheet. If Microsoft Excel opens the workbook in Protected View, click Enable Editing in the header.

  2. Click the sheet tabs at the bottom of the workbook to view the worksheet you want.

  3. Interact with the data in the following ways:

    • Filter the data by using the filter controls on the left side. Depending on the sheet, you can filter by scenario, metric, space-use type, zoning type, or land-use type. To select multiple items, press the Ctrl key while clicking. To select a range of items, press the Shift key while clicking.

    • Rearrange data elements by selecting and dragging rows in the table to new positions. The table and chart update accordingly.

    • Show or hide metric sources by using the plus (+) and minus (-) controls in the table or chart on the Metrics and Metric Potential sheets.

Note:

If your organization uses Microsoft Purview sensitivity labels, the PivotTables may remain empty until you set a sensitivity label for the workbook. After you set the label, reopen the workbook or refresh the data in Microsoft Excel by clicking Data > Refresh All.