{"text_format":"2","workbook":"xlsx","n_sheets":16,"sheets":["PFP","PFP1.1_Topo","PFP1.2_Geo","PFP1.3_Amb","PFP2.1_FatorKa","PFP2.2_FatorKb","PFP2.3_FatorKc","PFP3_FatorKd","CRO1_Ins-Pro","CRO2_Ins-Mes","CPU PICK-UP","MDO_DNIT","CPU HOSPEDAGEM","Cotação Voos","Serv Graficos","COT. VANT"],"not_rendered":{"charts":0,"images":22,"macros":0,"external_links":49,"defined_names":13503,"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":44,"n_cols":17,"rows_kept":44,"cut":false,"hidden":false,"merged":[[28,8,28,11],[28,0,28,7],[27,8,27,11],[27,0,27,7],[35,0,35,11],[29,0,29,7],[29,8,29,11],[32,0,32,11],[31,0,31,11],[43,0,43,11],[36,0,36,11],[38,0,38,11],[30,0,30,11],[37,0,37,11],[33,0,33,11],[39,0,39,11],[40,0,40,11],[41,0,41,11],[42,0,42,11],[34,0,34,11],[0,0,1,9],[4,6,4,9],[0,10,0,11],[1,10,1,11],[4,10,4,11],[2,0,2,11],[3,0,3,11],[4,0,4,5],[5,10,5,11],[5,6,5,9],[26,0,26,7],[26,8,26,11],[5,0,5,5],[25,0,25,7],[25,8,25,11]]}
["PROPOSTA FINANCEIRA DO PROJETO",{"$nulls":9},"CODIGO:"]
[{"$nulls":10},"PFP"]
["NOME DA CONSULTORA:"]
[]
["PROJETO:",{"$nulls":5},"CONTRATANTE:",null,null,null,"BASE:"]
["Elaboração de Projeto Executivo da Adutora Agreste Potiguar, no Estado do Rio Grande do Norte ",{"$nulls":5},"CODEVASF (SEDE)",null,null,null,"2024-09-01"]
["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"]
["SICRO","MO3","P0","P8061","Engenheiro coordenador (P8061)","mês",{"$f":"'CRO1_Ins-Pro'!D5","v":8},{"$f":"VLOOKUP(D8,MDO_DNIT!$A:$Z,4,0)","v":17866.689999999999},{"$f":"ROUND(J8*H8,2)","v":23133.79},{"$f":"'PFP2.3_FatorKc'!E35","v":1.2948},{"$f":"ROUND(G8*H8,2)","v":142933.51999999999},{"$f":"ROUND(G8*I8,2)","v":185070.32},{"$f":"O8-N8","v":1026.7399999999998},13812.22,14838.96,null,{"$f":"VLOOKUP(D8,MDO_DNIT!$A:$Z,26,0)","v":1029.0600000000013}]
["SICRO","MO2","P1","P8067","Engenheiro sênior (P8067)","mês",{"$f":"'CRO1_Ins-Pro'!D6","v":39},{"$f":"VLOOKUP(D9,MDO_DNIT!$A:$Z,4,0)","v":15564.54},23919.59,{"$f":"'PFP2.2_FatorKb'!$E$35","v":1.5367999999999999},607017.06000000006,932864.01,{"$f":"O9-N9","v":1028.8999999999996},11987.94,13016.84,null,{"$f":"VLOOKUP(D9,MDO_DNIT!$A:$Z,26,0)","v":1031.2299999999996}]
["SICRO","MO1","P2","P8066","Engenheiro pleno (P8066)","mês",{"$f":"'CRO1_Ins-Pro'!D7","v":53},{"$f":"VLOOKUP(D10,MDO_DNIT!$A:$Z,4,0)","v":12379.96},{"$f":"ROUND(J10*H10,2)","v":26738.240000000002},{"$f":"'PFP2.1_FatorKa'!$E$36","v":2.1598000000000002},{"$f":"ROUND(G10*H10,2)","v":656137.88},1417126.72,1028.8999999999996,9457.76,10486.66,null,{"$f":"VLOOKUP(D10,MDO_DNIT!$A:$Z,26,0)","v":1031.2300000000014}]
["SICRO","MO1","P3","P8065","Engenheiro júnior (P8065)","mês",{"$f":"'CRO1_Ins-Pro'!D8","v":39},{"$f":"VLOOKUP(D11,MDO_DNIT!$A:$Z,4,0)","v":12002},{"$f":"ROUND(J11*H11,2)","v":25921.919999999998},{"$f":"'PFP2.1_FatorKa'!$E$36","v":2.1598000000000002},{"$f":"ROUND(G11*H11,2)","v":468078},1010954.88,1028.8999999999996,8921.02,9949.92,null,{"$f":"VLOOKUP(D11,MDO_DNIT!$A:$Z,26,0)","v":1031.2299999999996}]
["SICRO","MO1","T1","P8147","Técnico de projetos/obra (P8147)","mês",{"$f":"'CRO1_Ins-Pro'!D9","v":39},{"$f":"VLOOKUP(D12,MDO_DNIT!$A:$Z,4,0)","v":3167.62},6841.43,{"$f":"'PFP2.1_FatorKa'!$E$36","v":2.1598000000000002},123537.18,266815.77,1062.8600000000001,2509.9,3572.76,null,{"$f":"VLOOKUP(D12,MDO_DNIT!$A:$Z,26,0)","v":1063.04}]
["SINAPI","MO1","D",40807,"Desenhista (40807)","mês",{"$f":"'CRO1_Ins-Pro'!D10","v":35},4976.43,6021.98,{"$f":"PFP3_FatorKd!$E$17","v":1.2101},174175.05,210769.3,1070.1799999999998,2450.48,3520.66,null,{"$f":"Q14","v":1068.6199999999999}]
["SICRO","MO1","A1","P8135","Secretária (P8135)","mês",{"$f":"'CRO1_Ins-Pro'!D11","v":7},{"$f":"VLOOKUP(D14,MDO_DNIT!$A:$Z,4,0)","v":2604.7800000000002},{"$f":"ROUND(J14*H14,2)","v":5625.8},{"$f":"'PFP2.1_FatorKa'!$E$36","v":2.1598000000000002},{"$f":"ROUND(G14*H14,2)","v":18233.46},{"$f":"ROUND(G14*I14,2)","v":39380.6},1074.8799999999999,1969.72,3044.6,null,{"$f":"VLOOKUP(D14,MDO_DNIT!$A:$Z,26,0)","v":1068.6199999999999}]
["SICRO","EC","ECA",null,"Encargos Comp. e Adicionais","mês",{"$f":"'CRO1_Ins-Pro'!D12","v":220},{"$f":"AVERAGE(Q8:Q14)","v":1046.1471428571431},1265.94,{"$f":"PFP3_FatorKd!$E$17","v":1.2101},{"$f":"ROUND(G15*H15,2)","v":230152.37},278506.8]
["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.2101},0,0,{"$nulls":4},"OBSERVAÇÃO:"]
["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.2101},0,0,{"$nulls":4},"A mão de obra do Sinapi já possui encargos sociais, por isso deve se usar o \"fator K\" sem encargos"]
["CODE","LO","V1",null,"Diárias","dia",{"$f":"'CRO1_Ins-Pro'!D15","v":235},{"$f":"'CPU HOSPEDAGEM'!C19","v":184.44008333333335},223.19,{"$f":"PFP3_FatorKd!$E$17","v":1.2101},{"$f":"ROUND(G18*H18,2)","v":43343.42},{"$f":"ROUND(G18*I18,2)","v":52449.65}]
["PROP","LO","V2",null,"Pick-up Cab.dupla 2.8 4x4 Diesel","dia",{"$f":"'CRO1_Ins-Pro'!D16","v":75},{"$f":"'CPU PICK-UP'!C11","v":325.62682583461901},394.04,{"$f":"PFP3_FatorKd!$E$17","v":1.2101},24422.01,29553]
["PROP","LO","V3",null,"Passagens Aéreas (ida e volta)","un",{"$f":"'CRO1_Ins-Pro'!D17","v":40},{"$f":"'Cotação Voos'!C106","v":1853.8333333333333},2243.3200000000002,{"$f":"PFP3_FatorKd!$E$17","v":1.2101},74153.33,89732.800000000003]
["CODE","EM","M1",null,"Relatório Parcial","un",{"$f":"'CRO1_Ins-Pro'!D18","v":28},{"$f":"'Serv Graficos'!E31","v":51.3},62.08,{"$f":"PFP3_FatorKd!$E$17","v":1.2101},1436.4,1738.24]
["CODE","EM","M2",null,"Relatório Final","un",{"$f":"'CRO1_Ins-Pro'!D19","v":2},{"$f":"'Serv Graficos'!E33","v":1474.85},1784.72,{"$f":"PFP3_FatorKd!$E$17","v":1.2101},2949.7,3569.44]
["CODE","SU","TOP",null,"Total Serviços Cartográficos","un",{"$f":"'CRO1_Ins-Pro'!D20","v":1},"-",{"$f":"'PFP1.1_Topo'!I23","v":740295.08760426228},"-","-",740295.09]
["CODE","SU","GEO",null,"Total Serviços Geotécnicos","un",{"$f":"'CRO1_Ins-Pro'!D21","v":1},"-",{"$f":"'PFP1.2_Geo'!I40","v":928892.04041844537},"-","-",928892.04]
["CODE","SU","AMB",null,"Total Serviços Ambientais","un",1,"-",{"$f":"'PFP1.3_Amb'!I29","v":13588.938988902442},"-","-",13588.94]
["TOTAL DOS CUSTOS DIRETOS",{"$nulls":7},{"$f":"SUM(K8:K25)","v":2566569.38}]
["TOTAL DOS ENCARGOS E DISPESAS DIVERSAS",{"$nulls":7},{"$f":"I28-I26","v":1951962.1500000004}]
["TOTAL DA PROPOSTA A PREÇO GLOBAL",{"$nulls":7},{"$f":"SUM(L8:L22)","v":4518531.53}]
["TOTAL DA PROPOSTA A PREÇO UNITÁRIO",{"$nulls":7},{"$f":"SUM(L23:O25)","v":1682776.0699999998}]
["TOTAL DA PROPOSTA",{"$nulls":7},{"$f":"I28+I29","v":6201307.5999999996}]
["OBSERVAÇÃO:"]
["*Encargos Complementares e adicionais já incluem auxílio transporte"]
["Alocar os Insumos MO, com respectivo FatorK, dentro da categoria de vínculo contratual (celetista, autonomo, societario)"]
["Uni - unidade de medição do insumo;"]
["Qde - Quantidade do Insumo (não pode ocorrer alteração pela Licitante)"]
["CUD - Custo Unitário Direto do Insumo (sem encargos, taxas e impostos, valor não pode ser maior que o Orçado pela Codevasf)"]
["CT - Custo Total (sem encargos, taxas e impostos) - CT = Qde x CUD"]
["FatorK - Taxa de Ressarcimento de Despesas e Encargos (detalhar composição nas Planilhas \"PFP2.1\", \"PFP2.2\", \"PFP3\")"]
["PU - Preço Unitário do Insumo (incluído encargos, taxas e impostos) - PU = CUD x FatorK"]
["PT - Preço Total do Insumo (incluído encargos, taxas e impostos) - PT = Qde x PU"]
["P - Profissionais nível superior nas áreas de Engenharia, Química, Arquitetura, Agronomia e Veterinária, conforme disposições da Lei 4.950-A/66"]
["S - Profissionais de nível superior nas demais áreas de atuação, incluindo Arqueólogo, Biólogo, Geógrafo e Sociólogo"]
["T - Profissionais de nível médio técnico nas diversas áreas de atuação"]
["A - Profissionais de nível médio de apoio técnico-administrativo"]

{"sheet":"PFP1.1_Topo","index":1,"n_rows":29,"n_cols":13,"rows_kept":29,"cut":false,"hidden":false,"merged":[[7,10,7,12],[26,10,27,12],[28,10,28,11],[27,0,27,8],[0,0,1,6],[2,0,2,8],[3,0,3,8],[4,0,4,4],[4,5,4,6],[5,0,5,4],[5,5,5,6],[22,0,22,6],[23,0,23,8],[24,0,24,8],[25,0,25,8],[26,0,26,8]]}
["SERVIÇOS TOPOGRÁFICOS/CARTOGRÁFICOS",{"$nulls":7},"CODIGO:"]
[{"$nulls":8},"PFP-1.1"]
["NOME DA EMPRESA:"]
[]
["PROJETO:",{"$nulls":4},"CONTRATANTE:",null,null,{"$f":"PFP!K5","v":"BASE:"}]
[{"$f":"PFP!A6","v":"Elaboração de Projeto Executivo da Adutora Agreste Potiguar, no Estado do Rio Grande do Norte "},{"$nulls":4},"CODEVASF (SEDE)",null,null,{"$f":"PFP!K6","v":"2024-09-01"}]
["Cod.","Base","Código","Insumos","Uni","Qde","Custo Unitário (CU)","Custo Total","Preço Total (PT)"]
["TP01","CODE","-","Nivelamento Geométrico dos Eixos classe IIN","km",50,843.75,{"$f":"ROUND(G8*F8,2)","v":42187.5},{"$f":"(H8*$M$29)+H8","v":48385.692644817085},null,"MEMÓRIA DE CALCULO DO BDI DE FORNECIMENTO"]
["TP02","ORSE/COMPOSIÇÃO",9164,"Seções Tranversais","km",100,{"$f":"4.67*1000","v":4670},{"$f":"ROUND(G9*F9,2)","v":467000},{"$f":"(H9*$M$29)+H9","v":535611.69695121958},null,"ITEM","DISCRIMINAÇÃO","PERC.    (%)"]
["TP03","EMOP/COMPOSIÇÃO","01.016.0035-0","Poligonal Classe IIP","km",50,1366.27,68313.5,78350.127750914646]
["TP04","CPOS/CDHU/COMPOSIÇÃO","01.20.921","Pontos GPS de dupla frequencia (L1/L2)","un ",30,1257.0899999999999,37712.699999999997,43253.454483109759]
["TP05","CODE","-","Levantamento Ecobatimetrico (MALHA 2X2)","ha ",5,2112.19,10560.95,12112.566061920736,null,"1.00","Despesas Indiretas"]
["TP06","CODE","-","Levantamento Topobatimétrico","km",5,1464.56,7322.8,8398.6666690243928,null,"A1","Seguro e Garantia",8.0000000000000002E-3]
["TP07","CODE","-","Cadastro Físico","ha ",10,14.752784482758621,147.53,169.20512559146346,null,"A2","Riscos e Imprevistos",1.15E-2]
["TP08","CODE","-","Cadastro Agrícola","ha ",10,4.917594827586206,49.18,56.405531597560987,null,"A3","Despesas Financeiras",1.0500000000000001E-2]
["TP09","CODE","-","Cadastro Jurídico","ha ",10,9.8351896551724121,98.35,112.79959399390245,null,"A4","Administração Central",2.1999999999999999E-2]
["TP10","CODE","-","Cadastro Socioeconomico","ha ",10,3.2783965517241378,32.78,37.596041597560983,null,"Total do Grupo A =",null,{"$f":"SUM(M13:M16)","v":5.1999999999999998E-2}]
["TP11","ORSE/INSUMO",4369,"Marco de Concreto (12x18x60cm)","un ",15,73,1095,1255.8775335365856,null,"2.00","Benefício"]
["TP12","EMBASA/INSUMO","D059722497","Estaca Testemunha de Madeira (2x4x70cm)","un",150,0.55000000000000004,82.5,94.620910060975632,null,"B1","LUCRO",0.05]
["TP13","SEINFRA/INSUMO","I1652","Piquetes de Madeira (2x2x20cm)","un",1500,2.08,3120,3578.3907804878054,null,"Total do Grupo B =",null,{"$f":"M19","v":0.05}]
["TP14","CODE","-","Picada Manual p/ levantamento TP","km",12,252.22,3026.64,3471.3143179024396,null,"3.00","Impostos"]
["TP15","CODE","-","Picada c/ Trator de Esteira","km",4,1178.52,4714.08,5406.6732084878058,null,"C1","PIS / PASEP",6.4999999999999997E-3]
["TOTAL SERVIÇOS TOPOGRÁFICOS",{"$nulls":7},{"$f":"SUM(I8:I22)","v":740295.08760426228},null,"C2","COFINS",0.03]
["OBSERVAÇÃO:",{"$nulls":9},"C3","ISS",0]
["Uni - unidade de medição do insumo;",{"$nulls":9},"Total do Grupo C =",null,{"$f":"SUM(M22:M24)","v":3.6499999999999998E-2}]
["Qde - Quantidade do Insumo (não pode ocorrer alteração pela Licitante)",{"$nulls":9},"Fórmula Para Cálculo do B.D.I"]
["PU - Preço Unitário (composições padrão da Codevasf, já incluso o FatorK)",{"$nulls":9},"BDI =(((1+A4+A1+A2)*(1+A3)*(1+B))/(1-C))-1"]
["PT - Preço Total (incluído encargos, taxas e impostos) - PT = Qde x PU"]
[{"$nulls":10},"Bonificação Sobre Despesas indiretas (B.D.I) =",null,{"$f":"(((1+M16+M13+M14)*(1+M15)*(1+M20))/(1-M25))-1","v":0.14692012195121973}]

{"sheet":"PFP1.2_Geo","index":2,"n_rows":45,"n_cols":14,"rows_kept":45,"cut":false,"hidden":false,"merged":[[5,0,5,4],[5,5,5,6],[7,3,7,8],[0,0,1,6],[2,0,2,8],[3,0,3,8],[4,0,4,4],[4,5,4,6],[6,11,6,13],[25,11,26,13],[27,11,27,12],[43,0,43,8],[44,0,44,8],[39,0,39,6],[40,0,40,8],[41,0,41,8],[42,0,42,8]]}
["SERVIÇOS GEOLÓGICOS/GEOTÉCNICOS",{"$nulls":7},"CODIGO:"]
[{"$nulls":8},"PFP-1.2"]
["NOME DA EMPRESA:"]
[]
["PROJETO: ",{"$nulls":4},"CONTRATANTE:",null,null,{"$f":"PFP!K5","v":"BASE:"}]
[{"$f":"PFP!A6","v":"Elaboração de Projeto Executivo da Adutora Agreste Potiguar, no Estado do Rio Grande do Norte "},{"$nulls":4},"CODEVASF (SEDE)",null,null,{"$f":"PFP!K6","v":"2024-09-01"}]
["Cod.","Código","Referência","Insumos","Uni","Qde","Custo Unitário (CU)","Custo Total","Preço Total (PT)",null,null,"MEMÓRIA DE CALCULO DO BDI DE FORNECIMENTO"]
["GT 1",null,null,"Sondagem mista",{"$nulls":7},"ITEM","DISCRIMINAÇÃO","PERC.    (%)"]
["GT1.2","E200320516","EMBASA/INSUMO","Sondagem Mista: (Des)Mobilização por equipe","un",6,3157.33,{"$f":"ROUND(G9*F9,2)","v":18943.98},{"$f":"(H9*$N$28)+H9","v":21727.231851841469}]
["GT1.3","C0333","SEINFRA/COMPOSIÇÃO","Sondagem Mista: em rochas","m",150,1251.98,{"$f":"ROUND(G10*F10,2)","v":187797},{"$f":"(H10*$N$28)+H10","v":215388.1581420732}]
["GT1.4","C0143","SEINFRA/COMPOSIÇÃO","Sondagem Mista: em solo (SPT)","m",60,299.97000000000003,17998.2,20642.497738902443,null,null,"1.00","Despesas Indiretas"]
["GT1.4.1","E200320513","EMBASA/INSUMO","Sondagem Mista: Desloc/Instalação 0-200 m","un",16,861.69,13787.04,15812.633598146345,null,null,"A1","Seguro e Garantia",8.0000000000000002E-3]
["GT1.4.2","E200320516","EMBASA/INSUMO","Sondagem Mista: Desloc/Instalação 201-500 m","un",12,3157.33,37887.96,43454.463703682937,null,null,"A2","Riscos e Imprevistos",1.15E-2]
["GT1.4.3","E200320517","EMBASA/INSUMO","Sondagem Mista: Desloc/Instalação acima 500 m","un",12,3749.32,44991.839999999997,51602.046619609762,null,null,"A3","Despesas Financeiras",1.0500000000000001E-2]
["GT 2",null,null,"Sondagem a Percussão SPT",{"$nulls":7},"A4","Administração Central",2.1999999999999999E-2]
["GT2.1","A.07.000.020476","CPOS/INSUMO","Sondagem Percussão: (Des)Mobilização por equipe","un",6,1261.18,{"$f":"ROUND(G16*F16,2)","v":7567.08},8678.8363164146358,null,null,"Total do Grupo A =",null,{"$f":"SUM(N12:N15)","v":5.1999999999999998E-2}]
["GT2.2","CO-28388","SETOP/COMPOSIÇÃO","Sondagem PercursSão: com SPT - Terrestre","m",1040,72.5,{"$f":"ROUND(G17*F17,2)","v":75400},86477.777195121962,null,null,"2.00","Benefício"]
["GT2.2.2.1",20002004,"SIURB/COMPOSIÇÃO","Sondagem Percurssão: Desloc/Instalação 0-200 m","un",140,189.46,26524.400000000001,30421.368082682933,null,null,"B1","LUCRO",0.05]
["GT2.2.2.2",20002005,"SIURB/COMPOSIÇÃO","Sondagem Percurssão: Desloc/Instalação 201-500 m","un",100,284.19,28419,32594.322945731714,null,null,"Total do Grupo B =",null,{"$f":"N18","v":0.05}]
["GT2.2.2.3","AD 15.05.0050","SCO/COMPOSIÇÃO","Sondagem Percurssão: Desloc/Instalação acima 500 m","un",20,365.86,7317.2,8392.2439163414638,null,null,"3.00","Impostos"]
["GT3","CODE","CODE","Poços de Inspeção com retroescavadeira","m",200,190.01,{"$f":"ROUND(G21*F21,2)","v":38002},43585.258474390255,null,null,"C1","PIS / PASEP",6.4999999999999997E-3]
["GT4","32.01.01","EMBASA/COMPOSIÇÃO","Sondagem a Trado","m",600,97.5,58500,67094.827134146355,null,null,"C2","COFINS",0.03]
["GT5",null,null,"Ensaios: ",{"$nulls":7},"C3","ISS",0]
["GT5.1","65.08.23","SUDECAP/COMPOSIÇÃO","Ensaio: Retirada de Amostra Indeformada","un",20,1000,20000,22938.402439024394,null,null,"Total do Grupo C =",null,{"$f":"SUM(N21:N23)","v":3.6499999999999998E-2}]
["GT6.1",null,null,"Ensaios de solo",{"$nulls":7},"Fórmula Para Cálculo do B.D.I"]
["GT6.1.1","ED-49553","SETOP/COMPOSIÇÃO","Ensaio: Limite de Liquidez","un",240,79.81,19154.400000000001,21968.566783902446,null,null,"BDI =(((1+A4+A1+A2)*(1+A3)*(1+B))/(1-C))-1"]
["GT6.1.2","ED-49554","SETOP/COMPOSIÇÃO","Ensaio: Limite de Plasticidade","un",240,79.819999999999993,19156.8,21971.319392195124]
["GT6.1.3","ED-49552","SETOP/COMPOSIÇÃO","Ensaio: Granulometria por Peneiramento","un",240,150.69,36165.599999999999,41479.054362439027,null,null,"Bonificação Sobre Despesas indiretas (B.D.I) =",null,{"$f":"(((1+N15+N12+N13)*(1+N14)*(1+N19))/(1-N24))-1","v":0.14692012195121973}]
["GT6.1.4","01.07.07U","COMPESA/COMPOSIÇÃO","Ensaio: Granulometria por Sedimentação","un",240,130.94,31425.599999999999,36042.652984390246]
["GT6.1.5",4685,"ORSE/COMPOSIÇÃO","Ensaio: Compactação Proctor Normal","un",240,220,52800,60557.382439024404]
["GT6.1.6","34.01.16","EMBASA/COMPOSIÇÃO","Ensaio: Massa Especifica Real dos Grãos","un",240,65.78,15787.2,18106.657349268298]
["GT6.1.7","67.01.18","SUDECAP/COMPOSIÇÃO","Ensaio: Adensamento Oedométrico","un",40,440,17600,20185.794146341468]
["GT6.1.8","97.01.13","SUDECAP/INSUMO","Ensaio: Índice de Suporte Califórnia (CBR)","un",30,120,3600,4128.9124390243906]
["GT6.1.9","CODE","CODE","Ensaio: Triaxial (UU) não consolidado não derenado","un",12,670.8,8049.6,9232.2482136585386]
["GT6.2",null,null,"Análise da Areia "]
["GT6.2.1","CODE","CODE","Ensaio: Mineralogia da Areia","un",15,425.77,6386.55,7324.8627048475628]
["GT6.2.2","66.01.28","SUDECAP/COMPOSIÇÃO","Ensaio: Equivalente de Areia","un",15,120,1800,2064.4562195121953]
["GT6.2.3","34.05.30","EMBASA/COMPOSIÇÃO","Ensaio: Teor de Matéria Orgânica","un",15,250,3750,4300.9504573170743]
["GT6.2.4","CODE","CODE","Ensaio: Reatividade Potencial","un",10,1108.98,11089.8,12719.114768414636]
["TOTAL SERVIÇOS GEOTÉCNICOS",{"$nulls":7},{"$f":"SUM(I9:I39)","v":928892.04041844537}]
["LEGENDA:"]
["Uni - unidade de medição do insumo;"]
["Qde - Quantidade do Insumo (não pode ocorrer alteração pela Licitante)"]
["PU - Preço Unitário (composições padrão da Codevasf, já incluso o FatorK)"]
["PT - Preço Total (incluído encargos, taxas e impostos) - PT = Qde x PU"]

{"sheet":"PFP1.3_Amb","index":3,"n_rows":35,"n_cols":14,"rows_kept":35,"cut":false,"hidden":false,"merged":[[6,11,6,13],[25,11,26,13],[27,11,27,12],[34,0,34,8],[0,0,1,6],[2,0,2,8],[3,0,3,8],[4,0,4,4],[4,5,4,6],[5,0,5,4],[5,5,5,6],[28,0,28,6],[29,0,29,8],[31,0,31,8],[32,0,32,8],[33,0,33,8],[30,0,30,8]]}
["SERVIÇOS ANÁLISE AMBIENTAL",{"$nulls":7},"CODIGO:"]
[{"$nulls":8},"PFP-1.3"]
["NOME DA EMPRESA:"]
[]
["PROJETO:",{"$nulls":4},"CONTRATANTE:",null,null,"BASE"]
[{"$f":"PFP!A6","v":"Elaboração de Projeto Executivo da Adutora Agreste Potiguar, no Estado do Rio Grande do Norte "},{"$nulls":4},"CODEVASF (SEDE)",null,null,{"$f":"PFP!K6","v":"2024-09-01"}]
["Cod.","CÓDIGO","Base","Insumos","Uni","Qde","Custo Unitário (CU)","Custo Total","Preço Total (PT)",null,null,"MEMÓRIA DE CALCULO DO BDI DE FORNECIMENTO"]
["AM01","33.01.02","EMBASA/COMPOSIÇÃO","Alcalinidade Total","un",10,30,{"$f":"ROUND(G8*F8,2)","v":300},{"$f":"(H8*$N$28)+H8","v":344.0760365853659},null,null,"ITEM","DISCRIMINAÇÃO","PERC.    (%)"]
["AM02","33.01.10","EMBASA/COMPOSIÇÃO","Condutividade","un",10,18,{"$f":"ROUND(G9*F9,2)","v":180},{"$f":"(H9*$N$28)+H9","v":206.44562195121955}]
["AM03","33.01.13","EMBASA/COMPOSIÇÃO","DBO","un",10,62,620,711.09047560975625]
["AM04","33.01.13","EMBASA/COMPOSIÇÃO","DQO","un",10,62,620,711.09047560975625,null,null,"1.00","Despesas Indiretas"]
["AM05","\tF099703031","EMBASA/INSUMO","Salinidade","un",10,17.5,175,200.71102134146346,null,null,"A1","Seguro e Garantia",8.0000000000000002E-3]
["AM06","F099703048","EMBASA/INSUMO","Sólidos Dissolvidos Totais","un",10,25,250,286.73003048780492,null,null,"A2","Riscos e Imprevistos",1.15E-2]
["AM07","33.02.71","EMBASA/COMPOSIÇÃO","Sólidos Suspensos","un",10,24.18,241.8,277.32528548780493,null,null,"A3","Despesas Financeiras",1.0500000000000001E-2]
["AM08","33.01.48","EMBASA/COMPOSIÇÃO","Sólidos Totais","un",10,22,220,252.32242682926835,null,null,"A4","Administração Central",2.1999999999999999E-2]
["AM09","33.01.51","EMBASA/COMPOSIÇÃO","Turbidez","un",10,20,200,229.38402439024395,null,null,"Total do Grupo A =",null,{"$f":"SUM(N12:N15)","v":5.1999999999999998E-2}]
["AM10","33.01.38","EMBASA/COMPOSIÇÃO","Oxigênio Dissolvido","un",10,23,230,263.79162804878052,null,null,"2.00","Benefício"]
["AM11","E200330139","EMBASA/INSUMO","pH","un",10,17,170,194.97642073170735,null,null,"B1","LUCRO",0.05]
["AM12","F099703027","EMBASA/INSUMO","Temperatura","un",10,11.16,111.6,127.99628560975611,null,null,"Total do Grupo B =",null,{"$f":"N18","v":0.05}]
["AM13","F099703046","EMBASA/INSUMO","Fósforo Total","un",10,92.5,925,1060.9011128048783,null,null,"3.00","Impostos"]
["AM14","E200330130","EMBASA/INSUMO","Nitrogênio Amoniacal","un",10,32,320,367.0144390243903,null,null,"C1","PIS / PASEP",6.4999999999999997E-3]
["AM15","E200330133","EMBASA/INSUMO","Nitrogênio Nitrato","un",10,34,340,389.9528414634147,null,null,"C2","COFINS",0.03]
["AM16","E200330132","EMBASA/INSUMO","Nitrogênio Total","un",10,32,320,367.0144390243903,null,null,"C3","ISS",0]
["AM17","F099703058","EMBASA/INSUMO","Clorofila A","un",10,30,300,344.0760365853659,null,null,"Total do Grupo C =",null,{"$f":"SUM(N21:N23)","v":3.6499999999999998E-2}]
["AM18","F099703057","EMBASA/INSUMO","Coliformes Termotolerantes","un",10,25,250,286.73003048780492,null,null,"Fórmula Para Cálculo do B.D.I"]
["AM19","*","EMBASA/INSUMO","Metais Pesados","un",10,186.5,1865,2139.0060274390248,null,null,"BDI =(((1+A4+A1+A2)*(1+A3)*(1+B))/(1-C))-1"]
["AM20","E200330140","EMBASA/INSUMO","Organoclorados","un",10,210.49,2104.9,2414.1521646951223]
["AM21","E200330140","EMBASA/INSUMO","Organofosforado","un",10,210.49,2104.9,2414.1521646951223,null,null,"Bonificação Sobre Despesas indiretas (B.D.I) =",null,{"$f":"(((1+N15+N12+N13)*(1+N14)*(1+N19))/(1-N24))-1","v":0.14692012195121973}]
["TOTAL SERVIÇOS AMBIENTAIS",{"$nulls":7},{"$f":"SUM(I8:I28)","v":13588.938988902442}]
["LEGENDA:"]
["* Somatório dos códigos de análises de diversos metais pesados da tabela EMBASA."]
["Uni - unidade de medição do insumo;"]
["Qde - Quantidade do Insumo (não pode ocorrer alteração pela Licitante)"]
["PU - Preço Unitário (composições padrão da Codevasf, já incluso o FatorK)"]
["PT - Preço Total (incluído encargos, taxas e impostos) - PT = Qde x PU"]

{"sheet":"PFP2.1_FatorKa","index":4,"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!K5","v":"BASE:"}]
[{"$f":"PFP!A6","v":"Elaboração de Projeto Executivo da Adutora Agreste Potiguar, no Estado do Rio Grande do Norte "},null,"CODEVASF (SEDE)",null,null,"SINAPI/RN"]
["Cod","DESCRIÇÃO",null,null,"%","R$"]
["A","ENCARGOS SOCIAIS BÁSICOS",null,null,{"$f":"ROUND(SUM(E9:E17),4)","v":0.36799999999999999},{"$f":"ROUND(E8*SUMIF(PFP!$B$8:$B$24,\"MO1\",PFP!$K$8:$K$24),2)","v":529979.46}]
["A1","INSS",null,null,0.2,{"$f":"ROUND(E9*SUMIF(PFP!$B$8:$B$24,\"MO1\",PFP!$K$8:$K$24),2)","v":288032.31}]
["A2","SESI",null,null,1.4999999999999999E-2,{"$f":"ROUND(E10*SUMIF(PFP!$B$8:$B$24,\"MO1\",PFP!$K$8:$K$24),2)","v":21602.42}]
["A3","SENAI",null,null,0.01,{"$f":"ROUND(E11*SUMIF(PFP!$B$8:$B$24,\"MO1\",PFP!$K$8:$K$24),2)","v":14401.62}]
["A4","INCRA",null,null,2E-3,{"$f":"ROUND(E12*SUMIF(PFP!$B$8:$B$24,\"MO1\",PFP!$K$8:$K$24),2)","v":2880.32}]
["A5","SEBRAE",null,null,6.0000000000000001E-3,{"$f":"ROUND(E13*SUMIF(PFP!$B$8:$B$24,\"MO1\",PFP!$K$8:$K$24),2)","v":8640.9699999999993}]
["A6","Salário Educação",null,null,2.5000000000000001E-2,{"$f":"ROUND(E14*SUMIF(PFP!$B$8:$B$24,\"MO1\",PFP!$K$8:$K$24),2)","v":36004.04}]
["A7","Seguro Contra Acidentes de Trabalho",null,null,0.03,{"$f":"ROUND(E15*SUMIF(PFP!$B$8:$B$24,\"MO1\",PFP!$K$8:$K$24),2)","v":43204.85}]
["A8","FGTS",null,null,0.08,{"$f":"ROUND(E16*SUMIF(PFP!$B$8:$B$24,\"MO1\",PFP!$K$8:$K$24),2)","v":115212.93}]
["A9","SECONCI",null,null,0,{"$f":"ROUND(E17*SUMIF(PFP!$B$8:$B$24,\"MO1\",PFP!$K$8:$K$24),2)","v":0}]
["B"," ENCARGOS SOCIAIS QUE RECEBEM INCIDÊNCIA DE \"A\"",null,null,{"$f":"ROUND(SUM(E19:E25),4)","v":0.20119999999999999},{"$f":"ROUND(E18*SUMIF(PFP!$B$8:$B$24,\"MO1\",PFP!$K$8:$K$24),2)","v":289760.51}]
["B3","Auxílio Enfermidade",null,null,6.4000000000000003E-3,{"$f":"ROUND(E19*SUMIF(PFP!$B$8:$B$24,\"MO1\",PFP!$K$8:$K$24),2)","v":9217.0300000000007}]
["B4","13º Salário",null,null,8.3299999999999999E-2,{"$f":"ROUND(E20*SUMIF(PFP!$B$8:$B$24,\"MO1\",PFP!$K$8:$K$24),2)","v":119965.46}]
["B5","Licença Paternidade",null,null,4.0000000000000002E-4,{"$f":"ROUND(E21*SUMIF(PFP!$B$8:$B$24,\"MO1\",PFP!$K$8:$K$24),2)","v":576.05999999999995}]
["B6","Faltas Justificadas",null,null,5.5999999999999999E-3,{"$f":"ROUND(E22*SUMIF(PFP!$B$8:$B$24,\"MO1\",PFP!$K$8:$K$24),2)","v":8064.9}]
["B8","Auxílio Acidente de Trabalho",null,null,8.0000000000000004E-4,{"$f":"ROUND(E23*SUMIF(PFP!$B$8:$B$24,\"MO1\",PFP!$K$8:$K$24),2)","v":1152.1300000000001}]
["B9","Férias Gozadas",null,null,0.10440000000000001,{"$f":"ROUND(E24*SUMIF(PFP!$B$8:$B$24,\"MO1\",PFP!$K$8:$K$24),2)","v":150352.87}]
["B10","Salário Maternidade",null,null,2.9999999999999997E-4,{"$f":"ROUND(E25*SUMIF(PFP!$B$8:$B$24,\"MO1\",PFP!$K$8:$K$24),2)","v":432.05}]
["C"," ENCARGOS SOCIAIS QUE NÃO RECEBEM INCIDÊNCIA DE \"A\"",null,null,{"$f":"ROUND(SUM(E27:E31),4)","v":6.8099999999999994E-2},{"$f":"ROUND(E26*SUMIF(PFP!$B$8:$B$24,\"MO1\",PFP!$K$8:$K$24),2)","v":98075}]
["C1","Aviso Prévio Indenizado",null,null,3.9100000000000003E-2,{"$f":"ROUND(E27*SUMIF(PFP!$B$8:$B$24,\"MO1\",PFP!$K$8:$K$24),2)","v":56310.32}]
["C2","Aviso Prévio Trabalhado",null,null,8.9999999999999998E-4,{"$f":"ROUND(E28*SUMIF(PFP!$B$8:$B$24,\"MO1\",PFP!$K$8:$K$24),2)","v":1296.1500000000001}]
["C3","Férias Indenizadas",null,null,6.6E-3,{"$f":"ROUND(E29*SUMIF(PFP!$B$8:$B$24,\"MO1\",PFP!$K$8:$K$24),2)","v":9505.07}]
["C4","Depósito Rescisão Sem Justa Causa",null,null,1.8200000000000001E-2,{"$f":"ROUND(E30*SUMIF(PFP!$B$8:$B$24,\"MO1\",PFP!$K$8:$K$24),2)","v":26210.94}]
["C5","Indenização Adicional",null,null,3.3E-3,{"$f":"ROUND(E31*SUMIF(PFP!$B$8:$B$24,\"MO1\",PFP!$K$8:$K$24),2)","v":4752.53}]
["D"," REINCIDÊNCIAS",null,null,{"$f":"ROUND(SUM(E33:E34),4)","v":7.7499999999999999E-2},{"$f":"ROUND(E32*SUMIF(PFP!$B$8:$B$24,\"MO1\",PFP!$K$8:$K$24),2)","v":111612.52}]
["D1","Reincidência de \"A\" sobre \"B\"",null,null,7.3999999999999996E-2,{"$f":"ROUND(E33*SUMIF(PFP!$B$8:$B$24,\"MO1\",PFP!$K$8:$K$24),2)","v":106571.96}]
["D2","Reincidência de \"A\" sobre Aviso Prévio Trabalhado e reincidência do FGTS sobre Aviso Prévio Indenizado",null,null,3.5000000000000001E-3,{"$f":"ROUND(E34*SUMIF(PFP!$B$8:$B$24,\"MO1\",PFP!$K$8:$K$24),2)","v":5040.57}]
["K1a","ENCARGOS SOCIAIS",null,null,{"$f":"ROUND(E8+E18+E26+E32,4)","v":0.71479999999999999},{"$f":"ROUND(E35*SUMIF(PFP!$B$8:$B$24,\"MO1\",PFP!$K$8:$K$24),2)","v":1029427.49}]
["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.1598000000000002}]
["OBSERVAÇÃO: CELETISTAS E EQUIVALENTES"]
["1 - DISCRIMINAR OS ENCARGOS SOCIAIS COM SEUS RESPECTIVOS PERCENTUAS TOTALIZANDO OS MESMOS. "]
["2 - APLICAR O  % TOTAL P/ CALCULAR OS E. SOCIAIS INCIDENTES NA MÃO-DE-OBRA CELETISTAS"]
["Ka - Taxa de Ressarcimento de Despesas e Encargos sobre a Mão de Obra CELETISTA (incide apenas no Insumo Codigo MO1)"]
["Ka = (1 + K1 + K2) x (1 + K3) x (1 + K4)"]

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

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

{"sheet":"PFP3_FatorKd","index":7,"n_rows":35,"n_cols":6,"rows_kept":35,"cut":false,"hidden":false,"merged":[[32,0,32,5],[12,1,12,3],[11,1,11,3],[8,1,8,2],[9,1,9,2],[10,1,10,2],[7,1,7,2],[25,0,25,5],[6,1,6,2],[0,0,1,4],[2,0,2,5],[5,0,5,1],[5,2,5,4],[4,2,4,4],[3,0,3,5],[33,0,33,5],[34,0,34,5],[16,1,16,3],[13,1,13,3],[14,1,14,3],[15,1,15,3],[21,0,21,5],[26,0,26,5],[27,0,27,5],[22,0,22,5],[23,0,23,5],[24,0,24,5],[28,0,28,5],[29,0,29,5],[30,0,30,5],[31,0,31,5]]}
["DESPESAS FISCAIS E CUSTOS DIVERSOS: Kc",{"$nulls":4},"CODIGO:"]
[{"$nulls":5},"PFP-3"]
["NOME DA CONSULTORA:"]
[]
["PROJETO:",null,"CONTRATANTE:",null,null,{"$f":"'PFP2.3_FatorKc'!F5","v":"BASE:"}]
[{"$f":"PFP!A6","v":"Elaboração de Projeto Executivo da Adutora Agreste Potiguar, no Estado do Rio Grande do Norte "},null,"CODEVASF (SEDE)",null,null,{"$f":"'PFP2.3_FatorKc'!F6","v":"SINAPI/RN"}]
["Cod","DESCRIÇÃO1",null,"% preço2","% custo4","R$"]
["K4","TRIBUTOS",null,{"$f":"ROUND(D9+D10+D11,4)","v":0.124},{"$f":"ROUND(E9+E10+E11,4)","v":0.1416},{"$f":"E8*SUM(SUMIF(PFP!$B$8:$B$24,\"MO1\",PFP!$K$8:$K$24)*(1+'PFP2.1_FatorKa'!$E$35)+SUMIF(PFP!$B$8:$B$24,\"MO2\",PFP!$K$8:$K$24)*(1+'PFP2.2_FatorKb'!$E$34)+SUMIF(PFP!$B$8:$B$24,\"<>MO*\",PFP!$K$8:$K$24)+$F$13+$F$12)","v":559524.05819817458}]
["K4.1","ISS",null,0.05,{"$f":"ROUND((1/(1-$D$8))*D9,4)","v":5.7099999999999998E-2},{"$f":"E9*SUM(SUMIF(PFP!$B$8:$B$24,\"MO1\",PFP!$K$8:$K$24)*(1+'PFP2.1_FatorKa'!$E$35)+SUMIF(PFP!$B$8:$B$24,\"MO2\",PFP!$K$8:$K$24)*(1+'PFP2.2_FatorKb'!$E$34)+SUMIF(PFP!$B$8:$B$24,\"<>MO*\",PFP!$K$8:$K$24)+$F$13+$F$12)","v":225627.2861801961}]
["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.5100000000000001E-2},{"$f":"E10*SUM(SUMIF(PFP!$B$8:$B$24,\"MO1\",PFP!$K$8:$K$24)*(1+'PFP2.1_FatorKa'!$E$35)+SUMIF(PFP!$B$8:$B$24,\"MO2\",PFP!$K$8:$K$24)*(1+'PFP2.2_FatorKb'!$E$34)+SUMIF(PFP!$B$8:$B$24,\"<>MO*\",PFP!$K$8:$K$24)+$F$13+$F$12)","v":59666.760443449413}]
["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.9400000000000003E-2},{"$f":"E11*SUM(SUMIF(PFP!$B$8:$B$24,\"MO1\",PFP!$K$8:$K$24)*(1+'PFP2.1_FatorKa'!$E$35)+SUMIF(PFP!$B$8:$B$24,\"MO2\",PFP!$K$8:$K$24)*(1+'PFP2.2_FatorKb'!$E$34)+SUMIF(PFP!$B$8:$B$24,\"<>MO*\",PFP!$K$8:$K$24)+$F$13+$F$12)","v":274230.01157452911}]
["K3","REMUNERAÇÃO DA EMPRESA (LUCRO)",null,null,0.06,{"$f":"E12*SUM(SUMIF(PFP!$B$8:$B$24,\"MO1\",PFP!$K$8:$K$24)*(1+'PFP2.1_FatorKa'!$E$35)+SUMIF(PFP!$B$8:$B$24,\"MO2\",PFP!$K$8:$K$24)*(1+'PFP2.2_FatorKb'!$E$34)+SUMIF(PFP!$B$8:$B$24,\"<>MO*\",PFP!$K$8:$K$24)+$F$13)","v":223666.47673415998}]
["K2","CUSTOS DA ADMINISTRAÇÃO CENTRAL",null,null,{"$f":"ROUND(SUM(E14:E16),4)","v":7.0000000000000007E-2},{"$f":"ROUND(E13*SUMIF(PFP!$B$8:$B$24,\"MO*\",PFP!$K$8:$K$24),2)","v":153307.85}]
["K2.1","Custos da administração central da empresa (diretoria, pessoal técnico de apoio e pessoal administrativo não diretamente vinculado à prestação dos serviços)",null,null,0.04,{"$f":"ROUND(E14*SUMIF(PFP!$B$8:$B$24,\"MO*\",PFP!$K$8:$K$24),2)","v":87604.49}]
["K2.2","Outras despesas que afetam o custo de produção como treinamento, biblioteca, programa de qualidade, programa de benefícios, auditoria interna e externa",null,null,0.02,{"$f":"ROUND(E15*SUMIF(PFP!$B$8:$B$24,\"MO*\",PFP!$K$8:$K$24),2)","v":43802.239999999998}]
["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!$B$8:$B$24,\"MO*\",PFP!$K$8:$K$24),2)","v":21901.119999999999}]
["Kd","TAXA RESSARCIMENTO DE DESPESAS SOBRE CUSTOS DIVERSOS",null,null,{"$f":"ROUND((1+E12)*(1+E8),4)","v":1.2101}]
["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,124 ) ] - 1 } x 100"}]
["Kc - Taxa de Ressarcimento de Despesas sobre Custos Diversos (incide sobre os Insumos Codigo DP e EM)"]
["Kc = (1 + K3) x (1 + K4)"]
["K2 - Incide sobre o Custo Total (CT) da Mão de Obra (MO* = MO1 + MO2)"]
["K3 - Incide sobre o Custo Total (CT) Mão de Obra com encargos (MO1 x Ka ou MO2 x Kb), demais Custos (DP e EM), e Custos da Administração Central (K2)"]
["K4 -  Incide sobre o Custo Total (CT) Mão de Obra com encargos (MO1 x Ka ou MO2 x Kb), demais Custos (DP e EM), e Custos da Administração Central (K2) e Lucro (K3)"]

{"sheet":"CRO1_Ins-Pro","index":8,"n_rows":90,"n_cols":17,"rows_kept":90,"cut":false,"hidden":false,"merged":[[2,5,3,5],[0,0,1,15],[2,0,3,0],[2,1,3,1],[2,2,3,2],[2,3,3,3],[2,4,3,4],[88,0,88,8],[87,0,87,11],[39,8,39,11],[22,0,23,0],[22,1,23,1]]}
["INSUMOS POR ETAPA/PRODUTO",{"$nulls":15},"CÓDIGO:"]
[{"$nulls":16},"CRO-1"]
["Cod.","Categoria / Insumo","Uni","Qde","CUD","PU","FatorK","E1.AC","E2. EB","E3. PE T1","E3 PE T2","E3. PE T3","E3. PE T4","E3. PE T5","E3. PE T6","E3. PE T7","E3. PE T8"]
[{"$nulls":6},"Meses",{"$f":"'CRO2_Ins-Mes'!E5","v":1},{"$f":"'CRO2_Ins-Mes'!E8","v":2},{"$f":"'CRO2_Ins-Mes'!$E15/8","v":0.875},{"$f":"'CRO2_Ins-Mes'!$E15/8","v":0.875},{"$f":"'CRO2_Ins-Mes'!$E15/8","v":0.875},{"$f":"'CRO2_Ins-Mes'!$E15/8","v":0.875},{"$f":"'CRO2_Ins-Mes'!$E15/8","v":0.875},{"$f":"'CRO2_Ins-Mes'!$E15/8","v":0.875},{"$f":"'CRO2_Ins-Mes'!$E15/8","v":0.875},{"$f":"'CRO2_Ins-Mes'!$E15/8","v":0.875}]
[{"$f":"PFP!C8","v":"P0"},{"$f":"PFP!E8","v":"Engenheiro coordenador (P8061)"},"mês",{"$f":"SUM(H5:Q5)","v":8},{"$f":"PFP!H8","v":17866.689999999999},{"$f":"PFP!I8","v":23133.79},{"$f":"PFP!J8","v":1.2948},{"$f":"'CRO2_Ins-Mes'!E18","v":1},{"$f":"'CRO2_Ins-Mes'!E30","v":0},{"$f":"'CRO2_Ins-Mes'!$E44/8","v":0.875},{"$f":"'CRO2_Ins-Mes'!$E44/8","v":0.875},{"$f":"'CRO2_Ins-Mes'!$E44/8","v":0.875},{"$f":"'CRO2_Ins-Mes'!$E44/8","v":0.875},{"$f":"'CRO2_Ins-Mes'!$E44/8","v":0.875},{"$f":"'CRO2_Ins-Mes'!$E44/8","v":0.875},{"$f":"'CRO2_Ins-Mes'!$E44/8","v":0.875},{"$f":"'CRO2_Ins-Mes'!$E44/8","v":0.875}]
[{"$f":"PFP!C9","v":"P1"},{"$f":"PFP!E9","v":"Engenheiro sênior (P8067)"},"mês",{"$f":"SUM(H6:Q6)","v":39},{"$f":"PFP!H9","v":15564.54},{"$f":"PFP!I9","v":23919.59},{"$f":"PFP!J9","v":1.5367999999999999},{"$f":"'CRO2_Ins-Mes'!E19","v":4},{"$f":"'CRO2_Ins-Mes'!E31","v":0},{"$f":"'CRO2_Ins-Mes'!$E45/8","v":4.375},{"$f":"'CRO2_Ins-Mes'!$E45/8","v":4.375},{"$f":"'CRO2_Ins-Mes'!$E45/8","v":4.375},{"$f":"'CRO2_Ins-Mes'!$E45/8","v":4.375},{"$f":"'CRO2_Ins-Mes'!$E45/8","v":4.375},{"$f":"'CRO2_Ins-Mes'!$E45/8","v":4.375},{"$f":"'CRO2_Ins-Mes'!$E45/8","v":4.375},{"$f":"'CRO2_Ins-Mes'!$E45/8","v":4.375}]
[{"$f":"PFP!C10","v":"P2"},{"$f":"PFP!E10","v":"Engenheiro pleno (P8066)"},"mês",53,{"$f":"PFP!H10","v":12379.96},{"$f":"PFP!I10","v":26738.240000000002},{"$f":"PFP!J10","v":2.1598000000000002},{"$f":"'CRO2_Ins-Mes'!E20","v":4},{"$f":"'CRO2_Ins-Mes'!E32","v":0},{"$f":"'CRO2_Ins-Mes'!$E46/8","v":6.125},{"$f":"'CRO2_Ins-Mes'!$E46/8","v":6.125},{"$f":"'CRO2_Ins-Mes'!$E46/8","v":6.125},{"$f":"'CRO2_Ins-Mes'!$E46/8","v":6.125},{"$f":"'CRO2_Ins-Mes'!$E46/8","v":6.125},{"$f":"'CRO2_Ins-Mes'!$E46/8","v":6.125},{"$f":"'CRO2_Ins-Mes'!$E46/8","v":6.125},{"$f":"'CRO2_Ins-Mes'!$E46/8","v":6.125}]
[{"$f":"PFP!C11","v":"P3"},{"$f":"PFP!E11","v":"Engenheiro júnior (P8065)"},"mês",39,{"$f":"PFP!H11","v":12002},{"$f":"PFP!I11","v":25921.919999999998},{"$f":"PFP!J11","v":2.1598000000000002},{"$f":"'CRO2_Ins-Mes'!E21","v":4},{"$f":"'CRO2_Ins-Mes'!E33","v":0},{"$f":"'CRO2_Ins-Mes'!$E47/8","v":4.375},{"$f":"'CRO2_Ins-Mes'!$E47/8","v":4.375},{"$f":"'CRO2_Ins-Mes'!$E47/8","v":4.375},{"$f":"'CRO2_Ins-Mes'!$E47/8","v":4.375},{"$f":"'CRO2_Ins-Mes'!$E47/8","v":4.375},{"$f":"'CRO2_Ins-Mes'!$E47/8","v":4.375},{"$f":"'CRO2_Ins-Mes'!$E47/8","v":4.375},{"$f":"'CRO2_Ins-Mes'!$E47/8","v":4.375}]
[{"$f":"PFP!C12","v":"T1"},{"$f":"PFP!E12","v":"Técnico de projetos/obra (P8147)"},"mês",39,{"$f":"PFP!H12","v":3167.62},{"$f":"PFP!I12","v":6841.43},{"$f":"PFP!J12","v":2.1598000000000002},{"$f":"'CRO2_Ins-Mes'!E22","v":4},{"$f":"'CRO2_Ins-Mes'!E34","v":0},{"$f":"'CRO2_Ins-Mes'!$E48/8","v":4.375},{"$f":"'CRO2_Ins-Mes'!$E48/8","v":4.375},{"$f":"'CRO2_Ins-Mes'!$E48/8","v":4.375},{"$f":"'CRO2_Ins-Mes'!$E48/8","v":4.375},{"$f":"'CRO2_Ins-Mes'!$E48/8","v":4.375},{"$f":"'CRO2_Ins-Mes'!$E48/8","v":4.375},{"$f":"'CRO2_Ins-Mes'!$E48/8","v":4.375},{"$f":"'CRO2_Ins-Mes'!$E48/8","v":4.375}]
[{"$f":"PFP!C13","v":"D"},{"$f":"PFP!E13","v":"Desenhista (40807)"},"mês",35,{"$f":"PFP!H13","v":4976.43},{"$f":"PFP!I13","v":6021.98},{"$f":"PFP!J13","v":1.2101},{"$f":"'CRO2_Ins-Mes'!E23","v":0},{"$f":"'CRO2_Ins-Mes'!E35","v":0},{"$f":"'CRO2_Ins-Mes'!$E49/8","v":4.375},{"$f":"'CRO2_Ins-Mes'!$E49/8","v":4.375},{"$f":"'CRO2_Ins-Mes'!$E49/8","v":4.375},{"$f":"'CRO2_Ins-Mes'!$E49/8","v":4.375},{"$f":"'CRO2_Ins-Mes'!$E49/8","v":4.375},{"$f":"'CRO2_Ins-Mes'!$E49/8","v":4.375},{"$f":"'CRO2_Ins-Mes'!$E49/8","v":4.375},{"$f":"'CRO2_Ins-Mes'!$E49/8","v":4.375}]
[{"$f":"PFP!C14","v":"A1"},{"$f":"PFP!E14","v":"Secretária (P8135)"},"mês",7,{"$f":"PFP!H14","v":2604.7800000000002},{"$f":"PFP!I14","v":5625.8},{"$f":"PFP!J14","v":2.1598000000000002},{"$f":"'CRO2_Ins-Mes'!E24","v":0},{"$f":"'CRO2_Ins-Mes'!E36","v":0},{"$f":"'CRO2_Ins-Mes'!$E50/8","v":0.875},{"$f":"'CRO2_Ins-Mes'!$E50/8","v":0.875},{"$f":"'CRO2_Ins-Mes'!$E50/8","v":0.875},{"$f":"'CRO2_Ins-Mes'!$E50/8","v":0.875},{"$f":"'CRO2_Ins-Mes'!$E50/8","v":0.875},{"$f":"'CRO2_Ins-Mes'!$E50/8","v":0.875},{"$f":"'CRO2_Ins-Mes'!$E50/8","v":0.875},{"$f":"'CRO2_Ins-Mes'!$E50/8","v":0.875}]
[{"$f":"PFP!C15","v":"ECA"},{"$f":"PFP!E15","v":"Encargos Comp. e Adicionais"},"mês",220,{"$f":"PFP!H15","v":1046.1471428571431},{"$f":"PFP!I15","v":1265.94},{"$f":"PFP!J15","v":1.2101},{"$f":"SUM(H5:H11)","v":17},{"$f":"SUM(I5:I11)","v":0},{"$f":"SUM(J5:J11)","v":25.375},{"$f":"SUM(K5:K11)","v":25.375},{"$f":"SUM(L5:L11)","v":25.375},{"$f":"SUM(M5:M11)","v":25.375},25.375,25.375,25.375,25.375]
[{"$f":"PFP!C16","v":"AT2"},{"$f":"PFP!E16","v":"Auxilio Transporte Técnicos"},"mês",0,{"$f":"PFP!H16","v":"Já incluso*"},{"$f":"PFP!I16","v":0},{"$f":"PFP!J16","v":1.2101}]
[{"$f":"PFP!C17","v":"AT3"},{"$f":"PFP!E17","v":"Auxilio Transporte Secretária"},"mês",0,{"$f":"PFP!H17","v":"Já Incluso*"},{"$f":"PFP!I17","v":0},{"$f":"PFP!J17","v":1.2101}]
[{"$f":"PFP!C18","v":"V1"},{"$f":"PFP!E18","v":"Diárias"},"dia",235,{"$f":"PFP!H18","v":184.44008333333335},{"$f":"PFP!I18","v":223.19},{"$f":"PFP!J18","v":1.2101},{"$f":"'CRO2_Ins-Mes'!E25","v":25},{"$f":"'CRO2_Ins-Mes'!E37","v":0},{"$f":"'CRO2_Ins-Mes'!$E51/8","v":26.25},{"$f":"'CRO2_Ins-Mes'!$E51/8","v":26.25},{"$f":"'CRO2_Ins-Mes'!$E51/8","v":26.25},{"$f":"'CRO2_Ins-Mes'!$E51/8","v":26.25},{"$f":"'CRO2_Ins-Mes'!$E51/8","v":26.25},{"$f":"'CRO2_Ins-Mes'!$E51/8","v":26.25},{"$f":"'CRO2_Ins-Mes'!$E51/8","v":26.25},{"$f":"'CRO2_Ins-Mes'!$E51/8","v":26.25}]
[{"$f":"PFP!C19","v":"V2"},{"$f":"PFP!E19","v":"Pick-up Cab.dupla 2.8 4x4 Diesel"},"dia",75,{"$f":"PFP!H19","v":325.62682583461901},{"$f":"PFP!I19","v":394.04},{"$f":"PFP!J19","v":1.2101},{"$f":"'CRO2_Ins-Mes'!E26","v":5},{"$f":"'CRO2_Ins-Mes'!E38","v":0},{"$f":"'CRO2_Ins-Mes'!$E52/8","v":8.75},{"$f":"'CRO2_Ins-Mes'!$E52/8","v":8.75},{"$f":"'CRO2_Ins-Mes'!$E52/8","v":8.75},{"$f":"'CRO2_Ins-Mes'!$E52/8","v":8.75},{"$f":"'CRO2_Ins-Mes'!$E52/8","v":8.75},{"$f":"'CRO2_Ins-Mes'!$E52/8","v":8.75},{"$f":"'CRO2_Ins-Mes'!$E52/8","v":8.75},{"$f":"'CRO2_Ins-Mes'!$E52/8","v":8.75}]
[{"$f":"PFP!C20","v":"V3"},{"$f":"PFP!E20","v":"Passagens Aéreas (ida e volta)"},"um",40,{"$f":"PFP!H20","v":1853.8333333333333},{"$f":"PFP!I20","v":2243.3200000000002},{"$f":"PFP!J20","v":1.2101},{"$f":"'CRO2_Ins-Mes'!E27","v":5},0,{"$f":"'CRO2_Ins-Mes'!$E53/8","v":4.375},{"$f":"'CRO2_Ins-Mes'!$E53/8","v":4.375},{"$f":"'CRO2_Ins-Mes'!$E53/8","v":4.375},{"$f":"'CRO2_Ins-Mes'!$E53/8","v":4.375},{"$f":"'CRO2_Ins-Mes'!$E53/8","v":4.375},{"$f":"'CRO2_Ins-Mes'!$E53/8","v":4.375},{"$f":"'CRO2_Ins-Mes'!$E53/8","v":4.375},{"$f":"'CRO2_Ins-Mes'!$E53/8","v":4.375}]
[{"$f":"PFP!C21","v":"M1"},{"$f":"PFP!E21","v":"Relatório Parcial"},"un",28,{"$f":"PFP!H21","v":51.3},{"$f":"PFP!I21","v":62.08},{"$f":"PFP!J21","v":1.2101},0,0,0,1,2,3,4,5,6,7]
[{"$f":"PFP!C22","v":"M2"},{"$f":"PFP!E22","v":"Relatório Final"},"un",2,{"$f":"PFP!H22","v":1474.85},{"$f":"PFP!I22","v":1784.72},{"$f":"PFP!J22","v":1.2101},{"$f":"'CRO2_Ins-Mes'!E28","v":1},0,{"$f":"'CRO2_Ins-Mes'!$E54/8","v":0.125},{"$f":"'CRO2_Ins-Mes'!$E54/8","v":0.125},{"$f":"'CRO2_Ins-Mes'!$E54/8","v":0.125},{"$f":"'CRO2_Ins-Mes'!$E54/8","v":0.125},{"$f":"'CRO2_Ins-Mes'!$E54/8","v":0.125},{"$f":"'CRO2_Ins-Mes'!$E54/8","v":0.125},{"$f":"'CRO2_Ins-Mes'!$E54/8","v":0.125},{"$f":"'CRO2_Ins-Mes'!$E54/8","v":0.125}]
[{"$f":"PFP!C23","v":"TOP"},{"$f":"PFP!E23","v":"Total Serviços Cartográficos"},"un",1,{"$f":"PFP!H23","v":"-"},{"$f":"PFP!I23","v":740295.08760426228},{"$f":"PFP!J23","v":"-"},null,{"$f":"'CRO2_Ins-Mes'!E40","v":1}]
[{"$f":"PFP!C24","v":"GEO"},{"$f":"PFP!E24","v":"Total Serviços Geotécnicos"},"un",1,{"$f":"PFP!H24","v":"-"},{"$f":"PFP!I24","v":928892.04041844537},{"$f":"PFP!J24","v":"-"},null,{"$f":"'CRO2_Ins-Mes'!E41","v":1}]
["AMB","Total Serviços Ambientais","un",1,null,{"$f":"PFP!L25","v":13588.94},null,null,{"$f":"'CRO2_Ins-Mes'!E42","v":1}]
["TOTAL","VALOR TOTAL POR PRODUTO","R$",{"$f":"SUM(H23:Q23)","v":6201307.5980227059},null,null,null,{"$f":"(H5*$F$5+H6*$F$6+H7*$F$7+H8*$F$8+H9*$F$9+H10*$F$10+H11*$F$11+H12*$F$12+H13*$F$13+H14*$F$14+$F$15*H15+$F$16*H16+$F$17*H17+H18*$F$18+H19*$F$19)","v":398890.75999999995},{"$f":"(I5*$F$5+I6*$F$6+I7*$F$7+I8*$F$8+I9*$F$9+I10*$F$10+I11*$F$11+I12*$F$12+I13*$F$13+I14*$F$14+$F$15*I15+$F$16*I16+$F$17*I17+I18*$F$18+I19*$F$19+F20*I20+F21*I21+F22*I22)","v":1682776.0680227075},{"$f":"(J5*$F$5+J6*$F$6+J7*$F$7+J8*$F$8+J9*$F$9+J10*$F$10+J11*$F$11+J12*$F$12+J13*$F$13+J14*$F$14+F15*J15+F16*J16+F17*J17+J18*$F$18+J19*$F$19)","v":514737.81624999992},{"$f":"(K5*$F$5+K6*$F$6+K7*$F$7+K8*$F$8+K9*$F$9+K10*$F$10+K11*$F$11+K12*$F$12+K13*$F$13+K14*$F$14+$F$15*K15+$F$16*K16+$F$17*K17+K18*$F$18+K19*$F$19)","v":514799.89624999993},{"$f":"(L5*$F$5+L6*$F$6+L7*$F$7+L8*$F$8+L9*$F$9+L10*$F$10+L11*$F$11+L12*$F$12+L13*$F$13+L14*$F$14+$F$15*L15+$F$16*L16+$F$17*L17+L18*$F$18+L19*$F$19)","v":514861.97624999989},{"$f":"(M5*$F$5+M6*$F$6+M7*$F$7+M8*$F$8+M9*$F$9+M10*$F$10+M11*$F$11+M12*$F$12+M13*$F$13+M14*$F$14+$F$15*M15+$F$16*M16+$F$17*M17+M18*$F$18+M19*$F$19)","v":514924.05624999991},514986.13624999992,515048.21624999994,515110.2962499999,515172.37624999991]
[null,null,"%",{"$f":"SUM(H24:Q24)","v":0.99995999999999996},null,null,null,{"$f":"ROUND(H23/$D$23,5)","v":6.4320000000000002E-2},{"$f":"ROUND(I23/$D$23,5)","v":0.27135999999999999},{"$f":"ROUND(J23/$D$23,5)","v":8.3000000000000004E-2},{"$f":"ROUND(K23/$D$23,5)","v":8.301E-2},{"$f":"ROUND(L23/$D$23,5)","v":8.3019999999999997E-2},{"$f":"ROUND(M23/$D$23,5)","v":8.3030000000000007E-2},8.3040000000000003E-2,8.3049999999999999E-2,8.3059999999999995E-2,8.3070000000000005E-2]
{"$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":9,"n_rows":56,"n_cols":15,"rows_kept":56,"cut":false,"hidden":false,"merged":[[78,5,78,11],[0,0,1,14]]}
["CRONOGRAMA SIMPLIFICADO"]
[]
["Cod1","Cod2","Produtos","Uni","Qde",1,2,3,4,5,6,7,8,9,10]
[1,"1.1","Análise Crítica do Projeto Básico (AC)","mês",{"$f":"SUM(F4:L4)","v":1},1]
[1,1,"Análise Crítica do Projeto Básico (AC)","mês",1,{"$f":"SUBTOTAL(4,F4:F4)","v":1},0,0,0,0,0,0]
[2,"2.1","Serviços Topográficos/Cartográficos","mês",2,null,1,1]
[2,"2.2","Serviços Geológicos/Geotécnicos","mês",2,null,1,1]
[2,2,"Estudos Básicos (EB)","mês",2,{"$f":"SUBTOTAL(4,F6:F7)","v":0},1,1,0,0,0,0]
[3,"3.1","Projeto Terraplanagem e Urbanização, Viário e Drenagem","mês",{"$f":"SUM(F9:O9)","v":7},null,null,null,1,1,1,1,1,1,1]
[3,"3.2","Projeto Estrutural e Fundações","mês",{"$f":"SUM(F10:O10)","v":7},null,null,null,1,1,1,1,1,1,1]
[3,"3.3","Projeto Edificações e Elementos Civis","mês",7,null,null,null,1,1,1,1,1,1,1]
[3,"3.4","Projeto Hidromecânico ","mês",7,null,null,null,1,1,1,1,1,1,1]
[3,"3.5","Projeto Elétrico, Automação e Controle","mês",7,null,null,null,1,1,1,1,1,1,1]
[3,"3.6","Projeto Consolidado e Peças Complementares","mês",7,null,null,null,1,1,1,1,1,1,1]
[3,3,"Projeto Executivo","mês",{"$f":"SUM(F15:O15)","v":7},{"$f":"SUBTOTAL(4,F9:F14)","v":0},0,0,1,1,1,1,1,1,1]
["Total","Total","Balanço Temporal","mês",6,{"$f":"SUBTOTAL(4,F6:F15)","v":0},1,1,1,1,1,1,1,1,{"$f":"SUBTOTAL(4,O6:O15)","v":1}]
["Cod1","Cod2","Insumos","Uni","Qde",1,2,3,4,5,6,7,8,9,10]
[1,{"$f":"PFP!C8","v":"P0"},{"$f":"PFP!E8","v":"Engenheiro coordenador (P8061)"},{"$f":"PFP!F8","v":"mês"},{"$f":"SUM(F18:L18)","v":1},1]
[1,{"$f":"PFP!C9","v":"P1"},{"$f":"PFP!E9","v":"Engenheiro sênior (P8067)"},{"$f":"PFP!F9","v":"mês"},4,4]
[1,{"$f":"PFP!C10","v":"P2"},{"$f":"PFP!E10","v":"Engenheiro pleno (P8066)"},{"$f":"PFP!F10","v":"mês"},4,4]
[1,{"$f":"PFP!C11","v":"P3"},{"$f":"PFP!E11","v":"Engenheiro júnior (P8065)"},{"$f":"PFP!F11","v":"mês"},4,4,null,{"$f":"H20/2","v":0},{"$f":"I20/2","v":0},{"$f":"J20/2","v":0},{"$f":"K20/2","v":0},{"$f":"L20/2","v":0}]
[1,{"$f":"PFP!C12","v":"T1"},{"$f":"PFP!E12","v":"Técnico de projetos/obra (P8147)"},{"$f":"PFP!F12","v":"mês"},4,4]
[1,{"$f":"PFP!C13","v":"D"},{"$f":"PFP!E13","v":"Desenhista (40807)"},{"$f":"PFP!F13","v":"mês"},0]
[1,{"$f":"PFP!C14","v":"A1"},{"$f":"PFP!E14","v":"Secretária (P8135)"},{"$f":"PFP!F14","v":"mês"},0]
[1,{"$f":"PFP!C18","v":"V1"},{"$f":"PFP!E18","v":"Diárias"},{"$f":"PFP!F18","v":"dia"},25,25]
[1,{"$f":"PFP!C19","v":"V2"},{"$f":"PFP!E19","v":"Pick-up Cab.dupla 2.8 4x4 Diesel"},{"$f":"PFP!F19","v":"dia"},5,5]
[1,{"$f":"PFP!C20","v":"V3"},{"$f":"PFP!E20","v":"Passagens Aéreas (ida e volta)"},{"$f":"PFP!F20","v":"un"},5,5]
[1,{"$f":"PFP!C22","v":"M2"},{"$f":"PFP!E22","v":"Relatório Final"},{"$f":"PFP!F22","v":"un"},1,1]
[1,null,"Análise Crítica do Projeto Básico (AC)"]
[2,{"$f":"PFP!C8","v":"P0"},{"$f":"PFP!E8","v":"Engenheiro coordenador (P8061)"},{"$f":"PFP!F8","v":"mês"},{"$f":"SUM(F30:L30)","v":0}]
[2,{"$f":"PFP!C9","v":"P1"},{"$f":"PFP!E9","v":"Engenheiro sênior (P8067)"},{"$f":"PFP!F9","v":"mês"},0]
[2,{"$f":"PFP!C10","v":"P2"},{"$f":"PFP!E10","v":"Engenheiro pleno (P8066)"},{"$f":"PFP!F10","v":"mês"},0]
[2,{"$f":"PFP!C11","v":"P3"},{"$f":"PFP!E11","v":"Engenheiro júnior (P8065)"},{"$f":"PFP!F11","v":"mês"},0,null,null,{"$f":"H32/2","v":0},{"$f":"I32/2","v":0},{"$f":"J32/2","v":0},{"$f":"K32/2","v":0},{"$f":"L32/2","v":0}]
[2,{"$f":"PFP!C12","v":"T1"},{"$f":"PFP!E12","v":"Técnico de projetos/obra (P8147)"},{"$f":"PFP!F12","v":"mês"},0]
[2,{"$f":"PFP!C13","v":"D"},{"$f":"PFP!E13","v":"Desenhista (40807)"},{"$f":"PFP!F13","v":"mês"},0]
[2,{"$f":"PFP!C14","v":"A1"},{"$f":"PFP!E14","v":"Secretária (P8135)"},{"$f":"PFP!F14","v":"mês"},0]
[2,{"$f":"PFP!C18","v":"V1"},{"$f":"PFP!E18","v":"Diárias"},{"$f":"PFP!F18","v":"dia"}]
[2,{"$f":"PFP!C19","v":"V2"},{"$f":"PFP!E19","v":"Pick-up Cab.dupla 2.8 4x4 Diesel"},{"$f":"PFP!F19","v":"dia"}]
[2,{"$f":"PFP!C20","v":"V3"},{"$f":"PFP!E20","v":"Passagens Aéreas (ida e volta)"},{"$f":"PFP!F20","v":"un"}]
[2,{"$f":"PFP!C23","v":"TOP"},{"$f":"PFP!E23","v":"Total Serviços Cartográficos"},{"$f":"PFP!F21","v":"un"},{"$f":"SUM(F40:L40)","v":1},null,null,1]
[2,{"$f":"PFP!C24","v":"GEO"},{"$f":"PFP!E24","v":"Total Serviços Geotécnicos"},{"$f":"PFP!F22","v":"un"},{"$f":"SUM(F41:L41)","v":1},null,null,1]
[2,"AMB","Total Serviços Ambientais",{"$f":"PFP!F23","v":"un"},{"$f":"SUM(F42:L42)","v":1},null,null,1]
[2,null,"Estudos Básicos (EB)"]
[3,{"$f":"PFP!C8","v":"P0"},{"$f":"PFP!E8","v":"Engenheiro coordenador (P8061)"},{"$f":"PFP!F8","v":"mês"},{"$f":"SUM(F44:O44)","v":7},null,null,null,1,1,1,1,1,1,1]
[3,{"$f":"PFP!C9","v":"P1"},{"$f":"PFP!E9","v":"Engenheiro sênior (P8067)"},{"$f":"PFP!F9","v":"mês"},{"$f":"SUM(F45:O45)","v":35},null,null,null,5,5,5,5,5,5,5]
[3,{"$f":"PFP!C10","v":"P2"},{"$f":"PFP!E10","v":"Engenheiro pleno (P8066)"},{"$f":"PFP!F10","v":"mês"},49,null,null,null,7,7,7,7,7,7,7]
[3,{"$f":"PFP!C11","v":"P3"},{"$f":"PFP!E11","v":"Engenheiro júnior (P8065)"},{"$f":"PFP!F11","v":"mês"},35,null,null,null,5,5,5,5,5,5,5]
[3,{"$f":"PFP!C12","v":"T1"},{"$f":"PFP!E12","v":"Técnico de projetos/obra (P8147)"},{"$f":"PFP!F12","v":"mês"},35,null,null,null,5,5,5,5,5,5,5]
[3,{"$f":"PFP!C13","v":"D"},{"$f":"PFP!E13","v":"Desenhista (40807)"},{"$f":"PFP!F13","v":"mês"},35,null,null,null,5,5,5,5,5,5,5]
[3,{"$f":"PFP!C14","v":"A1"},{"$f":"PFP!E14","v":"Secretária (P8135)"},{"$f":"PFP!F14","v":"mês"},7,null,null,null,1,1,1,1,1,1,1]
[3,{"$f":"PFP!C18","v":"V1"},{"$f":"PFP!E18","v":"Diárias"},{"$f":"PFP!F18","v":"dia"},210,null,null,null,30,30,30,30,30,30,30]
[3,{"$f":"PFP!C19","v":"V2"},{"$f":"PFP!E19","v":"Pick-up Cab.dupla 2.8 4x4 Diesel"},{"$f":"PFP!F19","v":"dia"},70,null,null,null,10,10,10,10,10,10,10]
[3,{"$f":"PFP!C20","v":"V3"},{"$f":"PFP!E20","v":"Passagens Aéreas (ida e volta)"},{"$f":"PFP!F20","v":"un"},35,null,null,null,5,5,5,5,5,5,5]
[3,{"$f":"PFP!C22","v":"M2"},{"$f":"PFP!E22","v":"Relatório Final"},{"$f":"PFP!F22","v":"un"},1,{"$nulls":6},0,null,null,1]
[3,null,"Projeto Executivo"]
["Total",null,"Balanço de Insumos",null,null,{"$f":"SUBTOTAL(2,F30:F55)","v":0},0,4,11,11,11,12,10,10,11]

{"sheet":"CPU PICK-UP","index":10,"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":"MDO_DNIT","index":11,"n_rows":113,"n_cols":26,"rows_kept":113,"cut":false,"hidden":false,"merged":[[0,25,1,25],[1,6,1,7],[1,8,1,9],[1,10,1,11],[1,12,1,13],[1,14,1,15],[1,16,1,17],[0,6,0,15],[1,18,1,19],[1,20,1,21],[0,16,0,21],[0,22,1,23],[0,24,1,24],[0,0,2,0],[0,1,2,1],[0,2,2,2],[0,3,1,3],[0,4,1,5]]}
["Código","Categoria","Unid.","Salário","Encargos Sociais",null,"Encargos Complementares",{"$nulls":9},"Encargos Adicionais",{"$nulls":5},"Encargos Totais",null,"Valor Total","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":12,"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 ",2487.0700000000002,"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":779.52066666666678}]
[null,"Custo Mensal:",{"$f":"SUM(C4:C12)","v":8574.7273333333342}]
[null,"Custo Mensal por pessoa:",{"$f":"C13/C16","v":2143.6818333333335}]
[null,"Custo diário por pessoa:",{"$f":"C14/22","v":97.440083333333348}]
[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":184.44008333333335}]

{"sheet":"Cotação Voos","index":13,"n_rows":106,"n_cols":6,"rows_kept":106,"cut":false,"hidden":false,"merged":[]}
["COTAÇÕES - IDA DIA 25/011/2024 E VOLTA DIA 29/011/2024"]
["Localidade:","Natal/RN"]
[]
["Origem","Destino"]
["BSB ",{"$f":"B2","v":"Natal/RN"},"Cia 1","Cia 2","Cia 3","Média"]
[null,null,1171,1446,1598,{"$f":"AVERAGE(C6:E6)","v":1405}]
{"$rows_empty":24}
["SP",{"$f":"B2","v":"Natal/RN"},"Cia 1","Cia 2","Cia 3","Média"]
[null,null,1546,1546,1691,{"$f":"AVERAGE(C32:E32)","v":1594.3333333333333}]
{"$rows_empty":24}
["Curitiba",{"$f":"B2","v":"Natal/RN"},"Cia 1","Cia 2","Cia 3","Média"]
[null,null,1514,1539,1630,{"$f":"AVERAGE(C58:E58)","v":1561}]
{"$rows_empty":23}
["Aracaju",{"$f":"B2","v":"Natal/RN"},"Cia 1","Cia 2","Cia 3","Média"]
[null,null,2666,2666,3233,{"$f":"AVERAGE(C83:E83)","v":2855}]
{"$rows_empty":22}
["VALOR ADOTADO:",null,{"$f":"AVERAGE(F6:F83)","v":1853.8333333333333}]

{"sheet":"Serv Graficos","index":14,"n_rows":42,"n_cols":9,"rows_kept":42,"cut":false,"hidden":false,"merged":[[35,0,35,4],[36,0,36,4],[37,0,37,4],[38,0,38,4],[39,0,39,4],[25,0,25,3],[2,0,2,4],[14,0,14,4],[18,0,18,3],[20,1,20,2],[21,0,21,4]]}
[]
[]
["Serviços Gráficos"]
[]
["Serviço",null,"Referencia","Código","Valor",null,null,"1 Vol Impressão Rel Final"]
["Impressão colorida",null,"SETOP/COMPOSIÇÃO","CO-2019",1.8,null,"Preto",{"$f":"C17*E7","v":91.35}]
["Impressão preta",null,"SETOP/COMPOSIÇÃO","CO-2017",0.28999999999999998,null,"Colorida",{"$f":"D17*E6","v":63}]
["Encadernação até 350 fls.",null,"EMBASA/COMPOSIÇÃO","30.02.30 / 30.02.27",{"$f":"20+7.2","v":27.2},"Foi considerado a soma de 2 composições, com encadernação de 250 e 100 folhas","Encader",{"$f":"E8","v":27.2}]
["Encadernação até 50 fls.",null,"EMBASA/COMPOSIÇÃO","30.02.26",6,null,"Total",{"$f":"SUM(H6:H8)","v":181.54999999999998}]
["Encadernação até 100 fls.",null,"EMBASA/COMPOSIÇÃO","30.02.27",7.2]
["Impressão em A3",null,"SETOP/COMPOSIÇÃO","CO-2018 / CO-2018",{"$f":"(4.33+0.83)/2","v":2.58},"Foi considerado a média para impressão colorida e preta/branco",null,"1 Rel A3"]
["Impressão em A1",null,"SIURB/INSUMO",84082,0.77,null,"Impresão A3",{"$f":"B18*E11","v":903}]
[{"$nulls":6},"Encader",{"$f":"E8","v":27.2}]
[{"$nulls":6},"Total",{"$f":"SUM(H12:H13)","v":930.2}]
["RELATÓRIO FINAL"]
["Qtd Rel Final (Volumes)","Qtd Pág por Volume","Qtd Impressão Preta","Qtd Impressão Color","Custo Unitário Parcial"]
[3,350,{"$f":"B17*0.9","v":315},{"$f":"B17*0.1","v":35},{"$f":"H9*A17","v":544.65},"Estimamos 90% do total de páginas de impressões pretas e 10% coloridas."]
["Peça Gráfica - Impressão em A3",350,null,null,{"$f":"ROUND(((B18*E11)+E8),2)","v":930.2}]
["Custo Unitário Rel Final",null,null,null,{"$f":"SUM(E17:E18)","v":1474.85}]
[]
[]
["MINUTA DO RELATÓRIO FINAL"]
["Qtd Rel Final (Volumes)","Qtd Pág por Volume","Qtd Impressão Preta","Qtd Impressão Color","Custo Unitário Parcial"]
[3,350,{"$f":"B24*0.9","v":315},{"$f":"B24*0.1","v":35},{"$f":"H9*A24","v":544.65}]
["Peça Gráfica - Impressão em A4",350,null,null,{"$f":"(E7*B25)+H8","v":128.69999999999999}]
["Custo Unitário Rel Final",null,null,null,{"$f":"SUM(E24:E25)","v":673.34999999999991}]
[]
[]
["Descrição","Qtd Pág por Volume","Qtd Impressão Preta","Qtd Impressão Color","Custo Unitário Total"]
["Relatório Mensal",50,{"$f":"B30*0.9","v":45},{"$f":"B30*0.1","v":5},{"$f":"H41","v":28.049999999999997},"Estimamos a quantidade de página por volume."]
["Relatório Parcial",100,{"$f":"B31*0.9","v":90},{"$f":"B31*0.1","v":10},{"$f":"I42","v":51.3},"Estimamos a quantidade de página por volume."]
["Minuta do Relatório Final",null,null,null,{"$f":"E26","v":673.34999999999991}]
["Relatório Final",null,null,null,{"$f":"E19","v":1474.85}]
[]
[]
["OBS:      A quantidade de páginas por volume foi estimada"]
["1 - Relatório Mensal: Será considerado 01 Volume com uma quantidade estimada de 50 páginas.",{"$nulls":6},"1 Rel Mensal"]
["2 - Relatório Parcial: Será considerado 01 Volumes com uma quantidade estimada de 100 páginas.",{"$nulls":6},{"$f":"C30*E7","v":13.049999999999999},"1 Rel Parcial"]
["3 - Minuta do Relatório Final:  Será considerado 03 Volumes com uma quantidade estimada de 350 páginas, cada, + 01 Volume de desenho em Folha A4, com estimativa de 350 páginas.",{"$nulls":6},{"$f":"D30*E6","v":9},{"$f":"C31*E7","v":26.099999999999998}]
["4 - Relatório Final:  Será considerado 03 Volumes com uma quantidade estimada de 350 páginas, cada, + 01 Volume de desenho em Folha A3, com estimativa de 350 páginas.",{"$nulls":6},{"$f":"E9","v":6},{"$f":"D31*E6","v":18}]
[{"$nulls":6},"Total",{"$f":"SUM(H38:H40)","v":28.049999999999997},{"$f":"E10","v":7.2}]
[{"$nulls":8},{"$f":"SUM(I39:I41)","v":51.3}]

{"sheet":"COT. VANT","index":15,"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}]