Overview:
Traverse XL provides an
easy way to input and analyze traverse data for closed polygon traverses as
well as open linear traverses. This program uses the graphing tools provided in
Excel and automatically displays the traverse data as it is entered.
For closed polygon
traverses, the program balances the traverse using the compass method, provides
statistics regarding misclosure and precision and calculates traverse perimeter
and area. For open linear traverses, the program determines the distance and
direction of the ending point relative to the starting point. Some additional
features that are built in to the traverse worksheets are the ability to rotate
traverse data as well as a way to convert horizontal measurement data from
meters to feet (or vice versa).
In addition to the data
entry and traverse analysis worksheets, there is a page that provides methods
for converting angular data. Finally, an example traverse is provided that
includes an annotated map showing the type of output that can be generated using
the charting functions provided in Excel.
Instructions:
Enter traverse data in to
the appropriate yellow shaded cells on the 'Data Entry' worksheet. Traverse
points must be specified by either entering x,y coordinates or by entering a
combination of a distance and an angle. With respect to distances, the spreadsheet
is designed to accept either horizontal distance directly or calculate a
horizontal distance when a slope distance and slope percentage is supplied.
With respect to angles, the spreadsheet will accept either azimuth or bearings.
The data from the 'Data
Entry' worksheet is automatically linked to the 'Compass Rule Adjustment' and
'Linear Traverse' worksheets.
Worksheets Included:
Data Entry:This worksheet should be
used for enteringr traverse data. Traverse data must be entered in the yellow
shaded cells only. A valid traverse point is defined by x,y coordinates OR a
combination of a distance measurement and angle measurement. If you choose to
paste coordinate point data into this worksheet, you might consider using
Excel's 'Paste Special' -> Values option so that the cell formats are
preserved.
Compass Rule Adjustment: This worksheet can be used
for analyzing closed (polygon) traverse measurements and provides tools for
assessing traverse closure. In addition to the traverse measurements input by
the user, adjusted measurements for a mathematically closed traverse are automatically
generated and can be copied for use in other applications. A visual display contains a map of the
original and adjusted traverse measurements.
Linear Traverse: This worksheet can be used
when analyzing open (linear) traverse measurements and provides measurement
statistics including distances (Euclidean and total traverse length),
directions between starting and ending points and number of traverse courses. A visual display of the traverse course is
included.
Conversion Tools: This worksheet contains
tools that allow users to convert angle units and to calculate distance and
direction between a set of coordinates.
Example Data Entry: This worksheet contains
example data for a closed polygon traverse.
Example Compass Adjustment: This worksheet
demonstrates the sample output from the values in the 'Example Data Entry'
worksheet.
Example Traverse Map: This chart demonstrates
the type of traverse maps that can be generated using this program.
Other Comments /
Suggestions:
If you wish to use this
workbook to analyze multiple traverses, you might consider saving the original
file as a template (File -> Save As Type (Template: *.xlt). When you wish to
enter data for a traverse, open Excel, select 'FIle-> New' and choose the
template name. This will ensure that the workbook will always be opened in the
same state.
Download the Excel Sheet by clicking DOWNLOAD Button >>>>>>>>>>>>>>>>>>
No comments:
Post a Comment