{"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":[[120,6,120,11],[120,19,120,33],[72,0,72,10],[120,4,120,5],[118,6,118,11],[120,15,120,18],[113,2,113,11],[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],[5,19,5,23],[1,0,1,24],[12,0,12,34],[20,0,20,34],[14,7,14,32],[15,7,15,32],[14,1,14,6],[22,18,22,32],[3,24,3,32],[4,24,4,32],[113,12,113,17],[111,16,111,26],[111,12,111,14],[43,24,43,32],[43,1,43,23],[111,2,111,11],[111,27,111,32],[70,30,70,34],[71,30,71,34],[72,30,72,34],[74,2,74,34],[75,2,75,34],[70,11,70,15],[71,11,71,15],[72,11,72,15],[70,18,70,29],[71,18,71,29],[47,1,47,23],[47,24,47,32],[40,24,40,32],[40,1,40,23],[30,1,30,12],[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],[5,24,5,32],[8,7,8,15],[9,7,9,15],[9,2,9,6],[10,2,10,6],[8,1,8,6],[6,1,6,6],[4,7,4,15],[5,7,5,15],[3,7,3,15],[10,7,10,15],[6,7,6,15],[3,1,3,6],[4,1,4,6],[5,1,5,6],[22,1,22,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],[15,1,15,6],[26,7,26,10],[26,11,26,15],[16,1,16,6],[17,1,17,6],[18,1,18,6],[16,7,16,32],[17,7,17,32],[18,7,18,32],[25,20,26,32],[117,2,117,5],[24,20,24,32],[28,1,28,6],[28,7,28,15],[115,0,115,34],[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],[27,7,27,10],[27,11,27,15],[27,19,27,22],[27,23,27,32],[25,1,25,6],[30,28,31,32],[72,18,72,29],[70,0,70,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,"Report No.:"]
["General data",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,"Vessel name:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Measuring device:"]
[null,"ENI No.:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Serial number:"]
[null,"Class No.:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Last calibration:"]
[null,"Type of vessel:",null,null,null,null,null,{"$f":"LOOKUP(Calculation!D2,Calculation!A2:A22,Calculation!B2:B22)","v":"(choose)"}]
[]
[null,"Certificate No.:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Other 1"]
[null,null,"Issued:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Other 2"]
[null,null,"Valid until:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Other 3"]
[]
["Owner"]
[]
[null,"Name:"]
[null,"Adress:"]
[null,"Contact person(s):"]
[null,"E-mail:"]
[null,"Tel.:"]
[]
["Vessel data"]
[" "]
[null,"Length, L",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Structure type:"]
[null,"Draught, T",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,null,"Double bottom",null,null,null,null,null,null,null,"Double hull"]
[null,"Breadth, B",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,null,"Wing voids"]
[null,"DWT",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,null,"Partition between wing void and hold is located vertically in line with the coaming"]
[null,"Frame spacing, a",null,null,null,null,null,"bottom/bilge"]
[null,null,null,null,null,null,null,"hull",null,null,null,null,null,null,null,null,null,null,null,"The ship is",null,null,null,{"$f":"LOOKUP(Calculation!D25,Calculation!A25:A28,Calculation!C25:C28)","v":0}]
[null,"Hull material"]
[]
[null,"The vessel is fit to operate in Zone(s):",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]
[]
[]
["Inspection results and clearances"]
[" "]
["1.",{"$f":"\"Condition of propulsion system\"&IF(Calculation!D31=1,IF(AI36=TRUE,\" (bow-thruster system)\",\"\"),IF(LOOKUP(Calculation!D31,Calculation!A31:A36,Calculation!C31:C36)=\"N/A\",IF(AI36=TRUE,\" (bow-thruster system)\",\"\"),IF(AI36=TRUE,\" (\"&LOOKUP(Calculation!D31,Calculation!A31:A36,Calculation!C31:C36)&\", bow-thruster system)\",\" (\"&LOOKUP(Calculation!D31,Calculation!A31:A36,Calculation!C31:C36&\")\"))))&\":\"","v":"Condition of propulsion system:"},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.","Condition of steering system:",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,"Rudder clearance:",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.","Condition of propeller shaft and clearances:",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,"Propeller shaft clearance:",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.","Condition of bulkheads, floors, side frames, brackets:",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.","Condition of bottom:",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.","Condition of river chest valve:",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}]
[]
["Description of the hull condition"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Comments / remarks"]
[]
[]
[]
[]
[]
[]
[]
[]
["Thickness measurements acceptance criteria"]
[]
["Minimum bottom plating thickness",null,null,null,null,null,null,null,null,null,null,{"$f":"Calculation!G49","v":""},null,null,null,null,null,null,"Factor for bottom, side or bilge plates, b",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":""}]
["Minimum side plating thickness",null,null,null,null,null,null,null,null,null,null,{"$f":"Calculation!G50","v":""},null,null,null,null,null,null,"Factor for the type of structure c",null,null,null,null,null,null,null,null,null,null,null,{"$f":"Calculation!G21","v":""}]
["Minimum bilge plating thickness",null,null,null,null,null,null,null,null,null,null,{"$f":"Calculation!G51","v":""},null,null,null,null,null,null,"Frame spacing factor f",null,null,null,null,null,null,null,null,null,null,null,{"$f":"Calculation!G17","v":""}]
[]
[null,null,"The minimum thicknesses are calculated according to Art. 3.02 and Art. 19.02 (Passenger ship) of ES-TRIN."]
[null,null,"The minimum thicknesses are a result of direct strength calculations."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Additional inspection required:",null,null,null,null,null,null,null,null,null,{"$f":"LOOKUP(Calculation!D79,Calculation!A79:A81,Calculation!B79:B81)","v":"(choose)"},null,null,null,"Additional inspection carried out on:"]
[]
[null,null,"Date of the next inspection:"]
[]
[]
[]
[null,null,"Issued at:"]
[null,null,null,null,null,null,"(place)"]
[]
[null,null,null,null,"on:",null,null,null,null,null,null,null,null,null,null,"Inspector:"]
[null,null,null,null,null,null,"(date)",null,null,null,null,null,null,null,null,null,null,null,null,"(name, stamp, signature)"]

{"sheet":"Calculation","index":1,"n_rows":93,"n_cols":11,"rows_kept":93,"cut":false,"hidden":true,"merged":[[50,8,50,13],[28,4,30,13],[32,5,33,13],[37,8,37,13],[43,4,44,13],[38,8,38,13],[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]]}
["Type of vessel",null,null,null,null,"L=",{"$f":"Report!H23","v":0},"-","the maximum length of the hull in m, excluding rudder and bowsprit,"]
[1,"(choose)",null,1,null,"T=",{"$f":"Report!H24","v":0},"-","the vertical distance in m between the lowest point of the hull without taking into account the keel or other fixed attachments and the maximum draught line,"]
[2,"Inland waterway vessel"]
[3,"Sea-going ship"]
[4,"Motor tanker",null,null,null,"a=",{"$f":"Report!L27","v":0},"-","frame spacing - bottom / bilge"]
[5,"Motor cargo vessel",null,null,null,null,{"$f":"Report!L28","v":0},"-","frame spacing - hull"]
[6,"Canal barge",null,null,"Article 3.02\nStrength and stability"]
[7,"Tug"]
[8,"Pusher"]
[9,"Tank barge"]
[10,"Dumb barge",null,null,"1.","The hull shall be sufficiently strong to withstand all of the stresses to which it is normally subjected."]
[11,"Tank lighter",null,null,null,"(b)","1.          tmin = f ⋅ b ⋅ c ⋅ (2,3 + 0,04 ⋅ L)",null,null,", [mm]","for L > 40,0 m"]
[12,"Cargo lighter",null,null,null,null,"             tmin = f ⋅ b ⋅ c ⋅ (1,5 + 0,06 ⋅ L) ≥ 3",null,null,", [mm]","for L ≤ 40,0 m"]
[13,"Ship-borne lighter",null,null,null,null,"or"]
[14,"Passenger sailing vessel",19,null,null,null,"2.          tmin = 0,005 ⋅ a ⋅ T 0,5",null,null,", [mm]"]
[15,"Day-trip vessel",19]
[16,"Cabin vessel",19,null,null,"f=",{"$f":"IF(G1=0,\"\",IF(G5<=500,1,(1+(0.0013*(G5-500)))))","v":""},"-","frame spacing factor - bottom / bilge"]
[17,"High-speed vessel",null,null,null,null,{"$f":"IF(G1=0,\"\",IF(G6<=500,1,(1+(0.0013*(G6-500)))))","v":""},null,"frame spacing factor - side"]
[18,"Floating equipment",null,null,null,"bBS=",{"$f":"IF(G1=0,\"\",1)","v":""},"-","factor for bottom plates and side plates"]
[19,"Worksite craft",null,null,null,"bBILGE=",{"$f":"IF(G1=0,\"\",1.25)","v":""},"-","factor for bilge plates"]
[20,"Recreational craft",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":"\"factor for the type of structure \"&IF(Report!S24=TRUE,IF(Report!S25=TRUE,IF(Report!S26=TRUE,\"(double bottom, partition between wing void and hold is located vertically in line with the coaming)\",\"(double bottom, wing voids)\"),IF(Report!S26=TRUE,\"(double bottom)\",\"(double bottom)\")),IF(Report!S25=TRUE,IF(Report!S26=TRUE,\"(partition between wing void and hold is located vertically in line with the coaming)\",\"(wing voids)\"),IF(Report!S26=TRUE,\"\",\"\")))&\"\"","v":"factor for the type of structure "}]
[21,"Traditional craft"]
[]
["The ship is",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":""},"-","bottom plates"]
[1,"(choose)",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":""},"-","side plates"]
[2,"Welded","welded",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":""},"-","bilge plates (must be more than bottom plates and side plates thickness)"]
[3,"Riveted","riveted"]
[4,"Partly welded, riveted","partly welded, riveted"]
[null,null,null,null,"Article 19.02\nHull"]
["Propeller"]
[1,"(choose)",null,6]
[2,"Propeller","propeller"]
[3,"Rudder-propeller","rudder-propeller",null,"1.","In the course of the periodical inspections, the thickness of the outside plating of steel\npassenger vessels shall be determined as follows:"]
[4,"Water-jet","water-jet"]
[5,"Cycloidal-propeller","cycloidal-propeller",null,null,"(a)","tmin =  0,006 ⋅ a ⋅ T 0,5 ≥ 3",null,", [mm]"]
[6,"N/A","N/A",null,null,null,"tmin = f ⋅ 0,55 ⋅ LF0,5  ≥ 3",null,", [mm]"]
[]
["Condition of propeller",null,null,null,null,"f=",{"$f":"IF(G1=0,\"\",IF(G5<400,(1+0.0013*(400-500)),(1+0.0013*(G5-500))))","v":""},"-","frame spacing factor - bottom / bilge"]
[1,"(choose)",null,1,null,null,{"$f":"IF(G1=0,\"\",IF(G6<400,(1+0.0013*(400-500)),(1+0.0013*(G6-500))))","v":""},"-","frame spacing factor - side"]
[2,"In order","in order"]
[3,"Repair needed","repair needed",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":""},"bottom / bilge"]
[4,"N/A","N/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":""},"side"]
[]
["Condition of steering system",null,null,null,"FINAL"]
[1,"(choose)",null,1]
[2,"In order","in order"]
[3,"Repair needed","repair needed",null,null,"Type of vessel:",null,{"$f":"LOOKUP(Calculation!D2,Calculation!A2:A22,Calculation!B2:B22)","v":"(choose)"},null,{"$f":"LOOKUP(Calculation!D2,Calculation!A2:A22,Calculation!C2:C22)","v":0}]
[4,"N/A","N/A"]
[null,null,null,null,null,"tmin=",{"$f":"IF(J47=19,G41,G24)","v":""},"-","bottom plates"]
["Rudder clearance",null,null,null,null,"tmin=",{"$f":"IF(J47=19,G42,G25)","v":""},"-","side plates"]
[1,"(choose)",null,1,null,"tmin=",{"$f":"IF(J47=19,G41,G26)","v":""},"-","bilge plates (must be more than bottom plates and side plates thickness)"]
[2,"Acceptable","acceptable"]
[3,"Not acceptable","not acceptable"]
[4,"N/A","N/A"]
[]
["Condition of propeller shaft and clearances"]
[1,"(choose)",null,1]
[2,"In order","in order"]
[3,"Repair needed","repair needed"]
[4,"N/A","N/A"]
[]
["Propeller shaft clearance"]
[1,"(choose)",null,1]
[2,"Acceptable","acceptable"]
[3,"Not acceptable","not acceptable"]
[4,"N/A","N/A"]
[]
["Condition of bulkheads, floors, side frames, brackets"]
[1,"(choose)",null,1]
[2,"In order","in order"]
[3,"Repair needed","repair needed"]
[]
["Condition of bottom"]
[1,"(choose)",null,1]
[2,"In order","in order"]
[3,"Repair needed","repair needed"]
[]
["Additional inspection"]
[1,"(choose)",null,1]
[2,"Yes"]
[3,"No"]
[]
["Condition of river chest valve"]
[1,"(choose)",null,1]
[2,"In order","in order"]
[3,"Repair needed","repair needed"]
[4,"N/A","N/A"]
[]
["Condition of anchoring and mooring equpment"]
[1,"(choose)",null,1]
[2,"In order","in order"]
[3,"Repair needed","repair needed"]
[4,"N/A","N/A"]

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