{"text_format":"2","workbook":"xlsx","n_sheets":15,"sheets":["PFP","PFP1.1_Topo","PFP1.2_Geo","PFP2.1_FatorKa","PFP2.2_FatorKb","PFP2.3_FatorKc","PFP3_FatorKd","CRO1_Ins-Pro","CRO2_Ins-Mes","CRO3_Fis-Finan","MDO_DNIT","CPU HOSPEDAGEM","CPU-VEICULO_PickUp","Cotação Voos","COT. VANT"],"not_rendered":{"charts":0,"images":21,"macros":0,"external_links":49,"defined_names":19579,"comments":1,"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":45,"n_cols":18,"rows_kept":45,"cut":false,"hidden":false,"merged":[[27,9,27,12],[27,1,27,8],[26,9,26,12],[26,1,26,8],[34,1,34,12],[28,1,28,8],[28,9,28,12],[31,1,31,12],[30,1,30,12],[42,1,42,12],[35,1,35,12],[37,1,37,12],[29,1,29,12],[36,1,36,12],[32,1,32,12],[38,1,38,12],[39,1,39,12],[40,1,40,12],[41,1,41,12],[33,1,33,12],[0,1,1,10],[4,7,4,10],[0,11,0,12],[1,11,1,12],[4,11,4,12],[2,1,2,12],[3,1,3,12],[4,1,4,6],[5,11,5,12],[5,7,5,10],[25,1,25,8],[25,9,25,12],[5,1,5,6],[24,1,24,8],[24,9,24,12]]}
[null,"PROPOSTA FINANCEIRA DO PROJETO",{"$nulls":9},"CODIGO:"]
[{"$nulls":11},"PFP"]
[null,"NOME DA CONSULTORA:"]
[]
[null,"PROJETO:",{"$nulls":5},"CONTRATANTE:",null,null,null,"BASE:"]
[null,"Elaboração de Estudo de Viabilidade Técnica, Econômica e Ambiental da barragem de Gravatá, município de Novo Cruzeiro, no estado de Minas Gerais ",{"$nulls":5},"CODEVASF (SEDE)",null,null,null,"2024-08-01"]
[null,"Base","Cod2","Cod3","Código","Categoria / Insumo","Uni","Qde","CUD","PU","FatorK","CT","PT","Encargos COMP E ADICIONAIS","SOCIAIS","TOTAIS",null,"Encargos Comp e Adicionais"]
[null,"SICRO","MO3","P0","P8061","Engenheiro coordenador (P8061)","mês",{"$f":"'CRO1_Ins-Pro'!D5","v":5},{"$f":"VLOOKUP(E8,MDO_DNIT!$A:$Z,4,0)","v":17866.689999999999},{"$f":"ROUND(K8*I8,2)","v":22990.86},{"$f":"PFP2.3_FatorKc!E35","v":1.2867999999999999},{"$f":"ROUND(H8*I8,2)","v":89333.45},{"$f":"ROUND(H8*J8,2)","v":114954.3},{"$f":"P8-O8","v":1026.8900000000012},13451.98,14478.87,null,{"$f":"VLOOKUP(E8,MDO_DNIT!$A:$Z,26,0)","v":1029.0600000000013}]
[null,"SICRO","MO2","P1","P8067","Engenheiro sênior (P8067)","mês",{"$f":"'CRO1_Ins-Pro'!D6","v":23},{"$f":"VLOOKUP(E9,MDO_DNIT!$A:$Z,4,0)","v":15564.54},23771.72,{"$f":"PFP2.2_FatorKb!$E$35","v":1.5273000000000001},357984.42,546749.56000000006,1030.1900000000005,11533.74,12563.93,null,{"$f":"VLOOKUP(E9,MDO_DNIT!$A:$Z,26,0)","v":1031.2299999999996}]
[null,"SICRO","MO1","P2","P8066","Engenheiro pleno (P8066)","mês",{"$f":"'CRO1_Ins-Pro'!D7","v":13},{"$f":"VLOOKUP(E10,MDO_DNIT!$A:$Z,4,0)","v":12379.96},{"$f":"ROUND(K10*I10,2)","v":26022.68},{"$f":"PFP2.1_FatorKa!$E$36","v":2.1019999999999999},{"$f":"ROUND(H10*I10,2)","v":160939.48000000001},338294.84,1030.1899999999987,8980.3700000000008,10010.56,null,{"$f":"VLOOKUP(E10,MDO_DNIT!$A:$Z,26,0)","v":1031.2300000000014}]
[null,"SICRO","MO1","P3","P8065","Engenheiro júnior (P8065)","mês",{"$f":"'CRO1_Ins-Pro'!D8","v":7},{"$f":"VLOOKUP(E11,MDO_DNIT!$A:$Z,4,0)","v":12002},{"$f":"ROUND(K11*I11,2)","v":25228.2},{"$f":"PFP2.1_FatorKa!$E$36","v":2.1019999999999999},{"$f":"ROUND(H11*I11,2)","v":84014},176597.4,1030.1899999999987,8799.3700000000008,9829.56,null,{"$f":"VLOOKUP(E11,MDO_DNIT!$A:$Z,26,0)","v":1031.2299999999996}]
[null,"SICRO","MO1","T1","P8147","Técnico de projetos/obra (P8147)","mês",{"$f":"'CRO1_Ins-Pro'!D9","v":5},{"$f":"VLOOKUP(E12,MDO_DNIT!$A:$Z,4,0)","v":3167.62},6658.34,{"$f":"PFP2.1_FatorKa!$E$36","v":2.1019999999999999},15838.1,33291.699999999997,1070.1799999999998,2450.48,3520.66,null,{"$f":"VLOOKUP(E12,MDO_DNIT!$A:$Z,26,0)","v":1063.04}]
[null,"SINAPI","MO1","D",40807,"Desenhista (40807)","mês",{"$f":"'CRO1_Ins-Pro'!D10","v":13},7442.91,8950.84,{"$f":"PFP3_FatorKd!$E$17","v":1.2025999999999999},96757.83,116360.92,1070.1799999999998,2450.48,3520.66,null,{"$f":"R14","v":1068.6199999999999}]
[null,"SICRO","MO1","A1","P8135","Secretária (P8135)","mês",{"$f":"'CRO1_Ins-Pro'!D11","v":5},{"$f":"VLOOKUP(E14,MDO_DNIT!$A:$Z,4,0)","v":2604.7800000000002},{"$f":"ROUND(K14*I14,2)","v":5475.25},{"$f":"PFP2.1_FatorKa!$E$36","v":2.1019999999999999},{"$f":"ROUND(H14*I14,2)","v":13023.9},{"$f":"ROUND(H14*J14,2)","v":27376.25},1068.97,1887.43,2956.4,null,{"$f":"VLOOKUP(E14,MDO_DNIT!$A:$Z,26,0)","v":1068.6199999999999}]
[null,"SICRO","EC","ECA",null,"Encargos Comp. e Adicionais","mês",{"$f":"'CRO1_Ins-Pro'!D12","v":71},{"$f":"AVERAGE(R8:R14)","v":1046.1471428571431},1258.0999999999999,{"$f":"PFP3_FatorKd!$E$17","v":1.2025999999999999},{"$f":"ROUND(H15*I15,2)","v":74276.45},89325.1]
[null,"PROP","EC","AT2",null,"Auxilio Transporte Técnicos","mês",{"$f":"'CRO1_Ins-Pro'!D13","v":0},"Já incluso*",0,{"$f":"PFP3_FatorKd!$E$17","v":1.2025999999999999},0,0]
[null,"PROP","EC","AT3",null,"Auxilio Transporte Secretária","mês",{"$f":"'CRO1_Ins-Pro'!D14","v":0},"Já Incluso*",0,{"$f":"PFP3_FatorKd!$E$17","v":1.2025999999999999},0,0]
[null,"CODE","LO","V1",null,"Diárias","dia",{"$f":"'CRO1_Ins-Pro'!D15","v":345},{"$f":"'CPU HOSPEDAGEM'!C19","v":187.18670833333334},225.11,{"$f":"PFP3_FatorKd!$E$17","v":1.2025999999999999},{"$f":"ROUND(H18*I18,2)","v":64579.41},{"$f":"ROUND(H18*J18,2)","v":77662.95}]
[null,"CODE","LO","V2",null,"Pick-up Cab.dupla 2.8 4x4 Diesel","dia",{"$f":"'CRO1_Ins-Pro'!D16","v":120},{"$f":"'CPU-VEICULO_PickUp'!C11","v":325.62682583461901},391.6,{"$f":"PFP3_FatorKd!$E$17","v":1.2025999999999999},39075.22,46992]
[null,"PROP","LO","V3",null,"Passagens Aéreas (ida e volta)","un",{"$f":"'CRO1_Ins-Pro'!D17","v":31},{"$f":"'Cotação Voos'!B104","v":1195.25},1437.41,{"$f":"PFP3_FatorKd!$E$17","v":1.2025999999999999},37052.75,44559.71]
[null,"CODE","EM","M1",null,"Relatório Parcial","un",{"$f":"'CRO1_Ins-Pro'!D18","v":0},33.35,40.11,{"$f":"PFP3_FatorKd!$E$17","v":1.2025999999999999},0,0]
[null,"CODE","EM","M2",null,"Relatório Final","un",{"$f":"'CRO1_Ins-Pro'!D19","v":10},1478.8,1778.4,{"$f":"PFP3_FatorKd!$E$17","v":1.2025999999999999},14788,17784]
[null,null,"SU","TOP",null,"Total Serviços Cartográficos","un",{"$f":"'CRO1_Ins-Pro'!D20","v":1},"-",{"$f":"PFP1.1_Topo!H24","v":100644.98184031098},"-","-",100644.98]
[null,null,"SU","GEO",null,"Total Serviços Geotécnicos","un",{"$f":"'CRO1_Ins-Pro'!D21","v":1},"-",{"$f":"PFP1.2_Geo!H34","v":467711.98421389027},"-","-",467711.98]
[null,"TOTAL DOS CUSTOS DIRETOS",{"$nulls":7},{"$f":"SUM(L8:L24)","v":1047663.0099999999}]
[null,"TOTAL DOS ENCARGOS E DESPESAS DIVERSAS",{"$nulls":7},{"$f":"J27-J25","v":582285.72000000009}]
[null,"TOTAL DA PROPOSTA A PREÇO GLOBAL",{"$nulls":7},{"$f":"SUM(M8:M22)","v":1629948.73}]
[null,"TOTAL DA PROPOSTA A PREÇO UNITÁRIO",{"$nulls":7},{"$f":"SUM(M23:P24)","v":568356.96}]
[null,"TOTAL DA PROPOSTA",{"$nulls":7},{"$f":"J27+J28","v":2198305.69}]
[null,"OBSERVAÇÃO:"]
[null,"*Encargos Complementares e adicionais já incluem auxílio transporte"]
[null,"Alocar os Insumos MO, com respectivo FatorK, dentro da categoria de vínculo contratual (celetista, autonomo, societario)"]
[null,"Uni - unidade de medição do insumo;"]
[null,"Qde - Quantidade do Insumo (não pode ocorrer alteração pela Licitante)"]
[null,"CUD - Custo Unitário Direto do Insumo (sem encargos, taxas e impostos, valor não pode ser maior que o Orçado pela Codevasf)"]
[null,"CT - Custo Total (sem encargos, taxas e impostos) - CT = Qde x CUD"]
[null,"FatorK - Taxa de Ressarcimento de Despesas e Encargos (detalhar composição nas Planilhas \"PFP2.1\", \"PFP2.2\", \"PFP3\")"]
[null,"PU - Preço Unitário do Insumo (incluído encargos, taxas e impostos) - PU = CUD x FatorK"]
[null,"PT - Preço Total do Insumo (incluído encargos, taxas e impostos) - PT = Qde x PU"]
[null,"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"]
[null,"S - Profissionais de nível superior nas demais áreas de atuação, incluindo Arqueólogo, Biólogo, Geógrafo e Sociólogo"]
[null,"T - Profissionais de nível médio técnico nas diversas áreas de atuação"]
[null,"A - Profissionais de nível médio de apoio técnico-administrativo"]
[]
[null,"Observações: "]

{"sheet":"PFP1.1_Topo","index":1,"n_rows":29,"n_cols":12,"rows_kept":29,"cut":false,"hidden":false,"merged":[[28,0,28,7],[0,0,1,5],[2,0,2,7],[3,0,3,7],[4,0,4,3],[4,4,4,5],[5,0,5,3],[5,4,5,5],[23,0,23,5],[24,0,24,7],[25,0,25,7],[26,0,26,7],[27,0,27,7],[6,9,7,11],[8,9,9,9],[8,10,9,10],[8,11,9,11],[10,9,10,11],[24,9,24,10],[25,9,25,10],[26,9,27,11],[28,9,28,10],[11,10,11,11],[16,9,16,10],[17,10,17,11],[19,9,19,10],[20,10,20,11]]}
["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!L5","v":"BASE:"}]
[{"$f":"PFP!B6","v":"Elaboração de Estudo de Viabilidade Técnica, Econômica e Ambiental da barragem de Gravatá, município de Novo Cruzeiro, no estado de Minas Gerais "},null,null,null,"CODEVASF (SEDE)",null,null,{"$f":"PFP!L6","v":"2024-08-01"}]
["Referência","Código","Insumos","Uni","Qde","Custo Unitário (CU)","Custo Total","Preço Total (PT)",null,"MEMÓRIA DE CALCULO DO BDI DE FORNECIMENTO"]
["EMBASA/COMPOSIÇÃO","31.90.22","Aerolevantamento com VANT/RPA categoria 3","ha ",700,34.31,{"$f":"ROUND(F8*E8,2)","v":24017},{"$f":"(G8*$L$29)+G8","v":27545.580568902446}]
["TP02","CODE","Nivelamento Geométrico dos Eixos classe IIN","km",2,846.42,{"$f":"ROUND(F9*E9,2)","v":1692.84},{"$f":"(G9*$L$29)+G9","v":1941.5522592439027},null,"ITEM","DISCRIMINAÇÃO","PERC.    (%)"]
["ORSE/COMPOSIÇÃO",9164,"Seções Transversais","km",2,{"$f":"4.67*1000","v":4670},9340,10712.233939024392]
["EMOP/COMPOSIÇÃO","01.016.0035-0","Poligonal Classe IIP","km",4,1366.27,5465.08,6268.0102200731717]
["CPOS/CDHU/COMPOSIÇÃO","01.20.921","Pontos GPS de dupla frequencia (L1/L2)","un ",12,1257.0899999999999,15085.08,17301.381793243905,null,"1.00","Despesas Indiretas"]
["TP06","CODE","Levantamento Ecobatimetrico","ha ",4,858.94,3435.76,3940.5422781951229,null,"A1","Seguro e Garantia",8.0000000000000002E-3]
["TP07","CODE","Levantamento Topobatimétrico","km",2,1490.27,2980.54,3418.4413002804886,null,"A2","Riscos e Imprevistos",1.15E-2]
["TP08","CODE","Cadastro Físico","ha ",700,14.59,10213,11713.495205487807,null,"A3","Despesas Financeiras",1.0500000000000001E-2]
["TP09","CODE","Cadastro Agrícola","ha ",700,4.8600000000000003,3402,3901.8222548780495,null,"A4","Administração Central",2.1999999999999999E-2]
["TP10","CODE","Cadastro Jurídico","ha ",700,9.73,6811,7811.6729506097572,null,"Total do Grupo A =",null,{"$f":"SUM(L13:L16)","v":5.1999999999999998E-2}]
["TP11","CODE","Cadastro Socioeconomico","ha ",700,3.24,2268,2601.2148365853664,null,"2.00","Benefício"]
["ORSE/INSUMO",4369,"Marco de Concreto (12x18x60cm)","un ",12,73,876,1004.7020268292684,null,"B1","LUCRO",0.05]
["EMBASA/INSUMO","D059722497","Estaca Testemunha de Madeira (2x4x70cm)","un",40,0.55000000000000004,22,25.232242682926834,null,"Total do Grupo B =",null,{"$f":"L19","v":0.05}]
["SEINFRA/INSUMO","I1652","Piquetes de Madeira (2x2x20cm)","un",200,2.08,416,477.1187707317074,null,"3.00","Impostos"]
["PD06","CODE","Picada Manual p/ levantamento TP","km",4,154.85,619.4,710.40232353658553,null,"C1","PIS / PASEP",6.4999999999999997E-3]
["PD08","CODE","Picada c/ Trator de Esteira","km",1,1108.69,1108.69,1271.578870006098,null,"C2","COFINS",0.03]
["TOTAL SERVIÇOS TOPOGRÁFICOS",{"$nulls":6},{"$f":"SUM(H8:H23)","v":100644.98184031098},null,"C3","ISS",0]
["OBSERVAÇÃO:",{"$nulls":8},"Total do Grupo C =",null,{"$f":"SUM(L22:L24)","v":3.6499999999999998E-2}]
["Uni - unidade de medição do insumo;",{"$nulls":8},"Fórmula Para Cálculo do B.D.I"]
["Qde - Quantidade do Insumo (não pode ocorrer alteração pela Licitante)",{"$nulls":8},"BDI =(((1+A4+A1+A2)*(1+A3)*(1+B))/(1-C))-1"]
["CU - Custo Unitário (composições padrão da Codevasf, já incluso o FatorK)"]
["PT - Preço Total (incluído encargos, taxas e impostos) - PT = Qde x PU",{"$nulls":8},"Bonificação Sobre Despesas indiretas (B.D.I) =",null,{"$f":"(((1+L16+L13+L14)*(1+L15)*(1+L20))/(1-L25))-1","v":0.14692012195121973}]

{"sheet":"PFP1.2_Geo","index":2,"n_rows":39,"n_cols":12,"rows_kept":39,"cut":false,"hidden":false,"merged":[[38,0,38,6],[5,0,5,3],[5,4,5,5],[7,2,7,6],[2,0,2,6],[3,0,3,6],[4,0,4,3],[4,4,4,5],[36,0,36,6],[37,0,37,6],[33,0,33,5],[34,0,34,6],[35,0,35,6],[26,9,26,10],[27,9,27,10],[28,9,29,11],[30,9,30,10],[0,0,1,6],[13,10,13,11],[18,9,18,10],[19,10,19,11],[21,9,21,10],[22,10,22,11],[8,9,9,11],[10,9,11,9],[10,10,11,10],[10,11,11,11],[12,9,12,11]]}
["SERVIÇOS GEOLÓGICOS/GEOTÉCNICOS",{"$nulls":6},"CODIGO:"]
[{"$nulls":7},"PFP-1.2"]
["NOME DA EMPRESA:"]
[]
["PROJETO: ",null,null,null,"CONTRATANTE:",null,{"$f":"PFP!L5","v":"BASE:"}]
[{"$f":"PFP!B6","v":"Elaboração de Estudo de Viabilidade Técnica, Econômica e Ambiental da barragem de Gravatá, município de Novo Cruzeiro, no estado de Minas Gerais "},null,null,null,"CODEVASF (SEDE)",null,{"$f":"PFP!L6","v":"2024-08-01"}]
["Cod.","Base","Insumos","Uni","Qde","Custo Unitário (CU)","Custo Total","Preço Total (PT)"]
["GT 1",null,"Sondagem mista"]
["E200320516","EMBASA/INSUMO","Sondagem Mista: (Des)Mobilização por equipe","un",2,3157.33,{"$f":"ROUND(F9*E9,2)","v":6314.66},{"$f":"(G9*$L$31)+G9","v":7242.4106172804886},null,"MEMÓRIA DE CALCULO DO BDI DE FORNECIMENTO"]
["C0333","SEINFRA/COMPOSIÇÃO","Sondagem Mista: em rochas","m",220,1251.98,{"$f":"ROUND(F10*E10,2)","v":275435.59999999998},{"$f":"(G10*$L$31)+G10","v":315902.63194170734}]
["GT 2",null,"Sondagem a Percussão SPT",{"$nulls":6},"ITEM","DISCRIMINAÇÃO","PERC.    (%)"]
["A.07.000.020476","CPOS/INSUMO","Sondagem Percussão: (Des)Mobilização por equipe","un",2,1216.18,{"$f":"ROUND(F12*E12,2)","v":2432.36},2789.7226278292692]
["CO-28388","SETOP/COMPOSIÇÃO","Sondagem Percursão: com SPT - Terrestre","m",300,72.5,{"$f":"ROUND(F13*E13,2)","v":21750},24945.512652439029]
["GT3","CODE","Poços de Inspeção com retroescavadeira","m",50,190.01,9500.5,10896.314618597564,null,"1.00","Despesas Indiretas"]
["32.01.01","EMBASA/COMPOSIÇÃO","Sondagem a Trado","m",200,97.5,19500,22364.942378048785,null,"A1","Seguro e Garantia",8.0000000000000002E-3]
["GT5",null,"Ensaios: ",{"$nulls":6},"A2","Riscos e Imprevistos",1.15E-2]
["65.08.23","SUDECAP/COMPOSIÇÃO","Ensaio: Retirada de Amostra Indeformada","un",5,1000,{"$f":"ROUND(F17*E17,2)","v":5000},5734.6006097560985,null,"A3","Despesas Financeiras",1.0500000000000001E-2]
["GT6.1",null,"Ensaios de solo",{"$nulls":6},"A4","Administração Central",2.1999999999999999E-2]
["ED-49553","SETOP/COMPOSIÇÃO","Ensaio: Limite de Liquidez","un",60,79.81,{"$f":"ROUND(F19*E19,2)","v":4788.6000000000004},5492.1416959756116,null,"Total do Grupo A =",null,{"$f":"SUM(L15:L18)","v":5.1999999999999998E-2}]
["ED-49554","SETOP/COMPOSIÇÃO","Ensaio: Limite de Plasticidade","un",60,79.819999999999993,{"$f":"ROUND(F20*E20,2)","v":4789.2},5492.8298480487811,null,"2.00","Benefício"]
["ED-49552","SETOP/COMPOSIÇÃO","Ensaio: Granulometria por Peneiramento","un",60,150.69,9041.4,10369.763590609757,null,"B1","LUCRO",0.05]
["01.07.07U","COMPESA/COMPOSIÇÃO","Ensaio: Granulometria por Sedimentação","un",60,130.94,7856.4,9010.6632460975616,null,"Total do Grupo B =",null,{"$f":"L21","v":0.05}]
[4685,"ORSE/COMPOSIÇÃO","Ensaio: Compactação Proctor Normal","un",60,116.23,6973.8,7998.3915464634165,null,"3.00","Impostos"]
["34.01.16","EMBASA/COMPOSIÇÃO","Ensaio: Massa Especifica Real dos Grãos","un",60,65.78,3946.8,4526.6643373170746,null,"C1","PIS / PASEP",6.4999999999999997E-3]
["67.01.18","SUDECAP/COMPOSIÇÃO","Ensaio: Adensamento Oedométrico","un",10,257.86,2578.6,2957.4482264634153,null,"C2","COFINS",0.03]
[6720,"ORSE/INSUMO","Ensaio: Índice de Suporte Califórnia (CBR)","un",10,259,2590,2970.523115853659,null,"C3","ISS",0]
["CO-6364","SETOP/COMPOSIÇÃO","Ensaio: Triaxial (UU) não consolidado não drenado","un",5,851.51,4257.55,4883.0697652134158,null,"Total do Grupo C =",null,{"$f":"SUM(L24:L26)","v":3.6499999999999998E-2}]
["GT6.2",null,"Análise da Areia ",{"$nulls":6},"Fórmula Para Cálculo do B.D.I"]
["GT6.2.1","CODE","Ensaio: Mineralogia da Areia","un",5,379.15,1895.75,2174.2738211890246,null,"BDI =(((1+A4+A1+A2)*(1+A3)*(1+B))/(1-C))-1"]
["01.001.0009-A","EMOP/COMPOSIÇÃO","Ensaio: Equivalente de Areia","un",5,221.13,1105.6500000000001,1268.0922328353663]
["34.05.30","EMBASA/COMPOSIÇÃO","Ensaio: Teor de Matéria Orgânica","un",5,250,1250,1433.6501524390246,null,"Bonificação Sobre Despesas indiretas (B.D.I) =",null,{"$f":"(((1+L18+L15+L16)*(1+L17)*(1+L22))/(1-L27))-1","v":0.14692012195121973}]
["GT6.2.4","CODE","Ensaio: Reatividade Potencial","un",5,986.27,4931.3500000000004,5655.8645433841475]
["\nSE 14.10.0100","SCO/COMPOSIÇÃO","Geofísica: Refração Sísmica","km",2,{"$f":"5.93*1000","v":5930},11860,13602.472646341466]
["TOTAL SERVIÇOS GEOTÉCNICOS",{"$nulls":6},{"$f":"SUM(H9:H33)","v":467711.98421389027}]
["LEGENDA:"]
["Uni - unidade de medição do insumo;"]
["Qde - Quantidade do Insumo (não pode ocorrer alteração pela Licitante)"]
["CU -  Custo Unitário (composições padrão da Codevasf, já incluso o FatorK)"]
["PT - Preço Total (incluído encargos, taxas e impostos) - PT = Qde x PU"]

{"sheet":"PFP2.1_FatorKa","index":3,"n_rows":41,"n_cols":6,"rows_kept":41,"cut":false,"hidden":false,"merged":[[35,1,35,3],[6,1,6,3],[40,0,40,5],[39,0,39,5],[38,0,38,5],[37,0,37,5],[22,1,22,3],[29,1,29,3],[30,1,30,3],[28,1,28,3],[25,1,25,3],[26,1,26,3],[27,1,27,3],[33,1,33,3],[31,1,31,3],[32,1,32,3],[34,1,34,3],[0,0,1,4],[2,0,2,5],[5,0,5,1],[5,2,5,4],[4,2,4,4],[3,0,3,5],[24,1,24,3],[7,1,7,3],[17,1,17,3],[8,1,8,3],[13,1,13,3],[14,1,14,3],[15,1,15,3],[18,1,18,3],[19,1,19,3],[20,1,20,3],[21,1,21,3],[23,1,23,3],[9,1,9,3],[10,1,10,3],[11,1,11,3],[12,1,12,3]]}
["DETALHAMENTO DOS ENCARGOS SOCIAIS: Ka",{"$nulls":4},"CODIGO:"]
[{"$nulls":5},"PFP-2.1"]
["NOME DA CONSULTORA:"]
[]
["PROJETO:",null,"CONTRATANTE:",null,null,{"$f":"PFP!L5","v":"BASE:"}]
[{"$f":"PFP!B6","v":"Elaboração de Estudo de Viabilidade Técnica, Econômica e Ambiental da barragem de Gravatá, município de Novo Cruzeiro, no estado de Minas Gerais "},null,"CODEVASF (SEDE)",null,null,"SINAPI/MG"]
["Cod","DESCRIÇÃO",null,null,"%","R$"]
["A","ENCARGOS SOCIAIS BÁSICOS",null,null,{"$f":"ROUND(SUM(E9:E17),4)","v":0.38},{"$f":"ROUND(E8*SUMIF(PFP!$C$8:$C$24,\"MO1\",PFP!$L$8:$L$24),2)","v":140817.85999999999}]
["A1","INSS",null,null,0.2,{"$f":"ROUND(E9*SUMIF(PFP!$C$8:$C$24,\"MO1\",PFP!$L$8:$L$24),2)","v":74114.66}]
["A2","SESI",null,null,1.4999999999999999E-2,{"$f":"ROUND(E10*SUMIF(PFP!$C$8:$C$24,\"MO1\",PFP!$L$8:$L$24),2)","v":5558.6}]
["A3","SENAI",null,null,0.01,{"$f":"ROUND(E11*SUMIF(PFP!$C$8:$C$24,\"MO1\",PFP!$L$8:$L$24),2)","v":3705.73}]
["A4","INCRA",null,null,2E-3,{"$f":"ROUND(E12*SUMIF(PFP!$C$8:$C$24,\"MO1\",PFP!$L$8:$L$24),2)","v":741.15}]
["A5","SEBRAE",null,null,6.0000000000000001E-3,{"$f":"ROUND(E13*SUMIF(PFP!$C$8:$C$24,\"MO1\",PFP!$L$8:$L$24),2)","v":2223.44}]
["A6","Salário Educação",null,null,2.5000000000000001E-2,{"$f":"ROUND(E14*SUMIF(PFP!$C$8:$C$24,\"MO1\",PFP!$L$8:$L$24),2)","v":9264.33}]
["A7","Seguro Contra Acidentes de Trabalho",null,null,0.03,{"$f":"ROUND(E15*SUMIF(PFP!$C$8:$C$24,\"MO1\",PFP!$L$8:$L$24),2)","v":11117.2}]
["A8","FGTS",null,null,0.08,{"$f":"ROUND(E16*SUMIF(PFP!$C$8:$C$24,\"MO1\",PFP!$L$8:$L$24),2)","v":29645.86}]
["A9","SECONCI",null,null,1.2E-2,{"$f":"ROUND(E17*SUMIF(PFP!$C$8:$C$24,\"MO1\",PFP!$L$8:$L$24),2)","v":4446.88}]
["B"," ENCARGOS SOCIAIS QUE RECEBEM INCIDÊNCIA DE \"A\"",null,null,{"$f":"ROUND(SUM(E19:E25),4)","v":9.6799999999999997E-2},{"$f":"ROUND(E18*SUMIF(PFP!$C$8:$C$24,\"MO1\",PFP!$L$8:$L$24),2)","v":35871.5}]
["B3","Auxílio Enfermidade",null,null,6.4000000000000003E-3,{"$f":"ROUND(E19*SUMIF(PFP!$C$8:$C$24,\"MO1\",PFP!$L$8:$L$24),2)","v":2371.67}]
["B4","13º Salário",null,null,8.3299999999999999E-2,{"$f":"ROUND(E20*SUMIF(PFP!$C$8:$C$24,\"MO1\",PFP!$L$8:$L$24),2)","v":30868.76}]
["B5","Licença Paternidade",null,null,4.0000000000000002E-4,{"$f":"ROUND(E21*SUMIF(PFP!$C$8:$C$24,\"MO1\",PFP!$L$8:$L$24),2)","v":148.22999999999999}]
["B6","Faltas Justificadas",null,null,5.5999999999999999E-3,{"$f":"ROUND(E22*SUMIF(PFP!$C$8:$C$24,\"MO1\",PFP!$L$8:$L$24),2)","v":2075.21}]
["B8","Auxílio Acidente de Trabalho",null,null,8.0000000000000004E-4,{"$f":"ROUND(E23*SUMIF(PFP!$C$8:$C$24,\"MO1\",PFP!$L$8:$L$24),2)","v":296.45999999999998}]
["B9","Férias Gozadas",null,null,0,{"$f":"ROUND(E24*SUMIF(PFP!$C$8:$C$24,\"MO1\",PFP!$L$8:$L$24),2)","v":0}]
["B10","Salário Maternidade",null,null,2.9999999999999997E-4,{"$f":"ROUND(E25*SUMIF(PFP!$C$8:$C$24,\"MO1\",PFP!$L$8:$L$24),2)","v":111.17}]
["C"," ENCARGOS SOCIAIS QUE NÃO RECEBEM INCIDÊNCIA DE \"A\"",null,null,{"$f":"ROUND(SUM(E27:E31),4)","v":0.1603},{"$f":"ROUND(E26*SUMIF(PFP!$C$8:$C$24,\"MO1\",PFP!$L$8:$L$24),2)","v":59402.9}]
["C1","Aviso Prévio Indenizado",null,null,4.4999999999999998E-2,{"$f":"ROUND(E27*SUMIF(PFP!$C$8:$C$24,\"MO1\",PFP!$L$8:$L$24),2)","v":16675.8}]
["C2","Aviso Prévio Trabalhado",null,null,1.1000000000000001E-3,{"$f":"ROUND(E28*SUMIF(PFP!$C$8:$C$24,\"MO1\",PFP!$L$8:$L$24),2)","v":407.63}]
["C3","Férias Indenizadas",null,null,9.0999999999999998E-2,{"$f":"ROUND(E29*SUMIF(PFP!$C$8:$C$24,\"MO1\",PFP!$L$8:$L$24),2)","v":33722.17}]
["C4","Depósito Rescisão Sem Justa Causa",null,null,1.9400000000000001E-2,{"$f":"ROUND(E30*SUMIF(PFP!$C$8:$C$24,\"MO1\",PFP!$L$8:$L$24),2)","v":7189.12}]
["C5","Indenização Adicional",null,null,3.8E-3,{"$f":"ROUND(E31*SUMIF(PFP!$C$8:$C$24,\"MO1\",PFP!$L$8:$L$24),2)","v":1408.18}]
["D"," REINCIDÊNCIAS",null,null,{"$f":"ROUND(SUM(E33:E34),4)","v":4.0800000000000003E-2},{"$f":"ROUND(E32*SUMIF(PFP!$C$8:$C$24,\"MO1\",PFP!$L$8:$L$24),2)","v":15119.39}]
["D1","Reincidência de \"A\" sobre \"B\"",null,null,3.6799999999999999E-2,{"$f":"ROUND(E33*SUMIF(PFP!$C$8:$C$24,\"MO1\",PFP!$L$8:$L$24),2)","v":13637.1}]
["D2","Reincidência de \"A\" sobre Aviso Prévio Trabalhado e reincidência do FGTS sobre Aviso Prévio Indenizado",null,null,4.0000000000000001E-3,{"$f":"ROUND(E34*SUMIF(PFP!$C$8:$C$24,\"MO1\",PFP!$L$8:$L$24),2)","v":1482.29}]
["K1a","ENCARGOS SOCIAIS",null,null,{"$f":"ROUND(E8+E18+E26+E32,4)","v":0.67789999999999995},{"$f":"ROUND(E35*SUMIF(PFP!$C$8:$C$24,\"MO1\",PFP!$L$8:$L$24),2)","v":251211.65}]
["Ka","TAXA DE RESSARCIMENTO DE DESPESAS E ENCARGOS SOBRE MO1",null,null,{"$f":"ROUND((1+E35+PFP3_FatorKd!E13)*(1+PFP3_FatorKd!E12)*(1+PFP3_FatorKd!E8),4)","v":2.1019999999999999}]
["OBSERVAÇÃO: CELETISTAS E EQUIVALENTES"]
["1 - DISCRIMINAR OS ENCARGOS SOCIAIS COM SEUS RESPECTIVOS PERCENTUAS TOTALIZANDO OS MESMOS. "]
["2 - APLICAR O  % TOTAL P/ CALCULAR OS E. SOCIAIS INCIDENTES NA MÃO-DE-OBRA CELETISTAS"]
["Ka - Taxa de Ressarcimento de Despesas e Encargos sobre a Mão de Obra CELETISTA (incide apenas no Insumo Codigo MO1)"]
["Ka = (1 + K1 + K2) x (1 + K3) x (1 + K4)"]

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

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

{"sheet":"PFP3_FatorKd","index":6,"n_rows":35,"n_cols":6,"rows_kept":35,"cut":false,"hidden":false,"merged":[[32,0,32,5],[12,1,12,3],[11,1,11,3],[8,1,8,2],[9,1,9,2],[10,1,10,2],[7,1,7,2],[25,0,25,5],[6,1,6,2],[0,0,1,4],[2,0,2,5],[5,0,5,1],[5,2,5,4],[4,2,4,4],[3,0,3,5],[33,0,33,5],[34,0,34,5],[16,1,16,3],[13,1,13,3],[14,1,14,3],[15,1,15,3],[21,0,21,5],[26,0,26,5],[27,0,27,5],[22,0,22,5],[23,0,23,5],[24,0,24,5],[28,0,28,5],[29,0,29,5],[30,0,30,5],[31,0,31,5]]}
["DESPESAS FISCAIS E CUSTOS DIVERSOS: Kc",{"$nulls":4},"CODIGO:"]
[{"$nulls":5},"PFP-3"]
["NOME DA CONSULTORA:"]
[]
["PROJETO:",null,"CONTRATANTE:",null,null,{"$f":"PFP2.3_FatorKc!F5","v":"BASE:"}]
[{"$f":"PFP!B6","v":"Elaboração de Estudo de Viabilidade Técnica, Econômica e Ambiental da barragem de Gravatá, município de Novo Cruzeiro, no estado de Minas Gerais "},null,"CODEVASF (SEDE)",null,null,{"$f":"PFP2.3_FatorKc!F6","v":"SINAPI/MG"}]
["Cod","DESCRIÇÃO1",null,"% preço2","% custo4","R$"]
["K4","TRIBUTOS",null,{"$f":"ROUND(D9+D10+D11,4)","v":0.104},{"$f":"ROUND(E9+E10+E11,4)","v":0.11609999999999999},{"$f":"E8*SUM(SUMIF(PFP!$C$8:$C$24,\"MO1\",PFP!$L$8:$L$24)*(1+PFP2.1_FatorKa!$E$35)+SUMIF(PFP!$C$8:$C$24,\"MO2\",PFP!$L$8:$L$24)*(1+PFP2.2_FatorKb!$E$34)+SUMIF(PFP!$C$8:$C$24,\"<>MO*\",PFP!$L$8:$L$24)+$F$13+$F$12)","v":167429.63652465047}]
["K4.1","ISS",null,0.03,{"$f":"ROUND((1/(1-$D$8))*D9,4)","v":3.3500000000000002E-2},{"$f":"E9*SUM(SUMIF(PFP!$C$8:$C$24,\"MO1\",PFP!$L$8:$L$24)*(1+PFP2.1_FatorKa!$E$35)+SUMIF(PFP!$C$8:$C$24,\"MO2\",PFP!$L$8:$L$24)*(1+PFP2.2_FatorKb!$E$34)+SUMIF(PFP!$C$8:$C$24,\"<>MO*\",PFP!$L$8:$L$24)+$F$13+$F$12)","v":48310.877033383214}]
["K4.2","PIS3 - aliquota efetiva aplicavel percentual-desconto",null,{"$f":"ROUND(1.65%*0.8,4)","v":1.32E-2},{"$f":"ROUND((1/(1-$D$8))*D10,4)","v":1.47E-2},{"$f":"E10*SUM(SUMIF(PFP!$C$8:$C$24,\"MO1\",PFP!$L$8:$L$24)*(1+PFP2.1_FatorKa!$E$35)+SUMIF(PFP!$C$8:$C$24,\"MO2\",PFP!$L$8:$L$24)*(1+PFP2.2_FatorKb!$E$34)+SUMIF(PFP!$C$8:$C$24,\"<>MO*\",PFP!$L$8:$L$24)+$F$13+$F$12)","v":21199.10126539502}]
["K4.3","COFINS3 - aliquota efetiva aplicavel percentual-desconto",null,{"$f":"ROUND(7.6%*0.8,4)","v":6.08E-2},{"$f":"ROUND((1/(1-$D$8))*D11,4)","v":6.7900000000000002E-2},{"$f":"E11*SUM(SUMIF(PFP!$C$8:$C$24,\"MO1\",PFP!$L$8:$L$24)*(1+PFP2.1_FatorKa!$E$35)+SUMIF(PFP!$C$8:$C$24,\"MO2\",PFP!$L$8:$L$24)*(1+PFP2.2_FatorKb!$E$34)+SUMIF(PFP!$C$8:$C$24,\"<>MO*\",PFP!$L$8:$L$24)+$F$13+$F$12)","v":97919.658225872234}]
["K3","REMUNERAÇÃO DA EMPRESA (LUCRO)",null,null,7.7499999999999999E-2,{"$f":"E12*SUM(SUMIF(PFP!$C$8:$C$24,\"MO1\",PFP!$L$8:$L$24)*(1+PFP2.1_FatorKa!$E$35)+SUMIF(PFP!$C$8:$C$24,\"MO2\",PFP!$L$8:$L$24)*(1+PFP2.2_FatorKb!$E$34)+SUMIF(PFP!$C$8:$C$24,\"<>MO*\",PFP!$L$8:$L$24)+$F$13)","v":103725.26149079749}]
["K2","CUSTOS DA ADMINISTRAÇÃO CENTRAL",null,null,{"$f":"ROUND(SUM(E14:E16),4)","v":7.0000000000000007E-2},{"$f":"ROUND(E13*SUMIF(PFP!$C$8:$C$24,\"MO*\",PFP!$L$8:$L$24),2)","v":57252.38}]
["K2.1","Custos da administração central da empresa (diretoria, pessoal técnico de apoio e pessoal administrativo não diretamente vinculado à prestação dos serviços)",null,null,0.04,{"$f":"ROUND(E14*SUMIF(PFP!$C$8:$C$24,\"MO*\",PFP!$L$8:$L$24),2)","v":32715.65}]
["K2.2","Outras despesas que afetam o custo de produção como treinamento, biblioteca, programa de qualidade, programa de benefícios, auditoria interna e externa",null,null,0.02,{"$f":"ROUND(E15*SUMIF(PFP!$C$8:$C$24,\"MO*\",PFP!$L$8:$L$24),2)","v":16357.82}]
["K2.3","Despesas fixas e variaveis com patrimônio, aluguéis, comunicação, manutenção e transporte não diretamente relacionados com o custo direto dos serviços",null,null,0.01,{"$f":"ROUND(E16*SUMIF(PFP!$C$8:$C$24,\"MO*\",PFP!$L$8:$L$24),2)","v":8178.91}]
["Kd","TAXA RESSARCIMENTO DE DESPESAS SOBRE CUSTOS DIVERSOS",null,null,{"$f":"ROUND((1+E12)*(1+E8),4)","v":1.2025999999999999}]
["NOME DO INFORMANTE:",null,null,null,"QUALIFICAÇÃO:"]
[]
["ASSINATURA:",null,null,null,"DATA:"]
[]
["Observação:"]
["1 - RELACIONAR OS CUSTOS DE ADMINISTRAÇÃO COM RESPECTIVOS PERCENTUAIS INCIDENTES NA MÃO -DE-OBRA"]
["1 - DISCRIMINAR OS TRIBUTOS QUE INCIDEM SOBRE OS CUSTOS DA PRESTAÇÃO DOS SERVIÇOS"]
["2 - K4 = INDICAR % DE CADA TRIBUTO E A SOMA DOS MESMOS (ex: ISS 5% + PIS 1,65% + COFINS 7,60% = 14,25%)"]
["3 - PIS e COFINS, Regime de Incidencia Acumulativa (0,65% e 3,00% - sem percentual de desconto) ou em Regime de Incidencia Não Acumulativa (1,65% e 7,60% - aplicável percentual de desconto) de acordo com a forma de apuração do lucro no IRPJ. APRESENTAR COMPROVANTES de aproveitamento de créditos tributários dos últimos 12 meses em caso de aplicação de \"percentual de desconto\"."]
["4 - AS DESPESAS FISCAIS (K4) INCIDEM SOBRE O TOTAL DA FATURA E NÃO SOBRE OS CUSTOS INCORRIDOS, "]
["     DEVENDO SER CALCULADO O K4' APLICANDO-SE A SEGUINTE FÓRMULA:"]
["     K4' = { [ 1 / ( 1 - K4) ] - 1 } x 100"]
[{"$f":"CONCATENATE(\"     K4' = { [ 1 / ( 1 - \",D8,\" ) ] - 1 } x 100\")","v":"     K4' = { [ 1 / ( 1 - 0,104 ) ] - 1 } x 100"}]
["Kc - Taxa de Ressarcimento de Despesas sobre Custos Diversos (incide sobre os Insumos Codigo DP e EM)"]
["Kc = (1 + K3) x (1 + K4)"]
["K2 - Incide sobre o Custo Total (CT) da Mão de Obra (MO* = MO1 + MO2)"]
["K3 - Incide sobre o Custo Total (CT) Mão de Obra com encargos (MO1 x Ka ou MO2 x Kb), demais Custos (DP e EM), e Custos da Administração Central (K2)"]
["K4 -  Incide sobre o Custo Total (CT) Mão de Obra com encargos (MO1 x Ka ou MO2 x Kb), demais Custos (DP e EM), e Custos da Administração Central (K2) e Lucro (K3)"]

{"sheet":"CRO1_Ins-Pro","index":7,"n_rows":89,"n_cols":19,"rows_kept":89,"cut":false,"hidden":false,"merged":[[87,0,87,7],[86,0,86,8],[21,0,22,0],[21,1,22,1],[2,0,3,0],[2,1,3,1],[2,2,3,2],[2,3,3,3],[2,4,3,4],[2,5,3,5],[2,7,2,17]]}
["INSUMOS POR ETAPA/PRODUTO",{"$nulls":16},"CÓDIGO:"]
[{"$nulls":17},"CRO-1"]
["Cod.","Categoria / Insumo","Uni","Qde","CUD","PU","FatorK","E1.EVTEA"]
[{"$nulls":6},"Meses","EVTEA","P 1.1","P 1.2","P 1.3","P 1.4","P 1.5","P 1.6","P 1.7","P 1.8","P 1.9","P 1.10"]
[{"$f":"PFP!D8","v":"P0"},{"$f":"PFP!F8","v":"Engenheiro coordenador (P8061)"},"mês",{"$f":"SUM(H5:H5)","v":5},{"$f":"PFP!I8","v":17866.689999999999},{"$f":"PFP!J8","v":22990.86},{"$f":"PFP!K8","v":1.2867999999999999},{"$f":"'CRO2_Ins-Mes'!E17","v":5},{"$f":"'CRO2_Ins-Mes'!E34","v":1},{"$f":"'CRO2_Ins-Mes'!E50","v":0.1},{"$f":"'CRO2_Ins-Mes'!E66","v":0.22500000000000001},{"$f":"'CRO2_Ins-Mes'!E82","v":0.22500000000000001},{"$f":"'CRO2_Ins-Mes'!E98","v":0.22500000000000001},{"$f":"'CRO2_Ins-Mes'!E114","v":0.22500000000000001},{"$f":"'CRO2_Ins-Mes'!E131","v":1},{"$f":"'CRO2_Ins-Mes'!E147","v":0.66666666666666663},{"$f":"'CRO2_Ins-Mes'!E163","v":0.66666666666666663},{"$f":"'CRO2_Ins-Mes'!E179","v":0.66666666666666663}]
[{"$f":"PFP!D9","v":"P1"},{"$f":"PFP!F9","v":"Engenheiro sênior (P8067)"},"mês",{"$f":"SUM(H6:H6)","v":23},{"$f":"PFP!I9","v":15564.54},{"$f":"PFP!J9","v":23771.72},{"$f":"PFP!K9","v":1.5273000000000001},{"$f":"'CRO2_Ins-Mes'!E18","v":23},{"$f":"'CRO2_Ins-Mes'!E35","v":1},{"$f":"'CRO2_Ins-Mes'!E51","v":0.8},{"$f":"'CRO2_Ins-Mes'!E67","v":1.55},{"$f":"'CRO2_Ins-Mes'!E83","v":1.55},{"$f":"'CRO2_Ins-Mes'!E99","v":1.55},{"$f":"'CRO2_Ins-Mes'!E115","v":1.55},{"$f":"'CRO2_Ins-Mes'!E132","v":6},{"$f":"'CRO2_Ins-Mes'!E148","v":4},{"$f":"'CRO2_Ins-Mes'!E164","v":2.5},{"$f":"'CRO2_Ins-Mes'!E180","v":2.5}]
[{"$f":"PFP!D10","v":"P2"},{"$f":"PFP!F10","v":"Engenheiro pleno (P8066)"},"mês",13,{"$f":"PFP!I10","v":12379.96},{"$f":"PFP!J10","v":26022.68},{"$f":"PFP!K10","v":2.1019999999999999},{"$f":"'CRO2_Ins-Mes'!E19","v":13},{"$f":"'CRO2_Ins-Mes'!E36","v":1},{"$f":"'CRO2_Ins-Mes'!E52","v":0.4},{"$f":"'CRO2_Ins-Mes'!E68","v":0.9},{"$f":"'CRO2_Ins-Mes'!E84","v":0.9},{"$f":"'CRO2_Ins-Mes'!E100","v":0.9},{"$f":"'CRO2_Ins-Mes'!E116","v":0.9},{"$f":"'CRO2_Ins-Mes'!E133","v":4},{"$f":"'CRO2_Ins-Mes'!E149","v":1.6666666666666665},{"$f":"'CRO2_Ins-Mes'!E165","v":1.1666666666666665},{"$f":"'CRO2_Ins-Mes'!E181","v":1.1666666666666665}]
[{"$f":"PFP!D11","v":"P3"},{"$f":"PFP!F11","v":"Engenheiro júnior (P8065)"},"mês",7,{"$f":"PFP!I11","v":12002},{"$f":"PFP!J11","v":25228.2},{"$f":"PFP!K11","v":2.1019999999999999},{"$f":"'CRO2_Ins-Mes'!E20","v":7},{"$f":"'CRO2_Ins-Mes'!E37","v":0},{"$f":"'CRO2_Ins-Mes'!E53","v":0.2},{"$f":"'CRO2_Ins-Mes'!E69","v":0.45},{"$f":"'CRO2_Ins-Mes'!E85","v":0.45},{"$f":"'CRO2_Ins-Mes'!E101","v":0.45},{"$f":"'CRO2_Ins-Mes'!E117","v":0.45},{"$f":"'CRO2_Ins-Mes'!E134","v":2},{"$f":"'CRO2_Ins-Mes'!E150","v":1.3333333333333333},{"$f":"'CRO2_Ins-Mes'!E166","v":0.83333333333333326},{"$f":"'CRO2_Ins-Mes'!E182","v":0.83333333333333326}]
[{"$f":"PFP!D12","v":"T1"},{"$f":"PFP!F12","v":"Técnico de projetos/obra (P8147)"},"mês",5,{"$f":"PFP!I12","v":3167.62},{"$f":"PFP!J12","v":6658.34},{"$f":"PFP!K12","v":2.1019999999999999},{"$f":"'CRO2_Ins-Mes'!E21","v":5},{"$f":"'CRO2_Ins-Mes'!E38","v":0},{"$f":"'CRO2_Ins-Mes'!E54","v":0.4},{"$f":"'CRO2_Ins-Mes'!E70","v":1.1499999999999999},{"$f":"'CRO2_Ins-Mes'!E86","v":1.1499999999999999},{"$f":"'CRO2_Ins-Mes'!E102","v":1.1499999999999999},{"$f":"'CRO2_Ins-Mes'!E118","v":1.1499999999999999},{"$f":"'CRO2_Ins-Mes'!E135","v":0},{"$f":"'CRO2_Ins-Mes'!E151","v":0},{"$f":"'CRO2_Ins-Mes'!E167","v":0},{"$f":"'CRO2_Ins-Mes'!E183","v":0}]
[{"$f":"PFP!D13","v":"D"},{"$f":"PFP!F13","v":"Desenhista (40807)"},"mês",13,{"$f":"PFP!I13","v":7442.91},{"$f":"PFP!J13","v":8950.84},{"$f":"PFP!K13","v":1.2025999999999999},{"$f":"'CRO2_Ins-Mes'!E22","v":13},{"$f":"'CRO2_Ins-Mes'!E39","v":1},{"$f":"'CRO2_Ins-Mes'!E55","v":0.6},{"$f":"'CRO2_Ins-Mes'!E71","v":1.35},{"$f":"'CRO2_Ins-Mes'!E87","v":1.35},{"$f":"'CRO2_Ins-Mes'!E103","v":1.35},{"$f":"'CRO2_Ins-Mes'!E119","v":1.35},{"$f":"'CRO2_Ins-Mes'!E136","v":2},{"$f":"'CRO2_Ins-Mes'!E152","v":1.6666666666666665},{"$f":"'CRO2_Ins-Mes'!E168","v":1.1666666666666665},{"$f":"'CRO2_Ins-Mes'!E184","v":1.1666666666666665}]
[{"$f":"PFP!D14","v":"A1"},{"$f":"PFP!F14","v":"Secretária (P8135)"},"mês",5,{"$f":"PFP!I14","v":2604.7800000000002},{"$f":"PFP!J14","v":5475.25},{"$f":"PFP!K14","v":2.1019999999999999},{"$f":"'CRO2_Ins-Mes'!E23","v":5},{"$f":"'CRO2_Ins-Mes'!E40","v":1},{"$f":"'CRO2_Ins-Mes'!E56","v":0.1},{"$f":"'CRO2_Ins-Mes'!E72","v":0.22500000000000001},{"$f":"'CRO2_Ins-Mes'!E88","v":0.22500000000000001},{"$f":"'CRO2_Ins-Mes'!E104","v":0.22500000000000001},{"$f":"'CRO2_Ins-Mes'!E120","v":0.22500000000000001},{"$f":"'CRO2_Ins-Mes'!E137","v":1},{"$f":"'CRO2_Ins-Mes'!E153","v":0.66666666666666663},{"$f":"'CRO2_Ins-Mes'!E169","v":0.66666666666666663},{"$f":"'CRO2_Ins-Mes'!E185","v":0.66666666666666663}]
[{"$f":"PFP!D15","v":"ECA"},{"$f":"PFP!F15","v":"Encargos Comp. e Adicionais"},"mês",71,{"$f":"PFP!I15","v":1046.1471428571431},{"$f":"PFP!J15","v":1258.0999999999999},{"$f":"PFP!K15","v":1.2025999999999999},{"$f":"SUM(H5:H11)","v":71},{"$f":"SUM(I5:I11)","v":5},{"$f":"SUM(J5:J11)","v":2.6},5.85,5.85,5.85,5.85,16,10,6.9999999999999991,6.9999999999999991]
[{"$f":"PFP!D16","v":"AT2"},{"$f":"PFP!F16","v":"Auxilio Transporte Técnicos"},"mês",0,{"$f":"PFP!I16","v":"Já incluso*"},{"$f":"PFP!J16","v":0},{"$f":"PFP!K16","v":1.2025999999999999}]
[{"$f":"PFP!D17","v":"AT3"},{"$f":"PFP!F17","v":"Auxilio Transporte Secretária"},"mês",0,{"$f":"PFP!I17","v":"Já Incluso*"},{"$f":"PFP!J17","v":0},{"$f":"PFP!K17","v":1.2025999999999999}]
[{"$f":"PFP!D18","v":"V1"},{"$f":"PFP!F18","v":"Diárias"},"dia",345,{"$f":"PFP!I18","v":187.18670833333334},{"$f":"PFP!J18","v":225.11},{"$f":"PFP!K18","v":1.2025999999999999},{"$f":"'CRO2_Ins-Mes'!E24","v":345},{"$f":"'CRO2_Ins-Mes'!E41","v":15},{"$f":"'CRO2_Ins-Mes'!E57","v":16},{"$f":"'CRO2_Ins-Mes'!E73","v":49.75},{"$f":"'CRO2_Ins-Mes'!E89","v":49.75},{"$f":"'CRO2_Ins-Mes'!E105","v":49.75},{"$f":"'CRO2_Ins-Mes'!E121","v":49.75},{"$f":"'CRO2_Ins-Mes'!E138","v":110},{"$f":"'CRO2_Ins-Mes'!E154","v":5},{"$f":"'CRO2_Ins-Mes'!E170","v":0},{"$f":"'CRO2_Ins-Mes'!E186","v":0}]
[{"$f":"PFP!D19","v":"V2"},{"$f":"PFP!F19","v":"Pick-up Cab.dupla 2.8 4x4 Diesel"},"dia",120,{"$f":"PFP!I19","v":325.62682583461901},{"$f":"PFP!J19","v":391.6},{"$f":"PFP!K19","v":1.2025999999999999},{"$f":"'CRO2_Ins-Mes'!E25","v":120},{"$f":"'CRO2_Ins-Mes'!E42","v":7},{"$f":"'CRO2_Ins-Mes'!E58","v":4.4000000000000004},{"$f":"'CRO2_Ins-Mes'!E74","v":9.9},{"$f":"'CRO2_Ins-Mes'!E90","v":9.9},{"$f":"'CRO2_Ins-Mes'!E106","v":9.9},{"$f":"'CRO2_Ins-Mes'!E122","v":9.9},{"$f":"'CRO2_Ins-Mes'!E139","v":62},{"$f":"'CRO2_Ins-Mes'!E155","v":7},{"$f":"'CRO2_Ins-Mes'!E171","v":0},{"$f":"'CRO2_Ins-Mes'!E187","v":0}]
[{"$f":"PFP!D20","v":"V3"},{"$f":"PFP!F20","v":"Passagens Aéreas (ida e volta)"},"um",31,{"$f":"PFP!I20","v":1195.25},{"$f":"PFP!J20","v":1437.41},{"$f":"PFP!K20","v":1.2025999999999999},{"$f":"'CRO2_Ins-Mes'!E26","v":31},{"$f":"'CRO2_Ins-Mes'!E43","v":3},{"$f":"'CRO2_Ins-Mes'!E59","v":0.8},{"$f":"'CRO2_Ins-Mes'!E75","v":3.05},{"$f":"'CRO2_Ins-Mes'!E91","v":3.05},{"$f":"'CRO2_Ins-Mes'!E107","v":3.05},{"$f":"'CRO2_Ins-Mes'!E123","v":3.05},{"$f":"'CRO2_Ins-Mes'!E140","v":10},{"$f":"'CRO2_Ins-Mes'!E156","v":5},{"$f":"'CRO2_Ins-Mes'!E172","v":0},{"$f":"'CRO2_Ins-Mes'!E188","v":0}]
[{"$f":"PFP!D21","v":"M1"},{"$f":"PFP!F21","v":"Relatório Parcial"},"un",0,{"$f":"PFP!I21","v":33.35},{"$f":"PFP!J21","v":40.11},{"$f":"PFP!K21","v":1.2025999999999999},{"$f":"'CRO2_Ins-Mes'!E27","v":0},{"$f":"'CRO2_Ins-Mes'!E44","v":0},{"$f":"'CRO2_Ins-Mes'!E60","v":0},{"$f":"'CRO2_Ins-Mes'!E76","v":0},{"$f":"'CRO2_Ins-Mes'!E92","v":0},{"$f":"'CRO2_Ins-Mes'!E108","v":0},{"$f":"'CRO2_Ins-Mes'!E124","v":0},{"$f":"'CRO2_Ins-Mes'!E141","v":0},{"$f":"'CRO2_Ins-Mes'!E157","v":0},{"$f":"'CRO2_Ins-Mes'!E173","v":0},{"$f":"'CRO2_Ins-Mes'!E189","v":0}]
[{"$f":"PFP!D22","v":"M2"},{"$f":"PFP!F22","v":"Relatório Final"},"un",10,{"$f":"PFP!I22","v":1478.8},{"$f":"PFP!J22","v":1778.4},{"$f":"PFP!K22","v":1.2025999999999999},{"$f":"'CRO2_Ins-Mes'!E28","v":10},{"$f":"'CRO2_Ins-Mes'!E45","v":1},{"$f":"'CRO2_Ins-Mes'!E61","v":1},{"$f":"'CRO2_Ins-Mes'!E77","v":1},{"$f":"'CRO2_Ins-Mes'!E93","v":1},{"$f":"'CRO2_Ins-Mes'!E109","v":1},{"$f":"'CRO2_Ins-Mes'!E125","v":1},{"$f":"'CRO2_Ins-Mes'!E142","v":1},{"$f":"'CRO2_Ins-Mes'!E158","v":1},{"$f":"'CRO2_Ins-Mes'!E174","v":1},{"$f":"'CRO2_Ins-Mes'!E190","v":1}]
[{"$f":"PFP!D23","v":"TOP"},{"$f":"PFP!F23","v":"Total Serviços Cartográficos"},"un",1,{"$f":"PFP!I23","v":"-"},{"$f":"PFP!J23","v":100644.98184031098},{"$f":"PFP!K23","v":"-"},{"$f":"'CRO2_Ins-Mes'!E29","v":1},{"$f":"'CRO2_Ins-Mes'!E46","v":0},{"$f":"'CRO2_Ins-Mes'!E62","v":0},{"$f":"'CRO2_Ins-Mes'!E78","v":1},{"$f":"'CRO2_Ins-Mes'!E94","v":0},{"$f":"'CRO2_Ins-Mes'!E110","v":0},{"$f":"'CRO2_Ins-Mes'!E126","v":0},{"$f":"'CRO2_Ins-Mes'!E143","v":0},{"$f":"'CRO2_Ins-Mes'!E159","v":0},{"$f":"'CRO2_Ins-Mes'!E175","v":0},{"$f":"'CRO2_Ins-Mes'!E191","v":0}]
[{"$f":"PFP!D24","v":"GEO"},{"$f":"PFP!F24","v":"Total Serviços Geotécnicos"},"un",1,{"$f":"PFP!I24","v":"-"},{"$f":"PFP!J24","v":467711.98421389027},{"$f":"PFP!K24","v":"-"},{"$f":"'CRO2_Ins-Mes'!E30","v":1},{"$f":"'CRO2_Ins-Mes'!E47","v":0},{"$f":"'CRO2_Ins-Mes'!E63","v":0},{"$f":"'CRO2_Ins-Mes'!E79","v":0},{"$f":"'CRO2_Ins-Mes'!E95","v":0},{"$f":"'CRO2_Ins-Mes'!E111","v":1},{"$f":"'CRO2_Ins-Mes'!E127","v":0},{"$f":"'CRO2_Ins-Mes'!E144","v":0},{"$f":"'CRO2_Ins-Mes'!E160","v":0},{"$f":"'CRO2_Ins-Mes'!E176","v":0},{"$f":"'CRO2_Ins-Mes'!E192","v":0}]
["TOTAL","VALOR TOTAL POR PRODUTO","R$",{"$f":"SUM(H22:H22)","v":1629948.73},null,null,null,{"$f":"SUMPRODUCT(F5:F19,H5:H19)","v":1629948.73},{"$f":"SUMPRODUCT(I5:I19,$F5:$F19)","v":105710.32999999999},56876.727000000006,126363.31574999999,126363.31574999999,126363.31574999999,126363.31574999999,428868.63,231404.28666666668,150817.74666666667,150817.74666666667,{"$f":"SUM(I22:R22)","v":1629948.7299999997}]
[null,null,"%",{"$f":"SUM(H23:H23)","v":1},null,null,null,{"$f":"ROUND(H22/$D$22,5)","v":1},6.4860000000000001E-2,3.4889999999999997E-2,7.7530000000000002E-2,7.7530000000000002E-2,7.7530000000000002E-2,7.7530000000000002E-2,0.26312000000000002,0.14197000000000001,9.2530000000000001E-2,9.2530000000000001E-2,{"$f":"SUM(I23:R23)","v":1.0000200000000001}]
{"$rows_empty":62}
["OBSERVAÇÃO:"]
["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"]
["T - Profissionais de nível médio técnico nas diversas áreas de atuação"]
["A - Profissionais de nível médio de apoio técnico-administrativo"]

{"sheet":"CRO2_Ins-Mes","index":8,"n_rows":193,"n_cols":13,"rows_kept":193,"cut":false,"hidden":false,"merged":[[0,0,1,12],[27,23,27,30]]}
["CRONOGRAMA SIMPLIFICADO"]
[]
["Cod1","Cod2","Produtos","Uni","Qde",1,2,3,4,5,6,7,8]
[1,"1.1","Detalhamento dos planos de desenvolvimnto regional","mês",{"$f":"SUM(F4:AB4)","v":1},1]
[1,"1.2","Caracterização Geográfica, Demográfica e Justificativas Iniciais","mês",{"$f":"SUM(G5:AB5)","v":1},null,1]
[1,"1.3","Estudos Topográfico","mês",2,null,1,1]
[1,"1.4","Estudos Hidrológicos","mês",2,null,1,1]
[1,"1.5","Estudos Geotécnicos","mês",2,null,1,1]
[1,"1.6","Diagnóstico Ambiental","mês",2,null,1,1]
[1,"1.7","Avaliação Técnica, Socioeconômica e Ambiental das Alternativas","mês",2,null,null,null,1,1]
[1,"1.8","Consolidação da alternativa mais viável","mês",2,{"$nulls":5},1,1]
[1,"1.9","Planilha orçamentária sintética da alternativa mais viável","mês",2,{"$nulls":6},1,1]
[1,"1.10","Relatório Síntese do EVTEA","mês",2,{"$nulls":6},1,1]
[1,1,"Estudo de Viabilidade Técnica, Econômica e Ambiental (EVTEA)","mês",{"$f":"SUM(F14:M14)","v":8},{"$f":"SUBTOTAL(4,F4:F13)","v":1},{"$f":"SUBTOTAL(4,G4:G13)","v":1},1,1,1,1,1,1]
["Total","Total","Balanço Temporal","mês",{"$f":"SUM(F15:AC15)","v":7},{"$f":"SUBTOTAL(4,F4:F4)","v":1},{"$f":"SUBTOTAL(4,G4:G4)","v":0},{"$f":"SUBTOTAL(4,H5:H14)","v":1},{"$f":"SUBTOTAL(4,I5:I14)","v":1},1,1,1,1]
["Cod1","Cod2","Insumos","Uni","Qde",1,2,3,4,5,6,7,8]
[1,{"$f":"PFP!D8","v":"P0"},{"$f":"PFP!F8","v":"Engenheiro coordenador (P8061)"},{"$f":"PFP!G8","v":"mês"},{"$f":"SUM(F17:M17)","v":5},1,0.5,0.5,0.5,0.5,0.5,0.5,1]
[1,{"$f":"PFP!D9","v":"P1"},{"$f":"PFP!F9","v":"Engenheiro sênior (P8067)"},{"$f":"PFP!G9","v":"mês"},{"$f":"SUM(F18:M18)","v":23},1,4,3,3,3,3,3,3]
[1,{"$f":"PFP!D10","v":"P2"},{"$f":"PFP!F10","v":"Engenheiro pleno (P8066)"},{"$f":"PFP!G10","v":"mês"},13,1,2,2,2,2,1,2,1]
[1,{"$f":"PFP!D11","v":"P3"},{"$f":"PFP!F11","v":"Engenheiro júnior (P8065)"},{"$f":"PFP!G11","v":"mês"},7,null,1,1,1,1,1,1,1]
[1,{"$f":"PFP!D12","v":"T1"},{"$f":"PFP!F12","v":"Técnico de projetos/obra (P8147)"},{"$f":"PFP!G12","v":"mês"},5,null,2,3,0,0,0,0,0]
[1,{"$f":"PFP!D13","v":"D"},{"$f":"PFP!F13","v":"Desenhista (40807)"},{"$f":"PFP!G13","v":"mês"},13,1,3,3,1,1,1,2,1]
[1,{"$f":"PFP!D14","v":"A1"},{"$f":"PFP!F14","v":"Secretária (P8135)"},{"$f":"PFP!G14","v":"mês"},5,1,0.5,0.5,0.5,0.5,0.5,0.5,1]
[1,{"$f":"PFP!D18","v":"V1"},{"$f":"PFP!F18","v":"Diárias"},{"$f":"PFP!G18","v":"dia"},345,{"$f":"SUM(F17:F21)*5","v":15},{"$f":"SUM(G18,(G19-2))*5*4","v":80},{"$f":"SUM(H18:H21)*5*3","v":135},{"$f":"SUM(I18:I21)*5*3","v":90},{"$f":"SUM(J18,J20)*5","v":20},{"$f":"K19*5","v":5}]
[1,{"$f":"PFP!D19","v":"V2"},{"$f":"PFP!F19","v":"Pick-up Cab.dupla 2.8 4x4 Diesel"},{"$f":"PFP!G19","v":"dia"},120,7,22,22,34,28,7]
[1,{"$f":"PFP!D20","v":"V3"},{"$f":"PFP!F20","v":"Passagens Aéreas (ida e volta)"},{"$f":"PFP!G20","v":"un"},31,{"$f":"(SUM(F17:F21))","v":3},{"$f":"(SUM(G18,(G19-2)))","v":4},{"$f":"(SUM(H18:H21))","v":9},{"$f":"SUM(I18:I21)","v":6},{"$f":"SUM(J18,J20)","v":4},{"$f":"K19*5","v":5}]
[null,"M1","Relatório Parcial",{"$f":"PFP!G21","v":"un"},0]
[null,"M2","Relatório Final",{"$f":"PFP!G21","v":"un"},{"$f":"SUM(F28:M28)","v":10},1,1,4,null,1,null,1,2]
[1,{"$f":"PFP!D23","v":"TOP"},{"$f":"PFP!F23","v":"Total Serviços Cartográficos"},{"$f":"PFP!G21","v":"un"},1,null,null,1]
[1,{"$f":"PFP!D24","v":"GEO"},{"$f":"PFP!F24","v":"Total Serviços Geotécnicos"},{"$f":"PFP!G22","v":"un"},1,null,null,1]
[1,null,"Estudo de Viabilidade Técnica, Econômica e Ambiental (EVTEA)",{"$f":"PFP!G23","v":"un"},{"$f":"SUM(F31:AC31)","v":0}]
["Total",null,"Balanço de Insumos",null,null,{"$f":"SUBTOTAL(2,F17:F31)","v":9},11,13,10,11,10,8,8]
["Cod1","Cod2","Insumos","Uni","Qde",1,2,3,4,5,6,7,8]
["1.1","P0","Engenheiro coordenador (P8061)","mês",{"$f":"SUM(F34:M34)","v":1},{"$f":"F17/SUM($F$4:$F$13)","v":1}]
["1.1","P1","Engenheiro sênior (P8067)","mês",{"$f":"SUM(F35:M35)","v":1},{"$f":"F18/SUM($F$4:$F$13)","v":1}]
["1.1","P2","Engenheiro pleno (P8066)","mês",1,1]
["1.1","P3","Engenheiro júnior (P8065)","mês",0,0]
["1.1","T1","Técnico de projetos/obra (P8147)","mês",0,0]
["1.1","D","Desenhista (40807)","mês",1,1]
["1.1","A1","Secretária (P8135)","mês",1,1]
["1.1","V1","Diárias","dia",15,15]
["1.1","V2","Pick-up Cab.dupla 2.8 4x4 Diesel","dia",7,7]
["1.1","V3","Passagens Aéreas (ida e volta)","un",3,3]
["1.1","M1","Relatório Parcial","un",0,{"$f":"F27/SUM($F$4:$F$13)","v":0}]
["1.1","M2","Relatório Final","un",1,{"$f":"F28","v":1}]
["1.1","TOP","Total Serviços Cartográficos","un",0,{"$f":"F29","v":0}]
["1.1","GEO","Total Serviços Geotécnicos","un",0,0]
["1.1",null,"Detalhamento dos planos de desenvolvimnto regional",{"$f":"PFP!G39","v":0}]
["Cod1","Cod2","Insumos","Uni","Qde",1,2,3,4,5,6,7,8]
["1.2","P0","Engenheiro coordenador (P8061)","mês",{"$f":"SUM(F50:M50)","v":0.1},null,{"$f":"G17/SUM(G$4:G$13)","v":0.1}]
["1.2","P1","Engenheiro sênior (P8067)","mês",{"$f":"SUM(F51:M51)","v":0.8},null,{"$f":"G18/SUM(G$4:G$13)","v":0.8}]
["1.2","P2","Engenheiro pleno (P8066)","mês",0.4,null,0.4]
["1.2","P3","Engenheiro júnior (P8065)","mês",0.2,null,0.2]
["1.2","T1","Técnico de projetos/obra (P8147)","mês",0.4,null,0.4]
["1.2","D","Desenhista (40807)","mês",0.6,null,0.6]
["1.2","A1","Secretária (P8135)","mês",0.1,null,0.1]
["1.2","V1","Diárias","dia",16,null,16]
["1.2","V2","Pick-up Cab.dupla 2.8 4x4 Diesel","dia",4.4000000000000004,null,4.4000000000000004]
["1.2","V3","Passagens Aéreas (ida e volta)","un",0.8,null,0.8]
["1.2","M1","Relatório Parcial","un",0,null,{"$f":"G27/SUM(G$4:G$13)","v":0}]
["1.2","M2","Relatório Final","un",1,null,{"$f":"G28","v":1}]
["1.2","TOP","Total Serviços Cartográficos","un",0,null,0]
["1.2","GEO","Total Serviços Geotécnicos","un",0,null,0]
["1.2",null,"Caracterização Geográfica, Demográfica e Justificativas Iniciais"]
["Cod1","Cod2","Insumos","Uni","Qde",1,2,3,4,5,6,7,8]
["1.3","P0","Engenheiro coordenador (P8061)","mês",{"$f":"SUM(F66:M66)","v":0.22500000000000001},null,{"$f":"G17/SUM(G$4:G$13)","v":0.1},{"$f":"H17/SUM(H$4:H$13)","v":0.125}]
["1.3","P1","Engenheiro sênior (P8067)","mês",{"$f":"SUM(F67:M67)","v":1.55},null,{"$f":"G18/SUM(G$4:G$13)","v":0.8},0.75]
["1.3","P2","Engenheiro pleno (P8066)","mês",0.9,null,0.4,0.5]
["1.3","P3","Engenheiro júnior (P8065)","mês",0.45,null,0.2,0.25]
["1.3","T1","Técnico de projetos/obra (P8147)","mês",1.1499999999999999,null,0.4,0.75]
["1.3","D","Desenhista (40807)","mês",1.35,null,0.6,0.75]
["1.3","A1","Secretária (P8135)","mês",0.22500000000000001,null,0.1,0.125]
["1.3","V1","Diárias","dia",49.75,null,16,33.75]
["1.3","V2","Pick-up Cab.dupla 2.8 4x4 Diesel","dia",9.9,null,4.4000000000000004,5.5]
["1.3","V3","Passagens Aéreas (ida e volta)","un",3.05,null,0.8,2.25]
["1.3","M1","Relatório Parcial","un",0]
["1.3","M2","Relatório Final","un",1,null,{"$f":"G27","v":0},{"$f":"H28/SUM(H6:H9)","v":1}]
["1.3","TOP","Total Serviços Cartográficos","un",1,null,0,1]
["1.3","GEO","Total Serviços Geotécnicos","un",0,null,0]
["1.3",null,"Estudos Topográficos"]
["Cod1","Cod2","Insumos","Uni","Qde",1,2,3,4,5,6,7,8]
["1.4","P0","Engenheiro coordenador (P8061)","mês",{"$f":"SUM(F82:M82)","v":0.22500000000000001},null,{"$f":"G17/SUM(G$4:G$13)","v":0.1},{"$f":"H17/SUM(H$4:H$13)","v":0.125}]
["1.4","P1","Engenheiro sênior (P8067)","mês",{"$f":"SUM(F83:M83)","v":1.55},null,{"$f":"G18/SUM(G$4:G$13)","v":0.8},0.75]
["1.4","P2","Engenheiro pleno (P8066)","mês",0.9,null,0.4,0.5]
["1.4","P3","Engenheiro júnior (P8065)","mês",0.45,null,0.2,0.25]
["1.4","T1","Técnico de projetos/obra (P8147)","mês",1.1499999999999999,null,0.4,0.75]
["1.4","D","Desenhista (40807)","mês",1.35,null,0.6,0.75]
["1.4","A1","Secretária (P8135)","mês",0.22500000000000001,null,0.1,0.125]
["1.4","V1","Diárias","dia",49.75,null,16,33.75]
["1.4","V2","Pick-up Cab.dupla 2.8 4x4 Diesel","dia",9.9,null,4.4000000000000004,5.5]
["1.4","V3","Passagens Aéreas (ida e volta)","un",3.05,null,0.8,2.25]
["1.4","M1","Relatório Parcial","un",0,null,{"$f":"G27","v":0},{"$f":"H27","v":0}]
["1.4","M2","Relatório Final","un",1,null,null,{"$f":"H28/SUM(H$4:H$13)","v":1}]
["1.4","TOP","Total Serviços Cartográficos","un",0,null,0]
["1.4","GEO","Total Serviços Geotécnicos","un",0,null,0]
["1.4",null,"Estudos Hidrológicos"]
["Cod1","Cod2","Insumos","Uni","Qde",1,2,3,4,5,6,7,8]
["1.5","P0","Engenheiro coordenador (P8061)","mês",{"$f":"SUM(F98:M98)","v":0.22500000000000001},null,{"$f":"G17/SUM(G$4:G$13)","v":0.1},{"$f":"H17/SUM(H$4:H$13)","v":0.125}]
["1.5","P1","Engenheiro sênior (P8067)","mês",{"$f":"SUM(F99:M99)","v":1.55},null,{"$f":"G18/SUM(G$4:G$13)","v":0.8},0.75]
["1.5","P2","Engenheiro pleno (P8066)","mês",0.9,null,0.4,0.5]
["1.5","P3","Engenheiro júnior (P8065)","mês",0.45,null,0.2,0.25]
["1.5","T1","Técnico de projetos/obra (P8147)","mês",1.1499999999999999,null,0.4,0.75]
["1.5","D","Desenhista (40807)","mês",1.35,null,0.6,0.75]
["1.5","A1","Secretária (P8135)","mês",0.22500000000000001,null,0.1,0.125]
["1.5","V1","Diárias","dia",49.75,null,16,33.75]
["1.5","V2","Pick-up Cab.dupla 2.8 4x4 Diesel","dia",9.9,null,4.4000000000000004,5.5]
["1.5","V3","Passagens Aéreas (ida e volta)","un",3.05,null,0.8,2.25]
["1.5","M1","Relatório Parcial","un",0]
["1.5","M2","Relatório Final","un",1,null,null,{"$f":"H28/SUM(H$4:H$13)","v":1}]
["1.5","TOP","Total Serviços Cartográficos","un",0,null,0]
["1.5","GEO","Total Serviços Geotécnicos","un",1,null,0,{"$f":"H30","v":1}]
["1.5",null,"Estudos Geotécnicos"]
["Cod1","Cod2","Insumos","Uni","Qde",1,2,3,4,5,6,7,8]
["1.6","P0","Engenheiro coordenador (P8061)","mês",{"$f":"SUM(F114:M114)","v":0.22500000000000001},null,{"$f":"G17/SUM(G$4:G$13)","v":0.1},{"$f":"H17/SUM(H$4:H$13)","v":0.125}]
["1.6","P1","Engenheiro sênior (P8067)","mês",{"$f":"SUM(F115:M115)","v":1.55},null,{"$f":"G18/SUM(G$4:G$13)","v":0.8},0.75]
["1.6","P2","Engenheiro pleno (P8066)","mês",0.9,null,0.4,0.5]
["1.6","P3","Engenheiro júnior (P8065)","mês",0.45,null,0.2,0.25]
["1.6","T1","Técnico de projetos/obra (P8147)","mês",1.1499999999999999,null,0.4,0.75]
["1.6","D","Desenhista (40807)","mês",1.35,null,0.6,0.75]
["1.6","A1","Secretária (P8135)","mês",0.22500000000000001,null,0.1,0.125]
["1.6","V1","Diárias","dia",49.75,null,16,33.75]
["1.6","V2","Pick-up Cab.dupla 2.8 4x4 Diesel","dia",9.9,null,4.4000000000000004,5.5]
["1.6","V3","Passagens Aéreas (ida e volta)","un",3.05,null,0.8,2.25]
["1.6","M1","Relatório Parcial","un",0]
["1.6","M2","Relatório Final","un",1,null,null,{"$f":"H28/SUM(H4:H13)","v":1}]
["1.6","TOP","Total Serviços Cartográficos","un",0,null,0]
["1.6","GEO","Total Serviços Geotécnicos","un",0,null,0]
["1.6",null,"Diagnóstico Ambiental"]
["Cod1","Cod2","Insumos","Uni","Qde",1,2,3,4,5,6,7,8]
[]
["1.7","P0","Engenheiro coordenador (P8061)","mês",{"$f":"SUM(F131:M131)","v":1},null,null,null,{"$f":"I17/SUM(I$4:I$13)","v":0.5},{"$f":"J17/SUM(J$4:J$13)","v":0.5}]
["1.7","P1","Engenheiro sênior (P8067)","mês",{"$f":"SUM(F132:M132)","v":6},null,null,null,{"$f":"I18/SUM(I$4:I$13)","v":3},3]
["1.7","P2","Engenheiro pleno (P8066)","mês",4,null,null,null,2,2]
["1.7","P3","Engenheiro júnior (P8065)","mês",2,null,null,null,1,1]
["1.7","T1","Técnico de projetos/obra (P8147)","mês",0,null,null,null,0,0]
["1.7","D","Desenhista (40807)","mês",2,null,null,null,1,1]
["1.7","A1","Secretária (P8135)","mês",1,null,null,null,0.5,0.5]
["1.7","V1","Diárias","dia",110,null,null,null,90,20]
["1.7","V2","Pick-up Cab.dupla 2.8 4x4 Diesel","dia",62,null,null,null,34,28]
["1.7","V3","Passagens Aéreas (ida e volta)","un",10,null,null,null,6,4]
["1.7","M1","Relatório Parcial","un",0,null,null,null,{"$f":"I28/SUM(I$4:I$13)","v":0}]
["1.7","M2","Relatório Final","un",1,{"$nulls":4},{"$f":"J28","v":1}]
["1.7","TOP","Total Serviços Cartográficos","un",0,null,null,null,0,0]
["1.7","GEO","Total Serviços Geotécnicos","un",0,null,null,null,0,0]
["1.7",null,"Avaliação Técnica, Socioeconômica e Ambiental das Alternativas"]
["Cod1","Cod2","Insumos","Uni","Qde",1,2,3,4,5,6,7,8]
["1.8","P0","Engenheiro coordenador (P8061)","mês",{"$f":"SUM(F147:M147)","v":0.66666666666666663},{"$nulls":5},{"$f":"K17/SUM(K$4:K$13)","v":0.5},{"$f":"L17/SUM(L$4:L$13)","v":0.16666666666666666}]
["1.8","P1","Engenheiro sênior (P8067)","mês",{"$f":"SUM(F148:M148)","v":4},{"$nulls":5},{"$f":"K18/SUM(K$4:K$13)","v":3},1]
["1.8","P2","Engenheiro pleno (P8066)","mês",1.6666666666666665,{"$nulls":5},1,0.66666666666666663]
["1.8","P3","Engenheiro júnior (P8065)","mês",1.3333333333333333,{"$nulls":5},1,0.33333333333333331]
["1.8","T1","Técnico de projetos/obra (P8147)","mês",0,{"$nulls":5},0,0]
["1.8","D","Desenhista (40807)","mês",1.6666666666666665,{"$nulls":5},1,0.66666666666666663]
["1.8","A1","Secretária (P8135)","mês",0.66666666666666663,{"$nulls":5},0.5,0.16666666666666666]
["1.8","V1","Diárias","dia",5,{"$nulls":5},5,0]
["1.8","V2","Pick-up Cab.dupla 2.8 4x4 Diesel","dia",7,{"$nulls":5},7,0]
["1.8","V3","Passagens Aéreas (ida e volta)","un",5,{"$nulls":5},5,0]
["1.8","M1","Relatório Parcial","un",0,{"$nulls":5},{"$f":"K28/SUM(K$4:K$13)","v":0}]
["1.8","M2","Relatório Final","un",1,{"$nulls":6},{"$f":"L28","v":1}]
["1.8","TOP","Total Serviços Cartográficos","un",0,{"$nulls":5},0,0]
["1.8","GEO","Total Serviços Geotécnicos","un",0,{"$nulls":5},0,0]
["1.8",null,"Consolidação da alternativa mais viável"]
["Cod1","Cod2","Insumos","Uni","Qde",1,2,3,4,5,6,7,8]
["1.9","P0","Engenheiro coordenador (P8061)","mês",{"$f":"SUM(F163:M163)","v":0.66666666666666663},{"$nulls":6},{"$f":"L17/SUM(L$4:L$13)","v":0.16666666666666666},{"$f":"M17/SUM(M$4:M$13)","v":0.5}]
["1.9","P1","Engenheiro sênior (P8067)","mês",{"$f":"SUM(F164:M164)","v":2.5},{"$nulls":6},{"$f":"L18/SUM(L$4:L$13)","v":1},1.5]
["1.9","P2","Engenheiro pleno (P8066)","mês",1.1666666666666665,{"$nulls":6},0.66666666666666663,0.5]
["1.9","P3","Engenheiro júnior (P8065)","mês",0.83333333333333326,{"$nulls":6},0.33333333333333331,0.5]
["1.9","T1","Técnico de projetos/obra (P8147)","mês",0,{"$nulls":6},0,0]
["1.9","D","Desenhista (40807)","mês",1.1666666666666665,{"$nulls":6},0.66666666666666663,0.5]
["1.9","A1","Secretária (P8135)","mês",0.66666666666666663,{"$nulls":6},0.16666666666666666,0.5]
["1.9","V1","Diárias","dia",0,{"$nulls":6},0,0]
["1.9","V2","Pick-up Cab.dupla 2.8 4x4 Diesel","dia",0,{"$nulls":6},0,0]
["1.9","V3","Passagens Aéreas (ida e volta)","un",0,{"$nulls":6},0,0]
["1.9","M1","Relatório Parcial","un",0]
["1.9","M2","Relatório Final","un",1,{"$nulls":7},1]
["1.9","TOP","Total Serviços Cartográficos","un",0,{"$nulls":6},0,0]
["1.9","GEO","Total Serviços Geotécnicos","un",0,{"$nulls":6},0,0]
["1.9",null,"Planilha orçamentária sintética da alternativa mais viável"]
["Cod1","Cod2","Insumos","Uni","Qde",1,2,3,4,5,6,7,8]
["1.10","P0","Engenheiro coordenador (P8061)","mês",{"$f":"SUM(F179:M179)","v":0.66666666666666663},{"$nulls":6},{"$f":"L17/SUM(L$4:L$13)","v":0.16666666666666666},{"$f":"M17/SUM(M$4:M$13)","v":0.5}]
["1.10","P1","Engenheiro sênior (P8067)","mês",{"$f":"SUM(F180:M180)","v":2.5},{"$nulls":6},{"$f":"L18/SUM(L$4:L$13)","v":1},1.5]
["1.10","P2","Engenheiro pleno (P8066)","mês",1.1666666666666665,{"$nulls":6},{"$f":"L19/SUM(L$4:L$13)","v":0.66666666666666663},0.5]
["1.10","P3","Engenheiro júnior (P8065)","mês",0.83333333333333326,{"$nulls":6},{"$f":"L20/SUM(L$4:L$13)","v":0.33333333333333331},0.5]
["1.10","T1","Técnico de projetos/obra (P8147)","mês",0,{"$nulls":6},{"$f":"L21/SUM(L$4:L$13)","v":0},0]
["1.10","D","Desenhista (40807)","mês",1.1666666666666665,{"$nulls":6},{"$f":"L22/SUM(L$4:L$13)","v":0.66666666666666663},0.5]
["1.10","A1","Secretária (P8135)","mês",0.66666666666666663,{"$nulls":6},{"$f":"L23/SUM(L$4:L$13)","v":0.16666666666666666},0.5]
["1.10","V1","Diárias","dia",0,{"$nulls":6},{"$f":"L24/SUM(L$4:L$13)","v":0},0]
["1.10","V2","Pick-up Cab.dupla 2.8 4x4 Diesel","dia",0,{"$nulls":6},{"$f":"L25/SUM(L$4:L$13)","v":0},0]
["1.10","V3","Passagens Aéreas (ida e volta)","un",0,{"$nulls":6},{"$f":"L26/SUM(L$4:L$13)","v":0},0]
["1.10","M1","Relatório Parcial","un",0]
["1.10","M2","Relatório Final","un",1,{"$nulls":7},1]
["1.10","TOP","Total Serviços Cartográficos","un",0,{"$nulls":6},{"$f":"L29/SUM(L$4:L$13)","v":0},0]
["1.10","GEO","Total Serviços Geotécnicos","un",0,{"$nulls":6},{"$f":"L30/SUM(L$4:L$13)","v":0},0]
["1.10",null,"Relatório Síntese do EVTEA"]

{"sheet":"CRO3_Fis-Finan","index":9,"n_rows":30,"n_cols":13,"rows_kept":30,"cut":false,"hidden":false,"merged":[[3,1,4,1],[3,0,4,0],[3,3,4,3],[5,1,6,1],[36,23,36,30],[24,3,25,3],[26,3,27,3],[28,3,29,3],[3,2,4,2],[13,3,14,3],[11,0,12,0],[13,0,14,0],[5,0,6,0],[5,2,6,2],[5,3,6,3],[7,2,8,2],[7,3,8,3],[7,1,8,1],[7,0,8,0],[9,1,10,1],[9,0,10,0],[9,2,10,2],[9,3,10,3],[11,3,12,3],[11,1,12,1],[13,1,14,1],[13,2,14,2],[15,2,16,2],[15,1,16,1],[0,0,1,11],[15,0,16,0],[17,2,18,2],[19,2,20,2],[21,2,22,2],[17,1,18,1],[17,0,18,0],[19,1,20,1],[19,0,20,0],[21,1,22,1],[21,0,22,0],[15,3,16,3],[17,3,18,3],[19,3,20,3],[21,3,22,3],[11,2,12,2]]}
["CRONOGRAMA FÍSICO-FINANCEIRO"]
[]
["Cod1","Cod2","Produtos",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"]
[1,"1.1","Detalhamento dos planos de desenvolvimnto regional",{"$f":"'CRO1_Ins-Pro'!I22","v":105710.32999999999},{"$f":"$D$4*E5","v":105710.32999999999},{"$f":"$D$4*F5","v":0},0,0,0,0,0,0,{"$f":"SUM(E4:L4)","v":105710.32999999999}]
[{"$nulls":4},1,0,{"$nulls":6},{"$f":"SUM(E5:L5)","v":1}]
[1,"1.2","Caracterização Geográfica, Demográfica e Justificativas Iniciais",{"$f":"'CRO1_Ins-Pro'!J22","v":56876.727000000006},{"$f":"$D$6*E7","v":0},{"$f":"$D$6*F7","v":56876.727000000006},0,0,0,0,0,0,56876.727000000006]
[{"$nulls":5},1,{"$nulls":6},1]
[1,"1.3","Estudos Topográfico",{"$f":"'CRO1_Ins-Pro'!K22+PFP1.1_Topo!H24","v":227008.29759031098},{"$f":"$D$8*E9","v":0},null,{"$f":"$D$8*(G9+F9)","v":227008.29759031098},{"$f":"$D$8*H9","v":0},0,0,0,0,227008.29759031098]
[{"$nulls":5},0.5,0.5,{"$nulls":5},1]
[1,"1.4","Estudos Hidrológicos",{"$f":"'CRO1_Ins-Pro'!L22","v":126363.31574999999},{"$f":"$D$10*E11","v":0},null,{"$f":"$D$10*(G11+F11)","v":126363.31574999999},{"$f":"$D$10*H11","v":0},0,0,0,0,126363.31574999999]
[{"$nulls":5},0.5,0.5,{"$nulls":5},1]
[1,"1.5","Estudos Geotécnicos",{"$f":"'CRO1_Ins-Pro'!M22+PFP1.2_Geo!H34","v":594075.29996389023},{"$f":"$D$12*E13","v":0},null,{"$f":"$D$12*(G13+F13)","v":594075.29996389023},{"$f":"$D$12*H13","v":0},0,0,0,0,594075.29996389023]
[{"$nulls":5},0.5,0.5,{"$nulls":5},1]
[1,"1.6","Diagnóstico Ambiental",{"$f":"'CRO1_Ins-Pro'!N22","v":126363.31574999999},{"$f":"$D$14*E15","v":0},null,{"$f":"$D$14*(G15+F15)","v":126363.31574999999},{"$f":"$D$14*H15","v":0},0,0,0,0,126363.31574999999]
[{"$nulls":5},0.5,0.5,{"$nulls":5},1]
[1,"1.7","Avaliação Técnica, Socioeconômica e Ambiental das Alternativas",{"$f":"'CRO1_Ins-Pro'!O22","v":428868.63},{"$f":"$D$16*E17","v":0},{"$f":"$D$16*F17","v":0},0,null,{"$f":"$D$16*(I17+H17)","v":428868.63},0,0,0,428868.63]
[{"$nulls":7},0.5,0.5,null,null,null,1]
[1,"1.8","Consolidação da alternativa mais viável",{"$f":"'CRO1_Ins-Pro'!P22","v":231404.28666666668},{"$f":"$D$18*E19","v":0},{"$f":"$D$18*F19","v":0},0,0,0,null,{"$f":"$D$18*(K19+J19)","v":231404.28666666668},0,231404.28666666668]
[{"$nulls":9},0.5,0.5,null,1]
[1,"1.9","Planilha orçamentária sintética da alternativa mais viável",{"$f":"'CRO1_Ins-Pro'!Q22","v":150817.74666666667},{"$f":"$D$20*E21","v":0},{"$f":"$D$20*F21","v":0},0,0,0,null,null,{"$f":"$D$20*(L21+K21)","v":150817.74666666667},150817.74666666667]
[{"$nulls":10},0.5,0.5,1]
[1,"1.10","Relatório Síntese do EVTEA",{"$f":"'CRO1_Ins-Pro'!R22","v":150817.74666666667},{"$f":"$D$22*E23","v":0},{"$f":"$D$22*F23","v":0},0,0,0,null,null,{"$f":"$D$22*(L23+K23)","v":150817.74666666667},150817.74666666667]
[{"$nulls":10},0.5,0.5,1]
[]
[null,null,null,"NO MÊS",{"$f":"SUM(E4,E6,E8,E10,E12,E14,E16,E18,E20,E22)","v":105710.32999999999},{"$f":"SUM(F4,F6,F8,F10,F12,F14,F16,F18,F20,F22)","v":56876.727000000006},1073810.2290542012,0,428868.63,0,231404.28666666668,301635.49333333335,{"$f":"SUM(E25:L25)","v":2198305.6960542011}]
[{"$nulls":4},{"$f":"E25/SUM($D$4:$D$22)","v":4.808718377509659E-2},{"$f":"F25/SUM($D$4:$D$22)","v":2.5872983499105513E-2},0.48847174939391391,0,0.19509053302722548,0,0.10526483513281185,0.13721271517184672,{"$f":"SUM(E26:L26)","v":1}]
[null,null,null,"DESENBOLSO",{"$f":"E25*1","v":105710.32999999999},{"$f":"F25*1","v":56876.727000000006},1073810.2290542012,0,428868.63,0,231404.28666666668,301635.49333333335,2198305.6960542011]
[null,null,0,null,{"$f":"E26*1","v":4.808718377509659E-2},{"$f":"F26*1","v":2.5872983499105513E-2},0.48847174939391391,0,0.19509053302722548,0,0.10526483513281185,0.13721271517184672,1]
[null,null,null,"ACUMILADO",{"$f":"E27","v":105710.32999999999},{"$f":"SUM(F27,E29)","v":162587.057},{"$f":"SUM(G27,F29)","v":1236397.2860542012},{"$f":"SUM(H27,G29)","v":1236397.2860542012},1665265.9160542013,1665265.9160542013,1896670.2027208679,2198305.6960542011]
[{"$nulls":4},{"$f":"E28","v":4.808718377509659E-2},{"$f":"SUM(F28,E30)","v":7.3960167274202099E-2},{"$f":"SUM(G28,F30)","v":0.56243191666811598},0.56243191666811598,0.75752244969534144,0.75752244969534144,0.86278728482815326,1]

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

{"sheet":"CPU HOSPEDAGEM","index":11,"n_rows":19,"n_cols":4,"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,"Código/Referencia"]
[null,"ALUGUEL ",3074.56,"F020003334/EMBASA"]
[null," Aquisição de Mobiliário",{"$f":"43.89*C16","v":175.56},"B8954/DNIT"]
[null,"Material de limpeza e diarista",{"$f":"126.93+(123*8)","v":1110.93},"10563/ORSE - E200300131/EMBASA"]
[null,"manutenção da casa alugada - Serviços Gerais/Vigia ",2706.8,"41096/SINAPI"]
[null,"Energia ",180,"10555/ORSE"]
[null,"Água",394.99,"10554/ORSE"]
[null,"telefone/Internet",{"$f":"154.99+89","v":243.99},"10557/10558/ORSE"]
[null,"IPTU (mês)",{"$f":"(C4*0.5)/12","v":128.10666666666665}]
[null,"Despesas Gerais - 10%",{"$f":"SUM(C4:C11)*0.1","v":801.49366666666674}]
[null,"Custo Mensal:",{"$f":"SUM(C4:C12)","v":8816.4303333333337}]
[null,"Custo Mensal por pessoa:",{"$f":"C13/C16","v":2204.1075833333334}]
[null,"Custo diário por pessoa:",{"$f":"C14/22","v":100.18670833333334}]
[null,"número de pessoas:",4]
[null,"Alimentação:",87,"Tabela Diária Codevasf"]
[]
[null,"Diária Total (alimentação + hospedagem):",{"$f":"C15+C17","v":187.18670833333334}]

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

{"sheet":"Cotação Voos","index":13,"n_rows":104,"n_cols":5,"rows_kept":104,"cut":false,"hidden":false,"merged":[]}
["COTAÇÕES - IDA DIA 04/011/2024 E VOLTA DIA 08/011/2024"]
[]
["BSB - Montes Claros","Cia 1","Cia 2","Cia 3","Média"]
[null,886,979,2105,{"$f":"AVERAGE(B4:D4)","v":1323.3333333333333}]
{"$rows_empty":24}
["SP - Montes Claros","Cia 1","Cia 2","Cia 3","Média"]
[null,683,744,743,{"$f":"AVERAGE(B30:D30)","v":723.33333333333337}]
{"$rows_empty":24}
["CURITIBA - Montes Claros","Cia 1","Cia 2","Cia 3","Média"]
[null,926,968,1045,{"$f":"AVERAGE(B56:D56)","v":979.66666666666663}]
{"$rows_empty":23}
["Joao Pessoa - Montes Claros","Cia 1","Cia 2","Cia 3","Média"]
[null,1528,1561,2175,{"$f":"AVERAGE(B81:D81)","v":1754.6666666666667}]
{"$rows_empty":22}
["VALOR ADOTADO:",{"$f":"AVERAGE(E4:E81)","v":1195.25}]

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