{"text_format":"2","workbook":"xlsx","n_sheets":20,"sheets":["PFP","PFP1.1Serv Graficos","PFP1.2_Equi_div","PFP1.3_Ger","PFP1.4_Ensaios_Solo_Concreto","PFP2.1_FatorKa","PFP2.2_FatorKb","PFP2.3_FatorKc","PFP3_FatorKd","Cronograma Físico-Financeiro","CPU-VEICULO_PickUp","CPU-VEICULO_Leve","CPU HOSPEDAGEM","CPU ESCRIT. CONTAINER","MDO -  DNIT","C.G - DNIT","Cotação Voos","AUX - MOBILIÁRIO","AUX - NOTEBOOK","AUX - IMPRESSORA"],"not_rendered":{"charts":0,"images":63,"macros":0,"external_links":336,"defined_names":35395,"comments":3,"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":39,"n_cols":19,"rows_kept":39,"cut":false,"hidden":false,"merged":[[18,7,18,10],[18,0,18,5],[25,0,25,10],[19,0,19,5],[19,7,19,10],[22,0,22,10],[21,0,21,10],[33,0,33,10],[26,0,26,10],[28,0,28,10],[20,0,20,10],[27,0,27,10],[23,0,23,10],[29,0,29,10],[30,0,30,10],[31,0,31,10],[32,0,32,10],[24,0,24,10],[0,0,1,8],[4,5,4,8],[0,9,0,10],[1,9,1,10],[4,9,4,10],[2,0,2,10],[3,0,3,10],[4,0,4,4],[5,9,5,10],[5,5,5,8],[17,0,17,5],[17,7,17,10],[5,0,5,4],[16,0,16,5],[16,7,16,10]]}
["PROPOSTA FINANCEIRA DO PROJETO",{"$nulls":8},"CODIGO:"]
[{"$nulls":9},"PFP"]
["NOME DA CONSULTORA:"]
[]
["PROJETO:",{"$nulls":4},"CONTRATANTE:",null,null,null,"BASE:"]
["CONTRATAÇÃO DOS SERVIÇOS DE APOIO À FISCALIZAÇÃO PARA EXECUÇÃO DAS OBRAS DE ENGENHARIA, VISANDO A IMPLANTAÇÃO DE PONTE EM CONCRETO ARMADO SOBRE O RIO MELCHIOR, NA REGIÃO ADMINISTRATIVA DA CEILÂNDIA, DISTRITO FEDERAL.",{"$nulls":4},"CODEVASF (SEDE)",null,null,null,"SICRO JAN/2025; SINAPI MAIO/2025; EMBASA JAN/2025; ORSE ABR/2025; SUDECAP JAN/2025.                            DATA-BASE ORÇAMENTO: JUN/2025"]
["Base","Cod2","Código","Categoria / Insumo","Uni","Qde","CUD","PU","FatorK","CT","PT","Encargos COMP E ADICIONAIS","SOCIAIS","TOTAIS",null,"Encargos Comp e Adicionais"]
["SICRO","MO1","P8065","Engenheiro Júnior","mês",8,{"$f":"VLOOKUP(C8,'MDO -  DNIT'!$A:$Z,4,0)","v":12903},{"$f":"G8*I8","v":27666.6126},{"$f":"'PFP2.1_FatorKa'!$E$36","v":2.1442000000000001},{"$f":"G8*F8","v":103224},{"$f":"ROUND(J8*I8,2)","v":221332.9},{"$nulls":4},{"$f":"VLOOKUP(C8,'MDO -  DNIT'!$A:$Z,26,0)","v":1087.2199999999993},null,null,40]
["SICRO","MO1","P8147","Técnico - Profissional Especial","mês",8,{"$f":"VLOOKUP(C9,'MDO -  DNIT'!$A:$Z,4,0)","v":3242.89},6953.4047380000002,{"$f":"'PFP2.1_FatorKa'!$E$36","v":2.1442000000000001},{"$f":"G9*F9","v":25943.119999999999},{"$f":"ROUND(J9*I9,2)","v":55627.24},{"$f":"N9-M9","v":1070.1799999999998},2450.48,3520.66,null,{"$f":"VLOOKUP(C9,'MDO -  DNIT'!$A:$Z,26,0)","v":1144.7199999999998},null,null,40]
["SICRO","MO1","P8098","Técnico Auxiliar (Laboratorista)","mês",8,{"$f":"VLOOKUP(C10,'MDO -  DNIT'!$A:$Z,4,0)","v":2413.91},5175.9058219999997,{"$f":"'PFP2.1_FatorKa'!$E$36","v":2.1442000000000001},19311.28,41407.25,{"$nulls":4},{"$f":"VLOOKUP(C10,'MDO -  DNIT'!$A:$Z,26,0)","v":1194.73},null,null,40]
["CODE","LO","PROP","Relatório Semanal de Obras","und",32,{"$f":"'PFP1.3_Ger'!H13","v":506.51431818181823},612.93297643181825,{"$f":"PFP3_FatorKd!$E$17","v":1.2101},16208.458181818183,{"$f":"H11*F11","v":19613.855245818184}]
["CODE","LO","PROP","Consultoria de Interpretação de Projeto para Execução","und",4,{"$f":"'PFP1.3_Ger'!H20","v":5489.9025000000001},6643.3310152499998,{"$f":"PFP3_FatorKd!$E$17","v":1.2101},21959.61,{"$f":"H12*F12","v":26573.324060999999}]
["CODE","LO","PROP","Levantamento Topográfico","und",1,{"$f":"'PFP1.3_Ger'!H28","v":9939.23},12027.462222999999,{"$f":"PFP3_FatorKd!$E$17","v":1.2101},9939.23,12027.462222999999]
["CODE","LO","PROP","Veículo leve - 71 a 115 CV","mês",16,{"$f":"'CPU-VEICULO_Leve'!D49","v":1763.0317835074602},2133.4447612223776,{"$f":"PFP3_FatorKd!$E$17","v":1.2101},28208.508536119363,34135.120000000003,{"$nulls":7},86]
["CODE","LO","PROP","Infraestrutura e Equipamentos de Escritório","und",1,{"$f":"'PFP1.2_Equi_div'!G11","v":27870.320000000003},{"$f":"G15*I15","v":33725.874232000002},{"$f":"PFP3_FatorKd!$E$17","v":1.2101},{"$f":"G15*F15","v":27870.320000000003},33725.870000000003,{"$nulls":7},1]
["SICRO","EC","SICRO","Encargos Complementares Adicionais","mês",{"$f":"SUM(F8:F10)","v":24},{"$f":"AVERAGE(P8:P10)","v":1142.2233333333331},1382.2044556666663,{"$f":"PFP3_FatorKd!$E$17","v":1.2101},27413.359999999993,33172.910000000003,{"$nulls":7},314]
["TOTAL DOS CUSTOS DIRETOS",{"$nulls":6},{"$f":"SUM(J8:J16)","v":280077.8867179376}]
["TOTAL DOS ENCARGOS E DESPESAS DIVERSAS",{"$nulls":6},{"$f":"H19-H17","v":197538.04481188062}]
["TOTAL DA PROPOSTA A PREÇO GLOBAL",{"$nulls":6},{"$f":"SUM(K8:K15,K16)","v":477615.93152981822}]
["TOTAL DA PROPOSTA",{"$nulls":6},{"$f":"H19","v":477615.93152981822},{"$nulls":7},{"$f":"H20/5900000","v":8.0951852801664101E-2}]
["OBSERVAÇÃO:"]
["*Encargos Complementares e adicionais já incluem auxílio transporte"]
["Alocar os Insumos MO, com respectivo FatorK, dentro da categoria de vínculo contratual (celetista, autonomo, societario)"]
["Uni - unidade de medição do insumo;"]
["Qde - Quantidade do Insumo (não pode ocorrer alteração pela Licitante)"]
["CUD - Custo Unitário Direto do Insumo (sem encargos, taxas e impostos, valor não pode ser maior que o Orçado pela Codevasf)"]
["CT - Custo Total (sem encargos, taxas e impostos) - CT = Qde x CUD"]
["FatorK - Taxa de Ressarcimento de Despesas e Encargos (detalhar composição nas Planilhas \"PFP2.1\", \"PFP2.2\", \"PFP3\")"]
["PU - Preço Unitário do Insumo (incluído encargos, taxas e impostos) - PU = CUD x FatorK"]
["PT - Preço Total do Insumo (incluído encargos, taxas e impostos) - PT = Qde x PU"]
["P - Profissionais nível superior nas áreas de Engenharia, Química, Arquitetura, Agronomia e Veterinária, conforme disposições da Lei 4.950-A/66"]
["S - Profissionais de nível superior nas demais áreas de atuação, incluindo Arqueólogo, Biólogo, Geógrafo e Sociólogo"]
["T - Profissionais de nível médio técnico nas diversas áreas de atuação"]
["A - Profissionais de nível médio de apoio técnico-administrativo"]
[]
["Observações: "]
["1- Sistemas oficiais de referência de preços utilizados"]
["Tabela Consultiva do DNIT-Out/2022."]
["SINAPI/GO - 11/2022"]

{"sheet":"PFP1.1Serv Graficos","index":1,"n_rows":42,"n_cols":9,"rows_kept":42,"cut":false,"hidden":true,"merged":[[27,0,27,3],[2,0,2,4],[14,0,14,4],[19,0,19,3],[21,1,21,2],[22,0,22,4],[37,0,37,4],[38,0,38,4],[39,0,39,4],[40,0,40,4],[41,0,41,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",2,null,"Preto",{"$f":"C17*E7","v":0}]
["Impressão preta",null,"SETOP/COMPOSIÇÃO","CO-2017",0.33,null,"Colorida",{"$f":"D17*E6","v":0}]
["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":27.2}]
["Encadernação até 100 fls.",null,"EMBASA/COMPOSIÇÃO","30.02.27",7.2]
["Impressão em A3",null,"SETOP/COMPOSIÇÃO","CO-2020 / CO-2018",{"$f":"(4.8+0.93)/2","v":2.8649999999999998},"Foi considerado o valor médio entre a impressão colorida e preta/branco",null,"1 Rel A3"]
["Impressão em A1",null,"-","-",{"$f":"2*E11","v":5.7299999999999995},"Foi considerado o dobro do valor da impressão A3","Impresão A3",{"$f":"B18*E11","v":0}]
["Impressão em A0",null,"-","-",{"$f":"2*E12","v":11.459999999999999},"Foi considerado o dobro do valor da impressão A1","Encader",{"$f":"E8","v":27.2}]
[{"$nulls":6},"Total",{"$f":"SUM(H12:H13)","v":27.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"]
[0,0,{"$f":"B17*0.9","v":0},{"$f":"B17*0.1","v":0},{"$f":"H9*A17","v":0},"Estimamos 90% do total de páginas de impressões pretas e 10% coloridas."]
["Peça Gráfica - Impressão em A3",0,null,null,{"$f":"ROUND(((B18*E11)+E8),2)","v":27.2}]
["Peça Gráfica - Impressão em A1",0,null,null,{"$f":"ROUND(((B19*E12)+E8),2)","v":27.2}]
["Custo Unitário Rel Final",null,null,null,{"$f":"SUM(E17:E19)","v":54.4}]
[]
[]
["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":"B25*0.9","v":315},{"$f":"B25*0.1","v":35},{"$f":"H9*A25","v":81.599999999999994}]
["Peça Gráfica - Impressão em A4",350,null,null,{"$f":"(E7*B26)+H8","v":142.69999999999999}]
[]
["Custo Unitário Rel Final",null,null,null,{"$f":"SUM(E25:E26)","v":224.29999999999998}]
[]
[]
["Descrição","Qtd Pág por Volume","Qtd Impressão Preta","Qtd Impressão Color","Custo Unitário Total"]
["Relatório Mensal",50,{"$f":"B32*0.9","v":45},{"$f":"B32*0.1","v":5},{"$f":"H36","v":30.85},"Estimamos a quantidade de página por volume.",null,"1 Rel Mensal","1 Rel Parcial"]
["Relatório Parcial",100,{"$f":"B33*0.9","v":90},{"$f":"B33*0.1","v":10},{"$f":"I36","v":56.900000000000006},"Estimamos a quantidade de página por volume.",null,{"$f":"C32*E7","v":14.850000000000001},{"$f":"C33*E7","v":29.700000000000003}]
["Minuta do Relatório Final",null,null,null,{"$f":"E28","v":224.29999999999998},null,null,{"$f":"D32*E6","v":10},{"$f":"D33*E6","v":20}]
["Relatório Final",null,null,null,{"$f":"E20","v":54.4},null,null,{"$f":"E9","v":6},{"$f":"E10","v":7.2}]
[{"$nulls":6},"Total",{"$f":"SUM(H33:H35)","v":30.85},{"$f":"SUM(I33:I35)","v":56.900000000000006}]
[]
["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."]
["2 - Relatório Parcial: Será considerado 01 Volumes com uma quantidade estimada de 100 páginas."]
["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."]
["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."]

{"sheet":"PFP1.2_Equi_div","index":2,"n_rows":11,"n_cols":7,"rows_kept":11,"cut":false,"hidden":false,"merged":[[10,0,10,5],[0,0,1,5],[2,0,2,6],[3,0,3,6],[4,0,4,3],[4,4,4,5],[5,0,5,3],[5,4,5,5]]}
["RECURSOS GERAIS",{"$nulls":5},"CODIGO:"]
[{"$nulls":6},"PFP1.2"]
["NOME DA EMPRESA:"]
[]
["PROJETO: ",null,null,null,"CONTRATANTE:",null,{"$f":"PFP!J5","v":"BASE:"}]
[{"$f":"PFP!A6","v":"CONTRATAÇÃO DOS SERVIÇOS DE APOIO À FISCALIZAÇÃO PARA EXECUÇÃO DAS OBRAS DE ENGENHARIA, VISANDO A IMPLANTAÇÃO DE PONTE EM CONCRETO ARMADO SOBRE O RIO MELCHIOR, NA REGIÃO ADMINISTRATIVA DA CEILÂNDIA, DISTRITO FEDERAL."},null,null,null,"CODEVASF (SEDE)",null,{"$f":"PFP!J6","v":"SICRO JAN/2025; SINAPI MAIO/2025; EMBASA JAN/2025; ORSE ABR/2025; SUDECAP JAN/2025.                            DATA-BASE ORÇAMENTO: JUN/2025"}]
["Cod.","Base","Insumos","Uni","Qde","Preço Unitário (PU)","Preço Total (PT)"]
["PROP","CODE","Aluguel de notebook","mês",{"$f":"8+8","v":16},{"$f":"'AUX - NOTEBOOK'!H10","v":92.05},{"$f":"E8*F8","v":1472.8}]
["PROP","CODE","Aluguel de impressora","mês",8,{"$f":"'AUX - IMPRESSORA'!H10","v":54.129999999999995},{"$f":"E9*F9","v":433.03999999999996}]
["PROP","CODE","Escritório","mês",8,{"$f":"'CPU ESCRIT. CONTAINER'!C14","v":3245.5600000000004},25964.480000000003]
["TOTAL",{"$nulls":5},{"$f":"SUM(G8:G10)","v":27870.320000000003}]

{"sheet":"PFP1.3_Ger","index":3,"n_rows":28,"n_cols":9,"rows_kept":28,"cut":false,"hidden":false,"merged":[[5,0,5,5],[5,6,5,7],[0,0,1,7],[2,0,2,8],[3,0,3,8],[4,0,4,3],[4,6,4,7]]}
["RECURSOS GERAIS",{"$nulls":7},"CODIGO:"]
[{"$nulls":8},"PFP1.3"]
["NOME DA EMPRESA:"]
[]
["PROJETO: ",{"$nulls":5},"CONTRATANTE:",null,{"$f":"[334]PFP!J5","v":"BASE:"}]
[{"$f":"PFP!A6","v":"CONTRATAÇÃO DOS SERVIÇOS DE APOIO À FISCALIZAÇÃO PARA EXECUÇÃO DAS OBRAS DE ENGENHARIA, VISANDO A IMPLANTAÇÃO DE PONTE EM CONCRETO ARMADO SOBRE O RIO MELCHIOR, NA REGIÃO ADMINISTRATIVA DA CEILÂNDIA, DISTRITO FEDERAL."},{"$nulls":5},"CODEVASF (SEDE)",null,{"$f":"PFP!J6","v":"SICRO JAN/2025; SINAPI MAIO/2025; EMBASA JAN/2025; ORSE ABR/2025; SUDECAP JAN/2025.                            DATA-BASE ORÇAMENTO: JUN/2025"}]
[]
["CODE 1",null,null,"DESCRIÇÃO","UNIDADE","QUANTIDADE","CUSTO UNITÁRIO","CUSTO TOTAL"]
["ORIGEM","CÓDIGO 1","CÓDIGO 2","RELATÓRIO SEMANAL DE OBRAS","[un]",1,null,"-"]
["SINAPI","MO1",2706,"Engenheiro Civil - Elaboração de Relatório Semanal de Obras","[h]",4,123.22,{"$f":"F10*G10","v":492.88},"mês"]
["DNIT","SU","B8953","Escritório - Mobiliário","dia",0.5,{"$f":"'C.G - DNIT'!G18/22","v":21.075454545454548},{"$f":"F11*G11","v":10.537727272727274},"dia"]
["DNIT","SU","B8959","Escritório - Custos Diversos","dia",0.5,{"$f":"'C.G - DNIT'!G25/22","v":6.1931818181818183},{"$f":"F12*G12","v":3.0965909090909092},"dia"]
[{"$nulls":7},{"$f":"SUM(H10:H12)","v":506.51431818181823}]
[]
[]
[]
["CODE 2",null,null,"DESCRIÇÃO","UNIDADE","QUANTIDADE","CUSTO UNITÁRIO","CUSTO TOTAL"]
["ORIGEM","CÓDIGO 1","CÓDIGO 2","RELATÓRIO DE AVALIAÇÃO DO PROJETO ","[un]",1,null,"-"]
["SINAPI","MO1",40811,"Engenheiro Civil - Avaliação do Projeto","[mês]",0.25,21959.61,{"$f":"G19*F19","v":5489.9025000000001},"mês"]
[{"$nulls":7},{"$f":"SUM(H19:H19)","v":5489.9025000000001}]
[]
[]
[]
["CODE 3",null,null,"DESCRIÇÃO","UNIDADE","QUANTIDADE","CUSTO UNITÁRIO","CUSTO TOTAL"]
["ORIGEM","CÓDIGO 1","CÓDIGO 2","LEVANTAMENTO TOPOGRÁFICO","[un]",1,null,"-"]
["DNIT","MO2","P8163","Topógrafo","[mês]",1,{"$f":"VLOOKUP(C26,'MDO -  DNIT'!$A:$Z,25,0)","v":5732.91},{"$f":"F26*G26","v":5732.91},"mês"]
["DNIT","MO2","P8028","Auxiliar","[mês]",1,{"$f":"VLOOKUP(C27,'MDO -  DNIT'!$A:$Z,25,0)","v":4206.32},{"$f":"F27*G27","v":4206.32},"mês"]
[{"$nulls":7},{"$f":"SUM(H26:H27)","v":9939.23}]

{"sheet":"PFP1.4_Ensaios_Solo_Concreto","index":4,"n_rows":25,"n_cols":13,"rows_kept":25,"cut":false,"hidden":true,"merged":[[24,10,24,11],[21,0,21,8],[5,0,5,4],[5,5,5,6],[18,0,18,6],[20,0,20,8],[19,0,19,8],[22,10,23,12],[22,0,22,8],[23,0,23,8],[0,0,1,6],[2,0,2,8],[3,0,3,8],[3,10,3,12],[4,0,4,4],[4,5,4,6]]}
["ENSAIOS DE SOLO E CONCRETO",{"$nulls":7},"CODIGO:"]
[{"$nulls":8},"PFP-1.4"]
["NOME DA EMPRESA:"]
[{"$nulls":10},"MEMÓRIA DE CALCULO DO BDI DE FORNECIMENTO"]
["PROJETO:",{"$nulls":4},"CONTRATANTE:",null,null,{"$f":"[335]PFP!K5","v":"BASE:"},null,"ITEM","DISCRIMINAÇÃO","PERC.    (%)"]
[{"$f":"PFP!A6","v":"CONTRATAÇÃO DOS SERVIÇOS DE APOIO À FISCALIZAÇÃO PARA EXECUÇÃO DAS OBRAS DE ENGENHARIA, VISANDO A IMPLANTAÇÃO DE PONTE EM CONCRETO ARMADO SOBRE O RIO MELCHIOR, NA REGIÃO ADMINISTRATIVA DA CEILÂNDIA, DISTRITO FEDERAL."},{"$nulls":4},{"$f":"PFP!F6","v":"CODEVASF (SEDE)"},null,null,{"$f":"PFP!J6","v":"SICRO JAN/2025; SINAPI MAIO/2025; EMBASA JAN/2025; ORSE ABR/2025; SUDECAP JAN/2025.                            DATA-BASE ORÇAMENTO: JUN/2025"}]
["Base","Cod.","Código","Insumos","Uni","Qde","Custo Unitário (CU)","Custo Total","Preço Total (PT)"]
["EMBASA","CODE","32.01.01","Sondagem A Trado Manual ","m",0,65,{"$f":"ROUND(F8*G8,2)","v":0},{"$f":"H8*(1+$M$25)","v":0},null,"1.00","Despesas Indiretas"]
["EMBASA","CODE","34.01.22","Ensaio de Umidade Natral (Estufa)","und",0,100,{"$f":"ROUND(F9*G9,2)","v":0},{"$f":"H9*(1+$M$25)","v":0},null,"A1","Seguro e Garantia",8.0000000000000002E-3]
["EMBASA","CODE","34.01.23","Ensaio de Umidade Natural \"Speed\"","und",0,85,0,0,null,"A2","Riscos e Imprevistos",1.15E-2]
["EMBASA","CODE","34.01.07","Deterimnação de Limite de Liquidez","und",0,190,0,0,null,"A3","Despesas Financeiras",1.0500000000000001E-2]
["EMBASA","CODE","34.01.10","Determinação de Limite de Plasticidade ","und",0,190,0,0,null,"A4","Administração Central",2.1999999999999999E-2]
["COMPESA","CODE","01.07.07U","Ensaio de Granulometria por Peneiramento e Sedimentação","und",0,138.12,0,0,null,"Total do Grupo A =",null,{"$f":"SUM(M9:M12)","v":5.1999999999999998E-2}]
["EMBASA","CODE","34.01.25","Ensaio de Compactação - Proctor Normal","und",0,300,0,0,null,"2.00","Benefício"]
["EMBASA","CODE","34.01.16","Massa Específica Real dos Grãos","und",0,65.78,0,0,null,"B1","LUCRO",0.05]
["EMBASA","CODE","34.05.19","Deteriminação da Massa Específica Aparente \"In Situ\", com Emprego do Cilindro de Cravação","und",0,157.86000000000001,0,0,null,"Total do Grupo B =",null,{"$f":"M15","v":0.05}]
["SUDECAP","CODE","98.04.09","Concreto - Extração e Rompimento de Corpo de Prova Cilindrico ","und",0,600,0,0,null,"3.00","Impostos"]
["SETOP","CODE","ED-49546","Concreto - Rompimento de Corpo de Prova Moldado in Loco no Recebimento","und",0,100.21,0,0,null,"C1","PIS / PASEP",6.4999999999999997E-3]
["TOTAL SERVIÇOS ENSAIOS",{"$nulls":7},{"$f":"SUM(I8:I18)","v":0},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(M18:M20)","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+M12+M9+M10)*(1+M11)*(1+M16))/(1-M21))-1","v":0.14692012195121973}]

{"sheet":"PFP2.1_FatorKa","index":5,"n_rows":41,"n_cols":6,"rows_kept":41,"cut":false,"hidden":false,"merged":[[35,1,35,3],[6,1,6,3],[40,0,40,5],[39,0,39,5],[38,0,38,5],[37,0,37,5],[22,1,22,3],[29,1,29,3],[30,1,30,3],[28,1,28,3],[25,1,25,3],[26,1,26,3],[27,1,27,3],[33,1,33,3],[31,1,31,3],[32,1,32,3],[34,1,34,3],[0,0,1,4],[2,0,2,5],[5,0,5,1],[5,2,5,4],[4,2,4,4],[3,0,3,5],[24,1,24,3],[7,1,7,3],[17,1,17,3],[8,1,8,3],[13,1,13,3],[14,1,14,3],[15,1,15,3],[18,1,18,3],[19,1,19,3],[20,1,20,3],[21,1,21,3],[23,1,23,3],[9,1,9,3],[10,1,10,3],[11,1,11,3],[12,1,12,3]]}
["DETALHAMENTO DOS ENCARGOS SOCIAIS: Ka",{"$nulls":4},"CODIGO:"]
[{"$nulls":5},"PFP-2.1"]
["NOME DA CONSULTORA:"]
[]
["PROJETO:",null,"CONTRATANTE:",null,null,{"$f":"PFP!J5","v":"BASE:"}]
[{"$f":"PFP!A6","v":"CONTRATAÇÃO DOS SERVIÇOS DE APOIO À FISCALIZAÇÃO PARA EXECUÇÃO DAS OBRAS DE ENGENHARIA, VISANDO A IMPLANTAÇÃO DE PONTE EM CONCRETO ARMADO SOBRE O RIO MELCHIOR, NA REGIÃO ADMINISTRATIVA DA CEILÂNDIA, DISTRITO FEDERAL."},null,"CODEVASF (SEDE)",null,null,"SINAPI/DF"]
["Cod","DESCRIÇÃO",null,null,"%","R$"]
["A","ENCARGOS SOCIAIS BÁSICOS",null,null,{"$f":"ROUND(SUM(E9:E17),4)","v":0.378},{"$f":"ROUND(E8*SUMIF(PFP!$B$8:$B$13,\"MO1\",PFP!$J$8:$J$13),2)","v":56124.84}]
["A1","INSS",null,null,0.2,{"$f":"ROUND(E9*SUMIF(PFP!$B$8:$B$13,\"MO1\",PFP!$J$8:$J$13),2)","v":29695.68}]
["A2","SESI",null,null,1.4999999999999999E-2,{"$f":"ROUND(E10*SUMIF(PFP!$B$8:$B$13,\"MO1\",PFP!$J$8:$J$13),2)","v":2227.1799999999998}]
["A3","SENAI",null,null,0.01,{"$f":"ROUND(E11*SUMIF(PFP!$B$8:$B$13,\"MO1\",PFP!$J$8:$J$13),2)","v":1484.78}]
["A4","INCRA",null,null,2E-3,{"$f":"ROUND(E12*SUMIF(PFP!$B$8:$B$13,\"MO1\",PFP!$J$8:$J$13),2)","v":296.95999999999998}]
["A5","SEBRAE",null,null,6.0000000000000001E-3,{"$f":"ROUND(E13*SUMIF(PFP!$B$8:$B$13,\"MO1\",PFP!$J$8:$J$13),2)","v":890.87}]
["A6","Salário Educação",null,null,2.5000000000000001E-2,{"$f":"ROUND(E14*SUMIF(PFP!$B$8:$B$13,\"MO1\",PFP!$J$8:$J$13),2)","v":3711.96}]
["A7","Seguro Contra Acidentes de Trabalho",null,null,0.03,{"$f":"ROUND(E15*SUMIF(PFP!$B$8:$B$13,\"MO1\",PFP!$J$8:$J$13),2)","v":4454.3500000000004}]
["A8","FGTS",null,null,0.08,{"$f":"ROUND(E16*SUMIF(PFP!$B$8:$B$13,\"MO1\",PFP!$J$8:$J$13),2)","v":11878.27}]
["A9","SECONCI",null,null,0.01,{"$f":"ROUND(E17*SUMIF(PFP!$B$8:$B$13,\"MO1\",PFP!$J$8:$J$13),2)","v":1484.78}]
["B"," ENCARGOS SOCIAIS QUE RECEBEM INCIDÊNCIA DE \"A\"",null,null,{"$f":"ROUND(SUM(E19:E25),4)","v":0.15790000000000001},{"$f":"ROUND(E18*SUMIF(PFP!$B$8:$B$13,\"MO1\",PFP!$J$8:$J$13),2)","v":23444.74}]
["B3","Auxílio Enfermidade",null,null,6.4999999999999997E-3,{"$f":"ROUND(E19*SUMIF(PFP!$B$8:$B$13,\"MO1\",PFP!$J$8:$J$13),2)","v":965.11}]
["B4","13º Salário",null,null,8.3299999999999999E-2,{"$f":"ROUND(E20*SUMIF(PFP!$B$8:$B$13,\"MO1\",PFP!$J$8:$J$13),2)","v":12368.25}]
["B5","Licença Paternidade",null,null,5.0000000000000001E-4,{"$f":"ROUND(E21*SUMIF(PFP!$B$8:$B$13,\"MO1\",PFP!$J$8:$J$13),2)","v":74.239999999999995}]
["B6","Faltas Justificadas",null,null,5.5999999999999999E-3,{"$f":"ROUND(E22*SUMIF(PFP!$B$8:$B$13,\"MO1\",PFP!$J$8:$J$13),2)","v":831.48}]
["B8","Auxílio Acidente de Trabalho",null,null,6.9999999999999999E-4,{"$f":"ROUND(E23*SUMIF(PFP!$B$8:$B$13,\"MO1\",PFP!$J$8:$J$13),2)","v":103.93}]
["B9","Férias Gozadas",null,null,6.0999999999999999E-2,{"$f":"ROUND(E24*SUMIF(PFP!$B$8:$B$13,\"MO1\",PFP!$J$8:$J$13),2)","v":9057.18}]
["B10","Salário Maternidade",null,null,2.9999999999999997E-4,{"$f":"ROUND(E25*SUMIF(PFP!$B$8:$B$13,\"MO1\",PFP!$J$8:$J$13),2)","v":44.54}]
["C"," ENCARGOS SOCIAIS QUE NÃO RECEBEM INCIDÊNCIA DE \"A\"",null,null,{"$f":"ROUND(SUM(E27:E31),4)","v":0.10340000000000001},{"$f":"ROUND(E26*SUMIF(PFP!$B$8:$B$13,\"MO1\",PFP!$J$8:$J$13),2)","v":15352.67}]
["C1","Aviso Prévio Indenizado",null,null,3.2399999999999998E-2,{"$f":"ROUND(E27*SUMIF(PFP!$B$8:$B$13,\"MO1\",PFP!$J$8:$J$13),2)","v":4810.7}]
["C2","Aviso Prévio Trabalhado",null,null,8.0000000000000004E-4,{"$f":"ROUND(E28*SUMIF(PFP!$B$8:$B$13,\"MO1\",PFP!$J$8:$J$13),2)","v":118.78}]
["C3","Férias Indenizadas",null,null,4.1700000000000001E-2,{"$f":"ROUND(E29*SUMIF(PFP!$B$8:$B$13,\"MO1\",PFP!$J$8:$J$13),2)","v":6191.55}]
["C4","Depósito Rescisão Sem Justa Causa",null,null,2.58E-2,{"$f":"ROUND(E30*SUMIF(PFP!$B$8:$B$13,\"MO1\",PFP!$J$8:$J$13),2)","v":3830.74}]
["C5","Indenização Adicional",null,null,2.7000000000000001E-3,{"$f":"ROUND(E31*SUMIF(PFP!$B$8:$B$13,\"MO1\",PFP!$J$8:$J$13),2)","v":400.89}]
["D"," REINCIDÊNCIAS",null,null,{"$f":"ROUND(SUM(E33:E34),4)","v":6.2600000000000003E-2},{"$f":"ROUND(E32*SUMIF(PFP!$B$8:$B$13,\"MO1\",PFP!$J$8:$J$13),2)","v":9294.75}]
["D1","Reincidência de \"A\" sobre \"B\"",null,null,5.9700000000000003E-2,{"$f":"ROUND(E33*SUMIF(PFP!$B$8:$B$13,\"MO1\",PFP!$J$8:$J$13),2)","v":8864.16}]
["D2","Reincidência de \"A\" sobre Aviso Prévio Trabalhado e reincidência do FGTS sobre Aviso Prévio Indenizado",null,null,2.8999999999999998E-3,{"$f":"ROUND(E34*SUMIF(PFP!$B$8:$B$13,\"MO1\",PFP!$J$8:$J$13),2)","v":430.59}]
["K1a","ENCARGOS SOCIAIS",null,null,{"$f":"ROUND(E8+E18+E26+E32,4)","v":0.70189999999999997},{"$f":"ROUND(E35*SUMIF(PFP!$B$8:$B$13,\"MO1\",PFP!$J$8:$J$13),2)","v":104216.99}]
["Ka","TAXA DE RESSARCIMENTO DE DESPESAS E ENCARGOS SOBRE MO1",null,null,{"$f":"ROUND((1+E35+[336]PFP3_FatorKd!E13)*(1+[336]PFP3_FatorKd!E12)*(1+[336]PFP3_FatorKd!E8),4)","v":2.1442000000000001}]
["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":6,"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":"CONTRATAÇÃO DOS SERVIÇOS DE APOIO À FISCALIZAÇÃO PARA EXECUÇÃO DAS OBRAS DE ENGENHARIA, VISANDO A IMPLANTAÇÃO DE PONTE EM CONCRETO ARMADO SOBRE O RIO MELCHIOR, NA REGIÃO ADMINISTRATIVA DA CEILÂNDIA, DISTRITO FEDERAL."},null,"CODEVASF (SEDE)",null,null,{"$f":"'PFP2.1_FatorKa'!F6","v":"SINAPI/DF"}]
["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$13,\"MO2\",PFP!$J$8:$J$13),2)","v":0}]
["A1","INSS",null,null,0.2,{"$f":"ROUND(E9*SUMIF(PFP!$B$8:$B$13,\"MO2\",PFP!$J$8:$J$13),2)","v":0}]
["A2","SESI",null,null,0,{"$f":"ROUND(E10*SUMIF(PFP!$B$8:$B$13,\"MO2\",PFP!$J$8:$J$13),2)","v":0}]
["A3","SENAI",null,null,0,{"$f":"ROUND(E11*SUMIF(PFP!$B$8:$B$13,\"MO2\",PFP!$J$8:$J$13),2)","v":0}]
["A4","INCRA",null,null,0,{"$f":"ROUND(E12*SUMIF(PFP!$B$8:$B$13,\"MO2\",PFP!$J$8:$J$13),2)","v":0}]
["A5","SEBRAE",null,null,0,{"$f":"ROUND(E13*SUMIF(PFP!$B$8:$B$13,\"MO2\",PFP!$J$8:$J$13),2)","v":0}]
["A6","Salário Educação",null,null,0,{"$f":"ROUND(E14*SUMIF(PFP!$B$8:$B$13,\"MO2\",PFP!$J$8:$J$13),2)","v":0}]
["A7","Seguro Contra Acidentes de Trabalho",null,null,0,{"$f":"ROUND(E15*SUMIF(PFP!$B$8:$B$13,\"MO2\",PFP!$J$8:$J$13),2)","v":0}]
["A8","FGTS",null,null,0,{"$f":"ROUND(E16*SUMIF(PFP!$B$8:$B$13,\"MO2\",PFP!$J$8:$J$13),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$13,\"MO2\",PFP!$J$8:$J$13),2)","v":0}]
["B3","Auxílio Enfermidade",null,null,0,{"$f":"ROUND(E18*SUMIF(PFP!$B$8:$B$13,\"MO2\",PFP!$J$8:$J$13),2)","v":0}]
["B4","13º Salário",null,null,0,{"$f":"ROUND(E19*SUMIF(PFP!$B$8:$B$13,\"MO2\",PFP!$J$8:$J$13),2)","v":0}]
["B5","Licença Paternidade",null,null,0,{"$f":"ROUND(E20*SUMIF(PFP!$B$8:$B$13,\"MO2\",PFP!$J$8:$J$13),2)","v":0}]
["B6","Faltas Justificadas",null,null,0,{"$f":"ROUND(E21*SUMIF(PFP!$B$8:$B$13,\"MO2\",PFP!$J$8:$J$13),2)","v":0}]
["B8","Auxílio Acidente de Trabalho",null,null,0,{"$f":"ROUND(E22*SUMIF(PFP!$B$8:$B$13,\"MO2\",PFP!$J$8:$J$13),2)","v":0}]
["B9","Férias Gozadas",null,null,0,{"$f":"ROUND(E23*SUMIF(PFP!$B$8:$B$13,\"MO2\",PFP!$J$8:$J$13),2)","v":0}]
["B10","Salário Maternidade",null,null,0,{"$f":"ROUND(E24*SUMIF(PFP!$B$8:$B$13,\"MO2\",PFP!$J$8:$J$13),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$13,\"MO2\",PFP!$J$8:$J$13),2)","v":0}]
["C1","Aviso Prévio Indenizado",null,null,0,{"$f":"ROUND(E26*SUMIF(PFP!$B$8:$B$13,\"MO2\",PFP!$J$8:$J$13),2)","v":0}]
["C2","Aviso Prévio Trabalhado",null,null,0,{"$f":"ROUND(E27*SUMIF(PFP!$B$8:$B$13,\"MO2\",PFP!$J$8:$J$13),2)","v":0}]
["C3","Férias Indenizadas",null,null,0,{"$f":"ROUND(E28*SUMIF(PFP!$B$8:$B$13,\"MO2\",PFP!$J$8:$J$13),2)","v":0}]
["C4","Depósito Rescisão Sem Justa Causa",null,null,0,{"$f":"ROUND(E29*SUMIF(PFP!$B$8:$B$13,\"MO2\",PFP!$J$8:$J$13),2)","v":0}]
["C5","Indenização Adicional",null,null,0,{"$f":"ROUND(E30*SUMIF(PFP!$B$8:$B$13,\"MO2\",PFP!$J$8:$J$13),2)","v":0}]
["D"," REINCIDÊNCIAS",null,null,{"$f":"ROUND(SUM(E32:E33),4)","v":0},{"$f":"ROUND(E31*SUMIF(PFP!$B$8:$B$13,\"MO2\",PFP!$J$8:$J$13),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$13,\"MO2\",PFP!$J$8:$J$13),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$13,\"MO2\",PFP!$J$8:$J$13),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$13,\"MO2\",PFP!$J$8:$J$13),2)","v":0}]
["Kb","TAXA DE RESSARCIMENTO DE DESPESAS E ENCARGOS SOBRE MO2",null,null,{"$f":"ROUND((1+E34+PFP3_FatorKd!E13)*(1+PFP3_FatorKd!E12)*(1+PFP3_FatorKd!E8),4)","v":1.5246999999999999}]
["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":7,"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":"CONTRATAÇÃO DOS SERVIÇOS DE APOIO À FISCALIZAÇÃO PARA EXECUÇÃO DAS OBRAS DE ENGENHARIA, VISANDO A IMPLANTAÇÃO DE PONTE EM CONCRETO ARMADO SOBRE O RIO MELCHIOR, NA REGIÃO ADMINISTRATIVA DA CEILÂNDIA, DISTRITO FEDERAL."},null,"CODEVASF (SEDE)",null,null,{"$f":"'PFP2.2_FatorKb'!F6","v":"SINAPI/DF"}]
["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$13,\"MO3\",PFP!$J$8:$J$13),2)","v":0}]
["A1","INSS",null,null,0,{"$f":"ROUND(E9*SUMIF(PFP!$B$8:$B$13,\"MO3\",PFP!$J$8:$J$13),2)","v":0}]
["A2","SESI",null,null,0,{"$f":"ROUND(E10*SUMIF(PFP!$B$8:$B$13,\"MO3\",PFP!$J$8:$J$13),2)","v":0}]
["A3","SENAI",null,null,0,{"$f":"ROUND(E11*SUMIF(PFP!$B$8:$B$13,\"MO3\",PFP!$J$8:$J$13),2)","v":0}]
["A4","INCRA",null,null,0,{"$f":"ROUND(E12*SUMIF(PFP!$B$8:$B$13,\"MO3\",PFP!$J$8:$J$13),2)","v":0}]
["A5","SEBRAE",null,null,0,{"$f":"ROUND(E13*SUMIF(PFP!$B$8:$B$13,\"MO3\",PFP!$J$8:$J$13),2)","v":0}]
["A6","Salário Educação",null,null,0,{"$f":"ROUND(E14*SUMIF(PFP!$B$8:$B$13,\"MO3\",PFP!$J$8:$J$13),2)","v":0}]
["A7","Seguro Contra Acidentes de Trabalho",null,null,0,{"$f":"ROUND(E15*SUMIF(PFP!$B$8:$B$13,\"MO3\",PFP!$J$8:$J$13),2)","v":0}]
["A8","FGTS",null,null,0,{"$f":"ROUND(E16*SUMIF(PFP!$B$8:$B$13,\"MO3\",PFP!$J$8:$J$13),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$13,\"MO3\",PFP!$J$8:$J$13),2)","v":0}]
["B3","Auxílio Enfermidade",null,null,0,{"$f":"ROUND(E18*SUMIF(PFP!$B$8:$B$13,\"MO3\",PFP!$J$8:$J$13),2)","v":0}]
["B4","13º Salário",null,null,0,{"$f":"ROUND(E19*SUMIF(PFP!$B$8:$B$13,\"MO3\",PFP!$J$8:$J$13),2)","v":0}]
["B5","Licença Paternidade",null,null,0,{"$f":"ROUND(E20*SUMIF(PFP!$B$8:$B$13,\"MO3\",PFP!$J$8:$J$13),2)","v":0}]
["B6","Faltas Justificadas",null,null,0,{"$f":"ROUND(E21*SUMIF(PFP!$B$8:$B$13,\"MO3\",PFP!$J$8:$J$13),2)","v":0}]
["B8","Auxílio Acidente de Trabalho",null,null,0,{"$f":"ROUND(E22*SUMIF(PFP!$B$8:$B$13,\"MO3\",PFP!$J$8:$J$13),2)","v":0}]
["B9","Férias Gozadas",null,null,0,{"$f":"ROUND(E23*SUMIF(PFP!$B$8:$B$13,\"MO3\",PFP!$J$8:$J$13),2)","v":0}]
["B10","Salário Maternidade",null,null,0,{"$f":"ROUND(E24*SUMIF(PFP!$B$8:$B$13,\"MO3\",PFP!$J$8:$J$13),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$13,\"MO3\",PFP!$J$8:$J$13),2)","v":0}]
["C1","Aviso Prévio Indenizado",null,null,0,{"$f":"ROUND(E26*SUMIF(PFP!$B$8:$B$13,\"MO3\",PFP!$J$8:$J$13),2)","v":0}]
["C2","Aviso Prévio Trabalhado",null,null,0,{"$f":"ROUND(E27*SUMIF(PFP!$B$8:$B$13,\"MO3\",PFP!$J$8:$J$13),2)","v":0}]
["C3","Férias Indenizadas",null,null,0,{"$f":"ROUND(E28*SUMIF(PFP!$B$8:$B$13,\"MO3\",PFP!$J$8:$J$13),2)","v":0}]
["C4","Depósito Rescisão Sem Justa Causa",null,null,0,{"$f":"ROUND(E29*SUMIF(PFP!$B$8:$B$13,\"MO3\",PFP!$J$8:$J$13),2)","v":0}]
["C5","Indenização Adicional",null,null,0,{"$f":"ROUND(E30*SUMIF(PFP!$B$8:$B$13,\"MO3\",PFP!$J$8:$J$13),2)","v":0}]
["D"," REINCIDÊNCIAS",null,null,{"$f":"ROUND(SUM(E32:E33),4)","v":0},{"$f":"ROUND(E31*SUMIF(PFP!$B$8:$B$13,\"MO3\",PFP!$J$8:$J$13),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$13,\"MO3\",PFP!$J$8:$J$13),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$13,\"MO3\",PFP!$J$8:$J$13),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$13,\"MO3\",PFP!$J$8:$J$13),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.2827}]
["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":8,"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: Kd",{"$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":"CONTRATAÇÃO DOS SERVIÇOS DE APOIO À FISCALIZAÇÃO PARA EXECUÇÃO DAS OBRAS DE ENGENHARIA, VISANDO A IMPLANTAÇÃO DE PONTE EM CONCRETO ARMADO SOBRE O RIO MELCHIOR, NA REGIÃO ADMINISTRATIVA DA CEILÂNDIA, DISTRITO FEDERAL."},null,"CODEVASF (SEDE)",null,null,{"$f":"'PFP2.3_FatorKc'!F6","v":"SINAPI/DF"}]
["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$13,\"MO1\",PFP!$J$8:$J$13)*(1+'PFP2.1_FatorKa'!$E$35)+SUMIF(PFP!$B$8:$B$13,\"MO2\",PFP!$J$8:$J$13)*(1+'PFP2.2_FatorKb'!$E$34)+SUMIF(PFP!$B$8:$B$13,\"<>MO*\",PFP!$J$8:$J$13)+$F$13+$F$12)","v":46486.440364438342}]
["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$13,\"MO1\",PFP!$J$8:$J$13)*(1+'PFP2.1_FatorKa'!$E$35)+SUMIF(PFP!$B$8:$B$13,\"MO2\",PFP!$J$8:$J$13)*(1+'PFP2.2_FatorKb'!$E$34)+SUMIF(PFP!$B$8:$B$13,\"<>MO*\",PFP!$J$8:$J$13)+$F$13+$F$12)","v":18745.591418145686}]
["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$13,\"MO1\",PFP!$J$8:$J$13)*(1+'PFP2.1_FatorKa'!$E$35)+SUMIF(PFP!$B$8:$B$13,\"MO2\",PFP!$J$8:$J$13)*(1+'PFP2.2_FatorKb'!$E$34)+SUMIF(PFP!$B$8:$B$13,\"<>MO*\",PFP!$J$8:$J$13)+$F$13+$F$12)","v":4957.2404625919417}]
["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$13,\"MO1\",PFP!$J$8:$J$13)*(1+'PFP2.1_FatorKa'!$E$35)+SUMIF(PFP!$B$8:$B$13,\"MO2\",PFP!$J$8:$J$13)*(1+'PFP2.2_FatorKb'!$E$34)+SUMIF(PFP!$B$8:$B$13,\"<>MO*\",PFP!$J$8:$J$13)+$F$13+$F$12)","v":22783.608483700715}]
["K3","REMUNERAÇÃO DA EMPRESA (LUCRO)",null,null,0.06,{"$f":"E12*SUM(SUMIF(PFP!$B$8:$B$13,\"MO1\",PFP!$J$8:$J$13)*(1+'PFP2.1_FatorKa'!$E$35)+SUMIF(PFP!$B$8:$B$13,\"MO2\",PFP!$J$8:$J$13)*(1+'PFP2.2_FatorKb'!$E$34)+SUMIF(PFP!$B$8:$B$13,\"<>MO*\",PFP!$J$8:$J$13)+$F$13)","v":18582.68322850909}]
["K2","CUSTOS DA ADMINISTRAÇÃO CENTRAL",null,null,{"$f":"ROUND(SUM(E14:E16),4)","v":0.06},{"$f":"ROUND(E13*SUMIF(PFP!$B$8:$B$13,\"MO*\",PFP!$J$8:$J$13),2)","v":8908.7000000000007}]
["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.03,{"$f":"ROUND(E14*SUMIF(PFP!$B$8:$B$13,\"MO*\",PFP!$J$8:$J$13),2)","v":4454.3500000000004}]
["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$13,\"MO*\",PFP!$J$8:$J$13),2)","v":2969.57}]
["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$13,\"MO*\",PFP!$J$8:$J$13),2)","v":1484.78}]
["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":"Cronograma Físico-Financeiro","index":9,"n_rows":29,"n_cols":12,"rows_kept":29,"cut":false,"hidden":false,"merged":[[20,2,21,2],[18,1,19,1],[18,2,19,2],[27,1,28,2],[12,1,13,1],[14,2,15,2],[16,2,17,2],[14,1,15,1],[12,2,13,2],[25,2,26,2],[23,1,24,2],[16,1,17,1],[20,1,21,1],[4,1,5,1],[4,2,5,2],[6,1,7,1],[6,2,7,2],[10,2,11,2],[10,1,11,1],[8,1,9,1],[8,2,9,2]]}
[null,"CRONOGRAMA FÍSICO-FINANCEIRO"]
[]
[]
[null,null,null,"Mês 1","Mês 2","Mês 3","Mês 4","Mês 5","Mês 6","Mês 7","Mês 8"]
[null,{"$f":"PFP!D8","v":"Engenheiro Júnior"},{"$f":"PFP!K8","v":221332.9},{"$f":"D6*$C$5","v":27666.612499999999},{"$f":"E6*$C$5","v":27666.612499999999},{"$f":"F6*$C$5","v":27666.612499999999},27666.612499999999,{"$f":"H6*$C$5","v":27666.612499999999},{"$f":"I6*$C$5","v":27666.612499999999},27666.612499999999,27666.612499999999,{"$f":"SUM(D5:K5)","v":221332.89999999997}]
[null,null,null,{"$f":"1/8","v":0.125},{"$f":"1/8","v":0.125},0.125,0.125,0.125,0.125,0.125,0.125,1]
[null,{"$f":"PFP!D9","v":"Técnico - Profissional Especial"},{"$f":"PFP!K9","v":55627.24},{"$f":"D8*$C$7","v":6953.4049999999997},{"$f":"E8*$C$7","v":6953.4049999999997},6953.4049999999997,6953.4049999999997,6953.4049999999997,6953.4049999999997,6953.4049999999997,6953.4049999999997,55627.24]
[null,null,null,{"$f":"1/8","v":0.125},{"$f":"1/8","v":0.125},0.125,0.125,0.125,0.125,0.125,0.125,1]
[null,{"$f":"PFP!D10","v":"Técnico Auxiliar (Laboratorista)"},{"$f":"PFP!K10","v":41407.25},{"$f":"D10*$C$9","v":5175.90625},{"$f":"E10*$C$9","v":5175.90625},5175.90625,5175.90625,5175.90625,5175.90625,5175.90625,5175.90625,41407.25]
[null,null,null,0.125,0.125,0.125,0.125,0.125,0.125,0.125,0.125,1]
[null,{"$f":"PFP!D11","v":"Relatório Semanal de Obras"},{"$f":"PFP!K11","v":19613.855245818184},{"$f":"D12*$C$11","v":2451.731905727273},{"$f":"E12*$C$11","v":2451.731905727273},2451.731905727273,2451.731905727273,2451.731905727273,2451.731905727273,2451.731905727273,2451.731905727273,19613.855245818184]
[null,null,null,0.125,0.125,0.125,0.125,0.125,0.125,0.125,0.125,1]
[null,{"$f":"PFP!D12","v":"Consultoria de Interpretação de Projeto para Execução"},{"$f":"PFP!K12","v":26573.324060999999},{"$f":"D14*$C$13","v":3321.6655076249999},{"$f":"E14*$C$13","v":3321.6655076249999},3321.6655076249999,3321.6655076249999,3321.6655076249999,3321.6655076249999,3321.6655076249999,3321.6655076249999,26573.324060999996]
[null,null,null,{"$f":"1/8","v":0.125},{"$f":"1/8","v":0.125},0.125,0.125,0.125,0.125,0.125,0.125,1]
[null,{"$f":"PFP!D13","v":"Levantamento Topográfico"},{"$f":"PFP!K13","v":12027.462222999999},{"$f":"D16*$C$15","v":1503.4327778749998},{"$f":"E16*$C$15","v":1503.4327778749998},1503.4327778749998,1503.4327778749998,1503.4327778749998,1503.4327778749998,1503.4327778749998,1503.4327778749998,12027.462222999997]
[null,null,null,0.125,0.125,0.125,0.125,0.125,0.125,0.125,0.125,1]
[null,{"$f":"PFP!D14","v":"Veículo leve - 71 a 115 CV"},{"$f":"PFP!K14","v":34135.120000000003},{"$f":"D18*$C$17","v":4266.8900000000003},{"$f":"E18*$C$17","v":4266.8900000000003},4266.8900000000003,4266.8900000000003,4266.8900000000003,4266.8900000000003,4266.8900000000003,4266.8900000000003,34135.120000000003]
[null,null,null,0.125,0.125,0.125,0.125,0.125,0.125,0.125,0.125,1]
[null,{"$f":"PFP!D15","v":"Infraestrutura e Equipamentos de Escritório"},{"$f":"PFP!K15","v":33725.870000000003},{"$f":"D20*$C$19","v":4215.7337500000003},{"$f":"E20*$C$19","v":4215.7337500000003},4215.7337500000003,4215.7337500000003,4215.7337500000003,4215.7337500000003,4215.7337500000003,4215.7337500000003,33725.870000000003]
[null,null,null,0.125,0.125,0.125,0.125,0.125,0.125,0.125,0.125,1]
[null,{"$f":"PFP!D16","v":"Encargos Complementares Adicionais"},{"$f":"PFP!K16","v":33172.910000000003},{"$f":"D22*$C$21","v":4146.6137500000004},4146.6137500000004,4146.6137500000004,4146.6137500000004,4146.6137500000004,4146.6137500000004,4146.6137500000004,4146.6137500000004,33172.910000000003]
[null,null,null,0.125,0.125,0.125,0.125,0.125,0.125,0.125,0.125,1]
[]
[null,"NO MÊS",null,{"$f":"D5+D7+D9+D11+D13+D15+D17+D21+D19","v":59701.991441227277},{"$f":"E5+E7+E9+E11+E13+E15+E17+E21+E19","v":59701.991441227277},59701.991441227277,59701.991441227277,59701.991441227277,59701.991441227277,59701.991441227277,59701.991441227277,{"$f":"SUM(D24:K24)","v":477615.93152981816}]
[null,null,null,{"$f":"D24/SUM($C$5:$C$22)","v":0.125},0.125,0.125,0.125,0.125,0.125,0.125,0.125,{"$f":"SUM(D25:K25)","v":1}]
[null,null,"DESEMBOLSO   (80% do Subproduto) ",{"$f":"D24*0.8","v":47761.593152981826},{"$f":"E24*0.8","v":47761.593152981826},47761.593152981826,47761.593152981826,47761.593152981826,47761.593152981826,47761.593152981826,{"$f":"L24-SUM(D26:J26)","v":143284.77945894538},{"$f":"SUM(D26:K26)","v":477615.93152981816}]
[null,null,null,{"$f":"D26/SUM($C$5:$C$22)","v":0.1},0.1,0.1,0.1,0.1,0.1,0.1,0.29999999999999982,{"$f":"SUM(D27:K27)","v":0.99999999999999978}]
[null,"ACUMULADO",null,{"$f":"D24","v":59701.991441227277},{"$f":"D28+E24","v":119403.98288245455},179105.97432368185,238807.96576490911,{"$f":"G28+H24","v":298509.95720613637},{"$f":"H28+I24","v":358211.94864736364},{"$f":"I28+J24","v":417913.9400885909},{"$f":"J28+K24","v":477615.93152981816}]
[null,null,null,{"$f":"D25","v":0.125},0.25,0.375,0.5,0.625,0.75,0.875,1]

{"sheet":"CPU-VEICULO_PickUp","index":10,"n_rows":61,"n_cols":33,"rows_kept":61,"cut":false,"hidden":true,"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:","2025-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.4618047486117282E-2},{"$f":"AVERAGE(E10:H10)","v":200477},{"$f":"MEDIAN(E10:H10)","v":205565.5},null,null,null,{"$f":"_xlfn.STDEV.S(L9:S9)/AVERAGE(L9:S9)","v":0.20491936834598948},{"$f":"AVERAGE(L9:S9)","v":34.548571428571428},{"$f":"MEDIAN(L9:S9)","v":30.91},{"$nulls":8},{"$f":"_xlfn.STDEV.S(W9:AD9)/AVERAGE(W9:AD9)","v":0.12410235614319021},{"$f":"AVERAGE(W9:AD9)","v":499.01906250000008},{"$f":"MEDIAN(W9:AD9)","v":499.45}]
["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.91},33.33,26.9,30.9,30.9,30.91,46,42.9,null,null,"Pneu 225/65 R17",{"$f":"SMALL(W7:X7,1)","v":499.01906250000008},499,479.9,565.25,393.38,449.9,{"$f":"2059.44/4","v":514.86},{"$f":"2359.85/4","v":589.96249999999998},499.9]
[null,"Custo Mensal (R$):",{"$f":"C51","v":3838.4196060633808},null,215525,175252,196485,214646]
[null,"Custo Diária (R$):",{"$f":"C10/22","v":174.4736184574264}]
[null,"Custo Horário (R$):",{"$f":"C10/176","v":21.8092023071783}]
["A","Depreciação mensal do equipamento"]
["A1","Preço de Aquisição ",{"$f":"SMALL(F7:G7,1)","v":200477}]
["A2","Tempo previsto de vida útil (meses)",36]
["A3","Previsão de recup. Na venda do bem usado",0.7]
["A4","Custo mensal [A1-(A3xA1)]/A2",{"$f":"(C14-(C16*C14))/C15","v":1670.6416666666669}]
["B","Juros pelo Capital empregado"]
["B1","Taxa mensal de Juros *",{"$f":"POWER(1+C56,1/12)-1","v":1.0348528288471437E-2}]
["B2","Juros s/depreciação/aluguel (B1xA4)",{"$f":"C19*C17","v":17.28868254739907}]
["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",6.1]
["C2","Incidência mensal (C1xA4)",{"$f":"C22*C17","v":1252.9812500000003},{"$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":"60*22","v":1320}]
["D2","Preço do litro de combustível",{"$f":"AG22","v":6.1}]
["D3","Quilômetros rodados com um litro combustivel",10]
["D4","Combustivel    (D1/D3)*D2",{"$f":"(C25/C27)*C26","v":805.19999999999993}]
["E","Lubrificantes"]
["E1","Quilometragem do Contrato (D1*12)",{"$f":"C25*36","v":47520}]
["E2","Franquia por troca de óleo (km)",10000]
["E3","Preço do litro de óleo",{"$f":"K9","v":30.91}]
["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":20.121139726027398}]
["F","Pneus"]
["F1","Quilometragem do Contrato ",{"$f":"C30","v":47520}]
["F2","Vida do Pneu em quilômetros",45000]
["F3","Quantidade de pneus",5]
["F4","Preço do Pneu",{"$f":"V9","v":499.01906250000008}]
["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":72.186867123287684}]
["G","Motorista"]
["G1","Salário com encargos sociais",0]
["H","Custo Mensal"," "]
[null,"Sem Motorista (A4+B2+C2+D4+E6+F6)",{"$f":"C17+C20+C23+C28+C35+C42","v":3838.4196060633808}]
[null,"Com Motorista (A4+B2+C2+D4+E6+F6+G1)",{"$f":"C17+C20+C23+C28+C35+C42+C44","v":3838.4196060633808}]
["I","Custo Direto p/ km Rodado"]
[null,"Sem Motorista",{"$f":"C46/C25","v":2.9078936409571066}]
[null,"Com Motorista",{"$f":"C47/C25","v":2.9078936409571066}]
["J","Preço cobrado sem BDI",{"$f":"C46*(1+C8)","v":3838.4196060633808}]
["J1","Sem Motorista",{"$f":"C51","v":3838.4196060633808}]
["J2","Com Motorista",{"$f":"C47","v":3838.4196060633808},{"$nulls":5},"https://www.google.com/search?q=lubrificante+5w30+1l&sa=X&sca_esv=c77f5342bf7e367a&tbm=shop&ei=e0uKZ-DcDNKp5OUPkOKj6QY&ved=0ahUKEwighoOy3_yKAxXSFLkGHRDxKG0Q4dUDCAg&uact=5&oq=lubrificante+5w30+1l&gs_lp=Egtwcm9kdWN0cy1jYyIUbHVicmlmaWNhbnRlIDV3MzAgMWxIgQ9Q4AlY8Q1wAHgAkAEAmAFroAGgA6oBAzEuM7gBA8gBAPgBAZgCAqAC0gHCAgUQABiABMICBhAAGAcYHsICBhAAGAgYHsICBhAAGBYYHpgDAIgGAZIHAzEuMaAHxQU&sclient=products-cc",{"$nulls":10},"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/2025:",0.13150000000000001]
[null," Taxa de Juros Selic — Português (Brasil) (www.gov.br) "]
["**","Conservação e manutenção - é calculado com o uso de um coeficiente multiplicador \"k\", conforme tabela abaixo, sobre a "]
[null,"depreciação mensal do equipamento (Item A da planilha de composição de preços). Os valores de K são fornecidos por"]
[null," fabricantes. "]
[null,"Metodologia conforme a bibliografia \"Como Preparar Orçamentos de Obras\", 3 edição, Aldo Dórea Mattos, 2019."]

{"sheet":"CPU-VEICULO_Leve","index":11,"n_rows":84,"n_cols":33,"rows_kept":84,"cut":false,"hidden":false,"merged":[[49,21,49,28],[1,0,1,3],[3,0,3,3],[4,0,4,2],[4,5,4,8],[5,0,5,3],[49,9,49,20]]}
[]
["Composição de Preços de Locação de Veículos"]
[null,"2023-08-23","Data de atualização:","2025-01-22",null,"CV","Média","Mediana",null,null,null,"CV","Média","Mediana",{"$nulls":9},"CV","Média","Mediana"]
["CODEVASF ",{"$nulls":4},{"$f":"_xlfn.STDEV.S(F7:I7)/AVERAGE(F7:I7)","v":0.1466333998024873},{"$f":"AVERAGE(F7:I7)","v":75224.5},{"$f":"MEDIAN(F7:I7)","v":74407.5},null,null,null,{"$f":"_xlfn.STDEV.S(M6:U6)/AVERAGE(M6:U6)","v":0.15722347279585167},{"$f":"AVERAGE(M6:U6)","v":26.768888888888892},{"$f":"MEDIAN(M6:U6)","v":27.12},{"$nulls":9},{"$f":"_xlfn.STDEV.S(Y6:AG6)/AVERAGE(Y6:AG6)","v":0.16218949848342898},{"$f":"AVERAGE(Y6:AG6)","v":329.14444444444445},{"$f":"MEDIAN(Y6:AG6)","v":334.75}]
["OBS:               Preço sem BDI e sem motorista                                                           BDI=",{"$nulls":4},"Preço FIPE",{"$nulls":4},"PRODUTO","MENOR","COT. 1","COT. 2","COT. 3","COT. 4","COT. 5","COT. 6","COT. 7","COT. 8","COT. 9",null,"PRODUTO ","MENOR","COT. 1","COT. 2","COT. 3","COT. 4","COT. 5","COT. 6","COT. 7","COT. 8","COT. 9"]
["Veículo Leve 1.0 T. Flex 12V 5p",{"$nulls":4},"Renault Kwid Zen 1.0","Hyndai HB20 Sense 1.0 ","ONIX HATCH LT 1.0 12V Flex 5p Mec.","MOBI TREKKING 1.0 Flex 5p.",null,"LUBRIFICANTE 15W40",{"$f":"SMALL(M4:N4,1)","v":26.768888888888892},27.12,19.010000000000002,28.9,23.9,28.76,33.9,29.44,24.9,24.99,null,"Pneu 185/65 R14",{"$f":"SMALL(Y4:Z4,1)","v":329.14444444444445},289.89999999999998,{"$f":"1255.8/4","v":313.95},289,{"$f":"1339/4","v":334.75},{"$f":"1519.6/4","v":379.9},231,364.9,{"$f":"718/2","v":359},{"$f":"799.8/2","v":399.9}]
[null,null,"Custo Mensal (R$):",{"$f":"D48","v":1763.0317835074602},null,63868,80150,88215,68665,null,null,""]
[null,null,"Custo Diário (R$):",{"$f":"D7/30","v":58.767726116915341}]
[null,null,"Custo Horário (R$):",{"$f":"D7/176","v":10.017226042656024}]
["A",null,"Depreciação mensal do equipamento"]
["A1",null,"Preço de Aquisição ",{"$f":"SMALL(G4:H4,1)","v":74407.5}]
["A2",null,"Tempo previsto de vida útil (meses)",36]
["A3",null,"Previsão de recup. Na venda do bem usado",0.7]
["A4",null,"Custo mensal [A1-(A3xA1)]/A2",{"$f":"(D11-(D13*D11))/D12","v":620.0625}]
["B",null,"Juros pelo Capital empregado"]
["B1",null,"Taxa mensal de Juros *",{"$f":"POWER(1+D53,1/12)-1","v":1.1163421416801933E-2}]
["B2",null,"Juros s/depreciação/aluguel (B1xA4)",{"$f":"D16*D14","v":6.9220189922557482}]
["C",null,"Conservação e manutenção **",0.75]
["C1",null,"Taxa de gastos s/a deprec. Inc. seguros (%)",{"$f":"D18","v":0.75}]
["C2",null,"Incidência mensal (C1xA4)",{"$f":"D19*D14","v":465.046875}]
["D",null,"Combustível"]
["D1",null,"Média mensal de quilômetro por veículo",{"$f":"60*22","v":1320}]
["D2",null,"Preço do litro de combustível",{"$f":"G82","v":6.51}]
["D3",null,"Quilômetros rodados com um litro combustivel",{"$f":"(12.8+13.3+15.3+15)/4","v":14.100000000000001}]
["D4",null,"Combustivel    (D1/D3)*D2",{"$f":"(D22/D24)*D23","v":609.44680851063822}]
["E",null,"Lubrificantes"]
["E1",null,"Quilometragem do Contrato (D1*12)",{"$f":"D22*36","v":47520}]
["E2",null,"Franquia por troca de óleo (km)",10000]
["E3",null,"Preço do litro de óleo",{"$f":"L6","v":26.768888888888892}]
["E4",null,"Quantidade de litros de óleo por troca",4]
["E5",null,"Quantidade de dias do Contrato",{"$f":"365*3","v":1095}]
["E6",null,"Lubrificantes  E = (E1*E3*E4*30)/E2*E5",{"$f":"(D27*D29*D30*30)/(D28*D31)","v":13.940357260273972}]
["F",null,"Pneus"]
["F1",null,"Quilometragem do Contrato ",{"$f":"D27","v":47520}]
["F2",null,"Vida do Pneu em quilômetros",45000]
["F3",null,"Quantidade de pneus",5]
["F4",null,"Preço do Pneu",{"$f":"X6","v":329.14444444444445}]
["F5",null,"Quantidade de dias do contrato ",{"$f":"D31","v":1095}]
["F6",null,"Pneus = (F1*F3*F4*30)/(F2*F5)",{"$f":"(D34*D36*D37*30)/(D35*D38)","v":47.613223744292235}]
["G",null,"Motorista"]
["G1",null,"Salário com encargos sociais",0]
["H",null,"Custo Mensal"," ",{"$nulls":6},"https://www.google.com/search?q=lubrificante+15w40+1l&sa=X&biw=1600&bih=757&tbm=shop&sxsrf=AJOqlzUezMM_9i0M4NKjKqAMycLuOygp_g%3A1677158931166&ei=E2r3Y5e2CcH31sQPsK67CA&ved=0ahUKEwjXi8vy36v9AhXBu5UCHTDXDgEQ4dUDCAg&uact=5&oq=lubrificante+15w40+1l&gs_lcp=Cgtwcm9kdWN0cy1jYxADMgsIABAWEB4Q8QQQGDoICAAQgAQQsAM6CQgAEAcQHhCwAzoJCAAQCBAeELADOgkIABAeELADEBg6DggAEAUQHhDxBBCwAxAYOgUIABCABDoGCAAQFhAeOggIABAWEB4QGEoECEEYAVDeBFi3DWD0D2gBcAB4AIABpQWIAZAIkgEHMy0xLjAuMZgBAKABAcgBCsABAQ&sclient=products-cc"]
[null,null,"Sem Motorista (A4+B2+C2+D4+E6+F6)",{"$f":"D14+D17+D20+D25+D32+D39","v":1763.0317835074602}]
[null,null,"Com Motorista (A4+B2+C2+D4+E6+F6+G1)",{"$f":"D14+D17+D20+D25+D32+D39+D41","v":1763.0317835074602}]
["I",null,"Custo Direto p/ km Rodado"]
[null,null,"Sem Motorista",{"$f":"D43/D22","v":1.3356301390208032},{"$nulls":17},"https://www.google.com/search?q=Pneu+185%2F65+R14&sa=X&hl=pt-BR&biw=1600&bih=757&tbm=shop&sxsrf=AJOqlzVJW-LYM1ZPHImwhsD-4UwyAvTluQ%3A1677158863331&ei=z2n3Y-uxE-zT1sQP0r-OmAs&ved=0ahUKEwir1Z7S36v9AhXsqZUCHdKfA7MQ4dUDCAg&uact=5&oq=Pneu+185%2F65+R14&gs_lcp=Cgtwcm9kdWN0cy1jYxADMgsIABCABBCxAxCDATIFCAAQgAQyBQgAEIAEMgUIABCABDIFCAAQgAQyBQgAEIAEMgUIABCABDIFCAAQgAQyBQgAEIAEMgUIABCABEoECEEYAFD5A1jGCWC1EGgAcAB4AIABrQmIAdcbkgEHNS0yLjAuMpgBAKABAcABAQ&sclient=products-cc"]
[null,null,"Com Motorista",{"$f":"D44/D22","v":1.3356301390208032}]
["J",null,"Preço cobrado sem BDI",{"$f":"D43*(1+D5)","v":1763.0317835074602}]
["J1",null,"Sem Motorista",{"$f":"D48","v":1763.0317835074602}]
["J2",null,"Com Motorista",{"$f":"D44","v":1763.0317835074602}]
[]
[]
["*",null,"Calculado com base na taxa SELIC JANEIRO/2025:",0.14249999999999999]
[]
["**",null,"Conservação e manutenção - é calculado com o uso de um coeficiente multiplicador \"k\", conforme tabela abaixo, sobre a "]
[null,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,null," fabricantes. "]
[null,null,"Metodologia conforme a bibliografia \"Como Preparar Orçamentos de Obras\", 3 edição, Aldo Dórea Mattos, 2019."]
{"$rows_empty":23}
[{"$nulls":5},"PREÇO DA GASOLINA",6.51]
[]
[{"$nulls":5},"https://precos.petrobras.com.br/w/gasolina/df"]

{"sheet":"CPU HOSPEDAGEM","index":12,"n_rows":19,"n_cols":4,"rows_kept":19,"cut":false,"hidden":true,"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 insumo"]
[null,"Aquisição de Mobiliário",{"$f":"42.41*C16","v":169.64},"B8954/DNIT"]
[null,"Material de limpeza e diarista",{"$f":"130.82+(123*8)","v":1114.82},"10563/ORSE - E200300131/EMBASA"]
[null,"manutenção da casa alugada - Serviços Gerais/Vigia ",2716.19,"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,"Custo Mensal:",{"$f":"SUM(C4:C12)","v":8022.2966666666653}]
[null,"Custo Mensal por pessoa:",{"$f":"C13/C16","v":2005.5741666666663}]
[null,"Custo diário por pessoa:",{"$f":"C14/22","v":91.162462121212101}]
[null,"número de pessoas:",4]
[null,"Alimentação:",100.59,"Tabela Diária Codevasf 2024"]
[]
[null,"Diária Total (alimentação + hospedagem):",{"$f":"C15+C17","v":191.75246212121209}]

{"sheet":"CPU ESCRIT. CONTAINER","index":13,"n_rows":17,"n_cols":5,"rows_kept":17,"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 CONTAINER ESCRITÓRIO C/ BANHEIRO",{"$f":"1600","v":1600},"4298/ORSE"]
[null,"Aquisição de Mobiliário",{"$f":"'AUX - MOBILIÁRIO'!F10","v":149.11000000000001},"CODE","cotação"]
[null,"Material de limpeza e diarista",{"$f":"129.46+(123*4)","v":621.46},"10563/ORSE - E200300131/EMBASA"]
[null,"Energia ",180,"10555/ORSE"]
[null,"Mobilização e Desmobilização",{"$f":"1200*2/8","v":300},"89.50.20/89.50.21/SUDECAP-MG"]
[null,"Água",394.99,"10554/ORSE"]
[]
[]
[]
[]
[null,"Custo Mensal:",{"$f":"SUM(C4:C13)","v":3245.5600000000004}]
[null,"Custo Mensal por pessoa:",{"$f":"C14/C17","v":1081.8533333333335}]
[null,"Custo diário por pessoa:",{"$f":"C15/22","v":49.175151515151519}]
[null,"número de pessoas:",3]

{"sheet":"MDO -  DNIT","index":14,"n_rows":105,"n_cols":26,"rows_kept":105,"cut":false,"hidden":false,"merged":[[1,20,1,21],[0,16,0,21],[0,22,1,23],[0,24,1,24],[1,6,1,7],[1,8,1,9],[1,10,1,11],[1,12,1,13],[1,14,1,15],[1,16,1,17],[1,18,1,19],[0,6,0,15],[0,0,2,0],[0,1,2,1],[0,2,2,2],[0,3,1,3],[0,4,1,5]]}
["Código","Categoria","Unid.","Salário","Encargos Sociais",null,"Encargos Complementares",{"$nulls":9},"Encargos Adicionais",{"$nulls":5},"Encargos Totais",null,"Valor Total"]
[{"$nulls":6},"Alimentação",null,"EPI",null,"Ferramenta",null,"Transporte",null,"Exame Ocupacional",null,"Cesta Básica",null,"Assistência Médica",null,"Seguro de Vida"]
[null,null,null,"R$","%","R$","%","R$","%","R$","%","R$","%","R$","%","R$","%","R$","%","R$","%","R$","%","R$","R$"]
["Profissionais mensalistas"]
["P8001","Advogado júnior","mês",4915.72,0.79300000000000004,3898.16,0.14990000000000001,736.74,5.4999999999999997E-3,26.96,0,0,0,0,5.9999999999999995E-4,2.86,0,0,6.3E-2,309.62,2E-3,9.98,1.014,4984.34,9900.0499999999993,{"$f":"Y5-F5-D5","v":1086.1699999999992}]
["P8002","Advogado pleno","mês",6554.29,0.79300000000000004,5197.55,0.1124,736.74,4.1000000000000003E-3,26.96,0,0,0,0,4.0000000000000002E-4,2.86,0,0,4.7199999999999999E-2,309.62,1.5E-3,9.98,0.9587,6283.72,12838.01,{"$f":"Y6-F6-D6","v":1086.17}]
["P8003","Advogado sênior","mês",12196.82,0.79300000000000004,9672.08,6.0400000000000002E-2,736.74,2.2000000000000001E-3,26.96,0,0,0,0,2.0000000000000001E-4,2.86,0,0,2.5399999999999999E-2,309.62,8.0000000000000004E-4,9.98,0.8821,10758.25,22955.07,1086.17]
["P8007","Analista de desenvolvimento de sistemas júnior","mês",4417.8100000000004,0.79590000000000005,3516.13,0.1668,736.74,0,0,0,0,0,0,8.0000000000000004E-4,3.5,0,0,7.0099999999999996E-2,309.62,2.3E-3,9.98,1.0358000000000001,4575.97,8993.7800000000007,1059.8400000000001]
["P8008","Analista de desenvolvimento de sistemas pleno","mês",5699.98,0.79590000000000005,4536.6099999999997,0.1293,736.74,0,0,0,0,0,0,5.9999999999999995E-4,3.5,0,0,5.4300000000000001E-2,309.62,1.8E-3,9.98,0.98180000000000001,5596.45,11296.43,1059.8400000000011]
["P8009","Analista de desenvolvimento de sistemas sênior","mês",10119.99,0.79590000000000005,8054.5,7.2800000000000004E-2,736.74,0,0,0,0,0,0,2.9999999999999997E-4,3.5,0,0,3.0599999999999999E-2,309.62,1E-3,9.98,0.90059999999999996,9114.34,19234.34,1059.8500000000004]
["P8013","Arquiteto júnior","mês",12903,0.79300000000000004,10232.08,5.7099999999999998E-2,736.74,2.0999999999999999E-3,26.96,0,0,0,0,2.0000000000000001E-4,2.73,0,0,2.4E-2,309.62,8.0000000000000004E-4,9.98,0.87719999999999998,11318.12,24221.119999999999,1086.0399999999991]
["P8014","Arquiteto pleno","mês",13128.58,0.79300000000000004,10410.969999999999,5.6099999999999997E-2,736.74,2.0999999999999999E-3,26.96,0,0,0,0,2.0000000000000001E-4,2.73,0,0,2.3599999999999999E-2,309.62,8.0000000000000004E-4,9.98,0.87570000000000003,11497.01,24625.59,1086.0400000000009]
["P8015","Arquiteto sênior","mês",15998.46,0.79300000000000004,12686.78,4.6100000000000002E-2,736.74,1.6999999999999999E-3,26.96,0,0,0,0,2.0000000000000001E-4,2.73,0,0,1.9400000000000001E-2,309.62,5.9999999999999995E-4,9.98,0.8609,13772.82,29771.29,1086.0500000000029]
["P8019","Assistente social júnior","mês",3294.18,0.80049999999999999,2636.99,0.22370000000000001,736.74,8.2000000000000007E-3,26.96,0,0,1.5599999999999999E-2,51.25,1.1999999999999999E-3,4.1100000000000003,0,0,9.4E-2,309.62,3.0000000000000001E-3,9.98,1.1462000000000001,3775.66,7069.84,1138.6700000000005]
["P8020","Assistente social pleno","mês",4392.24,0.80049999999999999,3515.99,0.16769999999999999,736.74,6.1000000000000004E-3,26.96,0,0,0,0,8.9999999999999998E-4,4.1100000000000003,0,0,7.0499999999999993E-2,309.62,2.3E-3,9.98,1.0481,4603.41,8995.65,1087.42]
["P8021","Assistente social sênior","mês",7474.93,0.80049999999999999,5983.68,9.8599999999999993E-2,736.74,3.5999999999999999E-3,26.96,0,0,0,0,5.9999999999999995E-4,4.1100000000000003,0,0,4.1399999999999999E-2,309.62,1.2999999999999999E-3,9.98,0.94599999999999995,7071.1,14546.04,1087.4300000000003]
["P8025","Auxiliar","mês",1639.47,0.81720000000000004,1339.78,0.44940000000000002,736.74,0.02,32.83,1E-3,1.68,9.1800000000000007E-2,150.53,3.8E-3,6.15,0,0,0.18890000000000001,309.62,6.1000000000000004E-3,9.98,1.5781000000000001,2587.3200000000002,4226.79,1247.5400000000002]
["P8026","Auxiliar administrativo","mês",1914.95,0.80200000000000005,1535.79,0.38469999999999999,736.74,0,0,0,0,7.0000000000000007E-2,134,2E-3,3.75,0,0,0.16170000000000001,309.62,5.1999999999999998E-3,9.98,1.4256,2729.89,4644.83,1194.0899999999999]
["P8027","Auxiliar de laboratório","mês",1810.44,0.80369999999999997,1455.05,0.40689999999999998,736.74,1.8100000000000002E-2,32.83,1.9E-3,3.47,7.7499999999999999E-2,140.27000000000001,2.3E-3,4.09,0,0,0.17100000000000001,309.62,5.4999999999999997E-3,9.98,1.4870000000000001,2692.05,4502.4799999999996,1236.9899999999993]
["P8028","Auxiliar de topografia","mês",1639.47,0.80589999999999995,1321.25,0.44940000000000002,736.74,0.02,32.83,8.9999999999999998E-4,1.46,9.1800000000000007E-2,150.53,2.7000000000000001E-3,4.42,0,0,0.18890000000000001,309.62,6.1000000000000004E-3,9.98,1.5657000000000001,2566.84,4206.32,1245.5999999999997]
["P8032","Biólogo júnior","mês",3221.45,0.79690000000000005,2567.17,0.22869999999999999,736.74,8.3999999999999995E-3,26.96,0,0,1.7299999999999999E-2,55.61,1.1000000000000001E-3,3.69,0,0,9.6100000000000005E-2,309.62,3.0999999999999999E-3,9.98,1.1516,3709.78,6931.23,1142.6099999999997]
["P8033","Biólogo pleno","mês",4295.2700000000004,0.79690000000000005,3422.9,0.17150000000000001,736.74,6.3E-3,26.96,0,0,0,0,8.9999999999999998E-4,3.69,0,0,7.2099999999999997E-2,309.62,2.3E-3,9.98,1.05,4509.8900000000003,8805.16,1086.9899999999998]
["P8034","Biólogo sênior","mês",7705.82,0.79690000000000005,6140.77,9.5600000000000004E-2,736.74,3.5000000000000001E-3,26.96,0,0,0,0,5.0000000000000001E-4,3.69,0,0,4.02E-2,309.62,1.2999999999999999E-3,9.98,0.93799999999999994,7227.76,14933.58,1086.9899999999998]
["P8038","Chefe de escritório","mês",3631.5,0.79410000000000003,2883.77,0.2029,736.74,0,0,0,0,8.5000000000000006E-3,31.01,8.0000000000000004E-4,2.98,0,0,8.5300000000000001E-2,309.62,2.7000000000000001E-3,9.98,1.0943000000000001,3974.11,7605.6,1090.33]
["P8040","Contador júnior","mês",4212.83,0.7944,3346.67,0.1749,736.74,0,0,0,0,0,0,6.9999999999999999E-4,2.79,0,0,7.3499999999999996E-2,309.62,2.3999999999999998E-3,9.98,1.0458000000000001,4405.8,8618.6299999999992,1059.1299999999992]
["P8041","Contador pleno","mês",5617.1,0.7944,4462.2299999999996,0.13120000000000001,736.74,0,0,0,0,0,0,5.0000000000000001E-4,2.79,0,0,5.5100000000000003E-2,309.62,1.8E-3,9.98,0.98299999999999998,5521.36,11138.46,1059.1299999999992]
["P8042","Contador sênior","mês",10692.34,0.7944,8494,6.8900000000000003E-2,736.74,0,0,0,0,0,0,2.9999999999999997E-4,2.79,0,0,2.9000000000000001E-2,309.62,8.9999999999999998E-4,9.98,0.89349999999999996,9553.1200000000008,20245.46,1059.119999999999]
["P8044","Coordenador ambiental","mês",18439.32,0.79820000000000002,14718.27,0.04,736.74,1.2999999999999999E-3,24.63,0,0,0,0,2.0000000000000001E-4,4.07,0,0,1.6799999999999999E-2,309.62,5.0000000000000001E-4,9.98,0.85699999999999998,15803.31,34242.629999999997,1085.0399999999972]
["P8045","Economista júnior","mês",4867.04,0.78600000000000003,3825.49,0.15140000000000001,736.74,0,0,0,0,0,0,4.0000000000000002E-4,1.87,0,0,6.3600000000000004E-2,309.62,2.0999999999999999E-3,9.98,1.0034000000000001,4883.71,9750.74,1058.21]
["P8046","Economista pleno","mês",6489.38,0.78600000000000003,5100.6499999999996,0.1135,736.74,0,0,0,0,0,0,2.9999999999999997E-4,1.87,0,0,4.7699999999999999E-2,309.62,1.5E-3,9.98,0.94910000000000005,6158.87,12648.25,1058.2200000000003]
["P8047","Economista sênior","mês",9957.27,0.78600000000000003,7826.41,7.3999999999999996E-2,736.74,0,0,0,0,0,0,2.0000000000000001E-4,1.87,0,0,3.1099999999999999E-2,309.62,1E-3,9.98,0.89229999999999998,8884.6299999999992,18841.900000000001,1058.2200000000012]
["P8054","Engenheiro agrônomo júnior","mês",12903,0.79249999999999998,10225.629999999999,5.7099999999999998E-2,736.74,2.0999999999999999E-3,26.96,0,0,0,0,2.0000000000000001E-4,3.08,0,0,2.4E-2,309.62,8.0000000000000004E-4,9.98,0.87670000000000003,11312.01,24215.01,1086.3799999999992]
["P8055","Engenheiro agrônomo pleno","mês",13536,0.79249999999999998,10727.28,5.4399999999999997E-2,736.74,2E-3,26.96,0,0,0,0,2.0000000000000001E-4,3.08,0,0,2.29E-2,309.62,6.9999999999999999E-4,9.98,0.87280000000000002,11813.67,25349.67,1086.3899999999976]
["P8056","Engenheiro agrônomo sênior","mês",14169,0.79249999999999998,11228.93,5.1999999999999998E-2,736.74,1.9E-3,26.96,0,0,0,0,2.0000000000000001E-4,3.08,0,0,2.1899999999999999E-2,309.62,6.9999999999999999E-4,9.98,0.86919999999999997,12315.32,26484.32,1086.3899999999994]
["P8057","Engenheiro ambiental júnior","mês",12903,0.80159999999999998,10343.040000000001,5.7099999999999998E-2,736.74,2.0999999999999999E-3,26.96,0,0,0,0,4.0000000000000002E-4,4.7,0,0,2.4E-2,309.62,8.0000000000000004E-4,9.98,0.88590000000000002,11431.05,24334.05,1088.0099999999984]
["P8058","Engenheiro ambiental pleno","mês",14000.63,0.80159999999999998,11222.91,5.2600000000000001E-2,736.74,1.9E-3,26.96,0,0,0,0,2.9999999999999997E-4,4.7,0,0,2.2100000000000002E-2,309.62,6.9999999999999999E-4,9.98,0.87929999999999997,12310.92,26311.55,1088.0100000000002]
["P8059","Engenheiro ambiental sênior","mês",15098.27,0.80159999999999998,12102.77,4.8800000000000003E-2,736.74,1.8E-3,26.96,0,0,0,0,2.9999999999999997E-4,4.7,0,0,2.0500000000000001E-2,309.62,6.9999999999999999E-4,9.98,0.87370000000000003,13190.78,28289.05,1088.0099999999984]
["P8060","Engenheiro consultor especial","mês",22395.59,0.79730000000000001,17856,3.2899999999999999E-2,736.74,1.1000000000000001E-3,24.63,0,0,0,0,2.0000000000000001E-4,3.91,0,0,1.38E-2,309.62,4.0000000000000002E-4,9.98,0.84570000000000001,18940.89,41336.480000000003,1084.8900000000031]
["P8061","Engenheiro coordenador","mês",18662.990000000002,0.79730000000000001,14880,3.95E-2,736.74,1.2999999999999999E-3,24.63,0,0,0,0,2.0000000000000001E-4,3.91,0,0,1.66E-2,309.62,5.0000000000000001E-4,9.98,0.85540000000000005,15964.89,34627.879999999997,1084.8899999999958]
["P8062","Engenheiro de pesca júnior","mês",12903,0.80130000000000001,10339.17,5.7099999999999998E-2,736.74,2.0999999999999999E-3,26.96,0,0,0,0,2.9999999999999997E-4,3.61,0,0,2.4E-2,309.62,8.0000000000000004E-4,9.98,0.88549999999999995,11426.09,24329.09,1086.92]
["P8063","Engenheiro de pesca pleno","mês",14139.75,0.80130000000000001,11330.18,5.21E-2,736.74,1.9E-3,26.96,0,0,0,0,2.9999999999999997E-4,3.61,0,0,2.1899999999999999E-2,309.62,6.9999999999999999E-4,9.98,0.87819999999999998,12417.1,26556.85,1086.9199999999983]
["P8064","Engenheiro de pesca sênior","mês",15376.5,0.80130000000000001,12321.19,4.7899999999999998E-2,736.74,1.8E-3,26.96,0,0,0,0,2.0000000000000001E-4,3.61,0,0,2.01E-2,309.62,5.9999999999999995E-4,9.98,0.872,13408.11,28784.61,1086.9199999999983]
["P8065","Engenheiro de projetos júnior","mês",12903,0.79730000000000001,10287.56,5.7099999999999998E-2,736.74,2.0999999999999999E-3,26.96,0,0,0,0,2.9999999999999997E-4,3.91,0,0,2.4E-2,309.62,8.0000000000000004E-4,9.98,0.88160000000000005,11374.78,24277.78,{"$f":"Y43-F43-D43","v":1087.2199999999993}]
["P8066","Engenheiro de projetos pleno","mês",13163.74,0.79730000000000001,10495.45,5.6000000000000001E-2,736.74,2E-3,26.96,0,0,0,0,2.9999999999999997E-4,3.91,0,0,2.35E-2,309.62,8.0000000000000004E-4,9.98,0.87990000000000002,11582.67,24746.41,{"$f":"Y44-F44-D44","v":1087.2199999999993}]
["P8067","Engenheiro de projetos sênior","mês",16396.560000000001,0.79730000000000001,13072.98,4.4900000000000002E-2,736.74,1.6000000000000001E-3,26.96,0,0,0,0,2.0000000000000001E-4,3.91,0,0,1.89E-2,309.62,5.9999999999999995E-4,9.98,0.86360000000000003,14160.2,30556.77,{"$f":"Y45-F45-D45","v":1087.2299999999996}]
["P8068","Engenheiro florestal júnior","mês",12903,0.80130000000000001,10339.17,5.7099999999999998E-2,736.74,2.0999999999999999E-3,26.96,0,0,0,0,2.9999999999999997E-4,3.61,0,0,2.4E-2,309.62,8.0000000000000004E-4,9.98,0.88549999999999995,11426.09,24329.09,1086.92]
["P8069","Engenheiro florestal pleno","mês",14139.75,0.80130000000000001,11330.18,5.21E-2,736.74,1.9E-3,26.96,0,0,0,0,2.9999999999999997E-4,3.61,0,0,2.1899999999999999E-2,309.62,6.9999999999999999E-4,9.98,0.87819999999999998,12417.1,26556.85,1086.9199999999983]
["P8070","Engenheiro florestal sênior","mês",15376.5,0.80130000000000001,12321.19,4.7899999999999998E-2,736.74,1.8E-3,26.96,0,0,0,0,2.0000000000000001E-4,3.61,0,0,2.01E-2,309.62,5.9999999999999995E-4,9.98,0.872,13408.11,28784.61,1086.9199999999983]
["P8080","Geólogo júnior","mês",12903,0.80089999999999995,10334.01,5.5E-2,709.66,2.0999999999999999E-3,26.96,0,0,0,0,2.9999999999999997E-4,3.55,0,0,2.4E-2,309.62,8.0000000000000004E-4,9.98,0.88300000000000001,11393.79,24296.79,1059.7800000000007]
["P8081","Geólogo pleno","mês",13467.8,0.80089999999999995,10786.36,5.2699999999999997E-2,709.66,2E-3,26.96,0,0,0,0,2.9999999999999997E-4,3.55,0,0,2.3E-2,309.62,6.9999999999999999E-4,9.98,0.87960000000000005,11846.14,25313.93,1059.7700000000004]
["P8082","Geólogo sênior","mês",14032.59,0.80089999999999995,11238.7,5.0599999999999999E-2,709.66,1.9E-3,26.96,0,0,0,0,2.9999999999999997E-4,3.55,0,0,2.2100000000000002E-2,309.62,6.9999999999999999E-4,9.98,0.87639999999999996,12298.48,26331.08,1059.7900000000009]
["P8092","Jornalista júnior","mês",3219.33,0.79559999999999997,2561.3000000000002,0.2288,736.74,8.3999999999999995E-3,26.96,0,0,1.7299999999999999E-2,55.74,8.0000000000000004E-4,2.66,0,0,9.6199999999999994E-2,309.62,3.0999999999999999E-3,9.98,1.1501999999999999,3703.01,6922.35,1141.7200000000003]
["P8093","Jornalista pleno","mês",4292.4399999999996,0.79559999999999997,3415.07,0.1716,736.74,6.3E-3,26.96,0,0,0,0,5.9999999999999995E-4,2.66,0,0,7.2099999999999997E-2,309.62,2.3E-3,9.98,1.0486,4501.04,8793.48,1085.9700000000003]
["P8094","Jornalista sênior","mês",8187.79,0.79559999999999997,6514.21,0.09,736.74,3.3E-3,26.96,0,0,0,0,2.9999999999999997E-4,2.66,0,0,3.78E-2,309.62,1.1999999999999999E-3,9.98,0.92820000000000003,7600.18,15787.98,1085.9800000000005]
["P8098","Laboratorista","mês",2413.91,0.80369999999999997,1940.06,0.30520000000000003,736.74,1.2500000000000001E-2,30.23,0,0,4.3099999999999999E-2,104.07,1.6999999999999999E-3,4.09,0,0,0.1283,309.62,4.1000000000000003E-3,9.98,1.2986,3134.79,5548.7,1194.73]
["P8102","Médico veterinário","mês",12903,0.79010000000000002,10194.66,5.7099999999999998E-2,736.74,2.0999999999999999E-3,26.96,0,0,0,0,2.0000000000000001E-4,2.62,0,0,2.4E-2,309.62,8.0000000000000004E-4,9.98,0.87429999999999997,11280.59,24183.59,1085.9300000000003]
["P8106","Meteorologista júnior","mês",5313.76,0.79759999999999998,4238.26,0.1386,736.74,5.1000000000000004E-3,26.96,0,0,0,0,8.0000000000000004E-4,4.16,0,0,5.8299999999999998E-2,309.62,1.9E-3,9.98,1.0023,5325.72,10639.48,1087.4599999999991]
["P8107","Meteorologista pleno","mês",7085.02,0.79759999999999998,5651.01,0.104,736.74,3.8E-3,26.96,0,0,0,0,5.9999999999999995E-4,4.16,0,0,4.3700000000000003E-2,309.62,1.4E-3,9.98,0.95109999999999995,6738.47,13823.49,1087.4599999999991]
["P8108","Meteorologista sênior","mês",11703,0.79759999999999998,9334.31,6.3E-2,736.74,2.3E-3,26.96,0,0,0,0,4.0000000000000002E-4,4.16,0,0,2.6499999999999999E-2,309.62,8.9999999999999998E-4,9.98,0.89049999999999996,10421.780000000001,22124.77,1087.4600000000009]
["P8112","Motorista de caminhão","mês",2427.21,0.80559999999999998,1955.36,0.30349999999999999,736.74,1.35E-2,32.83,0,0,4.2500000000000003E-2,103.27,1.8E-3,4.2699999999999996,0,0,0.12759999999999999,309.62,4.1000000000000003E-3,9.98,1.2986,3152.07,5579.28,1196.71]
["P8113","Motorista de veículo leve","mês",2131.79,0.80120000000000002,1707.99,0.34560000000000002,736.74,1.54E-2,32.83,0,0,5.6800000000000003E-2,120.99,1.8E-3,3.85,0,0,0.1452,309.62,4.7000000000000002E-3,9.98,1.3707,2922,5053.79,1214.0100000000002]
["P8117","Oceanógrafo júnior","mês",4704.63,0.80130000000000001,3769.82,0.15659999999999999,736.74,5.7000000000000002E-3,26.96,0,0,0,0,6.9999999999999999E-4,3.5,0,0,6.5799999999999997E-2,309.62,2.0999999999999999E-3,9.98,1.0323,4856.63,9561.26,1086.8100000000004]
["P8118","Oceanógrafo pleno","mês",6272.84,0.80130000000000001,5026.42,0.1174,736.74,4.3E-3,26.96,0,0,0,0,5.9999999999999995E-4,3.5,0,0,4.9399999999999999E-2,309.62,1.6000000000000001E-3,9.98,0.97460000000000002,6113.24,12386.07,1086.8099999999995]
["P8119","Oceanógrafo sênior","mês",12021.16,0.80130000000000001,9632.56,6.13E-2,736.74,2.2000000000000001E-3,26.96,0,0,0,0,2.9999999999999997E-4,3.5,0,0,2.58E-2,309.62,8.0000000000000004E-4,9.98,0.89170000000000005,10719.37,22740.53,1086.8099999999995]
["P8129","Pedagogo júnior","mês",2582.15,1.0650999999999999,2750.25,0.2853,736.74,1.04E-2,26.96,0,0,3.6400000000000002E-2,93.97,1.01E-2,26,0,0,0.11990000000000001,309.62,3.8999999999999998E-3,9.98,1.5310999999999999,3953.53,6535.68,1203.2800000000002]
["P8130","Pedagogo pleno","mês",3442.87,1.0650999999999999,3667,0.214,736.74,7.7999999999999996E-3,26.96,0,0,1.23E-2,42.33,7.6E-3,26,0,0,8.9899999999999994E-2,309.62,2.8999999999999998E-3,9.98,1.3996,4818.6400000000003,8261.51,1151.6400000000003]
["P8131","Pedagogo sênior","mês",4644.6499999999996,1.0650999999999999,4947.01,0.15859999999999999,736.74,5.7999999999999996E-3,26.96,0,0,0,0,5.5999999999999999E-3,26,0,0,6.6699999999999995E-2,309.62,2.0999999999999999E-3,9.98,1.3039000000000001,6056.32,10700.97,1109.3099999999995]
["P8135","Secretária","mês",2837.59,0.80249999999999999,2277.17,0.2596,736.74,0,0,0,0,2.7699999999999999E-2,78.64,1.6000000000000001E-3,4.6399999999999997,0,0,0.1091,309.62,3.5000000000000001E-3,9.98,1.2040999999999999,3416.8,6254.39,1139.6300000000001]
["P8139","Sondador","mês",2100.36,0.80020000000000002,1680.71,0.3508,736.74,1.44E-2,30.23,0,0,5.8500000000000003E-2,122.88,2.3E-3,4.8099999999999996,0,0,0.1474,309.62,4.7999999999999996E-3,9.98,1.3783000000000001,2894.97,4995.33,1214.2599999999998]
["P8143","Técnico ambiental","mês",2975.65,0.80649999999999999,2399.86,0.24759999999999999,736.74,1.0200000000000001E-2,30.23,0,0,2.3599999999999999E-2,70.36,1.6999999999999999E-3,5.0199999999999996,0,0,0.1041,309.62,3.3999999999999998E-3,9.98,1.1970000000000001,3561.82,6537.47,{"$f":"Y70-F70-D70","v":1161.9600000000005}]
["P8147","Técnico de obras","mês",3242.89,0.80210000000000004,2601.12,0.22720000000000001,736.74,9.2999999999999992E-3,30.23,0,0,1.6799999999999999E-2,54.33,1.1999999999999999E-3,3.82,0,0,9.5500000000000002E-2,309.62,3.0999999999999999E-3,9.98,1.1551,3745.84,6988.73,1144.7199999999998]
["P8151","Técnico de segurança do trabalho","mês",4601.83,0.80930000000000002,3724.26,0.16009999999999999,736.74,6.6E-3,30.23,0,0,0,0,1E-3,4.67,0,0,6.7299999999999999E-2,309.62,2.2000000000000001E-3,9.98,1.0464,4815.5,9417.33,1091.2399999999998]
["P8155","Técnico em geoprocessamento","mês",2920.29,0.79400000000000004,2318.71,0.25230000000000002,736.74,1.04E-2,30.23,0,0,2.52E-2,73.680000000000007,1.1000000000000001E-3,3.29,0,0,0.106,309.62,3.3999999999999998E-3,9.98,1.1923999999999999,3482.26,6402.55,1163.5500000000002]
["P8159","Técnico em informática - programador","mês",4417.8100000000004,0.80120000000000002,3539.55,0.1668,736.74,0,0,0,0,0,0,1.1000000000000001E-3,4.83,0,0,7.0099999999999996E-2,309.62,2.3E-3,9.98,1.0414000000000001,4600.72,9018.5300000000007,1061.17]
["P8163","Topógrafo","mês",2516.19,0.80589999999999995,2027.8,0.2928,736.74,1.2E-2,30.23,0,0,3.8899999999999997E-2,97.93,1.8E-3,4.42,0,0,0.1231,309.62,4.0000000000000001E-3,9.98,1.2784,3216.72,5732.91,1188.9199999999996]
["P8167","Arquivista júnior","mês",2556.4299999999998,0.79879999999999995,2042.07,0.28820000000000001,736.74,0,0,0,0,3.7400000000000003E-2,95.51,1.2999999999999999E-3,3.37,0,0,0.1211,309.62,3.8999999999999998E-3,9.98,1.2506999999999999,3197.31,5753.73,1155.23]
["P8168","Arquivista pleno","mês",3408.57,0.79879999999999995,2722.76,0.21609999999999999,736.74,0,0,0,0,1.2999999999999999E-2,44.39,1E-3,3.37,0,0,9.0800000000000006E-2,309.62,2.8999999999999998E-3,9.98,1.1227,3826.87,7235.44,1104.1099999999992]
["P8169","Arquivista sênior","mês",5529.35,0.79879999999999995,4416.84,0.13320000000000001,736.74,0,0,0,0,0,0,5.9999999999999995E-4,3.37,0,0,5.6000000000000001E-2,309.62,1.8E-3,9.98,0.99050000000000005,5476.56,11005.9,1059.7099999999991]
["P8173","Administrador júnior","mês",3488.04,0.7964,2777.88,0.2112,736.74,0,0,0,0,1.14E-2,39.619999999999997,1E-3,3.47,0,0,8.8800000000000004E-2,309.62,2.8999999999999998E-3,9.98,1.1115999999999999,3877.31,7365.35,1099.4300000000003]
["P8174","Administrador pleno","mês",4650.72,0.7964,3703.83,0.15840000000000001,736.74,0,0,0,0,0,0,6.9999999999999999E-4,3.47,0,0,6.6600000000000006E-2,309.62,2.0999999999999999E-3,9.98,1.0243,4763.6499999999996,9414.3700000000008,1059.8200000000006]
["P8175","Administrador sênior","mês",8384.93,0.7964,6677.76,8.7900000000000006E-2,736.74,0,0,0,0,0,0,4.0000000000000002E-4,3.47,0,0,3.6900000000000002E-2,309.62,1.1999999999999999E-3,9.98,0.92279999999999995,7737.58,16122.5,1059.8099999999995]
["P8180","Engenheiro agrimensor júnior","mês",12903,0.79879999999999995,10306.92,5.7099999999999998E-2,736.74,2.0999999999999999E-3,26.96,0,0,0,0,4.0000000000000002E-4,4.6100000000000003,0,0,2.4E-2,309.62,8.0000000000000004E-4,9.98,0.8831,11394.83,24297.83,1087.9100000000017]
["P8181","Engenheiro agrimensor pleno","mês",13780.36,0.79879999999999995,11007.75,5.3499999999999999E-2,736.74,2E-3,26.96,0,0,0,0,2.9999999999999997E-4,4.6100000000000003,0,0,2.2499999999999999E-2,309.62,6.9999999999999999E-4,9.98,0.87770000000000004,12095.66,25876.02,1087.9099999999999]
["P8182","Engenheiro agrimensor sênior","mês",14657.71,0.79879999999999995,11708.58,5.0299999999999997E-2,736.74,1.8E-3,26.96,0,0,0,0,2.9999999999999997E-4,4.6100000000000003,0,0,2.1100000000000001E-2,309.62,6.9999999999999999E-4,9.98,0.873,12796.49,27454.2,1087.9100000000017]
["P8183","Geógrafo júnior","mês",4065.19,0.79630000000000001,3237.11,0.1812,736.74,6.6E-3,26.96,0,0,1.1999999999999999E-3,4.99,8.9999999999999998E-4,3.64,0,0,7.6200000000000004E-2,309.62,2.5000000000000001E-3,9.98,1.0649,4329.05,8394.24,1091.9399999999991]
["P8184","Geógrafo pleno","mês",5420.25,0.79630000000000001,4316.1499999999996,0.13589999999999999,736.74,5.0000000000000001E-3,26.96,0,0,0,0,6.9999999999999999E-4,3.64,0,0,5.7099999999999998E-2,309.62,1.8E-3,9.98,0.99680000000000002,5403.1,10823.35,1086.9500000000007]
["P8185","Geógrafo sênior","mês",10653.03,0.79630000000000001,8483.01,6.9199999999999998E-2,736.74,2.5000000000000001E-3,26.96,0,0,0,0,2.9999999999999997E-4,3.64,0,0,2.9100000000000001E-2,309.62,8.9999999999999998E-4,9.98,0.89829999999999999,9569.9599999999991,20223,1086.9599999999991]
["P8186","Antropólogo júnior","mês",3451.7,0.86309999999999998,2979.16,0.21340000000000001,736.74,7.7999999999999996E-3,26.96,0,0,1.21E-2,41.8,2.8E-3,9.5399999999999991,0,0,8.9700000000000002E-2,309.62,2.8999999999999998E-3,9.98,1.1918,4113.8100000000004,7565.51,1134.6500000000005]
["P8187","Antropólogo pleno","mês",4602.2700000000004,0.86309999999999998,3972.22,0.16009999999999999,736.74,5.8999999999999999E-3,26.96,0,0,0,0,2.0999999999999999E-3,9.5399999999999991,0,0,6.7299999999999999E-2,309.62,2.2000000000000001E-3,9.98,1.1006,5065.07,9667.34,1092.8500000000004]
["P8188","Antropólogo sênior","mês",7246.03,0.86309999999999998,6254.05,0.1017,736.74,3.7000000000000002E-3,26.96,0,0,0,0,1.2999999999999999E-3,9.5399999999999991,0,0,4.2700000000000002E-2,309.62,1.4E-3,9.98,1.0139,7346.89,14592.92,1092.8399999999992]
["P8189","Arqueólogo júnior","mês",2862.79,0.84730000000000005,2425.64,0.25740000000000002,736.74,9.4000000000000004E-3,26.96,0,0,2.69E-2,77.13,2.8999999999999998E-3,8.24,0,0,0.1082,309.62,3.5000000000000001E-3,9.98,1.2555000000000001,3594.32,6457.11,1168.6799999999998]
["P8190","Arqueólogo pleno","mês",3817.05,0.84730000000000005,3234.19,0.193,736.74,7.1000000000000004E-3,26.96,0,0,5.1999999999999998E-3,19.88,2.2000000000000001E-3,8.24,0,0,8.1100000000000005E-2,309.62,2.5999999999999999E-3,9.98,1.1385000000000001,4345.6099999999997,8162.66,1111.4199999999992]
["P8191","Arqueólogo sênior","mês",5626.43,0.84730000000000005,4767.2700000000004,0.13089999999999999,736.74,4.7999999999999996E-3,26.96,0,0,0,0,1.5E-3,8.24,0,0,5.5E-2,309.62,1.8E-3,9.98,1.0412999999999999,5858.82,11485.25,1091.5499999999993]
["P8192","Historiador júnior","mês",4135.43,0.81369999999999998,3365,0.1782,736.74,6.4999999999999997E-3,26.96,0,0,2.0000000000000001E-4,0.77,1.6999999999999999E-3,7.01,0,0,7.4899999999999994E-2,309.62,2.3999999999999998E-3,9.98,1.0774999999999999,4456.09,8591.52,1091.0900000000001]
["P8193","Historiador pleno","mês",5513.91,0.81369999999999998,4486.66,0.1336,736.74,4.8999999999999998E-3,26.96,0,0,0,0,1.2999999999999999E-3,7.01,0,0,5.62E-2,309.62,1.8E-3,9.98,1.0114000000000001,5576.98,11090.88,1090.3099999999995]
["P8194","Historiador sênior","mês",8675.16,0.81369999999999998,7058.98,8.4900000000000003E-2,736.74,3.0999999999999999E-3,26.96,0,0,0,0,8.0000000000000004E-4,7.01,0,0,3.5700000000000003E-2,309.62,1.1999999999999999E-3,9.98,0.93940000000000001,8149.3,16824.46,1090.3199999999997]
["P8195","Paleontólogo júnior","mês",3451.7,0.86309999999999998,2979.16,0.21340000000000001,736.74,7.7999999999999996E-3,26.96,0,0,1.21E-2,41.8,2.8E-3,9.5399999999999991,0,0,8.9700000000000002E-2,309.62,2.8999999999999998E-3,9.98,1.1918,4113.8100000000004,7565.51,1134.6500000000005]
["P8196","Paleontólogo pleno","mês",4602.2700000000004,0.86309999999999998,3972.22,0.16009999999999999,736.74,5.8999999999999999E-3,26.96,0,0,0,0,2.0999999999999999E-3,9.5399999999999991,0,0,6.7299999999999999E-2,309.62,2.2000000000000001E-3,9.98,1.1006,5065.07,9667.34,1092.8500000000004]
["P8197","Paleontólogo sênior","mês",7246.03,0.86309999999999998,6254.05,0.1017,736.74,3.7000000000000002E-3,26.96,0,0,0,0,1.2999999999999999E-3,9.5399999999999991,0,0,4.2700000000000002E-2,309.62,1.4E-3,9.98,1.0139,7346.89,14592.92,1092.8399999999992]
["P8198","Sociólogo júnior","mês",4321.08,0.8135,3515.19,0.17050000000000001,736.74,6.1999999999999998E-3,26.96,0,0,0,0,1.6000000000000001E-3,7.01,0,0,7.17E-2,309.62,2.3E-3,9.98,1.0658000000000001,4605.51,8926.58,1090.3099999999995]
["P8199","Sociólogo pleno","mês",5761.43,0.8135,4686.93,0.12790000000000001,736.74,4.7000000000000002E-3,26.96,0,0,0,0,1.1999999999999999E-3,7.01,0,0,5.3699999999999998E-2,309.62,1.6999999999999999E-3,9.98,1.0026999999999999,5777.24,11538.67,1090.3099999999995]
["P8200","Sociólogo sênior","mês",8782.07,0.8135,7144.21,8.3900000000000002E-2,736.74,3.0999999999999999E-3,26.96,0,0,0,0,8.0000000000000004E-4,7.01,0,0,3.5299999999999998E-2,309.62,1.1000000000000001E-3,9.98,0.93769999999999998,8234.5300000000007,17016.59,1090.3100000000013]
["Profissionais horistas",{"$nulls":24},0]
["P8264","Motorista de veículo leve - horista","h",9.69,1.1319999999999999,10.97,0.41660000000000003,4.04,1.8599999999999998E-2,0.18,0,0,6.8400000000000002E-2,0.66,2.2000000000000001E-3,0.02,0,0,0.17510000000000001,1.7,5.5999999999999999E-3,0.05,1.8185,17.62,27.31,6.6499999999999968]
["Fonte: FGV IBRE",{"$nulls":24},0]

{"sheet":"C.G - DNIT","index":15,"n_rows":27,"n_cols":8,"rows_kept":27,"cut":false,"hidden":false,"merged":[[3,5,3,6],[24,1,25,1],[24,3,24,4],[25,3,25,4],[14,3,14,4],[15,1,16,1],[15,3,15,4],[16,3,16,4],[17,1,18,1],[17,3,17,4],[18,3,18,4],[19,1,23,1],[19,3,19,4],[20,3,20,4],[21,3,21,4],[22,3,22,4],[5,1,9,1],[3,1,4,1],[3,2,4,2],[3,3,4,3],[3,4,4,4]]}
[null,"2025-01-01"]
[null,"Tabela 1 - Custos de veículos "]
[null,{"$f":"\"Tabela de Preços de Consultoria - mês de referência: \"&TEXT(B1,\"MMMM\")&\" de \"&TEXT(B1,\"AAAA\")","v":"Tabela de Preços de Consultoria - mês de referência: janeiro de 2025"}]
[null,"Item","Código","Tipo","Unidade","Custo unitário (R$ / un)",null,"S"]
[{"$nulls":5},"Produtivo","Improdutivo"]
[null,"Veículos","E8889","Veículo leve - 53 kW (sem motorista)","hora",35.28,6.33]
[null,null,"E8890","Veículo leve - 53 kW (com motorista)","hora",62.59,33.64]
[null,null,"E8891","Veículo leve picape 4 x 4 com capacidade de 1,10 t - 147 kW (sem motorista)","hora",78.47,22.75]
[null,null,"E8888","Veículo tipo van furgão com capacidade de 1,38 t - 100 kW (sem motorista)","hora",55.73,17.2]
[null,null,"E8887","Veículo tipo van furgão com capacidade de 1,38 t - 100 kW (com motorista)","hora",83.04,44.51]
[null,"Fonte: FGV IBRE"]
[]
[null,"Tabela 2 - Custos de imóveis, mobiliário, cestas de instalações e custos diversos"]
[null,{"$f":"\"Tabela de Preços de Consultoria - mês de referência: \"&TEXT(B1,\"MMMM\")&\" de \"&TEXT(B1,\"AAAA\")","v":"Tabela de Preços de Consultoria - mês de referência: janeiro de 2025"}]
[null,"Item","Código","Tipo",null,"Unidade","Custo unitário \n(R$ / un)"]
[null,"Imóveis","B8951","Comercial (2,55% do CMCC - SINAPI)",null,"m² x mês",48.89]
[null,null,"B8952","Residencial (2,45% do CMCC - SINAPI)",null,"m² x mês",46.97]
[null,"Mobiliário","B8953","Escritório",null,"ocupante x mês",463.66]
[null,null,"B8954","Residência",null,"ocupante x mês",41.81]
[null,"Cesta das Instalações","B8955","Laboratório de asfalto",null,"mês",5910.44]
[null,null,"B8956","Laboratório de concreto",null,"mês",4533.32]
[null,null,"B8957","Laboratório de solos",null,"mês",3458.86]
[null,null,"B8958","Topografia",null,"mês",4674.3999999999996]
[null,null,"B8961","Topografia por VANT",null,"mês",923.93]
[null,"Custos Diversos","B8959","Escritório",null,"ocupante x mês",136.25]
[null,null,"B8960","Residência",null,"ocupante x mês",203.54]
[null,"Fonte: FGV IBRE"]

{"sheet":"Cotação Voos","index":16,"n_rows":106,"n_cols":6,"rows_kept":106,"cut":false,"hidden":true,"merged":[]}
["COTAÇÕES - IDA DIA 07/04/2024 E VOLTA DIA 11/04/2024"]
["Localidade:","Juazeiro/BA"]
[]
["Origem","Destino"]
["BSB ",{"$f":"B2","v":"Juazeiro/BA"},"Cia 1","Cia 2","Cia 3","Média"]
[null,null,1397,1695,1841,{"$f":"AVERAGE(C6:E6)","v":1644.3333333333333}]
{"$rows_empty":24}
["SP",{"$f":"B2","v":"Juazeiro/BA"},"Cia 1","Cia 2","Cia 3","Média"]
[null,null,885,1087,1087,{"$f":"AVERAGE(C32:E32)","v":1019.6666666666666}]
{"$rows_empty":24}
["Curitiba",{"$f":"B2","v":"Juazeiro/BA"},"Cia 1","Cia 2","Cia 3","Média"]
[null,null,2301,3653,4416,{"$f":"AVERAGE(C58:E58)","v":3456.6666666666665}]
{"$rows_empty":23}
["Recife",{"$f":"B2","v":"Juazeiro/BA"},"Cia 1","Cia 2","Cia 3","Média"]
[null,null,2262,2262,4704,{"$f":"AVERAGE(C83:E83)","v":3076}]
{"$rows_empty":22}
["VALOR ADOTADO:",null,{"$f":"AVERAGE(F6:F83)","v":2299.1666666666665}]

{"sheet":"AUX - MOBILIÁRIO","index":17,"n_rows":46,"n_cols":7,"rows_kept":46,"cut":false,"hidden":false,"merged":[[71,0,71,6],[0,0,3,5],[4,0,5,5],[7,0,8,0],[7,1,7,4],[7,5,8,5],[45,0,45,6]]}
[]
[]
[]
[]
["COMPOSIÇÃO DO PREÇO UNITÁRIO MENSAL PARA ALUGUEL DE MOBILIÁRIO E EQUIPAMENTOS DE ESCRITÓRIO"]
[]
[]
[" AQUISIÇÃO DE MOBILIÁRIO","VALOR DA DEPRECIAÇÃO",null,null,null,"VALOR MENSAL TOTAL (R$)"]
[null,"Tempo de Utilização (Anos)","Meses p/Ano de Uso","Percentual Residual (%)","Depreciação        Mensal - R$"]
[{"$f":"SUM(E13:E18)","v":3354.99},1.5,12,0.2,{"$f":"ROUND((A10*(100%-D10))/(B10*C10),2)","v":149.11000000000001},{"$f":"E10","v":149.11000000000001}]
[]
["Item","Código","Preço Un.","Quantidade","Custo de Aquisição"]
["Mesa de Escritório","11548/ORSE",345,{"$f":"4","v":4},{"$f":"C13*D13","v":1380}]
["Cadeira Giratória","11534/ORSE",280,{"$f":"5","v":5},{"$f":"C14*D14","v":1400}]
["Armário Escritório","Cotação",{"$f":"G43","v":574.99},1,{"$f":"C15*D15","v":574.99}]
{"$rows_empty":7}
["Armário para Escritório"]
{"$rows_empty":16}
["Cotação 1","Cotação 2","Cotação 3","Cotação 4","Cotação 5","CV=",{"$f":"_xlfn.STDEV.S(A41:E41)/AVERAGE(A41:A41)","v":6.2800886844130668E-2}]
[541.5,620.76,541.5,591.20000000000005,579.99,"Média=",{"$f":"AVERAGE(A41:E41)","v":574.99}]
[{"$nulls":5},"Mediana=",{"$f":"MEDIAN(A41:E41)","v":579.99}]
[{"$nulls":5},"Menor=",{"$f":"SMALL(G41:G42,1)","v":574.99}]
[]
["Data da Pesquisa: 20/01/2025"]
["https://www.google.com/search?sca_esv=3c12e2eb7b7f70e3&tbm=shop&q=armario+madeira+alto+escritorio&tbs=mr:1,price:1,ppr_min:500,ppr_max:700&sa=X&ved=0ahUKEwim5PCi5ISLAxW-ppUCHQnQD2QQvSsI5QYoAg&biw=1455&bih=695&dpr=1.1"]

{"sheet":"AUX - NOTEBOOK","index":18,"n_rows":47,"n_cols":10,"rows_kept":47,"cut":false,"hidden":false,"merged":[[46,0,46,8],[72,0,72,8],[0,0,3,7],[4,0,5,7],[7,0,8,0],[7,1,7,4],[7,5,7,6],[7,7,8,7]]}
[]
[]
[]
[]
["COMPOSIÇÃO DO PREÇO UNITÁRIO MENSAL PARA ALUGUEL DE NOTEBOOK"]
[]
[]
[" AQUISIÇÃO DE EQUIPAMENTO","VALOR DA DEPRECIAÇÃO",null,null,null,"MANUTENÇÃO",null,"VALOR MENSAL TOTAL (R$)"]
[null,"Tempo de Utilização (Anos)","Meses p/Ano de Uso","Percentual Residual (%)","Depreciação        Mensal - R$","Percentual Anual (%)","Valor Mensal (R$)"]
[{"$f":"SUM(E13:E18)","v":2599.0571428571429},2,12,0.25,{"$f":"ROUND((A10*(100%-D10))/(B10*C10),2)","v":81.22},0.05,{"$f":"ROUND((F10*A10)/12,2)","v":10.83},{"$f":"E10+G10","v":92.05}]
[]
["Item","Código","Preço Un.","Quantidade","Custo de Aquisição"]
["Notebook 16 GB RAM, 500 GB HDD, Tela 14\" e processador 2,8 GHz","Cotação",{"$f":"J44","v":2599.0571428571429},1,{"$f":"C13*D13","v":2599.0571428571429}]
{"$rows_empty":9}
["Notebook 16 Gb RAM, 500 GB HDD"]
{"$rows_empty":17}
["Cotação 1","Cotação 2","Cotação 3","Cotação 4","Cotação 5","Cotação 6","Cotação 7",null,"CV=",{"$f":"_xlfn.STDEV.S(A42:G42)/AVERAGE(A42:G42)","v":0.16603472259908722}]
[2990,2179,2950,1999.02,2276.39,2999.99,2799,null,"Média=",{"$f":"AVERAGE(A42:G42)","v":2599.0571428571429}]
[{"$nulls":8},"Mediana=",{"$f":"MEDIAN(A42:G42)","v":2799}]
[{"$nulls":8},"Menor=",{"$f":"SMALL(J42:J43,1)","v":2599.0571428571429}]
[]
["Data da Pesquisa: 20/01/2025"]
["https://www.google.com/search?sca_esv=3c12e2eb7b7f70e3&tbm=shop&q=armario+madeira+alto+escritorio&tbs=mr:1,price:1,ppr_min:500,ppr_max:700&sa=X&ved=0ahUKEwim5PCi5ISLAxW-ppUCHQnQD2QQvSsI5QYoAg&biw=1455&bih=695&dpr=1.1"]

{"sheet":"AUX - IMPRESSORA","index":19,"n_rows":47,"n_cols":8,"rows_kept":47,"cut":false,"hidden":false,"merged":[[46,0,46,8],[72,0,72,8],[0,0,3,7],[4,0,5,7],[7,0,8,0],[7,1,7,4],[7,5,7,6],[7,7,8,7]]}
[]
[]
[]
[]
["COMPOSIÇÃO DO PREÇO UNITÁRIO MENSAL PARA ALUGUEL DE IMPRESSORA"]
[]
[]
[" AQUISIÇÃO DE EQUIPAMENTO","VALOR DA DEPRECIAÇÃO",null,null,null,"MANUTENÇÃO",null,"VALOR MENSAL TOTAL (R$)"]
[null,"Tempo de Utilização (Anos)","Meses p/Ano de Uso","Percentual Residual (%)","Depreciação        Mensal - R$","Percentual Anual (%)","Valor Mensal (R$)"]
[{"$f":"SUM(E13:E18)","v":1528.2280000000003},2,12,0.25,{"$f":"ROUND((A10*(100%-D10))/(B10*C10),2)","v":47.76},0.05,{"$f":"ROUND((F10*A10)/12,2)","v":6.37},{"$f":"E10+G10","v":54.129999999999995}]
[]
["Item","Código","Preço Un.","Quantidade","Custo de Aquisição"]
["Impressora Laser Colorida Multifuncional","Cotação",{"$f":"G43","v":1528.2280000000003},1,{"$f":"C13*D13","v":1528.2280000000003}]
{"$rows_empty":9}
["Impressora Laser Multifuncional"]
{"$rows_empty":16}
[{"$nulls":5},"CV=",{"$f":"_xlfn.STDEV.S(A42:E42)/AVERAGE(A42:E42)","v":0.13105129699165202}]
["Cotação 1","Cotação 2","Cotação 3","Cotação 4","Cotação 5","Média=",{"$f":"AVERAGE(A42:E42)","v":1528.2280000000003}]
[1349.1,1597,1299,1779.94,1616.1,"Mediana=",{"$f":"MEDIAN(A42:E42)","v":1597}]
[{"$nulls":5},"Menor=",{"$f":"SMALL(G41:G42,1)","v":1528.2280000000003}]
[]
[]
["Data da Pesquisa: 20/01/2025"]
["https://www.google.com/search?sca_esv=3c12e2eb7b7f70e3&tbm=shop&q=armario+madeira+alto+escritorio&tbs=mr:1,price:1,ppr_min:500,ppr_max:700&sa=X&ved=0ahUKEwim5PCi5ISLAxW-ppUCHQnQD2QQvSsI5QYoAg&biw=1455&bih=695&dpr=1.1"]