{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["EXEMPLO DE CÁLCULO","SIMULADOR","REL-FUNCIONÁRIO"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":4,"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":"EXEMPLO DE CÁLCULO","index":0,"n_rows":21,"n_cols":7,"rows_kept":21,"cut":false,"hidden":false,"merged":[[16,1,16,5],[17,1,17,5],[18,1,18,5],[19,1,19,5],[20,1,20,5],[15,1,15,6],[1,3,1,10],[3,4,3,6],[9,4,9,10],[10,4,10,5],[10,6,10,10],[7,1,8,2],[3,1,3,2],[11,4,11,5],[11,6,11,10],[12,4,12,5],[12,6,12,10],[13,4,13,5],[13,6,13,10]]}
[]
[null,null,null,"SIMULADOR DE CÁLCULO COM BASE NA MP-936\nATENÇÃO: ESTE SIMULADOR É APENAS PARA EXEMPLIFICAR OS CÁLCULOS (APROXIMADOS) COM BASE NA MP-936.\nNÃO NOS RESPONSABILIZAMOS POR EVENTUAIS ERROS DE CÁLCULO NA PLANILHA, BEM COMO \nPOR QUAISQUER PREJUÍZOS PROVENIENTES DA TOMADA DE DECISÃO COM BASE NESTAS SIMULAÇÕES."]
[]
[null,"PARÂMETROS DA SIMULAÇÃO",null,null,"OPÇÕES REDUÇÃO DE JORNADA"]
[null,"SALÁRIO BASE",2300,null,"REDUÇÃO","EMPRESA","BENEF. GOV."]
[null,"RED. JORNADA",0.5,null,0.25,0.75,0.25]
[null,null,null,null,0.5,0.5,0.5]
[null,"Faixas do\nSeguro Desemprego",null,null,0.7,0.3,0.7]
[]
[null,"Faixa 1 (Máx.)",1599.61,null,"REGRAS PARA O CÁLCULO DO SEGURO DESEMPREGO"]
[null,"Faixa 2 (Máx.)",2666.29,null,"FAIXAS DE SALÁRIO MÉDIO",null,"VALOR DA PARCELA"]
[null,"Faixa 2 (Soma)",1279.69,null,"Até R$ 1.599,61",null,"Multiplica-se o salário médio por 0,8 (80%)"]
[null,"Piso",1045,null,"De R$ 1.599,62 até R$ 2.666,29",null,"O que exceder a R$ 1.599,61 multiplicar por 0,5 (50%) e somar a R$ 1.279,69"]
[null,"Teto",1813.03,null,"Acima de R$ 2.666,29",null,"O valor da parcela será de R$ 1.813,03"]
[]
[null,"RESUMO DO CÁLCULO DO SALÁRIO"]
[null,"VALOR DO SEGURO DESEMPREGO",null,null,null,null,{"$f":"TRUNC(IF(C5>C11,C14,IF(C5>C10,C12+0.5*(C5-C10),IF(0.8*C5<C13,C13,0.8*C5))),2)","v":1629.88}]
[null,"VALOR QUE SERÁ PAGO PELO EMPREGADOR",null,null,null,null,{"$f":"(1-VLOOKUP($C$6,$E$6:$G$8,3,0))*C5","v":1150}]
[null,"VALOR DO BENEFÍCIO EMERGENCIAL (PROPORCIONAL A REDUÇÃO)",null,null,null,null,{"$f":"VLOOKUP($C$6,$E$6:$G$8,3,0)*G17","v":814.94}]
[null,"VALOR TOTAL DO SALÁRIO",null,null,null,null,{"$f":"G19+G18","v":1964.94}]
[null,"REDUÇÃO DA RENDA MENSAL",null,null,null,null,{"$f":"1-G20/C5","v":0.14567826086956515}]

{"sheet":"SIMULADOR","index":1,"n_rows":424,"n_cols":21,"rows_kept":424,"cut":false,"hidden":false,"merged":[[21,18,21,20],[22,18,23,18],[22,19,23,19],[22,20,23,20],[5,2,5,6],[7,10,8,11],[5,8,5,20],[21,14,23,14],[21,15,23,15],[21,8,23,8],[21,9,23,9],[21,12,23,12],[21,3,23,3],[21,2,23,2],[21,16,22,17],[21,10,21,11],[21,1,23,1],[21,5,23,5],[21,13,23,13],[21,4,23,4],[21,6,23,6],[21,7,23,7],[22,10,23,10],[22,11,23,11],[3,19,3,20],[1,2,1,3],[7,6,7,8],[7,2,7,4],[16,13,16,17],[7,13,7,18],[11,13,11,17],[12,13,12,17],[13,13,13,17],[14,13,14,17],[15,13,15,17],[8,13,8,17],[9,13,9,17],[10,13,10,17],[1,6,1,7],[3,5,3,18]]}
[]
[null,null,"HABILITA/DESABILITA CORES",null,true,null,"ÚLTIMA LINHA PREENCHIDA",null,{"$f":"MAX(C3:U3)","v":{"$error":"#N/A"}}]
[null,null,{"$f":"LOOKUP(2,1/--(C25:C424<>\"\"),ROW(C25:C424))","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,"SIMULADOR DE CÁLCULO COM BASE NA MP-936\nATENÇÃO: ESTE SIMULADOR É APENAS PARA EXEMPLIFICAR OS CÁLCULOS (APROXIMADOS) COM BASE NA MP-936.\nNÃO NOS RESPONSABILIZAMOS POR EVENTUAIS ERROS DE CÁLCULO NA PLANILHA, BEM COMO\nPOR QUAISQUER PREJUÍZOS PROVENIENTES DA TOMADA DE DECISÃO COM BASE NESTAS SIMULAÇÕES.",null,null,null,null,null,null,null,null,null,null,null,null,null,"TECLE\nCTRL+SHIFT+J\nPARA\nOMITIR/MOSTRAR\nO RESUMO"]
[]
[null,null,"INFORME SE A EMPRESA FATURA MAIS DE 4.800.000 POR ANO:",null,null,null,null,null,{"$f":"IF(AND(E20>0,AND(H6<>\"S\",H6<>\"N\")),\"  <= ATENÇÃO: INFORME SE A EMPRESA FATURA OU NÃO MAIS DE R$ 4.800.000 POR ANO\",\"\")","v":""}]
[]
[null,null,"CRITÉRIOS DE CLASSIFICAÇÃO",null,null,null,"OPÇÕES REDUÇÃO DE JORNADA",null,null,null,"Faixas do\nSeguro Desemprego",null,null,"RESUMO DA SIMULAÇÃO"]
[null,null,"CRITÉRIOS","COLUNA","ORDEM",null,"REDUÇÃO","EMPRESA","GOV.",null,null,null,null,"VALOR DA FOLHA ANTES DA MP-936: (1)",null,null,null,null,{"$f":"E20","v":0}]
[null,{"$f":"IF(D10<>\"\",IF(OR(D10=D11,D10=D12,D10=D13,D10=D14),1,0),0)","v":0},1,null,null,null,0.25,0.75,0.25,null,"Faixa 1 (Máx.)",1599.61,null,"VALOR DA FOLHA APÓS MP-936 (SEM AJUDA COMP. MENSAL): (2)",null,null,null,null,{"$f":"K20","v":0}]
[null,{"$f":"IF(D11<>\"\",IF(OR(D11=D12,D11=D13,D11=D14,D11=D10),1,0),0)","v":0},2,null,null,null,0.5,0.5,0.5,null,"Faixa 2 (Máx.)",2666.29,null,"VALOR DA AJUDA COMP. MENSAL (OPCIONAL): (5)",null,null,null,null,{"$f":"R20","v":0}]
[null,{"$f":"IF(D12<>\"\",IF(OR(D12=D13,D12=D14,D12=D10,D12=D11),1,0),0)","v":0},3,null,null,null,0.7,0.3,0.7,null,"Faixa 2 (Soma)",1279.69,null,"VALOR DA FOLHA APÓS MP-936 (COM AJUDA COMP. MENSAL): (2+5)",null,null,null,null,{"$f":"SUM(S10:S11)","v":0},{"$f":"IF($S$9>0,S12/$S$9,\"\")","v":""}]
[null,{"$f":"IF(D13<>\"\",IF(OR(D13=D14,D13=D10,D13=D11,D13=D12),1,0),0)","v":0},4,null,null,null,"SUSPENSÃO",{"$f":"IF(H6=\"N\",0,0.3)","v":0.3},{"$f":"IF(H6=\"N\",1,0.7)","v":0.7},null,"Piso",1045,null,"BENEFÍCIO PAGO PELO GOVERNO: (4)",null,null,null,null,{"$f":"M20","v":0},""]
[null,{"$f":"IF(D14<>\"\",IF(OR(D14=D10,D14=D11,D14=D12,D14=D13),1,0),0)","v":0},5,null,null,null,"INTEGRAL",1,0,null,"Teto",1813.03,null,"TOTAL DAS PERDAS DOS FUNCIONÁRIOS: (6)",null,null,null,null,{"$f":"T20","v":0},""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"VALOR SUJEITO A FINANCIAMENTO (PARTE DA EMPRESA): (3)",null,null,null,null,{"$f":"L20","v":0},""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"VALOR NÃO SUJEITO A FINANCIAMENTO: ( (2-3)+5 )",null,null,null,null,{"$f":"K20-L20+R20","v":0},""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"ECONOMIA COM A FOLHA APÓS MP-936: (4+6)",null,null,null,null,{"$f":"M20+T20","v":0},""]
[]
[null,null,null,null,1,null,null,null,null,null,2,3,4,null,null,null,"% PADRÃO",5,null,6]
[null,null,null,null,{"$f":"SUM(E25:E424)","v":0},null,null,null,null,null,{"$f":"SUM(K25:K424)","v":0},{"$f":"SUM(L25:L424)","v":0},{"$f":"SUM(M25:M424)","v":0},null,null,null,0,{"$f":"SUM(R25:R424)","v":0},null,{"$f":"SUM(T25:T424)","v":0}]
[null,"A","B","C","D","E","F","G","H","I","J","K","L","M","N","O","P","Q","R","S","T"]
[null,"SEQ.","NOME","REC. BENEF.\nCONTINUADO\n(S/N)","SALÁRIO\nBASE","SETOR\n(OPCIONAL)","OPÇÃO\nDE CARGA\nHORÁRIA","%\nPAGO\nP/EMPR.","%\nPAGO\nP/GOV.","VALOR\nSEGURO\nDESEMPR.","VALOR PAGO PELA EMPR.",null,"VALOR\nPAGO\nPELO GOV.","NOVO\nSALÁRIO","VALOR\nDA\nREDUÇÃO","%\nDA\nREDUÇÃO","AJUDA COMPENSATÓRIA\nMENSAL",null,"VLRs INCLUINDO AJUDA COMP. MENSAL"]
[null,null,null,null,null,null,null,null,null,null,"VLR REF. %\nPG P/EMPR.","LIMITE A\nFINANCIAR",null,null,null,null,null,null,"SALÁRIO\nTOTAL","VALOR DA\nREDUÇÃO","% DA\nREDUÇÃO"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"% INDIV.","VALOR"]
[{"$f":"IF(COUNTA(C25:E25,G25)<4,1,0)","v":1},1,null,null,null,null,null,{"$f":"IF(A25,\"\",VLOOKUP(G25,$G$10:$I$14,2,0))","v":""},{"$f":"IF(A25,\"\",IF(D25=\"S\",0,VLOOKUP(G25,$G$10:$I$14,3,0)))","v":""},{"$f":"IF(A25,\"\",TRUNC(IF(E25>$L$11,$L$14,IF(E25>$L$10,$L$12+0.5*(E25-$L$10),IF(0.8*E25<$L$13,$L$13,0.8*E25))),2))","v":""},{"$f":"IF(A25,\"\",E25*H25)","v":""},{"$f":"IF(A25,\"\",IF(K25>2090,2090,K25))","v":""},{"$f":"IF(A25,\"\",I25*J25)","v":""},{"$f":"IF(A25,\"\",K25+M25)","v":""},{"$f":"IF(A25,\"\",E25-N25)","v":""},{"$f":"IF(A25,\"\",1-(N25/E25))","v":""},null,{"$f":"IF(A25,\"\",IF(Q25>0,(E25-N25)*Q25,(E25-N25)*$Q$20))","v":""},{"$f":"IF(A25,\"\",N25+R25)","v":""},{"$f":"IF(A25,\"\",E25-S25)","v":""},{"$f":"IF(A25,\"\",1-(S25/E25))","v":""}]
[{"$f":"IF(COUNTA(C26:E26,G26)<4,1,0)","v":1},2,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,3,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,4,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,5,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,6,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,7,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,8,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,9,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,10,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,11,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,12,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,13,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,14,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,15,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,16,null,null,null,null,null,{"$f":"IF(A40,\"\",VLOOKUP(G40,$G$10:$I$14,2,0))","v":""},{"$f":"IF(A40,\"\",IF(D40=\"S\",0,VLOOKUP(G40,$G$10:$I$14,3,0)))","v":""},{"$f":"IF(A40,\"\",TRUNC(IF(E40>$L$11,$L$14,IF(E40>$L$10,$L$12+0.5*(E40-$L$10),IF(0.8*E40<$L$13,$L$13,0.8*E40))),2))","v":""},{"$f":"IF(A40,\"\",E40*H40)","v":""},{"$f":"IF(A40,\"\",IF(K40>2090,2090,K40))","v":""},{"$f":"IF(A40,\"\",I40*J40)","v":""},{"$f":"IF(A40,\"\",K40+M40)","v":""},{"$f":"IF(A40,\"\",E40-N40)","v":""},{"$f":"IF(A40,\"\",1-(N40/E40))","v":""},null,{"$f":"IF(A40,\"\",IF(Q40>0,(E40-N40)*Q40,(E40-N40)*$Q$20))","v":""},{"$f":"IF(A40,\"\",N40+R40)","v":""},{"$f":"IF(A40,\"\",E40-S40)","v":""},""]
[1,17,null,null,null,null,null,{"$f":"IF(A41,\"\",VLOOKUP(G41,$G$10:$I$14,2,0))","v":""},{"$f":"IF(A41,\"\",IF(D41=\"S\",0,VLOOKUP(G41,$G$10:$I$14,3,0)))","v":""},{"$f":"IF(A41,\"\",TRUNC(IF(E41>$L$11,$L$14,IF(E41>$L$10,$L$12+0.5*(E41-$L$10),IF(0.8*E41<$L$13,$L$13,0.8*E41))),2))","v":""},{"$f":"IF(A41,\"\",E41*H41)","v":""},{"$f":"IF(A41,\"\",IF(K41>2090,2090,K41))","v":""},{"$f":"IF(A41,\"\",I41*J41)","v":""},{"$f":"IF(A41,\"\",K41+M41)","v":""},{"$f":"IF(A41,\"\",E41-N41)","v":""},{"$f":"IF(A41,\"\",1-(N41/E41))","v":""},null,{"$f":"IF(A41,\"\",IF(Q41>0,(E41-N41)*Q41,(E41-N41)*$Q$20))","v":""},{"$f":"IF(A41,\"\",N41+R41)","v":""},{"$f":"IF(A41,\"\",E41-S41)","v":""},""]
[1,18,null,null,null,null,null,{"$f":"IF(A42,\"\",VLOOKUP(G42,$G$10:$I$14,2,0))","v":""},{"$f":"IF(A42,\"\",IF(D42=\"S\",0,VLOOKUP(G42,$G$10:$I$14,3,0)))","v":""},"",{"$f":"IF(A42,\"\",E42*H42)","v":""},"",{"$f":"IF(A42,\"\",I42*J42)","v":""},"",{"$f":"IF(A42,\"\",E42-N42)","v":""},{"$f":"IF(A42,\"\",1-(N42/E42))","v":""},null,{"$f":"IF(A42,\"\",IF(Q42>0,(E42-N42)*Q42,(E42-N42)*$Q$20))","v":""},{"$f":"IF(A42,\"\",N42+R42)","v":""},{"$f":"IF(A42,\"\",E42-S42)","v":""},{"$f":"IF(A42,\"\",1-(S42/E42))","v":""}]
[1,19,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,20,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,21,null,null,null,null,null,{"$f":"IF(A45,\"\",VLOOKUP(G45,$G$10:$I$14,2,0))","v":""},{"$f":"IF(A45,\"\",IF(D45=\"S\",0,VLOOKUP(G45,$G$10:$I$14,3,0)))","v":""},"",{"$f":"IF(A45,\"\",E45*H45)","v":""},"",{"$f":"IF(A45,\"\",I45*J45)","v":""},"",{"$f":"IF(A45,\"\",E45-N45)","v":""},{"$f":"IF(A45,\"\",1-(N45/E45))","v":""},null,{"$f":"IF(A45,\"\",IF(Q45>0,(E45-N45)*Q45,(E45-N45)*$Q$20))","v":""},{"$f":"IF(A45,\"\",N45+R45)","v":""},{"$f":"IF(A45,\"\",E45-S45)","v":""},{"$f":"IF(A45,\"\",1-(S45/E45))","v":""}]
[1,22,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,23,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,24,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,25,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,26,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,27,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,28,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,29,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,30,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,31,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,32,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,33,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,34,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,35,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,36,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,37,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,38,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,39,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,40,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,41,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,42,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,43,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,44,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,45,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,46,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,47,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,48,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,49,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,50,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,51,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,52,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,53,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,54,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,55,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,56,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,57,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,58,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,59,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,60,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,61,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,62,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,63,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,64,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,65,null,null,null,null,null,{"$f":"IF(A89,\"\",VLOOKUP(G89,$G$10:$I$14,2,0))","v":""},{"$f":"IF(A89,\"\",IF(D89=\"S\",0,VLOOKUP(G89,$G$10:$I$14,3,0)))","v":""},{"$f":"IF(A89,\"\",TRUNC(IF(E89>$L$11,$L$14,IF(E89>$L$10,$L$12+0.5*(E89-$L$10),IF(0.8*E89<$L$13,$L$13,0.8*E89))),2))","v":""},{"$f":"IF(A89,\"\",E89*H89)","v":""},"",{"$f":"IF(A89,\"\",I89*J89)","v":""},"",{"$f":"IF(A89,\"\",E89-N89)","v":""},{"$f":"IF(A89,\"\",1-(N89/E89))","v":""},null,{"$f":"IF(A89,\"\",IF(Q89>0,(E89-N89)*Q89,(E89-N89)*$Q$20))","v":""},{"$f":"IF(A89,\"\",N89+R89)","v":""},{"$f":"IF(A89,\"\",E89-S89)","v":""},{"$f":"IF(A89,\"\",1-(S89/E89))","v":""}]
[{"$f":"IF(COUNTA(C90:E90,G90)<4,1,0)","v":1},66,null,null,null,null,null,"","","","",{"$f":"IF(A90,\"\",IF(K90>2090,2090,K90))","v":""},"","","","",null,"","","",""]
[1,67,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,68,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,69,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,70,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,71,null,null,null,null,null,"","","","","","",{"$f":"IF(A95,\"\",K95+M95)","v":""},"","",null,"","","",""]
[1,72,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,73,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,74,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,75,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,76,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,77,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,78,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,79,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,80,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,81,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,82,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,83,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,84,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,85,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,86,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,87,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,88,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,89,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,90,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,91,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,92,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,93,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,94,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,95,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,96,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,97,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,98,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,99,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,100,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,101,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,102,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,103,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,104,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,105,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,106,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,107,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,108,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,109,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,110,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,111,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,112,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,113,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,114,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,115,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,116,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,117,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,118,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,119,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,120,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,121,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,122,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,123,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,124,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,125,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,126,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,127,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,128,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,129,null,null,null,null,null,{"$f":"IF(A153,\"\",VLOOKUP(G153,$G$10:$I$14,2,0))","v":""},{"$f":"IF(A153,\"\",IF(D153=\"S\",0,VLOOKUP(G153,$G$10:$I$14,3,0)))","v":""},{"$f":"IF(A153,\"\",TRUNC(IF(E153>$L$11,$L$14,IF(E153>$L$10,$L$12+0.5*(E153-$L$10),IF(0.8*E153<$L$13,$L$13,0.8*E153))),2))","v":""},{"$f":"IF(A153,\"\",E153*H153)","v":""},"",{"$f":"IF(A153,\"\",I153*J153)","v":""},"",{"$f":"IF(A153,\"\",E153-N153)","v":""},{"$f":"IF(A153,\"\",1-(N153/E153))","v":""},null,{"$f":"IF(A153,\"\",IF(Q153>0,(E153-N153)*Q153,(E153-N153)*$Q$20))","v":""},{"$f":"IF(A153,\"\",N153+R153)","v":""},{"$f":"IF(A153,\"\",E153-S153)","v":""},{"$f":"IF(A153,\"\",1-(S153/E153))","v":""}]
[{"$f":"IF(COUNTA(C154:E154,G154)<4,1,0)","v":1},130,null,null,null,null,null,"","","","",{"$f":"IF(A154,\"\",IF(K154>2090,2090,K154))","v":""},"","","","",null,"","","",""]
[1,131,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,132,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,133,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,134,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,135,null,null,null,null,null,"","","","","","",{"$f":"IF(A159,\"\",K159+M159)","v":""},"","",null,"","","",""]
[1,136,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,137,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,138,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,139,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,140,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,141,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,142,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,143,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,144,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,145,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,146,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,147,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,148,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,149,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,150,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,151,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,152,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,153,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,154,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,155,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,156,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,157,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,158,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,159,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,160,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,161,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,162,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,163,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,164,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,165,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,166,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,167,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,168,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,169,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,170,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,171,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,172,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,173,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,174,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,175,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,176,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,177,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,178,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,179,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,180,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,181,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,182,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,183,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,184,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,185,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,186,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,187,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,188,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,189,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,190,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,191,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,192,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,193,null,null,null,null,null,{"$f":"IF(A217,\"\",VLOOKUP(G217,$G$10:$I$14,2,0))","v":""},{"$f":"IF(A217,\"\",IF(D217=\"S\",0,VLOOKUP(G217,$G$10:$I$14,3,0)))","v":""},{"$f":"IF(A217,\"\",TRUNC(IF(E217>$L$11,$L$14,IF(E217>$L$10,$L$12+0.5*(E217-$L$10),IF(0.8*E217<$L$13,$L$13,0.8*E217))),2))","v":""},{"$f":"IF(A217,\"\",E217*H217)","v":""},"",{"$f":"IF(A217,\"\",I217*J217)","v":""},"",{"$f":"IF(A217,\"\",E217-N217)","v":""},{"$f":"IF(A217,\"\",1-(N217/E217))","v":""},null,{"$f":"IF(A217,\"\",IF(Q217>0,(E217-N217)*Q217,(E217-N217)*$Q$20))","v":""},{"$f":"IF(A217,\"\",N217+R217)","v":""},{"$f":"IF(A217,\"\",E217-S217)","v":""},{"$f":"IF(A217,\"\",1-(S217/E217))","v":""}]
[{"$f":"IF(COUNTA(C218:E218,G218)<4,1,0)","v":1},194,null,null,null,null,null,"","","","",{"$f":"IF(A218,\"\",IF(K218>2090,2090,K218))","v":""},"","","","",null,"","","",""]
[1,195,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,196,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,197,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,198,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,199,null,null,null,null,null,"","","","","","",{"$f":"IF(A223,\"\",K223+M223)","v":""},"","",null,"","","",""]
[1,200,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,201,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,202,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,203,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,204,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,205,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,206,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,207,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,208,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,209,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,210,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,211,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,212,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,213,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,214,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,215,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,216,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,217,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,218,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,219,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,220,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,221,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,222,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,223,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,224,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,225,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,226,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,227,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,228,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,229,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,230,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,231,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,232,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,233,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,234,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,235,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,236,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,237,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,238,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,239,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,240,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,241,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,242,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,243,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,244,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,245,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,246,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,247,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,248,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,249,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,250,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,251,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,252,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,253,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,254,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,255,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,256,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,257,null,null,null,null,null,{"$f":"IF(A281,\"\",VLOOKUP(G281,$G$10:$I$14,2,0))","v":""},{"$f":"IF(A281,\"\",IF(D281=\"S\",0,VLOOKUP(G281,$G$10:$I$14,3,0)))","v":""},{"$f":"IF(A281,\"\",TRUNC(IF(E281>$L$11,$L$14,IF(E281>$L$10,$L$12+0.5*(E281-$L$10),IF(0.8*E281<$L$13,$L$13,0.8*E281))),2))","v":""},{"$f":"IF(A281,\"\",E281*H281)","v":""},"",{"$f":"IF(A281,\"\",I281*J281)","v":""},"",{"$f":"IF(A281,\"\",E281-N281)","v":""},{"$f":"IF(A281,\"\",1-(N281/E281))","v":""},null,{"$f":"IF(A281,\"\",IF(Q281>0,(E281-N281)*Q281,(E281-N281)*$Q$20))","v":""},{"$f":"IF(A281,\"\",N281+R281)","v":""},{"$f":"IF(A281,\"\",E281-S281)","v":""},{"$f":"IF(A281,\"\",1-(S281/E281))","v":""}]
[{"$f":"IF(COUNTA(C282:E282,G282)<4,1,0)","v":1},258,null,null,null,null,null,"","","","",{"$f":"IF(A282,\"\",IF(K282>2090,2090,K282))","v":""},"","","","",null,"","","",""]
[1,259,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,260,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,261,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,262,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,263,null,null,null,null,null,"","","","","","",{"$f":"IF(A287,\"\",K287+M287)","v":""},"","",null,"","","",""]
[1,264,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,265,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,266,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,267,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,268,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,269,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,270,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,271,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,272,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,273,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,274,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,275,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,276,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,277,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,278,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,279,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,280,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,281,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,282,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,283,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,284,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,285,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,286,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,287,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,288,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,289,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,290,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,291,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,292,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,293,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,294,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,295,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,296,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,297,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,298,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,299,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,300,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,301,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,302,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,303,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,304,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,305,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,306,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,307,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,308,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,309,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,310,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,311,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,312,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,313,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,314,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,315,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,316,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,317,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,318,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,319,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,320,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,321,null,null,null,null,null,{"$f":"IF(A345,\"\",VLOOKUP(G345,$G$10:$I$14,2,0))","v":""},{"$f":"IF(A345,\"\",IF(D345=\"S\",0,VLOOKUP(G345,$G$10:$I$14,3,0)))","v":""},{"$f":"IF(A345,\"\",TRUNC(IF(E345>$L$11,$L$14,IF(E345>$L$10,$L$12+0.5*(E345-$L$10),IF(0.8*E345<$L$13,$L$13,0.8*E345))),2))","v":""},{"$f":"IF(A345,\"\",E345*H345)","v":""},"",{"$f":"IF(A345,\"\",I345*J345)","v":""},"",{"$f":"IF(A345,\"\",E345-N345)","v":""},{"$f":"IF(A345,\"\",1-(N345/E345))","v":""},null,{"$f":"IF(A345,\"\",IF(Q345>0,(E345-N345)*Q345,(E345-N345)*$Q$20))","v":""},{"$f":"IF(A345,\"\",N345+R345)","v":""},{"$f":"IF(A345,\"\",E345-S345)","v":""},{"$f":"IF(A345,\"\",1-(S345/E345))","v":""}]
[{"$f":"IF(COUNTA(C346:E346,G346)<4,1,0)","v":1},322,null,null,null,null,null,"","","","",{"$f":"IF(A346,\"\",IF(K346>2090,2090,K346))","v":""},"","","","",null,"","","",""]
[1,323,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,324,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,325,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,326,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,327,null,null,null,null,null,"","","","","","",{"$f":"IF(A351,\"\",K351+M351)","v":""},"","",null,"","","",""]
[1,328,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,329,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,330,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,331,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,332,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,333,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,334,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,335,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,336,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,337,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,338,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,339,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,340,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,341,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,342,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,343,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,344,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,345,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,346,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,347,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,348,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,349,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,350,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,351,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,352,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,353,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,354,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,355,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,356,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,357,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,358,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,359,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,360,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,361,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,362,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,363,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,364,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,365,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,366,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,367,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,368,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,369,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,370,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,371,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,372,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,373,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,374,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,375,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,376,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,377,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,378,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,379,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,380,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,381,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,382,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,383,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,384,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,385,null,null,null,null,null,{"$f":"IF(A409,\"\",VLOOKUP(G409,$G$10:$I$14,2,0))","v":""},{"$f":"IF(A409,\"\",IF(D409=\"S\",0,VLOOKUP(G409,$G$10:$I$14,3,0)))","v":""},{"$f":"IF(A409,\"\",TRUNC(IF(E409>$L$11,$L$14,IF(E409>$L$10,$L$12+0.5*(E409-$L$10),IF(0.8*E409<$L$13,$L$13,0.8*E409))),2))","v":""},{"$f":"IF(A409,\"\",E409*H409)","v":""},"",{"$f":"IF(A409,\"\",I409*J409)","v":""},"",{"$f":"IF(A409,\"\",E409-N409)","v":""},{"$f":"IF(A409,\"\",1-(N409/E409))","v":""},null,{"$f":"IF(A409,\"\",IF(Q409>0,(E409-N409)*Q409,(E409-N409)*$Q$20))","v":""},{"$f":"IF(A409,\"\",N409+R409)","v":""},{"$f":"IF(A409,\"\",E409-S409)","v":""},{"$f":"IF(A409,\"\",1-(S409/E409))","v":""}]
[{"$f":"IF(COUNTA(C410:E410,G410)<4,1,0)","v":1},386,null,null,null,null,null,"","","","",{"$f":"IF(A410,\"\",IF(K410>2090,2090,K410))","v":""},"","","","",null,"","","",""]
[1,387,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,388,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,389,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,390,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,391,null,null,null,null,null,"","","","","","",{"$f":"IF(A415,\"\",K415+M415)","v":""},"","",null,"","","",""]
[1,392,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,393,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,394,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,395,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,396,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,397,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,398,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,399,null,null,null,null,null,"","","","","","","","","",null,"","","",""]
[1,400,null,null,null,null,null,"","","","","","","","","",null,"","","",""]

{"sheet":"REL-FUNCIONÁRIO","index":2,"n_rows":29,"n_cols":8,"rows_kept":29,"cut":false,"hidden":false,"merged":[[11,1,11,6],[23,1,23,5],[24,1,24,6],[25,1,25,6],[26,1,26,6],[21,1,21,6],[12,1,12,6],[13,1,13,6],[14,1,14,6],[19,1,19,6],[20,1,20,6],[15,1,15,6],[16,1,16,6],[18,1,18,6],[17,1,17,6],[7,5,7,7],[0,5,1,7],[3,1,6,7],[9,1,9,6],[10,1,10,6]]}
[null,null,null,null,null,"SIMULADOR DE CÁLCULO\nCOM BASE NA MP-936"]
[]
[]
[null,"ATENÇÃO: ESTE SIMULADOR É APENAS PARA EXEMPLIFICAR OS CÁLCULOS (APROXIMADOS)\nCOM BASE NA MP-936. NÃO NOS RESPONSABILIZAMOS POR EVENTUAIS ERROS DE\nCÁLCULO NA PLANILHA, BEM COMO POR QUAISQUER PREJUÍZOS PROVENIENTES DA\nTOMADA DE DECISÃO COM BASE NESTAS SIMULAÇÕES."]
[]
[]
[]
[{"$f":"VLOOKUP($C$8,SIMULADOR!$B$25:$U$424,2,0)","v":{"$error":"#N/A"}},"SEQ.",null,null,"NOME",{"$f":"IF($A$9,\"\",VLOOKUP($C$8,SIMULADOR!$B$25:$U$424,2,0))","v":""}]
[{"$f":"IF(ISNA(A8),1,IF(A8=0,1,0))","v":1}]
[null,"REC. BENEF. CONTINUADO (S/N)",null,null,null,null,null,{"$f":"IF($A$9,\"\",VLOOKUP($C$8,SIMULADOR!$B$25:$U$424,3,0))","v":""}]
[null,"SALÁRIO BASE",null,null,null,null,null,{"$f":"IF($A$9,\"\",VLOOKUP($C$8,SIMULADOR!$B$25:$U$424,4,0))","v":""}]
[null,"SETOR",null,null,null,null,null,{"$f":"IF($A$9,\"\",VLOOKUP($C$8,SIMULADOR!$B$25:$U$424,5,0))","v":""}]
[null,"OPÇÃO DE CARGA HORÁRIA",null,null,null,null,null,{"$f":"IF($A$9,\"\",VLOOKUP($C$8,SIMULADOR!$B$25:$U$424,6,0))","v":""}]
[null,"% PAGO P/EMPRESA",null,null,null,null,null,{"$f":"IF($A$9,\"\",VLOOKUP($C$8,SIMULADOR!$B$25:$U$424,7,0))","v":""}]
[null,"% PAGO P/GOV.",null,null,null,null,null,{"$f":"IF($A$9,\"\",VLOOKUP($C$8,SIMULADOR!$B$25:$U$424,8,0))","v":""}]
[null,"VALOR SEGURO DESEMPR.",null,null,null,null,null,{"$f":"IF($A$9,\"\",VLOOKUP($C$8,SIMULADOR!$B$25:$U$424,9,0))","v":""}]
[null,"VALOR A SER PAGO P/EMPRESA",null,null,null,null,null,{"$f":"IF($A$9,\"\",VLOOKUP($C$8,SIMULADOR!$B$25:$U$424,10,0))","v":""}]
[null,"DO VALOR PAGO PELA EMPRESA, É POSSÍVEL FINANCIAR O TOTAL DE:_",null,null,null,null,null,{"$f":"IF($A$9,\"\",VLOOKUP($C$8,SIMULADOR!$B$25:$U$424,11,0))","v":""}]
[null,"VALOR A SER PAGO PELO GOV.",null,null,null,null,null,{"$f":"IF($A$9,\"\",VLOOKUP($C$8,SIMULADOR!$B$25:$U$424,12,0))","v":""}]
[null,"NOVO SALÁRIO",null,null,null,null,null,{"$f":"IF($A$9,\"\",VLOOKUP($C$8,SIMULADOR!$B$25:$U$424,13,0))","v":""}]
[null,"VALOR DA REDUÇÃO",null,null,null,null,null,{"$f":"IF($A$9,\"\",VLOOKUP($C$8,SIMULADOR!$B$25:$U$424,14,0))","v":""}]
[null,"% DA REDUÇÃO",null,null,null,null,null,{"$f":"IF($A$9,\"\",VLOOKUP($C$8,SIMULADOR!$B$25:$U$424,15,0))","v":""}]
[]
[null,"AJUDA COMPENSATÓRIA MENSAL",null,null,null,null,{"$f":"IF($A$9,\"\",CONCATENATE(\"(\",100*IF(VLOOKUP($C$8,SIMULADOR!$B$25:$U$424,16,0)>0,VLOOKUP($C$8,SIMULADOR!$B$25:$U$424,16,0),SIMULADOR!$Q$20),\"% do VALOR DA REDUÇÃO)\"))","v":""},{"$f":"IF($A$9,\"\",VLOOKUP($C$8,SIMULADOR!$B$25:$U$424,17,0))","v":""}]
[null,"SALÁRIO TOTAL C/ABONO",null,null,null,null,null,{"$f":"IF($A$9,\"\",VLOOKUP($C$8,SIMULADOR!$B$25:$U$424,18,0))","v":""}]
[null,"VALOR DA REDUÇÃO C/ABONO",null,null,null,null,null,{"$f":"IF($A$9,\"\",VLOOKUP($C$8,SIMULADOR!$B$25:$U$424,19,0))","v":""}]
[null,"% DA REDUÇÃO C/ABONO",null,null,null,null,null,{"$f":"IF($A$9,\"\",VLOOKUP($C$8,SIMULADOR!$B$25:$U$424,20,0))","v":""}]
[]
[null,"(",null,")","MARQUE COM \"X\" PARA OMITIR DETALHAMENTO"]