FORUM23 Training Part 2:

Get more out of your noise

An ANOMS Advanced Training Session with Advanced Excel concepts

Build tools to help you analyze and apply effective limits related to noise and operations occurring at your airport through the use of ANOMS Query Gen, Excel, and ANOMS Auto Tag Rule Manager.

Lesson Time: 26 minutes.

Learn how to get a better understanding of noise and operations distributions related to various affecting factors. Applicable to assisting in creating, re-evaluating, and performing established Fly Quiet Program calculations

Helpful Tip

Various Excel formulas used in this video are included below for the ease of copy/paste:

Data Table Range: =OFFSET(Sheet1!$A$1,0,0,COUNTA(Sheet1!$A:$A),15)
1st Quartile: =var PathSelection = Table1[Combined] RETURN PERCENTILEX.INC( FILTER(Table1, Table1[Combined]=PathSelection ), Table1[Max Level], .25 )
3rd Quartile: =var PathSelection = Table1[Combined] RETURN PERCENTILEX.INC( FILTER(Table1, Table1[Combined]=PathSelection ), Table1[Max Level], .75 )
Ranking: =IF(Table1[Max Level]<=Table1[1st Quartile],”Good”,IF(Table1[3rd Quartile]<=Table1[Max Level],”Bad”,”Average”))

For better understanding of the concepts in this video, we recommend you watch the FOURM23 Training Part 1 video.