{"id":592,"date":"2016-11-02T20:36:18","date_gmt":"2016-11-02T20:36:18","guid":{"rendered":"http:\/\/www.noisemap.ltd.uk\/wpress\/?page_id=592"},"modified":"2017-01-20T23:55:44","modified_gmt":"2017-01-20T23:55:44","slug":"the-results-processor","status":"publish","type":"page","link":"http:\/\/www.noisemap.ltd.uk\/wpress\/the-results-processor\/","title":{"rendered":"The Results Processor"},"content":{"rendered":"<h1>WHAT IT DOES<\/h1>\n<p>You often need to process the results of your noise modelling in order to draw some conclusions about the noise impact of the project. NoiseMap quickly creates a large amount of noise information, so you may need some assistance in getting meaningful conclusions.<\/p>\n<p>This is where the Results Processor comes into play. This is an advanced new feature in NoiseMap 5.2 which greatly enhances the \u2018Compare Contour\u2019 function of earlier versions of NoiseMap.<\/p>\n<p>It also lets you calculate and compare\u00a0changes\u00a0of noise levels at <a href=\"http:\/\/www.noisemap.ltd.uk\/wpress\/features\/results-processing\/results-at-individual-receivers\/\"><strong>individual receivers<\/strong><\/a>, a new feature.<\/p>\n<p>The Results Processor can produce more meaningful noise contours and can replace the use spreadsheets in many cases.<\/p>\n<p><span style=\"font-size: large;\">W<\/span><span style=\"font-size: medium;\">HAT SORT OF RESULTS PROCESSING CAN YOU PERFORM<\/span><span style=\"font-size: large;\">? <\/span><\/p>\n<p><span style=\"font-family: CG Omega,CG Omega; font-size: medium;\">The results processor works on both <\/span><b><span style=\"font-size: medium;\">noise contours <\/span><\/b><span style=\"font-family: CG Omega,CG Omega; font-size: medium;\">and <\/span><b><span style=\"font-size: medium;\">noise levels <\/span><\/b><span style=\"font-family: CG Omega,CG Omega; font-size: medium;\">at individual receivers. <\/span><\/p>\n<p>In summary, the Results Processor lets you:<\/p>\n<p><span lang=\"ZH-TW\" style=\"font-family: Wingdings,Wingdings; font-size: xx-small;\">\uf06f <\/span><span style=\"font-family: CG Omega,CG Omega; font-size: medium;\">Add or subtract a fixed amount to each result; <\/span><\/p>\n<p><span lang=\"ZH-TW\" style=\"font-family: Wingdings,Wingdings; font-size: xx-small;\">\uf06f <\/span><span style=\"font-family: CG Omega,CG Omega; font-size: medium;\">Add or subtract any two or more results; <\/span><\/p>\n<p><span lang=\"ZH-TW\" style=\"font-family: Wingdings,Wingdings; font-size: xx-small;\">\uf06f <\/span><span style=\"font-family: CG Omega,CG Omega; font-size: medium;\">The addition or subtraction can be arithmetic or logarithmic; <\/span><\/p>\n<p><span lang=\"ZH-TW\" style=\"font-family: Wingdings,Wingdings; font-size: xx-small;\">\uf06f <\/span><span style=\"font-family: CG Omega,CG Omega; font-size: medium;\">Take the average value of two or more results; <\/span><\/p>\n<p><span lang=\"ZH-TW\" style=\"font-family: Wingdings,Wingdings; font-size: xx-small;\">\uf06f <\/span><span style=\"font-family: CG Omega,CG Omega; font-size: medium;\">Take the larger or smaller value of two or more results; <\/span><\/p>\n<p><span lang=\"ZH-TW\" style=\"font-family: Wingdings,Wingdings; font-size: xx-small;\">\uf06f <\/span><span style=\"font-family: CG Omega,CG Omega; font-size: medium;\">Calculate a new value based on comparing one result with another; <\/span><\/p>\n<p>You can\u00a0download any number of sets of results to do comparisons between multiple sets of results.<\/p>\n<p><span style=\"font-size: xx-large;\">CONTOUR RESULTS PROCESSING <\/span><\/p>\n<p>You may\u00a0try out\u00a0these examples from the <em>ManualExampleDatabase.nmdb<\/em> database supplied with NoiseMap.<\/p>\n<p><strong>CONTRIBUTION OF NEW ROAD TO CHANGE OF LEVEL<\/strong><\/p>\n<figure id=\"attachment_606\" aria-describedby=\"caption-attachment-606\" style=\"width: 300px\" class=\"wp-caption alignnone\"><a href=\"http:\/\/www.noisemap.ltd.uk\/wpress\/wp-content\/uploads\/2016\/11\/contribution-to-change-of-level.bmp\"><img decoding=\"async\" loading=\"lazy\" class=\"wp-image-606 size-medium\" src=\"http:\/\/www.noisemap.ltd.uk\/wpress\/wp-content\/uploads\/2016\/11\/contribution-to-change-of-level-300x204.bmp\" alt=\"Contribution of new road to change of level\" width=\"300\" height=\"204\" srcset=\"http:\/\/www.noisemap.ltd.uk\/wpress\/wp-content\/uploads\/2016\/11\/contribution-to-change-of-level-300x204.bmp 300w, http:\/\/www.noisemap.ltd.uk\/wpress\/wp-content\/uploads\/2016\/11\/contribution-to-change-of-level-768x523.bmp 768w, http:\/\/www.noisemap.ltd.uk\/wpress\/wp-content\/uploads\/2016\/11\/contribution-to-change-of-level.bmp 1014w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/a><figcaption id=\"caption-attachment-606\" class=\"wp-caption-text\">Showing where a new road increases noise levels<\/figcaption><\/figure>\n<p>This example shows how noise levels have increased alongside a new link road. This has been calculated by arithmetically subtracting the contribution of noise of existing roads from the total future noise level. Note that the increase in level is also shown at the receiver points, being as high as 3.9 dB at this location.<\/p>\n<p>The contour and receiver results can be exported for use in spreadsheets and reports.<\/p>\n<p>The Results Expression used here is simply:<br \/>\n<b><span style=\"font-family: Courier New,Courier New; font-size: medium;\">R1-R2<\/span><\/b><\/p>\n<p><span style=\"font-size: medium;\">where <\/span><b><span style=\"font-family: Courier New,Courier New; font-size: medium;\">R1 <\/span><\/b><span style=\"font-size: medium;\">is the Total Future Noise Level and <\/span><b><span style=\"font-family: Courier New,Courier New; font-size: medium;\">R2 <\/span><\/b><span style=\"font-size: medium;\">is the noise level from existing roads. <\/span><\/p>\n<p><em><span style=\"font-family: CG Omega,CG Omega; font-size: medium;\">Note that this result is <\/span><b><span style=\"font-family: CG Omega,CG Omega; font-size: medium;\">not <\/span><\/b><\/em><span style=\"font-family: CG Omega,CG Omega; font-size: medium;\"><em>the same as showing the contribution of noise from the new road. In areas where the noise from existing road is very high, a large contribution of noise from the new road may not have a significant effect overall.<\/em> <\/span><\/p>\n<p><strong>EXCEEDANCE OF A TRIGGER LEVEL<\/strong><\/p>\n<figure id=\"attachment_605\" aria-describedby=\"caption-attachment-605\" style=\"width: 300px\" class=\"wp-caption alignnone\"><a href=\"http:\/\/www.noisemap.ltd.uk\/wpress\/wp-content\/uploads\/2016\/11\/exceedance-of-trigger-level.bmp\"><img decoding=\"async\" loading=\"lazy\" class=\"size-medium wp-image-605\" src=\"http:\/\/www.noisemap.ltd.uk\/wpress\/wp-content\/uploads\/2016\/11\/exceedance-of-trigger-level-300x207.bmp\" alt=\"Showing areas where a trigger level is exceeded\" width=\"300\" height=\"207\" srcset=\"http:\/\/www.noisemap.ltd.uk\/wpress\/wp-content\/uploads\/2016\/11\/exceedance-of-trigger-level-300x207.bmp 300w, http:\/\/www.noisemap.ltd.uk\/wpress\/wp-content\/uploads\/2016\/11\/exceedance-of-trigger-level-768x531.bmp 768w, http:\/\/www.noisemap.ltd.uk\/wpress\/wp-content\/uploads\/2016\/11\/exceedance-of-trigger-level.bmp 1015w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/a><figcaption id=\"caption-attachment-605\" class=\"wp-caption-text\">Exceedance of trigger level<\/figcaption><\/figure>\n<p>This example shows areas where the future total noise level is greater than 60 dB and the contribution of noise from the new road exceeds 1 dB.<\/p>\n<p>The results expression is:<\/p>\n<p><b><span style=\"font-family: Courier New,Courier New; font-size: medium;\">if(((r1-r2)&gt;1 and r1&gt;60),10,-10)<\/span><\/b><\/p>\n<p><span style=\"font-size: medium;\">where <\/span><b><span style=\"font-family: Courier New,Courier New; font-size: medium;\">r1 <\/span><\/b><span style=\"font-size: medium;\">is the Total Future Noise Level and <\/span><b><span style=\"font-family: Courier New,Courier New; font-size: medium;\">r2 <\/span><\/b><span style=\"font-size: medium;\">is the noise level from existing roads. <\/span><\/p>\n<p>Note that the value of 10 is applied where the trigger is exceeded \u2013 this is shown in red on the map. A value of -10 is applied where the trigger is not exceeded.<\/p>\n<p>Interpolation of results is \u2018switched off\u2019 of setting the Contour Display Parameters to show \u2018Unsmoothed Contour Data\u2019 and the automatic colour generation is overridden by selecting to display only contour values of -10 and 10.<\/p>\n<p><strong><span style=\"font-family: CG Omega,CG Omega; font-size: large;\">S<\/span><\/strong><span style=\"font-family: CG Omega,CG Omega; font-size: medium;\"><strong>HOWING TRIGGERS AT RECEIVERS<\/strong> <\/span><\/p>\n<figure id=\"attachment_604\" aria-describedby=\"caption-attachment-604\" style=\"width: 300px\" class=\"wp-caption alignnone\"><a href=\"http:\/\/www.noisemap.ltd.uk\/wpress\/wp-content\/uploads\/2016\/11\/trigger-levels-at-receivers.bmp\"><img decoding=\"async\" loading=\"lazy\" class=\"size-medium wp-image-604\" src=\"http:\/\/www.noisemap.ltd.uk\/wpress\/wp-content\/uploads\/2016\/11\/trigger-levels-at-receivers-300x166.bmp\" alt=\"Showing which receivers exceed a trigger level\" width=\"300\" height=\"166\" srcset=\"http:\/\/www.noisemap.ltd.uk\/wpress\/wp-content\/uploads\/2016\/11\/trigger-levels-at-receivers-300x166.bmp 300w, http:\/\/www.noisemap.ltd.uk\/wpress\/wp-content\/uploads\/2016\/11\/trigger-levels-at-receivers-768x425.bmp 768w, http:\/\/www.noisemap.ltd.uk\/wpress\/wp-content\/uploads\/2016\/11\/trigger-levels-at-receivers-672x372.bmp 672w, http:\/\/www.noisemap.ltd.uk\/wpress\/wp-content\/uploads\/2016\/11\/trigger-levels-at-receivers.bmp 1015w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/a><figcaption id=\"caption-attachment-604\" class=\"wp-caption-text\">Showing which receivers exceed a trigger level<\/figcaption><\/figure>\n<p>Exactly the same procedure is applied to individual receiver results. The results shown on the above map apply to first floor receivers and it can be seen that noise levels on the fa\u00e7ade facing the new roundabout do exceed the trigger. [Ground floor receivers do not exceed the trigger, which corresponds to the noise contour.]<\/p>\n<p><strong>INDUSTRIAL NOISE<\/strong><\/p>\n<figure id=\"attachment_603\" aria-describedby=\"caption-attachment-603\" style=\"width: 300px\" class=\"wp-caption alignnone\"><a href=\"http:\/\/www.noisemap.ltd.uk\/wpress\/wp-content\/uploads\/2016\/11\/contribution-from-industrial-site.bmp\"><img decoding=\"async\" loading=\"lazy\" class=\"size-medium wp-image-603\" src=\"http:\/\/www.noisemap.ltd.uk\/wpress\/wp-content\/uploads\/2016\/11\/contribution-from-industrial-site-300x215.bmp\" alt=\"Showing the spread of noise from an industrial activity\" width=\"300\" height=\"215\" srcset=\"http:\/\/www.noisemap.ltd.uk\/wpress\/wp-content\/uploads\/2016\/11\/contribution-from-industrial-site-300x215.bmp 300w, http:\/\/www.noisemap.ltd.uk\/wpress\/wp-content\/uploads\/2016\/11\/contribution-from-industrial-site-768x550.bmp 768w, http:\/\/www.noisemap.ltd.uk\/wpress\/wp-content\/uploads\/2016\/11\/contribution-from-industrial-site-1024x733.bmp 1024w, http:\/\/www.noisemap.ltd.uk\/wpress\/wp-content\/uploads\/2016\/11\/contribution-from-industrial-site.bmp 1229w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/a><figcaption id=\"caption-attachment-603\" class=\"wp-caption-text\">Showing the spread of noise from an industrial activity<\/figcaption><\/figure>\n<p>This shows the contribution of noise from an industrial site, relative to the total noise level in an area.<\/p>\n<p>Two results sets were loaded:<\/p>\n<p><span style=\"font-family: Courier New,Courier New; font-size: medium;\"><b>R1 <\/b><\/span><span style=\"font-size: medium;\">= Total Noise from All Roads \u2013 L<\/span><span style=\"font-size: xx-small;\">Aeq <\/span><span style=\"font-size: medium;\">16 h parameter chosen<br \/>\n<\/span><span style=\"font-family: Courier New,Courier New; font-size: medium;\"><b>R2 <\/b><\/span><span style=\"font-size: medium;\">= Industrial site \u2013 L<\/span><span style=\"font-size: xx-small;\">Aeq <\/span><span style=\"font-size: medium;\">16-h calculated <\/span><\/p>\n<p>The Results Expression is:<br \/>\n<span style=\"font-family: Courier New,Courier New; font-size: medium;\"><b>R1 = logsum(R1,R2) \u2013 R1<\/b><\/span><br \/>\nThis is the total noise level from All Roads and the Industrial site, less the noise from the industrial site alone \u2013 i.e. the effective contribution of noise from the Industrial site.<\/p>\n<p>It can be seen that the effect of the site is very localised.<\/p>\n<p>HIGH-FREQUENCY NOISE<\/p>\n<figure id=\"attachment_602\" aria-describedby=\"caption-attachment-602\" style=\"width: 300px\" class=\"wp-caption alignnone\"><a href=\"http:\/\/www.noisemap.ltd.uk\/wpress\/wp-content\/uploads\/2016\/11\/effect-of-high-frequency-noise.bmp\"><img decoding=\"async\" loading=\"lazy\" class=\"size-medium wp-image-602\" src=\"http:\/\/www.noisemap.ltd.uk\/wpress\/wp-content\/uploads\/2016\/11\/effect-of-high-frequency-noise-300x215.bmp\" alt=\"Showing where high-frequency noise exceeds the background level\" width=\"300\" height=\"215\" srcset=\"http:\/\/www.noisemap.ltd.uk\/wpress\/wp-content\/uploads\/2016\/11\/effect-of-high-frequency-noise-300x215.bmp 300w, http:\/\/www.noisemap.ltd.uk\/wpress\/wp-content\/uploads\/2016\/11\/effect-of-high-frequency-noise-768x551.bmp 768w, http:\/\/www.noisemap.ltd.uk\/wpress\/wp-content\/uploads\/2016\/11\/effect-of-high-frequency-noise-1024x734.bmp 1024w, http:\/\/www.noisemap.ltd.uk\/wpress\/wp-content\/uploads\/2016\/11\/effect-of-high-frequency-noise.bmp 1230w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/a><figcaption id=\"caption-attachment-602\" class=\"wp-caption-text\">Showing where high-frequency noise exceeds the background level<\/figcaption><\/figure>\n<p>In this example, we are looking at where high-frequency noise from the site might be dominant. (This does not mean that it would be audible, as the previous example shows that traffic noise is dominant in most of the area.)<\/p>\n<p>Two Results Sets were loaded:<\/p>\n<p><span style=\"font-family: Courier New,Courier New; font-size: medium;\">R1 \u2013 BS5228 L<\/span><span style=\"font-family: Courier New,Courier New; font-size: xx-small;\">Aeq <\/span><\/p>\n<p><span style=\"font-family: Courier New,Courier New; font-size: medium;\">R2 \u2013 BS5228 L<\/span><span style=\"font-family: Courier New,Courier New; font-size: xx-small;\">eq <\/span><span style=\"font-family: Courier New,Courier New; font-size: medium;\">(2kHz) <\/span><\/p>\n<p>The Result Expression was:<\/p>\n<p><b><span style=\"font-family: Courier New,Courier New; font-size: medium;\">R1 \u2013 R2<\/span><\/b><br \/>\n<span style=\"font-size: medium;\">with the name <\/span><b><span style=\"font-family: Courier New,Courier New; font-size: medium;\">\u2018High-frequency noise\u2019. <\/span><\/b><\/p>\n<h3>OTHER EXPRESSIONS<\/h3>\n<p>NoiseMap allows highly-sophisticated expressions to be created. Because Result Expressions can be quite complex, you can save them for re-use with the Script Interface.<\/p>\n<p>The following sections of this guide give more details on creating and using Results Expressions.<\/p>\n<h1><span style=\"font-family: CG Omega,CG Omega; font-size: xx-large;\">USING THE RESULTS PROCESSOR <\/span><\/h1>\n<p>Firstly you will need to create a noise model and calculate some results \u2013 either noise contours or results at individual receivers. These results will have been stored in the database.<\/p>\n<p>The first step in using the Results Processor is to download the results from the database, using the Results Explorer.<\/p>\n<p><span style=\"font-size: medium;\">When you download results from the database, you get the complete set of results for the scenario\/ tiles\/ calculation\/ combination that you have chosen. For this reason it is called a <\/span><b><span style=\"font-family: CG Omega,CG Omega; font-size: medium;\">Result Set<\/span><\/b><span style=\"font-size: medium;\">. <\/span><\/p>\n<p>LOAD DATABASE RESULTS \u2013 RESULTS EXPLORER<\/p>\n<p>Open the Results Explorer by selecting<\/p>\n<p><span lang=\"ZH-TW\" style=\"font-family: Wingdings,Wingdings; font-size: xx-small;\">\uf06f <\/span><b><span style=\"font-family: Courier New,Courier New; font-size: medium;\">Calculate&gt; Load Database Contours<\/span><\/b><span style=\"font-size: medium;\">, or <\/span><\/p>\n<p><span lang=\"ZH-TW\" style=\"font-family: Wingdings,Wingdings; font-size: xx-small;\">\uf06f <\/span><b><span style=\"font-family: Courier New,Courier New; font-size: medium;\">Calculate&gt; Load Receiver Results<\/span><\/b><span style=\"font-size: medium;\">. <\/span><\/p>\n<p>This very powerful tool shows, for the whole database:<\/p>\n<p><span lang=\"ZH-TW\" style=\"font-family: Wingdings,Wingdings; font-size: xx-small;\">\uf06f <\/span><span style=\"font-size: medium;\">All the scenarios <\/span><\/p>\n<p><span lang=\"ZH-TW\" style=\"font-family: Wingdings,Wingdings; font-size: xx-small;\">\uf06f <\/span><span style=\"font-size: medium;\">All the calculation methods that have been used <\/span><\/p>\n<p>For Noise contours, it also shows:<\/p>\n<p><span lang=\"ZH-TW\" style=\"font-family: Wingdings,Wingdings; font-size: xx-small;\">\uf06f <\/span><span style=\"font-size: medium;\">The grid-size resolution of all calculated noise contours <\/span><\/p>\n<p><span lang=\"ZH-TW\" style=\"font-family: Wingdings,Wingdings; font-size: xx-small;\">\uf06f <\/span><span style=\"font-size: medium;\">The height of the noise contours <\/span><\/p>\n<p><span lang=\"ZH-TW\" style=\"font-family: Wingdings,Wingdings; font-size: xx-small;\">\uf06f <\/span><span style=\"font-size: medium;\">The category combinations of calculated contours <\/span><\/p>\n<figure id=\"attachment_601\" aria-describedby=\"caption-attachment-601\" style=\"width: 300px\" class=\"wp-caption alignnone\"><a href=\"http:\/\/www.noisemap.ltd.uk\/wpress\/wp-content\/uploads\/2016\/11\/results-explorer-window.bmp\"><img decoding=\"async\" loading=\"lazy\" class=\"size-medium wp-image-601\" src=\"http:\/\/www.noisemap.ltd.uk\/wpress\/wp-content\/uploads\/2016\/11\/results-explorer-window-300x202.bmp\" alt=\"Results explorer window\" width=\"300\" height=\"202\" srcset=\"http:\/\/www.noisemap.ltd.uk\/wpress\/wp-content\/uploads\/2016\/11\/results-explorer-window-300x202.bmp 300w, http:\/\/www.noisemap.ltd.uk\/wpress\/wp-content\/uploads\/2016\/11\/results-explorer-window-768x517.bmp 768w, http:\/\/www.noisemap.ltd.uk\/wpress\/wp-content\/uploads\/2016\/11\/results-explorer-window.bmp 894w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/a><figcaption id=\"caption-attachment-601\" class=\"wp-caption-text\">Results explorer window<\/figcaption><\/figure>\n<p><span style=\"font-family: CG Omega,CG Omega; font-size: large;\">P<\/span><span style=\"font-family: CG Omega,CG Omega; font-size: medium;\">ROCEDURE <\/span><\/p>\n<p>Firstly, filter down to the calculations of interest by ticking the boxes alongside the relevant criteria.<\/p>\n<p>Select the tiles of interest from the Tiles selector at the top of the window. The options are:<\/p>\n<p><span lang=\"ZH-TW\" style=\"font-family: Wingdings,Wingdings; font-size: xx-small;\">\uf06f <\/span><span style=\"font-size: medium;\">All visible tiles (default) <\/span><\/p>\n<p><span lang=\"ZH-TW\" style=\"font-family: Wingdings,Wingdings; font-size: xx-small;\">\uf06f <\/span><span style=\"font-size: medium;\">All loaded tiles <\/span><\/p>\n<p><span lang=\"ZH-TW\" style=\"font-family: Wingdings,Wingdings; font-size: xx-small;\">\uf06f <\/span><span style=\"font-size: medium;\">All populated tiles in model <\/span><\/p>\n<p><span lang=\"ZH-TW\" style=\"font-family: Wingdings,Wingdings; font-size: xx-small;\">\uf06f <\/span><span style=\"font-size: medium;\">All populated tiles in scenario <\/span><\/p>\n<p><span lang=\"ZH-TW\" style=\"font-family: Wingdings,Wingdings; font-size: xx-small;\">\uf06f <\/span><span style=\"font-size: medium;\">Named areas <\/span><\/p>\n<p>You can also select tiles in the graphical window using the mouse.<\/p>\n<p><span style=\"font-size: medium;\">You may also select <\/span><b><span style=\"font-family: CG Omega,CG Omega; font-size: medium;\">results <\/span><\/b><span style=\"font-size: medium;\">according to their validity \u2013 Valid, Invalid or All Results: see below for an explanation of \u2018validity\u2019. <\/span><\/p>\n<p>The lower part of the window shows the available results. Highlight the Result Sets that you wish to work on. You can select several lines at once. They will be loaded into NoiseMap.<\/p>\n<p>Note that when loading Noise Contours, you have to select each combination that you want to work on, but when loading Receiver Calculations, you only need to select the scenario and calculation method \u2013 all the combinations are loaded simultaneously. You select the combination of interest in a later step.<\/p>\n<p><span style=\"font-size: medium;\">For more information on using the Results Explorer, click on the <\/span><b><span style=\"font-family: CG Omega,CG Omega; font-size: medium;\">? <\/span><\/b><span style=\"font-size: medium;\">button to open context-sensitive help, or consult the main User Manual. <\/span><\/p>\n<p>Once you have loaded the result set, you can choose simply to display that result, or you can start to process it. For help on simply displaying a result, use the context-sensitive help or consult the User Manual.<\/p>\n<p><strong>PROCESSING A RESULT<\/strong><\/p>\n<p><span style=\"font-size: medium;\">This section details how to process a result set once you have downloaded it. First, select <\/span><b><span style=\"font-family: Courier New,Courier New; font-size: medium;\">Receiver Result Display Parameters <\/span><\/b><span style=\"font-size: medium;\">from the <\/span><b><span style=\"font-family: Courier New,Courier New; font-size: medium;\">Calculate <\/span><\/b><span style=\"font-size: medium;\">menu and the following dialog opens: <\/span><\/p>\n<p><a href=\"http:\/\/www.noisemap.ltd.uk\/wpress\/wp-content\/uploads\/2016\/11\/selection-of-results-display-parameters.bmp\"><img decoding=\"async\" loading=\"lazy\" class=\"alignnone size-medium wp-image-600\" src=\"http:\/\/www.noisemap.ltd.uk\/wpress\/wp-content\/uploads\/2016\/11\/selection-of-results-display-parameters-300x154.bmp\" alt=\"selection-of-results-display-parameters\" width=\"300\" height=\"154\" srcset=\"http:\/\/www.noisemap.ltd.uk\/wpress\/wp-content\/uploads\/2016\/11\/selection-of-results-display-parameters-300x154.bmp 300w, http:\/\/www.noisemap.ltd.uk\/wpress\/wp-content\/uploads\/2016\/11\/selection-of-results-display-parameters.bmp 463w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/a><\/p>\n<p>For Noise Contours, the contour Display Parameters dialogue opens:<\/p>\n<p><a href=\"http:\/\/www.noisemap.ltd.uk\/wpress\/wp-content\/uploads\/2016\/11\/selection-of-contour-display-parameters.bmp\"><img decoding=\"async\" loading=\"lazy\" class=\"alignnone size-medium wp-image-599\" src=\"http:\/\/www.noisemap.ltd.uk\/wpress\/wp-content\/uploads\/2016\/11\/selection-of-contour-display-parameters-300x193.bmp\" alt=\"selection-of-contour-display-parameters\" width=\"300\" height=\"193\" srcset=\"http:\/\/www.noisemap.ltd.uk\/wpress\/wp-content\/uploads\/2016\/11\/selection-of-contour-display-parameters-300x193.bmp 300w, http:\/\/www.noisemap.ltd.uk\/wpress\/wp-content\/uploads\/2016\/11\/selection-of-contour-display-parameters.bmp 457w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/a><\/p>\n<p><span style=\"font-size: medium;\">In either case, click on the button <\/span><b><span style=\"font-family: CG Omega,CG Omega; font-size: medium;\">Expr\u2026<\/span><\/b><span style=\"font-size: medium;\">to open the Expression Builder. <\/span><\/p>\n<p>You can now create a processing expression to create many different types of result.<\/p>\n<h1><span style=\"font-family: CG Omega,CG Omega; font-size: xx-large;\">CREATING A RESULTS EXPRESSION <\/span><\/h1>\n<p>Once\u00a0you have downloaded some results as described in the previous chapter\u00a0you can\u00a0process them. This chapter describes how to create a results expression to do that processing.<\/p>\n<p><strong><span style=\"font-family: CG Omega,CG Omega; font-size: large;\">A<\/span><span style=\"font-family: CG Omega,CG Omega; font-size: medium;\">DD AN <\/span><span style=\"font-family: CG Omega,CG Omega; font-size: large;\">O<\/span><\/strong><span style=\"font-family: CG Omega,CG Omega; font-size: medium;\"><strong>FFSET<\/strong> <\/span><\/p>\n<p><a href=\"http:\/\/www.noisemap.ltd.uk\/wpress\/wp-content\/uploads\/2016\/11\/result-expression-builder.bmp\"><img decoding=\"async\" loading=\"lazy\" class=\"alignnone size-medium wp-image-598\" src=\"http:\/\/www.noisemap.ltd.uk\/wpress\/wp-content\/uploads\/2016\/11\/result-expression-builder-300x185.bmp\" alt=\"result-expression-builder\" width=\"300\" height=\"185\" srcset=\"http:\/\/www.noisemap.ltd.uk\/wpress\/wp-content\/uploads\/2016\/11\/result-expression-builder-300x185.bmp 300w, http:\/\/www.noisemap.ltd.uk\/wpress\/wp-content\/uploads\/2016\/11\/result-expression-builder.bmp 576w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/a><\/p>\n<p><span style=\"font-size: medium;\">The simplest processing is to add a fixed offset to a result. First, you load the required result from the database. Suppose this is the \u2018All Roads\u2019 scenario from the ManualExample Database and you wish to add a 5 dB offset to all the results. Click the <\/span><b><span style=\"font-family: Courier New,Courier New; font-size: medium;\">Expr\u2026<\/span><\/b><span style=\"font-size: medium;\">button on the <\/span><b><span style=\"font-family: CG Omega,CG Omega; font-size: medium;\">Contour Display Parameters <\/span><\/b><span style=\"font-size: medium;\">dialogue and the <\/span><b><span style=\"font-family: CG Omega,CG Omega; font-size: medium;\">Expression Builder <\/span><\/b><span style=\"font-size: medium;\">opens. Select the <\/span><b><span style=\"font-family: CG Omega,CG Omega; font-size: medium;\">All Roads <\/span><\/b><span style=\"font-size: medium;\">result set and note that it is given the name <\/span><b><span style=\"font-family: Courier New,Courier New; font-size: medium;\">R1 <\/span><\/b><span style=\"font-size: medium;\">(you can edit this name if desired). <\/span><\/p>\n<p><span style=\"font-size: medium;\">Now, in the expression window below, enter <\/span><b><span style=\"font-family: Courier New,Courier New; font-size: medium;\">R1+5<\/span><\/b><span style=\"font-size: medium;\">. This means add 5 dB to all values in result set <\/span><b><span style=\"font-family: Courier New,Courier New; font-size: medium;\">R1<\/span><\/b><span style=\"font-size: medium;\">, (All Roads). You can give a (user-friendly) name to this expression: if not, the expression itself is shown. Here, the chosen name is <\/span><b><span style=\"font-family: CG Omega,CG Omega; font-size: medium;\">All + 5 dB offset<\/span><\/b><span style=\"font-size: medium;\">. This will be shown in the information panel on the main screen. <\/span><\/p>\n<p><span style=\"font-size: medium;\">Click <\/span><b><span style=\"font-family: Courier New,Courier New; font-size: medium;\">OK<\/span><\/b><span style=\"font-size: medium;\">. You will now see that the contour display parameters show the <\/span><b><span style=\"font-family: Courier New,Courier New; font-size: medium;\">Result Set <\/span><span style=\"font-family: CG Omega,CG Omega; font-size: medium;\">as <\/span><span style=\"font-family: Courier New,Courier New; font-size: medium;\">Result Expression <\/span><\/b><span style=\"font-size: medium;\">and the selected expression is <\/span><b><span style=\"font-family: CG Omega,CG Omega; font-size: medium;\">All + 5 dB offset<\/span><\/b><span style=\"font-size: medium;\">. This will be plotted as a contour. <\/span><\/p>\n<p><strong><span style=\"font-family: CG Omega,CG Omega; font-size: large;\">N<\/span><span style=\"font-family: CG Omega,CG Omega; font-size: medium;\">OISE <\/span><span style=\"font-family: CG Omega,CG Omega; font-size: large;\">C<\/span><\/strong><span style=\"font-family: CG Omega,CG Omega; font-size: medium;\"><strong>HANGES<\/strong> <\/span><\/p>\n<p><a href=\"http:\/\/www.noisemap.ltd.uk\/wpress\/wp-content\/uploads\/2016\/11\/multiple-result-expressions.bmp\"><img decoding=\"async\" loading=\"lazy\" class=\"alignnone size-medium wp-image-597\" src=\"http:\/\/www.noisemap.ltd.uk\/wpress\/wp-content\/uploads\/2016\/11\/multiple-result-expressions-300x185.bmp\" alt=\"multiple-result-expressions\" width=\"300\" height=\"185\" srcset=\"http:\/\/www.noisemap.ltd.uk\/wpress\/wp-content\/uploads\/2016\/11\/multiple-result-expressions-300x185.bmp 300w, http:\/\/www.noisemap.ltd.uk\/wpress\/wp-content\/uploads\/2016\/11\/multiple-result-expressions.bmp 576w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/a><\/p>\n<p><span style=\"font-size: medium;\">Another common requirement is to subtract two contours to find the change of noise level between two scenarios. Firstly, using the ManualExample model, go to <\/span><b><span style=\"font-family: Courier New,Courier New; font-size: medium;\">Load Database Contours <\/span><\/b><span style=\"font-size: medium;\">and load the two scenarios \u2013 say <\/span><b><span style=\"font-family: CG Omega,CG Omega; font-size: medium;\">All Roads <\/span><\/b><span style=\"font-size: medium;\">in the Baseline scenario and <\/span><b><span style=\"font-family: CG Omega,CG Omega; font-size: medium;\">All Roads <\/span><\/b><span style=\"font-size: medium;\">in the With New Road scenario. <\/span><\/p>\n<p><span style=\"font-size: medium;\">In the <\/span><b><span style=\"font-family: Courier New,Courier New; font-size: medium;\">Contour Display Parameters <\/span><\/b><span style=\"font-size: medium;\">dialogue, click <\/span><b><span style=\"font-family: Courier New,Courier New; font-size: medium;\">Expr\u2026<\/span><\/b><span style=\"font-size: medium;\">and in the <\/span><b><span style=\"font-family: Courier New,Courier New; font-size: medium;\">Expression Builder<\/span><\/b><span style=\"font-size: medium;\">, select the two sets of results, which NoiseMap will call <\/span><b><span style=\"font-family: Courier New,Courier New; font-size: medium;\">R1 <\/span><\/b><span style=\"font-size: medium;\">and <\/span><b><span style=\"font-family: Courier New,Courier New; font-size: medium;\">R2 <\/span><\/b><span style=\"font-size: medium;\">respectively. <\/span><\/p>\n<p><span style=\"font-size: medium;\">Then under <\/span><b><span style=\"font-family: Courier New,Courier New; font-size: medium;\">Expression <\/span><\/b><span style=\"font-size: medium;\">type the expression <\/span><b><span style=\"font-family: Courier New,Courier New; font-size: medium;\">R2 \u2013 R1<\/span><\/b><span style=\"font-size: medium;\">, and call this <\/span><b><span style=\"font-family: Courier New,Courier New; font-size: medium;\">Change from Existing<\/span><\/b><span style=\"font-size: medium;\">, see the dialogue below <\/span><\/p>\n<p><a href=\"http:\/\/www.noisemap.ltd.uk\/wpress\/wp-content\/uploads\/2016\/11\/multiple-result-expressions.bmp\"><img decoding=\"async\" loading=\"lazy\" class=\"alignnone size-medium wp-image-597\" src=\"http:\/\/www.noisemap.ltd.uk\/wpress\/wp-content\/uploads\/2016\/11\/multiple-result-expressions-300x185.bmp\" alt=\"multiple-result-expressions\" width=\"300\" height=\"185\" srcset=\"http:\/\/www.noisemap.ltd.uk\/wpress\/wp-content\/uploads\/2016\/11\/multiple-result-expressions-300x185.bmp 300w, http:\/\/www.noisemap.ltd.uk\/wpress\/wp-content\/uploads\/2016\/11\/multiple-result-expressions.bmp 576w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"font-size: medium;\">Click <\/span><b><span style=\"font-family: Courier New,Courier New; font-size: medium;\">OK <\/span><\/b><span style=\"font-size: medium;\">to return to the Contour Display Parameters window and click apply to see the resulting contour. <\/span><\/p>\n<p><span style=\"font-family: CG Omega,CG Omega; font-size: large;\">C<\/span><span style=\"font-family: CG Omega,CG Omega; font-size: medium;\">OMBINING <\/span><span style=\"font-family: CG Omega,CG Omega; font-size: large;\">N<\/span><span style=\"font-family: CG Omega,CG Omega; font-size: medium;\">OISE <\/span><span style=\"font-family: CG Omega,CG Omega; font-size: large;\">C<\/span><span style=\"font-family: CG Omega,CG Omega; font-size: medium;\">ONTOURS <\/span><\/p>\n<p>Note that in the above examples, the + and \u2013 operators add and subtract the noise levels arithmetically.<\/p>\n<p><span style=\"font-size: medium;\">Another common requirement is to add two contours together to get the combined noise level. Here the requirement is a decibel addition, which is performed by the <\/span><b><span style=\"font-family: Courier New,Courier New; font-size: medium;\">LOGSUM <\/span><\/b><span style=\"font-size: medium;\">function. The Expression to do a decibel addition of two noise levels is <\/span><\/p>\n<p>LOGSUM(R1,R2)<\/p>\n<p>Note that you can sum as many results as you require and this can include a numerical value, e.g.<\/p>\n<p>LOGSUM(R1,R2,R3,30.0)<\/p>\n<p><strong><span style=\"font-family: CG Omega,CG Omega; font-size: large;\">A<\/span><span style=\"font-family: CG Omega,CG Omega; font-size: medium;\">DD A <\/span><span style=\"font-family: CG Omega,CG Omega; font-size: large;\">N<\/span><\/strong><span style=\"font-family: CG Omega,CG Omega; font-size: medium;\"><strong>OISE FLOOR<\/strong> <\/span><\/p>\n<p>At larger distances, there can be a loss of precision in the calculated results. This can result in \u2018jitter\u2019 in the change of noise level which appears as random patches of different colour. You can avoid this by setting a noise floor. For example, you may decide that results below 30 dB are beyond the precision of the model. If you set 30 dB as the noise floor, then any results below 30 dB are set at 30 dB. Thus if two results are at 25 and 28 dB, both are set to 30 dB and the difference will be plotted as zero.<\/p>\n<p>The expression to set a noise floor of 30 dB to result R1 is<\/p>\n<p>MAX(R1,30)<\/p>\n<p>This means \u2018use the greater value of R1 or 30\u2019.<\/p>\n<p><span style=\"font-family: CG Omega,CG Omega; font-size: large;\">NULL <\/span><span style=\"font-family: CG Omega,CG Omega; font-size: medium;\">RESULTS <\/span><\/p>\n<p>Results sets can often contain \u2018null\u2019 results. This means a situation where no noise level has been calculated. It is represented in the database by a value of -99, as 0 dB would be a valid (and potentially audible) noise level. Null values can occur in many ways, such as<\/p>\n<p><span lang=\"ZH-TW\" style=\"font-family: Wingdings,Wingdings; font-size: xx-small;\">\uf06f <\/span><span style=\"font-size: medium;\">A tile was not calculated; <\/span><\/p>\n<p><span lang=\"ZH-TW\" style=\"font-family: Wingdings,Wingdings; font-size: xx-small;\">\uf06f <\/span><span style=\"font-size: medium;\">A receiver point was outside the angle of view or beyond the cut-off distance; <\/span><\/p>\n<p><span lang=\"ZH-TW\" style=\"font-family: Wingdings,Wingdings; font-size: xx-small;\">\uf06f <\/span><span style=\"font-size: medium;\">The receiver point was inside a building. <\/span><\/p>\n<p>NoiseMap lets the user process null results in an orderly manner, as follows.<\/p>\n<p>All arithmetic operations on any null value return a null result.<\/p>\n<p><span style=\"font-size: medium;\">Thus <\/span><b><span style=\"font-family: Courier New,Courier New; font-size: medium;\">60 dB + NULL = NULL <\/span><\/b><\/p>\n<p>However, the log functions operate slightly differently, eg<\/p>\n<p>LOGSUM(R1,NULL) = R1<\/p>\n<p>This is because NULL is treated as \u2018no noise contribution\u2019 (effectively as zero noise), so the total noise is the total of the other non-null values.<\/p>\n<p><span style=\"font-size: medium;\">You may want to ensure that there are no <\/span><b><span style=\"font-family: Courier New,Courier New; font-size: medium;\">NULL <\/span><\/b><span style=\"font-size: medium;\">values, to avoid getting <\/span><b><span style=\"font-family: Courier New,Courier New; font-size: medium;\">NULL <\/span><\/b><span style=\"font-size: medium;\">as a result. You can do this with the <\/span><b><span style=\"font-family: Courier New,Courier New; font-size: medium;\">COALESCE <\/span><\/b><span style=\"font-size: medium;\">function. For example <\/span><\/p>\n<p><span style=\"font-family: Courier New,Courier New; font-size: medium;\"><b>COALESCE(R1,R2,35) <\/b><\/span><span style=\"font-size: medium;\">would use the value of <\/span><b><span style=\"font-family: Courier New,Courier New; font-size: medium;\">R1 <\/span><\/b><span style=\"font-size: medium;\">unless it is <\/span><b><span style=\"font-family: Courier New,Courier New; font-size: medium;\">NULL<\/span><\/b><span style=\"font-size: medium;\">, in which case it would use the value of <\/span><b><span style=\"font-family: Courier New,Courier New; font-size: medium;\">R2<\/span><\/b><span style=\"font-size: medium;\">. But if that is also <\/span><b><span style=\"font-family: Courier New,Courier New; font-size: medium;\">NULL<\/span><\/b><span style=\"font-size: medium;\">, it would use the value <\/span><b><span style=\"font-family: Courier New,Courier New; font-size: medium;\">35<\/span><\/b><span style=\"font-size: medium;\">. Essentially, this is saying \u2018use the value of 35 if there is no other calculation for this point\u2019. <\/span><\/p>\n<p><span style=\"font-family: CG Omega,CG Omega; font-size: large;\">O<\/span><span style=\"font-family: CG Omega,CG Omega; font-size: medium;\">THER OPERATIONS <\/span><\/p>\n<table dir=\"LTR\" border=\"1\" width=\"534\" cellspacing=\"0\" cellpadding=\"7\">\n<tbody>\n<tr>\n<td colspan=\"2\" valign=\"TOP\" height=\"8\"><span style=\"font-size: medium;\">Other common Arithmetic Operators and Functions are available in the Results Processor: see the table below. Conditionals such as <\/span><b><span style=\"font-family: Courier New,Courier New; font-size: medium;\">Greater than<\/span><span style=\"font-family: CG Omega,CG Omega; font-size: medium;\">, <\/span><span style=\"font-family: Courier New,Courier New; font-size: medium;\">Equal to <\/span><\/b><span style=\"font-size: medium;\">and <\/span><b><span style=\"font-family: Courier New,Courier New; font-size: medium;\">IF <\/span><\/b><span style=\"font-size: medium;\">provide sophisticated processing possibilities, especially if combined with imported receiver point levels that could be used as noise criteria. <\/span><b><span style=\"font-family: CG Omega,CG Omega; font-size: small;\">Arithmetic Operators <\/span><\/b><\/td>\n<\/tr>\n<tr>\n<td valign=\"TOP\" width=\"50%\" height=\"8\"><span style=\"font-size: small;\">+ <\/span><\/td>\n<td valign=\"TOP\" width=\"50%\" height=\"8\"><span style=\"font-size: small;\">Arithmetic unary and binary add <\/span><\/td>\n<\/tr>\n<tr>\n<td valign=\"TOP\" width=\"50%\" height=\"8\"><span style=\"font-size: small;\">&#8211; <\/span><\/td>\n<td valign=\"TOP\" width=\"50%\" height=\"8\"><span style=\"font-size: small;\">Arithmetic unary and binary subtract <\/span><\/td>\n<\/tr>\n<tr>\n<td valign=\"TOP\" width=\"50%\" height=\"8\"><span style=\"font-size: small;\">* <\/span><\/td>\n<td valign=\"TOP\" width=\"50%\" height=\"8\"><span style=\"font-size: small;\">Multiply <\/span><\/td>\n<\/tr>\n<tr>\n<td valign=\"TOP\" width=\"50%\" height=\"8\"><span style=\"font-size: small;\">\/ <\/span><\/td>\n<td valign=\"TOP\" width=\"50%\" height=\"8\"><span style=\"font-size: small;\">Divide <\/span><\/td>\n<\/tr>\n<tr>\n<td valign=\"TOP\" width=\"50%\" height=\"8\"><span style=\"font-size: small;\">^ <\/span><\/td>\n<td valign=\"TOP\" width=\"50%\" height=\"8\"><span style=\"font-size: small;\">Power (eg. R1^2) \u2013 can also use ** <\/span><\/td>\n<\/tr>\n<tr>\n<td valign=\"TOP\" width=\"50%\" height=\"10\"><span style=\"font-family: Calibri,Calibri; font-size: medium;\">?? <\/span><\/td>\n<td valign=\"TOP\" width=\"50%\" height=\"10\"><span style=\"font-family: Calibri,Calibri; font-size: medium;\">Coalesce binary operator (see COALESCE function) <\/span><\/td>\n<\/tr>\n<tr>\n<td colspan=\"2\" valign=\"TOP\" height=\"8\"><b><\/b><span style=\"font-family: CG Omega,CG Omega; font-size: small;\"><b>Boolean Operators \u2013 0 is false, non-0 is true, eg. NOT(42) = 0, NOT(0)=1 <\/b><\/span><\/td>\n<\/tr>\n<tr>\n<td valign=\"TOP\" width=\"50%\" height=\"8\"><span style=\"font-size: small;\">NOT <\/span><\/td>\n<td valign=\"TOP\" width=\"50%\" height=\"8\"><span style=\"font-size: small;\">Boolean invert &#8211; can also use ! operator <\/span><\/td>\n<\/tr>\n<tr>\n<td valign=\"TOP\" width=\"50%\" height=\"8\"><span style=\"font-size: small;\">AND <\/span><\/td>\n<td valign=\"TOP\" width=\"50%\" height=\"8\"><span style=\"font-size: small;\">Boolean AND <\/span><\/td>\n<\/tr>\n<tr>\n<td valign=\"TOP\" width=\"50%\" height=\"8\"><span style=\"font-size: small;\">OR <\/span><\/td>\n<td valign=\"TOP\" width=\"50%\" height=\"8\"><span style=\"font-size: small;\">Boolean OR <\/span><\/td>\n<\/tr>\n<tr>\n<td colspan=\"2\" valign=\"TOP\" height=\"8\"><b><\/b><span style=\"font-family: CG Omega,CG Omega; font-size: small;\"><b>Conditionals \u2013 return 0 for false, 1 for true <\/b><\/span><\/td>\n<\/tr>\n<tr>\n<td valign=\"TOP\" width=\"50%\" height=\"8\"><span style=\"font-size: small;\">= <\/span><\/td>\n<td valign=\"TOP\" width=\"50%\" height=\"8\"><span style=\"font-size: small;\">Equality \u2013 can also use == <\/span><\/td>\n<\/tr>\n<tr>\n<td valign=\"TOP\" width=\"50%\" height=\"8\"><span style=\"font-size: small;\">&lt;&gt; <\/span><\/td>\n<td valign=\"TOP\" width=\"50%\" height=\"8\"><span style=\"font-size: small;\">Inequality \u2013 can also use != <\/span><\/td>\n<\/tr>\n<tr>\n<td valign=\"TOP\" width=\"50%\" height=\"8\"><span style=\"font-size: small;\">&gt; <\/span><\/td>\n<td valign=\"TOP\" width=\"50%\" height=\"8\"><span style=\"font-size: small;\">Greater than <\/span><\/td>\n<\/tr>\n<tr>\n<td valign=\"TOP\" width=\"50%\" height=\"8\"><span style=\"font-size: small;\">&lt; <\/span><\/td>\n<td valign=\"TOP\" width=\"50%\" height=\"8\"><span style=\"font-size: small;\">Less than <\/span><\/td>\n<\/tr>\n<tr>\n<td valign=\"TOP\" width=\"50%\" height=\"8\"><span style=\"font-size: small;\">&gt;= <\/span><\/td>\n<td valign=\"TOP\" width=\"50%\" height=\"8\"><span style=\"font-size: small;\">Greater than or equal <\/span><\/td>\n<\/tr>\n<tr>\n<td valign=\"TOP\" width=\"50%\" height=\"8\"><span style=\"font-size: small;\">&lt;= <\/span><\/td>\n<td valign=\"TOP\" width=\"50%\" height=\"8\"><span style=\"font-size: small;\">Less than or equal <\/span><\/td>\n<\/tr>\n<tr>\n<td colspan=\"2\" valign=\"TOP\" height=\"8\"><b><\/b><span style=\"font-family: CG Omega,CG Omega; font-size: small;\"><b>Functions <\/b><\/span><\/td>\n<\/tr>\n<tr>\n<td valign=\"TOP\" width=\"50%\" height=\"8\"><span style=\"font-size: small;\">MAX <\/span><\/td>\n<td valign=\"TOP\" width=\"50%\" height=\"8\"><span style=\"font-size: small;\">Returns highest value of parameters &#8211; two or more parameters <\/span><\/td>\n<\/tr>\n<tr>\n<td valign=\"TOP\" width=\"50%\" height=\"8\"><span style=\"font-size: small;\">MIN <\/span><\/td>\n<td valign=\"TOP\" width=\"50%\" height=\"8\"><span style=\"font-size: small;\">Returns lowest value of parameters &#8211; two or more parameters <\/span><\/td>\n<\/tr>\n<tr>\n<td valign=\"TOP\" width=\"50%\" height=\"8\"><span style=\"font-size: small;\">AVE <\/span><\/td>\n<td valign=\"TOP\" width=\"50%\" height=\"8\"><span style=\"font-size: small;\">Returns arithmetic mean of parameters &#8211; two or more parameters <\/span><\/td>\n<\/tr>\n<tr>\n<td valign=\"TOP\" width=\"50%\" height=\"23\"><span style=\"font-size: small;\">IF <\/span><\/td>\n<td valign=\"TOP\" width=\"50%\" height=\"23\"><span style=\"font-size: small;\">Takes three parameters \u2013 the first is evaluated as a boolean used to select the second parameter when true, or the third when false, eg. IF(R1&gt;42, 1, -1) returns 1 whenever R1 is greater than 42, or -1 when less than or equal to 42. <\/span><\/td>\n<\/tr>\n<tr>\n<td valign=\"TOP\" width=\"50%\" height=\"8\"><span style=\"font-size: small;\">LOG <\/span><\/td>\n<td valign=\"TOP\" width=\"50%\" height=\"8\"><span style=\"font-size: small;\">Returns the Log10 of the single parameter <\/span><\/td>\n<\/tr>\n<tr>\n<td valign=\"TOP\" width=\"50%\" height=\"8\"><span style=\"font-size: small;\">LOGSUM <\/span><\/td>\n<td valign=\"TOP\" width=\"50%\" height=\"8\"><span style=\"font-size: small;\">Returns logarithmic sum of the parameters \u2013 two or more parameters <\/span><\/td>\n<\/tr>\n<tr>\n<td valign=\"TOP\" width=\"50%\" height=\"8\"><span style=\"font-size: small;\">LOGDIFF <\/span><\/td>\n<td valign=\"TOP\" width=\"50%\" height=\"8\"><span style=\"font-size: small;\">Returns the logarithmic difference of two parameters, P1-P2 <\/span><\/td>\n<\/tr>\n<tr>\n<td valign=\"TOP\" width=\"50%\" height=\"8\"><span style=\"font-size: small;\">LOGAVE <\/span><\/td>\n<td valign=\"TOP\" width=\"50%\" height=\"8\"><span style=\"font-size: small;\">Returns logarithmic mean of the parameters \u2013 two or more parameters <\/span><\/td>\n<\/tr>\n<tr>\n<td valign=\"TOP\" width=\"50%\" height=\"8\"><span style=\"font-size: small;\">COALESCE <\/span><\/td>\n<td valign=\"TOP\" width=\"50%\" height=\"8\"><span style=\"font-size: small;\">Returns the first non-null parameter reading from left \u2013 two or more parameters <\/span><\/td>\n<\/tr>\n<tr>\n<td valign=\"TOP\" width=\"50%\" height=\"8\"><span style=\"font-size: small;\">ISNULL <\/span><\/td>\n<td valign=\"TOP\" width=\"50%\" height=\"8\"><span style=\"font-size: small;\">Returns True (1) if NULL. Returns False (0) if valid value &#8211; one parameter <\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>&nbsp;<\/p>\n<p><span style=\"font-size: large;\">E<\/span><span style=\"font-size: medium;\">NTERING EXPRESSIONS VIA THE <\/span><span style=\"font-size: large;\">S<\/span><span style=\"font-size: medium;\">CRIPT <\/span><span style=\"font-size: large;\">E<\/span><span style=\"font-size: medium;\">DITOR <\/span><\/p>\n<p>Complex expressions might be prone to typing errors, so it can save time if they are stored for re-use. You can do this by using a Script Command, which you can type in Script Command Pane (at the bottom of the Results\/Output Log window), or you can <span style=\"font-family: CG Omega,CG Omega; font-size: medium;\">create the script in an external editor and run it from the <\/span><b><span style=\"font-family: Courier New,Courier New; font-size: medium;\">File&gt;Run Script <\/span><\/b><span style=\"font-family: CG Omega,CG Omega; font-size: medium;\">menu item. <\/span><\/p>\n<p>The script command for loading a receiver results expression is<\/p>\n<p><span style=\"font-family: Courier New,Courier New; font-size: medium;\">display results expression=&#8221;<\/span><i><span style=\"font-family: Courier New,Courier New; font-size: medium;\">anexpression&#8221; <\/span><\/i><\/p>\n<p>This adds the new expression to the expression builder window and sets the expression as the headline value. Note that you must already have loaded the results from the database, using either the appropriate dialog or the script interface, so that the variables (R1, R2, etc) are available.<\/p>\n<p>For contours, the script command is:<\/p>\n<p><span style=\"font-family: Courier New,Courier New; font-size: medium;\">display contour expression=<\/span><i><span style=\"font-family: Courier New,Courier New; font-size: medium;\">&#8220;anexpression&#8221; <\/span><\/i><\/p>\n<p>For further information on using the Script interface, see the context sensitive help or the Script Interface manual, which has more information on results processing.<\/p>\n<p>EXAMPLES OF SIMPLE EXPRESSIONS<\/p>\n<p>Examples of simple expressions are:<\/p>\n<p><span style=\"font-size: medium;\"><b>R1+10 <\/b><\/span><span style=\"font-family: CG Omega,CG Omega; font-size: medium;\">&#8212; increase value of result R1 by 10 dB <\/span><\/p>\n<p><span style=\"font-size: medium;\"><b>R2 \u2013 R1 <\/b><\/span><span style=\"font-family: CG Omega,CG Omega; font-size: medium;\">\u2013 get change of noise level from R1 to R2 <\/span><\/p>\n<p><span style=\"font-size: medium;\"><b>LOGSUM(R3,R4) <\/b><\/span><span style=\"font-family: CG Omega,CG Omega; font-size: medium;\">get the cumulative level of R3 and R4 <\/span><\/p>\n<p><span style=\"font-size: medium;\"><b>MAX(R3, 35.0) <\/b><\/span><span style=\"font-family: CG Omega,CG Omega; font-size: medium;\">\u2013 put a noise floor of 35 dB on result R3 <\/span><\/p>\n<p><span style=\"font-size: medium;\"><b>MIN(R4, 80) <\/b><\/span><span style=\"font-family: CG Omega,CG Omega; font-size: medium;\">\u2013 put a ceiling of 80 dB on result R4 <\/span><\/p>\n<p>You can nest expressions, for example<\/p>\n<p><span style=\"font-size: medium;\"><b>MAX(MIN(R4,80),35) <\/b><\/span><span style=\"font-family: CG Omega,CG Omega; font-size: medium;\">constrain the values of R4 to between 35 and 80 dB. <\/span><\/p>\n<p>You can also produce conditional results e.g.<\/p>\n<p><span style=\"font-size: medium;\"><b>If(R3&lt;67.5, 0,1) <\/b><\/span><span style=\"font-family: CG Omega,CG Omega; font-size: medium;\">produces the result 0 if R3 is less than 67.5 and the result 1 if it is greater than or equal to 67.5 <\/span><\/p>\n<p>A test for noise insulation might be given by:<\/p>\n<p>If((R3&gt;=67.5) and (R3&gt;=(R1+1)), 1,0)<\/p>\n<p>It can be seen that there is great flexibility in this.<\/p>\n<p>RESULT EXPRESSION BUILDER<\/p>\n<p><span style=\"font-family: CG Omega,CG Omega; font-size: medium;\">To create an expression, click the <\/span><b><span style=\"font-size: medium;\">Expr <\/span><\/b><span style=\"font-family: CG Omega,CG Omega; font-size: medium;\">button to the right of the Result\/Expression line and the <\/span><b><span style=\"font-size: medium;\">Result Expression Builder <\/span><\/b><span style=\"font-family: CG Omega,CG Omega; font-size: medium;\">will open. <\/span><\/p>\n<p>Choose the results sets<\/p>\n<p><span style=\"font-family: CG Omega,CG Omega; font-size: medium;\">First click on <\/span><i><span style=\"font-family: CG Omega,CG Omega; font-size: medium;\">Select a result set<\/span><\/i><span style=\"font-family: CG Omega,CG Omega; font-size: medium;\">. This will show the name of the Results set you have downloaded. Select this and it will be shown as Result Set <\/span><b><span style=\"font-size: medium;\">R1<\/span><\/b><span style=\"font-family: CG Omega,CG Omega; font-size: medium;\">. To the right, under the column Result will be the Noise index. This is a drop-down list. Select the index that you require, eg Lday. The start and finish hour in this case are defined by the procedure and cannot be changed, but in other indexes it might be possible to change these. The Combination is also a drop-down and will list all the combinations in the results set. Select one, eg All Roads. <\/span><\/p>\n<p><span style=\"font-family: CG Omega,CG Omega; font-size: medium;\">Now go back to Result set again, and select the same results set, but this time, under Result, select L<\/span><span style=\"font-family: CG Omega,CG Omega; font-size: small;\">night<\/span><span style=\"font-family: CG Omega,CG Omega; font-size: medium;\">. Select All Roads for the combination. This will be shown as Result Set <\/span><b><span style=\"font-size: medium;\">R2<\/span><\/b><span style=\"font-family: CG Omega,CG Omega; font-size: medium;\">. The Results set names R1 and R2 are used for referencing the results when you create the expression. <\/span><\/p>\n<p>Result expression builder \u2013 day-night difference<\/p>\n<p>Create the expression<\/p>\n<p><span style=\"font-family: CG Omega,CG Omega; font-size: medium;\">Having chosen the Results sets, you create the expression. Under <\/span><b><span style=\"font-size: medium;\">Expression<\/span><\/b><span style=\"font-family: CG Omega,CG Omega; font-size: medium;\">, click <\/span><i><span style=\"font-family: CG Omega,CG Omega; font-size: medium;\">Enter a new expression <\/span><\/i><span style=\"font-family: CG Omega,CG Omega; font-size: medium;\">and type <\/span><b><span style=\"font-size: medium;\">R1-R2 <\/span><\/b><span style=\"font-family: CG Omega,CG Omega; font-size: medium;\">(not case-sensitive), i.e. the difference between daytime and night-time levels. You can give this a name, eg <\/span><b><span style=\"font-size: medium;\">Day-Night diff<\/span><\/b><span style=\"font-family: CG Omega,CG Omega; font-size: medium;\">. <\/span><\/p>\n<p><span style=\"font-family: CG Omega,CG Omega; font-size: medium;\">Click <\/span><b><span style=\"font-size: medium;\">OK <\/span><\/b><span style=\"font-family: CG Omega,CG Omega; font-size: medium;\">to close the Expression Builder. Note that the Receiver Result Display Parameter window now shows that the result set is \u2018Result Expression\u2019 and the Result\/Expression window is showing the expression you entered, or its name if you gave one, in this case, <\/span><b><span style=\"font-size: medium;\">Day-Night Diff<\/span><\/b><span style=\"font-family: CG Omega,CG Omega; font-size: medium;\">. Click OK to close the window and you will now see that the receiver results show the difference between day and night levels at each receiver. <\/span><\/p>\n<p>Result expression selected as headline value<\/p>\n<p><span style=\"font-size: large;\">M<\/span><span style=\"font-size: medium;\">ULTIPLE RESULTS LOADING <\/span><\/p>\n<p>You may need to compare the results from two different results sets. For instance in the present example, between the Base Scenario and the \u2018With New Road\u2019 scenario.<\/p>\n<p><span style=\"font-size: medium;\">We already have \u2018Baseline\u2019 loaded, so we need to load the \u2018With New Road\u2019 scenario. Select <b>Calculate&gt;Load Receiver Results <\/b><\/span><span style=\"font-family: CG Omega,CG Omega; font-size: medium;\">from the menu and in the <\/span><b><span style=\"font-size: medium;\">Receiver Results Explorer <\/span><\/b><span style=\"font-family: CG Omega,CG Omega; font-size: medium;\">choose <\/span><i><span style=\"font-family: CG Omega,CG Omega; font-size: medium;\">With New Road <\/span><\/i><span style=\"font-family: CG Omega,CG Omega; font-size: medium;\">Scenario. Select <\/span><b><span style=\"font-size: medium;\">CRTN <\/span><\/b><span style=\"font-family: CG Omega,CG Omega; font-size: medium;\">and load the With New Road Results. <\/span><\/p>\n<p><span style=\"font-family: CG Omega,CG Omega; font-size: medium;\">The Receiver Results Display Parameters window opens. Click the <\/span><b><span style=\"font-size: medium;\">Expr <\/span><\/b><span style=\"font-family: CG Omega,CG Omega; font-size: medium;\">button. Now we need to add the new scenario to the results list. Click <\/span><i><span style=\"font-family: CG Omega,CG Omega; font-size: medium;\">Select a result set <\/span><\/i><span style=\"font-family: CG Omega,CG Omega; font-size: medium;\">and choose With New Road Scenario. Note that this is shown as Result set <\/span><b><span style=\"font-size: medium;\">R3<\/span><\/b><span style=\"font-family: CG Omega,CG Omega; font-size: medium;\">. Select the appropriate index, say Lday, and in the combination column, select \u2018All Roads\u2019 <\/span><\/p>\n<p><span style=\"font-family: CG Omega,CG Omega; font-size: medium;\">Now you can create a new expression <\/span><b><span style=\"font-size: medium;\">R3-R1 <\/span><\/b><span style=\"font-family: CG Omega,CG Omega; font-size: medium;\">and perhaps call this <\/span><b><span style=\"font-size: medium;\">DS change <\/span><\/b><span style=\"font-family: CG Omega,CG Omega; font-size: medium;\">(Do-something change). Click <\/span><b><span style=\"font-size: medium;\">OK <\/span><\/b><span style=\"font-family: CG Omega,CG Omega; font-size: medium;\">and you will see the new expression shown in the Receiver Results Display Parameters window. You can switch between the two expressions to display or export the result as necessary. <\/span><\/p>\n<p>More complex expressions can be entered as shown earlier.<\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>WHAT IT DOES You often need to process the results of your noise modelling in order to draw some conclusions about the noise impact of the project. NoiseMap quickly creates a large amount of noise information, so you may need some assistance in getting meaningful conclusions. This is where the Results Processor comes into play. &hellip; <a href=\"http:\/\/www.noisemap.ltd.uk\/wpress\/the-results-processor\/\" class=\"more-link\">Continue reading <span class=\"screen-reader-text\">The Results Processor<\/span> <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":[],"_links":{"self":[{"href":"http:\/\/www.noisemap.ltd.uk\/wpress\/wp-json\/wp\/v2\/pages\/592"}],"collection":[{"href":"http:\/\/www.noisemap.ltd.uk\/wpress\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"http:\/\/www.noisemap.ltd.uk\/wpress\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"http:\/\/www.noisemap.ltd.uk\/wpress\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.noisemap.ltd.uk\/wpress\/wp-json\/wp\/v2\/comments?post=592"}],"version-history":[{"count":8,"href":"http:\/\/www.noisemap.ltd.uk\/wpress\/wp-json\/wp\/v2\/pages\/592\/revisions"}],"predecessor-version":[{"id":635,"href":"http:\/\/www.noisemap.ltd.uk\/wpress\/wp-json\/wp\/v2\/pages\/592\/revisions\/635"}],"wp:attachment":[{"href":"http:\/\/www.noisemap.ltd.uk\/wpress\/wp-json\/wp\/v2\/media?parent=592"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}