Frequency Dependant Directivities
Furthermore, frequency dependent directivities covering the entire frequency range can be copied via the clipboard to the dialog Directivity (menu Tables|Library (local)|Directivity) or be imported via CadnaA’s ODBC-interface.
Inserting via the clipboard
- To this end, mark and copy a section with data in a MS-Excel spreadsheet to the clipboard.
- On the opened dialog Directivity click the button „Paste“.
Subsequently, the data will be pasted starting from the cell in the upper left (i.e. 0°, 31.5 Hz).
Import via the ODBC-interface
The example makes use of an MS-Excel file containing directivities in columns per direction and per octave):
- Select the command Database|Definition from the File menu.

Dialog File|Database|Definition
- Select an ODBC-driver on "Data Source" (e.g. for MS-Excel). All ODBC-drivers installed on your system are listed.
- Move on the list „Object Type“ downwards and select „Directivity" by mouse click.
- Activate the option „Import Object Type“.
- Now, on the list box „Table“ a data range defined in the MS-Excel file can be selected. This data range has to be defined in MS-Excel prior to the import operation.
- In the table „Assign Columns" each CadnaA-attribute can be assigned to a column of the MS-Excel table. The attributes of the directivity index has the structure "Sxxx_yyyy", where\:xxx: angle from 0° to 180°yyyy: frequency from 31 to 8000 Hz(example: S000_31 or S180_8000)
- Close the dialog Database by OK.
- Select the command Database|Import from the File menu. On the following dialog activate the option "Append non-existing Objects“ and click OK.

Now, the data is imported. Check for the correct import on menu Tables|Libraries (local)|Directivity.