{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["Menu","menu_exp","mascara","calculo","seg aut","masc_termino","termin_exp","masc_exp2","exp2","config"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":0,"defined_names":1,"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":31,"n_cols":1,"rows_kept":31,"cut":false,"hidden":false,"merged":[[30,0,30,25],[0,15,0,255],[0,0,0,9],[8,0,8,16383]]}
[]
[]
[]
[]
[]
[]
[]
[]
["Base de cálculos trabalhistas - Comércio do estado de São Paulo"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Planilha+ 5.1.2   .:.   Acácio Jr   .:.   unico@acaciojunior.com       -      Última atualização: 03/02/2016"]

{"sheet":"menu_exp","index":1,"n_rows":25,"n_cols":1,"rows_kept":25,"cut":false,"hidden":false,"merged":[[0,0,0,9],[0,15,0,255],[8,0,8,16383],[23,0,23,25]]}
[]
[]
[]
[]
[]
[]
[]
[]
["Cálculo de rescisão de contrato de experiência"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[{"$f":"Menu!A31","v":"Planilha+ 5.1.2   .:.   Acácio Jr   .:.   unico@acaciojunior.com       -      Última atualização: 03/02/2016"}]
["Único Company     .:.     Acácio Jr     .:.     Fecomerciários"]

{"sheet":"mascara","index":2,"n_rows":41,"n_cols":24,"rows_kept":41,"cut":false,"hidden":false,"merged":[[12,0,12,20],[13,1,13,6],[11,1,11,6],[11,7,11,9],[0,13,1,19],[2,13,2,19],[4,0,4,20],[5,7,5,14],[10,0,10,20],[5,1,5,6],[7,1,7,6],[9,7,9,9],[7,7,7,9],[6,0,6,20],[11,13,11,18],[13,7,13,10],[31,1,31,19],[32,1,32,19],[15,10,15,17],[27,4,27,15],[25,1,25,3],[19,14,19,16],[19,4,19,6],[19,11,19,12],[19,1,19,3],[13,16,13,19],[40,0,40,20],[34,8,34,9],[15,7,15,9],[30,10,30,11],[27,1,27,3],[21,1,21,8],[21,9,21,11],[16,1,16,19],[25,4,25,15],[34,1,34,7],[35,0,35,20],[17,1,17,19],[30,1,30,9],[14,0,14,20],[15,1,15,6]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Base de cálculo demissional",null,null,null,null,null,null,null,null,"sim ou não","afastamento"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"sim","Dispensa sem justa causa"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"config!I101","v":"FECOMERCIÁRIOS"},null,null,null,null,null,null,null,null,"não","Pedido de demissão"]
[]
[]
[null,"Motivo do Afastamento:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(H6=\"Pedido de demissão\",IF(H10>0,IF(H12>0,\"Dias de aviso cumprido:\",\"\"),\"\"),\"\")","v":""},null,{"$f":"IF(H6=\"Pedido de demissão\",IF(H10>0,IF(H12>0,H12-H10,\"\"),\"\"),\"\")","v":""}]
[]
[null,"Admissão:",null,null,null,null,null,null,null,null,"dd/mm/aaaa (data do registro na carteira)",null,null,null,null,null,null,null,null,{"$f":"IF(H6=\"\",0,H12-H10)","v":0}]
[]
[null,null,null,null,null,null,"Data do aviso:",null,null,null,"dd/mm/aaaa",null,null,{"$f":"IF(P10=\"\",\"\",IF(H6=\"Dispensa sem justa causa\",\"Direito á\",\"\"))","v":""},null,{"$f":"IF(H6=\"Dispensa sem justa causa\",IF(H8>0,IF(H10>0,IF(calculo!AI8+30<=90,calculo!AI8+30,90),\"\"),\"\"),\"\")","v":""},{"$f":"IF(P10=\"\",\"\",IF(H6=\"Dispensa sem justa causa\",\"dias de aviso prévio (trabalhado ou indenizado)\",\"\"))","v":""}]
[]
[null,"Data do último dia trabalhado:",null,null,null,null,null,null,null,null,"dd/mm/aaaa",null,null,{"$f":"IF(H6=\"Dispensa sem justa causa\",IF(H8>0,IF(H10>0,IF(H12>0,IF(T12>0,\"Aviso prévio restante será indenizado\",IF(T12<0,\"Erro de procedimento, excedeu  dias no aviso prévio.\",\"\")),\"\"),\"\"),\"\"),\"\")","v":""},null,null,null,null,null,{"$f":"IF(H6=\"Dispensa sem justa causa\",IF(H8>0,IF(H10>0,IF(H12>0,(calculo!AI8+30)-T8,\"\"),\"\"),\"\"),\"\")","v":""}]
[]
[null,"Salário:",null,null,null,null,null,null,null,null,null,"bruto",null,null,null,null,{"$f":"IF(H12>0,IF(H12<H10,\"Data de saída inferior a data de aviso\",\"\"),\"\")","v":""}]
[]
[null,"Possui uma férias vencidas:",null,null,null,null,null,null,null,null,{"$f":"IF(H8>0,IF(H10>0,IF(H16=\"sim\",IF(calculo!AJ8>=1,\"\",\"Atenção: Não há férias vencidas\"),\"\"),\"\"),\"\")","v":""}]
[null,{"$f":"IF(H8>0,IF(H10>0,IF(H12>0,IF(calculo!O24=12,\"Atenção: Última férias recentemente vencida ja está sendo computada no cálculo\",IF(H8>0,IF(H10>0,IF(H12>0,IF(calculo!O24=0,\"Atenção, há uma férias recentemente vencida, verificar a necessidade de selecionar o ítem - férias vencidas\",\"\"),\"\"),\"\"),\"\")),\"\"),\"\"),\"\")","v":""}]
[]
[null,"*Preencher o valor já incluindo o DSR quando houver."]
[null,"Outras Verbas:",null,null,null,null,null,null,null,null,"Incide INSS e IRPF?",null,null,null,"Descontos:"]
[]
[null,"Média de salário para cálculo de FGTS:"]
[]
[]
[]
[null,"Empresa:"]
[]
[null,"Trabalhador:"]
[]
[]
[null,"Nº dependentes no Imposto de renda:",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(config!Z19=\"sim\",\"Maior de\",\"\")","v":"Maior de"},{"$f":"IF(config!Z19=\"sim\",config!Z20,\"\")","v":50},{"$f":"IF(config!Z19=\"sim\",\"anos de idade\",\"\")","v":"anos de idade"},"não"]
[]
[]
[]
[null,"Nº de filhos com salário famlía:",null,null,null,null,null,null,null,null,"Número de filhos menores de 14 anos, para salários até:",null,null,null,null,null,null,null,{"$f":"config!F91","v":1212.6400000000001}]
[]
[]
[]
[]
[]
[{"$f":"Menu!A31","v":"Planilha+ 5.1.2   .:.   Acácio Jr   .:.   unico@acaciojunior.com       -      Última atualização: 03/02/2016"}]

{"sheet":"calculo","index":3,"n_rows":61,"n_cols":42,"rows_kept":61,"cut":false,"hidden":false,"merged":[[50,25,50,28],[52,25,52,28],[48,17,48,28],[54,25,54,28],[50,3,50,8],[52,3,52,8],[52,9,52,11],[41,33,42,33],[41,34,42,34],[13,25,13,26],[14,25,14,26],[13,14,13,24],[35,25,35,28],[56,3,58,28],[13,10,13,12],[14,15,14,24],[17,19,17,28],[25,25,25,28],[27,25,27,28],[19,25,19,28],[23,25,23,28],[35,10,35,13],[39,10,39,13],[29,25,29,28],[17,10,17,13],[43,9,43,13],[43,24,43,28],[41,10,41,13],[48,3,48,12],[4,3,4,28],[9,6,9,10],[9,25,9,28],[11,7,11,12],[7,10,7,17],[5,6,5,28],[6,7,6,28],[10,25,10,28],[45,3,46,17],[45,25,45,28],[29,10,29,13],[21,6,21,7],[33,10,33,13],[43,19,43,23],[21,25,21,28],[31,10,31,13],[31,25,31,28],[37,10,37,13],[19,7,19,8],[41,3,41,9],[9,16,9,19],[23,10,23,13],[25,10,25,13],[19,10,19,13],[21,10,21,13],[27,10,27,13]]}
[null,null,null,{"$f":"config!I101","v":"FECOMERCIÁRIOS"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Único Company    .:.    Acácio Jr     .:.    Fecomerciários"]
[null,null,null,{"$f":"config!I102","v":"Federação dos Empregados no Comércio do Estado de São Paulo"}]
[]
[null,null,null,{"$f":"config!J103","v":"Rua dos Pinheiros, nº 20 - Pinheiros"},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":"config!H104","v":"(11) 3060 6600"},null,null,null,null,"Multa Data Base",{"$f":"IF(K8=\"Dispensa sem justa causa\",IF(Z11<DATE(YEAR(Z11),config!AD103,config!AB103),IF(Z11>=DATE(YEAR(Z11),config!AD103,config!AB103)-30,H12,0),0),0)","v":0}]
[null,null,null,"Base de cálculo demissional",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Projeção pedido de demissão",{"$f":"Q10+30","v":"1900-01-30"}]
[null,null,null,{"$f":"IF(mascara!E26=\"\",\"\",\"Empresa:\")","v":""},null,null,{"$f":"IF(mascara!E26=\"\",\"\",mascara!E26)","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,"saldo de dias trabalhados",{"$f":"IF(MONTH(Z10)=MONTH(G10),IF(YEAR(Z10)=YEAR(G10),DAY(Z10)-DAY(G10),DAY(Z10)),DAY(Z10))","v":{"$error":"#VALUE!"}},"Total de dias trabalhados",{"$f":"IF(MONTH(Z10)=MONTH(G10),IF(YEAR(Z10)=YEAR(G10),DAY(Z10)-DAY(G10)+1,DAY(Z10)),DAY(Z10))","v":{"$error":"#VALUE!"}},"Fevereiro",{"$f":"IF(MONTH(Z10)=2,AO6,0)","v":{"$error":"#VALUE!"}},{"$f":"Z10+1","v":{"$error":"#VALUE!"}},{"$f":"IF(MONTH(Z10)=MONTH(AN6),0,30)","v":{"$error":"#VALUE!"}}]
[null,null,null,{"$f":"IF(mascara!E28=\"\",\"\",\"Trabalhador:\")","v":""},null,null,null,{"$f":"IF(mascara!E28=\"\",\"\",mascara!E28)","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,"Data projeção do  aviso",{"$f":"IF(K8=\"Dispensa sem justa causa\",mascara!H10+mascara!P10,Z10)+AM11+AP8","v":{"$error":"#VALUE!"}},{"$f":"IF(K8=\"Dispensa sem justa causa\",Q10+30,Z10)","v":""},{"$f":"AJ7-1","v":{"$error":"#VALUE!"}},{"$f":"IF(AM7<=0,DAY(AJ7)-DAY(G10),0)","v":{"$error":"#VALUE!"}},{"$f":"MONTH(AK7)-MONTH(G10)","v":{"$error":"#VALUE!"}},{"$f":"IF(AM7<0,1,IF(AL7<0,1,0))","v":{"$error":"#VALUE!"}}]
[null,null,null,"Motivo do Afastamento:",null,null,null,null,null,null,{"$f":"mascara!H6","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Anos trabalhados",{"$f":"IF(K8=\"Dispensa sem justa causa\",IF(AK8>=config!L53,60,VLOOKUP(AK8,config!E31:L52,5,FALSE)-30),0)","v":0},{"$f":"IF(YEAR(AJ7)>YEAR(G10),(YEAR(AJ7)-YEAR(G10))-AN8,0)","v":{"$error":"#VALUE!"}},{"$f":"IF(config!H28=\"ano completo\",IF(YEAR(AJ7)>YEAR(G10),(YEAR(AJ7)-YEAR(G10))-AN8,0),IF(YEAR(AK7)>YEAR(G10),(YEAR(AK7)-YEAR(G10))-AN7,0))","v":{"$error":"#VALUE!"}},{"$f":"IF(AM8<=0,DAY(AJ7)-DAY(G10),0)","v":{"$error":"#VALUE!"}},{"$f":"MONTH(AJ7)-MONTH(G10)","v":{"$error":"#VALUE!"}},{"$f":"IF(AM8<0,1,IF(AL8<0,1,0))","v":{"$error":"#VALUE!"}},"Dias além da lei 12.506",{"$f":"IF(K8=\"Dispensa sem justa causa\",IF(config!Z16=\"sim\",calculo!AJ8,0),0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ano atual",{"$f":"YEAR(Z10)","v":{"$error":"#VALUE!"}},{"$f":"DATE(AI9,1,1)","v":{"$error":"#VALUE!"}}]
[null,null,null,"Admissão:",null,null,{"$f":"IF(mascara!H8=\"\",\"\",mascara!H8)","v":""},null,null,null,null,null,"Data do aviso:",null,null,null,{"$f":"mascara!H10","v":"00:00:00"},null,null,null,null,null,null,null,"Saída:",{"$f":"IF(mascara!H12=\"\",\"\",mascara!H12)","v":""},null,null,null,null,null,null,null,"Meses trabalhados no ano",{"$f":"MONTH(AI7)+AK10","v":{"$error":"#VALUE!"}},{"$f":"DAY(AI7)","v":{"$error":"#VALUE!"}},{"$f":"IF(AJ10<15,-1,0)","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Projeção para cálculo:",{"$f":"IF(K8=\"Dispensa sem justa causa\",AI7,Z10)","v":""},null,null,null,null,null,null,null,"Dias no aviso pela idade",{"$f":"config!Z22","v":15},"Anos a serem trabalhados:",{"$f":"config!Z21","v":20},"resultado:",{"$f":"IF(config!Z19=\"sim\",IF(mascara!S31=\"sim\",IF(AJ8>AK11,AI11,0),0),0)","v":0}]
[null,null,null,"Salário:",null,null,null,{"$f":"mascara!H14","v":0},null,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érias proporcionais",{"$f":"IF(AJ12>=15,DATEDIF(G10,Z11,\"Ym\")+1,DATEDIF(G10,Z11,\"Ym\"))","v":{"$error":"#VALUE!"}},{"$f":"IF(DAY(Z11)>=DAY(G10),DAY(Z11)-DAY(G10)+1,(DATEDIF(G10,AK14,\"md\")+1)+DAY(Z11))","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"valor dia",{"$f":"H12/30","v":0},"Último dia do mês inicial","Último dia do mês anterior a projeçao do calculo","dias trabalhados apos data de aniversario"]
[null,null,null,"Possui férias vencidas:",null,null,null,null,null,null,{"$f":"mascara!H16","v":0},null,null,null,{"$f":"IF(mascara!K31=\"\",\"\",\"Nº de pendentes no Imposto de renda:\")","v":""},null,null,null,null,null,null,null,null,null,null,{"$f":"mascara!K31","v":0},null,null,null,null,null,null,null,"Valor mês",{"$f":"H12/12","v":0},{"$f":"EOMONTH(G10,0)","v":{"$error":"#VALUE!"}},{"$f":"EOMONTH(Z11,-1)","v":{"$error":"#VALUE!"}},{"$f":"IF(DAY(G10)>DAY(Z11),DAY(AK14)-DAY(G10)+DAY(Z11)+1,DAY(Z11)-DAY(G10)+1)","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(mascara!I35=\"\",\"\",\"N º de filhos no salário família:\")","v":""},null,null,null,null,null,null,null,null,null,{"$f":"mascara!I35","v":0},null,null,null,null,null,null,null,"13º","meses no ano","dias","resultado 13º"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"13º",{"$f":"IF(AJ16>=15,DATEDIF(G10,Z11,\"YM\")+1,DATEDIF(G10,Z11,\"YM\"))","v":{"$error":"#VALUE!"}},{"$f":"IF(DAY(Z11)>=DAY(G10),DAY(Z11)-DAY(G10)+1,(DATEDIF(G10,AK14,\"md\")+1)+DAY(Z11))","v":{"$error":"#VALUE!"}},{"$f":"IF(YEAR(Z11)>YEAR(G10),IF(DAY(Z11)>=15,MONTH(Z11),MONTH(Z11)-1),AI16)","v":{"$error":"#VALUE!"}}]
[null,null,"x"]
[{"$f":"IF(C18=\"x\",0,1)","v":1},null,null,{"$f":"IF(K18=\"\",\"\",IF(K18=0,\"\",\"Aviso prévio indenizado:\"))","v":""},null,null,null,null,null,null,{"$f":"IF(K8=\"Dispensa sem justa causa\",IF(mascara!T12>0,mascara!T12*AI13,0)+AM11*AI13,0)*A18","v":0},null,null,null,{"$f":"IF(C18=\"x\",\"\",IF(K8=\"Dispensa sem justa causa\",IF(mascara!T12>0,mascara!T12+AM11,IF(AM11>0,AM11,\"\")),\"\"))","v":""},{"$f":"IF(O18=\"\",\"\",\"dias\")","v":""},null,null,null,"Descontos",null,null,null,null,null,null,null,null,null,"x"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"INSS","valores","porcentagem saldo e/ou + indenização","Porc 13º","Procentagem apenas sobre saldo de salario"]
[{"$f":"IF(C20=\"x\",0,1)","v":1},null,null,{"$f":"IF(K20>0,\"Saldo de salário:\",\"\")","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"IF(C20=\"x\",0,IF(AK6>30,30,AK6))","v":{"$error":"#VALUE!"}},null,{"$f":"IF(C20=\"x\",\"\",IF(H20=1,\"dia\",\"dias\"))","v":{"$error":"#VALUE!"}},{"$f":"IF(AM6=0,(H20*AI13),H12)*A20","v":{"$error":"#VALUE!"}},null,null,null,null,null,null,null,null,{"$f":"IF(Z20>0,\"Previdência Social:\",\"\")","v":{"$error":"#VALUE!"}},null,null,null,null,null,{"$f":"IF(AJ24>0,(AN24)*AJ24,AI23)*AF20","v":{"$error":"#VALUE!"}},null,null,null,null,null,{"$f":"IF(AD20=\"x\",0,1)","v":1},null,"até",{"$f":"config!F72","v":1556.94},{"$f":"IF(AN24<=AI20,config!M72,0)","v":{"$error":"#VALUE!"}},{"$f":"IF(K22<=AI20,config!M72,0)","v":{"$error":"#VALUE!"}},{"$f":"IF(K20<=AI20,config!M72,0)","v":{"$error":"#VALUE!"}},"Valor para calculo da previdencia social"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"até",{"$f":"config!J73","v":2594.92},{"$f":"IF(AN24>AI20,IF(AN24<=AI21,config!M73,0),0)","v":{"$error":"#VALUE!"}},{"$f":"IF(K22>AI20,IF(K22<=AI21,config!M73,0),0)","v":{"$error":"#VALUE!"}},{"$f":"IF(K20>AI20,IF(AN24<=AI21,config!M73,0),0)","v":{"$error":"#VALUE!"}},"outros",{"$f":"IF(mascara!L20=\"sim\",mascara!E20,0)","v":0}]
[{"$f":"IF(C22=\"x\",0,1)","v":1},null,null,{"$f":"IF(K22>0,\"13º Salário:\",\"\")","v":{"$error":"#VALUE!"}},null,null,{"$f":"IF(C22=\"x\",0,AK16)","v":{"$error":"#VALUE!"}},null,{"$f":"IF(G22>0,IF(G22=1,\"mês\",\"meses\"),\"\")","v":{"$error":"#VALUE!"}},null,{"$f":"(AI14*G22)*A22","v":{"$error":"#VALUE!"}},null,null,null,null,null,null,null,null,{"$f":"IF(Z22>0,\"Inss 13º Salário:\",\"\")","v":{"$error":"#VALUE!"}},null,null,null,null,null,{"$f":"IF(AK24>0,K22*AK24,AI23)*AF22","v":{"$error":"#VALUE!"}},null,null,null,null,null,{"$f":"IF(AD22=\"x\",0,1)","v":1},null,"até",{"$f":"config!J74","v":5189.82},{"$f":"IF(AN24>AI21,IF(AN24<=AI22,config!M74,0),0)","v":{"$error":"#VALUE!"}},{"$f":"IF(K22>AI21,IF(K22<=AI22,config!M74,0),0)","v":{"$error":"#VALUE!"}},{"$f":"IF(K20>AI21,IF(AN24<=AI22,config!M74,0),0)","v":{"$error":"#VALUE!"}},"Indenizado",{"$f":"IF(config!O76=\"sim\",calculo!K18,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"teto",{"$f":"AI22*11%","v":570.88019999999995},{"$f":"IF(AN24>AI22,381.4,0)","v":{"$error":"#VALUE!"}},{"$f":"IF(K22>AI22,381.41,0)","v":{"$error":"#VALUE!"}},{"$f":"IF(K20>AI22,381.4,0)","v":{"$error":"#VALUE!"}},"saldo",{"$f":"K20","v":{"$error":"#VALUE!"}}]
[{"$f":"IF(C24=\"x\",0,1)","v":1},null,null,{"$f":"IF(K24>0,\"Férias proporcionais:\",\"\")","v":{"$error":"#VALUE!"}},null,null,null,null,null,null,{"$f":"(AI12*AI14)*A24","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"IF(C24=\"x\",0,IF(AI12>0,AI12,\"\"))","v":{"$error":"#VALUE!"}},{"$f":"IF(C24=\"x\",\"\",IF(O24=\"\",\"\",IF(O24=1,\"mês\",\"meses\")))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"IF(Z24>0,\"Contrib. Confed.:\",\"\")","v":{"$error":"#VALUE!"}},null,null,null,null,null,{"$f":"IF(AH57>0,IF(AH56>AH57,AH57,AH56),AH56)*AF24","v":{"$error":"#VALUE!"}},null,null,null,null,null,{"$f":"IF(AD24=\"x\",0,1)","v":1},null,"Prcentagem/valor",null,{"$f":"IF(AN24<=AI22,SUM(AJ20:AJ22),0)","v":{"$error":"#VALUE!"}},{"$f":"IF(K22<=AI22,SUM(AK20:AK22),0)","v":{"$error":"#VALUE!"}},{"$f":"IF(K20<=AI22,SUM(AL20:AL22),0)","v":{"$error":"#VALUE!"}},"total",{"$f":"SUM(AN21:AN23)","v":{"$error":"#VALUE!"}}]
[]
[{"$f":"IF(C26=\"x\",0,1)","v":1},null,null,{"$f":"IF(K26>0,\"1/3 Férias proporcionais:\",\"\")","v":{"$error":"#VALUE!"}},null,null,null,null,null,null,{"$f":"(K24/3)*A26","v":{"$error":"#VALUE!"}},null,null,null,null,null,null,null,null,{"$f":"IF(Z26=0,\"\",\"Aviso não cumprido:\")","v":""},null,null,null,null,null,{"$f":"IF(K8=\"Pedido de demissão\",IF(AI5<=Z10,0,(AI5-Z10)*AI13),0)*AF26","v":0},null,null,null,null,null,{"$f":"IF(AD26=\"x\",0,1)","v":1},null,"IPRF"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Base, até","Alíquota","Parcela a deduzir","IPRF Salário","IPRF 13º","IPRF Outros","Valor para calculo de Inss apenas sobre saldo de salario"]
[{"$f":"IF(C28=\"x\",0,1)","v":1},null,null,{"$f":"IF(K28=0,\"\",\"Férias vencidas:\")","v":""},null,null,null,null,null,null,{"$f":"IF(K14=\"sim\",IF(mascara!K16=\"\",H12,0),0)*A28","v":0},null,null,null,null,null,null,null,null,{"$f":"IF(Z28=0,\"\",\"IRPF 13º:\")","v":{"$error":"#VALUE!"}},null,null,null,null,null,{"$f":"IF(SUM(AM29:AM32)>0,SUM(AM29:AM32),0)*AF28","v":{"$error":"#VALUE!"}},null,null,null,null,null,{"$f":"IF(AD28=\"x\",0,1)","v":1},null,{"$f":"config!F60","v":1903.98},{"$f":"AH28","v":1903.98},{"$f":"config!M60","v":0},{"$f":"config!P60","v":0},null,null,null,"outros",{"$f":"IF(mascara!#REF!=\"sim\",mascara!E20,0)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,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":"config!J61","v":2826.65},{"$f":"AH29","v":2826.65},{"$f":"config!M61","v":7.4999999999999997E-2},{"$f":"config!P61","v":142.80000000000001},{"$f":"IF($AI$34>$AH28,IF($AI$34<=$AI29,($AI$34*$AJ29)-$AK29,0),0)","v":{"$error":"#VALUE!"}},{"$f":"IF($AI$35>$AH28,IF($AI$35<=$AI29,($AI$35*$AJ29)-$AK29,0),0)","v":{"$error":"#VALUE!"}},{"$f":"IF($AI$36>$AH28,IF($AI$36<=$AI29,($AI$36*$AJ29)-$AK29,0),0)","v":0},"Indenizado",{"$f":"IF(config!Q83=\"sim\",calculo!M25,0)","v":0}]
[{"$f":"IF(C30=\"x\",0,1)","v":1},null,null,{"$f":"IF(K30=0,\"\",\"1/3 Férias vencidas:\")","v":""},null,null,null,null,null,null,{"$f":"(IF(K28=0,0,K28/3))*A30","v":0},null,null,null,null,null,null,null,null,{"$f":"IF(Z30=0,\"\",\"IRPF:\")","v":{"$error":"#VALUE!"}},null,null,null,null,null,{"$f":"IF(SUM(AL29:AL32)>0,SUM(AL29:AL32),0)*AF30","v":{"$error":"#VALUE!"}},null,null,null,null,null,{"$f":"IF(AD30=\"x\",0,1)","v":1},null,{"$f":"config!J62","v":3751.05},{"$f":"AH30","v":3751.05},{"$f":"config!M62","v":0.15},{"$f":"config!P62","v":354.8},{"$f":"IF(AI34>AI29,IF(AI34<=AI30,(AI34*AJ30)-AK30,0),0)","v":{"$error":"#VALUE!"}},{"$f":"IF($AI$35>$AH29,IF($AI$35<=$AI30,($AI$35*$AJ30)-$AK30,0),0)","v":{"$error":"#VALUE!"}},{"$f":"IF($AI$36>$AH29,IF($AI$36<=$AI30,($AI$36*$AJ30)-$AK30,0),0)","v":0},"saldo",{"$f":"M27","v":0}]
[null,null,null,null,null,null,null,null,null,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":"config!J63","v":4664.68},{"$f":"AH31","v":4664.68},{"$f":"config!M63","v":0.22500000000000001},{"$f":"config!P63","v":636.13},{"$f":"IF($AI$34>$AH30,IF($AI$34<=$AI31,($AI$34*$AJ31)-$AK31,0),0)","v":{"$error":"#VALUE!"}},{"$f":"IF($AI$35>$AH30,IF($AI$35<=$AI31,($AI$35*$AJ31)-$AK31,0),0)","v":{"$error":"#VALUE!"}},{"$f":"IF($AI$36>$AH30,IF($AI$36<=$AI31,($AI$36*$AJ31)-$AK31,0),0)","v":0},"total",{"$f":"SUM(AP28:AP30)","v":{"$error":"#REF!"}}]
[{"$f":"IF(C32=\"x\",0,1)","v":1},null,null,{"$f":"IF(K32=0,\"\",\"Salário família:\")","v":{"$error":"#VALUE!"}},null,null,null,null,null,null,{"$f":"IF(SUM(AK44:AK45)>0,SUM(AK44:AK45),0)*A32","v":{"$error":"#VALUE!"}},null,null,null,null,null,null,null,null,{"$f":"IF(mascara!R20>0,mascara!O20,\"\")","v":""},null,null,null,null,null,{"$f":"IF(mascara!R20>0,mascara!R20,0)","v":0},null,null,null,null,null,null,null,"acima",null,{"$f":"config!M64","v":0.27500000000000002},{"$f":"config!P64","v":869.36},{"$f":"IF($AI34>$AI31,($AI34*$AJ32)-$AK32,0)","v":{"$error":"#VALUE!"}},{"$f":"IF(AI35>AI31,(AI35*AJ32)-AK32,0)","v":{"$error":"#VALUE!"}},{"$f":"IF(AI36>AI31,(AI36*AJ32)-AK32,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"dedução por dependente",{"$f":"config!K66","v":189.59},{"$f":"AI33*Z14","v":0}]
[{"$f":"IF(C34=\"x\",0,1)","v":1},null,null,{"$f":"IF(K34<=0,\"\",\"Aviso prévio indenizado CCT\")","v":""},null,null,null,null,null,null,{"$f":"IF(AP8>0,AP8*AI13,0)*A34","v":0},null,null,null,{"$f":"IF(C34=\"x\",0,IF(AP8>0,AP8,0))","v":0},{"$f":"IF(O34=0,\"\",IF(O34=1,\"dia\",\"dias\"))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"salário e/ou outros líquido",{"$f":"IF(mascara!L20=\"sim\",(K20+K36)-Z20-AJ33,K20-(K20*AL24)-AJ33)","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"13º liquido",{"$f":"(K22)-Z22-AJ33","v":{"$error":"#VALUE!"}}]
[null,null,null,{"$f":"IF(mascara!E20>0,\"Outros:\",\"\")","v":""},null,null,null,null,null,null,{"$f":"IF(mascara!E20>0,mascara!E20,0)","v":0}]
[]
[null,null,null,{"$f":"IF(K38>0,\"Multa , Lei Nº 7.238/84\",\"\")","v":""},null,null,null,null,null,null,{"$f":"IF(C38=\"x\",0,IF(AI4>0,AI4,0))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"sim ou não","afastamento"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"sim","Dispensa sem justa causa"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"não","Pedido de demissão"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Faixa Salarial Até","Valor do benefício por filho de até 14 anos incompletos ou inválido"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"valor","valor proporcional"]
[null,null,null,"TOTAL BRUTO:",null,null,null,null,null,{"$f":"SUM(K18:N43)","v":{"$error":"#VALUE!"}},null,null,null,null,null,null,null,null,null,"TOTAL DESC.: R$",null,null,null,null,{"$f":"SUM(Z20:AC43)","v":{"$error":"#VALUE!"}},null,null,null,null,null,null,null,null,{"$f":"config!F90","v":806.8},{"$f":"config!I90","v":41.37},{"$f":"IF(H12<=AH44,Z15*AI44,0)","v":0},{"$f":"(AJ44/30)*H20","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,null,null,null,null,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":"config!F91","v":1212.6400000000001},{"$f":"config!I91","v":29.16},{"$f":"IF(H12>AH44,IF(H12<=AH45,Z15*AI45,0),0)","v":0},{"$f":"(AJ45/30)*H20","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TOTAL A RECEBER: R$",null,null,null,null,null,{"$f":"IF(J44>Y44,J44-Y44,0)","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Dias de aviso indenizado","Fraçao de meses"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"13ª no aviso",{"$f":"IF(K8=\"Dispensa sem justa causa\",mascara!T12+AP8+AM11,0)","v":0},{"$f":"IF(K8=\"Dispensa sem justa causa\",IF(AI48>=15,AI48/30,0),0)","v":0}]
[null,null,null,{"$f":"IF('seg aut'!F17>0,\"Cálculo de seguro desemprego:\",\"\")","v":{"$error":"#VALUE!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(mascara!H6=\"Dispensa sem justa causa\",IF(mascara!J22>0,\"Cálculo de FGTS:\",\"\"),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Z11-Q10","v":{"$error":"#VALUE!"}},{"$f":"IF(AI49>=15,AI49/30,0)","v":{"$error":"#VALUE!"}},null,{"$f":"IF(DAY(Z10-G10)+1>=15,MONTH(Z10-G10),MONTH(Z10-G10)-1)","v":{"$error":"#VALUE!"}},{"$f":"IF(K8=\"Dispensa sem justa causa\",AL50-O24,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,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":"Z10-Q10+1","v":{"$error":"#VALUE!"}},{"$f":"IF(AI50<15,1,0)","v":{"$error":"#VALUE!"}},null,{"$f":"IF(DAY(Z11-G10)+1>=15,MONTH(Z11-G10),MONTH(Z11-G10)-1)","v":{"$error":"#VALUE!"}}]
[null,null,null,{"$f":"IF('seg aut'!F17>0,'seg aut'!D17,\"\")","v":{"$error":"#VALUE!"}},null,null,null,null,null,{"$f":"IF('seg aut'!F17>0,'seg aut'!F17,\"\")","v":{"$error":"#VALUE!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(R49=\"Cálculo de FGTS:\",\"Valor aproximado de saldo FGTS:\",\"\")","v":""},{"$f":"IF(R49=\"Cálculo de FGTS:\",AJ53*mascara!J22*8/100,\"\")","v":""},null,null,null,null,null,null,null,"tirando casas decimais",{"$f":"IF(AJ51<1.5,AJ51-1,IF(AJ51<2.5,AJ51-2,IF(AJ51<3.5,AJ51-3,IF(AJ51<4.5,AJ51-4,IF(AJ51<5.5,AJ51-5,AJ51-6)))))","v":{"$error":"#VALUE!"}},{"$f":"IF(AJ50+AJ48=0,0,IF(AJ48<AJ49,AJ50+AJ48,AJ48))","v":{"$error":"#VALUE!"}},{"$f":"IF(AJ51=0,0,AJ51-AI51)","v":{"$error":"#VALUE!"}},{"$f":"AL50-AL49","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,{"$f":"IF('seg aut'!F19>0,'seg aut'!D19,\"\")","v":{"$error":"#VALUE!"}},null,null,null,null,null,{"$f":"IF('seg aut'!F19>0,'seg aut'!F19,\"\")","v":{"$error":"#VALUE!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(R49=\"Cálculo de FGTS:\",\"Valor aproximado da multa de 40%:\",\"\")","v":""},{"$f":"IF(R49=\"Cálculo de FGTS:\",Z51*40/100,\"\")","v":""},null,null,null,null,null,null,null,"Meses trabalhados na empresa:",null,{"$f":"IF(YEAR(AJ7)>YEAR(G10),(YEAR(AJ7)-YEAR(G10))-AN8,0)*12+IF(DAY(Z11-G10)+1>=15,MONTH(Z11-G10),MONTH(Z11-G10)-1)","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,{"$f":"IF(J51=\"\",\"\",\"*observar regras para recebimento de seguro desemprego\")","v":{"$error":"#VALUE!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(R49=\"Cálculo de FGTS:\",\"Total aproximado de FGTS + multa:\",\"\")","v":""},{"$f":"IF(R49=\"Cálculo de FGTS:\",Z51+Z53,\"\")","v":""},null,null,null,null,null,null,null,"Desconto confederativa"]
[null,null,null,null,null,null,null,null,null,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(config!P8=\"Sim\",(calculo!K36+calculo!K20)*config!P6,K20*config!P6)","v":{"$error":"#VALUE!"}},"Calculo do desconto"]
[null,null,null,{"$f":"config!E110","v":"Obs. Cálculo baseado nas informações digitadas pelo usuário do site, podendo haver diferenças."},null,null,null,null,null,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(config!P10>0,config!P10,0)","v":0},"limite se houver"]
[]
[]
[]
[null,null,{"$f":"config!P104","v":"www.fecomerciarios.org.br"},null,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":"config!G105","v":0}]

{"sheet":"seg aut","index":4,"n_rows":57,"n_cols":15,"rows_kept":57,"cut":false,"hidden":false,"merged":[[4,1,4,7],[9,2,9,7],[11,2,11,7],[14,3,14,7],[16,3,16,4],[18,3,18,4],[5,1,5,7],[20,1,20,7],[24,1,26,7],[27,1,29,7],[31,1,31,7],[32,1,32,7],[33,1,33,7],[34,1,34,7],[35,1,35,7],[36,1,36,7],[37,1,37,7],[38,1,38,7],[39,1,39,7],[40,1,40,7],[41,1,41,7],[42,1,42,7],[43,1,43,7],[44,1,44,7],[45,1,45,7],[52,1,52,7],[53,1,53,7],[54,1,54,7],[55,1,55,7],[46,1,46,7],[47,1,47,7],[48,1,48,7],[49,1,49,7],[50,1,50,7],[51,1,51,7]]}
[null,{"$f":"config!I101","v":"FECOMERCIÁRIOS"},null,null,null,null,null,null,null,"Único Company    .:.    Acácio Jr     .:.    Fecomerciários"]
[null,{"$f":"config!I102","v":"Federação dos Empregados no Comércio do Estado de São Paulo"}]
[]
[]
[null,"Cálculo de seguro desemprego",null,null,null,null,null,null,null,null,"data de saída para calculo",{"$f":"F11","v":""}]
[null,{"$f":"IF(mascara!H6=\"Pedido de demissão\",\"Pedido de demissão não dá direito a seguro desemprego\",\"\")","v":""},null,null,null,null,null,null,null,null,"meses",{"$f":"IF(N6<15,M6,M6+1)","v":{"$error":"#VALUE!"}},{"$f":"(YEAR(F11)-YEAR(F9))*12+MONTH(F11)-MONTH(F9)","v":{"$error":"#VALUE!"}},{"$f":"IF(DAY(F11)>DAY(F9),DAY(F11)-DAY(F9)+1,DAY(F9)-DAY(F11)+1)","v":{"$error":"#VALUE!"}}]
[null,null,null,null,"Salário:",{"$f":"mascara!H14","v":0},null,null,null,null,"Salário mínimo",{"$f":"config!K95","v":880}]
[]
[null,null,null,null,"Data de admissão:",{"$f":"mascara!H8","v":"00:00:00"},null,null,null,"Faixas de salário",null,"cálculo",null,null,"resultado"]
[null,null,null,null,null,null,null,null,null,"até",{"$f":"config!F82","v":1360.7},{"$f":"config!T82","v":0.8},null,null,{"$f":"IF(F7<=K10,F7*L10,0)","v":0}]
[null,null,null,null,"Data de saída (projeção)",{"$f":"calculo!Z11","v":""},null,null,null,"até",{"$f":"config!J83","v":2268.0500000000002},{"$f":"config!Q83","v":1360.7},{"$f":"config!X83","v":0.5},{"$f":"config!AE83","v":1088.56},{"$f":"IF(F7>0,IF(O10=0,IF(F7<=K11,(F7-L11)*M11+(N11),0),0),0)","v":0}]
[null,null,null,null,null,null,null,null,null,"acima",{"$f":"config!G84","v":2268.0500000000002},{"$f":"config!S84","v":1542.24},null,null,{"$f":"IF(F7>0,IF(O11+O10=0,L12,0),0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"total",{"$f":"IF(L6>5,SUM(O10:O12),0)","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,{"$f":"IF(L6<6,IF(L6>0,\"Somente tem direito ao benefício quem trabalhou mais de 6 meses.\",\"\"),\"\")","v":{"$error":"#VALUE!"}},null,null,null,null,null,"meses trabalhados",null,"parcelas a receber"]
[null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,{"$f":"IF(O13>0,\"Parcelas a receber:\",\"\")","v":{"$error":"#VALUE!"}},null,{"$f":"IF(B6=\"\",IF(O13>0,VLOOKUP(L6,K16:L40,2),0),0)","v":{"$error":"#VALUE!"}},null,null,null,null,1,0]
[null,null,null,null,null,null,null,null,null,null,2,0]
[null,null,null,{"$f":"IF(O13>0,\"Valor da parcela:\",\"\")","v":{"$error":"#VALUE!"}},null,{"$f":"IF(L6>5,IF(F17>0,IF(O13>=L7,O13,L7),0),0)","v":{"$error":"#VALUE!"}},null,null,null,null,3,0]
[null,null,null,null,null,null,null,null,null,null,4,0]
[null,{"$f":"IF(mascara!E28=\"\",\"\",mascara!E28)","v":""},null,null,null,null,null,null,null,null,{"$f":"K20+1","v":5},0]
[null,null,null,null,null,null,null,null,null,null,{"$f":"K21+1","v":6},3]
[null,null,null,null,null,null,null,null,null,null,{"$f":"K22+1","v":7},3]
[null,"Infomações complementares:",null,null,null,null,null,null,null,null,8,3]
[null,"       Tem direito ao seguro desemprego quem tiver sido dispensado sem justa causa, tiver trabalhado pelo menos 6 meses nos últimos 36 meses, não possuir renda própria e não estiver recebendo benefício de prestação continuada da Previdência Social, exceto pensão por morte ou auxílio-acidente.",null,null,null,null,null,null,null,null,9,3]
[null,null,null,null,null,null,null,null,null,null,10,3]
[null,null,null,null,null,null,null,null,null,null,11,3]
[null,"       O trabalhador terá direito de 03 a 05 parcelas do benefício, de forma contínua ou alternada, a cada 16 meses, de acordo com a quantidade de meses trabalhados nos últimos 36 meses anteriores a dispensa, da seguinte forma:",null,null,null,null,null,null,null,null,12,4]
[null,null,null,null,null,null,null,null,null,null,13,4]
[null,null,null,null,null,null,null,null,null,null,14,4]
[null,null,null,null,null,null,null,null,null,null,15,4]
[null,"       O trabalhador tem do 7º ao 120º dia após a data da demissão do emprego para fazer o requerimento do benefício, que poderá ser feito nas DRT (Delegacia Regional do Trabalho, no PAT ( Posto de Atendimento ao Trabalhador) no SINE (Sistema Nacional de Emprego), ou nas agências credenciadas da CAIXA.",null,null,null,null,null,null,null,null,16,4]
[null,null,null,null,null,null,null,null,null,null,17,4]
[null,"Como requerer?",null,null,null,null,null,null,null,null,18,4]
[null,"   Comparecer em um dos locais acima citados levando os seguintes documentos:",null,null,null,null,null,null,null,null,19,4]
[null,null,null,null,null,null,null,null,null,null,20,4]
[null,"· Comunicação de Dispensa - CD (via marrom) e Requerimento do Seguro-Desemprego - SD (via verde);",null,null,null,null,null,null,null,null,21,4]
[null,null,null,null,null,null,null,null,null,null,22,4]
[null,"· Termo de Rescisão de Contrato de Trabalho - TRCT;",null,null,null,null,null,null,null,null,23,4]
[null,null,null,null,null,null,null,null,null,null,24,5]
[null,"· Carteira de Trabalho;"]
[null,null,null,null,null,null,null,null,null,"De acordo com informações informandas, você não tem direito ao benefício "]
[null,"· Carteira de Identidade ou Certidão de Nascimento ou Certidão de Casamento com Protocolo de requerimento na Carteira de Identidade, ou Carteira Nacional de Habilitação - CNH, dentro do prazo de validade, ou Passaporte, ou Certificado de Reservista;"]
[null,null,null,null,null,null,null,null,null,null,null,"sim"]
[null,"· Comprovante de inscrição no PIS/PASEP;",null,null,null,null,null,null,null,null,null,"não"]
[]
[null,"· Documento de levantamento dos depósitos no FGTS ou extrato comprobatório dos depósitos;"]
[]
[null,"· Cadastro Pessoa Física - CPF;"]
[]
[null,"· Comprovante dos 2 últimos contracheques ou recibos de pagamento para o trabalhador formal (não é documentação obrigatória)"]
[]
[null,"Onde Receber?"]
[null,"   Em qualquer Agência da CAIXA, ou Casa Lotérica ou Correspondente Bancário (CAIXA AQUI) ou Auto-Atendimento (CAIXA AZUL 24 HORAS)."]
[null,"   O pagamento nas Lotéricas, nos Correspondentes Bancários ou no Auto-Atendimento somente é realizado com o Cartão do Cidadão."]
[]
[{"$f":"config!P104","v":"www.fecomerciarios.org.br"},null,null,null,null,null,null,{"$f":"config!H104","v":"(11) 3060 6600"}]

{"sheet":"masc_termino","index":5,"n_rows":24,"n_cols":19,"rows_kept":24,"cut":false,"hidden":false,"merged":[[23,0,23,19],[12,0,12,19],[9,9,9,10],[9,11,9,13],[10,0,10,19],[14,0,14,19],[22,4,22,8],[18,0,18,19],[19,1,19,7],[19,8,19,9],[15,1,15,18],[16,1,16,18],[17,1,17,9],[17,10,17,11],[11,1,11,10],[13,8,13,10],[17,15,17,17],[13,11,13,16],[0,13,1,18],[2,13,2,18],[4,0,4,19],[6,0,6,19],[5,1,5,18],[7,8,7,10],[7,11,7,13],[8,0,8,19]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Base de cálculo demissional"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"config!I101","v":"FECOMERCIÁRIOS"}]
[]
[]
[null,"Término de Contrato de Experiência - Rescisão"]
[]
[null,null,null,null,null,null,null,null,"Admissão:",null,null,null,null,null,"dd/mm/aaaa (data do registro na carteira)"]
[]
[null,null,null,null,null,null,null,null,null,"Saída:",null,null,null,null,"dd/mm/aaaa (data do último dia trabalhado na empresa)"]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Contrato de",null,{"$f":"IF(L8>0,IF(L10>0,(L10-L8)+1,0),0)","v":0},"dias"]
[]
[null,null,null,null,null,null,null,null,"Salário:"]
[]
[]
[]
[null,"Nº dependentes no Imposto de renda:",null,null,null,null,null,null,null,null,null,null,null,null,null,"Adiantamentos:"]
[]
[null,"Nº de filhos com salário famlía:",null,null,null,null,null,null,null,null,"Nº de filhos menores de 14 anos, para salários até",null,null,null,null,null,null,null,{"$f":"config!F91","v":1212.6400000000001}]
[]
[]
[]
[{"$f":"Menu!A31","v":"Planilha+ 5.1.2   .:.   Acácio Jr   .:.   unico@acaciojunior.com       -      Última atualização: 03/02/2016"}]

{"sheet":"termin_exp","index":6,"n_rows":47,"n_cols":37,"rows_kept":47,"cut":false,"hidden":false,"merged":[[2,6,2,26],[4,1,4,26],[5,1,5,26],[9,4,9,8],[9,12,9,15],[10,18,10,26],[9,20,9,25],[13,12,13,13],[13,15,13,24],[13,25,13,26],[17,5,17,6],[17,8,17,11],[17,17,17,26],[43,30,44,30],[25,8,25,11],[25,23,25,26],[31,7,31,11],[29,23,29,26],[43,29,44,29],[35,13,35,16],[27,23,27,26],[47,1,48,15],[7,1,7,26],[37,8,37,11],[33,13,33,16],[38,1,40,26],[19,4,19,5],[19,8,19,11],[19,12,19,13],[19,23,19,26],[13,1,13,11],[21,8,21,11],[21,23,21,26],[23,8,23,11],[23,23,23,26],[31,17,31,21],[31,22,31,26]]}
[null,{"$f":"config!I101","v":"FECOMERCIÁRIOS"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Único Company    .:.    Acácio Jr     .:.    Fecomerciários"]
[null,{"$f":"config!I102","v":"Federação dos Empregados no Comércio do Estado de São Paulo"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"dias","meses"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Meses trabalhados",{"$f":"(M10-E10)+1","v":1},{"$f":"IF(AE3>=15,IF(AE3<=44,1,IF(AE3<=74,2,IF(AE3<=104,3,IF(AE3<=119,4)))))","v":false}]
[null,{"$f":"config!J103","v":"Rua dos Pinheiros, nº 20 - Pinheiros"},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":"config!H104","v":"(11) 3060 6600"}]
[]
[null,"Base de Calculo - Rescisão de Contrato de Experiência",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"saldo de dias trabalhados",{"$f":"IF(MONTH(M10)=MONTH(E10),IF(YEAR(M10)=YEAR(E10),DAY(M10)-DAY(E10),DAY(M10)),DAY(M10))","v":0},"Total de dias trabalhados no mes",{"$f":"IF(MONTH(M10)=MONTH(E10),IF(YEAR(M10)=YEAR(E10),DAY(M10)-DAY(E10),DAY(M10)),DAY(M10))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Data saída  aviso",null,{"$f":"M10","v":"00:00:00"},"dia",null,"Dias para 13º","meses 13º"]
[null,"Término de Contrado de Experiência",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Anos trabalhados",{"$f":"IF(YEAR(AF7)>YEAR(E10),(YEAR(AF7)-YEAR(E10))-AH8,0)","v":0},{"$f":"IF(AG8<=0,DAY(AF7)-DAY(E10),0)","v":0},{"$f":"MONTH(AF7)-MONTH(E10)","v":0},{"$f":"IF(AG8<0,1,IF(AF8<0,1,0))","v":0},{"$f":"DAY(AF7)-DAY(E10)","v":0},{"$f":"IF(AI8>=15,AG8+1,AG8)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ano atual",{"$f":"YEAR(M10)","v":1900},{"$f":"DATE(AE9,1,1)","v":"1900-01-01"}]
[null,"Admissão:",null,null,{"$f":"masc_termino!L8","v":"00:00:00"},null,null,null,null,null,"Saída:",null,{"$f":"masc_termino!L10","v":"00:00:00"},null,null,null,null,"Salário:",null,null,{"$f":"masc_termino!L14","v":0},null,null,null,null,null,null,null,null,"Meses trabalhados no ano",{"$f":"MONTH(AF7)+AG10","v":0},{"$f":"DAY(AF7)","v":0},{"$f":"IF(AF10<15,-1,0)","v":-1}]
[null,null,null,null,null,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érias proporcionais",{"$f":"IF(YEAR(E10)=YEAR(M10),MONTH(M10)-MONTH(E10)-1,IF(MONTH(E10)>MONTH(M10),12-MONTH(E10)+MONTH(M10)-1))+AF11","v":-1},{"$f":"IF(AG11>=15,1,0)","v":0},{"$f":"IF(DAY(E10)>DAY(M10),(DAY(AH14)-DAY(E10)+DAY(M10)+1),DAY(M10)-DAY(E10)+1)","v":1},{"$f":"IF(YEAR(E10)=YEAR(M10),0,IF(DAY(E10)>15,1,0))","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"valor dia",{"$f":"U10/30","v":0}]
[null,"Nº de pendentes no Imposto de renda:",null,null,null,null,null,null,null,null,null,null,{"$f":"masc_termino!K18","v":0},null,null,"N º de filhos no salário família:",null,null,null,null,null,null,null,null,null,{"$f":"masc_termino!I20","v":0},null,null,null,"Valor mês",{"$f":"U10/12","v":0},null,"Fim mes anterior",{"$f":"EOMONTH(M10,-1)","v":{"$error":"#NUM!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"13º","meses no ano","dias","calculo de meses no ano"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"13º",{"$f":"IF(YEAR(M10)>YEAR(E10),IF(AF16>=15,MONTH(M10),MONTH(M10)-1),MONTH(M10)-MONTH(E10))","v":0},{"$f":"IF(YEAR(E10)=YEAR(M10),IF(DAY(E10)>DAY(M10),(DAY(AH14)-DAY(E10)+DAY(M10)+1),DAY(M10)-DAY(E10)+1),DAY(M10))","v":1},{"$f":"IF(YEAR(M10)=YEAR(E10),IF(AF16>=15,AE16,AE16-1),AE16)+AH16","v":-1},{"$f":"IF(YEAR(E10)=YEAR(M10),0,IF(DAY(E10)>15,1,0))","v":0}]
[]
[null,"Saldo salário:",null,null,null,{"$f":"IF(AG6>30,30,AG6)","v":0},null,{"$f":"IF(F18=1,\"dia\",\"dias\")","v":"dias"},{"$f":"(F18*AE13)+W12","v":0},null,null,null,null,null,null,null,null,"Descontos",null,null,null,null,null,null,null,null,null,null,null,"13.o Salario",{"$f":"YEAR(AF7)-YEAR(E10)","v":0},{"$f":"IF(AE18=0,MONTH(AF7)-MONTH(E10),0)","v":0},{"$f":"IF(AE18=0,DAY(AF7)-DAY(E10),0)","v":0},{"$f":"IF(AF18>0,IF(AG18>=15,AF18,AF18-1),0)","v":0},{"$f":"DAY(AF7)","v":0},{"$f":"IF(AF18=0,MONTH(AF7),0)","v":1},{"$f":"IF(AJ18>0,IF(AI18>=15,AJ18,AJ18-1),0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"INSS","valores","porcentagem saldo","Porc 13º","13º indenizado"]
[null,{"$f":"IF(I20>0,\"13º Salário:\",\"\")","v":""},null,null,{"$f":"AF3","v":false},null,{"$f":"IF(E20>0,IF(E20=1,\"mês\",\"meses\"),\"\")","v":"meses"},null,{"$f":"AE14*E20","v":0},null,null,null,null,null,null,null,null,{"$f":"IF(X20>0,\"INSS Saldo Salário:\",\"\")","v":""},null,null,null,null,null,{"$f":"IF(AF24>0,I18*AF24,AE23)","v":0},null,null,null,null,null,"até",{"$f":"config!F72","v":1556.94},{"$f":"IF(I22<=AE20,config!M72,0)","v":0.08},{"$f":"IF(I24<=AE20,config!M72,0)","v":0.08},{"$f":"IF(I38<=AE20,config!M72,0)","v":0.08}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"até",{"$f":"config!J73","v":2594.92},{"$f":"IF(I22>AE20,IF(I22<=AE21,config!M73,0),0)","v":0},{"$f":"IF(I24>AE20,IF(I24<=AE21,config!M73,0),0)","v":0},{"$f":"IF(I38>AE20,IF(I38<=AE21,config!M73,0),0)","v":0}]
[null,{"$f":"IF(I22>0,\"Férias Proporcionais:\",\"\")","v":""},null,null,null,null,null,null,{"$f":"AE11*AE14","v":0},null,null,null,{"$f":"AF3","v":false},{"$f":"IF(M22>1,\"meses\",\"mês\")","v":"meses"},null,null,null,{"$f":"IF(X22>0,\"Inss 13º Salário:\",\"\")","v":""},null,null,null,null,null,{"$f":"IF(AG24>0,I20*AG24,AE23)","v":0},null,null,null,null,null,"até",{"$f":"config!J74","v":5189.82},{"$f":"IF(I22>AE21,IF(I22<=AE22,config!M74,0),0)","v":0},{"$f":"IF(I24>AE21,IF(I24<=AE22,config!M74,0),0)","v":0},{"$f":"IF(I38>AE21,IF(I38<=AE22,config!M74,0),0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"teto",{"$f":"AE22*11%","v":570.88019999999995},{"$f":"IF(I22>AE22,381.4,0)","v":0},{"$f":"IF(I24>AE22,381.41,0)","v":0},{"$f":"IF(I38>AE22,381.41,0)","v":0}]
[null,{"$f":"IF(I24>0,\"1/3 Férias Proporcionais:\",\"\")","v":""},null,null,null,null,null,null,{"$f":"I22/3","v":0},null,null,null,null,null,null,null,null,{"$f":"IF(X24>0,\"Contrib. Confed.:\",\"\")","v":""},null,null,null,null,null,{"$f":"IF(I18<=3000,I18*config!P6,60)","v":0},null,null,null,null,null,"Prcentagem/valor",null,{"$f":"IF(I18<=AE22,SUM(AF20:AF22),0)","v":0.08},{"$f":"IF(I20<=AE22,SUM(AG20:AG22),0)","v":0.08},{"$f":"IF(I38<=AE22,SUM(AH20:AH22),0)","v":0.08}]
[]
[null,{"$f":"IF(I26>0,\"Salário família:\",\"\")","v":""},null,null,null,null,null,null,{"$f":"SUM(AG46:AG47)","v":0},null,null,null,null,null,null,null,null,{"$f":"IF(X26>0,\"IRPF 13º:\",\"\")","v":""},null,null,null,null,null,{"$f":"SUM(AI31:AI34)","v":0},null,null,null,null,null,"IPRF"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(X28=0,\"\",\"Adiantamentos\")","v":""},null,null,null,null,null,{"$f":"masc_termino!S18","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Base, até","Alíquota","Parcela a deduzir","IPRF Salário","IPRF 13º"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(X30>0,\"IRPF Salário:\",\"\")","v":""},null,null,null,null,null,{"$f":"SUM(AH31:AH34)","v":0},null,null,null,null,null,{"$f":"config!F60","v":1903.98},{"$f":"AD30","v":1903.98},{"$f":"config!M60","v":0},{"$f":"config!P60","v":0}]
[null,null,null,null,null,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":"config!J61","v":2826.65},{"$f":"AD31","v":2826.65},{"$f":"config!M61","v":7.4999999999999997E-2},{"$f":"config!P61","v":142.80000000000001},{"$f":"IF($AE$36>$AD30,IF($AE$36<=$AE31,($AE$36*$AF31)-$AG31,0),0)","v":0},{"$f":"IF($AE$37>$AD30,IF($AE$37<=$AE31,($AE$37*$AF31)-$AG31,0),0)","v":0}]
[null,"TOTAL BRUTO:",null,null,null,null,null,{"$f":"SUM(I18:L29)","v":0},null,null,null,null,null,null,null,null,null,"TOTAL DESC.: R$",null,null,null,null,{"$f":"SUM(X20:AA30)","v":0},null,null,null,null,null,null,{"$f":"config!J62","v":3751.05},{"$f":"AD32","v":3751.05},{"$f":"config!M62","v":0.15},{"$f":"config!P62","v":354.8},{"$f":"IF(AE36>AE31,IF(AE36<=AE32,(AE36*AF32)-AG32,0),0)","v":0},{"$f":"IF($AE$37>$AD31,IF($AE$37<=$AE32,($AE$37*$AF32)-$AG32,0),0)","v":0}]
[null,null,null,null,null,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":"config!J63","v":4664.68},{"$f":"AD33","v":4664.68},{"$f":"config!M63","v":0.22500000000000001},{"$f":"config!P63","v":636.13},{"$f":"IF($AE$36>$AD32,IF($AE$36<=$AE33,($AE$36*$AF33)-$AG33,0),0)","v":0},{"$f":"IF($AE$37>$AD32,IF($AE$37<=$AE33,($AE$37*$AF33)-$AG33,0),0)","v":0}]
[null,null,null,null,null,null,null,"TOTAL A RECEBER: R$",null,null,null,null,null,{"$f":"IF(H32>W32,H32-W32,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"acima",null,{"$f":"config!M64","v":0.27500000000000002},{"$f":"config!P64","v":869.36},{"$f":"IF($AE36>$AE33,($AE36*$AF34)-$AG34,0)","v":0},{"$f":"IF(AE37>AE33,(AE37*AF34)-AG34,0)","v":0}]
[null,null,null,null,null,null,"+",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"dedução por dependente",{"$f":"config!K66","v":189.59},{"$f":"AE35*X14","v":0}]
[null,null,null,null,null,null,null,"FGTS: (valor estimado)",null,null,null,null,null,{"$f":"((U10/30)*masc_termino!N12)*8%","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"salário líquido",{"$f":"I18-X20-AF35","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"13º liquido",{"$f":"(I20+I38)-X22-AF35","v":0}]
[]
[null,{"$f":"config!E110","v":"Obs. Cálculo baseado nas informações digitadas pelo usuário do site, podendo haver diferenças."}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"sim ou não","afastamento"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"sim","Rescisão antecipada do contrato de experiência por iniciativa do empregador"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"não","Rescisão antecipada do contrato de experiência por iniciativa do empregado"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Faixa Salarial Até","Valor do benefício por filho de até 14 anos incompletos ou inválido"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"valor","valor proporcional"]
[null,null,null,null,null,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":"config!F90","v":806.8},{"$f":"config!I90","v":41.37},{"$f":"IF(U10<=AD46,Z14*AE46,0)","v":0},{"$f":"(AF46/30)*F18","v":0}]
[{"$f":"config!P104","v":"www.fecomerciarios.org.br"},null,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":"config!G105","v":0},null,null,{"$f":"config!F91","v":1212.6400000000001},{"$f":"config!I91","v":29.16},{"$f":"IF(U10>AD46,IF(U10<=AD47,Z14*AE47,0),0)","v":0},{"$f":"(AF47/30)*F18","v":0}]

{"sheet":"masc_exp2","index":7,"n_rows":24,"n_cols":23,"rows_kept":24,"cut":false,"hidden":false,"merged":[[23,0,23,19],[9,11,9,13],[10,0,10,19],[15,1,15,18],[16,1,16,18],[22,4,22,8],[11,1,11,10],[11,11,11,12],[13,8,13,10],[17,1,17,9],[19,1,19,7],[17,10,17,11],[12,0,12,19],[13,11,13,16],[14,0,14,19],[18,0,18,19],[19,8,19,9],[8,0,8,19],[9,9,9,10],[0,13,1,18],[2,13,2,18],[4,0,4,19],[6,0,6,19],[7,8,7,10],[7,11,7,13],[5,1,5,11],[5,12,5,18],[17,17,17,18]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Base de cálculo demissional"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"por parte da empresa"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"config!I101","v":"FECOMERCIÁRIOS"},null,null,null,null,null,null,null,null,"por parte do trabalhador"]
[]
[]
[null,"Rescisão antecipada do contrato de experiência:"]
[]
[null,null,null,null,null,null,null,null,"Admissão:",null,null,null,null,null,"dd/mm/aaaa (data do registro na carteira)"]
[]
[null,null,null,null,null,null,null,null,null,"Saída:",null,null,null,null,"dd/mm/aaaa (data do último dia trabalhado na empresa)"]
[]
[null,"Contrato de experiência de quantos dias?",null,null,null,null,null,null,null,null,null,null,null,"máximo 90 dias",null,null,null,{"$f":"IF(L10>L8,(L10-L8)+1,0)","v":0},{"$f":"IF(R12>=1,\"dias trabalhados\",\"\")","v":""}]
[]
[null,null,null,null,null,null,null,null,"Salário:"]
[{"$f":"IF(L12>0,IF(L12<R12,\"Datas não correspondem com o número de dias do contrato\",\"\"),\"\")","v":""}]
[]
[]
[null,"Nº dependentes no Imposto de renda:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Adiantamentos:"]
[]
[null,"Nº de filhos com salário famlía:",null,null,null,null,null,null,null,null,"Nº de filhos menores de 14 anos ,para salários até:",null,null,null,null,null,null,null,{"$f":"config!F91","v":1212.6400000000001}]
[]
[]
[]
[{"$f":"Menu!A31","v":"Planilha+ 5.1.2   .:.   Acácio Jr   .:.   unico@acaciojunior.com       -      Última atualização: 03/02/2016"}]

{"sheet":"exp2","index":8,"n_rows":47,"n_cols":37,"rows_kept":47,"cut":false,"hidden":false,"merged":[[9,23,9,26],[25,8,25,11],[27,23,27,26],[21,23,21,26],[33,22,33,26],[27,8,27,11],[33,7,33,11],[33,17,33,21],[23,8,23,11],[29,23,29,26],[10,18,10,26],[11,4,11,9],[13,1,13,11],[13,12,13,13],[13,15,13,24],[19,23,19,26],[19,12,19,13],[43,30,44,30],[35,18,35,21],[39,1,41,26],[35,8,35,11],[37,8,37,11],[43,29,44,29],[37,18,37,21],[31,23,31,26],[13,25,13,26],[25,23,25,26],[17,8,17,11],[7,14,7,20],[2,6,2,26],[4,1,4,26],[5,1,5,26],[9,4,9,8],[9,12,9,15],[9,17,9,22],[17,5,17,6],[19,4,19,5],[19,8,19,11],[23,23,23,26],[21,8,21,11],[17,17,17,26]]}
[null,{"$f":"config!I101","v":"FECOMERCIÁRIOS"}]
[null,{"$f":"config!I102","v":"Federação dos Empregados no Comércio do Estado de São Paulo"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"dias","meses"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Meses trabalhados",{"$f":"(M10-E10)+1","v":1},{"$f":"IF(AE3>=15,IF(AE3<=44,1,IF(AE3<=74,2,IF(AE3<=104,3,IF(AE3<=119,4)))))","v":false}]
[null,{"$f":"config!J103","v":"Rua dos Pinheiros, nº 20 - Pinheiros"},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":"config!H104","v":"(11) 3060 6600"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Dias de multa para termino contrato",{"$f":"(X10-M10)/2","v":-0.5}]
[null,"Base de Calculo - Rescisão de Contrato de Experiência",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"saldo de dias trabalhados",{"$f":"IF(MONTH(M10)=MONTH(E10),IF(YEAR(M10)=YEAR(E10),DAY(M10)-DAY(E10),DAY(M10)),DAY(M10))","v":0},"Saldo de dias trabalhados no mes",{"$f":"IF(MONTH(M10)=MONTH(E10),IF(YEAR(M10)=YEAR(E10),DAY(M10)-DAY(E10)+1,DAY(M10)),DAY(M10))","v":1}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Data saída  aviso",null,{"$f":"IF(O8=\"Dispensa sem justa causa\",IF(X10=\"sim\",M10,IF(X10=\"não\",(M10+30))),M10)","v":"00:00:00"},"dia",null,"Dias para 13º","meses 13º"]
[null,"Rescisão antecipada do contrato de experiência:",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"masc_exp2!M6","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Anos trabalhados",{"$f":"IF(YEAR(AF7)>YEAR(E10),(YEAR(AF7)-YEAR(E10))-AH8,0)","v":0},{"$f":"IF(AG8<=0,DAY(AF7)-DAY(E10),0)","v":0},{"$f":"MONTH(AF7)-MONTH(E10)","v":0},{"$f":"IF(AG8<0,1,IF(AF8<0,1,0))","v":0},{"$f":"DAY(AF7)-DAY(E10)","v":0},{"$f":"IF(AI8>=15,AG8+1,AG8)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ano atual",{"$f":"YEAR(M10)","v":1900},{"$f":"DATE(AE9,1,1)","v":"1900-01-01"}]
[null,"Admissão:",null,null,{"$f":"masc_exp2!L8","v":"00:00:00"},null,null,null,null,null,"Saída:",null,{"$f":"masc_exp2!L10","v":"00:00:00"},null,null,null,null,"Término do contrato:",null,null,null,null,null,{"$f":"(masc_exp2!L8+masc_exp2!L12)-1","v":-1},null,null,null,null,null,"Meses trabalhados no ano",{"$f":"MONTH(AF7)+AG10","v":0},{"$f":"DAY(AF7)","v":0},{"$f":"IF(AF10<15,-1,0)","v":-1}]
[]
[null,"Salário:",null,null,{"$f":"masc_exp2!L14","v":0},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érias proporcionais",{"$f":"IF(YEAR(E10)=YEAR(M10),IF(AG12>=15,MONTH(M10)-MONTH(E10)+1,MONTH(M10)-MONTH(E10)),IF(MONTH(E10)>MONTH(M10),12-MONTH(E10)+MONTH(M10)))","v":0},{"$f":"IF(AG12>=15,1,0)","v":0},{"$f":"IF(DAY(E10)>DAY(M10),(DAY(AG13)-DAY(E10)+DAY(M10)+1),DAY(M10)-DAY(E10)+1)","v":1},{"$f":"(AF12-AG12)+1","v":0},{"$f":"IF(AH12>=15,1,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"valor dia",{"$f":"E12/30","v":0},"Fim mes anterior",{"$f":"EOMONTH(M10,-1)","v":{"$error":"#NUM!"}}]
[null,"Nº de pendentes no Imposto de renda:",null,null,null,null,null,null,null,null,null,null,{"$f":"masc_exp2!K18","v":0},null,null,"N º de filhos no salário família:",null,null,null,null,null,null,null,null,null,{"$f":"masc_exp2!I20","v":0},null,null,null,"Valor mês",{"$f":"E12/12","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"13º","meses no ano","dias","calculo de meses no ano"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"13º",{"$f":"IF(YEAR(M10)>YEAR(E10),IF(AF16>=15,MONTH(M10),MONTH(M10)-1),IF(AF16>=15,MONTH(M10)-MONTH(E10)+1,MONTH(M10-MONTH(E10))))","v":{"$error":"#NUM!"}},{"$f":"IF(YEAR(E10)=YEAR(M10),IF(DAY(E10)>DAY(M10),(DAY(AG13)-DAY(E10)+DAY(M10)+1),DAY(M10)-DAY(E10)+1),DAY(M10))","v":1},{"$f":"IF(YEAR(M10)=YEAR(E10),IF(AF16>=15,AE16,AE16-1),AE16)+AH16","v":{"$error":"#NUM!"}},{"$f":"IF(YEAR(E10)=YEAR(M10),0,IF(DAY(E10)>15,1,0))","v":0}]
[null,null,null,null,null,null,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":"DAY(AG13)-DAY(E10)+1","v":{"$error":"#NUM!"}},{"$f":"DAY(M10)","v":0}]
[null,"Saldo salário:",null,null,null,{"$f":"IF(AG6>30,30,AG6)","v":1},null,{"$f":"IF(F18=1,\"dia\",\"dias\")","v":"dia"},{"$f":"(F18*AE13)+W12","v":0},null,null,null,null,null,null,null,null,"Descontos",null,null,null,null,null,null,null,null,null,null,null,"13.o Salario",{"$f":"YEAR(AF7)-YEAR(E10)","v":0},{"$f":"IF(AE18=0,MONTH(AF7)-MONTH(E10),0)","v":0},{"$f":"IF(AE18=0,DAY(AF7)-DAY(E10),0)","v":0},{"$f":"IF(AF18>0,IF(AG18>=15,AF18,AF18-1),0)","v":0},{"$f":"DAY(AF7)","v":0},{"$f":"IF(AF18=0,MONTH(AF7),0)","v":1},{"$f":"IF(AJ18>0,IF(AI18>=15,AJ18,AJ18-1),0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"INSS","valores","porcentagem saldo","Porc 13º","13º indenizado"]
[null,{"$f":"IF(I20>0,\"13º Salário:\",\"\")","v":""},null,null,{"$f":"AF3","v":false},null,{"$f":"IF(E20>0,IF(E20=1,\"mês\",\"meses\"),\"\")","v":"meses"},null,{"$f":"AE14*E20","v":0},null,null,null,null,null,null,null,null,{"$f":"IF(X20>0,\"INSS Saldo Salário:\",\"\")","v":""},null,null,null,null,null,{"$f":"IF(AF24>0,I18*AF24,AE23)","v":0},null,null,null,null,null,"até",{"$f":"config!F72","v":1556.94},{"$f":"IF(I22<=AE20,config!M72,0)","v":0.08},{"$f":"IF(I24<=AE20,config!M72,0)","v":0.08},{"$f":"IF(I36<=AE20,8%,0)","v":0.08}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"até",{"$f":"config!J73","v":2594.92},{"$f":"IF(I22>AE20,IF(I22<=AE21,config!M73,0),0)","v":0},{"$f":"IF(I24>AE20,IF(I24<=AE21,config!M73,0),0)","v":0},{"$f":"IF(I36>AE20,IF(I36<=AE21,9%,0),0)","v":0}]
[null,{"$f":"IF(I22>0,\"Férias Proporcionais:\",\"\")","v":""},null,null,null,null,null,null,{"$f":"AE12*AE14","v":0},null,null,null,{"$f":"AF3","v":false},{"$f":"IF(M22>1,\"meses\",\"mês\")","v":"meses"},null,null,null,{"$f":"IF(X22>0,\"Inss 13º Salário:\",\"\")","v":""},null,null,null,null,null,{"$f":"IF(AG24>0,I20*AG24,AE23)","v":0},null,null,null,null,null,"até",{"$f":"config!J74","v":5189.82},{"$f":"IF(I22>AE21,IF(I22<=AE22,config!M74,0),0)","v":0},{"$f":"IF(I24>AE21,IF(I24<=AE22,config!M74,0),0)","v":0},{"$f":"IF(I36>AE21,IF(I36<=AE22,11%,0),0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"teto",{"$f":"AE22*11%","v":570.88019999999995},{"$f":"IF(I22>AE22,381.4,0)","v":0},{"$f":"IF(I24>AE22,381.41,0)","v":0},{"$f":"IF(I36>AE22,381.41,0)","v":0}]
[null,{"$f":"IF(I24>0,\"1/3 Férias Proporcionais:\",\"\")","v":""},null,null,null,null,null,null,{"$f":"I22/3","v":0},null,null,null,null,null,null,null,null,{"$f":"IF(X24>0,\"Contrib. Confed.:\",\"\")","v":""},null,null,null,null,null,{"$f":"IF(I18<=3000,I18*config!P6,60)","v":0},null,null,null,null,null,"Prcentagem/valor",null,{"$f":"IF(I18<=AE22,SUM(AF20:AF22),0)","v":0.08},{"$f":"IF(I20<=AE22,SUM(AG20:AG22),0)","v":0.08},{"$f":"IF(I36<=AE22,SUM(AH20:AH22),0)","v":0.08}]
[]
[null,{"$f":"IF(I26>0,\"Quebra de contrato:\",\"\")","v":""},null,null,null,null,null,null,{"$f":"IF(O8=\"por parte da empresa\",AE5*AE13,0)","v":0},null,null,null,null,null,null,null,null,{"$f":"IF(X26>0,\"Quebra de contrato:\",\"\")","v":""},null,null,null,null,null,{"$f":"IF(O8=\"por parte do trabalhador\",AE5*AE13,0)","v":0},null,null,null,null,null,"IPRF"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Base, até","Alíquota","Parcela a deduzir","IPRF Salário","IPRF 13º"]
[null,{"$f":"IF(I28>0,\"Salário família:\",\"\")","v":""},null,null,null,null,null,null,{"$f":"SUM(AG46:AG47)","v":0},null,null,null,null,null,null,null,null,{"$f":"IF(X28>0,\"IRPF 13º:\",\"\")","v":""},null,null,null,null,null,{"$f":"SUM(AI29:AI32)","v":0},null,null,null,null,null,{"$f":"config!F60","v":1903.98},{"$f":"AD28","v":1903.98},{"$f":"config!M60","v":0},{"$f":"config!P60","v":0}]
[null,null,null,null,null,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":"config!J61","v":2826.65},{"$f":"AD29","v":2826.65},{"$f":"config!M61","v":7.4999999999999997E-2},{"$f":"config!P61","v":142.80000000000001},{"$f":"IF($AE$36>$AD28,IF($AE$36<=$AE29,($AE$36*$AF29)-$AG29,0),0)","v":0},{"$f":"IF($AE$37>$AD28,IF($AE$37<=$AE29,($AE$37*$AF29)-$AG29,0),0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(X30>0,\"IRPF Salário:\",\"\")","v":""},null,null,null,null,null,{"$f":"SUM(AH29:AH32)","v":0},null,null,null,null,null,{"$f":"config!J62","v":3751.05},{"$f":"AD30","v":3751.05},{"$f":"config!M62","v":0.15},{"$f":"config!P62","v":354.8},{"$f":"IF(AE36>AE29,IF(AE36<=AE30,(AE36*AF30)-AG30,0),0)","v":0},{"$f":"IF($AE$37>$AD29,IF($AE$37<=$AE30,($AE$37*$AF30)-$AG30,0),0)","v":0}]
[null,null,null,null,null,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":"config!J63","v":4664.68},{"$f":"AD31","v":4664.68},{"$f":"config!M63","v":0.22500000000000001},{"$f":"config!P63","v":636.13},{"$f":"IF($AE$36>$AD30,IF($AE$36<=$AE31,($AE$36*$AF31)-$AG31,0),0)","v":0},{"$f":"IF($AE$37>$AD30,IF($AE$37<=$AE31,($AE$37*$AF31)-$AG31,0),0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(X32=0,\"\",\"Adiantamentos\")","v":""},null,null,null,null,null,{"$f":"masc_exp2!R18","v":0},null,null,null,null,null,"acima",null,{"$f":"config!M64","v":0.27500000000000002},{"$f":"config!P64","v":869.36},{"$f":"IF($AE36>$AE31,($AE36*$AF32)-$AG32,0)","v":0},{"$f":"IF(AE37>AE31,(AE37*AF32)-AG32,0)","v":0}]
[]
[null,"TOTAL BRUTO:",null,null,null,null,null,{"$f":"I28+I26+I24+I22+I20+I18","v":0},null,null,null,null,null,null,null,null,null,"TOTAL DESC.: R$",null,null,null,null,{"$f":"X30+X28+X26+X24+X22+X20+X32","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"dedução por dependente",{"$f":"config!K66","v":189.59},{"$f":"AE35*X14","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"TOTAL A RECEBER: R$",null,null,null,null,null,{"$f":"IF(H34>W34,H34-W34,0)","v":0},null,null,null,null,null,null,null,null,null,null,"salário líquido",{"$f":"I18-X20-AF35","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,"+",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"13º liquido",{"$f":"(I20+I36)-X22-AF35","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(O8=\"por parte da empresa\",\"FGTS: (valor estimado)\",\"\")","v":""},null,null,null,null,null,{"$f":"IF(M38=\"\",\"\",((E12/30)*masc_exp2!L12)*8%)","v":""}]
[]
[null,{"$f":"config!E110","v":"Obs. Cálculo baseado nas informações digitadas pelo usuário do site, podendo haver diferenças."},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"sim ou não","afastamento"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"sim","Rescisão antecipada do contrato de experiência por iniciativa do empregador"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"não","Rescisão antecipada do contrato de experiência por iniciativa do empregado"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Faixa Salarial Até","Valor do benefício por filho de até 14 anos incompletos ou inválido"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"valor","valor proporcional"]
[{"$f":"config!P104","v":"www.fecomerciarios.org.br"},null,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":"config!G105","v":0},null,null,{"$f":"config!F90","v":806.8},{"$f":"config!I90","v":41.37},{"$f":"IF(E12<=AD46,Z14*AE46,0)","v":0},{"$f":"(AF46/30)*F18","v":0}]
[null,null,null,null,null,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":"config!F91","v":1212.6400000000001},{"$f":"config!I91","v":29.16},{"$f":"IF(E12>AD46,IF(E12<=AD47,Z14*AE47,0),0)","v":0},{"$f":"(AF47/30)*F18","v":0}]

{"sheet":"config","index":9,"n_rows":115,"n_cols":39,"rows_kept":115,"cut":false,"hidden":false,"merged":[[101,27,101,28],[101,29,101,30],[102,27,102,28],[102,29,102,30],[99,27,99,31],[7,15,7,17],[5,15,5,17],[15,25,15,26],[99,4,99,8],[82,30,82,32],[79,4,79,15],[59,15,59,17],[65,10,65,12],[81,19,81,20],[81,21,81,22],[82,16,82,18],[71,5,71,7],[72,5,72,7],[73,5,73,7],[71,12,71,13],[75,14,75,15],[61,15,61,17],[62,15,62,17],[44,8,44,11],[108,4,108,10],[14,4,15,24],[82,25,82,26],[60,12,60,13],[61,12,61,13],[62,12,62,13],[63,12,63,13],[61,9,61,11],[62,9,62,11],[19,25,19,26],[20,25,20,26],[18,20,18,24],[63,15,63,17],[21,25,21,26],[59,12,59,13],[72,12,72,13],[73,12,73,13],[82,23,82,24],[60,15,60,17],[19,20,19,24],[83,18,83,20],[94,10,94,12],[69,4,69,10],[57,4,57,10],[109,4,109,27],[17,20,17,21],[18,25,18,26],[100,8,100,18],[101,8,101,23],[102,9,102,23],[103,7,103,12],[103,15,103,23],[104,6,104,15],[89,5,89,7],[90,5,90,7],[89,8,89,10],[90,8,90,10],[94,15,94,16],[87,4,87,9],[18,4,21,18],[20,19,20,24],[21,19,21,24],[45,4,45,7],[46,4,46,7],[47,4,47,7],[48,4,48,7],[49,4,49,7],[40,4,40,7],[0,4,0,7],[81,5,81,7],[82,5,82,7],[83,6,83,8],[82,9,82,11],[59,9,59,11],[60,9,60,11],[72,9,72,11],[73,9,73,11],[59,5,59,7],[63,7,63,9],[60,5,60,7],[61,5,61,7],[62,5,62,7],[4,3,4,15],[10,3,10,15],[50,4,50,7],[51,4,51,7],[34,8,34,11],[29,8,29,11],[25,4,25,11],[51,8,51,11],[29,4,29,7],[9,15,9,17],[45,8,45,11],[46,8,46,11],[47,8,47,11],[35,8,35,11],[36,8,36,11],[31,4,31,7],[32,4,32,7],[33,4,33,7],[34,4,34,7],[35,4,35,7],[36,4,36,7],[37,4,37,7],[48,8,48,11],[30,4,30,7],[44,4,44,7],[38,4,38,7],[39,4,39,7],[43,8,43,11],[52,11,52,12],[27,4,27,6],[27,7,27,11],[49,8,49,11],[40,8,40,11],[41,8,41,11],[42,8,42,11],[30,8,30,11],[31,8,31,11],[32,8,32,11],[33,8,33,11],[50,8,50,11],[37,8,37,11],[38,8,38,11],[39,8,39,11],[41,4,41,7],[42,4,42,7],[43,4,43,7]]}
[null,null,null,null,"Configuração"]
[]
[null,null,null,null,"Configuração para cálculos rescisórios"]
[]
[]
[null,null,null,null,"Contribuição Confederativa/Assistencial:",null,null,null,null,null,null,null,null,null,null,0.01]
[]
[null,null,null,null,"Calcula sobre outros (valores adicionais do mês)?",null,null,null,null,null,null,null,null,null,null,"Sim"]
[]
[null,null,null,null,"Valor limite de desconto:"]
[]
[]
[]
[null,null,null,null,"Aviso prévio proporcional além da lei. N 12.506"]
[null,null,null,null,"Os empregados dispensandos sem justa causa terão direito de 01 (um) dia em pecúnia, no aviso prévio legal, por ano completo de serviço na mesma empresa? (além dos 3 dias já previsto em lei)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Não",null,null,null,null,null,null,null,null,null,null,null,null,"Sim"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Não"]
[]
[null,null,null,null,"Aos empregados com certa idade e certo tempo de contrato de trabalho na mesma empresa, dispensados sem justa causa, o aviso prévio terá acréscimo?",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Existe o benefício?",null,null,null,null,"Sim"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"A partir de que idade?",null,null,null,null,50]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Anos de trabalho na empresa",null,null,null,null,null,20]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Dias de acréscimo no aviso",null,null,null,null,null,15]
[]
[]
[]
[null,null,null,null,"Tabela de contagem do acréscimo ao tempo de aviso prévio - Lei nº 12.506 de 11 de outubro de 2011"]
[]
[null,null,null,null,"Parâmetro:",null,null,"Ano + 1 dia",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Parâmetro"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ano Completo"]
[null,null,null,null,"Tempo de serviço, Ano completo",null,null,null,"Aviso Prévio, dias",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ano + 1 dia"]
[null,null,null,null,0,null,null,null,30,null,null,null,{"$f":"E31","v":0}]
[null,null,null,null,1,null,null,null,33,null,null,null,{"$f":"E32","v":1}]
[null,null,null,null,2,null,null,null,36,null,null,null,2]
[null,null,null,null,3,null,null,null,{"$f":"IF((I33-I32)+(I33)<90,(I33-I32)+(I33),90)","v":39},null,null,null,3]
[null,null,null,null,4,null,null,null,{"$f":"IF((I34-I33)+(I34)<90,(I34-I33)+(I34),90)","v":42},null,null,null,4]
[null,null,null,null,5,null,null,null,45,null,null,null,5]
[null,null,null,null,6,null,null,null,48,null,null,null,6]
[null,null,null,null,7,null,null,null,51,null,null,null,7]
[null,null,null,null,8,null,null,null,54,null,null,null,8]
[null,null,null,null,9,null,null,null,57,null,null,null,9]
[null,null,null,null,10,null,null,null,60,null,null,null,10]
[null,null,null,null,11,null,null,null,63,null,null,null,11]
[null,null,null,null,12,null,null,null,66,null,null,null,12]
[null,null,null,null,13,null,null,null,69,null,null,null,13]
[null,null,null,null,14,null,null,null,72,null,null,null,14]
[null,null,null,null,15,null,null,null,75,null,null,null,15]
[null,null,null,null,16,null,null,null,78,null,null,null,16]
[null,null,null,null,17,null,null,null,81,null,null,null,17]
[null,null,null,null,18,null,null,null,84,null,null,null,18]
[null,null,null,null,19,null,null,null,87,null,null,null,19]
[null,null,null,null,20,null,null,null,90,null,null,null,20]
[null,null,null,null,21,null,null,null,90,null,null,null,21]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(90,I31:M52,5,FALSE)","v":20}]
[]
[]
[]
[]
[null,null,null,null,"Imposto de renda na fonte"]
[null,null,null,null,"Base de cálculo (R$)",null,null,null,null,null,null,null,"Alíquota (%)",null,null,"Parcela a deduzir do imposto (R$)"]
[null,null,null,null,"até",1903.98,null,null,null,null,null,null,0,null,null,0]
[null,null,null,null,"de",{"$f":"F60+0.01","v":1903.99},null,null,"até",2826.65,null,null,7.4999999999999997E-2,null,null,142.80000000000001]
[null,null,null,null,"de",{"$f":"J61+0.01","v":2826.6600000000003},null,null,"até",3751.05,null,null,0.15,null,null,354.8]
[null,null,null,null,"de",{"$f":"J62+0.01","v":3751.0600000000004},null,null,"até",4664.68,null,null,0.22500000000000001,null,null,636.13]
[null,null,null,null,"Acima de",null,null,{"$f":"J63","v":4664.68},null,null,null,null,0.27500000000000002,null,null,869.36]
[]
[null,null,null,null,"Dedução por dependente:",null,null,null,null,null,189.59]
[]
[]
[]
[null,null,null,null,"Tabela de desconto de INSS"]
[null,null,null,null,"Salário",null,null,null,null,null,null,null,"Alíquota para fins de recolhimento (%)"]
[null,null,null,null,"até",1556.94,null,null,null,null,null,null,0.08]
[null,null,null,null,"de",{"$f":"F72+0.01","v":1556.95},null,null,"até",2594.92,null,null,0.09]
[null,null,null,null,"de",{"$f":"J73+0.01","v":2594.9300000000003},null,null,"até",5189.82,null,null,0.11]
[]
[null,null,null,null,"Desconta INSS sobre aviso prévio indenizado?",null,null,null,null,null,null,null,null,null,"Sim"]
[]
[]
[]
[null,null,null,null,"Tabela para cálculo do benefício Seguro Desemprego"]
[null,null,null,null,"Faixas de salário médio",null,null,null,null,null,null,null,"Valor da parcela"]
[null,null,null,null,"até",1360.7,null,null,null,null,null,null,"Multiplica-se salário médio por",null,null,null,null,null,null,0.8,null,{"$f":"T82*100%","v":0.8}]
[null,null,null,null,"de",{"$f":"F82+0.01","v":1360.71},null,null,"até",2268.0500000000002,null,null,"O que exceder a",null,null,null,1360.7,null,null,"multiplica-se por",null,null,null,0.5,null,{"$f":"X83*100%","v":0.5},null,"e soma-se a",null,null,1088.56]
[null,null,null,null,"acima de",null,{"$f":"J83","v":2268.0500000000002},null,null,null,null,null,"O valor da parcela será de",null,null,null,null,null,1542.24,null,null,"invariavelmente"]
[]
[]
[]
[null,null,null,null,"Tabela de salário família"]
[null,null,null,null,"Faixa Salarial",null,null,null,"Valor da cota por filho menor de 14 anos"]
[null,null,null,null,"até",806.8,null,null,41.37]
[null,null,null,null,"até",1212.6400000000001,null,null,29.16]
[]
[]
[]
[null,null,null,null,"Valor do Salário Mínimo:",null,null,null,null,null,880]
[]
[]
[]
[]
[null,null,null,null,"Dados do Sindicato",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Data Base da categoria"]
[null,null,null,null,"Nome Fantasia:",null,null,null,"FECOMERCIÁRIOS"]
[null,null,null,null,"Razão Social:",null,null,null,"Federação dos Empregados no Comércio do Estado de São Paulo",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Dia",null,"Mês"]
[null,null,null,null,"Endereço completo:",null,null,null,null,"Rua dos Pinheiros, nº 20 - Pinheiros",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,null,9]
[null,null,null,null,"Telefones:",null,null,"(11) 3060 6600",null,null,null,null,null,null,"Site:","www.fecomerciarios.org.br"]
[null,null,null,null,"E-mail:"]
[]
[]
[]
[null,null,null,null,"Informação/Nota do rodapé"]
[null,null,null,null,"Obs. Cálculo baseado nas informações digitadas pelo usuário do site, podendo haver diferenças."]
[]
[]
[]
[null,null,null,"Cálculo básico de rescisão de contrato de trabalho e seguro desemprego"]
[null,null,null,"Desenvolvido pro: Acácio Júnior  - adm@sincomerciarios.org.br"]