{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Ödeme Özeti","Ödeme Günlüğü"],"not_rendered":{"defined_names":6},"read":"whole","date_system":"1900"}

{"sheet":"Ödeme Özeti","index":0,"n_rows":18,"n_cols":11,"rows_kept":18,"merged":[[0,1,0,3],[0,4,0,10]]}
[null,"Ödeme Özeti",null,null,"Bu şablonu gereksinimlerinizi karşılayacak şekilde düzenlemek için aşağıdaki Ödeme Özeti tablo başlığındaki Kategori adlarını değiştirin. Daha fazla kategori eklemeniz gerekirse tablonun son sütununu kopyalayın ve kopyalanan sütunun sağına yapıştırın. Kategori adını değiştirdiğinizde formüller otomatik olarak güncelleştirilir. Bu tabloda Ödeme Günlüğü çalışma sayfasıyla eşit sayıda satır olduğundan emin olun."]
[null,"Tarih","Otomobil Sigortası","Ofis Malzemeleri","Elektrik","Ev Kredisi","Telefon","Boş 1","Boş 2","Boş 3","Boş 4"]
[null,{"$f":"IFERROR(INDEX(Defter[],ROW(A1),1),\"\")","v":"2018-04-06"},{"$f":"IFERROR(INDIRECT(\"Defter[@Tutar]\")*(INDIRECT(\"Defter[@Kategori]\")=KategoriAdı),\"\")","v":0},0,0,{"v":1200,"d":"1,200.00 ₺"},0,0,0,0,0]
[null,{"$f":"IFERROR(INDEX(Defter[],ROW(A2),1),\"\")","v":"2018-04-11"},0,0,{"v":85,"d":"85.00 ₺"},0,0,0,0,0,0]
[null,{"$f":"IFERROR(INDEX(Defter[],ROW(A3),1),\"\")","v":"2018-04-16"},{"v":100,"d":"100.00 ₺"},0,0,0,0,0,0,0,0]
[null,{"$f":"IFERROR(INDEX(Defter[],ROW(A4),1),\"\")","v":"2018-04-21"},0,0,0,{"v":1200,"d":"1,200.00 ₺"},0,0,0,0,0]
[null,{"$f":"IFERROR(INDEX(Defter[],ROW(A5),1),\"\")","v":"2018-04-26"},0,0,0,{"v":99,"d":"99.00 ₺"},0,0,0,0,0]
[null,{"$f":"IFERROR(INDEX(Defter[],ROW(A6),1),\"\")","v":"2018-05-01"},0,0,0,0,{"v":68,"d":"68.00 ₺"},0,0,0,0]
[null,{"$f":"IFERROR(INDEX(Defter[],ROW(A7),1),\"\")","v":"2018-05-06"},{"v":100,"d":"100.00 ₺"},0,0,0,0,0,0,0,0]
[null,{"$f":"IFERROR(INDEX(Defter[],ROW(A8),1),\"\")","v":"2018-05-11"},0,{"v":345,"d":"345.00 ₺"},0,0,0,0,0,0,0]
[null,{"$f":"IFERROR(INDEX(Defter[],ROW(A9),1),\"\")","v":"2018-05-16"},0,0,0,{"v":1200,"d":"1,200.00 ₺"},0,0,0,0,0]
[null,{"$f":"IFERROR(INDEX(Defter[],ROW(A10),1),\"\")","v":"2018-05-21"},0,0,{"v":74,"d":"74.00 ₺"},0,0,0,0,0,0]
[null,{"$f":"IFERROR(INDEX(Defter[],ROW(A11),1),\"\")","v":"2018-05-26"},0,0,0,0,{"v":123,"d":"123.00 ₺"},0,0,0,0]
[null,{"$f":"IFERROR(INDEX(Defter[],ROW(A12),1),\"\")","v":"2018-05-31"},0,{"v":99,"d":"99.00 ₺"},0,0,0,0,0,0,0]
[null,{"$f":"IFERROR(INDEX(Defter[],ROW(A13),1),\"\")","v":"2018-06-05"},{"v":100,"d":"100.00 ₺"},0,0,0,0,0,0,0,0]
[null,{"$f":"IFERROR(INDEX(Defter[],ROW(A14),1),\"\")","v":"2018-06-10"},0,0,0,{"v":1200,"d":"1,200.00 ₺"},0,0,0,0,0]
[null,{"$f":"IFERROR(INDEX(Defter[],ROW(A15),1),\"\")","v":"2018-06-15"},0,{"v":128,"d":"128.00 ₺"},0,0,0,0,0,0,0]
[null,null,{"$f":"SUBTOTAL(109,ÖdemeÖzeti[Otomobil Sigortası])","v":{"v":300,"d":"300.00 ₺"}},{"$f":"SUBTOTAL(109,ÖdemeÖzeti[Ofis Malzemeleri])","v":{"v":572,"d":"572.00 ₺"}},{"$f":"SUBTOTAL(109,ÖdemeÖzeti[Elektrik])","v":{"v":159,"d":"159.00 ₺"}},{"$f":"SUBTOTAL(109,ÖdemeÖzeti[Ev Kredisi])","v":{"v":4899,"d":"4,899.00 ₺"}},{"$f":"SUBTOTAL(109,ÖdemeÖzeti[Telefon])","v":{"v":191,"d":"191.00 ₺"}},{"$f":"SUBTOTAL(109,ÖdemeÖzeti[Boş 1])","v":0},{"$f":"SUBTOTAL(109,ÖdemeÖzeti[Boş 2])","v":0},{"$f":"SUBTOTAL(109,ÖdemeÖzeti[Boş 3])","v":0},{"$f":"SUBTOTAL(109,ÖdemeÖzeti[Boş 4])","v":0}]

{"sheet":"Ödeme Günlüğü","index":1,"n_rows":18,"n_cols":6,"rows_kept":18,"merged":[[0,1,0,3]]}
[null,"Ödeme Günlüğü"]
[null,"Tarih","Numara","Açıklama","Kategori","Tutar"]
[null,{"$f":"TODAY()-70","v":"2018-04-06"},"100","Woodgrove Bank","Ev Kredisi",{"v":1200,"d":"1,200.00 ₺"}]
[null,{"$f":"TODAY()-65","v":"2018-04-11"},101,"Elektrik ve Işık","Elektrik",{"v":85,"d":"85.00 ₺"}]
[null,{"$f":"TODAY()-60","v":"2018-04-16"},102,"Humongous Insurance","Otomobil Sigortası",{"v":100,"d":"100.00 ₺"}]
[null,{"$f":"TODAY()-55","v":"2018-04-21"},103,"Woodgrove Bank","Ev Kredisi",{"v":1200,"d":"1,200.00 ₺"}]
[null,{"$f":"TODAY()-50","v":"2018-04-26"},104,"Elektrik ve Işık","Ev Kredisi",{"v":99,"d":"99.00 ₺"}]
[null,{"$f":"TODAY()-45","v":"2018-05-01"},105,"Telefon Şirketi","Telefon",{"v":68,"d":"68.00 ₺"}]
[null,{"$f":"TODAY()-40","v":"2018-05-06"},106,"Humongous Insurance","Otomobil Sigortası",{"v":100,"d":"100.00 ₺"}]
[null,{"$f":"TODAY()-35","v":"2018-05-11"},107,"Litware, Inc.","Ofis Malzemeleri",{"v":345,"d":"345.00 ₺"}]
[null,{"$f":"TODAY()-30","v":"2018-05-16"},110,"Woodgrove Bank","Ev Kredisi",{"v":1200,"d":"1,200.00 ₺"}]
[null,{"$f":"TODAY()-25","v":"2018-05-21"},111,"Elektrik ve Işık","Elektrik",{"v":74,"d":"74.00 ₺"}]
[null,{"$f":"TODAY()-20","v":"2018-05-26"},108,"Telefon Şirketi","Telefon",{"v":123,"d":"123.00 ₺"}]
[null,{"$f":"TODAY()-15","v":"2018-05-31"},109,"Litware, Inc.","Ofis Malzemeleri",{"v":99,"d":"99.00 ₺"}]
[null,{"$f":"TODAY()-10","v":"2018-06-05"},112,"Humongous Insurance","Otomobil Sigortası",{"v":100,"d":"100.00 ₺"}]
[null,{"$f":"TODAY()-5","v":"2018-06-10"},113,"Woodgrove Bank","Ev Kredisi",{"v":1200,"d":"1,200.00 ₺"}]
[null,{"$f":"TODAY()","v":"2018-06-15"},114,"Litware, Inc.","Ofis Malzemeleri",{"v":128,"d":"128.00 ₺"}]
[null,"Toplamlar",{"$nulls":3},{"$f":"SUBTOTAL(109,Defter[Tutar])","v":{"v":6121,"d":"6,121.00 ₺"}}]