{"text_format":"1","workbook":"xlsx","n_sheets":12,"sheets":["Bilgi Girişi","Bordro1","Hesaplamalar","Tablo","Ödeme Emri","Değerler Tablosu","Asg Geç İnd","Vergi","Son 4 Yıl","Derece Kademe","Bordro","Sayfa1"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":9,"comments":5,"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":"Bilgi Girişi","index":0,"n_rows":163,"n_cols":12,"rows_kept":163,"cut":false,"hidden":false,"merged":[[12,6,12,7],[17,10,17,11],[18,10,18,11],[22,10,22,11],[19,10,19,11],[20,10,20,11],[33,6,33,7],[25,10,25,11],[24,10,24,11],[29,6,29,7],[26,10,26,11],[24,6,24,7],[30,6,30,7],[31,6,31,7],[1,5,1,9],[2,6,2,9],[11,6,11,7],[5,5,5,11],[6,10,6,11],[6,6,6,7],[10,10,10,11],[4,5,4,11],[7,6,7,7],[10,6,10,7],[8,6,8,7],[9,6,9,7],[7,10,7,11],[8,10,8,11],[9,10,9,11],[36,8,36,9],[13,10,13,11],[16,6,16,7],[14,10,14,11],[19,6,19,7],[15,6,15,7],[14,6,14,7],[28,6,28,7],[23,6,23,7],[27,6,27,7],[22,6,22,7],[26,6,26,7],[25,6,25,7],[34,6,34,7],[15,10,15,11],[32,6,32,7]]}
[]
[null,null,null,null,null,"Hesaplamaya İlişkin Mevcut Maaş ve Kişisel Bilgilerinizi Aşağıdaki Personel Bilgileri Alanına Giriniz",null,null,null,null,"Bu Ödeme Kıst Maaş mı?"]
[null,null,null,null,null,"Kurum :",null,null,null,null,"Ay Günü:",30]
[null,null,{"$f":"IF(F4=\"\",0,1)","v":1},null,1,"Ay / YIL",null,{"$f":"+'Değerler Tablosu'!E5","v":2018},"Birim",null,"Bordro Günü",30]
[null,null,null,null,null,"Personel Bilgileri"]
[null,null,null,null,null,"KİŞİSEL BİLGİLER"]
[null,{"$f":"IF(J7=0,0,1)","v":1},{"$f":"IF(F7=\"\",0,1)","v":0},0,{"$f":"IF(F7=\"\",0,SUM($C$4:C7))","v":0},{"$f":"IF(G4=\"\",\"\",\"Personel Durumu\")","v":""},null,null,{"$f":"IF(B7=0,0,IF(J7=\"\",\"\",SUM($C$4:C40)+SUM($B$4:B7)))","v":""},{"$f":"IF(G7=\"\",\"\",IF(G15='Bilgi Girişi'!F92,0,\"Özel Hizmet Tazminatı Oranı %\"))","v":""}]
[null,{"$f":"IF(J8=0,0,1)","v":1},0,null,{"$f":"IF(F8=\"\",0,SUM($C$4:C8))","v":0},{"$f":"IF(G7=\"\",\"\",\"T.C. Kimlik Numarası\")","v":""},null,null,{"$f":"IF(B8=0,0,IF(J8=\"\",\"\",SUM($C$4:C41)+SUM($B$4:B8)))","v":""},{"$f":"IF(G7=\"\",\"\",IF(G15='Bilgi Girişi'!F92,0,\"Mali Sorumluk Zammı Puanı\"))","v":""}]
[null,1,0,null,{"$f":"IF(F9=\"\",0,SUM($C$4:C9))","v":0},{"$f":"IF(G7=\"\",\"\",\"Kurum Sicil Numarası\")","v":""},null,null,{"$f":"IF(B9=0,0,IF(J9=\"\",\"\",SUM($C$4:C42)+SUM($B$4:B9)))","v":""},{"$f":"IF(G7=\"\",\"\",IF(G15='Bilgi Girişi'!F92,0,\"İş Riski Zammı Puanı\"))","v":""}]
[null,1,0,null,{"$f":"IF(F10=\"\",0,SUM($C$4:C10))","v":0},{"$f":"IF(G7=\"\",\"\",\"Emekli sicil Numarası\")","v":""},null,null,{"$f":"IF(B10=0,0,IF(J10=\"\",\"\",SUM($C$4:C43)+SUM($B$4:B10)))","v":""},{"$f":"IF(G7=\"\",\"\",IF(G15='Bilgi Girişi'!F92,0,\"Tem.Güç.Zammı Puanı\"))","v":""}]
[null,1,0,null,{"$f":"IF(F11=\"\",0,SUM($C$4:C11))","v":0},{"$f":"IF(G7=\"\",\"\",\"Adınız Soyadınız\")","v":""},null,null,{"$f":"IF(B11=0,0,IF(J11=\"\",\"\",SUM($C$4:C44)+SUM($B$4:B11)))","v":""},{"$f":"IF(G7=\"\",\"\",IF(G15='Bilgi Girişi'!F92,0,\"Yan Ödeme Puan Toplamı\"))","v":""},{"$f":"SUM(K8:L10)","v":0}]
[null,1,0,null,{"$f":"IF(F12=\"\",0,SUM($C$4:C12))","v":0},{"$f":"IF(G7=\"\",\"\",\"Medeni Haliniz\")","v":""},null,null,{"$f":"IF(B12=0,0,IF(J12=\"\",\"\",SUM($C$4:C45)+SUM($B$4:B12)))","v":""},{"$f":"IF(G7=\"\",\"\",IF(G15='Bilgi Girişi'!F91,\"(İdari Personel İçin )Yabancı Diliniz Varmı ?/Düzeyi\",0))","v":""}]
[null,null,null,null,{"$f":"IF(F13=\"\",0,SUM($C$4:C13))","v":0},{"$f":"IF(G7=\"\",\"\",IF(G12=\"Bekar\",\"\",IF(G12=\"\",\"\",CONCATENATE(\"Çocuk Sayınız\",\"/\",\" Asgari Geçim İndirimine Esas\"))))","v":""},null,null,{"$f":"IF(B14=0,0,IF(J13=\"\",\"\",SUM($C$4:C46)+SUM($B$4:B14)))","v":0},{"$f":"IF(G15='Bilgi Girişi'!F92,\"(Akademik Personel İçin )Yabancı Diliniz Varmı ? / Düzeyi\",0)","v":0}]
[null,{"$f":"IF(J13=0,0,1)","v":0},0,null,{"$f":"IF(F14=\"\",0,SUM($C$4:C14))","v":0},{"$f":"IF(G7=\"\",\"\",IF(G12=\"Bekar\",\"\",IF(G12=\"\",\"\",CONCATENATE(\"Çocuk Sayınız\",\"/\",\" Ödemeye Esas\"))))","v":""},null,null,{"$f":"IF(B15=0,0,IF(J14=\"\",\"\",SUM($C$4:C47)+SUM($B$4:B15)))","v":0},{"$f":"IF(G15='Bilgi Girişi'!F92,\"Yüksek Öğrenim Tazminatı Oranı %\",0)","v":0}]
[null,{"$f":"IF(J14=0,0,1)","v":0},0,null,{"$f":"IF(F15=\"\",0,SUM($C$4:C15))","v":0},{"$f":"IF(G7=\"\",\"\",\"Kadro Durumunuz ( İ / A )\")","v":""},null,null,{"$f":"IF(B16=0,0,IF(J15=\"\",\"\",SUM($C$4:C48)+SUM($B$4:B16)))","v":""},{"$f":"IF(G7=\"\",\"\",\"Döner Sermaye Alıyormusunuz ?\")","v":""}]
[null,{"$f":"IF(J15=0,0,1)","v":1},0,null,{"$f":"IF(F16=\"\",0,SUM($C$4:C16))","v":0},{"$f":"IF(G7=\"\",\"\",\"Kadro Ünvanınız\")","v":""},null,null,{"$f":"IF(B17=0,0,IF(J16=\"\",\"\",SUM($C$4:C49)+SUM($B$4:B17)))","v":""},{"$f":"IF(G7=\"\",\"\",IF(K15=\"Evet\",0,\"Ek Ödeme Oranınız\"))","v":""}]
[null,{"$f":"IF(J16=0,0,1)","v":1},{"$f":"IF(F17=\"\",0,1)","v":0},null,{"$f":"IF(F17=\"\",0,SUM($C$4:C17))","v":0},{"$f":"IF(G7=\"\",\"\",\"Bu Ay Maaş D/K Terfiniz  Varmı ?\")","v":""},null,null,{"$f":"IF(B18=0,0,IF(J17=\"\",\"\",SUM($C$4:C50)+SUM($B$4:B18)))","v":""},{"$f":"IF(G7=\"\",\"\",\"İdari Göreviniz Varmı ? / Oranını % Giriniz\")","v":""}]
[null,{"$f":"IF(J17=0,0,1)","v":1},0,null,{"$f":"IF(F18=\"\",0,SUM($C$4:C18))","v":0},{"$f":"IF(G7=\"\",\"\",IF(G17=\"\",\"Maaş Dereceniz / Kademeniz\",\"Yeni Maaş Dereceniz / Kademeniz\"))","v":""},null,null,{"$f":"IF(B21=0,0,IF(J18=\"\",\"\",SUM($C$4:C51)+SUM($B$4:B21)))","v":0},{"$f":"IF(G15='Bilgi Girişi'!F92,\"Üniverite Ödeneği Oranı %\",0)","v":0}]
[null,null,0,null,{"$f":"IF(F19=\"\",0,SUM($C$4:C19))","v":0},{"$f":"IF(G7=\"\",\"\",IF(G7=F89,\"\",IF(G17=\"\",\"\",\"Eski Maaş Derece /Kademeniz\")))","v":""},null,null,{"$f":"IF(B22=0,0,IF(J19=\"\",\"\",SUM($C$4:C52)+SUM($B$4:B22)))","v":0},{"$f":"IF(G15='Bilgi Girişi'!F92,\"Eğitim Öğretim Ödeneği\",0)","v":0}]
[null,null,{"$f":"IF(F20=\"\",0,1)","v":0},null,{"$f":"IF(F20=\"\",0,SUM($C$4:C20))","v":0},{"$f":"IF(G7=\"\",\"\",IF(G7=F89,\"\",\"Bu Ay Emekli Maaş D/K Terfiniz  Varmı ?\"))","v":""},null,null,{"$f":"IF(B24=0,0,IF(J20=\"\",\"\",SUM($C$4:C53)+SUM($B$4:B24)))","v":0},{"$f":"IF(G15=F92,\"Akademik Teşvik Ödeneği Puanınızı Giriniz\",0)","v":0}]
[null,{"$f":"IF(J18=0,0,1)","v":0},0,null,{"$f":"IF(F21=\"\",0,SUM($C$4:C21))","v":0},{"$f":"IF(G7=\"\",\"\",IF(G20=\"Evet\",\"Yeni Emekliliğe Esas Dereceniz / Kademeniz\",\"Emekliliğe Esas Dereceniz / Kademeniz\"))","v":""},null,null,{"$f":"IF(B25=0,0,IF(J21=\"\",\"\",SUM($C$4:C54)+SUM($B$4:B25)))","v":0},{"$f":"IF(G15=F92,\"Akademik Teşvik Oranı %\",0)","v":0}]
[null,0,0,null,{"$f":"IF(F22=\"\",0,SUM($C$4:C22))","v":0},{"$f":"IF(G20=\"Evet\",\"Eski Emekliliğe Esas Dereceniz / Kademeniz\",\"\")","v":""},null,null,{"$f":"IF(B28=0,0,IF(J22=\"\",\"\",SUM($C$4:C55)+SUM($B$4:B28)))","v":0},{"$f":"IF(G15='Bilgi Girişi'!F92,\"Geliştirme Ödeneği Alıyormusunuz / Oranı\",0)","v":0}]
[null,{"$f":"IF(J20=0,0,1)","v":0},{"$f":"IF(F23=\"\",0,1)","v":0},null,{"$f":"IF(F23=\"\",0,SUM($C$4:C23))","v":0},{"$f":"IF(G7=\"\",\"\",IF(G7=F89,\"\",\"Bu Ay Kıdem Yılı Değişikliğiniz Varmı ?\"))","v":""},null,null,{"$f":"IF(B29=0,0,IF(J23=\"\",\"\",SUM($C$4:C56)+SUM($B$4:B29)))","v":""},{"$f":"IF(G7=\"\",\"\",\"Bireysel Emeklilik Kesintiniz Varmı (BES)\")","v":""}]
[null,{"$f":"IF(J20=0,0,1)","v":0},0,null,{"$f":"IF(F24=\"\",0,SUM($C$4:C24))","v":0},{"$f":"IF(G7=\"\",\"\",IF(G23=\"\",\"Kıdem Yılınız\",\"Yeni Kıdem Yılınız\"))","v":""},null,null,{"$f":"IF(B31=0,0,IF(J24=\"\",\"\",SUM($C$4:C57)+SUM($B$4:B31)))","v":""},{"$f":"IF(G7=\"\",\"\",IF(G15='Bilgi Girişi'!F91,\"Özelleştirmeden Gelen Personel mi ? / Eski Kurum Neti TL\",0))","v":""}]
[null,{"$f":"IF(J21=0,0,1)","v":0},0,null,{"$f":"IF(F25=\"\",0,SUM($C$4:C25))","v":0},{"$f":"IF(G23=\"Evet\",\"Eski Kıdem Yılınız\",\"\")","v":""},null,null,{"$f":"IF(B32=0,0,IF(J25=\"\",\"\",SUM($C$4:C58)+SUM($B$4:B32)))","v":""},{"$f":"IF(G7=\"\",\"\",\"NormaL İcra Borcunuz  Varmı ?\")","v":""}]
[null,{"$f":"IF(J22=0,0,1)","v":0},{"$f":"IF(F26=\"\",0,1)","v":0},null,{"$f":"IF(F26=\"\",0,SUM($C$4:C26))","v":0},{"$f":"IF(G7=\"\",\"\",\"Daha Önceki Ek Göstergenizde Düşüş Varmı\")","v":""},null,null,{"$f":"IF(B33=0,0,IF(J26=\"\",\"\",SUM($C$4:C59)+SUM($B$4:B33)))","v":""},{"$f":"IF(G7=\"\",\"\",\"Kefaletli Göreviniz Varmı ?\")","v":""}]
[null,{"$f":"IF(J22=0,0,1)","v":0},{"$f":"IF(F27=\"\",0,1)","v":0},null,{"$f":"IF(F27=\"\",0,SUM($C$4:C27))","v":0},{"$f":"IF(G7=\"\",\"\",\"Bu Ay Ek Göstergeniz Değiştimi ?\")","v":""},null,null,{"$f":"IF(B34=0,0,IF(J27=\"\",\"\",SUM($C$4:C60)+SUM($B$4:B34)))","v":""},{"$f":"IF(G8=\"\",\"\",\"Nafaka Kesintisi Varmı ?/ Varsa Miktarı ? TL\")","v":""}]
[null,{"$f":"IF(J22=0,0,1)","v":0},0,null,{"$f":"IF(F28=\"\",0,SUM($C$4:C28))","v":0},{"$f":"IF(G7=\"\",\"\",IF(G27=\"\",\"Ek Gostergeniz (Ödemeye Esas)\",\"Yeni Ek Gostergeniz (Ödemeye Esas)\"))","v":""}]
[null,{"$f":"IF(J23=0,0,1)","v":1},0,null,{"$f":"IF(F29=\"\",0,SUM($C$4:C29))","v":0},{"$f":"IF(G27=\"Evet\",\"Yeni Emekliliğe Esas Ek Göstergeniz \",IF(G7=\"\",\"\",\"Emekliliğe Esas Ek Göstergeniz\"))","v":""}]
[null,{"$f":"IF(J24=0,0,1)","v":1},{"$f":"IF(F30=\"\",0,1)","v":0},null,{"$f":"IF(F30=\"\",0,SUM($C$4:C30))","v":0},{"$f":"IF(G4=\"\",\"\",IF(G27=\"Evet\",\"Eski Emekliye Esas  Ek Gostergeniz \",IF(G27=\"\",\"Eski Emekliye Esas  Ek Gostergeniz \")))","v":""}]
[null,{"$f":"IF(J24=0,0,1)","v":1},0,null,{"$f":"IF(F31=\"\",0,SUM($C$4:C31))","v":0},{"$f":"IF(G26=\"Evet\",\"Yüksek Olan Eski Emekliye Esas Ek Göstergeniz (Şahıs)\",\"\")","v":""}]
[null,{"$f":"IF(J25=0,0,1)","v":1},0,null,{"$f":"IF(F32=\"\",0,SUM($C$4:C32))","v":0},{"$f":"IF(G7=\"\",\"\",\"Varsa Bu Bordroda kullanılacak Raporlu Gun Sayınız\")","v":""}]
[null,{"$f":"IF(J26=0,0,1)","v":1},{"$f":"IF(F33=\"\",0,1)","v":0},null,{"$f":"IF(F33=\"\",0,SUM($C$4:C33))","v":0},{"$f":"IF(G7=\"\",\"\",\"Özel Sigorta Tutarı TL (Hayat Sigortası)\")","v":""}]
[null,1,0,null,{"$f":"IF(F34=\"\",0,SUM($C$4:C34))","v":0},{"$f":"IF(G7=\"\",\"\",\"Varsa Geçen Aylar Vergi Matrah Toplamınız\")","v":""}]
[null,0,0,null,{"$f":"IF(F35=\"\",0,SUM($C$4:C35))","v":0},{"$f":"IF(G7=\"\",\"\",\"Sendika Üyeliğiniz Var Mı ?\")","v":""}]
[null,0,0,null,{"$f":"IF(F36=\"\",0,SUM($C$4:C36))","v":0},{"$f":"IF(G7=\"\",\"\",\"Varsa Sakatlık İndirimi Durumu ' Kendisi / Eş veya Çocuk\")","v":""}]
[null,{"$f":"IF(J30=0,0,1)","v":0},{"$f":"IF(F37=\"\",0,1)","v":0},null,{"$f":"IF(F37=\"\",0,SUM($C$4:C37))","v":0},{"$f":"IF(F14=\"\",\"\",\"Varsa Enaz %40 Sakatlık İndiriminden Faydalanan Çocuk Sayısı\")","v":""},null,null,{"$f":"IF(G37>G14,\"Dikkat Çocuk Sayısında Hatalı Giriş Var\",IF(H37>H14,\"Dikkat Çocuk Sayısında Hatalı Giriş Var\",\"\"))","v":""}]
[null,{"$f":"IF(J30=0,0,1)","v":0},0,null,{"$f":"IF(F38=\"\",0,SUM($C$4:C38))","v":0},{"$f":"IF(G7=\"\",\"\",\"Tahhütlü İcra Borcunuz Varmı ? / Varsa Miktarını Giriniz\")","v":""}]
[null,{"$f":"IF(J31=0,0,1)","v":0},{"$f":"IF(F39=\"\",0,1)","v":0},null,{"$f":"IF(F39=\"\",0,SUM($C$4:C39))","v":0},{"$f":"IF(G16=\"Doçent\",\"Doçentler İçin / Kazanılmış Hak Aylığı D/K\",\"\")","v":""}]
[]
[null,null,null,null,null,"Mustafa İŞBİLİR / Afyon Kocatepe Ünv./İdari Ve Mali İşler/ Şube Müdürü / Mart 2018"]
[null,null,null,null,null,"Tadilat ve düzenleme yapılmaktadır.Karşılaştığınız Sorunlar için lütfen arayınız. 05427686825"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,"Aylar"]
[null,null,null,null,null,"Ocak",null,{"$f":"CONCATENATE('Bilgi Girişi'!G18,'Bilgi Girişi'!H18)","v":""}]
[null,null,null,null,null,"Şubat",null,{"$f":"CONCATENATE('Bilgi Girişi'!G19,'Bilgi Girişi'!H19)","v":""}]
[null,null,null,null,null,"Mart",null,{"$f":"CONCATENATE('Bilgi Girişi'!G21,'Bilgi Girişi'!H21)","v":""}]
[null,null,null,null,null,"Nisan",null,{"$f":"CONCATENATE('Bilgi Girişi'!G22,'Bilgi Girişi'!H22)","v":""}]
[null,null,null,null,null,"Mayıs",null,"Evli Eşi Çalışıyor"]
[null,null,null,null,null,"Haziran",null,"Evli Eşi Çalışmıyor"]
[null,null,null,null,null,"Temmuz",null,"Evli Eşi Emekli V.İnd Yararlanıyor"]
[null,null,null,null,null,"Ağustos",null,"Bekar"]
[null,null,null,null,null,"Eylül"]
[null,null,null,null,null,"Ekim"]
[null,null,null,null,null,"Kasım",null,"Rektör"]
[null,null,null,null,null,"Aralık",null,"3 Yıllık Profesör"]
[null,null,null,null,null,null,null,"Yeni Profesör"]
[null,null,null,null,null,null,null,"Doçent"]
[null,null,null,null,null,"Evet",null,"Genel Sekreter"]
[null,null,null,null,null,"Hayır",null,"İç Denetçi"]
[null,null,null,null,null,null,null,"Araştırmacı 1"]
[null,null,null,null,null,null,null,"Araştırmacı"]
[null,null,null,null,null,"01/10/2008 Den Önceki Personel"]
[null,null,null,null,null,"01/10/2008 Den Sonraki Personel"]
[null,null,null,null,null,null,null,"1.Derece"]
[null,null,null,null,null,"İdari Personel",null,"2.Derece"]
[null,null,null,null,null,"Akademik Personel",null,"3.Derece"]
[]
[]
[]
[]
[]
[null,null,null,null,null,1,100]
[null,null,null,null,null,2,200]
[null,null,null,null,null,3,300]
[null,null,null,null,null,4,400]
[null,null,null,null,null,5,500]
[null,null,null,null,null,6,600]
[null,null,null,null,null,7,650]
[null,null,null,null,null,8,750]
[null,null,null,null,null,9,850]
[null,null,null,null,null,10,950]
[null,null,null,null,null,11,1050]
[null,null,null,null,null,12,1150]
[null,null,null,null,null,13,1250]
[null,null,null,null,null,14,1350]
[null,null,null,null,null,15,1450]
[null,null,null,null,null,16,1550]
[null,null,null,null,null,17,1650]
[null,null,null,null,null,18,1750]
[null,null,null,null,null,19,1850]
[null,null,null,null,null,20,1950]
[null,null,null,null,null,21,2050]
[null,null,null,null,null,22,2150]
[null,null,null,null,null,23,2200]
[null,null,null,null,null,24,2300]
[null,null,null,null,null,25,2400]
[null,null,null,null,null,26,2500]
[null,null,null,null,null,27,2600]
[null,null,null,null,null,28,2700]
[null,null,null,null,null,29,2800]
[null,null,null,null,null,30,2900]
[null,null,null,null,null,null,3000]
[null,null,null,null,null,null,3100]
[null,null,null,null,null,null,3200]
[null,null,null,null,null,null,3300]
[null,null,null,null,null,null,3400]
[null,null,null,null,null,null,3500]
[null,null,null,null,null,null,3600]
[null,null,null,null,null,null,3700]
[null,null,null,null,null,null,3800]
[null,null,null,null,null,null,3900]
[null,null,null,null,null,null,4000]
[null,null,null,null,null,null,4100]
[null,null,null,null,null,null,4200]
[null,null,null,null,null,null,4300]
[null,null,null,null,null,null,4400]
[null,null,null,null,null,null,4500]
[null,null,null,null,null,null,4600]
[null,null,null,null,null,null,4700]
[null,null,null,null,null,null,4800]
[null,null,null,null,null,null,4900]
[null,null,null,null,null,null,5000]
[null,null,null,null,null,null,5100]
[null,null,null,null,null,null,5200]
[null,null,null,null,null,null,5300]
[null,null,null,null,null,null,5400]
[null,null,null,null,null,null,5500]
[null,null,null,null,null,null,5600]
[null,null,null,null,null,null,5700]
[null,null,null,null,null,null,5800]
[null,null,null,null,null,null,5900]
[null,null,null,null,null,null,6000]
[null,null,null,null,null,null,6100]
[null,null,null,null,null,null,6200]
[null,null,null,null,null,null,6300]
[null,null,null,null,null,null,6400]
[null,null,null,null,null,null,6500]

{"sheet":"Bordro1","index":1,"n_rows":39,"n_cols":7,"rows_kept":39,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[null,"Kurumu / Birimi",0]
[null,"Ait Olduğu Ay",0]
[null,"Bütçe Yılı",0]
[null,"PERSONEL BİLGİLERİ",null,"GELİRİN",null,"KESİNTİNİN"]
[null,0,0,"ADI","T U T A R I","ADI","T U T A R I"]
[null,0,0,0,0,0,0]
[null,0,0,0,0,0,0]
[null,0,0,0,0,0,0]
[null,0,0,0,0,0,0]
[null,0,"",0,0,0,0]
[null,0,0,0,0,0,0]
[null,0,"",0,0,0,0]
[null,0,0,0,0,0,0]
[null,0,"",0,0,0,0]
[null,0,0,0,0,0,0]
[null,0,0,0,0,0,0]
[null,0,0,0,0,0,0]
[null,0,0,0,0,0,0]
[null,0,0,0,0,0,0]
[null,0,0,0,0,0,0]
[null,0,0,0,0,0,0]
[null,null,null,0,0,0,0]
[null,null,null,0,0]
[null,null,null,0,0,"Gelir Toplamı",0]
[null,null,null,0,0,"Kesinti Toplamı",0]
[null,null,null,0,0,"Net Ödenen",0]
[null,null,null,0,0]
[null,null,null,0,0,"Toplam Ödenen",0]
[null,null,null,0,0]
[null,null,null,0,0]
[]
[]
[]
[]
[null,0]

{"sheet":"Hesaplamalar","index":2,"n_rows":38,"n_cols":28,"rows_kept":38,"cut":false,"hidden":true,"merged":[[17,1,19,1],[20,5,20,6],[18,5,18,6],[19,5,19,6],[14,5,14,6],[17,3,19,3],[11,5,11,6],[5,17,5,18],[6,13,6,14],[5,9,5,10],[5,5,5,6],[8,17,8,18],[8,13,8,14],[7,9,7,10],[10,5,10,6],[6,17,6,18],[6,5,6,6],[9,5,9,6],[37,5,37,6],[7,5,7,6],[3,16,3,18],[7,17,7,18],[13,17,13,18],[24,5,24,6],[3,4,3,6],[4,12,4,14],[4,8,4,10],[13,9,13,10],[13,5,13,6],[6,9,6,10],[8,5,8,6],[33,5,33,6],[34,5,34,6],[16,5,16,6],[32,4,32,6],[29,5,29,6],[22,4,22,6],[14,9,14,10],[23,5,23,6],[27,4,27,6],[30,5,30,6],[23,9,23,10],[15,5,15,6],[20,9,20,10],[15,9,15,10],[17,9,17,10],[19,9,19,10],[17,5,17,6],[26,10,31,11],[36,5,36,6],[2,20,2,21],[4,17,4,18],[4,5,4,6],[28,4,28,6],[16,9,16,10],[14,17,14,18],[10,13,10,14],[12,13,12,14],[7,13,7,14],[5,13,5,14],[12,5,12,6],[8,9,8,10],[10,9,10,10],[12,9,12,10],[21,9,21,10]]}
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"KESİNTİLER"]
[null,null,null,null,"Temel Maaşlar",null,null,null,null,null,null,null,null,null,null,null,"Emekli Keseneği Hesaplamaya İlşikin Bölüm",null,null,null,"Kesintinin Adı","Tutarı",null,null,null,"Emekli Matrahları","Tutarı","Em Ek Büyükse"]
[null,null,null,null,{"$f":"IF('Bilgi Girişi'!G7=\"\",\"\",\"Yeni Aylık Göstergesi\")","v":""},{"$f":"IF(ISERROR(VLOOKUP('Bilgi Girişi'!H70,'Derece Kademe'!$N$17:$O$287,2,FALSE)),0,VLOOKUP('Bilgi Girişi'!H70,'Derece Kademe'!$N$17:$O$287,2,FALSE))","v":0},null,null,"Zam ve Tazminatlar",null,null,null,"Ödenekler",null,null,null,{"$f":"IF('Bilgi Girişi'!G7='Bilgi Girişi'!F88,\"Em.Kes.Katkı Oranı % \n'Her İki Ek Göst Eşit Olanlar'\",0)","v":0},{"$f":"IF('Bilgi Girişi'!G28>6400,215,IF(Q5=0,0,+T5))","v":0},null,{"$f":"LARGE('Değerler Tablosu'!I45:I52,1)","v":55},{"$f":"IF('Bilgi Girişi'!G7=\"\",\"\",\"Bu Ay Vergi Matrahınız\")","v":""},{"$f":"IF(F5>0,SUM((F6+F18+F13+F15+M30+N6)-(V16+Z24+Z28+V21+V17+V22+F37)),SUM((F6+F18+F13+F15+J8+N6)-(V16+Z24+Z28+V21+V17+V22+F37)))","v":0},null,null,null,{"$f":"IF('Bilgi Girişi'!G7='Bilgi Girişi'!F88,\"Heriki Ek Göstregesi ve Emk Mük ile Kıdem Aynı Olanlar için Em.Kes.Karşılığı  % 20 (Devlet K.Matrahı)\",0)","v":0},{"$f":"IF(AND('Bilgi Girişi'!G7='Bilgi Girişi'!F88,'Bilgi Girişi'!L2=\"Evet\"),0,IF('Bilgi Girişi'!G7='Bilgi Girişi'!F89,0,(F10+F13+F16+R6+F19)))","v":0},{"$f":"IF(AND('Bilgi Girişi'!G7='Bilgi Girişi'!F88,'Bilgi Girişi'!L2=\"Evet\"),0,IF('Bilgi Girişi'!G7='Bilgi Girişi'!F89,0,(F10+F13+F16+R9+F21)))","v":0}]
[null,null,null,null,{"$f":"IF('Bilgi Girişi'!G7=\"\",\"\",\"Aylık Tutar (Ödemeye Esas)\")","v":""},{"$f":"ROUND((IF(ISERROR(((F5*'Değerler Tablosu'!E6)/'Bilgi Girişi'!L3)*'Bilgi Girişi'!L4),0,(F5*'Değerler Tablosu'!E6)/'Bilgi Girişi'!L3)*'Bilgi Girişi'!L4),2)","v":0},null,null,{"$f":"IF('Bilgi Girişi'!G7=\"\",\"\",IF('Bilgi Girişi'!J7=0,0,\"Ödemeye Esas Özel Hizmet Tazminatı Tutarı\"))","v":""},{"$f":"ROUND(((((9500*'Değerler Tablosu'!E6)/100)*'Bilgi Girişi'!K7)/'Bilgi Girişi'!L3)*'Bilgi Girişi'!L4,2)","v":0},null,null,{"$f":"IF('Bilgi Girişi'!K17=\"Evet\",\"İdari Görev Tutarı\",0)","v":0},{"$f":"ROUND((((F5+'Bilgi Girişi'!G28)*'Değerler Tablosu'!E6)*'Bilgi Girişi'!L17)/100,2)","v":0},null,null,{"$f":"IF('Bilgi Girişi'!G7='Bilgi Girişi'!F88,\"Em.Kes.Katkı Tutarı\n'Her İki Göstergesi Eşit Olanlar'\",0)","v":0},{"$f":"IF(C7=C8,0,ROUND(IF(Q6=0,0,('Değerler Tablosu'!E6*9500)*R5)/100,2))","v":0},null,null,{"$f":"IF('Bilgi Girişi'!G7=\"\",\"\",\"Sakatlık İndirimi  Tutarı TL\")","v":""},{"$f":"+Z28","v":0},null,null,null,{"$f":"IF('Bilgi Girişi'!G7='Bilgi Girişi'!F88,\"Heriki Ek Göstregesi ve Emk Mük ile Kıdem Aynı Olanlar için Em.Kes.Karşılığı  % 20 (Devlet)\",0)","v":0},{"$f":"IF('Bilgi Girişi'!G7='Bilgi Girişi'!F89,0,ROUND(IF(AA5=0,0,(AA5*0.2)),2))","v":0}]
[null,null,{"$f":"CONCATENATE('Bilgi Girişi'!G7,'Bilgi Girişi'!L2)","v":""},null,{"$f":"IF('Bilgi Girişi'!G7=\"\",\"\",\"Eski Aylık Göstergesi\")","v":""},{"$f":"IF(ISERROR(VLOOKUP('Bilgi Girişi'!H71,'Derece Kademe'!$N$17:$O$287,2,FALSE)),0,VLOOKUP('Bilgi Girişi'!H71,'Derece Kademe'!$N$17:$O$287,2,FALSE))","v":0},null,null,{"$f":"IF('Bilgi Girişi'!G7=\"\",\"\",IF('Bilgi Girişi'!J8=0,0,\"Emkliye Esas Özel Hizmet Tazminatı Tutarı\"))","v":""},{"$f":"ROUND(((((9500*'Değerler Tablosu'!E6)/100)*'Bilgi Girişi'!K7)/30)*'Bilgi Girişi'!L4,2)","v":0},null,null,{"$f":"IF('Bilgi Girişi'!J18=0,0,\"Üniversite Ödeneği Tutarı\")","v":0},{"$f":"IF(M7=0,0,ROUND(IF('Bilgi Girişi'!K18=\"\",0,(((9500*'Değerler Tablosu'!E6)*'Bilgi Girişi'!K18)/100)/'Bilgi Girişi'!L3)*'Bilgi Girişi'!L4,2))","v":0},null,null,{"$f":"IF(R7=0,0,\"Emekliye Esas Ek Gösterge Tutarı 'Ödemeye Esas Ek Göstergesi Aynı Olanlar'\")","v":0},{"$f":"IF('Bilgi Girişi'!G7='Bilgi Girişi'!F89,0,IF(C7=C8,0,IF('Bilgi Girişi'!G28='Bilgi Girişi'!G29,('Bilgi Girişi'!G30*'Değerler Tablosu'!E6),0)))","v":0},null,null,{"$f":"IF('Bilgi Girişi'!G7=\"\",\"\",\"Toplam Vergi Matrahınız\")","v":""},{"$f":"'Bilgi Girişi'!G34+V5","v":0},null,null,null,{"$f":"IF('Bilgi Girişi'!G7=\"\",\"\",IF('Bilgi Girişi'!G7='Bilgi Girişi'!F89,0,\"Gen.Sag.Sig.Pir.( ) Devlet K.Matrahı) % 12\"))","v":""},{"$f":"+AA5","v":0}]
[null,null,"01/10/2008 Den Önceki PersonelEvet",null,{"$f":"IF('Bilgi Girişi'!G7=\"\",\"\",\"Yeni Emekliye Esas Aylık Göstergesi\")","v":""},{"$f":"IF(C7=C8,0,IF(ISERROR(VLOOKUP('Bilgi Girişi'!H72,'Derece Kademe'!N17:O290,2,FALSE)),0,VLOOKUP('Bilgi Girişi'!H72,'Derece Kademe'!N17:O290,2,FALSE)))","v":0},null,null,{"$f":"IF('Bilgi Girişi'!G7=\"\",\"\",IF('Bilgi Girişi'!J11=0,0,\"Ödenecek Yan Odemeler Toplamı\"))","v":""},{"$f":"ROUND((('Bilgi Girişi'!K11*'Değerler Tablosu'!E7)/'Bilgi Girişi'!L3)*'Bilgi Girişi'!L4,2)","v":0},null,null,{"$f":"IF('Bilgi Girişi'!J18=0,0,\"Eğitim Öğretim Ödeneği Tutarı\")","v":0},{"$f":"IF(M8=0,0,ROUND(IF('Bilgi Girişi'!K19=\"Evet\",(((9500*'Değerler Tablosu'!E6)/12)/'Bilgi Girişi'!L3)*'Bilgi Girişi'!L4,0),2))","v":0},null,null,{"$f":"IF('Bilgi Girişi'!G7='Bilgi Girişi'!F88,\"Em.Kes.Katkı Oranı %\n'Emekli Ek Göst Farklı Olanlar'\",0)","v":0},{"$f":"IF('Bilgi Girişi'!G26=\"\",0,IF(Q8=0,0,IF(AND('Bilgi Girişi'!G31>=6400,'Bilgi Girişi'!G31<=7600),195,+T8)))","v":0},null,{"$f":"LARGE('Değerler Tablosu'!K45:K52,1)","v":0},{"$f":"IF('Bilgi Girişi'!G7=\"\",\"\",\"Geçerli Vergi Oranınız %\")","v":""},{"$f":"IF(V7=0,0,+Vergi!C21)","v":0},null,null,null,{"$f":"IF('Bilgi Girişi'!G7=\"\",\"\",IF('Bilgi Girişi'!G7='Bilgi Girişi'!F89,0,\"Gen.Sag.Sig.Pir.(Ek Göst Aynı İse ) Devlet K.Matrahı) % 12\"))","v":""},{"$f":"IF('Bilgi Girişi'!G7='Bilgi Girişi'!F89,0,IF(C7=C8,0,IF(Z8=0,0,ROUND(IF(R7=0,(F20+F13+F17+R9),(F20+F13+F17+R6)),2))))","v":0}]
[null,null,{"$f":"IF(C8=C8,1,0)","v":1},null,{"$f":"IF('Bilgi Girişi'!G7=\"\",\"\",\"Eski Emekliye Esas Aylık Göstergesi\")","v":""},{"$f":"IF('Bilgi Girişi'!G20=\"\",0,IF(C8=C9,0,IF(ISERROR(VLOOKUP('Bilgi Girişi'!H73,'Derece Kademe'!N17:O290,2,FALSE)),0,VLOOKUP('Bilgi Girişi'!H73,'Derece Kademe'!N17:O290,2,FALSE))))","v":0},null,null,{"$f":"IF('Bilgi Girişi'!G7=\"\",\"\",IF(J9<=0,0,\"Makam Tazminatı Puanı\"))","v":""},{"$f":"IF(AND('Bilgi Girişi'!G16=\"Doçent\",'Bilgi Girişi'!G39>1),0,IF(ISERROR(VLOOKUP('Bilgi Girişi'!G16,'Değerler Tablosu'!I8:J16,2,FALSE)),0,VLOOKUP('Bilgi Girişi'!G16,'Değerler Tablosu'!I8:J16,2,FALSE)))","v":0},null,null,{"$f":"IF('Bilgi Girişi'!J20>0,\"Ödemeye Easas Akademik Teşvik Ödeneği Tutarı\",0)","v":0},{"$f":"ROUND(((('Değerler Tablosu'!E6*9500)*'Bilgi Girişi'!K21/100)*('Bilgi Girişi'!K20)/100),2)","v":0},null,null,{"$f":"IF(R9=0,0,IF('Bilgi Girişi'!G7='Bilgi Girişi'!F88,\"Em.Kes.Katkı Tutarı \n'Emekli Ek  Göstergesi Farklı Olanlar'\",0))","v":0},{"$f":"IF(C7=C8,0,ROUND((('Değerler Tablosu'!E6*9500)*R8)/100,2))","v":0},null,null,{"$f":"IF('Bilgi Girişi'!G7=\"\",\"\",\"Gelir Vergisi\")","v":""},{"$f":"ROUND(IF(V5>0,(V5*V8)/100,0)-V31,2)","v":0},null,null,null,{"$f":"IF('Bilgi Girişi'!G7=\"\",\"\",IF('Bilgi Girişi'!G7='Bilgi Girişi'!F89,0,\"Gen.Sag.Sig.Pir.(Devlet) % 12\"))","v":""},{"$f":"ROUND(IF(AB5>AA5,AB5*0.12,AA5*0.12),2)","v":0}]
[null,null,null,null,"Emekli Kes İçin Kullanılacak Emekli Müktesebi Tutarı",{"$f":"ROUND(IF(F9<=0,F8*'Değerler Tablosu'!E6,Hesaplamalar!F9*'Değerler Tablosu'!E6),2)","v":0}]
[null,null,null,null,{"$f":"IF('Bilgi Girişi'!G7=\"\",\"\",\"Emekliye Esas Aylık Göstergesi Farkı ( % 100 Artış İçin)\")","v":""},{"$f":"IF('Bilgi Girişi'!G20=\"\",0,IF(F8=F9,F8,F8-F9))","v":0},null,null,{"$f":"IF('Bilgi Girişi'!G7=\"\",\"\",IF(J11<=0,0,\"Makam Tazminatı Tutarı\"))","v":""},{"$f":"ROUND(IF(J9>0,J9*'Değerler Tablosu'!E6,0),2)","v":0},null,null,{"$f":"IF('Bilgi Girişi'!J22=0,0,\"Geliştirme Ödeneği Tutarı\")","v":0},{"$f":"IF(M11=0,0,ROUND(IF(AND('Bilgi Girişi'!K22=\"Evet\",F7=0),(((F5+'Bilgi Girişi'!G28)*'Değerler Tablosu'!E6)*'Bilgi Girişi'!L22)/100,(((F5+'Bilgi Girişi'!G28)*'Değerler Tablosu'!E6)*'Bilgi Girişi'!L22)/100),2))","v":0}]
[null,null,null,null,{"$f":"IF('Bilgi Girişi'!G8=\"\",\"\",\" Emekliye Esas Aylık Tutar Farkı (%100 Artış İçin) \")","v":""},{"$f":"ROUND((IF((ISERROR((F11*'Değerler Tablosu'!E7)/'Bilgi Girişi'!L3)*'Bilgi Girişi'!L4),0,(F11*'Değerler Tablosu'!E6)/30)*'Bilgi Girişi'!L4),2)","v":0}]
[null,null,null,null,{"$f":"IF('Bilgi Girişi'!G7=\"\",\"\",\"Ödemeye ve Emekli Kes.Esas Taban Aylık Tutarı\")","v":""},{"$f":"IF('Bilgi Girişi'!G18=\"\",0,ROUND((('Değerler Tablosu'!E8*'Değerler Tablosu'!E9)/'Bilgi Girişi'!L3)*'Bilgi Girişi'!L4,2))","v":0},null,null,{"$f":"IF('Bilgi Girişi'!G7=\"\",\"\",IF(J13<=0,0,IF('Bilgi Girişi'!G16='Bilgi Girişi'!H80,\"Temsil Tazminatı Puanı\",\"Görev Tazminatı Puanı\")))","v":""},{"$f":"IF(ISERROR(VLOOKUP(J9,'Değerler Tablosu'!I22:L28,4,FALSE)),0,VLOOKUP(J9,'Değerler Tablosu'!I22:L28,4,FALSE))","v":0},null,null,{"$f":"IF('Bilgi Girişi'!G35=\"\",0,IF('Bilgi Girişi'!G4='Bilgi Girişi'!F70,\"Ödemeye Esas Top.Söz.İkram.\",IF('Bilgi Girişi'!G4='Bilgi Girişi'!F73,\"Ödemeye Esas Top.Söz.İkram.\",IF('Bilgi Girişi'!G4='Bilgi Girişi'!F76,\"Ödemeye Esas Top.Söz.İkram.\",IF('Bilgi Girişi'!G4='Bilgi Girişi'!F79,\"Ödemeye Easas Top.Söz.İkram.\",0)))))","v":0},{"$f":"IF('Bilgi Girişi'!K12=\"Evet\",0,IF(C7=C8,0,ROUND(IF('Bilgi Girişi'!G35=\"\",0,IF('Bilgi Girişi'!G4='Bilgi Girişi'!F70,('Değerler Tablosu'!E14*'Değerler Tablosu'!E6),IF('Bilgi Girişi'!G4='Bilgi Girişi'!F73,('Değerler Tablosu'!E14*'Değerler Tablosu'!E6),IF('Bilgi Girişi'!G4='Bilgi Girişi'!F76,('Değerler Tablosu'!E14*'Değerler Tablosu'!E6),IF('Bilgi Girişi'!G4='Bilgi Girişi'!F79,('Değerler Tablosu'!E14*'Değerler Tablosu'!E6),0))))),2)))","v":0},null,null,null,null,null,null,{"$f":"+E38","v":""},{"$f":"IF(AND('Bilgi Girişi'!G7='Bilgi Girişi'!F88,'Bilgi Girişi'!L2=\"Evet\"),0,IF('Bilgi Girişi'!G7='Bilgi Girişi'!F89,0,IF(F18>F19,(F12+F17+F20),(F12+F17+F20))))","v":0},null,null,null,7]
[null,null,null,null,null,null,null,null,{"$f":"IF('Bilgi Girişi'!G7=\"\",\"\",IF(J14<=0,0,IF('Bilgi Girişi'!G16='Bilgi Girişi'!H80,\"Temsil Tazminatı Puanı Ödemeye Esas\",\"GörevTazminatı Puanı ÖdemeyeEsas\")))","v":""},{"$f":"IF(AND('Bilgi Girişi'!G15='Bilgi Girişi'!F92,'Bilgi Girişi'!K16>0),(J13*0.8),IF(AND('Bilgi Girişi'!G15='Bilgi Girişi'!F91,'Bilgi Girişi'!K16>0),(J13*0.8),IF(AND('Bilgi Girişi'!G15='Bilgi Girişi'!F92,'Bilgi Girişi'!K15=\"Evet\"),+J13,IF('Bilgi Girişi'!K15=\"Evet\",(J13*0.8),0))))","v":0},null,null,null,null,null,null,{"$f":"IF(R14=0,0,\"Emekliye Esas Ek Gostergesi Farklı ise Emekli Kes. Tabi Dev.Kat. Ek Gösterge Tutarı\")","v":0},{"$f":"ROUND(IF('Bilgi Girişi'!G29<>'Bilgi Girişi'!G31,('Bilgi Girişi'!G31*'Değerler Tablosu'!E6),0),2)","v":0},null,null,{"$f":"IF('Bilgi Girişi'!G7=\"\",\"\",\"Damga Vergisi\")","v":""},{"$f":"IF(J27>0,ROUND((F6+F18+F13+F15+M30+M29+J15+J24+N13+J11+J18+J22+N7+N8+N11+N6+N9+J21)*Vergi!D11,2),ROUND((F6+F18+F13+F15+J8+J6+J15+J24+N13+J11+J18+J22+N7+N8+N11+N6+N9+J21)*Vergi!D11,2))","v":0}]
[null,null,null,null,{"$f":"IF('Bilgi Girişi'!G7=\"\",\"\",\"Ödemeye Esas Kıdem Aylık\")","v":""},{"$f":"ROUND(((('Bilgi Girişi'!G24*20)*'Değerler Tablosu'!E6)/'Bilgi Girişi'!L3)*'Bilgi Girişi'!L4,2)","v":0},null,null,{"$f":"IF('Bilgi Girişi'!G7=\"\",\"\",IF(J15<=0,0,IF('Bilgi Girişi'!G16='Bilgi Girişi'!H80,\"Temsil TazminatıTutarı\",\"GörevTazminatıTutarı\")))","v":""},{"$f":"ROUND(('Değerler Tablosu'!E6*J14),2)","v":0},null,null,null,null,null,null,{"$f":"IF(R15=0,0,\"Emekliye Esas Ek Gostergesi Farklı ise Emekli Kes.Tabi Şahıs Ek Gösterge Tutarı\")","v":0},{"$f":"ROUND(IF('Bilgi Girişi'!G31<>'Bilgi Girişi'!G29,('Bilgi Girişi'!G31*'Değerler Tablosu'!E6),0),2)","v":0},null,null,{"$f":"IF('Bilgi Girişi'!G7=0,0,IF('Bilgi Girişi'!G7='Bilgi Girişi'!F89,0,\"Emekli Keseneği (Devlet) Katkısı % 20\"))","v":0},{"$f":"+AA6","v":0}]
[null,null,null,null,{"$f":"IF('Bilgi Girişi'!G7=\"\",\"\",IF('Bilgi Girişi'!G29=\"\",\"\",\"Eski Kıdem Aylık\"))","v":""},{"$f":"IF('Bilgi Girişi'!G23=\"\",+F15,ROUND(((('Bilgi Girişi'!G25*20)*'Değerler Tablosu'!E6)/'Bilgi Girişi'!L3)*'Bilgi Girişi'!L4,2))","v":0},null,null,{"$f":"IF('Bilgi Girişi'!G7=\"\",\"\",IF('Bilgi Girişi'!K24=\"evet\",\"Ödemeye Esas Özelleştirme Tazminatı Tutarı\",0))","v":""},{"$f":"IF(I16=0,0,IF('Bilgi Girişi'!L24=0,0,'Bilgi Girişi'!L24-V34))","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"IF('Bilgi Girişi'!G7=0,0,IF('Bilgi Girişi'!G7='Bilgi Girişi'!F89,0,\"Emekli Keseneği (Kişi) %16\"))","v":0},{"$f":"IF(R8=0,(AA5*0.16),IF(AND(R8>=R5,AB5>AA5,(AA5*0.16)+V19),((AB5*0.16)+V19)))","v":0}]
[null,null,null,null,{"$f":"IF('Bilgi Girişi'!G7=\"\",\"\",\"Kıdem Aylık Farkı\")","v":""},{"$f":"IF(F16=0,0,IF(F15=F16,0,(F15-F16)))","v":0},null,null,{"$f":"IF('Bilgi Girişi'!G7=\"\",\"\",IF('Bilgi Girişi'!G15='Bilgi Girişi'!F92,0,IF('Bilgi Girişi'!K12=\"Evet\",\"İdari Pers.Dil Tazminatı Puanı\",0)))","v":""},{"$f":"IF(ISERROR(IF(I17=0,0,VLOOKUP('Bilgi Girişi'!G16,'Değerler Tablosu'!N7:P15,3,FALSE))),0,IF(I17=0,0,VLOOKUP('Bilgi Girişi'!G16,'Değerler Tablosu'!N7:P15,3,FALSE)))","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(U29=0,0,\"Mal.Yaş.Ölüm Sig   % 9 (Şahıs)\")","v":0},{"$f":"IF(U17=0,0,ROUND(((R14+F14+F15+J7+N7+F18+F10+F13)*'Değerler Tablosu'!$O$37)/100,2))","v":0},null,null,null,"Hayat Sigortası Matrahı"]
[null,{"$f":"LARGE(C18:C20,1)","v":0},{"$f":"ROUND(IF(F18=0,0,F18/'Değerler Tablosu'!E6),0)","v":0},{"$f":"SMALL(C18:C20,1)","v":0},{"$f":"IF('Bilgi Girişi'!G7=\"\",\"\",\"Ek Gosterge Ödemeye Esas\")","v":""},{"$f":"ROUND((('Bilgi Girişi'!G28*'Değerler Tablosu'!E6)/'Bilgi Girişi'!L3)*'Bilgi Girişi'!L4,2)","v":0},null,null,{"$f":"IF('Bilgi Girişi'!G7=\"\",\"\",IF(I17=0,0,\"Ödemeye Esas Dil Tazminatı Tutarı\"))","v":""},{"$f":"ROUND((J17*'Değerler Tablosu'!E6),2)","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"IF('Bilgi Girişi'!G7=0,0,IF('Bilgi Girişi'!G7='Bilgi Girişi'!F89,0,\"Artış %100 (Devlet + Kişi)\"))","v":0},{"$f":"0*1","v":0},null,null,null,{"$f":"F6+F13+F15+F18+J6+J8+J24+N7+N9+N8+N11+J22+F25","v":0}]
[null,null,{"$f":"ROUND(IF(F19=0,0,F19/'Değerler Tablosu'!E6),0)","v":0},null,{"$f":"IF('Bilgi Girişi'!G7=\"\",\"\",\"Ek Gosterge EmEkliliğe Esas (Devlet)\")","v":""},{"$f":"ROUND(IF('Bilgi Girişi'!G29>G29,('Bilgi Girişi'!G30*'Değerler Tablosu'!E6),('Bilgi Girişi'!G29*'Değerler Tablosu'!E6)),2)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Eski Em Ek Göst Büyük İse Fark % 20 Devlet",{"$f":"ROUND(IF(AB5>AA5,(AB5-AA5)*0.2,0),2)","v":0},null,null,null,"Hayat Sigortası Düşülebilecek Maksimum Tutar %15"]
[null,null,null,null,{"$f":"IF('Bilgi Girişi'!G7=\"\",\"\",\"Ek Gosterge Emekliliğe Esas Fark\")","v":""},{"$f":"ROUND(IF(C19>C18,0,IF(F19=0,0,IF(F18=F19,0,(F18-F19)))),2)","v":0},null,null,{"$f":"IF('Bilgi Girişi'!G15='Bilgi Girişi'!F91,0,IF('Bilgi Girişi'!K13=\"Evet\",\"Akademik Pers.Dil Tazminatı Puanı\",0))","v":0},{"$f":"IF(ISERROR(IF(I20=0,0,VLOOKUP('Bilgi Girişi'!L13,'Değerler Tablosu'!O7:P17,2,FALSE))),0,IF(I20=0,0,VLOOKUP('Bilgi Girişi'!L13,'Değerler Tablosu'!O7:P17,2,FALSE)))","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"IF('Bilgi Girişi'!G7=0,0,IF('Bilgi Girişi'!G7='Bilgi Girişi'!F89,0,\"Gen.Sag.Sig.Pir.(% 12 Devlet)\"))","v":0},{"$f":"IF(R8=0,(AA5*0.12),IF(AND(R8>=R5,AB5>AA5,(AA8*0.12)),((AB5*0.12))))","v":0},null,null,null,{"$f":"ROUND((Z18*0.15),2)","v":0}]
[null,{"$f":"+C21","v":0},{"$f":"ROUND(IF(F21=0,0,F21/'Değerler Tablosu'!E6),0)","v":0},null,{"$f":"IF('Bilgi Girişi'!G26=\"\",\"\",\"Eski Yüksek Ek Gosterge Emekliliğe Şahıs\")","v":""},{"$f":"ROUND((('Bilgi Girişi'!G31*'Değerler Tablosu'!E6)/'Bilgi Girişi'!L3)*'Bilgi Girişi'!L4,2)","v":0},null,null,{"$f":"IF(I20=0,0,\"Ödemeye Esas Akademik Dil Tazminatı Tutarı\")","v":0},{"$f":"ROUND(((J20*'Değerler Tablosu'!E6)/'Bilgi Girişi'!L3)*'Bilgi Girişi'!L4,2)","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(U30=0,0,\"Gen.Sag.Sig.Pir.(Kişi) %5\")","v":0},{"$f":"IF(U21=0,0,ROUND(((R14+F14+F15+J7+N7+F18+F10+F13)*'Değerler Tablosu'!$O$38)/100,2))","v":0},null,null,null,"Verdiği Tutar / Girilen Tutar"]
[null,null,null,null,null,null,null,null,{"$f":"IF('Bilgi Girişi'!J14=0,0,\"Yüksek Öğrenim Tazminatı Tutarı\")","v":0},{"$f":"IF(I22=0,0,ROUND(IF('Bilgi Girişi'!K14=\"\",0,((((9500*'Değerler Tablosu'!E6)*'Bilgi Girişi'!K14)/'Bilgi Girişi'!L3)*'Bilgi Girişi'!L4)/100),2))","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"IF('Bilgi Girişi'!G35=\"\",0,\"Sendika Aidatı Tutarı\")","v":0},{"$f":"IF('Bilgi Girişi'!L2=\"Evet\",0,IF('Bilgi Girişi'!G35=\"\",0,ROUND((F6+F18+F13+F15+J8+J6+J15+J24+N13+J11+J18+J22+N7+N8+N11+J21+N9)*Vergi!D12,2)))","v":0},null,null,null,{"$f":"+'Bilgi Girişi'!G33","v":0}]
[null,null,null,null,"Sosyal Haklar",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('Bilgi Girişi'!G38=\"Evet\",\"Taahütlü İcra Kesintisi\",0)","v":0},{"$f":"IF('Bilgi Girişi'!H38<=0,0,+'Bilgi Girişi'!H38)","v":0},null,null,null,"Düşülecek Tutar"]
[null,null,null,null,{"$f":"IF('Bilgi Girişi'!G12=\"Evli Eşi Çalışmıyor\",\"Ödemeye Esas Aile Yardımı Tutarı \",0)","v":0},{"$f":"IF('Bilgi Girişi'!L2=\"Evet\",0,ROUND(IF('Bilgi Girişi'!G12='Bilgi Girişi'!H75,('Değerler Tablosu'!E6*'Değerler Tablosu'!E10),0),2))","v":0},null,null,{"$f":"IF('Bilgi Girişi'!K16=0,0,\"Ödemeye Esas Ek Ödeme Tutarı (666 KHK)\")","v":0},{"$f":"IF('Bilgi Girişi'!K15=\"Evet\",0,ROUND(IF('Bilgi Girişi'!K16<=0,0,(((9500*'Değerler Tablosu'!E6)*'Bilgi Girişi'!K16)/'Bilgi Girişi'!L3)*'Bilgi Girişi'!L4)/100,2))","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"IF('Bilgi Girişi'!K25=\"Evet\",\"Normail İcra Borcu\",0)","v":0},{"$f":"ROUND(IF(U24=0,0,SUM(F6+F18+F13+F15+J8+J6+J24+J11+J15+J18+J22+N7+N8+N11)*0.25),2)","v":0},null,null,null,{"$f":"IF(Z22>Z20,Z20,Z22)","v":0}]
[null,null,null,null,{"$f":"IF('Bilgi Girişi'!G14+'Bilgi Girişi'!H14<=0,0,\"Ödemeye Esas Çocuk Yardımı Tutarı \")","v":0},{"$f":"IF('Bilgi Girişi'!L2=\"Evet\",0,(((('Bilgi Girişi'!G14*'Değerler Tablosu'!E11)+('Bilgi Girişi'!H14*'Değerler Tablosu'!E12))*'Değerler Tablosu'!E6)))+(((('Bilgi Girişi'!G37*'Değerler Tablosu'!E11)+('Bilgi Girişi'!H37*'Değerler Tablosu'!E12))*'Değerler Tablosu'!E6))*0.5","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('Bilgi Girişi'!K26=\"Evet\",\"Normal Kefalet Kesintisi\",0)","v":0},{"$f":"ROUND(IF(U25=0,0,(100*'Değerler Tablosu'!E6)),2)","v":0},null,null,null,"Sakatlık İndirimi İçin"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(V26=0,0,\"Bireysel emeklilik (BES) Tutarı\")","v":0},{"$f":"ROUNDDOWN(IF('Bilgi Girişi'!K23=\"Evet\",(AA5*0.03),0),0)","v":0},null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Bilgi Girişi'!G36,'Değerler Tablosu'!I31:J33,2,FALSE)),0,VLOOKUP('Bilgi Girişi'!G36,'Değerler Tablosu'!I31:J33,2,FALSE))","v":0},"1 Kişi"]
[null,null,null,null,null,null,null,null,"Rapor Günü",{"$f":"+'Bilgi Girişi'!G32","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(V27=0,0,\"Bireysel emeklilik (BES) Tutarı\")","v":0},{"$f":"ROUND(IF('Bilgi Girişi'!K23=\"Evet\",(((V29/11)*100)*0.03),0),0)","v":0},null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Bilgi Girişi'!H36,'Değerler Tablosu'!I31:J33,2,FALSE)),0,VLOOKUP('Bilgi Girişi'!H36,'Değerler Tablosu'!I31:J33,2,FALSE))","v":0},"2.Kişi"]
[null,null,null,null,"Sosyal Güvenlik Primleri / Emekli Kesenekleri",null,null,null,"Rapor için Hesaplacak Tutarlar",null,null,null,"Rapordan Dolayı Ödenecek Tutarlar",null,null,null,null,null,null,null,{"$f":"+'Bilgi Girişi'!J27","v":""},{"$f":"+'Bilgi Girişi'!K27","v":0},null,null,null,{"$f":"SUM(Z26:Z27)","v":0},"Toplama Tutar"]
[null,null,null,null,"Malullül Yaşlılık ve Ölüm Siğortası",null,null,null,"Ö.H.Taz.",{"$f":"+J6","v":0},null,null,{"$f":"J29-(ROUND(IF(J27>0,((($J$29/'Bilgi Girişi'!L3)*Hesaplamalar!$J$27)*$J$31))/100,2))","v":0},null,null,null,null,null,null,null,{"$f":"IF('Bilgi Girişi'!G7='Bilgi Girişi'!F89,\"Mal.Yaş.Ölüm Sig   % 11 (Devlet)\",0)","v":0},{"$f":"IF(U29=0,0,ROUND(((R14+F14+F15+J7+N7+F18+F10+F13)*'Değerler Tablosu'!$N$37)/100,2))","v":0}]
[null,null,null,null,{"$f":"IF('Bilgi Girişi'!G7=\"\",\"\",\"11% İşverenı Hissesi\")","v":""},{"$f":"+V29","v":0},null,null,"Yan Ödeme",{"$f":"+J8","v":0},null,null,{"$f":"J30-(ROUND(IF(J27>0,((($J$30/'Bilgi Girişi'!L4)*Hesaplamalar!$J$27)*$J$31))/100,2))","v":0},null,null,null,null,null,null,null,{"$f":"IF('Bilgi Girişi'!G7='Bilgi Girişi'!F89,\"Gen Sağ.Sig   % 7,5 (Devlet)\",0)","v":0},{"$f":"IF(U30=0,0,ROUND(((R14+F14+F15+J7+N7+F18+F10+F13)*'Değerler Tablosu'!$N$38)/100,2))","v":0}]
[null,null,null,null,{"$f":"IF('Bilgi Girişi'!G7=\"\",\"\",\"EMEKLI KESN.%20\")","v":""},{"$f":"+V15","v":0},null,null,"Rapor İnd.Oranı %",25,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('Bilgi Girişi'!G7=\"\",\"\",\"Asgari Geçim İndirimi Tutarınız\")","v":""},{"$f":"+'Asg Geç İnd'!Y4","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('Bilgi Girişi'!G7=\"\",\"\",\"Gelirler  Toplamınız\")","v":""},{"$f":"F6+F18+F13+F15+J8+J6+AA6+AA9+F24+F25+J24+N13+J11+J15+J18+J22+N7+N8+N11+V29+V30+N6+J21+N9","v":0}]
[null,null,null,null,"Genel Sağlık Siğortası Pirimi",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('Bilgi Girişi'!G7=\"\",\"\",\"Kesinti Toplamınız\")","v":""},{"$f":"V9+V14+V15+V16+V18+V20+V21+V22+V17+V23+V24+V25+V26+V27+V28","v":0}]
[null,null,null,null,{"$f":"IF('Bilgi Girişi'!G7=\"\",\"\",\"7,5 % İşveren Hissesi\")","v":""},{"$f":"+V30","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('Bilgi Girişi'!G7=\"\",\"\",\"Net Ödenecek Maaşş Tutarınız\")","v":""},{"$f":"V32-V33","v":0}]
[null,null,null,null,{"$f":"IF('Bilgi Girişi'!G7=\"\",\"\",\"12 % İşveren Hissesi\")","v":""},{"$f":"+V20","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('Bilgi Girişi'!K24=\"Evet\",\"Net Ödenen Maşınız Özelleştirme Tazminatı Dahil\",0)","v":0},{"$f":"IF('Bilgi Girişi'!K24=\"Evet\",J16+V34,0)","v":0}]
[]
[null,null,null,null,{"$f":"IF('Bilgi Girişi'!G7=\"\",\"\",\"EMEKLI KESN.%100 ŞAHIS\")","v":""},{"$f":"+F38","v":0}]
[null,null,null,null,{"$f":"IF('Bilgi Girişi'!G7=\"\",\"\",\"EMEKLI KESN.%100 Devlet\")","v":""},{"$f":"+V13","v":0}]

{"sheet":"Tablo","index":3,"n_rows":65,"n_cols":20,"rows_kept":65,"cut":false,"hidden":false,"merged":[[61,19,61,20],[62,19,64,20],[62,13,64,13],[62,14,63,14],[62,15,64,15],[62,16,63,16],[57,1,64,1],[57,4,57,5],[57,19,57,20],[58,4,58,5],[58,19,58,20],[62,17,64,17],[62,18,63,18],[62,2,63,2],[62,4,64,5],[62,6,64,6],[62,7,64,11],[62,12,64,12],[59,4,59,5],[59,19,59,20],[60,19,60,20],[61,4,61,5],[36,1,38,1],[36,19,36,20],[37,3,37,4],[37,19,37,20],[38,19,38,20],[41,1,54,1],[41,19,41,20],[42,19,42,20],[43,19,43,20],[44,19,44,20],[45,19,45,20],[46,19,46,20],[47,19,47,20],[48,19,48,20],[49,3,49,4],[49,19,49,20],[50,19,50,20],[51,19,51,20],[53,19,53,20],[54,19,54,20],[27,19,27,20],[30,1,33,1],[30,19,30,20],[31,19,31,20],[32,19,32,20],[33,19,33,20],[22,19,22,20],[23,19,23,20],[24,1,26,1],[24,19,24,20],[25,19,25,20],[26,19,26,20],[13,20,13,21],[14,1,21,1],[14,20,14,21],[15,19,15,20],[16,19,16,20],[17,19,17,21],[18,19,18,20],[19,19,19,20],[20,19,20,20],[21,19,21,21],[1,19,1,20],[2,19,2,20],[5,1,12,1],[5,19,5,20],[6,19,6,20],[7,19,7,20],[8,19,8,20],[9,19,9,20],[10,19,10,20],[11,19,11,20],[12,19,12,20]]}
[]
[null,null,null,null,null,null,null,null,null,"5510 Sayılı Kanuna Göre 4/c kapsamında 01/10/2008 den Önce Memuriyete Başlayanlar ",null,null,null,null,null,null,null," 5510 Sayılı Kanuna Göre 4/c kapsamında 01/10/2008 den Sonra Memuriyete Başlayanlar ",null,"5510 Sayılı Kanuna Göre 4/c kapsamında 01/10/2008 den Önce Memuriyete Başlayanlar "]
[null,"Harcama Gurubu",null,"Harcama Kalemi",null,"Damga Vergisi",null,"Gelir Vergisi",null,"Emekli Keseneği",null,"Tasarruf Kesintisi",null,"Döner Sermaye",null,"Vergi İndirimi",null,"Malüllük  Yaşlılık ve Ölüm  & Genel Sağlık Siğortası Primi",null,"\"01/07/2008 den itibaren 3 yıl Sonra \"  18/12/2009 tarih ve 27436 sayılıR.G Yayımlanan KAMU PERSONELİNİN GENEL SAĞLIK SİGORTASI KAPSAMINA\nALINMASI HAKKINDA TEBLİĞ 5.Maddesi\nGenel Sağlık Siğortası Primi  % 12 Tamamı İşverenden"]
[]
[]
[null,"Temel Maaşlar      (Eski 110)",null,"MAAŞ",null,"Tabi",null,"Tabi",null,"-----",null,"Tabi",null,"Tabi",null," ------",null," ------",null,"-----"]
[null,null,null,"EMEKLİ MAAŞI",null," ------",null,"----",null,"Tabi",null,"-----",null,"-----",null," ------",null,"Tabi",null,"Tabi"]
[null,null,null,"TABAN MAAŞ",null,"Tabi",null,"Tabi",null,"Tabi",null,"Tabi",null," ------",null," ------",null,"Tabi",null,"Tabi"]
[null,null,null,"KIDEM",null,"Tabi",null,"Tabi",null,"Tabi",null,"Tabi",null," ------",null," ------",null,"Tabi",null,"Tabi"]
[null,null,null,"EK GOSTERGE",null,"Tabi",null,"Tabi",null," ------",null,"Tabi",null,"Tabi",null," ------",null," ------",null," ------"]
[null,null,null,"Emekli Ek Göstersi",null," ------",null," ------",null,"Tabi",null," ------",null," ------",null," ------",null,"Tabi",null,"Tabi"]
[null,null,null,"İKİNCİ GÖREV AYLIĞI",null,"Tabi",null,"Tabi",null," ------",null," ------",null," ------",null," ------",null," ------",null," ------"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," ------"]
[null,"Sos Güv.Primi",null,"Malullül Yaşlılık ve Ölüm Siğortası"]
[null,null,null,"9  % Sigortalı Hissesi",null," ------",null," ------",null," ------",null," ------",null," ------",null,"Tabi",null," ------",null," ------"]
[null,null,null,"11% İşverenı Hissesi",null," ------",null," ------",null," ------",null," ------",null," ------",null," ------",null," ------",null," ------"]
[]
[null,null,null,"Genel Sağlık Siğortası Pirimi",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," ------"]
[null,null,null,"5 % Sigortalı Hissesi",null," ------",null," ------",null," ------",null," ------",null," ------",null,"Tabi",null," ------",null," ------"]
[null,null,null,"7,5 % İşverenı Hissesi",null," ------",null," ------",null," ------",null," ------",null," ------",null," ------",null," ------",null," ------"]
[null,null,null,"12 % İşverenı Hissesi",null," ------",null," ------",null," ------",null," ------",null," ------",null," ------",null," ------",null,"01/10/2008 den Önceki Memurlar İçin,    Emekli Keseneğine Tabi Gelirler Üzerinden Tamamı Devletten % 100 Artış Varsa Artıştan Önceki Matrahr Üzerinden"]
[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,"Emekli Sandığına  (Eski 110)",null,"EMEKLI KESN.%20",null," ------",null," ------",null," ------",null," ------",null," ------",null," ------",null," ------",null," ------"]
[null,null,null,"EMEKLI KESN.%25",null," ------",null," ------",null," ------",null," ------",null," ------",null,"Tabi",null," ------",null," ------"]
[null,null,null,"EMEKLİ KESN.%100",null," ------",null," ------",null," ------",null," ------",null," ------",null,"Tabi",null," ------",null," ------"]
[]
[]
[]
[null,"Sosyal Haklar    (Eski 140)",null,"COCUK YARDIMI",null," ------",null," ------",null," ------",null," ------",null," ------",null," ------",null," ------",null," ------"]
[null,null,null,"AİLE YARDIMI",null," ------",null," ------",null," ------",null," ------",null," ------",null," ------",null," ------",null," ------"]
[null,null,null,"TAS.KES.DEV.KATS.%3 Kaldırıldı",null," ------",null," ------",null," ------",null," ------",null," ------",null," ------",null," ------",null," ------"]
[null,null,null,"DOĞUM YARDIMI",null," ------",null," ------",null," ------",null," ------",null," ------",null," ------",null," ------",null," ------"]
[]
[]
[null,"Ek Çalışma Karşılıkları (150)",null,"EK ÇALIŞMA KARŞL.",null,"Tabi",null,"Tabi",null," ------",null," ------",null," ------",null," ------",null," ------",null," ------"]
[null,null,null,"EK ÇALIŞMA KARŞL.(2.ÖĞRT)",null,"Tabi",null,"Tabi",null," ------",null," ------",null," ------",null," ------",null," ------",null," ------"]
[null,null,null,"EK ÇALIŞMA KARŞL.(Nöbet)"," ","Tabi",null," ------",null," ------",null," ------",null," ------",null," ------",null," ------",null," ------"]
[]
[]
[null,"Zamlar         Ve       Tazminatlar                (Eski 160)",null,"İŞ RİSKİ(YAN ÖDEME)",null,"Tabi",null,"Tabi",null," ------",null,"Tabi",null,"Tabi",null," ------",null," ------",null," ------"]
[null,null,null,"ÖZEL HİZMET TAZMİ.",null,"Tabi",null," ------",null," ------",null,"Tabi",null,"Tabi",null," ------",null,"Tabi",null," ------"]
[null,null,null,"ARAZİ TAZMİNATI",null,"Tabi",null," ------",null," ------",null," ------",null," ------",null," ------",null," ------",null," ------"]
[null,null,null,"Yapı İşl.Tek.Dai.Bşk              % 30 Ek Taz.",null,"Tabi",null," ------",null," ------",null," ------",null,"Tabi",null," ------",null," ------",null," ------"]
[null,null,null,"MAKAM TAZMİNATI",null,"Tabi",null," ------",null," ------",null,"Tabi",null," ------",null," ------",null,"Tabi",null," ------"]
[null,null,null,"TEMSİL TAZMİNATI",null,"Tabi",null," ------",null," ------",null,"Tabi",null," ------",null," ------",null,"Tabi",null," ------"]
[null,null,null,"GÖREV TAZMİNATI",null,"Tabi",null," ------",null," ------",null," ------",null," ------",null," ------",null,"Tabi",null," ------"]
[null,null,null,"NÖBET TAZMİNATI",null,"Tabi",null,"Tabi",null," ------",null," ------",null," ------",null," ------",null," ------",null," ------"]
[null,null,null,"SAGLIK BAKAN.FARKI",null," ------",null," ------",null," ------",null," ------",null,"Tabi",null," ------",null," ------",null," ------"]
[null,null,null,"ÖZELLEŞTİRMEDEN DOGAN FARK",null," ------",null," ------",null," ------",null," ------",null," ------",null," ------",null," ------",null," ------"]
[null,null,null,"YABANCI DİL TAZMİ.",null,"Tabi",null," ------",null," ------",null," ------",null,"Tabi",null," ------",null," ------",null," ------"]
[null,null,null,"YÜKSEK ÖĞRETİM TAZMİNATI",null,"Tabi",null," ------",null," ------",null," ------",null," ------",null," ------",null," ------",null," ------"]
[null,null,null,"LOJMAN TAZMİNATI         31/03/2006 tarih ve 26125 say.Res.Gaz.Yayım.5473 say.Kan.11.Mad.ileKaldırıld",null,"Tabi",null," ------",null," ------",null," ------",null," ------",null," ------",null," ------",null," ------"]
[null,null,null,"Ek Ödeme                31/3/2006 Tarih ve 26125 Say.R.G Yayımlanan 5473 Say.Kanunla ",null,"Tabi",null," ------",null," ------",null," ------",null," ------",null," ------",null," ------",null," ------"]
[]
[]
[null,"Ödenekler (Eski 170)",null,"İDARİ GÖREV ÖDENEĞİ","Tabi",null,null,"Tabi",null," ------",null,"Tabi",null,"Tabi",null," ------",null," ------",null," ------"]
[null,null,null,"GELİŞTİRME ÖDENEĞİ","Tabi",null,null," ------",null," ------",null,"Tabi",null," ------",null," ------",null," ------",null," ------"]
[null,null,null,"ÜNİVERSİTE ÖDENEĞİ","Tabi",null,null," ------",null," ------",null,"Tabi",null,"Tabi",null," ------",null,"Tabi",null," ------"]
[null,null,null,"AKADEMİK TEŞVİK ÖDENEĞİ",null,"Tabi",null," ------",null," ------",null,"Tabi",null,"Tabi",null," ------",null,"Tabi",null," ------"]
[null,null,null,"EĞİTİM ÖĞRT.ÖDENEĞİ","Tabi",null,null," ------",null," ------",null,"Tabi",null,"Tabi",null," ------",null," ------",null," ------"]
[null,null,null,"Sendika Ödeneği                “31/3/2006 Tarih ve 26125 Say.R.G Yayımlanan 5473 Say.Kanunla eklenen (ek madde 4) 4688 ","Tabi",null,null,"25.02.2011 Tarih ve 27857 sayılı Mükerrer r.g yayımlanan 6111 sayılı kanunun 118.maddesi ile  Ocak Nisan,Temmuz ve Ekim aylarında peşin 45,00 TL Toplu Sözleşme Primi Getirildi",null,null,null,null,null," ------",null,"Tabi                                                 (kendisinden Kesilen Kısmı Kadar)    ",null," ------",null," ------"]
[null,null,null,"sayılı Kamu Görevlileri Sendikaları Kanunu Hükümleri Uyarınca Kamu Görevlileri Sendikalarına  Üye Olanlara 15/01/2006 dan itibaren 5.00.-YTL Tutarında ödenir"]
[null,null,null,"Not:  Sendika Yardımı 10/11/2009 tarih ve 27402 sayılı R.G Yayımlanan 2006/94 Esas 2009/92 Karar 25.06/2009 tarihli Anayasa Mah.Kararı İle İptal edildi"]

{"sheet":"Ödeme Emri","index":4,"n_rows":41,"n_cols":24,"rows_kept":41,"cut":false,"hidden":false,"merged":[[1,0,1,1],[1,2,1,12],[2,0,2,1],[2,2,2,12],[2,13,2,15],[2,16,2,18],[2,19,6,19],[2,20,2,22],[3,0,4,1],[3,7,4,12],[3,13,3,15],[3,16,3,18],[3,20,3,22],[4,13,4,15],[4,16,4,18],[4,20,4,22],[5,0,5,1],[5,2,5,18],[5,20,5,22],[6,0,6,1],[6,2,6,18],[6,20,6,22],[9,2,10,2],[9,3,10,3],[9,4,10,4],[9,6,10,6],[9,7,10,7],[9,5,10,5],[7,0,10,1],[7,2,8,6],[7,7,8,10],[9,8,10,8],[9,9,10,9],[9,10,10,10],[9,13,10,13],[9,14,10,14],[9,15,10,15],[9,16,10,16],[9,18,10,19],[9,20,10,22],[7,23,10,23],[8,11,8,12],[8,13,8,16],[8,18,8,19],[8,20,8,22],[7,11,7,12],[7,13,7,17],[7,18,7,22],[9,11,10,12],[16,18,16,19],[16,20,16,22],[11,0,11,1],[11,11,11,12],[11,18,11,19],[11,20,11,22],[15,0,15,1],[15,11,15,12],[12,20,12,22],[13,20,13,22],[14,20,14,22],[15,18,15,19],[15,20,15,22],[13,18,13,19],[21,20,21,22],[22,0,22,1],[22,11,22,12],[22,18,22,19],[17,0,17,1],[17,11,17,12],[17,18,17,19],[18,20,18,22],[17,20,17,22],[18,0,18,1],[18,11,18,12],[18,18,18,19],[22,20,22,22],[19,11,19,12],[19,18,19,19],[20,0,20,1],[20,11,20,12],[20,18,20,19],[20,20,20,22],[19,20,19,22],[19,0,19,1],[23,20,23,22],[26,0,26,1],[26,11,26,12],[24,0,24,1],[28,0,28,1],[28,11,28,12],[28,18,28,19],[28,20,28,22],[29,0,29,1],[25,0,25,1],[25,11,25,12],[25,18,25,19],[27,0,27,1],[24,20,24,22],[24,11,24,12],[24,18,24,19],[25,20,25,22],[33,0,33,16],[33,18,33,19],[12,0,12,1],[12,11,12,12],[12,18,12,19],[13,0,13,1],[13,11,13,12],[31,0,31,1],[31,11,31,12],[31,18,31,19],[32,0,32,16],[32,18,32,19],[14,0,14,1],[14,11,14,12],[14,18,14,19],[29,18,29,19],[23,0,23,1],[23,11,23,12],[23,18,23,19],[21,0,21,1],[21,11,21,12],[21,18,21,19],[16,0,16,1],[16,11,16,12],[32,20,32,22],[31,20,31,22],[27,11,27,12],[27,18,27,19],[26,18,26,19],[30,0,30,1],[30,11,30,12],[30,18,30,19],[30,20,30,22],[26,20,26,22],[29,11,29,12],[29,20,29,22],[27,20,27,22]]}
[]
["Muhasebe Birimi Kodu","","??","","",null,"","","","","","","","","","","","","","","","",""]
["Muhasebe Birimi Adı","",{"$f":"+'Bilgi Girişi'!G3","v":0},"","",null,"","","","","","","","Bütçe Yılı","","",{"$f":"+'Bilgi Girişi'!H4","v":2018},"","","İ l g i l i n i n ","Adı, Soyadı/Ünvanı","",""]
["Kurum-Birim Kodu","",1,2,3,4,5,"Yevmiyenin","","","","","","Tarihi","","","","","","","T.C./ Vergi Kimlik No","",""]
["","",38,44,0,0,908,"","","","","","","No.su","","",0,"","","","Banka Şube Adı","",""]
["Kurum Adı","",{"$f":"+C3","v":0},"","",null,"","","","","","","","","","","","","","","Banka Hesap Numarası","",""]
["Birim Adı","",{"$f":"+'Bilgi Girişi'!I4","v":"Birim"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","Bağlı Olduğu Vergi Dairesi","",""]
["Hesap No","","Kurumsal Kod","","",null,"","Fonksiyonel Kod","","","","Finans","","Ekonomik /","","","","","T u t a r","","","","","Hesap / Ayrıntı Adı"]
["","","","","",null,"","","","","","Kodu","","Y. Hesap Kodu","","","","","B o r ç","","A l a c a k","","",""]
["","",1,2,3,4,5,1,2,3,4,1,"",1,2,3,4,5,{"$f":"IF(txtYil>2008,\"TL\",\"YTL\")","v":"TL"},null,{"$f":"IF(txtYil>2008,\"TL\",\"YTL\")","v":"TL"},null,null,""]
["","","","","","","","","","","","","","","","","","",null,null,null,null,null,""]
["630","",{"$f":"+$C$5","v":38},{"$f":"+$D$5","v":44},{"$f":"+$E$5","v":0},{"$f":"+$F$5","v":0},{"$f":"+$G$5","v":908},null,null,null,null,"2","","01","01","01",1,"",{"$f":"Bordro!E10+Bordro!E12+Bordro!E13+Bordro!E11","v":0},null,"",null,null,"Temel Maaşlar"]
["630","",38,44,0,0,908,null,null,null,null,"2","","01","01",2,1,null,{"$f":"Bordro!E14+Bordro!E23+Bordro!E18+Bordro!E25+Bordro!E33+Bordro!E24+Bordro!E27+Bordro!E26","v":0},null,"",null,null,"Zamlar ve Tazminatlar"]
["630","",38,44,0,0,908,null,null,null,null,"2","","01","01",4,1,null,{"$f":"Bordro!E22+Bordro!E21","v":0},null,"",null,null,"Sosyal Haklar"]
["630","",38,44,0,0,908,null,null,null,null,"2","","01","01",4,1,null,{"$f":"Bordro!E30+Bordro!E28+Bordro!E29+Bordro!E32+Bordro!E31+Bordro!E34","v":0},null,"",null,null,"Ödenekler"]
["630","",38,44,0,0,908,null,null,null,null,"2","","02",1,"06","01","",{"$f":"Bordro!E16+Bordro!E15","v":0},null,"",null,null,"Sosyal Güvenlik Primi Ödemeleri (%20 Devlet Katkısı)"]
["630","",38,44,0,0,908,null,null,null,null,"2","","02",1,"06","02","",{"$f":"Bordro!E17+Bordro!E19","v":0},null,"",null,null,"Sağlık Primi Ödemeleri (Gen Sağ Sig % 12 Devlet)"]
["360","","","","",null,"","","","","","","","01","01","02","00","",{"$f":"Bordro!C25","v":0},null,"",null,null,"Diğer Ücretler ile Ücret sayılan Ödemelerden Yapılan Tevkifa(Asg.Geç.İnd.)"]
["360","","","","",null,"","","","","","","","01","01","02","00","",null,null,{"$f":"Bordro!G10+Bordro!C25","v":0},null,null,"Diğer Ücretler ile Ücret sayılan Ödemelerden Yapılan Tevkifa"]
["360","","","","",null,"","","","","","","","03","01","00","00","",null,null,{"$f":"+Bordro!G11","v":0},null,null,"Ücret ve Ücret Sayılan Ödemelere Ait Damga Vergisi"]
["361","","","","",null,"","","","","","","","10","01","01",1,"",null,null,{"$f":"+Bordro!G19","v":0},null,null,"Malüllük,Yaşlılık ve Emeklilik Primi (% 9 Şahıs Kesintisi)"]
["361","","","","",null,"","","","","","","","10","01",1,2,"",null,null,{"$f":"+Bordro!G25","v":0},null,null,"Genel Sağlık Sigortası Primi (% 5 Şahıs Kesintisi)"]
["361","","","","",null,"","","","","","","","10","02",2,1,"",null,null,{"$f":"+Bordro!G14","v":0},null,null,"Malüllük,Yaşlılık ve Emeklilik Primi (% 11 Devlet Katkısı)"]
["361","","","","",null,"","","","","","","",1,2,1,0,"",null,null,{"$f":"+Bordro!G12","v":0},null,null,"Sosyal Güvenlik Primi Ödemeleri (%20 Devlet Katkısı)"]
["361","","","","",null,"","","","","","","",1,1,1,0,"",null,null,{"$f":"+Bordro!G13","v":0},null,null,"Sosyal Güvenlik Primi Ödemeleri (%16 Şahıs Kesintisi)"]
["361","","","","",null,"","","","","","","",1,2,4,0,"",null,null,{"$f":"IF(Bordro!G16=0,+Bordro!G15,Bordro!G16)","v":0},null,null,"Genel Sağlık Sigortası Primi (% 12 Devlet Katkısı)"]
[362,"","","","",null,"","","","","","","",2,6,2,0,"",null,null,{"$f":"+Bordro!G23","v":0},null,null,"Kefalet Aidatı Aylık Kesintisi"]
[333,null,"","","",null,"","","","","","","",3,3,0,0,"",null,null,{"$f":"+Bordro!G21","v":0},null,null,"Tahhütlü İcra Kesintisi"]
["333","",null,null,null,null,null,null,null,null,null,"","",3,1,0,0,null,null,null,{"$f":"+Bordro!G22","v":0},null,null,"Normal İcra Kesintisi"]
["333","",null,null,null,null,null,null,null,null,null,"","","10","03",null,null,null,null,null,{"$f":"+Bordro!G20","v":0},null,null,"…….Sendikası (Sendika Aidatı)"]
[361,"",null,null,null,null,null,null,null,null,null,"","",98,9,2,null,null,null,null,{"$f":"+Bordro!G24","v":0},null,null,"BES (Vakıfbank Emeklilik A.Ş)Diğer"]
["103","",{"$f":"+$C$5","v":38},{"$f":"+$D$5","v":44},{"$f":"+$E$5","v":0},{"$f":"+$F$5","v":0},{"$f":"+$G$5","v":908},"","","","","","","02","00","00","00","",null,null,{"$f":"+Bordro!G30+Bordro!E33","v":0},null,null,"Verilen Gönderme Emirleri Hesabı"]
["TOPLAM",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(S12:T32)","v":0},null,{"$f":"SUM(U12:W32)","v":0},null,null,"TOPLAM"]
["Bordrodaki TOPLAM Hakediş (Bütçe Gideri Tahakkuk TOPLAMI)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(S12:T17)","v":0}]
[]
[]
[]
[]
[]
[]
[{"$f":"+'Bilgi Girişi'!F43","v":0}]

{"sheet":"Değerler Tablosu","index":5,"n_rows":81,"n_cols":26,"rows_kept":81,"cut":false,"hidden":false,"merged":[[9,24,11,24],[3,2,3,4],[7,2,7,3],[10,2,10,3],[11,2,11,3],[4,8,4,9],[5,8,5,9],[6,8,6,9],[8,9,9,9],[5,2,5,3],[4,2,4,3],[11,9,12,9],[6,2,6,3],[12,2,12,3],[8,2,8,3],[9,2,9,3],[13,2,13,3],[17,2,17,4],[18,2,18,3],[19,2,19,3],[25,2,25,3],[23,2,23,3],[24,2,24,3],[20,8,20,9],[20,2,20,3],[21,2,21,3],[18,17,18,18],[22,2,22,3],[22,23,22,24],[44,2,44,3],[39,2,39,3],[40,2,40,3],[41,2,41,3],[42,2,42,3],[43,2,43,3],[34,2,34,4],[35,2,35,3],[36,2,36,3],[37,2,37,3],[38,2,38,3],[27,2,27,3],[26,2,26,3]]}
[]
[]
[null,null,null,null,null,null,null,null,"MAKAM TAZMİNATI CETVELİ (Ek: 20/3/1997-KHK-570/7 md.)"]
[null,null,"Cari Dönem"]
[null,null,"Yıl",null,2018,null,null,null,"MAKAM TAZMİNATI",null,null,null,null,null,"Akademik",null,null,"Y.DİL TAZMİNATI",null,null,null,null,null,"             Üniversite Ödeneği"]
[null,null,"Maaş Katsayısı",null,0.10854999999999999,null,null,null,"Mak.Taz.Göst. X Maaş Katsayısı",null,null,null,null,null,"Y.DİL TAZMİNATI",null,null,"27/3/2006 tar.ve 29299 veya 23299 sy.R.G.",null,null,null,null,null," Madde 12 – (Değişik : 20/3/1997 - KHK - 570/4 md.)"]
[null,null,"Yan Ödeme Katsayısı",null,3.4424000000000003E-2,null,null,null,"(Yük.Öğrt.Personel Kan.Ek Mad.2(Ek:20/3/1997-KHK-570/7 Md.)",null,null,null,null,null,"A",900,null,"A1 İçin","100 -96  Puan",null,null,null,null,"ÜNİVERSİTE ÖDENEĞİ    (Yüksek Öğrenim Personel Kanunu 12.md.    Ve (23/2/95 tarih 547 sayılı KHK ile)"]
[null,null,"Taban Aylık Katsayısı",null,1.6991210000000001,null,null,null,"Rektör",7000,null,null,null,null,"B",600,null,"A   İçin","  90 -95  Puan",null,null,null,null,"             657 sayılı Devlet Memurları Kanununa tabi en yüksek Devlet memuru brüt aylık (ek gösterge dahil) tutarının;"]
[null,null,"Taban Aylık Çarpanı",null,1000,null,null,null,"3 Yıllık Profesör",6000,null,null,null,null,"C",300,null,"B   İçin","  80 -89  Puan ",null,null,null,null,null,"%"]
[null,null,"Aile Yardımı Puanı",null,2134,null,null,null," (Bu kadroda üç yılını tamamlamış olmak şartıyla)",null,null,null,null,null,"D",2100,null,"C   İçin","  70 -79 Puan",null,null,null,null,"1) Profesörlerden Rektör, Rektör Yardımcısı, Dekan, ",245]
[null,null,"Çocuk Yardımı Puanı 72 Aydan Küçük",null,500,null,null,null,"Yeni Profesör",4500,null,null,null,null,"E",1200,null,null,null,null,null,null,null,"Dekan Yardımcısı, Yüksekokul Müdürü olanlar ile "]
[null,null,"Çocuk Yardımı Puanı 72 Aydan Büyük",null,250,null,null,null,"Doçent",2000,null,null,null,null,"A1",1200,null,null,null,null,null,null,null,"Profesör kadrosunda üç yılını tamamlamış bulunanlara                            "]
[null,null,"Asgari Ücret (Günlük)",null,67.650000000000006,null,null,null,"(Kaz.Hak.aylığı 1.Derece Olmak Kaydıyla)",null,null,null,null,"Araştırmacı 1","C",250]
[null,null,"Sendika Topl.Sö.z Prim Puanı",null,750,null,null,null,"Genel Sekreter",2000,null,null,null,"İç Denetçi","B",600,null,null,null,null,null,null,null,"2) Diğer Profesör kadrosunda bulunanlara "]
[null,null,null,null,null,null,null,null,"Araştırmacı 1",3500,null,null,null,null,null,null,null,null,null,null,null,null,null,"(yeni ve 3 Yıldan Az Olanlara ) ",215]
[null,null,null,null,null,null,null,null,"İç Denetçi",2000]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"3) Doçent kadrosunda bulunanlara",175]
[null,null,null,null,null,null,null,null,"GÖREV TAZMİNATI",null,null,null,null,null,null,null,null,"Akademik Teşvik Oranları %"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Yeni Profesör",100,null,null,null,null,"4) Yardımcı Doçent kadrosunda bulunanlara (Doktor Öğrt. Grv.)",165,"Eski"]
[null,null,null,null,null,null,null,null,"Makam Tazminatı Gösterge Rakamları",null,"İlave","Toplam",null,null,null,null,null,"3 Yıllık Profesör",100,null,null,null,null,null,175,"Yeni"]
[null,null,null,null,null,null,null,null,6000,"Olanlar için",9000,{"$f":"I22+K22","v":15000},null,null,null,null,null,"Prof.Dr.",100,null,null,null,null,"5) Diğer Öğretim elemanlarından;"]
[null,null,null,null,null,null,null,null,5500,"Olanlar için",7000,12500,null,null,null,null,null,"Doç.Dr.",90,null,null,null,null,"(Öğrt.Grv-Uzman-Okt-ğt.Öğr.Plan)",null,"Eski"]
[null,null,null,null,null,null,null,null,4500,"Olanlar için",7000,11500,null,null,null,null,null,"Yrd.Doç.Dr.",80,null,null,null,null,"(Öğetim Görevlisi ve Araş Görevlileri)",null,"Yeni"]
[null,null,null,null,null,null,null,null,4000,"Olanlar için",6000,10000,null,null,null,null,null,"Arş.Grv.",70,null,null,null,null,"a) Birinci dereceden aylık alanlara",130]
[null,null,null,null,null,null,null,null,2000,"Olanlar için",6000,8000,null,null,null,null,null,"Öğretim.Grv.",70,null,null,null,null,"b) İkinci dereceden aylık alanlara ",117]
[null,null,null,null,null,null,null,null,3500,"Olanlar için",6000,9500,null,null,null,null,null,"Okutman",70,null,null,null,null,"c) Üçüncü dereceden aylık alanlara",110]
[null,null,null,null,null,null,null,null,7000,"Olanlar için",null,17000,"Temsil Tazminatı",null,null,null,null,"Uzman",70,null,null,null,null,"d) Dördüncü ve beşinci dereceden aylık alanlara",104]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Çevirici",70,null,null,null,null,"e) Diğer derecelerden aylık alanlara (6.ve 7.Dereceler)",98]
[null,null,null,null,null,null,null,null,"CARİ DÖNEM","Sakatlık İndirimi TL",null,null,null,null,null,null,null,"Rektör",100,null,null,null,null,"             Her ay üniversite ödeneği olarak ödenir."]
[null,null,null,null,null,null,null,null,"1.Derece",1000,null,null,null,null,null,null,null,null,null,null,null,null,null,"             Bu ödenek  kısmi statüde görev yapanlara ödenmez."]
[null,null,null,null,null,null,null,null,"2.Derece",530]
[null,null,null,null,null,null,null,null,"3.Derece",240]
[]
[]
[null,null,null,null,null,null,null,null,"Ek Göstergesi","%",null,null,null,"Devlet Hissesi %"," Şahıs Hissesi %"]
[null,null,null,null,null,null,null,null,"0-2200 Arası",55,null,null,"Malullül Yaşlılık ve Ölüm Siğortası",11,9]
[null,null,null,null,null,null,null,null,"2200 Dahil 3600 Hariç",85,null,null,"Genel Sağlık Siğortası Pirimi",7.5,5]
[null,null,null,null,null,null,null,null,"3600 Dahil 4800 Hariç",145]
[null,null,null,null,null,null,null,null,"4800 Dahil 6400 Hariç",165]
[null,null,null,null,null,null,null,null,"6400 Dahil 7600 Hariç",195]
[null,null,null,null,null,null,null,null,"7600 Dahil 8400 Hariç",215]
[]
[null,null,null,null,null,null,null,null,"Em.Kes.Katkı Oranı / Ek Gsösretegi Eşit Olanlar",null,"Em.Kes.Katkı Oranı / Ek Gsösretegi Farklı Olanlar"]
[null,null,null,null,null,null,null,null,{"$f":"IF(Hesaplamalar!D18<2200,55,0)","v":55}]
[null,null,null,null,null,null,null,null,{"$f":"IF(I47>0,0,IF(AND(Hesaplamalar!D18>=3600,Hesaplamalar!D18<=4800),145,0))","v":0},null,{"$f":"IF(I47>0,0,IF(AND(Hesaplamalar!B21>=2200,Hesaplamalar!B21<=3600),85,0))","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"IF(I48>0,0,IF(AND(Hesaplamalar!D18>=2200,Hesaplamalar!D18<=3600),85,0))","v":0},null,{"$f":"IF(I48>0,0,IF(AND(Hesaplamalar!B21>=2200,Hesaplamalar!B21<=3600),85,0))","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"IF(I49>0,0,IF(AND(Hesaplamalar!D18>=3600,Hesaplamalar!D18<=4800),145,0))","v":0},null,{"$f":"IF(I49>0,0,IF(AND(Hesaplamalar!B21>=3600,Hesaplamalar!B21<=4800),145,0))","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"IF(I50>0,0,IF(AND(Hesaplamalar!D18>=4800,Hesaplamalar!D18<=6400),165,0))","v":0},null,{"$f":"IF(I50>0,0,IF(AND(Hesaplamalar!B21>=4800,Hesaplamalar!B21<=6400),165,0))","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"IF(I51>0,0,IF(AND(Hesaplamalar!D18>=6400,Hesaplamalar!D18<=7600),195,0))","v":0},null,{"$f":"IF(I51>0,0,IF(AND(Hesaplamalar!B21>=6400,Hesaplamalar!B21<=7600),195,0))","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,{"$f":"+'Bilgi Girişi'!F43","v":0}]

{"sheet":"Asg Geç İnd","index":6,"n_rows":18,"n_cols":25,"rows_kept":18,"cut":false,"hidden":false,"merged":[[1,7,1,15]]}
[]
[{"$f":"COUNTIF(A4:A33,\">0\")","v":1}]
["Sıra No","Adı Soyadı","Medeni Hali",null,"Eşi Çalışıyormu","Çocuk Sayısı","İlgili  Döneme Ait Maaşındaki Vergi Matrahı","Sakatlık İndirimi (Varsa)","GELİR VERGİSİNE TABİ GELİRİ","İlgili Dönemde Kendisinden Kesilen  Gelir Vergisi tutarı","16 Yaşından Büyükler İçin Asgari Ücret (Günlük)","16 Yaşından Büyükler İçin Asgari Ücret (Yıllık)","Asgari Geçim İndirimine Esas Tutar","Asgari Geçim İndiriminin Yıllık Tutarı","Hesaplanan Yıllık Tutarın 1/12 si","İlgili Dönemde Mükellefin (Çalışanın) Ödeyeceği Vergi Tutarı","Çalışan Personel İçin","Eşi İçin","1.Çocuk","2.Çocuk","3.Çocuk","4.Çocuk","5.Çocuk","TOPLAM İnd.Oranı","Ödenecek İndirim Tutarı"]
[1,{"$f":"+'Bilgi Girişi'!G11","v":0},{"$f":"+'Bilgi Girişi'!G12","v":0},{"$f":"MID(C4,10,10)","v":""},{"$f":"IF(A4<=0,\"\",IF(D4=\"Çalışıyor\",\"Evet\",IF(C4=\"Dul\",\"\",IF(C4=\"Bekar\",\"\",IF(D4=\"Çalışmıyor\",\"Hayır\",IF(C4=\"Evli Eşi Emekli V.İnd Yararlanıyor\",\"Hayır\",\"\"))))))","v":""},{"$f":"+'Bilgi Girişi'!G13","v":0},{"$f":"+Hesaplamalar!V5","v":0},null,{"$f":"G4-H4","v":0},{"$f":"ROUND((I4*0.15),2)","v":0},{"$f":"IF(A4<=0,0,'Değerler Tablosu'!E13)","v":67.650000000000006},{"$f":"(K4*30)*12","v":24354.000000000004},{"$f":"ROUND((L4*X4)/100,2)","v":12177},{"$f":"ROUND((M4*0.15),2)","v":1826.55},{"$f":"ROUND((N4/12),2)","v":152.21},{"$f":"IF(J4-O4<0,0,J4-O4)","v":0},{"$f":"IF(A4<=0,0,50)","v":50},{"$f":"IF(E4=\"Hayır\",10,0)","v":0},{"$f":"IF(F4=0,0,IF(F4=1,7.5,IF(F4>1,7.5)))","v":0},{"$f":"IF(F4=0,0,IF(F4>1,7.5,))","v":0},{"$f":"IF(F4>2,10,0)","v":0},{"$f":"IF(F4>3,5,0)","v":0},{"$f":"IF(F4>4,5,0)","v":0},{"$f":"SUM(Q4:W4)","v":50},{"$f":"IF('Bilgi Girişi'!L2=\"Evet\",0,IF(J4<O4,+J4,+O4))","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,{"$f":"+'Bilgi Girişi'!F43","v":0}]
[]
[null,{"$f":"IF('Değerler Tablosu'!J30=C123,\"Sendika Adı\",IF('Değerler Tablosu'!J30=C126,\"Sendika Adı\",IF('Değerler Tablosu'!J30=C129,\"Sendika Adı\",IF('Değerler Tablosu'!J30=C132,\"Sendika Adı\",0))))","v":0}]

{"sheet":"Vergi","index":7,"n_rows":42,"n_cols":12,"rows_kept":42,"cut":false,"hidden":false,"merged":[[0,2,0,4],[2,4,2,5],[3,4,3,5],[4,4,4,5],[5,4,5,5]]}
[null,null,{"$f":"CONCATENATE(C2,\" \",\"Yılı İçin\")","v":"2018 Yılı İçin"}]
[null,"Yıl",2018]
[1,"1.Dilim",14800,null,{"$f":"CONCATENATE(C3,\" \",\"TL'ye kadar\",\" \",\"(0\",\"-\",C3,\".-TL)\")","v":"14800 TL'ye kadar (0-14800.-TL)"},null,0.15,null,null,null,{"$f":"ROUND(C3*0.15,2)","v":2220}]
[2,"2.Dilim",34000,null,{"$f":"CONCATENATE(C4,\"-TL'nin\",\" \",C3,\"-TL'si için\",\" \",K3,\"-TL, fazlası\",\"( \",C4,\"-\",C3,\"-TL)\")","v":"34000-TL'nin 14800-TL'si için 2220-TL, fazlası( 34000-14800-TL)"},null,0.2,null,null,null,{"$f":"ROUND((C4-C3)*0.2,2)","v":3840},{"$f":"K4+K3","v":6060}]
[3,"3:dilim",120000,null,{"$f":"CONCATENATE(C5,\"-TL'nin\",\" \",C4,\" \",\"- TL'si için\",\" \",L4,\"-TL\",\" \",\"fazlası\",\"(\",C5,\"-\",C4,\"-TL)\")","v":"120000-TL'nin 34000 - TL'si için 6060-TL fazlası(120000-34000-TL)"},null,0.27]
[null,null,null,null,{"$f":"CONCATENATE(C5,\" \",\"-TL'den fazlası\")","v":"120000 -TL'den fazlası"},null,0.35]
[]
[]
[]
[]
[null,null,"D.V.Oranı",7.5900000000000004E-3]
[null,null,"Sendka Aidat Oranı",5.0000000000000001E-3]
[]
[]
[]
[]
[null,null,{"$f":"IF(C35<=Vergi!C3,Vergi!G3,IF(Hesaplamalar!V7>Vergi!C3,Vergi!G4,IF(Hesaplamalar!V7>Vergi!C4,Vergi!G5)))*100","v":15}]
[]
[null,null,15,16,17,18]
[null,null,"Uygulanacak Oran","Vergi Oranı1","Vergi Oranı2","Vergi Oranı2","Vergi Oranı3","Vergi Oranı3"]
[null,null,{"$f":"+D32","v":15},{"$f":"IF(Hesaplamalar!V7<=C3,G3,IF(Hesaplamalar!V7>C3,G4))*100","v":15},{"$f":"IF(Hesaplamalar!V7>C4,\"Evet\",0)","v":0},{"$f":"IF(E21=\"Evet\",G5,0)*100","v":0},{"$f":"IF(Hesaplamalar!V7>C5,\"Malesef\",0)","v":0},{"$f":"IF(G21=\"Malesef\",G6,0)*100","v":0}]
[]
[]
[]
[]
[]
[null,null,null,{"$f":"+C19","v":15}]
[null,null,null,{"$f":"+D21","v":15}]
[null,null,null,{"$f":"+F21","v":0}]
[null,null,null,{"$f":"+H21","v":0}]
[]
[null,null,"En Büyük Oran",{"$f":"MAX(D27:D30)","v":15}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,{"$f":"+'Bilgi Girişi'!F43","v":0}]

{"sheet":"Son 4 Yıl","index":8,"n_rows":71,"n_cols":19,"rows_kept":71,"cut":false,"hidden":false,"merged":[[68,3,68,4],[68,5,68,8],[69,3,69,4],[69,5,69,8],[70,5,70,8],[41,2,41,10],[41,12,41,18],[67,3,67,4],[67,5,67,9],[51,3,51,4],[51,5,51,8],[52,3,52,4],[52,5,52,8],[53,5,53,8],[59,3,59,4],[59,5,59,9],[60,3,60,4],[60,5,60,8],[61,3,61,4],[61,5,61,8],[62,5,62,8],[43,3,43,4],[44,3,44,4],[45,3,45,4],[43,5,43,9],[44,5,44,8],[50,3,50,4],[50,5,50,9],[45,5,45,8],[46,5,46,8],[47,5,47,8],[36,12,36,14],[38,12,38,14],[34,16,34,18],[36,16,36,18],[38,16,38,18],[34,12,34,14],[33,12,33,14],[33,16,33,18],[21,2,21,18],[31,4,31,6],[31,8,31,10],[31,12,31,14],[31,16,31,18],[30,2,30,18],[22,4,22,6],[22,8,22,10],[34,4,34,6],[36,4,36,6],[38,4,38,6],[33,4,33,6],[34,8,34,10],[36,8,36,10],[38,8,38,10],[33,8,33,10],[1,2,1,18],[14,4,14,6],[22,12,22,14],[22,16,22,18],[2,4,2,6],[2,8,2,10],[2,12,2,14],[2,16,2,18],[13,2,13,18],[14,8,14,10],[14,12,14,14],[14,16,14,18]]}
[]
[null,null,"Son 4 Yıllın Katsayıları"]
[null,null,null,null,2015,null,null,null,2016,null,null,null,2017,null,null,null,2018]
[null,null,null,null,"01/01/2015 30/06/2015",null,"01/07/2015 31/12/2015",null,"01/01/2016 30/06/2016 ",null,"01/07/2016 31/12/2016 ",null,"01/01/2017 30/06/2017 ",null,"01/06/2017 31/12/2017 ",null,"01/01/2018 30/06/2018 ",null,"01/07/2018 31/12/2018 "]
[]
[null,null,"KATSAYI",null,7.9308000000000003E-2,null,8.3084000000000005E-2,null,{"$f":"G6+(G6*6.9)/100","v":8.8816796000000003E-2},null,9.3258999999999995E-2,null,9.6058000000000004E-2,null,0.10270600000000001,null,0.10854999999999999,null,0]
[]
[null,null,"YAN ÖDEME",null,2.5149000000000001E-2,null,2.6346999999999999E-2,null,{"$f":"G8+(G8*6.9)/100","v":2.8164942999999998E-2},null,2.9574E-2,null,3.0461999999999999E-2,null,3.2570000000000002E-2,null,3.4424000000000003E-2,null,0]
[]
[null,null,"TABAN AYLIK",null,1.2414400000000001,null,1.30054,null,{"$f":"G10+(G10*6.9)/100","v":1.39027726},null,1.4598,null,1.503595,null,1.607645,null,1.6991210000000001,null,0]
[]
[]
[]
[null,null,"Son 4 Yıllın Aile Yardımı Puanları"]
[null,null,null,null,2015,null,null,null,2016,null,null,null,2017,null,null,null,2018]
[null,null,null,null,"01/01/2015 30/06/2015",null,"01/07/2015 31/12/2015",null,"01/01/2016 30/06/2016 ",null,"01/07/2016 31/12/2016 ",null,"01/01/2017 30/06/2017 ",null,"01/06/2017 31/12/2017 ",null,"01/01/2018 30/06/2018 ",null,"01/07/2018 31/12/2018 "]
[]
[null,null,null,null,"PUAN",null,"PUAN",null,"PUAN",null,"PUAN",null,"PUAN",null,"PUAN",null,"PUAN",null,"PUAN"]
[null,null,"AİLE Yardımı Puanı",null,2134,null,2134,null,2134,null,2134,null,2134,null,2134,null,2134,null,0]
[]
[]
[null,null,"Son 4 Yıllın Toplu Sözleşme Pirimi"]
[null,null,null,null,2015,null,null,null,2016,null,null,null,2017,null,null,null,2018]
[null,null,null,null,"01/01/2015 30/06/2015",null,"01/07/2015 31/12/2015",null,"01/01/2016 30/06/2016 ",null,"01/07/2016 31/12/2016 ",null,"01/01/2017 30/06/2017 ",null,"01/06/2017 31/12/2017 ",null,"01/01/2018 30/06/2018 ",null,"01/07/2018 31/12/2018 "]
[]
[null,null,null,null,"TL",null,"PUAN",null,"PUAN",null,"PUAN",null,"PUAN",null,"PUAN",null,"PUAN",null,"PUAN"]
[null,null,"Sendika Ödeneği",null,60,null,750,null,750,null,750,null,750,null,750,null,750,null,0]
[]
[]
[]
[null,null,"Son 4 Yıllın Sakatlık İndirimleri"]
[null,null,null,null,2015,null,null,null,2016,null,null,null,2017,null,null,null,2018]
[]
[null,null,null,null,"TL",null,null,null,"TL",null,null,null,"TL",null,null,null,"TL"]
[null,null,"1.DERECE",null,880,null,null,null,900,null,null,null,900,null,null,null,1000]
[]
[null,null,"2.DERECE",null,440,null,null,null,460,null,null,null,470,null,null,null,530]
[]
[null,null,"3.DERECE",null,200,null,null,null,210,null,null,null,210,null,null,null,240]
[]
[]
[null,null,"Son 3 Yıllın Vergi Dilimleri",null,null,null,null,null,null,null,null,null,"Son 3 Yıl Asgari Ücret"]
[null,null,"YIL",null,2018,null,null,null,null,null,"%",null,"YIL",null,2018,null,67.650000000000006,"TL"]
[null,null,"1.Dilim",14800,null,{"$f":"CONCATENATE(D44,\" \",\"TL'ye kadar\",\" \",\"(0\",\"-\",D44,\".-TL)\")","v":"14800 TL'ye kadar (0-14800.-TL)"},null,null,null,null,15,null,"YIL",null,2017,null,59.25,"TL"]
[null,null,"2.Dilim",34000,null,{"$f":"CONCATENATE(D45,\"-TL'nin\",\" \",D44,\"-TL'si için\",\" \",L44,\"-TL, fazlası\",\"( \",D45,\"-\",D44,\"-TL)\")","v":"34000-TL'nin 14800-TL'si için -TL, fazlası( 34000-14800-TL)"},null,null,null,null,20,null,"YIL",null,2016,null,54.9,"TL"]
[null,null,"3:dilim",120000,null,{"$f":"CONCATENATE(D46,\"-TL'nin\",\" \",D45,\" \",\"- TL'si için\",\" \",M45,\"-TL\",\" \",\"fazlası\",\"(\",D46,\"-\",D45,\"-TL)\")","v":"120000-TL'nin 34000 - TL'si için YIL-TL fazlası(120000-34000-TL)"},null,null,null,null,27]
[null,null,null,null,null,{"$f":"CONCATENATE(D46,\" \",\"-TL'den fazlası\")","v":"120000 -TL'den fazlası"},null,null,null,null,35]
[]
[]
[null,null,"YIL",null,2017,null,null,null,null,null,"%"]
[null,null,"1.Dilim",13000,null,{"$f":"CONCATENATE(D51,\" \",\"TL'ye kadar\",\" \",\"(0\",\"-\",D51,\".-TL)\")","v":"13000 TL'ye kadar (0-13000.-TL)"},null,null,null,null,15]
[null,null,"2.Dilim",30000,null,{"$f":"CONCATENATE(D52,\"-TL'nin\",\" \",D51,\"-TL'si için\",\" \",L51,\"-TL, fazlası\",\"( \",D52,\"-\",D51,\"-TL)\")","v":"30000-TL'nin 13000-TL'si için -TL, fazlası( 30000-13000-TL)"},null,null,null,null,20]
[null,null,"3:dilim",110000,null,{"$f":"CONCATENATE(D53,\"-TL'nin\",\" \",D52,\" \",\"- TL'si için\",\" \",M52,\"-TL\",\" \",\"fazlası\",\"(\",D53,\"-\",D52,\"-TL)\")","v":"110000-TL'nin 30000 - TL'si için -TL fazlası(110000-30000-TL)"},null,null,null,null,27]
[null,null,null,null,null,{"$f":"CONCATENATE(D53,\" \",\"-TL'den fazlası\")","v":"110000 -TL'den fazlası"},null,null,null,null,35]
[]
[]
[]
[]
[null,null,"YIL",null,2016,null,null,null,null,null,"%"]
[null,null,"1.Dilim",12600,null,{"$f":"CONCATENATE(D60,\" \",\"TL'ye kadar\",\" \",\"(0\",\"-\",D60,\".-TL)\")","v":"12600 TL'ye kadar (0-12600.-TL)"},null,null,null,null,15]
[null,null,"2.Dilim",30000,null,{"$f":"CONCATENATE(D61,\"-TL'nin\",\" \",D60,\"-TL'si için\",\" \",L60,\"-TL, fazlası\",\"( \",D61,\"-\",D60,\"-TL)\")","v":"30000-TL'nin 12600-TL'si için -TL, fazlası( 30000-12600-TL)"},null,null,null,null,20]
[null,null,"3:dilim",110000,null,{"$f":"CONCATENATE(D62,\"-TL'nin\",\" \",D61,\" \",\"- TL'si için\",\" \",M61,\"-TL\",\" \",\"fazlası\",\"(\",D62,\"-\",D61,\"-TL)\")","v":"110000-TL'nin 30000 - TL'si için -TL fazlası(110000-30000-TL)"},null,null,null,null,27]
[null,null,null,null,null,{"$f":"CONCATENATE(D62,\" \",\"-TL'den fazlası\")","v":"110000 -TL'den fazlası"},null,null,null,null,35]
[]
[]
[]
[null,null,"YIL",null,2015,null,null,null,null,null,"%"]
[null,null,"1.Dilim",12000,null,{"$f":"CONCATENATE(D68,\" \",\"TL'ye kadar\",\" \",\"(0\",\"-\",D68,\".-TL)\")","v":"12000 TL'ye kadar (0-12000.-TL)"},null,null,null,null,15]
[null,null,"2.Dilim",29000,null,{"$f":"CONCATENATE(D69,\"-TL'nin\",\" \",D68,\"-TL'si için\",\" \",L68,\"-TL, fazlası\",\"( \",D69,\"-\",D68,\"-TL)\")","v":"29000-TL'nin 12000-TL'si için -TL, fazlası( 29000-12000-TL)"},null,null,null,null,20]
[null,null,"3:dilim",66000,null,{"$f":"CONCATENATE(D70,\"-TL'nin\",\" \",D69,\" \",\"- TL'si için\",\" \",M69,\"-TL\",\" \",\"fazlası\",\"(\",D70,\"-\",D69,\"-TL)\")","v":"66000-TL'nin 29000 - TL'si için -TL fazlası(66000-29000-TL)"},null,null,null,null,27]
[null,null,null,null,null,{"$f":"CONCATENATE(D70,\" \",\"-TL'den fazlası\")","v":"66000 -TL'den fazlası"},null,null,null,null,35]

{"sheet":"Derece Kademe","index":9,"n_rows":287,"n_cols":29,"rows_kept":287,"cut":false,"hidden":false,"merged":[[1,3,1,11],[2,4,2,9]]}
[]
[null,null,null,"1 Numaralı Cetvel"]
[null,null,null,null,"Aylık GÖSTERGE TABLOSU (1)",null,null,null,null,null,null,null,null,null,null,null,null,null,"7600 (Dahil) - 8400 (Hariç) Arasında Olanlar            ...         Den                      215 'e"]
[null,null,"DERECE",1,2,3,4,5,6,7,8,9,null,null,null,null,null,null,"6400 (Dahil) - 7600 (Hariç) Arasında Olanlar            180         Den                      195 'e"]
[null,null,1,1320,1380,1440,1500," --"," --"," --"," --"," --",null,null,null,null,null,null,"4800 (Dahil) - 6400 (Hariç) Arasında Olanlar            150         Den                      165 'e"]
[null,null,2,1155,1210,1265,1320,1380,1440," --"," --"," --",null,null,null,null,null,null,"3600 (Dahil) - 4800 (Hariç) Arasında Olanlar            130         Den                      145 'e"]
[null,null,3,1020,1065,1110,1155,1210,1265,1320,1380," --",null,null,null,null,null,null,"2200 (Dahil) -36000 (Hariç) Arasında Olanlar             70         Den                        85 'e"]
[null,null,4,915,950,985,1020,1065,1110,1155,1210,1265,null,null,null,null,null,null,"Digerleri                                                                       40          Den                        55 'e"]
[null,null,5,835,865,895,915,950,985,1020,1065,1110]
[null,null,6,760,785,810,835,865,895,915,950,985]
[null,null,7,705,720,740,760,785,810,835,865,895]
[null,null,8,660,675,690,705,720,740,760,785,810]
[null,null,9,620,630,645,660,675,690,705,720,740]
[null,null,10,590,600,610,620,630,645,660,675,690]
[null,null,11,560,570,580,590,600,610,620,630,645]
[null,null,12,545,550,555,560,570,580,590,600,610,null,"D/ K","Puan"]
[null,null,13,530,535,540,545,550,555,560,570,580,null,{"$f":"CONCATENATE($C$5,D4)","v":"11"},{"$f":"+N18","v":1320}]
[null,null,14,515,520,525,530,535,540,545,550,555,null,1320]
[null,null,15,500,505,510,515,520,525,530,535,540,null,{"$f":"CONCATENATE($C$6,D4)","v":"21"},{"$f":"+N20","v":1155}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,1155]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE($C$7,D4)","v":"31"},{"$f":"+N22","v":1020}]
[null,null,null,0,55,null,null,1,null,null,null,null,null,1020]
[null,null,null,{"$f":"D22+100","v":100},55,null,null,2,null,null,null,null,null,{"$f":"CONCATENATE($C$8,D4)","v":"41"},{"$f":"+N24","v":915}]
[null,null,null,200,55,null,null,3,null,null,null,null,null,915]
[null,null,null,300,55,null,null,4,null,null,null,null,null,{"$f":"CONCATENATE($C$9,D4)","v":"51"},{"$f":"+N26","v":835}]
[null,null,null,400,55,null,null,5,null,null,null,null,null,835]
[null,null,null,500,55,null,null,6,null,null,null,null,null,{"$f":"CONCATENATE($C$10,D4)","v":"61"},{"$f":"+N28","v":760}]
[null,null,null,600,55,null,null,7,null,null,null,null,null,760]
[null,null,null,650,55,null,null,8,null,null,null,null,null,{"$f":"CONCATENATE($C$11,D4)","v":"71"},{"$f":"+N30","v":705}]
[null,null,null,{"$f":"D29+100","v":750},55,null,null,9,null,null,null,null,null,705]
[null,null,null,850,55,null,null,10,null,null,null,null,null,{"$f":"CONCATENATE($C$12,D4)","v":"81"},{"$f":"+N32","v":660}]
[null,null,null,950,55,null,null,11,null,null,null,null,null,660]
[null,null,null,1050,55,null,null,12,null,null,null,null,null,{"$f":"CONCATENATE($C$13,D4)","v":"91"},{"$f":"+N34","v":620}]
[null,null,null,1150,55,null,null,13,null,null,null,null,null,620]
[null,null,null,1250,55,null,null,14,null,null,null,null,null,{"$f":"CONCATENATE($C$14,D4)","v":"101"},{"$f":"+N36","v":590}]
[null,null,null,1350,55,null,null,15,null,null,null,null,null,590]
[null,null,null,1450,55,null,null,16,null,null,null,null,null,{"$f":"CONCATENATE($C$15,D4)","v":"111"},{"$f":"+N38","v":560}]
[null,null,null,1550,55,null,null,17,null,null,null,null,null,560]
[null,null,null,1650,55,null,null,18,null,null,null,null,null,{"$f":"CONCATENATE($C$16,D4)","v":"121"},{"$f":"+N40","v":545}]
[null,null,null,1750,55,null,null,19,null,null,null,null,null,545]
[null,null,null,1850,55,null,null,20,null,null,null,null,null,{"$f":"CONCATENATE($C$17,D4)","v":"131"},{"$f":"+N42","v":530}]
[null,null,null,1950,55,null,null,21,null,null,null,null,null,530]
[null,null,null,2050,55,null,null,22,null,null,null,null,null,{"$f":"CONCATENATE($C$18,D4)","v":"141"},{"$f":"+N44","v":515}]
[null,null,null,2150,55,null,null,23,null,null,null,null,null,515]
[null,null,null,2200,85,null,null,24,null,null,null,null,null,{"$f":"CONCATENATE($C$19,D4)","v":"151"},{"$f":"+N46","v":500}]
[null,null,null,{"$f":"D45+100","v":2300},85,null,null,25,null,null,null,null,null,500]
[null,null,null,2400,85,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE($C$5,E4)","v":"12"},{"$f":"+N48","v":1380},null,{"$f":"+P48","v":0},null,{"$f":"+R48","v":0},null,{"$f":"+T48","v":0},null,{"$f":"+V48","v":0},null,{"$f":"+X48","v":0},null,{"$f":"+Z48","v":0},null,{"$f":"+AB48","v":0}]
[null,null,null,2500,85,null,null,null,null,null,null,null,null,1380]
[null,null,null,2600,85,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE($C$6,E4)","v":"22"},{"$f":"+N50","v":1210}]
[null,null,null,2700,85,null,null,null,null,null,null,null,null,1210]
[null,null,null,2800,85,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE($C$7,E4)","v":"32"},{"$f":"+N52","v":1065}]
[null,null,null,2900,85,null,null,null,null,null,null,null,null,1065]
[null,null,null,3000,85,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE($C$8,E4)","v":"42"},{"$f":"+N54","v":950}]
[null,null,null,3100,85,null,null,null,null,null,null,null,null,950]
[null,null,null,3200,85,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE($C$9,E4)","v":"52"},{"$f":"+N56","v":865}]
[null,null,null,3300,85,null,null,null,null,null,null,null,null,865]
[null,null,null,3400,85,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE($C$10,E4)","v":"62"},{"$f":"+N58","v":785}]
[null,null,null,3500,85,null,null,null,null,null,null,null,null,785]
[null,null,null,3600,145,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE($C$11,E4)","v":"72"},{"$f":"+N60","v":720}]
[null,null,null,3700,145,null,null,null,null,null,null,null,null,720]
[null,null,null,3800,145,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE($C$12,E4)","v":"82"},{"$f":"+N62","v":675}]
[null,null,null,3900,145,null,null,null,null,null,null,null,null,675]
[null,null,null,4000,145,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE($C$13,E4)","v":"92"},{"$f":"+N64","v":630}]
[null,null,null,4100,145,null,null,null,null,null,null,null,null,630]
[null,null,null,4200,145,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE($C$14,E4)","v":"102"},{"$f":"+N66","v":600}]
[null,null,null,4300,145,null,null,null,null,null,null,null,null,600]
[null,null,null,4400,145,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE($C$15,E4)","v":"112"},{"$f":"+N68","v":570}]
[null,null,null,4500,145,null,null,null,null,null,null,null,null,570]
[null,null,null,4600,145,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE($C$16,E4)","v":"122"},{"$f":"+N70","v":550}]
[null,null,null,4700,145,null,null,null,null,null,null,null,null,550]
[null,null,null,4800,165,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE($C$17,E4)","v":"132"},{"$f":"+N72","v":535}]
[null,null,null,4900,165,null,null,null,null,null,null,null,null,535]
[null,null,null,5000,165,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE($C$18,E4)","v":"142"},{"$f":"+N74","v":520}]
[null,null,null,5100,165,null,null,null,null,null,null,null,null,520]
[null,null,null,5200,165,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE($C$19,E4)","v":"152"},{"$f":"+N76","v":505}]
[null,null,null,5300,165,null,null,null,null,null,null,null,null,505]
[null,null,null,5400,165,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE($C$5,F4)","v":"13"},{"$f":"+N78","v":1440}]
[null,null,null,5500,165,null,null,null,null,null,null,null,null,1440]
[null,null,null,5600,165,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE($C$6,F4)","v":"23"},{"$f":"+N80","v":1265}]
[null,null,null,5700,165,null,null,null,null,null,null,null,null,1265]
[null,null,null,5800,165,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE($C$7,F4)","v":"33"},{"$f":"+N82","v":1110}]
[null,null,null,5900,165,null,null,null,null,null,null,null,null,1110]
[null,null,null,6000,165,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE($C$8,F4)","v":"43"},{"$f":"+N84","v":985}]
[null,null,null,6100,165,null,null,null,null,null,null,null,null,985]
[null,null,null,6200,165,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE($C$9,F4)","v":"53"},{"$f":"+N86","v":895}]
[null,null,null,6300,165,null,null,null,null,null,null,null,null,895]
[null,null,null,6400,195,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE($C$10,F4)","v":"63"},{"$f":"+N88","v":810}]
[null,null,null,6500,195,null,null,null,null,null,null,null,null,810]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE($C$11,F4)","v":"73"},{"$f":"+N90","v":740}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,740]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE($C$12,F4)","v":"83"},{"$f":"+N92","v":690}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,690]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE($C$13,F4)","v":"93"},{"$f":"+N94","v":645}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,645]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE($C$14,F4)","v":"103"},{"$f":"+N96","v":610}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,610]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE($C$15,F4)","v":"113"},{"$f":"+N98","v":580}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,580]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE($C$16,F4)","v":"123"},{"$f":"+N100","v":555}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,555]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE($C$17,F4)","v":"133"},{"$f":"+N102","v":540}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,540]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE($C$18,F4)","v":"143"},{"$f":"+N104","v":525}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,525]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE($C$19,F4)","v":"153"},{"$f":"+N106","v":510}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,510]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE($C$5,G4)","v":"14"},{"$f":"+N108","v":1500}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,1500]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE($C$6,G4)","v":"24"},{"$f":"+N110","v":1320}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,1320]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE($C$7,G4)","v":"34"},{"$f":"+N112","v":1155}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,1155]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE($C$8,G4)","v":"44"},{"$f":"+N114","v":1020}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,1020]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE($C$9,G4)","v":"54"},{"$f":"+N116","v":915}]
[null,null,null,{"$f":"CONCATENATE('Derece Kademe'!$C$5,\"/\",'Derece Kademe'!D4)","v":"1/1"},{"$f":"CONCATENATE('Derece Kademe'!$C$5,\"/\",'Derece Kademe'!E4)","v":"1/2"},{"$f":"CONCATENATE('Derece Kademe'!$C$5,\"/\",'Derece Kademe'!F4)","v":"1/3"},{"$f":"CONCATENATE('Derece Kademe'!$C$5,\"/\",'Derece Kademe'!G4)","v":"1/4"},null,null,null,null,null,null,915]
[null,null,null,{"$f":"CONCATENATE('Derece Kademe'!$C$6,\"/\",'Derece Kademe'!D4)","v":"2/1"},{"$f":"CONCATENATE('Derece Kademe'!$C$6,\"/\",'Derece Kademe'!E4)","v":"2/2"},{"$f":"CONCATENATE('Derece Kademe'!$C$6,\"/\",'Derece Kademe'!F4)","v":"2/3"},{"$f":"CONCATENATE('Derece Kademe'!$C$6,\"/\",'Derece Kademe'!G4)","v":"2/4"},{"$f":"CONCATENATE('Derece Kademe'!$C$6,\"/\",'Derece Kademe'!H4)","v":"2/5"},{"$f":"CONCATENATE('Derece Kademe'!$C$6,\"/\",'Derece Kademe'!I4)","v":"2/6"},null,null,null,null,{"$f":"CONCATENATE($C$10,G4)","v":"64"},{"$f":"+N118","v":835}]
[null,null,null,{"$f":"CONCATENATE('Derece Kademe'!$C$7,\"/\",'Derece Kademe'!D4)","v":"3/1"},{"$f":"CONCATENATE('Derece Kademe'!$C$7,\"/\",'Derece Kademe'!E4)","v":"3/2"},{"$f":"CONCATENATE('Derece Kademe'!$C$7,\"/\",'Derece Kademe'!F4)","v":"3/3"},{"$f":"CONCATENATE('Derece Kademe'!$C$7,\"/\",'Derece Kademe'!G4)","v":"3/4"},{"$f":"CONCATENATE('Derece Kademe'!$C$7,\"/\",'Derece Kademe'!H4)","v":"3/5"},{"$f":"CONCATENATE('Derece Kademe'!$C$7,\"/\",'Derece Kademe'!I4)","v":"3/6"},{"$f":"CONCATENATE('Derece Kademe'!$C$7,\"/\",'Derece Kademe'!J4)","v":"3/7"},{"$f":"CONCATENATE('Derece Kademe'!$C$7,\"/\",'Derece Kademe'!K4)","v":"3/8"},null,null,835]
[null,null,null,{"$f":"CONCATENATE('Derece Kademe'!$C$8,\"/\",'Derece Kademe'!D4)","v":"4/1"},{"$f":"CONCATENATE('Derece Kademe'!$C$8,\"/\",'Derece Kademe'!E4)","v":"4/2"},{"$f":"CONCATENATE('Derece Kademe'!$C$8,\"/\",'Derece Kademe'!F4)","v":"4/3"},{"$f":"CONCATENATE('Derece Kademe'!$C$8,\"/\",'Derece Kademe'!G4)","v":"4/4"},{"$f":"CONCATENATE('Derece Kademe'!$C$8,\"/\",'Derece Kademe'!H4)","v":"4/5"},{"$f":"CONCATENATE('Derece Kademe'!$C$8,\"/\",'Derece Kademe'!I4)","v":"4/6"},{"$f":"CONCATENATE('Derece Kademe'!$C$8,\"/\",'Derece Kademe'!J4)","v":"4/7"},{"$f":"CONCATENATE('Derece Kademe'!$C$8,\"/\",'Derece Kademe'!K4)","v":"4/8"},{"$f":"CONCATENATE('Derece Kademe'!$C$8,\"/\",'Derece Kademe'!L4)","v":"4/9"},null,{"$f":"CONCATENATE($C$11,G4)","v":"74"},{"$f":"+N120","v":760}]
[null,null,null,{"$f":"CONCATENATE('Derece Kademe'!$C$9,\"/\",'Derece Kademe'!D4)","v":"5/1"},{"$f":"CONCATENATE('Derece Kademe'!$C$9,\"/\",'Derece Kademe'!E4)","v":"5/2"},{"$f":"CONCATENATE('Derece Kademe'!$C$9,\"/\",'Derece Kademe'!F4)","v":"5/3"},{"$f":"CONCATENATE('Derece Kademe'!$C$9,\"/\",'Derece Kademe'!G4)","v":"5/4"},{"$f":"CONCATENATE('Derece Kademe'!$C$9,\"/\",'Derece Kademe'!H4)","v":"5/5"},{"$f":"CONCATENATE('Derece Kademe'!$C$9,\"/\",'Derece Kademe'!I4)","v":"5/6"},{"$f":"CONCATENATE('Derece Kademe'!$C$9,\"/\",'Derece Kademe'!J4)","v":"5/7"},{"$f":"CONCATENATE('Derece Kademe'!$C$9,\"/\",'Derece Kademe'!K4)","v":"5/8"},{"$f":"CONCATENATE('Derece Kademe'!$C$9,\"/\",'Derece Kademe'!L4)","v":"5/9"},null,760]
[null,null,null,{"$f":"CONCATENATE('Derece Kademe'!$C$10,\"/\",'Derece Kademe'!D4)","v":"6/1"},{"$f":"CONCATENATE('Derece Kademe'!$C$10,\"/\",'Derece Kademe'!E4)","v":"6/2"},{"$f":"CONCATENATE('Derece Kademe'!$C$10,\"/\",'Derece Kademe'!F4)","v":"6/3"},{"$f":"CONCATENATE('Derece Kademe'!$C$10,\"/\",'Derece Kademe'!G4)","v":"6/4"},{"$f":"CONCATENATE('Derece Kademe'!$C$10,\"/\",'Derece Kademe'!H4)","v":"6/5"},{"$f":"CONCATENATE('Derece Kademe'!$C$10,\"/\",'Derece Kademe'!I4)","v":"6/6"},{"$f":"CONCATENATE('Derece Kademe'!$C$10,\"/\",'Derece Kademe'!J4)","v":"6/7"},{"$f":"CONCATENATE('Derece Kademe'!$C$10,\"/\",'Derece Kademe'!K4)","v":"6/8"},{"$f":"CONCATENATE('Derece Kademe'!$C$10,\"/\",'Derece Kademe'!L4)","v":"6/9"},null,{"$f":"CONCATENATE($C$12,G4)","v":"84"},{"$f":"+N122","v":705}]
[null,null,null,{"$f":"CONCATENATE('Derece Kademe'!$C$11,\"/\",'Derece Kademe'!D4)","v":"7/1"},{"$f":"CONCATENATE('Derece Kademe'!$C$11,\"/\",'Derece Kademe'!E4)","v":"7/2"},{"$f":"CONCATENATE('Derece Kademe'!$C$11,\"/\",'Derece Kademe'!F4)","v":"7/3"},{"$f":"CONCATENATE('Derece Kademe'!$C$11,\"/\",'Derece Kademe'!G4)","v":"7/4"},{"$f":"CONCATENATE('Derece Kademe'!$C$11,\"/\",'Derece Kademe'!H4)","v":"7/5"},{"$f":"CONCATENATE('Derece Kademe'!$C$11,\"/\",'Derece Kademe'!I4)","v":"7/6"},{"$f":"CONCATENATE('Derece Kademe'!$C$11,\"/\",'Derece Kademe'!J4)","v":"7/7"},{"$f":"CONCATENATE('Derece Kademe'!$C$11,\"/\",'Derece Kademe'!K4)","v":"7/8"},{"$f":"CONCATENATE('Derece Kademe'!$C$11,\"/\",'Derece Kademe'!L4)","v":"7/9"},null,705]
[null,null,null,{"$f":"CONCATENATE('Derece Kademe'!$C$12,\"/\",'Derece Kademe'!D4)","v":"8/1"},{"$f":"CONCATENATE('Derece Kademe'!$C$12,\"/\",'Derece Kademe'!E4)","v":"8/2"},{"$f":"CONCATENATE('Derece Kademe'!$C$12,\"/\",'Derece Kademe'!F4)","v":"8/3"},{"$f":"CONCATENATE('Derece Kademe'!$C$12,\"/\",'Derece Kademe'!G4)","v":"8/4"},{"$f":"CONCATENATE('Derece Kademe'!$C$12,\"/\",'Derece Kademe'!H4)","v":"8/5"},{"$f":"CONCATENATE('Derece Kademe'!$C$12,\"/\",'Derece Kademe'!I4)","v":"8/6"},{"$f":"CONCATENATE('Derece Kademe'!$C$12,\"/\",'Derece Kademe'!J4)","v":"8/7"},{"$f":"CONCATENATE('Derece Kademe'!$C$12,\"/\",'Derece Kademe'!K4)","v":"8/8"},{"$f":"CONCATENATE('Derece Kademe'!$C$12,\"/\",'Derece Kademe'!L4)","v":"8/9"},null,{"$f":"CONCATENATE($C$13,G4)","v":"94"},{"$f":"+N124","v":660}]
[null,null,null,{"$f":"CONCATENATE('Derece Kademe'!$C$13,\"/\",'Derece Kademe'!D4)","v":"9/1"},{"$f":"CONCATENATE('Derece Kademe'!$C$13,\"/\",'Derece Kademe'!E4)","v":"9/2"},{"$f":"CONCATENATE('Derece Kademe'!$C$13,\"/\",'Derece Kademe'!F4)","v":"9/3"},{"$f":"CONCATENATE('Derece Kademe'!$C$13,\"/\",'Derece Kademe'!G4)","v":"9/4"},{"$f":"CONCATENATE('Derece Kademe'!$C$13,\"/\",'Derece Kademe'!H4)","v":"9/5"},{"$f":"CONCATENATE('Derece Kademe'!$C$13,\"/\",'Derece Kademe'!I4)","v":"9/6"},{"$f":"CONCATENATE('Derece Kademe'!$C$13,\"/\",'Derece Kademe'!J4)","v":"9/7"},{"$f":"CONCATENATE('Derece Kademe'!$C$13,\"/\",'Derece Kademe'!K4)","v":"9/8"},{"$f":"CONCATENATE('Derece Kademe'!$C$13,\"/\",'Derece Kademe'!L4)","v":"9/9"},null,660]
[null,null,null,{"$f":"CONCATENATE('Derece Kademe'!$C$14,\"/\",'Derece Kademe'!D4)","v":"10/1"},{"$f":"CONCATENATE('Derece Kademe'!$C$14,\"/\",'Derece Kademe'!E4)","v":"10/2"},{"$f":"CONCATENATE('Derece Kademe'!$C$14,\"/\",'Derece Kademe'!F4)","v":"10/3"},{"$f":"CONCATENATE('Derece Kademe'!$C$14,\"/\",'Derece Kademe'!G4)","v":"10/4"},{"$f":"CONCATENATE('Derece Kademe'!$C$14,\"/\",'Derece Kademe'!H4)","v":"10/5"},{"$f":"CONCATENATE('Derece Kademe'!$C$14,\"/\",'Derece Kademe'!I4)","v":"10/6"},{"$f":"CONCATENATE('Derece Kademe'!$C$14,\"/\",'Derece Kademe'!J4)","v":"10/7"},{"$f":"CONCATENATE('Derece Kademe'!$C$14,\"/\",'Derece Kademe'!K4)","v":"10/8"},{"$f":"CONCATENATE('Derece Kademe'!$C$14,\"/\",'Derece Kademe'!L4)","v":"10/9"},null,{"$f":"CONCATENATE($C$14,G4)","v":"104"},{"$f":"+N126","v":620}]
[null,null,null,{"$f":"CONCATENATE('Derece Kademe'!$C$15,\"/\",'Derece Kademe'!D4)","v":"11/1"},{"$f":"CONCATENATE('Derece Kademe'!$C$15,\"/\",'Derece Kademe'!E4)","v":"11/2"},{"$f":"CONCATENATE('Derece Kademe'!$C$15,\"/\",'Derece Kademe'!F4)","v":"11/3"},{"$f":"CONCATENATE('Derece Kademe'!$C$15,\"/\",'Derece Kademe'!G4)","v":"11/4"},{"$f":"CONCATENATE('Derece Kademe'!$C$15,\"/\",'Derece Kademe'!H4)","v":"11/5"},{"$f":"CONCATENATE('Derece Kademe'!$C$15,\"/\",'Derece Kademe'!I4)","v":"11/6"},{"$f":"CONCATENATE('Derece Kademe'!$C$15,\"/\",'Derece Kademe'!J4)","v":"11/7"},{"$f":"CONCATENATE('Derece Kademe'!$C$15,\"/\",'Derece Kademe'!K4)","v":"11/8"},{"$f":"CONCATENATE('Derece Kademe'!$C$15,\"/\",'Derece Kademe'!L4)","v":"11/9"},null,620]
[null,null,null,{"$f":"CONCATENATE('Derece Kademe'!$C$16,\"/\",'Derece Kademe'!D4)","v":"12/1"},{"$f":"CONCATENATE('Derece Kademe'!$C$16,\"/\",'Derece Kademe'!E4)","v":"12/2"},{"$f":"CONCATENATE('Derece Kademe'!$C$16,\"/\",'Derece Kademe'!F4)","v":"12/3"},{"$f":"CONCATENATE('Derece Kademe'!$C$16,\"/\",'Derece Kademe'!G4)","v":"12/4"},{"$f":"CONCATENATE('Derece Kademe'!$C$16,\"/\",'Derece Kademe'!H4)","v":"12/5"},{"$f":"CONCATENATE('Derece Kademe'!$C$16,\"/\",'Derece Kademe'!I4)","v":"12/6"},{"$f":"CONCATENATE('Derece Kademe'!$C$16,\"/\",'Derece Kademe'!J4)","v":"12/7"},{"$f":"CONCATENATE('Derece Kademe'!$C$16,\"/\",'Derece Kademe'!K4)","v":"12/8"},{"$f":"CONCATENATE('Derece Kademe'!$C$16,\"/\",'Derece Kademe'!L4)","v":"12/9"},null,{"$f":"CONCATENATE($C$15,G4)","v":"114"},{"$f":"+N128","v":590}]
[null,null,null,{"$f":"CONCATENATE('Derece Kademe'!$C$17,\"/\",'Derece Kademe'!D4)","v":"13/1"},{"$f":"CONCATENATE('Derece Kademe'!$C$17,\"/\",'Derece Kademe'!E4)","v":"13/2"},{"$f":"CONCATENATE('Derece Kademe'!$C$17,\"/\",'Derece Kademe'!F4)","v":"13/3"},{"$f":"CONCATENATE('Derece Kademe'!$C$17,\"/\",'Derece Kademe'!G4)","v":"13/4"},{"$f":"CONCATENATE('Derece Kademe'!$C$17,\"/\",'Derece Kademe'!H4)","v":"13/5"},{"$f":"CONCATENATE('Derece Kademe'!$C$17,\"/\",'Derece Kademe'!I4)","v":"13/6"},{"$f":"CONCATENATE('Derece Kademe'!$C$17,\"/\",'Derece Kademe'!J4)","v":"13/7"},{"$f":"CONCATENATE('Derece Kademe'!$C$17,\"/\",'Derece Kademe'!K4)","v":"13/8"},{"$f":"CONCATENATE('Derece Kademe'!$C$17,\"/\",'Derece Kademe'!L4)","v":"13/9"},null,590]
[null,null,null,{"$f":"CONCATENATE('Derece Kademe'!$C$18,\"/\",'Derece Kademe'!D4)","v":"14/1"},{"$f":"CONCATENATE('Derece Kademe'!$C$18,\"/\",'Derece Kademe'!E4)","v":"14/2"},{"$f":"CONCATENATE('Derece Kademe'!$C$18,\"/\",'Derece Kademe'!F4)","v":"14/3"},{"$f":"CONCATENATE('Derece Kademe'!$C$18,\"/\",'Derece Kademe'!G4)","v":"14/4"},{"$f":"CONCATENATE('Derece Kademe'!$C$18,\"/\",'Derece Kademe'!H4)","v":"14/5"},{"$f":"CONCATENATE('Derece Kademe'!$C$18,\"/\",'Derece Kademe'!I4)","v":"14/6"},{"$f":"CONCATENATE('Derece Kademe'!$C$18,\"/\",'Derece Kademe'!J4)","v":"14/7"},{"$f":"CONCATENATE('Derece Kademe'!$C$18,\"/\",'Derece Kademe'!K4)","v":"14/8"},{"$f":"CONCATENATE('Derece Kademe'!$C$18,\"/\",'Derece Kademe'!L4)","v":"14/9"},null,{"$f":"CONCATENATE($C$16,G4)","v":"124"},{"$f":"+N130","v":560}]
[null,null,null,{"$f":"CONCATENATE('Derece Kademe'!$C$19,\"/\",'Derece Kademe'!D4)","v":"15/1"},{"$f":"CONCATENATE('Derece Kademe'!$C$19,\"/\",'Derece Kademe'!E4)","v":"15/2"},{"$f":"CONCATENATE('Derece Kademe'!$C$19,\"/\",'Derece Kademe'!F4)","v":"15/3"},{"$f":"CONCATENATE('Derece Kademe'!$C$19,\"/\",'Derece Kademe'!G4)","v":"15/4"},{"$f":"CONCATENATE('Derece Kademe'!$C$19,\"/\",'Derece Kademe'!H4)","v":"15/5"},{"$f":"CONCATENATE('Derece Kademe'!$C$19,\"/\",'Derece Kademe'!I4)","v":"15/6"},{"$f":"CONCATENATE('Derece Kademe'!$C$19,\"/\",'Derece Kademe'!J4)","v":"15/7"},{"$f":"CONCATENATE('Derece Kademe'!$C$19,\"/\",'Derece Kademe'!K4)","v":"15/8"},{"$f":"CONCATENATE('Derece Kademe'!$C$19,\"/\",'Derece Kademe'!L4)","v":"15/9"},null,560]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE($C$17,G4)","v":"134"},{"$f":"+N132","v":545}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,545]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE($C$18,G4)","v":"144"},{"$f":"+N134","v":530}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,530]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE($C$19,G4)","v":"154"},{"$f":"+N136","v":515}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,515]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE($C$5,H4)","v":"15"},{"$f":"+N138","v":" --"}]
[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":"CONCATENATE($C$6,H4)","v":"25"},{"$f":"+N140","v":1380}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,1380]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE($C$7,H4)","v":"35"},{"$f":"+N142","v":1210}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,1210]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE($C$8,H4)","v":"45"},{"$f":"+N144","v":1065}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,1065]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE($C$9,H4)","v":"55"},{"$f":"+N146","v":950}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,950]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE($C$10,H4)","v":"65"},{"$f":"+N148","v":865}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,865]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE($C$11,H4)","v":"75"},{"$f":"+N150","v":785}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,785]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE($C$12,H4)","v":"85"},{"$f":"+N152","v":720}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,720]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE($C$13,H4)","v":"95"},{"$f":"+N154","v":675}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,675]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE($C$14,H4)","v":"105"},{"$f":"+N156","v":630}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,630]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE($C$15,H4)","v":"115"},{"$f":"+N158","v":600}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,600]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE($C$16,H4)","v":"125"},{"$f":"+N160","v":570}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,570]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE($C$17,H4)","v":"135"},{"$f":"+N162","v":550}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,550]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE($C$18,H4)","v":"145"},{"$f":"+N164","v":535}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,535]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE($C$19,H4)","v":"155"},{"$f":"+N166","v":520}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,520]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE($C$5,I4)","v":"16"},{"$f":"+N168","v":" --"}]
[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":"CONCATENATE($C$6,I4)","v":"26"},{"$f":"+N170","v":1440}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,1440]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE($C$7,I4)","v":"36"},{"$f":"+N172","v":1265}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,1265]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE($C$8,I4)","v":"46"},{"$f":"+N174","v":1110}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,1110]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE($C$9,I4)","v":"56"},{"$f":"+N176","v":985}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,985]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE($C$10,I4)","v":"66"},{"$f":"+N178","v":895}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,895]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE($C$11,I4)","v":"76"},{"$f":"+N180","v":810}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,810]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE($C$12,I4)","v":"86"},{"$f":"+N182","v":740}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,740]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE($C$13,I4)","v":"96"},{"$f":"+N184","v":690}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,690]
[null,null,{"$f":"+'Bilgi Girişi'!F43","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE($C$14,I4)","v":"106"},{"$f":"+N186","v":645}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,645]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE($C$15,I4)","v":"116"},{"$f":"+N188","v":610}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,610]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE($C$16,I4)","v":"126"},{"$f":"+N190","v":580}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,580]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE($C$17,I4)","v":"136"},{"$f":"+N192","v":555}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,555]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE($C$18,I4)","v":"146"},{"$f":"+N194","v":540}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,540]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE($C$19,I4)","v":"156"},{"$f":"+N196","v":525}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,525]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE($C$5,J4)","v":"17"},{"$f":"+N198","v":" --"}]
[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":"CONCATENATE($C$6,J4)","v":"27"},{"$f":"+N200","v":" --"}]
[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":"CONCATENATE($C$7,J4)","v":"37"},{"$f":"+N202","v":1320}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,1320]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE($C$8,J4)","v":"47"},{"$f":"+N204","v":1155}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,1155]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE($C$9,J4)","v":"57"},{"$f":"+N206","v":1020}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,1020]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE($C$10,J4)","v":"67"},{"$f":"+N208","v":915}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,915]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE($C$11,J4)","v":"77"},{"$f":"+N210","v":835}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,835]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE($C$12,J4)","v":"87"},{"$f":"+N212","v":760}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,760]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE($C$13,J4)","v":"97"},{"$f":"+N214","v":705}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,705]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE($C$14,J4)","v":"107"},{"$f":"+N216","v":660}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,660]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE($C$15,J4)","v":"117"},{"$f":"+N218","v":620}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,620]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE($C$16,J4)","v":"127"},{"$f":"+N220","v":590}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,590]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE($C$17,J4)","v":"137"},{"$f":"+N222","v":560}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,560]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE($C$18,J4)","v":"147"},{"$f":"+N224","v":545}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,545]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE($C$19,J4)","v":"157"},{"$f":"+N226","v":530}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,530]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE($C$5,K4)","v":"18"},{"$f":"+N228","v":" --"}]
[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":"CONCATENATE($C$6,K4)","v":"28"},{"$f":"+N230","v":" --"}]
[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":"CONCATENATE($C$7,K4)","v":"38"},{"$f":"+N232","v":1380}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,1380]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE($C$8,K4)","v":"48"},{"$f":"+N234","v":1210}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,1210]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE($C$9,K4)","v":"58"},{"$f":"+N236","v":1065}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,1065]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE($C$10,K4)","v":"68"},{"$f":"+N238","v":950}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,950]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE($C$11,K4)","v":"78"},{"$f":"+N240","v":865}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,865]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE($C$12,K4)","v":"88"},{"$f":"+N242","v":785}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,785]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE($C$13,K4)","v":"98"},{"$f":"+N244","v":720}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,720]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE($C$14,K4)","v":"108"},{"$f":"+N246","v":675}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,675]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE($C$15,K4)","v":"118"},{"$f":"+N248","v":630}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,630]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE($C$16,K4)","v":"128"},{"$f":"+N250","v":600}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,600]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE($C$17,K4)","v":"138"},{"$f":"+N252","v":570}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,570]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE($C$18,K4)","v":"148"},{"$f":"+N254","v":550}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,550]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE($C$19,K4)","v":"158"},{"$f":"+N256","v":535}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,535]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE($C$5,L4)","v":"19"},{"$f":"+N258","v":" --"}]
[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":"CONCATENATE($C$6,L4)","v":"29"},{"$f":"+N260","v":" --"}]
[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":"CONCATENATE($C$7,L4)","v":"39"},{"$f":"+N262","v":" --"}]
[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":"CONCATENATE($C$8,L4)","v":"49"},{"$f":"+N264","v":1265}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,1265]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE($C$9,L4)","v":"59"},{"$f":"+N266","v":1110}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,1110]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE($C$10,L4)","v":"69"},{"$f":"+N268","v":985}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,985]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE($C$11,L4)","v":"79"},{"$f":"+N270","v":895}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,895]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE($C$12,L4)","v":"89"},{"$f":"+N272","v":810}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,810]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE($C$13,L4)","v":"99"},{"$f":"+N274","v":740}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,740]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE($C$14,L4)","v":"109"},{"$f":"+N276","v":690}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,690]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE($C$15,L4)","v":"119"},{"$f":"+N278","v":645}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,645]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE($C$16,L4)","v":"129"},{"$f":"+N280","v":610}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,610]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE($C$17,L4)","v":"139"},{"$f":"+N282","v":580}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,580]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE($C$18,L4)","v":"149"},{"$f":"+N284","v":555}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,555]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE($C$19,L4)","v":"159"},{"$f":"+N286","v":540}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,540]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+AD48","v":0}]

{"sheet":"Bordro","index":10,"n_rows":39,"n_cols":7,"rows_kept":39,"cut":false,"hidden":false,"merged":[[4,2,4,6],[5,2,5,6],[6,2,6,6],[7,1,7,2],[7,3,7,4],[7,5,7,6]]}
[]
[]
[]
[]
[null,"Kurumu / Birimi",{"$f":"IF(C9=0,0,CONCATENATE(+'Bilgi Girişi'!G3,\" / \",'Bilgi Girişi'!J4))","v":0}]
[null,"Ait Olduğu Ay",{"$f":"+'Bilgi Girişi'!G4","v":0}]
[null,"Bütçe Yılı",{"$f":"IF(C9=0,0,+'Bilgi Girişi'!H4)","v":0}]
[null,"PERSONEL BİLGİLERİ",null,"GELİRİN",null,"KESİNTİNİN"]
[null,{"$f":"IF(C9=0,0,\"T.C. Kimlik Numarası\")","v":0},{"$f":"+'Bilgi Girişi'!G8","v":0},"ADI","T U T A R I","ADI","T U T A R I"]
[null,{"$f":"IF(C10=0,0,\"Adı Soyadı\")","v":0},{"$f":"+'Bilgi Girişi'!G11","v":0},{"$f":"IF(E10=0,0,\"Aylık Tutar\")","v":0},{"$f":"+Hesaplamalar!F6","v":0},{"$f":"IF(G10=0,0,\"Gelir Vergisi\")","v":0},{"$f":"+Hesaplamalar!V9","v":0}]
[null,{"$f":"IF(C11=0,0,\"Kurum Sicil Numarası\")","v":0},{"$f":"+'Bilgi Girişi'!G9","v":0},{"$f":"IF(E11=0,0,\"Ek Gosterge\")","v":0},{"$f":"+Hesaplamalar!F18","v":0},{"$f":"IF(G11=0,0,\"Damga Vergisi\")","v":0},{"$f":"+Hesaplamalar!V14","v":0}]
[null,{"$f":"IF(C12=0,0,\"Emekli sicil Numarası\")","v":0},{"$f":"+'Bilgi Girişi'!G10","v":0},{"$f":"IF(E12=0,0,\"Taban Aylık\")","v":0},{"$f":"+Hesaplamalar!F13","v":0},{"$f":"IF(G12=0,0,\"Emekli Keseneği (Devlet) %20\")","v":0},{"$f":"+Hesaplamalar!V15","v":0}]
[null,{"$f":"IF(C13=0,0,\"Hizmet Sınıfı / Ünvanı\")","v":0},{"$f":"+'Bilgi Girişi'!G16","v":0},{"$f":"IF(E13=0,0,\"Kıdem Aylık\")","v":0},{"$f":"+Hesaplamalar!F15","v":0},{"$f":"IF(G13=0,0,\"Emekli Keseneği (Kişi) %16\")","v":0},{"$f":"+Hesaplamalar!V16","v":0}]
[null,{"$f":"IF(C14=\"\",0,\"Medeni Hali / Çocuk Sayısı\")","v":0},{"$f":"IF('Bilgi Girişi'!G4=\"\",\"\",CONCATENATE(+'Bilgi Girişi'!G12,\" / \",('Bilgi Girişi'!G14+'Bilgi Girişi'!H14)))","v":""},{"$f":"IF(E14=0,0,\"Yan Odeme\")","v":0},{"$f":"IF(Hesaplamalar!J27>0,Hesaplamalar!M30,+Hesaplamalar!J8)","v":0},{"$f":"IF(G14=0,0,+D16)","v":0},{"$f":"+E16","v":0}]
[null,{"$f":"IF(C15=0,0,\"Kıdem  Yılı\")","v":0},{"$f":"+'Bilgi Girişi'!G24","v":0},{"$f":"IF(E15=0,0,\"Em.Kes.Karşılığı %20\")","v":0},{"$f":"+Hesaplamalar!V15","v":0},{"$f":"IF(G15=0,0,+D17)","v":0},{"$f":"+E17","v":0}]
[null,{"$f":"IF(C16=\"\",0,\"Maaş Derece / Kademe\")","v":0},{"$f":"IF('Bilgi Girişi'!G4=\"\",\"\",CONCATENATE('Bilgi Girişi'!G18,\" / \",'Bilgi Girişi'!H18))","v":""},{"$f":"IF(E16=0,0,+Hesaplamalar!U29)","v":0},{"$f":"+Hesaplamalar!V29","v":0},{"$f":"IF(G16=0,0,\"Gen.Sag.Sig.Pir.(Devlet) %12\")","v":0},{"$f":"+E19","v":0}]
[null,{"$f":"IF(C15=0,0,\"Ek Gosterge (Ödemeye Esas)\")","v":0},{"$f":"+'Bilgi Girişi'!G28","v":0},{"$f":"IF(E17=0,0,+Hesaplamalar!U30)","v":0},{"$f":"+Hesaplamalar!V30","v":0},{"$f":"+D20","v":0},{"$f":"+E20","v":0}]
[null,{"$f":"IF(C18=\"\",0,\"Derece / Kademe (Emekliliğe Esas)\")","v":0},{"$f":"IF('Bilgi Girişi'!G4=\"\",\"\",IF('Bilgi Girişi'!G22=\"\",CONCATENATE('Bilgi Girişi'!G21,\" / \",'Bilgi Girişi'!H21),CONCATENATE('Bilgi Girişi'!G22,\" / \",'Bilgi Girişi'!H22)))","v":""},{"$f":"IF(E18=0,0,\"Makam Tazminatı\")","v":0},{"$f":"+Hesaplamalar!J11","v":0},{"$f":"IF(G18=0,0,+Hesaplamalar!E37)","v":0},{"$f":"+E20","v":0}]
[null,{"$f":"IF(C19=0,0,\"Ek Gösterge (Emekliliğe Esas Devlet)\")","v":0},{"$f":"IF('Bilgi Girişi'!G29=\"\",0,'Bilgi Girişi'!G29)","v":0},{"$f":"IF(E19=0,0,\"Gen.Sag.Sig.Pir.(Devlet) %12\")","v":0},{"$f":"+Hesaplamalar!AA9","v":0},{"$f":"IF(G19=0,0,+Hesaplamalar!U17)","v":0},{"$f":"+Hesaplamalar!V17","v":0}]
[null,{"$f":"IF(C20=0,0,\"Ek Gösterge (Emekliliğe Esas Şahıs)\")","v":0},{"$f":"IF('Bilgi Girişi'!G26=\"Evet\",+'Bilgi Girişi'!G31,0)","v":0},{"$f":"IF(E20=0,0,+Hesaplamalar!E38)","v":0},{"$f":"+Hesaplamalar!F38","v":0},{"$f":"IF(G20=0,0,IF('Bilgi Girişi'!G35=\"\",0,\"Sendika Aidatı\"))","v":0},{"$f":"+Hesaplamalar!V22","v":0}]
[null,{"$f":"IF(C21=0,0,IF('Bilgi Girişi'!G32=0,0,\"Raporlu Gun\"))","v":0},{"$f":"+'Bilgi Girişi'!G2","v":0},{"$f":"IF(E21=0,0,IF(Hesaplamalar!F24=0,0,\"Aile Yardımı\"))","v":0},{"$f":"Hesaplamalar!F24","v":0},{"$f":"IF(G21=0,0,IF('Bilgi Girişi'!G38=\"EVET\",\"Taahütlü İcra Kesintisi\",0))","v":0},{"$f":"+Hesaplamalar!V23","v":0}]
[null,{"$f":"IF(C22=0,0,IF('Bilgi Girişi'!G33=0,0,\"Sigorta (Özel Sağlık)\"))","v":0},{"$f":"+Hesaplamalar!Z24","v":0},{"$f":"IF(E22=0,0,IF('Bilgi Girişi'!F14=0,0,\"ÇocukYardımı\"))","v":0},{"$f":"+Hesaplamalar!F25","v":0},{"$f":"IF(G22=0,0,IF('Bilgi Girişi'!K25=\"Evet\",\"Normai İcra Kesintisi\",0))","v":0},{"$f":"+Hesaplamalar!V24","v":0}]
[null,{"$f":"IF(C23=0,0,\"Aylık Vergi Matrahı\")","v":0},{"$f":"+Hesaplamalar!V5","v":0},{"$f":"IF(E23=0,0,\"Özel Hizmet Tazminatı\")","v":0},{"$f":"IF(Hesaplamalar!J27>0,Hesaplamalar!M29,+Hesaplamalar!J6)","v":0},{"$f":"IF('Bilgi Girişi'!K26=\"Evet\",\"Kefalet Kesintisi\",0)","v":0},{"$f":"+Hesaplamalar!V25","v":0}]
[null,{"$f":"IF(C24=0,0,\"Geçen Aylar Vergi Matrahı Toplamı\")","v":0},{"$f":"+'Bilgi Girişi'!G34","v":0},{"$f":"IF(E24=0,0,IF('Bilgi Girişi'!K13=0,0,\"Yabancı Dil Tazminatı\"))","v":0},{"$f":"((IF(Hesaplamalar!J18=0,Hesaplamalar!J21,Hesaplamalar!J18)))","v":0},{"$f":"IF(+Hesaplamalar!U26<=0,+Hesaplamalar!U27,Hesaplamalar!U26)","v":0},{"$f":"IF(+Hesaplamalar!V26<=0,+Hesaplamalar!V27,Hesaplamalar!V26)","v":0}]
[null,{"$f":"IF(C25=0,0,\"Asgari Geçim İndirimi Tutarı\")","v":0},{"$f":"+Hesaplamalar!V31","v":0},{"$f":"IF(E25=0,0,+Hesaplamalar!I15)","v":0},{"$f":"+Hesaplamalar!J15","v":0},{"$f":"IF(G25=0,0,+Hesaplamalar!U21)","v":0},{"$f":"+Hesaplamalar!V21","v":0}]
[null,null,null,{"$f":"IF(E26=0,0,IF(Hesaplamalar!J24=0,0,\"Ek Öde.(666 KHK\"))","v":0},{"$f":"+Hesaplamalar!J24","v":0},{"$f":"IF(G26=0,0,IF('Bilgi Girişi'!K27=\"\",\"\",\"Nafaka Kesintisi\"))","v":0},{"$f":"+Hesaplamalar!V28","v":0}]
[null,null,null,{"$f":"IF(E27=0,0,+Hesaplamalar!I22)","v":0},{"$f":"+Hesaplamalar!J22","v":0}]
[null,null,null,{"$f":"IF(E28=0,0,+Hesaplamalar!M7)","v":0},{"$f":"+Hesaplamalar!N7","v":0},"Gelir Toplamı",{"$f":"SUM(E10:E34)","v":0}]
[null,null,null,{"$f":"IF(E29=0,0,+Hesaplamalar!M8)","v":0},{"$f":"+Hesaplamalar!N8","v":0},"Kesinti Toplamı",{"$f":"SUM(G10:G25)","v":0}]
[null,null,null,{"$f":"IF(E30=0,0,+Hesaplamalar!M11)","v":0},{"$f":"+Hesaplamalar!N11","v":0},"Net Ödenen",{"$f":"G28-G29","v":0}]
[null,null,null,{"$f":"IF(E31=0,0,+Hesaplamalar!M6)","v":0},{"$f":"+Hesaplamalar!N6","v":0}]
[null,null,null,{"$f":"IF(E32=0,0,IF('Bilgi Girişi'!G35=\"\",0,\"Top.Söz.İkram.\"))","v":0},{"$f":"+Hesaplamalar!N13","v":0},"Toplam Ödenen",{"$f":"G30","v":0}]
[null,null,null,{"$f":"IF(E33=0,0,+Hesaplamalar!I16)","v":0},{"$f":"+Hesaplamalar!J16","v":0}]
[null,null,null,{"$f":"IF(E34=0,0,+Hesaplamalar!M9)","v":0},{"$f":"+Hesaplamalar!N9","v":0}]
[]
[]
[]
[]
[null,{"$f":"+'Bilgi Girişi'!F43","v":0}]

{"sheet":"Sayfa1","index":11,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}