{"text_format":"1","workbook":"xlsx","n_sheets":35,"sheets":["DASHBOARD","CRJAN","CRFEV","CRMAR","CRABR","CRMAI","CRJUN","CRJUL","CRAGO","CRSET","CEOUT","CRNOV","CRDEZ","CPJAN","CPFEV","CPMAR","CPABR","CPMAI","CPJUN","CPJUL","CPAGO","CPSET","CPOUT","CPNOV","CPDEZ","CADASTRO","FPAGTO","FRECEB","CLASSIFICACAO","PARCELAS","FORNECEDORES","RELATORIOS","RELRECEB","RELOPERAC","RELRET"],"not_rendered":{"charts":1,"images":3,"macros":1,"external_links":0,"defined_names":2,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"DASHBOARD","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"CRJAN","index":1,"n_rows":61,"n_cols":12,"rows_kept":61,"cut":false,"hidden":false,"merged":[[6,7,7,7],[6,6,7,6],[5,2,8,5],[0,0,1,11],[9,8,9,9],[6,11,7,11],[6,10,7,10],[6,9,7,9],[6,8,7,8]]}
["CONTROLE CONTAS  A RECEBER"]
[]
[]
[]
[]
[null,null,null,null,null,null,"SALDO ANTERIOR","TOTAL A RECEBER","RECEBIDO","A RECEBER","ATRASADO","SALDO ATUAL"]
[null,null,null,null,null,null,{"$f":"K10","v":10000},{"$f":"K59-I7","v":0},{"$f":"SUMIF(L12:L58,\"=RECEBIDO\",K12:K58)","v":0},{"$f":"SUMIF(L12:L58,\"=A RECEBER\",K12:K59)+SUMIF(L12:L58,\"=PROXIMA A RECEBER\",K12:K59)","v":0},{"$f":"SUMIF(L12:L58,\"=ATRASADA\",K12:K59)","v":0},{"$f":"SUM(G7+I7)-CPJAN!I7","v":10000}]
[]
[]
[null,null,null,null,null,null,null,null,"SALDO INICIAL >>>>>",null,10000]
[null,null,"DESCRIÇÃO DO RECEBIMENTO","Nº DOCUMENTO","TIPO DE DOC","PARCELAS","CLASSIFICAÇÃO","FORMA DE RECEBIMENTO","DATA VENCIMENTO","DATA PAGAMENTO","VALOR","STATUS"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(I12=\"\",\"\",IF(J12<>\"\",\"RECEBIDO\",IF(I12<TODAY(),\"ATRASADA\",IF(I12=TODAY(),\"VENCE HOJE\",IF(I12-TODAY()>2,\"A RECEBER\",\"PROXIMA A RECEBER\")))))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(I60=\"\",\"\",IF(J60<>\"\",\"PAGO\",IF(I60<TODAY(),\"ATRASADA\",IF(I60=TODAY(),\"VENCE HOJE\",IF(I60-TODAY()>2,\"A PAGAR\",\"PROXIMA A VENCER\")))))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,""]

{"sheet":"CRFEV","index":2,"n_rows":61,"n_cols":12,"rows_kept":61,"cut":false,"hidden":false,"merged":[[9,8,9,9],[0,0,1,11],[5,2,8,5],[6,6,7,6],[6,7,7,7],[6,8,7,8],[6,9,7,9],[6,10,7,10],[6,11,7,11]]}
["CONTROLE CONTAS  A RECEBER"]
[]
[]
[]
[]
[null,null,null,null,null,null,"SALDO ANTERIOR","TOTAL A RECEBER","RECEBIDO","A RECEBER","ATRASADO","SALDO ATUAL"]
[null,null,null,null,null,null,{"$f":"K10","v":10000},{"$f":"K59-I7","v":0},{"$f":"SUMIF(L12:L58,\"=RECEBIDO\",K12:K58)","v":0},{"$f":"SUMIF(L12:L58,\"=A RECEBER\",K12:K59)+SUMIF(L12:L58,\"=PROXIMA A RECEBER\",K12:K59)","v":0},{"$f":"SUMIF(L12:L58,\"=ATRASADA\",K12:K59)","v":0},{"$f":"SUM(G7+I7)-CPJAN!I7","v":10000}]
[]
[]
[null,null,null,null,null,null,null,null,"SALDO INICIAL >>>>>",null,10000]
[null,null,"DESCRIÇÃO DO RECEBIMENTO","Nº DOCUMENTO","TIPO DE DOC","PARCELAS","CLASSIFICAÇÃO","FORMA DE RECEBIMENTO","DATA VENCIMENTO","DATA PAGAMENTO","VALOR","STATUS"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(I12=\"\",\"\",IF(J12<>\"\",\"RECEBIDO\",IF(I12<TODAY(),\"ATRASADA\",IF(I12=TODAY(),\"VENCE HOJE\",IF(I12-TODAY()>2,\"A RECEBER\",\"PROXIMA A RECEBER\")))))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(I60=\"\",\"\",IF(J60<>\"\",\"PAGO\",IF(I60<TODAY(),\"ATRASADA\",IF(I60=TODAY(),\"VENCE HOJE\",IF(I60-TODAY()>2,\"A PAGAR\",\"PROXIMA A VENCER\")))))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,""]

{"sheet":"CRMAR","index":3,"n_rows":61,"n_cols":12,"rows_kept":61,"cut":false,"hidden":false,"merged":[[9,8,9,9],[0,0,1,11],[5,2,8,5],[6,6,7,6],[6,7,7,7],[6,8,7,8],[6,9,7,9],[6,10,7,10],[6,11,7,11]]}
["CONTROLE CONTAS  A RECEBER"]
[]
[]
[]
[]
[null,null,null,null,null,null,"SALDO ANTERIOR","TOTAL A RECEBER","RECEBIDO","A RECEBER","ATRASADO","SALDO ATUAL"]
[null,null,null,null,null,null,{"$f":"K10","v":10000},{"$f":"K59-I7","v":0},{"$f":"SUMIF(L12:L58,\"=RECEBIDO\",K12:K58)","v":0},{"$f":"SUMIF(L12:L58,\"=A RECEBER\",K12:K59)+SUMIF(L12:L58,\"=PROXIMA A RECEBER\",K12:K59)","v":0},{"$f":"SUMIF(L12:L58,\"=ATRASADA\",K12:K59)","v":0},{"$f":"SUM(G7+I7)-CPJAN!I7","v":10000}]
[]
[]
[null,null,null,null,null,null,null,null,"SALDO INICIAL >>>>>",null,10000]
[null,null,"DESCRIÇÃO DO RECEBIMENTO","Nº DOCUMENTO","TIPO DE DOC","PARCELAS","CLASSIFICAÇÃO","FORMA DE RECEBIMENTO","DATA VENCIMENTO","DATA PAGAMENTO","VALOR","STATUS"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(I12=\"\",\"\",IF(J12<>\"\",\"RECEBIDO\",IF(I12<TODAY(),\"ATRASADA\",IF(I12=TODAY(),\"VENCE HOJE\",IF(I12-TODAY()>2,\"A RECEBER\",\"PROXIMA A RECEBER\")))))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(I60=\"\",\"\",IF(J60<>\"\",\"PAGO\",IF(I60<TODAY(),\"ATRASADA\",IF(I60=TODAY(),\"VENCE HOJE\",IF(I60-TODAY()>2,\"A PAGAR\",\"PROXIMA A VENCER\")))))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,""]

{"sheet":"CRABR","index":4,"n_rows":61,"n_cols":12,"rows_kept":61,"cut":false,"hidden":false,"merged":[[9,8,9,9],[0,0,1,11],[5,2,8,5],[6,6,7,6],[6,7,7,7],[6,8,7,8],[6,9,7,9],[6,10,7,10],[6,11,7,11]]}
["CONTROLE CONTAS  A RECEBER"]
[]
[]
[]
[]
[null,null,null,null,null,null,"SALDO ANTERIOR","TOTAL A RECEBER","RECEBIDO","A RECEBER","ATRASADO","SALDO ATUAL"]
[null,null,null,null,null,null,{"$f":"K10","v":10000},{"$f":"K59-I7","v":0},{"$f":"SUMIF(L12:L58,\"=RECEBIDO\",K12:K58)","v":0},{"$f":"SUMIF(L12:L58,\"=A RECEBER\",K12:K59)+SUMIF(L12:L58,\"=PROXIMA A RECEBER\",K12:K59)","v":0},{"$f":"SUMIF(L12:L58,\"=ATRASADA\",K12:K59)","v":0},{"$f":"SUM(G7+I7)-CPJAN!I7","v":10000}]
[]
[]
[null,null,null,null,null,null,null,null,"SALDO INICIAL >>>>>",null,10000]
[null,null,"DESCRIÇÃO DO RECEBIMENTO","Nº DOCUMENTO","TIPO DE DOC","PARCELAS","CLASSIFICAÇÃO","FORMA DE RECEBIMENTO","DATA VENCIMENTO","DATA PAGAMENTO","VALOR","STATUS"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(I12=\"\",\"\",IF(J12<>\"\",\"RECEBIDO\",IF(I12<TODAY(),\"ATRASADA\",IF(I12=TODAY(),\"VENCE HOJE\",IF(I12-TODAY()>2,\"A RECEBER\",\"PROXIMA A RECEBER\")))))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(I60=\"\",\"\",IF(J60<>\"\",\"PAGO\",IF(I60<TODAY(),\"ATRASADA\",IF(I60=TODAY(),\"VENCE HOJE\",IF(I60-TODAY()>2,\"A PAGAR\",\"PROXIMA A VENCER\")))))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,""]

{"sheet":"CRMAI","index":5,"n_rows":61,"n_cols":12,"rows_kept":61,"cut":false,"hidden":false,"merged":[[9,8,9,9],[0,0,1,11],[5,2,8,5],[6,6,7,6],[6,7,7,7],[6,8,7,8],[6,9,7,9],[6,10,7,10],[6,11,7,11]]}
["CONTROLE CONTAS  A RECEBER"]
[]
[]
[]
[]
[null,null,null,null,null,null,"SALDO ANTERIOR","TOTAL A RECEBER","RECEBIDO","A RECEBER","ATRASADO","SALDO ATUAL"]
[null,null,null,null,null,null,{"$f":"K10","v":10000},{"$f":"K59-I7","v":0},{"$f":"SUMIF(L12:L58,\"=RECEBIDO\",K12:K58)","v":0},{"$f":"SUMIF(L12:L58,\"=A RECEBER\",K12:K59)+SUMIF(L12:L58,\"=PROXIMA A RECEBER\",K12:K59)","v":0},{"$f":"SUMIF(L12:L58,\"=ATRASADA\",K12:K59)","v":0},{"$f":"SUM(G7+I7)-CPJAN!I7","v":10000}]
[]
[]
[null,null,null,null,null,null,null,null,"SALDO INICIAL >>>>>",null,10000]
[null,null,"DESCRIÇÃO DO RECEBIMENTO","Nº DOCUMENTO","TIPO DE DOC","PARCELAS","CLASSIFICAÇÃO","FORMA DE RECEBIMENTO","DATA VENCIMENTO","DATA PAGAMENTO","VALOR","STATUS"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(I12=\"\",\"\",IF(J12<>\"\",\"RECEBIDO\",IF(I12<TODAY(),\"ATRASADA\",IF(I12=TODAY(),\"VENCE HOJE\",IF(I12-TODAY()>2,\"A RECEBER\",\"PROXIMA A RECEBER\")))))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(I60=\"\",\"\",IF(J60<>\"\",\"PAGO\",IF(I60<TODAY(),\"ATRASADA\",IF(I60=TODAY(),\"VENCE HOJE\",IF(I60-TODAY()>2,\"A PAGAR\",\"PROXIMA A VENCER\")))))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,""]

{"sheet":"CRJUN","index":6,"n_rows":61,"n_cols":12,"rows_kept":61,"cut":false,"hidden":false,"merged":[[9,8,9,9],[0,0,1,11],[5,2,8,5],[6,6,7,6],[6,7,7,7],[6,8,7,8],[6,9,7,9],[6,10,7,10],[6,11,7,11]]}
["CONTROLE CONTAS  A RECEBER"]
[]
[]
[]
[]
[null,null,null,null,null,null,"SALDO ANTERIOR","TOTAL A RECEBER","RECEBIDO","A RECEBER","ATRASADO","SALDO ATUAL"]
[null,null,null,null,null,null,{"$f":"K10","v":10000},{"$f":"K59-I7","v":0},{"$f":"SUMIF(L12:L58,\"=RECEBIDO\",K12:K58)","v":0},{"$f":"SUMIF(L12:L58,\"=A RECEBER\",K12:K59)+SUMIF(L12:L58,\"=PROXIMA A RECEBER\",K12:K59)","v":0},{"$f":"SUMIF(L12:L58,\"=ATRASADA\",K12:K59)","v":0},{"$f":"SUM(G7+I7)-CPJAN!I7","v":10000}]
[]
[]
[null,null,null,null,null,null,null,null,"SALDO INICIAL >>>>>",null,10000]
[null,null,"DESCRIÇÃO DO RECEBIMENTO","Nº DOCUMENTO","TIPO DE DOC","PARCELAS","CLASSIFICAÇÃO","FORMA DE RECEBIMENTO","DATA VENCIMENTO","DATA PAGAMENTO","VALOR","STATUS"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(I12=\"\",\"\",IF(J12<>\"\",\"RECEBIDO\",IF(I12<TODAY(),\"ATRASADA\",IF(I12=TODAY(),\"VENCE HOJE\",IF(I12-TODAY()>2,\"A RECEBER\",\"PROXIMA A RECEBER\")))))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(I60=\"\",\"\",IF(J60<>\"\",\"PAGO\",IF(I60<TODAY(),\"ATRASADA\",IF(I60=TODAY(),\"VENCE HOJE\",IF(I60-TODAY()>2,\"A PAGAR\",\"PROXIMA A VENCER\")))))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,""]

{"sheet":"CRJUL","index":7,"n_rows":61,"n_cols":12,"rows_kept":61,"cut":false,"hidden":false,"merged":[[9,8,9,9],[0,0,1,11],[5,2,8,5],[6,6,7,6],[6,7,7,7],[6,8,7,8],[6,9,7,9],[6,10,7,10],[6,11,7,11]]}
["CONTROLE CONTAS  A RECEBER"]
[]
[]
[]
[]
[null,null,null,null,null,null,"SALDO ANTERIOR","TOTAL A RECEBER","RECEBIDO","A RECEBER","ATRASADO","SALDO ATUAL"]
[null,null,null,null,null,null,{"$f":"K10","v":10000},{"$f":"K59-I7","v":0},{"$f":"SUMIF(L12:L58,\"=RECEBIDO\",K12:K58)","v":0},{"$f":"SUMIF(L12:L58,\"=A RECEBER\",K12:K59)+SUMIF(L12:L58,\"=PROXIMA A RECEBER\",K12:K59)","v":0},{"$f":"SUMIF(L12:L58,\"=ATRASADA\",K12:K59)","v":0},{"$f":"SUM(G7+I7)-CPJAN!I7","v":10000}]
[]
[]
[null,null,null,null,null,null,null,null,"SALDO INICIAL >>>>>",null,10000]
[null,null,"DESCRIÇÃO DO RECEBIMENTO","Nº DOCUMENTO","TIPO DE DOC","PARCELAS","CLASSIFICAÇÃO","FORMA DE RECEBIMENTO","DATA VENCIMENTO","DATA PAGAMENTO","VALOR","STATUS"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(I12=\"\",\"\",IF(J12<>\"\",\"RECEBIDO\",IF(I12<TODAY(),\"ATRASADA\",IF(I12=TODAY(),\"VENCE HOJE\",IF(I12-TODAY()>2,\"A RECEBER\",\"PROXIMA A RECEBER\")))))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(I60=\"\",\"\",IF(J60<>\"\",\"PAGO\",IF(I60<TODAY(),\"ATRASADA\",IF(I60=TODAY(),\"VENCE HOJE\",IF(I60-TODAY()>2,\"A PAGAR\",\"PROXIMA A VENCER\")))))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,""]

{"sheet":"CRAGO","index":8,"n_rows":61,"n_cols":12,"rows_kept":61,"cut":false,"hidden":false,"merged":[[9,8,9,9],[0,0,1,11],[5,2,8,5],[6,6,7,6],[6,7,7,7],[6,8,7,8],[6,9,7,9],[6,10,7,10],[6,11,7,11]]}
["CONTROLE CONTAS  A RECEBER"]
[]
[]
[]
[]
[null,null,null,null,null,null,"SALDO ANTERIOR","TOTAL A RECEBER","RECEBIDO","A RECEBER","ATRASADO","SALDO ATUAL"]
[null,null,null,null,null,null,{"$f":"K10","v":10000},{"$f":"K59-I7","v":0},{"$f":"SUMIF(L12:L58,\"=RECEBIDO\",K12:K58)","v":0},{"$f":"SUMIF(L12:L58,\"=A RECEBER\",K12:K59)+SUMIF(L12:L58,\"=PROXIMA A RECEBER\",K12:K59)","v":0},{"$f":"SUMIF(L12:L58,\"=ATRASADA\",K12:K59)","v":0},{"$f":"SUM(G7+I7)-CPJAN!I7","v":10000}]
[]
[]
[null,null,null,null,null,null,null,null,"SALDO INICIAL >>>>>",null,10000]
[null,null,"DESCRIÇÃO DO RECEBIMENTO","Nº DOCUMENTO","TIPO DE DOC","PARCELAS","CLASSIFICAÇÃO","FORMA DE RECEBIMENTO","DATA VENCIMENTO","DATA PAGAMENTO","VALOR","STATUS"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(I12=\"\",\"\",IF(J12<>\"\",\"RECEBIDO\",IF(I12<TODAY(),\"ATRASADA\",IF(I12=TODAY(),\"VENCE HOJE\",IF(I12-TODAY()>2,\"A RECEBER\",\"PROXIMA A RECEBER\")))))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(I60=\"\",\"\",IF(J60<>\"\",\"PAGO\",IF(I60<TODAY(),\"ATRASADA\",IF(I60=TODAY(),\"VENCE HOJE\",IF(I60-TODAY()>2,\"A PAGAR\",\"PROXIMA A VENCER\")))))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,""]

{"sheet":"CRSET","index":9,"n_rows":61,"n_cols":12,"rows_kept":61,"cut":false,"hidden":false,"merged":[[9,8,9,9],[0,0,1,11],[5,2,8,5],[6,6,7,6],[6,7,7,7],[6,8,7,8],[6,9,7,9],[6,10,7,10],[6,11,7,11]]}
["CONTROLE CONTAS  A RECEBER"]
[]
[]
[]
[]
[null,null,null,null,null,null,"SALDO ANTERIOR","TOTAL A RECEBER","RECEBIDO","A RECEBER","ATRASADO","SALDO ATUAL"]
[null,null,null,null,null,null,{"$f":"K10","v":10000},{"$f":"K59-I7","v":0},{"$f":"SUMIF(L12:L58,\"=RECEBIDO\",K12:K58)","v":0},{"$f":"SUMIF(L12:L58,\"=A RECEBER\",K12:K59)+SUMIF(L12:L58,\"=PROXIMA A RECEBER\",K12:K59)","v":0},{"$f":"SUMIF(L12:L58,\"=ATRASADA\",K12:K59)","v":0},{"$f":"SUM(G7+I7)-CPJAN!I7","v":10000}]
[]
[]
[null,null,null,null,null,null,null,null,"SALDO INICIAL >>>>>",null,10000]
[null,null,"DESCRIÇÃO DO RECEBIMENTO","Nº DOCUMENTO","TIPO DE DOC","PARCELAS","CLASSIFICAÇÃO","FORMA DE RECEBIMENTO","DATA VENCIMENTO","DATA PAGAMENTO","VALOR","STATUS"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(I12=\"\",\"\",IF(J12<>\"\",\"RECEBIDO\",IF(I12<TODAY(),\"ATRASADA\",IF(I12=TODAY(),\"VENCE HOJE\",IF(I12-TODAY()>2,\"A RECEBER\",\"PROXIMA A RECEBER\")))))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(I60=\"\",\"\",IF(J60<>\"\",\"PAGO\",IF(I60<TODAY(),\"ATRASADA\",IF(I60=TODAY(),\"VENCE HOJE\",IF(I60-TODAY()>2,\"A PAGAR\",\"PROXIMA A VENCER\")))))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,""]

{"sheet":"CEOUT","index":10,"n_rows":61,"n_cols":12,"rows_kept":61,"cut":false,"hidden":false,"merged":[[9,8,9,9],[0,0,1,11],[5,2,8,5],[6,6,7,6],[6,7,7,7],[6,8,7,8],[6,9,7,9],[6,10,7,10],[6,11,7,11]]}
["CONTROLE CONTAS  A RECEBER"]
[]
[]
[]
[]
[null,null,null,null,null,null,"SALDO ANTERIOR","TOTAL A RECEBER","RECEBIDO","A RECEBER","ATRASADO","SALDO ATUAL"]
[null,null,null,null,null,null,{"$f":"K10","v":10000},{"$f":"K59-I7","v":0},{"$f":"SUMIF(L12:L58,\"=RECEBIDO\",K12:K58)","v":0},{"$f":"SUMIF(L12:L58,\"=A RECEBER\",K12:K59)+SUMIF(L12:L58,\"=PROXIMA A RECEBER\",K12:K59)","v":0},{"$f":"SUMIF(L12:L58,\"=ATRASADA\",K12:K59)","v":0},{"$f":"SUM(G7+I7)-CPJAN!I7","v":10000}]
[]
[]
[null,null,null,null,null,null,null,null,"SALDO INICIAL >>>>>",null,10000]
[null,null,"DESCRIÇÃO DO RECEBIMENTO","Nº DOCUMENTO","TIPO DE DOC","PARCELAS","CLASSIFICAÇÃO","FORMA DE RECEBIMENTO","DATA VENCIMENTO","DATA PAGAMENTO","VALOR","STATUS"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(I12=\"\",\"\",IF(J12<>\"\",\"RECEBIDO\",IF(I12<TODAY(),\"ATRASADA\",IF(I12=TODAY(),\"VENCE HOJE\",IF(I12-TODAY()>2,\"A RECEBER\",\"PROXIMA A RECEBER\")))))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(I60=\"\",\"\",IF(J60<>\"\",\"PAGO\",IF(I60<TODAY(),\"ATRASADA\",IF(I60=TODAY(),\"VENCE HOJE\",IF(I60-TODAY()>2,\"A PAGAR\",\"PROXIMA A VENCER\")))))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,""]

{"sheet":"CRNOV","index":11,"n_rows":61,"n_cols":12,"rows_kept":61,"cut":false,"hidden":false,"merged":[[9,8,9,9],[0,0,1,11],[5,2,8,5],[6,6,7,6],[6,7,7,7],[6,8,7,8],[6,9,7,9],[6,10,7,10],[6,11,7,11]]}
["CONTROLE CONTAS  A RECEBER"]
[]
[]
[]
[]
[null,null,null,null,null,null,"SALDO ANTERIOR","TOTAL A RECEBER","RECEBIDO","A RECEBER","ATRASADO","SALDO ATUAL"]
[null,null,null,null,null,null,{"$f":"K10","v":10000},{"$f":"K59-I7","v":0},{"$f":"SUMIF(L12:L58,\"=RECEBIDO\",K12:K58)","v":0},{"$f":"SUMIF(L12:L58,\"=A RECEBER\",K12:K59)+SUMIF(L12:L58,\"=PROXIMA A RECEBER\",K12:K59)","v":0},{"$f":"SUMIF(L12:L58,\"=ATRASADA\",K12:K59)","v":0},{"$f":"SUM(G7+I7)-CPJAN!I7","v":10000}]
[]
[]
[null,null,null,null,null,null,null,null,"SALDO INICIAL >>>>>",null,10000]
[null,null,"DESCRIÇÃO DO RECEBIMENTO","Nº DOCUMENTO","TIPO DE DOC","PARCELAS","CLASSIFICAÇÃO","FORMA DE RECEBIMENTO","DATA VENCIMENTO","DATA PAGAMENTO","VALOR","STATUS"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(I12=\"\",\"\",IF(J12<>\"\",\"RECEBIDO\",IF(I12<TODAY(),\"ATRASADA\",IF(I12=TODAY(),\"VENCE HOJE\",IF(I12-TODAY()>2,\"A RECEBER\",\"PROXIMA A RECEBER\")))))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(I60=\"\",\"\",IF(J60<>\"\",\"PAGO\",IF(I60<TODAY(),\"ATRASADA\",IF(I60=TODAY(),\"VENCE HOJE\",IF(I60-TODAY()>2,\"A PAGAR\",\"PROXIMA A VENCER\")))))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,""]

{"sheet":"CRDEZ","index":12,"n_rows":61,"n_cols":12,"rows_kept":61,"cut":false,"hidden":false,"merged":[[9,8,9,9],[0,0,1,11],[5,2,8,5],[6,6,7,6],[6,7,7,7],[6,8,7,8],[6,9,7,9],[6,10,7,10],[6,11,7,11]]}
["CONTROLE CONTAS  A RECEBER"]
[]
[]
[]
[]
[null,null,null,null,null,null,"SALDO ANTERIOR","TOTAL A RECEBER","RECEBIDO","A RECEBER","ATRASADO","SALDO ATUAL"]
[null,null,null,null,null,null,{"$f":"K10","v":10000},{"$f":"K59-I7","v":0},{"$f":"SUMIF(L12:L58,\"=RECEBIDO\",K12:K58)","v":0},{"$f":"SUMIF(L12:L58,\"=A RECEBER\",K12:K59)+SUMIF(L12:L58,\"=PROXIMA A RECEBER\",K12:K59)","v":0},{"$f":"SUMIF(L12:L58,\"=ATRASADA\",K12:K59)","v":0},{"$f":"SUM(G7+I7)-CPJAN!I7","v":10000}]
[]
[]
[null,null,null,null,null,null,null,null,"SALDO INICIAL >>>>>",null,10000]
[null,null,"DESCRIÇÃO DO RECEBIMENTO","Nº DOCUMENTO","TIPO DE DOC","PARCELAS","CLASSIFICAÇÃO","FORMA DE RECEBIMENTO","DATA VENCIMENTO","DATA PAGAMENTO","VALOR","STATUS"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(I12=\"\",\"\",IF(J12<>\"\",\"RECEBIDO\",IF(I12<TODAY(),\"ATRASADA\",IF(I12=TODAY(),\"VENCE HOJE\",IF(I12-TODAY()>2,\"A RECEBER\",\"PROXIMA A RECEBER\")))))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(I60=\"\",\"\",IF(J60<>\"\",\"PAGO\",IF(I60<TODAY(),\"ATRASADA\",IF(I60=TODAY(),\"VENCE HOJE\",IF(I60-TODAY()>2,\"A PAGAR\",\"PROXIMA A VENCER\")))))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,""]

{"sheet":"CPJAN","index":13,"n_rows":61,"n_cols":12,"rows_kept":61,"cut":false,"hidden":false,"merged":[[9,8,9,9],[5,2,8,5],[0,0,1,11],[6,6,7,6],[6,7,7,7],[6,8,7,8],[6,9,7,9],[6,10,7,10],[6,11,7,11]]}
["CONTROLE CONTAS A PAGAR"]
[]
[]
[]
[]
[null,null,null,null,null,null,"SALDO ANTERIOR","TOTAL A PAGAR","PAGO","A PAGAR","ATRASADO","SALDO ATUAL"]
[null,null,null,null,null,null,{"$f":"K10","v":10000},{"$f":"K59-I7","v":0},{"$f":"SUMIF(L12:L58,\"=PAGO\",K12:K58)","v":0},{"$f":"SUMIF(L12:L58,\"=A PAGAR\",K12:K59)+SUMIF(L12:L58,\"=PROXIMA A VENCER\",K12:K59)","v":0},{"$f":"SUMIF(L12:L58,\"=ATRASADA\",K12:K59)","v":0},{"$f":"CRJAN!L7:L8","v":10000}]
[]
[]
[null,null,null,null,null,null,null,null,"SALDO INICIAL >>>>>",null,10000]
[null,null,"DESCRIÇÃO DO PAGAMENTO","Nº DOCUMENTO","TIPO DE DOC","PARCELAS","CLASSIFICAÇÃO","FORMA DE RECEBIMENTO","DATA VENCIMENTO","DATA PAGAMENTO","VALOR","STATUS"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(I12=\"\",\"\",IF(J12<>\"\",\"PAGO\",IF(I12<TODAY(),\"ATRASADA\",IF(I12=TODAY(),\"VENCE HOJE\",IF(I12-TODAY()>2,\"A PAGAR\",\"PROXIMA A VENCER\")))))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(K12:K57)","v":0},{"$f":"IF(I59=\"\",\"\",IF(J59<>\"\",\"PAGO\",IF(I59<TODAY(),\"ATRASADA\",IF(I59=TODAY(),\"VENCE HOJE\",IF(I59-TODAY()>2,\"A PAGAR\",\"PROXIMA A VENCER\")))))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]

{"sheet":"CPFEV","index":14,"n_rows":61,"n_cols":12,"rows_kept":61,"cut":false,"hidden":false,"merged":[[9,8,9,9],[0,0,1,11],[5,2,8,5],[6,6,7,6],[6,7,7,7],[6,8,7,8],[6,9,7,9],[6,10,7,10],[6,11,7,11]]}
["CONTROLE CONTAS A PAGAR"]
[]
[]
[]
[]
[null,null,null,null,null,null,"SALDO ANTERIOR","TOTAL A PAGAR","PAGO","A PAGAR","ATRASADO","SALDO ATUAL"]
[null,null,null,null,null,null,{"$f":"K10","v":10000},{"$f":"K59-I7","v":0},{"$f":"SUMIF(L12:L58,\"=PAGO\",K12:K58)","v":0},{"$f":"SUMIF(L12:L58,\"=A PAGAR\",K12:K59)+SUMIF(L12:L58,\"=PROXIMA A VENCER\",K12:K59)","v":0},{"$f":"SUMIF(L12:L58,\"=ATRASADA\",K12:K59)","v":0},{"$f":"CRJAN!L7:L8","v":10000}]
[]
[]
[null,null,null,null,null,null,null,null,"SALDO INICIAL >>>>>",null,10000]
[null,null,"DESCRIÇÃO DO PAGAMENTO","Nº DOCUMENTO","TIPO DE DOC","PARCELAS","CLASSIFICAÇÃO","FORMA DE RECEBIMENTO","DATA VENCIMENTO","DATA PAGAMENTO","VALOR","STATUS"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(I12=\"\",\"\",IF(J12<>\"\",\"PAGO\",IF(I12<TODAY(),\"ATRASADA\",IF(I12=TODAY(),\"VENCE HOJE\",IF(I12-TODAY()>2,\"A PAGAR\",\"PROXIMA A VENCER\")))))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(K12:K57)","v":0},""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]

{"sheet":"CPMAR","index":15,"n_rows":61,"n_cols":12,"rows_kept":61,"cut":false,"hidden":false,"merged":[[9,8,9,9],[0,0,1,11],[5,2,8,5],[6,6,7,6],[6,7,7,7],[6,8,7,8],[6,9,7,9],[6,10,7,10],[6,11,7,11]]}
["CONTROLE CONTAS A PAGAR"]
[]
[]
[]
[]
[null,null,null,null,null,null,"SALDO ANTERIOR","TOTAL A PAGAR","PAGO","A PAGAR","ATRASADO","SALDO ATUAL"]
[null,null,null,null,null,null,{"$f":"K10","v":10000},{"$f":"K59-I7","v":0},{"$f":"SUMIF(L12:L58,\"=PAGO\",K12:K58)","v":0},{"$f":"SUMIF(L12:L58,\"=A PAGAR\",K12:K59)+SUMIF(L12:L58,\"=PROXIMA A VENCER\",K12:K59)","v":0},{"$f":"SUMIF(L12:L58,\"=ATRASADA\",K12:K59)","v":0},{"$f":"CRJAN!L7:L8","v":10000}]
[]
[]
[null,null,null,null,null,null,null,null,"SALDO INICIAL >>>>>",null,10000]
[null,null,"DESCRIÇÃO DO PAGAMENTO","Nº DOCUMENTO","TIPO DE DOC","PARCELAS","CLASSIFICAÇÃO","FORMA DE RECEBIMENTO","DATA VENCIMENTO","DATA PAGAMENTO","VALOR","STATUS"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(I12=\"\",\"\",IF(J12<>\"\",\"PAGO\",IF(I12<TODAY(),\"ATRASADA\",IF(I12=TODAY(),\"VENCE HOJE\",IF(I12-TODAY()>2,\"A PAGAR\",\"PROXIMA A VENCER\")))))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(K12:K57)","v":0},""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]

{"sheet":"CPABR","index":16,"n_rows":61,"n_cols":12,"rows_kept":61,"cut":false,"hidden":false,"merged":[[9,8,9,9],[0,0,1,11],[5,2,8,5],[6,6,7,6],[6,7,7,7],[6,8,7,8],[6,9,7,9],[6,10,7,10],[6,11,7,11]]}
["CONTROLE CONTAS A PAGAR"]
[]
[]
[]
[]
[null,null,null,null,null,null,"SALDO ANTERIOR","TOTAL A PAGAR","PAGO","A PAGAR","ATRASADO","SALDO ATUAL"]
[null,null,null,null,null,null,{"$f":"K10","v":10000},{"$f":"K59-I7","v":0},{"$f":"SUMIF(L12:L58,\"=PAGO\",K12:K58)","v":0},{"$f":"SUMIF(L12:L58,\"=A PAGAR\",K12:K59)+SUMIF(L12:L58,\"=PROXIMA A VENCER\",K12:K59)","v":0},{"$f":"SUMIF(L12:L58,\"=ATRASADA\",K12:K59)","v":0},{"$f":"CRJAN!L7:L8","v":10000}]
[]
[]
[null,null,null,null,null,null,null,null,"SALDO INICIAL >>>>>",null,10000]
[null,null,"DESCRIÇÃO DO PAGAMENTO","Nº DOCUMENTO","TIPO DE DOC","PARCELAS","CLASSIFICAÇÃO","FORMA DE RECEBIMENTO","DATA VENCIMENTO","DATA PAGAMENTO","VALOR","STATUS"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(I12=\"\",\"\",IF(J12<>\"\",\"PAGO\",IF(I12<TODAY(),\"ATRASADA\",IF(I12=TODAY(),\"VENCE HOJE\",IF(I12-TODAY()>2,\"A PAGAR\",\"PROXIMA A VENCER\")))))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(K12:K57)","v":0},""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]

{"sheet":"CPMAI","index":17,"n_rows":61,"n_cols":12,"rows_kept":61,"cut":false,"hidden":false,"merged":[[9,8,9,9],[0,0,1,11],[5,2,8,5],[6,6,7,6],[6,7,7,7],[6,8,7,8],[6,9,7,9],[6,10,7,10],[6,11,7,11]]}
["CONTROLE CONTAS A PAGAR"]
[]
[]
[]
[]
[null,null,null,null,null,null,"SALDO ANTERIOR","TOTAL A PAGAR","PAGO","A PAGAR","ATRASADO","SALDO ATUAL"]
[null,null,null,null,null,null,{"$f":"K10","v":10000},{"$f":"K59-I7","v":0},{"$f":"SUMIF(L12:L58,\"=PAGO\",K12:K58)","v":0},{"$f":"SUMIF(L12:L58,\"=A PAGAR\",K12:K59)+SUMIF(L12:L58,\"=PROXIMA A VENCER\",K12:K59)","v":0},{"$f":"SUMIF(L12:L58,\"=ATRASADA\",K12:K59)","v":0},{"$f":"CRJAN!L7:L8","v":10000}]
[]
[]
[null,null,null,null,null,null,null,null,"SALDO INICIAL >>>>>",null,10000]
[null,null,"DESCRIÇÃO DO PAGAMENTO","Nº DOCUMENTO","TIPO DE DOC","PARCELAS","CLASSIFICAÇÃO","FORMA DE RECEBIMENTO","DATA VENCIMENTO","DATA PAGAMENTO","VALOR","STATUS"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(I12=\"\",\"\",IF(J12<>\"\",\"PAGO\",IF(I12<TODAY(),\"ATRASADA\",IF(I12=TODAY(),\"VENCE HOJE\",IF(I12-TODAY()>2,\"A PAGAR\",\"PROXIMA A VENCER\")))))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(K12:K57)","v":0},""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]

{"sheet":"CPJUN","index":18,"n_rows":61,"n_cols":12,"rows_kept":61,"cut":false,"hidden":false,"merged":[[9,8,9,9],[0,0,1,11],[5,2,8,5],[6,6,7,6],[6,7,7,7],[6,8,7,8],[6,9,7,9],[6,10,7,10],[6,11,7,11]]}
["CONTROLE CONTAS A PAGAR"]
[]
[]
[]
[]
[null,null,null,null,null,null,"SALDO ANTERIOR","TOTAL A PAGAR","PAGO","A PAGAR","ATRASADO","SALDO ATUAL"]
[null,null,null,null,null,null,{"$f":"K10","v":10000},{"$f":"K59-I7","v":0},{"$f":"SUMIF(L12:L58,\"=PAGO\",K12:K58)","v":0},{"$f":"SUMIF(L12:L58,\"=A PAGAR\",K12:K59)+SUMIF(L12:L58,\"=PROXIMA A VENCER\",K12:K59)","v":0},{"$f":"SUMIF(L12:L58,\"=ATRASADA\",K12:K59)","v":0},{"$f":"CRJAN!L7:L8","v":10000}]
[]
[]
[null,null,null,null,null,null,null,null,"SALDO INICIAL >>>>>",null,10000]
[null,null,"DESCRIÇÃO DO PAGAMENTO","Nº DOCUMENTO","TIPO DE DOC","PARCELAS","CLASSIFICAÇÃO","FORMA DE RECEBIMENTO","DATA VENCIMENTO","DATA PAGAMENTO","VALOR","STATUS"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(I12=\"\",\"\",IF(J12<>\"\",\"PAGO\",IF(I12<TODAY(),\"ATRASADA\",IF(I12=TODAY(),\"VENCE HOJE\",IF(I12-TODAY()>2,\"A PAGAR\",\"PROXIMA A VENCER\")))))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(K12:K57)","v":0},""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]

{"sheet":"CPJUL","index":19,"n_rows":61,"n_cols":12,"rows_kept":61,"cut":false,"hidden":false,"merged":[[9,8,9,9],[0,0,1,11],[5,2,8,5],[6,6,7,6],[6,7,7,7],[6,8,7,8],[6,9,7,9],[6,10,7,10],[6,11,7,11]]}
["CONTROLE CONTAS A PAGAR"]
[]
[]
[]
[]
[null,null,null,null,null,null,"SALDO ANTERIOR","TOTAL A PAGAR","PAGO","A PAGAR","ATRASADO","SALDO ATUAL"]
[null,null,null,null,null,null,{"$f":"K10","v":10000},{"$f":"K59-I7","v":0},{"$f":"SUMIF(L12:L58,\"=PAGO\",K12:K58)","v":0},{"$f":"SUMIF(L12:L58,\"=A PAGAR\",K12:K59)+SUMIF(L12:L58,\"=PROXIMA A VENCER\",K12:K59)","v":0},{"$f":"SUMIF(L12:L58,\"=ATRASADA\",K12:K59)","v":0},{"$f":"CRJAN!L7:L8","v":10000}]
[]
[]
[null,null,null,null,null,null,null,null,"SALDO INICIAL >>>>>",null,10000]
[null,null,"DESCRIÇÃO DO PAGAMENTO","Nº DOCUMENTO","TIPO DE DOC","PARCELAS","CLASSIFICAÇÃO","FORMA DE RECEBIMENTO","DATA VENCIMENTO","DATA PAGAMENTO","VALOR","STATUS"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(I12=\"\",\"\",IF(J12<>\"\",\"PAGO\",IF(I12<TODAY(),\"ATRASADA\",IF(I12=TODAY(),\"VENCE HOJE\",IF(I12-TODAY()>2,\"A PAGAR\",\"PROXIMA A VENCER\")))))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(K12:K57)","v":0},""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]

{"sheet":"CPAGO","index":20,"n_rows":61,"n_cols":12,"rows_kept":61,"cut":false,"hidden":false,"merged":[[9,8,9,9],[0,0,1,11],[5,2,8,5],[6,6,7,6],[6,7,7,7],[6,8,7,8],[6,9,7,9],[6,10,7,10],[6,11,7,11]]}
["CONTROLE CONTAS A PAGAR"]
[]
[]
[]
[]
[null,null,null,null,null,null,"SALDO ANTERIOR","TOTAL A PAGAR","PAGO","A PAGAR","ATRASADO","SALDO ATUAL"]
[null,null,null,null,null,null,{"$f":"K10","v":10000},{"$f":"K59-I7","v":0},{"$f":"SUMIF(L12:L58,\"=PAGO\",K12:K58)","v":0},{"$f":"SUMIF(L12:L58,\"=A PAGAR\",K12:K59)+SUMIF(L12:L58,\"=PROXIMA A VENCER\",K12:K59)","v":0},{"$f":"SUMIF(L12:L58,\"=ATRASADA\",K12:K59)","v":0},{"$f":"CRJAN!L7:L8","v":10000}]
[]
[]
[null,null,null,null,null,null,null,null,"SALDO INICIAL >>>>>",null,10000]
[null,null,"DESCRIÇÃO DO PAGAMENTO","Nº DOCUMENTO","TIPO DE DOC","PARCELAS","CLASSIFICAÇÃO","FORMA DE RECEBIMENTO","DATA VENCIMENTO","DATA PAGAMENTO","VALOR","STATUS"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(I12=\"\",\"\",IF(J12<>\"\",\"PAGO\",IF(I12<TODAY(),\"ATRASADA\",IF(I12=TODAY(),\"VENCE HOJE\",IF(I12-TODAY()>2,\"A PAGAR\",\"PROXIMA A VENCER\")))))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(K12:K57)","v":0},""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]

{"sheet":"CPSET","index":21,"n_rows":61,"n_cols":12,"rows_kept":61,"cut":false,"hidden":false,"merged":[[9,8,9,9],[0,0,1,11],[5,2,8,5],[6,6,7,6],[6,7,7,7],[6,8,7,8],[6,9,7,9],[6,10,7,10],[6,11,7,11]]}
["CONTROLE CONTAS A PAGAR"]
[]
[]
[]
[]
[null,null,null,null,null,null,"SALDO ANTERIOR","TOTAL A PAGAR","PAGO","A PAGAR","ATRASADO","SALDO ATUAL"]
[null,null,null,null,null,null,{"$f":"K10","v":10000},{"$f":"K59-I7","v":0},{"$f":"SUMIF(L12:L58,\"=PAGO\",K12:K58)","v":0},{"$f":"SUMIF(L12:L58,\"=A PAGAR\",K12:K59)+SUMIF(L12:L58,\"=PROXIMA A VENCER\",K12:K59)","v":0},{"$f":"SUMIF(L12:L58,\"=ATRASADA\",K12:K59)","v":0},{"$f":"CRJAN!L7:L8","v":10000}]
[]
[]
[null,null,null,null,null,null,null,null,"SALDO INICIAL >>>>>",null,10000]
[null,null,"DESCRIÇÃO DO PAGAMENTO","Nº DOCUMENTO","TIPO DE DOC","PARCELAS","CLASSIFICAÇÃO","FORMA DE RECEBIMENTO","DATA VENCIMENTO","DATA PAGAMENTO","VALOR","STATUS"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(I12=\"\",\"\",IF(J12<>\"\",\"PAGO\",IF(I12<TODAY(),\"ATRASADA\",IF(I12=TODAY(),\"VENCE HOJE\",IF(I12-TODAY()>2,\"A PAGAR\",\"PROXIMA A VENCER\")))))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(K12:K57)","v":0},""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]

{"sheet":"CPOUT","index":22,"n_rows":61,"n_cols":12,"rows_kept":61,"cut":false,"hidden":false,"merged":[[9,8,9,9],[0,0,1,11],[5,2,8,5],[6,6,7,6],[6,7,7,7],[6,8,7,8],[6,9,7,9],[6,10,7,10],[6,11,7,11]]}
["CONTROLE CONTAS A PAGAR"]
[]
[]
[]
[]
[null,null,null,null,null,null,"SALDO ANTERIOR","TOTAL A PAGAR","PAGO","A PAGAR","ATRASADO","SALDO ATUAL"]
[null,null,null,null,null,null,{"$f":"K10","v":10000},{"$f":"K59-I7","v":0},{"$f":"SUMIF(L12:L58,\"=PAGO\",K12:K58)","v":0},{"$f":"SUMIF(L12:L58,\"=A PAGAR\",K12:K59)+SUMIF(L12:L58,\"=PROXIMA A VENCER\",K12:K59)","v":0},{"$f":"SUMIF(L12:L58,\"=ATRASADA\",K12:K59)","v":0},{"$f":"CRJAN!L7:L8","v":10000}]
[]
[]
[null,null,null,null,null,null,null,null,"SALDO INICIAL >>>>>",null,10000]
[null,null,"DESCRIÇÃO DO PAGAMENTO","Nº DOCUMENTO","TIPO DE DOC","PARCELAS","CLASSIFICAÇÃO","FORMA DE RECEBIMENTO","DATA VENCIMENTO","DATA PAGAMENTO","VALOR","STATUS"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(I12=\"\",\"\",IF(J12<>\"\",\"PAGO\",IF(I12<TODAY(),\"ATRASADA\",IF(I12=TODAY(),\"VENCE HOJE\",IF(I12-TODAY()>2,\"A PAGAR\",\"PROXIMA A VENCER\")))))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(K12:K57)","v":0},""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]

{"sheet":"CPNOV","index":23,"n_rows":61,"n_cols":12,"rows_kept":61,"cut":false,"hidden":false,"merged":[[9,8,9,9],[0,0,1,11],[5,2,8,5],[6,6,7,6],[6,7,7,7],[6,8,7,8],[6,9,7,9],[6,10,7,10],[6,11,7,11]]}
["CONTROLE CONTAS A PAGAR"]
[]
[]
[]
[]
[null,null,null,null,null,null,"SALDO ANTERIOR","TOTAL A PAGAR","PAGO","A PAGAR","ATRASADO","SALDO ATUAL"]
[null,null,null,null,null,null,{"$f":"K10","v":10000},{"$f":"K59-I7","v":0},{"$f":"SUMIF(L12:L58,\"=PAGO\",K12:K58)","v":0},{"$f":"SUMIF(L12:L58,\"=A PAGAR\",K12:K59)+SUMIF(L12:L58,\"=PROXIMA A VENCER\",K12:K59)","v":0},{"$f":"SUMIF(L12:L58,\"=ATRASADA\",K12:K59)","v":0},{"$f":"CRJAN!L7:L8","v":10000}]
[]
[]
[null,null,null,null,null,null,null,null,"SALDO INICIAL >>>>>",null,10000]
[null,null,"DESCRIÇÃO DO PAGAMENTO","Nº DOCUMENTO","TIPO DE DOC","PARCELAS","CLASSIFICAÇÃO","FORMA DE RECEBIMENTO","DATA VENCIMENTO","DATA PAGAMENTO","VALOR","STATUS"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(I12=\"\",\"\",IF(J12<>\"\",\"PAGO\",IF(I12<TODAY(),\"ATRASADA\",IF(I12=TODAY(),\"VENCE HOJE\",IF(I12-TODAY()>2,\"A PAGAR\",\"PROXIMA A VENCER\")))))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(K12:K57)","v":0},""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]

{"sheet":"CPDEZ","index":24,"n_rows":61,"n_cols":12,"rows_kept":61,"cut":false,"hidden":false,"merged":[[9,8,9,9],[0,0,1,11],[5,2,8,5],[6,6,7,6],[6,7,7,7],[6,8,7,8],[6,9,7,9],[6,10,7,10],[6,11,7,11]]}
["CONTROLE CONTAS A PAGAR"]
[]
[]
[]
[]
[null,null,null,null,null,null,"SALDO ANTERIOR","TOTAL A PAGAR","PAGO","A PAGAR","ATRASADO","SALDO ATUAL"]
[null,null,null,null,null,null,{"$f":"K10","v":10000},{"$f":"K59-I7","v":0},{"$f":"SUMIF(L12:L58,\"=PAGO\",K12:K58)","v":0},{"$f":"SUMIF(L12:L58,\"=A PAGAR\",K12:K59)+SUMIF(L12:L58,\"=PROXIMA A VENCER\",K12:K59)","v":0},{"$f":"SUMIF(L12:L58,\"=ATRASADA\",K12:K59)","v":0},{"$f":"CRJAN!L7:L8","v":10000}]
[]
[]
[null,null,null,null,null,null,null,null,"SALDO INICIAL >>>>>",null,10000]
[null,null,"DESCRIÇÃO DO PAGAMENTO","Nº DOCUMENTO","TIPO DE DOC","PARCELAS","CLASSIFICAÇÃO","FORMA DE RECEBIMENTO","DATA VENCIMENTO","DATA PAGAMENTO","VALOR","STATUS"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(I12=\"\",\"\",IF(J12<>\"\",\"PAGO\",IF(I12<TODAY(),\"ATRASADA\",IF(I12=TODAY(),\"VENCE HOJE\",IF(I12-TODAY()>2,\"A PAGAR\",\"PROXIMA A VENCER\")))))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(K12:K57)","v":0},""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]

{"sheet":"CADASTRO","index":25,"n_rows":37,"n_cols":7,"rows_kept":37,"cut":false,"hidden":false,"merged":[[0,0,1,12]]}
["CADASTRO - TIPOS DE DOCUMENTOS"]
[]
[]
[]
[]
[]
[null,null,"ITEM 1","DOC PAGAMENTOS",null,"ITEM 2","DOC RECEBIMENTO"]
[]
[null,null,"1.1","BOLETO",null,"2.1","BOLETO"]
[null,null,"1.2","C. CRÉDITO  BB",null,"2.2","C. CRÉDITO"]
[null,null,"1.3","C. CRÉDITO PF",null,"2.3","C. DÉBITO"]
[null,null,"1.4","CHEQUE",null,"2.4","CHEQUE"]
[null,null,"1.5","DUPLICATA",null,"2.5","DINHEIRO"]
[null,null,"1.6","NOTA FISCAL",null,"2.6","OUTROS"]
[null,null,"1.7","OUTROS",null,"2.7","PIX BB"]
[null,null,"1.8","TITULOS",null,"2.8","PIX ITAÚ"]
[null,null,"1.9",null,null,"2.9","TRANSF. BB"]
[null,null,"1.10",null,null,"2.10","TRANSF. ITAÚ"]
[null,null,"1.11",null,null,"2.11"]
[null,null,"1.12",null,null,"2.12"]
[null,null,"1.13",null,null,"2.13"]
[null,null,"1.14",null,null,"2.14"]
[null,null,"1.15",null,null,"2.15"]
[null,null,"1.16",null,null,"2.16"]
[null,null,"1.17",null,null,"2.17"]
[null,null,"1.18",null,null,"2.18"]
[null,null,"1.19",null,null,"2.19"]
[null,null,"1.20",null,null,"2.20"]
[null,null,"1.21",null,null,"2.21"]
[null,null,"1.22",null,null,"2.22"]
[null,null,"1.23",null,null,"2.23"]
[null,null,"1.24",null,null,"2.24"]
[null,null,"1.25",null,null,"2.25"]
[null,null,"1.26",null,null,"2.26"]
[null,null,"1.27",null,null,"2.27"]
[null,null,"1.28",null,null,"2.28"]
[null,null,"1.29",null,null,"2.29"]

{"sheet":"FPAGTO","index":26,"n_rows":33,"n_cols":4,"rows_kept":33,"cut":false,"hidden":false,"merged":[[0,0,1,13]]}
["CADASTRO - FORMAS DE PAGAMENTOS"]
[]
[]
[]
[]
[]
[null,null,"ITEM 3","FORMAS DE PGTO"]
[]
[null,null,"3.1","CHEQUE CLIENTE"]
[null,null,"3.2","DEB CONTA BB"]
[null,null,"3.3","DEB CONTA ITAU"]
[null,null,"3.4","DEP. C. FAVORECIDO"]
[null,null,"3.5","DINHEIRO"]
[null,null,"3.6","EM MÃOS"]
[null,null,"3.7","OUTROS MEIOS"]
[null,null,"3.8","RETIRADA \"A\""]
[null,null,"3.9","RETIRADA \"M\""]
[null,null,"3.10","TRANSF  BB"]
[null,null,"3.11","TRANSF  PIX BB"]
[null,null,"3.12","TRANSF ITAÚ"]
[null,null,"3.13","TRANSF PIX ITAÚ"]
[null,null,"3.14"]
[null,null,"3.15"]
[null,null,"3.16"]
[null,null,"3.17"]
[null,null,"3.18"]
[null,null,"3.19"]
[null,null,"3.20"]
[null,null,"3.21"]
[null,null,"3.22"]
[null,null,"3.23"]
[null,null,"3.24"]
[null,null,"3.25"]

{"sheet":"FRECEB","index":27,"n_rows":33,"n_cols":4,"rows_kept":33,"cut":false,"hidden":false,"merged":[[0,0,1,12]]}
["CADASTRO - FORMAS DE RECEBIMENTOS"]
[]
[]
[]
[]
[]
[null,null,"ITEM 4","FORMA DE RECEBTOS"]
[]
[null,null,"4.1","BOLETO"]
[null,null,"4.2","CHEQUE"]
[null,null,"4.3","CRÉDITO   1x"]
[null,null,"4.4","CRÉDITO   2x"]
[null,null,"4.5","CRÉDITO   3x"]
[null,null,"4.6","CRÉDITO   4x"]
[null,null,"4.7","CRÉDITO   5x"]
[null,null,"4.8","CRÉDITO   6x"]
[null,null,"4.9","CRÉDITO   7x"]
[null,null,"4.10","CRÉDITO   8x"]
[null,null,"4.11","CRÉDITO   9x"]
[null,null,"4.12","CRÉDITO 10x"]
[null,null,"4.13","CRÉDITO 11x"]
[null,null,"4.14","CRÉDITO 12x"]
[null,null,"4.15","DEBITO"]
[null,null,"4.16","DINHEIRO"]
[null,null,"4.17","OUTROS"]
[null,null,"4.18","PIX BB"]
[null,null,"4.19","PIX ITAÚ"]
[null,null,"4.20","TRANFERÊNCIA BB"]
[null,null,"4.21","TRANSFERÊNCIA ITAÚ"]
[null,null,"4.22"]
[null,null,"4.23"]
[null,null,"4.24"]
[null,null,"4.25"]

{"sheet":"CLASSIFICACAO","index":28,"n_rows":53,"n_cols":7,"rows_kept":53,"cut":false,"hidden":false,"merged":[[0,0,1,12]]}
["CADASTRO - CLASSIFICAÇÃO"]
[]
[]
[]
[]
[]
[null,null,"ITEM 5","CONTAS A PAGAR",null,"ITEM 6","CONTAS A RECEBER"]
[]
[null,null,"5.01","13° SALÁRIO",null,"6.01","BANHEIRO"]
[null,null,"5.02","ADIANTAMENTO",null,"6.02","BICO"]
[null,null,"5.03","ÁGUA",null,"6.03","COZINHA"]
[null,null,"5.04","ALUGUEL",null,"6.04","DORMITÓRIO"]
[null,null,"5.05","BOLETO",null,"6.05","ESCRITÓRIO"]
[null,null,"5.06","BONIFICAÇÃO",null,"6.06","HOME"]
[null,null,"5.07","CELULAR A",null,"6.07","HOME OFFICE"]
[null,null,"5.08","CELULAR M",null,"6.08","LAVANDERIA"]
[null,null,"5.09","COMBUSTIVEL A",null,"6.09","SALA"]
[null,null,"5.10","COMBUSTIVEL M",null,"6.10","SALA DE JANTAR"]
[null,null,"5.11","CONTABILIDADE",null,"6.11","VÁRIOS AMBIENTES"]
[null,null,"5.12","EMPREITA",null,"6.12"]
[null,null,"5.13","EMPRÉSTIMO",null,"6.13"]
[null,null,"5.14","ENERGIA ELÉTRICA",null,"6.14"]
[null,null,"5.15","FGTS",null,"6.15"]
[null,null,"5.16","FORNECEDOR",null,"6.16"]
[null,null,"5.17","FORNECEDOR 1",null,"6.17"]
[null,null,"5.18","FORNECEDOR 2",null,"6.18"]
[null,null,"5.19","FORNECEDOR 3",null,"6.19"]
[null,null,"5.20","FRETE",null,"6.20"]
[null,null,"5.21","HORA EXTRA",null,"6.21"]
[null,null,"5.22","IMPOSTOS",null,"6.22"]
[null,null,"5.23","INSS",null,"6.23"]
[null,null,"5.24","INVESTIMENTO",null,"6.24"]
[null,null,"5.25","MANUT. VEICULO A",null,"6.25"]
[null,null,"5.26","MANUT. VEICULO M",null,"6.26"]
[null,null,"5.27","MANUTENÇÃO",null,"6.27"]
[null,null,"5.28","MAT  LIMPEZA",null,"6.28"]
[null,null,"5.29","MAT ESCRITÓRIO",null,"6.29"]
[null,null,"5.30","TELEFONE NET",null,"6.30"]
[null,null,"5.31","PROJETOS",null,"6.31"]
[null,null,"5.32","RETIRADA A",null,"6.32"]
[null,null,"5.33","RETIRADA M",null,"6.33"]
[null,null,"5.34","SALÁRIO",null,"6.34"]
[null,null,"5.35","SUPRIMENTOS COZINHA",null,"6.35"]
[null,null,"5.36","TARIFAS BANCO  BRASIL",null,"6.36"]
[null,null,"5.37","TELEFONE FIXO",null,"6.37"]
[null,null,"5.38","TV A CABO/INTERNET",null,"6.38"]
[null,null,"5.39","V.TRANSP",null,"6.39"]
[null,null,"5.40","VALE"]
[null,null,"5.41"]
[null,null,"5.42"]
[null,null,"5.43"]
[null,null,"5.44"]
[null,null,"5.45"]

{"sheet":"PARCELAS","index":29,"n_rows":86,"n_cols":4,"rows_kept":86,"cut":false,"hidden":false,"merged":[[0,0,1,12]]}
["CADASTRO - PARCELAS"]
[]
[]
[]
[]
[]
[null,null,"ITEM 7","PARCELAS"]
[]
[null,null,"7.1","1/1"]
[null,null,"7.2","1/2"]
[null,null,"7.3","1/3"]
[null,null,"7.4","1/4"]
[null,null,"7.5","1/5"]
[null,null,"7.6","1/6"]
[null,null,"7.7","1/7"]
[null,null,"7.8","1/8"]
[null,null,"7.9","1/9"]
[null,null,"7.10","1/10"]
[null,null,"7.11","1/11"]
[null,null,"7.12","1/12"]
[null,null,"7.13","2/2"]
[null,null,"7.14","2/3"]
[null,null,"7.15","2/4"]
[null,null,"7.16","2/5"]
[null,null,"7.17","2/6"]
[null,null,"7.18","2/7"]
[null,null,"7.19","2/8"]
[null,null,"7.20","2/9"]
[null,null,"7.21","2/10"]
[null,null,"7.22","2/11"]
[null,null,"7.23","2/12"]
[null,null,"7.24","3/3"]
[null,null,"7.25","3/4"]
[null,null,"7.26","3/5"]
[null,null,"7.27","3/6"]
[null,null,"7.28","3/7"]
[null,null,"7.29","3/8"]
[null,null,"7.30","3/9"]
[null,null,"7.31","3/10"]
[null,null,"7.32","3/11"]
[null,null,"7.33","3/12"]
[null,null,"7.34","4/4"]
[null,null,"7.35","4/5"]
[null,null,"7.36","4/6"]
[null,null,"7.37","4/7"]
[null,null,"7.38","4/8"]
[null,null,"7.39","4/9"]
[null,null,"7.40","4/10"]
[null,null,"7.41","4/11"]
[null,null,"7.42","4/12"]
[null,null,"7.43","5/5"]
[null,null,"7.44","5/6"]
[null,null,"7.45","5/7"]
[null,null,"7.46","5/8"]
[null,null,"7.47","5/9"]
[null,null,"7.48","5/10"]
[null,null,"7.49","5/11"]
[null,null,"7.50","5/12"]
[null,null,"7.51","6/6"]
[null,null,"7.52","6/7"]
[null,null,"7.53","6/8"]
[null,null,"7.54","6/9"]
[null,null,"7.55","6/10"]
[null,null,"7.56","6/11"]
[null,null,"7.57","6/12"]
[null,null,"7.58","7/7"]
[null,null,"7.59","7/8"]
[null,null,"7.60","7/9"]
[null,null,"7.61","7/10"]
[null,null,"7.62","7/11"]
[null,null,"7.63","7/12"]
[null,null,"7.64","8/8"]
[null,null,"7.65","8/9"]
[null,null,"7.66","8/10"]
[null,null,"7.67","8/11"]
[null,null,"7.68","8/12"]
[null,null,"7.69","9/9"]
[null,null,"7.70","9/10"]
[null,null,"7.71","9/11"]
[null,null,"7.72","9/12"]
[null,null,"7.73","10/10"]
[null,null,"7.74","10/11"]
[null,null,"7.75","10/12"]
[null,null,"7.76","11/11"]
[null,null,"7.77","11/12"]
[null,null,"7.78","12/12"]

{"sheet":"FORNECEDORES","index":30,"n_rows":38,"n_cols":4,"rows_kept":38,"cut":false,"hidden":false,"merged":[[0,0,1,12]]}
["CADASTRO - FORNECEDORES"]
[]
[]
[]
[]
[]
[null,null,"ITEM 8","FORNECEDORES"]
[]
[null,null,"8.1"]
[null,null,"8.2"]
[null,null,"8.3"]
[null,null,"8.4"]
[null,null,"8.5"]
[null,null,"8.6"]
[null,null,"8.7"]
[null,null,"8.8"]
[null,null,"8.9"]
[null,null,"8.10"]
[null,null,"8.11"]
[null,null,"8.12"]
[null,null,"8.13"]
[null,null,"8.14"]
[null,null,"8.15"]
[null,null,"8.16"]
[null,null,"8.17"]
[null,null,"8.18"]
[null,null,"8.19"]
[null,null,"8.20"]
[null,null,"8.21"]
[null,null,"8.22"]
[null,null,"8.23"]
[null,null,"8.24"]
[null,null,"8.25"]
[null,null,"8.26"]
[null,null,"8.27"]
[null,null,"8.28"]
[null,null,"8.29"]
[null,null,"8.30"]

{"sheet":"RELATORIOS","index":31,"n_rows":13,"n_cols":15,"rows_kept":13,"cut":false,"hidden":false,"merged":[[5,3,6,14],[0,0,1,15]]}
["RELATÓRIO DE CONTAS "]
[]
[]
[]
[]
[null,null,null,"RELATÓRIO FINACEIRO MENSAL"]
[]
[null,null,null,"JAN","FEV","MAR","ABR","MAI","JUN","JUL","AGO","SET","OUT","NOV","DEZ"]
[null,null,"CONTAS  A PAGAR",{"$f":"CPJAN!I7","v":0}]
[null,null,"CONTAS A RECEBER",{"$f":"CRJAN!I7","v":0}]
[null,null,"LUCRO  X PREJUÍZO",{"$f":"D10-D9","v":0}]
[]
[null,null,"ACUMULADO DO MÊS",{"$f":"CRJAN!K10+D11","v":10000}]

{"sheet":"RELRECEB","index":32,"n_rows":18,"n_cols":15,"rows_kept":18,"cut":false,"hidden":false,"merged":[[5,3,6,14],[0,0,1,16383]]}
["RELATÓRIO DE RECEBIMENTOS"]
[]
[]
[]
[]
[null,null,null,"RELATÓRIO DE RECEBIMENTOS MENSAL"]
[]
[null,null,null,"JAN","FEV","MAR","ABR","MAI","JUN","JUL","AGO","SET","OUT","NOV","DEZ"]
[null,null,"BOLETO",{"$f":"SUMIF(CRJAN!E12:E58,\"=BOLETO\",CRJAN!K12:K58)","v":0}]
[null,null,"CHEQUE",{"$f":"SUMIF(CRJAN!E12:E58,\"=CHEQUE\",CRJAN!K12:K58)","v":0}]
[null,null,"CRÉDITO",{"$f":"SUMIF(CRJAN!E12:E58,\"=C. CRÉDITO\",CRJAN!K12:K58)","v":0}]
[null,null,"DÉBITO",{"$f":"SUMIF(CRJAN!E12:E58,\"=C. DÉBITO\",CRJAN!K12:K58)","v":0}]
[null,null,"DINHEIRO",{"$f":"SUMIF(CRJAN!E12:E58,\"=DINHEIRO\",CRJAN!K12:K58)","v":0}]
[null,null,"OUTROS",{"$f":"SUMIF(CRJAN!E12:E58,\"=OUTROS\",CRJAN!K12:K58)","v":0}]
[null,null,"PIX BANCO DO BRASIL",{"$f":"SUMIF(CRJAN!E12:E58,\"=PIX BB\",CRJAN!K12:K58)","v":0}]
[null,null,"PIX ITAÚ",{"$f":"SUMIF(CRJAN!E12:E58,\"=PIX ITAÚ\",CRJAN!K12:K58)","v":0}]
[null,null,"TRANSF. BANCO DO BRASIL",{"$f":"SUMIF(CRJAN!E12:E58,\"=TRANSF. BB\",CRJAN!K12:K58)","v":0}]
[null,null,"TRANSF. ITAÚ",{"$f":"SUMIF(CRJAN!E12:E58,\"=TRANSF. ITAÚ\",CRJAN!K12:K58)","v":0}]

{"sheet":"RELOPERAC","index":33,"n_rows":20,"n_cols":15,"rows_kept":20,"cut":false,"hidden":false,"merged":[[5,3,6,14],[0,0,1,15]]}
["RELATÓRIO OPERACIONAL"]
[]
[]
[]
[]
[null,null,null,"RELATÓRIO DESPESA OPERACIONAL MENSAL"]
[]
[null,null,null,"JAN","FEV","MAR","ABR","MAI","JUN","JUL","AGO","SET","OUT","NOV","DEZ"]
[null,null,"ÁGUA",{"$f":"SUMIF(CPJAN!G12:G58,\"=ÁGUA\",CPJAN!K12:K58)","v":0}]
[null,null,"ALUGUEL",{"$f":"SUMIF(CPJAN!G12:G58,\"=ALUGUEL\",CPJAN!K12:K58)","v":0}]
[null,null,"CELULAR \"M\"",{"$f":"SUMIF(CPJAN!G12:G58,\"=CELULAR M\",CPJAN!K12:K58)","v":0}]
[null,null,"CELULAR\"A\"",{"$f":"SUMIF(CPJAN!G12:G58,\"=CELULAR A\",CPJAN!K12:K58)","v":0}]
[null,null,"CONTABILIDADE",{"$f":"SUMIF(CPJAN!G12:G58,\"=CONTABILIDADE\",CPJAN!K12:K58)","v":0}]
[null,null,"EMPRÉSTIMO",{"$f":"SUMIF(CPJAN!G12:G58,\"=EMPRÉSTIMO\",CPJAN!K12:K58)","v":0}]
[null,null,"FRETE",{"$f":"SUMIF(CPJAN!G12:G58,\"=FRETE\",CPJAN!K12:K58)","v":0}]
[null,null,"LUZ",{"$f":"SUMIF(CPJAN!G12:G58,\"=ENERGIA ELÉTRICA\",CPJAN!K12:K58)","v":0}]
[null,null,"MANUTENÇÃO",{"$f":"SUMIF(CPJAN!G12:G58,\"=MANUTENÇÃO\",CPJAN!K12:K58)","v":0}]
[null,null,"TELEFONE FIXO",{"$f":"SUMIF(CPJAN!G12:G58,\"=TELEFONE FIXO\",CPJAN!K12:K58)","v":0}]
[null,null,"TELEFONE NET",{"$f":"SUMIF(CPJAN!G12:G58,\"=TELEFONE NET\",CPJAN!K12:K58)","v":0}]
[null,null,"TV A CABO / INTERNET",{"$f":"SUMIF(CPJAN!G12:G58,\"=TV A CABO/INTERNET\",CPJAN!K12:K58)","v":0}]

{"sheet":"RELRET","index":34,"n_rows":12,"n_cols":15,"rows_kept":12,"cut":false,"hidden":false,"merged":[[5,3,6,14],[0,0,1,16383]]}
["RELATÓRIOS DE RETIRADAS"]
[]
[]
[]
[]
[null,null,null,"RELATÓRIO RETIRADAS MENSAL"]
[]
[null,null,null,"JAN","FEV","MAR","ABR","MAI","JUN","JUL","AGO","SET","OUT","NOV","DEZ"]
[null,null,"RETIRADAS A",{"$f":"SUMIF(CPJAN!G12:G58,\"=RETIRADA A\",CPJAN!K12:K58)","v":0}]
[null,null,"RETIRADAS M",{"$f":"SUMIF(CPJAN!G12:G58,\"=RETIRADA M\",CPJAN!K12:K58)","v":0}]
[]
[null,null,"RETIRADAS NO MÊS",{"$f":"D9+D10","v":0}]