{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Sayfa4"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":5,"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":"Sayfa4","index":0,"n_rows":33,"n_cols":16,"rows_kept":33,"cut":false,"hidden":false,"merged":[[0,0,0,12],[1,0,1,12]]}
["ÖNEMLİ NOTLAR:\n- Bu tablo hizmet süresi konusunda fikir vermesi için MS Excel® programı üzerinde hazırlanmıştır.\n- Hesaplama sonuçları başvuru sistemindeki sonuçlardan küçük miktarda farklı olabilir.\n- Başvurularda ELEKTRONİK BAŞVURU SİSTEMİNİN SONUÇLARI ESASTIR. \n- Yıl-ay-gün toplamlarında 1 ay 30 gün, 1 yıl ise 360 gün olarak hesaplanmıştır.\n- Tarih girişlerini mutlaka el ile yapınız, kopyala-yapıştır şeklinde giriş yapmayınız,\ngün/ay/yıl sayılarının arasına \".\" veya \"/\" işareti koyunuz, \",\" (virgül) koymayınız.\n"]
["Deniz Hizmeti Süre Hesaplama"]
["Gemi Adı","Başlama Tarihi","Bitiş Tarihi","Uyarı\nNotu","Periyot\nBaşlama","Periyot\nBitiş","Hizmet\nSüresi (Gün)","Hizmet Dışı\nSüre (Gün)","Toplam Süre\n(Gün)","Hizmet Süresi\nToplam","Genel\nToplam (Gün)","Hizmet Süresi\n(Yıl-Ay-Gün)","Hizmet + Hizmet\nDışı Süre Toplam\n(Yıl-Ay-Gün)",null,"Tarih\nÇakışması","Kontrol"]
[null,null,null,{"$f":"IF(O4=\"*\",\"Tarih Çakışması\",\"\")","v":""},{"$f":"IF(B4=\"\",\"\",MINA(Başlama_Tarihi))","v":""},{"$f":"IF(E4=\"\",\"\",DATE(YEAR(E4)+1,MONTH(E4),DAY(E4)-1))","v":""},{"$f":"IF(IF($B$4=\"\",0,(MAX(MIN($C$4,F4)-MAX($B$4,E4)+1,0)))+IF($B$5=\"\",0,(MAX(MIN($C$5,F4)-MAX($B$5,E4)+1,0)))+IF($B$6=\"\",0,(MAX(MIN($C$6,F4)-MAX($B$6,E4)+1,0)))+IF($B$7=\"\",0,(MAX(MIN($C$7,F4)-MAX($B$7,E4)+1,0)))+IF($B$8=\"\",0,(MAX(MIN($C$8,F4)-MAX($B$8,E4)+1,0)))+IF($B$9=\"\",0,(MAX(MIN($C$9,F4)-MAX($B$9,E4)+1,0)))+IF($B$10=\"\",0,(MAX(MIN($C$10,F4)-MAX($B$10,E4)+1,0)))+IF($B$11=\"\",0,(MAX(MIN($C$11,F4)-MAX($B$11,E4)+1,0)))+IF($B$12=\"\",0,(MAX(MIN($C$12,F4)-MAX($B$12,E4)+1,0)))+IF($B$13=\"\",0,(MAX(MIN($C$13,F4)-MAX($B$13,E4)+1,0)))+IF($B$14=\"\",0,(MAX(MIN($C$14,F4)-MAX($B$14,E4)+1,0)))+IF($B$15=\"\",0,(MAX(MIN($C$15,F4)-MAX($B$15,E4)+1,0)))+IF($B$16=\"\",0,(MAX(MIN($C$16,F4)-MAX($B$16,E4)+1,0)))+IF($B$17=\"\",0,(MAX(MIN($C$17,F4)-MAX($B$17,E4)+1,0)))+IF($B$18=\"\",0,(MAX(MIN($C$18,F4)-MAX($B$18,E4)+1,0)))+IF($B$19=\"\",0,(MAX(MIN($C$19,F4)-MAX($B$19,E4)+1,0)))+IF($B$20=\"\",0,(MAX(MIN($C$20,F4)-MAX($B$20,E4)+1,0)))+IF($B$21=\"\",0,(MAX(MIN($C$21,F4)-MAX($B$21,E4)+1,0)))+IF($B$22=\"\",0,(MAX(MIN($C$22,F4)-MAX($B$22,E4)+1,0)))+IF($B$23=\"\",0,(MAX(MIN($C$23,F4)-MAX($B$23,E4)+1,0)))+IF($B$24=\"\",0,(MAX(MIN($C$24,F4)-MAX($B$24,E4)+1,0)))+IF($B$25=\"\",0,(MAX(MIN($C$25,F4)-MAX($B$25,E4)+1,0)))+IF($B$26=\"\",0,(MAX(MIN($C$26,F4)-MAX($B$26,E4)+1,0)))+IF($B$27=\"\",0,(MAX(MIN($C$27,F4)-MAX($B$27,E4)+1,0)))+IF($B$28=\"\",0,(MAX(MIN($C$28,F4)-MAX($B$28,E4)+1,0)))+IF($B$29=\"\",0,(MAX(MIN($C$29,F4)-MAX($B$29,E4)+1,0)))+IF($B$30=\"\",0,(MAX(MIN($C$30,F4)-MAX($B$30,E4)+1,0)))+IF($B$31=\"\",0,(MAX(MIN($C$31,F4)-MAX($B$31,E4)+1,0)))+IF($B$32=\"\",0,(MAX(MIN($C$32,F4)-MAX($B$32,E4)+1,0)))+IF($B$33=\"\",0,(MAX(MIN($C$33,F4)-MAX($B$33,E4)+1,0)))=0,\"\",IF($B$4=\"\",0,(MAX(MIN($C$4,F4)-MAX($B$4,E4)+1,0)))+IF($B$5=\"\",0,(MAX(MIN($C$5,F4)-MAX($B$5,E4)+1,0)))+IF($B$6=\"\",0,(MAX(MIN($C$6,F4)-MAX($B$6,E4)+1,0)))+IF($B$7=\"\",0,(MAX(MIN($C$7,F4)-MAX($B$7,E4)+1,0)))+IF($B$8=\"\",0,(MAX(MIN($C$8,F4)-MAX($B$8,E4)+1,0)))+IF($B$9=\"\",0,(MAX(MIN($C$9,F4)-MAX($B$9,E4)+1,0)))+IF($B$10=\"\",0,(MAX(MIN($C$10,F4)-MAX($B$10,E4)+1,0)))+IF($B$11=\"\",0,(MAX(MIN($C$11,F4)-MAX($B$11,E4)+1,0)))+IF($B$12=\"\",0,(MAX(MIN($C$12,F4)-MAX($B$12,E4)+1,0)))+IF($B$13=\"\",0,(MAX(MIN($C$13,F4)-MAX($B$13,E4)+1,0)))+IF($B$14=\"\",0,(MAX(MIN($C$14,F4)-MAX($B$14,E4)+1,0)))+IF($B$15=\"\",0,(MAX(MIN($C$15,F4)-MAX($B$15,E4)+1,0)))+IF($B$16=\"\",0,(MAX(MIN($C$16,F4)-MAX($B$16,E4)+1,0)))+IF($B$17=\"\",0,(MAX(MIN($C$17,F4)-MAX($B$17,E4)+1,0)))+IF($B$18=\"\",0,(MAX(MIN($C$18,F4)-MAX($B$18,E4)+1,0)))+IF($B$19=\"\",0,(MAX(MIN($C$19,F4)-MAX($B$19,E4)+1,0)))+IF($B$20=\"\",0,(MAX(MIN($C$20,F4)-MAX($B$20,E4)+1,0)))+IF($B$21=\"\",0,(MAX(MIN($C$21,F4)-MAX($B$21,E4)+1,0)))+IF($B$22=\"\",0,(MAX(MIN($C$22,F4)-MAX($B$22,E4)+1,0)))+IF($B$23=\"\",0,(MAX(MIN($C$23,F4)-MAX($B$23,E4)+1,0)))+IF($B$24=\"\",0,(MAX(MIN($C$24,F4)-MAX($B$24,E4)+1,0)))+IF($B$25=\"\",0,(MAX(MIN($C$25,F4)-MAX($B$25,E4)+1,0)))+IF($B$26=\"\",0,(MAX(MIN($C$26,F4)-MAX($B$26,E4)+1,0)))+IF($B$27=\"\",0,(MAX(MIN($C$27,F4)-MAX($B$27,E4)+1,0)))+IF($B$28=\"\",0,(MAX(MIN($C$28,F4)-MAX($B$28,E4)+1,0)))+IF($B$29=\"\",0,(MAX(MIN($C$29,F4)-MAX($B$29,E4)+1,0)))+IF($B$30=\"\",0,(MAX(MIN($C$30,F4)-MAX($B$30,E4)+1,0)))+IF($B$31=\"\",0,(MAX(MIN($C$31,F4)-MAX($B$31,E4)+1,0)))+IF($B$32=\"\",0,(MAX(MIN($C$32,F4)-MAX($B$32,E4)+1,0)))+IF($B$33=\"\",0,(MAX(MIN($C$33,F4)-MAX($B$33,E4)+1,0))))","v":""},{"$f":"_xlfn.IFS(G4=\"\",\"\",G4=366,0,G4=180,30,G4=300,60,G4<180,ROUND(G4/6,0),AND(G4>180,G4<300),(30+(ROUND((G4-180)/6,0))),G4>300,(360-G4))","v":""},{"$f":"IF(G4=\"\",\"\",G4+H4)","v":""},{"$f":"SUM(G4:G33)","v":0},{"$f":"SUM(I4:I33)","v":0},{"$f":"IF(J4=0,\"\",INT(J4/360)&\" YIL \"&INT((J4-INT(J4/360)*360)/30)&\" AY \"&J4-INT(J4/360)*360-INT((J4-INT(J4/360)*360)/30)*30&\" GÜN\")","v":""},{"$f":"IF(K4=0,\"\",INT(K4/360)&\" YIL \"&INT((K4-INT(K4/360)*360)/30)&\" AY \"&K4-INT(K4/360)*360-INT((K4-INT(K4/360)*360)/30)*30&\" GÜN\")","v":""},null,{"$f":"IF(AND(P4=TRUE),\"*\",\" \")","v":" "},{"$f":"IF(B4=\"\",\"\",SUMPRODUCT((B4<=Bitiş_Tarihi)*(C4>=Başlama_Tarihi))>1)","v":""}]
[null,null,null,"",{"$f":"IF(F4=\"\",\"\",DATE(YEAR(F4),MONTH(F4),DAY(F4)+1))","v":""},{"$f":"IF(F4=\"\",\"\",DATE(YEAR(F4)+1,MONTH(F4),DAY(F4)))","v":""},{"$f":"IF(IF($B$4=\"\",0,(MAX(MIN($C$4,F5)-MAX($B$4,E5)+1,0)))+IF($B$5=\"\",0,(MAX(MIN($C$5,F5)-MAX($B$5,E5)+1,0)))+IF($B$6=\"\",0,(MAX(MIN($C$6,F5)-MAX($B$6,E5)+1,0)))+IF($B$7=\"\",0,(MAX(MIN($C$7,F5)-MAX($B$7,E5)+1,0)))+IF($B$8=\"\",0,(MAX(MIN($C$8,F5)-MAX($B$8,E5)+1,0)))+IF($B$9=\"\",0,(MAX(MIN($C$9,F5)-MAX($B$9,E5)+1,0)))+IF($B$10=\"\",0,(MAX(MIN($C$10,F5)-MAX($B$10,E5)+1,0)))+IF($B$11=\"\",0,(MAX(MIN($C$11,F5)-MAX($B$11,E5)+1,0)))+IF($B$12=\"\",0,(MAX(MIN($C$12,F5)-MAX($B$12,E5)+1,0)))+IF($B$13=\"\",0,(MAX(MIN($C$13,F5)-MAX($B$13,E5)+1,0)))+IF($B$14=\"\",0,(MAX(MIN($C$14,F5)-MAX($B$14,E5)+1,0)))+IF($B$15=\"\",0,(MAX(MIN($C$15,F5)-MAX($B$15,E5)+1,0)))+IF($B$16=\"\",0,(MAX(MIN($C$16,F5)-MAX($B$16,E5)+1,0)))+IF($B$17=\"\",0,(MAX(MIN($C$17,F5)-MAX($B$17,E5)+1,0)))+IF($B$18=\"\",0,(MAX(MIN($C$18,F5)-MAX($B$18,E5)+1,0)))+IF($B$19=\"\",0,(MAX(MIN($C$19,F5)-MAX($B$19,E5)+1,0)))+IF($B$20=\"\",0,(MAX(MIN($C$20,F5)-MAX($B$20,E5)+1,0)))+IF($B$21=\"\",0,(MAX(MIN($C$21,F5)-MAX($B$21,E5)+1,0)))+IF($B$22=\"\",0,(MAX(MIN($C$22,F5)-MAX($B$22,E5)+1,0)))+IF($B$23=\"\",0,(MAX(MIN($C$23,F5)-MAX($B$23,E5)+1,0)))+IF($B$24=\"\",0,(MAX(MIN($C$24,F5)-MAX($B$24,E5)+1,0)))+IF($B$25=\"\",0,(MAX(MIN($C$25,F5)-MAX($B$25,E5)+1,0)))+IF($B$26=\"\",0,(MAX(MIN($C$26,F5)-MAX($B$26,E5)+1,0)))+IF($B$27=\"\",0,(MAX(MIN($C$27,F5)-MAX($B$27,E5)+1,0)))+IF($B$28=\"\",0,(MAX(MIN($C$28,F5)-MAX($B$28,E5)+1,0)))+IF($B$29=\"\",0,(MAX(MIN($C$29,F5)-MAX($B$29,E5)+1,0)))+IF($B$30=\"\",0,(MAX(MIN($C$30,F5)-MAX($B$30,E5)+1,0)))+IF($B$31=\"\",0,(MAX(MIN($C$31,F5)-MAX($B$31,E5)+1,0)))+IF($B$32=\"\",0,(MAX(MIN($C$32,F5)-MAX($B$32,E5)+1,0)))+IF($B$33=\"\",0,(MAX(MIN($C$33,F5)-MAX($B$33,E5)+1,0)))=0,\"\",IF($B$4=\"\",0,(MAX(MIN($C$4,F5)-MAX($B$4,E5)+1,0)))+IF($B$5=\"\",0,(MAX(MIN($C$5,F5)-MAX($B$5,E5)+1,0)))+IF($B$6=\"\",0,(MAX(MIN($C$6,F5)-MAX($B$6,E5)+1,0)))+IF($B$7=\"\",0,(MAX(MIN($C$7,F5)-MAX($B$7,E5)+1,0)))+IF($B$8=\"\",0,(MAX(MIN($C$8,F5)-MAX($B$8,E5)+1,0)))+IF($B$9=\"\",0,(MAX(MIN($C$9,F5)-MAX($B$9,E5)+1,0)))+IF($B$10=\"\",0,(MAX(MIN($C$10,F5)-MAX($B$10,E5)+1,0)))+IF($B$11=\"\",0,(MAX(MIN($C$11,F5)-MAX($B$11,E5)+1,0)))+IF($B$12=\"\",0,(MAX(MIN($C$12,F5)-MAX($B$12,E5)+1,0)))+IF($B$13=\"\",0,(MAX(MIN($C$13,F5)-MAX($B$13,E5)+1,0)))+IF($B$14=\"\",0,(MAX(MIN($C$14,F5)-MAX($B$14,E5)+1,0)))+IF($B$15=\"\",0,(MAX(MIN($C$15,F5)-MAX($B$15,E5)+1,0)))+IF($B$16=\"\",0,(MAX(MIN($C$16,F5)-MAX($B$16,E5)+1,0)))+IF($B$17=\"\",0,(MAX(MIN($C$17,F5)-MAX($B$17,E5)+1,0)))+IF($B$18=\"\",0,(MAX(MIN($C$18,F5)-MAX($B$18,E5)+1,0)))+IF($B$19=\"\",0,(MAX(MIN($C$19,F5)-MAX($B$19,E5)+1,0)))+IF($B$20=\"\",0,(MAX(MIN($C$20,F5)-MAX($B$20,E5)+1,0)))+IF($B$21=\"\",0,(MAX(MIN($C$21,F5)-MAX($B$21,E5)+1,0)))+IF($B$22=\"\",0,(MAX(MIN($C$22,F5)-MAX($B$22,E5)+1,0)))+IF($B$23=\"\",0,(MAX(MIN($C$23,F5)-MAX($B$23,E5)+1,0)))+IF($B$24=\"\",0,(MAX(MIN($C$24,F5)-MAX($B$24,E5)+1,0)))+IF($B$25=\"\",0,(MAX(MIN($C$25,F5)-MAX($B$25,E5)+1,0)))+IF($B$26=\"\",0,(MAX(MIN($C$26,F5)-MAX($B$26,E5)+1,0)))+IF($B$27=\"\",0,(MAX(MIN($C$27,F5)-MAX($B$27,E5)+1,0)))+IF($B$28=\"\",0,(MAX(MIN($C$28,F5)-MAX($B$28,E5)+1,0)))+IF($B$29=\"\",0,(MAX(MIN($C$29,F5)-MAX($B$29,E5)+1,0)))+IF($B$30=\"\",0,(MAX(MIN($C$30,F5)-MAX($B$30,E5)+1,0)))+IF($B$31=\"\",0,(MAX(MIN($C$31,F5)-MAX($B$31,E5)+1,0)))+IF($B$32=\"\",0,(MAX(MIN($C$32,F5)-MAX($B$32,E5)+1,0)))+IF($B$33=\"\",0,(MAX(MIN($C$33,F5)-MAX($B$33,E5)+1,0))))","v":""},{"$f":"_xlfn.IFS(G5=\"\",\"\",G5=366,0,G5=180,30,G5=300,60,G5<180,ROUND(G5/6,0),AND(G5>180,G5<300),(30+(ROUND((G5-180)/6,0))),G5>300,(360-G5))","v":""},{"$f":"IF(G5=\"\",\"\",G5+H5)","v":""},null,null,null,null,null," ",{"$f":"IF(B5=\"\",\"\",SUMPRODUCT((B5<=Bitiş_Tarihi)*(C5>=Başlama_Tarihi))>1)","v":""}]
[null,null,null,"",{"$f":"IF(F5=\"\",\"\",DATE(YEAR(F5),MONTH(F5),DAY(F5)+1))","v":""},{"$f":"IF(F5=\"\",\"\",DATE(YEAR(F5)+1,MONTH(F5),DAY(F5)))","v":""},"",{"$f":"_xlfn.IFS(G6=\"\",\"\",G6=366,0,G6=180,30,G6=300,60,G6<180,ROUND(G6/6,0),AND(G6>180,G6<300),(30+(ROUND((G6-180)/6,0))),G6>300,(360-G6))","v":""},"",null,null,null,null,null," ",{"$f":"IF(B6=\"\",\"\",SUMPRODUCT((B6<=Bitiş_Tarihi)*(C6>=Başlama_Tarihi))>1)","v":""}]
[null,null,null,"",{"$f":"IF(F6=\"\",\"\",DATE(YEAR(F6),MONTH(F6),DAY(F6)+1))","v":""},{"$f":"IF(F6=\"\",\"\",DATE(YEAR(F6)+1,MONTH(F6),DAY(F6)))","v":""},"",{"$f":"_xlfn.IFS(G7=\"\",\"\",G7=366,0,G7=180,30,G7=300,60,G7<180,ROUND(G7/6,0),AND(G7>180,G7<300),(30+(ROUND((G7-180)/6,0))),G7>300,(360-G7))","v":""},"",null,null,null,null,null," ",{"$f":"IF(B7=\"\",\"\",SUMPRODUCT((B7<=Bitiş_Tarihi)*(C7>=Başlama_Tarihi))>1)","v":""}]
[null,null,null,"","","","",{"$f":"_xlfn.IFS(G8=\"\",\"\",G8=366,0,G8=180,30,G8=300,60,G8<180,ROUND(G8/6,0),AND(G8>180,G8<300),(30+(ROUND((G8-180)/6,0))),G8>300,(360-G8))","v":""},"",null,null,null,null,null," ",{"$f":"IF(B8=\"\",\"\",SUMPRODUCT((B8<=Bitiş_Tarihi)*(C8>=Başlama_Tarihi))>1)","v":""}]
[null,null,null,"","","","",{"$f":"_xlfn.IFS(G9=\"\",\"\",G9=366,0,G9=180,30,G9=300,60,G9<180,ROUND(G9/6,0),AND(G9>180,G9<300),(30+(ROUND((G9-180)/6,0))),G9>300,(360-G9))","v":""},"",null,null,null,null,null," ",{"$f":"IF(B9=\"\",\"\",SUMPRODUCT((B9<=Bitiş_Tarihi)*(C9>=Başlama_Tarihi))>1)","v":""}]
[null,null,null,"","","","",{"$f":"_xlfn.IFS(G10=\"\",\"\",G10=366,0,G10=180,30,G10=300,60,G10<180,ROUND(G10/6,0),AND(G10>180,G10<300),(30+(ROUND((G10-180)/6,0))),G10>300,(360-G10))","v":""},"",null,null,null,null,null," ",{"$f":"IF(B10=\"\",\"\",SUMPRODUCT((B10<=Bitiş_Tarihi)*(C10>=Başlama_Tarihi))>1)","v":""}]
[null,null,null,"","","","",{"$f":"_xlfn.IFS(G11=\"\",\"\",G11=366,0,G11=180,30,G11=300,60,G11<180,ROUND(G11/6,0),AND(G11>180,G11<300),(30+(ROUND((G11-180)/6,0))),G11>300,(360-G11))","v":""},"",null,null,null,null,null," ",{"$f":"IF(B11=\"\",\"\",SUMPRODUCT((B11<=Bitiş_Tarihi)*(C11>=Başlama_Tarihi))>1)","v":""}]
[null,null,null,"","","","",{"$f":"_xlfn.IFS(G12=\"\",\"\",G12=366,0,G12=180,30,G12=300,60,G12<180,ROUND(G12/6,0),AND(G12>180,G12<300),(30+(ROUND((G12-180)/6,0))),G12>300,(360-G12))","v":""},"",null,null,null,null,null," ",{"$f":"IF(B12=\"\",\"\",SUMPRODUCT((B12<=Bitiş_Tarihi)*(C12>=Başlama_Tarihi))>1)","v":""}]
[null,null,null,"","","","",{"$f":"_xlfn.IFS(G13=\"\",\"\",G13=366,0,G13=180,30,G13=300,60,G13<180,ROUND(G13/6,0),AND(G13>180,G13<300),(30+(ROUND((G13-180)/6,0))),G13>300,(360-G13))","v":""},"",null,null,null,null,null," ",{"$f":"IF(B13=\"\",\"\",SUMPRODUCT((B13<=Bitiş_Tarihi)*(C13>=Başlama_Tarihi))>1)","v":""}]
[null,null,null,"","","","",{"$f":"_xlfn.IFS(G14=\"\",\"\",G14=366,0,G14=180,30,G14=300,60,G14<180,ROUND(G14/6,0),AND(G14>180,G14<300),(30+(ROUND((G14-180)/6,0))),G14>300,(360-G14))","v":""},"",null,null,null,null,null," ",{"$f":"IF(B14=\"\",\"\",SUMPRODUCT((B14<=Bitiş_Tarihi)*(C14>=Başlama_Tarihi))>1)","v":""}]
[null,null,null,"","","","",{"$f":"_xlfn.IFS(G15=\"\",\"\",G15=366,0,G15=180,30,G15=300,60,G15<180,ROUND(G15/6,0),AND(G15>180,G15<300),(30+(ROUND((G15-180)/6,0))),G15>300,(360-G15))","v":""},"",null,null,null,null,null," ",{"$f":"IF(B15=\"\",\"\",SUMPRODUCT((B15<=Bitiş_Tarihi)*(C15>=Başlama_Tarihi))>1)","v":""}]
[null,null,null,"","","","",{"$f":"_xlfn.IFS(G16=\"\",\"\",G16=366,0,G16=180,30,G16=300,60,G16<180,ROUND(G16/6,0),AND(G16>180,G16<300),(30+(ROUND((G16-180)/6,0))),G16>300,(360-G16))","v":""},"",null,null,null,null,null," ",{"$f":"IF(B16=\"\",\"\",SUMPRODUCT((B16<=Bitiş_Tarihi)*(C16>=Başlama_Tarihi))>1)","v":""}]
[null,null,null,"","","","",{"$f":"_xlfn.IFS(G17=\"\",\"\",G17=366,0,G17=180,30,G17=300,60,G17<180,ROUND(G17/6,0),AND(G17>180,G17<300),(30+(ROUND((G17-180)/6,0))),G17>300,(360-G17))","v":""},"",null,null,null,null,null," ",{"$f":"IF(B17=\"\",\"\",SUMPRODUCT((B17<=Bitiş_Tarihi)*(C17>=Başlama_Tarihi))>1)","v":""}]
[null,null,null,"","","","",{"$f":"_xlfn.IFS(G18=\"\",\"\",G18=366,0,G18=180,30,G18=300,60,G18<180,ROUND(G18/6,0),AND(G18>180,G18<300),(30+(ROUND((G18-180)/6,0))),G18>300,(360-G18))","v":""},"",null,null,null,null,null," ",{"$f":"IF(B18=\"\",\"\",SUMPRODUCT((B18<=Bitiş_Tarihi)*(C18>=Başlama_Tarihi))>1)","v":""}]
[null,null,null,"","","","",{"$f":"_xlfn.IFS(G19=\"\",\"\",G19=366,0,G19=180,30,G19=300,60,G19<180,ROUND(G19/6,0),AND(G19>180,G19<300),(30+(ROUND((G19-180)/6,0))),G19>300,(360-G19))","v":""},"",null,null,null,null,null," ",{"$f":"IF(B19=\"\",\"\",SUMPRODUCT((B19<=Bitiş_Tarihi)*(C19>=Başlama_Tarihi))>1)","v":""}]
[null,null,null,"","","","",{"$f":"_xlfn.IFS(G20=\"\",\"\",G20=366,0,G20=180,30,G20=300,60,G20<180,ROUND(G20/6,0),AND(G20>180,G20<300),(30+(ROUND((G20-180)/6,0))),G20>300,(360-G20))","v":""},"",null,null,null,null,null," ",{"$f":"IF(B20=\"\",\"\",SUMPRODUCT((B20<=Bitiş_Tarihi)*(C20>=Başlama_Tarihi))>1)","v":""}]
[null,null,null,"","","","",{"$f":"_xlfn.IFS(G21=\"\",\"\",G21=366,0,G21=180,30,G21=300,60,G21<180,ROUND(G21/6,0),AND(G21>180,G21<300),(30+(ROUND((G21-180)/6,0))),G21>300,(360-G21))","v":""},"",null,null,null,null,null," ",{"$f":"IF(B21=\"\",\"\",SUMPRODUCT((B21<=Bitiş_Tarihi)*(C21>=Başlama_Tarihi))>1)","v":""}]
[null,null,null,"","","","",{"$f":"_xlfn.IFS(G22=\"\",\"\",G22=366,0,G22=180,30,G22=300,60,G22<180,ROUND(G22/6,0),AND(G22>180,G22<300),(30+(ROUND((G22-180)/6,0))),G22>300,(360-G22))","v":""},"",null,null,null,null,null," ",{"$f":"IF(B22=\"\",\"\",SUMPRODUCT((B22<=Bitiş_Tarihi)*(C22>=Başlama_Tarihi))>1)","v":""}]
[null,null,null,"","","","",{"$f":"_xlfn.IFS(G23=\"\",\"\",G23=366,0,G23=180,30,G23=300,60,G23<180,ROUND(G23/6,0),AND(G23>180,G23<300),(30+(ROUND((G23-180)/6,0))),G23>300,(360-G23))","v":""},"",null,null,null,null,null," ",{"$f":"IF(B23=\"\",\"\",SUMPRODUCT((B23<=Bitiş_Tarihi)*(C23>=Başlama_Tarihi))>1)","v":""}]
[null,null,null,"","","","",{"$f":"_xlfn.IFS(G24=\"\",\"\",G24=366,0,G24=180,30,G24=300,60,G24<180,ROUND(G24/6,0),AND(G24>180,G24<300),(30+(ROUND((G24-180)/6,0))),G24>300,(360-G24))","v":""},"",null,null,null,null,null," ",{"$f":"IF(B24=\"\",\"\",SUMPRODUCT((B24<=Bitiş_Tarihi)*(C24>=Başlama_Tarihi))>1)","v":""}]
[null,null,null,"","","","",{"$f":"_xlfn.IFS(G25=\"\",\"\",G25=366,0,G25=180,30,G25=300,60,G25<180,ROUND(G25/6,0),AND(G25>180,G25<300),(30+(ROUND((G25-180)/6,0))),G25>300,(360-G25))","v":""},"",null,null,null,null,null," ",{"$f":"IF(B25=\"\",\"\",SUMPRODUCT((B25<=Bitiş_Tarihi)*(C25>=Başlama_Tarihi))>1)","v":""}]
[null,null,null,"","","","",{"$f":"_xlfn.IFS(G26=\"\",\"\",G26=366,0,G26=180,30,G26=300,60,G26<180,ROUND(G26/6,0),AND(G26>180,G26<300),(30+(ROUND((G26-180)/6,0))),G26>300,(360-G26))","v":""},"",null,null,null,null,null," ",{"$f":"IF(B26=\"\",\"\",SUMPRODUCT((B26<=Bitiş_Tarihi)*(C26>=Başlama_Tarihi))>1)","v":""}]
[null,null,null,"","","","",{"$f":"_xlfn.IFS(G27=\"\",\"\",G27=366,0,G27=180,30,G27=300,60,G27<180,ROUND(G27/6,0),AND(G27>180,G27<300),(30+(ROUND((G27-180)/6,0))),G27>300,(360-G27))","v":""},"",null,null,null,null,null," ",{"$f":"IF(B27=\"\",\"\",SUMPRODUCT((B27<=Bitiş_Tarihi)*(C27>=Başlama_Tarihi))>1)","v":""}]
[null,null,null,"","","","",{"$f":"_xlfn.IFS(G28=\"\",\"\",G28=366,0,G28=180,30,G28=300,60,G28<180,ROUND(G28/6,0),AND(G28>180,G28<300),(30+(ROUND((G28-180)/6,0))),G28>300,(360-G28))","v":""},"",null,null,null,null,null," ",{"$f":"IF(B28=\"\",\"\",SUMPRODUCT((B28<=Bitiş_Tarihi)*(C28>=Başlama_Tarihi))>1)","v":""}]
[null,null,null,"","","","",{"$f":"_xlfn.IFS(G29=\"\",\"\",G29=366,0,G29=180,30,G29=300,60,G29<180,ROUND(G29/6,0),AND(G29>180,G29<300),(30+(ROUND((G29-180)/6,0))),G29>300,(360-G29))","v":""},"",null,null,null,null,null," ",{"$f":"IF(B29=\"\",\"\",SUMPRODUCT((B29<=Bitiş_Tarihi)*(C29>=Başlama_Tarihi))>1)","v":""}]
[null,null,null,"","","","",{"$f":"_xlfn.IFS(G30=\"\",\"\",G30=366,0,G30=180,30,G30=300,60,G30<180,ROUND(G30/6,0),AND(G30>180,G30<300),(30+(ROUND((G30-180)/6,0))),G30>300,(360-G30))","v":""},"",null,null,null,null,null," ",{"$f":"IF(B30=\"\",\"\",SUMPRODUCT((B30<=Bitiş_Tarihi)*(C30>=Başlama_Tarihi))>1)","v":""}]
[null,null,null,"","","","",{"$f":"_xlfn.IFS(G31=\"\",\"\",G31=366,0,G31=180,30,G31=300,60,G31<180,ROUND(G31/6,0),AND(G31>180,G31<300),(30+(ROUND((G31-180)/6,0))),G31>300,(360-G31))","v":""},"",null,null,null,null,null," ",{"$f":"IF(B31=\"\",\"\",SUMPRODUCT((B31<=Bitiş_Tarihi)*(C31>=Başlama_Tarihi))>1)","v":""}]
[null,null,null,"","","","",{"$f":"_xlfn.IFS(G32=\"\",\"\",G32=366,0,G32=180,30,G32=300,60,G32<180,ROUND(G32/6,0),AND(G32>180,G32<300),(30+(ROUND((G32-180)/6,0))),G32>300,(360-G32))","v":""},"",null,null,null,null,null," ",{"$f":"IF(B32=\"\",\"\",SUMPRODUCT((B32<=Bitiş_Tarihi)*(C32>=Başlama_Tarihi))>1)","v":""}]
[null,null,null,"","","","",{"$f":"_xlfn.IFS(G33=\"\",\"\",G33=366,0,G33=180,30,G33=300,60,G33<180,ROUND(G33/6,0),AND(G33>180,G33<300),(30+(ROUND((G33-180)/6,0))),G33>300,(360-G33))","v":""},"",null,null,null,null,null," ",{"$f":"IF(B33=\"\",\"\",SUMPRODUCT((B33<=Bitiş_Tarihi)*(C33>=Başlama_Tarihi))>1)","v":""}]