{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Anasayfa","Parametreler Yolluk","Yolluk","Parametreler Personel Nakil Bil","Personel Nakil Bildirimi","Nakit","metem","LİSE"],"not_rendered":{"charts":0,"images":9,"macros":1,"external_links":1,"defined_names":44,"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":"Anasayfa","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Parametreler Yolluk","index":1,"n_rows":25,"n_cols":34,"rows_kept":25,"cut":false,"hidden":false,"merged":[[18,8,18,9],[2,2,2,9],[9,2,10,2],[16,8,16,9],[17,8,17,9],[4,6,4,7],[13,2,14,2],[13,4,14,4],[3,8,3,9],[23,6,24,6],[23,8,24,9],[19,8,19,9],[20,8,20,9],[21,8,21,9],[22,8,22,9]]}
[]
[2,0]
[null,null,"S Ü R E K L İ    G Ö R E V    Y O L L U Ğ U"]
[null,null,null,null,null,null,null,null,"Lütfen sıra atlamadan yazınız.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Babası"]
[null,null,"Adı Soyadı",null,"İhsan HOMAN",null,"Personel Yakınları",null,"Adı Soyadı","Yakınlık Der.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Eşi"]
[null,null,"Unvanı",null,"Öğretmen",null,"1.Kişi",null,"abc","Kızı",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Oğlu"]
[null,null,"Kadro/Derece",null,"1/1-3000",null,"2.Kişi",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Kızı"]
[null,null,"T.C. NO:",null,12345678910,null,"3.Kişi","ŞEMA N",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Annesi"]
[null,null,null,null,null,null,"4.Kişi",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Diğer"]
[null,null,"Eşi memur olup yolluk almış mı?",null,2.5000000000000001E-2,null,"5.Kişi"]
[null,null,null,null,null,null,"6.Kişi"]
[null,null,null,null,0.05,null,"7.Kişi"]
[null,null,"Dairesi",null,"Artuklu İlçe Millî Eğitim Müdürlüğü",null,"8.Kişi"]
[null,null,"Kurumu",null,"Abdulkadir Tutaşı İlkokulu",null,"9.Kişi"]
[null,null,null,null,null,null,"10.Kişi"]
[null,null,"Gerçekleştirme Görevlisi",null,"İhsan HOMAN"]
[null,null,"Görevi",null,"Okul Müdürü",null,"Gün sayısı",null,1]
[null,null,"Harcama Yetkilisi",null,"Boş bırakılabilir.",null,"Gündeliği",null,39.75]
[null,null,"Görevi",null,"Boş bırakılabilir.","Boş bırakılabilir.","Taşıt ücreti",null,10]
[null,null,"Muhasebe Yetkilisi",null,"Boş bırakılabilir.","Boş bırakılabilir.","Eski görev yeri",null,"Mardin-Artuklu"]
["TVİN",null,"Görevi",null,"Boş bırakılabilir.","Boş bırakılabilir.","Yeni atandığı yer",null,"Mardin-Yeşilli"]
[null,null,"Muhasebe Birimi Adı",null,"Boş bırakılabilir.","Boş bırakılabilir.","Mesafe (Km)",null,10]
[null,null,"Banka hesap no",null,"Boş bırakılabilir.","Boş bırakılabilir.","Atama tarihi",null,"2018-12-31"]
[null,null,"Banka şubesi",null,"Boş bırakılabilir.","Boş bırakılabilir.","Önceden Avans Almışsa\nAldığı Saymanlık ve Tarihi",null,"YOK"]
[null,null,"Bütçe Yılı",null,2019]

{"sheet":"Yolluk","index":2,"n_rows":35,"n_cols":20,"rows_kept":35,"cut":false,"hidden":false,"merged":[[25,14,25,15],[2,14,2,15],[4,14,4,15],[6,14,6,15],[5,14,5,15],[11,14,11,15],[2,7,6,12],[3,14,3,15],[27,14,27,15],[8,12,8,13],[7,11,7,13],[9,12,10,12],[7,10,9,10],[26,4,26,15],[24,3,24,4],[7,7,8,9],[9,8,10,8],[9,7,10,7],[9,14,10,15],[7,14,8,15],[7,6,10,6],[7,5,10,5],[7,3,10,4],[30,10,30,11],[31,10,31,11],[32,10,32,11],[12,3,12,4],[14,3,14,4],[13,3,13,4],[19,3,19,4],[20,3,20,4],[21,3,21,4],[22,3,22,4],[15,3,15,4],[16,3,16,4],[25,3,25,6],[33,10,33,11],[29,10,29,11],[2,3,2,4],[4,3,4,4],[5,3,5,4],[6,3,6,4],[4,5,4,6],[5,5,5,6],[6,5,6,6],[2,5,2,6],[3,3,3,4],[3,5,3,6],[17,3,17,4],[18,3,18,4],[23,3,23,4],[11,3,11,4]]}
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"T2*T3","v":19.875},{"$f":"IF('Parametreler Yolluk'!A2=2,F7*0.05,F7*0.025)","v":1.9875}]
[null,null,null,"Adı ve Soyadı",null,{"$f":"memur","v":"İhsan HOMAN"},null,"YURT İÇİ  SÜREKLİ  GÖREV \nYOLLUĞU  BİLDİRİMİ",null,null,null,null,null,"Dairesi",{"$f":"'Parametreler Yolluk'!$E$13","v":"Artuklu İlçe Millî Eğitim Müdürlüğü"},null,null,null,null,{"$f":"'Parametreler Yolluk'!I22","v":10}]
[null,null,null,"T.C. Kimlik No",null,{"$f":"'Parametreler Yolluk'!$E$8","v":12345678910},null,null,null,null,null,null,null,"Kurumu",{"$f":"'Parametreler Yolluk'!$E$14","v":"Abdulkadir Tutaşı İlkokulu"}]
[null,null,null,"Unvanı",null,{"$f":"unvan","v":"Öğretmen"},null,null,null,null,null,null,null,"Bütçe Yılı",{"$f":"'Parametreler Yolluk'!$E$25","v":2019}]
[null,null,null,"Aylık Kadro Derecesi ve Ek Göstergesi",null,{"$f":"derece","v":"1/1-3000"},null,null,null,null,null,null,null,"Önceden Avans Almışsa\nAldığı Saymanlık ve Tarihi",{"$f":"'Parametreler Yolluk'!I24","v":"YOK"}]
[null,null,null,"Gündeliği",null,{"$f":"yevmiye","v":39.75},null,null,null,null,null,null,null,"Atama Tarihi",{"$f":"'Parametreler Yolluk'!$I$23","v":"2018-12-31"}]
[null,null,null,"Nerden Nereye \nGidildiği",null,"Adı  Soyadı","Akrabalık Derecesi","G Ü N D E L İ K L E R",null,null,"Taşıt Ücreti","YER  DEĞİŞTİRME  GİDERİ",null,null,"T O P L A M"]
[null,null,null,null,null,null,null,null,null,null,null,"Sabit Unsur","Değişken Unsur"]
[null,null,null,null,null,null,null,"Gün Sayısı","Yevmiye","TUTARI",null,"TL","Mesfe Km/Mil","Tutarı","1 + 2 + 3 + 4"]
[null,null,null,null,null,null,null,null,null,1,2,3,null,4]
[null,null,null,{"$f":"IF(F12=\"\",\"\",'Parametreler Yolluk'!$I$20&\" - \"&'Parametreler Yolluk'!$I$21)","v":"Mardin-Artuklu - Mardin-Yeşilli"},null,{"$f":"IF(memur=\"\",\"\",'Parametreler Yolluk'!E5)","v":"İhsan HOMAN"},{"$f":"IF(F12=\"\",0,\"Kendisi\")","v":"Kendisi"},{"$f":"IF(F12=\"\",0,'Parametreler Yolluk'!$I$17)","v":1},{"$f":"IF(F12=\"\",0,$F$7)","v":39.75},{"$f":"IF(F12=\"\",0,H12*I12)","v":39.75},{"$f":"IF(F12=\"\",0,'Parametreler Yolluk'!$I$19)","v":10},{"$f":"IF(F12=\"\",0,I12*S12)","v":795},{"$f":"IF(F12=\"\",\"\",$T$3&\" * \"&$T$2)","v":"10 * 1,9875"},{"$f":"IF(F12=\"\",0,S2)","v":19.875},{"$f":"IF(L12=\"-\",J12+K12+N12,J12+K12+L12+N12)","v":864.625},null,null,null,{"$f":"IF(F12=\"\",\"\",20)","v":20}]
[null,null,null,{"$f":"IF(F13=\"\",\"\",'Parametreler Yolluk'!$I$20&\" - \"&'Parametreler Yolluk'!$I$21)","v":"Mardin-Artuklu - Mardin-Yeşilli"},null,{"$f":"IF('Parametreler Yolluk'!I6=\"\",\"\",'Parametreler Yolluk'!I6)","v":"abc"},{"$f":"IF(F13=\"\",0,'Parametreler Yolluk'!J6)","v":"Kızı"},{"$f":"IF(F13=\"\",0,'Parametreler Yolluk'!$I$17)","v":1},{"$f":"IF(F13=\"\",0,$F$7)","v":39.75},{"$f":"IF(F13=\"\",0,H13*I13)","v":39.75},{"$f":"IF(F13=\"\",0,'Parametreler Yolluk'!$I$19)","v":10},{"$f":"IF(F13=\"\",0,IF(S12>=60,0,I13*S13))","v":397.5},null,null,{"$f":"IF(L13=\"-\",J13+K13+N13,J13+K13+L13+N13)","v":447.25},null,null,null,{"$f":"IF(F13=\"\",\"\",10)","v":10}]
[null,null,null,{"$f":"IF(F14=\"\",\"\",'Parametreler Yolluk'!$I$20&\" - \"&'Parametreler Yolluk'!$I$21)","v":""},null,{"$f":"IF('Parametreler Yolluk'!I7=\"\",\"\",'Parametreler Yolluk'!I7)","v":""},{"$f":"IF(F14=\"\",0,'Parametreler Yolluk'!J7)","v":0},{"$f":"IF(F14=\"\",0,'Parametreler Yolluk'!$I$17)","v":0},0,0,{"$f":"IF(F14=\"\",0,'Parametreler Yolluk'!$I$19)","v":0},{"$f":"IF(F14=\"\",0,IF((S12+S13)>=60,0,I14*S14))","v":0},null,null,0,null,null,null,""]
[null,null,null,{"$f":"IF(F15=\"\",\"\",'Parametreler Yolluk'!$I$20&\" - \"&'Parametreler Yolluk'!$I$21)","v":""},null,{"$f":"IF('Parametreler Yolluk'!I8=\"\",\"\",'Parametreler Yolluk'!I8)","v":""},{"$f":"IF(F15=\"\",0,'Parametreler Yolluk'!J8)","v":0},{"$f":"IF(F15=\"\",0,'Parametreler Yolluk'!$I$17)","v":0},0,0,{"$f":"IF(F15=\"\",0,'Parametreler Yolluk'!$I$19)","v":0},{"$f":"IF(F15=\"\",0,IF((S12+S13+S14)>=60,0,I15*S15))","v":0},null,null,0,null,null,null,""]
[null,null,null,{"$f":"IF(F16=\"\",\"\",'Parametreler Yolluk'!$I$20&\" - \"&'Parametreler Yolluk'!$I$21)","v":""},null,{"$f":"IF('Parametreler Yolluk'!I9=\"\",\"\",'Parametreler Yolluk'!I9)","v":""},{"$f":"IF(F16=\"\",0,'Parametreler Yolluk'!J9)","v":0},{"$f":"IF(F16=\"\",0,'Parametreler Yolluk'!$I$17)","v":0},0,0,{"$f":"IF(F16=\"\",0,'Parametreler Yolluk'!$I$19)","v":0},{"$f":"IF(F16=\"\",0,IF((S12+S13+S14+S15)>=60,0,I16*S16))","v":0},null,null,0,null,null,null,""]
[null,null,null,{"$f":"IF(F17=\"\",\"\",'Parametreler Yolluk'!$I$20&\" - \"&'Parametreler Yolluk'!$I$21)","v":""},null,{"$f":"IF('Parametreler Yolluk'!I10=\"\",\"\",'Parametreler Yolluk'!I10)","v":""},{"$f":"IF(F17=\"\",0,'Parametreler Yolluk'!J10)","v":0},{"$f":"IF(F17=\"\",0,'Parametreler Yolluk'!$I$17)","v":0},0,0,{"$f":"IF(F17=\"\",0,'Parametreler Yolluk'!$I$19)","v":0},{"$f":"IF(F17=\"\",0,IF((S12+S13+S14+S15+S16)>=60,\"-\",I17*S17))","v":0},null,null,0,null,null,null,""]
[null,null,null,{"$f":"IF(F18=\"\",\"\",'Parametreler Yolluk'!$I$20&\" - \"&'Parametreler Yolluk'!$I$21)","v":""},null,{"$f":"IF('Parametreler Yolluk'!I11=\"\",\"\",'Parametreler Yolluk'!I11)","v":""},{"$f":"IF(F18=\"\",0,'Parametreler Yolluk'!J11)","v":0},{"$f":"IF(F18=\"\",0,'Parametreler Yolluk'!$I$17)","v":0},0,0,{"$f":"IF(F18=\"\",0,'Parametreler Yolluk'!$I$19)","v":0},{"$f":"IF(F18=\"\",0,IF((S12+S13+S14+S15+S16+S17)>=60,\"-\",I18*S18))","v":0},null,null,0,null,null,null,""]
[null,null,null,{"$f":"IF(F19=\"\",\"\",'Parametreler Yolluk'!$I$20&\" - \"&'Parametreler Yolluk'!$I$21)","v":""},null,{"$f":"IF('Parametreler Yolluk'!I12=\"\",\"\",'Parametreler Yolluk'!I12)","v":""},{"$f":"IF(F19=\"\",0,'Parametreler Yolluk'!J12)","v":0},{"$f":"IF(F19=\"\",0,'Parametreler Yolluk'!$I$17)","v":0},{"$f":"IF(F19=\"\",0,$F$7)","v":0},{"$f":"IF(F19=\"\",0,H19*I19)","v":0},{"$f":"IF(F19=\"\",0,'Parametreler Yolluk'!$I$19)","v":0},null,null,null,null,null,null,null,""]
[null,null,null,{"$f":"IF(F20=\"\",\"\",'Parametreler Yolluk'!$I$20&\" - \"&'Parametreler Yolluk'!$I$21)","v":""},null,{"$f":"IF('Parametreler Yolluk'!I13=\"\",\"\",'Parametreler Yolluk'!I13)","v":""},{"$f":"IF(F20=\"\",0,'Parametreler Yolluk'!J13)","v":0},{"$f":"IF(F20=\"\",0,'Parametreler Yolluk'!$I$17)","v":0},{"$f":"IF(F20=\"\",0,$F$7)","v":0},{"$f":"IF(F20=\"\",0,H20*I20)","v":0},{"$f":"IF(F20=\"\",0,'Parametreler Yolluk'!$I$19)","v":0},{"$f":"IF(F20=\"\",0,IF((S12+S13+S14+S15+S16+S17+S18+S19)>=60,\"-\",I20*S20))","v":0},null,null,0,null,null,null,""]
[null,null,null,{"$f":"IF(F21=\"\",\"\",'Parametreler Yolluk'!$I$20&\" - \"&'Parametreler Yolluk'!$I$21)","v":""},null,{"$f":"IF('Parametreler Yolluk'!I14=\"\",\"\",'Parametreler Yolluk'!I14)","v":""},{"$f":"IF(F21=\"\",0,'Parametreler Yolluk'!J14)","v":0},{"$f":"IF(F21=\"\",0,'Parametreler Yolluk'!$I$17)","v":0},{"$f":"IF(F21=\"\",0,$F$7)","v":0},{"$f":"IF(F21=\"\",0,H21*I21)","v":0},{"$f":"IF(F21=\"\",0,'Parametreler Yolluk'!$I$19)","v":0},{"$f":"IF(F21=\"\",0,IF((S12+S13+S14+S15+S16+S17+S18+S19+S20)>=60,\"-\",I21*S21))","v":0},null,null,null,null,null,null,""]
[]
[]
[]
[]
[null,null,null," G E N E L   T O P L A M",null,null,null,{"$f":"SUM(H12:H25)","v":2},{"$f":"SUM(I12:I25)","v":79.5},{"$f":"SUM(J12:J25)","v":79.5},{"$f":"SUM(K12:K25)","v":20},{"$f":"SUM(L12:L25)","v":1192.5},{"$f":"M12","v":"10 * 1,9875"},{"$f":"N12","v":19.875},{"$f":"SUM(O12:O25)","v":1311.875}]
[null,null,null,null,{"$f":"\"         \"&'Parametreler Yolluk'!I20&\" 'dan \"&'Parametreler Yolluk'!I21&\" 'ya atanan\"&\" \"&$F$3&\" \"&\" ve aile fertlerine ait yurtiçi sürekli görev yolluğu\"","v":"         Mardin-Artuklu 'dan Mardin-Yeşilli 'ya atanan İhsan HOMAN  ve aile fertlerine ait yurtiçi sürekli görev yolluğu"}]
[null,null,null,null,{"$f":"\"olarak tahakkuk eden \"&UPPER([1]!YaziyaCevir(O26))&\" gösterir bildirimdir.\"","v":"olarak tahakkuk eden BİNÜÇYÜZONBİR LİRA SEKSENSEKİZ KURUŞTUR gösterir bildirimdir."},null,null,null,null,null,null,null,null,null,{"$f":"TODAY()","v":"2019-07-01"}]
[]
[null,null,null,null,null,null,null,null,null,null,"Birim Yetkilisi (1)"]
[]
[null,null,null,null,null,null,null,null,null,"Adı ve Soyadı:",{"$f":"'Parametreler Yolluk'!E16","v":"İhsan HOMAN"}]
[null,null,null,null,null,null,null,null,null,"Ünvanı:",{"$f":"'Parametreler Yolluk'!E17","v":"Okul Müdürü"}]
[null,null,null,null,"(1)  Bu kısım bildirim sahibinin atama işleminden",null,null,null,null,"İmzası:","......................"]
[null,null,null,null,"     bilgisi olan amir tarafından imzalanacaktır."]

{"sheet":"Parametreler Personel Nakil Bil","index":3,"n_rows":28,"n_cols":8,"rows_kept":28,"cut":false,"hidden":false,"merged":[[16,5,22,6],[16,7,22,7],[17,0,18,1],[19,0,19,1],[19,2,19,3],[20,0,20,1],[20,2,20,3],[21,0,21,1],[21,2,21,3],[22,0,22,1],[22,2,22,3],[16,0,16,1],[16,2,16,3],[13,0,13,1],[13,2,13,3],[14,0,14,1],[14,2,14,3],[15,0,15,1],[15,2,15,3],[11,0,11,1],[11,2,11,3],[12,5,12,6],[12,0,12,1],[12,2,12,3],[11,5,11,6],[9,0,9,1],[9,2,9,3],[9,5,9,6],[10,0,10,1],[10,2,10,3],[10,5,10,6],[6,0,7,1],[6,5,6,6],[7,5,7,6],[8,0,8,1],[8,2,8,3],[8,5,8,6],[3,0,3,1],[3,2,3,3],[3,5,3,6],[4,0,5,1],[4,5,4,6],[5,5,5,6],[0,0,0,7],[1,0,1,1],[1,2,1,3],[1,5,1,6],[2,0,2,1],[2,2,2,3],[2,5,2,6]]}
["PERSONEL NAKİL BİLDİRİMİ"]
["Adı Soyadı:            ",null,"İhsan HOMAN",null,null,"Şahsi ve Aile Yolluğunu Alıp Almadığı, Almışsa Tutarı: (Tutar otomatik yazılacaktır.)",null,{"$f":"Yolluk!$O$26","v":1311.875}]
["Saymanlık Sistem No:",null,1234567,null,null,"15 Gün İçinde Hareket Etmediği Takdirde Gecikme Nedeni:",null,"HAREKET EDİLMESİ TEBLİĞ EDİLMİŞTİR."]
["Sendika Adı:",null,"FREE-SEN",null,null,"Eğitime Hazırlık Ödeneği Aldı mı?",null,"2018-2019 EĞİTİM-ÖĞRETİM YILI İÇİN ALMIŞTIR."]
["Derece ve Kademesi:",null,"Eski","Yeni",null,"Almış Olduğu Sağlık Raporlarının Yıl İçindeki Toplam Süresi (Heyet Raporu Hariç):",null,"YOK"]
[null,null,"4/2","4/3",null,"Promosyon Bilgisi:",null,"2018-2019-2020 YILLARI İÇİN ALMIŞTIR."]
["Görev Ünvanı:",null,"Eski","Yeni",null,"Borçlu İse Borçlarına Ait Bilgiler:",null,"BİLİNEN BORCU YOKTUR."]
[null,null,"ÖĞRETMEN","ÖĞRETMEN",null,"Süregelen Gelir Vergisi Matrahı Toplamı:",null,1795.77]
["Eski Görev Yeri:                        ",null,"MARDİN-ARTUKLU-ABDULKADİR TUTAŞI İLKOKULU",null,null,"Yabancı Dil Tazminatından Yararlanıp Yararlanmadığı Yararlanıyorsa Grubu:",null,"YARARLANMIYOR."]
["Yeni Görev Yeri:",null,"MARDİN-NUSAYBİN-SÜLEYMAN BÖLÜNMEZ ANADOLU LİSESİ",null,null,"Medeni Durumu:",null,"EVLİ"]
["T.C. Kimlik No:",null,12345678910,null,null,"Lojman Tazminatından Yararlanıp Yararlanmadığı:",null,"YARARLANMIYOR."]
["Emekli Sicil No:",null,123456789,null,null,"Diğer Bilgiler:",null,"Personelin diğer bilgileri Say 2000i maaş otomasyon sisteminde kayıtlıdır."]
["Atama Tarihi:",null,"2019-01-21",null,null,"Açıklama:"]
["Atama Sayısı:",null,1393331,null,null,null,"Adı Soyadı"]
["Tebliğ Tarihi:",null,"2019-01-30",null,null,"Düzenleyen","İhsan HOMAN","Okul Müdürü"]
["Öğrenim Durumu:",null,"LİSANS",null,null,"İl-İlçe Adı","MARDİN","ARTUKLU"]
["Ulaşılabilecek Tel. No:",null,5415051234,null,null,"NOT 1: Değerli Yönetici Arkadaşım; Personel nakil bildirimi \"Parametreler\" ve \"Personel Nakil Bildirimi\" olmak üzere 2 sayfadan oluşmaktadır. Bir Personel nakil bildiriminde olması gereken tüm Parametreler mevcuttur. Yapmanız gereken sadece Yeşil alanları doldurmanızdır. Tüm alanları doldurduktan sonra \"Personel Nakil Bildirimi\" sayfasında yer alan formun çıktısını almaktır. Bir eksiklik/yanlışlık söz konusu ise lütfen ihsanhmn@gmail.com adresine bildirmeniz yeterli olacaktır. Faydalı olması dileğiyle kolaylıklar diliyorum.",null,"NOT 2: Sadece yeşil renkli alanlara veri girişi yapınız."]
["Kullanılan İzin Durumları: ",null,"Yıllık İzin","Mazeret İzni"]
[null,null,"…","…"]
["Göreve İlk Başlama Tarihi:",null,"2010-12-10"]
["Eski Memuriyetten Ayrılış Tarihi:",null,"2019-01-30"]
["Kıdem Aylığa Esas Hizmet Süresi:",null,"8 Yıl 1 Ay 20 Gun"]
["Yeni Görev Yerinde Aylığa \nHak Kazandığı Tarih: \n",null,"15.02.2019 MAAŞINA MÜSTAHAKTIR."]
[null,null,null,null,null,null,"Gerçekleştirme Görevlisi-Şube Müdürü","Abdurrahim TURGUT"]
[null,null,null,null,null,null,"Harcama Yetkilisi-İlçe Milli Eğitim Müdürü","Şehmus SÜMER"]
[null,null,null,null,null,null,"Muhasebe Yetkilisi-Mal Müdürü"]
[]
[null,null,null,null,null,null,"iletişim","ihsanhmn@gmail.com"]

{"sheet":"Personel Nakil Bildirimi","index":4,"n_rows":33,"n_cols":6,"rows_kept":33,"cut":false,"hidden":false,"merged":[[32,2,32,3],[27,0,27,1],[27,2,27,5],[28,0,28,5],[29,2,29,3],[30,2,30,3],[31,2,31,3],[24,0,24,1],[24,2,24,5],[25,0,25,1],[25,2,25,5],[26,0,26,1],[26,2,26,5],[21,0,21,1],[21,2,21,5],[22,0,22,1],[22,2,22,5],[23,0,23,1],[23,2,23,5],[18,0,18,1],[18,2,18,5],[19,0,19,1],[19,2,19,5],[20,0,20,1],[20,2,20,5],[17,0,17,1],[11,0,11,1],[11,2,11,3],[12,0,12,1],[12,2,12,3],[13,0,13,1],[13,2,13,5],[14,0,14,1],[15,0,15,1],[15,2,15,3],[16,0,16,1],[16,2,16,3],[17,2,17,3],[17,4,17,5],[7,0,7,1],[8,0,8,1],[9,0,9,1],[9,2,9,5],[10,0,10,1],[10,2,10,5],[0,0,0,5],[1,0,1,5],[2,0,2,5],[6,0,6,1],[6,2,6,3],[3,0,3,5],[4,0,4,1],[4,2,4,5],[5,0,5,1],[5,2,5,3]]}
["T.C."]
["MİLLÎ EĞİTİM BAKANLIĞI"]
[{"$f":"'Parametreler Personel Nakil Bil'!G16&\"-\"&'Parametreler Personel Nakil Bil'!H16&\" \"&\"İLÇE MİLLÎ EĞİTİM MÜDÜRLÜĞÜ\"","v":"MARDİN-ARTUKLU İLÇE MİLLÎ EĞİTİM MÜDÜRLÜĞÜ"}]
["PERSONEL NAKİL BİLDİRİMİ"]
["Adı Soyadı:            ",null,{"$f":"'Parametreler Personel Nakil Bil'!$C$2","v":"İhsan HOMAN"}]
["Saymanlık Sistem No:",null,{"$f":"'Parametreler Personel Nakil Bil'!$C$3","v":1234567},null,"T.C. Kimlik No:",{"$f":"'Parametreler Personel Nakil Bil'!$C$11","v":12345678910}]
["Sendika Adı:",null,{"$f":"'Parametreler Personel Nakil Bil'!$C$4","v":"FREE-SEN"},null,"Emekli Sicil No:",{"$f":"'Parametreler Personel Nakil Bil'!$C$12","v":123456789}]
["Derece ve Kademesi:",null,"Eski:",{"$f":"'Parametreler Personel Nakil Bil'!$C$6","v":"4/2"},"Yeni:",{"$f":"'Parametreler Personel Nakil Bil'!$D$6","v":"4/3"}]
["Görev Ünvanı:",null,"Eski:",{"$f":"'Parametreler Personel Nakil Bil'!$C$8","v":"ÖĞRETMEN"},"Yeni:",{"$f":"'Parametreler Personel Nakil Bil'!$D$8","v":"ÖĞRETMEN"}]
["Eski Görev Yeri:                        ",null,{"$f":"'Parametreler Personel Nakil Bil'!$C$9","v":"MARDİN-ARTUKLU-ABDULKADİR TUTAŞI İLKOKULU"}]
["Yeni Görev Yeri:",null,{"$f":"'Parametreler Personel Nakil Bil'!$C$10","v":"MARDİN-NUSAYBİN-SÜLEYMAN BÖLÜNMEZ ANADOLU LİSESİ"}]
["Atama Tarihi:",null,{"$f":"'Parametreler Personel Nakil Bil'!$C$13","v":"2019-01-21"},null,"Tebliğ Tarihi:",{"$f":"'Parametreler Personel Nakil Bil'!$C$15","v":"2019-01-30"}]
["Atama Sayısı:",null,{"$f":"'Parametreler Personel Nakil Bil'!$C$14","v":1393331},null,"Öğrenim Durumu:",{"$f":"'Parametreler Personel Nakil Bil'!$C$16","v":"LİSANS"}]
["Ulaşılabilecek Tel. No:",null,{"$f":"'Parametreler Personel Nakil Bil'!$C$17","v":5415051234}]
["Kullanılan İzin Durumları: ",null,"Yıllık İzin",{"$f":"'Parametreler Personel Nakil Bil'!$C$19","v":"…"},"Mazeret İzni:",{"$f":"'Parametreler Personel Nakil Bil'!$D$19","v":"…"}]
["Göreve İlk Başlama Tarihi:",null,{"$f":"'Parametreler Personel Nakil Bil'!$C$20","v":"2010-12-10"},null,"Kıdem Aylığa Esas Hizmet Süresi:",{"$f":"'Parametreler Personel Nakil Bil'!C22","v":"8 Yıl 1 Ay 20 Gun"}]
["Eski Memuriyetten Ayrılış Tarihi:",null,{"$f":"'Parametreler Personel Nakil Bil'!$C$21","v":"2019-01-30"},null,"Yeni Görev Yerinde Aylığa \nHak Kazandığı Tarih: \n",{"$f":"'Parametreler Personel Nakil Bil'!C23","v":"15.02.2019 MAAŞINA MÜSTAHAKTIR."}]
["Şahsi ve Aile Yolluğunu Alıp Almadığı, Almışsa Tutarı:",null,{"$f":"'Parametreler Personel Nakil Bil'!$H$2","v":1311.875},null,{"$f":"UPPER([1]!YaziyaCevir(C18))","v":"BİNÜÇYÜZONBİR LİRA SEKSENSEKİZ KURUŞTUR"}]
["15 Gün İçinde Hareket Etmediği Takdirde Gecikme Nedeni:",null,{"$f":"'Parametreler Personel Nakil Bil'!$H$3","v":"HAREKET EDİLMESİ TEBLİĞ EDİLMİŞTİR."}]
["Eğitime Hazırlık Ödeneği Aldı mı?",null,{"$f":"'Parametreler Personel Nakil Bil'!$H$4","v":"2018-2019 EĞİTİM-ÖĞRETİM YILI İÇİN ALMIŞTIR."}]
["Almış Olduğu Sağlık Raporlarının Yıl İçindeki Toplam Süresi (Heyet Raporu Hariç):",null,{"$f":"'Parametreler Personel Nakil Bil'!$H$5","v":"YOK"}]
["Promosyon Bilgisi:",null,{"$f":"'Parametreler Personel Nakil Bil'!$H$6","v":"2018-2019-2020 YILLARI İÇİN ALMIŞTIR."}]
["Borçlu İse Borçlarına Ait Bilgiler:",null,{"$f":"'Parametreler Personel Nakil Bil'!$H$7","v":"BİLİNEN BORCU YOKTUR."}]
["Süregelen Gelir Vergisi Matrahı Toplamı:",null,{"$f":"'Parametreler Personel Nakil Bil'!$H$8","v":1795.77}]
["Yabancı Dil Tazminatından Yararlanıp Yararlanmadığı Yararlanıyorsa Grubu:",null,{"$f":"'Parametreler Personel Nakil Bil'!$H$9","v":"YARARLANMIYOR."}]
["Medeni Durumu:",null,{"$f":"'Parametreler Personel Nakil Bil'!$H$10","v":"EVLİ"}]
["Lojman Tazminatından Yararlanıp Yararlanmadığı:",null,{"$f":"'Parametreler Personel Nakil Bil'!$H$11","v":"YARARLANMIYOR."}]
["Açıklama:",null,{"$f":"'Parametreler Personel Nakil Bil'!$H$12","v":"Personelin diğer bilgileri Say 2000i maaş otomasyon sisteminde kayıtlıdır."}]
[]
["İmzası"]
[null,"Düzenleyen","Gerçekleştirme Görevlisi",null,"Harcama Yetkilisi","Muhasebe Yetkilisi"]
["Adı Soyadı",{"$f":"'Parametreler Personel Nakil Bil'!$G$15","v":"İhsan HOMAN"},{"$f":"'Parametreler Personel Nakil Bil'!H24","v":"Abdurrahim TURGUT"},null,{"$f":"'Parametreler Personel Nakil Bil'!H25","v":"Şehmus SÜMER"},{"$f":"'Parametreler Personel Nakil Bil'!H26","v":0}]
["Unvanı",{"$f":"'Parametreler Personel Nakil Bil'!$H$15","v":"Okul Müdürü"},"Şube Müdürü",null,"İlçe Milli Eğitim Müdürü","Mal Müdürü"]

{"sheet":"Nakit","index":5,"n_rows":71,"n_cols":29,"rows_kept":71,"cut":false,"hidden":true,"merged":[[53,2,53,6],[54,2,54,6],[56,7,57,9],[48,6,48,8],[46,14,47,17],[8,2,8,5],[22,11,22,12],[9,2,9,5],[35,11,35,12],[23,11,23,12],[24,11,24,12],[48,14,48,16],[49,2,50,5],[48,10,48,12],[49,9,50,9],[49,13,50,13],[49,6,50,8],[45,2,45,11],[8,14,8,18],[55,2,55,17],[26,11,26,12],[27,11,27,12],[22,17,22,18],[21,17,21,18],[4,2,4,5],[5,2,5,5],[6,2,7,5],[5,6,5,13],[6,8,6,9],[4,6,4,13],[7,16,7,18],[7,8,7,9],[7,14,7,15],[6,14,6,15],[5,14,5,15],[67,11,67,19],[65,2,65,10],[66,2,66,10],[66,20,66,23],[67,20,67,23],[66,11,66,19],[11,13,12,16],[67,2,67,10],[61,11,61,19],[62,11,62,19],[61,2,61,10],[62,2,62,10],[63,2,63,10],[64,11,64,19],[25,11,25,12],[64,2,64,10],[42,17,42,18],[46,18,48,21],[49,18,50,21],[15,11,15,12],[20,11,20,12],[21,11,21,12],[16,11,16,12],[13,11,13,12],[8,6,8,13],[19,11,19,12],[9,6,9,13],[46,6,46,9],[47,6,47,9],[46,10,47,13],[32,22,32,23],[35,22,35,23],[29,17,29,18],[30,22,30,23],[34,17,34,18],[34,22,34,23],[47,22,47,23],[37,11,37,12],[38,11,38,12],[39,11,39,12],[38,17,38,18],[38,22,38,23],[37,22,37,23],[37,17,37,18],[39,17,39,18],[46,22,46,23],[31,22,31,23],[32,17,32,18],[70,2,70,20],[35,17,35,18],[36,22,36,23],[30,17,30,18],[33,17,33,18],[31,17,31,18],[36,17,36,18],[45,22,45,23],[39,22,39,23],[42,22,42,23],[30,11,30,12],[31,11,31,12],[34,11,34,12],[40,11,40,12],[49,22,49,23],[50,22,50,23],[61,20,61,23],[52,18,52,23],[65,20,65,23],[65,11,65,19],[63,11,63,19],[49,14,50,16],[49,17,50,17],[49,10,50,12],[63,20,63,23],[41,22,41,23],[36,11,36,12],[32,11,32,12],[33,11,33,12],[40,22,40,23],[44,2,44,23],[42,2,42,15],[46,2,48,5],[58,16,58,17],[53,12,53,17],[54,12,54,17],[56,10,57,13],[58,10,58,13],[57,14,57,15],[57,16,57,17],[56,14,56,17],[53,7,53,11],[54,7,54,11],[56,2,57,6],[58,2,58,6],[58,14,58,15],[58,7,58,9],[52,2,52,17],[40,17,40,18],[29,22,29,23],[29,11,29,12],[41,10,41,15],[13,17,13,18],[33,22,33,23],[28,22,28,23],[27,17,27,18],[25,17,25,18],[27,22,27,23],[24,22,24,23],[24,17,24,18],[23,17,23,18],[41,17,41,18],[26,17,26,18],[23,22,23,23],[26,22,26,23],[25,22,25,23],[28,11,28,12],[14,11,14,12],[18,11,18,12],[17,11,17,12],[20,17,20,18],[21,22,21,23],[22,22,22,23],[28,17,28,18],[2,2,2,23],[15,17,15,18],[16,17,16,18],[17,17,17,18],[6,10,7,13],[6,20,6,22],[8,20,8,22],[7,20,7,22],[6,16,6,18],[11,2,13,2],[11,3,12,6],[11,7,12,10],[11,11,12,12],[9,14,9,18],[11,17,11,21],[12,20,12,21],[9,20,9,22],[20,22,20,23],[5,20,5,22],[5,16,5,18],[5,19,9,19],[19,22,19,23],[19,17,19,18],[11,22,13,23],[18,22,18,23],[16,22,16,23],[17,22,17,23],[14,17,14,18],[15,22,15,23],[14,22,14,23],[12,17,12,19],[18,17,18,18]]}
["R"]
[]
[null,null,"ÖDEME EMRİ BELGESİ"]
[]
[null,null,"Muhasebe Birimi Kodu",null,null,null,25108]
[null,null,"Muhasebe Birimi Adı",null,null,null,{"$f":"'Parametreler Yolluk'!E22","v":"Boş bırakılabilir."},null,null,null,null,null,null,null,"Bütçe Yılı",null,2012,null,null,"İlgilinin","Adı Soyadı",null,null,{"$f":"memur","v":"İhsan HOMAN"}]
[null,null,"Kurum-Birim Kodu",null,null,null,1,2,"BİRİM",null,"Yevmiyenin",null,null,null,"Tarihi",null,{"$f":"TODAY()","v":"2019-07-01"},null,null,null,"T.C. / Vergi Kimlik No",null,null,{"$f":"vno","v":12345678910}]
[null,null,null,null,null,null,13,62,306,null,null,null,null,null,"No' su",null,null,null,null,null,"Banka Şube Adı",null,null,{"$f":"'Parametreler Yolluk'!E24","v":"Boş bırakılabilir."}]
[null,null,"Kurum Adı",null,null,null,"Milli Eğitim Bakanlığı",null,null,null,null,null,null,null,"PERSONEL SÜREKLİ",null,null,null,null,null,"Banka Hesap Numarası",null,null,{"$f":"'Parametreler Yolluk'!E23","v":"Boş bırakılabilir."}]
[null,null,"Birim Adı",null,null,null,{"$f":"'Parametreler Yolluk'!D13","v":0},null,null,null,null,null,null,null,"GÖREV YOLLUĞU",null,null,null,null,null,"Bağlı Olduğu Vergi Dairesi",null,null,{"$f":"'Parametreler Yolluk'!E22","v":"Boş bırakılabilir."}]
[]
[null,null,"Hesap No","Kurumsal Kod",null,null,null,"Fonksiyonel Kod",null,null,null,"Finans Kodu",null,"Ekonomik / Ayrıntı Kodu",null,null,null,"T U T A R",null,null,null,null,"Hesap / Ayrıntı Adı"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BORÇ",null,null,"ALACAK"]
[null,null,null,1,2,3,4,1,2,3,4,1,null,1,2,3,4,"YTL",null,"YKr","YTL","YKr",null,null,null,null,"BORÇ","ALACAK"]
[null,null,630,13,1,31,62,"09","9","9","05","1",null,"03","3","2","01",{"$f":"IF(AA15=\"\",\"\",INT(AA15))","v":1311},null,{"$f":"IF(AA15=\"\",\"\",(AA15-INT(AA15))*100)","v":87.5},null,null,{"$f":"AC15","v":"  Sürekli Görev Yolluğu"},null,null,null,{"$f":"Yolluk!O26","v":1311.875},null,"  Sürekli Görev Yolluğu"]
[null,null,600,"","","","","","","","",null,null,"01",5,1,"01",null,null,null,{"$f":"R15*8.25/1000","v":10.81575},41,{"$f":"AC16","v":"  Damga Vergisi"},null,null,null,null,{"$f":"ROUND(AA15*0.0075,2)","v":9.84},"  Damga Vergisi"]
[null,null,325,"","","","","","","","",null,null,"2","0","0","0",null,null,null,{"$f":"R15-U16","v":1300.18425},1,"  Verilen Gönderme Emri Hesabı",null,null,null,null,{"$f":"ROUND(AA15-AB16,2)","v":1302.04},"  Verilen Gönderme Emri Hesabı"]
[null,null,"","","","","","","","","",null,null,"","","","",{"$f":"IF(AA18=\"\",\"\",INT(AA18))","v":1311},null,{"$f":"IF(AA18=\"\",\"\",(AA18-INT(AA18))*100)","v":87.5},{"$f":"IF(AB18=\"\",\"\",INT(AB18))","v":1311},{"$f":"IF(AB18=\"\",\"\",(AB18-INT(AB18))*100)","v":87.5}," TAHAKKUK TOPLAMLARI",null,null,null,{"$f":"AA15","v":1311.875},{"$f":"AA15","v":1311.875}," TAHAKKUK TOPLAMLARI"]
[null,null,630,{"$f":"D15","v":13},{"$f":"E15","v":1},31,62,"09","9","9","05",1,null,{"$f":"N15","v":"03"},{"$f":"O15","v":"3"},{"$f":"P15","v":"2"},{"$f":"Q15","v":"01"},{"$f":"IF(AA19=\"\",\"\",INT(AA19))","v":1311},null,{"$f":"IF(AA19=\"\",\"\",(AA19-INT(AA19))*100)","v":87.5},null,null,"  Sürekli Görev Yolluğu",null,null,null,{"$f":"AA15","v":1311.875},null,"  Sürekli Görev Yolluğu"]
[null,null,835,"","","","","","","","",null,null,"","","","",null,null,null,{"$f":"IF(AB20=\"\",\"\",INT(AB20))","v":1311},{"$f":"IF(AB20=\"\",\"\",(AB20-INT(AB20))*100)","v":87.5},"  Gider Yansıtma Hesabı",null,null,null,null,{"$f":"AA15","v":1311.875},"  Gider Yansıtma Hesabı"]
[null,null,805,"","","","","","","","",null,null,null,null,null,null,{"$f":"U16","v":10.81575},null,{"$f":"IF(AA21=\"\",\"\",(AA21-INT(AA21))*100)","v":83.999999999999986},null,null,"  Gelir Yansıtma Hesabı",null,null,null,{"$f":"AB16","v":9.84},null,"  Gelir Yansıtma Hesabı"]
[null,null,600,"","","","","","","","",null,null,{"$f":"N16","v":"01"},{"$f":"O16","v":5},{"$f":"P16","v":1},{"$f":"Q16","v":"01"},null,null,null,{"$f":"U16","v":10.81575},41,"  Damga Vergisi",null,null,null,null,{"$f":"AB16","v":9.84},"  Damga Vergisi"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(AA18:AA23)","v":2633.59},{"$f":"SUM(AB18:AB23)","v":2633.59}," TOPLAM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AA15","v":1311.875},{"$f":"AA15","v":1311.875}," Bütçe Gideri Tahakkuk Toplamı"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"T O P L A M      ",null,null,null,null,null,null,{"$f":"IF(AA24=\"\",\"\",INT(AA24))","v":2633},null,{"$f":"IF(AA24=\"\",\"\",(AA24-INT(AA24))*100)","v":59.000000000014552},{"$f":"IF(AB24=\"\",\"\",INT(AB24))","v":2633},{"$f":"IF(AB24=\"\",\"\",(AB24-INT(AB24))*100)","v":59.000000000014552},{"$f":"IF(AA24<>AB24,\" ! HATA VAR !\",\" \" )","v":" "}]
[null,null,"Bütçe Gideri Tahakkuk Toplamı   ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AA25=\"\",\"\",INT(AA25))","v":1311},null,{"$f":"IF(AA25=\"\",\"\",(AA15-INT(AA25))*100)","v":87.5},{"$f":"IF(AB25=\"\",\"\",INT(AB25))","v":1311},{"$f":"IF(AB25=\"\",\"\",(AB25-INT(AB25))*100)","v":87.5},{"$f":"IF(AA25<>AB25,\" ! HATA VAR !\",\" \" )","v":" "}]
[]
[null,null,{"$f":"\"Yukarıda yazılı # \"&ParaCevir(G50+J50/100)&\"#  Bütçe Gideri tahakkuk ettirilmiştir. Ödenmesi / Mahsubu gerekir.\"","v":{"$error":"#NAME?"}}]
[]
[null,null,"Ödeme Emri Belgesi No",null,null,null,"Bütçe Gideri",null,null,null,"Kesinti Toplamı",null,null,null,"Ödenmesi Gereken",null,null,null,"Çek / Gönderme Emri No.",null,null,null,{"$f":"Q7","v":"2019-07-01"}]
[null,null,null,null,null,null,"Tahakkuk Toplamı",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Düzenleyen"]
[null,null,null,null,null,null,"YTL",null,null,"YKr","YTL",null,null,"YKr","YTL",null,null,"YKr"]
[null,null,null,null,null,null,{"$f":"IF(AA15=\"\",\"\",INT(AA15))","v":1311},null,null,{"$f":"IF(AA15=\"\",\"\",(AA15-INT(AA15))*100)","v":87.5},{"$f":"R15*8.25/1000","v":10.81575},null,null,41,{"$f":"U17","v":1300.18425},null,null,1,null,null,null,null,{"$f":"'Parametreler Yolluk'!E14","v":"Abdulkadir Tutaşı İlkokulu"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Parametreler Yolluk'!E15","v":0}]
[]
[null,null,"T E T K İ K   E D E N",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AÇIKLAMA VE EKLER"]
[null,null,"Memur",null,null,null,null,"Şef",null,null,null,null,"Muhasebe Yetkilisi Yrd."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,"Adet Personel Nakil Bildirimi"]
[null,null,"ÖDEMEYE ESAS BELGENİN",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,"Adet Atama Kararnamesi"]
[null,null,"Türü",null,null,null,null,"Tarihi",null,null,"No' su",null,null,null,"Tutarı",null,null,null,1,"Adet Göreve Başlama Yazısı"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"YTL",null,"YKr"]
[]
[]
[]
[null,null,"Kontrol Edilmiş ve Uygun Görülmüştür",null,null,null,null,null,null,null,null,"Uygundur",null,null,null,null,null,null,null,null,"Ödeyiniz / Mahsup Ediniz"]
[]
[null,null,"..... / ... / 2012",null,null,null,null,null,null,null,null,{"$f":"C64","v":"..... / ... / 2012"},null,null,null,null,null,null,null,null,"…/../2012"]
[]
[null,null,"Gerçekleştirme Görevlisi",null,null,null,null,null,null,null,null,"Harcama Yetkilisi",null,null,null,null,null,null,null,null,"Muhasebe Yetkilisi"]
[null,null,{"$f":"'Parametreler Yolluk'!E16","v":"İhsan HOMAN"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Parametreler Yolluk'!E20","v":"Boş bırakılabilir."}]
[null,null,{"$f":"'Parametreler Yolluk'!E17","v":"Okul Müdürü"},null,null,null,null,null,null,null,null,"İlçe Milli Eğitim Müdürü",null,null,null,null,null,null,null,null,{"$f":"'Parametreler Yolluk'!E21","v":"Boş bırakılabilir."}]
[]
[]
[null,null,{"$f":"\"Yalnız # \"&ParaCevir(O50+R50/100)&\"#  aldım.\"","v":{"$error":"#NAME?"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"İmza: ......................."]

{"sheet":"metem","index":6,"n_rows":71,"n_cols":29,"rows_kept":71,"cut":false,"hidden":true,"merged":[[53,2,53,6],[54,2,54,6],[56,7,57,9],[48,6,48,8],[46,14,47,17],[8,2,8,5],[22,11,22,12],[9,2,9,5],[35,11,35,12],[23,11,23,12],[24,11,24,12],[48,14,48,16],[49,2,50,5],[48,10,48,12],[49,9,50,9],[49,13,50,13],[49,6,50,8],[45,2,45,11],[8,14,8,18],[55,2,55,17],[26,11,26,12],[27,11,27,12],[22,17,22,18],[21,17,21,18],[4,2,4,5],[5,2,5,5],[6,2,7,5],[5,6,5,13],[6,8,6,9],[4,6,4,13],[7,16,7,18],[7,8,7,9],[7,14,7,15],[6,14,6,15],[5,14,5,15],[67,11,67,19],[65,2,65,10],[66,2,66,10],[66,20,66,23],[67,20,67,23],[66,11,66,19],[11,13,12,16],[67,2,67,10],[61,11,61,19],[62,11,62,19],[61,2,61,10],[62,2,62,10],[63,2,63,10],[64,11,64,19],[25,11,25,12],[64,2,64,10],[42,17,42,18],[46,18,48,21],[49,18,50,21],[15,11,15,12],[20,11,20,12],[21,11,21,12],[16,11,16,12],[13,11,13,12],[8,6,8,13],[19,11,19,12],[9,6,9,13],[46,6,46,9],[47,6,47,9],[46,10,47,13],[32,22,32,23],[35,22,35,23],[29,17,29,18],[30,22,30,23],[34,17,34,18],[34,22,34,23],[47,22,47,23],[37,11,37,12],[38,11,38,12],[39,11,39,12],[38,17,38,18],[38,22,38,23],[37,22,37,23],[37,17,37,18],[39,17,39,18],[46,22,46,23],[31,22,31,23],[32,17,32,18],[70,2,70,20],[35,17,35,18],[36,22,36,23],[30,17,30,18],[33,17,33,18],[31,17,31,18],[36,17,36,18],[45,22,45,23],[39,22,39,23],[42,22,42,23],[30,11,30,12],[31,11,31,12],[34,11,34,12],[40,11,40,12],[49,22,49,23],[50,22,50,23],[61,20,61,23],[52,18,52,23],[65,20,65,23],[65,11,65,19],[63,11,63,19],[49,14,50,16],[49,17,50,17],[49,10,50,12],[63,20,63,23],[41,22,41,23],[36,11,36,12],[32,11,32,12],[33,11,33,12],[40,22,40,23],[44,2,44,23],[42,2,42,15],[46,2,48,5],[58,16,58,17],[53,12,53,17],[54,12,54,17],[56,10,57,13],[58,10,58,13],[57,14,57,15],[57,16,57,17],[56,14,56,17],[53,7,53,11],[54,7,54,11],[56,2,57,6],[58,2,58,6],[58,14,58,15],[58,7,58,9],[52,2,52,17],[40,17,40,18],[29,22,29,23],[29,11,29,12],[41,10,41,15],[13,17,13,18],[33,22,33,23],[28,22,28,23],[27,17,27,18],[25,17,25,18],[27,22,27,23],[24,22,24,23],[24,17,24,18],[23,17,23,18],[41,17,41,18],[26,17,26,18],[23,22,23,23],[26,22,26,23],[25,22,25,23],[28,11,28,12],[14,11,14,12],[18,11,18,12],[17,11,17,12],[20,17,20,18],[21,22,21,23],[22,22,22,23],[28,17,28,18],[2,2,2,23],[15,17,15,18],[16,17,16,18],[17,17,17,18],[6,10,7,13],[6,20,6,22],[8,20,8,22],[7,20,7,22],[6,16,6,18],[11,2,13,2],[11,3,12,6],[11,7,12,10],[11,11,12,12],[9,14,9,18],[11,17,11,21],[12,20,12,21],[9,20,9,22],[20,22,20,23],[5,20,5,22],[5,16,5,18],[5,19,9,19],[19,22,19,23],[19,17,19,18],[11,22,13,23],[18,22,18,23],[16,22,16,23],[17,22,17,23],[14,17,14,18],[15,22,15,23],[14,22,14,23],[12,17,12,19],[18,17,18,18]]}
["R"]
[]
[null,null,"ÖDEME EMRİ BELGESİ"]
[]
[null,null,"Muhasebe Birimi Kodu",null,null,null,25108]
[null,null,"Muhasebe Birimi Adı",null,null,null,{"$f":"'Parametreler Yolluk'!E22","v":"Boş bırakılabilir."},null,null,null,null,null,null,null,"Bütçe Yılı",null,2011,null,null,"İlgilinin","Adı Soyadı",null,null,{"$f":"memur","v":"İhsan HOMAN"}]
[null,null,"Kurum-Birim Kodu",null,null,null,1,2,"BİRİM",null,"Yevmiyenin",null,null,null,"Tarihi",null,{"$f":"TODAY()","v":"2019-07-01"},null,null,null,"T.C. / Vergi Kimlik No",null,null,{"$f":"vno","v":12345678910}]
[null,null,null,null,null,null,13,1,"285",null,null,null,null,null,"No' su",null,null,null,null,null,"Banka Şube Adı",null,null,{"$f":"'Parametreler Yolluk'!E24","v":"Boş bırakılabilir."}]
[null,null,"Kurum Adı",null,null,null,null,null,null,null,null,null,null,null,"PERSONEL SÜREKLİ",null,null,null,null,null,"Banka Hesap Numarası",null,null,{"$f":"'Parametreler Yolluk'!E23","v":"Boş bırakılabilir."}]
[null,null,"Birim Adı",null,null,null,"HALK EĞİTİM MERKEZİ",null,null,null,null,null,null,null,"GÖREV YOLLUĞU",null,null,null,null,null,"Bağlı Olduğu Vergi Dairesi",null,null,{"$f":"'Parametreler Yolluk'!E22","v":"Boş bırakılabilir."}]
[]
[null,null,"Hesap No","Kurumsal Kod",null,null,null,"Fonksiyonel Kod",null,null,null,"Finans Kodu",null,"Ekonomik / Ayrıntı Kodu",null,null,null,"T U T A R",null,null,null,null,"Hesap / Ayrıntı Adı"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BORÇ",null,null,"ALACAK"]
[null,null,null,1,2,3,4,1,2,3,4,1,null,1,2,3,4,"YTL",null,"YKr","YTL","YKr",null,null,null,null,"BORÇ","ALACAK"]
[null,null,630,13,1,"38","0","09","9","9","05","1",null,"03","3","2","01",{"$f":"IF(AA15=\"\",\"\",INT(AA15))","v":1311},null,{"$f":"IF(AA15=\"\",\"\",(AA15-INT(AA15))*100)","v":87.5},null,null,{"$f":"AC15","v":"  Sürekli Görev Yolluğu"},null,null,null,{"$f":"Yolluk!O26","v":1311.875},null,"  Sürekli Görev Yolluğu"]
[null,null,600,"","","","","","","","",null,null,"01",5,1,"01",null,null,null,{"$f":"R15*8.25/1000","v":10.81575},{"$f":"IF(AB16=\"\",\"\",(AB16-INT(AB16))*100)","v":83.999999999999986},"  Damga Vergisi",null,null,null,null,{"$f":"ROUND(AA15*0.0075,2)","v":9.84},"  Damga Vergisi"]
[null,null,325,"","","","","","","","",null,null,"2","0","0","0",null,null,null,1125,{"$f":"IF(AB17=\"\",\"\",(AB17-INT(AB17))*100)","v":3.999999999996362},"  Verilen Gönderme Emri Hesabı",null,null,null,null,{"$f":"ROUND(AA15-AB16,2)","v":1302.04},"  Verilen Gönderme Emri Hesabı"]
[null,null,"","","","","","","","","",null,null,"","","","",{"$f":"IF(AA18=\"\",\"\",INT(AA18))","v":1311},null,{"$f":"IF(AA18=\"\",\"\",(AA18-INT(AA18))*100)","v":87.5},{"$f":"IF(AB18=\"\",\"\",INT(AB18))","v":1311},{"$f":"IF(AB18=\"\",\"\",(AB18-INT(AB18))*100)","v":87.5}," TAHAKKUK TOPLAMLARI",null,null,null,{"$f":"AA15","v":1311.875},{"$f":"AA15","v":1311.875}," TAHAKKUK TOPLAMLARI"]
[null,null,630,{"$f":"D15","v":13},1,"38","0","09","9","9","05",1,null,{"$f":"N15","v":"03"},{"$f":"O15","v":"3"},{"$f":"P15","v":"2"},{"$f":"Q15","v":"01"},{"$f":"IF(AA19=\"\",\"\",INT(AA19))","v":1311},null,{"$f":"IF(AA19=\"\",\"\",(AA19-INT(AA19))*100)","v":87.5},null,null,"  Sürekli Görev Yolluğu",null,null,null,{"$f":"AA15","v":1311.875},null,"  Sürekli Görev Yolluğu"]
[null,null,835,"","","","","","","","",null,null,"","","","",null,null,null,{"$f":"IF(AB20=\"\",\"\",INT(AB20))","v":1311},{"$f":"IF(AB20=\"\",\"\",(AB20-INT(AB20))*100)","v":87.5},"  Gider Yansıtma Hesabı",null,null,null,null,{"$f":"AA15","v":1311.875},"  Gider Yansıtma Hesabı"]
[null,null,805,"","","","","","","","",null,null,null,null,null,null,{"$f":"IF(AA21=\"\",\"\",INT(AA21))","v":9},null,{"$f":"IF(AA21=\"\",\"\",(AA21-INT(AA21))*100)","v":83.999999999999986},null,null,"  Gelir Yansıtma Hesabı",null,null,null,{"$f":"AB16","v":9.84},null,"  Gelir Yansıtma Hesabı"]
[null,null,600,"","","","","","","","",null,null,{"$f":"N16","v":"01"},{"$f":"O16","v":5},{"$f":"P16","v":1},{"$f":"Q16","v":"01"},null,null,null,{"$f":"IF(AB22=\"\",\"\",INT(AB22))","v":9},{"$f":"IF(AB22=\"\",\"\",(AB22-INT(AB22))*100)","v":83.999999999999986},"  Damga Vergisi",null,null,null,null,{"$f":"AB16","v":9.84},"  Damga Vergisi"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(AA18:AA23)","v":2633.59},{"$f":"SUM(AB18:AB23)","v":2633.59}," TOPLAM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AA15","v":1311.875},{"$f":"AA15","v":1311.875}," Bütçe Gideri Tahakkuk Toplamı"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"T O P L A M      ",null,null,null,null,null,null,{"$f":"IF(AA24=\"\",\"\",INT(AA24))","v":2633},null,{"$f":"IF(AA24=\"\",\"\",(AA24-INT(AA24))*100)","v":59.000000000014552},{"$f":"IF(AB24=\"\",\"\",INT(AB24))","v":2633},{"$f":"IF(AB24=\"\",\"\",(AB24-INT(AB24))*100)","v":59.000000000014552},{"$f":"IF(AA24<>AB24,\" ! HATA VAR !\",\" \" )","v":" "}]
[null,null,"Bütçe Gideri Tahakkuk Toplamı   ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AA25=\"\",\"\",INT(AA25))","v":1311},null,{"$f":"IF(AA25=\"\",\"\",(AA15-INT(AA25))*100)","v":87.5},{"$f":"IF(AB25=\"\",\"\",INT(AB25))","v":1311},{"$f":"IF(AB25=\"\",\"\",(AB25-INT(AB25))*100)","v":87.5},{"$f":"IF(AA25<>AB25,\" ! HATA VAR !\",\" \" )","v":" "}]
[]
[null,null,{"$f":"\"Yukarıda yazılı # \"&ParaCevir(G50+J50/100)&\"#  Bütçe Gideri tahakkuk ettirilmiştir. Ödenmesi / Mahsubu gerekir.\"","v":{"$error":"#NAME?"}}]
[]
[null,null,"Ödeme Emri Belgesi No",null,null,null,"Bütçe Gideri",null,null,null,"Kesinti Toplamı",null,null,null,"Ödenmesi Gereken",null,null,null,"Çek / Gönderme Emri No.",null,null,null,{"$f":"Q7","v":"2019-07-01"}]
[null,null,null,null,null,null,"Tahakkuk Toplamı",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Düzenleyen"]
[null,null,null,null,null,null,"YTL",null,null,"YKr","YTL",null,null,"YKr","YTL",null,null,"YKr"]
[null,null,null,null,null,null,{"$f":"IF(AA15=\"\",\"\",INT(AA15))","v":1311},null,null,{"$f":"IF(AA15=\"\",\"\",(AA15-INT(AA15))*100)","v":87.5},{"$f":"IF(AB16=\"\",\"\",(INT(AB16)))","v":9},null,null,{"$f":"IF(AB16=\"\",\"\",(AB16-INT(AB16))*100)","v":83.999999999999986},1125,null,null,{"$f":"IF(AA15=\"\",\"\",(AB17-INT(AB17))*100)","v":3.999999999996362},null,null,null,null,{"$f":"'Parametreler Yolluk'!E14","v":"Abdulkadir Tutaşı İlkokulu"}]
[]
[]
[null,null,"T E T K İ K   E D E N",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AÇIKLAMA VE EKLER"]
[null,null,"Memur",null,null,null,null,"Şef",null,null,null,null,"Muhasebe Yetkilisi Yrd."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,"Adet Personel Nakil Bildirimi"]
[null,null,"ÖDEMEYE ESAS BELGENİN",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,"Adet Atama Kararnamesi"]
[null,null,"Türü",null,null,null,null,"Tarihi",null,null,"No' su",null,null,null,"Tutarı",null,null,null,1,"Adet Göreve Başlama Yazısı"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"YTL",null,"YKr"]
[]
[]
[]
[null,null,"Kontrol Edilmiş ve Uygun Görülmüştür",null,null,null,null,null,null,null,null,"Uygundur",null,null,null,null,null,null,null,null,"Ödeyiniz / Mahsup Ediniz"]
[]
[null,null,"..... / 08 / 2011",null,null,null,null,null,null,null,null,{"$f":"C64","v":"..... / 08 / 2011"},null,null,null,null,null,null,null,null,"…/08/2011"]
[]
[null,null,"Gerçekleştirme Görevlisi",null,null,null,null,null,null,null,null,"Harcama Yetkilisi",null,null,null,null,null,null,null,null,"Muhasebe Yetkilisi"]
[null,null,{"$f":"'Parametreler Yolluk'!E16","v":"İhsan HOMAN"},null,null,null,null,null,null,null,null,{"$f":"'Parametreler Yolluk'!E18","v":"Boş bırakılabilir."},null,null,null,null,null,null,null,null,{"$f":"'Parametreler Yolluk'!E20","v":"Boş bırakılabilir."}]
[null,null,{"$f":"'Parametreler Yolluk'!E17","v":"Okul Müdürü"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Parametreler Yolluk'!E21","v":"Boş bırakılabilir."}]
[]
[]
[null,null,{"$f":"\"Yalnız # \"&ParaCevir(O50+R50/100)&\"#  aldım.\"","v":{"$error":"#NAME?"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"İmza: ......................."]

{"sheet":"LİSE","index":7,"n_rows":71,"n_cols":29,"rows_kept":71,"cut":false,"hidden":true,"merged":[[2,2,2,23],[15,17,15,18],[16,17,16,18],[17,17,17,18],[6,10,7,13],[6,20,6,22],[8,20,8,22],[7,20,7,22],[6,16,6,18],[17,22,17,23],[14,17,14,18],[15,22,15,23],[14,22,14,23],[9,20,9,22],[11,22,13,23],[16,22,16,23],[5,19,9,19],[6,14,6,15],[5,14,5,15],[8,14,8,18],[5,20,5,22],[5,16,5,18],[4,2,4,5],[5,2,5,5],[34,22,34,23],[31,22,31,23],[32,17,32,18],[41,10,41,15],[13,17,13,18],[33,22,33,23],[28,22,28,23],[27,17,27,18],[25,17,25,18],[27,22,27,23],[24,22,24,23],[24,17,24,18],[23,17,23,18],[28,17,28,18],[22,17,22,18],[21,17,21,18],[18,17,18,18],[19,17,19,18],[20,17,20,18],[21,22,21,23],[22,22,22,23],[20,22,20,23],[19,22,19,23],[18,22,18,23],[70,2,70,20],[35,17,35,18],[36,22,36,23],[30,17,30,18],[33,17,33,18],[31,17,31,18],[36,17,36,18],[45,22,45,23],[39,22,39,23],[40,17,40,18],[55,2,55,17],[63,20,63,23],[41,22,41,23],[36,11,36,12],[32,11,32,12],[33,11,33,12],[40,22,40,23],[44,2,44,23],[41,17,41,18],[52,2,52,17],[32,22,32,23],[35,22,35,23],[30,22,30,23],[34,17,34,18],[23,22,23,23],[29,22,29,23],[26,22,26,23],[25,22,25,23],[26,17,26,18],[29,17,29,18],[47,22,47,23],[37,11,37,12],[38,11,38,12],[39,11,39,12],[38,17,38,18],[38,22,38,23],[37,22,37,23],[37,17,37,18],[39,17,39,18],[46,22,46,23],[42,22,42,23],[40,11,40,12],[42,2,42,15],[25,11,25,12],[26,11,26,12],[27,11,27,12],[42,17,42,18],[46,18,48,21],[66,20,66,23],[67,20,67,23],[49,22,49,23],[50,22,50,23],[61,20,61,23],[52,18,52,23],[65,20,65,23],[65,11,65,19],[66,11,66,19],[63,11,63,19],[49,14,50,16],[49,17,50,17],[49,10,50,12],[49,18,50,21],[67,2,67,10],[61,11,61,19],[62,11,62,19],[61,2,61,10],[62,2,62,10],[63,2,63,10],[64,2,64,10],[67,11,67,19],[65,2,65,10],[66,2,66,10],[64,11,64,19],[6,2,7,5],[5,6,5,13],[6,8,6,9],[4,6,4,13],[8,6,8,13],[13,11,13,12],[19,11,19,12],[18,11,18,12],[17,11,17,12],[9,6,9,13],[11,13,12,16],[9,14,9,18],[11,17,11,21],[12,20,12,21],[12,17,12,19],[7,16,7,18],[7,8,7,9],[7,14,7,15],[15,11,15,12],[16,11,16,12],[48,14,48,16],[49,2,50,5],[48,10,48,12],[49,9,50,9],[49,13,50,13],[49,6,50,8],[8,2,8,5],[22,11,22,12],[9,2,9,5],[23,11,23,12],[24,11,24,12],[11,2,13,2],[11,3,12,6],[11,7,12,10],[11,11,12,12],[14,11,14,12],[35,11,35,12],[28,11,28,12],[29,11,29,12],[30,11,30,12],[31,11,31,12],[34,11,34,12],[20,11,20,12],[21,11,21,12],[56,2,57,6],[58,2,58,6],[45,2,45,11],[58,14,58,15],[58,7,58,9],[53,2,53,6],[54,2,54,6],[56,7,57,9],[48,6,48,8],[46,14,47,17],[58,16,58,17],[53,12,53,17],[54,12,54,17],[56,10,57,13],[58,10,58,13],[57,14,57,15],[57,16,57,17],[56,14,56,17],[53,7,53,11],[54,7,54,11],[46,6,46,9],[47,6,47,9],[46,2,48,5],[46,10,47,13]]}
["R"]
[]
[null,null,"ÖDEME EMRİ BELGESİ"]
[]
[null,null,"Muhasebe Birimi Kodu",null,null,null,25108]
[null,null,"Muhasebe Birimi Adı",null,null,null,{"$f":"'Parametreler Yolluk'!E22","v":"Boş bırakılabilir."},null,null,null,null,null,null,null,"Bütçe Yılı",null,2012,null,null,"İlgilinin","Adı Soyadı",null,null,{"$f":"memur","v":"İhsan HOMAN"}]
[null,null,"Kurum-Birim Kodu",null,null,null,1,2,"BİRİM",null,"Yevmiyenin",null,null,null,"Tarihi",null,{"$f":"TODAY()","v":"2019-07-01"},null,null,null,"T.C. / Vergi Kimlik No",null,null,{"$f":"vno","v":12345678910}]
[null,null,null,null,null,null,13,62,306,null,null,null,null,null,"No' su",null,null,null,null,null,"Banka Şube Adı",null,null,{"$f":"'Parametreler Yolluk'!E24","v":"Boş bırakılabilir."}]
[null,null,"Kurum Adı",null,null,null,"Milli Eğitim Bakanlığı",null,null,null,null,null,null,null,"PERSONEL SÜREKLİ",null,null,null,null,null,"Banka Hesap Numarası",null,null,{"$f":"'Parametreler Yolluk'!E23","v":"Boş bırakılabilir."}]
[null,null,"Birim Adı",null,null,null,"ORTAÖĞRETİM",null,null,null,null,null,null,null,"GÖREV YOLLUĞU",null,null,null,null,null,"Bağlı Olduğu Vergi Dairesi",null,null,{"$f":"'Parametreler Yolluk'!E22","v":"Boş bırakılabilir."}]
[]
[null,null,"Hesap No","Kurumsal Kod",null,null,null,"Fonksiyonel Kod",null,null,null,"Finans Kodu",null,"Ekonomik / Ayrıntı Kodu",null,null,null,"T U T A R",null,null,null,null,"Hesap / Ayrıntı Adı"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BORÇ",null,null,"ALACAK"]
[null,null,null,1,2,3,4,1,2,3,4,1,null,1,2,3,4,"YTL",null,"YKr","YTL","YKr",null,null,null,null,"BORÇ","ALACAK"]
[null,null,630,13,1,"32",62,"09","9","9","05","1",null,"03","3","2","01",{"$f":"IF(AA15=\"\",\"\",INT(AA15))","v":1311},null,{"$f":"IF(AA15=\"\",\"\",(AA15-INT(AA15))*100)","v":87.5},null,null,{"$f":"AC15","v":"  Sürekli Görev Yolluğu"},null,null,null,{"$f":"Yolluk!O26","v":1311.875},null,"  Sürekli Görev Yolluğu"]
[null,null,600,"","","","","","","","",null,null,"01",5,1,"01",null,null,null,{"$f":"R15*8.25/1000","v":10.81575},{"$f":"IF(AB16=\"\",\"\",(AB16-INT(AB16))*100)","v":83.999999999999986},"  Damga Vergisi",null,null,null,null,{"$f":"ROUND(AA15*0.0075,2)","v":9.84},"  Damga Vergisi"]
[null,null,325,"","","","","","","","",null,null,"2","0","0","0",null,null,null,892,{"$f":"IF(AB17=\"\",\"\",(AB17-INT(AB17))*100)","v":3.999999999996362},"  Verilen Gönderme Emri Hesabı",null,null,null,null,{"$f":"ROUND(AA15-AB16,2)","v":1302.04},"  Verilen Gönderme Emri Hesabı"]
[null,null,"","","","","","","","","",null,null,"","","","",{"$f":"IF(AA18=\"\",\"\",INT(AA18))","v":1311},null,{"$f":"IF(AA18=\"\",\"\",(AA18-INT(AA18))*100)","v":87.5},{"$f":"IF(AB18=\"\",\"\",INT(AB18))","v":1311},{"$f":"IF(AB18=\"\",\"\",(AB18-INT(AB18))*100)","v":87.5}," TAHAKKUK TOPLAMLARI",null,null,null,{"$f":"AA15","v":1311.875},{"$f":"AA15","v":1311.875}," TAHAKKUK TOPLAMLARI"]
[null,null,630,{"$f":"D15","v":13},1,"32",62,"09","9","9","05",1,null,{"$f":"N15","v":"03"},{"$f":"O15","v":"3"},{"$f":"P15","v":"2"},{"$f":"Q15","v":"01"},{"$f":"IF(AA19=\"\",\"\",INT(AA19))","v":1311},null,{"$f":"IF(AA19=\"\",\"\",(AA19-INT(AA19))*100)","v":87.5},null,null,"  Sürekli Görev Yolluğu",null,null,null,{"$f":"AA15","v":1311.875},null,"  Sürekli Görev Yolluğu"]
[null,null,835,"","","","","","","","",null,null,"","","","",null,null,null,{"$f":"IF(AB20=\"\",\"\",INT(AB20))","v":1311},{"$f":"IF(AB20=\"\",\"\",(AB20-INT(AB20))*100)","v":87.5},"  Gider Yansıtma Hesabı",null,null,null,null,{"$f":"AA15","v":1311.875},"  Gider Yansıtma Hesabı"]
[null,null,805,"","","","","","","","",null,null,null,null,null,null,{"$f":"IF(AA21=\"\",\"\",INT(AA21))","v":9},null,{"$f":"IF(AA21=\"\",\"\",(AA21-INT(AA21))*100)","v":83.999999999999986},null,null,"  Gelir Yansıtma Hesabı",null,null,null,{"$f":"AB16","v":9.84},null,"  Gelir Yansıtma Hesabı"]
[null,null,600,"","","","","","","","",null,null,{"$f":"N16","v":"01"},{"$f":"O16","v":5},{"$f":"P16","v":1},{"$f":"Q16","v":"01"},null,null,null,{"$f":"IF(AB22=\"\",\"\",INT(AB22))","v":9},{"$f":"IF(AB22=\"\",\"\",(AB22-INT(AB22))*100)","v":83.999999999999986},"  Damga Vergisi",null,null,null,null,{"$f":"AB16","v":9.84},"  Damga Vergisi"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(AA18:AA23)","v":2633.59},{"$f":"SUM(AB18:AB23)","v":2633.59}," TOPLAM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AA15","v":1311.875},{"$f":"AA15","v":1311.875}," Bütçe Gideri Tahakkuk Toplamı"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"T O P L A M      ",null,null,null,null,null,null,{"$f":"IF(AA24=\"\",\"\",INT(AA24))","v":2633},null,{"$f":"IF(AA24=\"\",\"\",(AA24-INT(AA24))*100)","v":59.000000000014552},{"$f":"IF(AB24=\"\",\"\",INT(AB24))","v":2633},{"$f":"IF(AB24=\"\",\"\",(AB24-INT(AB24))*100)","v":59.000000000014552},{"$f":"IF(AA24<>AB24,\" ! HATA VAR !\",\" \" )","v":" "}]
[null,null,"Bütçe Gideri Tahakkuk Toplamı   ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AA25=\"\",\"\",INT(AA25))","v":1311},null,{"$f":"IF(AA25=\"\",\"\",(AA15-INT(AA25))*100)","v":87.5},{"$f":"IF(AB25=\"\",\"\",INT(AB25))","v":1311},{"$f":"IF(AB25=\"\",\"\",(AB25-INT(AB25))*100)","v":87.5},{"$f":"IF(AA25<>AB25,\" ! HATA VAR !\",\" \" )","v":" "}]
[]
[null,null,{"$f":"\"Yukarıda yazılı # \"&ParaCevir(G50+J50/100)&\"#  Bütçe Gideri tahakkuk ettirilmiştir. Ödenmesi / Mahsubu gerekir.\"","v":{"$error":"#NAME?"}}]
[]
[null,null,"Ödeme Emri Belgesi No",null,null,null,"Bütçe Gideri",null,null,null,"Kesinti Toplamı",null,null,null,"Ödenmesi Gereken",null,null,null,"Çek / Gönderme Emri No.",null,null,null,{"$f":"Q7","v":"2019-07-01"}]
[null,null,null,null,null,null,"Tahakkuk Toplamı",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Düzenleyen"]
[null,null,null,null,null,null,"YTL",null,null,"YKr","YTL",null,null,"YKr","YTL",null,null,"YKr"]
[null,null,null,null,null,null,{"$f":"IF(AA15=\"\",\"\",INT(AA15))","v":1311},null,null,{"$f":"IF(AA15=\"\",\"\",(AA15-INT(AA15))*100)","v":87.5},7,null,null,{"$f":"IF(AB16=\"\",\"\",(AB16-INT(AB16))*100)","v":83.999999999999986},892,null,null,{"$f":"IF(AA15=\"\",\"\",(AB17-INT(AB17))*100)","v":3.999999999996362},null,null,null,null,{"$f":"'Parametreler Yolluk'!E14","v":"Abdulkadir Tutaşı İlkokulu"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Parametreler Yolluk'!E15","v":0}]
[]
[null,null,"T E T K İ K   E D E N",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AÇIKLAMA VE EKLER"]
[null,null,"Memur",null,null,null,null,"Şef",null,null,null,null,"Muhasebe Yetkilisi Yrd."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,"Adet Personel Nakil Bildirimi"]
[null,null,"ÖDEMEYE ESAS BELGENİN",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,"Adet Atama Kararnamesi"]
[null,null,"Türü",null,null,null,null,"Tarihi",null,null,"No' su",null,null,null,"Tutarı",null,null,null,1,"Adet Göreve Başlama Yazısı"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"YTL",null,"YKr"]
[]
[]
[]
[null,null,"Kontrol Edilmiş ve Uygun Görülmüştür",null,null,null,null,null,null,null,null,"Uygundur",null,null,null,null,null,null,null,null,"Ödeyiniz / Mahsup Ediniz"]
[]
[null,null,"…/05/2010",null,null,null,null,null,null,null,null,{"$f":"C64","v":"…/05/2010"},null,null,null,null,null,null,null,null,"…/05/2010"]
[]
[null,null,"Gerçekleştirme Görevlisi",null,null,null,null,null,null,null,null,"Harcama Yetkilisi",null,null,null,null,null,null,null,null,"Muhasebe Yetkilisi"]
[null,null,{"$f":"'Parametreler Yolluk'!E16","v":"İhsan HOMAN"},null,null,null,null,null,null,null,null,{"$f":"'Parametreler Yolluk'!E18","v":"Boş bırakılabilir."},null,null,null,null,null,null,null,null,{"$f":"'Parametreler Yolluk'!E20","v":"Boş bırakılabilir."}]
[null,null,{"$f":"'Parametreler Yolluk'!E17","v":"Okul Müdürü"},null,null,null,null,null,null,null,null,"İlçe Milli Eğitim Müdürü",null,null,null,null,null,null,null,null,{"$f":"'Parametreler Yolluk'!E21","v":"Boş bırakılabilir."}]
[]
[]
[null,null,{"$f":"\"Yalnız # \"&ParaCevir(O50+R50/100)&\"#  aldım.\"","v":{"$error":"#NAME?"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"İmza: ......................."]