{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Einbau HB","Ausbau HB","Rahmen Einschub"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":6,"comments":2,"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":"Einbau HB","index":0,"n_rows":107,"n_cols":20,"rows_kept":107,"cut":false,"hidden":false,"merged":[[0,11,0,12],[0,9,0,10]]}
["Projekt","Einbau Hilfsbrücke",null,null,null,null,null,"Uhrzeit-berechnung:","01:00:00","Start (Datum/Uhrzeit) eingeben:",null,"2022-01-02T23:00:00"]
["Vor-gangs-\nNr.","Vorgangsbezeichnung","Position Katalog","Hinweise/Bemerkungen","Leistungs-menge","Einheit Leistungs-menge\nErläuterung","Leistungs-wert Katalog","Einheit Leistungswert\nErläuterung ","Dauer (rechn.)","Dauer (gewählt)","Para-llelität\nin %","Beginn","Ende","Bemerkung","Tag-wechsel",null,"Prüfung Anfangszeit","Prüfung Dauer gewählt\nzu klein","Prüfung Dauer gewählt\nzu groß","Prüfung Parallelität"]
[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,null,16,17,18,19]
[0,"Vorbereitende Maßnahmen definieren, z.B. BE-Fläche, Anrampung, Baustrom, Kabelumverlegung, Verbau zum Nachbargleis, Feste Absperrung, Bodengutachten, Kampfmittelsondierung, Gründung Hilfsbrücke",null,"Im Vorfeld in einer gesonderten (Gleis-)Sperrung zu realisieren.",null,null,null,null,null,null,null,null,null,null,0,null,{"$f":"IF(L4=0,\"Bitte prüfen\",\"\")","v":"Bitte prüfen"},{"$f":"IF(J4/I4<0.5,\"Bitte prüfen\",\"\")","v":{"$error":"#DIV/0!"}},{"$f":"IF(J4/I4>2.5,\"Bitte prüfen\",\"\")","v":{"$error":"#DIV/0!"}},{"$f":"IF(K4<0,\"Bitte prüfen\",IF(K4>1.5,\"Bitte prüfen\",\"\"))","v":""}]
[]
[{"$f":"MAX(A4:A5)+1","v":1},"Sperrung einrichten","08.01.01.01","Regelungen Betra beachten",1,"psch",2,"psch/h",{"$f":"E6/G6*I$1","v":2.0833333333333332E-2},2.0833333333333332E-2,0,{"$f":"L1","v":"2022-01-02T23:00:00"},{"$f":"L6+J6","v":"2022-01-02T23:30:00"},null,1,null,{"$f":"IF(L6=0,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(J6/I6<0.5,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(J6/I6>2.5,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(K6<0,\"Bitte prüfen\",IF(K6>1.5,\"Bitte prüfen\",\"\"))","v":""}]
[]
[{"$f":"MAX(A4:A7)+1","v":2},"Oberleitung abschalten und Erdungsvorrichtung einbauen (1 Schaltgruppe)","08.01.02.01",null,2,"psch",4,"psch/h",{"$f":"E8/G8*I$1","v":2.0833333333333332E-2},2.0833333333333332E-2,0.5,{"$f":"IF(K8=100%,L6,IF(K8>0%,M6-J6*K8,M6))","v":"2022-01-02T23:15:00"},{"$f":"L8+J8","v":"2022-01-02T23:45:00"},null,null,null,{"$f":"IF(L8=0,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(J8/I8<0.5,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(J8/I8>2.5,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(K8<0,\"Bitte prüfen\",IF(K8>1.5,\"Bitte prüfen\",\"\"))","v":""}]
[null,null,null,"Teilparallelität zu Vorgang Nr. 1"]
[{"$f":"MAX(A6:A9)+1","v":3},"Gleisschaltmittel  (Achszähler, PZB, Linienleiter, Balisen etc.) abbauen","07.01.02.02/ 07.01.02.05/ 07.01.03.02","kann ggf. zu Bahnerdung parallel laufen (kein ZWB - nur Personal)",3,"St",3,"St/h",{"$f":"E10/G10*I$1","v":4.1666666666666664E-2},4.1666666666666664E-2,1,{"$f":"IF(K10=100%,L8,IF(K10>0%,M8-J8*K10,M8))","v":"2022-01-02T23:15:00"},{"$f":"L10+J10","v":"2022-01-03T00:15:00"},null,2,null,{"$f":"IF(L10=0,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(J10/I10<0.5,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(J10/I10>2.5,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(K10<0,\"Bitte prüfen\",IF(K10>1.5,\"Bitte prüfen\",\"\"))","v":""}]
[null,null,null,"Der Vorgang kann frühestens parallel zu Vorgang 2 beginnen",null," Annahme getroffen"]
[{"$f":"MAX(A8:A11)+1","v":4},"Erdungseinrichtungen (Schienen-, Gleisverbinder, Betriebserden etc.) abbauen","06.08.02.03","absolute Parallelität zu Vorgang Nr. 3, jedoch muss der Vorgang Nr. 2 vorher abgeschlossen sein.",4,"St",4,"St/h",{"$f":"E12/G12*I$1","v":4.1666666666666664E-2},4.1666666666666664E-2,1,"2022-01-02T23:45:00",{"$f":"L12+J12","v":"2022-01-03T00:45:00"},"Beginnzeit händisch gesetzt, da Vorgang 2 abgeschlossen sein muss.",null,null,{"$f":"IF(L12=0,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(J12/I12<0.5,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(J12/I12>2.5,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(K12<0,\"Bitte prüfen\",IF(K12>1.5,\"Bitte prüfen\",\"\"))","v":""}]
[null,null,null,null,null,null,null,"Leistungsmenge stark abhängig von der Lage des Bauwerks"]
[{"$f":"MAX(A10:A13)+1","v":5},"Rückstromführung montieren","06.08.01.07","Rücksprache mit Fachplaner, ob die Leistung erforderlich ist!",2,"St",1,"St/h",{"$f":"E14/G14*I$1","v":8.3333333333333329E-2},8.3333333333333329E-2,0.5,{"$f":"IF(K14=100%,L12,IF(K14>0%,M12-J12*K14,M12))","v":"2022-01-03T00:15:00"},{"$f":"L14+J14","v":"2022-01-03T02:15:00"},null,null,null,{"$f":"IF(L14=0,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(J14/I14<0.5,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(J14/I14>2.5,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(K14<0,\"Bitte prüfen\",IF(K14>1.5,\"Bitte prüfen\",\"\"))","v":""}]
[null,null,null,"Parallel zu Vorgang Nr. 4"]
[{"$f":"MAX(A12:A15)+1","v":6},"OLA aus-/verschwenken/verziehen","06.01.01.01","ca. 60 min freie Strecke, ca 120 min Bahnhof",90,"m",60,"m/h",{"$f":"E16/G16*I$1","v":6.25E-2},6.25E-2,0,{"$f":"IF(K16=100%,L14,IF(K16>0%,M14-J14*K16,M14))","v":"2022-01-03T02:15:00"},{"$f":"L16+J16","v":"2022-01-03T03:45:00"},null,null,null,{"$f":"IF(L16=0,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(J16/I16<0.5,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(J16/I16>2.5,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(K16<0,\"Bitte prüfen\",IF(K16>1.5,\"Bitte prüfen\",\"\"))","v":""}]
[null,null,null,"in der Regel 2 Kettenwerkslängen"]
[{"$f":"MAX(A14:A17)+1","v":7},"Schienen trennen/schneiden (Trennschnitt)","02.01.01.01","zur Wiederverwendung je 2 Schnitte recht, links",4,"St",6,"St/h",{"$f":"E18/G18*I$1","v":2.7777777777777776E-2},3.125E-2,0,{"$f":"IF(K18=100%,L16,IF(K18>0%,M16-J16*K18,M16))","v":"2022-01-03T03:45:00"},{"$f":"L18+J18","v":"2022-01-03T04:30:00"},null,null,null,{"$f":"IF(L18=0,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(J18/I18<0.5,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(J18/I18>2.5,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(K18<0,\"Bitte prüfen\",IF(K18>1.5,\"Bitte prüfen\",\"\"))","v":""}]
[null,null,null,"Trennschnitte vor der Hilfsbrücke in Abhänigkeit von der Geschwindigkeit 3, 5 oder 10 m (Schwellenteilung)"]
[{"$f":"MAX(A16:A19)+1","v":8},"Schienen lösen und verziehen","02.02.02.01","Schiene lösen mit Schrauber (2 Trupps á 2 Leute)",70,"2 x  30-40 m ",150,"m/h",{"$f":"E20/G20*I$1","v":1.9444444444444445E-2},2.0833333333333332E-2,0,{"$f":"IF(K20=100%,L18,IF(K20>0%,M18-J18*K20,M18))","v":"2022-01-03T04:30:00"},{"$f":"L20+J20","v":"2022-01-03T05:00:00"},null,null,null,{"$f":"IF(L20=0,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(J20/I20<0.5,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(J20/I20>2.5,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(K20<0,\"Bitte prüfen\",IF(K20>1.5,\"Bitte prüfen\",\"\"))","v":""}]
[null,null,null,null,null,"Schiene"]
[{"$f":"MAX(A18:A21)+1","v":9},"Regelfall: Holzschwellen ausbauen, transportieren und lagern","02.02.01.01","3 Stück am Haken (10-15 min); abhängig von Beton- oder Holzschwelle",40,"30 - 40 m ",55,"m/h",{"$f":"E22/G22*I$1","v":3.0303030303030304E-2},3.125E-2,0,{"$f":"IF(K22=100%,L20,IF(K22>0%,M20-J20*K22,M20))","v":"2022-01-03T05:00:00"},{"$f":"L22+J22","v":"2022-01-03T05:45:00"},null,null,null,{"$f":"IF(L22=0,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(J22/I22<0.5,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(J22/I22>2.5,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(K22<0,\"Bitte prüfen\",IF(K22>1.5,\"Bitte prüfen\",\"\"))","v":""}]
[null,null,null,null,null,"Gleis",null,"Zwei 2-Wege-Bagger im Einsatz"]
["9a","Alternativ: Montageschiene aufschrauben","02.02.07.01",null,40,"30 - 40 m ",70,"m/h",{"$f":"E24/G24*I$1","v":2.3809523809523808E-2},2.0833333333333332E-2,1,null,null,"Keine Zeiten eingetragen, da Alternative für Pos. 9",null,null,{"$f":"IF(L24=0,\"Bitte prüfen\",\"\")","v":"Bitte prüfen"},{"$f":"IF(J24/I24<0.5,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(J24/I24>2.5,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(K24<0,\"Bitte prüfen\",IF(K24>1.5,\"Bitte prüfen\",\"\"))","v":""}]
[null,null,null,null,null,"Gleis"]
["9b","Alternativ: Jochweise (10 m) rausheben, transportieren und lagern","02.02.01.04","6m Betonschwellen, 10m Holzschwellen",40,"30 - 40 m ",60,"m/h",{"$f":"E26/G26*I$1","v":2.7777777777777776E-2},3.125E-2,1,null,null,"Keine Zeiten eingetragen, da Alternative für Pos. 9",null,null,{"$f":"IF(L26=0,\"Bitte prüfen\",\"\")","v":"Bitte prüfen"},{"$f":"IF(J26/I26<0.5,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(J26/I26>2.5,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(K26<0,\"Bitte prüfen\",IF(K26>1.5,\"Bitte prüfen\",\"\"))","v":""}]
[null,null,null,null,null,"Gleis"]
[{"$f":"MAX(A20:A27)+1","v":10},"Schotter ausbauen","02.02.03.06","hier als Beispiel Kleinstmengen Verladung auf Res-Wagen vor Kopf",80,"75 - 100 m3",30,"m3/h",{"$f":"E28/G28*I$1","v":0.1111111111111111},0.125,0,{"$f":"IF(K28=100%,L22,IF(K28>0%,M22-J22*K28,M22))","v":"2022-01-03T05:45:00"},{"$f":"L28+J28","v":"2022-01-03T08:45:00"},null,null,null,{"$f":"IF(L28=0,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(J28/I28<0.5,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(J28/I28>2.5,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(K28<0,\"Bitte prüfen\",IF(K28>1.5,\"Bitte prüfen\",\"\"))","v":""}]
[]
[{"$f":"MAX(A26:A29)+1","v":11},"Kopfloch herstellen Seite 1","03.06.01.01","Verbau zum Nachbargleis in vorheriger Sperrpause in Verbindung mit Herstellung Gründung (Bohrpfahl oder HEB-Träger)\nparalleles Arbeiten an beiden Kopflöchern",1,"St",2,"St/h",{"$f":"E30/G30*I$1","v":2.0833333333333332E-2},2.0833333333333332E-2,0,{"$f":"IF(K30=100%,L28,IF(K30>0%,M28-J28*K30,M28))","v":"2022-01-03T08:45:00"},{"$f":"L30+J30","v":"2022-01-03T09:15:00"},null,null,null,{"$f":"IF(L30=0,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(J30/I30<0.5,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(J30/I30>2.5,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(K30<0,\"Bitte prüfen\",IF(K30>1.5,\"Bitte prüfen\",\"\"))","v":""}]
[]
[{"$f":"MAX(A28:A31)+1","v":12},"Kopfloch herstellen Seite 2","03.06.01.01",null,1,"St",2,"St/h",{"$f":"E32/G32*I$1","v":2.0833333333333332E-2},2.0833333333333332E-2,1,{"$f":"IF(K32=100%,L30,IF(K32>0%,M30-J30*K32,M30))","v":"2022-01-03T08:45:00"},{"$f":"L32+J32","v":"2022-01-03T09:15:00"},null,null,null,{"$f":"IF(L32=0,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(J32/I32<0.5,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(J32/I32>2.5,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(K32<0,\"Bitte prüfen\",IF(K32>1.5,\"Bitte prüfen\",\"\"))","v":""}]
[]
[{"$f":"MAX(A30:A33)+1","v":13},"Verbauträger kürzen Seite 1","03.06.01.02","ca. 30 min pro Träger, 3-4 Träger je Seite",3,"St",2,"St/h",{"$f":"E34/G34*I$1","v":6.25E-2},6.25E-2,0,{"$f":"IF(K34=100%,L32,IF(K34>0%,M32-J32*K34,M32))","v":"2022-01-03T09:15:00"},{"$f":"L34+J34","v":"2022-01-03T10:45:00"},null,null,null,{"$f":"IF(L34=0,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(J34/I34<0.5,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(J34/I34>2.5,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(K34<0,\"Bitte prüfen\",IF(K34>1.5,\"Bitte prüfen\",\"\"))","v":""}]
[]
[{"$f":"MAX(A32:A35)+1","v":14},"Verbauträger kürzen Seite 2","03.06.01.02",null,3,"St",2,"St/h",{"$f":"E36/G36*I$1","v":6.25E-2},6.25E-2,1,{"$f":"IF(K36=100%,L34,IF(K36>0%,M34-J34*K36,M34))","v":"2022-01-03T09:15:00"},{"$f":"L36+J36","v":"2022-01-03T10:45:00"},null,null,null,{"$f":"IF(L36=0,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(J36/I36<0.5,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(J36/I36>2.5,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(K36<0,\"Bitte prüfen\",IF(K36>1.5,\"Bitte prüfen\",\"\"))","v":""}]
[]
[{"$f":"MAX(A34:A37)+1","v":15},"Auflagerplatte aufschweißen Seite 1","03.06.01.03",null,3,"St",1.25,"St/h",{"$f":"E38/G38*I$1","v":9.9999999999999992E-2},0.10416666666666667,0,{"$f":"IF(K38=100%,L36,IF(K38>0%,M36-J36*K38,M36))","v":"2022-01-03T10:45:00"},{"$f":"L38+J38","v":"2022-01-03T13:15:00"},null,null,null,{"$f":"IF(L38=0,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(J38/I38<0.5,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(J38/I38>2.5,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(K38<0,\"Bitte prüfen\",IF(K38>1.5,\"Bitte prüfen\",\"\"))","v":""}]
[]
[{"$f":"MAX(A36:A39)+1","v":16},"Auflagerplatte aufschweißen Seite 2","03.06.01.03",null,3,"St",1.25,"St/h",{"$f":"E40/G40*I$1","v":9.9999999999999992E-2},0.10416666666666667,1,{"$f":"IF(K40=100%,L38,IF(K40>0%,M38-J38*K40,M38))","v":"2022-01-03T10:45:00"},{"$f":"L40+J40","v":"2022-01-03T13:15:00"},null,null,null,{"$f":"IF(L40=0,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(J40/I40<0.5,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(J40/I40>2.5,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(K40<0,\"Bitte prüfen\",IF(K40>1.5,\"Bitte prüfen\",\"\"))","v":""}]
[]
[{"$f":"MAX(A38:A41)+1","v":17},"Auflagerträger aufsetzen und anschweißen Seite 1","03.06.01.04",null,1,"St",0.67,"St/h",{"$f":"E42/G42*I$1","v":6.2189054726368154E-2},6.25E-2,0,{"$f":"IF(K42=100%,L40,IF(K42>0%,M40-J40*K42,M40))","v":"2022-01-03T13:15:00"},{"$f":"L42+J42","v":"2022-01-03T14:45:00"},null,null,null,{"$f":"IF(L42=0,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(J42/I42<0.5,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(J42/I42>2.5,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(K42<0,\"Bitte prüfen\",IF(K42>1.5,\"Bitte prüfen\",\"\"))","v":""}]
[]
[{"$f":"MAX(A40:A43)+1","v":18},"Auflagerträger aufsetzen und anschweißen Seite 2","03.06.01.04",null,1,"St",0.67,"St/h",{"$f":"E44/G44*I$1","v":6.2189054726368154E-2},6.25E-2,1,{"$f":"IF(K44=100%,L42,IF(K44>0%,M42-J42*K44,M42))","v":"2022-01-03T13:15:00"},{"$f":"L44+J44","v":"2022-01-03T14:45:00"},null,null,null,{"$f":"IF(L44=0,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(J44/I44<0.5,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(J44/I44>2.5,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(K44<0,\"Bitte prüfen\",IF(K44>1.5,\"Bitte prüfen\",\"\"))","v":""}]
[]
[{"$f":"MAX(A44:A45)+1","v":19},"Lager einbauen, Auflager Seite 1","03.06.01.05",null,2,"St",0.5,"St/h",{"$f":"E46/G46*I$1","v":0.16666666666666666},0.16666666666666666,0,{"$f":"IF(K46=100%,L44,IF(K46>0%,M44-J44*K46,M44))","v":"2022-01-03T14:45:00"},{"$f":"L46+J46","v":"2022-01-03T18:45:00"},null,null,null,{"$f":"IF(L46=0,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(J46/I46<0.5,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(J46/I46>2.5,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(K46<0,\"Bitte prüfen\",IF(K46>1.5,\"Bitte prüfen\",\"\"))","v":""}]
[]
[{"$f":"MAX(A44:A47)+1","v":20},"Lager einbauen, Auflager Seite 2","03.06.01.05",null,2,"St",0.5,"St/h",{"$f":"E48/G48*I$1","v":0.16666666666666666},0.16666666666666666,1,{"$f":"IF(K48=100%,L46,IF(K48>0%,M46-J46*K48,M46))","v":"2022-01-03T14:45:00"},{"$f":"L48+J48","v":"2022-01-03T18:45:00"},null,null,null,{"$f":"IF(L48=0,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(J48/I48<0.5,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(J48/I48>2.5,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(K48<0,\"Bitte prüfen\",IF(K48>1.5,\"Bitte prüfen\",\"\"))","v":""}]
[]
[{"$f":"MAX(A46:A49)+1","v":21},"Hilfsbrücke auflegen","03.06.03.01",null,1,"St",0.75,"St/h",{"$f":"E50/G50*I$1","v":5.5555555555555552E-2},6.25E-2,0,{"$f":"IF(K50=100%,L48,IF(K50>0%,M48-J48*K50,M48))","v":"2022-01-03T18:45:00"},{"$f":"L50+J50","v":"2022-01-03T20:15:00"},null,null,null,{"$f":"IF(L50=0,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(J50/I50<0.5,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(J50/I50>2.5,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(K50<0,\"Bitte prüfen\",IF(K50>1.5,\"Bitte prüfen\",\"\"))","v":""}]
[]
[{"$f":"MAX(A48:A51)+1","v":22},"Auflagerknaggen für Druckträger anschweißen","03.03.07.04","Bei statischem Erfordernis!",4,"St",0.5,"St/h",{"$f":"E52/G52*I$1","v":0.33333333333333331},8.3333333333333329E-2,0.5,{"$f":"IF(K52=100%,L50,IF(K52>0%,M50-J50*K52,M50))","v":"2022-01-03T19:30:00"},{"$f":"L52+J52","v":"2022-01-03T21:30:00"},null,null,null,{"$f":"IF(L52=0,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(J52/I52<0.5,\"Bitte prüfen\",\"\")","v":"Bitte prüfen"},{"$f":"IF(J52/I52>2.5,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(K52<0,\"Bitte prüfen\",IF(K52>1.5,\"Bitte prüfen\",\"\"))","v":""}]
[null,null,null,"4 Schweißer parallel und 1 ZWB je Seite am Arbeiten"]
[{"$f":"MAX(A50:A53)+1","v":23},"Druckträger für Aussteifungsrahmen einheben und auf die Knaggen setzen (keine Sperrung erf.)","03.03.07.05","Bei statischem Erfordernis!",2,"St",1,"St/h",{"$f":"E54/G54*I$1","v":8.3333333333333329E-2},8.3333333333333329E-2,0,{"$f":"IF(K54=100%,L52,IF(K54>0%,M52-J52*K54,M52))","v":"2022-01-03T21:30:00"},{"$f":"L54+J54","v":"2022-01-03T23:30:00"},null,null,null,{"$f":"IF(L54=0,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(J54/I54<0.5,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(J54/I54>2.5,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(K54<0,\"Bitte prüfen\",IF(K54>1.5,\"Bitte prüfen\",\"\"))","v":""}]
[null,null,null,null,null,null,null,"Dauer Einheben je Träger mit Autokran: 1,0 h"]
[{"$f":"MAX(A52:A55)+1","v":24},"Druckträgerauflager verschweißen","03.03.07.06","Bei statischem Erfordernis! \n2 Träger mit 4 Schweißungen",4,"St",0.5,"St/h",{"$f":"E56/G56*I$1","v":0.33333333333333331},8.3333333333333329E-2,0.75,{"$f":"IF(K56=100%,L54,IF(K56>0%,M54-J54*K56,M54))","v":"2022-01-03T22:00:00"},{"$f":"L56+J56","v":"2022-01-04"},null,3,null,{"$f":"IF(L56=0,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(J56/I56<0.5,\"Bitte prüfen\",\"\")","v":"Bitte prüfen"},{"$f":"IF(J56/I56>2.5,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(K56<0,\"Bitte prüfen\",IF(K56>1.5,\"Bitte prüfen\",\"\"))","v":""}]
[null,null,null,"4 Schweißer parallel am Arbeiten",null,null,null,"4 Schweißer"]
[{"$f":"MAX(A54:A57)+1","v":25},"Randweg auf der Hilfsbrücke einbauen (einseitig)","03.06.03.02","einseitiger Randweg: Rungen ausklappen",20,"m",10,"m/h",{"$f":"E58/G58*I$1","v":8.3333333333333329E-2},8.3333333333333329E-2,1,{"$f":"IF(K58=100%,L56,IF(K58>0%,M56-J56*K58,M56))","v":"2022-01-03T22:00:00"},{"$f":"L58+J58","v":"2022-01-04"},null,null,null,{"$f":"IF(L58=0,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(J58/I58<0.5,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(J58/I58>2.5,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(K58<0,\"Bitte prüfen\",IF(K58>1.5,\"Bitte prüfen\",\"\"))","v":""}]
[]
[{"$f":"MAX(A56:A59)+1","v":26},"Verbaubleche (Schotterhalterung) ergänzen Seite 1","03.06.04.01","ggf. mit anderen Gewerken parallel",1,"St",1.2,"St/h",{"$f":"E60/G60*I$1","v":3.4722222222222224E-2},3.125E-2,0,{"$f":"IF(K60=100%,L58,IF(K60>0%,M58-J58*K60,M58))","v":"2022-01-04"},{"$f":"L60+J60","v":"2022-01-04T00:45:00"},null,null,null,{"$f":"IF(L60=0,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(J60/I60<0.5,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(J60/I60>2.5,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(K60<0,\"Bitte prüfen\",IF(K60>1.5,\"Bitte prüfen\",\"\"))","v":""}]
[]
[{"$f":"MAX(A58:A61)+1","v":27},"Verbaubleche (Schotterhalterung) ergänzen Seite 2","03.06.04.01",null,1,"St",1.2,"St/h",{"$f":"E62/G62*I$1","v":3.4722222222222224E-2},3.125E-2,1,{"$f":"IF(K62=100%,L60,IF(K62>0%,M60-J60*K62,M60))","v":"2022-01-04"},{"$f":"L62+J62","v":"2022-01-04T00:45:00"},null,null,null,{"$f":"IF(L62=0,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(J62/I62<0.5,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(J62/I62>2.5,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(K62<0,\"Bitte prüfen\",IF(K62>1.5,\"Bitte prüfen\",\"\"))","v":""}]
[]
[{"$f":"MAX(A60:A63)+1","v":28},"Kopfloch verfüllen und verdichten Seite 1","03.06.04.02",null,1,"St",1.2,"St/h",{"$f":"E64/G64*I$1","v":3.4722222222222224E-2},3.125E-2,0,{"$f":"IF(K64=100%,L62,IF(K64>0%,M62-J62*K64,M62))","v":"2022-01-04T00:45:00"},{"$f":"L64+J64","v":"2022-01-04T01:30:00"},null,null,null,{"$f":"IF(L64=0,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(J64/I64<0.5,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(J64/I64>2.5,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(K64<0,\"Bitte prüfen\",IF(K64>1.5,\"Bitte prüfen\",\"\"))","v":""}]
[]
[{"$f":"MAX(A62:A65)+1","v":29},"Kopfloch verfüllen und verdichtenSeite 2","03.06.04.02",null,1,"St",1.2,"St/h",{"$f":"E66/G66*I$1","v":3.4722222222222224E-2},3.125E-2,1,{"$f":"IF(K66=100%,L64,IF(K66>0%,M64-J64*K66,M64))","v":"2022-01-04T00:45:00"},{"$f":"L66+J66","v":"2022-01-04T01:30:00"},null,null,null,{"$f":"IF(L66=0,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(J66/I66<0.5,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(J66/I66>2.5,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(K66<0,\"Bitte prüfen\",IF(K66>1.5,\"Bitte prüfen\",\"\"))","v":""}]
[]
[{"$f":"MAX(A64:A67)+1","v":30},"Grundschotter einbauen Seite 1","02.02.04.04","z.B. vom Lkw oder Flachwagen mit klappbaren Seitenborden vor Kopf",15,"m3",30,"m3/h",{"$f":"E68/G68*I$1","v":2.0833333333333332E-2},2.0833333333333332E-2,0,{"$f":"IF(K68=100%,L66,IF(K68>0%,M66-J66*K68,M66))","v":"2022-01-04T01:30:00"},{"$f":"L68+J68","v":"2022-01-04T02:00:00"},null,null,null,{"$f":"IF(L68=0,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(J68/I68<0.5,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(J68/I68>2.5,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(K68<0,\"Bitte prüfen\",IF(K68>1.5,\"Bitte prüfen\",\"\"))","v":""}]
[]
[{"$f":"MAX(A66:A69)+1","v":31},"Grundschotter einbauen Seite 2","02.02.04.04",null,15,"m3",30,"m3/h",{"$f":"E70/G70*I$1","v":2.0833333333333332E-2},2.0833333333333332E-2,1,{"$f":"IF(K70=100%,L68,IF(K70>0%,M68-J68*K70,M68))","v":"2022-01-04T01:30:00"},{"$f":"L70+J70","v":"2022-01-04T02:00:00"},null,null,null,{"$f":"IF(L70=0,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(J70/I70<0.5,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(J70/I70>2.5,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(K70<0,\"Bitte prüfen\",IF(K70>1.5,\"Bitte prüfen\",\"\"))","v":""}]
[]
[{"$f":"MAX(A68:A71)+1","v":32},"Schwellen auslegen Seite 1","02.02.06.01","6 Schwellen je Seite",6,"St",25,"St/h",{"$f":"E72/G72*I$1","v":9.9999999999999985E-3},1.0416666666666666E-2,0,{"$f":"IF(K72=100%,L70,IF(K72>0%,M70-J70*K72,M70))","v":"2022-01-04T02:00:00"},{"$f":"L72+J72","v":"2022-01-04T02:15:00"},null,null,null,{"$f":"IF(L72=0,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(J72/I72<0.5,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(J72/I72>2.5,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(K72<0,\"Bitte prüfen\",IF(K72>1.5,\"Bitte prüfen\",\"\"))","v":""}]
[null,null,null,"Holzschwellen empfohlen wegen Elastizität"]
[{"$f":"MAX(A70:A73)+1","v":33},"Schwellen auslegen Seite 2","02.02.06.01","6 Schwellen je Seite",6,"St",25,"St/h",{"$f":"E74/G74*I$1","v":9.9999999999999985E-3},1.0416666666666666E-2,1,{"$f":"IF(K74=100%,L72,IF(K74>0%,M72-J72*K74,M72))","v":"2022-01-04T02:00:00"},{"$f":"L74+J74","v":"2022-01-04T02:15:00"},null,null,null,{"$f":"IF(L74=0,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(J74/I74<0.5,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(J74/I74>2.5,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(K74<0,\"Bitte prüfen\",IF(K74>1.5,\"Bitte prüfen\",\"\"))","v":""}]
[null,null,null,"Holzschwellen empfohlen wegen Elastizität"]
[{"$f":"MAX(A72:A75)+1","v":34},"Schienen verziehen, auflegen und verspannen","02.02.06.03","für Kleinstmenge halben Wert ansetzen",60,"m",120,"m/h",{"$f":"E76/G76*I$1","v":2.0833333333333332E-2},2.0833333333333332E-2,0,{"$f":"IF(K76=100%,L74,IF(K76>0%,M74-J74*K76,M74))","v":"2022-01-04T02:15:00"},{"$f":"L76+J76","v":"2022-01-04T02:45:00"},null,null,null,{"$f":"IF(L76=0,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(J76/I76<0.5,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(J76/I76>2.5,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(K76<0,\"Bitte prüfen\",IF(K76>1.5,\"Bitte prüfen\",\"\"))","v":""}]
[]
[{"$f":"MAX(A74:A77)+1","v":35},"Füllschotter einbauen mit offenem Schüttgutwagen mit dosierbarer Schwerkraftentladung (z.B. Fc-Wagen)","02.04.02.01","Anrampung 15 mm über geplanter Gleislage wegen Setzung",40,"m",44,"m/h",{"$f":"E78/G78*I$1","v":3.7878787878787873E-2},4.1666666666666664E-2,0,{"$f":"IF(K78=100%,L76,IF(K78>0%,M76-J76*K78,M76))","v":"2022-01-04T02:45:00"},{"$f":"L78+J78","v":"2022-01-04T03:45:00"},null,null,null,{"$f":"IF(L78=0,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(J78/I78<0.5,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(J78/I78>2.5,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(K78<0,\"Bitte prüfen\",IF(K78>1.5,\"Bitte prüfen\",\"\"))","v":""}]
[]
[{"$f":"MAX(A76:A79)+1","v":36},"Gleis stopfen (1. Stabilisierung) maschinell)","02.04.02.02",null,30,"m",70,"m/h",{"$f":"E80/G80*I$1","v":1.7857142857142856E-2},2.0833333333333332E-2,0,{"$f":"IF(K80=100%,L78,IF(K80>0%,M78-J78*K80,M78))","v":"2022-01-04T03:45:00"},{"$f":"L80+J80","v":"2022-01-04T04:15:00"},null,null,null,{"$f":"IF(L80=0,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(J80/I80<0.5,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(J80/I80>2.5,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(K80<0,\"Bitte prüfen\",IF(K80>1.5,\"Bitte prüfen\",\"\"))","v":""}]
[]
[{"$f":"MAX(A78:A81)+1","v":37},"Gleis stopfen (2. Stabilisierung) maschinell)","02.04.02.03",null,50,"m",90,"m/h",{"$f":"E82/G82*I$1","v":2.3148148148148147E-2},2.0833333333333332E-2,0,{"$f":"IF(K82=100%,L80,IF(K82>0%,M80-J80*K82,M80))","v":"2022-01-04T04:15:00"},{"$f":"L82+J82","v":"2022-01-04T04:45:00"},null,null,null,{"$f":"IF(L82=0,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(J82/I82<0.5,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(J82/I82>2.5,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(K82<0,\"Bitte prüfen\",IF(K82>1.5,\"Bitte prüfen\",\"\"))","v":""}]
[]
[{"$f":"MAX(A80:A83)+1","v":38},"aluminotherm. Schweißen (Skv) 24-26 mm Lückenweite für alle Profile","02.01.02.01","Annahme 4 Schweißungen (1 Trupp)",4,"St",2,"St/h",{"$f":"E84/G84*I$1","v":8.3333333333333329E-2},8.3333333333333329E-2,0,{"$f":"IF(K84=100%,L82,IF(K84>0%,M82-J82*K84,M82))","v":"2022-01-04T04:45:00"},{"$f":"L84+J84","v":"2022-01-04T06:45:00"},null,null,null,{"$f":"IF(L84=0,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(J84/I84<0.5,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(J84/I84>2.5,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(K84<0,\"Bitte prüfen\",IF(K84>1.5,\"Bitte prüfen\",\"\"))","v":""}]
[]
[39,"Feinschliff","02.01.02.06","1 Trupp",4,"St",4,"St/h",{"$f":"E86/G86*I$1","v":4.1666666666666664E-2},4.1666666666666664E-2,0,{"$f":"IF(K86=100%,L84,IF(K86>0%,M84-J84*K86,M84))","v":"2022-01-04T06:45:00"},{"$f":"L86+J86","v":"2022-01-04T07:45:00"}]
[]
[{"$f":"MAX(A84:A87)+1","v":40},"Spannungsausgleich ohne Schlussschweißung herstellen","02.01.03.03","2x 150 m Spannungsausgleich (2x Wärmeröhren / 2 Trupps)",300,"m",115,"m/h",{"$f":"E88/G88*I$1","v":0.10869565217391304},0.10416666666666667,0.5,{"$f":"IF(K88=100%,L84,IF(K88>0%,M84-J84*K88,M84))","v":"2022-01-04T05:45:00"},{"$f":"L88+J88","v":"2022-01-04T08:15:00"},null,null,null,{"$f":"IF(L88=0,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(J88/I88<0.5,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(J88/I88>2.5,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(K88<0,\"Bitte prüfen\",IF(K88>1.5,\"Bitte prüfen\",\"\"))","v":""}]
[]
[{"$f":"MAX(A84:A89)+1","v":41},"Gleisschaltmittel  (Achszähler, PZB, Linienleiter, Balisen etc.) anbauen","07.01.03.01.01","abhängig vom Umfang LST, Einbindung Fachplanung erforderlich",2,"St",3,"St/h",{"$f":"E90/G90*I$1","v":2.7777777777777776E-2},4.1666666666666664E-2,0,{"$f":"IF(K90=100%,L88,IF(K90>0%,M88-J88*K90,M88))","v":"2022-01-04T08:15:00"},{"$f":"L90+J90","v":"2022-01-04T09:15:00"},null,null,null,{"$f":"IF(L90=0,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(J90/I90<0.5,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(J90/I90>2.5,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(K90<0,\"Bitte prüfen\",IF(K90>1.5,\"Bitte prüfen\",\"\"))","v":""}]
[null,null,null,null,null," Annahme getroffen"]
[42,"Erdungseinrichtungen (Schienen-, Gleisverbinder, Betriebserden etc.) anbauen einschl. Hilfsbrücke erden","06.08.01.01",null,2,"St",4,"St/h",{"$f":"E92/G92*I$1","v":2.0833333333333332E-2},2.0833333333333332E-2,0,{"$f":"M90","v":"2022-01-04T09:15:00"},{"$f":"L92+J92*(1-K92)","v":"2022-01-04T09:45:00"},null,null,null,{"$f":"IF(L92=0,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(J92/I92<0.5,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(J92/I92>2.5,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(K92<0,\"Bitte prüfen\",IF(K92>1.5,\"Bitte prüfen\",\"\"))","v":""}]
[null,null,null,null,null," Annahme getroffen"]
[43,"OLA zurückschwenken","06.01.01.01",null,90,"m",60,"m/h",{"$f":"E94/G94*I$1","v":6.25E-2},6.25E-2,0,{"$f":"IF(K94=100%,L92,IF(K94>0%,M92-J92*K94,M92))","v":"2022-01-04T09:45:00"},{"$f":"L94+J94","v":"2022-01-04T11:15:00"},null,null,null,{"$f":"IF(L94=0,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(J94/I94<0.5,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(J94/I94>2.5,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(K94<0,\"Bitte prüfen\",IF(K94>1.5,\"Bitte prüfen\",\"\"))","v":""}]
[]
[44,"ggf. Prüfung, ob Abnahmehandlungen (LST) notwendig sind","07.01.08.01","Achszähler",1,"St",2,"St/h",{"$f":"E96/G96*I$1","v":2.0833333333333332E-2},2.0833333333333332E-2,0,{"$f":"IF(K96=100%,L94,IF(K96>0%,M94-J94*K96,M94))","v":"2022-01-04T11:15:00"},{"$f":"L96+J96","v":"2022-01-04T11:45:00"},null,null,null,{"$f":"IF(L96=0,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(J96/I96<0.5,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(J96/I96>2.5,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(K96<0,\"Bitte prüfen\",IF(K96>1.5,\"Bitte prüfen\",\"\"))","v":""}]
[null,null,null,null,null," Annahme getroffen"]
[45,"Prüf- und Belastungsfahrten durchführen","08.02.01.01","Eventualposition ggf. schon durch Fahrt mit Arbeitszug (Stopfmaschine) innerhalb der Sperrung möglich.",1,"St",2,"St/h",{"$f":"E98/G98*I$1","v":2.0833333333333332E-2},2.0833333333333332E-2,0,{"$f":"IF(K98=100%,L96,IF(K98>0%,M96-J96*K98,M96))","v":"2022-01-04T11:45:00"},{"$f":"L98+J98","v":"2022-01-04T12:15:00"},null,null,null,{"$f":"IF(L98=0,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(J98/I98<0.5,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(J98/I98>2.5,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(K98<0,\"Bitte prüfen\",IF(K98>1.5,\"Bitte prüfen\",\"\"))","v":""}]
[]
[46,"ggf. Prüfung La-Einrichtung entsprechend VzG und Planung, ggf. Geschwindigkeitsüberwachung (GÜ - PZB-Magnete) für La auf HB","07.01.02.03","keine baulichen Veränderungen an der Anlage gegenüber dem Urzustand",6,"St",4,"St/h",{"$f":"E100/G100*I$1","v":6.25E-2},6.25E-2,0.5,{"$f":"IF(K100=100%,L98,IF(K100>0%,M98-J98*K100,M98))","v":"2022-01-04T12:00:00"},{"$f":"L100+J100","v":"2022-01-04T13:30:00"},null,null,null,{"$f":"IF(L100=0,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(J100/I100<0.5,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(J100/I100>2.5,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(K100<0,\"Bitte prüfen\",IF(K100>1.5,\"Bitte prüfen\",\"\"))","v":""}]
[]
[47,"Erdungsvorrichtung ausbauen und Oberleitung einschalten (1 Schaltgruppe)","08.01.02.02",null,2,"psch",4,"psch/h",{"$f":"E102/G102*I$1","v":2.0833333333333332E-2},2.0833333333333332E-2,0.5,{"$f":"IF(K102=100%,L100,IF(K102>0%,M100-J100*K102,M100))","v":"2022-01-04T12:45:00"},{"$f":"L102+J102","v":"2022-01-04T13:15:00"},null,null,null,{"$f":"IF(L102=0,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(J102/I102<0.5,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(J102/I102>2.5,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(K102<0,\"Bitte prüfen\",IF(K102>1.5,\"Bitte prüfen\",\"\"))","v":""}]
[]
[48,"Sperrung aufheben","08.01.01.02",null,1,"psch",2,"psch/h",{"$f":"E104/G104*I$1","v":2.0833333333333332E-2},2.0833333333333332E-2,0,{"$f":"IF(K104=100%,L102,IF(K104>0%,M102-J102*K104,M102))","v":"2022-01-04T13:15:00"},{"$f":"L104+J104","v":"2022-01-04T13:45:00"},null,null,null,{"$f":"IF(L104=0,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(J104/I104<0.5,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(J104/I104>2.5,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(K104<0,\"Bitte prüfen\",IF(K104>1.5,\"Bitte prüfen\",\"\"))","v":""}]
[]
[49,"Nacharbeiten festlegen (Hilfsbrückenübergänge stopfen)",null,"ca. alle 8 Wochen, je nach Belastung zu berücksichtigen",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(L106=0,\"Bitte prüfen\",\"\")","v":"Bitte prüfen"},{"$f":"IF(J106/I106<0.5,\"Bitte prüfen\",\"\")","v":{"$error":"#DIV/0!"}},{"$f":"IF(J106/I106>2.5,\"Bitte prüfen\",\"\")","v":{"$error":"#DIV/0!"}},{"$f":"IF(K106<0,\"Bitte prüfen\",IF(K106>1.5,\"Bitte prüfen\",\"\"))","v":""}]
[null,null,null,"ggf. Messeinrichtung Lageüberwachung bei Hilfsbrücken in Bögen oder Hilfsbrückenkette",null,null,null,null,null,null,null,null,null,null,{"$f":"M104-L1","v":1.6145833333575865}]

{"sheet":"Ausbau HB","index":1,"n_rows":109,"n_cols":20,"rows_kept":109,"cut":false,"hidden":false,"merged":[[0,11,0,12],[0,9,0,10]]}
["Projekt","Ausbau Hilfsbrücke und Einschub vorgefertigter Überbau",null,null,null,null,null,"Uhrzeit-berechnung:","01:00:00","Start (Datum/Uhrzeit) eingeben:",null,"2022-01-02T23:00:00"]
["Vor-gangs-\nNr.","Vorgangsbezeichnung","Position Katalog","Hinweise/Bemerkungen","Leistungs-menge","Einheit Leistungs-menge\nErläuterung","Leistungs-wert Katalog","Einheit Leistungswert\nErläuterung ","Dauer (rechn.)","Dauer (gewählt)","Para-llelität\nin %","Beginn","Ende","Bemerkung","Tag-wechsel",null,"Prüfung Anfangszeit","Prüfung Dauer gewählt\nzu klein","Prüfung Dauer gewählt\nzu groß","Prüfung Parallelität"]
[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,null,16,17,18,19]
[0,"Vorbereitende Maßnahmen definieren, z.B.  Vorbereiten Verschubbahn im Baufeld bis vor HB",null,"Im Vorfeld in einer gesonderten (Gleis-)Sperrung zu realisieren.",null,null,null,null,null,null,null,null,null,null,0,null,{"$f":"IF(L4=0,\"Bitte prüfen\",\"\")","v":"Bitte prüfen"},{"$f":"IF(J4/I4<0.5,\"Bitte prüfen\",\"\")","v":{"$error":"#DIV/0!"}},{"$f":"IF(J4/I4>2.5,\"Bitte prüfen\",\"\")","v":{"$error":"#DIV/0!"}},{"$f":"IF(K4<0,\"Bitte prüfen\",IF(K4>1.5,\"Bitte prüfen\",\"\"))","v":""}]
[]
[{"$f":"MAX(A4:A5)+1","v":1},"Sperrung einrichten","08.01.01.01","Regelungen Betra beachten",1,"psch",2,"psch/h",{"$f":"E6/G6*I$1","v":2.0833333333333332E-2},2.0833333333333332E-2,0,{"$f":"L1","v":"2022-01-02T23:00:00"},{"$f":"L6+J6","v":"2022-01-02T23:30:00"},null,1,null,{"$f":"IF(L6=0,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(J6/I6<0.5,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(J6/I6>2.5,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(K6<0,\"Bitte prüfen\",IF(K6>1.5,\"Bitte prüfen\",\"\"))","v":""}]
[]
[{"$f":"MAX(A4:A7)+1","v":2},"Oberleitung abschalten und Erdungs-vorrichtung einbauen (1 Schaltgruppe)","08.01.02.01",null,2,"psch",4,"psch/h",{"$f":"E8/G8*I$1","v":2.0833333333333332E-2},2.0833333333333332E-2,0.5,{"$f":"IF(K8=100%,L6,IF(K8>0%,M6-J6*K8,M6))","v":"2022-01-02T23:15:00"},{"$f":"L8+J8","v":"2022-01-02T23:45:00"},null,null,null,{"$f":"IF(L8=0,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(J8/I8<0.5,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(J8/I8>2.5,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(K8<0,\"Bitte prüfen\",IF(K8>1.5,\"Bitte prüfen\",\"\"))","v":""}]
[null,null,null,"Teilparallelität zu Vorgang Nr. 1"]
[{"$f":"MAX(A6:A9)+1","v":3},"Gleisschaltmittel  (Achszähler, PZB, Linienleiter, Balisen etc.) abbauen","07.01.02.02/ 07.01.02.05/ 07.01.03.02","kann ggf. zu Bahnerdung parallel laufen (kein ZWB - nur Personal)",3,"St",3,"psch/h",{"$f":"E10/G10*I$1","v":4.1666666666666664E-2},4.1666666666666664E-2,1,{"$f":"IF(K10=100%,L8,IF(K10>0%,M8-J8*K10,M8))","v":"2022-01-02T23:15:00"},{"$f":"L10+J10","v":"2022-01-03T00:15:00"},null,2,null,{"$f":"IF(L10=0,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(J10/I10<0.5,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(J10/I10>2.5,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(K10<0,\"Bitte prüfen\",IF(K10>1.5,\"Bitte prüfen\",\"\"))","v":""}]
[null,null,null,"Der Vorgang kann frühestens parallel zu Vorgang 2 beginnen",null," Annahme getroffen"]
[{"$f":"MAX(A8:A11)+1","v":4},"Erdungseinrichtungen (Schienen-, Gleisverbinder, Betriebserden etc.) abbauen ","06.08.02.03","absolute Parallelität zu Vorgang Nr. 3, jedoch muss der Vorgang Nr. 2 vorher abgeschlossen sein.",2,"St",4,"St/h",{"$f":"E12/G12*I$1","v":2.0833333333333332E-2},2.0833333333333332E-2,1,"2022-01-02T23:45:00",{"$f":"L12+J12","v":"2022-01-03T00:15:00"},"Beginnzeit händisch gesetzt, da Vorgang 2 abgeschlossen sein muss.",null,null,{"$f":"IF(L12=0,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(J12/I12<0.5,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(J12/I12>2.5,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(K12<0,\"Bitte prüfen\",IF(K12>1.5,\"Bitte prüfen\",\"\"))","v":""}]
[null,null,null,null,null,null,null,"Leistungsmenge stark abhängig von der Lage des Bauwerks"]
[{"$f":"MAX(A10:A13)+1","v":5},"Rückstromführung montieren","06.08.01.07","Rücksprache mit Fachplaner, ob die Leistung erforderlich ist!",2,"St",1,"St/h",{"$f":"E14/G14*I$1","v":8.3333333333333329E-2},8.3333333333333329E-2,0.5,{"$f":"IF(K14=100%,L12,IF(K14>0%,M12-J12*K14,M12))","v":"2022-01-03"},{"$f":"L14+J14","v":"2022-01-03T02:00:00"},null,null,null,{"$f":"IF(L14=0,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(J14/I14<0.5,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(J14/I14>2.5,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(K14<0,\"Bitte prüfen\",IF(K14>1.5,\"Bitte prüfen\",\"\"))","v":""}]
[null,null,null,"Teilparallelität zu Vorgang Nr. 4"]
[{"$f":"MAX(A14:A15)+1","v":6},"OLA aus-/verschwenken/verziehen","06.01.01.01","ca. 60 min freie Strecke, ca 120 min Bahnhof",90,"m",60,"m/h",{"$f":"E16/G16*I$1","v":6.25E-2},6.25E-2,0,{"$f":"IF(K16=100%,L14,IF(K16>0%,M14-J14*K16,M14))","v":"2022-01-03T02:00:00"},{"$f":"L16+J16","v":"2022-01-03T03:30:00"},null,null,null,{"$f":"IF(L16=0,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(J16/I16<0.5,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(J16/I16>2.5,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(K16<0,\"Bitte prüfen\",IF(K16>1.5,\"Bitte prüfen\",\"\"))","v":""}]
[null,null,null,"in der Regel 2 Kettenwerkslängen"]
[{"$f":"MAX(A16:A17)+1","v":7},"Randweg auf der Hilfsbrücke (einseitig) ausbauen","03.06.05.04","einseitiger Randweg: Rungen umklappen",20,"m",20,"m/h",{"$f":"E18/G18*I$1","v":4.1666666666666664E-2},4.1666666666666664E-2,0,{"$f":"IF(K18=100%,L16,IF(K18>0%,M16-J16*K18,M16))","v":"2022-01-03T03:30:00"},{"$f":"L18+J18","v":"2022-01-03T04:30:00"},null,null,null,{"$f":"IF(L18=0,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(J18/I18<0.5,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(J18/I18>2.5,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(K18<0,\"Bitte prüfen\",IF(K18>1.5,\"Bitte prüfen\",\"\"))","v":""}]
[]
[{"$f":"MAX(A16:A19)+1","v":8},"Schienen trennen/schneiden (Trennschnitt)","02.01.01.01","zur Wiederverwendung je 2 Schnitte recht, links",4,"St",6,"St/h",{"$f":"E20/G20*I$1","v":2.7777777777777776E-2},3.125E-2,0,{"$f":"IF(K20=100%,L18,IF(K20>0%,M18-J18*K20,M18))","v":"2022-01-03T04:30:00"},{"$f":"L20+J20","v":"2022-01-03T05:15:00"},null,null,null,{"$f":"IF(L20=0,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(J20/I20<0.5,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(J20/I20>2.5,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(K20<0,\"Bitte prüfen\",IF(K20>1.5,\"Bitte prüfen\",\"\"))","v":""}]
[null,null,null,"Trennschnitte vor der Hilfsbrücke in Abhänigkeit von der Geschwindigkeit 3, 5 oder 10 m (Schwellenteilung)"]
[{"$f":"MAX(A18:A21)+1","v":9},"Schienen lösen und verziehen","02.02.02.01","Schiene lösen mit Schrauber (2 Trupps á 2 Leute)",70,"2 x  30-40 m ",150,"m/h",{"$f":"E22/G22*I$1","v":1.9444444444444445E-2},2.0833333333333332E-2,0,{"$f":"IF(K22=100%,L20,IF(K22>0%,M20-J20*K22,M20))","v":"2022-01-03T05:15:00"},{"$f":"L22+J22","v":"2022-01-03T05:45:00"},null,null,null,{"$f":"IF(L22=0,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(J22/I22<0.5,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(J22/I22>2.5,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(K22<0,\"Bitte prüfen\",IF(K22>1.5,\"Bitte prüfen\",\"\"))","v":""}]
[null,null,null,null,null,"Schiene",null,"pro Schiene"]
[{"$f":"MAX(A22:A23)+1","v":10},"Regelfall: Holzschwellen ausbauen, transportieren und lagern","02.02.01.01","3 Stück am Haken (10-15 min); abhängig von Beton- oder Holzschwelle",40,"30 - 40 m",55,"m/h",{"$f":"E24/G24*I$1","v":3.0303030303030304E-2},3.125E-2,0,{"$f":"IF(K24=100%,L22,IF(K24>0%,M22-J22*K24,M22))","v":"2022-01-03T05:45:00"},{"$f":"L24+J24","v":"2022-01-03T06:30:00"},null,null,null,{"$f":"IF(L24=0,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(J24/I24<0.5,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(J24/I24>2.5,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(K24<0,\"Bitte prüfen\",IF(K24>1.5,\"Bitte prüfen\",\"\"))","v":""}]
[null,null,null,null,null," Gleis",null,"Zwei 2-Wege-Bagger im Einsatz"]
["10a","Alternativ: Montageschiene aufschrauben","02.02.07.01",null,40,"30 - 40 m",70,"m/h",{"$f":"E26/G26*I$1","v":2.3809523809523808E-2},2.0833333333333332E-2,1,null,null,"Keine Zeiten eingetragen, da Alternative für Pos. 9",null,null,{"$f":"IF(L26=0,\"Bitte prüfen\",\"\")","v":"Bitte prüfen"},{"$f":"IF(J26/I26<0.5,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(J26/I26>2.5,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(K26<0,\"Bitte prüfen\",IF(K26>1.5,\"Bitte prüfen\",\"\"))","v":""}]
[null,null,null,null,null," Gleis"]
["10b","Alternativ: Jochweise (10 m) rausheben, transportieren und lagern","02.02.01.04","6m Betonschwellen, 10m Holzschwellen",40,"30 - 40 m",60,"m/h",{"$f":"E28/G28*I$1","v":2.7777777777777776E-2},3.125E-2,1,null,null,"Keine Zeiten eingetragen, da Alternative für Pos. 9",null,null,{"$f":"IF(L28=0,\"Bitte prüfen\",\"\")","v":"Bitte prüfen"},{"$f":"IF(J28/I28<0.5,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(J28/I28>2.5,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(K28<0,\"Bitte prüfen\",IF(K28>1.5,\"Bitte prüfen\",\"\"))","v":""}]
[null,null,null,null,null," Gleis"]
[{"$f":"MAX(A22:A29)+1","v":11},"Schotter ausbauen","02.02.03.06","hier als Beispiel Kleinstmengen Verladung auf Res-Wagen vor Kopf",80,"75 - 100 m3",30,"m/h",{"$f":"E30/G30*I$1","v":0.1111111111111111},0.125,0,{"$f":"IF(K30=100%,L24,IF(K30>0%,M24-J24*K30,M24))","v":"2022-01-03T06:30:00"},{"$f":"L30+J30","v":"2022-01-03T09:30:00"},null,null,null,{"$f":"IF(L30=0,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(J30/I30<0.5,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(J30/I30>2.5,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(K30<0,\"Bitte prüfen\",IF(K30>1.5,\"Bitte prüfen\",\"\"))","v":""}]
[null,null,null,"Beginn mit spätestem Ende der Vorgänge 10, 11, 12"]
[{"$f":"MAX(A28:A31)+1","v":12},"Kopfloch freilegen Seite 1","03.06.01.01","Verbau zum Nachbargleis in vorheriger Sperrpause in Verbindung mit Herstellung Gründung (Bohrpfahl oder HEB-Träger)\nparalleles Arbeiten an beiden Kopflöchern",1,"St",2,"St/h",{"$f":"E32/G32*I$1","v":2.0833333333333332E-2},2.0833333333333332E-2,0,{"$f":"IF(K32=100%,L30,IF(K32>0%,M30-J30*K32,M30))","v":"2022-01-03T09:30:00"},{"$f":"L32+J32","v":"2022-01-03T10:00:00"},null,null,null,{"$f":"IF(L32=0,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(J32/I32<0.5,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(J32/I32>2.5,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(K32<0,\"Bitte prüfen\",IF(K32>1.5,\"Bitte prüfen\",\"\"))","v":""}]
[]
[{"$f":"MAX(A30:A33)+1","v":13},"Kopfloch freilegen Seite 2","03.06.01.01",null,1,"St",2,"St/h",{"$f":"E34/G34*I$1","v":2.0833333333333332E-2},2.0833333333333332E-2,1,{"$f":"IF(K34=100%,L32,IF(K34>0%,M32-J32*K34,M32))","v":"2022-01-03T09:30:00"},{"$f":"L34+J34","v":"2022-01-03T10:00:00"},null,null,null,{"$f":"IF(L34=0,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(J34/I34<0.5,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(J34/I34>2.5,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(K34<0,\"Bitte prüfen\",IF(K34>1.5,\"Bitte prüfen\",\"\"))","v":""}]
[]
[{"$f":"MAX(A32:A35)+1","v":14},"Hilfsbrücke ausheben","03.06.05.01","vor der Sperrpause Rückbau der Ausbohlung zwischen den Hauptträgern von unten",1,"St",1,"St/h",{"$f":"E36/G36*I$1","v":4.1666666666666664E-2},4.1666666666666664E-2,0,{"$f":"IF(K36=100%,L34,IF(K36>0%,M34-J34*K36,M34))","v":"2022-01-03T10:00:00"},{"$f":"L36+J36","v":"2022-01-03T11:00:00"},null,null,null,{"$f":"IF(L36=0,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(J36/I36<0.5,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(J36/I36>2.5,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(K36<0,\"Bitte prüfen\",IF(K36>1.5,\"Bitte prüfen\",\"\"))","v":""}]
[]
[{"$f":"MAX(A34:A37)+1","v":15},"Aussteifungsrahmen trennen und ausbauen","03.06.05.06","Rückbau: 3x Druckträger + Blech je Hilfsbrücke (konstruktiv)",3,"St",1,"St/h",{"$f":"E38/G38*I$1","v":0.125},0.125,0,{"$f":"IF(K38=100%,L36,IF(K38>0%,M36-J36*K38,M36))","v":"2022-01-03T11:00:00"},{"$f":"L38+J38","v":"2022-01-03T14:00:00"},null,null,null,{"$f":"IF(L38=0,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(J38/I38<0.5,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(J38/I38>2.5,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(K38<0,\"Bitte prüfen\",IF(K38>1.5,\"Bitte prüfen\",\"\"))","v":""}]
[]
[{"$f":"MAX(A36:A39)+1","v":16},"Verbaubleche (Schotterhalterung) ziehen Seite 1","03.06.05.07","ggf. mit anderen Gewerken parallel",1,"St",6,"St/h",{"$f":"E40/G40*I$1","v":6.9444444444444441E-3},1.0416666666666666E-2,0,{"$f":"IF(K40=100%,L38,IF(K40>0%,M38-J38*K40,M38))","v":"2022-01-03T14:00:00"},{"$f":"L40+J40","v":"2022-01-03T14:15:00"},null,null,null,{"$f":"IF(L40=0,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(J40/I40<0.5,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(J40/I40>2.5,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(K40<0,\"Bitte prüfen\",IF(K40>1.5,\"Bitte prüfen\",\"\"))","v":""}]
[]
[{"$f":"MAX(A38:A41)+1","v":17},"Verbaubleche (Schotterhalterung) ziehen Seite 2","03.06.05.07","ggf. mit anderen Gewerken parallel",1,"St",6,"St/h",{"$f":"E42/G42*I$1","v":6.9444444444444441E-3},1.0416666666666666E-2,1,{"$f":"IF(K42=100%,L40,IF(K42>0%,M40-J40*K42,M40))","v":"2022-01-03T14:00:00"},{"$f":"L42+J42","v":"2022-01-03T14:15:00"},null,null,null,{"$f":"IF(L42=0,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(J42/I42<0.5,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(J42/I42>2.5,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(K42<0,\"Bitte prüfen\",IF(K42>1.5,\"Bitte prüfen\",\"\"))","v":""}]
[]
[{"$f":"MAX(A42:A43)+1","v":18},"Verbauträger inkl. Auflagerträger abbrennen mind. 1,70 u. SOK Seite 1","03.06.05.08",null,3,"St",4,"St/h",{"$f":"E44/G44*I$1","v":3.125E-2},3.125E-2,0,{"$f":"IF(K44=100%,L42,IF(K44>0%,M42-J42*K44,M42))","v":"2022-01-03T14:15:00"},{"$f":"L44+J44","v":"2022-01-03T15:00:00"},null,null,null,{"$f":"IF(L44=0,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(J44/I44<0.5,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(J44/I44>2.5,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(K44<0,\"Bitte prüfen\",IF(K44>1.5,\"Bitte prüfen\",\"\"))","v":""}]
[]
[{"$f":"MAX(A42:A45)+1","v":19},"Verbauträger inkl. Auflagerträger abbrennen mind. 1,70 u. SOK Seite 2","03.06.05.08",null,3,"St",4,"St/h",{"$f":"E46/G46*I$1","v":3.125E-2},3.125E-2,0,{"$f":"IF(K46=100%,L44,IF(K46>0%,M44-J44*K46,M44))","v":"2022-01-03T15:00:00"},{"$f":"L46+J46","v":"2022-01-03T15:45:00"},null,null,null,{"$f":"IF(L46=0,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(J46/I46<0.5,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(J46/I46>2.5,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(K46<0,\"Bitte prüfen\",IF(K46>1.5,\"Bitte prüfen\",\"\"))","v":""}]
[]
[{"$f":"MAX(A44:A47)+1","v":20},"Kammerwandwände einbauen (Fertigteil; Seite 1), verschrauben oder vergießen","03.04.03.09",null,1,"St",2,"St/h",{"$f":"E48/G48*I$1","v":2.0833333333333332E-2},2.0833333333333332E-2,0,{"$f":"IF(K48=100%,L46,IF(K48>0%,M46-J46*K48,M46))","v":"2022-01-03T15:45:00"},{"$f":"L48+J48","v":"2022-01-03T16:15:00"},null,null,null,{"$f":"IF(L48=0,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(J48/I48<0.5,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(J48/I48>2.5,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(K48<0,\"Bitte prüfen\",IF(K48>1.5,\"Bitte prüfen\",\"\"))","v":""}]
[]
[{"$f":"MAX(A46:A49)+1","v":21},"Kammerwandwände einbauen (Fertigteil; Seite 2), verschrauben oder vergießen","03.04.03.09",null,1,"St",2,"St/h",{"$f":"E50/G50*I$1","v":2.0833333333333332E-2},2.0833333333333332E-2,0,{"$f":"IF(K50=100%,L48,IF(K50>0%,M48-J48*K50,M48))","v":"2022-01-03T16:15:00"},{"$f":"L50+J50","v":"2022-01-03T16:45:00"},null,null,null,{"$f":"IF(L50=0,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(J50/I50<0.5,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(J50/I50>2.5,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(K50<0,\"Bitte prüfen\",IF(K50>1.5,\"Bitte prüfen\",\"\"))","v":""}]
[]
[{"$f":"MAX(A48:A51)+1","v":22},"Erhärtungszeit Verguss Kammerwände","Herstellerangaben","maßgeblich ist die Herstellerangabe",1,"psch",4.5454545454545456E-2,"psch/h",{"$f":"E52/G52*I$1","v":0.91666666666666663},0.91666666666666663,1,{"$f":"IF(K52=100%,L50,IF(K52>0%,M50-J50*K52,M50))","v":"2022-01-03T16:15:00"},{"$f":"L52+J52","v":"2022-01-04T14:15:00"},null,null,null,{"$f":"IF(L52=0,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(J52/I52<0.5,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(J52/I52>2.5,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(K52<0,\"Bitte prüfen\",IF(K52>1.5,\"Bitte prüfen\",\"\"))","v":""}]
[null,"(Voraussetzung für Beginn Vorgang Widerlagerhinterfüllung)",null,"z.B. Pagel V1: ca. 20-24 h und V2: ca. 4-8 h"]
[23,"Lagersockel inkl. Schalung und Bewehrung herstellen","03.04.05.02","Wird vor der Sperrung erbracht!\nHier als Merker für Gesamtablauf.",4,"St ",0.2,"St/h",{"$f":"E54/G54*I$1","v":0.83333333333333326},0.83333333333333337,1,{"$f":"IF(K54=100%,L52,IF(K54>0%,M52-J52*K54,M52))","v":"2022-01-03T16:15:00"},{"$f":"L54+J54","v":"2022-01-04T12:15:00"},null,null,null,{"$f":"IF(L54=0,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(J54/I54<0.5,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(J54/I54>2.5,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(K54<0,\"Bitte prüfen\",IF(K54>1.5,\"Bitte prüfen\",\"\"))","v":""}]
[null,"=> Komplexität nicht abbildbar",null,null,null,"Lager herstellen"]
[24,"Lagerplatte einbauen","03.04.03.10","0,5 h je Lager",4,"St",2,"St/h",{"$f":"E56/G56*I$1","v":8.3333333333333329E-2},8.3333333333333329E-2,0,"2022-01-03T16:15:00",{"$f":"L56+J56","v":"2022-01-03T18:15:00"},null,null,null,{"$f":"IF(L56=0,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(J56/I56<0.5,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(J56/I56>2.5,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(K56<0,\"Bitte prüfen\",IF(K56>1.5,\"Bitte prüfen\",\"\"))","v":""}]
[null,"=> Komplexität nicht abbildbar",null,"Parallelität wegen Fachpersonal eingeschränkt"]
[{"$f":"MAX(A56:A57)+1","v":25},"Brückeneinschub (1. Schritt bis vor die Lager)","03.05.02.05","abhängig vom Verschubweg",20,"m",5,"m/h",{"$f":"E58/G58*I$1","v":0.16666666666666666},0.20833333333333334,1,{"$f":"IF(K58=100%,L56,IF(K58>0%,M56-J56*K58,M56))","v":"2022-01-03T16:15:00"},{"$f":"L58+J58","v":"2022-01-03T21:15:00"},null,null,null,{"$f":"IF(L58=0,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(J58/I58<0.5,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(J58/I58>2.5,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(K58<0,\"Bitte prüfen\",IF(K58>1.5,\"Bitte prüfen\",\"\"))","v":""}]
[]
[{"$f":"MAX(A58:A59)+1","v":26},"Verschubeinrichtung montieren","03.05.02.04","Montage unter ausgebauter HB",12,"m",5,"m/h",{"$f":"E60/G60*I$1","v":9.9999999999999992E-2},0.10416666666666667,0,{"$f":"IF(K60=100%,L58,IF(K60>0%,M58-J58*K60,M58))","v":"2022-01-03T21:15:00"},{"$f":"L60+J60","v":"2022-01-03T23:45:00"},null,null,null,{"$f":"IF(L60=0,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(J60/I60<0.5,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(J60/I60>2.5,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(K60<0,\"Bitte prüfen\",IF(K60>1.5,\"Bitte prüfen\",\"\"))","v":""}]
[]
[{"$f":"MAX(A60:A61)+1","v":27},"Brückeneinschub (2. Schritt in Endlage)","03.05.02.05",null,6,"m",2,"m/h",{"$f":"E62/G62*I$1","v":0.125},0.125,0,{"$f":"IF(K62=100%,L60,IF(K62>0%,M60-J60*K62,M60))","v":"2022-01-03T23:45:00"},{"$f":"L62+J62","v":"2022-01-04T02:45:00"},null,3,null,{"$f":"IF(L62=0,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(J62/I62<0.5,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(J62/I62>2.5,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(K62<0,\"Bitte prüfen\",IF(K62>1.5,\"Bitte prüfen\",\"\"))","v":""}]
[]
[{"$f":"MAX(A60:A63)+1","v":28},"Lager abstapeln und ausrichten","03.05.02.06","Annahme: 1,0 m abstapeln (Stapelhölzer)",1,"m",0.1,"m/h",{"$f":"E64/G64*I$1","v":0.41666666666666663},0.41666666666666669,0,{"$f":"IF(K64=100%,L62,IF(K64>0%,M62-J62*K64,M62))","v":"2022-01-04T02:45:00"},{"$f":"L64+J64","v":"2022-01-04T12:45:00"},null,null,null,{"$f":"IF(L64=0,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(J64/I64<0.5,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(J64/I64>2.5,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(K64<0,\"Bitte prüfen\",IF(K64>1.5,\"Bitte prüfen\",\"\"))","v":""}]
[null,"Presse (1 bis 2 cm über dem Lager)",null,"Presse ansetzen"]
[29,"Lagerplatte ausrichten, einmessen und vergießen","03.04.05.05","2,0 h je Lager",4,"St",0.5,"St/h",{"$f":"E66/G66*I$1","v":0.33333333333333331},0.33333333333333331,0,{"$f":"IF(K66=100%,L64,IF(K66>0%,M64-J64*K66,M64))","v":"2022-01-04T12:45:00"},{"$f":"L66+J66","v":"2022-01-04T20:45:00"},null,null,null,{"$f":"IF(L66=0,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(J66/I66<0.5,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(J66/I66>2.5,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(K66<0,\"Bitte prüfen\",IF(K66>1.5,\"Bitte prüfen\",\"\"))","v":""}]
[null,null,null,"parallelität wegen Fachpersonal eingeschränkt"]
[30,"Erhärtungszeit Verguss Lagerplatte","Herstellerangaben","maßgeblich ist die Herstellerangabe",1,"psch",0.125,"psch/h",{"$f":"E68/G68*I$1","v":0.33333333333333331},0.33333333333333331,0,{"$f":"IF(K68=100%,L66,IF(K68>0%,M66-J66*K68,M66))","v":"2022-01-04T20:45:00"},{"$f":"L68+J68","v":"2022-01-05T04:45:00"},null,4,null,{"$f":"IF(L68=0,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(J68/I68<0.5,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(J68/I68>2.5,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(K68<0,\"Bitte prüfen\",IF(K68>1.5,\"Bitte prüfen\",\"\"))","v":""}]
[null,null,null,"z.B. Pagel V1: ca. 20-24 h und V2: ca. 4-8 h"]
[31,"Fahrbahnübergänge herstellen","03.04.06.01","4 bis 5 m je Gleis und Seite",9,"m",0.75,"m/h",{"$f":"E70/G70*I$1","v":0.5},0.5,0.5,{"$f":"IF(K70=100%,L68,IF(K70>0%,M68-J68*K70,M68))","v":"2022-01-05T00:45:00"},{"$f":"L70+J70","v":"2022-01-05T12:45:00"},null,null,null,{"$f":"IF(L70=0,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(J70/I70<0.5,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(J70/I70>2.5,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(K70<0,\"Bitte prüfen\",IF(K70>1.5,\"Bitte prüfen\",\"\"))","v":""}]
[]
[32,"Aushärtungszeit Fahrbahnübergang","Herstellerangaben","maßgeblich ist die Herstellerangabe",1,"psch",0.125,"psch/h",{"$f":"E72/G72*I$1","v":0.33333333333333331},0.33333333333333331,0,{"$f":"IF(K72=100%,L70,IF(K72>0%,M70-J70*K72,M70))","v":"2022-01-05T12:45:00"},{"$f":"L72+J72","v":"2022-01-05T20:45:00"},null,null,null,{"$f":"IF(L72=0,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(J72/I72<0.5,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(J72/I72>2.5,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(K72<0,\"Bitte prüfen\",IF(K72>1.5,\"Bitte prüfen\",\"\"))","v":""}]
[null,null,null,"z.B. Pagel V1: ca. 20-24 h und V2: ca. 4-8 h"]
[33,"Widerlagerhinterfüllung einbauen und verdichten","03.02.01.04",null,120,"m3",50,"m3/h",{"$f":"E74/G74*I$1","v":9.9999999999999992E-2},0.10416666666666667,0.5,{"$f":"IF(K74=100%,L72,IF(K74>0%,M72-J72*K74,M72))","v":"2022-01-05T16:45:00"},{"$f":"L74+J74","v":"2022-01-05T19:15:00"},null,null,null,{"$f":"IF(L74=0,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(J74/I74<0.5,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(J74/I74>2.5,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(K74<0,\"Bitte prüfen\",IF(K74>1.5,\"Bitte prüfen\",\"\"))","v":""}]
[]
[34,"Einbau PSS und verdichten in Kleinmengen","02.06.02.04","inkl. Abnahme der PSS",50,"m3",25,"m3/h",{"$f":"E76/G76*I$1","v":8.3333333333333329E-2},8.3333333333333329E-2,0.5,{"$f":"IF(K76=100%,L74,IF(K76>0%,M74-J74*K76,M74))","v":"2022-01-05T18:00:00"},{"$f":"L76+J76","v":"2022-01-05T20:00:00"},null,null,null,{"$f":"IF(L76=0,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(J76/I76<0.5,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(J76/I76>2.5,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(K76<0,\"Bitte prüfen\",IF(K76>1.5,\"Bitte prüfen\",\"\"))","v":""}]
[]
[35,"Grundschotter einbauen","02.02.04.04","z.B. vom Lkw oder Flachwagen mit klappbaren Seitenborden vor Kopf",60,"m3",30,"m3/h",{"$f":"E78/G78*I$1","v":8.3333333333333329E-2},8.3333333333333329E-2,0,{"$f":"IF(K78=100%,L76,IF(K78>0%,M76-J76*K78,M76))","v":"2022-01-05T20:00:00"},{"$f":"L78+J78","v":"2022-01-05T22:00:00"},null,null,null,{"$f":"IF(L78=0,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(J78/I78<0.5,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(J78/I78>2.5,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(K78<0,\"Bitte prüfen\",IF(K78>1.5,\"Bitte prüfen\",\"\"))","v":""}]
[]
[36,"Gleisjoche (6m Länge) einbauen","02.02.05.02",null,40,"m",25,"m/h",{"$f":"E80/G80*I$1","v":6.6666666666666666E-2},6.25E-2,0,{"$f":"IF(K80=100%,L78,IF(K80>0%,M78-J78*K80,M78))","v":"2022-01-05T22:00:00"},{"$f":"L80+J80","v":"2022-01-05T23:30:00"},null,null,null,{"$f":"IF(L80=0,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(J80/I80<0.5,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(J80/I80>2.5,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(K80<0,\"Bitte prüfen\",IF(K80>1.5,\"Bitte prüfen\",\"\"))","v":""}]
[]
[{"$f":"MAX(A80:A81)+1","v":37},"Schienenwechsel; Ausbau Montageschienen","02.02.07.01",null,80,"m",70,"m/h",{"$f":"E82/G82*I$1","v":4.7619047619047616E-2},5.2083333333333336E-2,0,{"$f":"IF(K82=100%,L80,IF(K82>0%,M80-J80*K82,M80))","v":"2022-01-05T23:30:00"},{"$f":"L82+J82","v":"2022-01-06T00:45:00"},null,null,null,{"$f":"IF(L82=0,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(J82/I82<0.5,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(J82/I82>2.5,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(K82<0,\"Bitte prüfen\",IF(K82>1.5,\"Bitte prüfen\",\"\"))","v":""}]
[]
[{"$f":"MAX(A80:A83)+1","v":38},"Schienen verziehen, auflegen und verspannen","02.02.06.03",null,80,"m",150,"m/h",{"$f":"E84/G84*I$1","v":2.222222222222222E-2},2.0833333333333332E-2,0,{"$f":"IF(K84=100%,L82,IF(K84>0%,M82-J82*K84,M82))","v":"2022-01-06T00:45:00"},{"$f":"L84+J84","v":"2022-01-06T01:15:00"},null,5,null,{"$f":"IF(L84=0,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(J84/I84<0.5,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(J84/I84>2.5,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(K84<0,\"Bitte prüfen\",IF(K84>1.5,\"Bitte prüfen\",\"\"))","v":""}]
[]
[39,"Nachschottern aus offene Schüttgutwagen mit dosierbarer Schwerkraftentladung (z.B. Fc-Wagen)","02.04.02.01",null,40,"m",60,"m/h",{"$f":"E86/G86*I$1","v":2.7777777777777776E-2},4.1666666666666664E-2,0,{"$f":"IF(K86=100%,L84,IF(K86>0%,M84-J84*K86,M84))","v":"2022-01-06T01:15:00"},{"$f":"L86+J86","v":"2022-01-06T02:15:00"},null,null,null,{"$f":"IF(L86=0,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(J86/I86<0.5,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(J86/I86>2.5,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(K86<0,\"Bitte prüfen\",IF(K86>1.5,\"Bitte prüfen\",\"\"))","v":""}]
[]
[40,"Gleis stopfen (1. Stabilisierung maschinell)","02.04.02.02","H.V.: 40 m; 1. Stab.: 70 m",110,"m",65,"m/h",{"$f":"E88/G88*I$1","v":7.0512820512820512E-2},7.2916666666666671E-2,0,{"$f":"IF(K88=100%,L86,IF(K88>0%,M86-J86*K88,M86))","v":"2022-01-06T02:15:00"},{"$f":"L88+J88","v":"2022-01-06T04:00:00"},null,null,null,{"$f":"IF(L88=0,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(J88/I88<0.5,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(J88/I88>2.5,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(K88<0,\"Bitte prüfen\",IF(K88>1.5,\"Bitte prüfen\",\"\"))","v":""}]
[]
[41,"Gleis stopfen (2. Stabilisierung maschinell)","02.04.02.03","2. Stab: 100 m",100,"m",90,"m/h",{"$f":"E90/G90*I$1","v":4.6296296296296294E-2},4.1666666666666664E-2,0,{"$f":"IF(K90=100%,L88,IF(K90>0%,M88-J88*K90,M88))","v":"2022-01-06T04:00:00"},{"$f":"L90+J90","v":"2022-01-06T05:00:00"},null,null,null,{"$f":"IF(L90=0,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(J90/I90<0.5,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(J90/I90>2.5,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(K90<0,\"Bitte prüfen\",IF(K90>1.5,\"Bitte prüfen\",\"\"))","v":""}]
[]
[42,"aluminotherm. Schweißen (Skv) 24-26 mm Lückenweite für alle Profile","02.01.02.01","Annahme 4 Schweißungen (1 Trupp)",4,"St",1.75,"St/h",{"$f":"E92/G92*I$1","v":9.5238095238095233E-2},0.10416666666666667,0,{"$f":"IF(K92=100%,L90,IF(K92>0%,M90-J90*K92,M90))","v":"2022-01-06T05:00:00"},{"$f":"L92+J92","v":"2022-01-06T07:30:00"},null,null,null,{"$f":"IF(L92=0,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(J92/I92<0.5,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(J92/I92>2.5,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(K92<0,\"Bitte prüfen\",IF(K92>1.5,\"Bitte prüfen\",\"\"))","v":""}]
[]
[43,"Spannungsausgleich ohne Schlussschweißung herstellen","02.01.03.03","2x 150 m Spannungsausgleich (2x Wärmeröhren / 2 Trupps)",300,"m",150,"m/h",{"$f":"E94/G94*I$1","v":8.3333333333333329E-2},8.3333333333333329E-2,0.5,{"$f":"IF(K94=100%,L92,IF(K94>0%,M92-J92*K94,M92))","v":"2022-01-06T06:15:00"},{"$f":"L94+J94","v":"2022-01-06T08:15:00"},null,null,null,{"$f":"IF(L94=0,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(J94/I94<0.5,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(J94/I94>2.5,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(K94<0,\"Bitte prüfen\",IF(K94>1.5,\"Bitte prüfen\",\"\"))","v":""}]
[]
[44,"Gleisschaltmittel  (Achszähler, PZB, Linienleiter, Balisen etc.) anbauen","07.01.03.01.01","abhängig vom Umfang LST, Einbindung Fachplanung erforderlich",2,"St",2,"St/h",{"$f":"E96/G96*I$1","v":4.1666666666666664E-2},4.1666666666666664E-2,0,{"$f":"IF(K96=100%,L94,IF(K96>0%,M94-J94*K96,M94))","v":"2022-01-06T08:15:00"},{"$f":"L96+J96","v":"2022-01-06T09:15:00"},null,null,null,{"$f":"IF(L96=0,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(J96/I96<0.5,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(J96/I96>2.5,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(K96<0,\"Bitte prüfen\",IF(K96>1.5,\"Bitte prüfen\",\"\"))","v":""}]
[null,null,null,null,null," Annahme getroffen"]
[45,"Bauteilerden einbauen","06.08.01.01",null,2,"St",4,"St/h",{"$f":"E98/G98*I$1","v":2.0833333333333332E-2},2.0833333333333332E-2,0.5,{"$f":"IF(K98=100%,L96,IF(K98>0%,M96-J96*K98,M96))","v":"2022-01-06T08:45:00"},{"$f":"L98+J98","v":"2022-01-06T09:15:00"},null,null,null,{"$f":"IF(L98=0,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(J98/I98<0.5,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(J98/I98>2.5,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(K98<0,\"Bitte prüfen\",IF(K98>1.5,\"Bitte prüfen\",\"\"))","v":""}]
[null,"Schienenverbinder einbauen","06.08.01.02",null,null," Annahme getroffen"]
[46,"OLA zurückschwenken","06.01.01.01",null,90,"m",60,"m/h",{"$f":"E100/G100*I$1","v":6.25E-2},6.25E-2,0,{"$f":"IF(K100=100%,L98,IF(K100>0%,M98-J98*K100,M98))","v":"2022-01-06T09:15:00"},{"$f":"L100+J100","v":"2022-01-06T10:45:00"},null,null,null,{"$f":"IF(L100=0,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(J100/I100<0.5,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(J100/I100>2.5,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(K100<0,\"Bitte prüfen\",IF(K100>1.5,\"Bitte prüfen\",\"\"))","v":""}]
[]
[{"$f":"MAX(A100:A101)+1","v":47},"ggf. Prüfung, ob Abnahmehandlungen (LST) notwendig sind","07.01.08.01","Achszähler",1,"St",2,"St/h",{"$f":"E102/G102*I$1","v":2.0833333333333332E-2},2.0833333333333332E-2,0,{"$f":"IF(K102=100%,L100,IF(K102>0%,M100-J100*K102,M100))","v":"2022-01-06T10:45:00"},{"$f":"L102+J102","v":"2022-01-06T11:15:00"},null,null,null,{"$f":"IF(L102=0,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(J102/I102<0.5,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(J102/I102>2.5,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(K102<0,\"Bitte prüfen\",IF(K102>1.5,\"Bitte prüfen\",\"\"))","v":""}]
[null,null,null,null,null," Annahme getroffen"]
[{"$f":"MAX(A100:A103)+1","v":48},"ggf. Prüfung La-Einrichtung entsprechend VzG und Planung, ggf. Geschwindigkeitsüberwachung (GÜ - PZB-Magnete) für Nachlauf-La","07.01.02.03","keine baulichen Veränderungen an der Anlage gegenüber dem Urzustand",6,"St",4,"St/h",{"$f":"E104/G104*I$1","v":6.25E-2},6.25E-2,0.5,{"$f":"IF(K104=100%,L102,IF(K104>0%,M102-J102*K104,M102))","v":"2022-01-06T11:00:00"},{"$f":"L104+J104","v":"2022-01-06T12:30:00"},null,null,null,{"$f":"IF(L104=0,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(J104/I104<0.5,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(J104/I104>2.5,\"Bitte prüfen\",\"\")","v":""},""]
[]
[{"$f":"MAX(A102:A105)+1","v":49},"Erdungsvorrichtung ausbauen und Oberleitung einschalten (1 Schaltgruppe)","08.01.02.02",null,2,"psch",4,"psch/h",{"$f":"E106/G106*I$1","v":2.0833333333333332E-2},2.0833333333333332E-2,0.5,{"$f":"IF(K106=100%,L104,IF(K106>0%,M104-J104*K106,M104))","v":"2022-01-06T11:45:00"},{"$f":"L106+J106","v":"2022-01-06T12:15:00"},null,null,null,{"$f":"IF(L106=0,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(J106/I106<0.5,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(J106/I106>2.5,\"Bitte prüfen\",\"\")","v":""},""]
[]
[{"$f":"MAX(A104:A107)+1","v":50},"Sperrung aufheben","08.01.01.02",null,1,"psch",2,"psch/h",{"$f":"E108/G108*I$1","v":2.0833333333333332E-2},2.0833333333333332E-2,0,{"$f":"IF(K108=100%,L106,IF(K108>0%,M106-J106*K108,M106))","v":"2022-01-06T12:15:00"},{"$f":"L108+J108","v":"2022-01-06T12:45:00"},null,null,null,{"$f":"IF(L108=0,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(J108/I108<0.5,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(J108/I108>2.5,\"Bitte prüfen\",\"\")","v":""},""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"M108-L1","v":3.5729166666787933}]

{"sheet":"Rahmen Einschub","index":2,"n_rows":77,"n_cols":20,"rows_kept":77,"cut":false,"hidden":false,"merged":[[0,9,0,10],[0,11,0,12]]}
["Projekt","Herstellung Rahmenbauwerk mit Einschub (ohne Hilfsbrücken)",null,null,null,null,null,"Uhrzeit-berechnung:","01:00:00","Start (Datum/Uhrzeit) eingeben:",null,"2022-01-02T23:00:00"]
["Vor-gangs-\nNr.","Vorgangsbezeichnung","Position Katalog","Hinweise/Bemerkungen","Leistungs-menge","Einheit Leistungs-menge\nErläuterung","Leistungs-wert Katalog","Einheit Leistungswert\nErläuterung ","Dauer (rechn.)","Dauer (gewählt)","Para-llelität\nin %","Beginn","Ende","Bemerkung","Tag-wechsel",null,"Prüfung Anfangszeit","Prüfung Dauer gewählt\nzu klein","Prüfung Dauer gewählt\nzu groß","Prüfung Parallelität"]
[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,null,16,17,18,19]
[0,"Vorbereitende Maßnahmen definieren z.B. BE-Fläche, Anrampung, Baustrom, Kabelumverlegung, Verbau zum Nachbargleis, Feste Absperrung, Bodengutachten, Kampfmittelsondierung, Gründung Hilfsbrücke",null,"Im Vorfeld in einer gesonderten (Gleis-)Sperrung zu realisieren.",null,null,null,null,null,null,null,null,null,null,0,null,{"$f":"IF(L4=0,\"Bitte prüfen\",\"\")","v":"Bitte prüfen"},{"$f":"IF(J4/I4<0.5,\"Bitte prüfen\",\"\")","v":{"$error":"#DIV/0!"}},{"$f":"IF(J4/I4>2.5,\"Bitte prüfen\",\"\")","v":{"$error":"#DIV/0!"}},{"$f":"IF(K4<0,\"Bitte prüfen\",IF(K4>1.5,\"Bitte prüfen\",\"\"))","v":""}]
[]
[{"$f":"MAX(A4:A5)+1","v":1},"Sperrung einrichten","08.01.01.01","Regelungen Betra beachten",1,"psch",2,"psch/h",{"$f":"E6/G6*I$1","v":2.0833333333333332E-2},2.0833333333333332E-2,0,{"$f":"L1","v":"2022-01-02T23:00:00"},{"$f":"L6+J6","v":"2022-01-02T23:30:00"},null,1,null,{"$f":"IF(L6=0,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(J6/I6<0.5,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(J6/I6>2.5,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(K6<0,\"Bitte prüfen\",IF(K6>1.5,\"Bitte prüfen\",\"\"))","v":""}]
[]
[{"$f":"MAX(A4:A7)+1","v":2},"Oberleitung abschalten und Erdungs-vorrichtung einbauen (1 Schaltgruppe)","08.01.02.01",null,2,"psch",4,"psch/h",{"$f":"E8/G8*I$1","v":2.0833333333333332E-2},2.0833333333333332E-2,0.5,{"$f":"IF(K8=100%,L6,IF(K8>0%,M6-J6*K8,M6))","v":"2022-01-02T23:15:00"},{"$f":"L8+J8","v":"2022-01-02T23:45:00"},null,null,null,{"$f":"IF(L8=0,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(J8/I8<0.5,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(J8/I8>2.5,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(K8<0,\"Bitte prüfen\",IF(K8>1.5,\"Bitte prüfen\",\"\"))","v":""}]
[null,null,null,"Teilparallelität zu Vorgang Nr. 1"]
[{"$f":"MAX(A6:A9)+1","v":3},"Gleisschaltmittel  (Achszähler, PZB, Linienleiter, Balisen etc.) abbauen","07.01.02.02/ 07.01.02.05/ 07.01.03.02","kann ggf. zu Bahnerdung parallel laufen (kein ZWB - nur Personal)",3,"St",3,"St/h",{"$f":"E10/G10*I$1","v":4.1666666666666664E-2},4.1666666666666664E-2,0.5,{"$f":"IF(K10=100%,L8,IF(K10>0%,M8-J8*K10,M8))","v":"2022-01-02T23:30:00"},{"$f":"L10+J10","v":"2022-01-03T00:30:00"},null,2,null,{"$f":"IF(L10=0,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(J10/I10<0.5,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(J10/I10>2.5,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(K10<0,\"Bitte prüfen\",IF(K10>1.5,\"Bitte prüfen\",\"\"))","v":""}]
[null,null,null,"absolute Parallelität zu Vorgang Nr. 2",null," Annahme getroffen"]
[{"$f":"MAX(A8:A11)+1","v":4},"Erdungseinrichtungen (Schienen-, Gleisverbinder, Betriebserden etc.) abbauen","06.08.02.03","absolute Parallelität zu Vorgang Nr. 3, jedoch muss der Vorgang Nr. 2 vorher abgeschlossen sein.",1,"St",1,"St/h",{"$f":"E12/G12*I$1","v":4.1666666666666664E-2},4.1666666666666664E-2,1,"2022-01-02T23:45:00",{"$f":"L12+J12","v":"2022-01-03T00:45:00"},"Beginnzeit händisch gesetzt, da Vorgang 2 abgeschlossen sein muss.",null,null,{"$f":"IF(L12=0,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(J12/I12<0.5,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(J12/I12>2.5,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(K12<0,\"Bitte prüfen\",IF(K12>1.5,\"Bitte prüfen\",\"\"))","v":""}]
[]
[{"$f":"MAX(A10:A13)+1","v":5},"Rückstromführung montieren","06.08.01.07","Rücksprache mit Fachplaner, ob die Leistung erforderlich ist!",2,"St",1,"St/h",{"$f":"E14/G14*I$1","v":8.3333333333333329E-2},8.3333333333333329E-2,0.5,{"$f":"IF(K14=100%,L12,IF(K14>0%,M12-J12*K14,M12))","v":"2022-01-03T00:15:00"},{"$f":"L14+J14","v":"2022-01-03T02:15:00"},null,null,null,{"$f":"IF(L14=0,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(J14/I14<0.5,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(J14/I14>2.5,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(K14<0,\"Bitte prüfen\",IF(K14>1.5,\"Bitte prüfen\",\"\"))","v":""}]
[null,null,null,"Parallel zu Vorgang Nr. 4"]
[{"$f":"MAX(A12:A15)+1","v":6},"Schienen trennen/schneiden (Trennschnitt)","02.01.01.01","zur Wiederverwendung je 2 Schnitte rechts, links",4,"St",6,"St/h",{"$f":"E16/G16*I$1","v":2.7777777777777776E-2},3.125E-2,0,{"$f":"IF(K16=100%,L14,IF(K16>0%,M14-J14*K16,M14))","v":"2022-01-03T02:15:00"},{"$f":"L16+J16","v":"2022-01-03T03:00:00"},null,null,null,{"$f":"IF(L16=0,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(J16/I16<0.5,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(J16/I16>2.5,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(K16<0,\"Bitte prüfen\",IF(K16>1.5,\"Bitte prüfen\",\"\"))","v":""}]
[]
[{"$f":"MAX(A14:A17)+1","v":7},"Schienen lösen und verziehen","02.02.02.01","Schiene lösen mit Schrauber (2 Trupps á 2 Leute)",60,"m",150,"m/h",{"$f":"E18/G18*I$1","v":1.6666666666666666E-2},2.0833333333333332E-2,0.25,"2022-01-03T02:45:00",{"$f":"L18+J18","v":"2022-01-03T03:15:00"},"Beginnzeit händisch gesetzt, wegen Minutenanpassung",null,null,{"$f":"IF(L18=0,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(J18/I18<0.5,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(J18/I18>2.5,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(K18<0,\"Bitte prüfen\",IF(K18>1.5,\"Bitte prüfen\",\"\"))","v":""}]
[null,null,null,"Teilparallelität zu Vorgang Nr. 6"]
[{"$f":"MAX(A16:A19)+1","v":8},"Montageschiene aufsetzen","02.02.07.01",null,60,"m",60,"m/h",{"$f":"E20/G20*I$1","v":4.1666666666666664E-2},4.1666666666666664E-2,0,{"$f":"IF(K20=100%,L18,IF(K20>0%,M18-J18*K20,M18))","v":"2022-01-03T03:15:00"},{"$f":"L20+J20","v":"2022-01-03T04:15:00"},null,null,null,{"$f":"IF(L20=0,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(J20/I20<0.5,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(J20/I20>2.5,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(K20<0,\"Bitte prüfen\",IF(K20>1.5,\"Bitte prüfen\",\"\"))","v":""}]
[]
[{"$f":"MAX(A18:A21)+1","v":9},"Jochweise (6 m) rausheben, transportieren und lagern","02.02.01.04","Betonschwellen",30,"m",30,"m/h",{"$f":"E22/G22*I$1","v":4.1666666666666664E-2},4.1666666666666664E-2,0,{"$f":"IF(K22=100%,L20,IF(K22>0%,M20-J20*K22,M20))","v":"2022-01-03T04:15:00"},{"$f":"L22+J22","v":"2022-01-03T05:15:00"},null,null,null,{"$f":"IF(L22=0,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(J22/I22<0.5,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(J22/I22>2.5,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(K22<0,\"Bitte prüfen\",IF(K22>1.5,\"Bitte prüfen\",\"\"))","v":""}]
[]
[{"$f":"MAX(A20:A23)+1","v":10},"Schotter ausbauen","02.02.03.06","hier als Beispiel Kleinstmengen Verladung auf LKW vor Kopf",60,"m3",30,"m3/h",{"$f":"E24/G24*I$1","v":8.3333333333333329E-2},8.3333333333333329E-2,0,{"$f":"IF(K24=100%,L22,IF(K24>0%,M22-J22*K24,M22))","v":"2022-01-03T05:15:00"},{"$f":"L24+J24","v":"2022-01-03T07:15:00"},null,null,null,{"$f":"IF(L24=0,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(J24/I24<0.5,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(J24/I24>2.5,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(K24<0,\"Bitte prüfen\",IF(K24>1.5,\"Bitte prüfen\",\"\"))","v":""}]
[]
[{"$f":"MAX(A22:A25)+1","v":11},"Vorhandene Abdichtung sortenrein lösen","03.01.01.04",null,30,"m2",15,"m2/h",{"$f":"E26/G26*I$1","v":8.3333333333333329E-2},8.3333333333333329E-2,0,{"$f":"IF(K26=100%,L24,IF(K26>0%,M24-J24*K26,M24))","v":"2022-01-03T07:15:00"},{"$f":"L26+J26","v":"2022-01-03T09:15:00"},null,null,null,{"$f":"IF(L26=0,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(J26/I26<0.5,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(J26/I26>2.5,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(K26<0,\"Bitte prüfen\",IF(K26>1.5,\"Bitte prüfen\",\"\"))","v":""}]
[]
[{"$f":"MAX(A24:A27)+1","v":12},"Abbruch Überbau und Verladen auf LKW","03.01.01.03",null,20,"m3",10,"m3/h",{"$f":"E28/G28*I$1","v":8.3333333333333329E-2},8.3333333333333329E-2,0,{"$f":"IF(K28=100%,L26,IF(K28>0%,M26-J26*K28,M26))","v":"2022-01-03T09:15:00"},{"$f":"L28+J28","v":"2022-01-03T11:15:00"},null,null,null,{"$f":"IF(L28=0,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(J28/I28<0.5,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(J28/I28>2.5,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(K28<0,\"Bitte prüfen\",IF(K28>1.5,\"Bitte prüfen\",\"\"))","v":""}]
[]
[{"$f":"MAX(A26:A29)+1","v":13},"Erdarbeiten: Freilegen der Rahmen- und Flügelwände","03.02.01.02","Ausführung parallel zu Vorgang Nr. 12 und Nr. 15 und paralleler Bodenaushub an beiden Rahmenwänden",360,"m3",40,"m3/h",{"$f":"E30/G30*I$1","v":0.375},0.375,0.25,{"$f":"IF(K30=100%,L28,IF(K30>0%,M28-J28*K30,M28))","v":"2022-01-03T10:45:00"},{"$f":"L30+J30","v":"2022-01-03T19:45:00"},null,null,null,{"$f":"IF(L30=0,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(J30/I30<0.5,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(J30/I30>2.5,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(K30<0,\"Bitte prüfen\",IF(K30>1.5,\"Bitte prüfen\",\"\"))","v":""}]
[]
[{"$f":"MAX(A28:A31)+1","v":14},"Rahmen- und Flügelwände und Fundamente abbrechen inkl. Verladen auf LKW","03.01.01.05",null,150,"m3",7.5,"m3/h",{"$f":"E32/G32*I$1","v":0.83333333333333326},0.83333333333333337,0,{"$f":"IF(K32=100%,L30,IF(K32>0%,M30-J30*K32,M30))","v":"2022-01-03T19:45:00"},{"$f":"L32+J32","v":"2022-01-04T15:45:00"},null,3,null,{"$f":"IF(L32=0,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(J32/I32<0.5,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(J32/I32>2.5,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(K32<0,\"Bitte prüfen\",IF(K32>1.5,\"Bitte prüfen\",\"\"))","v":""}]
[]
[{"$f":"MAX(A30:A33)+1","v":15},"Erdarbeiten Bodenaushub inkl. Planum (Bodenaustausch für Gründung Verschubbahn)","03.02.01.02",null,60,"m3",30,"m3/h",{"$f":"E34/G34*I$1","v":8.3333333333333329E-2},8.3333333333333329E-2,0,{"$f":"IF(K34=100%,L32,IF(K34>0%,M32-J32*K34,M32))","v":"2022-01-04T15:45:00"},{"$f":"L34+J34","v":"2022-01-04T17:45:00"},null,null,null,{"$f":"IF(L34=0,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(J34/I34<0.5,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(J34/I34>2.5,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(K34<0,\"Bitte prüfen\",IF(K34>1.5,\"Bitte prüfen\",\"\"))","v":""}]
[]
[{"$f":"MAX(A32:A35)+1","v":16},"Erdarbeiten Bodenaustausch (tragfähingen Boden einbauen)","03.05.02.01",null,60,"m3",30,"m3/h",{"$f":"E36/G36*I$1","v":8.3333333333333329E-2},8.3333333333333329E-2,0,{"$f":"IF(K36=100%,L34,IF(K36>0%,M34-J34*K36,M34))","v":"2022-01-04T17:45:00"},{"$f":"L36+J36","v":"2022-01-04T19:45:00"},null,null,null,{"$f":"IF(L36=0,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(J36/I36<0.5,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(J36/I36>2.5,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(K36<0,\"Bitte prüfen\",IF(K36>1.5,\"Bitte prüfen\",\"\"))","v":""}]
[]
[{"$f":"MAX(A34:A37)+1","v":17},"Verschubfundamente einbauen","03.05.02.03","Verschubweg: 12 m",24,"m",5,"m/h",{"$f":"E38/G38*I$1","v":0.19999999999999998},0.20833333333333334,0,{"$f":"IF(K38=100%,L36,IF(K38>0%,M36-J36*K38,M36))","v":"2022-01-04T19:45:00"},{"$f":"L38+J38","v":"2022-01-05T00:45:00"},null,4,null,{"$f":"IF(L38=0,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(J38/I38<0.5,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(J38/I38>2.5,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(K38<0,\"Bitte prüfen\",IF(K38>1.5,\"Bitte prüfen\",\"\"))","v":""}]
[]
[{"$f":"MAX(A36:A39)+1","v":18},"Verschubeinrichtung montieren","03.05.02.04",null,24,"m",8,"m/h",{"$f":"E40/G40*I$1","v":0.125},0.125,0,{"$f":"IF(K40=100%,L38,IF(K40>0%,M38-J38*K40,M38))","v":"2022-01-05T00:45:00"},{"$f":"L40+J40","v":"2022-01-05T03:45:00"},null,null,null,{"$f":"IF(L40=0,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(J40/I40<0.5,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(J40/I40>2.5,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(K40<0,\"Bitte prüfen\",IF(K40>1.5,\"Bitte prüfen\",\"\"))","v":""}]
[]
[{"$f":"MAX(A38:A41)+1","v":19},"Verschub","03.05.02.05",null,12,"m",2,"m/h",{"$f":"E42/G42*I$1","v":0.25},0.25,0,{"$f":"IF(K42=100%,L40,IF(K42>0%,M40-J40*K42,M40))","v":"2022-01-05T03:45:00"},{"$f":"L42+J42","v":"2022-01-05T09:45:00"},null,null,null,{"$f":"IF(L42=0,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(J42/I42<0.5,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(J42/I42>2.5,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(K42<0,\"Bitte prüfen\",IF(K42>1.5,\"Bitte prüfen\",\"\"))","v":""}]
[]
[{"$f":"MAX(A40:A43)+1","v":20},"HGT-Keil lagenweise einbauen (Rahmbenbauwerkshinterfüllung inkl. Verdichtung)","03.02.01.04","paralleles Arbeiten an beiden Rahmenwänden",360,"m3",30,"m3/h",{"$f":"E44/G44*I$1","v":0.5},0.5,0,{"$f":"IF(K44=100%,L42,IF(K44>0%,M42-J42*K44,M42))","v":"2022-01-05T09:45:00"},{"$f":"L44+J44","v":"2022-01-05T21:45:00"},null,null,null,{"$f":"IF(L44=0,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(J44/I44<0.5,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(J44/I44>2.5,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(K44<0,\"Bitte prüfen\",IF(K44>1.5,\"Bitte prüfen\",\"\"))","v":""}]
[null,null,null,"Erschwernis: HGT (hydraulisch gebundene Tragschicht)"]
[{"$f":"MAX(A42:A45)+1","v":21},"Grundschotter einbauen","02.02.04.04","z.B. vom Lkw oder Flachwagen mit klappbaren Seitenborden vor Kopf",40,"m3",30,"m3/h",{"$f":"E46/G46*I$1","v":5.5555555555555552E-2},6.25E-2,0,{"$f":"IF(K46=100%,L44,IF(K46>0%,M44-J44*K46,M44))","v":"2022-01-05T21:45:00"},{"$f":"L46+J46","v":"2022-01-05T23:15:00"},null,null,null,{"$f":"IF(L46=0,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(J46/I46<0.5,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(J46/I46>2.5,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(K46<0,\"Bitte prüfen\",IF(K46>1.5,\"Bitte prüfen\",\"\"))","v":""}]
[]
[{"$f":"MAX(A44:A47)+1","v":22},"Gleisjoche (6m Länge) einbauen","02.02.05.02","Betonschwellen",30,"m",30,"m/h",{"$f":"E48/G48*I$1","v":4.1666666666666664E-2},4.1666666666666664E-2,0,{"$f":"IF(K48=100%,L46,IF(K48>0%,M46-J46*K48,M46))","v":"2022-01-05T23:15:00"},{"$f":"L48+J48","v":"2022-01-06T00:15:00"},null,5,null,{"$f":"IF(L48=0,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(J48/I48<0.5,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(J48/I48>2.5,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(K48<0,\"Bitte prüfen\",IF(K48>1.5,\"Bitte prüfen\",\"\"))","v":""}]
[]
[{"$f":"MAX(A46:A49)+1","v":23},"Schienenwechsel; Montageschienen ausbauen","02.02.07.01","wegen Kleinstmenge Faktor 0,5 ansetzen",60,"m",60,"m/h",{"$f":"E50/G50*I$1","v":4.1666666666666664E-2},4.1666666666666664E-2,0,{"$f":"IF(K50=100%,L48,IF(K50>0%,M48-J48*K50,M48))","v":"2022-01-06T00:15:00"},{"$f":"L50+J50","v":"2022-01-06T01:15:00"},null,null,null,{"$f":"IF(L50=0,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(J50/I50<0.5,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(J50/I50>2.5,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(K50<0,\"Bitte prüfen\",IF(K50>1.5,\"Bitte prüfen\",\"\"))","v":""}]
[]
[{"$f":"MAX(A48:A51)+1","v":24},"Schienen verziehen, auflegen und verspannen","02.02.06.03","wegen Kleinstmenge Faktor 0,5 ansetzen",60,"m",120,"m/h",{"$f":"E52/G52*I$1","v":2.0833333333333332E-2},2.0833333333333332E-2,0,{"$f":"IF(K52=100%,L50,IF(K52>0%,M50-J50*K52,M50))","v":"2022-01-06T01:15:00"},{"$f":"L52+J52","v":"2022-01-06T01:45:00"},null,null,null,{"$f":"IF(L52=0,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(J52/I52<0.5,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(J52/I52>2.5,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(K52<0,\"Bitte prüfen\",IF(K52>1.5,\"Bitte prüfen\",\"\"))","v":""}]
[]
[{"$f":"MAX(A50:A53)+1","v":25},"Nachschottern aus offene Schüttgutwagen mit dosierbarer Schwerkraftentladung (z.B. Fc-Wagen)","02.04.02.01","einschl. Rampen",60,"m",60,"m/h",{"$f":"E54/G54*I$1","v":4.1666666666666664E-2},4.1666666666666664E-2,0,{"$f":"IF(K54=100%,L52,IF(K54>0%,M52-J52*K54,M52))","v":"2022-01-06T01:45:00"},{"$f":"L54+J54","v":"2022-01-06T02:45:00"},null,null,null,{"$f":"IF(L54=0,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(J54/I54<0.5,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(J54/I54>2.5,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(K54<0,\"Bitte prüfen\",IF(K54>1.5,\"Bitte prüfen\",\"\"))","v":""}]
[]
[{"$f":"MAX(A52:A55)+1","v":26},"Gleis stopfen (1. Stabilisierung maschinell)","02.04.02.02","H.V.: 30 m; 1. Stab.: 60 m",90,"m",65,"m/h",{"$f":"E56/G56*I$1","v":5.7692307692307689E-2},6.25E-2,0,{"$f":"IF(K56=100%,L54,IF(K56>0%,M54-J54*K56,M54))","v":"2022-01-06T02:45:00"},{"$f":"L56+J56","v":"2022-01-06T04:15:00"},null,null,null,{"$f":"IF(L56=0,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(J56/I56<0.5,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(J56/I56>2.5,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(K56<0,\"Bitte prüfen\",IF(K56>1.5,\"Bitte prüfen\",\"\"))","v":""}]
[]
[{"$f":"MAX(A54:A57)+1","v":27},"Gleis stopfen (2. Stabilisierung maschinell)","02.04.02.03","2. Stab: 100 m",100,"m",90,"m/h",{"$f":"E58/G58*I$1","v":4.6296296296296294E-2},4.1666666666666664E-2,0,{"$f":"IF(K58=100%,L56,IF(K58>0%,M56-J56*K58,M56))","v":"2022-01-06T04:15:00"},{"$f":"L58+J58","v":"2022-01-06T05:15:00"},null,null,null,{"$f":"IF(L58=0,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(J58/I58<0.5,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(J58/I58>2.5,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(K58<0,\"Bitte prüfen\",IF(K58>1.5,\"Bitte prüfen\",\"\"))","v":""}]
[]
[{"$f":"MAX(A56:A59)+1","v":28},"Gleis stopfen (3x Stopfgänge) maschinell)","02.04.02.02","Hebe-Verdichtgang: ca. 30 m\n1. Stabilisierung: ca. 60 m (Rampen)\n2. Stabilisierung: ca. 100 m (Rampen)",190,"m",65,"m/h",{"$f":"E60/G60*I$1","v":0.12179487179487178},0.125,0,{"$f":"IF(K60=100%,L58,IF(K60>0%,M58-J58*K60,M58))","v":"2022-01-06T05:15:00"},{"$f":"L60+J60","v":"2022-01-06T08:15:00"},null,null,null,{"$f":"IF(L60=0,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(J60/I60<0.5,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(J60/I60>2.5,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(K60<0,\"Bitte prüfen\",IF(K60>1.5,\"Bitte prüfen\",\"\"))","v":""}]
[]
[{"$f":"MAX(A58:A61)+1","v":29},"aluminotherm. Schweißen (Skv) 24-26 mm Lückenweite für alle Profile","02.01.02.01","Annahme 4 Schweißungen (1 Trupp)",4,"St",1.75,"St/h",{"$f":"E62/G62*I$1","v":9.5238095238095233E-2},0.10416666666666667,0,{"$f":"IF(K62=100%,L60,IF(K62>0%,M60-J60*K62,M60))","v":"2022-01-06T08:15:00"},{"$f":"L62+J62","v":"2022-01-06T10:45:00"},null,null,null,{"$f":"IF(L62=0,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(J62/I62<0.5,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(J62/I62>2.5,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(K62<0,\"Bitte prüfen\",IF(K62>1.5,\"Bitte prüfen\",\"\"))","v":""}]
[]
[{"$f":"MAX(A60:A63)+1","v":30},"Spannungsausgleich ohne Schlussschweißung herstellen","02.01.03.03","2x 150 m Spannungsausgleich (2x Wärmeröhren / 2 Trupps)",300,"m",150,"m/h",{"$f":"E64/G64*I$1","v":8.3333333333333329E-2},8.3333333333333329E-2,0.5,{"$f":"IF(K64=100%,L62,IF(K64>0%,M62-J62*K64,M62))","v":"2022-01-06T09:30:00"},{"$f":"L64+J64","v":"2022-01-06T11:30:00"},null,null,null,{"$f":"IF(L64=0,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(J64/I64<0.5,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(J64/I64>2.5,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(K64<0,\"Bitte prüfen\",IF(K64>1.5,\"Bitte prüfen\",\"\"))","v":""}]
[]
[{"$f":"MAX(A62:A65)+1","v":31},"Gleisschaltmittel  (Achszähler, PZB, Linienleiter, Balisen etc.) anbauen","07.01.03.01.01","abhängig vom Umfang LST, Einbindung Fachplanung erforderlich",2,"St",2,"St/h",{"$f":"E66/G66*I$1","v":4.1666666666666664E-2},4.1666666666666664E-2,0,{"$f":"IF(K66=100%,L64,IF(K66>0%,M64-J64*K66,M64))","v":"2022-01-06T11:30:00"},{"$f":"L66+J66","v":"2022-01-06T12:30:00"},null,null,null,{"$f":"IF(L66=0,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(J66/I66<0.5,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(J66/I66>2.5,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(K66<0,\"Bitte prüfen\",IF(K66>1.5,\"Bitte prüfen\",\"\"))","v":""}]
[null,null,null,null,null," Annahme getroffen"]
[{"$f":"MAX(A64:A67)+1","v":32},"Erdungseinrichtungen (Schienen-, Gleisverbinder, Betriebserden etc.) anbauen einschl. Hilfsbrücke Bauwerk erden","06.08.01.01",null,2,"St",4,"St/h",{"$f":"E68/G68*I$1","v":2.0833333333333332E-2},2.0833333333333332E-2,0.5,{"$f":"IF(K68=100%,L66,IF(K68>0%,M66-J66*K68,M66))","v":"2022-01-06T12:00:00"},{"$f":"L68+J68","v":"2022-01-06T12:30:00"},null,null,null,{"$f":"IF(L68=0,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(J68/I68<0.5,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(J68/I68>2.5,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(K68<0,\"Bitte prüfen\",IF(K68>1.5,\"Bitte prüfen\",\"\"))","v":""}]
[null,null,null,null,null," Annahme getroffen"]
[{"$f":"MAX(A66:A69)+1","v":33},"ggf. Prüfung, ob Abnahmehandlungen (LST) notwendig sind","07.01.08.01","Achszähler",1,"St",2,"St/h",{"$f":"E70/G70*I$1","v":2.0833333333333332E-2},2.0833333333333332E-2,0,{"$f":"IF(K70=100%,L68,IF(K70>0%,M68-J68*K70,M68))","v":"2022-01-06T12:30:00"},{"$f":"L70+J70","v":"2022-01-06T13:00:00"},null,null,null,{"$f":"IF(L70=0,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(J70/I70<0.5,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(J70/I70>2.5,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(K70<0,\"Bitte prüfen\",IF(K70>1.5,\"Bitte prüfen\",\"\"))","v":""}]
[null,null,null,null,null," Annahme getroffen"]
[{"$f":"MAX(A68:A71)+1","v":34},"ggf. Prüfung La-Einrichtung entsprechend VzG und Planung, ggf. Geschwindigkeitsüberwachung (GÜ - PZB-Magnete) für Nachlauf-La","07.01.02.03","keine baulichen Veränderungen an der Anlage gegenüber dem Urzustand",6,"St",4,"St/h",{"$f":"E72/G72*I$1","v":6.25E-2},6.25E-2,0.5,{"$f":"IF(K72=100%,L70,IF(K72>0%,M70-J70*K72,M70))","v":"2022-01-06T12:45:00"},{"$f":"L72+J72","v":"2022-01-06T14:15:00"},null,null,null,{"$f":"IF(L72=0,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(J72/I72<0.5,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(J72/I72>2.5,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(K72<0,\"Bitte prüfen\",IF(K72>1.5,\"Bitte prüfen\",\"\"))","v":""}]
[]
[{"$f":"MAX(A70:A73)+1","v":35},"Erdungsvorrichtung ausbauen und Oberleitung einschalten (1 Schaltgruppe)","08.01.02.02",null,2,"psch",4,"psch/h",{"$f":"E74/G74*I$1","v":2.0833333333333332E-2},2.0833333333333332E-2,0.5,{"$f":"IF(K74=100%,L72,IF(K74>0%,M72-J72*K74,M72))","v":"2022-01-06T13:30:00"},{"$f":"L74+J74","v":"2022-01-06T14:00:00"},null,null,null,{"$f":"IF(L74=0,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(J74/I74<0.5,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(J74/I74>2.5,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(K74<0,\"Bitte prüfen\",IF(K74>1.5,\"Bitte prüfen\",\"\"))","v":""}]
[]
[{"$f":"MAX(A72:A75)+1","v":36},"Sperrung aufheben","08.01.01.02",null,1,"psch",2,"psch/h",{"$f":"E76/G76*I$1","v":2.0833333333333332E-2},2.0833333333333332E-2,0,{"$f":"IF(K76=100%,L74,IF(K76>0%,M74-J74*K76,M74))","v":"2022-01-06T14:00:00"},{"$f":"L76+J76","v":"2022-01-06T14:30:00"},null,null,null,{"$f":"IF(L76=0,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(J76/I76<0.5,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(J76/I76>2.5,\"Bitte prüfen\",\"\")","v":""},{"$f":"IF(K76<0,\"Bitte prüfen\",IF(K76>1.5,\"Bitte prüfen\",\"\"))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"M76-L1","v":3.6458333333430346}]