{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["Invulsheet","Dropdownmenu","Veehouder","Veehouder2","Robotmelken en uiergezondheid","Eerste Tweede keuze","DAP","Praktijk DDD","Praktijk Mastitis","Praktijk Celgetal","Praktijk Droogstand"],"not_rendered":{"charts":19,"images":2,"macros":1,"external_links":0,"defined_names":1,"comments":0,"pivot_tables":3},"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":"Invulsheet","index":0,"n_rows":21,"n_cols":61,"rows_kept":21,"cut":false,"hidden":false,"merged":[[0,0,0,2],[2,0,2,3],[3,5,3,8],[4,0,4,6]]}
[{"$error":"#VALUE!"}]
["Sla dit bestand op uw pc op als excel bestand met macro's (*.xlsm). Bij starten vraagt Excel: Macro's inschakelen? Ja"]
["Data in blauwe kolommen kan ingevuld worden"]
["Oranje velden worden automatisch ingevuld, daar zitten formules achter"]
["Bij invullen volgend nummer + enter komt er automatisch een nieuwe regel met bijbehorende formules"]
["Door op vernieuwen te drukken worden de achterliggende tabbladen en grafieken automatisch bijgewerkt"]
["Bedrijfsnr","UBN","Naam","Dierenarts","Robot","Biologisch","Vaccinatie","Totaal aantal koeien","DDD Mastitis injectoren","DDD Droogzetters","DDD Injectie","DDD Bedrijf","DDD Bedrijf groen","DDD Bedrijf oranje","DDD Bedrijf rood","DDD Droogzetters groen","DDD Droogzetters oranje","DDD Droogzetters rood","DDD Mastitis injectoren groen","DDD Mastitis injectoren oranje","DDD Mastitis injectoren rood","Avuloxil aantal injectoren","Avuloxil behandelingen (3/beh)","Ubrolexin aantal injectoren","Ubrolexin behandelingen (2/beh)","Albiotic aantal injectoren","Albiotic behandelingen (3/beh)","Orbenin lactation aantal injectoren ","Orbenin lactation behandelingen (3/beh)","Ubropen aantal injectoren","Ubropen behandelingen (3/beh)","Totaal aantal behandelingen (Medirund)","% Mastitis behandeling (obv Medirund)","# Mastitis behandeling eigen registratie","% Mastitis behandeling eigen registratie","Aantal BO/jaar","% 1e keus uierinjector","% 2e keus uierinjector","Orbenin Dry Cow aantal injectoren","Orbenin Dry Cow aantal koeien","Orbenin Extra Dry Cow aantal injectoren","Orbenin Extra Dry Cow aantal koeien","Ubrostar Dry Cow aantal injectoren","Ubrostar Dry Cow aantal koeien","Totaal aantal koeien drooggezet","% koeien drooggezet","Orbeseal aantal injectoren","Orbeseal aantal koeien","Ubroseal aantal injectoren","Ubroseal aantal koeien","Totaal aantal koeien gesealed","% koeien gesealed","Datum MPR","Tankcelgetal","Groen (<250)","Oranje (>250<350)","Rood (>350)","% Nieuw verhoogd","% Verhoogd","DS % Nieuwe infecties","DS % Genezen"]
[1,12345,"van Aa","AA","Ja","Nee","Startvac",80,0.11,0,0.05,0.14000000000000001,{"$f":"IF(AND(ISNUMBER(L8),L8<2),L8,\"\")","v":0.14000000000000001},{"$f":"IF(AND(ISNUMBER(L8),L8>2,L8<=4.99),L8,\"\")","v":""},{"$f":"IF(AND(ISNUMBER(L8),L8>5),L8,\"\")","v":""},{"$f":"IF(AND(ISNUMBER(J8),J8<1),J8,\"\")","v":0},{"$f":"IF(AND(ISNUMBER(J8),J8>1,J8<=2.4),J8,\"\")","v":""},{"$f":"IF(AND(ISNUMBER(J8),J8>2.4),J8,\"\")","v":""},{"$f":"IF(AND(ISNUMBER(I8),I8<0.6),I8,\"\")","v":0.11},{"$f":"IF(AND(ISNUMBER(I8),I8>0.6,I8<=1.4),I8,\"\")","v":""},{"$f":"IF(AND(ISNUMBER(I8),I8>1.4),I8,\"\")","v":""},24,{"$f":"V8/3","v":8},0,{"$f":"X8/2","v":0},0,{"$f":"Z8/3","v":0},0,{"$f":"AB8/3","v":0},0,{"$f":"AD8/3","v":0},{"$f":"AE8+AC8+AA8+Y8+W8","v":8},{"$f":"IFERROR(AF8/H8*100, 0)","v":10},null,{"$f":"IFERROR(AH8/H8*100, 0)","v":0},1,{"$f":"IFERROR((AC8+AE8)/AF8*100, 0 )","v":0},{"$f":"IFERROR( (W8+Y8+AA8)/AF8*100, 0 )","v":100},0,{"$f":"AM8/4","v":0},0,{"$f":"AO8/4","v":0},null,{"$f":"AQ8/4","v":0},{"$f":"AN8+AP8+AR8","v":0},{"$f":"IFERROR(AS8/H8*100, 0)","v":0},0,{"$f":"AU8/4","v":0},0,{"$f":"AW8/4","v":0},{"$f":"AV8+AX8","v":0},{"$f":"IFERROR(AY8/H8*100, 0)","v":0},null,338,{"$f":"IF(AND(ISNUMBER(BB8),BB8<250),BB8,\"\")","v":""},{"$f":"IF(AND(ISNUMBER(BB8),BB8>250,BB8<=300),BB8,\"\")","v":""},{"$f":"IF(AND(ISNUMBER(BB8),BB8>300),BB8,\"\")","v":338},13,25,31,58]
[2,12346,"van Dee","BB","Nee","Nee","Startvac",87,0.33,1.56,1.1200000000000001,3.23,{"$f":"IF(AND(ISNUMBER(L9),L9<2),L9,\"\")","v":""},{"$f":"IF(AND(ISNUMBER(L9),L9>2,L9<=4.99),L9,\"\")","v":3.23},{"$f":"IF(AND(ISNUMBER(L9),L9>5),L9,\"\")","v":""},{"$f":"IF(AND(ISNUMBER(J9),J9<1),J9,\"\")","v":""},1.56,"",0.33,"","",36,{"$f":"V9/3","v":12},20,{"$f":"X9/2","v":10},0,{"$f":"Z9/3","v":0},0,{"$f":"AB9/3","v":0},0,{"$f":"AD9/3","v":0},22,{"$f":"IFERROR(AF9/H9*100, 0)","v":25.287356321839084},null,{"$f":"IFERROR(AH9/H9*100, 0)","v":0},2,0,100,0,{"$f":"AM9/4","v":0},180,45,null,0,45,{"$f":"IFERROR(AS9/H9*100, 0)","v":51.724137931034484},0,0,0,{"$f":"AW9/4","v":0},0,{"$f":"IFERROR(AY9/H9*100, 0)","v":0},null,350,{"$f":"IF(AND(ISNUMBER(BB9),BB9<250),BB9,\"\")","v":""},{"$f":"IF(AND(ISNUMBER(BB9),BB9>250,BB9<=300),BB9,\"\")","v":""},{"$f":"IF(AND(ISNUMBER(BB9),BB9>300),BB9,\"\")","v":350},6,15,13,57]
[3,12347,"Berkers","CC","Nee","Nee","Nee",151,0.28999999999999998,0.89,0.78,2.0699999999999998,"",2.0699999999999998,"",0.89,"","",0.28999999999999998,"","",27,9,0,0,0,0,24,8,0,0,17,11.258278145695364,null,0,3,47.058823529411761,52.941176470588239,0,0,192,48,null,0,48,31.788079470198678,336,84,20,5,89,58.940397350993379,null,64,64,"","",4,4,8,91]
[4,12348,"Dirksen","DD","Nee","Nee","Nee",95,0.14000000000000001,1.67,0.3,2.11,"",2.11,"","",1.67,"",0.14000000000000001,"","",36,12,0,0,0,0,0,0,0,0,12,12.631578947368421,null,0,4,0,100,126,31.5,0,0,null,0,31.5,33.157894736842103,0,0,0,0,0,0,null,271,"",271,"",13,19,24,77]
[5,12349,"Hoogeveen","AA","Nee","Nee","Nee",110,0.54,0.96,0.44,1.95,1.95,"","",0.96,"","",0.54,"","",0,0,80,40,0,0,0,0,0,0,40,36.363636363636367,null,0,5,0,100,0,0,144,36,null,0,36,32.727272727272727,360,90,0,0,90,81.818181818181827,null,226,226,"","",9,21,31,72]
[6,12350,"Geertshuis","BB","Nee","Nee","Nee",125,0.16,1.05,0.52,1.73,1.73,"","","",1.05,"",0.16,"","",0,0,0,0,0,0,12,4,0,0,4,3.2,null,0,2,100,0,0,0,60,15,null,0,15,12,360,90,0,0,90,72,null,189,189,"","",13,19,24,77]
[7,12370,"Groot Nibbelink","BB","Ja","Nee","Startvac + Ubac",91,0,1.19,0.25,1.44,1.44,"","","",1.19,"",0,"","",0,0,0,0,0,0,0,0,0,0,0,0,null,0,12,0,0,0,0,60,15,null,0,15,16.483516483516482,12,3,0,0,3,3.296703296703297,null,106,106,"","",6,16,15,90]
[8,12371,"Timmermans","CC","Ja","Nee","Ubac",70,0.27,1.36,0.33,1.97,1.97,"","","",1.36,"",0.27,"","",48,16,0,0,0,0,0,0,0,0,16,22.857142857142858,null,0,5,0,100,0,0,60,15,null,0,15,21.428571428571427,240,60,0,0,60,85.714285714285708,null,96,96,"","",6,14,21,67]
[9,12372,"de Boer","DD","Ja","Nee","Ubac",178,1.1200000000000001,1.01,1.89,4.12,"",4.12,"","",1.01,"","",1.1200000000000001,"",0,0,240,120,1,0.33333333333333331,12,4,0,0,124.33333333333333,69.850187265917597,null,0,0,3.2171581769436997,96.782841823056302,0,0,60,15,null,0,15,8.4269662921348321,360,90,0,0,90,50.561797752808992,null,145,145,"","",5,12,13,73]
[10,12373,"van Bree","AA","ja","Nee","Startvac",107,0.32,0.81,0.15,1.28,1.28,"","",0.81,"","",0.32,"","",0,0,0,0,0,0,24,8,0,0,8,7.4766355140186906,null,0,4,100,0,24,6,60,15,null,0,21,19.626168224299064,0,0,0,0,0,0,null,219,219,"","",5,11,21,82]
[11,12374,"Boer30","CC","ja","Nee","Nee",68,0.72,1.27,0.7,2.72,"",2.72,"","",1.27,"","",0.72,"",0,0,20,10,0,0,24,8,0,0,18,26.47058823529412,null,0,1,44.444444444444443,55.555555555555557,0,0,60,15,null,0,15,22.058823529411764,0,0,0,0,0,0,null,148,148,"","",14,23,11,73]
[12,125893,"BoerHenk","BB","Ja","Ja","Nee",178,0.5,0.5,0.2,1.4,{"$f":"IF(AND(ISNUMBER(L19),L19<2),L19,\"\")","v":1.4},{"$f":"IF(AND(ISNUMBER(L19),L19>2,L19<=4.99),L19,\"\")","v":""},{"$f":"IF(AND(ISNUMBER(L19),L19>5),L19,\"\")","v":""},{"$f":"IF(AND(ISNUMBER(J19),J19<1),J19,\"\")","v":0.5},{"$f":"IF(AND(ISNUMBER(J19),J19>1,J19<=2.4),J19,\"\")","v":""},{"$f":"IF(AND(ISNUMBER(J19),J19>2.4),J19,\"\")","v":""},{"$f":"IF(AND(ISNUMBER(I19),I19<0.6),I19,\"\")","v":0.5},{"$f":"IF(AND(ISNUMBER(I19),I19>0.6,I19<=1.4),I19,\"\")","v":""},{"$f":"IF(AND(ISNUMBER(I19),I19>1.4),I19,\"\")","v":""},24,{"$f":"V19/3","v":8},20,{"$f":"X19/2","v":10},48,{"$f":"Z19/3","v":16},24,{"$f":"AB19/3","v":8},0,{"$f":"AD19/3","v":0},{"$f":"AE19+AC19+AA19+Y19+W19","v":42},23.595505617977526,null,0,6,{"$f":"IFERROR((AC19+AE19)/AF19*100, 0 )","v":19.047619047619047},{"$f":"IFERROR( (W19+Y19+AA19)/AF19*100, 0 )","v":80.952380952380949},24,{"$f":"AM19/4","v":6},60,{"$f":"AO19/4","v":15},null,{"$f":"AQ19/4","v":0},{"$f":"AN19+AP19+AR19","v":21},11.797752808988763,240,60,0,{"$f":"AW19/4","v":0},{"$f":"AV19+AX19","v":60},33.707865168539328,null,178,178,"",{"$f":"IF(AND(ISNUMBER(BB19),BB19>300),BB19,\"\")","v":""},15,5,10,80]
[13,125876,"BoerKlaas","BB","Nee","Nee","Startvac",220,0.5,0.5,0.2,1.4,{"$f":"IF(AND(ISNUMBER(L20),L20<2),L20,\"\")","v":1.4},{"$f":"IF(AND(ISNUMBER(L20),L20>2,L20<=4.99),L20,\"\")","v":""},{"$f":"IF(AND(ISNUMBER(L20),L20>5),L20,\"\")","v":""},{"$f":"IF(AND(ISNUMBER(J20),J20<1),J20,\"\")","v":0.5},{"$f":"IF(AND(ISNUMBER(J20),J20>1,J20<=2.4),J20,\"\")","v":""},{"$f":"IF(AND(ISNUMBER(J20),J20>2.4),J20,\"\")","v":""},{"$f":"IF(AND(ISNUMBER(I20),I20<0.6),I20,\"\")","v":0.5},{"$f":"IF(AND(ISNUMBER(I20),I20>0.6,I20<=1.4),I20,\"\")","v":""},{"$f":"IF(AND(ISNUMBER(I20),I20>1.4),I20,\"\")","v":""},24,{"$f":"V20/3","v":8},20,{"$f":"X20/2","v":10},48,{"$f":"Z20/3","v":16},24,{"$f":"AB20/3","v":8},0,{"$f":"AD20/3","v":0},{"$f":"AE20+AC20+AA20+Y20+W20","v":42},{"$f":"IFERROR(AF20/H20*100, 0)","v":19.090909090909093},null,{"$f":"IFERROR(AH20/H20*100, 0)","v":0},6,{"$f":"IFERROR((AC20+AE20)/AF20*100, 0 )","v":19.047619047619047},{"$f":"IFERROR( (W20+Y20+AA20)/AF20*100, 0 )","v":80.952380952380949},24,{"$f":"AM20/4","v":6},60,{"$f":"AO20/4","v":15},null,{"$f":"AQ20/4","v":0},{"$f":"AN20+AP20+AR20","v":21},{"$f":"IFERROR(AS20/H20*100, 0)","v":9.5454545454545467},240,{"$f":"AU20/4","v":60},0,{"$f":"AW20/4","v":0},{"$f":"AV20+AX20","v":60},{"$f":"IFERROR(AY20/H20*100, 0)","v":27.27272727272727},null,178,178,"",{"$f":"IF(AND(ISNUMBER(BB20),BB20>300),BB20,\"\")","v":""},15,5,10,80]
[14,12378,"BoerJan","AA","Ja","Nee","Startvac",300,0.25,2.23,1.5,3.75,{"$f":"IF(AND(ISNUMBER(L21),L21<2),L21,\"\")","v":""},{"$f":"IF(AND(ISNUMBER(L21),L21>2,L21<=4.99),L21,\"\")","v":3.75},{"$f":"IF(AND(ISNUMBER(L21),L21>5),L21,\"\")","v":""},{"$f":"IF(AND(ISNUMBER(J21),J21<1),J21,\"\")","v":""},{"$f":"IF(AND(ISNUMBER(J21),J21>1,J21<=2.4),J21,\"\")","v":2.23},{"$f":"IF(AND(ISNUMBER(J21),J21>2.4),J21,\"\")","v":""},{"$f":"IF(AND(ISNUMBER(I21),I21<0.6),I21,\"\")","v":0.25},{"$f":"IF(AND(ISNUMBER(I21),I21>0.6,I21<=1.4),I21,\"\")","v":""},{"$f":"IF(AND(ISNUMBER(I21),I21>1.4),I21,\"\")","v":""},48,{"$f":"V21/3","v":16},20,{"$f":"X21/2","v":10},24,{"$f":"Z21/3","v":8},0,{"$f":"AB21/3","v":0},0,{"$f":"AD21/3","v":0},{"$f":"AE21+AC21+AA21+Y21+W21","v":34},{"$f":"IFERROR(AF21/H21*100, 0)","v":11.333333333333332},null,{"$f":"IFERROR(AH21/H21*100, 0)","v":0},12,{"$f":"IFERROR((AC21+AE21)/AF21*100, 0 )","v":0},{"$f":"IFERROR( (W21+Y21+AA21)/AF21*100, 0 )","v":100},240,{"$f":"AM21/4","v":60},480,{"$f":"AO21/4","v":120},null,{"$f":"AQ21/4","v":0},{"$f":"AN21+AP21+AR21","v":180},{"$f":"IFERROR(AS21/H21*100, 0)","v":60},480,{"$f":"AU21/4","v":120},0,{"$f":"AW21/4","v":0},{"$f":"AV21+AX21","v":120},{"$f":"IFERROR(AY21/H21*100, 0)","v":40},null,180,180,"",{"$f":"IF(AND(ISNUMBER(BB21),BB21>300),BB21,\"\")","v":""},6,18,25,90]

{"sheet":"Dropdownmenu","index":1,"n_rows":15,"n_cols":14,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
["Dierenarts","Robot","Biologisch","Vaccinatie",null,"Normen","Groen","Oranje","Rood"]
["AA","Ja","Ja","Startvac",null,"Tankcelgetal","≤175","176-274","≥275"]
["BB","Nee","Nee","Ubac",null,"% verhoogd celgetal","<15",null,"≥15"]
["CC",null,null,"Startvac + Ubac",null,"% nieuw verhoogd celgetal","<5","5-10","≥10"]
["DD",null,null,"Nee",null,"% nieuwe infectie uit droogstand","<10","10-15","≥15"]
[null,null,null,null,null,"% genezen uit droogstand","≥90","81-89","≤80"]
[]
[null,null,null,null,null,null,"Groen","Oranje","Rood",null,"Landelijk gemidd"]
[null,null,null,null,null,"DDD mastitis","<0,6","0,6-1,4","≥1,4","Gebruik van mastitisinjectoren in DDDAF (dieren >2 jaar)",0.44,null,"P90 1,4"]
[null,null,null,null,null,"DDD droogzetters","<1","1-2,4","≥2,4","Gebruik van droogzetters in DDDAF (dieren >2 jaar)",0.91,null,"P90 2,4"]
[null,null,null,null,null,"DDD injectie","<0,5","0,5-1",">1","Gebruik van injecte in DDDAF (dieren >2 jaar) ",0.72]
[null,null,null,null,null,"DDD","<2","2-4,99","≥5","Totaal gebruik in DDD",2.13,null,"P90 4,0","Actiewaarde>5"]
[]
[null,null,null,null,null,null,"Groen","Oranje","Rood"]
[null,null,null,null,null,"% mastitisbehandeling obv Medirund","<20%","20-29","≥30%","Rollende jaargemiddelde klinische mastitisincidentie (CMI) ",29.7]

{"sheet":"Veehouder","index":2,"n_rows":31,"n_cols":5,"rows_kept":31,"cut":false,"hidden":false,"merged":[[0,1,0,3],[1,1,1,2],[2,1,2,2],[3,1,3,2],[4,1,4,2]]}
[{"$error":"#VALUE!"},"Uiergezondheidsprofiel",null,null,{"$error":"#VALUE!"}]
["Bedrijfsnr",3]
["UBN",{"$f":"_xlfn.XLOOKUP($B$2, tblInvul[Bedrijfsnr], tblInvul[UBN])","v":12347}]
["Naam",{"$f":"_xlfn.XLOOKUP($B$2, tblInvul[Bedrijfsnr], tblInvul[Naam])","v":"Berkers"}]
["Dierenarts",{"$f":"_xlfn.XLOOKUP($B$2, tblInvul[Bedrijfsnr], tblInvul[Dierenarts])","v":"CC"}]
["Kengetal","Bedrijf","Laagste 25% (P25)","Gemiddeld","Hoogste 25% (P75)"]
["Totaal aantal koeien",{"$f":"_xlfn.XLOOKUP($B$2, tblInvul[Bedrijfsnr], tblInvul[Totaal aantal koeien])","v":151},{"$f":"_xlfn.PERCENTILE.INC(tblInvul[Totaal aantal koeien], 0.25)","v":88},{"$f":"AVERAGE(tblInvul[Totaal aantal koeien])","v":132.85714285714286},{"$f":"_xlfn.PERCENTILE.INC(tblInvul[Totaal aantal koeien], 0.75)","v":171.25}]
[]
["DDD Bedrijf",{"$f":"_xlfn.XLOOKUP($B$2, tblInvul[Bedrijfsnr], tblInvul[DDD Bedrijf])","v":2.0699999999999998},{"$f":"_xlfn.PERCENTILE.INC(tblInvul[DDD Bedrijf], 0.25)","v":1.41},{"$f":"AVERAGE(Invulsheet!L8:L18)","v":2.0690909090909089},{"$f":"_xlfn.PERCENTILE.INC(Invulsheet!L8:L18, 0.75)","v":2.415}]
["DDD Mastitis injectoren",{"$f":"_xlfn.XLOOKUP($B$2, tblInvul[Bedrijfsnr], tblInvul[DDD Mastitis injectoren])","v":0.28999999999999998},{"$f":"_xlfn.PERCENTILE.INC(tblInvul[DDD Mastitis injectoren], 0.25)","v":0.1825},{"$f":"AVERAGE(tblInvul[DDD Mastitis injectoren])","v":0.375},{"$f":"_xlfn.PERCENTILE.INC(tblInvul[DDD Mastitis injectoren], 0.75)","v":0.5}]
["DDD Droogzetters",{"$f":"_xlfn.XLOOKUP($B$2, tblInvul[Bedrijfsnr], tblInvul[DDD Droogzetters])","v":0.89},{"$f":"_xlfn.PERCENTILE.INC(tblInvul[DDD Droogzetters], 0.25)","v":0.83000000000000007},{"$f":"AVERAGE(tblInvul[DDD Droogzetters])","v":1.0714285714285714},{"$f":"_xlfn.PERCENTILE.INC(tblInvul[DDD Droogzetters], 0.75)","v":1.3375000000000001}]
["DDD Injectie",{"$f":"_xlfn.XLOOKUP($B$2, tblInvul[Bedrijfsnr], tblInvul[DDD Injectie])","v":0.78},{"$f":"_xlfn.PERCENTILE.INC(tblInvul[DDD Injectie], 0.25)","v":0.21250000000000002},{"$f":"AVERAGE(tblInvul[DDD Injectie])","v":0.60214285714285709},{"$f":"_xlfn.PERCENTILE.INC(tblInvul[DDD Injectie], 0.75)","v":0.76}]
["Avuloxil behandelingen (3/beh)",{"$f":"_xlfn.XLOOKUP($B$2, tblInvul[Bedrijfsnr], tblInvul[Avuloxil behandelingen (3/beh)])","v":9}]
["Ubropen behandelingen (2/beh)",{"$f":"_xlfn.XLOOKUP($B$2, tblInvul[Bedrijfsnr], tblInvul[Ubropen behandelingen (3/beh)])","v":0}]
["Albiotic behandelingen (3/beh)",{"$f":"_xlfn.XLOOKUP($B$2, tblInvul[Bedrijfsnr], tblInvul[Albiotic behandelingen (3/beh)])","v":0}]
["Ubrolexin behandelingen (2/beh)",{"$f":"_xlfn.XLOOKUP($B$2, tblInvul[Bedrijfsnr], tblInvul[Ubrolexin behandelingen (2/beh)])","v":0}]
["Orbenin lactation behandelingen (3/beh)",{"$f":"_xlfn.XLOOKUP($B$2, tblInvul[Bedrijfsnr], tblInvul[Orbenin lactation behandelingen (3/beh)])","v":8}]
["Totaal aantal behandelingen",{"$f":"_xlfn.XLOOKUP($B$2, tblInvul[Bedrijfsnr], tblInvul[Totaal aantal behandelingen (Medirund)])","v":17},{"$f":"_xlfn.PERCENTILE.INC(tblInvul[Totaal aantal behandelingen (Medirund)], 0.25)","v":9},{"$f":"AVERAGE(tblInvul[Totaal aantal behandelingen (Medirund)])","v":27.666666666666664},{"$f":"_xlfn.PERCENTILE.INC(tblInvul[Totaal aantal behandelingen (Medirund)], 0.75)","v":38.5}]
["% mastitisbehandeling (obv Medirund)",{"$f":"_xlfn.XLOOKUP($B$2, tblInvul[Bedrijfsnr], tblInvul[% Mastitis behandeling (obv Medirund)])","v":11.258278145695364},{"$f":"_xlfn.PERCENTILE.INC(tblInvul[% Mastitis behandeling (obv Medirund)], 0.25)","v":10.314569536423841},{"$f":"AVERAGE(tblInvul[% Mastitis behandeling (obv Medirund)])","v":19.958225120938032},{"$f":"_xlfn.PERCENTILE.INC(tblInvul[% Mastitis behandeling (obv Medirund)], 0.75)","v":24.864393645873694}]
["Aantal BO/jaar",{"$f":"_xlfn.XLOOKUP($B$2, tblInvul[Bedrijfsnr], tblInvul[Aantal BO/jaar])","v":3},null,{"$f":"AVERAGE(tblInvul[Aantal BO/jaar])","v":4.5}]
["% 1e keus uierinjector",{"$f":"_xlfn.XLOOKUP($B$2, tblInvul[Bedrijfsnr], tblInvul[% 1e keus uierinjector])","v":47.058823529411761},{"$f":"_xlfn.PERCENTILE.INC(tblInvul[% 1e keus uierinjector], 0.25)","v":0},{"$f":"AVERAGE(tblInvul[% 1e keus uierinjector])","v":23.772547446145573},{"$f":"_xlfn.PERCENTILE.INC(tblInvul[% 1e keus uierinjector], 0.75)","v":38.095238095238095}]
["% 2e keus uierinjector",{"$f":"_xlfn.XLOOKUP($B$2, tblInvul[Bedrijfsnr], tblInvul[% 2e keus uierinjector])","v":52.941176470588239},{"$f":"_xlfn.PERCENTILE.INC(tblInvul[% 2e keus uierinjector], 0.25)","v":53.594771241830067},{"$f":"AVERAGE(tblInvul[% 2e keus uierinjector])","v":69.084595410997295},{"$f":"_xlfn.PERCENTILE.INC(tblInvul[% 2e keus uierinjector], 0.75)","v":100}]
[]
["Tankcelgetal",{"$f":"_xlfn.XLOOKUP($B$2, tblInvul[Bedrijfsnr], tblInvul[Tankcelgetal])","v":64},{"$f":"_xlfn.PERCENTILE.INC(tblInvul[Tankcelgetal], 0.25)","v":145.75},{"$f":"AVERAGE(tblInvul[Tankcelgetal])","v":192},{"$f":"_xlfn.PERCENTILE.INC(Invulsheet!BB8:BB18, 0.75)","v":248.5}]
["% koeien drooggezet",{"$f":"_xlfn.XLOOKUP($B$2, tblInvul[Bedrijfsnr], tblInvul[% koeien drooggezet])","v":31.788079470198678},{"$f":"_xlfn.PERCENTILE.INC(tblInvul[% koeien drooggezet], 0.25)","v":11.848314606741573},{"$f":"AVERAGE(tblInvul[% koeien drooggezet])","v":23.626045584123208},{"$f":"_xlfn.PERCENTILE.INC(tblInvul[% koeien drooggezet], 0.75)","v":32.492474413004217}]
["% koeien gesealed",{"$f":"_xlfn.XLOOKUP($B$2, tblInvul[Bedrijfsnr], tblInvul[% koeien gesealed])","v":58.940397350993379},{"$f":"_xlfn.PERCENTILE.INC(tblInvul[% koeien gesealed], 0.25)","v":0},{"$f":"AVERAGE(Invulsheet!AZ8:AZ18)","v":32.030124175724843},{"$f":"_xlfn.PERCENTILE.INC(Invulsheet!AZ8:AZ18, 0.75)","v":65.47019867549669}]
["% nieuw verhoogd",{"$f":"_xlfn.XLOOKUP($B$2, tblInvul[Bedrijfsnr], tblInvul[% Nieuw verhoogd])","v":4},{"$f":"_xlfn.PERCENTILE.INC(tblInvul[% Nieuw verhoogd], 0.25)","v":6},{"$f":"AVERAGE(tblInvul[% Nieuw verhoogd])","v":9.2857142857142865},{"$f":"_xlfn.PERCENTILE.INC(tblInvul[% Nieuw verhoogd], 0.75)","v":13}]
["% verhoogd",{"$f":"_xlfn.XLOOKUP($B$2, tblInvul[Bedrijfsnr], tblInvul[% Verhoogd])","v":4},{"$f":"_xlfn.PERCENTILE.INC(tblInvul[% Verhoogd], 0.25)","v":11.25},{"$f":"AVERAGE(tblInvul[% Verhoogd])","v":14.785714285714286},{"$f":"_xlfn.PERCENTILE.INC(tblInvul[% Verhoogd], 0.75)","v":19}]
[]
["DS % Genezen",{"$f":"_xlfn.XLOOKUP($B$2, tblInvul[Bedrijfsnr], tblInvul[DS % Genezen])","v":91},{"$f":"_xlfn.PERCENTILE.INC(tblInvul[DS % Genezen], 0.25)","v":72.25},{"$f":"AVERAGE(tblInvul[DS % Genezen])","v":76.214285714285708},{"$f":"_xlfn.PERCENTILE.INC(tblInvul[DS % Genezen], 0.75)","v":81.5}]
["DS % Nieuwe infecties",{"$f":"_xlfn.XLOOKUP($B$2, tblInvul[Bedrijfsnr], tblInvul[DS % Nieuwe infecties])","v":8},{"$f":"_xlfn.PERCENTILE.INC(tblInvul[DS % Nieuwe infecties], 0.25)","v":11.5},{"$f":"AVERAGE(tblInvul[DS % Nieuwe infecties])","v":18.357142857142858},{"$f":"_xlfn.PERCENTILE.INC(tblInvul[DS % Nieuwe infecties], 0.75)","v":24}]

{"sheet":"Veehouder2","index":3,"n_rows":39,"n_cols":2,"rows_kept":39,"cut":false,"hidden":false,"merged":[]}
["Praktijk:",{"$error":"#VALUE!"}]
["Datum:",{"$f":"TODAY()","v":"2026-04-10"}]
["Bedrijfsnr",3]
["Dierenarts",{"$f":"_xlfn.XLOOKUP($B$3, tblInvul[Bedrijfsnr], tblInvul[Dierenarts])","v":"CC"}]
["Naam veehouder",{"$f":"_xlfn.XLOOKUP($B$3, tblInvul[Bedrijfsnr], tblInvul[Naam])","v":"Berkers"}]
[]
["Kengetal","Bedrijf"]
["Totaal aantal koeien",{"$f":"_xlfn.XLOOKUP($B$3, tblInvul[Bedrijfsnr], tblInvul[Totaal aantal koeien])","v":151}]
["Tankcelgetal",{"$f":"_xlfn.XLOOKUP($B$3, tblInvul[Bedrijfsnr], tblInvul[Tankcelgetal])","v":64}]
["% verhoogd",{"$f":"_xlfn.XLOOKUP($B$3, tblInvul[Bedrijfsnr], tblInvul[% Verhoogd])","v":4}]
["% nieuw verhoogd",{"$f":"_xlfn.XLOOKUP($B$3, tblInvul[Bedrijfsnr], tblInvul[% Nieuw verhoogd])","v":4}]
[]
["DDD Bedrijf",{"$f":"_xlfn.XLOOKUP($B$3, tblInvul[Bedrijfsnr], tblInvul[DDD Bedrijf])","v":2.0699999999999998}]
["DDD Droogzetters",{"$f":"_xlfn.XLOOKUP($B$3, tblInvul[Bedrijfsnr], tblInvul[DDD Droogzetters])","v":0.89}]
["DDD Injectie",{"$f":"_xlfn.XLOOKUP($B$3, tblInvul[Bedrijfsnr], tblInvul[DDD Injectie])","v":0.78}]
["DDD Mastitis injectoren",{"$f":"_xlfn.XLOOKUP($B$3, tblInvul[Bedrijfsnr], tblInvul[DDD Mastitis injectoren])","v":0.28999999999999998}]
[]
["Avuloxil behandelingen (3/beh)",{"$f":"_xlfn.XLOOKUP($B$3, tblInvul[Bedrijfsnr], tblInvul[Avuloxil behandelingen (3/beh)])","v":9}]
["Ubropen behandelingen (2/beh)",{"$f":"_xlfn.XLOOKUP($B$3, tblInvul[Bedrijfsnr], tblInvul[Ubropen behandelingen (3/beh)])","v":0}]
["Ubrolexin behandelingen (2/beh)",{"$f":"_xlfn.XLOOKUP($B$3, tblInvul[Bedrijfsnr], tblInvul[Ubrolexin behandelingen (2/beh)])","v":0}]
["Albiotic behandelingen (3/beh)",{"$f":"_xlfn.XLOOKUP($B$3, tblInvul[Bedrijfsnr], tblInvul[Albiotic behandelingen (3/beh)])","v":0}]
["Orbenin lactation behandelingen (3/beh)",{"$f":"_xlfn.XLOOKUP($B$3, tblInvul[Bedrijfsnr], tblInvul[Orbenin lactation behandelingen (3/beh)])","v":8}]
["Totaal aantal behandelingen",{"$f":"_xlfn.XLOOKUP($B$3, tblInvul[Bedrijfsnr], tblInvul[Totaal aantal behandelingen (Medirund)])","v":17}]
[]
["% mastitisbehandeling (obv Medirund)",{"$f":"_xlfn.XLOOKUP($B$3, tblInvul[Bedrijfsnr], tblInvul[% Mastitis behandeling (obv Medirund)])","v":11.258278145695364}]
["Aantal BO/jaar",{"$f":"_xlfn.XLOOKUP($B$3, tblInvul[Bedrijfsnr], tblInvul[Aantal BO/jaar])","v":3}]
["% 1e keus uierinjector",{"$f":"_xlfn.XLOOKUP($B$3, tblInvul[Bedrijfsnr], tblInvul[% 1e keus uierinjector])","v":47.058823529411761}]
["% 2e keus uierinjector",{"$f":"_xlfn.XLOOKUP($B$3, tblInvul[Bedrijfsnr], tblInvul[% 2e keus uierinjector])","v":52.941176470588239}]
[]
[]
[]
[]
[]
[]
[]
["% koeien drooggezet",{"$f":"_xlfn.XLOOKUP($B$3, tblInvul[Naam], tblInvul[% koeien drooggezet])","v":{"$error":"#N/A"}}]
["% koeien gesealed",{"$f":"_xlfn.XLOOKUP($B$3, tblInvul[Naam], tblInvul[% koeien gesealed])","v":{"$error":"#N/A"}}]
["DS % Nieuwe infecties",{"$f":"_xlfn.XLOOKUP($B$3, tblInvul[Naam], tblInvul[DS % Nieuwe infecties])","v":{"$error":"#N/A"}}]
["DS % Genezen",{"$f":"_xlfn.XLOOKUP($B$3, tblInvul[Naam], tblInvul[DS % Genezen])","v":{"$error":"#N/A"}}]

{"sheet":"Robotmelken en uiergezondheid","index":4,"n_rows":6,"n_cols":11,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
["Robot","Ja/Nee"]
[]
["Rijlabels","Aantal bedrijven","Gemiddelde van DDD Bedrijf","Gemiddelde van DDD Droogzetters","Gemiddelde van % koeien drooggezet","Gemiddelde van % koeien gesealed","Gemiddelde van DDD Mastitis injectoren","Gemiddelde van % Mastitis behandeling (obv Medirund)","Gemiddelde van % 1e keus uierinjector","Gemiddelde van % 2e keus uierinjector","Gemiddelde van DDD Injectie"]
["Ja",8,2.1025,1.0462499999999999,19.977724845865293,26.660081491542165,0.41125,21.447924102960517,20.838652708625897,66.661347291374099,0.63375000000000004]
["Nee",6,2.0816666666666666,1.105,28.490473235133759,40.005217740317086,0.32666666666666666,17.971959811574724,27.6844070961718,72.315592903828204,0.56000000000000005]
["Eindtotaal",14,2.0935714285714284,1.0714285714285714,23.626045584123208,32.379425598159983,0.375,19.958225120938032,23.77254744614557,69.084595410997295,0.60214285714285709]

{"sheet":"Eerste Tweede keuze","index":5,"n_rows":22,"n_cols":8,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
[]
["Dierenarts","(Alle)"]
["Robot","(Alle)"]
["Biologisch","(Alle)"]
["Vaccinatie","(Alle)"]
[]
["Rijlabels","DD Mastitis injectoren","% behandeling mastitis","% 1e keuze uierinjector","% 2e keuze uierinjector","DD Droogzetters","% drooggezet","% gesealed"]
[1,0.11,10,0,100,0,0,0]
[2,0.33,25.287356321839084,0,100,1.56,51.724137931034484,0]
[3,0.28999999999999998,11.258278145695364,47.058823529411761,52.941176470588239,0.89,31.788079470198678,58.940397350993379]
[4,0.14000000000000001,12.631578947368421,0,100,1.67,33.157894736842103,0]
[5,0.54,36.363636363636367,0,100,0.96,32.727272727272727,81.818181818181827]
[6,0.16,3.2,100,0,1.05,12,72]
[7,0,0,0,0,1.19,16.483516483516482,3.296703296703297]
[8,0.27,22.857142857142858,0,100,1.36,21.428571428571427,85.714285714285708]
[9,1.1200000000000001,69.850187265917597,3.2171581769436997,96.782841823056302,1.01,8.4269662921348321,50.561797752808992]
[10,0.32,7.4766355140186906,100,0,0.81,19.626168224299064,0]
[11,0.72,26.47058823529412,44.444444444444443,55.555555555555557,1.27,22.058823529411764,0]
[12,0.5,23.595505617977526,19.047619047619047,80.952380952380949,0.5,11.797752808988763,33.707865168539328]
[13,0.5,19.090909090909093,19.047619047619047,80.952380952380949,0.5,9.5454545454545467,27.27272727272727]
[14,0.25,11.333333333333332,0,100,2.23,60,40]
["Eindtotaal",5.25,279.41515169313243,332.81566424603801,967.18433575396205,15,330.76463817772492,453.31195837423985]

{"sheet":"DAP","index":6,"n_rows":8,"n_cols":6,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
["Naam","(Alle)"]
["Dierenarts","(Alle)"]
["Biologisch","(Alle)"]
["Vaccinatie","(Alle)"]
["Robot","(Alle)"]
[]
["Gemiddelde van DDD Droogzetters","Gemiddelde van % koeien drooggezet","Gemiddelde van % koeien gesealed","Gemiddelde van DDD Mastitis injectoren","Gemiddelde van % Mastitis behandeling (obv Medirund)","Som van % 2e keus uierinjector"]
[1.0714285714285714,23.626045584123208,32.37942559815999,0.375,19.958225120938032,967.18433575396205]

{"sheet":"Praktijk DDD","index":7,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Praktijk Mastitis","index":8,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Praktijk Celgetal","index":9,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Praktijk Droogstand","index":10,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}