NASWI Results
Contents:
- NASWI_CompareAllEventsVsModeled.xlsx
- NASWI_DNL.xlsm
- NASWI_M1_DailyDNL.pdf
- NASWI_M2_DailyDNL.pdf
- NASWI_M3_DailyDNL.pdf
- NASWI_M4_DailyDNL.pdf
- OLF Coupeville Daily DNL.zip
    - OLF Coupeville Daily DNL
        - 2020-12-15_OLF.xlsx
        - 2020-12-16_OLF.xlsx
        - 2020-12-16_OLF_NotIncluding2ndPeriod.xlsx
        - 2020-12-17_OLF.xlsx
        - 2021-03-29_OLF.xlsx
        - 2021-03-30_OLF.xlsx
        - 2021-04-01_OLF.xlsx
        - 2021-06-07_OLF.xlsx
        - 2021-06-08_OLF.xlsx
        - 2021-06-09_OLF.xlsx
        - 2021-06-10_OLF.xlsx
        - 2021-08-09_OLF.xlsx
        - 2021-08-10_OLF.xlsx
        - 2021-08-12_OLF.xlsx
        
How to read NASWI_CompareAllEventsVsModeled?
- Main sheet: NASWI
- Excel file contains the data used to calculate the DNL at each site. 
- The DNL at each site is a dB average across all monitoring periods, except for 
  Site 33_SG, which is a dB average across M2, M3, and M4
- The data used for plotting is on a separate tab (NASWI_Plot_Data) and pulls 
  from the main sheet (NASWI)
- 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: DNL calculated from identified Aircraft Noise 
      Events
    - All Events: DNL calculated from all Noise Events during the period
    - Delta (All - Aircraft): DNL Difference between 
      All Events and Aircraft Noise Events
    - Modeled: DNL from real-time modeling
    - Delta (Modeled - All): DNL Difference between 
      Modeled and All Events
    - Sort: Column used to sort Site in descending site ID
    
How to read NASWI_DNL.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 DNL: DNL from real-time modeled operations
    - Previously Modeled DNL: DNL from previously modeled operations (last EIS)
    - Real-Time Measured DNL: DNL from Aircraft Noise Events
        - See supporting sheets
    - Difference between Real-Time Modeled DNL and Measured DNL
    - Difference between Previously Modeled and Measured DNL
    - Sort: Column used to sort Site in descending site ID
- The Supporting sheet columns contain the following:
    - SiteID
    - Site Name
    - DNL Ault Field All Aircraft: 
        - See NASWI_MX_DailyDNL PDFs
    - DNL Coupeville All FCLP
        - See table below
    - DNL Combined All Airfields
        - Sum of DNL from Ault Field and Coupeville
- The DNL from FCLP activities is calculated on a daily basis, summed across all 
  days in the period, and then averaged across 7 days
  
How to read NASWI_MX_DailyDNL?
- This file contains all DailyDNL identified at NASWI during a monitoring
  period. The DNL 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 DNL for 
  the monitoring period at the site
- The columns contain the following information:
    - Aircraft
    - Runway
    - Type
    - Day_yyyy_mm_dd: DNL for Aircraft Noise Events from that day
    - Daily Average: Average across all 7 days of the period, on an energy basis
    
How to read yyyy-mm-dd_OLF.xlsx?
- These sites contain the A-weighted 1-second measured Sound Level used to 
  calculate the DNL for the FCLP periods for a single day
- There is one sheet per site near the OLF on Whidbey Island
- The columns include:
    - Record #: Unique ID for the for recorded measurement
    - Record Type: Indicates the SLM's operation at that measurement time (RUN)
    - Date
    - Time
    - Tms: The number of milliseconds after the Time that the measurement was 
      recorded
    - LAeq: A-weighted sound level for that measurement
    - DNL: DNL for the FCLP periods that day
        - The entries in this column are the energy dB level converted to sound 
          power
        - If the measurement is during acoustic night, a 10 dB adjustment is 
          applied to the measured level before conversion to sound power
        - The sound power is summed and then divided by the number of seconds in 
          a day to calculate the DNL for the FCLP periods