{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Input og resultat","IDF","Kommuneliste","Tables","help1","help3"],"not_rendered":{"charts":0,"images":4,"macros":1,"external_links":0,"defined_names":45,"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":"Input og resultat","index":0,"n_rows":54,"n_cols":10,"rows_kept":54,"cut":false,"hidden":false,"merged":[]}
["Nedbørskarakteristika",null,null,null,null,null,null,null,"Pil ikke - intern beregning"]
["Kommune","Holbæk",null,null,null,null,null,null,"Afskærende lednings kapacitet l/s",0.39999999999999997]
[null," ",null,null,null,null,null,null,"Volumen m³",{"$f":"IDF!M15","v":36.401020886320374}]
["Designkarakteristika",null,null,null,null,null,null,null,"Total opland (m²)",1000]
["Gentagelsesperiode (år)",5,"år"]
["Sikkerhedsfaktor (klima, fremtidig udbygning, etc)",1.1000000000000001,null,null,null,"Beregningstjek","Vol m³","Dræn kap l/s","Iterationsafstand","Antal iterationer"]
["Oplandskarakteristika",null,null,null,"Faskine",{"$f":"IF(ABS((H7-B20)/H7)<0.001,\"OK\",\"Beregn\")","v":"Beregn"},0,1.6902369634427802E-2,9.9363796601312964E-4,6]
["Befæstet areal (m²)",null,"m²",null,"Regnbed",{"$f":"IF(ABS((H8-B26)/H8)<0.001,\"OK\",\"Beregn\")","v":"Beregn"},0,0.1,0,1]
[null,null,null,null,"Grøft",{"$f":"IF(ABS((H9-B35)/H9)<0.001,\"OK\",\"Beregn\")","v":"Beregn"},1.0000000000000001E-5,2.8603328174132515E-2,9.2709732237626196E-4,2]
["Jord- og nedsivningskarakteristika ",null,null,null,"Perm. bel.",{"$f":"IF(ABS((H10-B44)/H10)<0.001,\"OK\",\"Beregn\")","v":"Beregn"},0,0.3,0,1]
["K (Hydraulisk  ledningsevne) - se evt måling nederst ",9.9999999999999995E-7,"m/s"]
[]
[]
["Faskine",null,null,null,"Hjælpestørrelser, faskine",null,null,null,"Dimensionerende kasseregn, Afløbsteknik s. 269"]
["Bredde",0.8,"m",null,"Opstuvningsvolumen",null,{"$f":"F_bredde*F_hojde*F_hulrum*F_laengde","v":0}," [m³]","Vr,k (mm)",49.225459302928556]
["Højde",0.51,"m",null,"Faskine volumen ",null,{"$f":"G15/F_hulrum","v":0}," [m³]","Varighed (h)",56.325630690043987]
["Hulrums andel i faskine [Plast: 0,95, sten: 0,25]",0.95,"0-1",null,"Regn, der holdes umiddelbart",null,{"$f":"G15/B8*1000","v":{"$error":"#DIV/0!"}}," [mm]"]
["Udsivning i faskinebund: 0=Nej ,1=ja",0,null,null,"Regn, der siver pr døgn ",null,{"$f":"B20*86400/B8","v":{"$error":"#DIV/0!"}}," [mm/døgn]","Karakteritika for dimensionerende kasseregn"]
["Længde faskine",{"$f":"G7/(B15*B16*B17)","v":0},"m",null,"Tømmetid",{"$f":"ROUND(G19/60/60,0)","v":0},{"$f":"G15/(B20/1000)","v":0}," [s]","Samlet nedbør (mm)",{"$f":"J15+G18/24*J16","v":{"$error":"#DIV/0!"}}]
["Dræn kapacitet, gennemsnit",{"$f":"((B19+B15)*B16+B18*B19*B15)*B11*1000","v":4.08E-4},"l/s",null,"Afløbstal ",null,{"$f":"B20/B8*10000","v":{"$error":"#DIV/0!"}},"[l/sek/ha]","Intensitet (l/sek/ha)",{"$f":"J19*10000/(J16*3600)","v":{"$error":"#DIV/0!"}}]
[]
[]
["Regnbed",null,null,null,"Hjælpestørrelser, regnbed",null,null,null,"Dimensionerende kasseregn, Afløbsteknik s. 269"]
["Areal regnbed",25,"m²",null,"Opstuvningsvolumen",null,{"$f":"R_dybde*B24","v":0}," [m³]","Vr,k (mm)",44.884228010290997]
["Dybde",{"$f":"G8/R_areal","v":0},"m",null,"Regn, der holdes umiddelbart",null,{"$f":"G24/R_sam_opland*1000","v":0}," [mm]","Varighed (h)",38.853889834662333]
["Dræn kapacitet",{"$f":"B24*B11*1000","v":2.4999999999999998E-2},"l/s",null,"Regn, der siver pr døgn ",null,{"$f":"B26*86400/R_sam_opland","v":86.4}," [mm/døgn]","Karakteritika for dimensionerende kasseregn"]
["Samlet opland (befæstet areal + eget areal)",{"$f":"B8+B24","v":25},"m²",null,"Tømmetid",{"$f":"ROUND(G27/60/60,0)","v":0},{"$f":"G24/(B26/1000)","v":0}," [s]","Samlet nedbør (mm)",{"$f":"J24+G26/24*J25","v":184.75823141507539}]
[null,null,null,null,"Afløbstal ",null,{"$f":"R_draenkapacitet/R_sam_opland*10000","v":10},"[l/sek/ha]","Intensitet (l/sek/ha)",{"$f":"J27*10000/(J25*3600)","v":13.208904222209153}]
[]
[]
["Grøft / wadi, V-formet ",null,null,null,"Hjælpestørrelser, grøft",null,null,null,"Dimensionerende kasseregn, Afløbsteknik s. 269"]
["Bredde (kronekant)",2,"m",null,"Opstuvningsvolumen",null,{"$f":"0.5*B32*B34*B33","v":1.0000000000000001E-5}," [m³]","Vr,k (mm)",44.377706455308477]
["Længde grøft",25,"m",null,"Regn, der holdes umiddelbart",null,{"$f":"G32/B36*1000","v":2.0000000000000001E-4}," [mm]","Varighed (h)",37.121139394031644]
["Dybde",{"$f":"(G9*2)/(G_bredde*G_Laengde)","v":4.0000000000000003E-7},"m",null,"Regn, der siver pr døgn ",null,{"$f":"G32/(G35/86400)/G_sam_opl*1000","v":43.200000000003456}," [mm/døgn]","Karakteritika for dimensionerende kasseregn"]
["Dræn kapacitet, gns-snit",{"$f":"G32/G35*1000","v":2.5000000000002E-2},"l/s",null,"Tømmetid",{"$f":"ROUND(G35/60/60,0)","v":0},{"$f":"G_bredde/(2*B11*SQRT(1+(G_bredde/(2*G_dybde))^2))","v":0.39999999999996805}," [s]","Samlet nedbør (mm)",{"$f":"J32+G34/24*J33","v":111.19575736457077}]
["Samlet opland (befæstet areal + eget areal)",{"$f":"B8+G_Laengde*G_bredde","v":50},"m²",null,"Afløbstal ",null,{"$f":"G_draenkapacitet/G_sam_opl*10000","v":5.0000000000004006},"[l/sek/ha]","Intensitet (l/sek/ha)",{"$f":"J35*10000/(J33*3600)","v":8.3207872611834706}]
[]
[]
["Permeabel belægning",null,null,null,"Hjælpestørrelser, perm. belægning",null,null,null,"Dimensionerende kasseregn, Afløbsteknik s. 269"]
["Areal af permeabel belægning ",400,"m²",null,"Opstuvningsvolumen",null,{"$f":"P_belaegning*B43*B42/1000","v":0}," [m³]","Vr,k (mm)",28.73202657911575]
["Areal af tilstødende afvandingsareal (tag, vej, etc)",600,"m²",null,"Belægningsvolumen",null,{"$f":"P_belaegning*B43/1000","v":0}," [m³]","Varighed (h)",6.6621209994383124]
["Hulrumsandel af lag under belægning [0-1]",0.3,"0-1",null,"Regn, der holdes umiddelbart",null,{"$f":"G40/(P_belaegning+P_tilst_areal)*1000","v":0}," [mm]"]
["Dybde af lag under belægning",0,"mm",null,"Regn, der siver pr døgn ",null,{"$f":"G40/(G44/86400)/(P_belaegning+P_tilst_areal)*1000","v":{"$error":"#DIV/0!"}}," [mm/døgn]","Karakteritika for dimensionerende kasseregn"]
["Dræn kapacitet",{"$f":"B40*B11*1000","v":0.39999999999999997},"l/s",null,"Tømmetid",{"$f":"ROUND(G44/60/60,0)","v":0},{"$f":"G40/(B44/1000)","v":0}," [s]","Samlet nedbør (mm)",{"$f":"J40+G43/24*J41","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,"Afløbstal ",null,{"$f":"B44/(P_belaegning+P_tilst_areal)*10000","v":3.9999999999999996},"[l/sek/ha]","Intensitet (l/sek/ha)",{"$f":"J44*10000/(J41*3600)","v":{"$error":"#DIV/0!"}}]
[]
[]
[]
["Tabelværdier for den hydrauliske ledningsevne, K. Værdierne rækker over et stort spænd og K skal måles aktuelt på stedet. "]
["Grus","1e-3 til 0,1","m/s","3.600 - 360.000"," mm/ time"]
["Sand:","1e-5 til 1e-2","m/s","36 - 36.000"," mm/ time"]
["Silt:","1e-9 til 1e-5","m/s","0,0036 - 36"," mm/ time"]
["Ren ler:","under 1,0e-9","m/s"," under 0,0036"," mm/ time"]
["Moræneler","1e-10 til 1e-6","m/s","0,00036 - 3,6"," mm/ time"]

{"sheet":"IDF","index":1,"n_rows":69,"n_cols":35,"rows_kept":69,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,null,null,null,null,null,"Bassindimensionering opstrøms udløb",null,null,null,null,null,null,"Regression",null,null,null,null,null,null,null,null,null,"Sæt optimering i gang"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Oplandskarakteristika",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Initdummy"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Befæstet areal (ha)",null,null,null,{"$f":"'Input og resultat'!J4/10000","v":0.1},null,null,"Estimates, 3 parameters:",null,null,null,null,null,null,null,null,null,{"$f":"initdummy(B3,B4,B8,B9,B10,I3,I4,I5,Q3,Q4,Q5)","v":1}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Hydrologisk reduktionsfaktor (-)",null,null,null,1,null,null,"Alpha",{"$f":"EXP(X22/11+U7*W22/11)","v":139.73453511860532}]
["Årsmiddelnedbør [mm]",{"$f":"VLOOKUP('Input og resultat'!B2,Kommuneliste!A3:C101,2,FALSE)","v":618.99446813334896},"Fås fra kommunelisten",null,null,null,null,null,null,null,null,null,"Afskærende lednings kapacitet (l/s)",null,null,null,{"$f":"'Input og resultat'!J2","v":0.39999999999999997},null,null,"Theta",{"$f":"AD11","v":4.5263681120605455},null,null,null,null,null,null,null,null,"idftheta","theta"]
["Middelværdi Klimagrid [mm/dag]",{"$f":"VLOOKUP('Input og resultat'!B2,Kommuneliste!A3:C101,3,FALSE)","v":27.676026767857962},"Fås fra kommunelisten"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Nu",{"$f":"-(Z22-W22*X22/11)/(Y22-W22^2/11)","v":0.73845561305024321},null,null,null,null,null,null,null,null,{"$f":"idftheta(AE7)","v":0.20243877898220533},1]
["Gentagelsesperiode (år)",{"$f":"'Input og resultat'!B5","v":5},{"$f":"IF(B8<1/help1!C11,CONCATENATE(\" Fejl: Indtast gentagelsesperiode > \",ROUND(1/help1!C11,2),\" år\"),\" \")","v":" "},null,null,null,null,null,null,null,null,null,"NB. Frekvens- og sikkerhedsfaktorer på regnen ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"derividf","x"]
["Sikkerhedsfaktor (Fra Skrift 27)",{"$f":"'Input og resultat'!B6","v":1.1000000000000001},"Defineret i Skrift 27, Faktor til beskrivelse af usikkerhed, klima, mv. Typisk 1.0 - 1.8",null,null,null,null,null,null,null,null,null,"indgår ved beregning af bassinvolumen",null,null,null,null,null,null,"Dur (min)","Intensity","ln(dur)","ln(dur+Theta)","ln(int)","ln(dur+Theta)^2","ln(dur+Theta)*ln(int)","Est. Intensity","Obj.Func",null,{"$f":"derividf(AE9)","v":-0.18799210405040512},{"$f":"AE7","v":1}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IDF!A18","v":1},{"$f":"IDF!D18","v":39.528181096689956},{"$f":"LN(T10)","v":0},{"$f":"LN(T10+$U$5)","v":1.7095308388429329},{"$f":"LN(U10)","v":3.6770138630116516},{"$f":"W10^2","v":2.922495688955022},{"$f":"W10*X10","v":6.2859685936714014},{"$f":"$U$4*(T10+$U$5)^(-$U$7)","v":39.540750614546603},{"$f":"(LN(U10)-LN(AA10))^2","v":1.010847159145489E-7},null,"bisectidf","min","max","middel","tiny"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IDF!A19","v":2},{"$f":"IDF!D19","v":35.026377308640278},{"$f":"LN(T11)","v":0.69314718055994529},1.8758506035770266,3.5561014150370789,3.5188154869402948,6.6707149857784227,34.970751385166956,{"$f":"(LN(U11)-LN(AA11))^2","v":2.5261212442105891E-6},null,{"$f":"bisectidf(AE11,AF11,AG11,AH11)","v":4.5263681120605455},0,60,{"$f":"(AE11+AF11)/2","v":30},{"$f":"AD3/100000","v":1.0000000000000001E-5}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IDF!A20","v":5},{"$f":"IDF!D20","v":26.557090353472809},1.6094379124341003,2.2540635445105472,3.2792967686626517,5.0808024626914516,7.3917432978737212,26.449005761711671,1.6631718617694065E-5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IDF!A21","v":10},{"$f":"IDF!D21","v":19.535128631492547},2.3025850929940459,2.6759654884614341,2.972214313153517,7.1607912954366419,7.9535429263099173,19.368784225139731,7.3129923658167242E-5]
["Design regnkurve",null,null,null,null,null,null,null,null,null,null,null,"Volumen af bassin",null,null,null,null,null,null,{"$f":"IDF!A22","v":30},{"$f":"IDF!D22","v":10.102808518758712},3.4011973816621555,3.5417233252172782,2.3128134563568223,12.543804112388134,8.1913453652553514,10.219922233362773,1.3283759121099264E-4]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Q24*Q27*12","v":36.401020886320374},"m3",{"$f":"IF(Y27>0.1,\"ADVARSEL: Programmet har muligvis ikke optimeret korrekt\",\" \")","v":" "},null,null,null,null,{"$f":"IDF!A23","v":60},{"$f":"IDF!D23","v":6.2198008110335667},4.0943445622221004,4.1670739482014509,1.8277378822887231,17.364505289779228,7.6163189134262286,6.440107920512947,1.2115561759305326E-3]
["Varighed","zT","S{zT}","f*zT","Regression",null,null,null,null,null,null,null,"Effekten af koblede regn ER inkluderet (20 % ekstra volumen)",null,null,null,null,null,null,{"$f":"IDF!A24","v":180},{"$f":"IDF!D24","v":2.9941486990050512},5.1929568508902104,5.2177923698655118,1.0966599504304879,27.225357215026754,5.7221439216932906,2.9642865560984069,1.0047193197206024E-4]
["(min)","(mm/s)","(mm/s)","(mm/s)","(mm/s)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IDF!A25","v":360},{"$f":"IDF!D25","v":1.8397365597155493},5.8861040314501558,5.8985988893317449,0.60962238730287277,34.793468857225697,3.595917936656492,1.7930014187697658,6.6210501788205702E-4]
[1,{"$f":"help1!B17","v":35.934710087899958},{"$f":"help1!C17","v":3.2324901594357835},{"$f":"$B$9*B18","v":39.528181096689956},{"$f":"IDF!$U$4*(A18+IDF!$U$5)^(-IDF!$U$7)","v":39.540750614546603},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IDF!A26","v":720},{"$f":"IDF!D26","v":1.0937347287240422},6.5792512120101012,6.5855181560081348,8.9598196282766052E-2,43.369049383112788,0.59005054836573645,1.0796442597073923,1.6813267839732476E-4]
[2,{"$f":"help1!B18","v":31.842161189672975},{"$f":"help1!C18","v":2.6766201311040834},35.026377308640278,{"$f":"IDF!$U$4*(A19+IDF!$U$5)^(-IDF!$U$7)","v":34.970751385166956},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IDF!A27","v":1440},{"$f":"IDF!D27","v":0.6564814862374313},7.2723983925700466,7.2755367738844141,-0.42086078634153168,52.933435348144428,-3.0619881277137249,0.6486146334533065,1.4534080480258223E-4]
[5,{"$f":"help1!B19","v":24.142809412248006},{"$f":"help1!C19","v":1.6177553092013575},26.557090353472809,{"$f":"IDF!$U$4*(A20+IDF!$U$5)^(-IDF!$U$7)","v":26.449005761711671},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IDF!A28","v":2880},{"$f":"IDF!D28","v":0.37833974286701894},7.965545573129992,7.9671159949663295,-0.97196269637952082,63.47493727724833,-7.7437395448358828,0.38921745493304472,8.0347388624383339E-4]
[10,{"$f":"help1!B20","v":17.759207846811407},{"$f":"help1!C20","v":1.3547617856952057},19.535128631492547,{"$f":"IDF!$U$4*(A21+IDF!$U$5)^(-IDF!$U$7)","v":19.368784225139731},null,null,null,null,null,null,null,"Mellemresultater svarende til Skrift 16"]
[30,{"$f":"help1!B21","v":9.184371380689738},{"$f":"help1!C21","v":0.86559068915736725},10.102808518758712,{"$f":"IDF!$U$4*(A22+IDF!$U$5)^(-IDF!$U$7)","v":10.219922233362773},null,null,null,null,null,null,null,"Dvs. at effekt af koblede regn IKKE er indkluderet",null,null,null,null,null,null,null,"Sum",null,{"$f":"SUM(W10:W20)","v":49.168769932866802},{"$f":"SUM(X10:X20)","v":18.02823474980552},{"$f":"SUM(Y10:Y20)","v":270.38746241694878},{"$f":"SUM(Z10:Z20)","v":43.212018816480949},null,{"$f":"SUM(AB10:AB20)","v":3.3163069346753694E-3}]
[60,{"$f":"help1!B22","v":5.6543643736668781},{"$f":"help1!C22","v":0.62890107064041334},6.2198008110335667,{"$f":"IDF!$U$4*(A23+IDF!$U$5)^(-IDF!$U$7)","v":6.440107920512947},null,null,null,null,null,null,null,"i mellemresultaterne."]
[180,{"$f":"help1!B23","v":2.7219533627318646},{"$f":"help1!C23","v":0.26177160645384473},2.9941486990050512,{"$f":"IDF!$U$4*(A24+IDF!$U$5)^(-IDF!$U$7)","v":2.9642865560984069},null,null,null,null,null,null,null,"Reduceret areal (ha)",null,null,null,{"$f":"Q3*Q4","v":0.1}]
[360,{"$f":"help1!B24","v":1.6724877815595902},{"$f":"help1!C24","v":0.11776533696827006},1.8397365597155493,{"$f":"IDF!$U$4*(A25+IDF!$U$5)^(-IDF!$U$7)","v":1.7930014187697658},null,null,null,null,null,null,null,"Afløbstal (mu-m/s",null,null,null,{"$f":"Q5/(Q24*10)","v":0.39999999999999997},null,null,null,null,"Afløbstal","tr, 3 par","Vr,k 3 par","dV/dt","(dV/dt)^2",null,null,null,"dbasvol","alpha","nu","theta","t","a"]
[720,{"$f":"help1!B25","v":0.99430429884003835},{"$f":"help1!C25","v":7.951993752162545E-2},1.0937347287240422,{"$f":"IDF!$U$4*(A26+IDF!$U$5)^(-IDF!$U$7)","v":1.0796442597073923},null,null,null,null,null,null,null,"Varighed (h)",null,null,null,{"$f":"W27/60","v":7.5820086783912881},null,null,null,null,"mu-m/s",1153.5315245328354,"(mm)","( … )","( … )",null,null,null,{"$f":"dbasvol(AE26,AF26,AG26,AH26,AI26)","v":-8.8809722488221804E-2},{"$f":"U4","v":139.73453511860532},{"$f":"U7","v":0.73845561305024321},{"$f":"AE7","v":1},638,{"$f":"V27","v":0.39999999999999997}]
[1440,{"$f":"help1!B26","v":0.59680135112493748},{"$f":"help1!C26","v":4.5463401530362567E-2},0.6564814862374313,{"$f":"IDF!$U$4*(A27+IDF!$U$5)^(-IDF!$U$7)","v":0.6486146334533065},null,null,null,null,null,null,null,"Vr,k (mm)",null,null,null,{"$f":"X27","v":30.334184071933642},null,null,"Faktisk opland",null,{"$f":"Q25","v":0.39999999999999997},{"$f":"AD28","v":454.92052070347728},{"$f":"(U$4*(W27+U$5)^(-U$7)-V27)*W27*60/1000","v":30.334184071933642},{"$f":"$U$4*(W27+$U$5)^(-1-$U$7)*(W27+$U$5-$U$7*W27)-V27","v":6.2766757095620851E-3},{"$f":"SQRT(Y27^2)","v":6.2766757095620851E-3},null,null,null,"bisectvol","xl","xr","xmid","tiny"]
[2880,{"$f":"help1!B27","v":0.343945220788199},{"$f":"help1!C27","v":2.6839125589760159E-2},0.37833974286701894,{"$f":"IDF!$U$4*(A28+IDF!$U$5)^(-IDF!$U$7)","v":0.38921745493304472},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Initialisering",null,null,{"$f":"(U$4*(1-U$7)/V27)^(1/U$7)","v":452.12303700739415},null,null,null,null,null,null,{"$f":"bisectvol(AE28,AF28,AG28,AH28,AE26,AF26,AG26,AI26)","v":454.92052070347728},{"$f":"0.3*W28","v":135.63691110221825},{"$f":"3*W28","v":1356.3691110221826},{"$f":"(AE28+AF28)/2","v":746.00301106220036},{"$f":"AD3/100000","v":1.0000000000000001E-5}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tilnærmet volumenkurve excl koblede regn. Tilnærmelsen er god op til ca. T=5 år"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Volumenkurve",null,0.01,{"$f":"(U$4*(1-U$7)/V31)^(1/U$7)","v":66792.897279176264},{"$f":"(U$4*(W31+U$5)^(-U$7)-V31)*W31*60/1000","v":113.14388695050333}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tilnærmet for store afløbstal",null,{"$f":"V31*1.2","v":1.2E-2},52180.089285765367,106.06659680754929]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.44E-2,40764.240342652563,99.43147154174271]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.728E-2,31845.926548977,93.210780612721862]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.0736000000000001E-2,24878.742477182735,87.378511503259233]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.4883200000000001E-2,19435.824116910746,81.910259086696882]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.9859839999999999E-2,15183.695858017789,76.783121280368476]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3.5831808E-2,11861.839175020812,71.97560046948098]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4.2998169599999997E-2,9266.7312313002967,67.467510195807435]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5.1597803519999992E-2,7239.3754835245154,63.239886611486213]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6.1917364223999988E-2,5655.5603139146942,59.274904200389031]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7.4300837068799988E-2,4418.2488582225997,55.555795268396594]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8.916100448255998E-2,3451.6337709557997,52.066772700488237]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.1,2954.9677791210415,49.982517092238282]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.12,2308.4862138353001,46.836867977851419]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.14399999999999999,1803.4405102896903,43.883933571679236]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.17279999999999998,1408.8876314970184,41.110874944696306]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.20735999999999996,1100.6541922840745,38.505504265072254]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.24883199999999994,859.85540926730278,36.056216793287781]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.29859839999999993,671.73807180249798,33.751923271910186]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.35831807999999993,524.77664528904916,31.58198273140658]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.42998169599999991,409.96712707062198,29.536136142012246]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.51597803519999985,320.27539103986555,27.60444198700521]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.61917364223999982,250.2062222371035,25.777215818099062]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.74300837068799974,195.46663714281593,24.044977308399041]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,130.72998674015938,21.402092772420339]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.2,102.12915831329192,19.875535555899145]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.44,79.785558293622216,18.410910150747299]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.728,62.330243559801282,16.999638117118383]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.0735999999999999,48.693765454727796,15.633630928595084]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.4883199999999999,38.040647023706263,14.305584854928995]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.9859839999999997,29.718195183069568,13.009396011994726]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3.5831807999999996,23.216511653669908,11.740691762063451]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4.2998169599999994,18.137252617280819,10.497440237032102]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"V64*1.2","v":5.1597803519999994},14.169223068921294,9.2805493267164287]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"V65*1.2","v":6.1917364223999991},11.069310584865798,8.094309235081111]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"V66*1.2","v":7.4300837068799988},8.6475903603337194,6.9464917120333833]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"V67*1.2","v":8.9161004482559978},6.7556889353505589,5.847928622578352]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,5.7835924824079736,5.187640864756184]

{"sheet":"Kommuneliste","index":2,"n_rows":101,"n_cols":5,"rows_kept":101,"cut":false,"hidden":false,"merged":[]}
[null,"Årsmiddelnedbør","Middelværdi Klimagrid",null,"Faskinebund"]
["Kommuner","mm","mm/dag",null,"Nej/ja"]
["Albertslund",632.49007681987212,27.704998074179372,null,0]
["Allerød",674.10474259425848,27.91964123273647,null,1]
["Assens",697.02257492452702,25.833864009599534]
["Ballerup",647.05121493735714,27.724669202840431,null,"Note: Årsmiddelbøren er et maksimum af nedbøren i 5 punkter: "]
["Billund",906.63431520239408,26.231368235573651,null,"1: Kommunecentrum, samt 4 punkter, 15 km i n, s, ø, v fra kommunecentrum"]
["Bogense",673.60094135524582,25.749728966587114]
["Bornholm",696.05765684502512,28.983963279571785]
["Brøndby",644.89390717471429,28.189741274128249]
["Brønderslev-Dronninglund",709.81276643852414,27.38203116147827]
["Christiansø",610.00481300220338,29.013117650730955]
["Dragør",618.40528349083354,27.702569556270326]
["Egedal",651.34989077687703,28.096702818721255]
["Esbjerg",838.87384249581839,25.914605711181508]
["Fanø",809.84253030991022,25.539973514944027]
["Favrskov",699.71554380310863,25.60518000976495]
["Faxe",629.2901111571515,27.201269581405363]
["Fredensborg",661.90620101997285,28.35961029868227]
["Fredericia",778.80905053333368,25.308901015275019]
["Frederiksberg",656.19804973894361,27.767223236974139]
["Frederikshavn",697.01898247010683,27.319394342830524]
["Frederikssund",616.48382480431019,27.817460256564953]
["Frederiksværk-Hundested",621.72529665769059,27.947533656270171]
["Furesø",679.95092021623395,27.769100079873702]
["Faaborg-Midtfyn",685.73679311888554,26.392594759255722]
["Gentofte",676.56235966969325,27.96765019724398]
["Gladsaxe",664.32951678870904,27.969216051786212]
["Glostrup",653.58146739238487,27.684190868535367]
["Greve",612.24765272562763,28.84671911643645]
["Gribskov",632.04609713181162,28.374856688547574]
["Guldborgsund",609.50468777177525,26.425246227084457]
["Haderslev",835.41169613486784,25.52826949845651]
["Hedensted",780.69224549584044,25.127897279170842]
["Helsingør",650.84758180623919,28.275198547494941]
["Herlev",667.99038743927997,27.876176278428574]
["Herning",883.39077805774275,25.494125554247749]
["Hillerød",646.62557276955499,28.103204128961021]
["Hjørring",702.07871939484642,27.296836425260572]
["Holbæk",618.99446813334896,27.676026767857962]
["Holstebro",845.03357240675427,26.183972138750118]
["Horsens",789.96000540457283,25.218099401084249]
["Hvidovre",647.01912278857128,27.817102061671442]
["Høje-Taastrup",631.33655139856444,27.934491030929859]
["Hørsholm",659.79275902287009,28.186589200151243]
["Ikast-Brande",829.95688166626383,25.701272770762642]
["Ishøj",609.99018738007419,27.914621241542523]
["Jammerbugt",732.69064163187306,26.485937588089364]
["Kalundborg",612.31453770669486,26.792278174832486]
["Kerteminde",655.63381175143309,26.239959439180275]
["Kolding",824.16173841106104,25.745398463793972]
["Københavns",649.55503476979027,27.664790501131542]
["Køge",635.84910043516197,28.167798451842575]
["Langeland",631.92614702933724,27.521122107602338]
["Lejre",622.17921228986154,27.645088253570787]
["Lemvig",820.14935737639462,26.014501138433165]
["Lolland",621.16013877544526,27.250216700628624]
["Lyngby-Taarbæk",646.21526751164879,28.000004732028781]
["Læsø",663.51126398639053,27.942833182464334]
["Mariagerfjord",715.81038200234127,27.255017253422185]
["Middelfart",763.38604964787646,25.566544703287384]
["Morsø",807.37004732348942,25.756694254501124]
["Norddjurs",650.40096501166181,26.66260864141227]
["Nyborg",672.30623030065908,26.400098946720977]
["Næstved",635.57453540204915,27.070746235424131]
["Odder",701.99380060876911,25.587868162661447]
["Odense",680.95713975694866,26.130737070281455]
["Odsherred",608.10741958783854,27.595298161793146]
["Randers",688.067657379313,26.69955095982575]
["Rebild",725.57937065074373,26.869877325089512]
["Ringkøbing-Skjern",867.00298658913653,25.561305975757538]
["Ringsted",655.76211477903701,27.244061293129683]
["Roskilde",614.92728902806004,27.587608162758425]
["Rudersdal",686.92829536527722,27.807778303079445]
["Rødovre",690.77272101333415,27.636737871703897]
["Samsø",623.97659509098651,26.123341436112835]
["Silkeborg",810.86222463346667,25.764935337270977]
["Skanderborg",768.91808557791319,25.353257937753]
["Skive",788.4125946408825,25.914866615012048]
["Slagelse",613.94210490390367,26.605973705464091]
["Solrød",618.88607521578695,27.521750711781635]
["Sorø",631.24682814919447,27.441398336146307]
["Stevns",632.29073117374855,27.458564506862011]
["Struer",825.59018249573046,26.200876083750096]
["Svendborg",675.33653806718701,26.933199166213523]
["Syddjurs",658.8381766527624,27.062375509887413]
["Sønderborg",750.73019046042816,26.255528698668979]
["Thisted",834.51848395708987,25.42788807155722]
["Tønder",854.5457241005995,25.658870720729183]
["Tårnby",628.32871789070441,27.524539531603438]
["Vallensbæk",625.29921914407498,27.990062425631184]
["Varde",831.00740205943055,26.002352552450862]
["Vejen",871.68726543806213,25.911445192548126]
["Vejle",822.96525930671248,25.603890418043164]
["Vesthimmerland",737.6203059650619,26.179523982567439]
["Viborg",742.78617141599079,25.641650679890628]
["Vordingborg",614.07284124684429,25.937590121859703]
["Ærø",647.93242438031496,27.384899287947484]
["Aabenraa",842.86917819535438,25.582640892519144]
["Aalborg",706.92644963184773,27.227461463658681]
["Århus",696.60346488316793,25.675405259939566]

{"sheet":"Tables","index":3,"n_rows":48,"n_cols":12,"rows_kept":48,"cut":false,"hidden":false,"merged":[]}
["LAMBDA"]
[]
["Variabel","b_0","b_1","V(b_0)","Cov","V(b_1)","Res.var.",null,"E(lambda)","V(lambda)",null,"z_0"]
["i1m",0.24529999999999999,6.1120000000000002E-3,0.76290000000000002,-1.106E-3,1.6819999999999999E-6,0.34310000000000002,null,{"$f":"B4+C4*IDF!$B$5","v":4.0285941892310291},{"$f":"D4+2*E4*IDF!$B$5+F4*IDF!$B$5^2+G4","v":0.38124951944606661},null,15.8]
["i2m",0.84870000000000001,5.1929999999999997E-3,0.83099999999999996,-1.2030000000000001E-3,1.8300000000000001E-6,0.3977,null,{"$f":"B5+C5*IDF!$B$5","v":4.0631382730164809},{"$f":"D5+2*E5*IDF!$B$5+F5*IDF!$B$5^2+G5","v":0.44057140706199044},null,12.8]
["i5m",1.298,4.2919999999999998E-3,0.83160000000000001,-1.2049999999999999E-3,1.8330000000000001E-6,0.4007,null,{"$f":"B6+C6*IDF!$B$5","v":3.9547242572283339},{"$f":"D6+2*E6*IDF!$B$5+F6*IDF!$B$5^2+G6","v":0.44284489164419644},null,9]
["i10m",1.6639999999999999,4.3660000000000001E-3,1.06,-1.5410000000000001E-3,2.3470000000000001E-6,0.53459999999999996,null,{"$f":"B7+C7*IDF!$B$5","v":4.3665298478702015},{"$f":"D7+2*E7*IDF!$B$5+F7*IDF!$B$5^2+G7","v":0.58612184297054515},null,6]
["i30m",1.9690000000000001,3.2499999999999999E-3,0.90300000000000002,-1.307E-3,1.9860000000000001E-6,0.42330000000000001,null,{"$f":"B8+C8*IDF!$B$5","v":3.9807320214333837},{"$f":"D8+2*E8*IDF!$B$5+F8*IDF!$B$5^2+G8","v":0.46919260533668539},null,3.2]
["i60m",2.1779999999999999,2.735E-3,0.90800000000000003,-1.3129999999999999E-3,1.9929999999999998E-6,0.40939999999999999,null,{"$f":"B9+C9*IDF!$B$5","v":3.8709498703447096},{"$f":"D9+2*E9*IDF!$B$5+F9*IDF!$B$5^2+G9","v":0.45554675078014284},null,2.1]
["i3h",1.76,2.7200000000000002E-3,0.75970000000000004,-1.0939999999999999E-3,1.658E-6,0.30880000000000002,null,{"$f":"B10+C10*IDF!$B$5","v":3.4436649533227093},{"$f":"D10+2*E10*IDF!$B$5+F10*IDF!$B$5^2+G10","v":0.34940968704335457},null,1.1000000000000001]
["i6h",0.87270000000000003,3.5969999999999999E-3,0.73370000000000002,-1.0510000000000001E-3,1.5880000000000001E-6,0.30640000000000001,null,{"$f":"B11+C11*IDF!$B$5","v":3.0992231018756562},{"$f":"D11+2*E11*IDF!$B$5+F11*IDF!$B$5^2+G11","v":0.34742242069224438},null,0.73]
["i12h",3.9120000000000002E-2,4.4149999999999997E-3,0.70840000000000003,-1.0139999999999999E-3,1.5319999999999999E-6,0.30959999999999999,null,{"$f":"B12+C12*IDF!$B$5","v":2.7719805768087356},{"$f":"D12+2*E12*IDF!$B$5+F12*IDF!$B$5^2+G12","v":0.34967137884564969},null,0.45]
["i24h",-1.518,7.051E-3,0.68840000000000001,-9.7740000000000001E-4,1.4729999999999999E-6,0.28060000000000002,null,{"$f":"B13+C13*IDF!$B$5","v":2.8465299948082441},{"$f":"D13+2*E13*IDF!$B$5+F13*IDF!$B$5^2+G13","v":0.32337567896980918},null,0.26]
["i48h",-2.7410000000000001,9.4909999999999994E-3,0.6109,-8.6019999999999998E-4,1.2929999999999999E-6,0.2127,null,{"$f":"B14+C14*IDF!$B$5","v":3.1338764970536146},{"$f":"D14+2*E14*IDF!$B$5+F14*IDF!$B$5^2+G14","v":0.25410023501592238},null,0.15]
[]
[]
["MEAN"]
[]
["Variabel","b_0","b_1","V(b_0)","Cov","V(b_1)","Res.var.",null,"E(Mean)","V(Mean)"]
["i1m",6.2229999999999999,0,1.9910000000000001E-2,0,0,0.22120000000000001,null,{"$f":"B20+C20*IDF!$B$6","v":6.2229999999999999},{"$f":"D20+2*E20*IDF!$B$6+F20*IDF!$B$6^2+G20","v":0.24111000000000002}]
["i2m",5.9939999999999998,0,1.6650000000000002E-2,0,0,0.1275,null,{"$f":"B21+C21*IDF!$B$6","v":5.9939999999999998},{"$f":"D21+2*E21*IDF!$B$6+F21*IDF!$B$6^2+G21","v":0.14415}]
["i5m",4.8959999999999999,0,1.09E-2,0,0,7.6399999999999996E-2,null,{"$f":"B22+C22*IDF!$B$6","v":4.8959999999999999},{"$f":"D22+2*E22*IDF!$B$6+F22*IDF!$B$6^2+G22","v":8.7299999999999989E-2}]
["i10m",3.577,0,6.2230000000000002E-3,0,0,4.4209999999999999E-2,null,{"$f":"B23+C23*IDF!$B$6","v":3.577},{"$f":"D23+2*E23*IDF!$B$6+F23*IDF!$B$6^2+G23","v":5.0432999999999999E-2}]
["i30m",1.8220000000000001,0,2.434E-3,0,0,2.4709999999999999E-2,null,{"$f":"B24+C24*IDF!$B$6","v":1.8220000000000001},{"$f":"D24+2*E24*IDF!$B$6+F24*IDF!$B$6^2+G24","v":2.7143999999999998E-2}]
["i60m",1.0960000000000001,0,1.1039999999999999E-3,0,0,1.188E-2,null,{"$f":"B25+C25*IDF!$B$6","v":1.0960000000000001},{"$f":"D25+2*E25*IDF!$B$6+F25*IDF!$B$6^2+G25","v":1.2983999999999999E-2}]
["i3h",-0.38919999999999999,3.3320000000000002E-2,0.1145,-4.3270000000000001E-3,1.639E-4,1.2210000000000001E-3,null,{"$f":"B26+C26*IDF!$B$6","v":0.53296521190502744},{"$f":"D26+2*E26*IDF!$B$6+F26*IDF!$B$6^2+G26","v":1.7539111606429127E-3}]
["i6h",-0.4425,2.7709999999999999E-2,4.5999999999999999E-2,-1.735E-3,6.5649999999999997E-5,4.6460000000000002E-4,null,{"$f":"B27+C27*IDF!$B$6","v":0.32440270173734409},{"$f":"D27+2*E27*IDF!$B$6+F27*IDF!$B$6^2+G27","v":7.1422246059612172E-4}]
["i12h",-0.3382,1.942E-2,1.371E-2,-5.1599999999999997E-4,1.9490000000000001E-5,4.2490000000000001E-5,null,{"$f":"B28+C28*IDF!$B$6","v":0.19926843983180159},{"$f":"D28+2*E28*IDF!$B$6+F28*IDF!$B$6^2+G28","v":1.1943867527024801E-4}]
["i24h",-0.25219999999999998,1.353E-2,4.1099999999999999E-3,-1.5469999999999999E-4,5.8459999999999996E-6,9.2779999999999999E-6,null,{"$f":"B29+C29*IDF!$B$6","v":0.12225664216911825},{"$f":"D29+2*E29*IDF!$B$6+F29*IDF!$B$6^2+G29","v":3.4131845476989664E-5}]
["i48h",-7.7249999999999999E-2,5.2579999999999997E-3,1.4790000000000001E-3,-5.5770000000000003E-5,2.1129999999999999E-6,1.4100000000000001E-5,null,{"$f":"B30+C30*IDF!$B$6","v":6.8270548745397161E-2},{"$f":"D30+2*E30*IDF!$B$6+F30*IDF!$B$6^2+G30","v":2.4594647338540192E-5}]
[]
[]
["L-CV"]
[]
[null,"L-CV",null,null,"Kappa"]
["Variabel","mean","res. var","pred. var.","mean","res.var.","pred. var."]
["i1m",0.54290000000000005,4.9419999999999998E-4,5.1119999999999996E-4,{"$f":"1/B37-2","v":-0.15804015472462707},{"$f":"1/B37^4*C37","v":5.6888354826815819E-3},{"$f":"1/B37^4*D37","v":5.8845258979093977E-3}]
["i2m",0.52900000000000003,3.4400000000000001E-4,3.6279999999999998E-4,{"$f":"1/B38-2","v":-0.10964083175803419},{"$f":"1/B38^4*C38","v":4.3927425860578731E-3},{"$f":"1/B38^4*D38","v":4.6328110762261518E-3}]
["i5m",0.51929999999999998,9.7979999999999994E-5,1.16E-4,{"$f":"1/B39-2","v":-7.4330829963412226E-2},{"$f":"1/B39^4*C39","v":1.3472994879938722E-3},{"$f":"1/B39^4*D39","v":1.5950881874595754E-3}]
["i10m",0.53259999999999996,1.2070000000000001E-4,1.3999999999999999E-4,{"$f":"1/B40-2","v":-0.12241832519714602},{"$f":"1/B40^4*C40","v":1.5000392456470061E-3},{"$f":"1/B40^4*D40","v":1.7398963909741577E-3}]
["i30m",0.55779999999999996,2.1680000000000001E-4,2.4159999999999999E-4,-0.20724273933309423,2.2394699440359653E-3,2.4956454726895259E-3]
["i60m",0.55769999999999997,4.8500000000000003E-4,5.195E-4,-0.20692128384436059,5.0134785438703307E-3,5.3701074299806941E-3]
["i3h",0.54800000000000004,4.8670000000000001E-4,5.3209999999999998E-4,-0.17518248175182505,5.3968346511750476E-3,5.9002583067397632E-3]
["i6h",0.54949999999999999,0,4.5380000000000003E-5,-0.18016378525932653,0,4.9772986988451862E-4]
["i12h",0.53690000000000004,3.2670000000000003E-4,3.8460000000000002E-4,-0.13745576457440878,3.9316560576596257E-3,4.6284509328922314E-3]
["i24h",0.53300000000000003,2.7149999999999999E-4,3.3520000000000002E-4,-0.12382739212007521,3.3640388125297242E-3,4.1533179004050232E-3]
["i48h",0.52339999999999998,2.7280000000000002E-4,3.4850000000000001E-4,-8.9415361100496638E-2,3.6350424990183447E-3,4.6437401426242409E-3]
["i48h",0.52769999999999995,5.241E-4,6.4190000000000004E-4,{"$f":"1/B48-2","v":-0.10498389236308481},{"$f":"1/B48^4*C48","v":6.7587406688354099E-3},{"$f":"1/B48^4*D48","v":8.2778775716951924E-3}]

{"sheet":"help1","index":4,"n_rows":27,"n_cols":23,"rows_kept":27,"cut":false,"hidden":false,"merged":[]}
["Variable","i1m",null,"i2m",null,"i5m",null,"i10m",null,"i30m",null,"i60m",null,"i3h",null,"i6h",null,"i12h",null,"i24h",null,"i48h"]
[]
["q0",{"$f":"Tables!$L$4","v":15.8},null,{"$f":"Tables!$L$5","v":12.8},null,{"$f":"Tables!$L$6","v":9},null,{"$f":"Tables!$L$7","v":6},null,{"$f":"Tables!$L$8","v":3.2},null,{"$f":"Tables!$L$9","v":2.1},null,{"$f":"Tables!$L$10","v":1.1000000000000001},null,{"$f":"Tables!$L$11","v":0.73},null,{"$f":"Tables!$L$12","v":0.45},null,{"$f":"Tables!$L$13","v":0.26},null,{"$f":"Tables!$L$14","v":0.15}]
["lambda",{"$f":"Tables!$I$4","v":4.0285941892310291},null,{"$f":"Tables!$I$5","v":4.0631382730164809},null,{"$f":"Tables!$I$6","v":3.9547242572283339},null,{"$f":"Tables!$I$7","v":4.3665298478702015},null,{"$f":"Tables!$I$8","v":3.9807320214333837},null,{"$f":"Tables!$I$9","v":3.8709498703447096},null,{"$f":"Tables!$I$10","v":3.4436649533227093},null,{"$f":"Tables!$I$11","v":3.0992231018756562},null,{"$f":"Tables!$I$12","v":2.7719805768087356},null,{"$f":"Tables!$I$13","v":2.8465299948082441},null,{"$f":"Tables!$I$14","v":3.1338764970536146}]
["mean",{"$f":"Tables!$I$20","v":6.2229999999999999},null,{"$f":"Tables!I21","v":5.9939999999999998},null,{"$f":"Tables!I22","v":4.8959999999999999},null,{"$f":"Tables!I23","v":3.577},null,{"$f":"Tables!I24","v":1.8220000000000001},null,{"$f":"Tables!I25","v":1.0960000000000001},null,{"$f":"Tables!I26","v":0.53296521190502744},null,{"$f":"Tables!I27","v":0.32440270173734409},null,{"$f":"Tables!I28","v":0.19926843983180159},null,{"$f":"Tables!I29","v":0.12225664216911825},null,{"$f":"Tables!I30","v":6.8270548745397161E-2}]
["kappa",{"$f":"Tables!$E$37","v":-0.15804015472462707},null,{"$f":"Tables!$E$38","v":-0.10964083175803419},null,{"$f":"Tables!$E$39","v":-7.4330829963412226E-2},null,{"$f":"Tables!$E$40","v":-0.12241832519714602},null,{"$f":"Tables!$E$41","v":-0.20724273933309423},null,{"$f":"Tables!$E$42","v":-0.20692128384436059},null,{"$f":"Tables!$E$43","v":-0.17518248175182505},null,{"$f":"Tables!$E$44","v":-0.18016378525932653},null,{"$f":"Tables!$E$45","v":-0.13745576457440878},null,{"$f":"Tables!$E$46","v":-0.12382739212007521},null,{"$f":"Tables!$E$47","v":-8.9415361100496638E-2}]
["V_lambda",{"$f":"Tables!$J$4","v":0.38124951944606661},null,{"$f":"Tables!$J$5","v":0.44057140706199044},null,{"$f":"Tables!$J$6","v":0.44284489164419644},null,{"$f":"Tables!$J$7","v":0.58612184297054515},null,{"$f":"Tables!$J$8","v":0.46919260533668539},null,{"$f":"Tables!$J$9","v":0.45554675078014284},null,{"$f":"Tables!$J$10","v":0.34940968704335457},null,{"$f":"Tables!$J$11","v":0.34742242069224438},null,{"$f":"Tables!$J$12","v":0.34967137884564969},null,{"$f":"Tables!$J$13","v":0.32337567896980918},null,{"$f":"Tables!$J$14","v":0.25410023501592238}]
["V_mean",{"$f":"Tables!$J$20","v":0.24111000000000002},null,{"$f":"Tables!J21","v":0.14415},null,{"$f":"Tables!J22","v":8.7299999999999989E-2},null,{"$f":"Tables!J23","v":5.0432999999999999E-2},null,{"$f":"Tables!J24","v":2.7143999999999998E-2},null,{"$f":"Tables!J25","v":1.2983999999999999E-2},null,{"$f":"Tables!J26","v":1.7539111606429127E-3},null,{"$f":"Tables!J27","v":7.1422246059612172E-4},null,{"$f":"Tables!J28","v":1.1943867527024801E-4},null,{"$f":"Tables!J29","v":3.4131845476989664E-5},null,{"$f":"Tables!J30","v":2.4594647338540192E-5}]
["V_kappa",{"$f":"Tables!$G$37","v":5.8845258979093977E-3},null,{"$f":"Tables!$G$38","v":4.6328110762261518E-3},null,{"$f":"Tables!$G$39","v":1.5950881874595754E-3},null,{"$f":"Tables!$G$40","v":1.7398963909741577E-3},null,{"$f":"Tables!$G$41","v":2.4956454726895259E-3},null,{"$f":"Tables!$G$42","v":5.3701074299806941E-3},null,{"$f":"Tables!$G$43","v":5.9002583067397632E-3},null,{"$f":"Tables!$G$44","v":4.9772986988451862E-4},null,{"$f":"Tables!$G$45","v":4.6284509328922314E-3},null,{"$f":"Tables!$G$46","v":4.1533179004050232E-3},null,{"$f":"Tables!$G$47","v":4.6437401426242409E-3}]
[]
["Min Lanbda",null,{"$f":"MIN(B4:V4)","v":2.7719805768087356}]
[]
["T","z_T","S(z_T)","z_T","S(z_T)","z_T","S(z_T)","z_T","S(z_T)","z_T","S(z_T)","z_T","S(z_T)","z_T","S(z_T)","z_T","S(z_T)","z_T","S(z_T)","z_T","S(z_T)","z_T","S(z_T)"]
[{"$f":"IDF!B8","v":5},{"$f":"B$5*(1+B$6)/B$6*(1-(1/($A14*B$4))^B$6)+B$3","v":35.934710087899958},{"$f":"SQRT(((1+B$6)*B$5*$A14*(B$4*$A14)^(-B$6-1))^2*B$7+((1+B$6)/B$6*(1-(1/($A14*B$4))^B$6))^2*B$8+((1+B$6)*B$5*((B$4*$A14)^(-B$6)/B$6*LN(B$4*$A14)-1/B$6^2*(1-(B$4*$A14)^(-B$6))))^2*B$9)","v":3.2324901594357835},{"$f":"D$5*(1+D$6)/D$6*(1-(1/($A14*D$4))^D$6)+D$3","v":31.842161189672975},{"$f":"SQRT(((1+D$6)*D$5*$A14*(D$4*$A14)^(-D$6-1))^2*D$7+((1+D$6)/D$6*(1-(1/($A14*D$4))^D$6))^2*D$8+((1+D$6)*D$5*((D$4*$A14)^(-D$6)/D$6*LN(D$4*$A14)-1/D$6^2*(1-(D$4*$A14)^(-D$6))))^2*D$9)","v":2.6766201311040834},{"$f":"F$5*(1+F$6)/F$6*(1-(1/($A14*F$4))^F$6)+F$3","v":24.142809412248006},{"$f":"SQRT(((1+F$6)*F$5*$A14*(F$4*$A14)^(-F$6-1))^2*F$7+((1+F$6)/F$6*(1-(1/($A14*F$4))^F$6))^2*F$8+((1+F$6)*F$5*((F$4*$A14)^(-F$6)/F$6*LN(F$4*$A14)-1/F$6^2*(1-(F$4*$A14)^(-F$6))))^2*F$9)","v":1.6177553092013575},{"$f":"H$5*(1+H$6)/H$6*(1-(1/($A14*H$4))^H$6)+H$3","v":17.759207846811407},{"$f":"SQRT(((1+H$6)*H$5*$A14*(H$4*$A14)^(-H$6-1))^2*H$7+((1+H$6)/H$6*(1-(1/($A14*H$4))^H$6))^2*H$8+((1+H$6)*H$5*((H$4*$A14)^(-H$6)/H$6*LN(H$4*$A14)-1/H$6^2*(1-(H$4*$A14)^(-H$6))))^2*H$9)","v":1.3547617856952057},{"$f":"J$5*(1+J$6)/J$6*(1-(1/($A14*J$4))^J$6)+J$3","v":9.184371380689738},{"$f":"SQRT(((1+J$6)*J$5*$A14*(J$4*$A14)^(-J$6-1))^2*J$7+((1+J$6)/J$6*(1-(1/($A14*J$4))^J$6))^2*J$8+((1+J$6)*J$5*((J$4*$A14)^(-J$6)/J$6*LN(J$4*$A14)-1/J$6^2*(1-(J$4*$A14)^(-J$6))))^2*J$9)","v":0.86559068915736725},{"$f":"L$5*(1+L$6)/L$6*(1-(1/($A14*L$4))^L$6)+L$3","v":5.6543643736668781},{"$f":"SQRT(((1+L$6)*L$5*$A14*(L$4*$A14)^(-L$6-1))^2*L$7+((1+L$6)/L$6*(1-(1/($A14*L$4))^L$6))^2*L$8+((1+L$6)*L$5*((L$4*$A14)^(-L$6)/L$6*LN(L$4*$A14)-1/L$6^2*(1-(L$4*$A14)^(-L$6))))^2*L$9)","v":0.62890107064041334},{"$f":"N$5*(1+N$6)/N$6*(1-(1/($A14*N$4))^N$6)+N$3","v":2.7219533627318646},{"$f":"SQRT(((1+N$6)*N$5*$A14*(N$4*$A14)^(-N$6-1))^2*N$7+((1+N$6)/N$6*(1-(1/($A14*N$4))^N$6))^2*N$8+((1+N$6)*N$5*((N$4*$A14)^(-N$6)/N$6*LN(N$4*$A14)-1/N$6^2*(1-(N$4*$A14)^(-N$6))))^2*N$9)","v":0.26177160645384473},{"$f":"P$5*(1+P$6)/P$6*(1-(1/($A14*P$4))^P$6)+P$3","v":1.6724877815595902},{"$f":"SQRT(((1+P$6)*P$5*$A14*(P$4*$A14)^(-P$6-1))^2*P$7+((1+P$6)/P$6*(1-(1/($A14*P$4))^P$6))^2*P$8+((1+P$6)*P$5*((P$4*$A14)^(-P$6)/P$6*LN(P$4*$A14)-1/P$6^2*(1-(P$4*$A14)^(-P$6))))^2*P$9)","v":0.11776533696827006},{"$f":"R$5*(1+R$6)/R$6*(1-(1/($A14*R$4))^R$6)+R$3","v":0.99430429884003835},{"$f":"SQRT(((1+R$6)*R$5*$A14*(R$4*$A14)^(-R$6-1))^2*R$7+((1+R$6)/R$6*(1-(1/($A14*R$4))^R$6))^2*R$8+((1+R$6)*R$5*((R$4*$A14)^(-R$6)/R$6*LN(R$4*$A14)-1/R$6^2*(1-(R$4*$A14)^(-R$6))))^2*R$9)","v":7.951993752162545E-2},{"$f":"T$5*(1+T$6)/T$6*(1-(1/($A14*T$4))^T$6)+T$3","v":0.59680135112493748},{"$f":"SQRT(((1+T$6)*T$5*$A14*(T$4*$A14)^(-T$6-1))^2*T$7+((1+T$6)/T$6*(1-(1/($A14*T$4))^T$6))^2*T$8+((1+T$6)*T$5*((T$4*$A14)^(-T$6)/T$6*LN(T$4*$A14)-1/T$6^2*(1-(T$4*$A14)^(-T$6))))^2*T$9)","v":4.5463401530362567E-2},{"$f":"V$5*(1+V$6)/V$6*(1-(1/($A14*V$4))^V$6)+V$3","v":0.343945220788199},{"$f":"SQRT(((1+V$6)*V$5*$A14*(V$4*$A14)^(-V$6-1))^2*V$7+((1+V$6)/V$6*(1-(1/($A14*V$4))^V$6))^2*V$8+((1+V$6)*V$5*((V$4*$A14)^(-V$6)/V$6*LN(V$4*$A14)-1/V$6^2*(1-(V$4*$A14)^(-V$6))))^2*V$9)","v":2.6839125589760159E-2}]
[]
["Dur(min)","z_T","S_T"]
[1,{"$f":"B14","v":35.934710087899958},{"$f":"C14","v":3.2324901594357835}]
[2,{"$f":"D14","v":31.842161189672975},{"$f":"E14","v":2.6766201311040834}]
[5,{"$f":"F14","v":24.142809412248006},{"$f":"G14","v":1.6177553092013575}]
[10,{"$f":"H14","v":17.759207846811407},{"$f":"I14","v":1.3547617856952057}]
[30,{"$f":"J14","v":9.184371380689738},{"$f":"K14","v":0.86559068915736725}]
[60,{"$f":"L14","v":5.6543643736668781},{"$f":"M14","v":0.62890107064041334}]
[180,{"$f":"N14","v":2.7219533627318646},{"$f":"O14","v":0.26177160645384473}]
[360,{"$f":"P14","v":1.6724877815595902},{"$f":"Q14","v":0.11776533696827006}]
[720,{"$f":"R14","v":0.99430429884003835},{"$f":"S14","v":7.951993752162545E-2}]
[1440,{"$f":"T14","v":0.59680135112493748},{"$f":"U14","v":4.5463401530362567E-2}]
[2880,{"$f":"V14","v":0.343945220788199},{"$f":"W14","v":2.6839125589760159E-2}]

{"sheet":"help3","index":5,"n_rows":32,"n_cols":18,"rows_kept":32,"cut":false,"hidden":false,"merged":[]}
["Variable",null,"bv1","bv2",null,null,null,null,null,null,null,null,"LAMBDA"]
[]
["z0",null,{"$f":"Q4","v":17},{"$f":"Q5","v":5.4},null,null,null,null,null,null,null,null,"Variable","b_0","b_1",null,"z_0","E(lambda)"]
["lambda",null,{"$f":"R4","v":2.9423724190337008},{"$f":"R5","v":3.5266693690201603},null,null,null,null,null,null,null,null,"bv1",-1.0389999999999999,6.4320000000000002E-3,null,17,{"$f":"N4+O4*IDF!$B$5","v":2.9423724190337008}]
["mean",null,{"$f":"Q10","v":11.700039758268705},{"$f":"Q11","v":5.2354987271216586},null,null,null,null,null,null,null,null,"bv2",2.4489999999999998,1.7409999999999999E-3,null,5.4,{"$f":"N5+O5*IDF!$B$5","v":3.5266693690201603}]
["kappa",null,{"$f":"O17","v":-0.17418294686872371},{"$f":"O18","v":-0.12382739212007521}]
[null,null,null,null,null,null,null,null,null,null,null,null,"MEAN"]
[]
[null,null,null,null,null,null,"Incl. koblede regn, f-faktor 0, s-faktor 1",null,null,null,null,null,"Variable","b_0","b_1",null,"E(mean)"]
["T =",{"$f":"IDF!B8","v":5},{"$f":"C$5*(1+C$6)/C$6*(1-(1/($B10*C$4))^C$6)+C$3","v":50.133059556476816},{"$f":"D$5*(1+D$6)/D$6*(1-(1/($B10*D$4))^D$6)+D$3","v":21.206875212080568},null,0.1,{"$f":"C10","v":50.133059556476816},null,null,null,null,null,"bv1",-17,1.0369999999999999,null,{"$f":"N10+O10*IDF!B6","v":11.700039758268705}]
[null,null,null,null,null,1,{"$f":"D10","v":21.206875212080568},null,null,null,null,null,"bv2",-2.5470000000000002,0.28120000000000001,null,{"$f":"N11+O11*IDF!B6","v":5.2354987271216586}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"L-CV"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Kappa"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Variable","mean","mean"]
[null,null,null,null,null,null,null,null,null,null,null,null,"bv1",0.54769999999999996,{"$f":"1/N17-2","v":-0.17418294686872371}]
[null,null,null,null,null,null,null,null,null,null,null,null,"bv2",0.53300000000000003,{"$f":"1/N18-2","v":-0.12382739212007521}]
[]
[]
[]
[]
[]
[]
[]
[null,1,{"$f":"C$5*(1+C$6)/C$6*(1-(1/($B26*C$4))^C$6)+C$3","v":28.47198215548568},11.657059360693282]
[null,2,37.062447131442489,15.537875965047771]
[null,5,50.133059556476816,21.206875212080568]
[null,10,61.503186845160791,25.943562921745098]
[null,20,74.332388109261103,31.104760821832848]
[null,50,93.852346332144037,38.644108848883334]
[null,100,110.83276029032085,44.94355176331046]