Tips & FAQs

In no particular order ...
For the Subject

How To Clean Out Temp Files

Free Online Flood Maps

Load Add-ins

Share Comps

Percent Values Not Displaying in Grid



About .xls, .xlsx and .xlsm File Extensions
Prior to Microsoft Office 2007, Microsoft Word and Excel's default file extensions were .doc and .xls, respectively.  With the release of Office 2007, Microsoft introduced two versions of these file types, one whose extension ends with x and one whose extension with m.  The .xlsx or the .docx files are Office documents that contain XML capability.  The .xlsm and the .docm files are Office documents that contain XML capability AND macro capability.

Narrative1 uses macros in both Microsoft Word and Microsoft Excel.  Therefore, if Narrative1 is running on an Office 2007 or later instance, files that are dependent on Narrative1 functionality must be saved as an Office 2003 or earlier format (.xls or .doc) or as a .xlsm/.docm.  If a Narrative1 document is saved in a .xlsx or .docx format, the Narrative1 functionality will no longer be available for use in that document.

Top

Narrative1 Can't Find Google Earth
Right click on the Google Earth icon and select properties, select the target or path that ends with .exe and copy it. When the window comes up indicating an incorrect path, paste the copied path as shown below.


Top

Unprotect Worksheets

Excel 2000,2003

Excel 2007

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.


Note that some cells that require user input are not color coded because they are within tables that display in the narrative exactly as they appear in Excel. Examples are analysis grids and various income analysis tables.

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.



Sometimes virus software will prevent Microsoft Word or Excel to use the Narrative1 add-ins.  In this case, you will need to manually enable the add-ins and change your virus software's protection settings.  For information about enabling add-ins with some common virus software programs, follow these links:

Norton AntiVirus Plug-in for Microsoft Office
Kaspersky


To manually enable Narrative1 add-ins, follow the instructions below.  NOTE: Only do this if the above method does not work for you.

In Microsoft Word 2003
  1. From the menu bar, select Tools | Templates and Add-ins... The Templates and Add-ins window displays.
  2. In the Global Templates and Add-ins box, ensure that the following add-ins are checked:
    • N1Code.dot
  3. If the add-ins are not listed, click on the Add... button.  Browse to the add-ins listed in step 2 (usually found in C:\Program Files\Narrative1) and select them.  Click on the Open button.
  4. Check off these new add-ins and click on the OK button.

In Microsoft Excel 2003

  1. From the menu bar, select Tools | Add-ins... The Add-ins window displays.
  2. In the Add-ins Available: box, ensure that the following add-ins are checked:
    • Narrative1 Appraisal Engine
    • Narrative1 Database
  3. If the add-ins are not listed, click on the Browse... button.  Browse to the add-ins listed in step 2 (usually found in C:\Program Files\Narrative1) and select them.  Click on the Open button.
  4. Check off these new add-ins and click on the OK button.

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.

    We Want Your Feed Back and Ideas!

    Tip:
    Help pages can be printed, but hey, we're all going green, so please think twice before printing.

    Screen shots shown here may be slightly different than your version of Excel N1Appraisal.xls
    Ċ
    Tom Armstrong,
    Mar 4, 2010, 1:22 PM