{"text_format":"3","workbook":"xlsx","n_sheets":4,"sheets":["List of Active Vessels","Example","Vessel type","Species"],"not_rendered":{"images":1},"read":"whole","date_system":"1900"}

{"sheet":"List of Active Vessels","index":0,"n_rows":13,"n_cols":18,"rows_kept":13,"merged":[[9,2,9,3]]}
[null,"Resolution 10/08",null,"Concerning a record of active vessels fishing for tunas and swordfish"]
[{"$nulls":3},"in the IOTC area"]
[]
[null,"Reporting on active vessels"]
[]
[null,"Reporting deadline:",null,"15 of February every year"]
[]
["Date of reporting:  ",{"$nulls":4},"Note:","For the Main target species",{"$nulls":3},"Mandatory information"]
["Year reporting on:  ",{"$nulls":5},"report in priority the group",{"$nulls":3},"Mandatory information if available"]
["Reporting country:",{"$nulls":5},"Tropical tunas (AG01): Yellow fin/ big eye tuna",{"$nulls":3},"Mandatory information if any"]
[{"$nulls":6},"or the group (AG14): Albacore/Swordfish"]
[]
["IOTC Number","Vessel name","Registration number","IMO number","Previous flag","International radio call sign","Vessel type"," Length (LOA)","Gross tonnage (GT)","Name of owner","Address of owner","Name of operator","Address of operator","Name of charterer","Address of charterer","Main target species"," Period of authorisation FROM"," Period of authorisation TO"]

{"sheet":"Example","index":1,"n_rows":23,"n_cols":16,"rows_kept":23}
[]
[null,"Reporting on active vessels"]
[]
[]
["Field","Example","Guidance to fill in the report template"]
["IOTC Number",16854,"IOTC unique identifier for ships, it consists of a number of up to 6 digits",{"$nulls":12},"SWO"]
["Vessel name","Penmarch","Report name of vessel as stated in the fishing licence"]
["Registration number","BT8456","Report registration number as stated in the fishing licence"]
["IMO number (if available)","IMO-5304986","Unique identifier for ships, It consists of the three letters \"IMO\" followed by the seven-digit number "]
["Previous flag (if any)","France","Report name of flag country"]
["International radio call sign (if any)","FZ48","Report IRCS as stated in the fishing licence"]
["Vessel type","Purse Seine","Report the type of vessel using the IOTC Referential for type of vessel (sheet named \"Vessel type\")"]
[" Length (LOA)",48.5,"Report the length over all of the vessel as stated in the fishing licence"]
["Gross tonnage (GT)",1250,"Report the Gross tonnage of the vessel as stated in the fishing licence"]
["Name of owner","Alison","Report the full name of the owner"]
["Address of owner","84, Main Street, LE CONQUET","Report full adress: Street number, Street name, Province, Country"]
["Name of operator","Quenet","Report the full name of the operator"]
["Address of operator","138, House light Road, ","Report full adress: Street number, Street name, Province, Country"]
["Name of charterer","Baya","Report the full name of the charterer"]
["Address of charterer","74, Church Street, TRAOUR","Report full adress: Street number, Street name, Province, Country"]
["Main target species","YFT -Yellowfin tuna","Report the main target species or report the group of species"]
[" Period of licence_From","2011-02-01","Report the starting date of the fishing licence (Format dd/mm/yyyy)"]
[" Period of licence_To","2011-10-01","Report the end date of the fishing licence (Format dd/mm/yyyy)"]

{"sheet":"Vessel type","index":2,"n_rows":16,"n_cols":3,"rows_kept":16}
[]
[]
["VesselType","VesselType_english","VesselType_french"]
["BB","Pole and Line vessels","Canneurs"]
["CF","Cargo Freezer","Cargo frigorifique"]
["GI","Gill Netters","Filets maillants"]
["LB","Longliners-Pole and Line vessels","Palangriers-Canneurs"]
["LC","Longliners and Carrier vessels","Palangriers-Porteurs"]
["LI","Line vessels","Bateaux à ligne"]
["LL","Longliners","Palangriers"]
["MU","Multipurpose","Polivalent"]
["PS","Purse seiners","Senneurs à senne coulissante"]
["RT","Research-Training","Recherche-Formation"]
["SP","Supply vessel (purse seiners)","Bateau auxiliaire (senneurs)"]
["TW","Trawlers","Chalutiers"]
["UN","Unknown","Inconnu"]

{"sheet":"Species","index":3,"n_rows":211,"n_cols":6,"rows_kept":211}
["IOTC Species list"]
[]
["Species","TargetGrp - Species English","Species_e","Species_f","TargetGrp - Species English","TargetGrp - Species French"]
["AG00","UNKN","Unidentified tuna or tuna-like species","Thons ou espèces associées non identifiées",{"$f":"CONCATENATE(A5,\"-\",B5,\"-\",C5)","v":"AG01-TROP-Yellowfin tuna and bigeye tuna"},{"$f":"CONCATENATE(A4,\"-\",B4,\"-\",D4)","v":"AG00-UNKN-Thons ou espèces associées non identifiées"}]
["AG01","TROP","Yellowfin tuna and bigeye tuna","Albacore et patudo",{"$f":"CONCATENATE(A18,\"-\",B18,\"-\",C18)","v":"AG14-SWAL-Albacore, Swordfish"},"AG01-TROP-Albacore et patudo"]
["AG02","TROP","Juvenile yellowfin tuna and bigeye tuna","Juvenil albacore et patudo",{"$f":"CONCATENATE(A6,\"-\",B6,\"-\",C6)","v":"AG02-TROP-Juvenile yellowfin tuna and bigeye tuna"},"AG02-TROP-Juvenil albacore et patudo"]
["AG03","TROP","Yellowfin tuna, bigeye tuna and skipjack tuna","Albacore, patudo et listao","AG03-TROP-Yellowfin tuna, bigeye tuna and skipjack tuna","AG03-TROP-Albacore, patudo et listao"]
["AG04","TROP","Yellowfin tuna and skipjack tuna","Albacore et listao","AG04-TROP-Yellowfin tuna and skipjack tuna","AG04-TROP-Albacore et listao"]
["AG05","AGGR","Yellowfin tuna and swordfish","Albacore et espadon","AG05-AGGR-Yellowfin tuna and swordfish","AG05-AGGR-Albacore et espadon"]
["AG06","AGGR","Tropical tunas and/or swordfish","Thons tropicaux et/ou espadon","AG06-AGGR-Tropical tunas and/or swordfish","AG06-AGGR-Thons tropicaux et/ou espadon"]
["AG07","AGGR","Albacore tuna, Yellowfin tuna, Bigeye tuna,Skipjack tuna, swordfish, sailfish","Germon, Albacore, Patudo, Listao, Espadon, voilier","AG07-AGGR-Albacore tuna, Yellowfin tuna, Bigeye tuna,Skipjack tuna, swordfish, sailfish","AG07-AGGR-Germon, Albacore, Patudo, Listao, Espadon, voilier"]
["AG08","AGGR","Albacore tuna, Yellowfin tuna, Bigeye tuna, swordfish","Germon, Albacore, Patudo,  Espadon","AG08-AGGR-Albacore tuna, Yellowfin tuna, Bigeye tuna, swordfish","AG08-AGGR-Germon, Albacore, Patudo,  Espadon"]
["AG09","AGGR","Yellowfin tuna, Bigeye tuna, swordfish","Albacore, Patudo,  Espadon","AG09-AGGR-Yellowfin tuna, Bigeye tuna, swordfish","AG09-AGGR-Albacore, Patudo,  Espadon"]
["AG10","OTHR","Kawakawa & Frigate tuna & Bullet tuna","Thonine orientale & Auxide & Bonitou","AG10-OTHR-Kawakawa & Frigate tuna & Bullet tuna","AG10-OTHR-Thonine orientale & Auxide & Bonitou"]
["AG11","OTHR","Black marlin, blue marlin and striped marlin","Marlin rayé et makaires nca","AG11-OTHR-Black marlin, blue marlin and striped marlin","AG11-OTHR-Marlin rayé et makaires nca"]
["AG12","AGGR","Albacore tuna, Yellowfin tuna, Bigeye tuna,swordfish, sailfish","Germon, Albacore, Patudo, Espadon, voilier","AG12-AGGR-Albacore tuna, Yellowfin tuna, Bigeye tuna,swordfish, sailfish","AG12-AGGR-Germon, Albacore, Patudo, Espadon, voilier"]
["AG13","AGGR","Albacore tuna, Yellowfin tuna, Bigeye tuna, Skipjack tuna","Germon, Albacore, Patudo, Listao","AG13-AGGR-Albacore tuna, Yellowfin tuna, Bigeye tuna, Skipjack tuna","AG13-AGGR-Germon, Albacore, Patudo, Listao"]
["AG14","SWAL","Albacore, Swordfish","Germon, Espadon",{"$f":"CONCATENATE(A19,\"-\",B19,\"-\",C19)","v":"AG15-AGGR-Skipjack tuna, Swordfish "},"AG14-SWAL-Germon, Espadon"]
["AG15","AGGR","Skipjack tuna, Swordfish ","Listao, Espadon","AG16-TROP-Bigeye tuna, Skipjack tuna","AG15-AGGR-Listao, Espadon"]
["AG16","TROP","Bigeye tuna, Skipjack tuna","Patudo, Listao","AG17-AGGR-Albacore tuna, Yellowfin tuna, Bigeye tuna","AG16-TROP-Patudo, Listao"]
["AG17","AGGR","Albacore tuna, Yellowfin tuna, Bigeye tuna","Germon, Albacore, Patudo","AG18-AGGR-Tropical tunas, swordfish, Albacore","AG17-AGGR-Germon, Albacore, Patudo"]
["AG18","AGGR","Tropical tunas, swordfish, Albacore","Thons tropicaux, espadon, Germon","AG19-TROP-Bigeye, Yellowfin, Bluefin Tuna","AG18-AGGR-Thons tropicaux, espadon, Germon"]
["AG19","TROP","Bigeye, Yellowfin, Bluefin Tuna","Patudo, Albacore, Thon rouge du Sud","AG20-TROP-Bluefin Tuna and Skipjack","AG19-TROP-Patudo, Albacore, Thon rouge du Sud"]
["AG20","TROP","Bluefin Tuna and Skipjack","Thon Rouge et listao","AG21-AGGR-Swordfish and Sharks","AG20-TROP-Thon Rouge et listao"]
["AG21","AGGR","Swordfish and Sharks","Espadon et Requins","AG22-AGGR-Swordfish, sharks, tunas (not SBF)","AG21-AGGR-Espadon et Requins"]
["AG22","AGGR","Swordfish, sharks, tunas (not SBF)","Espadon, requins, thon ( pas de thon rouge)",{"$f":"CONCATENATE(A4,\"-\",B4,\"-\",C4)","v":"AG00-UNKN-Unidentified tuna or tuna-like species"},"AG22-AGGR-Espadon, requins, thon ( pas de thon rouge)"]
["ALB ","SWAL","Albacore","Germon",{"$f":"CONCATENATE(A27,\"-\",C27)","v":"ALB -Albacore"},{"$f":"CONCATENATE(A27,\"-\",D27)","v":"ALB -Germon"}]
["AML ","OTHR","Grey reef shark","Requin dagsit","AML -Grey reef shark","AML -Requin dagsit"]
["ANW ","OTHR","Angelfishes nei","Demoiselles nca","ANW -Angelfishes nei","ANW -Demoiselles nca"]
["BAR ","OTHR","Barracudas","Brochets de mer","BAR -Barracudas","BAR -Brochets de mer"]
["BET ","TROP","Bigeye tuna","Patudo","BET -Bigeye tuna","BET -Patudo"]
["BFT ","OTHR","Northern bluefin tuna","Thon rouge du Nord","BFT -Northern bluefin tuna","BFT -Thon rouge du Nord"]
["BIP ","OTHR","Striped bonito","Bonite oriental","BIP -Striped bonito","BIP -Bonite oriental"]
["BLM ","OTHR","Black marlin","Makaire noir","BLM -Black marlin","BLM -Makaire noir"]
["BON ","OTHR","Atlantic Bonito","Bonite","BON -Atlantic Bonito","BON -Bonite"]
["BSH ","OTHR","Blue shark","Peau bleue","BSH -Blue shark","BSH -Peau bleue"]
["BSK ","OTHR","Basking Sharks","pèlerin","BSK -Basking Sharks","BSK -pèlerin"]
["BUK ","OTHR","Butterfly kingfish","Thon papillon","BUK -Butterfly kingfish","BUK -Thon papillon"]
["BUM ","OTHR","Blue marlin","Makaire bleu","BUM -Blue marlin","BUM -Makaire bleu"]
["BXD ","OTHR","Alfonsino","béryx","BXD -Alfonsino","BXD -béryx"]
["CCL ","OTHR","Blacktip shark","Requin bordé","CCL -Blacktip shark","CCL -Requin bordé"]
["CCP ","OTHR","Sandbar shark","Requin gris","CCP -Sandbar shark","CCP -Requin gris"]
["COM ","OTHR","Narrow-barred Spanish mackerel","Thazard rayé indo-pacifique","COM -Narrow-barred Spanish mackerel","COM -Thazard rayé indo-pacifique"]
["DOL ","OTHR","Dolphin Fish","Coryphène commune","DOL -Dolphin Fish","DOL -Coryphène commune"]
["ESCL","OTHR","Black escolar","Escolier noir","ESCL-Black escolar","ESCL-Escolier noir"]
["FRI ","OTHR","Frigate tuna","Auxide","FRI -Frigate tuna","FRI -Auxide"]
["KAW ","OTHR","Kawakawa","Thonine orientale","KAW -Kawakawa","KAW -Thonine orientale"]
["KGX ","OTHR","Seerfishes nei","Thazards nca","KGX -Seerfishes nei","KGX -Thazards nca"]
["LAG ","OTHR","OPAH","OPAH","LAG -OPAH","LAG -OPAH"]
["LMA ","OTHR","Longfin mako","Petite taupe","LMA -Longfin mako","LMA -Petite taupe"]
["MAK ","OTHR","Mako sharks nei","Requin taupes nca","MAK -Mako sharks nei","MAK -Requin taupes nca"]
["MARL","OTHR","Marlins nei","Marlin rayé et makaires nca","MARL-Marlins nei","MARL-Marlin rayé et makaires nca"]
["MAZ ","OTHR","Horse mackerels","Horse mackerels","MAZ -Horse mackerels","MAZ -Horse mackerels"]
["MLS ","OTHR","Striped marlin","Marlin rayé","MLS -Striped marlin","MLS -Marlin rayé"]
["MOO ","OTHR","Moonfish","\tLuneur","MOO -Moonfish","MOO -\tLuneur"]
["OIL ","OTHR","Oilfish","Ruvet","OIL -Oilfish","OIL -Ruvet"]
["OTHR","OTHR","Fish other than IOTC species or sharks","Autres poissons (especes hors CTOI ou requins)","OTHR-Fish other than IOTC species or sharks","OTHR-Autres poissons (especes hors CTOI ou requins)"]
["POR ","OTHR","Porbeagle","\tRequin-taupe commun","POR -Porbeagle","POR -\tRequin-taupe commun"]
["SBF ","OTHR","Southern bluefin tuna","Thon rouge du Sud",{"$f":"CONCATENATE(A59,\"-\",C59)","v":"SBF -Southern bluefin tuna"},{"$f":"CONCATENATE(A59,\"-\",D59)","v":"SBF -Thon rouge du Sud"}]
["SCK ","OTHR","Kitefin shark","Squale liche","SCK -Kitefin shark","SCK -Squale liche"]
["SFA ","OTHR","I-P Sailfish","Voilier indo-pacifique","SFA -I-P Sailfish","SFA -Voilier indo-pacifique"]
["SKH ","OTHR","Sharks nei","Requins diverses","SKH -Sharks nei","SKH -Requins diverses"]
["SKHS","OTHR","Sharks finned (round weight)","Requins sans nageoires (poids vif)","SKHS-Sharks finned (round weight)","SKHS-Requins sans nageoires (poids vif)"]
["SKJ ","TROP","Skipjack tuna","Listao","SKJ -Skipjack tuna","SKJ -Listao"]
["SMA ","OTHR","Shortfin mako","Taupe bleue","SMA -Shortfin mako","SMA -Taupe bleue"]
["SPN ","OTHR","Hammerhead Shark NEI","Requins marteau nca","SPN -Hammerhead Shark NEI","SPN -Requins marteau nca"]
["SPZ ","OTHR","Smooth hammerhead","Requin marteau commun","SPZ -Smooth hammerhead","SPZ -Requin marteau commun"]
["SSP ","OTHR","Short-billed spearfish","Makaire à rostre court","SSP -Short-billed spearfish","SSP -Makaire à rostre court"]
["SWO ","SWAL","Swordfish","Espadon","SWO -Swordfish","SWO -Espadon"]
["THR ","OTHR","Thresher sharks nei","Renards de mer nca","THR -Thresher sharks nei","THR -Renards de mer nca"]
["TUN ","AGGR","Tunas nei","Thonidés nca","TUN -Tunas nei","TUN -Thonidés nca"]
["UNKN","UNKN","Unknown","Inconnu","UNKN-Unknown","UNKN-Inconnu"]
["WAH ","OTHR","Wahoo","Thazard-bâtard","WAH -Wahoo","WAH -Thazard-bâtard"]
["WHM ","OTHR","White marlin","Makaire Blanc","WHM -White marlin","WHM -Makaire Blanc"]
["YFT ","TROP","Yellowfin tuna","Albacore","YFT -Yellowfin tuna","YFT -Albacore"]
{"$rows_empty":47}
[null,"Australia","Australia"]
[null,"Bahamas","Belize"]
[null,"Belgium (EU)","China"]
[null,"Belize","Comoros"]
[null,"Bolivia","Eritrea"]
[null,"Cambodia","European Union"]
[null,"Canada","France"]
[null,"Cayman Islands","Guinea"]
[null,"China","India"]
[null,"Comoros","Indonesia"]
[null,"Cook Islands","Iran, Islamic Republic of"]
[null,"Costa Rica","Japan"]
[null,"Djibouti","Kenya"]
[null,"Egypt","Korea, Republic of"]
[null,"Equatorial Guinea","Madagascar"]
[null,"Eritrea","Malaysia"]
[null,"European Union","Maldives"]
[null,"Faeroe Islands","Mauritius"]
[null,"Fiji","Mozambique"]
[null,"France (EU)","Oman, Sultanate of"]
[null,"France (Territories)","Pakistan"]
[null,"Georgia","Philippines"]
[null,"Ghana","Senegal"]
[null,"Guinea","Seychelles"]
[null,"Guyana","Sierra Leone"]
[null,"Honduras","South Africa"]
[null,"Hungary (EU)","Sri Lanka"]
[null,"Iceland","Sudan"]
[null,"India","Tanzania"]
[null,"Indonesia","Thailand"]
[null,"Iran","United Kingdom"]
[null,"Italy (EU)","Vanuatu"]
[null,"Japan","Yemen"]
[null,"Jordan"]
[null,"Kenya",2011]
[null,"Kiribati",2012]
[null,"Korea_Republic of",2013]
[null,"Kuwait",2014]
[null,"Liberia",2015]
[null,"Lithuania",2016]
[null,"Madagascar",2017]
[null,"Malaysia",2018]
[null,"Maldives",2019]
[null,"Marshall Islands",2020]
[null,"Mauritius"]
[null,"Mongolia"]
[null,"Mozambique"]
[null,"Namibia"]
[null,"Netherlands"]
[null,"Netherlands Antilles"]
[null,"New Zealand"]
[null,"Nigeira"]
[null,"Oman"]
[null,"Pakistan"]
[null,"Palau"]
[null,"Panama"]
[null,"Papua New Guinea"]
[null,"Peru"]
[null,"Philippines"]
[null,"Portugal (EU)"]
[null,"Russian Federation"]
[null,"Saint Kitts and Nevis"]
[null,"Saint Vincent and Grenadines"]
[null,"San-Marino"]
[null,"Saudi Arabia"]
[null,"Senegal"]
[null,"Seychelles"]
[null,"Sierra Leone"]
[null,"Singapore"]
[null,"South Africa"]
[null,"Spain (EU)"]
[null,"Sri Lanka"]
[null,"Sudan"]
[null,"Taiwan Province of China"]
[null,"Tanzania"]
[null,"Thailand"]
[null,"Togo"]
[null,"Tonga"]
[null,"Turkey"]
[null,"Tuvalu"]
[null,"Ukraine "]
[null,"United Arab Emirates"]
[null,"United Kingdom (EU)"]
[null,"United Kingdom OT (BIOT)"]
[null,"United States"]
[null,"Unknown"]
[null,"Uruguay"]
[null,"Vanuatu"]
[null,"Yemen"]