{"text_format":"2","workbook":"xlsx","n_sheets":15,"sheets":["Planilha Resumo ","PFP","PFP2.1_FatorKa","PFP2.2_FatorKb","PFP2.3_FatorKc","PFP3_FatorKd","CRO1_Ins-Pro","CRO2_Ins-Mes","Cronograma","CPU HOSPEDAGEM","CPU-VEICULO_PickUp","Cotação Voos","PFS-X -Equipamentos","MDO_DNIT","COT. VANT"],"not_rendered":{"charts":0,"images":27,"macros":0,"external_links":51,"defined_names":15245,"comments":4,"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":"Planilha Resumo ","index":0,"n_rows":42,"n_cols":10,"rows_kept":42,"cut":false,"hidden":false,"merged":[[12,0,12,3]]}
[null,null,null,"Data base : Out/2024"]
[null,null,null,"Período de referência:"]
[null,null,null,"SINAPI Jun/2024"]
[null,null,null,"ORSE Jul/2024"]
[null,null,null,"SICRO Jul/2024"]
[null,null,null,"EMBASA Jul/2024"]
[]
["Itens","Serviços","Unidade","Quantidade","Preço Unitário (R$)","Preço (R$)",null,"Hectares","10% Hectares","Hectares"]
["Item 1 - DF, GO, MT e TO","Serviços de apoio à fiscalização. Veiculo Pick-up Cab.dupla 2.8 4x4 Diesel. Engenheiro,Técnico e Auxiliar","Semana",96,{"$f":"F9/D9","v":16581.013125000001},{"$f":"'CRO1_Ins-Pro'!H22","v":1591777.26},{"$f":"F9*0.1","v":159177.72600000002},30000,{"$f":"H9*0.1","v":3000},500]
["Item 2 - MG e BA","Serviços de apoio à fiscalização. Veiculo Pick-up Cab.dupla 2.8 4x4 Diesel. Engenheiro,Técnico e Auxiliar","Semana",96,{"$f":"F10/D10","v":16581.013125000001},{"$f":"'CRO1_Ins-Pro'!I22","v":1591777.26},{"$f":"F10*0.1","v":159177.72600000002},45000,{"$f":"H10*0.1","v":4500},500]
["Item 3 - SE, AL, PE, PB, RN, CE e PI","Serviços de apoio à fiscalização. Veiculo Pick-up Cab.dupla 2.8 4x4 Diesel. Engenheiro,Técnico e Auxiliar","Semana",96,16581.013125000001,{"$f":"'CRO1_Ins-Pro'!J22","v":1591777.26},159177.72600000002,55000,{"$f":"H11*0.1","v":5500},500]
["Item 4 - MA, PA e AP ","Serviços de apoio à fiscalização. Veiculo Pick-up Cab.dupla 2.8 4x4 Diesel. Engenheiro,Técnico e Auxiliar","Semana",96,16581.013125000001,{"$f":"'CRO1_Ins-Pro'!K22","v":1591777.26},159177.72600000002,40000,{"$f":"H12*0.1","v":4000},500]
[{"$nulls":4},"Preço Total (R$)",{"$f":"'CRO1_Ins-Pro'!L22","v":6367109.04},{"$f":"SUM(G9:G12)","v":636710.9040000001},{"$f":"SUM(H9:H12)","v":170000},{"$f":"SUM(I9:I12)","v":17000},{"$f":"I13*0.1","v":1700}]
["OBSERVAÇÃO:"]
["Grupo - Engenheiro Júnior, Técnico ambiental/geoprocessamento, Auxiliar de topografia/Auxiliar"]
["*Engenheiro Pleno e Secretária auxiliam e coordena os grupos."]
[]
[]
[]
[]
[{"$nulls":7},"Categoria ","Unidade","Quantidade"]
[{"$nulls":7},"Engenheiro pleno","Mês",24]
[{"$nulls":7},"Engenheiro júnior ","Mês",96]
[{"$nulls":7},"Técnico ambiental/geoprocessamento ","Mês",96]
[{"$nulls":7},"Auxiliar/Auxiliar de topografia","Mês",96]
[{"$nulls":7},"Auxiliar administrativo ","Mês",24]
[]
[]
[]
[{"$nulls":7},"Equipamento  ","Unidade","Quantidade"]
[{"$nulls":7},"Pick-up Cab.dupla 2.8 4x4 Diesel","Mês",4]
[{"$nulls":7},"Aparelho GPS Garmin MAP6","Mês",4]
[{"$nulls":7},"Aparelho Kit Receptores GNSS RTK ","Mês",4]
[{"$nulls":7},"Drone","Mês",4]
[{"$nulls":7},"Notebook  - (Core i7, 4Gb RAM, 1Tb)","Mês",4]
[]
[{"$nulls":7},"Descrição   ","Unidade","Quantidade"]
[{"$nulls":7},"Pick-up Cab. Dupla 2.8 4x4 Diesel","Dias",1920]
[{"$nulls":7},"Aparelho GPS Garmin MAP6","Mês",96]
[{"$nulls":7},"Aparelho Kit Receptores GNSS RTK ","Mês",96]
[{"$nulls":7},"Drone","Mês",96]
[{"$nulls":7},"Notebook - (Core i7, 4Gb RAM, 1Tb)","Mês",96]

{"sheet":"PFP","index":1,"n_rows":45,"n_cols":27,"rows_kept":45,"cut":false,"hidden":false,"merged":[[27,9,27,12],[27,1,27,8],[26,9,26,12],[26,1,26,8],[34,1,34,12],[28,1,28,8],[28,9,28,12],[31,1,31,12],[30,1,30,12],[42,1,42,12],[35,1,35,12],[37,1,37,12],[29,1,29,12],[36,1,36,12],[32,1,32,12],[38,1,38,12],[39,1,39,12],[40,1,40,12],[41,1,41,12],[33,1,33,12],[0,1,1,10],[4,7,4,10],[0,11,0,12],[1,11,1,12],[4,11,4,12],[2,1,2,12],[3,1,3,12],[4,1,4,6],[4,23,4,26],[5,23,5,26],[5,11,5,12],[5,7,5,10],[25,1,25,8],[25,9,25,12],[5,1,5,6],[24,1,24,8],[24,9,24,12]]}
[null,"PROPOSTA FINANCEIRA DO PROJETO",{"$nulls":9},"CODIGO:"]
[{"$nulls":11},"PFP"]
[null,"NOME DA CONSULTORA:"]
[]
[null,"PROJETO:",{"$nulls":5},"CONTRATANTE:",null,null,null,"BASE:",{"$nulls":11},"Memória de Cálculo Equipe Técnica"]
[null,"Apoio à fiscalização e supervisão técnica dos serviços de revitalização na SEDE",{"$nulls":5},"CODEVASF (SEDE)",null,null,null,"2024-10-01",{"$nulls":11},"Atividades e Prazos"]
[null,"Base","Cod2","Cod3","Código","Categoria / Insumo","Uni","Qde","CUD","PU","FatorK","CT","PT","Encargos COMP E ADICIONAIS","SOCIAIS","TOTAIS",null,"Encargos Comp e Adicionais",{"$nulls":5},"Profissional","Quantidade","Prazo Mês","Lotação"]
[{"$nulls":6},"mês",{"$f":"'CRO1_Ins-Pro'!D5","v":0},0,{"$f":"ROUND(K8*I8,2)","v":0},0,{"$f":"ROUND(H8*I8,2)","v":0},{"$f":"ROUND(H8*J8,2)","v":0},{"$f":"P8-O8","v":1026.8900000000012},13451.98,14478.87,null,{"$f":"VLOOKUP(E8,MDO_DNIT!$A:$Z,26,0)","v":{"$error":"#N/A"}},{"$nulls":5},"Profissional","Quantidade","Prazo Mês","Lotação"]
[{"$nulls":6},"mês",{"$f":"'CRO1_Ins-Pro'!D6","v":0},0,0,0,0,0,1030.1900000000005,11533.74,12563.93,null,{"$f":"VLOOKUP(E9,MDO_DNIT!$A:$Z,26,0)","v":{"$error":"#N/A"}},{"$nulls":5},"Eng. Coordenador",1,12,"Escritório Goiânia"]
[null,"SICRO","MO1","P2","P8066","Engenheiro pleno (P8066)","mês",{"$f":"'CRO1_Ins-Pro'!D7","v":24},{"$f":"VLOOKUP(E10,MDO_DNIT!$A:$Z,4,0)","v":12629.6},{"$f":"ROUND(K10*I10,2)","v":26889.68},{"$f":"'PFP2.1_FatorKa'!$E$36","v":2.1291000000000002},{"$f":"ROUND(H10*I10,2)","v":303110.40000000002},{"$f":"ROUND(H10*J10,2)","v":645352.31999999995},1030.1899999999987,8980.3700000000008,10010.56,null,{"$f":"VLOOKUP(E10,MDO_DNIT!$A:$Z,26,0)","v":1071.7099999999991},{"$nulls":5},"Engenheiro pleno (P8066)",1,24,"Coordenador Geral "]
[null,"SICRO","MO1","P3","P8065","Engenheiro júnior (P8065)","mês",{"$f":"'CRO1_Ins-Pro'!D8","v":96},{"$f":"VLOOKUP(E11,MDO_DNIT!$A:$Z,4,0)","v":12002},{"$f":"ROUND(K11*I11,2)","v":25553.46},{"$f":"'PFP2.1_FatorKa'!$E$36","v":2.1291000000000002},{"$f":"ROUND(H11*I11,2)","v":1152192},{"$f":"ROUND(H11*J11,2)","v":2453132.16},1030.1899999999987,8799.3700000000008,9829.56,null,{"$f":"VLOOKUP(E11,MDO_DNIT!$A:$Z,26,0)","v":1071.7000000000007},{"$nulls":5},"Engenheiro júnior (P8065)",4,24,"Coordenador de Campo - Analise e t"]
[null,"SICRO","MO1","T1","P8143","Técnico ambiental/geoprocessamento (P8143)","mês",{"$f":"'CRO1_Ins-Pro'!D9","v":96},{"$f":"VLOOKUP(E12,MDO_DNIT!$A:$Z,4,0)","v":2911.08},6197.98,{"$f":"'PFP2.1_FatorKa'!$E$36","v":2.1291000000000002},279463.67999999999,595006.07999999996,1070.1799999999998,2450.48,3520.66,null,{"$f":"VLOOKUP(E12,MDO_DNIT!$A:$Z,26,0)","v":1119.2200000000003},{"$nulls":5},"Técnico ambiental/geoprocessamento (P8143)",4,24,"Técnico de campo "]
[null,"SICRO","MO1","T3","P8028","Auxiliar de topografia/Auxiliar (P8028)","mês",{"$f":"'CRO1_Ins-Pro'!D10","v":96},{"$f":"VLOOKUP(E13,MDO_DNIT!$A:$Z,4,0)","v":1583.76},3371.98,{"$f":"'PFP2.1_FatorKa'!$E$36","v":2.1291000000000002},152040.95999999999,323710.08000000002,1070.1799999999998,2450.48,3520.66,null,{"$f":"VLOOKUP(E13,MDO_DNIT!$A:$Z,26,0)","v":1203.05},{"$nulls":5},"Auxiliar de topografia/Auxiliar (P8028)",4,24,"Auxiliar de campo"]
[null,"SICRO","MO1","A3","P8026","Auxiliar administrativo (P8026)","mês",{"$f":"'CRO1_Ins-Pro'!D11","v":24},{"$f":"VLOOKUP(E14,MDO_DNIT!$A:$Z,4,0)","v":1880.26},{"$f":"ROUND(K14*I14,2)","v":4003.26},{"$f":"'PFP2.1_FatorKa'!$E$36","v":2.1291000000000002},{"$f":"ROUND(H14*I14,2)","v":45126.239999999998},{"$f":"ROUND(H14*J14,2)","v":96078.24},1068.97,1887.43,2956.4,null,{"$f":"VLOOKUP(E14,MDO_DNIT!$A:$Z,26,0)","v":1152.1900000000003},{"$nulls":5},"Auxiliar administrativo (P8026)",1,24,"Apoio ao coordenador "]
[null,"SICRO","EC","ECA",null,"Encargos Comp. e Adicionais","mês",{"$f":"'CRO1_Ins-Pro'!D12","v":336},{"$f":"AVERAGE(R10:R14)","v":1123.5740000000001},{"$f":"ROUND(K15*I15,2)","v":1351.21},{"$f":"PFP3_FatorKd!$E$17","v":1.2025999999999999},{"$f":"ROUND(H15*I15,2)","v":377520.86},454006.56]
[null,"PROP","EC","AT2",null,"Auxilio Transporte Técnicos","mês",{"$f":"'CRO1_Ins-Pro'!D13","v":0},"Já incluso*",0,{"$f":"PFP3_FatorKd!$E$17","v":1.2025999999999999},0,0]
[null,"PROP","EC","AT3",null,"Auxilio Transporte Secretária","mês",{"$f":"'CRO1_Ins-Pro'!D14","v":0},"Já Incluso*",0,{"$f":"PFP3_FatorKd!$E$17","v":1.2025999999999999},0,0]
[null,"CODE","LO","V1",null,"Diárias","dia",{"$f":"'CRO1_Ins-Pro'!D15","v":3456},{"$f":"'CPU HOSPEDAGEM'!C19","v":219.85077777777778},264.39,{"$f":"PFP3_FatorKd!$E$17","v":1.2025999999999999},{"$f":"ROUND(H18*I18,2)","v":759804.29},{"$f":"ROUND(H18*J18,2)","v":913731.84}]
[null,"CODE","LO","V2",null,"Pick-up Cab.dupla 2.8 4x4 Diesel","dia",{"$f":"'CRO1_Ins-Pro'!D16","v":1920},{"$f":"'CPU-VEICULO_PickUp'!C11","v":325.62682583461901},391.6,{"$f":"PFP3_FatorKd!$E$17","v":1.2025999999999999},625203.51,{"$f":"ROUND(H19*J19,2)","v":751872}]
[null,"PROP","LO","V3",null,"Passagens Aéreas (ida e volta)","un",{"$f":"'CRO1_Ins-Pro'!D17","v":36},{"$f":"'Cotação Voos'!B104","v":1277.4166666666665},1536.22,{"$f":"PFP3_FatorKd!$E$17","v":1.2025999999999999},45987,55303.92]
[null,"PROP","LO","V4",null,"Equipamentos (Notebook, RTK, Drone, GPS)","mês",{"$f":"'CRO1_Ins-Pro'!D18","v":96},{"$f":"'PFS-X -Equipamentos'!F18","v":683.55156041666669},{"$f":"ROUND(K21*I21,2)","v":822.04},{"$f":"PFP3_FatorKd!$E$17","v":1.2025999999999999},{"$f":"ROUND(H21*I21,2)","v":65620.95},{"$f":"ROUND(H21*J21,2)","v":78915.839999999997}]
[{"$nulls":7},{"$f":"'CRO1_Ins-Pro'!D19","v":0},0,0,0,0,0]
[{"$nulls":7},{"$f":"'CRO1_Ins-Pro'!D20","v":0},0,0,0,0,{"$f":"ROUND(H23*J23,2)","v":0}]
[]
[null,"TOTAL DOS CUSTOS DIRETOS",{"$nulls":7},{"$f":"SUM(L8:L24)","v":3806069.8899999997}]
[null,"TOTAL DOS ENCARGOS E DESPESAS DIVERSAS",{"$nulls":7},{"$f":"J27-J25","v":2561039.1500000004}]
[null,"TOTAL DA PROPOSTA A PREÇO GLOBAL",{"$nulls":7},{"$f":"SUM(M8:M23)","v":6367109.04}]
[null,"TOTAL DA PROPOSTA A PREÇO UNITÁRIO"]
[null,"TOTAL DA PROPOSTA",{"$nulls":7},{"$f":"J27+J28","v":6367109.04}]
[null,"OBSERVAÇÃO:"]
[null,"*Encargos Complementares e adicionais já incluem auxílio transporte"]
[null,"Alocar os Insumos MO, com respectivo FatorK, dentro da categoria de vínculo contratual (celetista, autonomo, societario)"]
[null,"Uni - unidade de medição do insumo;"]
[null,"Qde - Quantidade do Insumo (não pode ocorrer alteração pela Licitante)"]
[null,"CUD - Custo Unitário Direto do Insumo (sem encargos, taxas e impostos, valor não pode ser maior que o Orçado pela Codevasf)"]
[null,"CT - Custo Total (sem encargos, taxas e impostos) - CT = Qde x CUD"]
[null,"FatorK - Taxa de Ressarcimento de Despesas e Encargos (detalhar composição nas Planilhas \"PFP2.1\", \"PFP2.2\", \"PFP3\")"]
[null,"PU - Preço Unitário do Insumo (incluído encargos, taxas e impostos) - PU = CUD x FatorK"]
[null,"PT - Preço Total do Insumo (incluído encargos, taxas e impostos) - PT = Qde x PU"]
[null,"P - Profissionais nível superior nas áreas de Engenharia, Química, Arquitetura, Agronomia e Veterinária, conforme disposições da Lei 4.950-A/66"]
[null,"S - Profissionais de nível superior nas demais áreas de atuação, incluindo Arqueólogo, Biólogo, Geógrafo e Sociólogo"]
[null,"T - Profissionais de nível médio técnico nas diversas áreas de atuação"]
[null,"A - Profissionais de nível médio de apoio técnico-administrativo"]
[]
[null,"Observações: "]

{"sheet":"PFP2.1_FatorKa","index":2,"n_rows":41,"n_cols":6,"rows_kept":41,"cut":false,"hidden":false,"merged":[[35,1,35,3],[6,1,6,3],[40,0,40,5],[39,0,39,5],[38,0,38,5],[37,0,37,5],[22,1,22,3],[29,1,29,3],[30,1,30,3],[28,1,28,3],[25,1,25,3],[26,1,26,3],[27,1,27,3],[33,1,33,3],[31,1,31,3],[32,1,32,3],[34,1,34,3],[0,0,1,4],[2,0,2,5],[5,0,5,1],[5,2,5,4],[4,2,4,4],[3,0,3,5],[24,1,24,3],[7,1,7,3],[17,1,17,3],[8,1,8,3],[13,1,13,3],[14,1,14,3],[15,1,15,3],[18,1,18,3],[19,1,19,3],[20,1,20,3],[21,1,21,3],[23,1,23,3],[9,1,9,3],[10,1,10,3],[11,1,11,3],[12,1,12,3]]}
["DETALHAMENTO DOS ENCARGOS SOCIAIS: Ka",{"$nulls":4},"CODIGO:"]
[{"$nulls":5},"PFP-2.1"]
["NOME DA CONSULTORA:"]
[]
["PROJETO:",null,"CONTRATANTE:",null,null,{"$f":"PFP!L5","v":"BASE:"}]
[{"$f":"PFP!B6","v":"Apoio à fiscalização e supervisão técnica dos serviços de revitalização na SEDE"},null,"CODEVASF (SEDE)",null,null,"SINAPI/DF  Jun/2024"]
["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!$C$8:$C$24,\"MO1\",PFP!$L$8:$L$24),2)","v":730270.78}]
["A1","INSS",null,null,0.2,{"$f":"ROUND(E9*SUMIF(PFP!$C$8:$C$24,\"MO1\",PFP!$L$8:$L$24),2)","v":386386.66}]
["A2","SESI",null,null,1.4999999999999999E-2,{"$f":"ROUND(E10*SUMIF(PFP!$C$8:$C$24,\"MO1\",PFP!$L$8:$L$24),2)","v":28979}]
["A3","SENAI",null,null,0.01,{"$f":"ROUND(E11*SUMIF(PFP!$C$8:$C$24,\"MO1\",PFP!$L$8:$L$24),2)","v":19319.330000000002}]
["A4","INCRA",null,null,2E-3,{"$f":"ROUND(E12*SUMIF(PFP!$C$8:$C$24,\"MO1\",PFP!$L$8:$L$24),2)","v":3863.87}]
["A5","SEBRAE",null,null,6.0000000000000001E-3,{"$f":"ROUND(E13*SUMIF(PFP!$C$8:$C$24,\"MO1\",PFP!$L$8:$L$24),2)","v":11591.6}]
["A6","Salário Educação",null,null,2.5000000000000001E-2,{"$f":"ROUND(E14*SUMIF(PFP!$C$8:$C$24,\"MO1\",PFP!$L$8:$L$24),2)","v":48298.33}]
["A7","Seguro Contra Acidentes de Trabalho",null,null,0.03,{"$f":"ROUND(E15*SUMIF(PFP!$C$8:$C$24,\"MO1\",PFP!$L$8:$L$24),2)","v":57958}]
["A8","FGTS",null,null,0.08,{"$f":"ROUND(E16*SUMIF(PFP!$C$8:$C$24,\"MO1\",PFP!$L$8:$L$24),2)","v":154554.66}]
["A9","SECONCI",null,null,0.01,{"$f":"ROUND(E17*SUMIF(PFP!$C$8:$C$24,\"MO1\",PFP!$L$8:$L$24),2)","v":19319.330000000002}]
["B"," ENCARGOS SOCIAIS QUE RECEBEM INCIDÊNCIA DE \"A\"",null,null,{"$f":"ROUND(SUM(E19:E25),4)","v":0.16239999999999999},{"$f":"ROUND(E18*SUMIF(PFP!$C$8:$C$24,\"MO1\",PFP!$L$8:$L$24),2)","v":313745.96000000002}]
["B3","Auxílio Enfermidade",null,null,6.4000000000000003E-3,{"$f":"ROUND(E19*SUMIF(PFP!$C$8:$C$24,\"MO1\",PFP!$L$8:$L$24),2)","v":12364.37}]
["B4","13º Salário",null,null,8.3299999999999999E-2,{"$f":"ROUND(E20*SUMIF(PFP!$C$8:$C$24,\"MO1\",PFP!$L$8:$L$24),2)","v":160930.04}]
["B5","Licença Paternidade",null,null,4.0000000000000002E-4,{"$f":"ROUND(E21*SUMIF(PFP!$C$8:$C$24,\"MO1\",PFP!$L$8:$L$24),2)","v":772.77}]
["B6","Faltas Justificadas",null,null,5.5999999999999999E-3,{"$f":"ROUND(E22*SUMIF(PFP!$C$8:$C$24,\"MO1\",PFP!$L$8:$L$24),2)","v":10818.83}]
["B8","Auxílio Acidente de Trabalho",null,null,8.0000000000000004E-4,{"$f":"ROUND(E23*SUMIF(PFP!$C$8:$C$24,\"MO1\",PFP!$L$8:$L$24),2)","v":1545.55}]
["B9","Férias Gozadas",null,null,6.5600000000000006E-2,{"$f":"ROUND(E24*SUMIF(PFP!$C$8:$C$24,\"MO1\",PFP!$L$8:$L$24),2)","v":126734.82}]
["B10","Salário Maternidade",null,null,2.9999999999999997E-4,{"$f":"ROUND(E25*SUMIF(PFP!$C$8:$C$24,\"MO1\",PFP!$L$8:$L$24),2)","v":579.58000000000004}]
["C"," ENCARGOS SOCIAIS QUE NÃO RECEBEM INCIDÊNCIA DE \"A\"",null,null,{"$f":"ROUND(SUM(E27:E31),4)","v":9.5699999999999993E-2},{"$f":"ROUND(E26*SUMIF(PFP!$C$8:$C$24,\"MO1\",PFP!$L$8:$L$24),2)","v":184886.01}]
["C1","Aviso Prévio Indenizado",null,null,3.2399999999999998E-2,{"$f":"ROUND(E27*SUMIF(PFP!$C$8:$C$24,\"MO1\",PFP!$L$8:$L$24),2)","v":62594.64}]
["C2","Aviso Prévio Trabalhado",null,null,8.0000000000000004E-4,{"$f":"ROUND(E28*SUMIF(PFP!$C$8:$C$24,\"MO1\",PFP!$L$8:$L$24),2)","v":1545.55}]
["C3","Férias Indenizadas",null,null,3.5900000000000001E-2,{"$f":"ROUND(E29*SUMIF(PFP!$C$8:$C$24,\"MO1\",PFP!$L$8:$L$24),2)","v":69356.399999999994}]
["C4","Depósito Rescisão Sem Justa Causa",null,null,2.3900000000000001E-2,{"$f":"ROUND(E30*SUMIF(PFP!$C$8:$C$24,\"MO1\",PFP!$L$8:$L$24),2)","v":46173.21}]
["C5","Indenização Adicional",null,null,2.7000000000000001E-3,{"$f":"ROUND(E31*SUMIF(PFP!$C$8:$C$24,\"MO1\",PFP!$L$8:$L$24),2)","v":5216.22}]
["D"," REINCIDÊNCIAS",null,null,{"$f":"ROUND(SUM(E33:E34),4)","v":6.4299999999999996E-2},{"$f":"ROUND(E32*SUMIF(PFP!$C$8:$C$24,\"MO1\",PFP!$L$8:$L$24),2)","v":124223.31}]
["D1","Reincidência de \"A\" sobre \"B\"",null,null,6.1400000000000003E-2,{"$f":"ROUND(E33*SUMIF(PFP!$C$8:$C$24,\"MO1\",PFP!$L$8:$L$24),2)","v":118620.7}]
["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!$C$8:$C$24,\"MO1\",PFP!$L$8:$L$24),2)","v":5602.61}]
["K1a","ENCARGOS SOCIAIS",null,null,{"$f":"ROUND(E8+E18+E26+E32,4)","v":0.70040000000000002},{"$f":"ROUND(E35*SUMIF(PFP!$C$8:$C$24,\"MO1\",PFP!$L$8:$L$24),2)","v":1353126.07}]
["Ka","TAXA DE RESSARCIMENTO DE DESPESAS E ENCARGOS SOBRE MO1",null,null,{"$f":"ROUND((1+E35+PFP3_FatorKd!E13)*(1+PFP3_FatorKd!E12)*(1+PFP3_FatorKd!E8),4)","v":2.1291000000000002}]
["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":3,"n_rows":40,"n_cols":6,"rows_kept":40,"cut":false,"hidden":false,"merged":[[27,1,27,3],[28,1,28,3],[29,1,29,3],[22,1,22,3],[23,1,23,3],[24,1,24,3],[25,1,25,3],[26,1,26,3],[6,1,6,3],[12,1,12,3],[13,1,13,3],[39,0,39,5],[36,0,36,5],[37,0,37,5],[38,0,38,5],[31,1,31,3],[32,1,32,3],[33,1,33,3],[34,1,34,3],[18,1,18,3],[30,1,30,3],[19,1,19,3],[20,1,20,3],[21,1,21,3],[0,0,1,4],[2,0,2,5],[3,0,3,5],[4,2,4,4],[5,0,5,1],[5,2,5,4],[7,1,7,3],[16,1,16,3],[17,1,17,3],[8,1,8,3],[9,1,9,3],[10,1,10,3],[14,1,14,3],[15,1,15,3],[11,1,11,3]]}
["DETALHAMENTO DOS ENCARGOS SOCIAIS: Kb",{"$nulls":4},"CODIGO:"]
[{"$nulls":5},"PFP-2.2"]
["NOME DA CONSULTORA:"]
[]
["PROJETO:",null,"CONTRATANTE:",null,null,{"$f":"'PFP2.1_FatorKa'!F5","v":"BASE:"}]
[{"$f":"PFP!B6","v":"Apoio à fiscalização e supervisão técnica dos serviços de revitalização na SEDE"},null,"CODEVASF (SEDE)",null,null,{"$f":"'PFP2.1_FatorKa'!F6","v":"SINAPI/DF  Jun/2024"}]
["Cod","DESCRIÇÃO",null,null,"%","R$"]
["A","ENCARGOS SOCIAIS BÁSICOS",null,null,{"$f":"ROUND(SUM(E9:E16),4)","v":0.2},{"$f":"ROUND(E8*SUMIF(PFP!$C$8:$C$24,\"MO2\",PFP!$L$8:$L$24),2)","v":0}]
["A1","INSS",null,null,0.2,{"$f":"ROUND(E9*SUMIF(PFP!$C$8:$C$24,\"MO2\",PFP!$L$8:$L$24),2)","v":0}]
["A2","SESI",null,null,0,{"$f":"ROUND(E10*SUMIF(PFP!$C$8:$C$24,\"MO2\",PFP!$L$8:$L$24),2)","v":0}]
["A3","SENAI",null,null,0,{"$f":"ROUND(E11*SUMIF(PFP!$C$8:$C$24,\"MO2\",PFP!$L$8:$L$24),2)","v":0}]
["A4","INCRA",null,null,0,{"$f":"ROUND(E12*SUMIF(PFP!$C$8:$C$24,\"MO2\",PFP!$L$8:$L$24),2)","v":0}]
["A5","SEBRAE",null,null,0,{"$f":"ROUND(E13*SUMIF(PFP!$C$8:$C$24,\"MO2\",PFP!$L$8:$L$24),2)","v":0}]
["A6","Salário Educação",null,null,0,{"$f":"ROUND(E14*SUMIF(PFP!$C$8:$C$24,\"MO2\",PFP!$L$8:$L$24),2)","v":0}]
["A7","Seguro Contra Acidentes de Trabalho",null,null,0,{"$f":"ROUND(E15*SUMIF(PFP!$C$8:$C$24,\"MO2\",PFP!$L$8:$L$24),2)","v":0}]
["A8","FGTS",null,null,0,{"$f":"ROUND(E16*SUMIF(PFP!$C$8:$C$24,\"MO2\",PFP!$L$8:$L$24),2)","v":0}]
["B"," ENCARGOS SOCIAIS QUE RECEBEM INCIDÊNCIA DE \"A\"",null,null,{"$f":"ROUND(SUM(E18:E24),4)","v":0},{"$f":"ROUND(E17*SUMIF(PFP!$C$8:$C$24,\"MO2\",PFP!$L$8:$L$24),2)","v":0}]
["B3","Auxílio Enfermidade",null,null,0,{"$f":"ROUND(E18*SUMIF(PFP!$C$8:$C$24,\"MO2\",PFP!$L$8:$L$24),2)","v":0}]
["B4","13º Salário",null,null,0,{"$f":"ROUND(E19*SUMIF(PFP!$C$8:$C$24,\"MO2\",PFP!$L$8:$L$24),2)","v":0}]
["B5","Licença Paternidade",null,null,0,{"$f":"ROUND(E20*SUMIF(PFP!$C$8:$C$24,\"MO2\",PFP!$L$8:$L$24),2)","v":0}]
["B6","Faltas Justificadas",null,null,0,{"$f":"ROUND(E21*SUMIF(PFP!$C$8:$C$24,\"MO2\",PFP!$L$8:$L$24),2)","v":0}]
["B8","Auxílio Acidente de Trabalho",null,null,0,{"$f":"ROUND(E22*SUMIF(PFP!$C$8:$C$24,\"MO2\",PFP!$L$8:$L$24),2)","v":0}]
["B9","Férias Gozadas",null,null,0,{"$f":"ROUND(E23*SUMIF(PFP!$C$8:$C$24,\"MO2\",PFP!$L$8:$L$24),2)","v":0}]
["B10","Salário Maternidade",null,null,0,{"$f":"ROUND(E24*SUMIF(PFP!$C$8:$C$24,\"MO2\",PFP!$L$8:$L$24),2)","v":0}]
["C"," ENCARGOS SOCIAIS QUE NÃO RECEBEM INCIDÊNCIA DE \"A\"",null,null,{"$f":"ROUND(SUM(E26:E30),4)","v":0},{"$f":"ROUND(E25*SUMIF(PFP!$C$8:$C$24,\"MO2\",PFP!$L$8:$L$24),2)","v":0}]
["C1","Aviso Prévio Indenizado",null,null,0,{"$f":"ROUND(E26*SUMIF(PFP!$C$8:$C$24,\"MO2\",PFP!$L$8:$L$24),2)","v":0}]
["C2","Aviso Prévio Trabalhado",null,null,0,{"$f":"ROUND(E27*SUMIF(PFP!$C$8:$C$24,\"MO2\",PFP!$L$8:$L$24),2)","v":0}]
["C3","Férias Indenizadas",null,null,0,{"$f":"ROUND(E28*SUMIF(PFP!$C$8:$C$24,\"MO2\",PFP!$L$8:$L$24),2)","v":0}]
["C4","Depósito Rescisão Sem Justa Causa",null,null,0,{"$f":"ROUND(E29*SUMIF(PFP!$C$8:$C$24,\"MO2\",PFP!$L$8:$L$24),2)","v":0}]
["C5","Indenização Adicional",null,null,0,{"$f":"ROUND(E30*SUMIF(PFP!$C$8:$C$24,\"MO2\",PFP!$L$8:$L$24),2)","v":0}]
["D"," REINCIDÊNCIAS",null,null,{"$f":"ROUND(SUM(E32:E33),4)","v":0},{"$f":"ROUND(E31*SUMIF(PFP!$C$8:$C$24,\"MO2\",PFP!$L$8:$L$24),2)","v":0}]
["D1","Reincidência de \"A\" sobre \"B\"",null,null,{"$f":"ROUND(E8*E17,4)","v":0},{"$f":"ROUND(E32*SUMIF(PFP!$C$8:$C$24,\"MO2\",PFP!$L$8:$L$24),2)","v":0}]
["D2","Reincidência de \"A\" sobre Aviso Prévio Trabalhado e reincidência do FGTS sobre Aviso Prévio Indenizado",null,null,{"$f":"ROUND((E27*E8)+(E26*E16),4)","v":0},{"$f":"ROUND(E33*SUMIF(PFP!$C$8:$C$24,\"MO2\",PFP!$L$8:$L$24),2)","v":0}]
["K1b","ENCARGOS SOCIAIS",null,null,{"$f":"ROUND(E8+E17+E25+E31,4)","v":0.2},{"$f":"ROUND(E34*SUMIF(PFP!$C$8:$C$24,\"MO2\",PFP!$L$8:$L$24),2)","v":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.5273000000000001}]
["OBSERVAÇÃO: AUTÔNOMOS E EQUIVALENTES"]
["1 - DISCRIMINAR OS ENCARGOS SOCIAIS COM SEUS RESPECTIVOS PERCENTUAS TOTALIZANDO OS MESMOS. "]
["2 - APLICAR O % TOTAL P/ CALCULAR OS E. SOCIAIS INCIDENTES NA MÃO-DE-OBRA AUTONÔMOS"]
["Kb - Taxa de Ressarcimento de Despesas e Encargos sobre a Mão de Obra AUTONÔMA (incide apenas no Insumo Codigo MO2)"]
["Kb = (1 + K1 + K2) x (1 + K3) x (1 + K4)"]

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

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

{"sheet":"CRO1_Ins-Pro","index":6,"n_rows":89,"n_cols":12,"rows_kept":89,"cut":false,"hidden":false,"merged":[[87,0,87,7],[86,0,86,8],[21,0,22,0],[21,1,22,1],[2,0,3,0],[2,1,3,1],[2,2,3,2],[2,3,3,3],[2,4,3,4],[2,5,3,5],[2,7,2,10],[2,6,3,6]]}
["INSUMOS POR ETAPA/PRODUTO",{"$nulls":9},"CÓDIGO:"]
[{"$nulls":10},"CRO-1"]
["Cod.","Categoria / Insumo","Uni","Qde","CUD","PU","FatorK","Apoio à fiscalização "]
[{"$nulls":7},"Item 1","Item  2","Item  3","Item  4"]
[{"$f":"PFP!D8","v":0},null,"mês",{"$f":"SUM(H5:K5)","v":0},{"$f":"PFP!I8","v":0},{"$f":"PFP!J8","v":0},{"$f":"PFP!K8","v":0}]
[{"$f":"PFP!D9","v":0},null,"mês",0,{"$f":"PFP!I9","v":0},{"$f":"PFP!J9","v":0},{"$f":"PFP!K9","v":0}]
[{"$f":"PFP!D10","v":"P2"},{"$f":"PFP!F10","v":"Engenheiro pleno (P8066)"},"mês",24,{"$f":"PFP!I10","v":12629.6},{"$f":"PFP!J10","v":26889.68},{"$f":"PFP!K10","v":2.1291000000000002},{"$f":"'CRO2_Ins-Mes'!E7","v":6},{"$f":"'CRO2_Ins-Mes'!E24","v":6},{"$f":"'CRO2_Ins-Mes'!E40","v":6},{"$f":"'CRO2_Ins-Mes'!E56","v":6}]
[{"$f":"PFP!D11","v":"P3"},{"$f":"PFP!F11","v":"Engenheiro júnior (P8065)"},"mês",{"$f":"SUM(H8:K8)","v":96},{"$f":"PFP!I11","v":12002},{"$f":"PFP!J11","v":25553.46},{"$f":"PFP!K11","v":2.1291000000000002},{"$f":"'CRO2_Ins-Mes'!E8","v":24},{"$f":"'CRO2_Ins-Mes'!E25","v":24},{"$f":"'CRO2_Ins-Mes'!E41","v":24},{"$f":"'CRO2_Ins-Mes'!E57","v":24}]
[{"$f":"PFP!D12","v":"T1"},{"$f":"PFP!F12","v":"Técnico ambiental/geoprocessamento (P8143)"},"mês",{"$f":"SUM(H9:K9)","v":96},{"$f":"PFP!I12","v":2911.08},{"$f":"PFP!J12","v":6197.98},{"$f":"PFP!K12","v":2.1291000000000002},{"$f":"'CRO2_Ins-Mes'!E9","v":24},{"$f":"'CRO2_Ins-Mes'!E26","v":24},{"$f":"'CRO2_Ins-Mes'!E42","v":24},{"$f":"'CRO2_Ins-Mes'!E58","v":24}]
[{"$f":"PFP!D13","v":"T3"},{"$f":"PFP!F13","v":"Auxiliar de topografia/Auxiliar (P8028)"},"mês",96,{"$f":"PFP!I13","v":1583.76},{"$f":"PFP!J13","v":3371.98},{"$f":"PFP!K13","v":2.1291000000000002},{"$f":"'CRO2_Ins-Mes'!E10","v":24},{"$f":"'CRO2_Ins-Mes'!E27","v":24},{"$f":"'CRO2_Ins-Mes'!E43","v":24},{"$f":"'CRO2_Ins-Mes'!E59","v":24}]
[{"$f":"PFP!D14","v":"A3"},{"$f":"PFP!F14","v":"Auxiliar administrativo (P8026)"},"mês",24,{"$f":"PFP!I14","v":1880.26},{"$f":"PFP!J14","v":4003.26},{"$f":"PFP!K14","v":2.1291000000000002},{"$f":"'CRO2_Ins-Mes'!E11","v":6},{"$f":"'CRO2_Ins-Mes'!E28","v":6},{"$f":"'CRO2_Ins-Mes'!E44","v":6},{"$f":"'CRO2_Ins-Mes'!E60","v":6}]
[{"$f":"PFP!D15","v":"ECA"},{"$f":"PFP!F15","v":"Encargos Comp. e Adicionais"},"mês",{"$f":"SUM(H12:K12)","v":336},{"$f":"PFP!I15","v":1123.5740000000001},{"$f":"PFP!J15","v":1351.21},{"$f":"PFP!K15","v":1.2025999999999999},{"$f":"SUM(H5:H11)","v":84},{"$f":"SUM(I5:I11)","v":84},{"$f":"SUM(J5:J11)","v":84},84]
[{"$f":"PFP!D16","v":"AT2"},{"$f":"PFP!F16","v":"Auxilio Transporte Técnicos"},"mês",{"$f":"SUM(H13:H13)","v":0},{"$f":"PFP!I16","v":"Já incluso*"},{"$f":"PFP!J16","v":0},{"$f":"PFP!K16","v":1.2025999999999999}]
[{"$f":"PFP!D17","v":"AT3"},{"$f":"PFP!F17","v":"Auxilio Transporte Secretária"},"mês",0,{"$f":"PFP!I17","v":"Já Incluso*"},{"$f":"PFP!J17","v":0},{"$f":"PFP!K17","v":1.2025999999999999}]
[{"$f":"PFP!D18","v":"V1"},{"$f":"PFP!F18","v":"Diárias"},"dia",{"$f":"SUM(H15:K15)","v":3456},{"$f":"PFP!I18","v":219.85077777777778},{"$f":"PFP!J18","v":264.39},{"$f":"PFP!K18","v":1.2025999999999999},{"$f":"'CRO2_Ins-Mes'!E12","v":864},{"$f":"'CRO2_Ins-Mes'!E29","v":864},{"$f":"'CRO2_Ins-Mes'!E45","v":864},{"$f":"'CRO2_Ins-Mes'!E61","v":864}]
[{"$f":"PFP!D19","v":"V2"},{"$f":"PFP!F19","v":"Pick-up Cab.dupla 2.8 4x4 Diesel"},"dia",{"$f":"SUM(H16:K16)","v":1920},{"$f":"PFP!I19","v":325.62682583461901},{"$f":"PFP!J19","v":391.6},{"$f":"PFP!K19","v":1.2025999999999999},{"$f":"'CRO2_Ins-Mes'!E13","v":480},{"$f":"'CRO2_Ins-Mes'!E30","v":480},{"$f":"'CRO2_Ins-Mes'!E46","v":480},{"$f":"'CRO2_Ins-Mes'!E62","v":480}]
[{"$f":"PFP!D20","v":"V3"},{"$f":"PFP!F20","v":"Passagens Aéreas (ida e volta)"},"um",{"$f":"SUM(H17:K17)","v":36},{"$f":"PFP!I20","v":1277.4166666666665},{"$f":"PFP!J20","v":1536.22},{"$f":"PFP!K20","v":1.2025999999999999},{"$f":"'CRO2_Ins-Mes'!E14","v":9},{"$f":"'CRO2_Ins-Mes'!E31","v":9},{"$f":"'CRO2_Ins-Mes'!E47","v":9},{"$f":"'CRO2_Ins-Mes'!E63","v":9}]
[{"$f":"PFP!D21","v":"V4"},{"$f":"PFP!F21","v":"Equipamentos (Notebook, RTK, Drone, GPS)"},"un",{"$f":"SUM(H18:K18)","v":96},{"$f":"PFP!I21","v":683.55156041666669},{"$f":"PFP!J21","v":822.04},{"$f":"PFP!K21","v":1.2025999999999999},{"$f":"'CRO2_Ins-Mes'!E15","v":24},{"$f":"'CRO2_Ins-Mes'!E32","v":24},{"$f":"'CRO2_Ins-Mes'!E48","v":24},{"$f":"'CRO2_Ins-Mes'!E64","v":24}]
[{"$f":"PFP!D22","v":0},{"$f":"PFP!F22","v":0},"un",{"$f":"SUM(H19:K19)","v":0},{"$f":"PFP!I22","v":0},{"$f":"PFP!J22","v":0},{"$f":"PFP!K22","v":0},{"$f":"'CRO2_Ins-Mes'!E16","v":0},{"$f":"'CRO2_Ins-Mes'!E33","v":0},{"$f":"'CRO2_Ins-Mes'!E49","v":0},{"$f":"'CRO2_Ins-Mes'!E65","v":0}]
[{"$f":"PFP!D23","v":0},{"$f":"PFP!F23","v":0},"un",{"$f":"SUM(H20:K20)","v":0},{"$f":"PFP!I23","v":0},{"$f":"PFP!J23","v":0},{"$f":"PFP!K23","v":0},{"$f":"'CRO2_Ins-Mes'!E17","v":0},{"$f":"'CRO2_Ins-Mes'!E34","v":0},{"$f":"'CRO2_Ins-Mes'!E50","v":0},{"$f":"'CRO2_Ins-Mes'!E66","v":0}]
[{"$f":"PFP!D24","v":0},{"$f":"PFP!F24","v":0},"un",0,{"$f":"PFP!I24","v":0},{"$f":"PFP!J24","v":0},{"$f":"PFP!K24","v":0},{"$f":"'CRO2_Ins-Mes'!E18","v":0},{"$f":"'CRO2_Ins-Mes'!E35","v":0},{"$f":"'CRO2_Ins-Mes'!E51","v":0},{"$f":"'CRO2_Ins-Mes'!E67","v":0}]
["TOTAL","VALOR TOTAL POR PRODUTO","R$",{"$f":"SUM(H22:K22)","v":6367109.04},null,null,null,{"$f":"SUMPRODUCT(F5:F19,H5:H19)","v":1591777.26},{"$f":"SUMPRODUCT(I5:I19,$F5:$F19)","v":1591777.26},1591777.26,1591777.26,{"$f":"SUM(H22:K22)","v":6367109.04}]
[null,null,"%",{"$f":"SUM(H23:K86)","v":1},null,null,null,{"$f":"ROUND(H22/$D$22,5)","v":0.25},0.25,0.25,0.25,{"$f":"SUM(H23:K23)","v":1}]
{"$rows_empty":62}
["OBSERVAÇÃO:"]
["P - Profissionais nível superior nas áreas de Engenharia, Química, Arquitetura, Agronomia e Veterinária, conforme disposições da Lei 4.950-A/66"]
["T - Profissionais de nível médio técnico nas diversas áreas de atuação"]
["A - Profissionais de nível médio de apoio técnico-administrativo"]

{"sheet":"CRO2_Ins-Mes","index":7,"n_rows":68,"n_cols":29,"rows_kept":68,"cut":false,"hidden":false,"merged":[[0,0,0,28],[1,5,1,28]]}
["CRONOGRAMA SIMPLIFICADO"]
[{"$nulls":5},"Relatórios Mensais de Andamento"]
["Cod1","Cod2","Produtos","Uni","Qde",1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24]
[null,null,"Relatórios Parcial ",{"$f":"PFP!G10","v":"mês"},{"$f":"SUM(F4:AC4)","v":96},4,4,4,4,4,4,4,4,4,4,4,4,4,4,4,4,4,4,4,4,4,4,4,4]
[null,null,"Relatórios  Final ",{"$f":"PFP!G11","v":"mês"},{"$f":"SUM(F5:AC5)","v":8},{"$nulls":11},4,{"$nulls":11},4]
["Cod1","Cod2","Insumos","Uni","Qde",1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24]
[1,{"$f":"PFP!D10","v":"P2"},{"$f":"PFP!F10","v":"Engenheiro pleno (P8066)"},{"$f":"PFP!G10","v":"mês"},{"$f":"SUM(F7:AC7)","v":6},0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25]
[1,{"$f":"PFP!D11","v":"P3"},{"$f":"PFP!F11","v":"Engenheiro júnior (P8065)"},{"$f":"PFP!G11","v":"mês"},24,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1]
[1,{"$f":"PFP!D12","v":"T1"},{"$f":"PFP!F12","v":"Técnico ambiental/geoprocessamento (P8143)"},{"$f":"PFP!G12","v":"mês"},24,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1]
[1,{"$f":"PFP!D13","v":"T3"},{"$f":"PFP!F13","v":"Auxiliar de topografia/Auxiliar (P8028)"},{"$f":"PFP!G13","v":"mês"},24,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1]
[1,{"$f":"PFP!D14","v":"A3"},{"$f":"PFP!F14","v":"Auxiliar administrativo (P8026)"},{"$f":"PFP!G14","v":"mês"},6,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25]
[1,{"$f":"PFP!D18","v":"V1"},{"$f":"PFP!F18","v":"Diárias"},{"$f":"PFP!G18","v":"dia"},864,{"$f":"SUM(F8:F10)*3*4","v":36},{"$f":"SUM(G8:G10)*3*4","v":36},36,36,36,36,36,36,36,36,36,36,36,36,36,36,36,36,36,36,36,36,36,36]
[1,{"$f":"PFP!D19","v":"V2"},{"$f":"PFP!F19","v":"Pick-up Cab.dupla 2.8 4x4 Diesel"},{"$f":"PFP!G19","v":"dia"},480,{"$f":"5*4","v":20},{"$f":"5*4","v":20},20,20,20,20,20,20,20,20,20,20,20,20,20,20,20,20,20,20,20,20,20,20]
[1,{"$f":"PFP!D20","v":"V3"},{"$f":"PFP!F20","v":"Passagens Aéreas (ida e volta)"},{"$f":"PFP!G20","v":"un"},9,{"$f":"(SUM(F8:F10))","v":3},{"$nulls":10},{"$f":"(SUM(Q8:Q10))","v":3},{"$nulls":11},{"$f":"(SUM(AC8:AC10))","v":3}]
[1,{"$f":"PFP!D21","v":"V4"},{"$f":"PFP!F21","v":"Equipamentos (Notebook, RTK, Drone, GPS)"},{"$f":"PFP!G21","v":"mês"},24,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1]
[1,null,null,{"$f":"PFP!G22","v":0},{"$f":"SUM(F16:AC16)","v":0}]
[1,{"$f":"PFP!D23","v":0},null,{"$f":"PFP!G23","v":0}]
[1,{"$f":"PFP!D24","v":0},{"$f":"PFP!F24","v":0},{"$f":"PFP!G24","v":0},0]
[1,null,"Item 1 - DF, GO, TO, MT",null,{"$f":"SUM(F19:AC19)","v":0}]
[]
["Cod1","Cod2","Insumos","Uni","Qde",1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24]
[]
[]
[2,"P2",{"$f":"C7","v":"Engenheiro pleno (P8066)"},"mês",{"$f":"SUM(F24:AC24)","v":6},0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25]
[2,"P3","Engenheiro júnior (P8065)","mês",24,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1]
[2,"T1","Técnico ambiental/geoprocessamento (P8143)","mês",24,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1]
[2,"D","Auxiliar de topografia/Auxiliar (P8028)","mês",24,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1]
[2,"A1","Auxiliar administrativo (P8026)","mês",6,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25]
[2,"V1","Diárias","dia",864,36,36,36,36,36,36,36,36,36,36,36,36,36,36,36,36,36,36,36,36,36,36,36,36]
[2,"V2","Pick-up Cab.dupla 2.8 4x4 Diesel","dia",480,20,20,20,20,20,20,20,20,20,20,20,20,20,20,20,20,20,20,20,20,20,20,20,20]
[2,"V3","Passagens Aéreas (ida e volta)","un",9,3,{"$nulls":4},0,{"$nulls":5},3,{"$nulls":11},3]
[2,"M1","Equipamentos (Notebook, RTK, Drone, GPS)","un",24,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1]
[2,null,0,null,{"$f":"SUM(F33:AC33)","v":0},{"$f":"F16","v":0}]
[2,null,null,null,0,{"$f":"F17","v":0},{"$f":"G17","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[2,null,{"$f":"C18","v":0},null,0,{"$f":"F18","v":0}]
[2,null,"Item 2-MG, BA",{"$f":"PFP!G39","v":0}]
["Cod1","Cod2","Insumos","Uni","Qde",1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24]
[]
[]
[3,"P2",{"$f":"C7","v":"Engenheiro pleno (P8066)"},"mês",{"$f":"SUM(F40:AC40)","v":6},0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25]
[3,"P3","Engenheiro júnior (P8065)","mês",24,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1]
[3,"T1","Técnico ambiental/geoprocessamento (P8143)","mês",24,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1]
[3,"D","Auxiliar de topografia/Auxiliar (P8028)","mês",24,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1]
[3,"A1","Auxiliar administrativo (P8026)","mês",6,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25]
[3,"V1","Diárias","dia",864,36,36,36,36,36,36,36,36,36,36,36,36,36,36,36,36,36,36,36,36,36,36,36,36]
[3,"V2","Pick-up Cab.dupla 2.8 4x4 Diesel","dia",480,20,20,20,20,20,20,20,20,20,20,20,20,20,20,20,20,20,20,20,20,20,20,20,20]
[3,"V3","Passagens Aéreas (ida e volta)","un",9,3,{"$nulls":4},0,{"$nulls":5},3,{"$nulls":11},3]
[3,"V4","Equipamentos (Notebook, RTK, Drone, GPS)","mês",24,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1]
[3,null,0,null,{"$f":"SUM(F49:AC49)","v":0},null,{"$f":"G16","v":0}]
[3]
[3,null,{"$f":"C18","v":0}]
[3,null,"Item 3 - SE, AL, PE, PB, RN, CE"]
["Cod1","Cod2","Insumos","Uni","Qde",1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24]
[]
[]
[4,"P2",{"$f":"C7","v":"Engenheiro pleno (P8066)"},"mês",{"$f":"SUM(F56:AC56)","v":6},0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25]
[4,"P3","Engenheiro júnior (P8065)","mês",24,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1]
[4,"T1","Técnico ambiental/geoprocessamento (P8143)","mês",24,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1]
[4,"D","Auxiliar de topografia/Auxiliar (P8028)","mês",24,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1]
[4,"A1","Auxiliar administrativo (P8026)","mês",6,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25]
[4,"V1","Diárias","dia",864,36,36,36,36,36,36,36,36,36,36,36,36,36,36,36,36,36,36,36,36,36,36,36,36]
[4,"V2","Pick-up Cab.dupla 2.8 4x4 Diesel","dia",480,20,20,20,20,20,20,20,20,20,20,20,20,20,20,20,20,20,20,20,20,20,20,20,20]
[4,"V3","Passagens Aéreas (ida e volta)","un",9,3,{"$nulls":4},0,{"$nulls":5},3,{"$nulls":11},3]
[4,"V4","Equipamentos (Notebook, RTK, Drone, GPS)","mês",{"$f":"SUM(F64:AC64)","v":24},1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1]
[4,null,0]
[4]
[4,null,{"$f":"C18","v":0}]
[4,null,"Item 4 - MA, AP, PA"]

{"sheet":"Cronograma","index":8,"n_rows":40,"n_cols":26,"rows_kept":40,"cut":false,"hidden":false,"merged":[[16,0,16,10],[17,0,17,10],[6,0,7,0],[6,1,7,1],[6,2,6,25],[12,0,12,6],[14,0,14,10],[15,0,15,10],[5,0,5,1],[0,0,1,25],[2,0,2,25],[4,0,4,1],[4,11,4,17],[4,24,4,25]]}
["Cronograma Físico Financeiro"]
[]
["NOME DA CONSULTORA:"]
[]
["PROJETO:",{"$nulls":10},"OBJETO:",{"$nulls":12},"EDITAL:"]
["Revitalização",{"$nulls":10},{"$f":"PFP!B6","v":"Apoio à fiscalização e supervisão técnica dos serviços de revitalização na SEDE"}]
[null,"Total","Relatórios Mensais de Andamento"]
[null,null,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24]
["Físico",100,{"$f":"$B$9/24","v":4.166666666666667},{"$f":"$B$9/24","v":4.166666666666667},4.166666666666667,4.166666666666667,4.166666666666667,4.166666666666667,4.166666666666667,4.166666666666667,4.166666666666667,4.166666666666667,4.166666666666667,4.166666666666667,4.166666666666667,4.166666666666667,4.166666666666667,4.166666666666667,4.166666666666667,4.166666666666667,4.166666666666667,4.166666666666667,4.166666666666667,4.166666666666667,4.166666666666667,4.166666666666667]
["Financeiro (R$)",{"$f":"SUM(C10:Z10)","v":6367109.04},{"$f":"'Planilha Resumo '!$F$13/24","v":265296.21000000002},{"$f":"'Planilha Resumo '!$F$13/24","v":265296.21000000002},{"$f":"'Planilha Resumo '!$F$13/24","v":265296.21000000002},{"$f":"'Planilha Resumo '!$F$13/24","v":265296.21000000002},{"$f":"'Planilha Resumo '!$F$13/24","v":265296.21000000002},{"$f":"'Planilha Resumo '!$F$13/24","v":265296.21000000002},{"$f":"'Planilha Resumo '!$F$13/24","v":265296.21000000002},{"$f":"'Planilha Resumo '!$F$13/24","v":265296.21000000002},{"$f":"'Planilha Resumo '!$F$13/24","v":265296.21000000002},{"$f":"'Planilha Resumo '!$F$13/24","v":265296.21000000002},{"$f":"'Planilha Resumo '!$F$13/24","v":265296.21000000002},{"$f":"'Planilha Resumo '!$F$13/24","v":265296.21000000002},{"$f":"'Planilha Resumo '!$F$13/24","v":265296.21000000002},{"$f":"'Planilha Resumo '!$F$13/24","v":265296.21000000002},{"$f":"'Planilha Resumo '!$F$13/24","v":265296.21000000002},{"$f":"'Planilha Resumo '!$F$13/24","v":265296.21000000002},{"$f":"'Planilha Resumo '!$F$13/24","v":265296.21000000002},{"$f":"'Planilha Resumo '!$F$13/24","v":265296.21000000002},{"$f":"'Planilha Resumo '!$F$13/24","v":265296.21000000002},{"$f":"'Planilha Resumo '!$F$13/24","v":265296.21000000002},{"$f":"'Planilha Resumo '!$F$13/24","v":265296.21000000002},{"$f":"'Planilha Resumo '!$F$13/24","v":265296.21000000002},{"$f":"'Planilha Resumo '!$F$13/24","v":265296.21000000002},{"$f":"'Planilha Resumo '!$F$13/24","v":265296.21000000002}]
["NOME DO INFORMANTE:",{"$nulls":20},"QUALIFICAÇÃO:"]
[]
["ASSINATURA:",{"$nulls":21},"DATA:"]
[]
["OBSERVAÇÃO:"]
{"$rows_empty":23}
[{"$nulls":12},{"$f":"100/24","v":4.166666666666667}]
[{"$nulls":12},{"$f":"4.17*24","v":100.08}]

{"sheet":"CPU HOSPEDAGEM","index":9,"n_rows":19,"n_cols":5,"rows_kept":19,"cut":false,"hidden":false,"merged":[[2,1,2,2]]}
[{"$nulls":4},"BASE:"]
[null,"Engenharia Consultiva da Codevasf"]
[null,"CPU - HOSPEDAGEM EQUIPE DE CAMPO (3 PESSOAS/MÊS)",null,"Código/Referencia"]
[null,"ALUGUEL ",3074.56,"F020003334/EMBASA","Jul/EMBASA"]
[null," Aquisição de Mobiliário",{"$f":"43.89*C16","v":131.67000000000002},"B8954/DNIT"]
[null,"Material de limpeza e diarista",{"$f":"126.93+(123*8)","v":1110.93},"10563/ORSE - E200300131/EMBASA","Jul/EMBASA"]
[null,"manutenção da casa alugada - Serviços Gerais/Vigia ",2706.8,"41096/SINAPI","Ago/SINAPI"]
[null,"Energia ",180,"10555/ORSE"]
[null,"Água",394.99,"10554/ORSE"]
[null,"telefone/Internet",{"$f":"154.99+89","v":243.99},"10557/10558/ORSE"]
[null,"IPTU (mês)",{"$f":"(C4*0.5)/12","v":128.10666666666665}]
[null,"Despesas Gerais - 10%",{"$f":"SUM(C4:C11)*0.1","v":797.10466666666662}]
[null,"Custo Mensal:",{"$f":"SUM(C4:C12)","v":8768.1513333333332}]
[null,"Custo Mensal por pessoa:",{"$f":"C13/C16","v":2922.7171111111111}]
[null,"Custo diário por pessoa:",{"$f":"C14/22","v":132.85077777777778}]
[null,"número de pessoas:",3]
[null,"Alimentação:",87,"Tabela Diária Codevasf"]
[]
[null,"Diária Total (alimentação + hospedagem):",{"$f":"C15+C17","v":219.85077777777778}]

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

{"sheet":"Cotação Voos","index":11,"n_rows":104,"n_cols":5,"rows_kept":104,"cut":false,"hidden":false,"merged":[]}
["COTAÇÕES - IDA DIA 07/04/2024 E VOLTA DIA 11/04/2024"]
[]
["BSB - PALMAS","Cia 1","Cia 2","Cia 3","Média"]
[null,760,760,1308,{"$f":"AVERAGE(B4:D4)","v":942.66666666666663}]
{"$rows_empty":24}
["BSB - Macapá","Cia 1","Cia 2","Cia 3","Média"]
[null,1306,1591,1882,{"$f":"AVERAGE(B30:D30)","v":1593}]
{"$rows_empty":24}
["BSB - Montes Claros","Cia 1","Cia 2","Cia 3","Média"]
[null,856,927,1354,{"$f":"AVERAGE(B56:D56)","v":1045.6666666666667}]
{"$rows_empty":23}
["BSB - Joao Pessoa ","Cia 1","Cia 2","Cia 3","Média"]
[null,1157,1158,2270,{"$f":"AVERAGE(B81:D81)","v":1528.3333333333333}]
{"$rows_empty":22}
["VALOR ADOTADO:",{"$f":"AVERAGE(E4:E81)","v":1277.4166666666665}]

{"sheet":"PFS-X -Equipamentos","index":12,"n_rows":58,"n_cols":17,"rows_kept":58,"cut":false,"hidden":false,"merged":[[46,15,48,15],[0,0,0,5],[46,6,48,6],[46,12,48,12],[46,13,48,13],[46,14,48,14],[27,0,27,1],[21,0,21,1],[33,0,33,1],[39,0,39,1]]}
["COMPOSIÇÃO DO CUSTO MENSAL - EQUIPAMENTOS DE INFORMÁTICA: NOTEBOOK,DRONE , RTK, RTK"]
[]
["A – DEPRECIAÇÃO MENSAL DOS EQUIPAMENTOS"]
["A.1 Preço de aquisição (Cotação)",{"$nulls":4},{"$f":"SUM(B26,B32,B38,B44)","v":63709.66}]
["A.2 Tempo previsto de vida útil (meses)",{"$nulls":4},48]
["A.3 Previsão de recup. na venda do bem usado (%)",{"$nulls":4},0.5]
["A.4 CUSTO MENSAL   "]
[{"$nulls":5},{"$f":"(F4-(F6*F4))/F5","v":663.64229166666667}]
[]
["B – JUROS PELO CAPITAL EMPREGADO"]
["B.1 Taxa mensal de juros (%)",{"$nulls":4},{"$f":"2%","v":0.02}]
["B.2 Juros s/ a depreciação/aluguel  (B.1 x A.4) ",{"$nulls":4},{"$f":"F11*F8","v":13.272845833333333}]
[]
["C – CONSERVAÇÃO E MANUTENÇÃO"]
["C.1 Taxa de gastos sobre a depreciação mensal inclusive seguros (%) ",{"$nulls":4},{"$f":"1%","v":0.01}]
["C.2 Incidência mensal (C.1 x A.4) ",{"$nulls":4},{"$f":"F15*F8","v":6.6364229166666666}]
[]
["VALOR TOTAL POR MÊS",{"$nulls":4},{"$f":"F8+F12+F16","v":683.55156041666669}]
[]
[]
["Cotação","R$"]
["Aparelho GPS Garmin MAP65 MULTIBAND(GPS, GLONASS, GALILEO, QZSS)"]
["Cotação 1",4895]
["Cotação 2",3749]
["Cotação 3",4249]
["Preço médio",{"$f":"ROUND(AVERAGE(B23,B24,B25),2)","v":4297.67}]
[]
["Aparelho Kit Receptores GNSS RTK CHC i73 Super Compacto com Sensor IMU e 1408 Canais"]
["Cotação 1",48900]
["Cotação 2",39589]
["Cotação 3",39900]
["Preço médio",{"$f":"ROUND(AVERAGE(B29,B30,B31),2)","v":42796.33}]
[]
["Drone DJI Mine 4 Pro Fly More Combo Plus DJI RC Com Tela 4K 48MP DJI044"]
["Cotação 1",12299]
["Cotação 2",10799]
["Cotação 3",10499]
["Preço médio",{"$f":"ROUND(AVERAGE(B35,B36,B37),2)","v":11199}]
[]
["Notebook  - (Core i7, 4Gb RAM, 1Tb"]
["Cotação 1",5199]
["Cotação 2",4751.99]
["Cotação 3",6299]
["Preço médio",{"$f":"ROUND(AVERAGE(B41,B42,B43),2)","v":5416.66}]
[]
[{"$nulls":6},"Objeto da cotação","Obs.: Marca, modelo, capacidade, tipo, etc.","Data da cotação","Forma de cotação","Empresa","Valor cotação","Média","Mediana","Mínimo","Máximo","Contato"]
[{"$nulls":6},"GPS- Portátil Garmin GPSMAP 65",null,"2024-10-07","Site","geotrackconsultoria",4895,{"$f":"AVERAGE(L47:L49)","v":4297.666666666667},{"$f":"MEDIAN(L47:L49)","v":4249},{"$f":"MIN(L47:L49)","v":3749},{"$f":"MAX(L47:L49)","v":4895},"https://www.mercadolivre.com.br/gps-portatil-garmin-map-65-mapa-rodoviario-topografico-cor-bege-mapas-pre-carregados-incluidos-sim/p/MLB27241540#wid%3DMLB3683801043%26sid%3Dsearch%26searchVariation%3DMLB27241540%26position%3D2%26search_layout%3Dstack%26type%3Dproduct%26tracking_id%3D8bd12d49-3b2b-4ba5-921e-47173181b3fb"]
[{"$nulls":8},"2024-10-07","Site","treinit",3749,{"$nulls":4},"https://www.treinit.com.br/navegadores-gps-e-bussolas/outdoor/navegador-gps-garmin-gpsmap-65?parceiro=6975&gad_source=1&gclid=Cj0KCQjwjY64BhCaARIsAIfc7YZ6bkAHJnSeqB6zId2C0AGBDdcQhkZLuZ-feCU1HAj_7W1IHhC_LgYaAmIuEALw_wcB"]
[{"$nulls":8},"2024-10-07","Site","garminstore",4249,{"$nulls":4},"https://www.garminstore.com.br/gps-portatil-garmin-gpsmap-65-/p?gad_source=1&gclid=Cj0KCQjwjY64BhCaARIsAIfc7YY_URuhEmws7R6GC73ZKiVCFcpRDLHeGGbTOQC3lKO2UkWxRHfk7EYaAoI7EALw_wcB&idsku=54390&skuId=54390"]
[{"$nulls":6},"RTK ","Kit Receptores GNSS RTK CHC i73 Super Compacto com Sensor IMU e 1408 Canais","2024-10-18","Site","cpetecnologia",48900,{"$f":"AVERAGE(L50:L52)","v":42796.333333333336},{"$f":"MEDIAN(L50:L52)","v":39900},{"$f":"MIN(L50:L52)","v":39589},{"$f":"MAX(L50:L52)","v":48900},"https://www.cpetecnologia.com.br/kit-receptores-gnss-rtk-chc-i73-com-sensor-imu-1408-canais-super-compacto/p"]
[{"$nulls":7},"Receptor GNSS RTK Modelo S90 Kit Base e Rover","2024-01-29","Site","geotrackconsultoria",39589,{"$nulls":4},"https://www.geotrackconsultoria.com.br/receptor-gnss-rtk-modelo-s90-kit-base-e-rover?srsltid=AfmBOoqU5eyRnJ8_GUmpMasuSECdWfq0ZiBIkOpI8EcYpOK2TB9AH_Dj"]
[{"$nulls":7},"KIT RTK GNSS CHC i50","2024-01-29","Site","mercadotopografico",39900,{"$nulls":4},"https://mercadotopografico.com.br//produto/385-kit-rtk-gnss-chc-i50?gad_source=4&gclid=CjwKCAjwjsi4BhB5EiwAFAL0YOiq7qwy1muoKfOVBv5Wr1tLWibY7-BsOY7PVrr568bbv_LwueoSDhoCPP4QAvD_BwE"]
[{"$nulls":6},"Drone DJI Mini 4 Pro Fly More Combo Plus (Com tela) BR - DJI044",null,"2024-10-07","Site","geotrackconsultoria",12299,{"$f":"AVERAGE(L53:L55)","v":11199},{"$f":"MEDIAN(L53:L55)","v":10799},{"$f":"MIN(L53:L55)","v":10499},{"$f":"MAX(L53:L55)","v":12299},"https://www.lojadji.com.br/drone-dji-mini-4-pro-fly-more-combo-plus-dji-rc-2-dji044/p?idsku=8&utm_source=google-dji&utm_medium=ECM-cpc&utm_campaign=DJI_M2C_[P]_PMAX_Generica_ES_DJI_None_mid&cd=&mig=ok&z=&utm_term=&utm_content=&gad_source=1&gclid=Cj0KCQjwmt24BhDPARIsAJFYKk3OwcLSDMrmxPsMrqY2tpHstJAwb3ygCBzeFfXSApFymW-k5sL8H0YaAjOAEALw_wcB"]
[{"$nulls":8},"2024-10-22","Site","kabum",10799,{"$nulls":4},"https://www.kabum.com.br/produto/580050/drone-dji-mini-4-pro-4k-camera-48mp-dji044?utm_id=20531423011&gad_source=1&gclid=Cj0KCQjwmt24BhDPARIsAJFYKk2ofDywfzByEV41W1I16xAzNsLl5pD3ICK0dHf55gjdfEs5W85R82YaAps5EALw_wcB"]
[{"$nulls":8},"2024-10-22","Site","primetek",10499,{"$nulls":4},"https://www.primetek.com.br/drone-dji-mine-4-pro-fly-more-combo-plus-dji-rc-com-tela-4k/p?idsku=26001&gad_source=1&gclid=Cj0KCQjwmt24BhDPARIsAJFYKk22gUMgWXCVXvw_8V7NifrB11UuXggylpEGRi2dPeRA_1V9WDyG-2saApDZEALw_wcB"]
[{"$nulls":6},"Notebook","Processador\n13ª geração Intel® Core™ i7-1355U (10-core, cache de 12MB, até 5.0GHz)\nSistema operacional\n(A Dell Technologies recomenda o Windows 11 Pro para empresas)\nWindows 11 Home, Português\nPlaca de vídeo \nIntel® Iris® Xe com memória gráfica compartilhada\nTela\nFull HD de 15.6\" (1920 x 1080), 120 Hz, WVA\nMemória \n16GB DDR4 (2x8GB) 2666MT/s; Limite de 16GB atingido (2 slots soDIMM)\nArmazenamento\nSSD de 1TB PCIe NVMe M.2\n","2024-10-25","Site","dell",5199,{"$f":"AVERAGE(L56:L58)","v":5416.663333333333},{"$f":"MEDIAN(L56:L58)","v":5199},{"$f":"MIN(L56:L58)","v":4751.99},{"$f":"MAX(L56:L58)","v":6299},"https://www.dell.com/pt-br/shop/cty/pdp/spd/inspiron-15-3530-laptop/brpichbto3530gqnzw?tfcid=31768715&gacd=9657105-15015-5761040-275878141-0&dgc=ST&cid=71700000114503108&gad_source=1&gclid=CjwKCAjwg-24BhB_EiwA1ZOx8kiiaFIZL8WsX_shSAXnx-UcqZLKXT9-wHv3M-Mv3DmQOd5Em1i5sxoCU8gQAvD_BwE&gclsrc=aw.ds"]
[{"$nulls":7},"Processador\nIntel® Core™ i7 até de 12ª geração\n\nSistema operacional\nAté Windows 11 Pro\n\nTela\nFHD TN de 14″ (1.920 x 1.080), antirreflexo, 250 nits\n\nFHD IPS de 14″ (1.920 x 1.080), antirreflexo, 300 nits\n\nProporção tela-corpo de 88%\n\n\n\nPara ambas as opções de tela, proporção = 16:9.\n\n\n\nMemória\nAté 16 GB, integrada e DIMM (canal duplo), 3.200 MHz\n\nArmazenamento\nPCIe M.2 de até 512 GB\n\nHD de até 1 TB\n\nCompatível com duas unidades (apenas HD até 1 TB e SSD de 256 GB)\n\n\n\nPlaca de vídeo\nUHD Intel® integrada \n\nOpcional: Intel® Iris® Xe\n\nBateria\nAté 5,8 horas, 38 Wh (MM18)\n\nAté 7,1 horas, 45 Wh (MM18)\n\nAmbas são compatíveis com Rapid Charge (60 minutos = 80%) com adaptador de 65 W ou superior\n\n*Todas as afirmações quanto à vida útil da bateria são aproximadas e baseadas nos resultados dos testes de benchmark de duração da bateria do MobileMark® 2018. A real vida útil da bateria varia e depende de diversos fatores, incluindo configuração e uso do produto, software, condições de operação, funcionalidade sem fio, configurações de gerenciamento de energia e brilho da tela. A capacidade máxima da bateria diminuirá com o tempo e o uso.\n","2024-10-25","Site","Lenovo",4751.99,{"$nulls":4},"https://www.lenovo.com/br/pt/p/laptops/lenovo-laptops/v-series/lenovo-v14-g3-iap(brazil)/82ul0017br?cid=br:sem|se|google|j-b2c-commercial_notebook-convers-google-performancemax-intelccf|||82UL0017BR|18004393355|||pmax||commercial&gad_source=1&gclid=CjwKCAjwg-24BhB_EiwA1ZOx8reHCtdYCDN0-LjnIzv6MRmC6weJofYqSPVFh3SdJhnmrUp6UtzMbxoCz1cQAvD_BwE"]
[{"$nulls":7},"VAIO_FH15_Ang-teclado\nVAIO_FH15_Ang-ladoaberto\nVAIO_FH15_Ang-fechado\nVAIO_FH15_Ang-tecladoLado\nVAIO_FH15_Ang-espessura\nVAIO_FH15_Ang-entradas\n2 avaliações\nNotebook VAIO® FH15 Intel® Core™ i7-12650H Shell Efi GeForce RTX® 3050 32GB RAM 1TB SSD 15.6\" Full HD - Cinza Escuro","2024-10-25","Site","vaio",6299,{"$nulls":4},"https://www.br.vaio.com/notebook-vaio-fh15-core-i7-geforce-rtx-3050-32gb-1tb-15-6-fullhd-cinza-escuro-3344256/p?idsku=43868&utm_source=google&utm_medium=cpc&utm_campaign=smart-shopping-ecom-intel&utm_term=pmx&utm_content=vaio&gad_source=1&gclid=CjwKCAjwg-24BhB_EiwA1ZOx8pTyDT0cW_ROnAD4WjxePeuyu6cOsCbEzpZh6I0fMRlSViUTb78lShoCFs0QAvD_BwE"]

{"sheet":"MDO_DNIT","index":13,"n_rows":113,"n_cols":27,"rows_kept":113,"cut":false,"hidden":false,"merged":[[1,20,1,21],[0,25,1,25],[0,16,0,21],[0,22,1,23],[0,24,1,24],[1,16,1,17],[1,18,1,19],[0,6,0,15],[0,0,2,0],[0,1,2,1],[0,2,2,2],[0,3,1,3],[0,4,1,5],[1,6,1,7],[1,8,1,9],[1,10,1,11],[1,12,1,13],[1,14,1,15]]}
["Código","Categoria","Unid.","Salário","Encargos Sociais",null,"Encargos Complementares",{"$nulls":9},"Encargos Adicionais",{"$nulls":5},"Encargos Totais",null,"Valor Total","Encargos Adicionais e Complementares","BASE:"]
[{"$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",{"$nulls":5},"SINAPI/DF  Set/2024"]
[null,null,null,"R$","%","R$","%","R$","%","R$","%","R$","%","R$","%","R$","%","R$","%","R$","%","R$","%","R$","R$","R$"]
["Profissionais mensalistas"]
["P8001","Advogado júnior","mês",4616.38,0.79300000000000004,3660.79,0.15959999999999999,736.74,5.4999999999999997E-3,25.51,0,0,0,0,5.9999999999999995E-4,2.95,0,0,6.4000000000000001E-2,295.48,2.2000000000000001E-3,9.98,1.0248999999999999,4731.45,9347.83,{"$f":"Y5-F5-D5","v":1070.6599999999999}]
["P8002","Advogado pleno","mês",6155.17,0.79300000000000004,4881.05,0.1197,736.74,4.1000000000000003E-3,25.51,0,0,0,0,5.0000000000000001E-4,2.95,0,0,4.8000000000000001E-2,295.48,1.6000000000000001E-3,9.98,0.96689999999999998,5951.71,12106.89,{"$f":"Y6-F6-D6","v":1070.6699999999992}]
["P8003","Advogado sênior","mês",11441.04,0.79300000000000004,9072.75,6.4399999999999999E-2,736.74,2.2000000000000001E-3,25.51,0,0,0,0,2.9999999999999997E-4,2.95,0,0,2.58E-2,295.48,8.9999999999999998E-4,9.98,0.88660000000000005,10143.41,21584.45,1070.6599999999999]
["P8007","Analista de desenvolvimento de sistemas júnior","mês",4690.87,0.79630000000000001,3735.34,0.15709999999999999,736.74,0,0,0,0,0,0,8.0000000000000004E-4,3.74,0,0,6.3E-2,295.48,2.0999999999999999E-3,9.98,1.0193000000000001,4781.28,9472.16,1045.9499999999998]
["P8008","Analista de desenvolvimento de sistemas pleno","mês",5657.08,0.79630000000000001,4504.74,0.13020000000000001,736.74,0,0,0,0,0,0,6.9999999999999999E-4,3.74,0,0,5.2200000000000003E-2,295.48,1.8E-3,9.98,0.98119999999999996,5550.68,11207.76,1045.9400000000005]
["P8009","Analista de desenvolvimento de sistemas sênior","mês",9897.56,0.79630000000000001,7881.43,7.4399999999999994E-2,736.74,0,0,0,0,0,0,4.0000000000000002E-4,3.74,0,0,2.9899999999999999E-2,295.48,1E-3,9.98,0.90200000000000002,8927.3700000000008,18824.919999999998,1045.9299999999985]
["P8013","Arquiteto júnior","mês",12002,0.79320000000000002,9519.99,6.1400000000000003E-2,736.74,2.0999999999999999E-3,25.51,0,0,0,0,2.0000000000000001E-4,2.61,0,0,2.46E-2,295.48,8.0000000000000004E-4,9.98,0.88239999999999996,10590.31,22592.31,1070.3200000000015]
["P8014","Arquiteto pleno","mês",12521.12,0.79320000000000002,9931.75,5.8799999999999998E-2,736.74,2E-3,25.51,0,0,0,0,2.0000000000000001E-4,2.61,0,0,2.3599999999999999E-2,295.48,8.0000000000000004E-4,9.98,0.87870000000000004,11002.08,23523.200000000001,1070.33]
["P8015","Arquiteto sênior","mês",15280.37,0.79320000000000002,12120.39,4.82E-2,736.74,1.6999999999999999E-3,25.51,0,0,0,0,2.0000000000000001E-4,2.61,0,0,1.9300000000000001E-2,295.48,6.9999999999999999E-4,9.98,0.86319999999999997,13190.72,28471.09,1070.33]
["P8019","Assistente social júnior","mês",3264.91,0.80159999999999998,2617.15,0.22570000000000001,736.74,7.7999999999999996E-3,25.51,0,0,7.1000000000000004E-3,23.14,1.2999999999999999E-3,4.29,0,0,9.0499999999999997E-2,295.48,3.0999999999999999E-3,9.98,1.137,3712.3,6977.21,1095.1499999999996]
["P8020","Assistente social pleno","mês",4353.21,0.80159999999999998,3489.54,0.16919999999999999,736.74,5.8999999999999999E-3,25.51,0,0,0,0,1E-3,4.29,0,0,6.7900000000000002E-2,295.48,2.3E-3,9.98,1.0479000000000001,4561.55,8914.76,1072.0100000000002]
["P8021","Assistente social sênior","mês",7202.11,0.80159999999999998,5773.22,0.1023,736.74,3.5000000000000001E-3,25.51,0,0,0,0,5.9999999999999995E-4,4.29,0,0,4.1000000000000002E-2,295.48,1.4E-3,9.98,0.95040000000000002,6845.22,14047.34,1072.0099999999993]
["P8025","Auxiliar","mês",1583.76,0.81559999999999999,1291.72,0.4652,736.74,1.9599999999999999E-2,31.06,1E-3,1.59,7.8299999999999995E-2,124.01,3.8999999999999998E-3,6.15,0,0,0.18659999999999999,295.48,6.3E-3,9.98,1.5765,2496.73,4080.5,1205.0199999999998]
["P8026","Auxiliar administrativo","mês",1880.26,0.80169999999999997,1507.4,0.39179999999999998,736.74,0,0,0,0,5.6500000000000002E-2,106.22,2E-3,3.76,0,0,0.15709999999999999,295.48,5.3E-3,9.98,1.4145000000000001,2659.59,4539.8500000000004,1152.1900000000003]
["P8027","Auxiliar de laboratório","mês",1753.34,0.80359999999999998,1408.99,0.42020000000000002,736.74,1.77E-2,31.06,1.9E-3,3.28,6.4899999999999999E-2,113.83,2.3E-3,4.0199999999999996,0,0,0.16850000000000001,295.48,5.7000000000000002E-3,9.98,1.4847999999999999,2603.38,4356.7299999999996,1194.3999999999999]
["P8028","Auxiliar de topografia","mês",1583.76,0.80620000000000003,1276.83,0.4652,736.74,1.9599999999999999E-2,31.06,8.9999999999999998E-4,1.39,7.8299999999999995E-2,124.01,2.8E-3,4.3899999999999997,0,0,0.18659999999999999,295.48,6.3E-3,9.98,1.5658000000000001,2479.88,4063.64,1203.05]
["P8032","Biólogo júnior","mês",3224.68,0.79700000000000004,2570.0700000000002,0.22850000000000001,736.74,7.9000000000000008E-3,25.51,0,0,7.9000000000000008E-3,25.55,1.1000000000000001E-3,3.6,0,0,9.1600000000000001E-2,295.48,3.0999999999999999E-3,9.98,1.1371,3666.94,6891.62,1096.8699999999994]
["P8033","Biólogo pleno","mês",4299.57,0.79700000000000004,3426.76,0.1714,736.74,5.8999999999999999E-3,25.51,0,0,0,0,8.0000000000000004E-4,3.6,0,0,6.8699999999999997E-2,295.48,2.3E-3,9.98,1.0462,4498.08,8797.65,1071.3199999999997]
["P8034","Biólogo sênior","mês",7659.98,0.79700000000000004,6105.01,9.6199999999999994E-2,736.74,3.3E-3,25.51,0,0,0,0,5.0000000000000001E-4,3.6,0,0,3.8600000000000002E-2,295.48,1.2999999999999999E-3,9.98,0.93689999999999996,7176.33,14836.31,1071.3199999999997]
["P8038","Chefe de escritório","mês",3337.76,0.79390000000000005,2649.85,0.22070000000000001,736.74,0,0,0,0,5.5999999999999999E-3,18.77,8.0000000000000004E-4,2.81,0,0,8.8499999999999995E-2,295.48,3.0000000000000001E-3,9.98,1.1126,3713.63,7051.4,1063.7899999999991]
["P8040","Contador júnior","mês",4191.21,0.79359999999999997,3326.15,0.17580000000000001,736.74,0,0,0,0,0,0,5.9999999999999995E-4,2.69,0,0,7.0499999999999993E-2,295.48,2.3999999999999998E-3,9.98,1.0428999999999999,4371.04,8562.25,1044.8900000000003]
["P8041","Contador pleno","mês",5588.28,0.79359999999999997,4434.8599999999997,0.1318,736.74,0,0,0,0,0,0,5.0000000000000001E-4,2.69,0,0,5.2900000000000003E-2,295.48,1.8E-3,9.98,0.98060000000000003,5479.76,11068.04,1044.9000000000015]
["P8042","Contador sênior","mês",10788.12,0.79359999999999997,8561.4500000000007,6.83E-2,736.74,0,0,0,0,0,0,2.0000000000000001E-4,2.69,0,0,2.7400000000000001E-2,295.48,8.9999999999999998E-4,9.98,0.89049999999999996,9606.34,20394.46,1044.8899999999976]
["P8044","Coordenador ambiental","mês",18689.66,0.79679999999999995,14891.92,3.9399999999999998E-2,736.74,1.1999999999999999E-3,23.3,0,0,0,0,2.0000000000000001E-4,3.98,0,0,1.5800000000000002E-2,295.48,5.0000000000000001E-4,9.98,0.85399999999999998,15961.41,34651.08,1069.5000000000036]
["P8045","Economista júnior","mês",4750.1000000000004,0.78610000000000002,3734.05,0.15509999999999999,736.74,0,0,0,0,0,0,4.0000000000000002E-4,1.9,0,0,6.2199999999999998E-2,295.48,2.0999999999999999E-3,9.98,1.0059,4778.1499999999996,9528.25,1044.0999999999995]
["P8046","Economista pleno","mês",6333.46,0.78610000000000002,4978.74,0.1163,736.74,0,0,0,0,0,0,2.9999999999999997E-4,1.9,0,0,4.6699999999999998E-2,295.48,1.6000000000000001E-3,9.98,0.95099999999999996,6022.84,12356.3,1044.0999999999995]
["P8047","Economista sênior","mês",10433.39,0.78610000000000002,8201.69,7.0599999999999996E-2,736.74,0,0,0,0,0,0,2.0000000000000001E-4,1.9,0,0,2.8299999999999999E-2,295.48,1E-3,9.98,0.88619999999999999,9245.7900000000009,19679.189999999999,1044.1099999999988]
["P8054","Engenheiro agrônomo júnior","mês",12002,0.79079999999999995,9491.18,6.1400000000000003E-2,736.74,2.0999999999999999E-3,25.51,0,0,0,0,2.0000000000000001E-4,2.5,0,0,2.46E-2,295.48,8.0000000000000004E-4,9.98,0.88,10561.4,22563.4,1070.2200000000012]
["P8055","Engenheiro agrônomo pleno","mês",12380.97,0.79079999999999995,9790.8700000000008,5.9499999999999997E-2,736.74,2.0999999999999999E-3,25.51,0,0,0,0,2.0000000000000001E-4,2.5,0,0,2.3900000000000001E-2,295.48,8.0000000000000004E-4,9.98,0.87719999999999998,10861.09,23242.06,1070.2200000000012]
["P8056","Engenheiro agrônomo sênior","mês",13631.64,0.79079999999999995,10779.9,5.3999999999999999E-2,736.74,1.9E-3,25.51,0,0,0,0,2.0000000000000001E-4,2.5,0,0,2.1700000000000001E-2,295.48,6.9999999999999999E-4,9.98,0.86929999999999996,11850.12,25481.759999999998,1070.2199999999993]
["P8057","Engenheiro ambiental júnior","mês",12002,0.79820000000000002,9580,6.1400000000000003E-2,736.74,2.0999999999999999E-3,25.51,0,0,0,0,4.0000000000000002E-4,4.3499999999999996,0,0,2.46E-2,295.48,8.0000000000000004E-4,9.98,0.88749999999999996,10652.07,22654.07,1072.0699999999997]
["P8058","Engenheiro ambiental pleno","mês",12193.36,0.79820000000000002,9732.74,6.0400000000000002E-2,736.74,2.0999999999999999E-3,25.51,0,0,0,0,4.0000000000000002E-4,4.3499999999999996,0,0,2.4199999999999999E-2,295.48,8.0000000000000004E-4,9.98,0.8861,10804.81,22998.17,1072.0699999999979]
["P8059","Engenheiro ambiental sênior","mês",14759.24,0.79820000000000002,11780.83,4.99E-2,736.74,1.6999999999999999E-3,25.51,0,0,0,0,2.9999999999999997E-4,4.3499999999999996,0,0,0.02,295.48,6.9999999999999999E-4,9.98,0.87080000000000002,12852.9,27612.14,1072.0699999999997]
["P8060","Engenheiro consultor especial","mês",21827.91,0.79759999999999998,17409.939999999999,3.3799999999999997E-2,736.74,1.1000000000000001E-3,23.3,0,0,0,0,2.0000000000000001E-4,3.99,0,0,1.35E-2,295.48,5.0000000000000001E-4,9.98,0.84660000000000002,18479.439999999999,40307.360000000001,1069.510000000002]
["P8061","Engenheiro coordenador","mês",18189.93,0.79759999999999998,14508.29,4.0500000000000001E-2,736.74,1.2999999999999999E-3,23.3,0,0,0,0,2.0000000000000001E-4,3.99,0,0,1.6199999999999999E-2,295.48,5.0000000000000001E-4,9.98,0.85640000000000005,15577.78,33767.71,1069.489999999998]
["P8062","Engenheiro de pesca júnior","mês",12002,0.80130000000000001,9617.2000000000007,6.1400000000000003E-2,736.74,2.0999999999999999E-3,25.51,0,0,0,0,4.0000000000000002E-4,4.74,0,0,2.46E-2,295.48,8.0000000000000004E-4,9.98,0.89070000000000005,10689.66,22691.66,1072.4599999999991]
["P8063","Engenheiro de pesca pleno","mês",12714.67,0.80130000000000001,10188.27,5.79E-2,736.74,2E-3,25.51,0,0,0,0,4.0000000000000002E-4,4.74,0,0,2.3199999999999998E-2,295.48,8.0000000000000004E-4,9.98,0.88560000000000005,11260.73,23975.4,1072.4600000000009]
["P8064","Engenheiro de pesca sênior","mês",16261.81,0.80130000000000001,13030.59,4.53E-2,736.74,1.6000000000000001E-3,25.51,0,0,0,0,2.9999999999999997E-4,4.74,0,0,1.8200000000000001E-2,295.48,5.9999999999999995E-4,9.98,0.86729999999999996,14103.05,30364.86,1072.4600000000009]
["P8065","Engenheiro de projetos júnior","mês",12002,0.79759999999999998,9572.7999999999993,6.1400000000000003E-2,736.74,2.0999999999999999E-3,25.51,0,0,0,0,2.9999999999999997E-4,3.99,0,0,2.46E-2,295.48,8.0000000000000004E-4,9.98,0.88690000000000002,10644.5,22646.5,1071.7000000000007]
["P8066","Engenheiro de projetos pleno","mês",12629.6,0.79759999999999998,10073.370000000001,5.8299999999999998E-2,736.74,2E-3,25.51,0,0,0,0,2.9999999999999997E-4,3.99,0,0,2.3400000000000001E-2,295.48,8.0000000000000004E-4,9.98,0.88249999999999995,11145.08,23774.68,1071.7099999999991]
["P8067","Engenheiro de projetos sênior","mês",15877.29,0.79759999999999998,12663.73,4.6399999999999997E-2,736.74,1.6000000000000001E-3,25.51,0,0,0,0,2.9999999999999997E-4,3.99,0,0,1.8599999999999998E-2,295.48,5.9999999999999995E-4,9.98,0.86509999999999998,13735.44,29612.73,1071.7099999999991]
["P8068","Engenheiro florestal júnior","mês",12002,0.80130000000000001,9617.2000000000007,6.1400000000000003E-2,736.74,2.0999999999999999E-3,25.51,0,0,0,0,4.0000000000000002E-4,4.74,0,0,2.46E-2,295.48,8.0000000000000004E-4,9.98,0.89070000000000005,10689.66,22691.66,1072.4599999999991]
["P8069","Engenheiro florestal pleno","mês",12714.67,0.80130000000000001,10188.27,5.79E-2,736.74,2E-3,25.51,0,0,0,0,4.0000000000000002E-4,4.74,0,0,2.3199999999999998E-2,295.48,8.0000000000000004E-4,9.98,0.88560000000000005,11260.73,23975.4,1072.4600000000009]
["P8070","Engenheiro florestal sênior","mês",16261.81,0.80130000000000001,13030.59,4.53E-2,736.74,1.6000000000000001E-3,25.51,0,0,0,0,2.9999999999999997E-4,4.74,0,0,1.8200000000000001E-2,295.48,5.9999999999999995E-4,9.98,0.86729999999999996,14103.05,30364.86,1072.4600000000009]
["P8080","Geólogo júnior","mês",10004.5,0.80079999999999996,8011.6,6.7699999999999996E-2,677.01,2.5999999999999999E-3,25.51,0,0,0,0,2.9999999999999997E-4,3.42,0,0,2.9499999999999998E-2,295.48,1E-3,9.98,0.90190000000000003,9023.01,19027.509999999998,1011.409999999998]
["P8081","Geólogo pleno","mês",11911.59,0.80079999999999996,9538.7999999999993,5.6800000000000003E-2,677.01,2.0999999999999999E-3,25.51,0,0,0,0,2.9999999999999997E-4,3.42,0,0,2.4799999999999999E-2,295.48,8.0000000000000004E-4,9.98,0.88570000000000004,10550.2,22461.79,1011.4000000000015]
["P8082","Geólogo sênior","mês",13818.68,0.80079999999999996,11066,4.9000000000000002E-2,677.01,1.8E-3,25.51,0,0,0,0,2.0000000000000001E-4,3.42,0,0,2.1399999999999999E-2,295.48,6.9999999999999999E-4,9.98,0.874,12077.4,25896.07,1011.3899999999994]
["P8092","Jornalista júnior","mês",3073.16,0.79549999999999998,2444.6999999999998,0.2397,736.74,8.3000000000000001E-3,25.51,0,0,1.1299999999999999E-2,34.64,8.9999999999999998E-4,2.68,0,0,9.6100000000000005E-2,295.48,3.2000000000000002E-3,9.98,1.1551,3549.74,6622.9,1105.04]
["P8093","Jornalista pleno","mês",4097.55,0.79549999999999998,3259.6,0.17979999999999999,736.74,6.1999999999999998E-3,25.51,0,0,0,0,6.9999999999999999E-4,2.68,0,0,7.2099999999999997E-2,295.48,2.3999999999999998E-3,9.98,1.0567,4330,8427.5499999999993,1070.3999999999987]
["P8094","Jornalista sênior","mês",7891.46,0.79549999999999998,6277.65,9.3399999999999997E-2,736.74,3.2000000000000002E-3,25.51,0,0,0,0,2.9999999999999997E-4,2.68,0,0,3.7400000000000003E-2,295.48,1.2999999999999999E-3,9.98,0.93110000000000004,7348.05,15239.51,1070.4000000000005]
["P8098","Laboratorista","mês",2337.79,0.80359999999999998,1878.65,0.31509999999999999,736.74,1.2200000000000001E-2,28.6,0,0,3.3700000000000001E-2,78.760000000000005,1.6999999999999999E-3,4.0199999999999996,0,0,0.12640000000000001,295.48,4.3E-3,9.98,1.2970999999999999,3032.24,5370.03,1153.5899999999997]
["P8102","Médico veterinário","mês",12002,0.79079999999999995,9491.18,6.1400000000000003E-2,736.74,2.0999999999999999E-3,25.51,0,0,0,0,2.0000000000000001E-4,2.2599999999999998,0,0,2.46E-2,295.48,8.0000000000000004E-4,9.98,0.88,10561.16,22563.16,1069.9799999999996]
["P8106","Meteorologista júnior","mês",5253.81,0.79330000000000001,4167.84,0.14019999999999999,736.74,4.8999999999999998E-3,25.51,0,0,0,0,5.0000000000000001E-4,2.63,0,0,5.62E-2,295.48,1.9E-3,9.98,0.997,5238.1899999999996,10491.99,1070.3399999999992]
["P8107","Meteorologista pleno","mês",7005.07,0.79330000000000001,5557.12,0.1052,736.74,3.5999999999999999E-3,25.51,0,0,0,0,4.0000000000000002E-4,2.63,0,0,4.2200000000000001E-2,295.48,1.4E-3,9.98,0.94610000000000005,6627.47,13632.54,1070.3500000000013]
["P8108","Meteorologista sênior","mês",11774.37,0.79330000000000001,9340.61,6.2600000000000003E-2,736.74,2.2000000000000001E-3,25.51,0,0,0,0,2.0000000000000001E-4,2.63,0,0,2.5100000000000001E-2,295.48,8.0000000000000004E-4,9.98,0.88419999999999999,10410.950000000001,22185.32,1070.3399999999983]
["P8112","Motorista de caminhão","mês",2332.4,0.80569999999999997,1879.21,0.3014,702.89,1.3299999999999999E-2,31.06,0,0,3.39E-2,79.09,1.8E-3,4.24,0,0,0.12670000000000001,295.48,4.3E-3,9.98,1.2870999999999999,3001.96,5334.36,1122.7499999999995]
["P8113","Motorista de veículo leve","mês",2065.77,0.80130000000000001,1655.3,0.34029999999999999,702.89,1.4999999999999999E-2,31.06,0,0,4.5999999999999999E-2,95.09,1.9E-3,3.85,0,0,0.14299999999999999,295.48,4.7999999999999996E-3,9.98,1.3524,2793.65,4859.42,1138.3499999999999]
["P8117","Oceanógrafo júnior","mês",4510.24,0.80300000000000005,3621.72,0.1633,736.74,5.7000000000000002E-3,25.51,0,0,0,0,8.0000000000000004E-4,3.57,0,0,6.5500000000000003E-2,295.48,2.2000000000000001E-3,9.98,1.0405,4693.01,9203.25,1071.2900000000009]
["P8118","Oceanógrafo pleno","mês",6013.65,0.80300000000000005,4828.96,0.1225,736.74,4.1999999999999997E-3,25.51,0,0,0,0,5.9999999999999995E-4,3.57,0,0,4.9099999999999998E-2,295.48,1.6999999999999999E-3,9.98,0.98109999999999997,5900.25,11913.9,1071.29]
["P8119","Oceanógrafo sênior","mês",10872.11,0.80300000000000005,8730.2999999999993,6.7799999999999999E-2,736.74,2.3E-3,25.51,0,0,0,0,2.9999999999999997E-4,3.57,0,0,2.7199999999999998E-2,295.48,8.9999999999999998E-4,9.98,0.90149999999999997,9801.59,20673.689999999999,1071.2799999999988]
["P8129","Pedagogo júnior","mês",2507.29,0.92379999999999995,2316.2399999999998,0.29380000000000001,736.74,1.0200000000000001E-2,25.51,0,0,2.7400000000000001E-2,68.59,1.04E-2,26,0,0,0.1178,295.48,4.0000000000000001E-3,9.98,1.3874,3478.55,5985.84,1162.3100000000004]
["P8130","Pedagogo pleno","mês",3343.06,0.92379999999999995,3088.31,0.22040000000000001,736.74,7.6E-3,25.51,0,0,5.4999999999999997E-3,18.45,7.7999999999999996E-3,26,0,0,8.8400000000000006E-2,295.48,3.0000000000000001E-3,9.98,1.2565,4200.4799999999996,7543.53,1112.1599999999994]
["P8131","Pedagogo sênior","mês",4715.72,0.92379999999999995,4356.38,0.15620000000000001,736.74,5.4000000000000003E-3,25.51,0,0,0,0,5.4999999999999997E-3,26,0,0,6.2700000000000006E-2,295.48,2.0999999999999999E-3,9.98,1.1556999999999999,5450.1,10165.82,1093.7199999999993]
["P8135","Secretária","mês",2697.38,0.7984,2153.59,0.27310000000000001,736.74,0,0,0,0,2.12E-2,57.19,1.4E-3,3.87,0,0,0.1095,295.48,3.7000000000000002E-3,9.98,1.2074,3256.85,5954.23,1103.2599999999993]
["P8139","Sondador","mês",2017.39,0.8004,1614.72,0.36520000000000002,736.74,1.4200000000000001E-2,28.6,0,0,4.8599999999999997E-2,97.99,2.2000000000000001E-3,4.51,0,0,0.14649999999999999,295.48,4.8999999999999998E-3,9.98,1.3819999999999999,2788.02,4805.42,1173.3099999999997]
["P8143","Técnico ambiental","mês",2911.08,0.80640000000000001,2347.4899999999998,0.25309999999999999,736.74,9.7999999999999997E-3,28.6,0,0,1.52E-2,44.37,1.4E-3,4.05,0,0,0.10150000000000001,295.48,3.3999999999999998E-3,9.98,1.1909000000000001,3466.71,6377.79,{"$f":"Y70-F70-D70","v":1119.2200000000003}]
["P8147","Técnico de obras","mês",3184.9,0.80210000000000004,2554.61,0.23130000000000001,736.74,8.9999999999999993E-3,28.6,0,0,8.8000000000000005E-3,27.94,1.1999999999999999E-3,3.8,0,0,9.2799999999999994E-2,295.48,3.0999999999999999E-3,9.98,1.1483000000000001,3657.15,6842.04,1102.5300000000002]
["P8151","Técnico de segurança do trabalho","mês",4601.83,0.80920000000000003,3723.8,0.16009999999999999,736.74,6.1999999999999998E-3,28.6,0,0,0,0,1E-3,4.67,0,0,6.4199999999999993E-2,295.48,2.2000000000000001E-3,9.98,1.0428999999999999,4799.28,9401.11,1075.4800000000005]
["P8155","Técnico em geoprocessamento","mês",2879.59,0.79610000000000003,2292.44,0.25580000000000003,736.74,9.9000000000000008E-3,28.6,0,0,1.61E-2,46.26,1.1999999999999999E-3,3.53,0,0,0.1026,295.48,3.5000000000000001E-3,9.98,1.1853,3413.04,6292.64,1120.6100000000001]
["P8159","Técnico em informática - programador","mês",4690.87,0.80079999999999996,3756.45,0.15709999999999999,736.74,0,0,0,0,0,0,6.9999999999999999E-4,3.45,0,0,6.3E-2,295.48,2.0999999999999999E-3,9.98,1.0237000000000001,4802.1000000000004,9492.98,1045.6599999999999]
["P8163","Topógrafo","mês",2428.5700000000002,0.80620000000000003,1957.92,0.3034,736.74,1.18E-2,28.6,0,0,3.0200000000000001E-2,73.319999999999993,1.8E-3,4.3899999999999997,0,0,0.1217,295.48,4.1000000000000003E-3,9.98,1.2790999999999999,3106.43,5535,1148.5099999999998]
["P8167","Arquivista júnior","mês",2411.9299999999998,0.79959999999999998,1928.58,0.30549999999999999,736.74,0,0,0,0,3.0800000000000001E-2,74.319999999999993,1.2999999999999999E-3,3.15,0,0,0.1225,295.48,4.1000000000000003E-3,9.98,1.2638,3048.25,5460.17,1119.6600000000003]
["P8168","Arquivista pleno","mês",3215.9,0.79959999999999998,2571.4299999999998,0.2291,736.74,0,0,0,0,8.0999999999999996E-3,26.08,1E-3,3.15,0,0,9.1899999999999996E-2,295.48,3.0999999999999999E-3,9.98,1.1328,3642.87,6858.77,1071.44]
["P8169","Arquivista sênior","mês",5113.29,0.79959999999999998,4088.59,0.14410000000000001,736.74,0,0,0,0,0,0,5.9999999999999995E-4,3.15,0,0,5.7799999999999997E-2,295.48,2E-3,9.98,1.004,5133.95,10247.24,1045.3599999999997]
["P8173","Administrador júnior","mês",3341.1,0.7974,2664.19,0.2205,736.74,0,0,0,0,5.5999999999999999E-3,18.57,1.1000000000000001E-3,3.58,0,0,8.8400000000000006E-2,295.48,3.0000000000000001E-3,9.98,1.1160000000000001,3728.54,7069.64,1064.3500000000008]
["P8174","Administrador pleno","mês",4454.8,0.7974,3552.26,0.16539999999999999,736.74,0,0,0,0,0,0,8.0000000000000004E-4,3.58,0,0,6.6299999999999998E-2,295.48,2.2000000000000001E-3,9.98,1.0322,4598.04,9052.84,1045.7799999999997]
["P8175","Administrador sênior","mês",7993.16,0.7974,6373.75,9.2200000000000004E-2,736.74,0,0,0,0,0,0,4.0000000000000002E-4,3.58,0,0,3.6999999999999998E-2,295.48,1.1999999999999999E-3,9.98,0.92820000000000003,7419.53,15412.69,1045.7800000000007]
["P8180","Engenheiro agrimensor júnior","mês",12002,0.7984,9582.4,6.1400000000000003E-2,736.74,2.0999999999999999E-3,25.51,0,0,0,0,4.0000000000000002E-4,4.3899999999999997,0,0,2.46E-2,295.48,8.0000000000000004E-4,9.98,0.88770000000000004,10654.5,22656.5,1072.1000000000004]
["P8181","Engenheiro agrimensor pleno","mês",12338.1,0.7984,9850.74,5.9700000000000003E-2,736.74,2.0999999999999999E-3,25.51,0,0,0,0,4.0000000000000002E-4,4.3899999999999997,0,0,2.3900000000000001E-2,295.48,8.0000000000000004E-4,9.98,0.88529999999999998,10922.84,23260.94,1072.0999999999985]
["P8182","Engenheiro agrimensor sênior","mês",14173.3,0.7984,11315.96,5.1999999999999998E-2,736.74,1.8E-3,25.51,0,0,0,0,2.9999999999999997E-4,4.3899999999999997,0,0,2.0799999999999999E-2,295.48,6.9999999999999999E-4,9.98,0.874,12388.07,26561.37,1072.1100000000006]
["P8183","Geógrafo júnior","mês",3904.44,0.79620000000000002,3108.72,0.18870000000000001,736.74,6.4999999999999997E-3,25.51,0,0,0,0,8.0000000000000004E-4,3.29,0,0,7.5700000000000003E-2,295.48,2.5999999999999999E-3,9.98,1.0705,4179.72,8084.16,1071.0000000000005]
["P8184","Geógrafo pleno","mês",5205.92,0.79620000000000002,4144.96,0.14149999999999999,736.74,4.8999999999999998E-3,25.51,0,0,0,0,5.9999999999999995E-4,3.29,0,0,5.6800000000000003E-2,295.48,1.9E-3,9.98,1.0019,5215.96,10421.879999999999,1070.9999999999991]
["P8185","Geógrafo sênior","mês",10039.58,0.79620000000000002,7993.51,7.3400000000000007E-2,736.74,2.5000000000000001E-3,25.51,0,0,0,0,2.9999999999999997E-4,3.29,0,0,2.9399999999999999E-2,295.48,1E-3,9.98,0.90290000000000004,9064.52,19104.099999999999,1071.0099999999984]
["P8186","Antropólogo júnior","mês",3075.8,0.82050000000000001,2523.6999999999998,0.23949999999999999,736.74,8.3000000000000001E-3,25.51,0,0,1.12E-2,34.479999999999997,2E-3,6.14,0,0,9.6100000000000005E-2,295.48,3.2000000000000002E-3,9.98,1.1808000000000001,3632.03,6707.84,1108.3400000000001]
["P8187","Antropólogo pleno","mês",4101.07,0.82050000000000001,3364.93,0.17960000000000001,736.74,6.1999999999999998E-3,25.51,0,0,0,0,1.5E-3,6.14,0,0,7.1999999999999995E-2,295.48,2.3999999999999998E-3,9.98,1.0823,4438.78,8539.85,1073.8500000000004]
["P8188","Antropólogo sênior","mês",6246.53,0.82050000000000001,5125.28,0.1179,736.74,4.1000000000000003E-3,25.51,0,0,0,0,1E-3,6.14,0,0,4.7300000000000002E-2,295.48,1.6000000000000001E-3,9.98,0.99239999999999995,6199.13,12445.66,1073.8500000000004]
["P8189","Arqueólogo júnior","mês",2815.27,0.80889999999999995,2277.27,0.26169999999999999,736.74,9.1000000000000004E-3,25.51,0,0,1.78E-2,50.12,1.9E-3,5.28,0,0,0.105,295.48,3.5000000000000001E-3,9.98,1.2078,3400.38,6215.65,1123.1099999999997]
["P8190","Arqueólogo pleno","mês",3753.69,0.80889999999999995,3036.36,0.1963,736.74,6.7999999999999996E-3,25.51,0,0,0,0,1.4E-3,5.28,0,0,7.8700000000000006E-2,295.48,2.7000000000000001E-3,9.98,1.0948,4109.3599999999997,7863.04,1072.9900000000002]
["P8191","Arqueólogo sênior","mês",5706.15,0.80889999999999995,4615.71,0.12909999999999999,736.74,4.4999999999999997E-3,25.51,0,0,0,0,8.9999999999999998E-4,5.28,0,0,5.1799999999999999E-2,295.48,1.6999999999999999E-3,9.98,0.99690000000000001,5688.71,11394.86,1073.0000000000009]
["P8192","Historiador júnior","mês",3885.3,0.8367,3250.83,0.18959999999999999,736.74,6.6E-3,25.51,0,0,0,0,1.8E-3,6.99,0,0,7.6100000000000001E-2,295.48,2.5999999999999999E-3,9.98,1.1133,4325.53,8210.84,1074.71]
["P8193","Historiador pleno","mês",5180.3999999999996,0.8367,4334.4399999999996,0.14219999999999999,736.74,4.8999999999999998E-3,25.51,0,0,0,0,1.2999999999999999E-3,6.99,0,0,5.7000000000000002E-2,295.48,1.9E-3,9.98,1.0442,5409.15,10589.55,1074.71]
["P8194","Historiador sênior","mês",8013.69,0.8367,6705.05,9.1899999999999996E-2,736.74,3.2000000000000002E-3,25.51,0,0,0,0,8.9999999999999998E-4,6.99,0,0,3.6900000000000002E-2,295.48,1.1999999999999999E-3,9.98,0.9708,7779.76,15793.45,1074.7100000000019]
["P8195","Paleontólogo júnior","mês",3075.8,0.82050000000000001,2523.6999999999998,0.23949999999999999,736.74,8.3000000000000001E-3,25.51,0,0,1.12E-2,34.479999999999997,2E-3,6.14,0,0,9.6100000000000005E-2,295.48,3.2000000000000002E-3,9.98,1.1808000000000001,3632.03,6707.84,1108.3400000000001]
["P8196","Paleontólogo pleno","mês",4101.07,0.82050000000000001,3364.93,0.17960000000000001,736.74,6.1999999999999998E-3,25.51,0,0,0,0,1.5E-3,6.14,0,0,7.1999999999999995E-2,295.48,2.3999999999999998E-3,9.98,1.0823,4438.78,8539.85,1073.8500000000004]
["P8197","Paleontólogo sênior","mês",6246.53,0.82050000000000001,5125.28,0.1179,736.74,4.1000000000000003E-3,25.51,0,0,0,0,1E-3,6.14,0,0,4.7300000000000002E-2,295.48,1.6000000000000001E-3,9.98,0.99239999999999995,6199.13,12445.66,1073.8500000000004]
["P8198","Sociólogo júnior","mês",4027.98,0.83889999999999998,3379.07,0.18290000000000001,736.74,6.3E-3,25.51,0,0,0,0,1.8E-3,7.17,0,0,7.3400000000000007E-2,295.48,2.5000000000000001E-3,9.98,1.1057999999999999,4453.96,8481.94,1074.8900000000008]
["P8199","Sociólogo pleno","mês",5370.64,0.83889999999999998,4505.43,0.13719999999999999,736.74,4.7999999999999996E-3,25.51,0,0,0,0,1.2999999999999999E-3,7.17,0,0,5.5E-2,295.48,1.9E-3,9.98,1.0389999999999999,5580.31,10950.95,1074.8800000000001]
["P8200","Sociólogo sênior","mês",8040.47,0.83889999999999998,6745.15,9.1600000000000001E-2,736.74,3.2000000000000002E-3,25.51,0,0,0,0,8.9999999999999998E-4,7.17,0,0,3.6700000000000003E-2,295.48,1.1999999999999999E-3,9.98,0.97260000000000002,7820.04,15860.51,1074.8900000000003]
["Profissionais horistas",{"$nulls":24},0]
["P8250","Auxiliar - horista","h",7.07,1.1323000000000001,8,0.54520000000000002,3.85,2.3599999999999999E-2,0.17,1.1999999999999999E-3,0.01,9.7500000000000003E-2,0.69,4.7999999999999996E-3,0.03,0,0,0.22439999999999999,1.59,7.7000000000000002E-3,0.05,2.0367999999999999,14.39,21.46,6.3900000000000006]
["P8251","Auxiliar de laboratório - horista","h",7.82,1.1316999999999999,8.85,0.49230000000000002,3.85,2.1299999999999999E-2,0.17,2.3E-3,0.02,8.1100000000000005E-2,0.63,2.8E-3,0.02,0,0,0.20269999999999999,1.59,7.0000000000000001E-3,0.05,1.9411,15.19,23.01,6.3400000000000016]
["P8255","Engenheiro de projetos júnior - horista","h",54.55,1.1314,61.72,7.0599999999999996E-2,3.85,2.5000000000000001E-3,0.14000000000000001,0,0,0,0,4.0000000000000002E-4,0.02,0,0,2.9100000000000001E-2,1.59,1E-3,0.05,1.2350000000000001,67.37,121.93,5.6600000000000108]
["P8256","Engenheiro de projetos pleno - horista","h",56.27,1.1314,63.67,6.8400000000000002E-2,3.85,2.3999999999999998E-3,0.14000000000000001,0,0,0,0,4.0000000000000002E-4,0.02,0,0,2.8199999999999999E-2,1.59,1E-3,0.05,1.2318,69.319999999999993,125.59,5.6499999999999986]
["P8260","Laboratorista - horista","h",10.43,1.1316999999999999,11.81,0.36919999999999997,3.85,1.47E-2,0.15,0,0,4.2700000000000002E-2,0.45,2.0999999999999999E-3,0.02,0,0,0.152,1.59,5.1999999999999998E-3,0.05,1.7177,17.920000000000002,28.35,6.1099999999999994]
["P8263","Motorista de caminhão - horista ","h",10.39,1.1326000000000001,11.77,0.37069999999999997,3.85,1.6E-2,0.17,0,0,4.3200000000000002E-2,0.45,2.3E-3,0.02,0,0,0.15260000000000001,1.59,5.3E-3,0.05,1.7226999999999999,17.899999999999999,28.29,6.129999999999999]
["P8264","Motorista de veículo leve - horista","h",9.1999999999999993,1.1317999999999999,10.42,0.41849999999999998,3.85,1.8100000000000002E-2,0.17,0,0,5.8099999999999999E-2,0.53,2.3E-3,0.02,0,0,0.17230000000000001,1.59,5.8999999999999999E-3,0.05,1.8070999999999999,16.63,25.83,6.2099999999999991]
["P8267","Sondador - horista","h",9.0399999999999991,1.1315999999999999,10.23,0.4259,3.85,1.7000000000000001E-2,0.15,0,0,6.0400000000000002E-2,0.55000000000000004,2.8E-3,0.03,0,0,0.17530000000000001,1.59,6.0000000000000001E-3,0.05,1.819,16.45,25.49,6.2199999999999989]
["P8270","Técnico de obras - horista","h",14.4,1.1312,16.29,0.26750000000000002,3.85,1.0699999999999999E-2,0.15,0,0,1.0999999999999999E-2,0.16,1.4E-3,0.02,0,0,0.1101,1.59,3.8E-3,0.05,1.5358000000000001,22.11,36.51,5.8199999999999985]
["Fonte: FGV IBRE",{"$nulls":24},0]

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