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

{"sheet":"Ek ders hesabı","index":0,"n_rows":13,"n_cols":19,"rows_kept":13,"cut":false,"hidden":false,"merged":[[0,0,0,7],[0,9,0,19],[1,17,1,19],[5,5,5,6],[8,5,8,6],[2,5,2,6],[3,5,3,6],[1,9,1,15],[12,10,12,11],[12,14,12,15],[10,5,12,6],[10,7,12,7],[1,0,1,3],[5,2,5,3],[6,2,6,3],[10,10,10,11],[1,5,1,7],[10,14,10,15],[3,9,3,10],[4,9,4,10],[5,9,5,10],[6,9,6,10],[9,5,9,6],[6,5,6,6],[12,2,12,3],[7,2,7,3],[8,2,8,3],[10,2,10,3],[2,0,3,0]]}
["2017 TEMMUZ-ARALIK KATSAYILARI ESAS ALINMIŞTIR"]
["EK DERS ÜCRETİ HESAPLAMA",null,null,null,null,"İADE EK DERS ÜCRETİ HESAPLAMA",null,null,1,"MEB ve ÖSYM MERKEZİ SINAVLAR ÜCRET TARİFESİ",null,null,null,null,null,null,null,"MERKEZİ SINAV GÖREV DURUMU"]
["Ek Ders Saati",":",76,1,null,"TAHAKKUK EDİLEN NET EK DERS TUTARI",null,10,1]
[null,":",null,"DYK Kurs Ek Ders Saati",null,"TAHAKKUK EDİLEN NET EK DERS SAYISI",null,5,null,null,null,null,null,null,null,null,null,null,2]
[]
["Brüt Ücret",":",{"$f":"IF(D3=1,'Ek ders hesabı'!C3*Parametreler!D6,IF(D3=2,'Ek ders hesabı'!C3*Parametreler!D10))+(C4*Parametreler!D6*2)","v":1092.7918400000001},null,null,"İADE EDİLECEK EK DERS SAYISI",null,15]
["Gelir Vergisi Kesintisi",":",{"$f":"C6*Parametreler!D14","v":218.55836800000003},null,null,"VADE(AY)",null,6,null,null,null,null,null,null,null,null,null,null,1]
["Damga Vergisi Kesintisi",":",{"$f":"C6*Parametreler!C16","v":8.2942900656000003}]
["Kesinti Toplamı",":",{"$f":"C7+C8","v":226.85265806560002},null,null,"ANA PARA",null,{"$f":"IFERROR((H3/H4)*H6,\"\")","v":30}]
[null,null,null,null,null,"YASAL FAİZ",null,{"$f":"IFERROR(H9*(H7*0.75%),\"\")","v":1.3499999999999999}]
["NET ÜCRET",":",{"$f":"C6-C9","v":865.93918193440004},null,null,"TOPLAM İADE EDİLECEK TUTAR",null,{"$f":"IFERROR(H9+H10,\"LÜTFEN İLGİLİ HÜCREYE DEĞER GİRİNİZ\")","v":31.35},null,"BRÜT ÜCRET",{"$f":"IF($I$2=1,Parametreler!$C$3*1900,IF($I$2=2,Parametreler!$C$3*1700,IF($I$2=3,Parametreler!$C$3*1650,IF($I$2=4,Parametreler!$C$3*1600,IF($I$2=5,Parametreler!$C$3*1200,IF($I$2=6,Parametreler!$C$3*2000,\"\"))))))","v":195.1414},null,null,"BRÜT ÜCRET",{"$f":"IF($I$3=1,Parametreler!$C$3*2000,IF($I$3=2,Parametreler!$C$3*1800,IF($I$3=3,Parametreler!$C$3*1800,IF($I$3=4,Parametreler!$C$3*1500,IF($I$3=5,Parametreler!$C$3*1200,IF($I$3=6,Parametreler!$C$3*2000,\"\"))))))","v":205.41200000000001}]
[]
["MERKEZİ SINAV DÂHİL NET ÜCRET",":",{"$f":"(IF(S4=1,IF(S7=1,(C11+K13),IF(S7=2,(C11+O13),\"\")),\"MERKEZİ SINAV GÖREVİ YOKTUR\"))","v":"MERKEZİ SINAV GÖREVİ YOKTUR"},null,null,null,null,null,null,"NET ÜCRET",{"$f":"K11-((IF(Parametreler!C14=1,(K11*0.15),IF(Parametreler!C14=2,(K11*0.2),IF(Parametreler!C14=3,(K11*0.27),\"\")))))-K11*Parametreler!C16","v":154.63199677400002},null,null,"NET ÜCRET",{"$f":"O11-((IF(Parametreler!C14=1,(O11*0.15),IF(Parametreler!C14=2,(O11*0.2),IF(Parametreler!C14=3,(O11*0.27),\"\")))))-O11*Parametreler!C16","v":162.77052291999999}]

{"sheet":"Parametreler","index":1,"n_rows":16,"n_cols":5,"rows_kept":16,"cut":false,"hidden":false,"merged":[[0,0,0,5],[5,3,7,3],[9,3,11,3],[2,4,2,5],[5,0,7,0],[9,0,11,0],[9,1,11,1],[5,1,7,1],[5,2,7,2],[9,2,11,2]]}
["Parametreler"]
[]
["Maaş Katsayısı(Temmuz-2017)",":",0.10270600000000001]
[]
[null,null,"Gösterge","Brüt Ücret"]
["Gündüz",":",140,{"$f":"IF(E6=3,((C3*C6)*0.15)+(C3*C6),IF(E6=2,((C3*C6)*0.05)+(C3*C6),(C3*C6)))","v":14.37884},1]
[]
[]
[]
["Gece",":",150,{"$f":"IF(E10=3,((C3*C10)*0.15)+(C10*C3),IF(E10=2,((C10*C3)*0.05)+(C10*C3),(C10*C3)))","v":15.405900000000001},1]
[]
[]
[]
["Gelir Vergisi Oranı",":",2,{"$f":"IF($C$14=1,0.15,IF($C$14=2,0.2,IF($C$14=3,0.27)))","v":0.2}]
[]
["Damga Vergisi Oranı",":",7.5900000000000004E-3]