|Instructions for the 1004 MC 5C Spreadsheet
Don Machholz, Colfax, CA (530) 320-8204
For the 1004 MC it is important to gather the proper information from the MLS. One tool that will do this is the Spreadsheet For The 1004 MC 4C Excel program which I wrote and made available free to all appraisers. It is available from my web site (www.donsappraisals.com)
These instructions tell how to set up your CRMLS (in Southern California) MLS for both the 4C (free program) and for the extended 5C program, available at a small cost from me. Whether you have already set up a 4C custom export and need to upgrade it to 5C, or build a 5C from scratch, these instructions are for you.
It makes it easier if the information is properly formatted when it is copied off the MLS and placed into a separate spreadsheet prior to being pasted into Spreadsheet program.
We can begin by setting our preferences so that your data is in the same order as is needed for the spreadsheet program. Once you make these changes in your MLS setting, you do not need to change it again. Log in to the MLS and click on “My Matrix”.
The next page you will see looks like this, click on “Settings”.
Next, click on “Custom Exports” on the bottom left side of the page.
This takes you to the next page, and from here we will start to create our new export. Click on “Add Export”, or if upgrading to a 5C, click on your 4C solution and hit “Edit Export”. But listen to this, you will be creating a Residential Export, this is the default. You can also create an export for Land or Income Properties, and you will need to do that too (later) if you are dealing with those properties.
You will then get a window like the one to the right. You can name this new export any name you want, like “1004 MC 5C”; here I named it “1004 MC”.
Then pick each parameter on the left box and move it over to the right hand box.
If going from 4C to 5C, all you need to add is the last parameter: “Sale Type”
When you have finished loading up the right-hand box, click on “SAVE”.
This is what is needed for the Spreadsheet program, in this order:
2) Multiple Listing Number
3) List Price
4) Selling Price
5) Year Built
6) Square Footage Structure
7) Acres (although SF of lot can be used if you want)
8) Listing Contract Date
9) Purchase Contract Date
10) Date Closed Sale
11) Days on Market
12) Sale Type
Now we are going to conduct the search and scoop up all categories.
For status date, use a beginning date that is at least two years before your date of value. Put a “+” after the date.
Choose comps, which means you will probably write in parameters for SF, lot size and age of the house.
Don’t use price for comp selection.
Then click on “Results”
When the results are displayed, click on “Check All”.
At the bottom right of the Results page, click on the “Export” button.
This will produce a box like that below.
Choose the export name that we created earlier, in this case, “1004 MC”.
Do not click on the MLS’s created “1004 MC”
Then click on “Export”.
Again: Do not use the MLS’s 1004 MC, it does not work with my spreadsheet.
Open that file on your desktop (it will find Excel on your computer, open it, and pop in the data).
Save this file as part of your work file.
Then copy the first 12 columns of data (but not the Header Row, if it is there, at the very top!) and paste into the Spreadsheet for 1004 MC 5C Excel program.
Follow the instructions at the top of the 1004 MC spreadsheet.