{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["KONTEYNER 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":"KONTEYNER NAVLUN ODA PAYI","index":0,"n_rows":72,"n_cols":18,"rows_kept":72,"cut":false,"hidden":false,"merged":[[47,0,48,0],[56,11,57,18],[41,0,42,0],[43,0,44,0],[53,1,53,10],[54,1,54,10],[50,1,50,10],[46,1,46,10],[51,15,52,18],[52,1,52,10],[49,1,49,10],[48,1,48,10],[41,11,42,12],[41,13,42,14],[41,15,42,16],[41,17,42,18],[45,11,46,12],[45,13,46,14],[45,15,46,16],[45,17,46,18],[47,11,48,14],[47,15,48,18],[56,1,57,6],[5,0,6,1],[16,0,17,0],[18,0,19,0],[14,0,15,1],[7,0,8,0],[9,0,10,0],[11,0,12,0],[7,1,7,3],[12,1,12,3],[11,1,11,3],[19,1,19,3],[6,2,6,18],[16,4,17,18],[16,1,16,3],[17,1,17,3],[18,1,18,3],[9,4,10,18],[5,2,5,18],[29,0,30,0],[33,11,33,12],[20,0,21,0],[22,0,23,0],[26,0,26,10],[27,0,28,1],[22,10,23,10],[53,0,54,0],[45,0,46,0],[49,0,50,0],[51,0,52,0],[33,1,33,10],[34,1,34,10],[35,1,35,10],[36,1,36,10],[51,1,51,10],[34,11,34,12],[47,1,47,10],[41,1,41,10],[37,0,38,0],[31,0,32,0],[33,0,34,0],[35,0,36,0],[24,0,25,0],[59,6,60,6],[59,1,60,2],[59,8,63,8],[59,9,63,9],[38,1,38,10],[58,11,59,18],[60,11,69,18],[25,1,25,3],[24,11,24,14],[25,11,25,14],[37,1,37,10],[34,13,34,14],[33,13,33,14],[35,13,36,14],[35,15,36,16],[35,17,36,18],[33,15,33,16],[33,17,33,18],[34,15,34,16],[34,17,34,18],[35,11,36,12],[37,11,38,12],[37,13,38,14],[37,15,38,16],[22,11,22,14],[23,11,23,14],[20,10,21,10],[20,1,20,3],[21,1,21,3],[22,15,23,18],[27,2,27,10],[29,15,30,18],[24,10,25,10],[24,4,25,9],[29,1,29,10],[30,1,30,10],[20,15,21,18],[22,1,22,3],[23,1,23,3],[20,11,20,14],[21,11,21,14],[71,0,71,18],[27,11,27,14],[28,11,28,14],[29,11,30,14],[51,11,52,14],[39,1,39,10],[40,1,40,10],[53,11,54,18],[49,11,50,18],[70,0,70,18],[58,1,58,3],[59,3,60,3],[58,4,58,6],[68,8,69,8],[68,9,69,9],[66,8,67,8],[66,9,67,9],[64,8,65,8],[64,9,65,9],[56,8,58,9],[39,0,40,0],[59,4,60,5],[27,15,27,18],[28,15,28,18],[37,17,38,18],[28,2,28,10],[24,15,25,18],[31,11,32,14],[31,1,32,10],[31,15,32,18],[24,1,24,3],[0,0,0,18],[18,10,19,18],[1,3,1,15],[2,3,2,15],[3,3,3,15],[11,4,12,18],[18,4,19,9],[20,4,21,9],[22,4,23,9],[7,4,8,18],[14,2,14,18],[15,2,15,18],[1,0,3,2],[1,16,3,18],[10,1,10,3],[9,1,9,3],[8,1,8,3],[39,11,40,12],[39,13,40,14],[39,15,40,16],[39,17,40,18],[42,1,42,10],[43,11,44,18],[43,1,43,10],[44,1,44,10],[45,1,45,10]]}
[]
["2019\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,"2019\nYILI"]
[null,null,null,"KONTEYNER 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)\nCONTAINERCHAMBER'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 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",null,null,null,null,null,"KONTEYNER"]
[null," Type of vessel"]
[3,"  TÜRK - YABANCI BAYRAK",null,null,"Yabancı Bayrak",null,null,null,null,null,4,"  BAYRAĞI"]
[null," Turkish - Foreign Flag",null,null,null,null,null,null,null,null,null,"  Flag"]
[5," GROS TONU",null,null,null,null,null,null,null,null,6," HAREKET LİMANI"]
[null," GT",null,null,null,null,null,null,null,null,null," Port of Departure "]
[7," HAREKET TARİHİ",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," Certificate of seagoing number"]
[]
["C",null," KONTEYNER YÜKLEME / BOŞALTMA  BİLGİLERİ",null,null,null,null,null,null,null,null,"YÜKLEME ",null,null,null,"BOŞALTMA "]
[null,null,"CONTAINER LOADING & UNLOADING INFORMATION",null,null,null,null,null,null,null,null,"LOADING",null,null,null,"UNLOADING"]
[1," KONTEYNERİN GELDİĞİ VEYA GİDECEĞİ LİMAN / ÜLKE"]
[null," Port  / Country of origin /destination of container"]
[2,"Listeden Tavan Ücret Seçildiğinde Taşınan Konteyner Yükünün Adedi Yazılmalıdır                            Number of Shipped Containers should be written when ceiling fee is chosen from the list        ",null,null,null,null,null,null,null,null,null,"_",null,null,null,"_"]
[]
[3," KONTEYNER CİNSİ",null,null,null,null,null,null,null,null,null,"ADET / Piece",null,"ADET / Piece",null,"ADET / Piece",null,"ADET / Piece"]
[null," Type of container",null,null,null,null,null,null,null,null,null,"20' Kont./Cont.",null,"40' Kont./Cont.",null,"20' Kont./Cont.",null,"40' Kont./Cont."]
[4," YÜKÜN MİKTARI   ( TON & 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(L38=0,0,L36*L38)","v":0},null,{"$f":"IF(N38=0,0,N36*N38)","v":0},null,{"$f":"IF(P38=0,0,P36*P38)","v":0},null,{"$f":"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,{"$f":"IF(AND(L32=\"_\",L40=0),0,IF(AND(L32=\"Tavan Ücret\",P32<>\"Tavan Ücret\",L40=0),$J$65/2,IF(L32&P32&SIGN($L$40+$N$40)=\"Tavan ÜcretTavan Ücret1\",($J$69/2)*(L40/(L40+N40)),IF(L32&P32&SIGN($L$40+$N$40)=\"Tavan ÜcretTavan Ücret0\",$J$69/4,IF(L32&P32=\"Tavan Ücret_\",$J$65*(L40/(L40+N40)),IF(L32&P32=\"Tavan Ücret\",$J$65*(L40/(L40+N40)),IF(L40=0,0,IF((L40+N40)*0.005>=$J$65,$J$65*(L40/(L40+N40)),((L40*0.005))))))))))","v":0},null,{"$f":"IF(AND(L32=\"_\",N40=0),0,IF(AND(L32=\"Tavan Ücret\",P32<>\"Tavan Ücret\",N40=0),$J$65/2,IF(L32&P32&SIGN(SUM($L$40+$N$40))=\"Tavan ÜcretTavan Ücret1\",($J$69/2)*(N40/(L40+N40)),IF(L32&P32&SIGN(SUM($L$40+$N$40))=\"Tavan ÜcretTavan Ücret0\",$J$69/4,IF(L32&P32=\"Tavan Ücret_\",$J$65*(N40/(L40+N40)),IF(L32&P32=\"Tavan Ücret\",$J$65*(N40/(L40+N40)),IF(N40=0,0,IF((L40+N40)*0.005>=$J$65,$J$65*(N40/(L40+N40)),((N40*0.005))))))))))","v":0},null,{"$f":"IF(AND(P32=\"_\",P40=0),0,IF(AND(P32=\"Tavan Ücret\",L32<>\"Tavan Ücret\",P40=0),$J$67/2,IF(L32&P32&SIGN($P$40+$R$40)=\"Tavan ÜcretTavan Ücret1\",($J$69/2)*(P40/(P40+R40)),IF(L32&P32&SIGN($P$40:$R$40)=\"Tavan ÜcretTavan Ücret0\",$J$69/4,IF(L32&P32=\"_Tavan Ücret\",$J$67*(P40/(P40+R40)),IF(L32&P32=\"Tavan Ücret\",$J$67*(P40/(P40+R40)),IF(P40=0,0,IF((P40+R40)*0.005>=$J$67,$J$67*(P40/(P40+R40)),((P40*0.005))))))))))","v":0},null,{"$f":"IF(AND(P32=\"_\",R40=0),0,IF(AND(P32=\"Tavan Ücret\",L32<>\"Tavan Ücret\",R40=0),$J$67/2,IF(L32&P32&SIGN($P$40+$R$40)=\"Tavan ÜcretTavan Ücret1\",($J$69/2)*(R40/(P40+R40)),IF(L32&P32&SIGN($P$40:$R$40)=\"Tavan ÜcretTavan Ücret0\",$J$69/4,IF(L32&P32=\"_Tavan Ücret\",$J$67*(R40/(P40+R40)),IF(L32&P32=\"Tavan Ücret\",$J$67*(R40/(P40+R40)),IF(R40=0,0,IF((P40+R40)*0.005>=$J$67,$J$67*(R40/(P40+R40)),((R40*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$44=\"döviz kurunu yazınız\",0,ROUND(L42*$L$44,2))","v":0},null,{"$f":"IF($L$44=\"döviz kurunu yazınız\",0,ROUND(N42*$L$44,2))","v":0},null,{"$f":"IF($L$44=\"döviz kurunu yazınız\",0,ROUND(P42*$L$44,2))","v":0},null,{"$f":"IF($L$44=\"döviz kurunu yazınız\",0,ROUND(R42*$L$44,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(L46:O47)","v":0},null,null,null,{"$f":"SUM(P46:S47)","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(L48:S49)","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,{"$f":"(IF($L$52=\"Yok\",0,IF($L$52=\"\",0,IF($E$21=\"Türk Bayrağı\",VLOOKUP($E$23,$B$62:$D$70,3),IF($E$21=\"Yabancı Bayrak\",VLOOKUP($E$23,$E$62:$G$70,3))))))*SIGN($E$23)","v":0}]
[null," Port Service Fee"]
[13," GENEL TOPLAM (TL)",null,null,null,null,null,null,null,null,null,{"$f":"L50+P52","v":0}]
[null," Grand Total (TL)"]
[]
[null," 2019 YILI \nLİMAN HİZMET ÜCRETİ / PORT SERVICE FEE",null,null,null,null,null,null,"2019 YILI \nKONTEYNER NAVLUN ODA PAYI \nCONTAINER\nCHAMBER'S FREIGHT SHARE",null,null,"ACENTENİN KAŞESİ  / AGENT  STAMP"]
[]
[null,"TÜRK \nBAYRAKLI GEMİ\nTURKISH FLAG SHIP     ",null,null,"YABANCI \nBAYRAKLI GEMİ\nFOREIGN FLAG SHIP",null,null,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,"KONTEYNER \nYÜK BİLGİLERİ      CONTAINER CARGO INFORMATION","KONTEYNER TAVAN  ÜCRET \n TUTAR     CONTAINER \nCEILING FEE"]
[]
[null,0,500,100,0,500,200]
[null,501,1500,170,501,1000,340]
[null,1501,2500,300,1001,1500,420]
[null,2501,5000,420,1501,2000,515,null,"YÜKLEME \nLOADING ",550]
[null,5001,10000,500,2001,2500,595]
[null,10001,25000,595,2501,5000,675,null,"BOŞALTMA \n UNLOADING",550]
[null,25001,35000,675,5001,10000,700]
[null,35001,50000,750,10001,25000,765,null,"YÜKLEME + BOŞALTMA     LOADING + UNLOADING",825]
[null,50001,"VE YUKARISI",800,25001,"VE YUKARISI",815]
["* 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."]