1004 MC Spreadsheet: An Excel program to Sort MLS Data

Written during Thanksgiving 2008, and revised several times, the free 1004 MC program sorts MLS data for placement into the 1004 MC form.  It runs in all versions of Excel and in Open Office, but not with MicroSoft Works.  It is available here for free download.

If you want me to run the data for you and send you the results, click here

It is important to select the correct instructions and the correct flavor for your MLS.  The 3a versions, no longer provided here, were for the original 1004 MC form that was published in November 2008.  The 4a and 4b are for the updated 1004 MC, the March 2009 version.  For all a 4b version is now available.  This 4b version delivers the Sale Price/List Price ratio in the manner recently requested by Fannie Mae.

On May 9, 2009 I corrected an error that used List Price rather than Sale Price in calculating the $/SF for the chart.  This had produced minor changes in the graph, but did not affect the 1004 MC data in any way.  The 4b versions here have that corrected, among a few other minor user-friendly changes.

On November 19, 2009 I uploaded a new Nevada County Paragon Spreadsheet to handle the new Back on Market categories.
 
The instructions are designed for two purposes: to help you set up the export feature on your MLS (you need to do this only once) and to help you select the proper status and dates so that you scoop up all the needed data to make the program work.

The spreadsheets come in different flavors, for different MLSs.  Some need to have only 11 columns to be downloaded, while others need 13 or more columns.  Read the instructions.
 
The Generic Spreadsheet for the 1004 MC works for MetroList and many other systems, including Rappatoni.  Here is the 4b spreadsheet.  MetroList instructions for the 4b.

Paragon Systems: Spreadsheet 4b. (New)  Paragon (Nevada County, CA) instructions are here.  The spreadsheet was updated Nov 19, 2009.
 
Alameda County (CA) Paragon MLS: Spreadsheet 4b.  Instructions here.
Austin, Texas (ABOR): Spreadsheet 4b.  Instructions here.
Bareis: Spreadsheet 4b.  Instructions here.
Calaveras County (thanks to the good people there who revised the program to fit their MLS): Spreadsheet 4b.  Instructions here.
FLEX MLS: Spreadsheet 4b.  Instructions here.
Houston, Texas (HAR): Spreadsheet 4b.  Instructions here.
Las Vegas, Nevada (MLXChange): Spreadsheet for Excel 1997-2003 4b.   Excel 2007 Spreadsheet 4b.   Instructions here.
MLS CLAW: Spreadsheet 4b.  Instructions here.
MRMLS: with EZ Spreadsheet 4b.  Instructions here.
MLS Listings (REILS) System.  Spreadsheet 4b.  Instructions here. (updated 10/6/09)
San Antonio, Texas MLS:  Spreadsheet 4b.  Instructions are here.
San Diego Tempo: Spreadsheet 4b.  Instructions here.
Tempo: Spreadsheet 4b.  Instructions here.
Tahoe-Sierra MLS: Spreadsheet 4b.  Instructions here.
Washington State (NWMLS): Spreadsheet: 4b.  For instructions, see your MLS.
Yuba/ Sutter County California MLS: Spreadsheet 4b.  Instructions here.

Navica, of Texas does not give us the data we need to construct a spreadsheet.

MLS Alliance does not supply the needed information for a spreadsheet solution.

To customize a spreadsheet and instructions for your MLS I'll need access to your site and about 4 hours of time.

If you are having trouble with your MLS, please call your MLS.  If, after reading the instructions sheet and the instructions at the top of the spreadsheet you are having trouble with your spreadsheet, e-mail me your spreadsheet and I'll look it over.

If you need additional help, I am available for tutoring, at a reasonable fee.
 
If you wish to show appreciation for my efforts, you may donate here:

Other files
I've written some other files that are available here.

Seasonal Variations Template:  Dump in several years of data and see the seasonal differences in your neighborhood.  Useful for comparison to the 1004 MC results.

Spreadsheet for the Three-Year Snapshot:  Takes three years of 1004 MC input to produce several graphs showing long term changes.
 
Market Trend Analysis Program:  A multiple regression program for determining subject value over time, adjusted for SF, lot size and age of property.

Market Trend Analysis Program with one Variable:  A multiple regression program for comparing two sets of data to find the difference in value (ie: pool vs no pool, 3 vs 4 bedroom).

Snapshot of the Past Three Months:  Similar to the 1004MC 13 column, but covers only the last 3 months.

DOM vs Selling Price:  A program to determine quick, or distress sale prices.

Weighted Comps:  Determines final value from comparable data from your grids.