{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Degisken","GelirVergisi"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":1,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Degisken","index":0,"n_rows":6,"n_cols":2,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
["Gelir Dilimleri","Vergi Oranı %"]
[0,15]
[22000,20]
[49000,27]
[180000,35]
[600000,40]

{"sheet":"GelirVergisi","index":1,"n_rows":58,"n_cols":8,"rows_kept":58,"cut":false,"hidden":false,"merged":[[1,0,1,7],[39,4,39,5],[26,3,26,4],[19,5,19,6],[20,5,20,6],[22,5,22,6],[21,5,21,6]]}
[]
[]
[]
[]
[null," "]
[]
[]
[]
["FATURA TOPLAM BEDELİ",null,null,null," "]
["İNDİRİLECEK KDV (%)",null,18,{"$f":"D9-D11","v":0}]
["KDV HARİÇ  KESİNTİYE ESAS TUTAR",null,null,{"$f":"ROUND(D9/((100+C10)/100),2)","v":0}," "]
[null,null,null,null,"Hazine Payı (%)",null,1,{"$f":"ROUND(D11*(G12/100),2)","v":0}]
[null,null,null,null,"Bilimsel Araştırma Proje Payı (%)",null,5,{"$f":"ROUND(D11*(G13/100),2)","v":0}]
[]
[null,null,null,null,"Araç Gereç Payı (Üniv. Yön. Kur.Kararı gereği %)",null,0,{"$f":"ROUND(D11*(G15/100),2)","v":0}]
[null,null,null,null,"KESİNTİLER TOPLAMI",null,null,{"$f":"SUM(H12:H15)","v":0}]
["KATKI PAYI MATRAHI",null,null,{"$f":"D11","v":0}]
["YASAL KESİNTİLER TOPLAMI",null,null,{"$f":"H16","v":0}]
["VERGİ MATRAHI",null,null,{"$f":"D17-D18","v":0}]
["GELİR VERGİSİ ",null,null,0,null,"Kümülatif  Vergi  Matrahı",null,0]
["DAMGA VERGİSİ (%07,59)",null,null,{"$f":"ROUND(D19*(7.59/1000),2)","v":0},null,"Ek Ödeme Vergi Matrahı",null,{"$f":"D19","v":0}]
["VERGİLER TOPLAMI",null,null,{"$f":"D20+D21","v":0}]
["ÖDENECEK TUTAR",null,null,{"$f":"ROUND(SUM(D19-D22),2)","v":0},null,"Toplam Matrah ",null,{"$f":"H20+H21","v":0}]
[]
[]
[]
[null,null," ",{"$f":"Degisken!$A1","v":"Gelir Dilimleri"},null,{"$f":"Degisken!$B1","v":"Vergi Oranı %"}]
[null,null,null,{"$f":"Degisken!$A2","v":0},{"$f":"Degisken!$A3","v":22000},{"$f":"Degisken!$B2","v":15}]
[null,null,null,{"$f":"Degisken!$A3","v":22000},{"$f":"Degisken!$A4","v":49000},{"$f":"Degisken!$B3","v":20}]
[null,null,null,{"$f":"Degisken!$A4","v":49000},{"$f":"Degisken!$A5","v":180000},{"$f":"Degisken!$B4","v":27}]
[null,null,null,{"$f":"Degisken!$A5","v":180000},{"$f":"Degisken!$A6","v":600000},{"$f":"Degisken!$B5","v":35}]
[null,null,null,{"$f":"Degisken!$A6","v":600000},null,{"$f":"Degisken!$B6","v":40}]
[]
[]
[]
[]
[]
[]
[]
["Düzenleyen",null,null,null,"Birim Sorumlusu"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Not:Değişken sayfasında bulunan gelir vergisi dilimlerinde yapılan değişiklikler güncellenmelidir. "]