Submarket Analytics

The Submarket Analytics worksheet imports annual Submarket Trends from your market analytics provider. This import is available in the 46.02.25 version of the Valuation Model and can be merged into your current template.

Data Export Instructions

1. Navigate to your Market Analytics website.

2. Click on the Data Export tab

3. Make sure to select the following options:

   1. Market Type - Markets

      1. Include Submarkets - choose the appropriate submarket

   2. Data As Of - Today

   3. Building Quality - All

   4. Time Period - Annual

4. Add all Exportable fields

5. Export to Excel and save in your workfile. Do not change the worksheet name, it should be named: DataExport

Import Submarket Analytics

1. Make sure that you have the appropriate Property Major Type and Market/Submarket filled out in the File Info worksheet.

2. Navigate to the Submarket Analytics worksheet. 

3. Click the Import Submarket Analytics button.

   1. A file explorer browser will appear, navigate to your workfile and choose the .xlsx export for your project.

4. Market Trends will import and hide any blank rows.

5. The subheader allows for some customization by choosing the data point from the dropdown, however, this would affect the charts below.

6. Set any unnecessary Rows and Columns to Hide and click the Toggle Display button.

Submarket Overview Table

1. Navigate to the Submarket Overview table

2.  Choose the most recent analysis year and set the data points that are pertinent to your analysis.