{"text_format":"3","workbook":"xlsx","n_sheets":9,"sheets":["basis","aanvoer gewas","aanvoer mest","aanvoer compost","aanvoer groenbemesters","resultaat","totaal overzicht OSBalans","totaal overzicht Nmineralisatie","tabellen"],"not_rendered":{"images":8,"defined_names":9},"read":"whole","date_system":"1900"}

{"sheet":"basis","index":0,"n_rows":48,"n_cols":4,"rows_kept":48,"merged":[[1,1,1,4],[4,1,4,4],[7,2,7,3],[8,2,8,3],[9,2,9,3],[12,2,12,3]]}
[]
[null,"ORGANISCHE STOFBALANS"]
[]
[]
[null,"basisgegevens"]
[]
[]
[null,"Naam:"]
[null,"Adres:"]
[null,"Postcode + Woonplaats"]
[]
[]
[null,"Naam perceel"]
[]
[null,"Organische stofpercentage van het perceel (gemiddeld)",null,"%"]
[]
[null,null,"verder>>"]
{"$rows_empty":30}
[{"$nulls":3},"organische stofbalans (1/7)"]

{"sheet":"aanvoer gewas","index":1,"n_rows":30,"n_cols":7,"rows_kept":30,"merged":[[1,0,1,6],[9,6,10,6],[11,6,13,6],[14,6,16,6]]}
[]
["ORGANISCHE STOFBALANS"]
[]
[null,"aanvoer gewasresten"]
[]
[null,"vul een volledige rotatie in"]
[null,null,"Jaar aflopend sorteren"]
[]
[null,"jaar","gewas","gewasaanvoer (kg per ha)","beschikbare N (kg per ha)",null,{"$f":"IF(COUNTIF(E10:E19,\"!\")>0,\"Let op!\",\"\")","v":""}]
[null,2012,null,{"$f":"IF(C10=\"\",\"\",VLOOKUP(C10,tabellen!E$3:G$197,2))","v":""},{"$f":"IF(tabellen!AD1=FALSE,IF(C10=\"\",\"\",IF(C11=\"\",VLOOKUP(C10,tabellen!E$3:G$197,3),IF(C12=\"\",VLOOKUP(C11,tabellen!E$3:G$197,3),IF(C13=\"\",VLOOKUP(C12,tabellen!E$3:G$197,3),IF(C14=\"\",VLOOKUP(C13,tabellen!E$3:G$197,3),IF(C15=\"\",VLOOKUP(C14,tabellen!E$3:G$197,3),IF(C16=\"\",VLOOKUP(C15,tabellen!E$3:G$197,3),IF(C17=\"\",VLOOKUP(C16,tabellen!E$3:G$197,3),IF(C18=\"\",VLOOKUP(C17,tabellen!E$3:G$197,3),IF(C19=\"\",VLOOKUP(C18,tabellen!E$3:G$197,3),IF(C19<>\"\",VLOOKUP(C19,tabellen!E$3:G$197,3),0))))))))))),IF(C11=\"\",IF(C10=\"\",0,VLOOKUP(C10,tabellen!E$3:G$197,3)),IF(C11=\"\",0,VLOOKUP(C11,tabellen!E$3:G$197,3))))","v":0},{"$f":"IF(LEFT(C9,8)=\"Grasland\",\"!\",\"\")","v":""},{"$f":"IF(COUNTIF(F10:F19,\"!\")>0,\"Vul 'grasland inzaai najaar' in bij aanvoer groenbemesters.\",\"\")","v":""}]
[null,{"$f":"IF(tabellen!AD$1=TRUE,'aanvoer gewas'!B10-1,B10+1)","v":2011},null,{"$f":"IF(C11=\"\",\"\",VLOOKUP(C11,tabellen!E$3:F$197,2))","v":""},{"$f":"IF(C11=\"\",\"\",IF(tabellen!AD$1=FALSE,IF(C10=\"\",\"\",VLOOKUP(C10,tabellen!E$3:G$197,3)),IF(C12=\"\",VLOOKUP(C$10,tabellen!E$3:G$197,3),VLOOKUP(C12,tabellen!E$3:G$197,3))))","v":""},{"$f":"IF(LEFT(C10,8)=\"Grasland\",\"!\",\"\")","v":""}]
[null,{"$f":"IF(tabellen!AD$1=TRUE,'aanvoer gewas'!B11-1,B11+1)","v":2010},null,{"$f":"IF(C12=\"\",\"\",VLOOKUP(C12,tabellen!E$3:F$197,2))","v":""},{"$f":"IF(C12=\"\",\"\",IF(tabellen!AD$1=FALSE,IF(C11=\"\",\"\",VLOOKUP(C11,tabellen!E$3:G$197,3)),IF(C13=\"\",VLOOKUP(C$10,tabellen!E$3:G$197,3),VLOOKUP(C13,tabellen!E$3:G$197,3))))","v":""},"",{"$f":"IF(COUNTIF(F10:F19,\"!\")>0,\"Let op: kies voor grasland (jaar 1) als het in het voorjaar van dit jaar is ingezaaid. \",\"\")","v":""}]
[null,{"$f":"IF(tabellen!AD$1=TRUE,'aanvoer gewas'!B12-1,B12+1)","v":2009},null,{"$f":"IF(C13=\"\",\"\",VLOOKUP(C13,tabellen!E$3:F$197,2))","v":""},{"$f":"IF(C13=\"\",\"\",IF(tabellen!AD$1=FALSE,IF(C12=\"\",\"\",VLOOKUP(C12,tabellen!E$3:G$197,3)),IF(C14=\"\",VLOOKUP(C$10,tabellen!E$3:G$197,3),VLOOKUP(C14,tabellen!E$3:G$197,3))))","v":""},""]
[null,{"$f":"IF(tabellen!AD$1=TRUE,'aanvoer gewas'!B13-1,B13+1)","v":2008},null,{"$f":"IF(C14=\"\",\"\",VLOOKUP(C14,tabellen!E$3:F$197,2))","v":""},{"$f":"IF(C14=\"\",\"\",IF(tabellen!AD$1=FALSE,IF(C13=\"\",\"\",VLOOKUP(C13,tabellen!E$3:G$197,3)),IF(C15=\"\",VLOOKUP(C$10,tabellen!E$3:G$197,3),VLOOKUP(C15,tabellen!E$3:G$197,3))))","v":""},""]
[null,{"$f":"IF(tabellen!AD$1=TRUE,'aanvoer gewas'!B14-1,B14+1)","v":2007},null,{"$f":"IF(C15=\"\",\"\",VLOOKUP(C15,tabellen!E$3:F$197,2))","v":""},{"$f":"IF(C15=\"\",\"\",IF(tabellen!AD$1=FALSE,IF(C14=\"\",\"\",VLOOKUP(C14,tabellen!E$3:G$197,3)),IF(C16=\"\",VLOOKUP(C$10,tabellen!E$3:G$197,3),VLOOKUP(C16,tabellen!E$3:G$197,3))))","v":""},"",{"$f":"IF(COUNTIF(F10:F19,\"!\")>0,\"Kies voor 'Grasland (jaar 2 of ouder)'  als er voor 1 januari van dit jaar is ingezaaid.\",\"\")","v":""}]
[null,{"$f":"IF(tabellen!AD$1=TRUE,'aanvoer gewas'!B15-1,B15+1)","v":2006},null,{"$f":"IF(C16=\"\",\"\",VLOOKUP(C16,tabellen!E$3:F$197,2))","v":""},{"$f":"IF(C16=\"\",\"\",IF(tabellen!AD$1=FALSE,IF(C15=\"\",\"\",VLOOKUP(C15,tabellen!E$3:G$197,3)),IF(C17=\"\",VLOOKUP(C$10,tabellen!E$3:G$197,3),VLOOKUP(C17,tabellen!E$3:G$197,3))))","v":""},""]
[null,{"$f":"IF(tabellen!AD$1=TRUE,'aanvoer gewas'!B16-1,B16+1)","v":2005},null,{"$f":"IF(C17=\"\",\"\",VLOOKUP(C17,tabellen!E$3:F$197,2))","v":""},{"$f":"IF(C17=\"\",\"\",IF(tabellen!AD$1=FALSE,IF(C16=\"\",\"\",VLOOKUP(C16,tabellen!E$3:G$197,3)),IF(C18=\"\",VLOOKUP(C$10,tabellen!E$3:G$197,3),VLOOKUP(C18,tabellen!E$3:G$197,3))))","v":""},""]
[null,{"$f":"IF(tabellen!AD$1=TRUE,'aanvoer gewas'!B17-1,B17+1)","v":2004},null,{"$f":"IF(C18=\"\",\"\",VLOOKUP(C18,tabellen!E$3:F$197,2))","v":""},{"$f":"IF(C18=\"\",\"\",IF(tabellen!AD$1=FALSE,IF(C17=\"\",\"\",VLOOKUP(C17,tabellen!E$3:G$197,3)),IF(C19=\"\",VLOOKUP(C$10,tabellen!E$3:G$197,3),VLOOKUP(C19,tabellen!E$3:G$197,3))))","v":""},""]
[null,{"$f":"IF(tabellen!AD$1=TRUE,'aanvoer gewas'!B18-1,B18+1)","v":2003},null,{"$f":"IF(C19=\"\",\"\",VLOOKUP(C19,tabellen!E$3:F$197,2))","v":""},{"$f":"IF(C19=\"\",\"\",IF(tabellen!AD$1=FALSE,IF(C18=\"\",\"\",VLOOKUP(C18,tabellen!E$3:G$197,3)),IF(C20=\"\",VLOOKUP(C$10,tabellen!E$3:G$197,3),VLOOKUP(C20,tabellen!E$3:G$197,3))))","v":""},""]
[null,null,"gemiddelde jaarlijkse organische stofaanvoer",{"$f":"AVERAGE(D10:D19)","v":{"$error":"#DIV/0!"}}]
[]
[]
[{"$nulls":3},"<<terug","verder>>"]
[]
[]
[]
[]
[]
[]
[{"$nulls":4},"organische stofbalans (2/7)"]

{"sheet":"aanvoer mest","index":2,"n_rows":24,"n_cols":11,"rows_kept":24,"merged":[[1,1,1,9],[5,3,5,5],[5,6,5,8]]}
[]
[null,"ORGANISCHE STOFBALANS"]
[]
[null,"aanvoer organische mest"]
[]
[{"$nulls":3},"organische mest voorjaar",null,null,"organische mest najaar"]
[null,"jaar","gewas","soort mest","dosering (ton per ha)","N (kg/ton)","soort mest","dosering (ton per ha)","N (kg/ton)","aanvoer eff. org. stof (kg/ha)","beschikbare N (kg/ha)"]
[null,{"$f":"'aanvoer gewas'!B10","v":2012},{"$f":"IF('aanvoer gewas'!C10=\"\",\"\",'aanvoer gewas'!C10)","v":""},null,null,{"$f":"IF(D8=\"\",\"\",VLOOKUP(D8,tabellen!$I$3:$N$24,4))","v":""},null,null,{"$f":"IF(G8=\"\",\"\",VLOOKUP(G8,tabellen!$I$3:$N$24,4))","v":""},{"$f":"IF(C8=\"\",\"\",IF(AND(D8=\"\",G8=\"\"),0,IF(G8=\"\",(VLOOKUP(D8,tabellen!I$3:K$24,3)*E8),IF(D8=\"\",(VLOOKUP(G8,tabellen!I$3:K$24,3)*H8),VLOOKUP(D8,tabellen!I$3:K$24,3)*E8+VLOOKUP(G8,tabellen!I$3:K$24,3)*H8))))","v":""},{"$f":"IF(D8=\"\",IF(tabellen!AD1=FALSE,IF(AND(C8=\"\",G8=\"\"),\"\",IF(AND(C9=\"\",G8<>\"\"),VLOOKUP(G8,tabellen!I$3:N$24,5)*H8*I8,IF(AND(C10=\"\",G9<>\"\"),VLOOKUP(G9,tabellen!I$3:N$24,5)*H9*I9,IF(AND(C11=\"\",G10<>\"\"),VLOOKUP(G10,tabellen!I$3:N$24,5)*H10*I10,IF(AND(C12=\"\",G11<>\"\"),VLOOKUP(G11,tabellen!I$3:N$24,5)*H11*I11,IF(AND(C13=\"\",G12<>\"\"),VLOOKUP(G12,tabellen!I$3:N$24,5)*H12*I12,IF(AND(C14=\"\",G13<>\"\"),VLOOKUP(G13,tabellen!I$3:N$24,5)*H13*I13,IF(AND(C15=\"\",G14<>\"\"),VLOOKUP(G14,tabellen!I$3:N$24,5)*H14*I14,IF(AND(C16=\"\",G15<>\"\"),VLOOKUP(G15,tabellen!I$3:N$24,5)*H15*I15,IF(AND(C17=\"\",G16<>\"\"),VLOOKUP(G16,tabellen!I$3:N$24,5)*H16*I16,IF(AND(C17<>\"\",G17<>\"\"),VLOOKUP(G17,tabellen!I$3:N$24,5)*H17*I17,0))))))))))),IF(C9=\"\",IF(G8=\"\",0,VLOOKUP(G8,tabellen!I$3:N$24,5)*H8*I8),IF(G9=\"\",0,VLOOKUP(G9,tabellen!I$3:N$24,5)*H9*I9))),IF(tabellen!AD1=FALSE,IF(AND(C8=\"\",G8=\"\"),\"\",IF(AND(C9=\"\",G8<>\"\"),VLOOKUP(G8,tabellen!I$3:N$24,5)*H8*I8,IF(AND(C10=\"\",G9<>\"\"),VLOOKUP(G9,tabellen!I$3:N$24,5)*H9*I9,IF(AND(C11=\"\",G10<>\"\"),VLOOKUP(G10,tabellen!I$3:N$24,5)*H10*I10,IF(AND(C12=\"\",G11<>\"\"),VLOOKUP(G11,tabellen!I$3:N$24,5)*H11*I11,IF(AND(C13=\"\",G12<>\"\"),VLOOKUP(G12,tabellen!I$3:N$24,5)*H12*I12,IF(AND(C14=\"\",G13<>\"\"),VLOOKUP(G13,tabellen!I$3:N$24,5)*H13*I13,IF(AND(C15=\"\",G14<>\"\"),VLOOKUP(G14,tabellen!I$3:N$24,5)*H14*I14,IF(AND(C16=\"\",G15<>\"\"),VLOOKUP(G15,tabellen!I$3:N$24,5)*H15*I15,IF(AND(C17=\"\",G16<>\"\"),VLOOKUP(G16,tabellen!I$3:N$24,5)*H16*I16,IF(AND(C17<>\"\",G17<>\"\"),VLOOKUP(G17,tabellen!I$3:N$24,5)*H17*I17,0))))))))))),IF(C9=\"\",IF(G8=\"\",0,VLOOKUP(G8,tabellen!I$3:N$24,5)*H8*I8),IF(G9=\"\",0,VLOOKUP(G9,tabellen!I$3:N$24,5)*H9*I9)))+IF(D8=\"\",\"\",VLOOKUP(D8,tabellen!I$3:N$24,6)*E8*F8))","v":0}]
[null,{"$f":"'aanvoer gewas'!B11","v":2011},{"$f":"IF('aanvoer gewas'!C11=\"\",\"\",'aanvoer gewas'!C11)","v":""},null,null,{"$f":"IF(D9=\"\",\"\",VLOOKUP(D9,tabellen!$I$3:$N$24,4))","v":""},null,null,{"$f":"IF(G9=\"\",\"\",VLOOKUP(G9,tabellen!$I$3:$N$24,4))","v":""},{"$f":"IF(C9=\"\",\"\",IF(AND(D9=\"\",G9=\"\"),0,IF(G9=\"\",(VLOOKUP(D9,tabellen!I$3:K$24,3)*E9),IF(D9=\"\",(VLOOKUP(G9,tabellen!I$3:K$24,3)*H9),VLOOKUP(D9,tabellen!I$3:K$24,3)*E9+VLOOKUP(G9,tabellen!I$3:K$24,3)*H9))))","v":""},{"$f":"IF(D9=\"\",IF(C9=\"\",\"\",IF(tabellen!AD$1=FALSE,IF(C8=\"\",\"\",IF(G8=\"\",0,VLOOKUP(G8,tabellen!I$3:N$24,5)*H8*I8)),IF(C10=\"\",IF(G$8=\"\",0,VLOOKUP(G$8,tabellen!I$3:N$24,5)*H$8*I$8),IF(G10=\"\",0,VLOOKUP(G10,tabellen!I$3:N$24,5)*H10*I10)))),IF(C9=\"\",\"\",IF(tabellen!AD$1=FALSE,IF(C8=\"\",\"\",IF(G8=\"\",0,VLOOKUP(G8,tabellen!I$3:N$24,5)*H8*I8)),IF(C10=\"\",IF(G$8=\"\",0,VLOOKUP(G$8,tabellen!I$3:N$24,5)*H$8*I$8),IF(G10=\"\",0,VLOOKUP(G10,tabellen!I$3:N$24,5)*H10*I10))))+IF(D9=\"\",\"\",VLOOKUP(D9,tabellen!I$3:N$24,6)*E9*F9))","v":""}]
[null,{"$f":"'aanvoer gewas'!B12","v":2010},{"$f":"IF('aanvoer gewas'!C12=\"\",\"\",'aanvoer gewas'!C12)","v":""},null,null,{"$f":"IF(D10=\"\",\"\",VLOOKUP(D10,tabellen!$I$3:$N$24,4))","v":""},null,null,{"$f":"IF(G10=\"\",\"\",VLOOKUP(G10,tabellen!$I$3:$N$24,4))","v":""},{"$f":"IF(C10=\"\",\"\",IF(AND(D10=\"\",G10=\"\"),0,IF(G10=\"\",(VLOOKUP(D10,tabellen!I$3:K$24,3)*E10),IF(D10=\"\",(VLOOKUP(G10,tabellen!I$3:K$24,3)*H10),VLOOKUP(D10,tabellen!I$3:K$24,3)*E10+VLOOKUP(G10,tabellen!I$3:K$24,3)*H10))))","v":""},{"$f":"IF(D10=\"\",IF(C10=\"\",\"\",IF(tabellen!AD$1=FALSE,IF(C9=\"\",\"\",IF(G9=\"\",0,VLOOKUP(G9,tabellen!I$3:N$24,5)*H9*I9)),IF(C11=\"\",IF(G$8=\"\",0,VLOOKUP(G$8,tabellen!I$3:N$24,5)*H$8*I$8),IF(G11=\"\",0,VLOOKUP(G11,tabellen!I$3:N$24,5)*H11*I11)))),IF(C10=\"\",\"\",IF(tabellen!AD$1=FALSE,IF(C9=\"\",\"\",IF(G9=\"\",0,VLOOKUP(G9,tabellen!I$3:N$24,5)*H9*I9)),IF(C11=\"\",IF(G$8=\"\",0,VLOOKUP(G$8,tabellen!I$3:N$24,5)*H$8*I$8),IF(G11=\"\",0,VLOOKUP(G11,tabellen!I$3:N$24,5)*H11*I11))))+IF(D10=\"\",\"\",VLOOKUP(D10,tabellen!I$3:N$24,6)*E10*F10))","v":""}]
[null,{"$f":"'aanvoer gewas'!B13","v":2009},{"$f":"IF('aanvoer gewas'!C13=\"\",\"\",'aanvoer gewas'!C13)","v":""},null,null,{"$f":"IF(D11=\"\",\"\",VLOOKUP(D11,tabellen!$I$3:$N$24,4))","v":""},null,null,{"$f":"IF(G11=\"\",\"\",VLOOKUP(G11,tabellen!$I$3:$N$24,4))","v":""},{"$f":"IF(C11=\"\",\"\",IF(AND(D11=\"\",G11=\"\"),0,IF(G11=\"\",(VLOOKUP(D11,tabellen!I$3:K$24,3)*E11),IF(D11=\"\",(VLOOKUP(G11,tabellen!I$3:K$24,3)*H11),VLOOKUP(D11,tabellen!I$3:K$24,3)*E11+VLOOKUP(G11,tabellen!I$3:K$24,3)*H11))))","v":""},{"$f":"IF(D11=\"\",IF(C11=\"\",\"\",IF(tabellen!AD$1=FALSE,IF(C10=\"\",\"\",IF(G10=\"\",0,VLOOKUP(G10,tabellen!I$3:N$24,5)*H10*I10)),IF(C12=\"\",IF(G$8=\"\",0,VLOOKUP(G$8,tabellen!I$3:N$24,5)*H$8*I$8),IF(G12=\"\",0,VLOOKUP(G12,tabellen!I$3:N$24,5)*H12*I12)))),IF(C11=\"\",\"\",IF(tabellen!AD$1=FALSE,IF(C10=\"\",\"\",IF(G10=\"\",0,VLOOKUP(G10,tabellen!I$3:N$24,5)*H10*I10)),IF(C12=\"\",IF(G$8=\"\",0,VLOOKUP(G$8,tabellen!I$3:N$24,5)*H$8*I$8),IF(G12=\"\",0,VLOOKUP(G12,tabellen!I$3:N$24,5)*H12*I12))))+IF(D11=\"\",\"\",VLOOKUP(D11,tabellen!I$3:N$24,6)*E11*F11))","v":""}]
[null,{"$f":"'aanvoer gewas'!B14","v":2008},{"$f":"IF('aanvoer gewas'!C14=\"\",\"\",'aanvoer gewas'!C14)","v":""},null,null,{"$f":"IF(D12=\"\",\"\",VLOOKUP(D12,tabellen!$I$3:$N$24,4))","v":""},null,null,{"$f":"IF(G12=\"\",\"\",VLOOKUP(G12,tabellen!$I$3:$N$24,4))","v":""},{"$f":"IF(C12=\"\",\"\",IF(AND(D12=\"\",G12=\"\"),0,IF(G12=\"\",(VLOOKUP(D12,tabellen!I$3:K$24,3)*E12),IF(D12=\"\",(VLOOKUP(G12,tabellen!I$3:K$24,3)*H12),VLOOKUP(D12,tabellen!I$3:K$24,3)*E12+VLOOKUP(G12,tabellen!I$3:K$24,3)*H12))))","v":""},{"$f":"IF(D12=\"\",IF(C12=\"\",\"\",IF(tabellen!AD$1=FALSE,IF(C11=\"\",\"\",IF(G11=\"\",0,VLOOKUP(G11,tabellen!I$3:N$24,5)*H11*I11)),IF(C13=\"\",IF(G$8=\"\",0,VLOOKUP(G$8,tabellen!I$3:N$24,5)*H$8*I$8),IF(G13=\"\",0,VLOOKUP(G13,tabellen!I$3:N$24,5)*H13*I13)))),IF(C12=\"\",\"\",IF(tabellen!AD$1=FALSE,IF(C11=\"\",\"\",IF(G11=\"\",0,VLOOKUP(G11,tabellen!I$3:N$24,5)*H11*I11)),IF(C13=\"\",IF(G$8=\"\",0,VLOOKUP(G$8,tabellen!I$3:N$24,5)*H$8*I$8),IF(G13=\"\",0,VLOOKUP(G13,tabellen!I$3:N$24,5)*H13*I13))))+IF(D12=\"\",\"\",VLOOKUP(D12,tabellen!I$3:N$24,6)*E12*F12))","v":""}]
[null,{"$f":"'aanvoer gewas'!B15","v":2007},{"$f":"IF('aanvoer gewas'!C15=\"\",\"\",'aanvoer gewas'!C15)","v":""},null,null,{"$f":"IF(D13=\"\",\"\",VLOOKUP(D13,tabellen!$I$3:$N$24,4))","v":""},null,null,{"$f":"IF(G13=\"\",\"\",VLOOKUP(G13,tabellen!$I$3:$N$24,4))","v":""},{"$f":"IF(C13=\"\",\"\",IF(AND(D13=\"\",G13=\"\"),0,IF(G13=\"\",(VLOOKUP(D13,tabellen!I$3:K$24,3)*E13),IF(D13=\"\",(VLOOKUP(G13,tabellen!I$3:K$24,3)*H13),VLOOKUP(D13,tabellen!I$3:K$24,3)*E13+VLOOKUP(G13,tabellen!I$3:K$24,3)*H13))))","v":""},{"$f":"IF(D13=\"\",IF(C13=\"\",\"\",IF(tabellen!AD$1=FALSE,IF(C12=\"\",\"\",IF(G12=\"\",0,VLOOKUP(G12,tabellen!I$3:N$24,5)*H12*I12)),IF(C14=\"\",IF(G$8=\"\",0,VLOOKUP(G$8,tabellen!I$3:N$24,5)*H$8*I$8),IF(G14=\"\",0,VLOOKUP(G14,tabellen!I$3:N$24,5)*H14*I14)))),IF(C13=\"\",\"\",IF(tabellen!AD$1=FALSE,IF(C12=\"\",\"\",IF(G12=\"\",0,VLOOKUP(G12,tabellen!I$3:N$24,5)*H12*I12)),IF(C14=\"\",IF(G$8=\"\",0,VLOOKUP(G$8,tabellen!I$3:N$24,5)*H$8*I$8),IF(G14=\"\",0,VLOOKUP(G14,tabellen!I$3:N$24,5)*H14*I14))))+IF(D13=\"\",\"\",VLOOKUP(D13,tabellen!I$3:N$24,6)*E13*F13))","v":""}]
[null,{"$f":"'aanvoer gewas'!B16","v":2006},{"$f":"IF('aanvoer gewas'!C16=\"\",\"\",'aanvoer gewas'!C16)","v":""},null,null,{"$f":"IF(D14=\"\",\"\",VLOOKUP(D14,tabellen!$I$3:$N$24,4))","v":""},null,null,{"$f":"IF(G14=\"\",\"\",VLOOKUP(G14,tabellen!$I$3:$N$24,4))","v":""},{"$f":"IF(C14=\"\",\"\",IF(AND(D14=\"\",G14=\"\"),0,IF(G14=\"\",(VLOOKUP(D14,tabellen!I$3:K$24,3)*E14),IF(D14=\"\",(VLOOKUP(G14,tabellen!I$3:K$24,3)*H14),VLOOKUP(D14,tabellen!I$3:K$24,3)*E14+VLOOKUP(G14,tabellen!I$3:K$24,3)*H14))))","v":""},{"$f":"IF(D14=\"\",IF(C14=\"\",\"\",IF(tabellen!AD$1=FALSE,IF(C13=\"\",\"\",IF(G13=\"\",0,VLOOKUP(G13,tabellen!I$3:N$24,5)*H13*I13)),IF(C15=\"\",IF(G$8=\"\",0,VLOOKUP(G$8,tabellen!I$3:N$24,5)*H$8*I$8),IF(G15=\"\",0,VLOOKUP(G15,tabellen!I$3:N$24,5)*H15*I15)))),IF(C14=\"\",\"\",IF(tabellen!AD$1=FALSE,IF(C13=\"\",\"\",IF(G13=\"\",0,VLOOKUP(G13,tabellen!I$3:N$24,5)*H13*I13)),IF(C15=\"\",IF(G$8=\"\",0,VLOOKUP(G$8,tabellen!I$3:N$24,5)*H$8*I$8),IF(G15=\"\",0,VLOOKUP(G15,tabellen!I$3:N$24,5)*H15*I15))))+IF(D14=\"\",\"\",VLOOKUP(D14,tabellen!I$3:N$24,6)*E14*F14))","v":""}]
[null,{"$f":"'aanvoer gewas'!B17","v":2005},{"$f":"IF('aanvoer gewas'!C17=\"\",\"\",'aanvoer gewas'!C17)","v":""},null,null,{"$f":"IF(D15=\"\",\"\",VLOOKUP(D15,tabellen!$I$3:$N$24,4))","v":""},null,null,{"$f":"IF(G15=\"\",\"\",VLOOKUP(G15,tabellen!$I$3:$N$24,4))","v":""},{"$f":"IF(C15=\"\",\"\",IF(AND(D15=\"\",G15=\"\"),0,IF(G15=\"\",(VLOOKUP(D15,tabellen!I$3:K$24,3)*E15),IF(D15=\"\",(VLOOKUP(G15,tabellen!I$3:K$24,3)*H15),VLOOKUP(D15,tabellen!I$3:K$24,3)*E15+VLOOKUP(G15,tabellen!I$3:K$24,3)*H15))))","v":""},{"$f":"IF(D15=\"\",IF(C15=\"\",\"\",IF(tabellen!AD$1=FALSE,IF(C14=\"\",\"\",IF(G14=\"\",0,VLOOKUP(G14,tabellen!I$3:N$24,5)*H14*I14)),IF(C16=\"\",IF(G$8=\"\",0,VLOOKUP(G$8,tabellen!I$3:N$24,5)*H$8*I$8),IF(G16=\"\",0,VLOOKUP(G16,tabellen!I$3:N$24,5)*H16*I16)))),IF(C15=\"\",\"\",IF(tabellen!AD$1=FALSE,IF(C14=\"\",\"\",IF(G14=\"\",0,VLOOKUP(G14,tabellen!I$3:N$24,5)*H14*I14)),IF(C16=\"\",IF(G$8=\"\",0,VLOOKUP(G$8,tabellen!I$3:N$24,5)*H$8*I$8),IF(G16=\"\",0,VLOOKUP(G16,tabellen!I$3:N$24,5)*H16*I16))))+IF(D15=\"\",\"\",VLOOKUP(D15,tabellen!I$3:N$24,6)*E15*F15))","v":""}]
[null,{"$f":"'aanvoer gewas'!B18","v":2004},{"$f":"IF('aanvoer gewas'!C18=\"\",\"\",'aanvoer gewas'!C18)","v":""},null,null,{"$f":"IF(D16=\"\",\"\",VLOOKUP(D16,tabellen!$I$3:$N$24,4))","v":""},null,null,{"$f":"IF(G16=\"\",\"\",VLOOKUP(G16,tabellen!$I$3:$N$24,4))","v":""},{"$f":"IF(C16=\"\",\"\",IF(AND(D16=\"\",G16=\"\"),0,IF(G16=\"\",(VLOOKUP(D16,tabellen!I$3:K$24,3)*E16),IF(D16=\"\",(VLOOKUP(G16,tabellen!I$3:K$24,3)*H16),VLOOKUP(D16,tabellen!I$3:K$24,3)*E16+VLOOKUP(G16,tabellen!I$3:K$24,3)*H16))))","v":""},{"$f":"IF(D16=\"\",IF(C16=\"\",\"\",IF(tabellen!AD$1=FALSE,IF(C15=\"\",\"\",IF(G15=\"\",0,VLOOKUP(G15,tabellen!I$3:N$24,5)*H15*I15)),IF(C17=\"\",IF(G$8=\"\",0,VLOOKUP(G$8,tabellen!I$3:N$24,5)*H$8*I$8),IF(G17=\"\",0,VLOOKUP(G17,tabellen!I$3:N$24,5)*H17*I17)))),IF(C16=\"\",\"\",IF(tabellen!AD$1=FALSE,IF(C15=\"\",\"\",IF(G15=\"\",0,VLOOKUP(G15,tabellen!I$3:N$24,5)*H15*I15)),IF(C17=\"\",IF(G$8=\"\",0,VLOOKUP(G$8,tabellen!I$3:N$24,5)*H$8*I$8),IF(G17=\"\",0,VLOOKUP(G17,tabellen!I$3:N$24,5)*H17*I17))))+IF(D16=\"\",\"\",VLOOKUP(D16,tabellen!I$3:N$24,6)*E16*F16))","v":""}]
[null,{"$f":"'aanvoer gewas'!B19","v":2003},{"$f":"IF('aanvoer gewas'!C19=\"\",\"\",'aanvoer gewas'!C19)","v":""},null,null,{"$f":"IF(D17=\"\",\"\",VLOOKUP(D17,tabellen!$I$3:$N$24,4))","v":""},null,null,{"$f":"IF(G17=\"\",\"\",VLOOKUP(G17,tabellen!$I$3:$N$24,4))","v":""},{"$f":"IF(C17=\"\",\"\",IF(AND(D17=\"\",G17=\"\"),0,IF(G17=\"\",(VLOOKUP(D17,tabellen!I$3:K$24,3)*E17),IF(D17=\"\",(VLOOKUP(G17,tabellen!I$3:K$24,3)*H17),VLOOKUP(D17,tabellen!I$3:K$24,3)*E17+VLOOKUP(G17,tabellen!I$3:K$24,3)*H17))))","v":""},{"$f":"IF(D17=\"\",IF(C17=\"\",\"\",IF(tabellen!AD$1=FALSE,IF(C16=\"\",\"\",IF(G16=\"\",0,VLOOKUP(G16,tabellen!I$3:N$24,5)*H16*I16)),IF(C18=\"\",IF(G$8=\"\",0,VLOOKUP(G$8,tabellen!I$3:N$24,5)*H$8*I$8),IF(G18=\"\",0,VLOOKUP(G18,tabellen!I$3:N$24,5)*H18*I18)))),IF(C17=\"\",\"\",IF(tabellen!AD$1=FALSE,IF(C16=\"\",\"\",IF(G16=\"\",0,VLOOKUP(G16,tabellen!I$3:N$24,5)*H16*I16)),IF(C18=\"\",IF(G$8=\"\",0,VLOOKUP(G$8,tabellen!I$3:N$24,5)*H$8*I$8),IF(G18=\"\",0,VLOOKUP(G18,tabellen!I$3:N$24,5)*H18*I18))))+IF(D17=\"\",\"\",VLOOKUP(D17,tabellen!I$3:N$24,6)*E17*F17))","v":""}]
[{"$nulls":8},"gemiddelde jaarlijkse organische stofaanvoer",{"$f":"AVERAGE(J8:J17)","v":{"$error":"#DIV/0!"}}]
[]
[{"$nulls":7},"<<terug",null,"verder>>"]
[]
[]
[]
[{"$nulls":9},"organische stofbalans (3/7)"]

{"sheet":"aanvoer compost","index":3,"n_rows":24,"n_cols":11,"rows_kept":24,"merged":[[1,1,1,9],[5,3,5,5],[5,6,5,8]]}
[]
[null,"ORGANISCHE STOFBALANS"]
[]
[null,"aanvoer compost"]
[]
[{"$nulls":3},"compost voorjaar",null,null,"compost najaar"]
[null,"jaar","gewas","soort compost","dosering (ton per ha)","N (kg/ton)","soort compost","dosering (ton per ha)","N (kg/ton)","aanvoer eff. org. stof (kg/ha)","beschikbare N (kg/ha)"]
[null,{"$f":"'aanvoer gewas'!B10","v":2012},{"$f":"IF('aanvoer gewas'!C10=\"\",\"\",'aanvoer gewas'!C10)","v":""},null,null,{"$f":"IF(D8=\"\",\"\",VLOOKUP(D8,tabellen!$Q$3:$V$12,4))","v":""},null,null,{"$f":"IF(G8=\"\",\"\",VLOOKUP(G8,tabellen!$Q$3:$V$12,4))","v":""},{"$f":"IF(C8=\"\",\"\",IF(AND(D8=\"\",G8=\"\"),0,IF(G8=\"\",(VLOOKUP(D8,tabellen!$Q$3:$V$12,3)*E8),IF(D8=\"\",(VLOOKUP(G8,tabellen!$Q$3:$V$12,3)*H8),VLOOKUP(D8,tabellen!$Q$3:$V$12,3)*E8+VLOOKUP(G8,tabellen!$Q$3:$V$12,3)*H8))))","v":""},{"$f":"IF(D8=\"\",IF(tabellen!AD1=FALSE,IF(AND(C8=\"\",G8=\"\"),\"\",IF(AND(C9=\"\",G8<>\"\"),VLOOKUP(G8,tabellen!Q$3:V$12,5)*H8*I8,IF(AND(C10=\"\",G9<>\"\"),VLOOKUP(G9,tabellen!Q$3:V$12,5)*H9*I9,IF(AND(C11=\"\",G10<>\"\"),VLOOKUP(G10,tabellen!Q$3:V$12,5)*H10*I10,IF(AND(C12=\"\",G11<>\"\"),VLOOKUP(G11,tabellen!Q$3:V$12,5)*H11*I11,IF(AND(C13=\"\",G12<>\"\"),VLOOKUP(G12,tabellen!Q$3:V$12,5)*H12*I12,IF(AND(C14=\"\",G13<>\"\"),VLOOKUP(G13,tabellen!Q$3:V$12,5)*H13*I13,IF(AND(C15=\"\",G14<>\"\"),VLOOKUP(G14,tabellen!Q$3:V$12,5)*H14*I14,IF(AND(C16=\"\",G15<>\"\"),VLOOKUP(G15,tabellen!Q$3:V$12,5)*H15*I15,IF(AND(C17=\"\",G16<>\"\"),VLOOKUP(G16,tabellen!Q$3:V$12,5)*H16*I16,IF(AND(C17<>\"\",G17<>\"\"),VLOOKUP(G17,tabellen!Q$3:V$12,5)*H17*I17,0))))))))))),IF(C9=\"\",IF(G8=\"\",0,VLOOKUP(G8,tabellen!Q$3:V$12,5)*H8*I8),IF(G9=\"\",0,VLOOKUP(G9,tabellen!Q$3:V$12,5)*H9*I9))),IF(tabellen!AD1=FALSE,IF(AND(C8=\"\",G8=\"\"),\"\",IF(AND(C9=\"\",G8<>\"\"),VLOOKUP(G8,tabellen!Q$3:V$12,5)*H8*I8,IF(AND(C10=\"\",G9<>\"\"),VLOOKUP(G9,tabellen!Q$3:V$12,5)*H9*I9,IF(AND(C11=\"\",G10<>\"\"),VLOOKUP(G10,tabellen!Q$3:V$12,5)*H10*I10,IF(AND(C12=\"\",G11<>\"\"),VLOOKUP(G11,tabellen!Q$3:V$12,5)*H11*I11,IF(AND(C13=\"\",G12<>\"\"),VLOOKUP(G12,tabellen!Q$3:V$12,5)*H12*I12,IF(AND(C14=\"\",G13<>\"\"),VLOOKUP(G13,tabellen!Q$3:V$12,5)*H13*I13,IF(AND(C15=\"\",G14<>\"\"),VLOOKUP(G14,tabellen!Q$3:V$12,5)*H14*I14,IF(AND(C16=\"\",G15<>\"\"),VLOOKUP(G15,tabellen!Q$3:V$12,5)*H15*I15,IF(AND(C17=\"\",G16<>\"\"),VLOOKUP(G16,tabellen!Q$3:V$12,5)*H16*I16,IF(AND(C17<>\"\",G17<>\"\"),VLOOKUP(G17,tabellen!Q$3:V$12,5)*H17*I17,0))))))))))),IF(C9=\"\",IF(G8=\"\",0,VLOOKUP(G8,tabellen!Q$3:V$12,5)*H8*I8),IF(G9=\"\",0,VLOOKUP(G9,tabellen!Q$3:V$12,5)*H9*I9)))+IF(D8=\"\",\"\",VLOOKUP(D8,tabellen!Q$3:V$12,6)*E8*F8))","v":0}]
[null,{"$f":"'aanvoer gewas'!B11","v":2011},{"$f":"IF('aanvoer gewas'!C11=\"\",\"\",'aanvoer gewas'!C11)","v":""},null,null,{"$f":"IF(D9=\"\",\"\",VLOOKUP(D9,tabellen!$Q$3:$V$12,4))","v":""},null,null,{"$f":"IF(G9=\"\",\"\",VLOOKUP(G9,tabellen!$Q$3:$V$12,4))","v":""},{"$f":"IF(C9=\"\",\"\",IF(AND(D9=\"\",G9=\"\"),0,IF(G9=\"\",(VLOOKUP(D9,tabellen!$Q$3:$V$12,3)*E9),IF(D9=\"\",(VLOOKUP(G9,tabellen!$Q$3:$V$12,3)*H9),VLOOKUP(D9,tabellen!$Q$3:$V$12,3)*E9+VLOOKUP(G9,tabellen!$Q$3:$V$12,3)*H9))))","v":""},{"$f":"IF(D9=\"\",IF(C9=\"\",\"\",IF(tabellen!AD$1=FALSE,IF(C8=\"\",\"\",IF(G8=\"\",0,VLOOKUP(G8,tabellen!Q$3:V$12,5)*H8*I8)),IF(C10=\"\",IF(G$8=\"\",0,VLOOKUP(G$8,tabellen!Q$3:V$12,5)*H$8*I$8),IF(G10=\"\",0,VLOOKUP(G10,tabellen!Q$3:V$12,5)*H10*I10)))),IF(C9=\"\",\"\",IF(tabellen!AD$1=FALSE,IF(C8=\"\",\"\",IF(G8=\"\",0,VLOOKUP(G8,tabellen!Q$3:V$12,5)*H8*I8)),IF(C10=\"\",IF(G$8=\"\",0,VLOOKUP(G$8,tabellen!Q$3:V$12,5)*H$8*I$8),IF(G10=\"\",0,VLOOKUP(G10,tabellen!Q$3:V$12,5)*H10*I10))))+IF(D9=\"\",\"\",VLOOKUP(D9,tabellen!Q$3:V$12,6)*E9*F9))","v":""}]
[null,{"$f":"'aanvoer gewas'!B12","v":2010},{"$f":"IF('aanvoer gewas'!C12=\"\",\"\",'aanvoer gewas'!C12)","v":""},null,null,{"$f":"IF(D10=\"\",\"\",VLOOKUP(D10,tabellen!$Q$3:$V$12,4))","v":""},null,null,{"$f":"IF(G10=\"\",\"\",VLOOKUP(G10,tabellen!$Q$3:$V$12,4))","v":""},{"$f":"IF(C10=\"\",\"\",IF(AND(D10=\"\",G10=\"\"),0,IF(G10=\"\",(VLOOKUP(D10,tabellen!$Q$3:$V$12,3)*E10),IF(D10=\"\",(VLOOKUP(G10,tabellen!$Q$3:$V$12,3)*H10),VLOOKUP(D10,tabellen!$Q$3:$V$12,3)*E10+VLOOKUP(G10,tabellen!$Q$3:$V$12,3)*H10))))","v":""},{"$f":"IF(D10=\"\",IF(C10=\"\",\"\",IF(tabellen!AD$1=FALSE,IF(C9=\"\",\"\",IF(G9=\"\",0,VLOOKUP(G9,tabellen!Q$3:V$12,5)*H9*I9)),IF(C11=\"\",IF(G$8=\"\",0,VLOOKUP(G$8,tabellen!Q$3:V$12,5)*H$8*I$8),IF(G11=\"\",0,VLOOKUP(G11,tabellen!Q$3:V$12,5)*H11*I11)))),IF(C10=\"\",\"\",IF(tabellen!AD$1=FALSE,IF(C9=\"\",\"\",IF(G9=\"\",0,VLOOKUP(G9,tabellen!Q$3:V$12,5)*H9*I9)),IF(C11=\"\",IF(G$8=\"\",0,VLOOKUP(G$8,tabellen!Q$3:V$12,5)*H$8*I$8),IF(G11=\"\",0,VLOOKUP(G11,tabellen!Q$3:V$12,5)*H11*I11))))+IF(D10=\"\",\"\",VLOOKUP(D10,tabellen!Q$3:V$12,6)*E10*F10))","v":""}]
[null,{"$f":"'aanvoer gewas'!B13","v":2009},{"$f":"IF('aanvoer gewas'!C13=\"\",\"\",'aanvoer gewas'!C13)","v":""},null,null,{"$f":"IF(D11=\"\",\"\",VLOOKUP(D11,tabellen!$Q$3:$V$12,4))","v":""},null,null,{"$f":"IF(G11=\"\",\"\",VLOOKUP(G11,tabellen!$Q$3:$V$12,4))","v":""},{"$f":"IF(C11=\"\",\"\",IF(AND(D11=\"\",G11=\"\"),0,IF(G11=\"\",(VLOOKUP(D11,tabellen!$Q$3:$V$12,3)*E11),IF(D11=\"\",(VLOOKUP(G11,tabellen!$Q$3:$V$12,3)*H11),VLOOKUP(D11,tabellen!$Q$3:$V$12,3)*E11+VLOOKUP(G11,tabellen!$Q$3:$V$12,3)*H11))))","v":""},{"$f":"IF(D11=\"\",IF(C11=\"\",\"\",IF(tabellen!AD$1=FALSE,IF(C10=\"\",\"\",IF(G10=\"\",0,VLOOKUP(G10,tabellen!Q$3:V$12,5)*H10*I10)),IF(C12=\"\",IF(G$8=\"\",0,VLOOKUP(G$8,tabellen!Q$3:V$12,5)*H$8*I$8),IF(G12=\"\",0,VLOOKUP(G12,tabellen!Q$3:V$12,5)*H12*I12)))),IF(C11=\"\",\"\",IF(tabellen!AD$1=FALSE,IF(C10=\"\",\"\",IF(G10=\"\",0,VLOOKUP(G10,tabellen!Q$3:V$12,5)*H10*I10)),IF(C12=\"\",IF(G$8=\"\",0,VLOOKUP(G$8,tabellen!Q$3:V$12,5)*H$8*I$8),IF(G12=\"\",0,VLOOKUP(G12,tabellen!Q$3:V$12,5)*H12*I12))))+IF(D11=\"\",\"\",VLOOKUP(D11,tabellen!Q$3:V$12,6)*E11*F11))","v":""}]
[null,{"$f":"'aanvoer gewas'!B14","v":2008},{"$f":"IF('aanvoer gewas'!C14=\"\",\"\",'aanvoer gewas'!C14)","v":""},null,null,{"$f":"IF(D12=\"\",\"\",VLOOKUP(D12,tabellen!$Q$3:$V$12,4))","v":""},null,null,{"$f":"IF(G12=\"\",\"\",VLOOKUP(G12,tabellen!$Q$3:$V$12,4))","v":""},{"$f":"IF(C12=\"\",\"\",IF(AND(D12=\"\",G12=\"\"),0,IF(G12=\"\",(VLOOKUP(D12,tabellen!$Q$3:$V$12,3)*E12),IF(D12=\"\",(VLOOKUP(G12,tabellen!$Q$3:$V$12,3)*H12),VLOOKUP(D12,tabellen!$Q$3:$V$12,3)*E12+VLOOKUP(G12,tabellen!$Q$3:$V$12,3)*H12))))","v":""},{"$f":"IF(D12=\"\",IF(C12=\"\",\"\",IF(tabellen!AD$1=FALSE,IF(C11=\"\",\"\",IF(G11=\"\",0,VLOOKUP(G11,tabellen!Q$3:V$12,5)*H11*I11)),IF(C13=\"\",IF(G$8=\"\",0,VLOOKUP(G$8,tabellen!Q$3:V$12,5)*H$8*I$8),IF(G13=\"\",0,VLOOKUP(G13,tabellen!Q$3:V$12,5)*H13*I13)))),IF(C12=\"\",\"\",IF(tabellen!AD$1=FALSE,IF(C11=\"\",\"\",IF(G11=\"\",0,VLOOKUP(G11,tabellen!Q$3:V$12,5)*H11*I11)),IF(C13=\"\",IF(G$8=\"\",0,VLOOKUP(G$8,tabellen!Q$3:V$12,5)*H$8*I$8),IF(G13=\"\",0,VLOOKUP(G13,tabellen!Q$3:V$12,5)*H13*I13))))+IF(D12=\"\",\"\",VLOOKUP(D12,tabellen!Q$3:V$12,6)*E12*F12))","v":""}]
[null,{"$f":"'aanvoer gewas'!B15","v":2007},{"$f":"IF('aanvoer gewas'!C15=\"\",\"\",'aanvoer gewas'!C15)","v":""},null,null,{"$f":"IF(D13=\"\",\"\",VLOOKUP(D13,tabellen!$Q$3:$V$12,4))","v":""},null,null,{"$f":"IF(G13=\"\",\"\",VLOOKUP(G13,tabellen!$Q$3:$V$12,4))","v":""},{"$f":"IF(C13=\"\",\"\",IF(AND(D13=\"\",G13=\"\"),0,IF(G13=\"\",(VLOOKUP(D13,tabellen!$Q$3:$V$12,3)*E13),IF(D13=\"\",(VLOOKUP(G13,tabellen!$Q$3:$V$12,3)*H13),VLOOKUP(D13,tabellen!$Q$3:$V$12,3)*E13+VLOOKUP(G13,tabellen!$Q$3:$V$12,3)*H13))))","v":""},{"$f":"IF(D13=\"\",IF(C13=\"\",\"\",IF(tabellen!AD$1=FALSE,IF(C12=\"\",\"\",IF(G12=\"\",0,VLOOKUP(G12,tabellen!Q$3:V$12,5)*H12*I12)),IF(C14=\"\",IF(G$8=\"\",0,VLOOKUP(G$8,tabellen!Q$3:V$12,5)*H$8*I$8),IF(G14=\"\",0,VLOOKUP(G14,tabellen!Q$3:V$12,5)*H14*I14)))),IF(C13=\"\",\"\",IF(tabellen!AD$1=FALSE,IF(C12=\"\",\"\",IF(G12=\"\",0,VLOOKUP(G12,tabellen!Q$3:V$12,5)*H12*I12)),IF(C14=\"\",IF(G$8=\"\",0,VLOOKUP(G$8,tabellen!Q$3:V$12,5)*H$8*I$8),IF(G14=\"\",0,VLOOKUP(G14,tabellen!Q$3:V$12,5)*H14*I14))))+IF(D13=\"\",\"\",VLOOKUP(D13,tabellen!Q$3:V$12,6)*E13*F13))","v":""}]
[null,{"$f":"'aanvoer gewas'!B16","v":2006},{"$f":"IF('aanvoer gewas'!C16=\"\",\"\",'aanvoer gewas'!C16)","v":""},null,null,{"$f":"IF(D14=\"\",\"\",VLOOKUP(D14,tabellen!$Q$3:$V$12,4))","v":""},null,null,{"$f":"IF(G14=\"\",\"\",VLOOKUP(G14,tabellen!$Q$3:$V$12,4))","v":""},{"$f":"IF(C14=\"\",\"\",IF(AND(D14=\"\",G14=\"\"),0,IF(G14=\"\",(VLOOKUP(D14,tabellen!$Q$3:$V$12,3)*E14),IF(D14=\"\",(VLOOKUP(G14,tabellen!$Q$3:$V$12,3)*H14),VLOOKUP(D14,tabellen!$Q$3:$V$12,3)*E14+VLOOKUP(G14,tabellen!$Q$3:$V$12,3)*H14))))","v":""},{"$f":"IF(D14=\"\",IF(C14=\"\",\"\",IF(tabellen!AD$1=FALSE,IF(C13=\"\",\"\",IF(G13=\"\",0,VLOOKUP(G13,tabellen!Q$3:V$12,5)*H13*I13)),IF(C15=\"\",IF(G$8=\"\",0,VLOOKUP(G$8,tabellen!Q$3:V$12,5)*H$8*I$8),IF(G15=\"\",0,VLOOKUP(G15,tabellen!Q$3:V$12,5)*H15*I15)))),IF(C14=\"\",\"\",IF(tabellen!AD$1=FALSE,IF(C13=\"\",\"\",IF(G13=\"\",0,VLOOKUP(G13,tabellen!Q$3:V$12,5)*H13*I13)),IF(C15=\"\",IF(G$8=\"\",0,VLOOKUP(G$8,tabellen!Q$3:V$12,5)*H$8*I$8),IF(G15=\"\",0,VLOOKUP(G15,tabellen!Q$3:V$12,5)*H15*I15))))+IF(D14=\"\",\"\",VLOOKUP(D14,tabellen!Q$3:V$12,6)*E14*F14))","v":""}]
[null,{"$f":"'aanvoer gewas'!B17","v":2005},{"$f":"IF('aanvoer gewas'!C17=\"\",\"\",'aanvoer gewas'!C17)","v":""},null,null,{"$f":"IF(D15=\"\",\"\",VLOOKUP(D15,tabellen!$Q$3:$V$12,4))","v":""},null,null,{"$f":"IF(G15=\"\",\"\",VLOOKUP(G15,tabellen!$Q$3:$V$12,4))","v":""},{"$f":"IF(C15=\"\",\"\",IF(AND(D15=\"\",G15=\"\"),0,IF(G15=\"\",(VLOOKUP(D15,tabellen!$Q$3:$V$12,3)*E15),IF(D15=\"\",(VLOOKUP(G15,tabellen!$Q$3:$V$12,3)*H15),VLOOKUP(D15,tabellen!$Q$3:$V$12,3)*E15+VLOOKUP(G15,tabellen!$Q$3:$V$12,3)*H15))))","v":""},{"$f":"IF(D15=\"\",IF(C15=\"\",\"\",IF(tabellen!AD$1=FALSE,IF(C14=\"\",\"\",IF(G14=\"\",0,VLOOKUP(G14,tabellen!Q$3:V$12,5)*H14*I14)),IF(C16=\"\",IF(G$8=\"\",0,VLOOKUP(G$8,tabellen!Q$3:V$12,5)*H$8*I$8),IF(G16=\"\",0,VLOOKUP(G16,tabellen!Q$3:V$12,5)*H16*I16)))),IF(C15=\"\",\"\",IF(tabellen!AD$1=FALSE,IF(C14=\"\",\"\",IF(G14=\"\",0,VLOOKUP(G14,tabellen!Q$3:V$12,5)*H14*I14)),IF(C16=\"\",IF(G$8=\"\",0,VLOOKUP(G$8,tabellen!Q$3:V$12,5)*H$8*I$8),IF(G16=\"\",0,VLOOKUP(G16,tabellen!Q$3:V$12,5)*H16*I16))))+IF(D15=\"\",\"\",VLOOKUP(D15,tabellen!Q$3:V$12,6)*E15*F15))","v":""}]
[null,{"$f":"'aanvoer gewas'!B18","v":2004},{"$f":"IF('aanvoer gewas'!C18=\"\",\"\",'aanvoer gewas'!C18)","v":""},null,null,{"$f":"IF(D16=\"\",\"\",VLOOKUP(D16,tabellen!$Q$3:$V$12,4))","v":""},null,null,{"$f":"IF(G16=\"\",\"\",VLOOKUP(G16,tabellen!$Q$3:$V$12,4))","v":""},{"$f":"IF(C16=\"\",\"\",IF(AND(D16=\"\",G16=\"\"),0,IF(G16=\"\",(VLOOKUP(D16,tabellen!$Q$3:$V$12,3)*E16),IF(D16=\"\",(VLOOKUP(G16,tabellen!$Q$3:$V$12,3)*H16),VLOOKUP(D16,tabellen!$Q$3:$V$12,3)*E16+VLOOKUP(G16,tabellen!$Q$3:$V$12,3)*H16))))","v":""},{"$f":"IF(C16=\"\",\"\",IF(tabellen!AD$1=FALSE,IF(C15=\"\",\"\",IF(G15=\"\",0,VLOOKUP(G15,tabellen!Q$3:V$12,5)*H15*I15)),IF(C17=\"\",IF(G$8=\"\",0,VLOOKUP(G$8,tabellen!Q$3:V$12,5)*H$8*I$8),IF(G17=\"\",0,VLOOKUP(G17,tabellen!Q$3:V$12,5)*H17*I17))))","v":""}]
[null,{"$f":"'aanvoer gewas'!B19","v":2003},{"$f":"IF('aanvoer gewas'!C19=\"\",\"\",'aanvoer gewas'!C19)","v":""},null,null,{"$f":"IF(D17=\"\",\"\",VLOOKUP(D17,tabellen!$Q$3:$V$12,4))","v":""},null,null,{"$f":"IF(G17=\"\",\"\",VLOOKUP(G17,tabellen!$Q$3:$V$12,4))","v":""},{"$f":"IF(C17=\"\",\"\",IF(AND(D17=\"\",G17=\"\"),0,IF(G17=\"\",(VLOOKUP(D17,tabellen!$Q$3:$V$12,3)*E17),IF(D17=\"\",(VLOOKUP(G17,tabellen!$Q$3:$V$12,3)*H17),VLOOKUP(D17,tabellen!$Q$3:$V$12,3)*E17+VLOOKUP(G17,tabellen!$Q$3:$V$12,3)*H17))))","v":""},{"$f":"IF(C17=\"\",\"\",IF(tabellen!AD$1=FALSE,IF(C16=\"\",\"\",IF(G16=\"\",0,VLOOKUP(G16,tabellen!Q$3:V$12,5)*H16*I16)),IF(C18=\"\",IF(G$8=\"\",0,VLOOKUP(G$8,tabellen!Q$3:V$12,5)*H$8*I$8),IF(G18=\"\",0,VLOOKUP(G18,tabellen!Q$3:V$12,5)*H18*I18))))","v":""}]
[{"$nulls":8},"gemiddelde jaarlijkse organische stofaanvoer",{"$f":"AVERAGE(J8:J17)","v":{"$error":"#DIV/0!"}}]
[]
[{"$nulls":7},"<<terug",null,"verder>>"]
[]
[]
[]
[{"$nulls":9},"organische stofbalans (3/7)"]

{"sheet":"aanvoer groenbemesters","index":4,"n_rows":29,"n_cols":6,"rows_kept":29,"merged":[[1,1,1,4]]}
[]
[null,"ORGANISCHE STOFBALANS"]
[]
[null,"aanvoer groenbemesters"]
[]
[null,"jaar","gewas","soort groenbemester","aanvoer eff. org. stof (kg/ha)","beschikbare N (kg/ha)"]
[null,{"$f":"'aanvoer gewas'!B10","v":2012},{"$f":"IF('aanvoer gewas'!C10=\"\",\"\",'aanvoer gewas'!C10)","v":""},null,{"$f":"IF(C7=\"\",\"\",IF(D7=\"\",0,VLOOKUP(D7,tabellen!X$3:Y$22,2)))","v":""},{"$f":"IF(tabellen!AD1=FALSE,IF(AND(C7=\"\",D7=\"\"),\"\",IF(AND(C8=\"\",D7<>\"\"),VLOOKUP(D7,tabellen!X$3:Z$22,3),IF(AND(C9=\"\",D8<>\"\"),VLOOKUP(D8,tabellen!X$3:Z$22,3),IF(AND(C10=\"\",D9<>\"\"),VLOOKUP(D9,tabellen!X$3:Z$22,3),IF(AND(C11=\"\",D10<>\"\"),VLOOKUP(D10,tabellen!X$3:Z$22,3),IF(AND(C12=\"\",D11<>\"\"),VLOOKUP(D11,tabellen!X$3:Z$22,3),IF(AND(C13=\"\",D12<>\"\"),VLOOKUP(D12,tabellen!X$3:Z$22,3),IF(AND(C14=\"\",D13<>\"\"),VLOOKUP(D13,tabellen!X$3:Z$22,3),IF(AND(C15=\"\",D14<>\"\"),VLOOKUP(D14,tabellen!X$3:Z$22,3),IF(AND(C16=\"\",D15<>\"\"),VLOOKUP(D15,tabellen!X$3:Z$22,3),IF(AND(C16<>\"\",D16<>\"\"),VLOOKUP(D16,tabellen!X$3:Z$22,3),0))))))))))),IF(C8=\"\",IF(D7=\"\",0,VLOOKUP(D7,tabellen!X$3:Z$22,3)),IF(D8=\"\",0,VLOOKUP(D8,tabellen!X$3:Z$22,3))))","v":0}]
[null,{"$f":"'aanvoer gewas'!B11","v":2011},{"$f":"IF('aanvoer gewas'!C11=\"\",\"\",'aanvoer gewas'!C11)","v":""},null,{"$f":"IF(C8=\"\",\"\",IF(D8=\"\",0,VLOOKUP(D8,tabellen!X$3:Y$22,2)))","v":""},{"$f":"IF(C8=\"\",\"\",IF(tabellen!AD$1=FALSE,IF(C7=\"\",\"\",IF(D7=\"\",0,VLOOKUP(D7,tabellen!X$3:Z$22,3))),IF(C9=\"\",IF(D$7=\"\",0,VLOOKUP(D$7,tabellen!X$3:Z$22,3)),IF(D9=\"\",0,VLOOKUP(D9,tabellen!X$3:Z$22,3)))))","v":""}]
[null,{"$f":"'aanvoer gewas'!B12","v":2010},{"$f":"IF('aanvoer gewas'!C12=\"\",\"\",'aanvoer gewas'!C12)","v":""},null,{"$f":"IF(C9=\"\",\"\",IF(D9=\"\",0,VLOOKUP(D9,tabellen!X$3:Y$22,2)))","v":""},{"$f":"IF(C9=\"\",\"\",IF(tabellen!AD$1=FALSE,IF(C8=\"\",\"\",IF(D8=\"\",0,VLOOKUP(D8,tabellen!X$3:Z$22,3))),IF(C10=\"\",IF(D$7=\"\",0,VLOOKUP(D$7,tabellen!X$3:Z$22,3)),IF(D10=\"\",0,VLOOKUP(D10,tabellen!X$3:Z$22,3)))))","v":""}]
[null,{"$f":"'aanvoer gewas'!B13","v":2009},{"$f":"IF('aanvoer gewas'!C13=\"\",\"\",'aanvoer gewas'!C13)","v":""},null,{"$f":"IF(C10=\"\",\"\",IF(D10=\"\",0,VLOOKUP(D10,tabellen!X$3:Y$22,2)))","v":""},{"$f":"IF(C10=\"\",\"\",IF(tabellen!AD$1=FALSE,IF(C9=\"\",\"\",IF(D9=\"\",0,VLOOKUP(D9,tabellen!X$3:Z$22,3))),IF(C11=\"\",IF(D$7=\"\",0,VLOOKUP(D$7,tabellen!X$3:Z$22,3)),IF(D11=\"\",0,VLOOKUP(D11,tabellen!X$3:Z$22,3)))))","v":""}]
[null,{"$f":"'aanvoer gewas'!B14","v":2008},{"$f":"IF('aanvoer gewas'!C14=\"\",\"\",'aanvoer gewas'!C14)","v":""},null,{"$f":"IF(C11=\"\",\"\",IF(D11=\"\",0,VLOOKUP(D11,tabellen!X$3:Y$22,2)))","v":""},{"$f":"IF(C11=\"\",\"\",IF(tabellen!AD$1=FALSE,IF(C10=\"\",\"\",IF(D10=\"\",0,VLOOKUP(D10,tabellen!X$3:Z$22,3))),IF(C12=\"\",IF(D$7=\"\",0,VLOOKUP(D$7,tabellen!X$3:Z$22,3)),IF(D12=\"\",0,VLOOKUP(D12,tabellen!X$3:Z$22,3)))))","v":""}]
[null,{"$f":"'aanvoer gewas'!B15","v":2007},{"$f":"IF('aanvoer gewas'!C15=\"\",\"\",'aanvoer gewas'!C15)","v":""},null,{"$f":"IF(C12=\"\",\"\",IF(D12=\"\",0,VLOOKUP(D12,tabellen!X$3:Y$22,2)))","v":""},{"$f":"IF(C12=\"\",\"\",IF(tabellen!AD$1=FALSE,IF(C11=\"\",\"\",IF(D11=\"\",0,VLOOKUP(D11,tabellen!X$3:Z$22,3))),IF(C13=\"\",IF(D$7=\"\",0,VLOOKUP(D$7,tabellen!X$3:Z$22,3)),IF(D13=\"\",0,VLOOKUP(D13,tabellen!X$3:Z$22,3)))))","v":""}]
[null,{"$f":"'aanvoer gewas'!B16","v":2006},{"$f":"IF('aanvoer gewas'!C16=\"\",\"\",'aanvoer gewas'!C16)","v":""},null,{"$f":"IF(C13=\"\",\"\",IF(D13=\"\",0,VLOOKUP(D13,tabellen!X$3:Y$22,2)))","v":""},{"$f":"IF(C13=\"\",\"\",IF(tabellen!AD$1=FALSE,IF(C12=\"\",\"\",IF(D12=\"\",0,VLOOKUP(D12,tabellen!X$3:Z$22,3))),IF(C14=\"\",IF(D$7=\"\",0,VLOOKUP(D$7,tabellen!X$3:Z$22,3)),IF(D14=\"\",0,VLOOKUP(D14,tabellen!X$3:Z$22,3)))))","v":""}]
[null,{"$f":"'aanvoer gewas'!B17","v":2005},{"$f":"IF('aanvoer gewas'!C17=\"\",\"\",'aanvoer gewas'!C17)","v":""},null,{"$f":"IF(C14=\"\",\"\",IF(D14=\"\",0,VLOOKUP(D14,tabellen!X$3:Y$22,2)))","v":""},{"$f":"IF(C14=\"\",\"\",IF(tabellen!AD$1=FALSE,IF(C13=\"\",\"\",IF(D13=\"\",0,VLOOKUP(D13,tabellen!X$3:Z$22,3))),IF(C15=\"\",IF(D$7=\"\",0,VLOOKUP(D$7,tabellen!X$3:Z$22,3)),IF(D15=\"\",0,VLOOKUP(D15,tabellen!X$3:Z$22,3)))))","v":""}]
[null,{"$f":"'aanvoer gewas'!B18","v":2004},{"$f":"IF('aanvoer gewas'!C18=\"\",\"\",'aanvoer gewas'!C18)","v":""},null,{"$f":"IF(C15=\"\",\"\",IF(D15=\"\",0,VLOOKUP(D15,tabellen!X$3:Y$22,2)))","v":""},{"$f":"IF(C15=\"\",\"\",IF(tabellen!AD$1=FALSE,IF(C14=\"\",\"\",IF(D14=\"\",0,VLOOKUP(D14,tabellen!X$3:Z$22,3))),IF(C16=\"\",IF(D$7=\"\",0,VLOOKUP(D$7,tabellen!X$3:Z$22,3)),IF(D16=\"\",0,VLOOKUP(D16,tabellen!X$3:Z$22,3)))))","v":""}]
[null,{"$f":"'aanvoer gewas'!B19","v":2003},{"$f":"IF('aanvoer gewas'!C19=\"\",\"\",'aanvoer gewas'!C19)","v":""},null,{"$f":"IF(C16=\"\",\"\",IF(D16=\"\",0,VLOOKUP(D16,tabellen!X$3:Y$22,2)))","v":""},{"$f":"IF(C16=\"\",\"\",IF(tabellen!AD$1=FALSE,IF(C15=\"\",\"\",IF(D15=\"\",0,VLOOKUP(D15,tabellen!X$3:Z$22,3))),IF(C17=\"\",IF(D$7=\"\",0,VLOOKUP(D$7,tabellen!X$3:Z$22,3)),IF(D17=\"\",0,VLOOKUP(D17,tabellen!X$3:Z$22,3)))))","v":""}]
[{"$nulls":3},"gemiddelde jaarlijkse organische stofaanvoer",{"$f":"AVERAGE(E7:E16)","v":{"$error":"#DIV/0!"}}]
[]
[{"$nulls":4},"<<terug","verder>>"]
{"$rows_empty":9}
[{"$nulls":4},"organische stofbalans (5/7)"]

{"sheet":"resultaat","index":5,"n_rows":40,"n_cols":6,"rows_kept":40,"merged":[[1,1,1,5],[6,3,6,5],[20,4,20,5],[22,1,24,5]]}
[]
[null,"ORGANISCHE STOFBALANS"]
[]
[null,"resultaat organische stofbalans"]
[]
[]
[null,null,"perceel",{"$f":"basis!C13","v":0}]
[]
[]
[{"$nulls":3},"kg effectieve organische stof per hectare"]
[]
[null,null,"gemiddelde jaarlijks aanvoer",{"$f":"'aanvoer gewas'!D20+'aanvoer mest'!J18+'aanvoer compost'!J18+'aanvoer groenbemesters'!E17","v":{"$error":"#DIV/0!"}}]
[]
[null,null,"gemiddelde jaarlijks afbraak",{"$f":"IF(basis!C15<23,(basis!C15/100*10)*0.3*(-0.37*LN(basis!C15)+1.8398)*10^6*0.0487*basis!C15^-0.453*0.57,3145.513)","v":{"$error":"#NUM!"}}]
[]
[]
[null,null,"resultaat organische stofbalans:",{"$f":"D12-D14","v":{"$error":"#DIV/0!"}}]
[]
[]
[]
[null,null,"<<<< terug naar begin","<<terug","totaal overzicht>>"]
[]
[null,"Heeft u een tekort op de balans? Lees in de tabel hiernaast af of dit tekort op de lange termijn te hoog wordt. (Lees af bij het OS% van het perceel). "]
{"$rows_empty":16}
[{"$nulls":5},"organische stofbalans (6/7)"]

{"sheet":"totaal overzicht OSBalans","index":6,"n_rows":24,"n_cols":13,"rows_kept":24,"merged":[[3,2,3,3],[3,4,3,6],[3,7,3,9],[3,10,3,11],[22,9,22,10],[23,1,23,12]]}
[null,"organische stofbalans"]
[null,{"$f":"\"perceel: \"&basis!C13","v":"perceel: "}]
[]
[null,null,"gewasaanvoer",null,"aanvoer mest",null,null,"aanvoer compost",null,null,"aanvoer groenbemester",null,"totaal"]
[{"$nulls":3},"eff.org.stof per hectare","soort mest","ton per ha","eff.org.stof per hectare","soort compost","ton per ha","eff.org.stof per hectare","soort groenbem.","eff.org.stof per hectare","eff.org.stof per hectare"]
[null,{"$f":"'aanvoer gewas'!B10","v":2012},{"$f":"IF('aanvoer gewas'!C10=\"\",\"\",'aanvoer gewas'!C10)","v":""},{"$f":"IF(C6=\"\",0,VLOOKUP(C6,tabellen!E$3:F$197,2))","v":0},{"$f":"IF(AND('aanvoer mest'!D8=\"\",'aanvoer mest'!G8=\"\"),\"\",IF(AND('aanvoer mest'!D8=\"\",'aanvoer mest'!G8<>\"\"),'aanvoer mest'!G8,IF(AND('aanvoer mest'!G8=\"\",'aanvoer mest'!D8<>\"\"),'aanvoer mest'!D8,'aanvoer mest'!D8&\" / \"&'aanvoer mest'!G8)))","v":""},{"$f":"IF(AND('aanvoer mest'!D8=\"\",'aanvoer mest'!G8=\"\"),\"\",IF(AND('aanvoer mest'!D8=\"\",'aanvoer mest'!G8<>\"\"),'aanvoer mest'!H8,IF(AND('aanvoer mest'!G8=\"\",'aanvoer mest'!D8<>\"\"),'aanvoer mest'!E8,'aanvoer mest'!E8&\" / \"&'aanvoer mest'!H8)))","v":""},{"$f":"IF(E6=\"\",0,'aanvoer mest'!J8)","v":0},{"$f":"IF(AND('aanvoer compost'!D8=\"\",'aanvoer compost'!G8=\"\"),\"\",IF(AND('aanvoer compost'!D8=\"\",'aanvoer compost'!G8<>\"\"),'aanvoer compost'!G8,IF(AND('aanvoer compost'!G8=\"\",'aanvoer compost'!D8<>\"\"),'aanvoer compost'!D8,'aanvoer compost'!D8&\" / \"&'aanvoer compost'!G8)))","v":""},{"$f":"IF(AND('aanvoer compost'!D8=\"\",'aanvoer compost'!G8=\"\"),\"\",IF(AND('aanvoer compost'!D8=\"\",'aanvoer compost'!G8<>\"\"),'aanvoer compost'!H8,IF(AND('aanvoer compost'!G8=\"\",'aanvoer compost'!D8<>\"\"),'aanvoer compost'!E8,'aanvoer compost'!E8&\" / \"&'aanvoer compost'!H8)))","v":""},{"$f":"IF(H6=\"\",0,'aanvoer compost'!J8)","v":0},{"$f":"IF('aanvoer groenbemesters'!D7=\"\",\"\",'aanvoer groenbemesters'!D7)","v":""},{"$f":"IF(K6=\"\",0,VLOOKUP(K6,tabellen!X$3:Y$22,2))","v":0},{"$f":"IF(D6+G6+J6+L6=0,\"\",D6+G6+J6+L6)","v":""}]
[null,{"$f":"'aanvoer gewas'!B11","v":2011},{"$f":"IF('aanvoer gewas'!C11=\"\",\"\",'aanvoer gewas'!C11)","v":""},{"$f":"IF(C7=\"\",0,VLOOKUP(C7,tabellen!E$3:F$197,2))","v":0},{"$f":"IF(AND('aanvoer mest'!D9=\"\",'aanvoer mest'!G9=\"\"),\"\",IF(AND('aanvoer mest'!D9=\"\",'aanvoer mest'!G9<>\"\"),'aanvoer mest'!G9,IF(AND('aanvoer mest'!G9=\"\",'aanvoer mest'!D9<>\"\"),'aanvoer mest'!D9,'aanvoer mest'!D9&\" / \"&'aanvoer mest'!G9)))","v":""},{"$f":"IF(AND('aanvoer mest'!D9=\"\",'aanvoer mest'!G9=\"\"),\"\",IF(AND('aanvoer mest'!D9=\"\",'aanvoer mest'!G9<>\"\"),'aanvoer mest'!H9,IF(AND('aanvoer mest'!G9=\"\",'aanvoer mest'!D9<>\"\"),'aanvoer mest'!E9,'aanvoer mest'!E9&\" / \"&'aanvoer mest'!H9)))","v":""},{"$f":"IF(E7=\"\",0,'aanvoer mest'!J9)","v":0},{"$f":"IF(AND('aanvoer compost'!D9=\"\",'aanvoer compost'!G9=\"\"),\"\",IF(AND('aanvoer compost'!D9=\"\",'aanvoer compost'!G9<>\"\"),'aanvoer compost'!G9,IF(AND('aanvoer compost'!G9=\"\",'aanvoer compost'!D9<>\"\"),'aanvoer compost'!D9,'aanvoer compost'!D9&\" / \"&'aanvoer compost'!G9)))","v":""},{"$f":"IF(AND('aanvoer compost'!D9=\"\",'aanvoer compost'!G9=\"\"),\"\",IF(AND('aanvoer compost'!D9=\"\",'aanvoer compost'!G9<>\"\"),'aanvoer compost'!H9,IF(AND('aanvoer compost'!G9=\"\",'aanvoer compost'!D9<>\"\"),'aanvoer compost'!E9,'aanvoer compost'!E9&\" / \"&'aanvoer compost'!H9)))","v":""},{"$f":"IF(H7=\"\",0,'aanvoer compost'!J9)","v":0},{"$f":"IF('aanvoer groenbemesters'!D8=\"\",\"\",'aanvoer groenbemesters'!D8)","v":""},{"$f":"IF(K7=\"\",0,VLOOKUP(K7,tabellen!X$3:Y$22,2))","v":0},""]
[null,{"$f":"'aanvoer gewas'!B12","v":2010},{"$f":"IF('aanvoer gewas'!C12=\"\",\"\",'aanvoer gewas'!C12)","v":""},{"$f":"IF(C8=\"\",0,VLOOKUP(C8,tabellen!E$3:F$197,2))","v":0},{"$f":"IF(AND('aanvoer mest'!D10=\"\",'aanvoer mest'!G10=\"\"),\"\",IF(AND('aanvoer mest'!D10=\"\",'aanvoer mest'!G10<>\"\"),'aanvoer mest'!G10,IF(AND('aanvoer mest'!G10=\"\",'aanvoer mest'!D10<>\"\"),'aanvoer mest'!D10,'aanvoer mest'!D10&\" / \"&'aanvoer mest'!G10)))","v":""},{"$f":"IF(AND('aanvoer mest'!D10=\"\",'aanvoer mest'!G10=\"\"),\"\",IF(AND('aanvoer mest'!D10=\"\",'aanvoer mest'!G10<>\"\"),'aanvoer mest'!H10,IF(AND('aanvoer mest'!G10=\"\",'aanvoer mest'!D10<>\"\"),'aanvoer mest'!E10,'aanvoer mest'!E10&\" / \"&'aanvoer mest'!H10)))","v":""},{"$f":"IF(E8=\"\",0,'aanvoer mest'!J10)","v":0},{"$f":"IF(AND('aanvoer compost'!D10=\"\",'aanvoer compost'!G10=\"\"),\"\",IF(AND('aanvoer compost'!D10=\"\",'aanvoer compost'!G10<>\"\"),'aanvoer compost'!G10,IF(AND('aanvoer compost'!G10=\"\",'aanvoer compost'!D10<>\"\"),'aanvoer compost'!D10,'aanvoer compost'!D10&\" / \"&'aanvoer compost'!G10)))","v":""},{"$f":"IF(AND('aanvoer compost'!D10=\"\",'aanvoer compost'!G10=\"\"),\"\",IF(AND('aanvoer compost'!D10=\"\",'aanvoer compost'!G10<>\"\"),'aanvoer compost'!H10,IF(AND('aanvoer compost'!G10=\"\",'aanvoer compost'!D10<>\"\"),'aanvoer compost'!E10,'aanvoer compost'!E10&\" / \"&'aanvoer compost'!H10)))","v":""},{"$f":"IF(H8=\"\",0,'aanvoer compost'!J10)","v":0},{"$f":"IF('aanvoer groenbemesters'!D9=\"\",\"\",'aanvoer groenbemesters'!D9)","v":""},{"$f":"IF(K8=\"\",0,VLOOKUP(K8,tabellen!X$3:Y$22,2))","v":0},""]
[null,{"$f":"'aanvoer gewas'!B13","v":2009},{"$f":"IF('aanvoer gewas'!C13=\"\",\"\",'aanvoer gewas'!C13)","v":""},{"$f":"IF(C9=\"\",0,VLOOKUP(C9,tabellen!E$3:F$197,2))","v":0},{"$f":"IF(AND('aanvoer mest'!D11=\"\",'aanvoer mest'!G11=\"\"),\"\",IF(AND('aanvoer mest'!D11=\"\",'aanvoer mest'!G11<>\"\"),'aanvoer mest'!G11,IF(AND('aanvoer mest'!G11=\"\",'aanvoer mest'!D11<>\"\"),'aanvoer mest'!D11,'aanvoer mest'!D11&\" / \"&'aanvoer mest'!G11)))","v":""},{"$f":"IF(AND('aanvoer mest'!D11=\"\",'aanvoer mest'!G11=\"\"),\"\",IF(AND('aanvoer mest'!D11=\"\",'aanvoer mest'!G11<>\"\"),'aanvoer mest'!H11,IF(AND('aanvoer mest'!G11=\"\",'aanvoer mest'!D11<>\"\"),'aanvoer mest'!E11,'aanvoer mest'!E11&\" / \"&'aanvoer mest'!H11)))","v":""},{"$f":"IF(E9=\"\",0,'aanvoer mest'!J11)","v":0},{"$f":"IF(AND('aanvoer compost'!D11=\"\",'aanvoer compost'!G11=\"\"),\"\",IF(AND('aanvoer compost'!D11=\"\",'aanvoer compost'!G11<>\"\"),'aanvoer compost'!G11,IF(AND('aanvoer compost'!G11=\"\",'aanvoer compost'!D11<>\"\"),'aanvoer compost'!D11,'aanvoer compost'!D11&\" / \"&'aanvoer compost'!G11)))","v":""},{"$f":"IF(AND('aanvoer compost'!D11=\"\",'aanvoer compost'!G11=\"\"),\"\",IF(AND('aanvoer compost'!D11=\"\",'aanvoer compost'!G11<>\"\"),'aanvoer compost'!H11,IF(AND('aanvoer compost'!G11=\"\",'aanvoer compost'!D11<>\"\"),'aanvoer compost'!E11,'aanvoer compost'!E11&\" / \"&'aanvoer compost'!H11)))","v":""},{"$f":"IF(H9=\"\",0,'aanvoer compost'!J11)","v":0},{"$f":"IF('aanvoer groenbemesters'!D10=\"\",\"\",'aanvoer groenbemesters'!D10)","v":""},{"$f":"IF(K9=\"\",0,VLOOKUP(K9,tabellen!X$3:Y$22,2))","v":0},""]
[null,{"$f":"'aanvoer gewas'!B14","v":2008},{"$f":"IF('aanvoer gewas'!C14=\"\",\"\",'aanvoer gewas'!C14)","v":""},{"$f":"IF(C10=\"\",0,VLOOKUP(C10,tabellen!E$3:F$197,2))","v":0},{"$f":"IF(AND('aanvoer mest'!D12=\"\",'aanvoer mest'!G12=\"\"),\"\",IF(AND('aanvoer mest'!D12=\"\",'aanvoer mest'!G12<>\"\"),'aanvoer mest'!G12,IF(AND('aanvoer mest'!G12=\"\",'aanvoer mest'!D12<>\"\"),'aanvoer mest'!D12,'aanvoer mest'!D12&\" / \"&'aanvoer mest'!G12)))","v":""},{"$f":"IF(AND('aanvoer mest'!D12=\"\",'aanvoer mest'!G12=\"\"),\"\",IF(AND('aanvoer mest'!D12=\"\",'aanvoer mest'!G12<>\"\"),'aanvoer mest'!H12,IF(AND('aanvoer mest'!G12=\"\",'aanvoer mest'!D12<>\"\"),'aanvoer mest'!E12,'aanvoer mest'!E12&\" / \"&'aanvoer mest'!H12)))","v":""},{"$f":"IF(E10=\"\",0,'aanvoer mest'!J12)","v":0},{"$f":"IF(AND('aanvoer compost'!D12=\"\",'aanvoer compost'!G12=\"\"),\"\",IF(AND('aanvoer compost'!D12=\"\",'aanvoer compost'!G12<>\"\"),'aanvoer compost'!G12,IF(AND('aanvoer compost'!G12=\"\",'aanvoer compost'!D12<>\"\"),'aanvoer compost'!D12,'aanvoer compost'!D12&\" / \"&'aanvoer compost'!G12)))","v":""},{"$f":"IF(AND('aanvoer compost'!D12=\"\",'aanvoer compost'!G12=\"\"),\"\",IF(AND('aanvoer compost'!D12=\"\",'aanvoer compost'!G12<>\"\"),'aanvoer compost'!H12,IF(AND('aanvoer compost'!G12=\"\",'aanvoer compost'!D12<>\"\"),'aanvoer compost'!E12,'aanvoer compost'!E12&\" / \"&'aanvoer compost'!H12)))","v":""},{"$f":"IF(H10=\"\",0,'aanvoer compost'!J12)","v":0},{"$f":"IF('aanvoer groenbemesters'!D11=\"\",\"\",'aanvoer groenbemesters'!D11)","v":""},{"$f":"IF(K10=\"\",0,VLOOKUP(K10,tabellen!X$3:Y$22,2))","v":0},""]
[null,{"$f":"'aanvoer gewas'!B15","v":2007},{"$f":"IF('aanvoer gewas'!C15=\"\",\"\",'aanvoer gewas'!C15)","v":""},{"$f":"IF(C11=\"\",0,VLOOKUP(C11,tabellen!E$3:F$197,2))","v":0},{"$f":"IF(AND('aanvoer mest'!D13=\"\",'aanvoer mest'!G13=\"\"),\"\",IF(AND('aanvoer mest'!D13=\"\",'aanvoer mest'!G13<>\"\"),'aanvoer mest'!G13,IF(AND('aanvoer mest'!G13=\"\",'aanvoer mest'!D13<>\"\"),'aanvoer mest'!D13,'aanvoer mest'!D13&\" / \"&'aanvoer mest'!G13)))","v":""},{"$f":"IF(AND('aanvoer mest'!D13=\"\",'aanvoer mest'!G13=\"\"),\"\",IF(AND('aanvoer mest'!D13=\"\",'aanvoer mest'!G13<>\"\"),'aanvoer mest'!H13,IF(AND('aanvoer mest'!G13=\"\",'aanvoer mest'!D13<>\"\"),'aanvoer mest'!E13,'aanvoer mest'!E13&\" / \"&'aanvoer mest'!H13)))","v":""},{"$f":"IF(E11=\"\",0,'aanvoer mest'!J13)","v":0},{"$f":"IF(AND('aanvoer compost'!D13=\"\",'aanvoer compost'!G13=\"\"),\"\",IF(AND('aanvoer compost'!D13=\"\",'aanvoer compost'!G13<>\"\"),'aanvoer compost'!G13,IF(AND('aanvoer compost'!G13=\"\",'aanvoer compost'!D13<>\"\"),'aanvoer compost'!D13,'aanvoer compost'!D13&\" / \"&'aanvoer compost'!G13)))","v":""},{"$f":"IF(AND('aanvoer compost'!D13=\"\",'aanvoer compost'!G13=\"\"),\"\",IF(AND('aanvoer compost'!D13=\"\",'aanvoer compost'!G13<>\"\"),'aanvoer compost'!H13,IF(AND('aanvoer compost'!G13=\"\",'aanvoer compost'!D13<>\"\"),'aanvoer compost'!E13,'aanvoer compost'!E13&\" / \"&'aanvoer compost'!H13)))","v":""},{"$f":"IF(H11=\"\",0,'aanvoer compost'!J13)","v":0},{"$f":"IF('aanvoer groenbemesters'!D12=\"\",\"\",'aanvoer groenbemesters'!D12)","v":""},{"$f":"IF(K11=\"\",0,VLOOKUP(K11,tabellen!X$3:Y$22,2))","v":0},""]
[null,{"$f":"'aanvoer gewas'!B16","v":2006},{"$f":"IF('aanvoer gewas'!C16=\"\",\"\",'aanvoer gewas'!C16)","v":""},{"$f":"IF(C12=\"\",0,VLOOKUP(C12,tabellen!E$3:F$197,2))","v":0},{"$f":"IF(AND('aanvoer mest'!D14=\"\",'aanvoer mest'!G14=\"\"),\"\",IF(AND('aanvoer mest'!D14=\"\",'aanvoer mest'!G14<>\"\"),'aanvoer mest'!G14,IF(AND('aanvoer mest'!G14=\"\",'aanvoer mest'!D14<>\"\"),'aanvoer mest'!D14,'aanvoer mest'!D14&\" / \"&'aanvoer mest'!G14)))","v":""},{"$f":"IF(AND('aanvoer mest'!D14=\"\",'aanvoer mest'!G14=\"\"),\"\",IF(AND('aanvoer mest'!D14=\"\",'aanvoer mest'!G14<>\"\"),'aanvoer mest'!H14,IF(AND('aanvoer mest'!G14=\"\",'aanvoer mest'!D14<>\"\"),'aanvoer mest'!E14,'aanvoer mest'!E14&\" / \"&'aanvoer mest'!H14)))","v":""},{"$f":"IF(E12=\"\",0,'aanvoer mest'!J14)","v":0},{"$f":"IF(AND('aanvoer compost'!D14=\"\",'aanvoer compost'!G14=\"\"),\"\",IF(AND('aanvoer compost'!D14=\"\",'aanvoer compost'!G14<>\"\"),'aanvoer compost'!G14,IF(AND('aanvoer compost'!G14=\"\",'aanvoer compost'!D14<>\"\"),'aanvoer compost'!D14,'aanvoer compost'!D14&\" / \"&'aanvoer compost'!G14)))","v":""},{"$f":"IF(AND('aanvoer compost'!D14=\"\",'aanvoer compost'!G14=\"\"),\"\",IF(AND('aanvoer compost'!D14=\"\",'aanvoer compost'!G14<>\"\"),'aanvoer compost'!H14,IF(AND('aanvoer compost'!G14=\"\",'aanvoer compost'!D14<>\"\"),'aanvoer compost'!E14,'aanvoer compost'!E14&\" / \"&'aanvoer compost'!H14)))","v":""},{"$f":"IF(H12=\"\",0,'aanvoer compost'!J14)","v":0},{"$f":"IF('aanvoer groenbemesters'!D13=\"\",\"\",'aanvoer groenbemesters'!D13)","v":""},{"$f":"IF(K12=\"\",0,VLOOKUP(K12,tabellen!X$3:Y$22,2))","v":0},""]
[null,{"$f":"'aanvoer gewas'!B17","v":2005},{"$f":"IF('aanvoer gewas'!C17=\"\",\"\",'aanvoer gewas'!C17)","v":""},{"$f":"IF(C13=\"\",0,VLOOKUP(C13,tabellen!E$3:F$197,2))","v":0},{"$f":"IF(AND('aanvoer mest'!D15=\"\",'aanvoer mest'!G15=\"\"),\"\",IF(AND('aanvoer mest'!D15=\"\",'aanvoer mest'!G15<>\"\"),'aanvoer mest'!G15,IF(AND('aanvoer mest'!G15=\"\",'aanvoer mest'!D15<>\"\"),'aanvoer mest'!D15,'aanvoer mest'!D15&\" / \"&'aanvoer mest'!G15)))","v":""},{"$f":"IF(AND('aanvoer mest'!D15=\"\",'aanvoer mest'!G15=\"\"),\"\",IF(AND('aanvoer mest'!D15=\"\",'aanvoer mest'!G15<>\"\"),'aanvoer mest'!H15,IF(AND('aanvoer mest'!G15=\"\",'aanvoer mest'!D15<>\"\"),'aanvoer mest'!E15,'aanvoer mest'!E15&\" / \"&'aanvoer mest'!H15)))","v":""},{"$f":"IF(E13=\"\",0,'aanvoer mest'!J15)","v":0},{"$f":"IF(AND('aanvoer compost'!D15=\"\",'aanvoer compost'!G15=\"\"),\"\",IF(AND('aanvoer compost'!D15=\"\",'aanvoer compost'!G15<>\"\"),'aanvoer compost'!G15,IF(AND('aanvoer compost'!G15=\"\",'aanvoer compost'!D15<>\"\"),'aanvoer compost'!D15,'aanvoer compost'!D15&\" / \"&'aanvoer compost'!G15)))","v":""},{"$f":"IF(AND('aanvoer compost'!D15=\"\",'aanvoer compost'!G15=\"\"),\"\",IF(AND('aanvoer compost'!D15=\"\",'aanvoer compost'!G15<>\"\"),'aanvoer compost'!H15,IF(AND('aanvoer compost'!G15=\"\",'aanvoer compost'!D15<>\"\"),'aanvoer compost'!E15,'aanvoer compost'!E15&\" / \"&'aanvoer compost'!H15)))","v":""},{"$f":"IF(H13=\"\",0,'aanvoer compost'!J15)","v":0},{"$f":"IF('aanvoer groenbemesters'!D14=\"\",\"\",'aanvoer groenbemesters'!D14)","v":""},{"$f":"IF(K13=\"\",0,VLOOKUP(K13,tabellen!X$3:Y$22,2))","v":0},""]
[null,{"$f":"'aanvoer gewas'!B18","v":2004},{"$f":"IF('aanvoer gewas'!C18=\"\",\"\",'aanvoer gewas'!C18)","v":""},{"$f":"IF(C14=\"\",0,VLOOKUP(C14,tabellen!E$3:F$197,2))","v":0},{"$f":"IF(AND('aanvoer mest'!D16=\"\",'aanvoer mest'!G16=\"\"),\"\",IF(AND('aanvoer mest'!D16=\"\",'aanvoer mest'!G16<>\"\"),'aanvoer mest'!G16,IF(AND('aanvoer mest'!G16=\"\",'aanvoer mest'!D16<>\"\"),'aanvoer mest'!D16,'aanvoer mest'!D16&\" / \"&'aanvoer mest'!G16)))","v":""},{"$f":"IF(AND('aanvoer mest'!D16=\"\",'aanvoer mest'!G16=\"\"),\"\",IF(AND('aanvoer mest'!D16=\"\",'aanvoer mest'!G16<>\"\"),'aanvoer mest'!H16,IF(AND('aanvoer mest'!G16=\"\",'aanvoer mest'!D16<>\"\"),'aanvoer mest'!E16,'aanvoer mest'!E16&\" / \"&'aanvoer mest'!H16)))","v":""},{"$f":"IF(E14=\"\",0,'aanvoer mest'!J16)","v":0},{"$f":"IF(AND('aanvoer compost'!D16=\"\",'aanvoer compost'!G16=\"\"),\"\",IF(AND('aanvoer compost'!D16=\"\",'aanvoer compost'!G16<>\"\"),'aanvoer compost'!G16,IF(AND('aanvoer compost'!G16=\"\",'aanvoer compost'!D16<>\"\"),'aanvoer compost'!D16,'aanvoer compost'!D16&\" / \"&'aanvoer compost'!G16)))","v":""},{"$f":"IF(AND('aanvoer compost'!D16=\"\",'aanvoer compost'!G16=\"\"),\"\",IF(AND('aanvoer compost'!D16=\"\",'aanvoer compost'!G16<>\"\"),'aanvoer compost'!H16,IF(AND('aanvoer compost'!G16=\"\",'aanvoer compost'!D16<>\"\"),'aanvoer compost'!E16,'aanvoer compost'!E16&\" / \"&'aanvoer compost'!H16)))","v":""},{"$f":"IF(H14=\"\",0,'aanvoer compost'!J16)","v":0},{"$f":"IF('aanvoer groenbemesters'!D15=\"\",\"\",'aanvoer groenbemesters'!D15)","v":""},{"$f":"IF(K14=\"\",0,VLOOKUP(K14,tabellen!X$3:Y$22,2))","v":0},""]
[null,{"$f":"'aanvoer gewas'!B19","v":2003},{"$f":"IF('aanvoer gewas'!C19=\"\",\"\",'aanvoer gewas'!C19)","v":""},{"$f":"IF(C15=\"\",0,VLOOKUP(C15,tabellen!E$3:F$197,2))","v":0},{"$f":"IF(AND('aanvoer mest'!D17=\"\",'aanvoer mest'!G17=\"\"),\"\",IF(AND('aanvoer mest'!D17=\"\",'aanvoer mest'!G17<>\"\"),'aanvoer mest'!G17,IF(AND('aanvoer mest'!G17=\"\",'aanvoer mest'!D17<>\"\"),'aanvoer mest'!D17,'aanvoer mest'!D17&\" / \"&'aanvoer mest'!G17)))","v":""},{"$f":"IF(AND('aanvoer mest'!D17=\"\",'aanvoer mest'!G17=\"\"),\"\",IF(AND('aanvoer mest'!D17=\"\",'aanvoer mest'!G17<>\"\"),'aanvoer mest'!H17,IF(AND('aanvoer mest'!G17=\"\",'aanvoer mest'!D17<>\"\"),'aanvoer mest'!E17,'aanvoer mest'!E17&\" / \"&'aanvoer mest'!H17)))","v":""},{"$f":"IF(E15=\"\",0,'aanvoer mest'!J17)","v":0},{"$f":"IF(AND('aanvoer compost'!D17=\"\",'aanvoer compost'!G17=\"\"),\"\",IF(AND('aanvoer compost'!D17=\"\",'aanvoer compost'!G17<>\"\"),'aanvoer compost'!G17,IF(AND('aanvoer compost'!G17=\"\",'aanvoer compost'!D17<>\"\"),'aanvoer compost'!D17,'aanvoer compost'!D17&\" / \"&'aanvoer compost'!G17)))","v":""},{"$f":"IF(AND('aanvoer compost'!D17=\"\",'aanvoer compost'!G17=\"\"),\"\",IF(AND('aanvoer compost'!D17=\"\",'aanvoer compost'!G17<>\"\"),'aanvoer compost'!H17,IF(AND('aanvoer compost'!G17=\"\",'aanvoer compost'!D17<>\"\"),'aanvoer compost'!E17,'aanvoer compost'!E17&\" / \"&'aanvoer compost'!H17)))","v":""},{"$f":"IF(H15=\"\",0,'aanvoer compost'!J17)","v":0},{"$f":"IF('aanvoer groenbemesters'!D16=\"\",\"\",'aanvoer groenbemesters'!D16)","v":""},{"$f":"IF(K15=\"\",0,VLOOKUP(K15,tabellen!X$3:Y$22,2))","v":0},""]
[null,null,"gemiddelde",{"$f":"'aanvoer gewas'!D20","v":{"$error":"#DIV/0!"}},null,"gemiddelde",{"$f":"'aanvoer mest'!J18","v":{"$error":"#DIV/0!"}},null,"gemiddelde",{"$f":"'aanvoer compost'!J18","v":{"$error":"#DIV/0!"}},"gemiddelde",{"$f":"'aanvoer groenbemesters'!E17","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(M6:M15)","v":{"$error":"#DIV/0!"}}]
[]
[{"$nulls":10},"jaarlijkse aanvoer per hectare",null,{"$f":"AVERAGE(M6:M15)","v":{"$error":"#DIV/0!"}}]
[{"$nulls":10},{"$f":"\"jaarlijkse afbraak van organische stof bij \"&basis!C15&\"% organische stof\"","v":"jaarlijkse afbraak van organische stof bij % organische stof"},null,{"$f":"resultaat!D14","v":{"$error":"#NUM!"}}]
[]
[{"$nulls":10},"resultaat (aanvoer-afbraak)",null,{"$f":"M18-M19","v":{"$error":"#DIV/0!"}}]
[]
[null,null,"<<<< terug naar begin",null,null,"<<terug",{"$nulls":3},"naar overzicht N-levering>>"]
[null,"Disclaimer: Dit advies is met de grootst mogelijke zorgvuldigheid samengesteld. Desondanks kan dit advies informatie bevatten die incorrect en/of incompleet is. Aan de inhoud ervan kunnen geen rechten worden ontleend. HLB aanvaardt geen aansprakelijkheid voor directe of indirecte schade die het gevolg is van het gebruik van informatie van dit advies. De inhoud van dit advies mag niet worden gebruikt voor publicatie zonder toestemming van HLB."]

{"sheet":"totaal overzicht Nmineralisatie","index":7,"n_rows":21,"n_cols":21,"rows_kept":21,"merged":[[3,1,5,1],[3,3,3,12],[3,13,3,18],[3,19,4,20],[4,3,4,4],[4,5,4,7],[4,8,4,10],[4,11,4,12],[4,13,4,15],[4,16,4,18],[19,3,19,4],[20,1,20,20]]}
[null,"N-mineralisatie"]
[null,{"$f":"\"perceel: \"&basis!C13","v":"perceel: "}]
[]
[{"$nulls":3},"N-levering uit aanvoer voorgaand jaar",{"$nulls":9},"N-levering uit aanvoer huidig jaar",{"$nulls":5},"totale N-levering tijdens groeiseizoen"]
[{"$nulls":3},"voorvrucht",null,"aanvoer mest",null,null,"aanvoer compost",null,null,"aanvoer groenbemester",null,"aanvoer mest",null,null,"aanvoer compost"]
[null,null,"gewas","voorvrucht","beschikbare N (kg/ha)","mest najaar","ton per ha","beschikbare N (kg/ha)","compost najaar","ton per ha","beschikbare N (kg/ha)","groen-bemester najaar","beschikbare N (kg/ha)","mest voorjaar","ton per ha","beschikbare N (kg/ha)","compost voorjaar","ton per ha","beschikbare N (kg/ha)","beschikbare N (excl. bodem org. stof) (kg/ha)","beschikbare N (incl. bodem org. stof) (kg/ha)"]
[null,{"$f":"'aanvoer gewas'!B10","v":2012},{"$f":"IF('aanvoer gewas'!C10=\"\",\"\",'aanvoer gewas'!C10)","v":""},{"$f":"IF(tabellen!AD$1=FALSE,IF(C7=\"\",\"\",IF(C8=\"\",'aanvoer gewas'!C10,IF(C9=\"\",'aanvoer gewas'!C11,IF(C10=\"\",'aanvoer gewas'!C12,IF(C11=\"\",'aanvoer gewas'!C13,IF(C12=\"\",'aanvoer gewas'!C14,IF(C13=\"\",'aanvoer gewas'!C15,IF(C14=\"\",'aanvoer gewas'!C16,IF(C15=\"\",'aanvoer gewas'!C17,IF(C16=\"\",'aanvoer gewas'!C18,IF(C16<>\"\",'aanvoer gewas'!C19,0))))))))))),IF(C8=\"\",IF(C7=\"\",0,'aanvoer gewas'!C10),IF(C8=\"\",0,'aanvoer gewas'!C11)))","v":0},{"$f":"IF(D7=\"\",\"\",'aanvoer gewas'!E10)","v":0},{"$f":"IF(tabellen!AD$1=FALSE,IF(C7=\"\",\"\",IF(C8=\"\",'aanvoer mest'!G8,IF(C9=\"\",'aanvoer mest'!G9,IF(C10=\"\",'aanvoer mest'!G10,IF(C11=\"\",'aanvoer mest'!G11,IF(C12=\"\",'aanvoer mest'!G12,IF(C13=\"\",'aanvoer mest'!G13,IF(C14=\"\",'aanvoer mest'!G14,IF(C15=\"\",'aanvoer mest'!G15,IF(C16=\"\",'aanvoer mest'!G16,IF(C16<>\"\",'aanvoer mest'!G17,\"\"))))))))))),IF(C8=\"\",IF(C7=\"\",0,'aanvoer mest'!G8),IF(C8=\"\",0,'aanvoer mest'!G9)))","v":0},{"$f":"IF(tabellen!AD$1=FALSE,IF(C7=\"\",\"\",IF(C8=\"\",'aanvoer mest'!H8,IF(C9=\"\",'aanvoer mest'!H9,IF(C10=\"\",'aanvoer mest'!H10,IF(C11=\"\",'aanvoer mest'!H11,IF(C12=\"\",'aanvoer mest'!H12,IF(C13=\"\",'aanvoer mest'!H13,IF(C14=\"\",'aanvoer mest'!H14,IF(C15=\"\",'aanvoer mest'!H15,IF(C16=\"\",'aanvoer mest'!H16,IF(C16<>\"\",'aanvoer mest'!H17,\"\"))))))))))),IF(C8=\"\",IF(C7=\"\",0,'aanvoer mest'!H8),IF(C8=\"\",0,'aanvoer mest'!H9)))","v":0},{"$f":"IF(tabellen!AD1=FALSE,IF(AND('aanvoer mest'!C8=\"\",'aanvoer mest'!G8=\"\"),\"\",IF(AND('aanvoer mest'!C9=\"\",'aanvoer mest'!G8<>\"\"),VLOOKUP('aanvoer mest'!G8,tabellen!I$3:V$10,5)*'aanvoer mest'!H8*'aanvoer mest'!I8,IF(AND('aanvoer mest'!C10=\"\",'aanvoer mest'!G9<>\"\"),VLOOKUP('aanvoer mest'!G9,tabellen!I$3:N$24,5)*'aanvoer mest'!H9*'aanvoer mest'!I9,IF(AND('aanvoer mest'!C11=\"\",'aanvoer mest'!G10<>\"\"),VLOOKUP('aanvoer mest'!G10,tabellen!I$3:N$24,5)*'aanvoer mest'!H10*'aanvoer mest'!I10,IF(AND('aanvoer mest'!C12=\"\",'aanvoer mest'!G11<>\"\"),VLOOKUP('aanvoer mest'!G11,tabellen!I$3:N$24,5)*'aanvoer mest'!H11*'aanvoer mest'!I11,IF(AND('aanvoer mest'!C13=\"\",'aanvoer mest'!G12<>\"\"),VLOOKUP('aanvoer mest'!G12,tabellen!I$3:N$24,5)*'aanvoer mest'!H12*'aanvoer mest'!I12,IF(AND('aanvoer mest'!C14=\"\",'aanvoer mest'!G13<>\"\"),VLOOKUP('aanvoer mest'!G13,tabellen!I$3:N$24,5)*'aanvoer mest'!H13*'aanvoer mest'!I13,IF(AND('aanvoer mest'!C15=\"\",'aanvoer mest'!G14<>\"\"),VLOOKUP('aanvoer mest'!G14,tabellen!I$3:N$24,5)*'aanvoer mest'!H14*'aanvoer mest'!I14,IF(AND('aanvoer mest'!C16=\"\",'aanvoer mest'!G15<>\"\"),VLOOKUP('aanvoer mest'!G15,tabellen!I$3:N$24,5)*'aanvoer mest'!H15*'aanvoer mest'!I15,IF(AND('aanvoer mest'!C17=\"\",'aanvoer mest'!G16<>\"\"),VLOOKUP('aanvoer mest'!G16,tabellen!I$3:N$24,5)*'aanvoer mest'!H16*'aanvoer mest'!I16,IF(AND('aanvoer mest'!C17<>\"\",'aanvoer mest'!G17<>\"\"),VLOOKUP('aanvoer mest'!G17,tabellen!I$3:N$24,5)*'aanvoer mest'!H17*'aanvoer mest'!I17,0))))))))))),IF('aanvoer mest'!C9=\"\",IF('aanvoer mest'!G8=\"\",0,VLOOKUP('aanvoer mest'!G8,tabellen!I$3:N$24,5)*'aanvoer mest'!H8*'aanvoer mest'!I8),IF('aanvoer mest'!G9=\"\",0,VLOOKUP('aanvoer mest'!G9,tabellen!I$3:N$24,5)*'aanvoer mest'!H9*'aanvoer mest'!I9)))","v":0},{"$f":"IF(tabellen!AD$1=FALSE,IF(C7=\"\",\"\",IF(C8=\"\",'aanvoer compost'!G8,IF(C9=\"\",'aanvoer compost'!G9,IF(C10=\"\",'aanvoer compost'!G10,IF(C11=\"\",'aanvoer compost'!G11,IF(C12=\"\",'aanvoer compost'!G12,IF(C13=\"\",'aanvoer compost'!G13,IF(C14=\"\",'aanvoer compost'!G14,IF(C15=\"\",'aanvoer compost'!G15,IF(C16=\"\",'aanvoer compost'!G16,IF(C16<>\"\",'aanvoer compost'!G17,\"\"))))))))))),IF(C8=\"\",IF(C7=\"\",0,'aanvoer compost'!G8),IF(C8=\"\",0,'aanvoer compost'!G9)))","v":0},{"$f":"IF(tabellen!AD$1=FALSE,IF(C7=\"\",\"\",IF(C8=\"\",'aanvoer compost'!H8,IF(C9=\"\",'aanvoer compost'!H9,IF(C10=\"\",'aanvoer compost'!H10,IF(C11=\"\",'aanvoer compost'!H11,IF(C12=\"\",'aanvoer compost'!H12,IF(C13=\"\",'aanvoer compost'!H13,IF(C14=\"\",'aanvoer compost'!H14,IF(C15=\"\",'aanvoer compost'!H15,IF(C16=\"\",'aanvoer compost'!H16,IF(C16<>\"\",'aanvoer compost'!H17,\"\"))))))))))),IF(C8=\"\",IF(C7=\"\",0,'aanvoer compost'!H8),IF(C8=\"\",0,'aanvoer compost'!H9)))","v":0},{"$f":"IF(tabellen!AD1=FALSE,IF(AND('aanvoer compost'!C8=\"\",'aanvoer compost'!G8=\"\"),\"\",IF(AND('aanvoer compost'!C9=\"\",'aanvoer compost'!G8<>\"\"),VLOOKUP('aanvoer compost'!G8,tabellen!I$3:V$10,5)*'aanvoer compost'!H8*'aanvoer compost'!I8,IF(AND('aanvoer compost'!C10=\"\",'aanvoer compost'!G9<>\"\"),VLOOKUP('aanvoer compost'!G9,tabellen!Q$3:V$12,5)*'aanvoer compost'!H9*'aanvoer compost'!I9,IF(AND('aanvoer compost'!C11=\"\",'aanvoer compost'!G10<>\"\"),VLOOKUP('aanvoer compost'!G10,tabellen!Q$3:V$12,5)*'aanvoer compost'!H10*'aanvoer compost'!I10,IF(AND('aanvoer compost'!C12=\"\",'aanvoer compost'!G11<>\"\"),VLOOKUP('aanvoer compost'!G11,tabellen!Q$3:V$12,5)*'aanvoer compost'!H11*'aanvoer compost'!I11,IF(AND('aanvoer compost'!C13=\"\",'aanvoer compost'!G12<>\"\"),VLOOKUP('aanvoer compost'!G12,tabellen!Q$3:V$12,5)*'aanvoer compost'!H12*'aanvoer compost'!I12,IF(AND('aanvoer compost'!C14=\"\",'aanvoer compost'!G13<>\"\"),VLOOKUP('aanvoer compost'!G13,tabellen!Q$3:V$12,5)*'aanvoer compost'!H13*'aanvoer compost'!I13,IF(AND('aanvoer compost'!C15=\"\",'aanvoer compost'!G14<>\"\"),VLOOKUP('aanvoer compost'!G14,tabellen!Q$3:V$12,5)*'aanvoer compost'!H14*'aanvoer compost'!I14,IF(AND('aanvoer compost'!C16=\"\",'aanvoer compost'!G15<>\"\"),VLOOKUP('aanvoer compost'!G15,tabellen!Q$3:V$12,5)*'aanvoer compost'!H15*'aanvoer compost'!I15,IF(AND('aanvoer compost'!C17=\"\",'aanvoer compost'!G16<>\"\"),VLOOKUP('aanvoer compost'!G16,tabellen!Q$3:V$12,5)*'aanvoer compost'!H16*'aanvoer compost'!I16,IF(AND('aanvoer compost'!C17<>\"\",'aanvoer compost'!G17<>\"\"),VLOOKUP('aanvoer compost'!G17,tabellen!Q$3:V$12,5)*'aanvoer compost'!H17*'aanvoer compost'!I17,0))))))))))),IF('aanvoer compost'!C9=\"\",IF('aanvoer compost'!G8=\"\",0,VLOOKUP('aanvoer compost'!G8,tabellen!Q$3:V$12,5)*'aanvoer compost'!H8*'aanvoer compost'!I8),IF('aanvoer compost'!G9=\"\",0,VLOOKUP('aanvoer compost'!G9,tabellen!Q$3:V$12,5)*'aanvoer compost'!H9*'aanvoer compost'!I9)))","v":0},{"$f":"IF(tabellen!AD$1=FALSE,IF(C7=\"\",\"\",IF(C8=\"\",'aanvoer groenbemesters'!D7,IF(C9=\"\",'aanvoer groenbemesters'!D8,IF(C10=\"\",'aanvoer groenbemesters'!D9,IF(C11=\"\",'aanvoer groenbemesters'!D10,IF(C12=\"\",'aanvoer groenbemesters'!D11,IF(C13=\"\",'aanvoer groenbemesters'!D12,IF(C14=\"\",'aanvoer groenbemesters'!D13,IF(C15=\"\",'aanvoer groenbemesters'!D14,IF(C16=\"\",'aanvoer groenbemesters'!D15,IF(C16<>\"\",'aanvoer groenbemesters'!D16,\"\"))))))))))),IF(C8=\"\",IF(C7=\"\",0,'aanvoer groenbemesters'!D7),IF(C8=\"\",0,'aanvoer groenbemesters'!D8)))","v":0},{"$f":"IF('aanvoer gewas'!C10=\"\",\"\",'aanvoer groenbemesters'!F7)","v":""},{"$f":"IF('aanvoer mest'!$D8=\"\",\"\",'aanvoer mest'!D8)","v":""},{"$f":"IF('aanvoer mest'!$D8=\"\",\"\",'aanvoer mest'!E8)","v":""},{"$f":"IF(N7=\"\",\"\",VLOOKUP(N7,tabellen!I$3:N$24,6)*'aanvoer mest'!E8*'aanvoer mest'!F8)","v":""},{"$f":"IF('aanvoer compost'!$D8=\"\",\"\",'aanvoer compost'!D8)","v":""},{"$f":"IF('aanvoer compost'!$D8=\"\",\"\",'aanvoer compost'!E8)","v":""},{"$f":"IF(Q7=\"\",0,VLOOKUP(Q7,tabellen!Q$3:V$12,6)*'aanvoer compost'!E8*'aanvoer compost'!F8)","v":0},{"$f":"IF(C7=\"\",\"\",E7+H7+K7+M7+P7+S7)","v":""},{"$f":"IF(C7=\"\",\"\",((((basis!$C$15/100*10)*0.3*(-0.37*LN(basis!$C$15)+1.8398)*10^6)/20-((basis!$C$15/100*10)*0.3*(-0.37*LN(basis!$C$15)+1.8398)*10^6-(basis!$C$15/100*10)*0.3*(-0.37*LN(basis!$C$15)+1.8398)*10^6*(0.0487*basis!$C$15^-0.453)*EXP((0.0412*LN(basis!$C$15)-0.1726)*0)*0.57)/20)*0.75)+T7)","v":""}]
[null,{"$f":"'aanvoer gewas'!B11","v":2011},{"$f":"IF('aanvoer gewas'!C11=\"\",\"\",'aanvoer gewas'!C11)","v":""},{"$f":"IF(C8=\"\",\"\",IF(tabellen!AD$1=FALSE,IF(C7=\"\",\"\",'aanvoer gewas'!C10),IF(C9=\"\",'aanvoer gewas'!C$10,'aanvoer gewas'!C12)))","v":""},{"$f":"IF(D8=\"\",\"\",'aanvoer gewas'!E11)","v":""},{"$f":"IF(C8=\"\",\"\",IF(tabellen!AD$1=FALSE,IF(C7=\"\",\"\",'aanvoer mest'!G8),IF(C9=\"\",'aanvoer mest'!G$8,'aanvoer mest'!G10)))","v":""},{"$f":"IF(C8=\"\",\"\",IF(tabellen!AD$1=FALSE,IF(C7=\"\",\"\",'aanvoer mest'!H8),IF(C9=\"\",'aanvoer mest'!H$8,'aanvoer mest'!H10)))","v":""},{"$f":"IF('aanvoer mest'!C9=\"\",\"\",IF(tabellen!AD$1=FALSE,IF('aanvoer mest'!C8=\"\",\"\",IF('aanvoer mest'!C8=\"\",IF('aanvoer mest'!G8=\"\",0,VLOOKUP('aanvoer mest'!G8,tabellen!I2:N23,5)*'aanvoer mest'!H8*'aanvoer mest'!I8)+VLOOKUP('aanvoer mest'!C8,tabellen!I2:N23,5)*'aanvoer mest'!E8*'aanvoer mest'!F8,IF('aanvoer mest'!G8=\"\",0,VLOOKUP('aanvoer mest'!G8,tabellen!I$3:N$24,5)*'aanvoer mest'!H8*'aanvoer mest'!I8))),IF('aanvoer mest'!C10=\"\",IF('aanvoer mest'!G$8=\"\",0,VLOOKUP('aanvoer mest'!G$8,tabellen!I$3:N$24,5)*'aanvoer mest'!H$8*'aanvoer mest'!I$8),IF('aanvoer mest'!G10=\"\",0,VLOOKUP('aanvoer mest'!G10,tabellen!I$3:N$24,5)*'aanvoer mest'!H10*'aanvoer mest'!I10))))","v":""},{"$f":"IF(C8=\"\",\"\",IF(tabellen!AD$1=FALSE,IF(C7=\"\",\"\",'aanvoer compost'!G8),IF(C9=\"\",'aanvoer compost'!G$8,'aanvoer compost'!G10)))","v":""},{"$f":"IF(C8=\"\",\"\",IF(tabellen!AD$1=FALSE,IF(C7=\"\",\"\",'aanvoer compost'!H8),IF(C9=\"\",'aanvoer compost'!H$8,'aanvoer compost'!H10)))","v":""},{"$f":"IF('aanvoer compost'!C9=\"\",\"\",IF(tabellen!AD$1=FALSE,IF('aanvoer compost'!C8=\"\",\"\",IF('aanvoer compost'!C8=\"\",IF('aanvoer compost'!G8=\"\",0,VLOOKUP('aanvoer compost'!G8,tabellen!I2:N23,5)*'aanvoer compost'!H8*'aanvoer compost'!I8)+VLOOKUP('aanvoer compost'!C8,tabellen!I2:N23,5)*'aanvoer compost'!E8*'aanvoer compost'!F8,IF('aanvoer compost'!G8=\"\",0,VLOOKUP('aanvoer compost'!G8,tabellen!Q$3:V$12,5)*'aanvoer compost'!H8*'aanvoer compost'!I8))),IF('aanvoer compost'!C10=\"\",IF('aanvoer compost'!G$8=\"\",0,VLOOKUP('aanvoer compost'!G$8,tabellen!Q$3:V$12,5)*'aanvoer compost'!H$8*'aanvoer compost'!I$8),IF('aanvoer compost'!G10=\"\",0,VLOOKUP('aanvoer compost'!G10,tabellen!Q$3:V$12,5)*'aanvoer compost'!H10*'aanvoer compost'!I10))))","v":""},{"$f":"IF(C8=\"\",\"\",IF(tabellen!AD$1=FALSE,IF(C7=\"\",\"\",'aanvoer groenbemesters'!D7),IF(C9=\"\",'aanvoer groenbemesters'!D$7,'aanvoer groenbemesters'!D9)))","v":""},{"$f":"IF('aanvoer gewas'!C11=\"\",\"\",'aanvoer groenbemesters'!F8)","v":""},{"$f":"IF('aanvoer mest'!D9=\"\",\"\",'aanvoer mest'!D9)","v":""},{"$f":"IF('aanvoer mest'!E9=\"\",\"\",'aanvoer mest'!E9)","v":""},{"$f":"IF(N8=\"\",0,VLOOKUP(N8,tabellen!I$3:N$24,6)*'aanvoer mest'!E9*'aanvoer mest'!F9)","v":0},{"$f":"IF('aanvoer compost'!$D9=\"\",\"\",'aanvoer compost'!D9)","v":""},{"$f":"IF('aanvoer compost'!$D9=\"\",\"\",'aanvoer compost'!E9)","v":""},{"$f":"IF(Q8=\"\",0,VLOOKUP(Q8,tabellen!Q$3:V$12,6)*'aanvoer compost'!E9*'aanvoer compost'!F9)","v":0},"",{"$f":"IF(C8=\"\",\"\",((((basis!$C$15/100*10)*0.3*(-0.37*LN(basis!$C$15)+1.8398)*10^6)/20-((basis!$C$15/100*10)*0.3*(-0.37*LN(basis!$C$15)+1.8398)*10^6-(basis!$C$15/100*10)*0.3*(-0.37*LN(basis!$C$15)+1.8398)*10^6*(0.0487*basis!$C$15^-0.453)*EXP((0.0412*LN(basis!$C$15)-0.1726)*0)*0.57)/20)*0.75)+T8)","v":""}]
[null,{"$f":"'aanvoer gewas'!B12","v":2010},{"$f":"IF('aanvoer gewas'!C12=\"\",\"\",'aanvoer gewas'!C12)","v":""},{"$f":"IF(C9=\"\",\"\",IF(tabellen!AD$1=FALSE,IF(C8=\"\",\"\",'aanvoer gewas'!C11),IF(C10=\"\",'aanvoer gewas'!C$10,'aanvoer gewas'!C13)))","v":""},{"$f":"IF(D9=\"\",\"\",'aanvoer gewas'!E12)","v":""},{"$f":"IF(C9=\"\",\"\",IF(tabellen!AD$1=FALSE,IF(C8=\"\",\"\",'aanvoer mest'!G9),IF(C10=\"\",'aanvoer mest'!G$8,'aanvoer mest'!G11)))","v":""},{"$f":"IF(C9=\"\",\"\",IF(tabellen!AD$1=FALSE,IF(C8=\"\",\"\",'aanvoer mest'!H9),IF(C10=\"\",'aanvoer mest'!H$8,'aanvoer mest'!H11)))","v":""},{"$f":"IF('aanvoer mest'!C10=\"\",\"\",IF(tabellen!AD$1=FALSE,IF('aanvoer mest'!C9=\"\",\"\",IF('aanvoer mest'!C9=\"\",IF('aanvoer mest'!G9=\"\",0,VLOOKUP('aanvoer mest'!G9,tabellen!I3:N24,5)*'aanvoer mest'!H9*'aanvoer mest'!I9)+VLOOKUP('aanvoer mest'!C9,tabellen!I3:N24,5)*'aanvoer mest'!E9*'aanvoer mest'!F9,IF('aanvoer mest'!G9=\"\",0,VLOOKUP('aanvoer mest'!G9,tabellen!I$3:N$24,5)*'aanvoer mest'!H9*'aanvoer mest'!I9))),IF('aanvoer mest'!C11=\"\",IF('aanvoer mest'!G$8=\"\",0,VLOOKUP('aanvoer mest'!G$8,tabellen!I$3:N$24,5)*'aanvoer mest'!H$8*'aanvoer mest'!I$8),IF('aanvoer mest'!G11=\"\",0,VLOOKUP('aanvoer mest'!G11,tabellen!I$3:N$24,5)*'aanvoer mest'!H11*'aanvoer mest'!I11))))","v":""},{"$f":"IF(C9=\"\",\"\",IF(tabellen!AD$1=FALSE,IF(C8=\"\",\"\",'aanvoer compost'!G9),IF(C10=\"\",'aanvoer compost'!G$8,'aanvoer compost'!G11)))","v":""},{"$f":"IF(C9=\"\",\"\",IF(tabellen!AD$1=FALSE,IF(C8=\"\",\"\",'aanvoer compost'!H9),IF(C10=\"\",'aanvoer compost'!H$8,'aanvoer compost'!H11)))","v":""},{"$f":"IF('aanvoer compost'!C10=\"\",\"\",IF(tabellen!AD$1=FALSE,IF('aanvoer compost'!C9=\"\",\"\",IF('aanvoer compost'!C9=\"\",IF('aanvoer compost'!G9=\"\",0,VLOOKUP('aanvoer compost'!G9,tabellen!I3:N24,5)*'aanvoer compost'!H9*'aanvoer compost'!I9)+VLOOKUP('aanvoer compost'!C9,tabellen!I3:N24,5)*'aanvoer compost'!E9*'aanvoer compost'!F9,IF('aanvoer compost'!G9=\"\",0,VLOOKUP('aanvoer compost'!G9,tabellen!Q$3:V$12,5)*'aanvoer compost'!H9*'aanvoer compost'!I9))),IF('aanvoer compost'!C11=\"\",IF('aanvoer compost'!G$8=\"\",0,VLOOKUP('aanvoer compost'!G$8,tabellen!Q$3:V$12,5)*'aanvoer compost'!H$8*'aanvoer compost'!I$8),IF('aanvoer compost'!G11=\"\",0,VLOOKUP('aanvoer compost'!G11,tabellen!Q$3:V$12,5)*'aanvoer compost'!H11*'aanvoer compost'!I11))))","v":""},{"$f":"IF(C9=\"\",\"\",IF(tabellen!AD$1=FALSE,IF(C8=\"\",\"\",'aanvoer groenbemesters'!D8),IF(C10=\"\",'aanvoer groenbemesters'!D$7,'aanvoer groenbemesters'!D10)))","v":""},{"$f":"IF('aanvoer gewas'!C12=\"\",\"\",'aanvoer groenbemesters'!F9)","v":""},{"$f":"IF('aanvoer mest'!D10=\"\",\"\",'aanvoer mest'!D10)","v":""},{"$f":"IF('aanvoer mest'!E10=\"\",\"\",'aanvoer mest'!E10)","v":""},{"$f":"IF(N9=\"\",0,VLOOKUP(N9,tabellen!I$3:N$24,6)*'aanvoer mest'!E10*'aanvoer mest'!F10)","v":0},{"$f":"IF('aanvoer compost'!$D10=\"\",\"\",'aanvoer compost'!D10)","v":""},{"$f":"IF('aanvoer compost'!$D10=\"\",\"\",'aanvoer compost'!E10)","v":""},{"$f":"IF(Q9=\"\",0,VLOOKUP(Q9,tabellen!Q$3:V$12,6)*'aanvoer compost'!E10*'aanvoer compost'!F10)","v":0},"",{"$f":"IF(C9=\"\",\"\",((((basis!$C$15/100*10)*0.3*(-0.37*LN(basis!$C$15)+1.8398)*10^6)/20-((basis!$C$15/100*10)*0.3*(-0.37*LN(basis!$C$15)+1.8398)*10^6-(basis!$C$15/100*10)*0.3*(-0.37*LN(basis!$C$15)+1.8398)*10^6*(0.0487*basis!$C$15^-0.453)*EXP((0.0412*LN(basis!$C$15)-0.1726)*0)*0.57)/20)*0.75)+T9)","v":""}]
[null,{"$f":"'aanvoer gewas'!B13","v":2009},{"$f":"IF('aanvoer gewas'!C13=\"\",\"\",'aanvoer gewas'!C13)","v":""},{"$f":"IF(C10=\"\",\"\",IF(tabellen!AD$1=FALSE,IF(C9=\"\",\"\",'aanvoer gewas'!C12),IF(C11=\"\",'aanvoer gewas'!C$10,'aanvoer gewas'!C14)))","v":""},{"$f":"IF(D10=\"\",\"\",'aanvoer gewas'!E13)","v":""},{"$f":"IF(C10=\"\",\"\",IF(tabellen!AD$1=FALSE,IF(C9=\"\",\"\",'aanvoer mest'!G10),IF(C11=\"\",'aanvoer mest'!G$8,'aanvoer mest'!G12)))","v":""},{"$f":"IF(C10=\"\",\"\",IF(tabellen!AD$1=FALSE,IF(C9=\"\",\"\",'aanvoer mest'!H10),IF(C11=\"\",'aanvoer mest'!H$8,'aanvoer mest'!H12)))","v":""},{"$f":"IF('aanvoer mest'!C11=\"\",\"\",IF(tabellen!AD$1=FALSE,IF('aanvoer mest'!C10=\"\",\"\",IF('aanvoer mest'!C10=\"\",IF('aanvoer mest'!G10=\"\",0,VLOOKUP('aanvoer mest'!G10,tabellen!I4:N25,5)*'aanvoer mest'!H10*'aanvoer mest'!I10)+VLOOKUP('aanvoer mest'!C10,tabellen!I4:N25,5)*'aanvoer mest'!E10*'aanvoer mest'!F10,IF('aanvoer mest'!G10=\"\",0,VLOOKUP('aanvoer mest'!G10,tabellen!I$3:N$24,5)*'aanvoer mest'!H10*'aanvoer mest'!I10))),IF('aanvoer mest'!C12=\"\",IF('aanvoer mest'!G$8=\"\",0,VLOOKUP('aanvoer mest'!G$8,tabellen!I$3:N$24,5)*'aanvoer mest'!H$8*'aanvoer mest'!I$8),IF('aanvoer mest'!G12=\"\",0,VLOOKUP('aanvoer mest'!G12,tabellen!I$3:N$24,5)*'aanvoer mest'!H12*'aanvoer mest'!I12))))","v":""},{"$f":"IF(C10=\"\",\"\",IF(tabellen!AD$1=FALSE,IF(C9=\"\",\"\",'aanvoer compost'!G10),IF(C11=\"\",'aanvoer compost'!G$8,'aanvoer compost'!G12)))","v":""},{"$f":"IF(C10=\"\",\"\",IF(tabellen!AD$1=FALSE,IF(C9=\"\",\"\",'aanvoer compost'!H10),IF(C11=\"\",'aanvoer compost'!H$8,'aanvoer compost'!H12)))","v":""},{"$f":"IF('aanvoer compost'!C11=\"\",\"\",IF(tabellen!AD$1=FALSE,IF('aanvoer compost'!C10=\"\",\"\",IF('aanvoer compost'!C10=\"\",IF('aanvoer compost'!G10=\"\",0,VLOOKUP('aanvoer compost'!G10,tabellen!I4:N25,5)*'aanvoer compost'!H10*'aanvoer compost'!I10)+VLOOKUP('aanvoer compost'!C10,tabellen!I4:N25,5)*'aanvoer compost'!E10*'aanvoer compost'!F10,IF('aanvoer compost'!G10=\"\",0,VLOOKUP('aanvoer compost'!G10,tabellen!Q$3:V$12,5)*'aanvoer compost'!H10*'aanvoer compost'!I10))),IF('aanvoer compost'!C12=\"\",IF('aanvoer compost'!G$8=\"\",0,VLOOKUP('aanvoer compost'!G$8,tabellen!Q$3:V$12,5)*'aanvoer compost'!H$8*'aanvoer compost'!I$8),IF('aanvoer compost'!G12=\"\",0,VLOOKUP('aanvoer compost'!G12,tabellen!Q$3:V$12,5)*'aanvoer compost'!H12*'aanvoer compost'!I12))))","v":""},{"$f":"IF(C10=\"\",\"\",IF(tabellen!AD$1=FALSE,IF(C9=\"\",\"\",'aanvoer groenbemesters'!D9),IF(C11=\"\",'aanvoer groenbemesters'!D$7,'aanvoer groenbemesters'!D11)))","v":""},{"$f":"IF('aanvoer gewas'!C13=\"\",\"\",'aanvoer groenbemesters'!F10)","v":""},{"$f":"IF('aanvoer mest'!D11=\"\",\"\",'aanvoer mest'!D11)","v":""},{"$f":"IF('aanvoer mest'!E11=\"\",\"\",'aanvoer mest'!E11)","v":""},{"$f":"IF(N10=\"\",0,VLOOKUP(N10,tabellen!I$3:N$24,6)*'aanvoer mest'!E11*'aanvoer mest'!F11)","v":0},{"$f":"IF('aanvoer compost'!$D11=\"\",\"\",'aanvoer compost'!D11)","v":""},{"$f":"IF('aanvoer compost'!$D11=\"\",\"\",'aanvoer compost'!E11)","v":""},{"$f":"IF(Q10=\"\",0,VLOOKUP(Q10,tabellen!Q$3:V$12,6)*'aanvoer compost'!E11*'aanvoer compost'!F11)","v":0},"",{"$f":"IF(C10=\"\",\"\",((((basis!$C$15/100*10)*0.3*(-0.37*LN(basis!$C$15)+1.8398)*10^6)/20-((basis!$C$15/100*10)*0.3*(-0.37*LN(basis!$C$15)+1.8398)*10^6-(basis!$C$15/100*10)*0.3*(-0.37*LN(basis!$C$15)+1.8398)*10^6*(0.0487*basis!$C$15^-0.453)*EXP((0.0412*LN(basis!$C$15)-0.1726)*0)*0.57)/20)*0.75)+T10)","v":""}]
[null,{"$f":"'aanvoer gewas'!B14","v":2008},{"$f":"IF('aanvoer gewas'!C14=\"\",\"\",'aanvoer gewas'!C14)","v":""},{"$f":"IF(C11=\"\",\"\",IF(tabellen!AD$1=FALSE,IF(C10=\"\",\"\",'aanvoer gewas'!C13),IF(C12=\"\",'aanvoer gewas'!C$10,'aanvoer gewas'!C15)))","v":""},{"$f":"IF(D11=\"\",\"\",'aanvoer gewas'!E14)","v":""},{"$f":"IF(C11=\"\",\"\",IF(tabellen!AD$1=FALSE,IF(C10=\"\",\"\",'aanvoer mest'!G11),IF(C12=\"\",'aanvoer mest'!G$8,'aanvoer mest'!G13)))","v":""},{"$f":"IF(C11=\"\",\"\",IF(tabellen!AD$1=FALSE,IF(C10=\"\",\"\",'aanvoer mest'!H11),IF(C12=\"\",'aanvoer mest'!H$8,'aanvoer mest'!H13)))","v":""},{"$f":"IF('aanvoer mest'!C12=\"\",\"\",IF(tabellen!AD$1=FALSE,IF('aanvoer mest'!C11=\"\",\"\",IF('aanvoer mest'!C11=\"\",IF('aanvoer mest'!G11=\"\",0,VLOOKUP('aanvoer mest'!G11,tabellen!I5:N26,5)*'aanvoer mest'!H11*'aanvoer mest'!I11)+VLOOKUP('aanvoer mest'!C11,tabellen!I5:N26,5)*'aanvoer mest'!E11*'aanvoer mest'!F11,IF('aanvoer mest'!G11=\"\",0,VLOOKUP('aanvoer mest'!G11,tabellen!I$3:N$24,5)*'aanvoer mest'!H11*'aanvoer mest'!I11))),IF('aanvoer mest'!C13=\"\",IF('aanvoer mest'!G$8=\"\",0,VLOOKUP('aanvoer mest'!G$8,tabellen!I$3:N$24,5)*'aanvoer mest'!H$8*'aanvoer mest'!I$8),IF('aanvoer mest'!G13=\"\",0,VLOOKUP('aanvoer mest'!G13,tabellen!I$3:N$24,5)*'aanvoer mest'!H13*'aanvoer mest'!I13))))","v":""},{"$f":"IF(C11=\"\",\"\",IF(tabellen!AD$1=FALSE,IF(C10=\"\",\"\",'aanvoer compost'!G11),IF(C12=\"\",'aanvoer compost'!G$8,'aanvoer compost'!G13)))","v":""},{"$f":"IF(C11=\"\",\"\",IF(tabellen!AD$1=FALSE,IF(C10=\"\",\"\",'aanvoer compost'!H11),IF(C12=\"\",'aanvoer compost'!H$8,'aanvoer compost'!H13)))","v":""},{"$f":"IF('aanvoer compost'!C12=\"\",\"\",IF(tabellen!AD$1=FALSE,IF('aanvoer compost'!C11=\"\",\"\",IF('aanvoer compost'!C11=\"\",IF('aanvoer compost'!G11=\"\",0,VLOOKUP('aanvoer compost'!G11,tabellen!I5:N26,5)*'aanvoer compost'!H11*'aanvoer compost'!I11)+VLOOKUP('aanvoer compost'!C11,tabellen!I5:N26,5)*'aanvoer compost'!E11*'aanvoer compost'!F11,IF('aanvoer compost'!G11=\"\",0,VLOOKUP('aanvoer compost'!G11,tabellen!Q$3:V$12,5)*'aanvoer compost'!H11*'aanvoer compost'!I11))),IF('aanvoer compost'!C13=\"\",IF('aanvoer compost'!G$8=\"\",0,VLOOKUP('aanvoer compost'!G$8,tabellen!Q$3:V$12,5)*'aanvoer compost'!H$8*'aanvoer compost'!I$8),IF('aanvoer compost'!G13=\"\",0,VLOOKUP('aanvoer compost'!G13,tabellen!Q$3:V$12,5)*'aanvoer compost'!H13*'aanvoer compost'!I13))))","v":""},{"$f":"IF(C11=\"\",\"\",IF(tabellen!AD$1=FALSE,IF(C10=\"\",\"\",'aanvoer groenbemesters'!D10),IF(C12=\"\",'aanvoer groenbemesters'!D$7,'aanvoer groenbemesters'!D12)))","v":""},{"$f":"IF('aanvoer gewas'!C14=\"\",\"\",'aanvoer groenbemesters'!F11)","v":""},{"$f":"IF('aanvoer mest'!D12=\"\",\"\",'aanvoer mest'!D12)","v":""},{"$f":"IF('aanvoer mest'!E12=\"\",\"\",'aanvoer mest'!E12)","v":""},{"$f":"IF(N11=\"\",0,VLOOKUP(N11,tabellen!I$3:N$24,6)*'aanvoer mest'!E12*'aanvoer mest'!F12)","v":0},{"$f":"IF('aanvoer compost'!$D12=\"\",\"\",'aanvoer compost'!D12)","v":""},{"$f":"IF('aanvoer compost'!$D12=\"\",\"\",'aanvoer compost'!E12)","v":""},{"$f":"IF(Q11=\"\",0,VLOOKUP(Q11,tabellen!Q$3:V$12,6)*'aanvoer compost'!E12*'aanvoer compost'!F12)","v":0},"",{"$f":"IF(C11=\"\",\"\",((((basis!$C$15/100*10)*0.3*(-0.37*LN(basis!$C$15)+1.8398)*10^6)/20-((basis!$C$15/100*10)*0.3*(-0.37*LN(basis!$C$15)+1.8398)*10^6-(basis!$C$15/100*10)*0.3*(-0.37*LN(basis!$C$15)+1.8398)*10^6*(0.0487*basis!$C$15^-0.453)*EXP((0.0412*LN(basis!$C$15)-0.1726)*0)*0.57)/20)*0.75)+T11)","v":""}]
[null,{"$f":"'aanvoer gewas'!B15","v":2007},{"$f":"IF('aanvoer gewas'!C15=\"\",\"\",'aanvoer gewas'!C15)","v":""},{"$f":"IF(C12=\"\",\"\",IF(tabellen!AD$1=FALSE,IF(C11=\"\",\"\",'aanvoer gewas'!C14),IF(C13=\"\",'aanvoer gewas'!C$10,'aanvoer gewas'!C16)))","v":""},{"$f":"IF(D12=\"\",\"\",'aanvoer gewas'!E15)","v":""},{"$f":"IF(C12=\"\",\"\",IF(tabellen!AD$1=FALSE,IF(C11=\"\",\"\",'aanvoer mest'!G12),IF(C13=\"\",'aanvoer mest'!G$8,'aanvoer mest'!G14)))","v":""},{"$f":"IF(C12=\"\",\"\",IF(tabellen!AD$1=FALSE,IF(C11=\"\",\"\",'aanvoer mest'!H12),IF(C13=\"\",'aanvoer mest'!H$8,'aanvoer mest'!H14)))","v":""},{"$f":"IF('aanvoer mest'!C13=\"\",\"\",IF(tabellen!AD$1=FALSE,IF('aanvoer mest'!C12=\"\",\"\",IF('aanvoer mest'!C12=\"\",IF('aanvoer mest'!G12=\"\",0,VLOOKUP('aanvoer mest'!G12,tabellen!I6:N27,5)*'aanvoer mest'!H12*'aanvoer mest'!I12)+VLOOKUP('aanvoer mest'!C12,tabellen!I6:N27,5)*'aanvoer mest'!E12*'aanvoer mest'!F12,IF('aanvoer mest'!G12=\"\",0,VLOOKUP('aanvoer mest'!G12,tabellen!I$3:N$24,5)*'aanvoer mest'!H12*'aanvoer mest'!I12))),IF('aanvoer mest'!C14=\"\",IF('aanvoer mest'!G$8=\"\",0,VLOOKUP('aanvoer mest'!G$8,tabellen!I$3:N$24,5)*'aanvoer mest'!H$8*'aanvoer mest'!I$8),IF('aanvoer mest'!G14=\"\",0,VLOOKUP('aanvoer mest'!G14,tabellen!I$3:N$24,5)*'aanvoer mest'!H14*'aanvoer mest'!I14))))","v":""},{"$f":"IF(C12=\"\",\"\",IF(tabellen!AD$1=FALSE,IF(C11=\"\",\"\",'aanvoer compost'!G12),IF(C13=\"\",'aanvoer compost'!G$8,'aanvoer compost'!G14)))","v":""},{"$f":"IF(C12=\"\",\"\",IF(tabellen!AD$1=FALSE,IF(C11=\"\",\"\",'aanvoer compost'!H12),IF(C13=\"\",'aanvoer compost'!H$8,'aanvoer compost'!H14)))","v":""},{"$f":"IF('aanvoer compost'!C13=\"\",\"\",IF(tabellen!AD$1=FALSE,IF('aanvoer compost'!C12=\"\",\"\",IF('aanvoer compost'!C12=\"\",IF('aanvoer compost'!G12=\"\",0,VLOOKUP('aanvoer compost'!G12,tabellen!I6:N27,5)*'aanvoer compost'!H12*'aanvoer compost'!I12)+VLOOKUP('aanvoer compost'!C12,tabellen!I6:N27,5)*'aanvoer compost'!E12*'aanvoer compost'!F12,IF('aanvoer compost'!G12=\"\",0,VLOOKUP('aanvoer compost'!G12,tabellen!Q$3:V$12,5)*'aanvoer compost'!H12*'aanvoer compost'!I12))),IF('aanvoer compost'!C14=\"\",IF('aanvoer compost'!G$8=\"\",0,VLOOKUP('aanvoer compost'!G$8,tabellen!Q$3:V$12,5)*'aanvoer compost'!H$8*'aanvoer compost'!I$8),IF('aanvoer compost'!G14=\"\",0,VLOOKUP('aanvoer compost'!G14,tabellen!Q$3:V$12,5)*'aanvoer compost'!H14*'aanvoer compost'!I14))))","v":""},{"$f":"IF(C12=\"\",\"\",IF(tabellen!AD$1=FALSE,IF(C11=\"\",\"\",'aanvoer groenbemesters'!D11),IF(C13=\"\",'aanvoer groenbemesters'!D$7,'aanvoer groenbemesters'!D13)))","v":""},{"$f":"IF('aanvoer gewas'!C15=\"\",\"\",'aanvoer groenbemesters'!F12)","v":""},{"$f":"IF('aanvoer mest'!D13=\"\",\"\",'aanvoer mest'!D13)","v":""},{"$f":"IF('aanvoer mest'!E13=\"\",\"\",'aanvoer mest'!E13)","v":""},{"$f":"IF(N12=\"\",0,VLOOKUP(N12,tabellen!I$3:N$24,6)*'aanvoer mest'!E13*'aanvoer mest'!F13)","v":0},{"$f":"IF('aanvoer compost'!$D13=\"\",\"\",'aanvoer compost'!D13)","v":""},{"$f":"IF('aanvoer compost'!$D13=\"\",\"\",'aanvoer compost'!E13)","v":""},{"$f":"IF(Q12=\"\",0,VLOOKUP(Q12,tabellen!Q$3:V$12,6)*'aanvoer compost'!E13*'aanvoer compost'!F13)","v":0},"",{"$f":"IF(C12=\"\",\"\",((((basis!$C$15/100*10)*0.3*(-0.37*LN(basis!$C$15)+1.8398)*10^6)/20-((basis!$C$15/100*10)*0.3*(-0.37*LN(basis!$C$15)+1.8398)*10^6-(basis!$C$15/100*10)*0.3*(-0.37*LN(basis!$C$15)+1.8398)*10^6*(0.0487*basis!$C$15^-0.453)*EXP((0.0412*LN(basis!$C$15)-0.1726)*0)*0.57)/20)*0.75)+T12)","v":""}]
[null,{"$f":"'aanvoer gewas'!B16","v":2006},{"$f":"IF('aanvoer gewas'!C16=\"\",\"\",'aanvoer gewas'!C16)","v":""},{"$f":"IF(C13=\"\",\"\",IF(tabellen!AD$1=FALSE,IF(C12=\"\",\"\",'aanvoer gewas'!C15),IF(C14=\"\",'aanvoer gewas'!C$10,'aanvoer gewas'!C17)))","v":""},{"$f":"IF(D13=\"\",\"\",'aanvoer gewas'!E16)","v":""},{"$f":"IF(C13=\"\",\"\",IF(tabellen!AD$1=FALSE,IF(C12=\"\",\"\",'aanvoer mest'!G13),IF(C14=\"\",'aanvoer mest'!G$8,'aanvoer mest'!G15)))","v":""},{"$f":"IF(C13=\"\",\"\",IF(tabellen!AD$1=FALSE,IF(C12=\"\",\"\",'aanvoer mest'!H13),IF(C14=\"\",'aanvoer mest'!H$8,'aanvoer mest'!H15)))","v":""},{"$f":"IF('aanvoer mest'!C14=\"\",\"\",IF(tabellen!AD$1=FALSE,IF('aanvoer mest'!C13=\"\",\"\",IF('aanvoer mest'!C13=\"\",IF('aanvoer mest'!G13=\"\",0,VLOOKUP('aanvoer mest'!G13,tabellen!I7:N28,5)*'aanvoer mest'!H13*'aanvoer mest'!I13)+VLOOKUP('aanvoer mest'!C13,tabellen!I7:N28,5)*'aanvoer mest'!E13*'aanvoer mest'!F13,IF('aanvoer mest'!G13=\"\",0,VLOOKUP('aanvoer mest'!G13,tabellen!I$3:N$24,5)*'aanvoer mest'!H13*'aanvoer mest'!I13))),IF('aanvoer mest'!C15=\"\",IF('aanvoer mest'!G$8=\"\",0,VLOOKUP('aanvoer mest'!G$8,tabellen!I$3:N$24,5)*'aanvoer mest'!H$8*'aanvoer mest'!I$8),IF('aanvoer mest'!G15=\"\",0,VLOOKUP('aanvoer mest'!G15,tabellen!I$3:N$24,5)*'aanvoer mest'!H15*'aanvoer mest'!I15))))","v":""},{"$f":"IF(C13=\"\",\"\",IF(tabellen!AD$1=FALSE,IF(C12=\"\",\"\",'aanvoer compost'!G13),IF(C14=\"\",'aanvoer compost'!G$8,'aanvoer compost'!G15)))","v":""},{"$f":"IF(C13=\"\",\"\",IF(tabellen!AD$1=FALSE,IF(C12=\"\",\"\",'aanvoer compost'!H13),IF(C14=\"\",'aanvoer compost'!H$8,'aanvoer compost'!H15)))","v":""},{"$f":"IF('aanvoer compost'!C14=\"\",\"\",IF(tabellen!AD$1=FALSE,IF('aanvoer compost'!C13=\"\",\"\",IF('aanvoer compost'!C13=\"\",IF('aanvoer compost'!G13=\"\",0,VLOOKUP('aanvoer compost'!G13,tabellen!I7:N28,5)*'aanvoer compost'!H13*'aanvoer compost'!I13)+VLOOKUP('aanvoer compost'!C13,tabellen!I7:N28,5)*'aanvoer compost'!E13*'aanvoer compost'!F13,IF('aanvoer compost'!G13=\"\",0,VLOOKUP('aanvoer compost'!G13,tabellen!Q$3:V$12,5)*'aanvoer compost'!H13*'aanvoer compost'!I13))),IF('aanvoer compost'!C15=\"\",IF('aanvoer compost'!G$8=\"\",0,VLOOKUP('aanvoer compost'!G$8,tabellen!Q$3:V$12,5)*'aanvoer compost'!H$8*'aanvoer compost'!I$8),IF('aanvoer compost'!G15=\"\",0,VLOOKUP('aanvoer compost'!G15,tabellen!Q$3:V$12,5)*'aanvoer compost'!H15*'aanvoer compost'!I15))))","v":""},{"$f":"IF(C13=\"\",\"\",IF(tabellen!AD$1=FALSE,IF(C12=\"\",\"\",'aanvoer groenbemesters'!D12),IF(C14=\"\",'aanvoer groenbemesters'!D$7,'aanvoer groenbemesters'!D14)))","v":""},{"$f":"IF('aanvoer gewas'!C16=\"\",\"\",'aanvoer groenbemesters'!F13)","v":""},{"$f":"IF('aanvoer mest'!D14=\"\",\"\",'aanvoer mest'!D14)","v":""},{"$f":"IF('aanvoer mest'!E14=\"\",\"\",'aanvoer mest'!E14)","v":""},{"$f":"IF(N13=\"\",0,VLOOKUP(N13,tabellen!I$3:N$24,6)*'aanvoer mest'!E14*'aanvoer mest'!F14)","v":0},{"$f":"IF('aanvoer compost'!$D14=\"\",\"\",'aanvoer compost'!D14)","v":""},{"$f":"IF('aanvoer compost'!$D14=\"\",\"\",'aanvoer compost'!E14)","v":""},{"$f":"IF(Q13=\"\",0,VLOOKUP(Q13,tabellen!Q$3:V$12,6)*'aanvoer compost'!E14*'aanvoer compost'!F14)","v":0},"",{"$f":"IF(C13=\"\",\"\",((((basis!$C$15/100*10)*0.3*(-0.37*LN(basis!$C$15)+1.8398)*10^6)/20-((basis!$C$15/100*10)*0.3*(-0.37*LN(basis!$C$15)+1.8398)*10^6-(basis!$C$15/100*10)*0.3*(-0.37*LN(basis!$C$15)+1.8398)*10^6*(0.0487*basis!$C$15^-0.453)*EXP((0.0412*LN(basis!$C$15)-0.1726)*0)*0.57)/20)*0.75)+T13)","v":""}]
[null,{"$f":"'aanvoer gewas'!B17","v":2005},{"$f":"IF('aanvoer gewas'!C17=\"\",\"\",'aanvoer gewas'!C17)","v":""},{"$f":"IF(C14=\"\",\"\",IF(tabellen!AD$1=FALSE,IF(C13=\"\",\"\",'aanvoer gewas'!C16),IF(C15=\"\",'aanvoer gewas'!C$10,'aanvoer gewas'!C18)))","v":""},{"$f":"IF(D14=\"\",\"\",'aanvoer gewas'!E17)","v":""},{"$f":"IF(C14=\"\",\"\",IF(tabellen!AD$1=FALSE,IF(C13=\"\",\"\",'aanvoer mest'!G14),IF(C15=\"\",'aanvoer mest'!G$8,'aanvoer mest'!G16)))","v":""},{"$f":"IF(C14=\"\",\"\",IF(tabellen!AD$1=FALSE,IF(C13=\"\",\"\",'aanvoer mest'!H14),IF(C15=\"\",'aanvoer mest'!H$8,'aanvoer mest'!H16)))","v":""},{"$f":"IF('aanvoer mest'!C15=\"\",\"\",IF(tabellen!AD$1=FALSE,IF('aanvoer mest'!C14=\"\",\"\",IF('aanvoer mest'!C14=\"\",IF('aanvoer mest'!G14=\"\",0,VLOOKUP('aanvoer mest'!G14,tabellen!I8:N29,5)*'aanvoer mest'!H14*'aanvoer mest'!I14)+VLOOKUP('aanvoer mest'!C14,tabellen!I8:N29,5)*'aanvoer mest'!E14*'aanvoer mest'!F14,IF('aanvoer mest'!G14=\"\",0,VLOOKUP('aanvoer mest'!G14,tabellen!I$3:N$24,5)*'aanvoer mest'!H14*'aanvoer mest'!I14))),IF('aanvoer mest'!C16=\"\",IF('aanvoer mest'!G$8=\"\",0,VLOOKUP('aanvoer mest'!G$8,tabellen!I$3:N$24,5)*'aanvoer mest'!H$8*'aanvoer mest'!I$8),IF('aanvoer mest'!G16=\"\",0,VLOOKUP('aanvoer mest'!G16,tabellen!I$3:N$24,5)*'aanvoer mest'!H16*'aanvoer mest'!I16))))","v":""},{"$f":"IF(C14=\"\",\"\",IF(tabellen!AD$1=FALSE,IF(C13=\"\",\"\",'aanvoer compost'!G14),IF(C15=\"\",'aanvoer compost'!G$8,'aanvoer compost'!G16)))","v":""},{"$f":"IF(C14=\"\",\"\",IF(tabellen!AD$1=FALSE,IF(C13=\"\",\"\",'aanvoer compost'!H14),IF(C15=\"\",'aanvoer compost'!H$8,'aanvoer compost'!H16)))","v":""},{"$f":"IF('aanvoer compost'!C15=\"\",\"\",IF(tabellen!AD$1=FALSE,IF('aanvoer compost'!C14=\"\",\"\",IF('aanvoer compost'!C14=\"\",IF('aanvoer compost'!G14=\"\",0,VLOOKUP('aanvoer compost'!G14,tabellen!I8:N29,5)*'aanvoer compost'!H14*'aanvoer compost'!I14)+VLOOKUP('aanvoer compost'!C14,tabellen!I8:N29,5)*'aanvoer compost'!E14*'aanvoer compost'!F14,IF('aanvoer compost'!G14=\"\",0,VLOOKUP('aanvoer compost'!G14,tabellen!Q$3:V$12,5)*'aanvoer compost'!H14*'aanvoer compost'!I14))),IF('aanvoer compost'!C16=\"\",IF('aanvoer compost'!G$8=\"\",0,VLOOKUP('aanvoer compost'!G$8,tabellen!Q$3:V$12,5)*'aanvoer compost'!H$8*'aanvoer compost'!I$8),IF('aanvoer compost'!G16=\"\",0,VLOOKUP('aanvoer compost'!G16,tabellen!Q$3:V$12,5)*'aanvoer compost'!H16*'aanvoer compost'!I16))))","v":""},{"$f":"IF(C14=\"\",\"\",IF(tabellen!AD$1=FALSE,IF(C13=\"\",\"\",'aanvoer groenbemesters'!D13),IF(C15=\"\",'aanvoer groenbemesters'!D$7,'aanvoer groenbemesters'!D15)))","v":""},{"$f":"IF('aanvoer gewas'!C17=\"\",\"\",'aanvoer groenbemesters'!F14)","v":""},{"$f":"IF('aanvoer mest'!D15=\"\",\"\",'aanvoer mest'!D15)","v":""},{"$f":"IF('aanvoer mest'!E15=\"\",\"\",'aanvoer mest'!E15)","v":""},{"$f":"IF(N14=\"\",0,VLOOKUP(N14,tabellen!I$3:N$24,6)*'aanvoer mest'!E15*'aanvoer mest'!F15)","v":0},{"$f":"IF('aanvoer compost'!$D15=\"\",\"\",'aanvoer compost'!D15)","v":""},{"$f":"IF('aanvoer compost'!$D15=\"\",\"\",'aanvoer compost'!E15)","v":""},{"$f":"IF(Q14=\"\",0,VLOOKUP(Q14,tabellen!Q$3:V$12,6)*'aanvoer compost'!E15*'aanvoer compost'!F15)","v":0},"",{"$f":"IF(C14=\"\",\"\",((((basis!$C$15/100*10)*0.3*(-0.37*LN(basis!$C$15)+1.8398)*10^6)/20-((basis!$C$15/100*10)*0.3*(-0.37*LN(basis!$C$15)+1.8398)*10^6-(basis!$C$15/100*10)*0.3*(-0.37*LN(basis!$C$15)+1.8398)*10^6*(0.0487*basis!$C$15^-0.453)*EXP((0.0412*LN(basis!$C$15)-0.1726)*0)*0.57)/20)*0.75)+T14)","v":""}]
[null,{"$f":"'aanvoer gewas'!B18","v":2004},{"$f":"IF('aanvoer gewas'!C18=\"\",\"\",'aanvoer gewas'!C18)","v":""},{"$f":"IF(C15=\"\",\"\",IF(tabellen!AD$1=FALSE,IF(C14=\"\",\"\",'aanvoer gewas'!C17),IF(C16=\"\",'aanvoer gewas'!C$10,'aanvoer gewas'!C19)))","v":""},{"$f":"IF(D15=\"\",\"\",'aanvoer gewas'!E18)","v":""},{"$f":"IF(C15=\"\",\"\",IF(tabellen!AD$1=FALSE,IF(C14=\"\",\"\",'aanvoer mest'!G15),IF(C16=\"\",'aanvoer mest'!G$8,'aanvoer mest'!G17)))","v":""},{"$f":"IF(C15=\"\",\"\",IF(tabellen!AD$1=FALSE,IF(C14=\"\",\"\",'aanvoer mest'!H15),IF(C16=\"\",'aanvoer mest'!H$8,'aanvoer mest'!H17)))","v":""},{"$f":"IF('aanvoer mest'!C16=\"\",\"\",IF(tabellen!AD$1=FALSE,IF('aanvoer mest'!C15=\"\",\"\",IF('aanvoer mest'!C15=\"\",IF('aanvoer mest'!G15=\"\",0,VLOOKUP('aanvoer mest'!G15,tabellen!I9:N30,5)*'aanvoer mest'!H15*'aanvoer mest'!I15)+VLOOKUP('aanvoer mest'!C15,tabellen!I9:N30,5)*'aanvoer mest'!E15*'aanvoer mest'!F15,IF('aanvoer mest'!G15=\"\",0,VLOOKUP('aanvoer mest'!G15,tabellen!I$3:N$24,5)*'aanvoer mest'!H15*'aanvoer mest'!I15))),IF('aanvoer mest'!C17=\"\",IF('aanvoer mest'!G$8=\"\",0,VLOOKUP('aanvoer mest'!G$8,tabellen!I$3:N$24,5)*'aanvoer mest'!H$8*'aanvoer mest'!I$8),IF('aanvoer mest'!G17=\"\",0,VLOOKUP('aanvoer mest'!G17,tabellen!I$3:N$24,5)*'aanvoer mest'!H17*'aanvoer mest'!I17))))","v":""},{"$f":"IF(C15=\"\",\"\",IF(tabellen!AD$1=FALSE,IF(C14=\"\",\"\",'aanvoer compost'!G15),IF(C16=\"\",'aanvoer compost'!G$8,'aanvoer compost'!G17)))","v":""},{"$f":"IF(C15=\"\",\"\",IF(tabellen!AD$1=FALSE,IF(C14=\"\",\"\",'aanvoer compost'!H15),IF(C16=\"\",'aanvoer compost'!H$8,'aanvoer compost'!H17)))","v":""},{"$f":"IF('aanvoer compost'!C16=\"\",\"\",IF(tabellen!AD$1=FALSE,IF('aanvoer compost'!C15=\"\",\"\",IF('aanvoer compost'!C15=\"\",IF('aanvoer compost'!G15=\"\",0,VLOOKUP('aanvoer compost'!G15,tabellen!I9:N30,5)*'aanvoer compost'!H15*'aanvoer compost'!I15)+VLOOKUP('aanvoer compost'!C15,tabellen!I9:N30,5)*'aanvoer compost'!E15*'aanvoer compost'!F15,IF('aanvoer compost'!G15=\"\",0,VLOOKUP('aanvoer compost'!G15,tabellen!Q$3:V$12,5)*'aanvoer compost'!H15*'aanvoer compost'!I15))),IF('aanvoer compost'!C17=\"\",IF('aanvoer compost'!G$8=\"\",0,VLOOKUP('aanvoer compost'!G$8,tabellen!Q$3:V$12,5)*'aanvoer compost'!H$8*'aanvoer compost'!I$8),IF('aanvoer compost'!G17=\"\",0,VLOOKUP('aanvoer compost'!G17,tabellen!Q$3:V$12,5)*'aanvoer compost'!H17*'aanvoer compost'!I17))))","v":""},{"$f":"IF(C15=\"\",\"\",IF(tabellen!AD$1=FALSE,IF(C14=\"\",\"\",'aanvoer groenbemesters'!D14),IF(C16=\"\",'aanvoer groenbemesters'!D$7,'aanvoer groenbemesters'!D16)))","v":""},{"$f":"IF('aanvoer gewas'!C18=\"\",\"\",'aanvoer groenbemesters'!F15)","v":""},{"$f":"IF('aanvoer mest'!D16=\"\",\"\",'aanvoer mest'!D16)","v":""},{"$f":"IF('aanvoer mest'!E16=\"\",\"\",'aanvoer mest'!E16)","v":""},{"$f":"IF(N15=\"\",0,VLOOKUP(N15,tabellen!I$3:N$24,6)*'aanvoer mest'!E16*'aanvoer mest'!F16)","v":0},{"$f":"IF('aanvoer compost'!$D16=\"\",\"\",'aanvoer compost'!D16)","v":""},{"$f":"IF('aanvoer compost'!$D16=\"\",\"\",'aanvoer compost'!E16)","v":""},{"$f":"IF(Q15=\"\",0,VLOOKUP(Q15,tabellen!Q$3:V$12,6)*'aanvoer compost'!E16*'aanvoer compost'!F16)","v":0},{"$f":"IF(C15=\"\",\"\",E15+H15+K15+M15+P15+S15)","v":""},{"$f":"IF(C15=\"\",\"\",((((basis!$C$15/100*10)*0.3*(-0.37*LN(basis!$C$15)+1.8398)*10^6)/20-((basis!$C$15/100*10)*0.3*(-0.37*LN(basis!$C$15)+1.8398)*10^6-(basis!$C$15/100*10)*0.3*(-0.37*LN(basis!$C$15)+1.8398)*10^6*(0.0487*basis!$C$15^-0.453)*EXP((0.0412*LN(basis!$C$15)-0.1726)*0)*0.57)/20)*0.75)+T15)","v":""}]
[null,{"$f":"'aanvoer gewas'!B19","v":2003},{"$f":"IF('aanvoer gewas'!C19=\"\",\"\",'aanvoer gewas'!C19)","v":""},{"$f":"IF(C16=\"\",\"\",IF(tabellen!AD$1=FALSE,IF(C15=\"\",\"\",'aanvoer gewas'!C18),IF(C17=\"\",'aanvoer gewas'!C$10,'aanvoer gewas'!C20)))","v":""},{"$f":"IF(D16=\"\",\"\",'aanvoer gewas'!E19)","v":""},{"$f":"IF(C16=\"\",\"\",IF(tabellen!AD$1=FALSE,IF(C15=\"\",\"\",'aanvoer mest'!G16),IF(C17=\"\",'aanvoer mest'!G$8,'aanvoer mest'!G18)))","v":""},{"$f":"IF(C16=\"\",\"\",IF(tabellen!AD$1=FALSE,IF(C15=\"\",\"\",'aanvoer mest'!H16),IF(C17=\"\",'aanvoer mest'!H$8,'aanvoer mest'!H18)))","v":""},{"$f":"IF('aanvoer mest'!C17=\"\",\"\",IF(tabellen!AD$1=FALSE,IF('aanvoer mest'!C16=\"\",\"\",IF('aanvoer mest'!C16=\"\",IF('aanvoer mest'!G16=\"\",0,VLOOKUP('aanvoer mest'!G16,tabellen!I10:N31,5)*'aanvoer mest'!H16*'aanvoer mest'!I16)+VLOOKUP('aanvoer mest'!C16,tabellen!I10:N31,5)*'aanvoer mest'!E16*'aanvoer mest'!F16,IF('aanvoer mest'!G16=\"\",0,VLOOKUP('aanvoer mest'!G16,tabellen!I$3:N$24,5)*'aanvoer mest'!H16*'aanvoer mest'!I16))),IF('aanvoer mest'!C18=\"\",IF('aanvoer mest'!G$8=\"\",0,VLOOKUP('aanvoer mest'!G$8,tabellen!I$3:N$24,5)*'aanvoer mest'!H$8*'aanvoer mest'!I$8),IF('aanvoer mest'!G18=\"\",0,VLOOKUP('aanvoer mest'!G18,tabellen!I$3:N$24,5)*'aanvoer mest'!H18*'aanvoer mest'!I18))))","v":""},{"$f":"IF(C16=\"\",\"\",IF(tabellen!AD$1=FALSE,IF(C15=\"\",\"\",'aanvoer compost'!G16),IF(C17=\"\",'aanvoer compost'!G$8,'aanvoer compost'!G18)))","v":""},{"$f":"IF(C16=\"\",\"\",IF(tabellen!AD$1=FALSE,IF(C15=\"\",\"\",'aanvoer compost'!H16),IF(C17=\"\",'aanvoer compost'!H$8,'aanvoer compost'!H18)))","v":""},{"$f":"IF('aanvoer compost'!C17=\"\",\"\",IF(tabellen!AD$1=FALSE,IF('aanvoer compost'!C16=\"\",\"\",IF('aanvoer compost'!C16=\"\",IF('aanvoer compost'!G16=\"\",0,VLOOKUP('aanvoer compost'!G16,tabellen!I10:N31,5)*'aanvoer compost'!H16*'aanvoer compost'!I16)+VLOOKUP('aanvoer compost'!C16,tabellen!I10:N31,5)*'aanvoer compost'!E16*'aanvoer compost'!F16,IF('aanvoer compost'!G16=\"\",0,VLOOKUP('aanvoer compost'!G16,tabellen!Q$3:V$12,5)*'aanvoer compost'!H16*'aanvoer compost'!I16))),IF('aanvoer compost'!C18=\"\",IF('aanvoer compost'!G$8=\"\",0,VLOOKUP('aanvoer compost'!G$8,tabellen!Q$3:V$12,5)*'aanvoer compost'!H$8*'aanvoer compost'!I$8),IF('aanvoer compost'!G18=\"\",0,VLOOKUP('aanvoer compost'!G18,tabellen!Q$3:V$12,5)*'aanvoer compost'!H18*'aanvoer compost'!I18))))","v":""},{"$f":"IF(C16=\"\",\"\",IF(tabellen!AD$1=FALSE,IF(C15=\"\",\"\",'aanvoer groenbemesters'!D15),IF(C17=\"\",'aanvoer groenbemesters'!D$7,'aanvoer groenbemesters'!D17)))","v":""},{"$f":"IF('aanvoer gewas'!C19=\"\",\"\",'aanvoer groenbemesters'!F16)","v":""},{"$f":"IF('aanvoer mest'!D17=\"\",\"\",'aanvoer mest'!D17)","v":""},{"$f":"IF('aanvoer mest'!E17=\"\",\"\",'aanvoer mest'!E17)","v":""},{"$f":"IF(N16=\"\",0,VLOOKUP(N16,tabellen!I$3:N$24,6)*'aanvoer mest'!E17*'aanvoer mest'!F17)","v":0},{"$f":"IF('aanvoer compost'!$D17=\"\",\"\",'aanvoer compost'!D17)","v":""},{"$f":"IF('aanvoer compost'!$D17=\"\",\"\",'aanvoer compost'!E17)","v":""},{"$f":"IF(Q16=\"\",0,VLOOKUP(Q16,tabellen!Q$3:V$12,6)*'aanvoer compost'!E17*'aanvoer compost'!F17)","v":0},{"$f":"IF(C16=\"\",\"\",E16+H16+K16+M16+P16+S16)","v":""},{"$f":"IF(C16=\"\",\"\",((((basis!$C$15/100*10)*0.3*(-0.37*LN(basis!$C$15)+1.8398)*10^6)/20-((basis!$C$15/100*10)*0.3*(-0.37*LN(basis!$C$15)+1.8398)*10^6-(basis!$C$15/100*10)*0.3*(-0.37*LN(basis!$C$15)+1.8398)*10^6*(0.0487*basis!$C$15^-0.453)*EXP((0.0412*LN(basis!$C$15)-0.1726)*0)*0.57)/20)*0.75)+T16)","v":""}]
[]
[]
[]
[{"$nulls":3},"<<<< terug naar begin",null,null,"<<terug"]
[null,"Disclaimer: Dit advies is met de grootst mogelijke zorgvuldigheid samengesteld. Desondanks kan dit advies informatie bevatten die incorrect en/of incompleet is. Aan de inhoud ervan kunnen geen rechten worden ontleend. HLB aanvaardt geen aansprakelijkheid voor directe of indirecte schade die het gevolg is van het gebruik van informatie van dit advies. De inhoud van dit advies mag niet worden gebruikt voor publicatie zonder toestemming van HLB."]

{"sheet":"tabellen","index":8,"n_rows":200,"n_cols":30,"rows_kept":200,"hidden":true,"merged":[[0,11,0,13],[0,19,0,21],[198,4,198,5]]}
[null,"afbraak organische stof",null,null,"levering effectieve organische stof door gewasresten",{"$nulls":3},"levering effectieve organische stof door organische mest",null,null,"Stikstof",{"$nulls":4},"levering effectieve organische stof door compost",null,null,"Stikstof",{"$nulls":3},"levering effectieve organische stof door groenbemesters",null,"Stikstof",null,"jaar aflopend sorteren",null,true]
[null,"os%","jaarlijkse afbraak",null,"gewas","levering effectieve organische stof door gewasresten (kg per hectare)","N-Levering",null,"mestsoort","afk","effectieve org. stof per ton produkt","Kg N per ton/m³","w.c. N nj","w.c. N vj",null,null,"compostsoort","afk","effectieve org. stof per ton produkt","Kg N per ton/m³","w.c. N nj","w.c. N vj",null,"groenbemesters (in de stoppel gezaaid)","levering effectieve organische stof door gewasresten (kg per hectare)","mineralisatie"]
[null,2,{"$f":"1479*LN(B3) - 329.93","v":{"v":695.2346800481589,"d":"695"}},{"$nulls":5},"(geen mest)",null,0,{"$nulls":5},"(geen compost)",null,0,{"$nulls":4},"(geen groenbemester)",0]
[null,3,{"v":1294.9175749401343,"d":"1295"},null,"Aardbeien",300,0,null,"Droge hennenmest (vast)","V-HEN",190,{"v":24.099999999999998,"d":"24.1"},0.25,0.58,null,null,"AVEBE-compost","AVEBE",110,3.3,0.1,0.1,null,"Bladkool",840,30]
[null,4,{"v":1720.3993600963179,"d":"1720"},null,"Achillea",0,0,null,"Eendenmest (vast)","V-EEN",105,{"v":8.299999999999999,"d":"8.3"},0.25,0.55,null,null,"Champost","CHAM",126,5.2,0.1,0.25,null,"Bladrammenas",850,30]
[null,5,{"v":2050.4286724900344,"d":"2050"},null,"Aconitum (monnikskap)",0,0,null,"Geitenmest (vast)","V-GEIT",90,8.5,0.25,0.65,null,null,"GFT-compost","GFT",183,6.9,0.1,0.1,null,"Gele mosterd",850,30]
[null,6,{"v":2320.0822549882932,"d":"2320"},null,"Agapanthus (Afrikaanse lelie)",0,0,null,"Kalkoenen (vast)","V-KAL",230,{"v":24.700000000000003,"d":"24.7"},0.25,0.62,null,null,"Groencompost","GROEN",190,8.5,0.1,0.1,null,"Hopperupsklaver",790,60]
[null,7,{"v":2548.0711104528086,"d":"2548"},null,"Alchemilla mollis",0,0,null,"Kippendrijfmest","D-KIP",35,10.2,0.25,0.84,null,null,"Humusaarde","HUMAA",88,{"v":4,"d":"4.0"},0.1,0.1,null,"Japanse haver (Avena Strigosa)",850,30]
[null,8,{"v":2745.564040144477,"d":"2746"},null,"Allium (sierui)",300,0,null,"Kippenstrooisel (vast)","V-KIP",230,19.1,0.25,0.73,null,null,"Humuskal","HUMKA",150,7.3,0.1,0.1,null,"Klaver, rode (onder dekvrucht)",1165,60]
[null,9,{"v":2919.765149880269,"d":"2920"},null,"Amaranthus",0,0,null,"Konijnenmest (vast)","V-KON",185,{"v":13.600000000000001,"d":"13.6"},0.25,0.65,null,null,"Laco-keurcompost","LACO",193,8.6,0.1,0.1,null,"Klaver, witte (onder dekvrucht)",850,60]
[null,10,{"v":3075.5933525381943,"d":"3076"},null,"Andijvie",450,0,null,"Nertsenmest (vast)","V-NER",95,17.7,0.25,0.8,null,null,"Natuurcompost","NATUU",185,6.8,0.1,0.1,null,"Kunstweide (najaarszaai)",450,30]
[null,12,{"v":3345.2469350364527,"d":"3345"},null,"Anjer (tros-)",250,0,null,"Paardenmest (vast)","V-PAA",125,{"v":5,"d":"5.0"},0.25,0.6,null,null,"Recro-keurcompost","RECRO",132,8.9,0.1,0.1,null,"Phacelia",850,30]
[null,15,{"v":3675.276247430169,"d":"3675"},null,"Anthirrhinum (leeuwebek)",0,0,null,"Rundveedrijfmest","V-RUND",30,4.2,0.25,0.66,{"$nulls":9},"Raaigras, engels (in stoppel)",980,30]
[null,20,{"v":4100.758032586352,"d":"4101"},null,"Asclepias",0,0,null,"Rundveegier","G-RUND",5,{"v":4,"d":"4.0"},0.25,0.93,null,null,"bron: praktijkgids bemesting NMI, Conviro",{"$nulls":6},"Raaigras, engels (onder dekvrucht)",1155,30]
[null,30,{"v":4700.4409274783275,"d":"4700"},null,"Asperges (aanleg)",0,0,null,"Rundveemest (vast)","V-RUND",85,6.4,0.25,0.48,{"$nulls":9},"Raaigras, italiaans (in stoppel)",1080,30]
[{"$nulls":4},"Asperges (bestaand)",1000,0,null,"Schapenmest (vast)","V-SCH",105,8.6,0.25,0.65,{"$nulls":9},"Raaigras, italiaans (onder dekvrucht)",1255,30]
[null,"bron: Kor Zwart, Alterra",null,null,"Aster",250,0,null,"Varkensmest (vast)","V-VAR",65,7.5,0.25,0.65,{"$nulls":9},"Stoppelknollen",830,30]
[{"$nulls":4},"Astilbe spirea",0,0,null,"Vleeskalverendrijfmest","D-KAL",5,{"v":3,"d":"3.0"},0.25,0.82,{"$nulls":9},"Tagetes",865,30]
[{"$nulls":4},"Astrantia",0,0,null,"Vleeskuikenmest (vast)","V-KUI",280,30.5,0.25,0.62,{"$nulls":9},"Teunisbloem",700,60]
[{"$nulls":4},"Augurken",250,0,null,"Vleesvarkensdrijfmest","D-VAR",18,{"v":7,"d":"7.0"},0.25,0.75,{"$nulls":9},"Wikken",645,30]
[{"$nulls":4},"Begonia (knol)",0,0,null,"Vleesvarkensgier","G-VAR",2,6.5,0.25,0.94,{"$nulls":9},"Winterrogge",850,30]
[{"$nulls":4},"Bieslook",300,0,null,"Vossenmest (vast)","V-VOS",95,17.7,0.25,0.8,{"$nulls":9},"Zomerkoolzaad",770,30]
[{"$nulls":4},"Bladspinazie",300,0,null,"Zeugendrijfmest","D-ZEUG",10,4.2,0.25,0.8]
[{"$nulls":4},"Blauwmaanzaad",750,0,null,"Zeugengier","G-ZEUG",3,{"v":2,"d":"2.0"},0.25,0.94,{"$nulls":9},"bron: praktijkgids bemesting NMI"]
[{"$nulls":4},"Bleekselderij",450,0]
[{"$nulls":4},"Bloemkool (exl. gewasresten)",1000,0,null,"bron: Nutrinorm.nl"]
[{"$nulls":4},"Bloemkool (incl. gewasresten)",1150,30]
[{"$nulls":4},"Boerenkool (excl. gewasresten)",750,0]
[{"$nulls":4},"Boerenkool (incl. gewasresten)",900,30]
[{"$nulls":4},"Bollen bijgoed",0,0]
[{"$nulls":4},"Bonen (overige) (excl. gewasresten)",170,0]
[{"$nulls":4},"Bonen (overige) (incl. gewaresten)",650,0]
[{"$nulls":4},"Bosuien",300,0]
[{"$nulls":4},"Braak",0,0]
[{"$nulls":4},"Broccoli",1150,30]
[{"$nulls":4},"Brouwgerst (excl. stro)",1310,0]
[{"$nulls":4},"Brouwgerst (incl. stro)",1940,-25]
[{"$nulls":4},"Bupleurum",0,0]
[{"$nulls":4},"Campanula",0,0]
[{"$nulls":4},"Carthamus",0,0]
[{"$nulls":4},"CCM maïs",1900,-25]
[{"$nulls":4},"Chelone",0,0]
[{"$nulls":4},"Chinese kool",450,20]
[{"$nulls":4},"Chrysant",0,0]
[{"$nulls":4},"Cichorei",700,0]
[{"$nulls":4},"Conserven-erwten (excl. gewasresten)",170,30]
[{"$nulls":4},"Conserven-erwten (incl. gewasresten)",1000,30]
[{"$nulls":4},"Consumptieaardappelen",875,0]
[{"$nulls":4},"Courgettes",250,0]
[{"$nulls":4},"Crocussen",150,0]
[{"$nulls":4},"Dahlia (incl. gewasresten)",750,0]
[{"$nulls":4},"Delphinium (ridderspoor)",0,0]
[{"$nulls":4},"Dicentra",0,0]
[{"$nulls":4},"Droogbloemen",0,0]
[{"$nulls":4},"Duizendschoon (Dianthus barbatus)",0,0]
[{"$nulls":4},"Echinops (kogeldistel)",0,0]
[{"$nulls":4},"Eremurus (naald van Cleopatra)",0,0]
[{"$nulls":4},"Erwten (overige) (excl. gewasresten)",170,30]
[{"$nulls":4},"Erwten (overige) (incl. gewasresten)",1000,30]
[{"$nulls":4},"Gentiaan",0,0]
[{"$nulls":4},"Gladiolen kralen",1000,0]
[{"$nulls":4},"Gladiolen pitten",1900,0]
[{"$nulls":4},"Graanplantsilage",750,0]
[{"$nulls":4},"Grasland (inzaai najaar)",450,25]
[{"$nulls":4},"Grasland (jaar 1)",1175,25]
[{"$nulls":4},"Grasland (jaar 2 of ouder)",1400,25]
[{"$nulls":4},"Graszaad",2300,0]
[{"$nulls":4},"Gypsophila (gipskruid)",0,0]
[{"$nulls":4},"Haver (excl. stro)",1570,0]
[{"$nulls":4},"Haver (incl. stro)",2470,-25]
[{"$nulls":4},"Helenium",0,0]
[{"$nulls":4},"Helianthus (zonnebloem)",0,0]
[{"$nulls":4},"Helleborus (kerstroos)",0,0]
[{"$nulls":4},"Hennep",660,0]
[{"$nulls":4},"Hortensia",0,0]
[{"$nulls":4},"Hosta",0,0]
[{"$nulls":4},"Hyacinten",350,0]
[{"$nulls":4},"Hypericum",0,0]
[{"$nulls":4},"Irissen",400,0]
[{"$nulls":4},"Japanse uien",300,0]
[{"$nulls":4},"Karwij (incl. stro)",1275,0]
[{"$nulls":4},"Kervel",300,0]
[{"$nulls":4},"Klaver",1200,30]
[{"$nulls":4},"Knoflook",300,0]
[{"$nulls":4},"Knolselderij (excl. loof)",400,0]
[{"$nulls":4},"Knolselderij (incl. loof)",1000,0]
[{"$nulls":4},"Knolvenkel (excl. loof)",400,0]
[{"$nulls":4},"Knolvenkel (incl. loof)",750,20]
[{"$nulls":4},"Kool (overige)",1150,20]
[{"$nulls":4},"Koolraap (excl. loof)",550,0]
[{"$nulls":4},"Koolraap (incl. loof)",1150,20]
[{"$nulls":4},"Koolrabi – Zaadteelt",300,20]
[{"$nulls":4},"Koolrabi (excl. bladresten)",300,0]
[{"$nulls":4},"Koolrabi (incl. bladresten)",550,20]
[{"$nulls":4},"Koolzaad",975,0]
[{"$nulls":4},"Korrelmaïs",2200,-25]
[{"$nulls":4},"Kruiden",300,0]
[{"$nulls":4},"Landbouwerwten",200,30]
[{"$nulls":4},"Lathyrus",0,0]
[{"$nulls":4},"Lelies",450,0]
[{"$nulls":4},"Limonium",0,0]
[{"$nulls":4},"Luzerne (jaar 1)",1350,75]
[{"$nulls":4},"Luzerne (jaar 2)",2050,75]
[{"$nulls":4},"Lysimachia",0,0]
[{"$nulls":4},"Matthiola (violier)",0,0]
[{"$nulls":4},"Narcis grofbollig",700,0]
[{"$nulls":4},"Narcis kleinbollig",200,0]
[{"$nulls":4},"Narcissen",500,0]
[{"$nulls":4},"Nigella",0,0]
[{"$nulls":4},"Ornithogalum (vogelmelk)",0,0]
[{"$nulls":4},"Overige akkerbouwgewassen",0,0]
[{"$nulls":4},"Overige bloembollen",0,0]
[{"$nulls":4},"Overige bloemgewassen",0,0]
[{"$nulls":4},"Overige groentegewassen",0,0]
[{"$nulls":4},"Paksoi",450,0]
[{"$nulls":4},"Papaver",0,0]
[{"$nulls":4},"Parijse wortelen",700,0]
[{"$nulls":4},"Peterselie",250,0]
[{"$nulls":4},"Peulen",170,20]
[{"$nulls":4},"Phlox",0,0]
[{"$nulls":4},"Physalis (lampionplant)",0,0]
[{"$nulls":4},"Picklers uien",300,0]
[{"$nulls":4},"Pioen/Paeonia",0,0]
[{"$nulls":4},"Plantuien",300,0]
[{"$nulls":4},"Pompoen",350,0]
[{"$nulls":4},"Pootaardappelen",875,0]
[{"$nulls":4},"Prei (excl. bladresten)",100,0]
[{"$nulls":4},"Prei (incl. bladresten)",450,20]
[{"$nulls":4},"Raapstelen",0,0]
[{"$nulls":4},"Rabarber",0,0]
[{"$nulls":4},"Radicchio rosso",300,0]
[{"$nulls":4},"Radijs",0,0]
[{"$nulls":4},"Rettich",700,0]
[{"$nulls":4},"Rode bieten (kroten)",600,20]
[{"$nulls":4},"Rode kool (excl. oogstresten)",1000,0]
[{"$nulls":4},"Rode kool (incl. oogstresten)",1150,30]
[{"$nulls":4},"Roodlof",300,0]
[{"$nulls":4},"Rudbeckia",0,0]
[{"$nulls":4},"Savooiekool (excl. oogstresten)",1000,0]
[{"$nulls":4},"Savooiekool (incl. oogstresten)",1440,20]
[{"$nulls":4},"Scabiosa (duifkruid)",0,0]
[{"$nulls":4},"Schorseneren",600,0]
[{"$nulls":4},"Sjalotten",500,0]
[{"$nulls":4},"Sla (krop)",300,0]
[{"$nulls":4},"Sluitkool",1150,30]
[{"$nulls":4},"Snijmaïs continuteelt",660,0]
[{"$nulls":4},"Snijmaïs vruchtwisseling",660,0]
[{"$nulls":4},"Solidago (gulden roede)",0,0]
[{"$nulls":4},"Spitskool (excl. oogstresten)",1000,0]
[{"$nulls":4},"Spitskool (incl. oogstresten)",1150,20]
[{"$nulls":4},"Spruitkool (excl. stammen)",1300,0]
[{"$nulls":4},"Spruitkool (incl. stammen)",2000,40]
[{"$nulls":4},"Stambonen",650,30]
[{"$nulls":4},"Stamslabonen (incl. stro)",650,20]
[{"$nulls":4},"Stamsnijbonen (excl. oogstresten)",170,20]
[{"$nulls":4},"Stamsnijbonen (incl. oogstresten)",650,20]
[{"$nulls":4},"Stoksperciebonen",650,20]
[{"$nulls":4},"Suikerbieten (excl. kop + bladresten)",375,0]
[{"$nulls":4},"Suikerbieten (incl. kop + bladresten)",1275,15]
[{"$nulls":4},"Triticale (excl. stro)",1600,0]
[{"$nulls":4},"Triticale (incl. stro)",2530,-25]
[{"$nulls":4},"Tuinbonen",650,20]
[{"$nulls":4},"Tulpen",500,0]
[{"$nulls":4},"Veldbonen (excl. oogstresten)",170,20]
[{"$nulls":4},"Veldbonen (incl. oogstresten)",1000,20]
[{"$nulls":4},"Veronica",0,0]
[{"$nulls":4},"Vlas",100,0]
[{"$nulls":4},"Voederbieten (excl. kop + bladresten)",375,0]
[{"$nulls":4},"Voederbieten (incl. kop + bladrestren)",1275,25]
[{"$nulls":4},"Waspeen",700,0]
[{"$nulls":4},"Wikken",645,20]
[{"$nulls":4},"Wintergerst (excl. stro)",1570,0]
[{"$nulls":4},"Wintergerst (incl. stro)",2350,-25]
[{"$nulls":4},"Winterrogge (excl. stro)",1500,0]
[{"$nulls":4},"Winterrogge (incl. stro)",2520,-25]
[{"$nulls":4},"Wintertarwe (excl. stro)",1640,0]
[{"$nulls":4},"Wintertarwe (incl. stro)",2630,-25]
[{"$nulls":4},"Winterwortelen",700,0]
[{"$nulls":4},"Witlof",600,0]
[{"$nulls":4},"Witte kool (excl. gewasresten)",1000,0]
[{"$nulls":4},"Witte kool (incl. gewasresten)",1150,30]
[{"$nulls":4},"Wortels (overige)",100,0]
[{"$nulls":4},"Yssla",450,0]
[{"$nulls":4},"Zaadbieten (excl. gewasresten)",450,0]
[{"$nulls":4},"Zaaigoed bloemen",0,0]
[{"$nulls":4},"Zaaiuien",300,0]
[{"$nulls":4},"Zantedeschia (calla of aronskelk)",0,0]
[{"$nulls":4},"Zetmeelaardappelen",875,0]
[{"$nulls":4},"Zilveruien",300,0]
[{"$nulls":4},"Zomergerst (excl. stro)",1310,0]
[{"$nulls":4},"Zomergerst (incl. stro)",1940,-25]
[{"$nulls":4},"Zomerrogge (excl. stro)",1310,0]
[{"$nulls":4},"Zomerrogge (incl. stro)",1940,-25]
[{"$nulls":4},"Zomertarwe (excl. stro)",1630,0]
[{"$nulls":4},"Zomertarwe (incl. stro)",2590,-25]
[{"$nulls":4},"Zomerwortelen",700,0]
[{"$nulls":4},"Zwarte braak",0,0]
[]
[{"$nulls":4},"bron: praktijkgids bemesting NMI, BLGG",null,"bron: Kennisakker Adviesbasis voor bemesting 2012"]
[{"$nulls":6},"bieten kop + blad gesteld op 15 kg N omdat koppen niet meer achterblijven op het veld."]