These Excel workbooks are based on and intended to support the material in the respective subject material. They may be used in their current form or modified as needed for educational purposes. They may not be used wholly or in part for commercial purposes. Each is provided as-is with no warranty against defects or errors and the author is not liable for any damages arising from their use.

Each workbook uses Visual Basic for Applications so macros must be enabled in Excel when opening the sheet.

The latest versions of Excel have additional security restrictions with downloaded files. You may have to unblock the file before Excel will run it. Excel will give you a warning message and a link to follow.

Click on a name to download the file. File links are also in the related subject area.

Level Collimation - Computes collimation error using the method described in XX. Instrument Errors and Correction Chapter F. Automatic Level

Two-D Coordinate Transformation- Performs a simple non-least squares transformation. For least squares transformations, use TransPack. It is a standalone Windows program that can perform Conformal, Affine, and Projective 2D transformations.

COGO Intersections and Arc Fitting

Spiral Curve Computations, Version 1.2 updated 16 Dec 2023

Vertical Curve Fitting

Traverse Adjustment - Compass, Transit, and Crandall Methods

Distance and Angle Measurement Error Propagation

NAD 83 Coordinate Conversion: Conversions between SPC , UTM, and Geodetic - all zones except Alaska

updated 06 Apr '24