{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Guide","Guide DK","noise_register_data","vocabularies"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Guide","index":0,"n_rows":27,"n_cols":7,"rows_kept":27,"cut":false,"hidden":false,"merged":[[16,2,16,6],[17,2,17,6],[18,2,18,6],[19,2,19,6],[20,2,20,6],[26,2,26,6],[21,2,21,6],[22,2,22,6],[23,2,23,6],[24,2,24,6],[25,2,25,6],[8,2,8,6],[14,2,14,6],[15,2,15,6],[0,1,0,6],[9,1,10,1],[11,2,11,6],[12,2,12,6],[13,2,13,6],[9,2,9,6],[1,2,1,6],[2,2,2,6],[3,2,3,6],[4,2,4,6],[5,2,5,6],[6,2,6,6],[7,2,7,6]]}
["Template in general:","The sheet is divided into themes (left row); a) Station: information of the area/locality where the activity is taking place,  b) Event: information about the activity, c) Mitigation: Information concerning mitigation, d) Optional attributes: additional information about the activity. Red fields are minimum requriements for the registration. Fields in green are optional, and only to be filled in if the information is available. One line in the noise register tab has to be filled in for every coherent period of time in which the activity is going on. If an acitivity is taking place between the 3rd January and the 5th of January and again on the 8th of january, 2 lines have to be filled in. Furthermore a new registration (new line) has to be made when changing locality. \n\nGenerally the register should include the use of sound soruces in the range of 10 Hz to 10 KHz.\n\nA set of blocks has been predefined delineating geographical areas to which the registration is to relate for moving activities such as seismic surveys, see maps below and www.ices.dk/marine-data/maps/Pages/ICES-statistical-rectangles.aspx,  for information of the definition of the ICES polygons. A seismic survey should be registered in relation to the ICES subrectangle blocks (polygons). Polygon source data can be reported in two ways; by entering the Latitude and Longitude of the centroid of the polygon and selecting the appropriate polygon type from Geometry_type (ICES sub-rectancles). Alternatively, these fields can be left blank and the identifier for the polygon can be entered in the polygon_ID field. Every time a survey is moving into a new polygon, a new line in the register must be filled in. The following minimum registration is necessary for the given activities:\n\nSeismic surveys: data_entry_point_ID, start_date, end_date, geometry_type, polygon_ID, source_event, value. Optional registration in other fields should be done as applicable for the specific activity. If possible actual values (SEL, Lpeak) should be included.\n\nPile driving, conducter driving: data_entry_point_ID, start_date, end_date, latitude, longitude, geometry_type, source_event, value. Optional registration in other fields should be done as applicable for the specific activity.  If possible actual values (SEL, Lpeak) as well as the hammer type should be included.\n                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    \n"]
[null,"data_entry_point_ID (string)","ID, number or survey name"]
[null,"start_date (ddmmyyyy)"]
["Station","end_date (ddmmyyyy)"]
[null,"Latitude (WGS84)"]
[null,"Longitude (WGS84)"]
[null,"Geometry_type (Point, Uk license blocks, ICES sub-rectangles, German naval polygon)","Drop down list specifying how the positioning of the activity is registered. For exact position choose \"point\" for moving activities such as seismic, choose \"ICES_SubRectangle\". See map below for reference. A new registration/line must be used when entering a new subrectangle."]
[null,"polygon_ID                               (ICES sub-rectangle ID or Regional Polygon ID)","ID-number refering to the the block in which the activity is taking place (ICES ), see map below for reference. No registration needed in this field when an exact position in lat-long is provided."]
[null,"source_event (vocab list)","Drop down list specifying the source of noise eg. airgun, pile driving, eksplosion etc."]
["Event","value (from list: very_low/low/medium/high/very_high)","Sound/energy level drop down list. See interval definition below or \"Monitoring guidance for Underwater Noise in European Seas, Part I: Executive Summary\" page 8-9 for further information (link:http://publications.jrc.ec.europa.eu/repository/bitstream/JRC88733/lb-na-26557-en-n.pdf). The level used for placing the acticvity in the correct interval can be either modelled/claculated or meassured. "]
[null,null,"Airgun arrays (zero to peak source level, rounded to nearest decibel):\n· Very low: 209-233 dB re 1 μPa m\n· Low: 234-243 dB re 1 μPa m\n· Medium: 244-253 dB re 1 μPa m\n· High: above 253 dB re 1 μPa m","Explosions (equivalent TNT charge mass, rounded to nearest 10 g if less than 10 kg and to\nnearest 1 kg otherwise)\n· Very low: 8 g to 210 g\n· Low: 220 g to 2.1 kg\n· medium: 2.11-21 kg\n· high: 22-210 kg\n· Very high: above 210 kg\n","Impact pile driver (hammer energy, rounded to nearest 10 kJ)\n· Very low: less than 280 kJ\n· Low: 290 kJ-2.80 MJ\n· Medium: 2.81-28 MJ\n· High: above 28 MJ\n","Sonar or acoustic deterrents (source level, rounded to nearest decibel):\n· Very low: 176-200 dB re 1 μPa m\n· Low: 201-210 dB re 1 μPa m\n· Medium: 211-220 dB re 1 μPa m\n· High: above 220 dB re 1 μPa m\n","Generic explicitly impulsive source (energy source level, rounded to nearest decibel):\n· Very low: 186-210 dB re 1 μPa² m² s\n· Low: 211-220 dB re 1 μPa² m² s\n· Medium: 221-230 dB re 1 μPa² m² s\n· High: above 230 dB re 1 μPa² m² s\n"]
[null,"sound_mitigation_bool (yes/no)","specifying if any type of mitigation is in place."]
[null,"NMS_type (from list: BBC/SBC/IHC/HSD/HEP/COF/CBBCIHC/CBBCHSD/CBBCCOF/Other)","Specifying the type of mitigation. See the \"vocabularies\" tab for explanation of abbreviations."]
[null,"sound_measurement_bool (yes/no)","specifies whether meassurements have been made during the activity"]
["Mitigation","SEL (dB re 1µPa²s)\n","The actual value of the meassurement provided as SEL (Sound Exposure Level)"]
[null,"Lpeak (dB re 1µPa)","The actual value of the meassurement provided as  Lpeak"]
[null,"distance_to_pile (metres, decimal)"]
[null,"type_hammer (Model number of hammer used, e.g. S-2000, 3000S)","Type of hammer used for pile driving actrivities."]
[null,"max_energy (Kj)","Not applicable for activities in danish waters"]
[null,"source_spectra (UNIT to be determined)","The frequency band of the event. Not currently applicable since format is to be determined."]
[null,"duty_cycle (decimal)","The percentage of the duration the signal was active  (pulse duration/pulse interval)"]
[null,"start_time (hhmm)","Start time of the event transmission"]
["Optional attributes","duration (seconds, integer)","Duration of the event in seconds"]
[null,"directivity (decimal)"]
[null,"source_depth (metres, decimal)","Approximate depth of the sound source in metres from sea surface ."]
[null,"platform_speed (Knots, decimal)","Speed of the platform recording the event"]
[null,"remarks (free text)","Any free text comments or additional supporting information, eg. Information of other mitigation meassures than the ones described above (soft start etc.)."]

{"sheet":"Guide DK","index":1,"n_rows":29,"n_cols":7,"rows_kept":29,"cut":false,"hidden":false,"merged":[[15,2,15,6],[16,2,16,6],[5,2,5,6],[6,2,6,6],[7,2,7,6],[8,2,8,6],[9,2,9,6],[22,2,22,6],[23,2,23,6],[24,2,24,6],[25,2,25,6],[26,2,26,6],[17,2,17,6],[18,2,18,6],[19,2,19,6],[20,2,20,6],[21,2,21,6],[0,1,0,6],[11,2,11,6],[12,2,12,6],[13,2,13,6],[14,2,14,6],[9,1,10,1],[1,2,1,6],[2,2,2,6],[3,2,3,6],[4,2,4,6]]}
["Generelt om registret:","Registret er opdelt i en række overordnede temaer (rækken yderst tv); a) Station: information om lokaliteten hvor aktiviteten finder sted, b) Event: information om aktiviteten c) Mitigation: Information om evt. afbødende foranstaltninger d) Optional attributes: yderligere oplysninger om aktiviteten. Felter markeret med rødt er obligatoriske, hvorimod felter markeret med grønt kun skal udfyldes, hvis muligt. Der skal udfyldes en linje i skemaet for hver sammenhængende tidsperiode aktiviteten finder sted. Dvs., hvis man laver en undersøgelse fra den 3/1-5/1 og igen den 8/1, skal der udfyldes 2 linjer. Der skal også udfyldes en linje, hver gang man skifter lokalitet.\n\nRegistringen omfatter som udgangspunkt brugen af lydkilder fra 10 Hz til 10 kHz. \n\nPre-definerede blokke (polygoner) er defineret til brug for aktiviteter der bevæger sig, eks seismik, se kort nedenfor og http://www.ices.dk/marine-data/maps/Pages/ICES-statistical-rectangles.aspx,  for information om definitionen af blokkene. Blokkene  kan registreres på 2 måder; enten ved at indtaste breddegrad og længdegrad af det geometriske tyngdepunkt af polygonen og derefter vælge den relevante polygon type fra \"Geometry Type\" (ICES sub-rectangle). Alternativt kan disse felter stå tomme og ID numret for polygonen kan indtastes i polygonen ID feltet. Der skal foretages en ny registrering, hver gang en indsamling, af eksempelvis seismik, bevæger sig ind i en ny ICES sub-rektangle polygon. Minimumsregistrering for angivne aktiviteter er som følger: \n\nSeismiske surveys: data_entry_point_ID, start_date, end_date, geometry_type, polygon_ID, source_event, value. Øvrige felter udfyldes vis muligt for den enkelte aktivitet. Faktiske værdier (SEL, Lpeak) bør inkluderes hvis muligt.\n\nPælenedramning, nedramning af ledeforingsrør: data_entry_point_ID, start_date, end_date, latitude, longitude, geometry_type, source_event, value. Øvrige felter udfyldes vis muligt for den enkelte aktivitet. Faktiske værdier (SEL, Lpeak) samt type af hammer bør inkluderes hvis muligt."]
[null,"data_entry_point_ID (string)","ID, evt.nummer eller survey navn"]
[null,"start_date (ddmmyyyy)","Starttidspunkt"]
["Station","end_date (ddmmyyyy)","Sluttidspunkt"]
[null,"Latitude (WGS84)","Breddegrad"]
[null,"Longitude (WGS84)","Længdegrad"]
[null,"Geometry_type (Point, Uk license blocks, ICES sub-rectangles, German naval polygon)","Liste som angiver hvordan positionen for aktiviteten registreres. Hvis det er den eksakte position for aktiviteten angives \"point\". For aktiviteter der bevæger sig, som eks. seismik, vælges \"ICES_SubRectangle\", se kort nedenfor.  Der skal udfyldes en ny linje, hver gang man skifter \"blok\""]
[null,"polygon_ID                               (ICES sub-rectangle ID or Regional Polygon ID)","ID-nummer, der refererer til den blok aktiviteten befinder sig i (ICES). "]
[null,"source_event (vocab list)","Liste hvor man angiver støjkilden fx airgun, pælenedramninger, eksplosion osv."]
["Event","value (from list: very_low/low/medium/high/very_high)","Lyd-/energiniveau. Se definitionen af intervaller herunder eller \"Monitoring guidance for Underwater Noise in European Seas, Part I: Executive Summary\" side 8-9 for yderligere information. (link:http://publications.jrc.ec.europa.eu/repository/bitstream/JRC88733/lb-na-26557-en-n.pdf). Lydniveauet som skal anvendes kan være enten målt eller modelleret/beregnet. "]
[null,null,"Airgun arrays (zero to peak source level, rounded to nearest decibel):\n· Very low: 209-233 dB re 1 μPa m\n· Low: 234-243 dB re 1 μPa m\n· Medium: 244-253 dB re 1 μPa m\n· High: above 253 dB re 1 μPa m","Explosions (equivalent TNT charge mass, rounded to nearest 10 g if less than 10 kg and to\nnearest 1 kg otherwise)\n· Very low: 8 g to 210 g\n· Low: 220 g to 2.1 kg\n· medium: 2.11-21 kg\n· high: 22-210 kg\n· Very high: above 210 kg\n","Impact pile driver (hammer energy, rounded to nearest 10 kJ)\n· Very low: less than 280 kJ\n· Low: 290 kJ-2.80 MJ\n· Medium: 2.81-28 MJ\n· High: above 28 MJ\n","Sonar or acoustic deterrents (source level, rounded to nearest decibel):\n· Very low: 176-200 dB re 1 μPa m\n· Low: 201-210 dB re 1 μPa m\n· Medium: 211-220 dB re 1 μPa m\n· High: above 220 dB re 1 μPa m\n","Generic explicitly impulsive source (energy source level, rounded to nearest decibel):\n· Very low: 186-210 dB re 1 μPa² m² s\n· Low: 211-220 dB re 1 μPa² m² s\n· Medium: 221-230 dB re 1 μPa² m² s\n· High: above 230 dB re 1 μPa² m² s\n"]
[null,"sound_mitigation_bool (yes/no)","Her angives om der er foretaget nogle afbødende foranstaltninger i forbindelse med aktiviteten."]
[null,"NMS_type (from list: BBC/SBC/IHC/HSD/HEP/COF/CBBCIHC/CBBCHSD/CBBCCOF/Other)","Angiver hvilken afbødende foranstaltning der er anvendt. Forklaring på forkortelserne findes i fanebladet \"vocabularies\"."]
[null,"sound_measurement_bool (yes/no)","Udfyldes hvis der har været foretaget konkrete målinger af lydniveauet under aktiviteten."]
["Mitigation","SEL (dB re 1µPa²s)\n","Her skrives værdien af lydmålingen udtrykt som SEL (Sound Exposure Level, der er et udtryk for energien i lydeksponeringen)"]
[null,"Lpeak (dB re 1µPa)","Her skrives værdien af lydmåling udtrykt som L peak (en værdi for spidslydtrykket, dvs udtryk for intensiteten i lydeksponeringen, der bruges til at beskrive korte og stereotype signaler) som fx seismiske måleimpulser)"]
[null,"distance_to_pile (metres, decimal)"]
[null,"type_hammer (Model number of hammer used, e.g. S-2000, 3000S)","Type af hammer der bruges til pælenedramning"]
[null,"max_energy (Kj)","Ikke relevant for Danmark"]
[null,"source_spectra (UNIT to be determined)","Frekvensbåndet. Ikke relevant på nuværende tidspunkt, da enheden endnu ikke er fastlagt."]
[null,"duty_cycle (decimal)","Den %-del af varigheden hvor signalet var aktivt (puls varighed/puls interval)"]
[null,"start_time (hhmm)","Starttidspunktet for transmissionen  "]
["Optional attributes","duration (seconds, integer)","Varigheden af begivenheden i sekunder  "]
[null,"directivity (decimal)"]
[null,"source_depth (metres, decimal)","Ca. dybden af lydkilden målt i meter fra havoverfladen"]
[null,"platform_speed (Knots, decimal)","Hastighed af den platform der optager lyden "]
[null,"remarks (free text)","Kommentarfelt, her kan noteres supplerende oplysninger, fx hvis man benytter andre afbødende foranstaltninger end de beskrevne (som eks. soft start)"]
[]
[null,null,null,null,null,"\n"]

{"sheet":"noise_register_data","index":2,"n_rows":3,"n_cols":25,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,"Station",null,null,null,null,null,"Event",null,null,null,"Mitigation",null,null,null,null,null,null,null,"Optional attributes"]
["data_entry_point_ID (string)","start_date (ddmmyyyy)","end_date (ddmmyyyy)","Latitude (WGS84)","Longitude (WGS84)","Geometry_type (Point, Uk license blocks, ICES sub-rectangles, German naval polygon)","polygon_ID                               (ICES sub-rectangle ID or Regional Polygon ID)","source_event (vocab list)","value_code (from list: NA/very_low/low/medium/high/very_high)","sound_mitigation_bool (yes/no)","NMS_type (from list: BBC/SBC/IHC/HSD/HEP/COF/CBBCIHC/CBBCHSD/CBBCCOF/Other)","sound_measurement_bool (yes/no)","SEL (dB re 1µPa²s)\n","Lpeak (dB re 1µPa)","distance_to_pile (metres, decimal))","type_hammer (Model number of hammer used, e.g. S-2000, 3000S)","max_energy (Kj)","source_spectra (UNIT to be determined)","duty_cycle (decimal)","start_time (hhmm)","duration (seconds, integer)","directivity (decimal)","source_depth (metres, decimal)","platform_speed (Knots, decimal)","remarks (free text)"]

{"sheet":"vocabularies","index":3,"n_rows":17,"n_cols":21,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
["value_code","Sonar or acoustic deterrents (source level, rounded to nearest decibel)","Generic explicitly impulsive source (energy source level, rounded to nearest decibel)","Airgun arrays (zero to peak source level, rounded to nearest decibel): ","Explosions (equivalent TNT charge mass, rounded to nearest 10 g if less than 10 kg and to nearest 1 kg otherwise)","Impact pile driver (hammer energy, rounded to nearest 10 kJ) ",null,"ISO Country Codes","Country",null,"Source Event",null,"EDMO code","EDMOD Code Description",null,"Yes/No type",null,"Types of noise mitigation systems ",null,null,"Geometry_type"]
["NA",null,null,null,null,null,null,"BE","Belgium",null,"Airgun_arrays",null,193,"Institute of Meteorology and Water Management, Maritime Branch in Gdynia (IMWM MB) (IMGW OM)",null,"Yes",null,"NMS_Type","Description",null,"Point"]
["very_low","176-200 dB re 1 μPa m ","186-210 dB re 1 μPa2 m2 s ","209-233 dB re 1 μPa m ","8 g to 210 g ","< 280 kJ ",null,"DE","Germany",null,"Explosions",null,396,"Marine Institute (MI)",null,"No",null,"BBC","Big Bubble Curtain",null,"ICES_SubRectangle"]
["low","201-210 dB re 1 μPa m ","211-220 dB re 1 μPa2 m2 s ","234-243 dB re 1 μPa m ","220 g - 2.1 kg ","290 kJ - 2.80 MJ ",null,"DK","Denmark",null,"Generic_explicitly_impulsive_source",null,411,"Environmental Protection Agency ",null,null,null,"SBC","Small Bubble Curtain",null,"UK_Licence_Blocks"]
["medium","211-220 dB re 1 μPa m ","221-230 dB re 1 μPa2 m2 s ","244-253 dB re 1 μPa m ","2.11 kg - 21 kg ","2.81 - 28 MJ ",null,"EE ","Estonia",null,"Impact_pile_driver",null,457,"Danish Forest and Nature Agency ",null,null,null,"IHC","I H C - Noise Mitigation System",null,"German_Naval_Polygon"]
["high","> 220 dB re 1 μPa m ","> 230 dB re 1 μPa2 m2 s ","> 253 dB re 1 μPa m","22 kg - 210 kg ","> 28 MJ ",null,"ES","Spain",null,"Sonar_or_acoustic_deterrents",null,1375,"Joint Nature Conservation Committee - Aberdeen Office (JNCC) ",null,null,null,"HSD","HydroSoundDamper"]
["very_high",null,null,null,"> 210 kg ",null,null,"FI","Finland",null,null,null,1526,"Rijkswaterstaat Water, Traffic and Environment",null,null,null,"HEP","Pile-in-Pile Jacket"]
[null,null,null,null,null,null,null,"FR","France",null,null,null,1850,"Federal Maritime and Hydrographic Agency (BSH) ",null,null,null,"COF","Cofferdamm"]
[null,null,null,null,null,null,null,"GB","Great Britain",null,null,null,2381,"National Parks & Wildlife Service ",null,null,null,"CBBCIHC","Combined BBC and I H C-NMS"]
[null,null,null,null,null,null,null,"IE","Ireland",null,null,null,2746,"Joint Nature Conservation Committee - Peterborough Office (JNCC) ",null,null,null,"CBBCHSD","Combined BBC and HSD"]
[null,null,null,null,null,null,null,"LI","Lituania",null,null,null,2803,"Directorate for Coast and Sea Sustainability. Ministry of Agriculture, Food and Environment (MAGRAMA)",null,null,null,"CBBCCOF","Combined BBC and Cofferdamm"]
[null,null,null,null,null,null,null,"LV","Latvia",null,null,null,3316,"Department of Environment, Community & Local Government ",null,null,null,"Other","Other system or other combination"]
[null,null,null,null,null,null,null,"NL","Netherlands",null,null,null,3327,"Royal Belgian Institute of Natural Sciences, Operational Directorate Natural Environment (RBINS-ODNATURE-Gulledelle)"]
[null,null,null,null,null,null,null,"PT ","Portugal",null,null,null,3512,"The Swedish Agency for Marine and Water Management (SWAM) "]
[null,null,null,null,null,null,null,"PL","Poland",null,null,null,4477,"Danish Energy Agency"]
[null,null,null,null,null,null,null,"RU","Russia"]
[null,null,null,null,null,null,null,"SE","Sweden"]