July 18, 2018
8:30 am - 4:30 pm
Event Phone: 860-563-1990
In daily practice, surveyors rely on the processors built into their CAD programs when reducing raw field data to coordinates. It isn’t that the coordinate geometry is overly difficult, but for large batches of data, pen and paper calculations simply take too long.
This workshop is intended to provide attendees with another tool in the toolbox for working with field data. Microsoft Excel is a widely used spreadsheet program that is likely to be already installed on your office computer.
In hands-on exercises, we will demonstrate how to set up your own Excel template, which can then be used over and over again back at the office. It is anticipated that the template will be valuable as both a backup and a check on your CAD processors, and simultaneously beneficial in terms of reinforcing the COGO formulae and reductions.
We will review spreadsheet basics and unit conversions before dissecting a data set generated by students from Dr. Meyer’s Natural Resources Applications of Surveying course at UConn. This workshop will be a condensed seminar of the same Excel functions, programming, and formatting as taught to UConn students.
To complete this workshop and get PDH or CEU credits you will take a 10-question multiple choice exam at the conclusion of the session. A minimum score of 70% is required to gain the credits for this workshop.