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

{"sheet":"Controle de faturas","index":0,"n_rows":9,"n_cols":10,"rows_kept":9}
[null,"Controle de faturas"]
[null,"Fatura nº","Data","Vencimento","Nome do cliente","Valor ","Valor por atraso ","Total pago","Data do pagamento","Devedor"]
[null,1001,{"$f":"DATE(YEAR(TODAY()),1,15)","v":"2018-01-15"},{"$f":"DATE(YEAR(TODAY()),2,15)","v":"2018-02-15"},"Cardoso",{"v":40398,"d":"R$ 40,398.00"},{"$f":"IFERROR(IF(Faturas[[#This Row],[Vencimento]]>=Faturas[[#This Row],[Data do pagamento]],,5), \"\")","v":0},{"v":40398,"d":"R$ 40,398.00"},{"$f":"DATE(YEAR(TODAY()),2,1)","v":"2018-02-01"},{"$f":"IFERROR(Faturas[[#This Row],[Valor ]]-Faturas[[#This Row],[Total pago]]+Faturas[[#This Row],[Valor por atraso ]], \"\")","v":0}]
[null,1002,{"$f":"DATE(YEAR(TODAY()),2,11)","v":"2018-02-11"},{"$f":"DATE(YEAR(TODAY()),4,1)","v":"2018-04-01"},"Cardoso",{"v":31400,"d":"R$ 31,400.00"},{"$f":"IFERROR(IF(Faturas[[#This Row],[Vencimento]]>=Faturas[[#This Row],[Data do pagamento]],,5), \"\")","v":{"v":5,"d":"R$ 5.00"}},{"v":15000,"d":"R$ 15,000.00"},{"$f":"DATE(YEAR(TODAY()),4,10)","v":"2018-04-10"},{"$f":"IFERROR(Faturas[[#This Row],[Valor ]]-Faturas[[#This Row],[Total pago]]+Faturas[[#This Row],[Valor por atraso ]], \"\")","v":{"v":16405,"d":"R$ 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":"R$ 27,598.00"},{"$f":"IFERROR(IF(Faturas[[#This Row],[Vencimento]]>=Faturas[[#This Row],[Data do pagamento]],,5), \"\")","v":0},{"v":11000,"d":"R$ 11,000.00"},{"$f":"DATE(YEAR(TODAY()),3,17)","v":"2018-03-17"},{"$f":"IFERROR(Faturas[[#This Row],[Valor ]]-Faturas[[#This Row],[Total pago]]+Faturas[[#This Row],[Valor por atraso ]], \"\")","v":{"v":16598,"d":"R$ 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"},"Davi Barros",{"v":240,"d":"R$ 240.00"},{"$f":"IFERROR(IF(Faturas[[#This Row],[Vencimento]]>=Faturas[[#This Row],[Data do pagamento]],,5), \"\")","v":{"v":5,"d":"R$ 5.00"}},{"v":150,"d":"R$ 150.00"},{"$f":"DATE(YEAR(TODAY()),4,16)","v":"2018-04-16"},{"$f":"IFERROR(Faturas[[#This Row],[Valor ]]-Faturas[[#This Row],[Total pago]]+Faturas[[#This Row],[Valor por atraso ]], \"\")","v":{"v":95,"d":"R$ 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":"R$ 300.00"},{"$f":"IFERROR(IF(Faturas[[#This Row],[Vencimento]]>=Faturas[[#This Row],[Data do pagamento]],,5), \"\")","v":0},{"v":300,"d":"R$ 300.00"},{"$f":"DATE(YEAR(TODAY()),4,11)","v":"2018-04-11"},{"$f":"IFERROR(Faturas[[#This Row],[Valor ]]-Faturas[[#This Row],[Total pago]]+Faturas[[#This Row],[Valor por atraso ]], \"\")","v":0}]
[null,1006,{"$f":"DATE(YEAR(TODAY()),4,1)","v":"2018-04-01"},{"$f":"DATE(YEAR(TODAY()),6,1)","v":"2018-06-01"},"Manuela Ribeiro",{"v":2950,"d":"R$ 2,950.00"},{"$f":"IFERROR(IF(Faturas[[#This Row],[Vencimento]]>=Faturas[[#This Row],[Data do pagamento]],,5), \"\")","v":0},{"v":400,"d":"R$ 400.00"},{"$f":"DATE(YEAR(TODAY()),4,28)","v":"2018-04-28"},{"$f":"IFERROR(Faturas[[#This Row],[Valor ]]-Faturas[[#This Row],[Total pago]]+Faturas[[#This Row],[Valor por atraso ]], \"\")","v":{"v":2550,"d":"R$ 2,550.00"}}]
[null,"Total",{"$nulls":3},{"$f":"SUBTOTAL(109,Faturas[[Valor ]])","v":{"v":102886,"d":"R$ 102,886.00"}},null,{"$f":"SUBTOTAL(109,Faturas[Total pago])","v":{"v":67248,"d":"R$ 67,248.00"}},null,{"$f":"SUBTOTAL(109,Faturas[Devedor])","v":{"v":35648,"d":"R$ 35,648.00"}}]