{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["BİLGİ GİRİŞİ","BORDRO","FAİZ"],"not_rendered":{"charts":0,"images":5,"macros":1,"external_links":0,"defined_names":4,"comments":1,"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":"BİLGİ GİRİŞİ","index":0,"n_rows":38,"n_cols":14,"rows_kept":38,"cut":false,"hidden":false,"merged":[[1,1,1,15],[2,1,30,1],[30,2,30,14],[2,15,30,15],[3,3,3,6],[11,8,11,13],[25,10,25,13],[4,8,4,13],[3,8,3,11],[5,10,5,13],[6,10,7,13],[8,10,9,13],[20,10,20,13],[19,8,19,13],[5,4,5,6],[4,4,4,6],[7,4,7,6],[8,4,8,6],[9,4,9,6],[10,4,10,6],[11,4,11,6],[24,4,24,6],[25,4,25,6],[12,4,12,6],[13,4,13,6],[14,4,14,6],[15,4,15,6],[16,4,16,6],[27,4,27,5],[21,10,22,13],[26,4,26,6],[28,4,28,6],[12,11,12,13],[12,9,12,10],[17,4,17,6],[18,4,18,6],[19,4,19,6],[20,4,20,6],[21,4,21,6],[22,4,22,6],[20,8,22,9],[24,10,24,13],[24,8,25,9],[23,4,23,6]]}
[]
[]
[]
[null,null,null,"YURTİÇİ SÜREKLİ GÖREV YOLLUĞU"]
[null,null,null,"ADI VE SOYADI","Sedat ATAM",null,null,null,"FAİZLİ HESAPLAMA         "]
[null,null,null,"ÜNVANI","Öğretmen",null,null,null,"ANA PARA",{"$f":"BORDRO!S19","v":41400},"FAİZ HESAPLANACAK MI?"]
[null,null,null,"DERECE VE EK GÖSTERGESİ",8,"/",null,null,"KAÇ AYLIK FAİZ?",0,"Hayır"]
[null,null,null,"GÜNDELİĞİ",400,null,null,null,"FAİZ ORANI %",9]
[null,null,null,"NEREDEN GİTTİ","MUŞ-BULANIK Atatürk İlkokulu",null,null,null,"FAİZ TUTARI",{"$f":"IF(K7=\"EVET\",ROUND((J6*J7*J8)/1200,2),\"0\")","v":"0"},"NOT: Faiz hesaplanacaksa kaç aylık hesaplanacağı belirtilmelidir."]
[null,null,null,"NEREYE GİTTİ","İZMİR-KONAK Necatibey İlkokulu",null,null,null,"TOPLAM TUTAR",{"$f":"IF(K7=\"EVET\",J6+J9,J6)","v":41400}]
[null,null,null,"MESAFE (Km cinsinden) *",1400]
[null,null,null,"TAŞIT ÜCRETİ *",5000,null,null,null,"GÜNDELİKLER"]
[null,null,null,"Memurun 1.yakınının adı ve soyadı",null,null,null,null,"YIL","DERECE",null,"EK GÖSTERGE"]
[null,null,null,"Akrabalık Derecesi",null,null,null,null,null,"5 - 15","1- 4","3600-6400","6400-8000","8000 +"]
[null,null,null,"Memurun 2. yakınının adı ve soyadı",null,null,null,null,2021,46.35,47.65,54.05,57.55,61.65]
[null,null,null,"Akrabalık Derecesi",null,null,null,null,2022,100,102,115,121,129]
[null,null,null,"Memurun 3.yakınının adı ve soyadı",null,null,null,null,2023,200,203,212,220,236]
[null,null,null,"Akrabalık Derecesi",null,null,null,null,2024,400,405,420,435,465]
[null,null,null,"Memurun 4.yakınının adı ve soyadı"]
[null,null,null,"Akrabalık Derecesi",null,null,null,null,"EŞ DURUMU"]
[null,null,null,"Memurun 5.yakınının  adı ve soyadı",null,null,null,null,null,null,"EŞİ DE ATANMIŞ MIDIR?"]
[null,null,null,"Akrabalık Derecesi",null,null,null,null,null,null,"Hayır"]
[null,null,null,"Memurun 6.yakınının adı ve soyadı"]
[null,null,null,"Akrabalık Derecesi"]
[null,null,null,"Memurun 7.yakınının adı ve soyadı",null,null,null,null,"ONAY",null,"Metin ARAL"]
[null,null,null,"Akrabalık Derecesi",null,null,null,null,null,null,"Şube Müdürü"]
[null,null,null,"Toplamda Alacağı (Faiz Dahil)",{"$f":"J10","v":41400}]
[null,null,null,"Bildirim Tarihi","2023-01-20"]
[null,null,null,"DAİRESİ","BULANIK İLÇE MİLLİ EĞİTİM MÜDÜRLÜĞÜ"]
[]
[]
[]
[null,null,null,"Eşi"]
[null,null,null,"Oğlu"]
[null,null,null,"Kızı"]
[null,null,null,"Annesi"]
[null,null,null,"Babası"]
[null,null,null,"Diğer"]

{"sheet":"BORDRO","index":1,"n_rows":35,"n_cols":23,"rows_kept":35,"cut":false,"hidden":false,"merged":[[17,1,17,4],[18,0,18,4],[16,5,16,6],[17,5,17,6],[4,14,4,18],[18,12,18,13],[14,5,14,6],[15,5,15,6],[14,7,14,8],[13,12,13,13],[7,14,8,14],[10,12,10,13],[7,15,7,16],[12,12,12,13],[10,9,10,11],[7,12,8,13],[18,7,18,8],[24,0,24,18],[30,0,30,6],[31,0,31,6],[19,17,19,18],[29,10,29,16],[26,2,26,18],[23,7,23,8],[19,0,19,16],[18,9,18,11],[23,5,23,6],[18,5,18,6],[30,10,32,10],[30,11,32,16],[21,15,21,18],[22,15,22,16],[14,12,14,13],[13,5,13,6],[13,7,13,8],[27,0,27,6],[27,17,27,18],[27,10,27,16],[15,7,15,8],[15,9,15,11],[15,1,15,4],[16,1,16,4],[17,9,17,11],[15,12,15,13],[16,12,16,13],[17,12,17,13],[16,9,16,11],[16,7,16,8],[12,7,12,8],[13,1,13,4],[12,1,12,4],[9,12,9,13],[13,9,13,11],[12,9,12,11],[12,5,12,6],[11,1,11,4],[0,0,0,18],[10,5,10,6],[10,7,10,8],[6,1,9,4],[10,1,10,4],[4,11,4,12],[6,0,9,0],[1,2,1,10],[2,2,2,10],[7,9,8,11],[6,18,8,18],[6,17,8,17],[7,7,9,8],[6,5,6,11],[19,20,19,22],[28,10,28,16],[24,20,24,22],[17,7,17,8],[3,4,3,10],[4,2,4,10],[3,11,3,12],[6,12,6,16],[11,7,11,8],[11,5,11,6],[9,9,9,11],[7,5,9,6],[14,1,14,4],[14,9,14,11],[11,12,11,13],[11,9,11,11],[22,17,22,18],[21,0,21,6],[22,1,22,6],[21,7,21,14],[22,7,22,11],[22,12,22,14]]}
["YURTİÇİ SÜREKLİ GÖREV YOLLUĞU BİLDİRİMİ"]
["ADI SOYADI",":",{"$f":"IF('BİLGİ GİRİŞİ'!E5=\"\",\"\",'BİLGİ GİRİŞİ'!E5)","v":"Sedat ATAM"},null,null,null,null,null,null,null,null,"DAİRESİ",null,":",{"$f":"'BİLGİ GİRİŞİ'!E29","v":"BULANIK İLÇE MİLLİ EĞİTİM MÜDÜRLÜĞÜ"}]
["GÖREVİ / UNVANI",":",{"$f":"'BİLGİ GİRİŞİ'!E6","v":"Öğretmen"}]
["DERECESİ / EK GÖSTERGESİ",":",{"$f":"IF('BİLGİ GİRİŞİ'!E7=\"\",\"\",'BİLGİ GİRİŞİ'!E7)","v":8},"/",{"$f":"IF('BİLGİ GİRİŞİ'!G7=\"\",\"\",'BİLGİ GİRİŞİ'!G7)","v":""},null,null,null,null,null,null,"BÜTÇE YILI             ",null,":",{"$f":"YEAR(TODAY())","v":2024}]
["AYRILACAĞI YER",":",{"$f":"IF('BİLGİ GİRİŞİ'!E9=\"\",\"\",'BİLGİ GİRİŞİ'!E9)","v":"MUŞ-BULANIK Atatürk İlkokulu"},null,null,null,null,null,null,null,null,"GİDECEĞİ YER",null,":",{"$f":"IF('BİLGİ GİRİŞİ'!E10=\"\",\"\",'BİLGİ GİRİŞİ'!E10)","v":"İZMİR-KONAK Necatibey İlkokulu"}]
[]
[" Adı ve Soyadı","Akrabalık Derecesi",null,null,null,"GÜNDELİKLER",null,null,null,null,null,null,"YER DEĞİŞTİRME GİDERİ",null,null,null,null,"FAİZ","TOPLAM"]
[null,null,null,null,null,"Gün Sayısı",null,"Bir Günlüğü",null,"Tutarı",null,null,"Taşıt Ücreti",null,"Sabit Unsur","Değişken Unsurlar"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mesafe","Tutarı"]
[null,null,null,null,null,null,null,null,null,"(1)",null,null,"(2)",null,"(3)",null,"(4)","(5)","(1+2+3+4+5)",null,1,3,4]
[{"$f":"IF('BİLGİ GİRİŞİ'!E5=\"\",\"\",'BİLGİ GİRİŞİ'!E5)","v":"Sedat ATAM"},{"$f":"IF('BİLGİ GİRİŞİ'!E5=\"\",\"\",\"Kendisi\")","v":"Kendisi"},null,null,null,{"$f":"IF(A11=\"\",\"\",1)","v":1},null,{"$f":"'BİLGİ GİRİŞİ'!E8","v":400},null,{"$f":"IF(U11=\"\",\"\",ROUND(U11,2))","v":400},null,null,{"$f":"'BİLGİ GİRİŞİ'!E12","v":5000},null,{"$f":"IF(V11=\"\",\"\",ROUND(V11,2))","v":8000},{"$f":"'BİLGİ GİRİŞİ'!E11","v":1400},{"$f":"IF(W11=\"\",\"\",IF('BİLGİ GİRİŞİ'!K22=\"EVET\",ROUND(W11/2,2),ROUND(W11,2)))","v":28000},{"$f":"IF('BİLGİ GİRİŞİ'!J9=\"\",\"\",'BİLGİ GİRİŞİ'!J9)","v":"0"},{"$f":"IF(A11=\"\",\"\",J11+M11+O11+Q11+R11)","v":41400},null,{"$f":"IF(F11=\"\",\"\",F11*H11)","v":400},{"$f":"IF(H11=\"\",\"\",H11*20)","v":8000},{"$f":"IF(H11=\"\",\"\",H11/100*5*P11)","v":28000}]
[{"$f":"IF('BİLGİ GİRİŞİ'!E13=\"\",\"\",'BİLGİ GİRİŞİ'!E13)","v":""},{"$f":"IF(A12=\"\",\"\",'BİLGİ GİRİŞİ'!E14)","v":""},null,null,null,"",null,{"$f":"IF(A12=\"\",\"\",'BİLGİ GİRİŞİ'!E8)","v":""},null,"",null,null,{"$f":"IF(A12=\"\",\"\",'BİLGİ GİRİŞİ'!E12)","v":""},null,{"$f":"IF(V12=\"\",\"\",ROUND(V12,2))","v":""},null,{"$f":"IF(W12=\"\",\"\",ROUND(W12,2))","v":""},null,{"$f":"IF(A12=\"\",\"\",J12+M12+O12+Q12+R12)","v":""},null,{"$f":"IF(F12=\"\",\"\",F12*H12)","v":""},{"$f":"IF(H12=\"\",\"\",H12*10)","v":""},{"$f":"IF(H12=\"\",\"\",H12/100*5*P12)","v":""}]
[{"$f":"IF('BİLGİ GİRİŞİ'!E15=\"\",\"\",'BİLGİ GİRİŞİ'!E15)","v":""},{"$f":"IF(A13=\"\",\"\",'BİLGİ GİRİŞİ'!E16)","v":""},null,null,null,"",null,{"$f":"IF(A13=\"\",\"\",'BİLGİ GİRİŞİ'!E8)","v":""},null,"",null,null,{"$f":"IF(A13=\"\",\"\",'BİLGİ GİRİŞİ'!E12)","v":""},null,"",null,"",null,"",null,"","",{"$f":"IF(H13=\"\",\"\",H13/100*5*P13)","v":""}]
[{"$f":"IF('BİLGİ GİRİŞİ'!E17=\"\",\"\",'BİLGİ GİRİŞİ'!E17)","v":""},{"$f":"IF(A14=\"\",\"\",'BİLGİ GİRİŞİ'!E18)","v":""},null,null,null,"",null,{"$f":"IF(A14=\"\",\"\",'BİLGİ GİRİŞİ'!E8)","v":""},null,"",null,null,{"$f":"IF(A14=\"\",\"\",'BİLGİ GİRİŞİ'!E12)","v":""},null,"",null,"",null,"",null,"","",""]
[{"$f":"IF('BİLGİ GİRİŞİ'!E19=\"\",\"\",'BİLGİ GİRİŞİ'!E19)","v":""},{"$f":"IF(A15=\"\",\"\",'BİLGİ GİRİŞİ'!E20)","v":""},null,null,null,"",null,{"$f":"IF(A15=\"\",\"\",'BİLGİ GİRİŞİ'!E8)","v":""},null,{"$f":"IF(U15=\"\",\"\",ROUND(U15,2))","v":""},null,null,{"$f":"IF(A15=\"\",\"\",'BİLGİ GİRİŞİ'!E12)","v":""},null,"",null,"",null,"",null,"","",""]
[{"$f":"IF('BİLGİ GİRİŞİ'!E21=\"\",\"\",'BİLGİ GİRİŞİ'!E21)","v":""},{"$f":"IF(A16=\"\",\"\",'BİLGİ GİRİŞİ'!E22)","v":""},null,null,null,"",null,{"$f":"IF(A16=\"\",\"\",'BİLGİ GİRİŞİ'!E8)","v":""},null,"",null,null,{"$f":"IF(A16=\"\",\"\",'BİLGİ GİRİŞİ'!E12)","v":""},null,"",null,"",null,"",null,"","",""]
[{"$f":"IF('BİLGİ GİRİŞİ'!E23=\"\",\"\",'BİLGİ GİRİŞİ'!E23)","v":""},{"$f":"IF(A17=\"\",\"\",'BİLGİ GİRİŞİ'!E24)","v":""},null,null,null,"",null,{"$f":"IF(A17=\"\",\"\",'BİLGİ GİRİŞİ'!E8)","v":""},null,"",null,null,{"$f":"IF(A17=\"\",\"\",'BİLGİ GİRİŞİ'!E12)","v":""},null,"",null,"",null,"",null,"","",""]
[{"$f":"IF('BİLGİ GİRİŞİ'!E25=\"\",\"\",'BİLGİ GİRİŞİ'!E25)","v":""},{"$f":"IF(A18=\"\",\"\",'BİLGİ GİRİŞİ'!E25)","v":""},null,null,null,"",null,{"$f":"IF(A18=\"\",\"\",H16)","v":""},null,{"$f":"IF(U18=\"\",\"\",ROUND(U18,2))","v":""},null,null,{"$f":"IF(A18=\"\",\"\",'BİLGİ GİRİŞİ'!E12)","v":""},null,{"$f":"IF(V18=\"\",\"\",ROUND(V18,2))","v":""},null,"",null,"",null,"","",""]
["TOPLAM",null,null,null,null,null,null,null,null,{"$f":"SUM(J11:J18)","v":400},null,null,{"$f":"SUM(M11:M18)","v":5000},null,{"$f":"SUM(O11:O18)","v":8000},null,{"$f":"SUM(Q11:Q18)","v":28000},{"$f":"SUM(R11:R18)","v":0},{"$f":"SUM(S11:S18)","v":41400}]
["GENEL TOPLAM (1+2+3+4+5)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"S19+R19","v":41400},null,null,{"$f":"TEXT(R20,\"#.##0,00\")","v":"41.400,00"}]
[]
["A",null,null,null,null,null,null,"B",null,null,null,null,null,null,null,"A-B"]
["BRÜT TUTAR:",{"$f":"IF(R20=\"\",\"\",R20)","v":41400},null,null,null,null,null,"DAMGA VERGİSİ (0,00759x..):",null,null,null,null,{"$f":"IF(R20=\"\",\"\",R20*0.00759)","v":314.226},null,null,"ÖDENECEK TUTAR",null,{"$f":"IF(R20=\"\",\"\",B23-M23)","v":41085.773999999998}]
[]
[{"$f":"CONCATENATE(    \"       Görev yaptığı yer \", ('BİLGİ GİRİŞİ'!E9),\" iken atandığı yer \",'BİLGİ GİRİŞİ'!E10,\" olan,  \",'BİLGİ GİRİŞİ'!E5,\"   ve aile fertlerine ait  \",U20,\"  (\",O35,\") yurtiçi sürekli görev yolluğu  tahakkuk ettiğini gösterir bildirimdir.  \",U25,\" \")","v":"       Görev yaptığı yer MUŞ-BULANIK Atatürk İlkokulu iken atandığı yer İZMİR-KONAK Necatibey İlkokulu olan,  Sedat ATAM   ve aile fertlerine ait  41.400,00  (Kırkbirbindörtyüz Lira) yurtiçi sürekli görev yolluğu  tahakkuk ettiğini gösterir bildirimdir.  20.01.2023 "},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"TEXT(('BİLGİ GİRİŞİ'!E28),\"gg.aa.yyyy\")","v":"20.01.2023"}]
[]
[]
["BİLDİRİM YETKİLİSİ",null,null,null,null,null,null,null,null,null,"BİLDİRİM SAHİBİ"]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"C2","v":"Sedat ATAM"}]
[{"$f":"'BİLGİ GİRİŞİ'!K25","v":"Metin ARAL"},null,null,null,null,null,null,null,null,null,"İMZA"]
[{"$f":"'BİLGİ GİRİŞİ'!K26","v":"Şube Müdürü"}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"yaziyla(R20)","v":"Kırkbirbindörtyüz Lira"}]

{"sheet":"FAİZ","index":2,"n_rows":43,"n_cols":3,"rows_kept":43,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[null,"FAİZ HESAPLAMA"]
[]
[]
[]
[null,{"$f":"A42&\" X\"&\" \"&B30&\" =\"&A43&\" X\"&\" \"&C30&\" =\"&\" \"&B43&\" /\"&\" \"&1200&\" \"&\"=\"&\" \"&C43&\"YTL\"","v":"41.400,00 X 0 =0,00 X 9 = 0,00 / 1200 = 0,00YTL"}]
[]
[]
[]
[null,"ONAYLAYAN"]
[null,{"$f":"\"....\"&\" \"&\"/\"&\" \"&B28&\" \"&\"/\"&B26&\"\"","v":".... / 06 /2024"}]
[]
[null,{"$f":"'BİLGİ GİRİŞİ'!K25","v":"Metin ARAL"}]
[null,{"$f":"'BİLGİ GİRİŞİ'!K26","v":"Şube Müdürü"}]
[]
[]
[]
[]
[]
[null,{"$f":"TODAY()","v":"2024-06-13"}]
[null,{"$f":"YEAR(B25)","v":2024}]
[null,{"$f":"MONTH(B25)","v":6}]
[null,{"$f":"IF(B27<10,\"0\"&B27,B27)","v":"06"}]
[]
[{"$f":"BORDRO!S19","v":41400},{"$f":"'BİLGİ GİRİŞİ'!J7","v":0},{"$f":"'BİLGİ GİRİŞİ'!J8","v":9}]
[{"$f":"A30*B30","v":0},{"$f":"A31*C30","v":0},{"$f":"B31/1200","v":0}]
[]
[{"$f":"INT(A30)","v":41400},{"$f":"INT(B30)","v":0},{"$f":"INT(C30)","v":9}]
[{"$f":"A30-A33","v":0},{"$f":"B30-B33","v":0},{"$f":"C30-C33","v":0}]
[{"$f":"A34*100","v":0},{"$f":"B34*100","v":0},{"$f":"C34*100","v":0}]
[]
[]
[]
[]
[]
[]
[{"$f":"FIXED(A30)","v":"41.400,00"}]
[{"$f":"FIXED(A31)","v":"0,00"},{"$f":"FIXED(B31)","v":"0,00"},{"$f":"FIXED(C31)","v":"0,00"}]