A behind-the-scene look at what it takes to get our South Lake Tahoe real estate information on the web for you.
(This was also posted by my brother and partner on our Lake Tahoe blog this morning.)
(LAKE TAHOE REAL ESTATE BLOG) Ok, I’m somewhat computer literate. But it didn’t come easy. We’ve got an extensive digital design background in print, which we’ve talked about briefly in a recent post. Learning how to do that was challenging enough; it took a lot of time, weekend seminars, and semester courses. That was back in the late 80’s and early 90’s, and looking back it seems it took about two years to get up to speed, which meant to me at the time being able to technically produce most any design I could think of and get it printed as magazine quality, high-resolution graphics.
<!-- technorati tags end --> Perhaps the most difficult of the software programs we had to learn back then was Photoshop. That took the longest to learn. It’s much easier to grasp and use now, but that was before Photoshop 3.0 introduced layers. Before that, in its pioneer phase, Photoshop had no layers, which meant that enhancing images with such things, for example, as true opaque shadows, back-lighting, text glows, beveling, embossing..., all common, easy-to-do Photoshop parlor tricks now, had to be done using hand-built, time consuming masks. These then had to be applied to the image directly.
Now all such Photoshop enhancements are not done by hand anymore. Masks are instantly built automatically by the software itself, which requires no learning curve, and then kept in isolated layers that can be easily changed. Back then that was not possible. Any enhancement, after being saved only once, could not be undone, thus any changes to an image had to be made starting from scratch all over again. That meant one always had to make and save back-up copies of every image... every time, otherwise changes were always permanent, and unwanted changes meant that the image was destroyed.
I realize this Photoshop discussion is likely tedious, or Greek, to many of you. It’s arcane, I agree, but I went into a little detail purposefully because what we’ve had to do to learn how to build this blog, and create such information resources for you on it as the neighborhoods and absorption rates, for example, eclipses everything we’ve ever done to learn about computer applications by a landslide.
It began last November. That was when we decided we would get our blog up and running... and that to do it the way we thought best, we’d have to do it ourselves. One of the outcomes of this decision meant that Gary would have to focus for the most part on all of our client services: showing listings, working with Buyers, processing escrow... etc. It also meant that I had to go back to school. And that I would be confronting face-to-face the dreaded “Code”, the precipice where what I knew about the computer falls to nothing, and the very wall of all of my prior computer resistance.
The first thing I had to do was become willing. Next was resolve. I had to make a deal with myself that I was going to get through it... no matter what. Then came about a month of research and reading, mostly downloaded information from WordPress, lots of things about Web 2.0, blogging in general, and two key articles from Steve Pavlina.com.
The school day for the research phase was basically when I was awake. It was the least fun of all. In retrospect, I should have stated with Lynda.com immediately, but I didn’t know that then. I thought I needed to know more about where I was going before I got on the road to get there. Reading and research was therefore my travel guide, and to be completely honest, sometimes I had no idea what I was looking at and trying to comprehend at all. Much of the time, I just wanted to quit, throw all of this computer-code-blog-web-crap against the wall, and sub-contract the work out... which almost always means loss of control to a techno geek that does not know the real estate industry, and more time and more money than what was agreed upon.
Lynda.com is where the fun started. It’s the best place in the world to learn a computer application. It teaches with immediate, online videos that are available 24/7. Each video is a detailed, step-by-step process that is supported by sample files that one can download and use over and over again. By doing this while following the instructions on each video... knowledge, comfort and confidence with the application comes. Their courses of instruction offered range from esoteric, high-end CGI (motion picture graphics), modeling and animation to the basic Mac OS and Windows operating systems, and most everything in between.
The school day for this phase was from when I woke up, usually around 6 am, until my eyes were to fuzzy to see clearly, usually around 9 pm. Rather than work out of our main office where there are some distractions, or my home office machine that my wife’s son sometime uses for school, most all of this phase was done at our dining room table working on a Dell 17” laptop and a Mac Pro 17” laptop at the same time.
To set up our foundation for this blog, being able to edit it, and to create the real estate information pages that we planned to make available for you, I watched 691 Lynda.com videos from December 10th to a few days ago on the following courses:
Html Essential Training
XHTML Essential Training
Dreamweaver 8 Essential Training
Dreamweaver 8 Beyond the Basics
CSS for Designers
CSS Web Site Design
Excel 2003 Essential Training
Power Point Essential Training
All of these have to do with web development, even Excel and Power Point, which have web interfaces, and have advanced features that are essential to learn, particularly Excel formulas, functions and macros, which may not at first seem to have anything to do with the web, but have everything to do with getting huge amounts of real estate information data processed and web-ready quickly.
The work on our Neighborhoods and Absorption Rates comes from a combination of three software programs. The actual numbers come off our MLS, and are gathered and then formulated in Excel. The spreadsheets and actual statistical charts are done there. It’s automated for the most part, with built-in formulas, functions and macros. Photoshop is involved as well, particularly for the stat charts. That too is somewhat automated through batch processing and Photoshop’s actions function. It’s all assembled in Dreamweaver, and that too is templated and somewhat automated via it’s history panel, primarily to take the data out of Excel and reformat it for the web.
The Neighborhood “prototype” took three days to build. Absorption Rates took a few hours to create for the web, but a few days to program in Excel. It’s triggered by a inserting a data feed into one page (don’t you know we named it “data” in the workbook), and on doing that the chart that you see on the web populates automatically.
I just learned a lot more when we did the first Neighborhood though, and today I’ll start taking apart and re-doing the entire Absorption Rates section... because I can do it better, and make it easier for you now.
That’s enough geek stuff for a long time. We just thought you might like this behind the scene look at our determination, and what’s involved, for us to bring you “all the information... all the time” about your South Lake Tahoe real estate market.
(Please comment below about this post, or anything else where we might be helpful to you. If you liked it, please click on the “Vote for Me” icon in the left sidebar and add us to your technorati and del.ici.ous bookmark accounts.)