• Home
  • KW Joint Calendar
    • KW Joint Calendar Agenda View
    • Sync Calendar Instructions
    • Maps Coaching
  • Getting Started
    • KW Terminology
    • To Do's First 60 Days
    • Inside MyKW.com
    • Inside eEdge Control Panel
    • KW Tech Orientation
    • KW Tech Setup Guides
    • KW Tech Cheat Sheet
    • KW eEdge Database Setup
    • KW Tech Webinar Schedule
    • Setup KW.com Email on iPhone or Android
    • KW Mobile App
    • HomeKeepr App
    • Continuing Training
    • Listings Syndication Setup
  • How To's
    • Check CE Credits
    • Send Blast Email
    • Publish Office Post
    • BackAgent Notification
    • Create 1 PDF in Dotloop
    • Find Real Estate Forms
    • Forward eEdge Email to Gmail
    • Make a Mailing List From GSMLS
    • Create Greensheets
    • Add OH to KWLS
    • Submit Contract of Sale - Summit MC
    • Submit New Listings - Summit MC
    • Get Brokers Signature - Summit MC
    • Update eEdge Website Theme
    • Find Comps in GSMLS
  • Rosters
    • Summit Phone Roster
    • Westfield Phone Roster
    • Attorney List
  • Resources
    • Scott Leroy Setup Email Explained
    • Scott Le Roy Marketing
    • SLRM Training Schedule
    • Scott Le Roy Training Videos
    • MREA and Books
    • Family Reunion 2016
    • Secure Access
  • KW Zillow Agreement
  • Placester
    • KW Placester Setup Guide
    • Site Themes
    • Sample Site
    • Access Your Site
    • Placester Menu Maps
    • Getting Started by Placester
    • Set Up Tutorial by SLRM
    • Set Up Vendors
    • KW Placester Details
Summit & Westfield KW Resources
Keller Williams Realty Premier Properties

Westfield MC Market Data Charts

The towns I included by default are Clark, Cranford, Scotch Plains and Westfield. To view them, go to: Westfield MC Market Data

To add an additional towns or add to your website, follow the directions below.

Go to the Westfield MC Market Data spreadsheet on google drive.

Copy the spreadsheet to your google drive.

Make a copy of an existing sheet to be used for the new town by following these steps:
  1. Click the down arrow next to the sheet name to open the sheet menu.
  2. From the menu, select Duplicate.
  3. A duplicate sheet (which contains the exact formatting) will appear in a new tab beside the original sheet. It's labeled Copy of Sheet.
  4. Click the down arrow next to the sheet name  to Rename the new sheet.
Go to Terradatum.com to create a report. See figure 1.
Select View Your Report when finished. This will open a PDF.
Picture
Figure 1
On the PDF report, copy the text as shown in figure 2 for the top graph.
Picture
Figure 2
Paste the copied text into the one cell as shown in figure 3. 
This will auto populate the data and update the charts.
Picture
Figure 3
Next, copy the text as shown in figure 4 for all the lower graphs.
Picture
Figure 4
Paste the copied text into the one cell as shown in figure 5.
This will auto populate the data and update all the lower charts.
Picture
Figure 5
Now you can publish the page to the web. Once it is published, you can share the
charts as a webpage using a link or embed the individual graphs into a webpage into.
Picture

The individual charts can also be publish directly into a webpage. 
Picture
Picture