NASL Results Contents: - NASL_CompareAllEventsVsModeled.xlsx - NASL_CNEL.xlsm - NASL_M1_DailyCNEL.pdf - NASL_M2_DailyCNEL.pdf - NASL_M3_DailyCNEL.pdf - NASL_M4_DailyCNEL.pdf How to read NASL_CompareAllEventsVsModeled? - Main sheet: NASL - Excel file contains the data used to calculate the CNEL at each site. - The CNEL at each site is a dB average across all monitoring periods - The data used for plotting is on a separate tab (NAS_Plot_Data) and pulls from the main sheet (NASL) - The columns contain the following: - SiteID - Name - MX_SLMSerialNumber: The SLM Serial Number corresponding for the SLM used at this site during this monitoring periods - Aircraft Noise Events: CNEL calculated from identified Aircraft Noise Events - All Events: CNEL calculated from all Noise Events during the period - Delta (All - Aircraft): CNEL Difference between All Events and Aircraft Noise Events - Modeled: CNEL from real-time modeling - Delta (Modeled - All): CNEL Difference between Modeled and All Events - Sort: Column used to sort Site in descending site ID How to read NASL_CNEL.xlsm - Main Sheet: MP Comparisons - Supporting Sheets: MP1_Data, MP2_Data, MP3_Data, MP4_Data - Hidden Sheets: Plot_All_Data (data used for plotting and pulls from main sheet) - This is a macro-enabled workbook with acoustic functions provided as MACROS Functions include: - ENERGY2DB: Converts sound energy (power) to dB - DB2ENERGY: Converts dB to sound energy (power) - Log10: Take the Log with base 10 of a number - DBSUM: Sum dB values on an energy basis, to account for the logarithmic nature of the dB unit - The Main Sheet columns contain the following: - SiteID - Name - Real-Time Modeled CNEL: CNEL from real-time modeled operations - Previously Modeled CNEL: CNEL from previously modeled operations (last EIS) - Real-Time Measured CNEL: CNEL from Aircraft Noise Events - See supporting sheets - Difference between Real-Time Modeled CNEL and Measured CNEL - Difference between Previously Modeled and Measured CNEL - Sort: Column used to sort Site in descending site ID - The Supporting sheet columns contain the following: - SiteID - Site Name - CNEL Reeves Field All Aircraft: - See NASL_MX_DailyCNEL PDFs - CNEL Reeves Field All Airfields (Round) - Rounded CNEL value How to read NASL_MX_DailyCNEL? - This file contains all DailyCNEL identified at NASL during a monitoring period. The CNEL is also calcualted for several categories of Aircraft, Runway, and Operation Type - The bottom of each page indicates the Site ID. - The top right value (DailyAverage for ALL operations) is used as the CNEL for the monitoring period at the site - The columns contain the following information: - Aircraft - Runway - Type - Day_yyyy_mm_dd: CNEL for Aircraft Noise Events from that day - Daily Average: Average across all 7 days of the period, on an energy basis