{"text_format":"1","workbook":"xlsx","n_sheets":13,"sheets":["Stats","Animal","ID","NLIS","DNA","MATING","CALVING","HEALTH","WEIGHT","PRICE","TaxStocklist","Info","NLISDBExtract"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":11,"comments":3,"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":"Stats","index":0,"n_rows":22,"n_cols":2,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
["STATISTICS"]
[]
["Bulls",{"$f":"COUNTIFS(ID!C:C,\"M\",ID!D:D,\"y\")","v":1}]
["Females",{"$f":"COUNTIFS(ID!C:C,\"F\",ID!D:D,\"y\")","v":1}]
["Steers",{"$f":"COUNTIFS(ID!C:C,\"C\",ID!D:D,\"y\")","v":0}]
["Horned",{"$f":"COUNTIFS(ID!G:G,\"H\",ID!D:D,\"y\")","v":0}]
["Pp",{"$f":"COUNTIFS(ID!G:G,\"PP\",ID!D:D,\"y\")","v":1}]
["Ph",{"$f":"COUNTIFS(ID!G:G,\"PH\",ID!D:D,\"y\")","v":1}]
["Pregnant",{"$f":"COUNTIF(MATING!H:H,\"y\")","v":0}]
["Age 0",{"$f":"COUNTIFS(ID!I:I,0,ID!D:D,\"y\")","v":1}]
["Age 1",{"$f":"COUNTIFS(ID!I:I,1,ID!D:D,\"y\")","v":0}]
["Age 2",{"$f":"COUNTIFS(ID!I:I,2,ID!D:D,\"y\")","v":0}]
["Age 3",{"$f":"COUNTIFS(ID!I:I,3,ID!D:D,\"y\")","v":1}]
["Age 4",{"$f":"COUNTIFS(ID!I:I,4,ID!D:D,\"y\")","v":0}]
["Age 5",{"$f":"COUNTIFS(ID!I:I,5,ID!D:D,\"y\")","v":0}]
["Age 6",{"$f":"COUNTIFS(ID!I:I,6,ID!D:D,\"y\")","v":0}]
["Age 7",{"$f":"COUNTIFS(ID!I:I,7,ID!D:D,\"y\")","v":0}]
["Age 8",{"$f":"COUNTIFS(ID!I:I,8,ID!D:D,\"y\")","v":0}]
["Age 9",{"$f":"COUNTIFS(ID!I:I,9,ID!D:D,\"y\")","v":0}]
["Age 10",{"$f":"COUNTIFS(ID!I:I,10,ID!D:D,\"y\")","v":0}]
["Age 11",{"$f":"COUNTIFS(ID!I:I,11,ID!D:D,\"y\")","v":0}]
["Age 12",{"$f":"COUNTIFS(ID!I:I,12,ID!D:D,\"y\")","v":0}]

{"sheet":"Animal","index":1,"n_rows":51,"n_cols":16,"rows_kept":51,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[null,"Animal",1,"of",3]
[null,"Fairfield Sniper"]
[]
[null,"AnimalID","FFFPS147",null,null,null,null,null,null,null,"DNA"]
[null,"Name","Fairfield Sniper",null,null,null,null,null,null,null,"DNAID",838961]
[null,"HBNo",2131,null,null,null,null,null,null,null,"Date","2019-04-10"]
[null,"HBGrade","P",null,null,null,null,null,null,null,"Type","POLL"]
[null,"HornStatus","PP",null,null,null,null,null,null,null,"Result","PcPc"]
[null,"Sex","M",null,null,null,null,null,null,null,"Comment"]
[null,"DOB","2019-01-29","Years",{"$f":"IF(C10<1,\"\",ROUNDDOWN(YEARFRAC(C10,TODAY(),3),0))","v":0},"Months",{"$f":"IF(C10<1,\"\",((TODAY()-C10)-E10*365)/30)","v":6.7333333333333334},null,null,null,"NLIS"]
[null,"WeanDate",null,null,null,null,null,null,null,null,"NLIS","NJ370691XBN01147"]
[null,"BreedingAge","2020-01-29",null,null,null,null,null,null,null,"TagColour","White"]
[null,"AI-ET","Natural",null,null,null,null,null,null,null,"TagStatus","Active"]
[null,"Colour","R/W",null,null,null,null,null,null,null,"TagNumber","982 123548457121"]
[null,"Current","y","CullDate",null,null,null,null,null,null,"HEALTH"]
[null,"Owner",null,null,null,null,null,null,null,null,"Procedure","Vaccination1stShot","Wormer","Vaccination","Dehorned","Insecticide"]
[null,"PIC","NJ370691",null,null,null,null,null,null,null,"Product","7-in-1","Moxidectin","7-in-1",null,"Deltamethrin"]
[null,"SireID","VP269",null,null,null,null,null,null,null,"Date","2019-03-21","2019-03-21","2019-05-09","2019-05-09","2019-08-05"]
[null,"Sire","Vestfold Park Trigger",null,null,null,null,null,null,null,"Due",null,"2019-09-20","2020-05-08"]
[null,"DamID","SPKPN03",null,null,null,null,null,null,null,"WEIGHT"]
[null,"Dam","Shalni Park Nessie",null,null,null,null,null,null,null,"Date"]
[null,"Comment",null,null,null,null,null,null,null,null,"Weight"]
[null,"Calves",0,null,null,null,null,null,null,null,"Weaning","TO BE CALCULATED"]
[null,"InterCalving",0,null,null,null,null,null,null,null,"200d","TO BE CALCULATED"]
[null,null,null,null,null,null,null,null,null,null,"365d","TO BE CALCULATED"]
[]
[]
[null,"BREEDING"]
[null,"AI-ET"]
[null,"Bull HBNo"]
[null,"Bull"]
[null,"MatingDate"]
[null,"Due"]
[null,"Pregnant"]
[null,"Twins"]
[null,"CalfID1"]
[null,"Name"]
[null,"CalfID2"]
[null,"Name"]
[null,"Birthdate"]
[null,"Gestation"]
[null,"Comment"]
[]
[]
[null,"PRICE"]
[null,"PurchaseDate"]
[null,"BuyPrice"]
[null,"Owner"]
[null,"SellDate"]
[null,"SellPrice"]
[null,"Buyer"]

{"sheet":"ID","index":2,"n_rows":4,"n_cols":23,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
["AnimalID","Name","Sex","Current","HBNo","HBGrade","Horn","DOB","AgeYr","AgeMth","Colour","AI-ET","WeanDate","BreedAge","CullDate","PIC","SireID","Sire","DamID","Dam","Comment","Calves","ICAv"]
["FFFPS147","Fairfield Sniper","M","y",2131,"P","PP","2019-01-29",{"$f":"ROUNDDOWN(YEARFRAC(H2,TODAY(),3),0)","v":0},{"$f":"((TODAY()-H2)-I2*365)/30","v":6.7333333333333334},"R/W","Natural",null,{"$f":"(IF(C2=\"F\",H2+540,H2+365))","v":"2020-01-29"},null,"NJ370691","VP269","Vestfold Park Trigger","SPKPN03","Shalni Park Nessie",null,{"$f":"COUNTIF(CALVING!A:A,ID!A2)","v":0},{"$f":"IF(V2>1,VLOOKUP(A2,CALVING!A:J,10,FALSE),0)","v":0}]
["SPKPN03","Shalni Park Nessie","F","y",2050,"P","PH","2016-05-17",{"$f":"ROUNDDOWN(YEARFRAC(H3,TODAY(),3),0)","v":3},{"$f":"((TODAY()-H3)-I3*365)/30","v":3.1333333333333333},"R/W","Natural",null,{"$f":"(IF(C3=\"F\",H3+540,H3+365))","v":"2017-11-08"},null,"NJ370691","SPKPJ05","Shalni Park Jacko (P) (P)","SPKPJ01","Shalni Park Jessie (P) (P)",null,{"$f":"COUNTIF(CALVING!A:A,ID!A3)","v":1},{"$f":"IF(V3>1,VLOOKUP(A3,CALVING!A:J,10,FALSE),0)","v":0}]
["VP269","Vestfold Park Trigger","M","n",2071,"P","PH","2014-03-19",5,5.1333333333333337,"R/W","AI",null,"2015-03-19",null,null,"110379-00023","Dalgaard Amadeus (DK)","VYPP3C","Vestfold Yarra Park Susan 8th",null,{"$f":"COUNTIF(CALVING!A:A,ID!A4)","v":0},{"$f":"IF(V4>1,VLOOKUP(A4,CALVING!A:J,10,FALSE),0)","v":0}]

{"sheet":"NLIS","index":3,"n_rows":35,"n_cols":17,"rows_kept":35,"cut":false,"hidden":false,"merged":[]}
["AnimalID","Name","NLIS Tag Number","TagColour","TagStatus","RFID Number","BreederPIC","Transfer","Location",null,"Date","WeighbillNr","FromPIC","From","ToPIC","To","Comment"]
["FFFPS147",{"$f":"VLOOKUP(A2,ID!A:B,2,FALSE)","v":"Fairfield Sniper"},"NJ370691XBN01147","White","Active",{"$f":"VLOOKUP(TRIM($C2),NLISDBExtract!B:E,2,FALSE)","v":"982 123548457121"},{"$f":"LEFT(C2,8)","v":"NJ370691"},{"$f":"VLOOKUP(TRIM($C2),NLISDBExtract!B:E,3,FALSE)","v":"-"},{"$f":"VLOOKUP(TRIM($C2),NLISDBExtract!B:K,11,FALSE)","v":{"$error":"#REF!"}}]
["SPKPN03",{"$f":"VLOOKUP(A3,ID!A:B,2,FALSE)","v":"Shalni Park Nessie"},"3SGFG266MBL00328","White","Active",{"$f":"VLOOKUP(TRIM($C3),NLISDBExtract!B:E,2,FALSE)","v":"964 001006983393"},{"$f":"LEFT(C3,8)","v":"3SGFG266"},{"$f":"VLOOKUP(TRIM($C3),NLISDBExtract!B:E,3,FALSE)","v":"2017-09-18"},{"$f":"VLOOKUP(TRIM($C3),NLISDBExtract!B:K,11,FALSE)","v":{"$error":"#REF!"}}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"SPARE NLIS TAGS ","Colour","TagStatus","RFID Number","Mgmt","Issue"]
[null,null,null,null,null,null,null,null,null,null,"Fairfield"]
[null,null,null,null,null,null,null,null,null,null,"NJ370691XBN01154","White","Active",{"$f":"VLOOKUP(TRIM($K35),NLISDBExtract!B:J,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(TRIM($K35),NLISDBExtract!B:I,8,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(TRIM($K35),NLISDBExtract!B:E,4,FALSE)","v":{"$error":"#N/A"}}]

{"sheet":"DNA","index":4,"n_rows":4,"n_cols":7,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
["AnimalID","Name","DNAID","Date","Type","Result","DNAComment"]
["SPKPN03",{"$f":"VLOOKUP(A2,ID!A:B,2,FALSE)","v":"Shalni Park Nessie"},"POL2372017","2017-10-23","Poll","PH"]
["SPKPN03",{"$f":"VLOOKUP(A3,ID!A:B,2,FALSE)","v":"Shalni Park Nessie"},663118,"2018-11-23","Parent"]
["FFFPS147",{"$f":"VLOOKUP(A4,ID!A:B,2,FALSE)","v":"Fairfield Sniper"},838961,"2019-04-10","POLL","PcPc"]

{"sheet":"MATING","index":5,"n_rows":2,"n_cols":17,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
["AnimalID","Name","AI-ET","BullID","Bull","MatingDate","Due","Pregnant","Twins","CalfID1","Name","CalfID2","Name","Birthdate","Gestation","Comment","Current"]
["SPKPN03",{"$f":"VLOOKUP(A2,ID!A:B,2,FALSE)","v":"Shalni Park Nessie"},"Natural","VP275","Vestfold Park Trigger","2018-04-10",{"$f":"_xlfn.IFNA(F2+Gestation,N2)","v":"2019-01-22"},"n","n","FFFPS147",{"$f":"_xlfn.IFNA(VLOOKUP(J2,ID!A:B,2,FALSE),\"\")","v":"Fairfield Sniper"},null,null,{"$f":"_xlfn.IFNA(VLOOKUP(J2,ID!A:H,8,FALSE),\"\")","v":"2019-01-29"},{"$f":"IF((ISBLANK(N2)),\"\",N2-F2)","v":294},"Pregtest 9/1/18",{"$f":"VLOOKUP(A2,ID!A:D,4,FALSE)","v":"y"}]

{"sheet":"CALVING","index":6,"n_rows":3,"n_cols":10,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
["AnimalID","Cow","BullID","Bull","Twins","CalfID1","Name","Birthdate","ICDays","ICAv"]
["SPKPN03","Shalni Park Nessie","VP275","Vestfold Park Trigger","n","FFFPS147","Fairfield Sniper","2019-01-29",{"$f":"IF(A2=A1,H2-H1,\"\")","v":""},{"$f":"IFERROR(ROUNDDOWN(AVERAGEIF(A:I,A2,I:I),0),\"\")","v":""}]
[null,null,null,null,null,null,null,null,"",""]

{"sheet":"HEALTH","index":7,"n_rows":6,"n_cols":12,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
["AnimalID","Name","NLIS","Procedure","Product","Date","Due","Meat Withholding","ExportSlaughter","FollowUp","Comment","Current"]
["FFFPS147",{"$f":"VLOOKUP(A2,ID!A:B,2,FALSE)","v":"Fairfield Sniper"},{"$f":"VLOOKUP(A2,NLIS!A:C,3,FALSE)","v":"NJ370691XBN01147"},"Vaccination1stShot","7-in-1","2019-03-21",{"$f":"IF(J2=\"y\",\"\",IF(D2=\"Vaccination\",(F2+365),IF(D2=\"Wormer\",(F2+183),\"\")))","v":""},{"$f":"_xlfn.IFNA(IF((VLOOKUP(E2,Info!O:P,2,FALSE)+F2)>TODAY(),(VLOOKUP(E2,Info!O:P,2,FALSE)+$F2),\"\"),\"\")","v":""},{"$f":"_xlfn.IFNA(IF((VLOOKUP(E2,Info!O:Q,3,FALSE)+F2)>TODAY(),(VLOOKUP(E2,Info!O:Q,3,FALSE)+$F2),\"\"),\"\")","v":""},null,null,{"$f":"VLOOKUP(A2,ID!A:D,4,FALSE)","v":"y"}]
["FFFPS147",{"$f":"VLOOKUP(A3,ID!A:B,2,FALSE)","v":"Fairfield Sniper"},{"$f":"VLOOKUP(A3,NLIS!A:C,3,FALSE)","v":"NJ370691XBN01147"},"Wormer","Moxidectin","2019-03-21","2019-09-20",{"$f":"_xlfn.IFNA(IF((VLOOKUP(E3,Info!O:P,2,FALSE)+F3)>TODAY(),(VLOOKUP(E3,Info!O:P,2,FALSE)+$F3),\"\"),\"\")","v":""},{"$f":"_xlfn.IFNA(IF((VLOOKUP(E3,Info!O:Q,3,FALSE)+F3)>TODAY(),(VLOOKUP(E3,Info!O:Q,3,FALSE)+$F3),\"\"),\"\")","v":""},null,null,{"$f":"VLOOKUP(A3,ID!A:D,4,FALSE)","v":"y"}]
["FFFPS147",{"$f":"VLOOKUP(A4,ID!A:B,2,FALSE)","v":"Fairfield Sniper"},{"$f":"VLOOKUP(A4,NLIS!A:C,3,FALSE)","v":"NJ370691XBN01147"},"Vaccination","7-in-1","2019-05-09","2020-05-08",{"$f":"_xlfn.IFNA(IF((VLOOKUP(E4,Info!O:P,2,FALSE)+F4)>TODAY(),(VLOOKUP(E4,Info!O:P,2,FALSE)+$F4),\"\"),\"\")","v":""},{"$f":"_xlfn.IFNA(IF((VLOOKUP(E4,Info!O:Q,3,FALSE)+F4)>TODAY(),(VLOOKUP(E4,Info!O:Q,3,FALSE)+$F4),\"\"),\"\")","v":""},null,"Booster",{"$f":"VLOOKUP(A4,ID!A:D,4,FALSE)","v":"y"}]
["FFFPS147",{"$f":"VLOOKUP(A5,ID!A:B,2,FALSE)","v":"Fairfield Sniper"},{"$f":"VLOOKUP(A5,NLIS!A:C,3,FALSE)","v":"NJ370691XBN01147"},"Dehorned",null,"2019-05-09","",{"$f":"_xlfn.IFNA(IF((VLOOKUP(E5,Info!O:P,2,FALSE)+F5)>TODAY(),(VLOOKUP(E5,Info!O:P,2,FALSE)+$F5),\"\"),\"\")","v":""},{"$f":"_xlfn.IFNA(IF((VLOOKUP(E5,Info!O:Q,3,FALSE)+F5)>TODAY(),(VLOOKUP(E5,Info!O:Q,3,FALSE)+$F5),\"\"),\"\")","v":""},null,null,{"$f":"VLOOKUP(A5,ID!A:D,4,FALSE)","v":"y"}]
["FFFPS147",{"$f":"VLOOKUP(A6,ID!A:B,2,FALSE)","v":"Fairfield Sniper"},{"$f":"VLOOKUP(A6,NLIS!A:C,3,FALSE)","v":"NJ370691XBN01147"},"Insecticide","Deltamethrin","2019-08-05","",{"$f":"_xlfn.IFNA(IF((VLOOKUP(E6,Info!O:P,2,FALSE)+F6)>TODAY(),(VLOOKUP(E6,Info!O:P,2,FALSE)+$F6),\"\"),\"\")","v":""},{"$f":"_xlfn.IFNA(IF((VLOOKUP(E6,Info!O:Q,3,FALSE)+F6)>TODAY(),(VLOOKUP(E6,Info!O:Q,3,FALSE)+$F6),\"\"),\"\")","v":"2019-08-26"},null,null,{"$f":"VLOOKUP(A6,ID!A:D,4,FALSE)","v":"y"}]

{"sheet":"WEIGHT","index":8,"n_rows":2,"n_cols":4,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
["AnimalID","Name","Date","Weight"]
["FFFPS147",{"$f":"VLOOKUP(A2,ID!A:B,2,FALSE)","v":"Fairfield Sniper"}]

{"sheet":"PRICE","index":9,"n_rows":2,"n_cols":11,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
["AnimalID","Name","PDate","P$","Owner","SDate","S$","Per kg  price","Kgs","Purchaser","Lease"]
["FFFPS147",{"$f":"VLOOKUP(A2,ID!A:B,2,FALSE)","v":"Fairfield Sniper"}]

{"sheet":"TaxStocklist","index":10,"n_rows":13,"n_cols":10,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
["FFF STOCKLIST","2017-06-30","17-18","2018-06-30","18-19","2019-06-30",null,"LLS Stocklist","2019-06-30","Comment"]
["Females",2,null,null,null,null,null,"Cattle >6mths"]
["Males",0,0]
["Females Bought",null,{"$f":"5+9+12","v":26}]
["Females Sold",null,0]
["Males Bought",null,1]
["Males Sold",null,0]
["Females Born",null,1]
["Males Born",null,1]
["Females Death",null,1]
["Males Death",null,0]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"71-7-13","v":51}]

{"sheet":"Info","index":11,"n_rows":11,"n_cols":17,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
["Name","Value",null,null,"PIC NUMBERS","PIC",null,null,"LPA Accreditation/eDEC",null,null,null,null,null,"Product","Meat Withholding Period","Export"]
["Gestation",287,null,null,"Property1",1234567,null,null,"LPA Registration No.",null,null,null,null,null,"Moxidectin",0,0]
[null,null,null,null,"Property2",2345678,null,null,"Password",null,null,null,null,null,"7-in-1",0,0]
[null,null,null,null,"Property3",3456789,null,null,"eLearning PIN",null,null,null,null,null,"5-in-1",0,0]
[null,null,null,null,null,null,null,null,"www.lpa.nlis.com.au",null,null,null,null,null,"Deltamethrin",0,21]
[null,null,null,null,"NLIS User ID:",null,null,null,"Ph 1800683111",null,null,null,null,null,"Avermectin",0,0]
[null,null,null,null,"Your Password:"]
[]
[null,null,null,null,"LBCentre"]
[null,null,null,null,"Membership Number"]
[null,null,null,null,"Prefix"]

{"sheet":"NLISDBExtract","index":12,"n_rows":3,"n_cols":11,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
["pic","NLIS ID","RFID","transfer date","Issue date","LT","LT reason for loss","EU status","Management ID","Status","Active"]
["NJ370691","NJ370691XBN01147","982 123548457121","-","2017-09-29","Y","-","N",1147,null,"YES"]
["NJ370691","3SGFG266MBL00328","964 001006983393","2017-09-18","2015-04-21","Y","-","N",null,null,"YES"]