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

{"sheet":"Ewidencja faktur","index":0,"n_rows":9,"n_cols":10,"rows_kept":9}
[null,"Ewidencja faktur"]
[null,"Nr faktury","Data","Termin płatności","Nazwa klienta","Kwota ","Opłata za opóźnienie ","Suma płatności","Data płatności","Kwota zaległości"]
[null,1001,{"$f":"DATE(YEAR(TODAY()),1,15)","v":"2018-01-15"},{"$f":"DATE(YEAR(TODAY()),2,15)","v":"2018-02-15"},"Ostrowska",{"v":60597,"d":"60,597.00 zł"},{"$f":"IFERROR(IF(Faktury[[#This Row],[Termin płatności]]>=Faktury[[#This Row],[Data płatności]],,5), \"\")","v":0},{"v":60597,"d":"60,597.00 zł"},{"$f":"DATE(YEAR(TODAY()),2,1)","v":"2018-02-01"},{"$f":"IFERROR(Faktury[[#This Row],[Kwota ]]-Faktury[[#This Row],[Suma płatności]]+Faktury[[#This Row],[Opłata za opóźnienie ]], \"\")","v":0}]
[null,1002,{"$f":"DATE(YEAR(TODAY()),2,11)","v":"2018-02-11"},{"$f":"DATE(YEAR(TODAY()),4,1)","v":"2018-04-01"},"Ostrowska",{"v":47100,"d":"47,100.00 zł"},{"$f":"IFERROR(IF(Faktury[[#This Row],[Termin płatności]]>=Faktury[[#This Row],[Data płatności]],,5), \"\")","v":{"v":5,"d":"5.00 zł"}},{"v":22500,"d":"22,500.00 zł"},{"$f":"DATE(YEAR(TODAY()),4,10)","v":"2018-04-10"},{"$f":"IFERROR(Faktury[[#This Row],[Kwota ]]-Faktury[[#This Row],[Suma płatności]]+Faktury[[#This Row],[Opłata za opóźnienie ]], \"\")","v":{"v":24605,"d":"24,605.00 zł"}}]
[null,1003,{"$f":"DATE(YEAR(TODAY()),2,17)","v":"2018-02-17"},{"$f":"DATE(YEAR(TODAY()),4,15)","v":"2018-04-15"},"Contoso",{"v":41397,"d":"41,397.00 zł"},{"$f":"IFERROR(IF(Faktury[[#This Row],[Termin płatności]]>=Faktury[[#This Row],[Data płatności]],,5), \"\")","v":0},{"v":16500,"d":"16,500.00 zł"},{"$f":"DATE(YEAR(TODAY()),3,17)","v":"2018-03-17"},{"$f":"IFERROR(Faktury[[#This Row],[Kwota ]]-Faktury[[#This Row],[Suma płatności]]+Faktury[[#This Row],[Opłata za opóźnienie ]], \"\")","v":{"v":24897,"d":"24,897.00 zł"}}]
[null,1004,{"$f":"DATE(YEAR(TODAY()),3,8)","v":"2018-03-08"},{"$f":"DATE(YEAR(TODAY()),4,1)","v":"2018-04-01"},"Błażej Woźniak",{"v":360,"d":"360.00 zł"},{"$f":"IFERROR(IF(Faktury[[#This Row],[Termin płatności]]>=Faktury[[#This Row],[Data płatności]],,5), \"\")","v":{"v":5,"d":"5.00 zł"}},{"v":225,"d":"225.00 zł"},{"$f":"DATE(YEAR(TODAY()),4,16)","v":"2018-04-16"},{"$f":"IFERROR(Faktury[[#This Row],[Kwota ]]-Faktury[[#This Row],[Suma płatności]]+Faktury[[#This Row],[Opłata za opóźnienie ]], \"\")","v":{"v":140,"d":"140.00 zł"}}]
[null,1005,{"$f":"DATE(YEAR(TODAY()),3,17)","v":"2018-03-17"},{"$f":"DATE(YEAR(TODAY()),4,30)","v":"2018-04-30"},"Contoso",{"v":450,"d":"450.00 zł"},{"$f":"IFERROR(IF(Faktury[[#This Row],[Termin płatności]]>=Faktury[[#This Row],[Data płatności]],,5), \"\")","v":0},{"v":225,"d":"225.00 zł"},{"$f":"DATE(YEAR(TODAY()),4,11)","v":"2018-04-11"},{"$f":"IFERROR(Faktury[[#This Row],[Kwota ]]-Faktury[[#This Row],[Suma płatności]]+Faktury[[#This Row],[Opłata za opóźnienie ]], \"\")","v":{"v":225,"d":"225.00 zł"}}]
[null,1006,{"$f":"DATE(YEAR(TODAY()),4,1)","v":"2018-04-01"},{"$f":"DATE(YEAR(TODAY()),6,1)","v":"2018-06-01"},"Hanna Kwiatkowska",{"v":4425,"d":"4,425.00 zł"},{"$f":"IFERROR(IF(Faktury[[#This Row],[Termin płatności]]>=Faktury[[#This Row],[Data płatności]],,5), \"\")","v":0},{"v":3600,"d":"3,600.00 zł"},{"$f":"DATE(YEAR(TODAY()),4,28)","v":"2018-04-28"},{"$f":"IFERROR(Faktury[[#This Row],[Kwota ]]-Faktury[[#This Row],[Suma płatności]]+Faktury[[#This Row],[Opłata za opóźnienie ]], \"\")","v":{"v":825,"d":"825.00 zł"}}]
[null,"Suma",{"$nulls":3},{"$f":"SUBTOTAL(109,Faktury[[Kwota ]])","v":{"v":154329,"d":"154,329.00 zł"}},null,{"$f":"SUBTOTAL(109,Faktury[Suma płatności])","v":{"v":103647,"d":"103,647.00 zł"}},null,{"$f":"SUBTOTAL(109,Faktury[Kwota zaległości])","v":{"v":50692,"d":"50,692.00 zł"}}]