{"text_format":"2","workbook":"xlsx","n_sheets":16,"sheets":["PFP","PFP1.2_Equi_div","PFP1.3_Ger","COMPOSIÇÕES PFP1.3_Ger","PFP2.1_FatorKa","PFP2.2_FatorKb","PFP2.3_FatorKc","PFP3_FatorKd","Cronograma Físico-Financeiro","CPU-VEICULO_Leve","CPU ESCRIT. CONTAINER","MDO -  DNIT","C.G - DNIT","AUX - MOBILIÁRIO","AUX - NOTEBOOK","AUX - IMPRESSORA"],"not_rendered":{"charts":0,"images":49,"macros":0,"external_links":251,"defined_names":33700,"comments":2,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"PFP","index":0,"n_rows":39,"n_cols":16,"rows_kept":39,"cut":false,"hidden":false,"merged":[[30,0,30,10],[31,0,31,10],[32,0,32,10],[33,0,33,10],[0,0,1,8],[25,0,25,10],[26,0,26,10],[27,0,27,10],[28,0,28,10],[29,0,29,10],[20,0,20,10],[21,0,21,10],[22,0,22,10],[23,0,23,10],[24,0,24,10],[17,0,17,5],[17,7,17,10],[18,0,18,5],[18,7,18,10],[19,0,19,5],[19,7,19,10],[5,0,5,4],[5,5,5,8],[5,9,5,10],[16,0,16,5],[16,7,16,10],[0,9,0,10],[1,9,1,10],[2,0,2,10],[3,0,3,10],[4,0,4,4],[4,5,4,8],[4,9,4,10]]}
["PROPOSTA FINANCEIRA DO PROJETO",{"$nulls":8},"CODIGO:"]
[{"$nulls":9},"PFP"]
["NOME DA CONSULTORA:"]
[]
["PROJETO:",{"$nulls":4},"CONTRATANTE:",null,null,null,"BASE: "]
["CONTRATAÇÃO DE EMPRESA DE ENGENHARIA PARA SUPERVISÃO E APOIO À FISCALIZAÇÃO DURANTE OS SERVIÇOS DE EXECUÇÃO DAS OBRAS DA PONTE SOBRE O RIBEIRÃO ÁGUA LIMPA, VIAS DE ACESSO E INFRAESTRUTURA COMPLETA VISANDO A INTERLIGAÇÃO DAS RODOVIAS GO-173 E GO-324, NO MUNICÍPIO DE BRITÂNIA, NO ESTADO DE GOIÁS",{"$nulls":4},"CODEVASF (SEDE)",null,null,null,"SICRO JAN/2025; SINAPI MAI/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","P8066","Engenheiro Pleno","mês",18,{"$f":"VLOOKUP(C8,'MDO -  DNIT'!$A:$Z,4,0)","v":13163.74},{"$f":"G8*I8","v":27750.480294000001},{"$f":"'PFP2.1_FatorKa'!$E$36","v":2.1080999999999999},{"$f":"G8*F8","v":236947.32},{"$f":"ROUND(J8*I8,2)","v":499508.65},{"$nulls":4},{"$f":"VLOOKUP(C8,'MDO -  DNIT'!$A:$Z,26,0)","v":1087.22}]
["SICRO","MO1","P8147","Técnico - Profissional Especial","mês",18,{"$f":"VLOOKUP(C9,'MDO -  DNIT'!$A:$Z,4,0)","v":3242.89},6836.3364089999995,{"$f":"'PFP2.1_FatorKa'!$E$36","v":2.1080999999999999},58372.02,{"$f":"ROUND(J9*I9,2)","v":123054.06},{"$f":"N9-M9","v":1070.18},2450.48,3520.66,null,{"$f":"VLOOKUP(C9,'MDO -  DNIT'!$A:$Z,26,0)","v":1144.72}]
["SICRO","MO1","P8098","Técnico Auxiliar (Laboratorista)","mês",18,{"$f":"VLOOKUP(C10,'MDO -  DNIT'!$A:$Z,4,0)","v":2413.91},5088.7636709999997,{"$f":"'PFP2.1_FatorKa'!$E$36","v":2.1080999999999999},43450.38,91597.75,{"$nulls":4},{"$f":"VLOOKUP(C10,'MDO -  DNIT'!$A:$Z,26,0)","v":1194.73}]
["CODE","LO","PROP","Relatório Semanal de Obras","und",72,{"$f":"'COMPOSIÇÕES PFP1.3_Ger'!H20","v":503.39431818181799},609.15746443181797,{"$f":"PFP3_FatorKd!$E$17","v":1.2101},36244.3909090909,{"$f":"H11*F11","v":43859.337439090901}]
["CODE","LO","PROP","Relatório de Avaliação de Projeto","und",1,{"$f":"'COMPOSIÇÕES PFP1.3_Ger'!H29","v":43750.11},52942.008111000003,{"$f":"PFP3_FatorKd!$E$17","v":1.2101},43750.11,{"$f":"H12*F12","v":52942.008111000003}]
["CODE","LO","PROP","Levantamento Topográfico","und",2,{"$f":"'COMPOSIÇÕES PFP1.3_Ger'!H37","v":9736.77},11782.465377,{"$f":"PFP3_FatorKd!$E$17","v":1.2101},19473.54,23564.930754000001]
["CODE","LO","PROP","Veículo leve - 71 a 115 CV","mês",32,{"$f":"'CPU-VEICULO_Leve'!D49","v":1727.88820096473},2090.9175119874199,{"$f":"PFP3_FatorKd!$E$17","v":1.2101},55292.422430871498,66909.36]
["CODE","LO","PROP","Infraestrutura e Equipamentos de Escritório","und",1,{"$f":"'PFP1.2_Equi_div'!G11","v":62595.78},75747.153378000003,{"$f":"PFP3_FatorKd!$E$17","v":1.2101},62595.78,75747.149999999994]
["SICRO","EC","SICRO","Encargos Complementares Adicionais","mês",{"$f":"SUM(F8:F10)","v":54},{"$f":"AVERAGE(P8:P13)","v":1142.2233333333299},1382.2044556666699,{"$f":"PFP3_FatorKd!$E$17","v":1.2101},61680.06,74639.039999999994]
["TOTAL DOS CUSTOS DIRETOS",{"$nulls":6},{"$f":"SUM(J8:J16)","v":617806.023339962}]
["TOTAL DOS ENCARGOS E DESPESAS DIVERSAS",{"$nulls":6},{"$f":"H19-H17","v":434016.26296412898}]
["TOTAL DA PROPOSTA A PREÇO GLOBAL",{"$nulls":6},{"$f":"SUM(K8:K16)","v":1051822.2863040899}]
["TOTAL DA PROPOSTA",{"$nulls":6},{"$f":"H19","v":1051822.2863040899},{"$nulls":7},{"$f":"H20/67950000","v":1.54793566785002E-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.2_Equi_div","index":1,"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 DE EMPRESA DE ENGENHARIA PARA SUPERVISÃO E APOIO À FISCALIZAÇÃO DURANTE OS SERVIÇOS DE EXECUÇÃO DAS OBRAS DA PONTE SOBRE O RIBEIRÃO ÁGUA LIMPA, VIAS DE ACESSO E INFRAESTRUTURA COMPLETA VISANDO A INTERLIGAÇÃO DAS RODOVIAS GO-173 E GO-324, NO MUNICÍPIO DE BRITÂNIA, NO ESTADO DE GOIÁS"},null,null,null,"CODEVASF (SEDE)",null,{"$f":"PFP!J6","v":"SICRO JAN/2025; SINAPI MAI/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",36,{"$f":"'AUX - NOTEBOOK'!H10","v":119.12},{"$f":"E8*F8","v":4288.32}]
["PROP","CODE","Aluguel de impressora","mês",18,{"$f":"'AUX - IMPRESSORA'!H10","v":70.05},{"$f":"E9*F9","v":1260.9000000000001}]
["PROP","CODE","Escritório","mês",18,{"$f":"'CPU ESCRIT. CONTAINER'!C14","v":3169.2533333333299},57046.559999999998]
["TOTAL",{"$nulls":5},{"$f":"SUM(G8:G10)","v":62595.78}]

{"sheet":"PFP1.3_Ger","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.3"]
["NOME DA EMPRESA:"]
[]
["PROJETO: ",null,null,null,"CONTRATANTE:",null,{"$f":"[249]PFP!J5","v":"BASE:"}]
[{"$f":"PFP!A6","v":"CONTRATAÇÃO DE EMPRESA DE ENGENHARIA PARA SUPERVISÃO E APOIO À FISCALIZAÇÃO DURANTE OS SERVIÇOS DE EXECUÇÃO DAS OBRAS DA PONTE SOBRE O RIBEIRÃO ÁGUA LIMPA, VIAS DE ACESSO E INFRAESTRUTURA COMPLETA VISANDO A INTERLIGAÇÃO DAS RODOVIAS GO-173 E GO-324, NO MUNICÍPIO DE BRITÂNIA, NO ESTADO DE GOIÁS"},null,null,null,"CODEVASF (SEDE)",null,{"$f":"PFP!J6","v":"SICRO JAN/2025; SINAPI MAI/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","Relatório Semanal de Obras","und",72,{"$f":"'[249]COMPOSIÇÕES PFP1.3_Ger'!J20","v":570.28950048819502},{"$f":"E8*F8","v":41060.844035150003}]
["PROP","CODE","Relatório de Avaliação de Projeto","und",1,{"$f":"'[249]COMPOSIÇÕES PFP1.3_Ger'!J29","v":50028.9219887816},{"$f":"E9*F9","v":50028.9219887816}]
["PROP","CODE","Levantamento Topográfico","und",2,{"$f":"'[249]COMPOSIÇÕES PFP1.3_Ger'!J37","v":11764.535140182201},{"$f":"E10*F10","v":23529.0702803645}]
["TOTAL",{"$nulls":5},{"$f":"SUM(G8:G10)","v":114618.836304296}]

{"sheet":"COMPOSIÇÕES PFP1.3_Ger","index":3,"n_rows":66,"n_cols":9,"rows_kept":66,"cut":false,"hidden":false,"merged":[[1,0,1,7]]}
[]
[]
[]
["COMPOSIÇÃO 1",null,null,"DESCRIÇÃO","UNIDADE","QUANTIDADE","CUSTO UNITÁRIO","CUSTO TOTAL"]
["ORIGEM","CÓDIGO 1","CÓDIGO 2","RELATÓRIO DIÁRIO DE OBRAS","[un]",1]
["SINAPI","MO1",2706,"Engenheiro Civil - Acompanhamento de Obras","[h]",8,114.63,{"$f":"G6*F6","v":917.04},"dia"]
["SINAPI","MO1",2706,"Engenheiro Civil - Elaboração de Relatório Diário de Obras","[h]",2,114.63,{"$f":"G7*F7","v":229.26},"dia"]
["PRÓPRIO","SU","PRÓPRIO","Veículo Leve","dia",1,{"$f":"'[250]CPU-VEICULO_Leve'!D8","v":118.697006855335},{"$f":"G8*F8","v":118.697006855335},"dia"]
["DNIT","SU","B8953","Escritório - Mobiliário","dia",1,{"$f":"'[250]DNIT Rel. Consolidação de C.G.'!$G$18/22","v":20.755454545454501},{"$f":"G9*F9","v":20.755454545454501},"dia"]
["DNIT","SU","B8959","Escritório - Custos Diversos","dia",1,{"$f":"'[250]DNIT Rel. Consolidação de C.G.'!$G$25/22","v":6.1904545454545499},{"$f":"G10*F10","v":6.1904545454545499},"dia"]
[{"$nulls":7},{"$f":"SUM(H6:H10)","v":1291.94291594624}]
[]
[]
[]
["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,122.44,{"$f":"F17*G17","v":489.76},"mês"]
["DNIT","SU","B8953","Escritório - Mobiliário","dia",0.5,{"$f":"'C.G - DNIT'!G18/22","v":21.075454545454502},{"$f":"F18*G18","v":10.537727272727301},"dia"]
["DNIT","SU","B8959","Escritório - Custos Diversos","dia",0.5,{"$f":"'C.G - DNIT'!G25/22","v":6.1931818181818201},{"$f":"F19*G19","v":3.0965909090909101},"dia"]
[{"$nulls":7},{"$f":"SUM(H17:H19)","v":503.39431818181799}]
[]
[]
[]
["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]",2,21575.1,{"$f":"G26*F26","v":43150.2},"mês"]
["DNIT","SU","B8953","Escritório - Mobiliário","[ocupante x mês]",1,{"$f":"'C.G - DNIT'!$G$18","v":463.66},{"$f":"G27*F27","v":463.66},"ocupante x mês"]
["DNIT","SU","B8959","Escritório - Custos Diversos","[ocupante x mês]",1,{"$f":"'C.G - DNIT'!G25","v":136.25},{"$f":"G28*F28","v":136.25},"ocupante x mês"]
[{"$nulls":7},{"$f":"SUM(H26:H28)","v":43750.11}]
[]
[]
[]
["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,5618.85,{"$f":"F35*G35","v":5618.85},"mês"]
["DNIT","MO2","P8028","Auxiliar","[mês]",1,4117.92,{"$f":"F36*G36","v":4117.92},"mês"]
[{"$nulls":7},{"$f":"SUM(H35:H36)","v":9736.77}]
[]
[]
[]
["COMPOSIÇÃO 5",null,null,"DESCRIÇÃO","UNIDADE","QUANTIDADE","CUSTO UNITÁRIO","CUSTO TOTAL"]
["SUDECAP","CÓDIGO 1","98.04.09","CONCRETO - EXTRAÇÃO E ROMPIMENTO DE CORPO DE PROVA CILÍNDRICO","[un]",1,600,{"$f":"G42*F42","v":600}]
[]
[]
[]
[]
["COMPOSIÇÃO 6",null,null,"DESCRIÇÃO","UNIDADE","QUANTIDADE","CUSTO UNITÁRIO","CUSTO TOTAL"]
["SETOP","CÓDIGO 1","ED-49546","CONCRETO - ROMPIMENTO DE CORPO DE PROVA MOLDADO IN LOCO NO RECEBIMENTO","[un]",1,100.21,{"$f":"G48*F48","v":100.21}]
[]
[]
[]
[]
["COMPOSIÇÃO 7",null,null,"DESCRIÇÃO","UNIDADE","QUANTIDADE","CUSTO UNITÁRIO","CUSTO TOTAL"]
["SINAPI","CÓDIGO 1",97636,"PAVIMENTO - ESPESSURA DE CORPO DE PROVA COM EXTRAÇÃO","[un]",1,22.98,{"$f":"G54*F54","v":22.98}]
[]
[]
[]
[]
["COMPOSIÇÃO 8",null,null,"DESCRIÇÃO","UNIDADE","QUANTIDADE","CUSTO UNITÁRIO","CUSTO TOTAL"]
["SCO","CÓDIGO 1","\nAD 34.20.0062","PAVIMENTO - TEOR DE LIGANTE","[un]",1,441.63,{"$f":"G60*F60","v":441.63}]
[]
[]
[]
[]
["COMPOSIÇÃO 9",null,null,"DESCRIÇÃO","UNIDADE","QUANTIDADE","CUSTO UNITÁRIO","CUSTO TOTAL"]
["SUDECAP","CÓDIGO 1","96.01.03","PAVIMENTO - DENSIDADE DE MASSA","[un]",1,116.38,{"$f":"G66*F66","v":116.38}]

{"sheet":"PFP2.1_FatorKa","index":4,"n_rows":41,"n_cols":6,"rows_kept":41,"cut":false,"hidden":false,"merged":[[38,0,38,5],[39,0,39,5],[40,0,40,5],[0,0,1,4],[32,1,32,3],[33,1,33,3],[34,1,34,3],[35,1,35,3],[37,0,37,5],[27,1,27,3],[28,1,28,3],[29,1,29,3],[30,1,30,3],[31,1,31,3],[22,1,22,3],[23,1,23,3],[24,1,24,3],[25,1,25,3],[26,1,26,3],[17,1,17,3],[18,1,18,3],[19,1,19,3],[20,1,20,3],[21,1,21,3],[11,1,11,3],[12,1,12,3],[13,1,13,3],[14,1,14,3],[15,1,15,3],[6,1,6,3],[7,1,7,3],[8,1,8,3],[9,1,9,3],[10,1,10,3],[2,0,2,5],[3,0,3,5],[4,2,4,4],[5,0,5,1],[5,2,5,4]]}
["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 DE EMPRESA DE ENGENHARIA PARA SUPERVISÃO E APOIO À FISCALIZAÇÃO DURANTE OS SERVIÇOS DE EXECUÇÃO DAS OBRAS DA PONTE SOBRE O RIBEIRÃO ÁGUA LIMPA, VIAS DE ACESSO E INFRAESTRUTURA COMPLETA VISANDO A INTERLIGAÇÃO DAS RODOVIAS GO-173 E GO-324, NO MUNICÍPIO DE BRITÂNIA, NO ESTADO DE GOIÁS"},null,"CODEVASF (SEDE)",null,null,"SINAPI/GO"]
["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":128054.95}]
["A1","INSS",null,null,0.2,{"$f":"ROUND(E9*SUMIF(PFP!$B$8:$B$13,\"MO1\",PFP!$J$8:$J$13),2)","v":67753.94}]
["A2","SESI",null,null,1.4999999999999999E-2,{"$f":"ROUND(E10*SUMIF(PFP!$B$8:$B$13,\"MO1\",PFP!$J$8:$J$13),2)","v":5081.55}]
["A3","SENAI",null,null,0.01,{"$f":"ROUND(E11*SUMIF(PFP!$B$8:$B$13,\"MO1\",PFP!$J$8:$J$13),2)","v":3387.7}]
["A4","INCRA",null,null,2E-3,{"$f":"ROUND(E12*SUMIF(PFP!$B$8:$B$13,\"MO1\",PFP!$J$8:$J$13),2)","v":677.54}]
["A5","SEBRAE",null,null,6.0000000000000001E-3,{"$f":"ROUND(E13*SUMIF(PFP!$B$8:$B$13,\"MO1\",PFP!$J$8:$J$13),2)","v":2032.62}]
["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":8469.24}]
["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":10163.09}]
["A8","FGTS",null,null,0.08,{"$f":"ROUND(E16*SUMIF(PFP!$B$8:$B$13,\"MO1\",PFP!$J$8:$J$13),2)","v":27101.58}]
["A9","SECONCI",null,null,0.01,{"$f":"ROUND(E17*SUMIF(PFP!$B$8:$B$13,\"MO1\",PFP!$J$8:$J$13),2)","v":3387.7}]
["B"," ENCARGOS SOCIAIS QUE RECEBEM INCIDÊNCIA DE \"A\"",null,null,{"$f":"ROUND(SUM(E19:E25),4)","v":9.69E-2},{"$f":"ROUND(E18*SUMIF(PFP!$B$8:$B$13,\"MO1\",PFP!$J$8:$J$13),2)","v":32826.79}]
["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":2202}]
["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":28219.52}]
["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":169.38}]
["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":1897.11}]
["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":237.14}]
["B9","Férias Gozadas",null,null,0,{"$f":"ROUND(E24*SUMIF(PFP!$B$8:$B$13,\"MO1\",PFP!$J$8:$J$13),2)","v":0}]
["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":101.63}]
["C"," ENCARGOS SOCIAIS QUE NÃO RECEBEM INCIDÊNCIA DE \"A\"",null,null,{"$f":"ROUND(SUM(E27:E31),4)","v":0.15670000000000001},{"$f":"ROUND(E26*SUMIF(PFP!$B$8:$B$13,\"MO1\",PFP!$J$8:$J$13),2)","v":53085.22}]
["C1","Aviso Prévio Indenizado",null,null,4.3999999999999997E-2,{"$f":"ROUND(E27*SUMIF(PFP!$B$8:$B$13,\"MO1\",PFP!$J$8:$J$13),2)","v":14905.87}]
["C2","Aviso Prévio Trabalhado",null,null,1E-3,{"$f":"ROUND(E28*SUMIF(PFP!$B$8:$B$13,\"MO1\",PFP!$J$8:$J$13),2)","v":338.77}]
["C3","Férias Indenizadas",null,null,8.9200000000000002E-2,{"$f":"ROUND(E29*SUMIF(PFP!$B$8:$B$13,\"MO1\",PFP!$J$8:$J$13),2)","v":30218.26}]
["C4","Depósito Rescisão Sem Justa Causa",null,null,1.8800000000000001E-2,{"$f":"ROUND(E30*SUMIF(PFP!$B$8:$B$13,\"MO1\",PFP!$J$8:$J$13),2)","v":6368.87}]
["C5","Indenização Adicional",null,null,3.7000000000000002E-3,{"$f":"ROUND(E31*SUMIF(PFP!$B$8:$B$13,\"MO1\",PFP!$J$8:$J$13),2)","v":1253.45}]
["D"," REINCIDÊNCIAS",null,null,{"$f":"ROUND(SUM(E33:E34),4)","v":4.0500000000000001E-2},{"$f":"ROUND(E32*SUMIF(PFP!$B$8:$B$13,\"MO1\",PFP!$J$8:$J$13),2)","v":13720.17}]
["D1","Reincidência de \"A\" sobre \"B\"",null,null,3.6600000000000001E-2,{"$f":"ROUND(E33*SUMIF(PFP!$B$8:$B$13,\"MO1\",PFP!$J$8:$J$13),2)","v":12398.97}]
["D2","Reincidência de \"A\" sobre Aviso Prévio Trabalhado e reincidência do FGTS sobre Aviso Prévio Indenizado",null,null,3.8999999999999998E-3,{"$f":"ROUND(E34*SUMIF(PFP!$B$8:$B$13,\"MO1\",PFP!$J$8:$J$13),2)","v":1321.2}]
["K1a","ENCARGOS SOCIAIS",null,null,{"$f":"ROUND(E8+E18+E26+E32,4)","v":0.67210000000000003},{"$f":"ROUND(E35*SUMIF(PFP!$B$8:$B$13,\"MO1\",PFP!$J$8:$J$13),2)","v":227687.13}]
["Ka","TAXA DE RESSARCIMENTO DE DESPESAS E ENCARGOS SOBRE MO1",null,null,{"$f":"ROUND((1+E35+[251]PFP3_FatorKd!E13)*(1+[251]PFP3_FatorKd!E12)*(1+[251]PFP3_FatorKd!E8),4)","v":2.1080999999999999}]
["OBSERVAÇÃO: CELETISTAS E EQUIVALENTES"]
["1 - DISCRIMINAR OS ENCARGOS SOCIAIS COM SEUS RESPECTIVOS PERCENTUAS TOTALIZANDO OS MESMOS. "]
["2 - APLICAR O  % TOTAL P/ CALCULAR OS E. SOCIAIS INCIDENTES NA MÃO-DE-OBRA CELETISTAS"]
["Ka - Taxa de Ressarcimento de Despesas e Encargos sobre a Mão de Obra CELETISTA (incide apenas no Insumo Codigo MO1)"]
["Ka = (1 + K1 + K2) x (1 + K3) x (1 + K4)"]

{"sheet":"PFP2.2_FatorKb","index":5,"n_rows":40,"n_cols":6,"rows_kept":40,"cut":false,"hidden":false,"merged":[[37,0,37,5],[38,0,38,5],[39,0,39,5],[0,0,1,4],[31,1,31,3],[32,1,32,3],[33,1,33,3],[34,1,34,3],[36,0,36,5],[26,1,26,3],[27,1,27,3],[28,1,28,3],[29,1,29,3],[30,1,30,3],[21,1,21,3],[22,1,22,3],[23,1,23,3],[24,1,24,3],[25,1,25,3],[16,1,16,3],[17,1,17,3],[18,1,18,3],[19,1,19,3],[20,1,20,3],[11,1,11,3],[12,1,12,3],[13,1,13,3],[14,1,14,3],[15,1,15,3],[6,1,6,3],[7,1,7,3],[8,1,8,3],[9,1,9,3],[10,1,10,3],[2,0,2,5],[3,0,3,5],[4,2,4,4],[5,0,5,1],[5,2,5,4]]}
["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 DE EMPRESA DE ENGENHARIA PARA SUPERVISÃO E APOIO À FISCALIZAÇÃO DURANTE OS SERVIÇOS DE EXECUÇÃO DAS OBRAS DA PONTE SOBRE O RIBEIRÃO ÁGUA LIMPA, VIAS DE ACESSO E INFRAESTRUTURA COMPLETA VISANDO A INTERLIGAÇÃO DAS RODOVIAS GO-173 E GO-324, NO MUNICÍPIO DE BRITÂNIA, NO ESTADO DE GOIÁS"},null,"CODEVASF (SEDE)",null,null,{"$f":"'PFP2.1_FatorKa'!F6","v":"SINAPI/GO"}]
["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":6,"n_rows":40,"n_cols":6,"rows_kept":40,"cut":false,"hidden":false,"merged":[[37,0,37,5],[38,0,38,5],[39,0,39,5],[0,0,1,4],[31,1,31,3],[32,1,32,3],[33,1,33,3],[34,1,34,3],[36,0,36,5],[26,1,26,3],[27,1,27,3],[28,1,28,3],[29,1,29,3],[30,1,30,3],[21,1,21,3],[22,1,22,3],[23,1,23,3],[24,1,24,3],[25,1,25,3],[16,1,16,3],[17,1,17,3],[18,1,18,3],[19,1,19,3],[20,1,20,3],[11,1,11,3],[12,1,12,3],[13,1,13,3],[14,1,14,3],[15,1,15,3],[6,1,6,3],[7,1,7,3],[8,1,8,3],[9,1,9,3],[10,1,10,3],[2,0,2,5],[3,0,3,5],[4,2,4,4],[5,0,5,1],[5,2,5,4]]}
["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 DE EMPRESA DE ENGENHARIA PARA SUPERVISÃO E APOIO À FISCALIZAÇÃO DURANTE OS SERVIÇOS DE EXECUÇÃO DAS OBRAS DA PONTE SOBRE O RIBEIRÃO ÁGUA LIMPA, VIAS DE ACESSO E INFRAESTRUTURA COMPLETA VISANDO A INTERLIGAÇÃO DAS RODOVIAS GO-173 E GO-324, NO MUNICÍPIO DE BRITÂNIA, NO ESTADO DE GOIÁS"},null,"CODEVASF (SEDE)",null,null,{"$f":"'PFP2.2_FatorKb'!F6","v":"SINAPI/GO"}]
["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":7,"n_rows":35,"n_cols":6,"rows_kept":35,"cut":false,"hidden":false,"merged":[[0,0,1,4],[30,0,30,5],[31,0,31,5],[32,0,32,5],[33,0,33,5],[34,0,34,5],[25,0,25,5],[26,0,26,5],[27,0,27,5],[28,0,28,5],[29,0,29,5],[16,1,16,3],[21,0,21,5],[22,0,22,5],[23,0,23,5],[24,0,24,5],[11,1,11,3],[12,1,12,3],[13,1,13,3],[14,1,14,3],[15,1,15,3],[6,1,6,2],[7,1,7,2],[8,1,8,2],[9,1,9,2],[10,1,10,2],[2,0,2,5],[3,0,3,5],[4,2,4,4],[5,0,5,1],[5,2,5,4]]}
["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 DE EMPRESA DE ENGENHARIA PARA SUPERVISÃO E APOIO À FISCALIZAÇÃO DURANTE OS SERVIÇOS DE EXECUÇÃO DAS OBRAS DA PONTE SOBRE O RIBEIRÃO ÁGUA LIMPA, VIAS DE ACESSO E INFRAESTRUTURA COMPLETA VISANDO A INTERLIGAÇÃO DAS RODOVIAS GO-173 E GO-324, NO MUNICÍPIO DE BRITÂNIA, NO ESTADO DE GOIÁS"},null,"CODEVASF (SEDE)",null,null,{"$f":"'PFP2.3_FatorKc'!F6","v":"SINAPI/GO"}]
["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":103003.540560857}]
["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":41536.032245938703}]
["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":10984.1346219558}]
["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":50483.373692962297}]
["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":41175.064183265502}]
["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":20326.18}]
["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":10163.09}]
["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":6775.39}]
["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":3387.7}]
["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":8,"n_rows":29,"n_cols":22,"rows_kept":29,"cut":false,"hidden":false,"merged":[[25,2,26,2],[27,1,28,2],[23,1,24,2],[14,1,15,1],[16,1,17,1],[18,1,19,1],[20,1,21,1],[4,2,5,2],[6,2,7,2],[8,2,9,2],[10,2,11,2],[12,2,13,2],[14,2,15,2],[16,2,17,2],[18,2,19,2],[20,2,21,2],[4,1,5,1],[6,1,7,1],[8,1,9,1],[10,1,11,1],[12,1,13,1]]}
[null,"CRONOGRAMA FÍSICO-FINANCEIRO"]
[]
[]
[null,null,null,"Mês 1","Mês 2","Mês 3","Mês 4","Mês 5","Mês 6","Mês 7","Mês 8","Mês 9","Mês 10","Mês 11","Mês 12","Mês 13","Mês 14","Mês 15","Mês 16","Mês 17","Mês 18"]
[null,{"$f":"PFP!D8","v":"Engenheiro Pleno"},{"$f":"PFP!K8","v":499508.65},{"$f":"D6*$C$5","v":27750.480555555601},{"$f":"E6*$C$5","v":27750.480555555601},27750.480555555601,27750.480555555601,27750.480555555601,27750.480555555601,27750.480555555601,27750.480555555601,27750.480555555601,{"$f":"M6*$C$5","v":27750.480555555601},27750.480555555601,27750.480555555601,27750.480555555601,27750.480555555601,27750.480555555601,27750.480555555601,27750.480555555601,{"$f":"U6*$C$5","v":27750.480555555601},{"$f":"SUM(D5:U5)","v":499508.65}]
[null,null,null,{"$f":"1/18","v":5.5555555555555601E-2},{"$f":"1/18","v":5.5555555555555601E-2},5.5555555555555601E-2,5.5555555555555601E-2,5.5555555555555601E-2,5.5555555555555601E-2,5.5555555555555601E-2,5.5555555555555601E-2,5.5555555555555601E-2,{"$f":"1/18","v":5.5555555555555601E-2},5.5555555555555601E-2,5.5555555555555601E-2,5.5555555555555601E-2,5.5555555555555601E-2,5.5555555555555601E-2,5.5555555555555601E-2,5.5555555555555601E-2,{"$f":"1/18","v":5.5555555555555601E-2},1]
[null,{"$f":"PFP!D9","v":"Técnico - Profissional Especial"},{"$f":"PFP!K9","v":123054.06},{"$f":"D8*$C$7","v":6836.3366666666698},{"$f":"E8*$C$7","v":6836.3366666666698},6836.3366666666698,6836.3366666666698,6836.3366666666698,6836.3366666666698,6836.3366666666698,6836.3366666666698,{"$f":"L8*$C$7","v":6836.3366666666698},6836.3366666666698,6836.3366666666698,6836.3366666666698,6836.3366666666698,6836.3366666666698,6836.3366666666698,6836.3366666666698,6836.3366666666698,6836.3366666666698,123054.06]
[null,null,null,5.5555555555555601E-2,{"$f":"1/18","v":5.5555555555555601E-2},5.5555555555555601E-2,5.5555555555555601E-2,5.5555555555555601E-2,5.5555555555555601E-2,5.5555555555555601E-2,5.5555555555555601E-2,5.5555555555555601E-2,{"$f":"1/18","v":5.5555555555555601E-2},5.5555555555555601E-2,5.5555555555555601E-2,5.5555555555555601E-2,5.5555555555555601E-2,5.5555555555555601E-2,5.5555555555555601E-2,5.5555555555555601E-2,5.5555555555555601E-2,1]
[null,{"$f":"PFP!D10","v":"Técnico Auxiliar (Laboratorista)"},{"$f":"PFP!K10","v":91597.75},{"$f":"D10*$C$9","v":5088.7638888888896},{"$f":"E10*$C$9","v":5088.7638888888896},5088.7638888888896,5088.7638888888896,5088.7638888888896,5088.7638888888896,5088.7638888888896,5088.7638888888896,{"$f":"L10*$C$9","v":5088.7638888888896},5088.7638888888896,5088.7638888888896,5088.7638888888896,5088.7638888888896,5088.7638888888896,5088.7638888888896,5088.7638888888896,{"$f":"T10*$C$9","v":5088.7638888888896},{"$f":"U10*$C$9","v":5088.7638888888896},91597.75]
[null,null,null,5.5555555555555601E-2,{"$f":"1/18","v":5.5555555555555601E-2},5.5555555555555601E-2,5.5555555555555601E-2,5.5555555555555601E-2,5.5555555555555601E-2,5.5555555555555601E-2,5.5555555555555601E-2,5.5555555555555601E-2,5.5555555555555601E-2,5.5555555555555601E-2,5.5555555555555601E-2,5.5555555555555601E-2,5.5555555555555601E-2,5.5555555555555601E-2,5.5555555555555601E-2,5.5555555555555601E-2,5.5555555555555601E-2,1]
[null,{"$f":"PFP!D11","v":"Relatório Semanal de Obras"},{"$f":"PFP!K11","v":43859.337439090901},{"$f":"D12*$C$11","v":2436.6298577272701},{"$f":"E12*$C$11","v":2436.6298577272701},2436.6298577272701,2436.6298577272701,2436.6298577272701,2436.6298577272701,2436.6298577272701,2436.6298577272701,{"$f":"L12*$C$11","v":2436.6298577272701},2436.6298577272701,2436.6298577272701,2436.6298577272701,2436.6298577272701,2436.6298577272701,2436.6298577272701,2436.6298577272701,2436.6298577272701,2436.6298577272701,43859.337439090901]
[null,null,null,{"$f":"1/18","v":5.5555555555555601E-2},5.5555555555555601E-2,5.5555555555555601E-2,5.5555555555555601E-2,5.5555555555555601E-2,5.5555555555555601E-2,5.5555555555555601E-2,5.5555555555555601E-2,5.5555555555555601E-2,5.5555555555555601E-2,5.5555555555555601E-2,5.5555555555555601E-2,5.5555555555555601E-2,5.5555555555555601E-2,5.5555555555555601E-2,5.5555555555555601E-2,5.5555555555555601E-2,5.5555555555555601E-2,1]
[null,{"$f":"PFP!D12","v":"Relatório de Avaliação de Projeto"},{"$f":"PFP!K12","v":52942.008111000003},{"$f":"D14*$C$13","v":2941.2226728333299},{"$f":"E14*$C$13","v":2941.2226728333299},2941.2226728333299,2941.2226728333299,2941.2226728333299,2941.2226728333299,2941.2226728333299,2941.2226728333299,{"$f":"L14*$C$13","v":2941.2226728333299},2941.2226728333299,2941.2226728333299,2941.2226728333299,2941.2226728333299,2941.2226728333299,2941.2226728333299,{"$f":"S14*$C$13","v":2941.2226728333299},{"$f":"T14*$C$13","v":2941.2226728333299},{"$f":"U14*$C$13","v":2941.2226728333299},52942.008111000003]
[null,null,null,{"$f":"1/18","v":5.5555555555555601E-2},5.5555555555555601E-2,5.5555555555555601E-2,5.5555555555555601E-2,5.5555555555555601E-2,5.5555555555555601E-2,5.5555555555555601E-2,5.5555555555555601E-2,5.5555555555555601E-2,5.5555555555555601E-2,5.5555555555555601E-2,5.5555555555555601E-2,5.5555555555555601E-2,5.5555555555555601E-2,5.5555555555555601E-2,5.5555555555555601E-2,5.5555555555555601E-2,5.5555555555555601E-2,1]
[null,{"$f":"PFP!D13","v":"Levantamento Topográfico"},{"$f":"PFP!K13","v":23564.930754000001},{"$f":"D16*$C$15","v":1309.16281966667},{"$f":"E16*$C$15","v":1309.16281966667},1309.16281966667,1309.16281966667,1309.16281966667,1309.16281966667,1309.16281966667,1309.16281966667,{"$f":"L16*$C$15","v":1309.16281966667},1309.16281966667,1309.16281966667,1309.16281966667,1309.16281966667,1309.16281966667,1309.16281966667,{"$f":"S16*$C$15","v":1309.16281966667},{"$f":"T16*$C$15","v":1309.16281966667},{"$f":"U16*$C$15","v":1309.16281966667},23564.930754000001]
[null,null,null,{"$f":"1/18","v":5.5555555555555601E-2},5.5555555555555601E-2,5.5555555555555601E-2,5.5555555555555601E-2,5.5555555555555601E-2,5.5555555555555601E-2,5.5555555555555601E-2,5.5555555555555601E-2,5.5555555555555601E-2,5.5555555555555601E-2,5.5555555555555601E-2,5.5555555555555601E-2,5.5555555555555601E-2,5.5555555555555601E-2,5.5555555555555601E-2,5.5555555555555601E-2,5.5555555555555601E-2,5.5555555555555601E-2,1]
[null,{"$f":"PFP!D14","v":"Veículo leve - 71 a 115 CV"},{"$f":"PFP!K14","v":66909.36},{"$f":"D18*$C$17","v":3717.1866666666701},{"$f":"E18*$C$17","v":3717.1866666666701},3717.1866666666701,3717.1866666666701,3717.1866666666701,3717.1866666666701,3717.1866666666701,3717.1866666666701,{"$f":"L18*$C$17","v":3717.1866666666701},{"$f":"M18*$C$17","v":3717.1866666666701},{"$f":"N18*$C$17","v":3717.1866666666701},{"$f":"O18*$C$17","v":3717.1866666666701},{"$f":"P18*$C$17","v":3717.1866666666701},3717.1866666666701,3717.1866666666701,3717.1866666666701,3717.1866666666701,3717.1866666666701,66909.36]
[null,null,null,{"$f":"1/18","v":5.5555555555555601E-2},5.5555555555555601E-2,5.5555555555555601E-2,5.5555555555555601E-2,5.5555555555555601E-2,5.5555555555555601E-2,5.5555555555555601E-2,5.5555555555555601E-2,5.5555555555555601E-2,5.5555555555555601E-2,5.5555555555555601E-2,5.5555555555555601E-2,5.5555555555555601E-2,5.5555555555555601E-2,5.5555555555555601E-2,5.5555555555555601E-2,5.5555555555555601E-2,5.5555555555555601E-2,1]
[null,{"$f":"PFP!D15","v":"Infraestrutura e Equipamentos de Escritório"},{"$f":"PFP!K15","v":75747.149999999994},{"$f":"D20*$C$19","v":4208.1750000000002},{"$f":"E20*$C$19","v":4208.1750000000002},4208.1750000000002,4208.1750000000002,4208.1750000000002,4208.1750000000002,4208.1750000000002,4208.1750000000002,{"$f":"L20*$C$19","v":4208.1750000000002},4208.1750000000002,4208.1750000000002,4208.1750000000002,4208.1750000000002,4208.1750000000002,4208.1750000000002,{"$f":"S20*$C$19","v":4208.1750000000002},{"$f":"T20*$C$19","v":4208.1750000000002},{"$f":"U20*$C$19","v":4208.1750000000002},75747.149999999994]
[null,null,null,{"$f":"1/18","v":5.5555555555555601E-2},5.5555555555555601E-2,5.5555555555555601E-2,5.5555555555555601E-2,5.5555555555555601E-2,5.5555555555555601E-2,5.5555555555555601E-2,5.5555555555555601E-2,5.5555555555555601E-2,5.5555555555555601E-2,5.5555555555555601E-2,5.5555555555555601E-2,5.5555555555555601E-2,5.5555555555555601E-2,5.5555555555555601E-2,5.5555555555555601E-2,5.5555555555555601E-2,5.5555555555555601E-2,1]
[null,{"$f":"PFP!D16","v":"Encargos Complementares Adicionais"},{"$f":"PFP!K16","v":74639.039999999994},{"$f":"D22*$C$21","v":4146.61333333333},{"$f":"E22*$C$21","v":4146.61333333333},4146.61333333333,4146.61333333333,4146.61333333333,4146.61333333333,4146.61333333333,4146.61333333333,{"$f":"L22*$C$21","v":4146.61333333333},{"$f":"M22*$C$21","v":4146.61333333333},{"$f":"N22*$C$21","v":4146.61333333333},{"$f":"O22*$C$21","v":4146.61333333333},{"$f":"P22*$C$21","v":4146.61333333333},4146.61333333333,4146.61333333333,4146.61333333333,4146.61333333333,4146.61333333333,74639.039999999994]
[null,null,null,{"$f":"1/18","v":5.5555555555555601E-2},5.5555555555555601E-2,5.5555555555555601E-2,5.5555555555555601E-2,5.5555555555555601E-2,5.5555555555555601E-2,5.5555555555555601E-2,5.5555555555555601E-2,5.5555555555555601E-2,5.5555555555555601E-2,5.5555555555555601E-2,5.5555555555555601E-2,5.5555555555555601E-2,5.5555555555555601E-2,5.5555555555555601E-2,5.5555555555555601E-2,5.5555555555555601E-2,5.5555555555555601E-2,1]
[]
[null,"NO MÊS",null,{"$f":"D5+D7+D9+D11+D13+D15+D17+D19+D21","v":58434.571461338397},58434.571461338397,58434.571461338397,58434.571461338397,58434.571461338397,58434.571461338397,58434.571461338397,58434.571461338397,{"$f":"L5+L7+L9+L11+L13+L15+L17+L19+L21","v":58434.571461338397},58434.571461338397,58434.571461338397,58434.571461338397,58434.571461338397,58434.571461338397,58434.571461338397,58434.571461338397,58434.571461338397,58434.571461338397,{"$f":"SUM(D24:U24)","v":1051822.2863040899}]
[null,null,null,{"$f":"D24/SUM($C$5:$C$22)","v":5.5555555555555601E-2},5.5555555555555601E-2,5.5555555555555601E-2,5.5555555555555601E-2,5.5555555555555601E-2,5.5555555555555601E-2,5.5555555555555601E-2,5.5555555555555601E-2,5.5555555555555601E-2,5.5555555555555601E-2,5.5555555555555601E-2,5.5555555555555601E-2,5.5555555555555601E-2,5.5555555555555601E-2,5.5555555555555601E-2,5.5555555555555601E-2,5.5555555555555601E-2,5.5555555555555601E-2,{"$f":"SUM(D25:U25)","v":1}]
[null,null,"DESEMBOLSO   (80% do Subproduto) ",{"$f":"D24*0.8","v":46747.657169070699},{"$f":"E24*0.8","v":46747.657169070699},46747.657169070699,46747.657169070699,46747.657169070699,46747.657169070699,46747.657169070699,{"$f":"K24*0.8","v":46747.657169070699},46747.657169070699,46747.657169070699,46747.657169070699,46747.657169070699,46747.657169070699,46747.657169070699,46747.657169070699,46747.657169070699,46747.657169070699,{"$f":"V24-SUM(D26:T26)","v":257112.11442989},{"$f":"SUM(D26:U26)","v":1051822.2863040899}]
[null,null,null,{"$f":"D26/SUM($C$5:$C$22)","v":4.4444444444444398E-2},4.4444444444444398E-2,4.4444444444444398E-2,4.4444444444444398E-2,4.4444444444444398E-2,4.4444444444444398E-2,4.4444444444444398E-2,4.4444444444444398E-2,4.4444444444444398E-2,4.4444444444444398E-2,4.4444444444444398E-2,4.4444444444444398E-2,4.4444444444444398E-2,4.4444444444444398E-2,4.4444444444444398E-2,4.4444444444444398E-2,4.4444444444444398E-2,0.24444444444444499,{"$f":"SUM(D27:U27)","v":1}]
[null,"ACUMULADO",null,{"$f":"D24","v":58434.571461338397},{"$f":"D28+E24","v":116869.142922677},175303.71438401501,233738.285845354,{"$f":"G28+H24","v":292172.85730669199},{"$f":"H28+I24","v":350607.42876803002},{"$f":"I28+J24","v":409042.00022936898},{"$f":"J28+K24","v":467476.571690707},{"$f":"K28+L24","v":525911.14315204497},584345.71461338399,642780.28607472195,701214.85753606097,759649.42899739905,818084.00045873795,876518.57192007604,934953.143381414,993387.71484275302,1051822.2863040899]
[null,null,null,{"$f":"D25","v":5.5555555555555601E-2},0.11111111111111099,0.16666666666666699,0.22222222222222199,0.27777777777777801,0.33333333333333298,0.38888888888888901,0.44444444444444497,{"$f":"K29+L25","v":0.5},0.55555555555555602,0.61111111111111105,0.66666666666666696,0.72222222222222199,0.77777777777777801,0.83333333333333404,0.88888888888888895,0.94444444444444497,1]

{"sheet":"CPU-VEICULO_Leve","index":9,"n_rows":84,"n_cols":33,"rows_kept":84,"cut":false,"hidden":false,"merged":[[49,9,49,20],[49,21,49,28],[1,0,1,3],[3,0,3,3],[4,0,4,2],[4,5,4,8],[5,0,5,3]]}
[]
["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.14663339980248699},{"$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.157223472795852},{"$f":"AVERAGE(M6:U6)","v":26.768888888888899},{"$f":"MEDIAN(M6:U6)","v":27.12},{"$nulls":9},{"$f":"_xlfn.STDEV.S(Y6:AG6)/AVERAGE(Y6:AG6)","v":0.16218949848342901},{"$f":"AVERAGE(Y6:AG6)","v":329.14444444444399},{"$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.768888888888899},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.14444444444399},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":1727.88820096473},null,63868,80150,88215,68665,null,null,""]
[null,null,"Custo Diário (R$):",{"$f":"D7/30","v":57.596273365491101}]
[null,null,"Custo Horário (R$):",{"$f":"D7/176","v":9.8175465963905406}]
["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.03485282884714E-2}]
["B2",null,"Juros s/depreciação/aluguel (B1xA4)",{"$f":"D16*D14","v":6.4167343218703197}]
["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.14}]
["D3",null,"Quilômetros rodados com um litro combustivel",{"$f":"(12.8+13.3+15.3+15)/4","v":14.1}]
["D4",null,"Combustivel    (D1/D3)*D2",{"$f":"(D22/D24)*D23","v":574.808510638298}]
["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.768888888888899}]
["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.940357260274}]
["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.14444444444399}]
["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.613223744292199}]
["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":1727.88820096473}]
[null,null,"Com Motorista (A4+B2+C2+D4+E6+F6+G1)",{"$f":"D14+D17+D20+D25+D32+D39+D41","v":1727.88820096473}]
["I",null,"Custo Direto p/ km Rodado"]
[null,null,"Sem Motorista",{"$f":"D43/D22","v":1.3090062128520701},{"$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.3090062128520701}]
["J",null,"Preço cobrado sem BDI",{"$f":"D43*(1+D5)","v":1727.88820096473}]
["J1",null,"Sem Motorista",{"$f":"D48","v":1727.88820096473}]
["J2",null,"Com Motorista",{"$f":"D44","v":1727.88820096473}]
[]
[]
["*",null,"Calculado com base na taxa SELIC JANEIRO/2025:",0.13150000000000001]
[]
["**",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.14]
[]
[{"$nulls":5},"https://precos.petrobras.com.br/sele%C3%A7%C3%A3o-de-estados-gasolina"]

{"sheet":"CPU ESCRIT. CONTAINER","index":10,"n_rows":17,"n_cols":4,"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"]
[null,"Material de limpeza e diarista",{"$f":"130.82+(123*4)","v":622.82000000000005},"10563/ORSE - E200300131/EMBASA"]
[null,"Energia ",180,"10555/ORSE"]
[null,"Mobilização e Desmobilização",{"$f":"1200*2/18","v":133.333333333333},"89.50.20/89.50.21/SUDECAP-MG"]
[null,"Água",394.99,"10554/ORSE"]
[null,"telefone/Internet",{"$f":"89","v":89},"10558/ORSE"]
[]
[]
[]
[null,"Custo Mensal:",{"$f":"SUM(C4:C13)","v":3169.2533333333299}]
[null,"Custo Mensal por pessoa:",{"$f":"C14/C17","v":792.31333333333396}]
[null,"Custo diário por pessoa:",{"$f":"C15/22","v":36.014242424242397}]
[null,"número de pessoas:",4]

{"sheet":"MDO -  DNIT","index":11,"n_rows":105,"n_cols":26,"rows_kept":105,"cut":false,"hidden":false,"merged":[[0,0,2,0],[0,1,2,1],[0,2,2,2],[0,3,1,3],[0,24,1,24],[0,4,1,5],[0,22,1,23],[0,6,0,15],[0,16,0,21],[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],[1,20,1,21]]}
["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.17}]
["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.8399999999999]
["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.8399999999999]
["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.8499999999999]
["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.04]
["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.04]
["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.05]
["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.67]
["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.43]
["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.54]
["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.99]
["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.5999999999999]
["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.6099999999999]
["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.99]
["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.99]
["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.1300000000001]
["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.1300000000001]
["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.1199999999999]
["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.04]
["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.22]
["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.22]
["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.3800000000001]
["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.3900000000001]
["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.3900000000001]
["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.01]
["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.01]
["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.01]
["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.8900000000001]
["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.8900000000001]
["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.92]
["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.92]
["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,1087.22]
["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,1087.22]
["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,1087.23]
["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.92]
["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.92]
["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.78]
["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.77]
["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.79]
["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.72]
["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.97]
["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.98]
["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.93]
["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.46]
["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.46]
["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.46]
["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.01]
["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.81]
["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.81]
["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.81]
["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.28]
["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.6400000000001]
["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.31]
["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.26]
["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.96}]
["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.72]
["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.24]
["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.55]
["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.92]
["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.1099999999999]
["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.71]
["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.43]
["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.82]
["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.81]
["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.9100000000001]
["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.9100000000001]
["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.9100000000001]
["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.94]
["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.95]
["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.96]
["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.6500000000001]
["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.8499999999999]
["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.8399999999999]
["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.68]
["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.42]
["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.55]
["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.0899999999999]
["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.31]
["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.32]
["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.6500000000001]
["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.8499999999999]
["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.8399999999999]
["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.31]
["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.31]
["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.31]
["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.65]
["Fonte: FGV IBRE",{"$nulls":24},0]

{"sheet":"C.G - DNIT","index":12,"n_rows":27,"n_cols":8,"rows_kept":27,"cut":false,"hidden":false,"merged":[[24,3,24,4],[25,3,25,4],[3,1,4,1],[5,1,9,1],[15,1,16,1],[17,1,18,1],[19,1,23,1],[24,1,25,1],[3,2,4,2],[3,3,4,3],[3,4,4,4],[18,3,18,4],[19,3,19,4],[20,3,20,4],[21,3,21,4],[22,3,22,4],[3,5,3,6],[14,3,14,4],[15,3,15,4],[16,3,16,4],[17,3,17,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":"AUX - MOBILIÁRIO","index":13,"n_rows":71,"n_cols":7,"rows_kept":71,"cut":false,"hidden":false,"merged":[[0,0,3,5],[4,0,5,5],[7,1,7,4],[44,0,44,6],[70,0,70,6],[7,0,8,0],[7,5,8,5]]}
[]
[]
[]
[]
["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:E17)","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,4,{"$f":"C13*D13","v":1380}]
["Cadeira Giratória","11534/ORSE",280,5,{"$f":"C14*D14","v":1400}]
["Armário Escritório","Cotação",{"$f":"G42","v":574.99},1,{"$f":"C15*D15","v":574.99}]
[]
[]
[]
[]
[]
[]
["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(A40:E40)/AVERAGE(A40:A40)","v":6.2800886844130696E-2}]
[541.5,620.76,541.5,591.20000000000005,579.99,"Média=",{"$f":"AVERAGE(A40:E40)","v":574.99}]
[{"$nulls":5},"Mediana=",{"$f":"MEDIAN(A40:E40)","v":579.99}]
[{"$nulls":5},"Menor=",{"$f":"SMALL(G40:G41,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"]
["Aparelho Telefone"]
{"$rows_empty":18}
["Cotação 1","Cotação 2","Cotação 3","Cotação 4","Cotação 5","CV=",{"$f":"_xlfn.STDEV.S(A66:E66)/AVERAGE(A66:A66)","v":0.17423053278387299}]
[122,159.99,138.88,175,163.93,"Média=",{"$f":"AVERAGE(A66:E66)","v":151.96}]
[{"$nulls":5},"Mediana=",{"$f":"MEDIAN(A66:E66)","v":159.99}]
[{"$nulls":5},"Menor=",{"$f":"SMALL(G66:G67,1)","v":151.96}]
["Data da Pesquisa: 20/01/2025"]
[]
["https://www.google.com/search?sca_esv=3c12e2eb7b7f70e3&tbm=shop&q=telefone+com+identificador+de+chamadas&tbs=mr:1,price:1,ppr_min:150,ppr_max:300&sa=X&ved=0ahUKEwjRubuz9ISLAxUtBbkGHaiyFkQQvSsIrwkoAQ&biw=1455&bih=695&dpr=1.1"]

{"sheet":"AUX - NOTEBOOK","index":14,"n_rows":47,"n_cols":10,"rows_kept":47,"cut":false,"hidden":false,"merged":[[0,0,3,7],[4,0,5,7],[7,1,7,4],[7,5,7,6],[46,0,46,8],[72,0,72,8],[7,0,8,0],[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.0571428571402},1.5,12,0.25,{"$f":"ROUND((A10*(100%-D10))/(B10*C10),2)","v":108.29},0.05,{"$f":"ROUND((F10*A10)/12,2)","v":10.83},{"$f":"E10+G10","v":119.12}]
[]
["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.0571428571402},1,{"$f":"C13*D13","v":2599.0571428571402}]
{"$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.166034722599087}]
[2990,2179,2950,1999.02,2276.39,2999.99,2799,null,"Média=",{"$f":"AVERAGE(A42:G42)","v":2599.0571428571402}]
[{"$nulls":8},"Mediana=",{"$f":"MEDIAN(A42:G42)","v":2799}]
[{"$nulls":8},"Menor=",{"$f":"SMALL(J42:J43,1)","v":2599.0571428571402}]
[]
["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":15,"n_rows":47,"n_cols":8,"rows_kept":47,"cut":false,"hidden":false,"merged":[[0,0,3,7],[4,0,5,7],[7,1,7,4],[7,5,7,6],[46,0,46,8],[72,0,72,8],[7,0,8,0],[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.2280000000001},1.5,12,0.25,{"$f":"ROUND((A10*(100%-D10))/(B10*C10),2)","v":63.68},0.05,{"$f":"ROUND((F10*A10)/12,2)","v":6.37},{"$f":"E10+G10","v":70.05}]
[]
["Item","Código","Preço Un.","Quantidade","Custo de Aquisição"]
["Impressora Laser Colorida Multifuncional","Cotação",{"$f":"G43","v":1528.2280000000001},1,{"$f":"C13*D13","v":1528.2280000000001}]
{"$rows_empty":9}
["Impressora Laser Multifuncional"]
{"$rows_empty":16}
[{"$nulls":5},"CV=",{"$f":"_xlfn.STDEV.S(A42:E42)/AVERAGE(A42:E42)","v":0.13105129699165199}]
["Cotação 1","Cotação 2","Cotação 3","Cotação 4","Cotação 5","Média=",{"$f":"AVERAGE(A42:E42)","v":1528.2280000000001}]
[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.2280000000001}]
[]
[]
["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"]