{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["kostenbaten prod teelten","kostenbaten niet prod teelt","dashboard"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":0,"defined_names":5,"comments":2,"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":"kostenbaten prod teelten","index":0,"n_rows":49,"n_cols":44,"rows_kept":49,"cut":false,"hidden":true,"merged":[[0,37,0,42],[24,38,24,43],[25,16,25,22],[25,23,25,29],[24,17,24,22],[24,24,24,29],[24,31,24,36],[0,23,0,28],[0,30,0,35],[1,0,1,1],[19,1,20,1],[0,0,0,1],[0,16,0,21],[25,30,25,36],[0,9,0,14],[24,10,24,15],[25,9,25,15],[0,2,0,7],[24,3,24,8],[25,2,25,8]]}
["Dit rekenblad werd ontwikkeld in het kader van de projecten 'Dorp van de 7 Neten, proeftuin voor agrobiodiversiteit' ",null,"RODE KLAVER 3j 4 sn",null,null,null,null,null,"indien op-brengst lager","GRASKLAVER (5 snedes maaien , derogatie)",null,null,null,null,null,"indien op-brengst lager","GRAS (5 snedes maaien , derogatie)",null,null,null,null,null,"indien op-brengst lager","1 snede GRAS + MAIS (derogatie) ",null,null,null,null,null,"indien op-brengst lager","KUILMAIS zonder groenbedekker",null,null,null,null,null,"indien op-brengst lager","KUILMAIS met groenbedekker",null,null,null,null,null,"indien op-brengst lager"]
["en 'Zot van pAtrijs'",null,"hoeveelheid","eenheid","kost /eenheid","kost/ha","aant x/jaar","EUR/ha/jaar",{"$f":"-dashboard!$C$17","v":-0.5},"hoeveelheid","eenheid","kost /eenheid","kost/ha","aant x/jaar","EUR/ha/jaar",{"$f":"-dashboard!$C$17","v":-0.5},"hoeveelheid","eenheid","kost /eenheid","kost/ha","aant x/jaar","EUR/ha/jaar",{"$f":"-dashboard!$C$17","v":-0.5},"hoeveelheid","eenheid","kost /eenheid","kost/ha","aant x/jaar","EUR/ha/jaar",{"$f":"-dashboard!$C$17","v":-0.5},"hoeveelheid","eenheid","kost /eenheid","kost/ha","aant x/jaar","EUR/ha/jaar",{"$f":"-dashboard!$C$17","v":-0.5},"hoeveelheid","eenheid","kost /eenheid","kost/ha","aant x/jaar","EUR/ha/jaar",{"$f":"-dashboard!$C$17","v":-0.5}]
["KOSTEN"]
[null,"Algemene kosten (pacht, analyse, onderhoud grachten, …)",null,null,null,420,1,{"$f":"F4*G4","v":420},{"$f":"H4","v":420},null,null,null,420,1,{"$f":"M4*N4","v":420},{"$f":"O4","v":420},null,null,null,420,1,{"$f":"T4*U4","v":420},{"$f":"V4","v":420},null,null,null,420,1,{"$f":"AA4*AB4","v":420},{"$f":"AC4","v":420},null,null,null,420,1,{"$f":"AH4*AI4","v":420},{"$f":"AJ4","v":420},null,null,null,420,1,{"$f":"AO4*AP4","v":420},{"$f":"AQ4","v":420}]
[null,"Bodembewerking",null,null,null,null,null,{"$f":"25+15","v":40},40,null,null,null,{"$f":"65+75+45","v":185},{"$f":"1/4","v":0.25},46.25,46.25,null,null,null,{"$f":"65+75+45","v":185},{"$f":"1/4","v":0.25},46.25,46.25,null,null,null,210,1,210,210,null,null,null,{"$f":"75+45","v":120},1,120,120,null,null,null,{"$f":"75+45","v":120},1,120,120]
[null,"Zaaizaad (incl. goenbedekker)",15,null,9,{"$f":"C6*E6","v":135},{"$f":"1/3","v":0.33333333333333331},45,45,45,null,6,{"$f":"J6*L6","v":270},{"$f":"1/4","v":0.25},67.5,67.5,45,null,5.4,{"$f":"Q6*S6","v":243.00000000000003},{"$f":"1/4","v":0.25},60.750000000000007,60.750000000000007,1.9,"dosis",95,{"$f":"X6*Z6","v":180.5},1,180.5,180.5,2,"dosis",95,{"$f":"AE6*AG6","v":190},1,190,190,2,"dosis",95,{"$f":"AL6*AN6","v":190},1,190,190]
[null,"Zaaizaad groenbemester",null,null,null,null,null,0,0,null,null,null,null,null,0,0,null,null,null,null,null,0,0,50,"kg/ha",3.5,{"$f":"X7*Z7","v":175},1,175,175,0,"kg/ha",2.2000000000000002,{"$f":"AE7*AG7","v":0},1,0,0,30,"kg/ha",2.2000000000000002,{"$f":"AL7*AN7","v":66},1,66,66]
[null,"Zaaien (incl groenbedekker zaaien)",null,null,null,65,{"$f":"1/3","v":0.33333333333333331},21.666666666666664,21.666666666666664,null,null,null,65,{"$f":"1/4","v":0.25},16.25,16.25,null,null,null,65,{"$f":"1/4","v":0.25},16.25,16.25,null,null,null,{"$f":"55+65","v":120},1,120,120,null,null,null,55,1,55,55,null,null,null,{"$f":"55+45","v":100},1,100,100]
[null,"Gewasbescherming product",null,null,null,{"$f":"25*3","v":75},{"$f":"1/3","v":0.33333333333333331},25,25,null,null,null,60,0.25,15,15,null,null,null,60,0.25,15,15,null,null,null,100,1,100,100,null,null,null,100,1,100,100,null,null,null,100,1,100,100]
[null,"Gewasbescherming toepassing",null,null,null,30,{"$f":"1/3","v":0.33333333333333331},10,10,null,null,null,30,0.25,7.5,7.5,null,null,null,30,0.25,7.5,7.5,null,null,null,30,1,30,30,null,null,null,30,1,30,30,null,null,null,30,1,30,30]
[null,"Klepelen/maaien of vernietigen",null,null,null,0,1,0,0,null,null,null,0,1,0,0,null,null,null,0,1,0,0,null,null,null,0,1,0,0,null,null,null,null,null,0,0,null,null,null,null,null,0,0]
[null,"Oogst",null,null,null,{"$f":"dashboard!D14","v":150},4,{"$f":"F12*G12","v":600},600,null,null,null,{"$f":"dashboard!D14","v":150},{"$f":"dashboard!D15","v":5},750,750,null,null,null,{"$f":"dashboard!D14","v":150},{"$f":"dashboard!D15","v":5},750,750,null,null,null,{"$f":"dashboard!D14+dashboard!C13","v":460},1,{"$f":"AA12*AB12","v":460},{"$f":"AC12","v":460},null,null,null,{"$f":"dashboard!C13","v":310},1,310,310,null,null,null,{"$f":"dashboard!C13","v":310},1,310,310]
[null,"Kunstmest product",null,null,null,245,1,245,245,null,null,null,263,1,263,263,null,null,null,340,1,340,340,null,null,null,{"$f":"53+143","v":196},1,196,196,null,null,null,107,1,107,107,null,null,null,107,1,107,107]
[null,"Kunstmest toepassing",null,null,null,10,2,20,20,null,null,null,10,3,30,30,null,null,null,10,5,50,50,null,null,null,10,3,30,30,null,null,null,10,1,10,10,null,null,null,10,1,10,10]
[null,"Dierlijke mest toepassing",25,null,{"$f":"dashboard!D10","v":4.5},{"$f":"C15*E15","v":112.5},1,112.5,112.5,50,null,{"$f":"dashboard!D10","v":4.5},{"$f":"J15*L15","v":225},1,225,225,50,null,{"$f":"dashboard!D10","v":4.5},{"$f":"Q15*S15","v":225},1,225,225,{"$f":"25+25","v":50},null,{"$f":"AA15/X15","v":4},{"$f":"25*dashboard!D10+25*dashboard!C10","v":200},1,200,200,35,null,{"$f":"dashboard!$C$10","v":3.5},{"$f":"AE15*AG15","v":122.5},1,122.5,122.5,35,null,{"$f":"dashboard!$C$10","v":3.5},{"$f":"AL15*AN15","v":122.5},1,122.5,122.5]
[null,"TOTALE KOSTPRIJS",null,null,null,null,null,{"$f":"SUM(H4:H15)","v":1539.1666666666665},{"$f":"SUM(I4:I15)","v":1539.1666666666665},null,null,null,null,null,{"$f":"SUM(O4:O15)","v":1840.5},{"$f":"SUM(P4:P15)","v":1840.5},null,null,null,null,null,{"$f":"SUM(V4:V15)","v":1930.75},{"$f":"SUM(W4:W15)","v":1930.75},null,null,null,null,null,{"$f":"SUM(AC4:AC15)","v":2121.5},{"$f":"SUM(AD4:AD15)","v":2121.5},null,null,null,null,null,{"$f":"SUM(AJ4:AJ15)","v":1464.5},{"$f":"SUM(AK4:AK15)","v":1464.5},null,null,null,null,null,{"$f":"SUM(AQ4:AQ15)","v":1575.5},{"$f":"SUM(AR4:AR15)","v":1575.5}]
["BATEN"]
[1,"Uitgespaarde kost mestafzet/vergoeding plaatsingsruimte mest",{"$f":"C15","v":25},"m3",{"$f":"dashboard!$C$11","v":14},"EUR/m3",null,{"$f":"C18*E18","v":350},{"$f":"H18","v":350},{"$f":"J15","v":50},"m3",{"$f":"dashboard!$C$11","v":14},"EUR/m3",null,{"$f":"J18*L18","v":700},{"$f":"O18","v":700},{"$f":"Q15","v":50},"m3",{"$f":"dashboard!$C$11","v":14},"EUR/m3",null,{"$f":"Q18*S18","v":700},{"$f":"V18","v":700},{"$f":"X15","v":50},"m3",{"$f":"dashboard!$C$11","v":14},"EUR/m3",null,{"$f":"X18*Z18","v":700},{"$f":"AC18","v":700},35,"m3",{"$f":"dashboard!$C$11","v":14},"EUR/m3",null,{"$f":"AE18*AG18","v":490},{"$f":"AJ18","v":490},35,"m3",{"$f":"dashboard!$C$11","v":14},"EUR/m3",null,{"$f":"AL18*AN18","v":490},{"$f":"AQ18","v":490}]
[{"$f":"IF(dashboard!$L$54=TRUE,0,1)","v":1},"Verkoopwaarde",11,"ton DS/ha",{"$f":"dashboard!D12","v":120},"EUR/ ton DS*",0.1,{"$f":"$A$19*C19*E19","v":1320},{"$f":"C19*(1+I2)*E19*$A19","v":660},12.5,"ton DS/ha",{"$f":"dashboard!D12","v":120},"EUR/ ton DS*",0.1,{"$f":"$A$19*J19*L19","v":1500},{"$f":"J19*(1+P2)*L19*$A19","v":750},{"$f":"dashboard!D16","v":11},"ton DS/ha",{"$f":"dashboard!D12","v":120},"EUR/ ton DS*",0.1,{"$f":"A19*Q19*S19","v":1320},{"$f":"Q19*(1+W2)*S19*$A19","v":660},{"$f":"dashboard!C16+dashboard!D16/5","v":18.899999999999999},"ton DS/ha",{"$f":"AC19/X19","v":102.32804232804233},"EUR/ ton DS*",null,{"$f":"dashboard!C16*dashboard!C12+dashboard!D16/5*dashboard!D12","v":1934},{"$f":"X19*(1+AD2)*Z19*A19","v":966.99999999999989},{"$f":"dashboard!$C$16","v":16.7},"ton DS/ha",{"$f":"dashboard!$C$12","v":100},"EUR/ ton DS*",null,{"$f":"AE19*AG19*$A19","v":1670},{"$f":"AE19*(1+AK2)*AG19*$A19","v":835},{"$f":"dashboard!$C$16","v":16.7},"ton DS/ha",{"$f":"dashboard!$C$12","v":100},"EUR/ ton DS*",null,{"$f":"AL19*AN19*$A19","v":1670},{"$f":"AL19*(1+AR2)*AN19*$A19","v":835}]
[{"$f":"IF(dashboard!$L$54=TRUE,1,0)","v":0},"Voederwaardeopbrengst (voederwaardeprijzen.nl)",730,"VEM",{"$f":"dashboard!$K$22","v":16.138461538461542},"ct/kVEM",{"$f":"(C19*(1-H20)*C20*E20)/100","v":1166.3266153846155},0.1,null,870,"VEM",{"$f":"dashboard!$K$22","v":16.138461538461542},"ct/kVEM",{"$f":"(J19*(1-O20)*J20*L20)/100","v":1579.5519230769235},0.1,null,{"$f":"dashboard!D18","v":900},"VEM",{"$f":"dashboard!$K$22","v":16.138461538461542},"ct/kVEM",{"$f":"(Q19*(1-V20)*Q20*S20)/100","v":1437.9369230769234},0.1,null,{"$f":"(dashboard!C16*dashboard!C18+dashboard!D16/dashboard!D15*dashboard!D18)/(dashboard!C16+dashboard!D16/5)","v":944.17989417989429},"VEM",{"$f":"dashboard!$K$22","v":16.138461538461542},"ct/kVEM",{"$f":"(X19*(1-AC20)*X20*Z20)/100","v":2591.9176153846156},0.1,null,{"$f":"dashboard!$C$18","v":950},"VEM",{"$f":"dashboard!$K$22","v":16.138461538461542},"ct/kVEM",{"$f":"(AE19*(1-AJ20)*AE20*AG20)/100","v":2304.3302307692311},0.1,null,{"$f":"dashboard!$C$18","v":950},"VEM",{"$f":"dashboard!$K$22","v":16.138461538461542},"ct/kVEM",{"$f":"(AL19*(1-AQ20)*AL20*AN20)/100","v":2304.3302307692311},0.1]
[null,null,80,"DVE",{"$f":"dashboard!$K$24","v":66.992307692307676},"ct/kgDVE",{"$f":"C19*(1-H20)*C21*E21/100","v":530.57907692307674},{"$f":"(G20+G21)*$A$20","v":0},{"$f":"H21*(1+I2)","v":0},{"$f":"dashboard!$D$19","v":65},"DVE",{"$f":"dashboard!$K$24","v":66.992307692307676},"ct/kgDVE",{"$f":"J19*(1-O20)*J21*L21/100","v":489.88124999999985},{"$f":"(N20+N21)*$A$20","v":0},{"$f":"O21*(1+P2)","v":0},{"$f":"dashboard!$D$19","v":65},"DVE",{"$f":"dashboard!$K$24","v":66.992307692307676},"ct/kgDVE",{"$f":"Q19*(1-V20)*Q21*S21/100","v":431.0954999999999},{"$f":"(U20+U21)*$A$20","v":0},{"$f":"V21*(1+W2)","v":0},{"$f":"(dashboard!C16*dashboard!C19+dashboard!D16/dashboard!D15*dashboard!D19)/(dashboard!C16+dashboard!D16/dashboard!D15)","v":53.513227513227513},"DVE",{"$f":"dashboard!$K$24","v":66.992307692307676},"ct/kgDVE",{"$f":"X19*(1-AC20)*X21*Z21/100","v":609.80417999999975},{"$f":"(AB20+AB21)*$A$20","v":0},{"$f":"AC21*(1+AD2)","v":0},{"$f":"dashboard!$C$19","v":52},"DVE",{"$f":"dashboard!$K$24","v":66.992307692307676},"ct/kgDVE",{"$f":"AE19*(1-AJ20)*AE21*AG21/100","v":523.58507999999983},{"$f":"(AI20+AI21)*$A$20","v":0},{"$f":"AJ21*(1+AK2)","v":0},{"$f":"dashboard!$C$19","v":52},"DVE",{"$f":"dashboard!$K$24","v":66.992307692307676},"ct/kgDVE",{"$f":"AL19*(1-AQ20)*AL21*AN21/100","v":523.58507999999983},{"$f":"(AP20+AP21)*$A$20","v":0},{"$f":"AQ21*(1+AR2)","v":0}]
[1,"Vergoeding BO, premie, .. (°inkomenssteun+vergroening GLB niet meegerekend)",null,null,null,null,null,450,{"$f":"H22","v":450},null,null,null,null,null,450,{"$f":"O22","v":450},null,null,null,null,null,0,{"$f":"V22","v":0},null,null,null,null,null,0,{"$f":"AC22","v":0},null,null,null,null,null,0,{"$f":"AJ22","v":0},null,null,null,null,null,0,{"$f":"AQ22","v":0}]
[null,"TOTALE OPBRENGST",null,null,null,null,null,{"$f":"SUM(H18:H19,H21:H22)","v":2120},{"$f":"SUM(I18:I19,I21:I22)","v":1460},null,null,null,null,null,{"$f":"SUM(O18:O19,O21:O22)","v":2650},{"$f":"SUM(P18:P19,P21:P22)","v":1900},null,null,null,null,null,{"$f":"SUM(V18:V19,V21:V22)","v":2020},{"$f":"SUM(W18:W19,W21:W22)","v":1360},null,null,null,null,null,{"$f":"SUM(AC18:AC19,AC21:AC22)","v":2634},{"$f":"SUM(AD18:AD19,AD21:AD22)","v":1667},null,null,null,null,null,{"$f":"SUM(AJ18:AJ19,AJ21:AJ22)","v":2160},{"$f":"SUM(AK18:AK19,AK21:AK22)","v":1325},null,null,null,null,null,{"$f":"SUM(AQ18:AQ19,AQ21:AQ22)","v":2160},{"$f":"SUM(AR18:AR19,AR21:AR22)","v":1325}]
["SALDO/ha",null,null,null,null,null,null,{"$f":"H23-H16","v":580.83333333333348},{"$f":"I23-I16","v":-79.166666666666515},null,null,null,null,null,{"$f":"O23-O16","v":809.5},{"$f":"P23-P16","v":59.5},null,null,null,null,null,{"$f":"V23-V16","v":89.25},{"$f":"W23-W16","v":-570.75},null,null,null,null,null,{"$f":"AC23-AC16","v":512.5},{"$f":"AD23-AD16","v":-454.5},null,null,null,null,null,{"$f":"AJ23-AJ16","v":695.5},{"$f":"AK23-AK16","v":-139.5},null,null,null,null,null,{"$f":"AQ23-AQ16","v":584.5},{"$f":"AR23-AR16","v":-250.5}]
["opp EAG",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.3,"ha EAG",null,null,null,null,null,0,"ha EAG",null,null,null,null,null,0,"ha EAG"]
[]
[null,null,"Jaargemiddelde voederwaardeprijzen (ct) 2017",null,null,null,null,null,null,"Jaargemiddelde voederwaardeprijzen (ct) 2017",null,null,null,null,null,null,"Jaargemiddelde voederwaardeprijzen (ct) 2017",null,null,null,null,null,null,"Jaargemiddelde voederwaardeprijzen (ct) 2017"]
[null,null,"kVEM",null,16.138461538461542,"ct/kVEM",null,null,null,"kVEM",null,16.138461538461542,"ct/kVEM",null,null,null,"kVEM",null,16.138461538461542,"ct/kVEM",null,null,null,"kVEM",null,16.138461538461542,"ct/kVEM"]
[null,null,"kgDVE toeslag",null,66.992307692307676,"ct/kgDVE",null,null,null,"kgDVE toeslag",null,66.992307692307676,"ct/kgDVE",null,null,null,"kgDVE toeslag",null,66.992307692307676,"ct/kgDVE",null,null,null,"kgDVE toeslag",null,66.992307692307676,"ct/kgDVE"]
[]
[null,{"$f":"C1","v":"RODE KLAVER 3j 4 sn"}]
[null,"opbrengst DS/ha",{"$f":"C19","v":11},null,null,null,null,null,null,{"$f":"J19","v":12.5},null,null,null,null,null,null,{"$f":"Q19","v":11},null,null,null,null,null,null,{"$f":"X19","v":18.899999999999999},null,null,null,null,null,null,{"$f":"AE19","v":16.7},null,null,null,null,null,null,{"$f":"AL19","v":16.7}]
[null,"VEM",{"$f":"C20","v":730},null,null,null,null,null,null,{"$f":"J20","v":870},null,null,null,null,null,null,{"$f":"Q20","v":900},null,null,null,null,null,null,{"$f":"X20","v":944.17989417989429},null,null,null,null,null,null,{"$f":"AE20","v":950},null,null,null,null,null,null,{"$f":"AL20","v":950}]
[null,"DVE",{"$f":"C21","v":80},null,null,null,null,null,null,{"$f":"J21","v":65},null,null,null,null,null,null,{"$f":"Q21","v":65},null,null,null,null,null,null,{"$f":"X21","v":53.513227513227513},null,null,null,null,null,null,{"$f":"AE21","v":52},null,null,null,null,null,null,{"$f":"AL21","v":52}]
[null,"KOSTEN"]
[null,"algemeen",{"$f":"H4","v":420},null,null,null,null,null,null,{"$f":"O4","v":420},null,null,null,null,null,null,{"$f":"V4","v":420},null,null,null,null,null,null,{"$f":"AC4","v":420},null,null,null,null,null,null,{"$f":"AJ4","v":420},null,null,null,null,null,null,{"$f":"AQ4","v":420}]
[null,"aanleg (bodembewerking, zaai)",{"$f":"H5+H7+H8","v":61.666666666666664},null,null,null,null,null,null,{"$f":"O5+O7+O8","v":62.5},null,null,null,null,null,null,{"$f":"V5+V7+V8","v":62.5},null,null,null,null,null,null,{"$f":"AC5+AC7+AC8","v":505},null,null,null,null,null,null,{"$f":"AJ5+AJ7+AJ8","v":175},null,null,null,null,null,null,{"$f":"AQ5+AQ7+AQ8","v":286}]
[null,"zaaizaad",{"$f":"H6+H7","v":45},null,null,null,null,null,null,{"$f":"O6+O7","v":67.5},null,null,null,null,null,null,{"$f":"V6+V7","v":60.750000000000007},null,null,null,null,null,null,{"$f":"AC6+AC7","v":355.5},null,null,null,null,null,null,{"$f":"AJ6+AJ7","v":190},null,null,null,null,null,null,{"$f":"AQ6+AQ7","v":256}]
[null,"gewasbescherming",{"$f":"H9+H10","v":35},null,null,null,null,null,null,{"$f":"O9+O10","v":22.5},null,null,null,null,null,null,{"$f":"V9+V10","v":22.5},null,null,null,null,null,null,{"$f":"AC9+AC10","v":130},null,null,null,null,null,null,{"$f":"AJ9+AJ10","v":130},null,null,null,null,null,null,{"$f":"AQ9+AQ10","v":130}]
[null,"kunstmest",{"$f":"H13+H14","v":265},null,null,null,null,null,null,{"$f":"O13+O14","v":293},null,null,null,null,null,null,{"$f":"V13+V14","v":390},null,null,null,null,null,null,{"$f":"AC13+AC14","v":226},null,null,null,null,null,null,{"$f":"AJ13+AJ14","v":117},null,null,null,null,null,null,{"$f":"AQ13+AQ14","v":117}]
[null,"dierlijke mest toepassing",{"$f":"H15","v":112.5},null,null,null,null,null,null,{"$f":"O15","v":225},null,null,null,null,null,null,{"$f":"V15","v":225},null,null,null,null,null,null,{"$f":"AC15","v":200},null,null,null,null,null,null,{"$f":"AJ15","v":122.5},null,null,null,null,null,null,{"$f":"AQ15","v":122.5}]
[null,"oogst",{"$f":"H12+H11","v":600},null,null,null,null,null,null,{"$f":"O12+O11","v":750},null,null,null,null,null,null,{"$f":"V12+V11","v":750},null,null,null,null,null,null,{"$f":"AC12+AC11","v":460},null,null,null,null,null,null,{"$f":"AJ12+AJ11","v":310},null,null,null,null,null,null,{"$f":"AQ12+AQ11","v":310}]
[null,"TOTAAL KOSTEN",{"$f":"SUM(C36:C42)","v":1539.1666666666667},null,null,null,null,null,null,{"$f":"SUM(J36:J42)","v":1840.5},null,null,null,null,null,null,{"$f":"SUM(Q36:Q42)","v":1930.75},null,null,null,null,null,null,{"$f":"SUM(X36:X42)","v":2296.5},null,null,null,null,null,null,{"$f":"SUM(AE36:AE42)","v":1464.5},null,null,null,null,null,null,{"$f":"SUM(AL36:AL42)","v":1641.5}]
[null,"BATEN"]
[null,"uitgespaarde mestafzet",{"$f":"H18","v":350},null,null,null,null,null,null,{"$f":"O18","v":700},null,null,null,null,null,null,{"$f":"V18","v":700},null,null,null,null,null,null,{"$f":"AC18","v":700},null,null,null,null,null,null,{"$f":"AJ18","v":490},null,null,null,null,null,null,{"$f":"AQ18","v":490}]
[null,"voederwaardeopbrengst",{"$f":"H21","v":0},null,null,null,null,null,null,{"$f":"O21","v":0},null,null,null,null,null,null,{"$f":"V21","v":0},null,null,null,null,null,null,{"$f":"AC21","v":0},null,null,null,null,null,null,{"$f":"AJ21","v":0},null,null,null,null,null,null,{"$f":"AQ21","v":0}]
[null,"vergoeding of premie",{"$f":"H22","v":450},null,null,null,null,null,null,{"$f":"O22","v":450},null,null,null,null,null,null,{"$f":"V22","v":0},null,null,null,null,null,null,{"$f":"AC22","v":0},null,null,null,null,null,null,{"$f":"AJ22","v":0},null,null,null,null,null,null,{"$f":"AQ22","v":0}]
[null,"TOTAAL BATEN",{"$f":"SUM(C45:C47)","v":800},null,null,null,null,null,null,{"$f":"SUM(J45:J47)","v":1150},null,null,null,null,null,null,{"$f":"SUM(Q45:Q47)","v":700},null,null,null,null,null,null,{"$f":"SUM(X45:X47)","v":700},null,null,null,null,null,null,{"$f":"SUM(AE45:AE47)","v":490},null,null,null,null,null,null,{"$f":"SUM(AL45:AL47)","v":490}]
[null,"SALDO",{"$f":"C48-C43","v":-739.16666666666674},null,null,null,null,null,null,{"$f":"J48-J43","v":-690.5},null,null,null,null,null,null,{"$f":"Q48-Q43","v":-1230.75},null,null,null,null,null,null,{"$f":"X48-X43","v":-1596.5},null,null,null,null,null,null,{"$f":"AE48-AE43","v":-974.5},null,null,null,null,null,null,{"$f":"AL48-AL43","v":-1151.5}]

{"sheet":"kostenbaten niet prod teelt","index":1,"n_rows":49,"n_cols":47,"rows_kept":49,"cut":false,"hidden":true,"merged":[[0,41,0,46],[24,42,24,46],[0,35,0,40],[0,0,0,1],[1,0,1,1],[0,29,0,34],[0,23,0,28],[0,9,0,14],[0,16,0,21],[0,2,0,7],[25,35,25,40],[24,30,24,34],[24,36,24,40],[19,1,20,1],[25,23,25,28],[25,9,25,14],[25,29,25,34],[25,16,25,21],[25,2,25,7]]}
["Dit rekenblad werd ontwikkeld in het kader van de projecten 'Dorp van de 7 Neten, proeftuin voor agrobiodiversiteit' ",null,"BO GRASSTROOK 15/6",null,null,null,null,null,"combinatie met EAG","BO GEMENGDE GRASSTROOK",null,null,null,null,null,"combinatie met EAG","BO BLOEMENSTROOK",null,null,null,null,null,"combinatie met EAG","BO HAAG",null,null,null,null,null,"EAG braak met bloemenmengsel (teeltcode 9832)",null,null,null,null,null,"EAG AKR",null,null,null,null,null,"EAG braak zonder inzaai (teeltcode 89) of bosrand zonder productie"]
["en 'Zot van pAtrijs'",null,"hoeveelheid","eenheid","kost /eenheid","kost/ha","aant x/jaar","EUR/ha/jaar",null,"hoeveelheid","eenheid","kost /eenheid","kost/ha","aant x/jaar","EUR/ha/jaar",null,"hoeveelheid","eenheid","kost /eenheid","kost/ha","aant x/jaar","EUR/ha/jaar",null,"hoeveelheid","eenheid","kost /eenheid","kost/ha","aant x/jaar","EUR/ha/jaar","hoeveelheid","eenheid","kost /eenheid","kost/ha","aant x/jaar","EUR/ha/jaar","hoeveelheid","eenheid","kost /eenheid","kost/ha","aant x/jaar","EUR/ha/jaar","hoeveelheid","eenheid","kost /eenheid","kost/ha","aant x/jaar","EUR/ha/jaar"]
["KOSTEN"]
[null,"Algemene kosten (pacht, analyse, onderhoud grachten, …)",null,null,null,420,1,{"$f":"F4*G4","v":420},{"$f":"H4","v":420},null,null,null,420,1,{"$f":"M4*N4","v":420},{"$f":"O4","v":420},null,null,null,420,1,{"$f":"T4*U4","v":420},{"$f":"V4","v":420},null,null,null,420,1,{"$f":"AA4*AB4","v":420},null,null,null,420,1,{"$f":"AG4*AH4","v":420},null,null,null,420,1,{"$f":"AM4*AN4","v":420},null,null,null,420,1,{"$f":"AS4*AT4","v":420}]
[null,"Bodembewerking",null,null,null,{"$f":"75+45","v":120},{"$f":"1/5","v":0.2},{"$f":"F5*G5","v":24},24,null,null,null,{"$f":"75+45","v":120},{"$f":"1/5","v":0.2},{"$f":"M5*N5","v":24},24,null,null,null,{"$f":"75+45","v":120},1,{"$f":"T5*U5","v":120},120,null,null,null,75,0.2,{"$f":"AA5*AB5","v":15},null,null,null,{"$f":"75+45","v":120},1,{"$f":"AG5*AH5","v":120},null,null,null,{"$f":"75+45","v":120},1,{"$f":"AM5*AN5","v":120},null,null,null,null,null,{"$f":"AS5*AT5","v":0}]
[null,"Zaaizaad",10,"kg/ha",20,{"$f":"C6*E6","v":200},{"$f":"1/5","v":0.2},{"$f":"F6*G6","v":40},40,10,"kg/ha",20,{"$f":"J6*L6","v":200},{"$f":"1/5","v":0.2},{"$f":"M6*N6","v":40},40,20,"kg/ha",10,{"$f":"Q6*S6","v":200},1,{"$f":"T6*U6","v":200},200,null,null,null,{"$f":"560/(90/10000)","v":62222.222222222226},{"$f":"1/15","v":6.6666666666666666E-2},{"$f":"AA6*AB6","v":4148.1481481481487},10,"kg/ha",5.5,{"$f":"AD6*AF6","v":55},1,{"$f":"AG6*AH6","v":55},10,"kg/ha",5.5,{"$f":"AJ6*AL6","v":55},1,{"$f":"AM6*AN6","v":55},null,null,null,null,null,{"$f":"AS6*AT6","v":0}]
[null,"Zaaizaad groenbemester",null,null,null,null,null,0,0,null,null,null,null,null,0,0,null,null,null,null,null,0,0,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,0]
[null,"Zaaien (incl groenbedekker)",null,null,null,65,{"$f":"1/5*1.5","v":0.30000000000000004},{"$f":"F8*G8","v":19.500000000000004},19.500000000000004,null,null,null,65,{"$f":"1/5*1.5","v":0.30000000000000004},{"$f":"M8*N8","v":19.500000000000004},19.500000000000004,null,null,null,65,{"$f":"1*1.5","v":1.5},{"$f":"T8*U8","v":97.5},97.5,null,null,null,null,null,{"$f":"AA8*AB8","v":0},null,null,null,65,1,{"$f":"AG8*AH8","v":65},null,null,null,65,{"$f":"1*1.5","v":1.5},{"$f":"AM8*AN8","v":97.5},null,null,null,null,null,{"$f":"AS8*AT8","v":0}]
[null,"Gewasbescherming product",null,null,null,null,null,0,0,null,null,null,null,null,0,0,null,null,null,null,null,0,0,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,0]
[null,"Gewasbescherming toepassing",null,null,null,null,null,0,0,null,null,null,null,null,0,0,null,null,null,null,null,0,0,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,0]
[null,"Klepelen/maaien of vernietigen",null,null,null,150,1,{"$f":"F11*G11","v":150},150,null,null,null,150,1,{"$f":"M11*N11","v":150},150,null,null,null,150,1,{"$f":"T11*U11","v":150},150,null,null,null,200,1,{"$f":"AA11*AB11","v":200},null,null,null,150,1,{"$f":"AG11*AH11","v":150},null,null,null,150,1,{"$f":"AM11*AN11","v":150},null,null,null,null,null,{"$f":"AS11*AT11","v":0}]
[null,"Oogst",null,null,null,null,null,0,{"$f":"H12","v":0},null,null,null,null,null,0,{"$f":"O12","v":0},null,null,null,null,null,0,{"$f":"V12","v":0},null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,0]
[null,"Kunstmest product",null,null,null,null,null,{"$f":"F13*G13","v":0},{"$f":"H13","v":0},null,null,null,null,null,{"$f":"M13*N13","v":0},0,null,null,null,null,null,{"$f":"T13*U13","v":0},0,null,null,null,null,null,{"$f":"AA13*AB13","v":0},null,null,null,null,null,{"$f":"AG13*AH13","v":0},null,null,null,null,null,{"$f":"AM13*AN13","v":0},null,null,null,null,null,{"$f":"AS13*AT13","v":0}]
[null,"Kunstmest toepassing",null,null,null,null,null,{"$f":"F14*G14","v":0},0,null,null,null,null,null,{"$f":"M14*N14","v":0},0,null,null,null,null,null,{"$f":"T14*U14","v":0},0,null,null,null,null,null,{"$f":"AA14*AB14","v":0},null,null,null,null,null,{"$f":"AG14*AH14","v":0},null,null,null,null,null,{"$f":"AM14*AN14","v":0},null,null,null,null,null,{"$f":"AS14*AT14","v":0}]
[null,"Dierlijke mest toepassing",null,null,null,null,null,{"$f":"F15*G15","v":0},0,null,null,null,null,null,{"$f":"M15*N15","v":0},0,null,null,null,null,null,{"$f":"T15*U15","v":0},0,null,null,null,null,null,{"$f":"AA15*AB15","v":0},null,null,null,null,null,{"$f":"AG15*AH15","v":0},null,null,null,null,null,{"$f":"AM15*AN15","v":0},null,null,null,null,null,{"$f":"AS15*AT15","v":0}]
[null,"TOTALE KOSTPRIJS",null,null,null,null,null,{"$f":"SUM(H4:H15)","v":653.5},{"$f":"SUM(I4:I15)","v":653.5},null,null,null,null,null,{"$f":"SUM(O4:O15)","v":653.5},{"$f":"SUM(P4:P15)","v":653.5},null,null,null,null,null,{"$f":"SUM(V4:V15)","v":987.5},{"$f":"SUM(W4:W15)","v":987.5},null,null,null,null,null,{"$f":"SUM(AC4:AC15)","v":4783.1481481481487},null,null,null,null,null,{"$f":"SUM(AI4:AI15)","v":810},null,null,null,null,null,{"$f":"SUM(AO4:AO15)","v":842.5},null,null,null,null,null,{"$f":"SUM(AU4:AU15)","v":420}]
["BATEN"]
[1,"Uitgespaarde kost mestafzet/vergoeding plaatsingsruimte mest",null,null,null,null,null,0,{"$f":"H18","v":0},null,null,null,null,null,0,{"$f":"O18","v":0},null,null,null,null,null,0,{"$f":"V18","v":0},null,null,null,null,null,0,35,"m3",{"$f":"dashboard!$C$11","v":14},"EUR/ m3",null,{"$f":"AD18*AF18","v":490},35,"m3",{"$f":"dashboard!$C$11","v":14},"EUR/ m3",null,{"$f":"AJ18*AL18","v":490},null,null,null,null,null,{"$f":"AP18*AR18","v":0}]
[{"$f":"IF(dashboard!$L$54=TRUE,0,1)","v":1},"Verkoopwaarde",5.5,"ton DS/ha",90,"EUR/ ton DS*",0.1,{"$f":"$A$19*C19*E19","v":495},{"$f":"H19","v":495},null,null,null,null,null,0,{"$f":"O19","v":0},null,null,null,null,null,0,{"$f":"V19","v":0},null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,0]
[{"$f":"IF(dashboard!$L$54=TRUE,1,0)","v":0},"Voederwaardeopbrengst (voederwaardeprijzen.nl)",600,"VEM",{"$f":"dashboard!$K$22","v":16.138461538461542},"ct/kVEM",{"$f":"(C19*(1-H20)*C20*E20)/100","v":479.3123076923078},0.1,0.1,null,null,null,null,null,null,0,null,null,null,null,null,null,{"$f":"V20","v":0}]
[null,null,47,"DVE",{"$f":"dashboard!$K$24","v":66.992307692307676},"ct/kgDVE",{"$f":"C19*(1-H20)*C21*E21/100","v":155.85760384615381},{"$f":"(G20+G21)*$A$20","v":0},0,null,null,null,null,null,null,0,null,null,null,null,null,null,{"$f":"V21","v":0}]
[1,"Vergoeding BO, premie, .. (°inkomenssteun+vergroening GLB niet meegerekend)",null,null,null,null,null,1317,686,null,null,null,null,null,1812,1181,null,null,null,null,null,1972,1341,null,null,null,null,null,{"$f":"AA31","v":7480},null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,0]
[null,"TOTALE OPBRENGST",null,null,null,null,null,{"$f":"SUM(H18:H22)","v":1812.1},{"$f":"SUM(I18:I19,I21:I22)","v":1181},null,null,null,null,null,{"$f":"SUM(O18:O22)","v":1812},{"$f":"SUM(P18:P19,P21:P22)","v":1181},null,null,null,null,null,{"$f":"SUM(V18:V22)","v":1972},{"$f":"SUM(W18:W19,W21:W22)","v":1341},null,null,null,null,null,{"$f":"SUM(AC18:AC22)","v":7480},null,null,null,null,null,{"$f":"SUM(AI18:AI22)","v":490},null,null,null,null,null,{"$f":"SUM(AO18:AO22)","v":490},null,null,null,null,null,{"$f":"SUM(AU18:AU22)","v":0}]
["SALDO/ha",null,null,null,null,null,null,{"$f":"H23-H16","v":1158.5999999999999},{"$f":"I23-I16","v":527.5},null,null,null,null,null,{"$f":"O23-O16","v":1158.5},{"$f":"P23-P16","v":527.5},null,null,null,null,null,{"$f":"V23-V16","v":984.5},{"$f":"W23-W16","v":353.5},null,null,null,null,null,{"$f":"AC23-AC16","v":2696.8518518518513},null,null,null,null,null,{"$f":"AI23-AI16","v":-320},null,null,null,null,null,{"$f":"AO23-AO16","v":-352.5},null,null,null,null,null,{"$f":"AU23-AU16","v":-420}]
["opp EAG",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,"ha EAG",null,null,null,null,1.5,"ha EAG",null,null,null,null,1,"ha EAG"]
[null,null,"strook van 6m, of 1,67 km voor 1 ha",null,null,null,null,null,null,"strook van 6m, of 1,67 km voor 1 ha",null,null,null,null,null,null,"strook van 6m, of 1,67 km voor 1 ha",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"strook van 6m, of 1,67 km voor 1 ha, perceel apart intekenen"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.87,"EUR/l m"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.5,"m breed"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AA28/AA29","v":0.748},"EUR/m2"]
[null,{"$f":"C1","v":"BO GRASSTROOK 15/6"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AA30*10000","v":7480},"EUR/ha"]
[null,"opbrengst DS/ha",{"$f":"C19","v":5.5},"bron nvzv studiedag, LCV 02 geel slechts 4 ton",null,null,null,null,null,{"$f":"J19","v":0},null,null,null,null,null,null,{"$f":"Q19","v":0},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AD19","v":0},null,null,null,null,null,{"$f":"AJ19","v":0},null,null,null,null,null,{"$f":"AP19","v":0}]
[null,"VEM",{"$f":"C20","v":600},"bron nvwv studiedag, LCV 02 geel slechts 600",null,null,null,null,null,{"$f":"J20","v":0},null,null,null,null,null,null,{"$f":"Q20","v":0},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AD20","v":0},null,null,null,null,null,{"$f":"AJ20","v":0},null,null,null,null,null,{"$f":"AP20","v":0}]
[null,"DVE",{"$f":"C21","v":47},"bron nvew studiedag, LCV 02 geel selchts 12% RE of 45",null,null,null,null,null,{"$f":"J21","v":0},null,null,null,null,null,null,{"$f":"Q21","v":0},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AD21","v":0},null,null,null,null,null,{"$f":"AJ21","v":0},null,null,null,null,null,{"$f":"AP21","v":0}]
[null,"KOSTEN"]
[null,"algemeen",{"$f":"H4","v":420},null,null,null,null,null,null,{"$f":"O4","v":420},null,null,null,null,null,null,{"$f":"V4","v":420},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AI4","v":420},null,null,null,null,null,{"$f":"AO4","v":420},null,null,null,null,null,{"$f":"AU4","v":420}]
[null,"aanleg (bodembewerking, zaai)",{"$f":"H5+H7+H8","v":43.5},null,null,null,null,null,null,{"$f":"O5+O7+O8","v":43.5},null,null,null,null,null,null,{"$f":"V5+V7+V8","v":217.5},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AI5+AI7+AI8","v":185},null,null,null,null,null,{"$f":"AO5+AO7+AO8","v":217.5},null,null,null,null,null,{"$f":"AU5+AU7+AU8","v":0}]
[null,"zaaizaad",{"$f":"H6+H7","v":40},null,null,null,null,null,null,{"$f":"O6+O7","v":40},null,null,null,null,null,null,{"$f":"V6+V7","v":200},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AI6+AI7","v":55},null,null,null,null,null,{"$f":"AO6+AO7","v":55},null,null,null,null,null,{"$f":"AU6+AU7","v":0}]
[null,"gewasbescherming",{"$f":"H9+H10","v":0},null,null,null,null,null,null,{"$f":"O9+O10","v":0},null,null,null,null,null,null,{"$f":"V9+V10","v":0},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AI9+AI10","v":0},null,null,null,null,null,{"$f":"AO9+AO10","v":0},null,null,null,null,null,{"$f":"AU9+AU10","v":0}]
[null,"kunstmest",{"$f":"H13+H14","v":0},null,null,null,null,null,null,{"$f":"O13+O14","v":0},null,null,null,null,null,null,{"$f":"V13+V14","v":0},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AI13+AI14","v":0},null,null,null,null,null,{"$f":"AO13+AO14","v":0},null,null,null,null,null,{"$f":"AU13+AU14","v":0}]
[null,"dierlijke mest toepassing",{"$f":"H15","v":0},null,null,null,null,null,null,{"$f":"O15","v":0},null,null,null,null,null,null,{"$f":"V15","v":0},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AI15","v":0},null,null,null,null,null,{"$f":"AO15","v":0},null,null,null,null,null,{"$f":"AU15","v":0}]
[null,"oogst",{"$f":"H12+H11","v":150},null,null,null,null,null,null,{"$f":"O12+O11","v":150},null,null,null,null,null,null,{"$f":"V12+V11","v":150},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AI12+AI11","v":150},null,null,null,null,null,{"$f":"AO12+AO11","v":150},null,null,null,null,null,{"$f":"AU12+AU11","v":0}]
[null,"TOTAAL KOSTEN",{"$f":"SUM(C36:C42)","v":653.5},null,null,null,null,null,null,{"$f":"SUM(J31:J42)","v":653.5},null,null,null,null,null,null,{"$f":"SUM(Q31:Q42)","v":987.5},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(AD31:AD42)","v":810},null,null,null,null,null,{"$f":"SUM(AJ31:AJ42)","v":842.5},null,null,null,null,null,{"$f":"SUM(AP31:AP42)","v":420}]
[null,"BATEN"]
[null,"uitgespaarde mestafzet",{"$f":"H18","v":0},null,null,null,null,null,null,{"$f":"O18","v":0},null,null,null,null,null,null,{"$f":"V18","v":0},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AI18","v":490},null,null,null,null,null,{"$f":"AO18","v":490},null,null,null,null,null,{"$f":"AU18","v":0}]
[null,"voederwaardeopbrengst",{"$f":"H21","v":0},null,null,null,null,null,null,{"$f":"O21","v":0},null,null,null,null,null,null,{"$f":"V21","v":0},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AI21","v":0},null,null,null,null,null,{"$f":"AO21","v":0},null,null,null,null,null,{"$f":"AU21","v":0}]
[null,"vergoeding of premie",{"$f":"H22","v":1317},null,null,null,null,null,null,{"$f":"O22","v":1812},null,null,null,null,null,null,{"$f":"V22","v":1972},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AI22","v":0},null,null,null,null,null,{"$f":"AO22","v":0},null,null,null,null,null,{"$f":"AU22","v":0}]
[null,"TOTAAL BATEN",{"$f":"SUM(C45:C47)","v":1317},null,null,null,null,null,null,{"$f":"SUM(J45:J47)","v":1812},null,null,null,null,null,null,{"$f":"SUM(Q45:Q47)","v":1972},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(AD45:AD47)","v":490},null,null,null,null,null,{"$f":"SUM(AJ45:AJ47)","v":490},null,null,null,null,null,{"$f":"SUM(AP45:AP47)","v":0}]
[null,"SALDO",{"$f":"C48-C43","v":663.5},null,null,null,null,null,null,{"$f":"J48-J43","v":1158.5},null,null,null,null,null,null,{"$f":"Q48-Q43","v":984.5},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AD48-AD43","v":-320},null,null,null,null,null,{"$f":"AJ48-AJ43","v":-352.5},null,null,null,null,null,{"$f":"AP48-AP43","v":-420}]

{"sheet":"dashboard","index":2,"n_rows":86,"n_cols":20,"rows_kept":86,"cut":false,"hidden":false,"merged":[[24,2,24,3],[60,4,60,5],[60,6,60,7],[33,2,33,3],[33,4,33,5],[33,6,33,7],[48,2,48,3],[48,4,48,5],[48,6,48,7],[44,4,44,5],[45,4,45,5],[47,4,47,5],[49,4,49,5],[47,6,47,7],[49,6,49,7],[51,2,51,3],[1,4,4,7],[10,9,10,11],[10,2,10,3],[7,9,7,11],[7,2,7,3],[10,5,11,7],[0,1,0,7],[16,9,16,11],[16,2,16,3],[6,0,42,0],[59,4,59,5],[59,6,59,7],[43,2,43,3],[43,4,43,5],[43,6,43,7],[55,2,55,3],[55,4,55,5],[55,6,55,7],[44,2,44,3],[45,2,45,3],[24,4,24,5],[24,6,24,7],[16,5,17,7],[57,2,57,3],[58,2,58,3],[56,11,56,12],[50,6,50,7],[51,6,51,7],[52,6,52,7],[56,2,56,3],[56,6,56,7],[44,6,44,7],[45,6,45,7],[31,8,32,8],[50,4,50,5],[51,4,51,5],[52,4,52,5],[49,2,49,3],[59,13,59,14],[60,11,60,12],[60,13,60,14],[61,1,61,3],[55,9,55,10],[55,11,55,12],[55,13,55,14],[56,9,56,10],[57,11,57,12],[56,13,56,14],[57,9,57,10],[58,11,58,12],[57,13,57,14],[58,9,58,10],[59,11,59,12],[58,13,58,14],[42,8,42,9],[43,0,62,0],[47,2,47,3],[57,4,57,5],[58,4,58,5],[56,4,56,5],[62,6,62,7],[60,1,60,3],[59,1,59,3],[61,4,61,5],[61,6,61,7],[62,1,62,5],[57,6,57,7],[58,6,58,7],[50,2,50,3],[52,2,52,3]]}
[null,"Dit rekenblad werd ontwikkeld in het kader van de projecten 'Dorp van de 7 Neten, proeftuin voor agrobiodiversiteit' "]
[null,null,null,null,"De resultaten van dit rekenblad zijn enkel richtinggevend en passen in een vrijblijvend advies, gebaseerd op gemiddelde cijfers. Hooibeekhoeve kan niet aansprakelijk worden gesteld voor eventuele beslissingen die genomen worden op basis van het uitgebrachte advies"]
[]
[null,"en 'Zot van pAtrijs'"]
[]
[]
["INPUT","1) Pas de kosten en opbrengsten aan, aan je eigen bedrijfssituatie",null,null,null,null,null,null,null,{"$f":"C12*C16","v":1670}]
[null,null,"MIJN BEDRIJF",null,null,null,null,null,null,"standaard waarden"]
[null,"pas cijfers in lichtgeel gekleurde cellen aan","mais","gras",null,null,null,null,null,"mais",null,"gras"]
[null,"kost uitrijden mest per m3",{"$f":"J10","v":3.5},{"$f":"L10","v":4.5},"EUR/m3",null,null,null,null,3.5,null,4.5,"EUR/m3"]
[null,"mestafzet of vergoeding voor mestaanvaarding",{"$f":"J11","v":14},null,"EUR/m3","indien mest gratis wordt uigereden, reken de kost  van het mestrijden bij als vergoeding!",null,null,null,14,null,null,"EUR/m3"]
[null,"aankoop/verkoopprijs",{"$f":"J12","v":100},120,"EUR/kg DS",null,null,null,null,100,null,120,"EUR/kg DS"]
[null,"oogstkost incl. transport",{"$f":"J13","v":310},{"$f":"D14*D15","v":750},"EUR/ha",null,null,null,null,310,null,{"$f":"L14*L15","v":750},"EUR/ha"]
[null,"oogstkost (maaien, schudden, harken, inkuilen)",null,{"$f":"L14","v":150},"EUR/snede",null,null,null,null,null,null,150,"EUR/snede"]
[null,"aantal snedes/jaar",null,{"$f":"L15","v":5},"snedes/jaar","cijfes komen overeen met verkoopprijs mais van",null,null,null,null,null,5,"snedes/jaar"]
[null,"opbrengst kg DS/ha:",{"$f":"J16","v":16.7},{"$f":"L16","v":11},null,{"$f":"C16*C12-C13","v":1360},"EUR/ha op stam",null,null,16.7,null,11]
[null,"% opbrengstderving in randen:",0.5,null,null,"! Niet elke m2 brengt evenveel op, hoeveel lager brengt je 'marginale' opp op?",null,null,null,0.25]
[null,"VEM:",{"$f":"J18","v":950},{"$f":"L18","v":900},null,null,null,null,null,950,null,900]
[null,"DVE:",{"$f":"J19","v":52},{"$f":"L19","v":65},null,"gewogen gemiddelde alle snedes voor gras",null,null,null,52,null,65]
[]
[null,null,null,null,null,null,null,null,null,"Jaargemiddelde voederwaardeprijzen (ct) 2017"]
[null,null,null,null,null,null,null,null,null,"kVEM",16.138461538461542,"ct/kVEM"]
[null,null,null,null,null,null,null,null,null,"kVEM",16.138461538461542,"ct/kVEM","gemiddelde voederwaardeprijzen.nl 2017"]
[null,"2) Vul je oppervlaktes in :",null,null,null,null,null,null,null,"kgDVE toeslag",66.992307692307676,"ct/kgDVE"]
[null,"Productieve opp (ha)","Scenario 1 ",null,"Scenario 2",null,"Scenario 3",null,null,null,null,3]
[null,"vul opp (ha) in licht gekleurde cellen in","100% opbr",{"$f":"-$C$17*100&\"% opbr\"","v":"-50% opbr"},2,{"$f":"-$C$17*100&\"% opbr\"","v":"-50% opbr"},3,{"$f":"-$C$17*100&\"% opbr\"","v":"-50% opbr"},null,"100% opbr",{"$f":"-$C$17*100&\"% opbr\"","v":"-50% opbr"}]
[null,"grasland BG (derogatie)",13.5,null,13.5,null,13.5,null,null,{"$f":"'kostenbaten prod teelten'!V24","v":89.25},{"$f":"'kostenbaten prod teelten'!W24","v":-570.75}]
[null,"grasland niet BG (derogatie)",null,null,null,null,null,null,"vul ook grasklaver of VLI in bij grasland voor EAG check",{"$f":"J27","v":89.25},{"$f":"K27","v":-570.75}]
[null,"mais  zonder GB",11,0.5,11,null,11,null,null,{"$f":"'kostenbaten prod teelten'!AJ24","v":695.5},{"$f":"'kostenbaten prod teelten'!AK24","v":-139.5}]
[null,"mais met GB",10,null,10,null,10,null,null,{"$f":"'kostenbaten prod teelten'!AQ24","v":584.5},{"$f":"'kostenbaten prod teelten'!AR24","v":-250.5}]
[null,"gras+mais (derogatie)",null,null,null,null,null,null,null,{"$f":"'kostenbaten prod teelten'!AC24","v":512.5},{"$f":"'kostenbaten prod teelten'!AD24","v":-454.5}]
[null,"andere teelten",0,null,0,null,0,null,"andere teelten worden niet meegenomen in econ vgl, voor correcte EAG check : gewasgroep areeal mais of gras > andere teelten "]
[null,"Totaal prod opp (excl andere)",{"$f":"SUM(C27:C31)","v":34.5},0.5,34.5,0,34.5,0]
[null,"Niet productieve opp (ha)","Scenario 1 ",null,"Scenario 2",null,"Scenario 3",null,null,"BO/EAG","BO + EAG"]
[null,"vul opp (ha) in licht gekleurde cellen in","BO/EAG","BO + EAG","BO/EAG","BO + EAG","BO/EAG","BO + EAG"]
[null,"BO grasstrook 15/6",0,0,null,null,null,null,null,{"$f":"'kostenbaten niet prod teelt'!H24","v":1158.5999999999999},{"$f":"'kostenbaten niet prod teelt'!I24","v":527.5}]
[null,"BO gemengde grasstrook",0,0,0.5,null,null,0.5,null,{"$f":"'kostenbaten niet prod teelt'!O24","v":1158.5},{"$f":"'kostenbaten niet prod teelt'!P24","v":527.5}]
[null,"BO bloemenstrook",0,0,null,null,null,null,null,{"$f":"'kostenbaten niet prod teelt'!V24","v":984.5},{"$f":"'kostenbaten niet prod teelt'!W24","v":353.5}]
[null,"BO onderhoud haag",0]
[null,"EAG Braak (code 9832)",0,null,null,null,null,null,null,{"$f":"'kostenbaten niet prod teelt'!$AI$24","v":-320}]
[null,"EAG Braak (code 89)",0,null,null,null,null,null,null,{"$f":"'kostenbaten niet prod teelt'!$AU$24","v":-420}]
[null,"EAG AKR",0,null,null,null,null,null,null,{"$f":"'kostenbaten niet prod teelt'!AO24","v":-352.5}]
[null,"TOTAAL areaal     waarvan niet prod",{"$f":"SUM(C27:C32,D27:D32,C36:C42,D36:D38)","v":35},{"$f":"SUM(C36:C42,D36:D38)","v":0},{"$f":"SUM(E27:E32,F27:F32,E36:E42,F36:F38)","v":35},{"$f":"SUM(E36:E42,F36:F38)","v":0.5},{"$f":"SUM(G27:G32,H27:H32,G36:G42,H36:H38)","v":35},{"$f":"SUM(G36:G42,H36:H38)","v":0.5},{"$f":"IF((C43+E43+G43)/3=C43,\"ok\",\"niet gelijk\")","v":"ok"}]
["OUTPUT","3) teeltdiv/EAG check:","Scenario 1 ",null,"Scenario 2",null,"Scenario 3"]
[null,"TOTAAL subs bouwland",{"$f":"C43-C27","v":21.5},null,{"$f":"E43-E27","v":21.5},null,{"$f":"G43-G27","v":21.5}]
[null,"% GRAS",{"$f":"MAX((C28+C27+D27+D28)/C43,(C28+D28+C41)/C45)","v":0.38571428571428573},null,{"$f":"MAX((E28+E27)/E43,(E28+E41)/E45)","v":0.38571428571428573},null,{"$f":"MAX((G28+G27)/G43,(G28+G41)/G45)","v":0.38571428571428573}]
[null,"% grootste gewasgroep",{"$f":"IF((C27+D27+C28+D28)>(C29+D29+C30+D30+C31+D31),\"gras\",\"mais\")","v":"mais"},{"$f":"IF(MAX(C28+D28,C29+D29+C30+D30+C31+D31,C32)<0.75*C45,\"ok\",\"!!\")","v":"!!"},{"$f":"IF((E27+F27+E28+F28)>(E29+F29+E30+F30+E31+F31),\"gras\",\"mais\")","v":"mais"},{"$f":"IF(MAX(E28+F28,E29+F29+E30+F30+E31+F31,E32)<0.75*E45,\"ok\",\"!!\")","v":"!!"},{"$f":"IF((G27+H27+G28+H28)>(G29+H29+G30+H30+G31+H31),\"gras\",\"mais\")","v":"mais"},{"$f":"IF(MAX(G28+H28,G29+H29+G30+H30+G31+H31,G32)<0.75*G45,\"ok\",\"!!\")","v":"!!"}]
[null,"3e teelt?",{"$f":"IF(C45>=30,0.05*C45,\"niet nodig\")","v":"niet nodig"},null,{"$f":"IF(E45>=30,0.05*E45,\"niet nodig\")","v":"niet nodig"},null,{"$f":"IF(G45>=30,0.05*G45,\"niet nodig\")","v":"niet nodig"}]
[null,"teeltdiversificatie ok?",{"$f":"IF(C45<10,\"ok\",IF(C46>0.75,\"ok\",IF(C45<30,IF(D47=\"ok\",\"ok\",\"grootste gewas\"),IF(C32>C48,\"ok\",\"niet ok\"))))","v":"grootste gewas"},null,{"$f":"IF(E45<10,\"ok\",IF(E46>0.75,\"ok\",IF(E45<30,IF(F47=\"ok\",\"ok\",\"grootste gewas\"),IF(E32>E48,\"ok\",\"niet ok\"))))","v":"grootste gewas"},null,{"$f":"IF(G45<10,\"ok\",IF(G46>0.75,\"ok\",IF(G45<30,IF(H47=\"ok\",\"ok\",\"grootste gewas\"),IF(G32>G48,\"ok\",\"niet ok\"))))","v":"grootste gewas"}]
[null,"opp EAG nodig?",{"$f":"IF(C45<10,\"nee\",IF(C46>0.75,\"nee\",C45*0.05))","v":1.075},null,{"$f":"IF(E45<10,\"nee\",IF(E46>0.75,\"nee\",E45*0.05))","v":1.075},null,{"$f":"IF(G45<10,\"nee\",IF(G46>0.75,\"nee\",G45*0.05))","v":1.075},null,"Deze tool omvat niet volgende EAG of agromilieu-maatregelen"]
[null,"overige EAG gerealiseerd op bedrijf",0,null,0,null,0,null,"=EAG opp van grachten, poelen, bomenrij, bomen in groep, bosrand met prod, houtkant, .."]
[null,"EAG gerealiseerd",{"$f":"(C30+D30+C31+D31)*$M$80+(D36+D37+D38)*$M$73+C41*$M$69+C40*$M$82+C42*$M$73+C51","v":3},null,{"$f":"(E30+F30+E31+F31)*$M$80+(F36+F37+F38)*$M$73+E41*$M$69+E40*$M$82+E42*$M$73+E51","v":3},null,{"$f":"(G30+H30+G31+H31)*$M$80+(H36+H37+H38)*$M$73+G41*$M$69+G40*$M$82+G42*$M$73+G51","v":3.75}]
[null,"EAG ok?",{"$f":"IF(C50=\"nee\",\"ja\",IF(C52>=C50,\"ja\",\"nee\"))","v":"ja"},null,{"$f":"IF(E50=\"nee\",\"ja\",IF(E52>=E50,\"ja\",\"nee\"))","v":"ja"},null,{"$f":"IF(G50=\"nee\",\"ja\",IF(G52>=G50,\"ja\",\"nee\"))","v":"ja"},null,null,"kVEM",16.138461538461542,"ct/kVEM"]
[null,null,null,null,null,null,null,null,null,null,"gewassen verkopen",false]
[null,"4) Vergelijk rendabiliteit (/areaal/jaar)"]
[null,null,"Scenario 1 ",null,"Scenario 2",null,"Scenario 3",null,null,"Scenario 1 ",null,"Scenario 2",null,"Scenario 3"]
[null,"SALDO PROD TEELTEN EUR/ha/jaar",{"$f":"J57/(C33+D33)","v":418.01785714285717},null,{"$f":"L57/(E33+F33)","v":426.0978260869565},null,{"$f":"N57/(G33+H33)","v":426.0978260869565},null,null,{"$f":"C27*$J27+D27*$K27+C28*$J28+D28*$K28+C29*$J29+D29*$K29+C30*$J30+D30*$K30+C31*$J31+D31*$K31","v":14630.625},null,{"$f":"E27*$J27+F27*$K27+E28*$J28+F28*$K28+E29*$J29+F29*$K29+E30*$J30+F30*$K30+E31*$J31+F31*$K31","v":14700.375},null,{"$f":"G27*$J27+H27*$K27+G28*$J28+H28*$K28+G29*$J29+H29*$K29+G30*$J30+H30*$K30+G31*$J31+H31*$K31","v":14700.375}]
[null,"SALDO NIET PROD EUR/ha/jaar",{"$f":"IF(D43>0,J58/D43,0)","v":0},null,{"$f":"IF(F43>0,L58/F43,0)","v":1158.5},null,{"$f":"IF(H43>0,N58/H43,0)","v":527.5},null,null,{"$f":"C36*$J36+D36*$K36+C37*$J37+D37*$K37+C38*$J38+D38*$K38+C40*$J40+C41*$J41+C42*$J42","v":0},null,{"$f":"E36*$J36+F36*$K36+E37*$J37+F37*$K37+E38*$J38+F38*$K38+E40*$J40+E41*$J41+E42*$J42","v":579.25},null,{"$f":"G36*$J36+H36*$K36+G37*$J37+H37*$K37+G38*$J38+H38*$K38+G40*$J40+G41*$J41+G42*$J42","v":263.75}]
[null,"TOTAAL TEELTSALDO EUR/ha/jaar",{"$f":"J59/(C33+D33+D43)","v":418.01785714285717},null,{"$f":"L59/(E33+F33+F43)","v":436.56071428571431},null,{"$f":"N59/(G33+H33+H43)","v":427.54642857142858},null,null,{"$f":"J57+J58","v":14630.625},null,{"$f":"L57+L58","v":15279.625},null,{"$f":"N57+N58","v":14964.125}]
[null,"meeropbrengst tov Scen 1 (EUR/ha/jaar)",null,null,{"$f":"L60/(E33+F33+F43)","v":18.542857142857144},null,{"$f":"N60/(G33+H33+H43)","v":9.5285714285714285},null,null,null,null,{"$f":"L59-J59","v":649},null,{"$f":"N59-J59","v":333.5}]
[null,"kost compensatie niet prod. opp. tov Scen 1 (EUR/ha/jaar)",null,null,{"$f":"IF($L$54=FALSE,L61/(E33+F33+F43),\"\")","v":23.857142857142858},null,{"$f":"IF($L$54=FALSE,N61/(G33+H33+H43),\"\")","v":23.857142857142858},null,"geldig als je maar net genoeg voedergewas hebt, kost mais, afwegen of bijproducten goedkoper zijn",null,null,{"$f":"F43*$C$12*$C$16+F33*$C$17*$C$12*$C$16","v":835},null,{"$f":"H43*$C$12*$C$16+H33*$C$17*$C$12*$C$16","v":835}]
[null,"EINDSALDO EUR/ha/jaar tov Scen 1",null,null,{"$f":"IF($L$54=FALSE,E60-E61,\"\")","v":-5.3142857142857132},null,{"$f":"IF($L$54=FALSE,G60-G61,\"\")","v":-14.328571428571429},null,"EINTRESULTAAT inl. compensatie",null,{"$f":"L62/4","v":3611.15625},{"$f":"L59-L61","v":14444.625},null,{"$f":"N59-N61","v":14129.125}]
[null,"EINDSALDO EUR/ha/jaar tov Scen 2",null,null,null,null,{"$f":"G60-E60","v":-9.014285714285716},null,null,null,{"$f":"N62/4","v":3532.28125}]
[null,"exclusief basisbetaling en vergroeningspremie"]
[]
[]
[null,null,null,null,null,null,null,null,null,"invulling EAG","omz factor",null,"weg factor",null,"bemesting","teeltcodes"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"intekenen"]
[null,null,null,null,null,null,null,null,null,"braak",null,null,1,null,"nee","89 braak,98 fauna,9832 bloemen"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"apart perceel"]
[]
[null,null,null,null,null,null,null,null,null,"1m teeltvrije strook",null,null,1.5,null,"nee"]
[null,null,null,null,null,null,null,null,null,"akkerrand",null,null,1.5,null,"volgens wetgeving","82 braak,98 fauna,9831 bloemen, gras",null,null,null,"deel van perceel (automatisch)"]
[null,null,null,null,null,null,null,null,null,"agroforestry",null,null,1,null,null,null,null,null,null,"apart perceel AKR of BO bij VLM"]
[]
[null,null,null,null,null,null,null,null,null,"strook langs bosrand zonder prod",6,null,1.5,null,"nee"]
[null,null,null,null,null,null,null,null,null,"strook langs bosrand met prod",null,null,0.3]
[null,null,null,null,null,null,null,null,null,"korte omloothout",null,null,0.5,null,null,"883, 963"]
[null,null,null,null,null,null,null,null,null,"beboste landbouwgrond",null,null,1]
[null,null,null,null,null,null,null,null,null,"groenbedekking",null,null,0.3,null,null,"nateelt 657, 658, 659, 661, 700"]
[null,null,null,null,null,null,null,null,null,"stikstofbindend gewas",null,null,1,null,null,"43,51,52,53,721,722,723,731,732,744,747"]
[null,null,null,null,null,null,null,null,null,"houtkant/heg",null,null,2,null,0,4]
[null,null,null,null,null,null,null,null,null,"groep bomen",null,null,1.5,null,0,895]
[null,null,null,null,null,null,null,null,null,"bomenrij",null,null,2,null,0,10]
[null,null,null,null,null,null,null,null,null,"poelen",null,null,1.5,null,0,3]
[null,null,null,null,null,null,null,null,null,"grachten",2.5,null,2,null,0,"waterloop tsn 2 en 6m"]