{"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":[[6,7,6,17],[3,25,3,32],[4,25,4,32],[5,25,5,32],[35,1,36,23],[35,24,36,32],[42,24,42,32],[42,2,42,23],[33,0,33,34],[38,24,38,32],[38,1,38,23],[39,24,39,32],[39,2,39,23],[27,18,27,22],[30,1,31,12],[70,0,70,12],[71,0,71,12],[72,0,72,12],[70,13,70,15],[71,13,71,15],[72,13,72,15],[26,1,27,6],[25,8,25,15],[28,1,28,7],[26,7,26,11],[27,7,27,11],[22,1,22,7],[23,1,23,7],[24,1,24,7],[25,1,25,7],[26,12,26,15],[27,12,27,15],[28,8,28,15],[3,1,3,6],[4,1,4,6],[5,1,5,6],[25,20,26,32],[8,7,8,15],[9,7,9,15],[9,2,9,6],[10,2,10,6],[8,1,8,6],[14,1,14,8],[15,1,15,8],[16,1,16,8],[17,1,17,8],[18,1,18,8],[14,9,14,32],[15,9,15,32],[16,9,16,32],[17,9,17,32],[18,9,18,32],[22,8,22,15],[23,8,23,15],[24,8,24,15],[20,0,20,34],[22,18,22,32],[121,19,121,33],[68,0,68,34],[46,24,46,32],[46,1,46,23],[50,0,50,34],[51,1,57,34],[59,0,59,34],[60,1,67,34],[121,6,121,11],[117,6,117,11],[120,6,120,11],[120,19,120,33],[120,4,120,5],[118,6,118,11],[120,15,120,18],[117,2,117,5],[24,20,24,32],[115,0,115,34],[27,23,27,32],[30,28,31,32],[41,24,41,32],[41,1,41,23],[113,12,113,17],[111,16,111,26],[111,12,111,14],[44,24,44,32],[44,1,44,23],[111,2,111,11],[111,27,111,32],[74,2,74,34],[75,2,75,34],[113,2,113,11],[48,1,48,23],[48,24,48,32],[70,17,70,28],[71,17,71,28],[72,17,72,28],[70,29,70,33],[71,29,71,33],[72,29,72,33],[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,28,1,33],[12,0,12,34],[6,1,6,6],[4,7,4,15],[5,7,5,15],[1,0,1,21],[1,22,1,27],[0,22,0,27],[3,18,3,24],[4,19,4,24],[3,7,3,15],[10,7,10,15]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rapport n°:"]
["Données générales",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ID de la fonction:"]
[]
[null,"Nom du bateau:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Appareil de mesure:"]
[null,"N° ENI:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Numéro de série:"]
[null,"N° de classe:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Dernier étalonnage:"]
[null,"Type de bateau:",null,null,null,null,null,{"$f":"LOOKUP(Calculation!D2,Calculation!A2:A22,Calculation!B2:B22)","v":"(choisir)"}]
[]
[null,"N° de certificat:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Autres 1"]
[null,null,"Délivré:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Autres 2"]
[null,null,"Valable jusqu'au:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Autres 3"]
[]
["Propriétaire"]
[]
[null,"Nom:"]
[null,"Adresse:"]
[null,"Personne(s) à contacter:"]
[null,"Courriel:"]
[null,"Tél.:"]
[]
["Données du bateau"]
[" "]
[null,"Longueur, L",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Type de structure :"]
[null,"Tirant d’eau, T",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,null,"Double fond",null,null,null,null,null,null,null,"Double coque"]
[null,"Largeur, B",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,null,"Doubles parois"]
[null,"PLD",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,null,"La paroi délimitant la double paroi et la cale est à la verticale sous l'hiloire"]
[null,"Écartement des varangues, a",null,null,null,null,null,"Fond/Bouchain"]
[null,null,null,null,null,null,null,"Coque",null,null,null,null,null,null,null,null,null,null,"Le bâtiment est",null,null,null,null,{"$f":"LOOKUP(Calculation!D25,Calculation!A25:A28,Calculation!C25:C28)","v":0}]
[null,"Matériau de la coque"]
[]
[null,"Le bateau est apte à naviguer dans la/les 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]
[]
[]
["Résultats de la visite et écartements"]
[" "]
["1.",{"$f":"\"Etat du système de propulsion \"&IF(Calculation!D31=1,IF(AI36=TRUE,\" (propulseurs d’étrave)\",\"\"),IF(LOOKUP(Calculation!D31,Calculation!A31:A36,Calculation!C31:C36)=\"N/A\",IF(AI36=TRUE,\" (propulseurs d’étrave)\",\"\"),IF(AI36=TRUE,\" (\"&LOOKUP(Calculation!D31,Calculation!A31:A36,Calculation!C31:C36)&\", propulseurs d’étrave)\",\" (\"&LOOKUP(Calculation!D31,Calculation!A31:A36,Calculation!C31:C36&\")\"))))&\":\"","v":"Etat du système de propulsion :"},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.","État de l'installation de gouverne:",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,"Débattement du gouvernail:",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.","État de l'arbre d'hélice et écartements:",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,"Écartement de l'arbre d'hélice:",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.","État des cloisons, des planchers, des cadres latéraux, des supports:",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.","État du fond:",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.","État de la vanne de coffre de mer:",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 de l'état de la coque"]
[]
[]
[]
[]
[]
[]
[]
[]
["Observations / remarques"]
[]
[]
[]
[]
[]
[]
[]
[]
["Critères d'acceptation des mesures d'épaisseur"]
[]
["Épaisseur minimale des tôles de fond",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Calculation!G49","v":""},null,null,null,"Facteur pour les tôles de fond, de bouchain et de bordé latéral, b",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(I23=0,\"\",\"\"&_xlfn.NUMBERVALUE(ROUND(Calculation!G19,2),2)&\"/\"&ROUND(Calculation!G20,2)&\"\")","v":""}]
["Épaisseur minimale des tôles de bordé latéral",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Calculation!G50","v":""},null,null,null,"Facteur pour le type de structure c",null,null,null,null,null,null,null,null,null,null,null,{"$f":"Calculation!G21","v":""}]
["Épaisseur minimale des tôles de bouchain",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Calculation!G51","v":""},null,null,null,"Facteur pour l'écartement des varangues f",null,null,null,null,null,null,null,null,null,null,null,{"$f":"Calculation!G17","v":""}]
[]
[null,null,"Les épaisseurs minimales sont calculées conformément aux articles 3.02 et 19.02 (bateau à passagers) de l'ES-TRIN."]
[null,null,"Les épaisseurs minimales sont le résultat de calculs directs de la solidité."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Visite supplémentaire requise:",null,null,null,null,null,null,null,null,null,{"$f":"LOOKUP(Calculation!D79,Calculation!A79:A81,Calculation!B79:B81)","v":"(choisir)"},null,null,null,"Visite supplémentaire effectuée le:"]
[]
[null,null,"Date de la prochaine visite:"]
[]
[]
[]
[null,null,"Délivré à:"]
[null,null,null,null,null,null,"(lieu)"]
[]
[null,null,null,null,"le:",null,null,null,null,null,null,null,null,null,null,"Inspecteur:"]
[null,null,null,null,null,null,"(date)",null,null,null,null,null,null,null,null,null,null,null,null,"(nom, cachet, signature)"]

{"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]]}
["Type de bateau",null,null,null,null,"L=",{"$f":"Report!I23","v":0},"-","la longueur maximale de la coque en m gouvernail et beaupré non compris,"]
[1,"(choisir)",null,1,null,"T=",{"$f":"Report!I24","v":0},"-","la distance verticale en m entre le point le plus bas de la coque, la quille ou d’autres appendices fixes non compris, et le plan du plus grand enfoncement,"]
[2,"Bateau de navigation intérieure"]
[3,"Navire de mer"]
[4,"Automoteur-citerne",null,null,null,"a=",{"$f":"Report!M27","v":0},"-","Écartement des varangues - Fond / Bouchain"]
[5,"Automoteur ordinaire",null,null,null,null,{"$f":"Report!M28","v":0},"-","Écartement des varangues - Coque"]
[6,"Péniche de canal",null,null,"Article 3.02\n3.02Solidité et stabilité"]
[7,"Remorqueur"]
[8,"Pousseur"]
[9,"Chaland-citerne"]
[10,"Chaland ordinaire",null,null,"1.","La coque doit avoir une solidité suffisante pour répondre à toutes les sollicitations auxquelles\nelle est normalement soumise."]
[11,"Barge-citerne",null,null,null,"(b)","1.          tmin = f ⋅ b ⋅ c ⋅ (2,3 + 0,04 ⋅ L)",null,null,", [mm]","pour L > 40,0 m"]
[12,"Barge ordinaire",null,null,null,null,"             tmin = f ⋅ b ⋅ c ⋅ (1,5 + 0,06 ⋅ L) ≥ 3",null,null,", [mm]","pour L ≤ 40,0 m"]
[13,"Barge de navire",null,null,null,null,"ou"]
[14,"Bateau à passagers à voiles",19,null,null,null,"2.          tmin = 0,005 ⋅ a ⋅ T 0,5",null,null,", [mm]"]
[15,"Bateau d’excursions journalières",19]
[16,"Bateau à cabines",19,null,null,"f=",{"$f":"IF(G1=0,\"\",IF(G5<=500,1,(1+(0.0013*(G5-500)))))","v":""},"-","Facteur pour l'écartement des varangues - Fond / Bouchain"]
[17,"Bateau rapide",null,null,null,null,{"$f":"IF(G1=0,\"\",IF(G6<=500,1,(1+(0.0013*(G6-500)))))","v":""},null,"Facteur pour l'écartement des varangues - Bordé latéral"]
[18,"Engin flottant",null,null,null,"bBS=",{"$f":"IF(G1=0,\"\",1)","v":""},"-","Facteur pour les tôles de fond et de bordé latéral"]
[19,"Bâtiment de chantier",null,null,null,"bBOUCHAIN=",{"$f":"IF(G1=0,\"\",1.25)","v":""},"-","Facteur pour les tôles de bouchain"]
[20,"Bâtiment traditionnel",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":"\"facteur pour le type de construction \"&IF(Report!S24=TRUE,IF(Report!S25=TRUE,IF(Report!S26=TRUE,\"(double fond et double muraille, dont la paroi\ndélimitant la cale est à la verticale sous l'hiloire)\",\"(double fond et double muraille)\"),IF(Report!S26=TRUE,\"(double fond)\",\"(double fond)\")),IF(Report!S25=TRUE,IF(Report!S26=TRUE,\"(dont la paroi délimitant la cale est à la verticale sous l'hiloire)\",\"(double muraille)\"),IF(Report!S26=TRUE,\"\",\"\")))&\"\"","v":"facteur pour le type de construction "}]
[21,"Traditional craft"]
[]
["Le bâtiment est",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":""},"-","Tôles de fond"]
[1,"(choisir)",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":""},"-","Tôles de bordé latéral"]
[2,"Soudées","Soudées",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":""},"-","Tôles de bouchain (l'épaisseur doit être supérieure à celle des tôles de fond et de bordé latéral"]
[3,"Rivées","Rivées"]
[4,"Partiellement soudées, rivées","Partiellement soudées, rivées"]
[null,null,null,null,"Article 19.02\nCoque"]
["Hélice"]
[1,"(choisir)",null,1]
[2,"Hélice","Hélice"]
[3,"Hélice de gouverne","Hélice de gouverne",null,"1.","L'épaisseur des bordés extérieurs des bateaux à passagers en acier est à déterminer de la manière suivante lors des visites périodiques:"]
[4,"Système de propulsion par jet d'eau","Système de propulsion par jet d'eau"]
[5,"Hélice à propulseurs cycloïdaux","Hélice à propulseurs cycloïdaux",null,null,"(a)","tmin =  0,006 ⋅ a ⋅ T 0,5 ≥ 3",null,", [mm]"]
[6,"Néant","Néant",null,null,null,"tmin = f ⋅ 0,55 ⋅ LF0,5  ≥ 3",null,", [mm]"]
[]
["État de l'hélice",null,null,null,null,"f=",{"$f":"IF(G1=0,\"\",IF(G5<400,(1+0.0013*(400-500)),(1+0.0013*(G5-500))))","v":""},"-","Facteur pour l'écartement des varangues - Fond / Bouchain"]
[1,"(choisir)",null,1,null,null,{"$f":"IF(G1=0,\"\",IF(G6<400,(1+0.0013*(400-500)),(1+0.0013*(G6-500))))","v":""},"-","Facteur pour l'écartement des varangues - Bordé latéral"]
[2,"Bon état","Bon état"]
[3,"Réparation requise","Réparation requise",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":""},"Fond / Bouchain"]
[4,"Néant","Néant",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":""},"Côté"]
[]
["État de l'installation de gouverne",null,null,null,"FINAL"]
[1,"(choisir)",null,1]
[2,"Bon état","Bon état"]
[3,"Réparation requise","Réparation requise",null,null,"Type de bateau:",null,{"$f":"LOOKUP(Calculation!D2,Calculation!A2:A22,Calculation!B2:B22)","v":"(choisir)"},null,{"$f":"LOOKUP(Calculation!D2,Calculation!A2:A22,Calculation!C2:C22)","v":0}]
[4,"Néant","Néant"]
[null,null,null,null,null,"tmin=",{"$f":"IF(J47=19,G41,G24)","v":""},"-","Tôles de fond"]
["Débattement du gouvernail",null,null,null,null,"tmin=",{"$f":"IF(J47=19,G42,G25)","v":""},"-","Tôles de bordé latéral"]
[1,"(choisir)",null,1,null,"tmin=",{"$f":"IF(J47=19,G41,G26)","v":""},"-","Tôles de bouchain (l'épaisseur doit être supérieure à celle des tôles de fond et de bordé latéral"]
[2,"Acceptable","Acceptable"]
[3,"Non acceptable","Non acceptable"]
[4,"Néant","Néant"]
[]
["État de l'arbre d'hélice et écartements"]
[1,"(choisir)",null,1]
[2,"Bon état","Bon état"]
[3,"Réparation requise","Réparation requise"]
[4,"Néant","Néant"]
[]
["Écartement de l'arbre d'hélice"]
[1,"(choisir)",null,1]
[2,"Acceptable","Acceptable"]
[3,"Non acceptable","Non acceptable"]
[4,"Néant","Néant"]
[]
["État des cloisons, des planchers, des cadres latéraux, des supports"]
[1,"(choisir)",null,1]
[2,"Bon état","Bon état"]
[3,"Réparation requise","Réparation requise"]
[]
["État du fond"]
[1,"(choisir)",null,1]
[2,"Bon état","Bon état"]
[3,"Réparation requise","Réparation requise"]
[]
["Visite supplémentaire"]
[1,"(choisir)",null,1]
[2,"Oui"]
[3,"Non"]
[]
["État de la vanne de coffre de mer"]
[1,"(choisir)",null,1]
[2,"Bon état","Bon état"]
[3,"Réparation requise","Réparation requise"]
[4,"Néant","Néant"]
[]
["État du gréement d'ancrage et d'amarrage"]
[1,"(choisir)",null,1]
[2,"Bon état","Bon état"]
[3,"Réparation requise","Réparation requise"]
[4,"Néant","Néant"]

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