{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Druckdispositiv"],"not_rendered":{"charts":1,"images":5,"macros":1,"external_links":2,"defined_names":47,"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":"Druckdispositiv","index":0,"n_rows":63,"n_cols":13,"rows_kept":63,"cut":false,"hidden":false,"merged":[[28,5,28,6],[29,5,29,6],[30,1,30,3],[30,11,30,12],[23,1,23,3],[23,5,23,7],[23,10,23,11],[25,5,25,6],[26,5,26,6],[27,5,27,6],[22,1,22,3],[22,10,22,11],[15,1,15,3],[15,10,15,11],[16,9,16,12],[18,1,18,3],[18,6,18,7],[18,10,18,11],[19,10,19,11],[20,10,20,11],[21,1,21,3],[21,6,21,7],[21,10,21,11],[9,1,9,3],[9,10,9,11],[10,10,10,11],[12,10,12,11],[13,10,13,11],[14,10,14,11],[3,5,3,6],[3,8,3,9],[3,11,3,12],[5,6,5,7],[6,6,6,7],[7,6,7,7],[7,10,7,11],[1,5,1,6],[1,8,1,9],[1,11,1,12],[2,5,2,6],[2,8,2,9],[2,11,2,12]]}
[null,"Bestimmung der Belastungswerte und Spitzendurchfluss Hausanschlussleitung"]
[null,"Teilstrecke","Σ LU\n(früher DU)\n[LU]","Σ  Fluss\nQT = LU*0.1 \n[l/s]",null,"Spitzendurchfluss\nQD1 = 0.598 * QT0.257\n[l/s]",null,null,"Spitzendurchfluss \nQD2 = bes. Zustände\n[l/s]",null,null,"Spitzendurchfluss\nQD = QD1 + QD2 \n[l/s]"]
[null,"Hausanschlussleitung",0,{"$f":"IF(C3=\"\",\"\",C3*0.1)","v":0},"*",{"$f":"ROUND(0.598*POWER(D3,0.257),2)","v":0},null,"+",0,null,"=",{"$f":"F3+I3","v":0}]
[null,"Druckminderer",0,{"$f":"IF(C4=\"\",\"\",C4*0.1)","v":0},null,{"$f":"IF(C4=\"\",\"\",ROUND(0.598*POWER(D4,0.257),2))","v":0},null,"+",0,null,"=",{"$f":"IF(F4=\"\",\"\",F4+I4)","v":0}]
[null,"Berechnung des Betriebsdruckes nach dem Wasserzähler"]
[null,"Höhe Reservoir der Netzbetreiberin (Überlauf)",null,null,null,"h1 =",655.20000000000005]
[null,"Höhe Hausanschlussleitung bei Verteilbatterie",null,null,null,"h2 =",0]
[null,"Differenz Reservoir - Verteilbatterie",null,null,null,"Δh12 =",{"$f":"IF(AND(G6=\"\",G7=\"\"),\"\",G6-G7)","v":655.20000000000005},null,null,"pRh1 ≈",{"$f":" $G$8*9.81","v":6427.5120000000006},null,{"$f":"K8/100","v":64.275120000000001}]
[]
[null,"Druckschwankungen im Reservoir und Netz",null,null,null,null,null,null,null,"∆pVL =",50,null,{"$f":"K10/100","v":0.5}]
[null,"Versorgungsdruck:",null,null,null,"SP = pRh1 - ∆pVL",null,null,null,"SP =",{"$f":"K8-K10","v":6377.5120000000006},null,{"$f":"K11/100","v":63.775120000000008}]
[]
[null,"Druckverlust Hausanschlussleitung (Annhahme)",null,null,null,null,null,null,null,"∆pAL =",50,null,{"$f":"K13/100","v":0.5}]
[null,"- Δp Wasserzähler","bei QD =",{"$f":"L3","v":0},null,null,null,null,null,"∆pWZ =",45,null,{"$f":"K14/100","v":0.45}]
[null,"- Δp Feinfilter Netzdruck","bei QD =",{"$f":"L3","v":0},null,null,null,null,null,"∆pFN =",0,null,{"$f":"K15/100","v":0}]
[null,"Betriebsdruck nach dem Wasserzähler:",null,null,null,"OPWZ = SP - ∆pAL - ∆pWZ",null,null,null,"OPWZ =",{"$f":"ROUND(K11-SUM(K13:K15),0)","v":6283},null,{"$f":"K16/100","v":62.83}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(K11<=500,\"Passtückes für DM einbauen.\",\"Druckminderer einbauen.\")","v":"Druckminderer einbauen."}]
[null,"Berechnung des zur Verfügung stehenden Druckverlustes"]
[null,{"$f":"IF(K16<=500,\"Betriebsdruck nach dem Wasserzähler\",\"Ruhedruck für Druckminderer\")","v":"Ruhedruck für Druckminderer"},null,null,null,"PR DM =",500,null,null,{"$f":"IF(K16<=500,J16,F19)","v":"PR DM ="},{"$f":"IF(K16<=500,K16,G19)","v":500},null,{"$f":"K19/100","v":5}]
[null,"- Δp Feinfilter","bei QD =",{"$f":"IF(L4=\"\",$L$3,$L$4)","v":0},null,null,null,null,null,"∆pAPP2 =",0,null,{"$f":"IF(K20=\"\",\"\",K20/100)","v":0}]
[null,"- Δp Enthärtung","bei QD =",{"$f":"IF(L4=\"\",$L$3,$L$4)","v":0},null,null,null,null,null,"∆pAPP3 =",0,null,{"$f":"IF(K21=\"\",\"\",K21/100)","v":0}]
[null,"Höhenunterschied DM - höchste Entnahmestelle",null,null,null,"h2 =",0,null,null,"pRh2 ≈",{"$f":"IF(G22=\"\",\"\",G22*1000*9.81/1000)","v":0},null,{"$f":"K22/100","v":0}]
[null,"Fliessdruck höchste Entnahmestelle",null,null,null,null,null,null,null,"pminFl =",0,null,{"$f":"fl/100","v":0}]
[null,"Zur Verfügung stehender Druckverlust",null,null,null,"∆pL = OPWZ - ∆pAPP - pRh2 - pminFl",null,null,null,"∆pL =",{"$f":"K19-SUM(K20:K21)-K22-fl","v":500},null,{"$f":"K24/100","v":5}]
[null,"Entscheidungsgrundlagen"]
[null,"- Alle Apparate gemäss:",null,null,null,"Tabelle 3",null,true]
[null,"- Max. Abgewickelte Rohrlänge Stockwerk",null,null,null,"< 15 m",null,true]
[null,"- Max. Abgewickelte Rohrlänge Verteilleitungen",null,null,null,"< 35 m",null,true]
[null,"- Besondere Zustände",null,null,null,"Diagramm 1",null,true]
[null,"- Zur Verfügung stehender Druckverlust",null,null,null,{"$f":"$K$24","v":500},null,150]
[null,"Entscheid für Rohrweitenbestimmung:",null,null,null,{"$f":"IF(H26=TRUE,IF(H27=TRUE,IF(H28=TRUE,IF(H29=TRUE,IF(F30>150,\"Vereinfachte Rohrweitenbestimmung.\",\"Berechnungsverfahren durchführen.\"),\"Berechnungsverfahren durchführen.\"),\"Berechnungsverfahren durchführen.\"),\"Berechnungsverfahren durchführen.\"),\"Berechnungsverfahren durchführen.\")","v":"Vereinfachte Rohrweitenbestimmung."}]
[]
[null,"Daten für Druckdispositiv"]
[null,null,"x","y"]
[null,"Statischer Druck",0,{"$f":"K8","v":6427.5120000000006}]
[null,null,4,{"$f":"K8","v":6427.5120000000006}]
[null,"- Schwankungen Wasserstand",4,{"$f":"D36-K10","v":6377.5120000000006}]
[null,"- dp Hauptleitung",8,{"$f":"D37-X42","v":6377.5120000000006}]
[null,"- dp Zuleitung",12,{"$f":"D38-K13","v":6327.5120000000006}]
[null,null,12,{"$f":"D39-X44","v":6327.5120000000006}]
[null,null,16,{"$f":"D40","v":6327.5120000000006}]
[null,"- dp Zähler",16,{"$f":"D41-K14","v":6282.5120000000006}]
[null,null,20,{"$f":"D42","v":6282.5120000000006}]
[null,"- dp Feinfilter",20,{"$f":"D43-K15","v":6282.5120000000006}]
[null,null,24,{"$f":"D44","v":6282.5120000000006}]
[null,"= vordruck",28,{"$f":"D45","v":6282.5120000000006}]
[null,null,28,{"$f":"D46","v":6282.5120000000006}]
[null,null,28,{"$f":"IF(vordruck>=nachdruck,vordruck,aus)","v":6283},null,{"$f":"D48","v":6283}]
[null,null,28,{"$f":"IF(vordruck>nachdruck,vordruck,aus)","v":6283}]
[null,null,28,{"$f":"IF(vordruck>nachdruck,vordruck,D51)","v":6283}]
[null,null,28,{"$f":"IF(vordruck>nachdruck,vordruck,ein)","v":6283}]
[null,null,28,{"$f":"IF(vordruck>nachdruck,vordruck,ein)","v":6283},null,{"$f":"D51","v":6283}]
[null,"DM",28,{"$f":"IF(vordruck>=nachdruck,D46,D55)","v":6282.5120000000006}]
[null,"- Funktion",28,{"$f":"IF(vordruck>=nachdruck,D55,D52)","v":500}]
[null,"= nachdruck",28,{"$f":"K19","v":500}]
[null,"- dp Druckminderer",28,{"$f":"D55-K20","v":500}]
[null,"- dp Feinfilter",32,{"$f":"D58+K20","v":500}]
[null,"- dp Enthärtung",32,{"$f":"D60+K21","v":500}]
[null,null,36,{"$f":"D58","v":500}]
[null,"Steigleitung",36,{"$f":"D62+K22","v":500}]
[null,null,40,{"$f":"D60","v":500}]
[null,"Druckverlust",40,{"$f":"D63+K24","v":500}]
[null,"Fliessdruck",44,{"$f":"IF(vordruck<nachdruck,fl,IF((vordruck-nachdruck)<=0.5,fl+(vordruck-nachdruck),fl))","v":0}]