{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["5510 SONRASI(istifa)","5510 SONRASI (Ücretsiz İzin.)","5510 ÖNCESİ "],"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":[[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],[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],[47,2,47,7],[50,2,50,8],[48,2,48,7],[46,2,46,3],[51,2,51,8],[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]]}
[null,null,"YERSİZ VE FAZLA ÖDENEN AYLIKLARDAN DOĞAN"]
[null,null,"               KİŞİLERDEN ALACAKLARI HESAPLAMA CETVELİ   5510 SONRASI     "]
[]
[null,null,"Tahakkuk Birimi",null,null,"Borç Nedeni","Askere Sevk "]
[null,null,"Borçlunun Adı Soyadı",null,null,"Hizmet Süresi","1 Ay"]
[null,null,"Sicil Nosu",null,null,"İlişki Kesilme t","2013-11-05"]
[null,null,"Unvanı",null,null,"TEL. "]
[null,null,"Ödenen Gün ",30,null,"Ödenecek Gün",20]
[]
[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",51.83,null,{"$f":"(D12/D8)*G8","v":34.553333333333335},null,null,{"$f":"D12-F12","v":17.276666666666664}]
[null,null,"Taban Aylığı",1027.5,null,{"$f":"(D13/D8)*G8","v":685},null,null,{"$f":"D13-F13","v":342.5}]
[null,null,"Kıdem Aylığı",0,null,{"$f":"(D14/D8)*G8","v":0},null,null,{"$f":"D14-F14","v":0}]
[null,null,"Ek Gösterge",0,null,{"$f":"(D15/D8)*G8","v":0},null,null,0]
[null,null,"Özel Hizmet Tazminatı",663.86,null,{"$f":"(D16/D8)*G8","v":442.57333333333338},null,null,221.28666666666663]
[null,null,"Sendika ödeneği",45,null,{"$f":"(D17/D8)*G8","v":30},null,null,15]
[null,null,"Aile ve Çocuk Yardımı*",0,null,{"$f":"(D18)","v":0},null,null,0]
[null,null,"Makam Tazminatı",0,null,{"$f":"(D19/D8)*G8","v":0},null,null,0]
[null,null,"Dil Tazminatı",0,null,{"$f":"(D20/D8)*G8","v":0},null,null,0]
[null,null,"Yan Ödeme",12.18,null,{"$f":"(D21/D8*G8)","v":8.1199999999999992},null,null,4.0600000000000005]
[null,null,"İdari Görev Ö.",0,null,{"$f":"(D22/D8)*G8","v":0},null,null,0]
[null,null,"Ek Ödeme",474.18,null,{"$f":"(D23/D8)*G8","v":316.12},null,null,158.06]
[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":2274.5500000000002},null,{"$f":"SUM(F12:F26)","v":1516.3666666666663},null,"(1)",{"$f":"SUM(I12:I26)","v":758.18333333333317}]
[]
[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.",191.75,null,{"$f":"D31/30*G8","v":127.83333333333333},null,null,{"$f":"D31-F31","v":63.916666666666671}]
[null,null,"Genel sağlık sig. %7,5 Dev.",130.74,null,{"$f":"D32/30*G8","v":87.160000000000011},null,null,{"$f":"D32-F32","v":43.58}]
[null,null,"TOPLAM",{"$f":"SUM(D31:D32)","v":322.49},null,{"$f":"SUM(F31:F32)","v":214.99333333333334},null,"(2)**",{"$f":"SUM(I31:I32)","v":107.49666666666667}]
[null,null,"Hakediş Toplamı",{"$f":"(D27+D33)","v":2597.04}]
[]
[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",93.82,null,{"$f":"(D38/D8)*G8","v":62.54666666666666},null,null,{"$f":"(D38-F38)","v":31.273333333333333}]
[null,null,"Damga Vergisi",17.260000000000002,null,{"$f":"(D39/D8)*G8","v":11.506666666666668},null,null,{"$f":"(D39-F39)","v":5.7533333333333339}]
[null,null,"Mal. yaş.ve Em. Prim %9 Kişi",156.88999999999999,null,{"$f":"D40","v":156.88999999999999},null,null,{"$f":"D40-F40","v":0}]
[null,null,"Genel sağlık sig. %5 Kişi",87.16,null,{"$f":"D41","v":87.16},null,null,{"$f":"D41-F41","v":0}]
[null,null,"Mal. yaş.ve Em. Prim %11 Dev.",{"$f":"(D31)","v":191.75},null,{"$f":"D42/30*G8","v":127.83333333333333},null,null,{"$f":"D42-F42","v":63.916666666666671}]
[null,null,"Genel sağlık sig. %7,5 Dev.",{"$f":"(D32)","v":130.74},null,{"$f":"D43/30*G8","v":87.160000000000011},null,null,{"$f":"D43-F43","v":43.58}]
[]
[null,null,"TOPLAM",{"$f":"SUM(D38:D44)","v":677.62},null,{"$f":"SUM(F38:F44)","v":533.09666666666669},null,"(3)",{"$f":"SUM(I38:I44)","v":144.52333333333334}]
[]
[null,null,"140 NOLU HESAP",null,null,{"$f":"(I27+I33)","v":865.67999999999984}]
[null,null,"KİŞİDEN ALINACAK TUTAR",null,null,null,null,null,{"$f":"I27+I33-I38-I39","v":828.65333333333319}]
[]
[]
[null,null," "]
[]
[]
[null,null,null,"Harcama Yetkilisi"]
[null,null,"Adı ve Soyadı    :"]
[null,null,"Unvanı               :"]
[null,null,"Tebliğ Tarih    :"]
[null,null,"İmza                  :"]

{"sheet":"5510 SONRASI (Ücretsiz İzin.)","index":1,"n_rows":58,"n_cols":9,"rows_kept":58,"cut":false,"hidden":false,"merged":[[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],[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],[34,2,34,8],[35,2,35,8],[36,3,36,4],[36,5,36,6],[36,7,36,8],[46,2,46,3],[47,2,47,7],[48,2,48,7],[50,2,50,8],[51,2,51,8],[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]]}
[null,null,"YERSİZ VE FAZLA ÖDENEN AYLIKLARDAN DOĞAN"]
[null,null,"               KİŞİLERDEN ALACAKLARI HESAPLAMA CETVELİ   5510 SONRASI     "]
[]
[null,null,"Tahakkuk Birimi",null,null,"Borç Nedeni","ücretsiz izin"]
[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,"TEL. "]
[null,null,"Ödenen Gün ",30,null,"Ödenecek Gün",3]
[]
[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",76,null,{"$f":"(D12/D8)*G8","v":7.6},null,null,{"$f":"D12-F12","v":68.400000000000006}]
[null,null,"Taban Aylığı",1607.65,null,{"$f":"(D13/D8)*G8","v":160.76500000000001},null,null,{"$f":"D13-F13","v":1446.885}]
[null,null,"Kıdem Aylığı",12.32,null,{"$f":"(D14/D8)*G8","v":1.232},null,null,{"$f":"D14-F14","v":11.088000000000001}]
[null,null,"Ek Gösterge",51.35,null,{"$f":"(D15/D8)*G8","v":5.1349999999999998},null,null,46.215000000000003]
[null,null,"Özel Hizmet Tazminatı",1029.96,null,{"$f":"(D16/D8)*G8","v":102.99600000000001},null,null,926.96400000000006]
[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,"Makam Tazminatı",0,null,{"$f":"(D19/D8)*G8","v":0},null,null,0]
[null,null,"Dil Tazminatı",0,null,{"$f":"(D20/D8)*G8","v":0},null,null,0]
[null,null,"Yan Ödeme",24.43,null,{"$f":"(D21/D8)*G8","v":2.4430000000000001},null,null,21.986999999999998]
[null,null,"İdari Görev Ödeneği",0,null,{"$f":"(D22/D8)*G8","v":0},null,null,0]
[null,null,"Ek Ödeme",634.21,null,{"$f":"(D23/D8)*G8","v":63.421000000000006},null,null,570.78899999999999]
[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":3435.9199999999996},null,{"$f":"SUM(F12:F26)","v":343.59199999999998},null,"(1)",{"$f":"SUM(I12:I26)","v":3092.3280000000004}]
[]
[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,"İsver MYO.11",305.5,null,{"$f":"D31/30*G8","v":30.55},null,null,{"$f":"D31-F31","v":274.95}]
[null,null,"İsver MYO.7,5",208.3,null,{"$f":"D32/30*G8","v":20.83},null,null,{"$f":"D32-F32","v":187.47000000000003}]
[null,null,"TOPLAM",{"$f":"SUM(D31:D32)","v":513.79999999999995},null,{"$f":"SUM(F31:F32)","v":51.379999999999995},null,"(2)**",{"$f":"SUM(I31:I32)","v":462.42}]
[null,null,"Hakediş Toplamı",{"$f":"(D27+D33)","v":3949.7199999999993}]
[]
[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",74.13,null,{"$f":"(D38/D8)*G8","v":7.4129999999999985},null,null,{"$f":"(D38-F38)","v":66.716999999999999}]
[null,null,"Damga Vergisi",26.08,null,{"$f":"(D39/D8)*G8","v":2.6079999999999997},null,null,{"$f":"(D39-F39)","v":23.471999999999998}]
[null,null,"Ücretli MYO.9",249.96,null,{"$f":"D40/30*G8","v":24.996000000000002},null,null,{"$f":"D40-F40","v":224.964}]
[null,null,"Ücretli MYO.5",138.86000000000001,null,{"$f":"(D41)","v":138.86000000000001},null,null,{"$f":"D41-F41","v":0}]
[null,null,"İsver MYO.11",{"$f":"(D31)","v":305.5},null,{"$f":"D42/30*G8","v":30.55},null,null,{"$f":"D42-F42","v":274.95}]
[null,null,"İsver MYO.7,5",208.3,null,{"$f":"(D43)","v":208.3},null,null,{"$f":"D43-F43","v":0}]
[]
[null,null,"TOPLAM",{"$f":"SUM(D38:D44)","v":1002.8299999999999},null,{"$f":"SUM(F38:F44)","v":412.72700000000003},null,"(3)",{"$f":"SUM(I38:I44)","v":590.10300000000007}]
[]
[null,null,"140 NOLU HESAP",null,null,{"$f":"(I27+I33)","v":3554.7480000000005}]
[null,null,"KİŞİDEN ALINACAK TUTAR",null,null,null,null,null,{"$f":"I27+I33-I38-I39-I40-I42","v":2964.6450000000004}]
[]
[]
[null,null," "]
[]
[]
[null,null,null,"Gerçekleştrime Görevlisi",null,null,"Borçlu"]
[null,null,"Adı ve Soyadı   :"]
[null,null,"Unvanı            :"]
[null,null,"Tebliğ Tarih    :"]
[null,null,"İmza               :"]

{"sheet":"5510 ÖNCESİ ","index":2,"n_rows":60,"n_cols":10,"rows_kept":60,"cut":false,"hidden":false,"merged":[[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],[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],[5,4,5,5],[5,7,5,9],[6,4,6,5],[6,6,6,9],[7,4,7,5],[7,7,7,9],[0,3,0,9],[1,3,1,9],[2,3,2,9],[3,7,3,9],[4,4,4,5],[4,7,4,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",null,null,"Borç Nedeni","ÜCRETSİZ İZİN"]
[null,null,null,"Borçlunun Adı Soyadı",null,null,"Hizmet Süresi",11]
[null,null,null,"Sicil Nosu",null,null,"İlişki Kesilme T","2017-10-30"]
[null,null,null,"Unvanı",null,null,"TEL. "]
[null,null,null,"Ödenen Gün ",31,null,"Ödenecek Gün",16]
[]
[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",109.38,null,{"$f":"(E12/E8)*H8","v":56.454193548387096},null,null,{"$f":"E12-G12","v":52.9258064516129}]
[null,null,null,"Taban Aylığı",1607.65,null,{"$f":"(E13/E8)*H8","v":829.75483870967741},null,null,{"$f":"E13-G13","v":777.89516129032268}]
[null,null,null,"Kıdem Aylığı",22.6,null,{"$f":"(E14/E8)*H8","v":11.664516129032259},null,null,{"$f":"E14-G14","v":10.935483870967742}]
[null,null,null,"Ek Gösterge",164.33,null,{"$f":"(E15/E8)*H8","v":84.815483870967753},null,null,79.514516129032259]
[null,null,null,"Özel Hizmet Tazminatı",926.92,null,{"$f":"(E16/E8)*H8","v":478.41032258064513},null,null,448.50967741935483]
[null,null,null,"Sendika ödeneği *",77.03,null,{"$f":"(E17)","v":77.03},null,null,0]
[null,null,null,"Aile ve Çocuk Yardımı*",219.17,null,{"$f":"SUM(E18)","v":219.17},null,null,0]
[null,null,null,"Çocuk Yardımı",179.74,null,{"$f":"SUM(E19)","v":179.74},null,null,0]
[null,null,null,"Dil Tazminatı",0,null,{"$f":"(E20/E8)*H8","v":0},null,null,0]
[null,null,null,"Yan Ödeme",16.29,null,{"$f":"(E21/E8)*H8","v":8.4077419354838714},null,null,7.8822580645161278]
[null,null,null,"İdari Görev Ö",0,null,{"$f":"(E22/E8)*H8","v":0}]
[null,null,null,"Ek ödeme",634.21,null,{"$f":"(E23/E8)*H8","v":327.33419354838713},null,null,306.8758064516129]
[null,null,null,"Eğitim Öğretim Ödeneği",0,null,{"$f":"(E24/E8)*H8","v":0},null,null,0]
[null,null,null,"Gelişme Güçlüğü (*)",0,null,null,null,null,0]
[null,null,null,"Üniversite Ödeneği",0,null,{"$f":"(E26/E8)*H8","v":0},null,null,0]
[null,null,null,"TOPLAM",{"$f":"SUM(E12:E26)","v":3957.3200000000006},null,{"$f":"SUM(G12:G26)","v":2272.7812903225808},null,"(1)",{"$f":"SUM(J12:J26)","v":1684.5387096774193}]
[]
[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",488.12,null,null,null,null,{"$f":"E31-G31","v":488.12}]
[null,null,null,"Genel Sağlık S.% 12",292.87,null,null,null,null,{"$f":"E32-G32","v":292.87}]
[null,null,null,"TOPLAM",{"$f":"SUM(E31:E32)","v":780.99},null,{"$f":"SUM(G31:G32)","v":0},null,"(2)**",{"$f":"SUM(J31:J32)","v":780.99}]
[null,null,null,"Hakediş Toplamı",{"$f":"(E27+E33)","v":4738.3100000000004}]
[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",75.760000000000005,null,{"$f":"(E37/E8)*H8","v":39.101935483870967},null,null,{"$f":"(E37-G37)","v":36.658064516129038}]
[null,null,null,"Damga Vergisi",27.01,null,{"$f":"(E38/E8)*H8","v":13.940645161290323},null,null,{"$f":"(E38-G38)","v":13.069354838709678}]
[]
[]
[]
[]
[]
[null,null,null,"TOPLAM",{"$f":"SUM(E37:E43)","v":102.77000000000001},null,{"$f":"SUM(G37:G43)","v":53.042580645161294},null,"(3)",{"$f":"SUM(J37:J43)","v":49.727419354838716}]
[]
[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":1684.5387096774193}]
[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":1634.8112903225806}]
[]
[]
[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,"Tebliğ Tarih    :"]
[null,null,null,"İmza               :"]