{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Fatura İzleyici"],"not_rendered":{"defined_names":2},"read":"whole","date_system":"1900"}

{"sheet":"Fatura İzleyici","index":0,"n_rows":9,"n_cols":10,"rows_kept":9}
[null,"Fatura İzleyici"]
[null,"Fatura No","Tarih","Vadesi Gelen Ödeme","Müşteri Adı","Tutar ","Gecikme Ücreti ","Toplam Ödeme","Ödeme Tarihi","Bekleyen"]
[null,1001,{"$f":"DATE(YEAR(TODAY()),1,15)","v":"2018-01-15"},{"$f":"DATE(YEAR(TODAY()),2,15)","v":"2018-02-15"},"Demir",{"v":40398,"d":"40,398.00 ₺"},{"$f":"IFERROR(IF(Faturalar[[#This Row],[Vadesi Gelen Ödeme]]>=Faturalar[[#This Row],[Ödeme Tarihi]],,5), \"\")","v":0},{"v":40398,"d":"40,398.00 ₺"},{"$f":"DATE(YEAR(TODAY()),2,1)","v":"2018-02-01"},{"$f":"IFERROR(Faturalar[[#This Row],[Tutar ]]-Faturalar[[#This Row],[Toplam Ödeme]]+Faturalar[[#This Row],[Gecikme Ücreti ]], \"\")","v":0}]
[null,1002,{"$f":"DATE(YEAR(TODAY()),2,11)","v":"2018-02-11"},{"$f":"DATE(YEAR(TODAY()),4,1)","v":"2018-04-01"},"Demir",{"v":31400,"d":"31,400.00 ₺"},{"$f":"IFERROR(IF(Faturalar[[#This Row],[Vadesi Gelen Ödeme]]>=Faturalar[[#This Row],[Ödeme Tarihi]],,5), \"\")","v":{"v":5,"d":"5.00 ₺"}},{"v":15000,"d":"15,000.00 ₺"},{"$f":"DATE(YEAR(TODAY()),4,10)","v":"2018-04-10"},{"$f":"IFERROR(Faturalar[[#This Row],[Tutar ]]-Faturalar[[#This Row],[Toplam Ödeme]]+Faturalar[[#This Row],[Gecikme Ücreti ]], \"\")","v":{"v":16405,"d":"16,405.00 ₺"}}]
[null,1003,{"$f":"DATE(YEAR(TODAY()),2,17)","v":"2018-02-17"},{"$f":"DATE(YEAR(TODAY()),4,15)","v":"2018-04-15"},"Contoso",{"v":27598,"d":"27,598.00 ₺"},{"$f":"IFERROR(IF(Faturalar[[#This Row],[Vadesi Gelen Ödeme]]>=Faturalar[[#This Row],[Ödeme Tarihi]],,5), \"\")","v":0},{"v":11000,"d":"11,000.00 ₺"},{"$f":"DATE(YEAR(TODAY()),3,17)","v":"2018-03-17"},{"$f":"IFERROR(Faturalar[[#This Row],[Tutar ]]-Faturalar[[#This Row],[Toplam Ödeme]]+Faturalar[[#This Row],[Gecikme Ücreti ]], \"\")","v":{"v":16598,"d":"16,598.00 ₺"}}]
[null,1004,{"$f":"DATE(YEAR(TODAY()),3,8)","v":"2018-03-08"},{"$f":"DATE(YEAR(TODAY()),4,1)","v":"2018-04-01"},"Turgay Elmas",{"v":240,"d":"240.00 ₺"},{"$f":"IFERROR(IF(Faturalar[[#This Row],[Vadesi Gelen Ödeme]]>=Faturalar[[#This Row],[Ödeme Tarihi]],,5), \"\")","v":{"v":5,"d":"5.00 ₺"}},{"v":150,"d":"150.00 ₺"},{"$f":"DATE(YEAR(TODAY()),4,16)","v":"2018-04-16"},{"$f":"IFERROR(Faturalar[[#This Row],[Tutar ]]-Faturalar[[#This Row],[Toplam Ödeme]]+Faturalar[[#This Row],[Gecikme Ücreti ]], \"\")","v":{"v":95,"d":"95.00 ₺"}}]
[null,1005,{"$f":"DATE(YEAR(TODAY()),3,17)","v":"2018-03-17"},{"$f":"DATE(YEAR(TODAY()),4,30)","v":"2018-04-30"},"Contoso",{"v":300,"d":"300.00 ₺"},{"$f":"IFERROR(IF(Faturalar[[#This Row],[Vadesi Gelen Ödeme]]>=Faturalar[[#This Row],[Ödeme Tarihi]],,5), \"\")","v":0},{"v":300,"d":"300.00 ₺"},{"$f":"DATE(YEAR(TODAY()),4,11)","v":"2018-04-11"},{"$f":"IFERROR(Faturalar[[#This Row],[Tutar ]]-Faturalar[[#This Row],[Toplam Ödeme]]+Faturalar[[#This Row],[Gecikme Ücreti ]], \"\")","v":0}]
[null,1006,{"$f":"DATE(YEAR(TODAY()),4,1)","v":"2018-04-01"},{"$f":"DATE(YEAR(TODAY()),6,1)","v":"2018-06-01"},"Elif Yıldız",{"v":2950,"d":"2,950.00 ₺"},{"$f":"IFERROR(IF(Faturalar[[#This Row],[Vadesi Gelen Ödeme]]>=Faturalar[[#This Row],[Ödeme Tarihi]],,5), \"\")","v":0},{"v":400,"d":"400.00 ₺"},{"$f":"DATE(YEAR(TODAY()),4,28)","v":"2018-04-28"},{"$f":"IFERROR(Faturalar[[#This Row],[Tutar ]]-Faturalar[[#This Row],[Toplam Ödeme]]+Faturalar[[#This Row],[Gecikme Ücreti ]], \"\")","v":{"v":2550,"d":"2,550.00 ₺"}}]
[null,"Toplam",{"$nulls":3},{"$f":"SUBTOTAL(109,Faturalar[[Tutar ]])","v":{"v":102886,"d":"102,886.00 ₺"}},null,{"$f":"SUBTOTAL(109,Faturalar[Toplam Ödeme])","v":{"v":67248,"d":"67,248.00 ₺"}},null,{"$f":"SUBTOTAL(109,Faturalar[Bekleyen])","v":{"v":35648,"d":"35,648.00 ₺"}}]