Report to Excel

The pull-down button for Excel reports gives two options:

• Quantity

• Geometry

Quantity

Report options

Pick the report type to use:

• Novapoint Road Quantity report

  • Quantities based cutting the 3D results in the set interval

• Novapoint Road Quantity report by X-section

  • Quantities based on slicing the 3D result features at given intervals, then multiplying by the interval length/step

• DynaRoad (used mainly in Finland)

• Planman (used mainly in Finland)

Select the language to use for the report.

Activate the checkbox for Only summary sheet if you would like only the summary sheet in the Novapoint Quantity report.

• This will not cut the features into pieces.

• This will only present the summary report found in the Novapoint Road reports above.

Section

Set the from-to chainages to make the report from.

By default the report is set to 'Full length' of the road model.

Report sectioning

The report sectioning will extract the quantities in intervals along the road chainage. An interval of 10m will extract the report in the sections that are divided by 10, i.e. ch. 40, 50, 60, 70 in addition to the start and end chainage.

The quantities presented for chainage 50 is a result of the geometries it finds in chainage 45 to 55.

Fixed interval (m) - The default interval is set to 10 m. The excel report will have many sheets that splits with detailed overview of each of the quantities found in the summary sheet, and lists them with the set interval. It is possible to change the interval/step to extract the report from.

As calculated intervals - Will section the quantity report based on the calculation interval set in the road task.

No sectioning - Will make a traditional combined Novapoint report, but without any sectioning interval. In the Excel workbook, the sheets of a traditional combined Novapoint report will be available.

Geometry

Reports for:

• Alignment geometry

• TILOS quantity

• TILOS cut/fill

Note: Traditional Novapoint Quantity reports are not available from this dialog. Use the Quantity tool instead of the Geometry tool to get the quantity reports.

Use this function to generate reports of various data sets to Excel.

• Select the report type and hit the button Send to generate the report.

Run the function from the following locations of the floating window Road Model:

MOUS_ICO Toolbar: Report to Excel

MOUS_ICO Menu: Road > Send > Report to Excel

The dialog box Send Report to Excel will pop up:

• Chainage/stationing - Shows the chainage included in the report.

• Report - Select the report (data set) from the pull-down menu.

• Filter - Use this button to customize the national and international reports (data set) available in the pull-down menu at Report.

• Send - Use this button to execute the function.

Next topic: Setting Out Data