The spreadsheet is a key report for REALTORS® as they search for properties. Typically, this is the initial report that REALTORS® view when the leave the search template. This Quick Start Guide is focused on how to use and customize the spreadsheet.
After performing a search, you will typically see your results in a spreadsheet like below.
In the image below there are 3 rows of tabs and some additional tools.
Multi-tasking functionality of Paragon allows you to have open multiple tabs for different modules of Paragon. Tabs can wrap to additional rows. In this example, tabs are open for Residential and Vacant Land Search/Results, Listings, CMA and Contacts.
In the example below with the Residential tab selected, the maximum of three (3) sub-tabs are displayed in compound buttons of Criteria and Results - name of the report and number of matches displayed within parentheses.
These buttons will be discussed in detail on the next pages.
Allows you to display different sections of the total results in a spreadsheet. Available reports is a list of all reports you can use inside Paragon.
By clicking on the arrowhead next to each report folder, you will either show or hide the different reports inside that folder.
By continuing to hold a left mouse click on a report, you can drag and drop commonly used reports into your Favorites folder make them easy to access at a later time.
The following are the different functions available to you when on any results page.
After checking the boxes on the left side of the lines of property data, clicking the Checked button will show just the properties with a checked box. Properties with a checked checkbox are retained in the filtering process.
Clicking a checkbox on the left side of the property data line selects 1 property at a time. You can check as many checkboxes and you want.
Holding down the control key and clicking anywhere on the property data line. i.e. click properties with a desired value in a given column (data field) as you move up or down that column of data. This selects 1 property at a time.
Clicking Select All – selects all checkboxes. Uncheck the boxes you do not want retained as you filter your results.
Un-filtering or All button -Clicking the All button removes all filtering and displays all of your original search results.
E-mail Button - click E-mail to send an E-mail to a contact and/or client with the Search Results. See the Quick Start E-mailing Listings.
Save button -Hover over Save and click on Save Search to save the search template that brought you these results or listing to a Listing Cart for you or your Client(s). See Quick Start Guide Saving Searches.
Print button - Hover over Print and select the type of printing you want to do.
Drive selection is determined by personal settings in Preferences > User > Application > Saving Export Files.
Customize button -Customizes the display of your search results. This button allows you to select the fields to be viewed, the order the fields appear and how the data is sorted.
The customizing tool allows you to set up your reports to meet your business needs as you communicate with clients. To begin the customizing process, hover over customize and click on Fields. The customizing tool will open. Using the customizing tool, add to or remove fields from the right side of the screen (on the report). Moving fields up on the list, moves the fields to the left on the spreadsheet. Moving fields down on the list, moves the fields to the right on the spreadsheet.
Sorting: Semi-permanent -In addition to placing fields on the spreadsheet, you can determine how your data will be sorted every time you display results on the spreadsheet. Clicking on Sort at the bottom of the Customizing Tool will open a new window.
Use the dropdown boxes to choose fields already displayed on the spreadsheet for sorting. Select if the data for each field should be ascending (A to Z) or descending (Z to A).
All data is grouped by “City”. Within each city, group the properties by the number of “Bedrooms”. Finally, into the grouped data “City & Bedrooms”, add the “Bathroom” data.
When you are finished setting up the sort, click on Save and return to the customizing tool.
When you are finished locating fields and setting your sort preferences, click on Save. Every time you display this spreadsheet, the data will be displayed according to the field order you set (left to right field placement) and sorted based on your maximum of 3 fields.
Actions button -allows you to display additional information on Results pages. By clicking on each of the optional actions, you toggle on or off the display of Criteria and Toggle Stats.
Display of typical search criteria.
Toggle Status - toggles the displaying of the statistics for the search results. Using Preferences, you can set the default display status of Stats, This setting allows you to either display or hid the Stats temporarily.
PDF allows you to choose .PDF format for this report – Paragon controls the page margins.
HTML allows you to choose HTML for this report – your browser controls the page margins.
Add to CMA allows you to add all or selected properties to an existing or new CMA.
Maintain Listing allows you to perform listing maintenance on your own listings in results.
Driving Directions allows you to add selected listings to the Driving Directions tool.