{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Export_data","File_information","Seal_AU_totals","Haulout_Breeding_Unit_Abundance","Unit_description","Seal_survey_effort","Seal_survey_programme_metadata","Vocabularies"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":2,"defined_names":56,"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":"Export_data","index":0,"n_rows":35,"n_cols":5,"rows_kept":35,"cut":false,"hidden":false,"merged":[[25,0,25,13]]}
[]
[]
["Biodiversity data - Seals"]
[]
["This file converts data to an XML file that can be uploaded to the Seals biodiversity database. "]
[]
["1) COPY YOUR DATA INTO THE EXCEL FILE tabs:"]
[]
[null,"worksheet tab: File_information",null,null,"This worksheet should always be filled in"]
[null,"worksheet tab: Seal_AU_totals",null,null,"This worksheet should be filled in if possible"]
[null,"worksheet tab: Haulout_Breeding_Unit_Abundance",null,null,"This worksheet should always be filled in"]
[null,"worksheet tab: Unit_description",null,null,"This worksheet should be filled when the Unit information changes"]
[null,"worksheet tab: Seal_survey_effort",null,null,"This worksheet should always be filled in"]
[null,"worksheet tab: Seal_survey_programme_metadata",null,null,"This worksheet should be filled when the survey metadata changes"]
[null,"worksheet tab: Vocabularies",null,null,"For reference, used in the dropdown boxes on worksheets"]
[]
[null,"All red outlined cells are mandatory and should be checked / filled in"]
[]
[null,"All green outlined cells are optional "]
[]
[]
["2) Use the button here to export the completed Excel data template to XML."]
[]
[]
[]
["5) The vocabularies are included as a worksheet tab. These are the valid codes for use in the drop down boxes in the spreadsheet fields. The vocabularies on the vocabulary worksheet will also be available on the ICES Vocab server (once finalized). The latest versions of the vocabularies will be the ones available via the URL below. It may be that from time to time the lists are updated on the vocab server, so it is always best to check that you have the latest version of the Excel spreadsheet"]
["https://vocab.ices.dk"]
["5.a) The complete list of EDMO codes can be found in:"]
["https://vocab.ices.dk/?ref=1398"]
["https://www.seadatanet.org/Metadata/EDMO-Organisations"]
[]
["6) Go to this website for more information on the reporting requirements, to upload your data, or to access the latest versions of the submission Template."]
["https://biodiversity.ices.dk"]
[]
["7) For a complete description of reporting fields see the OSPAR Reporting Guidance for seals data"]

{"sheet":"File_information","index":1,"n_rows":3,"n_cols":5,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,"ISO 3166 Code (2-ALPHA) (Vocabulary)","EDMO code lookup\n(Vocabulary)","Name and/or e-mail, important for the restricted data"]
[null,null,"Country ","Reporting_organisation","Contact"]

{"sheet":"Seal_AU_totals","index":2,"n_rows":4,"n_cols":13,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
[]
[]
["Latin name","YYYY","YYYY","YYYY","Vocabulary","Vocabulary\nparameter the value is reported for","Integer","Vocabulary","Vocabulary","(mm)","(mm)","Unique indentifier that links to [Seal_survey_programme_metadata]","Vocabulary"]
["Species_name","Focal_year","Start_year","End_year","Seal_assessment_unit","PARAM","Value","Estimate_type","Activity_type","Survey_start_month","Survey_end_month","Survey_programmeID","Data_access"]

{"sheet":"Haulout_Breeding_Unit_Abundance","index":3,"n_rows":4,"n_cols":13,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
[]
[]
["Latin name","(yyyy)","Date (yyyyymmdd)","Text, as specified in the tab Unit_description","Vocabulary\nparameter the value is reported for","Integer","Vocabulary","Vocabulary","(mm)","(mm)","Unique identifier that links to [Seal_survey_effort]","Unique indentifier that links to [Seal_survey_programme_metadata]","Vocabulary"]
["Species_name","Year","Date","UnitID","PARAM","Value","Estimate_type","Activity_type","Survey_start_month","Survey_end_month","SurveyID","Survey_programmeID","Data_access"]

{"sheet":"Unit_description","index":4,"n_rows":4,"n_cols":10,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
[1,{"$f":"A1+1","v":2},{"$f":"B1+1","v":3},4,5,6,7,8,9,10]
[]
["National identifier (unique number)","Free text","Vocab","Vocabulary","WGS84, decimal degrees","WGS84, decimal degrees","Reported in GeoJSON","Vocabulary","Vocabulary","Vocabulary"]
["UnitID","Unit_name","Unit_type","Geometry_type","Latitude","Longitude","Polygon","Area_type","Area_reference","Seal_assessment_unit"]

{"sheet":"Seal_survey_effort","index":5,"n_rows":4,"n_cols":10,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
[]
[]
["Unique ID to be generated by submitter","Unique ID that links to [Seal_survey_programme_metadata]","Vocabulary","Vocabulary","Date (yyyyymmdd)","Date (yyyyymmdd)","Vocabulary","Vocabulary","Vocabulary","Reported in GeoJSON"]
["SurveyID","Survey_programmeID","PlatformClass","Count_method","Start_date","End_date","Data_resolution","Data_type","Geometry_type","Polygon"]

{"sheet":"Seal_survey_programme_metadata","index":6,"n_rows":4,"n_cols":10,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
[]
[]
["Unique ID to be generated by submitter","Free text","(yyyy)","(yyyy)","ISO 3166 Code (2-ALPHA)\n(Vocabulary)","EDMO Code; this is the data monitoring monitoring organisation, which is not neccesarily the organisation submitting data","Free text","Free text","Free text, max.500 char","Free text"]
["Survey_programmeID","Programme_name","Start_year","End_year","Country ","Institute","Contact","Website","Survey_protocol","References"]

{"sheet":"Vocabularies","index":7,"n_rows":28,"n_cols":57,"rows_kept":28,"cut":false,"hidden":false,"merged":[]}
[1,{"$f":"A1+1","v":2},{"$f":"B1+1","v":3},4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57]
["ISO_3166","https://vocab.ices.dk/?CodeTypeRelID=337&CodeID=156386",null,"EDMO","https://vocab.ices.dk/?ref=1398",null,"SpecWoRMS","https://vocab.ices.dk/?ref=365",null,"SealAU","https://vocab.ices.dk/?ref=1672",null,"PARAM","https://vocab.ices.dk/?ref=37",null,"EstimateType","https://vocab.ices.dk/?ref=1674",null,"CountType","https://vocab.ices.dk/?ref=1677",null,"ActyvityType","https://vocab.ices.dk/?ref=1675",null,"Data_access","https://vocab.ices.dk/?ref=1435",null,"DataResolution","https://vocab.ices.dk/?ref=1676",null,"GeometryType",null,"AreaType","https://vocab.ices.dk/?ref=1446",null,"Areas_OSPAR","https://vocab.ices.dk/?CodeTypeRelID=349&CodeID=156501",null,"Platform Class","https://vocab.ices.dk/?ref=311",null,"https://vocab.ices.dk/?ref=1440",null,"DataResolution","https://vocab.ices.dk/?ref=1676"]
["ISO country code","Country name",null,"EDMO code","Description",null,"AphiaID","Species_name",null,"Seal_assessment_unit","Description",null,"PARAM","Description",null,"Estimate_type","Description",null,"Data_type","Description",null,"Activity_type","Description",null,"Data_access","Description",null,"Unit_type","description",null,"Geometry_type",null,"Area_type","Description",null,"Area_reference","OSPAR region description",null,"PlatformClass","Description",null,"BD_CountMethod",null,"Data_resolution","Description"]
["BE","Belgium",null,3512,"The Swedish Agency for Marine and Water Management (SWAM) ",null,137080,"Halichoerus grypus",null,1,"Southwest Scotland",null,"SP-P","Pup production",null,"Maximum","Maximum",null,"PA","presence and absence",null,"moult","moulting season",null,"Public","Public",null,"HU","Haulout unit",null,"Point",null,"OSPARRegion","Ospar Region",null,1,"Artic Waters (OSPAR region I)",null,0,"Unknown",null,"photo",null,"HU","Haulout units"]
["DK","Denmark",null,2746,"Joint Nature Conservation Committee - Peterborough Office (JNCC) ",null,137084,"Phoca vitulina",null,2,"West Scotland",null,"S-C-Tot","Total count (all ages)",null,"Modelled","Modelled estimate",null,"P","presence only",null,"breeding","breeding season",null,"Restricted","Restricted",null,"BU","Breeding unit",null,"Line",null,null,null,null,2,"Greater North Sea (OSPAR region II)",null,10,"Land or seafloor",null,"observed",null,"BU","Breeding units"]
["EE","Estonia",null,1375,"Joint Nature Conservation Committee - Aberdeen Office (JNCC) ",null,null,null,null,3,"Western Isles",null,"S-C-AdJuv","Adult/juvenile count",null,"Count-1day","Count on single day",null,null,null,null,"summer","summer colonies",null,null,null,null,null,null,null,"Polygon",null,null,null,null,3,"Celtic Seas (OSPAR region III)",null,31,"Research vessel",null,"video",null,"grid-5km","5 km grid"]
["FO","Faroe Islands",null,4477,"Danish Energy Agency",null,null,null,null,4,"North coast and Orkney",null,"SP-C-A","Pup count (All)",null,"Count-over-days","Counts over multiple days",null,null,null,null,null,null,null,null,null,null,null,null,null,"MultiPolygon",null,null,null,null,4,"Bay of Biscay and Iberian Coast (OSPAR region IV)",null,32,"Vessel of opportunity",null,"mixed"]
["FI","Finland",null,1526,"Rijkswaterstaat Water, Traffic and Environment",null,null,null,null,5,"Shetland",null,"SP-C-WC","Pup count (Whitecoats)",null,"Count-over-years","Counts over multiple years",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,"Wider Atlantic (OSPAR region V)",null,33,"Self-propelled small boat"]
["FR","France",null,457,"Danish Forest and Nature Agency ",null,null,null,null,6,"Moray Firth",null,"SP-C-MP","Pup count (Moulted pups)",null,"Average","Average",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,35,"Vessel of opportunity on fixed route"]
["DE","Germany",null,1850,"Federal Maritime and Hydrographic Agency (BSH) ",null,null,null,null,7,"East Scotland",null,"SP-C-DP","Pup count (Dead pups)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,37,"Self-propelled boat"]
["GL","Greenland",null,3327,"Royal Belgian Institute of Natural Sciences, Operational Directorate Natural Environment (RBINS-ODNATURE-Gulledelle)",null,null,null,null,8,"Northeast England",null,"SP-C-Oth","Pup count (other categories)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,38,"Man-powered boat"]
["IS","Iceland",null,411,"Environmental Protection Agency ",null,null,null,null,9,"Southeast England",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,61,"Research aeroplane"]
["IE","Ireland",null,3316,"Department of Environment, Community & Local Government ",null,null,null,null,10,"South England",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,62,"Aeroplane"]
["LV","Latvia",null,396,"Marine Institute (MI)",null,null,null,null,11,"Southwest England",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,67,"Helicopter"]
["LT","Lithuania",null,2381,"National Parks & Wildlife Service ",null,null,null,null,12,"Wales",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"6D","Unmanned aerial vehicle"]
["NL","The Netherlands",null,2803,"Directorate for Coast and Sea Sustainability. Ministry of Agriculture, Food and Environment (MAGRAMA)",null,null,null,null,13,"Northwest England"]
["NO","Norway",null,49,"Sea Mammal Research Unit (SMRU)",null,null,null,null,14,"Northern Ireland"]
["PL","Poland",null,null,null,null,null,null,null,15,"Ireland"]
["PT","Portugal",null,null,null,null,null,null,null,16,"French North Sea and Channel coast"]
["RU","Russian Federation",null,null,null,null,null,null,null,17,"Belgium coast and Dutch Delta"]
["ES","Spain",null,null,null,null,null,null,null,18,"Wadden Sea"]
["SE","Sweden",null,null,null,null,null,null,null,19,"Limfjord"]
["GB","UK",null,null,null,null,null,null,null,20,"Kattegat"]
["GG","UK (Guernsey)",null,null,null,null,null,null,null,21,"Iceland"]
["IM","UK (Isle of Man)",null,null,null,null,null,null,null,22,"Skagerrak"]
["JE","UK (Jersey)",null,null,null,null,null,null,null,23,"Norway MA1"]
[null,null,null,null,null,null,null,null,null,24,"Norway MA2"]
[null,null,null,null,null,null,null,null,null,25,"Norway MA3"]