{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Anleitung","Verlustbeiwert","Formblatt1a","Strangverbrauch","Einzelgerät","Anschlußw","Gleichzeitig","Kupfer","Gewinde"],"not_rendered":{"charts":0,"images":1,"macros":0,"external_links":0,"defined_names":94,"comments":5,"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":"Anleitung","index":0,"n_rows":17,"n_cols":2,"rows_kept":17,"cut":false,"hidden":false,"merged":[[0,0,0,1]]}
["Anleitung zur Benutzung der Excel-Tabelle"]
[]
[null,"DIESE DATEI IST OHNE ANSPRUCH AUF RICHTIGKEIT ... ÜRTÜMER SIND NICHT AUSGESCHLOSSEN ... BENUTZUNG AUF EIGENES RISIKO UND EIGENE GEFAHR ...DIESE DATEI JETZT BITTE ERST \"SPEICHERN UNTER\" MIT ANDEREM DATEINAMEN AUF DEM PC SPEICHERN, SONST WIRD DIESE URSPRÜNGLICHE DATEI ÜBERSCHRIEBEN . AM BESTEN VERWENDET MAN DAZU DIE PROJEKTBEZEICHNUNG z.B.: MEYER-GAS-2002.XLS"]
[null,"Vorraussetzung zur Bedienung dieser Tabelle ist natürlich die Fachkompetenz ... Wer nicht weiß um was es hier geht wird's auch nicht so schnell herausfinden :-)"]
[null,"Eingabefelder sind gelb; berechnete Felder grau und hinweisende Felder weiß hinterlegt. Wenn bei der Eingabe von Daten das Datenfeld rot wird zeigt das eine Fehleingabe an. In der Regel passen dann die Daten nicht mit vorangegangenen Eingaben zusammen. Hier gilt es dann die Ursache zu finden."]
[null,"Erklärungen sind bei den Felder mit dem kleinen roten Dreieck (oben rechts) hinterlegt und können gelesen werden, wenn man mit der Maustaste auf das Feld zeigt (nicht klicken sondern nur den Mauszeiger irgendwo HIER hin halten ) Dieses Feld hat auch einen Text hinterlegt !"]
[null,"Die Vorgehensweise sollte die ersten Male anhand der folgenden Auflistung erfolgen. Durch das abhaken der einzelnen Punkte erreicht man eine gewisse Kontrolle des Vorgehens. Nach mehrmaliger Benutzung wird diese Seite dann bestimmt nicht mehr benötigt werden. Jetzt geht's los !"]
[1,"Als erstes muss die isometrische Zeichnung angefertigt werden. Diese Zeichnung wird dann durch die Geräte mit den dazugehörigen Anschlusswerten komplettiert."]
[2,"Einteilung der Teilstrecken in Vt; Vb; Ab und Ez und deren Nummerierung. Wenn es nach dem Zähler nur einen Verbraucher gibt (z.B. ein Heizkessel) darf nach DIN der zulässige Druckverlust für die Vb und die Ab summiert werden ... In dieser Strecke dürfen dann also als Teilstrecke Ez 0,5 mbar + 0,8 mbar = 1,3 mbar verbraucht werden ... oder einfach das Blatt \"Einzelgerät\" benutzen :-)"]
[3,"Vermerk der fallenden oder steigenden Strecken in den jeweiligen Teilstrecken mit Meterangaben. Hinzufügen der Gesamtlänge der Teilstrecke"]
[null,"Jetzt geht's im Computer weiter !"]
["4","Anhand der Zeichnung werden nun die Formstücke und z.B. Kugelhähne in das Blatt Verlustbeiwert eingegeben. Die ermittelten Daten werden automatisch in dem Blatt Formblatt1a übernommen. Sofern die gesonderten Anschlußbedingungen des GVU's das zulassen hier einTIP: Wenn die HAE und der (einzige) Gaszähler in einem Raum installiert sind muß kein Kugeleckhahn auf die Zählerplatte, dass ist meistens ein entscheidender  Verlust durch Einzelwiderstand den man sich sparen kann, 'mal ganz abgesehen vom Material : TRGI '86, Teil 3 Abschnitt 3.7.8 Ist nur ein Gaszähler hinter der HAE angeschlossen und befindet sich dieser Gaszähler mit der HAE in dem selben Raum, dann ist eine weitere Absperreinrichtung nicht erforderlich."]
["5","Eingabe der Daten in das Blatt Formblatt1a. Jede Teilstrecke wird komplett eingegeben. Außer bei Teilstrecke 1 (Vt) müssen in der letzten Spalte die zusammenhängenden Teilstrecken eingegeben werden. Hierdurch werden zusammenhängende Teilstrecken summiert und dienen der Kotrolle des gesamten Druckverlustes in z.B. mehrerer Verbrauchsleitungen (Vb) oder des gesamten Druckverlustes vom Gerät bis zur TAE. Man fügt die noch fehlenden und dazwischenliegenden Teilstrecken zu den bereits fest eingegebenen Teilstrecken hinzu. z.B. 6 4 2 1 ... treten anschließend oder beim Löschen von Zahlen Probleme auf, so liegt das meistens daran, dass in diesen Feldern immer eine NULL \"0\" stehen muss ...                                                                                                                                                     KEINE ZAHLEN MIT DER TASTE \"ENTFERNEN\" LÖSCHEN ! ...  IMMER EINE \"0\" EINGEBEN"]
["6","Jetzt sollten brauchbare Dimensionen erreicht werden ... Man kann nun natürlich auch damit spielen, welche Teilstrecke (z.B. bei mehreren Vb's) welche Dimension bekommt ... Ist es sinnvoller die ganze Strecke gleichmäßig zu Dimensionieren oder soll sie in verschiedene Dimensionen installiert werden ? ... das liegt im Ermessen des Meisters !"]
[" ","DIESE DATEI IST OHNE ANSPRUCH AUF RICHTIGKEIT ... IRRTÜMER SIND NICHT AUSGESCHLOSSEN ... BENUTZUNG AUF EIGENES RISIKO UND EIGENE GEFAHR ... Und nicht vergessen ... Hier saß und sitzt ein Meister des Installations- und Heizungsbauhandwerks und kein Programmierer ... Wenn also nicht alle Fehlfunktionen abgedeckt wurden - bitte mitteilen - und nicht meckern ...                                                "]
[" ","Mit freundlichen Grüßen       me. Hasko Ahrendt"]
[" "]

{"sheet":"Verlustbeiwert","index":1,"n_rows":31,"n_cols":36,"rows_kept":31,"cut":false,"hidden":false,"merged":[[3,10,3,11],[3,12,3,13],[3,14,3,15],[3,16,3,17],[30,1,30,2],[3,4,3,5],[3,6,3,7],[3,8,3,9],[0,21,0,22],[3,28,3,29],[3,30,3,31],[3,32,3,33],[3,18,3,19],[3,34,3,35],[3,20,3,21],[3,22,3,23],[3,24,3,25],[3,26,3,27]]}
[null,null,"Zusammenstellung der Verlustbeiwerte z",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Blatt - Nr. :"]
["Lfd.","Form- und Ver-","Graphische","Verlust-",null,null,null,null,null,null,null,null,"Teilstrecken"]
["Nr.","bindungsstücke","Symbole","beiwerte"]
[null,"Armaturen",null,"z",1,null,2,null,3,null,4,null,5,null,6,null,7,null,8,null,9,null,10,null,11,null,12,null,13,null,14,null,15,null,16]
[1,"Reduzierstück",null,0.4,0,{"$f":"(E5*D5)","v":0},0,{"$f":"(G5*D5)","v":0},0,{"$f":"(I5*D5)","v":0},0,{"$f":"(K5*D5)","v":0},0,{"$f":"(M5*D5)","v":0},0,{"$f":"(O5*D5)","v":0},0,{"$f":"(Q5*D5)","v":0},0,{"$f":"(S5*D5)","v":0},0,{"$f":"(U5*D5)","v":0},0,{"$f":"(W5*D5)","v":0},0,{"$f":"(Y5*D5)","v":0},0,{"$f":"(AA5*D5)","v":0},0,{"$f":"(AC5*D5)","v":0},0,{"$f":"(AE5*D5)","v":0},0,{"$f":"(AG5*D5)","v":0},0,{"$f":"(AI5*D5)","v":0}]
[2,"Etagenbogen",null,0.5,null,{"$f":"(E6*D6)","v":0},null,0,null,{"$f":"(I6*D6)","v":0},null,{"$f":"(K6*D6)","v":0},null,{"$f":"(M6*D6)","v":0},null,{"$f":"(O6*D6)","v":0},null,{"$f":"(Q6*D6)","v":0},null,{"$f":"(S6*D6)","v":0},null,{"$f":"(U6*D6)","v":0},0,{"$f":"(W6*D6)","v":0},null,{"$f":"(Y6*D6)","v":0},null,{"$f":"(AA6*D6)","v":0},null,{"$f":"(AC6*D6)","v":0},null,{"$f":"(AE6*D6)","v":0},null,{"$f":"(AG6*D6)","v":0},null,{"$f":"(AI6*D6)","v":0}]
[3,"Winkel o. Bogen",null,0.7,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[4,"T-Stück 90° Durchg.",null,0.3,0,0,null,0,0,0,0,0,null,0,null,0,null,0,0,0,null,0,0,0,null,0,0,0,null,0,0,0,null,0,null,0]
[5,"T-Stück 90° Abzw.",null,1.3,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[6,"Reinigungs-T-Stück",null,1.3,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[7,"T-Stück 90° Gegenl.",null,1.5,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[8,"Bogen-T Durchg.",null,0.3,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[9,"Bogen-T Abzw.",null,0.9,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[10,"Reinigungsbogen-T",null,0.9,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[11,"Zweibogen-T \nGegenlauf",null,1.3,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[12,"Kreuzstück 90° \nDurchgang",null,1.3,0,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[13,"Kreuzstück 90°   \n Abzweig",null,2,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[14,"Reinigungskreuz -   \nstück 90° Durchg.",null,0.5,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[15,"Reinigungskreuz -   \nstück 90° Abzw.",null,1.3,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[15,"Anschlstück -DN25",null,2,null,0,null,0,null,0,null,0,0,0,null,0,null,0,null,0,null,0,null,0,null,0,0,0,null,0,null,0,null,0,null,0]
[null,"EinstutzenGZ>DN25","Z",4,null,0,null,0,null,0,null,0,0,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[17,"Absperrhahn (Kegel) \nDurchgang",null,2,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,0,0]
[18,"Absperrhahn (Kegel) Eckform\n(Sicherheitsarmatur)",null,5,0,0,null,0,null,0,0,0,0,0,null,0,null,0,null,0,null,0,null,0,null,0,0,0,null,0,null,0,null,0,null,0]
[19,"Absperrhahn          \n(Kugel) Durchg.",null,0.5,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,null,0]
[20,"Absperrhahn       \n(Kugel) Eckform",null,1.3,0,0,null,0,null,0,null,0,0,0,0,0,null,0,null,0,0,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[21,"Absperrschieber",null,0.5,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,0,0,null,0,null,0]
[22,"Thermisch auslösende\nAbsperreinrichtung",null,2,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,0,0,null,0,0,0,0,0,null,0,null,0]
[null,"S z in den Teilstrecken"]
[null,null,null,null,null,{"$f":"SUM(F5:F27)","v":0},null,{"$f":"SUM(H5:H27)","v":0},null,{"$f":"SUM(J5:J27)","v":0},null,{"$f":"SUM(L5:L27)","v":0},null,{"$f":"SUM(N5:N27)","v":0},null,{"$f":"SUM(P5:P27)","v":0},null,{"$f":"SUM(R5:R27)","v":0},null,{"$f":"SUM(T5:T27)","v":0},null,{"$f":"SUM(V5:V27)","v":0},null,{"$f":"SUM(X5:X27)","v":0},null,{"$f":"SUM(Z5:Z27)","v":0},null,{"$f":"SUM(AB5:AB27)","v":0},null,{"$f":"SUM(AD5:AD27)","v":0},null,{"$f":"SUM(AF5:AF27)","v":0},null,{"$f":"SUM(AH5:AH27)","v":0},null,{"$f":"SUM(AJ5:AJ27)","v":0}]
[null,null,null,null,null,1,null,2,null,3,null,4,null,5,null,6,null,7,null,8,null,9,null,10,null,11,null,12,null,13,null,14,null,15,null,16]
[null," ",null,null,null,null,null,null,null,null,null,null,"Teilstrecken",null,null,null,null,null,null,null,null,null,null,null,"Teilstrecken"]

{"sheet":"Formblatt1a","index":2,"n_rows":109,"n_cols":30,"rows_kept":109,"cut":false,"hidden":false,"merged":[[56,9,56,13],[62,9,62,13],[50,9,50,13],[58,14,58,16],[62,14,62,16],[57,14,57,16],[14,9,14,13],[20,9,20,13],[26,9,26,13],[32,9,32,13],[38,14,38,16],[40,14,40,16],[86,9,86,13],[71,7,72,17],[77,7,78,17],[75,14,75,16],[81,14,81,16],[86,14,86,16],[83,7,84,17],[74,14,74,16],[76,14,76,16],[80,14,80,16],[106,14,106,16],[101,7,102,17],[98,14,98,16],[89,7,90,17],[99,14,99,16],[105,14,105,16],[104,9,104,13],[88,14,88,16],[92,9,92,13],[98,9,98,13],[95,7,96,17],[92,14,92,16],[94,14,94,16],[87,14,87,16],[93,14,93,16],[44,14,44,16],[46,14,46,16],[50,14,50,16],[52,14,52,16],[47,7,48,17],[45,14,45,16],[51,14,51,16],[44,9,44,13],[35,7,36,17],[39,14,39,16],[38,9,38,13],[26,14,26,16],[28,14,28,16],[32,14,32,16],[34,14,34,16],[29,7,30,17],[27,14,27,16],[33,14,33,16],[8,0,10,0],[2,2,2,5],[2,7,2,11],[2,14,2,16],[8,2,8,3],[9,1,10,1],[9,2,10,2],[9,3,10,3],[2,18,2,23],[4,18,4,23],[7,18,7,23],[8,18,8,23],[9,18,10,23],[3,18,3,23],[5,18,5,23],[23,18,23,23],[24,18,24,23],[13,18,13,23],[17,18,17,23],[18,18,18,23],[11,18,11,23],[12,18,12,23],[31,18,31,23],[32,18,32,23],[35,18,35,23],[36,18,36,23],[25,18,25,23],[26,18,26,23],[29,18,29,23],[30,18,30,23],[42,18,42,23],[43,18,43,23],[44,18,44,23],[47,18,47,23],[37,18,37,23],[38,18,38,23],[41,18,41,23],[54,18,54,23],[55,18,55,23],[56,18,56,23],[59,18,59,23],[48,18,48,23],[49,18,49,23],[50,18,50,23],[53,18,53,23],[80,18,80,23],[66,18,66,23],[67,18,67,23],[68,18,68,23],[71,18,71,23],[60,18,60,23],[61,18,61,23],[62,18,62,23],[65,18,65,23],[101,18,101,23],[86,18,86,23],[89,18,89,23],[83,18,83,23],[72,18,72,23],[73,18,73,23],[74,18,74,23],[77,18,77,23],[78,18,78,23],[79,18,79,23],[102,18,102,23],[90,18,90,23],[91,18,91,23],[92,18,92,23],[95,18,95,23],[84,18,84,23],[85,18,85,23],[96,18,96,23],[97,18,97,23],[98,18,98,23],[82,14,82,16],[68,9,68,13],[74,9,74,13],[80,9,80,13],[64,14,64,16],[68,14,68,16],[70,14,70,16],[65,7,66,17],[69,14,69,16],[0,18,0,23],[41,7,42,17],[53,7,54,17],[59,7,60,17],[11,7,12,17],[17,7,18,17],[23,7,24,17],[16,14,16,16],[56,14,56,16],[22,14,22,16],[103,18,103,23],[104,18,104,23],[100,14,100,16],[104,14,104,16],[15,14,15,16],[21,14,21,16],[20,14,20,16],[19,18,19,23],[20,18,20,23],[63,14,63,16]]}
[null,null,null,null,null,null,null,null,null,null,"Ermittlung der Rohrdurchmesser ( differenziertes Verfahren )",null,null,null,null,null,null,null,"meIsIme - akademie"]
[]
["Projekt :",null," ",null,null,null,"Name:",null,null,null,null,null,null,"Datum :"," ",null,null,"Blatt - Nr.:"," ",null,null,null,null,null,null,null,"Aufrundung der VS-Werte bei Überschreitung von:"]
["Vt","Verteilungsleitungen :",null,null,null,null,"Dp zul < 0,3 mbar",null,null,null,null,null,null,null,null,null,null,"Rohrart:","Cu",null,null,null,null,null,null,null,"0,4",null,null,{"$f":"IF($S$8=\"K1  waagerecht\",1,0)","v":0}]
["Vb","Verbrauchsleitungen :",null,null,null,null,"Dp zul < 0,8 mbar",null,null,null,null,null,null,"1.Gasfamilie",null,null,null,"DIN 2440",{"$f":"IF(S4=\"Stahl\",\"x\",\" \")","v":" "},null,null,null,null,null,null,null,null,null,null,{"$f":"IF($S$8=\"K2  waagerecht\",1,0)","v":0}]
["Ab","Abzweig - und Geräte -",null,null,null,null,"Dp zul < 0,5 mbar  (Gasfamilie 1+2)",null,null,null,null,null,"x","2.Gasfamilie",null,null,null,"DIN 1786",{"$f":"IF(S4=\"Cu\",\"x\",\" \")","v":"x"},null,null,null,null,null,null,null,null,null,null,{"$f":"IF($S$8=\"K3  waagerecht\",1,0)","v":1}]
[" ","anschlußleitungen :",null,null,null,null," ",null,null,null,null,null,null,"4.Gasfamilie",null,null,null," ",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($S$8=\"M1  senkrecht\",2,0)","v":0}]
["Ez","Einzelanschlußleitung",null,null,null,null,"Dp zul < 1,3 mbar",null,null,null,null,null,null,null,null,null,null,"GS Typ","K3  waagerecht",null,null,null,null,null,null,null,null,null,null,{"$f":"IF($S$8=\"M2  senkrecht\",2,0)","v":0}]
["Leitungsart",1,2,null,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,null,null,null,null,null,1,null,null,null,null,{"$f":"IF($S$8=\"M3  senkrecht\",2,0)","v":0}]
[null,"TS","Geräte- art","An- zahl","S VA  Geräte","fG         Geräte","___","VS","l","DN","v","R","R x l","Sz","Z","DH","DpH","DpTS","Kontrolle\nSDpTS\n< pzul",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(AD4:AD9)","v":1}]
[null,null,null,null,"m³/h","___","m³/h","m³/h","m","___","m/s","mbar m","mbar","___","mbar","m","mbar","mbar",null,null,null,null,null,null,null,null,null,null,null,"GS-Typ"]
["Vt",null,"H",0,0,{"$f":"IF(E12=0,0,VLOOKUP(D12,Gleichzeitig!$B$3:$F$52,VLOOKUP(C12,Gleichzeitig!$J$5:$K$8,2,0)))","v":0},{"$f":"$E12*$F12","v":0},{"$f":"IF(((J14<25)*AND(J14>0)),\"Einige GVU's verlangen in der Vt mindestens DN 25 ! ... Bitte überprüfen !\",0)","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(($A$12=\"Vt\")*AND(Strangverbrauch!C1>0.399),\"Vtges. > 0,399mbar\",0)","v":0}]
[". ",null,"DWH",0,0,{"$f":"IF(E13=0,0,VLOOKUP(D13,Gleichzeitig!$B$3:$F$52,VLOOKUP(C13,Gleichzeitig!$J$5:$K$8,2,0)))","v":0},{"$f":"$E13*$F13","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(($A$12=\"Vb\")*AND(Strangverbrauch!C1>0.899),\"Vbges. > 0,899mbar\",0)","v":0}]
[null,1,"RH",0,0,{"$f":"IF(E14=0,0,VLOOKUP(D14,Gleichzeitig!$B$3:$F$52,VLOOKUP(C14,Gleichzeitig!$J$5:$K$8,2,0)))","v":0},0,{"$f":"SUM(G12:G17)","v":0},0,null,{"$f":"IF(AND(J14<>0,OR($S$4=\"Cu\",$S$4=\"Stahl\")),IF($S$4=\"Cu\",VLOOKUP(H14+$AA$4,Kupfer!$A$5:$Q$55,VLOOKUP(J14,Gewinde!$S$8:$V$15,4)),VLOOKUP(H14+$AA$4,Gewinde!$A$5:$Q$55,VLOOKUP(J14,Gewinde!$T$8:$V$15,3))),0)","v":0},{"$f":"IF(AND(J14<>0,OR($S$4=\"Cu\",$S$4=\"Stahl\")),IF($S$4=\"Cu\",VLOOKUP(H14+$AA$4,Kupfer!$A$5:$Q$55,VLOOKUP(J14,Gewinde!$S$8:$V$15,3)),VLOOKUP(H14+$AA$4,Gewinde!$A$5:$Q$55,VLOOKUP(J14,Gewinde!$T$8:$V$15,2))),0)","v":0},{"$f":"(L14*I14)","v":0},{"$f":"Verlustbeiwert!F29","v":0},{"$f":"0.003972*K14^2*N14","v":0},0,{"$f":"IF(P14=0,0,P14*(-0.04))","v":0},{"$f":"IF(AND(J14>0,K14<1),\"NIX\",M14+O14+Q14)","v":0},{"$f":"IF(($A$12=\"Ab\")*AND(Strangverbrauch!C1>0.599),\"Abges. > 0,599mbar\",0)","v":0},null,null,null,null,null,1]
[null,null,"UWH",0,0,{"$f":"IF(E15=0,0,VLOOKUP(D15,Gleichzeitig!$B$3:$F$52,VLOOKUP(C15,Gleichzeitig!$J$5:$K$8,2,0)))","v":0},0,{"$f":"IF(A13=\"GS\",\"VA\",\"\")","v":""},{"$f":"IF(A13=\"GS\",\"GS\",\"\")","v":""},{"$f":"IF($AD$10=2,\"Dimensionskontrolle !\",\"\")","v":""},null,null,null,null,null,null,null,{"$f":"Strangverbrauch!C1","v":0},{"$f":"IF(($A$12=\"Ez\")*AND(Strangverbrauch!C1>1.399),\"Ezges. > 1,399mbar\",0)","v":0}]
[null,null,"G2",0,0,{"$f":"IF(E16=0,0,VLOOKUP(D16,Gleichzeitig!$B$3:$F$52,VLOOKUP(C13,Gleichzeitig!$J$5:$K$8,2,0)))","v":0},0,{"$f":"IF(A14=\"GS\",\"VA\",\"\")","v":""}," ",null,null,null,null,null,null,null,null,0,0,0,0,0,0,0]
[null,null,"Bäcker",0,0,{"$f":"IF(E17<>0,1,0)","v":0},0,{"$f":"IF(A13=\"GS\",SUM(E12:E17),\"\")","v":""},{"$f":"IF(A13=\"GS\",(IF(H17<=2.09,2.5,IF(AND(H17>=2.1,H17<=3.29),4,IF(AND(H17>=3.3,H17<=4.89),6,IF(AND(H17>=4.9,H17<=8.09),10,IF(AND(H17>=8.1,H17<=16),16,IF(H17>=16,\">16\"))))))),\"\")","v":""},null,null,null,null,null,{"$f":"IF(R17>0,\"Druckverlust bis zur HAE ->\",0)","v":0},null,null,{"$f":"Strangverbrauch!U$22","v":0},0,0,0,0,0,{"$f":"Y14","v":1}]
["Vt",null,"H",0,0,{"$f":"IF(E18=0,0,VLOOKUP(D18,Gleichzeitig!$B$3:$F$52,VLOOKUP(C18,Gleichzeitig!$J$5:$K$8,2,0)))","v":0},0,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(($A$18=\"Vt\")*AND(Strangverbrauch!C2>0.399),\"Vtges. > 0,399mbar\",0)","v":0}]
[". ",null,"DWH",0,0,{"$f":"IF(E19=0,0,VLOOKUP(D19,Gleichzeitig!$B$3:$F$52,VLOOKUP(C19,Gleichzeitig!$J$5:$K$8,2,0)))","v":0},0,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(($A$18=\"Vb\")*AND(Strangverbrauch!C2>0.899),\"Vbges. > 0,899mbar\",0)","v":0}]
[null,2,"RH",0,0,{"$f":"IF(E20=0,0,VLOOKUP(D20,Gleichzeitig!$B$3:$F$52,VLOOKUP(C20,Gleichzeitig!$J$5:$K$8,2,0)))","v":0},0,{"$f":"SUM(G18:G23)","v":0},0,null,{"$f":"IF(AND(J20<>0,OR($S$4=\"Cu\",$S$4=\"Stahl\")),IF($S$4=\"Cu\",VLOOKUP(H20+$AA$4,Kupfer!$A$5:$Q$55,VLOOKUP(J20,Gewinde!$S$8:$V$15,4)),VLOOKUP(H20+$AA$4,Gewinde!$A$5:$Q$55,VLOOKUP(J20,Gewinde!$T$8:$V$15,3))),0)","v":0},{"$f":"IF(AND(J20<>0,OR($S$4=\"Cu\",$S$4=\"Stahl\")),IF($S$4=\"Cu\",VLOOKUP(H20+$AA$4,Kupfer!$A$5:$Q$55,VLOOKUP(J20,Gewinde!$S$8:$V$15,3)),VLOOKUP(H20+$AA$4,Gewinde!$A$5:$Q$55,VLOOKUP(J20,Gewinde!$T$8:$V$15,2))),0)","v":0},{"$f":"(L20*I20)","v":0},{"$f":"Verlustbeiwert!H29","v":0},{"$f":"0.003972*K20^2*N20","v":0},0,{"$f":"IF(P20=0,0,P20*(-0.04))","v":0},{"$f":"IF(AND(J20>0,K20<1),\"NIX\",M20+O20+Q20)","v":0},{"$f":"IF(($A$18=\"Ab\")*AND(Strangverbrauch!C2>0.599),\"Abges. > 0,599mbar\",0)","v":0},null,null,null,null,null,2]
[null,null,"UWH",0,0,{"$f":"IF(E21=0,0,VLOOKUP(D21,Gleichzeitig!$B$3:$F$52,VLOOKUP(C21,Gleichzeitig!$J$5:$K$8,2,0)))","v":0},0,{"$f":"IF(A19=\"GS\",\"VA\",\"\")","v":""},{"$f":"IF(A19=\"GS\",\"GS\",\"\")","v":""},{"$f":"IF($AD$10=2,\"Dimensionskontrolle !\",\"\")","v":""},null,null,null,null,null,null,null,{"$f":"Strangverbrauch!C2","v":0},{"$f":"IF(($A$18=\"Ez\")*AND(Strangverbrauch!C2>1.399),\"Ezges. > 1,399mbar\",0)","v":0}]
[null,null,"G2",0,0,{"$f":"IF(E22=0,0,VLOOKUP(D22,Gleichzeitig!$B$3:$F$52,VLOOKUP(C19,Gleichzeitig!$J$5:$K$8,2,0)))","v":0},0," "," ",null,null,null,null,null,null,null,null,0,{"$f":"Y20","v":2},0,0,0,0,0]
[null,null," ",0,0,{"$f":"IF(E23<>0,1,0)","v":0},0,{"$f":"IF(A19=\"GS\",SUM(E18:E23),\"\")","v":""},{"$f":"IF(A19=\"GS\",(IF(H23<=2.09,2.5,IF(AND(H23>=2.1,H23<=3.29),4,IF(AND(H23>=3.3,H23<=4.89),6,IF(AND(H23>=4.9,H23<=8.09),10,IF(AND(H23>=8.1,H23<=16),16,IF(H23>=16,\">16\"))))))),\"\")","v":""},null,null,null,null,null,{"$f":"IF(R23>0,\"Druckverlust bis zur HAE ->\",0)","v":0},null,null,{"$f":"Strangverbrauch!V$22","v":0},0,0,0,0,0,1]
["Vt",null,"H",0,0,{"$f":"IF(E24=0,0,VLOOKUP(D24,Gleichzeitig!$B$3:$F$52,VLOOKUP(C24,Gleichzeitig!$J$5:$K$8,2,0)))","v":0},0,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(($A$24=\"Vt\")*AND(Strangverbrauch!C3>0.399),\"Vtges. > 0,399mbar\",0)","v":0}]
[". ",null,"DWH",0,0,{"$f":"IF(E25=0,0,VLOOKUP(D25,Gleichzeitig!$B$3:$F$52,VLOOKUP(C25,Gleichzeitig!$J$5:$K$8,2,0)))","v":0},0,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(($A$24=\"Vb\")*AND(Strangverbrauch!C3>0.899),\"Vbges. > 0,899mbar\",0)","v":0}]
[null,3,"RH",0,0,{"$f":"IF(E26=0,0,VLOOKUP(D26,Gleichzeitig!$B$3:$F$52,VLOOKUP(C26,Gleichzeitig!$J$5:$K$8,2,0)))","v":0},0,{"$f":"SUM(G24:G29)","v":0},0,null,{"$f":"IF(AND(J26<>0,OR($S$4=\"Cu\",$S$4=\"Stahl\")),IF($S$4=\"Cu\",VLOOKUP(H26+$AA$4,Kupfer!$A$5:$Q$55,VLOOKUP(J26,Gewinde!$S$8:$V$15,4)),VLOOKUP(H26+$AA$4,Gewinde!$A$5:$Q$55,VLOOKUP(J26,Gewinde!$T$8:$V$15,3))),0)","v":0},{"$f":"IF(AND(J26<>0,OR($S$4=\"Cu\",$S$4=\"Stahl\")),IF($S$4=\"Cu\",VLOOKUP(H26+$AA$4,Kupfer!$A$5:$Q$55,VLOOKUP(J26,Gewinde!$S$8:$V$15,3)),VLOOKUP(H26+$AA$4,Gewinde!$A$5:$Q$55,VLOOKUP(J26,Gewinde!$T$8:$V$15,2))),0)","v":0},{"$f":"(L26*I26)","v":0},{"$f":"Verlustbeiwert!J29","v":0},{"$f":"0.003972*K26^2*N26","v":0},0,{"$f":"IF(P26=0,0,P26*(-0.04))","v":0},{"$f":"IF(AND(J26>0,K26<1),\"NIX\",M26+O26+Q26)","v":0},{"$f":"IF(($A$24=\"Ab\")*AND(Strangverbrauch!C3>0.599),\"Abges. > 0,599mbar\",0)","v":0},null,null,null,null,null,3]
[null,null,"UWH",0,0,{"$f":"IF(E27=0,0,VLOOKUP(D27,Gleichzeitig!$B$3:$F$52,VLOOKUP(C27,Gleichzeitig!$J$5:$K$8,2,0)))","v":0},0,{"$f":"IF(A25=\"GS\",\"VA\",\"\")","v":""},{"$f":"IF(A25=\"GS\",\"GS\",\"\")","v":""},{"$f":"IF($AD$10=2,\"Dimensionskontrolle !\",\"\")","v":""},null,null,null,null,null,null,null,{"$f":"Strangverbrauch!C3","v":0},{"$f":"IF(($A$24=\"Ez\")*AND(Strangverbrauch!C3>1.399),\"Ezges. > 1,399mbar\",0)","v":0}]
[null,null,"G2",0,0,{"$f":"IF(E28=0,0,VLOOKUP(D28,Gleichzeitig!$B$3:$F$52,VLOOKUP(C25,Gleichzeitig!$J$5:$K$8,2,0)))","v":0},0," "," ",null,null,null,null,null,null,null,null,0,{"$f":"Y26","v":3},0,0,0,0,0]
[null,null," ",0,0,{"$f":"IF(E29<>0,1,0)","v":0},0,{"$f":"IF(A25=\"GS\",SUM(E24:E29),\"\")","v":""},{"$f":"IF(A25=\"GS\",(IF(H29<=2.09,2.5,IF(AND(H29>=2.1,H29<=3.29),4,IF(AND(H29>=3.3,H29<=4.89),6,IF(AND(H29>=4.9,H29<=8.09),10,IF(AND(H29>=8.1,H29<=16),16,IF(H29>=16,\">16\"))))))),\"\")","v":""},null,null,null,null,null,{"$f":"IF(R29>0,\"Druckverlust bis zur HAE ->\",0)","v":0},null,null,{"$f":"Strangverbrauch!W$22","v":0},0,0,0,0,0,1]
["Vt",null,"H",0,0,{"$f":"IF(E30=0,0,VLOOKUP(D30,Gleichzeitig!$B$3:$F$52,VLOOKUP(C30,Gleichzeitig!$J$5:$K$8,2,0)))","v":0},0,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(($A$30=\"Vt\")*AND(Strangverbrauch!C4>0.399),\"Vtges. > 0,399mbar\",0)","v":0}]
[". ",null,"DWH",0,0,{"$f":"IF(E31=0,0,VLOOKUP(D31,Gleichzeitig!$B$3:$F$52,VLOOKUP(C31,Gleichzeitig!$J$5:$K$8,2,0)))","v":0},0,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(($A$30=\"Vb\")*AND(Strangverbrauch!C4>0.899),\"Vbges. > 0,899mbar\",0)","v":0}]
[null,4,"RH",0,0,{"$f":"IF(E32=0,0,VLOOKUP(D32,Gleichzeitig!$B$3:$F$52,VLOOKUP(C32,Gleichzeitig!$J$5:$K$8,2,0)))","v":0},0,{"$f":"SUM(G30:G35)","v":0},0,null,{"$f":"IF(AND(J32<>0,OR($S$4=\"Cu\",$S$4=\"Stahl\")),IF($S$4=\"Cu\",VLOOKUP(H32+$AA$4,Kupfer!$A$5:$Q$55,VLOOKUP(J32,Gewinde!$S$8:$V$15,4)),VLOOKUP(H32+$AA$4,Gewinde!$A$5:$Q$55,VLOOKUP(J32,Gewinde!$T$8:$V$15,3))),0)","v":0},{"$f":"IF(AND(J32<>0,OR($S$4=\"Cu\",$S$4=\"Stahl\")),IF($S$4=\"Cu\",VLOOKUP(H32+$AA$4,Kupfer!$A$5:$Q$55,VLOOKUP(J32,Gewinde!$S$8:$V$15,3)),VLOOKUP(H32+$AA$4,Gewinde!$A$5:$Q$55,VLOOKUP(J32,Gewinde!$T$8:$V$15,2))),0)","v":0},{"$f":"(L32*I32)","v":0},{"$f":"Verlustbeiwert!L29","v":0},{"$f":"0.003972*K32^2*N32","v":0},0,{"$f":"IF(P32=0,0,P32*(-0.04))","v":0},{"$f":"IF(AND(J32>0,K32<1),\"NIX\",M32+O32+Q32)","v":0},{"$f":"IF(($A$30=\"Ab\")*AND(Strangverbrauch!C4>0.599),\"Abges. > 0,599mbar\",0)","v":0},null,null,null,null,null,4]
[null,null,"UWH",0,0,{"$f":"IF(E33=0,0,VLOOKUP(D33,Gleichzeitig!$B$3:$F$52,VLOOKUP(C33,Gleichzeitig!$J$5:$K$8,2,0)))","v":0},0,{"$f":"IF(A31=\"GS\",\"VA\",\"\")","v":""},{"$f":"IF(A31=\"GS\",\"GS\",\"\")","v":""},{"$f":"IF($AD$10=2,\"Dimensionskontrolle !\",\"\")","v":""},null,null,null,null,null,null,null,{"$f":"Strangverbrauch!C4","v":0},{"$f":"IF(($A$30=\"Ez\")*AND(Strangverbrauch!C4>1.399),\"Ezges. > 1,399mbar\",0)","v":0}]
[null,null,"G2",0,0,{"$f":"IF(E34=0,0,VLOOKUP(D34,Gleichzeitig!$B$3:$F$52,VLOOKUP(C31,Gleichzeitig!$J$5:$K$8,2,0)))","v":0},0," "," ",null,null,null,null,null,null,null,null,0,{"$f":"Y32","v":4},0,0,0,0,0]
[null,null,null,0,0,{"$f":"IF(E35<>0,1,0)","v":0},0,{"$f":"IF(A31=\"GS\",SUM(E30:E35),\"\")","v":""},{"$f":"IF(A31=\"GS\",(IF(H35<=2.09,2.5,IF(AND(H35>=2.1,H35<=3.29),4,IF(AND(H35>=3.3,H35<=4.89),6,IF(AND(H35>=4.9,H35<=8.09),10,IF(AND(H35>=8.1,H35<=16),16,IF(H35>=16,\">16\"))))))),\"\")","v":""},null,null,null,null,null,{"$f":"IF(R35>0,\"Druckverlust bis zur HAE ->\",0)","v":0},null,null,{"$f":"Strangverbrauch!X$22","v":0},0,0,0,0,0,1]
["Vt",null,"H",0,0,{"$f":"IF(E36=0,0,VLOOKUP(D36,Gleichzeitig!$B$3:$F$52,VLOOKUP(C36,Gleichzeitig!$J$5:$K$8,2,0)))","v":0},0,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(($A$36=\"Vt\")*AND(Strangverbrauch!C5>0.399),\"Vtges. > 0,399mbar\",0)","v":0}]
[". ",null,"DWH",0,0,{"$f":"IF(E37=0,0,VLOOKUP(D37,Gleichzeitig!$B$3:$F$52,VLOOKUP(C37,Gleichzeitig!$J$5:$K$8,2,0)))","v":0},0,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(($A$36=\"Vb\")*AND(Strangverbrauch!C1>0.899),\"Vbges. > 0,899mbar\",0)","v":0}]
[null,5,"RH",0,0,{"$f":"IF(E38=0,0,VLOOKUP(D38,Gleichzeitig!$B$3:$F$52,VLOOKUP(C38,Gleichzeitig!$J$5:$K$8,2,0)))","v":0},0,{"$f":"SUM(G36:G41)","v":0},0,null,{"$f":"IF(AND(J38<>0,OR($S$4=\"Cu\",$S$4=\"Stahl\")),IF($S$4=\"Cu\",VLOOKUP(H38+$AA$4,Kupfer!$A$5:$Q$55,VLOOKUP(J38,Gewinde!$S$8:$V$15,4)),VLOOKUP(H38+$AA$4,Gewinde!$A$5:$Q$55,VLOOKUP(J38,Gewinde!$T$8:$V$15,3))),0)","v":0},{"$f":"IF(AND(J38<>0,OR($S$4=\"Cu\",$S$4=\"Stahl\")),IF($S$4=\"Cu\",VLOOKUP(H38+$AA$4,Kupfer!$A$5:$Q$55,VLOOKUP(J38,Gewinde!$S$8:$V$15,3)),VLOOKUP(H38+$AA$4,Gewinde!$A$5:$Q$55,VLOOKUP(J38,Gewinde!$T$8:$V$15,2))),0)","v":0},{"$f":"(L38*I38)","v":0},{"$f":"Verlustbeiwert!N29","v":0},{"$f":"0.003972*K38^2*N38","v":0},0,{"$f":"IF(P38=0,0,P38*(-0.04))","v":0},{"$f":"IF(AND(J38>0,K38<1),\"NIX\",M38+O38+Q38)","v":0},{"$f":"IF(($A$36=\"Ab\")*AND(Strangverbrauch!C1>0.599),\"Abges. > 0,599mbar\",0)","v":0},null,null,null,null,null,5]
[null,null,"UWH",0,0,{"$f":"IF(E39=0,0,VLOOKUP(D39,Gleichzeitig!$B$3:$F$52,VLOOKUP(C39,Gleichzeitig!$J$5:$K$8,2,0)))","v":0},0,{"$f":"IF(A37=\"GS\",\"VA\",\"\")","v":""},{"$f":"IF(A37=\"GS\",\"GS\",\"\")","v":""},{"$f":"IF($AD$10=2,\"Dimensionskontrolle !\",\"\")","v":""},null,null,null,null,null,null,null,{"$f":"Strangverbrauch!C5","v":0},{"$f":"IF(($A$36=\"Ez\")*AND(Strangverbrauch!C1>1.399),\"Ezges. > 1,399mbar\",0)","v":0}]
[null,null,"G2",0,0,{"$f":"IF(E40=0,0,VLOOKUP(D40,Gleichzeitig!$B$3:$F$52,VLOOKUP(C37,Gleichzeitig!$J$5:$K$9,2,0)))","v":0},0," "," ",null,null,null,null,null,null,null,null,0,{"$f":"Y38","v":5},0,0,0,0,0]
[null,null,null,0,0,{"$f":"IF(E41<>0,1,0)","v":0},0,{"$f":"IF(A37=\"GS\",SUM(E36:E41),\"\")","v":""},{"$f":"IF(A37=\"GS\",(IF(H41<=2.09,2.5,IF(AND(H41>=2.1,H41<=3.29),4,IF(AND(H41>=3.3,H41<=4.89),6,IF(AND(H41>=4.9,H41<=8.09),10,IF(AND(H41>=8.1,H41<=16),16,IF(H41>=16,\">16\"))))))),\"\")","v":""},null,null,null,null,null,{"$f":"IF(R41>0,\"Druckverlust bis zur HAE ->\",0)","v":0},null,null,{"$f":"Strangverbrauch!Y$22","v":0},0,0,0,0,0,1]
["Vt",null,"H",0,0,{"$f":"IF(E42=0,0,VLOOKUP(D42,Gleichzeitig!$B$3:$F$52,VLOOKUP(C42,Gleichzeitig!$J$5:$K$8,2,0)))","v":0},0,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(($A$42=\"Vt\")*AND(Strangverbrauch!C6>0.399),\"Vtges. > 0,399mbar\",0)","v":0}]
[". ",null,"DWH",0,0,{"$f":"IF(E43=0,0,VLOOKUP(D43,Gleichzeitig!$B$3:$F$52,VLOOKUP(C43,Gleichzeitig!$J$5:$K$8,2,0)))","v":0},0,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(($A$42=\"Vb\")*AND(Strangverbrauch!C6>0.899),\"Vbges. > 0,899mbar\",0)","v":0}]
[null,6,"RH",0,0,{"$f":"IF(E44=0,0,VLOOKUP(D44,Gleichzeitig!$B$3:$F$52,VLOOKUP(C44,Gleichzeitig!$J$5:$K$8,2,0)))","v":0},0,{"$f":"SUM(G42:G47)","v":0},0,null,{"$f":"IF(AND(J44<>0,OR($S$4=\"Cu\",$S$4=\"Stahl\")),IF($S$4=\"Cu\",VLOOKUP(H44+$AA$4,Kupfer!$A$5:$Q$55,VLOOKUP(J44,Gewinde!$S$8:$V$15,4)),VLOOKUP(H44+$AA$4,Gewinde!$A$5:$Q$55,VLOOKUP(J44,Gewinde!$T$8:$V$15,3))),0)","v":0},{"$f":"IF(AND(J44<>0,OR($S$4=\"Cu\",$S$4=\"Stahl\")),IF($S$4=\"Cu\",VLOOKUP(H44+$AA$4,Kupfer!$A$5:$Q$55,VLOOKUP(J44,Gewinde!$S$8:$V$15,3)),VLOOKUP(H44+$AA$4,Gewinde!$A$5:$Q$55,VLOOKUP(J44,Gewinde!$T$8:$V$15,2))),0)","v":0},{"$f":"(L44*I44)","v":0},{"$f":"Verlustbeiwert!P29","v":0},{"$f":"0.003972*K44^2*N44","v":0},0,{"$f":"IF(P44=0,0,P44*(-0.04))","v":0},{"$f":"IF(AND(J44>0,K44<1),\"NIX\",M44+O44+Q44)","v":0},{"$f":"IF(($A$42=\"Ab\")*AND(Strangverbrauch!C6>0.599),\"Abges. > 0,599mbar\",0)","v":0},null,null,null,null,null,6]
[null,null,"UWH",0,0,{"$f":"IF(E45=0,0,VLOOKUP(D45,Gleichzeitig!$B$3:$F$52,VLOOKUP(C45,Gleichzeitig!$J$5:$K$8,2,0)))","v":0},0,{"$f":"IF(A43=\"GS\",\"VA\",\"\")","v":""},{"$f":"IF(A43=\"GS\",\"GS\",\"\")","v":""},{"$f":"IF($AD$10=2,\"Dimensionskontrolle !\",\"\")","v":""},null,null,null,null,null,null,null,{"$f":"Strangverbrauch!C6","v":0},{"$f":"IF(($A$42=\"Ez\")*AND(Strangverbrauch!C6>1.399),\"Ezges. > 1,399mbar\",0)","v":0}]
[null,null,"G2",0,0,{"$f":"IF(E46=0,0,VLOOKUP(D46,Gleichzeitig!$B$3:$F$52,VLOOKUP(C43,Gleichzeitig!$J$5:$K$8,2,0)))","v":0},0," "," ",null,null,null,null,null,null,null,null,0,{"$f":"Y44","v":6},0,0,0,0,0]
[null,null,null,0,0,{"$f":"IF(E47<>0,1,0)","v":0},0,{"$f":"IF(A43=\"GS\",SUM(E42:E47),\"\")","v":""},{"$f":"IF(A43=\"GS\",(IF(H47<=2.09,2.5,IF(AND(H47>=2.1,H47<=3.29),4,IF(AND(H47>=3.3,H47<=4.89),6,IF(AND(H47>=4.9,H47<=8.09),10,IF(AND(H47>=8.1,H47<=16),16,IF(H47>=16,\">16\"))))))),\"\")","v":""},null,null,null,null,null,{"$f":"IF(R47>0,\"Druckverlust bis zur HAE ->\",0)","v":0},null,null,{"$f":"Strangverbrauch!Z$22","v":0},0,0,0,0,0,1]
["Vt",null,"H",0,0,{"$f":"IF(E48=0,0,VLOOKUP(D48,Gleichzeitig!$B$3:$F$52,VLOOKUP(C48,Gleichzeitig!$J$5:$K$8,2,0)))","v":0},0,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(($A$48=\"Vt\")*AND(Strangverbrauch!C7>0.399),\"Vtges. > 0,399mbar\",0)","v":0}]
[". ",null,"DWH",0,0,{"$f":"IF(E49=0,0,VLOOKUP(D49,Gleichzeitig!$B$3:$F$52,VLOOKUP(C49,Gleichzeitig!$J$5:$K$8,2,0)))","v":0},0,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(($A$48=\"Vb\")*AND(Strangverbrauch!C15>0.899),\"Vbges. > 0,899mbar\",0)","v":0}]
[null,7,"RH",0,0,{"$f":"IF(E50=0,0,VLOOKUP(D50,Gleichzeitig!$B$3:$F$52,VLOOKUP(C50,Gleichzeitig!$J$5:$K$8,2,0)))","v":0},0,{"$f":"SUM(G48:G53)","v":0},0,null,{"$f":"IF(AND(J50<>0,OR($S$4=\"Cu\",$S$4=\"Stahl\")),IF($S$4=\"Cu\",VLOOKUP(H50+$AA$4,Kupfer!$A$5:$Q$55,VLOOKUP(J50,Gewinde!$S$8:$V$15,4)),VLOOKUP(H50+$AA$4,Gewinde!$A$5:$Q$55,VLOOKUP(J50,Gewinde!$T$8:$V$15,3))),0)","v":0},{"$f":"IF(AND(J50<>0,OR($S$4=\"Cu\",$S$4=\"Stahl\")),IF($S$4=\"Cu\",VLOOKUP(H50+$AA$4,Kupfer!$A$5:$Q$55,VLOOKUP(J50,Gewinde!$S$8:$V$15,3)),VLOOKUP(H50+$AA$4,Gewinde!$A$5:$Q$55,VLOOKUP(J50,Gewinde!$T$8:$V$15,2))),0)","v":0},{"$f":"(L50*I50)","v":0},{"$f":"Verlustbeiwert!R29","v":0},{"$f":"0.003972*K50^2*N50","v":0},0,{"$f":"IF(P50=0,0,P50*(-0.04))","v":0},{"$f":"IF(AND(J50>0,K50<1),\"NIX\",M50+O50+Q50)","v":0},{"$f":"IF(($A$48=\"Ab\")*AND(Strangverbrauch!C11>0.599),\"Abges. > 0,599mbar\",0)","v":0},null,null,null,null,null,7]
[null,null,"UWH",0,0,{"$f":"IF(E51=0,0,VLOOKUP(D51,Gleichzeitig!$B$3:$F$52,VLOOKUP(C51,Gleichzeitig!$J$5:$K$8,2,0)))","v":0},0,{"$f":"IF(A49=\"GS\",\"VA\",\"\")","v":""},{"$f":"IF(A49=\"GS\",\"GS\",\"\")","v":""},{"$f":"IF($AD$10=2,\"Dimensionskontrolle !\",\"\")","v":""},null,null,null,null,null,null,null,{"$f":"Strangverbrauch!C7","v":0},{"$f":"IF(($A$48=\"Ez\")*AND(Strangverbrauch!C11>1.399),\"Ezges. > 1,399mbar\",0)","v":0}]
[null,null,"G2",0,0,{"$f":"IF(E52=0,0,VLOOKUP(D52,Gleichzeitig!$B$3:$F$52,VLOOKUP(C49,Gleichzeitig!$J$5:$K$8,2,0)))","v":0},0," "," ",null,null,null,null,null,null,null,null,0,{"$f":"Y50","v":7},0,0,0,0,0]
[null,null,null,0,0,{"$f":"IF(E53<>0,1,0)","v":0},0,{"$f":"IF(A49=\"GS\",SUM(E48:E53),\"\")","v":""},{"$f":"IF(A49=\"GS\",(IF(H53<=2.09,2.5,IF(AND(H53>=2.1,H53<=3.29),4,IF(AND(H53>=3.3,H53<=4.89),6,IF(AND(H53>=4.9,H53<=8.09),10,IF(AND(H53>=8.1,H53<=16),16,IF(H53>=16,\">16\"))))))),\"\")","v":""},null,null,null,null,null,{"$f":"IF(R53>0,\"Druckverlust bis zur HAE ->\",0)","v":0},null,null,{"$f":"Strangverbrauch!AA$22","v":0},0,0,0,0,0,1]
["Vt",null,"H",0,0,{"$f":"IF(E54=0,0,VLOOKUP(D54,Gleichzeitig!$B$3:$F$52,VLOOKUP(C54,Gleichzeitig!$J$5:$K$8,2,0)))","v":0},0,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(($A$54=\"Vt\")*AND(Strangverbrauch!C8>0.399),\"Vtges. > 0,399mbar\",0)","v":0}]
[". ",null,"DWH",0,0,{"$f":"IF(E55=0,0,VLOOKUP(D55,Gleichzeitig!$B$3:$F$52,VLOOKUP(C55,Gleichzeitig!$J$5:$K$8,2,0)))","v":0},0,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(($A$54=\"Vb\")*AND(Strangverbrauch!C16>0.899),\"Vbges. > 0,899mbar\",0)","v":0}]
[null,8,"RH",0,0,{"$f":"IF(E56=0,0,VLOOKUP(D56,Gleichzeitig!$B$3:$F$52,VLOOKUP(C56,Gleichzeitig!$J$5:$K$8,2,0)))","v":0},0,{"$f":"SUM(G54:G59)","v":0},0,null,{"$f":"IF(AND(J56<>0,OR($S$4=\"Cu\",$S$4=\"Stahl\")),IF($S$4=\"Cu\",VLOOKUP(H56+$AA$4,Kupfer!$A$5:$Q$55,VLOOKUP(J56,Gewinde!$S$8:$V$15,4)),VLOOKUP(H56+$AA$4,Gewinde!$A$5:$Q$55,VLOOKUP(J56,Gewinde!$T$8:$V$15,3))),0)","v":0},{"$f":"IF(AND(J56<>0,OR($S$4=\"Cu\",$S$4=\"Stahl\")),IF($S$4=\"Cu\",VLOOKUP(H56+$AA$4,Kupfer!$A$5:$Q$55,VLOOKUP(J56,Gewinde!$S$8:$V$15,3)),VLOOKUP(H56+$AA$4,Gewinde!$A$5:$Q$55,VLOOKUP(J56,Gewinde!$T$8:$V$15,2))),0)","v":0},{"$f":"(L56*I56)","v":0},{"$f":"Verlustbeiwert!T29","v":0},{"$f":"0.003972*K56^2*N56","v":0},0,{"$f":"IF(P56=0,0,P56*(-0.04))","v":0},{"$f":"IF(AND(J56>0,K56<1),\"NIX\",M56+O56+Q56)","v":0},{"$f":"IF(($A$54=\"Ab\")*AND(Strangverbrauch!C16>0.599),\"Abges. > 0,599mbar\",0)","v":0},null,null,null,null,null,8]
[null,null,"UWH",0,0,{"$f":"IF(E57=0,0,VLOOKUP(D57,Gleichzeitig!$B$3:$F$52,VLOOKUP(C57,Gleichzeitig!$J$5:$K$8,2,0)))","v":0},0,{"$f":"IF(A55=\"GS\",\"VA\",\"\")","v":""},{"$f":"IF(A55=\"GS\",\"GS\",\"\")","v":""},{"$f":"IF($AD$10=2,\"Dimensionskontrolle !\",\"\")","v":""},null,null,null,null,null,null,null,{"$f":"Strangverbrauch!C8","v":0},{"$f":"IF(($A$54=\"Ez\")*AND(Strangverbrauch!C16>1.399),\"Ezges. > 1,399mbar\",0)","v":0}]
[null,null,"G2",0,0,{"$f":"IF(E58=0,0,VLOOKUP(D58,Gleichzeitig!$B$3:$F$52,VLOOKUP(C55,Gleichzeitig!$J$5:$K$8,2,0)))","v":0},0," "," ",null,null,null,null,null,null,null,null,0,{"$f":"Y56","v":8},0,0,0,0,0]
[null,null,null,0,0,{"$f":"IF(E59<>0,1,0)","v":0},0,{"$f":"IF(A55=\"GS\",SUM(E54:E59),\"\")","v":""},{"$f":"IF(A55=\"GS\",(IF(H59<=2.09,2.5,IF(AND(H59>=2.1,H59<=3.29),4,IF(AND(H59>=3.3,H59<=4.89),6,IF(AND(H59>=4.9,H59<=8.09),10,IF(AND(H59>=8.1,H59<=16),16,IF(H59>=16,\">16\"))))))),\"\")","v":""},null,null,null,null,null,{"$f":"IF(R59>0,\"Druckverlust bis zur HAE ->\",0)","v":0},null,null,{"$f":"Strangverbrauch!AB$22","v":0},0,0,0,0,0,1]
["Vt",null,"H",0,0,{"$f":"IF(E60=0,0,VLOOKUP(D60,Gleichzeitig!$B$3:$F$52,VLOOKUP(C60,Gleichzeitig!$J$5:$K$8,2,0)))","v":0},0,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(($A$60=\"Vt\")*AND(Strangverbrauch!C9>0.399),\"Vtges. > 0,399mbar\",0)","v":0}]
[". ",null,"DWH",0,0,{"$f":"IF(E61=0,0,VLOOKUP(D61,Gleichzeitig!$B$3:$F$52,VLOOKUP(C61,Gleichzeitig!$J$5:$K$8,2,0)))","v":0},0,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(($A$60=\"Vb\")*AND(Strangverbrauch!C21>0.899),\"Vbges. > 0,899mbar\",0)","v":0}]
[null,9,"RH",0,0,{"$f":"IF(E62=0,0,VLOOKUP(D62,Gleichzeitig!$B$3:$F$52,VLOOKUP(C62,Gleichzeitig!$J$5:$K$8,2,0)))","v":0},0,{"$f":"SUM(G60:G65)","v":0},0,null,{"$f":"IF(AND(J62<>0,OR($S$4=\"Cu\",$S$4=\"Stahl\")),IF($S$4=\"Cu\",VLOOKUP(H62+$AA$4,Kupfer!$A$5:$Q$55,VLOOKUP(J62,Gewinde!$S$8:$V$15,4)),VLOOKUP(H62+$AA$4,Gewinde!$A$5:$Q$55,VLOOKUP(J62,Gewinde!$T$8:$V$15,3))),0)","v":0},{"$f":"IF(AND(J62<>0,OR($S$4=\"Cu\",$S$4=\"Stahl\")),IF($S$4=\"Cu\",VLOOKUP(H62+$AA$4,Kupfer!$A$5:$Q$55,VLOOKUP(J62,Gewinde!$S$8:$V$15,3)),VLOOKUP(H62+$AA$4,Gewinde!$A$5:$Q$55,VLOOKUP(J62,Gewinde!$T$8:$V$15,2))),0)","v":0},{"$f":"(L62*I62)","v":0},{"$f":"Verlustbeiwert!V29","v":0},{"$f":"0.003972*K62^2*N62","v":0},0,{"$f":"IF(P62=0,0,P62*(-0.04))","v":0},{"$f":"IF(AND(J62>0,K62<1),\"NIX\",M62+O62+Q62)","v":0},{"$f":"IF(($A$60=\"Ab\")*AND(Strangverbrauch!C21>0.599),\"Abges. > 0,599mbar\",0)","v":0},null,null,null,null,null,9]
[null,null,"UWH",0,0,{"$f":"IF(E63=0,0,VLOOKUP(D63,Gleichzeitig!$B$3:$F$52,VLOOKUP(C63,Gleichzeitig!$J$5:$K$8,2,0)))","v":0},0,{"$f":"IF(A61=\"GS\",\"VA\",\"\")","v":""},{"$f":"IF(A61=\"GS\",\"GS\",\"\")","v":""},{"$f":"IF($AD$10=2,\"Dimensionskontrolle !\",\"\")","v":""},null,null,null,null,null,null,null,{"$f":"Strangverbrauch!C9","v":0},{"$f":"IF(($A$60=\"Ez\")*AND(Strangverbrauch!C21>1.399),\"Ezges. > 1,399mbar\",0)","v":0}]
[null,null,"G2",0,0,{"$f":"IF(E64=0,0,VLOOKUP(D64,Gleichzeitig!$B$3:$F$52,VLOOKUP(C61,Gleichzeitig!$J$5:$K$8,2,0)))","v":0},0," "," ",null,null,null,null,null,null,null,null,0,{"$f":"Y62","v":9},0,0,0,0,0]
[null,null,null,0,0,{"$f":"IF(E65<>0,1,0)","v":0},0,{"$f":"IF(A61=\"GS\",SUM(E60:E65),\"\")","v":""},{"$f":"IF(A61=\"GS\",(IF(H65<=2.09,2.5,IF(AND(H65>=2.1,H65<=3.29),4,IF(AND(H65>=3.3,H65<=4.89),6,IF(AND(H65>=4.9,H65<=8.09),10,IF(AND(H65>=8.1,H65<=16),16,IF(H65>=16,\">16\"))))))),\"\")","v":""},null,null,null,null,null,{"$f":"IF(R65>0,\"Druckverlust bis zur HAE ->\",0)","v":0},null,null,{"$f":"Strangverbrauch!AC$22","v":0},0,0,0,0,0,1]
["Vt",null,"H",0,0,{"$f":"IF(E66=0,0,VLOOKUP(D66,Gleichzeitig!$B$3:$F$52,VLOOKUP(C66,Gleichzeitig!$J$5:$K$8,2,0)))","v":0},0,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(($A$66=\"Vt\")*AND(Strangverbrauch!C10>0.399),\"Vtges. > 0,399mbar\",0)","v":0}]
[". ",null,"DWH",0,0,{"$f":"IF(E67=0,0,VLOOKUP(D67,Gleichzeitig!$B$3:$F$52,VLOOKUP(C67,Gleichzeitig!$J$5:$K$8,2,0)))","v":0},0,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(($A$66=\"Vb\")*AND(Strangverbrauch!C26>0.899),\"Vbges. > 0,899mbar\",0)","v":0}]
[null,10,"RH",0,0,{"$f":"IF(E68=0,0,VLOOKUP(D68,Gleichzeitig!$B$3:$F$52,VLOOKUP(C68,Gleichzeitig!$J$5:$K$8,2,0)))","v":0},0,{"$f":"SUM(G66:G71)","v":0},0,null,{"$f":"IF(AND(J68<>0,OR($S$4=\"Cu\",$S$4=\"Stahl\")),IF($S$4=\"Cu\",VLOOKUP(H68+$AA$4,Kupfer!$A$5:$Q$55,VLOOKUP(J68,Gewinde!$S$8:$V$15,4)),VLOOKUP(H68+$AA$4,Gewinde!$A$5:$Q$55,VLOOKUP(J68,Gewinde!$T$8:$V$15,3))),0)","v":0},{"$f":"IF(AND(J68<>0,OR($S$4=\"Cu\",$S$4=\"Stahl\")),IF($S$4=\"Cu\",VLOOKUP(H68+$AA$4,Kupfer!$A$5:$Q$55,VLOOKUP(J68,Gewinde!$S$8:$V$15,3)),VLOOKUP(H68+$AA$4,Gewinde!$A$5:$Q$55,VLOOKUP(J68,Gewinde!$T$8:$V$15,2))),0)","v":0},{"$f":"(L68*I68)","v":0},{"$f":"Verlustbeiwert!X$29","v":0},{"$f":"0.003972*K68^2*N68","v":0},0,{"$f":"IF(P68=0,0,P68*(-0.04))","v":0},{"$f":"IF(AND(J68>0,K68<1),\"NIX\",M68+O68+Q68)","v":0},{"$f":"IF(($A$66=\"Ab\")*AND(Strangverbrauch!C26>0.599),\"Abges. > 0,599mbar\",0)","v":0},null,null,null,null,null,10]
[null,null,"UWH",0,0,{"$f":"IF(E69=0,0,VLOOKUP(D69,Gleichzeitig!$B$3:$F$52,VLOOKUP(C69,Gleichzeitig!$J$5:$K$8,2,0)))","v":0},0,{"$f":"IF(A67=\"GS\",\"VA\",\"\")","v":""},{"$f":"IF(A67=\"GS\",\"GS\",\"\")","v":""},{"$f":"IF($AD$10=2,\"Dimensionskontrolle !\",\"\")","v":""},null,null,null,null,null,null,null,{"$f":"Strangverbrauch!C10","v":0},{"$f":"IF(($A$66=\"Ez\")*AND(Strangverbrauch!C26>1.399),\"Ezges. > 1,399mbar\",0)","v":0}]
[null,null,"G2",0,0,{"$f":"IF(E70=0,0,VLOOKUP(D70,Gleichzeitig!$B$3:$F$52,VLOOKUP(C67,Gleichzeitig!$J$5:$K$8,2,0)))","v":0},0," "," ",null,null,null,null,null,null,null,null,0,{"$f":"Y68","v":10},0,0,0,0,0]
[null,null,null,0,0,{"$f":"IF(E71<>0,1,0)","v":0},0,{"$f":"IF(A67=\"GS\",SUM(E66:E71),\"\")","v":""},{"$f":"IF(A67=\"GS\",(IF(H71<=2.09,2.5,IF(AND(H71>=2.1,H71<=3.29),4,IF(AND(H71>=3.3,H71<=4.89),6,IF(AND(H71>=4.9,H71<=8.09),10,IF(AND(H71>=8.1,H71<=16),16,IF(H71>=16,\">16\"))))))),\"\")","v":""},null,null,null,null,null,{"$f":"IF(R71>0,\"Druckverlust bis zur HAE ->\",0)","v":0},null,null,{"$f":"Strangverbrauch!AD$22","v":0},0,0,0,0,0,1]
["Vt",null,"H",0,0,{"$f":"IF(E72=0,0,VLOOKUP(D72,Gleichzeitig!$B$3:$F$52,VLOOKUP(C72,Gleichzeitig!$J$5:$K$8,2,0)))","v":0},0,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(($A$72=\"Vt\")*AND(Strangverbrauch!C11>0.399),\"Vtges. > 0,399mbar\",0)","v":0}]
[". ",null,"DWH",0,0,{"$f":"IF(E73=0,0,VLOOKUP(D73,Gleichzeitig!$B$3:$F$52,VLOOKUP(C73,Gleichzeitig!$J$5:$K$8,2,0)))","v":0},0,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(($A$72=\"Vb\")*AND(Strangverbrauch!C31>0.899),\"Vbges. > 0,899mbar\",0)","v":0}]
[null,11,"RH",0,0,{"$f":"IF(E74=0,0,VLOOKUP(D74,Gleichzeitig!$B$3:$F$52,VLOOKUP(C74,Gleichzeitig!$J$5:$K$8,2,0)))","v":0},0,{"$f":"SUM(G72:G77)","v":0},0,null,{"$f":"IF(AND(J74<>0,OR($S$4=\"Cu\",$S$4=\"Stahl\")),IF($S$4=\"Cu\",VLOOKUP(H74+$AA$4,Kupfer!$A$5:$Q$55,VLOOKUP(J74,Gewinde!$S$8:$V$15,4)),VLOOKUP(H74+$AA$4,Gewinde!$A$5:$Q$55,VLOOKUP(J74,Gewinde!$T$8:$V$15,3))),0)","v":0},{"$f":"IF(AND(J74<>0,OR($S$4=\"Cu\",$S$4=\"Stahl\")),IF($S$4=\"Cu\",VLOOKUP(H74+$AA$4,Kupfer!$A$5:$Q$55,VLOOKUP(J74,Gewinde!$S$8:$V$15,3)),VLOOKUP(H74+$AA$4,Gewinde!$A$5:$Q$55,VLOOKUP(J74,Gewinde!$T$8:$V$15,2))),0)","v":0},{"$f":"(L74*I74)","v":0},{"$f":"Verlustbeiwert!Z29","v":0},{"$f":"0.003972*K74^2*N74","v":0},0,{"$f":"IF(P74=0,0,P74*(-0.04))","v":0},{"$f":"IF(AND(J74>0,K74<1),\"NIX\",M74+O74+Q74)","v":0},{"$f":"IF(($A$72=\"Ab\")*AND(Strangverbrauch!C31>0.599),\"Abges. > 0,599mbar\",0)","v":0},null,null,null,null,null,11]
[null,null,"UWH",0,0,{"$f":"IF(E75=0,0,VLOOKUP(D75,Gleichzeitig!$B$3:$F$52,VLOOKUP(C75,Gleichzeitig!$J$5:$K$8,2,0)))","v":0},0,{"$f":"IF(A73=\"GS\",\"VA\",\"\")","v":""},{"$f":"IF(A73=\"GS\",\"GS\",\"\")","v":""},{"$f":"IF($AD$10=2,\"Dimensionskontrolle !\",\"\")","v":""},null,null,null,null,null,null,null,{"$f":"Strangverbrauch!C11","v":0},{"$f":"IF(($A$72=\"Ez\")*AND(Strangverbrauch!C31>1.399),\"Ezges. > 1,399mbar\",0)","v":0}]
[null,null,"G2",0,0,{"$f":"IF(E76=0,0,VLOOKUP(D76,Gleichzeitig!$B$3:$F$52,VLOOKUP(C73,Gleichzeitig!$J$5:$K$8,2,0)))","v":0},0," "," ",null,null,null,null,null,null,null,null,0,{"$f":"Y74","v":11},0,0,0,0,0]
[null,null,null,0,0,{"$f":"IF(E77<>0,1,0)","v":0},0,{"$f":"IF(A73=\"GS\",SUM(E72:E77),\"\")","v":""},{"$f":"IF(A73=\"GS\",(IF(H77<=2.09,2.5,IF(AND(H77>=2.1,H77<=3.29),4,IF(AND(H77>=3.3,H77<=4.89),6,IF(AND(H77>=4.9,H77<=8.09),10,IF(AND(H77>=8.1,H77<=16),16,IF(H77>=16,\">16\"))))))),\"\")","v":""},null,null,null,null,null,{"$f":"IF(R77>0,\"Druckverlust bis zur HAE ->\",0)","v":0},null,null,{"$f":"Strangverbrauch!AE$22","v":0},0,0,0,0,0,1]
["Vt",null,"H",0,0,{"$f":"IF(E78=0,0,VLOOKUP(D78,Gleichzeitig!$B$3:$F$52,VLOOKUP(C78,Gleichzeitig!$J$5:$K$8,2,0)))","v":0},0,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(($A$78=\"Vt\")*AND(Strangverbrauch!C12>0.399),\"Vtges. > 0,399mbar\",0)","v":0}]
[". ",null,"DWH",0,0,{"$f":"IF(E79=0,0,VLOOKUP(D79,Gleichzeitig!$B$3:$F$52,VLOOKUP(C79,Gleichzeitig!$J$5:$K$8,2,0)))","v":0},0,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(($A$78=\"Vb\")*AND(Strangverbrauch!C36>0.899),\"Vbges. > 0,899mbar\",0)","v":0}]
[null,12,"RH",0,0,{"$f":"IF(E80=0,0,VLOOKUP(D80,Gleichzeitig!$B$3:$F$52,VLOOKUP(C80,Gleichzeitig!$J$5:$K$8,2,0)))","v":0},0,{"$f":"SUM(G78:G83)","v":0},0,null,{"$f":"IF(AND(J80<>0,OR($S$4=\"Cu\",$S$4=\"Stahl\")),IF($S$4=\"Cu\",VLOOKUP(H80+$AA$4,Kupfer!$A$5:$Q$55,VLOOKUP(J80,Gewinde!$S$8:$V$15,4)),VLOOKUP(H80+$AA$4,Gewinde!$A$5:$Q$55,VLOOKUP(J80,Gewinde!$T$8:$V$15,3))),0)","v":0},{"$f":"IF(AND(J80<>0,OR($S$4=\"Cu\",$S$4=\"Stahl\")),IF($S$4=\"Cu\",VLOOKUP(H80+$AA$4,Kupfer!$A$5:$Q$55,VLOOKUP(J80,Gewinde!$S$8:$V$15,3)),VLOOKUP(H80+$AA$4,Gewinde!$A$5:$Q$55,VLOOKUP(J80,Gewinde!$T$8:$V$15,2))),0)","v":0},{"$f":"(L80*I80)","v":0},{"$f":"Verlustbeiwert!AB29","v":0},{"$f":"0.003972*K80^2*N80","v":0},0,{"$f":"IF(P80=0,0,P80*(-0.04))","v":0},{"$f":"IF(AND(J80>0,K80<1),\"NIX\",M80+O80+Q80)","v":0},{"$f":"IF(($A$78=\"Ab\")*AND(Strangverbrauch!C36>0.599),\"Abges. > 0,599mbar\",0)","v":0},null,null,null,null,null,12]
[null,null,"UWH",0,0,{"$f":"IF(E81=0,0,VLOOKUP(D81,Gleichzeitig!$B$3:$F$52,VLOOKUP(C81,Gleichzeitig!$J$5:$K$8,2,0)))","v":0},0,{"$f":"IF(A79=\"GS\",\"VA\",\"\")","v":""},{"$f":"IF(A79=\"GS\",\"GS\",\"\")","v":""},{"$f":"IF($AD$10=2,\"Dimensionskontrolle !\",\"\")","v":""},null,null,null,null,null,null,null,{"$f":"Strangverbrauch!C12","v":0},{"$f":"IF(($A$78=\"Ez\")*AND(Strangverbrauch!C36>1.399),\"Ezges. > 1,399mbar\",0)","v":0}]
[null,null,"G2",0,0,{"$f":"IF(E82=0,0,VLOOKUP(D82,Gleichzeitig!$B$3:$F$52,VLOOKUP(C79,Gleichzeitig!$J$5:$K$8,2,0)))","v":0},0," "," ",null,null,null,null,null,null,null,null,0,{"$f":"Y80","v":12},0,0,0,0,0]
[null,null,null,0,0,{"$f":"IF(E83<>0,1,0)","v":0},0,{"$f":"IF(A79=\"GS\",SUM(E78:E83),\"\")","v":""},{"$f":"IF(A79=\"GS\",(IF(H83<=2.09,2.5,IF(AND(H83>=2.1,H83<=3.29),4,IF(AND(H83>=3.3,H83<=4.89),6,IF(AND(H83>=4.9,H83<=8.09),10,IF(AND(H83>=8.1,H83<=16),16,IF(H83>=16,\">16\"))))))),\"\")","v":""},null,null,null,null,null,{"$f":"IF(R83>0,\"Druckverlust bis zur HAE ->\",0)","v":0},null,null,{"$f":"Strangverbrauch!AF$22","v":0},0,0,0,0,0,1]
["Vt",null,"H",0,0,{"$f":"IF(E84=0,0,VLOOKUP(D84,Gleichzeitig!$B$3:$F$52,VLOOKUP(C84,Gleichzeitig!$J$5:$K$8,2,0)))","v":0},0,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(($A$84=\"Vt\")*AND(Strangverbrauch!C13>0.399),\"Vtges. > 0,399mbar\",0)","v":0}]
[". ",null,"DWH",0,0,{"$f":"IF(E85=0,0,VLOOKUP(D85,Gleichzeitig!$B$3:$F$52,VLOOKUP(C85,Gleichzeitig!$J$5:$K$8,2,0)))","v":0},0,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(($A$84=\"Vb\")*AND(Strangverbrauch!C41>0.899),\"Vbges. > 0,899mbar\",0)","v":0}]
[null,13,"RH",0,0,{"$f":"IF(E86=0,0,VLOOKUP(D86,Gleichzeitig!$B$3:$F$52,VLOOKUP(C86,Gleichzeitig!$J$5:$K$8,2,0)))","v":0},0,{"$f":"SUM(G84:G89)","v":0},0,null,{"$f":"IF(AND(J86<>0,OR($S$4=\"Cu\",$S$4=\"Stahl\")),IF($S$4=\"Cu\",VLOOKUP(H86+$AA$4,Kupfer!$A$5:$Q$55,VLOOKUP(J86,Gewinde!$S$8:$V$15,4)),VLOOKUP(H86+$AA$4,Gewinde!$A$5:$Q$55,VLOOKUP(J86,Gewinde!$T$8:$V$15,3))),0)","v":0},{"$f":"IF(AND(J86<>0,OR($S$4=\"Cu\",$S$4=\"Stahl\")),IF($S$4=\"Cu\",VLOOKUP(H86+$AA$4,Kupfer!$A$5:$Q$55,VLOOKUP(J86,Gewinde!$S$8:$V$15,3)),VLOOKUP(H86+$AA$4,Gewinde!$A$5:$Q$55,VLOOKUP(J86,Gewinde!$T$8:$V$15,2))),0)","v":0},{"$f":"(L86*I86)","v":0},{"$f":"Verlustbeiwert!AD29","v":0},{"$f":"0.003972*K86^2*N86","v":0},0,{"$f":"IF(P86=0,0,P86*(-0.04))","v":0},{"$f":"IF(AND(J86>0,K86<1),\"NIX\",M86+O86+Q86)","v":0},{"$f":"IF(($A$84=\"Ab\")*AND(Strangverbrauch!C41>0.599),\"Abges. > 0,599mbar\",0)","v":0},null,null,null,null,null,13]
[null,null,"UWH",0,0,{"$f":"IF(E87=0,0,VLOOKUP(D87,Gleichzeitig!$B$3:$F$52,VLOOKUP(C87,Gleichzeitig!$J$5:$K$8,2,0)))","v":0},0,{"$f":"IF(A85=\"GS\",\"VA\",\"\")","v":""},{"$f":"IF(A85=\"GS\",\"GS\",\"\")","v":""},{"$f":"IF($AD$10=2,\"Dimensionskontrolle !\",\"\")","v":""},null,null,null,null,null,null,null,{"$f":"Strangverbrauch!C13","v":0},{"$f":"IF(($A$84=\"Ez\")*AND(Strangverbrauch!C41>1.399),\"Ezges. > 1,399mbar\",0)","v":0}]
[null,null,"G2",0,0,{"$f":"IF(E88=0,0,VLOOKUP(D88,Gleichzeitig!$B$3:$F$52,VLOOKUP(C85,Gleichzeitig!$J$5:$K$8,2,0)))","v":0},0," "," ",null,null,null,null,null,null,null,null,0,{"$f":"Y86","v":13},0,0,0,0,0]
[null,null,null,0,0,{"$f":"IF(E89<>0,1,0)","v":0},0,{"$f":"IF(A85=\"GS\",SUM(E84:E89),\"\")","v":""},{"$f":"IF(A85=\"GS\",(IF(H89<=2.09,2.5,IF(AND(H89>=2.1,H89<=3.29),4,IF(AND(H89>=3.3,H89<=4.89),6,IF(AND(H89>=4.9,H89<=8.09),10,IF(AND(H89>=8.1,H89<=16),16,IF(H89>=16,\">16\"))))))),\"\")","v":""},null,null,null,null,null,{"$f":"IF(R89>0,\"Druckverlust bis zur HAE ->\",0)","v":0},null,null,{"$f":"Strangverbrauch!AG$22","v":0},0,0,0,0,0,1]
["Vt",null,"H",0,0,{"$f":"IF(E90=0,0,VLOOKUP(D90,Gleichzeitig!$B$3:$F$52,VLOOKUP(C90,Gleichzeitig!$J$5:$K$8,2,0)))","v":0},{"$f":"$E90*$F90","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(($A$90=\"Vt\")*AND(Strangverbrauch!C14>0.399),\"Vtges. > 0,399mbar\",0)","v":0}]
[". ",null,"DWH",0,0,{"$f":"IF(E91=0,0,VLOOKUP(D91,Gleichzeitig!$B$3:$F$52,VLOOKUP(C91,Gleichzeitig!$J$5:$K$8,2,0)))","v":0},0,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(($A$90=\"Vb\")*AND(Strangverbrauch!C46>0.899),\"Vbges. > 0,899mbar\",0)","v":0}]
[null,14,"RH",0,0,{"$f":"IF(E92=0,0,VLOOKUP(D92,Gleichzeitig!$B$3:$F$52,VLOOKUP(C92,Gleichzeitig!$J$5:$K$8,2,0)))","v":0},0,{"$f":"SUM(G90:G95)","v":0},null,null,{"$f":"IF(AND(J92<>0,OR($S$4=\"Cu\",$S$4=\"Stahl\")),IF($S$4=\"Cu\",VLOOKUP(H92+$AA$4,Kupfer!$A$5:$Q$55,VLOOKUP(J92,Gewinde!$S$8:$V$15,4)),VLOOKUP(H92+$AA$4,Gewinde!$A$5:$Q$55,VLOOKUP(J92,Gewinde!$T$8:$V$15,3))),0)","v":0},{"$f":"IF(AND(J92<>0,OR($S$4=\"Cu\",$S$4=\"Stahl\")),IF($S$4=\"Cu\",VLOOKUP(H92+$AA$4,Kupfer!$A$5:$Q$55,VLOOKUP(J92,Gewinde!$S$8:$V$15,3)),VLOOKUP(H92+$AA$4,Gewinde!$A$5:$Q$55,VLOOKUP(J92,Gewinde!$T$8:$V$15,2))),0)","v":0},{"$f":"(L92*I92)","v":0},{"$f":"Verlustbeiwert!AF29","v":0},{"$f":"0.003972*K92^2*N92","v":0},null,{"$f":"IF(P92=0,0,P92*(-0.04))","v":0},{"$f":"IF(AND(J92>0,K92<1),\"NIX\",M92+O92+Q92)","v":0},{"$f":"IF(($A$90=\"Ab\")*AND(Strangverbrauch!C46>0.599),\"Abges. > 0,599mbar\",0)","v":0},null,null,null,null,null,14]
[null,null,"UWH",0,0,{"$f":"IF(E93=0,0,VLOOKUP(D93,Gleichzeitig!$B$3:$F$52,VLOOKUP(C93,Gleichzeitig!$J$5:$K$8,2,0)))","v":0},0,{"$f":"IF(A91=\"GS\",\"VA\",\"\")","v":""},{"$f":"IF(A91=\"GS\",\"GS\",\"\")","v":""},{"$f":"IF($AD$10=2,\"Dimensionskontrolle !\",\"\")","v":""},null,null,null,null,null,null,null,{"$f":"Strangverbrauch!C14","v":0},{"$f":"IF(($A$90=\"Ez\")*AND(Strangverbrauch!C46>1.399),\"Ezges. > 1,399mbar\",0)","v":0}]
[null,null,"G2",0,0,{"$f":"IF(E94=0,0,VLOOKUP(D94,Gleichzeitig!$B$3:$F$52,VLOOKUP(C91,Gleichzeitig!$J$5:$K$8,2,0)))","v":0},0," "," ",null,null,null,null,null,null,null,null,0,{"$f":"Y92","v":14},0,0,0,0,0]
[null,null,null,0,0,{"$f":"IF(E95<>0,1,0)","v":0},0,{"$f":"IF(A91=\"GS\",SUM(E90:E95),\"\")","v":""},{"$f":"IF(A91=\"GS\",(IF(H95<=2.09,2.5,IF(AND(H95>=2.1,H95<=3.29),4,IF(AND(H95>=3.3,H95<=4.89),6,IF(AND(H95>=4.9,H95<=8.09),10,IF(AND(H95>=8.1,H95<=16),16,IF(H95>=16,\">16\"))))))),\"\")","v":""},null,null,null,null,null,{"$f":"IF(R95>0,\"Druckverlust bis zur HAE ->\",0)","v":0},null,null,{"$f":"Strangverbrauch!AH$22","v":0},0,0,0,0,0,1]
["Vt",null,"H",0,0,{"$f":"IF(E96=0,0,VLOOKUP(D96,Gleichzeitig!$B$3:$F$52,VLOOKUP(C96,Gleichzeitig!$J$5:$K$8,2,0)))","v":0},0,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(($A$96=\"Vt\")*AND(Strangverbrauch!C15>0.399),\"Vtges. > 0,399mbar\",0)","v":0}]
[". ",null,"DWH",0,0,{"$f":"IF(E97=0,0,VLOOKUP(D97,Gleichzeitig!$B$3:$F$52,VLOOKUP(C97,Gleichzeitig!$J$5:$K$8,2,0)))","v":0},0,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(($A$96=\"Vb\")*AND(Strangverbrauch!C51>0.899),\"Vbges. > 0,899mbar\",0)","v":0}]
[null,15,"RH",0,0,{"$f":"IF(E98=0,0,VLOOKUP(D98,Gleichzeitig!$B$3:$F$52,VLOOKUP(C98,Gleichzeitig!$J$5:$K$8,2,0)))","v":0},0,{"$f":"SUM(G96:G101)","v":0},null,0,{"$f":"IF(AND(J98<>0,OR($S$4=\"Cu\",$S$4=\"Stahl\")),IF($S$4=\"Cu\",VLOOKUP(H98+$AA$4,Kupfer!$A$5:$Q$55,VLOOKUP(J98,Gewinde!$S$8:$V$15,4)),VLOOKUP(H98+$AA$4,Gewinde!$A$5:$Q$55,VLOOKUP(J98,Gewinde!$T$8:$V$15,3))),0)","v":0},{"$f":"IF(AND(J98<>0,OR($S$4=\"Cu\",$S$4=\"Stahl\")),IF($S$4=\"Cu\",VLOOKUP(H98+$AA$4,Kupfer!$A$5:$Q$55,VLOOKUP(J98,Gewinde!$S$8:$V$15,3)),VLOOKUP(H98+$AA$4,Gewinde!$A$5:$Q$55,VLOOKUP(J98,Gewinde!$T$8:$V$15,2))),0)","v":0},{"$f":"(L98*I98)","v":0},{"$f":"Verlustbeiwert!AH29","v":0},{"$f":"0.003972*K98^2*N98","v":0},0,{"$f":"IF(P98=0,0,P98*(-0.04))","v":0},{"$f":"IF(AND(J98>0,K98<1),\"NIX\",M98+O98+Q98)","v":0},{"$f":"IF(($A$96=\"Ab\")*AND(Strangverbrauch!C51>0.599),\"Abges. > 0,599mbar\",0)","v":0},null,null,null,null,null,15]
[null,null,"UWH",0,0,{"$f":"IF(E99=0,0,VLOOKUP(D99,Gleichzeitig!$B$3:$F$52,VLOOKUP(C99,Gleichzeitig!$J$5:$K$8,2,0)))","v":0},0,{"$f":"IF(A97=\"GS\",\"VA\",\"\")","v":""},{"$f":"IF(A97=\"GS\",\"GS\",\"\")","v":""},{"$f":"IF($AD$10=2,\"Dimensionskontrolle !\",\"\")","v":""},null,null,null,null,null,null,null,{"$f":"Strangverbrauch!C15","v":0},{"$f":"IF(($A$96=\"Ez\")*AND(Strangverbrauch!C51>1.399),\"Ezges. > 1,399mbar\",0)","v":0}]
[null,null,"G2",0,0,{"$f":"IF(E100=0,0,VLOOKUP(D100,Gleichzeitig!$B$3:$F$52,VLOOKUP(C97,Gleichzeitig!$J$5:$K$8,2,0)))","v":0},0," "," ",null,null,null,null,null,null,null,null,0,{"$f":"Y98","v":15},0,0,0,0,0]
[null,null,null,0,0,{"$f":"IF(E101<>0,1,0)","v":0},0,{"$f":"IF(A97=\"GS\",SUM(E96:E101),\"\")","v":""},{"$f":"IF(A97=\"GS\",(IF(H101<=2.09,2.5,IF(AND(H101>=2.1,H101<=3.29),4,IF(AND(H101>=3.3,H101<=4.89),6,IF(AND(H101>=4.9,H101<=8.09),10,IF(AND(H101>=8.1,H101<=16),16,IF(H101>=16,\">16\"))))))),\"\")","v":""},null,null,null,null,null,{"$f":"IF(R101>0,\"Druckverlust bis zur HAE ->\",0)","v":0},null,null,{"$f":"Strangverbrauch!AI$22","v":0},0,0,0,0,0,1]
["Vt",null,"H",0,0,{"$f":"IF(E102=0,0,VLOOKUP(D102,Gleichzeitig!$B$3:$F$52,VLOOKUP(C102,Gleichzeitig!$J$5:$K$8,2,0)))","v":0},0,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(($A$102=\"Vt\")*AND(Strangverbrauch!C16>0.399),\"Vtges. > 0,399mbar\",0)","v":0}]
[". ",null,"DWH",0,0,{"$f":"IF(E103=0,0,VLOOKUP(D103,Gleichzeitig!$B$3:$F$52,VLOOKUP(C103,Gleichzeitig!$J$5:$K$8,2,0)))","v":0},0,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(($A$102=\"Vb\")*AND(Strangverbrauch!C56>0.899),\"Vbges. > 0,899mbar\",0)","v":0}]
[null,16,"RH",0,0,{"$f":"IF(E104=0,0,VLOOKUP(D104,Gleichzeitig!$B$3:$F$52,VLOOKUP(C104,Gleichzeitig!$J$5:$K$8,2,0)))","v":0},0,{"$f":"SUM(G102:G107)","v":0},null,0,{"$f":"IF(AND(J104<>0,OR($S$4=\"Cu\",$S$4=\"Stahl\")),IF($S$4=\"Cu\",VLOOKUP(H104+$AA$4,Kupfer!$A$5:$Q$55,VLOOKUP(J104,Gewinde!$S$8:$V$15,4)),VLOOKUP(H104+$AA$4,Gewinde!$A$5:$Q$55,VLOOKUP(J104,Gewinde!$T$8:$V$15,3))),0)","v":0},{"$f":"IF(AND(J104<>0,OR($S$4=\"Cu\",$S$4=\"Stahl\")),IF($S$4=\"Cu\",VLOOKUP(H104+$AA$4,Kupfer!$A$5:$Q$55,VLOOKUP(J104,Gewinde!$S$8:$V$15,3)),VLOOKUP(H104+$AA$4,Gewinde!$A$5:$Q$55,VLOOKUP(J104,Gewinde!$T$8:$V$15,2))),0)","v":0},{"$f":"(L104*I104)","v":0},{"$f":"Verlustbeiwert!AJ29","v":0},{"$f":"0.003972*K104^2*N104","v":0},0,{"$f":"IF(P104=0,0,P104*(-0.04))","v":0},{"$f":"IF(AND(J104>0,K104<1),\"NIX\",M104+O104+Q104)","v":0},{"$f":"IF(($A$102=\"Ab\")*AND(Strangverbrauch!C56>0.599),\"Abges. > 0,599mbar\",0)","v":0},null,null,null,null,null,16]
[null,null,"UWH",0,0,{"$f":"IF(E105=0,0,VLOOKUP(D105,Gleichzeitig!$B$3:$F$52,VLOOKUP(C105,Gleichzeitig!$J$5:$K$8,2,0)))","v":0},0,{"$f":"IF(A103=\"GS\",\"VA\",\"\")","v":""},{"$f":"IF(A103=\"GS\",\"GS\",\"\")","v":""},{"$f":"IF($AD$10=2,\"Dimensionskontrolle !\",\"\")","v":""},null,null,null,null,null,null,null,{"$f":"Strangverbrauch!C16","v":0},{"$f":"IF(($A$102=\"Ez\")*AND(Strangverbrauch!C56>1.399),\"Ezges. > 1,399mbar\",0)","v":0}]
[null,null,"G2",0,0,{"$f":"IF(E106=0,0,VLOOKUP(D106,Gleichzeitig!$B$3:$F$52,VLOOKUP(C103,Gleichzeitig!$J$5:$K$8,2,0)))","v":0},0," "," ",null,null,null,null,null,null,null,null,0,{"$f":"Y104","v":16},0,0,0,0,0]
[null,null,null,0,0,{"$f":"IF(E107<>0,1,0)","v":0},0,{"$f":"IF(A103=\"GS\",SUM(E102:E107),\"\")","v":""},{"$f":"IF(A103=\"GS\",(IF(H107<=2.09,2.5,IF(AND(H107>=2.1,H107<=3.29),4,IF(AND(H107>=3.3,H107<=4.89),6,IF(AND(H107>=4.9,H107<=8.09),10,IF(AND(H107>=8.1,H107<=16),16,IF(H107>=16,\">16\"))))))),\"\")","v":""},null,null,null,null,null,{"$f":"IF(R107>0,\"Druckverlust bis zur HAE ->\",0)","v":0},null,null,{"$f":"Strangverbrauch!AJ$22","v":0},0,0,0,0,0,1]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]

{"sheet":"Strangverbrauch","index":3,"n_rows":22,"n_cols":37,"rows_kept":22,"cut":false,"hidden":true,"merged":[[0,20,0,36]]}
[1,{"$f":"IF(Formblatt1a!A12=\"Vt\",\"Vt\",(IF(Formblatt1a!A12=\"Vb\",\"Vb\",(IF(Formblatt1a!A12=\"Ab\",\"Abl\",(IF(Formblatt1a!A12=\"Ez\",\"Ezl\")))))))","v":"Vt"},{"$f":"SUM(E1:P1)","v":0},null,{"$f":"INDIRECT($B$1&Formblatt1a!S$16)","v":0},{"$f":"INDIRECT($B$1&Formblatt1a!T$16)","v":0},{"$f":"INDIRECT($B$1&Formblatt1a!U$16)","v":0},{"$f":"INDIRECT($B$1&Formblatt1a!V$16)","v":0},{"$f":"INDIRECT($B$1&Formblatt1a!W$16)","v":0},{"$f":"INDIRECT($B$1&Formblatt1a!X$16)","v":0},{"$f":"INDIRECT($B$1&Formblatt1a!S$17)","v":0},{"$f":"INDIRECT($B$1&Formblatt1a!T$17)","v":0},{"$f":"INDIRECT($B$1&Formblatt1a!U$17)","v":0},{"$f":"INDIRECT($B$1&Formblatt1a!V$17)","v":0},{"$f":"INDIRECT($B$1&Formblatt1a!W$17)","v":0},{"$f":"INDIRECT($B$1&Formblatt1a!X$17)","v":0},null,null,null,null,"Teilstrecken"]
[2,{"$f":"IF(Formblatt1a!A18=\"Vt\",\"Vt\",(IF(Formblatt1a!A18=\"Vb\",\"Vb\",(IF(Formblatt1a!A18=\"Ab\",\"Abl\",(IF(Formblatt1a!A18=\"Ez\",\"Ezl\")))))))","v":"Vt"},0,null,{"$f":"INDIRECT($B$2&Formblatt1a!S$22)","v":0},{"$f":"INDIRECT($B$2&Formblatt1a!T$22)","v":0},{"$f":"INDIRECT($B$2&Formblatt1a!U$22)","v":0},{"$f":"INDIRECT($B$2&Formblatt1a!V$22)","v":0},{"$f":"INDIRECT($B$2&Formblatt1a!W$22)","v":0},{"$f":"INDIRECT($B$2&Formblatt1a!X$22)","v":0},{"$f":"INDIRECT($B$2&Formblatt1a!S$23)","v":0},{"$f":"INDIRECT($B$2&Formblatt1a!T$23)","v":0},{"$f":"INDIRECT($B$2&Formblatt1a!U$23)","v":0},{"$f":"INDIRECT($B$2&Formblatt1a!V$23)","v":0},{"$f":"INDIRECT($B$2&Formblatt1a!W$23)","v":0},{"$f":"INDIRECT($B$2&Formblatt1a!X$23)","v":0},null,null,null,0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16]
[3,{"$f":"IF(Formblatt1a!A24=\"Vt\",\"Vt\",(IF(Formblatt1a!A24=\"Vb\",\"Vb\",(IF(Formblatt1a!A24=\"Ab\",\"Abl\",(IF(Formblatt1a!A24=\"Ez\",\"Ezl\")))))))","v":"Vt"},0,null,{"$f":"INDIRECT($B$3&Formblatt1a!S$28)","v":0},{"$f":"INDIRECT($B$3&Formblatt1a!T$28)","v":0},{"$f":"INDIRECT($B$3&Formblatt1a!U$28)","v":0},{"$f":"INDIRECT($B$3&Formblatt1a!V$28)","v":0},{"$f":"INDIRECT($B$3&Formblatt1a!W$28)","v":0},{"$f":"INDIRECT($B$3&Formblatt1a!X$28)","v":0},{"$f":"INDIRECT($B$3&Formblatt1a!S$29)","v":0},{"$f":"INDIRECT($B$3&Formblatt1a!T$29)","v":0},{"$f":"INDIRECT($B$3&Formblatt1a!U$29)","v":0},{"$f":"INDIRECT($B$3&Formblatt1a!V$29)","v":0},{"$f":"INDIRECT($B$3&Formblatt1a!W$29)","v":0},{"$f":"INDIRECT($B$3&Formblatt1a!X$29)","v":0},null,null,"Vt = ",null,{"$f":"IF(Formblatt1a!$A$12=\"Vt\",Formblatt1a!$R$14,0)","v":0},{"$f":"IF(Formblatt1a!$A$18=\"Vt\",Formblatt1a!$R$20,0)","v":0},{"$f":"IF(Formblatt1a!$A$24=\"Vt\",Formblatt1a!$R$26,0)","v":0},{"$f":"IF(Formblatt1a!$A$30=\"Vt\",Formblatt1a!$R$32,0)","v":0},{"$f":"IF(Formblatt1a!$A$36=\"Vt\",Formblatt1a!$R$38,0)","v":0},{"$f":"IF(Formblatt1a!$A$42=\"Vt\",Formblatt1a!$R$44,0)","v":0},{"$f":"IF(Formblatt1a!$A$48=\"Vt\",Formblatt1a!$R$50,0)","v":0},{"$f":"IF(Formblatt1a!$A$72=\"Vt\",Formblatt1a!$R$56,0)","v":0},{"$f":"IF(Formblatt1a!$A$72=\"Vt\",Formblatt1a!$R$62,0)","v":0},{"$f":"IF(Formblatt1a!$A$72=\"Vt\",Formblatt1a!$R$68,0)","v":0},{"$f":"IF(Formblatt1a!$A$72=\"Vt\",Formblatt1a!$R$74,0)","v":0},{"$f":"IF(Formblatt1a!$A$78=\"Vt\",Formblatt1a!$R$80,0)","v":0},{"$f":"IF(Formblatt1a!$A$84=\"Vt\",Formblatt1a!$R$86,0)","v":0},{"$f":"IF(Formblatt1a!$A$90=\"Vt\",Formblatt1a!$R$92,0)","v":0},{"$f":"IF(Formblatt1a!$A$96=\"Vt\",Formblatt1a!$R$98,0)","v":0},{"$f":"IF(Formblatt1a!$A$102=\"Vt\",Formblatt1a!$R$104,0)","v":0},{"$f":"SUM(U3:AJ3)","v":0}]
[4,{"$f":"IF(Formblatt1a!A30=\"Vt\",\"Vt\",(IF(Formblatt1a!A30=\"Vb\",\"Vb\",(IF(Formblatt1a!A30=\"Ab\",\"Abl\",(IF(Formblatt1a!A30=\"Ez\",\"Ezl\")))))))","v":"Vt"},0,null,{"$f":"INDIRECT($B$4&Formblatt1a!S$34)","v":0},{"$f":"INDIRECT($B$4&Formblatt1a!T$34)","v":0},{"$f":"INDIRECT($B$4&Formblatt1a!U$34)","v":0},{"$f":"INDIRECT($B$4&Formblatt1a!V$34)","v":0},{"$f":"INDIRECT($B$4&Formblatt1a!W$34)","v":0},{"$f":"INDIRECT($B$4&Formblatt1a!X$34)","v":0},{"$f":"INDIRECT($B$4&Formblatt1a!S$35)","v":0},{"$f":"INDIRECT($B$4&Formblatt1a!T$35)","v":0},{"$f":"INDIRECT($B$4&Formblatt1a!U$35)","v":0},{"$f":"INDIRECT($B$4&Formblatt1a!V$35)","v":0},{"$f":"INDIRECT($B$4&Formblatt1a!W$35)","v":0},{"$f":"INDIRECT($B$4&Formblatt1a!X$35)","v":0},null,null,"Vb = ",null,{"$f":"IF(Formblatt1a!$A$12=\"Vb\",Formblatt1a!$R$14,0)","v":0},{"$f":"IF(Formblatt1a!$A$18=\"Vb\",Formblatt1a!$R$20,0)","v":0},{"$f":"IF(Formblatt1a!$A$24=\"Vb\",Formblatt1a!$R$26,0)","v":0},{"$f":"IF(Formblatt1a!$A$30=\"Vb\",Formblatt1a!$R$32,0)","v":0},{"$f":"IF(Formblatt1a!$A$36=\"Vb\",Formblatt1a!$R$38,0)","v":0},{"$f":"IF(Formblatt1a!$A$42=\"Vb\",Formblatt1a!$R$44,0)","v":0},{"$f":"IF(Formblatt1a!$A$48=\"Vb\",Formblatt1a!$R$50,0)","v":0},{"$f":"IF(Formblatt1a!$A$72=\"Vb\",Formblatt1a!$R$56,0)","v":0},{"$f":"IF(Formblatt1a!$A$72=\"Vb\",Formblatt1a!$R$62,0)","v":0},{"$f":"IF(Formblatt1a!$A$72=\"Vb\",Formblatt1a!$R$68,0)","v":0},{"$f":"IF(Formblatt1a!$A$72=\"Vb\",Formblatt1a!$R$74,0)","v":0},{"$f":"IF(Formblatt1a!$A$78=\"Vb\",Formblatt1a!$R$80,0)","v":0},{"$f":"IF(Formblatt1a!$A$84=\"Vb\",Formblatt1a!$R$86,0)","v":0},{"$f":"IF(Formblatt1a!$A$90=\"Vb\",Formblatt1a!$R$92,0)","v":0},{"$f":"IF(Formblatt1a!$A$96=\"Vb\",Formblatt1a!$R$98,0)","v":0},{"$f":"IF(Formblatt1a!$A$102=\"Vb\",Formblatt1a!$R$104,0)","v":0},{"$f":"SUM(U4:AJ4)","v":0}]
[5,{"$f":"IF(Formblatt1a!A36=\"Vt\",\"Vt\",(IF(Formblatt1a!A36=\"Vb\",\"Vb\",(IF(Formblatt1a!A36=\"Ab\",\"Abl\",(IF(Formblatt1a!A36=\"Ez\",\"Ezl\")))))))","v":"Vt"},0,null,{"$f":"INDIRECT($B$5&Formblatt1a!S$40)","v":0},{"$f":"INDIRECT($B$5&Formblatt1a!T$40)","v":0},{"$f":"INDIRECT($B$5&Formblatt1a!U$40)","v":0},{"$f":"INDIRECT($B$5&Formblatt1a!V$40)","v":0},{"$f":"INDIRECT($B$5&Formblatt1a!W$40)","v":0},{"$f":"INDIRECT($B$5&Formblatt1a!X$40)","v":0},{"$f":"INDIRECT($B$5&Formblatt1a!S$41)","v":0},{"$f":"INDIRECT($B$5&Formblatt1a!T$41)","v":0},{"$f":"INDIRECT($B$5&Formblatt1a!U$41)","v":0},{"$f":"INDIRECT($B$5&Formblatt1a!V$41)","v":0},{"$f":"INDIRECT($B$5&Formblatt1a!W$41)","v":0},{"$f":"INDIRECT($B$5&Formblatt1a!X$41)","v":0},null,null,"Abl ="," ",{"$f":"IF(Formblatt1a!$A$12=\"Ab\",Formblatt1a!$R$14,0)","v":0},{"$f":"IF(Formblatt1a!$A$18=\"Ab\",Formblatt1a!$R$20,0)","v":0},{"$f":"IF(Formblatt1a!$A$24=\"Ab\",Formblatt1a!$R$26,0)","v":0},{"$f":"IF(Formblatt1a!$A$30=\"Ab\",Formblatt1a!$R$32,0)","v":0},{"$f":"IF(Formblatt1a!$A$36=\"Ab\",Formblatt1a!$R$38,0)","v":0},{"$f":"IF(Formblatt1a!$A$42=\"Ab\",Formblatt1a!$R$44,0)","v":0},{"$f":"IF(Formblatt1a!$A$48=\"Ab\",Formblatt1a!$R$50,0)","v":0},{"$f":"IF(Formblatt1a!$A$72=\"Ab\",Formblatt1a!$R$56,0)","v":0},{"$f":"IF(Formblatt1a!$A$72=\"Ab\",Formblatt1a!$R$62,0)","v":0},{"$f":"IF(Formblatt1a!$A$72=\"Ab\",Formblatt1a!$R$68,0)","v":0},{"$f":"IF(Formblatt1a!$A$72=\"Ab\",Formblatt1a!$R$74,0)","v":0},{"$f":"IF(Formblatt1a!$A$78=\"Ab\",Formblatt1a!$R$80,0)","v":0},{"$f":"IF(Formblatt1a!$A$84=\"Ab\",Formblatt1a!$R$86,0)","v":0},{"$f":"IF(Formblatt1a!$A$90=\"Ab\",Formblatt1a!$R$92,0)","v":0},{"$f":"IF(Formblatt1a!$A$96=\"Ab\",Formblatt1a!$R$98,0)","v":0},{"$f":"IF(Formblatt1a!$A$102=\"Ab\",Formblatt1a!$R$104,0)","v":0},{"$f":"SUM(U5:AJ5)","v":0}]
[6,{"$f":"IF(Formblatt1a!A42=\"Vt\",\"Vt\",(IF(Formblatt1a!A42=\"Vb\",\"Vb\",(IF(Formblatt1a!A42=\"Ab\",\"Abl\",(IF(Formblatt1a!A42=\"Ez\",\"Ezl\")))))))","v":"Vt"},0,null,{"$f":"INDIRECT($B$6&Formblatt1a!S$46)","v":0},{"$f":"INDIRECT($B$6&Formblatt1a!T$46)","v":0},{"$f":"INDIRECT($B$6&Formblatt1a!U$46)","v":0},{"$f":"INDIRECT($B$6&Formblatt1a!V$46)","v":0},{"$f":"INDIRECT($B$6&Formblatt1a!W$46)","v":0},{"$f":"INDIRECT($B$6&Formblatt1a!X$46)","v":0},{"$f":"INDIRECT($B$6&Formblatt1a!S$47)","v":0},{"$f":"INDIRECT($B$6&Formblatt1a!T$47)","v":0},{"$f":"INDIRECT($B$6&Formblatt1a!U$47)","v":0},{"$f":"INDIRECT($B$6&Formblatt1a!V$47)","v":0},{"$f":"INDIRECT($B$6&Formblatt1a!W$47)","v":0},{"$f":"INDIRECT($B$6&Formblatt1a!X$47)","v":0},null,null,"Ezl =",null,{"$f":"IF(Formblatt1a!$A$12=\"Ez\",Formblatt1a!$R$14,0)","v":0},{"$f":"IF(Formblatt1a!$A$18=\"Ez\",Formblatt1a!$R$20,0)","v":0},{"$f":"IF(Formblatt1a!$A$24=\"Ez\",Formblatt1a!$R$26,0)","v":0},{"$f":"IF(Formblatt1a!$A$30=\"Ez\",Formblatt1a!$R$32,0)","v":0},{"$f":"IF(Formblatt1a!$A$36=\"Ez\",Formblatt1a!$R$38,0)","v":0},{"$f":"IF(Formblatt1a!$A$42=\"Ez\",Formblatt1a!$R$44,0)","v":0},{"$f":"IF(Formblatt1a!$A$48=\"Ez\",Formblatt1a!$R$50,0)","v":0},{"$f":"IF(Formblatt1a!$A$72=\"Ez\",Formblatt1a!$R$56,0)","v":0},{"$f":"IF(Formblatt1a!$A$72=\"Ez\",Formblatt1a!$R$62,0)","v":0},{"$f":"IF(Formblatt1a!$A$72=\"Ez\",Formblatt1a!$R$68,0)","v":0},{"$f":"IF(Formblatt1a!$A$72=\"Ez\",Formblatt1a!$R$74,0)","v":0},{"$f":"IF(Formblatt1a!$A$78=\"Ez\",Formblatt1a!$R$80,0)","v":0},{"$f":"IF(Formblatt1a!$A$84=\"Ez\",Formblatt1a!$R$86,0)","v":0},{"$f":"IF(Formblatt1a!$A$90=\"Ez\",Formblatt1a!$R$92,0)","v":0},{"$f":"IF(Formblatt1a!$A$96=\"Ez\",Formblatt1a!$R$98,0)","v":0},{"$f":"IF(Formblatt1a!$A$102=\"Ez\",Formblatt1a!$R$104,0)","v":0}]
[7,{"$f":"IF(Formblatt1a!A48=\"Vt\",\"Vt\",(IF(Formblatt1a!A48=\"Vb\",\"Vb\",(IF(Formblatt1a!A48=\"Ab\",\"Abl\",(IF(Formblatt1a!A48=\"Ez\",\"Ezl\")))))))","v":"Vt"},0,null,{"$f":"INDIRECT($B$7&Formblatt1a!S$52)","v":0},{"$f":"INDIRECT($B$7&Formblatt1a!T$52)","v":0},{"$f":"INDIRECT($B$7&Formblatt1a!U$52)","v":0},{"$f":"INDIRECT($B$7&Formblatt1a!V$52)","v":0},{"$f":"INDIRECT($B$7&Formblatt1a!W$52)","v":0},{"$f":"INDIRECT($B$7&Formblatt1a!X$52)","v":0},{"$f":"INDIRECT($B$7&Formblatt1a!S$53)","v":0},{"$f":"INDIRECT($B$7&Formblatt1a!T$53)","v":0},{"$f":"INDIRECT($B$7&Formblatt1a!U$53)","v":0},{"$f":"INDIRECT($B$7&Formblatt1a!V$53)","v":0},{"$f":"INDIRECT($B$7&Formblatt1a!W$53)","v":0},{"$f":"INDIRECT($B$7&Formblatt1a!X$53)","v":0}]
[8,{"$f":"IF(Formblatt1a!A54=\"Vt\",\"Vt\",(IF(Formblatt1a!A54=\"Vb\",\"Vb\",(IF(Formblatt1a!A54=\"Ab\",\"Abl\",(IF(Formblatt1a!A54=\"Ez\",\"Ezl\")))))))","v":"Vt"},0,null,{"$f":"INDIRECT($B$8&Formblatt1a!S$58)","v":0},{"$f":"INDIRECT($B$8&Formblatt1a!T$58)","v":0},{"$f":"INDIRECT($B$8&Formblatt1a!U$58)","v":0},{"$f":"INDIRECT($B$8&Formblatt1a!V$58)","v":0},{"$f":"INDIRECT($B$8&Formblatt1a!W$58)","v":0},{"$f":"INDIRECT($B$8&Formblatt1a!X$58)","v":0},{"$f":"INDIRECT($B$8&Formblatt1a!S$59)","v":0},{"$f":"INDIRECT($B$8&Formblatt1a!T$59)","v":0},{"$f":"INDIRECT($B$8&Formblatt1a!U$59)","v":0},{"$f":"INDIRECT($B$8&Formblatt1a!V$59)","v":0},{"$f":"INDIRECT($B$8&Formblatt1a!W$59)","v":0},{"$f":"INDIRECT($B$8&Formblatt1a!X$59)","v":0},null,null,"TS",0,{"$f":"SUM(U3:U6)","v":0},{"$f":"SUM(V3:V6)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[9,{"$f":"IF(Formblatt1a!A60=\"Vt\",\"Vt\",(IF(Formblatt1a!A60=\"Vb\",\"Vb\",(IF(Formblatt1a!A60=\"Ab\",\"Abl\",(IF(Formblatt1a!A60=\"Ez\",\"Ezl\")))))))","v":"Vt"},0,null,{"$f":"INDIRECT($B$9&Formblatt1a!S$64)","v":0},{"$f":"INDIRECT($B$9&Formblatt1a!T$64)","v":0},{"$f":"INDIRECT($B$9&Formblatt1a!U$64)","v":0},{"$f":"INDIRECT($B$9&Formblatt1a!V$64)","v":0},{"$f":"INDIRECT($B$9&Formblatt1a!W$64)","v":0},{"$f":"INDIRECT($B$9&Formblatt1a!X$64)","v":0},{"$f":"INDIRECT($B$9&Formblatt1a!S$65)","v":0},{"$f":"INDIRECT($B$9&Formblatt1a!T$65)","v":0},{"$f":"INDIRECT($B$9&Formblatt1a!U$65)","v":0},{"$f":"INDIRECT($B$9&Formblatt1a!V$65)","v":0},{"$f":"INDIRECT($B$9&Formblatt1a!W$65)","v":0},{"$f":"INDIRECT($B$9&Formblatt1a!X$65)","v":0}]
[10,{"$f":"IF(Formblatt1a!A66=\"Vt\",\"Vt\",(IF(Formblatt1a!A66=\"Vb\",\"Vb\",(IF(Formblatt1a!A66=\"Ab\",\"Abl\",(IF(Formblatt1a!A66=\"Ez\",\"Ezl\")))))))","v":"Vt"},0,null,{"$f":"INDIRECT($B$10&Formblatt1a!S$70)","v":0},{"$f":"INDIRECT($B$10&Formblatt1a!T$70)","v":0},{"$f":"INDIRECT($B$10&Formblatt1a!U$70)","v":0},{"$f":"INDIRECT($B$10&Formblatt1a!V$70)","v":0},{"$f":"INDIRECT($B$10&Formblatt1a!W$70)","v":0},{"$f":"INDIRECT($B$10&Formblatt1a!X$70)","v":0},{"$f":"INDIRECT($B$10&Formblatt1a!S$71)","v":0},{"$f":"INDIRECT($B$10&Formblatt1a!T$71)","v":0},{"$f":"INDIRECT($B$10&Formblatt1a!U$71)","v":0},{"$f":"INDIRECT($B$10&Formblatt1a!V$71)","v":0},{"$f":"INDIRECT($B$10&Formblatt1a!W$71)","v":0},{"$f":"INDIRECT($B$10&Formblatt1a!X$71)","v":0},null,null,1,null,{"$f":"INDIRECT(TS&Formblatt1a!$S16)","v":0},{"$f":"INDIRECT(TS&Formblatt1a!$S22)","v":0},{"$f":"INDIRECT(TS&Formblatt1a!$S28)","v":0},{"$f":"INDIRECT(TS&Formblatt1a!$S34)","v":0},{"$f":"INDIRECT(TS&Formblatt1a!$S40)","v":0},{"$f":"INDIRECT(TS&Formblatt1a!$S46)","v":0},{"$f":"INDIRECT(TS&Formblatt1a!$S52)","v":0},{"$f":"INDIRECT(TS&Formblatt1a!$S58)","v":0},{"$f":"INDIRECT(TS&Formblatt1a!$S64)","v":0},{"$f":"INDIRECT(TS&Formblatt1a!$S70)","v":0},{"$f":"INDIRECT(TS&Formblatt1a!$S76)","v":0},{"$f":"INDIRECT(TS&Formblatt1a!$S82)","v":0},{"$f":"INDIRECT(TS&Formblatt1a!$S88)","v":0},{"$f":"INDIRECT(TS&Formblatt1a!$S94)","v":0},{"$f":"INDIRECT(TS&Formblatt1a!$S100)","v":0},{"$f":"INDIRECT(TS&Formblatt1a!$S106)","v":0}]
[11,{"$f":"IF(Formblatt1a!A72=\"Vt\",\"Vt\",(IF(Formblatt1a!A72=\"Vb\",\"Vb\",(IF(Formblatt1a!A72=\"Ab\",\"Abl\",(IF(Formblatt1a!A72=\"Ez\",\"Ezl\")))))))","v":"Vt"},0,null,{"$f":"INDIRECT($B$11&Formblatt1a!S$76)","v":0},{"$f":"INDIRECT($B$11&Formblatt1a!T$76)","v":0},{"$f":"INDIRECT($B$11&Formblatt1a!U$76)","v":0},{"$f":"INDIRECT($B$11&Formblatt1a!V$76)","v":0},{"$f":"INDIRECT($B$11&Formblatt1a!W$76)","v":0},{"$f":"INDIRECT($B$11&Formblatt1a!X$76)","v":0},{"$f":"INDIRECT($B$11&Formblatt1a!S$77)","v":0},{"$f":"INDIRECT($B$11&Formblatt1a!T$77)","v":0},{"$f":"INDIRECT($B$11&Formblatt1a!U$77)","v":0},{"$f":"INDIRECT($B$11&Formblatt1a!V$77)","v":0},{"$f":"INDIRECT($B$11&Formblatt1a!W$77)","v":0},{"$f":"INDIRECT($B$11&Formblatt1a!X$77)","v":0},null,null,2,null,{"$f":"INDIRECT(TS&Formblatt1a!$T16)","v":0},{"$f":"INDIRECT(TS&Formblatt1a!$T22)","v":0},{"$f":"INDIRECT(TS&Formblatt1a!$T28)","v":0},{"$f":"INDIRECT(TS&Formblatt1a!$T34)","v":0},{"$f":"INDIRECT(TS&Formblatt1a!$T40)","v":0},{"$f":"INDIRECT(TS&Formblatt1a!$T46)","v":0},{"$f":"INDIRECT(TS&Formblatt1a!$T52)","v":0},{"$f":"INDIRECT(TS&Formblatt1a!$T58)","v":0},{"$f":"INDIRECT(TS&Formblatt1a!$T64)","v":0},{"$f":"INDIRECT(TS&Formblatt1a!$T70)","v":0},{"$f":"INDIRECT(TS&Formblatt1a!$T76)","v":0},{"$f":"INDIRECT(TS&Formblatt1a!$T82)","v":0},{"$f":"INDIRECT(TS&Formblatt1a!$T88)","v":0},{"$f":"INDIRECT(TS&Formblatt1a!$T94)","v":0},{"$f":"INDIRECT(TS&Formblatt1a!$T100)","v":0},{"$f":"INDIRECT(TS&Formblatt1a!$T106)","v":0}]
[12,{"$f":"IF(Formblatt1a!A78=\"Vt\",\"Vt\",(IF(Formblatt1a!A78=\"Vb\",\"Vb\",(IF(Formblatt1a!A78=\"Ab\",\"Abl\",(IF(Formblatt1a!A78=\"Ez\",\"Ezl\")))))))","v":"Vt"},0,null,{"$f":"INDIRECT($B$12&Formblatt1a!S$82)","v":0},{"$f":"INDIRECT($B$12&Formblatt1a!T$82)","v":0},{"$f":"INDIRECT($B$12&Formblatt1a!U$82)","v":0},{"$f":"INDIRECT($B$12&Formblatt1a!V$82)","v":0},{"$f":"INDIRECT($B$12&Formblatt1a!W$82)","v":0},{"$f":"INDIRECT($B$12&Formblatt1a!X$82)","v":0},{"$f":"INDIRECT($B$12&Formblatt1a!S$83)","v":0},{"$f":"INDIRECT($B$12&Formblatt1a!T$83)","v":0},{"$f":"INDIRECT($B$12&Formblatt1a!U$83)","v":0},{"$f":"INDIRECT($B$12&Formblatt1a!V$83)","v":0},{"$f":"INDIRECT($B$12&Formblatt1a!W$83)","v":0},{"$f":"INDIRECT($B$12&Formblatt1a!X$83)","v":0},null,null,3,null,{"$f":"INDIRECT(TS&Formblatt1a!$U16)","v":0},{"$f":"INDIRECT(TS&Formblatt1a!$U22)","v":0},{"$f":"INDIRECT(TS&Formblatt1a!$U28)","v":0},{"$f":"INDIRECT(TS&Formblatt1a!$U34)","v":0},{"$f":"INDIRECT(TS&Formblatt1a!$U40)","v":0},{"$f":"INDIRECT(TS&Formblatt1a!$U46)","v":0},{"$f":"INDIRECT(TS&Formblatt1a!$U52)","v":0},{"$f":"INDIRECT(TS&Formblatt1a!$U58)","v":0},{"$f":"INDIRECT(TS&Formblatt1a!$U64)","v":0},{"$f":"INDIRECT(TS&Formblatt1a!$U70)","v":0},{"$f":"INDIRECT(TS&Formblatt1a!$U76)","v":0},{"$f":"INDIRECT(TS&Formblatt1a!$U82)","v":0},{"$f":"INDIRECT(TS&Formblatt1a!$U88)","v":0},{"$f":"INDIRECT(TS&Formblatt1a!$U94)","v":0},{"$f":"INDIRECT(TS&Formblatt1a!$U100)","v":0},{"$f":"INDIRECT(TS&Formblatt1a!$U106)","v":0}]
[13,{"$f":"IF(Formblatt1a!A84=\"Vt\",\"Vt\",(IF(Formblatt1a!A84=\"Vb\",\"Vb\",(IF(Formblatt1a!A84=\"Ab\",\"Abl\",(IF(Formblatt1a!A84=\"Ez\",\"Ezl\")))))))","v":"Vt"},0,null,{"$f":"INDIRECT($B$13&Formblatt1a!S$88)","v":0},{"$f":"INDIRECT($B$13&Formblatt1a!T$88)","v":0},{"$f":"INDIRECT($B$13&Formblatt1a!U$88)","v":0},{"$f":"INDIRECT($B$13&Formblatt1a!V$88)","v":0},{"$f":"INDIRECT($B$13&Formblatt1a!W$88)","v":0},{"$f":"INDIRECT($B$13&Formblatt1a!X$88)","v":0},{"$f":"INDIRECT($B$13&Formblatt1a!S$89)","v":0},{"$f":"INDIRECT($B$13&Formblatt1a!T$89)","v":0},{"$f":"INDIRECT($B$13&Formblatt1a!U$89)","v":0},{"$f":"INDIRECT($B$13&Formblatt1a!V$89)","v":0},{"$f":"INDIRECT($B$13&Formblatt1a!W$89)","v":0},{"$f":"INDIRECT($B$13&Formblatt1a!X$89)","v":0},null,null,4,null,{"$f":"INDIRECT(TS&Formblatt1a!$V16)","v":0},{"$f":"INDIRECT(TS&Formblatt1a!$V22)","v":0},{"$f":"INDIRECT(TS&Formblatt1a!$V28)","v":0},{"$f":"INDIRECT(TS&Formblatt1a!$V34)","v":0},{"$f":"INDIRECT(TS&Formblatt1a!$V40)","v":0},{"$f":"INDIRECT(TS&Formblatt1a!$V46)","v":0},{"$f":"INDIRECT(TS&Formblatt1a!$V52)","v":0},{"$f":"INDIRECT(TS&Formblatt1a!$V58)","v":0},{"$f":"INDIRECT(TS&Formblatt1a!$V64)","v":0},{"$f":"INDIRECT(TS&Formblatt1a!$V70)","v":0},{"$f":"INDIRECT(TS&Formblatt1a!$V76)","v":0},{"$f":"INDIRECT(TS&Formblatt1a!$V82)","v":0},{"$f":"INDIRECT(TS&Formblatt1a!$V88)","v":0},{"$f":"INDIRECT(TS&Formblatt1a!$V94)","v":0},{"$f":"INDIRECT(TS&Formblatt1a!$V100)","v":0},{"$f":"INDIRECT(TS&Formblatt1a!$V106)","v":0}]
[14,{"$f":"IF(Formblatt1a!A90=\"Vt\",\"Vt\",(IF(Formblatt1a!A90=\"Vb\",\"Vb\",(IF(Formblatt1a!A90=\"Ab\",\"Abl\",(IF(Formblatt1a!A90=\"Ez\",\"Ezl\")))))))","v":"Vt"},0,null,{"$f":"INDIRECT($B$14&Formblatt1a!S$94)","v":0},{"$f":"INDIRECT($B$14&Formblatt1a!T$94)","v":0},{"$f":"INDIRECT($B$14&Formblatt1a!U$94)","v":0},{"$f":"INDIRECT($B$14&Formblatt1a!V$94)","v":0},{"$f":"INDIRECT($B$14&Formblatt1a!W$94)","v":0},{"$f":"INDIRECT($B$14&Formblatt1a!X$94)","v":0},{"$f":"INDIRECT($B$14&Formblatt1a!S$95)","v":0},{"$f":"INDIRECT($B$14&Formblatt1a!T$95)","v":0},{"$f":"INDIRECT($B$14&Formblatt1a!U$95)","v":0},{"$f":"INDIRECT($B$14&Formblatt1a!V$95)","v":0},{"$f":"INDIRECT($B$14&Formblatt1a!W$95)","v":0},{"$f":"INDIRECT($B$14&Formblatt1a!X$95)","v":0},null,null,5,null,{"$f":"INDIRECT(TS&Formblatt1a!$W16)","v":0},{"$f":"INDIRECT(TS&Formblatt1a!$W22)","v":0},{"$f":"INDIRECT(TS&Formblatt1a!$W28)","v":0},{"$f":"INDIRECT(TS&Formblatt1a!$W34)","v":0},{"$f":"INDIRECT(TS&Formblatt1a!$W40)","v":0},{"$f":"INDIRECT(TS&Formblatt1a!$W46)","v":0},{"$f":"INDIRECT(TS&Formblatt1a!$W52)","v":0},{"$f":"INDIRECT(TS&Formblatt1a!$W58)","v":0},{"$f":"INDIRECT(TS&Formblatt1a!$W64)","v":0},{"$f":"INDIRECT(TS&Formblatt1a!$W70)","v":0},{"$f":"INDIRECT(TS&Formblatt1a!$W76)","v":0},{"$f":"INDIRECT(TS&Formblatt1a!$W82)","v":0},{"$f":"INDIRECT(TS&Formblatt1a!$W88)","v":0},{"$f":"INDIRECT(TS&Formblatt1a!$W94)","v":0},{"$f":"INDIRECT(TS&Formblatt1a!$W100)","v":0},{"$f":"INDIRECT(TS&Formblatt1a!$W106)","v":0}]
[15,{"$f":"IF(Formblatt1a!A96=\"Vt\",\"Vt\",(IF(Formblatt1a!A96=\"Vb\",\"Vb\",(IF(Formblatt1a!A96=\"Ab\",\"Abl\",(IF(Formblatt1a!A96=\"Ez\",\"Ezl\")))))))","v":"Vt"},{"$f":"SUM(E15:P15)","v":0},null,{"$f":"INDIRECT($B$15&Formblatt1a!S$100)","v":0},{"$f":"INDIRECT($B$15&Formblatt1a!T$100)","v":0},{"$f":"INDIRECT($B$15&Formblatt1a!U$100)","v":0},{"$f":"INDIRECT($B$15&Formblatt1a!V$100)","v":0},{"$f":"INDIRECT($B$15&Formblatt1a!W$100)","v":0},{"$f":"INDIRECT($B$15&Formblatt1a!X$100)","v":0},{"$f":"INDIRECT($B$15&Formblatt1a!S$101)","v":0},{"$f":"INDIRECT($B$15&Formblatt1a!T$101)","v":0},{"$f":"INDIRECT($B$15&Formblatt1a!U$101)","v":0},{"$f":"INDIRECT($B$15&Formblatt1a!V$101)","v":0},{"$f":"INDIRECT($B$15&Formblatt1a!W$101)","v":0},{"$f":"INDIRECT($B$15&Formblatt1a!X$101)","v":0},null,null,6,null,{"$f":"INDIRECT(TS&Formblatt1a!$X16)","v":0},{"$f":"INDIRECT(TS&Formblatt1a!$X22)","v":0},{"$f":"INDIRECT(TS&Formblatt1a!$X28)","v":0},{"$f":"INDIRECT(TS&Formblatt1a!$X34)","v":0},{"$f":"INDIRECT(TS&Formblatt1a!$X40)","v":0},{"$f":"INDIRECT(TS&Formblatt1a!$X46)","v":0},{"$f":"INDIRECT(TS&Formblatt1a!$X52)","v":0},{"$f":"INDIRECT(TS&Formblatt1a!$X58)","v":0},{"$f":"INDIRECT(TS&Formblatt1a!$X64)","v":0},{"$f":"INDIRECT(TS&Formblatt1a!$X70)","v":0},{"$f":"INDIRECT(TS&Formblatt1a!$X76)","v":0},{"$f":"INDIRECT(TS&Formblatt1a!$X82)","v":0},{"$f":"INDIRECT(TS&Formblatt1a!$X88)","v":0},{"$f":"INDIRECT(TS&Formblatt1a!$X94)","v":0},{"$f":"INDIRECT(TS&Formblatt1a!$X100)","v":0},{"$f":"INDIRECT(TS&Formblatt1a!$X106)","v":0}]
[16,{"$f":"IF(Formblatt1a!A102=\"Vt\",\"Vt\",(IF(Formblatt1a!A102=\"Vb\",\"Vb\",(IF(Formblatt1a!A102=\"Ab\",\"Abl\",(IF(Formblatt1a!A102=\"Ez\",\"Ezl\")))))))","v":"Vt"},{"$f":"SUM(E16:P16)","v":0},null,{"$f":"INDIRECT($B$16&Formblatt1a!S$106)","v":0},{"$f":"INDIRECT($B$16&Formblatt1a!T$106)","v":0},{"$f":"INDIRECT($B$16&Formblatt1a!U$106)","v":0},{"$f":"INDIRECT($B$16&Formblatt1a!V$106)","v":0},{"$f":"INDIRECT($B$16&Formblatt1a!W$106)","v":0},{"$f":"INDIRECT($B$16&Formblatt1a!X$106)","v":0},{"$f":"INDIRECT($B$16&Formblatt1a!S$107)","v":0},{"$f":"INDIRECT($B$16&Formblatt1a!T$107)","v":0},{"$f":"INDIRECT($B$16&Formblatt1a!U$107)","v":0},{"$f":"INDIRECT($B$1&Formblatt1a!V$107)","v":0},{"$f":"INDIRECT($B$16&Formblatt1a!W$107)","v":0},{"$f":"INDIRECT($B$16&Formblatt1a!X$107)","v":0},null,null,7,null,{"$f":"INDIRECT(TS&Formblatt1a!S17)","v":0},{"$f":"INDIRECT(TS&Formblatt1a!S23)","v":0},{"$f":"INDIRECT(TS&Formblatt1a!S29)","v":0},{"$f":"INDIRECT(TS&Formblatt1a!S35)","v":0},{"$f":"INDIRECT(TS&Formblatt1a!$S41)","v":0},{"$f":"INDIRECT(TS&Formblatt1a!S47)","v":0},{"$f":"INDIRECT(TS&Formblatt1a!S53)","v":0},{"$f":"INDIRECT(TS&Formblatt1a!S59)","v":0},{"$f":"INDIRECT(TS&Formblatt1a!S65)","v":0},{"$f":"INDIRECT(TS&Formblatt1a!S71)","v":0},{"$f":"INDIRECT(TS&Formblatt1a!S77)","v":0},{"$f":"INDIRECT(TS&Formblatt1a!S83)","v":0},{"$f":"INDIRECT(TS&Formblatt1a!S89)","v":0},{"$f":"INDIRECT(TS&Formblatt1a!S95)","v":0},{"$f":"INDIRECT(TS&Formblatt1a!S101)","v":0},{"$f":"INDIRECT(TS&Formblatt1a!S107)","v":0}]
["strang",null,"verbrauch",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,null,{"$f":"INDIRECT(TS&Formblatt1a!T17)","v":0},{"$f":"INDIRECT(TS&Formblatt1a!T23)","v":0},{"$f":"INDIRECT(TS&Formblatt1a!T29)","v":0},{"$f":"INDIRECT(TS&Formblatt1a!T35)","v":0},{"$f":"INDIRECT(TS&Formblatt1a!T41)","v":0},{"$f":"INDIRECT(TS&Formblatt1a!T47)","v":0},{"$f":"INDIRECT(TS&Formblatt1a!T53)","v":0},{"$f":"INDIRECT(TS&Formblatt1a!T59)","v":0},{"$f":"INDIRECT(TS&Formblatt1a!T65)","v":0},{"$f":"INDIRECT(TS&Formblatt1a!T71)","v":0},{"$f":"INDIRECT(TS&Formblatt1a!T77)","v":0},{"$f":"INDIRECT(TS&Formblatt1a!T83)","v":0},{"$f":"INDIRECT(TS&Formblatt1a!T89)","v":0},{"$f":"INDIRECT(TS&Formblatt1a!T95)","v":0},{"$f":"INDIRECT(TS&Formblatt1a!T101)","v":0},{"$f":"INDIRECT(TS&Formblatt1a!T107)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9,null,{"$f":"INDIRECT(TS&Formblatt1a!U17)","v":0},{"$f":"INDIRECT(TS&Formblatt1a!U23)","v":0},{"$f":"INDIRECT(TS&Formblatt1a!U29)","v":0},{"$f":"INDIRECT(TS&Formblatt1a!U35)","v":0},{"$f":"INDIRECT(TS&Formblatt1a!U41)","v":0},{"$f":"INDIRECT(TS&Formblatt1a!U47)","v":0},{"$f":"INDIRECT(TS&Formblatt1a!U53)","v":0},{"$f":"INDIRECT(TS&Formblatt1a!U59)","v":0},{"$f":"INDIRECT(TS&Formblatt1a!U65)","v":0},{"$f":"INDIRECT(TS&Formblatt1a!U71)","v":0},{"$f":"INDIRECT(TS&Formblatt1a!U77)","v":0},{"$f":"INDIRECT(TS&Formblatt1a!U83)","v":0},{"$f":"INDIRECT(TS&Formblatt1a!U89)","v":0},{"$f":"INDIRECT(TS&Formblatt1a!U95)","v":0},{"$f":"INDIRECT(TS&Formblatt1a!U101)","v":0},{"$f":"INDIRECT(TS&Formblatt1a!U107)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,null,{"$f":"INDIRECT(TS&Formblatt1a!V17)","v":0},{"$f":"INDIRECT(TS&Formblatt1a!V23)","v":0},{"$f":"INDIRECT(TS&Formblatt1a!V29)","v":0},{"$f":"INDIRECT(TS&Formblatt1a!V35)","v":0},{"$f":"INDIRECT(TS&Formblatt1a!V41)","v":0},{"$f":"INDIRECT(TS&Formblatt1a!V47)","v":0},{"$f":"INDIRECT(TS&Formblatt1a!V53)","v":0},{"$f":"INDIRECT(TS&Formblatt1a!V59)","v":0},{"$f":"INDIRECT(TS&Formblatt1a!V65)","v":0},{"$f":"INDIRECT(TS&Formblatt1a!V71)","v":0},{"$f":"INDIRECT(TS&Formblatt1a!V77)","v":0},{"$f":"INDIRECT(TS&Formblatt1a!V83)","v":0},{"$f":"INDIRECT(TS&Formblatt1a!V89)","v":0},{"$f":"INDIRECT(TS&Formblatt1a!V95)","v":0},{"$f":"INDIRECT(TS&Formblatt1a!V101)","v":0},{"$f":"INDIRECT(TS&Formblatt1a!V107)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,11,null,{"$f":"INDIRECT(TS&Formblatt1a!W17)","v":0},{"$f":"INDIRECT(TS&Formblatt1a!W23)","v":0},{"$f":"INDIRECT(TS&Formblatt1a!W29)","v":0},{"$f":"INDIRECT(TS&Formblatt1a!W35)","v":0},{"$f":"INDIRECT(TS&Formblatt1a!W41)","v":0},{"$f":"INDIRECT(TS&Formblatt1a!W47)","v":0},{"$f":"INDIRECT(TS&Formblatt1a!W53)","v":0},{"$f":"INDIRECT(TS&Formblatt1a!W59)","v":0},{"$f":"INDIRECT(TS&Formblatt1a!W65)","v":0},{"$f":"INDIRECT(TS&Formblatt1a!W71)","v":0},{"$f":"INDIRECT(TS&Formblatt1a!W77)","v":0},{"$f":"INDIRECT(TS&Formblatt1a!W83)","v":0},{"$f":"INDIRECT(TS&Formblatt1a!W89)","v":0},{"$f":"INDIRECT(TS&Formblatt1a!W95)","v":0},{"$f":"INDIRECT(TS&Formblatt1a!W101)","v":0},{"$f":"INDIRECT(TS&Formblatt1a!W107)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,12,null,{"$f":"INDIRECT(TS&Formblatt1a!X17)","v":0},{"$f":"INDIRECT(TS&Formblatt1a!X23)","v":0},{"$f":"INDIRECT(TS&Formblatt1a!X29)","v":0},{"$f":"INDIRECT(TS&Formblatt1a!X35)","v":0},{"$f":"INDIRECT(TS&Formblatt1a!X41)","v":0},{"$f":"INDIRECT(TS&Formblatt1a!X47)","v":0},{"$f":"INDIRECT(TS&Formblatt1a!X53)","v":0},{"$f":"INDIRECT(TS&Formblatt1a!X59)","v":0},{"$f":"INDIRECT(TS&Formblatt1a!X65)","v":0},{"$f":"INDIRECT(TS&Formblatt1a!X71)","v":0},{"$f":"INDIRECT(TS&Formblatt1a!X77)","v":0},{"$f":"INDIRECT(TS&Formblatt1a!X83)","v":0},{"$f":"INDIRECT(TS&Formblatt1a!X89)","v":0},{"$f":"INDIRECT(TS&Formblatt1a!X95)","v":0},{"$f":"INDIRECT(TS&Formblatt1a!X101)","v":0},{"$f":"INDIRECT(TS&Formblatt1a!X107)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(U10:U21)","v":0},{"$f":"IF(SUM(V10:V21)=$U$22,0,SUM(V10:V21))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]

{"sheet":"Einzelgerät","index":4,"n_rows":43,"n_cols":27,"rows_kept":43,"cut":false,"hidden":false,"merged":[[32,18,32,23],[34,9,34,13],[40,9,40,13],[35,14,35,16],[35,18,35,23],[41,18,41,23],[33,18,33,23],[31,7,32,17],[37,7,38,17],[34,14,34,16],[36,14,36,16],[34,18,34,23],[37,18,37,23],[38,18,38,23],[31,18,31,23],[22,18,22,23],[24,18,24,23],[27,18,27,23],[28,18,28,23],[25,18,25,23],[42,14,42,16],[40,14,40,16],[39,18,39,23],[40,18,40,23],[41,14,41,16],[29,18,30,23],[23,18,23,23],[28,0,30,0],[22,2,22,5],[22,7,22,11],[22,14,22,16],[28,2,28,3],[29,1,30,1],[29,2,30,2],[29,3,30,3],[7,1,7,2],[5,11,5,13],[6,11,6,13],[7,11,7,13],[7,14,7,15],[12,1,12,2],[11,1,11,2],[8,1,8,2],[9,1,9,2],[10,1,10,2],[1,4,2,7],[4,1,4,2],[6,1,6,2],[5,1,5,2],[4,11,4,13],[3,11,3,16],[4,14,4,16],[1,11,1,16],[6,14,6,16],[8,14,8,16],[17,1,17,3],[11,11,11,13],[11,14,11,16],[9,14,9,15],[13,1,13,2],[15,1,15,2],[8,11,8,13],[9,11,9,13],[10,11,10,13]]}
[null,"Zusammenstellung der Verlustbeiwerte z"]
["Lfd.","Form- und Ver-",null," ","Anzahl der Formstücke in den Teilstrecken",null,null,null,null,null,null," "]
["Nr.","bindungsstücke",null," "]
[null,"Armaturen",null,"z",1,null,2,null,null,null,null,"Projekt - Daten"]
[1,"Reduzierstück",null,0.4,0,{"$f":"(E5*D5)","v":0},0,{"$f":"(G5*D5)","v":0},null,null,null,"Gerät",null,null,"UWH"]
[3,"Winkel o. Bogen",null,0.7,0,{"$f":"(E6*D6)","v":0},0,0,null,null,null,"Nennwärme- leistung QNL",null,null,19.2,"QNB",{"$f":"O6/O7","v":21.333333333333332}]
[15,"Anschlstück -DN25",null,2,0,0,null,0,null,null,null,"Wirkungsgrad Eta",null,null,0.9]
[null,"EinstutzenGZ>DN25",null,4,null,0,null,0,null,null,null,"Gasart",null,null,"LL",null,{"$f":"IF(O8=\"LL\",8.6,10.6)","v":8.6}]
[17,"Absperrhahn (Kegel) \nDurchgang",null,2,null,0,null,0,null,null,null,"Anschlußwert m³/h",null,null,{"$f":"O6/Q8/O7","v":2.4806201550387597}]
[18,"Absperrhahn (Kegel) Eckform\n(Sicherheitsarmatur)",null,5,0,0,null,0,null,null,null,"Spitzen- volumenstrom m³/h",null,null,{"$f":"O9*Q10","v":2.4806201550387597},null,{"$f":"IF(O5=\"H\",0.621,1)","v":1}]
[19,"Absperrhahn          \n(Kugel) Durchg.",null,0.5,null,0,null,0,null,null,null,"GS Nennvolumen-strom",null,null,{"$f":"I37","v":4},null,"Vgas"]
[20,"Absperrhahn       \n(Kugel) Eckform",null,1.3,0,0,null,0]
[21,"Absperrschieber",null,0.5,0,0,null,0]
[22,"Thermisch auslösende\nAbsperreinrichtung",null,2,0,0,0,0]
[null,"S z in den Teilstrecken"]
[null,null,null,null,null,{"$f":"SUM(F5:F14)","v":0},null,{"$f":"SUM(H5:H14)","v":0}]
[null,null,null,null,null,1,null,2]
[null," "]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"Ermittlung der Rohrdurchmesser ( differenziertes Verfahren )"]
[]
["Projekt :",null," ",null,null,null,"Name:"," ",null,null,null,null,null,"Datum :"," ",null,null,"Blatt - Nr.:","1",null,null,null,null,null,null,null,"Aufrundung der VS-Werte bei Überschreitung von:"]
["Vt","Verteilungsleitungen :",null,null,null,null,"Dp zul < 0,3 mbar",null,null,null,null,null,null,null,null,null," ","Rohrart:","Cu",null,null,null,null,null,null,null,"0,4"]
["Ez","Einzelzuleitung",null,null,null,null,"Dp zul < 1,3 mbar",null,null,null,null,null,null,"1.Gasfamilie",null,null,null,"DIN 2440",{"$f":"IF(S24=\"Stahl\",\"x\",\" \")","v":" "}]
[null," ",null,null,null,null,null,null,null,null,null,null,"x","2.Gasfamilie",null,null,null,"DIN 1786",{"$f":"IF(S24=\"Cu\",\"x\",\" \")","v":"x"}]
[" "," ",null,null,null,null," ",null,null,null,null,null,null,"4.Gasfamilie",null,null,null," "]
[null," "," ",null,null,null,null,null,null,null,null,null,null,null,null,null,null," Gs - Typ","K3  waagerecht"]
["Leitungsart",1,2,null,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,null,null,null,null,null,1]
[null,"TS","Geräte- art","An- zahl","S VA  Geräte","fG         Geräte","___","VS","l","DN","v","R","R x l","Sz","Z","DH","DpH","DpTS","Kontrolle\nSDpTS\n< pzul"]
[null,null,null,null,"m³/h","___","m³/h","m³/h","m","___","m/s","mbar m","mbar","___","mbar","m","mbar","mbar"]
["Vt",null,"H",{"$f":"IF($O$5=\"H\",1,0)","v":0},{"$f":"IF(D32>0,$O$9,0)","v":0},{"$f":"IF(D32>0,$Q$10,0)","v":0},{"$f":"$E32*$F32","v":0},{"$f":"IF(((J34<25)*AND(J34>0)),\"Einige GVU's verlangen in der VT mindestens DN 25 ! ... Bitte überprüfen !\",0)","v":0}]
["GS",null,"DWH",{"$f":"IF($O$5=\"DWH\",1,0)","v":0},{"$f":"IF(D33>0,$O$9,0)","v":0},{"$f":"IF(D33>0,$Q$10,0)","v":0},0]
[null,1,"RH",{"$f":"IF($O$5=\"RH\",1,0)","v":0},{"$f":"IF(D34>0,$O$9,0)","v":0},0,0,{"$f":"O10","v":2.4806201550387597},0,null,{"$f":"IF(AND(J34<>0,OR($S$24=\"Cu\",$S$24=\"Stahl\")),IF($S$24=\"Cu\",VLOOKUP(H34+$AA$24,Kupfer!$A$5:$Q$55,VLOOKUP(J34,Gewinde!$S$8:$V$15,4)),VLOOKUP(H34+$AA$24,Gewinde!$A$5:$Q$55,VLOOKUP(J34,Gewinde!$T$8:$V$15,3))),0)","v":0},{"$f":"IF(AND(J34<>0,OR($S$24=\"Cu\",$S$24=\"Stahl\")),IF($S$24=\"Cu\",VLOOKUP(H34+$AA$24,Kupfer!$A$5:$Q$55,VLOOKUP(J34,Gewinde!$S$8:$V$15,3)),VLOOKUP(H34+$AA$24,Gewinde!$A$5:$Q$55,VLOOKUP(J34,Gewinde!$T$8:$V$15,2))),0)","v":0},{"$f":"(L34*I34)","v":0},{"$f":"F16","v":0},{"$f":"0.003972*K34^2*N34","v":0},0,{"$f":"IF(P34=0,0,P34*(-0.04))","v":0},{"$f":"IF(AND(J34>0,K34<1),\"NIX\",M34+O34+Q34)","v":0},{"$f":"IF((R34>0.399),\"Vt > 0,399 mbar\",0)","v":0},null,null,null,null,null,1]
[null,null,"UWH",{"$f":"IF($O$5=\"UWH\",1,0)","v":1},2.4806201550387597,1,2.4806201550387597,"S VA","GS",{"$f":"IF($AD$10=2,\"Dimensionskontrolle !\",\"\")","v":""}]
[null,null,"G2",{"$f":"IF($O$5=\"G2\",1,0)","v":0},0,0,0,{"$f":"IF(A34=\"GS\",\"VA\",\"\")","v":""}," ",null,null,null,null,null,null,null,null,{"$f":"Strangverbrauch!U22","v":0}," "]
[null,null,null,null,0,0,null,{"$f":"IF(A33=\"GS\",SUM(E32:E37),\"\")","v":2.4806201550387597},{"$f":"IF(A33=\"GS\",(IF(H37<=2.09,2.5,IF(AND(H37>=2.1,H37<=3.29),4,IF(AND(H37>=3.3,H37<=4.89),6,IF(AND(H37>=4.9,H37<=8.09),10,IF(AND(H37>=8.1,H37<=16),16,IF(H37>=16,\">16\"))))))),\"\")","v":4},null,null,null,null,null,null,null,null,null,0,0,0,0,0,1]
["Ez",null,"H",{"$f":"D32","v":0},0,0,0]
[" ",null,"DWH",{"$f":"D33","v":0},0,0,0]
[" ",2,"RH",{"$f":"D34","v":0},0,0,0,{"$f":"H34","v":2.4806201550387597},0,0,{"$f":"IF(AND(J40<>0,OR($S$24=\"Cu\",$S$24=\"Stahl\")),IF($S$24=\"Cu\",VLOOKUP(H40+$AA$24,Kupfer!$A$5:$Q$55,VLOOKUP(J40,Gewinde!$S$8:$V$15,4)),VLOOKUP(H40+$AA$24,Gewinde!$A$5:$Q$55,VLOOKUP(J40,Gewinde!$T$8:$V$15,3))),0)","v":0},{"$f":"IF(AND(J40<>0,OR($S$24=\"Cu\",$S$24=\"Stahl\")),IF($S$24=\"Cu\",VLOOKUP(H40+$AA$24,Kupfer!$A$5:$Q$55,VLOOKUP(J40,Gewinde!$S$8:$V$15,3)),VLOOKUP(H40+$AA$24,Gewinde!$A$5:$Q$55,VLOOKUP(J40,Gewinde!$T$8:$V$15,2))),0)","v":0},{"$f":"(L40*I40)","v":0},{"$f":"H16","v":0},{"$f":"0.003972*K40^2*N40","v":0},0,{"$f":"IF(P40=0,0,P40*(-0.04))","v":0},{"$f":"IF(AND(J40>0,K40<1),\"NIX\",M40+O40+Q40)","v":0},{"$f":"IF((R40>1.399),\"Ez > 1,399 mbar\",0)","v":0},null,null,null,null,null,2]
[null,null,"UWH",{"$f":"D35","v":1},2.4806201550387597,1,2.4806201550387597,0,null,{"$f":"IF($AD$10=2,\"Dimensionskontrolle !\",\"\")","v":""}]
[null,null,"G2",{"$f":"D36","v":0},0,0,0,null,null,null,null,null,null,null,null,null,null,{"$f":"Strangverbrauch!V22","v":0}," "]
[null,null,null,null,0,0,null,null,null,null,null,null,null,null,{"$f":"IF(R43>0,\"Druckverlust bis zur HAE ->\",0)","v":0},null,null,{"$f":"R34+R40","v":0},{"$f":"Y40","v":2},0,0,0,0,1]

{"sheet":"Anschlußw","index":5,"n_rows":35,"n_cols":7,"rows_kept":35,"cut":false,"hidden":false,"merged":[]}
[null,null,null,"         Anschlußwert VA (m³/h) in Abhängikkeit"]
[null,null,"Nenn -","           des Betriebsheizwertes Hi,B (kWh/m³)"]
[null,"Gasgerät","wärme -","1. Gasfamilie","           2. Gasfamilie",null,"4. Gasfamilie"]
[null,null,"leistung",null,"Gruppe LL (L)","Gruppe E (H)"]
[null,null,"QNL (kW)","Hi,B =","Hi,B =","Hi,B =","Hi,B ="]
[null,null,null,"4,2 kWh/m³","8,6 kWh/m³","10,6 kWh/m³","6,3 kWh/m³"]
[null,"Gasherd","4fl.",3,1.5,1.2,2]
[null,"Freie Gassteckdose G2",14,4,1.9,1.6,2.6]
[null,"Gas-Durchlaufwasserheizer",17.5,5,2.4,2,3.3]
[null," ",22.7,6.5,3.2,2.6,4.3]
[null,null,27.9,8,3.9,3.2,5.3]
[null,"Gas-Vorrats-              80l",6.9,1.9,0.9,0.7,1.3]
[null,"wasserheizer           120l",7.6,2.1,1,0.8,1.5]
[null,"                                 150l",8.3000000000000007,2.2999999999999998,1.1000000000000001,0.9,1.6]
[null,"Wasserinhalt:          190l",8.6999999999999993,2.4,1.2,1,1.7]
[null,"                                 200l",10.5,2.9,1.4,1.2,1.9]
[null,null,3.5,1,0.5,0.4,0.7]
[null,"Gas-Raumheizer",4.7,1.3,0.6,0.5,0.9]
[null,null,7,2,1,0.8,1.3]
[null,null,9.3000000000000007,2.7,1.3,1.1000000000000001,1.8]
[null,null,11.6,3.3,1.6,1.3,2.2000000000000002]
[null,null,5,1.4,0.7,0.6,1]
[null,"Gas-Umlaufwasserheizer,",6,1.7,0.8,0.7,1.1000000000000001]
[null,null,7,2,1,0.8,1.3]
[null,"Gas-Kombiwasserheizer;",8,2.2999999999999998,1.1000000000000001,0.9,1.5]
[null,null,9,2.6,1.3,1,1.7]
[null,"Gas-Heizkessel",9.3000000000000007,2.7,1.3,1.1000000000000001,1.8]
[null,null,10,2.9,1.4,1.1000000000000001,1.9]
[null,null,11,3.1,1.5,1.2,2.1]
[null,null,14,4,1.9,1.6,2.6]
[null,null,17.5,5,2.4,2,3.3]
[null,null,18.600000000000001,5.3,2.6,2.1,3.5]
[null,null,20.9,6,2.9,2.4,4]
[null,null,23.3,6.7,3.2,2.6,4.4000000000000004]
[null,null,30,8.6,4.2,3.4,5.7]

{"sheet":"Gleichzeitig","index":6,"n_rows":52,"n_cols":11,"rows_kept":52,"cut":false,"hidden":false,"merged":[]}
[null,"Anzahl","           Gerätebezogene Gleichzeitigkeitsfaktoren"]
[null,"der Gasgeräte","H","DWH / G2","RH","UWH"]
[null,1,0.621,1,1,1,null,null,null,"Tabelle Zuordnung Bezeichnung zu Index:"]
[null,2,0.44800000000000001,0.60699999999999998,0.8,0.88300000000000001]
[null,3,0.371,0.45600000000000002,0.70299999999999996,0.82199999999999995,null,null,null,"H",2]
[null,4,0.23499999999999999,0.373,0.64100000000000001,0.78200000000000003,null,null,null,"DWH",3]
[null,5,0.29399999999999998,0.32,0.59699999999999998,0.752,null,null,null,"RH",4]
[null,6,0.27100000000000002,0.28299999999999997,0.56399999999999995,0.72899999999999998,null,null,null,"UWH",5]
[null,7,0.253,0.255,0.53700000000000003,0.71,null,null,null," "," "]
[null,8,0.23899999999999999,0.23400000000000001,0.51500000000000001,0.69399999999999995]
[null,9,0.22700000000000001,0.217,0.496,0.68]
[null,10,0.217,0.20200000000000001,0.48,0.66800000000000004]
[null,11,0.20799999999999999,0.191,0.46600000000000003,0.65700000000000003]
[null,12,0.20100000000000001,0.18,0.45400000000000001,0.64800000000000002]
[null,13,0.19400000000000001,0.17199999999999999,0.443,0.63900000000000001]
[null,14,0.188,0.16400000000000001,0.432,0.63100000000000001]
[null,15,0.183,0.157,0.42299999999999999,0.624]
[null,16,0.17799999999999999,0.151,0.41499999999999998,0.61699999999999999]
[null,17,0.17299999999999999,0.14599999999999999,0.40699999999999997,0.61099999999999999]
[null,18,0.16900000000000001,0.14099999999999999,0.4,0.60499999999999998]
[null,19,0.16600000000000001,0.13700000000000001,0.39400000000000002,0.59899999999999998]
[null,20,0.16200000000000001,0.13300000000000001,0.38700000000000001,0.59399999999999997]
[null,21,0.159,0.129,0.38200000000000001,0.59]
[null,22,0.156,0.125,0.376,0.58499999999999996]
[null,23,0.153,0.122,0.371,0.58099999999999996]
[null,24,0.151,0.11899999999999999,0.36599999999999999,0.57699999999999996]
[null,25,0.14799999999999999,0.11700000000000001,0.36199999999999999,0.57299999999999995]
[null,26,0.14599999999999999,0.114,0.35699999999999998,0.56899999999999995]
[null,27,0.14399999999999999,0.112,0.35299999999999998,0.56599999999999995]
[null,28,0.14199999999999999,0.11,0.34899999999999998,0.56200000000000006]
[null,29,0.14000000000000001,0.108,0.34599999999999997,0.55900000000000005]
[null,30,0.13800000000000001,0.106,0.34200000000000003,0.55600000000000005]
[null,31,0.13600000000000001,0.104,0.33900000000000002,0.55300000000000005]
[null,32,0.13400000000000001,0.10199999999999999,0.33600000000000002,0.55000000000000004]
[null,33,0.13300000000000001,0.1,0.33200000000000002,0.54700000000000004]
[null,34,0.13100000000000001,9.9000000000000005E-2,0.32900000000000001,0.54500000000000004]
[null,35,0.13,9.7000000000000003E-2,0.32700000000000001,0.54200000000000004]
[null,36,0.128,9.6000000000000002E-2,0.32400000000000001,0.54]
[null,37,0.127,9.5000000000000001E-2,0.32100000000000001,0.53700000000000003]
[null,38,0.126,9.2999999999999999E-2,0.31900000000000001,0.53500000000000003]
[null,39,0.125,9.1999999999999998E-2,0.316,0.53300000000000003]
[null,40,0.123,9.0999999999999998E-2,0.314,0.53]
[null,41,0.122,0.09,0.311,0.52800000000000002]
[null,42,0.121,8.8999999999999996E-2,0.309,0.52600000000000002]
[null,43,0.12,8.7999999999999995E-2,0.307,0.52400000000000002]
[null,44,0.11899999999999999,8.6999999999999994E-2,0.30499999999999999,0.52200000000000002]
[null,45,0.11799999999999999,8.5999999999999993E-2,0.30299999999999999,0.52]
[null,46,0.11700000000000001,8.5000000000000006E-2,0.30099999999999999,0.51800000000000002]
[null,47,0.11600000000000001,8.4000000000000005E-2,0.29899999999999999,0.51700000000000002]
[null,48,0.115,8.3000000000000004E-2,0.29699999999999999,0.51500000000000001]
[null,49,0.114,8.2000000000000003E-2,0.29499999999999998,0.51300000000000001]
[null,50,0.114,8.2000000000000003E-2,0.29299999999999998,0.51200000000000001]

{"sheet":"Kupfer","index":7,"n_rows":55,"n_cols":17,"rows_kept":55,"cut":false,"hidden":false,"merged":[]}
[null,"Fließgeschwindigkeit und Rohrreibungsdruckgefälle für Cu-Rohre nach DIN 1786"]
[null,"  12x1 (DN10)",null,"  15x1 (DN12)",null,"  18x1 (DN15)",null,"  22x1 (DN20)",null,"28x1,5 (DN25)",null," 35x1,5 (DN32)",null," 42x1,5 (DN40)",null," 54x2,0 (DN50)"]
["Vs","v","R","v","R","v","R","v","R","v","R","v","R","v","R","v","R"]
["m³/h","m/s","mbar/m","m/s","mbar/m","m/s","mbar/m","m/s","mbar/m","m/s","mbar/m","m/s","mbar/m","m/s","mbar/m","m/s","mbar/m"]
[0.5,1.75,0.15,1.05,3.5000000000000003E-2]
[1,3.5,0.23710000000000001,2.1,4.3799999999999999E-2,1.4,1.9099999999999999E-2,0.9,7.7999999999999996E-3]
[1.5,5.3,0.47499999999999998,3.1,0.13689999999999999,2.1,5.1400000000000001E-2,1.3,1.17E-2]
[2,7.1,0.78190000000000004,4.2,0.22420000000000001,2.8,8.3799999999999999E-2,1.8,2.93E-2,1.1000000000000001,6.4000000000000003E-3]
[2.5,8.8000000000000007,1.1549,5.2,0.32950000000000002,3.5,0.12280000000000001,2.2000000000000002,4.2700000000000002E-2,1.4,1.49E-2]
[3,10.6,1.5913999999999999,6.3,0.45240000000000002,4.0999999999999996,0.16800000000000001,2.7,5.8299999999999998E-2,1.7,2.0400000000000001E-2,1,6.4000000000000003E-3]
[3.5,12.4,2.0907,7.8,0.59160000000000001,4.8,0.21959999999999999,3.1,7.5999999999999998E-2,2,2.6499999999999999E-2,1.2,8.3000000000000001E-3]
[4,14.2,2.6503999999999999,8.4,0.74790000000000001,5.5,0.27689999999999998,3.5,9.5699999999999993E-2,2.2999999999999998,3.3300000000000003E-2,1.4,1.04E-2]
[4.5,null,null,null,null,6.2,0.3402,4,0.1173,2.5,4.07E-2,1.6,1.2699999999999999E-2]
[5,null,null,null,null,null,null,4.4000000000000004,0.14099999999999999,2.8,4.8800000000000003E-2,1.7,1.52E-2,1.2,6.0000000000000001E-3]
[5.5,null,null,null,null,null,null,4.9000000000000004,0.1663,3.1,5.7500000000000002E-2,1.9,1.7899999999999999E-2,1.3,7.0000000000000001E-3]
[6,null,null,null,null,null,null,5.3,0.19339999999999999,3.4,6.6900000000000001E-2,2.1,2.07E-2,1.4,8.0999999999999996E-3]
[6.5,null,null,null,null,null,null,5.7,0.22239999999999999,3.7,7.6799999999999993E-2,2.2000000000000002,2.3800000000000002E-2,1.5,9.2999999999999992E-3]
[7,null,null,null,null,null,null,6.2,0.25359999999999999,4,8.7400000000000005E-2,2.4,2.7099999999999999E-2,1.6,1.06E-2,1,3.3E-3]
[7.5,null,null,null,null,null,null,6.6,0.2858,4.2,9.8500000000000004E-2,2.6,3.0499999999999999E-2,1.7,1.1900000000000001E-2,1.1000000000000001,3.7000000000000002E-3]
[8,null,null,null,null,null,null,7.1,0.32029999999999997,4.5,0.1103,2.8,3.4099999999999998E-2,1.9,1.3299999999999999E-2,1.1000000000000001,4.1000000000000003E-3]
[8.5,null,null,null,null,null,null,null,null,4.8,0.1225,2.9,3.78E-2,2,1.4800000000000001E-2,1.2,4.5999999999999999E-3]
[9,null,null,null,null,null,null,null,null,5.0999999999999996,0.13539999999999999,3.1,4.1799999999999997E-2,2.1,1.6299999999999999E-2,1.3,5.1000000000000004E-3]
[9.5,null,null,null,null,null,null,null,null,5.4,0.14879999999999999,3.3,4.5900000000000003E-2,2.2000000000000002,1.7899999999999999E-2,1.3,5.4999999999999997E-3]
[10,null,null,null,null,null,null,null,null,5.7,0.16289999999999999,3.5,5.0099999999999999E-2,2.2999999999999998,1.9599999999999999E-2,1.4,6.0000000000000001E-3]
[10.5,null,null,null,null,null,null,null,null,5.9,0.1774,3.6,5.4600000000000003E-2,2.4,2.1299999999999999E-2,1.5,6.6E-3]
[11,null,null,null,null,null,null,null,null,6.2,0.1925,3.8,5.9200000000000003E-2,2.6,2.3099999999999999E-2,1.6,7.1000000000000004E-3]
[11.5,null,null,null,null,null,null,null,null,6.5,0.20810000000000001,4,6.4000000000000001E-2,2.7,2.5000000000000001E-2,1.6,7.7000000000000002E-3]
[12,null,null,null,null,null,null,null,null,6.8,0.2243,4.0999999999999996,6.8900000000000003E-2,2.8,2.69E-2,1.7,8.3000000000000001E-3]
[12.5,null,null,null,null,null,null,null,null,7.1,0.24110000000000001,4.3,7.4099999999999999E-2,2.9,2.8899999999999999E-2,1.8,8.8999999999999999E-3]
[13,null,null,null,null,null,null,null,null,null,null,4.5,7.9299999999999995E-2,3,3.09E-2,1.8,9.4999999999999998E-3]
[13.5,null,null,null,null,null,null,null,null,null,null,4.7,8.48E-2,3.1,3.3000000000000002E-2,1.9,1.01E-2]
[14,null,null,null,null,null,null,null,null,null,null,4.8,9.0399999999999994E-2,3.3,3.5099999999999999E-2,2,1.0800000000000001E-2]
[14.5,null,null,null,null,null,null,null,null,null,null,5,9.6000000000000002E-2,3.4,3.7400000000000003E-2,2.1,1.15E-2]
[15,null,null,null,null,null,null,null,null,null,null,5.2,0.1019,3.5,3.9600000000000003E-2,2.1,1.2200000000000001E-2]
[15.5,null,null,null,null,null,null,null,null,null,null,5.4,0.1079,3.6,4.2000000000000003E-2,2.2000000000000002,1.29E-2]
[16,null,null,null,null,null,null,null,null,null,null,5.5,0.1142,3.7,4.4400000000000002E-2,2.2999999999999998,1.3599999999999999E-2]
[16.5,null,null,null,null,null,null,null,null,null,null,5.7,0.1206,3.8,4.6899999999999997E-2,2.2999999999999998,1.44E-2]
[17,null,null,null,null,null,null,null,null,null,null,5.9,0.127,4,4.9399999999999999E-2,2.4,1.5100000000000001E-2]
[17.5,null,null,null,null,null,null,null,null,null,null,6,0.13370000000000001,4.0999999999999996,5.1900000000000002E-2,2.5,1.5900000000000001E-2]
[18,null,null,null,null,null,null,null,null,null,null,6.2,0.1406,4.2,5.45E-2,2.5,1.67E-2]
[18.5,null,null,null,null,null,null,null,null,null,null,6.4,0.1474,4.3,5.7299999999999997E-2,2.6,1.7500000000000002E-2]
[19,null,null,null,null,null,null,null,null,null,null,6.6,0.15459999999999999,4.4000000000000004,5.9900000000000002E-2,2.7,1.84E-2]
[19.5,null,null,null,null,null,null,null,null,null,null,6.7,0.16200000000000001,4.5,6.2799999999999995E-2,2.8,1.9199999999999998E-2]
[20,null,null,null,null,null,null,null,null,null,null,6.9,0.16930000000000001,4.7,6.5699999999999995E-2,2.8,2.01E-2]
[21,null,null,null,null,null,null,null,null,null,null,null,null,4.9000000000000004,7.1499999999999994E-2,3,2.1899999999999999E-2]
[22,null,null,null,null,null,null,null,null,null,null,null,null,5.0999999999999996,7.7600000000000002E-2,3.1,2.3699999999999999E-2]
[23,null,null,null,null,null,null,null,null,null,null,null,null,5.3,8.3900000000000002E-2,3.3,2.5600000000000001E-2]
[24,null,null,null,null,null,null,null,null,null,null,null,null,5.6,9.0499999999999997E-2,3.4,2.76E-2]
[25,null,null,null,null,null,null,null,null,null,null,null,null,5.8,9.7299999999999998E-2,3.5,2.9600000000000001E-2]
[26,null,null,null,null,null,null,null,null,null,null,null,null,6,0.1043,3.7,3.1699999999999999E-2]
[27,null,null,null,null,null,null,null,null,null,null,null,null,6.3,0.1115,3.8,3.39E-2]
[28,null,null,null,null,null,null,null,null,null,null,null,null,6.5,0.1188,4,3.6200000000000003E-2]
[29,null,null,null,null,null,null,null,null,null,null,null,null,6.7,0.12640000000000001,4.0999999999999996,3.85E-2]
[30,null,null,null,null,null,null,null,null,null,null,null,null,7,0.13439999999999999,4.2,4.0899999999999999E-2]
[31,null,null,null,null,null,null,null,null,null,null,null,null,7.2,0.14219999999999999,4.4000000000000004,4.3200000000000002E-2]

{"sheet":"Gewinde","index":8,"n_rows":55,"n_cols":22,"rows_kept":55,"cut":false,"hidden":false,"merged":[]}
[null,null,null,"Fließgeschwindigkeit und Rohrreibungsdruckgefälle für Rohre nach DIN 2440"]
[null,"     DN 15",null,"     DN 20",null,"     DN 25",null,"     DN 32",null,"     DN 40",null,"     DN 50",null,"     DN 65",null,"     DN 80"]
["VS","v","R","v","R","v","R","v","R","v","R","v","R","v","R","v","R"]
["m³/h","m/s","mbar/m","m/s","mbar/m","m/s","mbar/m","m/s","mbar/m","m/s","mbar/m","m/s","mbar/m","m/s","mbar/m","m/s","mbar/m"]
[0.5,0.7,1.4999999999999999E-2]
[1,1.4,1.9199999999999998E-2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tabelle für Zuordnung der DN zum Index:"]
[1.5,2.1,7.3200000000000001E-2,1.1000000000000001,8.6999999999999994E-3,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cu","Stahl","R-Wert","Geschw. v"]
[2,2.8,0.12559999999999999,1.5,2.69E-2,null,null,null,null,null,null,null,null,null,null,null,null,null,10,15,3,2]
[2.5,3.5,0.19159999999999999,1.9,4.0500000000000001E-2,1.2,1.26E-2,null,null,null,null,null,null,null,null,null,null,null,12,20,5,4]
[3,4.0999999999999996,0.27160000000000001,2.2999999999999998,5.7000000000000002E-2,1.4,1.7600000000000001E-2,null,null,null,null,null,null,null,null,null,null,null,15,25,7,6]
[3.5,4.8,0.36509999999999998,2.7,7.6200000000000004E-2,1.7,2.3400000000000001E-2,null,null,null,null,null,null,null,null,null,null,null,20,32,9,8]
[4,5.5,0.4723,3,9.8000000000000004E-2,1.9,2.9899999999999999E-2,1.1000000000000001,7.4000000000000003E-3,null,null,null,null,null,null,null,null,null,25,40,11,10]
[4.5,null,null,3.4,0.1225,2.2000000000000002,3.73E-2,1.2,9.1000000000000004E-3,null,null,null,null,null,null,null,null,null,32,50,13,12]
[5,null,null,3.8,0.1497,2.4,4.5400000000000003E-2,1.4,1.11E-2,1,5.1999999999999998E-3,null,null,null,null,null,null,null,40,65,15,14]
[5.5,null,null,4.2,0.18,2.6,5.4300000000000001E-2,1.5,1.32E-2,1.1000000000000001,6.1000000000000004E-3,null,null,null,null,null,null,null,50,80,17,16]
[6,null,null,4.5,0.2127,2.9,6.4000000000000001E-2,1.6,1.55E-2,1.2,7.1999999999999998E-3]
[6.5,null,null,4.9000000000000004,0.24809999999999999,3.1,7.4499999999999997E-2,1.8,1.7999999999999999E-2,1.3,8.3000000000000001E-3]
[7,null,null,5.3,0.28620000000000001,3.3,8.5699999999999998E-2,1.9,2.06E-2,1.4,9.4999999999999998E-3]
[7.5,null,null,5.7,0.32700000000000001,3.6,9.7799999999999998E-2,2.1,2.35E-2,1.5,1.0800000000000001E-2]
[8,null,null,null,null,3.8,0.1108,2.2000000000000002,2.6499999999999999E-2,1.6,1.2200000000000001E-2,1,3.7000000000000002E-3]
[8.5,null,null,null,null,4.0999999999999996,0.1244,2.2999999999999998,2.9600000000000001E-2,1.7,1.37E-2,1.1000000000000001,4.1000000000000003E-3]
[9,null,null,null,null,4.3,0.13880000000000001,2.5,3.3000000000000002E-2,1.8,1.52E-2,1.1000000000000001,4.5999999999999999E-3]
[9.5,null,null,null,null,4.5,0.154,2.6,3.6499999999999998E-2,1.9,1.6799999999999999E-2,1.2,5.0000000000000001E-3]
[10,null,null,null,null,4.8,0.17,2.7,4.02E-2,2,1.8499999999999999E-2,1.3,5.5999999999999999E-3]
[10.5,null,null,null,null,5,0.1867,2.9,4.41E-2,2.1,2.0199999999999999E-2,1.3,6.1000000000000004E-3]
[11,null,null,null,null,5.3,0.20419999999999999,3,4.82E-2,2.2000000000000002,2.2100000000000002E-2,1.4,6.6E-3]
[11.5,null,null,null,null,5.5,0.2225,3.2,5.2400000000000002E-2,2.2999999999999998,2.4E-2,1.4,7.1999999999999998E-3]
[12,null,null,null,null,5.7,0.24160000000000001,3.3,5.6800000000000003E-2,2.4,2.5999999999999999E-2,1.5,7.7999999999999996E-3]
[12.5,null,null,null,null,6,0.26140000000000002,3.4,6.1400000000000003E-2,2.5,2.8000000000000001E-2,1.6,8.3999999999999995E-3]
[13,null,null,null,null,null,null,3.6,6.6299999999999998E-2,2.6,0.03,1.6,8.9999999999999993E-3]
[13.5,null,null,null,null,null,null,3.7,7.1300000000000002E-2,2.7,3.2500000000000001E-2,1.7,9.7000000000000003E-3,1,2.5999999999999999E-3]
[14,null,null,null,null,null,null,3.8,7.6399999999999996E-2,2.8,3.4799999999999998E-2,1.8,1.04E-2,1,2.8E-3]
[14.5,null,null,null,null,null,null,4,8.1699999999999995E-2,2.9,3.7199999999999997E-2,1.8,1.11E-2,1.1000000000000001,3.0000000000000001E-3]
[15,null,null,null,null,null,null,4.0999999999999996,8.72E-2,3,3.9600000000000003E-2,1.9,1.18E-2,1.1000000000000001,3.2000000000000002E-3]
[15.5,null,null,null,null,null,null,4.3,9.2799999999999994E-2,3.1,4.2200000000000001E-2,2,1.2500000000000001E-2,1.2,3.3999999999999998E-3]
[16,null,null,null,null,null,null,4.4000000000000004,9.8699999999999996E-2,3.2,4.48E-2,2,1.3299999999999999E-2,1.2,3.5999999999999999E-3]
[16.5,null,null,null,null,null,null,4.5,0.1047,3.3,4.7500000000000001E-2,2.1,1.41E-2,1.2,3.8E-3]
[17,null,null,null,null,null,null,4.7,0.1109,3.4,0.05,2.1,1.49E-2,1.3,4.0000000000000001E-3]
[17.5,null,null,null,null,null,null,4.8,0.1172,3.5,5.3199999999999997E-2,2.2000000000000002,1.5699999999999999E-2,1.3,4.1999999999999997E-3]
[18,null,null,null,null,null,null,4.9000000000000004,0.12379999999999999,3.6,5.62E-2,2.2999999999999998,1.66E-2,1.3,4.4000000000000003E-3]
[18.5,null,null,null,null,null,null,5.0999999999999996,0.1305,3.7,5.8999999999999997E-2,2.2999999999999998,1.7500000000000002E-2,1.4,4.7000000000000002E-3,1,2.0999999999999999E-3]
[19,null,null,null,null,null,null,5.2,0.13739999999999999,3.8,6.2300000000000001E-2,2.4,1.84E-2,1.4,4.8999999999999998E-3,1,2.2000000000000001E-3]
[19.5,null,null,null,null,null,null,5.4,0.1444,3.9,6.5500000000000003E-2,2.5,1.9300000000000001E-2,1.5,5.1000000000000004E-3,1.1000000000000001,2.3E-3]
[20,null,null,null,null,null,null,5.5,0.1517,4,6.8699999999999997E-2,2.5,2.0199999999999999E-2,1.5,5.4000000000000003E-3,1.1000000000000001,2.3999999999999998E-3]
[21,null,null,null,null,null,null,5.8,0.16669999999999999,4.3,7.5399999999999995E-2,2.6,2.2200000000000001E-2,1.6,5.8999999999999999E-3,1.1000000000000001,2.5999999999999999E-3]
[22,null,null,null,null,null,null,null,null,4.5,8.2500000000000004E-2,2.8,2.4199999999999999E-2,1.6,6.4000000000000003E-3,1.2,2.8999999999999998E-3]
[23,null,null,null,null,null,null,null,null,4.7,8.9800000000000005E-2,2.9,2.63E-2,1.7,7.0000000000000001E-3,1.2,3.0999999999999999E-3]
[24,null,null,null,null,null,null,null,null,4.9000000000000004,9.7500000000000003E-2,3,2.8500000000000001E-2,1.8,7.6E-3,1.3,3.3999999999999998E-3]
[25,null,null,null,null,null,null,null,null,5.0999999999999996,0.1055,3.1,3.0800000000000001E-2,1.9,8.2000000000000007E-3,1.4,3.5999999999999999E-3]
[26,null,null,null,null,null,null,null,null,5.3,0.1138,3.3,3.3300000000000003E-2,1.9,8.8000000000000005E-3,1.4,3.8999999999999998E-3]
[27,null,null,null,null,null,null,null,null,5.5,0.12239999999999999,3.4,3.5799999999999998E-2,2,9.4000000000000004E-3,1.5,4.1999999999999997E-3]
[28,null,null,null,null,null,null,null,null,5.7,0.1313,3.5,3.8300000000000001E-2,2.1,1.01E-2,1.5,4.4999999999999997E-3]
[29,null,null,null,null,null,null,null,null,5.9,0.14050000000000001,3.7,4.1000000000000002E-2,2.2000000000000002,1.0800000000000001E-2,1.6,4.7999999999999996E-3]
[30,null,null,null,null,null,null,null,null,null,null,3.8,4.3700000000000003E-2,2.2000000000000002,1.15E-2,1.6,5.1000000000000004E-3]
[31,null,null,null,null,null,null,null,null,null,null,3.9,4.6600000000000003E-2,2.2999999999999998,1.12E-2,1.7,5.4000000000000003E-3]