Aarhus Universitets segl

Excel workbooks

The context of this page is explained in Thompson wind tunnel data used for validation of OML and AERMOD/PRIME .

Here are links to 4 Excel workbooks (one for each building shape).

Each workbook contains one central worksheet with a chart as shown in the figure. The chart is dynamic, so the user can vary the stack height or the stack location (using arrow keys), and inspect the resulting changes in concentrations according to both measurements and models.

Be aware that each workbook is quite large (almost 3 MB).

Further, the workbooks are dependent on macros. Therefore you must ensure that the level of macro security set to Medium (in Excel, choose Tools > Options > Security > Macro security > Check Medium .

When you open a workbook you are prompted whether you wish to enable macros. You must reply Yes - otherwise the charts won't work.

We encourage readers to explore the graphs in the spreadsheets. Currently, the best introduction to the spreadsheets is the paper by Olesen et al. (2007a). There is a comprehensive technical report on the OML dispersion model (Olesen et al., 2007b). Page 92-94 of this report gives a further explanation of the data and the graphs.

  • EPA_Cubic -   Contains data for cubic building (Thompson's no. 1)
  • EPA_Wide2 -   Contains data for wide building (dimensions as 2 cubes next to each other; Thompson's no. 13)
  • EPA_Wide4  -  Contains data for very wide building (4 cubes next to each other; Thompson's no. 3)
  • EPA_Long2  -  Contains data for long building (2 cubes, one behind the other; Thompson's no. 4)

The spreadsheets have been tested on a number of systems (including Windows 2000 and Windows XP, running Excel 2003). There may be problems with certain combinations of operating systems, service packs, and Excel versions.

Acknowledgements

We received the Thompson data set from Steve Perry of the US EPA.

We have rearranged the data sets into Excel workbooks with embedded graphs and macros, so that it is easy to vary parameters and inspect concentration results according to measurement and models. Ruwim Berkowicz of the National Environmental Research Institute in Denmark is the author of the Excel macros.