The hook
Spreadsheets are the swiss army knife of survey computations. Closure sheets, level loops, traverse comps, area by coordinates — all faster in Excel than in any general-purpose CAD. Surveyors who can build their own templates work twice as fast as those who can't.
Memorize these
Concepts that show up on the exam
Cell formulas
Excel formulas reference cells (=A2*COS(RADIANS(B2))) — change an input, every dependent computation updates.
Named ranges
Give a cell or range a name (e.g., RADIUS). Formulas using the name read clearly: =RADIUS*TAN(RADIANS(DELTA/2)).
RADIANS / DEGREES
Excel trig (SIN/COS/TAN) takes RADIANS. Always wrap degrees in RADIANS() before calling. Forgetting this is a frequent blunder.
Conditional formatting
Highlight cells based on value rules — e.g., flag closure errors over 0.10 ft in red. Catches bad data at a glance.
Lookup tables
VLOOKUP / INDEX-MATCH / XLOOKUP let you pull rate-of-curvature, geoid undulation, etc. from a reference table by interpolation key.
Don't fall for these
What trips people up
Hardcoding values you should reference
"=120*COS(RADIANS(60))" hides the inputs. Better: input distance and bearing in named cells, formula references them. Now it's a reusable template.
No version of the file
Spreadsheet templates evolve. Without version control, you'll edit the template halfway through a project and lose old computations. Save versioned copies; or use Git.
No documentation in the sheet
A spreadsheet with no comments is read-once code. Add a header row with units, methods, and assumptions so the next surveyor (or you in 2 years) knows what it does.
Test yourself
How well did it stick?
A quick 5-question check on Spreadsheets. See where you stand and what to review.