{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["INPUT -OUTPUT","Grafiek","Gevoeligheidsanalyse","Berekening","transport berekening","versies"],"not_rendered":{"charts":5,"images":4,"macros":1,"external_links":1,"defined_names":32,"comments":3,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"INPUT -OUTPUT","index":0,"n_rows":59,"n_cols":17,"rows_kept":59,"cut":false,"hidden":false,"merged":[[53,5,55,5],[53,6,55,6],[4,12,4,13],[44,9,45,10],[39,9,40,10],[39,8,40,8],[44,8,45,8],[1,14,1,16],[1,1,2,1],[53,1,55,1],[53,2,55,2],[5,2,5,3],[53,3,55,3],[4,2,4,3],[27,5,27,6],[27,7,28,9],[6,2,6,3],[21,13,29,16],[25,11,26,12],[21,11,22,12],[4,5,4,7],[42,12,46,16],[53,4,55,4]]}
[]
[null,"INPUT",null,null,null,null,null,null,null,null,null,null,null,null,"check laatste versie hier"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"versie 1.0 2/07/2020"]
[null,"ADMINISTRATIEVE GEGEVENS VAN DE BEMALINGSSITE"]
[null,"OMV nummer",null,null,"straat",null,null,null,"nr",null,null,"gemeente"]
[null,"aanvrager"]
[null,"ingevuld door",null,null,"datum",{"$f":"TODAY()","v":"2020-09-07"},null,null,{"$f":"IF(OR(ISBLANK(C5),ISBLANK(F5),ISBLANK(J5),ISBLANK(M5),ISBLANK(C6),ISBLANK(C7)),\"Vul alle administratieve gegevens in. \",\"\")","v":"Vul alle administratieve gegevens in. "}]
[]
[null,"LIGGING","Gelegen in beschermd duingebied?",null,null,null,null,null,null,"NEEN",null,null,"zie DOV themaviewer bemalingen"]
[null,null,"Gelegen in groengebied, natuurontwikkelingsgebied, parkgebied of bosgebied?",null,null,null,null,null,null,"NEEN"]
[null,null,"Gelegen in Waterwingebied of beschermingszone Type I of II?",null,null,null,null,null,null,"NEEN",null,null,{"$f":"IF(OR(ISBLANK(J9),ISBLANK(J10),ISBLANK(J11),ISBLANK(J12)),\"Vul alle vragen met betrekking tot de ligging in. \",\"\")","v":""}]
[null,null,"Afstand tot speciale beschermingszones (habitat richtlijngebied, vogelrichtlijngebied)",null,null,null,null,null,null,1,"in meter",null,{"$f":"IF(ISBLANK(J12),\"<----  indien leeg: wordt beschouwd als IN habitatgebied!\",\"\")","v":""}]
[]
[]
[null,"GEGEVENS OVER DE BOUWPUT EN DE ONDERGROND"]
[null,null,null,null,"grondwatervoeding uit neerslag",200,"mm/j"]
[null,null,null,null,"Bemalingskader / bouwput:",null,null,null,null,null,null,null,null,"Maaiveld",null,"mTAW"]
[null,null,null,null,"breedte",null,"m"]
[null,null,null,null,"lengte",null,"m",null,null,null,null,null,null,"Watertafel / oorspronkelijk peil",null,"m-mv"]
[null,null,"s",null,"diepte",null,"m-mv"]
[null,null,null,null,"equivalente r",{"$f":"Berekening!C6","v":""},"m",null,null,null,"verontreiniging"]
[null,null,null,null,null,null,null,null,null,"afstand",null,"m tot centrum bemaling",null,{"$f":"IF(OR(ISBLANK(F16),ISBLANK(F18),ISBLANK(F19),ISBLANK(F20),ISBLANK(O17),ISBLANK(O19),ISBLANK(F25),ISBLANK(F26),ISBLANK(F27),ISBLANK(F30),AND(ISBLANK(F28),ISBLANK(F29))),\"vul alle gele cellen in.\",CONCATENATE(IF(Berekening!F9<0.05,\"Zeer kleine doorlatendheid, kies voldoende lage voeding. \",\"\"), IF(Berekening!F12<Berekening!F11,\"Watertafel boven maaiveld. \",\"\"),IF(Berekening!F16<Berekening!F14,\"Filter minder diep dan gewenste verlaging. \",\"\"),IF(Berekening!F16>Berekening!F17,\"Filter dieper dan ondoorlatende basis. Pas filterdiepte of peil ondoorlatende basis aan. \",\"\"),IF(Berekening!F14<Berekening!F12,\"Gewenst waterpeil (verlaging) minder diep dan oorspronkelijk peil. \",\"\"), IF(Berekening!F14<Berekening!F13+0.5,\"Gewenst waterpeil (verlaging) minder diep dan halve meter onder bouwput. \",\"\"),IF(Berekening!F13<Berekening!F12,\"Basis bouwput boven de oorspronkelijke watertafel. Geen bemaling nodig. \",\"\"),IF(Berekening!F17<Berekening!F11,\"Ondoorlatende basis hoger dan maaiveld. \",\"\"),IF(Berekening!F14>Berekening!F17,\"Gewenste verlaging dieper dan de ondoorlatende basis. \",\"\"),IF(B57<0,\"Afstand 'verlaging op' moet groter zijn dan equivalente straal. \",\"\"),IF('transport berekening'!C4<0,\"Afstand verontreiniging moet groter zijn dan equivalete straal. \",\"\"),IF(AND(ISNUMBER(K24),K24<1),\"Retardatiefactor moet minstens 1 zijn. \",\"\"),IF(ISBLANK(K22),\"\",IF(ISBLANK(K23),\"Vul effectieve porositeit in. \",\"\")),IF(ISBLANK(K22),\"\",IF(ISBLANK(K24),\"Vul retardatiefactor in van 1 of groter. \",\"\")),IF(K23>0.3,\"Porositeit is steeds kleiner dan 1 (tussen 0,05 en 0,3). \",\"\"),\"\"))","v":"vul alle gele cellen in."}]
[null,null,"H",null,null,null,null,null,null,"effectieve porositeit"]
[null,null," (t.o.v. onderkant filter)",null,null,null,null,null,null,"retardatiefactor"]
[null,null,null,null,"gewenste verlaging tot",null,"m-mv"]
[null,null,null,null,"duur bemaling",null,"dagen",null,null,"Wat is de verlaging op",null,"m tot rand bemaling"]
[null,null,null,null,"Filterdiepte",null,"m-mv"]
[null,null,null,null,"Grondsoort",null,null,{"$f":"IF(OR(ISBLANK(F16),ISBLANK(F18),ISBLANK(F19),ISBLANK(F20),ISBLANK(O17),ISBLANK(O19),ISBLANK(F25),ISBLANK(F26),ISBLANK(F27),ISBLANK(F30)),\"\",IF(SUM(ISBLANK(F29),ISBLANK(F28))=0,\"slechts 1 van de twee invullen\",IF(SUM(ISBLANK(F29),ISBLANK(F28))=2,\"Vul grondsoort OF doorlatendheid in\",\"\")))","v":""}]
[null,null,null,null,"OF Doorlatendheid",null,"m/d"]
[null,null,null,null,"Peil ondoorlatende basis:",null,"m-mv"]
[]
[]
[]
[null," OUTPUT"]
[]
[null,"DEBIET en INVLOEDSTRAAL",null,null,null,null,null,null,null,null,null,null,"RUBRIEK","volgens DUPUIT",null,"link indelingslijst"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"C47","v":""}]
[null,null,"Begin van de bemaling - debiet en invloedstraal volgens Dupuit en Sichardt ",null,null,null,null,null,null,null,null,null,"max dagdebiet",{"$f":"G41","v":""},"m³/d"]
[null,null,"Invloedstraal",null,{"$f":"r_sichard","v":""},"m vanaf de rand",null,null,null,null,null,null,"max jaardebiet",{"$f":"IF(AND(ISNUMBER(G41),ISNUMBER(G46)),IF(duur<366,G41*5+G46*(duur-5),(G41*5+G46*360)),\"\")","v":""},"m³/j"]
[null,null,"Initiëel debiet",null,{"$f":"IF(ISERROR(q_sichard),\"\",q_sichard)","v":""},"m³/u       --->",{"$f":"IF(ISERROR(q_sichard),\"\",E40*24)","v":""},"m³/d  ",{"$f":"IF(ISNUMBER(G41),INT(G41*5),\"\")","v":""},"volume in m³ voor eerste 5 dagen",null,null,"rubriek",{"$f":"IF(AND(ISNUMBER(G41),ISNUMBER(G46)),\nIF(M11=\"\",\nIF(AND($F$20>2.5,$J$11=\"JA\"),\"UITGRAVING DIEPER DAN 2,5 m IS VERBODEN\",\nCONCATENATE(\nIF(AND(OR($J$10=\"JA\",$J$9=\"JA\"),N39<=30000,G41<=500),\"53.2.1°a)\",\"\"),\nIF(AND(OR($J$10=\"JA\",$J$9=\"JA\"),AND(OR(N39>30000,G41>500),G41<=2000)),\"53.2.1°b)\",\"\"),\nIF(AND(OR($J$10=\"JA\",$J$9=\"JA\"),G41>2000),\"53.2.1°c)\",\"\"),\nIF(AND(AND($J$10=\"NEEN\",$J$9=\"NEEN\"),N39<=30000),\"53.2.2°a)\",\"\"),\nIF(AND(AND($J$10=\"NEEN\",$J$9=\"NEEN\"),N39>30000,Berekening!F14<=4),\"53.2.2°b)1°\",\"\"),\nIF(AND(AND($J$10=\"NEEN\",$J$9=\"NEEN\"),N39>30000,Berekening!F14>4),\"53.2.2°b)2°\",\"\"),\nIF(G41>=2500,\" en 53.11.1°\",\"\"),\nIF(AND(OR($J$9=\"JA\",$J$12<E44),G41>=1000),\" en 53.11.2°\",\"\"),)),\"Vul gele cellen in bij 'Ligging bemaling'\"),\"\")","v":""}]
[null,null,"Onvolkomen debiet",null,{"$f":"IF(ISERROR(q_sichard),\"\",Berekening!C40)","v":""},"m³/u       --->",{"$f":"IF(ISERROR(q_sichard),\"\",E41*24)","v":""},"m³/d",null,null,null,null,"klasse",{"$f":"IF(AND(ISNUMBER(G41),ISNUMBER(G46)),\nIF(AND(F20>2.5,J11=\"JA\"),\"VERBODEN\",\nMIN(\nIF(AND(OR(J10=\"JA\",J9=\"JA\"),N39<=30000,G41<=500),3,99),\nIF(AND(OR(J10=\"JA\",J9=\"JA\"),AND(OR(N39>30000,G41>500),G41<=2000)),2,99),\nIF(AND(OR(J10=\"JA\",J9=\"JA\"),G41>2000),1,99),\nIF(AND(AND(J10=\"NEEN\",J9=\"NEEN\"),N39<=30000),3,99),\nIF(AND(AND(J10=\"NEEN\",J9=\"NEEN\"),N39>30000,Berekening!F14<=4),3,99),\nIF(AND(AND(J10=\"NEEN\",J9=\"NEEN\"),N39>30000,Berekening!F14>4),2,99),\nIF(G41>=2500,1,99),\nIF(AND(OR(J9=\"JA\",J12<E44),G41>=1000),1,99))),\"\")","v":""}]
[]
[null,null,"Stationaire toestand volgens DUPUIT - debiet en invloedstraal in evenwicht gebracht met grondwatervoeding",null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(ISNUMBER(G41),ISNUMBER(G46)),\nCONCATENATE(IF(OR(N38>2500,N39>500000),\"WAARSCHUWING: Een hydrogeologische studie (bijlage RH) moet aan de aanvraag toegevoegd worden.\n\",\"\"),IF(N39>10000000,\"WAARSCHUWING: Project-MER vereist.\n\",\"\"),IF(N38>1000,\"WAARSCHUWING: Project-MER of ontheffingsnota vereist indien impact op kustduinen of speciale beschermingszones.\",\"\"),IF($J$12<E44,\"WAARSCHUWING: Invloedstraal tot in speciale beschermingszone\",\"\")),\"\")","v":""}]
[null,null,"Invloedstraal",null,{"$f":"IF(input_ok=\"OK\",Berekening!C32-F21,\"\")","v":""},"m vanaf de rand (met verlaging = 5 cm)"]
[null,null,"Stationair debiet",null,{"$f":"IF(input_ok=\"OK\",q_stat,\"\")","v":""},"m³/u       --->",{"$f":"IF(ISNUMBER(E45),E45*24,\"\")","v":""},"m³/d",{"$f":"IF(ISNUMBER(G46),INT(G46*(duur-5)),\"\")","v":""},"volume in m³ resterende duur"]
[null,null,"Onvolkomen stationair debiet",null,{"$f":"IF(input_ok=\"OK\",Berekening!C41,\"\")","v":""},"m³/u       --->",{"$f":"IF(ISNUMBER(E46),E46*24,\"\")","v":""},"m³/d"]
[null,null,{"$f":"IF(input_ok=\"OK\",IF(AND(ABS(Berekening!C45-q_stat)<0.1,ABS(Berekening!D45-r_stat)<1),\"\",\"FOUTIEVE ITERATIEVE BEREKENING\"),\"\")","v":""}]
[null,null,"Stationaire toestand volgens VERRUIJT - invloedstraal in evenwicht gebracht met grondwatervoeding"]
[null,null,"Invloedstraal",null,{"$f":"IF(input_ok=\"OK\",Berekening!C37-F21,\"\")","v":""},"m vanaf de rand (met verlaging = 5 cm)"]
[]
[]
[]
[null,"VERLAGING OP EEN AFSTAND",null,null,null,null,null,null,null,null,null,null,"VERPLAATSING VERONTREINIGING"]
[null,"afstand tot rand bemaling (m)","afstand tot centrum bemaling (m)","H (verzadigde dikte t.o.v. onderkant filter in m)","h (mTAW)","verlaging s t.o.v. oorspr. peil (m)","Peil (m-mv)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Berekend met afpompingskegel volgens DUPUIT"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(K22),\"\",IF('transport berekening'!D4>E44,\"verontreiniging buiten invloedstraal\",IF('transport berekening'!D12<duur,CONCATENATE(\"Verontreiniging bereikt bemaling na \",'transport berekening'!D12,\" dagen\"),CONCATENATE(\"Verplaatsing na \", duur,\" dagen: \",'transport berekening'!D11,\" m \"))))","v":""}]
[null,{"$f":"Berekening!J48","v":""},{"$f":"Berekening!K48","v":""},{"$f":"Berekening!L48","v":""},{"$f":"Berekening!M48","v":""},{"$f":"Berekening!N48","v":""},{"$f":"Berekening!O48","v":""},{"$f":"Berekening!P48","v":""},null,null,null,null,"Berekend met afpompingskegel volgens VERRUIJT"]
[null,null,null,{"$f":"Berekening!L49","v":""},{"$f":"Berekening!M49","v":""},{"$f":"Berekening!N49","v":""},{"$f":"Berekening!O49","v":""},{"$f":"Berekening!P49","v":""},null,null,null,null,{"$f":"IF(ISBLANK(K22),\"\",IF('transport berekening'!D4>E49,\"verontreiniging buiten invloedstraal\",IF('transport berekening'!P12<duur,CONCATENATE(\"Verontreiniging bereikt bemaling na \",'transport berekening'!P12,\" dagen\"),CONCATENATE(\"Verplaatsing na \", duur,\" dagen: \",'transport berekening'!P11,\" m \"))))","v":""}]
[null,null,null,{"$f":"Berekening!L50","v":""},{"$f":"Berekening!M50","v":""},{"$f":"Berekening!N50","v":""},{"$f":"Berekening!O50","v":""},{"$f":"Berekening!P50","v":""}]

{"sheet":"Grafiek","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Gevoeligheidsanalyse","index":2,"n_rows":85,"n_cols":10,"rows_kept":85,"cut":false,"hidden":false,"merged":[]}
["Gevoeligheid voor de gekozen doorlatendheid K"]
["enkel uitgevoerd voor Dupuit in evenwicht met de voeding uit neerslag"]
[]
["originele K-waarde",{"$f":"doorlatendheid","v":{"$error":"#N/A"}},"m/d"]
[]
[null,"factor",0.2,0.5,1,2,5]
[null,"doorlatendheid (m/d)",{"$f":"doorlatendheid*C6","v":{"$error":"#N/A"}},{"$f":"doorlatendheid*D6","v":{"$error":"#N/A"}},{"$f":"doorlatendheid*E6","v":{"$error":"#N/A"}},{"$f":"doorlatendheid*F6","v":{"$error":"#N/A"}},{"$f":"doorlatendheid*G6","v":{"$error":"#N/A"}}]
["Sichard"]
[null,"debiet (m³/u)",{"$f":"(PI()*doorlatendheid*C6*(rustpeil^2-(rustpeil-verlaging)^2))/(LN(r_sichard+r_equivalent)-LN(r_equivalent))/24","v":{"$error":"#N/A"}},{"$f":"(PI()*doorlatendheid*D6*(rustpeil^2-(rustpeil-verlaging)^2))/(LN(r_sichard+r_equivalent)-LN(r_equivalent))/24","v":{"$error":"#N/A"}},{"$f":"(PI()*doorlatendheid*E6*(rustpeil^2-(rustpeil-verlaging)^2))/(LN(r_sichard+r_equivalent)-LN(r_equivalent))/24","v":{"$error":"#N/A"}},{"$f":"(PI()*doorlatendheid*F6*(rustpeil^2-(rustpeil-verlaging)^2))/(LN(r_sichard+r_equivalent)-LN(r_equivalent))/24","v":{"$error":"#N/A"}},{"$f":"(PI()*doorlatendheid*G6*(rustpeil^2-(rustpeil-verlaging)^2))/(LN(r_sichard+r_equivalent)-LN(r_equivalent))/24","v":{"$error":"#N/A"}}]
[null,"debiet (m³/d)",{"$f":"C9*24","v":{"$error":"#N/A"}},{"$f":"D9*24","v":{"$error":"#N/A"}},{"$f":"E9*24","v":{"$error":"#N/A"}},{"$f":"F9*24","v":{"$error":"#N/A"}},{"$f":"G9*24","v":{"$error":"#N/A"}}]
[null,"invloedstraal (m)",{"$f":"IF(input_ok=\"OK\",IF(verlaging>0,3000*(doorlatendheid*C6/3600/24)^0.5*(verlaging),\"\"),\"\")","v":""},{"$f":"IF(input_ok=\"OK\",IF(verlaging>0,3000*(doorlatendheid*D6/3600/24)^0.5*(verlaging),\"\"),\"\")","v":""},{"$f":"IF(input_ok=\"OK\",IF(verlaging>0,3000*(doorlatendheid*E6/3600/24)^0.5*(verlaging),\"\"),\"\")","v":""},{"$f":"IF(input_ok=\"OK\",IF(verlaging>0,3000*(doorlatendheid*F6/3600/24)^0.5*(verlaging),\"\"),\"\")","v":""},{"$f":"IF(input_ok=\"OK\",IF(verlaging>0,3000*(doorlatendheid*G6/3600/24)^0.5*(verlaging),\"\"),\"\")","v":""}]
[]
["Dupuit met voeding uit neerslag"]
[null,"debiet (m³/u)",{"$f":"(PI()*doorlatendheid*C6*(rustpeil^2-(rustpeil-verlaging)^2))/(LN(C16)-LN(r_equivalent))/24","v":{"$error":"#N/A"}},{"$f":"(PI()*doorlatendheid*D6*(rustpeil^2-(rustpeil-verlaging)^2))/(LN(D16)-LN(r_equivalent))/24","v":{"$error":"#N/A"}},{"$f":"(PI()*doorlatendheid*E6*(rustpeil^2-(rustpeil-verlaging)^2))/(LN(E16)-LN(r_equivalent))/24","v":{"$error":"#N/A"}},{"$f":"(PI()*doorlatendheid*F6*(rustpeil^2-(rustpeil-verlaging)^2))/(LN(F16)-LN(r_equivalent))/24","v":{"$error":"#N/A"}},{"$f":"(PI()*doorlatendheid*G6*(rustpeil^2-(rustpeil-verlaging)^2))/(LN(G16)-LN(r_equivalent))/24","v":{"$error":"#N/A"}}]
[null,"debiet (m³/d)",{"$f":"C14*24","v":{"$error":"#N/A"}},{"$f":"D14*24","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,"invloedstraal (m)",{"$f":"IF(ISNUMBER(C14),(C14/(voeding_m3_u*PI()))^0.5,r_equivalent+r_sichard)","v":{"$error":"#VALUE!"}},{"$f":"IF(ISNUMBER(D14),(D14/(voeding_m3_u*PI()))^0.5,r_equivalent+r_sichard)","v":{"$error":"#VALUE!"}},{"$f":"IF(ISNUMBER(E14),(E14/(voeding_m3_u*PI()))^0.5,r_equivalent+r_sichard)","v":{"$error":"#VALUE!"}},{"$f":"IF(ISNUMBER(F14),(F14/(voeding_m3_u*PI()))^0.5,r_equivalent+r_sichard)","v":{"$error":"#VALUE!"}},{"$f":"IF(ISNUMBER(G14),(G14/(voeding_m3_u*PI()))^0.5,r_equivalent+r_sichard)","v":{"$error":"#VALUE!"}}]
[null,"verlaging 5 cm op afstand (m)",{"$f":"C16*EXP(-PI()*doorlatendheid*C6*(rustpeil^2-(rustpeil-0.05)^2)/C14/24)","v":{"$error":"#VALUE!"}},{"$f":"D16*EXP(-PI()*doorlatendheid*D6*(rustpeil^2-(rustpeil-0.05)^2)/D14/24)","v":{"$error":"#VALUE!"}},{"$f":"E16*EXP(-PI()*doorlatendheid*E6*(rustpeil^2-(rustpeil-0.05)^2)/E14/24)","v":{"$error":"#VALUE!"}},{"$f":"F16*EXP(-PI()*doorlatendheid*F6*(rustpeil^2-(rustpeil-0.05)^2)/F14/24)","v":{"$error":"#VALUE!"}},{"$f":"G16*EXP(-PI()*doorlatendheid*G6*(rustpeil^2-(rustpeil-0.05)^2)/G14/24)","v":{"$error":"#VALUE!"}}]
[null,"totaal volume van bemaling",{"$f":"C10*5+C15*(duur-5)","v":{"$error":"#N/A"}},{"$f":"D10*5+D15*(duur-5)","v":{"$error":"#N/A"}},{"$f":"E10*5+E15*(duur-5)","v":{"$error":"#N/A"}},{"$f":"F10*5+F15*(duur-5)","v":{"$error":"#N/A"}},{"$f":"G10*5+G15*(duur-5)","v":{"$error":"#N/A"}}]
[null,"totaal volume met toeslagfactor",{"$f":"C18*toeslagfactor","v":{"$error":"#N/A"}},{"$f":"D18*toeslagfactor","v":{"$error":"#N/A"}},{"$f":"E18*toeslagfactor","v":{"$error":"#N/A"}},{"$f":"F18*toeslagfactor","v":{"$error":"#N/A"}},{"$f":"G18*toeslagfactor","v":{"$error":"#N/A"}}]
[]
["Verruijt met voeding uit neerslag"]
[null,"debiet (m³/u)",{"$f":"IF(ISNUMBER(C22),((rustpeil-verlaging)^2-rustpeil^2+voeding_m3_u*24/(2*doorlatendheid*C6)*(r_equivalent^2-C24^2))*PI()*doorlatendheid*C6/LN(r_equivalent/C24)/24,100)","v":100},{"$f":"IF(ISNUMBER(D22),((rustpeil-verlaging)^2-rustpeil^2+voeding_m3_u*24/(2*doorlatendheid*D6)*(r_equivalent^2-D24^2))*PI()*doorlatendheid*D6/LN(r_equivalent/D24)/24,100)","v":100},{"$f":"IF(ISNUMBER(E22),((rustpeil-verlaging)^2-rustpeil^2+voeding_m3_u*24/(2*doorlatendheid*E6)*(r_equivalent^2-E24^2))*PI()*doorlatendheid*E6/LN(r_equivalent/E24)/24,100)","v":100},{"$f":"IF(ISNUMBER(F22),((rustpeil-verlaging)^2-rustpeil^2+voeding_m3_u*24/(2*doorlatendheid*F6)*(r_equivalent^2-F24^2))*PI()*doorlatendheid*F6/LN(r_equivalent/F24)/24,100)","v":100},{"$f":"IF(ISNUMBER(G22),((rustpeil-verlaging)^2-rustpeil^2+voeding_m3_u*24/(2*doorlatendheid*G6)*(r_equivalent^2-G24^2))*PI()*doorlatendheid*G6/LN(r_equivalent/G24)/24,100)","v":100}]
[null,"debiet (m³/d)",{"$f":"C22*24","v":2400},{"$f":"D22*24","v":2400},2400,2400,2400]
[null,"invloedstraal (m)",{"$f":"IF(ISNUMBER(C22),(C22/(voeding_m3_u*PI()))^0.5,100)","v":1180.761322827354},{"$f":"IF(ISNUMBER(D22),(D22/(voeding_m3_u*PI()))^0.5,100)","v":1180.761322827354},{"$f":"IF(ISNUMBER(E22),(E22/(voeding_m3_u*PI()))^0.5,100)","v":1180.761322827354},{"$f":"IF(ISNUMBER(F22),(F22/(voeding_m3_u*PI()))^0.5,100)","v":1180.761322827354},{"$f":"IF(ISNUMBER(G22),(G22/(voeding_m3_u*PI()))^0.5,100)","v":1180.761322827354}]
[null,"tussenstap berekening ",{"$f":"(voeding_m3_u/2*C26^2+doorlatendheid*C6/24*((rustpeil-verlaging_x)^2-rustpeil^2)-voeding_m3_u/2*C24^2+C22/PI()*LN(C24))/C22*PI()","v":{"$error":"#N/A"}},{"$f":"(voeding_m3_u/2*D26^2+doorlatendheid*D6/24*((rustpeil-verlaging_x)^2-rustpeil^2)-voeding_m3_u/2*D24^2+D22/PI()*LN(D24))/D22*PI()","v":{"$error":"#N/A"}},{"$f":"(voeding_m3_u/2*E26^2+doorlatendheid*E6/24*((rustpeil-verlaging_x)^2-rustpeil^2)-voeding_m3_u/2*E24^2+E22/PI()*LN(E24))/E22*PI()","v":{"$error":"#N/A"}},{"$f":"(voeding_m3_u/2*F26^2+doorlatendheid*F6/24*((rustpeil-verlaging_x)^2-rustpeil^2)-voeding_m3_u/2*F24^2+F22/PI()*LN(F24))/F22*PI()","v":{"$error":"#N/A"}},{"$f":"(voeding_m3_u/2*G26^2+doorlatendheid*G6/24*((rustpeil-verlaging_x)^2-rustpeil^2)-voeding_m3_u/2*G24^2+G22/PI()*LN(G24))/G22*PI()","v":{"$error":"#N/A"}}]
[null,"verlaging 5 cm op afstand (m)",{"$f":"IF(ISNUMBER(C25),EXP(C25),100)","v":100},100,{"$f":"IF(ISNUMBER(E25),EXP(E25),100)","v":100},{"$f":"IF(ISNUMBER(F25),EXP(F25),100)","v":100},100]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["BEREKENING"]
["AFPOMPINGSCURVES"]
[]
["factor",{"$f":"C6","v":0.2},{"$f":"D6","v":0.5},{"$f":"E6","v":1},{"$f":"F6","v":2},{"$f":"G6","v":5}]
["debiet",{"$f":"C14","v":{"$error":"#N/A"}},{"$f":"D14","v":{"$error":"#N/A"}},{"$f":"E14","v":{"$error":"#N/A"}},{"$f":"F14","v":{"$error":"#N/A"}},{"$f":"G14","v":{"$error":"#N/A"}}]
["invloedstraal",{"$f":"C16","v":{"$error":"#VALUE!"}},{"$f":"D16","v":{"$error":"#VALUE!"}},{"$f":"E16","v":{"$error":"#VALUE!"}},{"$f":"F16","v":{"$error":"#VALUE!"}},{"$f":"G16","v":{"$error":"#VALUE!"}}]
[null,"DUPUIT: evenwicht met voeding, itteratieve berekening"]
[null,"afstand tot centrum put (m)","afstand tot centrum put (m)","afstand tot centrum put (m)","afstand tot centrum put (m)","afstand tot centrum put (m)","h (verzadigde dikte)","h(mTAW)","s (m)","Peil (m-mv)"]
[0,{"$f":"IF(verlaging>0,10^(LOG(r_equivalent)+$A65*(LOG(B$62)-LOG(r_equivalent))/20),\"\")","v":""},"","","","",{"$f":"(rustpeil^2-(B$61*24*(LN(B$62)-LN(B65))/(PI()*doorlatendheid*B$60)))^0.5","v":{"$error":"#N/A"}},{"$f":"maaiveld-diepte_filter+G65","v":{"$error":"#N/A"}},{"$f":"rustpeil-G65","v":{"$error":"#N/A"}},{"$f":"maaiveld-H65","v":{"$error":"#N/A"}}]
[1,"","","","","",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2,"","","","","",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[3,"","","","","",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[4,"","","","","",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[5,"","","","","",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[6,"","","","","",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[7,"","","","","",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[8,"","","","","",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[9,"","","","","",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[10,{"$f":"IF(verlaging>0,10^(LOG(r_equivalent)+$A75*(LOG(B$62)-LOG(r_equivalent))/20),\"\")","v":""},"","","","",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[11,"","","","","",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[12,"","","","","",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[13,"","","","","",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[14,"","","","","",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[15,"","","","","",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[16,"","","","","",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[17,"","","","","",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[18,"","","","","",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[19,"","","","","",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[20,"","","","","",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]

{"sheet":"Berekening","index":3,"n_rows":60,"n_cols":39,"rows_kept":60,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,null,null,null,null,null,"DUPUIT met Sichardt: begin bemaling",null,null,null,null,null,null,"DUPUIT: evenwicht met voeding, itteratieve berekening",null,null,null,null,null,null,"VERRUIJT : evenwicht met voeding, itteratieve berekening",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(AI2,\" \",AJ2)","v":" "}]
[null,"OMZETTINNG INPUT naar m-mv en m/d, bepalen toeslag onvolkomen bron",null,null,null,null,null,null,"afstand tot centrum put (m)","afstand tot rand put (m)","H (verzadigde dikte)","h(mTAW)","s (m)","Peil (m-mv)",null,"afstand tot centrum put (m)","afstand tot rand put (m)","h (verzadigde dikte)","h(mTAW)","s (m)","Peil (m-mv)",null,"afstand tot centrum put (m)","afstand tot rand put (m)","h (verzadigde dikte)","h(mTAW)","s (m)","Peil (m-mv)",null,null,"codetabel",null,null,null,null,null,{"$f":"CONCATENATE(AI3,\" \",AJ3)","v":" "}]
[null,"breedte bouwput",{"$f":"IF(ISNUMBER('INPUT -OUTPUT'!F18),'INPUT -OUTPUT'!F18)","v":false},"m",null,null,null,0,{"$f":"IF(verlaging>0,10^(LOG(r_equivalent)+H4*(LOG(r_sichard+r_equivalent)-LOG(r_equivalent))/20),\"\")","v":""},{"$f":"I4-r_equivalent","v":{"$error":"#VALUE!"}},{"$f":"(rustpeil^2-(q_sichard*24*(LN(r_equivalent+r_sichard)-LN(I4))/(PI()*doorlatendheid)))^0.5","v":{"$error":"#N/A"}},{"$f":"maaiveld-$F$16+K4","v":{"$error":"#N/A"}},{"$f":"rustpeil-K4","v":{"$error":"#N/A"}},{"$f":"maaiveld-L4","v":{"$error":"#N/A"}},null,{"$f":"IF(verlaging>0,10^(LOG(r_equivalent)+H4*(LOG(r_stat)-LOG(r_equivalent))/20),\"\")","v":""},{"$f":"P4-r_equivalent","v":{"$error":"#VALUE!"}},{"$f":"(rustpeil^2-(q_stat*24*(LN(r_stat)-LN(P4))/(PI()*doorlatendheid)))^0.5","v":{"$error":"#N/A"}},{"$f":"maaiveld-diepte_filter+R4","v":{"$error":"#N/A"}},{"$f":"rustpeil-R4","v":{"$error":"#N/A"}},{"$f":"maaiveld-S4","v":{"$error":"#N/A"}},10,{"$f":"IF(verlaging>0,10^(LOG(r_equivalent)+H4*(LOG(r_stat_veruijt)-LOG(r_equivalent))/20),\"\")","v":""},{"$f":"W4-r_equivalent","v":{"$error":"#VALUE!"}},{"$f":"(rustpeil^2+(q_stat_veruijt*24*(LN(W4/(r_stat_veruijt))/(PI()*doorlatendheid))+(voeding_m3_u*24/(2*doorlatendheid)*((r_stat_veruijt)^2-W4^2))))^0.5","v":{"$error":"#N/A"}},{"$f":"maaiveld-$F$16+Y4","v":{"$error":"#N/A"}},{"$f":"rustpeil-Y4","v":{"$error":"#N/A"}},{"$f":"maaiveld-Z4","v":{"$error":"#N/A"}},null,null,"eenheid","factor naar m/d",null,null,null,"grondsoort",{"$f":"CONCATENATE(AI4,\" \",AJ4)","v":" grondsoort"},"doorlatendheid (m/dag)"]
[null,"lengte bouwput",{"$f":"IF(ISNUMBER('INPUT -OUTPUT'!F19),'INPUT -OUTPUT'!F19,\"\")","v":""},"m",null,null,null,1,"",{"$error":"#VALUE!"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"maaiveld-L5","v":{"$error":"#N/A"}},null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},9,"",{"$error":"#VALUE!"},{"$error":"#N/A"},{"$f":"maaiveld-$F$16+Y5","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$f":"maaiveld-Z5","v":{"$error":"#N/A"}},null,null,"m/d",1]
[null,"equivalente straal",{"$f":"IF(AND(ISNUMBER(breedte), ISNUMBER(lengte)),(C4+C5)/PI(),\"\")","v":""},"m",null,null,null,2,"",{"$error":"#VALUE!"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},8,"",{"$error":"#VALUE!"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,"m/s",{"$f":"3600*24","v":86400},null,null,"01","zware klei",{"$f":"CONCATENATE(AI6,\" \",AJ6)","v":"01 zware klei"},1E-4]
[null,"duur bemaling",{"$f":"IF(ISNUMBER('INPUT -OUTPUT'!F26),'INPUT -OUTPUT'!F26)","v":false},"dagen",null,null,null,3,"",{"$error":"#VALUE!"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},7,"",{"$error":"#VALUE!"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,null,null,null,"02","potklei",{"$f":"CONCATENATE(AI7,\" \",AJ7)","v":"02 potklei"},1E-3]
[null,"type sediment",{"$f":"IF(ISBLANK('INPUT -OUTPUT'!F28),\"\",'INPUT -OUTPUT'!F28)","v":""},null,null,null,null,4,"",{"$error":"#VALUE!"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},6,"",{"$error":"#VALUE!"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,null,null,null,"03","matig zware klei","03 matig zware klei",0.01]
[null,"K (doorlatendhied)",{"$f":"IF(ISBLANK('INPUT -OUTPUT'!F29),\"\",'INPUT -OUTPUT'!F29)","v":""},{"$f":"'INPUT -OUTPUT'!G29","v":"m/d"},"-->",{"$f":"IF(k_m_d<>\"\",k_m_d*(IF(D9=\"m/d\",1,86400)),LOOKUP(sediment_type,AK6:AK43,AL6:AL43))","v":{"$error":"#N/A"}},"m/d",5,"",{"$error":"#VALUE!"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},5,"",{"$error":"#VALUE!"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,"keuzetabel","keuzetabel",null,null,"04","zandige klei","04 zandige klei",0.05]
[null,null,null,null,null,null,null,6,"",{"$error":"#VALUE!"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},4,"",{"$error":"#VALUE!"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,"mTAW",null,null,null,"05","keileem","05 keileem",0.05,"0.001 - 0.1"]
[null,"maaiveld",{"$f":"'INPUT -OUTPUT'!O17","v":0},{"$f":"'INPUT -OUTPUT'!P17","v":"mTAW"},"-->",{"$f":"0","v":0},"m-mv",7,"",{"$error":"#VALUE!"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},3,"",{"$error":"#VALUE!"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,"m-mv","JA",null,null,"06","veen","06 veen",0.01]
[null,"Peil in rust",{"$f":"'INPUT -OUTPUT'!O19","v":0},{"$f":"'INPUT -OUTPUT'!P19","v":"m-mv"},"-->",{"$f":"IF(D12=\"mTAW\",maaiveld-C12,C12)","v":0},"m-mv",8,"",{"$error":"#VALUE!"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},2,"",{"$error":"#VALUE!"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,"NEEN",null,null,"07","kleiig veen","07 kleiig veen",5.0000000000000001E-3]
[null,"Onderkant bouwput",{"$f":"'INPUT -OUTPUT'!F20","v":0},{"$f":"'INPUT -OUTPUT'!G20","v":"m-mv"},"-->",{"$f":"IF(D13=\"mTAW\",maaiveld-C13,C13)","v":0},"m-mv",9,"",{"$error":"#VALUE!"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},1,"",{"$error":"#VALUE!"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,null,null,null,"08","sterk zandig veen","08 sterk zandig veen",0.05]
[null,"s (gewenste verlaging)",{"$f":"'INPUT -OUTPUT'!F25","v":0},{"$f":"'INPUT -OUTPUT'!G25","v":"m-mv"},"-->",{"$f":"IF(D14=\"mTAW\",maaiveld-C14,C14)","v":0},"m-mv",10,"",{"$error":"#VALUE!"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,"Onvolkomen bron (fig 45 ",null,null,null,"09","leem/löss","09 leem/löss",0.05]
[null,"s (gewenste verlaging)",{"$f":"F14-F12","v":0},{"$f":"IF(verlaging<=0,\"negatieve verlaging: pas peilen aan!\",\"m\")","v":"negatieve verlaging: pas peilen aan!"},null,null,null,11,"",{"$error":"#VALUE!"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,"x van","x tot","factor",null,"10","zandige leem","10 zandige leem",0.3]
[null,"diepte filter",{"$f":"'INPUT -OUTPUT'!F27","v":0},{"$f":"'INPUT -OUTPUT'!G27","v":"m-mv"},"-->",{"$f":"IF(D16=\"mTAW\",maaiveld-C16,C16)","v":0},"m-mv",12,"",{"$error":"#VALUE!"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,0,1,1,null,"11","lichte zavel","11 lichte zavel",0.5]
[null,"ondoorlatende basis",{"$f":"'INPUT -OUTPUT'!F30","v":0},{"$f":"'INPUT -OUTPUT'!G30","v":"m-mv"},"-->",{"$f":"IF(D17=\"mTAW\",maaiveld-C17,C17)","v":0},"m-mv",13,"",{"$error":"#VALUE!"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,1,2,1.05,null,"12","uiterst fijn zand (kleiig)","12 uiterst fijn zand (kleiig)",0.5]
[null,"H (beperkt tot onderkant filter)",{"$f":"MIN(F16,F17)-F12","v":0},"dikte verzadigde zone vanaf onderkant filter in m",null,null,null,14,"",{"$error":"#VALUE!"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,2,3,1.1000000000000001,null,"13","uiterst fijn zand (zwak kleiig)","13 uiterst fijn zand (zwak kleiig)",2]
[null,"Toeslag onvolkomen bron",{"$f":"MIN(1.25,MAX(1,(F17-F16)*0.05 +1))","v":1},"automatisch bepaald",null,null,null,15,"",{"$error":"#VALUE!"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,3,4,1.1499999999999999,null,"14","uiterst fijn zand (zuiver)","14 uiterst fijn zand (zuiver)",3]
[null,"Grondwatervoeding",{"$f":"'INPUT -OUTPUT'!F16","v":200},"mm/j","-->",{"$f":"C20/1000/365/24","v":2.2831050228310506E-5},"m/u",16,"",{"$error":"#VALUE!"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,4,5,1.2,null,"15","zeer fijn zand (kleiig)","15 zeer fijn zand (kleiig)",1]
[null,"INPUT VOLLEDIG:",{"$f":"IF(OR(ISBLANK(breedte),ISBLANK(lengte),ISBLANK(duur),ISBLANK(doorlatendheid),ISBLANK(F17),ISBLANK(F12),ISBLANK(F13),ISBLANK(F14),ISBLANK(F16),ISBLANK(voeding_m3_u)),\"vul input aan in gele cellen\",\"OK\")","v":"OK"},null,null,null,null,17,"",{"$error":"#VALUE!"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,5,10000,1.25,null,"16","zeer fijn zand (zwak kleiig)","16 zeer fijn zand (zwak kleiig)",4]
[null,"INPUT CONSISTENT",{"$f":"IF('INPUT -OUTPUT'!N22=\"\",\"OK\",\"zie opmerkingen input tabblad\")","v":"zie opmerkingen input tabblad"},null,null,null,null,18,"",{"$error":"#VALUE!"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},{"$f":"maaiveld-$F$16+Y22","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},null,null,"OF factor = 1 + x *0.05 ",null,null,null,"17","zeer fijn zand (zuiver)","17 zeer fijn zand (zuiver)",6]
[null,"VOLLEDIG EN CONSINTENT:",{"$f":"IF(AND(C21=\"OK\",C22=\"OK\"),\"OK\",\"controleer input\")","v":"controleer input"},null,null,null,null,19,"",{"$error":"#VALUE!"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,"voor waarden van x<= 5",null,null,null,"18","matig fijn zand (kleiig)","18 matig fijn zand (kleiig)",3]
[null,"OUTPUT",null,null,null,null,null,20,"",{"$error":"#VALUE!"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,{"$f":"IF(verlaging>0,10^(LOG(r_equivalent)+H24*(LOG(r_stat)-LOG(r_equivalent))/20),\"\")","v":""},{"$error":"#VALUE!"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,null,null,null,"19","matig fijn zand (zwak kleiig)","19 matig fijn zand (zwak kleiig)",10]
[null,"SICHARD",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"20","matig fijn zand (zuiver)","20 matig fijn zand (zuiver)",15]
[null,"invloedstraal (Sichard)",{"$f":"IF(C23=\"OK\",IF(verlaging>0,3000*(doorlatendheid/3600/24)^0.5*(verlaging),\"\"),\"\")","v":""},"m",null,null,null,null,"afstanden volgens log x = log r_equivalent + i * ( log(r invloedstraal) -log(r equivalent)/20",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"21","matig grof zand (kleiig)","21 matig grof zand (kleiig)",5]
[null,"Debiet bij begin (Sichard)",{"$f":"(PI()*doorlatendheid*(rustpeil^2-(rustpeil-verlaging)^2))/(LN(r_sichard+r_equivalent)-LN(r_equivalent))/24","v":{"$error":"#N/A"}},"m³/u","-->",{"$f":"C27*24","v":{"$error":"#N/A"}},"m³/d",null,"met i van 0 tot 20",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"22","matig grof zand (zwak kleiig)","22 matig grof zand (zwak kleiig)",20]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"23","matig grof zand (zuiver)","23 matig grof zand (zuiver)",30]
[null,"STATIONAIR volgens DUPUIT",null,null,null,null,null,null,"Betekenins (invloed)stralen in de berekeningen:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"24","zeer grof zand (kleiig)","24 zeer grof zand (kleiig)",10]
[null,"Debiet stationair",{"$f":"(PI()*doorlatendheid*(rustpeil^2-(rustpeil-verlaging)^2))/(LN(r_stat)-LN(r_equivalent))/24","v":{"$error":"#N/A"}},"m³/u","-->",{"$f":"C30*24","v":{"$error":"#N/A"}},"m³/d",null,null,null,"berekening invloedstraal Dupuit / Verruijt: vanaf centrum bouwput",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"25","zeer grof zand (zwak kleiig)","25 zeer grof zand (zwak kleiig)",35]
[null,"invloedstraat stationair",{"$f":"IF(ISNUMBER(q_stat),(q_stat/(voeding_m3_u*PI()))^0.5,r_equivalent+r_sichard)","v":{"$error":"#VALUE!"}},"m",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"26","zeer grof zand (zuiver)","26 zeer grof zand (zuiver)",55]
[null,"invloedstraal verlaging 5 cm",{"$f":"r_stat*EXP(-PI()*doorlatendheid*(rustpeil^2-(rustpeil-verlaging_x)^2)/q_stat/24)","v":{"$error":"#VALUE!"}},"m",null,null,null,null,null,null,"r equivalent","brekende invloedstraal Sichardt: vanaf rand/r equivalent",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"27","uiterst grof zand (kleiig)","27 uiterst grof zand (kleiig)",50]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"28","uiterst grof zand (zwak kleiig)","28 uiterst grof zand (zwak kleiig)",150]
[null,"STATIONAIR volgens VERRUIJT",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"29","uiterst grof zand (zuiver)","29 uiterst grof zand (zuiver)",250]
[null,"Debiet stationair",{"$f":"IF(ISNUMBER(q_stat_veruijt),((rustpeil-verlaging)^2-rustpeil^2+voeding_m3_u*24/(2*doorlatendheid)*(r_equivalent^2-r_stat_veruijt^2))*PI()*doorlatendheid/LN(r_equivalent/r_stat_veruijt)/24,100)","v":100},"m³/u","-->",{"$f":"C35*24","v":2400},"m³/d",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"30","teelaarde","30 teelaarde",5]
[null,"invloedstraat stationair",{"$f":"IF(ISNUMBER(q_stat_veruijt),(q_stat_veruijt/(voeding_m3_u*PI()))^0.5,100)","v":1180.761322827354},"m",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"31","schelpen","31 schelpen",30]
[null,"invloedstraal verlaging 5 cm",{"$f":"C54","v":100},"m",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"32","duinzand","32 duinzand",7]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"33","grof zand","33 grof zand",30]
[null,{"$f":"CONCATENATE(\"Onvolkomen debiet (* toeslagfactor \",C19, \")\")","v":"Onvolkomen debiet (* toeslagfactor 1)"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"34","zeer grof zand","34 zeer grof zand",80]
[null,"bij begin (Sichard)",{"$f":"q_sichard*C19","v":{"$error":"#N/A"}},"m³/u","-->",{"$f":"C40*24","v":{"$error":"#N/A"}},"m³/d",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"35","uiterst grof zand","35 uiterst grof zand",200]
[null,"DUPUIT stationair",{"$f":"q_stat*C19","v":{"$error":"#N/A"}},"m³/u","-->",{"$f":"C41*24","v":{"$error":"#N/A"}},"m³/d",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"36","fijn grind","36 fijn grind",1000,"1.000 - 10.000"]
[null,"VERRUIJT stationair",{"$f":"q_stat_veruijt*toeslagfactor","v":100},"m³/u","-->",{"$f":"C42*24","v":2400},"m³/d",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"37","grof grind","37 grof grind",10000,"10.000 - 100.000"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"38"]
[null,"Controle itteratieberekening: ","Q volgens r","r volgens Q"]
[null,{"$f":"IF(AND(ABS(Berekening!C45-q_stat)<0.1,ABS(Berekening!D45-r_stat)<1),\"OK\",\"iteratieve berekening niet correct\")","v":{"$error":"#VALUE!"}},{"$f":"r_stat^2*PI()*voeding_m3_u","v":{"$error":"#VALUE!"}},{"$f":"IF(q_stat>0,(C30/(voeding_m3_u*PI()))^0.5,0)","v":{"$error":"#N/A"}},"Dupuit",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bron: Grondwaterzakboekje 2016, Bram Bot"]
[null,{"$f":"IF(AND(C46-q_stat_veruijt<0.1,D46-r_stat_veruijt<1),\"OK\",\"iteratieve berekening niet correct\")","v":{"$error":"#N/A"}},{"$f":"r_stat_veruijt^2*PI()*voeding_m3_u","v":99.999999999999972},{"$f":"(q_stat_veruijt/(voeding_m3_u*PI()))^0.5","v":1180.761322827354},"Verruit"]
[null,null,null,null,null,null,null,null,null,"afstand tot rand bemaling (m)","afstand tot centrum bemaling (m)","h (verzadigde dikte)","h (mTAW)","s (m)","Peil (m-mv)"]
[null,null,null,null,null,null,null,null,"gekozen afstand:",{"$f":"IF(ISBLANK('INPUT -OUTPUT'!K26),\"\",IF('INPUT -OUTPUT'!L26=\"m tot rand bemaling\",'INPUT -OUTPUT'!K26,'INPUT -OUTPUT'!K26-r_equivalent))","v":""},{"$f":"IF(ISBLANK('INPUT -OUTPUT'!K26),\"\",J48+r_equivalent)","v":""},{"$f":"IF(input_ok=\"OK\",IF(J48>r_sichard,\"\",(rustpeil^2-(q_sichard*24*(LN(r_equivalent+r_sichard)-LN(J48+r_equivalent))/(PI()*doorlatendheid)))^0.5),\"\")","v":""},{"$f":"IF(input_ok=\"OK\",IF(J48>r_sichard,\"\",maaiveld-$F$16+L48),\"\")","v":""},{"$f":"IF(input_ok=\"OK\",IF(J48>r_sichard,\"\",rustpeil-L48),\"\")","v":""},{"$f":"IF(input_ok=\"OK\",IF(J48>r_sichard,\"\",maaiveld-M48),\"\")","v":""},{"$f":"IF(input_ok=\"OK\",IF(J48=\"\",\"\",IF(J48>r_sichard,\"afstand buiten invloedstraal volgens SICHARD\",\"bij begin van de bemalingsduur SICHARD\")),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(input_ok=\"OK\",IF(K48>r_stat,\"\",(rustpeil^2-(q_stat*24*(LN(r_stat)-LN(J48+r_equivalent))/(PI()*doorlatendheid)))^0.5),\"\")","v":""},{"$f":"IF(input_ok=\"OK\",IF(K48>r_stat,\"\",maaiveld-$F$16+L49),\"\")","v":""},{"$f":"IF(input_ok=\"OK\",IF(K48>r_stat,\"\",rustpeil-L49),\"\")","v":""},{"$f":"IF(input_ok=\"OK\",IF(K48>r_stat,\"\",maaiveld-M49),\"\")","v":""},{"$f":"IF(input_ok=\"OK\",IF(J48=\"\",\"\",IF(K48>r_stat,\"afstand buiten invloedstraal volgens DUPUIT\",\"stationair volgens DUPUIT\")),\"\")","v":""}]
[null,"Berekening afstand tot een beplaalde verlaging X m volgens verruijt:",null,null,null,null,null,null,null,null,null,{"$f":"IF(input_ok=\"OK\",IF(K48>r_stat_veruijt,\"\",(rustpeil^2+(q_stat_veruijt*24*(LN((J48+r_equivalent)/(r_stat_veruijt))/(PI()*doorlatendheid))+(voeding_m3_u*24/(2*doorlatendheid)*((r_stat_veruijt)^2-(J48+r_equivalent)^2))))^0.5),\"\")","v":""},{"$f":"IF(input_ok=\"OK\",IF(K48>r_stat_veruijt,\"\",maaiveld-$F$16+L50),\"\")","v":""},{"$f":"IF(input_ok=\"OK\",IF(K48>r_stat_veruijt,\"\",rustpeil-L50),\"\")","v":""},{"$f":"IF(input_ok=\"OK\",IF(K48>r_stat_veruijt,\"\",maaiveld-M50),\"\")","v":""},{"$f":"IF(input_ok=\"OK\",IF(J48=\"\",\"\",IF(K48>r_stat_veruijt,\"afstand buiten invloedstraal volgens VERRUIJT\",\"stationair volgens VERRUIJT\")),\"\")","v":""}]
[null,"verlaging waarvoor afstand wordt gezocht:",null,0.05,"m"]
[null,{"$f":"CONCATENATE(\"itteratieve berekening voor een verlaging van \",D51*100, \"cm volgen Verruijt\")","v":"itteratieve berekening voor een verlaging van 5cm volgen Verruijt"}]
[null,"stap 1",{"$f":"(voeding_m3_u/2*C54^2+doorlatendheid/24*((rustpeil-verlaging_x)^2-rustpeil^2)-voeding_m3_u/2*r_stat_veruijt^2+q_stat_veruijt/PI()*LN(r_stat_veruijt))/q_stat_veruijt*PI()","v":{"$error":"#N/A"}}]
[null,"stap 2",{"$f":"IF(ISNUMBER(C53),EXP(C53),100)","v":100},"m"]
[]
[]
[]
[]
[]
[null,null,null,"m"]

{"sheet":"transport berekening","index":4,"n_rows":419,"n_cols":22,"rows_kept":419,"cut":false,"hidden":false,"merged":[]}
[]
[]
["INPUT",null,"afstand tot rand bemaling (m)","afstand tot centrum bemaling (m)"]
[null,"verontreiniging op",{"$f":"IF(ISBLANK('INPUT -OUTPUT'!K22),\"\",IF('INPUT -OUTPUT'!L22=\"m tot rand bemaling\",'INPUT -OUTPUT'!K22,'INPUT -OUTPUT'!K22-r_equivalent))","v":""},{"$f":"IF(ISBLANK('INPUT -OUTPUT'!K22),\"\",C4+r_equivalent)","v":""},null,"effectieve porositeit",{"$f":"'INPUT -OUTPUT'!K23","v":0},"retardatiefactor",{"$f":"'INPUT -OUTPUT'!K24","v":0}]
[]
["OUTPUT"]
[]
[]
[]
["Resultaat volgens DUPUIT",null,null,null,null,null,null,null,null,null,null,null,"Resultaat volgens VERRUIJT"]
[{"$f":"CONCATENATE(\"Verplaatsing na \", duur,\" dagen (in m)\")","v":"Verplaatsing na ONWAAR dagen (in m)"},null,null,{"$f":"ROUND(VLOOKUP(duur,B18:J418,9),2)","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"Verplaatsing na \", duur,\" dagen (in m)\")","v":"Verplaatsing na ONWAAR dagen (in m)"},null,null,{"$f":"ROUND(VLOOKUP(duur,M18:U418,9),2)","v":{"$error":"#N/A"}}]
["Verontreiniging bereikt bemaling na",null,null,{"$f":"IF(SUM(K18:K418)<duur,SUM(K18:K418),\"\")","v":{"$error":"#VALUE!"}},"dagen",null,null,null,null,null,null,null,"Verontreiniging bereikt bemaling na",null,null,{"$f":"IF(SUM(V18:V418)<duur,SUM(V18:V418),\"\")","v":{"$error":"#VALUE!"}},"dagen"]
[{"$f":"IF(D4>r_stat,\"afstand buiten de invloedstraal\",\"\")","v":{"$error":"#VALUE!"}},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(D4>r_stat_veruijt,\"afstand buiten de invloedstraal\",\"\")","v":"afstand buiten de invloedstraal"}]
[]
["BEREKENING GRADIENT VOLGENS DUPUIT",null,null,null,null,null,null,null,null,null,null,null,"BEREKENING GRADIENT VOLGENS VERRUIJT"]
[null,"tijd (dag)","afstand 1","peil 1 ","afstand 2","peil 2","gradient","snelheid (m/d) conservatief","verplaatsing op deze dag met retardatie","totale verplaatsing na t dagen in m","dagteller voordat verontreiniging in bemaling komt",null,"tijd (dag)","afstand 1","peil 1 ","afstand 2","peil 2","gradient","snelheid (m/d) conservatief","verplaatsing per op deze dag met retardatie","totale verplaatsing na t dagen in m","dagteller voordat verontreiniging in bemaling komt"]
[null,0,{"$f":"IF($D$4<r_stat,C18+0.1,\"\")","v":{"$error":"#VALUE!"}},{"$f":"IF(AND(B17<=duur,C17>r_equivalent),(rustpeil^2-(q_stat*24*(LN(r_stat)-LN(C17))/(PI()*doorlatendheid)))^0.5,\"\")","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"IF(ISNUMBER(G17),G17*doorlatendheid/$G$4,\"\")","v":""},null,0,null,null,0,{"$f":"IF($D$4<r_stat_veruijt,C18+0.1,\"\")","v":""},{"$f":"IF(AND(M17<=duur,N17>r_equivalent),(rustpeil^2+(q_stat_veruijt*24*(LN((N17)/(r_stat_veruijt))/(PI()*doorlatendheid))+(voeding_m3_u*24/(2*doorlatendheid)*((r_stat_veruijt)^2-(N17)^2))))^0.5,\"\")","v":""},null,null,null,null,null,0]
[null,{"$f":"IF(ISNUMBER(B17),IF(AND(B17<duur,$D$4-J17>r_equivalent),B17+1,\"\"),\"\")","v":{"$error":"#VALUE!"}},{"$f":"IF(B18<=duur,$D$4,\"\")","v":{"$error":"#VALUE!"}},{"$f":"IF(B18<=duur,(rustpeil^2-(q_stat*24*(LN(r_stat)-LN(C18))/(PI()*doorlatendheid)))^0.5,\"\")","v":{"$error":"#VALUE!"}},{"$f":"IF(B18<>\"\",C17,\"\")","v":{"$error":"#VALUE!"}},{"$f":"IF(B18<>\"\",D17,\"\")","v":{"$error":"#VALUE!"}},{"$f":"IFERROR((F18-D18)/(E18-C18),\"\")","v":""},"",{"$f":"IF(B18<>\"\",H18/$I$4,\"\")","v":{"$error":"#VALUE!"}},{"$f":"IF(ISNUMBER(I18),MIN($D$4-r_equivalent,J17+I18),\"\")","v":""},{"$f":"IF(B18<>\"\",1,0)","v":{"$error":"#VALUE!"}},null,{"$f":"IF(ISNUMBER(M17),IF(AND(M17<duur,$D$4-U17>r_equivalent),M17+1,\"\"),\"\")","v":{"$error":"#VALUE!"}},{"$f":"IF(M18<=duur,$D$4,\"\")","v":{"$error":"#VALUE!"}},{"$f":"IF(M18<=duur,(rustpeil^2+(q_stat_veruijt*24*(LN((N18)/(r_stat_veruijt))/(PI()*doorlatendheid))+(voeding_m3_u*24/(2*doorlatendheid)*((r_stat_veruijt)^2-(N18)^2))))^0.5,\"\")","v":{"$error":"#VALUE!"}},{"$f":"IF(M18<>\"\",N17,\"\")","v":{"$error":"#VALUE!"}},{"$f":"IF(M18<>\"\",O17,\"\")","v":{"$error":"#VALUE!"}},{"$f":"IFERROR((Q18-O18)/(P18-N18),0)","v":0},{"$f":"R18*doorlatendheid/$G$4","v":{"$error":"#N/A"}},{"$f":"IF(M18<>\"\",S18/$I$4,\"\")","v":{"$error":"#VALUE!"}},{"$f":"IF(ISNUMBER(T18),MIN($D$4-r_equivalent,U17+T18),\"\")","v":""},{"$f":"IF(M18<>\"\",1,0)","v":{"$error":"#VALUE!"}}]
[null,"",{"$f":"IF(B19<=duur,C18-I18,\"\")","v":{"$error":"#VALUE!"}},{"$error":"#N/A"},"",{"$f":"IF(B19<>\"\",D18,\"\")","v":""},"","",{"$f":"IF(B19<>\"\",H19/$I$4,\"\")","v":""},{"$f":"IF(ISNUMBER(I19),MIN($D$4-r_equivalent,J18+I19),\"\")","v":""},0,null,"",{"$f":"IF(M19<=duur,N18-T18,\"\")","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},"",{"$f":"IF(M19<>\"\",O18,\"\")","v":""},{"$f":"IFERROR((Q19-O19)/(P19-N19),\"\")","v":""},{"$f":"IF(ISNUMBER(R19),R19*doorlatendheid/$G$4,\"\")","v":""},{"$f":"IF(M19<>\"\",S19/$I$4,\"\")","v":""},{"$f":"IF(ISNUMBER(T19),MIN($D$4-r_equivalent,U18+T19),\"\")","v":""},0]
[null,"",{"$f":"IF(B20<=duur,C19-I19,\"\")","v":{"$error":"#VALUE!"}},{"$error":"#N/A"},"","","","","",{"$f":"IF(ISNUMBER(I20),MIN($D$4-r_equivalent,J19+I20),\"\")","v":""},0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","",{"$f":"IF(ISNUMBER(T20),MIN($D$4-r_equivalent,U19+T20),\"\")","v":""},0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$f":"IF(M39<=duur,MAX(r_equivalent,N38-T38),\"\")","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},{"$f":"IF(B41<>\"\",C40,\"\")","v":""},"","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},{"$f":"IF(B42<>\"\",C41,\"\")","v":""},"","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","",{"$f":"IF(ISNUMBER(G81),G81*doorlatendheid/$G$4,\"\")","v":""},"","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,{"$f":"IF(ISNUMBER(B81),IF(AND(B81<duur,$D$4-J81>r_equivalent),B81+1,\"\"),\"\")","v":""},{"$error":"#VALUE!"},{"$f":"IF(B82<=duur,(rustpeil^2-(q_stat*24*(LN(r_stat)-LN(C82))/(PI()*doorlatendheid)))^0.5,\"\")","v":{"$error":"#N/A"}},"","",{"$f":"IFERROR((F82-D82)/(E82-C82),\"\")","v":""},"","","",{"$f":"IF(B82<>\"\",1,0)","v":0},null,{"$f":"IF(ISNUMBER(M81),IF(AND(M81<duur,$D$4-U81>r_equivalent),M81+1,\"\"),\"\")","v":""},{"$error":"#VALUE!"},{"$f":"IF(M82<=duur,(rustpeil^2+(q_stat_veruijt*24*(LN((N82)/(r_stat_veruijt))/(PI()*doorlatendheid))+(voeding_m3_u*24/(2*doorlatendheid)*((r_stat_veruijt)^2-(N82)^2))))^0.5,\"\")","v":{"$error":"#VALUE!"}},{"$f":"IF(M82<>\"\",N81,\"\")","v":""},"","","","","",0]
[null,"",{"$f":"IF(B83<=duur,C82-I82,\"\")","v":{"$error":"#VALUE!"}},{"$error":"#N/A"},"",{"$f":"IF(B83<>\"\",D82,\"\")","v":""},"","",{"$f":"IF(B83<>\"\",H83/$I$4,\"\")","v":""},{"$f":"IF(ISNUMBER(I83),MIN($D$4-r_equivalent,J82+I83),\"\")","v":""},0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",{"$f":"IF(M83<>\"\",O82,\"\")","v":""},{"$f":"IFERROR((Q83-O83)/(P83-N83),\"\")","v":""},{"$f":"IF(ISNUMBER(R83),R83*doorlatendheid/$G$4,\"\")","v":""},{"$f":"IF(M83<>\"\",S83/$I$4,\"\")","v":""},{"$f":"IF(ISNUMBER(T83),MIN($D$4-r_equivalent,U82+T83),\"\")","v":""},{"$f":"IF(M83<>\"\",1,0)","v":0}]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$f":"IF(M103<=duur,MAX(r_equivalent,N102-T102),\"\")","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},{"$f":"IF(B106<>\"\",C105,\"\")","v":""},"","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","",{"$f":"IF(ISNUMBER(G145),G145*doorlatendheid/$G$4,\"\")","v":""},"","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,{"$f":"IF(ISNUMBER(B145),IF(AND(B145<duur,$D$4-J145>r_equivalent),B145+1,\"\"),\"\")","v":""},{"$error":"#VALUE!"},{"$f":"IF(B146<=duur,(rustpeil^2-(q_stat*24*(LN(r_stat)-LN(C146))/(PI()*doorlatendheid)))^0.5,\"\")","v":{"$error":"#N/A"}},"","",{"$f":"IFERROR((F146-D146)/(E146-C146),\"\")","v":""},"","","",{"$f":"IF(B146<>\"\",1,0)","v":0},null,{"$f":"IF(ISNUMBER(M145),IF(AND(M145<duur,$D$4-U145>r_equivalent),M145+1,\"\"),\"\")","v":""},{"$error":"#VALUE!"},{"$f":"IF(M146<=duur,(rustpeil^2+(q_stat_veruijt*24*(LN((N146)/(r_stat_veruijt))/(PI()*doorlatendheid))+(voeding_m3_u*24/(2*doorlatendheid)*((r_stat_veruijt)^2-(N146)^2))))^0.5,\"\")","v":{"$error":"#VALUE!"}},{"$f":"IF(M146<>\"\",N145,\"\")","v":""},"","","","","",0]
[null,"",{"$f":"IF(B147<=duur,C146-I146,\"\")","v":{"$error":"#VALUE!"}},{"$error":"#N/A"},"",{"$f":"IF(B147<>\"\",D146,\"\")","v":""},"","",{"$f":"IF(B147<>\"\",H147/$I$4,\"\")","v":""},{"$f":"IF(ISNUMBER(I147),MIN($D$4-r_equivalent,J146+I147),\"\")","v":""},0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",{"$f":"IF(M147<>\"\",O146,\"\")","v":""},{"$f":"IFERROR((Q147-O147)/(P147-N147),\"\")","v":""},{"$f":"IF(ISNUMBER(R147),R147*doorlatendheid/$G$4,\"\")","v":""},{"$f":"IF(M147<>\"\",S147/$I$4,\"\")","v":""},{"$f":"IF(ISNUMBER(T147),MIN($D$4-r_equivalent,U146+T147),\"\")","v":""},{"$f":"IF(M147<>\"\",1,0)","v":0}]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",{"$f":"IF(B159<>\"\",1,0)","v":0},null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","",{"$f":"IFERROR((F160-D160)/(E160-C160),\"\")","v":""},"","","",{"$f":"IF(B160<>\"\",1,0)","v":0},null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","",{"$f":"IFERROR((F161-D161)/(E161-C161),\"\")","v":""},"","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$f":"IF(M167<=duur,MAX(r_equivalent,N166-T166),\"\")","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},{"$f":"IF(B170<>\"\",C169,\"\")","v":""},"","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","",{"$f":"IF(ISNUMBER(G209),G209*doorlatendheid/$G$4,\"\")","v":""},"","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,{"$f":"IF(ISNUMBER(B209),IF(AND(B209<duur,$D$4-J209>r_equivalent),B209+1,\"\"),\"\")","v":""},{"$error":"#VALUE!"},{"$f":"IF(B210<=duur,(rustpeil^2-(q_stat*24*(LN(r_stat)-LN(C210))/(PI()*doorlatendheid)))^0.5,\"\")","v":{"$error":"#N/A"}},"","","","","","",0,null,{"$f":"IF(ISNUMBER(M209),IF(AND(M209<duur,$D$4-U209>r_equivalent),M209+1,\"\"),\"\")","v":""},{"$error":"#VALUE!"},{"$f":"IF(M210<=duur,(rustpeil^2+(q_stat_veruijt*24*(LN((N210)/(r_stat_veruijt))/(PI()*doorlatendheid))+(voeding_m3_u*24/(2*doorlatendheid)*((r_stat_veruijt)^2-(N210)^2))))^0.5,\"\")","v":{"$error":"#VALUE!"}},{"$f":"IF(M210<>\"\",N209,\"\")","v":""},"","","","","",0]
[null,"",{"$f":"IF(B211<=duur,C210-I210,\"\")","v":{"$error":"#VALUE!"}},{"$error":"#N/A"},"",{"$f":"IF(B211<>\"\",D210,\"\")","v":""},"","",{"$f":"IF(B211<>\"\",H211/$I$4,\"\")","v":""},{"$f":"IF(ISNUMBER(I211),MIN($D$4-r_equivalent,J210+I211),\"\")","v":""},0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",{"$f":"IF(M211<>\"\",O210,\"\")","v":""},{"$f":"IFERROR((Q211-O211)/(P211-N211),\"\")","v":""},{"$f":"IF(ISNUMBER(R211),R211*doorlatendheid/$G$4,\"\")","v":""},{"$f":"IF(M211<>\"\",S211/$I$4,\"\")","v":""},{"$f":"IF(ISNUMBER(T211),MIN($D$4-r_equivalent,U210+T211),\"\")","v":""},{"$f":"IF(M211<>\"\",1,0)","v":0}]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$f":"IFERROR((Q218-O218)/(P218-N218),\"\")","v":""},"","","",{"$f":"IF(M218<>\"\",1,0)","v":0}]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$f":"IFERROR((Q219-O219)/(P219-N219),\"\")","v":""},"","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",{"$f":"IF(B224<>\"\",1,0)","v":0},null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","",{"$f":"IFERROR((F225-D225)/(E225-C225),\"\")","v":""},"","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$f":"IF(M231<=duur,MAX(r_equivalent,N230-T230),\"\")","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},{"$f":"IF(B234<>\"\",C233,\"\")","v":""},"","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","",{"$f":"IF(ISNUMBER(G273),G273*doorlatendheid/$G$4,\"\")","v":""},"","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,{"$f":"IF(ISNUMBER(B273),IF(AND(B273<duur,$D$4-J273>r_equivalent),B273+1,\"\"),\"\")","v":""},{"$error":"#VALUE!"},{"$f":"IF(B274<=duur,(rustpeil^2-(q_stat*24*(LN(r_stat)-LN(C274))/(PI()*doorlatendheid)))^0.5,\"\")","v":{"$error":"#N/A"}},"","","","","","",0,null,{"$f":"IF(ISNUMBER(M273),IF(AND(M273<duur,$D$4-U273>r_equivalent),M273+1,\"\"),\"\")","v":""},{"$error":"#VALUE!"},{"$f":"IF(M274<=duur,(rustpeil^2+(q_stat_veruijt*24*(LN((N274)/(r_stat_veruijt))/(PI()*doorlatendheid))+(voeding_m3_u*24/(2*doorlatendheid)*((r_stat_veruijt)^2-(N274)^2))))^0.5,\"\")","v":{"$error":"#VALUE!"}},{"$f":"IF(M274<>\"\",N273,\"\")","v":""},"","","","","",0]
[null,"",{"$f":"IF(B275<=duur,C274-I274,\"\")","v":{"$error":"#VALUE!"}},{"$error":"#N/A"},"",{"$f":"IF(B275<>\"\",D274,\"\")","v":""},"","",{"$f":"IF(B275<>\"\",H275/$I$4,\"\")","v":""},{"$f":"IF(ISNUMBER(I275),MIN($D$4-r_equivalent,J274+I275),\"\")","v":""},0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",{"$f":"IF(M275<>\"\",O274,\"\")","v":""},"",{"$f":"IF(ISNUMBER(R275),R275*doorlatendheid/$G$4,\"\")","v":""},{"$f":"IF(M275<>\"\",S275/$I$4,\"\")","v":""},{"$f":"IF(ISNUMBER(T275),MIN($D$4-r_equivalent,U274+T275),\"\")","v":""},0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",{"$f":"IF(M282<>\"\",1,0)","v":0}]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$f":"IFERROR((Q283-O283)/(P283-N283),\"\")","v":""},"","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",{"$f":"IF(B288<>\"\",1,0)","v":0},null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","",{"$f":"IFERROR((F289-D289)/(E289-C289),\"\")","v":""},"","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$f":"IF(M295<=duur,MAX(r_equivalent,N294-T294),\"\")","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},{"$f":"IF(B298<>\"\",C297,\"\")","v":""},"","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","",{"$f":"IF(ISNUMBER(G337),G337*doorlatendheid/$G$4,\"\")","v":""},"","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,{"$f":"IF(ISNUMBER(B337),IF(AND(B337<duur,$D$4-J337>r_equivalent),B337+1,\"\"),\"\")","v":""},{"$error":"#VALUE!"},{"$f":"IF(B338<=duur,(rustpeil^2-(q_stat*24*(LN(r_stat)-LN(C338))/(PI()*doorlatendheid)))^0.5,\"\")","v":{"$error":"#N/A"}},"","","","","","",0,null,{"$f":"IF(ISNUMBER(M337),IF(AND(M337<duur,$D$4-U337>r_equivalent),M337+1,\"\"),\"\")","v":""},{"$error":"#VALUE!"},{"$f":"IF(M338<=duur,(rustpeil^2+(q_stat_veruijt*24*(LN((N338)/(r_stat_veruijt))/(PI()*doorlatendheid))+(voeding_m3_u*24/(2*doorlatendheid)*((r_stat_veruijt)^2-(N338)^2))))^0.5,\"\")","v":{"$error":"#VALUE!"}},{"$f":"IF(M338<>\"\",N337,\"\")","v":""},"","","","","",0]
[null,"",{"$f":"IF(B339<=duur,C338-I338,\"\")","v":{"$error":"#VALUE!"}},{"$error":"#N/A"},"",{"$f":"IF(B339<>\"\",D338,\"\")","v":""},"","",{"$f":"IF(B339<>\"\",H339/$I$4,\"\")","v":""},{"$f":"IF(ISNUMBER(I339),MIN($D$4-r_equivalent,J338+I339),\"\")","v":""},0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",{"$f":"IF(M339<>\"\",O338,\"\")","v":""},"",{"$f":"IF(ISNUMBER(R339),R339*doorlatendheid/$G$4,\"\")","v":""},{"$f":"IF(M339<>\"\",S339/$I$4,\"\")","v":""},{"$f":"IF(ISNUMBER(T339),MIN($D$4-r_equivalent,U338+T339),\"\")","v":""},0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",{"$f":"IF(M346<>\"\",1,0)","v":0}]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$f":"IFERROR((Q347-O347)/(P347-N347),\"\")","v":""},"","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",{"$f":"IF(B352<>\"\",1,0)","v":0},null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","",{"$f":"IFERROR((F353-D353)/(E353-C353),\"\")","v":""},"","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$f":"IF(M359<=duur,MAX(r_equivalent,N358-T358),\"\")","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},{"$f":"IF(B362<>\"\",C361,\"\")","v":""},"","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","",{"$f":"IF(ISNUMBER(G401),G401*doorlatendheid/$G$4,\"\")","v":""},"","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,{"$f":"IF(ISNUMBER(B401),IF(AND(B401<duur,$D$4-J401>r_equivalent),B401+1,\"\"),\"\")","v":""},{"$error":"#VALUE!"},{"$f":"IF(B402<=duur,(rustpeil^2-(q_stat*24*(LN(r_stat)-LN(C402))/(PI()*doorlatendheid)))^0.5,\"\")","v":{"$error":"#N/A"}},"","","","","","",0,null,{"$f":"IF(ISNUMBER(M401),IF(AND(M401<duur,$D$4-U401>r_equivalent),M401+1,\"\"),\"\")","v":""},{"$error":"#VALUE!"},{"$f":"IF(M402<=duur,(rustpeil^2+(q_stat_veruijt*24*(LN((N402)/(r_stat_veruijt))/(PI()*doorlatendheid))+(voeding_m3_u*24/(2*doorlatendheid)*((r_stat_veruijt)^2-(N402)^2))))^0.5,\"\")","v":{"$error":"#VALUE!"}},{"$f":"IF(M402<>\"\",N401,\"\")","v":""},"","","","","",0]
[null,"",{"$f":"IF(B403<=duur,C402-I402,\"\")","v":{"$error":"#VALUE!"}},{"$error":"#N/A"},"",{"$f":"IF(B403<>\"\",D402,\"\")","v":""},"","",{"$f":"IF(B403<>\"\",H403/$I$4,\"\")","v":""},{"$f":"IF(ISNUMBER(I403),MIN($D$4-r_equivalent,J402+I403),\"\")","v":""},0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",{"$f":"IF(M403<>\"\",O402,\"\")","v":""},"",{"$f":"IF(ISNUMBER(R403),R403*doorlatendheid/$G$4,\"\")","v":""},{"$f":"IF(M403<>\"\",S403/$I$4,\"\")","v":""},{"$f":"IF(ISNUMBER(T403),MIN($D$4-r_equivalent,U402+T403),\"\")","v":""},0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",{"$f":"IF(M410<>\"\",1,0)","v":0}]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$f":"IFERROR((Q411-O411)/(P411-N411),\"\")","v":""},"","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",{"$f":"IF(B416<>\"\",1,0)","v":0},null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","",{"$f":"IFERROR((F417-D417)/(E417-C417),\"\")","v":""},"","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,"",{"$error":"#VALUE!"},{"$error":"#N/A"},"","","","","","",0,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","","","","","",0]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(K18:K418)","v":{"$error":"#VALUE!"}}]

{"sheet":"versies","index":5,"n_rows":36,"n_cols":2,"rows_kept":36,"cut":false,"hidden":false,"merged":[]}
["versies"]
["v0.1","v 0 = beta versie"]
["v0.2","macro igevoegd: bij openen workbook wordt iteraties automatisch ingeschakeld"]
[null,"test iteratie ingebouwd: debiet bevestigd invloedstraal en omgekeerd"]
[null,"voor doorlatendheid kan eenheid gekozen worden"]
["v0.3","fouten in de invoer worden opgevangen met foutmelding"]
[null,"alle referenties in de formules verwijzen naar cellen met een naam ipv celcoördinaat"]
[null,"input in figuur verwerkt in appart tablad, ook output dit appart tablad"]
[null,"mogelijkheid om sedimenttype te kiezen"]
["v0.4","berekening verbeterd: in de formules H: verzadigde dikte ipv tov 0 mTAW"]
["v0.5","toevoegen berekening volgens Veruijt (houd rekening met voeding in de berekening van de verlaging, toename van gradiënt dichter bij de put doordat er steeds meer voeding bijkomt naarmate men dichter bij de put komt)"]
[null,"duur van de bemaling toegevoegd --> totaal debiet overeenkomstig deze duur wordt berekend"]
[null,"mogelijkheid om peilen in mTAW of m-mv in te geven"]
[null,"berekening verbeterd: H beperkt tot filterdiepte (enkel horizontale stroming wordt beschouwd volgens DUPUIT en VERUIJT "]
[null,"automatisch bepalen van de toeslag onvolkomen bron"]
[null,"foutmeldingen worden getoond als onlogische combinaties worden ingevoerd"]
[null,"toevoegen transportberekening"]
[null,"alle input en output op eerste blad (ook transport verontreiging)"]
["v0.6 9/12/2019","rubriek en klasse zijn toegevoegd"]
[null,"waarschuwing als verontreiniging put bereikt: aantal dagen wordt vermeld"]
[null,"als verontreiniging put niet bereikt: afstand wordt vermeld"]
[null,"Als verontreiniging buiten invloedstraal: geen output"]
[null,"Waarschuwing indien MER drempels overschreden worden"]
["v0.7 24/03/2020","verruijt is toegevoegd aan transport berekening"]
["v0.8 06/04/2020","afstanden voor verlaging en verontreiniging kunnen tov rand of centrum bouwput ingegeven worden"]
[null,"alle berekeningen van verlaging gebeuren met afstand tot centrum"]
[null,"grafieken verontreiniging breken af waneer duur van de bemaling is bereikt of waneer verontreiniging in bemaling beland"]
[null,"berekening transport opgeschoond zodat lege cellen getoond worden ipv foutmeldingen "]
["v0.9 14/04/2020","fout in rubriekbepaling en klasse opgelost (debiet verwees naar stationair debiet over volledige duur ipc naar maximaal jaardebiet)"]
[null,"foutmelding bij onvolledig invullen. Geen resultaten en geen debieten of rubrieken bij onvolledig invullen"]
["v 0.10 10/06/2020","tabblad gevoeligheidsanalyse toegevoegd"]
[null,"enkel nog invloedstraal en verlagingscurve met verruijt berekend, klasse en rubriek bepaald volgens Verruijt zijn verwijderd"]
[null,"invloedstraal in output komt overeen met afstand met 5 cm verlaging"]
[null,"klasse bepaald met Verruijt verwijderd"]
["v 1.0 10/06/2020","Versie website VMM"]
[null,"Hadleiding in overeenstemming met deze versie"]