{"text_format":"2","workbook":"xlsx","n_sheets":14,"sheets":["PFP","PFP1.1_Topo","PFP1.2_Geo","PFP2.1_FatorKa","PFP2.2_FatorKb","PFP2.3_FatorKc","PFP3_FatorKd","CRO1_Ins-Pro","CRO2_Ins-Mes","COT. VANT","Planilha de Medição","Cronograma Físico-Financeiro","CPU VEICULO_PickUp","Consultiva atualizada"],"not_rendered":{"charts":0,"images":13,"macros":0,"external_links":34,"defined_names":4318,"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":"PFP","index":0,"n_rows":42,"n_cols":12,"rows_kept":42,"cut":false,"hidden":false,"merged":[[23,0,23,6],[23,7,23,10],[26,0,26,10],[25,0,25,10],[13,1,13,2],[14,1,14,2],[15,1,15,2],[16,1,16,2],[22,7,22,10],[22,0,22,6],[21,7,21,10],[21,0,21,6],[37,0,37,10],[30,0,30,10],[32,0,32,10],[24,0,24,10],[31,0,31,10],[27,0,27,10],[33,0,33,10],[34,0,34,10],[35,0,35,10],[36,0,36,10],[28,0,28,10],[29,0,29,10],[0,0,1,8],[4,5,4,8],[0,9,0,10],[1,9,1,10],[4,9,4,10],[2,0,2,10],[3,0,3,10],[4,0,4,4],[5,9,5,10],[5,5,5,8],[20,0,20,6],[20,7,20,10],[5,0,5,4],[19,0,19,6],[19,7,19,10],[6,1,6,2],[7,1,7,2],[8,1,8,2],[9,1,9,2],[10,1,10,2],[11,1,11,2],[17,1,17,2],[18,1,18,2],[12,1,12,2]]}
["PROPOSTA FINANCEIRA DO PROJETO",{"$nulls":8},"CODIGO:"]
[{"$nulls":9},"PFP"]
["NOME DA CONSULTORA:"]
[]
["PROJETO:",{"$nulls":4},"CONTRATANTE:",null,null,null,"BASE:"]
["ELABORAÇÃO DE ESTUDO DE VIABILIDADE TÉCNICA, ECONÔMICA E AMBIENTAL, ESTUDOS BÁSICOS, PROJETO BÁSICO E PROJETO EXECUTIVO PARA PARA CONSTRUÇÃO DA INFRAESTRUTURA RODOVIÁRIA DA ESTRADA PARQUE LINHA DO EQUADOR, NO ESTADO DO AMAPÁ",{"$nulls":4},"CODEVASF (SEDE)",null,null,null,"2024-03-01"]
["Base","Código",null,"Categoria / Insumo","Uni","Qde","CUD","PU","FatorK","CT","PT","Encargos COMP E ADICIONAIS"]
["SICRO","P8061",null,"Engenheiro coordenador (P8061)","mês",{"$f":"'CRO1_Ins-Pro'!D5","v":1.05},{"$f":"VLOOKUP(B8,'Consultiva atualizada'!A:Y,4,FALSE)","v":17866.689999999999},{"$f":"ROUND(I8*G8,2)","v":23042.67},{"$f":"'PFP2.3_FatorKc'!E35","v":1.2897000000000001},{"$f":"ROUND(F8*G8,2)","v":18760.02},{"$f":"ROUND(F8*H8,2)","v":24194.799999999999},{"$f":"14633.42-13607.04","v":1026.3799999999992}]
["SICRO","P8066",null,"Engenheiro pleno (P8066)","mês",{"$f":"'CRO1_Ins-Pro'!D6","v":4.5},{"$f":"VLOOKUP(B9,'Consultiva atualizada'!A:Y,4,FALSE)","v":12379.96},{"$f":"ROUND(I9*G9,2)","v":26364.36},{"$f":"'PFP2.1_FatorKa'!E36","v":2.1295999999999999},{"$f":"ROUND(F9*G9,2)","v":55709.82},{"$f":"ROUND(F9*H9,2)","v":118639.62},{"$f":"10299.82-9271.29","v":1028.5299999999988}]
["SICRO","P8065",null,"Engenheiro júnior (P8065)","mês",{"$f":"'CRO1_Ins-Pro'!D7","v":6},{"$f":"VLOOKUP(B10,'Consultiva atualizada'!A:Y,4,FALSE)","v":12002},{"$f":"ROUND(I10*G10,2)","v":25559.46},{"$f":"'PFP2.1_FatorKa'!E36","v":2.1295999999999999},{"$f":"ROUND(F10*G10,2)","v":72012},153356.76,{"$f":"9942.82-8914.29","v":1028.5299999999988}]
["SINAPI",40807,null,"Desenhista (40807)","mês",{"$f":"'CRO1_Ins-Pro'!D8","v":10},2799.33,5961.45,{"$f":"'PFP2.1_FatorKa'!E36","v":2.1295999999999999},27993.3,59614.5,{"$f":"3022.03-1944.87","v":1077.1600000000003}]
["SICRO","P8147",null,"Técnico de projetos/obra (P8147)","mês",{"$f":"'CRO1_Ins-Pro'!D9","v":5.5},{"$f":"VLOOKUP(B12,'Consultiva atualizada'!A:Y,4,FALSE)","v":3167.62},{"$f":"ROUND(I12*G12,2)","v":6745.76},{"$f":"'PFP2.1_FatorKa'!E36","v":2.1295999999999999},17421.91,37101.68,{"$f":"3553.62-2489.97","v":1063.6500000000001}]
["SICRO",null,null,"Encargos Comp. e Adicionais","mês",{"$f":"SUM(F8:F12)","v":27.05},{"$f":"(F8*L8+F9*L9+F10*L10+F11*L11+F12*L12)/SUM(F8:F12)","v":1053.5652125693157},1267.02,{"$f":"PFP3_FatorKd!$E$17","v":1.2025999999999999},{"$f":"ROUND(F13*G13,2)","v":28498.94},34272.89]
["PROP","N.A",null,"Auxilio Transporte Técnicos","mês",{"$f":"'CRO1_Ins-Pro'!D11","v":0},"Já incluso*",0,0,0,0]
["PROP","N.A",null,"Auxilio Transporte Secretária","mês",{"$f":"'CRO1_Ins-Pro'!D12","v":0},"Já Incluso*",0,0,0,0]
["CODE","Próprio",null,"Relatório Parcial","un",{"$f":"'CRO1_Ins-Pro'!D13","v":0},33.35,40.11,{"$f":"PFP3_FatorKd!$E$17","v":1.2025999999999999},0,0]
["CODE","Próprio",null,"Relatório Final","un",{"$f":"'CRO1_Ins-Pro'!D14","v":4},1478.8,1778.4,{"$f":"PFP3_FatorKd!$E$17","v":1.2025999999999999},5915.2,7113.6]
["CODE","Próprio",null,"Total Serviços Cartográficos","un",1,"-",{"$f":"'PFP1.1_Topo'!H22","v":45421.48},"-","-",45421.48]
["CODE","Próprio",null,"Total Serviços Geotécnicos","un",1,"-",{"$f":"'PFP1.2_Geo'!H41","v":119321.39},"-","-",119321.39]
["TOTAL DOS CUSTOS DIRETOS",{"$nulls":6},{"$f":"SUM(J8:J19)","v":226311.19}]
["TOTAL DOS ENCARGOS E DISPESAS DIVERSAS",{"$nulls":6},{"$f":"H22-H20","v":207982.65999999997}]
["TOTAL DA PROPOSTA A PREÇO GLOBAL",{"$nulls":6},{"$f":"SUM(K8:K17)","v":434293.85}]
["TOTAL DA PROPOSTA A PREÇO UNITÁRIO",{"$nulls":6},{"$f":"SUM(K18:K19)","v":164742.87}]
["TOTAL DA PROPOSTA",{"$nulls":6},{"$f":"H22+H23","v":599036.72}]
["OBSERVAÇÃO:"]
["*Encargos Complementares e adicionais já incluem auxílio transporte"]
["Alocar os Insumos MO, com respectivo FatorK, dentro da categoria de vínculo contratual (celetista, autonomo, societario)"]
["Uni - unidade de medição do insumo;"]
["Qde - Quantidade do Insumo (não pode ocorrer alteração pela Licitante)"]
["CUD - Custo Unitário Direto do Insumo (sem encargos, taxas e impostos, valor não pode ser maior que o Orçado pela Codevasf)"]
["CT - Custo Total (sem encargos, taxas e impostos) - CT = Qde x CUD"]
["FatorK - Taxa de Ressarcimento de Despesas e Encargos (detalhar composição nas Planilhas \"PFP2.1\", \"PFP2.2\", \"PFP3\")"]
["PU - Preço Unitário do Insumo (incluído encargos, taxas e impostos) - PU = CUD x FatorK"]
["PT - Preço Total do Insumo (incluído encargos, taxas e impostos) - PT = Qde x PU"]
["P - Profissionais nível superior nas áreas de Engenharia, Química, Arquitetura, Agronomia e Veterinária, conforme disposições da Lei 4.950-A/66"]
["S - Profissionais de nível superior nas demais áreas de atuação, incluindo Arqueólogo, Biólogo, Geógrafo e Sociólogo"]
["T - Profissionais de nível médio técnico nas diversas áreas de atuação"]
["A - Profissionais de nível médio de apoio técnico-administrativo"]
[]
["Observações: "]
["1- Sistemas oficiais de referência de preços utilizados"]
["Tabela Consultiva do DNIT-Jul/2023."]

{"sheet":"PFP1.1_Topo","index":1,"n_rows":27,"n_cols":8,"rows_kept":27,"cut":false,"hidden":false,"merged":[[26,0,26,7],[0,0,1,6],[2,0,2,7],[3,0,3,7],[4,0,4,4],[4,5,4,6],[5,0,5,4],[5,5,5,6],[21,0,21,6],[22,0,22,7],[23,0,23,7],[24,0,24,7],[25,0,25,7]]}
["SERVIÇOS TOPOGRÁFICOS/CARTOGRÁFICOS",{"$nulls":6},"CODIGO:"]
[{"$nulls":7},"PFP-1.1"]
["NOME DA EMPRESA:"]
[]
["PROJETO:",{"$nulls":4},"CONTRATANTE:",null,{"$f":"PFP!J5","v":"BASE:"}]
[{"$f":"PFP!A6","v":"ELABORAÇÃO DE ESTUDO DE VIABILIDADE TÉCNICA, ECONÔMICA E AMBIENTAL, ESTUDOS BÁSICOS, PROJETO BÁSICO E PROJETO EXECUTIVO PARA PARA CONSTRUÇÃO DA INFRAESTRUTURA RODOVIÁRIA DA ESTRADA PARQUE LINHA DO EQUADOR, NO ESTADO DO AMAPÁ"},{"$nulls":4},"CODEVASF (SEDE)",null,{"$f":"PFP!J6","v":"2024-03-01"}]
["Cod.","Referência","Código","Insumos","Uni","Qde","Preço Unitário (PU)","Preço Total (PT)"]
["TP01","Engenharia Consultiva Codevasf ","CODE","Nivelamento Geométrico dos Eixos classe IIN","km",1.5,1143.76,{"$f":"ROUND(G8*F8,2)","v":1715.64}]
["TP02","Engenharia Consultiva Codevasf ","CODE","Seções Tranversais","km",7,394.36,{"$f":"ROUND(G9*F9,2)","v":2760.52}]
["TP03","EMOP/COMPOSIÇÃO","01.016.0035-0","Poligonal Classe IIP","km",1.5,1366.27,{"$f":"ROUND(G10*F10,2)","v":2049.41}]
["TP04","CPOS/CDHU-SP/COMPOSIÇÃO","01.20.921","Pontos GPS de dupla frequencia (L1/L2)","un ",4,1257.0899999999999,5028.3599999999997]
[null,null,null,"Aerolevantamento com VANT/RPA categoria 3","ha ",400,70,{"$f":"F12*G12","v":28000}]
[null,null,null,"Levantamentos Topobatimétricos","km",1.5,527.58000000000004,{"$f":"F13*G13","v":791.37000000000012}]
["TP05","CODE","CODE","Cadastro Físico","ha ",45,16.100000000000001,724.5]
["TP06","CODE","CODE","Cadastro Agrícola","ha ",45,5.37,241.65]
["TP07","CODE","CODE","Cadastro Jurídico","ha ",45,10.74,483.3]
["TP08","CODE","CODE","Cadastro Socioeconomico","ha ",45,3.58,161.1]
["TP10","ORSE/INSUMO",4369,"Marco de Concreto (12x18x60cm)","un ",4,73,292]
["TP11","EMBASA/INSUMO","D059722497","Barrote de Madeira (10x10x50cm)","un ",350,0.55000000000000004,192.5]
["TP12","SEINFRA/INSUMO","I1652","Piquetes de Madeira (2x2x20cm)","un ",350,2.08,728]
["TP13","EMOP/COMPOSIÇÃO","01.005.0014-A","Picada p/ levantamento TP","km",1,2253.13,2253.13]
["TOTAL SERVIÇOS TOPOGRÁFICOS",{"$nulls":6},{"$f":"SUM(H8:H21)","v":45421.48}]
["OBSERVAÇÃO:"]
["Uni - unidade de medição do insumo;"]
["Qde - Quantidade do Insumo (não pode ocorrer alteração pela Licitante)"]
["PU - Preço Unitário (composições padrão da Codevasf, já incluso o FatorK)"]
["PT - Preço Total (incluído encargos, taxas e impostos) - PT = Qde x PU"]

{"sheet":"PFP1.2_Geo","index":2,"n_rows":46,"n_cols":8,"rows_kept":46,"cut":false,"hidden":false,"merged":[[5,0,5,4],[5,5,5,6],[0,0,1,6],[2,0,2,7],[3,0,3,7],[4,0,4,4],[4,5,4,6],[44,0,44,7],[45,0,45,7],[40,0,40,6],[41,0,41,7],[42,0,42,7],[43,0,43,7]]}
["SERVIÇOS GEOLÓGICOS/GEOTÉCNICOS",{"$nulls":6},"CODIGO:"]
[{"$nulls":7},"PFP-1.2"]
["NOME DA EMPRESA:"]
[]
["PROJETO: ",{"$nulls":4},"CONTRATANTE:",null,{"$f":"PFP!J5","v":"BASE:"}]
[{"$f":"PFP!A6","v":"ELABORAÇÃO DE ESTUDO DE VIABILIDADE TÉCNICA, ECONÔMICA E AMBIENTAL, ESTUDOS BÁSICOS, PROJETO BÁSICO E PROJETO EXECUTIVO PARA PARA CONSTRUÇÃO DA INFRAESTRUTURA RODOVIÁRIA DA ESTRADA PARQUE LINHA DO EQUADOR, NO ESTADO DO AMAPÁ"},{"$nulls":4},"CODEVASF (SEDE)",null,{"$f":"PFP!J6","v":"2024-03-01"}]
["Cod.","Referência","Código","Insumos","Uni","Qde","Preço Unitário (PU)","Preço Total (PT)"]
["GT 1","CODE",null,"Sondagem a Percussão SPT"]
["GT1.1","SUDECAP/INSUMO","95.01.01","Sondagem Percussão: (Des)Mobilização por equipe","un",1,1500,{"$f":"F9*G9","v":1500}]
["GT1.2","AGETOP Civil/GO",2460,"Sondagem Percursão: com SPT - Terrestre","m",180,66.94,{"$f":"F10*G10","v":12049.199999999999}]
[null,null,null,"Sondagem a trado","m"]
["GT 2","CODE",null,"Ensaios:"]
[null,null,null,"Coleta de Amostras Indeformadas","un",5,855,{"$f":"G13*F13","v":4275}]
["GT 2.1","CODE",null,"Ensaios de solo"]
["GT 2.1.1","SUDECAP","97.01.01","Ensaio: Umidade Natural ","un",40,30,{"$f":"F15*G15","v":1200}]
["GT 2.1.2","SETOP","MATED-11061","Ensaio: Densidade Natural","un",40,50.08,2003.1999999999998]
["GT 2.1.3","SETOP","MATED-11053","Ensaio: Limite de Liquidez","un",40,79.81,3192.4]
["GT 2.1.4","SETOP","MATED-11054","Ensaio: Limite de Plasticidade","un",40,79.819999999999993,3192.7999999999997]
["GT 2.1.5","CODE","MATED-11052","Ensaio: Granulometria por Peneiramento","un",40,150.69,6027.6]
["GT 2.1.6","CODE","MATED-11052","Ensaio: Granulometria por Sedimentação","un",40,150.69,6027.6]
["GT 2.1.7","CODE","MATED-11062","Ensaio: Massa Especifica Real dos Grãos","un",40,61.82,2472.8000000000002]
["GT 2.1.8","CODE","MATED-11062","Ensaio: Massa Específica Aparente \"in situ\"","un",40,61.82,2472.8000000000002]
["GT 2.1.9","ORSE",4330,"Ensaio: Compactação Proctor Normal","un",40,220,8800]
["GT 2.1.10","EMBASA","E200340134","Ensaio: Índice de Suporte California e Expansão","un",40,350,14000]
[null,null,null,"Ensaio: Adensamento oedométrico","un",15,142,2130]
[null,null,null,"Ensaio: Cisalhamento Direto","un",8,1510.32,12082.56]
[null,null,null,"Ensaio: Triaxial CU - Consolidado Não Drenado","un",4,2500,10000]
["GT 2.3","CODE",null,"Ensaios de Análise da Areia"]
["GT 2.3.1","CODE",null,"Ensaio: Teor de Matéria Orgânica","un",10,200,2000]
["GT 2.3.2","ORSE",6939,"Ensaio: Equivalente Areia ","un",10,175,1750]
["GT 2.4","CODE",null,"Ensaios de Material Pétreo"]
[null,null,null,"Coleta de Material Pétreo","un",5,200,1000]
["GT 2.4.1","CODE",null,"Ensaio: Abrasão los Angeles ","un",5,842.74,4213.7]
["GT 2.4.2","ORSE",4339,"Ensaio: Índice de Forma","un",5,230.77,1153.8500000000001]
["GT 2.4.3","ORSE",4338,"Ensaio: Adesividade","un",5,81.45,407.25]
[null,null,null,"Ensaio: Durabilidade","un",5,760,3800]
[null,null,null,"Ensaio: Absorção","un",5,120,600]
["GT 3","CODE",null,"Sondagem Mista"]
["01.21.090","EMBASA","E200320516","Sondagem Mista: (Des)Mobilização","un",1,3157.33,{"$f":"F39*G39","v":3157.33}]
["C0333","SEINFRA","I0454","Sondagem Mista: em rochas","m",10,981.33,{"$f":"F40*G40","v":9813.3000000000011}]
["TOTAL SERVIÇOS GEOTÉCNICOS",{"$nulls":6},{"$f":"SUM(H8:H40)","v":119321.39}]
["LEGENDA:"]
["Uni - unidade de medição do insumo;"]
["Qde - Quantidade do Insumo (não pode ocorrer alteração pela Licitante)"]
["PU - Preço Unitário (composições padrão da Codevasf, já incluso o FatorK)"]
["PT - Preço Total (incluído encargos, taxas e impostos) - PT = Qde x PU"]

{"sheet":"PFP2.1_FatorKa","index":3,"n_rows":41,"n_cols":6,"rows_kept":41,"cut":false,"hidden":false,"merged":[[35,1,35,3],[6,1,6,3],[40,0,40,5],[39,0,39,5],[38,0,38,5],[37,0,37,5],[22,1,22,3],[29,1,29,3],[30,1,30,3],[28,1,28,3],[25,1,25,3],[26,1,26,3],[27,1,27,3],[33,1,33,3],[31,1,31,3],[32,1,32,3],[34,1,34,3],[0,0,1,4],[2,0,2,5],[5,0,5,1],[5,2,5,4],[4,2,4,4],[3,0,3,5],[24,1,24,3],[7,1,7,3],[17,1,17,3],[8,1,8,3],[13,1,13,3],[14,1,14,3],[15,1,15,3],[18,1,18,3],[19,1,19,3],[20,1,20,3],[21,1,21,3],[23,1,23,3],[9,1,9,3],[10,1,10,3],[11,1,11,3],[12,1,12,3]]}
["DETALHAMENTO DOS ENCARGOS SOCIAIS: Ka",{"$nulls":4},"CODIGO:"]
[{"$nulls":5},"PFP-2.1"]
["NOME DA CONSULTORA:"]
[]
["PROJETO:",null,"CONTRATANTE:",null,null,{"$f":"PFP!J5","v":"BASE:"}]
[{"$f":"PFP!A6","v":"ELABORAÇÃO DE ESTUDO DE VIABILIDADE TÉCNICA, ECONÔMICA E AMBIENTAL, ESTUDOS BÁSICOS, PROJETO BÁSICO E PROJETO EXECUTIVO PARA PARA CONSTRUÇÃO DA INFRAESTRUTURA RODOVIÁRIA DA ESTRADA PARQUE LINHA DO EQUADOR, NO ESTADO DO AMAPÁ"},null,"CODEVASF (SEDE)",null,null,"SINAPI/AP"]
["Cod","DESCRIÇÃO",null,null,"%","R$"]
["A","ENCARGOS SOCIAIS BÁSICOS",null,null,{"$f":"ROUND(SUM(E9:E17),4)","v":0.36799999999999999},{"$f":"ROUND(E8*SUMIF(PFP!$B$8:$B$19,\"MO1\",PFP!$J$8:$J$19),2)","v":0}]
["A1","INSS",null,null,0.2,{"$f":"ROUND(E9*SUMIF(PFP!$B$8:$B$19,\"MO1\",PFP!$J$8:$J$19),2)","v":0}]
["A2","SESI",null,null,1.4999999999999999E-2,{"$f":"ROUND(E10*SUMIF(PFP!$B$8:$B$19,\"MO1\",PFP!$J$8:$J$19),2)","v":0}]
["A3","SENAI",null,null,0.01,{"$f":"ROUND(E11*SUMIF(PFP!$B$8:$B$19,\"MO1\",PFP!$J$8:$J$19),2)","v":0}]
["A4","INCRA",null,null,2E-3,{"$f":"ROUND(E12*SUMIF(PFP!$B$8:$B$19,\"MO1\",PFP!$J$8:$J$19),2)","v":0}]
["A5","SEBRAE",null,null,6.0000000000000001E-3,{"$f":"ROUND(E13*SUMIF(PFP!$B$8:$B$19,\"MO1\",PFP!$J$8:$J$19),2)","v":0}]
["A6","Salário Educação",null,null,2.5000000000000001E-2,{"$f":"ROUND(E14*SUMIF(PFP!$B$8:$B$19,\"MO1\",PFP!$J$8:$J$19),2)","v":0}]
["A7","Seguro Contra Acidentes de Trabalho",null,null,0.03,{"$f":"ROUND(E15*SUMIF(PFP!$B$8:$B$19,\"MO1\",PFP!$J$8:$J$19),2)","v":0}]
["A8","FGTS",null,null,0.08,{"$f":"ROUND(E16*SUMIF(PFP!$B$8:$B$19,\"MO1\",PFP!$J$8:$J$19),2)","v":0}]
["A9","Seconci",null,null,0,{"$f":"ROUND(E17*SUMIF(PFP!$B$8:$B$19,\"MO1\",PFP!$J$8:$J$19),2)","v":0}]
["B"," ENCARGOS SOCIAIS QUE RECEBEM INCIDÊNCIA DE \"A\"",null,null,{"$f":"ROUND(SUM(E19:E25),4)","v":0.2},{"$f":"ROUND(E18*SUMIF(PFP!$B$8:$B$19,\"MO1\",PFP!$J$8:$J$19),2)","v":0}]
["B3","Auxílio Enfermidade",null,null,6.4000000000000003E-3,{"$f":"ROUND(E19*SUMIF(PFP!$B$8:$B$19,\"MO1\",PFP!$J$8:$J$19),2)","v":0}]
["B4","13º Salário",null,null,8.3299999999999999E-2,{"$f":"ROUND(E20*SUMIF(PFP!$B$8:$B$19,\"MO1\",PFP!$J$8:$J$19),2)","v":0}]
["B5","Licença Paternidade",null,null,4.0000000000000002E-4,{"$f":"ROUND(E21*SUMIF(PFP!$B$8:$B$19,\"MO1\",PFP!$J$8:$J$19),2)","v":0}]
["B6","Faltas Justificadas",null,null,5.5999999999999999E-3,{"$f":"ROUND(E22*SUMIF(PFP!$B$8:$B$19,\"MO1\",PFP!$J$8:$J$19),2)","v":0}]
["B8","Auxílio Acidente de Trabalho",null,null,8.0000000000000004E-4,{"$f":"ROUND(E23*SUMIF(PFP!$B$8:$B$19,\"MO1\",PFP!$J$8:$J$19),2)","v":0}]
["B9","Férias Gozadas",null,null,0.1032,{"$f":"ROUND(E24*SUMIF(PFP!$B$8:$B$19,\"MO1\",PFP!$J$8:$J$19),2)","v":0}]
["B10","Salário Maternidade",null,null,2.9999999999999997E-4,{"$f":"ROUND(E25*SUMIF(PFP!$B$8:$B$19,\"MO1\",PFP!$J$8:$J$19),2)","v":0}]
["C"," ENCARGOS SOCIAIS QUE NÃO RECEBEM INCIDÊNCIA DE \"A\"",null,null,{"$f":"ROUND(SUM(E27:E31),4)","v":5.4100000000000002E-2},{"$f":"ROUND(E26*SUMIF(PFP!$B$8:$B$19,\"MO1\",PFP!$J$8:$J$19),2)","v":0}]
["C1","Aviso Prévio Indenizado",null,null,3.0200000000000001E-2,{"$f":"ROUND(E27*SUMIF(PFP!$B$8:$B$19,\"MO1\",PFP!$J$8:$J$19),2)","v":0}]
["C2","Aviso Prévio Trabalhado",null,null,6.9999999999999999E-4,{"$f":"ROUND(E28*SUMIF(PFP!$B$8:$B$19,\"MO1\",PFP!$J$8:$J$19),2)","v":0}]
["C3","Férias Indenizadas",null,null,6.4999999999999997E-3,{"$f":"ROUND(E29*SUMIF(PFP!$B$8:$B$19,\"MO1\",PFP!$J$8:$J$19),2)","v":0}]
["C4","Depósito Rescisão Sem Justa Causa",null,null,1.4200000000000001E-2,{"$f":"ROUND(E30*SUMIF(PFP!$B$8:$B$19,\"MO1\",PFP!$J$8:$J$19),2)","v":0}]
["C5","Indenização Adicional",null,null,2.5000000000000001E-3,{"$f":"ROUND(E31*SUMIF(PFP!$B$8:$B$19,\"MO1\",PFP!$J$8:$J$19),2)","v":0}]
["D"," REINCIDÊNCIAS",null,null,{"$f":"ROUND(SUM(E33:E34),4)","v":7.6300000000000007E-2},{"$f":"ROUND(E32*SUMIF(PFP!$B$8:$B$19,\"MO1\",PFP!$J$8:$J$19),2)","v":0}]
["D1","Reincidência de \"A\" sobre \"B\"",null,null,7.3599999999999999E-2,{"$f":"ROUND(E33*SUMIF(PFP!$B$8:$B$19,\"MO1\",PFP!$J$8:$J$19),2)","v":0}]
["D2","Reincidência de \"A\" sobre Aviso Prévio Trabalhado e reincidência do FGTS sobre Aviso Prévio Indenizado",null,null,2.7000000000000001E-3,{"$f":"ROUND(E34*SUMIF(PFP!$B$8:$B$19,\"MO1\",PFP!$J$8:$J$19),2)","v":0}]
["K1a","ENCARGOS SOCIAIS",null,null,{"$f":"ROUND(E8+E18+E26+E32,4)","v":0.69840000000000002},{"$f":"ROUND(E35*SUMIF(PFP!$B$8:$B$19,\"MO1\",PFP!$J$8:$J$19),2)","v":0}]
["Ka","TAXA DE RESSARCIMENTO DE DESPESAS E ENCARGOS SOBRE MO1",null,null,{"$f":"ROUND((1+E35+PFP3_FatorKd!E13)*(1+PFP3_FatorKd!E12)*(1+PFP3_FatorKd!E8),4)","v":2.1295999999999999}]
["OBSERVAÇÃO: CELETISTAS E EQUIVALENTES"]
["1 - DISCRIMINAR OS ENCARGOS SOCIAIS COM SEUS RESPECTIVOS PERCENTUAS TOTALIZANDO OS MESMOS. "]
["2 - APLICAR O  % TOTAL P/ CALCULAR OS E. SOCIAIS INCIDENTES NA MÃO-DE-OBRA CELETISTAS"]
["Ka - Taxa de Ressarcimento de Despesas e Encargos sobre a Mão de Obra CELETISTA (incide apenas no Insumo Codigo MO1)"]
["Ka = (1 + K1 + K2) x (1 + K3) x (1 + K4)"]

{"sheet":"PFP2.2_FatorKb","index":4,"n_rows":40,"n_cols":6,"rows_kept":40,"cut":false,"hidden":false,"merged":[[27,1,27,3],[28,1,28,3],[29,1,29,3],[22,1,22,3],[23,1,23,3],[24,1,24,3],[25,1,25,3],[26,1,26,3],[6,1,6,3],[12,1,12,3],[13,1,13,3],[39,0,39,5],[36,0,36,5],[37,0,37,5],[38,0,38,5],[31,1,31,3],[32,1,32,3],[33,1,33,3],[34,1,34,3],[18,1,18,3],[30,1,30,3],[19,1,19,3],[20,1,20,3],[21,1,21,3],[0,0,1,4],[2,0,2,5],[3,0,3,5],[4,2,4,4],[5,0,5,1],[5,2,5,4],[7,1,7,3],[16,1,16,3],[17,1,17,3],[8,1,8,3],[9,1,9,3],[10,1,10,3],[14,1,14,3],[15,1,15,3],[11,1,11,3]]}
["DETALHAMENTO DOS ENCARGOS SOCIAIS: Kb",{"$nulls":4},"CODIGO:"]
[{"$nulls":5},"PFP-2.2"]
["NOME DA CONSULTORA:"]
[]
["PROJETO:",null,"CONTRATANTE:",null,null,{"$f":"'PFP2.1_FatorKa'!F5","v":"BASE:"}]
[{"$f":"PFP!A6","v":"ELABORAÇÃO DE ESTUDO DE VIABILIDADE TÉCNICA, ECONÔMICA E AMBIENTAL, ESTUDOS BÁSICOS, PROJETO BÁSICO E PROJETO EXECUTIVO PARA PARA CONSTRUÇÃO DA INFRAESTRUTURA RODOVIÁRIA DA ESTRADA PARQUE LINHA DO EQUADOR, NO ESTADO DO AMAPÁ"},null,"CODEVASF (SEDE)",null,null,{"$f":"'PFP2.1_FatorKa'!F6","v":"SINAPI/AP"}]
["Cod","DESCRIÇÃO",null,null,"%","R$"]
["A","ENCARGOS SOCIAIS BÁSICOS",null,null,{"$f":"ROUND(SUM(E9:E16),4)","v":0.2},{"$f":"ROUND(E8*SUMIF(PFP!$B$8:$B$19,\"MO2\",PFP!$J$8:$J$19),2)","v":0}]
["A1","INSS",null,null,0.2,{"$f":"ROUND(E9*SUMIF(PFP!$B$8:$B$19,\"MO2\",PFP!$J$8:$J$19),2)","v":0}]
["A2","SESI",null,null,0,{"$f":"ROUND(E10*SUMIF(PFP!$B$8:$B$19,\"MO2\",PFP!$J$8:$J$19),2)","v":0}]
["A3","SENAI",null,null,0,{"$f":"ROUND(E11*SUMIF(PFP!$B$8:$B$19,\"MO2\",PFP!$J$8:$J$19),2)","v":0}]
["A4","INCRA",null,null,0,{"$f":"ROUND(E12*SUMIF(PFP!$B$8:$B$19,\"MO2\",PFP!$J$8:$J$19),2)","v":0}]
["A5","SEBRAE",null,null,0,{"$f":"ROUND(E13*SUMIF(PFP!$B$8:$B$19,\"MO2\",PFP!$J$8:$J$19),2)","v":0}]
["A6","Salário Educação",null,null,0,{"$f":"ROUND(E14*SUMIF(PFP!$B$8:$B$19,\"MO2\",PFP!$J$8:$J$19),2)","v":0}]
["A7","Seguro Contra Acidentes de Trabalho",null,null,0,{"$f":"ROUND(E15*SUMIF(PFP!$B$8:$B$19,\"MO2\",PFP!$J$8:$J$19),2)","v":0}]
["A8","FGTS",null,null,0,{"$f":"ROUND(E16*SUMIF(PFP!$B$8:$B$19,\"MO2\",PFP!$J$8:$J$19),2)","v":0}]
["B"," ENCARGOS SOCIAIS QUE RECEBEM INCIDÊNCIA DE \"A\"",null,null,{"$f":"ROUND(SUM(E18:E24),4)","v":0},{"$f":"ROUND(E17*SUMIF(PFP!$B$8:$B$19,\"MO2\",PFP!$J$8:$J$19),2)","v":0}]
["B3","Auxílio Enfermidade",null,null,0,{"$f":"ROUND(E18*SUMIF(PFP!$B$8:$B$19,\"MO2\",PFP!$J$8:$J$19),2)","v":0}]
["B4","13º Salário",null,null,0,{"$f":"ROUND(E19*SUMIF(PFP!$B$8:$B$19,\"MO2\",PFP!$J$8:$J$19),2)","v":0}]
["B5","Licença Paternidade",null,null,0,{"$f":"ROUND(E20*SUMIF(PFP!$B$8:$B$19,\"MO2\",PFP!$J$8:$J$19),2)","v":0}]
["B6","Faltas Justificadas",null,null,0,{"$f":"ROUND(E21*SUMIF(PFP!$B$8:$B$19,\"MO2\",PFP!$J$8:$J$19),2)","v":0}]
["B8","Auxílio Acidente de Trabalho",null,null,0,{"$f":"ROUND(E22*SUMIF(PFP!$B$8:$B$19,\"MO2\",PFP!$J$8:$J$19),2)","v":0}]
["B9","Férias Gozadas",null,null,0,{"$f":"ROUND(E23*SUMIF(PFP!$B$8:$B$19,\"MO2\",PFP!$J$8:$J$19),2)","v":0}]
["B10","Salário Maternidade",null,null,0,{"$f":"ROUND(E24*SUMIF(PFP!$B$8:$B$19,\"MO2\",PFP!$J$8:$J$19),2)","v":0}]
["C"," ENCARGOS SOCIAIS QUE NÃO RECEBEM INCIDÊNCIA DE \"A\"",null,null,{"$f":"ROUND(SUM(E26:E30),4)","v":0},{"$f":"ROUND(E25*SUMIF(PFP!$B$8:$B$19,\"MO2\",PFP!$J$8:$J$19),2)","v":0}]
["C1","Aviso Prévio Indenizado",null,null,0,{"$f":"ROUND(E26*SUMIF(PFP!$B$8:$B$19,\"MO2\",PFP!$J$8:$J$19),2)","v":0}]
["C2","Aviso Prévio Trabalhado",null,null,0,{"$f":"ROUND(E27*SUMIF(PFP!$B$8:$B$19,\"MO2\",PFP!$J$8:$J$19),2)","v":0}]
["C3","Férias Indenizadas",null,null,0,{"$f":"ROUND(E28*SUMIF(PFP!$B$8:$B$19,\"MO2\",PFP!$J$8:$J$19),2)","v":0}]
["C4","Depósito Rescisão Sem Justa Causa",null,null,0,{"$f":"ROUND(E29*SUMIF(PFP!$B$8:$B$19,\"MO2\",PFP!$J$8:$J$19),2)","v":0}]
["C5","Indenização Adicional",null,null,0,{"$f":"ROUND(E30*SUMIF(PFP!$B$8:$B$19,\"MO2\",PFP!$J$8:$J$19),2)","v":0}]
["D"," REINCIDÊNCIAS",null,null,{"$f":"ROUND(SUM(E32:E33),4)","v":0},{"$f":"ROUND(E31*SUMIF(PFP!$B$8:$B$19,\"MO2\",PFP!$J$8:$J$19),2)","v":0}]
["D1","Reincidência de \"A\" sobre \"B\"",null,null,{"$f":"ROUND(E8*E17,4)","v":0},{"$f":"ROUND(E32*SUMIF(PFP!$B$8:$B$19,\"MO2\",PFP!$J$8:$J$19),2)","v":0}]
["D2","Reincidência de \"A\" sobre Aviso Prévio Trabalhado e reincidência do FGTS sobre Aviso Prévio Indenizado",null,null,{"$f":"ROUND((E27*E8)+(E26*E16),4)","v":0},{"$f":"ROUND(E33*SUMIF(PFP!$B$8:$B$19,\"MO2\",PFP!$J$8:$J$19),2)","v":0}]
["K1b","ENCARGOS SOCIAIS",null,null,{"$f":"ROUND(E8+E17+E25+E31,4)","v":0.2},{"$f":"ROUND(E34*SUMIF(PFP!$B$8:$B$19,\"MO2\",PFP!$J$8:$J$19),2)","v":0}]
["Kb","TAXA DE RESSARCIMENTO DE DESPESAS E ENCARGOS SOBRE MO2",null,null,{"$f":"ROUND((1+E34+PFP3_FatorKd!E13)*(1+PFP3_FatorKd!E12)*(1+PFP3_FatorKd!E8),4)","v":1.5302}]
["OBSERVAÇÃO: AUTÔNOMOS E EQUIVALENTES"]
["1 - DISCRIMINAR OS ENCARGOS SOCIAIS COM SEUS RESPECTIVOS PERCENTUAS TOTALIZANDO OS MESMOS. "]
["2 - APLICAR O % TOTAL P/ CALCULAR OS E. SOCIAIS INCIDENTES NA MÃO-DE-OBRA AUTONÔMOS"]
["Kb - Taxa de Ressarcimento de Despesas e Encargos sobre a Mão de Obra AUTONÔMA (incide apenas no Insumo Codigo MO2)"]
["Kb = (1 + K1 + K2) x (1 + K3) x (1 + K4)"]

{"sheet":"PFP2.3_FatorKc","index":5,"n_rows":40,"n_cols":6,"rows_kept":40,"cut":false,"hidden":false,"merged":[[0,0,1,4],[2,0,2,5],[3,0,3,5],[4,2,4,4],[5,0,5,1],[5,2,5,4],[16,1,16,3],[6,1,6,3],[7,1,7,3],[8,1,8,3],[9,1,9,3],[10,1,10,3],[11,1,11,3],[12,1,12,3],[13,1,13,3],[14,1,14,3],[15,1,15,3],[28,1,28,3],[17,1,17,3],[18,1,18,3],[19,1,19,3],[20,1,20,3],[21,1,21,3],[22,1,22,3],[23,1,23,3],[24,1,24,3],[25,1,25,3],[26,1,26,3],[27,1,27,3],[36,0,36,5],[37,0,37,5],[38,0,38,5],[39,0,39,5],[29,1,29,3],[30,1,30,3],[31,1,31,3],[32,1,32,3],[33,1,33,3],[34,1,34,3]]}
["DETALHAMENTO DOS ENCARGOS SOCIAIS: Kc",{"$nulls":4},"CODIGO:"]
[{"$nulls":5},"PFP-2.3"]
["NOME DA CONSULTORA:"]
[]
["PROJETO:",null,"CONTRATANTE:",null,null,{"$f":"'PFP2.2_FatorKb'!F5","v":"BASE:"}]
[{"$f":"PFP!A6","v":"ELABORAÇÃO DE ESTUDO DE VIABILIDADE TÉCNICA, ECONÔMICA E AMBIENTAL, ESTUDOS BÁSICOS, PROJETO BÁSICO E PROJETO EXECUTIVO PARA PARA CONSTRUÇÃO DA INFRAESTRUTURA RODOVIÁRIA DA ESTRADA PARQUE LINHA DO EQUADOR, NO ESTADO DO AMAPÁ"},null,"CODEVASF (SEDE)",null,null,{"$f":"'PFP2.2_FatorKb'!F6","v":"SINAPI/AP"}]
["Cod","DESCRIÇÃO",null,null,"%","R$"]
["A","ENCARGOS SOCIAIS BÁSICOS",null,null,{"$f":"SUM(E9:E16)","v":0},{"$f":"ROUND(E8*SUMIF(PFP!$B$8:$B$19,\"MO3\",PFP!$J$8:$J$19),2)","v":0}]
["A1","INSS",null,null,0,{"$f":"ROUND(E9*SUMIF(PFP!$B$8:$B$19,\"MO3\",PFP!$J$8:$J$19),2)","v":0}]
["A2","SESI",null,null,0,{"$f":"ROUND(E10*SUMIF(PFP!$B$8:$B$19,\"MO3\",PFP!$J$8:$J$19),2)","v":0}]
["A3","SENAI",null,null,0,{"$f":"ROUND(E11*SUMIF(PFP!$B$8:$B$19,\"MO3\",PFP!$J$8:$J$19),2)","v":0}]
["A4","INCRA",null,null,0,{"$f":"ROUND(E12*SUMIF(PFP!$B$8:$B$19,\"MO3\",PFP!$J$8:$J$19),2)","v":0}]
["A5","SEBRAE",null,null,0,{"$f":"ROUND(E13*SUMIF(PFP!$B$8:$B$19,\"MO3\",PFP!$J$8:$J$19),2)","v":0}]
["A6","Salário Educação",null,null,0,{"$f":"ROUND(E14*SUMIF(PFP!$B$8:$B$19,\"MO3\",PFP!$J$8:$J$19),2)","v":0}]
["A7","Seguro Contra Acidentes de Trabalho",null,null,0,{"$f":"ROUND(E15*SUMIF(PFP!$B$8:$B$19,\"MO3\",PFP!$J$8:$J$19),2)","v":0}]
["A8","FGTS",null,null,0,{"$f":"ROUND(E16*SUMIF(PFP!$B$8:$B$19,\"MO3\",PFP!$J$8:$J$19),2)","v":0}]
["B"," ENCARGOS SOCIAIS QUE RECEBEM INCIDÊNCIA DE \"A\"",null,null,{"$f":"ROUND(SUM(E18:E24),4)","v":0},{"$f":"ROUND(E17*SUMIF(PFP!$B$8:$B$19,\"MO3\",PFP!$J$8:$J$19),2)","v":0}]
["B3","Auxílio Enfermidade",null,null,0,{"$f":"ROUND(E18*SUMIF(PFP!$B$8:$B$19,\"MO3\",PFP!$J$8:$J$19),2)","v":0}]
["B4","13º Salário",null,null,0,{"$f":"ROUND(E19*SUMIF(PFP!$B$8:$B$19,\"MO3\",PFP!$J$8:$J$19),2)","v":0}]
["B5","Licença Paternidade",null,null,0,{"$f":"ROUND(E20*SUMIF(PFP!$B$8:$B$19,\"MO3\",PFP!$J$8:$J$19),2)","v":0}]
["B6","Faltas Justificadas",null,null,0,{"$f":"ROUND(E21*SUMIF(PFP!$B$8:$B$19,\"MO3\",PFP!$J$8:$J$19),2)","v":0}]
["B8","Auxílio Acidente de Trabalho",null,null,0,{"$f":"ROUND(E22*SUMIF(PFP!$B$8:$B$19,\"MO3\",PFP!$J$8:$J$19),2)","v":0}]
["B9","Férias Gozadas",null,null,0,{"$f":"ROUND(E23*SUMIF(PFP!$B$8:$B$19,\"MO3\",PFP!$J$8:$J$19),2)","v":0}]
["B10","Salário Maternidade",null,null,0,{"$f":"ROUND(E24*SUMIF(PFP!$B$8:$B$19,\"MO3\",PFP!$J$8:$J$19),2)","v":0}]
["C"," ENCARGOS SOCIAIS QUE NÃO RECEBEM INCIDÊNCIA DE \"A\"",null,null,{"$f":"ROUND(SUM(E26:E30),4)","v":0},{"$f":"ROUND(E25*SUMIF(PFP!$B$8:$B$19,\"MO3\",PFP!$J$8:$J$19),2)","v":0}]
["C1","Aviso Prévio Indenizado",null,null,0,{"$f":"ROUND(E26*SUMIF(PFP!$B$8:$B$19,\"MO3\",PFP!$J$8:$J$19),2)","v":0}]
["C2","Aviso Prévio Trabalhado",null,null,0,{"$f":"ROUND(E27*SUMIF(PFP!$B$8:$B$19,\"MO3\",PFP!$J$8:$J$19),2)","v":0}]
["C3","Férias Indenizadas",null,null,0,{"$f":"ROUND(E28*SUMIF(PFP!$B$8:$B$19,\"MO3\",PFP!$J$8:$J$19),2)","v":0}]
["C4","Depósito Rescisão Sem Justa Causa",null,null,0,{"$f":"ROUND(E29*SUMIF(PFP!$B$8:$B$19,\"MO3\",PFP!$J$8:$J$19),2)","v":0}]
["C5","Indenização Adicional",null,null,0,{"$f":"ROUND(E30*SUMIF(PFP!$B$8:$B$19,\"MO3\",PFP!$J$8:$J$19),2)","v":0}]
["D"," REINCIDÊNCIAS",null,null,{"$f":"ROUND(SUM(E32:E33),4)","v":0},{"$f":"ROUND(E31*SUMIF(PFP!$B$8:$B$19,\"MO3\",PFP!$J$8:$J$19),2)","v":0}]
["D1","Reincidência de \"A\" sobre \"B\"",null,null,{"$f":"ROUND(E8*E17,4)","v":0},{"$f":"ROUND(E32*SUMIF(PFP!$B$8:$B$19,\"MO3\",PFP!$J$8:$J$19),2)","v":0}]
["D2","Reincidência de \"A\" sobre Aviso Prévio Trabalhado e reincidência do FGTS sobre Aviso Prévio Indenizado",null,null,{"$f":"ROUND(E8*E27,4)+ROUND(E26*E11,4)","v":0},{"$f":"ROUND(E33*SUMIF(PFP!$B$8:$B$19,\"MO3\",PFP!$J$8:$J$19),2)","v":0}]
["K1c","ENCARGOS SOCIAIS",null,null,{"$f":"ROUND(E8+E17+E25+E31,4)","v":0},{"$f":"ROUND(E34*SUMIF(PFP!$B$8:$B$19,\"MO3\",PFP!$J$8:$J$19),2)","v":0}]
["Kc","TAXA DE RESSARCIMENTO DE DESPESAS E ENCARGOS SOBRE MO3",null,null,{"$f":"ROUND((1+E34+PFP3_FatorKd!E13)*(1+PFP3_FatorKd!E12)*(1+PFP3_FatorKd!E8),4)","v":1.2897000000000001}]
["OBSERVAÇÃO: SOCIETÁRIOS E EQUIVALENTES"]
["1 - DISCRIMINAR OS ENCARGOS SOCIAIS COM SEUS RESPECTIVOS PERCENTUAS TOTALIZANDO OS MESMOS. "]
["2 - APLICAR O % TOTAL P/ CALCULAR OS E. SOCIAIS INCIDENTES NA MÃO-DE-OBRA DE SOCIETÁRIOS"]
["Kc - Taxa de Ressarcimento de Despesas e Encargos sobre a Mão de Obra SOCIETÁRIA (incide apenas no Insumo Codigo MO3)"]
["Kc = (1 + K1 + K2) x (1 + K3) x (1 + K4)"]

{"sheet":"PFP3_FatorKd","index":6,"n_rows":35,"n_cols":6,"rows_kept":35,"cut":false,"hidden":false,"merged":[[32,0,32,5],[12,1,12,3],[11,1,11,3],[8,1,8,2],[9,1,9,2],[10,1,10,2],[7,1,7,2],[25,0,25,5],[6,1,6,2],[0,0,1,4],[2,0,2,5],[5,0,5,1],[5,2,5,4],[4,2,4,4],[3,0,3,5],[33,0,33,5],[34,0,34,5],[16,1,16,3],[13,1,13,3],[14,1,14,3],[15,1,15,3],[21,0,21,5],[26,0,26,5],[27,0,27,5],[22,0,22,5],[23,0,23,5],[24,0,24,5],[28,0,28,5],[29,0,29,5],[30,0,30,5],[31,0,31,5]]}
["DESPESAS FISCAIS E CUSTOS DIVERSOS: Kc",{"$nulls":4},"CODIGO:"]
[{"$nulls":5},"PFP-3"]
["NOME DA CONSULTORA:"]
[]
["PROJETO:",null,"CONTRATANTE:",null,null,{"$f":"'PFP2.3_FatorKc'!F5","v":"BASE:"}]
[{"$f":"PFP!A6","v":"ELABORAÇÃO DE ESTUDO DE VIABILIDADE TÉCNICA, ECONÔMICA E AMBIENTAL, ESTUDOS BÁSICOS, PROJETO BÁSICO E PROJETO EXECUTIVO PARA PARA CONSTRUÇÃO DA INFRAESTRUTURA RODOVIÁRIA DA ESTRADA PARQUE LINHA DO EQUADOR, NO ESTADO DO AMAPÁ"},null,"CODEVASF (SEDE)",null,null,{"$f":"'PFP2.3_FatorKc'!F6","v":"SINAPI/AP"}]
["Cod","DESCRIÇÃO1",null,"% preço2","% custo4","R$"]
["K4","TRIBUTOS",null,0.104,{"$f":"ROUND(E9+E10+E11,4)","v":0.11609999999999999}]
["K4.1","ISS",null,0.03,3.3500000000000002E-2]
["K4.2","PIS3 - aliquota efetiva aplicavel percentual-desconto",null,1.32E-2,1.47E-2]
["K4.3","COFINS3 - aliquota efetiva aplicavel percentual-desconto",null,6.08E-2,6.7900000000000002E-2]
["K3","REMUNERAÇÃO DA EMPRESA (LUCRO)",null,null,7.7499999999999999E-2]
["K2","CUSTOS DA ADMINISTRAÇÃO CENTRAL",null,null,7.2400000000000006E-2,{"$f":"ROUND(E13*SUMIF(PFP!$B$8:$B$19,\"MO*\",PFP!$J$8:$J$19),2)","v":0}]
["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,{"$f":"ROUND(E14*SUMIF(PFP!$B$8:$B$19,\"MO*\",PFP!$J$8:$J$19),2)","v":0}]
["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,{"$f":"ROUND(E15*SUMIF(PFP!$B$8:$B$19,\"MO*\",PFP!$J$8:$J$19),2)","v":0}]
["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,1.24E-2,{"$f":"ROUND(E16*SUMIF(PFP!$B$8:$B$19,\"MO*\",PFP!$J$8:$J$19),2)","v":0}]
["Kd","TAXA RESSARCIMENTO DE DESPESAS SOBRE CUSTOS DIVERSOS",null,null,{"$f":"ROUND((1+E12)*(1+E8),4)","v":1.2025999999999999}]
["NOME DO INFORMANTE:",null,null,null,"QUALIFICAÇÃO:"]
[]
["ASSINATURA:",null,null,null,"DATA:"]
[]
["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 (ex: ISS 5% + PIS 1,65% + COFINS 7,60% = 14,25%)"]
["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' APLICANDO-SE A SEGUINTE FÓRMULA:"]
["     K4' = { [ 1 / ( 1 - K4) ] - 1 } x 100"]
[{"$f":"CONCATENATE(\"     K4' = { [ 1 / ( 1 - \",D8,\" ) ] - 1 } x 100\")","v":"     K4' = { [ 1 / ( 1 - 0,104 ) ] - 1 } x 100"}]
["Kc - Taxa de Ressarcimento de Despesas sobre Custos Diversos (incide sobre os Insumos Codigo DP e EM)"]
["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 (DP e EM), 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 (DP e EM), e Custos da Administração Central (K2) e Lucro (K3)"]

{"sheet":"CRO1_Ins-Pro","index":7,"n_rows":85,"n_cols":11,"rows_kept":85,"cut":false,"hidden":false,"merged":[[83,0,83,7],[82,0,82,10],[0,0,1,7],[34,7,34,10],[16,0,18,0],[2,0,3,0],[2,1,3,1],[2,2,3,2],[2,3,3,3],[2,4,3,4],[2,5,3,5],[16,1,17,1]]}
["INSUMOS POR ETAPA/PRODUTO",{"$nulls":9},"CÓDIGO:"]
[{"$nulls":10},"CRO-1"]
["Cod.","Categoria / Insumo","Uni","Qde","CUD","PU","FatorK","E1. EB","E2. EVTEA ","E3. PB","E4. PE"]
[{"$nulls":6},"Meses"]
[{"$f":"PFP!B8","v":"P8061"},{"$f":"PFP!D8","v":"Engenheiro coordenador (P8061)"},"mês",{"$f":"SUM(H5:K5)","v":1.05},{"$f":"PFP!G8","v":17866.689999999999},{"$f":"PFP!H8","v":23042.67},{"$f":"PFP!I8","v":1.2897000000000001},{"$f":"'CRO2_Ins-Mes'!E5","v":0.15000000000000002},{"$f":"'CRO2_Ins-Mes'!E13","v":0.15000000000000002},{"$f":"'CRO2_Ins-Mes'!E21","v":0.25},{"$f":"'CRO2_Ins-Mes'!E29","v":0.5}]
[{"$f":"PFP!B9","v":"P8066"},{"$f":"PFP!D9","v":"Engenheiro pleno (P8066)"},"mês",4.5,{"$f":"PFP!G9","v":12379.96},{"$f":"PFP!H9","v":26364.36},{"$f":"PFP!I9","v":2.1295999999999999},{"$f":"'CRO2_Ins-Mes'!E6","v":0},{"$f":"'CRO2_Ins-Mes'!E14","v":1},{"$f":"'CRO2_Ins-Mes'!E22","v":2.5},{"$f":"'CRO2_Ins-Mes'!E30","v":1}]
[{"$f":"PFP!B10","v":"P8065"},{"$f":"PFP!D10","v":"Engenheiro júnior (P8065)"},"mês",6,{"$f":"PFP!G10","v":12002},{"$f":"PFP!H10","v":25559.46},{"$f":"PFP!I10","v":2.1295999999999999},{"$f":"'CRO2_Ins-Mes'!E7","v":0},{"$f":"'CRO2_Ins-Mes'!E15","v":2.5},{"$f":"'CRO2_Ins-Mes'!E23","v":2.5},{"$f":"'CRO2_Ins-Mes'!E31","v":1}]
[{"$f":"PFP!B11","v":40807},{"$f":"PFP!D11","v":"Desenhista (40807)"},"mês",10,{"$f":"PFP!G11","v":2799.33},{"$f":"PFP!H11","v":5961.45},{"$f":"PFP!I11","v":2.1295999999999999},{"$f":"'CRO2_Ins-Mes'!E8","v":1.5},{"$f":"'CRO2_Ins-Mes'!E16","v":1.5},{"$f":"'CRO2_Ins-Mes'!E24","v":5},{"$f":"'CRO2_Ins-Mes'!E32","v":2}]
[{"$f":"PFP!B12","v":"P8147"},"Técnico de projetos/obra (P8147)","mês",5.5,{"$f":"PFP!G12","v":3167.62},{"$f":"PFP!H12","v":6745.76},{"$f":"PFP!I12","v":2.1295999999999999},{"$f":"'CRO2_Ins-Mes'!E9","v":1.5},{"$f":"'CRO2_Ins-Mes'!E17","v":1.5},{"$f":"'CRO2_Ins-Mes'!E25","v":2.5},{"$f":"'CRO2_Ins-Mes'!E33","v":0}]
["-",{"$f":"PFP!D13","v":"Encargos Comp. e Adicionais"},"mês",{"$f":"SUM(D5:D9)","v":27.05},{"$f":"PFP!G13","v":1053.5652125693157},{"$f":"PFP!H13","v":1267.02},{"$f":"PFP!I13","v":1.2025999999999999},{"$f":"SUM(H5:H9)","v":3.15},{"$f":"SUM(I5:I9)","v":6.65},{"$f":"SUM(J5:J9)","v":12.75},{"$f":"SUM(K5:K9)","v":4.5}]
["-",{"$f":"PFP!D14","v":"Auxilio Transporte Técnicos"},"mês",{"$f":"SUM(H11:K11)","v":0},{"$f":"PFP!G14","v":"Já incluso*"},{"$f":"PFP!H14","v":0},{"$f":"PFP!I14","v":0},0,0,0,0]
["-",{"$f":"PFP!D15","v":"Auxilio Transporte Secretária"},"mês",0,{"$f":"PFP!G15","v":"Já Incluso*"},{"$f":"PFP!H15","v":0},{"$f":"PFP!I15","v":0},0,0,0,0]
["-",{"$f":"PFP!D16","v":"Relatório Parcial"},"un",0,{"$f":"PFP!G16","v":33.35},{"$f":"PFP!H16","v":40.11},{"$f":"PFP!I16","v":1.2025999999999999},{"$f":"'CRO2_Ins-Mes'!E10","v":0},{"$f":"'CRO2_Ins-Mes'!E18","v":0},{"$f":"'CRO2_Ins-Mes'!E26","v":0},{"$f":"'CRO2_Ins-Mes'!E34","v":0}]
["-",{"$f":"PFP!D17","v":"Relatório Final"},"un",4,{"$f":"PFP!G17","v":1478.8},{"$f":"PFP!H17","v":1778.4},{"$f":"PFP!I17","v":1.2025999999999999},{"$f":"'CRO2_Ins-Mes'!E11","v":1},{"$f":"'CRO2_Ins-Mes'!E19","v":1},{"$f":"'CRO2_Ins-Mes'!E27","v":1},{"$f":"'CRO2_Ins-Mes'!E35","v":1}]
["-",{"$f":"PFP!D18","v":"Total Serviços Cartográficos"},"un",1,{"$f":"PFP!G18","v":"-"},{"$f":"PFP!H18","v":45421.48},{"$f":"PFP!I18","v":"-"},1]
["-",{"$f":"PFP!D19","v":"Total Serviços Geotécnicos"},"un",1,{"$f":"PFP!G19","v":"-"},{"$f":"PFP!H19","v":119321.39},{"$f":"PFP!I19","v":"-"},1]
["TOTAL","VALOR TOTAL POR PRODUTO","R$",{"$f":"SUM(H17:K17)","v":599036.7300000001},null,null,null,{"$f":"ROUND(H5*$F$5+H6*$F$6+H7*$F$7+H8*$F$8+H9*$F$9+H10*$F$10+H11*$F$11+H12*$F$12+H13*$F$13+H14*$F$14+H15*$F$15+H16*$F$16,2)","v":193029.6},{"$f":"ROUND(I5*$F$5+I6*$F$6+I7*$F$7+I8*$F$8+I9*$F$9+I10*$F$10+I11*$F$11+I12*$F$12+I13*$F$13+I14*$F$14+I15*$F$15+I16*$F$16,2)","v":122984.31},{"$f":"ROUND(J5*$F$5+J6*$F$6+J7*$F$7+J8*$F$8+J9*$F$9+J10*$F$10+J11*$F$11+J12*$F$12+J13*$F$13+J14*$F$14+J15*$F$15+J16*$F$16,2)","v":200174.77},{"$f":"ROUND(K5*$F$5+K6*$F$6+K7*$F$7+K8*$F$8+K9*$F$9+K10*$F$10+K11*$F$11+K12*$F$12+K13*$F$13+K14*$F$14+K15*$F$15+K16*$F$16,2)","v":82848.05}]
[null,null,"%",{"$f":"SUM(H18:K18)","v":0.99999000000000005},null,null,null,{"$f":"ROUND(H17/$D$17,5)","v":0.32223000000000002},{"$f":"ROUND(I17/$D$17,5)","v":0.20530000000000001},0.33416000000000001,0.13830000000000001]
[null,"VALOR PARCIAL POR PRODUTO","%",0.8,null,null,null,{"$f":"H17*$D$19","v":154423.68000000002},{"$f":"I17*$D$19","v":98387.448000000004},160139.81599999999,66278.44]
{"$rows_empty":62}
["OBSERVAÇÃO:"]
[]
["T - Profissionais de nível médio técnico nas diversas áreas de atuação"]
["A - Profissionais de nível médio de apoio técnico-administrativo"]

{"sheet":"CRO2_Ins-Mes","index":8,"n_rows":37,"n_cols":15,"rows_kept":37,"cut":false,"hidden":false,"merged":[[60,5,60,14],[0,0,1,14]]}
["CRONOGRAMA SIMPLIFICADO"]
[]
["Cod1","Cod2","Produtos","Uni","Qde",1,2,3,4,5,6,7,8,9,10]
["Cod1","Cod2","Insumos","Uni","Qde",1,2,3,4,5,6,7,8,9,10]
[1,"1.1",{"$f":"PFP!D8","v":"Engenheiro coordenador (P8061)"},{"$f":"PFP!E8","v":"mês"},{"$f":"SUM(F5:O5)","v":0.15000000000000002},0.05,0.05,0.05]
[1,"1.2",{"$f":"PFP!D9","v":"Engenheiro pleno (P8066)"},{"$f":"PFP!E9","v":"mês"},{"$f":"SUM(F6:O6)","v":0}]
[1,"1.3",{"$f":"PFP!D10","v":"Engenheiro júnior (P8065)"},{"$f":"PFP!E10","v":"mês"},0]
[1,"1.4",{"$f":"PFP!D11","v":"Desenhista (40807)"},{"$f":"PFP!E11","v":"mês"},1.5,0.5,0.5,0.5]
[1,"1.5",{"$f":"PFP!D12","v":"Técnico de projetos/obra (P8147)"},"mês",1.5,0.5,0.5,0.5]
[1,"1.6",{"$f":"PFP!D16","v":"Relatório Parcial"},{"$f":"PFP!E16","v":"un"},0]
[1,"1.7",{"$f":"PFP!D17","v":"Relatório Final"},{"$f":"PFP!E17","v":"un"},1,null,0,1]
[1,1,"Estudos Básicos (EB)",null,4.1500000000000004,{"$f":"SUM(F5:F11)","v":1.05},1.05,2.0499999999999998,0,0,0,null,null,0,0]
[2,"2.1",{"$f":"PFP!D8","v":"Engenheiro coordenador (P8061)"},{"$f":"PFP!E8","v":"mês"},{"$f":"SUM(F13:O13)","v":0.15000000000000002},0.05,0.05,0.05]
[2,"2.2",{"$f":"PFP!D9","v":"Engenheiro pleno (P8066)"},{"$f":"PFP!E9","v":"mês"},{"$f":"SUM(F14:O14)","v":1},0.25,0.25,0.5]
[2,"2.3",{"$f":"PFP!D10","v":"Engenheiro júnior (P8065)"},{"$f":"PFP!E10","v":"mês"},2.5,0.5,1,1]
[2,"2.4",{"$f":"PFP!D11","v":"Desenhista (40807)"},{"$f":"PFP!E11","v":"mês"},1.5,0.5,0.5,0.5]
[2,"2.5",{"$f":"PFP!D12","v":"Técnico de projetos/obra (P8147)"},"mês",1.5,0.5,0.5,0.5]
[2,"2.6",{"$f":"PFP!D16","v":"Relatório Parcial"},"un",0]
[2,"2.7",{"$f":"PFP!D17","v":"Relatório Final"},"un",1,null,null,1]
[2,2,"Estudo de Viabilidade Técnica, Econômica e Ambiental (EVTEA)",null,7.6499999999999995,{"$f":"SUM(F13:F19)","v":1.8},2.2999999999999998,3.55,0,0,0,null,null,0,0]
[3,"3.1",{"$f":"PFP!D8","v":"Engenheiro coordenador (P8061)"},{"$f":"PFP!E8","v":"mês"},{"$f":"SUM(F21:O21)","v":0.25},null,null,null,0.05,0.05,0.05,0.05,0.05]
[3,"3.2",{"$f":"PFP!D9","v":"Engenheiro pleno (P8066)"},{"$f":"PFP!E9","v":"mês"},2.5,null,null,null,0.5,0.5,0.5,0.5,0.5]
[3,"3.3",{"$f":"PFP!D10","v":"Engenheiro júnior (P8065)"},{"$f":"PFP!E10","v":"mês"},2.5,null,null,null,0.5,0.5,0.5,0.5,0.5]
[3,"3.4",{"$f":"PFP!D11","v":"Desenhista (40807)"},{"$f":"PFP!E11","v":"mês"},5,null,null,null,1,1,1,1,1]
[3,"3.5",{"$f":"PFP!D12","v":"Técnico de projetos/obra (P8147)"},"mês",2.5,null,null,null,0.5,0.5,0.5,0.5,0.5]
[3,"3.6",{"$f":"PFP!D16","v":"Relatório Parcial"},{"$f":"PFP!E16","v":"un"},0]
[3,"3.7",{"$f":"PFP!D17","v":"Relatório Final"},{"$f":"PFP!E17","v":"un"},1,{"$nulls":7},1]
[3,3,"Projeto Básico (PB)",null,13.75,{"$f":"SUM(F21:F27)","v":0},0,0,2.5499999999999998,2.5499999999999998,2.5499999999999998,2.5499999999999998,3.55,0,0]
[4,"4.1","Engenheiro coordenador (P8061)","mês",0.5,{"$nulls":8},0.25,0.25]
[4,"4.2","Engenheiro pleno (P8066)","mês",1,{"$nulls":8},0.5,0.5]
[4,"4.3","Engenheiro júnior (P8065)","mês",1,{"$nulls":8},0.5,0.5]
[4,"4.4","Desenhista (40807)","mês",2,{"$nulls":8},1,1]
[4,"4.5","Técnico de projetos/obra","mês",0]
[4,"4.6","Relatório Parcial","un",0]
[4,"4.7","Relatório Final","un",1,{"$nulls":9},1]
[4,4,"Projeto Executivo (PE)",null,5.5,{"$f":"SUM(F29:F35)","v":0},0,0,0,0,0,null,null,2.25,3.25]
["Total",null,"Balanço de Insumos",null,null,{"$f":"F36+F28+F20+F12","v":2.85},3.3499999999999996,5.6,2.5499999999999998,2.5499999999999998,2.5499999999999998,null,null,2.25,3.25]

{"sheet":"COT. VANT","index":9,"n_rows":17,"n_cols":10,"rows_kept":17,"cut":false,"hidden":true,"merged":[[1,0,1,9],[7,0,9,0],[7,1,7,5],[8,1,8,5],[9,1,9,5]]}
[]
["COTAÇÃO ORÇAMENTÁRIA DE LEVANTAMENTO PLANIALTIMÉTRICO POR MEIO DE VANT PARA ÁREA NA CIDADE DE PINDARÉ-MIRIM-MA"]
["MÊS/ANO DE REFERÊNCIA ","ÁREA DO PROJETO [ha]","EMPRESA","LOCALIDADE","WEBSITE","CONTATO","AVALIAÇÃO TÉCNICA DA PROPOSTA","PREÇO","PREÇO UNITÁRIO","RELAÇÃO CUSTO-BENEFÍCIO"]
["2022-09-01",50,"DRONES SOLUTION","SALVADOR-BA","http://www.dronessolution.com.br/","contato@dronessolution.com.br","SATISFATÓRIA",9800,{"$f":"(H4/B4)","v":196},"A"]
["2022-09-01",50,"ERG","BELO HORIZONTE-MG","http://www.ergbh.com.br/","comercial@ergbh.com.br","SATISFATÓRIA",13240.5,{"$f":"(H5/B5)","v":264.81},"B"]
["2022-09-01",50,"CEPEMAR","VITÓRIA-ES","http://www.cepemar.com.br/","comercial@cepemar.com.br","SATISFATÓRIA",63000,1260,"C"]
[]
["Observações","  1. Na cotação acima já estão iclusos: Planejamento Aerotogramétrico, Voo Aerotoforamétrico, Apoio de Campo, Aerotriangulação, Restituição, MDT, MDS, Ortofotos, Edição/Revisão e Entrega Final.",{"$nulls":4},"CV com todos valores:",{"$f":"STDEVA(H4:H6)/AVERAGE(H4:H6)","v":1.0380549324194583}]
[null,"  2. INCONCLUSIVA: não apresentou o orçamento de forma detalhada.",{"$nulls":4},"CV tirando o maior valor:",{"$f":"STDEVA(H4:H5)/AVERAGE(H4:H5)","v":0.21117604918923782}]
[null,"  3. SATISFATÓRIA: apresentou, no mínimo, os requisitos básicos de um orçamento.",{"$nulls":4},"Média tirando o maior valor:",{"$f":"AVERAGE(H4:H5)","v":11520.25},"Valor para a área de 65ha"]
[null,"4-Para o valor do serviço de Vant, considerou-se a média tirando o maior valor das cotações recebidas, pois o CV (coeficiente de variação) está muito elevado com as 3 cotaçoes."]
[null,"5-As cotações recebidas foram utilizadas para o serviço de levantamento do Ramal do Manga no Amapá, referente a um trecho de 6,5km de rodovia, com área total estimadade de 65ha."]
[null,"Dessa forma, para a cotação representativa deste serviço, realizou-se a parametrização proporcional a área de estudo do serviço a ser realizado."]
[]
[null,"Portanto:"]
[null,null,{"$f":"I10","v":"Valor para a área de 65ha"},{"$f":"H10","v":11520.25}]
[null,null,"Valor unitário para a área de 1ha",{"$f":"D16/65","v":177.23461538461538}]

{"sheet":"Planilha de Medição","index":10,"n_rows":27,"n_cols":9,"rows_kept":27,"cut":false,"hidden":false,"merged":[[4,1,4,2],[0,1,2,8]]}
[null,"PLANILHA DE MEDIÇÃO"]
[]
[]
[]
[null,"#",null,"DESCRIÇÃO","P. PARCIAL (80%)","P. GLOBAL","P. UNITÁRIO","P. TOTAL","% PRODUTO"]
[null,1,1,"Estudos Básicos (EB)",null,null,null,{"$f":"'CRO1_Ins-Pro'!H17","v":193029.6},{"$f":"H6/$H$27","v":0.32223332949884392}]
[null,1,"1.1","Serviços Topográficos/Cartográficos",{"$f":"H7*0.8","v":36337.184000000001},null,{"$f":"H7","v":45421.48},{"$f":"'CRO1_Ins-Pro'!F15","v":45421.48},{"$f":"H7/H6","v":0.23530836721414747}]
[null,1,"1.2","Serviços Geológicos/Geotécnicos",{"$f":"H8*0.8","v":95457.112000000008},null,{"$f":"H8","v":119321.39},{"$f":"'CRO1_Ins-Pro'!F16","v":119321.39},{"$f":"H8/H6","v":0.618150739575692}]
[null,1,"1.3","Estudos Hidrológicos e Hidrogeológicos",{"$f":"H9*0.8","v":5868.0998399999999},{"$f":"H9","v":7335.1247999999996},null,{"$f":"I9*H6","v":7335.1247999999996},3.7999999999999999E-2]
[null,1,"1.4","Relatório de Avaliação Fundiária",{"$f":"H10*0.8","v":4848.9035519999998},{"$f":"H10","v":6061.1294399999997},null,{"$f":"I10*H6","v":6061.1294399999997},3.1399999999999997E-2]
[null,1,"1.5","Estudos de Tráfego",{"$f":"H11*0.8","v":2803.0828305019527},3503.8535381274405,null,{"$f":"I11*H7","v":3503.8535381274405},{"$f":"1-SUM(I7:I10)","v":7.7140893210160488E-2}]
[null,2,2,"Estudo de Viabilidade Técnica, Econômica e Ambiental (EVTEA)",null,null,null,{"$f":"'CRO1_Ins-Pro'!I17","v":122984.31},{"$f":"H12/$H$27","v":0.2053034544309161}]
[null,2,"2.1","Diagnóstico e Prognóstico",{"$f":"H13*0.8","v":16578.284987999999},{"$f":"H13","v":20722.856234999999},null,{"$f":"I13*H12","v":20722.856234999999},0.16850000000000001]
[null,2,"2.2","Análise da Viabilidade Ambiental",{"$f":"H14*0.8","v":36718.195593600001},{"$f":"H14","v":45897.744491999998},null,{"$f":"I14*H12","v":45897.744491999998},0.37319999999999998]
[null,2,"2.3","Avaliação Socioeconômica",{"$f":"H15*0.8","v":18280.387838399998},22850.484797999998,null,{"$f":"I15*H12","v":22850.484797999998},0.18579999999999999]
[null,2,"2.4","Análise Técnica-Econômica-Ambiental",{"$f":"H16*0.8","v":26810.579580000009},33513.22447500001,null,{"$f":"I16*H12","v":33513.22447500001},{"$f":"1-SUM(I13:I15)","v":0.27250000000000008}]
[null,3,3,"Projeto Básico (PB)",null,null,null,{"$f":"'CRO1_Ins-Pro'!J17","v":200174.77},{"$f":"H17/$H$27","v":0.33416109559759383}]
[null,3,"3.1","Projeto Geométrico",{"$f":"H18*0.8","v":17343.142072800008},{"$f":"H18","v":21678.927591000011},null,{"$f":"I18*$H$17","v":21678.927591000011},{"$f":"1-SUM(I19:I24)","v":0.10830000000000006}]
[null,3,"3.3","Projeto de Terraplenagem",25862.580284,{"$f":"H19","v":32328.225354999999},null,32328.225354999999,0.1615]
[null,3,"3.4","Projeto de Drenagem",29049.362622400004,36311.703278000001,null,36311.703278000001,0.18140000000000001]
[null,3,"3.5","Projeto de Pavimentação",31147.194212000002,38933.992765000003,null,38933.992765000003,0.19450000000000001]
[null,3,"3.6","Projeto de Sinalização",9111.9555304000005,11389.944412999999,null,11389.944412999999,5.6899999999999999E-2]
[null,3,"3.7","Projeto de Iluminação Pública",7830.8370023999996,9788.5462529999986,null,9788.5462529999986,4.8899999999999999E-2]
[null,3,"3.8","Projeto de Obras de Artes Especiaos",39794.744276000005,49743.430345000001,null,49743.430345000001,0.2485]
[null,4,4,"Projeto Executivo (PE)",null,null,null,{"$f":"'CRO1_Ins-Pro'!K17","v":82848.05},{"$f":"H25/$H$27","v":0.13830212047264615}]
[]
[{"$nulls":7},{"$f":"H25+H17+H12+H6","v":599036.73},{"$f":"I25+I17+I12+I6","v":1}]

{"sheet":"Cronograma Físico-Financeiro","index":11,"n_rows":19,"n_cols":14,"rows_kept":19,"cut":false,"hidden":false,"merged":[[13,1,14,2],[17,1,18,2],[10,1,11,1],[10,2,11,2],[0,1,1,4],[4,1,5,1],[4,2,5,2],[6,1,7,1],[6,2,7,2],[8,1,9,1],[8,2,9,2],[15,2,16,2]]}
[null,"CRONOGRAMA FÍSICO-FINANCEIRO"]
[]
[]
[null,null,null,"Mês 1","Mês 2","Mês 3","Mês 4","Mês 5","Mês 6","Mês 7","Mês 8","Mês 9","Mês 10"]
[null,"Estudos Básicos (EB)",{"$f":"'CRO1_Ins-Pro'!H17","v":193029.6},{"$f":"D6*$C$5","v":30884.736000000001},77211.840000000011,27024.144000000004,0,57908.88,0,0,0,0,0,{"$f":"SUM(D5:M5)","v":193029.60000000003}]
[null,null,null,0.16,0.4,0.14000000000000001,null,0.3,{"$nulls":5},1]
[null,"Estudo de Viabilidade Técnica, Econômica e Ambiental (EVTEA)",{"$f":"'CRO1_Ins-Pro'!I17","v":122984.31},{"$f":"D8*$C$7","v":36895.292999999998},49193.724000000002,36895.292999999998,0,0,0,0,0,0,0,122984.31]
[null,null,null,0.3,0.4,0.3,{"$nulls":7},1]
[null,"Projeto Básico (PB)",{"$f":"'CRO1_Ins-Pro'!J17","v":200174.77},{"$f":"D10*$C$9","v":0},0,0,20017.476999999999,40034.953999999998,50043.692499999997,50043.692499999997,40034.953999999998,0,0,200174.77]
[{"$nulls":6},0.1,0.2,0.25,0.25,0.2,0,null,1]
[null,"Projeto Executivo (PE)",{"$f":"'CRO1_Ins-Pro'!K17","v":82848.05},{"$f":"D12*$C$11","v":0},0,0,0,0,0,0,0,41424.025000000001,41424.025000000001,82848.05]
[{"$nulls":11},0.5,0.5,1]
[]
[null,"NO MÊS",null,{"$f":"D5+D7+D9+D11","v":67780.028999999995},126405.56400000001,63919.437000000005,{"$f":"G5+G7+G9+G11","v":20017.476999999999},97943.834000000003,50043.692499999997,50043.692499999997,40034.953999999998,41424.025000000001,41424.025000000001,{"$f":"SUM(D14:M14)","v":599036.7300000001}]
[null,null,null,{"$f":"D14/SUM($C$5:$C$12)","v":0.11314836904908983},0.21101471357190399,0.10670370245911298,{"$f":"G14/SUM($C$5:$C$12)","v":3.3416109559759377E-2},0.16350221796917191,8.3540273899398443E-2,8.3540273899398443E-2,6.6832219119518754E-2,6.9151060236323059E-2,6.9151060236323059E-2,{"$f":"SUM(D15:M15)","v":0.99999999999999978}]
[null,null,"DESEMBOLSO         (80% do Subproduto) ",{"$f":"D14*0.8","v":54224.023199999996},{"$f":"E14*0.8","v":101124.45120000001},{"$f":"F14*0.8 + (0.2*N7)","v":75732.411600000007},{"$f":"G14*0.8","v":16013.981599999999},{"$f":"H14*0.8+(0.2*$N$5)","v":116960.9872},40034.953999999998,40034.953999999998,{"$f":"K14*0.8 + (0.2*$N$9)","v":72062.917199999996},33139.22,{"$f":"M14*0.8 + (0.2*$N$11)","v":49708.83},{"$f":"SUM(D16:M16)","v":599036.73}]
[null,null,null,{"$f":"D16/SUM($C$5,$C$7,$C$9,$C$11)","v":9.0518695239271862E-2},{"$f":"E16/SUM($C$5,$C$7,$C$9,$C$11)","v":0.16881177085752319},0.12642365285347359,{"$f":"G16/SUM($C$5,$C$7,$C$9,$C$11)","v":2.6732887647807499E-2},{"$f":"H16/SUM($C$5,$C$7,$C$9,$C$11)","v":0.19524844027510632},{"$f":"I16/SUM($C$5,$C$7,$C$9,$C$11)","v":6.6832219119518754E-2},{"$f":"J16/SUM($C$5,$C$7,$C$9,$C$11)","v":6.6832219119518754E-2},{"$f":"K16/SUM($C$5,$C$7,$C$9,$C$11)","v":0.12029799441513375},{"$f":"L16/SUM($C$5,$C$7,$C$9,$C$11)","v":5.5320848189058448E-2},{"$f":"M16/SUM($C$5,$C$7,$C$9,$C$11)","v":8.2981272283587676E-2},{"$f":"SUM(D17:M17)","v":0.99999999999999989}]
[null,"ACUMULADO",null,{"$f":"D16","v":54224.023199999996},{"$f":"D18+E16","v":155348.47440000001},{"$f":"E18+F16","v":231080.886},247094.8676,364055.85479999997,404090.8088,444125.76280000003,516188.68000000005,549327.9,599036.73]
[null,null,null,{"$f":"D15","v":0.11314836904908983},{"$f":"D19+E15","v":0.3241630826209938},0.43086678508010678,0.46428289463986616,{"$f":"G19+H15","v":0.62778511260903813},0.71132538650843657,0.79486566040783502,0.86169787952735377,0.93084893976367677,0.99999999999999978]

{"sheet":"CPU VEICULO_PickUp","index":12,"n_rows":61,"n_cols":33,"rows_kept":61,"cut":false,"hidden":false,"merged":[[52,8,52,18],[52,19,52,26],[4,0,4,2],[6,0,6,2],[7,0,7,1],[7,4,7,7],[8,0,8,2]]}
[]
[]
[]
[]
["Composição de Preços de Locação de Veículo tipo pick-up"]
[null,"Data de atualização:","2024-01-22",null,"CV","Média","Mediana",null,null,null,"CV","Média","Mediana",{"$nulls":8},"CV","Média","Mediana"]
["CODEVASF ",null,null,null,{"$f":"_xlfn.STDEV.S(E10:H10)/AVERAGE(E10:H10)","v":9.2667922664402616E-2},{"$f":"AVERAGE(E10:H10)","v":179935.5},{"$f":"MEDIAN(E10:H10)","v":184702},null,null,null,{"$f":"_xlfn.STDEV.S(L9:S9)/AVERAGE(L9:S9)","v":0.20952494145854728},{"$f":"AVERAGE(L9:S9)","v":31.095714285714287},{"$f":"MEDIAN(L9:S9)","v":30.16},{"$nulls":8},{"$f":"_xlfn.STDEV.S(W9:AD9)/AVERAGE(W9:AD9)","v":0.13240988535259646},{"$f":"AVERAGE(W9:AD9)","v":430.60093749999999},{"$f":"MEDIAN(W9:AD9)","v":437.31624999999997}]
["OBS:               Preço sem BDI e sem motorista                                                                   BDI=",null,null,null,"Preço FIPE ",{"$nulls":4},"PRODUTO ","MENOR (MÉDIA, MEDIANA)","COT. 1","COT. 2","COT. 3","COT. 4","COT. 5","COT. 6","COT. 7","COT. 8",null,"PRODUTO","MENOR (MÉDIA, MEDIANA)","COT. 1","COT. 2","COT. 3","COT. 4","COT. 5","COT. 6","COT. 7","COT. 8"]
["Veículo tipo pick-up, cabine dupla - 2.0 16V 4x4 diesel Aut.",null,null,null,"Toro Ultra 2.0 16V 4x4 TB Diesel Aut.","Toro Freedom 2.0 16V 4x4 TB Diesel Aut.","Toro Volcano 2.0 16V 4x4 TB Diesel Aut."," Toro Ranch 2.0 16V 4x4 TB Diesel Aut.\n",null,"LUBRIFICANTE 5W30",{"$f":"SMALL(L7:M7,1)","v":30.16},32.270000000000003,28.9,30.16,37.700000000000003,39.99,20.25,28.4,null,null,"Pneu 225/65 R17",{"$f":"SMALL(W7:X7,1)","v":430.60093749999999},{"$f":"1661.85/4","v":415.46249999999998},{"$f":"1940.9/4","v":485.22500000000002},399.88,330.46,479.6,386.23,459.17,488.78]
[null,"Custo Mensal (R$):",{"$f":"C51","v":7163.7901683616183},null,193030,157308,177450,191954]
[null,"Custo Diária (R$):",{"$f":"C10/22","v":325.62682583461901}]
[null,"Custo Horário (R$):",{"$f":"C10/176","v":40.703353229327377}]
["A","Depreciação mensal do equipamento"]
["A1","Preço de Aquisição ",{"$f":"SMALL(F7:G7,1)","v":179935.5}]
["A2","Tempo previsto de vida útil (meses)",36]
["A3","Previsão de recup. Na venda do bem usado",0.4]
["A4","Custo mensal [A1-(A3xA1)]/A2",{"$f":"(C14-(C16*C14))/C15","v":2998.9250000000002}]
["B","Juros pelo Capital empregado"]
["B1","Taxa mensal de Juros *",{"$f":"POWER(1+C56,1/12)-1","v":9.300823618865417E-3}]
["B2","Juros s/depreciação/aluguel (B1xA4)",{"$f":"C19*C17","v":27.892472471205974}]
["C","Conservação e manutenção **",0.75]
["C1","Taxa de gastos s/a deprec. Inc. seguros (%)",{"$f":"C21","v":0.75},{"$nulls":28},"PREÇO DO DIESEL",5.98]
["C2","Incidência mensal (C1xA4)",{"$f":"C22*C17","v":2249.1937500000004},{"$nulls":28},"https://precos.petrobras.com.br/sele%C3%A7%C3%A3o-de-estados-diesel "]
["D","Combustível"]
["D1","Média mensal de quilômetro por veículo",{"$f":"130*22","v":2860}]
["D2","Preço do litro de combustível",{"$f":"AG22","v":5.98}]
["D3","Quilômetros rodados com um litro combustivel",10]
["D4","Combustivel    (D1/D3)*D2",{"$f":"(C25/C27)*C26","v":1710.2800000000002}]
["E","Lubrificantes"]
["E1","Quilometragem do Contrato (D1*12)",{"$f":"C25*36","v":102960}]
["E2","Franquia por troca de óleo (km)",10000]
["E3","Preço do litro de óleo",{"$f":"K9","v":30.16}]
["E4","Quantidade de litros de óleo por troca",5]
["E5","Quantidade de dias do Contrato",{"$f":"365*3","v":1095}]
["E6","Lubrificantes  E = (E1*E3*E4*30)/E2*E5",{"$f":"(C30*C32*C33*30)/(C31*C34)","v":42.537994520547947}]
["F","Pneus"]
["F1","Quilometragem do Contrato ",{"$f":"C30","v":102960}]
["F2","Vida do Pneu em quilômetros",45000]
["F3","Quantidade de pneus",5]
["F4","Preço do Pneu",{"$f":"V9","v":430.60093749999999}]
["F5","Quantidade de dias do contrato ",{"$f":"C34","v":1095}]
["F6","Pneus = (F1*F3*F4*30)/(F2*F5)",{"$f":"(C37*C39*C40*30)/(C38*C41)","v":134.96095136986301}]
["G","Motorista"]
["G1","Salário com encargos sociais",0,{"$nulls":6},"https://www.google.com/search?q=lubrificante+5w30&sxsrf=AJOqlzUM514L6uswJHb1jIGpGgXchTtV5A:1677092590843&source=lnms&tbm=shop&sa=X&sqi=2&ved= "]
["H","Custo Mensal"," "]
[null,"Sem Motorista (A4+B2+C2+D4+E6+F6)",{"$f":"C17+C20+C23+C28+C35+C42","v":7163.7901683616183}]
[null,"Com Motorista (A4+B2+C2+D4+E6+F6+G1)",{"$f":"C17+C20+C23+C28+C35+C42+C44","v":7163.7901683616183}]
["I","Custo Direto p/ km Rodado"]
[null,"Sem Motorista",{"$f":"C46/C25","v":2.5048217371893768}]
[null,"Com Motorista",{"$f":"C47/C25","v":2.5048217371893768}]
["J","Preço cobrado sem BDI",{"$f":"C46*(1+C8)","v":7163.7901683616183}]
["J1","Sem Motorista",{"$f":"C51","v":7163.7901683616183}]
["J2","Com Motorista",{"$f":"C47","v":7163.7901683616183},{"$nulls":16},"https://www.google.com/search?q=pneu+225%2F65+R17&sa=X&biw=1600&bih=757&tbm=shop&sxsrf=AJOqlzWsb-d4PS1_OUOEhKmRc2RbtSg3RQ%3A1677092596279&ei=9Gb2Y9K5ENTa5OUPvLykGA&ved=0ahUKEwjSg9Pj6Kn9AhVULbkGHTweCQMQ4dUDCAg&uact=5&oq=pneu+225%2F65+R17&gs_lcp=Cgtwcm9kdWN0cy1jYxADMgsIABCABBCxAxCDATIFCAAQgAQyBwgAEIAEEAoyBwgAEIAEEAoyBwgAEIAEEAoyBwgAEIAEEAoyBwgAEIAEEAoyBQgAEIAEMgcIABCABBAKMgcIABCABBAKOgQIIxAnOgQIABBDSgQIQRgAUABYoTJgqUBoAHAAeACAAdIFiAGUKZIBDTAuMi42LjIuMi4yLjGYAQCgAQHAAQE&sclient=products-cc"]
[]
[null,"OBSERVAÇÕES:"]
["*","Calculado com base na taxa SELIC JANEIRO/2024:",0.11749999999999999]
[null," Taxa de Juros Selic — Português (Brasil) (www.gov.br) "]
["**","Conservação e manutenção - é calculado com o uso de um coeficiente multiplicador \"k\", conforme tabela abaixo, sobre a "]
[null,"depreciação mensal do equipamento (Item A da planilha de composição de preços). Os valores de K são fornecidos por"]
[null," fabricantes. "]
[null,"Metodologia conforme a bibliografia \"Como Preparar Orçamentos de Obras\", 3 edição, Aldo Dórea Mattos, 2019."]

{"sheet":"Consultiva atualizada","index":13,"n_rows":113,"n_cols":25,"rows_kept":113,"cut":false,"hidden":false,"merged":[[0,16,0,21],[0,22,0,23],[0,5,0,15],[1,5,1,6],[1,7,1,8],[1,9,1,10],[1,11,1,12],[1,13,1,14]]}
["Código","Categoria","Unid.","Salário","Encargos Sociais","Encargos Complementares",{"$nulls":10},"Encargos Adicionais",{"$nulls":5},"Encargos Totais",null,"Valor Total"]
[{"$nulls":5},"Alimentação",null,"EPI",null,"Ferramenta",null,"Transporte",null,"Exame Ocupacional",null,null,"Cesta Básica",null,"Assistência Médica",null,"Seguro de Vida"]
[null,null,null,"R$","%","R$","%","R$","%","R$","%","R$","%","R$","%","R$","%","R$","%","R$","%","R$","%","R$","R$"]
["Profissionais mensalistas"]
["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]
["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]
["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]
["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]
["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]
["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]
["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]
["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]
["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]
["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]
["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]
["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]
["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]
["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]
["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]
["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]
["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]
["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]
["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]
["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]
["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]
["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]
["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]
["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]
["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]
["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]
["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]
["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]
["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]
["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]
["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]
["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]
["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]
["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]
["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]
["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]
["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]
["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]
["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]
["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]
["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]
["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]
["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]
["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]
["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]
["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]
["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]
["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]
["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]
["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]
["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]
["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]
["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]
["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]
["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]
["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]
["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]
["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]
["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]
["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]
["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]
["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]
["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]
["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]
["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]
["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]
["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]
["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]
["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]
["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]
["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]
["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]
["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]
["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]
["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]
["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]
["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]
["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]
["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]
["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]
["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]
["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]
["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]
["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]
["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]
["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]
["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]
["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]
["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]
["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]
["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]
["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]
["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]
["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]
["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]
["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]
["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]
["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]
["Profissionais horistas"]
["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]
["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]
["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]
["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]
["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]
["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]
["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]
["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]
["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]
["Fonte: FGV IBRE"]