Create User-Defined Average

<< Click to Display Table of Contents >>

Navigation:  Additional Executive Compensation Assessor Topics (Listed Alphabetically) >

Create User-Defined Average

There are several ways to create a user-defined average:

Select individual areas (e.g., counties or cities). This is a bottom-up approach.  See To Select Areas for a User-Defined Average below.

Narrow the search by state/province, then by county, to view and select available cities.  This is a top-down approach.  See To Browse Areas for a User-Defined Average below.

Search for cities within a radius of another. See Cities in a Radius.

Import one or more user-defined averages.  See Import a User-Defined Average.

 

To Select Areas for a User-Defined Average

1.From any of the main tables:  In Organization Data, click the Averages button in the Area field to open the User-Defined Averages tab in the Browse Areas dialog.

From Advanced Reports: To add a new area, click the button to open the Browse Areas dialog. To change an area already displayed in the table, select the area and click the Browse button to open the Browse Areas dialog.  Click the User-Defined Averages tab.

2.In the User Defined Averages tab, click the button and enter a unique name for your new average.  

3.Select the area type: States/Provinces, Counties, or Cities.  (Note: Averaging more than one area type -- States/Provinces, Counties, or Cities -- is not allowed.  For example, an average of Cities cannot also include States/Provinces or Counties. Averaging areas in more than one country is not allowed.)

4.Click the Add Area button.

5.Search for the desired area and select it from the results list.  Click OK.

6.Repeat steps 4-5 until all desired areas are selected.  Click OK.

7.Click OK.  The new area will be selected in the main table and saved under the User-Defined Averages filter.

 

To Browse Areas for a User-Defined Average

1.From any of the main tables:  In Organization Data, click the Browse button in the Area field to open the Browse Areas dialog.

From Advanced Reports: To add a new area, click the button to open the Browse Areas dialog. To change an area already displayed in the table, select the area and click the Browse button to open the Browse Areas dialog.

2.In the Browse Areas dialog, click the Browse By Region tab to browse regions.

3.Click on the Select Nation field and select an area from the drop-down list.  The state or regional averages in the selected nation will be listed under Available Areas.

4.To narrow the area, click on the Select State (or Select Region) field and select an area from the drop-down list.   The cities in the selected state/region will be listed under Available Areas.

5.To further narrow the area, click on the Select County (or Select Sub-Region) field and select an area from the drop-down list.  The cities in the selected county/sub-region will be listed under Available Areas.

6.Select multiple Available Areas using one of these two techniques:

Hold down the Shift key on your keyboard while clicking a second city to select all cities between the first and the second selected cities. This allows you to select a group of areas that are contiguous (i.e. next to each other).

Hold down the Ctrl key on your keyboard while selecting an additional city.  This allows you to select multiple areas that are anywhere on your list, not necessarily next to each other.

7.Add selected areas to the Selected Areas list using these tools:

To move all of the areas listed under Available Areas to the Selected Areas list, click the button.

To move highlighted areas listed under Available Areas to the Selected Areas list, click the button.

To remove all of the areas listed under Selected Areas, click the button.

To remove highlighted areas listed under Selected Areas, click the button.

8.Once all areas have been selected, click Create New UDA.

9.Enter a unique name for your new average and click OK.

10.The Browse Areas dialog will display the areas included in your new UDA.  Click OK.

11.Click OK to exit the Browse Areas dialog. The new area will be selected in the main table and saved under the User-Defined Averages filter.

 

Note: User-defined averages are not allowed in the Peer Analysis or Valuations tab.

 

To Search for Cities in a Radius for a User-Defined Average

See Cities in a Radius

 

To Import a User-Defined Average

See Import a User-Defined Average

 

To Edit a User-Defined Average

See Edit User-Defined Average

 

To Select a User-Defined Average

See Select User-Defined Average

 

To Create an Organization Profile

See My Organizations

 

To Export to PDF

See Export to PDF

 

To Export to Excel

See Export to Excel