{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Assistente","Informações","BaseFuncionarios"],"not_rendered":{"charts":0,"images":10,"macros":0,"external_links":0,"defined_names":16,"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":"Assistente","index":0,"n_rows":32,"n_cols":17,"rows_kept":32,"cut":false,"hidden":false,"merged":[[28,3,28,5],[28,7,28,9],[25,7,25,9],[25,10,25,12],[27,3,27,5],[27,7,27,9],[27,10,27,12],[20,7,20,9],[20,10,20,12],[26,3,26,5],[26,7,26,9],[26,10,26,12],[21,3,21,5],[21,7,21,9],[21,10,21,12],[22,3,22,5],[22,7,22,9],[22,10,22,12],[23,3,23,5],[24,3,24,5],[24,7,24,9],[24,10,24,12],[25,3,25,5],[16,3,16,5],[16,7,16,9],[16,10,16,12],[10,6,10,12],[11,2,11,12],[14,7,14,9],[14,10,14,12],[15,3,15,5],[14,3,14,5],[15,7,15,9],[15,10,15,12],[30,3,30,5],[30,7,30,9],[30,10,30,12],[31,3,31,5],[31,7,31,9],[31,10,31,12],[17,3,17,5],[17,7,17,9],[17,10,17,12],[28,10,28,12],[29,3,29,5],[29,7,29,9],[29,10,29,12],[23,7,23,9],[23,10,23,12],[18,3,18,5],[18,7,18,9],[18,10,18,12],[19,3,19,5],[19,7,19,9],[19,10,19,12],[20,3,20,5],[32,10,32,12],[32,3,32,5],[32,7,32,9],[5,2,6,5],[5,6,6,12],[7,3,7,5],[7,6,7,12],[8,2,8,12],[9,3,9,5],[10,3,10,5],[12,3,12,5],[12,7,12,9],[12,10,12,12],[13,3,13,5],[13,7,13,9],[13,10,13,12]]}
[]
[]
[]
[]
[]
[null,null,{"$f":"NomeEmpresa","v":"Empresa Fictícia LTDA"},null,null,null,"Recibo de Pagamento de Salário"]
[]
[null,null,"CNPJ:",{"$f":"CnpjFormatado","v":"12.345.675/3342-11"},null,null,{"$f":"MesRef&\"/\"&AnoRef","v":"Março/2018"}]
[]
[null,null,"Código","Nome do Funcionário",null,null,"CBO","Emp.","Local","Depto.","Setor","Seção","Fl."]
[null,null,{"$f":"CodFuncionario","v":1},{"$f":"IF(MAX(BaseFuncionarios!A:A)=0,\"Nenhum funcionário cadastrado\",IFERROR(VLOOKUP(C11,BaseFuncionarios!A:B,2,0),\"Não encontrado\"))","v":"Deisiane Avelino"},null,null,{"$f":"IFERROR(VLOOKUP(C11,BaseFuncionarios!A:E,3,0)&\" - \"&VLOOKUP(C11,BaseFuncionarios!A:E,4,0),\"\")","v":"Supervisor(a) de RH - 1621"}]
[]
[null,null,"Cód.","Descrição",null,null,"Referência","Vencimentos",null,null,"Descontos"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,{"$f":"IFERROR(VLOOKUP(D15,Opcoes,2,0),\"\")","v":3},"ADCIONAL NOTURNO",null,null,null,300,null,null,""]
[null,null,16,"V.T - ÔNIBUS",null,null,0.06]
[null,null,""]
[null,null,""]
[null,null,"",null,null,null,null,""]
[null,null,"",null,null,null,null,""]
[null,null,"",null,null,null,null,"",null,null,""]
[null,null,"",null,null,null,null,"",null,null,""]
[null,null,"",null,null,null,null,"",null,null,""]
[null,null,"",null,null,null,null,"",null,null,""]
[null,null,"",null,null,null,null,"",null,null,""]
[null,null,"",null,null,null,null,"",null,null,""]
[null,null,"",null,null,null,null,"",null,null,""]
[null,null,"",null,null,null,null,"",null,null,""]
[null,null,"",null,null,null,null,"",null,null,""]
[null,null,"",null,null,null,null,"",null,null,""]
[null,null,"",null,null,null,null,"",null,null,""]
[null,null,"",null,null,null,null,"",null,null,""]

{"sheet":"Informações","index":1,"n_rows":31,"n_cols":12,"rows_kept":31,"cut":false,"hidden":false,"merged":[]}
["SALÁRIO DE CONTRIBUIÇÃO (R$)","ALÍQUOTA INSS",null,null,null,null,null,"Base de cálculo (R$)","Alíquota (%)","Parcela a deduzir do IRPF (R$)",null,"Meses"]
["até 1.693,72",0.08,null,0,{"$f":"B2","v":0.08},null,null,0,0,0,1,"Janeiro"]
["de 1.693,73 até 2.822,90",0.09,null,{"$f":"RIGHT(A2,8)","v":"1.693,72"},0.09,null,null,1903.98,7.4999999999999997E-2,142.80000000000001,2,"Fevereiro"]
["de 2.822,91 até 5.645,80",0.11,null,"2.822,90",0.11,null,null,2826.65,0.15,354.8,3,"Março"]
[null,null,null,null,null,null,null,3751.05,0.22500000000000001,636.13,4,"Abril"]
[null,null,null,null,null,null,null,4664.68,0.27500000000000002,869.36,5,"Maio"]
[null,null,null,null,null,null,null,null,null,null,6,"Junho"]
["DESCRIÇÃO","COD",null,null,null,null,null,"Nome da empresa","Empresa Fictícia LTDA",null,7,"Julho"]
["SALÁRIO FAMÍLIA",1,null,null,null,null,null,"CNPJ da empresa","12345675334211",null,8,"Agosto"]
["INSALUBRIDADE",2,null,null,null,null,null,"Mês Ref","Março",null,9,"Setembro"]
["ADCIONAL NOTURNO",3,null,null,null,null,null,"Ano Ref",2018,null,10,"Outubro"]
["HORA EXTRA - 50%",4,null,null,null,null,null,null,null,null,11,"Novembro"]
["HORA EXTRA - 75%",5,null,null,null,null,null,"CNPJ com formato","12.345.675/3342-11",null,12,"Dezembro"]
["HORA EXTRA - 100%",6]
["ADCIONAL DE FUNÇÃO",7,null,null,null,null,null,"CodFuncionario",1]
["ADCIONAL DE RT - PRINCIPAL",8]
["ADCIONAL DE RT - SUBSTITUTO",9]
["PREAMIAÇÃO",10]
["AJUDA DE CUSTO",11]
["ADCIONAL DE COLETA DOMICILIAR",12]
["PLANO DE SAÚDE",13]
["CONVÊNIO FARMÁCIA",14]
["VALE",15]
["V.T - ÔNIBUS",16]
["V.T - COMBUSTÍVEL",17]
["HORA DÉBITO",18]
["FALTAS",19]
["DSR",20]
[null,21]
[null,22]
[null,23]

{"sheet":"BaseFuncionarios","index":2,"n_rows":3,"n_cols":4,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
["Cod","Nome","Ocupação","Salário"]
[1,"Deisiane Avelino","Supervisor(a) de RH",1621]
[2,"Elen Rodrigues","Assistente de RH",1621]