{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Berechnungen","ERSID"],"not_rendered":{"charts":0,"images":10,"macros":1,"external_links":0,"defined_names":2,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Berechnungen","index":0,"n_rows":40,"n_cols":16,"rows_kept":40,"cut":false,"hidden":true,"merged":[[21,10,21,12],[21,13,21,15],[21,7,21,9],[21,1,21,3],[21,4,21,6],[0,1,0,3],[4,1,4,3],[4,4,4,6],[9,13,9,15],[15,1,15,3],[15,4,15,6],[4,7,4,9],[9,1,9,3],[9,4,9,6],[9,7,9,9],[9,10,9,12],[15,7,15,9],[15,10,15,12],[15,13,15,15]]}
[1,"Stufe 1"]
[null,"p","v","pe²"]
[1,{"$f":"ERSID!$F$19","v":0},{"$f":"ERSID!$K$19","v":0},{"$f":"B3^2-4*C3^2","v":0}]
[]
[2,"Stufe 1",null,null,"Stufe 2",null,null,"Stufe 3"]
[null,"p","v","pe²","pb","vl","pe²","vk","v","pe²"]
[1,{"$f":"ERSID!$F$19","v":0},{"$f":"ERSID!$K$19","v":0},{"$f":"B7^2-4*C7^2","v":0},{"$f":"ERSID!$F$23","v":0},{"$f":"(D8-D7)/(8*E7)","v":{"$error":"#DIV/0!"}},{"$f":"D7+(E7+2*F7)^2","v":{"$error":"#DIV/0!"}},{"$f":"ERSID!$K$23","v":0},{"$f":"H7-F7","v":{"$error":"#DIV/0!"}},{"$f":"G7-4*I7^2","v":{"$error":"#DIV/0!"}}]
[2,{"$f":"ERSID!$F$20","v":0},{"$f":"ERSID!$K$20","v":0},{"$f":"B8^2-4*C8^2","v":0}]
[]
[3.1,"Stufe 1",null,null,"Stufe 2",null,null,"Stufe 3",null,null,"Stufe 4",null,null,"Stufe 5"]
[null,"p","v","pe²","pb","vl","pe²","vk","v","pe²","pb","vl","pe²","vk","v","pe²"]
[1,{"$f":"ERSID!$F$19","v":0},{"$f":"ERSID!$K$19","v":0},{"$f":"B12^2-4*C12^2","v":0},{"$f":"ERSID!$F$23","v":0},{"$f":"(D13-D12)/(8*E12)","v":{"$error":"#DIV/0!"}},{"$f":"D12+(E12+2*F12)^2","v":{"$error":"#DIV/0!"}},{"$f":"ERSID!$K$23","v":0},{"$f":"H12-F12","v":{"$error":"#DIV/0!"}},{"$f":"G12-4*I12^2","v":{"$error":"#DIV/0!"}}]
[2,{"$f":"ERSID!$F$20","v":0},{"$f":"ERSID!$K$20","v":0},{"$f":"B13^2-4*C13^2","v":0},null,null,null,null,null,null,{"$f":"ERSID!$F$24","v":0},{"$f":"(J14-J12)/(8*K13)","v":{"$error":"#DIV/0!"}},{"$f":"J12+(K13+2*L13)^2","v":{"$error":"#DIV/0!"}},{"$f":"ERSID!$K$24","v":0},{"$f":"N13-L13","v":{"$error":"#DIV/0!"}},{"$f":"M13-4*O13^2","v":{"$error":"#DIV/0!"}}]
[3,{"$f":"ERSID!$F$21","v":0},{"$f":"ERSID!$K$21","v":0},{"$f":"B14^2-4*C14^2","v":0},null,null,null,null,null,{"$f":"D14","v":0}]
[]
[3.2,"Stufe 1",null,null,"Stufe 2",null,null,"Stufe 3",null,null,"Stufe 4",null,null,"Stufe 5"]
[null,"p","v","pe²","pb","vl","pe²","vk","v","pe²","pb","vl","pe²","vk","v","pe²"]
[1,{"$f":"ERSID!$F$19","v":0},{"$f":"ERSID!$K$19","v":0},{"$f":"B18^2-4*C18^2","v":0},null,null,null,null,null,{"$f":"D18","v":0}]
[2,{"$f":"ERSID!$F$20","v":0},{"$f":"ERSID!$K$20","v":0},{"$f":"B19^2-4*C19^2","v":0},null,null,null,null,null,null,{"$f":"ERSID!$F$24","v":0},{"$f":"(J20-J18)/(8*K19)","v":{"$error":"#DIV/0!"}},{"$f":"J18+(K19+2*L19)^2","v":{"$error":"#DIV/0!"}},{"$f":"ERSID!$K$24","v":0},{"$f":"N19-L19","v":{"$error":"#DIV/0!"}},{"$f":"M19-4*O19^2","v":{"$error":"#DIV/0!"}}]
[3,{"$f":"ERSID!$F$21","v":0},{"$f":"ERSID!$K$21","v":0},{"$f":"B20^2-4*C20^2","v":0},{"$f":"ERSID!$F$23","v":0},{"$f":"(D20-D19)/(8*E20)","v":{"$error":"#DIV/0!"}},{"$f":"D19+(E20+2*F20)^2","v":{"$error":"#DIV/0!"}},{"$f":"ERSID!$K$23","v":0},{"$f":"H20-F20","v":{"$error":"#DIV/0!"}},{"$f":"G20-4*I20^2","v":{"$error":"#DIV/0!"}}]
[]
[4,"Stufe 1",null,null,"Stufe 2",null,null,"Stufe 3",null,null,"Stufe 4",null,null,"Stufe 5"]
[null,"p","v","pe²","pb","vl","pe²","vk","v","pe²","pb","vl","pe²","vk","v","pe²"]
[1,{"$f":"ERSID!$F$19","v":0},{"$f":"ERSID!$K$19","v":0},{"$f":"B24^2-4*C24^2","v":0},{"$f":"ERSID!$F$23","v":0},{"$f":"(D25-D24)/(8*E24)","v":{"$error":"#DIV/0!"}},{"$f":"D24+(E24+2*F24)^2","v":{"$error":"#DIV/0!"}},{"$f":"ERSID!$K$23","v":0},{"$f":"H24-F24","v":{"$error":"#DIV/0!"}},{"$f":"G24-4*I24^2","v":{"$error":"#DIV/0!"}}]
[2,{"$f":"ERSID!$F$20","v":0},{"$f":"ERSID!$K$20","v":0},{"$f":"B25^2-4*C25^2","v":0},null,null,null,null,null,null,{"$f":"ERSID!$F$25","v":0},{"$f":"(J26-J24)/(8*K25)","v":{"$error":"#DIV/0!"}},{"$f":"J24+(K25+2*L25)^2","v":{"$error":"#DIV/0!"}},{"$f":"ERSID!$K$25","v":0},{"$f":"N25-L25","v":{"$error":"#DIV/0!"}},{"$f":"M25-4*O25^2","v":{"$error":"#DIV/0!"}}]
[3,{"$f":"ERSID!$F$21","v":0},{"$f":"ERSID!$K$21","v":0},{"$f":"B26^2-4*C26^2","v":0},{"$f":"ERSID!$F$24","v":0},{"$f":"(D27-D26)/(8*E26)","v":{"$error":"#DIV/0!"}},{"$f":"D26+(E26+2*F26)^2","v":{"$error":"#DIV/0!"}},{"$f":"ERSID!$K$24","v":0},{"$f":"H26-F26","v":{"$error":"#DIV/0!"}},{"$f":"G26-4*I26^2","v":{"$error":"#DIV/0!"}}]
[4,{"$f":"ERSID!$F$22","v":0},{"$f":"ERSID!$K$22","v":0},{"$f":"B27^2-4*C27^2","v":0}]
[]
[null,{"$f":"IF(Anzahl=1,Berechnungen!D3,IF(Anzahl=2,Berechnungen!J7,IF(Anzahl=3.1,Berechnungen!P13,IF(Anzahl=3.2,Berechnungen!P19,IF(Anzahl=4,Berechnungen!P25,\"Fehler\")))))","v":0},{"$f":"SQRT(ABS(B29))","v":0},{"$f":"IF(B29<0,\" j\",\"\")","v":""},{"$f":"FIXED(C29,0)&D29&\" \"","v":"0 "}]
[]
[]
[]
[{"$f":"IF(ISNUMBER(ERSID!F19)=TRUE,1,0)","v":0},{"$f":"IF(ISNUMBER(ERSID!K19)=TRUE,1,0)","v":0},{"$f":"IF(A33+B33=2,0,-1)","v":-1},null,{"$f":"IF(Anzahl=1,\"einem\",INT(Anzahl))","v":"einem"},{"$f":"IF(ERSID!M1=1,\" Drehgestell\",\" Drehgestellen\")","v":" Drehgestell"},null,null,{"$f":"IF(ERSID!M1=3.1,\" (Drehgestell 1 und 2 mit Brücke 1 verbunden)\",IF(ERSID!M1=3.2,\" (Drehgestell 2 und 3 mit Brücke 1 verbunden)\",\"\"))","v":""}]
[{"$f":"IF(ISNUMBER(ERSID!F20)=TRUE,1,0)","v":0},{"$f":"IF(ISNUMBER(ERSID!K20)=TRUE,1,0)","v":0},{"$f":"IF(Anzahl =1,0,IF(A34+B34=2,0,-1))","v":0}]
[{"$f":"IF(ISNUMBER(ERSID!F21)=TRUE,1,0)","v":0},{"$f":"IF(ISNUMBER(ERSID!K21)=TRUE,1,0)","v":0},{"$f":"IF(Anzahl <3,0,IF(A35+B35=2,0,-1))","v":0},null,{"$f":"IF(C40<0,\"Es fehlen noch Angaben!                           \",\"Der Ersatz-Radsatzstand im Drehgestell für die angegebenen Werte lautet:\")","v":"Es fehlen noch Angaben!                           "}]
[{"$f":"IF(ISNUMBER(ERSID!F22)=TRUE,1,0)","v":0},{"$f":"IF(ISNUMBER(ERSID!K22)=TRUE,1,0)","v":0},{"$f":"IF(Anzahl <4,0,IF(A36+B36=2,0,-1))","v":0},null,{"$f":"\"pe = \"&Berechnungen!E29&\"mm\"","v":"pe = 0 mm"}]
[{"$f":"IF(ISNUMBER(ERSID!F23)=TRUE,1,0)","v":0},{"$f":"IF(ISNUMBER(ERSID!K23)=TRUE,1,0)","v":0},{"$f":"IF(Anzahl =1,0,IF(A37+B37=2,0,-1))","v":0},null,null,null,null,null,null,null,null," "]
[{"$f":"IF(ISNUMBER(ERSID!F24)=TRUE,1,0)","v":0},{"$f":"IF(ISNUMBER(ERSID!K24)=TRUE,1,0)","v":0},{"$f":"IF(Anzahl <3,0,IF(A38+B38=2,0,-1))","v":0},null,null,null,null,null," ",null," "," "]
[{"$f":"IF(ISNUMBER(ERSID!F25)=TRUE,1,0)","v":0},{"$f":"IF(ISNUMBER(ERSID!K25)=TRUE,1,0)","v":0},{"$f":"IF(Anzahl <4,0,IF(A39+B39=2,0,-1))","v":0}]
[null,null,{"$f":"SUM(C33:C39)","v":-1},null,null,null,null,null,null,null," "]

{"sheet":"ERSID","index":1,"n_rows":26,"n_cols":25,"rows_kept":26,"cut":false,"hidden":false,"merged":[[1,10,1,12],[3,1,4,2],[25,1,25,9],[25,10,25,12],[1,4,1,9],[2,1,2,12],[19,2,19,3],[18,2,18,3],[18,12,24,12],[20,2,20,3],[21,2,21,3],[22,2,22,3],[23,2,23,3],[24,2,24,3]]}
[null,null,null,null,null,null,null,null,null,null,null,null,1,null,null,null,null,null," "]
[null,null,null,null,"Ersatz-Radsatzstand im Drehgestell",null,null,null,null,null,"  © 1996-2023 Martin Brinkert      "]
[null,{"$f":"\"für Eisenbahnwagen mit \"&Berechnungen!E33&Berechnungen!F33&\" pro Wagenhälfte\"&Berechnungen!I33","v":"für Eisenbahnwagen mit einem Drehgestell pro Wagenhälfte"}]
[null,"Wagenhälfte mit"]
[]
[]
[]
[]
[]
[]
[]
[3.2149999999999999]
[]
[]
[]
[]
[]
[]
[null,null,"führ. Radsatzstand im Drehgestell 1",null,"p 1 [mm]",null,null,665,"konstr. Versatz Drehgestell 1","vk 1 [mm]",null,null,"Bei Versatz aus der Mitte nach rechts (siehe Zeichnung) ist der Wert positiv, ansonsten negativ anzugeben."]
[null,null,{"$f":"IF(Anzahl<2,\"\",\"führ. Radsatzstand im Drehgestell 2\")","v":""},null,{"$f":"IF(Anzahl<2,\"\",\"p 2 [mm]\")","v":""},null,null,null,{"$f":"IF(Anzahl<2,\"\",\"konstr. Versatz Drehgestell 2\")","v":""},{"$f":"IF(Anzahl<2,\"\",\"vk 2 [mm]\")","v":""}]
[null,null,{"$f":"IF(Anzahl<3,\"\",\"führ. Radsatzstand im Drehgestell 3\")","v":""},null,{"$f":"IF(Anzahl<3,\"\",\"p 3 [mm]\")","v":""},null,null,null,{"$f":"IF(Anzahl<3,\"\",\"konstr. Versatz Drehgestell 3\")","v":""},{"$f":"IF(Anzahl<3,\"\",\"vk 3 [mm]\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,{"$f":"IF(Anzahl<4,\"\",\"führ. Radsatzstand im Drehgestell 4\")","v":""},null,{"$f":"IF(Anzahl<4,\"\",\"p 4 [mm]\")","v":""},null,null,null,{"$f":"IF(Anzahl<4,\"\",\"konstr. Versatz Drehgestell 4\")","v":""},{"$f":"IF(Anzahl<4,\"\",\"vk 4 [mm]\")","v":""}]
[null,null,{"$f":"IF(Anzahl<2,\"\",\"Abstand Verbindungs-Brücke 1        \")","v":""},null,{"$f":"IF(Anzahl<2,\"\",\"pb 1 [mm]\")","v":""},null,null,null,{"$f":"IF(Anzahl<2,\"\",\"konstr. Versatz Brücke 1\")","v":""},{"$f":"IF(Anzahl<2,\"\",\"vkb 1 [mm]\")","v":""}]
[null,null,{"$f":"IF(Anzahl<3,\"\",\"Abstand Verbindungs-Brücke 2        \")","v":""},null,{"$f":"IF(Anzahl<3,\"\",\"pb 2 [mm]\")","v":""},null,null,null,{"$f":"IF(Anzahl<3,\"\",\"konstr. Versatz Brücke 2\")","v":""},{"$f":"IF(Anzahl<3,\"\",\"vkb 2 [mm]\")","v":""}]
[null,null,{"$f":"IF(Anzahl<4,\"\",\"Abstand Verbindungs-Brücke 3        \")","v":""},null,{"$f":"IF(Anzahl<4,\"\",\"pb 3 [mm]\")","v":""},null,null,null,{"$f":"IF(Anzahl<4,\"\",\"konstr. Versatz Brücke 3\")","v":""},{"$f":"IF(Anzahl<4,\"\",\"vkb 3 [mm]\")","v":""}]
[null,{"$f":"Berechnungen!E35","v":"Es fehlen noch Angaben!                           "},{"$f":"VLOOKUP(Berechnungen!$H40,$V25:$X25,2)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(Berechnungen!$H40,$V25:$X25,2)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(Berechnungen!$H40,$V25:$X25,2)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(Berechnungen!$H40,$V25:$X25,2)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(Berechnungen!$H40,$V25:$X25,2)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(Berechnungen!$H40,$V25:$X25,2)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(Berechnungen!$H40,$V25:$X25,2)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(Berechnungen!$H40,$V25:$X25,2)","v":{"$error":"#N/A"}},{"$f":"IF(Berechnungen!C40<0,\"\",Berechnungen!E36)","v":""},{"$f":"VLOOKUP(Berechnungen!$H40,$V25:$X25,3)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(Berechnungen!$H40,$V25:$X25,3)","v":{"$error":"#N/A"}}]