Only the adjustment row headers are modifiable. If you manually enter in data into the fields below, the fields will no longer update from the database.
The Navigate function allows you to quickly traverse your various project worksheets, or quickly bring a section nestled within a worksheet into view.
2. Add/Arrange Comps
The Arrange Comps function is the venue for selecting which comps you will import into your designated grid, once you have searched for them.
3. Save Subject to Database
It is possible to save the information you are currently working on as a comparable sale record in your database for later use via the Save Subject to Database button.
The options to configure how to this information is stored are interspersed throughout the workbook.
4. Copy Comp IDs to Clipboard
After you have successfully imported comparable sale records into the worksheet, you can copy them to the clipboard.
Usage for this function will vary, but primarily you can use it to easily copy and paste the comparables into a Fast Fetch search in N1 Web to view and edit the records.
5. View Comp Image
Clicking on View Comp Image produces a drop-down where you may choose between the comparables you have imported into the worksheet, allowing you to view any images associated with your selection.
6. View Maps
View Maps gives you a way to visualize your comparable sales and subject property on a map view of your choosing.
Clicking on View Maps produces two options:
|Street View||Opens a web browser that will display your comparable sales and subject property.|
|Google Maps||If installed, will open Google Earth and allow you to view your records with a terrain view of your choosing. Each property will be represented as a clickable pin; clicking on a pin will give you a quick synopsis of the property characteristics.|
7. Comps Database
The Comps Database button is the venue for creating and searching for comparables that you may feature within this worksheet for comparison purposes.
- N1 Web users can click here to learn more.
8. Hide/Show Thumbnails
If you have images associated with the comparables you have imported into the worksheet, you can toggle between viewing or hiding them by clicking on the respective option.
This option is exclusive to N1 Web users.
9. Subject Parcel & Building
The analysis row headers correspond with the fields from Site and Improvements. When set to All, the totals and averages from your parcels and buildings are represented in their respective spot in the analysis grid. GBA, for example, would be the cumulative total of your buildings GBAs.
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 for copying a worksheet, and,
- Follow the instructions for using Paste Text and Map Fields and Tables
The latter step pertains to how you will import that second, third, or fourth sheet into your N1 report document.
10. Show Price Adj.
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.
11. 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 located at the upper-left corner of the Sales Grid worksheet.
There are three options:
- Price / Unit
- Implied Value Per Room
Your selection will affect the Adjusted Unit Price fields.
12. Show 2nd Trend
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 trends date to the date specified in the cell.
13. Synchronize Database
If you were to make changes in the database to properties that have already been imported into the analysis grid, the changes would not be immediately visible. Clicking Synchronize Database will cause any changes that you've made in the database to be reflected in the analysis grid.