{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Vandgennemstrømning"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":0,"defined_names":24,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Vandgennemstrømning","index":0,"n_rows":133,"n_cols":36,"rows_kept":133,"cut":false,"hidden":false,"merged":[[34,22,34,24],[34,26,34,27],[35,4,35,5],[35,6,35,8],[35,11,35,12],[35,22,35,24],[35,26,35,27],[5,1,5,18],[36,4,36,5],[36,6,36,8],[31,6,31,8],[32,11,32,12],[36,11,36,12],[33,4,33,5],[33,6,33,8],[33,11,33,12],[34,4,34,5],[34,6,34,8],[34,11,34,12],[57,5,57,7],[7,10,7,13],[32,4,32,5],[32,6,32,8],[25,20,26,29],[36,22,36,24],[32,22,32,24],[32,26,32,27],[36,26,36,27],[38,7,38,12],[38,2,38,5],[31,11,31,13],[43,22,43,23],[40,22,40,23],[33,22,33,24],[33,26,33,27]]}
[]
[null,"Dette regneark er et støtteværktøj til \"Kvantificering af fosfortab fra N og P vådområder\" version oktober 2013. De anvedte henvisninger til afnsit er til afsnit i denne vejledning."]
[null,"Den nødvendige information intastes i de hvide felter og indgår jf. formlerne præsenteret i vejledningen i beregningene i de lyse farvede felter."]
[null,"Denne version er opdateret 26-06-2014"]
[]
[null,"Bestemmelse af vandstrømning gennem projektområdet (kapitel 3)"]
[]
[null,null,"Data om projektområdet"]
[]
[null,null,"Projektområdets areal",null,null,null,null,"ha"]
[null,null,"Direkte oplandsareal til projektområde",null,null,null,null,"ha","Bestemmes via GIS procedure jf. afsnit 3.4"]
[]
[null,null,"Årlig nedbør",null,null,null,null,"mm år-1","Gennemsnitlig årlig nedbør for 10-årig periode baseret på data fra DMI"]
[null,null,"Korrektion af nedbør for læforhold",null,null,null,null,null,"Kendes forholdene ikke, vælges moderat læ"]
[null,null,"Korrigeret årlig nedbør",null,null,null,{"$f":"IF(G14=\"\",\"\",IF(G14=\"Frit eksponeret\",G13*(100+F129)/100,IF(G14=\"Moderat læ\",G13*(100+F130)/100,IF(G14=\"Ideelt læ\",G13*(100+F131)/100))))","v":""},"mm år-1","Bestemt jf. bilag 2"]
[null,null,"Potentiel fordampning",null,null,null,null,"mm år-1","Gennemsnitlig årlig potentiel fordampning for 10-årig periode baseret på data fra DMI"]
[null,null,"Nettonedbør",null,null,null,{"$f":"IF(G16=\"\",\"\",nedbor-G16)","v":""},"mm år-1","Bestemt jf. afsnit 3.5"]
[]
[null,null,"Base flow index (BFI) og overfladenær strømning",null,null,null,null,null,null,null,null,null,null,"Simplificeret figur 3.3"]
[null,null,"BFI regnes på baggrund af karakteristika for området (jf. afsnit 3.3)"]
[]
[null,null,"Andel af sandjord (js)",null,null,null,null,"%","Bestemmes fra jordbundskort"]
[null,null,"Andelen af humusjord (j9)",null,null,null,null,"%","Bestemmes fra jordbundskort"]
[null,null,"Georegion",null,null,null,null,null,"Bestemmes fra figur 3.3 (mere detaljeret i vejledningen)"]
[null,null,"Beregnet BFI",null,null,null,{"$f":"IF(G24=\"\",\"\",IF(georegion=1,1.3152-0.862-0.0001957*Årlig_nedbør-0.005439*js-0.007967*j_9+0.01091*js,IF(georegion=2,1.3152-0.862-0.0001957*Årlig_nedbør-0.005439*js-0.007967*j_9+0.01091*js,IF(georegion=3,1.3152-0.1133-0.0001957*Årlig_nedbør-0.005439*js-0.007967*j_9+0.002806*js-0.02147*j_9,IF(georegion=4,1.3152-0.8509-0.0001957*Årlig_nedbør-0.005439*js-0.007967*j_9+0.01079*js,IF(georegion=5,1.3152-0.8509-0.0001957*Årlig_nedbør-0.005439*js-0.007967*j_9+0.01079*js,IF(georegion=6,1.3152-0.6359-0.0001957*Årlig_nedbør-0.005439*js-0.007967*j_9+0.007747*js+0.01963*j_9,IF(georegion=7,1.3152-0.6581-0.0001957*Årlig_nedbør-0.005439*js-0.007967*j_9+0.00715*js,IF(georegion=8,1.3152-0-0.0001957*Årlig_nedbør-0.005439*js-0.007967*j_9,IF(georegion=9,1.3152-0-0.0001957*Årlig_nedbør-0.005439*js-0.007967*j_9,999999))))))))))","v":""},null,"Bestemt jf. afsnit 3.3"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fosforbalance for projektområdet "]
[null,null,"Overfladenær strømning (QOF)",null,null,null,{"$f":"IF(G25=\"\",\"\",(1-BFI)*(netto_nedboer/1000)*(oplands_areal*10000))","v":""},"m3 år-1","(QOF = (1-BFI) * nettonedbør * oplandsareal)"]
[]
[null,null,"Bestemmelse af vandgennemstrømning (kapitel 3)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fosforfrigivelse fra projektområdet"]
[null,null,"Vandgennemstrømningen bestemmes for hvert prøvefelt. Beregningerne følger beskrivelsen i kapitel 3",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Frigivelsen beregnes ud fra proceduren beskrevet i kapitel 6 i vejledning."]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Tekstur og permeabilitet bestemmes vha. tabel 2.1"]
[null,null,"ID for prøvefelt","Areal af prøvefelt      (ha)","Type af område",null,"Prøvefeltes placering over vandløbets sommer-middelvandstand                                    (jf. afsnit 3.2)",null,null," QOF,areal  (afsnit 3.2)   (mm år-1)","Grundsvandsdybde                                         (m)","Tekstur",null,"Permeabilitet","Drænings-intensitet             (jf. afsnit 3.6)","Drænings-faktor","Faktor","Gennemstrømning (afsnit 3.2)                        (Qfelt;mm år-1)",null,null,null,"ID for prøvefelt","Vægt af ovntørret prøve                               (kg)",null,null,"Jordkernes længde                     (m)","Jordkernes radius          (m)",null,"Volumenvægt (ligning 6.3)        (kg m-3)","PBD (0-30 cm)                          (mg P kg tør jord-1)","FeBD (0-30 cm)                           (mg Fe kg tør jord-1)","FeBD:PBD (ligning 6.2) molforhold ","P-frigivelsesrate (ligning 6.1)               (kg P ha-1 mm-1)","Fosfor tab (kg P år-1)","PBD pulje (kg P ha-1)","PBD total                (kg P)"]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(E34=\"\",\"\",IF(E34=\"Permanent vådt\",Q_OF/(areal*10000)*1000,IF(AND(E34=\"Delvist vådt\",G34=\"<50\"),Q_OF/(areal*10000)*1000,IF(AND(E34=\"Delvist vådt\",G34=\">50\"),(Q_OF/(areal*10000))*1000*4/12,IF(E34=\"Tørt\",0,\"\")))))","v":""},null,null,null,null,null,{"$f":"IF(O34=\"\",\"\",IF(O34=\"Intensiv (>25%)\",1,IF(O34=\"Moderat (<25%)\",0.5,0)))","v":""},{"$f":"IF(O34=\"\",\"\",IF(N34+P34>1,1,N34+P34))","v":""},{"$f":"IF(P34=\"\",\"\",IF(J34=0,0,IF((J34*Q34)>netto_nedboer,J34*Q34,netto_nedboer)))","v":""},null,null,null,{"$f":"IF(C34=\"\",\"\",C34)","v":""},null,null,null,null,null,null,{"$f":"IF(AA34=\"\",\"\",W34/((PI()*AA34^2*Z34)))","v":""},null,null,{"$f":"IF(AE34=\"\",\"\",((AE34/1000)/Fe)/((AD34/1000)/P))","v":""},{"$f":"IF(AF34=\"\",\"\",(0.2384*(AF34^-0.878)))","v":""},{"$f":"IF(AG34=\"\",\"\",AG34*R34*D34)","v":""},{"$f":"IF(AD34=\"\",\"\",AC34*10000*0.3*AD34/1000^2)","v":""},{"$f":"IF(OR(AI34=\"\",AH34=0),\"\",AI34*D34)","v":""}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(E35=\"\",\"\",IF(E35=\"Permanent vådt\",Q_OF/(areal*10000)*1000,IF(AND(E35=\"Delvist vådt\",G35=\"<50\"),Q_OF/(areal*10000)*1000,IF(AND(E35=\"Delvist vådt\",G35=\">50\"),(Q_OF/(areal*10000))*1000*4/12,IF(E35=\"Tørt\",0,\"\")))))","v":""},null,null,null,null,null,{"$f":"IF(O35=\"\",\"\",IF(O35=\"Intensiv (>25%)\",1,IF(O35=\"Moderat (<25%)\",0.5,0)))","v":""},{"$f":"IF(O35=\"\",\"\",IF(N35+P35>1,1,N35+P35))","v":""},{"$f":"IF(P35=\"\",\"\",IF(J35=0,0,IF((J35*Q35)>netto_nedboer,J35*Q35,netto_nedboer)))","v":""},null,null,null,{"$f":"IF(C35=\"\",\"\",C35)","v":""},null,null,null,null,null,null,{"$f":"IF(AA35=\"\",\"\",W35/((PI()*AA35^2*Z35)))","v":""},null,null,"",{"$f":"IF(AF35=\"\",\"\",(0.2384*(AF35^-0.878)))","v":""},{"$f":"IF(AG35=\"\",\"\",AG35*R35*D35)","v":""},{"$f":"IF(AD35=\"\",\"\",AC35*10000*0.3*AD35/1000^2)","v":""},{"$f":"IF(OR(AI35=\"\",AH35=0),\"\",AI35*D35)","v":""}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(E36=\"\",\"\",IF(E36=\"Permanent vådt\",Q_OF/(areal*10000)*1000,IF(AND(E36=\"Delvist vådt\",G36=\"<50\"),Q_OF/(areal*10000)*1000,IF(AND(E36=\"Delvist vådt\",G36=\">50\"),(Q_OF/(areal*10000))*1000*4/12,IF(E36=\"Tørt\",0,\"\")))))","v":""},null,null,null,null,null,{"$f":"IF(O36=\"\",\"\",IF(O36=\"Intensiv (>25%)\",1,IF(O36=\"Moderat (<25%)\",0.5,0)))","v":""},{"$f":"IF(O36=\"\",\"\",IF(N36+P36>1,1,N36+P36))","v":""},{"$f":"IF(P36=\"\",\"\",IF(J36=0,0,IF((J36*Q36)>netto_nedboer,J36*Q36,netto_nedboer)))","v":""},null,null,null,{"$f":"IF(C36=\"\",\"\",C36)","v":""},null,null,null,null,null,null,{"$f":"IF(AA36=\"\",\"\",W36/((PI()*AA36^2*Z36)))","v":""},null,null,"",{"$f":"IF(AF36=\"\",\"\",(0.2384*(AF36^-0.878)))","v":""},{"$f":"IF(AG36=\"\",\"\",AG36*R36*D36)","v":""},{"$f":"IF(AD36=\"\",\"\",AC36*10000*0.3*AD36/1000^2)","v":""},""]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(E37=\"\",\"\",IF(E37=\"Permanent vådt\",Q_OF/(areal*10000)*1000,IF(AND(E37=\"Delvist vådt\",G37=\"<50\"),Q_OF/(areal*10000)*1000,IF(AND(E37=\"Delvist vådt\",G37=\">50\"),(Q_OF/(areal*10000))*1000*4/12,IF(E37=\"Tørt\",0,\"\")))))","v":""},null,null,null,null,null,{"$f":"IF(O37=\"\",\"\",IF(O37=\"Intensiv (>25%)\",1,IF(O37=\"Moderat (<25%)\",0.5,0)))","v":""},{"$f":"IF(O37=\"\",\"\",IF(N37+P37>1,1,N37+P37))","v":""},{"$f":"IF(P37=\"\",\"\",IF(J37=0,0,IF((J37*Q37)>netto_nedboer,J37*Q37,netto_nedboer)))","v":""},null,null,null,{"$f":"IF(C37=\"\",\"\",C37)","v":""},null,null,null,null,null,null,{"$f":"IF(AA37=\"\",\"\",W37/((PI()*AA37^2*Z37)))","v":""},null,null,{"$f":"IF(AE37=\"\",\"\",((AE37/1000)/Fe)/((AD37/1000)/P))","v":""},{"$f":"IF(AF37=\"\",\"\",(0.2384*(AF37^-0.878)))","v":""},{"$f":"IF(AG37=\"\",\"\",AG37*R37*D37)","v":""},{"$f":"IF(AD37=\"\",\"\",AC37*10000*0.3*AD37/1000^2)","v":""},""]
[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,"(areal*Qfelt*frigivelses rate)"]
[null,null,"Type af område",null,null,null,null,"Tabel til bestemmelse af permeabilitet (flere detaljer finde i afsnit 2.2 + 3.7)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Samlet fosfortab fra projektområdet"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AH34=\"\",\"\",SUM(AH34:AH37))","v":""},null,"kg år-1"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Samlet mobil fosfor (PBD) pulje i projektetområdet med risiko for fosfortab "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(AJ34:AJ37)","v":0},null,"kg"]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fosfortilbageholdelse ved sedimentation"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tilbageholdelsen beregnes ud fra proceduren beskrevet i kapitel 4 og 5 i vejledning, og er afhænger af typen af vådområde. Fosfor balancen er beregnet jf. kapitel 8."]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Type af projekt"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"A: Overrisling med drænvand"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"B: Oversvømmelse med vandløbsvand"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"C: Sødannelse"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"A: Overrisling (kapitel 4)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Drænet oplandsareal",null,null,null,null,"ha"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fosfortilbageholdelse",null,null,null,{"$f":"IF(Z57=\"\",\"\",0.062*Z57)","v":""},"kg P år-1",null,"beregnes ud fra en vejledende værdi på 0.062 kg ha-1 år-1"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fosforbalance",null,null,null,{"$f":"IF(Z57=\"\",\"\",Z58-Ptab)","v":""},"kg P år-1"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"B: Oversvømmelse (kapitel 5)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Vandløbstype"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1: Oplandsareal <10 km2, dog min. 2 km2"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2: Oplandsareal 10-100 km2"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"3: Oplandsareal >100 km2"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Der må maks. regnes sedimentation for et område op til",null,null,null,null,null,{"$f":"IF($Z$63=\"\",\"\",IF($Z$63=1,25,IF($Z$63=2,75,100)))","v":""},"meter fra vandløbet (oversvømmet areal)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Oversvømmet areal bestemmes efter kapitel 5 i vejledningen - manuel eller modelberegnet"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Manuelt beregnet oversvømmet areal"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Vandløbsstrækning",null,null,null,null,"m","Længde af vandløbsstrækning grænsende op til projektområdet"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bredde for sedimentationsområde",null,null,null,null,"m",{"$f":"IF(Z73>AB68,\"Større end den maksimale bredde for denne type vandløb\",\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Oversvømmet areal",null,null,null,{"$f":"IF(Z73=\"\",\"\",(Z72*Z73)/10000)","v":""},"ha"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Modelberegnet oversvømmet areal"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Modelberegnet oversvømmet areal",null,null,null,null,"ha"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Oversvømmelseshyppighed",null,null,null,null,"antal dage år-1"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Dage med oversvømmelse",null,null,null,null,"dage"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Forventet tab af partikelbundet fosfor fra oplandet (beregnes med lingning 2, kapitel 5)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Årsafstrømning",null,null,null,{"$f":"IF(Z63=\"\",\"\",nedbor)","v":""},"mm år-1"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Qflom",null,null,null,{"$f":"IF(Z83=\"\",\"\",(1-BFI)*Z83)","v":""},"mm år-1"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Andel sandjord i opland (S)",null,null,null,{"$f":"IF(Z83=\"\",\"\",js)","v":""},"%"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Andel landbrugsjord i opland (A)",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,"Hældning på vandløb (SL)",null,null,null,null,"‰ eller m/km"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Andel af eng/mose i opland (EM)",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,"Partikelbundet P (PP)",null,null,null,{"$f":"IF(Z88=\"\",\"\",1.09*EXP(-7.6634+0.9208*LN(Z84)+0.0229*Z86+0.0092*Z85+0.0187*Z87-0.0412*Z88))","v":""},"kg P ha-1 år-1"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fosfordeponeringsrate",null,null,null,{"$f":"IF(Z89=\"\",\"\",IF(Z89<0.14,0.5,IF(AND(Z89>=0.14,Z89<=0.36),1,1.5)))","v":""},"kg P oversvømmet ha-1 dag-1"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fosfordeponering",null,null,null,{"$f":"IF(Z90=\"\",\"\",IF(AND(Z74=\"\",Z77=\"\"),\"angiv areal\",IF(Z77=\"\",Z80*Z90*Z74,Z80*Z90*Z77)))","v":""},"kg P år-1"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fosforbalance",null,null,null,{"$f":"IF(Z88=\"\",\"\",Fosfordeponi-Ptab)","v":""},"kg P år-1"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"C: Sødannelse (kapitel 8)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"I søer er sammenhængen mellem tilbageholdelsen af fosfor og vandets opholdstid modelmæssigt beskrevet af bl.a. Vollenweider 1976 (kapitel 8 i vejledningen)."]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fosforkoncentration i indløb (Pindløb)",null,null,null,null,"mg P L-1"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Volumen af sø",null,null,null,null,"m3"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Vandføring til sø",null,null,null,null,"m3 år-1"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Opholdstid",null,null,null,{"$f":"IF(Z100=\"\",\"\",Z99/Z100)","v":""},"år"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fosforkoncentration i sø (Psø)",null,null,null,{"$f":"IF(Z101=\"\",\"\",Z98/(1+Z101^0.5))","v":""},"mg P L-1"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Årligt tilført P",null,null,null,{"$f":"IF(Z100=\"\",\"\",(Z98/1000)*Z100)","v":""},"kg P år-1"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Årligt fraført P",null,null,null,{"$f":"IF(Z100=\"\",\"\",(Z102/1000)*Z100)","v":""},"kg P år-1"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Foforretention",null,null,null,{"$f":"IF(Z100=\"\",\"\",Z103-Z104)","v":""},"kg P år-1",null,"Negativ værdi indikerer fosforfrigivelse"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fosforbalance",null,null,null,{"$f":"IF(Z100=\"\",\"\",Z105-Ptab)","v":""},"kg P år-1"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NB! For søer med veldifineret ind- og udløb med diffusiv udveksling af fosfor mellem søsediment og vandsøjlen. I disse tilfælde skal der tages særskilt kontakt"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"til Naturstyrelsen for fastlæggelse af betydningen af denne proces."]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Skjules når det endelige ark laves"]
[null,null,"Type",null,null,"Grundvandstand","Permeabilitet","Dræningsintensitet","Dræningsfaktor",null,null,null,"Molvægt (g/mol)",null,"Type projekt",null,null,"Vandløbstype"]
[null,null,"Permanent vådt",null,null,0,1,"Intensiv (>25%)",1,null,null,null,"P",30.973761,"A","A: Overrisling med drænvand",null,1]
[null,null,"Delvist vådt",null,null,"<50",0.5,"Moderat (<25%)",null,null,null,null,"Fe",55.845700000000001,"B","B: Oversvømmelse med vandløbsvand",null,2]
[null,null,"Tørt",null,null,">50",0,"Ingen",null,null,null,null,null,null,"C","C: Overrisling + oversvømmelse",null,3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"D","D: Sødannelse"]
[]
[null,null,"Georegion",null,"Korrektion af nedbør",null,null,null,"Grundvandsdybde"]
[null,null,1,null,null,"Frit eksponeret",null,null,"Permanent vådt"]
[null,null,2,null,null,"Moderat læ",null,null,"Højtliggende grundvandsspejl"]
[null,null,3,null,null,"Ideelt læ",null,null,"Dybtliggende grundvandsspejs (>1m)"]
[null,null,4,null,null,"År"]
[null,null,5,null,"Frit",27]
[null,null,6,null,"Moderat",21]
[null,null,7,null,"Ideelt",16]
[null,null,8]
[null,null,9]