Exporting Data from WY, Casper -  Paragon 5

Using Customize to setup the Export Format

Before you can export data, you must first setup the Export format.  This is a one time action that you will need to do.  The format must be setup as shown in this section for the Focus 1st application to understand the format. 

Once you are in the search spreadsheet screen, use the  button and the Fields menu item, to customize the spreadsheet.  Once you’ve pressed the graphic you will see a dialog box as shown below. 

Note: Be sure that none of the boxes under the “Short Lbl” and “Short Value” heading have a checkmark in them.  If they do, then make sure that they are unchecked.  

Also, there are no problems if you decided to Start from the default spreadsheet and add fields shown below.

First select the name from the “Available” table (on the left) and add it into the “Selected” table (table on the right) by using the  button.  You will see the item move to the table on the right. 

Do this for each of the options as shown in the graphic above. 

Note: Be sure that you create the Spreadsheet report with all the entries shown below.   Also, there is no problems if you decided to include additional items. 

 

·         # of Baths

·         # of Bedrooms

·         Above Grade Sq Ft

·         Address

·         Approx Total SqFt

·         Asking Price

·         City

·         Closing Date

·         Days on Market

·         Expiration Date

·         Listing Date

·         MLS#

·         Off Market Date

·         Price

·         Sold Price

·         Status

·         Status Date

·         Sub Area

·         Total Sq Ft

·         Type

·         Year Built

Once you have completed the task above, save the results by pressing the  "Save" button.  You are now ready to do your MLS search and export results. 

Note this change will need to be done for the Condo spreadsheet as well. 

Casper, WY

In selecting data from the Selkirk MLS, be sure to select the options below:

Make sure that all the status options are selected.  This option will make sure that all the data that is needed to create the appropriate graphs, is collected.   Additonally, to minimize the amount of data downloaded, you may select the “Closed Date” to be 1/1/2006. 

This assumes it is 2008 and you are only looking for the last two years of data. 

You should also make your normal selection choice by selecting other options that you would normally select in doing a CMA.  As mentioned earlier, looking at activity in specific subdivisions is a good starting point. 

Once you’ve selected the search criteria, press the  button to see the results as shown below.  Now you are ready to export the results.  To export the results, select the  drop down button.  The select the "Export to Excel" menu item as shown below. 

When you select the "Export to Excel" menu item, you will see a screen similar to the screen below.  

Select export to save your file.  Notice that you may position your cursor in the “File Name” field and rename the file to be created. 

Once you have saved your exported file, you are ready to run the application. 

When you run the application you will need to find the exported data file, so be aware of where the file has been placed.   It may make sense to move the file to a location that is easier to access. 

For instructions on how to run the application, be sure to see http://www.focus1st.com and take a look at the tutorial section.