Sheets will automatically re-protect the next time it is activated, unless all worksheets have been protected via Options.

Top

---

Color Codes
Narrative1 uses color codes to cue the user for input, or indicate calculated results and auto-fill data. Color codes are also used for navigation markers, help links and tips.


Top

---

Copy Grids and Other Worksheets second sales grid new sales grid sales grid 2 second land grid new land grid more buildings in improvements copy sales grid copy land grid
To create a second instance of a worksheet, start by right-clicking on the sheet tab.

With Excel 2003 you may see a warning regarding cells with more than 255 characters. Cells with more than 255 characters are usually the comparable sale comments. The simplest way is to repopulate the comp data from the database.

Link the New Worksheet to Word: You will probably need corresponding Narrative for the new Excel worksheet! See Map Fields & Tables.

Top

---

Add Extra Comps To Word ("My comps aren't showing up in Word!")
By default, the Narrative1 template displays three comps for Land, Sales and Leases. New users often assume that the number of comps used in Excel automatically display in Word. Nope, just three, unless you modify you template.

To add more:

1. Create a new blank page in Word
   Keyboard shortcut: Control-Enter
2. Run Fields and Tables (Remember you need to Save Fields & Tables In Excel first).
   
3. Scroll down the list to the comp sheet, select it and click insert

Also: See Map Fields & Tables

Top

---

Add Property Description Sections

Property description sections for Land and Improvements may be found in Narrative1 autotext for builds published after May 2011. To update your autotext, click this link.

Simple place the cursor where the property description narrative belongs, find the appropriate autotext and click "Insert at Cursor"

---

Licensing Policy

We license to the user, not to a computer. We want you to use the software wherever you need to work.

• A license allows you to install the software on as many computers as you personally use (office workstation, server, home, laptop, etc.)


• A license allows you to install the software on computers used by your support staff (secretary, data entry person, etc.) There is no additional fee for support staff use. Support staff does not include appraisers.


• You cannot install the software on other appraiser's computers (associates, friends, etc.)


• We could add a lot of legalese here, but lets keep it simple and fair. If a person is writing appraisals with the software, they should have a license.


• Please make a careful and informed purchase decision as all sales are final.

If you have questions, please call 1-603-968-7462, 9 to 5 eastern time.

Top

---

About Customizing

Note that when you branch off and customize a template, new features that are not spreadsheet level work will still be available to you. For example, most database features are not  programmed at the spreadsheet level, but rather are "add-in" based. These and other new features will run from your customized template.

A word about backups: Save backups often, using a unique name for each backup. An easy method is to right-click on the file name via Windows Explorer and select Copy, then right click again and Paste. Windows will rename the file "Copy x of myfile" each time, and you can do while the file is open. This way if a file becomes corrupt (rare, but it does happen) or if there is an error that you created without realizing it, your backup won't over-write your previous backup and you can roll-back to various points in time.

Top

---

How To Clean Out Temp Files
Windows & MS Office stores temp files and accumulate over time and can slow your system down.

Windows XP:

1. Reboot the computer.
2. Click Start Run and enter %temp%. This will open the folder with temp files and folders. Type Control-a (this will select all the files and folders) and press the delete key. Often a temp file will be in use and stop the delete process; if you sort the files by date and select all the files that are older than the last reboot, you should be able to delete the bulk of the temp files.
   

Windows Vista/Windows 7

1. Click Start Run and enter %temp%. This will open the folder with temp files and folders. Type Control-a (this will select all the files and folders) and press the delete key.

Top

---

Hide and Unhide Rows and Columns
See PDF attachment below.

---

Quickly changing a large group of fields in Word
There are many reasons why you may need to alter the same field that appears over and over in your report. For example, you may want to change acres to square feet, or to square meters. The quickest way to do this is below:

1. Open your Word document.
2. Find an instance of the field that you'd like to change.
3. Select all and press Alt-F9 to toggle all field codes.
4. Copy the field code to the clipboard.
5. Open the Find and Replace window.
6. Paste the field code into the Find text box, and then put the replacement fields in the Replace dialog box.
7. Find each field one by one and replace them with the desired field code.
8. When finished, select all and press Alt-F9 to toggle all field codes.

Top

---

Load Add-ins macro runtime macros add-ins virus  add-in
Sometimes Excel and/or Word will lose track of the Add-ins and give an errors something like

• N1Engine.xla could not be found
• Unable to get the Add property of the "Addins" class

Often this can be easily fixed by running the Load Add-ins utility:

    Programs > Narrative1 > Narrative1 Utilities > Load Add-ins
    Note: Be sure to close all Word, Excel, Outlook and Internet Explorer files before running this utility.

This will open an Excel files with a prominent button labeled "Click to Load Narrative1 add-ins". After this utility runs, it will automatically close Word and Excel.

In Microsoft Word 2007 and Later

1. Click on the Microsoft Office Button and then click Word Options.  The Word Options window appears.
2. From the left-hand tool bar, select Add-ins.
3. At the bottom of the window, select Word Add-ins from the Manage: dropdown.  Click on the Go... button.  The Add-ins window appears.
4. Ensure that the following add-ins are checked:
• N1Code.dot
• N1Ribbon.dotm
  
5. Click on OK.

In Microsoft Excel 2007 and Later

1. Click on the Microsoft Office Button then click Excel Options.  The Excel Options window appears.
2. From the left-hand tool bar, select Add-ins.
3. At the bottom of the window, select Excel Add-ins from the Manage: dropdown.  Click on the Go... button.  The Add-ins window appears.
4. Ensure that the following add-ins are checked:
• N1Ribbon
• Narrative1 Appraisal Engine
• Narrative1 Database
  
5. Click on OK.

Occasionally you will need to restart either Word or Excel following the manual selection of add-ins.

Top

---

Share Comps
There are two tools to share comps:

1. Export Comps from Excel
2. Export Comps From Google Earth
   

---

Percent Values Not Displaying in Grid Percent office not showing % office not showing

Occasionally, when a user accesses comps in the Sales Grid or copies of the Sales Grid, the Percent Office field does not display.  This phenomenon occurs because the Microsoft Excel cells are not formatted to display values stored as percentages.  To remedy this, the cell formats must be changed.

In Microsoft Excel 2003 or earlier

1. Select Tools | Protection | Unprotected Sheet...
   
2. Place your mouse pointer on the row header of the row that will display the Percent Office values.  All values in the row will be highlighted.
3. Right-click on the row header.  A pop-up menu appears. 
   
4. Select Format Cells... The Format Cells window appears.
   
5. Select the Number tab.  Select Percentage from the Category: list.  Click on the OK button.
   

In Microsoft Excel 2007 and Later

1. Select the Review tab and click on the Unprotect Sheet icon.
2. Place your mouse pointer on the row header of the row that will display the Percent Office values.  All values in the row will be highlighted.
3. Right-click on the row header.  A pop-up menu appears. 
   
4. Select Format Cells... The Format Cells window appears.
   
5. Select the Number tab.  Select Percentage from the Category: list.  Click on the OK button.

Top

---