Changelog
Back to All
Added

Location Analytics — 17 new formulas for motion, geofencing & trips

28 days ago by ReadMe API

GeoSheet now ships a full suite of Location Analytics formulas that turn any POINT cell with history into a motion-aware data source. Combined with Time Warp, you can track speed and heading in real time, detect geofence entries, measure dwell time inside service areas, and reconstruct entire trips retroactively.

Motion

  • SPEED(cell, [units]) — instantaneous speed in km/h, mph, m/s, or knots
  • HEADING(cell) — compass bearing 0–360°
  • TRAVELED(cell, since, [until], [units]) — distance covered over a time window
  • LOCATIONAT(cell, datetime) — historical POINT at a specific moment

Geofencing

  • GEOFENCE(point, polygon) — is this point inside the region right now?
  • GEOFENCEIN(cell, polygon, [since]) — when did it most recently enter?
  • DWELLTIME(cell, polygon, [since]) — total duration spent inside

Proximity & trade areas

  • NEARESTPOINT(ref, range) and NEARESTDIST(ref, range, [unit]) — nearest-neighbour lookups
  • COUNTWITHIN(ref, range, radius, [unit]) — count of points inside a radius
  • POINTSINPOLY(polygon, range) — count of points inside a polygon
  • TRADEAREA(point, amount, [mode], [unit]) — build a catchment polygon by radius or by Mapbox drive-time isochrone
  • OVERLAP(poly1, poly2) — share of the first polygon that overlaps the second (0–1)

Trip analysis

  • TRIPPATH(cell, from, to) — reconstruct a LINE from the history inside a window; plot it on a map to visualize the route taken
  • TRIPDIST(cell, from, to, [units]) — total distance travelled in the window
  • TRIPTIME(cell, from, to, [stationary_kph]) — active moving time, excluding stops below a configurable speed threshold
  • ROUTEDIST(waypoint_range, [units]) — measure a route you build yourself from an ordered range of waypoints

How it fits together

All the motion, geofencing, and trip-analysis formulas read from a cell's temporal history, so anywhere you're already tracking a moving asset — a live LOCATION() cell, an imported GPS trail, or a column updated by a teammate — you can layer analytics on top without restructuring your sheet. Pair them with map charts, alerts, or Geovani ("how far did Alice drive yesterday?") for fleet tracking, field service, delivery ops, and customer trade-area analysis.