{"text_format":"2","workbook":"xlsx","n_sheets":6,"sheets":["Planilha Orçamentária","Fator Ka","Fator Kc","Encargos Sociais","Cronograma","MDO_DNIT"],"not_rendered":{"charts":0,"images":3,"macros":0,"external_links":1,"defined_names":1381,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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":"Planilha Orçamentária","index":0,"n_rows":25,"n_cols":13,"rows_kept":25,"cut":false,"hidden":false,"merged":[[8,1,8,2],[24,1,24,3],[5,1,6,3],[5,5,5,6],[6,4,6,6],[7,1,7,2],[7,4,7,6],[0,0,0,9],[1,0,1,9],[2,0,2,9],[3,0,3,9],[4,5,4,6]]}
["Ministério da Integração e do Desenvolvimento Regional"]
["Companhia de desenvolvimento dos Vales do São Francisco e do Parnaíba"]
[]
["PLANILHA ORÇAMENTÁRIA - ORÇAMENTO NÃO DESONERADO"]
["CONTRATO:",{"$nulls":8},"Bancos de dados:"]
["PROJETO:","CADERNOS DE CARACTERIZAÇÃO GEOGRÁFICA DOS ESTADOS E DISTRITO FEDERAL NA ÁREA DE ATUAÇÃO DA CODEVASF – NA SEDE DA COMPANHIA EM BRASÍLIA - DF",{"$nulls":7},"Tabela Eng Consultiva DNIT"]
[{"$nulls":4},"Encargos sociais - Horistas:",null,null,null,{"$f":"'Encargos Sociais'!E46","v":1.1014000000000002},"2024-01-01"]
["DATA BASE:","2024-07-01",null,null,"Encargos sociais - Mensalista:",null,null,null,{"$f":"'Encargos Sociais'!F46","v":0.70040000000000002},"-"]
["ITEM","REFERÊNCIA",null,"DESCRIÇÃO","UNID.","QUANT.","CUSTO UNITÁRIO","FatorK","PREÇO UNITÁRIO ","PREÇO TOTAL","TIPO de BDI","CLASSIF","Encargos Comp e Adicionais"]
[null,"FONTE","CÓDIGO"]
[1,null,null,"Mão de Obra",{"$nulls":5},{"$f":"SUM(J12:J19)","v":1946058.0100000002},null,"ss"]
["1.1","DNIT","P8185","Coordenador Geral – jornada 40 hrs","mês",29,9831.81,{"$f":"'Fator Ka'!D35","v":2.1311548236000006},{"$f":"ROUND(H12*G12,2)","v":20953.11},{"$f":"ROUND(F12*I12,2)","v":607640.18999999994},"serv","s",{"$f":"VLOOKUP(C12,MDO_DNIT!B4:AA126,26,0)","v":1030.5}]
["1.2","DNIT","P8184","Geógrafo pleno – jornada 40 hrs","mês",28,5123.87,{"$f":"'Fator Ka'!D35","v":2.1311548236000006},10919.76,305753.28000000003,"serv","s",{"$f":"VLOOKUP(C13,MDO_DNIT!B5:AA127,26,0)","v":1030.5}]
["1.3","DNIT","P8184","Geógrafo pleno – jornada 40 hrs","mês",29,5123.87,{"$f":"'Fator Ka'!D35","v":2.1311548236000006},10919.76,316673.03999999998,"serv","s",{"$f":"VLOOKUP(C14,MDO_DNIT!B6:AA128,26,0)","v":1030.5}]
["1.4","DNIT","P8184","Analista Geo – jornada 40 hrs","mês",26,5123.87,{"$f":"'Fator Ka'!D35","v":2.1311548236000006},10919.76,283913.76,"serv","s",{"$f":"VLOOKUP(C15,MDO_DNIT!B7:AA129,26,0)","v":1030.5}]
["1.5","DNIT","P8168","Bibliotecário – jornada 40 hrs","mês",19,3170.69,{"$f":"'Fator Ka'!D35","v":2.1311548236000006},6757.23,128387.37,"serv","s",{"$f":"VLOOKUP(C16,MDO_DNIT!B8:AA130,26,0)","v":1034.2999999999997}]
["1.6","DNIT","P8135","Revisor de texto – jornada 40 hrs","mês",19,2604.7800000000002,{"$f":"'Fator Ka'!D35","v":2.1311548236000006},5551.19,105472.61,"serv","s",{"$f":"VLOOKUP(C17,MDO_DNIT!B9:AA131,26,0)","v":1068.6199999999999}]
["1.7","DNIT","P8159","Designer gráfico – jornada 40 hrs","mês",16,4761.5,{"$f":"'Fator Ka'!D35","v":2.1311548236000006},10147.49,162359.84,"serv","s",{"$f":"VLOOKUP(C18,MDO_DNIT!B10:AA132,26,0)","v":1005.8799999999992}]
["1.8*","DNIT",null,"Encargos Comp. e Adicionais","mês",29,{"$f":"AVERAGE(M12:M18)","v":1032.9714285714283},{"$f":"'Fator Kc'!E16","v":1.197009},1236.48,35857.919999999998,"serv","s"]
[]
[null,null,null,"TOTAL sem BDI e Encargos Sociais :",{"$nulls":5},{"$f":"SUMPRODUCT(F12:F19,G12:G19)","v":926277.80142857134}]
[null,null,null,"BDI e Encargos Sociais:",{"$nulls":5},{"$f":"J23-J21","v":1019780.2085714289}]
[null,null,null,"TOTAL COM BDI:",{"$nulls":5},{"$f":"SUM(J12:J19)","v":1946058.0100000002}]
[]
[null,"*Conforme instrução do sr. Gerente de Custos (AG/GCT) foi mantido o item 1.8 que utiliza como referência a planilha do DNIT, entretanto, para este item se manter funcional, foi necessária  a manutenção dos códigos de referência, embora não correspondam à formação profissional, buscou-se utilizar códigos com valores próximos ao custo unitário."]

{"sheet":"Fator Ka","index":1,"n_rows":40,"n_cols":4,"rows_kept":40,"cut":false,"hidden":false,"merged":[[30,1,30,2],[33,1,33,2],[34,1,34,2],[0,0,0,3],[4,0,4,1],[5,1,5,2],[16,1,16,2],[24,1,24,2]]}
["DETALHAMENTO DOS ENCARGOS SOCIAIS: Ka"]
["NOME DA CONSULTORA:"]
[]
["PROJETO:",null,"CONTRATATANTE:"]
["CADERNOS DE CARACTERIZAÇÃO GEOGRÁFICA DOS ESTADOS E DISTRITO FEDERAL NA ÁREA DE ATUAÇÃO DA CODEVASF – NA SEDE DA COMPANHIA EM BRASÍLIA – DF",null,"CODEVASF (SEDE)","Não Desonerado"]
["Cod.","DESCRIÇÃO",null,"%"]
["A","ENCARGOS SOCIAIS BÁSICOS",null,{"$f":"SUM(D8:D16)","v":0.37800000000000006}]
["A1","INSS",null,0.2]
["A2","SESI",null,1.4999999999999999E-2]
["A3","SENAI",null,0.01]
["A4","INCRA",null,2E-3]
["A5","SEBRAE",null,6.0000000000000001E-3]
["A6","Salário Educação",null,2.5000000000000001E-2]
["A7","Seguro Contra Acidentes de Trabalho",null,0.03]
["A8","FGTS",null,0.08]
["A9","SECONCI",null,0.01]
["B","ENCARGOS SOCIAIS QUE RECEBEM INCIDÊNCIA DE \"A\"",null,{"$f":"SUM(D18:D24)","v":0.16239999999999999}]
["B3","Auxílio Enfermidade",null,6.4000000000000003E-3]
["B4","13º Salário",null,8.3299999999999999E-2]
["B5","Licença Paternidade",null,4.0000000000000002E-4]
["B6","Faltas Justificadas",null,5.5999999999999999E-3]
["B8","Auxílio Acidente de Trabalho",null,8.0000000000000004E-4]
["B9","Férias Gozadas",null,6.5600000000000006E-2]
["B10","Salário Maternidade",null,2.9999999999999997E-4]
["C","ENCARGOS SOCIAIS QUE NÃO RECEBEM INCIDÊNCIA DE \"A\"",null,{"$f":"SUM(D26:D30)","v":9.5699999999999993E-2}]
["C1","Aviso Prévio Indenizado",null,3.2399999999999998E-2]
["C2","Aviso Prévio Trabalhado",null,8.0000000000000004E-4]
["C3","Férias Indenizadas",null,3.5900000000000001E-2]
["C4","Depósito Rescisão Sem Justa Causa",null,2.3900000000000001E-2]
["C5","Indenização Adicional",null,2.7000000000000001E-3]
["D","REINCIDÊNCIAS",null,{"$f":"SUM(D32:D33)","v":6.4299999999999996E-2}]
["D1","Reincidência de \"A\" sobre \"B\"",null,6.1400000000000003E-2]
["D2","Reincidência de \"A\" sobre Aviso Prévio Trabalhado e reincidência do FGTS sobre Aviso Prévio Indenizado",null,2.8999999999999998E-3]
["K1","ENCARGOS SOCIAIS",null,{"$f":"D31+D25+D17+D7","v":0.70040000000000002}]
["Ka","TAXA DE RESSARCIMENTO DE DESPESAS E ENCARGOS SOBRE MO1",null,{"$f":"(1+D34+'Fator Kc'!E12)*(1+'Fator Kc'!E11)*(1+'Fator Kc'!E7)","v":2.1311548236000006}]
["OBSERVAÇÃO: CELETISTAS E EQUIVALENTES"]
["1 - DISCRIMINAR OS ENCARGOS SOCIAIS COM SEUS RESPECTIVOS PERCENTUAIS TOTALIZANDO OS MESMOS."]
["2 - APLICAR 0 % TOTAL P/CALCULAR OS E. SOCIAS INCIDENTES NA MÃO-DE-OBRA CELESTISTAS"]
["Ka - Taxa de Ressarcimento de Despesas e Encargos sobre a Mão de Obra CELETISTA (incide apenas no Insumo Código MO1)"]
["Ka = (1+K1+K2)x(1+K3)x(1+K4)"]

{"sheet":"Fator Kc","index":2,"n_rows":29,"n_cols":6,"rows_kept":29,"cut":false,"hidden":false,"merged":[[24,0,24,4],[25,0,25,4],[26,0,26,4],[27,0,27,4],[28,0,28,4],[19,0,19,4],[20,0,20,4],[21,0,21,4],[22,0,22,4],[23,0,23,4],[14,1,14,3],[15,1,15,3],[16,0,16,4],[17,0,17,4],[18,0,18,4],[9,1,9,2],[10,1,10,3],[11,1,11,3],[12,1,12,3],[13,1,13,3],[5,1,5,2],[5,5,7,5],[6,1,6,2],[7,1,7,2],[8,1,8,2],[0,0,0,4],[1,0,1,4],[2,0,2,4],[3,2,3,4],[4,0,4,1],[4,2,4,4]]}
["DESPESAS FISCAIS E CUSTOS DIVERSOS: Kc"]
["NOME DA CONSULTORA:"]
[]
["PROJETO:",null,"CONTRATANTE:"]
["SERVIÇOS DE APOIO À UNIDADE DE GESTÃO E SEGURANÇA DE BARRAGENS DA CODEVASF – NA SEDE DA COMPANHIA EM BRASÍLIA - DF",null,"CODEVASF (SEDE)"]
["Cod","DESCRIÇÃO1",null,"% preço2","% custo4","Recomendação TCU: Redução de 20% da alíquota do PIS e COFINS"]
["K4","TAXAS E IMPOSTOS",null,0.124,{"$f":"SUM(E8:E10)","v":0.1187}]
["K4.1","ISS",null,0.03,{"$f":"ROUND((1/(1-$D$7))*D8,4)","v":3.4200000000000001E-2}]
["K4.2","PIS3",null,1.32E-2,{"$f":"ROUND((1/(1-$D$7))*D9,4)","v":1.5100000000000001E-2},"(80% de 1,65%)"]
["K4.3","COFINS3",null,6.08E-2,{"$f":"ROUND((1/(1-$D$7))*D10,4)","v":6.9400000000000003E-2},"(80% de 7,60%)"]
["K3","REMUNERAÇÃO DA EMPRESA (LUCRO)",null,null,7.0000000000000007E-2]
["K2","CUSTOS DA ADMINISTRAÇÃO CENTRAL",null,null,{"$f":"SUM(E13:E15)","v":0.08}]
["K2.1","Custos da administração central da empresa (diretoria, pessoal técnico de apoio e pessoal administrativo não diretamente vinculado à prestação dos serviços)",null,null,0.04]
["K2.2","Outras despesas que afetam o custo de produção como treinamento, biblioteca, programa de qualidade, programa de benefícios, auditoria interna e externa",null,null,0.02]
["K2.3","Despesas fixas e variaveis com patrimônio, aluguéis, comunicação, manutenção e transporte não diretamente relacionados com o custo direto dos serviços",null,null,0.02]
["Kc","TAXA RESSARCIMENTO DE DESPESAS SOBRE CUSTOS DIVERSOS",null,null,{"$f":"(1+E11)*(1+E7)","v":1.197009}]
["Observação:"]
["1 - RELACIONAR OS CUSTOS DE ADMINISTRAÇÃO COM RESPECTIVOS PERCENTUAIS INCIDENTES NA MÃO -DE-OBRA"]
["1 - DISCRIMINAR OS TRIBUTOS QUE INCIDEM SOBRE OS CUSTOS DA PRESTAÇÃO DOS SERVIÇOS"]
["2 - K4 = INDICAR % DE CADA TRIBUTO E A SOMA DOS MESMOS"]
["3 - PIS e COFINS, Regime de Incidencia Acumulativa (0,65% e 3,00% - sem percentual de desconto) ou em Regime de Incidencia Não Acumulativa (1,65% e 7,60% - aplicável percentual de desconto) de acordo com a forma de apuração do lucro no IRPJ. APRESENTAR COMPROVANTES de aproveitamento de créditos tributários dos últimos 12 meses em caso de aplicação de \"percentual de desconto\"."]
["4 - AS DESPESAS FISCAIS (K4) INCIDEM SOBRE O TOTAL DA FATURA E NÃO SOBRE OS CUSTOS INCORRIDOS, DEVENDO SER CALCULADO O K4' AP"]
["K4' = { [ 1 / ( 1 - K4) ] - 1 } x 100"]
["K4' = { [ 1 / ( 1 - 0,124 ) ] - 1 } x 100"]
["Kc - Taxa de Ressarcimento de Despesas sobre Custos Diversos"]
["Kc = (1 + K3) x (1 + K4)"]
["K2 - Incide sobre o Custo Total (CT) da Mão de Obra (MO* = MO1 + MO2)"]
["K3 - Incide sobre o Custo Total (CT) Mão de Obra com encargos (MO1 x Ka ou MO2 x Kb), demais Custos e Custos da Administração Central (K2)"]
["K4 -  Incide sobre o Custo Total (CT) Mão de Obra com encargos (MO1 x Ka ou MO2 x Kb), demais Custos, e Custos da Administração Central (K2) e Lucro (K3)"]

{"sheet":"Encargos Sociais","index":3,"n_rows":47,"n_cols":6,"rows_kept":47,"cut":false,"hidden":false,"merged":[[46,0,46,1],[11,0,11,5],[22,0,22,5],[34,0,34,5],[41,0,41,5],[45,0,45,1],[5,1,5,2],[6,1,6,2],[7,0,7,5],[8,0,8,5],[9,0,10,0],[9,1,10,1],[9,2,9,3],[9,4,9,5],[0,0,0,5],[1,0,1,5],[2,0,2,5],[3,0,3,5],[4,1,4,2]]}
["Ministério da Integração e do Desenvolvimento Regional"]
["Companhia de Desenvolvimento dos Vales do São Francisco e do Parnaíba"]
[{"$f":"'Planilha Orçamentária'!A3:J3","v":0}]
["COMPOSIÇÃO DE ENCARGOS SOCIAIS SOBRE A MÃO DE OBRA"]
["CONTRATO:",{"$f":"'Planilha Orçamentária'!B5:D5","v":0}]
["PROJETO:",{"$f":"'Planilha Orçamentária'!B6","v":"CADERNOS DE CARACTERIZAÇÃO GEOGRÁFICA DOS ESTADOS E DISTRITO FEDERAL NA ÁREA DE ATUAÇÃO DA CODEVASF – NA SEDE DA COMPANHIA EM BRASÍLIA - DF"}]
["DATA BASE:",{"$f":"'Planilha Orçamentária'!B8:C8","v":"2024-07-01"}]
["Encargos Sociais – Distrito Federal     VIGÊNCIA A PARTIR DE  12/2023"]
["ENCARGOS SOCIAIS SOBRE A MÃO DE OBRA"]
["CÓDIGO","DESCRIÇÃO","COM DESONERAÇÃO",null,"SEM DESONERAÇÃO"]
[null,null,"HORISTA\n%","MENSALISTA\n%","HORISTA\n%","MENSALISTA\n%"]
["GRUPO A"]
["A1","INSS",0,0,0.2,0.2]
["A2","SESI",1.4999999999999999E-2,1.4999999999999999E-2,1.4999999999999999E-2,1.4999999999999999E-2]
["A3","SENAI",0.01,0.01,0.01,0.01]
["A4","INCRA",2E-3,2E-3,2E-3,2E-3]
["A5","SEBRAE",6.0000000000000001E-3,6.0000000000000001E-3,6.0000000000000001E-3,6.0000000000000001E-3]
["A6","Salário Educação",2.5000000000000001E-2,2.5000000000000001E-2,2.5000000000000001E-2,2.5000000000000001E-2]
["A7","Seguro Contra Acidentes de Trabalho",0.03,0.03,0.03,0.03]
["A8","FGTS",0.08,0.08,0.08,0.08]
["A9","SECONCI",0.01,0.01,0.01,0.01]
["A","Total",{"$f":"SUM(C13:C21)","v":0.17799999999999999},{"$f":"SUM(D13:D21)","v":0.17799999999999999},{"$f":"SUM(E13:E21)","v":0.37800000000000006},{"$f":"SUM(F13:F21)","v":0.37800000000000006}]
["GRUPO B"]
["B1","Repouso Semanal Remunerado",0.17730000000000001,"Não incide",0.17730000000000001,"Não incide"]
["B2","Feriados",3.4000000000000002E-2,"Não incide",3.4000000000000002E-2,"Não incide"]
["B3","Auxílio - Enfermidade",8.3000000000000001E-3,6.4000000000000003E-3,8.3000000000000001E-3,6.4000000000000003E-3]
["B4","13º Salário",0.1072,8.3299999999999999E-2,0.1072,8.3299999999999999E-2]
["B5","Licença Paternidade",5.9999999999999995E-4,4.0000000000000002E-4,5.9999999999999995E-4,4.0000000000000002E-4]
["B6","Faltas Justificadas",7.1000000000000004E-3,5.5999999999999999E-3,7.1000000000000004E-3,5.5999999999999999E-3]
["B7","Dias de Chuvas",1.2699999999999999E-2,"Não incide",1.2699999999999999E-2,"Não incide"]
["B8","Auxílio Acidente de Trabalho",1E-3,8.0000000000000004E-4,1E-3,8.0000000000000004E-4]
["B9","Férias Gozadas",8.4400000000000003E-2,6.5600000000000006E-2,8.4400000000000003E-2,6.5600000000000006E-2]
["B10","Salário Maternidade",4.0000000000000002E-4,2.9999999999999997E-4,4.0000000000000002E-4,2.9999999999999997E-4]
["B","Total",{"$f":"SUM(C24:C33)","v":0.433},{"$f":"SUM(D24:D33)","v":0.16239999999999999},{"$f":"SUM(E24:E33)","v":0.433},{"$f":"SUM(F24:F33)","v":0.16239999999999999}]
["GRUPO C"]
["C1","Aviso Prévio Indenizado",4.1599999999999998E-2,3.2399999999999998E-2,4.1599999999999998E-2,3.2399999999999998E-2]
["C2","Aviso Prévio Trabalhado",1E-3,8.0000000000000004E-4,1E-3,8.0000000000000004E-4]
["C3","Férias Indenizadas",4.6100000000000002E-2,3.5900000000000001E-2,4.6100000000000002E-2,3.5900000000000001E-2]
["C4","Depósito Rescisão Sem Justa Causa",3.0800000000000001E-2,2.3900000000000001E-2,3.0800000000000001E-2,2.3900000000000001E-2]
["C5","Indenização Adicional",3.5000000000000001E-3,2.7000000000000001E-3,3.5000000000000001E-3,2.7000000000000001E-3]
["C","Total",{"$f":"SUM(C36:C40)","v":0.123},{"$f":"SUM(D36:D40)","v":9.5699999999999993E-2},{"$f":"SUM(E36:E40)","v":0.123},{"$f":"SUM(F36:F40)","v":9.5699999999999993E-2}]
["GRUPO D"]
["D1","Reincidência de Grupo A sobre Grupo B",7.7100000000000002E-2,2.8899999999999999E-2,0.16370000000000001,6.1400000000000003E-2]
["D2","Reincidência de Grupo A sobre Aviso Prévio Trabalhado e Reincidência do FGTS sobre Aviso\nPrévio Indenizado",3.5000000000000001E-3,2.7000000000000001E-3,3.7000000000000002E-3,2.8999999999999998E-3]
["D","Total",{"$f":"SUM(C43:C44)","v":8.0600000000000005E-2},{"$f":"SUM(D43:D44)","v":3.1599999999999996E-2},{"$f":"SUM(E43:E44)","v":0.16740000000000002},{"$f":"SUM(F43:F44)","v":6.4299999999999996E-2}]
["TOTAL(A+B+C+D)",null,{"$f":"C22+C34+C41+C45","v":0.81459999999999999},{"$f":"D22+D34+D41+D45","v":0.4677},{"$f":"E22+E34+E41+E45","v":1.1014000000000002},{"$f":"F22+F34+F41+F45","v":0.70040000000000002}]
["Fonte: Informação Dias de Chuva – INMET"]

{"sheet":"Cronograma","index":4,"n_rows":15,"n_cols":37,"rows_kept":15,"cut":false,"hidden":false,"merged":[[9,0,10,0],[9,1,10,1],[0,0,0,35],[1,0,1,35],[2,0,2,35],[3,0,3,35],[7,0,8,0],[7,1,8,1],[7,2,8,2],[7,3,7,34],[7,35,8,35]]}
["Ministério da Integração e do Desenvolvimento Regional"]
["Companhia de Desenvolvimento dos Vales do São Francisco e do Parnaíba"]
[{"$f":"'[1]Planilha Orçamentária'!A3:I3","v":0}]
["CRONOGRAMA FÍSICO-FINANCEIRO NÃO DESONERADO"]
["CONTRATO:",{"$f":"'Planilha Orçamentária'!B5:D5","v":0}]
["PROJETO:",{"$f":"'Planilha Orçamentária'!B6","v":"CADERNOS DE CARACTERIZAÇÃO GEOGRÁFICA DOS ESTADOS E DISTRITO FEDERAL NA ÁREA DE ATUAÇÃO DA CODEVASF – NA SEDE DA COMPANHIA EM BRASÍLIA - DF"}]
["DATA BASE:",{"$f":"'Planilha Orçamentária'!B8:C8","v":"2024-07-01"}]
["ITEM","DESCRIÇÃO","TOTAL","MESES",{"$nulls":31},"TOTAL"]
[null,null,null,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32]
[1,{"$f":"'Planilha Orçamentária'!D11","v":"Mão de Obra"},{"$f":"'Planilha Orçamentária'!J11","v":1946058.0100000002},{"$f":"$C10*D11","v":0},121628.62562500002,0,121628.62562500002,0,121628.62562500002,0,121628.62562500002,0,121628.62562500002,0,121628.62562500002,0,121628.62562500002,0,121628.62562500002,0,121628.62562500002,0,121628.62562500002,0,121628.62562500002,0,121628.62562500002,0,121628.62562500002,0,121628.62562500002,0,121628.62562500002,0,121628.62562500002,{"$f":"SUM(D10:AI10)","v":1946058.0100000007},"R$"]
[null,null,{"$f":"C10/C10","v":1},{"$f":"D14","v":0},6.25E-2,0,6.25E-2,0,6.25E-2,0,6.25E-2,0,6.25E-2,0,6.25E-2,0,6.25E-2,0,6.25E-2,0,6.25E-2,0,6.25E-2,0,6.25E-2,0,6.25E-2,0,6.25E-2,0,6.25E-2,0,6.25E-2,0,6.25E-2,{"$f":"SUM(D11:AI11)","v":1},"%"]
[null,"VALOR TOTAL:",{"$f":"SUMIF($AK$10:$AK$11,\"R$\",C$10:C$11)","v":1946058.0100000002},0,121628.62562500002,0,121628.62562500002,0,121628.62562500002,0,121628.62562500002,0,121628.62562500002,0,121628.62562500002,0,121628.62562500002,0,121628.62562500002,0,121628.62562500002,0,121628.62562500002,0,121628.62562500002,0,121628.62562500002,0,121628.62562500002,0,121628.62562500002,0,121628.62562500002,0,121628.62562500002,1946058.0100000007]
[null,"VALOR ACUMULADO:",null,{"$f":"D12","v":0},{"$f":"E12+D13","v":121628.62562500002},121628.62562500002,243257.25125000003,243257.25125000003,364885.87687500007,364885.87687500007,486514.50250000006,486514.50250000006,608143.12812500005,608143.12812500005,729771.75375000003,729771.75375000003,851400.37937500002,851400.37937500002,973029.005,973029.005,1094657.630625,1094657.630625,1216286.2562500001,1216286.2562500001,1337914.8818750002,1337914.8818750002,1459543.5075000003,1459543.5075000003,1581172.1331250004,1581172.1331250004,1702800.7587500005,1702800.7587500005,1824429.3843750006,1824429.3843750006,1946058.0100000007,{"$f":"SUMIF($AK$10:$AK$11,\"R$\",AJ$10:AJ$11)","v":1946058.0100000007}]
[null,"FÍSICO PARCIAL:",null,0,6.25E-2,0,6.25E-2,0,6.25E-2,0,6.25E-2,0,6.25E-2,0,6.25E-2,0,6.25E-2,0,6.25E-2,0,6.25E-2,0,6.25E-2,0,6.25E-2,0,6.25E-2,0,6.25E-2,0,6.25E-2,0,6.25E-2,0,6.25E-2,{"$f":"AJ12/$C$12","v":1.0000000000000002}]
[null,"AVANÇO FÍSICO:",null,{"$f":"D14","v":0},{"$f":"E14+D15","v":6.25E-2},6.25E-2,0.125,0.125,0.1875,0.1875,0.25,0.25,0.3125,0.3125,0.375,0.375,0.4375,0.4375,0.5,0.5,0.5625,0.5625,0.625,0.625,0.6875,0.6875,0.75,0.75,0.8125,0.8125,0.875,0.875,0.9375,0.9375,1,{"$f":"AI15","v":1}]

{"sheet":"MDO_DNIT","index":5,"n_rows":112,"n_cols":27,"rows_kept":112,"cut":false,"hidden":false,"merged":[[0,7,0,16],[0,17,0,22],[0,23,1,24],[0,25,1,25],[0,26,1,26],[1,7,1,8],[1,9,1,10],[1,11,1,12],[1,13,1,14],[1,15,1,16],[1,17,1,18],[1,19,1,20],[1,21,1,22],[0,1,2,1],[0,2,2,2],[0,3,2,3],[0,4,1,4],[0,5,1,6]]}
[null,"Código","Categoria","Unid.","Salário","Encargos Sociais",null,"Encargos Complementares",{"$nulls":9},"Encargos Adicionais",{"$nulls":5},"Encargos Totais",null,"Valor Total","Encargos Adicionais e Complementares"]
[{"$nulls":7},"Alimentação",null,"EPI",null,"Ferramenta",null,"Transporte",null,"Exame Ocupacional",null,"Cesta Básica",null,"Assistência Médica",null,"Seguro de Vida"]
[{"$nulls":4},"R$","%","R$","%","R$","%","R$","%","R$","%","R$","%","R$","%","R$","%","R$","%","R$","%","R$","R$","R$"]
[null,"Profissionais mensalistas",{"$nulls":24},{"$f":"Z4-G4-E4","v":0}]
[null,"P8001","Advogado júnior","mês",4530.07,0.79290000000000005,3591.89,0.1552,702.89,5.4999999999999997E-3,24.99,0,0,0,0,5.9999999999999995E-4,2.83,0,0,6.3899999999999998E-2,289.39,2.2000000000000001E-3,9.98,1.0203,4621.9799999999996,9152.0499999999993,1030.0900000000001]
[null,"P8002","Advogado pleno","mês",6040.1,0.79290000000000005,4789.1899999999996,0.1164,702.89,4.1000000000000003E-3,24.99,0,0,0,0,5.0000000000000001E-4,2.83,0,0,4.7899999999999998E-2,289.39,1.6999999999999999E-3,9.98,0.96340000000000003,5819.27,11859.37,1030.0800000000008]
[null,"P8003","Advogado sênior","mês",11150.15,0.79290000000000005,8840.9500000000007,6.3E-2,702.89,2.2000000000000001E-3,24.99,0,0,0,0,2.9999999999999997E-4,2.83,0,0,2.5999999999999999E-2,289.39,8.9999999999999998E-4,9.98,0.88529999999999998,9871.0300000000007,21021.18,1030.08]
[null,"P8007","Analista de desenvolvimento de sistemas júnior","mês",4761.5,0.79600000000000004,3790.16,0.14760000000000001,702.89,0,0,0,0,0,0,8.0000000000000004E-4,3.69,0,0,6.08E-2,289.39,2.0999999999999999E-3,9.98,1.0073000000000001,4796.1099999999997,9557.61,1005.9500000000007]
[null,"P8008","Analista de desenvolvimento de sistemas pleno","mês",5587.15,0.79600000000000004,4447.37,0.1258,702.89,0,0,0,0,0,0,6.9999999999999999E-4,3.69,0,0,5.1799999999999999E-2,289.39,1.8E-3,9.98,0.97599999999999998,5453.33,11040.48,1005.96]
[null,"P8009","Analista de desenvolvimento de sistemas sênior","mês",9769.36,0.79600000000000004,7776.41,7.1900000000000006E-2,702.89,0,0,0,0,0,0,4.0000000000000002E-4,3.69,0,0,2.9600000000000001E-2,289.39,1E-3,9.98,0.89900000000000002,8782.3700000000008,18551.73,1005.9599999999991]
[null,"P8013","Arquiteto júnior","mês",12002,0.79349999999999998,9523.59,5.8599999999999999E-2,702.89,2.0999999999999999E-3,24.99,0,0,0,0,2.0000000000000001E-4,2.66,0,0,2.41E-2,289.39,8.0000000000000004E-4,9.98,0.87929999999999997,10553.5,22555.5,1029.9099999999999]
[null,"P8014","Arquiteto pleno","mês",12275.9,0.79349999999999998,9740.92,5.7299999999999997E-2,702.89,2E-3,24.99,0,0,0,0,2.0000000000000001E-4,2.66,0,0,2.3599999999999999E-2,289.39,8.0000000000000004E-4,9.98,0.87739999999999996,10770.84,23046.73,1029.9099999999999]
[null,"P8015","Arquiteto sênior","mês",14951.37,0.79349999999999998,11863.91,4.7E-2,702.89,1.6999999999999999E-3,24.99,0,0,0,0,2.0000000000000001E-4,2.66,0,0,1.9400000000000001E-2,289.39,6.9999999999999999E-4,9.98,0.86240000000000006,12893.82,27845.18,1029.8999999999996]
[null,"P8019","Assistente social júnior","mês",3183.32,0.80200000000000005,2553.0300000000002,0.2208,702.89,7.7999999999999996E-3,24.99,0,0,8.8000000000000005E-3,28.03,1.4E-3,4.51,0,0,9.0899999999999995E-2,289.39,3.0999999999999999E-3,9.98,1.1349,3612.82,6796.14,1059.7900000000004]
[null,"P8020","Assistente social pleno","mês",4244.43,0.80200000000000005,3404.03,0.1656,702.89,5.8999999999999999E-3,24.99,0,0,0,0,1.1000000000000001E-3,4.51,0,0,6.8199999999999997E-2,289.39,2.3999999999999998E-3,9.98,1.0450999999999999,4435.79,8680.23,1031.7699999999986]
[null,"P8021","Assistente social sênior","mês",7054.37,0.80200000000000005,5657.6,9.9599999999999994E-2,702.89,3.5000000000000001E-3,24.99,0,0,0,0,5.9999999999999995E-4,4.51,0,0,4.1000000000000002E-2,289.39,1.4E-3,9.98,0.94830000000000003,6689.36,13743.73,1031.7599999999993]
[null,"P8025","Auxiliar","mês",1554.37,0.81469999999999998,1266.3399999999999,0.45219999999999999,702.89,1.9599999999999999E-2,30.42,1E-3,1.56,8.09E-2,125.77,4.0000000000000001E-3,6.15,0,0,0.1862,289.39,6.4000000000000003E-3,9.98,1.5649,2432.5100000000002,3986.88,1166.17]
[null,"P8026","Auxiliar administrativo","mês",1842.36,0.80179999999999996,1477.2,0.38150000000000001,702.89,0,0,0,0,5.8900000000000001E-2,108.49,2E-3,3.75,0,0,0.15709999999999999,289.39,5.4000000000000003E-3,9.98,1.4067000000000001,2591.71,4434.07,1114.51]
[null,"P8027","Auxiliar de laboratório","mês",1721.24,0.80389999999999995,1383.71,0.40839999999999999,702.89,1.77E-2,30.42,1.9E-3,3.21,6.7299999999999999E-2,115.76,2.3E-3,4.01,0,0,0.1681,289.39,5.7999999999999996E-3,9.98,1.4753000000000001,2539.37,4260.6099999999997,1155.6599999999996]
[null,"P8028","Auxiliar de topografia","mês",1554.37,0.80669999999999997,1253.9100000000001,0.45219999999999999,702.89,1.9599999999999999E-2,30.42,8.9999999999999998E-4,1.36,8.09E-2,125.77,2.8E-3,4.3899999999999997,0,0,0.1862,289.39,6.4000000000000003E-3,9.98,1.5557000000000001,2418.11,3972.48,1164.1999999999998]
[null,"P8032","Biólogo júnior","mês",3234.91,0.79710000000000003,2578.5500000000002,0.21729999999999999,702.89,7.7000000000000002E-3,24.99,0,0,7.7000000000000002E-3,24.94,1.1000000000000001E-3,3.67,0,0,8.9499999999999996E-2,289.39,3.0999999999999999E-3,9.98,1.1234999999999999,3634.41,6869.32,1055.8599999999997]
[null,"P8033","Biólogo pleno","mês",4313.22,0.79710000000000003,3438.07,0.16300000000000001,702.89,5.7999999999999996E-3,24.99,0,0,0,0,8.9999999999999998E-4,3.67,0,0,6.7100000000000007E-2,289.39,2.3E-3,9.98,1.0361,4468.99,8782.2099999999991,1030.9199999999992]
[null,"P8034","Biólogo sênior","mês",7635.07,0.79710000000000003,6085.92,9.2100000000000001E-2,702.89,3.3E-3,24.99,0,0,0,0,5.0000000000000001E-4,3.67,0,0,3.7900000000000003E-2,289.39,1.2999999999999999E-3,9.98,0.93210000000000004,7116.84,14751.92,1030.9300000000003]
[null,"P8038","Chefe de escritório","mês",3358.49,0.79400000000000004,2666.64,0.20930000000000001,702.89,0,0,0,0,5.1999999999999998E-3,17.52,8.9999999999999998E-4,3.01,0,0,8.6199999999999999E-2,289.39,3.0000000000000001E-3,9.98,1.0985,3689.44,7047.93,1022.8000000000011]
[null,"P8040","Contador júnior","mês",4154.33,0.79320000000000002,3295.22,0.16919999999999999,702.89,0,0,0,0,0,0,5.9999999999999995E-4,2.57,0,0,6.9699999999999998E-2,289.39,2.3999999999999998E-3,9.98,1.0350999999999999,4300.05,8454.3799999999992,1004.8299999999999]
[null,"P8041","Contador pleno","mês",5539.11,0.79320000000000002,4393.62,0.12690000000000001,702.89,0,0,0,0,0,0,5.0000000000000001E-4,2.57,0,0,5.2200000000000003E-2,289.39,1.8E-3,9.98,0.97460000000000002,5398.45,10937.56,1004.8299999999999]
[null,"P8042","Contador sênior","mês",10620.57,0.79320000000000002,8424.24,6.6199999999999995E-2,702.89,0,0,0,0,0,0,2.0000000000000001E-4,2.57,0,0,2.7199999999999998E-2,289.39,8.9999999999999998E-4,9.98,0.88780000000000003,9429.07,20049.64,1004.8299999999999]
[null,"P8044","Coordenador ambiental ","mês",18522.37,0.79579999999999995,14740.1,3.7900000000000003E-2,702.89,1.1999999999999999E-3,22.82,0,0,0,0,2.0000000000000001E-4,3.19,0,0,1.5599999999999999E-2,289.39,5.0000000000000001E-4,9.98,0.85129999999999995,15768.37,34290.74,1028.2700000000004]
[null,"P8045","Economista júnior","mês",4742.07,0.78610000000000002,3727.74,0.1482,702.89,0,0,0,0,0,0,4.0000000000000002E-4,1.82,0,0,6.0999999999999999E-2,289.39,2.0999999999999999E-3,9.98,0.99780000000000002,4731.83,9473.9,1004.0900000000001]
[null,"P8046","Economista pleno","mês",6322.76,0.78610000000000002,4970.32,0.11119999999999999,702.89,0,0,0,0,0,0,2.9999999999999997E-4,1.82,0,0,4.58E-2,289.39,1.6000000000000001E-3,9.98,0.94489999999999996,5974.41,12297.17,1004.0900000000001]
[null,"P8047","Economista sênior","mês",10619.55,0.78610000000000002,8348.0300000000007,6.6199999999999995E-2,702.89,0,0,0,0,0,0,2.0000000000000001E-4,1.82,0,0,2.7300000000000001E-2,289.39,8.9999999999999998E-4,9.98,0.88070000000000004,9352.11,19971.669999999998,1004.0899999999983]
[null,"P8054","Engenheiro agrônomo júnior","mês",12002,0.79010000000000002,9482.7800000000007,5.8599999999999999E-2,702.89,2.0999999999999999E-3,24.99,0,0,0,0,2.0000000000000001E-4,2.44,0,0,2.41E-2,289.39,8.0000000000000004E-4,9.98,0.87590000000000001,10512.47,22514.47,1029.6900000000005]
[null,"P8055","Engenheiro agrônomo pleno","mês",12137.3,0.79010000000000002,9589.68,5.79E-2,702.89,2.0999999999999999E-3,24.99,0,0,0,0,2.0000000000000001E-4,2.44,0,0,2.3800000000000002E-2,289.39,8.0000000000000004E-4,9.98,0.87490000000000001,10619.38,22756.68,1029.7000000000007]
[null,"P8056","Engenheiro agrônomo sênior","mês",13689.19,0.79010000000000002,10815.83,5.1299999999999998E-2,702.89,1.8E-3,24.99,0,0,0,0,2.0000000000000001E-4,2.44,0,0,2.1100000000000001E-2,289.39,6.9999999999999999E-4,9.98,0.86529999999999996,11845.52,25534.71,1029.6899999999987]
[null,"P8057","Engenheiro ambiental júnior","mês",12002,0.79690000000000005,9564.39,5.8599999999999999E-2,702.89,2.0999999999999999E-3,24.99,0,0,0,0,2.9999999999999997E-4,3.6,0,0,2.41E-2,289.39,8.0000000000000004E-4,9.98,0.88280000000000003,10595.25,22597.25,1030.8600000000006]
[null,"P8058","Engenheiro ambiental pleno","mês",13319.39,0.79690000000000005,10614.22,5.28E-2,702.89,1.9E-3,24.99,0,0,0,0,2.9999999999999997E-4,3.6,0,0,2.1700000000000001E-2,289.39,6.9999999999999999E-4,9.98,0.87429999999999997,11645.07,24964.47,{"$f":"Z36-G36-E36","v":1030.8600000000024}]
[null,"P8059","Engenheiro ambiental sênior","mês",14636.78,0.79690000000000005,11664.05,4.8000000000000001E-2,702.89,1.6999999999999999E-3,24.99,0,0,0,0,2.0000000000000001E-4,3.6,0,0,1.9800000000000002E-2,289.39,6.9999999999999999E-4,9.98,0.86729999999999996,12694.9,27331.69,1030.8599999999988]
[null,"P8060","Engenheiro consultor especial","mês",21440.03,0.79700000000000004,17087.71,3.2800000000000003E-2,702.89,1.1000000000000001E-3,22.82,0,0,0,0,2.0000000000000001E-4,3.98,0,0,1.35E-2,289.39,5.0000000000000001E-4,9.98,0.84499999999999997,18116.77,39556.800000000003,1029.0600000000049]
[null,"P8061","Engenheiro coordenador","mês",17866.689999999999,0.79700000000000004,14239.76,3.9300000000000002E-2,702.89,1.2999999999999999E-3,22.82,0,0,0,0,2.0000000000000001E-4,3.98,0,0,1.6199999999999999E-2,289.39,5.9999999999999995E-4,9.98,0.85460000000000003,15268.82,33135.51,1029.0600000000013]
[null,"P8062","Engenheiro de pesca júnior","mês",12002,0.80289999999999995,9636.41,5.8599999999999999E-2,702.89,2.0999999999999999E-3,24.99,0,0,0,0,4.0000000000000002E-4,4.3899999999999997,0,0,2.41E-2,289.39,8.0000000000000004E-4,9.98,0.88890000000000002,10668.05,22670.05,1031.6399999999994]
[null,"P8063","Engenheiro de pesca pleno","mês",12623.69,0.80289999999999995,10135.56,5.57E-2,702.89,2E-3,24.99,0,0,0,0,2.9999999999999997E-4,4.3899999999999997,0,0,2.29E-2,289.39,8.0000000000000004E-4,9.98,0.88460000000000005,11167.2,23790.89,1031.6399999999994]
[null,"P8064","Engenheiro de pesca sênior","mês",16283.3,0.80289999999999995,13073.86,4.3200000000000002E-2,702.89,1.5E-3,24.99,0,0,0,0,2.9999999999999997E-4,4.3899999999999997,0,0,1.78E-2,289.39,5.9999999999999995E-4,9.98,0.86629999999999996,14105.5,30388.799999999999,1031.6399999999994]
[null,"P8065","Engenheiro de projetos júnior","mês",12002,0.79700000000000004,9565.59,5.8599999999999999E-2,702.89,2.0999999999999999E-3,24.99,0,0,0,0,2.9999999999999997E-4,3.98,0,0,2.41E-2,289.39,8.0000000000000004E-4,9.98,0.88290000000000002,10596.82,22598.82,1031.2299999999996]
[null,"P8066","Engenheiro de projetos pleno","mês",12379.96,0.79700000000000004,9866.83,5.6800000000000003E-2,702.89,2E-3,24.99,0,0,0,0,2.9999999999999997E-4,3.98,0,0,2.3400000000000001E-2,289.39,8.0000000000000004E-4,9.98,0.88029999999999997,10898.06,23278.02,1031.2300000000014]
[null,"P8067","Engenheiro de projetos sênior","mês",15564.54,0.79700000000000004,12404.93,4.5199999999999997E-2,702.89,1.6000000000000001E-3,24.99,0,0,0,0,2.9999999999999997E-4,3.98,0,0,1.8599999999999998E-2,289.39,5.9999999999999995E-4,9.98,0.86329999999999996,13436.16,29000.7,1031.2299999999996]
[null,"P8068","Engenheiro florestal júnior","mês",12002,0.80289999999999995,9636.41,5.8599999999999999E-2,702.89,2.0999999999999999E-3,24.99,0,0,0,0,4.0000000000000002E-4,4.3899999999999997,0,0,2.41E-2,289.39,8.0000000000000004E-4,9.98,0.88890000000000002,10668.05,22670.05,1031.6399999999994]
[null,"P8069","Engenheiro florestal pleno","mês",12623.69,0.80289999999999995,10135.56,5.57E-2,702.89,2E-3,24.99,0,0,0,0,2.9999999999999997E-4,4.3899999999999997,0,0,2.29E-2,289.39,8.0000000000000004E-4,9.98,0.88460000000000005,11167.2,23790.89,1031.6399999999994]
[null,"P8070","Engenheiro florestal sênior","mês",16283.3,0.80289999999999995,13073.86,4.3200000000000002E-2,702.89,1.5E-3,24.99,0,0,0,0,2.9999999999999997E-4,4.3899999999999997,0,0,1.78E-2,289.39,5.9999999999999995E-4,9.98,0.86629999999999996,14105.5,30388.799999999999,1031.6399999999994]
[null,"P8080","Geólogo júnior","mês",10004.5,0.8014,8017.61,7.0300000000000001E-2,702.89,2.5000000000000001E-3,24.99,0,0,0,0,2.9999999999999997E-4,3.44,0,0,2.8899999999999999E-2,289.39,1E-3,9.98,0.90439999999999998,9048.2999999999993,19052.8,1030.6899999999987]
[null,"P8081","Geólogo pleno","mês",11840.54,0.8014,9489.01,5.9400000000000001E-2,702.89,2.0999999999999999E-3,24.99,0,0,0,0,2.9999999999999997E-4,3.44,0,0,2.4400000000000002E-2,289.39,8.0000000000000004E-4,9.98,0.88839999999999997,10519.7,22360.25,1030.6999999999989]
[null,"P8082","Geólogo sênior","mês",13676.59,0.8014,10960.42,5.1400000000000001E-2,702.89,1.8E-3,24.99,0,0,0,0,2.9999999999999997E-4,3.44,0,0,2.12E-2,289.39,6.9999999999999999E-4,9.98,0.87680000000000002,11991.11,25667.7,1030.6900000000005]
[null,"P8092","Jornalista júnior","mês",3004.28,0.79579999999999995,2390.81,0.23400000000000001,702.89,8.3000000000000001E-3,24.99,0,0,1.29E-2,38.78,8.9999999999999998E-4,2.74,0,0,9.6299999999999997E-2,289.39,3.3E-3,9.98,1.1515,3459.58,6463.86,1068.7699999999995]
[null,"P8093","Jornalista pleno","mês",4005.71,0.79579999999999995,3187.74,0.17549999999999999,702.89,6.1999999999999998E-3,24.99,0,0,0,0,6.9999999999999999E-4,2.74,0,0,7.22E-2,289.39,2.5000000000000001E-3,9.98,1.0528999999999999,4217.74,8223.4500000000007,1030.0000000000009]
[null,"P8094","Jornalista sênior","mês",7743.99,0.79579999999999995,6162.67,9.0800000000000006E-2,702.89,3.2000000000000002E-3,24.99,0,0,0,0,4.0000000000000002E-4,2.74,0,0,3.7400000000000003E-2,289.39,1.2999999999999999E-3,9.98,0.92879999999999996,7192.67,14936.66,1030]
[null,"P8098","Laboratorista","mês",2294.9899999999998,0.80389999999999995,1844.94,0.30630000000000002,702.89,1.2200000000000001E-2,28.01,0,0,3.5400000000000001E-2,81.33,1.6999999999999999E-3,4.01,0,0,0.12609999999999999,289.39,4.3E-3,9.98,1.29,2960.56,5255.55,1115.6200000000003]
[null,"P8102","Médico veterinário","mês",12002,0.7913,9497.18,5.8599999999999999E-2,702.89,2.0999999999999999E-3,24.99,0,0,0,0,2.0000000000000001E-4,2.21,0,0,2.41E-2,289.39,8.0000000000000004E-4,9.98,0.87709999999999999,10526.65,22528.65,1029.4700000000012]
[null,"P8106","Meteorologista júnior","mês",5290.59,0.79220000000000002,4191.21,0.13289999999999999,702.89,4.7000000000000002E-3,24.99,0,0,0,0,5.0000000000000001E-4,2.4700000000000002,0,0,5.4699999999999999E-2,289.39,1.9E-3,9.98,0.98680000000000001,5220.92,10511.51,1029.71]
[null,"P8107","Meteorologista pleno","mês",7054.12,0.79220000000000002,5588.27,9.9599999999999994E-2,702.89,3.5000000000000001E-3,24.99,0,0,0,0,2.9999999999999997E-4,2.4700000000000002,0,0,4.1000000000000002E-2,289.39,1.4E-3,9.98,0.93820000000000003,6617.99,13672.11,1029.7200000000003]
[null,"P8108","Meteorologista sênior","mês",11877.06,0.79220000000000002,9409,5.9200000000000003E-2,702.89,2.0999999999999999E-3,24.99,0,0,0,0,2.0000000000000001E-4,2.4700000000000002,0,0,2.4400000000000002E-2,289.39,8.0000000000000004E-4,9.98,0.87890000000000001,10438.719999999999,22315.78,1029.7199999999993]
[null,"P8112","Motorista de caminhão","mês",2285.67,0.80620000000000003,1842.71,0.3075,702.89,1.3299999999999999E-2,30.42,0,0,3.5799999999999998E-2,81.89,1.9E-3,4.2699999999999996,0,0,0.12659999999999999,289.39,4.4000000000000003E-3,9.98,1.2957000000000001,2961.55,5247.22,1118.8400000000001]
[null,"P8113","Motorista de veículo leve","mês",2024.72,0.80200000000000005,1623.83,0.34720000000000001,702.89,1.4999999999999999E-2,30.42,0,0,4.82E-2,97.55,1.9E-3,3.86,0,0,0.1429,289.39,4.8999999999999998E-3,9.98,1.3621000000000001,2757.92,4782.6400000000003,1134.0900000000004]
[null,"P8117","Oceanógrafo júnior","mês",4943.07,0.80259999999999998,3967.31,0.14219999999999999,702.89,5.1000000000000004E-3,24.99,0,0,0,0,8.0000000000000004E-4,4.07,0,0,5.8500000000000003E-2,289.39,2E-3,9.98,1.0112000000000001,4998.63,9941.7000000000007,1031.3200000000015]
[null,"P8118","Oceanógrafo pleno","mês",6590.76,0.80259999999999998,5289.75,0.1066,702.89,3.8E-3,24.99,0,0,0,0,5.9999999999999995E-4,4.07,0,0,4.3900000000000002E-2,289.39,1.5E-3,9.98,0.95909999999999995,6321.07,12911.83,1031.3199999999997]
[null,"P8119","Oceanógrafo sênior","mês",12409.57,0.80259999999999998,9959.92,5.6599999999999998E-2,702.89,2E-3,24.99,0,0,0,0,2.9999999999999997E-4,4.07,0,0,2.3300000000000001E-2,289.39,8.0000000000000004E-4,9.98,0.88570000000000004,10991.24,23400.81,1031.3200000000015]
[null,"P8129","Pedagogo júnior","mês",2381.06,0.84530000000000005,2012.71,0.29520000000000002,702.89,1.0500000000000001E-2,24.99,0,0,3.2000000000000001E-2,76.17,4.0000000000000001E-3,9.57,0,0,0.1215,289.39,4.1999999999999997E-3,9.98,1.3127,3125.7,5506.75,1112.98]
[null,"P8130","Pedagogo pleno","mês",3174.74,0.84530000000000005,2683.61,0.22140000000000001,702.89,7.9000000000000008E-3,24.99,0,0,8.9999999999999993E-3,28.55,3.0000000000000001E-3,9.57,0,0,9.1200000000000003E-2,289.39,3.0999999999999999E-3,9.98,1.1809000000000001,3748.98,6923.72,1065.3700000000008]
[null,"P8131","Pedagogo sênior","mês",4728.95,0.84530000000000005,3997.38,0.14860000000000001,702.89,5.3E-3,24.99,0,0,0,0,2E-3,9.57,0,0,6.1199999999999997E-2,289.39,2.0999999999999999E-3,9.98,1.0646,5034.2,9763.15,1036.8199999999997]
[null,"P8135","Secretária","mês",2604.7800000000002,0.79759999999999998,2077.5700000000002,0.26979999999999998,702.89,0,0,0,0,2.41E-2,62.75,1.4E-3,3.6,0,0,0.1111,289.39,3.8E-3,9.98,1.2079,3146.18,5750.97,{"$f":"Z68-G68-E68","v":1068.6199999999999}]
[null,"P8139","Sondador","mês",1989.67,0.80010000000000003,1591.94,0.3533,702.89,1.41E-2,28.01,0,0,5.0099999999999999E-2,99.65,2.3E-3,4.57,0,0,0.1454,289.39,5.0000000000000001E-3,9.98,1.3703000000000001,2726.43,4716.1000000000004,1134.4900000000002]
[null,"P8143","Técnico ambiental","mês",2831.37,0.80710000000000004,2285.1999999999998,0.24829999999999999,702.89,9.9000000000000008E-3,28.01,0,0,1.7399999999999999E-2,49.15,1.6999999999999999E-3,4.9000000000000004,0,0,0.1022,289.39,3.5000000000000001E-3,9.98,1.1900999999999999,3369.53,6200.9,1084.33]
[null,"P8147","Técnico de obras","mês",3167.62,0.80210000000000004,2540.75,0.22189999999999999,702.89,8.8000000000000005E-3,28.01,0,0,9.1000000000000004E-3,28.97,1.1999999999999999E-3,3.79,0,0,9.1399999999999995E-2,289.39,3.2000000000000002E-3,9.98,1.1376999999999999,3603.79,6771.41,1063.04]
[null,"P8151","Técnico de segurança do trabalho","mês",4457.84,0.8095,3608.62,0.15770000000000001,702.89,6.3E-3,28.01,0,0,0,0,1E-3,4.68,0,0,6.4899999999999999E-2,289.39,2.2000000000000001E-3,9.98,1.0417000000000001,4643.57,9101.41,1034.9499999999998]
[null,"P8155","Técnico em geoprocessamento","mês",2801.45,0.7974,2233.88,0.25090000000000001,702.89,0.01,28.01,0,0,1.8200000000000001E-2,50.94,1.2999999999999999E-3,3.73,0,0,0.1033,289.39,3.5999999999999999E-3,9.98,1.1847000000000001,3318.83,6120.29,1084.96]
[null,"P8159","Técnico em informática - programador","mês",4761.5,0.80149999999999999,3816.34,0.14760000000000001,702.89,0,0,0,0,0,0,8.0000000000000004E-4,3.61,0,0,6.08E-2,289.39,2.0999999999999999E-3,9.98,1.0127999999999999,4822.22,9583.7199999999993,1005.8799999999992]
[null,"P8163","Topógrafo","mês",2390.63,0.80669999999999997,1928.52,0.29399999999999998,702.89,1.17E-2,28.01,0,0,3.1600000000000003E-2,75.59,1.8E-3,4.3899999999999997,0,0,0.1211,289.39,4.1999999999999997E-3,9.98,1.2710999999999999,3038.78,5429.4,1110.2499999999995]
[null,"P8167","Arquivista júnior","mês",2378.02,0.80020000000000002,1902.89,0.29559999999999997,702.89,0,0,0,0,3.2099999999999997E-2,76.349999999999994,1.4E-3,3.25,0,0,0.1217,289.39,4.1999999999999997E-3,9.98,1.2551000000000001,2984.76,5362.77,1081.8600000000001]
[null,"P8168","Arquivista pleno","mês",3170.69,0.80020000000000002,2537.19,0.22170000000000001,702.89,0,0,0,0,9.1000000000000004E-3,28.79,1E-3,3.25,0,0,9.1300000000000006E-2,289.39,3.0999999999999999E-3,9.98,1.1264000000000001,3571.49,6742.18,1034.2999999999997]
[null,"P8169","Arquivista sênior","mês",5052.6400000000003,0.80020000000000002,4043.13,0.1391,702.89,0,0,0,0,0,0,5.9999999999999995E-4,3.25,0,0,5.7299999999999997E-2,289.39,2E-3,9.98,0.99919999999999998,5048.6400000000003,10101.290000000001,1005.5200000000004]
[null,"P8173","Administrador júnior","mês",3268.41,0.79790000000000005,2607.86,0.21510000000000001,702.89,0,0,0,0,7.0000000000000001E-3,22.93,1.1000000000000001E-3,3.71,0,0,8.8499999999999995E-2,289.39,3.0999999999999999E-3,9.98,1.1127,3636.77,6905.18,1028.9099999999999]
[null,"P8174","Administrador pleno","mês",4357.88,0.79790000000000005,3477.15,0.1613,702.89,0,0,0,0,0,0,8.9999999999999998E-4,3.71,0,0,6.6400000000000001E-2,289.39,2.3E-3,9.98,1.0286999999999999,4483.13,8841.01,1005.9800000000005]
[null,"P8175","Administrador sênior","mês",7766,0.79790000000000005,6196.49,9.0499999999999997E-2,702.89,0,0,0,0,0,0,5.0000000000000001E-4,3.71,0,0,3.73E-2,289.39,1.2999999999999999E-3,9.98,0.9274,7202.46,14968.46,1005.9699999999993]
[null,"P8180","Engenheiro agrimensor júnior","mês",12002,0.79820000000000002,9580,5.8599999999999999E-2,702.89,2.0999999999999999E-3,24.99,0,0,0,0,2.9999999999999997E-4,4.17,0,0,2.41E-2,289.39,8.0000000000000004E-4,9.98,0.8841,10611.41,22613.41,1031.4099999999999]
[null,"P8181","Engenheiro agrimensor pleno","mês",13020.37,0.79820000000000002,10392.86,5.3999999999999999E-2,702.89,1.9E-3,24.99,0,0,0,0,2.9999999999999997E-4,4.17,0,0,2.2200000000000001E-2,289.39,8.0000000000000004E-4,9.98,0.87739999999999996,11424.28,24444.65,1031.42]
[null,"P8182","Engenheiro agrimensor sênior","mês",14038.74,0.79820000000000002,11205.72,5.0099999999999999E-2,702.89,1.8E-3,24.99,0,0,0,0,2.9999999999999997E-4,4.17,0,0,2.06E-2,289.39,6.9999999999999999E-4,9.98,0.87170000000000003,12237.14,26275.88,1031.4200000000019]
[null,"P8183","Geógrafo júnior","mês",3842.9,0.79679999999999995,3062.02,0.18290000000000001,702.89,6.4999999999999997E-3,24.99,0,0,0,0,8.0000000000000004E-4,3.25,0,0,7.5300000000000006E-2,289.39,2.5999999999999999E-3,9.98,1.0649999999999999,4092.52,7935.42,1030.4999999999995]
[null,"P8184","Geógrafo pleno","mês",5123.87,0.79679999999999995,4082.7,0.13719999999999999,702.89,4.8999999999999998E-3,24.99,0,0,0,0,5.9999999999999995E-4,3.25,0,0,5.6500000000000002E-2,289.39,1.9E-3,9.98,0.99790000000000001,5113.2,10237.07,1030.5]
[null,"P8185","Geógrafo sênior","mês",9831.81,0.79679999999999995,7833.99,7.1499999999999994E-2,702.89,2.5000000000000001E-3,24.99,0,0,0,0,2.9999999999999997E-4,3.25,0,0,2.9399999999999999E-2,289.39,1E-3,9.98,0.90159999999999996,8864.49,18696.3,1030.5]
[null,"P8186","Antropólogo júnior","mês",2946.19,0.81679999999999997,2406.4499999999998,0.23860000000000001,702.89,8.5000000000000006E-3,24.99,0,0,1.43E-2,42.26,1.8E-3,5.32,0,0,9.8199999999999996E-2,289.39,3.3999999999999998E-3,9.98,1.1816,3481.28,6427.47,1074.8300000000004]
[null,"P8187","Antropólogo pleno","mês",3928.26,0.81679999999999997,3208.6,0.1789,702.89,6.4000000000000003E-3,24.99,0,0,0,0,1.4E-3,5.32,0,0,7.3700000000000002E-2,289.39,2.5000000000000001E-3,9.98,1.0797000000000001,4241.17,8169.43,1032.5699999999997]
[null,"P8188","Antropólogo sênior","mês",5873.81,0.81679999999999997,4797.7299999999996,0.1197,702.89,4.3E-3,24.99,0,0,0,0,8.9999999999999998E-4,5.32,0,0,4.9299999999999997E-2,289.39,1.6999999999999999E-3,9.98,0.99260000000000004,5830.3,11704.11,1032.5700000000006]
[null,"P8189","Arqueólogo júnior","mês",2738.44,0.79869999999999997,2187.19,0.25669999999999998,702.89,9.1000000000000004E-3,24.99,0,0,0.02,54.73,1.4E-3,3.74,0,0,0.1057,289.39,3.5999999999999999E-3,9.98,1.1952,3272.9,6011.34,1085.71]
[null,"P8190","Arqueólogo pleno","mês",3651.25,0.79869999999999997,2916.26,0.1925,702.89,6.7999999999999996E-3,24.99,0,0,0,0,1E-3,3.74,0,0,7.9299999999999995E-2,289.39,2.7000000000000001E-3,9.98,1.0810999999999999,3947.24,7598.5,1030.9899999999998]
[null,"P8191","Arqueólogo sênior","mês",5503.01,0.79869999999999997,4395.25,0.12770000000000001,702.89,4.4999999999999997E-3,24.99,0,0,0,0,6.9999999999999999E-4,3.74,0,0,5.2600000000000001E-2,289.39,1.8E-3,9.98,0.98609999999999998,5426.24,10929.24,1030.9799999999996]
[null,"P8192","Historiador júnior","mês",3935.94,0.80330000000000001,3161.74,0.17860000000000001,702.89,6.3E-3,24.99,0,0,0,0,8.9999999999999998E-4,3.7,0,0,7.3499999999999996E-2,289.39,2.5000000000000001E-3,9.98,1.0651999999999999,4192.6899999999996,8128.63,1030.9500000000003]
[null,"P8193","Historiador pleno","mês",5247.92,0.80330000000000001,4215.66,0.13389999999999999,702.89,4.7999999999999996E-3,24.99,0,0,0,0,6.9999999999999999E-4,3.7,0,0,5.5100000000000003E-2,289.39,1.9E-3,9.98,0.99970000000000003,5246.6,10494.53,1030.9500000000007]
[null,"P8194","Historiador sênior","mês",8467.7999999999993,0.80330000000000001,6802.19,8.3000000000000004E-2,702.89,3.0000000000000001E-3,24.99,0,0,0,0,4.0000000000000002E-4,3.7,0,0,3.4200000000000001E-2,289.39,1.1999999999999999E-3,9.98,0.92500000000000004,7833.13,16300.93,1030.9400000000023]
[null,"P8195","Paleontólogo júnior","mês",2946.19,0.81679999999999997,2406.4499999999998,0.23860000000000001,702.89,8.5000000000000006E-3,24.99,0,0,1.43E-2,42.26,1.8E-3,5.32,0,0,9.8199999999999996E-2,289.39,3.3999999999999998E-3,9.98,1.1816,3481.28,6427.47,1074.8300000000004]
[null,"P8196","Paleontólogo pleno","mês",3928.26,0.81679999999999997,3208.6,0.1789,702.89,6.4000000000000003E-3,24.99,0,0,0,0,1.4E-3,5.32,0,0,7.3700000000000002E-2,289.39,2.5000000000000001E-3,9.98,1.0797000000000001,4241.17,8169.43,1032.5699999999997]
[null,"P8197","Paleontólogo sênior","mês",5873.81,0.81679999999999997,4797.7299999999996,0.1197,702.89,4.3E-3,24.99,0,0,0,0,8.9999999999999998E-4,5.32,0,0,4.9299999999999997E-2,289.39,1.6999999999999999E-3,9.98,0.99260000000000004,5830.3,11704.11,1032.5700000000006]
[null,"P8198","Sociólogo júnior","mês",4060.7,0.80330000000000001,3261.96,0.1731,702.89,6.1999999999999998E-3,24.99,0,0,0,0,8.9999999999999998E-4,3.7,0,0,7.1300000000000002E-2,289.39,2.5000000000000001E-3,9.98,1.0571999999999999,4292.91,8353.6,{"$f":"Z100-G100-E100","v":1030.9400000000005}]
[null,"P8199","Sociólogo pleno","mês",5414.26,0.80330000000000001,4349.28,0.1298,702.89,4.5999999999999999E-3,24.99,0,0,0,0,6.9999999999999999E-4,3.7,0,0,5.3400000000000003E-2,289.39,1.8E-3,9.98,0.99370000000000003,5380.23,10794.49,1030.9499999999998]
[null,"P8200","Sociólogo sênior","mês",8587.73,0.80330000000000001,6898.53,8.1799999999999998E-2,702.89,2.8999999999999998E-3,24.99,0,0,0,0,4.0000000000000002E-4,3.7,0,0,3.3700000000000001E-2,289.39,1.1999999999999999E-3,9.98,0.92330000000000001,7929.47,16517.21,1030.9500000000007]
[null,"Profissionais horistas"]
[null,"P8250","Auxiliar - horista","h",7.07,1.1323000000000001,8,0.54520000000000002,3.85,2.3599999999999999E-2,0.17,1.1999999999999999E-3,0.01,9.7500000000000003E-2,0.69,4.7999999999999996E-3,0.03,0,0,0.22439999999999999,1.59,7.7000000000000002E-3,0.05,2.0367999999999999,14.39,21.46]
[null,"P8251","Auxiliar de laboratório - horista","h",7.82,1.1316999999999999,8.85,0.49230000000000002,3.85,2.1299999999999999E-2,0.17,2.3E-3,0.02,8.1100000000000005E-2,0.63,2.8E-3,0.02,0,0,0.20269999999999999,1.59,7.0000000000000001E-3,0.05,1.9411,15.19,23.01]
[null,"P8255","Engenheiro de projetos júnior - horista","h",54.55,1.1314,61.72,7.0599999999999996E-2,3.85,2.5000000000000001E-3,0.14000000000000001,0,0,0,0,4.0000000000000002E-4,0.02,0,0,2.9100000000000001E-2,1.59,1E-3,0.05,1.2350000000000001,67.37,121.93]
[null,"P8256","Engenheiro de projetos pleno - horista","h",56.27,1.1314,63.67,6.8400000000000002E-2,3.85,2.3999999999999998E-3,0.14000000000000001,0,0,0,0,4.0000000000000002E-4,0.02,0,0,2.8199999999999999E-2,1.59,1E-3,0.05,1.2318,69.319999999999993,125.59]
[null,"P8260","Laboratorista - horista","h",10.43,1.1316999999999999,11.81,0.36919999999999997,3.85,1.47E-2,0.15,0,0,4.2700000000000002E-2,0.45,2.0999999999999999E-3,0.02,0,0,0.152,1.59,5.1999999999999998E-3,0.05,1.7177,17.920000000000002,28.35]
[null,"P8263","Motorista de caminhão - horista ","h",10.39,1.1326000000000001,11.77,0.37069999999999997,3.85,1.6E-2,0.17,0,0,4.3200000000000002E-2,0.45,2.3E-3,0.02,0,0,0.15260000000000001,1.59,5.3E-3,0.05,1.7226999999999999,17.899999999999999,28.29]
[null,"P8264","Motorista de veículo leve - horista","h",9.1999999999999993,1.1317999999999999,10.42,0.41849999999999998,3.85,1.8100000000000002E-2,0.17,0,0,5.8099999999999999E-2,0.53,2.3E-3,0.02,0,0,0.17230000000000001,1.59,5.8999999999999999E-3,0.05,1.8070999999999999,16.63,25.83]
[null,"P8267","Sondador - horista","h",9.0399999999999991,1.1315999999999999,10.23,0.4259,3.85,1.7000000000000001E-2,0.15,0,0,6.0400000000000002E-2,0.55000000000000004,2.8E-3,0.03,0,0,0.17530000000000001,1.59,6.0000000000000001E-3,0.05,1.819,16.45,25.49]
[null,"P8270","Técnico de obras - horista","h",14.4,1.1312,16.29,0.26750000000000002,3.85,1.0699999999999999E-2,0.15,0,0,1.0999999999999999E-2,0.16,1.4E-3,0.02,0,0,0.1101,1.59,3.8E-3,0.05,1.5358000000000001,22.11,36.51]