{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["hesaplama"],"not_rendered":{"charts":0,"images":1,"macros":0,"external_links":0,"defined_names":0,"comments":1,"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":"hesaplama","index":0,"n_rows":416,"n_cols":49,"rows_kept":416,"cut":false,"hidden":false,"merged":[[6,3,6,11],[42,3,42,5],[42,6,42,7]]}
["Ay","Tefe/Üfe",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,"Ekranda Gözükmesine Gerek Olmayan Hesaplamalar"]
["1980-01-01",9.1999999999999993,null,null,null,null,null,null,null,null,null,null,"2014-04-30",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"son vade tarihi"]
["1980-02-01",29.3,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,"kanunun yayım tariih"]
["1980-03-01",4.4000000000000004,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,"ağustos 2014'e esas yi-üfe"]
["1980-04-01",3.5]
["1980-05-01",2.9]
["1980-06-01",2.8,null,"6552 Sayılı Kanun Kapsamında Yi-ÜFE ile Güncellenmiş Peşin ve Taksitli Ödeme Planlama Aracı"]
["1980-07-01",0.2]
["1980-08-01",1.5,null,"Sıra","Borcun vadesi*","Borç Tutarı ","Yi-Üfe(%)","Yi-Üfe İle Güncellenen Borç Tutarı","Toplam Peşin Ödenecek Tutar","Taksit Sayısı","Taksitli Ödeme Toplam Tutar","Aylık Taksit Tutarı"]
["1980-09-01",3.5,null,1,"2013-08-31",379.96,{"$f":"IF(E10>$M$2,0,SUMIF(A:B,\">=\" & DATE(YEAR(E10),MONTH(E10),DAY(1)),B:B)+P10)","v":9.2940000000000005},{"$f":"IF(G10<=0,0,F10*G10/100)","v":35.313482399999998},{"$f":"H10+F10","v":415.27348239999998},6,{"$f":"IF(G10=0,0,IF(J10=6,I10*$AW$17,IF(J10=9,I10*$AW$18,IF(J10=12,I10*$AW$19,IF(J10=18,I10*$AW$20,I10*0)))))","v":436.03715652},{"$f":"IF(J10=0,0,K10/J10)","v":72.672859419999995},null,{"$f":"DATE(2014,8,IF((DAY(E10)+1)>31,31,DAY(E10)+1))","v":"2014-08-31"},"2014-09-10",{"$f":"0.42/30*(O10-N10+1)","v":0.154}]
["1980-10-01",7.1,null,2,"2013-07-31",376.75,{"$f":"IF(E11>$M$2,0,SUMIF(A:B,\">=\" & DATE(YEAR(E11),MONTH(E11),DAY(1)),B:B)+P11)","v":10.284000000000002},{"$f":"IF(G11<=0,0,F11*G11/100)","v":38.744970000000009},{"$f":"H11+F11","v":415.49497000000002},6,{"$f":"IF(G11=0,0,IF(J11=6,I11*$AW$17,IF(J11=9,I11*$AW$18,IF(J11=12,I11*$AW$19,IF(J11=18,I11*$AW$20,I11*0)))))","v":436.26971850000007},72.711619750000011,null,{"$f":"DATE(2014,8,IF((DAY(E11)+1)>31,31,DAY(E11)+1))","v":"2014-08-31"},"2014-09-10",{"$f":"0.42/30*(O11-N11+1)","v":0.154}]
["1980-11-01",3.8,null,3,"2012-02-26",340.6,14.870000000000005,{"$f":"IF(G12<=0,0,F12*G12/100)","v":50.647220000000019},{"$f":"H12+F12","v":391.24722000000003},6,410.80958100000004,68.468263500000006,null,"2014-08-27","2014-09-10",0.21]
["1980-12-01",3.1,null,4,"2012-01-31",322.51,15.193999999999999,49.002169399999993,371.5121694,6,390.08777787000002,65.014629644999999,null,"2014-08-31","2014-09-10",0.154]
["1981-01-01",4.5999999999999996,null,5,"2011-12-31",320.31,16.193999999999999,51.871001399999997,372.18100140000001,6,390.79005147000004,65.131675245000011,null,"2014-08-31","2014-09-10",0.154]
["1981-02-01",2.2000000000000002,null,6,"2011-11-30",320.31,16.843999999999998,53.953016399999996,374.26301639999997,6,392.97616721999998,65.496027869999992,null,"2014-08-31","2014-09-10",0.154,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,"taksit sayısı","katsayı"]
["1981-03-01",-0.8,null,7,"2011-10-31",320.31,18.443999999999996,59.07797639999999,379.38797640000001,6,398.35737522000005,66.392895870000004,null,"2014-08-31","2014-09-10",0.154,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,0,0]
["1981-04-01",-0.8,null,8,"2011-09-30",320.31,19.993999999999996,64.042781399999981,384.35278139999997,6,403.57042046999999,67.261736744999993,null,"2014-08-31","2014-09-10",0.154,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,6,1.05]
["1981-05-01",2.2000000000000002,null,9,"2011-08-31",152.02000000000001,21.753999999999998,33.070430799999997,185.09043080000001,6,194.34495234000002,32.390825390000003,null,"2014-08-31","2014-09-10",0.154,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,9,1.07]
["1981-06-01",6.4,null,10,"2011-06-30",38.700000000000003,21.733999999999998,8.4110580000000006,47.111058,6,49.466610899999999,8.2444351499999993,null,"2014-08-31","2014-09-10",0.154,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,12,1.1000000000000001]
["1981-07-01",0.2,null,11,null,null,1177.0639999999983,0,0,null,0,0,null,"2014-08-01","2014-09-10",0.57400000000000007,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,18,1.1499999999999999]
["1981-08-01",1.1000000000000001,null,12,null,null,1177.0639999999983,0,0,null,0,0,null,"2014-08-01","2014-09-10",0.57400000000000007]
["1981-09-01",2.9,null,13,null,null,1177.0639999999983,0,0,null,0,0,null,"2014-08-01","2014-09-10",0.57400000000000007]
["1981-10-01",1.6,null,14,null,null,1177.0639999999983,0,0,null,0,0,null,"2014-08-01","2014-09-10",0.57400000000000007]
["1981-11-01",2,null,15,null,null,1177.0639999999983,0,0,null,0,0,null,"2014-08-01","2014-09-10",0.57400000000000007]
["1981-12-01",1.7,null,16,null,null,1177.0639999999983,0,0,null,0,0,null,"2014-08-01","2014-09-10",0.57400000000000007]
["1982-01-01",3.6,null,17,null,null,1177.0639999999983,0,0,null,0,0,null,"2014-08-01","2014-09-10",0.57400000000000007]
["1982-02-01",3.7,null,18,null,null,1177.0639999999983,0,0,null,0,0,null,"2014-08-01","2014-09-10",0.57400000000000007]
["1982-03-01",3.3,null,19,null,null,1177.0639999999983,0,0,null,0,0,null,"2014-08-01","2014-09-10",0.57400000000000007]
["1982-04-01",1.9,null,20,null,null,1177.0639999999983,0,0,null,0,0,null,"2014-08-01","2014-09-10",0.57400000000000007]
["1982-05-01",1.3,null,21,null,null,1177.0639999999983,0,0,null,0,0,null,"2014-08-01","2014-09-10",0.57400000000000007]
["1982-06-01",1.4,null,22,null,null,1177.0639999999983,0,0,null,0,0,null,"2014-08-01","2014-09-10",0.57400000000000007]
["1982-07-01",2,null,23,null,null,1177.0639999999983,0,0,null,0,0,null,"2014-08-01","2014-09-10",0.57400000000000007]
["1982-08-01",1.9,null,24,null,null,1177.0639999999983,0,0,null,0,0,null,"2014-08-01","2014-09-10",0.57400000000000007]
["1982-09-01",1.1000000000000001,null,25,null,null,1177.0639999999983,0,0,null,0,0,null,"2014-08-01","2014-09-10",0.57400000000000007]
["1982-10-01",0.8,null,26,null,null,1177.0639999999983,0,0,null,0,0,null,"2014-08-01","2014-09-10",0.57400000000000007]
["1982-11-01",1,null,27,null,null,1177.0639999999983,0,0,null,0,0,null,"2014-08-01","2014-09-10",0.57400000000000007]
["1982-12-01",0.6,null,28,null,null,1177.0639999999983,0,0,null,0,0,null,"2014-08-01","2014-09-10",0.57400000000000007]
["1983-01-01",9.5,null,29,null,null,1177.0639999999983,0,0,null,0,0,null,"2014-08-01","2014-09-10",0.57400000000000007]
["1983-02-01",2.4,null,30,null,null,1177.0639999999983,0,0,null,0,0,null,"2014-08-01","2014-09-10",0.57400000000000007]
["1983-03-01",1.6,null,null,"TOPLAM",{"$f":"SUM(F10:F39)","v":2891.7799999999997},null,{"$f":"SUM(H10:H39)","v":444.13410619999996},{"$f":"SUM(I10:I39)","v":3335.9141061999999},null,{"$f":"SUM(K10:K39)","v":3502.7098115099998},{"$f":"SUM(L10:L39)","v":583.784968585}]
["1983-04-01",1.4]
["1983-05-01",1.7,null,"*","Borcun ödenmesi gereken normal vade tarihi yazılmalıdır. Örneğin: Ocak/2014 KDV Beyannamesi için vade tarihi 26.02.2014 yazılmalıdır."]
["1983-06-01",1.3,null,"www.korunanmuhasebe.com",null,null,"info@korunanmuhasebe.com",null,"Tel : +90 212 518 09 50 - 518 09 49 - 516 17 48 - 516 23 69"]
["1983-07-01",1.2]
["1983-08-01",2.1]
["1983-09-01",2.1]
["1983-10-01",2.8]
["1983-11-01",4.0999999999999996]
["1983-12-01",4.4000000000000004]
["1984-01-01",3.9]
["1984-02-01",3.4]
["1984-03-01",3.3]
["1984-04-01",8.3000000000000007]
["1984-05-01",6.9]
["1984-06-01",4.7]
["1984-07-01",-0.7]
["1984-08-01",3.2]
["1984-09-01",2.2999999999999998]
["1984-10-01",3.3]
["1984-11-01",3.7]
["1984-12-01",1.7]
["1985-01-01",4.8]
["1985-02-01",4.7]
["1985-03-01",5.3]
["1985-04-01",2.2999999999999998]
["1985-05-01",2.2000000000000002]
["1985-06-01",-1.3]
["1985-07-01",0.5]
["1985-08-01",1.8]
["1985-09-01",2.7]
["1985-10-01",5]
["1985-11-01",3.1]
["1985-12-01",1.9]
["1986-01-01",4.5]
["1986-02-01",2]
["1986-03-01",1.3]
["1986-04-01",2]
["1986-05-01",1.6]
["1986-06-01",1]
["1986-07-01",1.2]
["1986-08-01",0.2]
["1986-09-01",2.2000000000000002]
["1986-10-01",3.9]
["1986-11-01",1.5]
["1986-12-01",0.9]
["1987-01-01",3.6]
["1987-02-01",2.2000000000000002]
["1987-03-01",3.5]
["1987-04-01",2.6]
["1987-05-01",4.8]
["1987-06-01",0.5]
["1987-07-01",1.7]
["1987-08-01",2.8]
["1987-09-01",2.1]
["1987-10-01",3.5]
["1987-11-01",2.8]
["1987-12-01",10.8]
["1988-01-01",6.9]
["1988-02-01",6.2]
["1988-03-01",7]
["1988-04-01",4.8]
["1988-05-01",2.1]
["1988-06-01",2.6]
["1988-07-01",2.2000000000000002]
["1988-08-01",3.1]
["1988-09-01",3.7]
["1988-10-01",6.1]
["1988-11-01",5.3]
["1988-12-01",4.3]
["1989-01-01",7.7]
["1989-02-01",5.0999999999999996]
["1989-03-01",2.2999999999999998]
["1989-04-01",4.5]
["1989-05-01",3.8]
["1989-06-01",6.3]
["1989-07-01",5]
["1989-08-01",3.1]
["1989-09-01",4.2]
["1989-10-01",4.3]
["1989-11-01",3.5]
["1989-12-01",3.3]
["1990-01-01",4.4000000000000004]
["1990-02-01",5.5]
["1990-03-01",3.6]
["1990-04-01",3.1]
["1990-05-01",2.2999999999999998]
["1990-06-01",1.4]
["1990-07-01",1.3]
["1990-08-01",2.5]
["1990-09-01",5.3]
["1990-10-01",4.9000000000000004]
["1990-11-01",3.8]
["1990-12-01",2.6]
["1991-01-01",4.5999999999999996]
["1991-02-01",5.3]
["1991-03-01",4.9000000000000004]
["1991-04-01",5.4]
["1991-05-01",2.9]
["1991-06-01",1.4]
["1991-07-01",2.2000000000000002]
["1991-08-01",4.7]
["1991-09-01",4.4000000000000004]
["1991-10-01",3.5]
["1991-11-01",3.8]
["1991-12-01",4.4000000000000004]
["1992-01-01",11]
["1992-02-01",5.2]
["1992-03-01",4.3]
["1992-04-01",2.2000000000000002]
["1992-05-01",0.7]
["1992-06-01",0.2]
["1992-07-01",1.8]
["1992-08-01",4.8]
["1992-09-01",6.3]
["1992-10-01",5.5]
["1992-11-01",3.5]
["1992-12-01",3.6]
["1993-01-01",5]
["1993-02-01",5.2]
["1993-03-01",4.8]
["1993-04-01",2.6]
["1993-05-01",2.9]
["1993-06-01",2.2999999999999998]
["1993-07-01",4.7]
["1993-08-01",3.8]
["1993-09-01",4]
["1993-10-01",3.6]
["1993-11-01",6.4]
["1993-12-01",2.9]
["1994-01-01",5.3]
["1994-02-01",10.1]
["1994-03-01",8.5]
["1994-04-01",32.799999999999997]
["1994-05-01",9]
["1994-06-01",1.9]
["1994-07-01",0.9]
["1994-08-01",2.7]
["1994-09-01",5.4]
["1994-10-01",6.9]
["1994-11-01",6.4]
["1994-12-01",8.3000000000000007]
["1995-01-01",8.4]
["1995-02-01",7]
["1995-03-01",6.1]
["1995-04-01",3.9]
["1995-05-01",1.7]
["1995-06-01",1.3]
["1995-07-01",2.4]
["1995-08-01",2.9]
["1995-09-01",4.8]
["1995-10-01",4.4000000000000004]
["1995-11-01",4.3]
["1995-12-01",4.0999999999999996]
["1996-01-01",9.8000000000000007]
["1996-02-01",5.8]
["1996-03-01",7]
["1996-04-01",8.1]
["1996-05-01",4.0999999999999996]
["1996-06-01",2.7]
["1996-07-01",2.4]
["1996-08-01",3.8]
["1996-09-01",5.0999999999999996]
["1996-10-01",5.5]
["1996-11-01",5.0999999999999996]
["1996-12-01",3.9]
["1997-01-01",5.6]
["1997-02-01",6.2]
["1997-03-01",6]
["1997-04-01",5.5]
["1997-05-01",5.2]
["1997-06-01",3.4]
["1997-07-01",5.3]
["1997-08-01",5.3]
["1997-09-01",6.3]
["1997-10-01",6.7]
["1997-11-01",5.6]
["1997-12-01",5.4]
["1998-01-01",6.5]
["1998-02-01",4.5999999999999996]
["1998-03-01",4]
["1998-04-01",4]
["1998-05-01",3.3]
["1998-06-01",1.6]
["1998-07-01",2.5]
["1998-08-01",2.4]
["1998-09-01",5.3]
["1998-10-01",4.0999999999999996]
["1998-11-01",3.4]
["1998-12-01",2.5]
["1999-01-01",3.6]
["1999-02-01",3.4]
["1999-03-01",4]
["1999-04-01",5.3]
["1999-05-01",3.2]
["1999-06-01",1.8]
["1999-07-01",4]
["1999-08-01",3.3]
["1999-09-01",5.9]
["1999-10-01",4.7]
["1999-11-01",4.0999999999999996]
["1999-12-01",6.8]
["2000-01-01",5.8]
["2000-02-01",4.0999999999999996]
["2000-03-01",3.1]
["2000-04-01",2.4]
["2000-05-01",1.7]
["2000-06-01",0.3]
["2000-07-01",1]
["2000-08-01",0.9]
["2000-09-01",2.2999999999999998]
["2000-10-01",2.8]
["2000-11-01",2.4]
["2000-12-01",1.9]
["2001-01-01",2.2999999999999998]
["2001-02-01",2.6]
["2001-03-01",10.1]
["2001-04-01",14.4]
["2001-05-01",6.3]
["2001-06-01",2.9]
["2001-07-01",3.3]
["2001-08-01",3.5]
["2001-09-01",5.4]
["2001-10-01",6.7]
["2001-11-01",4.2]
["2001-12-01",4.0999999999999996]
["2002-01-01",4.2]
["2002-02-01",2.6]
["2002-03-01",1.9]
["2002-04-01",1.8]
["2002-05-01",0.4]
["2002-06-01",1.2]
["2002-07-01",2.7]
["2002-08-01",2.1]
["2002-09-01",3.1]
["2002-10-01",3.1]
["2002-11-01",1.6]
["2002-12-01",2.6]
["2003-01-01",5.6]
["2003-02-01",3.1]
["2003-03-01",3.2]
["2003-04-01",1.8]
["2003-05-01",-0.6]
["2003-06-01",-1.9]
["2003-07-01",-0.5]
["2003-08-01",-0.2]
["2003-09-01",0.1]
["2003-10-01",0.6]
["2003-11-01",1.7]
["2003-12-01",0.6]
["2004-01-01",2.6]
["2004-02-01",1.6]
["2004-03-01",2.1]
["2004-04-01",2.6]
["2004-05-01",0]
["2004-06-01",-1.1000000000000001]
["2004-07-01",-1.5]
["2004-08-01",0.8]
["2004-09-01",1.8]
["2004-10-01",3.2]
["2004-11-01",0.8]
["2004-12-01",0.1]
["2005-01-01",-0.41]
["2005-02-01",0.11]
["2005-03-01",1.26]
["2005-04-01",1.21]
["2005-05-01",0.2]
["2005-06-01",-0.48]
["2005-07-01",-0.74]
["2005-08-01",1.04]
["2005-09-01",0.78]
["2005-10-01",0.68]
["2005-11-01",-0.95]
["2005-12-01",-0.04]
["2006-01-01",1.96]
["2006-02-01",0.26]
["2006-03-01",0.25]
["2006-04-01",1.94]
["2006-05-01",2.77]
["2006-06-01",4.0199999999999996]
["2006-07-01",0.86]
["2006-08-01",-0.75]
["2006-09-01",-0.23]
["2006-10-01",0.45]
["2006-11-01",-0.28999999999999998]
["2006-12-01",-0.12]
["2007-01-01",-0.05]
["2007-02-01",0.95]
["2007-03-01",0.97]
["2007-04-01",0.8]
["2007-05-01",0.39]
["2007-06-01",-0.11]
["2007-07-01",0.06]
["2007-08-01",0.85]
["2007-09-01",1.02]
["2007-10-01",-0.13]
["2007-11-01",0.89]
["2007-12-01",0.15]
["2008-01-01",0.42]
["2008-02-01",2.56]
["2008-03-01",3.17]
["2008-04-01",4.5]
["2008-05-01",2.12]
["2008-06-01",0.32]
["2008-07-01",1.25]
["2008-08-01",-2.34]
["2008-09-01",-0.9]
["2008-10-01",0.56999999999999995]
["2008-11-01",-0.03]
["2008-12-01",-3.54]
["2009-01-01",0.23]
["2009-02-01",1.17]
["2009-03-01",0.28999999999999998]
["2009-04-01",0.65]
["2009-05-01",-0.05]
["2009-06-01",0.94]
["2009-07-01",-0.71]
["2009-08-01",0.42]
["2009-09-01",0.62]
["2009-10-01",0.28000000000000003]
["2009-11-01",1.29]
["2009-12-01",0.66]
["2010-01-01",0.57999999999999996]
["2010-02-01",1.66]
["2010-03-01",1.94]
["2010-04-01",2.35]
["2010-05-01",-1.1499999999999999]
["2010-06-01",-0.5]
["2010-07-01",-0.16]
["2010-08-01",1.1499999999999999]
["2010-09-01",0.51]
["2010-10-01",1.21]
["2010-11-01",-0.31]
["2010-12-01",1.31]
["2011-01-01",2.36]
["2011-02-01",1.72]
["2011-03-01",1.22]
["2011-04-01",0.61]
["2011-05-01",0.15]
["2011-06-01",0.01]
["2011-07-01",-0.03]
["2011-08-01",1.76]
["2011-09-01",1.55]
["2011-10-01",1.6]
["2011-11-01",0.65]
["2011-12-01",1]
["2012-01-01",0.38]
["2012-02-01",-0.09]
["2012-03-01",0.36]
["2012-04-01",0.08]
["2012-05-01",0.53]
["2012-06-01",-1.49]
["2012-07-01",-0.31]
["2012-08-01",0.26]
["2012-09-01",1.03]
["2012-10-01",0.17]
["2012-11-01",1.66]
["2012-12-01",-0.12]
["2013-01-01",-0.18]
["2013-02-01",-0.13]
["2013-03-01",0.81]
["2013-04-01",-0.51]
["2013-05-01",1]
["2013-06-01",1.46]
["2013-07-01",0.99]
["2013-08-01",0.04]
["2013-09-01",0.88]
["2013-10-01",0.69]
["2013-11-01",0.62]
["2013-12-01",1.1100000000000001]
["2014-01-01",3.32]
["2014-02-01",1.38]
["2014-03-01",0.74]
["2014-04-01",0.09]
["2014-05-01",-0.52]
["2014-06-01",0.06]
["2014-07-01",0.73]