Tony and Suzanne Marriott's Phoenix Arizona Real Estate Blog

head_left_image

Database Guru Found!

As a follow-up to my post last Saturday Database Guru Needed I have an update for those out there who have been quietly trying to find out more about this "Top Secret" project!

I had several offers of help - all much appreciated - however - I found during a casual conversation while having lunch with my parents that I had a Database Guru "in the family".

My father - who is a retired Nuclear Physicist and worked on projects such as the Chalk River "National Research Universal" Reactor (hence me being born in Hamilton, Ontario) - has always been a staunch proponent of keeping things simple in programming - and this case was no exception!

DOSBy writing (in his words) a simple program in DOS, and converting the two databases from Excel to .txt files, the task that would have taken a total of 470 hours to complete can be accomplished in a matter of minutes by the PC.  We've tested it on a sample of 1164 contact records - and had successful data merges with 1127 of them.  We're meeting today to figure out how to move the 96.8% accuracy rate to 100% - but even if that can't be done - the manual aspect has been reduced from 470 hours to less than 15 hours - easily manageable.

The output file is easily imported back into Excel - and voila - we have what we need!

I'm going to suggest that he bottle the program and market it!

 

If you are considering selling a home or real estate in the Phoenix area you owe it to yourself to talk with Haven Express at Keller Williams Realty Professional Partners to determine whether Tony Marriott is the best real estate Broker in the Phoenix and Scottsdale metropolitan area to help you with the sale of your home!

About the Authors - Updated 2018

If you are considering a Traditional or Short Sale of your home in Phoenix, Scottsdale or any location in Maricopa County Arizona, you owe it to yourself to talk with the BVO Luxury Group @ Keller Williams Arizona Realty to determine whether Tony and Suzanne Marriott are the best real estate Brokers in the Phoenix and Scottsdale metropolitan area to help you with the Successful Sale of your home.

Tony and Suzanne have personally Listed, Sold and Closed more than a hundred Short Sales with the highest list to close rate in the Phoenix Metro Area!

Tony Marriott - Chief Operating Officer - BVO Luxury Group @ Keller Williams Arizona Realty

Suzanne Marriott - Chief Learning Officer - BVO Luxury Group @ Keller Williams Arizona Realty

Associate Brokers, REALTORS
BVO Luxury Group
Keller Williams Arizona Realty

Comments

WOW,  that is excellent. And a relative, anxious to see how it works out. Do you like your RSS pieces blog ?

I am seriously thinking about doing one with Mary.

Posted by Missy Caulk, Savvy Realtor - Ann Arbor Real Estate (Missy Caulk TEAM) about 12 years ago
How is it they say?  "The older I get the more my father knows."    Don't let him get away.
Posted by JudyAnn Lorenz, Virtual Marketing Consultant (Bar JD Communications) about 12 years ago
Sounds like a great find, Tony.  It's always nice to have a nuclear physicist scientist in the family!  You never know when one might come in handy.  :-)
Posted by Stefan Scholl, Northern Michigan Real Estate (Buyer's Broker of Northern Michigan, LLC) about 12 years ago

Missy - Thanks for stopping by.  It's working out well - we spent some time together today identifying some "bugs" - in the data - not the program - and we'll be at the 99% mark within a day or two - then will unleash the program on the two "master" databases....

Yes - we do like our RSS Pieces blog.  We haven't done as much yet with it as we would have liked - but it is on the schedule and we're steadily migrating traffic from our other websites to www.PhoenixArizonaHomeSearch.com  

Posted by Tony and Suzanne Marriott, Associate Brokers, Serving Scottsdale, Phoenix and Maricopa County AZ (BVO Luxury Group @ Keller Williams Arizona Realty) about 12 years ago

A nuclear physicist who thinks like me, wow!

I am a staunch believe in the KISS principle.  "Keep It Simple Stupid".

Posted by Randy Prothero, Hawaii REALTOR, (808) 384-5645 (eXp Realty) about 12 years ago
Judy - How true!
Posted by Tony and Suzanne Marriott, Associate Brokers, Serving Scottsdale, Phoenix and Maricopa County AZ (BVO Luxury Group @ Keller Williams Arizona Realty) about 12 years ago

Stefan - Yes indeed.  I wonder where I got my analytical traits from! :-)

Posted by Tony and Suzanne Marriott, Associate Brokers, Serving Scottsdale, Phoenix and Maricopa County AZ (BVO Luxury Group @ Keller Williams Arizona Realty) about 12 years ago
Randy - AND he taught me how to play chess - followed by me teaching David Goodman how to play chess.  He played against Goodman a couple of times.  Once he won - the next time was a draw.  Not too shabby!
Posted by Tony and Suzanne Marriott, Associate Brokers, Serving Scottsdale, Phoenix and Maricopa County AZ (BVO Luxury Group @ Keller Williams Arizona Realty) about 12 years ago
Databases are the best!!  Good luck with the conversion.
Posted by Matt Ratcliffe about 12 years ago
Matt - Thanks for stopping by - and don't forget to log in to get points for your comments!
Posted by Tony and Suzanne Marriott, Associate Brokers, Serving Scottsdale, Phoenix and Maricopa County AZ (BVO Luxury Group @ Keller Williams Arizona Realty) about 12 years ago

Enjoyed this post and want to read more - try this one - Peacocks and Pickles for Christmas 2015!  Wishing you a prosperous and Happy New Year!

Posted by Tony and Suzanne Marriott, Associate Brokers, Serving Scottsdale, Phoenix and Maricopa County AZ (BVO Luxury Group @ Keller Williams Arizona Realty) over 3 years ago

Enjoyed this post and want to read more - visit our website  - HavenExpress.com - where all your questions about buying and selling residential real estate in Arizona are addressed!

Posted by Tony and Suzanne Marriott, Associate Brokers, Serving Scottsdale, Phoenix and Maricopa County AZ (BVO Luxury Group @ Keller Williams Arizona Realty) over 3 years ago

Enjoyed this post and want to read more - visit our website  - HavenExpress.com - where all your questions about buying and selling residential real estate in Arizona are addressed!

Posted by Tony and Suzanne Marriott, Associate Brokers, Serving Scottsdale, Phoenix and Maricopa County AZ (BVO Luxury Group @ Keller Williams Arizona Realty) over 3 years ago

Planning to sell your home in Scottsdale, Arizona?  Give us a call for a free, no obligation, consultation!  Haven Express

Listed, Sold and Closed 100% of listings taken (dozens of them) since June 2011!

Real Estate.  It's What We Do. Best!

Posted by Tony and Suzanne Marriott, Associate Brokers, Serving Scottsdale, Phoenix and Maricopa County AZ (BVO Luxury Group @ Keller Williams Arizona Realty) about 3 years ago

Planning to sell your home in Scottsdale, Arizona?  Give us a call for a free, no obligation, consultation!  Haven Express

Listed, Sold and Closed 100% of listings taken (dozens of them) since June 2011!

Real Estate.  It's What We Do. Best!

Posted by Tony and Suzanne Marriott, Associate Brokers, Serving Scottsdale, Phoenix and Maricopa County AZ (BVO Luxury Group @ Keller Williams Arizona Realty) about 3 years ago

Planning to sell your home in Scottsdale, Arizona?  Give us a call for a free, no obligation, consultation!  Haven Express

Listed, Sold and Closed 100% of listings taken (dozens of them) since June 2011!

Real Estate.  It's What We Do. Best!

Posted by Tony and Suzanne Marriott, Associate Brokers, Serving Scottsdale, Phoenix and Maricopa County AZ (BVO Luxury Group @ Keller Williams Arizona Realty) about 3 years ago

This blog does not allow anonymous comments