{"text_format":"2","workbook":"xlsx","n_sheets":17,"sheets":["PFP","PFP1.1_Topo","PFP1.2_Geo","PFP1.3_Amb","PFP2.1_FatorKa","PFP2.2_FatorKb","PFP2.3_FatorKc","PFP3_FatorKd","CRO1_Ins-Pro","Cronograma Físico-Financeiro","Planilha de Medição","CPU HOSPEDAGEM","CPU-VEICULO_PickUp","DNIT TC - 072023","DNIT TC - 012023","DNIT TC -042023","SINAPI_ES_RN"],"not_rendered":{"charts":0,"images":2,"macros":0,"external_links":43,"defined_names":6269,"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 Santana do Matos, no Estado do Rio Grande do Norte ",{"$nulls":4},"12ª SR CODEVASF",null,null,null,"2024-05-17"]
["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]
["CODE","LO","V1","Diárias","dia",{"$f":"'CRO1_Ins-Pro'!D12","v":70},{"$f":"'CPU HOSPEDAGEM'!C19","v":0},0,{"$f":"PFP3_FatorKd!$E$17","v":1},0,0]
["CODE","LO","V2","Pick-up cabine dupla ","dia",{"$f":"'CRO1_Ins-Pro'!D13","v":70},{"$f":"'CPU-VEICULO_PickUp'!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]
["CODE","SU","TOP","Total Serviços Cartográficos","un",{"$f":"'CRO1_Ins-Pro'!D17","v":1},"-",{"$f":"'PFP1.1_Topo'!H23","v":0},"-","-",0]
["CODE","SU","GEO","Total Serviços Geotécnicos","un",{"$f":"'CRO1_Ins-Pro'!D18","v":1},"-",{"$f":"'PFP1.2_Geo'!H35","v":0},"-","-",0]
["CODE","SU","AMB","Total Serviços Ambientais","un",{"$f":"'CRO1_Ins-Pro'!D19","v":1},"-",{"$f":"'PFP1.3_Amb'!H29","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":"ROUND(H25-H23,2)","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":33,"n_cols":12,"rows_kept":33,"cut":false,"hidden":false,"merged":[[28,9,28,10],[30,9,31,11],[32,9,32,10],[24,0,24,5],[29,9,29,10],[28,0,28,7],[29,0,29,7],[25,0,25,7],[26,0,26,7],[27,0,27,7],[15,10,15,11],[20,9,20,10],[21,10,21,11],[23,9,23,10],[24,10,24,11],[10,9,11,11],[12,9,13,9],[12,10,13,10],[12,11,13,11],[14,9,14,11],[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,{"$f":"PFP!J5","v":"Data base: "}]
[{"$f":"PFP!A6","v":"Estudos e Projeto Básico do Sistema Adutor de Santana do Matos, no Estado do Rio Grande do Norte "},null,null,null,"12ª SR CODEVASF",null,null,{"$f":"PFP!J6","v":"2024-05-17"}]
["Referência","Código","Insumos","Uni","Qde","Custo Unitário (PU)","Custo Total","Preço Total (PT)"]
["TP08","CODE","Nivelamento Geométrico classe IIN","km",42,null,{"$f":"ROUND(F8*E8,2)","v":0},{"$f":"G8*1.1469","v":0}]
["TP09","CODE","Nivelamento Geométrico classe IIN (Secções)","km",{"$f":"(42000/20)*0.012","v":25.2},null,0,{"$f":"G9*1.1469","v":0}]
["EMOP/COMPOSIÇÃO","01.016.0035-0","Poligonal Classe IIP (Locação)","km",42,null,0,0]
["CPOS/CDHU/COMPOSIÇÃO","01.20.921","Pontos GPS de dupla frequencia (L1/L2)","un",10,null,0,0,null,"MEMÓRIA DE CALCULO DO BDI DE FORNECIMENTO"]
["TP20","CODE","Levantamento Ecobatimetrico","ha ",2,null,0,0]
["TP21","CODE","Levantamento Topobatimétrico","km",2,null,0,0,null,"ITEM","DISCRIMINAÇÃO","PERC.    (%)"]
["TP23","CODE","Cadastro Físico (Faixa domínio e instalações)","ha ",50,null,0,0]
["TP24","CODE","Cadastro Agrícola (Faixa domínio e instalações)","ha ",50,null,0,0]
["TP25","CODE","Cadastro Jurídico (Faixa domínio e instalações)","ha ",50,null,0,0,null,"1.00","Despesas Indiretas"]
["TP26","CODE","Cadastro Socioeconomico (Faixa domínio e instalações)","ha ",50,null,0,0,null,"A1","Seguro e Garantia"]
["ORSE/INSUMO",4369,"Marco de Concreto (12x18x60cm)","un",{"$f":"E11","v":10},null,0,0,null,"A2","Riscos e Imprevistos"]
["EMBASA/INSUMO","D059722497","Estaca Testemunha de Madeira (2x4x70cm)","un",210,null,0,0,null,"A3","Despesas Financeiras"]
["SEINFRA/INSUMO","I1652","Piquetes de Madeira (2x2x20cm)","un",2100,null,0,0,null,"A4","Administração Central"]
["PD06","CODE","Picada Manual p/ levantamento TP","km",42,null,0,0,null,"Total do Grupo A =",null,{"$f":"SUM(L17:L20)","v":0}]
["PD08","CODE","Picada c/ Trator de Esteira","km",4,null,0,0,null,"2.00","Benefício"]
["TOTAL SERVIÇOS TOPOGRÁFICOS:",{"$nulls":5},{"$f":"SUM(G8:G22)","v":0},{"$f":"SUM(H8:H22)","v":0},null,"B1","LUCRO"]
["BDI:",{"$nulls":6},{"$f":"L33","v":0},null,"Total do Grupo B =",null,{"$f":"L23","v":0}]
["TOTAL SERVIÇOS TOPOGRÁFICOS COM BDI:",{"$nulls":8},"3.00","Impostos"]
["OBSERVAÇÃO:",{"$nulls":8},"C1","PIS / PASEP"]
["Uni - unidade de medição do insumo;",{"$nulls":8},"C2","COFINS"]
["Qde - Quantidade do Insumo (não pode ocorrer alteração pela Licitante)",{"$nulls":8},"C3","ISS"]
["PU - Preço Unitário (composições padrão da Codevasf, já incluso o FatorK)",{"$nulls":8},"Total do Grupo C =",null,{"$f":"SUM(L26:L28)","v":0}]
["PT - Preço Total (incluído encargos, taxas e impostos) - PT = Qde x PU",{"$nulls":8},"Fórmula Para Cálculo do B.D.I"]
[{"$nulls":9},"BDI =(((1+A4+A1+A2)*(1+A3)*(1+B))/(1-C))-1"]
[]
[{"$nulls":9},"Bonificação Sobre Despesas indiretas (B.D.I) =",null,{"$f":"(((1+L20+L17+L18)*(1+L19)*(1+L24))/(1-L29))-1","v":0}]

{"sheet":"PFP1.2_Geo","index":2,"n_rows":47,"n_cols":13,"rows_kept":47,"cut":false,"hidden":false,"merged":[[42,10,42,11],[43,10,43,11],[44,10,45,12],[46,10,46,11],[36,0,36,5],[29,11,29,12],[34,10,34,11],[35,11,35,12],[37,10,37,11],[38,11,38,12],[24,10,25,12],[26,10,27,10],[26,11,27,11],[26,12,27,12],[28,10,28,12],[34,0,34,5],[40,0,40,7],[5,0,5,3],[5,4,5,5],[41,0,41,7],[37,0,37,7],[38,0,38,7],[39,0,39,7],[4,0,4,3],[4,4,4,5],[2,0,2,7],[3,0,3,7],[0,0,1,5]]}
["SERVIÇOS GEOLÓGICOS/GEOTÉCNICOS",{"$nulls":6},"CODIGO:"]
[{"$nulls":7},"PFP-1.2"]
["NOME DA EMPRESA:"]
[]
["PROJETO:",null,null,null,"CONTRATANTE:",null,null,{"$f":"'PFP1.1_Topo'!H5","v":"Data base: "}]
[{"$f":"PFP!A6","v":"Estudos e Projeto Básico do Sistema Adutor de Santana do Matos, no Estado do Rio Grande do Norte "},null,null,null,"12ª SR CODEVASF",null,null,{"$f":"'PFP1.1_Topo'!H6","v":"2024-05-17"}]
["Código","Referência","Insumos","Uni","Qde","Custo Unitário (PU)","Custo Total","Preço Total (PT)"]
["A.07.000.020350","CPOS","Sondagem Rotativa: (Des)Mobilização","un",1,null,{"$f":"ROUND(F8*E8,2)","v":0},{"$f":"G8*1.1469","v":0}]
["01.002.0015-0","EMOP","Sondagem Rotativa: Ø N em rochas","m",50,null,{"$f":"ROUND(F9*E9,2)","v":0},{"$f":"G9*1.1469","v":0}]
["01.002.0003-A","EMOP","Sondagem Rotativa: Ø N em solo","m",30,null,{"$f":"ROUND(F10*E10,2)","v":0},0]
["GT04","CODE","Sondagem Rotativa: Desl/Inst 0-200 m","un",0,"Já incluso*",0,0]
["GT05","CODE","Sondagem Rotativa: Desl/Inst 201-500 m","un",0,"Já incluso*",0,0]
["GT06","CODE","Sondagem Rotativa: Desl/Inst >500 m","un",0,"Já incluso*",0,0]
["A.07.000.020476","CPOS","Sondagem Percussão: (Des)Mobilização","un",4,null,{"$f":"ROUND(F14*E14,2)","v":0},0]
["A.07.000.020483","CPOS","Sondagem Percursão: com SPT","m",100,null,0,0]
[200204,"SIURB","Sondagem Percursão: Desloc/Instalação 0-200 m","un",2,null,0,0]
[200205,"SIURB","Sondagem Percursão: Desloc/Instalação 201-500 m","un",8,null,0,0,null,"Estimativa para cálculo do poço de inspeção"]
["32.01.01","EMBASA","Sondagem Trado","m",30,null,0,0,null,"Comprimento:",1]
["95.03.01","SUDECAP/INSUMO","Poço de Inspeção","m",200,null,0,0,null,"Pronfundidade:",1]
[null,null,"Ensaios de caractrização do solo",{"$nulls":4},0,null,"Base:",0.3]
["34.01.23","EMBASA","Ensaio: Umidade Natural ","un",20,null,{"$f":"ROUND(F21*E21,2)","v":0},0,null,"Volume (m³):",{"$f":"K20*K19*K18","v":0.3}]
["01.001.0091-A","EMOP","Ensaio: Densidade Natural","un",20,null,0,0,null,"A largura da base é a mesma largura da concha de uma retroescavadeira"]
["ED-49553","SETOP","Ensaio: Limite de Liquidez","un",20,null,0,0]
["ED-49554","SETOP","Ensaio: Limite de Plasticidade","un",20,null,0,0]
["ED-49552","SETOP","Ensaio: Granulometria por Peneiramento e Sedimentação","un",30,null,0,0,null,null,"MEMÓRIA DE CALCULO DO BDI DE FORNECIMENTO"]
[4685,"ORSE","Ensaio: Compactação Proctor Normal","un",20,null,0,0]
["34.01.16","EMBASA","Ensaio: Massa Especifica Real dos Grãos","un",20,null,0,0,null,null,"ITEM","DISCRIMINAÇÃO","PERC.    (%)"]
[null,null,"Ensaios de dispersão",{"$nulls":4},0]
["E200320120","EMBASA","Ensaio: Dispersão Granulometria Comparativa","un",10,null,{"$f":"ROUND(F29*E29,2)","v":0},0]
["E200320121","EMBASA","Ensaio: Dispersão Crumb Test","un",10,null,{"$f":"ROUND(F30*E30,2)","v":0},0,null,null,"1.00","Despesas Indiretas"]
[null,null,"Ensaios de análise da areia",{"$nulls":4},0,null,null,"A1","Seguro e Garantia"]
["GT6.1.16.2","CODE","Ensaio: Mineralogia da Areia","un",5,null,{"$f":"ROUND(F32*E32,2)","v":0},0,null,null,"A2","Riscos e Imprevistos"]
["01.001.0009-A","EMOP","Ensaio: Equivalente de Areia","un",5,null,{"$f":"ROUND(F33*E33,2)","v":0},0,null,null,"A3","Despesas Financeiras"]
["34.05.30","EMBASA","Ensaio: Teor de Matéria Orgânica","un",5,null,{"$f":"ROUND(F34*E34,2)","v":0},0,null,null,"A4","Administração Central"]
["TOTAL SERVIÇOS GEOTÉCNICOS",{"$nulls":5},{"$f":"SUM(G8:G34)","v":0},{"$f":"SUM(H8:H34)","v":0},null,null,"Total do Grupo A =",null,{"$f":"SUM(M31:M34)","v":0}]
["BDI:",{"$nulls":6},{"$f":"M47","v":0},null,null,"2.00","Benefício"]
["TOTAL SERVIÇOS TOPOGRÁFICOS COM BDI:",{"$nulls":9},"B1","LUCRO"]
["LEGENDA:",{"$nulls":9},"Total do Grupo B =",null,{"$f":"M37","v":0}]
["Uni - unidade de medição do insumo;",{"$nulls":9},"3.00","Impostos"]
["Qde - Quantidade do Insumo (não pode ocorrer alteração pela Licitante)",{"$nulls":9},"C1","PIS / PASEP"]
["PU - Preço Unitário (composições padrão da Codevasf, já incluso o FatorK)",{"$nulls":9},"C2","COFINS"]
["PT - Preço Total (incluído encargos, taxas e impostos) - PT = Qde x PU",{"$nulls":9},"C3","ISS"]
[{"$nulls":10},"Total do Grupo C =",null,{"$f":"SUM(M40:M42)","v":0}]
[{"$nulls":10},"Fórmula Para Cálculo do B.D.I"]
[{"$nulls":10},"BDI =(((1+A4+A1+A2)*(1+A3)*(1+B))/(1-C))-1"]
[]
[{"$nulls":10},"Bonificação Sobre Despesas indiretas (B.D.I) =",null,{"$f":"(((1+M34+M31+M32)*(1+M33)*(1+M38))/(1-M43))-1","v":0}]

{"sheet":"PFP1.3_Amb","index":3,"n_rows":40,"n_cols":13,"rows_kept":40,"cut":false,"hidden":false,"merged":[[35,10,35,11],[36,10,36,11],[37,10,38,12],[39,10,39,11],[30,0,30,5],[35,0,35,7],[33,0,33,7],[34,0,34,7],[22,11,22,12],[27,10,27,11],[28,11,28,12],[30,10,30,11],[31,11,31,12],[17,10,18,12],[19,10,20,10],[19,11,20,11],[19,12,20,12],[21,10,21,12],[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],[28,0,28,5],[31,0,31,7],[32,0,32,7]]}
["SERVIÇOS ANÁLISE AMBIENTAL",{"$nulls":6},"CODIGO:"]
[{"$nulls":7},"PFP-1.3"]
["NOME DA EMPRESA:"]
[]
["PROJETO:",null,null,null,"CONTRATANTE:",null,null,{"$f":"'PFP1.2_Geo'!H5","v":"Data base: "}]
[{"$f":"PFP!A6","v":"Estudos e Projeto Básico do Sistema Adutor de Santana do Matos, no Estado do Rio Grande do Norte "},null,null,null,"12ª SR CODEVASF",null,null,{"$f":"'PFP1.2_Geo'!H6","v":"2024-05-17"}]
["Código","Referência","Insumos","Uni","Qde","Custo Unitário (PU)","Custo Total","Preço Total (PT)"]
["33.01.02","EMBASA/COMPOSIÇÃO","Alcalinidade Total","un",3,null,{"$f":"ROUND(E8*F8,2)","v":0},{"$f":"G8*1.1469","v":0}]
["33.01.10","EMBASA/COMPOSIÇÃO","Condutividade","un",3,null,0,{"$f":"G9*1.1469","v":0}]
["33.01.13","EMBASA/COMPOSIÇÃO","DBO","un",3,null,0,0]
["33.01.13","EMBASA/COMPOSIÇÃO","DQO","un",3,null,0,0]
["\tF099703031","EMBASA/INSUMO","Salinidade","un",3,null,0,0]
["F099703048","EMBASA/INSUMO","Sólidos Dissolvidos Totais","un",3,null,0,0]
["33.02.71","EMBASA/COMPOSIÇÃO","Sólidos Suspensos","un",3,null,0,0]
["33.01.48","EMBASA/COMPOSIÇÃO","Sólidos Totais","un",3,null,0,0]
["33.01.51","EMBASA/COMPOSIÇÃO","Turbidez","un",3,null,0,0]
["33.01.38","EMBASA/COMPOSIÇÃO","Oxigênio Dissolvido","un",3,null,0,0]
["E200330139","EMBASA/INSUMO","pH","un",3,null,0,0,null,null,"MEMÓRIA DE CALCULO DO BDI DE FORNECIMENTO"]
["F099703027","EMBASA/INSUMO","Temperatura","un",3,null,0,0]
["F099703046","EMBASA/INSUMO","Fósforo Total","un",3,null,0,0,null,null,"ITEM","DISCRIMINAÇÃO","PERC.    (%)"]
["E200330130","EMBASA/INSUMO","Nitrogênio Amoniacal","un",3,null,0,0]
["E200330133","EMBASA/INSUMO","Nitrogênio Nitrato","un",3,null,0,0]
["E200330132","EMBASA/INSUMO","Nitrogênio Total","un",3,null,0,0,null,null,"1.00","Despesas Indiretas"]
["F099703058","EMBASA/INSUMO","Clorofila A","un",3,null,0,0,null,null,"A1","Seguro e Garantia"]
["F099703057","EMBASA/INSUMO","Coliformes Termotolerantes","un",3,null,0,0,null,null,"A2","Riscos e Imprevistos"]
["E200330128","EMBASA/INSUMO","Metais Pesados","un",3,null,0,0,null,null,"A3","Despesas Financeiras"]
["E200330140","EMBASA/INSUMO","Organoclorados","un",3,null,0,0,null,null,"A4","Administração Central"]
["E200330140","EMBASA/INSUMO","Organofosforado","un",3,null,0,0,null,null,"Total do Grupo A =",null,{"$f":"SUM(M24:M27)","v":0}]
["TOTAL SERVIÇOS GEOTÉCNICOS",{"$nulls":5},{"$f":"SUM(G8:G27)","v":0},{"$f":"SUM(H8:H28)","v":0},null,null,"2.00","Benefício"]
["BDI:",{"$nulls":6},{"$f":"M40","v":0},null,null,"B1","LUCRO"]
["TOTAL SERVIÇOS TOPOGRÁFICOS COM BDI:",{"$nulls":6},{"$f":"(G29*H30)+G29","v":0},null,null,"Total do Grupo B =",null,{"$f":"M30","v":0}]
["LEGENDA:",{"$nulls":9},"3.00","Impostos"]
["Uni - unidade de medição do insumo;",{"$nulls":9},"C1","PIS / PASEP"]
["Qde - Quantidade do Insumo (não pode ocorrer alteração pela Licitante)",{"$nulls":9},"C2","COFINS"]
["PU - Preço Unitário (composições padrão da Codevasf, já incluso o FatorK)",{"$nulls":9},"C3","ISS"]
["PT - Preço Total (incluído encargos, taxas e impostos) - PT = Qde x PU",{"$nulls":9},"Total do Grupo C =",null,{"$f":"SUM(M33:M35)","v":0}]
[{"$nulls":10},"Fórmula Para Cálculo do B.D.I"]
[{"$nulls":10},"BDI =(((1+A4+A1+A2)*(1+A3)*(1+B))/(1-C))-1"]
[]
[{"$nulls":10},"Bonificação Sobre Despesas indiretas (B.D.I) =",null,{"$f":"(((1+M27+M24+M25)*(1+M26)*(1+M31))/(1-M36))-1","v":0}]

{"sheet":"PFP2.1_FatorKa","index":4,"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 Santana do Matos, 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":5,"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 Santana do Matos, 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":6,"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 Santana do Matos, 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":7,"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 Santana do Matos, no Estado do Rio Grande do Norte "},null,"12ª SR CODEVASF"]
["Cod","DESCRIÇÃO1",null,"% preço2","% custo4","R$"]
["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$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+$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$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+$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$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+$F$12)","v":{"$error":"#DIV/0!"}}]
["K4.3","COFINS3 - aliquota efetiva aplicavel percentual-desconto",null,null,0,{"$f":"E11*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+$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":8,"n_rows":32,"n_cols":11,"rows_kept":32,"cut":false,"hidden":false,"merged":[[37,7,37,10],[19,0,20,0],[19,1,20,1],[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",70,{"$f":"PFP!G15","v":0},{"$f":"PFP!H15","v":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},2,5,2,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$",{"$f":"TRUNC(SUM(H20:K20),1)","v":{"$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 PARCIAL POR PRODUTO                            (80% DO VALOR TOTAL)                                       (ITEM 7.6 DO EDITAL)","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!"}}]
{"$rows_empty":9}
["TOTAL","VALOR PAGAMENTO DO PRODUTO FINAL                                       (80% DO VALOR TOTAL)                                       (ITEM 7.6 DO EDITAL)","R$",{"$f":"SUM(H32:K32)","v":{"$error":"#DIV/0!"}},null,null,null,{"$f":"H20-H22","v":{"$error":"#DIV/0!"}},{"$f":"I20-I22","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]

{"sheet":"Cronograma Físico-Financeiro","index":9,"n_rows":19,"n_cols":15,"rows_kept":19,"cut":false,"hidden":false,"merged":[[8,1,9,1],[8,2,9,2],[0,1,1,4],[4,1,5,1],[4,2,5,2],[6,1,7,1],[6,2,7,2],[10,1,11,1],[10,2,11,2],[13,1,14,2],[15,2,16,2],[17,1,18,2]]}
[null,"CRONOGRAMA FÍSICO-FINANCEIRO"]
[]
[]
[null,null,null,"Mês 1","Mês 2","Mês 3","Mês 4","Mês 5","Mês 6","Mês 7","Mês 8","Mês 9","Mês 10","Mês 11"]
[null,"Estudos Básicos (EB)",{"$f":"'CRO1_Ins-Pro'!H20","v":{"$error":"#DIV/0!"}},{"$f":"D6*$C$5","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"M6*$C$5","v":{"$error":"#DIV/0!"}},{"$f":"N6*$C$5","v":{"$error":"#DIV/0!"}},{"$f":"SUM(D5:M5)","v":{"$error":"#DIV/0!"}}]
[null,null,null,0.1,0.55000000000000004,null,0.35,{"$nulls":7},1]
[null,"Estudo de Viabilidade Técnica, Econômica e Ambiental (EVTEA)",{"$f":"'CRO1_Ins-Pro'!I20","v":{"$error":"#DIV/0!"}},{"$f":"D8*$C$7","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[{"$nulls":4},0.15,0.85,{"$nulls":8},1]
[null,"Estudos Ambientais (EA)",{"$f":"'CRO1_Ins-Pro'!J20","v":{"$error":"#DIV/0!"}},{"$f":"D10*$C$9","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[{"$nulls":4},0,1,{"$nulls":8},1]
[null,"Projeto Básico (PB)",{"$f":"'CRO1_Ins-Pro'!K20","v":{"$error":"#DIV/0!"}},{"$f":"D12*$C$11","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[{"$nulls":7},0,0.25,0.75,{"$nulls":4},1]
[]
[null,"NO MÊS",null,{"$f":"D5+D7+D9+D11","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"M5+M7+M9+M11","v":{"$error":"#DIV/0!"}},{"$f":"N5+N7+N9+N11","v":{"$error":"#DIV/0!"}},{"$f":"SUM(D14:M14)","v":{"$error":"#DIV/0!"}}]
[null,null,null,{"$f":"D14/SUM($C$5:$C$12)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"G14/SUM($C$5:$C$12)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"SUM(D15:M15)","v":{"$error":"#DIV/0!"}}]
[null,null,"DESEMBOLSO         (80% do Subproduto) ",{"$f":"D14*0.8","v":{"$error":"#DIV/0!"}},{"$f":"E14*0.8","v":{"$error":"#DIV/0!"}},{"$f":"F14*0.8 + (0.2*O7) + (0.2*O9)","v":{"$error":"#DIV/0!"}},{"$f":"G14*0.8+(O5*0.2)","v":{"$error":"#DIV/0!"}},{"$f":"H14*0.8","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"J14*0.8+(O11*0.2)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"SUM(D16:M16)","v":{"$error":"#DIV/0!"}}]
[null,null,null,{"$f":"D16/SUM($C$5,$C$7,$C$9,$C$11)","v":{"$error":"#DIV/0!"}},{"$f":"E16/SUM($C$5,$C$7,$C$9,$C$11)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"SUM(D17:M17)","v":{"$error":"#DIV/0!"}}]
[null,"ACUMULADO",null,{"$f":"D16","v":{"$error":"#DIV/0!"}},{"$f":"D18+E16","v":{"$error":"#DIV/0!"}},{"$f":"E18+F16","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"TRUNC(I18+J16,1)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"L18+M16","v":{"$error":"#DIV/0!"}},{"$f":"M18+N16","v":{"$error":"#DIV/0!"}}]
[null,null,null,{"$f":"D15","v":{"$error":"#DIV/0!"}},{"$f":"D19+E15","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]

{"sheet":"Planilha de Medição","index":10,"n_rows":29,"n_cols":9,"rows_kept":29,"cut":false,"hidden":false,"merged":[[0,1,2,8],[4,1,4,2]]}
[null,"PLANILHA DE MEDIÇÃO"]
[]
[]
[]
[null,"#",null,"DESCRIÇÃO","P. PARCIAL (80%)","P. GLOBAL","P. UNITÁRIO","P. TOTAL","% PRODUTO"]
[null,1,1,"Estudos Básicos (EB)",null,null,null,{"$f":"'CRO1_Ins-Pro'!H20","v":{"$error":"#DIV/0!"}},{"$f":"H6/$H$29","v":{"$error":"#DIV/0!"}}]
[null,1,"1.1","Estudo Preliminares",{"$f":"H7*0.8","v":{"$error":"#DIV/0!"}},{"$f":"H7","v":{"$error":"#DIV/0!"}},null,{"$f":"$H$6*I7","v":{"$error":"#DIV/0!"}},{"$f":"1-(I8+I9+I10)","v":{"$error":"#DIV/0!"}}]
[null,1,"1.2","Estudo Hidrológicos/Demanda",{"$f":"H8*0.8","v":{"$error":"#DIV/0!"}},{"$f":"H8-G8","v":{"$error":"#DIV/0!"}},{"$f":"'CRO1_Ins-Pro'!F19","v":0},{"$f":"$H$6*I8","v":{"$error":"#DIV/0!"}},0.17080000000000001]
[null,1,"1.3","Estudo Topográfico/Cartográfico",{"$f":"H9*0.8","v":0},null,{"$f":"H9","v":0},{"$f":"'CRO1_Ins-Pro'!F17","v":0},{"$f":"H9/H6","v":{"$error":"#DIV/0!"}}]
[null,1,"1.4","Serviços Geológicos/Geotécnicos",{"$f":"H10*0.8","v":0},null,{"$f":"H10","v":0},{"$f":"'CRO1_Ins-Pro'!F18","v":0},{"$f":"H10/H6","v":{"$error":"#DIV/0!"}}]
[null,2,2,"Estudo de Viabilidade Técnica, Econômica e Ambiental (EVTEA)",null,null,null,{"$f":"'CRO1_Ins-Pro'!I20","v":{"$error":"#DIV/0!"}},{"$f":"H11/$H$29","v":{"$error":"#DIV/0!"}}]
[null,2,"2.1","Estudo de Concepção de Alternativas",{"$f":"H12*0.8","v":{"$error":"#DIV/0!"}},{"$f":"H12-G12","v":{"$error":"#DIV/0!"}},null,{"$f":"I12*$H$11","v":{"$error":"#DIV/0!"}},0.12330000000000001]
[null,2,"2.2","Estudo Técnico",{"$f":"H13*0.8","v":{"$error":"#DIV/0!"}},{"$f":"H13-G13","v":{"$error":"#DIV/0!"}},null,{"$f":"I13*$H$11","v":{"$error":"#DIV/0!"}},0.21640000000000001]
[null,2,"2.3","Estudo Ambiental",{"$f":"H14*0.8","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},0.15509999999999999]
[null,2,"2.4","Estudo Econômico",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},0.13289999999999999]
[null,2,"2.5","Estudo de Seleção",{"$f":"H16*0.8","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},0.20119999999999999]
[null,2,"2.6","Estudo Consolidado e Peças Complementares",{"$f":"H17*0.8","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},{"$f":"1-SUM(I12:I16)","v":0.17110000000000003}]
[null,3,3,"Estudos Ambientais (EA)",null,null,null,{"$f":"'CRO1_Ins-Pro'!J20","v":{"$error":"#DIV/0!"}},{"$f":"H18/$H$29","v":{"$error":"#DIV/0!"}}]
[null,4,4,"Projeto Básico (PB)",null,null,null,{"$f":"'CRO1_Ins-Pro'!K20","v":{"$error":"#DIV/0!"}},{"$f":"H19/$H$29","v":{"$error":"#DIV/0!"}}]
[null,4,"4.1","Projeto de Terraplenagem e Urbanização",{"$f":"H20*0.8","v":{"$error":"#DIV/0!"}},{"$f":"H20-G20","v":{"$error":"#DIV/0!"}},null,{"$f":"I20*$H$19","v":{"$error":"#DIV/0!"}},0.1109]
[null,4,"4.2","Projeto de Edificações, Fundações e Elementos Civis",{"$error":"#DIV/0!"},{"$f":"H21-G21","v":{"$error":"#DIV/0!"}},null,{"$f":"I21*$H$19","v":{"$error":"#DIV/0!"}},0.14149999999999999]
[null,4,"4.3","Projeto de Hidromecânico",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},0.3125]
[null,4,"4.4","Projeto Elétrico, Automação e Controle",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},0.1545]
[null,4,"4.5","Projeto Fundiário e de Desapropriação",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},5.6899999999999999E-2]
[null,4,"4.6","Orçamento e Especificações Técnicas",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},8.7599999999999997E-2]
[null,4,"4.7","Projeto Consolidado e Peças Complementares ",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},{"$f":"1-SUM(I20:I25)","v":0.13610000000000011}]
[]
[]
[{"$nulls":7},{"$f":"TRUNC(H6+H11+H18+H19,1)","v":{"$error":"#DIV/0!"}},{"$f":"I19+I18+I11+I6","v":{"$error":"#DIV/0!"}}]

{"sheet":"CPU HOSPEDAGEM","index":11,"n_rows":19,"n_cols":2,"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:"]
[null,"Custo Mensal por pessoa:"]
[null,"Custo diário por pessoa:"]
[null,"número de pessoas:"]
[null,"Alimentação:"]
[]
[null,"Diária Total (alimentação + hospedagem):"]

{"sheet":"CPU-VEICULO_PickUp","index":12,"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:","2024-01-22",null,"CV","Média","Mediana",null,null,null,"CV","Média","Mediana",{"$nulls":8},"CV","Média","Mediana"]
["CODEVASF ",null,null,null,{"$f":"_xlfn.STDEV.S(E10:H10)/AVERAGE(E10:H10)","v":{"$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"]
["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"]
["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":"DNIT TC - 072023","index":13,"n_rows":101,"n_cols":25,"rows_kept":101,"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]

{"sheet":"DNIT TC - 012023","index":14,"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",4298.3599999999997,0.79710000000000003,3426.22,0.1575,677.01,8.8999999999999999E-3,38.08,0,0,0,0,8.0000000000000004E-4,3.43,0,0,7.0199999999999999E-2,301.75,2.3E-3,9.98,1.0367999999999999,4456.47,8754.83]
["P8002","Advogado pleno","mês",5731.15,0.79710000000000003,4568.3,0.1181,677.01,6.6E-3,38.08,0,0,0,0,5.9999999999999995E-4,3.43,0,0,5.2699999999999997E-2,301.75,1.6999999999999999E-3,9.98,0.97689999999999999,5598.54,11329.69]
["P8003","Advogado sênior","mês",9757.66,0.79710000000000003,7777.83,6.9400000000000003E-2,677.01,3.8999999999999998E-3,38.08,0,0,0,0,4.0000000000000002E-4,3.43,0,0,3.09E-2,301.75,1E-3,9.98,0.90269999999999995,8808.08,18565.740000000002]
["P8007","Analista de desenvolvimento de sistemas júnior","mês",3651.52,0.79510000000000003,2903.32,0.18540000000000001,677.01,0,0,0,0,0,0,8.9999999999999998E-4,3.33,0,0,8.2600000000000007E-2,301.75,2.7000000000000001E-3,9.98,1.0668,3895.39,7546.9]
["P8008","Analista de desenvolvimento de sistemas pleno","mês",4868.6899999999996,0.79510000000000003,3871.09,0.1391,677.01,0,0,0,0,0,0,6.9999999999999999E-4,3.33,0,0,6.2E-2,301.75,2E-3,9.98,0.99890000000000001,4863.16,9731.85]
["P8009","Analista de desenvolvimento de sistemas sênior","mês",8775.73,0.79510000000000003,6977.58,7.7100000000000002E-2,677.01,0,0,0,0,0,0,4.0000000000000002E-4,3.33,0,0,3.44E-2,301.75,1.1000000000000001E-3,9.98,0.90810000000000002,7969.65,16745.38]
["P8013","Arquiteto júnior","mês",11067,0.79339999999999999,8780.56,6.1199999999999997E-2,677.01,3.3999999999999998E-3,38.08,0,0,0,0,2.0000000000000001E-4,2.4900000000000002,0,0,2.7300000000000001E-2,301.75,8.9999999999999998E-4,9.98,0.88639999999999997,9809.86,20876.86]
["P8014","Arquiteto pleno","mês",11353.02,0.79339999999999999,9007.49,5.96E-2,677.01,3.3999999999999998E-3,38.08,0,0,0,0,2.0000000000000001E-4,2.4900000000000002,0,0,2.6599999999999999E-2,301.75,8.9999999999999998E-4,9.98,0.8841,10036.790000000001,21389.81]
["P8015","Arquiteto sênior","mês",14013.69,0.79339999999999999,11118.47,4.8300000000000003E-2,677.01,2.7000000000000001E-3,38.08,0,0,0,0,2.0000000000000001E-4,2.4900000000000002,0,0,2.1499999999999998E-2,301.75,6.9999999999999999E-4,9.98,0.8669,12147.77,26161.47]
["P8019","Assistente social júnior","mês",2676.07,0.80179999999999996,2145.6799999999998,0.253,677.01,1.4200000000000001E-2,38.08,0,0,2.18E-2,58.47,1.6000000000000001E-3,4.21,0,0,0.1128,301.75,3.7000000000000002E-3,9.98,1.2089000000000001,3235.16,5911.24]
["P8020","Assistente social pleno","mês",3568.1,0.80179999999999996,2860.9,0.18970000000000001,677.01,1.0699999999999999E-2,38.08,0,0,1.4E-3,4.95,1.1999999999999999E-3,4.21,0,0,8.4599999999999995E-2,301.75,2.8E-3,9.98,1.0921000000000001,3896.87,7464.96]
["P8021","Assistente social sênior","mês",6285.93,0.80179999999999996,5040.0600000000004,0.1077,677.01,6.1000000000000004E-3,38.08,0,0,0,0,6.9999999999999999E-4,4.21,0,0,4.8000000000000001E-2,301.75,1.6000000000000001E-3,9.98,0.96579999999999999,6071.08,12357]
["P8025","Auxiliar","mês",1401.01,0.80130000000000001,1122.6300000000001,0.48320000000000002,677.01,0,0,1.1999999999999999E-3,1.74,9.6299999999999997E-2,134.97,2.5000000000000001E-3,3.47,0,0,0.21540000000000001,301.75,7.1000000000000004E-3,9.98,1.6071,2251.5500000000002,3652.57]
["P8026","Auxiliar administrativo","mês",1681.55,0.80220000000000002,1348.94,0.40260000000000001,677.01,0,0,0,0,7.0300000000000001E-2,118.14,2.5999999999999999E-3,4.29,0,0,0.1794,301.75,5.8999999999999999E-3,9.98,1.4630000000000001,2460.11,4141.66]
["P8027","Auxiliar de laboratório","mês",1553.91,0.79930000000000001,1242.04,0.43569999999999998,677.01,0,0,2.8E-3,4.3,8.1000000000000003E-2,125.8,2.8E-3,4.28,0,0,0.19420000000000001,301.75,6.4000000000000003E-3,9.98,1.5221,2365.17,3919.08]
["P8028","Auxiliar de topografia","mês",1401.01,0.79969999999999997,1120.3900000000001,0.48320000000000002,677.01,2.8000000000000001E-2,39.18,1.2999999999999999E-3,1.87,9.6299999999999997E-2,134.97,3.0999999999999999E-3,4.3099999999999996,0,0,0.21540000000000001,301.75,7.1000000000000004E-3,9.98,1.6341000000000001,2289.46,3690.47]
["P8032","Biólogo júnior","mês",3034.42,0.79590000000000005,2415.1,0.22309999999999999,677.01,1.2500000000000001E-2,38.08,0,0,1.2200000000000001E-2,36.97,1.1000000000000001E-3,3.26,0,0,9.9400000000000002E-2,301.75,3.3E-3,9.98,1.1475,3482.14,6516.56]
["P8033","Biólogo pleno","mês",4045.9,0.79590000000000005,3220.13,0.1673,677.01,9.4000000000000004E-3,38.08,0,0,0,0,8.0000000000000004E-4,3.26,0,0,7.46E-2,301.75,2.5000000000000001E-3,9.98,1.0505,4250.2,8296.1]
["P8034","Biólogo sênior","mês",6946.81,0.79590000000000005,5528.97,9.7500000000000003E-2,677.01,5.4999999999999997E-3,38.08,0,0,0,0,5.0000000000000001E-4,3.26,0,0,4.3400000000000001E-2,301.75,1.4E-3,9.98,0.94420000000000004,6559.04,13505.85]
["P8038","Chefe de escritório","mês",3329.2,0.79830000000000001,2657.7,0.2034,677.01,0,0,0,0,5.7999999999999996E-3,19.28,8.9999999999999998E-4,3.06,0,0,9.06E-2,301.75,3.0000000000000001E-3,9.98,1.1020000000000001,3668.78,6997.98]
["P8040","Contador júnior","mês",3809.75,0.79710000000000003,3036.76,0.1777,677.01,0,0,0,0,0,0,8.0000000000000004E-4,3.06,0,0,7.9200000000000007E-2,301.75,2.5999999999999999E-3,9.98,1.0573999999999999,4028.56,7838.31]
["P8041","Contador pleno","mês",5079.67,0.79710000000000003,4049.01,0.1333,677.01,0,0,0,0,0,0,5.9999999999999995E-4,3.06,0,0,5.9400000000000001E-2,301.75,2E-3,9.98,0.99229999999999996,5040.8100000000004,10120.48]
["P8042","Contador sênior","mês",9426.86,0.79710000000000003,7514.15,7.1800000000000003E-2,677.01,0,0,0,0,0,0,2.9999999999999997E-4,3.06,0,0,3.2000000000000001E-2,301.75,1.1000000000000001E-3,9.98,0.90229999999999999,8505.9500000000007,17932.810000000001]
["P8044","Coordenador ambiental ","mês",14992.13,0.79490000000000005,11917.25,4.5199999999999997E-2,677.01,0,0,0,0,0,0,2.0000000000000001E-4,2.92,0,0,2.01E-2,301.75,6.9999999999999999E-4,9.98,0.86099999999999999,12908.91,27901.040000000001]
["P8045","Economista júnior","mês",4427.8900000000003,0.79390000000000005,3515.31,0.15290000000000001,677.01,0,0,0,0,0,0,5.9999999999999995E-4,2.65,0,0,6.8099999999999994E-2,301.75,2.3E-3,9.98,1.0178,4506.6899999999996,8934.58]
["P8046","Economista pleno","mês",5903.86,0.79390000000000005,4687.07,0.1147,677.01,0,0,0,0,0,0,4.0000000000000002E-4,2.65,0,0,5.11E-2,301.75,1.6999999999999999E-3,9.98,0.96179999999999999,5678.46,11582.32]
["P8047","Economista sênior","mês",10342.629999999999,0.79390000000000005,8211.02,6.5500000000000003E-2,677.01,0,0,0,0,0,0,2.9999999999999997E-4,2.65,0,0,2.92E-2,301.75,1E-3,9.98,0.88980000000000004,9202.4,19545.03]
["P8054","Engenheiro agrônomo júnior","mês",11067,0.79059999999999997,8749.57,6.1199999999999997E-2,677.01,3.3999999999999998E-3,38.08,0,0,0,0,2.0000000000000001E-4,2.2599999999999998,0,0,2.7300000000000001E-2,301.75,8.9999999999999998E-4,9.98,0.88360000000000005,9778.65,20845.650000000001]
["P8055","Engenheiro agrônomo pleno","mês",11980.97,0.79059999999999997,9472.16,5.6500000000000002E-2,677.01,3.2000000000000002E-3,38.08,0,0,0,0,2.0000000000000001E-4,2.2599999999999998,0,0,2.52E-2,301.75,8.0000000000000004E-4,9.98,0.87649999999999995,10501.24,22482.21]
["P8056","Engenheiro agrônomo sênior","mês",12894.95,0.79059999999999997,10194.75,5.2499999999999998E-2,677.01,3.0000000000000001E-3,38.08,0,0,0,0,2.0000000000000001E-4,2.2599999999999998,0,0,2.3400000000000001E-2,301.75,8.0000000000000004E-4,9.98,0.87039999999999995,11223.83,24118.77]
["P8057","Engenheiro ambiental júnior","mês",11067,0.79679999999999995,8818.19,6.1199999999999997E-2,677.01,3.3999999999999998E-3,38.08,0,0,0,0,2.9999999999999997E-4,3.37,0,0,2.7300000000000001E-2,301.75,8.9999999999999998E-4,9.98,0.88990000000000002,9848.3700000000008,20915.37]
["P8058","Engenheiro ambiental pleno","mês",12074.42,0.79679999999999995,9620.9,5.6099999999999997E-2,677.01,3.2000000000000002E-3,38.08,0,0,0,0,2.9999999999999997E-4,3.37,0,0,2.5000000000000001E-2,301.75,8.0000000000000004E-4,9.98,0.8821,10651.08,22725.51]
["P8059","Engenheiro ambiental sênior","mês",13081.85,0.79679999999999995,10423.620000000001,5.1799999999999999E-2,677.01,2.8999999999999998E-3,38.08,0,0,0,0,2.9999999999999997E-4,3.37,0,0,2.3099999999999999E-2,301.75,8.0000000000000004E-4,9.98,0.87549999999999994,11453.8,24535.65]
["P8060","Engenheiro consultor especial","mês",20302.32,0.79510000000000003,16142.37,3.3300000000000003E-2,677.01,1.6999999999999999E-3,34.78,0,0,0,0,2.0000000000000001E-4,3.38,0,0,1.49E-2,301.75,5.0000000000000001E-4,9.98,0.84570000000000001,17169.259999999998,37471.58]
["P8061","Engenheiro coordenador","mês",16918.599999999999,0.79510000000000003,13451.98,0.04,677.01,2.0999999999999999E-3,34.78,0,0,0,0,2.0000000000000001E-4,3.38,0,0,1.78E-2,301.75,5.9999999999999995E-4,9.98,0.85580000000000001,14478.87,31397.46]
["P8062","Engenheiro de pesca júnior","mês",11067,0.79749999999999999,8825.93,6.1199999999999997E-2,677.01,3.3999999999999998E-3,38.08,0,0,0,0,4.0000000000000002E-4,4.2300000000000004,0,0,2.7300000000000001E-2,301.75,8.9999999999999998E-4,9.98,0.89070000000000005,9856.98,20923.98]
["P8063","Engenheiro de pesca pleno","mês",11153.58,0.79749999999999999,8894.98,6.0699999999999997E-2,677.01,3.3999999999999998E-3,38.08,0,0,0,0,4.0000000000000002E-4,4.2300000000000004,0,0,2.7099999999999999E-2,301.75,8.9999999999999998E-4,9.98,0.88990000000000002,9926.02,21079.599999999999]
["P8064","Engenheiro de pesca sênior","mês",11240.15,0.79749999999999999,8964.02,6.0199999999999997E-2,677.01,3.3999999999999998E-3,38.08,0,0,0,0,4.0000000000000002E-4,4.2300000000000004,0,0,2.6800000000000001E-2,301.75,8.9999999999999998E-4,9.98,0.88919999999999999,9995.07,21235.22]
["P8065","Engenheiro de projetos júnior","mês",11067,0.79510000000000003,8799.3700000000008,6.1199999999999997E-2,677.01,3.3999999999999998E-3,38.08,0,0,0,0,2.9999999999999997E-4,3.38,0,0,2.7300000000000001E-2,301.75,8.9999999999999998E-4,9.98,0.88819999999999999,9829.56,20896.560000000001]
["P8066","Engenheiro de projetos pleno","mês",11294.64,0.79510000000000003,8980.3700000000008,5.9900000000000002E-2,677.01,3.3999999999999998E-3,38.08,0,0,0,0,2.9999999999999997E-4,3.38,0,0,2.6700000000000002E-2,301.75,8.9999999999999998E-4,9.98,0.88629999999999998,10010.56,21305.200000000001]
["P8067","Engenheiro de projetos sênior","mês",14506.03,0.79510000000000003,11533.74,4.6699999999999998E-2,677.01,2.5999999999999999E-3,38.08,0,0,0,0,2.0000000000000001E-4,3.38,0,0,2.0799999999999999E-2,301.75,6.9999999999999999E-4,9.98,0.86609999999999998,12563.93,27069.96]
["P8068","Engenheiro florestal júnior","mês",11067,0.79749999999999999,8825.93,6.1199999999999997E-2,677.01,3.3999999999999998E-3,38.08,0,0,0,0,4.0000000000000002E-4,4.2300000000000004,0,0,2.7300000000000001E-2,301.75,8.9999999999999998E-4,9.98,0.89070000000000005,9856.98,20923.98]
["P8069","Engenheiro florestal pleno","mês",11153.58,0.79749999999999999,8894.98,6.0699999999999997E-2,677.01,3.3999999999999998E-3,38.08,0,0,0,0,4.0000000000000002E-4,4.2300000000000004,0,0,2.7099999999999999E-2,301.75,8.9999999999999998E-4,9.98,0.88990000000000002,9926.02,21079.599999999999]
["P8070","Engenheiro florestal sênior","mês",11240.15,0.79749999999999999,8964.02,6.0199999999999997E-2,677.01,3.3999999999999998E-3,38.08,0,0,0,0,4.0000000000000002E-4,4.2300000000000004,0,0,2.6800000000000001E-2,301.75,8.9999999999999998E-4,9.98,0.88919999999999999,9995.07,21235.22]
["P8080","Geólogo júnior","mês",10004.5,0.79669999999999996,7970.59,6.7699999999999996E-2,677.01,3.7000000000000002E-3,36.630000000000003,0,0,0,0,4.0000000000000002E-4,3.69,0,0,3.0200000000000001E-2,301.75,1E-3,9.98,0.89959999999999996,8999.64,19004.14]
["P8081","Geólogo pleno","mês",12022.42,0.79669999999999996,9578.26,5.6300000000000003E-2,677.01,3.0000000000000001E-3,36.630000000000003,0,0,0,0,2.9999999999999997E-4,3.69,0,0,2.5100000000000001E-2,301.75,8.0000000000000004E-4,9.98,0.88229999999999997,10607.32,22629.73]
["P8082","Geólogo sênior","mês",14040.33,0.79669999999999996,11185.93,4.82E-2,677.01,2.5999999999999999E-3,36.630000000000003,0,0,0,0,2.9999999999999997E-4,3.69,0,0,2.1499999999999998E-2,301.75,6.9999999999999999E-4,9.98,0.87,12214.99,26255.32]
["P8092","Jornalista júnior","mês",2640.43,0.79720000000000002,2104.9499999999998,0.25640000000000002,677.01,9.7000000000000003E-3,25.61,0,0,2.3E-2,60.61,1.1000000000000001E-3,2.89,0,0,0.1143,301.75,3.8E-3,9.98,1.2054,3182.79,5823.22]
["P8093","Jornalista pleno","mês",3520.57,0.79720000000000002,2806.6,0.1923,677.01,7.3000000000000001E-3,25.61,0,0,2.2000000000000001E-3,7.8,8.0000000000000004E-4,2.89,0,0,8.5699999999999998E-2,301.75,2.8E-3,9.98,1.0884,3831.63,7352.2]
["P8094","Jornalista sênior","mês",6885.35,0.79720000000000002,5489,9.8299999999999998E-2,677.01,3.7000000000000002E-3,25.61,0,0,0,0,4.0000000000000002E-4,2.89,0,0,4.3799999999999999E-2,301.75,1.4E-3,9.98,0.94489999999999996,6506.23,13391.58]
["P8098","Laboratorista","mês",2071.89,0.79930000000000001,1656.06,0.32679999999999998,677.01,1.78E-2,36.94,0,0,4.5699999999999998E-2,94.72,2.0999999999999999E-3,4.28,0,0,0.14560000000000001,301.75,4.7999999999999996E-3,9.98,1.3421000000000001,2780.73,4852.62]
["P8102","Médico veterinário","mês",11067,0.79259999999999997,8771.7000000000007,6.1199999999999997E-2,677.01,3.3999999999999998E-3,38.08,0,0,0,0,2.9999999999999997E-4,2.86,0,0,2.7300000000000001E-2,301.75,8.9999999999999998E-4,9.98,0.88560000000000005,9801.3799999999992,20868.38]
["P8106","Meteorologista júnior","mês",4563.01,0.79700000000000004,3636.72,0.1484,677.01,5.5999999999999999E-3,25.61,0,0,0,0,5.9999999999999995E-4,2.8,0,0,6.6100000000000006E-2,301.75,2.2000000000000001E-3,9.98,1.0199,4653.8599999999997,9216.8700000000008]
["P8107","Meteorologista pleno","mês",6084.01,0.79700000000000004,4848.96,0.1113,677.01,4.1999999999999997E-3,25.61,0,0,0,0,5.0000000000000001E-4,2.8,0,0,4.9599999999999998E-2,301.75,1.6000000000000001E-3,9.98,0.96419999999999995,5866.1,11950.12]
["P8108","Meteorologista sênior","mês",10409.09,0.79700000000000004,8296.0499999999993,6.5000000000000002E-2,677.01,2.5000000000000001E-3,25.61,0,0,0,0,2.9999999999999997E-4,2.8,0,0,2.9000000000000001E-2,301.75,1E-3,9.98,0.89470000000000005,9313.19,19722.28]
["P8112","Motorista de caminhão","mês",2061.12,0.80020000000000002,1649.31,0.32850000000000001,677.01,1.5699999999999999E-2,32.409999999999997,0,0,4.6300000000000001E-2,95.36,2.0999999999999999E-3,4.3099999999999996,0,0,0.1464,301.75,4.7999999999999996E-3,9.98,1.3440000000000001,2770.12,4831.24]
["P8113","Motorista de veículo leve","mês",1905.56,0.79890000000000005,1522.36,0.3553,677.01,1.78E-2,33.89,0,0,5.4899999999999997E-2,104.7,2.0999999999999999E-3,3.93,0,0,0.15840000000000001,301.75,5.1999999999999998E-3,9.98,1.3926000000000001,2653.61,4559.18]
["P8117","Oceanógrafo júnior","mês",4581.8900000000003,0.82030000000000003,3758.53,0.14779999999999999,677.01,8.0999999999999996E-3,37.22,0,0,0,0,1.2999999999999999E-3,5.93,0,0,6.59E-2,301.75,2.2000000000000001E-3,9.98,1.0455000000000001,4790.41,9372.2999999999993]
["P8118","Oceanógrafo pleno","mês",6109.19,0.82030000000000003,5011.37,0.1108,677.01,6.1000000000000004E-3,37.22,0,0,0,0,1E-3,5.93,0,0,4.9399999999999999E-2,301.75,1.6000000000000001E-3,9.98,0.98919999999999997,6043.25,12152.44]
["P8119","Oceanógrafo sênior","mês",10247.31,0.82030000000000003,8405.8700000000008,6.6100000000000006E-2,677.01,3.5999999999999999E-3,37.22,0,0,0,0,5.9999999999999995E-4,5.93,0,0,2.9399999999999999E-2,301.75,1E-3,9.98,0.92100000000000004,9437.75,19685.060000000001]
["P8129","Pedagogo júnior","mês",2561.89,0.79259999999999997,2030.55,0.26429999999999998,677.01,1.49E-2,38.08,0,0,2.5499999999999998E-2,65.319999999999993,1.1000000000000001E-3,2.75,0,0,0.1178,301.75,3.8999999999999998E-3,9.98,1.22,3125.43,5687.32]
["P8130","Pedagogo pleno","mês",3415.85,0.79259999999999997,2707.4,0.19819999999999999,677.01,1.11E-2,38.08,0,0,4.1000000000000003E-3,14.08,8.0000000000000004E-4,2.75,0,0,8.8300000000000003E-2,301.75,2.8999999999999998E-3,9.98,1.0981000000000001,3751.05,7166.89]
["P8131","Pedagogo sênior","mês",5543.52,0.79259999999999997,4393.79,0.1221,677.01,6.8999999999999999E-3,38.08,0,0,0,0,5.0000000000000001E-4,2.75,0,0,5.4399999999999997E-2,301.75,1.8E-3,9.98,0.97829999999999995,5423.36,10966.87]
["P8135","Secretária","mês",2364.31,0.79830000000000001,1887.43,0.2863,677.01,0,0,0,0,3.2599999999999997E-2,77.17,1.2999999999999999E-3,3.06,0,0,0.12759999999999999,301.75,4.1999999999999997E-3,9.98,1.2504,2956.4,5320.7]
["P8139","Sondador","mês",1824.64,0.79759999999999998,1455.33,0.371,677.01,2.3400000000000001E-2,42.69,0,0,0.06,109.55,2.2000000000000001E-3,4.03,0,0,0.16539999999999999,301.75,5.4999999999999997E-3,9.98,1.4251,2600.35,4424.99]
["P8143","Técnico ambiental","mês",2618.06,0.79849999999999999,2090.52,0.2586,677.01,1.4200000000000001E-2,37.29,0,0,2.3699999999999999E-2,61.95,1.5E-3,3.94,0,0,0.1153,301.75,3.8E-3,9.98,1.2156,3182.44,5800.49]
["P8147","Técnico de obras","mês",3069.63,0.79830000000000001,2450.48,0.22059999999999999,677.01,1.3899999999999999E-2,42.69,0,0,1.14E-2,34.85,1.2999999999999999E-3,3.89,0,0,9.8299999999999998E-2,301.75,3.3E-3,9.98,1.1469,3520.66,6590.28]
["P8151","Técnico de segurança do trabalho","mês",4293.3999999999996,0.80200000000000005,3443.31,0.15770000000000001,677.01,7.7000000000000002E-3,33.130000000000003,0,0,0,0,1.1000000000000001E-3,4.6100000000000003,0,0,7.0300000000000001E-2,301.75,2.3E-3,9.98,1.0410999999999999,4469.78,8763.18]
["P8155","Técnico em geoprocessamento","mês",2433.29,0.79620000000000002,1937.39,0.2782,677.01,1.7500000000000002E-2,42.69,0,0,0.03,73.03,1.2999999999999999E-3,3.16,0,0,0.124,301.75,4.1000000000000003E-3,9.98,1.2514000000000001,3045.01,5478.3]
["P8159","Técnico em informática - programador","mês",3298.2,0.79790000000000005,2631.63,0.20530000000000001,677.01,0,0,0,0,6.4000000000000003E-3,21.14,1.1999999999999999E-3,3.86,0,0,9.1499999999999998E-2,301.75,3.0000000000000001E-3,9.98,1.1052999999999999,3645.37,6943.57]
["P8163","Topógrafo","mês",2215.09,0.79969999999999997,1771.41,0.30559999999999998,677.01,1.7100000000000001E-2,37.979999999999997,0,0,3.8899999999999997E-2,86.13,1.9E-3,4.3099999999999996,0,0,0.13619999999999999,301.75,4.4999999999999997E-3,9.98,1.304,2888.56,5103.6499999999996]
["P8167","Arquivista júnior","mês",1929.44,0.80010000000000003,1543.75,0.35089999999999999,677.01,1.66E-2,32.1,0,0,5.3499999999999999E-2,103.27,1.8E-3,3.52,0,0,0.15640000000000001,301.75,5.1999999999999998E-3,9.98,1.3845000000000001,2671.37,4600.82]
["P8168","Arquivista pleno","mês",2572.59,0.80010000000000003,2058.33,0.26319999999999999,677.01,1.2500000000000001E-2,32.1,0,0,2.5100000000000001E-2,64.680000000000007,1.4E-3,3.52,0,0,0.1173,301.75,3.8999999999999998E-3,9.98,1.2234,3147.37,5719.96]
["P8169","Arquivista sênior","mês",4087.98,0.80010000000000003,3270.8,0.1656,677.01,7.9000000000000008E-3,32.1,0,0,0,0,8.9999999999999998E-4,3.52,0,0,7.3800000000000004E-2,301.75,2.3999999999999998E-3,9.98,1.0507,4295.16,8383.14]
["P8173","Administrador júnior","mês",3049.72,0.79669999999999996,2429.71,0.222,677.01,1.4200000000000001E-2,43.24,0,0,1.18E-2,36.049999999999997,1.1000000000000001E-3,3.22,0,0,9.8900000000000002E-2,301.75,3.3E-3,9.98,1.1479999999999999,3500.96,6550.67]
["P8174","Administrador pleno","mês",4066.29,0.79669999999999996,3239.61,0.16650000000000001,677.01,1.06E-2,43.24,0,0,0,0,8.0000000000000004E-4,3.22,0,0,7.4200000000000002E-2,301.75,2.5000000000000001E-3,9.98,1.0512999999999999,4274.8100000000004,8341.1]
["P8175","Administrador sênior","mês",7066.51,0.79669999999999996,5629.88,9.5799999999999996E-2,677.01,6.1000000000000004E-3,43.24,0,0,0,0,5.0000000000000001E-4,3.22,0,0,4.2700000000000002E-2,301.75,1.4E-3,9.98,0.94320000000000004,6665.08,13731.59]
["P8180","Engenheiro agrimensor júnior","mês",11067,0.79400000000000004,8787.2000000000007,6.1199999999999997E-2,677.01,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0.85519999999999996,9464.2099999999991,20531.21]
["P8181","Engenheiro agrimensor pleno","mês",11541.44,0.79400000000000004,9163.9,5.8700000000000002E-2,677.01,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0.85270000000000001,9840.91,21382.35]
["P8182","Engenheiro agrimensor sênior","mês",12015.88,0.79400000000000004,9540.6,5.6300000000000003E-2,677.01,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0.85029999999999994,10217.61,22233.49]
["P8183","Geógrafo júnior","mês",3239.76,0.7944,2573.67,0.20899999999999999,677.01,0,0,0,0,7.6E-3,24.65,0,0,0,0,0,0,0,0,1.0109999999999999,3275.32,6515.09]
["P8184","Geógrafo pleno","mês",4319.68,0.7944,3431.56,0.15670000000000001,677.01,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0.95109999999999995,4108.57,8428.25]
["P8185","Geógrafo sênior","mês",8153.57,0.7944,6477.19,8.3000000000000004E-2,677.01,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0.87739999999999996,7154.2,15307.77]
["P8186","Antropólogo júnior","mês",3115.44,0.81489999999999996,2538.77,0.21729999999999999,677.01,1.21E-2,37.6,0,0,1.03E-2,32.11,1.5E-3,4.62,0,0,9.69E-2,301.75,3.2000000000000002E-3,9.98,1.1560999999999999,3601.84,6717.28]
["P8187","Antropólogo pleno","mês",4153.92,0.81489999999999996,3385.03,0.16300000000000001,677.01,9.1000000000000004E-3,37.6,0,0,0,0,1.1000000000000001E-3,4.62,0,0,7.2599999999999998E-2,301.75,2.3999999999999998E-3,9.98,1.0630999999999999,4415.99,8569.91]
["P8188","Antropólogo sênior","mês",6000.58,0.81489999999999996,4889.88,0.1128,677.01,6.3E-3,37.6,0,0,0,0,8.0000000000000004E-4,4.62,0,0,5.0299999999999997E-2,301.75,1.6999999999999999E-3,9.98,0.98670000000000002,5920.84,11921.42]
["P8189","Arqueólogo júnior","mês",3115.44,0.81489999999999996,2538.77,0.21729999999999999,677.01,1.21E-2,37.6,0,0,1.03E-2,32.11,1.5E-3,4.62,0,0,9.69E-2,301.75,3.2000000000000002E-3,9.98,1.1560999999999999,3601.84,6717.28]
["P8190","Arqueólogo pleno","mês",4153.92,0.81489999999999996,3385.03,0.16300000000000001,677.01,9.1000000000000004E-3,37.6,0,0,0,0,1.1000000000000001E-3,4.62,0,0,7.2599999999999998E-2,301.75,2.3999999999999998E-3,9.98,1.0630999999999999,4415.99,8569.91]
["P8191","Arqueólogo sênior","mês",6000.58,0.81489999999999996,4889.88,0.1128,677.01,6.3E-3,37.6,0,0,0,0,8.0000000000000004E-4,4.62,0,0,5.0299999999999997E-2,301.75,1.6999999999999999E-3,9.98,0.98670000000000002,5920.84,11921.42]
["P8192","Historiador júnior","mês",3289.63,0.80020000000000002,2632.36,0.20580000000000001,677.01,1.14E-2,37.380000000000003,0,0,6.6E-3,21.65,1.1999999999999999E-3,3.98,0,0,9.1700000000000004E-2,301.75,3.0000000000000001E-3,9.98,1.1198999999999999,3684.12,6973.75]
["P8193","Historiador pleno","mês",4386.17,0.80020000000000002,3509.81,0.15440000000000001,677.01,8.5000000000000006E-3,37.380000000000003,0,0,0,0,8.9999999999999998E-4,3.98,0,0,6.88E-2,301.75,2.3E-3,9.98,1.0350999999999999,4539.92,8926.09]
["P8194","Historiador sênior","mês",7321.05,0.80020000000000002,5858.3,9.2499999999999999E-2,677.01,5.1000000000000004E-3,37.380000000000003,0,0,0,0,5.0000000000000001E-4,3.98,0,0,4.1200000000000001E-2,301.75,1.4E-3,9.98,0.94089999999999996,6888.41,14209.46]
["P8195","Paleontólogo júnior","mês",3115.44,0.81489999999999996,2538.77,0.21729999999999999,677.01,1.21E-2,37.6,0,0,1.03E-2,32.11,1.5E-3,4.62,0,0,9.69E-2,301.75,3.2000000000000002E-3,9.98,1.1560999999999999,3601.84,6717.28]
["P8196","Paleontólogo pleno","mês",4153.92,0.81489999999999996,3385.03,0.16300000000000001,677.01,9.1000000000000004E-3,37.6,0,0,0,0,1.1000000000000001E-3,4.62,0,0,7.2599999999999998E-2,301.75,2.3999999999999998E-3,9.98,1.0630999999999999,4415.99,8569.91]
["P8197","Paleontólogo sênior","mês",6000.58,0.81489999999999996,4889.88,0.1128,677.01,6.3E-3,37.6,0,0,0,0,8.0000000000000004E-4,4.62,0,0,5.0299999999999997E-2,301.75,1.6999999999999999E-3,9.98,0.98670000000000002,5920.84,11921.42]
["P8198","Sociólogo júnior","mês",3289.63,0.80020000000000002,2632.36,0.20580000000000001,677.01,1.14E-2,37.380000000000003,0,0,6.6E-3,21.65,1.1999999999999999E-3,3.98,0,0,9.1700000000000004E-2,301.75,3.0000000000000001E-3,9.98,1.1198999999999999,3684.12,6973.75]
["P8199","Sociólogo pleno","mês",4386.17,0.80020000000000002,3509.81,0.15440000000000001,677.01,8.5000000000000006E-3,37.380000000000003,0,0,0,0,8.9999999999999998E-4,3.98,0,0,6.88E-2,301.75,2.3E-3,9.98,1.0350999999999999,4539.92,8926.09]
["P8200","Sociólogo sênior","mês",7321.05,0.80020000000000002,5858.3,9.2499999999999999E-2,677.01,5.1000000000000004E-3,37.380000000000003,0,0,0,0,5.0000000000000001E-4,3.98,0,0,4.1200000000000001E-2,301.75,1.4E-3,9.98,0.94089999999999996,6888.41,14209.46]
["Fonte: FGV IBRE"]

{"sheet":"DNIT TC -042023","index":15,"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"]

{"sheet":"SINAPI_ES_RN","index":16,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}