{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Praćenje faktura"],"not_rendered":{"defined_names":2},"read":"whole","date_system":"1900"}

{"sheet":"Praćenje faktura","index":0,"n_rows":9,"n_cols":10,"rows_kept":9}
[null,"Praćenje faktura"]
[null,"Broj fakture","Datum","Dospeva za naplatu","Ime klijenta","Iznos ","Naknada za kašnjenje ","Ukupno plaćeno","Datum plaćanja","Preostalo"]
[null,1001,{"$f":"DATE(YEAR(TODAY()),1,15)","v":"2018-01-15"},{"$f":"DATE(YEAR(TODAY()),2,15)","v":"2018-02-15"},"Ralević",{"v":2019900,"d":"2,019,900.00 din."},{"$f":"IFERROR(IF(Fakture[[#This Row],[Dospeva za naplatu]]>=Fakture[[#This Row],[Datum plaćanja]],,5), \"\")","v":0},{"v":2019900,"d":"2,019,900.00 din."},{"$f":"DATE(YEAR(TODAY()),2,1)","v":"2018-02-01"},{"$f":"IFERROR(Fakture[[#This Row],[Iznos ]]-Fakture[[#This Row],[Ukupno plaćeno]]+Fakture[[#This Row],[Naknada za kašnjenje ]], \"\")","v":0}]
[null,1002,{"$f":"DATE(YEAR(TODAY()),2,11)","v":"2018-02-11"},{"$f":"DATE(YEAR(TODAY()),4,1)","v":"2018-04-01"},"Ralević",{"v":1570000,"d":"1,570,000.00 din."},{"$f":"IFERROR(IF(Fakture[[#This Row],[Dospeva za naplatu]]>=Fakture[[#This Row],[Datum plaćanja]],,5), \"\")","v":{"v":5,"d":"5.00 din."}},{"v":750000,"d":"750,000.00 din."},{"$f":"DATE(YEAR(TODAY()),4,10)","v":"2018-04-10"},{"$f":"IFERROR(Fakture[[#This Row],[Iznos ]]-Fakture[[#This Row],[Ukupno plaćeno]]+Fakture[[#This Row],[Naknada za kašnjenje ]], \"\")","v":{"v":820005,"d":"820,005.00 din."}}]
[null,1003,{"$f":"DATE(YEAR(TODAY()),2,17)","v":"2018-02-17"},{"$f":"DATE(YEAR(TODAY()),4,15)","v":"2018-04-15"},"Contoso",{"v":1379900,"d":"1,379,900.00 din."},{"$f":"IFERROR(IF(Fakture[[#This Row],[Dospeva za naplatu]]>=Fakture[[#This Row],[Datum plaćanja]],,5), \"\")","v":0},{"v":550000,"d":"550,000.00 din."},{"$f":"DATE(YEAR(TODAY()),3,17)","v":"2018-03-17"},{"$f":"IFERROR(Fakture[[#This Row],[Iznos ]]-Fakture[[#This Row],[Ukupno plaćeno]]+Fakture[[#This Row],[Naknada za kašnjenje ]], \"\")","v":{"v":829900,"d":"829,900.00 din."}}]
[null,1004,{"$f":"DATE(YEAR(TODAY()),3,8)","v":"2018-03-08"},{"$f":"DATE(YEAR(TODAY()),4,1)","v":"2018-04-01"},"Luka Macura",{"v":12000,"d":"12,000.00 din."},{"$f":"IFERROR(IF(Fakture[[#This Row],[Dospeva za naplatu]]>=Fakture[[#This Row],[Datum plaćanja]],,5), \"\")","v":{"v":5,"d":"5.00 din."}},{"v":7500,"d":"7,500.00 din."},{"$f":"DATE(YEAR(TODAY()),4,16)","v":"2018-04-16"},{"$f":"IFERROR(Fakture[[#This Row],[Iznos ]]-Fakture[[#This Row],[Ukupno plaćeno]]+Fakture[[#This Row],[Naknada za kašnjenje ]], \"\")","v":{"v":4505,"d":"4,505.00 din."}}]
[null,1005,{"$f":"DATE(YEAR(TODAY()),3,17)","v":"2018-03-17"},{"$f":"DATE(YEAR(TODAY()),4,30)","v":"2018-04-30"},"Contoso",{"v":15000,"d":"15,000.00 din."},{"$f":"IFERROR(IF(Fakture[[#This Row],[Dospeva za naplatu]]>=Fakture[[#This Row],[Datum plaćanja]],,5), \"\")","v":0},{"v":7500,"d":"7,500.00 din."},{"$f":"DATE(YEAR(TODAY()),4,11)","v":"2018-04-11"},{"$f":"IFERROR(Fakture[[#This Row],[Iznos ]]-Fakture[[#This Row],[Ukupno plaćeno]]+Fakture[[#This Row],[Naknada za kašnjenje ]], \"\")","v":{"v":7500,"d":"7,500.00 din."}}]
[null,1006,{"$f":"DATE(YEAR(TODAY()),4,1)","v":"2018-04-01"},{"$f":"DATE(YEAR(TODAY()),6,1)","v":"2018-06-01"},"Mirjana Ralević",{"v":147500,"d":"147,500.00 din."},{"$f":"IFERROR(IF(Fakture[[#This Row],[Dospeva za naplatu]]>=Fakture[[#This Row],[Datum plaćanja]],,5), \"\")","v":0},{"v":120000,"d":"120,000.00 din."},{"$f":"DATE(YEAR(TODAY()),4,28)","v":"2018-04-28"},{"$f":"IFERROR(Fakture[[#This Row],[Iznos ]]-Fakture[[#This Row],[Ukupno plaćeno]]+Fakture[[#This Row],[Naknada za kašnjenje ]], \"\")","v":{"v":27500,"d":"27,500.00 din."}}]
[null,"Ukupno",{"$nulls":3},{"$f":"SUBTOTAL(109,Fakture[[Iznos ]])","v":{"v":5144300,"d":"5,144,300.00 din."}},null,{"$f":"SUBTOTAL(109,Fakture[Ukupno plaćeno])","v":{"v":3454900,"d":"3,454,900.00 din."}},null,{"$f":"SUBTOTAL(109,Fakture[Preostalo])","v":{"v":1689410,"d":"1,689,410.00 din."}}]