{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Vandgennemstrømning","Rettelser"],"not_rendered":{"charts":0,"images":4,"macros":1,"external_links":0,"defined_names":33,"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":144,"n_cols":38,"rows_kept":144,"cut":false,"hidden":false,"merged":[[57,4,57,5],[57,6,57,8],[57,11,57,12],[57,20,57,22],[55,20,55,22],[56,4,56,5],[56,6,56,8],[56,11,56,12],[56,20,56,22],[53,20,53,22],[54,4,54,5],[54,6,54,8],[54,11,54,12],[54,20,54,22],[51,20,51,22],[52,4,52,5],[52,6,52,8],[52,11,52,12],[52,20,52,22],[50,4,50,5],[50,6,50,8],[50,11,50,12],[50,20,50,22],[64,20,64,21],[61,20,61,21],[5,1,5,17],[31,6,31,8],[32,11,32,12],[33,4,33,5],[33,6,33,8],[34,6,34,8],[34,4,34,5],[33,11,33,12],[34,11,34,12],[33,20,33,22],[47,4,47,5],[47,6,47,8],[47,11,47,12],[47,20,47,22],[25,18,26,27],[32,20,32,22],[32,24,32,25],[59,7,59,12],[59,2,59,5],[31,11,31,13],[48,4,48,5],[48,6,48,8],[48,11,48,12],[48,20,48,22],[49,4,49,5],[49,6,49,8],[49,11,49,12],[49,20,49,22],[35,4,35,5],[35,6,35,8],[35,11,35,12],[36,20,36,22],[40,11,40,12],[39,4,39,5],[39,6,39,8],[39,11,39,12],[41,4,41,5],[41,6,41,8],[41,11,41,12],[41,20,41,22],[42,4,42,5],[42,6,42,8],[78,5,78,7],[7,10,7,13],[32,4,32,5],[32,6,32,8],[51,4,51,5],[51,6,51,8],[51,11,51,12],[53,4,53,5],[53,6,53,8],[53,11,53,12],[55,4,55,5],[55,6,55,8],[55,11,55,12],[36,4,36,5],[36,6,36,8],[36,11,36,12],[38,4,38,5],[38,6,38,8],[38,11,38,12],[37,4,37,5],[37,6,37,8],[37,11,37,12],[40,4,40,5],[40,6,40,8],[45,4,45,5],[45,6,45,8],[45,11,45,12],[45,20,45,22],[46,4,46,5],[46,6,46,8],[46,11,46,12],[46,20,46,22],[34,20,34,22],[35,20,35,22],[38,20,38,22],[39,20,39,22],[40,20,40,22],[37,20,37,22],[42,11,42,12],[42,20,42,22],[43,6,43,8],[43,4,43,5],[43,11,43,12],[43,20,43,22],[44,4,44,5],[44,6,44,8],[44,11,44,12],[44,20,44,22]]}
[]
[",","Dette regneark er et støtteværktøj til \"Kvantificering af fosfortab fra N og P vådområder\" version 29 september 2020. De anvendte henvisninger til afnsit er til afsnit i denne vejledning."]
[]
[null,"Indsæt kun det antal rækker der skal bruges. Man kan senere indsætte  en tom række hvis det bliver nødvendigt"]
[]
[null,"Bestemmelse af vandstrømning gennem projektområdet (kapitel 3)"]
[null,null,"Projektnavn",null,null,null,"Gammelgaard Sø"]
[null,null,"Data om projektområdet"]
[]
[null,null,"Projektområdets areal",null,null,null,43.79,"ha"]
[null,null,"Direkte oplandsareal til projektområde",null,null,null,112.6,"ha","Bestemmes via GIS procedure jf. afsnit 3.4 - figur 3.0"]
[null,null,"Vandløbsoplandets areal",null,null,null,null,"ha","Se figur 3.0"]
[null,null,"Årlig nedbør",null,null,null,681,"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,"Moderat læ",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+F140)/100,IF(G14=\"Moderat læ\",G13*(100+F141)/100,IF(G14=\"Ideelt læ\",G13*(100+F142)/100))))","v":824.01},"mm år-1","Bestemt jf. bilag 2"]
[null,null,"Potentiel fordampning",null,null,null,570,"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=\"\",\"\",Korrigeret_Nedbor-G16)","v":254.01},"mm år-1","Bestemt jf. afsnit 3.5"]
[]
[null,null,"Base flow index (BFI) og overfladenær strømning - Til brug ved oversvømmelse",null,null,null,null,null,null,null,null,"Base flow index (BFI) og overfladenær strømning fra dirékte opland"]
[null,null,"BFI regnes på baggrund af karakteristika for vandløbsoplandet (jf. afsnit 3.3)",null,null,null,null,null,null,null,null,"BFI regnes på baggrund af karakteristika for det direkte opland (jf. afsnit 3.3)"]
[]
[null,null,"Andel af sandjord (js)",null,null,null,null,"%","Bestemmes fra jordbundskort",null,null,"Andel sandjord (js)",21.3,"%"]
[null,null,"Befæstet areal (j9)",null,null,null,null,"%","Bestemmes fra AIS arealanvendelseskort",null,null,"Befæstet areal (j9)",1.8,"%"]
[null,null,"Georegion",null,null,null,null,null,"figur 3.3 (mere detaljeret i vejledningen)",null,null,"Georegion",6,"figur 3.3"]
[null,null,"Beregnet BFI",null,null,null,{"$f":"IF(G24=\"\",\"\",IF(IF(georegion=1,1.3152-0.862-0.0001957*nedbor-0.005439*G22-0.007967*j_9+0.01091*G22,IF(georegion=2,1.3152-0.862-0.0001957*nedbor-0.005439*G22-0.007967*j_9+0.01091*G22,IF(georegion=3,1.3152-0.862-0.0001957*nedbor-0.005439*G22-0.007967*j_9+0.01091*G22,IF(georegion=4,1.3152-0.8509-0.0001957*nedbor-0.005439*G22-0.007967*j_9+0.01079*G22,IF(georegion=5,1.3152-0.8509-0.0001957*nedbor-0.005439*G22-0.007967*j_9+0.01079*G22,IF(georegion=6,1.3152-0.6359-0.0001957*nedbor-0.005439*G22-0.007967*j_9+0.007747*G22+0.01963*j_9,IF(georegion=7,1.3152-0.6581-0.0001957*nedbor-0.005439*G22-0.007967*j_9+0.00715*G22,IF(georegion=8,1.3152-0.6581-0.0001957*nedbor-0.005439*G22-0.007967*j_9+0.00715*G22,IF(georegion=9,1.3152-0.6581-0.0001957*nedbor-0.005439*G22-0.007967*j_9+0.00715*G22,999999)))))))))<0,0.05,IF(IF(georegion=1,1.3152-0.862-0.0001957*nedbor-0.005439*G22-0.007967*j_9+0.01091*G22,IF(georegion=2,1.3152-0.862-0.0001957*nedbor-0.005439*G22-0.007967*j_9+0.01091*G22,IF(georegion=3,1.3152-0.862-0.0001957*nedbor-0.005439*G22-0.007967*j_9+0.01091*G22,IF(georegion=4,1.3152-0.8509-0.0001957*nedbor-0.005439*G22-0.007967*j_9+0.01079*G22,IF(georegion=5,1.3152-0.8509-0.0001957*nedbor-0.005439*G22-0.007967*j_9+0.01079*G22,IF(georegion=6,1.3152-0.6359-0.0001957*nedbor-0.005439*G22-0.007967*j_9+0.007747*G22+0.01963*j_9,IF(georegion=7,1.3152-0.6581-0.0001957*nedbor-0.005439*G22-0.007967*j_9+0.00715*G22,IF(georegion=8,1.3152-0.6581-0.0001957*nedbor-0.005439*G22-0.007967*j_9+0.00715,IF(georegion=9,1.3152-0.6581-0.0001957*nedbor-0.005439*G22-0.007967*j_9+0.00715,999999)))))))))>1,0.95,IF(georegion=1,1.3152-0.862-0.0001957*nedbor-0.005439*G22-0.007967*j_9+0.01091*G22,IF(georegion=2,1.3152-0.862-0.0001957*nedbor-0.005439*G22-0.007967*j_9+0.01091*G22,IF(georegion=3,1.3152-0.862-0.0001957*nedbor-0.005439*G22-0.007967*j_9+0.01091*G22,IF(georegion=4,1.3152-0.8509-0.0001957*nedbor-0.005439*G22-0.007967*j_9+0.01079*G22,IF(georegion=5,1.3152-0.8509-0.0001957*nedbor-0.005439*G22-0.007967*j_9+0.01079*G22,IF(georegion=6,1.3152-0.6359-0.0001957*nedbor-0.005439*G22-0.007967*j_9+0.007747*G22+0.01963*j_9,IF(georegion=7,1.3152-0.6581-0.0001957*nedbor-0.005439*G22-0.007967*j_9+0.00715*G22,IF(georegion=8,1.3152-0.6581-0.0001957*nedbor-0.005439*G22-0.007967*j_9+0.00715*G22,IF(georegion=9,1.3152-0.6581-0.0001957*nedbor-0.005439*G22-0.007967*j_9+0.00715*G22,999999))))))))))))","v":""},null,"Bestemt jf. afsnit 3.3",null,null,"Beregnet BFI",{"$f":"IF(M24=\"\",\"\",IF(IF(M24=1,1.3152-0.862-0.0001957*netto_nedboer-0.005439*M22-0.007967*M23+0.01091*M22,IF(M24=2,1.3152-0.862-0.0001957*netto_nedboer-0.005439*M22-0.007967*M23+0.01091*M22,IF(M24=3,1.3152-0.862-0.0001957*netto_nedboer-0.005439*M22-0.007967*M23+0.01091*M22,IF(M24=4,1.3152-0.8509-0.0001957*netto_nedboer-0.005439*M22-0.007967*M23+0.01079*M22,IF(M24=5,1.3152-0.8509-0.0001957*netto_nedboer-0.005439*M22-0.007967*M23+0.01079*M22,IF(M24=6,1.3152-0.6359-0.0001957*netto_nedboer-0.005439*M22-0.007967*M23+0.007747*M22+0.01963*M23,IF(M24=7,1.3152-0.6581-0.0001957*netto_nedboer-0.005439*M22-0.007967*M23+0.00715*M22,IF(M24=8,1.3152-0.6581-0.0001957*netto_nedboer-0.005439*M22-0.007967*M23+0.00715*M22,IF(M24=9,1.3152-0.6581-0.0001957*netto_nedboer-0.005439*M22-0.007967*M23+0.00715*M22,999999)))))))))<0,0.05,IF(IF(M24=1,1.3152-0.862-0.0001957*netto_nedboer-0.005439*M22-0.007967*M23+0.01091*M22,IF(M24=2,1.3152-0.862-0.0001957*netto_nedboer-0.005439*M22-0.007967*M23+0.01091*M22,IF(M24=3,1.3152-0.862-0.0001957*netto_nedboer-0.005439*M22-0.007967*M23+0.01091*M22,IF(M24=4,1.3152-0.8509-0.0001957*netto_nedboer-0.005439*M22-0.007967*M23+0.01079*M22,IF(M24=5,1.3152-0.8509-0.0001957*netto_nedboer-0.005439*M22-0.007967*M23+0.01079*M22,IF(M24=6,1.3152-0.6359-0.0001957*netto_nedboer-0.005439*M22-0.007967*M23+0.007747*M22+0.01963*M23,IF(M24=7,1.3152-0.6581-0.0001957*netto_nedboer-0.005439*M22-0.007967*M23+0.00715*M22,IF(M24=8,1.3152-0.6581-0.0001957*netto_nedboer-0.005439*M22-0.007967*M23+0.00715*M22,IF(M24=9,1.3152-0.6581-0.0001957*netto_nedboer-0.005439*M22-0.007967*M23+0.00715*M22,999999)))))))))>1,0.95,IF(M24=1,1.3152-0.862-0.0001957*netto_nedboer-0.005439*M22-0.007967*M23+0.01091*M22,IF(M24=2,1.3152-0.862-0.0001957*netto_nedboer-0.005439*M22-0.007967*M23+0.01091*M22,IF(M24=3,1.3152-0.862-0.0001957*netto_nedboer-0.005439*M22-0.007967*M23+0.01091*M22,IF(M24=4,1.3152-0.8509-0.0001957*netto_nedboer-0.005439*M22-0.007967*M23+0.01079*M22,IF(M24=5,1.3152-0.8509-0.0001957*netto_nedboer-0.005439*M22-0.007967*M23+0.01079*M22,IF(M24=6,1.3152-0.6359-0.0001957*netto_nedboer-0.005439*M22-0.007967*M23+0.007747*M22+0.01963*M23,IF(M24=7,1.3152-0.6581-0.0001957*netto_nedboer-0.005439*M22-0.007967*M23+0.00715*M22,IF(M24=8,1.3152-0.6581-0.0001957*netto_nedboer-0.005439*M22-0.007967*M23+0.00715*M22,IF(M24=9,1.3152-0.6581-0.0001957*netto_nedboer-0.005439*M22-0.007967*M23+0.00715*M22,999999))))))))))))","v":0.69974404299999993},"Bestemt jf. afsnit 3.3"]
[null,null,"Årsafstrømning eller Nettonedbør i mm/år",null,null,null,null,null,"Til brug i ligning PP i BOKS 1 kap. 5",null,null,null,null,null,null,null,null,null,"Fosforbalance for projektområdet "]
[null,null,"Qflom (1 - BFI) x årsafstrømning",null,null,null,{"$f":"IF(G25=\"\",\"\",(1-BFI)*(G26))","v":""},null,"Indsættes i ligning PP som vist i boks 1",null,null,"QOF overfladenære",{"$f":"IF(M25=\"\",\"\",(1-M25)*(netto_nedboer/1000)*(oplands_areal*10000))","v":85877.785607903847},"m3 år-1"]
[null,null,null,null,null,null,null,null,null,null,null,"strømning"]
[null,null,"Bestemmelse af vandgennemstrømning (kapitel 3)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fosforfrigivelse fra projektområder"]
[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,"Simplificeret figur 3.3",null,null,null,"Frigivelsen beregnes ud fra proceduren beskrevet i kapitel 6 i vejledning."]
[null,null,null,null,"Fremtidige forhold (gælder også grundvandsdybde)",null,null,null,null,null,null,"Nuværende forhold","Nuværende forhold","Nuværende forhold",null,"(georegion 9, Bornholm, ikke vist)"]
[null,null,null,null,null,null,"Anvendes kun ved delvist vådt",null,null,null,null,"Tekstur og permeabilitet bestemmes vha. tabel 2.1",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Model 1","Model 1",null,null,"Model 2","Model 2"]
[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,"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 ","Frigivelses rate (ligning 6.1)               (kg P ha-1 mm-1)","Fosfor frigivelse (kg P år-1)","PBD pulje (kg P ha-1)","PBD total (kg P)","Frigivelses rate ny ligning kg P ha-1 mm-1","Fosforfrigivelse med ny formel Kg P år-1","Antal år med tab grid M1","Antal år med tab grid M2"]
[null,null,1,1.26,"Tørt",null,"<50",null,null,{"$f":"IF(E34=\"\",\"\",IF(E34=\"Permanent vådt\",Qovf/(areal*10000)*1000,IF(AND(E34=\"Delvist vådt\",G34=\"<50\"),Qovf/(areal*10000)*1000,IF(AND(E34=\"Delvist vådt\",G34=\">50\"),(Qovf/(areal*10000))*1000*4/12,IF(E34=\"Tørt\",0,\"\")))))","v":0},">1 m","Moderat omsat tørv",null,0.5,"Intensiv (>25%)",{"$f":"IF(O34=\"\",\"\",IF(O34=\"Intensiv (>25%)\",1,IF(O34=\"Moderat (<25%)\",0.5,0)))","v":1},{"$f":"IF(O34=\"\",\"\",IF(N34+P34>1,1,N34+P34))","v":1},{"$f":"IF(P34=\"\",\"\",IF(J34=0,0,IF((J34*Q34)>netto_nedboer,J34*Q34,netto_nedboer)))","v":0},null,{"$f":"IF(C34=\"\",\"\",C34)","v":1},0.6653,null,null,0.28499999999999998,2.4799999999999999E-2,null,{"$f":"IF(Y34=\"\",\"\",U34/((PI()*Y34^2*X34)))","v":1208.1460243240547},230,1960,{"$f":"IF(AC34=\"\",\"\",((AC34/1000)/Fe)/((AB34/1000)/P))","v":4.7264213919860394},{"$f":"IF(AD34=\"\",\"\",(0.1313*(AD34^-0.955)))","v":2.9791079920444781E-2},{"$f":"IF(AE34=\"\",\"\",AE34*R34*D34)","v":0},{"$f":"IF(AB34=\"\",\"\",AA34*10000*0.3*AB34/1000^2)","v":833.6207567835977},{"$f":"IF(E34=\"Tørt\",0, IF(AG34=\"\",\"\",AG34*D34))","v":0},{"$f":"IF(AD34=\"\",\"\",(0.0562*(AD34^-0.967)))","v":1.2515939258565039E-2},{"$f":"IF(AI34=\"\",\"\",AI34*R34*D34)","v":0},{"$f":"AG34/AF34","v":{"$error":"#DIV/0!"}},{"$f":"AG34/AJ34","v":{"$error":"#DIV/0!"}}]
[null,null,2,1.61,"Permanent vådt",null,"<50",null,null,196.11277827792611,"<1 m","Gytje, moderat/stærkt omsat tørv",null,0,"Intensiv (>25%)",1,1,254.01,null,2,0.16639999999999999,null,null,0.28499999999999998,2.4799999999999999E-2,null,302.17270170978912,280,6540,12.95459740857398,1.1373650575818222E-2,4.6513237822493743,253.82506943622286,408.65836179231883,4.7208737257055794E-3,1.9306301074570236,54.570501070014387,131.47265675378631]
[null,null,3,1.54,"Permanent vådt",null,"<50",null,null,196.11277827792611,"<1 m","Moderat omsat tørv",null,0.5,"Intensiv (>25%)",1,1,254.01,null,3,0.12670000000000001,null,null,0.28499999999999998,2.4799999999999999E-2,null,230.07981554465314,210,7820,20.653405042823351,7.2853041673732596E-3,2.8498317717939017,144.95028379313143,223.22343704142241,3.0070411977738158E-3,1.1762805433556516,50.862750997364543,123.22764719003375]
[null,null,4,12.05,"Permanent vådt",null,"<50",null,null,196.11277827792611,"<1 m","Let omsat tørv",null,1,"Intensiv (>25%)",1,1,254.01,null,4,0.13220000000000001,null,null,0.28499999999999998,2.4799999999999999E-2,null,240.06749498818584,140,6310,24.998015182905753,6.07106590369909E-3,18.582442974893201,100.82834789503804,1214.9815921352083,2.5001246984870974E-3,7.6524329296856264,5.4260006626291037,13.175985836334565]
[null,null,5,1.26,"Tørt",null,"<50",null,null,0,">1 m","Moderat omsat tørv",null,0.5,"Intensiv (>25%)",1,1,0,null,5,0.76780000000000004,null,null,0.28499999999999998,2.4799999999999999E-2,null,1394.2800503171641,190,2180,6.3636618849135349,2.2424586772106108E-2,0,794.73962868078354,0,9.3875346531856804E-3,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,6,1.36,"Permanent vådt",null,"<50",null,null,196.11277827792611,"<1 m","Muld/sand",null,1,"Intensiv (>25%)",1,1,254.01,null,6,0.28949999999999998,null,null,0.28499999999999998,2.4799999999999999E-2,null,525.71512707322086,300,5950,11.000183120634178,1.329620821173875E-2,4.5932229930947139,473.14361436589871,643.47531553762235,5.5297130819274339E-3,1.9102592911189271,103.0090668528843,247.68554539460277]
[null,null,7,1.41,"Permanent vådt",null,"<50",null,null,196.11277827792611,"<1 m","Let omsat tørv",null,1,"Intensiv (>25%)",1,1,254.01,null,7,0.26169999999999999,null,null,0.28499999999999998,2.4799999999999999E-2,null,475.23194734045558,240,7620,17.609536844376557,8.4835075276464035E-3,3.0384030034074225,342.16700208512793,482.45547294003035,3.5083108276632896E-3,1.2565159070020004,112.6140942137709,272.31410297186409]
[null,null,8,1.35,"Delvist vådt",null,"<50",null,null,196.11277827792611,"<1 m","Moderat omsat tørv",null,0.5,"Intensiv (>25%)",1,1,254.01,null,8,0.45860000000000001,null,null,0.28499999999999998,2.4799999999999999E-2,null,832.79087141892603,240,4530,10.468661667326222,1.3940189074248174E-2,4.7802790261122015,599.60942742162672,809.4727270191961,5.800982559232116E-3,1.9892352328252423,125.43398076686933,301.42711004068741]
[null,null,9,1.2,"Permanent vådt",null,"<50",null,null,196.11277827792611,"<1 m","Moderat omsat tørv",null,0.5,"Intensiv (>25%)",1,1,254.01,null,9,0.215,null,null,0.28499999999999998,2.4799999999999999E-2,null,390.42746915627799,380,6540,9.5454928273703015,1.5224999829905611E-2,4.6407626481531885,445.08731483815689,534.10477780578822,6.3426581615295373E-3,1.9333183195321411,95.908226423792925,230.21936446858223]
[null,null,10,1.21,"Permanent vådt",null,"<50",null,null,196.11277827792611,"<1 m","Moderat omsat tørv",null,0.5,"Intensiv (>25%)",1,1,254.01,null,10,0.21099999999999999,null,null,0.28499999999999998,2.4799999999999999E-2,null,383.16370228825423,420,6720,8.8740973074023604,1.6323231047431386E-2,5.0169793412132355,482.7862648832002,584.1713805086722,6.8061297976460952E-3,2.0918782861791021,96.230466989814232,230.79080081902293]
[null,null,11,1.45,"Delvist vådt",null,"<50",null,null,196.11277827792611,"<1 m","Moderat omsat tørv",null,0.5,"Intensiv (>25%)",1,1,254.01,null,11,0.46750000000000003,null,null,0.28499999999999998,2.4799999999999999E-2,null,848.95275270027901,470,4980,5.8767293338914577,2.4195808764203328E-2,8.9116672070831662,1197.0233813073933,1735.6839028957202,1.0138696075506595E-2,3.7342287757021735,134.3209248608359,320.55437767931306]
[null,null,12,1.1950000000000001,"Delvist vådt",null,"<50",null,null,196.11277827792611,"<1 m","Let omsat tørv",null,1,"Intensiv (>25%)",1,1,254.01,null,12,0.68930000000000002,null,null,0.28499999999999998,2.4799999999999999E-2,null,1251.7286255321974,210,6700,17.695372607022563,8.4442036990866314E-3,2.5631700570179694,788.58903408528431,942.36389573191479,3.4918531742272208E-3,1.0599239216186205,307.66161298042812,744.00531774112812]
[null,null,13,1.21,"Permanent vådt",null,"<50",null,null,196.11277827792611,"<1 m","Moderat omsat tørv",null,0.5,"Intensiv (>25%)",1,1,254.01,null,13,0.1077,null,null,0.28499999999999998,2.4799999999999999E-2,null,195.57692292154019,120,8790,40.626726735451427,3.8181186976673559E-3,1.1735067997773267,70.407692251754469,85.193307624622904,1.5632026157696296E-3,0.48045360668228876,59.997685795356574,146.54420587649622]
[null,null,14,1.34,"Permanent vådt",null,"<50",null,null,196.11277827792611,"<1 m","Moderat omsat tørv",null,0.5,"Intensiv (>25%)",1,1,254.01,null,14,6.6199999999999995E-2,null,null,0.28499999999999998,2.4799999999999999E-2,null,120.2153416657935,140,8390,33.238248396922231,4.6248783394435711E-3,1.5741855649827623,50.490443499633265,67.657194289508581,1.8980700863881531E-3,0.64605256874222938,32.074009966027191,78.15222157220245]
[null,null,15,1.41,"Delvist vådt",null,"<50",null,null,{"$f":"IF(E48=\"\",\"\",IF(E48=\"Permanent vådt\",Qovf/(areal*10000)*1000,IF(AND(E48=\"Delvist vådt\",G48=\"<50\"),Qovf/(areal*10000)*1000,IF(AND(E48=\"Delvist vådt\",G48=\">50\"),(Qovf/(areal*10000))*1000*4/12,IF(E48=\"Tørt\",0,\"\")))))","v":196.11277827792611},"<1 m","Moderat omsat tørv",null,0.5,"Intensiv (>25%)",1,{"$f":"IF(O48=\"\",\"\",IF(N48+P48>1,1,N48+P48))","v":1},{"$f":"IF(P48=\"\",\"\",IF(J48=0,0,IF((J48*Q48)>netto_nedboer,J48*Q48,netto_nedboer)))","v":254.01},null,{"$f":"IF(C48=\"\",\"\",C48)","v":15},0.10390000000000001,null,null,0.28499999999999998,2.4799999999999999E-2,null,{"$f":"IF(Y48=\"\",\"\",U48/((PI()*Y48^2*X48)))","v":188.67634439691761},70,7430,{"$f":"IF(AC48=\"\",\"\",((AC48/1000)/Fe)/((AB48/1000)/P))","v":58.870127673213865},2.679260999839487E-3,{"$f":"IF(AE48=\"\",\"\",AE48*R48*D48)","v":0.95958831206261153},{"$f":"IF(AB48=\"\",\"\",AA48*10000*0.3*AB48/1000^2)","v":39.622032323352705},{"$f":"IF(E48=\"Tørt\",0, IF(AG48=\"\",\"\",AG48*D48))","v":55.867065575927313},{"$f":"IF(AD48=\"\",\"\",(0.0562*(AD48^-0.967)))","v":1.0920634502495895E-3},{"$f":"IF(AI48=\"\",\"\",AI48*R48*D48)","v":0.39112700216703644},{"$f":"AG48/AF48","v":41.290657488507875},{"$f":"AG48/AJ48","v":101.3022166810962}]
[null,null,16,1.47,"Delvist vådt",null,"<50",null,null,{"$f":"IF(E49=\"\",\"\",IF(E49=\"Permanent vådt\",Qovf/(areal*10000)*1000,IF(AND(E49=\"Delvist vådt\",G49=\"<50\"),Qovf/(areal*10000)*1000,IF(AND(E49=\"Delvist vådt\",G49=\">50\"),(Qovf/(areal*10000))*1000*4/12,IF(E49=\"Tørt\",0,\"\")))))","v":196.11277827792611},"<1 m","Moderat omsat tørv",null,0.5,"Intensiv (>25%)",1,{"$f":"IF(O49=\"\",\"\",IF(N49+P49>1,1,N49+P49))","v":1},{"$f":"IF(P49=\"\",\"\",IF(J49=0,0,IF((J49*Q49)>netto_nedboer,J49*Q49,netto_nedboer)))","v":254.01},null,{"$f":"IF(C49=\"\",\"\",C49)","v":16},9.2499999999999999E-2,null,null,0.28499999999999998,2.4799999999999999E-2,null,{"$f":"IF(Y49=\"\",\"\",U49/((PI()*Y49^2*X49)))","v":167.97460882304983},220,6060,{"$f":"IF(AC49=\"\",\"\",((AC49/1000)/Fe)/((AB49/1000)/P))","v":15.277565250812019},9.7161232545368917E-3,{"$f":"IF(AE49=\"\",\"\",AE49*R49*D49)","v":3.6279489277908263},{"$f":"IF(AB49=\"\",\"\",AA49*10000*0.3*AB49/1000^2)","v":110.86324182321289},{"$f":"IF(E49=\"Tørt\",0, IF(AG49=\"\",\"\",AG49*D49))","v":162.96896548012293},{"$f":"IF(AD49=\"\",\"\",(0.0562*(AD49^-0.967)))","v":4.0249079749106534E-3},{"$f":"IF(AI49=\"\",\"\",AI49*R49*D49)","v":1.502879305819371},{"$f":"AG49/AF49","v":30.558104325553735},{"$f":"AG49/AJ49","v":73.767228941095951}]
[null,null,17,1.48,"Delvist vådt",null,"<50",null,null,{"$f":"IF(E50=\"\",\"\",IF(E50=\"Permanent vådt\",Qovf/(areal*10000)*1000,IF(AND(E50=\"Delvist vådt\",G50=\"<50\"),Qovf/(areal*10000)*1000,IF(AND(E50=\"Delvist vådt\",G50=\">50\"),(Qovf/(areal*10000))*1000*4/12,IF(E50=\"Tørt\",0,\"\")))))","v":196.11277827792611},"<1 m","Moderat omsat tørv",null,0.5,"Intensiv (>25%)",1,{"$f":"IF(O50=\"\",\"\",IF(N50+P50>1,1,N50+P50))","v":1},{"$f":"IF(P50=\"\",\"\",IF(J50=0,0,IF((J50*Q50)>netto_nedboer,J50*Q50,netto_nedboer)))","v":254.01},null,{"$f":"IF(C50=\"\",\"\",C50)","v":17},0.1004,null,null,0.28499999999999998,2.4799999999999999E-2,null,{"$f":"IF(Y50=\"\",\"\",U50/((PI()*Y50^2*X50)))","v":182.3205483873968},390,9040,{"$f":"IF(AC50=\"\",\"\",((AC50/1000)/Fe)/((AB50/1000)/P))","v":12.856064047903416},1.1456885161274603E-2,{"$f":"IF(AE50=\"\",\"\",AE50*R50*D50)","v":4.3070418317267354},{"$f":"IF(AB50=\"\",\"\",AA50*10000*0.3*AB50/1000^2)","v":213.31504161325427},{"$f":"IF(E50=\"Tørt\",0, IF(AG50=\"\",\"\",AG50*D50))","v":315.70626158761632},{"$f":"IF(AD50=\"\",\"\",(0.0562*(AD50^-0.967)))","v":4.7558577161346998E-3},{"$f":"IF(AI50=\"\",\"\",AI50*R50*D50)","v":1.787892419343555},{"$f":"AG50/AF50","v":49.52704198086095},{"$f":"AG50/AJ50","v":119.31089326480577}]
[null,null,18,1.28,"Permanent vådt",null,"<50",null,null,{"$f":"IF(E51=\"\",\"\",IF(E51=\"Permanent vådt\",Qovf/(areal*10000)*1000,IF(AND(E51=\"Delvist vådt\",G51=\"<50\"),Qovf/(areal*10000)*1000,IF(AND(E51=\"Delvist vådt\",G51=\">50\"),(Qovf/(areal*10000))*1000*4/12,IF(E51=\"Tørt\",0,\"\")))))","v":196.11277827792611},"<1 m","Moderat omsat tørv",null,0.5,"Intensiv (>25%)",1,{"$f":"IF(O51=\"\",\"\",IF(N51+P51>1,1,N51+P51))","v":1},{"$f":"IF(P51=\"\",\"\",IF(J51=0,0,IF((J51*Q51)>netto_nedboer,J51*Q51,netto_nedboer)))","v":254.01},null,{"$f":"IF(C51=\"\",\"\",C51)","v":18},0.1237,null,null,0.28499999999999998,2.4799999999999999E-2,null,{"$f":"IF(Y51=\"\",\"\",U51/((PI()*Y51^2*X51)))","v":224.63199039363531},130,5990,{"$f":"IF(AC51=\"\",\"\",((AC51/1000)/Fe)/((AB51/1000)/P))","v":25.555693688144299},5.9444817408179848E-3,{"$f":"IF(AE51=\"\",\"\",AE51*R51*D51)","v":1.9327459929410256},{"$f":"IF(AB51=\"\",\"\",AA51*10000*0.3*AB51/1000^2)","v":87.606476253517783},{"$f":"IF(E51=\"Tørt\",0, IF(AG51=\"\",\"\",AG51*D51))","v":112.13628960450276},{"$f":"IF(AD51=\"\",\"\",(0.0562*(AD51^-0.967)))","v":2.4473480375572132E-3},{"$f":"IF(AI51=\"\",\"\",AI51*R51*D51)","v":0.79571312002548189},{"$f":"AG51/AF51","v":45.32746495063666},{"$f":"AG51/AJ51","v":110.09806681422103}]
[null,null,19,1.19,"Permanent vådt",null,"<50",null,null,{"$f":"IF(E52=\"\",\"\",IF(E52=\"Permanent vådt\",Qovf/(areal*10000)*1000,IF(AND(E52=\"Delvist vådt\",G52=\"<50\"),Qovf/(areal*10000)*1000,IF(AND(E52=\"Delvist vådt\",G52=\">50\"),(Qovf/(areal*10000))*1000*4/12,IF(E52=\"Tørt\",0,\"\")))))","v":196.11277827792611},"<1 m","Moderat omsat tørv",null,0.5,"Intensiv (>25%)",1,{"$f":"IF(O52=\"\",\"\",IF(N52+P52>1,1,N52+P52))","v":1},{"$f":"IF(P52=\"\",\"\",IF(J52=0,0,IF((J52*Q52)>netto_nedboer,J52*Q52,netto_nedboer)))","v":254.01},null,{"$f":"IF(C52=\"\",\"\",C52)","v":19},0.1411,null,null,0.28499999999999998,2.4799999999999999E-2,null,{"$f":"IF(Y52=\"\",\"\",U52/((PI()*Y52^2*X52)))","v":256.22937626953876},110,6540,{"$f":"IF(AC52=\"\",\"\",((AC52/1000)/Fe)/((AB52/1000)/P))","v":32.975338858188316},4.6600864776810908E-3,{"$f":"IF(AE52=\"\",\"\",AE52*R52*D52)","v":1.4086131937729707},{"$f":"IF(AB52=\"\",\"\",AA52*10000*0.3*AB52/1000^2)","v":84.555694168947781},{"$f":"IF(E52=\"Tørt\",0, IF(AG52=\"\",\"\",AG52*D52))","v":100.62127606104785},{"$f":"IF(AD52=\"\",\"\",(0.0562*(AD52^-0.967)))","v":1.9127019220483658E-3},{"$f":"IF(AI52=\"\",\"\",AI52*R52*D52)","v":0.57815604411121135},{"$f":"AG52/AF52","v":60.027617619046531},{"$f":"AG52/AJ52","v":146.25064466624005}]
[null,null,20,1.29,"Permanent vådt",null,"<50",null,null,{"$f":"IF(E53=\"\",\"\",IF(E53=\"Permanent vådt\",Qovf/(areal*10000)*1000,IF(AND(E53=\"Delvist vådt\",G53=\"<50\"),Qovf/(areal*10000)*1000,IF(AND(E53=\"Delvist vådt\",G53=\">50\"),(Qovf/(areal*10000))*1000*4/12,IF(E53=\"Tørt\",0,\"\")))))","v":196.11277827792611},"<1 m","Moderat omsat tørv",null,0.5,"Intensiv (>25%)",1,{"$f":"IF(O53=\"\",\"\",IF(N53+P53>1,1,N53+P53))","v":1},{"$f":"IF(P53=\"\",\"\",IF(J53=0,0,IF((J53*Q53)>netto_nedboer,J53*Q53,netto_nedboer)))","v":254.01},null,{"$f":"IF(C53=\"\",\"\",C53)","v":20},0.151,null,null,0.28499999999999998,2.4799999999999999E-2,null,{"$f":"IF(Y53=\"\",\"\",U53/((PI()*Y53^2*X53)))","v":274.20719926789758},160,7170,{"$f":"IF(AC53=\"\",\"\",((AC53/1000)/Fe)/((AB53/1000)/P))","v":24.854405349248015},6.1045618899715597E-3,{"$f":"IF(AE53=\"\",\"\",AE53*R53*D53)","v":2.0002994977164619},{"$f":"IF(AB53=\"\",\"\",AA53*10000*0.3*AB53/1000^2)","v":131.61945564859084},{"$f":"IF(E53=\"Tørt\",0, IF(AG53=\"\",\"\",AG53*D53))","v":169.78909778668219},{"$f":"IF(AD53=\"\",\"\",(0.0562*(AD53^-0.967)))","v":2.5140924860856525E-3},{"$f":"IF(AI53=\"\",\"\",AI53*R53*D53)","v":0.82379997578389541},{"$f":"AG53/AF53","v":65.799874368237042},{"$f":"AG53/AJ53","v":159.7711331847843}]
[null,null,21,1.2,"Permanent vådt",null,"<50",null,null,{"$f":"IF(E54=\"\",\"\",IF(E54=\"Permanent vådt\",Qovf/(areal*10000)*1000,IF(AND(E54=\"Delvist vådt\",G54=\"<50\"),Qovf/(areal*10000)*1000,IF(AND(E54=\"Delvist vådt\",G54=\">50\"),(Qovf/(areal*10000))*1000*4/12,IF(E54=\"Tørt\",0,\"\")))))","v":196.11277827792611},"<1 m","Moderat omsat tørv",null,0.5,"Intensiv (>25%)",1,{"$f":"IF(O54=\"\",\"\",IF(N54+P54>1,1,N54+P54))","v":1},{"$f":"IF(P54=\"\",\"\",IF(J54=0,0,IF((J54*Q54)>netto_nedboer,J54*Q54,netto_nedboer)))","v":254.01},null,{"$f":"IF(C54=\"\",\"\",C54)","v":21},0.16819999999999999,null,null,0.28499999999999998,2.4799999999999999E-2,null,{"$f":"IF(Y54=\"\",\"\",U54/((PI()*Y54^2*X54)))","v":305.44139680039979},100,10200,{"$f":"IF(AC54=\"\",\"\",((AC54/1000)/Fe)/((AB54/1000)/P))","v":56.572370334690035},2.7830918997857812E-3,{"$f":"IF(AE54=\"\",\"\",AE54*R54*D54)","v":0.84831980815750352},{"$f":"IF(AB54=\"\",\"\",AA54*10000*0.3*AB54/1000^2)","v":91.632419040119942},{"$f":"IF(E54=\"Tørt\",0, IF(AG54=\"\",\"\",AG54*D54))","v":109.95890284814392},{"$f":"IF(AD54=\"\",\"\",(0.0562*(AD54^-0.967)))","v":1.1349268856382419E-3},{"$f":"IF(AI54=\"\",\"\",AI54*R54*D54)","v":0.34593933386516379},{"$f":"AG54/AF54","v":108.01636147002121},{"$f":"AG54/AJ54","v":264.88002395193189}]
[null,null,22,1.07,"Permanent vådt",null,"<50",null,null,{"$f":"IF(E55=\"\",\"\",IF(E55=\"Permanent vådt\",Qovf/(areal*10000)*1000,IF(AND(E55=\"Delvist vådt\",G55=\"<50\"),Qovf/(areal*10000)*1000,IF(AND(E55=\"Delvist vådt\",G55=\">50\"),(Qovf/(areal*10000))*1000*4/12,IF(E55=\"Tørt\",0,\"\")))))","v":196.11277827792611},"<1 m","Moderat omsat tørv",null,0.5,"Intensiv (>25%)",1,{"$f":"IF(O55=\"\",\"\",IF(N55+P55>1,1,N55+P55))","v":1},{"$f":"IF(P55=\"\",\"\",IF(J55=0,0,IF((J55*Q55)>netto_nedboer,J55*Q55,netto_nedboer)))","v":254.01},null,{"$f":"IF(C55=\"\",\"\",C55)","v":22},0.17349999999999999,null,null,0.28499999999999998,2.4799999999999999E-2,null,{"$f":"IF(Y55=\"\",\"\",U55/((PI()*Y55^2*X55)))","v":315.06588790053132},110,9390,{"$f":"IF(AC55=\"\",\"\",((AC55/1000)/Fe)/((AB55/1000)/P))","v":47.345325975288738},3.2989450759305897E-3,{"$f":"IF(AE55=\"\",\"\",AE55*R55*D55)","v":0.89662259144872813},{"$f":"IF(AB55=\"\",\"\",AA55*10000*0.3*AB55/1000^2)","v":103.97174300717535},{"$f":"IF(E55=\"Tørt\",0, IF(AG55=\"\",\"\",AG55*D55))","v":111.24976501767763},{"$f":"IF(AD55=\"\",\"\",(0.0562*(AD55^-0.967)))","v":1.3481659345561867E-3},{"$f":"IF(AI55=\"\",\"\",AI55*R55*D55)","v":0.36641896306918015},{"$f":"AG55/AF55","v":115.95931666096192},{"$f":"AG55/AJ55","v":283.75098858501332}]
[null,null,23,1.17,"Permanent vådt",null,"<50",null,null,{"$f":"IF(E56=\"\",\"\",IF(E56=\"Permanent vådt\",Qovf/(areal*10000)*1000,IF(AND(E56=\"Delvist vådt\",G56=\"<50\"),Qovf/(areal*10000)*1000,IF(AND(E56=\"Delvist vådt\",G56=\">50\"),(Qovf/(areal*10000))*1000*4/12,IF(E56=\"Tørt\",0,\"\")))))","v":196.11277827792611},"<1 m","Moderat omsat tørv",null,0.5,"Intensiv (>25%)",1,{"$f":"IF(O56=\"\",\"\",IF(N56+P56>1,1,N56+P56))","v":1},{"$f":"IF(P56=\"\",\"\",IF(J56=0,0,IF((J56*Q56)>netto_nedboer,J56*Q56,netto_nedboer)))","v":254.01},null,{"$f":"IF(C56=\"\",\"\",C56)","v":23},0.13300000000000001,null,null,0.28499999999999998,2.4799999999999999E-2,null,{"$f":"IF(Y56=\"\",\"\",U56/((PI()*Y56^2*X56)))","v":241.52024836179061},210,6430,{"$f":"IF(AC56=\"\",\"\",((AC56/1000)/Fe)/((AB56/1000)/P))","v":16.982275501963446},8.7825101152321037E-3,{"$f":"IF(AE56=\"\",\"\",AE56*R56*D56)","v":2.6100891114130249},{"$f":"IF(AB56=\"\",\"\",AA56*10000*0.3*AB56/1000^2)","v":152.1577564679281},{"$f":"IF(E56=\"Tørt\",0, IF(AG56=\"\",\"\",AG56*D56))","v":178.02457506747587},{"$f":"IF(AD56=\"\",\"\",(0.0562*(AD56^-0.967)))","v":3.6335429454284474E-3},{"$f":"IF(AI56=\"\",\"\",AI56*R56*D56)","v":1.0798588049748874},{"$f":"AG56/AF56","v":58.296000624114477},{"$f":"AG56/AJ56","v":140.90523294984533}]
[null,null,24,0.99,"Permanent vådt",null,"<50",null,null,{"$f":"IF(E57=\"\",\"\",IF(E57=\"Permanent vådt\",Qovf/(areal*10000)*1000,IF(AND(E57=\"Delvist vådt\",G57=\"<50\"),Qovf/(areal*10000)*1000,IF(AND(E57=\"Delvist vådt\",G57=\">50\"),(Qovf/(areal*10000))*1000*4/12,IF(E57=\"Tørt\",0,\"\")))))","v":196.11277827792611},"<1 m","Moderat omsat tørv",null,0.5,"Intensiv (>25%)",1,{"$f":"IF(O57=\"\",\"\",IF(N57+P57>1,1,N57+P57))","v":1},{"$f":"IF(P57=\"\",\"\",IF(J57=0,0,IF((J57*Q57)>netto_nedboer,J57*Q57,netto_nedboer)))","v":254.01},null,{"$f":"IF(C57=\"\",\"\",C57)","v":24},0.13650000000000001,null,null,0.28499999999999998,2.4799999999999999E-2,null,{"$f":"IF(Y57=\"\",\"\",U57/((PI()*Y57^2*X57)))","v":247.87604437131139},370,10700,{"$f":"IF(AC57=\"\",\"\",((AC57/1000)/Fe)/((AB57/1000)/P))","v":16.039331281960347},9.2749558315177016E-3,{"$f":"IF(AE57=\"\",\"\",AE57*R57*D57)","v":2.3323722154561728},{"$f":"IF(AB57=\"\",\"\",AA57*10000*0.3*AB57/1000^2)","v":275.14240925215569},{"$f":"IF(E57=\"Tørt\",0, IF(AG57=\"\",\"\",AG57*D57))","v":272.39098515963411},{"$f":"IF(AD57=\"\",\"\",(0.0562*(AD57^-0.967)))","v":3.8399114062388231E-3},{"$f":"IF(AI57=\"\",\"\",AI57*R57*D57)","v":0.96562213733573621},{"$f":"AG57/AF57","v":117.9667668088485},{"$f":"AG57/AJ57","v":284.93796756907994}]
[null,null,25,1.79,"Permanent vådt",null,"<50",null,null,{"$f":"IF(E58=\"\",\"\",IF(E58=\"Permanent vådt\",Qovf/(areal*10000)*1000,IF(AND(E58=\"Delvist vådt\",G58=\"<50\"),Qovf/(areal*10000)*1000,IF(AND(E58=\"Delvist vådt\",G58=\">50\"),(Qovf/(areal*10000))*1000*4/12,IF(E58=\"Tørt\",0,\"\")))))","v":196.11277827792611},"<1 m","Moderat omsat tørv",null,0.5,"Intensiv (>25%)",1,{"$f":"IF(O58=\"\",\"\",IF(N58+P58>1,1,N58+P58))","v":1},{"$f":"IF(P58=\"\",\"\",IF(J58=0,0,IF((J58*Q58)>netto_nedboer,J58*Q58,netto_nedboer)))","v":254.01},null,{"$f":"IF(C58=\"\",\"\",C58)","v":25},0.1719,null,null,0.28499999999999998,2.4799999999999999E-2,null,{"$f":"IF(Y58=\"\",\"\",U58/((PI()*Y58^2*X58)))","v":312.16038115332179},220,6910,{"$f":"IF(AC58=\"\",\"\",((AC58/1000)/Fe)/((AB58/1000)/P))","v":17.420458066519977},8.5714211881670766E-3,{"$f":"IF(AE58=\"\",\"\",AE58*R58*D58)","v":3.8972357858513109},{"$f":"IF(AB58=\"\",\"\",AA58*10000*0.3*AB58/1000^2)","v":206.02585156119238},{"$f":"IF(E58=\"Tørt\",0, IF(AG58=\"\",\"\",AG58*D58))","v":368.78627429453439},{"$f":"IF(AD58=\"\",\"\",(0.0562*(AD58^-0.967)))","v":3.5451262900190522E-3},{"$f":"IF(AI58=\"\",\"\",AI58*R58*D58)","v":1.6118905767806535},{"$f":"AG58/AF58","v":52.864610426999903},{"$f":"AG58/AJ58","v":127.81627644518976}]
[null,null,null,{"$f":"SUM(D$34:D58)","v":43.785000000000004},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,{"$f":"Ppulje","v":9688.9408238053911}]
[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,"Samlet fosforfrigivelse fra projektområdet M1",null,null,null,null,null,"Samlet fosforfrigivelse med ny formel M2"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AF57=\"\",\"\",SUM(AF$34:AF58))","v":87.196652438115834},null,"kg år-1",null,null,null,{"$f":"IF(AJ57=\"\",\"\",SUM(AJ$34:AJ58))","v":36.110507173177197}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Samlet fosfor (PBD) pulje i projektområdet",null,null,null,null,null,null,"Antal år med fosfortab"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AH57=\"\",\"\",SUM(AH$34:AH58))","v":9688.9408238053911},null,"kg",null,"Oprindelig formel M1",null,{"$f":"Ppulje/Ptab","v":111.11597237843174}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ny Formel M2",null,{"$f":"Ppulje/Ptab2","v":268.3136178990672}]
[]
[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,"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,"Type af projekt",null,null,null,"A",null,null,null,"Der kan indsættes op til 3 typer. DVS en i hver boks i drop down menuen"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"A: Overrislingsareal"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"B: Oversvømmelsesareal"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"C: Areal ved Sødannelse"]
[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,"Total Typer","Projektareal","Projektareal - type areal",null,"Kommentar"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Areal af type A B C",null,null,null,null,null,null,{"$f":"X76+Y76+Z76","v":0},{"$f":"G10","v":43.79},{"$f":"AB76-AA76","v":43.79},null,{"$f":"IF(AC76<0,\"Projektareal mindre end Total typer\",\"Ok\")","v":"Ok"}]
[]
[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,"Drænet oplandsareal til overrisling",null,null,null,112,"ha",null,"Obs! Indsæt 0 hvis der ikke er overrisling"]
[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(X79=\"\",\"\",0.062*X79)","v":6.944},"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,"B: Oversvømmelse (kapitel 5)"]
[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,"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,"2: Oplandsareal 10-100 km2"]
[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,"Der må maks. regnes sedimentation for et område op til",null,null,null,null,null,{"$f":"IF($X$84=\"\",\"\",IF($X$84=1,25,IF($X$84=2,75,100)))","v":""},"meter fra vandløbet på hver side (oversvømmet areal)"]
[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,"Manuelt beregnet oversvømmet areal"]
[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,"Bredde for sedimentationsområde",null,null,null,null,"m",{"$f":"IF(X94>Z89,\"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,"Oversvømmet areal",null,null,null,{"$f":"IF(X94=\"\",\"\",X93*X94/10000)","v":""},"ha"]
[]
[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,"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,"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,"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,"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,"Årsafstrømning",null,null,null,{"$f":"IF(X84=\"\",\"\",G26)","v":""},"mm år-1"]
[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(X104=\"\",\"\",(1-G25)*X104)","v":""},"mm år-1"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Andel sandjord i vandløbsopland (S)",null,null,null,{"$f":"IF(X104=\"\",\"\",G22)","v":""},"%"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Andel landbrugsjord i vandløbsopland (A)",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,"Andel af eng/mose i vandløbsopland (EM)",null,null,null,null,"%",null,"Kode 4110 + 4120 i AIS arealanvendelses tema"]
[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(X109=\"\",\"\",1.09*EXP(-7.6634+0.9208*LN(X105)+0.0229*X107+0.0092*X106+0.0187*X108-0.0412*X109))","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,1,"Fosfordeponering_metode1 LIGNING 1",null,null,null,{"$f":"IF(X113=\"\",\"\",IF(AND(X95=\"\",X98=\"\"),\"angiv areal\",IF(X98=\"\",X101*X113*X95,X101*X113*X98)))","v":""},"kg P år-1",null,"Beregning af deponering med ligning 1, Kap 5.2"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,"Fosfordeponering_metode2 LIGNING 2",null,null,null,{"$f":"IF(X110=\"\",\"\", X110*G12*0.1)","v":""},"kg P år-1",null,"Beregning af deponering med ligning 2, Kap 5.3 (MAKSIMAL årlig sedimentation af fosfor; i.e. 10 % af årlig PP transport i vandløb)"]
[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(X110=\"\",\"\",IF( X110<0.14,0.5,IF(AND(X110>=0.14,X110<=0.36),1,1.5)))","v":""},"kg P oversvømmet ha-1 år-1"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Valgt Fosfordeponering",null,null,null,{"$f":"IF(X111>X112,X112,X111)","v":""},"kg P år-1",null,"Obs!! Hvis beregning 1 > beregning 2  vælges beregning 2 automatisk ellers anvendes 1 "]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," (kapitel 8 i vejledningen)."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fosfortilbageholdelse i søer",null,null,null,{"$f":"0","v":0},"kg P år-1",null,"Obs!! Ny viden: I nyretablerede søer er der IKKE P tilbageholdelse "]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total fosfortilbageholdelse (A+B+C)",null,null,null,{"$f":"IF(ISERROR((X80+X114)-U62),IF(X114=\"\",(X80+0)-U62,IF(X80=\"\",(0+X114)-U62,IF(AND(X114=\"\",X80=\"\"),-U62))),(X80+X114)-U62)","v":-80.252652438115831},"kg P år-1",null,"Negative tal=frigivelse/tab af P  Positive tal=tilbageholdelse af P"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total fosfortilbageholdelse (A+B+C) Ny formel",null,null,null,{"$f":"IF(ISERROR((X80+X114)-AA62),IF(X114=\"\",(X80+0)-AA62,IF(X80=\"\",(0+X114)-AA62,IF(AND(X114=\"\",X80=\"\"),-AA62))),(X80+X114)-AA62)","v":-29.166507173177198},"kg P år-1"]
[]
[]
[]
[]
[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,"m24",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]

{"sheet":"Rettelser","index":1,"n_rows":12,"n_cols":2,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
["Rettelser foretaget i regne arket"]
[]
["Juni2018: indsat ny opdateret figur vandløbsoplande"]
["Juni 2018: Indsat 2 Gule Bjælker i række 31 E-I og L-O fortællende hvilke data der skal indtastes"]
["Juni 2018: Der kan nu indsættes en ekstra række i regnearket, se kolonne R nedenunder gennemstrømning"]
[]
["Oktober 2018","Ligning 6.1 rettet"]
[]
["August 2020","Indsat ligning for oxisk interface, M2, i kolonne AI"]
[null,"Fosforfrigivelse beregnet efter M2 i kolonne AJ"]
[null,"Antal år med fosforfrigivelse med oprindelig formel M1 beregnes for hvert grid i kolonne AK"]
[null,"Antal år med fosforfrigivelse beregnet med ny formel M2 beregnes for hvert grid i kolonne AL"]