Spreadsheet

The Spreadsheet, a component of the base package

The basic Spreadsheet is available with every SoundPLAN package like the GeoDatabase, the Result Tables, the Library and the basic Graphics. As the name of the Spreadsheet suggests, it is a toolbox to create new content. Open the results of calculations and add to it connecting the content with formulas of your own.

The Spreadsheet has a variety of formats:
bullet

Receiver Table

bullet

Area Table

bullet

Measurement Map

bullet

Use it to preview what is in the Shape File definition before you open it (you can even amend the file here)

bullet

Combine multiple result files (Single recivers and Façade Noise Maps)

bullet

Add geometrical information (km-post, façade length …)

bullet

Add columns of your own (numerical or text)

bullet

Connect all loaded data columns with free definable formulas

bullet

Several noise relevant calculation operations are available (LEVEL SUM …)

bullet

Display the results in the graphics as Façade Noise Maps, level tables and receiver tables

 
General application

When opening the Spreadsheet you can choose to open an existing Spreadsheet or create a new one from an existing template or start one from scratch. Choose one of the forms of the Spreadsheet and select the data. If you have selected the receiver table for example and selected one of the result files from a SoundPLAN calculation, you already have the basic Spreadsheet.

Add columns with content with results from other calculations or additional data from the calculation that delivered the results that you opened in the first place. For your presentation you may want to include the property owners name or the information if this property already has existing noise control measures. There is a long list of parameters for you to choose from.

The connection to the Graphics

The Façade Noise Map is a good example to show what the Spreadsheet can do. The results of the Façade Noise Map can be opened in the Spreadsheet and the results can be processed. If you calculated Façade Noise Maps separately for road noise, railway noise and industry noise and want to have a comprehensive Façade Noise Map, load the data into the Spreadsheet and add columns for the total result for day and for night (or day, evening, night) and write a formula for these columns to sum up the contributions.

Save the Spreadsheet and open it in the Graphics selecting one of the new columns for the Façade Noise Map results.

The Formula Interpreter

The Spreadsheet has a column setup that allows you to select if a column is visible or hidden, how wide the column shall be and what the title is. For each column you also can define a formula.

On the left you see that for column 21 a formula was written =X19-X17;  The content of column 21 is the content of column 19 minus the content of column 17. The X before the number refers to the column #.

Formulas do not have to be this simple, they actually can be a bit of code with structures IF... THEN.... ELSE....; There are many pre-defined functions for example to add noise levels.

=Lpeg(Epeg(x12)+Epeg(x17))

would sum up the energies from the level columns 12 and 17 and then take the  10 x log10 of this value. In the Spreadsheet Toolbox you also will find the shortcut:  =LEVELSUM(x12,x17).

Structured Tables

The table on the left is a structured table variant of the Spreadsheet where the receiver name is taken out of the regular Spreadsheet and placed in extra rows and the results for all floors for the same location is in tabular form.

Columns are hidden when there is no conflict and printed in red letters if there is. These definitions are controlled by the user the same way as the formulas in the section above.

The Area Table / EU Statistics

From the information supplied in the Facade Noise Map and the definition of the usage areas, the program can derive a noise assessment area by area in the form of an Area Table as seen in the lower part on the left.

The numbers of inhabitants are converted into a statistics for the Lden and the Ln to show how many people are exposed to what noise level bracket.

Along with this display there is a possibility to show conflicts - where are people living that are exposed to noise levels exceeding the noise limits.

The collaboration between the Graphics and the Spreadsheet is important here.

 

.

 

Conflict Table / Annoyance

On the left you see the results of a Facade Noise Map in modified form. The Facade Noise Map supplied the noise levels on the buildings and the number of residents but the noise levels were converted into a percentage of annoyed people and the absolute numbers of these annoyed people then were assigned to the are table for each block unit of housing. It quickly becomes visible where the conflict in this community is.

The formulas above were used to convert the noise levels at the receiver into a percentage of annoyed people.

Other displays would figure out a density of annoyance area by area by taking the number of annoyed people and dividing them amongst the size of the city block.

Density of conflicts

On the left the same information as is seen in the picture above is formatted in a different way. The number of noise effected population per square kilometer is mapped here. Similarly it would be possible to map the number of annoyed or highly annoyed persons in the area.

 

The Measurement Map

On the left you see a noise contour map derived from measured data. Import the X/Y coordinates and the noise levels and map them in the Graphics.

Just as a noise contour map was done from measured data, you also could map other data such as the annual rail fall in a country or other data that you know on a point by point basis.

This function requires the module Cartography.

 

 

Collaboration with other modules

Some of the Spreadsheets functionality requires the presence of the Noise Mapping Toolbox (Conflict Maps, EU Statistics), others require the module Cartography.

Copyright 2014 SoundPLAN international LLC, Shelton, WA 98584, USA