{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Help","Set Up","iSam Paste In","TB Invoice","Other Work Invoice"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"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":"Help","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Set Up","index":1,"n_rows":39,"n_cols":3,"rows_kept":39,"cut":false,"hidden":false,"merged":[]}
["Practice Identification","Version: 1"]
[]
["OV Practice ID:"]
["OV Practice Name:"]
["Purchase Order Number:"]
["Vat Reg Number:"]
[]
[]
[]
[]
["Mileage Fee"]
[]
["Date Applies","2017-04-01"]
["Before ",0.45]
["On or after",0.45]
[]
[]
["Attendence Fee"]
[]
["Date Applies","2017-04-01"]
["Before ",60]
["On or after",60]
[]
[]
["TB Test Cost Per Animal"]
[]
["Date Applies","2017-04-01"]
["Before ",2.6]
["On or after",2.6]
[]
[]
["Non - TB Cost per Animal"]
[]
["Date Applies","2017-04-01"]
["Fee per Animal Tested","Before","After"]
["Brucellosis Blood Sampling",2,2]
["Brucellosis Full Abortion Investigation",20,20]
["Anthrax investigation",15,15]
["Enzootic Bovine Leukosis testing",3,3]

{"sheet":"iSam Paste In","index":2,"n_rows":9,"n_cols":9,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
["Customer Name","Location Name","CPHH","TT1 Date","Submitted Date","Part Test Indicator","Test Type","Work Schedule","Paid For Test"]

{"sheet":"TB Invoice","index":3,"n_rows":9,"n_cols":22,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
[]
[null,"OV Practice ID:",{"$f":"'Set Up'!B3","v":0}]
[null,"OV Practice Name:",{"$f":"'Set Up'!B4","v":0}]
[null,"PO Number:",{"$f":"'Set Up'!B5","v":0}]
[null,"Vat Reg Number:",{"$f":"'Set Up'!B6","v":0}]
[null,null,null,null,null,null,null,null,null,"Totals:",{"$f":"SUM(K10:K21)","v":0},null,{"$f":"SUM(M10:M21)","v":0},{"$f":"SUM(N10:N21)","v":0},{"$f":"SUM(O10:O21)","v":0},null,{"$f":"SUM(Q10:Q21)","v":0},{"$f":"SUM(R10:R21)","v":0},null,{"$f":"SUM(T10:T21)","v":0},{"$f":"SUM(U10:U21)","v":0},{"$f":"SUM(V10:V21)","v":0}]
[]
[]
["OV Practice Customer ID","OV Practice Name","CPH","CPHH","Work Schedule Activity ID","Reason for Test","Part Test Label","TT1 Date","TT2 Date","Submission Date","Number of Animals tested","Cost per Animal","Animal Cost","Attendance Fee TT1","Attendance Fee TT2","Cost per Mile TT1","Excess Mileage TT1","Mileage Cost TT1","Cost per Mile TT2","Excess Mileage TT2","Mileage Cost TT2","Total Cost"]

{"sheet":"Other Work Invoice","index":4,"n_rows":9,"n_cols":14,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
[]
["OV Practice ID:",{"$f":"'Set Up'!B3","v":0}]
["OV Practice Name:",{"$f":"'Set Up'!B4","v":0}]
["PO Number:",{"$f":"'Set Up'!B5","v":0}]
["Vat Reg Number:",{"$f":"'Set Up'!B6","v":0}]
[null,null,null,null,null,"Totals:",{"$f":"SUM(G10:G26)","v":0},{"$f":"SUM(H10:H26)","v":0},null,{"$f":"SUM(J10:J26)","v":0},{"$f":"SUM(K10:K26)","v":0},null,{"$f":"SUM(M10:M26)","v":0},{"$f":"SUM(N10:N26)","v":0}]
[]
[]
["APHA Ref Number","CPHH","Customer Name","Date of Visit","Submitted Date","Work Area","Attendence Fee","Excess Miles","Cost Per Mile","Excess Mileage Cost","Number of Animals","Cost per Animal","Animal Cost","Total Cost"]