{"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":[[8,20,8,24],[9,20,9,24],[10,20,10,24],[4,21,4,25],[5,21,5,25],[3,20,3,25],[3,26,3,32],[4,26,4,32],[5,26,5,32],[6,6,6,19],[0,28,0,33],[23,20,23,25],[23,28,23,32],[0,24,0,27],[1,28,1,33],[12,0,12,34],[1,23,1,27],[1,0,1,22],[30,1,31,12],[20,0,20,34],[22,18,22,32],[9,2,9,6],[10,2,10,6],[8,1,8,6],[8,25,8,32],[9,25,9,32],[10,25,10,32],[4,1,4,5],[5,1,5,5],[6,1,6,5],[4,6,4,17],[5,6,5,17],[8,7,8,17],[22,1,22,6],[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],[72,0,72,10],[113,2,113,11],[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],[40,24,40,32],[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],[3,1,3,5],[3,6,3,17],[9,7,9,17],[10,7,10,17],[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],[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],[27,23,28,32],[27,19,28,22],[70,17,70,29],[71,17,71,29],[72,17,72,29],[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],[24,20,24,32],[28,1,28,6],[28,7,28,15],[27,7,27,10],[27,11,27,15],[25,1,25,6],[30,28,31,32],[25,20,26,32]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rapport nr.:"]
["Algemene gegevens",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Onderzoek ID:"]
[]
[null,"Scheepsnaam:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Meettoestel:"]
[null,"ENI nr.:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Serienummer:"]
[null,"Klasse nr.:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Laatste ijking:"]
[null,"Type schip:",null,null,null,null,{"$f":"LOOKUP(Calculation!D2,Calculation!A2:A22,Calculation!B2:B22)","v":"(keuze)"}]
[]
[null,"Certificaat nr.:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Overige 1"]
[null,null,"Afgegeven op:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Overige 2"]
[null,null,"Geldig tot:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Overige 3"]
[]
["Eigenaar"]
[]
[null,"Naam:"]
[null,"Adres:"]
[null,"Contact persoon(-en):"]
[null,"E-mail:"]
[null,"Tel.:"]
[]
["Scheepsgegevens"]
[" "]
[null,"Lengte, L",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bouwwijze:"]
[null,"Diepgang, T",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,null,"Dubbele bodem",null,null,null,null,null,null,null,"Dubbelwandig"]
[null,"Breedte, B",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,null,"Zijtanks"]
[null,"DWT",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,null,"Met laadruimlangsschot in de zijde verticaal onder de denneboom"]
[null,"Spantafstand, a",null,null,null,null,null,"bodem/kim"]
[null,null,null,null,null,null,null,"romp",null,null,null,null,null,null,null,null,null,null,null,"Het schip is",null,null,null,{"$f":"LOOKUP(Calculation!D25,Calculation!A25:A28,Calculation!C25:C28)","v":0}]
[null,"Materiaal romp"]
[]
[null,"Het schip is geschikt om te varen in de 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]
[]
[]
["Resultaten van het onderzoek en spelingen"]
[" "]
["1.",{"$f":"\"Conditie voortstuwingssysteem\"&IF(Calculation!D31=1,IF(AI36=TRUE,\" (boegschroefinstallaties)\",\"\"),IF(LOOKUP(Calculation!D31,Calculation!A31:A36,Calculation!C31:C36)=\"N/A\",IF(AI36=TRUE,\" (boegschroefinstallaties)\",\"\"),IF(AI36=TRUE,\" (\"&LOOKUP(Calculation!D31,Calculation!A31:A36,Calculation!C31:C36)&\", boegschroefinstallaties)\",\" (\"&LOOKUP(Calculation!D31,Calculation!A31:A36,Calculation!C31:C36&\")\"))))&\":\"","v":"Conditie voortstuwingssysteem:"},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.","Conditie stuurmachine:",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,"Speling roer:",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.","Conditie schroefaskoker en speling:",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,"Speling schroefaskoker:",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.","Conditie van de schotten, dekken, spanten, knieën:",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.","Conditie bodemplaat:",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.","Conditie van inlaatkasten en buitenboordafsluiters:",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}]
[]
["Beschrijving van de conditie van de scheepsromp"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Opmerkingen / aanvullende informatie"]
[]
[]
[]
[]
[]
[]
[]
[]
["Criteria voor de goedkeuring van de gemeten dikte"]
[]
["Minimumdikte bodembeplating",null,null,null,null,null,null,null,null,null,null,{"$f":"Calculation!G49","v":""},null,null,null,null,null,"Factor voor bodem-, kim- en huidbeplating, 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":""}]
["Minimumdikte huidbeplating",null,null,null,null,null,null,null,null,null,null,{"$f":"Calculation!G50","v":""},null,null,null,null,null,"Factor voor bouwwijze c",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Calculation!G21","v":""}]
["Minimumdikte kimbeplating",null,null,null,null,null,null,null,null,null,null,{"$f":"Calculation!G51","v":""},null,null,null,null,null,"Factor spantafstand f",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Calculation!G17","v":""}]
[]
[null,null,"De minimumdikte wordt berekend overeenkomstig art. 3.02 en art. 19.02 (passagiersschip) van de ES-TRIN."]
[null,null,"De minimumdikte is het resultaat van de sterkteberekening."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Aanvullend onderzoek vereist:",null,null,null,null,null,null,null,null,null,{"$f":"LOOKUP(Calculation!D79,Calculation!A79:A81,Calculation!B79:B81)","v":"(keuze)"},null,null,null,"Aanvullend onderzoek uitvoeren op:"]
[]
[null,null,"Datum van volgend onderzoek"]
[]
[]
[]
[null,null,null,null,null,"Afgegeven te:"]
[null,null,null,null,null,null,"(plaats)"]
[]
[null,null,null,null,"op:",null,null,null,null,null,null,null,null,null,null,"Inspecteur:"]
[null,null,null,null,null,null,"(plaats)",null,null,null,null,null,null,null,null,null,null,null,null,"(naam, stempel, handtekening)"]

{"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],[10,5,10,13]]}
["Type vaartuig",null,null,null,null,"L=",{"$f":"Report!H23","v":0},"-","de maximale lengte van de scheepsromp in m, zonder roer en boegspriet,"]
[1,"(keuze)",null,1,null,"T=",{"$f":"Report!H24","v":0},"-","de verticale afstand in m tussen het laagste punt van de scheepsromp zonder rekening te houden met de kiel of andere appendages en de maximale diepgangslijn,"]
[2,"Binnenschip"]
[3,"Zeeschip"]
[4,"Motortankschip",null,null,null,"a=",{"$f":"Report!L27","v":0},"-","afstand tussen spanten - bodem / kim"]
[5,"Motorvrachtschip",null,null,null,null,{"$f":"Report!L28","v":0},"-","afstand tussen spanten - scheepsromp"]
[6,"Kanaalspits",null,null,"Article 3.02\nSterkte en stabiliteit"]
[7,"Sleepboot"]
[8,"Duwboot"]
[9,"Sleeptankschip"]
[10,"Sleepvrachtschip",null,null,"1.","De sterkte van de scheepsromp moet zodanig zijn dat zij in overeenstemming is met de belasting waaraan de romp onder normale omstandigheden is blootgesteld."]
[11,"Tankduwbak",null,null,null,"(b)","1.          tmin = f ⋅ b ⋅ c ⋅ (2,3 + 0,04 ⋅ L)",null,null,", [mm]","voor L > 40,0 m"]
[12,"Vrachtduwbak",null,null,null,null,"             tmin = f ⋅ b ⋅ c ⋅ (1,5 + 0,06 ⋅ L) ≥ 3",null,null,", [mm]","voor L ≤ 40,0 m"]
[13,"Zeeschipbak",null,null,null,null,"of"]
[14,"Zeilend passagiersschip",19,null,null,null,"2.          tmin = 0,005 ⋅ a ⋅ T 0,5",null,null,", [mm]"]
[15,"Dagtochtschip",19]
[16,"Hotelschip",19,null,null,"f=",{"$f":"IF(G1=0,\"\",IF(G5<=500,1,(1+(0.0013*(G5-500)))))","v":""},"-","factor voor spantafstand - bodem / kim"]
[17,"Snel schip",null,null,null,null,{"$f":"IF(G1=0,\"\",IF(G6<=500,1,(1+(0.0013*(G6-500)))))","v":""},null,"factor spantafstand - zijbeplating"]
[18,"Drijvend werktuig",null,null,null,"bBS=",{"$f":"IF(G1=0,\"\",1)","v":""},"-","factor voor bodem- en zijbeplating"]
[19,"Schip bestemd voor bouwwerkzaamheden",null,null,null,"bKIM=",{"$f":"IF(G1=0,\"\",1.25)","v":""},"-","factor voor kimbeplating"]
[20,"Pleziervaartuig",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 voor bouwwijze \"&IF(Report!S24=TRUE,IF(Report!S25=TRUE,IF(Report!S26=TRUE,\"(dubbele bodem en zijtanks, waarvan het laadruimlangsschot in de zijde verticaal onder de dennenboom is geplaatst)\",\"(dubbele bodem en zijtanks)\"),IF(Report!S26=TRUE,\"(dubbele bodem)\",\"(dubbele bodem)\")),IF(Report!S25=TRUE,IF(Report!S26=TRUE,\"(waarvan het laadruimlangsschot in de zijde verticaal onder de dennenboom is geplaatst)\",\"(zijtanks)\"),IF(Report!S26=TRUE,\"\",\"\")))&\"\"","v":"factor voor bouwwijze "}]
[21,"Traditioneel vaartuig"]
[]
["Het schip 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":""},"-","bodembeplating"]
[1,"(keuze)",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":""},"-","zijbeplating"]
[2,"Gelast","Gelast",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":""},"-","kimbeplating (moet meer zijn dan bodembeplating en dikte zijbeplating)"]
[3,"Geklonken","Geklonken"]
[4,"Gedeeltelijk gelast, gedeeltelijk geklonken","Gedeeltelijk gelast, gedeeltelijk geklonken"]
[null,null,null,null,"Article 19.02\nScheepsromp"]
["Schroef"]
[1,"(keuze)",null,1]
[2,"Propeller","Propeller"]
[3,"Roerpropeller","Roerpropeller",null,"1.","Bij een periodiek onderzoek wordt de dike van de scheepshuid van stalen passagiersschepen als volgt vastgesteld:"]
[4,"Waterstraalschroef","Waterstraalschroef"]
[5,"Cycloïdaalschroef","Cycloïdaalschroef",null,null,"(a)","tmin =  0,006 ⋅ a ⋅ T 0,5 ≥ 3",null,", [mm]"]
[6,"Niet van toepassing","Niet van toepassing",null,null,null,"tmin = f ⋅ 0,55 ⋅ LF0,5  ≥ 3",null,", [mm]"]
[]
["Conditie van de schroef",null,null,null,null,"f=",{"$f":"IF(G1=0,\"\",IF(G5<400,(1+0.0013*(400-500)),(1+0.0013*(G5-500))))","v":""},"-","factor voor spantafstand - bodem / kim"]
[1,"(keuze)",null,1,null,null,{"$f":"IF(G1=0,\"\",IF(G6<400,(1+0.0013*(400-500)),(1+0.0013*(G6-500))))","v":""},"-","factor voor spantafstand - zijbeplating"]
[2,"Goed","Goed"]
[3,"Reparatie vereist","Reparatie vereist",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":""},"bodem / kim"]
[4,"Niet van toepassing","Niet van toepassing",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":""},"zijbeplating"]
[]
["Conditie van de stuurmachine",null,null,null,"EINDBEOORDELING"]
[1,"(keuze)",null,1]
[2,"Goed","Goed"]
[3,"Reparatie vereist","Reparatie vereist",null,null,"Type schip:",null,{"$f":"LOOKUP(Calculation!D2,Calculation!A2:A22,Calculation!B2:B22)","v":"(keuze)"},null,{"$f":"LOOKUP(Calculation!D2,Calculation!A2:A22,Calculation!C2:C22)","v":0}]
[4,"Niet van toepassing","Niet van toepassing"]
[null,null,null,null,null,"tmin=",{"$f":"IF(J47=19,G41,G24)","v":""},"-","bodembeplating"]
["Speling roer",null,null,null,null,"tmin=",{"$f":"IF(J47=19,G42,G25)","v":""},"-","zijbeplating"]
[1,"(keuze)",null,1,null,"tmin=",{"$f":"IF(J47=19,G41,G26)","v":""},"-","kimbeplating (moet meer zijn dan bodembeplating en dikte zijbeplating)"]
[2,"Acceptabel","Acceptabel"]
[3,"Niet acceptabel","Niet acceptabel"]
[4,"Niet van toepassing","Niet van toepassing"]
[]
["Conditie schroefaskoker en speling"]
[1,"(keuze)",null,1]
[2,"Goed","Goed"]
[3,"Reparatie vereist","Reparatie vereist"]
[4,"Niet van toepassing","Niet van toepassing"]
[]
["Speling schroefaskoker"]
[1,"(keuze)",null,1]
[2,"Acceptabel","Acceptabel"]
[3,"Niet acceptabel","Niet acceptabel"]
[4,"Niet van toepassing","Niet van toepassing"]
[]
["Conditie van de schotten, dekken, spanten, knieën"]
[1,"(keuze)",null,1]
[2,"Goed","Goed"]
[3,"Reparatie vereist","Reparatie vereist"]
[]
["Conditie bodemplaat"]
[1,"(keuze)",null,1]
[2,"Goed","Goed"]
[3,"Reparatie vereist","Reparatie vereist"]
[]
["Aanvullend onderzoek"]
[1,"(keuze)",null,1]
[2,"Ja"]
[3,"Nee"]
[]
["Conditie inlaatkasten en buitenboordafsluiters"]
[1,"(keuze)",null,1]
[2,"Goed","Goed"]
[3,"Reparatie vereist","Reparatie vereist"]
[4,"Niet van toepassing","Niet van toepassing"]
[]
["Conditie van ankers en ankeruitrusting"]
[1,"(keuze)",null,1]
[2,"Goed","Goed"]
[3,"Reparatie vereist","Reparatie vereist"]
[4,"Niet van toepassing","Niet van toepassing"]

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