{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["YOLCU NAVLUN  BILDIRIM"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":1,"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":"YOLCU NAVLUN  BILDIRIM","index":0,"n_rows":53,"n_cols":14,"rows_kept":53,"cut":false,"hidden":false,"merged":[[0,0,0,13],[51,12,51,13],[52,12,52,13],[42,12,43,13],[44,12,44,13],[45,12,45,13],[46,12,46,13],[47,12,47,13],[48,12,48,13],[49,12,49,13],[50,12,50,13],[41,1,41,6],[35,1,35,4],[34,0,35,0],[34,1,34,4],[36,0,38,0],[36,1,36,6],[36,7,38,7],[36,8,36,13],[37,1,37,6],[16,5,17,6],[24,5,25,13],[26,5,27,13],[23,1,23,4],[7,1,7,4],[7,5,8,13],[8,1,8,4],[12,0,13,1],[12,2,12,13],[13,2,13,13],[11,0,11,13],[18,5,19,6],[18,7,19,7],[18,8,18,10],[19,8,19,10],[18,11,19,13],[18,0,19,0],[16,7,17,13],[1,13,3,13],[1,0,3,1],[1,2,1,12],[2,2,2,12],[3,2,3,12],[40,8,40,13],[5,0,6,1],[5,2,5,13],[6,2,6,13],[14,0,15,0],[16,0,17,0],[9,0,10,0],[9,1,9,4],[10,1,10,4],[9,5,10,13],[14,1,14,4],[15,1,15,4],[16,1,16,4],[17,1,17,4],[14,5,15,13],[7,0,8,0],[24,0,25,0],[26,0,27,0],[20,0,21,0],[22,0,23,0],[18,1,18,4],[19,1,19,4],[20,1,20,4],[21,1,21,4],[27,1,27,4],[22,1,22,4],[20,5,21,13],[22,5,23,13],[30,1,30,4],[31,1,31,4],[30,0,31,0],[24,1,24,4],[25,1,25,4],[26,1,26,4],[37,8,37,13],[32,0,33,0],[32,1,32,4],[33,1,33,4],[28,1,28,4],[29,1,29,4],[28,0,29,0],[28,5,29,6],[30,5,31,6],[32,5,33,6],[34,5,35,6],[30,7,31,7],[30,11,31,13],[28,7,29,13],[32,7,33,13],[34,7,35,13],[38,1,38,6],[38,8,38,13],[52,9,52,11],[41,8,41,13],[42,1,43,4],[42,5,43,6],[42,8,43,11],[44,5,44,6],[45,5,45,6],[46,5,46,6],[47,5,47,6],[48,5,48,6],[49,5,49,6],[40,1,40,6],[49,2,49,4],[50,1,52,6]]}
[]
["2021\nYILI",null,"YABANCI BAYRAKLI  YOLCU VE KRUVAZİYER GEMİLERİ",null,null,null,null,null,null,null,null,null,null,"2021\nYILI"]
[null,null,"NAVLUN ODA PAYI BİLDİRİM FORMU"]
[null,null,"CHAMBER'S SHARE OF FREIGHT REVENUE DECLARATION FORM FOR FOREIGN FLAG PASSENGER & CRUISE SHIPS"]
[]
["A",null,"GEMİ ACENTE BİLGİLERİ"]
[null,null,"SHIP AGENCY INFORMATION"]
[1," GEMİ ACENTESİ SİCİL NUMARASI"]
[null,"Ship's Agent Registration Number"]
[2," 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,null,"Yolcu-Kruvaziyer"]
[null," Type of vessel"]
[3,"  TÜRK - YABANCI BAYRAK",null,null,null,"Yabancı Bayrak",null,4," BAYRAĞI"]
[null," Turkish - Foreign Flag",null,null,null,null,null,null," Flag"]
[5," GROS TONU"]
[null," GT"]
[6," HAREKET LİMANI"]
[null," Port of Departure "]
[7," HAREKET TARİHİ"]
[null," Date of Departure "]
[8," LİMAN ÇIKIŞ BELGE ( LÇB ) NO "]
[null," Certificate of seagoing number"]
[9," LİMAN HİZMET ÜCRETİ (TL)",null,null,null,{"$f":"IF(OR($F$17=\"Gemi Cinsini Seçin\",$F$17=\"\",$F$19=\"Bayrağı Seçin\",$F$21=\"\")=TRUE,0,IF($F$19=\"Yabancı Bayrak\",VLOOKUP($F$21,$I$45:$M$53,5)))","v":0}]
[null," Port Service Fee (TL)"]
[10," NAVLUN ÜCRETİ ($)",null,null,null,{"$f":"IF(OR($F$17=\"Gemi Cinsini Seçin\",$F$17=\"\",$F$19=\"Bayrağı Seçin\",$F$21=\"\")=TRUE,0,IF($F$19=\"Yabancı Bayrak\",VLOOKUP($F$21,$B$45:$F$53,5)))","v":0},null,11," DÖVİZ KURU ",null,null,"Döviz kurunu girin"]
[null," Freight Fee ($)",null,null,null,null,null,null,"EXCHANGE RATE"]
[12," YOLCU NAVLUN ÜCRETİ (TL)",null,null,null,{"$f":"IF(OR($F$31=0,$L$31=\"\",$L$31=\"döviz kurunu girin\"),0,ROUND($F$31*L31,2))","v":0}]
[null,"Passengers Freight Fee (TL)"]
[13,"GENEL TOPLAM (TL)",null,null,null,{"$f":"ROUND(SUM(F29+F33),2)","v":0}]
[null,"Grand Total (TL)"]
[14,"AÇIKLAMA",null,null,null,null,null,15,"ACENTENİN KAŞESİ  / AGENT  STAMP"]
[null,"Description",null,null,null,null,null,null,"TARİH ve İMZA / DATE - SIGNATURE"]
[]
[]
[null,"2021 YABANCI BAYRAKLI  YOLCU VE KRUVAZİYER GEMİLERDEN \nALINAN NAVLUN HASILAT ODA PAYI TARİFESİ",null,null,null,null,null,null,"2021 YILI YABANCI BAYRAKLI YOLCU VE KRUVAZİYER GEMİLERDEN ALINACAK LİMAN HİZMET ÜCRETİ"]
[null," 2021 TARIFF FOR CHAMBER'S SHARE OF FREIGHT REVENUE\nOBTAINED FROM FOREIGN FLAG PASSENGER AND CRUISE SHIPS",null,null,null,null,null,null,"PORT SERVICE FEE TO BE COLLECTED FROM THE FOREIGN \nFLAGGED PASSENGER AND CRUISE SHIPS IN 2021"]
[null,"GEMİ GROS TONU\nSHIP'S GROSS TONAGE",null,null,null,"TUTAR\nAMOUNT",null,null,"GEMİ GROS TONU\nSHIP'S GROSS TONAGE",null,null,null,"YOLCU ve KRUVAZİYER\n Gemileri İçin. \n For Passenger and Cruise Ships"]
[]
[null,0,5000,"GT","KADAR / UP TO","ÜCRETSİZ",null,null,0,500,"GT","KADAR / UP TO",210]
[null,5001,20000,"GT","KADAR / UP TO",50,null,null,501,1000,"GT","KADAR / UP TO",345]
[null,20001,30000,"GT","KADAR / UP TO",100,null,null,1001,1500,"GT","KADAR / UP TO",430]
[null,30001,50000,"GT","KADAR / UP TO",150,null,null,1501,2000,"GT","KADAR / UP TO",540]
[null,50001,100000,"GT","KADAR / UP TO",200,null,null,2001,2500,"GT","KADAR / UP TO",645]
[null,100001,"GT VE YUKARISI / GT AND OVER",null,null,250,null,null,2501,5000,"GT","KADAR / UP TO",780]
[null,"Not : ( LÇB ) Liman Çıkış Belge numarası yazılması gerekmektedir. \n  ( CS ) Certificate of Seagoing number should be written .",null,null,null,null,null,null,5001,10000,"GT","KADAR / UP TO",860]
[null,null,null,null,null,null,null,null,10001,25000,"GT","KADAR / UP TO",975]
[null,null,null,null,null,null,null,null,25001,"GT VE YUKARISI / GT AND OVER",null,null,1100]