{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Resumo de pagamento","Diário de pagamento"],"not_rendered":{"defined_names":6},"read":"whole","date_system":"1900"}

{"sheet":"Resumo de pagamento","index":0,"n_rows":18,"n_cols":11,"rows_kept":18,"merged":[[0,1,0,3],[0,4,0,10]]}
[null,"Resumo de pagamento",null,null,"Modifique os nomes das categorias no cabeçalho da tabela Resumo de pagamento abaixo para personalizar esse modelo para atender às suas necessidades. Se você precisar adicionar outras categorias, copie a última coluna na tabela e cole à direita da coluna copiada. Quando você alterar o nome da categoria, as fórmulas serão atualizadas automaticamente. Certifique-se de que esta tabela tem o mesmo número de linhas que a planilha Diário de pagamento."]
[null,"Data","Seguro do automóvel","Material de escritório","Conta de luz","Hipoteca","Telefone","Vazio 1","Vazio 2","Vazio 3","Vazio 4"]
[null,{"$f":"IFERROR(INDEX(Registro[],ROW(A1),1),\"\")","v":"2018-04-06"},{"$f":"IFERROR(INDIRECT(\"Registro[@Valor]\")*(INDIRECT(\"Registro[@Categoria]\")=NomeDaCategoria),\"\")","v":0},0,0,{"v":1200,"d":"R$ 1,200.00"},0,0,0,0,0]
[null,{"$f":"IFERROR(INDEX(Registro[],ROW(A2),1),\"\")","v":"2018-04-11"},0,0,{"v":85,"d":"R$ 85.00"},0,0,0,0,0,0]
[null,{"$f":"IFERROR(INDEX(Registro[],ROW(A3),1),\"\")","v":"2018-04-16"},{"v":100,"d":"R$ 100.00"},0,0,0,0,0,0,0,0]
[null,{"$f":"IFERROR(INDEX(Registro[],ROW(A4),1),\"\")","v":"2018-04-21"},0,0,0,{"v":1200,"d":"R$ 1,200.00"},0,0,0,0,0]
[null,{"$f":"IFERROR(INDEX(Registro[],ROW(A5),1),\"\")","v":"2018-04-26"},0,0,0,{"v":99,"d":"R$ 99.00"},0,0,0,0,0]
[null,{"$f":"IFERROR(INDEX(Registro[],ROW(A6),1),\"\")","v":"2018-05-01"},0,0,0,0,{"v":68,"d":"R$ 68.00"},0,0,0,0]
[null,{"$f":"IFERROR(INDEX(Registro[],ROW(A7),1),\"\")","v":"2018-05-06"},{"v":100,"d":"R$ 100.00"},0,0,0,0,0,0,0,0]
[null,{"$f":"IFERROR(INDEX(Registro[],ROW(A8),1),\"\")","v":"2018-05-11"},0,{"v":345,"d":"R$ 345.00"},0,0,0,0,0,0,0]
[null,{"$f":"IFERROR(INDEX(Registro[],ROW(A9),1),\"\")","v":"2018-05-16"},0,0,0,{"v":1200,"d":"R$ 1,200.00"},0,0,0,0,0]
[null,{"$f":"IFERROR(INDEX(Registro[],ROW(A10),1),\"\")","v":"2018-05-21"},0,0,{"v":74,"d":"R$ 74.00"},0,0,0,0,0,0]
[null,{"$f":"IFERROR(INDEX(Registro[],ROW(A11),1),\"\")","v":"2018-05-26"},0,0,0,0,{"v":123,"d":"R$ 123.00"},0,0,0,0]
[null,{"$f":"IFERROR(INDEX(Registro[],ROW(A12),1),\"\")","v":"2018-05-31"},0,{"v":99,"d":"R$ 99.00"},0,0,0,0,0,0,0]
[null,{"$f":"IFERROR(INDEX(Registro[],ROW(A13),1),\"\")","v":"2018-06-05"},{"v":100,"d":"R$ 100.00"},0,0,0,0,0,0,0,0]
[null,{"$f":"IFERROR(INDEX(Registro[],ROW(A14),1),\"\")","v":"2018-06-10"},0,0,0,{"v":1200,"d":"R$ 1,200.00"},0,0,0,0,0]
[null,{"$f":"IFERROR(INDEX(Registro[],ROW(A15),1),\"\")","v":"2018-06-15"},0,{"v":128,"d":"R$ 128.00"},0,0,0,0,0,0,0]
[null,null,{"$f":"SUBTOTAL(109,ResumoDePagamento[Seguro do automóvel])","v":{"v":300,"d":"R$ 300.00"}},{"$f":"SUBTOTAL(109,ResumoDePagamento[Material de escritório])","v":{"v":572,"d":"R$ 572.00"}},{"$f":"SUBTOTAL(109,ResumoDePagamento[Conta de luz])","v":{"v":159,"d":"R$ 159.00"}},{"$f":"SUBTOTAL(109,ResumoDePagamento[Hipoteca])","v":{"v":4899,"d":"R$ 4,899.00"}},{"$f":"SUBTOTAL(109,ResumoDePagamento[Telefone])","v":{"v":191,"d":"R$ 191.00"}},{"$f":"SUBTOTAL(109,ResumoDePagamento[Vazio 1])","v":0},{"$f":"SUBTOTAL(109,ResumoDePagamento[Vazio 2])","v":0},{"$f":"SUBTOTAL(109,ResumoDePagamento[Vazio 3])","v":0},{"$f":"SUBTOTAL(109,ResumoDePagamento[Vazio 4])","v":0}]

{"sheet":"Diário de pagamento","index":1,"n_rows":18,"n_cols":6,"rows_kept":18,"merged":[[0,1,0,3]]}
[null,"Diário de pagamento"]
[null,"Data","Número","Descrição","Categoria","Valor"]
[null,{"$f":"TODAY()-70","v":"2018-04-06"},"100","Woodgrove Bank","Hipoteca",{"v":1200,"d":"R$ 1,200.00"}]
[null,{"$f":"TODAY()-65","v":"2018-04-11"},101,"Companhia de Eletricidade e Energia","Conta de luz",{"v":85,"d":"R$ 85.00"}]
[null,{"$f":"TODAY()-60","v":"2018-04-16"},102,"Humongous Insurance","Seguro do automóvel",{"v":100,"d":"R$ 100.00"}]
[null,{"$f":"TODAY()-55","v":"2018-04-21"},103,"Woodgrove Bank","Hipoteca",{"v":1200,"d":"R$ 1,200.00"}]
[null,{"$f":"TODAY()-50","v":"2018-04-26"},104,"Companhia de Eletricidade e Energia","Hipoteca",{"v":99,"d":"R$ 99.00"}]
[null,{"$f":"TODAY()-45","v":"2018-05-01"},105,"Companhia telefônica","Telefone",{"v":68,"d":"R$ 68.00"}]
[null,{"$f":"TODAY()-40","v":"2018-05-06"},106,"Humongous Insurance","Seguro do automóvel",{"v":100,"d":"R$ 100.00"}]
[null,{"$f":"TODAY()-35","v":"2018-05-11"},107,"Litware, Inc.","Material de escritório",{"v":345,"d":"R$ 345.00"}]
[null,{"$f":"TODAY()-30","v":"2018-05-16"},110,"Woodgrove Bank","Hipoteca",{"v":1200,"d":"R$ 1,200.00"}]
[null,{"$f":"TODAY()-25","v":"2018-05-21"},111,"Companhia de Eletricidade e Energia","Conta de luz",{"v":74,"d":"R$ 74.00"}]
[null,{"$f":"TODAY()-20","v":"2018-05-26"},108,"Companhia telefônica","Telefone",{"v":123,"d":"R$ 123.00"}]
[null,{"$f":"TODAY()-15","v":"2018-05-31"},109,"Litware, Inc.","Material de escritório",{"v":99,"d":"R$ 99.00"}]
[null,{"$f":"TODAY()-10","v":"2018-06-05"},112,"Humongous Insurance","Seguro do automóvel",{"v":100,"d":"R$ 100.00"}]
[null,{"$f":"TODAY()-5","v":"2018-06-10"},113,"Woodgrove Bank","Hipoteca",{"v":1200,"d":"R$ 1,200.00"}]
[null,{"$f":"TODAY()","v":"2018-06-15"},114,"Litware, Inc.","Material de escritório",{"v":128,"d":"R$ 128.00"}]
[null,"Totais",{"$nulls":3},{"$f":"SUBTOTAL(109,Registro[Valor])","v":{"v":6121,"d":"R$ 6,121.00"}}]