{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["ekim 2022","Ayar"],"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":"ekim 2022","index":0,"n_rows":88,"n_cols":52,"rows_kept":88,"cut":false,"hidden":false,"merged":[[4,0,5,0],[4,1,5,1],[4,2,5,2],[4,3,5,3],[4,4,4,34],[0,0,0,40],[0,42,0,43],[0,44,0,45],[0,46,0,49],[1,0,3,26],[1,27,2,33],[1,34,2,40],[1,42,1,43],[1,44,1,45],[1,46,1,49],[15,4,15,40],[18,2,18,3],[18,29,18,38],[21,2,21,3],[21,29,21,38],[22,2,22,3],[22,29,22,38],[2,42,2,43],[2,44,2,47],[3,27,3,33],[3,34,3,40],[23,33,23,38],[29,0,29,40],[30,30,30,39],[31,1,31,13],[31,14,34,15],[31,16,34,17],[31,18,34,21],[31,22,34,23],[31,24,34,26],[31,27,34,30],[31,31,34,33],[31,34,34,38],[31,39,34,40],[32,0,34,0],[32,1,34,1],[32,2,34,2],[32,3,34,3],[32,4,34,7],[32,8,34,13],[36,4,36,7],[36,8,36,13],[36,14,36,15],[36,16,36,17],[36,18,36,21],[35,4,35,7],[35,8,35,13],[35,14,35,15],[35,16,35,17],[35,18,35,21],[36,22,36,23],[36,24,36,26],[36,27,36,30],[36,31,36,33],[36,34,36,38],[36,39,36,40],[35,24,35,26],[35,27,35,30],[35,31,35,33],[35,34,35,38],[35,39,35,40],[35,22,35,23],[38,4,38,7],[38,8,38,13],[38,14,38,15],[38,16,38,17],[38,18,38,21],[37,4,37,7],[37,8,37,13],[37,14,37,15],[37,16,37,17],[37,18,37,21],[38,22,38,23],[38,24,38,26],[38,27,38,30],[38,31,38,33],[38,34,38,38],[38,39,38,40],[37,24,37,26],[37,27,37,30],[37,31,37,33],[37,34,37,38],[37,39,37,40],[37,22,37,23],[40,4,40,7],[40,8,40,13],[40,14,40,15],[40,16,40,17],[40,18,40,21],[39,4,39,7],[39,8,39,13],[39,14,39,15],[39,16,39,17],[39,18,39,21],[40,22,40,23],[40,24,40,26],[40,27,40,30],[40,31,40,33],[40,34,40,38],[40,39,40,40],[39,24,39,26],[39,27,39,30],[39,31,39,33],[39,34,39,38],[39,39,39,40],[39,22,39,23],[42,4,42,7],[42,8,42,13],[42,14,42,15],[42,16,42,17],[42,18,42,21],[41,4,41,7],[41,8,41,13],[41,14,41,15],[41,16,41,17],[41,18,41,21],[42,22,42,23],[42,24,42,26],[42,27,42,30],[42,31,42,33],[42,34,42,38],[42,39,42,40],[41,24,41,26],[41,27,41,30],[41,31,41,33],[41,34,41,38],[41,39,41,40],[41,22,41,23],[48,3,48,15],[48,27,48,33],[51,3,51,16],[51,27,51,33],[52,3,52,16],[52,27,52,33],[43,0,43,33],[43,34,43,38],[43,39,43,40],[44,0,44,40],[45,0,45,2],[46,0,46,2],[66,0,66,33],[67,0,68,0],[67,1,68,1],[67,2,68,3],[67,4,67,33],[68,4,68,23],[68,24,68,33],[63,0,63,33],[64,0,64,1],[64,2,64,33],[65,0,65,1],[65,4,65,25],[65,26,65,33],[72,2,72,3],[72,4,72,23],[72,24,72,33],[69,2,69,3],[69,4,69,23],[69,24,69,33],[70,2,70,3],[70,4,70,23],[70,24,70,33],[86,5,86,23],[87,5,87,23],[4,42,4,49],[77,0,77,23],[77,24,77,33],[79,0,79,2],[79,3,79,4],[80,0,80,2],[83,5,83,23],[75,2,75,3],[75,4,75,23],[75,24,75,33],[76,2,76,3],[76,4,76,23],[76,24,76,33],[73,2,73,3],[73,4,73,23],[73,24,73,33],[74,2,74,3],[74,4,74,23],[74,24,74,33],[71,2,71,3],[71,4,71,23],[71,24,71,33]]}
["STAJYER ÖĞRENCİ PUANTAJ ÇİZELGESİ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,{"$f":"YEAR(AU1)","v":2022},null,"2022-10-31",null,null,null,{"$f":"DATE(YEAR(AU1),MONTH(AU1),DAY(AU1-(AU1-1)))","v":"2022-10-01"},{"$f":"DATE(YEAR(AU1),MONTH(AU1)+1,1)-1","v":"2022-10-31"}]
["K U R U M U: YAKAKENT ÇOK PROGRAMLI ANADOLU LİSESİ MÜDÜRLÜĞÜ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AİT OLDUĞU DÖNEM",null,null,null,null,null,null,{"$f":"AU2","v":false},null,null,null,null,null,null,null,"Ait Olduğu Ay ",null,"X",null,{"$f":"IF(AS2=1,\"OCAK\",IF(AS2=2,\"ŞUBAT\",IF(AS2=3,\"MART\",IF(AS2=4,\"NİSAN\",IF(AS2=5,\"MAYIS\",IF(AS2=6,\"HAZİRAN\",IF(AS2=7,\"TEMMUZ\",IF(AS2=8,\"AĞUSTOS\",IF(AS2=9,\"EYLÜL\",IF(AS2=10,\"EKİM\",IF(AS2=11,\"KASIM\",IF(AS2=12,\"ARALIK\"))))))))))))","v":false}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Toplam Ödeme",null,{"$f":"DOLLAR(AI44)","v":"₺3.300,22"}]
[null,null,null,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 YILI",null,null,null,null,null,null,{"$f":"YEAR(AU1)","v":2022}]
["S.NO","ADI SOYADI","ÜNVANI","T.C.Kimlik No",{"$f":"AI2","v":false},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Çalışılan gün","Resmi Tatil","Teorik eğitim (İzinli)","Raporlu","Gelmediği gün","TOPLAM",null,"ÖNCE İLGİLİ AYIN SON GÜNÜNÜ YAZIN DİĞERLERİ OTOMATİK OLARAK GELİR"]
[null,null,null,null,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,"D","T","İ","R","G"]
[1,"X","Stajyer Öğrenci","X","T","T","D","D","D","D","D","T","T","D","D","D","D","D","T","T","D","D","D","D","D","T","T","D","D","D","D","D","T","T","D",{"$f":"IF(B7>\"0\",COUNTIF(E7:AI7,\"D\"),\"\")","v":21},{"$f":"IF(B7>\"0\",COUNTIF(E7:AI7,\"T\"),\"\")","v":10},{"$f":"IF(B7>\"0\",COUNTIF(E7:AI7,\"İ\"),\"\")","v":0},{"$f":"IF(B7>\"0\",COUNTIF(E7:AI7,\"R\"),\"\")","v":0},{"$f":"IF(B7>\"0\",COUNTIF(E7:AI7,\"G\"),\"\")","v":0},{"$f":"IF(B7>\"0\",SUM(AJ7:AN7),\"\")","v":31}]
[2,"X","Stajyer Öğrenci","X","T","T","D","D","D","D","D","T","T","D","D","D","D","D","T","T","D","D","D","D","D","T","T","D","D","D","D","D","T","T","D",{"$f":"IF(B8>\"0\",COUNTIF(E8:AI8,\"D\"),\"\")","v":21},{"$f":"IF(B8>\"0\",COUNTIF(E8:AI8,\"T\"),\"\")","v":10},{"$f":"IF(B8>\"0\",COUNTIF(E8:AI8,\"İ\"),\"\")","v":0},{"$f":"IF(B8>\"0\",COUNTIF(E8:AI8,\"R\"),\"\")","v":0},{"$f":"IF(B8>\"0\",COUNTIF(E8:AI8,\"G\"),\"\")","v":0},{"$f":"IF(B8>\"0\",SUM(AJ8:AN8),\"\")","v":31}]
[3]
[4]
[5]
[6]
[7]
[8]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,{"$f":"AY1","v":"2022-10-01"},{"$f":"AZ1","v":"2022-10-31"},{"$f":"AI4","v":2022},"tarihleri arasında okulumuzda stayjer öğrenci olarak görev yapanlara ait puantaj cetvelidir."]
[]
[]
[null,null,"DÜZENLEYEN",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ONAY"]
[]
[]
[null,"ADI SOYADI :","Taha TOK",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tahsin CEYLAN"]
[null,"ÜNVANI :","Müdür Yardımcısı",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Okul Müdürü"]
[]
[]
[]
[]
[]
[]
["YAKAKENT ÇOK PROGRAMLI ANADOLU LİSESİNDE MESLEKİ EĞİTİM GÖREN ÖĞRENCİLERİN AYLIK  ÜCRET BORDROSU \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,null,null,null,null,null,"Ay İçindeki Staj Günü Toplamı :",null,null,null,null,null,null,null,null,null,30]
[null,"STAJYER ÖĞRENCİNİN",null,null,null,null,null,null,null,null,null,null,null,null,"Devam (gün)",null,"Devamsız Gün",null,"Asgari Ücretin Net Tutarı",null,null,null,"Oran",null,"GÜNLÜK ÜCRET",null,null,"Stajyer Öğrenci Ücreti",null,null,null,"Devamsız Gün Kesinti Tutarı",null,null,"Net Ödenen",null,null,null,null,"İmza "]
["S.No","Adı Soyadı","Ünvanı","T.C.Kimlik No","STAJ YILI",null,null,null,"STAJ AYI"]
[]
[]
[1,{"$f":"B7","v":"X"},{"$f":"C7","v":"Stajyer Öğrenci"},"X",2022,null,null,null,{"$f":"AU2","v":false},null,null,null,null,null,{"$f":"AO31-AN7","v":30},null,{"$f":"AO31-O36","v":0},null,5500.35,null,null,null,0.3,null,{"$f":"(AB36/30)","v":55.00366666666666},null,null,{"$f":"IF(B36>\"0\",ROUND((S36*$W$36),2),\" \")","v":1650.11},null,null,null,{"$f":"Y36*Q36","v":0},null,null,{"$f":"AB36-AF36","v":1650.11}]
[2,{"$f":"B8","v":"X"},"Stajyer Öğrenci","X",2022,null,null,null,{"$f":"AU2","v":false},null,null,null,null,null,{"$f":"AO31-AN8","v":30},null,{"$f":"AO31-O37","v":0},null,5500.35,null,null,null,0.3,null,{"$f":"(AB36/30)","v":55.00366666666666},null,null,{"$f":"IF(B37>\"0\",ROUND((S37*$W$36),2),\" \")","v":1650.11},null,null,null,{"$f":"Y37*Q37","v":0},null,null,{"$f":"AB37-AF37","v":1650.11}]
[3,null,null,null,null,null,null,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":"IF(B38>\"0\",AB38-Q38,\" \")","v":" "}]
[4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[5,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[6,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[7,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[8,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
["GENEL 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,null,null,null,null,null,null,null,{"$f":"SUM((AI36:AI43))","v":3300.22}]
[{"$f":"\"2022-2023 Eğitim-Öğretim Yılı Stajyer Öğrencilerin \"&I36&\"  ayına ait Maaş tutarı \"&AS3&\"'dir.\"","v":"2022-2023 Eğitim-Öğretim Yılı Stajyer Öğrencilerin YANLIŞ  ayına ait Maaş tutarı ₺3.300,22'dir."}]
["İşletmedeki Personel Sayısı        :",null,null,2]
["Ödenecek ücretin üst sınırı (TL)  :",null,null,{"$f":"AB36","v":1650.11}]
[]
[null,null,null,"DÜZENLEYEN",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ONAY"]
[]
[]
[null,null,"ADI SOYADI :",{"$f":"C22","v":"Taha TOK"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AD22","v":"Tahsin CEYLAN"}]
[null,null,"ÜNVANI :",{"$f":"C23","v":"Müdür Yardımcısı"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AD23","v":"Okul Müdürü"}]
[]
["M.Y.H.B.Y. Örnek No:13"]
[]
[]
[]
[]
[]
[]
[]
[]
["B   A   N   K   A       L   İ   S   T   E   S   İ"]
["KURUM ADI",null,"YAKAKENT ÇOK PROGRAMLI ANADOLU LİSESİ MÜDÜRLÜĞÜ"]
["AİT OLDUĞU AY",null,2022,"YILI","EYLÜL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AYI"]
["EK DERS  ÜCRETİ"]
["Sıra No","ADI VE SOYADI","T.C.KİMLİK NO",null,"HAVALE EDİLEN TUTAR"]
[null,null,null,null,"HESAP NO",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BORDRO ELE GEÇEN"]
[1,{"$f":"B36","v":"X"},{"$f":"D36","v":"X"},null,"X",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AI36","v":1650.11}]
[2,{"$f":"B37","v":"X"},{"$f":"D37","v":"X"},null,"X",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AI37","v":1650.11}]
[3]
[4]
[5]
[6]
[7]
[8]
["T   O   P   L   A   M",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(Y70:Y77)","v":3300.22}]
[]
["Bordro Kayıtlarına uygun olarak",null,null,{"$f":"Y78","v":3300.22}]
["Ödenmesi lazımdır."]
[]
[]
[" ",null,null,null,null,"HARCAMA YETKİLİSİ"]
[]
[null,null,null,null,null," "]
[null,null,null,null,null,{"$f":"AB52","v":"Tahsin CEYLAN"}]
[null,null,null,null,null,{"$f":"AB53","v":"Okul Müdürü"}]

{"sheet":"Ayar","index":1,"n_rows":12,"n_cols":3,"rows_kept":12,"cut":false,"hidden":true,"merged":[]}
["2018-12-01"]
["2018-12-30"]
["Aydın DERİN"]
["Müdür Başyardımcısı"]
["Osman ŞAFAK"]
["Okul Müdürü"]
["YAKAKENT ÇO PROGRAMLI ANADOLU LİSESİ"]
["YAKAKENT/SAMSUN"]
[0]
[0]
[1,100,"Brüt Ders Saatleri (Reh./Kulüp Hariç)"]
[false]