So I will admit – I’m an Excel freak. If there is a project, workflow, or experiment to be made – you can bet that I have created an Excel sheet for it. That being said – it does have it’s limitations and when I was faced with a recent predicament that even the almighty Google couldn’t accomplish I had to think outside the box and revisit my old friend Zoho.
Recently, one of my agents and I were talking about the importance of proper pricing and what a seller actually “pays” and “nets” by overpricing their home. That led me to create the below spreadsheet that based on a simple mortgage formula and summing up the monthly costs of ownership for a home-owner (mortgage, taxes, assessments, etc.) Once we have this number we can simply pull simple data using MLS info OR (my personal favorite – Agent Metrics from Terradatum) and plug in the numbers for DOM (days on market) and SP/OLP (sales price to Original List Price ratio).
So this was cool, and I have had a number of agent use this in their listing presentations to either 1. Get the price they want from the start or 2. Show what it has cost the seller already (if they have previously been listed). It’s great info and really drives the point home – however I was stumped when an agent approached me and said, “I’d really like to embed this on my website so that I can drive traffic there from my farm.”
Take 1 = I fooled around with Excel and found that I could export it as a webpage (great) which I could then open with Notepad to see the HTML code (awesome). However, this being a Microsoft based program – I soon found the problem in my ways when viewing this in Firefox:
Take 2 = So I scrapped that idea and went the “cloud based” route and opened up a quick Google Doc. Upload – Activate – Format – Share. Got the code and placed it on my site. Result = #fail Where the sheet showed up fine, the functionality of the sheet was removed and the consumer could not take advantage of putting in their home value, taxes, assessments, etc. (NOTE – I am not saying that I didn’t overlook something, so if I mistaken – please leave my error in the comments section)
Take 3 = I have played around with the suite of solutions put together by Zoho.com off and on over the years. I can’t tell you why i don’t use them more often other than the fact that I (like many) am a slave to Google. So after logging into my Zoho Account – make my way over to Zoho Sheets – upload the document – and presto! See the finished piece below.
Take a look at the functionality in this sheet – the consumer can actually fill in their information on their own and see the true value in correct pricing. Feel free to download and use with your clients – and as always, I’m open and eager for any suggestions on how I could make this better!