{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["README","File_information","Fishing_effort","Bycatch_monitor_effort","Bycatch_event","Selected Vocabularies"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"defined_names":13,"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":"README","index":0,"n_rows":49,"n_cols":6,"rows_kept":49,"cut":false,"hidden":false,"merged":[[12,2,12,7],[14,2,14,7]]}
[]
[null,"Bycatch data template"]
[]
[null,"This Excel file converts data to an XML file that can be uploaded to the Bycatch database. "]
[null,"You can check the format here: ",null,null,null,"https://datsu.ices.dk/web/selRep.aspx?Dataset=128"]
[]
[null,"1) COPY YOUR DATA INTO THE TABLES"]
[null,null,"File_information",null,null,"This table should be filled in"]
[null,null,"Fishing_effort",null,null,"This table should be filled in"]
[null,null,"Bycatch_monitor_effort",null,null,"This table should be filled in"]
[null,null,"Bycatch_event",null,null,"Fill in this table if you have observed bycatch events"]
[]
[null,null,"All red outlined cells should be checked / filled in"]
[]
[null,null,"Green cells should be filled in but are not mandatory"]
[]
[]
[]
[]
[null,"2) EXPORT TO XML TEMPLATE"]
[null,"Click the 'export' button on the \"README\" table"]
[]
[null,"3) VERIFY AND UPLOAD"]
[null,"The .xml file can  be uploaded to the Bycatch database via:"]
[null,"https://bycatch.ices.dk/"]
[]
[null,"4) CODES"]
[null,"Some of the fields in the tables refer to a 'vocabulary'. "]
[null,"Following the link on top of the header will take you to the list of available codes for that variable."]
[null,"There is a selection of codes also in the 'Selected Vocabularies' tab"]
[null,"The full list of CodeTypes used in BYCATCH in the ICES vocabulary server:"]
[null,"https://vocab.ices.dk/?dataset=169670"]
[]
[null,"List of the available country codes:  "]
[null,"https://vocab.ices.dk/?ref=337"]
[]
[null,"List of EDMO codes for reporting organisations can be found here:"]
[null,"https://vocab.ices.dk/?ref=1398"]
[]
[null,"For the list of valid species please consult:"]
[null,"https://www.marinespecies.org/"]
[]
[null,"List of the available ICES areas:"]
[null,"https://vocab.ices.dk/?ref=358"]
[]
[]
[]
[null,"version June 2023"]
[null,"Last moification date 16/06/2023"]

{"sheet":"File_information","index":1,"n_rows":3,"n_cols":4,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
[]
[null,"ISO 3166 Code (2 ALPHA)\n(Vocabulary)","EDMO code\n(Vocabulary)","Email of person that fills in the template"]
[null,"Country ","Reporting_organisation","Email"]

{"sheet":"Fishing_effort","index":2,"n_rows":5,"n_cols":17,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,"GFSM_GSAs"]
[null,null,null,null,"ICES_Area and NAFO"]
[]
["Integer (YYYY)","Integer (MM)","Integer (Q)","AreaType","Vocabulary(multiple separated by [~]","Metier-3 ","Metier-4","Metier-5","Metier-6","Vessel size range [m]","Number","Number","Number","Number","Number","Number","Number"]
["Year","Month","Quarter","Area type","Area code","Metier Level 3","Metier Level 4","Metier Level 5","Metier Level 6","Vessel size range [m]","Days at sea F","Vessels F","Trips F","Total length of nets F [km]","Total km hours F","No. of hauls F","Total towing time F"]

{"sheet":"Bycatch_monitor_effort","index":3,"n_rows":5,"n_cols":25,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
[null,null,null,"GFSM_GSAs"]
[null,null,null,"ICES_Area and NAFO"]
[]
["Integer (YYYY)","Integer (MM)","AreaType","Vocabulary","Metier-3 ","Metier-4","Metier-5","Metier-6","Vessel size range [m]","BYC_MonProgr","BYC_SamplingProtocol","BYC_MonMethod","Species scientific name separated (multiple separated by til [~])","BYC_PingerChar","Text","Number","Number","Number","Number","Number","Number","Number","Number","BYC_Mon812Type","Text"]
["Year","Month","Area type","Area code","Metier Level 3","Metier Level 4","Metier Level 5","Metier Level 6","Vessel size range [m]","Monitoring program","Monitoring protocol ","Monitoring method","Fishery target species","Pinger characteristics","Other mitigation measures","Vessels Observed","Trips Observed","Days at sea Observed","Hauls with pingers Observed [%]","Total length of nets Observed [km] ","Total km hours Observed","No. of hauls Observed","Total towing time Observed","Type of 812 monitoring","Comments"]

{"sheet":"Bycatch_event","index":4,"n_rows":5,"n_cols":23,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
[null,null,null,"GFSM_GSAs"]
[null,null,null,"ICES_Area and NAFO"]
[]
["Integer (YYYY)","Integer (MM)","AreaType","Vocabulary","Metier-3 ","Metier-4","Metier-5","Metier-6","Vessel size range [m]","BYC_MonProgr","BYC_SamplingProtocol","BYC_MonMethod","Species scientific name","YesNoFields","Number","Number","Number","Number",null,"Number","Number","Number","Number"]
["Year","Month","Area type","Area code","Metier Level 3","Metier Level 4","Metier Level 5","Metier Level 6","Vessel size range [m]","Monitoring program type ","Monitoring protocol ","Monitoring method","Bycatch species","Is cetacean","No. of specimens with pingers","No. of specimens without pingers","No. of incidents with pingers","No. of incidents without pingers","Are there numbers raised?","Bycatch rate with pingers","Bycatch rate without pingers","Total Bycatch Estimate","Coefficient of Variation [%]"]

{"sheet":"Selected Vocabularies","index":5,"n_rows":16,"n_cols":36,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
["Vocabulary references"]
[]
["WoRMS species names and codes","https://www.marinespecies.org/",null,null,"BYC_MonProgr","https://vocab.ices.dk/?ref=1500",null,"BYC_SamplingProtocol","https://vocab.ices.dk/?ref=1501",null,null,"Metier-3","https://vocab.ices.dk/?ref=1497",null,null,"BYC_PingerChar","https://vocab.ices.dk/?ref=1504",null,null,"BYC_Mon812Type","https://vocab.ices.dk/?ref=1505",null,"YesNoFields","https://vocab.ices.dk/?ref=316",null,"BYC_MonMethod","https://vocab.ices.dk/?ref=1533",null,"BYC_Mon812Type","http://vocab.ices.dk/?ref=1505",null,"AreaType","http://vocab.ices.dk/?CodeTypeRelID=1446&CodeID=169670"]
[null,null,null,null,"Monitoring Program Type",null,null,"SamplingProtocol",null,null,null,"Metier Level 3",null,null,null,"Pinger characteristics",null,null,null,"812 type of monitoring",null,null,"Is Cetacean",null,null,"Monitoring method",null,null,"Month",null,null,"AreaType",null,null,"Are these number raised"]
["EDMO organisation codes","https://vocab.ices.dk/?ref=1398",null,null,1,"Reg812",null,"Mammals","Marine mammals\n",null,null,"L3TB","Bottom trawls",null,null,1,"Type 1",null,null,"MS","Monitoring scheme",null,"Y","Yes",null,"EM","Eletronic Monitoring",null,1,1,null,"GFCM_GSAs","GFCM Geographical Subareas",null,"A","No -  unraised sub-sample data provided"]
[null,null,null,null,2,"DCF",null,"Cetaceans","Cetaceans",null,null,"L3DR","Dredges",null,null,2,"Type 2",null,null,"PMS","Pilot monitoring scheme",null,"N","No",null,"LB","Logbook",null,2,2,null,"ICESArea","ICES area 27",null,"B","No -  due to 100% coverage"]
["ISO_3166","https://vocab.ices.dk/?ref=337",null,null,3,"Reg812/DCF",null,"Seabirds","Seabirds",null,null,"L3LL","Longlines",null,null,3,"Other",null,null,"SS","Scientific studies",null,null,null,null,"OTH","Other ",null,3,3,null,"NAFOArea","NAFO area 21",null,"C","Yes - to observed trip level"]
[null,null,null,null,4,"Other",null,"Turtles","Sea Turtles",null,null,"L3GN","Nets",null,null,4,"DDD",null,null,null,null,null,null,null,null,"PO","Port observer",null,4,4]
[null,null,null,null,5,"Unknown",null,"Fish","Fish",null,null,"L3PT","Pelagic trawls",null,null,5,"MIX",null,null,null,null,null,null,null,null,"SO","At sea observer",null,5,5]
[null,null,null,null,6,"Research program",null,"Elasmobranchs","Elasmobranchs",null,null,"L3LH","Rod and lines",null,null,null,null,null,null,null,null,null,null,null,null,"VO","Vessel crew observer",null,6,6]
[null,null,null,null,7,"EU-MAP",null,"ProtectedSpecies","Protected Species",null,null,"L3SX","Seines",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,7]
[null,null,null,null,null,null,null,"Pinnipeds","Pinnipeds",null,null,"L3PS","Surrounding nets",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,8]
[null,null,null,null,null,null,null,"All","All",null,null,"L3FIX","Traps",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9,9]
[null,null,null,null,null,null,null,null,null,null,null,"L3NK","Other gear",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,10]
[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,null,11,11]
[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,null,12,12]