Taking your comps from Report Writer and exporting them straight into the Excel template is a quick and easy process. You can take a single record and use it as a subject for a new file, or a collection of comps to use in an analysis grid.
1. Select Propertes > Search
Begin by clicking on the Search tab from the navigation bar, and click on a property descriptor that matches what you are looking for.
2. Perform a Search
The Search page will offer a number of different filters for refining your results. Simply fill out your desired search parameters and perform a search.
3. Select Your Records for Export
The Search Results table will become populated and comprised of all records that matched your filters. Find the records that you wish to export to Excel. In the left-most column of the comp(s) you wish to export, click on the empty checkbox. Below the Search Results table, you'll find the Your Selection field filled with all of the IDs of your comp selections. Click Copy, and then open up your N1Appraisal.xlsm file.
Importing a New Subject
To import a new subject, you need only a single property ID.
1. Select a Record for Export
From the Search Results page, note the record you wish to use as a subject, and find its corresponding ID from within the ID column.
2. Enter the ID > Click Import Subject
Within your N1Appraisal.xlsm Excel file, open the File Info worksheet . To the left of the page, you'll find a button that says Import Subject Data from DB. Below that will be a text field where you can enter the ID of the record you wish to import. Type in the appropriate ID, and click Import Subject Data From DB.
Importing Comps to a Grid
To import multiple records from Web to use within a grid worksheet:
1. Click Arrange Comps
Navigate to the appropriate grid worksheet (Land, Lease, Sales). In the top, left-hand corner, find and click on the Arrange Comps button.
2. Enter Record IDs > Click Add to Worksheet
This will produce a new window, where toward the bottom will be an empty text field titled Import Comps From N1-Web. The IDs that you paste within this text field are the same that appear within the Your Selection field on The Search Page. If you clicked Copy while in the Search Page, click Paste from Clipboard to paste in your IDs. Finally, click Add to Worksheet to have the information imported into your Excel file.