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.

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

Vertical Curve Fitting

Traverse Adjustment - Compass, Transit, and Crandall Methods

updated 03 Nov '21