{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":[" NAVLUN ODA PAYI BİLDİRİMİ"],"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":" NAVLUN ODA PAYI BİLDİRİMİ","index":0,"n_rows":75,"n_cols":19,"rows_kept":75,"cut":false,"hidden":false,"merged":[[59,15,71,18],[57,7,71,7],[58,4,58,6],[64,9,64,10],[67,9,67,10],[68,9,68,10],[69,9,69,10],[70,9,70,10],[71,9,71,10],[66,8,66,10],[65,8,65,10],[62,9,62,10],[63,9,63,10],[65,12,65,13],[66,12,66,13],[57,15,58,18],[62,11,62,13],[57,14,71,14],[59,8,59,10],[59,11,59,13],[57,0,57,6],[60,4,60,5],[60,9,60,10],[61,9,61,10],[49,1,49,11],[23,4,24,8],[25,4,26,8],[23,0,24,0],[25,0,26,0],[38,0,39,0],[42,0,43,0],[52,0,53,0],[54,0,55,0],[28,1,28,3],[27,4,28,8],[23,9,24,9],[25,9,26,9],[27,9,28,9],[23,10,23,12],[24,10,24,12],[25,10,25,12],[55,1,55,11],[32,1,32,11],[33,1,33,11],[34,1,34,11],[27,0,28,0],[64,0,64,1],[65,0,65,1],[66,0,66,1],[67,0,67,1],[68,0,68,1],[69,0,69,1],[70,0,70,1],[61,4,62,5],[61,6,62,6],[61,3,62,3],[58,0,58,3],[59,0,59,3],[71,0,71,1],[61,0,62,2],[60,0,60,2],[63,0,63,1],[56,0,56,18],[5,18,6,18],[6,2,6,17],[5,2,5,17],[7,0,7,18],[21,4,22,8],[21,9,22,18],[16,0,16,18],[36,12,37,15],[36,1,37,11],[36,16,37,18],[40,12,41,15],[11,1,11,3],[12,4,13,18],[13,1,13,3],[18,2,18,18],[27,1,27,3],[34,0,35,0],[52,16,53,18],[53,1,53,11],[54,1,54,11],[27,10,27,12],[28,10,28,12],[23,13,24,18],[25,13,26,18],[27,13,28,18],[29,0,29,18],[32,0,33,0],[23,1,23,3],[24,1,24,3],[25,1,25,3],[26,1,26,3],[26,10,26,12],[30,16,30,18],[31,16,31,18],[44,1,44,11],[45,1,45,11],[46,1,46,11],[47,1,47,11],[48,1,48,11],[30,2,30,11],[31,2,31,11],[40,16,41,18],[48,16,49,18],[38,16,39,18],[42,16,43,18],[44,16,45,18],[46,12,47,18],[74,0,74,18],[57,8,57,13],[30,12,30,15],[31,12,31,15],[32,12,33,15],[34,12,35,15],[38,12,39,15],[42,12,43,15],[44,12,45,15],[48,12,49,15],[52,12,53,15],[42,1,42,11],[43,1,43,11],[54,12,55,18],[50,12,51,18],[73,0,73,18],[60,11,60,13],[58,8,58,10],[58,11,58,13],[32,16,33,18],[52,1,52,11],[44,0,45,0],[46,0,47,0],[72,0,72,18],[61,11,61,13],[30,0,31,1],[48,0,49,0],[50,0,51,0],[40,0,41,0],[36,0,37,0],[50,1,50,11],[51,1,51,11],[41,1,41,11],[40,1,40,11],[38,1,38,11],[39,1,39,11],[35,1,35,11],[34,16,35,18],[59,4,59,6],[67,12,67,13],[68,12,68,13],[69,12,69,13],[70,12,70,13],[71,12,71,13],[63,11,63,13],[64,11,64,13],[12,1,12,3],[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],[8,2,8,18],[9,2,9,18],[10,1,10,3],[15,1,15,3],[14,1,14,3],[17,2,17,18],[19,1,19,3],[21,1,21,3],[22,1,22,3],[10,4,11,18],[20,1,20,3],[14,4,15,18],[19,4,20,18],[0,16,0,17],[1,16,1,17],[2,16,2,17],[3,16,3,17],[0,2,1,15],[2,2,3,15],[0,0,3,1],[5,0,6,1],[4,0,4,18]]}
[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.F03"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Yayın Tarihi",null,"2009-06-05"]
[null,null," NAVLUN HASILATI ODA PAYI BİLDİRİM FORMU",null,null,null,null,null,null,null,null,null,null,null,null,null,"Revizyon Tarihi",null,"2021-12-20"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Revizyon No.",null,"01"]
[]
["2024\nYILI",null,"TÜRK LİMANLARINDA ELLEÇLEME YAPAN YABANCI BAYRAKLI & YABANCILARA KİRAYA VERİLMİŞ TÜRK BAYRAKLI GEMİLER İÇİN \nNAVLUN 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,"CHAMBER'S FREIGHT REVENUE SHARE DECLARATION FORM FOR FOREIGN FLAG VESSELS OR TURKISH FLAG 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 Registration 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"]
[null," Type of vessel"]
[3," TÜRK - YABANCI BAYRAK",null,null,"Bayrağı Seçin",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,null,"YÜKLEME ",null,null,null,"BOŞALTMA"]
[null,null,"LOADING & UNLOADING INFORMATION",null,null,null,null,null,null,null,null,null,"LOADING",null,null,null,"UNLOADING"]
[1," YÜKÜN CİNSİ"]
[null," Type of cargo"]
[2," YÜKÜN GELDİĞİ VEYA GİDECEĞİ LİMAN / ÜLKE"]
[null," Port  / Country of origin /destination of cargo"]
[3,"Listeden Tavan Ücret seçildiğinde Taşınan Yükün Tonu yazılmalıdır.\nTonnage of shipped cargo should be written when ceiling fee is chosen from the list.",null,null,null,null,null,null,null,null,null,null,"_",null,null,null,"_"]
[]
[4," YÜKÜN MİKTARI   ( TON & ADET )"]
[null," Quantity of cargo ( Piece)"]
[5," NAVLUN BİRİM FİYATI  ( $ / TON & ADET )"]
[null," Freight Unit Price ( $ / Ton & Piece)"]
[6," TOPLAM NAVLUN TUTARI  ( $ )",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M37=\"Tavan Ücret\",0,IF(M41=0,0,M39*M41))","v":0},null,null,null,{"$f":"IF(Q37=\"Tavan Ücret\",0,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,null,{"$f":"(IF($M$37&$Q$37=\"Tavan ÜcretTavan Ücret\",VLOOKUP(MAX($M$39:$Q$39),$I$68:$M$72,5)/2,IF($Q$37&$M$37=\"_Tavan Ücret\",VLOOKUP($M$39,$I$61:$L$65,4),IF($Q$37&$M$37=\"Tavan Ücret\",VLOOKUP($M$39,$I$61:$L$65,4),IF(($M$43*0.005)>VLOOKUP($M$39,$I$61:$L$65,4),VLOOKUP($M$39,$I$61:$L$65,4),$M$43*0.005)))))*SIGN($E$26)","v":0},null,null,null,{"$f":"(IF($M$37&$Q$37=\"Tavan ÜcretTavan Ücret\",VLOOKUP(MAX($M$39:$Q$39),$I$68:$M$72,5)/2,IF($M$37&$Q$37=\"_Tavan Ücret\",VLOOKUP($Q$39,$I$61:$L$65,4),IF($M$37&$Q$37=\"Tavan Ücret\",VLOOKUP($Q$39,$I$61:$L$65,4),IF(($Q$43*0.005)>VLOOKUP($Q$39,$I$61:$L$65,4),VLOOKUP($Q$39,$I$61:$L$65,4),$Q$43*0.005)))))*SIGN($E$26)","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,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,null,{"$f":"IF($M$47=\"Döviz kurunu yazınız\",0,IF($M$47=\"\",0,IF($M$47=0,0,ROUND(M45*M47,2))))","v":0},null,null,null,{"$f":"IF($M$47=\"Döviz kurunu yazınız\",0,IF($M$47=\"\",0,IF($M$47=0,0,ROUND(Q45*M47,2))))","v":0}]
[null," Chamber's freight share of 5 per thousand  (TL)"]
[10," TOPLAM NAVLUN ODA PAYI (TL)",null,null,null,null,null,null,null,null,null,null,{"$f":"M49+Q49","v":0}]
[null," Total Chamber's Freight Share (TL)"]
[11," LİMAN HİZMET ÜCRETİ (TL)",null,null,null,null,null,null,null,null,null,null,"Var",null,null,null,{"$f":"(IF($M$53=\"Yok\",0,IF($M$53=\"\",0,IF($E$24=\"Türk Bayrağı\",VLOOKUP($E$26,$A$64:$D$72,4),IF($E$24=\"Yabancı Bayrak\",VLOOKUP($E$26,$E$64:$G$72,3))))))*SIGN($E$26)","v":0}]
[null," Port Service Fee"]
[12," GENEL TOPLAM (TL)",null,null,null,null,null,null,null,null,null,null,{"$f":"M51+Q53","v":0}]
[null," Grand Total (TL)"]
[]
["2024 YILI                                                                                                                                                                  LİMAN HİZMET ÜCRETİ / PORT SERVICE FEE",null,null,null,null,null,null,null,"2024 YILI                                                                                           NAVLUN ODA PAYI / CHAMBER'S FREIGHT SHARE",null,null,null,null,null,null,"ACENTENİN KAŞESİ                                   AGENT  STAMP\nTARİH ve İMZA                                      DATE - SIGNATURE"]
["TÜRK BAYRAKLI GEMİ         ",null,null,null,"YABANCI BAYRAKLI GEMİ",null,null,null,"TAŞINAN  YÜKÜN \nTON (MT)  ARALIĞI                          ",null,null,"ÖDENECEK TAVAN  \nÜCRET  TUTAR"]
["TURKISH FLAG SHIP",null,null,null,"FOREIGN FLAG SHIP",null,null,null,"TON (MT) RANGE OF SHIPPED CARGO",null,null,"CEILING FEE TO BE PAID"]
["GEMİ GROS TONU",null,null,"TUTAR","GEMİ GROS TONU",null,"TUTAR",null,0,20000,null,580]
["SHIP'S GROSS TONAGE",null,null,"AMOUNT","SHIP'S GROSS TONAGE",null,"AMOUNT",null,20001,40000,null,870]
[null,null,null,null,null,null,null,null,40001,60000,null,1130]
[0,null,500,480,0,500,1000,null,60001,100000,null,1400]
[501,null,1500,800,501,1000,1700,null,100001,"VE YUKARISI",null,1780]
[1501,1501,2500,1450,1001,1500,2000,null,"TAŞINAN  YÜKÜN \nTON (MT)  ARALIĞI                          ",null,null,"TAVAN  ÜCRET \n TUTAR","İNDİRİMLİ  ÖDENECEK TAVAN ÜCRET"]
[2501,2501,5000,2000,1501,2000,2500,null,"TON (MT) RANGE OF \nSHIPPED CARGO",null,null,"CEILING FEE","REDUCED CEILING FEE TO BE PAID"]
[5001,5001,10000,2400,2001,2500,3000,null,0,20000,null,"(580+580)",870]
[10001,10001,25000,2850,2501,5000,3500,null,20001,40000,null,"(870+870)",1305]
[25001,25001,35000,3200,5001,10000,4000,null,40001,60000,null,"(1.130+1.130)",1695]
[35001,35001,50000,3600,10001,25000,4500,null,60001,100000,null,"(1.400+1.400)",2100]
[50001,50001,"VE YUKARISI",3800,25001,"VE YUKARISI",5000,null,100001," VE YUKARISI",null,"(1.780+1.780)",2670]
[]
["* Not : 5174 sayılı Kanunun 26. maddesi gereğince Navlun 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."]