{"text_format":"3","workbook":"xlsx","n_sheets":4,"sheets":["MonthlyReport","Define diagnostic tests in use","Release notes","DataValidationValues"],"not_rendered":{"defined_names":12},"read":"whole","date_system":"1900"}

{"sheet":"MonthlyReport","index":0,"n_rows":64,"n_cols":9,"rows_kept":64,"merged":[[3,1,3,2],[3,4,11,8],[4,1,4,2],[5,1,5,2],[6,1,6,2],[7,1,7,2]]}
["Monthly laboratory report","Template version: ","3.1"]
[null,"Release date: ","2024-03-22"]
["Submitting laboratory details",{"$nulls":3},"Notes"]
["Name of reporting person",{"$nulls":3},"1. Only include results of submissions received during reporting month.\n2. Reports should be submitted within 30 days of the end of the reporting period.\n3. For each pathogen, results should be aggregated by country (England, Wales, Scotland or Unknown) with a separate row of results for each country.\n4. Submissions may contain samples from multiple individual animals from the same premises as part of the same disease investigation.\n5. Go to \"Define diagnostic tests in use\" sheet to define which tests are offered by your laboratory. There is currently no validation of spreadsheet data based on which tests are selected.\n6. PRRSV-2 and BVDV-2  (if differentiated from PRRSV-1 and BVDV-1, respectively) must not be included in this report but must be reported using the immediate reporting protocol.\n7. Changing data in a cell will not automatically highlight unvalidated cells; if the contents of one cell is changed, data in other cells on the same row should be re-entered to ensure data integrity."]
["Laboratory Name"]
["Laboratory Address"]
["Laboratory postcode"]
["Laboratory UKAS Accreditation Number (if available)"]
["Reporting period (enter month and year)"]
[]
[]
[]
["Monthly submission results"]
["Pathogen\n(Remember, PRRSV-2 and BVDV-2 - if differentiated from PRRSV-1 and BVDV-1, respectively - must not be included in this report but must be reported using the immediate reporting protocol.)","Disease","Species","Other species definition","Qualifying tests","Country (where samples were taken)","Total number of submissions where at least one qualifying test was undertaken\n(Please note, this is voluntary information)","Number of submissions with at least one sample testing as positive","Number of positive samples"]
[null,{"$f":"IF(A15=\"\",\"---\",VLOOKUP(A15,agent_condition_lut,2,FALSE))","v":"---"},null,null,{"$f":"IF(A15=\"\",\"---\",VLOOKUP(A15,agent_condition_lut,4,FALSE))","v":"---"}]
[null,"---",null,null,"---"]
[null,{"$f":"IF(A17=\"\",\"---\",VLOOKUP(A17,agent_condition_lut,2,FALSE))","v":"---"},null,null,{"$f":"IF(A17=\"\",\"---\",VLOOKUP(A17,agent_condition_lut,4,FALSE))","v":"---"}]
[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,"---",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,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,"---"]
[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,"---",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,null,"---"]

{"sheet":"Define diagnostic tests in use","index":1,"n_rows":31,"n_cols":7,"rows_kept":31,"merged":[[4,1,4,2]]}
["Define diagnostic tests in use"]
[]
["Only complete this sheet if range of tests (or UKAS accreditation) has changed since last monthly report"]
[]
["Disease","Diagnostic test"]
["Mycoplasma gallisepticum / M. meleagridis",null,"PCR","Test accreditation:","Not applicable",{"$f":"IF(AND(G6=TRUE,E6=\"Not applicable\"),\"Please enter test accreditation status\",IF(AND(G6=FALSE,E6<>\"Not applicable\"),\"Please enter test accreditation status as \"\"Not applicable\"\"\",\"\"))","v":""},false]
[null,null,"DGGE/PCR","Test accreditation:","Not applicable",{"$f":"IF(AND(G7=TRUE,E7=\"Not applicable\"),\"Please enter test accreditation status\",IF(AND(G7=FALSE,E7<>\"Not applicable\"),\"Please enter test accreditation status as \"\"Not applicable\"\"\",\"\"))","v":""},false]
[null,null,"Culture","Test accreditation:","Not applicable","",false]
["Campylobacter fetus subsp. venerealis",null,"Culture of Campylobacter foetus subsp venerealis","Test accreditation:","Not applicable",null,false]
["Bovine Virus Diarrhoea Virus 1 (BVDV-1) or BVDV (-1 and -2 not differentiated) ",null,"Antigen ELISA","Test accreditation:","Not applicable",null,false]
[null,null,"PCR differentiating BVDV-1 and BVDV-2 ","Test accreditation:","Not applicable",null,false]
[null,null,"PCR not differentiating BVDV-1 and BVDV-2","Test accreditation:","Not applicable",null,false]
[null,null,"Virus isolation","Test accreditation:","Not applicable",null,false]
[null,null,"Immunohistochemistry","Test accreditation:","Not applicable",null,false]
["Bovine Herpes Virus 1 (BHV1)",null,"PCR (including gE PCR)","Test accreditation:","Not applicable",null,false]
[null,null,"Virus isolation","Test accreditation:","Not applicable",null,false]
[null,null,"Immunohistochemistry","Test accreditation:","Not applicable",null,false]
[null,null,"FAT","Test accreditation:","Not applicable",null,false]
[null,null,"gE ELISA (used for cattle vaccinated with marker live vaccine)","Test accreditation:","Not applicable",null,false]
["Mycobacterium avium subsp. paratuberculosis (Map)",null,"PCR","Test accreditation:","Not applicable",null,false]
[null,null,"Histology","Test accreditation:","Not applicable",null,false]
[null,null,"ZN smear","Test accreditation:","Not applicable",null,false]
[null,null,"Liquid culture","Test accreditation:","Not applicable",null,false]
[null,null,"Indirect antibody ELISA","Test accreditation:","Not applicable",null,false]
[null,null,"Complement-fixation test","Test accreditation:","Not applicable",null,false]
["Porcine reproductive and respiratory syndrome virus - 1 (PRRSV-1) or PRRSV (-1 and -2 not differentiated) ",null,"PCR differentiating PRRSV-1 and PRRSV-2 ","Test accreditation:","Not applicable",null,false]
[null,null,"PCR not differentiating PRRSV-1 and PRRSV-2","Test accreditation:","Not applicable",null,false]
[null,null,"Virus isolation","Test accreditation:","Not applicable",null,false]
[null,null,"Immunohistochemistry","Test accreditation:","Not applicable",null,false]
["Tritrichomonas foetus",null,"Culture & microscopy of Tritrichomonas foetus","Test accreditation:","Not applicable",null,false]
[null,null,"PCR","Test accreditation:","Not applicable",null,false]

{"sheet":"Release notes","index":2,"n_rows":7,"n_cols":3,"rows_kept":7}
["Release notes for template"]
[]
["Date","Version","Changes"]
[null,"v1.0","Original draft sent out for review purposes but subsequently used by some labs to return results."]
["2021-06-30","v2.0","Unrecorded changes. Sent out 30 July 2021"]
["2022-02-14","v3.0","Included template version and release date cells.\nMinor correction to pathogens included for Avian mycoplasmosis on the 'Define diagnostic tests in use' sheet (M. synoviae was incorrectly listed instead of M. meleagridis)."]
["2024-03-22","v3.1","Corrected error where Campylobacter fetus subsp. veneralis had a capital 'V'.\nAdded 'Release notes' sheet."]

{"sheet":"DataValidationValues","index":3,"n_rows":55,"n_cols":6,"rows_kept":55,"hidden":true}
["Values used for data validation"]
[]
["agent_condition_lut named range",{"$nulls":4},"Test accreditation option list"]
["agent named range","condition named range","id","Qualifying diagnostic tests",null,"test_accreditation"]
["Mycoplasma gallisepticum / M. meleagridis","Avian mycoplasmosis",1,"PCR, DGGE/PCR , culture",null,"Not applicable"]
["Campylobacter fetus subsp. venerealis","Bovine genital campylobacteriosis",2,"Culture of Campylobacter foetus subsp venerealis",null,"Yes"]
["Bovine Virus Diarrhoea Virus 1 (BVDV-1) or BVDV (-1 and -2 not differentiated)","Bovine viral diarrhoea (BVD)",3,"Antigen ELISA,PCR,Virus isolation,immunohistochemistry",null,"No"]
["Bovine Herpes Virus 1 (BHV-1)","Infectious bovine rhinotracheitis (IBR) / Infectious pustular vulvovaginitis / Infectious balanoposthitis",4,"PCR (including gE PCR), Virus isolation, Immunohistochemistry, FAT, gE ELISA (used for cattle vaccinated with marker live vaccine)",null,"Unknown"]
["Mycobacterium avium subsp. paratuberculosis (Map)","Paratuberculosis (Johne's disease)",5,"PCR, Histology, ZN smear, Liquid culture, Indirect antibody ELISA, Complement Fixation Test"]
["Porcine reproductive and respiratory syndrome virus - 1 (PRRSV-1) or PRRSV (-1 and -2 not differentiated)","Porcine Reproductive and Respiratory Syndrome (PRRS)",6,"PCR, Virus isolation, immunohistochemistry"]
["Tritrichomonas foetus","Trichomonosis",7,"Culture & microscopy of Tritrichomonas foetus, PCR"]
[]
["Other spp definition string: "]
["Other (please specify)"]
[]
["species_condition named ranges"]
["condition_id","species"]
[1,"Chicken"]
[1,"Turkey"]
[1,{"$f":"A14","v":"Other (please specify)"}]
[2,"Domestic cattle"]
[2,"Bison"]
[2,"Buffalo"]
[2,{"$f":"A14","v":"Other (please specify)"}]
[3,"Domestic cattle"]
[3,"Bison"]
[3,"Buffalo"]
[3,{"$f":"A14","v":"Other (please specify)"}]
[4,"Domestic cattle"]
[4,"Bison"]
[4,"Buffalo"]
[4,{"$f":"A14","v":"Other (please specify)"}]
[5,"Domestic cattle"]
[5,"Sheep"]
[5,"Goat"]
[5,"Deer"]
[5,"Camelid"]
[5,"Bison"]
[5,"Buffalo"]
[5,{"$f":"A14","v":"Other (please specify)"}]
[6,"Domestic pig"]
[6,"Wild boar"]
[6,{"$f":"A14","v":"Other (please specify)"}]
[7,"Domestic cattle"]
[7,"Bison"]
[7,"Buffalo"]
[7,{"$f":"A14","v":"Other (please specify)"}]
[]
[]
["Country options"]
[]
["England"]
["Wales"]
["Scotland"]
["Unknown"]