{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["Volumenberegning","Volumenberegning idé til model","Eksempel","Vandmængdematriks","Disclaimer","Simpel volumenberegningsmodel","Tidl udkast","Find sumpvolumen - simpel","Find sumpvolumen - avanceret","Tabeller"],"not_rendered":{"charts":0,"images":11,"macros":1,"external_links":0,"defined_names":0,"comments":2,"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":"Volumenberegning","index":0,"n_rows":122,"n_cols":30,"rows_kept":122,"cut":false,"hidden":true,"merged":[[4,23,4,29],[10,23,10,29],[44,2,44,4],[45,2,45,4],[46,2,46,4],[44,5,44,7],[45,5,45,7],[46,5,46,7],[38,2,38,4],[39,2,39,4],[40,2,40,4],[38,5,38,7],[39,5,39,7],[40,5,40,7],[33,2,33,4],[34,2,34,4],[35,2,35,4],[36,2,36,4],[33,5,33,7],[34,5,34,7],[35,5,35,7],[36,5,36,7],[26,2,26,4],[26,5,26,7],[28,2,28,4],[29,2,29,4],[28,5,28,7],[29,5,29,7],[22,2,22,4],[22,5,22,7],[23,5,23,7],[23,2,23,4],[25,2,25,4],[25,5,25,7],[3,5,3,6],[3,2,3,3],[19,2,19,4],[20,2,20,4],[19,5,19,7],[20,5,20,7],[79,2,79,4],[79,5,79,7],[74,2,74,4],[74,5,74,7],[75,2,75,4],[75,5,75,7],[72,2,72,4],[72,5,72,7],[97,2,97,3],[97,5,97,6],[91,2,91,4],[91,5,91,7],[90,2,90,4],[90,5,90,7],[81,2,81,4],[81,5,81,7],[84,2,84,4],[84,5,84,7],[82,2,82,4],[82,5,82,7],[80,2,80,4],[80,5,80,7],[68,2,68,4],[68,5,68,7],[69,2,69,4],[69,5,69,7],[71,2,71,4],[71,5,71,7],[51,2,51,3],[51,5,51,6],[65,2,65,4],[65,5,65,7],[66,2,66,4],[66,5,66,7],[85,2,85,4],[85,5,85,7],[86,2,86,4],[86,5,86,7],[92,2,92,4],[92,5,92,7],[111,2,111,4],[111,5,111,7],[112,2,112,4],[112,5,112,7],[114,2,114,4],[114,5,114,7],[120,2,120,4],[120,5,120,7],[121,2,121,4],[121,5,121,7],[115,2,115,4],[115,5,115,7],[117,2,117,4],[117,5,117,7],[118,2,118,4],[118,5,118,7]]}
[]
[]
[null,"Beregningseksempler"]
[null,null,"Branche-enheder",null,null,"SI-enhed",null,null,null,null,null,"Dimensioneringsparametre"]
[null,"Sumpdiameter",1.45,"mvs",null,{"$f":"C5","v":1.45},"m",null,null,null,null,"Pumpeinstallation",null,"[-]","Dykket ",null,null,null,null,null,null,null,null,"Dykkede pumper"]
[null,"Sumpoverflade",10,"m2",null,10,"m2",null,null,null,null,"Pumpekapacitet",null,"[l/s]",20,null,null,null,null,null,null,null,"Motorstørrelse","kW","<4,0","4-7,5","7,5-11","11-30","30-100",">100"]
[null,"Startkote pumpe 1",11,"m",null,11,"m",null,null,null,null,"Geometrisk trykhøjde",null,"[m]",10,null,null,null,null,null,null,null,"Højeste tilladte antal starter","z/time",30,25,15,10,8,6]
[null,"Startkote pumpe 2",12,"m",null,11.5,"m",null,null,null,null,"Trykledningsmateriale",null,"[-]","PE100",null,null,null,null,null,null,null,"Korteste tid mellem starter [minutter]","T minimum_minut",2,2.4,4,6,7.5,10]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Korteste tid mellem starter [sekunder]","T minimum_sekund",{"$f":"Y8*60","v":120},144,240,360,450,600]
[null,"Pumpekapacitet:",100,"l/s",null,{"$f":"C10/1000","v":0.1},"m3/s",null,null,null,null,"Trykklasse",null,"[SDR]",17]
[null,"Trykhøjde:",20,"mvs",null,{"$f":"C11","v":20},"m ",null,null,null,null,"Trykledningslængde",null,"[m]",2000,null,null,null,null,null,null,null,null,"Tørtopstillede pumper"]
[null,"Optaget effekt:",45,"kW",null,{"$f":"C12","v":45},"kW",null,null,null,null,"Trykledningsdimension",null,"[mm]",225,null,null,null,null,null,null,null,"Motorstørrelse","kW","<4,0","4-7,5","7,5-11","11-30","30-100",">100"]
[null,"Antal pumper",2,"n",null,2,"n",null,null,null,null,"Trykledningsruhed",null,"[mm]",0.3,null,null,null,null,null,null,null,"Højeste tilladte antal starter","z/time",20,15,12,10,8,4]
[null,"Tilladt antal starter jf. tabel 2",10,"z/h",null,10,"z/h",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Korteste tid mellem starter [minutter]","T minimum_minut",3,4,5,6,7.5,15]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Korteste tid mellem starter [sekunder]","T minimum_sekund",{"$f":"Y14*60","v":180},240,300,360,450,900]
[null,"Tminimum jf tabel 2",360,"sekunder",null,360,"sekunder",null,null,null,null,"Resultater"]
[null,null,null,null,null,null,null,null,null,null,null,"Beregnet trykledningsmodstand",null,"[m]",9.92]
[null,"Solodrift 1 pumpe",null,null,null,null,null,null,null,null,null,"Systemmodstand",null,"[m]",19.920000000000002]
[null,"Metode 1: formel 6",null,null,null,null,null,null,null,null,null,"Effektoptag (P1)",null,"[kW]",6.3]
[null,"Mindste sumpvolumen","Vminimum = 0,25 ∙ Qpumpe ∙ Tminimum →",null,null,"Vminimum = 0,25 ∙ 0,045 ∙ 180 =",null,null,{"$f":"0.25*F10*C16","v":9},"m3",null,"Tilladeligt antal starter jf. tabel 2",null,"[z/h]",25]
[null,"Afstand mellem P1start og P1stop","ΔH = Vminimum / Sumpoverflade",null,null,"ΔH = 2,025 / 1,77",null,null,{"$f":"I20/$F$6","v":0.9},"m",null,"Korteste tid mellem starter",null,"[Tmin_sek]",144]
[null,"Metode 3: formel 10"]
[null,"Mindste sumpvolumen","Vminimum = Qpumpe ∙ 900 / n ∙ z →",null,null,"Vminimum = 0,045 ∙ 900 / 1* 20 =",null,null,{"$f":"F10*900/1/F14","v":9},"m3"]
[null,"Afstand mellem P1start og P1stop","ΔH = Vminimum / Sumpoverflade",null,null,"ΔH = 2,025 / 1,77",null,null,{"$f":"I23/$F$6","v":0.9},"m"]
[null,"Tommelfinger regel 1.1, jf. afsnit 3.5: ","1 minuts driftsvolumen"]
[null,"Mindste sumpvolumen","Vminimum = 60 · Qpumpe Vtotal →",null,null,"Vminimum = 60 · 0,045 =",null,null,{"$f":"60*F10","v":6},"m3"]
[null,"Afstand mellem P1start og P1stop","ΔH = Vminimum / Sumpoverflade",null,null,"ΔH = 2,700 / 1,77",null,null,{"$f":"I26/$F$6","v":0.6},"m"]
[null,"Tommelfinger regel 2.1, jf. afsnit 3.5: ","3 minutters driftsvolumen"]
[null,"Mindste sumpvolumen","Vminimum = 3 ·60 · Qpumpe →",null,null,"Vminimum = 3 ·60 · 0,045 =",null,null,{"$f":"3*60*F10","v":18},"m3"]
[null,"Afstand mellem P1start og P1stop","ΔH = Vminimum / Sumpoverflade",null,null,"ΔH = 8,1 / 1,77",null,null,{"$f":"I29/$F$6","v":1.8},"m"]
[]
[null,"Paralleldrift 2 pumper"]
[null,"Metode 2: formel 7 og formel 8"]
[null,"Volumen mellem pumpestarter:","ΔV = Aoverflade · (StartkoteP2 - StartkoteP1) →",null,null,"ΔV= 1,77 ∙ (12-11,5) =",null,null,{"$f":"(F8-F7)*F6","v":5},"m3"]
[null,"Beregnet akkumuleret volumen","Vtotal = Vminimum / n + ((n-1) ∙ ΔV) →",null,null,"Vtotal = 2,0 / 2 + ((2-1) ∙ 1,77)",null,null,{"$f":"I23/F13+((F13-1)*I34)","v":9.5},"m3"]
[null,"Beregnet volumen P1start- P1stop","Vminimum P1 = VP1start - VP1stop = Vtotal/n",null,null,"Vminimum P1 = Vtotal /2",null,null,0.94803646691106458,"m3",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"3556/425","v":8.3670588235294119}]
[null,"Afstand mellem P1start- P1stop","ΔH = VminimumP1 / Sumpoverflade",null,null,"ΔH =0,948 / 1,77",null,null,{"$f":"I36/F6","v":9.4803646691106455E-2},"m3",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"3217/343","v":9.3790087463556855}]
[null,"Tommelfinger regel 1.2, jf. afsnit 3.5: ","90 gange Qpumpe, 1,5 minutterss driftsvolumen akkumuleret"]
[null,"Mindste totale sumpvolumen","Vtotal = 90 · Qpumpe →",null,null,"Vtotal = 90 · 0,045 =",null,null,{"$f":"90*F10","v":9},"m3"]
[null,"Beregnet volumen P1start- P1stop","Vminimum P1 = Vtotal/n",null,null,"Vminimum P1 = 4,050/2",null,null,{"$f":"I39/2","v":4.5},"m3"]
[null,"Afstand mellem P1start- P1stop","ΔH = VminimumP1 / Sumpoverflade",null,null,"ΔH =2,025 / 1,77",null,null,{"$f":"I40/F6","v":0.45},"m"]
[null,null,null,null,null,null,null,null,null," "]
[null,"Solo eller paralleldrift"]
[null,"Metode 3: formel 10 - 2 pumper i paralleldrift"]
[null,"Volumen til hver pumpe","V minimum P1 = Qpumpe ∙ 900 / n ∙ z →",null,null,"Vminimum = 0,045 ∙ 900 / 2 · 20 =",null,null,{"$f":"F10*900/F13/F14","v":4.5},"m3"]
[null,"Totalt volumen","Vtotal = VminimumP1 * n →",null,null,"Vtotal = 1,0 ∙ 2",null,null,{"$f":"I45*F13","v":9},"m3"]
[null,"Afstand mellem Pxstart og Pxstop","ΔH = VminimumP1 / Sumpoverflade",null,null,"ΔH =1,013 / 1,77",null,null,{"$f":"I45/F6","v":0.45},"m"]
[]
[]
[]
[null,"Beregningseksempler på case"]
[null,null,"Branche-enheder",null,null,"SI-enhed"]
[null,"Sumpdiameter",2.4,"mvs",null,{"$f":"C53","v":2.4},"m"]
[null,"Sumpoverflade",{"$f":"PI()*((C53/2)^2)","v":4.5238934211693023},"m2",null,{"$f":"C54","v":4.5238934211693023},"m2"]
[null,"Startkote pumpe 1",11,"m",null,11,"m"]
[null,"Startkote pumpe 2",12,"m",null,12,"m"]
[null,"Pumpekapacitet:",78,"l/s",null,{"$f":"C57/1000","v":7.8E-2},"m3/s"]
[null,"Trykhøjde:",25.9,"mvs",null,{"$f":"C58","v":25.9},"m ",null,null,null,null,{"$f":"281/3.6","v":78.055555555555557}]
[null,"Optaget effelt:",26.4,"kW",null,{"$f":"C59","v":26.4},"kW"]
[null,"Antal pumper",1,"n",null,1,"n"]
[null,"Tilladt antal starter jf. tabel 2",15,"z/h",null,15,"z/h"]
[null,"Tminimum jf tabel 2",240,"sekunder",null,240,"sekunder"]
[]
[null,"Solodrift 1 pumpe"]
[null,"Metode 1: formel 6"]
[null,"Mindste sumpvolumen","Vminimum = 0,25 ∙ Qpumpe ∙ Tminimum →",null,null,"Vminimum = 0,25 ∙ 0,078 ∙ 180 =",null,null,{"$f":"0.25*F57*C62","v":4.68},"m3"]
[null,"Afstand mellem P1start og P1stop","ΔH = Vminimum / Sumpoverflade",null,null,"ΔH = 4,68 / 4,52",null,null,{"$f":"I66/$F$54","v":1.0345071300973196},"m"]
[null,"Metode 3: formel 10"]
[null,"Mindste sumpvolumen","Vminimum = Qpumpe ∙ 900 / n ∙ z →",null,null,"Vminimum = 0,078 ∙ 900 / 1* 15 =",null,null,{"$f":"F57*900/1/F61","v":4.6800000000000006},"m3"]
[null,"Afstand mellem P1start og P1stop","ΔH = Vminimum / Sumpoverflade",null,null,"ΔH = 4,68 / 4,52",null,null,{"$f":"I69/$F$54","v":1.0345071300973199},"m"]
[null,"Tommelfinger regel 1.1, jf. afsnit 3.5: ","1 minuts driftsvolumen"]
[null,"Mindste sumpvolumen","Vminimum = 60 · Qpumpe Vtotal →",null,null,"Vminimum = 60 · 0,078 =",null,null,{"$f":"60*F57","v":4.68},"m3"]
[null,"Afstand mellem P1start og P1stop","ΔH = Vminimum / Sumpoverflade",null,null,"ΔH = 4,68 / 4,52",null,null,{"$f":"I72/$F$54","v":1.0345071300973196},"m"]
[null,"Tommelfinger regel 2.1, jf. afsnit 3.5: ","3 minutters driftsvolumen"]
[null,"Mindste sumpvolumen","Vminimum = 3 ·60 · Qpumpe →",null,null,"Vminimum = 3 ·60 · 0,078 =",null,null,{"$f":"3*60*F57","v":14.04},"m3"]
[null,"Afstand mellem P1start og P1stop","ΔH = Vminimum / Sumpoverflade",null,null,"ΔH = 14,04 / 4,52",null,null,{"$f":"I75/$F$54","v":3.1035213902919589},"m"]
[]
[null,"Paralleldrift 2 pumper"]
[null,"Metode 2: formel 7 og formel 8"]
[null,"Volumen mellem pumpestarter:","ΔV = Aoverflade · (StartkoteP2 - StartkoteP1) →",null,null,"ΔV= 1,77 ∙ (12-11,5) =",null,null,{"$f":"(F56-F55)*F54","v":4.5238934211693023},"m3"]
[null,"Beregnet akkumuleret volumen","Vtotal = Vminimum / n + ((n-1) ∙ ΔV) →",null,null,"Vtotal = 2,0 / 2 + ((2-1) ∙ 1,77)",null,null,{"$f":"I69/F60+((F60-1)*I80)","v":4.6800000000000006},"m3"]
[null,"Beregnet volumen P1start- P1stop","Vminimum P1 = VP1start - VP1stop = Vtotal/n",null,null,"Vminimum P1 = Vtotal /2",null,null,0.94803646691106458,"m3"]
[null,"Afstand mellem P1start- P1stop","ΔH = VminimumP1 / Sumpoverflade",null,null,"ΔH =0,948 / 1,77",null,null,{"$f":"I82/F54","v":0.20956206936148888},"m3"]
[null,"Tommelfinger regel 1.2, jf. afsnit 3.5: ","90 gange Qpumpe, 1,5 minutterss driftsvolumen akkumuleret"]
[null,"Mindste totale sumpvolumen","Vtotal = 90 · Qpumpe →",null,null,"Vtotal = 90 · 0,045 =",null,null,{"$f":"90*F57","v":7.02},"m3"]
[null,"Beregnet volumen P1start- P1stop","Vminimum P1 = Vtotal/n",null,null,"Vminimum P1 = 4,050/2",null,null,{"$f":"I85/2","v":3.51},"m3"]
[null,"Afstand mellem P1start- P1stop","ΔH = VminimumP1 / Sumpoverflade",null,null,"ΔH =2,025 / 1,77",null,null,{"$f":"I86/F54","v":0.77588034757298974},"m"]
[null,null,null,null,null,null,null,null,null," "]
[null,"Solo eller paralleldrift"]
[null,"Metode 3: formel 10 - 2 pumper i paralleldrift"]
[null,"Volumen til hver pumpe","V minimum P1 = Qpumpe ∙ 900 / n ∙ z →",null,null,"Vminimum = 0,045 ∙ 900 / 2 · 20 =",null,null,{"$f":"F57*900/F60/F61","v":4.6800000000000006},"m3"]
[null,"Totalt volumen","Vtotal = VminimumP1 * n →",null,null,"Vtotal = 1,0 ∙ 2",null,null,{"$f":"I91*F60","v":4.6800000000000006},"m3"]
[null,"Afstand mellem Pxstart og Pxstop","ΔH = VminimumP1 / Sumpoverflade",null,null,"ΔH =1,013 / 1,77",null,null,{"$f":"I91/F54","v":1.0345071300973199},"m"]
[]
[]
[]
[null,"Resultat af designproces"]
[null,null,"Branche-enheder",null,null,"SI-enhed"]
[null,"Sumpdiameter",2.2000000000000002,"mvs",null,{"$f":"C99","v":2.2000000000000002},"m"]
[null,"Sumpoverflade",{"$f":"PI()*((C99/2)^2)","v":3.8013271108436504},"m2",null,{"$f":"C100","v":3.8013271108436504},"m2"]
[null,"Startkote pumpe 1",11,"m",null,11,"m"]
[null,"Startkote pumpe 2",12,"m",null,12,"m"]
[null,"Pumpekapacitet:",{"$f":"236/3.6","v":65.555555555555557},"l/s",null,{"$f":"C103/1000","v":6.5555555555555561E-2},"m3/s"]
[null,"Trykhøjde:",25.9,"mvs",null,{"$f":"C104","v":25.9},"m "]
[null,"Optaget effelt:",26.4,"kW",null,{"$f":"C105","v":26.4},"kW"]
[null,"Antal pumper",1,"n",null,1,"n"]
[null,"Tilladt antal starter jf. tabel 2",15,"z/h",null,15,"z/h"]
[null,"Tminimum jf tabel 2",240,"sekunder",null,240,"sekunder"]
[]
[null,"Solodrift 1 pumpe"]
[null,"Metode 1: formel 6"]
[null,"Mindste sumpvolumen","Vminimum = 0,25 ∙ Qpumpe ∙ Tminimum →",null,null,"Vminimum = 0,25 ∙ 0,066 ∙ 180 =",null,null,{"$f":"0.25*F103*C108","v":3.9333333333333336},"m3"]
[null,"Afstand mellem P1start og P1stop","ΔH = Vminimum / Sumpoverflade",null,null,"ΔH = 4,68 / 4,52",null,null,{"$f":"I112/F100","v":1.0347263517820191},"m"]
[null,"Metode 3: formel 10"]
[null,"Mindste sumpvolumen","Vminimum = Qpumpe ∙ 900 / n ∙ z →",null,null,"Vminimum = 0,066 ∙ 900 / 1* 15 =",null,null,{"$f":"F103*900/1/F107","v":3.933333333333334},"m3"]
[null,"Afstand mellem P1start og P1stop","ΔH = Vminimum / Sumpoverflade",null,null,"ΔH = 4,68 / 4,52",null,null,{"$f":"I115/F100","v":1.0347263517820193},"m"]
[null,"Tommelfinger regel 1.1, jf. afsnit 3.5: ","1 minuts driftsvolumen"]
[null,"Mindste sumpvolumen","Vminimum = 60 · Qpumpe Vtotal →",null,null,"Vminimum = 60 · 0,066 =",null,null,{"$f":"60*F103","v":3.9333333333333336},"m3"]
[null,"Afstand mellem P1start og P1stop","ΔH = Vminimum / Sumpoverflade",null,null,"ΔH = 4,68 / 4,52",null,null,{"$f":"I118/F100","v":1.0347263517820191},"m"]
[null,"Tommelfinger regel 2.1, jf. afsnit 3.5: ","3 minutters driftsvolumen"]
[null,"Mindste sumpvolumen","Vminimum = 3 ·60 · Qpumpe →",null,null,"Vminimum = 3 ·60 · 0,066 =",null,null,{"$f":"3*60*F103","v":11.8},"m3"]
[null,"Afstand mellem P1start og P1stop","ΔH = Vminimum / Sumpoverflade",null,null,"ΔH = 14,04 / 4,52",null,null,{"$f":"I121/$F$54","v":2.608372678450507}," "]

{"sheet":"Volumenberegning idé til model","index":1,"n_rows":120,"n_cols":20,"rows_kept":120,"cut":false,"hidden":true,"merged":[[17,13,17,14],[18,3,18,4],[18,6,18,7],[64,2,64,9],[94,2,94,9],[60,2,60,9],[51,2,51,6],[105,17,105,19],[105,13,105,14],[105,15,105,16],[73,2,73,9],[82,2,82,9]]}
[]
[]
[]
[]
[]
[null,null,"Metode 1",null,null,null,null,6]
[null,null,"Metode 2",null,null,null,8,8]
[null,null,"Metode 3",")            (8)",null,null,null,9]
[null,null,"Metode 4",null,null,null,null,12]
[null,null,"Metode 5.1",null,null,null,null,13]
[null,null,"Metode 5.2",null,null,null,null,14]
[null,null,"Metode 5.3",null,null,null,null,15]
[null,null,"Metode 6.1",null,null,null,null,16]
[null,null,"Metode 6.2",null,null,null,null,17]
[]
[]
[]
[null,null,"Beregningseksempler",null,null,null,null,null,null,null,null,null,null,"Driftsform",null,"Beregningsform"]
[null,null,null,"Branche-enheder",null,null,"SI-enhed",null,null,null,null,null,null,"Solo","Parallel","Individuel","Estimat"]
[null,null,"Sumpdiameter",1.45,"mvs",null,{"$f":"D20","v":1.45},"m",null,null,null,null,null,"x",null,"x"]
[null,null,"Sumpoverflade",10,"m2",null,10,"m2",null,null,null,null,null,null,"x","x"]
[null,null,"Startkote pumpe 1",11,"m",null,11,"m",null,null,null,null,null,"x","x","x"]
[null,null,"Startkote pumpe 2",12,"m",null,11.5,"m",null,null,null,null,null,"x",null,"x"]
[null,null,"Pumpekapacitet:",100,"l/s",null,{"$f":"D24/1000","v":0.1},"m3/s",null,null,null,null,null,"(x)",null,null,"x"]
[null,null,"Trykhøjde:",20,"mvs",null,{"$f":"D25","v":20},"m ",null,null,null,null,null,null,"(x)",null,"x"]
[null,null,"Optaget effekt:",45,"kW",null,{"$f":"D26","v":45},"kW",null,null,null,null,null,null,"(x)",null,"x"]
[null,null,"Antal pumper",2,"n",null,2,"n",null,null,null,null,null,"(x)","(x)",null,"x"]
[null,null,"Tilladt antal starter jf. tabel 2",10,"z/h",null,10,"z/h"]
[null,null,"Tminimum jf tabel 2",360,"sekunder",null,360,"sekunder"]
[]
[]
[null,null,"Dimensioneringsparametre",null,null,null,"Enheder",null,null,null,"Værdi"]
[null,null,"Kendes maksimalt tilladte antal pumpestarter",null,null,"Ja","[-]",null,"Tabel",null,"Drop down (Ja-Nej)"]
[null,null,"Pumpeinstallation",null,null,"Dykket ","[-]",null,"Info",null,"Drop down (Dykket - tørt)"]
[null,null,"Antal identiske pumper i pumpestationen",null,null,3,"[-]",null,"Tabelopslag",null,"Drop down (1-2-3)"]
[null,null,"Maksimalt antal pumper i samdrift",null,null,2,"[-]",null,"Tabelopslag",null,"Drop down (1-2-3)"]
[null,null,"Antallet af pumper i den driftssituation som skal beregnes",null,null,2,"[-]",null,"Tabelopslag",null,"Drop down (1-2-3)"]
[null,null,"Pumpens/-ernes virkningsgrad i driftspunkt",null,null,0.63,"[%]",null,"Indtastet variabel",null,"Vilkårlig"]
[null,null,"Pumpekapacitet",null,null,20,"[l/s]",null,"Indtastet variabel",null,"Vilkårlig"]
[null,null,"Pumpekapacitet 2 pumper i parallel drift",null,null,26.5,"[l/s]",null,"Indtastet variabel",null,"Vilkårlig"]
[null,null,"Pumpekapacitet 3 pumper i parallel drift",null,null,31.2,"[l/s]",null,"Indtastet variabel",null,"Vilkårlig"]
[null,null,"Geometrisk trykhøjde",null,null,10,"[m]",null,"Indtastet variabel",null,"Vilkårlig"]
[null,null,"Trykledningsmateriale",null,null,"PE100","[-]",null,"Info",null,"Prædefineret fast"]
[null,null,"Trykklasse",null,null,17,"[SDR]",null,"Tabel",null,"Drop down"]
[null,null,"Trykledningsdimension",null,null,225,"[mm]",null,"Tabel",null,"Drop down"]
[null,null,"Trykledningsruhed",null,null,0.3,"[mm]",null,"Tabel",null,"Drop down (0,1 -0,3-0,6-1,0)mm"]
[null,null,"Trykledningslængde",null,null,2000,"[m]",null,"Indtastet variabel",null,"Vilkårlig"]
[null,null,"Sumpdiameter",null,null,1.25,"[m]",null,"Indtastet variabel",null,"Vilkårlig"]
[null,null,"Startniveau pumpe 1",null,null,10,"[m]",null,"Indtastet variabel",null,"Vilkårlig"]
[null,null,"Startniveau pumpe 2",null,null,10.5,"[m]",null,"Indtastet variabel",null,"Vilkårlig"]
[]
[]
[null,null,"Resultater fra pumpeudlægning"]
[null,null,"Antal pumper i samdrift",null,null,"=celle F37"]
[null,null,"Beregnet trykledningsmodstand",null,null,9.92,"[m]",null,"Beregning",null,"Colebrook&White"]
[null,null,"Systemmodstand",null,null,{"$f":"F42+F55","v":19.920000000000002},"[m]",null,"Beregning"]
[null,null,"Effektoptag (P1)",null,null,{"$f":"(F39*F56/100)/F38","v":6.3238095238095244},"[kW]",null,"Beregning"]
[null,null,"Tilladeligt antal starter jf. tabel 2",null,null,25,"[z/h]",null,"Beregning eller tabelopslag"]
[null,null,"Korteste tid mellem starter",null,null,144,"[Tmin_sek]"]
[null,null,"Sumpoverflade",null,null,{"$f":"PI()*(1.25/2)^2","v":1.227184630308513},"[m2]",null,"Beregning"]
[]
[null,null,"Metode 1, behovsspecifik metode, anvendes til pumper i solo drift",null,null,null,null,null,"Sumpvolumen"]
[null,null,null,null,null,null,null,null,{"$f":"0.25*0.02*144","v":0.72},"m3"]
[]
[]
[null,null,"Metode 2, behovsspecifik metode, anvendes til pumper parallel drift",null,null,null,null,null,"Sumpvolumen"]
[]
[null,null,"Beregning af volumen mellem pumpestart 1 og pumpestart 2"]
[null,null,null,null,null,null,null,null,{"$f":"F60*(F33-F49)","v":{"$error":"#VALUE!"}},"m3"]
[]
[null,null,"Metode 2, volumenberegning for 2 pumper i parallel drift:"]
[null,null,null,null,null,null,null,null,{"$f":"I63/2+((2-1)*I69)","v":{"$error":"#VALUE!"}},"m3"]
[]
[]
[null,null,"Metode 3, behovsspecifik metode, anvendes til pumper i solo og parallel drift",null,null,null,null,null,"Sumpvolumen"]
[]
[null,null,"Metode 3, volumenberegning for pumpe i solo drift:"]
[null,null,null,null,null,null,null,null,{"$f":"0.02*900/25","v":0.72},"m3"]
[]
[null,null,"Metode 3, volumenberegning for 2 pumper i parallel drift:"]
[null,null,null,null,null,null,null,null,{"$f":"0.0265*900/25","v":0.95399999999999996},"m3"]
[]
[]
[null,null,"Metode 5, faktormetoder, anvendes til pumper i solo og parallel drift:",null,null,null,null,null,"Sumpvolumen"]
[]
[null,null,"Metode 5.1, volumenberegning for pumpe i solo drift:"]
[null,null,null,null,null,null,null,null,{"$f":"60*20/1000","v":1.2},"m3"]
[]
[null,null,"Metode 5.2, volumenberegning for 2 pumper i parallel drift:"]
[null,null,null,null,null,null,null,null,{"$f":"90*20/1000","v":1.8},"m3"]
[]
[null,null,"Metode 5.3, volumenberegning for 3 pumper i parallel drift:"]
[null,null,null,null,null,null,null,null,{"$f":"120*20/1000","v":2.4},"m2"]
[]
[null,null,3]
[null,null,"Metode 6, regelbaseret driftstids-metode, anvendes til pumper i solo og parallel drift"]
[]
[null,null,"Metode 6.1, 60 sekunders driftstid"]
[null,null,null,null,null,null,null,null,{"$f":"60*20/1000","v":1.2},"m3"]
[]
[null,null,"Metode 6.1, 180 sekunders driftstid"]
[null,null,null,null,null,null,null,null,{"$f":"180*20/1000","v":3.6},"m2"]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Solodrift","Vol.",null,"Afvig.",null,"Start/stop afstand"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pumpe 1","Pumpe 2","Pumpe 3"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"C62","v":"Metode 1, behovsspecifik metode, anvendes til pumper i solo drift"},{"$f":"I63","v":0.72},"m3",100,"%",{"$f":"I63/F60","v":0.58670878221396294},"-","-"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"C77","v":"Metode 3, volumenberegning for pumpe i solo drift:"},{"$f":"I78","v":0.72},"m3",100,"%",{"$f":"I78/F60","v":0.58670878221396294},"-","-"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"C86","v":"Metode 5.1, volumenberegning for pumpe i solo drift:"},{"$f":"I87","v":1.2},"m3",{"$f":"N110/N108*100","v":166.66666666666669},"%",{"$f":"I87/F60","v":0.97784797035660487},"-","-"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Parallel drift","Vol.",null,"Afvig.",null,"Pumpe 1","Pumpe 2","Pumpe 3"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"C71","v":"Metode 2, volumenberegning for 2 pumper i parallel drift:"},{"$f":"I72","v":{"$error":"#VALUE!"}},"m3",100,"%",{"$f":"I63/F60","v":0.58670878221396294},{"$f":"I72/F60-R113","v":{"$error":"#VALUE!"}},"-"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"C80","v":"Metode 3, volumenberegning for 2 pumper i parallel drift:"},{"$f":"I90","v":1.8},"m3",{"$f":"N114/N113*100","v":{"$error":"#VALUE!"}},"%",{"$f":"I78/F60","v":0.58670878221396294},{"$f":"I81/F60-R114","v":0.190680354219538},"-"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"C89","v":"Metode 5.2, volumenberegning for 2 pumper i parallel drift:"},{"$f":"I90","v":1.8},"m3",{"$f":"N115/N113*100","v":{"$error":"#VALUE!"}},"%",{"$f":"I87/F60","v":0.97784797035660487},{"$f":"I90/F60-R115","v":0.4889239851783026},"-"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"C92","v":"Metode 5.3, volumenberegning for 3 pumper i parallel drift:"},{"$f":"I93","v":2.4},"m3",{"$f":"N116/N113*100","v":{"$error":"#VALUE!"}},"%",{"$f":"I87/F60","v":0.97784797035660487},{"$f":"I90/F60-R116","v":0.4889239851783026},{"$f":"I93/F60-S116-R116","v":0.48892398517830238}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Regelbaseret driftstids-metode","Vol.",null,"Afvig.",null,"Pumpe 1","Pumpe 2","Pumpe 3"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"C98","v":"Metode 6.1, 60 sekunders driftstid"},{"$f":"I99","v":1.2},"m3",100,"%",{"$f":"I99/F60","v":0.97784797035660487},"-","-"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"C101","v":"Metode 6.1, 180 sekunders driftstid"},{"$f":"I102","v":3.6},"m3",300,"%",{"$f":"I102/F60","v":2.9335439110698149},"-","-"]

{"sheet":"Eksempel","index":2,"n_rows":71,"n_cols":22,"rows_kept":71,"cut":false,"hidden":true,"merged":[[31,17,47,19],[48,12,48,19],[17,13,17,14],[18,3,18,4],[18,6,18,7],[31,7,47,9],[48,2,48,9]]}
[]
[]
[]
[]
[]
[null,null,"Metode 1",null,null,null,null,6]
[null,null,"Metode 2",null,null,null,8,8]
[null,null,"Metode 3",")            (8)",null,null,null,9]
[null,null,"Metode 4",null,null,null,null,12]
[null,null,"Metode 5.1",null,null,null,null,13]
[null,null,"Metode 5.2",null,null,null,null,14]
[null,null,"Metode 5.3",null,null,null,null,15]
[null,null,"Metode 6.1",null,null,null,null,16]
[null,null,"Metode 6.2",null,null,null,null,17]
[]
[]
[]
[null,null,"Beregningseksempler",null,null,null,null,null,null,null,null,null,null,"Driftsform",null,"Beregningsform"]
[null,null,null,"Branche-enheder",null,null,"SI-enhed",null,null,null,null,null,null,"Solo","Parallel","Individuel","Estimat"]
[null,null,"Sumpdiameter",1.45,"mvs",null,{"$f":"D20","v":1.45},"m",null,null,null,null,null,"x",null,"x"]
[null,null,"Sumpoverflade",10,"m2",null,10,"m2",null,null,null,null,null,null,"x","x"]
[null,null,"Startkote pumpe 1",11,"m",null,11,"m",null,null,null,null,null,"x","x","x"]
[null,null,"Startkote pumpe 2",12,"m",null,11.5,"m",null,null,null,null,null,"x",null,"x"]
[null,null,"Pumpekapacitet:",100,"l/s",null,{"$f":"D24/1000","v":0.1},"m3/s",null,null,null,null,null,"(x)",null,null,"x"]
[null,null,"Trykhøjde:",20,"mvs",null,{"$f":"D25","v":20},"m ",null,null,null,null,null,null,"(x)",null,"x"]
[null,null,"Optaget effekt:",45,"kW",null,{"$f":"D26","v":45},"kW",null,null,null,null,null,null,"(x)",null,"x"]
[null,null,"Antal pumper",2,"n",null,2,"n",null,null,null,null,null,"(x)","(x)",null,"x"]
[null,null,"Tilladt antal starter jf. tabel 2",10,"z/h",null,10,"z/h"]
[null,null,"Tminimum jf tabel 2",360,"sekunder",null,360,"sekunder"]
[]
[]
[null,null,"Dimensioneringsparametre",null,null,null,"Enheder"]
[null,null,"Pumpeinstallation",null,null,"Dykket ","[-]"]
[null,null,"Pumpekapacitet",null,null,78,"[l/s]",null,null,null,null,null,"Dimensioneringsparametre",null,null,null,"Enheder"]
[null,null,"Pumpekapacitet 2 pumper i parallel drift",null,null,26.5,"[l/s]",null,null,null,null,null,"Pumpeinstallation",null,null,"Dykket ","[-]"]
[null,null,"Geometrisk trykhøjde",null,null,10,"[m]",null,null,null,null,null,"Pumpekapacitet",null,null,66,"[l/s]"]
[null,null,"Sumpdiameter",null,null,2.4,"[m]",null,null,null,null,null,"Pumpekapacitet 2 pumper i parallel drift",null,null,26.5,"[l/s]"]
[null,null,"Sumpoverflade",null,null,{"$f":"PI()*(F37/2)^2","v":4.5238934211693023},"[m2]",null,null,null,null,null,"Geometrisk trykhøjde",null,null,10,"[m]"]
[null,null,"Startniveau pumpe 1",null,null,11,"[-]",null,null,null,null,null,"Sumpdiameter",null,null,2.2000000000000002,"[m]"]
[null,null,"Startniveau pumpe 2",null,null,12,"[-]",null,null,null,null,null,"Sumpoverflade",null,null,{"$f":"PI()*(P39/2)^2","v":3.8013271108436504},"[m2]",null,null,null,null,{"$f":"P40/P39","v":1.7278759594743864}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Startniveau pumpe 1",null,null,11,"[-]"]
[null,null,"Resultater fra pumpeudlægning",null,null,null,null,null,null,null,null,null,"Startniveau pumpe 2",null,null,12,"[-]"]
[null,null,"Beregnet trykledningsmodstand",null,null,15.9,"[m]",null,null,null,null,null,"Resultater fra pumpeudlægning"]
[null,null,"Systemmodstand",null,null,{"$f":"F43+F36","v":25.9},"[m]",null,null,null,null,null,"Beregnet trykledningsmodstand",null,null,13.5,"[m]"]
[null,null,"Effektoptag (P1)",null,null,26.4,"[kW]",null,null,null,null,null,"Systemmodstand",null,null,{"$f":"P44+P38","v":23.5},"[m]"]
[null,null,"Tilladeligt antal starter jf. tabel 2",null,null,10,"[z/h]",null,null,null,null,null,"Effektoptag (P1)",null,null,22.6,"[kW]"]
[null,null,"Korteste tid mellem starter",null,null,360,"[Tmin_sek]",null,null,null,null,null,"Tilladeligt antal starter jf. tabel 2",null,null,10,"[z/h]"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Korteste tid mellem starter",null,null,360,"[Tmin_sek]"]
[]
[null,null,"Metode 1, anvendes til pumper i solo drift",null,null,null,null,null,"Sumpvolumen",null,null,null,"Metode 1, anvendes til pumper i solo drift",null,null,null,null,null,"Sumpvolumen"]
[null,null,null,null,null,null,null,null,{"$f":"0.25*F34/1000*360","v":7.02},"m3",null,null,null,null,null,null,null,null,{"$f":"0.25*P36/1000*360","v":5.94},"m3"]
[]
[null,null,"Metode 3, volumenberegning for pumpe i solo drift:",null,null,null,null,null,null,null,null,null,"Metode 3, volumenberegning for pumpe i solo drift:"]
[null,null,null,null,null,null,null,null,{"$f":"F34/1000*900/10","v":7.0200000000000005},"m3",null,null,null,null,null,null,null,null,{"$f":"P36/1000*900/10","v":5.94},"m3"]
[]
[]
[null,null,"Metode 5.1, volumenberegning for pumpe i solo drift:",null,null,null,null,null,null,null,null,null,"Metode 5.1, volumenberegning for pumpe i solo drift:"]
[null,null,null,null,null,null,null,null,{"$f":"60*F34/1000","v":4.68},"m3",null,null,null,null,null,null,null,null,{"$f":"60*P36/1000","v":3.96},"m3"]
[]
[]
[null,null,"Metode 6.1, 60 sekunders driftstid",null,null,null,null,null,null,null,null,null,"Metode 6.1, 60 sekunders driftstid"]
[null,null,null,null,null,null,null,null,{"$f":"60*F34/1000","v":4.68},"m3",null,null,null,null,null,null,null,null,{"$f":"60*P36/1000","v":3.96},"m3"]
[]
[null,null,"Metode 6.1, 180 sekunders driftstid",null,null,null,null,null,null,null,null,null,"Metode 6.1, 180 sekunders driftstid"]
[null,null,null,null,null,null,null,null,{"$f":"180*F34/1000","v":14.04},"m2",null,null,null,null,null,null,null,null,{"$f":"180*P36/1000","v":11.88},"m2"]
[]
[]
[]
[null,null,null,{"$f":"F45","v":26.4},null,null,null,null,null,null,null,null,null,{"$f":"N70/N71","v":20.268488268488269}]
[null,null,null,{"$f":"F34*F44/100","v":20.201999999999998},null,null,null,null,null,null,null,null,null,{"$f":"P36*P45/100","v":15.51}]
[null,null,null,{"$f":"D70/D69","v":0.76522727272727264},null,null,null,null,null,null,null,null,null,{"$f":"D71","v":0.76522727272727264}]

{"sheet":"Vandmængdematriks","index":3,"n_rows":30,"n_cols":18,"rows_kept":30,"cut":false,"hidden":true,"merged":[[3,10,5,10],[3,5,5,5],[3,6,5,6],[3,7,5,7],[3,8,5,8],[3,9,5,9]]}
[]
[]
[]
[null,null,null,null,null,"Qmaks_time_tørvejr","Qmaks_time_absolut","Qmaks_døgn","Qmiddel_døgn","Qminimum_døgn","Qår"]
[]
[null,null,"Spildevand"]
[null,null,"Timespidsbelastning","Qspv-timemaks","[m3/h]","×","×"]
[null,null,"Døgnspidsbelastning","Qspv-døgnmaks","[m3/d]",null,null,"×"]
[null,null,"Døgnmiddelbelastning","Qspv-døgnmiddel","[m3/d]",null,null,null,"×"]
[null,null,"Døgnminimumsbelastning","Qspv-døgnminimum","[m3/d]",null,null,null,null,"×"]
[null,null,"Spildevandsårsmængde","Qspv-år","[m3/år]",null,null,null,null,null,"×"]
[]
[null,null,"Uvedkommende vand",null,null,null,null,null,null,null,null,null,null,null,null,1700,123,{"$f":"P13/Q13","v":13.821138211382113}]
[null,null,"Døgnspidsbelastning","Quved-døgnmaks","[m3/d]","×","×","×",null,null,null,null,null,null,null,1800,123,{"$f":"P14/Q14","v":14.634146341463415}]
[null,null,"Døgnmiddelbelastning","Quved-døgnmiddel","[m3/d]",null,null,null,"×"]
[null,null,"Døgnminimumsbelastning","Quved-døgnmininimum","[m3/d]",null,null,null,null,"×"]
[null,null,"Uvedkommende vand årsmængde ","Quved-år","[m3/år]",null,null,null,null,null,"×"]
[]
[null,null,"Nedbør"]
[null,null,"Direkte nedbørsbelastning ","Qdir-ned-timemaks","[m3/h]",null,"×","×"]
[null,null,"Indirekte nedbørsbelastning","Qind-ned-døgnmaks","[m3/d]",null,"×","×"]
[null,null,"Gennemsnitlig nedbørsbelastning","Qned-gennemsnit","[m3/d]",null,null,null,"×"]
[null,null,"Nedbør årsmængde","Qned-år","[m3/år]",null,null,null,null,null,"×"]
[]
[null,null,"Industribelastning"]
[null,null,"Timespidsbelastning","Qindu-timemaks","[m3/h]","×","×"]
[null,null,"Døgnspidsbelastning","Qindu-døgnmaks","[m3/d]",null,null,"×"]
[null,null,"Døgnmiddelbelastning","Qindu-døgnmiddel","[m3/d]",null,null,null,"×"]
[null,null,"Døgnminimumsbelastning","Qindu-døgnmininimum","[m3/d]",null,null,null,null,"×"]
[null,null,"Industri årsmængde","Qindu-år","[m3/år]",null,null,null,null,null,"×"]

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

{"sheet":"Simpel volumenberegningsmodel","index":5,"n_rows":111,"n_cols":20,"rows_kept":111,"cut":false,"hidden":true,"merged":[[96,17,96,19],[17,13,17,14],[18,3,18,4],[18,6,18,7],[44,2,44,6],[51,2,51,9],[55,2,55,9],[64,2,64,9],[73,2,73,9],[85,2,85,9],[96,13,96,14],[96,15,96,16]]}
[]
[]
[]
[]
[]
[null,null,"Metode 1",null,null,null,null,6]
[null,null,"Metode 2",null,null,null,8,8]
[null,null,"Metode 3",")            (8)",null,null,null,9]
[null,null,"Metode 4",null,null,null,null,12]
[null,null,"Metode 5.1",null,null,null,null,13]
[null,null,"Metode 5.2",null,null,null,null,14]
[null,null,"Metode 5.3",null,null,null,null,15]
[null,null,"Metode 6.1",null,null,null,null,16]
[null,null,"Metode 6.2",null,null,null,null,17]
[]
[]
[]
[null,null,"Beregningseksempler",null,null,null,null,null,null,null,null,null,null,"Driftsform",null,"Beregningsform"]
[null,null,null,"Branche-enheder",null,null,"SI-enhed",null,null,null,null,null,null,"Solo","Parallel","Individuel","Estimat"]
[null,null,"Sumpdiameter",1.45,"mvs",null,{"$f":"D20","v":1.45},"m",null,null,null,null,null,"x",null,"x"]
[null,null,"Sumpoverflade",10,"m2",null,10,"m2",null,null,null,null,null,null,"x","x"]
[null,null,"Startkote pumpe 1",11,"m",null,11,"m",null,null,null,null,null,"x","x","x"]
[null,null,"Startkote pumpe 2",12,"m",null,11.5,"m",null,null,null,null,null,"x",null,"x"]
[null,null,"Pumpekapacitet:",100,"l/s",null,{"$f":"D24/1000","v":0.1},"m3/s",null,null,null,null,null,"(x)",null,null,"x"]
[null,null,"Trykhøjde:",20,"mvs",null,{"$f":"D25","v":20},"m ",null,null,null,null,null,null,"(x)",null,"x"]
[null,null,"Optaget effekt:",45,"kW",null,{"$f":"D26","v":45},"kW",null,null,null,null,null,null,"(x)",null,"x"]
[null,null,"Antal pumper",2,"n",null,2,"n",null,null,null,null,null,"(x)","(x)",null,"x"]
[null,null,"Tilladt antal starter jf. tabel 2",10,"z/h",null,10,"z/h"]
[null,null,"Tminimum jf tabel 2",360,"sekunder",null,360,"sekunder"]
[]
[]
[null,null,"Dimensioneringsparametre",null,null,null,"Enheder",null,null,null,"Værdi"]
[null,null,"Pumpeinstallation",null,null,"Dykket ","[-]",null,"Info",null,"Drop down (Dykket - tørt)"]
[null,null,"Maksimalt tilladte antal starter pr. pumpe",null,null,10,"[z/h]",null,"Indtastet variabel",null,"Vilkårlig"]
[null,null,"Antal identiske pumper i pumpestationen som alternerer",null,null,3,"[-]",null,"Tabelopslag",null,"Drop down (1-2-3)"]
[null,null,"Maksimalt antal pumper i samdrift",null,null,2,"[-]",null,"Tabelopslag",null,"Drop down (1-2-3)"]
[null,null,"Antallet af pumper i den driftssituation som ønskes beregnet",null,null,2,"[-]",null,"Tabelopslag",null,"Drop down (1-2-3)"]
[null,null,"Pumpens/-ernes virkningsgrad i driftspunkt",null,null,0.63,"[%]",null,"Indtastet variabel",null,"Vilkårlig"]
[null,null,"Pumpekapacitet solodrift",null,null,20,"[l/s]",null,"Indtastet variabel",null,"Vilkårlig"]
[null,null,"Pumpekapacitet 2 pumper i parallel drift",null,null,26.5,"[l/s]",null,"Indtastet variabel",null,"Vilkårlig"]
[null,null,"Pumpekapacitet 3 pumper i parallel drift",null,null,31.2,"[l/s]",null,"Indtastet variabel",null,"Vilkårlig"]
[null,null,"Sumpdiameter",null,null,1.25,"[m]",null,"Indtastet variabel",null,"Vilkårlig"]
[null,null,"Startniveau pumpe 1",null,null,10,"[m]",null,"Indtastet variabel",null,"Vilkårlig"]
[null,null,"Startniveau pumpe 2",null,null,10.5,"[m]",null,"Indtastet variabel",null,"Vilkårlig"]
[]
[null,null,"Resultater fra pumpeudlægning"]
[null,null,"Antal pumper i samdrift",null,null,"=celle F37","[-]",null,"Resultater"]
[null,null,"Anvendt akkumuleret pumpekapacitet",null,null,"=F39;F40;F41","[l/s]",null,"Resultater"]
[null,null,"Tilladeligt antal starter pr. pumpe",null,null,"=celle F34","[z/h]",null,"Resultater"]
[null,null,"Korteste tid mellem starter",null,null,{"$f":"3600/(F34*F37)","v":180},"[Tmin_sek]",null,"Resultater"]
[null,null,"Sumpoverflade",null,null,{"$f":"PI()*(1.25/2)^2","v":1.227184630308513},"[m2]",null,"Resultater"]
[]
[null,null,"Metode 1, behovsspecifik metode, anvendes til pumper i solo drift",null,null,null,null,null,"Sumpvolumen"]
[null,null,null,null,null,null,null,null,{"$f":"0.25*0.02*144","v":0.72},"m3"]
[]
[]
[null,null,"Metode 2, behovsspecifik metode, anvendes til pumper parallel drift",null,null,null,null,null,"Sumpvolumen"]
[]
[null,null,"Beregning af volumen mellem pumpestart 1 og pumpestart 2"]
[null,null,null,null,null,null,null,null,{"$f":"F51*(#REF!-F43)","v":{"$error":"#REF!"}},"m3"]
[]
[null,null,"Metode 2, volumenberegning for 2 pumper i parallel drift:"]
[null,null,null,null,null,null,null,null,{"$f":"I54/2+((2-1)*I60)","v":{"$error":"#REF!"}},"m3"]
[]
[]
[null,null,"Metode 3, behovsspecifik metode, anvendes til pumper i solo og parallel drift",null,null,null,null,null,"Sumpvolumen"]
[]
[null,null,"Metode 3, volumenberegning for pumpe i solo drift:"]
[null,null,null,null,null,null,null,null,{"$f":"0.02*900/25","v":0.72},"m3"]
[]
[null,null,"Metode 3, volumenberegning for 2 pumper i parallel drift:"]
[null,null,null,null,null,null,null,null,{"$f":"0.0265*900/25","v":0.95399999999999996},"m3"]
[]
[]
[null,null,"Metode 5, faktormetoder, anvendes til pumper i solo og parallel drift:",null,null,null,null,null,"Sumpvolumen"]
[]
[null,null,"Metode 5.1, volumenberegning for pumpe i solo drift:"]
[null,null,null,null,null,null,null,null,{"$f":"60*20/1000","v":1.2},"m3"]
[]
[null,null,"Metode 5.2, volumenberegning for 2 pumper i parallel drift:"]
[null,null,null,null,null,null,null,null,{"$f":"90*20/1000","v":1.8},"m3"]
[]
[null,null,"Metode 5.3, volumenberegning for 3 pumper i parallel drift:"]
[null,null,null,null,null,null,null,null,{"$f":"120*20/1000","v":2.4},"m2"]
[]
[null,null,3]
[null,null,"Metode 6, regelbaseret driftstids-metode, anvendes til pumper i solo og parallel drift"]
[]
[null,null,"Metode 6.1, 60 sekunders driftstid"]
[null,null,null,null,null,null,null,null,{"$f":"60*20/1000","v":1.2},"m3"]
[]
[null,null,"Metode 6.1, 180 sekunders driftstid"]
[null,null,null,null,null,null,null,null,{"$f":"180*20/1000","v":3.6},"m2"]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Solodrift","Vol.",null,"Afvig.",null,"Start/stop afstand"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pumpe 1","Pumpe 2","Pumpe 3"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"C53","v":"Metode 1, behovsspecifik metode, anvendes til pumper i solo drift"},{"$f":"I54","v":0.72},"m3",100,"%",{"$f":"I54/F51","v":0.58670878221396294},"-","-"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"C68","v":"Metode 3, volumenberegning for pumpe i solo drift:"},{"$f":"I69","v":0.72},"m3",100,"%",{"$f":"I69/F51","v":0.58670878221396294},"-","-"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"C77","v":"Metode 5.1, volumenberegning for pumpe i solo drift:"},{"$f":"I78","v":1.2},"m3",{"$f":"N101/N99*100","v":166.66666666666669},"%",{"$f":"I78/F51","v":0.97784797035660487},"-","-"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Parallel drift","Vol.",null,"Afvig.",null,"Pumpe 1","Pumpe 2","Pumpe 3"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"C62","v":"Metode 2, volumenberegning for 2 pumper i parallel drift:"},{"$f":"I63","v":{"$error":"#REF!"}},"m3",100,"%",{"$f":"I54/F51","v":0.58670878221396294},{"$f":"I63/F51-R104","v":{"$error":"#REF!"}},"-"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"C71","v":"Metode 3, volumenberegning for 2 pumper i parallel drift:"},{"$f":"I81","v":1.8},"m3",{"$f":"N105/N104*100","v":{"$error":"#REF!"}},"%",{"$f":"I69/F51","v":0.58670878221396294},{"$f":"I72/F51-R105","v":0.190680354219538},"-"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"C80","v":"Metode 5.2, volumenberegning for 2 pumper i parallel drift:"},{"$f":"I81","v":1.8},"m3",{"$f":"N106/N104*100","v":{"$error":"#REF!"}},"%",{"$f":"I78/F51","v":0.97784797035660487},{"$f":"I81/F51-R106","v":0.4889239851783026},"-"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"C83","v":"Metode 5.3, volumenberegning for 3 pumper i parallel drift:"},{"$f":"I84","v":2.4},"m3",{"$f":"N107/N104*100","v":{"$error":"#REF!"}},"%",{"$f":"I78/F51","v":0.97784797035660487},{"$f":"I81/F51-R107","v":0.4889239851783026},{"$f":"I84/F51-S107-R107","v":0.48892398517830238}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Regelbaseret driftstids-metode","Vol.",null,"Afvig.",null,"Pumpe 1","Pumpe 2","Pumpe 3"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"C89","v":"Metode 6.1, 60 sekunders driftstid"},{"$f":"I90","v":1.2},"m3",100,"%",{"$f":"I90/F51","v":0.97784797035660487},"-","-"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"C92","v":"Metode 6.1, 180 sekunders driftstid"},{"$f":"I93","v":3.6},"m3",300,"%",{"$f":"I93/F51","v":2.9335439110698149},"-","-"]

{"sheet":"Tidl udkast","index":6,"n_rows":21,"n_cols":12,"rows_kept":21,"cut":false,"hidden":true,"merged":[[14,1,14,3]]}
[]
[null,"Dimensioneringsparametre",null,"Enheder",null,null,null,"Værdi"]
[null,"Pumpeinstallation","Dykket ","[-]",null,"Info",null,"Drop down (Dykket - tørt)"]
[null,"Maksimalt tilladte antal starter pr. pumpe",10,"[z/h]",null,"Indtastet variabel",null,"Vilkårlig"]
[null,"Antal identiske pumper i pumpestationen som alternerer",3,"[-]",null,"Tabelopslag",null,"Drop down (1-2-3)",null,null,null,"Fra v0.x"]
[null,"Maksimalt antal pumper i samdrift",2,"[-]",null,"Tabelopslag",null,"Drop down (1-2-3)"]
[null,"Antallet af pumper i den driftssituation som ønskes beregnet",2,"[-]",null,"Tabelopslag",null,"Drop down (1-2-3)"]
[null,"Pumpens/-ernes virkningsgrad i driftspunkt",0.63,"[%]",null,"Indtastet variabel",null,"Vilkårlig"]
[null,"Pumpekapacitet solodrift",20,"[l/s]",null,"Indtastet variabel",null,"Vilkårlig"]
[null,"Pumpekapacitet 2 pumper i parallel drift",26.5,"[l/s]",null,"Indtastet variabel",null,"Vilkårlig"]
[null,"Pumpekapacitet 3 pumper i parallel drift",31.2,"[l/s]",null,"Indtastet variabel",null,"Vilkårlig"]
[null,"Sumpdiameter",1.25,"[m]",null,"Indtastet variabel",null,"Vilkårlig"]
[null,"Startniveau pumpe 1",10,"[m]",null,"Indtastet variabel",null,"Vilkårlig"]
[null,"Startniveau pumpe 2",10.5,"[m]",null,"Indtastet variabel",null,"Vilkårlig"]
[]
[null,"Resultater fra pumpeudlægning"]
[null,"Antal pumper i samdrift",{"$f":"C7","v":2},"[-]",null,"Resultater"]
[null,"Anvendt akkumuleret pumpekapacitet",{"$f":"IF(C6=1,C9,IF(C6=2,C10,C11))","v":26.5},"[l/s]",null,"Resultater",null,"C9-11 afh. Af C6"]
[null,"Tilladeligt antal starter pr. pumpe",{"$f":"C4","v":10},"[z/h]",null,"Resultater"]
[null,"Korteste tid mellem starter",{"$f":"3600/(C4*C7)","v":180},"[Tmin_sek]",null,"Resultater"]
[null,"Sumpoverflade",{"$f":"PI()*(1.25/2)^2","v":1.227184630308513},"[m2]",null,"Resultater"]

{"sheet":"Find sumpvolumen - simpel","index":7,"n_rows":31,"n_cols":6,"rows_kept":31,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Dimensioneringsparametre til sumpdimensionering"]
[null,"Trykledningsdimension",160,"[mm]"]
[null,"Trykklasse",17,"[SDR]"]
[null,"Pumpeinstallation","Dykket","[-]"]
[null,"Maksimalt tilladte antal starter pr. pumpe",10,"[z/h]"]
[null,"Antal identiske pumper som alternerer",1,"[-]"]
[null,"Maksimalt antal pumper i samdrift",3,"[-]"]
[null,"Antallet af pumper i den driftssituation som ønskes beregnet",3,"[-]"]
[null,"Pumpens/-ernes virkningsgrad i driftspunkt",65,"[%]"]
[null,"Pumpekapacitet solodrift",16,"[l/s]",null,"farveforskel på inddata felter"]
[null,"Pumpekapacitet 2 pumper i parallel drift",24,"[l/s]",null,"række 9 fjernes?"]
[null,"Pumpekapacitet 3 pumper i parallel drift",28,"[l/s]"]
[null,"Sumpdiameter",1.25,"[m]"]
[null,"Startniveau pumpe 1",10,"[m]"]
["x","Startniveau pumpe 2",10.5,"[m]"]
[]
[null,"Resultater fra pumpeudlægning"]
[null,"Antal pumper i samdrift",2,"[-]"]
[null,"Anvendt akkumuleret pumpekapacitet",28,"[l/s]"]
[null,"Tilladeligt antal starter pr. pumpe",10,"[z/h]"]
[null,"Korteste tid mellem starter",120,"[s]"]
[null,"Sumpoverflade",1.227184630308513,"[m2]"]
[]
[null,"Resultater"]
[null,"Nødvendigt sumpvolumen, Metode 3. Solo-/paralleldrift.",0.84000000000000008,"[m3]"]
[null,"Nødvendigt sumpvolumen, Metode 6.1. Solo-/paralleldrift, estimat.",0.96,"[m3]"]
[null,"Nødvendigt sumpvolumen, Metode 6.2. Solo-/paralleldrift, estimat.",2.88,"[m3]"]
[null,"Nødvendigt sumpvolumen, Metode 2. Paralleldrift.",1.707184630308513,"[m3]"]
[null,"Nødvendigt sumpvolumen, Metode 5.2. Paralleldrift, estimat.",1.44,"[m3]"]
[null,"Nødvendigt sumpvolumen, Metode 5.3. Paralleldrift, estimat.",1.92,"[m3]"]

{"sheet":"Find sumpvolumen - avanceret","index":8,"n_rows":39,"n_cols":4,"rows_kept":39,"cut":false,"hidden":true,"merged":[]}
[]
[null,"Dimensioneringsparametre til sumpdimensionering"]
[null,"Trykledningsdimension",225,"[mm]"]
[null,"Trykledningslængde",2000,"[m]"]
[null,"Trykklasse",17,"[SDR]"]
[null,"Pumpeinstallation","Dykket","[-]"]
[null,"Motorstørrelse på pumpe",10,"[kW]"]
[null,"Antal identiske pumper som alternerer",2,"[-]"]
[null,"Maksimalt antal pumper i samdrift",2,"[-]"]
[null,"Antallet af pumper i den driftssituation som ønskes beregnet",2,"[-]"]
[null,"Pumpens/-ernes virkningsgrad i driftspunkt",63,"[%]"]
[null,"Pumpekapacitet solodrift",20,"[l/s]"]
[null,"Pumpekapacitet 2 pumper i parallel drift",26.5,"[l/s]"]
[null,"Pumpekapacitet 3 pumper i parallel drift",31.2,"[l/s]"]
[null,"Sumpdiameter",1.25,"[m]"]
["x","Startniveau pumpe 1",10,"[m]"]
[null,"Startniveau pumpe 2",10.5,"[m]"]
[]
[null,"Resultater fra pumpeudlægning"]
[null,"Antal pumper i samdrift",2,"[-]"]
[null,"Anvendt akkumuleret pumpekapacitet",26.5,"[l/s]"]
[null,"Tilladeligt antal starter pr. pumpe",15,"[z/h]"]
[]
[null,"Resultater fra pumpeudlægning"]
[null,"Antal pumper i samdrift",2,"[-]"]
[null,"Anvendt akkumuleret pumpekapacitet",26.5,"[l/s]"]
[null,"Tilladeligt antal starter pr. pumpe",15,"[z/h]"]
[null,"Korteste tid mellem starter",180,"[s]"]
[null,"Sumpoverflade",1.227184630308513,"[m2]"]
[]
[null,"Resultater, sumpvolumen"]
[]
[null,"Resultater, ledningstab m.m."]
[null,"Valgt ledningsruhed",0.03,"[mm]"]
[null,"Indtastet geometrisk tab",null,"[m]"]
[null,"Beregnet strømningshastighed",0.85606409247554394,"[m/s]"]
[null,"Rørtab /1000m",3.1090222760977686,"[mvs]"]
[null,"Rørtab for ledningen (2000 m)",6.2180445521955372,"[m]"]
[null,"Systemtab","Kan ikke beregnes","[m]"]

{"sheet":"Tabeller","index":9,"n_rows":20,"n_cols":21,"rows_kept":20,"cut":false,"hidden":true,"merged":[]}
["Pumpe","Antal pumper","Trykledn.dim.","Trykklasse",null,null,null,"Dykkede","Dykkede",null,null,"Tørtopstillede","Tørtopstillede",null,"Trykledningsruhed",null,null,"C&W Parametre"]
["Dykket",1,90,11,null,"Motorstr min","Motorstr max","Max. Starter [z/h]","Min. t ml. starter [min]","Motorstr min","Motorstr max","Max. Starter [z/h]","Min. t ml. starter [min]",null,0.1,null,null,"Trykledningsruhed",{"$f":"(0.01+0.6)/2/1000","v":3.0499999999999999E-4},"[m]","Tab B.3 i Brorson, ruhed i PVC/PE rør i intervallet 0.01 - 0.6 mm"]
["Tørt",2,110,17,null,0,4,30,2,0,4,20,3,null,0.3,null,null,"Hastighed",{"$f":"('Find sumpvolumen - simpel'!C20/1000)/(PI()*('Find sumpvolumen - simpel'!C24/1000/2)^2)","v":{"$error":"#DIV/0!"}},"[m/s]"]
[null,3,125,26,null,{"$f":"G3","v":4},7.5,25,2.4,{"$f":"K3","v":4},7.5,15,4,null,0.6,null,null,"Reynolds tal",{"$f":"S3*(0.5*'Find sumpvolumen - simpel'!C24/1000)/(1.3*10^(-6))","v":{"$error":"#DIV/0!"}},"[-]"]
[null,null,140,null,null,{"$f":"G4","v":7.5},11,15,4,{"$f":"K4","v":7.5},11,12,5,null,1,null,null,"Friktionsfaktor, f","=2/(6,4-2,45*LN(I2/('CDV (2)'!C24*3,7)+4,7/(I4*SQRT(I5+1^(-300)))))^2"]
[null,null,160,null,null,11,30,10,6,11,30,10,6,null,3]
[null,null,180,null,null,30,100,8,7.5,30,100,8,7.5,null,6]
[null,null,200,null,null,100,null,6,10,100,null,4,15]
[null,null,225]
[null,null,250]
[null,null,280]
[null,null,315]
[null,null,355]
[null,null,400]
[null,null,450]
[null,null,500]
[null,null,560]
[null,null,630]
[null,null,710]
[null,null,800]