{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Cadastrar","Banco de Dados","Busca","Plan3"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":1,"defined_names":8,"comments":1,"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":"Cadastrar","index":0,"n_rows":13,"n_cols":23,"rows_kept":13,"cut":false,"hidden":false,"merged":[[13,0,13,2],[13,4,13,7],[13,9,13,13],[13,15,13,19],[7,15,7,17],[11,13,11,17],[2,5,2,15],[12,0,12,1],[9,0,9,7],[9,9,9,11],[9,13,9,19],[11,0,11,7],[11,9,11,11],[0,0,7,3],[4,5,4,9],[4,11,4,13],[4,15,4,19],[7,11,7,13]]}
["insira aqui o nome da sua empresa",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Cadastrar!F8&-Cadastrar!H8&-Cadastrar!J8","v":"00"}]
[null,null,null,null,null,"Nome Completo:",null,null,null,null,null,null,null,null,null,null,null,"Sexo:",null,"Estado Civil:"]
[]
[null,null,null,null,null,"CPF:",null,null,null,null,null,"CNPJ:",null,null,null,"RG:"]
[]
[null,null,null,null,null,"Data de Nascimento:"]
[null,null,null,null,null,"Dia",null,"Mês",null,"Ano",null,"Nacionalidade",null,null,null,"Naturalidade:",null,null,null,"UF:"]
[]
["Endereço:",null,null,null,null,null,null,null,null,"Número:",null,null,null,"Complemento:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Desenvolvido por:"]
["Município:",null,null,null,null,null,null,null,null,"Bairro:",null,null,null,"Cep:",null,null,null,null,null,"UF:"]
[]
["Telefone:",null,null,null,"Celular:",null,null,null,null,"E-mail:",null,null,null,null,null,"Cadastrado em:"]

{"sheet":"Banco de Dados","index":1,"n_rows":2,"n_cols":21,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
["CNPJ","CPF","Nome","Sexo","Estado Civil","RG","Data de Nascimento","Nacionalidade","Naturalidade","UF","Endereço","Número","Complemento","Município","Bairro","CEP","UF","Telefone","Celular","E-mail","Cadastrado em"]
[{"$f":"Cadastrar!L5","v":0},{"$f":"Cadastrar!F5","v":0},{"$f":"Cadastrar!F3","v":0},{"$f":"Cadastrar!R3","v":0},{"$f":"Cadastrar!T3","v":0},{"$f":"Cadastrar!P5","v":0},{"$f":"Cadastrar!V1","v":"00"},{"$f":"Cadastrar!L8","v":0},{"$f":"Cadastrar!P8","v":0},{"$f":"Cadastrar!T8","v":0},{"$f":"Cadastrar!A10","v":0},{"$f":"Cadastrar!J10","v":0},{"$f":"Cadastrar!N10","v":0},{"$f":"Cadastrar!A12","v":0},{"$f":"Cadastrar!J12","v":0},{"$f":"Cadastrar!N12","v":0},{"$f":"Cadastrar!T12","v":0},{"$f":"Cadastrar!A14","v":0},{"$f":"Cadastrar!E14","v":0},{"$f":"Cadastrar!J14","v":0},{"$f":"Cadastrar!P14","v":"00:00:00"}]

{"sheet":"Busca","index":2,"n_rows":18,"n_cols":14,"rows_kept":18,"cut":false,"hidden":false,"merged":[[2,1,2,7],[2,9,2,15],[15,13,15,15],[9,7,9,9],[11,1,11,3],[17,10,17,15],[9,13,9,15],[7,13,7,15],[17,5,17,8],[11,13,11,15],[13,1,13,5],[15,7,15,9],[15,1,15,5],[13,9,13,15],[11,5,11,9],[17,1,17,3],[9,1,9,2],[9,4,9,5],[7,1,7,11]]}
[]
[null,"CPF:",null,null,null,null,null,null,null,"CNPJ:"]
[]
[]
[null,"Resultado da busca"]
[]
[null,"Nome Completo:",null,null,null,null,null,null,null,null,null,null,null,"Sexo:"]
[null,{"$f":"IF(AND($J$3=\"\",$B$3=\"\"),\"\",IF($J$3=\"\",VLOOKUP($B$3,'Banco de Dados'!$B$2:$U$720,2,0),VLOOKUP($J$3,'Banco de Dados'!$A$3:$U$1048576,3,0)))","v":""},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND($J$3=\"\",$B$3=\"\"),\"\",IF($J$3=\"\",VLOOKUP($B$3,'Banco de Dados'!$B$2:$U$720,3,0),VLOOKUP($J$3,'Banco de Dados'!$A$3:$U$1048576,4,0)))","v":""}]
[null,"CPF:",null,null,"CNPJ:",null,null,"RG:",null,null,null,"Estado Civil:",null,"Data de Nascimento:"]
[null,{"$f":"IFERROR(IF(AND($J$3=\"\",$B$3=\"\"),\"\",IF($J$3=\"\",VLOOKUP($B$3,'Banco de Dados'!$B$2:$U$724,1,0),\"-\")),\"-\")","v":""},null,null,{"$f":"IFERROR(IF(AND($J$3=\"\",$B$3=\"\"),\"\",IF($J$3=\"\",\"-\",VLOOKUP($J$3,'Banco de Dados'!$2:$715,1,0))),\"-\")","v":""},null,null,{"$f":"IF(AND($J$3=\"\",$B$3=\"\"),\"\",IF($J$3=\"\",VLOOKUP($B$3,'Banco de Dados'!$B$2:$U$720,5,0),VLOOKUP($J$3,'Banco de Dados'!$A$3:$U$1048576,6,0)))","v":""},null,null,null,{"$f":"IF(AND($J$3=\"\",$B$3=\"\"),\"\",IF($J$3=\"\",VLOOKUP($B$3,'Banco de Dados'!$B$2:$U$720,4,0),VLOOKUP($J$3,'Banco de Dados'!$A$3:$U$1048576,5,0)))","v":""},null,{"$f":"IF(AND($J$3=\"\",$B$3=\"\"),\"\",IF($J$3=\"\",VLOOKUP($B$3,'Banco de Dados'!$B$2:$U$720,6,0),VLOOKUP($J$3,'Banco de Dados'!$A$3:$U$1048576,7,0)))","v":""}]
[null,"Nacionalidade",null,null,null,"Naturalidade:",null,null,null,null,null,"UF:",null,"Cadastrado em:"]
[null,{"$f":"IF(AND($J$3=\"\",$B$3=\"\"),\"\",IF($J$3=\"\",VLOOKUP($B$3,'Banco de Dados'!$B$2:$U$720,7,0),VLOOKUP($J$3,'Banco de Dados'!$A$3:$U$1048576,8,0)))","v":""},null,null,null,{"$f":"IF(AND($J$3=\"\",$B$3=\"\"),\"\",IF($J$3=\"\",VLOOKUP($B$3,'Banco de Dados'!$B$2:$U$720,8,0),VLOOKUP($J$3,'Banco de Dados'!$A$3:$U$1048576,9,0)))","v":""},null,null,null,null,null,{"$f":"IF(AND($J$3=\"\",$B$3=\"\"),\"\",IF($J$3=\"\",VLOOKUP($B$3,'Banco de Dados'!$B$2:$U$720,9,0),VLOOKUP($J$3,'Banco de Dados'!$A$3:$U$1048576,10,0)))","v":""},null,{"$f":"IF(AND($J$3=\"\",$B$3=\"\"),\"\",IF($J$3=\"\",VLOOKUP($B$3,'Banco de Dados'!$B$2:$U$720,20,0),VLOOKUP($J$3,'Banco de Dados'!$A$3:$U$1048576,21,0)))","v":""}]
[null,"Endereço:",null,null,null,null,null,"Número:",null,"Complemento:"]
[null,{"$f":"IF(AND($J$3=\"\",$B$3=\"\"),\"\",IF($J$3=\"\",VLOOKUP($B$3,'Banco de Dados'!$B$2:$U$720,10,0),VLOOKUP($J$3,'Banco de Dados'!$A$3:$U$1048576,11,0)))","v":""},null,null,null,null,null,{"$f":"IF(AND($J$3=\"\",$B$3=\"\"),\"\",IF($J$3=\"\",VLOOKUP($B$3,'Banco de Dados'!$B$2:$U$720,11,0),VLOOKUP($J$3,'Banco de Dados'!$A$3:$U$1048576,12,0)))","v":""},null,{"$f":"IF(AND($J$3=\"\",$B$3=\"\"),\"\",IF($J$3=\"\",VLOOKUP($B$3,'Banco de Dados'!$B$2:$U$720,12,0),VLOOKUP($J$3,'Banco de Dados'!$A$3:$U$1048576,13,0)))","v":""}]
[null,"Município:",null,null,null,null,null,"Bairro:",null,null,null,"UF:",null,"Cep:"]
[null,{"$f":"IF(AND($J$3=\"\",$B$3=\"\"),\"\",IF($J$3=\"\",VLOOKUP($B$3,'Banco de Dados'!$B$2:$U$720,12,0),VLOOKUP($J$3,'Banco de Dados'!$A$3:$U$1048576,14,0)))","v":""},null,null,null,null,null,{"$f":"IF(AND($J$3=\"\",$B$3=\"\"),\"\",IF($J$3=\"\",VLOOKUP($B$3,'Banco de Dados'!$B$2:$U$720,14,0),VLOOKUP($J$3,'Banco de Dados'!$A$3:$U$1048576,15,0)))","v":""},null,null,null,{"$f":"IF(AND($J$3=\"\",$B$3=\"\"),\"\",IF($J$3=\"\",VLOOKUP($B$3,'Banco de Dados'!$B$2:$U$720,9,0),VLOOKUP($J$3,'Banco de Dados'!$A$3:$U$1048576,10,0)))","v":""},null,{"$f":"IF(AND($J$3=\"\",$B$3=\"\"),\"\",IF($J$3=\"\",VLOOKUP($B$3,'Banco de Dados'!$B$2:$U$720,15,0),VLOOKUP($J$3,'Banco de Dados'!$A$3:$U$1048576,16,0)))","v":""}]
[null,"Telefone:",null,null,null,"Celular:",null,null,null,null,"E-mail:"]
[null,{"$f":"IF(AND($J$3=\"\",$B$3=\"\"),\"\",IF($J$3=\"\",VLOOKUP($B$3,'Banco de Dados'!$B$2:$U$720,17,0),VLOOKUP($J$3,'Banco de Dados'!$A$3:$U$1048576,18,0)))","v":""},null,null,null,{"$f":"IF(AND($J$3=\"\",$B$3=\"\"),\"\",IF($J$3=\"\",VLOOKUP($B$3,'Banco de Dados'!$B$2:$U$720,18,0),VLOOKUP($J$3,'Banco de Dados'!$A$3:$U$1048576,19,0)))","v":""},null,null,null,null,{"$f":"IF(AND($J$3=\"\",$B$3=\"\"),\"\",IF($J$3=\"\",VLOOKUP($B$3,'Banco de Dados'!$B$2:$U$720,19,0),VLOOKUP($J$3,'Banco de Dados'!$A$3:$U$1048576,20,0)))","v":""}]

{"sheet":"Plan3","index":3,"n_rows":112,"n_cols":7,"rows_kept":112,"cut":false,"hidden":true,"merged":[]}
[]
[]
[1,1,1910,"Feminino","Solteiro (a)","AC","AC"]
[2,2,1911,"Masculino","Casado (a)","AL","AL"]
[3,3,1912,null,"Divorciado (a)","AP","AP"]
[4,4,1913,null,"Viúvo (a)","AM","AM"]
[5,5,1914,null,null,"BA","BA"]
[6,6,1915,null,null,"CE","CE"]
[7,7,1916,null,null,"DF","DF"]
[8,8,1917,null,null,"ES","ES"]
[9,9,1918,null,null,"GO","GO"]
[10,10,1919,null,null,"MA","MA"]
[11,11,1920,null,null,"MT","MT"]
[12,12,1921,null,null,"MS","MS"]
[13,null,1922,null,null,"MG","MG"]
[14,null,1923,null,null,"PR","PR"]
[15,null,1924,null,null,"PB","PB"]
[16,null,1925,null,null,"PA","PA"]
[17,null,1926,null,null,"PE","PE"]
[18,null,1927,null,null,"PI","PI"]
[19,null,1928,null,null,"RJ","RJ"]
[20,null,1929,null,null,"RN","RN"]
[21,null,1930,null,null,"RS","RS"]
[22,null,1931,null,null,"RO","RO"]
[23,null,1932,null,null,"RR","RR"]
[24,null,1933,null,null,"SC","SC"]
[25,null,1934,null,null,"SE","SE"]
[26,null,1935,null,null,"SP","SP"]
[27,null,1936,null,null,"TO","TO"]
[28,null,1937]
[29,null,1938]
[30,null,1939]
[31,null,1940]
[null,null,1941]
[null,null,1942]
[null,null,1943]
[null,null,1944]
[null,null,1945]
[null,null,1946]
[null,null,1947]
[null,null,1948]
[null,null,1949]
[null,null,1950]
[null,null,1951]
[null,null,1952]
[null,null,1953]
[null,null,1954]
[null,null,1955]
[null,null,1956]
[null,null,1957]
[null,null,1958]
[null,null,1959]
[null,null,1960]
[null,null,1961]
[null,null,1962]
[null,null,1963]
[null,null,1964]
[null,null,1965]
[null,null,1966]
[null,null,1967]
[null,null,1968]
[null,null,1969]
[null,null,1970]
[null,null,1971]
[null,null,1972]
[null,null,1973]
[null,null,1974]
[null,null,1975]
[null,null,1976]
[null,null,1977]
[null,null,1978]
[null,null,1979]
[null,null,1980]
[null,null,1981]
[null,null,1982]
[null,null,1983]
[null,null,1984]
[null,null,1985]
[null,null,1986]
[null,null,1987]
[null,null,1988]
[null,null,1989]
[null,null,1990]
[null,null,1991]
[null,null,1992]
[null,null,1993]
[null,null,1994]
[null,null,1995]
[null,null,1996]
[null,null,1997]
[null,null,1998]
[null,null,1999]
[null,null,2000]
[null,null,2001]
[null,null,2002]
[null,null,2003]
[null,null,2004]
[null,null,2005]
[null,null,2006]
[null,null,2007]
[null,null,2008]
[null,null,2009]
[null,null,2010]
[null,null,2011]
[null,null,2012]
[null,null,2013]
[null,null,2014]
[null,null,2015]
[null,null,2016]
[null,null,2017]
[null,null,2018]
[null,null,2019]