{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Report","Calculation","Default"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":14,"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":"Report","index":0,"n_rows":122,"n_cols":35,"rows_kept":122,"cut":false,"hidden":false,"merged":[[14,1,14,7],[15,1,15,7],[16,1,16,7],[17,1,17,7],[18,1,18,7],[14,8,14,32],[15,8,15,32],[16,8,16,32],[17,8,17,32],[18,8,18,32],[28,1,28,6],[28,7,28,15],[115,0,115,34],[27,7,27,10],[27,11,27,15],[28,23,28,32],[25,1,25,6],[30,28,31,32],[40,24,40,32],[40,1,40,23],[33,0,33,34],[35,24,35,32],[35,1,35,23],[37,24,37,32],[37,1,37,23],[38,24,38,32],[38,2,38,23],[41,24,41,32],[41,2,41,23],[30,1,31,12],[113,12,113,17],[28,18,28,22],[121,19,121,33],[68,0,68,34],[45,24,45,32],[45,1,45,23],[49,0,49,34],[50,1,57,34],[59,0,59,34],[60,1,67,34],[71,0,71,10],[121,6,121,11],[117,6,117,11],[70,0,70,10],[47,1,47,23],[47,24,47,32],[120,6,120,11],[120,19,120,33],[120,4,120,5],[118,6,118,11],[120,15,120,18],[70,18,70,30],[117,2,117,5],[111,12,111,16],[111,17,111,27],[6,1,6,6],[4,7,4,15],[5,7,5,15],[5,18,5,23],[3,7,3,15],[10,7,10,15],[6,7,6,15],[3,1,3,6],[4,1,4,6],[5,1,5,6],[23,1,23,6],[26,1,26,6],[22,7,22,15],[23,7,23,15],[25,7,25,15],[24,1,24,6],[24,7,24,15],[26,7,26,10],[26,11,26,15],[24,20,24,32],[25,20,27,32],[0,28,0,33],[8,18,8,23],[8,24,8,32],[9,18,9,23],[9,24,9,32],[10,18,10,23],[10,24,10,32],[23,20,23,25],[23,28,23,32],[1,25,1,27],[0,24,0,27],[1,28,1,33],[3,18,3,23],[4,19,4,23],[1,0,1,24],[12,0,12,34],[3,24,3,32],[4,24,4,32],[20,0,20,34],[22,18,22,32],[22,1,22,6],[5,24,5,32],[8,7,8,15],[9,7,9,15],[9,2,9,6],[10,2,10,6],[8,1,8,6],[113,2,113,11],[71,18,71,30],[72,18,72,30],[70,31,70,34],[71,31,71,34],[72,31,72,34],[43,24,43,32],[43,1,43,23],[111,2,111,11],[111,28,111,33],[74,2,74,34],[75,2,75,34],[70,11,70,15],[71,11,71,15],[72,11,72,15],[72,0,72,10]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bericht Nr.:"]
["Allgemeine Daten",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Job ID:"]
[]
[null,"Schiffsname:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Messgerät:"]
[null,"ENI Nr.:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Seriennr.:"]
[null,"Klassennr.:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Letzte Kalibrierung:"]
[null,"Art des Schiffes:",null,null,null,null,null,{"$f":"LOOKUP(Calculation!D2,Calculation!A2:A22,Calculation!B2:B22)","v":"Bitte wählen"}]
[]
[null,"Zeugnis Nr.:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sonstiges 1"]
[null,null,"Ausgestellt am:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sonstiges 2"]
[null,null,"Gültig bis:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sonstiges 3"]
[]
["Eigner"]
[]
[null,"Name:"]
[null,"Adresse:"]
[null,"Kontaktperson(-en):"]
[null,"E-mail:"]
[null,"Tel.:"]
[]
["Schiffsdaten"]
[" "]
[null,"Länge L",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bauart:"]
[null,"Tiefgang T",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,null,"Doppelboden",null,null,null,null,null,null,null,"Doppelhülle"]
[null,"Breite B",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,null,"Wallgänge"]
[null,"DWT",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,null,"Begrenzungsschott zwischen Wallgang und Laderaum ist senkrecht unter dem Dennebaum angeordnet"]
[null,"Spantabstand, a",null,null,null,null,null,"Boden/Kimm"]
[null,null,null,null,null,null,null,"Außenhaut"]
[null,"Rumpfmaterial",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Das Schiff ist",null,null,null,null,{"$f":"LOOKUP(Calculation!D25,Calculation!A25:A28,Calculation!C25:C28)","v":0}]
[]
[null,"Das Schiff ist tauglich zur Fahrt in der/den Zone(n):",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[]
[]
["Untersuchungsergebnisse und Spiel"]
[" "]
["1.",{"$f":"\"Zustand des Antriebssystems\"&IF(Calculation!D31=1,IF(AI36=TRUE,\" (Bugstrahlantrieb)\",\"\"),IF(LOOKUP(Calculation!D31,Calculation!A31:A36,Calculation!C31:C36)=\"k.A.\",IF(AI36=TRUE,\" (Bugstrahlantrieb)\",\"\"),IF(AI36=TRUE,\" (\"&LOOKUP(Calculation!D31,Calculation!A31:A36,Calculation!C31:C36)&\", Bugstrahlantrieb)\",\" (\"&LOOKUP(Calculation!D31,Calculation!A31:A36,Calculation!C31:C36&\")\"))))&\":\"","v":"Zustand des Antriebssystems:"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"LOOKUP(Calculation!D39,Calculation!A39:A42,Calculation!C39:C42)","v":0},null,null,null,null,null,null,null,null,null,false]
[]
["2.","Zustand der Steuereinrichtung:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"LOOKUP(Calculation!D45,Calculation!A45:A48,Calculation!C45:C48)","v":0}]
[null,null,"Ruderspiel:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"LOOKUP(Calculation!D51,Calculation!A51:A54,Calculation!C51:C54)","v":0}]
[]
["3.","Zustand der Propellerwelle und Spiel:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"LOOKUP(Calculation!D57,Calculation!A57:A60,Calculation!C57:C60)","v":0}]
[null,null,"Propellerwellenspiel:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"LOOKUP(Calculation!D63,Calculation!A63:A66,Calculation!C63:C66)","v":0}]
[]
["4.","Zustand der Schotten, Bodenwrangen, Seitenspanten, Stützplatten:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"LOOKUP(Calculation!D69,Calculation!A69:A71,Calculation!C69:C71)","v":0}]
[]
["5.","Zustand des Bodens:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"LOOKUP(Calculation!D74,Calculation!A74:A76,Calculation!C74:C76)","v":0}]
[]
["6.","Zustand des Seekastenventils:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"LOOKUP(Calculation!D84,Calculation!A84:A87,Calculation!C84:C87)","v":0}]
[]
["Beschreibung des Schiffskörperzustandes"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Kommentare / Bemerkungen"]
[]
[]
[]
[]
[]
[]
[]
[]
["Akzeptanzkriterien für die Dickenmessungen"]
[]
["Mindestdicke der Bodenbeplattung",null,null,null,null,null,null,null,null,null,null,{"$f":"Calculation!G49","v":""},null,null,null,null,null,null,"Faktor für Boden-, Seiten- oder Kimmplatten, b",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(H23=0,\"\",\"\"&_xlfn.NUMBERVALUE(ROUND(Calculation!G19,2),2)&\"/\"&ROUND(Calculation!G20,2)&\"\")","v":""}]
["Mindestdicke der Seitenbeplattung",null,null,null,null,null,null,null,null,null,null,{"$f":"Calculation!G50","v":""},null,null,null,null,null,null,"Faktor für Bauart, c",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Calculation!G21","v":""}]
["Mindestdicke der Kimmbeplattung",null,null,null,null,null,null,null,null,null,null,{"$f":"Calculation!G51","v":""},null,null,null,null,null,null,"Faktor für Spantabstand, f",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Calculation!G17","v":""}]
[]
[null,null,"Die Mindestdicken werden nach Artikel 3.02 und Artikel 19.02 (Fahrgastschiffe) des ES-TRIN berechnet."]
[null,null,"Die Mindestdicken ergeben sich aus direkten Festigkeitsberechnungen."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Nachuntersuchung erforderlich:",null,null,null,null,null,null,null,null,null,{"$f":"LOOKUP(Calculation!D79,Calculation!A79:A81,Calculation!B79:B81)","v":"Bitte wählen"},null,null,null,null,"Nachuntersuchung durchgeführt:"]
[]
[null,null,"Datum nächste Untersuchung:"]
[]
[]
[]
[null,null,"Erstellt in:"]
[null,null,null,null,null,null,"(Ort)"]
[]
[null,null,null,null,"am:",null,null,null,null,null,null,null,null,null,null,"Inspector:"]
[null,null,null,null,null,null,"(Datum)",null,null,null,null,null,null,null,null,null,null,null,null,"(Name, Stempel, Unterschrift)"]

{"sheet":"Calculation","index":1,"n_rows":93,"n_cols":11,"rows_kept":93,"cut":false,"hidden":true,"merged":[[25,8,25,13],[0,8,0,13],[1,8,3,13],[4,8,4,13],[6,4,8,13],[20,8,21,13],[16,8,16,13],[18,8,18,13],[19,8,19,13],[5,8,5,13],[17,8,17,13],[10,5,10,13],[50,8,50,13],[28,4,30,13],[32,5,33,13],[37,8,37,13],[43,4,44,13],[38,8,38,13]]}
["Art des Schiffes",null,null,null,null,"L=",{"$f":"Report!H23","v":0},"-","die größte Länge des Schiffskörpers  in m , ohne Ruder und Bugspriet "]
[1,"Bitte wählen",null,1,null,"T=",{"$f":"Report!H24","v":0},"-","der senkrechte Abstand vom tiefsten Punkt des Schiffskörpers, ohne Berücksichtigung des Kiels oder anderer fester Anbauten, bis zur Ebene der größten Einsenkung des Schiffskörpers in m"]
[2,"Binnenschiff"]
[3,"Seeschiff"]
[4,"Motortankschiff",null,null,null,"a=",{"$f":"Report!L27","v":0},"-","Spantabstand - Boden / Kimm"]
[5,"Gütermotorschiff",null,null,null,null,{"$f":"Report!L28","v":0},"-","Spantabstand - Schiffskörper"]
[6,"Kanalpeniche",null,null,"Artikel 3.02\nFestigkeit und Stabilität"]
[7,"Schleppboot"]
[8,"Schubboot"]
[9,"Tankschleppkahn"]
[10,"Güterschleppkahn",null,null,"1.","Die Festigkeit des Schiffskörpers muss den Beanspruchungen genügen, denen er unter normalen Bedingungen ausgesetzt ist."]
[11,"Tankschubleichter",null,null,null,"(b)","1.          tmin = f ⋅ b ⋅ c ⋅ (2,3 + 0,04 ⋅ L)",null,null,", [mm]","für L > 40,0 m"]
[12,"Güterschubleichter",null,null,null,null,"             tmin = f ⋅ b ⋅ c ⋅ (1,5 + 0,06 ⋅ L) ≥ 3",null,null,", [mm]","für L ≤ 40,0 m"]
[13,"Trägerschiffsleichter",null,null,null,null,"oder"]
[14,"Segelfahrgastschiff",19,null,null,null,"2.          tmin = 0,005 ⋅ a ⋅ T 0,5",null,null,", [mm]"]
[15,"Tagesausflugsschiff",19]
[16,"Kabinenschiff",19,null,null,"f=",{"$f":"IF(G1=0,\"\",IF(G5<=500,1,(1+(0.0013*(G5-500)))))","v":""},"-","Faktor für Spantabstand - Boden / Kimm"]
[17,"Schnelles Schiff",null,null,null,null,{"$f":"IF(G1=0,\"\",IF(G6<=500,1,(1+(0.0013*(G6-500)))))","v":""},null,"Faktor für Spantabstand - Seite"]
[18,"Schwimmende Geräte",null,null,null,"bBS=",{"$f":"IF(G1=0,\"\",1)","v":""},"-","Faktor für Boden- und Seitenplatten "]
[19,"Baustellenfahrzeuge",null,null,null,"bKIMM=",{"$f":"IF(G1=0,\"\",1.25)","v":""},"-","Faktor für Kimmplatten"]
[20,"Sportfahrzeuge",null,null,null,"c=",{"$f":"IF(G1=0,\"\",IF(Report!S24=TRUE,IF(Report!S25=TRUE,IF(Report!S26=TRUE,0.95,1),1),1))","v":""},"-",{"$f":"\"Faktor für Bauart \"&IF(Report!S24=TRUE,IF(Report!S25=TRUE,IF(Report!S26=TRUE,\"(für Schiffe mit Doppelboden und Wallgang, deren seitliches Laderaumbegrenzungsschott senkrecht unter dem Dennebaum\nangeordnet ist)\",\"(für Schiffe mit Doppelboden und Wallgang)\"),IF(Report!S26=TRUE,\"(für Schiffe mit Doppelboden)\",\"(für Schiffe mit Doppelboden)\")),IF(Report!S25=TRUE,IF(Report!S26=TRUE,\"(für Schiffe deren seitliches Laderaumbegrenzungsschott senkrecht unter dem Dennebaum\nangeordnet ist)\",\"(für Schiffe mit Wallgang)\"),IF(Report!S26=TRUE,\"\",\"\")))&\"\"","v":"Faktor für Bauart "}]
[21,"Traditionsfahrzeug"]
[]
["Das Schiff ist",null,null,null,null,"tmin=",{"$f":"IF(G1=0,\"\",MAX(IF(G1>40,G17*G19*G21*(2.3+(0.04*G1)),MAX((G17*G19*G21*(1.5+(0.06*G1))),3)),0.005*G5*SQRT(G2)))","v":""},"-","Bodenplatten"]
[1,"Bitte wählen",null,1,null,"tmin=",{"$f":"IF(G1=0,\"\",MAX(IF(G1>40,1*G19*G21*(2.3+(0.04*G1)),MAX((1*G19*G21*(1.5+(0.06*G1))),3)),0.005*G6*SQRT(G2)))","v":""},"-","Seitenplatten"]
[2,"geschweißt","geschweißt",null,null,"tmin=",{"$f":"IF(G1=0,\"\",MAX((MAX(IF(G1>40,G17*G20*G21*(2.3+(0.04*G1)),MAX((G17*G20*G21*(1.5+(0.06*G1))),3)),0.005*G5*SQRT(G2))),G24,G25))","v":""},"-","Kimmplatten (muss mehr als die Dicke der Boden und Seitenplatten betragen)"]
[3,"genietet","genietet"]
[4,"teilweise geschweißt, genietet","teilweise geschweißt, genietet"]
[null,null,null,null,"Artikel 19.02\nSchiffskörper"]
["Propeller"]
[1,"Bitte wählen",null,1]
[2,"Propeller","Propeller"]
[3,"Ruderpropeller","Ruderpropeller",null,"1.","Die Dicke der Außenhaut stählerner Fahrgastschiffe ist bei wiederkehrenden Untersuchungen wie folgt festzulegen:"]
[4,"Wasserstrahl","Wasserstrahl"]
[5,"Zykloidalpropeller","Zykloidalpropeller",null,null,"(a)","tmin =  0,006 ⋅ a ⋅ T 0,5 ≥ 3",null,", [mm]"]
[6,"k.A.","k.A.",null,null,null,"tmin = f ⋅ 0,55 ⋅ LF0,5  ≥ 3",null,", [mm]"]
[]
["Zustand des Antriebssystems:",null,null,null,null,"f=",{"$f":"IF(G1=0,\"\",IF(G5<400,(1+0.0013*(400-500)),(1+0.0013*(G5-500))))","v":""},"-","Faktor für Spantabstand - Boden / Kimm"]
[1,"Bitte wählen",null,1,null,null,{"$f":"IF(G1=0,\"\",IF(G6<400,(1+0.0013*(400-500)),(1+0.0013*(G6-500))))","v":""},"-","Faktor für Spantabstand - Seite"]
[2,"gut","gut"]
[3,"reparaturbedürftig","reparaturbedürftig",null,null,"tmin=",{"$f":"IF(G1=0,\"\",MAX((IF(G5<400,0.006*400*SQRT(G2),0.006*G5*SQRT(G2))),(0.55*G38*SQRT(G1)),3))","v":""},"Boden/Kimm"]
[4,"k.A.","k.A.",null,null,null,{"$f":"IF(G1=0,\"\",MAX((IF(G6<400,0.006*400*SQRT(G2),0.006*G6*SQRT(G2))),(0.55*G39*SQRT(G1)),3))","v":""},"Seite"]
[]
["Zustand der Steuereinrichtung:",null,null,null,"FINAL"]
[1,"Bitte wählen",null,1]
[2,"gut","gut"]
[3,"reparaturbedürftig","reparaturbedürftig",null,null,"Art des Schiffs:",null,{"$f":"LOOKUP(Calculation!D2,Calculation!A2:A22,Calculation!B2:B22)","v":"Bitte wählen"},null,{"$f":"LOOKUP(Calculation!D2,Calculation!A2:A22,Calculation!C2:C22)","v":0}]
[4,"k.A.","k.A."]
[null,null,null,null,null,"tmin=",{"$f":"IF(J47=19,G41,G24)","v":""},"-","Bodenplatten"]
["Ruderspiel",null,null,null,null,"tmin=",{"$f":"IF(J47=19,G42,G25)","v":""},"-","Seitenplatten"]
[1,"Bitte wählen",null,1,null,"tmin=",{"$f":"IF(J47=19,G41,G26)","v":""},"-","Kimmplatten (muss mehr als die Dicke der Boden und Seitenplatten betragen)"]
[2,"Akzeptabel","Akzeptabel"]
[3,"Nicht akzeptabel","Nicht akzeptabel"]
[4,"k.A.","k.A."]
[]
["Zustand der Propellerwelle und Spiel"]
[1,"Bitte wählen",null,1]
[2,"gut","gut"]
[3,"reparaturbedürftig","reparaturbedürftig"]
[4,"k.A.","k.A."]
[]
["Propellerwellenspiel"]
[1,"Bitte wählen",null,1]
[2,"Akzeptabel","Akzeptabel"]
[3,"Nicht akzeptabel","Nicht akzeptabel"]
[4,"k.A.","k.A."]
[]
["Zustand der Schotte, Bodenwrangen, Seitenspanten, Stützplatten"]
[1,"Bitte wählen",null,1]
[2,"gut","gut"]
[3,"reparaturbedürftig","reparaturbedürftig"]
[]
["Zustand des Schiffsboden"]
[1,"Bitte wählen",null,1]
[2,"gut","gut"]
[3,"reparaturbedürftig","reparaturbedürftig"]
[]
["Zusätzliche Prüfungen"]
[1,"Bitte wählen",null,1]
[2,"Ja"]
[3,"Nein"]
[]
["Zustand der Seekastenventile"]
[1,"Bitte wählen",null,1]
[2,"gut","gut"]
[3,"reparaturbedürftig","reparaturbedürftig"]
[4,"k.A.","k.A."]
[]
["Zustand der Anker- und Anlegeausrüstung "]
[1,"Bitte wählen",null,1]
[2,"gut","gut"]
[3,"reparaturbedürftig","reparaturbedürftig"]
[4,"k.A.","k.A."]

{"sheet":"Default","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}