{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Menu","CDC Formulário","CDC Planilha","CDC Analítico","FS","CST"],"not_rendered":{"charts":3,"images":29,"macros":1,"external_links":2,"defined_names":7,"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":"Menu","index":0,"n_rows":15,"n_cols":11,"rows_kept":15,"cut":false,"hidden":false,"merged":[[13,6,13,9],[13,10,13,15],[14,6,14,9],[14,10,14,15]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,"EMPRESA",null,null,null,"Empresa ABCDE"]
[null,null,null,null,null,null,"SEGMENTO DA EMPRESA",null,null,null,"Comércio"]

{"sheet":"CDC Formulário","index":1,"n_rows":24,"n_cols":8,"rows_kept":24,"cut":false,"hidden":false,"merged":[[10,3,13,10],[21,3,21,5],[20,3,20,4],[19,5,19,10],[20,5,20,10],[21,6,21,10],[19,3,19,4],[18,3,18,4],[17,3,17,4],[16,3,16,4],[15,3,15,4],[15,5,15,10],[16,5,16,6],[17,5,17,10],[18,5,18,10],[16,7,16,8],[16,9,16,10],[23,3,23,10],[22,3,22,10]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"COM O OBJETIVO DE LHE CONHECER MELHOR, PEDIMOS QUE INFORME OS DADOS ABAIXO. USAREMOS ESTES DADOS QUANDO PRECISARMOS ENTRAR EM CONTATO COM VOCÊ. FIQUE TRANQUILO, NUNCA REPASSAREMOS ESTA INFORMAÇÃO A NINGUÉM!"]
[]
[]
[]
[]
[null,null,null,"NOME:"]
[null,null,null,"SEXO:",null,null,null,"DATA DE NASCIMENTO:"]
[null,null,null,"CIDADE:"]
[null,null,null,"BAIRRO:"]
[null,null,null,"TELEFONE:"]
[null,null,null,"E-MAIL:"]
[null,null,null,"NOME NAS REDES SOCIAIS:"]
[null,null,null,"COM QUE FREQUÊNCIA VOCÊ COSTUMA VIR AO NOSSO ESTABELECIMENTO?"]
[null,null,null,"   DIARIAMENTE             SEMANALMENTE             MENSALMENTE            OCASIONAMENTE"]

{"sheet":"CDC Planilha","index":2,"n_rows":18,"n_cols":38,"rows_kept":18,"cut":false,"hidden":false,"merged":[[16,32,16,33],[16,10,16,11],[16,12,16,13],[16,14,16,15],[16,16,16,17],[16,18,16,19],[16,20,16,21],[16,22,16,23],[16,24,16,25],[16,26,16,27],[7,2,7,6],[4,7,4,10],[16,2,16,9],[16,28,16,29],[16,30,16,31],[9,2,9,6],[10,2,10,6],[9,7,9,10],[11,7,11,9],[10,7,10,9],[15,3,15,4],[11,2,11,6],[12,2,12,6],[13,2,13,6],[13,7,13,10],[12,7,12,10],[3,7,3,10],[6,7,6,10],[4,2,4,6],[5,2,5,6],[6,2,6,6]]}
[]
[]
[]
[null,null,null,null,null,null,null,{"$f":"UPPER(H13)","v":"CONSUMO MÉDIO (M) : CLIENTE GASTA ENTRE VALORES DEFINIDOS ACIMA."}]
[null,null,{"$f":"UPPER(C11)","v":"DIÁRIO (D): CLIENTE COMPRA QUASE TODOS OS DIAS"},null,null,null,null,{"$f":"UPPER(H14)","v":"(OBS.: DEIXAR EM BRANCO NOS MESES QUE O CLIENTE NÃO COMPROU)"}]
[null,null,{"$f":"UPPER(C12)","v":"SEMANAL (S): CLIENTE COMPRA QUASE TODA SEMANA"}]
[null,null,"MENSAL (M): CLIENTE COMPRA UMA VEZ POR MÊS"]
[null,null,"OCASIONAL (O): CLIENTE OCASIONALMENTE COMPRA"]
[]
[null,null,"CRITÉRIO PARA AVALIAÇÃO DA FREQUÊNCIA",null,null,null,null,"CRITÉRIOS PARA AVALIAÇÃO DO CONSUMO"]
[null,null,"DIÁRIO (D): CLIENTE COMPRA QUASE TODOS OS DIAS",null,null,null,null,"CONSUMO ALTO (A): CLIENTE NORMALMENTE GASTA MAIS QUE",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"D","A"]
[null,null,"SEMANAL (S): CLIENTE COMPRA QUASE TODA SEMANA",null,null,null,null,"CONSUMO BAIXO (B): CLIENTE NORMALMENTE GASTA MENOS QUE",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"S","M"]
[null,null,"MENSAL (M): CLIENTE COMPRA UMA VEZ POR MÊS",null,null,null,null,"CONSUMO MÉDIO (M) : CLIENTE GASTA ENTRE VALORES DEFINIDOS ACIMA.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"M","B"]
[null,null,"OCASIONAL (O): CLIENTE OCASIONALMENTE COMPRA",null,null,null,null,"(OBS.: DEIXAR EM BRANCO NOS MESES QUE O CLIENTE NÃO COMPROU)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"O"]
[]
[null,null,"DATA INICIAL DO CADASTOR",null,null,null,null,null,null,null,{"$f":"D16","v":"00:00:00"},null,{"$f":"EDATE(K16,1)","v":31},null,{"$f":"EDATE(M16,1)","v":59},null,{"$f":"EDATE(O16,1)","v":88},null,{"$f":"EDATE(Q16,1)","v":119},null,{"$f":"EDATE(S16,1)","v":149},null,{"$f":"EDATE(U16,1)","v":180},null,{"$f":"EDATE(W16,1)","v":210},null,{"$f":"EDATE(Y16,1)","v":241},null,{"$f":"EDATE(AA16,1)","v":272},null,{"$f":"EDATE(AC16,1)","v":302},null,{"$f":"EDATE(AE16,1)","v":333}]
[null,null,"DADOS DOS CADASTRO",null,null,null,null,null,null,null,{"$f":"IF($D$16>0,MONTH(K16)&\"/\"&RIGHT(YEAR(K16),2),\"Informe a data inicial\")","v":"Informe a data inicial"},null,{"$f":"IF($D$16>0,MONTH(M16)&\"/\"&RIGHT(YEAR(M16),2),\"Informe a data inicial\")","v":"Informe a data inicial"},null,{"$f":"IF($D$16>0,MONTH(O16)&\"/\"&RIGHT(YEAR(O16),2),\"Informe a data inicial\")","v":"Informe a data inicial"},null,{"$f":"IF($D$16>0,MONTH(Q16)&\"/\"&RIGHT(YEAR(Q16),2),\"Informe a data inicial\")","v":"Informe a data inicial"},null,{"$f":"IF($D$16>0,MONTH(S16)&\"/\"&RIGHT(YEAR(S16),2),\"Informe a data inicial\")","v":"Informe a data inicial"},null,{"$f":"IF($D$16>0,MONTH(U16)&\"/\"&RIGHT(YEAR(U16),2),\"Informe a data inicial\")","v":"Informe a data inicial"},null,{"$f":"IF($D$16>0,MONTH(W16)&\"/\"&RIGHT(YEAR(W16),2),\"Informe a data inicial\")","v":"Informe a data inicial"},null,{"$f":"IF($D$16>0,MONTH(Y16)&\"/\"&RIGHT(YEAR(Y16),2),\"Informe a data inicial\")","v":"Informe a data inicial"},null,{"$f":"IF($D$16>0,MONTH(AA16)&\"/\"&RIGHT(YEAR(AA16),2),\"Informe a data inicial\")","v":"Informe a data inicial"},null,{"$f":"IF($D$16>0,MONTH(AC16)&\"/\"&RIGHT(YEAR(AC16),2),\"Informe a data inicial\")","v":"Informe a data inicial"},null,{"$f":"IF($D$16>0,MONTH(AE16)&\"/\"&RIGHT(YEAR(AE16),2),\"Informe a data inicial\")","v":"Informe a data inicial"},null,{"$f":"IF($D$16>0,MONTH(AG16)&\"/\"&RIGHT(YEAR(AG16),2),\"Informe a data inicial\")","v":"Informe a data inicial"}]
[null,null,"NOME","SEXO","ANIVERSÁRIO","CIDADE ","BAIRRO","TELEFONE","E-MAIL","REDE SOCIAL","FREQ.","CONSUMO","FREQ.","CONSUMO","FREQ.","CONSUMO","FREQ.","CONSUMO","FREQ.","CONSUMO","FREQ.","CONSUMO","FREQ.","CONSUMO","FREQ.","CONSUMO","FREQ.","CONSUMO","FREQ.","CONSUMO","FREQ.","CONSUMO","FREQ.","CONSUMO"]

{"sheet":"CDC Analítico","index":3,"n_rows":21,"n_cols":15,"rows_kept":21,"cut":false,"hidden":false,"merged":[[24,1,24,14],[23,1,23,14],[22,1,22,14],[11,3,11,14],[9,1,9,14],[13,1,15,1],[17,1,20,1],[11,1,12,2],[16,1,16,2]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"O QUADRO E OS GRÁFICOS A SEGUIR MOSTRAM A EVOLUÇÃO DA SUA CARTEIRA DE CLIENTES \nDE ACORDO COM OS DADOS CADASTRADOS NA PLANILHA DE CADASTRO DE CLIENTES"]
[]
[null,"CONSUMO E FREQUÊNCIA",null,"MÊS"]
[null,null,null,{"$f":"'CDC Planilha'!K17","v":"Informe a data inicial"},{"$f":"'CDC Planilha'!M17","v":"Informe a data inicial"},{"$f":"'CDC Planilha'!O17","v":"Informe a data inicial"},{"$f":"'CDC Planilha'!Q17","v":"Informe a data inicial"},{"$f":"'CDC Planilha'!S17","v":"Informe a data inicial"},{"$f":"'CDC Planilha'!U17","v":"Informe a data inicial"},{"$f":"'CDC Planilha'!W17","v":"Informe a data inicial"},{"$f":"'CDC Planilha'!Y17","v":"Informe a data inicial"},{"$f":"'CDC Planilha'!AA17","v":"Informe a data inicial"},{"$f":"'CDC Planilha'!AC17","v":"Informe a data inicial"},{"$f":"'CDC Planilha'!AE17","v":"Informe a data inicial"},{"$f":"'CDC Planilha'!AG17","v":"Informe a data inicial"}]
["B","CONSUMO","BAIXO",{"$f":"COUNTIFS('CDC Planilha'!L:L,\"B\")","v":0},{"$f":"COUNTIFS('CDC Planilha'!N:N,\"B\")","v":0},{"$f":"COUNTIFS('CDC Planilha'!P:P,\"B\")","v":0},{"$f":"COUNTIFS('CDC Planilha'!R:R,\"B\")","v":0},{"$f":"COUNTIFS('CDC Planilha'!T:T,\"B\")","v":0},{"$f":"COUNTIFS('CDC Planilha'!V:V,\"B\")","v":0},{"$f":"COUNTIFS('CDC Planilha'!X:X,\"B\")","v":0},{"$f":"COUNTIFS('CDC Planilha'!Z:Z,\"B\")","v":0},{"$f":"COUNTIFS('CDC Planilha'!AB:AB,\"B\")","v":0},{"$f":"COUNTIFS('CDC Planilha'!AD:AD,\"B\")","v":0},{"$f":"COUNTIFS('CDC Planilha'!AF:AF,\"B\")","v":0},{"$f":"COUNTIFS('CDC Planilha'!AH:AH,\"B\")","v":0}]
["M",null,"MÉDIO",{"$f":"COUNTIFS('CDC Planilha'!L:L,\"M\")","v":0},{"$f":"COUNTIFS('CDC Planilha'!N:N,\"M\")","v":0},{"$f":"COUNTIFS('CDC Planilha'!P:P,\"M\")","v":0},{"$f":"COUNTIFS('CDC Planilha'!R:R,\"M\")","v":0},{"$f":"COUNTIFS('CDC Planilha'!T:T,\"M\")","v":0},{"$f":"COUNTIFS('CDC Planilha'!V:V,\"M\")","v":0},{"$f":"COUNTIFS('CDC Planilha'!X:X,\"M\")","v":0},{"$f":"COUNTIFS('CDC Planilha'!Z:Z,\"M\")","v":0},{"$f":"COUNTIFS('CDC Planilha'!AB:AB,\"M\")","v":0},{"$f":"COUNTIFS('CDC Planilha'!AD:AD,\"M\")","v":0},{"$f":"COUNTIFS('CDC Planilha'!AF:AF,\"M\")","v":0},{"$f":"COUNTIFS('CDC Planilha'!AH:AH,\"M\")","v":0}]
["A",null,"ALTO",{"$f":"COUNTIFS('CDC Planilha'!L:L,\"A\")","v":0},{"$f":"COUNTIFS('CDC Planilha'!N:N,\"A\")","v":0},{"$f":"COUNTIFS('CDC Planilha'!P:P,\"A\")","v":0},{"$f":"COUNTIFS('CDC Planilha'!R:R,\"A\")","v":0},{"$f":"COUNTIFS('CDC Planilha'!T:T,\"A\")","v":0},{"$f":"COUNTIFS('CDC Planilha'!V:V,\"A\")","v":0},{"$f":"COUNTIFS('CDC Planilha'!X:X,\"A\")","v":0},{"$f":"COUNTIFS('CDC Planilha'!Z:Z,\"A\")","v":0},{"$f":"COUNTIFS('CDC Planilha'!AB:AB,\"A\")","v":0},{"$f":"COUNTIFS('CDC Planilha'!AD:AD,\"A\")","v":0},{"$f":"COUNTIFS('CDC Planilha'!AF:AF,\"A\")","v":0},{"$f":"COUNTIFS('CDC Planilha'!AH:AH,\"A\")","v":0}]
[null,"QUANTIDADE TOTAL DOS CLIENTES",null,{"$f":"SUM(D14:D16)","v":0},0,0,0,0,0,0,0,0,0,0,0]
["O","FREQUÊNCIA","OCASIONAL",{"$f":"COUNTIFS('CDC Planilha'!K:K,\"O\")","v":0},{"$f":"COUNTIFS('CDC Planilha'!M:M,\"O\")","v":0},{"$f":"COUNTIFS('CDC Planilha'!O:O,\"O\")","v":0},{"$f":"COUNTIFS('CDC Planilha'!Q:Q,\"O\")","v":0},{"$f":"COUNTIFS('CDC Planilha'!S:S,\"O\")","v":0},{"$f":"COUNTIFS('CDC Planilha'!U:U,\"O\")","v":0},{"$f":"COUNTIFS('CDC Planilha'!W:W,\"O\")","v":0},{"$f":"COUNTIFS('CDC Planilha'!Y:Y,\"O\")","v":0},{"$f":"COUNTIFS('CDC Planilha'!AA:AA,\"O\")","v":0},{"$f":"COUNTIFS('CDC Planilha'!AC:AC,\"O\")","v":0},{"$f":"COUNTIFS('CDC Planilha'!AE:AE,\"O\")","v":0},{"$f":"COUNTIFS('CDC Planilha'!AG:AG,\"O\")","v":0}]
["M",null,"MENSAL",{"$f":"COUNTIFS('CDC Planilha'!K:K,\"M\")","v":0},{"$f":"COUNTIFS('CDC Planilha'!M:M,\"M\")","v":0},{"$f":"COUNTIFS('CDC Planilha'!O:O,\"M\")","v":0},{"$f":"COUNTIFS('CDC Planilha'!Q:Q,\"M\")","v":0},{"$f":"COUNTIFS('CDC Planilha'!S:S,\"M\")","v":0},{"$f":"COUNTIFS('CDC Planilha'!U:U,\"M\")","v":0},{"$f":"COUNTIFS('CDC Planilha'!W:W,\"M\")","v":0},{"$f":"COUNTIFS('CDC Planilha'!Y:Y,\"M\")","v":0},{"$f":"COUNTIFS('CDC Planilha'!AA:AA,\"M\")","v":0},{"$f":"COUNTIFS('CDC Planilha'!AC:AC,\"M\")","v":0},{"$f":"COUNTIFS('CDC Planilha'!AE:AE,\"M\")","v":0},{"$f":"COUNTIFS('CDC Planilha'!AG:AG,\"M\")","v":0}]
["S",null,"SEMANAL",{"$f":"COUNTIFS('CDC Planilha'!K:K,\"S\")","v":0},{"$f":"COUNTIFS('CDC Planilha'!M:M,\"S\")","v":0},{"$f":"COUNTIFS('CDC Planilha'!O:O,\"S\")","v":0},{"$f":"COUNTIFS('CDC Planilha'!Q:Q,\"S\")","v":0},{"$f":"COUNTIFS('CDC Planilha'!S:S,\"S\")","v":0},{"$f":"COUNTIFS('CDC Planilha'!U:U,\"S\")","v":0},{"$f":"COUNTIFS('CDC Planilha'!W:W,\"S\")","v":0},{"$f":"COUNTIFS('CDC Planilha'!Y:Y,\"S\")","v":0},{"$f":"COUNTIFS('CDC Planilha'!AA:AA,\"S\")","v":0},{"$f":"COUNTIFS('CDC Planilha'!AC:AC,\"S\")","v":0},{"$f":"COUNTIFS('CDC Planilha'!AE:AE,\"S\")","v":0},{"$f":"COUNTIFS('CDC Planilha'!AG:AG,\"S\")","v":0}]
["D",null,"DIÁRIA",{"$f":"COUNTIFS('CDC Planilha'!K:K,\"D\")","v":0},{"$f":"COUNTIFS('CDC Planilha'!M:M,\"D\")","v":0},{"$f":"COUNTIFS('CDC Planilha'!O:O,\"D\")","v":0},{"$f":"COUNTIFS('CDC Planilha'!Q:Q,\"D\")","v":0},{"$f":"COUNTIFS('CDC Planilha'!S:S,\"D\")","v":0},{"$f":"COUNTIFS('CDC Planilha'!U:U,\"D\")","v":0},{"$f":"COUNTIFS('CDC Planilha'!W:W,\"D\")","v":0},{"$f":"COUNTIFS('CDC Planilha'!Y:Y,\"D\")","v":0},{"$f":"COUNTIFS('CDC Planilha'!AA:AA,\"D\")","v":0},{"$f":"COUNTIFS('CDC Planilha'!AC:AC,\"D\")","v":0},{"$f":"COUNTIFS('CDC Planilha'!AE:AE,\"D\")","v":0},{"$f":"COUNTIFS('CDC Planilha'!AG:AG,\"D\")","v":0}]

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

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