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 (Only for Classic Users via Grids)
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 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 subject you have imported into the workbook and 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. If a PasteSpecial Error occurs, verify that your Office version is up to date and contact Support.
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.
If your field is a custom or new field, you may need to add an N1DB name to the field in Site and Improvements. Navigate to the respective worksheet and click the Show Total and Show Databased Record buttons. Add your N1DB named range. Make sure it matches the field name exactly, substituting underscores for spaces. For example: "Current Use" becomes "N1DBCurrent_Use". Make sure that the Totals field pulls from either Parcel 1 or sums or concatenates the data appropriate to the format of the field.
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 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.
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.