{"text_format":"2","workbook":"xlsx","n_sheets":14,"sheets":["PFP","PFP1.1_Topo","PFP1.2_Geo","PFP1.3_Amb","CPU Veículo","CPU Diária","PFP2.1_FatorKa","PFP2.2_FatorKb","PFP2.3_FatorKc","PFP3_FatorKd","CRO1_Ins-Pro","CRO2_Pro-Mes","DNIT TC - 012023","DNIT TC -072023"],"not_rendered":{"charts":0,"images":1,"macros":0,"external_links":0,"defined_names":8,"comments":2,"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":40,"n_cols":11,"rows_kept":40,"cut":false,"hidden":false,"merged":[[25,7,25,10],[25,0,25,6],[24,7,24,10],[24,0,24,6],[31,0,31,10],[26,0,26,6],[26,7,26,10],[28,0,28,10],[39,0,39,10],[32,0,32,10],[34,0,34,10],[27,0,27,10],[33,0,33,10],[29,0,29,10],[35,0,35,10],[36,0,36,10],[37,0,37,10],[38,0,38,10],[30,0,30,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],[23,0,23,6],[23,7,23,10],[5,0,5,4],[22,0,22,6],[22,7,22,10]]}
["PROPOSTA FINANCEIRA DO PROJETO",{"$nulls":8},"CODIGO:"]
[{"$nulls":9},"PFP"]
["NOME DA CONSULTORA:"]
[]
["PROJETO:",{"$nulls":4},"CONTRATANTE:",null,null,null,"Data base: "]
["Estudos e Projeto Básico do Sistema Adutor de Serra Verde, no Estado do Rio Grande do Norte ",{"$nulls":4},"12ª SR CODEVASF",null,null,null,"2024-06-01"]
["Base","Cod2","Cod3","Categoria / Insumo","Uni","Qde","CUD","PU","FatorK","CT","PT"]
["SICRO","MO","P0","Engenheiro coordenador (P8061)","mês",{"$f":"'CRO1_Ins-Pro'!D5","v":3},null,{"$f":"ROUND(I8*G8,2)","v":0},{"$f":"'PFP2.3_FatorKc'!E36","v":1},{"$f":"ROUND(F8*G8,2)","v":0},{"$f":"ROUND(F8*H8,2)","v":0}]
["SICRO","MO","P1","Engenheiro de projeto pleno - Civil/Sanitarista (P8066)","mês",{"$f":"'CRO1_Ins-Pro'!D6","v":5},null,0,{"$f":"'PFP2.1_FatorKa'!E36","v":1},{"$f":"ROUND(F9*G9,2)","v":0},{"$f":"ROUND(F9*H9,2)","v":0}]
["SICRO","MO","P2","Engenheiro ambiental pleno (P8058)","mês",{"$f":"'CRO1_Ins-Pro'!D7","v":3},null,{"$f":"ROUND(I10*G10,2)","v":0},{"$f":"'PFP2.2_FatorKb'!E36","v":1},0,0]
["SICRO","MO","P3","Engenheiro pleno - demais esp. (P8066)","mês",{"$f":"'CRO1_Ins-Pro'!D8","v":2},null,{"$f":"ROUND(I11*G11,2)","v":0},{"$f":"'PFP2.2_FatorKb'!E36","v":1},0,0]
["SICRO","MO","T1","Técnico de projetos/obra (P8147)","mês",{"$f":"'CRO1_Ins-Pro'!D9","v":7},null,0,{"$f":"'PFP2.1_FatorKa'!$E$36","v":1},0,0]
["SICRO","MO","A1","Auxiliar administrativo (P8026)","mês",{"$f":"'CRO1_Ins-Pro'!D10","v":7},null,0,{"$f":"'PFP2.1_FatorKa'!$E$36","v":1},0,0]
["SICRO","EC","ECA","Encargos Comp. e Adicionais","mês",{"$f":"'CRO1_Ins-Pro'!D11","v":27},null,0,{"$f":"PFP3_FatorKd!$E$17","v":1},0,0]
["COMP.","LO","V1","Diárias","dia",{"$f":"'CRO1_Ins-Pro'!D12","v":70},{"$f":"'CPU Diária'!C19","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"PFP3_FatorKd!$E$17","v":1},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
["PROP","LO","V2","Pick-up cabine dupla ","dia",{"$f":"'CRO1_Ins-Pro'!D13","v":70},{"$f":"'CPU Veículo'!C11","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"PFP3_FatorKd!$E$17","v":1},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
["PROP","LO","V3","Passagens Aéreas (ida e volta)","un",{"$f":"'CRO1_Ins-Pro'!D14","v":3},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"PFP3_FatorKd!$E$17","v":1},{"$error":"#REF!"},{"$error":"#REF!"}]
["CODE","EM","M1","Relatório Parcial","un",{"$f":"'CRO1_Ins-Pro'!D15","v":14},null,0,{"$f":"PFP3_FatorKd!$E$17","v":1},0,0]
["CODE","EM","M2","Relatório Final","un",{"$f":"'CRO1_Ins-Pro'!D16","v":4},null,0,{"$f":"PFP3_FatorKd!$E$17","v":1},0,0]
["COMP.","SU","TOP","Total Serviços Cartográficos","un",{"$f":"'CRO1_Ins-Pro'!D17","v":1},"-",{"$f":"'PFP1.1_Topo'!H23","v":0},"-","-",0]
["COMP.","SU","GEO","Total Serviços Geotécnicos","un",{"$f":"'CRO1_Ins-Pro'!D18","v":1},"-",{"$f":"'PFP1.2_Geo'!H40","v":0},"-","-",0]
["EMBASA","SU","AMB","Total Serviços Ambientais","un",{"$f":"'CRO1_Ins-Pro'!D19","v":1},"-",{"$f":"'PFP1.3_Amb'!H37","v":0},"-","-",0]
["TOTAL DOS CUSTOS DIRETOS",{"$nulls":6},{"$f":"SUM(J8:J22)","v":{"$error":"#DIV/0!"}}]
["TOTAL DOS ENCARGOS E DISPESAS DIVERSAS",{"$nulls":6},{"$f":"H25-H23","v":{"$error":"#DIV/0!"}}]
["TOTAL DA PROPOSTA A PREÇO GLOBAL",{"$nulls":6},{"$f":"SUM(K8:K19)","v":{"$error":"#DIV/0!"}}]
["TOTAL DA PROPOSTA A PREÇO UNITÁRIO",{"$nulls":6},{"$f":"SUM(K20:K22)","v":0}]
["TOTAL DA PROPOSTA",{"$nulls":6},{"$f":"H25+H26","v":{"$error":"#DIV/0!"}}]
["OBSERVAÇÃO:"]
["Alocar os Insumos MO, com respectivo FatorK, dentro da categoria de vínculo contratual (com ou sem) de cada tipo de profissional"]
["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 Socioó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"]

{"sheet":"PFP1.1_Topo","index":1,"n_rows":28,"n_cols":12,"rows_kept":28,"cut":false,"hidden":false,"merged":[[27,9,27,10],[4,7,5,7],[24,9,24,10],[5,9,6,11],[7,9,8,9],[7,10,8,10],[7,11,8,11],[9,9,9,11],[10,10,10,11],[15,9,15,10],[16,10,16,11],[18,9,18,10],[19,10,19,11],[23,9,23,10],[25,9,26,11],[26,0,26,7],[27,0,27,7],[23,0,23,7],[24,0,24,7],[25,0,25,7],[4,0,4,3],[2,0,2,7],[3,0,3,7],[22,0,22,5],[0,0,1,5],[5,0,5,3],[4,4,4,5],[5,4,5,5]]}
["SERVIÇOS TOPOGRÁFICOS/CARTOGRÁFICOS",{"$nulls":6},"CODIGO:"]
[{"$nulls":7},"PFP-1.1"]
["NOME DA EMPRESA:"]
[]
["PROJETO:",null,null,null,"CONTRATANTE:",null,null,"CPOS - 03/2024 / EMOP - 04/2024 /ORSE - 03/2024 /  Seinfra 028 / CODE - 12/2023"]
[{"$f":"PFP!A6","v":"Estudos e Projeto Básico do Sistema Adutor de Serra Verde, no Estado do Rio Grande do Norte "},null,null,null,"12ª SR CODEVASF",{"$nulls":4},"MEMÓRIA DE CALCULO DO BDI DE FORNECIMENTO"]
["Cod.","Base","Insumos","Uni","Qde","Custo Unitário (CU)","Custo Total","Preço Total (PT)"]
["TP08","CODE","Nivelamento Geométrico classe IIN","km",{"$f":"(52000/20)*0.02","v":52},null,{"$f":"E8*F8","v":0},{"$f":"G8*$L$28+G8","v":0},null,"ITEM","DISCRIMINAÇÃO","PERC.    (%)"]
["TP09","CODE","Nivelamento Geométrico classe IIN (Secções)","km",{"$f":"(52000/20)*0.012","v":31.2},null,{"$f":"E9*F9","v":0},{"$f":"G9*$L$28+G9","v":0}]
["01.016.0035-0","EMOP/COMPOSIÇÃO","Poligonal Classe IIP (Locação)","km",{"$f":"(52000/20)*0.02","v":52},null,0,0]
["01.20.921","CPOS/CDHU/COMPOSIÇÃO","Pontos GPS de dupla frequencia (L1/L2)","un",26,null,0,0,null,"1.00","Despesas Indiretas"]
["TP20","CODE","Levantamento Ecobatimetrico","ha ",1,null,0,0,null,"A1","Seguro e Garantia"]
["TP21","CODE","Levantamento Topobatimétrico","km",1,null,0,0,null,"A2","Riscos e Imprevistos"]
["TP23","CODE","Cadastro Físico (Faixa domínio e instalações)","ha ",62,null,0,0,null,"A3","Despesas Financeiras"]
["TP24","CODE","Cadastro Agrícola (Faixa domínio e instalações)","ha ",62,null,0,0,null,"A4","Administração Central"]
["TP25","CODE","Cadastro Jurídico (Faixa domínio e instalações)","ha ",62,null,0,0,null,"Total do Grupo A =",null,{"$f":"SUM(L12:L15)","v":0}]
["TP26","CODE","Cadastro Socioeconomico (Faixa domínio e instalações)","ha ",62,null,0,0,null,"2.00","Benefício"]
[4369,"ORSE/INSUMO","Marco de Concreto (12x18x60cm)","un",26,null,0,0,null,"B1","LUCRO"]
["TP28","CODE","Estaca Testemunha de Madeira (2x4x70cm)","un",260,null,0,0,null,"Total do Grupo B =",null,{"$f":"L18","v":0}]
["I1652","SEINFRA/INSUMO","Piquetes de Madeira (2x2x20cm)","un",2600,null,0,0,null,"3.00","Impostos"]
["PD06","CODE","Picada Manual p/ levantamento TP","km",{"$f":"(52000/20)*0.02","v":52},null,0,0,null,"C1","PIS / PASEP"]
["PD08","CODE","Picada c/ Trator de Esteira","km",5,null,0,0,null,"C2","COFINS"]
["TOTAL SERVIÇOS TOPOGRÁFICOS",{"$nulls":6},{"$f":"SUM(H8:H22)","v":0},null,"C3","ISS"]
["OBSERVAÇÃO:",{"$nulls":8},"Total do Grupo C =",null,{"$f":"SUM(L21:L23)","v":0}]
["Uni - unidade de medição do insumo;",{"$nulls":8},"Fórmula Para Cálculo do B.D.I"]
["Qde - Quantidade do Insumo (não pode ocorrer alteração pela Licitante)",{"$nulls":8},"BDI =(((1+A4+A1+A2)*(1+A3)*(1+B))/(1-C))-1"]
["CU - Custo Unitário "]
["PT - Preço Total (incluído encargos, taxas e impostos). Foi utilizado BDI de fornecimento de 14,69%",{"$nulls":8},"Bonificação Sobre Despesas indiretas (B.D.I) =",null,{"$f":"(((1+L15+L12+L13)*(1+L14)*(1+L19))/(1-L24))-1","v":0}]

{"sheet":"PFP1.2_Geo","index":2,"n_rows":45,"n_cols":24,"rows_kept":45,"cut":false,"hidden":false,"merged":[[39,0,39,5],[43,0,43,7],[5,0,5,3],[5,4,5,5],[44,0,44,7],[40,0,40,7],[41,0,41,7],[42,0,42,7],[4,0,4,3],[4,4,4,5],[2,0,2,7],[3,0,3,7],[0,0,1,5],[24,9,25,11],[26,9,26,10],[4,9,5,11],[6,9,7,9],[6,10,7,10],[6,11,7,11],[8,9,8,11],[9,10,9,11],[14,9,14,10],[15,10,15,11],[17,9,17,10],[18,10,18,11],[22,9,22,10],[23,9,23,10]]}
["SERVIÇOS GEOLÓGICOS/GEOTÉCNICOS",{"$nulls":6},"CODIGO:",{"$nulls":12},"Maior Dist",43.5]
[{"$nulls":7},"PFP-1.2",{"$nulls":13},{"$f":"V1*0.2","v":8.7000000000000011}]
["NOME DA EMPRESA:",{"$nulls":20},{"$f":"V2+V1","v":52.2}]
[]
["PROJETO:",null,null,null,"CONTRATANTE:",null,null,"Data base: ",null,"MEMÓRIA DE CALCULO DO BDI DE FORNECIMENTO"]
[{"$f":"PFP!A6","v":"Estudos e Projeto Básico do Sistema Adutor de Serra Verde, no Estado do Rio Grande do Norte "},null,null,null,"12ª SR CODEVASF",null,null,"CPOS - 03/2024 / EMOP - 04/2024 / SIURB - 07/2023 / EMBASA - 01/2024 / SETOP - 01/2024 / ORSE - 03/2024 / COMPESA - 07/2023 / CODE - 12/2023 / SUDECAP 10/2023",{"$nulls":9},"2023-03-01","2023-01-01","2023-02-01","2022-01-01","2023-04-01","2020-02-01"]
["Cod.","Base","Insumos","Uni","Qde","Custo Unitário (CU)","Custo Total","Preço Total (PT)",null,"ITEM","DISCRIMINAÇÃO","PERC.    (%)"]
["A.07.000.020350","CPOS","Sondagem Rotativa: (Des)Mobilização","un",1,null,{"$f":"ROUND(F8*E8,2)","v":0},{"$f":"G8*$L$27+G8","v":0}]
["01.002.0015-0","EMOP","Sondagem Rotativa: Ø N em rochas","m",{"$f":"10*5","v":50},null,{"$f":"ROUND(F9*E9,2)","v":0},{"$f":"G9*$L$27+G9","v":0},{"$nulls":8},"2023-09-01",324.77]
["01.002.0003-A","EMOP","Sondagem Rotativa: Ø N em solo","m",30,null,{"$f":"ROUND(F10*E10,2)","v":0},0,null,"1.00","Despesas Indiretas",{"$nulls":5},"2023-09-01",126.77,{"$nulls":5},"Utilizado o conceito da memoria quantitativos "]
["GT04","CODE","Sondagem Rotativa: Desl/Inst 0-200 m","un",0,"Já incluso*",0,0,null,"A1","Seguro e Garantia"]
["GT05","CODE","Sondagem Rotativa: Desl/Inst 201-500 m","un",0,"Já incluso*",0,0,null,"A2","Riscos e Imprevistos"]
["GT06","CODE","Sondagem Rotativa: Desl/Inst >500 m","un",0,"Já incluso*",0,0,null,"A3","Despesas Financeiras"]
["01.21.010","CPOS","Sondagem Percussão: (Des)Mobilização","un",1,null,{"$f":"ROUND(F14*E14,2)","v":0},0,null,"A4","Administração Central"]
["01.21.110","CPOS","Sondagem Percursão: com SPT","m",{"$f":"10*10","v":100},null,0,0,null,"Total do Grupo A =",null,{"$f":"SUM(L11:L14)","v":0}]
[200204,"SIURB","Sondagem Percursão: Desloc/Instalação 0-200 m","un",4,null,0,0,null,"2.00","Benefício",{"$nulls":5},"2023-07-01",null,183.44300000000001]
[200205,"SIURB","Sondagem Percursão: Desloc/Instalação 201-500 m","un",4,null,0,0,null,"B1","LUCRO",{"$nulls":5},"2023-07-01",null,275.16000000000003]
["32.01.01","EMBASA","Sondagem Trado","m",{"$f":"6*10*2","v":120},null,0,0,null,"Total do Grupo B =",null,{"$f":"L17","v":0},{"$nulls":6},63.5]
["95.03.01","SUDECAP/INSUMO","Poço de Inspeção","m",{"$f":"52*2","v":104},null,0,0,null,"3.00","Impostos",{"$nulls":8},190.68,null,null,null,"Trados e poços de inspeção (1km em 1km): 52 poços x 2m = 104 metros  "]
[null,null,"Ensaios de caractrização do solo",{"$nulls":6},"C1","PIS / PASEP"]
["34.01.23","EMBASA","Ensaio: Umidade Natural ","un",{"$f":"43+25","v":68},null,{"$f":"ROUND(F21*E21,2)","v":0},0,null,"C2","COFINS",{"$nulls":9},68.87]
["01.001.0091-A","EMOP","Ensaio: Densidade Natural","un",{"$f":"43+25","v":68},null,0,0,null,"C3","ISS",{"$nulls":6},48.89]
["ED-49553","SETOP","Ensaio: Limite de Liquidez","un",68,null,0,0,null,"Total do Grupo C =",null,{"$f":"SUM(L20:L22)","v":0},{"$nulls":6},76.680000000000007]
["ED-49554","SETOP","Ensaio: Limite de Plasticidade","un",68,null,0,0,null,"Fórmula Para Cálculo do B.D.I",{"$nulls":8},77.64]
["ED-49552","SETOP","Ensaio: Granulometria por Peneiramento e Sedimentação","un",68,null,0,0,null,"BDI =(((1+A4+A1+A2)*(1+A3)*(1+B))/(1-C))-1",{"$nulls":8},147.31]
[4685,"ORSE","Ensaio: Compactação Proctor Normal","un",68,null,0,0,{"$nulls":9},202]
["34.01.16","EMBASA","Ensaio: Massa Especifica Real dos Grãos","un",68,null,0,0,null,"Bonificação Sobre Despesas indiretas (B.D.I) =",null,{"$f":"(((1+L14+L11+L12)*(1+L13)*(1+L18))/(1-L23))-1","v":0},{"$nulls":6},65.78]
[null,null,"Ensaios de dispersão"]
["E200320120","EMBASA","Ensaio: Dispersão Granulometria Comparativa","un",{"$f":"3+(2*5)","v":13},null,{"$f":"ROUND(F29*E29,2)","v":0},0,{"$nulls":10},287.39999999999998]
["E200320121","EMBASA","Ensaio: Dispersão Crumb Test","un",{"$f":"3+(2*5)","v":13},null,{"$f":"ROUND(F30*E30,2)","v":0},0,{"$nulls":10},122.19]
[null,null,"Ensaios de análise da areia"]
["GT6.1.16.1","CODE","Ensaio: Análise Quimica da Areia","un",{"$f":"5*2","v":10},null,{"$f":"ROUND(F32*E32,2)","v":0},0,{"$nulls":14},459.82]
["GT6.1.16.2","CODE","Ensaio: Mineralogia da Areia","un",{"$f":"5*2","v":10},null,{"$f":"ROUND(F33*E33,2)","v":0},0,{"$nulls":14},529.20000000000005]
["GT6.1.19","CODE","Ensaio: Reatividade Potencial","un",10,null,{"$f":"ROUND(F34*E34,2)","v":0},0,{"$nulls":14},1382.66]
["01.001.0009-A","EMOP","Ensaio: Equivalente de Areia","un",10,null,{"$f":"ROUND(F35*E35,2)","v":0},0,{"$nulls":9},224.69]
["34.05.30","EMBASA","Ensaio: Teor de Matéria Orgânica","un",10,null,{"$f":"ROUND(F36*E36,2)","v":0},0,{"$nulls":10},200]
[null,null,"Ensaios de material pétreo",{"$nulls":6},"Estimativa para cálculo do poço de inspeção"]
["01.07.13U","COMPESA","Ensaio: Abrasão Los Angeles","un",{"$f":"5*2","v":10},null,{"$f":"ROUND(F38*E38,2)","v":0},0,null,"Comprimento:",1,{"$nulls":7},274.70999999999998]
[4690,"ORSE","Índice de forma","un",{"$f":"5*2","v":10},null,{"$f":"ROUND(F39*E39,2)","v":0},0,null,"Pronfundidade:",1,{"$nulls":10},230.77]
["TOTAL SERVIÇOS GEOTÉCNICOS",{"$nulls":6},{"$f":"SUM(G14:G39)","v":0},null,"Base:",0.3]
["LEGENDA:",{"$nulls":8},"Volume (m³):",{"$f":"K40*K39*K38","v":0.3}]
["Uni - unidade de medição do insumo;",{"$nulls":8},"A largura da base é a mesma largura da concha de uma retroescavadeira"]
["Qde - Quantidade do Insumo (não pode ocorrer alteração pela Licitante)"]
["CU - Custo Unitário "]
["PT - Preço Total (incluído encargos, taxas e impostos). Foi utilizado BDI de fornecimento de 14,69%"]

{"sheet":"PFP1.3_Amb","index":3,"n_rows":42,"n_cols":13,"rows_kept":42,"cut":false,"hidden":false,"merged":[[24,10,24,11],[25,10,25,11],[26,10,27,12],[28,10,28,11],[11,11,11,12],[16,10,16,11],[17,11,17,12],[19,10,19,11],[20,11,20,12],[6,10,7,12],[8,10,9,10],[8,11,9,11],[8,12,9,12],[10,10,10,12],[41,0,41,7],[0,0,1,5],[2,0,2,7],[3,0,3,7],[4,0,4,3],[4,4,4,5],[5,0,5,3],[5,4,5,5],[36,0,36,5],[37,0,37,7],[38,0,38,7],[39,0,39,7],[40,0,40,7],[4,7,5,7]]}
["SERVIÇOS ANÁLISE AMBIENTAL",{"$nulls":6},"CODIGO:"]
[{"$nulls":7},"PFP-1.3"]
["NOME DA EMPRESA:"]
[]
["PROJETO:",null,null,null,"CONTRATANTE:",null,null," EMBASA - 01/2024"]
[{"$f":"PFP!A6","v":"Estudos e Projeto Básico do Sistema Adutor de Serra Verde, no Estado do Rio Grande do Norte "},null,null,null,"12ª SR CODEVASF"]
["Cod.","Base","Insumos","Uni","Qde","Custo Unitário (CU)","Custo Total","Preço Total (PT)",null,null,"MEMÓRIA DE CALCULO DO BDI DE FORNECIMENTO"]
["33.01.02","EMBASA/COMPOSIÇÃO","Alcalinidade Total","un",3,null,{"$f":"E8*F8","v":0},{"$f":"G8*$M$29+G8","v":0}]
["33.01.10","EMBASA/COMPOSIÇÃO","Condutividade","un",3,null,{"$f":"E9*F9","v":0},{"$f":"G9*$M$29+G9","v":0},null,null,"ITEM","DISCRIMINAÇÃO","PERC.    (%)"]
["33.01.13","EMBASA/COMPOSIÇÃO","DBO","un",3,null,0,0]
["33.01.13","EMBASA/COMPOSIÇÃO","DQO","un",3,null,0,0]
["F099703031","EMBASA/INSUMO","Salinidade","un",3,null,0,0,null,null,"1.00","Despesas Indiretas"]
["F099703048","EMBASA/INSUMO","Sólidos Dissolvidos Totais","un",3,null,0,0,null,null,"A1","Seguro e Garantia"]
["33.02.71","EMBASA/COMPOSIÇÃO","Sólidos Suspensos","un",3,null,0,0,null,null,"A2","Riscos e Imprevistos"]
["33.01.48","EMBASA/COMPOSIÇÃO","Sólidos Totais","un",3,null,0,0,null,null,"A3","Despesas Financeiras"]
["33.01.51","EMBASA/COMPOSIÇÃO","Turbidez","un",3,null,0,0,null,null,"A4","Administração Central"]
["33.01.38","EMBASA/COMPOSIÇÃO","Oxigênio Dissolvido","un",3,null,0,0,null,null,"Total do Grupo A =",null,{"$f":"SUM(M13:M16)","v":0}]
["E200330139","EMBASA/INSUMO","pH","un",3,null,0,0,null,null,"2.00","Benefício"]
["F099703027","EMBASA/INSUMO","Temperatura","un",3,null,0,0,null,null,"B1","LUCRO"]
["F099703046","EMBASA/INSUMO","Fósforo Total","un",3,null,0,0,null,null,"Total do Grupo B =",null,{"$f":"M19","v":0}]
["E200330130","EMBASA/INSUMO","Nitrogênio Amoniacal","un",3,null,0,0,null,null,"3.00","Impostos"]
["E200330133","EMBASA/INSUMO","Nitrogênio Nitrato","un",3,null,0,0,null,null,"C1","PIS / PASEP"]
["E200330132","EMBASA/INSUMO","Nitrogênio Total","un",3,null,0,0,null,null,"C2","COFINS"]
["F099703058","EMBASA/INSUMO","Clorofila Alfa","un",3,null,0,0,null,null,"C3","ISS"]
["F099703057","EMBASA/INSUMO","Coliformes Termotolerantes","un",3,null,0,0,null,null,"Total do Grupo C =",null,{"$f":"SUM(M22:M24)","v":0}]
["F099703064","EMBASA/INSUMO","Metais Pesados - Alumínio","un",3,null,0,0,null,null,"Fórmula Para Cálculo do B.D.I"]
["F099703061","EMBASA/INSUMO","Metais Pesados - Arsênio","un",3,null,0,0,null,null,"BDI =(((1+A4+A1+A2)*(1+A3)*(1+B))/(1-C))-1"]
["F099703063","EMBASA/INSUMO","Metais Pesados - Bário","un",3,null,0,0]
["F099703068","EMBASA/INSUMO","Metais Pesados - Cadmio","un",3,null,0,0,null,null,"Bonificação Sobre Despesas indiretas (B.D.I) =",null,{"$f":"(((1+M16+M13+M14)*(1+M15)*(1+M20))/(1-M25))-1","v":0}]
["F099703066","EMBASA/INSUMO","Metais Pesados - Cromo","un",3,null,0,0]
["F099703062","EMBASA/INSUMO","Metais Pesados - Ferro","un",3,null,0,0]
["F099703065","EMBASA/INSUMO","Metais Pesados - Manganês","un",3,null,0,0]
["F099703069","EMBASA/INSUMO","Metais Pesados - Mercúrio","un",3,null,0,0]
["F099703067","EMBASA/INSUMO","Metais Pesados - Zinco","un",3,null,0,0]
["E200330140","EMBASA/INSUMO","Organoclorados","un",3,null,0,0]
["E200330140","EMBASA/INSUMO","Organofosforado","un",3,null,0,0]
["TOTAL SERVIÇOS GEOTÉCNICOS",{"$nulls":6},{"$f":"SUM(H8:H36)","v":0}]
["LEGENDA:"]
["Uni - unidade de medição do insumo;"]
["Qde - Quantidade do Insumo (não pode ocorrer alteração pela Licitante)"]
["CU - Custo Unitário "]
["PT - Preço Total (incluído encargos, taxas e impostos). Foi utilizado BDI de fornecimento de 14,69%"]

{"sheet":"CPU Veículo","index":4,"n_rows":61,"n_cols":32,"rows_kept":61,"cut":false,"hidden":false,"merged":[[52,19,52,26],[4,0,4,2],[6,0,6,2],[7,0,7,1],[7,4,7,7],[8,0,8,2],[52,8,52,18]]}
[]
[]
[]
[]
["Composição de Preços de Locação de Veículo tipo pick-up"]
[null,"Data de atualização:",null,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":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(E10:H10)","v":{"$error":"#DIV/0!"}},{"$f":"MEDIAN(E10:H10)","v":{"$error":"#NUM!"}},null,null,null,{"$f":"_xlfn.STDEV.S(L9:S9)/AVERAGE(L9:S9)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(L9:S9)","v":{"$error":"#DIV/0!"}},{"$f":"MEDIAN(L9:S9)","v":{"$error":"#NUM!"}},{"$nulls":8},{"$f":"_xlfn.STDEV.S(W9:AD9)/AVERAGE(W9:AD9)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(W9:AD9)","v":{"$error":"#DIV/0!"}},{"$f":"MEDIAN(W9:AD9)","v":{"$error":"#NUM!"}}]
["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,"Custo Mensal (R$):",{"$f":"C51","v":{"$error":"#DIV/0!"}}]
[null,"Custo Diária (R$):",{"$f":"C10/22","v":{"$error":"#DIV/0!"}}]
[null,"Custo Horário (R$):",{"$f":"C10/176","v":{"$error":"#DIV/0!"}}]
["A","Depreciação mensal do equipamento"]
["A1","Preço de Aquisição ",{"$f":"SMALL(F7:G7,1)","v":{"$error":"#DIV/0!"}}]
["A2","Tempo previsto de vida útil (meses)"]
["A3","Previsão de recup. Na venda do bem usado"]
["A4","Custo mensal [A1-(A3xA1)]/A2",{"$f":"(C14-(C16*C14))/C15","v":{"$error":"#DIV/0!"}}]
["B","Juros pelo Capital empregado"]
["B1","Taxa mensal de Juros *",{"$f":"POWER(1+C56,1/12)-1","v":0}]
["B2","Juros s/depreciação/aluguel (B1xA4)",{"$f":"C19*C17","v":{"$error":"#DIV/0!"}}]
["C","Conservação e manutenção **"]
["C1","Taxa de gastos s/a deprec. Inc. seguros (%)",{"$f":"C21","v":0},{"$nulls":28},"PREÇO DO DIESEL"]
["C2","Incidência mensal (C1xA4)",{"$f":"C22*C17","v":{"$error":"#DIV/0!"}}]
["D","Combustível"]
["D1","Média mensal de quilômetro por veículo"]
["D2","Preço do litro de combustível",{"$f":"AG22","v":0}]
["D3","Quilômetros rodados com um litro combustivel"]
["D4","Combustivel    (D1/D3)*D2",{"$f":"(C25/C27)*C26","v":{"$error":"#DIV/0!"}}]
["E","Lubrificantes"]
["E1","Quilometragem do Contrato (D1*12)",{"$f":"C25*36","v":0}]
["E2","Franquia por troca de óleo (km)"]
["E3","Preço do litro de óleo",{"$f":"K9","v":0}]
["E4","Quantidade de litros de óleo por troca"]
["E5","Quantidade de dias do Contrato"]
["E6","Lubrificantes  E = (E1*E3*E4*30)/E2*E5",{"$f":"(C30*C32*C33*30)/(C31*C34)","v":{"$error":"#DIV/0!"}}]
["F","Pneus"]
["F1","Quilometragem do Contrato ",{"$f":"C30","v":0}]
["F2","Vida do Pneu em quilômetros"]
["F3","Quantidade de pneus"]
["F4","Preço do Pneu",{"$f":"V9","v":0}]
["F5","Quantidade de dias do contrato ",{"$f":"C34","v":0}]
["F6","Pneus = (F1*F3*F4*30)/(F2*F5)",{"$f":"(C37*C39*C40*30)/(C38*C41)","v":{"$error":"#DIV/0!"}}]
["G","Motorista"]
["G1","Salário com encargos sociais"]
["H","Custo Mensal"," "]
[null,"Sem Motorista (A4+B2+C2+D4+E6+F6)",{"$f":"C17+C20+C23+C28+C35+C42","v":{"$error":"#DIV/0!"}}]
[null,"Com Motorista (A4+B2+C2+D4+E6+F6+G1)",{"$f":"C17+C20+C23+C28+C35+C42+C44","v":{"$error":"#DIV/0!"}}]
["I","Custo Direto p/ km Rodado"]
[null,"Sem Motorista",{"$f":"C46/C25","v":{"$error":"#DIV/0!"}}]
[null,"Com Motorista",{"$f":"C47/C25","v":{"$error":"#DIV/0!"}}]
["J","Preço cobrado sem BDI",{"$f":"C46*(1+C8)","v":{"$error":"#DIV/0!"}}]
["J1","Sem Motorista",{"$f":"C51","v":{"$error":"#DIV/0!"}}]
["J2","Com Motorista",{"$f":"C47","v":{"$error":"#DIV/0!"}}]
[]
[null,"OBSERVAÇÕES:"]
["*","Calculado com base na taxa SELIC JANEIRO/2024:"]
[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":"CPU Diária","index":5,"n_rows":19,"n_cols":3,"rows_kept":19,"cut":false,"hidden":false,"merged":[[2,1,2,2]]}
[]
[null,"Engenharia Consultiva da Codevasf"]
[null,"CPU - HOSPEDAGEM EQUIPE DE CAMPO (4 PESSOAS/MÊS)"]
[null,"ALUGUEL "]
[null," Aquisição de Mobiliário"]
[null,"Material de limpeza e diarista"]
[null,"manutenção da casa alugada - Serviços Gerais/Vigia "]
[null,"Energia "]
[null,"Água"]
[null,"telefone/Internet"]
[null,"IPTU (mês)"]
[null,"Despesas Gerais - 10%"]
[null,"Custo Mensal:",{"$f":"SUM(C4:C12)","v":0}]
[null,"Custo Mensal por pessoa:",{"$f":"C13/C16","v":{"$error":"#DIV/0!"}}]
[null,"Custo diário por pessoa:",{"$f":"C14/22","v":{"$error":"#DIV/0!"}}]
[null,"número de pessoas:"]
[null,"Alimentação:"]
[]
[null,"Diária Total (alimentação + hospedagem):",{"$f":"C15+C17","v":{"$error":"#DIV/0!"}}]

{"sheet":"PFP2.1_FatorKa","index":6,"n_rows":41,"n_cols":6,"rows_kept":41,"cut":false,"hidden":false,"merged":[[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],[16,1,16,3],[9,1,9,3],[10,1,10,3],[11,1,11,3],[12,1,12,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],[6,1,6,3],[32,1,32,3],[34,1,34,3],[35,1,35,3],[18,1,18,3],[19,1,19,3],[20,1,20,3],[21,1,21,3],[23,1,23,3],[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]]}
["DETALHAMENTO DOS ENCARGOS SOCIAIS: Ka",{"$nulls":4},"CODIGO:"]
[{"$nulls":5},"PFP-2.1"]
["NOME DA CONSULTORA:"]
[]
["PROJETO:",null,"CONTRATANTE:",null,null,"Data base: SINAPI dez/2023"]
[{"$f":"PFP!A6","v":"Estudos e Projeto Básico do Sistema Adutor de Serra Verde, no Estado do Rio Grande do Norte "},null,"12ª SR CODEVASF"]
["Cod","DESCRIÇÃO",null,null,"%","R$"]
["A","ENCARGOS SOCIAIS BÁSICOS",null,null,{"$f":"ROUND(SUM(E9:E17),4)","v":0},{"$f":"ROUND(E8*SUMIF(PFP!$B$8:$B$21,\"MO1\",PFP!$J$8:$J$21),2)","v":0}]
["A1","INSS",null,null,null,{"$f":"ROUND(E9*SUMIF(PFP!$B$8:$B$21,\"MO1\",PFP!$J$8:$J$21),2)","v":0}]
["A2","SESI",null,null,null,{"$f":"ROUND(E10*SUMIF(PFP!$B$8:$B$21,\"MO1\",PFP!$J$8:$J$21),2)","v":0}]
["A3","SENAI",null,null,null,{"$f":"ROUND(E11*SUMIF(PFP!$B$8:$B$21,\"MO1\",PFP!$J$8:$J$21),2)","v":0}]
["A4","INCRA",null,null,null,{"$f":"ROUND(E12*SUMIF(PFP!$B$8:$B$21,\"MO1\",PFP!$J$8:$J$21),2)","v":0}]
["A5","SEBRAE",null,null,null,{"$f":"ROUND(E13*SUMIF(PFP!$B$8:$B$21,\"MO1\",PFP!$J$8:$J$21),2)","v":0}]
["A6","Salário Educação",null,null,null,{"$f":"ROUND(E14*SUMIF(PFP!$B$8:$B$21,\"MO1\",PFP!$J$8:$J$21),2)","v":0}]
["A7","Seguro Contra Acidentes de Trabalho",null,null,null,{"$f":"ROUND(E15*SUMIF(PFP!$B$8:$B$21,\"MO1\",PFP!$J$8:$J$21),2)","v":0}]
["A8","FGTS",null,null,null,{"$f":"ROUND(E16*SUMIF(PFP!$B$8:$B$21,\"MO1\",PFP!$J$8:$J$21),2)","v":0}]
["A9","SECONCI",null,null,null,{"$f":"ROUND(E17*SUMIF(PFP!$B$8:$B$21,\"MO1\",PFP!$J$8:$J$21),2)","v":0}]
["B"," ENCARGOS SOCIAIS QUE RECEBEM INCIDÊNCIA DE \"A\"",null,null,{"$f":"ROUND(SUM(E19:E25),4)","v":0},{"$f":"ROUND(E18*SUMIF(PFP!$B$8:$B$21,\"MO1\",PFP!$J$8:$J$21),2)","v":0}]
["B3","Auxílio Enfermidade",null,null,null,{"$f":"ROUND(E19*SUMIF(PFP!$B$8:$B$21,\"MO1\",PFP!$J$8:$J$21),2)","v":0}]
["B4","13º Salário",null,null,null,{"$f":"ROUND(E20*SUMIF(PFP!$B$8:$B$21,\"MO1\",PFP!$J$8:$J$21),2)","v":0}]
["B5","Licença Paternidade",null,null,null,{"$f":"ROUND(E21*SUMIF(PFP!$B$8:$B$21,\"MO1\",PFP!$J$8:$J$21),2)","v":0}]
["B6","Faltas Justificadas",null,null,null,{"$f":"ROUND(E22*SUMIF(PFP!$B$8:$B$21,\"MO1\",PFP!$J$8:$J$21),2)","v":0}]
["B8","Auxílio Acidente de Trabalho",null,null,null,{"$f":"ROUND(E23*SUMIF(PFP!$B$8:$B$21,\"MO1\",PFP!$J$8:$J$21),2)","v":0}]
["B9","Férias Gozadas",null,null,null,{"$f":"ROUND(E24*SUMIF(PFP!$B$8:$B$21,\"MO1\",PFP!$J$8:$J$21),2)","v":0}]
["B10","Salário Maternidade",null,null,null,{"$f":"ROUND(E25*SUMIF(PFP!$B$8:$B$21,\"MO1\",PFP!$J$8:$J$21),2)","v":0}]
["C"," ENCARGOS SOCIAIS QUE NÃO RECEBEM INCIDÊNCIA DE \"A\"",null,null,{"$f":"ROUND(SUM(E27:E31),4)","v":0},{"$f":"ROUND(E26*SUMIF(PFP!$B$8:$B$21,\"MO1\",PFP!$J$8:$J$21),2)","v":0}]
["C1","Aviso Prévio Indenizado",null,null,null,{"$f":"ROUND(E27*SUMIF(PFP!$B$8:$B$21,\"MO1\",PFP!$J$8:$J$21),2)","v":0}]
["C2","Aviso Prévio Trabalhado",null,null,null,{"$f":"ROUND(E28*SUMIF(PFP!$B$8:$B$21,\"MO1\",PFP!$J$8:$J$21),2)","v":0}]
["C3","Férias Indenizadas",null,null,null,{"$f":"ROUND(E29*SUMIF(PFP!$B$8:$B$21,\"MO1\",PFP!$J$8:$J$21),2)","v":0}]
["C4","Depósito Rescisão Sem Justa Causa",null,null,null,{"$f":"ROUND(E30*SUMIF(PFP!$B$8:$B$21,\"MO1\",PFP!$J$8:$J$21),2)","v":0}]
["C5","Indenização Adicional",null,null,null,{"$f":"ROUND(E31*SUMIF(PFP!$B$8:$B$21,\"MO1\",PFP!$J$8:$J$21),2)","v":0}]
["D"," REINCIDÊNCIAS",null,null,{"$f":"ROUND(SUM(E33:E34),4)","v":0},{"$f":"ROUND(E32*SUMIF(PFP!$B$8:$B$21,\"MO1\",PFP!$J$8:$J$21),2)","v":0}]
["D1","Reincidência de \"A\" sobre \"B\"",null,null,{"$f":"ROUND(E8*E18,4)","v":0},{"$f":"ROUND(E33*SUMIF(PFP!$B$8:$B$21,\"MO1\",PFP!$J$8:$J$21),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((E28*E8)+(E27*E16),4)","v":0},{"$f":"ROUND(E34*SUMIF(PFP!$B$8:$B$21,\"MO1\",PFP!$J$8:$J$21),2)","v":0}]
["K1a","ENCARGOS SOCIAIS",null,null,{"$f":"ROUND(E8+E18+E26+E32,4)","v":0},{"$f":"ROUND(E35*SUMIF(PFP!$B$8:$B$21,\"MO1\",PFP!$J$8:$J$21),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":1}]
["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":7,"n_rows":41,"n_cols":6,"rows_kept":41,"cut":false,"hidden":false,"merged":[[13,1,13,3],[14,1,14,3],[15,1,15,3],[11,1,11,3],[31,1,31,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],[28,1,28,3],[29,1,29,3],[30,1,30,3],[40,0,40,5],[37,0,37,5],[38,0,38,5],[39,0,39,5],[32,1,32,3],[33,1,33,3],[34,1,34,3],[35,1,35,3],[19,1,19,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],[17,1,17,3],[18,1,18,3],[8,1,8,3],[9,1,9,3],[10,1,10,3],[16,1,16,3],[6,1,6,3],[12,1,12,3]]}
["DETALHAMENTO DOS ENCARGOS SOCIAIS: Kb",{"$nulls":4},"CODIGO:"]
[{"$nulls":5},"PFP-2.2"]
["NOME DA CONSULTORA:"]
[]
["PROJETO:",null,"CONTRATANTE:",null,null,"Data base: SINAPI dez/2023"]
[{"$f":"PFP!A6","v":"Estudos e Projeto Básico do Sistema Adutor de Serra Verde, no Estado do Rio Grande do Norte "},null,"12ª SR CODEVASF"]
["Cod","DESCRIÇÃO",null,null,"%","R$"]
["A","ENCARGOS SOCIAIS BÁSICOS",null,null,{"$f":"ROUND(SUM(E9:E17),4)","v":0},{"$f":"ROUND(E8*SUMIF(PFP!$B$8:$B$21,\"MO2\",PFP!$J$8:$J$21),2)","v":0}]
["A1","INSS",null,null,null,{"$f":"ROUND(E9*SUMIF(PFP!$B$8:$B$21,\"MO2\",PFP!$J$8:$J$21),2)","v":0}]
["A2","SESI",null,null,null,{"$f":"ROUND(E10*SUMIF(PFP!$B$8:$B$21,\"MO2\",PFP!$J$8:$J$21),2)","v":0}]
["A3","SENAI",null,null,null,{"$f":"ROUND(E11*SUMIF(PFP!$B$8:$B$21,\"MO2\",PFP!$J$8:$J$21),2)","v":0}]
["A4","INCRA",null,null,null,{"$f":"ROUND(E12*SUMIF(PFP!$B$8:$B$21,\"MO2\",PFP!$J$8:$J$21),2)","v":0}]
["A5","SEBRAE",null,null,null,{"$f":"ROUND(E13*SUMIF(PFP!$B$8:$B$21,\"MO2\",PFP!$J$8:$J$21),2)","v":0}]
["A6","Salário Educação",null,null,null,{"$f":"ROUND(E14*SUMIF(PFP!$B$8:$B$21,\"MO2\",PFP!$J$8:$J$21),2)","v":0}]
["A7","Seguro Contra Acidentes de Trabalho",null,null,null,{"$f":"ROUND(E15*SUMIF(PFP!$B$8:$B$21,\"MO2\",PFP!$J$8:$J$21),2)","v":0}]
["A8","FGTS",null,null,null,{"$f":"ROUND(E16*SUMIF(PFP!$B$8:$B$21,\"MO2\",PFP!$J$8:$J$21),2)","v":0}]
["A9","SECONCI",null,null,null,{"$f":"ROUND(E17*SUMIF(PFP!$B$8:$B$21,\"MO2\",PFP!$J$8:$J$21),2)","v":0}]
["B"," ENCARGOS SOCIAIS QUE RECEBEM INCIDÊNCIA DE \"A\"",null,null,{"$f":"ROUND(SUM(E19:E25),4)","v":0},{"$f":"ROUND(E18*SUMIF(PFP!$B$8:$B$21,\"MO2\",PFP!$J$8:$J$21),2)","v":0}]
["B3","Auxílio Enfermidade",null,null,null,{"$f":"ROUND(E19*SUMIF(PFP!$B$8:$B$21,\"MO2\",PFP!$J$8:$J$21),2)","v":0}]
["B4","13º Salário",null,null,null,{"$f":"ROUND(E20*SUMIF(PFP!$B$8:$B$21,\"MO2\",PFP!$J$8:$J$21),2)","v":0}]
["B5","Licença Paternidade",null,null,null,{"$f":"ROUND(E21*SUMIF(PFP!$B$8:$B$21,\"MO2\",PFP!$J$8:$J$21),2)","v":0}]
["B6","Faltas Justificadas",null,null,null,{"$f":"ROUND(E22*SUMIF(PFP!$B$8:$B$21,\"MO2\",PFP!$J$8:$J$21),2)","v":0}]
["B8","Auxílio Acidente de Trabalho",null,null,null,{"$f":"ROUND(E23*SUMIF(PFP!$B$8:$B$21,\"MO2\",PFP!$J$8:$J$21),2)","v":0}]
["B9","Férias Gozadas",null,null,null,{"$f":"ROUND(E24*SUMIF(PFP!$B$8:$B$21,\"MO2\",PFP!$J$8:$J$21),2)","v":0}]
["B10","Salário Maternidade",null,null,null,{"$f":"ROUND(E25*SUMIF(PFP!$B$8:$B$21,\"MO2\",PFP!$J$8:$J$21),2)","v":0}]
["C"," ENCARGOS SOCIAIS QUE NÃO RECEBEM INCIDÊNCIA DE \"A\"",null,null,{"$f":"ROUND(SUM(E27:E31),4)","v":0},{"$f":"ROUND(E26*SUMIF(PFP!$B$8:$B$21,\"MO2\",PFP!$J$8:$J$21),2)","v":0}]
["C1","Aviso Prévio Indenizado",null,null,null,{"$f":"ROUND(E27*SUMIF(PFP!$B$8:$B$21,\"MO2\",PFP!$J$8:$J$21),2)","v":0}]
["C2","Aviso Prévio Trabalhado",null,null,null,{"$f":"ROUND(E28*SUMIF(PFP!$B$8:$B$21,\"MO2\",PFP!$J$8:$J$21),2)","v":0}]
["C3","Férias Indenizadas",null,null,null,{"$f":"ROUND(E29*SUMIF(PFP!$B$8:$B$21,\"MO2\",PFP!$J$8:$J$21),2)","v":0}]
["C4","Depósito Rescisão Sem Justa Causa",null,null,null,{"$f":"ROUND(E30*SUMIF(PFP!$B$8:$B$21,\"MO2\",PFP!$J$8:$J$21),2)","v":0}]
["C5","Indenização Adicional",null,null,null,{"$f":"ROUND(E31*SUMIF(PFP!$B$8:$B$21,\"MO2\",PFP!$J$8:$J$21),2)","v":0}]
["D"," REINCIDÊNCIAS",null,null,{"$f":"ROUND(SUM(E33:E34),4)","v":0},{"$f":"ROUND(E32*SUMIF(PFP!$B$8:$B$21,\"MO2\",PFP!$J$8:$J$21),2)","v":0}]
["D1","Reincidência de \"A\" sobre \"B\"",null,null,{"$f":"ROUND(E8*E18,4)","v":0},{"$f":"ROUND(E33*SUMIF(PFP!$B$8:$B$21,\"MO2\",PFP!$J$8:$J$21),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*E28,4)+ROUND(E27*E11,4)","v":0},{"$f":"ROUND(E34*SUMIF(PFP!$B$8:$B$21,\"MO2\",PFP!$J$8:$J$21),2)","v":0}]
["K1b","ENCARGOS SOCIAIS",null,null,{"$f":"ROUND(E8+E18+E26+E32,4)","v":0},{"$f":"ROUND(E35*SUMIF(PFP!$B$8:$B$21,\"MO2\",PFP!$J$8:$J$21),2)","v":0}]
["Kb","TAXA DE RESSARCIMENTO DE DESPESAS E ENCARGOS SOBRE MO2",null,null,{"$f":"ROUND((1+E35+PFP3_FatorKd!E13)*(1+PFP3_FatorKd!E12)*(1+PFP3_FatorKd!E8),4)","v":1}]
["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":8,"n_rows":41,"n_cols":6,"rows_kept":41,"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],[17,1,17,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],[16,1,16,3],[29,1,29,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],[28,1,28,3],[37,0,37,5],[38,0,38,5],[39,0,39,5],[40,0,40,5],[30,1,30,3],[31,1,31,3],[32,1,32,3],[33,1,33,3],[34,1,34,3],[35,1,35,3]]}
["DETALHAMENTO DOS ENCARGOS SOCIAIS: Kc",{"$nulls":4},"CODIGO:"]
[{"$nulls":5},"PFP-2.3"]
["NOME DA CONSULTORA:"]
[]
["PROJETO:",null,"CONTRATANTE:",null,null,"Data base: SINAPI dez/2023"]
[{"$f":"PFP!A6","v":"Estudos e Projeto Básico do Sistema Adutor de Serra Verde, no Estado do Rio Grande do Norte "},null,"12ª SR CODEVASF"]
["Cod","DESCRIÇÃO",null,null,"%","R$"]
["A","ENCARGOS SOCIAIS BÁSICOS",null,null,{"$f":"SUM(E9:E17)","v":0},{"$f":"ROUND(E8*SUMIF(PFP!$B$8:$B$21,\"MO3\",PFP!$J$8:$J$21),2)","v":0}]
["A1","INSS",null,null,null,{"$f":"ROUND(E9*SUMIF(PFP!$B$8:$B$21,\"MO3\",PFP!$J$8:$J$21),2)","v":0}]
["A2","SESI",null,null,null,{"$f":"ROUND(E10*SUMIF(PFP!$B$8:$B$21,\"MO3\",PFP!$J$8:$J$21),2)","v":0}]
["A3","SENAI",null,null,null,{"$f":"ROUND(E11*SUMIF(PFP!$B$8:$B$21,\"MO3\",PFP!$J$8:$J$21),2)","v":0}]
["A4","INCRA",null,null,null,{"$f":"ROUND(E12*SUMIF(PFP!$B$8:$B$21,\"MO3\",PFP!$J$8:$J$21),2)","v":0}]
["A5","SEBRAE",null,null,null,{"$f":"ROUND(E13*SUMIF(PFP!$B$8:$B$21,\"MO3\",PFP!$J$8:$J$21),2)","v":0}]
["A6","Salário Educação",null,null,null,{"$f":"ROUND(E14*SUMIF(PFP!$B$8:$B$21,\"MO3\",PFP!$J$8:$J$21),2)","v":0}]
["A7","Seguro Contra Acidentes de Trabalho",null,null,null,{"$f":"ROUND(E15*SUMIF(PFP!$B$8:$B$21,\"MO3\",PFP!$J$8:$J$21),2)","v":0}]
["A8","FGTS",null,null,null,{"$f":"ROUND(E16*SUMIF(PFP!$B$8:$B$21,\"MO3\",PFP!$J$8:$J$21),2)","v":0}]
["A9","SECONCI",null,null,null,{"$f":"ROUND(E17*SUMIF(PFP!$B$8:$B$21,\"MO3\",PFP!$J$8:$J$21),2)","v":0}]
["B"," ENCARGOS SOCIAIS QUE RECEBEM INCIDÊNCIA DE \"A\"",null,null,{"$f":"ROUND(SUM(E19:E25),4)","v":0},{"$f":"ROUND(E18*SUMIF(PFP!$B$8:$B$21,\"MO3\",PFP!$J$8:$J$21),2)","v":0}]
["B3","Auxílio Enfermidade",null,null,null,{"$f":"ROUND(E19*SUMIF(PFP!$B$8:$B$21,\"MO3\",PFP!$J$8:$J$21),2)","v":0}]
["B4","13º Salário",null,null,null,{"$f":"ROUND(E20*SUMIF(PFP!$B$8:$B$21,\"MO3\",PFP!$J$8:$J$21),2)","v":0}]
["B5","Licença Paternidade",null,null,null,{"$f":"ROUND(E21*SUMIF(PFP!$B$8:$B$21,\"MO3\",PFP!$J$8:$J$21),2)","v":0}]
["B6","Faltas Justificadas",null,null,null,{"$f":"ROUND(E22*SUMIF(PFP!$B$8:$B$21,\"MO3\",PFP!$J$8:$J$21),2)","v":0}]
["B8","Auxílio Acidente de Trabalho",null,null,null,{"$f":"ROUND(E23*SUMIF(PFP!$B$8:$B$21,\"MO3\",PFP!$J$8:$J$21),2)","v":0}]
["B9","Férias Gozadas",null,null,null,{"$f":"ROUND(E24*SUMIF(PFP!$B$8:$B$21,\"MO3\",PFP!$J$8:$J$21),2)","v":0}]
["B10","Salário Maternidade",null,null,null,{"$f":"ROUND(E25*SUMIF(PFP!$B$8:$B$21,\"MO3\",PFP!$J$8:$J$21),2)","v":0}]
["C"," ENCARGOS SOCIAIS QUE NÃO RECEBEM INCIDÊNCIA DE \"A\"",null,null,{"$f":"ROUND(SUM(E27:E31),4)","v":0},{"$f":"ROUND(E26*SUMIF(PFP!$B$8:$B$21,\"MO3\",PFP!$J$8:$J$21),2)","v":0}]
["C1","Aviso Prévio Indenizado",null,null,null,{"$f":"ROUND(E27*SUMIF(PFP!$B$8:$B$21,\"MO3\",PFP!$J$8:$J$21),2)","v":0}]
["C2","Aviso Prévio Trabalhado",null,null,null,{"$f":"ROUND(E28*SUMIF(PFP!$B$8:$B$21,\"MO3\",PFP!$J$8:$J$21),2)","v":0}]
["C3","Férias Indenizadas",null,null,null,{"$f":"ROUND(E29*SUMIF(PFP!$B$8:$B$21,\"MO3\",PFP!$J$8:$J$21),2)","v":0}]
["C4","Depósito Rescisão Sem Justa Causa",null,null,null,{"$f":"ROUND(E30*SUMIF(PFP!$B$8:$B$21,\"MO3\",PFP!$J$8:$J$21),2)","v":0}]
["C5","Indenização Adicional",null,null,null,{"$f":"ROUND(E31*SUMIF(PFP!$B$8:$B$21,\"MO3\",PFP!$J$8:$J$21),2)","v":0}]
["D"," REINCIDÊNCIAS",null,null,{"$f":"ROUND(SUM(E33:E34),4)","v":0},{"$f":"ROUND(E32*SUMIF(PFP!$B$8:$B$21,\"MO3\",PFP!$J$8:$J$21),2)","v":0}]
["D1","Reincidência de \"A\" sobre \"B\"",null,null,{"$f":"ROUND(E8*E18,4)","v":0},{"$f":"ROUND(E33*SUMIF(PFP!$B$8:$B$21,\"MO3\",PFP!$J$8:$J$21),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*E28,4)+ROUND(E27*E11,4)","v":0},{"$f":"ROUND(E34*SUMIF(PFP!$B$8:$B$21,\"MO3\",PFP!$J$8:$J$21),2)","v":0}]
["K1c","ENCARGOS SOCIAIS",null,null,{"$f":"ROUND(E8+E18+E26+E32,4)","v":0},{"$f":"ROUND(E35*SUMIF(PFP!$B$8:$B$21,\"MO3\",PFP!$J$8:$J$21),2)","v":0}]
["Kc","TAXA DE RESSARCIMENTO DE DESPESAS E ENCARGOS SOBRE MO3",null,null,{"$f":"ROUND((1+E35+PFP3_FatorKd!E13)*(1+PFP3_FatorKd!E12)*(1+PFP3_FatorKd!E8),4)","v":1}]
["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":9,"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,"Data base: SINAPI dez/2023"]
[{"$f":"PFP!A6","v":"Estudos e Projeto Básico do Sistema Adutor de Serra Verde, no Estado do Rio Grande do Norte "},null,"12ª SR CODEVASF"]
["Cod","DESCRIÇÃO1",null,"% preço2","% custo4"]
["K4","TRIBUTOS",null,{"$f":"ROUND(D9+D10+D11,4)","v":0},{"$f":"ROUND(E9+E10+E11,4)","v":0},{"$f":"E8*SUM(SUMIF(PFP!$B$8:$B$25,\"MO1\",PFP!$K$8:$K$25)*(1+'PFP2.1_FatorKa'!$E$35)+SUMIF(PFP!$B$8:$B$25,\"MO2\",PFP!$K$8:$K$25)*(1+'PFP2.2_FatorKb'!$E$35)+SUMIF(PFP!$B$8:$B$25,\"<>MO*\",PFP!$K$8:$K$25)+$F$13+$F$12)","v":{"$error":"#DIV/0!"}}]
["K4.1","ISS",null,null,{"$f":"ROUND((1/(1-$D$8))*D9,4)","v":0},{"$f":"E9*SUM(SUMIF(PFP!$B$8:$B$25,\"MO1\",PFP!$K$8:$K$25)*(1+'PFP2.1_FatorKa'!$E$35)+SUMIF(PFP!$B$8:$B$25,\"MO2\",PFP!$K$8:$K$25)*(1+'PFP2.2_FatorKb'!$E$35)+SUMIF(PFP!$B$8:$B$25,\"<>MO*\",PFP!$K$8:$K$25)+$F$13+$F$12)","v":{"$error":"#DIV/0!"}}]
["K4.2","PIS3 - aliquota efetiva aplicavel percentual-desconto",null,null,{"$f":"ROUND((1/(1-$D$8))*D10,4)","v":0},{"$f":"E10*SUM(SUMIF(PFP!$B$8:$B$25,\"MO1\",PFP!$K$8:$K$25)*(1+'PFP2.1_FatorKa'!$E$35)+SUMIF(PFP!$B$8:$B$25,\"MO2\",PFP!$K$8:$K$25)*(1+'PFP2.2_FatorKb'!$E$35)+SUMIF(PFP!$B$8:$B$25,\"<>MO*\",PFP!$K$8:$K$25)+$F$13+$F$12)","v":{"$error":"#DIV/0!"}}]
["K4.3","COFINS3 - aliquota efetiva aplicavel percentual-desconto",null,null,{"$f":"ROUND((1/(1-$D$8))*D11,4)","v":0},{"$f":"E11*SUM(SUMIF(PFP!$B$8:$B$25,\"MO1\",PFP!$K$8:$K$25)*(1+'PFP2.1_FatorKa'!$E$35)+SUMIF(PFP!$B$8:$B$25,\"MO2\",PFP!$K$8:$K$25)*(1+'PFP2.2_FatorKb'!$E$35)+SUMIF(PFP!$B$8:$B$25,\"<>MO*\",PFP!$K$8:$K$25)+$F$13+$F$12)","v":{"$error":"#DIV/0!"}}]
["K3","REMUNERAÇÃO DA EMPRESA (LUCRO)",null,null,null,{"$f":"E12*SUM(SUMIF(PFP!$B$8:$B$21,\"MO1\",PFP!$J$8:$J$21)*(1+'PFP2.1_FatorKa'!$E$35)+SUMIF(PFP!$B$8:$B$21,\"MO2\",PFP!$J$8:$J$21)*(1+'PFP2.2_FatorKb'!$E$35)+SUMIF(PFP!$B$8:$B$21,\"<>MO*\",PFP!$J$8:$J$21)+$F$13)","v":{"$error":"#DIV/0!"}}]
["K2","CUSTOS DA ADMINISTRAÇÃO CENTRAL",null,null,null,{"$f":"ROUND(E13*SUMIF(PFP!$B$8:$B$21,\"MO*\",PFP!$J$8:$J$21),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,null,{"$f":"ROUND(E14*SUMIF(PFP!$B$8:$B$21,\"MO*\",PFP!$J$8:$J$21),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,null,{"$f":"ROUND(E15*SUMIF(PFP!$B$8:$B$21,\"MO*\",PFP!$J$8:$J$21),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,null,{"$f":"ROUND(E16*SUMIF(PFP!$B$8:$B$21,\"MO*\",PFP!$J$8:$J$21),2)","v":0}]
["Kd","TAXA RESSARCIMENTO DE DESPESAS SOBRE CUSTOS DIVERSOS",null,null,{"$f":"ROUND((1+E12)*(1+E8),4)","v":1}]
["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 ) ] - 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":10,"n_rows":23,"n_cols":11,"rows_kept":23,"cut":false,"hidden":false,"merged":[[38,7,38,10],[19,0,20,0],[19,1,20,1],[21,0,22,0],[0,0,1,7],[1,8,1,10]]}
["INSUMOS POR ETAPA/PRODUTO",{"$nulls":7},"CODIGO:"]
[{"$nulls":8},"CRO-1"]
["Cod.","Categoria / Insumo","Uni","Qde","CUD","PU","FatorK","EB","EVTEA","EA","PB"]
[{"$nulls":6},"Meses",2,2,1,2]
[{"$f":"PFP!C8","v":"P0"},{"$f":"PFP!D8","v":"Engenheiro coordenador (P8061)"},"mês",3,{"$f":"PFP!G8","v":0},{"$f":"PFP!H8","v":0},{"$f":"PFP!I8","v":1},0.5,1,0.5,1]
[{"$f":"PFP!C10","v":"P2"},{"$f":"PFP!D9","v":"Engenheiro de projeto pleno - Civil/Sanitarista (P8066)"},"mês",5,{"$f":"PFP!G9","v":0},{"$f":"PFP!H9","v":0},{"$f":"PFP!I9","v":1},1,1.5,1,1.5]
["P2",{"$f":"PFP!D10","v":"Engenheiro ambiental pleno (P8058)"},"mês",3,{"$f":"PFP!G10","v":0},{"$f":"PFP!H10","v":0},{"$f":"PFP!I10","v":1},0.5,1,1,0.5]
["P2",{"$f":"PFP!D11","v":"Engenheiro pleno - demais esp. (P8066)"},"mês",2,{"$f":"PFP!G11","v":0},{"$f":"PFP!H11","v":0},{"$f":"PFP!I11","v":1},0.5,0.5,0,1]
[{"$f":"PFP!C12","v":"T1"},{"$f":"PFP!D12","v":"Técnico de projetos/obra (P8147)"},"mês",7,{"$f":"PFP!G12","v":0},{"$f":"PFP!H12","v":0},{"$f":"PFP!I12","v":1},2,2,1,2]
["A1","Auxiliar administrativo","mês",7,{"$f":"PFP!G13","v":0},{"$f":"PFP!H13","v":0},{"$f":"PFP!I13","v":1},2,2,1,2]
[{"$f":"PFP!C14","v":"ECA"},{"$f":"PFP!D14","v":"Encargos Comp. e Adicionais"},"mês",{"$f":"SUM(H11:K11)","v":27},{"$f":"PFP!G14","v":0},{"$f":"PFP!H14","v":0},{"$f":"PFP!I14","v":1},{"$f":"SUM(H5:H10)","v":6.5},{"$f":"SUM(I5:I10)","v":8},{"$f":"SUM(J5:J10)","v":4.5},{"$f":"SUM(K5:K10)","v":8}]
[{"$f":"PFP!C15","v":"V1"},{"$f":"PFP!D15","v":"Diárias"},"dia",{"$f":"SUM(H12:K12)","v":70},{"$f":"PFP!G15","v":{"$error":"#DIV/0!"}},{"$f":"PFP!H15","v":{"$error":"#DIV/0!"}},{"$f":"PFP!I15","v":1},{"$f":"H4*5*2","v":20},{"$f":"I4*5*2","v":20},{"$f":"J4*5*2","v":10},{"$f":"K4*5*2","v":20}]
[{"$f":"PFP!C16","v":"V2"},{"$f":"PFP!D16","v":"Pick-up cabine dupla "},"dia",70,{"$f":"PFP!G16","v":{"$error":"#DIV/0!"}},{"$f":"PFP!H16","v":{"$error":"#DIV/0!"}},{"$f":"PFP!I16","v":1},20,20,10,20]
[{"$f":"PFP!C17","v":"V3"},{"$f":"PFP!D17","v":"Passagens Aéreas (ida e volta)"},"un",3,{"$f":"PFP!G17","v":{"$error":"#REF!"}},{"$f":"PFP!H17","v":{"$error":"#REF!"}},{"$f":"PFP!I17","v":1},1,1,0,1]
[{"$f":"PFP!C18","v":"M1"},{"$f":"PFP!D18","v":"Relatório Parcial"},"un",14,{"$f":"PFP!G18","v":0},{"$f":"PFP!H18","v":0},{"$f":"PFP!I18","v":1},3,5,1,5]
[{"$f":"PFP!C19","v":"M2"},{"$f":"PFP!D19","v":"Relatório Final"},"un",4,{"$f":"PFP!G19","v":0},{"$f":"PFP!H19","v":0},{"$f":"PFP!I19","v":1},1,1,1,1]
[{"$f":"PFP!C20","v":"TOP"},{"$f":"PFP!D20","v":"Total Serviços Cartográficos"},"un",1,{"$f":"PFP!G20","v":"-"},{"$f":"PFP!H20","v":0},{"$f":"PFP!I20","v":"-"},1]
[{"$f":"PFP!C21","v":"GEO"},{"$f":"PFP!D21","v":"Total Serviços Geotécnicos"},"un",1,{"$f":"PFP!G21","v":"-"},{"$f":"PFP!H21","v":0},{"$f":"PFP!I21","v":"-"},1]
[{"$f":"PFP!C22","v":"AMB"},{"$f":"PFP!D22","v":"Total Serviços Ambientais"},"un",1,{"$f":"PFP!G22","v":"-"},{"$f":"PFP!H22","v":0},{"$f":"PFP!I22","v":"-"},1]
["TOTAL","VALOR TOTAL POR PRODUTO","R$",{"$error":"#DIV/0!"},null,null,null,{"$f":"SUM(H5:H19*$F$5:$F$19)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(I5:I19*$F$5:$F$19)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(J5:J19*$F$5:$F$19)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(K5:K19*$F$5:$F$19)","v":{"$error":"#DIV/0!"}}]
[null,null,"%",{"$error":"#DIV/0!"},null,null,null,{"$f":"ROUND(H20/$D$20,5)","v":{"$error":"#DIV/0!"}},{"$f":"ROUND(I20/$D$20,5)","v":{"$error":"#DIV/0!"}},{"$f":"ROUND(J20/$D$20,5)","v":{"$error":"#DIV/0!"}},{"$f":"ROUND(K20/$D$20,5)","v":{"$error":"#DIV/0!"}}]
["TOTAL","VALOR DOS SUBPRODUTOS","R$",{"$error":"#DIV/0!"},null,null,null,{"$f":"H20*0.8","v":{"$error":"#DIV/0!"}},{"$f":"I20*0.8","v":{"$error":"#DIV/0!"}},{"$f":"J20*0.8","v":{"$error":"#DIV/0!"}},{"$f":"K20*0.8","v":{"$error":"#DIV/0!"}}]
[null,"VALOR DO PRODUTO CONSOLIDADO","R$",{"$error":"#DIV/0!"},null,null,null,{"$f":"H20*0.2","v":{"$error":"#DIV/0!"}},{"$f":"I20*0.2","v":{"$error":"#DIV/0!"}},{"$f":"J20*0.2","v":{"$error":"#DIV/0!"}},{"$f":"K20*0.2","v":{"$error":"#DIV/0!"}}]

{"sheet":"CRO2_Pro-Mes","index":11,"n_rows":21,"n_cols":16383,"rows_kept":21,"cut":false,"hidden":false,"merged":[[17,0,18,1],[19,0,20,1],[11,1,13,1],[11,0,13,0],[14,1,16,1],[14,0,16,0],[8,0,10,0],[8,1,10,1],[0,0,0,9],[2,0,4,0],[2,1,4,1],[5,0,7,0],[5,1,7,1]]}
["CRONOGRAMA FÍSICO-FINANCEIRO"]
["Cod1","Produto/ Mês",1,2,3,4,5,6,7,"Total/Produto",{"$nulls":16371},"Valor","%"]
["EVTEA","Estudo de Viabilidade",null,1,1,{"$nulls":4},{"$f":"SUM(C3:I3)","v":2},{"$nulls":16371},{"$f":"'CRO1_Ins-Pro'!I20","v":{"$error":"#DIV/0!"}},{"$f":"XFB3/$J$19","v":{"$error":"#DIV/0!"}}]
[null,null,null,{"$f":"D5/XFB3","v":{"$error":"#DIV/0!"}},{"$f":"E5/XFB3","v":{"$error":"#DIV/0!"}},{"$nulls":4},{"$f":"SUM(C4:I4)","v":{"$error":"#DIV/0!"}}]
[null,null,null,{"$f":"XFB3/2","v":{"$error":"#DIV/0!"}},{"$f":"XFB3/2","v":{"$error":"#DIV/0!"}},{"$nulls":4},{"$f":"SUM(C5:I5)","v":{"$error":"#DIV/0!"}}]
["EB","Estudos Básicos",1,1,{"$nulls":5},{"$f":"SUM(C6:I6)","v":2},{"$nulls":16371},{"$f":"'CRO1_Ins-Pro'!H20","v":{"$error":"#DIV/0!"}},{"$f":"XFB6/$J$19","v":{"$error":"#DIV/0!"}}]
[null,null,{"$f":"C8/XFB6","v":{"$error":"#DIV/0!"}},{"$f":"D8/XFB6","v":{"$error":"#DIV/0!"}},{"$nulls":5},{"$error":"#DIV/0!"}]
[null,null,{"$f":"XFB6/2","v":{"$error":"#DIV/0!"}},{"$f":"XFB6/2","v":{"$error":"#DIV/0!"}},{"$nulls":5},{"$error":"#DIV/0!"}]
["EA","Estudos Ambientais",null,null,1,{"$nulls":4},1,{"$nulls":16371},{"$f":"'CRO1_Ins-Pro'!J20","v":{"$error":"#DIV/0!"}},{"$f":"XFB9/$J$19","v":{"$error":"#DIV/0!"}}]
[{"$nulls":4},{"$f":"E11/XFB9","v":{"$error":"#DIV/0!"}},{"$nulls":4},{"$error":"#DIV/0!"}]
[{"$nulls":4},{"$f":"XFB9","v":{"$error":"#DIV/0!"}},{"$nulls":4},{"$error":"#DIV/0!"}]
["LA","Licenciamento Ambiental",null,null,null,0,0,null,null,0,{"$nulls":16371},0,{"$f":"XFB12/$J$19","v":{"$error":"#DIV/0!"}}]
[{"$nulls":5},0,0,null,null,0]
[{"$nulls":5},{"$f":"XFB12/2","v":0},{"$f":"XFC12/2","v":{"$error":"#DIV/0!"}},null,null,{"$error":"#DIV/0!"}]
["PB","Projeto Básico",{"$nulls":5},1,1,2,{"$nulls":16371},{"$f":"'CRO1_Ins-Pro'!K20","v":{"$error":"#DIV/0!"}},{"$f":"XFB15/$J$19","v":{"$error":"#DIV/0!"}}]
[{"$nulls":7},{"$f":"H17/XFB15","v":{"$error":"#DIV/0!"}},{"$f":"I17/XFB15","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
[{"$nulls":7},{"$f":"XFB15/2","v":{"$error":"#DIV/0!"}},{"$f":"XFB15/2","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
["Total Geral",null,{"$f":"C19/$J$19","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"SUM(C18:I18)","v":{"$error":"#DIV/0!"}}]
[null,null,{"$f":"C8","v":{"$error":"#DIV/0!"}},{"$f":"D5+D8","v":{"$error":"#DIV/0!"}},{"$f":"E5+E11","v":{"$error":"#DIV/0!"}},{"$f":"F14","v":0},{"$f":"G14","v":{"$error":"#DIV/0!"}},{"$f":"H17","v":{"$error":"#DIV/0!"}},{"$f":"I17","v":{"$error":"#DIV/0!"}},{"$f":"SUM(XFB3:XFB15)","v":{"$error":"#DIV/0!"}}]
["Acumulado",null,{"$f":"C18","v":{"$error":"#DIV/0!"}},{"$f":"C20+D18","v":{"$error":"#DIV/0!"}},{"$f":"D20+E18","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,{"$f":"C19","v":{"$error":"#DIV/0!"}},{"$f":"C21+D19","v":{"$error":"#DIV/0!"}},{"$f":"D21+E19","v":{"$error":"#DIV/0!"}},{"$f":"E21+F19","v":{"$error":"#DIV/0!"}},{"$f":"F21+G19","v":{"$error":"#DIV/0!"}},{"$f":"G21+H19","v":{"$error":"#DIV/0!"}},{"$f":"H21+I19","v":{"$error":"#DIV/0!"}}]

{"sheet":"DNIT TC - 012023","index":12,"n_rows":102,"n_cols":25,"rows_kept":102,"cut":false,"hidden":true,"merged":[[1,20,1,21],[0,16,0,21],[0,22,1,23],[0,24,1,24],[1,6,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],[0,6,0,15],[0,0,2,0],[0,1,2,1],[0,2,2,2],[0,3,1,3],[0,4,1,5]]}
["Código","Categoria","Unid.","Salário","Encargos Sociais",null,"Encargos Complementares",{"$nulls":9},"Encargos Adicionais",{"$nulls":5},"Encargos Totais",null,"Valor Total"]
[{"$nulls":6},"Alimentação",null,"EPI",null,"Ferramenta",null,"Transporte",null,"Exame Ocupacional",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$"]
["P8001","Advogado júnior","mês",4281.78,0.79520000000000002,3404.88,0.16420000000000001,702.89,5.7999999999999996E-3,24.8,0,0,0,0,6.9999999999999999E-4,3.02,0,0,6.7100000000000007E-2,287.2,2.3E-3,9.98,1.0353000000000001,4432.76,8714.5499999999993]
["P8002","Advogado pleno","mês",5709.05,0.79520000000000002,4539.83,0.1231,702.89,4.3E-3,24.8,0,0,0,0,5.0000000000000001E-4,3.02,0,0,5.0299999999999997E-2,287.2,1.6999999999999999E-3,9.98,0.97519999999999996,5567.72,11276.77]
["P8003","Advogado sênior","mês",10130.91,0.79520000000000002,8056.1,6.9400000000000003E-2,702.89,2.3999999999999998E-3,24.8,0,0,0,0,2.9999999999999997E-4,3.02,0,0,2.8299999999999999E-2,287.2,1E-3,9.98,0.89670000000000005,9083.99,19214.900000000001]
["P8007","Analista de desenvolvimento de sistemas júnior","mês",4013.75,0.79410000000000003,3187.32,0.17510000000000001,702.89,0,0,0,0,0,0,8.9999999999999998E-4,3.46,0,0,7.1599999999999997E-2,287.2,2.5000000000000001E-3,9.98,1.0441,4190.8500000000004,8204.59]
["P8008","Analista de desenvolvimento de sistemas pleno","mês",5130.1499999999996,0.79410000000000003,4073.85,0.13700000000000001,702.89,0,0,0,0,0,0,6.9999999999999999E-4,3.46,0,0,5.6000000000000001E-2,287.2,1.9E-3,9.98,0.98970000000000002,5077.38,10207.530000000001]
["P8009","Analista de desenvolvimento de sistemas sênior","mês",9196.66,0.79410000000000003,7303.07,7.6399999999999996E-2,702.89,0,0,0,0,0,0,4.0000000000000002E-4,3.46,0,0,3.1199999999999999E-2,287.2,1.1000000000000001E-3,9.98,0.9032,8306.6,17503.259999999998]
["P8013","Arquiteto júnior","mês",11220,0.79300000000000004,8897.4599999999991,6.2600000000000003E-2,702.89,2.2000000000000001E-3,24.8,0,0,0,0,2.9999999999999997E-4,3.43,0,0,2.5600000000000001E-2,287.2,8.9999999999999998E-4,9.98,0.88460000000000005,9925.76,21145.759999999998]
["P8014","Arquiteto pleno","mês",11626.7,0.79300000000000004,9219.9699999999993,6.0499999999999998E-2,702.89,2.0999999999999999E-3,24.8,0,0,0,0,2.9999999999999997E-4,3.43,0,0,2.47E-2,287.2,8.9999999999999998E-4,9.98,0.88139999999999996,10248.27,21874.97]
["P8015","Arquiteto sênior","mês",14229.73,0.79300000000000004,11284.18,4.9399999999999999E-2,702.89,1.6999999999999999E-3,24.8,0,0,0,0,2.0000000000000001E-4,3.43,0,0,2.0199999999999999E-2,287.2,6.9999999999999999E-4,9.98,0.86529999999999996,12312.48,26542.21]
["P8019","Assistente social júnior","mês",3020.78,0.79979999999999996,2416.02,0.23269999999999999,702.89,8.2000000000000007E-3,24.8,0,0,1.2500000000000001E-2,37.78,1.6000000000000001E-3,4.7,0,0,9.5100000000000004E-2,287.2,3.3E-3,9.98,1.1531,3483.38,6504.16]
["P8020","Assistente social pleno","mês",4027.71,0.79979999999999996,3221.36,0.17449999999999999,702.89,6.1999999999999998E-3,24.8,0,0,0,0,1.1999999999999999E-3,4.7,0,0,7.1300000000000002E-2,287.2,2.5000000000000001E-3,9.98,1.0553999999999999,4250.93,8278.64]
["P8021","Assistente social sênior","mês",6830.21,0.79979999999999996,5462.8,0.10290000000000001,702.89,3.5999999999999999E-3,24.8,0,0,0,0,6.9999999999999999E-4,4.7,0,0,4.2000000000000003E-2,287.2,1.5E-3,9.98,0.95050000000000001,6492.37,13322.58]
["P8025","Auxiliar","mês",1467.63,0.80469999999999997,1181,0.47889999999999999,702.89,2.06E-2,30.19,1.1000000000000001E-3,1.55,8.9200000000000002E-2,130.97,4.4999999999999997E-3,6.67,0,0,0.19570000000000001,287.2,6.7999999999999996E-3,9.98,1.6014999999999999,2350.46,3818.09]
["P8026","Auxiliar administrativo","mês",1772.08,0.80120000000000002,1419.79,0.39660000000000001,702.89,0,0,0,0,6.3600000000000004E-2,112.71,2.2000000000000001E-3,3.83,0,0,0.16209999999999999,287.2,5.5999999999999999E-3,9.98,1.4313,2536.41,4308.49]
["P8027","Auxiliar de laboratório","mês",1618.28,0.80079999999999996,1295.92,0.43430000000000002,702.89,1.8700000000000001E-2,30.19,2E-3,3.19,7.5300000000000006E-2,121.94,2.7000000000000001E-3,4.3099999999999996,0,0,0.17749999999999999,287.2,6.1999999999999998E-3,9.98,1.5174000000000001,2455.62,4073.9]
["P8028","Auxiliar de topografia","mês",1467.63,0.80169999999999997,1176.5999999999999,0.47889999999999999,702.89,2.06E-2,30.19,8.9999999999999998E-4,1.35,8.9200000000000002E-2,130.97,3.2000000000000002E-3,4.7,0,0,0.19570000000000001,287.2,6.7999999999999996E-3,9.98,1.5971,2343.88,3811.52]
["P8032","Biólogo júnior","mês",3175.35,0.79559999999999997,2526.31,0.22140000000000001,702.89,7.7999999999999996E-3,24.8,0,0,8.9999999999999993E-3,28.51,1.1999999999999999E-3,3.77,0,0,9.0399999999999994E-2,287.2,3.0999999999999999E-3,9.98,1.1285000000000001,3583.46,6758.81]
["P8033","Biólogo pleno","mês",4233.8,0.79559999999999997,3368.41,0.16600000000000001,702.89,5.8999999999999999E-3,24.8,0,0,0,0,8.9999999999999998E-4,3.77,0,0,6.7799999999999999E-2,287.2,2.3999999999999998E-3,9.98,1.0386,4397.05,8630.85]
["P8034","Biólogo sênior","mês",7434.92,0.79559999999999997,5915.22,9.4500000000000001E-2,702.89,3.3E-3,24.8,0,0,0,0,5.0000000000000001E-4,3.77,0,0,3.8600000000000002E-2,287.2,1.2999999999999999E-3,9.98,0.93400000000000005,6943.86,14378.78]
["P8038","Chefe de escritório","mês",3370.83,0.79569999999999996,2682.17,0.20849999999999999,702.89,0,0,0,0,5.0000000000000001E-3,16.78,8.0000000000000004E-4,2.74,0,0,8.5199999999999998E-2,287.2,3.0000000000000001E-3,9.98,1.0982000000000001,3701.76,7072.59]
["P8040","Contador júnior","mês",4031.96,0.79530000000000001,3206.62,0.17430000000000001,702.89,0,0,0,0,0,0,5.9999999999999995E-4,2.61,0,0,7.1199999999999999E-2,287.2,2.5000000000000001E-3,9.98,1.044,4209.3100000000004,8241.27]
["P8041","Contador pleno","mês",5375.95,0.79530000000000001,4275.49,0.13070000000000001,702.89,0,0,0,0,0,0,5.0000000000000001E-4,2.61,0,0,5.3400000000000003E-2,287.2,1.9E-3,9.98,0.98180000000000001,5278.18,10654.13]
["P8042","Contador sênior","mês",10196.459999999999,0.79530000000000001,8109.24,6.8900000000000003E-2,702.89,0,0,0,0,0,0,2.9999999999999997E-4,2.61,0,0,2.8199999999999999E-2,287.2,1E-3,9.98,0.89359999999999995,9111.93,19308.39]
["P8044","Coordenador ambiental ","mês",16968.79,0.79479999999999995,13486.79,4.1399999999999999E-2,702.89,1.2999999999999999E-3,22.65,0,0,0,0,2.0000000000000001E-4,3.32,0,0,1.6899999999999998E-2,287.2,5.9999999999999995E-4,9.98,0.85529999999999995,14512.83,31481.62]
["P8045","Economista júnior","mês",4633.6099999999997,0.79,3660.55,0.1517,702.89,0,0,0,0,0,0,4.0000000000000002E-4,1.78,0,0,6.2E-2,287.2,2.2000000000000001E-3,9.98,1.0062,4662.3999999999996,9296]
["P8046","Economista pleno","mês",6178.14,0.79,4880.7299999999996,0.1138,702.89,0,0,0,0,0,0,2.9999999999999997E-4,1.78,0,0,4.65E-2,287.2,1.6000000000000001E-3,9.98,0.95220000000000005,5882.58,12060.72]
["P8047","Economista sênior","mês",10535.44,0.79,8323,6.6699999999999995E-2,702.89,0,0,0,0,0,0,2.0000000000000001E-4,1.78,0,0,2.7300000000000001E-2,287.2,8.9999999999999998E-4,9.98,0.8851,9324.84,19860.28]
["P8054","Engenheiro agrônomo júnior","mês",11220,0.79049999999999998,8869.41,6.2600000000000003E-2,702.89,2.2000000000000001E-3,24.8,0,0,0,0,2.0000000000000001E-4,2.64,0,0,2.5600000000000001E-2,287.2,8.9999999999999998E-4,9.98,0.8821,9896.93,21116.93]
["P8055","Engenheiro agrônomo pleno","mês",11530.62,0.79049999999999998,9114.9500000000007,6.0999999999999999E-2,702.89,2.2000000000000001E-3,24.8,0,0,0,0,2.0000000000000001E-4,2.64,0,0,2.4899999999999999E-2,287.2,8.9999999999999998E-4,9.98,0.87960000000000005,10142.469999999999,21673.09]
["P8056","Engenheiro agrônomo sênior","mês",13314.45,0.79049999999999998,10525.07,5.28E-2,702.89,1.9E-3,24.8,0,0,0,0,2.0000000000000001E-4,2.64,0,0,2.1600000000000001E-2,287.2,6.9999999999999999E-4,9.98,0.86770000000000003,11552.59,24867.03]
["P8057","Engenheiro ambiental júnior","mês",11220,0.79579999999999995,8928.8799999999992,6.2600000000000003E-2,702.89,2.2000000000000001E-3,24.8,0,0,0,0,2.9999999999999997E-4,3.6,0,0,2.5600000000000001E-2,287.2,8.9999999999999998E-4,9.98,0.88749999999999996,9957.34,21177.34]
["P8058","Engenheiro ambiental pleno","mês",11266.87,0.79579999999999995,8966.17,6.2399999999999997E-2,702.89,2.2000000000000001E-3,24.8,0,0,0,0,2.9999999999999997E-4,3.6,0,0,2.5499999999999998E-2,287.2,8.9999999999999998E-4,9.98,0.8871,9994.64,21261.51]
["P8059","Engenheiro ambiental sênior","mês",13578.83,0.79579999999999995,10806.03,5.1799999999999999E-2,702.89,1.8E-3,24.8,0,0,0,0,2.9999999999999997E-4,3.6,0,0,2.12E-2,287.2,6.9999999999999999E-4,9.98,0.87150000000000005,11834.5,25413.33]
["P8060","Engenheiro consultor especial","mês",20551.86,0.79449999999999998,16328.45,3.4200000000000001E-2,702.89,1.1000000000000001E-3,22.65,0,0,0,0,2.0000000000000001E-4,3.66,0,0,1.4E-2,287.2,5.0000000000000001E-4,9.98,0.84440000000000004,17354.830000000002,37906.68]
["P8061","Engenheiro coordenador","mês",17126.55,0.79449999999999998,13607.04,4.1000000000000002E-2,702.89,1.2999999999999999E-3,22.65,0,0,0,0,2.0000000000000001E-4,3.66,0,0,1.6799999999999999E-2,287.2,5.9999999999999995E-4,9.98,0.85440000000000005,14633.42,31759.96]
["P8062","Engenheiro de pesca júnior","mês",11220,0.80120000000000002,8989.4599999999991,6.2600000000000003E-2,702.89,2.2000000000000001E-3,24.8,0,0,0,0,4.0000000000000002E-4,4.63,0,0,2.5600000000000001E-2,287.2,8.9999999999999998E-4,9.98,0.89300000000000002,10018.969999999999,21238.97]
["P8063","Engenheiro de pesca pleno","mês",11526.37,0.80120000000000002,9234.93,6.0999999999999999E-2,702.89,2.2000000000000001E-3,24.8,0,0,0,0,4.0000000000000002E-4,4.63,0,0,2.4899999999999999E-2,287.2,8.9999999999999998E-4,9.98,0.89049999999999996,10264.43,21790.799999999999]
["P8064","Engenheiro de pesca sênior","mês",13764.58,0.80120000000000002,11028.19,5.11E-2,702.89,1.8E-3,24.8,0,0,0,0,2.9999999999999997E-4,4.63,0,0,2.0899999999999998E-2,287.2,6.9999999999999999E-4,9.98,0.876,12057.69,25822.27]
["P8065","Engenheiro de projetos júnior","mês",11220,0.79449999999999998,8914.2900000000009,6.2600000000000003E-2,702.89,2.2000000000000001E-3,24.8,0,0,0,0,2.9999999999999997E-4,3.66,0,0,2.5600000000000001E-2,287.2,8.9999999999999998E-4,9.98,0.88619999999999999,9942.82,21162.82]
["P8066","Engenheiro de projetos pleno","mês",11669.34,0.79449999999999998,9271.2900000000009,6.0199999999999997E-2,702.89,2.0999999999999999E-3,24.8,0,0,0,0,2.9999999999999997E-4,3.66,0,0,2.46E-2,287.2,8.9999999999999998E-4,9.98,0.88260000000000005,10299.82,21969.16]
["P8067","Engenheiro de projetos sênior","mês",14809.88,0.79449999999999998,11766.45,4.7500000000000001E-2,702.89,1.6999999999999999E-3,24.8,0,0,0,0,2.0000000000000001E-4,3.66,0,0,1.9400000000000001E-2,287.2,6.9999999999999999E-4,9.98,0.8639,12794.98,27604.86]
["P8068","Engenheiro florestal júnior","mês",11220,0.80120000000000002,8989.4599999999991,6.2600000000000003E-2,702.89,2.2000000000000001E-3,24.8,0,0,0,0,4.0000000000000002E-4,4.63,0,0,2.5600000000000001E-2,287.2,8.9999999999999998E-4,9.98,0.89300000000000002,10018.969999999999,21238.97]
["P8069","Engenheiro florestal pleno","mês",11526.37,0.80120000000000002,9234.93,6.0999999999999999E-2,702.89,2.2000000000000001E-3,24.8,0,0,0,0,4.0000000000000002E-4,4.63,0,0,2.4899999999999999E-2,287.2,8.9999999999999998E-4,9.98,0.89049999999999996,10264.43,21790.799999999999]
["P8070","Engenheiro florestal sênior","mês",13764.58,0.80120000000000002,11028.19,5.11E-2,702.89,1.8E-3,24.8,0,0,0,0,2.9999999999999997E-4,4.63,0,0,2.0899999999999998E-2,287.2,6.9999999999999999E-4,9.98,0.876,12057.69,25822.27]
["P8080","Geólogo júnior","mês",10004.5,0.79849999999999999,7988.59,7.0300000000000001E-2,702.89,2.5000000000000001E-3,24.8,0,0,0,0,4.0000000000000002E-4,3.91,0,0,2.87E-2,287.2,1E-3,9.98,0.90129999999999999,9017.3799999999992,19021.88]
["P8081","Geólogo pleno","mês",11482.37,0.79849999999999999,9168.67,6.1199999999999997E-2,702.89,2.2000000000000001E-3,24.8,0,0,0,0,2.9999999999999997E-4,3.91,0,0,2.5000000000000001E-2,287.2,8.9999999999999998E-4,9.98,0.8881,10197.459999999999,21679.83]
["P8082","Geólogo sênior","mês",13792.18,0.79849999999999999,11013.06,5.0999999999999997E-2,702.89,1.8E-3,24.8,0,0,0,0,2.9999999999999997E-4,3.91,0,0,2.0799999999999999E-2,287.2,6.9999999999999999E-4,9.98,0.87309999999999999,12041.84,25834.02]
["P8092","Jornalista júnior","mês",2779.77,0.79610000000000003,2212.9699999999998,0.25290000000000001,702.89,8.8999999999999999E-3,24.8,0,0,1.8800000000000001E-2,52.25,1E-3,2.92,0,0,0.1033,287.2,3.5999999999999999E-3,9.98,1.1846000000000001,3293,6072.77]
["P8093","Jornalista pleno","mês",3706.35,0.79610000000000003,2950.63,0.18959999999999999,702.89,6.7000000000000002E-3,24.8,0,0,0,0,8.0000000000000004E-4,2.92,0,0,7.7499999999999999E-2,287.2,2.7000000000000001E-3,9.98,1.0733999999999999,3978.42,7684.77]
["P8094","Jornalista sênior","mês",7205.54,0.79610000000000003,5736.33,9.7500000000000003E-2,702.89,3.3999999999999998E-3,24.8,0,0,0,0,4.0000000000000002E-4,2.92,0,0,3.9899999999999998E-2,287.2,1.4E-3,9.98,0.93869999999999998,6764.12,13969.66]
["P8098","Laboratorista","mês",2157.71,0.80079999999999996,1727.89,0.32579999999999998,702.89,1.29E-2,27.8,0,0,4.1500000000000002E-2,89.57,2E-3,4.3099999999999996,0,0,0.1331,287.2,4.5999999999999999E-3,9.98,1.3207,2849.65,5007.3599999999997]
["P8102","Médico veterinário","mês",11220,0.79220000000000002,8888.48,6.2600000000000003E-2,702.89,2.2000000000000001E-3,24.8,0,0,0,0,2.9999999999999997E-4,3.08,0,0,2.5600000000000001E-2,287.2,8.9999999999999998E-4,9.98,0.88380000000000003,9916.43,21136.43]
["P8106","Meteorologista júnior","mês",4941.05,0.79320000000000002,3919.24,0.14230000000000001,702.89,5.0000000000000001E-3,24.8,0,0,0,0,4.0000000000000002E-4,2.1800000000000002,0,0,5.8099999999999999E-2,287.2,2E-3,9.98,1.0011000000000001,4946.29,9887.34]
["P8107","Meteorologista pleno","mês",6588.06,0.79320000000000002,5225.6499999999996,0.1067,702.89,3.8E-3,24.8,0,0,0,0,2.9999999999999997E-4,2.1800000000000002,0,0,4.36E-2,287.2,1.5E-3,9.98,0.94910000000000005,6252.7,12840.76]
["P8108","Meteorologista sênior","mês",11069.44,0.79320000000000002,8780.2800000000007,6.3500000000000001E-2,702.89,2.2000000000000001E-3,24.8,0,0,0,0,2.0000000000000001E-4,2.1800000000000002,0,0,2.5899999999999999E-2,287.2,8.9999999999999998E-4,9.98,0.88600000000000001,9807.33,20876.78]
["P8112","Motorista de caminhão","mês",2154.65,0.80210000000000004,1728.24,0.32619999999999999,702.89,1.4E-2,30.19,0,0,4.1700000000000001E-2,89.75,2.2000000000000001E-3,4.63,0,0,0.1333,287.2,4.5999999999999999E-3,9.98,1.3241000000000001,2852.89,5007.54]
["P8113","Motorista de veículo leve","mês",1953.12,0.79920000000000002,1560.93,0.3599,702.89,1.55E-2,30.19,0,0,5.21E-2,101.84,2.2000000000000001E-3,4.3499999999999996,0,0,0.14699999999999999,287.2,5.1000000000000004E-3,9.98,1.3811,2697.39,4650.51]
["P8117","Oceanógrafo júnior","mês",4548.8100000000004,0.80020000000000002,3639.95,0.1545,702.89,5.4999999999999997E-3,24.8,0,0,0,0,8.0000000000000004E-4,3.5,0,0,6.3100000000000003E-2,287.2,2.2000000000000001E-3,9.98,1.0263,4668.32,9217.1299999999992]
["P8118","Oceanógrafo pleno","mês",6065.08,0.80020000000000002,4853.2700000000004,0.1159,702.89,4.1000000000000003E-3,24.8,0,0,0,0,5.9999999999999995E-4,3.5,0,0,4.7399999999999998E-2,287.2,1.6000000000000001E-3,9.98,0.9698,5881.64,11946.72]
["P8119","Oceanógrafo sênior","mês",10920.23,0.80020000000000002,8738.3700000000008,6.4399999999999999E-2,702.89,2.3E-3,24.8,0,0,0,0,2.9999999999999997E-4,3.5,0,0,2.63E-2,287.2,8.9999999999999998E-4,9.98,0.89439999999999997,9766.74,20686.96]
["P8129","Pedagogo júnior","mês",2395.6799999999998,0.8095,1939.31,0.29339999999999999,702.89,1.04E-2,24.8,0,0,3.1399999999999997E-2,75.290000000000006,3.3E-3,7.79,0,0,0.11990000000000001,287.2,4.1999999999999997E-3,9.98,1.272,3047.26,5442.94]
["P8130","Pedagogo pleno","mês",3194.25,0.8095,2585.7399999999998,0.22,702.89,7.7999999999999996E-3,24.8,0,0,8.6E-3,27.38,2.3999999999999998E-3,7.79,0,0,8.9899999999999994E-2,287.2,3.0999999999999999E-3,9.98,1.1414,3645.78,6840.03]
["P8131","Pedagogo sênior","mês",4952.66,0.8095,4009.18,0.1419,702.89,5.0000000000000001E-3,24.8,0,0,0,0,1.6000000000000001E-3,7.79,0,0,5.8000000000000003E-2,287.2,2E-3,9.98,1.018,5041.84,9994.5]
["P8135","Secretária","mês",2434.7399999999998,0.79879999999999995,1944.87,0.28870000000000001,702.89,0,0,0,0,0.03,72.95,1.6999999999999999E-3,4.1500000000000004,0,0,0.11799999999999999,287.2,4.1000000000000003E-3,9.98,1.2412000000000001,3022.03,5456.77]
["P8139","Sondador","mês",1882.18,0.79779999999999995,1501.6,0.37340000000000001,702.89,1.4800000000000001E-2,27.8,0,0,5.6399999999999999E-2,106.1,1.9E-3,3.57,0,0,0.15260000000000001,287.2,5.3E-3,9.98,1.4021999999999999,2639.15,4521.33]
["P8143","Técnico ambiental","mês",2719.96,0.80100000000000005,2178.69,0.25840000000000002,702.89,1.0200000000000001E-2,27.8,0,0,2.0500000000000001E-2,55.83,2E-3,5.45,0,0,0.1056,287.2,3.7000000000000002E-3,9.98,1.2014,3267.85,5987.81]
["P8147","Técnico de obras","mês",3118.31,0.79849999999999999,2489.9699999999998,0.22539999999999999,702.89,8.8999999999999999E-3,27.8,0,0,1.0200000000000001E-2,31.93,1.1999999999999999E-3,3.85,0,0,9.2100000000000001E-2,287.2,3.2000000000000002E-3,9.98,1.1395999999999999,3553.62,6671.93]
["P8151","Técnico de segurança do trabalho","mês",4457.84,0.8044,3585.89,0.15770000000000001,702.89,6.1999999999999998E-3,27.8,0,0,0,0,1.1000000000000001E-3,4.87,0,0,6.4399999999999999E-2,287.2,2.2000000000000001E-3,9.98,1.0361,4618.63,9076.4699999999993]
["P8155","Técnico em geoprocessamento","mês",2591.14,0.79549999999999998,2061.2600000000002,0.27129999999999999,702.89,1.0699999999999999E-2,27.8,0,0,2.4500000000000001E-2,63.56,1.6000000000000001E-3,4.1500000000000004,0,0,0.1108,287.2,3.8999999999999998E-3,9.98,1.2182999999999999,3156.85,5747.99]
["P8159","Técnico em informática - programador","mês",4013.75,0.79820000000000002,3203.77,0.17510000000000001,702.89,0,0,0,0,0,0,8.9999999999999998E-4,3.8,0,0,7.1599999999999997E-2,287.2,2.5000000000000001E-3,9.98,1.0483,4207.6400000000003,8221.39]
["P8163","Topógrafo","mês",2290.75,0.80169999999999997,1836.49,0.30680000000000002,702.89,1.21E-2,27.8,0,0,3.56E-2,81.59,2.0999999999999999E-3,4.7,0,0,0.12540000000000001,287.2,4.4000000000000003E-3,9.98,1.2881,2950.65,5241.3999999999996]
["P8167","Arquivista júnior","mês",2182.42,0.7984,1742.44,0.3221,702.89,0,0,0,0,4.0399999999999998E-2,88.09,1.6000000000000001E-3,3.58,0,0,0.13159999999999999,287.2,4.5999999999999999E-3,9.98,1.2986,2834.19,5016.6099999999997]
["P8168","Arquivista pleno","mês",2909.89,0.7984,2323.2600000000002,0.24160000000000001,702.89,0,0,0,0,1.5299999999999999E-2,44.44,1.1999999999999999E-3,3.58,0,0,9.8699999999999996E-2,287.2,3.3999999999999998E-3,9.98,1.1586000000000001,3371.35,6281.25]
["P8169","Arquivista sênior","mês",4542.09,0.7984,3626.41,0.15479999999999999,702.89,0,0,0,0,0,0,8.0000000000000004E-4,3.58,0,0,6.3200000000000006E-2,287.2,2.2000000000000001E-3,9.98,1.0194000000000001,4630.0600000000004,9172.15]
["P8173","Administrador júnior","mês",3166.55,0.79720000000000002,2524.37,0.222,702.89,0,0,0,0,9.1999999999999998E-3,29.04,1.1999999999999999E-3,3.87,0,0,9.0700000000000003E-2,287.2,3.2000000000000002E-3,9.98,1.1234,3557.36,6723.91]
["P8174","Administrador pleno","mês",4222.07,0.79720000000000002,3365.83,0.16650000000000001,702.89,0,0,0,0,0,0,8.9999999999999998E-4,3.87,0,0,6.8000000000000005E-2,287.2,2.3999999999999998E-3,9.98,1.0349999999999999,4369.78,8591.84]
["P8175","Administrador sênior","mês",7442.19,0.79720000000000002,5932.92,9.4399999999999998E-2,702.89,0,0,0,0,0,0,5.0000000000000001E-4,3.87,0,0,3.8600000000000002E-2,287.2,1.2999999999999999E-3,9.98,0.93210000000000004,6936.86,14379.06]
["P8180","Engenheiro agrimensor júnior","mês",11220,0.79430000000000001,8912.0499999999993,6.2600000000000003E-2,702.89,2.2000000000000001E-3,24.8,0,0,0,0,2.9999999999999997E-4,3.87,0,0,2.5600000000000001E-2,287.2,8.9999999999999998E-4,9.98,0.88600000000000001,9940.7900000000009,21160.79]
["P8181","Engenheiro agrimensor pleno","mês",11491.01,0.79430000000000001,9127.31,6.1199999999999997E-2,702.89,2.2000000000000001E-3,24.8,0,0,0,0,2.9999999999999997E-4,3.87,0,0,2.5000000000000001E-2,287.2,8.9999999999999998E-4,9.98,0.88380000000000003,10156.06,21647.07]
["P8182","Engenheiro agrimensor sênior","mês",12631.91,0.79430000000000001,10033.52,5.5599999999999997E-2,702.89,2E-3,24.8,0,0,0,0,2.9999999999999997E-4,3.87,0,0,2.2700000000000001E-2,287.2,8.0000000000000004E-4,9.98,0.87570000000000003,11062.27,23694.17]
["P8183","Geógrafo júnior","mês",3416.59,0.79420000000000002,2713.45,0.20569999999999999,702.89,7.3000000000000001E-3,24.8,0,0,4.1000000000000003E-3,14.04,8.0000000000000004E-4,2.73,0,0,8.4099999999999994E-2,287.2,2.8999999999999998E-3,9.98,1.0991,3755.09,7171.68]
["P8184","Geógrafo pleno","mês",4555.45,0.79420000000000002,3617.94,0.15429999999999999,702.89,5.4000000000000003E-3,24.8,0,0,0,0,5.9999999999999995E-4,2.73,0,0,6.3E-2,287.2,2.2000000000000001E-3,9.98,1.0198,4645.54,9200.99]
["P8185","Geógrafo sênior","mês",8786.76,0.79420000000000002,6978.44,0.08,702.89,2.8E-3,24.8,0,0,0,0,2.9999999999999997E-4,2.73,0,0,3.27E-2,287.2,1.1000000000000001E-3,9.98,0.91110000000000002,8006.04,16792.8]
["P8186","Antropólogo júnior","mês",3129,0.82,2565.7800000000002,0.22459999999999999,702.89,7.9000000000000008E-3,24.8,0,0,0.01,31.29,1.8E-3,5.5,0,0,9.1800000000000007E-2,287.2,3.2000000000000002E-3,9.98,1.1593,3627.44,6756.44]
["P8187","Antropólogo pleno","mês",4172,0.82,3421.04,0.16850000000000001,702.89,5.8999999999999999E-3,24.8,0,0,0,0,1.2999999999999999E-3,5.5,0,0,6.88E-2,287.2,2.3999999999999998E-3,9.98,1.0669999999999999,4451.41,8623.41]
["P8188","Antropólogo sênior","mês",6159.78,0.82,5051.0200000000004,0.11409999999999999,702.89,4.0000000000000001E-3,24.8,0,0,0,0,8.9999999999999998E-4,5.5,0,0,4.6600000000000003E-2,287.2,1.6000000000000001E-3,9.98,0.98729999999999996,6081.39,12241.17]
["P8189","Arqueólogo júnior","mês",2980.05,0.80510000000000004,2399.2399999999998,0.2359,702.89,8.3000000000000001E-3,24.8,0,0,1.35E-2,40.229999999999997,1.2999999999999999E-3,3.74,0,0,9.64E-2,287.2,3.3E-3,9.98,1.1637999999999999,3468.08,6448.13]
["P8190","Arqueólogo pleno","mês",3973.4,0.80510000000000004,3198.98,0.1769,702.89,6.1999999999999998E-3,24.8,0,0,0,0,8.9999999999999998E-4,3.74,0,0,7.2300000000000003E-2,287.2,2.5000000000000001E-3,9.98,1.0640000000000001,4227.6000000000004,8201]
["P8191","Arqueólogo sênior","mês",5890.45,0.80510000000000004,4742.3999999999996,0.1193,702.89,4.1999999999999997E-3,24.8,0,0,0,0,5.9999999999999995E-4,3.74,0,0,4.8800000000000003E-2,287.2,1.6999999999999999E-3,9.98,0.97970000000000002,5771.02,11661.48]
["P8192","Historiador júnior","mês",3434.55,0.8014,2752.45,0.20469999999999999,702.89,7.1999999999999998E-3,24.8,0,0,3.8E-3,12.96,1.2999999999999999E-3,4.54,0,0,8.3599999999999994E-2,287.2,2.8999999999999998E-3,9.98,1.1049,3794.82,7229.37]
["P8193","Historiador pleno","mês",4579.3999999999996,0.8014,3669.93,0.1535,702.89,5.4000000000000003E-3,24.8,0,0,0,0,1E-3,4.54,0,0,6.2700000000000006E-2,287.2,2.2000000000000001E-3,9.98,1.0262,4699.34,9278.74]
["P8194","Historiador sênior","mês",7561.4,0.8014,6059.71,9.2999999999999999E-2,702.89,3.3E-3,24.8,0,0,0,0,5.9999999999999995E-4,4.54,0,0,3.7999999999999999E-2,287.2,1.2999999999999999E-3,9.98,0.9375,7089.12,14650.53]
["P8195","Paleontólogo júnior","mês",3129,0.82789999999999997,2590.5,0.22459999999999999,702.89,7.9000000000000008E-3,24.8,0,0,0.01,31.29,1.8E-3,5.5,0,0,9.1800000000000007E-2,287.2,3.2000000000000002E-3,9.98,1.1672,3652.16,6781.16]
["P8196","Paleontólogo pleno","mês",4172,0.82789999999999997,3454,0.16850000000000001,702.89,5.8999999999999999E-3,24.8,0,0,0,0,1.2999999999999999E-3,5.5,0,0,6.88E-2,287.2,2.3999999999999998E-3,9.98,1.0749,4484.37,8656.3700000000008]
["P8197","Paleontólogo sênior","mês",6159.78,0.82789999999999997,5099.68,0.11409999999999999,702.89,4.0000000000000001E-3,24.8,0,0,0,0,8.9999999999999998E-4,5.5,0,0,4.6600000000000003E-2,287.2,1.6000000000000001E-3,9.98,0.99519999999999997,6130.05,12289.83]
["P8198","Sociólogo júnior","mês",3607.77,0.8014,2891.26,0.1948,702.89,6.8999999999999999E-3,24.8,0,0,6.9999999999999999E-4,2.57,1.2999999999999999E-3,4.54,0,0,7.9600000000000004E-2,287.2,2.8E-3,9.98,1.0873999999999999,3923.24,7531.01]
["P8199","Sociólogo pleno","mês",4810.3599999999997,0.8014,3855.02,0.14610000000000001,702.89,5.1999999999999998E-3,24.8,0,0,0,0,8.9999999999999998E-4,4.54,0,0,5.9700000000000003E-2,287.2,2.0999999999999999E-3,9.98,1.0154000000000001,4884.43,9694.7900000000009]
["P8200","Sociólogo sênior","mês",7731.83,0.8014,6196.29,9.0899999999999995E-2,702.89,3.2000000000000002E-3,24.8,0,0,0,0,5.9999999999999995E-4,4.54,0,0,3.7100000000000001E-2,287.2,1.2999999999999999E-3,9.98,0.9345,7225.7,14957.54]
["Fonte: FGV IBRE"]

{"sheet":"DNIT TC -072023","index":13,"n_rows":102,"n_cols":25,"rows_kept":102,"cut":false,"hidden":true,"merged":[[1,20,1,21],[0,16,0,21],[0,22,1,23],[0,24,1,24],[1,6,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],[0,6,0,15],[0,0,2,0],[0,1,2,1],[0,2,2,2],[0,3,1,3],[0,4,1,5]]}
["Código","Categoria","Unid.","Salário","Encargos Sociais",null,"Encargos Complementares",{"$nulls":9},"Encargos Adicionais",{"$nulls":5},"Encargos Totais",null,"Valor Total"]
[{"$nulls":6},"Alimentação",null,"EPI",null,"Ferramenta",null,"Transporte",null,"Exame Ocupacional",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$"]
["P8001","Advogado júnior","mês",4222.1400000000003,0.79630000000000001,3362.09,0.1603,677.01,6.1999999999999998E-3,26.03,0,0,0,0,8.0000000000000004E-4,3.47,0,0,7.1400000000000005E-2,301.42,2.3999999999999998E-3,9.98,1.0374000000000001,4379.99,8602.1299999999992]
["P8002","Advogado pleno","mês",5629.52,0.79630000000000001,4482.78,0.1203,677.01,4.5999999999999999E-3,26.03,0,0,0,0,5.9999999999999995E-4,3.47,0,0,5.3499999999999999E-2,301.42,1.8E-3,9.98,0.97709999999999997,5500.69,11130.21]
["P8003","Advogado sênior","mês",9740.8700000000008,0.79630000000000001,7756.65,6.9500000000000006E-2,677.01,2.7000000000000001E-3,26.03,0,0,0,0,4.0000000000000002E-4,3.47,0,0,3.09E-2,301.42,1E-3,9.98,0.90080000000000005,8774.56,18515.43]
["P8007","Analista de desenvolvimento de sistemas júnior","mês",3731.91,0.79379999999999995,2962.39,0.18140000000000001,677.01,0,0,0,0,0,0,8.9999999999999998E-4,3.29,0,0,8.0799999999999997E-2,301.42,2.7000000000000001E-3,9.98,1.0595000000000001,3954.09,7686]
["P8008","Analista de desenvolvimento de sistemas pleno","mês",4975.88,0.79379999999999995,3949.85,0.1361,677.01,0,0,0,0,0,0,6.9999999999999999E-4,3.29,0,0,6.0600000000000001E-2,301.42,2E-3,9.98,0.99309999999999998,4941.55,9917.43]
["P8009","Analista de desenvolvimento de sistemas sênior","mês",8853.75,0.79379999999999995,7028.1,7.6499999999999999E-2,677.01,0,0,0,0,0,0,4.0000000000000002E-4,3.29,0,0,3.4000000000000002E-2,301.42,1.1000000000000001E-3,9.98,0.90580000000000005,8019.8,16873.55]
["P8013","Arquiteto júnior","mês",11067,0.79239999999999999,8769.49,6.1199999999999997E-2,677.01,2.3999999999999998E-3,26.03,0,0,0,0,2.0000000000000001E-4,2.6,0,0,2.7199999999999998E-2,301.42,8.9999999999999998E-4,9.98,0.88429999999999997,9786.52,20853.52]
["P8014","Arquiteto pleno","mês",11492.2,0.79239999999999999,9106.42,5.8900000000000001E-2,677.01,2.3E-3,26.03,0,0,0,0,2.0000000000000001E-4,2.6,0,0,2.6200000000000001E-2,301.42,8.9999999999999998E-4,9.98,0.88090000000000002,10123.450000000001,21615.65]
["P8015","Arquiteto sênior","mês",14185.72,0.79239999999999999,11240.77,4.7699999999999999E-2,677.01,1.8E-3,26.03,0,0,0,0,2.0000000000000001E-4,2.6,0,0,2.12E-2,301.42,6.9999999999999999E-4,9.98,0.86409999999999998,12257.8,26443.52]
["P8019","Assistente social júnior","mês",2867.66,0.79969999999999997,2293.27,0.2361,677.01,9.1000000000000004E-3,26.03,0,0,1.6400000000000001E-2,46.97,1.2999999999999999E-3,3.82,0,0,0.1051,301.42,3.5000000000000001E-3,9.98,1.1712,3358.5,6226.16]
["P8020","Assistente social pleno","mês",3823.55,0.79969999999999997,3057.69,0.17710000000000001,677.01,6.7999999999999996E-3,26.03,0,0,0,0,1E-3,3.82,0,0,7.8799999999999995E-2,301.42,2.5999999999999999E-3,9.98,1.0660000000000001,4075.95,7899.5]
["P8021","Assistente social sênior","mês",6517.04,0.79969999999999997,5211.68,0.10390000000000001,677.01,4.0000000000000001E-3,26.03,0,0,0,0,5.9999999999999995E-4,3.82,0,0,4.6300000000000001E-2,301.42,1.5E-3,9.98,0.95589999999999997,6229.93,12746.97]
["P8025","Auxiliar","mês",1428.53,0.79979999999999996,1142.54,0.47389999999999999,677.01,2.2200000000000001E-2,31.69,1.1000000000000001E-3,1.62,9.3299999999999994E-2,133.32,2.5000000000000001E-3,3.57,0,0,0.21099999999999999,301.42,7.0000000000000001E-3,9.98,1.6109,2301.15,3729.68]
["P8026","Auxiliar administrativo","mês",1708.51,0.80110000000000003,1368.69,0.39629999999999999,677.01,0,0,0,0,6.8199999999999997E-2,116.52,2.5000000000000001E-3,4.28,0,0,0.1764,301.42,5.7999999999999996E-3,9.98,1.4502999999999999,2477.89,4186.3999999999996]
["P8027","Auxiliar de laboratório","mês",1609.67,0.79879999999999995,1285.81,0.42059999999999997,677.01,1.9699999999999999E-2,31.69,2.0999999999999999E-3,3.35,7.6100000000000001E-2,122.45,2.7000000000000001E-3,4.37,0,0,0.18729999999999999,301.42,6.1999999999999998E-3,9.98,1.5134000000000001,2436.08,4045.75]
["P8028","Auxiliar de topografia","mês",1428.53,0.7994,1141.97,0.47389999999999999,677.01,2.2200000000000001E-2,31.69,1E-3,1.41,9.3299999999999994E-2,133.32,3.0999999999999999E-3,4.4800000000000004,0,0,0.21099999999999999,301.42,7.0000000000000001E-3,9.98,1.6109,2301.27,3729.8]
["P8032","Biólogo júnior","mês",3084.04,0.79479999999999995,2451.1999999999998,0.2195,677.01,8.3999999999999995E-3,26.03,0,0,1.0999999999999999E-2,33.99,1.1000000000000001E-3,3.31,0,0,9.7699999999999995E-2,301.42,3.2000000000000002E-3,9.98,1.1357999999999999,3502.93,6586.97]
["P8033","Biólogo pleno","mês",4112.0600000000004,0.79479999999999995,3268.26,0.1646,677.01,6.3E-3,26.03,0,0,0,0,8.0000000000000004E-4,3.31,0,0,7.3300000000000004E-2,301.42,2.3999999999999998E-3,9.98,1.0423,4286.01,8398.06]
["P8034","Biólogo sênior","mês",7148.83,0.79479999999999995,5681.89,9.4700000000000006E-2,677.01,3.5999999999999999E-3,26.03,0,0,0,0,5.0000000000000001E-4,3.31,0,0,4.2200000000000001E-2,301.42,1.4E-3,9.98,0.93720000000000003,6699.64,13848.47]
["P8038","Chefe de escritório","mês",3122.68,0.79720000000000002,2489.4,0.21679999999999999,677.01,0,0,0,0,1.01E-2,31.67,1E-3,3.05,0,0,9.6500000000000002E-2,301.42,3.2000000000000002E-3,9.98,1.1248,3512.52,6635.2]
["P8040","Contador júnior","mês",3909.36,0.79610000000000003,3112.24,0.17319999999999999,677.01,0,0,0,0,0,0,8.0000000000000004E-4,3.14,0,0,7.7100000000000002E-2,301.42,2.5999999999999999E-3,9.98,1.0497000000000001,4103.79,8013.14]
["P8041","Contador pleno","mês",5212.47,0.79610000000000003,4149.6499999999996,0.12989999999999999,677.01,0,0,0,0,0,0,5.9999999999999995E-4,3.14,0,0,5.7799999999999997E-2,301.42,1.9E-3,9.98,0.98629999999999995,5141.2,10353.67]
["P8042","Contador sênior","mês",9737.02,0.79610000000000003,7751.64,6.9500000000000006E-2,677.01,0,0,0,0,0,0,2.9999999999999997E-4,3.14,0,0,3.1E-2,301.42,1E-3,9.98,0.89790000000000003,8743.19,18480.22]
["P8044","Coordenador ambiental ","mês",15552.43,0.79449999999999998,12356.4,4.3499999999999997E-2,677.01,1.5E-3,23.77,0,0,0,0,2.0000000000000001E-4,3.38,0,0,1.9400000000000001E-2,301.42,5.9999999999999995E-4,9.98,0.85980000000000001,13371.96,28924.39]
["P8045","Economista júnior","mês",4306.55,0.79220000000000002,3411.65,0.15720000000000001,677.01,0,0,0,0,0,0,6.9999999999999999E-4,3.03,0,0,7.0000000000000007E-2,301.42,2.3E-3,9.98,1.0224,4403.09,8709.64]
["P8046","Economista pleno","mês",5742.07,0.79220000000000002,4548.87,0.1179,677.01,0,0,0,0,0,0,5.0000000000000001E-4,3.03,0,0,5.2499999999999998E-2,301.42,1.6999999999999999E-3,9.98,0.96489999999999998,5540.31,11282.38]
["P8047","Economista sênior","mês",9853.56,0.79220000000000002,7805.99,6.8699999999999997E-2,677.01,0,0,0,0,0,0,2.9999999999999997E-4,3.03,0,0,3.0599999999999999E-2,301.42,1E-3,9.98,0.89280000000000004,8797.43,18650.990000000002]
["P8054","Engenheiro agrônomo júnior","mês",11067,0.7903,8746.25,6.1199999999999997E-2,677.01,2.3999999999999998E-3,26.03,0,0,0,0,2.9999999999999997E-4,3.08,0,0,2.7199999999999998E-2,301.42,8.9999999999999998E-4,9.98,0.88219999999999998,9763.76,20830.759999999998]
["P8055","Engenheiro agrônomo pleno","mês",12027.17,0.7903,9505.07,5.6300000000000003E-2,677.01,2.2000000000000001E-3,26.03,0,0,0,0,2.9999999999999997E-4,3.08,0,0,2.5100000000000001E-2,301.42,8.0000000000000004E-4,9.98,0.87490000000000001,10522.59,22549.759999999998]
["P8056","Engenheiro agrônomo sênior","mês",12987.35,0.7903,10263.9,5.21E-2,677.01,2E-3,26.03,0,0,0,0,2.0000000000000001E-4,3.08,0,0,2.3199999999999998E-2,301.42,8.0000000000000004E-4,9.98,0.86860000000000004,11281.41,24268.76]
["P8057","Engenheiro ambiental júnior","mês",11067,0.79569999999999996,8806.01,6.1199999999999997E-2,677.01,2.3999999999999998E-3,26.03,0,0,0,0,2.9999999999999997E-4,3.45,0,0,2.7199999999999998E-2,301.42,8.9999999999999998E-4,9.98,0.88770000000000004,9823.9,20890.900000000001]
["P8058","Engenheiro ambiental pleno","mês",11113.77,0.79569999999999996,8843.23,6.0900000000000003E-2,677.01,2.3E-3,26.03,0,0,0,0,2.9999999999999997E-4,3.45,0,0,2.7099999999999999E-2,301.42,8.9999999999999998E-4,9.98,0.88729999999999998,9861.1200000000008,20974.89]
["P8059","Engenheiro ambiental sênior","mês",13306.5,0.79569999999999996,10587.98,5.0900000000000001E-2,677.01,2E-3,26.03,0,0,0,0,2.9999999999999997E-4,3.45,0,0,2.2700000000000001E-2,301.42,8.0000000000000004E-4,9.98,0.87219999999999998,11605.87,24912.36]
["P8060","Engenheiro consultor especial","mês",20421.759999999998,0.79390000000000005,16212.84,3.32E-2,677.01,1.1999999999999999E-3,23.77,0,0,0,0,2.0000000000000001E-4,3.32,0,0,1.4800000000000001E-2,301.42,5.0000000000000001E-4,9.98,0.84360000000000002,17228.34,37650.1]
["P8061","Engenheiro coordenador","mês",17018.13,0.79390000000000005,13510.7,3.9800000000000002E-2,677.01,1.4E-3,23.77,0,0,0,0,2.0000000000000001E-4,3.32,0,0,1.77E-2,301.42,5.9999999999999995E-4,9.98,0.85360000000000003,14526.2,31544.33]
["P8062","Engenheiro de pesca júnior","mês",11067,0.79710000000000003,8821.51,6.1199999999999997E-2,677.01,2.3999999999999998E-3,26.03,0,0,0,0,4.0000000000000002E-4,3.89,0,0,2.7199999999999998E-2,301.42,8.9999999999999998E-4,9.98,0.8891,9839.83,20906.830000000002]
["P8063","Engenheiro de pesca pleno","mês",11199.09,0.79710000000000003,8926.7999999999993,6.0499999999999998E-2,677.01,2.3E-3,26.03,0,0,0,0,2.9999999999999997E-4,3.89,0,0,2.69E-2,301.42,8.9999999999999998E-4,9.98,0.88800000000000001,9945.1200000000008,21144.22]
["P8064","Engenheiro de pesca sênior","mês",12672.11,0.79710000000000003,10100.94,5.3400000000000003E-2,677.01,2.0999999999999999E-3,26.03,0,0,0,0,2.9999999999999997E-4,3.89,0,0,2.3800000000000002E-2,301.42,8.0000000000000004E-4,9.98,0.87749999999999995,11119.27,23791.38]
["P8065","Engenheiro de projetos júnior","mês",11067,0.79390000000000005,8786.09,6.1199999999999997E-2,677.01,2.3999999999999998E-3,26.03,0,0,0,0,2.9999999999999997E-4,3.32,0,0,2.7199999999999998E-2,301.42,8.9999999999999998E-4,9.98,0.88590000000000002,9803.85,20870.849999999999]
["P8066","Engenheiro de projetos pleno","mês",11469.24,0.79390000000000005,9105.43,5.8999999999999997E-2,677.01,2.3E-3,26.03,0,0,0,0,2.9999999999999997E-4,3.32,0,0,2.63E-2,301.42,8.9999999999999998E-4,9.98,0.88260000000000005,10123.19,21592.42]
["P8067","Engenheiro de projetos sênior","mês",14672.91,0.79390000000000005,11648.82,4.6100000000000002E-2,677.01,1.8E-3,26.03,0,0,0,0,2.0000000000000001E-4,3.32,0,0,2.0500000000000001E-2,301.42,6.9999999999999999E-4,9.98,0.86329999999999996,12666.58,27339.49]
["P8068","Engenheiro florestal júnior","mês",11067,0.79710000000000003,8821.51,6.1199999999999997E-2,677.01,2.3999999999999998E-3,26.03,0,0,0,0,4.0000000000000002E-4,3.89,0,0,2.7199999999999998E-2,301.42,8.9999999999999998E-4,9.98,0.8891,9839.83,20906.830000000002]
["P8069","Engenheiro florestal pleno","mês",11199.11,0.79710000000000003,8926.81,6.0499999999999998E-2,677.01,2.3E-3,26.03,0,0,0,0,2.9999999999999997E-4,3.89,0,0,2.69E-2,301.42,8.9999999999999998E-4,9.98,0.88800000000000001,9945.14,21144.25]
["P8070","Engenheiro florestal sênior","mês",12672.11,0.79710000000000003,10100.94,5.3400000000000003E-2,677.01,2.0999999999999999E-3,26.03,0,0,0,0,2.9999999999999997E-4,3.89,0,0,2.3800000000000002E-2,301.42,8.0000000000000004E-4,9.98,0.87749999999999995,11119.27,23791.38]
["P8080","Geólogo júnior","mês",10004.5,0.79590000000000005,7962.58,6.7699999999999996E-2,677.01,2.5999999999999999E-3,26.03,0,0,0,0,4.0000000000000002E-4,3.55,0,0,3.0099999999999998E-2,301.42,1E-3,9.98,0.89770000000000005,8980.57,18985.07]
["P8081","Geólogo pleno","mês",10526.36,0.79590000000000005,8377.93,6.4299999999999996E-2,677.01,2.5000000000000001E-3,26.03,0,0,0,0,2.9999999999999997E-4,3.55,0,0,2.86E-2,301.42,8.9999999999999998E-4,9.98,0.89259999999999995,9395.92,19922.28]
["P8082","Geólogo sênior","mês",14001.61,0.79590000000000005,11143.88,4.8399999999999999E-2,677.01,1.9E-3,26.03,0,0,0,0,2.9999999999999997E-4,3.55,0,0,2.1499999999999998E-2,301.42,6.9999999999999999E-4,9.98,0.86860000000000004,12161.87,26163.48]
["P8092","Jornalista júnior","mês",2682.71,0.79630000000000001,2136.2399999999998,0.25240000000000001,677.01,9.7000000000000003E-3,26.03,0,0,2.1600000000000001E-2,58.07,1.1000000000000001E-3,2.95,0,0,0.1124,301.42,3.7000000000000002E-3,9.98,1.1972,3211.7,5894.4]
["P8093","Jornalista pleno","mês",3576.94,0.79630000000000001,2848.32,0.1893,677.01,7.3000000000000001E-3,26.03,0,0,1.1999999999999999E-3,4.42,8.0000000000000004E-4,2.95,0,0,8.43E-2,301.42,2.8E-3,9.98,1.0820000000000001,3870.12,7447.06]
["P8094","Jornalista sênior","mês",6931.43,0.79630000000000001,5519.5,9.7699999999999995E-2,677.01,3.8E-3,26.03,0,0,0,0,4.0000000000000002E-4,2.95,0,0,4.3499999999999997E-2,301.42,1.4E-3,9.98,0.94310000000000005,6536.88,13468.31]
["P8098","Laboratorista","mês",2146.23,0.79879999999999995,1714.41,0.31540000000000001,677.01,1.3599999999999999E-2,29.18,0,0,4.2099999999999999E-2,90.26,2E-3,4.37,0,0,0.1404,301.42,4.7000000000000002E-3,9.98,1.3169999999999999,2826.63,4972.8599999999997]
["P8102","Médico veterinário","mês",11067,0.79200000000000004,8765.06,6.1199999999999997E-2,677.01,2.3999999999999998E-3,26.03,0,0,0,0,2.9999999999999997E-4,2.98,0,0,2.7199999999999998E-2,301.42,8.9999999999999998E-4,9.98,0.88390000000000002,9782.48,20849.48]
["P8106","Meteorologista júnior","mês",4696.66,0.79559999999999997,3736.66,0.14410000000000001,677.01,5.4999999999999997E-3,26.03,0,0,0,0,5.9999999999999995E-4,2.8,0,0,6.4199999999999993E-2,301.42,2.0999999999999999E-3,9.98,1.0122,4753.8999999999996,9450.5499999999993]
["P8107","Meteorologista pleno","mês",6262.21,0.79559999999999997,4982.21,0.1081,677.01,4.1999999999999997E-3,26.03,0,0,0,0,4.0000000000000002E-4,2.8,0,0,4.8099999999999997E-2,301.42,1.6000000000000001E-3,9.98,0.95799999999999996,5999.45,12261.66]
["P8108","Meteorologista sênior","mês",10569.08,0.79559999999999997,8408.76,6.4100000000000004E-2,677.01,2.5000000000000001E-3,26.03,0,0,0,0,2.9999999999999997E-4,2.8,0,0,2.8500000000000001E-2,301.42,8.9999999999999998E-4,9.98,0.89180000000000004,9425.99,19995.07]
["P8112","Motorista de caminhão","mês",2096.81,0.79979999999999996,1677.03,0.32290000000000002,677.01,1.5100000000000001E-2,31.69,0,0,4.4499999999999998E-2,93.22,2.0999999999999999E-3,4.41,0,0,0.14380000000000001,301.42,4.7999999999999996E-3,9.98,1.3329,2794.76,4891.57]
["P8113","Motorista de veículo leve","mês",1918.44,0.79710000000000003,1529.19,0.35289999999999999,677.01,1.6500000000000001E-2,31.69,0,0,5.4199999999999998E-2,103.93,2E-3,3.88,0,0,0.15709999999999999,301.42,5.1999999999999998E-3,9.98,1.385,2657.09,4575.53]
["P8117","Oceanógrafo júnior","mês",4509.57,0.83579999999999999,3769.1,0.15010000000000001,677.01,5.7999999999999996E-3,26.03,0,0,0,0,1.6000000000000001E-3,7.38,0,0,6.6799999999999998E-2,301.42,2.2000000000000001E-3,9.98,1.0624,4790.92,9300.5]
["P8118","Oceanógrafo pleno","mês",6012.77,0.83579999999999999,5025.47,0.11260000000000001,677.01,4.3E-3,26.03,0,0,0,0,1.1999999999999999E-3,7.38,0,0,5.0099999999999999E-2,301.42,1.6999999999999999E-3,9.98,1.0057,6047.29,12060.05]
["P8119","Oceanógrafo sênior","mês",9797.51,0.83579999999999999,8188.76,6.9099999999999995E-2,677.01,2.7000000000000001E-3,26.03,0,0,0,0,8.0000000000000004E-4,7.38,0,0,3.0800000000000001E-2,301.42,1E-3,9.98,0.94010000000000005,9210.58,19008.09]
["P8129","Pedagogo júnior","mês",2605.46,0.79690000000000005,2076.29,0.25979999999999998,677.01,0.01,26.03,0,0,2.41E-2,62.7,1.6000000000000001E-3,4.22,0,0,0.1157,301.42,3.8E-3,9.98,1.2119,3157.64,5763.1]
["P8130","Pedagogo pleno","mês",3473.94,0.79690000000000005,2768.38,0.19489999999999999,677.01,7.4999999999999997E-3,26.03,0,0,3.0000000000000001E-3,10.6,1.1999999999999999E-3,4.22,0,0,8.6800000000000002E-2,301.42,2.8999999999999998E-3,9.98,1.0931999999999999,3797.63,7271.57]
["P8131","Pedagogo sênior","mês",5794.12,0.79690000000000005,4617.34,0.1168,677.01,4.4999999999999997E-3,26.03,0,0,0,0,6.9999999999999999E-4,4.22,0,0,5.1999999999999998E-2,301.42,1.6999999999999999E-3,9.98,0.97270000000000001,5635.99,11430.11]
["P8135","Secretária","mês",2335.81,0.79720000000000002,1862.11,0.2898,677.01,0,0,0,0,3.3799999999999997E-2,78.88,1.2999999999999999E-3,3.05,0,0,0.129,301.42,4.3E-3,9.98,1.2554000000000001,2932.45,5268.26]
["P8139","Sondador","mês",1843.72,0.79669999999999996,1468.89,0.36720000000000003,677.01,1.5800000000000002E-2,29.18,0,0,5.8799999999999998E-2,108.41,2.2000000000000001E-3,4.01,0,0,0.16350000000000001,301.42,5.4000000000000003E-3,9.98,1.4096,2598.9,4442.62]
["P8143","Técnico ambiental","mês",2751.31,0.79849999999999999,2196.92,0.24610000000000001,677.01,1.06E-2,29.18,0,0,1.9599999999999999E-2,53.95,1.5E-3,4.05,0,0,0.1096,301.42,3.5999999999999999E-3,9.98,1.1894,3272.51,6023.83]
["P8147","Técnico de obras","mês",3091.07,0.79679999999999995,2462.9699999999998,0.219,677.01,9.4000000000000004E-3,29.18,0,0,1.09E-2,33.57,1.1999999999999999E-3,3.84,0,0,9.7500000000000003E-2,301.42,3.2000000000000002E-3,9.98,1.1380999999999999,3517.96,6609.04]
["P8151","Técnico de segurança do trabalho","mês",4293.3999999999996,0.80179999999999996,3442.45,0.15770000000000001,677.01,6.7999999999999996E-3,29.18,0,0,0,0,1.1000000000000001E-3,4.6100000000000003,0,0,7.0199999999999999E-2,301.42,2.3E-3,9.98,1.0399,4464.6400000000003,8758.0400000000009]
["P8155","Técnico em geoprocessamento","mês",2522.7600000000002,0.79449999999999998,2004.33,0.26840000000000003,677.01,1.1599999999999999E-2,29.18,0,0,2.6800000000000001E-2,67.67,1.2999999999999999E-3,3.27,0,0,0.1195,301.42,4.0000000000000001E-3,9.98,1.226,3092.86,5615.61]
["P8159","Técnico em informática - programador","mês",3610.93,0.79649999999999999,2876.1,0.1875,677.01,0,0,0,0,6.9999999999999999E-4,2.38,1.1000000000000001E-3,3.86,0,0,8.3500000000000005E-2,301.42,2.8E-3,9.98,1.0720000000000001,3870.75,7481.67]
["P8163","Topógrafo","mês",2323.3000000000002,0.7994,1857.25,0.29139999999999999,677.01,1.26E-2,29.18,0,0,3.4299999999999997E-2,79.63,1.9E-3,4.4800000000000004,0,0,0.12970000000000001,301.42,4.3E-3,9.98,1.2736000000000001,2958.95,5282.25]
["P8167","Arquivista júnior","mês",2018.26,0.79810000000000003,1610.77,0.33539999999999998,677.01,0,0,0,0,4.8500000000000001E-2,97.94,1.6999999999999999E-3,3.48,0,0,0.14929999999999999,301.42,4.8999999999999998E-3,9.98,1.3381000000000001,2700.6,4718.8599999999997]
["P8168","Arquivista pleno","mês",2691.02,0.79810000000000003,2147.6999999999998,0.25159999999999999,677.01,0,0,0,0,2.1399999999999999E-2,57.57,1.2999999999999999E-3,3.48,0,0,0.112,301.42,3.7000000000000002E-3,9.98,1.1880999999999999,3197.16,5888.17]
["P8169","Arquivista sênior","mês",4219.38,0.79810000000000003,3367.49,0.1605,677.01,0,0,0,0,0,0,8.0000000000000004E-4,3.48,0,0,7.1400000000000005E-2,301.42,2.3999999999999998E-3,9.98,1.0331999999999999,4359.37,8578.76]
["P8173","Administrador júnior","mês",3097.97,0.79610000000000003,2466.29,0.2185,677.01,0,0,0,0,1.0699999999999999E-2,33.15,1E-3,3.11,0,0,9.7299999999999998E-2,301.42,3.2000000000000002E-3,9.98,1.1269,3490.96,6588.93]
["P8174","Administrador pleno","mês",4130.62,0.79610000000000003,3288.39,0.16389999999999999,677.01,0,0,0,0,0,0,8.0000000000000004E-4,3.11,0,0,7.2999999999999995E-2,301.42,2.3999999999999998E-3,9.98,1.0361,4279.91,8410.5300000000007]
["P8175","Administrador sênior","mês",7233.66,0.79610000000000003,5758.72,9.3600000000000003E-2,677.01,0,0,0,0,0,0,4.0000000000000002E-4,3.11,0,0,4.1700000000000001E-2,301.42,1.4E-3,9.98,0.93320000000000003,6750.24,13983.9]
["P8180","Engenheiro agrimensor júnior","mês",11067,0.79330000000000001,8779.4500000000007,6.1199999999999997E-2,677.01,2.3999999999999998E-3,26.03,0,0,0,0,2.0000000000000001E-4,2.71,0,0,2.7199999999999998E-2,301.42,8.9999999999999998E-4,9.98,0.88519999999999999,9796.59,20863.59]
["P8181","Engenheiro agrimensor pleno","mês",11198.11,0.79330000000000001,8883.4599999999991,6.0499999999999998E-2,677.01,2.3E-3,26.03,0,0,0,0,2.0000000000000001E-4,2.71,0,0,2.69E-2,301.42,8.9999999999999998E-4,9.98,0.8841,9900.6,21098.71]
["P8182","Engenheiro agrimensor sênior","mês",12047.23,0.79330000000000001,9557.07,5.62E-2,677.01,2.2000000000000001E-3,26.03,0,0,0,0,2.0000000000000001E-4,2.71,0,0,2.5000000000000001E-2,301.42,8.0000000000000004E-4,9.98,0.87770000000000004,10574.21,22621.439999999999]
["P8183","Geógrafo júnior","mês",3351.22,0.79430000000000001,2661.87,0.20200000000000001,677.01,7.7999999999999996E-3,26.03,0,0,5.4000000000000003E-3,17.96,8.0000000000000004E-4,2.71,0,0,8.9899999999999994E-2,301.42,3.0000000000000001E-3,9.98,1.1032,3696.98,7048.19]
["P8184","Geógrafo pleno","mês",4468.29,0.79430000000000001,3549.16,0.1515,677.01,5.7999999999999996E-3,26.03,0,0,0,0,5.9999999999999995E-4,2.71,0,0,6.7500000000000004E-2,301.42,2.2000000000000001E-3,9.98,1.0219,4566.3100000000004,9034.6]
["P8185","Geógrafo sênior","mês",8514.33,0.79430000000000001,6762.93,7.9500000000000001E-2,677.01,3.0999999999999999E-3,26.03,0,0,0,0,2.9999999999999997E-4,2.71,0,0,3.5400000000000001E-2,301.42,1.1999999999999999E-3,9.98,0.91379999999999995,7780.08,16294.41]
["P8186","Antropólogo júnior","mês",3165.46,0.80720000000000003,2555.16,0.21390000000000001,677.01,8.2000000000000007E-3,26.03,0,0,9.1999999999999998E-3,29.1,1.5E-3,4.66,0,0,9.5200000000000007E-2,301.42,3.2000000000000002E-3,9.98,1.1383000000000001,3603.36,6768.82]
["P8187","Antropólogo pleno","mês",4220.6099999999997,0.80720000000000003,3406.88,0.16039999999999999,677.01,6.1999999999999998E-3,26.03,0,0,0,0,1.1000000000000001E-3,4.66,0,0,7.1400000000000005E-2,301.42,2.3999999999999998E-3,9.98,1.0487,4425.97,8646.58]
["P8188","Antropólogo sênior","mês",6078.95,0.80720000000000003,4906.93,0.1114,677.01,4.3E-3,26.03,0,0,0,0,8.0000000000000004E-4,4.66,0,0,4.9599999999999998E-2,301.42,1.6000000000000001E-3,9.98,0.9748,5926.02,12004.97]
["P8189","Arqueólogo júnior","mês",3085.16,0.82709999999999995,2551.7399999999998,0.21940000000000001,677.01,8.3999999999999995E-3,26.03,0,0,1.0999999999999999E-2,33.92,2E-3,6.32,0,0,9.7699999999999995E-2,301.42,3.2000000000000002E-3,9.98,1.169,3606.42,6691.58]
["P8190","Arqueólogo pleno","mês",4113.55,0.82709999999999995,3402.32,0.1646,677.01,6.3E-3,26.03,0,0,0,0,1.5E-3,6.32,0,0,7.3300000000000004E-2,301.42,2.3999999999999998E-3,9.98,1.0751999999999999,4423.07,8536.6200000000008]
["P8191","Arqueólogo sênior","mês",5832.14,0.82709999999999995,4823.76,0.11609999999999999,677.01,4.4999999999999997E-3,26.03,0,0,0,0,1.1000000000000001E-3,6.32,0,0,5.1700000000000003E-2,301.42,1.6999999999999999E-3,9.98,1.0021,5844.52,11676.66]
["P8192","Historiador júnior","mês",3325.64,0.79669999999999996,2649.54,0.2036,677.01,7.7999999999999996E-3,26.03,0,0,5.8999999999999999E-3,19.489999999999998,1.1000000000000001E-3,3.69,0,0,9.06E-2,301.42,3.0000000000000001E-3,9.98,1.1087,3687.15,7012.79]
["P8193","Historiador pleno","mês",4434.18,0.79669999999999996,3532.71,0.1527,677.01,5.8999999999999999E-3,26.03,0,0,0,0,8.0000000000000004E-4,3.69,0,0,6.8000000000000005E-2,301.42,2.3E-3,9.98,1.0263,4550.84,8985.02]
["P8194","Historiador sênior","mês",7403.84,0.79669999999999996,5898.64,9.1399999999999995E-2,677.01,3.5000000000000001E-3,26.03,0,0,0,0,5.0000000000000001E-4,3.69,0,0,4.07E-2,301.42,1.2999999999999999E-3,9.98,0.93420000000000003,6916.76,14320.6]
["P8195","Paleontólogo júnior","mês",3141.84,0.79810000000000003,2507.5100000000002,0.2155,677.01,8.3000000000000001E-3,26.03,0,0,9.7000000000000003E-3,30.52,1.1999999999999999E-3,3.91,0,0,9.5899999999999999E-2,301.42,3.2000000000000002E-3,9.98,1.1318999999999999,3556.37,6698.22]
["P8196","Paleontólogo pleno","mês",4189.13,0.79810000000000003,3343.34,0.16159999999999999,677.01,6.1999999999999998E-3,26.03,0,0,0,0,8.9999999999999998E-4,3.91,0,0,7.1999999999999995E-2,301.42,2.3999999999999998E-3,9.98,1.0411999999999999,4361.6899999999996,8550.81]
["P8197","Paleontólogo sênior","mês",6069.84,0.79810000000000003,4844.34,0.1115,677.01,4.3E-3,26.03,0,0,0,0,5.9999999999999995E-4,3.91,0,0,4.9700000000000001E-2,301.42,1.6000000000000001E-3,9.98,0.96589999999999998,5862.69,11932.53]
["P8198","Sociólogo júnior","mês",3782.76,0.81910000000000005,3098.46,0.17899999999999999,677.01,6.8999999999999999E-3,26.03,0,0,0,0,1.5E-3,5.55,0,0,7.9699999999999993E-2,301.42,2.5999999999999999E-3,9.98,1.0887,4118.4399999999996,7901.19]
["P8199","Sociólogo pleno","mês",5043.67,0.81910000000000005,4131.2700000000004,0.13420000000000001,677.01,5.1999999999999998E-3,26.03,0,0,0,0,1.1000000000000001E-3,5.55,0,0,5.9799999999999999E-2,301.42,2E-3,9.98,1.0213000000000001,5151.26,10194.93]
["P8200","Sociólogo sênior","mês",7915.13,0.81910000000000005,6483.28,8.5500000000000007E-2,677.01,3.3E-3,26.03,0,0,0,0,6.9999999999999999E-4,5.55,0,0,3.8100000000000002E-2,301.42,1.2999999999999999E-3,9.98,0.94799999999999995,7503.26,15418.39]
["Fonte: FGV IBRE"]