{"text_format":"1","workbook":"xlsx","n_sheets":15,"sheets":["Planilha25","Planilha1","Planilha2","Planilha3","Planilha4","Planilha6","Planilha7","Planilha8","Planilha16","Planilha17","Planilha19","Planilha18","Planilha12","Planilha13","Planilha14"],"not_rendered":{"charts":6,"images":18,"macros":1,"external_links":0,"defined_names":13,"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":"Planilha25","index":0,"n_rows":59,"n_cols":38,"rows_kept":59,"cut":false,"hidden":false,"merged":[]}
["Planilhas de apoio",1,1,2021,2,null,1,2,3,4,5,6,7,8,9,10,11,12,{"$f":"Planilha1!L3-Planilha1!I3","v":-74},null,null,null,null,null,null,73,{"$f":"MATCH(Z1,Planilha7!A:A,0)","v":{"$error":"#N/A"}},190,{"$f":"MATCH(AB1,Planilha8!A:A,0)","v":{"$error":"#N/A"}},462,"462",462,{"$f":"AF1+(AE1-AD1)","v":462},"Vencido","Raissa",null,1,{"$f":"IF(AK1>1,INDIRECT(\"Planilha3!A\" & Planilha25!AK1),\"\")","v":""}]
["Planilha 12 = Apoio da 7",2,2,2022,{"$f":"VLOOKUP($E$1,$C$1:$D$10,2,0)","v":2022},null,{"$f":"(\"01/\"&G1&\"/\"&$E$2)*1","v":"2022-01-01"},{"$f":"(\"01/\"&H1&\"/\"&$E$2)*1","v":"2022-02-01"},"2022-03-01","2022-04-01","2022-05-01","2022-06-01","2022-07-01","2022-08-01","2022-09-01","2022-10-01","2022-11-01","2022-12-01",{"$f":"(\"01/\"&G1&\"/\"&$E$2+1)*1","v":"2023-01-01"},null,null,null,{"$f":"Planilha1!L3-Planilha1!I3","v":-74},null,null,"corresp do id fatura","linha do id fatura","corresp do id","linha do id","Valor anterior","Atual","Total Anterior","Agora","Status Ant","seleção listbox lan 1","Id fatura seleçao lan 1","linha combox ","id "]
["Planilha 13 = Apoio da 8",3,3,2023,{"$f":"TODAY()","v":"2025-03-21"},null,{"$f":"H2-1","v":"2022-01-31"},{"$f":"I2-1","v":"2022-02-28"},"2022-03-31","2022-04-30","2022-05-31","2022-06-30","2022-07-31","2022-08-31","2022-09-30","2022-10-31","2022-11-30","2022-12-31",{"$f":"(\"01/\"&G1&\"/\"&$E$2)*1","v":"2022-01-01"},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AF3+(AE1-AD1)","v":0},null,2]
["Planilha 14 = Apoio da 3",4,4,2024,4,{"$f":"YEAR(E3)","v":2025},"Jan","Fev","Mar","Abr","Mai","Jun","Jul","Ago","Set","Out","Nov","Dez",null,null,null,null,null,null,null,11,{"$f":"MATCH(Z4,Planilha7!A:A,0)","v":{"$error":"#N/A"}},{"$f":"INDIRECT(\"Planilha7!B\" & AA4)","v":{"$error":"#N/A"}},{"$f":"MATCH(AB4,Planilha3!A:A,0)-2","v":{"$error":"#N/A"}},0,0,"Total Pago Ant","Agora",null,"ver fatura?"]
["Planilha 4 = Contas",5,5,2025,{"$f":"(\"01/\"&E4&\"/\"&$E$2)*1","v":"2022-04-01"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"corresp id fatura 1","linha do id fatura","id aluno","linha cadastro do aluno","ver aluno","ver relatorio",null,null,null,1,{"$f":"IFERROR(MATCH(AI5,Planilha3!A:A,0),0)","v":0}]
[null,6,6,2026,{"$f":"(\"01/\"&E4+1&\"/\"&$F$4)*1-1","v":"2025-04-30"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,{"$f":"ROUNDUP((AC4/25),0)","v":{"$error":"#N/A"}},{"$f":"AC4-(25*(AC6-1))","v":{"$error":"#N/A"}},null,null,null,null,"id aluno selçao cadastro","linha no cadastro"]
[null,7,7,2027,null,null,null,null,null,null,null,"Cadastros","Clientes Cadastrados","Idade Total","Média","Total de Vencimentos","Valores Recebidos","Valores a Receber","Quantidade de Parcelas Pagas","Parcelas Pagas Com Atraso","Faturas Abertas",null,null,null,null,"listindex",null,null,"Pagina","linha aluno"]
[null,8,8,2028,null,"Janeiro",1,{"$f":"(\"01/\"&G8&\"/\"&$E$2)*1","v":"2022-01-01"},{"$f":"H9-1","v":"2022-01-31"},"Jan",null,{"$f":"COUNTIFS(Planilha3!B:B,\">=\"&$H8,Planilha3!B:B,\"<=\"&$I8)","v":0},{"$f":"COUNTA(Planilha3!A:A)-1","v":0},{"$f":"SUM(Planilha3!#REF!)","v":{"$error":"#REF!"}},{"$f":"IFERROR(N8/M8,0)","v":0},{"$f":"COUNTIFS(Planilha7!E:E,\">=\"&$H8,Planilha7!E:E,\"<=\"&$I8)","v":0},{"$f":"SUMIFS(Planilha8!E:E,Planilha8!D:D,\">=\"&$H8,Planilha8!D:D,\"<=\"&$I8)","v":0},{"$f":"SUMIFS(Planilha8!E:E,Planilha8!C:C,\">=\"&$H8,Planilha8!C:C,\"<=\"&$I8,Planilha8!F:F,\"<>Pago\",Planilha8!F:F,\"<>Pago com Atraso\")","v":0},{"$f":"COUNTIFS(Planilha8!D:D,\">=\"&$H8,Planilha8!D:D,\"<=\"&$I8)","v":0},{"$f":"COUNTIFS(Planilha8!D:D,\">=\"&$H8,Planilha8!D:D,\"<=\"&$I8,Planilha8!F:F,\"=Pago com Atraso\")","v":0},{"$f":"COUNTIFS(Planilha7!D:D,\">=\"&$H8,Planilha7!D:D,\"<=\"&$I8)","v":0}]
[{"$f":"YEAR(E5)","v":2022},9,9,2029,null,"Fervereiro",2,"2022-02-01","2022-02-28","Fev",null,{"$f":"COUNTIFS(Planilha3!B:B,\">=\"&$H9,Planilha3!B:B,\"<=\"&$I9)","v":0},null,null,null,{"$f":"COUNTIFS(Planilha7!E:E,\">=\"&$H9,Planilha7!E:E,\"<=\"&$I9)","v":0},{"$f":"SUMIFS(Planilha8!E:E,Planilha8!D:D,\">=\"&$H9,Planilha8!D:D,\"<=\"&$I9)","v":0},{"$f":"SUMIFS(Planilha8!E:E,Planilha8!C:C,\">=\"&$H9,Planilha8!C:C,\"<=\"&$I9,Planilha8!F:F,\"<>Pago\",Planilha8!F:F,\"<>Pago com Atraso\")","v":0},{"$f":"COUNTIFS(Planilha8!D:D,\">=\"&$H9,Planilha8!D:D,\"<=\"&$I9)","v":0},{"$f":"COUNTIFS(Planilha8!D:D,\">=\"&$H9,Planilha8!D:D,\"<=\"&$I9,Planilha8!F:F,\"=Pago com Atraso\")","v":0},{"$f":"COUNTIFS(Planilha7!D:D,\">=\"&$H9,Planilha7!D:D,\"<=\"&$I9)","v":0}]
[null,10,10,2030,null,"Março",3,"2022-03-01","2022-03-31","Mar",null,{"$f":"COUNTIFS(Planilha3!B:B,\">=\"&$H10,Planilha3!B:B,\"<=\"&$I10)","v":0},null,null,null,{"$f":"COUNTIFS(Planilha7!E:E,\">=\"&$H10,Planilha7!E:E,\"<=\"&$I10)","v":0},{"$f":"SUMIFS(Planilha8!E:E,Planilha8!D:D,\">=\"&$H10,Planilha8!D:D,\"<=\"&$I10)","v":0},{"$f":"SUMIFS(Planilha8!E:E,Planilha8!C:C,\">=\"&$H10,Planilha8!C:C,\"<=\"&$I10,Planilha8!F:F,\"<>Pago\",Planilha8!F:F,\"<>Pago com Atraso\")","v":0},{"$f":"COUNTIFS(Planilha8!D:D,\">=\"&$H10,Planilha8!D:D,\"<=\"&$I10)","v":0},{"$f":"COUNTIFS(Planilha8!D:D,\">=\"&$H10,Planilha8!D:D,\"<=\"&$I10,Planilha8!F:F,\"=Pago com Atraso\")","v":0},{"$f":"COUNTIFS(Planilha7!D:D,\">=\"&$H10,Planilha7!D:D,\"<=\"&$I10)","v":0}]
[null,11,null,null,null,"Abril",4,"2022-04-01","2022-04-30","Abr",null,{"$f":"COUNTIFS(Planilha3!B:B,\">=\"&$H11,Planilha3!B:B,\"<=\"&$I11)","v":0},null,null,null,{"$f":"COUNTIFS(Planilha7!E:E,\">=\"&$H11,Planilha7!E:E,\"<=\"&$I11)","v":0},{"$f":"SUMIFS(Planilha8!E:E,Planilha8!D:D,\">=\"&$H11,Planilha8!D:D,\"<=\"&$I11)","v":0},{"$f":"SUMIFS(Planilha8!E:E,Planilha8!C:C,\">=\"&$H11,Planilha8!C:C,\"<=\"&$I11,Planilha8!F:F,\"<>Pago\",Planilha8!F:F,\"<>Pago com Atraso\")","v":0},{"$f":"COUNTIFS(Planilha8!D:D,\">=\"&$H11,Planilha8!D:D,\"<=\"&$I11)","v":0},{"$f":"COUNTIFS(Planilha8!D:D,\">=\"&$H11,Planilha8!D:D,\"<=\"&$I11,Planilha8!F:F,\"=Pago com Atraso\")","v":0},{"$f":"COUNTIFS(Planilha7!D:D,\">=\"&$H11,Planilha7!D:D,\"<=\"&$I11)","v":0}]
["Sim",12,null,null,null,"Maio",5,"2022-05-01","2022-05-31","Mai",null,{"$f":"COUNTIFS(Planilha3!B:B,\">=\"&$H12,Planilha3!B:B,\"<=\"&$I12)","v":0},null,null,null,{"$f":"COUNTIFS(Planilha7!E:E,\">=\"&$H12,Planilha7!E:E,\"<=\"&$I12)","v":0},{"$f":"SUMIFS(Planilha8!E:E,Planilha8!D:D,\">=\"&$H12,Planilha8!D:D,\"<=\"&$I12)","v":0},{"$f":"SUMIFS(Planilha8!E:E,Planilha8!C:C,\">=\"&$H12,Planilha8!C:C,\"<=\"&$I12,Planilha8!F:F,\"<>Pago\",Planilha8!F:F,\"<>Pago com Atraso\")","v":0},{"$f":"COUNTIFS(Planilha8!D:D,\">=\"&$H12,Planilha8!D:D,\"<=\"&$I12)","v":0},{"$f":"COUNTIFS(Planilha8!D:D,\">=\"&$H12,Planilha8!D:D,\"<=\"&$I12,Planilha8!F:F,\"=Pago com Atraso\")","v":0},{"$f":"COUNTIFS(Planilha7!D:D,\">=\"&$H12,Planilha7!D:D,\"<=\"&$I12)","v":0}]
["Não",null,null,null,null,"Junho",6,"2022-06-01","2022-06-30","Jun",null,{"$f":"COUNTIFS(Planilha3!B:B,\">=\"&$H13,Planilha3!B:B,\"<=\"&$I13)","v":0},null,null,null,{"$f":"COUNTIFS(Planilha7!E:E,\">=\"&$H13,Planilha7!E:E,\"<=\"&$I13)","v":0},{"$f":"SUMIFS(Planilha8!E:E,Planilha8!D:D,\">=\"&$H13,Planilha8!D:D,\"<=\"&$I13)","v":0},{"$f":"SUMIFS(Planilha8!E:E,Planilha8!C:C,\">=\"&$H13,Planilha8!C:C,\"<=\"&$I13,Planilha8!F:F,\"<>Pago\",Planilha8!F:F,\"<>Pago com Atraso\")","v":0},{"$f":"COUNTIFS(Planilha8!D:D,\">=\"&$H13,Planilha8!D:D,\"<=\"&$I13)","v":0},{"$f":"COUNTIFS(Planilha8!D:D,\">=\"&$H13,Planilha8!D:D,\"<=\"&$I13,Planilha8!F:F,\"=Pago com Atraso\")","v":0},{"$f":"COUNTIFS(Planilha7!D:D,\">=\"&$H13,Planilha7!D:D,\"<=\"&$I13)","v":0}]
[1,null,null,null,null,"Julho",7,"2022-07-01","2022-07-31","Jul",null,{"$f":"COUNTIFS(Planilha3!B:B,\">=\"&$H14,Planilha3!B:B,\"<=\"&$I14)","v":0},null,null,null,{"$f":"COUNTIFS(Planilha7!E:E,\">=\"&$H14,Planilha7!E:E,\"<=\"&$I14)","v":0},{"$f":"SUMIFS(Planilha8!E:E,Planilha8!D:D,\">=\"&$H14,Planilha8!D:D,\"<=\"&$I14)","v":0},{"$f":"SUMIFS(Planilha8!E:E,Planilha8!C:C,\">=\"&$H14,Planilha8!C:C,\"<=\"&$I14,Planilha8!F:F,\"<>Pago\",Planilha8!F:F,\"<>Pago com Atraso\")","v":0},{"$f":"COUNTIFS(Planilha8!D:D,\">=\"&$H14,Planilha8!D:D,\"<=\"&$I14)","v":0},{"$f":"COUNTIFS(Planilha8!D:D,\">=\"&$H14,Planilha8!D:D,\"<=\"&$I14,Planilha8!F:F,\"=Pago com Atraso\")","v":0},{"$f":"COUNTIFS(Planilha7!D:D,\">=\"&$H14,Planilha7!D:D,\"<=\"&$I14)","v":0}]
[null,null,null,null,null,"Agosto",8,"2022-08-01","2022-08-31","Ago",null,{"$f":"COUNTIFS(Planilha3!B:B,\">=\"&$H15,Planilha3!B:B,\"<=\"&$I15)","v":0},null,null,null,{"$f":"COUNTIFS(Planilha7!E:E,\">=\"&$H15,Planilha7!E:E,\"<=\"&$I15)","v":0},{"$f":"SUMIFS(Planilha8!E:E,Planilha8!D:D,\">=\"&$H15,Planilha8!D:D,\"<=\"&$I15)","v":0},{"$f":"SUMIFS(Planilha8!E:E,Planilha8!C:C,\">=\"&$H15,Planilha8!C:C,\"<=\"&$I15,Planilha8!F:F,\"<>Pago\",Planilha8!F:F,\"<>Pago com Atraso\")","v":0},{"$f":"COUNTIFS(Planilha8!D:D,\">=\"&$H15,Planilha8!D:D,\"<=\"&$I15)","v":0},{"$f":"COUNTIFS(Planilha8!D:D,\">=\"&$H15,Planilha8!D:D,\"<=\"&$I15,Planilha8!F:F,\"=Pago com Atraso\")","v":0},{"$f":"COUNTIFS(Planilha7!D:D,\">=\"&$H15,Planilha7!D:D,\"<=\"&$I15)","v":0}]
[null,null,null,null,null,"Setembro",9,"2022-09-01","2022-09-30","Set",null,{"$f":"COUNTIFS(Planilha3!B:B,\">=\"&$H16,Planilha3!B:B,\"<=\"&$I16)","v":0},null,null,null,{"$f":"COUNTIFS(Planilha7!E:E,\">=\"&$H16,Planilha7!E:E,\"<=\"&$I16)","v":0},{"$f":"SUMIFS(Planilha8!E:E,Planilha8!D:D,\">=\"&$H16,Planilha8!D:D,\"<=\"&$I16)","v":0},{"$f":"SUMIFS(Planilha8!E:E,Planilha8!C:C,\">=\"&$H16,Planilha8!C:C,\"<=\"&$I16,Planilha8!F:F,\"<>Pago\",Planilha8!F:F,\"<>Pago com Atraso\")","v":0},{"$f":"COUNTIFS(Planilha8!D:D,\">=\"&$H16,Planilha8!D:D,\"<=\"&$I16)","v":0},{"$f":"COUNTIFS(Planilha8!D:D,\">=\"&$H16,Planilha8!D:D,\"<=\"&$I16,Planilha8!F:F,\"=Pago com Atraso\")","v":0},{"$f":"COUNTIFS(Planilha7!D:D,\">=\"&$H16,Planilha7!D:D,\"<=\"&$I16)","v":0}]
[null,null,null,null,null,"Outubro",10,"2022-10-01","2022-10-31","Out",null,{"$f":"COUNTIFS(Planilha3!B:B,\">=\"&$H17,Planilha3!B:B,\"<=\"&$I17)","v":0},null,null,null,{"$f":"COUNTIFS(Planilha7!E:E,\">=\"&$H17,Planilha7!E:E,\"<=\"&$I17)","v":0},{"$f":"SUMIFS(Planilha8!E:E,Planilha8!D:D,\">=\"&$H17,Planilha8!D:D,\"<=\"&$I17)","v":0},{"$f":"SUMIFS(Planilha8!E:E,Planilha8!C:C,\">=\"&$H17,Planilha8!C:C,\"<=\"&$I17,Planilha8!F:F,\"<>Pago\",Planilha8!F:F,\"<>Pago com Atraso\")","v":0},{"$f":"COUNTIFS(Planilha8!D:D,\">=\"&$H17,Planilha8!D:D,\"<=\"&$I17)","v":0},{"$f":"COUNTIFS(Planilha8!D:D,\">=\"&$H17,Planilha8!D:D,\"<=\"&$I17,Planilha8!F:F,\"=Pago com Atraso\")","v":0},{"$f":"COUNTIFS(Planilha7!D:D,\">=\"&$H17,Planilha7!D:D,\"<=\"&$I17)","v":0}]
[null,null,null,null,null,"Novembro",11,"2022-11-01","2022-11-30","Nov",null,{"$f":"COUNTIFS(Planilha3!B:B,\">=\"&$H18,Planilha3!B:B,\"<=\"&$I18)","v":0},null,null,null,{"$f":"COUNTIFS(Planilha7!E:E,\">=\"&$H18,Planilha7!E:E,\"<=\"&$I18)","v":0},{"$f":"SUMIFS(Planilha8!E:E,Planilha8!D:D,\">=\"&$H18,Planilha8!D:D,\"<=\"&$I18)","v":0},{"$f":"SUMIFS(Planilha8!E:E,Planilha8!C:C,\">=\"&$H18,Planilha8!C:C,\"<=\"&$I18,Planilha8!F:F,\"<>Pago\",Planilha8!F:F,\"<>Pago com Atraso\")","v":0},{"$f":"COUNTIFS(Planilha8!D:D,\">=\"&$H18,Planilha8!D:D,\"<=\"&$I18)","v":0},{"$f":"COUNTIFS(Planilha8!D:D,\">=\"&$H18,Planilha8!D:D,\"<=\"&$I18,Planilha8!F:F,\"=Pago com Atraso\")","v":0},{"$f":"COUNTIFS(Planilha7!D:D,\">=\"&$H18,Planilha7!D:D,\"<=\"&$I18)","v":0}]
[null,null,{"$f":"LOOKUP(E4,G8:G19,F8:F19)","v":"Abril"},null,null,"Dezembro",12,"2022-12-01","2022-12-31","Dez",null,{"$f":"COUNTIFS(Planilha3!B:B,\">=\"&$H19,Planilha3!B:B,\"<=\"&$I19)","v":0},null,null,null,{"$f":"COUNTIFS(Planilha7!E:E,\">=\"&$H19,Planilha7!E:E,\"<=\"&$I19)","v":0},{"$f":"SUMIFS(Planilha8!E:E,Planilha8!D:D,\">=\"&$H19,Planilha8!D:D,\"<=\"&$I19)","v":0},{"$f":"SUMIFS(Planilha8!E:E,Planilha8!C:C,\">=\"&$H19,Planilha8!C:C,\"<=\"&$I19,Planilha8!F:F,\"<>Pago\",Planilha8!F:F,\"<>Pago com Atraso\")","v":0},{"$f":"COUNTIFS(Planilha8!D:D,\">=\"&$H19,Planilha8!D:D,\"<=\"&$I19)","v":0},{"$f":"COUNTIFS(Planilha8!D:D,\">=\"&$H19,Planilha8!D:D,\"<=\"&$I19,Planilha8!F:F,\"=Pago com Atraso\")","v":0},{"$f":"COUNTIFS(Planilha7!D:D,\">=\"&$H19,Planilha7!D:D,\"<=\"&$I19)","v":0}]
[null,null,null,null,null,null,null,{"$f":"S2","v":"2023-01-01"}]
[null,null,null,null,null,null,null,"Inicio","Final",null,null,"Cadastros","Clientes Cadastrados","Idade Total","Média","Total de Vencimentos","Valores Recebidos","Valores a Receber","Quantidade de Parcelas Pagas","Parcelas Pagas Com Atraso"]
["Grafico A Receber X Recebido",null,null,null,null,null,null,{"$f":"(\"01/\"&E4&\"/\"&$E$2)*1","v":"2022-04-01"},{"$f":"(\"01/\"&E4+1&\"/\"&$E$2)*1-1","v":"2022-04-30"},null,"Mês Atual",{"$f":"COUNTIFS(Planilha3!B:B,\">=\"&$H22,Planilha3!B:B,\"<=\"&$I22)","v":0},null,null,null,{"$f":"COUNTIFS(Planilha7!E:E,\">=\"&$H22,Planilha7!E:E,\"<=\"&$I22)","v":0},{"$f":"SUMIFS(Planilha8!E:E,Planilha8!D:D,\">=\"&$H22,Planilha8!D:D,\"<=\"&$I22)","v":0},{"$f":"SUMIFS(Planilha8!E:E,Planilha8!C:C,\">=\"&$H22,Planilha8!C:C,\"<=\"&$I22,Planilha8!F:F,\"<>Pago\",Planilha8!F:F,\"<>Pago com Atraso\")","v":0},{"$f":"COUNTIFS(Planilha8!D:D,\">=\"&$H22,Planilha8!D:D,\"<=\"&$I22)","v":0},{"$f":"COUNTIFS(Planilha8!D:D,\">=\"&$H22,Planilha8!D:D,\"<=\"&$I22,Planilha8!F:F,\"=Pago com Atraso\")","v":0},{"$f":"COUNTIFS(Planilha7!D:D,\">=\"&$H22,Planilha7!D:D,\"<=\"&$I22)","v":0}]
[null,"A Receber","Recebido",null,null,null,null,null,{"$f":"MONTH(I22)","v":4},null,"Total do Ano",{"$f":"SUM(L8:L19)","v":0},null,null,null,{"$f":"SUM(P8:P19)","v":0},0,0,0,0,0]
["Janeiro",{"$f":"R8","v":0},{"$f":"Q8","v":0}]
["Fervereiro",{"$f":"R9","v":0},{"$f":"Q9","v":0}]
["Março",0,0]
["Abril",0,0]
["Maio",0,0,null,null,null,null,{"$f":"YEAR(K29)","v":2022},null,null,"Do ultimo mês",{"$f":"COUNTIFS(Planilha3!B:B,\">=\"&$J29,Planilha3!B:B,\"<=\"&$K29)","v":0},null,null,null,{"$f":"COUNTIFS(Planilha7!E:E,\">=\"&$J29,Planilha7!E:E,\"<=\"&$K29)","v":0},{"$f":"SUMIFS(Planilha8!E:E,Planilha8!D:D,\">=\"&$J29,Planilha8!D:D,\"<=\"&$K29)","v":0},{"$f":"SUMIFS(Planilha8!E:E,Planilha8!C:C,\">=\"&$J29,Planilha8!C:C,\"<=\"&$K29,Planilha8!F:F,\"<>Pago\",Planilha8!F:F,\"<>Pago com Atraso\")","v":0},{"$f":"COUNTIFS(Planilha8!D:D,\">=\"&$J29,Planilha8!D:D,\"<=\"&$K29)","v":0},{"$f":"COUNTIFS(Planilha8!D:D,\">=\"&$J29,Planilha8!D:D,\"<=\"&$K29,Planilha8!F:F,\"=Pago com Atraso\")","v":0}]
["Junho",0,0,null,null,null,null,{"$f":"LOOKUP(I29,G8:G19,F8:F19)","v":"Março"},{"$f":"MONTH(K29)","v":3},{"$f":"(\"01/\"&E4-1&\"/\"&$E$2)*1-1","v":"2022-02-28"},{"$f":"(\"01/\"&E4&\"/\"&$E$2)*1-1","v":"2022-03-31"}]
["Julho",0,0,null,null,null,null,null,null,null,null,"Cadastros","Clientes Cadastrados","Idade Total","Média","Total de Vencimentos","Valores Recebidos","Valores a Receber","Quantidade de Parcelas Pagas","Parcelas Pagas Com Atraso"]
["Agosto",0,0,null,null,null,null,null,null,null,"Aumeto",{"$f":"IF(L22=0,IF(L28=0,0,-1),IF(L28=0,1,((L22/L28)-1)))","v":0},null,null,null,{"$f":"IF(P22=0,IF(P28=0,0,-1),IF(P28=0,1,((P22/P28)-1)))","v":0},{"$f":"IF(Q22=0,IF(Q28=0,0,-1),IF(Q28=0,1,((Q22/Q28)-1)))","v":0},0,0,0,0]
["Setembro",0,0,null,null,null,null,null,null,null,null,{"$f":"IF(L$31>0,\"↑\",\"↓\")&\" \"&TEXT(L$31,\"0,00%\")","v":"↓ 0,00%"},null,null,null,{"$f":"IF(P$31>0,\"↑\",\"↓\")&\" \"&TEXT(P$31,\"0,00%\")","v":"↓ 0,00%"},"↓ 0,00%","↓ 0,00%","↓ 0,00%","↓ 0,00%","↓ 0,00%"]
["Outubro",0,0]
["Novembro",0,0]
["Dezembro",0,0]
[null,null,null,null,null,null,null,null,null,null,"Ano Anterior"]
[null,null,null,null,null,null,null,null,null,null,null,"Cadastros",null,null,null,"Total de Vencimentos","Valores Recebidos","Valores a Receber","Quantidade de Parcelas Pagas","Parcelas Pagas Com Atraso","Faturas Abertas"]
["Ano Anterior","Ano Atual (Recebido)","Ano Atual (A Receber)",null,null,"Janeiro",1,{"$f":"(\"01/\"&G38&\"/\"&$E$2 -1)*1","v":"2021-01-01"},{"$f":"H39-1","v":"2021-01-31"},"Jan",null,{"$f":"COUNTIFS(Planilha3!B:B,\">=\"&$H38,Planilha3!B:B,\"<=\"&$I38)","v":0},null,null,null,{"$f":"COUNTIFS(Planilha7!E:E,\">=\"&$H38,Planilha7!E:E,\"<=\"&$I38)","v":0},{"$f":"SUMIFS(Planilha8!E:E,Planilha8!D:D,\">=\"&$H38,Planilha8!D:D,\"<=\"&$I38)","v":0},{"$f":"SUMIFS(Planilha8!E:E,Planilha8!C:C,\">=\"&$H38,Planilha8!C:C,\"<=\"&$I38,Planilha8!F:F,\"<>Pago\",Planilha8!F:F,\"<>Pago com Atraso\")","v":0},{"$f":"COUNTIFS(Planilha8!D:D,\">=\"&$H38,Planilha8!D:D,\"<=\"&$I38)","v":0},{"$f":"COUNTIFS(Planilha8!D:D,\">=\"&$H38,Planilha8!D:D,\"<=\"&$I38,Planilha8!F:F,\"=Pago com Atraso\")","v":0},{"$f":"COUNTIFS(Planilha7!D:D,\">=\"&$H38,Planilha7!D:D,\"<=\"&$I38)","v":0}]
[{"$f":"Q53","v":0},{"$f":"Q23","v":0},{"$f":"R23","v":0},null,null,"Fervereiro",2,{"$f":"(\"01/\"&G39&\"/\"&$E$2 -1)*1","v":"2021-02-01"},{"$f":"H40-1","v":"2021-02-28"},"Fev",null,{"$f":"COUNTIFS(Planilha3!B:B,\">=\"&$H39,Planilha3!B:B,\"<=\"&$I39)","v":0},null,null,null,{"$f":"COUNTIFS(Planilha7!E:E,\">=\"&$H39,Planilha7!E:E,\"<=\"&$I39)","v":0},{"$f":"SUMIFS(Planilha8!E:E,Planilha8!D:D,\">=\"&$H39,Planilha8!D:D,\"<=\"&$I39)","v":0},{"$f":"SUMIFS(Planilha8!E:E,Planilha8!C:C,\">=\"&$H39,Planilha8!C:C,\"<=\"&$I39,Planilha8!F:F,\"<>Pago\",Planilha8!F:F,\"<>Pago com Atraso\")","v":0},{"$f":"COUNTIFS(Planilha8!D:D,\">=\"&$H39,Planilha8!D:D,\"<=\"&$I39)","v":0},{"$f":"COUNTIFS(Planilha8!D:D,\">=\"&$H39,Planilha8!D:D,\"<=\"&$I39,Planilha8!F:F,\"=Pago com Atraso\")","v":0},{"$f":"COUNTIFS(Planilha7!D:D,\">=\"&$H39,Planilha7!D:D,\"<=\"&$I39)","v":0}]
[null,"Ano Anterior","Ano Atual",null,null,"Março",3,"2021-03-01","2021-03-31","Mar",null,{"$f":"COUNTIFS(Planilha3!B:B,\">=\"&$H40,Planilha3!B:B,\"<=\"&$I40)","v":0},null,null,null,{"$f":"COUNTIFS(Planilha7!E:E,\">=\"&$H40,Planilha7!E:E,\"<=\"&$I40)","v":0},{"$f":"SUMIFS(Planilha8!E:E,Planilha8!D:D,\">=\"&$H40,Planilha8!D:D,\"<=\"&$I40)","v":0},{"$f":"SUMIFS(Planilha8!E:E,Planilha8!C:C,\">=\"&$H40,Planilha8!C:C,\"<=\"&$I40,Planilha8!F:F,\"<>Pago\",Planilha8!F:F,\"<>Pago com Atraso\")","v":0},{"$f":"COUNTIFS(Planilha8!D:D,\">=\"&$H40,Planilha8!D:D,\"<=\"&$I40)","v":0},{"$f":"COUNTIFS(Planilha8!D:D,\">=\"&$H40,Planilha8!D:D,\"<=\"&$I40,Planilha8!F:F,\"=Pago com Atraso\")","v":0},{"$f":"COUNTIFS(Planilha7!D:D,\">=\"&$H40,Planilha7!D:D,\"<=\"&$I40)","v":0}]
["Jan",{"$f":"Q38","v":0},{"$f":"Q8","v":0},null,null,"Abril",4,"2021-04-01","2021-04-30","Abr",null,{"$f":"COUNTIFS(Planilha3!B:B,\">=\"&$H41,Planilha3!B:B,\"<=\"&$I41)","v":0},null,null,null,{"$f":"COUNTIFS(Planilha7!E:E,\">=\"&$H41,Planilha7!E:E,\"<=\"&$I41)","v":0},{"$f":"SUMIFS(Planilha8!E:E,Planilha8!D:D,\">=\"&$H41,Planilha8!D:D,\"<=\"&$I41)","v":0},{"$f":"SUMIFS(Planilha8!E:E,Planilha8!C:C,\">=\"&$H41,Planilha8!C:C,\"<=\"&$I41,Planilha8!F:F,\"<>Pago\",Planilha8!F:F,\"<>Pago com Atraso\")","v":0},{"$f":"COUNTIFS(Planilha8!D:D,\">=\"&$H41,Planilha8!D:D,\"<=\"&$I41)","v":0},{"$f":"COUNTIFS(Planilha8!D:D,\">=\"&$H41,Planilha8!D:D,\"<=\"&$I41,Planilha8!F:F,\"=Pago com Atraso\")","v":0},{"$f":"COUNTIFS(Planilha7!D:D,\">=\"&$H41,Planilha7!D:D,\"<=\"&$I41)","v":0}]
["Fev",{"$f":"Q39","v":0},{"$f":"Q9","v":0},null,null,"Maio",5,"2021-05-01","2021-05-31","Mai",null,{"$f":"COUNTIFS(Planilha3!B:B,\">=\"&$H42,Planilha3!B:B,\"<=\"&$I42)","v":0},null,null,null,{"$f":"COUNTIFS(Planilha7!E:E,\">=\"&$H42,Planilha7!E:E,\"<=\"&$I42)","v":0},{"$f":"SUMIFS(Planilha8!E:E,Planilha8!D:D,\">=\"&$H42,Planilha8!D:D,\"<=\"&$I42)","v":0},{"$f":"SUMIFS(Planilha8!E:E,Planilha8!C:C,\">=\"&$H42,Planilha8!C:C,\"<=\"&$I42,Planilha8!F:F,\"<>Pago\",Planilha8!F:F,\"<>Pago com Atraso\")","v":0},{"$f":"COUNTIFS(Planilha8!D:D,\">=\"&$H42,Planilha8!D:D,\"<=\"&$I42)","v":0},{"$f":"COUNTIFS(Planilha8!D:D,\">=\"&$H42,Planilha8!D:D,\"<=\"&$I42,Planilha8!F:F,\"=Pago com Atraso\")","v":0},{"$f":"COUNTIFS(Planilha7!D:D,\">=\"&$H42,Planilha7!D:D,\"<=\"&$I42)","v":0}]
["Mar",0,0,null,null,"Junho",6,"2021-06-01","2021-06-30","Jun",null,{"$f":"COUNTIFS(Planilha3!B:B,\">=\"&$H43,Planilha3!B:B,\"<=\"&$I43)","v":0},null,null,null,{"$f":"COUNTIFS(Planilha7!E:E,\">=\"&$H43,Planilha7!E:E,\"<=\"&$I43)","v":0},{"$f":"SUMIFS(Planilha8!E:E,Planilha8!D:D,\">=\"&$H43,Planilha8!D:D,\"<=\"&$I43)","v":0},{"$f":"SUMIFS(Planilha8!E:E,Planilha8!C:C,\">=\"&$H43,Planilha8!C:C,\"<=\"&$I43,Planilha8!F:F,\"<>Pago\",Planilha8!F:F,\"<>Pago com Atraso\")","v":0},{"$f":"COUNTIFS(Planilha8!D:D,\">=\"&$H43,Planilha8!D:D,\"<=\"&$I43)","v":0},{"$f":"COUNTIFS(Planilha8!D:D,\">=\"&$H43,Planilha8!D:D,\"<=\"&$I43,Planilha8!F:F,\"=Pago com Atraso\")","v":0},{"$f":"COUNTIFS(Planilha7!D:D,\">=\"&$H43,Planilha7!D:D,\"<=\"&$I43)","v":0}]
["Abr",0,0,null,null,"Julho",7,"2021-07-01","2021-07-31","Jul",null,{"$f":"COUNTIFS(Planilha3!B:B,\">=\"&$H44,Planilha3!B:B,\"<=\"&$I44)","v":0},null,null,null,{"$f":"COUNTIFS(Planilha7!E:E,\">=\"&$H44,Planilha7!E:E,\"<=\"&$I44)","v":0},{"$f":"SUMIFS(Planilha8!E:E,Planilha8!D:D,\">=\"&$H44,Planilha8!D:D,\"<=\"&$I44)","v":0},{"$f":"SUMIFS(Planilha8!E:E,Planilha8!C:C,\">=\"&$H44,Planilha8!C:C,\"<=\"&$I44,Planilha8!F:F,\"<>Pago\",Planilha8!F:F,\"<>Pago com Atraso\")","v":0},{"$f":"COUNTIFS(Planilha8!D:D,\">=\"&$H44,Planilha8!D:D,\"<=\"&$I44)","v":0},{"$f":"COUNTIFS(Planilha8!D:D,\">=\"&$H44,Planilha8!D:D,\"<=\"&$I44,Planilha8!F:F,\"=Pago com Atraso\")","v":0},{"$f":"COUNTIFS(Planilha7!D:D,\">=\"&$H44,Planilha7!D:D,\"<=\"&$I44)","v":0}]
["Mai",0,0,null,null,"Agosto",8,"2021-08-01","2021-08-31","Ago",null,{"$f":"COUNTIFS(Planilha3!B:B,\">=\"&$H45,Planilha3!B:B,\"<=\"&$I45)","v":0},null,null,null,{"$f":"COUNTIFS(Planilha7!E:E,\">=\"&$H45,Planilha7!E:E,\"<=\"&$I45)","v":0},{"$f":"SUMIFS(Planilha8!E:E,Planilha8!D:D,\">=\"&$H45,Planilha8!D:D,\"<=\"&$I45)","v":0},{"$f":"SUMIFS(Planilha8!E:E,Planilha8!C:C,\">=\"&$H45,Planilha8!C:C,\"<=\"&$I45,Planilha8!F:F,\"<>Pago\",Planilha8!F:F,\"<>Pago com Atraso\")","v":0},{"$f":"COUNTIFS(Planilha8!D:D,\">=\"&$H45,Planilha8!D:D,\"<=\"&$I45)","v":0},{"$f":"COUNTIFS(Planilha8!D:D,\">=\"&$H45,Planilha8!D:D,\"<=\"&$I45,Planilha8!F:F,\"=Pago com Atraso\")","v":0},{"$f":"COUNTIFS(Planilha7!D:D,\">=\"&$H45,Planilha7!D:D,\"<=\"&$I45)","v":0}]
["Jun",0,0,null,null,"Setembro",9,"2021-09-01","2021-09-30","Set",null,{"$f":"COUNTIFS(Planilha3!B:B,\">=\"&$H46,Planilha3!B:B,\"<=\"&$I46)","v":0},null,null,null,{"$f":"COUNTIFS(Planilha7!E:E,\">=\"&$H46,Planilha7!E:E,\"<=\"&$I46)","v":0},{"$f":"SUMIFS(Planilha8!E:E,Planilha8!D:D,\">=\"&$H46,Planilha8!D:D,\"<=\"&$I46)","v":0},{"$f":"SUMIFS(Planilha8!E:E,Planilha8!C:C,\">=\"&$H46,Planilha8!C:C,\"<=\"&$I46,Planilha8!F:F,\"<>Pago\",Planilha8!F:F,\"<>Pago com Atraso\")","v":0},{"$f":"COUNTIFS(Planilha8!D:D,\">=\"&$H46,Planilha8!D:D,\"<=\"&$I46)","v":0},{"$f":"COUNTIFS(Planilha8!D:D,\">=\"&$H46,Planilha8!D:D,\"<=\"&$I46,Planilha8!F:F,\"=Pago com Atraso\")","v":0},{"$f":"COUNTIFS(Planilha7!D:D,\">=\"&$H46,Planilha7!D:D,\"<=\"&$I46)","v":0}]
["Jul",0,0,null,null,"Outubro",10,"2021-10-01","2021-10-31","Out",null,{"$f":"COUNTIFS(Planilha3!B:B,\">=\"&$H47,Planilha3!B:B,\"<=\"&$I47)","v":0},null,null,null,{"$f":"COUNTIFS(Planilha7!E:E,\">=\"&$H47,Planilha7!E:E,\"<=\"&$I47)","v":0},{"$f":"SUMIFS(Planilha8!E:E,Planilha8!D:D,\">=\"&$H47,Planilha8!D:D,\"<=\"&$I47)","v":0},{"$f":"SUMIFS(Planilha8!E:E,Planilha8!C:C,\">=\"&$H47,Planilha8!C:C,\"<=\"&$I47,Planilha8!F:F,\"<>Pago\",Planilha8!F:F,\"<>Pago com Atraso\")","v":0},{"$f":"COUNTIFS(Planilha8!D:D,\">=\"&$H47,Planilha8!D:D,\"<=\"&$I47)","v":0},{"$f":"COUNTIFS(Planilha8!D:D,\">=\"&$H47,Planilha8!D:D,\"<=\"&$I47,Planilha8!F:F,\"=Pago com Atraso\")","v":0},{"$f":"COUNTIFS(Planilha7!D:D,\">=\"&$H47,Planilha7!D:D,\"<=\"&$I47)","v":0}]
["Ago",0,0,null,null,"Novembro",11,"2021-11-01","2021-11-30","Nov",null,{"$f":"COUNTIFS(Planilha3!B:B,\">=\"&$H48,Planilha3!B:B,\"<=\"&$I48)","v":0},null,null,null,{"$f":"COUNTIFS(Planilha7!E:E,\">=\"&$H48,Planilha7!E:E,\"<=\"&$I48)","v":0},{"$f":"SUMIFS(Planilha8!E:E,Planilha8!D:D,\">=\"&$H48,Planilha8!D:D,\"<=\"&$I48)","v":0},{"$f":"SUMIFS(Planilha8!E:E,Planilha8!C:C,\">=\"&$H48,Planilha8!C:C,\"<=\"&$I48,Planilha8!F:F,\"<>Pago\",Planilha8!F:F,\"<>Pago com Atraso\")","v":0},{"$f":"COUNTIFS(Planilha8!D:D,\">=\"&$H48,Planilha8!D:D,\"<=\"&$I48)","v":0},{"$f":"COUNTIFS(Planilha8!D:D,\">=\"&$H48,Planilha8!D:D,\"<=\"&$I48,Planilha8!F:F,\"=Pago com Atraso\")","v":0},{"$f":"COUNTIFS(Planilha7!D:D,\">=\"&$H48,Planilha7!D:D,\"<=\"&$I48)","v":0}]
["Set",0,0,null,null,"Dezembro",12,"2021-12-01",{"$f":"H50-1","v":"2021-12-31"},"Dez",null,{"$f":"COUNTIFS(Planilha3!B:B,\">=\"&$H49,Planilha3!B:B,\"<=\"&$I49)","v":0},null,null,null,{"$f":"COUNTIFS(Planilha7!E:E,\">=\"&$H49,Planilha7!E:E,\"<=\"&$I49)","v":0},{"$f":"SUMIFS(Planilha8!E:E,Planilha8!D:D,\">=\"&$H49,Planilha8!D:D,\"<=\"&$I49)","v":0},{"$f":"SUMIFS(Planilha8!E:E,Planilha8!C:C,\">=\"&$H49,Planilha8!C:C,\"<=\"&$I49,Planilha8!F:F,\"<>Pago\",Planilha8!F:F,\"<>Pago com Atraso\")","v":0},{"$f":"COUNTIFS(Planilha8!D:D,\">=\"&$H49,Planilha8!D:D,\"<=\"&$I49)","v":0},{"$f":"COUNTIFS(Planilha8!D:D,\">=\"&$H49,Planilha8!D:D,\"<=\"&$I49,Planilha8!F:F,\"=Pago com Atraso\")","v":0},{"$f":"COUNTIFS(Planilha7!D:D,\">=\"&$H49,Planilha7!D:D,\"<=\"&$I49)","v":0}]
["Out",0,0,null,null,null,null,{"$f":"S3","v":"2022-01-01"}]
["Nov",0,0,null,null,null,null,"Inicio","Final",null,null,"Cadastros","Clientes Cadastrados","Idade Total","Média","Total de Vencimentos","Valores Recebidos","Valores a Receber","Quantidade de Parcelas Pagas","Parcelas Pagas Com Atraso","Faturas Abertas"]
["Dez",0,0,null,null,null,null,{"$f":"H38","v":"2021-01-01"},{"$f":"(\"01/\"&E30+1&\"/\"&$E$2)*1-1","v":"2021-12-31"},null,"Mês igual ano passado",{"$f":"VLOOKUP($I$23,$G$38:$AA$49,6,0)","v":0},null,null,null,{"$f":"VLOOKUP($I$23,$G$38:$AA$49,6,0)","v":0},0,0,0,0,{"$f":"COUNTIFS(Planilha7!D:D,\">=\"&$H52,Planilha7!D:D,\"<=\"&$I52)","v":0}]
[null,null,null,null,null,null,null,null,null,null,"Total do Ano",{"$f":"SUM(L38:L49)","v":0},null,null,null,{"$f":"SUM(P38:P49)","v":0},0,0,0,0,0]
[null,null,null,null,null,null,null,{"$f":"YEAR(I52)","v":2021}]
[null,null,null,null,null,null,null,null,null,null,null,"Lotes Comprados"]
[null,null,null,null,null,1,null,null,null,null,"Aumeto do Mesmo Mês",{"$f":"IF(L$22=0,IF(L$52=0,0,-1),(L$22-L$52)/L$22)","v":0},null,null,null,{"$f":"IF(P$22=0,IF(P$52=0,0,-1),(P$22-P$52)/P$22)","v":0},0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(L$56>0,\"↑\",\"↓\")&\" \"&TEXT(L$56,\"0,00%\")","v":"↓ 0,00%"},null,null,null,{"$f":"IF(P$56>0,\"↑\",\"↓\")&\" \"&TEXT(P$56,\"0,00%\")","v":"↓ 0,00%"},"↓ 0,00%","↓ 0,00%","↓ 0,00%","↓ 0,00%","↓ 0,00%"]
[null,null,null,null,null,null,null,null,null,null,"Aumento do Ano",{"$f":"IF(L$23=0,IF(L$53=0,0,-1),(L$23-L$53)/L$23)","v":0},null,null,null,{"$f":"IF(P$23=0,IF(P$53=0,0,-1),(P$23-P$53)/P$23)","v":0},0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(L$58>0,\"↑\",\"↓\")&\" \"&TEXT(L$58,\"0,00%\")","v":"↓ 0,00%"},null,null,null,{"$f":"IF(P$58>0,\"↑\",\"↓\")&\" \"&TEXT(P$58,\"0,00%\")","v":"↓ 0,00%"},"↓ 0,00%","↓ 0,00%","↓ 0,00%","↓ 0,00%","↓ 0,00%"]

{"sheet":"Planilha1","index":1,"n_rows":24,"n_cols":27,"rows_kept":24,"cut":false,"hidden":false,"merged":[[0,0,4,3],[4,13,4,15]]}
["Sua Logo Aqui",null,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":"\"V\"&X5","v":"V1"}]
[]
[null,null,null,null,null,"2024-10-08",null,null,{"$f":"TODAY()-F3","v":164},null,null,{"$f":"80+Y5","v":90}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Atualização Automática:",null,null,null,null,null,null,null,null,null,1,10]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]

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

{"sheet":"Planilha3","index":3,"n_rows":1,"n_cols":27,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["ID","DATA","NOME DO MEMBRO","EMAIL","TELEFONE","CPF/CNPJ","DATA DE NASCIMENTO","IDADE","SEXO","ENDEREÇO","CIDADE","RESPONSÁVEL","REGISTRO ACADÊMICO","TURMA","OBSERVAÇÃO","PAÍS","ALTERE AQUI","ALTERE AQUI","ALTERE AQUI","ALTERE AQUI","ALTERE AQUI","ALTERE AQUI","ALTERE AQUI","ALTERE AQUI","ALTERE AQUI","ALTERE AQUI","ALTERE AQUI"]

{"sheet":"Planilha4","index":4,"n_rows":9,"n_cols":7,"rows_kept":9,"cut":false,"hidden":true,"merged":[]}
["Faturas em Aberto",{"$f":"COUNTIFS(Planilha7!F:F,\"=Aberto\")","v":0},null,"Valores Total",null,"Mensalidade",{"$f":"SUM(Planilha7!J:J)","v":0}]
["Faturas Vencidas",{"$f":"COUNTIFS(Planilha7!F:F,\"=Vencido\")","v":0},null,{"$f":"SUM(Planilha7!G:G)","v":0},null,"Atividades Extraclasse",{"$f":"SUM(Planilha7!K:K)","v":0}]
["Faturas Fechadas",{"$f":"COUNTIFS(Planilha7!F:F,\"=Fechado\")","v":0},null,"Valores Pago",null,"Materiais Escolares",{"$f":"SUM(Planilha7!L:L)","v":0}]
["Proximas do vencimento",{"$f":"COUNTIFS(Planilha7!P:P,\">0\",Planilha7!P:P,\"<7\")","v":0},null,{"$f":"SUM(Planilha7!I:I)","v":0},null,"Multas",{"$f":"SUM(Planilha7!M:M)","v":0}]
[null,null,null,"Falta Receber",null,"Outros",{"$f":"SUM(Planilha7!O:O)","v":0}]
["Parcelas em Aberto",{"$f":"COUNTIFS(Planilha8!F:F,\"=Aberto\")","v":0},null,{"$f":"D2-D4","v":0}]
["Parcelas Pagas",{"$f":"COUNTIFS(Planilha8!F:F,\"=Pago\")","v":0}]
["Parcelas pagas com atraso",{"$f":"COUNTIFS(Planilha8!F:F,\"=Pago com Atraso\")","v":0}]
["Parcelas Vencidas",{"$f":"COUNTIFS(Planilha8!F:F,\"=Vencido\")","v":0}]

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

{"sheet":"Planilha7","index":6,"n_rows":1,"n_cols":16,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["ID","ID MEMBRO","NOME DO MEMBRO","DATA LANÇAMENTO","PROXIMO VENCIMENTO","STATUS","VALOR","PARCELAS","TOTAL PAGO","MENSALIDADE","ATIVIDADES EXTRACLASSE","MATERIAIS ESCOLARES","MULTAS","OUTROS","DESCONTO",{"$error":"#VALUE!"}]

{"sheet":"Planilha8","index":7,"n_rows":1,"n_cols":6,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["ID","ID FATURA","DATA VENCIMENTO","DATA DE PAGAMENTO","VALOR DE CADA","Status"]

{"sheet":"Planilha16","index":8,"n_rows":20,"n_cols":58,"rows_kept":20,"cut":false,"hidden":false,"merged":[[5,4,5,10]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,"Retrato",null,null,"Planilha16",{"$f":"\"D5:L21\"","v":"D5:L21"},2,"Relatório Anual Mensalidades",null,2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,"Paisagem",null,null,null,null,"xlPortrait","xlLandscape "]
[]
[]
[]
[null,null,null,null,"RELATÓRIO ANUAL"]
[null,null,null,null,"Meses","Cadastros","Faturas Abertas","Parcelas Pagas","Valores a Receber","Valor Recebido","Em Relação Ao Ano Anterior"]
[null,null,null,null,"Janeiro",{"$f":"Planilha25!L8","v":0},{"$f":"Planilha25!U8","v":0},{"$f":"Planilha25!S8+Planilha25!T8","v":0},{"$f":"Planilha25!R8","v":0},{"$f":"Planilha25!Q8","v":0},{"$f":"IF(J8=0,IF(Planilha25!Q38=0,0,-1),(J8-Planilha25!Q38)/J8)","v":0}]
[null,null,null,null,"Fevereiro",{"$f":"Planilha25!L9","v":0},{"$f":"Planilha25!U9","v":0},{"$f":"Planilha25!S9+Planilha25!T9","v":0},{"$f":"Planilha25!R9","v":0},{"$f":"Planilha25!Q9","v":0},{"$f":"IF(J9=0,IF(Planilha25!Q39=0,0,-1),(J9-Planilha25!Q39)/J9)","v":0}]
[null,null,null,null,"Março",{"$f":"Planilha25!L10","v":0},{"$f":"Planilha25!U10","v":0},{"$f":"Planilha25!S10+Planilha25!T10","v":0},{"$f":"Planilha25!R10","v":0},{"$f":"Planilha25!Q10","v":0},{"$f":"IF(J10=0,IF(Planilha25!Q40=0,0,-1),(J10-Planilha25!Q40)/J10)","v":0}]
[null,null,null,null,"Abril",{"$f":"Planilha25!L11","v":0},{"$f":"Planilha25!U11","v":0},{"$f":"Planilha25!S11+Planilha25!T11","v":0},{"$f":"Planilha25!R11","v":0},{"$f":"Planilha25!Q11","v":0},{"$f":"IF(J11=0,IF(Planilha25!Q41=0,0,-1),(J11-Planilha25!Q41)/J11)","v":0}]
[null,null,null,null,"Maio",{"$f":"Planilha25!L12","v":0},{"$f":"Planilha25!U12","v":0},{"$f":"Planilha25!S12+Planilha25!T12","v":0},{"$f":"Planilha25!R12","v":0},{"$f":"Planilha25!Q12","v":0},{"$f":"IF(J12=0,IF(Planilha25!Q42=0,0,-1),(J12-Planilha25!Q42)/J12)","v":0}]
[null,null,null,null,"Junho",{"$f":"Planilha25!L13","v":0},{"$f":"Planilha25!U13","v":0},{"$f":"Planilha25!S13+Planilha25!T13","v":0},{"$f":"Planilha25!R13","v":0},{"$f":"Planilha25!Q13","v":0},{"$f":"IF(J13=0,IF(Planilha25!Q43=0,0,-1),(J13-Planilha25!Q43)/J13)","v":0}]
[null,null,null,null,"Julho",{"$f":"Planilha25!L14","v":0},{"$f":"Planilha25!U14","v":0},{"$f":"Planilha25!S14+Planilha25!T14","v":0},{"$f":"Planilha25!R14","v":0},{"$f":"Planilha25!Q14","v":0},{"$f":"IF(J14=0,IF(Planilha25!Q44=0,0,-1),(J14-Planilha25!Q44)/J14)","v":0}]
[null,null,null,null,"Agosto",{"$f":"Planilha25!L15","v":0},{"$f":"Planilha25!U15","v":0},{"$f":"Planilha25!S15+Planilha25!T15","v":0},{"$f":"Planilha25!R15","v":0},{"$f":"Planilha25!Q15","v":0},{"$f":"IF(J15=0,IF(Planilha25!Q45=0,0,-1),(J15-Planilha25!Q45)/J15)","v":0}]
[null,null,null,null,"Setembro",{"$f":"Planilha25!L16","v":0},{"$f":"Planilha25!U16","v":0},{"$f":"Planilha25!S16+Planilha25!T16","v":0},{"$f":"Planilha25!R16","v":0},{"$f":"Planilha25!Q16","v":0},{"$f":"IF(J16=0,IF(Planilha25!Q46=0,0,-1),(J16-Planilha25!Q46)/J16)","v":0}]
[null,null,null,null,"Outubro",{"$f":"Planilha25!L17","v":0},{"$f":"Planilha25!U17","v":0},{"$f":"Planilha25!S17+Planilha25!T17","v":0},{"$f":"Planilha25!R17","v":0},{"$f":"Planilha25!Q17","v":0},{"$f":"IF(J17=0,IF(Planilha25!Q47=0,0,-1),(J17-Planilha25!Q47)/J17)","v":0}]
[null,null,null,null,"Novembro",{"$f":"Planilha25!L18","v":0},{"$f":"Planilha25!U18","v":0},{"$f":"Planilha25!S18+Planilha25!T18","v":0},{"$f":"Planilha25!R18","v":0},{"$f":"Planilha25!Q18","v":0},{"$f":"IF(J18=0,IF(Planilha25!Q48=0,0,-1),(J18-Planilha25!Q48)/J18)","v":0}]
[null,null,null,null,"Dezembro",{"$f":"Planilha25!L19","v":0},{"$f":"Planilha25!U19","v":0},{"$f":"Planilha25!S19+Planilha25!T19","v":0},{"$f":"Planilha25!R19","v":0},{"$f":"Planilha25!Q19","v":0},{"$f":"IF(J19=0,IF(Planilha25!Q49=0,0,-1),(J19-Planilha25!Q49)/J19)","v":0}]
[null,null,null,null,"Total",{"$f":"SUM(F8:F19)","v":0},{"$f":"SUM(G8:G19)","v":0},0,0,0,{"$f":"IF(J20=0,IF(Planilha25!Q53=0,0,-1),(J20-Planilha25!Q53)/J20)","v":0}]

{"sheet":"Planilha17","index":9,"n_rows":8,"n_cols":58,"rows_kept":8,"cut":false,"hidden":false,"merged":[[5,4,5,12]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,"Retrato",null,null,"Planilha17",{"$f":"\"E5:M\"&COUNTA(E:E)+11","v":"E5:M15"},2,"Relatório de Faturas",null,2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,"Paisagem",null,null,null,null,"xlPortrait","xlLandscape "]
[null,null,null,null,"2000-01-01","2100-01-01"]
[]
[]
[null,null,null,null,"RELATÓRIO DE FATURAS"]
[null,null,null,null,"ID","ID ALUNO","NOME DO MEMBRO","DATA LANÇAMENTO","PROXIMO VENCIMENTO","STATUS","VALOR","PARCELAS","TOTAL PAGO"]
[null,null,null,null,1,1,"João","2023-03-08","2023-04-01",null,300,3]

{"sheet":"Planilha19","index":10,"n_rows":7,"n_cols":58,"rows_kept":7,"cut":false,"hidden":false,"merged":[[5,4,5,10]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,"Retrato",null,null,"Planilha19",{"$f":"\"E5:K\"&COUNTA(E:E)+11","v":"E5:K14"},2,"Relatório de Parcelas",null,2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,"Paisagem",null,null,null,null,"xlPortrait","xlLandscape "]
[null,null,null,null,"2000-01-01","2023-01-31"]
[]
[]
[null,null,null,null,"RELATÓRIO DE PARCELAS"]
[null,null,null,null,"ID","ID FATURA","NOME DO MEMBRO","DATA VENCIMENTO","DATA DE PAGAMENTO","VALOR ","Status"]

{"sheet":"Planilha18","index":11,"n_rows":7,"n_cols":58,"rows_kept":7,"cut":false,"hidden":false,"merged":[[5,4,5,9]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,"Retrato",null,null,"Planilha18",{"$f":"\"E5:J\"&COUNTA(E:E)+11","v":"E5:J13"},2,"Relatório Individual",null,2]
[null,null,null,null,null,null,null,null,null,null,null,"JOSÉ LORENZO FIUZA BARBOSA",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,"Paisagem",null,null,null,null,"xlPortrait","xlLandscape "]
[]
[]
[]
[null,null,null,null,{"$f":"\"Relatório de Parcelas: \" & L2","v":"Relatório de Parcelas: JOSÉ LORENZO FIUZA BARBOSA"}]
[null,null,null,null,"ID","ID FATURA","DATA VENCIMENTO","DATA DE PAGAMENTO","VALOR ","Status"]

{"sheet":"Planilha12","index":12,"n_rows":1,"n_cols":7,"rows_kept":1,"cut":false,"hidden":true,"merged":[]}
["ID","ALUNO","DATA DE LANÇAMENTO","STATUS","VALOR","DIAS","ID Alunos"]

{"sheet":"Planilha13","index":13,"n_rows":2,"n_cols":6,"rows_kept":2,"cut":false,"hidden":true,"merged":[]}
["ID ","ID FATURA","DATA DE VENCIMENTO","DATA PAGAMENTO","VALOR","STATUS"]
[11,11,"2022-03-05",null,462,"Vencido"]

{"sheet":"Planilha14","index":14,"n_rows":1,"n_cols":9,"rows_kept":1,"cut":false,"hidden":true,"merged":[]}
["ID","DATA","NOME DO MEMBRO","EMAIL","TELEFONE","CPF/CNPJ","DATA DE NASCIMENTO","REGISTRO ACADÊMICO","TURMA"]