This command creates a report of the elevation difference between
points and a design
elevation which can be defined by a grid file, triangulation file, 3D
polyline, section file, note file, road
template file or design points. The station and offset of the points
can also be reported, if a centerline
is specified.
Note the Report Formatter option in the dialog box below. This
option can be used to customize the
report layout, and to
output the report data to Microsoft® Excel or Microsoft®
Access. The standard report can be formatted to allow for the
Cut/Fill difference to be reported in Feet-Inches, and for user
specified decimal place setting for X/Y and Z values. These
options are available from the main Cut Sheet Report dialog box shown
here.
The Points
option reports the horizontal distance and cut/fill between two points.
The points
to compare can be in the same coordinate (.CRD) file or separate
files. The Output Options for the cut sheet report include Bearing-Distance
which reports the bearing and distance difference, if any, between the
points selected. The DeltaX-DeltaY reports
and labels positional difference of the reference and selected points
in x, y values. The same can be said of the North-South-East-West
option. This option will report the positional difference of
reference and selected points to compare but will label the differences
as either North-South-East-West. With the None option selected
only cut/fill values will be reported. If the Report Coordinates
option is checked, the coordinate values of the points will be shown on
the cut sheet report.
When comparing points in the same file, the Points to Compare dialog
appears as shown below. The goal in this dialog is to establish
in the upper window all the
point pairings that you
wish to compare for the cutsheet.
The selection of the points to compare is accomplished in 4 ways:
1) By manually specifying what points are to be compared by picking
the survey and design points and then pressing the add button to add
them to the selected points field at the top of the dialog. This
allows for the assigning of multiple design points to
the same survey point if needed. With this method each pair is
selected and added individually to the list.
2) By specifying a range of survey and design points to be
compared. This is accomplished by entering in the range of
points in the Survey Range of Points field and the Design Range of
Points field and then pressing add. With this option the points
will be compared
sequentially for each range. For example, if points 2000-2004
made up the survey range, and points 2001-2005 made up the design
range, point 2000 will be compared with point 2001 and so on.
3) By point group. This option will compare the points of the
defined survey group with that of the defined design group. The points
will be compared sequentially in the same manner as
comparing ranges of
points described in item 2 above. Once the groups are specified,
press the add button
to verify the selection of the groups. If points in the
coordinate
file have been categorized by groups to define surveyed and design
surfaces, this option makes it very quick to calculate cut and fill
data.
4) By matching points that are within a distance tolerance from each
other, using Match
by Tolerance. This option can be a time-saver, particularly
when
office personnel are not
familiar with the pairings to analyze. When comparing points, there is
an option to flag points in
the report that exceed the specified distance tolerance.
The pairs, ranges or group of points to compare can be saved for
later recall and further cut/fill analysis by selecting the Save
button. The file to be saved will have a prf extension. To
recall a comparison set of points for a cut sheet report press the Load
button and specify the desired *.prf file.
For
the
separate file option, the
point numbers are used to match points between the files. If point
numbers are missing in the
comparison (e.g. points 1 to 3 in the current coordinate (.CRD) file
are
being compared to points 1 and 3 in
the design coordinate (.CRD) file), then there is an option for
reporting the missing points, as seen
in the Compare Points dialog.
When using a 3D
Polyline for the grade elevation, the program calculates
the elevation along the 3D polyline at the position perpendicular from
the
point selected. This calculated elevation is then compared to the
point(s) selected to determine the cut/fill values.
For Grid
and Triangulation
surface files, the design elevation is determined by
the elevation of the surface file at the point selected. With Section Files,
the grade elevation is
interpolated from the offset-elevation data in the section file based
on the
station-offset of the point along the centerline. When using this
method, a centerline file (*.cl) must be specified for station-offset
data.
The Note File
option reads the grade elevation from the note (.NOT) file
that is associated with the current coordinate file. For example, if
the current
coordinate (.CRD) file is job3.crd then the note file name is job3.not.
In
Carlson Software's data collection programs (SurvCE and
Field), there is an option to store stakeout data to the
note file under the Stakeout options. When storing a point in the
stakeout
routines (using SurvCE or Field), the target point number,
coordinates and elevation can be stored to the note file.
This results with the
as-staked coordinate stored in the coordinate (.CRD) file and the
target coordinate stored in
the associated note file. The Cut Sheet report can display this
stakeout data using the
Stakeout Point Comparison report option. The horizontal difference
between the staked point and the target
point can be reported in Bearing-Distance, Delta X-Y or
North-South-East-West format. Also, in
SurvCE and Field, the elevation difference routines can record the
design grade elevation and
station-offset to the note file when a point is stored to the
coordinate (.CRD) file. This grade data can
be reported using the Grade Elevation Report option. The note file
records that the Cut Sheet report uses are TARGET_X, TARGET_Y,
TARGET_Z, TARGET_DESC, TARGET_PT, STATION, OFFSET, VOFF1 and VOFF2.
The Template Design option defines the grade elevation using road design files. For each point, the program finds the station-offset for the point along the centerline and then applies the road design at that station to determine the grade elevation. Grade to Process is used to define the surface to use for the cut sheet comparison. These grades are defined as Top Surface, usually final grade, or subgrades and correspond to the defined grades and subgrades within a template file. The required design files include a centerline (.CL) file, a template (.TPL) file, and a profile (.PRO) file. There are also several optional design files such as Superelevation, Template Point Profile and Template Point Centerline. The design files are created in the Civil Design module. Using the design files in Cut Sheet is similar to the Process Road Design command.
This leads to the following report:
If the Station-Offset
method is selected as an
Input Method, then only the final grade elevations are
produced in the report. This is useful for writing final
grades on the stakes prior to taking field shots. You are
first prompted for the desired offset and starting station,
as shown in the Station Offset dialog. Specify left offsets with the
negative sign (-).
After filling out the Station-Offset dialog with the desired
information, selecting the OK button will result in the following
report showing only the final grade elevations of the specified
station-offsets.
Examples of Cut Sheet reports comparing points are shown next.
 |
| Example 1: Cut Sheet Report comparing points from the Current Coordinate File and with the Use Feet-Inches For Cut/Fill options on. |
 |
| Example 2: Cut Sheet Report comparing points from Another Coordinate file, reporting coordinates for the points. |
Example 3: Steps for Comparing Points in Current Coordinate file and using Report Formatter Option to customize report output to user preference.
1) Check on Use Report Formatter on the Cut Sheet Report dialog.
2) Specify points to compare by one of the four methods described above
for comparing points within the current coordinate file.
3)
Select report content by highlighting the desired data from
the Available list on the left side of the dialog box and then
pressing the Add button to place the selected data in the Used list.
Standard window selection methods using the Ctrl and
Shift keys can be used to select more than one item at a time. After
moving the selected data to the Used window it may be necessary
to move data up or down to obtain the desired order of your
report. To do this use the up and down arrows located on the left
of the Used window.
4) When the desired data has been specified in the Used window press
the Display button at the bottom left of the dialog. For more
detailed information on using the report formatter see the Report
Formatter section of this manual.
Pulldown Menu Location: Survey
Keyboard Command: cutrprt
Prerequisite: A coordinate (.CRD) file
File Name: \lsp\cutrprt.lsp