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!
By 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!
Comments (16)Subscribe to CommentsComment