{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["AÇILIŞ","KURUM BİLGİLERİ","PERSONEL BİLGİLERİ","PUANTAJ GİRİŞİ","BORDRO","BANKA LİSTESİ","VERGİ MATRAHI","ÖRNEK ÖEB"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":0,"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":"AÇILIŞ","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"KURUM BİLGİLERİ","index":1,"n_rows":14,"n_cols":3,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
["Bakanlık Adı","MİLLİ EĞİTİM BAKANLIĞI"]
["İl-İlçe","ÇANKIRI-YAPRAKLI"]
["Okul Adı"," Yapraklı İlçe Milli Eğitim Müd."]
["Saymanlık Adı","Yapraklı Malmüdürlüğü"]
["Saymanlık Kodu"]
["Vergi No"]
["Vergi Dairesi"]
["SGK Sicil No"]
["Banka Şubesi","Yapraklı"]
["Banka Hesap No"]
["Mutemet","…..............","Memur"]
["Gerçekleştirme Görevlisi","Ümit YURTOĞLU","Şube Müdürü"]
["Harcama Yetkilisi","Hüseyin BALTA","İlçe Milli Eğitim Müdürü"]
["Muhasebe Yetkilisi","…..........","Malmüdürü"]

{"sheet":"PERSONEL BİLGİLERİ","index":2,"n_rows":19,"n_cols":23,"rows_kept":19,"cut":false,"hidden":false,"merged":[[10,22,11,22],[1,15,2,15],[1,16,2,21],[1,22,2,22],[10,15,11,15],[10,16,11,16],[10,17,11,17],[10,18,11,18],[10,19,11,19],[10,20,11,20],[10,21,11,21]]}
["Sıra No","Adı Soyadı","TC KİMLİK NO","İBAN ","Medeni Hali","AGİ"]
[1,"Ümit YURTOĞLU",22222222222,"TR….................","Çalışan eş-4 Çocuk",{"$f":"IF(E2=I$4,V$5,IF(E2=I$5,V$6,IF(E2=I$6,V$7,IF(OR(E2=I$7,E2=I$11),V$8,IF(OR(E2=I$8,E2=I$13),V$9,IF(I$9=E2,V$15,IF(I$10=E2,V$18,IF(I$12=E2,V$18))))))))","v":429.3},null,null,null,null,null,null,null,null,null,"Eşi Çalışmayanlar için asgari geçim indirimi","Asgari ücretinizi brüt olarak yazınız:",null,null,null,null,null,3577.5]
[2,"Ali SEĞMEN",111111111,"TR12345657896633","Çalışmayan eş-1 Çocuk",{"$f":"IF(E3=I$4,V$5,IF(E3=I$5,V$6,IF(E3=I$6,V$7,IF(OR(E3=I$7,E3=I$11),V$8,IF(OR(E3=I$8,E3=I$13),V$9,IF(I$9=E3,V$15,IF(I$10=E3,V$18,IF(I$12=E3,V$18))))))))","v":362.22187500000001}]
[3,null,null,null,null,false,null,null,"Bekar",null,null,null,null,null,null,"Asgari geçim indiriminden yararlanan","Oranlar"]
[4,null,null,null,null,false,null,null,"Çalışmayan eş-0 Çocuk",null,null,null,null,null,null,"Çalışanın kendisi ",0.5,null,{"$f":"W2*50/100","v":1788.75},null,{"$f":"S5*15/100","v":268.3125},{"$f":"U5","v":268.3125},"Çalışanın kendisi (bekar)"]
[5,null,null,null,null,false,null,null,"Çalışmayan eş-1 Çocuk",null,null,null,null,null,null,"Çalışmayan ve herhangi bir geliri olmayan eş ",0.1,null,{"$f":"W2*10/100","v":357.75},null,{"$f":"S6*15/100","v":53.662500000000001},{"$f":"U5+U6","v":321.97500000000002},"Evli eşi çalışmayan ve çocuksuz"]
[6,null,null,null,null,false,null,null,"Çalışmayan eş-2 Çocuk",null,null,null,null,null,null,"1. çocuk ",7.4999999999999997E-2,null,{"$f":"W2*7.5/100","v":268.3125},null,{"$f":"S7*15/100","v":40.246875000000003},{"$f":"U5+U6+U7","v":362.22187500000001},"Evli eşi çalışmayan ve 1 çocuklu"]
[7,null,null,null,null,false,null,null,"Çalışmayan eş-3 Çocuk",null,null,null,null,null,null,"2. çocuk ",7.4999999999999997E-2,null,{"$f":"W2*7.5/100","v":268.3125},null,{"$f":"S8*15/100","v":40.246875000000003},{"$f":"U5+U6+U7+U8","v":402.46875},"Evli eşi çalışmayan ve 2 çocuklu"]
[8,null,null,null,null,false,null,null,"Çalışan eş-1 Çocuk",null,null,null,null,null,null,"3. çocuk ",0.1,null,{"$f":"W2*10/100","v":357.75},null,{"$f":"S9*15/100","v":53.662500000000001},{"$f":"U5+U6+U7+U8+U9","v":456.13125000000002},"Evli eşi çalışmayan ve 3 çocuklu üst sınır"]
[9,null,null,null,null,false,null,null,"Çalışan eş-2 Çocuk"]
[10,null,null,null,null,false,null,null,"Çalışan eş-3 Çocuk",null,null,null,null,null,null,"Eşi Çalışanlar için asgari geçim indirimi"]
[11,null,null,null,null,false,null,null,"Çalışan eş-4 Çocuk"]
[12,null,null,null,null,false,null,null,"Çalışan eş-5 Çocuk",null,null,null,null,null,null,"Asgari geçim indiriminden yararlanan","Oranlar"]
[13,null,null,null,null,false,null,null,null,null,null,null,null,null,null,"Çalışanın kendisi ",0.5,null,{"$f":"W2*50/100","v":1788.75},null,{"$f":"S14*15/100","v":268.3125},{"$f":"U14","v":268.3125},"Evli eşi çalışan ve çocuksuz"]
[14,null,null,null,null,false,null,null,null,null,null,null,null,null,null,"1. çocuk ",7.4999999999999997E-2,null,{"$f":"W2*7.5/100","v":268.3125},null,40.246875000000003,{"$f":"U14+U15","v":308.55937499999999},"Evli eşi çalışan ve 1 çocuklu"]
[15,null,null,null,null,false,null,null,null,null,null,null,null,null,null,"2. çocuk ",7.4999999999999997E-2,null,{"$f":"W2*7.5/100","v":268.3125},null,40.246875000000003,{"$f":"U14+U15+U16","v":348.80624999999998},"Evli eşi çalışan ve 2 çocuklu"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"3. çocuk ",0.1,null,{"$f":"W2*10/100","v":357.75},null,53.662500000000001,{"$f":"U14+U15+U16+U17","v":402.46875},"Evli eşi çalışan ve 3 çocuklu"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"4. çocuk ",0.05,null,{"$f":"W2*5/100","v":178.875},null,26.831250000000001,{"$f":"U14+U15+U16+U17+U18","v":429.3},"Evli eşi çalışan ve 4 çocuklu"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"5. çocuk",0.05,null,{"$f":"W2*5/100","v":178.875},null,26.831250000000001,{"$f":"U14+U15+U16+U17+U18+U19","v":456.13125000000002},"Evli eşi çalışan ve 5 çocuklu üst sınır"]

{"sheet":"PUANTAJ GİRİŞİ","index":3,"n_rows":17,"n_cols":39,"rows_kept":17,"cut":false,"hidden":false,"merged":[[1,0,1,1],[2,0,2,1],[5,3,6,3],[5,0,6,0],[5,1,6,1],[5,2,6,2],[5,38,6,38],[5,37,6,37],[5,36,6,36],[1,2,1,3],[2,2,2,3],[5,35,6,35],[1,30,1,33],[2,30,2,33],[1,34,1,35],[2,34,2,35]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,23.21,"GÜNDÜZ-İYEP"]
["Dairesi veya Okul Adı",null,{"$f":"'KURUM BİLGİLERİ'!B3:B3","v":" Yapraklı İlçe Milli Eğitim Müd."},null,null,null,null,null,null,null,null,null,null,null,null,null,null,24.87,"GECE-İYEP",null,null,null,null,null,null,null,null,null,null,null,"Ait Olduğu Yıl",null,null,null,2021]
["İşyeri Sicil No",null,{"$f":"'KURUM BİLGİLERİ'!B8:B8","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,46.42,"TAKVİYE KURSU GÜNDÜZ",null,null,null,null,null,null,null,null,null,null,null,"Ait Olduğu Ay",null,null,null,2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,49.74,"TAKVİYE KURSU GECE"]
[]
["Sıra No","TC. Kimlik No","Adı Soyadı","Ek Ders Türü (Açılır Listeden Seçiniz)",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,"G. Toplam","KATSAYI","BRÜT ÜCRET","TOPLAM ÜCRET"]
[null,null,null,null,"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ı","Çarşamba"]
[1,{"$f":"'PERSONEL BİLGİLERİ'!C2","v":22222222222},{"$f":"'PERSONEL BİLGİLERİ'!B2","v":"Ümit YURTOĞLU"},"GÜNDÜZ-İYEP",4,2,7,8,4,null,null,5,100,5,8,4,null,null,5,2,7,8,4,null,null,5,2,7,8,4,null,null,5,2,7,{"$f":"SUM(E8:AI8)","v":213},{"$f":"IF(D8=$S$1,$R$1,IF(D8=$S$2,$R$2,IF(D8=$S$3,$R$3,IF(D8=$S$4,$R$4))))","v":23.21},{"$f":"AJ8*AK8","v":4943.7300000000005},{"$f":"SUM(AL8:AL8)","v":4943.7300000000005}]
[2,{"$f":"'PERSONEL BİLGİLERİ'!C3","v":111111111},{"$f":"'PERSONEL BİLGİLERİ'!B3","v":"Ali SEĞMEN"},"GECE-İYEP",2,5,6,8,4,null,null,5,6,5,6,5,null,null,6,6,6,6,6,null,null,6,6,6,6,6,null,null,6,6,6,{"$f":"SUM(E9:AI9)","v":130},24.87,{"$f":"AJ9*AK9","v":3233.1},{"$f":"AL9","v":3233.1}]
[3,{"$f":"'PERSONEL BİLGİLERİ'!C4","v":0},{"$f":"'PERSONEL BİLGİLERİ'!B4","v":0},null,null,null,null,null,null,null,null,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,false,0,{"$f":"AL10","v":0}]
[4,{"$f":"'PERSONEL BİLGİLERİ'!C5","v":0},{"$f":"'PERSONEL BİLGİLERİ'!B5","v":0},null,null,null,null,null,null,null,null,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,false,0,0]
[5,{"$f":"'PERSONEL BİLGİLERİ'!C6","v":0},{"$f":"'PERSONEL BİLGİLERİ'!B6","v":0},null,null,null,null,null,null,null,null,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,false,0,0]
[6,{"$f":"'PERSONEL BİLGİLERİ'!C7","v":0},{"$f":"'PERSONEL BİLGİLERİ'!B7","v":0},null,null,null,null,null,null,null,null,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,false,0,0]
[7,{"$f":"'PERSONEL BİLGİLERİ'!C8","v":0},{"$f":"'PERSONEL BİLGİLERİ'!B8","v":0},null,null,null,null,null,null,null,null,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,false,0,0]
[8,{"$f":"'PERSONEL BİLGİLERİ'!C9","v":0},{"$f":"'PERSONEL BİLGİLERİ'!B9","v":0},null,null,null,null,null,null,null,null,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,false,0,0]
[9,{"$f":"'PERSONEL BİLGİLERİ'!C10","v":0},{"$f":"'PERSONEL BİLGİLERİ'!B10","v":0},null,null,null,null,null,null,null,null,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,false,0,0]
[10,{"$f":"'PERSONEL BİLGİLERİ'!C11","v":0},{"$f":"'PERSONEL BİLGİLERİ'!B11","v":0},null,null,null,null,null,null,null,null,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,false,0,0]

{"sheet":"BORDRO","index":4,"n_rows":14,"n_cols":21,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,20,3,20],[1,12,3,12],[1,1,3,1],[1,13,3,13],[1,14,1,19],[2,19,3,19],[0,2,0,16],[1,0,3,0],[1,2,3,2],[1,3,3,3],[1,4,3,4],[2,11,3,11],[1,10,3,10],[1,5,1,9]]}
[null,null,"YAPRAKLI İLÇE MİLLİ EĞİTİM MÜDÜRLÜĞÜ 2021-ŞUBAT AYI EK DERS KARŞILIĞI ÇALIŞAN ÖĞRETMENLER ÜCRET BORDROSU"]
["Sıra No","Adı Soyadı","TC. ","Ders Saati Toplam","Ek Ders Ücreti BRÜT","SGK",null,null,null,null,"TOPLAM (PEK)","AGİ","GEÇMİŞ AYLAR VERGİ MATRAH TOPLAMI","VERGİ MATRAHI","KESİNTİLER",null,null,null,null,null,"NET ELE GEÇEN"]
[null,null,null,null,null,"Prim Gün Sayısı","SGDP","SGK Prim işveren(mal-yaş-öl)","GSSP işveren","Kısa V. Sig. Kol.-işveren",null,"Tutar",null,null,"GELİR VERGİSİ","DAMGA VERGİSİ","SGDP DEVLET","SGK PRİM KİŞİ(mal-yaş-öl)","GSSP KİŞİ","TOPLAM KESİNTİ"]
[null,null,null,null,null,7.5,0.22500000000000001,0.11,7.4999999999999997E-2,0.02,null,null,null,null,0.15,7.5900000000000004E-3,0.22500000000000001,0.09,0.05]
[1,{"$f":"'PERSONEL BİLGİLERİ'!B2","v":"Ümit YURTOĞLU"},{"$f":"'PERSONEL BİLGİLERİ'!C2","v":22222222222},{"$f":"SUM('PUANTAJ GİRİŞİ'!AJ8:AJ8)","v":213},{"$f":"'PUANTAJ GİRİŞİ'!AL8","v":4943.7300000000005},{"$f":"ROUNDUP(D5/$F$4,0)","v":29},null,{"$f":"E5*$H$4","v":543.8103000000001},{"$f":"E5*$I$4","v":370.77975000000004},{"$f":"E5*$J$4","v":98.874600000000015},{"$f":"SUM(E5,H5:J5)","v":5957.1946500000004},{"$f":"'PERSONEL BİLGİLERİ'!F2","v":429.3},{"$f":"'VERGİ MATRAHI'!O2","v":6251.61},{"$f":"E5-R5-S5","v":4251.6078000000007},{"$f":"N5*$O$4","v":637.74117000000012},{"$f":"E5*$P$4","v":37.522910700000004},null,{"$f":"E5*$R$4","v":444.93570000000005},{"$f":"E5*$S$4","v":247.18650000000002},{"$f":"SUM(O5:S5)","v":1367.3862807000003},{"$f":"E5+L5-T5","v":4005.6437193000002}]
[2,{"$f":"'PERSONEL BİLGİLERİ'!B3","v":"Ali SEĞMEN"},{"$f":"'PERSONEL BİLGİLERİ'!C3","v":111111111},{"$f":"SUM('PUANTAJ GİRİŞİ'!AJ9:AJ9)","v":130},{"$f":"'PUANTAJ GİRİŞİ'!AL9","v":3233.1},{"$f":"ROUNDUP(D6/$F$4,0)","v":18},null,{"$f":"E6*$H$4","v":355.64100000000002},{"$f":"E6*$I$4","v":242.48249999999999},{"$f":"E6*$J$4","v":64.662000000000006},{"$f":"SUM(E6,H6:J6)","v":3895.8854999999999},{"$f":"'PERSONEL BİLGİLERİ'!F3","v":362.22187500000001},{"$f":"'VERGİ MATRAHI'!O3","v":4280.4699999999993},2780.4659999999999,{"$f":"N6*$O$4","v":417.06989999999996},{"$f":"E6*$P$4","v":24.539228999999999},null,{"$f":"E6*$R$4","v":290.97899999999998},{"$f":"E6*$S$4","v":161.655},{"$f":"SUM(O6:S6)","v":894.24312899999995},2701.0787460000001]
[3,{"$f":"'PERSONEL BİLGİLERİ'!B4","v":0},{"$f":"'PERSONEL BİLGİLERİ'!C4","v":0},{"$f":"SUM('PUANTAJ GİRİŞİ'!AJ10:AJ10)","v":0},{"$f":"'PUANTAJ GİRİŞİ'!AL10","v":0},0,null,0,0,0,0,{"$f":"'PERSONEL BİLGİLERİ'!F4","v":false},{"$f":"'VERGİ MATRAHI'!O4","v":0},0,0,0,null,0,0,0,0]
[4,{"$f":"'PERSONEL BİLGİLERİ'!B5","v":0},{"$f":"'PERSONEL BİLGİLERİ'!C5","v":0},{"$f":"SUM('PUANTAJ GİRİŞİ'!AJ11:AJ11)","v":0},{"$f":"'PUANTAJ GİRİŞİ'!AL11","v":0},0,null,0,0,0,0,{"$f":"'PERSONEL BİLGİLERİ'!F5","v":false},{"$f":"'VERGİ MATRAHI'!O5","v":0},0,0,0,null,0,0,0,0]
[5,{"$f":"'PERSONEL BİLGİLERİ'!B6","v":0},{"$f":"'PERSONEL BİLGİLERİ'!C6","v":0},{"$f":"SUM('PUANTAJ GİRİŞİ'!AJ12:AJ12)","v":0},{"$f":"'PUANTAJ GİRİŞİ'!AL12","v":0},0,null,0,0,0,0,{"$f":"'PERSONEL BİLGİLERİ'!F6","v":false},{"$f":"'VERGİ MATRAHI'!O6","v":0},0,0,0,null,0,0,0,0]
[6,{"$f":"'PERSONEL BİLGİLERİ'!B7","v":0},{"$f":"'PERSONEL BİLGİLERİ'!C7","v":0},{"$f":"SUM('PUANTAJ GİRİŞİ'!AJ13:AJ13)","v":0},{"$f":"'PUANTAJ GİRİŞİ'!AL13","v":0},0,null,0,0,0,0,{"$f":"'PERSONEL BİLGİLERİ'!F7","v":false},{"$f":"'VERGİ MATRAHI'!O7","v":0},0,0,0,null,0,0,0,0]
[7,{"$f":"'PERSONEL BİLGİLERİ'!B8","v":0},{"$f":"'PERSONEL BİLGİLERİ'!C8","v":0},{"$f":"SUM('PUANTAJ GİRİŞİ'!AJ14:AJ14)","v":0},{"$f":"'PUANTAJ GİRİŞİ'!AL14","v":0},0,null,0,0,0,0,{"$f":"'PERSONEL BİLGİLERİ'!F8","v":false},{"$f":"'VERGİ MATRAHI'!O8","v":0},0,0,0,null,0,0,0,0]
[8,{"$f":"'PERSONEL BİLGİLERİ'!B9","v":0},{"$f":"'PERSONEL BİLGİLERİ'!C9","v":0},{"$f":"SUM('PUANTAJ GİRİŞİ'!AJ15:AJ15)","v":0},{"$f":"'PUANTAJ GİRİŞİ'!AL15","v":0},0,null,0,0,0,0,{"$f":"'PERSONEL BİLGİLERİ'!F9","v":false},{"$f":"'VERGİ MATRAHI'!O9","v":0},0,0,0,null,0,0,0,0]
[9,{"$f":"'PERSONEL BİLGİLERİ'!B10","v":0},{"$f":"'PERSONEL BİLGİLERİ'!C10","v":0},{"$f":"SUM('PUANTAJ GİRİŞİ'!AJ16:AJ16)","v":0},{"$f":"'PUANTAJ GİRİŞİ'!AL16","v":0},0,null,0,0,0,0,{"$f":"'PERSONEL BİLGİLERİ'!F10","v":false},{"$f":"'VERGİ MATRAHI'!O10","v":0},0,0,0,null,0,0,0,0]
[10,{"$f":"'PERSONEL BİLGİLERİ'!B11","v":0},{"$f":"'PERSONEL BİLGİLERİ'!C11","v":0},{"$f":"SUM('PUANTAJ GİRİŞİ'!AJ17:AJ17)","v":0},{"$f":"'PUANTAJ GİRİŞİ'!AL17","v":0},0,null,0,0,0,0,{"$f":"'PERSONEL BİLGİLERİ'!F11","v":false},{"$f":"'VERGİ MATRAHI'!O11","v":0},0,0,0,null,0,0,0,0]

{"sheet":"BANKA LİSTESİ","index":5,"n_rows":45,"n_cols":5,"rows_kept":45,"cut":false,"hidden":false,"merged":[[38,1,38,3],[4,0,4,1],[5,0,5,2],[0,0,0,4],[1,0,1,1],[2,0,2,1],[3,0,3,1],[43,3,43,4],[44,3,44,4],[41,0,41,1],[41,3,41,4],[40,0,40,1],[42,3,42,4],[42,0,42,1],[43,0,43,1],[44,0,44,1]]}
["BANKA LİSTESİ"]
["Muhasebe Biriminin Adı",null,{"$f":"'KURUM BİLGİLERİ'!B4","v":"Yapraklı Malmüdürlüğü"},"Muhasebe Biriminin Kodu",{"$f":"'KURUM BİLGİLERİ'!B5","v":0}]
["Harcama Biriminin Adı",null,"İlçe Milli Eğitim Müdürlüğü","Harcama Biriminin Kodu",285]
["Banka Adı",null,"Halkbank","Şube Adı",{"$f":"'KURUM BİLGİLERİ'!B2","v":"ÇANKIRI-YAPRAKLI"}]
["Ücretin Ait Olduğu Yıl",null,2020,"Ücretin Ait Olduğu Ay","ŞUBAT"]
[]
["SN","T.C. Kimlik No","Adı Soyadı","Banka Hesap No / IBAN","Ödenecek Net Aylık Tutar"]
[1,{"$f":"BORDRO!C5","v":22222222222},{"$f":"'PERSONEL BİLGİLERİ'!B2","v":"Ümit YURTOĞLU"},{"$f":"'PERSONEL BİLGİLERİ'!D2","v":"TR…................."},{"$f":"BORDRO!U5","v":4005.6437193000002}]
[2,{"$f":"BORDRO!C6","v":111111111},{"$f":"'PERSONEL BİLGİLERİ'!B3","v":"Ali SEĞMEN"},{"$f":"'PERSONEL BİLGİLERİ'!D3","v":"TR12345657896633"},{"$f":"BORDRO!U6","v":2701.0787460000001}]
[3,{"$f":"BORDRO!C7","v":0},{"$f":"'PERSONEL BİLGİLERİ'!B4","v":0},{"$f":"'PERSONEL BİLGİLERİ'!D4","v":0},{"$f":"BORDRO!U7","v":0}]
[4,{"$f":"BORDRO!C8","v":0},{"$f":"'PERSONEL BİLGİLERİ'!B5","v":0},{"$f":"'PERSONEL BİLGİLERİ'!D5","v":0},{"$f":"BORDRO!U8","v":0}]
[5,{"$f":"BORDRO!C9","v":0},{"$f":"'PERSONEL BİLGİLERİ'!B6","v":0},{"$f":"'PERSONEL BİLGİLERİ'!D6","v":0},{"$f":"BORDRO!U9","v":0}]
[6,{"$f":"BORDRO!C10","v":0},{"$f":"'PERSONEL BİLGİLERİ'!B7","v":0},{"$f":"'PERSONEL BİLGİLERİ'!D7","v":0},{"$f":"BORDRO!U10","v":0}]
[7,{"$f":"BORDRO!C11","v":0},{"$f":"'PERSONEL BİLGİLERİ'!B8","v":0},{"$f":"'PERSONEL BİLGİLERİ'!D8","v":0},{"$f":"BORDRO!U11","v":0}]
[8,{"$f":"BORDRO!C12","v":0},{"$f":"'PERSONEL BİLGİLERİ'!B9","v":0},{"$f":"'PERSONEL BİLGİLERİ'!D9","v":0},{"$f":"BORDRO!U12","v":0}]
[9,{"$f":"BORDRO!C13","v":0},{"$f":"'PERSONEL BİLGİLERİ'!B10","v":0},{"$f":"'PERSONEL BİLGİLERİ'!D10","v":0},{"$f":"BORDRO!U13","v":0}]
[10,{"$f":"BORDRO!C14","v":0},{"$f":"'PERSONEL BİLGİLERİ'!B11","v":0},{"$f":"'PERSONEL BİLGİLERİ'!D11","v":0},{"$f":"BORDRO!U14","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Sayfa Toplamı :",null,null,{"$f":"SUM(E8:E38)","v":6706.7224653000003}]
[]
["Kayıtlarımıza uygundur."]
["…./..../2021",null,null,"…./..../2021"]
["Gerçekleştirme Görevlisi",null,null,"Harcama Yetkilisi"]
[{"$f":"'KURUM BİLGİLERİ'!B12","v":"Ümit YURTOĞLU"},null,null,{"$f":"'KURUM BİLGİLERİ'!B13","v":"Hüseyin BALTA"}]
[{"$f":"'KURUM BİLGİLERİ'!C12","v":"Şube Müdürü"},null,null,{"$f":"'KURUM BİLGİLERİ'!C13","v":"İlçe Milli Eğitim Müdürü"}]

{"sheet":"VERGİ MATRAHI","index":6,"n_rows":18,"n_cols":15,"rows_kept":18,"cut":false,"hidden":false,"merged":[[12,0,12,14],[13,0,13,14],[15,0,15,14],[17,0,17,14]]}
["Sıra No","Adı Soyadı","OCAK","ŞUBAT","MART","NİSAN","MAYIS","HAZİRAN","TEMMUZ","AĞUSTOS","EYLÜL","EKİM","KASIM","ARALIK","TOPLAM"]
[1,{"$f":"BORDRO!B5","v":"Ümit YURTOĞLU"},2000,4251.6099999999997,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(C2:N2)","v":6251.61}]
[2,{"$f":"BORDRO!B6","v":"Ali SEĞMEN"},1500,2780.47,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(C3:N3)","v":4280.4699999999993}]
[3,{"$f":"BORDRO!B7","v":0},null,null,null,null,null,null,null,null,null,null,null,null,0]
[4,{"$f":"BORDRO!B8","v":0},null,null,null,null,null,null,null,null,null,null,null,null,0]
[5,{"$f":"BORDRO!B9","v":0},null,null,null,null,null,null,null,null,null,null,null,null,0]
[6,{"$f":"BORDRO!B10","v":0},null,null,null,null,null,null,null,null,null,null,null,null,0]
[7,{"$f":"BORDRO!B11","v":0},null,null,null,null,null,null,null,null,null,null,null,null,0]
[8,{"$f":"BORDRO!B12","v":0},null,null,null,null,null,null,null,null,null,null,null,null,0]
[9,{"$f":"BORDRO!B13","v":0},null,null,null,null,null,null,null,null,null,null,null,null,0]
[10,{"$f":"BORDRO!B14","v":0},null,null,null,null,null,null,null,null,null,null,null,null,0]
[]
["AÇIKLAMALAR!!!"]
["2021 YILI GELİR VERGİSİ DİLİMLERİ                                                                                                                                                                                                                                                                                                  24.000 TL'ye kadar 15%\n53.000 TL'nin 24.000 TL'si için 3.600 TL, fazlası 20%\n130.000 TL'nin 53.000 TL'si için 9.400 TL (ücret gelirlerinde 190.000 TL'nin 53.000 TL'si için 9.400 TL), fazlası 27%\n650.000 TL'nin 130.000 TL'si için 30.190 TL (ücret gelirlerinde 650.000 TL'nin 190.000 TL'si için 46.390 TL), fazlası 35%\n650.000 TL'den fazlasının 650.000 TL'si için 212.190 TL (ücret gelirlerinde 650.000 TL'den fazlasının 650.000 TL'si için 207.390 TL), fazlası 40%"]
[]
["1-) Ücretli öğretmenlerimiz yıl içerisinde %15'lik dilimden bir üst dilime geçemezler. Fakat  %20'lik dilime geçme durumları ortaya çıkarsa Gelir Vergisi hesaplamasını %20'lik dilime yükseltmeniz gerekebilir. Bu durumda bordroda gelir vergisi sutununda ilgili öğretmeni %20 ile çarpınız."]
[]
["2-) İşlemlerinizin sağlıklı olabilmesi için hesaplama yaptığınız her aya ait vergi matrahı kısmını yukarıdaki tabloya aktarınız. Toplam tutar bir üst dilime çıktığında 1. maddeye göre hareket ediniz."]

{"sheet":"ÖRNEK ÖEB","index":7,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}