{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["DYK FAZLA ÇALIŞMA PUANTAJI"],"not_rendered":{"charts":0,"images":0,"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":"DYK FAZLA ÇALIŞMA PUANTAJI","index":0,"n_rows":49,"n_cols":59,"rows_kept":49,"cut":false,"hidden":false,"merged":[[8,57,8,58],[13,55,13,56],[39,33,39,37],[38,30,38,35],[1,1,1,37],[3,4,3,13],[2,1,2,2],[5,36,7,36],[5,37,7,37],[2,33,2,36],[3,33,3,36],[2,3,2,30],[47,1,47,2],[44,5,44,12],[45,5,45,12],[43,24,43,31],[44,24,44,31],[45,24,45,31],[43,5,43,12],[42,25,42,30],[5,1,5,35],[41,5,41,9],[6,2,6,4],[42,5,42,9],[41,24,41,30],[41,17,41,23],[39,2,39,32],[6,1,7,1],[40,33,40,36]]}
[]
[null,"DESTEKLEME ve YETİŞTİRME KURSLARI HİZMETLİ VE MEMUR FAZLA ÇALIŞMA PUANTAJ ÇİZELGESİ"]
[null,"Okul / Kurumu Adı :",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,null,null,null,null,null,"Ait Olduğu Ay",null,null,null,12]
[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,null,null,null,null,null,null,null,"Bütçe Yılı",null,null,null,2019]
[null,null,null,null,null,{"$f":"WEEKDAY(BE11,2)","v":7},{"$f":"IF(F5>6,1,F5+1)","v":1},{"$f":"IF(G5>6,1,G5+1)","v":2},3,4,5,6,7,1,2,3,4,5,6,7,1,2,3,4,5,6,7,1,2,3,4,5,6,7,1,2]
[null,"AYLIK FAZLA ÇALIŞMA SAATLERİ",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,null,null,null,null,null,null,null,null,"Aylık Fazla Çalışma Saati Toplamı","AÇIKLAMA"]
[null,"Sıra No ","HZİMETLİNİN/\nMEMURUN",null,null,{"$f":"VLOOKUP(F5,$BD$16:$BE$22,2)","v":"Pazar"},{"$f":"VLOOKUP(G5,$BD$16:$BE$22,2)","v":"Pazartesi"},"Salı","Çarşamba","Perşembe","Cuma","Cumartesi","Pazar","Pazartesi","Salı","Çarşamba","Perşembe","Cuma","Cumartesi","Pazar","Pazartesi","Salı","Çarşamba","Perşembe","Cuma","Cumartesi","Pazar","Pazartesi","Salı","Çarşamba","Perşembe","Cuma","Cumartesi","Pazar","Pazartesi","Salı",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AYLAR","YILLAR"]
[null,null,"TC KİMLİK NO'SU","ADI VE SOYADI","GÖREVİ",1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31]
[null,{"$f":"IF(C9=\"\",\"\",1)","v":1},"1……","Ad SOYAD","Memur",null,null,null,null,null,null,8,null,null,null,null,null,null,8,null,null,null,null,null,null,8,null,null,null,null,null,null,8,null,null,null,{"$f":"SUM(F9:AJ9)","v":32},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,2010,"Ocak","Ay Adı :",{"$f":"CHOOSE(AL3,\"OCAK\",\"ŞUBAT\",\"MART\",\"NİSAN\",\"MAYIS\",\"HAZİRAN\",\"TEMMUZ\",\"AĞUSTOS\",\"EYLÜL\",\"EKİM\",\"KASIM\",\"ARALIK\")","v":"ARALIK"},"AYLAR"]
[null,{"$f":"IF(C10=\"\",\"\",B9+1)","v":""},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,null,null,null,null,null,null,null,null,{"$f":"SUM(F10:AJ10)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,2011,"Şubat","Gün Sayısı :",{"$f":"VLOOKUP(BE9,BF10:BG22,2,0)","v":31},"Ocak",31]
[null,{"$f":"IF(C11=\"\",\"\",B10+1)","v":""},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,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,2012,"Mart","Ay & Yıl :",{"$f":"CONCATENATE(BE9,AL4)","v":"ARALIK2019"},"Şubat",29]
[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,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,2013,"Nisan","Sonraki Ay :",{"$f":"CHOOSE(AL3+1,\"OCAK\",\"ŞUBAT\",\"MART\",\"NİSAN\",\"MAYIS\",\"HAZİRAN\",\"TEMMUZ\",\"AĞUSTOS\",\"EYLÜL\",\"EKİM\",\"KASIM\",\"ARALIK\",\"OCAK\")","v":"OCAK"},"Mart",31]
[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,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,2014,"Mayıs","Sonr. Ay & Yıl :",{"$f":"IF(BE9=\"ARALIK\",CONCATENATE(BE12,AL3+1),CONCATENATE(BE12,AL4))","v":"OCAK13"},"Nisan",30]
[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,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,2015,"Haziran","HAFTANIN GÜNLERİ",null,"Mayıs",31]
[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,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,2016,"Temmuz"]
[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,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,2017,"Ağustos",1,"Pazartesi","Haziran",30]
[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,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9,2018,"Eylül",2,"Salı","Temmuz",31]
[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,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,2019,"Ekim",3,"Çarşamba","Ağustos",31]
[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,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,11,2020,"Kasım",4,"Perşembe","Eylül",30]
[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,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,12,2021,"Aralık",5,"Cuma","Ekim",31]
[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,null,null,null,null,null,null,null,null,null,{"$f":"SUM(F21:AJ21)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2022,{"$f":"INDEX(BC9:BC20,AL3)","v":"Aralık"},6,"Cumartesi","Kasım",30]
[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,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2023,null,7,"Pazar","Aralık",31]
[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,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2024]
[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,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2025]
[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,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2026]
[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,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2027]
[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,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2028]
[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,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2029]
[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,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2030]
[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,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2031]
[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,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2032]
[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,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2033]
[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,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2034]
[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,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2035]
[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,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2036]
[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,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2037]
[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,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2038]
[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,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2039]
[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,null,null,null,null,"T O P L A M",null,null,null,null,null,{"$f":"SUM(AK9:AK38)","v":32},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2040]
[null,null,{"$f":"CONCATENATE(\"Yukarıda belirtilen görevlilerce \"&AL4&\" \"&BC21&\" ayında toplam \"&Yaziyla(AK39)&\" saat Fazla Çalışma Saati hesaplanmıştır.\")","v":"Yukarıda belirtilen görevlilerce 2019 Aralık ayında toplam Otuzİki saat Fazla Çalışma Saati hesaplanmıştır."},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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2041]
[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,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,2042]
[null,null,null,null,null,"Düzenleyen",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Okul/Kurum Müdürü ",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,null,null,2043]
[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,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,null,2044]
[null,null,null,null,"Adı Soyadı :",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Adı Soyadı :",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,null,null,null,2045]
[null,null,null,null,"Unvanı :",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Unvanı :",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,null,null,null,2046]
[null,null,null,null,"İmzası :",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"İmzası :",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,null,null,null,2047]
[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,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,null,2048]
[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,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,null,2049]
[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,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,null,2050]