skysuite

Google Maps

Four Google-backed geospatial features that insert images or compute distances directly in Excel: a static Road map, a static Satellite map, a Street View image for the address, and a Haversine distance calculator between an ordered list of addresses.

When to use it

  • Adding a Google road or satellite map to a deal sheet, with custom marker color and size.
  • Inserting a Street View shot of the property next to the underwriting summary.
  • Computing the distance from a deal address to a list of amenities or comparable properties, in miles or kilometers.
  • Producing a labeled map for a pitch deck with two marker color sets (primary subject vs comps).

How it works

  1. 1
    Ad-hoc: Click the Google ribbon entry - Road Map, Satellite View, Street View, or Measure Distance. The add-in prompts for addresses and an output cell.
  2. 2
    Automation: Add a Street View action or a Create Map action - Measure Distance is ad-hoc only.
  3. 3
    Street View binds an Input range (address cell) + Output range (insert anchor) + Image type (Street View vs Place photo).
  4. 4
    Create Map binds Input range (primary addresses), optional Secondary input range (secondary addresses), Output range, plus map type, image size, scale, zoom, marker size, and per-set marker colors.
  5. 5
    The action geocodes each address and writes a floating Shape (image) or a row-per-address distance table.

Tips & shortcuts

  • Use named ranges in your model for map insertion anchors - both Street View and Create Map work with named-range bindings, so the image lands in a predictable spot when the workflow is re-run.
  • Scale=2 (the default for Create Map) doubles pixel density on the Google Static Maps request - sharper images for retina exports / PDFs. Don't confuse Scale with Zoom.
  • Two-set maps are useful for comp maps - the primary set might be the subject property in dark blue and the secondary set might be 10 comps in red. Pass them as separate input ranges with different colors.
  • Street View has no Place fallback by default. If Street View has no image for an obscure address, the standalone action surfaces an error. Inside Full Report, SkySuite skips the missing image instead of failing the run.