{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Mutitunnel","Durchverbindung_in Arbeit","Daten"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":0,"comments":1,"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":"Mutitunnel","index":0,"n_rows":50,"n_cols":20,"rows_kept":50,"cut":false,"hidden":false,"merged":[[27,5,39,5],[27,6,39,8],[16,5,17,5],[16,6,16,8],[17,6,17,8],[21,5,22,5],[21,6,21,8],[22,6,22,8]]}
[null,null,null,null,null,null,null,null,null,null,"Informationen:","Berechnung Breitschiff"]
[null,"length of ventilation (LL)",106,"[m]",null,null,null,null,null,null,null,null,"Ersteller:","xxx",{"$f":"TODAY()","v":"2025-08-13"}]
[null,"ancho de ventilación (BL)",1.5,"[m]",null,null,null,null,null,null,"Kunde ",null,null,null,null,null,"Benötigte Daten:"]
[null,"brazo de palanca (B1)",2,"[m]",null,null,null,null,null,null,"Projekt"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Länge LL"]
[null,null,null,null,null,null,null,null,null,null,"Anmerkung: Beispielhafte Stückliste was alles im Angebot beeinhaltet sein soll.",null,null,null,null,null,null,"width of ventilation (BL)"]
[null,"Angriffswinkel γ",70,"[°]",null,null,null,null,null,null,null,null,null,null,null,null,"Hebelarm B1"]
[null,null,null,null,null,null,null,null,null,null,"Abteil 1",null,null,null,null,null,"Gewicht G"]
[null,null,null,null,null,null,null,null,null,null,"Stückzahl","Bezeichnung","Artikelnummer","Bezeichnung","Bemerkung"]
[null,"peso",{"$f":"Daten!G17","v":8.52},null,null,null,null,null,null,null,1,"89213.0201","89213.0201","TBR IN.0202","Stückzahl in Stunden",null,null,"LL","BL"]
[null,null,{"$f":"Daten!G17","v":8.52},"[kg/m]",null,null,null,null,null,null,null,{"$f":"IF(G15<50,Daten!I15,IF(AND(G15>=50,G15<90),Daten!I16,IF(AND(G15>=90,G15<150),Daten!I17,IF(AND(G15>=150,G15<250),Daten!I18,IF(AND(G15>=250,G15<350),Daten!I19,IF(AND(G15>=350,G15<450),Daten!I20,IF(AND(G15>=450,G15<600),Daten!I21,\"Error\")))))))","v":"EWA 10.05xx"},null,null,null,null,null,50,2.15,1.6]
[null,null,null,null,null,null,null,null,null,null,null,"PAR 06",null,null,"optional",null,null,100,4.3]
[null,null,null,null,null,null,null,null,null,null,{"$f":"K11*2","v":0},"KKS 10"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"C27","v":133.68795287891712},{"$f":"IF(G20<500,Daten!J15,IF(AND(G20>=500,G20<700),Daten!J16,IF(AND(G20>=700,G20<1200),Daten!J17,IF(AND(G20>=1200,G20<2500),Daten!J18,\"Error\"))))","v":"EZD 51"}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"K14","v":133.68795287891712},"EZZ"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"K14","v":133.68795287891712},"ELD/KLG"]
[]
[]
[null,"Lock cremallera y piñón"]
[null,"radio del piñón ( r)",{"$f":"Daten!C12","v":22},"[mm]"]
[null,"Reibungsfaktor (KR)",{"$f":"Daten!D12","v":1.5},"[   ]"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"(($C$10+$C$13+$C$14+$C$15+$C$17)*COS(RADIANS($C$5))*($C$3/2)*$C$3*$C$25*9.81)/(COS(RADIANS(90-$C$7))*$C$4)*$C$23","v":0}]
[]
[null,"longitud posible"]
[null,"EWA 173",{"$f":"(150/((C3*(C10)*C20*C21*Daten!B3)))*(200*C4*SIN(RADIANS(C7)))","v":133.68795287891712},"[m]"]
[null,"EWA 313",{"$f":"(250/((C3*(C10)*C20*C21*Daten!B3)))*(200*C4*SIN(RADIANS(C7)))","v":222.8132547981952},"[m]"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Berechnung Kraft"]
[null,"horizontales Fenster",{"$f":"(($C$10+$C$13+$C$14+$C$15+$C$17)*($C$3/2)*$C$3*$C$23*9.81)/((1/COS(RADIANS(90-((180-$C$5)/2))))*$C$4)*Daten!B3","v":0},{"$f":"MAX(C46:C47)","v":0}]
[null,"Fenster geschlossen",{"$f":"(($C$10+$C$13+$C$14+$C$15+$C$17)*COS(RADIANS($C$5))*($C$3/2)*$C$3*$C$23*9.81)/(COS(RADIANS(90-$C$7))*$C$4)*Daten!B3","v":0}]
[]
[null,"wenn der Winkel Gamma kleiner  als 70° ist, ist die Kraft zum Aufdrücken des Fensters größer als die Kraft in der horizontalen"]
[null,"Ansonsten ist die Kraft der Zahnstange in der horizontalen die größte"]

{"sheet":"Durchverbindung_in Arbeit","index":1,"n_rows":29,"n_cols":15,"rows_kept":29,"cut":false,"hidden":true,"merged":[[24,5,25,5],[24,6,24,8],[25,6,25,8],[27,5,28,5],[27,6,27,8],[28,6,28,8]]}
[null,null,null,null,null,null,null,null,null,null,"Informationen:","Venlo Stütze "]
[null,"Lüftungslänge (LL)",50,"[m]",null,null,null,null,null,null,null,null,"Ersteller:","tfl","2020-08-03"]
[null,"Fensterbreite (BL)",1.5,"[m]",null,null,null,null,null,null,"Kunde "]
[null,"Hebelarm (B1)",1.4,"[m]",null,null,null,null,null,null,"Projekt"]
[null,"Dachneigung α",30,"[°]",null,null,null,null,null,null,"Fensterabmaße"]
[null,"Angriffswinkel γ",60,"[°]",null,null,null,null,null,null,"Eindeckung"]
[null,null,null,null,null,null,null,null,null,null,"Vakmaat"]
[null,"Eindeckung (GG)",null,null,null,null,null,null,null,null,"Kapmaat"]
[null,null,{"$f":"Daten!G17","v":8.52},"[kg/m²]",null,null,null,null,null,null,"Stützenabmessung","x"]
[null,"Rahmen (GR)",null,null,null,null,null,null,null,null,"Obergurt","x"]
[null,null,{"$f":"Daten!J7","v":0},"[kg/m²]",null,null,null,null,null,null,"Gitterbinderhöhe","x"]
[null,"Schneelast (GS)",null,"[kg/m²]",null,null,null,null,null,null,"Gurtabsenkung","x"]
[null,"Windlast (GW)",null,"[kg/m²]",null,null,null,null,null,null,"Abteil 1"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Klappen pro LZG","x"]
[null,"Lock Zahnstangengetriebe",null,null,null,null,null,null,null,null,null,null,"Klappen pro EWA","x"]
[null,"Ritzelradius ( r)",{"$f":"Daten!C12","v":22},"[mm]",null,null,null,null,null,null,"Stückzahl","Bezeichnung","Artikelnummer","Bezeichnung","Bemerkung"]
[null,"Reibungsfaktor (KR)",{"$f":"Daten!D12","v":1.5},"[   ]",null,null,null,null,null,null,1,"89213.0201","89213.0201","TBR IN.0202","Stunden"]
[null,null,null,null,null,null,null,null,null,null,null,"EWA 10"]
[null,"Sicherheitsfaktor (S)",1,"[   ]",null,null,null,null,null,null,null,"PAR 06",null,null,"optional"]
[null,null,null,null,null,"Bild neu siehe Aufgabe",null,null,null,null,{"$f":"K18*2","v":0},"KKS 10"]
[null,"Abstand der Zahnstangen/\nBinderfeldlänge",3,"[m]",null,null,null,null,null,null,null,"EZD 51"]
[null,"Anzahl Zahnstangen-getriebe pro Seite",{"$f":"C2/C21","v":16.666666666666668},"[   ]",null,null,null,null,null,null,{"$f":"K21","v":0},"EZZ"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"K21","v":0},"ELD 12"]
[]
[null,"Drehmoment (T)",{"$f":"(C3*C3*C2*(C9+C11+C12+C13)*C16*C17*C19*COS(RADIANS(C5)))/(100*C4*SIN(RADIANS(C6)))","v":225.93214285714291},"[Nm]",null,"T =","BL x BL x LL x G x r x cos(α) x KR x S"]
[null,null,"Drehmoment für beide Lüftungsseiten",null,null,null,"100 x B1 x sin(γ)"]
[]
[null,"Belastung Zahnstange (F)",{"$f":"(C3*C3*C2*(C9+C11+C12+C13)*COS(RADIANS(C5))*C19)/(0.2*C4*C22*SIN(RADIANS(C6)))","v":205.3928571428572},"[N]",null,"F =","BL x BL x LL x G x cos(α) x S"]
[null,null,null,null,null,null,"0,2 x B1 x sin(γ) x ZSt"]

{"sheet":"Daten","index":2,"n_rows":39,"n_cols":11,"rows_kept":39,"cut":false,"hidden":true,"merged":[[26,8,27,8],[20,5,20,6]]}
[]
[]
["Sicherheitsfaktor",1,null,null,null,"peso 4",4,null,"Alu-Profil normal",2.5]
[null,null,null,null,null,"peso 6",6,null,"Null",0,"meistens nur für Isolierglas"]
[null,null,null,null,null,"peso 8",6,null,"Stahl",8.1999999999999993]
[null,null,null,null,null,"peso Spain",8.52,null,null,2]
[null,"EZD 31",22,1.5,null,"peso 10",10,null,"ausgewählt:",{"$f":"INDEX(J3:J5,J6)","v":0}]
[null,"EZD 51/52",22,1.4,null,"peso 12",12]
[]
[null,null,null,null,null,null,null,null,"Gabler, Fried, Kräss = GFK"]
[null,null,1,1]
[null,"ausgewählt:",{"$f":"INDEX(C7:C10,C11)","v":22},{"$f":"INDEX(D7:D10,C11)","v":1.5}]
[]
[]
[null,null,null,null,null,null,null,null,"EWA 10.05xx","EZD 51"]
[null,null,null,null,null,null,4,null,"EWA 10.09xx","AZD 05"]
[null,null," ",null,null,"ausgewählt:",{"$f":"INDEX(G3:G15,G16)","v":8.52},null,"EWA 12.15xx","ZSG 15"]
[null,null,null,null,null,null,null,null,"EWA 12.25xx","ZSG 20"]
[null,"EWA 10",null,null,null,null,null,null,"EWA 14.35xx","Error"]
[null,"EWA 12",null,"ohne",0,null,null,null,"EWA 14.45xx"]
[null,"EWA 14",null,"Insektentennetz 1,4kg/m",1.4,"kg/m Wert van der valk von Holland Kaas. Wird in der Excel umgerechnet auf kg/m²",null,null,"EWA 14.60xx"]
[null,"EWA 16",null,null,1,null,null,null,"Error"]
[null,"PAR 06",null,"ausgewählt:",{"$f":"INDEX(E20:E21,E22)","v":0}]
[null,"PAR 10"]
[null,"KKS 10"]
[null,"KKS 11"]
[null,"KKS 14",null,"über Binder",0]
[null,"KKS 15",null,"unter Binder",0.3]
[null,"BKS 45",null,null,2]
[null,"EZD 51",null,"ausgewählt:",{"$f":"INDEX(E27:E28,E29)","v":0.3}]
[null,"EZD 52"]
[null,"AZD 05"]
[null,"AZZ"]
[null,"EZZ"]
[null,"ELD 12"]
[null,"ELD 16"]
[null,"ALD 11"]
[null,"ALD 15"]
[null,"KLG 35"]