The Geographic Assessor (GA) allows users to import multiple UDAs from a single file.
To import one or more UDAs, first save your area list. Create a list of postal codes, cities, counties, or states associated with one or more UDAs using a program like Microsoft Excel and save it as a .CSV (comma delimited) file. ERI provides users with a .CSV file template to simplify the upload process. See instructions below.
To Create a .CSV File
1.From Two City Comparison or Graphs: Click the Browse button in the Base Location or Destination Location field in the Options panel to open the Browse Areas dialog.
From Comparison List - Labor or Comparison List - COL: To change the base location, click the Browse button in the Base Location field in the Options panel. To add a new comparison city in the table, click the 
or 
button to open the Browse Areas dialog. To change a comparison city already displayed in the table, click on the selected area and either begin typing the name of the area you are looking for and select the desired area listed OR click the Browse button to open the Browse Areas dialog.
From Estimated Per Diems: To add a new comparison city in the table, click the or button to open the Browse Areas dialog. To change a comparison city already displayed in the table, click on the selected area and either begin typing the name of the area you are looking for and select the desired area listed OR click the Browse button to open the Browse Areas dialog.
| 2. | In the Browse Areas screen, click the User-Defined Average button. |
3.In the User Defined Averages screen, click the 
button to download and save a .CSV file template.
4.Open the .CSV file template using a spreadsheet program like Microsoft Excel.
5.Fill out the template. Required columns are designated with an asterisk (*).
States can be listed in full or using abbreviations (e.g., Washington or WA) in the state column. Canadian provinces must be listed under state. The citystate column is designed to include both the city and state in this format: Seattle, Washington. To import a list of counties, the .CSV file must have three separate columns for county, state, and UDA (the name of the user-defined average associated with the county). See Assessor Series FAQ #40 for suggestions on how to format ZIP codes correctly in Excel for export to an Assessor Series application. Averaging areas in more than one country is not allowed.
The following is example displays the correct format for a .CSV file containing multiple UDAs:
Any data that is not formatted correctly in the .CSV file will not be displayed in the user-defined average.
6.Once the table is complete, give the file a unique name and save the file in the .CSV (comma delimited) format.
7.Close the .CSV file.
Note: If you are importing a list of multiple UDAs and have pre-existing UDAs stored in the Geographic Assessor, consider using a prefix in the UDA names in the .CSV file so that these new UDAs are listed together in the Search Area screen. In the example above, some of the UDA names include numeric prefixes (MSA 1, MSA 2, and MSA 3) so that they are sorted together in numeric order within the alphabetized UDA filter.
To Import a .CSV File
1.From Two City Comparison or Graphs: Click the Browse button under Base Location or Destination Location in the Options field.
| From Comparison List - Labor or Comparison List - COL: Click the Browse button under Base Location in the Options field OR click on a location in the Comparison Cities column of the main table. |
2.In the Browse Areas screen, click the User-Defined Average tab.
3.Click the 
button.
4.In the Upload User-Defined Averages dialog, click the Browse button to select the .CSV file to upload and then click Open. Then click OK.
5.A message will display the number of rows that you have successfully imported. If the .CSV file contains any errors, then a message will display the number of errors encountered during the import and will list the areas needing review (see example below).
6.To export the results to Excel, click 
.
7.In the Choose Export Preferences dialog, select one of more of these options to export:
•Errors
•Warnings
•Successes
8.Click OK in the Choose Export Preferences dialog.
9.Click OK in the Upload User-Defined Averages from file dialog to return the User-Defined Averages tab.
10.All user-defined averages saved in the .CSV file will be uploaded at once, but they will be listed separately in the User-Defined Averages tab.
The following screenshot displays the upload status for the example of a .CSV file containing multiple UDAs shown above. Notice that the status of Skamania County is "Not Found" because the Geographic Assessor database does not contain active cities with survey data in this rural county.
See My Organizations to share lists (or make them private) and manage permission status.
To Create an Organization Profile
See My Organizations
To Create a User-Defined Average
See Create User-Defined Average
To Edit a User-Defined Average
To Select a User-Defined Average