Compare Report

Icon:

---

Introduction

This command allows the comparison of different objects in the drawing to find distance tolerances, elevation tolerances and other comparison information.

Users can compare points to points, points to surfaces, points to alignment and more.  Detailed information is output to a spreadsheet view and is able to be exported to tables or spreadsheet (via a comma separated file).  The column information in the spreadsheet view will change to suit the report type selected.

Each line (or the analysed cell) can be coloured to highlight tolerance issues (such as surveyed points being too far above or below a surface).

Objects being compared include:

• Points

• Surfaces

• Alignments

• Strings

• Lines

• Polylines

• Alignments

The form is split in two.  On the left is a list of reports comparing objects.  The inputs on the right side change based on the report type selected - once inputs are selected for comparison, clicking on the Update Report button will populate the spreadsheet view below.

Outputs

Outputs from the comparison includes:

• Adding text to the drawing at each point describing any column from the report.  Only useful for reports related to Points

• Export to an Excel spreadsheet (.xls)

• Export to a table in the drawing

• Export to a file

Excel Output

When outputting to Excel, the user is able to create a new Excel file, or append to an existing file (the file should not be open for editing at the time of export).  Excel must be installed on the computer to use this functionality.

Users can pick which columns of the report to export, the Sheet name to create or add data to, and the column (as well as the starting row) to add to in the Excel worksheet.  This functionality allows users to update existing spreadsheets with any information from the report.

Details

Upon selecting the command the following form is displayed:

Report	List of available reports.  Click on a Report Type to select inputs and generate a report.
[List of Report Types]	Select a Report Type to set up and create.  The right side panel options will change to reflect the inputs required.
Report Inputs	Report inputs are dynamic and display pending the Report Type selected.  All possible inputs are shown, below:
Point Group/Point Group 1	Select a point group from the pick list. Displayed for Report Types: Point to Point, Point to Surface, Point to Alignment, Point to String, Point to 2D Polyline, Point to 3d Polyline, Point to Line, Point to Polygon
Point Group `	Select a point group from the pick list. Displayed for Report Types: Point to Point
Polyline	Use the Pick icon, then at the prompt click in the drawing, then click on a polyline.  The object ID will display Displayed for Report Types: Point to 2D Polyline, Point to 3D Polyline, Point to Polygon
Line/Line 1	Use the Pick icon, then at the prompt click in the drawing, then click on a line.  The object ID will display Displayed for Report Types: Point to Line, Line to Line
Line 2	Use the Pick icon, then at the prompt click in the drawing, then click on a line.  The object ID will display Displayed for Report Types: Line to Line
String	Select a created String from the pick list. Displayed for Report Types: Point to String
Code	Select a Code (from the selected String)from the pick list. Displayed for Report Types: Point to String
Display closest alignment details	Select a point group from the pick list. Displayed for Report Types: Point to Point
Alignment/Alignment 1	Select an alignment from the pick list. Displayed for Report Types: Point to Point, Point to Surface, Point to Alignment, Alignment to Alignment, Alignment to Alignment (section)
Alignment 2	Select an alignment from the pick list. Displayed for Report Types: Alignment to Alignment, Alignment to Alignment (section)
Display closest alignment details	Tick on to have the software automatically report the chainage/offset to the nearest alignment in the drawing.  This will override any Alignment selected. Untick to report chainage/offset only to the selected Alignment. Displayed for Report Types: Point to Alignment
Zoom Level	Type in an integer for the zoom level when zooming to points selected in the report list.
Decimal Places	Type in the number of decimal places to report
Report Heading	Type in a heading to add to the report outputs (table in the drawing or file)
Update Report	Click to recalculate the report output
Analysis	Column Name Set the column of data to to use for analysis Apply Full Row Any colours assigned will be applied to all cells in the row. If unticked, only the cell/s under the Column Name will be coloured. Colour Scheme Picklist to select a Colour Scheme. Colour Scheme Edit      Name Multiple Schemes can be created.  When a Scheme is created it is named.  The pick list allows any Scheme to be selected for editing    Add Add a new Scheme    Delete Delete the currently selected Scheme    [Colour List] List of the colours to use in the Scheme for minimum and maximum.  Linear colour change will apply between colours when applied      Value Listing of the order of colours (non editable)     Colour Click to select the colour to apply.  A form will display to select the colour.     Move Up Button to rearrange the colours by moving the selected line up     Move Down Button to rearrange the colours by moving the selected line down    Add Colour Click to add a new colour in the list at the bottom.  A form will display to select the colour.    Remove Colour Remove the selected colour from the list.    Automate Range Weighting Tick on to automate range weighting of the colours. OK Apply and exit. Cancel Exit without change.   Range Min. Type in a minimum value. The most minimum will be displayed when the form is opened.   Range Max. Type in a maximum value. The most maximum will be displayed when the form is opened.   Use absolute values Tick on to report absolute (negative and positive) values.  When ticked on, Positive values between minimum and maximum will be highlighted, and negative values between minimum and maximum value will be highlighted. When unticked, the exact values between Range Min. and Range Max. will be used.     Number of Ranges Toggle to analyse colour ranges by a set number of ranges. Type in an integer for the number of ranges to split colours.     Value increment Toggle to analyse colour ranges with colours split by a value increment. Type in a value increment to split colours.   Compute Ranges Compute the ranges and display on the right side panel. [Right Side Panel] Displays the results of the analysis on the right side panel.   Min Displays minimum elevations.  Non editable.   Max Displays maximum elevations.  Non editable.   Colour Displays the colour applied between the maximum and minimum value per row.  Non editable. Apply Apply the colour ranges on analysed report results.
Text Output	This command adds text to the drawing using an output column from the report   Column (picklist) Set the column of data from the spreadsheet view to add as text to the drawing Select Click on Select to set the text properties:      Style Pick the text style    Layer Pick the CAD layer    Height Type in a text height   Rotation Type in a fixed rotation for the text   Prefix Type in a prefix for the text   Suffix Type in a suffix for the text   Override Colour Tick on to use the colours assigned via Analysis of the report output Create Text Adds text to the drawing.
Excel Connect	Export the contents of the spreadsheet view to Excel.   File Path Non editable field showing the output Excel file New file Click, then navigate to a folder and type in a name for a new Excel file to be created. Open file Click, then navigate to an existing Excel file to append report data to.  [Columns List] List of columns from the spreadsheet view (report) to add to Excel     Tick Box Tick on/off to include a column from the spreadsheet view     Name Name of the column from the report     Sheet Name Sheet name to add cells to in Excel     Start Column Start column of each report item.  Letters must be used and match column names in Excel     Start Row Start row for each report item.  Numbers must be used and match row numbers in Excel Create/Update Click to create/edit the Excel file.  Excel will open if installed on the computer. Close Close the form
Export to Table	Click to create a Table in the drawing.  At the command prompt, click in the drawing, then click where the table (top left corner) should be inserted.
Export to File	Creates a .csv file and opens the file for viewing.  User will be prompted to pick a save location and filename.
Report Outputs	Spreadsheet view of the report results.  Inputs vary pending the Report Type selected.