{"text_format":"3","workbook":"xlsx","n_sheets":10,"sheets":["INSTRUCTIONS","1. PAYMENT","2. Contact & sample information","2a 20+ sample info","3. Species groups","4. Analytical Report","4a. 20+ Analytical Report","5. DAFM Enclosure","6. VAT Receipt","Data"],"not_rendered":{"images":6,"defined_names":11,"comments":1},"read":"whole","date_system":"1900"}

{"sheet":"INSTRUCTIONS","index":0,"n_rows":32,"n_cols":4,"rows_kept":32}
[]
[null,null,"Last updated: 04-12-17"]
[]
[]
[]
[]
[]
[null,null,"DNA ANALYSIS FORM\nINSTRUCTIONS FOR COMPLETION"]
[]
[null,"1)","Please ensure you use the most recent version of the form.  You can download the latest version from the Swift Ecology website here.  The date of the most recent update is given on the top left of the form.  You may need to enable editing once opened."]
[]
[null,null,"Please read and follow the instructions carefully, because the system has changed significantly"]
[]
[null,"2)","Complete Tab 1: Payment first (blue boxes only) otherwise later pages will not populate correctly.  Payment is required in advance, by credit/debit card online, or, if previously arranged, electronic bank transfer.  We are not able to take payments over the telephone."]
[]
[null,"3)","Once Tab 1 is complete and payment made, complete Tab 2: Contact and Sample information (blue boxes only).  If you have more than 20 samples continue onto Tab 2a."]
[]
[null,"4)","Once both tabs are fully completed, save the document using the Payment Reference Number as the filename, and email the entire document to dna@swiftecology.co.uk .  If paying by bank transfer (by arrangement only), also attach your bank’s confirmation of payment (or screenshot)."]
[]
[null,"5)","Provided payment has been received we will then issue your shipping label, processed form (including order/sample numbers and commercial document for customs), and VAT receipt, normally within 6 working hours."]
[]
[null,"6)","Mark the samples clearly with the full sample numbers. Eg  SEL1234-1. The full sample number will be provided by Swift Ecology along with your shipping label.   "]
[]
[null,"7)","Print Tab 2 and Tab 5 of the processed form and enclose with the samples.  Mark the envelope \"For research and diagnostic purposes\".","Tab 2"]
[{"$nulls":3},"Tab 5"]
[null,"8)","Samples must be dispatched within 2 working days of receipt of shipping label."]
[]
[null,null,"At busy times there may be delays so please contact us again only if you have not received a reply within one working day. "]
[]
[null,null,"By using the service you agree to abide by our\nTerms and Conditions."]
[]
[null,null,"Click here for FAQs"]

{"sheet":"1. PAYMENT","index":1,"n_rows":30,"n_cols":5,"rows_kept":30,"merged":[[0,0,0,4],[1,2,1,4],[2,2,2,4],[3,2,3,4],[4,2,4,4],[5,2,5,4],[6,2,6,4],[7,2,7,4],[8,1,8,4],[9,2,9,4],[10,2,10,4],[11,1,11,4],[12,1,12,2],[19,2,19,4],[20,2,20,4],[21,2,21,4],[26,2,26,4],[27,1,27,4],[28,1,28,4],[29,1,29,4]]}
[]
[null,"First Name"]
[null,"Last Name"]
[null,"Email"]
[null,"Phone"]
[null,"Company"]
[null,"Date of Payment (ddmmyy eg 021116)"]
[null,"Payment Reference Number",{"$f":"LEFT(C2,2)&LEFT(C3,2)&C7","v":""}]
[null,"If your business is non-commercial you may apply for a Swift Discount Code. More info in FAQs"]
[null,"If you already have a Swift Code, enter it here:"]
[null,"Please select service required (dropdown box)","CHOOSE"]
[null,"Click here to check whether Express service currently available"]
[null,"for more than 40 samples, please contact us",null,"Price each","Price "]
[null,"Quantity of Single Species Samples",null,{"$f":"IF(ISBLANK($C$10),(IF($C14>0,VLOOKUP($C$16,price,2),\"-\")),IF($C14>0,VLOOKUP($C$16,price,4),0))","v":"-"},{"$f":"IF(C14>0,C14*D14,\"-\")","v":"-"}]
[null,"Quantity of Multiple species samples (bats/small mammals only)",null,{"$f":"IF(ISBLANK($C$10),(IF($C15>0,VLOOKUP($C$16,price,3),\"-\")),IF($C15>0,VLOOKUP($C$16,price,5),0))","v":"-"},{"$f":"IF(C15>0,C15*D15,\"-\")","v":"-"}]
[null,"Total number of Samples (over 20 use both sample info sheets)",{"$f":"SUM(C14:C15)","v":0},"Sub Total:",{"$f":"SUM(E14:E15)","v":0}]
[null,"Charge for Express service (per sample)",null,{"$f":"IF(C11=\"Express\",20,0)","v":0},{"$f":"C16*D17","v":0}]
[null,"Sub Total",null,null,{"$f":"SUM(E16:E17)","v":0}]
[]
[null,"Country - Please select from dropdown box >>"]
[null,{"$f":"IF(OR(A23=3,A23=4),\"Are you VAT registered\",\" \")","v":{"$error":"#N/A"}},"Yes"]
[null,{"$f":"IF(AND(C21=\"Yes\",OR(A23=3,A23=4)),\"Please enter VAT Number:\",\" \")","v":{"$error":"#N/A"}}]
[{"$f":"VLOOKUP(C20,vatcarriagetable,2)","v":{"$error":"#N/A"}},{"$f":"LOOKUP(C20,country,Data!H25:H29)","v":{"$error":"#N/A"}},null,null,{"$f":"IF('1. PAYMENT'!A23=1,16.5,0)","v":{"$error":"#N/A"}}]
[null,"Total Ex VAT",null,null,{"$f":"E18+E23","v":{"$error":"#N/A"}}]
[]
[{"$f":"IF(OR($A$23=5,AND($A$23=3,$C$21=\"yes\"),AND($A$23=4,$C$21=\"yes\")),0,1)","v":{"$error":"#N/A"}},{"$f":"IF(A26=1,yesvat,novat)","v":{"$error":"#N/A"}},null,null,{"$f":"IF((OR((A26=1),(A26=2))),E24*0.2,0)","v":{"$error":"#N/A"}}]
[null,"your total to pay is",{"$f":"E24+E26","v":{"$error":"#N/A"}}]
[null,{"$f":"\"Card payments: Click here to pay £\"&TEXT(C27,\".00\")&\" quoting Payment Reference Number: \"&C8","v":{"$error":"#N/A"}}]
[null,"Bank transfer (by arrangement only): \nPay quoting Payment Reference Number and send bank payment confirmation to SEL with completed form. "]
[null,"For Guidance click here"]

{"sheet":"2. Contact & sample information","index":2,"n_rows":33,"n_cols":11,"rows_kept":33,"merged":[[0,0,0,10],[1,1,1,3],[1,7,1,9],[2,2,2,3],[2,5,2,6],[2,8,2,10],[3,2,3,3],[3,4,7,4],[3,5,3,6],[3,8,3,10],[4,2,4,3],[4,5,4,6],[4,8,4,10],[5,2,5,3],[5,5,5,6],[5,8,5,10],[6,2,6,3],[6,5,6,6],[6,8,6,10],[7,2,7,3],[7,5,7,6],[7,8,7,10],[8,3,9,6],[9,7,9,8],[10,6,10,8],[11,6,11,8],[12,6,12,8],[13,6,13,8],[14,6,14,8],[15,6,15,8],[16,6,16,8],[17,6,17,8],[18,6,18,8],[19,6,19,8],[20,6,20,8],[21,6,21,8],[22,6,22,8],[23,6,23,8],[24,6,24,8],[25,6,25,8],[26,6,26,8],[27,6,27,8],[28,6,28,8],[29,6,29,8],[30,6,30,8],[32,2,32,10]]}
[]
[null,"CONTACT/PAYMENT INFORMATION",null,null,"Ord No.",null,null,"Additional Copies of Report to:"]
[null,"Name (sender)",{"$f":"'1. PAYMENT'!C2&\" \"&'1. PAYMENT'!C3","v":" "},null,"Company",{"$f":"'1. PAYMENT'!C6","v":0},null,"Name"]
[null,"Address",null,null,"Invoice Address (amend if different)",{"$f":"C4","v":0},null,"Email"]
[{"$nulls":5},{"$f":"C5","v":0},null,"Name"]
[{"$nulls":5},0,null,"Email"]
[{"$nulls":5},0,null,"Name"]
[null,"Postcode",{"$nulls":3},0,null,"Email"]
[null,"Sample weight",null,{"$f":"'1. PAYMENT'!C11&\" Service\"","v":"CHOOSE Service"},{"$nulls":3},"Date of dispatch",null,"Payment Ref Number:",{"$f":"'1. PAYMENT'!C8","v":""}]
[null,"Weight if other",{"$nulls":5},"Samples must be sent within 2 working days of this date",null,"Total no. samples",{"$f":"'1. PAYMENT'!C16","v":0}]
[null,"Sample\nNumber","Single or mixed species sample","Type","Date collected","Site postcode/ post town ","Site description / comments (Optional)",null,null,"Species Group (see tab 3)","Suspected identity of species "]
[1,{"$f":"IF(A12<=$K$10,\"SEL\"&$F$2&\"-\"&A12,\" \")","v":" "},{"$f":"IF('1. PAYMENT'!$C$14>=A12,\"single\",\"mixed\")","v":"mixed"}]
[2," ",{"$f":"IF('1. PAYMENT'!$C$14>=A13,\"single\",\"mixed\")","v":"mixed"}]
[3," ",{"$f":"IF('1. PAYMENT'!$C$14>=A14,\"single\",\"mixed\")","v":"mixed"}]
[4," ",{"$f":"IF('1. PAYMENT'!$C$14>=A15,\"single\",\"mixed\")","v":"mixed"}]
[5," ",{"$f":"IF('1. PAYMENT'!$C$14>=A16,\"single\",\"mixed\")","v":"mixed"}]
[6," ",{"$f":"IF('1. PAYMENT'!$C$14>=A17,\"single\",\"mixed\")","v":"mixed"}]
[7," ",{"$f":"IF('1. PAYMENT'!$C$14>=A18,\"single\",\"mixed\")","v":"mixed"}]
[8," ",{"$f":"IF('1. PAYMENT'!$C$14>=A19,\"single\",\"mixed\")","v":"mixed"}]
[9," ",{"$f":"IF('1. PAYMENT'!$C$14>=A20,\"single\",\"mixed\")","v":"mixed"}]
[10," ",{"$f":"IF('1. PAYMENT'!$C$14>=A21,\"single\",\"mixed\")","v":"mixed"}]
[11," ",{"$f":"IF('1. PAYMENT'!$C$14>=A22,\"single\",\"mixed\")","v":"mixed"}]
[12," ",{"$f":"IF('1. PAYMENT'!$C$14>=A23,\"single\",\"mixed\")","v":"mixed"}]
[13," ",{"$f":"IF('1. PAYMENT'!$C$14>=A24,\"single\",\"mixed\")","v":"mixed"}]
[14," ",{"$f":"IF('1. PAYMENT'!$C$14>=A25,\"single\",\"mixed\")","v":"mixed"}]
[15," ",{"$f":"IF('1. PAYMENT'!$C$14>=A26,\"single\",\"mixed\")","v":"mixed"}]
[16," ",{"$f":"IF('1. PAYMENT'!$C$14>=A27,\"single\",\"mixed\")","v":"mixed"}]
[17," ",{"$f":"IF('1. PAYMENT'!$C$14>=A28,\"single\",\"mixed\")","v":"mixed"}]
[18," ",{"$f":"IF('1. PAYMENT'!$C$14>=A29,\"single\",\"mixed\")","v":"mixed"}]
[19," ",{"$f":"IF('1. PAYMENT'!$C$14>=A30,\"single\",\"mixed\")","v":"mixed"}]
[20," ",{"$f":"IF('1. PAYMENT'!$C$14>=A31,\"single\",\"mixed\")","v":"mixed"}]
[]
[null,"Shipped to:","Dr Peter Turner, Room B04, Dept. Chemical and Life Science, Waterford Institute of Technology, Cork Rd, Waterford, Ireland."]

{"sheet":"2a 20+ sample info","index":3,"n_rows":28,"n_cols":11,"rows_kept":28,"merged":[[0,0,0,10],[1,1,1,3],[1,7,2,10],[2,2,2,3],[2,5,2,6],[3,1,4,4],[4,7,4,8],[5,6,5,8],[6,6,6,8],[7,6,7,8],[8,6,8,8],[9,6,9,8],[10,6,10,8],[11,6,11,8],[12,6,12,8],[13,6,13,8],[14,6,14,8],[15,6,15,8],[16,6,16,8],[17,6,17,8],[18,6,18,8],[19,6,19,8],[20,6,20,8],[21,6,21,8],[22,6,22,8],[23,6,23,8],[24,6,24,8],[25,6,25,8],[27,2,27,10]]}
["For additional samples"]
[null,"CONTACT/PAYMENT INFORMATION",null,null,"Ord No.",{"$f":"'2. Contact & sample information'!F2&\"A\"","v":"A"}]
[null,"Name (sender)",{"$f":"'2. Contact & sample information'!C3:D3","v":" "},null,"Company",{"$f":"'1. PAYMENT'!C6","v":0}]
[null,{"$f":"'1. PAYMENT'!C11&\" Service\"","v":"CHOOSE Service"},{"$nulls":7},"Payment Ref Number:",{"$f":"'2. Contact & sample information'!K9","v":""}]
[{"$nulls":9},"Total no. samples",{"$f":"'1. PAYMENT'!C16","v":0}]
[null,"Sample\nNumber","Single or mixed species sample","Type","Date collected","Location OR Grid Ref","Site description / comments (optional)",null,null,"Species Group (see tab 3)","Suspected identity of species "]
[21,{"$f":"IF(A7<=$K$5,\"SEL\"&'2. Contact & sample information'!$F$2&\"-\"&A7,\" \")","v":" "},{"$f":"IF('1. PAYMENT'!$C$10>=A7,\"single\",\"mixed\")","v":"mixed"}]
[22,{"$f":"IF(A8<=$K$5,\"SEL\"&'2. Contact & sample information'!$F$2&\"-\"&A8,\" \")","v":" "},{"$f":"IF('1. PAYMENT'!$C$10>=A8,\"single\",\"mixed\")","v":"mixed"}]
[23,{"$f":"IF(A9<=$K$5,\"SEL\"&'2. Contact & sample information'!$F$2&\"-\"&A9,\" \")","v":" "},{"$f":"IF('1. PAYMENT'!$C$10>=A9,\"single\",\"mixed\")","v":"mixed"}]
[24,{"$f":"IF(A10<=$K$5,\"SEL\"&'2. Contact & sample information'!$F$2&\"-\"&A10,\" \")","v":" "},{"$f":"IF('1. PAYMENT'!$C$10>=A10,\"single\",\"mixed\")","v":"mixed"}]
[25,{"$f":"IF(A11<=$K$5,\"SEL\"&'2. Contact & sample information'!$F$2&\"-\"&A11,\" \")","v":" "},{"$f":"IF('1. PAYMENT'!$C$10>=A11,\"single\",\"mixed\")","v":"mixed"}]
[26,{"$f":"IF(A12<=$K$5,\"SEL\"&'2. Contact & sample information'!$F$2&\"-\"&A12,\" \")","v":" "},{"$f":"IF('1. PAYMENT'!$C$10>=A12,\"single\",\"mixed\")","v":"mixed"}]
[27,{"$f":"IF(A13<=$K$5,\"SEL\"&'2. Contact & sample information'!$F$2&\"-\"&A13,\" \")","v":" "},{"$f":"IF('1. PAYMENT'!$C$10>=A13,\"single\",\"mixed\")","v":"mixed"}]
[28,{"$f":"IF(A14<=$K$5,\"SEL\"&'2. Contact & sample information'!$F$2&\"-\"&A14,\" \")","v":" "},{"$f":"IF('1. PAYMENT'!$C$10>=A14,\"single\",\"mixed\")","v":"mixed"}]
[29,{"$f":"IF(A15<=$K$5,\"SEL\"&'2. Contact & sample information'!$F$2&\"-\"&A15,\" \")","v":" "},{"$f":"IF('1. PAYMENT'!$C$10>=A15,\"single\",\"mixed\")","v":"mixed"}]
[30,{"$f":"IF(A16<=$K$5,\"SEL\"&'2. Contact & sample information'!$F$2&\"-\"&A16,\" \")","v":" "},{"$f":"IF('1. PAYMENT'!$C$10>=A16,\"single\",\"mixed\")","v":"mixed"}]
[31,{"$f":"IF(A17<=$K$5,\"SEL\"&'2. Contact & sample information'!$F$2&\"-\"&A17,\" \")","v":" "},{"$f":"IF('1. PAYMENT'!$C$10>=A17,\"single\",\"mixed\")","v":"mixed"}]
[32,{"$f":"IF(A18<=$K$5,\"SEL\"&'2. Contact & sample information'!$F$2&\"-\"&A18,\" \")","v":" "},{"$f":"IF('1. PAYMENT'!$C$10>=A18,\"single\",\"mixed\")","v":"mixed"}]
[33,{"$f":"IF(A19<=$K$5,\"SEL\"&'2. Contact & sample information'!$F$2&\"-\"&A19,\" \")","v":" "},{"$f":"IF('1. PAYMENT'!$C$10>=A19,\"single\",\"mixed\")","v":"mixed"}]
[34,{"$f":"IF(A20<=$K$5,\"SEL\"&'2. Contact & sample information'!$F$2&\"-\"&A20,\" \")","v":" "},{"$f":"IF('1. PAYMENT'!$C$10>=A20,\"single\",\"mixed\")","v":"mixed"}]
[35,{"$f":"IF(A21<=$K$5,\"SEL\"&'2. Contact & sample information'!$F$2&\"-\"&A21,\" \")","v":" "},{"$f":"IF('1. PAYMENT'!$C$10>=A21,\"single\",\"mixed\")","v":"mixed"}]
[36,{"$f":"IF(A22<=$K$5,\"SEL\"&'2. Contact & sample information'!$F$2&\"-\"&A22,\" \")","v":" "},{"$f":"IF('1. PAYMENT'!$C$10>=A22,\"single\",\"mixed\")","v":"mixed"}]
[37,{"$f":"IF(A23<=$K$5,\"SEL\"&'2. Contact & sample information'!$F$2&\"-\"&A23,\" \")","v":" "},{"$f":"IF('1. PAYMENT'!$C$10>=A23,\"single\",\"mixed\")","v":"mixed"}]
[38,{"$f":"IF(A24<=$K$5,\"SEL\"&'2. Contact & sample information'!$F$2&\"-\"&A24,\" \")","v":" "},{"$f":"IF('1. PAYMENT'!$C$10>=A24,\"single\",\"mixed\")","v":"mixed"}]
[39,{"$f":"IF(A25<=$K$5,\"SEL\"&'2. Contact & sample information'!$F$2&\"-\"&A25,\" \")","v":" "},{"$f":"IF('1. PAYMENT'!$C$10>=A25,\"single\",\"mixed\")","v":"mixed"}]
[40,{"$f":"IF(A26<=$K$5,\"SEL\"&'2. Contact & sample information'!$F$2&\"-\"&A26,\" \")","v":" "},{"$f":"IF('1. PAYMENT'!$C$10>=A26,\"single\",\"mixed\")","v":"mixed"}]
[]
[null,"Shipped to:","Dr Peter Turner, Room B04, Dept. Chemical and Life Science, Waterford Institute of Technology, Cork Rd, Waterford, Ireland."]

{"sheet":"3. Species groups","index":4,"n_rows":25,"n_cols":12,"rows_kept":25,"merged":[[0,1,0,12],[1,4,1,5],[1,7,1,8],[1,10,1,11],[18,10,18,11],[21,1,23,4]]}
[null,"Species Groups"]
[null,"Group A. Carnivores.",null,null,"Group B. Small mammals.",null,null,"Group C. Bats.",null,null,"Group D. Other mammals"]
[null,"Wildcat*","Felis sylvestris",null,"Water shrew","Neomys fodiens",null,"Greater horseshoe bat","Rhinolophus ferrumequinum",null,"Red squirrel","Sciurus vulgaris"]
[null,"Red fox","Vulpes vulpes",null,"Common shrew","Sorex araneus",null,"Lesser horseshoe bat","Rhinolophus hipposideros",null,"Grey squirrel","Sciurus carolinensis"]
[null,"Otter","Lutra lutra",null,"Pygmy shrew","Sorex minutus",null,"Western barbastelle","Barbastella barbastellus",null,"European hedgehog","Erinaceus europaeus"]
[null,"Pine marten","Martes martes",null,"French shrew","Sorex coronatus",null,"Serotine","Eptesicus serotinus",null,"European hare","Lepus europaeus"]
[null,"Badger","Meles meles",null,"Lesser white toothed shrew","Crocidura suaveolens",null,"Alcathoe bat","Myotis alcathoe",null,"Mountain/Irish hare","Lepus timidus"]
[null,"Stoat","Mustela erminea",null,"Greater white toothed shrew","Crocidura russula",null,"Bechstein's bat","Myotis bechsteinii",null,"Fallow deer","Dama dama"]
[null,"Weasel","Mustela nivalis",null,"European water vole","Arvicola amphibius",null,"Brandt's bat","Myotis brandtii",null,"Red deer","Cervus elaphus"]
[null,"Polecat*","Mustela putorius",null,"Bank vole","Myodes glareolus",null,"Daubenton's bat","Myotis daubentonii",null,"Sika deer","Cervus nippon"]
[{"$nulls":4},"Field vole","Microtus agrestis",null,"Mouse-eared bat","Myotis myotis",null,"Roe deer","Capreolus capreolus"]
[{"$nulls":4},"Common vole","Microtus arvalis",null,"Whiskered bat","Myotis mystacinus",null,"Muntjac","Muntiacus reevesi"]
[{"$nulls":4},"Yellow-necked mouse","Apodemus flavicollis",null,"Natterer's bat","Myotis nattereri",null,"Chinese water deer","Hydropotes inermis"]
[{"$nulls":4},"Wood mouse","Apodemus sylvaticus",null,"Leisler's bat (Lesser noctule)","Nyctalus leisleri",null,"Edible dormouse","Glis glis"]
[{"$nulls":4},"Harvest mouse","Micromys minutus",null,"Noctule bat","Nyctalus noctula",null,"Mole","Talpa europaea"]
[{"$nulls":4},"House mouse","Mus musculus",null,"Nathusius's pipistrelle","Pipistrellus nathusii",null,"Wild boar*","Sus scrofa"]
[{"$nulls":4},"Brown rat","Rattus norvegicus",null,"Common pipistrelle","Pipistrellus pipistrellus",null,"Beaver","Castor fiber"]
[{"$nulls":4},"Black rat","Rattus rattus",null,"Soprano pipistrelle","Pipistrellus pygmaeus"]
[{"$nulls":4},"Hazel dormouse","Muscardinus avellanarius",null,"Brown long-eared bat","Plecotus auritus",null,"Group E. Owls"]
[{"$nulls":7},"Grey long-eared bat","Plecotus austriacus",null,"Barn owl","Tyto alba"]
[{"$nulls":10},"Snowy owl","Bubo scandiacus"]
[null,"*Mitochondrial DNA sequences from these species may be indistinguishable from those of domestic congeners (e.g. cats, ferrets and pigs)",{"$nulls":8},"Tawny owl","Strix aluco"]
[{"$nulls":10},"Little owl","Athene noctua"]
[{"$nulls":10},"Long-eared owl","Asio otus"]
[{"$nulls":10},"Short-eared owl","Asio flammeus"]

{"sheet":"4. Analytical Report","index":5,"n_rows":26,"n_cols":15,"rows_kept":26,"merged":[[0,0,0,14],[1,1,1,2],[1,3,1,6],[1,7,1,8],[1,10,3,14],[2,1,2,2],[2,3,3,4],[2,5,3,6],[2,7,3,8],[2,9,3,9],[3,0,3,2],[4,0,5,0],[4,1,5,1],[4,2,5,2],[4,3,4,4],[4,5,5,7],[4,8,5,9],[4,10,4,11],[4,12,4,14],[5,3,5,4],[6,3,6,4],[6,5,6,7],[6,8,6,9],[7,3,7,4],[7,5,7,7],[7,8,7,9],[8,3,8,4],[8,5,8,7],[8,8,8,9],[9,3,9,4],[9,5,9,7],[9,8,9,9],[10,3,10,4],[10,5,10,7],[10,8,10,9],[11,3,11,4],[11,5,11,7],[11,8,11,9],[12,3,12,4],[12,5,12,7],[12,8,12,9],[13,3,13,4],[13,5,13,7],[13,8,13,9],[14,3,14,4],[14,5,14,7],[14,8,14,9],[15,3,15,4],[15,5,15,7],[15,8,15,9],[16,3,16,4],[16,5,16,7],[16,8,16,9],[17,3,17,4],[17,5,17,7],[17,8,17,9],[18,3,18,4],[18,5,18,7],[18,8,18,9],[19,3,19,4],[19,5,19,7],[19,8,19,9],[20,3,20,4],[20,5,20,7],[20,8,20,9],[21,3,21,4],[21,5,21,7],[21,8,21,9],[22,3,22,4],[22,5,22,7],[22,8,22,9],[23,3,23,4],[23,5,23,7],[23,8,23,9],[24,3,24,4],[24,5,24,7],[24,8,24,9],[25,3,25,4],[25,5,25,7],[25,8,25,9]]}
["FOR LABORATORY USE ONLY"]
["Company",{"$f":"'1. PAYMENT'!C6","v":0},null,"POSITIVE CONTROL SAMPLE",{"$nulls":3},"Report date to SEL",null,"Author","COMMENTS"]
["Date ",{"$f":"'1. PAYMENT'!C7","v":0}]
["SAMPLES"]
["SAMPLE NUMBER","Group","Suspected identity of sample\n","DNA EXTRACT",null,"SPECIES",null,null,"COMMENTS",null,"qPCR",null,"Sequencing"]
[{"$nulls":3},"code",{"$nulls":6},"primers","Ct","primers","match%","bases"]
[{"$f":"'2. Contact & sample information'!B12","v":" "},{"$f":"'2. Contact & sample information'!J12","v":0},{"$f":"'2. Contact & sample information'!K12","v":0}]
[{"$f":"'2. Contact & sample information'!B13","v":" "},{"$f":"'2. Contact & sample information'!J13","v":0},{"$f":"'2. Contact & sample information'!K13","v":0}]
[{"$f":"'2. Contact & sample information'!B14","v":" "},{"$f":"'2. Contact & sample information'!J14","v":0},{"$f":"'2. Contact & sample information'!K14","v":0}]
[{"$f":"'2. Contact & sample information'!B15","v":" "},{"$f":"'2. Contact & sample information'!J15","v":0},{"$f":"'2. Contact & sample information'!K15","v":0}]
[{"$f":"'2. Contact & sample information'!B16","v":" "},{"$f":"'2. Contact & sample information'!J16","v":0},{"$f":"'2. Contact & sample information'!K16","v":0}]
[{"$f":"'2. Contact & sample information'!B17","v":" "},{"$f":"'2. Contact & sample information'!J17","v":0},{"$f":"'2. Contact & sample information'!K17","v":0}]
[{"$f":"'2. Contact & sample information'!B18","v":" "},{"$f":"'2. Contact & sample information'!J18","v":0},{"$f":"'2. Contact & sample information'!K18","v":0}]
[{"$f":"'2. Contact & sample information'!B19","v":" "},{"$f":"'2. Contact & sample information'!J19","v":0},{"$f":"'2. Contact & sample information'!K19","v":0}]
[{"$f":"'2. Contact & sample information'!B20","v":" "},{"$f":"'2. Contact & sample information'!J20","v":0},{"$f":"'2. Contact & sample information'!K20","v":0}]
[{"$f":"'2. Contact & sample information'!B21","v":" "},{"$f":"'2. Contact & sample information'!J21","v":0},{"$f":"'2. Contact & sample information'!K21","v":0}]
[{"$f":"'2. Contact & sample information'!B22","v":" "},{"$f":"'2. Contact & sample information'!J22","v":0},{"$f":"'2. Contact & sample information'!K22","v":0}]
[{"$f":"'2. Contact & sample information'!B23","v":" "},{"$f":"'2. Contact & sample information'!J23","v":0},{"$f":"'2. Contact & sample information'!K23","v":0}]
[{"$f":"'2. Contact & sample information'!B24","v":" "},{"$f":"'2. Contact & sample information'!J24","v":0},{"$f":"'2. Contact & sample information'!K24","v":0}]
[{"$f":"'2. Contact & sample information'!B25","v":" "},{"$f":"'2. Contact & sample information'!J25","v":0},{"$f":"'2. Contact & sample information'!K25","v":0}]
[{"$f":"'2. Contact & sample information'!B26","v":" "},{"$f":"'2. Contact & sample information'!J26","v":0},{"$f":"'2. Contact & sample information'!K26","v":0}]
[{"$f":"'2. Contact & sample information'!B27","v":" "},{"$f":"'2. Contact & sample information'!J27","v":0},{"$f":"'2. Contact & sample information'!K27","v":0}]
[{"$f":"'2. Contact & sample information'!B28","v":" "},{"$f":"'2. Contact & sample information'!J28","v":0},{"$f":"'2. Contact & sample information'!K28","v":0}]
[{"$f":"'2. Contact & sample information'!B29","v":" "},{"$f":"'2. Contact & sample information'!J29","v":0},{"$f":"'2. Contact & sample information'!K29","v":0}]
[{"$f":"'2. Contact & sample information'!B30","v":" "},{"$f":"'2. Contact & sample information'!J30","v":0},{"$f":"'2. Contact & sample information'!K30","v":0}]
[{"$f":"'2. Contact & sample information'!B31","v":" "},{"$f":"'2. Contact & sample information'!J31","v":0},{"$f":"'2. Contact & sample information'!K31","v":0}]

{"sheet":"4a. 20+ Analytical Report","index":6,"n_rows":26,"n_cols":15,"rows_kept":26,"merged":[[0,0,0,14],[1,1,1,2],[1,3,1,6],[1,7,1,8],[1,10,3,14],[2,1,2,2],[2,3,3,4],[2,5,3,6],[2,7,3,8],[2,9,3,9],[3,0,3,2],[4,0,5,0],[4,1,5,1],[4,2,5,2],[4,3,4,4],[4,5,5,7],[4,8,5,9],[4,10,4,11],[4,12,4,14],[5,3,5,4],[6,3,6,4],[6,5,6,7],[6,8,6,9],[7,3,7,4],[7,5,7,7],[7,8,7,9],[8,3,8,4],[8,5,8,7],[8,8,8,9],[9,3,9,4],[9,5,9,7],[9,8,9,9],[10,3,10,4],[10,5,10,7],[10,8,10,9],[11,3,11,4],[11,5,11,7],[11,8,11,9],[12,3,12,4],[12,5,12,7],[12,8,12,9],[13,3,13,4],[13,5,13,7],[13,8,13,9],[14,3,14,4],[14,5,14,7],[14,8,14,9],[15,3,15,4],[15,5,15,7],[15,8,15,9],[16,3,16,4],[16,5,16,7],[16,8,16,9],[17,3,17,4],[17,5,17,7],[17,8,17,9],[18,3,18,4],[18,5,18,7],[18,8,18,9],[19,3,19,4],[19,5,19,7],[19,8,19,9],[20,3,20,4],[20,5,20,7],[20,8,20,9],[21,3,21,4],[21,5,21,7],[21,8,21,9],[22,3,22,4],[22,5,22,7],[22,8,22,9],[23,3,23,4],[23,5,23,7],[23,8,23,9],[24,3,24,4],[24,5,24,7],[24,8,24,9],[25,3,25,4],[25,5,25,7],[25,8,25,9]]}
["FOR LABORATORY USE ONLY\nPage 2"]
["Company",{"$f":"'1. PAYMENT'!C6","v":0},null,"POSITIVE CONTROL SAMPLE",{"$nulls":3},"Report date to SEL",null,"Author","COMMENTS"]
["Date ",{"$f":"'4. Analytical Report'!B3:C3","v":"00:00:00"}]
["SAMPLES"]
["SAMPLE NUMBER","Group","Suspected identity of sample\n","DNA EXTRACT",null,"SPECIES",null,null,"COMMENTS",null,"qPCR",null,"Sequencing"]
[{"$nulls":3},"code",{"$nulls":6},"primers","Ct","primers","match%","bases"]
[{"$f":"'2a 20+ sample info'!B7","v":" "},{"$f":"'2a 20+ sample info'!J7","v":0},{"$f":"'2a 20+ sample info'!K7","v":0}]
[{"$f":"'2a 20+ sample info'!B8","v":" "},{"$f":"'2a 20+ sample info'!J8","v":0},{"$f":"'2a 20+ sample info'!K8","v":0}]
[{"$f":"'2a 20+ sample info'!B9","v":" "},{"$f":"'2a 20+ sample info'!J9","v":0},{"$f":"'2a 20+ sample info'!K9","v":0}]
[{"$f":"'2a 20+ sample info'!B10","v":" "},{"$f":"'2a 20+ sample info'!J10","v":0},{"$f":"'2a 20+ sample info'!K10","v":0}]
[{"$f":"'2a 20+ sample info'!B11","v":" "},{"$f":"'2a 20+ sample info'!J11","v":0},{"$f":"'2a 20+ sample info'!K11","v":0}]
[{"$f":"'2a 20+ sample info'!B12","v":" "},{"$f":"'2a 20+ sample info'!J12","v":0},{"$f":"'2a 20+ sample info'!K12","v":0}]
[{"$f":"'2a 20+ sample info'!B13","v":" "},{"$f":"'2a 20+ sample info'!J13","v":0},{"$f":"'2a 20+ sample info'!K13","v":0}]
[{"$f":"'2a 20+ sample info'!B14","v":" "},{"$f":"'2a 20+ sample info'!J14","v":0},{"$f":"'2a 20+ sample info'!K14","v":0}]
[{"$f":"'2a 20+ sample info'!B15","v":" "},{"$f":"'2a 20+ sample info'!J15","v":0},{"$f":"'2a 20+ sample info'!K15","v":0}]
[{"$f":"'2a 20+ sample info'!B16","v":" "},{"$f":"'2a 20+ sample info'!J16","v":0},{"$f":"'2a 20+ sample info'!K16","v":0}]
[{"$f":"'2a 20+ sample info'!B17","v":" "},{"$f":"'2a 20+ sample info'!J17","v":0},{"$f":"'2a 20+ sample info'!K17","v":0}]
[{"$f":"'2a 20+ sample info'!B18","v":" "},{"$f":"'2a 20+ sample info'!J18","v":0},{"$f":"'2a 20+ sample info'!K18","v":0}]
[{"$f":"'2a 20+ sample info'!B19","v":" "},{"$f":"'2a 20+ sample info'!J19","v":0},{"$f":"'2a 20+ sample info'!K19","v":0}]
[{"$f":"'2a 20+ sample info'!B20","v":" "},{"$f":"'2a 20+ sample info'!J20","v":0},{"$f":"'2a 20+ sample info'!K20","v":0}]
[{"$f":"'2a 20+ sample info'!B21","v":" "},{"$f":"'2a 20+ sample info'!J21","v":0},{"$f":"'2a 20+ sample info'!K21","v":0}]
[{"$f":"'2a 20+ sample info'!B22","v":" "},{"$f":"'2a 20+ sample info'!J22","v":0},{"$f":"'2a 20+ sample info'!K22","v":0}]
[{"$f":"'2a 20+ sample info'!B23","v":" "},{"$f":"'2a 20+ sample info'!J23","v":0},{"$f":"'2a 20+ sample info'!K23","v":0}]
[{"$f":"'2a 20+ sample info'!B24","v":" "},{"$f":"'2a 20+ sample info'!J24","v":0},{"$f":"'2a 20+ sample info'!K24","v":0}]
[{"$f":"'2a 20+ sample info'!B25","v":" "},{"$f":"'2a 20+ sample info'!J25","v":0},{"$f":"'2a 20+ sample info'!K25","v":0}]
[{"$f":"'2a 20+ sample info'!B26","v":" "},{"$f":"'2a 20+ sample info'!J26","v":0},{"$f":"'2a 20+ sample info'!K26","v":0}]

{"sheet":"5. DAFM Enclosure","index":7,"n_rows":26,"n_cols":5,"rows_kept":26,"merged":[[1,2,1,4],[25,2,25,4]]}
[]
[null,null,"DAFM Commercial Document"]
[]
[null,null,"Consignor",null,"Consignee"]
[null,null,{"$f":"'2. Contact & sample information'!C3","v":" "},null,"Dr Peter Turner"]
[null,null,{"$f":"'1. PAYMENT'!C6:E6","v":0},null,"Waterford Institute of Technology"]
[null,null,{"$f":"'2. Contact & sample information'!C4","v":0},null,"Cork Road"]
[null,null,{"$f":"'2. Contact & sample information'!C5","v":0},null,"Waterford"]
[null,null,{"$f":"'2. Contact & sample information'!C6","v":0},null,"IRELAND"]
[null,null,{"$f":"'2. Contact & sample information'!C7","v":0}]
[null,null,{"$f":"'2. Contact & sample information'!C8","v":0},null,"2017/07"]
[]
[null,null,"Place of Sample Origin",null,"Sample Destination"]
[null,null,{"$f":"'2. Contact & sample information'!F12","v":0},null,"Dr Peter Turner"]
[{"$nulls":4},"Waterford Institute of Technology"]
[{"$nulls":4},"Cork Road"]
[{"$nulls":4},"Waterford"]
[{"$nulls":4},"IRELAND"]
[]
[]
[null,null,"Sample Type.\nFaecal / hair or tissue",null,"Species:\nUnknown."]
[]
[null,null,"Category.\n",null,"Quantity:"]
[null,null,"2(a) / 3(h)",null,{"$f":"'2. Contact & sample information'!C9","v":0}]
[]
[null,null,"CN Code 0511 91 90"]

{"sheet":"6. VAT Receipt","index":8,"n_rows":28,"n_cols":5,"rows_kept":28,"hidden":true,"merged":[[16,1,17,2],[27,1,29,4]]}
{"$rows_empty":7}
[null,null,"VAT RECEIPT"]
[{"$nulls":4},"From:"]
[null,{"$f":"'1. PAYMENT'!C6","v":0},null,null,"Swift Ecology Ltd."]
[null,{"$f":"'2. Contact & sample information'!F4","v":0},null,null,"Fartown Barn"]
[null,{"$f":"'2. Contact & sample information'!F5","v":0},null,null,"Pensax"]
[null,{"$f":"'2. Contact & sample information'!F6","v":0},null,null,"Abberley"]
[null,{"$f":"'2. Contact & sample information'!F7","v":0},null,null,"Worcestershire"]
[null,{"$f":"'2. Contact & sample information'!F8","v":0},null,null,"WR6 6AE"]
[]
[null,"This receipt is invalid \nwithout a Receipt Number",null,"Receipt No.",{"$f":"'2. Contact & sample information'!F2","v":0}]
[{"$nulls":3},"Date:",{"$f":"(LEFT('1. PAYMENT'!C7,2)&\"/\"&MID('1. PAYMENT'!C7,3,2)&\"/\"&RIGHT('1. PAYMENT'!C7,2))","v":"//"}]
[]
[]
[null,"DNA  Analysis",{"$f":"'2. Contact & sample information'!D9","v":"CHOOSE Service"}]
[]
[null,{"$f":"'1. PAYMENT'!C16","v":0},"Samples",null,{"$f":"'1. PAYMENT'!E24","v":{"$error":"#N/A"}}]
[null,null,"VAT",null,{"$f":"'1. PAYMENT'!E26","v":{"$error":"#N/A"}}]
[{"$nulls":4},{"$f":"SUM(E23:E24)","v":{"$error":"#N/A"}}]
[]
[]
[null,"Company No. 6233860. Registered in England and Wales. \nVAT Reg No:. 901 5587 33"]

{"sheet":"Data","index":9,"n_rows":29,"n_cols":10,"rows_kept":29,"hidden":true}
[]
[null,"Sample Types",null,"Prices","single","mixed","single comm","single non-comm"]
[null,"Faecal",null,1,50,{"$f":"E3+10","v":60},30,40,null,"Service"]
[null,"Fur",null,2,50,{"$f":"E4+10","v":60},30,40,null,"CHOOSE"]
[null,"Tissue sample",null,3,50,60,30,40,null,"Standard"]
[null,"Owl pellet",null,4,50,60,30,40,null,"Express"]
[null,"Swab",null,5,45,55,30,40]
[null,"Other",null,6,45,55,30,40,null,"Yes/No"]
[{"$nulls":3},7,45,55,30,40,null,"Yes"]
[null,"Weights",null,8,45,55,30,40,null,"No"]
[null,"less than 1g",null,9,45,55,30,40,null,"Possible"]
[null,"1 - 5g",null,10,40,50,30,40]
[null,"5-10g",null,11,40,50,30,40]
[null,"other (please specify)",null,12,40,50,30,40]
[{"$nulls":3},13,40,50,30,40]
[null,"Group",null,14,40,50,30,40]
[null,"A. Carnivores.",null,15,40,50,30,40]
[null,"B. Small mammals.",null,16,40,50,30,40]
[null,"C. Bats.",null,17,40,50,30,40]
[null,"D. Other mammals.",null,18,40,50,30,40]
[null,"E. Owls.",null,19,40,50,30,40]
[{"$nulls":3},20,35,45,30,40]
[]
[{"$nulls":3},"VAT Reg","NOT VAT REG","VAT number needed?","Carriage"]
[null,"1 England, Wales or Scotland (not C.I.) ",1,"VAT applies","VAT will be added to your total","no","y","Carriage will be added to your total and you will receive a shipping label"]
[null,"2 Northern Ireland ",2,"VAT will be added to your total","VAT will be added to your total","no","n","No carrriage will be added to your order, you may use a courier of your choice or the post"]
[null,"3 Republic of Ireland",3,"NO VAT applies","VAT will be added to your total","yes","n","No carrriage will be added to your order, you may use a courier of your choice or the post"]
[null,"4 other EU countries",4,"NO VAT","VAT will be added to your total","yes","n","No carrriage will be added to your order, please use a courier of your choice"]
[null,"5 Channel Is. ",5,"NO VAT","NO VAT","no","n","No carrriage will be added to your order, please use a courier of your choice"]