{"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","Halsnæs",null,null,null,null,null,null,"Afskærende lednings kapacitet l/s",2]
[null," ",null,null,null,null,null,null,"Volumen m³",{"$f":"IDF!M15","v":23.058614016749367}]
["Designkarakteristika",null,null,null,null,null,null,null,"Total opland (m²)",1000]
["Gentagelsesperiode (år)",10,"år"]
["Sikkerhedsfaktor (klima, fremtidig udbygning, etc)",1.07,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":"OK"},12.050163322383671,6.9969424225596558E-2,6.7903949547165382E-4,6]
["Befæstet areal (m²)",250,"m²",null,"Regnbed",{"$f":"IF(ABS((H8-B26)/H8)<0.001,\"OK\",\"Beregn\")","v":"OK"},11.187860186639966,0.125,0,1]
[null,null,null,null,"Grøft",{"$f":"IF(ABS((H9-B35)/H9)<0.001,\"OK\",\"Beregn\")","v":"OK"},12.12702796583072,0.13885745701961252,5.24378863425141E-4,2]
["Jord- og nedsivningskarakteristika ",null,null,null,"Perm. bel.",{"$f":"IF(ABS((H10-B44)/H10)<0.001,\"OK\",\"Beregn\")","v":"OK"},23.147048361451429,2,0,1]
["K (Hydraulisk  ledningsevne) - se evt måling nederst ",5.0000000000000004E-6,"m/s"]
[]
[]
["Faskine",null,null,null,"Hjælpestørrelser, faskine",null,null,null,"Dimensionerende kasseregn, Afløbsteknik s. 269"]
["Bredde",1,"m",null,"Opstuvningsvolumen",null,{"$f":"F_bredde*F_hojde*F_hulrum*F_laengde","v":12.050163322383669}," [m³]","Vr,k (mm)",40.167211074612233]
["Højde",1.3,"m",null,"Faskine volumen ",null,{"$f":"G15/F_hulrum","v":12.684382444614389}," [m³]","Varighed (h)",13.660658717668166]
["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":48.200653289534678}," [mm]"]
["Udsivning i faskinebund: 0=Nej ,1=ja",0,null,null,"Regn, der siver pr døgn ",null,{"$f":"B20*86400/B8","v":24.165012864293672}," [mm/døgn]","Karakteritika for dimensionerende kasseregn"]
["Længde faskine",{"$f":"G7/(B15*B16*B17)","v":9.7572172650879931},"m",null,"Tømmetid",{"$f":"ROUND(G19/60/60,0)","v":48},{"$f":"G15/(B20/1000)","v":172337.43957030264}," [s]","Samlet nedbør (mm)",{"$f":"J15+G18/24*J16","v":53.921794143244597}]
["Dræn kapacitet, gennemsnit",{"$f":"((B19+B15)*B16+B18*B19*B15)*B11*1000","v":6.9921912223071966E-2},"l/s",null,"Afløbstal ",null,{"$f":"B20/B8*10000","v":2.7968764889228788},"[l/sek/ha]","Intensitet (l/sek/ha)",{"$f":"J19*10000/(J16*3600)","v":10.964534332102856}]
[]
[]
["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":11.187860186639966}," [m³]","Vr,k (mm)",33.902606626181715]
["Dybde",{"$f":"G8/R_areal","v":0.44751440746559867},"m",null,"Regn, der holdes umiddelbart",null,{"$f":"G24/R_sam_opland*1000","v":40.683127951418065}," [mm]","Varighed (h)",7.1569062286740328]
["Dræn kapacitet",{"$f":"B24*B11*1000","v":0.125},"l/s",null,"Regn, der siver pr døgn ",null,{"$f":"B26*86400/R_sam_opland","v":39.272727272727273}," [mm/døgn]","Karakteritika for dimensionerende kasseregn"]
["Samlet opland (befæstet areal + eget areal)",{"$f":"B8+B24","v":275},"m²",null,"Tømmetid",{"$f":"ROUND(G27/60/60,0)","v":25},{"$f":"G24/(B26/1000)","v":89502.881493119727}," [s]","Samlet nedbør (mm)",{"$f":"J24+G26/24*J25","v":45.613907727648311}]
[null,null,null,null,"Afløbstal ",null,{"$f":"R_draenkapacitet/R_sam_opland*10000","v":4.5454545454545459},"[l/sek/ha]","Intensitet (l/sek/ha)",{"$f":"J27*10000/(J25*3600)","v":17.703920548214636}]
[]
[]
["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":12.12702796583072}," [m³]","Vr,k (mm)",33.686188793974225]
["Længde grøft",25,"m",null,"Regn, der holdes umiddelbart",null,{"$f":"G32/B36*1000","v":40.423426552769065}," [mm]","Varighed (h)",6.986389584440011]
["Dybde",{"$f":"(G9*2)/(G_bredde*G_Laengde)","v":0.48508111863322884},"m",null,"Regn, der siver pr døgn ",null,{"$f":"G32/(G35/86400)/G_sam_opl*1000","v":40.011918029309548}," [mm/døgn]","Karakteritika for dimensionerende kasseregn"]
["Dræn kapacitet, gns-snit",{"$f":"G32/G35*1000","v":0.13893027093510257},"l/s",null,"Tømmetid",{"$f":"ROUND(G35/60/60,0)","v":24},{"$f":"G_bredde/(2*B11*SQRT(1+(G_bredde/(2*G_dybde))^2))","v":87288.593653542383}," [s]","Samlet nedbør (mm)",{"$f":"J32+G34/24*J33","v":45.333640767867379}]
["Samlet opland (befæstet areal + eget areal)",{"$f":"B8+G_Laengde*G_bredde","v":300},"m²",null,"Afløbstal ",null,{"$f":"G_draenkapacitet/G_sam_opl*10000","v":4.6310090311700858},"[l/sek/ha]","Intensitet (l/sek/ha)",{"$f":"J35*10000/(J33*3600)","v":18.024586002361659}]
[]
[]
["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":23.147048361451422}," [m³]","Vr,k (mm)",19.28920696787619]
["Areal af tilstødende afvandingsareal (tag, vej, etc)",600,"m²",null,"Belægningsvolumen",null,{"$f":"P_belaegning*B43/1000","v":77.156827871504746}," [m³]","Varighed (h)",1.0224138986515521]
["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":23.147048361451422}," [mm]"]
["Dybde af lag under belægning",192.89206967876189,"mm",null,"Regn, der siver pr døgn ",null,{"$f":"G40/(G44/86400)/(P_belaegning+P_tilst_areal)*1000","v":172.8}," [mm/døgn]","Karakteritika for dimensionerende kasseregn"]
["Dræn kapacitet",{"$f":"B40*B11*1000","v":2},"l/s",null,"Tømmetid",{"$f":"ROUND(G44/60/60,0)","v":3},{"$f":"G40/(B44/1000)","v":11573.52418072571}," [s]","Samlet nedbør (mm)",{"$f":"J40+G43/24*J41","v":26.650587038167366}]
[null,null,null,null,"Afløbstal ",null,{"$f":"B44/(P_belaegning+P_tilst_areal)*10000","v":20},"[l/sek/ha]","Intensitet (l/sek/ha)",{"$f":"J44*10000/(J41*3600)","v":72.406496563661932}]
[]
[]
[]
["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/10+U7*W22/10)","v":163.07240857571966}]
["Årsmiddelnedbør [mm]",{"$f":"VLOOKUP('Input og resultat'!B2,Kommuneliste!A3:C101,2,FALSE)","v":659.18675445029498},"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":2},null,null,"Theta",{"$f":"AD11","v":4.3981942860717762},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":28.521069588601001},"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/10)/(Y22-W22^2/10)","v":0.74475786605297745},null,null,null,null,null,null,null,null,{"$f":"idftheta(AE7)","v":9.9075739476169628E-2},1]
["Gentagelsesperiode (år)",{"$f":"'Input og resultat'!B5","v":10},{"$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.07},"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":-8.3219099611397951E-2},{"$f":"AE7","v":1}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"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":40.673801348523611},{"$f":"LN(T11)","v":0.69314718055994529},{"$f":"LN(T11+$U$5)","v":1.8560158077545728},{"$f":"LN(U11)","v":3.7055841836733063},{"$f":"W11^2","v":3.4447946786348593},{"$f":"W11*X11","v":6.8776228218629809},{"$f":"$U$4*(T11+$U$5)^(-$U$7)","v":40.931991854157822},{"$f":"(LN(U11)-LN(AA11))^2","v":4.0040680032727892E-5},null,{"$f":"bisectidf(AE11,AF11,AG11,AH11)","v":4.3981942860717762},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":30.881944396854809},1.6094379124341003,2.2405175735965162,3.4301716893936778,5.0199189975948197,7.6853599505397856,30.739585058383376,2.1348556357808086E-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":22.386052249384726},2.3025850929940459,2.6671028019185479,3.108438097484933,7.1134373560017687,8.2905239593924254,22.372858168326747,3.4758361888183133E-7]
["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":11.781757267302678},3.4011973816621555,3.5380040713176562,2.4665523408929309,12.51747280866031,8.7266722241972854,11.695895453555211,5.3500104680592075E-5]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Q24*Q27*12","v":23.058614016749367},"m3",{"$f":"IF(Y27>0.1,\"ADVARSEL: Programmet har muligvis ikke optimeret korrekt\",\" \")","v":"ADVARSEL: Programmet har muligvis ikke optimeret korrekt"},null,null,null,null,{"$f":"IDF!A23","v":60},{"$f":"IDF!D23","v":7.1899907919503994},4.0943445622221004,4.165085593681054,1.9726898910576429,17.347938002689457,8.2164222460444361,7.331748794614664,3.811934806428268E-4]
["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":3.322754660601368},5.1929568508902104,5.2170975186996662,1.200794155952094,27.218106519622214,6.2646602114867296,3.3491946419341976,6.2817601673931061E-5]
["(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":2.0372096491989216},5.8861040314501558,5.8982472100663683,0.71158105251764581,34.789320151055698,4.1970809577482946,2.0166310477325498,1.030779585429544E-4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IDF!A26","v":720},{"$f":"IDF!D26","v":1.2437912745770388},6.5792512120101012,6.5853412333033239,0.21816419452961489,43.366719159044941,1.4366856658662803,1.2088985338321732,8.0966153612471476E-4]
[2,{"$f":"help1!B18","v":38.012898456564123},{"$f":"help1!C18","v":2.0958328111849984},{"$f":"$B$9*B19","v":40.673801348523611},{"$f":"IDF!$U$4*(A19+IDF!$U$5)^(-IDF!$U$7)","v":40.931991854157822},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IDF!A27","v":1440},{"$f":"IDF!D27","v":0.7361428605232021},7.2723983925700466,7.275448039254413,-0.30633107511725738,52.932144171890883,-2.2286958198245466,0.72306740632674815,3.2118928858571901E-4]
[5,{"$f":"help1!B19","v":28.861630277434401},{"$f":"help1!C19","v":1.3804952976629403},30.881944396854809,{"$f":"IDF!$U$4*(A20+IDF!$U$5)^(-IDF!$U$7)","v":30.739585058383376},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IDF!A28","v":2880},{"$f":"IDF!D28","v":0.41702020280454744},7.965545573129992,7.9670715590148369,-0.87462061038436489,63.474229226463102,-6.9681649899214699,0.43199343551352615,1.2443767009263139E-3]
[10,{"$f":"help1!B20","v":20.92154415830348},{"$f":"help1!C20","v":0.78667332899651998},22.386052249384726,{"$f":"IDF!$U$4*(A21+IDF!$U$5)^(-IDF!$U$7)","v":22.372858168326747},null,null,null,null,null,null,null,"Mellemresultater svarende til Skrift 16"]
[30,{"$f":"help1!B21","v":11.010988100282876},{"$f":"help1!C21","v":1.04390439190379},11.781757267302678,{"$f":"IDF!$U$4*(A22+IDF!$U$5)^(-IDF!$U$7)","v":11.695895453555211},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(W11:W20)","v":47.409931408606951},{"$f":"SUM(X11:X20)","v":15.63302392000022},267.22408107165802,{"$f":"SUM(Z11:Z20)","v":42.498167227392202},null,{"$f":"SUM(AB11:AB20)","v":3.0375534911864701E-3}]
[60,{"$f":"help1!B22","v":6.7196175625704662},{"$f":"help1!C22","v":0.65487119438029429},7.1899907919503994,{"$f":"IDF!$U$4*(A23+IDF!$U$5)^(-IDF!$U$7)","v":7.331748794614664},null,null,null,null,null,null,null,"i mellemresultaterne."]
[180,{"$f":"help1!B23","v":3.1053781874779141},{"$f":"help1!C23","v":0.32762122590161086},3.322754660601368,{"$f":"IDF!$U$4*(A24+IDF!$U$5)^(-IDF!$U$7)","v":3.3491946419341976},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.9039342515877768},{"$f":"help1!C24","v":0.11366876352218724},2.0372096491989216,{"$f":"IDF!$U$4*(A25+IDF!$U$5)^(-IDF!$U$7)","v":2.0166310477325498},null,null,null,null,null,null,null,"Afløbstal (mu-m/s",null,null,null,{"$f":"Q5/(Q24*10)","v":2},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":1.1624217519411577},{"$f":"help1!C25","v":7.1855447929520838E-2},1.2437912745770388,{"$f":"IDF!$U$4*(A26+IDF!$U$5)^(-IDF!$U$7)","v":1.2088985338321732},null,null,null,null,null,null,null,"Varighed (h)",null,null,null,{"$f":"W27/60","v":1.0268960487496497},null,null,null,null,"mu-m/s",1153.5315245328354,"(mm)","( … )","( … )",null,null,null,{"$f":"dbasvol(AE26,AF26,AG26,AH26,AI26)","v":-1.6596759714412903},{"$f":"U4","v":163.07240857571966},{"$f":"U7","v":0.74475786605297745},{"$f":"AE7","v":1},638,{"$f":"V27","v":2}]
[1440,{"$f":"help1!B26","v":0.68798398179738507},{"$f":"help1!C26","v":4.3748978364370784E-2},0.7361428605232021,{"$f":"IDF!$U$4*(A27+IDF!$U$5)^(-IDF!$U$7)","v":0.72306740632674815},null,null,null,null,null,null,null,"Vr,k (mm)",null,null,null,{"$f":"X27","v":19.21551168062447},null,null,"Faktisk opland",null,{"$f":"Q25","v":2},{"$f":"AD28","v":61.613762924978985},{"$f":"(U$4*(W27+U$5)^(-U$7)-V27)*W27*60/1000","v":19.21551168062447},{"$f":"$U$4*(W27+$U$5)^(-1-$U$7)*(W27+$U$5-$U$7*W27)-V27","v":0.19435743105382519},{"$f":"SQRT(Y27^2)","v":0.19435743105382519},null,null,null,"bisectvol","xl","xr","xmid","tiny"]
[2880,{"$f":"help1!B27","v":0.38973850729396953},{"$f":"help1!C27","v":2.6950094952377525E-2},0.41702020280454744,{"$f":"IDF!$U$4*(A28+IDF!$U$5)^(-IDF!$U$7)","v":0.43199343551352615},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":58.899192811929773},null,null,null,null,null,null,{"$f":"bisectvol(AE28,AF28,AG28,AH28,AE26,AF26,AG26,AI26)","v":61.613762924978985},{"$f":"0.3*W28","v":17.669757843578932},{"$f":"3*W28","v":176.69757843578932},{"$f":"(AE28+AF28)/2","v":97.18366813968413},{"$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":72400.968902856752},{"$f":"(U$4*(W31+U$5)^(-U$7)-V31)*W31*60/1000","v":126.74533357860111}]
[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},56679.534103450882,119.06601018344672]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.44E-2,44371.914283283739,111.85144360580234]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.728E-2,34736.820058709818,105.07340204584111]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.0736000000000001E-2,27193.928575801056,98.705347767761793]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.4883200000000001E-2,21288.930596868107,92.722331294881755]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.9859839999999999E-2,16666.167401850525,87.10089138196436]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3.5831808E-2,13047.209421940976,81.818960291950063]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4.2998169599999997E-2,10214.086394037056,76.85577391016048]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5.1597803519999992E-2,7996.1589862587316,72.191786230997991]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6.1917364223999988E-2,6259.8411709982547,67.808587750227304]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7.4300837068799988E-2,4900.5543228273264,63.688827290330913]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8.916100448255998E-2,3836.4284356358298,59.816136777857693]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.1,3288.713941689336,57.498903489768232]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.12,2574.5894956817347,53.996024246012837]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.14399999999999999,2015.5328766204059,50.701339636658602]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.17279999999999998,1577.8720388440156,47.60145120782034]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.20735999999999996,1235.2466188199346,44.683619542766955]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.24883199999999994,967.02024736045132,41.93569644413958]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.29859839999999993,757.03761868898823,39.346057004816188]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.35831807999999993,592.65145448053102,36.903531426119947]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.42998169599999991,463.96075680644151,34.597336764662678]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.51597803519999985,363.21446986928333,32.41700931313175]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.61917364223999982,284.34463300408339,30.352339139672338]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.74300837068799974,222.60090669659905,28.393309548291896]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,149.38528522696404,25.402280093181361]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.2,116.94716931117418,23.67416889699037]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.44,91.552795103729579,22.016372412170483]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.728,71.672656471084125,20.419487589279402]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.0735999999999999,56.109370334371839,18.874443012109275]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.4883199999999999,43.925558146290236,17.372744639437155]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.9859839999999997,34.387387471378673,15.906844830101823]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3.5831807999999996,26.920373172460145,14.470647066432216]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4.2998169599999994,21.07477610352635,13.06013400699532]
[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},16.498515268285043,11.674063716612984]
[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},12.915961940506158,10.314620048608685]
[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},10.11133851355001,8.9878417989919619]
[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},7.9157221898404888,7.7036202235808613]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,6.7856201050062213,6.9231325010192792]

{"sheet":"Kommuneliste","index":2,"n_rows":101,"n_cols":6,"rows_kept":101,"cut":false,"hidden":false,"merged":[]}
[null,"Årsmiddelnedbør","Middelværdi Klimagrid","Northing","Easting","Faskinebund"]
["Kommuner","mm","mm/dag","m","m","Nej/ja"]
["Albertslund",640.93120613344104,27.883887816645199,6175140,710791,0]
["Allerød",685.90148109916402,27.980664954474399,6195096,707641,1]
["Assens",715.00320983031304,25.8390130749906,6126050,565439]
["Ballerup",658.35836399584298,28.203187564974399,6181137,710019]
["Billund",888.55226207130499,26.431787823322999,6177641,498323]
["Bornholm",694.85653734071695,28.977950787728101,6126753,877619]
["Brøndby",637.69404606863304,27.704196220811799,6171287,714637]
["Brønderslev",756.59296932385598,27.067365368482601,6340900,565980]
["Christiansø",575.92674548849095,29.351724032698002,6148265,892218]
["Dragør",608.69892604858796,26.9475763886701,6164631,729202]
["Egedal",640.48044867487999,28.322975651501402,6184288,702479]
["Esbjerg",836.22271448582501,25.106513539742998,6140331,475667]
["Fanø",806.00790372292499,25.148578761261501,6140167,463990]
["Favrskov",670.50951171173097,24.9798061927643,6241884,558870]
["Faxe",650.68927764681098,26.784458755737699,6128922,694309]
["Fredensborg",722.50273138104399,27.484682690605101,6205785,715168]
["Fredericia",745.09731787026499,24.8424444364599,6158304,544664]
["Frederiksberg",639.26087634107103,26.930061600356002,6176349,721564]
["Frederikshavn",748.118980697501,27.293217834472902,6369756,584876]
["Frederikssund",645.09429524041502,27.7615068520813,6190689,690472]
["Furesø",681.251538803887,28.166383059245799,6189233,711119]
["Faaborg-Midtfyn",745.53943441181002,26.3664898891824,6115016,586719]
["Gentofte",668.62250798029095,27.507357870781401,6184154,722879]
["Gladsaxe",679.72623638416599,28.122859292174098,6183289,717732]
["Glostrup",645.51992551232001,27.729401370184199,6176147,713767]
["Greve",624.17897072648998,28.909395503067401,6165017,704840]
["Gribskov",690.75788372499801,28.391984702744299,6216274,700025]
["Guldborgsund",636.32357036614496,25.418483730899901,6072506,683158]
["Haderslev",841.32719277756496,24.977666344814299,6123036,521151]
["Halsnæs",659.18675445029498,28.521069588601001,6214464,680603]
["Hedensted",741.75545505869195,24.347441915804598,6183658,546660]
["Helsingør",691.13103251184498,28.575369709150099,6215578,718490]
["Herlev",674.63807605992497,28.1698392098236,6181717,715090]
["Herning",922.49671160917899,24.879885663672901,6222360,488223]
["Hillerød",717.47985079201396,28.012144220021099,6202533,702286]
["Hjørring",745.51069909882904,26.881341437176498,6369341,563173]
["Holbæk",645.62885618214796,27.4428681919693,6171549,664158]
["Holstebro",854.74653504369496,25.676488237905001,6250265,472585]
["Horsens",718.45225920308201,24.869681610444701,6195972,557305]
["Hvidovre",633.28187934501102,27.511905145030401,6170614,718180]
["Høje-Taastrup",631.24974368368703,27.963618121788201,6172586,704380]
["Hørsholm",710.41002173369998,27.6792280804552,6198682,717692]
["Ikast-Brande",842.23723884771505,25.907605612767799,6211985,516252]
["Ishøj",627.97511443979499,28.284516665704,6168424,708158]
["Jammerbugt",749.31674855434005,25.736466175660698,6337636,528838]
["Kalundborg",583.10702311312798,26.306944438464999,6173653,636338]
["Kerteminde",598.88593585085005,26.190674952595099,6148437,603683]
["Kolding",827.75652684753095,25.475743367253799,6147082,528789]
["København",633.10194008929898,26.458096006797,6175328,725775]
["Køge",642.28339729099298,27.417972913882998,6149215,694171]
["Langeland",610.27445594451206,27.894614769185701,6089983,611537]
["Lejre",643.94598970404797,27.260179943640601,6169481,684300]
["Lemvig",846.97458918736504,25.940693341414399,6265191,458064]
["Lolland",604.16264856124201,27.771258009738101,6077106,646894]
["Lyngby-Taarbæk",682.51325404467605,27.784908365893799,6187757,719786]
["Læsø",668.94824916902098,28.400295096767,6349069,622309]
["Mariagerfjord",740.59145543458396,26.119428329308001,6285038,557124]
["Middelfart",693.24049180281702,25.360802531533398,6144855,555348]
["Morsø",793.02187166387,25.6292930280182,6298092,485072]
["Norddjurs",649.707408549805,27.331217491238998,6265684,619069]
["Nordfyns",626.90747056583098,25.542383899057999,6153932,580292]
["Nyborg",668.44266114255095,26.701360491101202,6129361,607638]
["Næstved",645.05909460805401,25.6827459680526,6127462,674417]
["Odder",656.912019248516,25.007014429600101,6198964,577358]
["Odense",687.03326980476902,25.280920783289002,6138435,587298]
["Odsherred",628.53895517846195,27.7358049478696,6194279,658209]
["Randers",684.31447644456398,25.692089291762802,6266926,565781]
["Rebild",776.14451468312802,26.326018668349999,6296559,553453]
["Ringkøbing-Skjern",870.82498673426505,25.535033155634501,6208221,467531]
["Ringsted",665.06658455777301,27.7913453631081,6149417,677660]
["Roskilde",638.19519336601502,27.573034568640001,6171202,695850]
["Rudersdal",705.31886902110398,27.710273097552701,6193254,718461]
["Rødovre",646.26804868950296,27.6564823929446,6176969,717002]
["Samsø",567.85412622437798,25.594857308305301,6194234,603482]
["Silkeborg",783.11021370278195,25.404784542654699,6226357,533715]
["Skanderborg",736.20142978938804,24.686680140952099,6215944,553758]
["Skive",779.69903389893796,25.323961403349202,6280378,499080]
["Slagelse",581.13214535443001,26.087604991581401,6133333,641892]
["Solrød",632.98455454861198,28.074318438083001,6159241,700281]
["Sorø",654.65617413453901,26.7895706028274,6150817,658922]
["Stevns",627.19791716507802,28.043769763909399,6136582,708161]
["Struer",823.77041850242301,26.591505994569101,6266307,472360]
["Svendborg",725.83377048767397,26.5506545255475,6105259,603707]
["Syddjurs",653.056405981995,26.273019798533799,6237302,593128]
["Sønderborg",712.89087985263598,25.555349708712601,6090474,549254]
["Thisted",809.17043408193604,25.010100488009499,6307888,478660]
["Tønder",839.16397936923295,25.1340626561846,6101761,490764]
["Tårnby",613.64647722386701,26.782663043272301,6170134,730909]
["Vallensbæk",633.85668053010795,27.811915321835802,6170407,712354]
["Varde",893.33792139905495,25.8355823063964,6168689,467933]
["Vejen",926.61732497018795,25.767191982890999,6145805,502091]
["Vejle",832.65265728877398,24.670934284182302,6179553,525431]
["Vesthimmerlands",735.96088064697699,26.230677990563301,6298903,522297]
["Viborg",744.139937462445,25.199780462895099,6256251,523745]
["Vordingborg",629.147006046559,25.786341450334302,6100860,697314]
["Ærø",598.27763135131897,26.816652613032801,6083782,588196]
["Aabenraa",877.20593534373802,25.316322927456198,6093028,520451]
["Aalborg",715.75037541089898,28.1006107724434,6320099,554145]
["Aarhus",699.03280980948102,25.3702243586843,6224795,572535]

{"sheet":"Tables","index":3,"n_rows":47,"n_cols":12,"rows_kept":47,"cut":false,"hidden":true,"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.41959999999999997,5.8669999999999998E-3,1.018,-1.4239999999999999E-3,2.052E-6,0.25850000000000001,null,{"$f":"B4+C4*IDF!$B$5","v":4.2870486883598806},{"$f":"D4+2*E4*IDF!$B$5+F4*IDF!$B$5^2+G4","v":0.29078589102760816},null,16.7]
["i2m",0.82350000000000001,3.5630000000000002E-3,0.47949999999999998,-6.5200000000000002E-4,9.3379999999999996E-7,7.1230000000000002E-2,null,{"$f":"B5+C5*IDF!$B$5","v":3.1721824061064012},{"$f":"D5+2*E5*IDF!$B$5+F5*IDF!$B$5^2+G5","v":9.6911950306061131E-2},null,14.9]
["i5m",1.476,2.3579999999999999E-3,0.42599999999999999,-5.7839999999999996E-4,8.2880000000000001E-7,5.9540000000000003E-2,null,{"$f":"B6+C6*IDF!$B$5","v":3.0303623669937956},{"$f":"D6+2*E6*IDF!$B$5+F6*IDF!$B$5^2+G6","v":8.3128886950659814E-2},null,10.6]
["i10m",1.849,1.6169999999999999E-3,0.48909999999999998,-6.7159999999999995E-4,9.6059999999999996E-7,7.8719999999999998E-2,null,{"$f":"B7+C7*IDF!$B$5","v":2.914904981946127},{"$f":"D7+2*E7*IDF!$B$5+F7*IDF!$B$5^2+G7","v":9.9807157881714445E-2},null,7.34]
["i30m",1.825,1.6080000000000001E-3,0.42620000000000002,-5.7779999999999995E-4,8.2529999999999996E-7,5.4339999999999999E-2,null,{"$f":"B8+C8*IDF!$B$5","v":2.8849723011560746},{"$f":"D8+2*E8*IDF!$B$5+F8*IDF!$B$5^2+G8","v":7.7399065935650657E-2},null,3.74]
["i60m",2.0720000000000001,1.2160000000000001E-3,0.51719999999999999,-7.0540000000000002E-4,1.0049999999999999E-6,7.3260000000000006E-2,null,{"$f":"B9+C9*IDF!$B$5","v":2.8735710934115586},{"$f":"D9+2*E9*IDF!$B$5+F9*IDF!$B$5^2+G9","v":9.7179139950450813E-2},null,2.39]
["i3h",1.1970000000000001,2.4870000000000001E-3,0.63429999999999997,-8.7089999999999997E-4,1.238E-6,9.6589999999999995E-2,null,{"$f":"B10+C10*IDF!$B$5","v":2.8363974583178839},{"$f":"D10+2*E10*IDF!$B$5+F10*IDF!$B$5^2+G10","v":0.12066315652495556},null,1.19]
["i6h",6.1269999999999998E-2,4.1479999999999998E-3,0.77590000000000003,-1.07E-3,1.522E-6,0.13669999999999999,null,{"$f":"B11+C11*IDF!$B$5","v":2.7955766574598235},{"$f":"D11+2*E11*IDF!$B$5+F11*IDF!$B$5^2+G11","v":0.16329070923977879},null,0.753]
["i12h",-1.19,5.986E-3,0.72199999999999998,-9.8970000000000004E-4,1.407E-6,0.1183,null,{"$f":"B12+C12*IDF!$B$5","v":2.7558919121394658},{"$f":"D12+2*E12*IDF!$B$5+F12*IDF!$B$5^2+G12","v":0.14688547662158408},null,0.45300000000000001]
["i24h",-2.3260000000000001,7.5890000000000003E-3,0.66320000000000001,-9.0609999999999996E-4,1.288E-6,0.1028,null,{"$f":"B13+C13*IDF!$B$5","v":2.676568279523289},{"$f":"D13+2*E13*IDF!$B$5+F13*IDF!$B$5^2+G13","v":0.13109276787379054},null,0.26700000000000002]
["i48h",-3.6629999999999998,9.5809999999999992E-3,0.48449999999999999,-6.5379999999999995E-4,9.3030000000000001E-7,5.6930000000000001E-2,null,{"$f":"B14+C14*IDF!$B$5","v":2.6526682943882762},{"$f":"D14+2*E14*IDF!$B$5+F14*IDF!$B$5^2+G14","v":8.3718032869690678E-2},null,0.16]
[]
[]
["MEAN"]
[]
["Variabel","b_0","b_1","V(b_0)","Cov","V(b_1)","Res.var.",null,"E(Mean)","V(Mean)"]
["i1m",5.3940000000000001,0,1.7299999999999999E-2,0,0,0.16270000000000001,null,{"$f":"B20+C20*IDF!$B$6","v":5.3940000000000001},{"$f":"D20+2*E20*IDF!$B$6+F20*IDF!$B$6^2+G20","v":0.18000000000000002}]
["i2m",5.6879999999999997,0,1.993E-2,0,0,0.1691,null,{"$f":"B21+C21*IDF!$B$6","v":5.6879999999999997},{"$f":"D21+2*E21*IDF!$B$6+F21*IDF!$B$6^2+G21","v":0.18903}]
["i5m",4.7910000000000004,0,1.2760000000000001E-2,0,0,6.9800000000000001E-2,null,{"$f":"B22+C22*IDF!$B$6","v":4.7910000000000004},{"$f":"D22+2*E22*IDF!$B$6+F22*IDF!$B$6^2+G22","v":8.2559999999999995E-2}]
["i10m",3.8769999999999998,0,7.3029999999999996E-3,0,0,1.0370000000000001E-2,null,{"$f":"B23+C23*IDF!$B$6","v":3.8769999999999998},{"$f":"D23+2*E23*IDF!$B$6+F23*IDF!$B$6^2+G23","v":1.7673000000000001E-2}]
["i30m",1.9510000000000001,0,2.552E-3,0,0,1.057E-2,null,{"$f":"B24+C24*IDF!$B$6","v":1.9510000000000001},{"$f":"D24+2*E24*IDF!$B$6+F24*IDF!$B$6^2+G24","v":1.3122E-2}]
["i60m",1.163,0,1.116E-3,0,0,6.9639999999999997E-3,null,{"$f":"B25+C25*IDF!$B$6","v":1.163},{"$f":"D25+2*E25*IDF!$B$6+F25*IDF!$B$6^2+G25","v":8.0800000000000004E-3}]
["i3h",0.21179999999999999,1.0789999999999999E-2,8.5050000000000001E-2,-3.2200000000000002E-3,1.2229999999999999E-4,1.0889999999999999E-3,null,{"$f":"B26+C26*IDF!$B$6","v":0.5195423408610047},{"$f":"D26+2*E26*IDF!$B$6+F26*IDF!$B$6^2+G26","v":1.948419350847032E-3}]
["i6h",9.7719999999999994E-3,1.064E-2,2.8889999999999999E-2,-1.0920000000000001E-3,4.1399999999999997E-5,2.2939999999999999E-4,null,{"$f":"B27+C27*IDF!$B$6","v":0.31323618042271467},{"$f":"D27+2*E27*IDF!$B$6+F27*IDF!$B$6^2+G27","v":5.0627241227718905E-4}]
["i12h",-0.1288,1.1339999999999999E-2,8.8039999999999993E-3,-3.3270000000000001E-4,1.2629999999999999E-5,3.256E-5,null,{"$f":"B28+C28*IDF!$B$6","v":0.19462892913473537},{"$f":"D28+2*E28*IDF!$B$6+F28*IDF!$B$6^2+G28","v":1.3253161007976874E-4}]
["i24h",-9.4140000000000001E-2,7.4469999999999996E-3,3.7030000000000001E-3,-1.3990000000000001E-4,5.3129999999999998E-6,4.4280000000000003E-5,null,{"$f":"B29+C29*IDF!$B$6","v":0.11825640522631164},{"$f":"D29+2*E29*IDF!$B$6+F29*IDF!$B$6^2+G29","v":8.8952072978100937E-5}]
["i48h",-7.7879999999999998E-3,2.6199999999999999E-3,1.225E-3,-4.6260000000000001E-5,1.7579999999999999E-6,1.502E-5,null,{"$f":"B30+C30*IDF!$B$6","v":6.6937202322134612E-2},{"$f":"D30+2*E30*IDF!$B$6+F30*IDF!$B$6^2+G30","v":3.1298221282644549E-5}]
[]
[]
["L-CV"]
[]
[null,"L-CV",null,null,"Kappa"]
["Variabel","mean","res. var","pred. var.","mean","res.var.","pred. var."]
["i1m",0.62019999999999997,1.908E-4,2.0770000000000001E-4,-0.38761689777491126,1.2895890081734539E-3,1.4038136110986709E-3]
["i2m",0.56459999999999999,0,1.842E-5,-0.22883457314913214,0,1.8127008175339125E-4]
["i5m",0.54349999999999998,0,2.037E-5,-0.16007359705611779,0,2.334494393717262E-4]
["i10m",0.51429999999999998,0,2.1679999999999999E-5,-5.5609566400933286E-2,0,3.0987973834140802E-4]
["i30m",0.54179999999999995,3.7530000000000002E-4,4.0880000000000002E-4,-0.15430047988187501,4.3553449914132169E-3,4.7441114641346201E-3]
["i60m",0.54200000000000004,3.5609999999999998E-4,3.9389999999999998E-4,-0.15498154981549828,4.1264332808979539E-3,4.5644539998475264E-3]
["i3h",0.53979999999999995,4.684E-4,5.1570000000000001E-4,-0.14746202297147071,5.5167761911268601E-3,6.0738716519302344E-3]
["i6h",0.54079999999999995,0,4.0609999999999999E-5,-0.15088757396449681,0,4.7477326760208931E-4]
["i12h",0.53959999999999997,5.9559999999999999E-5,1.044E-4,-0.14677538917716815,7.025333169944683E-4,1.2314385207223388E-3]
["i24h",0.53369999999999995,0,5.0210000000000002E-5,-0.12628817687839589,0,6.1887282090410253E-4]
["i48h",0.51880000000000004,7.2910000000000005E-5,1.3420000000000001E-4,-7.2474942174248325E-2,1.0064384694005808E-3,1.852476239110656E-3]

{"sheet":"help1","index":4,"n_rows":27,"n_cols":23,"rows_kept":27,"cut":false,"hidden":true,"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":16.7},null,{"$f":"Tables!$L$5","v":14.9},null,{"$f":"Tables!$L$6","v":10.6},null,{"$f":"Tables!$L$7","v":7.34},null,{"$f":"Tables!$L$8","v":3.74},null,{"$f":"Tables!$L$9","v":2.39},null,{"$f":"Tables!$L$10","v":1.19},null,{"$f":"Tables!$L$11","v":0.753},null,{"$f":"Tables!$L$12","v":0.45300000000000001},null,{"$f":"Tables!$L$13","v":0.26700000000000002},null,{"$f":"Tables!$L$14","v":0.16}]
["lambda",{"$f":"Tables!$I$4","v":4.2870486883598806},null,{"$f":"Tables!$I$5","v":3.1721824061064012},null,{"$f":"Tables!$I$6","v":3.0303623669937956},null,{"$f":"Tables!$I$7","v":2.914904981946127},null,{"$f":"Tables!$I$8","v":2.8849723011560746},null,{"$f":"Tables!$I$9","v":2.8735710934115586},null,{"$f":"Tables!$I$10","v":2.8363974583178839},null,{"$f":"Tables!$I$11","v":2.7955766574598235},null,{"$f":"Tables!$I$12","v":2.7558919121394658},null,{"$f":"Tables!$I$13","v":2.676568279523289},null,{"$f":"Tables!$I$14","v":2.6526682943882762}]
["mean",{"$f":"Tables!$I$20","v":5.3940000000000001},null,{"$f":"Tables!I21","v":5.6879999999999997},null,{"$f":"Tables!I22","v":4.7910000000000004},null,{"$f":"Tables!I23","v":3.8769999999999998},null,{"$f":"Tables!I24","v":1.9510000000000001},null,{"$f":"Tables!I25","v":1.163},null,{"$f":"Tables!I26","v":0.5195423408610047},null,{"$f":"Tables!I27","v":0.31323618042271467},null,{"$f":"Tables!I28","v":0.19462892913473537},null,{"$f":"Tables!I29","v":0.11825640522631164},null,{"$f":"Tables!I30","v":6.6937202322134612E-2}]
["kappa",{"$f":"Tables!$E$37","v":-0.38761689777491126},null,{"$f":"Tables!$E$38","v":-0.22883457314913214},null,{"$f":"Tables!$E$39","v":-0.16007359705611779},null,{"$f":"Tables!$E$40","v":-5.5609566400933286E-2},null,{"$f":"Tables!$E$41","v":-0.15430047988187501},null,{"$f":"Tables!$E$42","v":-0.15498154981549828},null,{"$f":"Tables!$E$43","v":-0.14746202297147071},null,{"$f":"Tables!$E$44","v":-0.15088757396449681},null,{"$f":"Tables!$E$45","v":-0.14677538917716815},null,{"$f":"Tables!$E$46","v":-0.12628817687839589},null,{"$f":"Tables!$E$47","v":-7.2474942174248325E-2}]
["V_lambda",{"$f":"Tables!$J$4","v":0.29078589102760816},null,{"$f":"Tables!$J$5","v":9.6911950306061131E-2},null,{"$f":"Tables!$J$6","v":8.3128886950659814E-2},null,{"$f":"Tables!$J$7","v":9.9807157881714445E-2},null,{"$f":"Tables!$J$8","v":7.7399065935650657E-2},null,{"$f":"Tables!$J$9","v":9.7179139950450813E-2},null,{"$f":"Tables!$J$10","v":0.12066315652495556},null,{"$f":"Tables!$J$11","v":0.16329070923977879},null,{"$f":"Tables!$J$12","v":0.14688547662158408},null,{"$f":"Tables!$J$13","v":0.13109276787379054},null,{"$f":"Tables!$J$14","v":8.3718032869690678E-2}]
["V_mean",{"$f":"Tables!$J$20","v":0.18000000000000002},null,{"$f":"Tables!J21","v":0.18903},null,{"$f":"Tables!J22","v":8.2559999999999995E-2},null,{"$f":"Tables!J23","v":1.7673000000000001E-2},null,{"$f":"Tables!J24","v":1.3122E-2},null,{"$f":"Tables!J25","v":8.0800000000000004E-3},null,{"$f":"Tables!J26","v":1.948419350847032E-3},null,{"$f":"Tables!J27","v":5.0627241227718905E-4},null,{"$f":"Tables!J28","v":1.3253161007976874E-4},null,{"$f":"Tables!J29","v":8.8952072978100937E-5},null,{"$f":"Tables!J30","v":3.1298221282644549E-5}]
["V_kappa",{"$f":"Tables!$G$37","v":1.4038136110986709E-3},null,{"$f":"Tables!$G$38","v":1.8127008175339125E-4},null,{"$f":"Tables!$G$39","v":2.334494393717262E-4},null,{"$f":"Tables!$G$40","v":3.0987973834140802E-4},null,{"$f":"Tables!$G$41","v":4.7441114641346201E-3},null,{"$f":"Tables!$G$42","v":4.5644539998475264E-3},null,{"$f":"Tables!$G$43","v":6.0738716519302344E-3},null,{"$f":"Tables!$G$44","v":4.7477326760208931E-4},null,{"$f":"Tables!$G$45","v":1.2314385207223388E-3},null,{"$f":"Tables!$G$46","v":6.1887282090410253E-4},null,{"$f":"Tables!$G$47","v":1.852476239110656E-3}]
[]
["Min Lanbda",null,{"$f":"MIN(B4:V4)","v":2.6526682943882762}]
[]
["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":10},{"$f":"B$5*(1+B$6)/B$6*(1-(1/($A14*B$4))^B$6)+B$3","v":44.753137891037561},{"$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.7409628688464718},{"$f":"D$5*(1+D$6)/D$6*(1-(1/($A14*D$4))^D$6)+D$3","v":38.012898456564123},{"$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.0958328111849984},{"$f":"F$5*(1+F$6)/F$6*(1-(1/($A14*F$4))^F$6)+F$3","v":28.861630277434401},{"$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.3804952976629403},{"$f":"H$5*(1+H$6)/H$6*(1-(1/($A14*H$4))^H$6)+H$3","v":20.92154415830348},{"$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":0.78667332899651998},{"$f":"J$5*(1+J$6)/J$6*(1-(1/($A14*J$4))^J$6)+J$3","v":11.010988100282876},{"$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":1.04390439190379},{"$f":"L$5*(1+L$6)/L$6*(1-(1/($A14*L$4))^L$6)+L$3","v":6.7196175625704662},{"$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.65487119438029429},{"$f":"N$5*(1+N$6)/N$6*(1-(1/($A14*N$4))^N$6)+N$3","v":3.1053781874779141},{"$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.32762122590161086},{"$f":"P$5*(1+P$6)/P$6*(1-(1/($A14*P$4))^P$6)+P$3","v":1.9039342515877768},{"$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.11366876352218724},{"$f":"R$5*(1+R$6)/R$6*(1-(1/($A14*R$4))^R$6)+R$3","v":1.1624217519411577},{"$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.1855447929520838E-2},{"$f":"T$5*(1+T$6)/T$6*(1-(1/($A14*T$4))^T$6)+T$3","v":0.68798398179738507},{"$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.3748978364370784E-2},{"$f":"V$5*(1+V$6)/V$6*(1-(1/($A14*V$4))^V$6)+V$3","v":0.38973850729396953},{"$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.6950094952377525E-2}]
[]
["Dur(min)","z_T","S_T"]
[1,{"$f":"B14","v":44.753137891037561},{"$f":"C14","v":3.7409628688464718}]
[2,{"$f":"D14","v":38.012898456564123},{"$f":"E14","v":2.0958328111849984}]
[5,{"$f":"F14","v":28.861630277434401},{"$f":"G14","v":1.3804952976629403}]
[10,{"$f":"H14","v":20.92154415830348},{"$f":"I14","v":0.78667332899651998}]
[30,{"$f":"J14","v":11.010988100282876},{"$f":"K14","v":1.04390439190379}]
[60,{"$f":"L14","v":6.7196175625704662},{"$f":"M14","v":0.65487119438029429}]
[180,{"$f":"N14","v":3.1053781874779141},{"$f":"O14","v":0.32762122590161086}]
[360,{"$f":"P14","v":1.9039342515877768},{"$f":"Q14","v":0.11366876352218724}]
[720,{"$f":"R14","v":1.1624217519411577},{"$f":"S14","v":7.1855447929520838E-2}]
[1440,{"$f":"T14","v":0.68798398179738507},{"$f":"U14","v":4.3748978364370784E-2}]
[2880,{"$f":"V14","v":0.38973850729396953},{"$f":"W14","v":2.6950094952377525E-2}]

{"sheet":"help3","index":5,"n_rows":32,"n_cols":18,"rows_kept":32,"cut":false,"hidden":true,"merged":[]}
["Variable",null,"bv1","bv2",null,null,null,null,null,null,null,null,"LAMBDA"]
[]
["z0",null,{"$f":"Q4","v":17.8},{"$f":"Q5","v":6.26},null,null,null,null,null,null,null,null,"Variable","b_0","b_1",null,"z_0","E(lambda)"]
["lambda",null,{"$f":"R4","v":2.6716217493112739},{"$f":"R5","v":2.9049596495686352},null,null,null,null,null,null,null,null,"bv1",-2.855,8.3840000000000008E-3,null,17.8,{"$f":"N4+O4*IDF!$B$5","v":2.6716217493112739}]
["mean",null,{"$f":"Q10","v":12.012207371918729},{"$f":"Q11","v":4.9800000000000004},null,null,null,null,null,null,null,null,"bv2",1.9319999999999999,1.4760000000000001E-3,null,6.26,{"$f":"N5+O5*IDF!$B$5","v":2.9049596495686352}]
["kappa",null,{"$f":"O17","v":-0.16412704240866516},{"$f":"O18","v":-0.22127356812522248}]
[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":10},{"$f":"C$5*(1+C$6)/C$6*(1-(1/($B10*C$4))^C$6)+C$3","v":61.518861740077242},{"$f":"D$5*(1+D$6)/D$6*(1-(1/($B10*D$4))^D$6)+D$3","v":25.668994934488552},null,0.1,{"$f":"C10","v":61.518861740077242},null,null,null,null,null,"bv1",-11.01,0.80720000000000003,null,{"$f":"N10+O10*IDF!B6","v":12.012207371918729}]
[null,null,null,null,null,1,{"$f":"D10","v":25.668994934488552},null,null,null,null,null,"bv2",4.9800000000000004,0,null,{"$f":"N11+O11*IDF!B6","v":4.9800000000000004}]
[]
[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.54469999999999996,{"$f":"1/N17-2","v":-0.16412704240866516}]
[null,null,null,null,null,null,null,null,null,null,null,null,"bv2",0.56220000000000003,{"$f":"1/N18-2","v":-0.22127356812522248}]
[]
[]
[]
[]
[]
[]
[]
[null,1,{"$f":"C$5*(1+C$6)/C$6*(1-(1/($B26*C$4))^C$6)+C$3","v":28.507078835367025},10.924335718456634]
[null,2,37.168150368303728,14.602668098560695]
[null,5,50.239318717982556,20.417117803521705]
[null,10,61.518861740077242,25.668994934488552]
[null,20,74.157452976880435,31.79143494339305]
[null,50,93.231438583718557,41.469358476341718]
[null,100,109.69101094171909,50.210902019933158]