{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Druckleitung","Längsschnitt","Q-H Diagramm ohne PW","Q-H Diagramm","Betriebspunkt","Pumpenkennlinie","Druckluftspülung"],"not_rendered":{"charts":6,"images":0,"macros":1,"external_links":0,"defined_names":26,"comments":1,"pivot_tables":0},"unopened":[{"sheet":"Längsschnitt","index":1,"reason":"not_a_worksheet"},{"sheet":"Q-H Diagramm ohne PW","index":2,"reason":"not_a_worksheet"},{"sheet":"Q-H Diagramm","index":3,"reason":"not_a_worksheet"}],"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":"Druckleitung","index":0,"n_rows":11,"n_cols":41,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(AJ:AJ)","v":0},"max Spülzeit"]
[null,"    Eingabedaten",null,null,null,null,null,null,null,null,null,"Förderhöhe =","Förderhöhe =",{"$f":"M4","v":0},null,null,"Förderhöhe =",{"$f":"Q4","v":0},"Förderhöhe =","Förderhöhe =",{"$f":"T4","v":0},null,"Berechnungen zu Lastfall 3",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"MAX(C:C)","v":0},"max QL"]
["Nr.","Kilometer","Q [l/s]","Kb","D  [mm]","H  [m]","Länge [m]","v  [m/s]","l","Jr  [o/oo]","Js  [o/oo]","D h r  [m] ","Pi1 /r*g  [m]"," Hmanmin [m]","bei Kilometer","D h r  [m] ","Pi2 /r*g  [m]"," h man [m]"," D h luft  [m] ","Pi3 /r*g  [m]","Hmanluft [m]","Länge [m]","D Pi,1  [bar] ","D Pi,2  [bar] "," LPi   [m]","S LP`i   [m]","S LPi   [m]","max. LP  [m]"," D LP  [m]","VG","PLP  [bar] ","Pi3  [bar] ","Pi2 [bar] ","Pi1 [bar] ","S Länge' [m]","Spülzeit min","gespülte Länge","Restspülzeit",null,{"$f":"MAX(H:H)","v":0},"max v "]
[1,null,null,null,null,null,{"$f":"IF(B3=\"Kilometer\",0,IF(B3=B4,ABS(F3-F4),SQRT(((-B3+B4)*1000)^2+((-F3+F4)^2))))","v":0},{"$f":"IF(C4=0,0,4*C4/(E4*E4*PI()/1000))","v":0},{"$f":"IF(C4=0,0,(64/(H4*E4/0.00131))*(1-(EXP(-EXP(-(2.519084*H4*E4-8.75)))))+(EXP(-EXP(-(2.519084*H4*E4-8.75))))*(-0.8686*LN(LN(H4*E4/0.00131)^1.2/(H4*E4/0.00131)+D4/(3.71*E4)))^(-2))","v":0},{"$f":"IF(C4=0,0,1000000*I4*H4*H4/(E4*2*9.80665))","v":0},{"$f":"IF(F3=\"H  [m]\",0,(F3-F4)*1000/G4)","v":0},{"$f":"G4*J4/1000","v":0},{"$f":"((CELL(\"Inhalt\",INDEX(AH:AH,ROW()+((COUNT(AH:AH)-1)+((A4-1)*(-2))))))-1)/0.1","v":0},{"$f":"M4+F4","v":0},{"$f":"IF(AND(V4=0,V5>0),B4,\"\")","v":""},{"$f":"IF(K4>J4,G4*K4/1000,G4*J4/1000)","v":0},{"$f":"((CELL(\"Inhalt\",INDEX(AG:AG,ROW()+((COUNT(AG:AG)-1)+((A4-1)*(-2))))))-1)/0.1","v":0},{"$f":"Q4+F4","v":0},{"$f":"IF((K4-J4)/1000*V4=0,\"\",(K4-J4)/1000*V4)","v":""},{"$f":"((CELL(\"Inhalt\",INDEX(AF:AF,ROW()+((COUNT(AF:AF)-1)+((A4-1)*(-2))))))-1)/0.1","v":0},{"$f":"T4+F4","v":0},{"$f":"IF(CELL(\"Inhalt\",INDEX(AF:AF,ROW()+((COUNT(AF:AF)-1)+((A4-1)*(-2)))))=1,0,IF(CELL(\"Inhalt\",INDEX(AF:AF,ROW()+((COUNT(AF:AF))+((A4-1)*(-2)))))=CELL(\"Inhalt\",INDEX(AF:AF,ROW()+((COUNT(AF:AF)-1)+((A4-1)*(-2))))),CELL(\"Inhalt\",INDEX(Y:Y,ROW()+((COUNT(Y:Y))+((A4-1)*(-2))))),CELL(\"Inhalt\",INDEX(AC:AC,ROW()+((COUNT(AC:AC))+((A4-1)*(-2)))))))","v":0},{"$f":"IF(A4=1,0,(CELL(\"Inhalt\",INDEX(F:F,ROW()+((COUNT(F:F))+((A4-1)*(-2)))))-CELL(\"Inhalt\",INDEX(F:F,ROW()+((COUNT(F:F)-1)+((A4-1)*(-2)))))+CELL(\"Inhalt\",INDEX(L:L,ROW()+((COUNT(L:L))+((A4-1)*(-2))))))*0.1)","v":0},{"$f":"IF(A4=1,0,(CELL(\"Inhalt\",INDEX(F:F,ROW()+((COUNT(F:F))+((A4-1)*(-2)))))-CELL(\"Inhalt\",INDEX(F:F,ROW()+((COUNT(F:F)-1)+((A4-1)*(-2)))))+CELL(\"Inhalt\",INDEX(P:P,ROW()+((COUNT(P:P))+((A4-1)*(-2))))))*0.1)","v":0},{"$f":"IF(A4=1,0,IF(ROUND(CELL(\"Inhalt\",INDEX(N:N,ROW()+((COUNT(N:N)-2)+((A4-1)*(-2))))),3)=ROUND(CELL(\"Inhalt\",INDEX(R:R,ROW()+((COUNT(R:R)-2)+((A4-1)*(-2))))),3),0,IF(W4=(CELL(\"Inhalt\",INDEX(F:F,ROW()+((COUNT(F:F))+((A4-1)*(-2)))))-CELL(\"Inhalt\",INDEX(F:F,ROW()+((COUNT(F:F)-1)+((A4-1)*(-2)))))+CELL(\"Inhalt\",INDEX(P:P,ROW()+((COUNT(P:P))+((A4-1)*(-2))))))*0.1,0,CELL(\"Inhalt\",INDEX(G:G,ROW()+((COUNT(G:G))+((A4-1)*(-2))))))))","v":0},{"$f":"IF(A4=1,0,IF((CELL(\"Inhalt\",INDEX(Y:Y,ROW()+((COUNT(Y:Y))+((A4-1)*(-2))))))=0,(CELL(\"Inhalt\",INDEX(Y:Y,ROW()+((COUNT(Y:Y))+((A4-1)*(-2)))))),Z3+(CELL(\"Inhalt\",INDEX(Y:Y,ROW()+((COUNT(Y:Y))+((A4-1)*(-2))))))))","v":0},{"$f":"CELL(\"Inhalt\",INDEX(Z:Z,ROW()+((COUNT(Z:Z))+((A4-1)*(-2)))))","v":0},{"$f":"IF(A4=1,0,IF(AA4=0,AA4,IF(AND(AA5<AA4,AA3=0),AA4,AB3)))","v":0},{"$f":"IF(A4=1,0,IF(Y4=0,0,IF(-(AA5+((AF3+W4)/(-W4/Y4)))/2+SQRT(((AA5+((AF3+W4)/(-W4/Y4)))/2)^2-(((AF3+W4)*AA5-AB4)/(-W4/Y4)))<0,0,IF(OR(AC3>0,AD3=\"LP\"),0,-(AA5+((AF3+W4)/(-W4/Y4)))/2+SQRT(((AA5+((AF3+W4)/(-W4/Y4)))/2)^2-(((AF3+W4)*AA5-AB4)/(-W4/Y4)))))))","v":0},{"$f":"IF(A4=1,0,IF(AND(AA4>0,AC4>0),\"SP\",IF(AND(AA4=0,AB4=0),0,IF(AND(AE4>AE3,AE4<AF3+W4),0,\"LP\"))))","v":0},{"$f":"IF(AA4=0,1,IF(AA5=0,AA4,AB4/AA5))","v":1},{"$f":"IF(A4=1,1,IF(AD4=\"SP\",AB4/(AC4+AA5),IF(AD4=\"LP\",AF3,IF(AF3+W4<1,AF3,AF3+W4))))","v":1},{"$f":"IF(A4=1,1,IF(AG3+X4<1,1,AG3+X4))","v":1},{"$f":"IF(A4=1,1,IF(AH3+W4<1,1,AH3+W4))","v":1},{"$f":"B4*1000","v":0},{"$f":"IF(H4=0,0,(G4/H4)/60)","v":0},{"$f":"IF(AL4>0,H4*60*AJ4,IF(AND(AL3>0,AL4<0),H4*60*AL3,0))","v":0},{"$f":"$AN$7-SUM($AJ$4:AJ4)","v":0},null,{"$f":"MIN(H:H)","v":0},"min v"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(G:G)","v":0},"Gesamtlänge"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"MAX(E:E)","v":0},"max Durchmesser"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"gew. Spülzeit"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(AK:AK)","v":0},"gespülte Leitung"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNT(A:A)","v":1},"Anzahl Datensätze"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"MIN(E:E)","v":0},"min Durchmesser"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"MIN(F:F)","v":0},"min Höhenkote"]

{"sheet":"Betriebspunkt","index":4,"n_rows":15,"n_cols":12,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
[null,"x","y(p)","y(min)","y(luft)"," ","Hman p [m]"]
[{"$f":"COUNT(Pumpenkennlinie!B:B)","v":0},"Q [l/s]","Hman p [m]","Hman min [m]","Hman luft [m]",null,"x","y(p)","m","a"]
[null,null,null,null,null,null,null,null,{"$f":"SLOPE(H3:H4,G3:G4)","v":{"$error":"#DIV/0!"}},{"$f":"INTERCEPT(H3:H4,G3:G4)","v":{"$error":"#DIV/0!"}}]
[]
[null,null,null,null,null,null,"Hman min [m]"]
[null,null,null,null,null,null,"x","y(min)","m","a","Betriebspunkt","Differenz"]
[null,null,null,null,null,null,null,null,{"$f":"SLOPE(H7:H8,G7:G8)","v":{"$error":"#DIV/0!"}},{"$f":"INTERCEPT(H7:H8,G7:G8)","v":{"$error":"#DIV/0!"}},{"$f":"IF(G7=0,0,(J3-J7)/(I7-I3))","v":0},{"$f":"K7-G7","v":0}]
[]
[null,null,null,null,null,null,"Hman p [m]"]
[null,null,null,null,null,null,"x","y(p)","m","a"]
[null,null,null,null,null,null,null,null,{"$f":"SLOPE(H11:H12,G11:G12)","v":{"$error":"#DIV/0!"}},{"$f":"INTERCEPT(H11:H12,G11:G12)","v":{"$error":"#DIV/0!"}}]
[]
[null,null,null,null,null,null,"Hman luft [m]"]
[null,null,null,null,null,null,"x","y(luft)","m","a","Betriebspunkt","Differenz"]
[null,null,null,null,null,null,null,null,{"$f":"SLOPE(H15:H16,G15:G16)","v":{"$error":"#DIV/0!"}},{"$f":"INTERCEPT(H15:H16,G15:G16)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR(G15=0,G15=\"Q [l/s]\"),0,(J11-J15)/(I15-I11))","v":0},{"$f":"K15-G15","v":0}]

{"sheet":"Pumpenkennlinie","index":5,"n_rows":21,"n_cols":8,"rows_kept":21,"cut":false,"hidden":false,"merged":[[0,4,0,7]]}
[null,null,null,null,"Rohrkennlinie"]
[null,"Q [l/s]","Hman p [m]",null,"Q [l/s]","Hman min [m]","Hman luft [m]","Hman max [m]"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Fördermenge der Pumpe bei Hmanmin =",null,null,null,{"$f":"IF(OR(Betriebspunkt!K7=0,Betriebspunkt!K15=0),\"\",Betriebspunkt!K7)","v":""}]
[]
[null,null,null,"Fördermenge der Pumpe bei Hmanluft =",null,null,null,{"$f":"IF(Betriebspunkt!K15=0,\"\",Betriebspunkt!K15)","v":""}]

{"sheet":"Druckluftspülung","index":6,"n_rows":31,"n_cols":3,"rows_kept":31,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[null,"gewählte Spülgeschwindigkeit:",0]
[]
[null,"erforderlicher Spüldruck psp: ",1.4345976114273071]
[]
[null,"max. mögliche Spülzeit:",0]
[]
[null,"Förderstrom  QLeitung:",0]
[]
[null,"vmax:",0]
[]
[null,"vmin:"]
[]
[null,"gewählte Spülzeit:",0]
[]
[null,"gesamte Leitungslänge :",2315.475830078125]
[]
[null,"gespülte Leitungslänge:",0]
[]
[null,"gesamtes Leitungsvolumen",0]
[]
[null,"gespültes Leitungsvolumen VR:",0]
[]
[null,"gewählter Kesseldruck pk:",0]
[]
[null,"erforderliches Kesselvolumen Vk:",0]
[]
[null,"Förderstrom Kompressor Qkomp:",{"$f":"(C6+1)*C10*3.6","v":0}]
[null,"(bei direktem Einblasen ohne Druckkessel)"]