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

{"sheet":"Sledování faktur","index":0,"n_rows":9,"n_cols":10,"rows_kept":9}
[null,"Sledování faktur"]
[null,"Č. faktury","Datum","Termín splatnosti","Jméno zákazníka","Částka ","Poplatek z prodlení ","Celkem zaplaceno","Datum platby","Zbývá"]
[null,1001,{"$f":"DATE(YEAR(TODAY()),1,15)","v":"2018-01-15"},{"$f":"DATE(YEAR(TODAY()),2,15)","v":"2018-02-15"},"Blažková",{"v":403980,"d":"403,980.00 Kč"},{"$f":"IFERROR(IF(Faktury[[#This Row],[Termín splatnosti]]>=Faktury[[#This Row],[Datum platby]],,5), \"\")","v":0},{"v":403980,"d":"403,980.00 Kč"},{"$f":"DATE(YEAR(TODAY()),2,1)","v":"2018-02-01"},{"$f":"IFERROR(Faktury[[#This Row],[Částka ]]-Faktury[[#This Row],[Celkem zaplaceno]]+Faktury[[#This Row],[Poplatek z prodlení ]], \"\")","v":0}]
[null,1002,{"$f":"DATE(YEAR(TODAY()),2,11)","v":"2018-02-11"},{"$f":"DATE(YEAR(TODAY()),4,1)","v":"2018-04-01"},"Blažková",{"v":314000,"d":"314,000.00 Kč"},{"$f":"IFERROR(IF(Faktury[[#This Row],[Termín splatnosti]]>=Faktury[[#This Row],[Datum platby]],,5), \"\")","v":{"v":5,"d":"5.00 Kč"}},{"v":150000,"d":"150,000.00 Kč"},{"$f":"DATE(YEAR(TODAY()),4,10)","v":"2018-04-10"},{"$f":"IFERROR(Faktury[[#This Row],[Částka ]]-Faktury[[#This Row],[Celkem zaplaceno]]+Faktury[[#This Row],[Poplatek z prodlení ]], \"\")","v":{"v":164005,"d":"164,005.00 Kč"}}]
[null,1003,{"$f":"DATE(YEAR(TODAY()),2,17)","v":"2018-02-17"},{"$f":"DATE(YEAR(TODAY()),4,15)","v":"2018-04-15"},"Contoso",{"v":275980,"d":"275,980.00 Kč"},{"$f":"IFERROR(IF(Faktury[[#This Row],[Termín splatnosti]]>=Faktury[[#This Row],[Datum platby]],,5), \"\")","v":0},{"v":110000,"d":"110,000.00 Kč"},{"$f":"DATE(YEAR(TODAY()),3,17)","v":"2018-03-17"},{"$f":"IFERROR(Faktury[[#This Row],[Částka ]]-Faktury[[#This Row],[Celkem zaplaceno]]+Faktury[[#This Row],[Poplatek z prodlení ]], \"\")","v":{"v":165980,"d":"165,980.00 Kč"}}]
[null,1004,{"$f":"DATE(YEAR(TODAY()),3,8)","v":"2018-03-08"},{"$f":"DATE(YEAR(TODAY()),4,1)","v":"2018-04-01"},"Václav Holý",{"v":2400,"d":"2,400.00 Kč"},{"$f":"IFERROR(IF(Faktury[[#This Row],[Termín splatnosti]]>=Faktury[[#This Row],[Datum platby]],,5), \"\")","v":{"v":5,"d":"5.00 Kč"}},{"v":1500,"d":"1,500.00 Kč"},{"$f":"DATE(YEAR(TODAY()),4,16)","v":"2018-04-16"},{"$f":"IFERROR(Faktury[[#This Row],[Částka ]]-Faktury[[#This Row],[Celkem zaplaceno]]+Faktury[[#This Row],[Poplatek z prodlení ]], \"\")","v":{"v":905,"d":"905.00 Kč"}}]
[null,1005,{"$f":"DATE(YEAR(TODAY()),3,17)","v":"2018-03-17"},{"$f":"DATE(YEAR(TODAY()),4,30)","v":"2018-04-30"},"Contoso",{"v":3000,"d":"3,000.00 Kč"},{"$f":"IFERROR(IF(Faktury[[#This Row],[Termín splatnosti]]>=Faktury[[#This Row],[Datum platby]],,5), \"\")","v":0},{"v":1500,"d":"1,500.00 Kč"},{"$f":"DATE(YEAR(TODAY()),4,11)","v":"2018-04-11"},{"$f":"IFERROR(Faktury[[#This Row],[Částka ]]-Faktury[[#This Row],[Celkem zaplaceno]]+Faktury[[#This Row],[Poplatek z prodlení ]], \"\")","v":{"v":1500,"d":"1,500.00 Kč"}}]
[null,1006,{"$f":"DATE(YEAR(TODAY()),4,1)","v":"2018-04-01"},{"$f":"DATE(YEAR(TODAY()),6,1)","v":"2018-06-01"},"Ludmila Šmídová",{"v":29500,"d":"29,500.00 Kč"},{"$f":"IFERROR(IF(Faktury[[#This Row],[Termín splatnosti]]>=Faktury[[#This Row],[Datum platby]],,5), \"\")","v":0},{"v":24000,"d":"24,000.00 Kč"},{"$f":"DATE(YEAR(TODAY()),4,28)","v":"2018-04-28"},{"$f":"IFERROR(Faktury[[#This Row],[Částka ]]-Faktury[[#This Row],[Celkem zaplaceno]]+Faktury[[#This Row],[Poplatek z prodlení ]], \"\")","v":{"v":5500,"d":"5,500.00 Kč"}}]
[null,"Celkem",{"$nulls":3},{"$f":"SUBTOTAL(109,Faktury[[Částka ]])","v":{"v":1028860,"d":"1,028,860.00 Kč"}},null,{"$f":"SUBTOTAL(109,Faktury[Celkem zaplaceno])","v":{"v":690980,"d":"690,980.00 Kč"}},null,{"$f":"SUBTOTAL(109,Faktury[Zbývá])","v":{"v":337890,"d":"337,890.00 Kč"}}]