{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["SABİTLER","DATA","RAPOR","AYLIK"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":4,"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":"SABİTLER","index":0,"n_rows":12,"n_cols":1,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
[]
["RAPORLU"]
["KESİNTİ"]
["YILLIK İZİN"]
["DOĞUM İZNİ"]
["EVLİLİK İZNİ"]
["GÖREVLİ İZİNLİ"]
["ÖLÜM İZNİ"]
["SEVKLİ"]
["ÜCRETSİZ İZİN"]
["MAZERET İZNİ"]
["HEYET RAPORLU"]

{"sheet":"DATA","index":1,"n_rows":106,"n_cols":22,"rows_kept":106,"cut":false,"hidden":false,"merged":[[1,1,1,7],[0,1,0,7],[4,5,5,5],[4,6,5,6],[4,7,5,7],[3,5,3,7],[2,1,2,7],[4,0,5,0],[4,1,5,1],[4,2,5,2],[4,3,5,3],[4,4,5,4]]}
["x","…………………………... KAYMAKAMLIĞI"]
["x","……………………………………………………..  LİSESİ MÜDÜRLÜĞÜ"]
["x","RAPOR-İZİNLERİN MAAŞTAN DÜŞÜM ÇİZELGESİ",null,null,null,null,null,null,"AÇIKLAMALAR ALT HÜCRELERDE GÖRÜNÜR"]
["x",null,null,null,null,"BU 3 SÜTÜNU SİLME \nFORMÜL VAR",null,null,null,null,null,null,null,null,null,null,null,"tt","xx","rr"]
["SIRA","TC KİMLİK NO","SİCİL NO","ADI, SOYADI","GÖREVİ","RAPORLU GÜN SAYISI","TOPLAM KESİLEN","KESİLMESİ GEREKEN ","RAPORLU","RAPORLU","RAPORLU","KESİNTİ","YILLIK İZİN","RAPORLU","RAPORLU","Sevkli","RAPORLU","RAPORLU","Sevkli","KESİNTİ","KESİNTİ","KESİNTİ"]
[null,null,null,null,null,null,null,null,"2020-01-14","2020-01-15","2020-01-17","2020-01-18","2020-01-19","2020-01-20","2020-01-21","2020-01-22","14.01.2020","16.01.2020","2020-01-16","2020-01-16","2020-02-17","2020-03-18"]
[{"$f":"IF(B7=\"\",\"\",ROW(A1))","v":1},1001,845555,"a","Sosyal Bilgiler",{"$f":"SUMIFS(I7:KY7,$I$5:$KY$5,\"RAPORLU\")","v":4},{"$f":"SUMIFS(I7:KY7,$I$5:$KY$5,\"KESİNTİ\")","v":0},{"$f":"F7-7-G7","v":-3},1,1,null,null,1,1,1,1]
[{"$f":"IF(B8=\"\",\"\",ROW(A2))","v":2},1002,845554,"b","Türkçe",14,13,{"$f":"F8-7-G8","v":-6},2,null,2,null,2,2,2,null,null,6,7,8,2,3]
[3,1003,845553,"c","Din Kült. ve Ahl.Bil.",17,0,10,5,null,12,null,1]
[4,1004,845552,"d","Görsel Sanatlar",7,6,-6,6,null,null,6,null,1]
[5,1005,845551,"e","Müzik",22,0,15,7,null,14,null,null,null,1]
[6,1006,845550,104,"İngilizce",8,0,1,8,null,null,null,null,null,null,1]
[7,1007,845549,105,"Fen Bilimleri/Fen ve Teknoloji",9,0,2,9]
[8,1008,845548,106,"İngilizce",10,0,3,10]
[9,1009,845547,107,"Sosyal Bilgiler",11,0,4,11]
[10,1010,845546,108,"İngilizce",12,0,5,12]
[11,1011,845545,109,"Bilişim Teknolojileri",13,0,6,13]
[12,1012,845544,110,"Teknoloji ve Tasarım",14,0,7,14]
[13,1013,845543,111,"Türkçe",15,0,8,15]
[14,1014,845542,112,"Türkçe",16,0,9,16]
[15,1015,845541,113,"Fen Bilimleri/Fen ve Teknoloji",17,0,10,17]
[16,1016,845540,114,"Sosyal Bilgiler",18,0,11,18]
[17,1017,845539,115,"Okul Öncesi Öğrt",19,0,12,19]
[18,1018,845538,116,"Türkçe",20,0,13,20]
[19,1019,845537,117,"Fen Bilimleri/Fen ve Teknoloji",21,0,14,21]
[20,1020,845536,118,"Rehberlik",22,0,15,22]
[21,1021,845535,119,"İlköğretim Matematik Öğr.",23,0,16,23]
[22,1022,845534,120,"Teknoloji ve Tasarım",24,0,17,24]
[23,1023,845533,121,"Türkçe",25,0,18,25]
[24,1024,845532,122,"Beden Eğitimi",26,0,19,26]
[25,1025,845531,123,"İlköğretim Matematik Öğr.",1,0,-6,null,null,null,null,null,null,null,null,1]
[26,1026,845530,124,"Türkçe",0,0,-7]
[27,1027,845529,125,"İngilizce",0,0,-7]
[28,1028,845528,126,"Türkçe",0,0,-7]
[29,1029,845527,127,"Türkçe",0,0,-7]
[30,1030,845526,128,"Beden Eğitimi",0,0,-7]
[31,1031,845525,129,"Fen Bilimleri/Fen ve Teknoloji",0,0,-7]
[32,1032,845524,130,"Rehberlik",0,0,-7]
[33,1033,845523,131,"Sosyal Bilgiler",{"$f":"SUMIFS(I39:KY39,$I$5:$KY$5,\"RAPORLU\")","v":0},{"$f":"SUMIFS(I39:KY39,$I$5:$KY$5,\"KESİNTİ\")","v":0},-7]
[34,1034,845522,132,"Okul Öncesi Öğrt",0,0,-7]
[35,1035,845521,133,"Din Kült. ve Ahl.Bil.",0,0,-7]
[36,1036,845520,134,"Bilişim Teknolojileri",0,0,-7]
[37,1037,845519,135,"İngilizce",0,0,-7]
[38,1038,845518,136,"Sosyal Bilgiler",0,0,-7]
[39,1039,845517,137,"Türkçe",0,0,-7]
[40,1040,845516,138,"Din Kült. ve Ahl.Bil.",0,0,-7]
[41,1041,845515,139,"Görsel Sanatlar",0,0,-7]
[42,1042,845514,140,"Müzik",0,0,-7]
[43,1043,845513,141,"İngilizce",0,0,-7]
[44,1044,845512,142,"Fen Bilimleri/Fen ve Teknoloji",0,0,-7]
[45,1045,845511,143,"İngilizce",0,0,-7]
[46,1046,845510,144,"Sosyal Bilgiler",0,0,-7]
[47,1047,845509,145,"İngilizce",0,0,-7]
[48,1048,845508,146,"Bilişim Teknolojileri",0,0,-7]
[49,1049,845507,147,"Teknoloji ve Tasarım",0,0,-7]
[50,1050,845506,148,"Türkçe",0,0,-7]
[51,1051,845505,149,"Türkçe",0,0,-7]
[52,1052,845504,150,"Fen Bilimleri/Fen ve Teknoloji",0,0,-7]
[53,1053,845503,151,"Sosyal Bilgiler",0,0,-7]
[54,1054,845502,152,"Okul Öncesi Öğrt",0,0,-7]
[55,1055,845501,153,"Türkçe",0,0,-7]
[56,1056,845500,154,"Fen Bilimleri/Fen ve Teknoloji",0,0,-7]
[57,1057,845499,155,"Rehberlik",0,0,-7]
[58,1058,845498,156,"İlköğretim Matematik Öğr.",0,0,-7]
[59,1059,845497,157,"Teknoloji ve Tasarım",0,0,-7]
[60,1060,845496,158,"Türkçe",0,0,-7]
[61,1061,845495,159,"Beden Eğitimi",0,0,-7]
[62,1062,845494,160,"İlköğretim Matematik Öğr.",0,0,-7]
[63,1063,845493,161,"Türkçe",0,0,-7]
[64,1064,845492,162,"İngilizce",0,0,-7]
[65,1065,845491,163,"Türkçe",{"$f":"SUMIFS(I71:KY71,$I$5:$KY$5,\"RAPORLU\")","v":0},{"$f":"SUMIFS(I71:KY71,$I$5:$KY$5,\"KESİNTİ\")","v":0},-7]
[{"$f":"IF(B72=\"\",\"\",ROW(A66))","v":66},1066,845490,164,"Türkçe",0,0,{"$f":"F72-7-G72","v":-7}]
[67,1067,845489,165,"Beden Eğitimi",0,0,-7]
[68,1068,845488,166,"Fen Bilimleri/Fen ve Teknoloji",0,0,-7]
[69,1069,845487,167,"Rehberlik",0,0,-7]
[70,1070,845486,168,"Sosyal Bilgiler",0,0,-7]
[71,1071,845485,169,"Okul Öncesi Öğrt",0,0,-7]
[72,1072,845484,170,"Din Kült. ve Ahl.Bil.",0,0,-7]
[73,1073,845483,171,"Bilişim Teknolojileri",0,0,-7]
[74,1074,845482,172,"İngilizce",0,0,-7]
[75,1075,845481,173,"Sosyal Bilgiler",0,0,-7]
[76,1076,845480,174,"Türkçe",0,0,-7]
[77,1077,845479,175,"Din Kült. ve Ahl.Bil.",0,0,-7]
[78,1078,845478,176,"Görsel Sanatlar",0,0,-7]
[79,1079,845477,177,"Müzik",0,0,-7]
[80,1080,845476,178,"İngilizce",0,0,-7]
[81,1081,845475,179,"Fen Bilimleri/Fen ve Teknoloji",0,0,-7]
[82,1082,845474,180,"İngilizce",0,0,-7]
[83,1083,845473,181,"Sosyal Bilgiler",0,0,-7]
[84,1084,845472,182,"İngilizce",0,0,-7]
[85,1085,845471,183,"Bilişim Teknolojileri",0,0,-7]
[86,1086,845470,184,"Teknoloji ve Tasarım",0,0,-7]
[87,1087,845469,185,"Türkçe",0,0,-7]
[88,1088,845468,186,"Türkçe",0,0,-7]
["",null,null,null,null,0,0,-7]
["",null,null,null,null,0,0,-7]
["",null,null,null,null,0,0,-7]
["",null,null,null,null,0,0,-7]
["",null,null,null,null,0,0,-7]
["",null,null,null,null,0,0,-7]
["",null,null,null,null,0,0,-7]
["",null,null,null,null,0,0,-7]
["",null,null,null,null,0,0,-7]
["",null,null,null,null,0,0,-7]
["",null,null,null,null,0,0,-7]
["",null,null,null,null,0,0,-7]

{"sheet":"RAPOR","index":2,"n_rows":48,"n_cols":8,"rows_kept":48,"cut":false,"hidden":false,"merged":[[46,6,46,7],[47,6,47,7],[46,1,46,2],[47,1,47,2],[44,1,44,3],[43,5,43,6],[0,0,0,7],[1,0,1,7],[2,0,2,7],[6,5,6,7],[3,6,3,7],[4,6,4,7],[3,0,3,1],[4,0,4,1],[6,1,6,2],[6,3,6,4],[3,2,3,3],[3,4,3,5],[4,4,4,5],[4,2,4,3]]}
["…………………………... KAYMAKAMLIĞI"]
["……………………………………………………..  LİSESİ MÜDÜRLÜĞÜ"]
["RAPOR-İZİNLERİN MAAŞTAN DÜŞÜM ÇİZELGESİ"]
["Personel Adı-Soyadı :",null,"T.C. Kimlik No",null,"Sicil No",null,"GÖREVİ"]
["b",null,1002,null,845554,null,"Türkçe"]
[]
[null,"RAPORLU",null,"KESİNTİ",null,"DİĞER İZİN ÇEŞİTLERİ"]
["Sıra No","TARİH","GÜN","TARİH ","GÜN","ÇEŞİT","TARİH","GÜN"]
[1,"2020-01-14",2,"2020-01-16",2,"YILLIK İZİN","2020-01-19",2]
[2,"2020-01-17",2]
[3,"2020-01-20",2]
[4,"2020-01-21",2]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"RAPORLU GÜN SAYISI",{"$f":"SUM(C9:C43)","v":8},"TOPLAM KESİLEN GÜN ",{"$f":"SUM(E9:E43)","v":2},"DİĞER İZİN TOPLAMI",null,{"$f":"SUM(H9:H43)","v":2}]
[null,"KESİLMESİ GEREKEN GÜN SAYISI",null,null,{"$f":"C44-E44-7","v":-1}]
[]
[null,"xxxxxx",null,null,null,null,"xxxxx"]
[null,"Müdür Yardımcısı",null,null,null,null,"Okul Müdürü"]

{"sheet":"AYLIK","index":3,"n_rows":48,"n_cols":14,"rows_kept":48,"cut":false,"hidden":false,"merged":[[4,4,4,6],[4,7,4,9],[4,10,4,13],[0,0,0,13],[1,0,1,13],[2,0,2,13],[3,0,3,13]]}
["…………………………………………….. KAYMAKAMLIĞI"]
["……………………………………………………………………… LİSESİ MÜDÜRLÜĞÜ"]
["01.01.2020 - 31.01.2020 TARİHLERİ ARASI PERSONEL DEVAMSIZLIK TAKİP ÇİZELGESİ"]
[]
[null,null,null,null,"RAPORLU",null,null,"KESİNTİ",null,null,"DİĞER İZİN ÇEŞİTLERİ"]
["S.NO","T.C. KİMLİK NO","ADI, SOYADI","BRANŞI","TARİH","GÜN","AÇIKLAMA","TARİH","GÜN","AÇIKLAMA","ÇEŞİDİ","TARİH","GÜN","AÇIKLAMA"]
[1,1001,"a","Sosyal Bilgiler","2020-01-14",1]
[2,1001,"a","Sosyal Bilgiler","2020-01-15",1]
[3,1001,"a","Sosyal Bilgiler",null,null,null,null,null,null,"YILLIK İZİN","2020-01-19",1]
[4,1001,"a","Sosyal Bilgiler","2020-01-20",1]
[5,1001,"a","Sosyal Bilgiler","2020-01-21",1]
[6,1001,"a","Sosyal Bilgiler",null,null,null,null,null,null,"Sevkli","2020-01-22",1]
[7,1002,"b","Türkçe","2020-01-14",2]
[8,1002,"b","Türkçe","2020-01-17",2]
[9,1002,"b","Türkçe",null,null,null,null,null,null,"YILLIK İZİN","2020-01-19",2]
[10,1002,"b","Türkçe","2020-01-20",2]
[11,1002,"b","Türkçe","2020-01-21",2]
[12,1002,"b","Türkçe",null,null,null,null,null,null,"Sevkli","2020-01-16",7,"xx"]
[13,1002,"b","Türkçe",null,null,null,"2020-01-16",8,"rr"]
[14,1003,"c","Din Kült. ve Ahl.Bil.","2020-01-14",5]
[15,1003,"c","Din Kült. ve Ahl.Bil.","2020-01-17",12]
[16,1003,"c","Din Kült. ve Ahl.Bil.",null,null,null,null,null,null,"YILLIK İZİN","2020-01-19",1]
[17,1004,"d","Görsel Sanatlar","2020-01-14",6]
[18,1004,"d","Görsel Sanatlar",null,null,null,"2020-01-18",6]
[19,1004,"d","Görsel Sanatlar","2020-01-20",1]
[20,1005,"e","Müzik","2020-01-14",7]
[21,1005,"e","Müzik","2020-01-17",14]
[22,1005,"e","Müzik","2020-01-21",1]
[23,1006,104,"İngilizce","2020-01-14",8]
[24,1006,104,"İngilizce",null,null,null,null,null,null,"Sevkli","2020-01-22",1]
[25,1007,105,"Fen Bilimleri/Fen ve Teknoloji","2020-01-14",9]
[26,1008,106,"İngilizce","2020-01-14",10]
[27,1009,107,"Sosyal Bilgiler","2020-01-14",11]
[28,1010,108,"İngilizce","2020-01-14",12]
[29,1011,109,"Bilişim Teknolojileri","2020-01-14",13]
[30,1012,110,"Teknoloji ve Tasarım","2020-01-14",14]
[31,1013,111,"Türkçe","2020-01-14",15]
[32,1014,112,"Türkçe","2020-01-14",16]
[33,1015,113,"Fen Bilimleri/Fen ve Teknoloji","2020-01-14",17]
[34,1016,114,"Sosyal Bilgiler","2020-01-14",18]
[35,1017,115,"Okul Öncesi Öğrt","2020-01-14",19]
[36,1018,116,"Türkçe","2020-01-14",20]
[37,1019,117,"Fen Bilimleri/Fen ve Teknoloji","2020-01-14",21]
[38,1020,118,"Rehberlik","2020-01-14",22]
[39,1021,119,"İlköğretim Matematik Öğr.","2020-01-14",23]
[40,1022,120,"Teknoloji ve Tasarım","2020-01-14",24]
[41,1023,121,"Türkçe","2020-01-14",25]
[42,1024,122,"Beden Eğitimi","2020-01-14",26]