software maintenance

Spreadsheet

The basic format of SoundPLAN's built-in spreadsheet is part of every SoundPLAN program. Use the spreadsheet to generate columns and fill them with information from another calculation run; add more columns and have the program calculate the difference between the different calculations. A flexible formula generator is included that allows numerical, logical operations, text and values in a 'what if' scenario. Advanced options of the Spreadsheet are used in the Graphics to generate conflict maps and to prepare the noise assessment.

After starting the Spreadsheet, select what type of data you want to display. The Option "Level Table" is the most common option and will load results from SoundPLAN calculations, either from Single Receiver Calculations or Facade Noise Maps. Measurement data prepares measurement data for making contour maps. (This option requires the Cartography module). Usage areas can be defined in the Geo-database for each homogeneous section of town. In the "Area Table" variant of the spreadsheet, the number of people exposed to certain classes of noise exposure can be summed and displayed. This table can be opened later in the Graphics to display the exposure. (This operation requires the Grid Noise Map Evaluation module).

Following is a Noise Exposure Map prepared using the Facade Noise Map and the Noise Map Evaluation modules. Details can also be seen under Features/Noise-exposure. The Features/Noise-exposure detail contains the 'how to' manual for generating noise maps.

A receiver type spreadsheet is shown below with a user defined column 20 that included a formula for evaluating the statement whether or not the noise limit is exceeded for day and/or for night.

The spreadsheet allows the user to make new columns for other result filtes to be read into, or the data can be calculated using the formula generator. Columns are addressed simply by placing an "x" in front of the column number, so the difference between column 14 and column 16 would be x16-x14;

Instruction:

Conditional Instruction:

Operators

Operators can be arithmetical operators, relational operators, or Boolean operators.

Arithmetic operators: +, -, *, / (division), ^ (x^y power)

Relational operators: <, <=, =, >=, >, <>

Boolean operators: AND, OR

Value

Constant	Number
Column	a column is defined by XNo (Column Number) in a formula. Multiple columns are divided by a comma, if two dots .. are entered between the columns, all columns in this range are interpreted.
	X1, X3: The columns x1 and x3 are interpreted
	X1..X3: The columns x1, x2, x3 are interpreted
Statistic functions	¾¾ COUNT (¾ Column ¾ Relation ¾ Value ¾) ¾
	¾¾ MIN (¾¾ Column ¾¾) ¾¾
	¾¾ MAX ( ¾¾ Column ¾¾) ¾¾
Text	With relations and instructions, VALUE can also be a text. The text has to be marked by "". Text relations do not differ between normal letters and capital letters.
Arithmetic Functions	¾ Function ( ¾ instruction ¾ ) ¾
ROUND	Result is the rounded value (e.g. round(x10)
	RLS90 rounded value according to RLS 90
	SCHALL03 rounded value according to Schall 03
	TRUNC result is the trunced value
SQR	result is x²
SQRT	result is square root of x
EXP	result is x^y
LN	result is the natural logarithm
LOG	result is the logarithm to the base 10
LogLEV	result is the logarithmic level
ELEV	result is the energetical level
	Example: LogLEV(ELEV(x2)+ELEV (x3)); result is the summed up level
ABS	result is the absolute of an value
GV	Grid value: instead of x if the grid value shall be used (Assessment table)
CV	Conflict value: instead of x if the conflict value shall be used (Assessment table)
GRIDCOUNT	Counts the number of grid values (Assessment table)
CONFLICTCOUNT	Counts the number of conflict values (Assessment table)
RIGHT, LEFT, MID	Function if only a part of a text shall be displayed
	RIGHT (text, number of characters)
	LEFT (text, number of characters)
	MID (text, start position, number of characters)
	Example: RIGHT ("SoundPLAN 5.0",5) result Sound MID ("SoundPLAN 5.0",6,4) result PLAN
TEXT	converts a value in a text, additionally the number of decimal places can be entered
	TEXT (instruction[, decimal places])
	Example: TEXT (x11-x9,1)
VALUE	converts a text in a value
KM	converts the km post calculated in the Geo-Database into km+meter (in GeoDB; 0,665 -> 0+665)

Example:

Enter "yes" in a new text column if the acceptable noise level day or night is exceeded. (The limit is in column x7 (day) or x8 (night) and the level day / night is column x11/x12.)

IF x11 - x7 >0 OR x12 – x8 >0

THEN "yes"

ELSE "-";

The spreadsheet is equipped with special calculation functions to assess the type of windows needed for a given room usage, assess the dimensions and the outside facade and to the calculate the noise level outside the window. The receiver noise levels are derived from a single point calculation or from a facade noise map. The size of the window, total size of the facade, and the transmission index of the facade are needed to dimension the window.

Last modification: 15 January 2004