{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["INSTRUCTIONS","Establishment details","Table 1","Table 2","Table 3","Lists"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":1,"defined_names":36,"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":"INSTRUCTIONS","index":0,"n_rows":42,"n_cols":1,"rows_kept":42,"cut":false,"hidden":false,"merged":[[0,0,0,3],[41,0,41,1],[2,0,2,3],[1,0,1,3]]}
["Additional Statistics on \nBreeding and Genotyping of Animals \nfor Scientific Procedures - 2017"]
["Instructions"]
["PLEASE ENSURE MACROS ARE ENABLED TO ENSURE THIS SPREADSHEET FUNCTIONS PROPERLY \n\n- If the security warning appears, please follow the instructions below (see step 1 for Windows users or step M for Mac users)\n- If no security warning appears, please continue to the next page\n\nYou will be asked to resubmit the form if macros have not been enabled\n\nIf you require assistance, contact ASRU Business Support Team at ROPReturns@homeoffice.gsi.gov.uk"]
[]
["    For Windows users (for Mac users, see below). Please note, this is an example and the macro message may not look exactly like this."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[" "]
[]
[]
["    For Mac users (for Windows users, see above). Please note, this is an example and the macro message may not look exactly like this."]
[]
["M) "]

{"sheet":"Establishment details","index":1,"n_rows":34,"n_cols":2,"rows_kept":34,"cut":false,"hidden":false,"merged":[[9,0,9,1],[13,0,13,1],[18,0,18,1],[0,0,0,1],[1,0,1,1]]}
["Additional statistics on breeding and genotyping of animals for scientific procedures"]
["Click here for guidance on how to complete this form"]
[]
["Reporting year",2017]
["Country","United Kingdom"]
["Serial Number (Home Office use only)"]
[]
["Date of form completion and return"]
[]
["Establishment details"]
["Name of Establishment"]
["Establishment PEL number (ASPeL)"]
[]
["Person responsible for Compliance"]
["Name"]
["Telephone number"]
["e-mail address"]
[]
["Person completing the form (if different from above)"]
["Name"]
["Telephone number"]
["e-mail address"]
[]
["Checks (0=empty)"]
[]
["Establishment details tab - tab empty",{"$f":"COUNTA(B20:B22,B15:B17,B11:B12,B8)","v":0}]
["Table 1 - tab empty",{"$f":"COUNTA('Table 1'!A7:E57)","v":0}]
["Table 2 - tab empty",{"$f":"COUNTA('Table 2'!A7:I57)","v":0}]
["Table 3 - tab empty",{"$f":"COUNTA('Table 3'!C6:C9)","v":0}]
["Entire workbook empty?",{"$f":"IF(AND(B26=0,B27=0,B28=0,B29=0),0,1)","v":0}]
[]
[]
["Compliance person - details empty",{"$f":"COUNTA(B15:B17)","v":0}]
["Person completing form - detail empty",{"$f":"COUNTA(B20:B22)","v":0}]

{"sheet":"Table 1","index":2,"n_rows":57,"n_cols":10,"rows_kept":57,"cut":false,"hidden":false,"merged":[[2,2,2,5],[4,2,4,5],[0,2,0,5],[4,0,4,1]]}
[null,null,"Click here for guidance on how to complete this form"]
["PEL Number"]
[{"$f":"IF('Establishment details'!B12=\"\",\"\",'Establishment details'!B12)","v":""},null,"TABLE 1 -  Annex I.C.2(i)"]
[]
["Time period covered:\nJanuary - December 2017",null,"Number of animals bred for scientific procedures that were killed/died without being used in procedures"]
["Species","Specify other","Total excluding those involved in creation or maintenance of a GA line","Genetically normal animals killed as a result of creation of a new GA line ","All animals (other than previously reported) killed for the maintenance of established GA lines ","Total\n(not in annual statistics reporting)",null,"Count","Row","Specify other species"]
[null,null,null,null,null,{"$f":"SUM(C7:E7)","v":0},null,{"$f":"COUNTA(A7:E7)","v":0},7,{"$f":"IF(OR(LEFT(A7,4)=\"[A35\",LEFT(A7,3)=\"[A7\",LEFT(A7,6)=\"[A10_2\",LEFT(A7,4)=\"[A12\",LEFT(A7,4)=\"[A25\",LEFT(A7,4)=\"[A27\",LEFT(A7,6)=\"[A29_2\",LEFT(A7,4)=\"[A33\"),1,0)","v":0}]
[null,null,null,null,null,{"$f":"SUM(C8:E8)","v":0},null,{"$f":"COUNTA(A8:E8)","v":0},8,{"$f":"IF(OR(LEFT(A8,4)=\"[A35\",LEFT(A8,3)=\"[A7\",LEFT(A8,6)=\"[A10_2\",LEFT(A8,4)=\"[A12\",LEFT(A8,4)=\"[A25\",LEFT(A8,4)=\"[A27\",LEFT(A8,6)=\"[A29_2\",LEFT(A8,4)=\"[A33\"),1,0)","v":0}]
[null,null,null,null,null,{"$f":"SUM(C9:E9)","v":0},null,0,9,0]
[null,null,null,null,null,0,null,0,10,0]
[null,null,null,null,null,0,null,0,11,0]
[null,null,null,null,null,0,null,0,12,0]
[null,null,null,null,null,0,null,0,13,0]
[null,null,null,null,null,0,null,0,14,0]
[null,null,null,null,null,0,null,0,15,0]
[null,null,null,null,null,0,null,0,16,0]
[null,null,null,null,null,0,null,0,17,0]
[null,null,null,null,null,0,null,0,18,0]
[null,null,null,null,null,0,null,0,19,0]
[null,null,null,null,null,0,null,0,20,0]
[null,null,null,null,null,0,null,0,21,0]
[null,null,null,null,null,0,null,0,22,0]
[null,null,null,null,null,0,null,0,23,0]
[null,null,null,null,null,0,null,0,24,0]
[null,null,null,null,null,0,null,0,25,0]
[null,null,null,null,null,0,null,0,26,0]
[null,null,null,null,null,0,null,0,27,0]
[null,null,null,null,null,0,null,0,28,0]
[null,null,null,null,null,0,null,0,29,0]
[null,null,null,null,null,0,null,0,30,0]
[null,null,null,null,null,0,null,0,31,0]
[null,null,null,null,null,0,null,0,32,0]
[null,null,null,null,null,0,null,0,33,0]
[null,null,null,null,null,0,null,0,34,0]
[null,null,null,null,null,0,null,0,35,0]
[null,null,null,null,null,0,null,0,36,0]
[null,null,null,null,null,0,null,0,37,0]
[null,null,null,null,null,0,null,0,38,0]
[null,null,null,null,null,0,null,0,39,0]
[null,null,null,null,null,0,null,0,40,0]
[null,null,null,null,null,0,null,0,41,0]
[null,null,null,null,null,0,null,0,42,0]
[null,null,null,null,null,0,null,0,43,0]
[null,null,null,null,null,0,null,0,44,0]
[null,null,null,null,null,0,null,0,45,0]
[null,null,null,null,null,0,null,0,46,0]
[null,null,null,null,null,0,null,0,47,0]
[null,null,null,null,null,0,null,0,48,0]
[null,null,null,null,null,0,null,0,49,0]
[null,null,null,null,null,0,null,0,50,0]
[null,null,null,null,null,0,null,0,51,0]
[null,null,null,null,null,0,null,0,52,0]
[null,null,null,null,null,0,null,0,53,0]
[null,null,null,null,null,0,null,0,54,0]
[null,null,null,null,null,0,null,0,55,0]
[null,null,null,null,null,0,null,0,56,0]
[null,null,null,null,null,0,null,{"$f":"COUNTA(A57:E57)","v":0},57,0]

{"sheet":"Table 2","index":3,"n_rows":57,"n_cols":14,"rows_kept":57,"cut":false,"hidden":false,"merged":[[4,2,4,8],[0,2,0,8],[2,2,2,8],[4,0,4,1]]}
[null,null,"Click here for guidance on how to complete this form"]
["PEL Number"]
[{"$f":"IF('Establishment details'!B12=\"\",\"\",'Establishment details'!B12)","v":""},null,"TABLE 2 - Annex I.D.3"]
[]
["Time period covered:\nJuly - December 2017",null,"Tissue sampling for the purpose of genotyping\n\nDo not report where tissue was removed for identification but not used for genotyping"]
["Species","Specify other","Number of animals","Re-sampling specifically for genotyping","Genotyping method used","Specify other","Severity of method","Invasive method","Surplus material from identification",null,"Count","Rows","Specify other species","Specify other method"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTA(A7:I7)","v":0},7,{"$f":"IF(OR(LEFT(A7,4)=\"[A35\",LEFT(A7,3)=\"[A7\",LEFT(A7,6)=\"[A10_2\",LEFT(A7,4)=\"[A12\",LEFT(A7,4)=\"[A25\",LEFT(A7,4)=\"[A27\",LEFT(A7,6)=\"[A29_2\",LEFT(A7,4)=\"[A33\"),1,0)","v":0},{"$f":"IF(E7=\"[M9] Other\",1,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTA(A8:I8)","v":0},8,{"$f":"IF(OR(LEFT(A8,4)=\"[A35\",LEFT(A8,3)=\"[A7\",LEFT(A8,6)=\"[A10_2\",LEFT(A8,4)=\"[A12\",LEFT(A8,4)=\"[A25\",LEFT(A8,4)=\"[A27\",LEFT(A8,6)=\"[A29_2\",LEFT(A8,4)=\"[A33\"),1,0)","v":0},{"$f":"IF(E8=\"[M9] Other\",1,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,0,9,0,0]
[null,null,null,null,null,null,null,null,null,null,0,10,0,0]
[null,null,null,null,null,null,null,null,null,null,0,11,0,0]
[null,null,null,null,null,null,null,null,null,null,0,12,0,0]
[null,null,null,null,null,null,null,null,null,null,0,13,0,0]
[null,null,null,null,null,null,null,null,null,null,0,14,0,0]
[null,null,null,null,null,null,null,null,null,null,0,15,0,0]
[null,null,null,null,null,null,null,null,null,null,0,16,0,0]
[null,null,null,null,null,null,null,null,null,null,0,17,0,0]
[null,null,null,null,null,null,null,null,null,null,0,18,0,0]
[null,null,null,null,null,null,null,null,null,null,0,19,0,0]
[null,null,null,null,null,null,null,null,null,null,0,20,0,0]
[null,null,null,null,null,null,null,null,null,null,0,21,0,0]
[null,null,null,null,null,null,null,null,null,null,0,22,0,0]
[null,null,null,null,null,null,null,null,null,null,0,23,0,0]
[null,null,null,null,null,null,null,null,null,null,0,24,0,0]
[null,null,null,null,null,null,null,null,null,null,0,25,0,0]
[null,null,null,null,null,null,null,null,null,null,0,26,0,0]
[null,null,null,null,null,null,null,null,null,null,0,27,0,0]
[null,null,null,null,null,null,null,null,null,null,0,28,0,0]
[null,null,null,null,null,null,null,null,null,null,0,29,0,0]
[null,null,null,null,null,null,null,null,null,null,0,30,0,0]
[null,null,null,null,null,null,null,null,null,null,0,31,0,0]
[null,null,null,null,null,null,null,null,null,null,0,32,0,0]
[null,null,null,null,null,null,null,null,null,null,0,33,0,0]
[null,null,null,null,null,null,null,null,null,null,0,34,0,0]
[null,null,null,null,null,null,null,null,null,null,0,35,0,0]
[null,null,null,null,null,null,null,null,null,null,0,36,0,0]
[null,null,null,null,null,null,null,null,null,null,0,37,0,0]
[null,null,null,null,null,null,null,null,null,null,0,38,0,0]
[null,null,null,null,null,null,null,null,null,null,0,39,0,0]
[null,null,null,null,null,null,null,null,null,null,0,40,0,0]
[null,null,null,null,null,null,null,null,null,null,0,41,0,0]
[null,null,null,null,null,null,null,null,null,null,0,42,0,0]
[null,null,null,null,null,null,null,null,null,null,0,43,0,0]
[null,null,null,null,null,null,null,null,null,null,0,44,0,0]
[null,null,null,null,null,null,null,null,null,null,0,45,0,0]
[null,null,null,null,null,null,null,null,null,null,0,46,0,0]
[null,null,null,null,null,null,null,null,null,null,0,47,0,0]
[null,null,null,null,null,null,null,null,null,null,0,48,0,0]
[null,null,null,null,null,null,null,null,null,null,0,49,0,0]
[null,null,null,null,null,null,null,null,null,null,0,50,0,0]
[null,null,null,null,null,null,null,null,null,null,0,51,0,0]
[null,null,null,null,null,null,null,null,null,null,0,52,0,0]
[null,null,null,null,null,null,null,null,null,null,0,53,0,0]
[null,null,null,null,null,null,null,null,null,null,0,54,0,0]
[null,null,null,null,null,null,null,null,null,null,0,55,0,0]
[null,null,null,null,null,null,null,null,null,null,0,56,0,0]
[null,null,null,null,null,null,null,null,null,null,0,57,0,0]

{"sheet":"Table 3","index":4,"n_rows":9,"n_cols":3,"rows_kept":9,"cut":false,"hidden":false,"merged":[[7,0,7,1],[8,0,8,1],[4,0,4,1],[5,0,5,1],[6,0,6,1]]}
[null,null,"Click here for guidance on how to complete this form"]
["PEL Number"]
[{"$f":"IF('Establishment details'!B12=\"\",\"\",'Establishment details'!B12)","v":""},null,"TABLE 3 - Comments on Annex I"]
[]
[null,null,"Refinement to genotyping methods during 2017"]
["Efforts being made to refine tissue sampling techniques for genotyping"]
["More severe techniques being replaced by less severe ones"]
["Other refinement efforts of specific techniques involved in GA production"]
["Results achieved so far"]

{"sheet":"Lists","index":5,"n_rows":40,"n_cols":5,"rows_kept":40,"cut":false,"hidden":true,"merged":[]}
["Species","YesNo","Method","Severity","Genotype"]
["[A34] Zebra fish (Danio rerio)","[Y] Yes","[M1] Tail tip","Sub-threshold","[G1] Not previously sampled for genotyping"]
["[A35] Other Fish (other Pisces)","[N] No","[M2] Ear notching","[SV1] Non-recovery","[G2] Previously sampled for genotyping"]
["[A1] Mice (Mus musculus)","Not applicable","[M3] Saliva","[SV2] Mild","[G3] Do not know if previously sampled for genotyping"]
["[A2] Rats (Rattus norvegicus)",null,"[M4] Hair/fur sample","[SV3] Moderate"]
["[A3] Guinea-Pigs (Cavia porcellus)",null,"[M5] Faeces","[SV4] Severe"]
["[A4] Hamsters (Syrian) (Mesocricetus auratus)",null,"[M6] Fin clip","Not applicable"]
["[A5] Hamsters (chinese) (Cricetulus griseus)",null,"[M7] Mucus sample"]
["[A6] Mongolian gerbil (Meriones unguiculatus)",null,"[M8] Toe removal"]
["[A7] Other Rodents (other Rodentia)",null,"[M10] Blood sample"]
["[A8] Rabbits (Oryctolagus cuniculus)",null,"[M9] Other"]
["[A9] Cats (Felis catus)"]
["[A10_1] Beagles (Canis lupus familiaris)"]
["[A10_2] Other dogs (Other Canis)"]
["[A11] Ferrets (Mustela putorius furo)"]
["[A12] Other carnivores (other Carnivora)"]
["[A13] Horses, donkeys & cross-breeds (Equidae)"]
["[A14] Pigs (Sus scrofa domesticus)"]
["[A15] Goats (Capra aegagrus hircus)"]
["[A16] Sheep (Ovis aries)"]
["[A17] Cattle (Bos primigenius)"]
["[A18] Prosimians (Prosimia)"]
["[A19] Marmoset and tamarins (eg. Callithrix jacchus)"]
["[A20] Cynomolgus monkey (Macaca fascicularis)"]
["[A21] Rhesus monkey (Macaca mulatta)"]
["[A22] Vervets Chlorocebus spp. (usually either pygerythrus or sabaeus)"]
["[A23] Baboons (Papio spp.)"]
["[A24] Squirrel monkey (eg. Saimiri sciureus)"]
["[A25_1] Other species of Old World Monkeys (Cercopithecoidea)"]
["[A25_2] Other species of New World Monkeys (Ceboidea)"]
["[A26] Apes (Hominoidea)"]
["[A27] Other Mammals (other Mammalia)"]
["[A28] Domestic fowl (Gallus gallus domesticus)",null,null," "]
["[A29_1] Quail (Coturnix coturnix)"]
["[A29_2] Other birds (other Aves)"]
["[A30] Reptiles (Reptilia)"]
["[A31] Rana (Rana temporaria and Rana pipiens)"]
["[A32] Xenopus (Xenopus laevis and Xenopus tropicalis)"]
["[A33] Other Amphibians (other Amphibia)"]
["[A36] Cephalopods (Cephalopoda)"]