Excel Spreadsheets For 1004 MC

[gregb]

http://www.donsappraisals.com/1004_MC_Spreadsheet_1.html

 

[RSW]

I'll try it and see how it works. I currently use David Brauns's "Total Solution" program. I'll let you know what I think.

 

[Digger88]

a 1004mc only takes 5 minutes, is this faster? cliff notes?

 

[Pilgrum]

I have been using Don's spread sheet for a long time. I love it. It is easy. Plus you can get a couple of scatter graphs to paste into your report.

 

[Doug Wegener]

Ditto. They are great. Don desearves our KUDOS for making this available free to appraisers.

 

[George Hatch]

I have also been distributing free Excel worksheets for the 1004MC on a freeware basis since before the forms became mandatory. My version even includes the form itself.

https://app.box.com/shared/3nx558czgn

 

[Mike Garrett RAA]

I still do it manually...might add 10 minutes to my research and form filling. Hard to teach an old dog new tricks. I do know my MLS has an auto-populate feature but have never learned to use that either.

 

[George Hatch]

I still do it manually...might add 10 minutes to my research and form filling. Hard to teach an old dog new tricks. I do know my MLS has an auto-populate feature but have never learned to use that either.

I'll bet you're doing it wrong.

 

[Mike Garrett RAA]

I'll bet you're doing it wrong.

Could be...but no one has ever questioned it. I search MLS by reported neighborhood. Search 1 is for all listings, pending, under contract, and sold within the last 90 days. Search 2 is for sales only (MLS doesn't give me listing data other than current) for the 180 day time period. Search 3 is for the time period 6 months to a year.

If there isn't sufficient data I might use a one square mile grid rather than neighborhood. Another trick is to use grade school as a searchable feature as often this is a meaningful item that really defines a neighborhood.

We have appraisers who use parameters that I believe are too broad and not really comparable properties. Just for the record, I don't use spread sheets for anything. Guess I should really learn how, right?

 

[George Hatch]

That nobody checks those is a very real observation, and on that basis I can well imagine the lack of incentive to really worry about mathematical accuracy. So it's not something I'd get excited about or criticize you for.

But with that said......

I've never seen an MLS system that didn't provide access to all the expireds, cancelled and withdrawn listings. And if you can search those listings then any of these Excel spreadsheets has the capacity to include them in the various calculations.

The process is dead accurate to whatever extent the database itself is accurate because a spreadsheet program is one big calculator - it does exactly what you tell it to do. It's more accurate than what most people can consistently do with the same data on a manual basis. The entire process (build the search, run for the download, and transfer the download to the spreadsheet) takes about 3 minutes to get the results. It takes longer than that to transscribe the results into the formsware reports.

Moreover, you get the actual medians in the data, not the averages.

I can only imagine how long it would take to do a sp/lp ratio for each of the listings and finding the median for the 3 datasets by hand. And that's just one of the questions.