{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["5510 SONRASI(istifa)","5510 ÖNCESİ (Ücretsiz İzin) ","5510 SONRASI (Ücretsiz İzin.)"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":3,"comments":3,"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":"5510 SONRASI(istifa)","index":0,"n_rows":58,"n_cols":9,"rows_kept":58,"cut":false,"hidden":false,"merged":[[53,6,53,8],[54,6,54,8],[56,6,56,8],[57,6,57,8],[54,3,54,4],[55,3,55,4],[56,3,56,4],[57,3,57,4],[55,6,55,8],[53,3,53,4],[47,2,47,7],[50,2,50,8],[48,2,48,7],[46,2,46,3],[51,2,51,8],[0,2,0,8],[1,2,1,8],[10,7,10,8],[29,3,29,4],[29,5,29,6],[29,7,29,8],[5,3,5,4],[6,3,6,4],[3,6,3,8],[2,2,2,8],[7,3,7,4],[7,6,7,8],[4,3,4,4],[4,6,4,8],[5,6,5,8],[8,2,8,8],[10,11,10,20],[6,6,6,8],[36,3,36,4],[10,3,10,4],[10,5,10,6],[9,2,9,8],[36,7,36,8],[36,5,36,6],[28,2,28,8],[27,2,27,8],[35,2,35,8],[34,2,34,8]]}
[null,null,"YERSİZ VE FAZLA ÖDENEN AYLIKLARDAN DOĞAN"]
[null,null,"               KİŞİLERDEN ALACAKLARI HESAPLAMA CETVELİ   5510 SONRASI     "]
[]
[null,null,"Tahakkuk Birimi","Odunpazarı Malmüdürlüğü",null,"Borç Nedeni","Görevden Çekilme"]
[null,null,"Borçlunun Adı Soyadı",null,null,"Hizmet Süresi"]
[null,null,"Sicil Nosu",null,null,"İlişki Kesme Tarih"]
[null,null,"Unvanı",null,null,"T.C.KİMLİK NO"]
[null,null,"Ödenmiş Gün ",31,null,"Çalıştığı Gün",1]
[]
[null,null,"TABLO 1 : AYLIK VE YAN ÖDEMELER "]
[null,null,"AYLIK                               UNSURLARI","TAHAKKUK                              ETTİRİLEN (A)",null,"TAHAKKUK ETTİRİLMESİ GEREKEN (B)",null,"FARK (C)"]
[null,null,"Aylık",114.3,null,{"$f":"(D12/D8)*G8","v":3.6870967741935483},null,null,{"$f":"D12-F12","v":110.61290322580645}]
[null,null,"Taban Aylığı",2417.6999999999998,null,{"$f":"(D13/D8)*G8","v":77.990322580645156},null,null,{"$f":"D13-F13","v":2339.7096774193546}]
[null,null,"Kıdem Aylığı",18.54,null,{"$f":"(D14/D8)*G8","v":0.59806451612903222},null,null,{"$f":"D14-F14","v":17.941935483870967}]
[null,null,"Ek Gösterge",77.23,null,{"$f":"(D15/D8)*G8","v":2.4912903225806451},null,null,74.738709677419365]
[null,null,"Özel Hizmet Tazminatı",1458.61,null,{"$f":"(D16/D8)*G8","v":47.051935483870963},null,null,1411.558064516129]
[null,null,"Sendika ödeneği",115.85,null,{"$f":"(D17/D8)*G8","v":3.7370967741935481},null,null,112.11290322580645]
[null,null,"Aile ve Çocuk Yardımı*",0,null,{"$f":"(D18)","v":0},null,null,0]
[null,null,"Makam Tazminatı",null,null,{"$f":"(D19/D8)*G8","v":0},null,null,0]
[null,null,"Dil Tazminatı",null,null,{"$f":"(D20/D8)*G8","v":0},null,null,0]
[null,null,"Yan Ödeme",50.74,null,{"$f":"(D21/D8*G8)","v":1.6367741935483873},null,null,49.103225806451611]
[null,null,"İdari Görev Ö.",0,null,{"$f":"(D22/D8)*G8","v":0},null,null,0]
[null,null,"Ek Ödeme",953.8,null,{"$f":"(D23/D8)*G8","v":30.767741935483869},null,null,923.0322580645161]
[null,null,"Eğitim Öğretim Ödeneği",0,null,{"$f":"(D24/D8)*G8","v":0},null,null,0]
[null,null,"Gelişme Güçlüğü (*)",0,null,{"$f":"(D25)","v":0},null,null,0]
[null,null,"Üniversite Ödeneği",0,null,{"$f":"(D26/D8)*G8","v":0},null,null,0]
[null,null,"TOPLAM",{"$f":"SUM(D12:D26)","v":5206.7700000000004},null,{"$f":"SUM(F12:F26)","v":167.96032258064514},null,"(1)",{"$f":"SUM(I12:I26)","v":5038.8096774193546}]
[]
[null,null,"TABLO 2 : KESİNTİ YAPILAN KATKI PAYLARI "]
[null,null,"AYLIK                               UNSURLARI","FİİLEN ÖDENEN             (A)",null,"HAK EDİLEN (B)",null,"FARK (C)"]
[null,null,"Mal. yaş.ve Em. Prim %11 Dev.",459.1,null,{"$f":"D31/30*G8","v":15.303333333333335},null,null,{"$f":"D31-F31","v":443.79666666666668}]
[null,null,"Genel sağlık sig. %7,5 Dev.",313.02,null,{"$f":"D32/30*G8","v":10.433999999999999},null,null,{"$f":"D32-F32","v":302.58599999999996}]
[null,null,"TOPLAM",{"$f":"SUM(D31:D32)","v":772.12},null,{"$f":"SUM(F31:F32)","v":25.737333333333332},null,"(2)**",{"$f":"SUM(I31:I32)","v":746.38266666666664}]
[null,null,"Hakediş Toplamı",{"$f":"(D27+D33)","v":5978.89}]
[]
[null,null,"TABLO 3 : YASAL KESİNTİLER "]
[null,null,"AYLIK                               UNSURLARI","FİİLEN KESİLEN             (A)",null,"KESİLMESİ GEREKEN (B)",null,"FARK (C)"]
[null,null,"Gelir Vergisi",165.02,null,{"$f":"(D38/D8)*G8","v":5.3232258064516129},null,null,{"$f":"(D38-F38)","v":159.69677419354841}]
[null,null,"Damga Vergisi",39.33,null,{"$f":"(D39/D8)*G8","v":1.2687096774193547},null,null,{"$f":"(D39-F39)","v":38.061290322580646}]
[null,null,"Mal. yaş.ve Em. Prim %9 Kişi",null,null,{"$f":"D40","v":0},null,null,{"$f":"D40-F40","v":0}]
[null,null,"Genel sağlık sig. %5 Kişi",0,null,{"$f":"D41","v":0},null,null,{"$f":"D41-F41","v":0}]
[null,null,"Mal. yaş.ve Em. Prim %11 Dev.",{"$f":"(D31)","v":459.1},null,{"$f":"D42/30*G8","v":15.303333333333335},null,null,{"$f":"D42-F42","v":443.79666666666668}]
[null,null,"Genel sağlık sig. %7,5 Dev.",{"$f":"(D32)","v":313.02},null,{"$f":"D43/30*G8","v":10.433999999999999},null,null,{"$f":"D43-F43","v":302.58599999999996}]
[]
[null,null,"TOPLAM",{"$f":"SUM(D38:D44)","v":976.47},null,{"$f":"SUM(F38:F44)","v":32.329268817204301},null,"(3)",{"$f":"SUM(I38:I44)","v":944.14073118279566}]
[]
[null,null,"140 NOLU HESAP",null,null,{"$f":"(I27+I33)","v":5785.192344086021}]
[null,null,"KİŞİDEN ALINACAK TUTAR",null,null,null,null,null,{"$f":"I27+I33-I38-I39","v":5587.4342795698913}]
[]
[]
[null,null," "]
[]
[]
[null,null,null,"Harcama Yetkilisi"]
[null,null,"Adı ve Soyadı    :"]
[null,null,"Unvanı               :"]
[null,null,"Tebliğ Tarih    :"]
[null,null,"İmza                  :"]

{"sheet":"5510 ÖNCESİ (Ücretsiz İzin) ","index":1,"n_rows":60,"n_cols":15,"rows_kept":60,"cut":false,"hidden":false,"merged":[[24,12,25,17],[0,3,0,9],[1,3,1,9],[2,3,2,9],[3,7,3,9],[4,4,4,5],[4,7,4,9],[5,4,5,5],[5,7,5,9],[6,4,6,5],[6,6,6,9],[7,4,7,5],[7,7,7,9],[35,4,35,5],[35,6,35,7],[35,8,35,9],[8,3,8,9],[9,3,9,9],[10,4,10,5],[10,6,10,7],[10,8,10,9],[27,3,27,9],[28,3,28,9],[29,4,29,5],[29,6,29,7],[29,8,29,9],[34,3,34,9],[53,3,53,9],[55,4,55,5],[55,7,55,9],[45,3,45,6],[46,3,46,6],[48,3,48,5],[49,3,49,8],[50,3,50,8],[52,3,52,9]]}
[null,null,null,"YERSİZ VE FAZLA ÖDENEN AYLIKLARDAN DOĞAN"]
[null,null,null,"                KİŞİLERDEN ALACAKLARI HESAPLAMA CETVELİ     5510 ÖNCESİ"]
[]
[null,null,null,"Tahakkuk Birimi","Odunpazarı Malmüdürlüğü",null,"Borç Nedeni","ÜCRETSİZ İZİN"]
[null,null,null,"Borçlunun Adı Soyadı",null,null,"Hizmet Süresi"]
[null,null,null,"Sicil Nosu",null,null,"İlişki Kesilme T"]
[null,null,null,"Unvanı",null,null,"T.C.NO:"]
[null,null,null,"Ödenmiş Gün ",31,null,"Çalıştığı Gün",18]
[]
[null,null,null,"TABLO 1 : AYLIK VE YAN ÖDEMELER "]
[null,null,null,"AYLIK                               UNSURLARI","TAHAKKUK                              ETTİRİLEN (A)",null,"TAHAKKUK ETTİRİLMESİ GEREKEN (B)",null,"FARK (C)"]
[null,null,null,"Aylık",191.48,null,{"$f":"(E12/E8)*H8","v":111.18193548387097},null,null,{"$f":"E12-G12","v":80.298064516129017}]
[null,null,null,"Taban Aylığı",2814.19,null,{"$f":"(E13/E8)*H8","v":1634.0458064516129},null,null,{"$f":"E13-G13","v":1180.1441935483872}]
[null,null,null,"Kıdem Aylığı",50.34,null,{"$f":"(E14/E8)*H8","v":29.229677419354843},null,null,{"$f":"E14-G14","v":21.11032258064516}]
[null,null,null,"Ek Gösterge",287.68,null,{"$f":"(E15/E8)*H8","v":167.04},null,null,120.64000000000001]
[null,null,null,"Özel Hizmet Tazminatı",1973.85,null,{"$f":"(E16/E8)*H8","v":1146.1064516129031},null,null,827.74354838709678]
[null,null,null,"Sendika ödeneği *",0,null,{"$f":"(E17)","v":0},null,null,0]
[null,null,null,"Aile ve Çocuk Yardımı*",0,null,{"$f":"SUM(E18)","v":0},null,null,0]
[null,null,null,"Çocuk Yardımı",0,null,{"$f":"SUM(E19)","v":0},null,null,0]
[null,null,null,"Dil Tazminatı",0,null,{"$f":"(E20/E8)*H8","v":0},null,null,0]
[null,null,null,"Yan Ödeme",42.76,null,{"$f":"(E21/E8)*H8","v":24.828387096774193},null,null,17.931612903225805]
[null,null,null,"İdari Görev Ö",0,null,{"$f":"(E22/E8)*H8","v":0}]
[null,null,null,"Ek ödeme",1110.25,null,{"$f":"(E23/E8)*H8","v":644.66129032258061},null,null,465.58870967741939,null,null,"2008  YILI EYLÜL AYINDAN "]
[null,null,null,null,null,null,{"$f":"(E24/E8)*H8","v":0},null,null,0]
[null,null,null,null,null,null,null,null,null,0,null,null,"ÖNCE GÖREVE BAŞLAYANLAR"]
[null,null,null,"Artış %100 Devlet",0,null,{"$f":"(E26/E8)*H8","v":0},null,null,0]
[null,null,null,"TOPLAM",{"$f":"SUM(E12:E26)","v":6470.55},null,{"$f":"SUM(G12:G26)","v":3757.0935483870967},null,"(1)",{"$f":"SUM(J12:J26)","v":2713.4564516129035}]
[]
[null,null,null,"TABLO 2 : KESİNTİ YAPILAN KATKI PAYLARI "]
[null,null,null,"AYLIK                               UNSURLARI","FİİLEN ÖDENEN             (A)",null,"HAK EDİLEN (B)",null,"FARK (C)"]
[null,null,null,"Emekli Keseneği %20",856.63,null,null,null,null,{"$f":"E31-G31","v":856.63}]
[null,null,null,"Genel Sağlık S.% 12",513.98,null,null,null,null,{"$f":"E32-G32","v":513.98},null,null,null,null,{"$f":"-D2","v":{"$error":"#VALUE!"}}]
[null,null,null,"TOPLAM",{"$f":"SUM(E31:E32)","v":1370.6100000000001},null,{"$f":"SUM(G31:G32)","v":0},null,"(2)**",{"$f":"SUM(J31:J32)","v":1370.6100000000001}]
[null,null,null,"Hakediş Toplamı",{"$f":"(E27+E33)","v":7841.16}]
[null,null,null,"TABLO 3 : YASAL KESİNTİLER "]
[null,null,null,"AYLIK                               UNSURLARI","FİİLEN KESİLEN             (A)",null,"KESİLMESİ GEREKEN (B)",null,"FARK (C)"]
[null,null,null,"Gelir Vergisi",136.86000000000001,null,{"$f":"(E37/E8)*H8","v":79.46709677419355},null,null,{"$f":"(E37-G37)","v":57.392903225806464}]
[null,null,null,"Damga Vergisi",49.11,null,{"$f":"(E38/E8)*H8","v":28.515483870967742},null,null,{"$f":"(E38-G38)","v":20.594516129032257}]
[null,null,null,"İkraz",0,null,0,null,null,0]
[]
[]
[]
[]
[null,null,null,"TOPLAM",{"$f":"SUM(E37:E43)","v":185.97000000000003},null,{"$f":"SUM(G37:G43)","v":107.98258064516129},null,"(3)",{"$f":"SUM(J37:J43)","v":77.987419354838721}]
[]
[null,null,null,"5434-87.m.  Eğer Hizmet Süresi 5 yıldan fazla ise (1)+(2)"]
[null,null,null,"Eğer Hizmet Süresi 5 yıldan az ise (1)"]
[]
[null,null,null,"140 Nolu Hesaba alınacak",null,null,{"$f":"IF(H5>10,J27,IF(H5<=5,J27,J27+J33))","v":2713.4564516129035}]
[null,null,null,"KİŞİDEN ALINACAK TUTAR",null,null,null,null,null,{"$f":"IF(H5>10,J27-J44,IF(H5<=5,J27-J44,J27+J33-J44))","v":2635.4690322580645}]
[]
[]
[null,null,null," "]
[]
[]
[null,null,null,null,"HARCAMA YETKİLİSİ",null,null,"BORÇLU"]
[null,null,null,"Adı ve Soyadı   :"]
[null,null,null,"Unvanı            :",null,null,null,null,null,"Ayşe Ülkü ÖNER"]
[null,null,null,"Tebliğ Tarih    :"]
[null,null,null,"İmza               :"]

{"sheet":"5510 SONRASI (Ücretsiz İzin.)","index":2,"n_rows":58,"n_cols":18,"rows_kept":58,"cut":false,"hidden":false,"merged":[[12,11,13,18],[56,3,56,4],[56,6,56,8],[57,3,57,4],[57,6,57,8],[53,3,53,4],[53,6,53,8],[54,3,54,4],[54,6,54,8],[55,3,55,4],[55,6,55,8],[46,2,46,3],[47,2,47,7],[48,2,48,7],[50,2,50,8],[51,2,51,8],[34,2,34,8],[35,2,35,8],[36,3,36,4],[36,5,36,6],[36,7,36,8],[10,5,10,6],[10,7,10,8],[27,2,27,8],[28,2,28,8],[29,3,29,4],[29,5,29,6],[29,7,29,8],[10,11,10,20],[0,2,0,8],[1,2,1,8],[2,2,2,8],[3,6,3,8],[4,3,4,4],[4,6,4,8],[5,3,5,4],[5,6,5,8],[6,3,6,4],[6,5,6,8],[7,3,7,4],[7,6,7,8],[8,2,8,8],[9,2,9,8],[10,3,10,4]]}
[null,null,"YERSİZ VE FAZLA ÖDENEN AYLIKLARDAN DOĞAN"]
[null,null,"               KİŞİLERDEN ALACAKLARI HESAPLAMA CETVELİ   5510 SONRASI     "]
[]
[null,null,"Tahakkuk Birimi","Odunpazarı Mal Müd.",null,"Borç Nedeni"]
[null,null,"Borçlunun Adı Soyadı",null,null,"Hizmet Süresi"]
[null,null,"Sicil Nosu",null,null,"Adres ve Tlf."]
[null,null,"Unvanı",null,null,"T.C.Kimlik No:"]
[null,null,"Ödenmiş Gün ",31,null,"Çalıştığı Gün",18]
[]
[null,null,"TABLO 1 : AYLIK VE YAN ÖDEMELER "]
[null,null,"AYLIK                               UNSURLARI","TAHAKKUK                              ETTİRİLEN (A)",null,"TAHAKKUK ETTİRİLMESİ GEREKEN (B)",null,"FARK (C)",null,null,null,"2008 EYLÜL AYINDAN SONRA "]
[null,null,"Aylık",191.48,null,{"$f":"(D12/D8)*G8","v":111.18193548387097},null,null,{"$f":"D12-F12","v":80.298064516129017}]
[null,null,"Taban Aylığı",2814.19,null,{"$f":"(D13/D8)*G8","v":1634.0458064516129},null,null,{"$f":"D13-F13","v":1180.1441935483872},null,null,"GÖREVE BAŞLAYANLAR"]
[null,null,"Kıdem Aylığı",50.34,null,{"$f":"(D14/D8)*G8","v":29.229677419354843},null,null,{"$f":"D14-F14","v":21.11032258064516}]
[null,null,"Ek Gösterge",287.68,null,{"$f":"(D15/D8)*G8","v":167.04},null,null,120.64000000000001]
[null,null,"Özel Hizmet Tazminatı",1973.85,null,{"$f":"(D16/D8)*G8","v":1146.1064516129031},null,null,827.74354838709678]
[null,null,"Sendika ödeneği",0,null,{"$f":"(D17)","v":0},null,null,0]
[null,null,"Aile ve Çocuk Yardımı*",0,null,{"$f":"(D18)","v":0},null,null,0]
[null,null,null,null,null,{"$f":"(D19/D8)*G8","v":0},null,null,0]
[null,null,null,null,null,{"$f":"(D20/D8)*G8","v":0},null,null,0]
[null,null,"Yan Ödeme",42.76,null,{"$f":"(D21/D8)*G8","v":24.828387096774193},null,null,17.931612903225805]
[null,null,"İdari Görev Ödeneği",0,null,{"$f":"(D22/D8)*G8","v":0},null,null,0]
[null,null,"Ek Ödeme",1110.25,null,{"$f":"(D23/D8)*G8","v":644.66129032258061},null,null,465.58870967741939]
[null,null,"Eğitim Öğretim Ödeneği",0,null,{"$f":"(D24/D8)*G8","v":0},null,null,0,null,null,null,null,null,null,null,null," "]
[null,null,"Gelişme Güç/Sendika Ödnğ",0,null,{"$f":"(D25)","v":0},null,null,0]
[null,null,"Üniversite ödeneği",0,null,{"$f":"(D26/D8)*G8","v":0},null,null,0]
[null,null,"TOPLAM",{"$f":"SUM(D12:D26)","v":6470.55},null,{"$f":"SUM(F12:F26)","v":3757.0935483870967},null,"(1)",{"$f":"SUM(I12:I26)","v":2713.4564516129035}]
[]
[null,null,"TABLO 2 : KESİNTİ YAPILAN KATKI PAYLARI "]
[null,null,"AYLIK                               UNSURLARI","FİİLEN ÖDENEN             (A)",null,"HAK EDİLEN (B)",null,"FARK (C)"]
[null,null,"Emk.Kes.Mal.Yaş.Devlet",856.63,null,{"$f":"D31/30*G8","v":513.97799999999995},null,null,{"$f":"D31-F31","v":342.65200000000004}]
[null,null,"Sağlık Sig.Primi Dev.",513.98,null,{"$f":"D32/30*G8","v":308.38800000000003},null,null,{"$f":"D32-F32","v":205.59199999999998}]
[null,null,"TOPLAM",{"$f":"SUM(D31:D32)","v":1370.6100000000001},null,{"$f":"SUM(F31:F32)","v":822.36599999999999},null,"(2)**",{"$f":"SUM(I31:I32)","v":548.24400000000003}]
[null,null,"Hakediş Toplamı",{"$f":"(D27+D33)","v":7841.16}]
[]
[null,null,"TABLO 3 : YASAL KESİNTİLER "]
[null,null,"AYLIK                               UNSURLARI","FİİLEN KESİLEN             (A)",null,"KESİLMESİ GEREKEN (B)",null,"FARK (C)"]
[null,null,"Gelir Vergisi",136.86000000000001,null,{"$f":"(D38/D8)*G8","v":79.46709677419355},null,null,{"$f":"(D38-F38)","v":57.392903225806464}]
[null,null,"Damga Vergisi",49.11,null,{"$f":"(D39/D8)*G8","v":28.515483870967742},null,null,{"$f":"(D39-F39)","v":20.594516129032257}]
[null,null,"Sağlık Sig.Primi Dev.",513.98,null,{"$f":"D40/30*G8","v":308.38800000000003},null,null,{"$f":"D40-F40","v":205.59199999999998}]
[null,null,"Sağlık Sig.Primi Kişi",685.3,null,{"$f":"(D41)","v":685.3},null,null,{"$f":"D41-F41","v":0}]
[null,null,"Emk.Kes.Mal.Yaş.Devlet",856.63,null,{"$f":"D42/30*G8","v":513.97799999999995},null,null,{"$f":"D42-F42","v":342.65200000000004}]
[null,null,"Emk.Kes.Mal.Yaş.Kişi",685.3,null,{"$f":"(D43)","v":685.3},null,null,{"$f":"D43-F43","v":0}]
[null,null,"Sendika Kesintisi",0]
[null,null,"TOPLAM",{"$f":"SUM(D38:D44)","v":2927.1800000000003},null,{"$f":"SUM(F38:F44)","v":2300.9485806451612},null,"(3)",{"$f":"SUM(I38:I44)","v":626.23141935483875}]
[]
[null,null,"140 NOLU HESAP",null,null,{"$f":"(I27+I33)","v":3261.7004516129036}]
[null,null,"KİŞİDEN ALINACAK TUTAR",null,null,null,null,null,{"$f":"I27+I33-I38-I39-I40-I42","v":2635.4690322580645}]
[]
[]
[null,null," "]
[]
[]
[null,null,null,"Gerçekleştrime Görevlisi",null,null,"Borçlu"]
[null,null,"Adı ve Soyadı   :","Zübeyde ERTEN",null,null,"Aslıhan ACAR"]
[null,null,"Unvanı            :","Okul Müdürü"]
[null,null,"Tebliğ Tarih    :"]
[null,null,"İmza               :"]