Editing the Result Table
Via the menu Tables|Result Table, button „Edit“ the column headings, the numbers of columns and their contents of the Result Table can be edited. Table columns not required can be suppressed from being displayed while the intermediate results in these invisible columns are still saved. Those intermediate results, however, can be referred to in subsequent columns.
Dialog Edit Result Table
Inserting a new Column
In order to create a new column select either the commands Insert before/after from the table’s context menu or press the INS key.
Note
The maximum number of columns in the Result Table is limited to 50 columns.
Shifting Table Columns per Drag&Drop
Clicking into a table row and holding the mouse button pressed enables to move it to new position in the table.
Dialog options
The options on the dialog provide filter options determining which receiver points or parameters are displayed.
Axis for Station
Enter a string corresponding to the ID (see manual "Introduction to CadnaA") of a line-type source (e.g. a road or a railway track) in order to display the station, the distance or the height of a receiver point from this source in the Result Table. This requires that corresponding columns for these values have been defined in the Result Table using the corresponding predefined designations as column content (e.g. „Axis: Station“).
Receiver from Building Noise Map
Select by clicking in the corresponding list box the range of receiver points of the calculated building noise map to be displayed in the Result Table. Either the highest level (max.), the lowest level (min.), or a level at a distinct storey can be displayed.
Noise map of buildings see Building Noise Map.
Only exceeding BNM-Receivers
With this option activated, only those receiver points (facade points) exceeding the specified limiting value/s are displayed (BNM = Building Noise Map).
Sort alphabetically by ID
If this option is checked, the rows of the Result Table are sorted by the ID alphabetically.
Button "Open"
enables to load a file with a table format of the Result Table (*.cnt)
Button "Save"
enables to save the present table format of the Result Table to a file (*.cnt)
Editing a Table Column
For editing, double-click into the corresponding row or select the Edit command from the context menu. This opens the dialog Table Column (see below) enabling to enter the column headings and to define the column contents.
Headers, Lines 1 to 3
Up to three line headings can be defined for every column. Use the expression PREV to combine columns which should receive a common heading.
Example
To identify receiver points two columns in the Result Table are defined (via the context menu). The first column shall display the receiver’s designation with the heading "Name". The second column shall display the ID with the heading "ID". For both columns, however, the superior heading "Receiver" shall be displayed.
- On the dialog Table Column insert in „Line 1“ of for the first row "Receiver", and in „Line 2“ the text "Name".
- Select from the list box „Column“ the item „Name“.
- Click in „Line 1“ of the second row and enter PREV and in „Line 2“ the text "ID".
- Select from the list box „Column“ the item „ID“.
New defined Column Headings on the Result Table
Description
The text entered will be displayed the status bar on screen when the cursor is placed into the respective column of the Result Table.
Expression
In case on list box „Column“ the option „(User Defined)“ or „(String variable)“ is selected, here an expression can be defined (see Result Table in the CadnaA manual „Attributes, Variables, and Keywords“).
List Box "Column"
This list box determines the column content to be displayed (see Result Table in the CadnaA-manual „Attributes, Variables, and Keywords“).
Double arrow (>>)
gives access to pre-defined levels, levels in variants, limiting values, etc. (based on the evaluation parameter LP1, analogously for LP2..LP4).
Precision
Enter the number of digits after the decimal sign.
Rounding up with last digit
Enter the value by which the last digit shall be rounded up.
Note
Note that the input for „rounding up with last digit“ refers to the last displayed decimal. This means that the actual rounding operation takes place from the first, not displayed digit to the last displayed digit.
Example: The level value with 6 decimals shall be 54.151396 dB.
Thus, the following rounded values result depending on the precision and the rounding rule:
| precision | rounding rule | value displayed | Explanations |
| 0 | 0.5 | 54 | 54.1 -> 54 Only from x>=54.5 it would be rounded to 55. |
| 0 | 0.1 | 55 | 54.1 -> 55 Only values 53.1<=x<54.1 would result in 54. |
| 1 | 0.5 | 54.2 | 54.15 -> 54.2 Only values 54.05<=x<54.15 would result in 54.1. |
| 1 | 0.1 | 54.2 | 54.15 -> 54.2 Only values x>54.01<=x<54.10 would result in 54.1. |
| 2 | 0.5 | 54.15 | 54.151 -> 54.15 Only from x>=54.155 it would be rounded to 54.16. |
| 2 | 0.1 | 54.16 | 54.151 -> 54.16 Only values 54.141<=x<54.151 would result in 54.15. |
| 3 | 0.5 | 54.151 | 54.1513 -> 54.151 Only from x>=54.1515 it would be rounded to 54.152. |
| 3 | 0.1 | 54.152 | 54.1513 -> 54.152 Only values 54.1501<=x<54.1510 would result in 54.151. |
Alignment
select the alignment of the text within the table column (with preview).
Display of Column
These options control whether the column content is displayed or not:
- Always: The column content is always displayed.
- Never (Column invisible): The column content is not displayed. The value, however, is existent and can be referred to by using the column number (SP<n>).
- Only If: Whether the column content is displayed or not depends on the condition entered (Only If, Then, Else)
Examples
| only if | then | else | Explanation |
| x>0 | (deact.) | - | Provided the result is larger than zero it is displayed or printed. Otherwise, a hyphen is displayed in this column. |
| x>0 | yes | no | When the value is larger than zero (e.g. with an exceedance) „yes“ is displayed in the column, otherwise „no“. |
Column Width
The following options are available:
- auto: Arranges the column width automatically depending on the space available (default).
- in mm: Specify a fixed column width in mm.
- in chars: Specify a fixed column width in number of characters to be displayed.
Arrow Buttons <-|->
moves to the next/previous data set
Button "New"
generates a new table row below the row currently selected
Conversion to EU-indices at individual receivers with CRTN / TRL
In order to convert results at individual receiver points to the EU-indices Lden and Lnight the Result Table of CadnaA can be used. As with grid calculations (see Grid Arithmetic, Grid calculations for EU-noise indices with CRTN), motorways have to be distinguished from non-motorways. Using two variants, for example, with variant 1 for the motorways, and variant 2 for the non-motorways the layout of the Result Table is as displayed below.
Example
Path: Examples\Tables\TRL conversion for CRTN.cna
In this example, the Result Table calculates the levels Ld, Le, Ln, and Lden from the levels L10,18h for motorways (level LP1@V1 from variant 1) and for non-motorways (level LP1@V2 from variant 2). In this example:
Example
Path: \Examples\Tables \Ld_Le_L_Lden using crtn_x.cnt
This format of the Result Table is provided as a separate format file.
Note
The table format file "comparison Ld_Le_Ln_Lden calc.cnt" compares the results obtained using the „crtn_x“ command with the results obtained by using separate equations.