Grid Formatting Settings

The left-hand menu provides options for formatting the Analysis Grid.

Parcel and Building Selection

This function allows you to use the information you entered for parcels or buildings in the analysis grid as a subject.

The analysis row headers correspond with the fields from Site and Improvements worksheets. When set to All, the totals and averages from your parcels and buildings are represented respectively in the analysis Grid. GBA, for example, would be the cumulative total of all buildings' gross building areas.

However, if you set Subject Building to Building 1, only the GBA for Building 1 would be used as the subject in the analysis grid. The same principle applies to all other selections. If the field you wish to use does not already exist within the analysis grid, you can use the adjustable row headers to select it.

You may need to create a copy of the worksheet if you are planning to represent each building or parcel individually on a sheet. In this case:

Follow the instructions Here.

Subject and Comparable data attributes

The data attributes for the subject and comparables are customizable; you may click on any row header to choose from the drop-down with options that correspond with fields in your database. The row will automatically populate with the respective data from your database for comparables. Click the Refresh Comp Data button to update comparable data.

Show Price Adjustment

The Show Price Adjustment button will reveal two additional rows beneath the Price column: Price Adjustment and Adjusted Price.

You are able to add a Price Adjustment for your subject and comparable sales, resulting in a new value under Adjusted Price.

You must set the Price Adjustment values to $0 if you click Hide Price Adjustment.

Unit of Comparison

Adjustments can be made to the sale price or unit price by selecting the Unit of Comparison(UOC) from the drop-down list.

There are four options:

• Price
• Price / Acre
• Price / Unit
• Price / SF

Your selection will affect the Adjusted Unit Price fields. If Price / Unit is chosen, you must select the Unit type in the Row Header.

Show 2nd Trend

Allows the user to toggle a Second trend for analysis.

This will give you the ability to use different rates if there are apparent discontinuities in property trends in years prior.

The value can be manually entered for the subject property as a compound rate. You may enter 0% or the annual appreciate/depreciation rate. The adjustment is applied from the end of the first trend's date to the date specified in the cell. You may need to change the date in the second trend to drive the adjustment.

Adjustment Format

This dropdown allows the user to toggle between a Quantitative, Qualitative, % Adjustment , $ Adjustment or All view of adjustments.

Show Net/Gross From Price or Adjusted Price

Allows the user to toggle between Gross/Net Adjustment options.