{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Instructions","Application","Parent Nominations","Test Options"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":0,"defined_names":27,"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":17,"n_cols":2,"rows_kept":17,"cut":false,"hidden":false,"merged":[[12,1,12,4],[13,1,13,4],[14,1,14,4],[15,1,15,4],[16,1,16,4],[11,1,11,4],[6,1,7,4],[8,1,8,4],[9,1,9,4],[10,1,10,4]]}
[]
[]
[]
[]
[]
[]
[null,"HOW TO FILL OUT NEOGEN AUSTRALASIA SUBMISSION FORM"]
[]
[null,"1. Producer Information \nPlease complete all relevant fields\nPlease provide at least one valid E-mail and Phone number"]
[null,"2. Billing Information\nPlease complete relevant fields if billing information is different to producer information\nIf billing information is the same as producer information please tick the white box"]
[null,"3. Sample Information\nSpecies Type: from the drop down menu select species type for testing e.g. Beef. \nNOTE: you will need to select species type to allow test codes to appear\nBreed: Type what breed is being tested e.g. Angus\nSample type: from the drop down menu select sample type that is being submitted for testing e.g. TSU\nNumber of Samples: Type how many samples you are submitting for testing e.g. 50"]
[null,"4. Account Details/Billing Reference\nPlease tick either YES or NO - If you are an existing customer with NEOGEN AUSTRALASIA tick YES and supply your account code"]
[null,"5. Details of animals submitted for testing\na) Make sure the Animal ID and/or Barcode information matches the ID written on the Sample. Please supply only the information requested.\nb) Sex of animal: M - Male or F - Female\nc) Date of Birth (DOB): Please provide date of birth if you can, if unknown please leave blank. Enter DOB as DD/MM/YYYY\nd) Test Option: Please select which testing you require from the dropdown box. e.g. Seeksire. If more than 3 tests are required for a single animal, please continue down on the next line, taking care to skip over any extra testing lines when entering the next animal"]
[null,"6. Parentage Verification\nIf parentage is required please put Sire and Dam information into the Parent Nominations tab, ensure to include case numbers or barcodes. "]
[null,"7. EMAIL this file to naa-lab@neogen.com when you send your samples. Samples will not be processed without an electronic copy of this form."]
[null,"8. Enclose a copy of the form with the samples; the print area is set for 20 entries, please contact us if you need this adjusted. The form does NOT need to be printed in colour. Mail a printed copy with your samples to: Neogen Australasia, 14 Hume Drive, Bundamba, QLD, 4304"]
[null,"9. Your results will be returned to you via the email listed on the form and/or your society where appropriate"]

{"sheet":"Application","index":1,"n_rows":232,"n_cols":16,"rows_kept":232,"cut":false,"hidden":false,"merged":[[30,0,31,0],[30,1,31,1],[30,2,31,2],[30,4,31,4],[26,0,26,15],[30,3,31,3],[30,5,31,5],[30,6,31,6],[30,7,31,7],[30,14,31,14],[30,13,31,13],[30,12,31,12],[11,6,11,8],[12,6,12,8],[14,6,14,8],[8,2,8,4],[10,2,10,4],[12,2,12,4],[13,2,13,4],[14,2,14,4],[6,2,6,4],[6,6,6,8],[16,6,16,8],[30,15,31,15],[18,2,18,4],[21,2,21,4],[18,6,18,8],[16,2,16,4],[21,6,21,8],[23,8,23,9],[30,8,31,8],[30,9,30,11],[20,6,20,8],[19,2,19,4],[8,6,8,8],[10,6,10,8]]}
[]
[null,null,null,null,null,null,null,null,"Neogen Australasia  ",null,null,null,null,"Neogen Australasia"]
[null,null,null,null,null,null,null,null,"Submission Form",null,null,null,null,"14 Hume Drive, Bundamba, QLD, 4304"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"07 3736 2134"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FY23"]
[null,null,"Member Information",null,null,null,"Billing Information",null,null,null,"Sample Information",null,"Account Information"]
[]
[null,"Property/Stud Name: ",null,null,null,"Account Name: ","Australian Gelbvieh Association Inc, C/- Genetic Hub",null,null,"Species: ","Beef","Account  Code: ",796]
[null,null,null,null,null,null,null,null,null,null,null,null,"Only if Known - leave blank if not."]
[null,"Member Name: ",null,null,null,"Address: ","Building 3, Room 314 (Po Box U66)",null,null,"Breed: ","Gelbvieh","Herd Prefix/Code: "]
[null,null,null,null,null,null,"Nathan Cob Drive, Charles Sturt University"]
[null,"Address: ",null,null,null,null,"Wagga Wagga, NSW, 2678",null,null,"Number of samples: "]
[null,null,null,null,null,null,null,null,null,null,"Surcharge for samples that are not Allflex TSU"]
[null,null,null,null,null,"ABN: ",null,null,null,"Date:"]
[]
[null,"Phone Number: ",null,null,null,"PO/Billing Reference: "]
[]
[null,"Email: ",null,null,null,"Phone Number: ","(02) 6933 1214"]
[null,"Secondary E-mail: "]
[null,null,null,null,null,"Email: ","registrar@genetichub.com.au"]
[null,null,null,null,null,"Secondary E-mail: "]
[]
[]
[]
[]
["Sample Submission:  Complete this form and submit it via email to registrar@genetichub.com.au. Mail a printed copy with your samples to: Neogen Australasia, 14 Hume Drive, Bundamba, QLD, 4304"]
[]
["LIMS IDENTIFIERS (Office use ONLY)"]
["Barcode 2",null,"Barcode 1","Sample Type","Animal ID","Registration Number","EID","Sex","DOB"]
["Barcode/Case Number",null,"Sample Barcode","Sample Type","Animal ID","Rego Number","ICAR","Sex (M/F)","Date of Birth","Test Options",null,null,"SIRE BARCODE / CASE NUMBER","SIRE REGO / IDENT","DAM BARCODE / CASE NUMBER","DAM REGO / IDENT"]
[null,null,null,null,null,null,null,null,null,"Test 1","Test 2","Test 3"]
[null,1]
[null,2]
[null,3]
[null,4]
[null,5]
[null,6]
[null,7]
[null,8]
[null,9]
[null,10]
[null,11]
[null,12]
[null,13]
[null,14]
[null,15]
[null,16]
[null,17]
[null,18]
[null,19]
[null,20]
[null,21]
[null,22]
[null,23]
[null,24]
[null,25]
[null,26]
[null,27]
[null,28]
[null,29]
[null,30]
[null,31]
[null,32]
[null,33]
[null,34]
[null,35]
[null,36]
[null,37]
[null,38]
[null,39]
[null,40]
[null,41]
[null,42]
[null,43]
[null,44]
[null,45]
[null,46]
[null,47]
[null,48]
[null,49]
[null,50]
[null,51]
[null,52]
[null,53]
[null,54]
[null,55]
[null,56]
[null,57]
[null,58]
[null,59]
[null,60]
[null,61]
[null,62]
[null,63]
[null,64]
[null,65]
[null,66]
[null,67]
[null,68]
[null,69]
[null,70]
[null,71]
[null,72]
[null,73]
[null,74]
[null,75]
[null,76]
[null,77]
[null,78]
[null,79]
[null,80]
[null,81]
[null,82]
[null,83]
[null,84]
[null,85]
[null,86]
[null,87]
[null,88]
[null,89]
[null,90]
[null,91]
[null,92]
[null,93]
[null,94]
[null,95]
[null,96]
[null,97]
[null,98]
[null,99]
[null,100]
[null,101]
[null,102]
[null,103]
[null,104]
[null,105]
[null,106]
[null,107]
[null,108]
[null,109]
[null,110]
[null,111]
[null,112]
[null,113]
[null,114]
[null,115]
[null,116]
[null,117]
[null,118]
[null,119]
[null,120]
[null,121]
[null,122]
[null,123]
[null,124]
[null,125]
[null,126]
[null,127]
[null,128]
[null,129]
[null,130]
[null,131]
[null,132]
[null,133]
[null,134]
[null,135]
[null,136]
[null,137]
[null,138]
[null,139]
[null,140]
[null,141]
[null,142]
[null,143]
[null,144]
[null,145]
[null,146]
[null,147]
[null,148]
[null,149]
[null,150]
[null,151]
[null,152]
[null,153]
[null,154]
[null,155]
[null,156]
[null,157]
[null,158]
[null,159]
[null,160]
[null,161]
[null,162]
[null,163]
[null,164]
[null,165]
[null,166]
[null,167]
[null,168]
[null,169]
[null,170]
[null,171]
[null,172]
[null,173]
[null,174]
[null,175]
[null,176]
[null,177]
[null,178]
[null,179]
[null,180]
[null,181]
[null,182]
[null,183]
[null,184]
[null,185]
[null,186]
[null,187]
[null,188]
[null,189]
[null,190]
[null,191]
[null,192]
[null,193]
[null,194]
[null,195]
[null,196]
[null,197]
[null,198]
[null,199]
[null,200]

{"sheet":"Parent Nominations","index":2,"n_rows":101,"n_cols":9,"rows_kept":101,"cut":false,"hidden":false,"merged":[]}
["No.","SIRE BARCODE / CASE NUMBER","SIRE REGO / IDENT",null,null,null,"No.","DAM BARCODE / CASE NUMBER","DAM REGO / IDENT"]
[1,null,null,null,null,null,1]
[2,null,null,null,null,null,2]
[3,null,null,null,null,null,3]
[4,null,null,null,null,null,4]
[5,null,null,null,null,null,5]
[6,null,null,null,null,null,6]
[7,null,null,null,null,null,7]
[8,null,null,null,null,null,8]
[9,null,null,null,null,null,9]
[10,null,null,null,null,null,10]
[11,null,null,null,null,null,11]
[12,null,null,null,null,null,12]
[13,null,null,null,null,null,13]
[14,null,null,null,null,null,14]
[15,null,null,null,null,null,15]
[16,null,null,null,null,null,16]
[17,null,null,null,null,null,17]
[18,null,null,null,null,null,18]
[19,null,null,null,null,null,19]
[20,null,null,null,null,null,20]
[21,null,null,null,null,null,21]
[22,null,null,null,null,null,22]
[23,null,null,null,null,null,23]
[24,null,null,null,null,null,24]
[25,null,null,null,null,null,25]
[26,null,null,null,null,null,26]
[27,null,null,null,null,null,27]
[28,null,null,null,null,null,28]
[29,null,null,null,null,null,29]
[30,null,null,null,null,null,30]
[31,null,null,null,null,null,31]
[32,null,null,null,null,null,32]
[33,null,null,null,null,null,33]
[34,null,null,null,null,null,34]
[35,null,null,null,null,null,35]
[36,null,null,null,null,null,36]
[37,null,null,null,null,null,37]
[38,null,null,null,null,null,38]
[39,null,null,null,null,null,39]
[40,null,null,null,null,null,40]
[41,null,null,null,null,null,41]
[42,null,null,null,null,null,42]
[43,null,null,null,null,null,43]
[44,null,null,null,null,null,44]
[45,null,null,null,null,null,45]
[46,null,null,null,null,null,46]
[47,null,null,null,null,null,47]
[48,null,null,null,null,null,48]
[49,null,null,null,null,null,49]
[50,null,null,null,null,null,50]
[51,null,null,null,null,null,51]
[52,null,null,null,null,null,52]
[53,null,null,null,null,null,53]
[54,null,null,null,null,null,54]
[55,null,null,null,null,null,55]
[56,null,null,null,null,null,56]
[57,null,null,null,null,null,57]
[58,null,null,null,null,null,58]
[59,null,null,null,null,null,59]
[60,null,null,null,null,null,60]
[61,null,null,null,null,null,61]
[62,null,null,null,null,null,62]
[63,null,null,null,null,null,63]
[64,null,null,null,null,null,64]
[65,null,null,null,null,null,65]
[66,null,null,null,null,null,66]
[67,null,null,null,null,null,67]
[68,null,null,null,null,null,68]
[69,null,null,null,null,null,69]
[70,null,null,null,null,null,70]
[71,null,null,null,null,null,71]
[72,null,null,null,null,null,72]
[73,null,null,null,null,null,73]
[74,null,null,null,null,null,74]
[75,null,null,null,null,null,75]
[76,null,null,null,null,null,76]
[77,null,null,null,null,null,77]
[78,null,null,null,null,null,78]
[79,null,null,null,null,null,79]
[80,null,null,null,null,null,80]
[81,null,null,null,null,null,81]
[82,null,null,null,null,null,82]
[83,null,null,null,null,null,83]
[84,null,null,null,null,null,84]
[85,null,null,null,null,null,85]
[86,null,null,null,null,null,86]
[87,null,null,null,null,null,87]
[88,null,null,null,null,null,88]
[89,null,null,null,null,null,89]
[90,null,null,null,null,null,90]
[91,null,null,null,null,null,91]
[92,null,null,null,null,null,92]
[93,null,null,null,null,null,93]
[94,null,null,null,null,null,94]
[95,null,null,null,null,null,95]
[96,null,null,null,null,null,96]
[97,null,null,null,null,null,97]
[98,null,null,null,null,null,98]
[99,null,null,null,null,null,99]
[100,null,null,null,null,null,100]

{"sheet":"Test Options","index":3,"n_rows":20,"n_cols":1,"rows_kept":20,"cut":false,"hidden":true,"merged":[]}
["Beef"]
["SeekSire"]
["Seeksire + PV"]
["GELB_STD_BDL-NAA"]
["GGP_Bovine100K-NAA"]
["POLL"]
["Coat"]
["BVDV / PI - Available in conjunction with another test"]
["PV Only - Samples Already Tested"]
[]
[]
[]
[]
[]
["Sample Type"]
["TSU"]
["Hair"]
["Tissue"]
["Semen"]
["Blood card"]