{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["RO-RO NAVLUN ODA PAYI"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":1,"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":"RO-RO NAVLUN ODA PAYI","index":0,"n_rows":75,"n_cols":19,"rows_kept":75,"cut":false,"hidden":false,"merged":[[42,11,43,15],[42,16,43,19],[44,11,45,15],[44,16,45,19],[48,11,49,15],[48,16,49,19],[32,0,33,0],[32,1,32,10],[32,11,33,15],[32,16,33,19],[33,1,33,10],[38,11,39,15],[40,11,41,15],[38,16,39,19],[40,16,41,19],[40,0,41,0],[36,0,37,0],[39,1,39,10],[23,10,23,13],[24,10,24,13],[23,1,23,3],[24,1,24,3],[25,1,25,3],[26,1,26,3],[25,9,26,9],[27,9,28,9],[27,1,27,3],[30,11,30,15],[31,11,31,15],[28,10,28,13],[27,10,27,13],[27,14,28,19],[34,11,35,15],[36,11,37,15],[41,1,41,10],[40,1,40,10],[28,1,28,3],[72,0,72,1],[21,4,22,4],[21,5,22,8],[56,11,57,19],[59,8,60,10],[52,11,53,19],[54,16,55,19],[55,1,55,10],[52,1,52,10],[51,1,51,10],[60,0,60,6],[59,0,59,6],[58,0,58,19],[59,7,72,7],[67,0,67,1],[68,0,68,1],[69,0,69,1],[70,0,70,1],[71,0,71,1],[65,9,66,10],[67,9,68,10],[69,9,70,10],[34,1,34,10],[35,1,35,10],[53,1,53,10],[50,0,51,0],[71,9,72,10],[59,11,72,11],[62,12,72,19],[26,10,26,13],[46,11,47,19],[50,11,51,15],[50,16,51,19],[38,1,38,10],[29,0,29,19],[38,0,39,0],[54,11,55,15],[34,0,35,0],[27,0,28,0],[49,1,49,10],[44,1,44,10],[62,6,63,6],[56,0,57,0],[48,0,49,0],[52,0,53,0],[54,0,55,0],[61,8,61,10],[62,9,64,10],[17,2,17,19],[7,0,7,19],[16,0,16,19],[36,1,36,10],[37,1,37,10],[65,8,66,8],[62,8,64,8],[59,12,61,19],[61,0,61,3],[62,0,63,2],[64,0,64,1],[65,0,65,1],[66,0,66,1],[23,4,24,8],[25,4,26,8],[27,4,28,8],[21,9,22,19],[23,9,24,9],[23,0,24,0],[25,0,26,0],[44,0,45,0],[46,0,47,0],[56,1,56,10],[57,1,57,10],[5,0,6,1],[0,18,0,19],[1,18,1,19],[2,18,2,19],[3,18,3,19],[0,16,0,17],[1,16,1,17],[2,16,2,17],[3,16,3,17],[0,0,3,1],[0,2,1,15],[2,2,3,15],[5,18,6,19],[5,2,5,17],[6,2,6,17],[4,0,4,19],[8,0,9,1],[19,0,20,0],[21,0,22,0],[17,0,18,1],[10,0,11,0],[12,0,13,0],[14,0,15,0],[10,1,10,3],[15,1,15,3],[14,1,14,3],[22,1,22,3],[9,2,9,19],[19,4,20,19],[19,1,19,3],[20,1,20,3],[21,1,21,3],[12,4,13,19],[8,2,8,19],[14,4,15,19],[10,4,11,19],[18,2,18,19],[13,1,13,3],[12,1,12,3],[11,1,11,3],[23,14,24,19],[74,0,74,19],[42,1,42,10],[43,1,43,10],[73,0,73,19],[62,3,63,3],[61,4,61,6],[42,0,43,0],[62,4,63,5],[30,16,30,19],[31,16,31,19],[31,2,31,10],[36,16,37,19],[45,1,45,10],[46,1,46,10],[47,1,47,10],[48,1,48,10],[30,2,30,10],[34,16,35,19],[54,1,54,10],[50,1,50,10],[25,14,26,19],[25,10,25,13],[30,0,31,1]]}
[null,null,"İMEAK DENİZ TİCARET ODASI",null,null,null,null,null,null,null,null,null,null,null,null,null,"Doküman No.",null,"MIS05.F19"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Yayın Tarihi",null,"2024-01-09"]
[null,null," RO-RO GEMİLERİ HASILATI NAVLUN ODA PAYI BİLDİRİM FORMU",null,null,null,null,null,null,null,null,null,null,null,null,null,"Revizyon Tarihi",null,"-"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Revizyon No.",null,"00"]
[]
["2024\nYILI",null,"TÜRK LİMANLARINDA ELLEÇLEME YAPAN YABANCI BAYRAKLI & YANCILARA KİRAYA VERİLMİŞ TÜRK BAYRAKLI GEMİLER İÇİN  \n RO-RO GEMİLERİ NAVLUN HASILATI ODA PAYI BİLDİRİM FORMU ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2024\nYILI"]
[null,null,"RO-RO SHIPS CHAMBER’S FREIGHT REVENUE SHARE DECLARATION FORM FOR FOREIGN FLAGGED VESSELS OR TURKISH FLAGGED VESSELS CHARTERED BY FOREIGNERS, HANDLING IN TURKISH PORTS"]
[]
["A",null,"GEMİ ACENTE BİLGİLERİ"]
[null,null,"SHIP AGENCY INFORMATION"]
[1," YABANCI ŞİRKET ADI    "]
[null," Name of  foreign company               "]
[2," GEMİ ACENTESİ SİCİL NUMARASI"]
[null,"Ship's Agent Registratıon Number"]
[3," GEMİ ACENTE UNVANI"]
[null," Name of Agent"]
[]
["B",null,"GEMİ BİLGİLERİ"]
[null,null,"SHIP INFORMATION"]
[1," GEMİ ADI"]
[null," Name of vessel"]
[2," GEMİ CİNSİ",null,null,"Diğer"," RO-RO GEMİLERİ"]
[null," Type of vessel"]
[3,"  TÜRK - YABANCI BAYRAK",null,null,"Yabancı Bayrak",null,null,null,null,4,"  BAYRAĞI"]
[null," Turkish - Foreign Flag",null,null,null,null,null,null,null,null,"  Flag"]
[5," GROS TONU",null,null,null,null,null,null,null,6," HAREKET LİMANI"]
[null," GT",null,null,null,null,null,null,null,null," Port of Departure "]
[7," HAREKET TARİHİ",null,null,null,null,null,null,null,8," LİMAN ÇIKIŞ BELGE ( LÇB ) NO"]
[null," Date of Departure ",null,null,null,null,null,null,null,null," Certificate of seagoing number"]
[]
["C",null,"YÜKLEME / BOŞALTMA  BİLGİLERİ",null,null,null,null,null,null,null,null,"YÜKLEME ",null,null,null,null,"BOŞALTMA "]
[null,null," LOADING & UNLOADING INFORMATION",null,null,null,null,null,null,null,null,"LOADING",null,null,null,null,"UNLOADING"]
[1," YÜKÜN CİNSİ"]
[null," Type of cargo"]
[1," YÜKÜN GELDİĞİ VEYA GİDECEĞİ LİMAN / ÜLKE"]
[null," Port  / Country of origin /destination of cargo"]
[2,"Listeden Tavan Ücret seçildiğinde Taşınan Yükün Adedi yazılmalıdır.",null,null,null,null,null,null,null,null,null,"_",null,null,null,null,"_"]
[null,"Tonnage of shipped cargo should be written when ceiling fee is chosen from the list."]
[4," YÜKÜN MİKTARI   ( ADET )"]
[null," Quantity of cargo ( Piece)"]
[5," NAVLUN BİRİM FİYATI  ( $ / ADET )"]
[null," Freight Unit Price ( $ / Piece)"]
[6," TOPLAM NAVLUN TUTARI  ( $ )",null,null,null,null,null,null,null,null,null,{"$f":"IF(L41=0,0,L39*L41)","v":0},null,null,null,null,{"$f":"IF(Q41=0,0,Q39*Q41)","v":0}]
[null," Total amount of freight ( $ )"]
[7," TOPLAM NAVLUN TUTARININ ‰ 5 TUTARI ($)",null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(L37=\"_\",L43=0),0,IF(AND(L37=\"Tavan Ücret\",Q37<>\"Tavan Ücret\",L43=0),$J$68,IF(L37&Q37&SIGN($L$43)=\"Tavan ÜcretTavan Ücret1\",($J$72/2),IF(L37&Q37&SIGN($L$43+$L$43)=\"Tavan ÜcretTavan Ücret0\",$J$72/2,IF(L37&Q37=\"Tavan Ücret_\",$J$68,IF(L37&Q37=\"Tavan Ücret\",$J$68,IF(L43=0,0,IF(L43*0.005>=$J$68,$J$68,((L43*0.005))))))))))","v":0},null,null,null,null,{"$f":"IF(AND(Q37=\"_\",Q43=0),0,IF(AND(Q37=\"Tavan Ücret\",L37<>\"Tavan Ücret\",Q43=0),$J$70,IF(L37&Q37&SIGN($Q$43+$S$43)=\"Tavan ÜcretTavan Ücret1\",$J$72/2,IF(L37&Q37&SIGN($Q$43:$S$43)=\"Tavan ÜcretTavan Ücret0\",$J$72/2,IF(L37&Q37=\"_Tavan Ücret\",$J$70,IF(L37&Q37=\"Tavan Ücret\",$J$70,IF(Q43=0,0,IF(Q43*0.005>=$J$70,$J$70,((Q43*0.005))))))))))","v":0}]
[null," 5 per thousand of total amount of freight ($)"]
[8," DÖVİZ KURU  (Geminin kalkış tarihindeki MB Döviz Alış Kuru)",null,null,null,null,null,null,null,null,null,"Döviz kurunu yazınız"]
[null," Turkish Central Bank's Foreign currency buying rate of exchange at the date of ship’s departure"]
[9," BİNDE BEŞ NAVLUN ODA PAYI TUTARI (TL)",null,null,null,null,null,null,null,null,null,{"$f":"IF($L$47=\"döviz kurunu yazınız\",0,ROUND(L45*$L$47,2))","v":0},null,null,null,null,{"$f":"IF($L$47=\"döviz kurunu yazınız\",0,ROUND(Q45*$L$47,2))","v":0}]
[null," Chamber's freight share of 5 per thousand  (TL)"]
[10," YÜKLEME / BOŞALTMA NAVLUN ODA PAYI TOPLAMI (TL)",null,null,null,null,null,null,null,null,null,{"$f":"SUM(L49:P50)","v":0},null,null,null,null,{"$f":"SUM(Q49:S50)","v":0}]
[null," Total Chamber's freight share of loading & unloading (TL)"]
[11,"TOPLAM NAVLUN ODA PAYI (TL)",null,null,null,null,null,null,null,null,null,{"$f":"SUM(L51:Q51)","v":0}]
[null," Total Chamber's Freight Share (TL)"]
[12," LİMAN HİZMET ÜCRETİ (TL)",null,null,null,null,null,null,null,null,null,"Var",null,null,null,null,{"$f":"(IF($L$55=\"Yok\",0,IF($L$55=\"\",0,IF($E$24=\"Türk Bayrağı\",VLOOKUP($E$26,$A$65:$D$73,4),IF($E$24=\"Yabancı Bayrak\",VLOOKUP($E$26,$E$65:$G$73,3))))))*SIGN($E$26)","v":0}]
[null," Port Service Fee"]
[13," GENEL TOPLAM (TL)",null,null,null,null,null,null,null,null,null,{"$f":"L53+Q55","v":0}]
[null," Grand Total (TL)"]
[]
[" 2024 YILI LİMAN HİZMET ÜCRETİ",null,null,null,null,null,null,null,"2024 YILI\nRO-RO NAVLUN HASILATI ODA PAYI",null,null,null,"ACENTENİN KAŞESİ  / AGENT  STAMP\n\nTARİH ve İMZA / DATE - SIGNATURE"]
["PORT SERVICE FEE"]
["TÜRK \nBAYRAKLI GEMİ /\nTURKISH FLAG SHIP     ",null,null,null,"YABANCI \nBAYRAKLI GEMİ /\nFOREIGN FLAG SHIP",null,null,null,"RO-RO FREIGHT REVENUE SHARE"]
["GEMİ GROS TONU\nSHIP'S GROSS TONAGE",null,null,"TUTAR\nAMOUNT","GEMİ GROS TONU\nSHIP'S GROSS TONAGE",null,"TUTAR\nAMOUNT",null,"YÜK BİLGİLERİ","TAVAN  ÜCRET \n TUTAR"]
[]
[0,null,500,480,0,500,1000]
[501,501,1500,800,501,1000,1700,null,"LOAD INFORMATION","CEILING FEE"]
[1501,1501,2500,1450,1001,1500,2000]
[2501,2501,5000,2000,1501,2000,2500,null,"YÜKLEME",600]
[5001,5001,10000,2400,2001,2500,3000,null,"LOADING "]
[10001,10001,25000,2850,2501,5000,3500,null,"BOŞALTMA",600]
[25001,25001,35000,3200,5001,10000,4000,null," UNLOADING"]
[35001,35001,50000,3600,10001,25000,4500,null,"YÜKLEME + BOŞALTMA",900]
[50001,50001,"VE YUKARISI",3800,25001,"VE YUKARISI",5000,null,"LOADING + UNLOADING"]
["* Not : 5174 sayılı Kanunun 26. maddesi gereğince Navlun Hasılatı Oda Payı gemi hareket tarihini takip eden  15 gün içinde ödenmediği takdirde, 6183 sayılı Amme Alacakları Tahsili Usulü Hakkında Kanun uyarınca yürürlükte bulunan oranda günlük Gecikme Zammı uygulanacaktır."]
["* Note : According to article 26 of Law  No:5174, daily delay interest in force in accordance with the Law No: 6183 \"Law On the  Procedure for the Collection of Public Receivables\" will be applied, if the Chamber's share of freight is not paid within 15 days after the ship's departure date."]