This introductory module shows you how to use spreadsheets (yes spreadsheets!) as a super useful sandbox tool for geospatial applications and spatial engineering.
We’re going to look at the role they can plan in that space between the back of a napkin and production level coding or commercial software. Between field notes and commercial software. When reverse engineering what a product’s doing. For some surprisingly deep levels of data analysis. And / or to help bring your analyses and algorithms to life in more efficient and typically more error free ways.
Here’s a little more on what this is all about …
This is just one tool in your sandbox environment, but the goal here is to build a foundation on which you might want to do everything from quickly analyzing some data, to prototyping an even-pretty sophisticated least squares adjustment or Kalman filtering algorithm – to name just a few examples.
Everything you find here applies to either Microsoft Excel or Google Sheets (with minor differences that we’ll outline for you as we go).
Check out the example we’ll use
This is the example we’ll be using throughout the lessons below (it’s the same one we use in the Browser-based coding as a sandbox tool module):
Get yourself access to a spreadsheet
Get started right away
You need to be signed in and enrolled (see above) in order to do this step.