{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["LIMAN HIZMET - NAVLUN FORMU"],"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":"LIMAN HIZMET - NAVLUN FORMU","index":0,"n_rows":71,"n_cols":19,"rows_kept":71,"cut":false,"hidden":false,"merged":[[0,0,0,20],[18,11,19,20],[49,17,50,20],[50,1,50,11],[51,1,51,11],[52,1,52,11],[27,17,27,20],[28,17,28,20],[41,1,41,11],[42,1,42,11],[43,1,43,11],[44,1,44,11],[45,1,45,11],[27,2,27,11],[28,2,28,11],[29,1,29,11],[30,1,30,11],[31,1,31,11],[37,17,38,20],[45,17,46,20],[35,17,36,20],[39,17,40,20],[41,17,42,20],[29,17,30,20],[63,12,63,13],[63,10,63,11],[43,12,44,20],[24,1,24,3],[20,12,20,16],[21,12,21,16],[54,15,55,20],[58,10,58,13],[58,15,67,20],[46,1,46,11],[64,12,64,13],[65,12,65,13],[66,12,66,13],[67,12,67,13],[64,10,64,11],[65,10,65,11],[66,10,66,11],[67,10,67,11],[59,10,59,13],[60,10,60,13],[33,12,34,16],[33,1,34,11],[33,17,34,20],[56,4,56,6],[70,0,70,20],[54,1,54,6],[54,8,54,13],[27,12,27,16],[28,12,28,16],[29,12,30,16],[31,12,32,16],[35,12,36,16],[39,12,40,16],[41,12,42,16],[45,12,46,16],[49,12,50,16],[39,1,39,11],[40,1,40,11],[51,12,52,20],[47,12,48,20],[69,0,69,20],[56,10,56,13],[55,8,55,9],[55,1,55,3],[56,15,57,20],[57,3,58,3],[55,10,55,13],[68,0,68,20],[57,10,57,13],[27,0,28,1],[45,0,46,0],[47,0,48,0],[24,0,25,0],[37,0,38,0],[33,0,34,0],[47,1,47,11],[48,1,48,11],[38,1,38,11],[37,1,37,11],[35,1,35,11],[36,1,36,11],[32,1,32,11],[56,1,56,3],[31,17,32,20],[2,3,2,17],[3,3,3,17],[11,4,12,20],[18,4,19,10],[20,4,21,10],[22,4,23,10],[16,4,17,20],[16,1,16,3],[17,1,17,3],[18,1,18,3],[19,1,19,3],[20,1,20,3],[21,1,21,3],[22,1,22,3],[23,1,23,3],[7,4,8,20],[22,17,23,20],[20,11,21,11],[20,17,21,20],[8,1,8,3],[9,4,10,20],[1,0,3,2],[1,18,3,20],[10,1,10,3],[9,1,9,3],[5,0,6,1],[16,0,17,0],[18,0,19,0],[26,0,26,11],[14,0,15,1],[7,0,8,0],[9,0,10,0],[22,11,23,11],[11,0,12,0],[5,2,5,20],[6,2,6,20],[7,1,7,3],[12,1,12,3],[11,1,11,3],[14,2,14,20],[15,2,15,20],[22,12,22,16],[23,12,23,16],[25,12,25,16],[24,17,25,20],[13,0,13,20],[1,3,1,17],[29,0,30,0],[31,0,32,0],[61,12,62,13],[61,8,62,9],[61,10,62,11],[49,1,49,11],[20,0,21,0],[22,0,23,0],[41,0,42,0],[43,0,44,0],[35,0,36,0],[39,0,40,0],[57,4,58,5],[57,6,58,6],[55,4,55,6],[57,1,58,2],[24,4,25,10],[24,11,25,11],[49,0,50,0],[51,0,52,0],[37,12,38,16],[25,1,25,3],[24,12,24,16]]}
[]
["2021\nYILI",null,null,"(TÜRK LİMANLARINDA ELLEÇLEME YAPAN YABANCI BAYRAKLI-YABANCILARA KİRAYA VERİLMİŞ TÜRK BAYRAKLI GEMİLER İÇİN)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021\nYILI"]
[null,null,null," NAVLUN ODA PAYI BİLDİRİM FORMU"]
[null,null,null,"(FOR FOREIGN FLAG VESSELS OR TURKISH FLAG VESSELS CHARTERED BY FOREIGNERS, HANDLING IN TURKISH PORTS)\nCHAMBER'S FREIGHT SHARE DECLARATION FORM"]
[]
["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,"Yabancı Bayrak",null,null,null,null,null,null,4,"  BAYRAĞI"]
[null," Turkish - Foreign Flag",null,null,null,null,null,null,null,null,null,null,"  Flag"]
[5," GROS TONU",null,null,null,null,null,null,null,null,null,6," HAREKET LİMANI"]
[null," GT",null,null,null,null,null,null,null,null,null,null," Port of Departure "]
[7," HAREKET TARİHİ",null,null,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,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,null,"BOŞALTMA "]
[null,null,"LOADING & UNLOADING INFORMATION",null,null,null,null,null,null,null,null,null,"LOADING",null,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,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(M34=\"Tavan Ücret\",0,IF(M38=0,0,M36*M38))","v":0},null,null,null,null,{"$f":"IF(R34=\"Tavan Ücret\",0,IF(R38=0,0,R36*R38))","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$34&$R$34=\"Tavan ÜcretTavan Ücret\",VLOOKUP(MAX($M$36:$R$36),$I$64:$M$68,5)/2,IF($R$34&$M$34=\"_Tavan Ücret\",VLOOKUP($M$36,$I$57:$K$61,3),IF($R$34&$M$34=\"Tavan Ücret\",VLOOKUP($M$36,$I$57:$K$61,3),IF(($M$40*0.005)>VLOOKUP($M$36,$I$57:$K$61,3),VLOOKUP($M$36,$I$57:$K$61,3),$M$40*0.005)))))*SIGN($E$23)","v":0},null,null,null,null,{"$f":"(IF($M$34&$R$34=\"Tavan ÜcretTavan Ücret\",VLOOKUP(MAX($M$36:$R$36),$I$64:$M$68,5)/2,IF($M$34&$R$34=\"_Tavan Ücret\",VLOOKUP($R$36,$I$57:$K$61,3),IF($M$34&$R$34=\"Tavan Ücret\",VLOOKUP($R$36,$I$57:$K$61,3),IF(($R$40*0.005)>VLOOKUP($R$36,$I$57:$K$61,3),VLOOKUP($R$36,$I$57:$K$61,3),$R$40*0.005)))))*SIGN($E$23)","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$44=\"döviz kurunu yazınız\",0,IF($M$44=\"\",0,IF($M$44=0,0,ROUND(M42*M44,2))))","v":0},null,null,null,null,{"$f":"IF($M$44=\"döviz kurunu yazınız\",0,IF($M$44=\"\",0,IF($M$44=0,0,ROUND(R42*M44,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":"M46+R46","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,null,{"$f":"(IF($M$50=\"Yok\",0,IF($M$50=\"\",0,IF($E$21=\"Türk Bayrağı\",VLOOKUP($E$23,$B$60:$D$68,3),IF($E$21=\"Yabancı Bayrak\",VLOOKUP($E$23,$E$60:$G$68,3))))))*SIGN($E$23)","v":0}]
[null," Port Service Fee"]
[12," GENEL TOPLAM (TL)",null,null,null,null,null,null,null,null,null,null,{"$f":"M48+R50","v":0}]
[null," Grand Total (TL)"]
[]
[null,"2021 YILI\n LİMAN HİZMET ÜCRETİ / PORT SERVICE FEE",null,null,null,null,null,null,"2021 YILI\nNAVLUN ODA PAYI / CHAMBER'S FREIGHT SHARE",null,null,null,null,null,null,"ACENTENİN KAŞESİ  / AGENT  STAMP"]
[null,"TÜRK \nBAYRAKLI GEMİ         ",null,null,"YABANCI \nBAYRAKLI GEMİ",null,null,null,"TAŞINAN  YÜKÜN \nTON (MT)  ARALIĞI                          TON (MT) RANGE OF \nSHIPPED CARGO",null,"ÖDENECEK TAVAN  \nÜCRET  TUTAR\nCEILING FEE TO BE PAID"]
[null,"TURKISH FLAG SHIP",null,null,"FOREIGN FLAG SHIP",null,null,null,0,20000,550,null,null,null,null,"TARİH ve İMZA / DATE - SIGNATURE"]
[null,"GEMİ GROS TONU\nSHIP'S GROSS TONAGE",null,"TUTAR\nAMOUNT","GEMİ GROS TONU\nSHIP'S GROSS TONAGE",null,"TUTAR\nAMOUNT",null,20001,40000,800]
[null,null,null,null,null,null,null,null,40001,60000,1050]
[null,0,500,125,0,500,250,null,60001,100000,1300]
[null,501,1500,210,501,1000,430,null,100001,"VE YUKARISI",1650]
[null,1501,2500,370,1001,1500,540,null,"TAŞINAN  YÜKÜN \nTON (MT)  ARALIĞI                          TON (MT) RANGE OF \nSHIPPED CARGO",null,"TAVAN  ÜCRET \n TUTAR                      CEILING FEE",null,"İNDİRİMLİ  ÖDENECEK\nTAVAN  ÜCRET\nREDUCED CEILING FEE TO BE PAID"]
[null,2501,5000,530,1501,2000,650]
[null,5001,10000,630,2001,2500,760,null,0,20000,"( 550 + 550 )",null,825]
[null,10001,25000,750,2501,5000,860,null,20001,40000," ( 800 + 800 )",null,1200]
[null,25001,35000,850,5001,10000,900,null,40001,60000,"( 1.050 + 1.050 )",null,1575]
[null,35001,50000,950,10001,25000,975,null,60001,100000,"( 1.300 + 1.300 )",null,1950]
[null,50001,"VE YUKARISI",1000,25001,"VE YUKARISI",1100,null,100001," VE YUKARISI","( 1.650 + 1.650 )",null,2475]
[]
["* 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."]