{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["RESUMO","TAB.REF","CRONOGRAMA","PLAN. BDI.IMP","CVCTEC-77","CVCTEC-79","CVCTEC-80","CVCTEC-83","CVCTEC-84","PMPATOS_004DR","PMPATOS_005DR"],"not_rendered":{"charts":0,"images":4,"macros":1,"external_links":1,"defined_names":18,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"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":"RESUMO","index":0,"n_rows":23,"n_cols":8,"rows_kept":23,"cut":false,"hidden":false,"merged":[[20,1,20,4],[21,1,21,4],[22,1,22,4],[19,1,19,4],[6,3,7,3],[6,2,7,2],[6,1,7,1],[18,0,18,4],[15,0,15,3],[4,1,4,2],[4,5,4,6],[2,1,2,4],[15,5,15,6],[16,0,16,7],[14,5,14,6],[8,5,8,6],[9,5,9,6],[10,5,10,6],[11,5,11,6],[12,5,12,6],[5,0,5,6],[6,0,7,0],[6,4,6,6],[7,5,7,6],[13,5,13,6],[0,0,0,6],[1,0,1,6],[2,5,2,6],[3,1,3,2],[3,5,3,6]]}
[]
["PLANILHA ORÇAMENTÁRIA  RESUMO"]
["OBRA:","PROJETOS DE MODIFICAÇÃO, EXTENSÃO DE REDE  E ILUMINAÇÃO PÚBLICA",null,null,null,"BDI:",null,"(com desoneração)"]
["LOCAL:","DIVERSOS - MUNICIPIO DE PATOS DE MINAS",null,"ART:",null,null,null,"(sem desoneração)"]
["REFERÊNCIA:","PREÇOS DE MERCADO",null,"DATA:","2020-02-04",{"$f":"IF(H5=1,'PLAN. BDI.IMP'!D45,'PLAN. BDI.IMP'!D40)","v":0.31559999999999999},null,1]
[]
["ITEM","Descrição","BAIRRO","REFERÊNCIA","VALOR TOTAL"]
[null,null,null,null,"SEM BDI","COM BDI"]
[1,"Rua Laumar da Rocha Filgueira (extensão)","JARDIM RECANTO","CVCTEC_PMINAS_77",{"$f":"'CVCTEC-77'!F52","v":15998.86},{"$f":"'CVCTEC-77'!H52","v":21047.85}]
[2,"Avenida A (extensão)","JARDIM PANORÂMICO","CVCTEC_PMINAS_79",{"$f":"'CVCTEC-79'!F61","v":29475.75},{"$f":"'CVCTEC-79'!H61","v":38777.82}]
[3,"Av Arthur Magalhães (modificação de rede para duplicação)","NOVA FLORESTA","CVCTEC_PMINAS_80",{"$f":"'CVCTEC-80'!F128","v":84732.42},{"$f":"'CVCTEC-80'!H128","v":111473.99}]
[4,"Av dos Buritis (modificação de rede para duplicação)","ALTO DA COLINA","CVCTEC_PMINAS_83",{"$f":"'CVCTEC-83'!F123","v":92158.04},{"$f":"'CVCTEC-83'!H123","v":121244.7}]
[5,"Rua Sagitário (melhoria de rede)","JARDIM PELUZZO","CVCTEC_PMINAS_84",{"$f":"'CVCTEC-84'!F90","v":22070.53},{"$f":"'CVCTEC-84'!H90","v":29036.55}]
[6,"Praça Frei Ildeu (iluminação)","SEBASTIÃO AMORIM","PMPATOS_004DR",{"$f":"PMPATOS_004DR!F39","v":36069.68},{"$f":"PMPATOS_004DR!H39","v":47449.87}]
[7,"Praça José de Brito (iluminação)","JARDIM PELUZZO","PMPATOS_005DR",{"$f":"PMPATOS_005DR!F40","v":37121.089999999997},{"$f":"PMPATOS_005DR!H40","v":48834.11}]
["TOTAL",null,null,null,{"$f":"SUM(E9:E15)","v":317626.37},{"$f":"SUM(F9:G15)","v":417864.89}]
[]
[null,"Patos de Minas,",{"$f":"CONCATENATE(DAY(E5),\" de \",TEXT(MONTH(E5)*29,\"mmmm\"),\" de \",YEAR(E5))","v":"4 de fevereiro de 2020"}]
[]
[null,"_______________________________________________________"]
[null,"Diogo Soares Resende"]
[null,"Eng. Eletricista"]
[null,"CREA: 194.419D/MG"]

{"sheet":"TAB.REF","index":1,"n_rows":140,"n_cols":4,"rows_kept":140,"cut":false,"hidden":false,"merged":[[0,0,0,16383]]}
["VALORES DE REFERÊNCIA"]
["CÓDIGO","DESCRIÇÃO","UNIDADE","PREÇO"]
[114,"LUMINARIA LED POTÊNCIA ATÉ 114W FLUXO LUMINOSO APROXIMADO 13.100lm EFICIENCIA LUMINOSA ≥ 115lm/w","PC",880.15]
[120,"LUMINARIA LED POTÊNCIA ATÉ 120W FLUXO LUMINOSO APROXIMADO 13.800lm EFICIENCIA LUMINOSA ≥ 115lm/w","PC",767]
[150,"LUMINARIA LED POTÊNCIA ATÉ 150W FLUXO LUMINOSO APROXIMADO 17.250lm EFICIENCIA LUMINOSA ≥ 115lm/w","PC",1235]
[2931,"CABO DE AÇO MR 1/4P (6,4MM) 7 FIOS","KG",2.76]
[2964,"CABO DE AÇO HS 3/8P (9,5MM²) 7FIOS","KG",7.78]
[3954,"FITA ADESIVA ISOLANTE PVC 19MMX20M","RL",4.97]
[39586,"COBERTURA PROTETORA PARA BUCHA DE EQUIPAMENTO","PC",9.67]
[66688,"PARAFUSO CABEÇA ABAULADA M12X 40MM","PC",1.63]
[66878,"PARAFUSO CABEÇA ABAULADA M16X 45MM","PC",2.17]
[66886,"PARAFUSO CABEÇA ABAULADA M16X 70MM","PC",2.64]
[66894,"PARAFUSO CABEÇA ABAULADA M16X150MM","PC",4.3]
[74799,"PARAFUSO CABEÇA QUADRADA M16X125MM","PC",3.99]
[74807,"PARAFUSO CABEÇA QUADRADA M16X150MM","PC",4.37]
[74831,"PARAFUSO CABEÇA QUADRADA M16X300MM","PC",6.75]
[74864,"PARAFUSO CABEÇA QUADRADA M16X450MM","PC",9.7899999999999991]
[74872,"PARAFUSO CABEÇA QUADRADA M16X500MM","PC",11.41]
[75036,"PARAFUSO CABEÇA SEXTAVADA M12X 40MM","PC",12.44]
[75630,"PORCA QUADRADA M16 24X24X13MM","PC",0.68]
[75721,"ARRUELA QUADRADA 38X18X3MM","PC",0.52]
[82586,"MASSA CALAFETAR 1KG","KG",16.78]
[207415,"POSTE CONCRETO CIRCULAR 11M 300DAN","PC",695.96]
[207449,"POSTE CONCRETO CIRCULAR 11M 600DAN","PC",951.41]
[207506,"POSTE CONCRETO CIRCULAR 12M 600DAN","PC",1118.3499999999999]
[207514,"POSTE CONCRETO CIRCULAR 12M1000DAN","PC",1597.78]
[207522,"POSTE CONCRETO CIRCULAR 12M 300DAN","PC",765.08]
[211771,"BRAÇO SUPORTE L","PC",72.27]
[211789,"BRAÇO SUPORTE C","PC",92.79]
[214668,"POSTE CONCRETO RC IP 11,5M 150DAN","PC",1122.95]
[219634,"ISOLADOR ROLDANA PORCELANA OU VIDRO","PC",5.42]
[219642,"ISOLADOR PINO POLIMÉRICO 15 KV P/BRAÇO SUPORTE C","PC",20.079999999999998]
[219659,"ISOLADOR DE ANCORAGEM POLIMÉRICO 15KV ITEM 1","PC",41.77]
[219709,"ALÇA PREFORMADA OLHAL CA/CAA 34MM² (2AWG)","PC",12.17]
[220434,"CABO CA 53MM² (1/0AWG)","KG",21.15]
[222539,"HASTE ATERRAMENTO 2400MM","PC",40.75]
[223818,"CANTONEIRA PARA BRAÇO C","PC",60.9]
[225615,"CABO CU 1X 1,5MM² 1KV XLPE","M",1.1499999999999999]
[225623,"CABO AL 1X 16MM² 1KV","M",1.85]
[225656,"CABO AL 1X 70MM² 1KV","M",6.53]
[225896,"CABO CU 1X 2,5MM² 750V","M",1.53]
[226373,"CABO QUADRUPLEX CA 3X1X 70+70 1KV","M",22.81]
[227066,"CONETOR TERMINAL COMP CA/CAA 54MM² / 70MM² COMPACT","PC",5.48]
[227389,"CONETOR TERMINAL COMPRESSÃO 1F AÇO 6,4MM / 21MM²","PC",2.0699999999999998]
[227769,"CONETOR FORMATO H ITEM 1 CAA 13-34MM² / 13-34MM²","PC",2.25]
[227777,"CONETOR FORMATO H ITEM 2 CAA 27-54MM² / 13-34MM²","PC",2.71]
[227785,"CONETOR FORMATO H ITEM 3 CAA 42-67MM² / 42-67MM²","PC",4.7699999999999996]
[227850,"CONETOR CUNHA CU ITEM 1","PC",3.79]
[227868,"CONETOR CUNHA CU ITEM 2","PC",2.81]
[228874,"ALÇA PREFORMADA NEUTRO CA/CAL 35MM²","PC",4.7699999999999996]
[228890,"ALÇA PREFORMADA CA/CAA 54MM² (1/0AWG)","PC",7.35]
[228981,"ALÇA PREFORMADA NEUTRO CA/CAL 16MM²","PC",1.3]
[229005,"ALÇA PREFORMADA NEUTRO CA/CAL 70MM²","PC",6.03]
[230367,"LAÇO PREFORMADO DE TOPO CA/CAA 34MM² (2AWG)","PC",3.52]
[231175,"CONETOR PARA ATERRAMENTO DE FERRAGENS DE IP","PC",1.3]
[231522,"ALÇA PARA ESTRIBO FECHADA 2AWG","PC",8.61]
[231548,"CABO AL 1X 50MM² 15KV PROTEGIDO","M",7.15]
[231555,"SUPORTE Z PARA CHAVE FUSÍVEL","PC",14.06]
[231589,"CABO TRIPLEX CA 2X1X70+70 1KV","M",16.079999999999998]
[231662,"ESPAÇADOR LOSANGULAR 50-150MM² 15KV","CJ",21.82]
[231688,"CONETOR CUNHA CU ITEM 7","PC",3.9]
[231696,"CONETOR CUNHA CU ITEM 6","PC",4.2699999999999996]
[231712,"BRAÇO SUPORTE COM GRAMPO DE SUSPENSÃO ITEM 2","CJ",38.380000000000003]
[231753,"CONETOR CUNHA AL 150-50MM²","PC",14.41]
[231795,"CONETOR CUNHA AL 50MM² COM ESTRIBO","PC",14.96]
[231811,"CONETOR CUNHA AL 150MM² COM ESTRIBO","PC",31.85]
[231860,"CARTUCHO DE APLICAÇÃO AZUL","PC",6.53]
[231878,"CARTUCHO DE APLICAÇÃO VERMELHO","PC",6.54]
[231886,"CONETOR TERMINAL COMPRESSÃO 1F 50MM²","PC",1.92]
[234567,"GRAMPO ANCORAGEM PARA CABO 50MM² 15KV","PC",20.12]
[234575,"GRAMPO ANCORAGEM PARA CABO 150MM² 15KV","PC",23.4]
[236265,"PINO P/ ISOLADOR POLIMÉRICO ATÉ 36,2 KV - BRAÇO C","PC",15.35]
[236836,"CINTA DE AÇO D 170MM","PC",16.28]
[236844,"CINTA DE AÇO D 180MM","PC",16.510000000000002]
[236851,"CINTA DE AÇO D 190MM","PC",17.48]
[236869,"CINTA DE AÇO D 200MM","PC",17.93]
[236877,"CINTA DE AÇO D 210MM","PC",18.52]
[236885,"CINTA DE AÇO D 220MM","PC",18.66]
[236893,"CINTA DE AÇO D 230MM","PC",19.34]
[236901,"CINTA DE AÇO D 240MM","PC",20.51]
[236919,"CINTA DE AÇO D 250MM","PC",21.79]
[236927,"CINTA DE AÇO D 260MM","PC",21.62]
[236935,"CINTA DE AÇO D 270MM","PC",22.15]
[236943,"CINTA DE AÇO D 280MM","PC",25.47]
[236950,"CINTA DE AÇO D 290MM","PC",23.93]
[237081,"SUPORTE 240MM TRANSFORMADOR POSTE CC","PC",104.81]
[237156,"SELA PARA CRUZETA","PC",8.8800000000000008]
[237172,"SUPORTE L PARA CRUZETA","PC",25.98]
[237222,"AFASTADOR ARMAÇÃO SECUNDÁRIA 500MM","PC",124.8]
[237230,"ARMAÇÃO SECUNDÁRIO 1 ESTRIBO","PC",11]
[237248,"ARMAÇÃO SECUNDÁRIO 2 ESTRIBOS","PC",23.33]
[237271,"MANILHA SAPATILHA CLASSE 50KN","PC",10.91]
[237289,"OLHAL PARA PARAFUSO 50KN","PC",16.760000000000002]
[237677,"ALÇA PREFORMADA ESTAI CABO AÇO 9,5MM","PC",12.24]
[237685,"ALÇA PREFORMADA ESTAI CABO AÇO 6,4MM","PC",6.75]
[237701,"FIXADOR PREFORMADO ESTAI 6,4MM","PC",6.68]
[237768,"SAPATILHA","PC",1.99]
[237776,"SUPORTE L DE TOPO DE POSTE ITEM 1","PC",32.39]
[237784,"MÃO-FRANCESA PERFILADA NORMAL 38X5X726MM","PC",22.64]
[245837,"TRANSFORMADOR TRIFÁSICO 15KV 45KVA","PC",5284]
[258905,"BRAÇO PARA IP TIPO CURTO","PC",39.799999999999997]
[258921,"BRAÇO PARA IP TIPO MÉDIO","PC",166.63]
[270439,"CHAVE FUSÍVEL 15KV COM PORTA FUSÍVEL 100A 7,1KA","PC",243.45]
[271353,"ELO FUSÍVEL BOTÃO 500MM 3H","PC",4.3]
[289058,"PÁRA-RAIOS 12KV 10KA ZNO","PC",153.69]
[293357,"PÁRA-RAIOS REDE SECUNDÁRIA ISOLADA 280V 10KA","PC",59.64]
[299560,"ARO COM TAMPA ARTICULADA CAIXA ZA","CJ",139.08000000000001]
[306555,"ANEL CAIXA ZA CONCRETO PREMOLDADO","PC",51.32]
[327361,"RELÉ FOTOELÉTRICO ELETRÔNICO 105-305V","PC",19.100000000000001]
[327692,"BRAÇADEIRA PLÁSTICA CABO MULTIPLEXADO","PC",1.1499999999999999]
[327700,"ANEL ELASTOMÉRICO P/ ISOLADOR PINO POLIMÉRICO 15KV","PC",4.29]
[327726,"CONETOR DE PERFURAÇÃO 10-70MM²/6-35MM²","PC",8.25]
[327767,"CONETOR DE PERFURAÇÃO 70-240MM²/70-120MM²","PC",16]
[328120,"ESTRIBO PARA BRAÇO TIPO L PARA RDAP","PC",10.94]
[328138,"BRAÇO ANTIBALANÇO 15KV","PC",25.79]
[331728,"CONETOR CUNHA ITEM 2 + COBERTURA ISOLANTE ITEM 2","PC",3.63]
[338731,"CONETOR TERMINAL COMPRESSÃO 16MM²","PC",2.12]
[354899,"LÂMPADA VAPOR DE SÓDIO 150W AP E-40 TUBULAR","PC",30.81]
[354900,"LUMINÁRIA COM EQUIPAMENTO VS 150W TUBULAR","PC",359.87]
[354903,"SUPORTE IP 2 LUMINÁRIAS POSTE RC OU AÇO 10/12/14M","PC",160]
[355028,"REATOR LÂMPADA VS 150W INTEGRADO","PC",75.36]
[357342,"FIO PARA AMARRAÇÃO ALUMÍNIO RECOZIDO 5,2MM (4AWG)","KG",31.05]
[374393,"MANTA AUTO-ADESIVA PARA EMENDA CABO 15KV RDP","PC",66.28]
[375058,"COBERTURA PROTETORA P/ BCH BT TRANSFORMADOR ITEM 1","PC",8.41]
[375718,"ISOLADOR PILAR PORCELANA 15KV","PC",57.98]
[375720,"PINO PARA ISOLADOR PILAR","PC",7.03]
[376109,"LUMINÁRIA COM EQUIPAMENTO VS 100W VIDRO PLANO","PC",269.72000000000003]
[376112,"REATOR LÂMPADA VS 100W INTEGRADO CONECTOR RÁPIDO","PC",45.5]
[376238,"LÂMPADA VAPOR DE SÓDIO 100W AP E-40 TUBULAR","PC",24.46]
[377357,"CONETOR TERMINAL ATERRAMENTO TEMPORÁRIO DE CHAVE","PC",8.6300000000000008]
[377568,"DUTO PEAD CORRUGADO DEN 63MM","M",10.5]
[377705,"CRUZETA DE FIBRA DE VIDRO 2400X112,5X90MM","PC",210.26]
[378809,"CONECTOR TERMINAL P/ BUCHA,50 MM²,RETO,COMPRESSÃO","PC",12.06]
[378842,"GRAMPO DE LINHA VIVA","PC",57.96]
[378849,"CONECTOR,PERFURAÇÃO,AL/CU,16-70/1,5-6MM²,RDS.","PC",84.24]
[379679,"CONETOR DE PERFURAÇÃO 35-120MM²/1,5MM²","PC",5.98]
["SINAPI34623","DISJUNTOR TIPO DIN/IEC, BIPOLAR 40A","PC",51.47]
["SUP3","SUPORTE IP 3 LUMINÁRIAS POSTE RC OU AÇO 10/12/14M","PC",221]
["US. CONST. RDA","MÃO DE OBRA DE CONSTRUÇÃO DE REDE ELÉTRICA","US",1538.3]
["US. CONST. RDS","MÃO DE OBRA DE CONSTRUÇÃO DE REDE SUBTERRÂNEA","US",1538.3]

{"sheet":"CRONOGRAMA","index":2,"n_rows":40,"n_cols":18,"rows_kept":40,"cut":false,"hidden":false,"merged":[[37,4,37,13],[38,4,38,13],[39,4,39,13],[33,4,33,13],[1,0,1,17],[2,1,2,17],[3,1,3,17],[4,1,4,6],[4,7,4,11],[4,12,4,14],[4,15,4,17],[5,0,5,17],[6,0,8,0],[6,1,8,6],[6,7,8,7],[6,8,8,8],[6,9,6,17],[7,9,7,11],[7,12,7,14],[7,15,7,17],[9,1,9,6],[10,1,10,6],[11,1,11,6],[30,0,30,17],[31,1,31,6],[18,1,18,6],[19,1,19,6],[20,1,20,6],[21,1,21,6],[35,0,35,6],[36,0,36,17],[12,1,12,6],[13,1,13,6],[14,1,14,6],[15,1,15,6],[16,1,16,6],[17,1,17,6],[28,1,28,6],[29,1,29,6],[22,1,22,6],[23,1,23,6],[24,1,24,6],[25,1,25,6],[26,1,26,6],[27,1,27,6]]}
[]
["CRONOGRAMA FISICO-FINANCEIRO"]
["OBRA:","PROJETOS DE MODIFICAÇÃO, EXTENSÃO DE REDE  E ILUMINAÇÃO PÚBLICA"]
["LOCAL:","DIVERSOS - MUNICIPIO DE PATOS DE MINAS"]
["REFERÊNCIA:","PREÇOS DE MERCADO_COTAÇÃO Janeiro/2020",null,null,null,null,null,"BDI (PUBLICAÇÃO TCU - ACÓRDÃO Nº 2622/2013):",null,null,null,null,{"$f":"RESUMO!F5","v":0.31559999999999999},null,null,{"$f":"RESUMO!E5","v":"2020-02-04"}]
[]
["ITEM","DISCRIMINAÇÃO DE SERVIÇOS",null,null,null,null,null,"VALOR SERVIÇOS (R$)","PESO (%)","SERVIÇOS A EXECUTAR"]
[null,null,null,null,null,null,null,null,null,"MÊS - 1",null,null,"MÊS - 2",null,null,"MÊS - 3"]
[null,null,null,null,null,null,null,null,null,"SIMPL.%","R$","ACUM.%","SIMPL.%","R$","ACUM.%","SIMPL.%","R$","ACUM.%"]
[1,{"$f":"'CVCTEC-77'!$A$4","v":"LOCAL: CVCTEC_PMINAS_77 - RUA LAUMAR ROCHA FILGUEIRA E OUTRAS - B. JARDIM RECANTO"},null,null,null,null,null,{"$f":"SUM(H11:H12)","v":21047.85}]
["1.1","MATERIAL",null,null,null,null,null,{"$f":"'CVCTEC-77'!H50:I50","v":9815.82},{"$f":"H11/$H$32","v":2.35E-2},0.15,{"$f":"J11*H11","v":1472.37},{"$f":"J11","v":0.15},0.35,{"$f":"M11*H11","v":3435.54},{"$f":"L11+M11","v":0.5},0.5,{"$f":"P11*H11","v":4907.91},{"$f":"O11+P11","v":1}]
["1.2","MÃO DE OBRA",null,null,null,null,null,{"$f":"'CVCTEC-77'!H51:I51","v":11232.03},{"$f":"H12/$H$32","v":2.69E-2},0.15,{"$f":"J12*H12","v":1684.8},{"$f":"J12","v":0.15},0.35,{"$f":"M12*H12","v":3931.21},{"$f":"L12+M12","v":0.5},0.5,{"$f":"P12*H12","v":5616.02},{"$f":"O12+P12","v":1}]
[2,{"$f":"'CVCTEC-79'!$A$4","v":"LOCAL: CVCTEC_PMINAS_79 - AV. A - B. JARDIM PANORAMICO"},null,null,null,null,null,{"$f":"SUM(H14:H15)","v":38777.82}]
["2.1","MATERIAL",null,null,null,null,null,{"$f":"'CVCTEC-79'!H59:I59","v":22081.55},{"$f":"H14/$H$32","v":5.28E-2},0.15,{"$f":"J14*H14","v":3312.23},{"$f":"J14","v":0.15},0.35,{"$f":"M14*H14","v":7728.54},{"$f":"L14+M14","v":0.5},0.5,{"$f":"P14*H14","v":11040.78},{"$f":"O14+P14","v":1}]
["2.2","MÃO DE OBRA",null,null,null,null,null,{"$f":"'CVCTEC-79'!H60:I60","v":16696.27},{"$f":"H15/$H$32","v":0.04},0.15,{"$f":"J15*H15","v":2504.44},{"$f":"J15","v":0.15},0.35,{"$f":"M15*H15","v":5843.69},{"$f":"L15+M15","v":0.5},0.5,{"$f":"P15*H15","v":8348.14},{"$f":"O15+P15","v":1}]
[3,{"$f":"'CVCTEC-80'!$A$4","v":"LOCAL: CVCTEC_PMINAS_80 - RUA ARTHUR MAGALHAES - B. NOVA FLORESTA"},null,null,null,null,null,{"$f":"SUM(H17:H18)","v":111473.99}]
["3.1","MATERIAL",null,null,null,null,null,{"$f":"'CVCTEC-80'!H126:I126","v":73527.929999999993},{"$f":"H17/$H$32","v":0.17599999999999999},0.15,{"$f":"J17*H17","v":11029.19},{"$f":"J17","v":0.15},0.35,{"$f":"M17*H17","v":25734.78},{"$f":"L17+M17","v":0.5},0.5,{"$f":"P17*H17","v":36763.97},{"$f":"O17+P17","v":1}]
["3.2","MÃO DE OBRA",null,null,null,null,null,{"$f":"'CVCTEC-80'!H127:I127","v":37946.06},{"$f":"H18/$H$32","v":9.0800000000000006E-2},0.15,{"$f":"J18*H18","v":5691.91},{"$f":"J18","v":0.15},0.35,{"$f":"M18*H18","v":13281.12},{"$f":"L18+M18","v":0.5},0.5,{"$f":"P18*H18","v":18973.03},{"$f":"O18+P18","v":1}]
[4,{"$f":"'CVCTEC-83'!$A$4","v":"LOCAL: CVCTEC_PMINAS_83 - AVENIDA DOS BURITIS - B. ALTO DA COLINA"},null,null,null,null,null,{"$f":"SUM(H20:H21)","v":121244.7}]
["4.1","MATERIAL",null,null,null,null,null,{"$f":"'CVCTEC-83'!H121:I121","v":83096.259999999995},{"$f":"H20/$H$32","v":0.19889999999999999},0.15,{"$f":"J20*H20","v":12464.44},{"$f":"J20","v":0.15},0.35,{"$f":"M20*H20","v":29083.69},{"$f":"L20+M20","v":0.5},0.5,{"$f":"P20*H20","v":41548.129999999997},{"$f":"O20+P20","v":1}]
["4.2","MÃO DE OBRA",null,null,null,null,null,{"$f":"'CVCTEC-83'!H122:I122","v":38148.44},{"$f":"H21/$H$32","v":9.1300000000000006E-2},0.15,{"$f":"J21*H21","v":5722.27},{"$f":"J21","v":0.15},0.35,{"$f":"M21*H21","v":13351.95},{"$f":"L21+M21","v":0.5},0.5,{"$f":"P21*H21","v":19074.22},{"$f":"O21+P21","v":1}]
[5,{"$f":"'CVCTEC-84'!$A$4","v":"LOCAL: CVCTEC_PMINAS_84 - RUA SAGITÁRIO - JARDIM PELUZZO"},null,null,null,null,null,{"$f":"SUM(H23:H24)","v":29036.55}]
["5.1","MATERIAL",null,null,null,null,null,{"$f":"'CVCTEC-84'!H88:I88","v":19929.490000000002},{"$f":"H23/$H$32","v":4.7699999999999999E-2},0.15,{"$f":"J23*H23","v":2989.42},{"$f":"J23","v":0.15},0.35,{"$f":"M23*H23","v":6975.32},{"$f":"L23+M23","v":0.5},0.5,{"$f":"P23*H23","v":9964.75},{"$f":"O23+P23","v":1}]
["5.2","MÃO DE OBRA",null,null,null,null,null,{"$f":"'CVCTEC-84'!H89:I89","v":9107.06},{"$f":"H24/$H$32","v":2.18E-2},0.15,{"$f":"J24*H24","v":1366.06},{"$f":"J24","v":0.15},0.35,{"$f":"M24*H24","v":3187.47},{"$f":"L24+M24","v":0.5},0.5,{"$f":"P24*H24","v":4553.53},{"$f":"O24+P24","v":1}]
[6,{"$f":"CONCATENATE(PMPATOS_004DR!A5,\" \",PMPATOS_004DR!B5)","v":"LOCAL: PMPATOS_004DR - PRAÇA FREI ILDEU - SEBASTIÃO AMORIM"},null,null,null,null,null,{"$f":"SUM(H26:H27)","v":47449.87}]
["6.1","MATERIAL",null,null,null,null,null,{"$f":"PMPATOS_004DR!H37","v":34619.040000000001},{"$f":"H26/$H$32","v":8.2799999999999999E-2},0.15,{"$f":"J26*H26","v":5192.8599999999997},{"$f":"J26","v":0.15},0.35,{"$f":"M26*H26","v":12116.66},{"$f":"L26+M26","v":0.5},0.5,{"$f":"P26*H26","v":17309.52},{"$f":"O26+P26","v":1}]
["6.2","MÃO DE OBRA",null,null,null,null,null,{"$f":"PMPATOS_004DR!H38","v":12830.83},{"$f":"H27/$H$32","v":3.0700000000000002E-2},0.15,{"$f":"J27*H27","v":1924.62},{"$f":"J27","v":0.15},0.35,{"$f":"M27*H27","v":4490.79},{"$f":"L27+M27","v":0.5},0.5,{"$f":"P27*H27","v":6415.42},{"$f":"O27+P27","v":1}]
[7,{"$f":"CONCATENATE(PMPATOS_004DR!A5,\" \",PMPATOS_005DR!B5)","v":"LOCAL: PMPATOS_005DR - PRAÇA JOSÉ DE BRITO - JARDIM PELUZZO"},null,null,null,null,null,{"$f":"SUM(H29:H30)","v":48834.11}]
["7.1","MATERIAL",null,null,null,null,null,{"$f":"PMPATOS_005DR!H38","v":26875.99},{"$f":"H29/$H$32","v":6.4299999999999996E-2},0.15,{"$f":"J29*H29","v":4031.4},{"$f":"J29","v":0.15},0.35,{"$f":"M29*H29","v":9406.6},{"$f":"L29+M29","v":0.5},0.5,{"$f":"P29*H29","v":13438},{"$f":"O29+P29","v":1}]
["7.2","MÃO DE OBRA",null,null,null,null,null,{"$f":"PMPATOS_005DR!H39","v":21958.12},{"$f":"H30/$H$32","v":5.2499999999999998E-2},0.15,{"$f":"J30*H30","v":3293.72},{"$f":"J30","v":0.15},0.35,{"$f":"M30*H30","v":7685.34},{"$f":"L30+M30","v":0.5},0.5,{"$f":"P30*H30","v":10979.06},{"$f":"O30+P30","v":1}]
[]
[null,"TOTAIS",null,null,null,null,null,{"$f":"SUM(H10:H30)/2","v":417864.89},{"$f":"H32/$H$32","v":1},0.15,{"$f":"J32*H32","v":62679.73},{"$f":"J32","v":0.15},0.35,{"$f":"M32*H32","v":146252.71},{"$f":"L32+M32","v":0.5},0.5,{"$f":"P32*H32","v":208932.45},{"$f":"O32+P32","v":1}]
[]
[null,null,null,null,{"$f":"CONCATENATE(RESUMO!B18,\" \",RESUMO!C18)","v":"Patos de Minas, 4 de fevereiro de 2020"}]
[]
[]
["_______________________________________________________"]
[null,null,null,null,{"$f":"RESUMO!B21","v":"Diogo Soares Resende"}]
[null,null,null,null,{"$f":"RESUMO!B22","v":"Eng. Eletricista"}]
[null,null,null,null,{"$f":"RESUMO!B23","v":"CREA: 194.419D/MG"}]

{"sheet":"PLAN. BDI.IMP","index":3,"n_rows":61,"n_cols":10,"rows_kept":61,"cut":false,"hidden":false,"merged":[[1,0,1,9],[2,0,2,9],[4,0,4,9],[5,0,5,9],[49,0,51,9],[44,1,45,2],[44,3,45,4],[6,8,6,9],[30,0,30,9],[35,0,35,1],[39,1,40,2],[39,3,40,4],[39,5,40,6],[57,0,57,9],[58,0,58,9],[59,0,59,9],[60,0,60,9],[56,0,56,4]]}
[]
["COMPOSIÇÃO DO BDI (Bonificações e Despesas Indiretas)"]
["\"Estações e Redes de Distribuição de Energia Elétrica\""]
[]
["OBJETO: PROJETOS DE MODIFICAÇÃO, EXTENSÃO DE REDE  E ILUMINAÇÃO PÚBLICA"]
["LOCAL:  DIVERSOS - MUNICIPIO DE PATOS DE MINAS"]
["PROF. RESP.: DIOGO SOARES RESENDE",null,null,null,null,"CREA-MG","194.419/D","DATA:",{"$f":"RESUMO!E5","v":"2020-02-04"}]
[]
["1) ADMINISTRAÇÃO CENTRAL - ( 5,29% a 7,93%)"]
[]
[null,5.3699999999999998E-2]
[null,null,null,null,null,"Adm. Central, Seguros e Garantias, Riscos",null,null,null,{"$f":"1+B11+B15+B20","v":1.0784}]
["2) SEGUROS E GARANTIAS - ( 0,25% a 0,56%)",null,null,null,null,"Despesas Financeiras",null,null,null,{"$f":"1+B24","v":1.0111000000000001}]
[null,null,null,null,null,"Lucro/Remuneração",null,null,null,{"$f":"1+B28","v":1.0841000000000001}]
[null,5.0000000000000001E-3,null,null,null,"Impostos (com desoneração)",null,null,null,{"$f":"1-C34-E34-G34-C36","v":0.89849999999999997}]
[null,null,null,null,null,"Impostos (sem desoneração)",null,null,null,{"$f":"1-C34-E34-G34","v":0.94350000000000001}]
[]
["3) RISCOS  -  ( 1,00% a 1,97%)"]
[]
[null,1.9699999999999999E-2]
[]
["4) DESPESAS FINANCEIRAS - ( 1,01% a 1,11%)"]
[]
[null,1.11E-2]
[]
["5) LUCRO/REMUNERAÇÃO  - (8,00% a 9,51%)"]
[]
[null,8.4099999999999994E-2]
[]
["6) IMPOSTOS"]
[" - ISS - Variação de 2% a 5% - Justificado pela Legislação Tributária Municipal com apresentação da base de cálculo da alíquota."]
[]
[]
[null,"COFINS=",0.03,"PIS=",6.4999999999999997E-3,"ISS=",0.02]
[]
["CPRB=",null,4.4999999999999998E-2]
[]
["A) Sem desoneração:"]
[]
[null,"BDI=",null,{"$f":"(J12*J13*J14)/J16-1","v":0.25290000000000001},null,"Faixa referencial",null,"1º Quartil","Médio","3º Quartil"]
[null,null,null,null,null,null,null,0.24,0.25840000000000002,0.27860000000000001]
[]
["B) Com desoneração:"]
[]
[null,"BDI=",null,{"$f":"(J12*J13*J14/J15)-1","v":0.31559999999999999}]
[]
[]
[]
["Observação:"]
["Composição para \"Estações e Redes de Distribuição de Energia Elétrica\", conforme classificação 4221-9/03 do CNAE 2.0."]
[]
[]
[]
[]
[]
[null,null,null,null,"Patos de Minas,",{"$f":"RESUMO!C18","v":"4 de fevereiro de 2020"}]
[]
["_______________________________________________________"]
[{"$f":"RESUMO!B21","v":"Diogo Soares Resende"}]
[{"$f":"RESUMO!B22","v":"Eng. Eletricista"}]
[{"$f":"RESUMO!B23","v":"CREA: 194.419D/MG"}]

{"sheet":"CVCTEC-77","index":4,"n_rows":61,"n_cols":9,"rows_kept":61,"cut":false,"hidden":false,"merged":[[57,0,57,8],[60,0,60,8],[59,0,59,8],[51,0,51,4],[51,5,51,6],[51,7,51,8],[54,0,54,8],[56,0,56,6],[58,0,58,9],[49,0,49,4],[49,5,49,6],[49,7,49,8],[50,0,50,4],[50,5,50,6],[50,7,50,8],[47,0,47,4],[47,5,47,6],[47,7,47,8],[48,0,48,4],[48,5,48,6],[48,7,48,8],[42,0,42,4],[42,5,42,6],[42,7,42,8],[43,0,43,4],[43,5,43,6],[43,7,43,8],[6,0,6,8],[7,0,8,0],[7,1,8,1],[7,2,8,2],[7,3,8,3],[7,4,8,4],[7,5,7,6],[7,7,7,8],[1,0,1,8],[2,0,2,8],[3,0,3,8],[4,0,4,4],[5,0,5,4]]}
[]
["PLANILHA ORÇAMENTÁRIA "]
["OBJETO: PROJETOS DE MODIFICAÇÃO, EXTENSÃO DE REDE  E ILUMINAÇÃO PÚBLICA"]
["LOCAL: CVCTEC_PMINAS_77 - RUA LAUMAR ROCHA FILGUEIRA E OUTRAS - B. JARDIM RECANTO"]
["RESPONSÁVEL TÉCNICO: DIOGO SOARES RESENDE",null,null,null,null,"CREA:",{"$f":"LEFT(RIGHT(RESUMO!B23,11),8)","v":"194.419D"},"ART:"]
["REFERENCIA DE PREÇOS: PREÇOS DE MERCADO",null,null,null,null,"DATA: ",{"$f":"RESUMO!E5","v":"2020-02-04"},"BDI :",{"$f":"RESUMO!F5","v":0.31559999999999999}]
[]
["ITEM","CÓDIGO ","DESCRIÇÃO","UNID.","QUANT.","PREÇO SEM BDI",null,"PREÇO COM BDI"]
[null,null,null,null,null,"UNITÁRIO ","TOTAL","UNITÁRIO ","TOTAL"]
[1,228981,{"$f":"VLOOKUP(B10,TAB.REF!$A$3:$D$140,2)","v":"ALÇA PREFORMADA NEUTRO CA/CAL 16MM²"},{"$f":"VLOOKUP(B10,TAB.REF!$A$3:$D$140,3)","v":"PC"},10,{"$f":"VLOOKUP(B10,TAB.REF!$A$3:$D$140,4)","v":1.3},{"$f":"ROUND(F10*E10,2)","v":13},{"$f":"ROUND(F10*(1+$I$6),2)","v":1.71},{"$f":"ROUND(H10*E10,2)","v":17.100000000000001}]
[2,229005,{"$f":"VLOOKUP(B11,TAB.REF!$A$3:$D$140,2)","v":"ALÇA PREFORMADA NEUTRO CA/CAL 70MM²"},{"$f":"VLOOKUP(B11,TAB.REF!$A$3:$D$140,3)","v":"PC"},6,{"$f":"VLOOKUP(B11,TAB.REF!$A$3:$D$140,4)","v":6.03},36.18,7.93,47.58]
[3,327692,{"$f":"VLOOKUP(B12,TAB.REF!$A$3:$D$140,2)","v":"BRAÇADEIRA PLÁSTICA CABO MULTIPLEXADO"},{"$f":"VLOOKUP(B12,TAB.REF!$A$3:$D$140,3)","v":"PC"},15,{"$f":"VLOOKUP(B12,TAB.REF!$A$3:$D$140,4)","v":1.1499999999999999},17.25,1.51,22.65]
[4,258905,{"$f":"VLOOKUP(B13,TAB.REF!$A$3:$D$140,2)","v":"BRAÇO PARA IP TIPO CURTO"},{"$f":"VLOOKUP(B13,TAB.REF!$A$3:$D$140,3)","v":"PC"},2,{"$f":"VLOOKUP(B13,TAB.REF!$A$3:$D$140,4)","v":39.799999999999997},79.599999999999994,52.36,104.72]
[5,231712,{"$f":"VLOOKUP(B14,TAB.REF!$A$3:$D$140,2)","v":"BRAÇO SUPORTE COM GRAMPO DE SUSPENSÃO ITEM 2"},{"$f":"VLOOKUP(B14,TAB.REF!$A$3:$D$140,3)","v":"CJ"},2,{"$f":"VLOOKUP(B14,TAB.REF!$A$3:$D$140,4)","v":38.380000000000003},76.760000000000005,50.49,100.98]
[6,225615,{"$f":"VLOOKUP(B15,TAB.REF!$A$3:$D$140,2)","v":"CABO CU 1X 1,5MM² 1KV XLPE"},{"$f":"VLOOKUP(B15,TAB.REF!$A$3:$D$140,3)","v":"M"},18,{"$f":"VLOOKUP(B15,TAB.REF!$A$3:$D$140,4)","v":1.1499999999999999},20.7,1.51,27.18]
[7,2931,{"$f":"VLOOKUP(B16,TAB.REF!$A$3:$D$140,2)","v":"CABO DE AÇO MR 1/4P (6,4MM) 7 FIOS"},{"$f":"VLOOKUP(B16,TAB.REF!$A$3:$D$140,3)","v":"KG"},3.6,{"$f":"VLOOKUP(B16,TAB.REF!$A$3:$D$140,4)","v":2.76},9.94,3.63,13.07]
[8,226373,{"$f":"VLOOKUP(B17,TAB.REF!$A$3:$D$140,2)","v":"CABO QUADRUPLEX CA 3X1X 70+70 1KV"},{"$f":"VLOOKUP(B17,TAB.REF!$A$3:$D$140,3)","v":"M"},91,{"$f":"VLOOKUP(B17,TAB.REF!$A$3:$D$140,4)","v":22.81},2075.71,30.01,2730.91]
[9,231589,{"$f":"VLOOKUP(B18,TAB.REF!$A$3:$D$140,2)","v":"CABO TRIPLEX CA 2X1X70+70 1KV"},{"$f":"VLOOKUP(B18,TAB.REF!$A$3:$D$140,3)","v":"M"},38,{"$f":"VLOOKUP(B18,TAB.REF!$A$3:$D$140,4)","v":16.079999999999998},611.04,21.15,803.7]
[10,236836,{"$f":"VLOOKUP(B19,TAB.REF!$A$3:$D$140,2)","v":"CINTA DE AÇO D 170MM"},{"$f":"VLOOKUP(B19,TAB.REF!$A$3:$D$140,3)","v":"PC"},2,{"$f":"VLOOKUP(B19,TAB.REF!$A$3:$D$140,4)","v":16.28},32.56,21.42,42.84]
[11,236877,{"$f":"VLOOKUP(B20,TAB.REF!$A$3:$D$140,2)","v":"CINTA DE AÇO D 210MM"},{"$f":"VLOOKUP(B20,TAB.REF!$A$3:$D$140,3)","v":"PC"},10,{"$f":"VLOOKUP(B20,TAB.REF!$A$3:$D$140,4)","v":18.52},185.2,24.36,243.6]
[12,236893,{"$f":"VLOOKUP(B21,TAB.REF!$A$3:$D$140,2)","v":"CINTA DE AÇO D 230MM"},{"$f":"VLOOKUP(B21,TAB.REF!$A$3:$D$140,3)","v":"PC"},4,{"$f":"VLOOKUP(B21,TAB.REF!$A$3:$D$140,4)","v":19.34},77.36,25.44,101.76]
[13,227850,{"$f":"VLOOKUP(B22,TAB.REF!$A$3:$D$140,2)","v":"CONETOR CUNHA CU ITEM 1"},{"$f":"VLOOKUP(B22,TAB.REF!$A$3:$D$140,3)","v":"PC"},9,{"$f":"VLOOKUP(B22,TAB.REF!$A$3:$D$140,4)","v":3.79},34.11,4.99,44.91]
[14,227868,{"$f":"VLOOKUP(B23,TAB.REF!$A$3:$D$140,2)","v":"CONETOR CUNHA CU ITEM 2"},{"$f":"VLOOKUP(B23,TAB.REF!$A$3:$D$140,3)","v":"PC"},5,{"$f":"VLOOKUP(B23,TAB.REF!$A$3:$D$140,4)","v":2.81},14.05,3.7,18.5]
[15,231696,{"$f":"VLOOKUP(B24,TAB.REF!$A$3:$D$140,2)","v":"CONETOR CUNHA CU ITEM 6"},{"$f":"VLOOKUP(B24,TAB.REF!$A$3:$D$140,3)","v":"PC"},1,{"$f":"VLOOKUP(B24,TAB.REF!$A$3:$D$140,4)","v":4.2699999999999996},4.2699999999999996,5.62,5.62]
[16,331728,{"$f":"VLOOKUP(B25,TAB.REF!$A$3:$D$140,2)","v":"CONETOR CUNHA ITEM 2 + COBERTURA ISOLANTE ITEM 2"},{"$f":"VLOOKUP(B25,TAB.REF!$A$3:$D$140,3)","v":"PC"},5,{"$f":"VLOOKUP(B25,TAB.REF!$A$3:$D$140,4)","v":3.63},18.149999999999999,4.78,23.9]
[17,327726,{"$f":"VLOOKUP(B26,TAB.REF!$A$3:$D$140,2)","v":"CONETOR DE PERFURAÇÃO 10-70MM²/6-35MM²"},{"$f":"VLOOKUP(B26,TAB.REF!$A$3:$D$140,3)","v":"PC"},5,{"$f":"VLOOKUP(B26,TAB.REF!$A$3:$D$140,4)","v":8.25},41.25,10.85,54.25]
[18,379679,{"$f":"VLOOKUP(B27,TAB.REF!$A$3:$D$140,2)","v":"CONETOR DE PERFURAÇÃO 35-120MM²/1,5MM²"},{"$f":"VLOOKUP(B27,TAB.REF!$A$3:$D$140,3)","v":"PC"},8,{"$f":"VLOOKUP(B27,TAB.REF!$A$3:$D$140,4)","v":5.98},47.84,7.87,62.96]
[19,327767,{"$f":"VLOOKUP(B28,TAB.REF!$A$3:$D$140,2)","v":"CONETOR DE PERFURAÇÃO 70-240MM²/70-120MM²"},{"$f":"VLOOKUP(B28,TAB.REF!$A$3:$D$140,3)","v":"PC"},6,{"$f":"VLOOKUP(B28,TAB.REF!$A$3:$D$140,4)","v":16},96,21.05,126.3]
[20,227777,{"$f":"VLOOKUP(B29,TAB.REF!$A$3:$D$140,2)","v":"CONETOR FORMATO H ITEM 2 CAA 27-54MM² / 13-34MM²"},{"$f":"VLOOKUP(B29,TAB.REF!$A$3:$D$140,3)","v":"PC"},10,{"$f":"VLOOKUP(B29,TAB.REF!$A$3:$D$140,4)","v":2.71},27.1,3.57,35.700000000000003]
[21,227785,{"$f":"VLOOKUP(B30,TAB.REF!$A$3:$D$140,2)","v":"CONETOR FORMATO H ITEM 3 CAA 42-67MM² / 42-67MM²"},{"$f":"VLOOKUP(B30,TAB.REF!$A$3:$D$140,3)","v":"PC"},16,{"$f":"VLOOKUP(B30,TAB.REF!$A$3:$D$140,4)","v":4.7699999999999996},76.319999999999993,6.28,100.48]
[22,231175,{"$f":"VLOOKUP(B31,TAB.REF!$A$3:$D$140,2)","v":"CONETOR PARA ATERRAMENTO DE FERRAGENS DE IP"},{"$f":"VLOOKUP(B31,TAB.REF!$A$3:$D$140,3)","v":"PC"},8,{"$f":"VLOOKUP(B31,TAB.REF!$A$3:$D$140,4)","v":1.3},10.4,1.71,13.68]
[23,227389,{"$f":"VLOOKUP(B32,TAB.REF!$A$3:$D$140,2)","v":"CONETOR TERMINAL COMPRESSÃO 1F AÇO 6,4MM / 21MM²"},{"$f":"VLOOKUP(B32,TAB.REF!$A$3:$D$140,3)","v":"PC"},1,{"$f":"VLOOKUP(B32,TAB.REF!$A$3:$D$140,4)","v":2.0699999999999998},2.0699999999999998,2.72,2.72]
[24,222539,{"$f":"VLOOKUP(B33,TAB.REF!$A$3:$D$140,2)","v":"HASTE ATERRAMENTO 2400MM"},{"$f":"VLOOKUP(B33,TAB.REF!$A$3:$D$140,3)","v":"PC"},1,{"$f":"VLOOKUP(B33,TAB.REF!$A$3:$D$140,4)","v":40.75},40.75,53.61,53.61]
[25,376238,{"$f":"VLOOKUP(B34,TAB.REF!$A$3:$D$140,2)","v":"LÂMPADA VAPOR DE SÓDIO 100W AP E-40 TUBULAR"},{"$f":"VLOOKUP(B34,TAB.REF!$A$3:$D$140,3)","v":"PC"},2,{"$f":"VLOOKUP(B34,TAB.REF!$A$3:$D$140,4)","v":24.46},48.92,32.18,64.36]
[26,376109,{"$f":"VLOOKUP(B35,TAB.REF!$A$3:$D$140,2)","v":"LUMINÁRIA COM EQUIPAMENTO VS 100W VIDRO PLANO"},{"$f":"VLOOKUP(B35,TAB.REF!$A$3:$D$140,3)","v":"PC"},2,{"$f":"VLOOKUP(B35,TAB.REF!$A$3:$D$140,4)","v":269.72000000000003},539.44000000000005,354.84,709.68]
[27,237289,{"$f":"VLOOKUP(B36,TAB.REF!$A$3:$D$140,2)","v":"OLHAL PARA PARAFUSO 50KN"},{"$f":"VLOOKUP(B36,TAB.REF!$A$3:$D$140,3)","v":"PC"},11,{"$f":"VLOOKUP(B36,TAB.REF!$A$3:$D$140,4)","v":16.760000000000002},184.36,22.05,242.55]
[28,66878,{"$f":"VLOOKUP(B37,TAB.REF!$A$3:$D$140,2)","v":"PARAFUSO CABEÇA ABAULADA M16X 45MM"},{"$f":"VLOOKUP(B37,TAB.REF!$A$3:$D$140,3)","v":"PC"},13,{"$f":"VLOOKUP(B37,TAB.REF!$A$3:$D$140,4)","v":2.17},28.21,2.85,37.049999999999997]
[29,66886,{"$f":"VLOOKUP(B38,TAB.REF!$A$3:$D$140,2)","v":"PARAFUSO CABEÇA ABAULADA M16X 70MM"},{"$f":"VLOOKUP(B38,TAB.REF!$A$3:$D$140,3)","v":"PC"},34,{"$f":"VLOOKUP(B38,TAB.REF!$A$3:$D$140,4)","v":2.64},89.76,3.47,117.98]
[30,207415,{"$f":"VLOOKUP(B39,TAB.REF!$A$3:$D$140,2)","v":"POSTE CONCRETO CIRCULAR 11M 300DAN"},{"$f":"VLOOKUP(B39,TAB.REF!$A$3:$D$140,3)","v":"PC"},4,{"$f":"VLOOKUP(B39,TAB.REF!$A$3:$D$140,4)","v":695.96},2783.84,915.6,3662.4]
[31,376112,{"$f":"VLOOKUP(B40,TAB.REF!$A$3:$D$140,2)","v":"REATOR LÂMPADA VS 100W INTEGRADO CONECTOR RÁPIDO"},{"$f":"VLOOKUP(B40,TAB.REF!$A$3:$D$140,3)","v":"PC"},2,{"$f":"VLOOKUP(B40,TAB.REF!$A$3:$D$140,4)","v":45.5},91,59.86,119.72]
[32,327361,{"$f":"VLOOKUP(B41,TAB.REF!$A$3:$D$140,2)","v":"RELÉ FOTOELÉTRICO ELETRÔNICO 105-305V"},{"$f":"VLOOKUP(B41,TAB.REF!$A$3:$D$140,3)","v":"PC"},2,{"$f":"VLOOKUP(B41,TAB.REF!$A$3:$D$140,4)","v":19.100000000000001},38.200000000000003,25.13,50.26]
[33,237768,{"$f":"VLOOKUP(B42,TAB.REF!$A$3:$D$140,2)","v":"SAPATILHA"},{"$f":"VLOOKUP(B42,TAB.REF!$A$3:$D$140,3)","v":"PC"},5,{"$f":"VLOOKUP(B42,TAB.REF!$A$3:$D$140,4)","v":1.99},9.9499999999999993,2.62,13.1]
[" VALOR TOTAL MATERIAIS",null,null,null,null,{"$f":"ROUND(SUM(G10:G42),2)","v":7461.29},null,{"$f":"ROUND(SUM(I10:I42),2)","v":9815.82}]
["MÃO DE OBRA DE CONSTRUÇÃO",null,null,null,null,"PREÇO SEM BDI",null,"PREÇO COM BDI"]
["ITEM","CÓDIGO","DESCRIÇÃO","UN","QUANT.","R$.UNIT.","R$. TOTAL","R$.UNIT.","R$. TOTAL"]
[1,"US. CONST. RDA",{"$f":"VLOOKUP(B46,TAB.REF!$A$3:$D$140,2)","v":"MÃO DE OBRA DE CONSTRUÇÃO DE REDE ELÉTRICA"},"US",5.55,{"$f":"VLOOKUP(B46,TAB.REF!$A$2:$D$140,4)","v":1538.3},{"$f":"ROUND(E46*F46,2)","v":8537.57},{"$f":"F46*(1+$I$6)","v":2023.79},{"$f":"ROUND(H46*E46,2)","v":11232.03}]
[2,"US. CONST. RDS",{"$f":"VLOOKUP(B47,TAB.REF!$A$3:$D$140,2)","v":"MÃO DE OBRA DE CONSTRUÇÃO DE REDE SUBTERRÂNEA"},"US",null,{"$f":"VLOOKUP(B47,TAB.REF!$A$2:$D$140,4)","v":1538.3},{"$f":"ROUND(E47*F47,2)","v":0},{"$f":"F47*(1+$I$6)","v":2023.79},{"$f":"ROUND(H47*E47,2)","v":0}]
[" VALOR TOTAL MÃO DE OBRA",null,null,null,null,{"$f":"SUM(G46:G47)","v":8537.57},null,{"$f":"SUM(I46:I47)","v":11232.03}]
["RESUMO",null,null,null,null,"PREÇO SEM BDI",null,"PREÇO COM BDI"]
[" VALOR TOTAL MATERIAIS",null,null,null,null,{"$f":"ROUND(F43,2)","v":7461.29},null,{"$f":"ROUND(H43,2)","v":9815.82}]
[" VALOR TOTAL MÃO DE OBRA",null,null,null,null,{"$f":"ROUND(F48,2)","v":8537.57},null,{"$f":"H48","v":11232.03}]
[" VALOR TOTAL",null,null,null,null,{"$f":"ROUND(SUM(F50:G51),2)","v":15998.86},null,{"$f":"SUM(H50:I51)","v":21047.85}]
[]
[]
[{"$f":"CONCATENATE(RESUMO!B18,\" \",RESUMO!C18)","v":"Patos de Minas, 4 de fevereiro de 2020"}]
[]
[]
["_______________________________________________________"]
[{"$f":"RESUMO!B21","v":"Diogo Soares Resende"}]
[{"$f":"RESUMO!B22","v":"Eng. Eletricista"}]
[{"$f":"RESUMO!B23","v":"CREA: 194.419D/MG"}]

{"sheet":"CVCTEC-79","index":5,"n_rows":70,"n_cols":9,"rows_kept":70,"cut":false,"hidden":false,"merged":[[67,0,67,8],[68,0,68,8],[69,0,69,8],[60,0,60,4],[60,5,60,6],[60,7,60,8],[63,0,63,8],[65,0,65,6],[66,0,66,8],[58,0,58,4],[58,5,58,6],[58,7,58,8],[59,0,59,4],[59,5,59,6],[59,7,59,8],[56,0,56,4],[56,5,56,6],[56,7,56,8],[57,0,57,4],[57,5,57,6],[57,7,57,8],[51,0,51,4],[51,5,51,6],[51,7,51,8],[52,0,52,4],[52,5,52,6],[52,7,52,8],[6,0,6,8],[7,0,8,0],[7,1,8,1],[7,2,8,2],[7,3,8,3],[7,4,8,4],[7,5,7,6],[7,7,7,8],[1,0,1,8],[2,0,2,8],[3,0,3,8],[4,0,4,4],[5,0,5,4]]}
[]
["PLANILHA ORÇAMENTÁRIA "]
["OBJETO: PROJETOS DE MODIFICAÇÃO, EXTENSÃO DE REDE  E ILUMINAÇÃO PÚBLICA"]
["LOCAL: CVCTEC_PMINAS_79 - AV. A - B. JARDIM PANORAMICO"]
["RESPONSÁVEL TÉCNICO: DIOGO SOARES RESENDE",null,null,null,null,"CREA:",{"$f":"LEFT(RIGHT(RESUMO!B23,11),8)","v":"194.419D"},"ART:"]
["REFERENCIA DE PREÇOS: PREÇOS DE MERCADO",null,null,null,null,"DATA: ",{"$f":"RESUMO!E5","v":"2020-02-04"},"BDI :",{"$f":"RESUMO!F5","v":0.31559999999999999}]
[]
["ITEM","CÓDIGO ","DESCRIÇÃO","UNID.","QUANT.","PREÇO SEM BDI",null,"PREÇO COM BDI"]
[null,null,null,null,null,"UNITÁRIO ","TOTAL","UNITÁRIO ","TOTAL"]
[1,228981,{"$f":"VLOOKUP(B10,TAB.REF!$A$3:$D$140,2)","v":"ALÇA PREFORMADA NEUTRO CA/CAL 16MM²"},{"$f":"VLOOKUP(B10,TAB.REF!$A$3:$D$140,3)","v":"PC"},16,{"$f":"VLOOKUP(B10,TAB.REF!$A$3:$D$140,4)","v":1.3},{"$f":"ROUND(F10*E10,2)","v":20.8},{"$f":"ROUND(F10*(1+$I$6),2)","v":1.71},{"$f":"ROUND(H10*E10,2)","v":27.36}]
[2,229005,{"$f":"VLOOKUP(B11,TAB.REF!$A$3:$D$140,2)","v":"ALÇA PREFORMADA NEUTRO CA/CAL 70MM²"},{"$f":"VLOOKUP(B11,TAB.REF!$A$3:$D$140,3)","v":"PC"},4,{"$f":"VLOOKUP(B11,TAB.REF!$A$3:$D$140,4)","v":6.03},24.12,7.93,31.72]
[3,327692,{"$f":"VLOOKUP(B12,TAB.REF!$A$3:$D$140,2)","v":"BRAÇADEIRA PLÁSTICA CABO MULTIPLEXADO"},{"$f":"VLOOKUP(B12,TAB.REF!$A$3:$D$140,3)","v":"PC"},20,{"$f":"VLOOKUP(B12,TAB.REF!$A$3:$D$140,4)","v":1.1499999999999999},23,1.51,30.2]
[4,258921,{"$f":"VLOOKUP(B13,TAB.REF!$A$3:$D$140,2)","v":"BRAÇO PARA IP TIPO MÉDIO"},{"$f":"VLOOKUP(B13,TAB.REF!$A$3:$D$140,3)","v":"PC"},6,{"$f":"VLOOKUP(B13,TAB.REF!$A$3:$D$140,4)","v":166.63},999.78,219.22,1315.32]
[5,231712,{"$f":"VLOOKUP(B14,TAB.REF!$A$3:$D$140,2)","v":"BRAÇO SUPORTE COM GRAMPO DE SUSPENSÃO ITEM 2"},{"$f":"VLOOKUP(B14,TAB.REF!$A$3:$D$140,3)","v":"CJ"},4,{"$f":"VLOOKUP(B14,TAB.REF!$A$3:$D$140,4)","v":38.380000000000003},153.52000000000001,50.49,201.96]
[6,225615,{"$f":"VLOOKUP(B15,TAB.REF!$A$3:$D$140,2)","v":"CABO CU 1X 1,5MM² 1KV XLPE"},{"$f":"VLOOKUP(B15,TAB.REF!$A$3:$D$140,3)","v":"M"},52.5,{"$f":"VLOOKUP(B15,TAB.REF!$A$3:$D$140,4)","v":1.1499999999999999},60.38,1.51,79.28]
[7,2931,{"$f":"VLOOKUP(B16,TAB.REF!$A$3:$D$140,2)","v":"CABO DE AÇO MR 1/4P (6,4MM) 7 FIOS"},{"$f":"VLOOKUP(B16,TAB.REF!$A$3:$D$140,3)","v":"KG"},11.3,{"$f":"VLOOKUP(B16,TAB.REF!$A$3:$D$140,4)","v":2.76},31.19,3.63,41.02]
[8,226373,{"$f":"VLOOKUP(B17,TAB.REF!$A$3:$D$140,2)","v":"CABO QUADRUPLEX CA 3X1X 70+70 1KV"},{"$f":"VLOOKUP(B17,TAB.REF!$A$3:$D$140,3)","v":"M"},210,{"$f":"VLOOKUP(B17,TAB.REF!$A$3:$D$140,4)","v":22.81},4790.1000000000004,30.01,6302.1]
[9,231860,{"$f":"VLOOKUP(B18,TAB.REF!$A$3:$D$140,2)","v":"CARTUCHO DE APLICAÇÃO AZUL"},{"$f":"VLOOKUP(B18,TAB.REF!$A$3:$D$140,3)","v":"PC"},6,{"$f":"VLOOKUP(B18,TAB.REF!$A$3:$D$140,4)","v":6.53},39.18,8.59,51.54]
[10,231878,{"$f":"VLOOKUP(B19,TAB.REF!$A$3:$D$140,2)","v":"CARTUCHO DE APLICAÇÃO VERMELHO"},{"$f":"VLOOKUP(B19,TAB.REF!$A$3:$D$140,3)","v":"PC"},3,{"$f":"VLOOKUP(B19,TAB.REF!$A$3:$D$140,4)","v":6.54},19.62,8.6,25.8]
[11,236851,{"$f":"VLOOKUP(B20,TAB.REF!$A$3:$D$140,2)","v":"CINTA DE AÇO D 190MM"},{"$f":"VLOOKUP(B20,TAB.REF!$A$3:$D$140,3)","v":"PC"},2,{"$f":"VLOOKUP(B20,TAB.REF!$A$3:$D$140,4)","v":17.48},34.96,23,46]
[12,236877,{"$f":"VLOOKUP(B21,TAB.REF!$A$3:$D$140,2)","v":"CINTA DE AÇO D 210MM"},{"$f":"VLOOKUP(B21,TAB.REF!$A$3:$D$140,3)","v":"PC"},14,{"$f":"VLOOKUP(B21,TAB.REF!$A$3:$D$140,4)","v":18.52},259.27999999999997,24.36,341.04]
[13,236893,{"$f":"VLOOKUP(B22,TAB.REF!$A$3:$D$140,2)","v":"CINTA DE AÇO D 230MM"},{"$f":"VLOOKUP(B22,TAB.REF!$A$3:$D$140,3)","v":"PC"},16,{"$f":"VLOOKUP(B22,TAB.REF!$A$3:$D$140,4)","v":19.34},309.44,25.44,407.04]
[14,236919,{"$f":"VLOOKUP(B23,TAB.REF!$A$3:$D$140,2)","v":"CINTA DE AÇO D 250MM"},{"$f":"VLOOKUP(B23,TAB.REF!$A$3:$D$140,3)","v":"PC"},1,{"$f":"VLOOKUP(B23,TAB.REF!$A$3:$D$140,4)","v":21.79},21.79,28.67,28.67]
[15,231753,{"$f":"VLOOKUP(B24,TAB.REF!$A$3:$D$140,2)","v":"CONETOR CUNHA AL 150-50MM²"},{"$f":"VLOOKUP(B24,TAB.REF!$A$3:$D$140,3)","v":"PC"},3,{"$f":"VLOOKUP(B24,TAB.REF!$A$3:$D$140,4)","v":14.41},43.23,18.96,56.88]
[16,231811,{"$f":"VLOOKUP(B25,TAB.REF!$A$3:$D$140,2)","v":"CONETOR CUNHA AL 150MM² COM ESTRIBO"},{"$f":"VLOOKUP(B25,TAB.REF!$A$3:$D$140,3)","v":"PC"},3,{"$f":"VLOOKUP(B25,TAB.REF!$A$3:$D$140,4)","v":31.85},95.55,41.9,125.7]
[17,231795,{"$f":"VLOOKUP(B26,TAB.REF!$A$3:$D$140,2)","v":"CONETOR CUNHA AL 50MM² COM ESTRIBO"},{"$f":"VLOOKUP(B26,TAB.REF!$A$3:$D$140,3)","v":"PC"},3,{"$f":"VLOOKUP(B26,TAB.REF!$A$3:$D$140,4)","v":14.96},44.88,19.68,59.04]
[18,227850,{"$f":"VLOOKUP(B27,TAB.REF!$A$3:$D$140,2)","v":"CONETOR CUNHA CU ITEM 1"},{"$f":"VLOOKUP(B27,TAB.REF!$A$3:$D$140,3)","v":"PC"},16,{"$f":"VLOOKUP(B27,TAB.REF!$A$3:$D$140,4)","v":3.79},60.64,4.99,79.84]
[19,227868,{"$f":"VLOOKUP(B28,TAB.REF!$A$3:$D$140,2)","v":"CONETOR CUNHA CU ITEM 2"},{"$f":"VLOOKUP(B28,TAB.REF!$A$3:$D$140,3)","v":"PC"},8,{"$f":"VLOOKUP(B28,TAB.REF!$A$3:$D$140,4)","v":2.81},22.48,3.7,29.6]
[20,231696,{"$f":"VLOOKUP(B29,TAB.REF!$A$3:$D$140,2)","v":"CONETOR CUNHA CU ITEM 6"},{"$f":"VLOOKUP(B29,TAB.REF!$A$3:$D$140,3)","v":"PC"},3,{"$f":"VLOOKUP(B29,TAB.REF!$A$3:$D$140,4)","v":4.2699999999999996},12.81,5.62,16.86]
[21,231688,{"$f":"VLOOKUP(B30,TAB.REF!$A$3:$D$140,2)","v":"CONETOR CUNHA CU ITEM 7"},{"$f":"VLOOKUP(B30,TAB.REF!$A$3:$D$140,3)","v":"PC"},6,{"$f":"VLOOKUP(B30,TAB.REF!$A$3:$D$140,4)","v":3.9},23.4,5.13,30.78]
[22,331728,{"$f":"VLOOKUP(B31,TAB.REF!$A$3:$D$140,2)","v":"CONETOR CUNHA ITEM 2 + COBERTURA ISOLANTE ITEM 2"},{"$f":"VLOOKUP(B31,TAB.REF!$A$3:$D$140,3)","v":"PC"},13,{"$f":"VLOOKUP(B31,TAB.REF!$A$3:$D$140,4)","v":3.63},47.19,4.78,62.14]
[23,327726,{"$f":"VLOOKUP(B32,TAB.REF!$A$3:$D$140,2)","v":"CONETOR DE PERFURAÇÃO 10-70MM²/6-35MM²"},{"$f":"VLOOKUP(B32,TAB.REF!$A$3:$D$140,3)","v":"PC"},20,{"$f":"VLOOKUP(B32,TAB.REF!$A$3:$D$140,4)","v":8.25},165,10.85,217]
[24,379679,{"$f":"VLOOKUP(B33,TAB.REF!$A$3:$D$140,2)","v":"CONETOR DE PERFURAÇÃO 35-120MM²/1,5MM²"},{"$f":"VLOOKUP(B33,TAB.REF!$A$3:$D$140,3)","v":"PC"},14,{"$f":"VLOOKUP(B33,TAB.REF!$A$3:$D$140,4)","v":5.98},83.72,7.87,110.18]
[25,327767,{"$f":"VLOOKUP(B34,TAB.REF!$A$3:$D$140,2)","v":"CONETOR DE PERFURAÇÃO 70-240MM²/70-120MM²"},{"$f":"VLOOKUP(B34,TAB.REF!$A$3:$D$140,3)","v":"PC"},6,{"$f":"VLOOKUP(B34,TAB.REF!$A$3:$D$140,4)","v":16},96,21.05,126.3]
[26,227769,{"$f":"VLOOKUP(B35,TAB.REF!$A$3:$D$140,2)","v":"CONETOR FORMATO H ITEM 1 CAA 13-34MM² / 13-34MM²"},{"$f":"VLOOKUP(B35,TAB.REF!$A$3:$D$140,3)","v":"PC"},1,{"$f":"VLOOKUP(B35,TAB.REF!$A$3:$D$140,4)","v":2.25},2.25,2.96,2.96]
[27,227785,{"$f":"VLOOKUP(B36,TAB.REF!$A$3:$D$140,2)","v":"CONETOR FORMATO H ITEM 3 CAA 42-67MM² / 42-67MM²"},{"$f":"VLOOKUP(B36,TAB.REF!$A$3:$D$140,3)","v":"PC"},3,{"$f":"VLOOKUP(B36,TAB.REF!$A$3:$D$140,4)","v":4.7699999999999996},14.31,6.28,18.84]
[28,231175,{"$f":"VLOOKUP(B37,TAB.REF!$A$3:$D$140,2)","v":"CONETOR PARA ATERRAMENTO DE FERRAGENS DE IP"},{"$f":"VLOOKUP(B37,TAB.REF!$A$3:$D$140,3)","v":"PC"},14,{"$f":"VLOOKUP(B37,TAB.REF!$A$3:$D$140,4)","v":1.3},{"$f":"ROUND(F37*E37,2)","v":18.2},{"$f":"ROUND(F37*(1+$I$6),2)","v":1.71},{"$f":"ROUND(H37*E37,2)","v":23.94}]
[29,227389,{"$f":"VLOOKUP(B38,TAB.REF!$A$3:$D$140,2)","v":"CONETOR TERMINAL COMPRESSÃO 1F AÇO 6,4MM / 21MM²"},{"$f":"VLOOKUP(B38,TAB.REF!$A$3:$D$140,3)","v":"PC"},5,{"$f":"VLOOKUP(B38,TAB.REF!$A$3:$D$140,4)","v":2.0699999999999998},10.35,2.72,13.6]
[30,222539,{"$f":"VLOOKUP(B39,TAB.REF!$A$3:$D$140,2)","v":"HASTE ATERRAMENTO 2400MM"},{"$f":"VLOOKUP(B39,TAB.REF!$A$3:$D$140,3)","v":"PC"},5,{"$f":"VLOOKUP(B39,TAB.REF!$A$3:$D$140,4)","v":40.75},203.75,53.61,268.05]
[31,354899,{"$f":"VLOOKUP(B40,TAB.REF!$A$3:$D$140,2)","v":"LÂMPADA VAPOR DE SÓDIO 150W AP E-40 TUBULAR"},{"$f":"VLOOKUP(B40,TAB.REF!$A$3:$D$140,3)","v":"PC"},6,{"$f":"VLOOKUP(B40,TAB.REF!$A$3:$D$140,4)","v":30.81},184.86,40.53,243.18]
[32,354900,{"$f":"VLOOKUP(B41,TAB.REF!$A$3:$D$140,2)","v":"LUMINÁRIA COM EQUIPAMENTO VS 150W TUBULAR"},{"$f":"VLOOKUP(B41,TAB.REF!$A$3:$D$140,3)","v":"PC"},6,{"$f":"VLOOKUP(B41,TAB.REF!$A$3:$D$140,4)","v":359.87},2159.2199999999998,473.44,2840.64]
[33,374393,{"$f":"VLOOKUP(B42,TAB.REF!$A$3:$D$140,2)","v":"MANTA AUTO-ADESIVA PARA EMENDA CABO 15KV RDP"},{"$f":"VLOOKUP(B42,TAB.REF!$A$3:$D$140,3)","v":"PC"},5,{"$f":"VLOOKUP(B42,TAB.REF!$A$3:$D$140,4)","v":66.28},331.4,87.2,436]
[34,237289,{"$f":"VLOOKUP(B43,TAB.REF!$A$3:$D$140,2)","v":"OLHAL PARA PARAFUSO 50KN"},{"$f":"VLOOKUP(B43,TAB.REF!$A$3:$D$140,3)","v":"PC"},12,{"$f":"VLOOKUP(B43,TAB.REF!$A$3:$D$140,4)","v":16.760000000000002},201.12,22.05,264.60000000000002]
[35,66878,{"$f":"VLOOKUP(B44,TAB.REF!$A$3:$D$140,2)","v":"PARAFUSO CABEÇA ABAULADA M16X 45MM"},{"$f":"VLOOKUP(B44,TAB.REF!$A$3:$D$140,3)","v":"PC"},30,{"$f":"VLOOKUP(B44,TAB.REF!$A$3:$D$140,4)","v":2.17},65.099999999999994,2.85,85.5]
[36,66886,{"$f":"VLOOKUP(B45,TAB.REF!$A$3:$D$140,2)","v":"PARAFUSO CABEÇA ABAULADA M16X 70MM"},{"$f":"VLOOKUP(B45,TAB.REF!$A$3:$D$140,3)","v":"PC"},76,{"$f":"VLOOKUP(B45,TAB.REF!$A$3:$D$140,4)","v":2.64},200.64,3.47,263.72000000000003]
[37,207415,{"$f":"VLOOKUP(B46,TAB.REF!$A$3:$D$140,2)","v":"POSTE CONCRETO CIRCULAR 11M 300DAN"},{"$f":"VLOOKUP(B46,TAB.REF!$A$3:$D$140,3)","v":"PC"},6,{"$f":"VLOOKUP(B46,TAB.REF!$A$3:$D$140,4)","v":695.96},4175.76,915.6,5493.6]
[38,207449,{"$f":"VLOOKUP(B47,TAB.REF!$A$3:$D$140,2)","v":"POSTE CONCRETO CIRCULAR 11M 600DAN"},{"$f":"VLOOKUP(B47,TAB.REF!$A$3:$D$140,3)","v":"PC"},1,{"$f":"VLOOKUP(B47,TAB.REF!$A$3:$D$140,4)","v":951.41},951.41,1251.67,1251.67]
[39,355028,{"$f":"VLOOKUP(B48,TAB.REF!$A$3:$D$140,2)","v":"REATOR LÂMPADA VS 150W INTEGRADO"},{"$f":"VLOOKUP(B48,TAB.REF!$A$3:$D$140,3)","v":"PC"},6,{"$f":"VLOOKUP(B48,TAB.REF!$A$3:$D$140,4)","v":75.36},452.16,99.14,594.84]
[40,327361,{"$f":"VLOOKUP(B49,TAB.REF!$A$3:$D$140,2)","v":"RELÉ FOTOELÉTRICO ELETRÔNICO 105-305V"},{"$f":"VLOOKUP(B49,TAB.REF!$A$3:$D$140,3)","v":"PC"},6,{"$f":"VLOOKUP(B49,TAB.REF!$A$3:$D$140,4)","v":19.100000000000001},114.6,25.13,150.78]
[41,237768,{"$f":"VLOOKUP(B50,TAB.REF!$A$3:$D$140,2)","v":"SAPATILHA"},{"$f":"VLOOKUP(B50,TAB.REF!$A$3:$D$140,3)","v":"PC"},4,{"$f":"VLOOKUP(B50,TAB.REF!$A$3:$D$140,4)","v":1.99},7.96,2.62,10.48]
[42,237081,{"$f":"VLOOKUP(B51,TAB.REF!$A$3:$D$140,2)","v":"SUPORTE 240MM TRANSFORMADOR POSTE CC"},{"$f":"VLOOKUP(B51,TAB.REF!$A$3:$D$140,3)","v":"PC"},2,{"$f":"VLOOKUP(B51,TAB.REF!$A$3:$D$140,4)","v":104.81},209.62,137.88999999999999,275.77999999999997]
[" VALOR TOTAL MATERIAIS",null,null,null,null,{"$f":"ROUND(SUM(G10:G51),2)","v":16784.77},null,{"$f":"ROUND(SUM(I10:I51),2)","v":22081.55}]
["MÃO DE OBRA DE CONSTRUÇÃO",null,null,null,null,"PREÇO SEM BDI",null,"PREÇO COM BDI"]
["ITEM","CÓDIGO","DESCRIÇÃO","UN","QUANT.","R$.UNIT.","R$. TOTAL","R$.UNIT.","R$. TOTAL"]
[1,"US. CONST. RDA",{"$f":"VLOOKUP(B55,TAB.REF!$A$2:$D$140,2)","v":"MÃO DE OBRA DE CONSTRUÇÃO DE REDE ELÉTRICA"},"US",8.25,{"$f":"VLOOKUP(B55,TAB.REF!$A$2:$D$140,4)","v":1538.3},{"$f":"ROUND(E55*F55,2)","v":12690.98},{"$f":"F55*(1+$I$6)","v":2023.79},{"$f":"ROUND(H55*E55,2)","v":16696.27}]
[2,"US. CONST. RDS",{"$f":"VLOOKUP(B56,TAB.REF!$A$2:$D$140,2)","v":"MÃO DE OBRA DE CONSTRUÇÃO DE REDE SUBTERRÂNEA"},"US",null,{"$f":"VLOOKUP(B56,TAB.REF!$A$2:$D$140,4)","v":1538.3},{"$f":"ROUND(E56*F56,2)","v":0},{"$f":"F56*(1+$I$6)","v":2023.79},{"$f":"ROUND(H56*E56,2)","v":0}]
[" VALOR TOTAL MÃO DE OBRA",null,null,null,null,{"$f":"SUM(G55:G56)","v":12690.98},null,{"$f":"SUM(I55:I56)","v":16696.27}]
["RESUMO",null,null,null,null,"PREÇO SEM BDI",null,"PREÇO COM BDI"]
[" VALOR TOTAL MATERIAIS",null,null,null,null,{"$f":"ROUND(F52,2)","v":16784.77},null,{"$f":"ROUND(H52,2)","v":22081.55}]
[" VALOR TOTAL MÃO DE OBRA",null,null,null,null,{"$f":"ROUND(F57,2)","v":12690.98},null,{"$f":"H57","v":16696.27}]
[" VALOR TOTAL",null,null,null,null,{"$f":"ROUND(SUM(F59:G60),2)","v":29475.75},null,{"$f":"SUM(H59:I60)","v":38777.82}]
[]
[]
[{"$f":"CONCATENATE(RESUMO!B18,\" \",RESUMO!C18)","v":"Patos de Minas, 4 de fevereiro de 2020"}]
[]
[]
["_______________________________________________________"]
[{"$f":"RESUMO!B21","v":"Diogo Soares Resende"}]
[{"$f":"RESUMO!B22","v":"Eng. Eletricista"}]
[{"$f":"RESUMO!B23","v":"CREA: 194.419D/MG"}]

{"sheet":"CVCTEC-80","index":6,"n_rows":137,"n_cols":9,"rows_kept":137,"cut":false,"hidden":false,"merged":[[136,0,136,8],[4,0,4,4],[1,0,1,8],[2,0,2,8],[3,0,3,8],[5,0,5,4],[6,0,6,8],[7,0,8,0],[7,1,8,1],[7,2,8,2],[7,3,8,3],[7,4,8,4],[7,5,7,6],[7,7,7,8],[118,0,118,4],[118,5,118,6],[118,7,118,8],[119,0,119,4],[119,5,119,6],[119,7,119,8],[123,0,123,4],[123,5,123,6],[123,7,123,8],[124,0,124,4],[124,5,124,6],[124,7,124,8],[125,0,125,4],[125,5,125,6],[125,7,125,8],[126,0,126,4],[126,5,126,6],[126,7,126,8],[134,0,134,8],[135,0,135,8],[127,0,127,4],[127,5,127,6],[127,7,127,8],[130,0,130,8],[132,0,132,6],[133,0,133,8]]}
[]
["PLANILHA ORÇAMENTÁRIA "]
["OBJETO: PROJETOS DE MODIFICAÇÃO, EXTENSÃO DE REDE  E ILUMINAÇÃO PÚBLICA"]
["LOCAL: CVCTEC_PMINAS_80 - RUA ARTHUR MAGALHAES - B. NOVA FLORESTA"]
["RESPONSÁVEL TÉCNICO: DIOGO SOARES RESENDE",null,null,null,null,"CREA:",{"$f":"LEFT(RIGHT(RESUMO!B23,11),8)","v":"194.419D"},"ART:"]
["REFERENCIA DE PREÇOS: PREÇOS DE MERCADO",null,null,null,null,"DATA: ",{"$f":"RESUMO!E5","v":"2020-02-04"},"BDI :",{"$f":"RESUMO!F5","v":0.31559999999999999}]
[]
["ITEM","CÓDIGO ","DESCRIÇÃO","UNID.","QUANT.","PREÇO SEM BDI",null,"PREÇO COM BDI"]
[null,null,null,null,null,"UNITÁRIO ","TOTAL","UNITÁRIO ","TOTAL"]
[1,237222,{"$f":"VLOOKUP(B10,TAB.REF!$A$3:$D$140,2)","v":"AFASTADOR ARMAÇÃO SECUNDÁRIA 500MM"},{"$f":"VLOOKUP(B10,TAB.REF!$A$3:$D$140,3)","v":"PC"},1,{"$f":"VLOOKUP(B10,TAB.REF!$A$3:$D$140,4)","v":124.8},{"$f":"ROUND(F10*E10,2)","v":124.8},{"$f":"ROUND(F10*(1+$I$6),2)","v":164.19},{"$f":"ROUND(H10*E10,2)","v":164.19}]
[2,228890,{"$f":"VLOOKUP(B11,TAB.REF!$A$3:$D$140,2)","v":"ALÇA PREFORMADA CA/CAA 54MM² (1/0AWG)"},{"$f":"VLOOKUP(B11,TAB.REF!$A$3:$D$140,3)","v":"PC"},1,{"$f":"VLOOKUP(B11,TAB.REF!$A$3:$D$140,4)","v":7.35},7.35,9.67,9.67]
[3,237685,{"$f":"VLOOKUP(B12,TAB.REF!$A$3:$D$140,2)","v":"ALÇA PREFORMADA ESTAI CABO AÇO 6,4MM"},{"$f":"VLOOKUP(B12,TAB.REF!$A$3:$D$140,3)","v":"PC"},3,{"$f":"VLOOKUP(B12,TAB.REF!$A$3:$D$140,4)","v":6.75},20.25,8.8800000000000008,26.64]
[4,237677,{"$f":"VLOOKUP(B13,TAB.REF!$A$3:$D$140,2)","v":"ALÇA PREFORMADA ESTAI CABO AÇO 9,5MM"},{"$f":"VLOOKUP(B13,TAB.REF!$A$3:$D$140,3)","v":"PC"},20,{"$f":"VLOOKUP(B13,TAB.REF!$A$3:$D$140,4)","v":12.24},244.8,16.100000000000001,322]
[5,228981,{"$f":"VLOOKUP(B14,TAB.REF!$A$3:$D$140,2)","v":"ALÇA PREFORMADA NEUTRO CA/CAL 16MM²"},{"$f":"VLOOKUP(B14,TAB.REF!$A$3:$D$140,3)","v":"PC"},34,{"$f":"VLOOKUP(B14,TAB.REF!$A$3:$D$140,4)","v":1.3},44.2,1.71,58.14]
[6,229005,{"$f":"VLOOKUP(B15,TAB.REF!$A$3:$D$140,2)","v":"ALÇA PREFORMADA NEUTRO CA/CAL 70MM²"},{"$f":"VLOOKUP(B15,TAB.REF!$A$3:$D$140,3)","v":"PC"},22,{"$f":"VLOOKUP(B15,TAB.REF!$A$3:$D$140,4)","v":6.03},132.66,7.93,174.46]
[7,219709,{"$f":"VLOOKUP(B16,TAB.REF!$A$3:$D$140,2)","v":"ALÇA PREFORMADA OLHAL CA/CAA 34MM² (2AWG)"},{"$f":"VLOOKUP(B16,TAB.REF!$A$3:$D$140,3)","v":"PC"},3,{"$f":"VLOOKUP(B16,TAB.REF!$A$3:$D$140,4)","v":12.17},36.51,16.010000000000002,48.03]
[8,327700,{"$f":"VLOOKUP(B17,TAB.REF!$A$3:$D$140,2)","v":"ANEL ELASTOMÉRICO P/ ISOLADOR PINO POLIMÉRICO 15KV"},{"$f":"VLOOKUP(B17,TAB.REF!$A$3:$D$140,3)","v":"PC"},13,{"$f":"VLOOKUP(B17,TAB.REF!$A$3:$D$140,4)","v":4.29},55.77,5.64,73.319999999999993]
[9,237230,{"$f":"VLOOKUP(B18,TAB.REF!$A$3:$D$140,2)","v":"ARMAÇÃO SECUNDÁRIO 1 ESTRIBO"},{"$f":"VLOOKUP(B18,TAB.REF!$A$3:$D$140,3)","v":"PC"},1,{"$f":"VLOOKUP(B18,TAB.REF!$A$3:$D$140,4)","v":11},11,14.47,14.47]
[10,75721,{"$f":"VLOOKUP(B19,TAB.REF!$A$3:$D$140,2)","v":"ARRUELA QUADRADA 38X18X3MM"},{"$f":"VLOOKUP(B19,TAB.REF!$A$3:$D$140,3)","v":"PC"},53,{"$f":"VLOOKUP(B19,TAB.REF!$A$3:$D$140,4)","v":0.52},27.56,0.68,36.04]
[11,327692,{"$f":"VLOOKUP(B20,TAB.REF!$A$3:$D$140,2)","v":"BRAÇADEIRA PLÁSTICA CABO MULTIPLEXADO"},{"$f":"VLOOKUP(B20,TAB.REF!$A$3:$D$140,3)","v":"PC"},47,{"$f":"VLOOKUP(B20,TAB.REF!$A$3:$D$140,4)","v":1.1499999999999999},54.05,1.51,70.97]
[12,328138,{"$f":"VLOOKUP(B21,TAB.REF!$A$3:$D$140,2)","v":"BRAÇO ANTIBALANÇO 15KV"},{"$f":"VLOOKUP(B21,TAB.REF!$A$3:$D$140,3)","v":"PC"},1,{"$f":"VLOOKUP(B21,TAB.REF!$A$3:$D$140,4)","v":25.79},25.79,33.93,33.93]
[13,258905,{"$f":"VLOOKUP(B22,TAB.REF!$A$3:$D$140,2)","v":"BRAÇO PARA IP TIPO CURTO"},{"$f":"VLOOKUP(B22,TAB.REF!$A$3:$D$140,3)","v":"PC"},9,{"$f":"VLOOKUP(B22,TAB.REF!$A$3:$D$140,4)","v":39.799999999999997},358.2,52.36,471.24]
[14,258921,{"$f":"VLOOKUP(B23,TAB.REF!$A$3:$D$140,2)","v":"BRAÇO PARA IP TIPO MÉDIO"},{"$f":"VLOOKUP(B23,TAB.REF!$A$3:$D$140,3)","v":"PC"},4,{"$f":"VLOOKUP(B23,TAB.REF!$A$3:$D$140,4)","v":166.63},666.52,219.22,876.88]
[15,211789,{"$f":"VLOOKUP(B24,TAB.REF!$A$3:$D$140,2)","v":"BRAÇO SUPORTE C"},{"$f":"VLOOKUP(B24,TAB.REF!$A$3:$D$140,3)","v":"PC"},7,{"$f":"VLOOKUP(B24,TAB.REF!$A$3:$D$140,4)","v":92.79},649.53,122.07,854.49]
[16,231712,{"$f":"VLOOKUP(B25,TAB.REF!$A$3:$D$140,2)","v":"BRAÇO SUPORTE COM GRAMPO DE SUSPENSÃO ITEM 2"},{"$f":"VLOOKUP(B25,TAB.REF!$A$3:$D$140,3)","v":"CJ"},5,{"$f":"VLOOKUP(B25,TAB.REF!$A$3:$D$140,4)","v":38.380000000000003},191.9,50.49,252.45]
[17,211771,{"$f":"VLOOKUP(B26,TAB.REF!$A$3:$D$140,2)","v":"BRAÇO SUPORTE L"},{"$f":"VLOOKUP(B26,TAB.REF!$A$3:$D$140,3)","v":"PC"},2,{"$f":"VLOOKUP(B26,TAB.REF!$A$3:$D$140,4)","v":72.27},144.54,95.08,190.16]
[18,225623,{"$f":"VLOOKUP(B27,TAB.REF!$A$3:$D$140,2)","v":"CABO AL 1X 16MM² 1KV"},{"$f":"VLOOKUP(B27,TAB.REF!$A$3:$D$140,3)","v":"M"},3,{"$f":"VLOOKUP(B27,TAB.REF!$A$3:$D$140,4)","v":1.85},5.55,2.4300000000000002,7.29]
[19,231548,{"$f":"VLOOKUP(B28,TAB.REF!$A$3:$D$140,2)","v":"CABO AL 1X 50MM² 15KV PROTEGIDO"},{"$f":"VLOOKUP(B28,TAB.REF!$A$3:$D$140,3)","v":"M"},450.5,{"$f":"VLOOKUP(B28,TAB.REF!$A$3:$D$140,4)","v":7.15},3221.08,9.41,4239.21]
[20,225656,{"$f":"VLOOKUP(B29,TAB.REF!$A$3:$D$140,2)","v":"CABO AL 1X 70MM² 1KV"},{"$f":"VLOOKUP(B29,TAB.REF!$A$3:$D$140,3)","v":"M"},6,{"$f":"VLOOKUP(B29,TAB.REF!$A$3:$D$140,4)","v":6.53},39.18,8.59,51.54]
[21,220434,{"$f":"VLOOKUP(B30,TAB.REF!$A$3:$D$140,2)","v":"CABO CA 53MM² (1/0AWG)"},{"$f":"VLOOKUP(B30,TAB.REF!$A$3:$D$140,3)","v":"KG"},4.93,{"$f":"VLOOKUP(B30,TAB.REF!$A$3:$D$140,4)","v":21.15},104.27,27.82,137.15]
[22,225615,{"$f":"VLOOKUP(B31,TAB.REF!$A$3:$D$140,2)","v":"CABO CU 1X 1,5MM² 1KV XLPE"},{"$f":"VLOOKUP(B31,TAB.REF!$A$3:$D$140,3)","v":"M"},112,{"$f":"VLOOKUP(B31,TAB.REF!$A$3:$D$140,4)","v":1.1499999999999999},128.80000000000001,1.51,169.12]
[23,2964,{"$f":"VLOOKUP(B32,TAB.REF!$A$3:$D$140,2)","v":"CABO DE AÇO HS 3/8P (9,5MM²) 7FIOS"},{"$f":"VLOOKUP(B32,TAB.REF!$A$3:$D$140,3)","v":"KG"},63.74,{"$f":"VLOOKUP(B32,TAB.REF!$A$3:$D$140,4)","v":7.78},495.9,10.24,652.70000000000005]
[24,2931,{"$f":"VLOOKUP(B33,TAB.REF!$A$3:$D$140,2)","v":"CABO DE AÇO MR 1/4P (6,4MM) 7 FIOS"},{"$f":"VLOOKUP(B33,TAB.REF!$A$3:$D$140,3)","v":"KG"},32.6,{"$f":"VLOOKUP(B33,TAB.REF!$A$3:$D$140,4)","v":2.76},89.98,3.63,118.34]
[25,226373,{"$f":"VLOOKUP(B34,TAB.REF!$A$3:$D$140,2)","v":"CABO QUADRUPLEX CA 3X1X 70+70 1KV"},{"$f":"VLOOKUP(B34,TAB.REF!$A$3:$D$140,3)","v":"M"},277,{"$f":"VLOOKUP(B34,TAB.REF!$A$3:$D$140,4)","v":22.81},6318.37,30.01,8312.77]
[26,231589,{"$f":"VLOOKUP(B35,TAB.REF!$A$3:$D$140,2)","v":"CABO TRIPLEX CA 2X1X70+70 1KV"},{"$f":"VLOOKUP(B35,TAB.REF!$A$3:$D$140,3)","v":"M"},83,{"$f":"VLOOKUP(B35,TAB.REF!$A$3:$D$140,4)","v":16.079999999999998},1334.64,21.15,1755.45]
[27,223818,{"$f":"VLOOKUP(B36,TAB.REF!$A$3:$D$140,2)","v":"CANTONEIRA PARA BRAÇO C"},{"$f":"VLOOKUP(B36,TAB.REF!$A$3:$D$140,3)","v":"PC"},3,{"$f":"VLOOKUP(B36,TAB.REF!$A$3:$D$140,4)","v":60.9},182.7,80.12,240.36]
[28,231860,{"$f":"VLOOKUP(B37,TAB.REF!$A$3:$D$140,2)","v":"CARTUCHO DE APLICAÇÃO AZUL"},{"$f":"VLOOKUP(B37,TAB.REF!$A$3:$D$140,3)","v":"PC"},12,{"$f":"VLOOKUP(B37,TAB.REF!$A$3:$D$140,4)","v":6.53},78.36,8.59,103.08]
[29,231878,{"$f":"VLOOKUP(B38,TAB.REF!$A$3:$D$140,2)","v":"CARTUCHO DE APLICAÇÃO VERMELHO"},{"$f":"VLOOKUP(B38,TAB.REF!$A$3:$D$140,3)","v":"PC"},12,{"$f":"VLOOKUP(B38,TAB.REF!$A$3:$D$140,4)","v":6.54},78.48,8.6,103.2]
[30,270439,{"$f":"VLOOKUP(B39,TAB.REF!$A$3:$D$140,2)","v":"CHAVE FUSÍVEL 15KV COM PORTA FUSÍVEL 100A 7,1KA"},{"$f":"VLOOKUP(B39,TAB.REF!$A$3:$D$140,3)","v":"PC"},9,{"$f":"VLOOKUP(B39,TAB.REF!$A$3:$D$140,4)","v":243.45},2191.0500000000002,320.27999999999997,2882.52]
[31,236836,{"$f":"VLOOKUP(B40,TAB.REF!$A$3:$D$140,2)","v":"CINTA DE AÇO D 170MM"},{"$f":"VLOOKUP(B40,TAB.REF!$A$3:$D$140,3)","v":"PC"},7,{"$f":"VLOOKUP(B40,TAB.REF!$A$3:$D$140,4)","v":16.28},113.96,21.42,149.94]
[32,236844,{"$f":"VLOOKUP(B41,TAB.REF!$A$3:$D$140,2)","v":"CINTA DE AÇO D 180MM"},{"$f":"VLOOKUP(B41,TAB.REF!$A$3:$D$140,3)","v":"PC"},5,{"$f":"VLOOKUP(B41,TAB.REF!$A$3:$D$140,4)","v":16.510000000000002},{"$f":"ROUND(F41*E41,2)","v":82.55},{"$f":"ROUND(F41*(1+$I$6),2)","v":21.72},{"$f":"ROUND(H41*E41,2)","v":108.6}]
[33,236851,{"$f":"VLOOKUP(B42,TAB.REF!$A$3:$D$140,2)","v":"CINTA DE AÇO D 190MM"},{"$f":"VLOOKUP(B42,TAB.REF!$A$3:$D$140,3)","v":"PC"},5,{"$f":"VLOOKUP(B42,TAB.REF!$A$3:$D$140,4)","v":17.48},87.4,23,115]
[34,236869,{"$f":"VLOOKUP(B43,TAB.REF!$A$3:$D$140,2)","v":"CINTA DE AÇO D 200MM"},{"$f":"VLOOKUP(B43,TAB.REF!$A$3:$D$140,3)","v":"PC"},5,{"$f":"VLOOKUP(B43,TAB.REF!$A$3:$D$140,4)","v":17.93},89.65,23.59,117.95]
[35,236877,{"$f":"VLOOKUP(B44,TAB.REF!$A$3:$D$140,2)","v":"CINTA DE AÇO D 210MM"},{"$f":"VLOOKUP(B44,TAB.REF!$A$3:$D$140,3)","v":"PC"},24,{"$f":"VLOOKUP(B44,TAB.REF!$A$3:$D$140,4)","v":18.52},444.48,24.36,584.64]
[36,236885,{"$f":"VLOOKUP(B45,TAB.REF!$A$3:$D$140,2)","v":"CINTA DE AÇO D 220MM"},{"$f":"VLOOKUP(B45,TAB.REF!$A$3:$D$140,3)","v":"PC"},5,{"$f":"VLOOKUP(B45,TAB.REF!$A$3:$D$140,4)","v":18.66},93.3,24.55,122.75]
[37,236893,{"$f":"VLOOKUP(B46,TAB.REF!$A$3:$D$140,2)","v":"CINTA DE AÇO D 230MM"},{"$f":"VLOOKUP(B46,TAB.REF!$A$3:$D$140,3)","v":"PC"},20,{"$f":"VLOOKUP(B46,TAB.REF!$A$3:$D$140,4)","v":19.34},386.8,25.44,508.8]
[38,236901,{"$f":"VLOOKUP(B47,TAB.REF!$A$3:$D$140,2)","v":"CINTA DE AÇO D 240MM"},{"$f":"VLOOKUP(B47,TAB.REF!$A$3:$D$140,3)","v":"PC"},3,{"$f":"VLOOKUP(B47,TAB.REF!$A$3:$D$140,4)","v":20.51},61.53,26.98,80.94]
[39,236919,{"$f":"VLOOKUP(B48,TAB.REF!$A$3:$D$140,2)","v":"CINTA DE AÇO D 250MM"},{"$f":"VLOOKUP(B48,TAB.REF!$A$3:$D$140,3)","v":"PC"},10,{"$f":"VLOOKUP(B48,TAB.REF!$A$3:$D$140,4)","v":21.79},217.9,28.67,286.7]
[40,236927,{"$f":"VLOOKUP(B49,TAB.REF!$A$3:$D$140,2)","v":"CINTA DE AÇO D 260MM"},{"$f":"VLOOKUP(B49,TAB.REF!$A$3:$D$140,3)","v":"PC"},2,{"$f":"VLOOKUP(B49,TAB.REF!$A$3:$D$140,4)","v":21.62},43.24,28.44,56.88]
[41,236935,{"$f":"VLOOKUP(B50,TAB.REF!$A$3:$D$140,2)","v":"CINTA DE AÇO D 270MM"},{"$f":"VLOOKUP(B50,TAB.REF!$A$3:$D$140,3)","v":"PC"},4,{"$f":"VLOOKUP(B50,TAB.REF!$A$3:$D$140,4)","v":22.15},88.6,29.14,116.56]
[42,236943,{"$f":"VLOOKUP(B51,TAB.REF!$A$3:$D$140,2)","v":"CINTA DE AÇO D 280MM"},{"$f":"VLOOKUP(B51,TAB.REF!$A$3:$D$140,3)","v":"PC"},1,{"$f":"VLOOKUP(B51,TAB.REF!$A$3:$D$140,4)","v":25.47},25.47,33.51,33.51]
[43,236950,{"$f":"VLOOKUP(B52,TAB.REF!$A$3:$D$140,2)","v":"CINTA DE AÇO D 290MM"},{"$f":"VLOOKUP(B52,TAB.REF!$A$3:$D$140,3)","v":"PC"},1,{"$f":"VLOOKUP(B52,TAB.REF!$A$3:$D$140,4)","v":23.93},23.93,31.48,31.48]
[44,375058,{"$f":"VLOOKUP(B53,TAB.REF!$A$3:$D$140,2)","v":"COBERTURA PROTETORA P/ BCH BT TRANSFORMADOR ITEM 1"},{"$f":"VLOOKUP(B53,TAB.REF!$A$3:$D$140,3)","v":"PC"},7,{"$f":"VLOOKUP(B53,TAB.REF!$A$3:$D$140,4)","v":8.41},58.87,11.06,77.42]
[45,39586,{"$f":"VLOOKUP(B54,TAB.REF!$A$3:$D$140,2)","v":"COBERTURA PROTETORA PARA BUCHA DE EQUIPAMENTO"},{"$f":"VLOOKUP(B54,TAB.REF!$A$3:$D$140,3)","v":"PC"},3,{"$f":"VLOOKUP(B54,TAB.REF!$A$3:$D$140,4)","v":9.67},29.01,12.72,38.159999999999997]
[46,378809,{"$f":"VLOOKUP(B55,TAB.REF!$A$3:$D$140,2)","v":"CONECTOR TERMINAL P/ BUCHA,50 MM²,RETO,COMPRESSÃO"},{"$f":"VLOOKUP(B55,TAB.REF!$A$3:$D$140,3)","v":"PC"},3,{"$f":"VLOOKUP(B55,TAB.REF!$A$3:$D$140,4)","v":12.06},36.18,15.87,47.61]
[47,231811,{"$f":"VLOOKUP(B56,TAB.REF!$A$3:$D$140,2)","v":"CONETOR CUNHA AL 150MM² COM ESTRIBO"},{"$f":"VLOOKUP(B56,TAB.REF!$A$3:$D$140,3)","v":"PC"},3,{"$f":"VLOOKUP(B56,TAB.REF!$A$3:$D$140,4)","v":31.85},95.55,41.9,125.7]
[48,231795,{"$f":"VLOOKUP(B57,TAB.REF!$A$3:$D$140,2)","v":"CONETOR CUNHA AL 50MM² COM ESTRIBO"},{"$f":"VLOOKUP(B57,TAB.REF!$A$3:$D$140,3)","v":"PC"},12,{"$f":"VLOOKUP(B57,TAB.REF!$A$3:$D$140,4)","v":14.96},179.52,19.68,236.16]
[49,227850,{"$f":"VLOOKUP(B58,TAB.REF!$A$3:$D$140,2)","v":"CONETOR CUNHA CU ITEM 1"},{"$f":"VLOOKUP(B58,TAB.REF!$A$3:$D$140,3)","v":"PC"},40,{"$f":"VLOOKUP(B58,TAB.REF!$A$3:$D$140,4)","v":3.79},151.6,4.99,199.6]
[50,227868,{"$f":"VLOOKUP(B59,TAB.REF!$A$3:$D$140,2)","v":"CONETOR CUNHA CU ITEM 2"},{"$f":"VLOOKUP(B59,TAB.REF!$A$3:$D$140,3)","v":"PC"},20,{"$f":"VLOOKUP(B59,TAB.REF!$A$3:$D$140,4)","v":2.81},56.2,3.7,74]
[51,231696,{"$f":"VLOOKUP(B60,TAB.REF!$A$3:$D$140,2)","v":"CONETOR CUNHA CU ITEM 6"},{"$f":"VLOOKUP(B60,TAB.REF!$A$3:$D$140,3)","v":"PC"},7,{"$f":"VLOOKUP(B60,TAB.REF!$A$3:$D$140,4)","v":4.2699999999999996},29.89,5.62,39.340000000000003]
[52,231688,{"$f":"VLOOKUP(B61,TAB.REF!$A$3:$D$140,2)","v":"CONETOR CUNHA CU ITEM 7"},{"$f":"VLOOKUP(B61,TAB.REF!$A$3:$D$140,3)","v":"PC"},18,{"$f":"VLOOKUP(B61,TAB.REF!$A$3:$D$140,4)","v":3.9},70.2,5.13,92.34]
[53,331728,{"$f":"VLOOKUP(B62,TAB.REF!$A$3:$D$140,2)","v":"CONETOR CUNHA ITEM 2 + COBERTURA ISOLANTE ITEM 2"},{"$f":"VLOOKUP(B62,TAB.REF!$A$3:$D$140,3)","v":"PC"},31,{"$f":"VLOOKUP(B62,TAB.REF!$A$3:$D$140,4)","v":3.63},112.53,4.78,148.18]
[54,327726,{"$f":"VLOOKUP(B63,TAB.REF!$A$3:$D$140,2)","v":"CONETOR DE PERFURAÇÃO 10-70MM²/6-35MM²"},{"$f":"VLOOKUP(B63,TAB.REF!$A$3:$D$140,3)","v":"PC"},42,{"$f":"VLOOKUP(B63,TAB.REF!$A$3:$D$140,4)","v":8.25},346.5,10.85,455.7]
[55,379679,{"$f":"VLOOKUP(B64,TAB.REF!$A$3:$D$140,2)","v":"CONETOR DE PERFURAÇÃO 35-120MM²/1,5MM²"},{"$f":"VLOOKUP(B64,TAB.REF!$A$3:$D$140,3)","v":"PC"},28,{"$f":"VLOOKUP(B64,TAB.REF!$A$3:$D$140,4)","v":5.98},167.44,7.87,220.36]
[56,327767,{"$f":"VLOOKUP(B65,TAB.REF!$A$3:$D$140,2)","v":"CONETOR DE PERFURAÇÃO 70-240MM²/70-120MM²"},{"$f":"VLOOKUP(B65,TAB.REF!$A$3:$D$140,3)","v":"PC"},18,{"$f":"VLOOKUP(B65,TAB.REF!$A$3:$D$140,4)","v":16},{"$f":"ROUND(F65*E65,2)","v":288},{"$f":"ROUND(F65*(1+$I$6),2)","v":21.05},{"$f":"ROUND(H65*E65,2)","v":378.9}]
[57,227769,{"$f":"VLOOKUP(B66,TAB.REF!$A$3:$D$140,2)","v":"CONETOR FORMATO H ITEM 1 CAA 13-34MM² / 13-34MM²"},{"$f":"VLOOKUP(B66,TAB.REF!$A$3:$D$140,3)","v":"PC"},5,{"$f":"VLOOKUP(B66,TAB.REF!$A$3:$D$140,4)","v":2.25},11.25,2.96,14.8]
[58,227777,{"$f":"VLOOKUP(B67,TAB.REF!$A$3:$D$140,2)","v":"CONETOR FORMATO H ITEM 2 CAA 27-54MM² / 13-34MM²"},{"$f":"VLOOKUP(B67,TAB.REF!$A$3:$D$140,3)","v":"PC"},25,{"$f":"VLOOKUP(B67,TAB.REF!$A$3:$D$140,4)","v":2.71},67.75,3.57,89.25]
[59,227785,{"$f":"VLOOKUP(B68,TAB.REF!$A$3:$D$140,2)","v":"CONETOR FORMATO H ITEM 3 CAA 42-67MM² / 42-67MM²"},{"$f":"VLOOKUP(B68,TAB.REF!$A$3:$D$140,3)","v":"PC"},70,{"$f":"VLOOKUP(B68,TAB.REF!$A$3:$D$140,4)","v":4.7699999999999996},333.9,6.28,439.6]
[60,231175,{"$f":"VLOOKUP(B69,TAB.REF!$A$3:$D$140,2)","v":"CONETOR PARA ATERRAMENTO DE FERRAGENS DE IP"},{"$f":"VLOOKUP(B69,TAB.REF!$A$3:$D$140,3)","v":"PC"},28,{"$f":"VLOOKUP(B69,TAB.REF!$A$3:$D$140,4)","v":1.3},36.4,1.71,47.88]
[61,377357,{"$f":"VLOOKUP(B70,TAB.REF!$A$3:$D$140,2)","v":"CONETOR TERMINAL ATERRAMENTO TEMPORÁRIO DE CHAVE"},{"$f":"VLOOKUP(B70,TAB.REF!$A$3:$D$140,3)","v":"PC"},9,{"$f":"VLOOKUP(B70,TAB.REF!$A$3:$D$140,4)","v":8.6300000000000008},77.67,11.35,102.15]
[62,227066,{"$f":"VLOOKUP(B71,TAB.REF!$A$3:$D$140,2)","v":"CONETOR TERMINAL COMP CA/CAA 54MM² / 70MM² COMPACT"},{"$f":"VLOOKUP(B71,TAB.REF!$A$3:$D$140,3)","v":"PC"},4,{"$f":"VLOOKUP(B71,TAB.REF!$A$3:$D$140,4)","v":5.48},21.92,7.21,28.84]
[63,338731,{"$f":"VLOOKUP(B72,TAB.REF!$A$3:$D$140,2)","v":"CONETOR TERMINAL COMPRESSÃO 16MM²"},{"$f":"VLOOKUP(B72,TAB.REF!$A$3:$D$140,3)","v":"PC"},3,{"$f":"VLOOKUP(B72,TAB.REF!$A$3:$D$140,4)","v":2.12},6.36,2.79,8.3699999999999992]
[64,231886,{"$f":"VLOOKUP(B73,TAB.REF!$A$3:$D$140,2)","v":"CONETOR TERMINAL COMPRESSÃO 1F 50MM²"},{"$f":"VLOOKUP(B73,TAB.REF!$A$3:$D$140,3)","v":"PC"},6,{"$f":"VLOOKUP(B73,TAB.REF!$A$3:$D$140,4)","v":1.92},11.52,2.5299999999999998,15.18]
[65,227389,{"$f":"VLOOKUP(B74,TAB.REF!$A$3:$D$140,2)","v":"CONETOR TERMINAL COMPRESSÃO 1F AÇO 6,4MM / 21MM²"},{"$f":"VLOOKUP(B74,TAB.REF!$A$3:$D$140,3)","v":"PC"},16,{"$f":"VLOOKUP(B74,TAB.REF!$A$3:$D$140,4)","v":2.0699999999999998},33.119999999999997,2.72,43.52]
[66,377705,{"$f":"VLOOKUP(B75,TAB.REF!$A$3:$D$140,2)","v":"CRUZETA DE FIBRA DE VIDRO 2400X112,5X90MM"},{"$f":"VLOOKUP(B75,TAB.REF!$A$3:$D$140,3)","v":"PC"},8,{"$f":"VLOOKUP(B75,TAB.REF!$A$3:$D$140,4)","v":210.26},1682.08,276.62,2212.96]
[67,271353,{"$f":"VLOOKUP(B76,TAB.REF!$A$3:$D$140,2)","v":"ELO FUSÍVEL BOTÃO 500MM 3H"},{"$f":"VLOOKUP(B76,TAB.REF!$A$3:$D$140,3)","v":"PC"},3,{"$f":"VLOOKUP(B76,TAB.REF!$A$3:$D$140,4)","v":4.3},12.9,5.66,16.98]
[68,231662,{"$f":"VLOOKUP(B77,TAB.REF!$A$3:$D$140,2)","v":"ESPAÇADOR LOSANGULAR 50-150MM² 15KV"},{"$f":"VLOOKUP(B77,TAB.REF!$A$3:$D$140,3)","v":"CJ"},16,{"$f":"VLOOKUP(B77,TAB.REF!$A$3:$D$140,4)","v":21.82},349.12,28.71,459.36]
[69,328120,{"$f":"VLOOKUP(B78,TAB.REF!$A$3:$D$140,2)","v":"ESTRIBO PARA BRAÇO TIPO L PARA RDAP"},{"$f":"VLOOKUP(B78,TAB.REF!$A$3:$D$140,3)","v":"PC"},1,{"$f":"VLOOKUP(B78,TAB.REF!$A$3:$D$140,4)","v":10.94},10.94,14.39,14.39]
[70,357342,{"$f":"VLOOKUP(B79,TAB.REF!$A$3:$D$140,2)","v":"FIO PARA AMARRAÇÃO ALUMÍNIO RECOZIDO 5,2MM (4AWG)"},{"$f":"VLOOKUP(B79,TAB.REF!$A$3:$D$140,3)","v":"KG"},0.02,{"$f":"VLOOKUP(B79,TAB.REF!$A$3:$D$140,4)","v":31.05},0.62,40.85,0.82]
[71,237701,{"$f":"VLOOKUP(B80,TAB.REF!$A$3:$D$140,2)","v":"FIXADOR PREFORMADO ESTAI 6,4MM"},{"$f":"VLOOKUP(B80,TAB.REF!$A$3:$D$140,3)","v":"PC"},1,{"$f":"VLOOKUP(B80,TAB.REF!$A$3:$D$140,4)","v":6.68},6.68,8.7899999999999991,8.7899999999999991]
[72,234575,{"$f":"VLOOKUP(B81,TAB.REF!$A$3:$D$140,2)","v":"GRAMPO ANCORAGEM PARA CABO 150MM² 15KV"},{"$f":"VLOOKUP(B81,TAB.REF!$A$3:$D$140,3)","v":"PC"},6,{"$f":"VLOOKUP(B81,TAB.REF!$A$3:$D$140,4)","v":23.4},140.4,30.79,184.74]
[73,234567,{"$f":"VLOOKUP(B82,TAB.REF!$A$3:$D$140,2)","v":"GRAMPO ANCORAGEM PARA CABO 50MM² 15KV"},{"$f":"VLOOKUP(B82,TAB.REF!$A$3:$D$140,3)","v":"PC"},29,{"$f":"VLOOKUP(B82,TAB.REF!$A$3:$D$140,4)","v":20.12},583.48,26.47,767.63]
[74,222539,{"$f":"VLOOKUP(B83,TAB.REF!$A$3:$D$140,2)","v":"HASTE ATERRAMENTO 2400MM"},{"$f":"VLOOKUP(B83,TAB.REF!$A$3:$D$140,3)","v":"PC"},13,{"$f":"VLOOKUP(B83,TAB.REF!$A$3:$D$140,4)","v":40.75},529.75,53.61,696.93]
[75,219659,{"$f":"VLOOKUP(B84,TAB.REF!$A$3:$D$140,2)","v":"ISOLADOR DE ANCORAGEM POLIMÉRICO 15KV ITEM 1"},{"$f":"VLOOKUP(B84,TAB.REF!$A$3:$D$140,3)","v":"PC"},39,{"$f":"VLOOKUP(B84,TAB.REF!$A$3:$D$140,4)","v":41.77},1629.03,54.95,2143.0500000000002]
[76,219642,{"$f":"VLOOKUP(B85,TAB.REF!$A$3:$D$140,2)","v":"ISOLADOR PINO POLIMÉRICO 15 KV P/BRAÇO SUPORTE C"},{"$f":"VLOOKUP(B85,TAB.REF!$A$3:$D$140,3)","v":"PC"},16,{"$f":"VLOOKUP(B85,TAB.REF!$A$3:$D$140,4)","v":20.079999999999998},321.27999999999997,26.42,422.72]
[77,219634,{"$f":"VLOOKUP(B86,TAB.REF!$A$3:$D$140,2)","v":"ISOLADOR ROLDANA PORCELANA OU VIDRO"},{"$f":"VLOOKUP(B86,TAB.REF!$A$3:$D$140,3)","v":"PC"},1,{"$f":"VLOOKUP(B86,TAB.REF!$A$3:$D$140,4)","v":5.42},5.42,7.13,7.13]
[78,376238,{"$f":"VLOOKUP(B87,TAB.REF!$A$3:$D$140,2)","v":"LÂMPADA VAPOR DE SÓDIO 100W AP E-40 TUBULAR"},{"$f":"VLOOKUP(B87,TAB.REF!$A$3:$D$140,3)","v":"PC"},4,{"$f":"VLOOKUP(B87,TAB.REF!$A$3:$D$140,4)","v":24.46},97.84,32.18,128.72]
[79,376109,{"$f":"VLOOKUP(B88,TAB.REF!$A$3:$D$140,2)","v":"LUMINÁRIA COM EQUIPAMENTO VS 100W VIDRO PLANO"},{"$f":"VLOOKUP(B88,TAB.REF!$A$3:$D$140,3)","v":"PC"},4,{"$f":"VLOOKUP(B88,TAB.REF!$A$3:$D$140,4)","v":269.72000000000003},1078.8800000000001,354.84,1419.36]
[80,120,{"$f":"VLOOKUP(B89,TAB.REF!$A$3:$D$140,2)","v":"LUMINARIA LED POTÊNCIA ATÉ 120W FLUXO LUMINOSO APROXIMADO 13.800lm EFICIENCIA LUMINOSA ≥ 115lm/w"},{"$f":"VLOOKUP(B89,TAB.REF!$A$3:$D$140,3)","v":"PC"},9,{"$f":"VLOOKUP(B89,TAB.REF!$A$3:$D$140,4)","v":767},{"$f":"ROUND(F89*E89,2)","v":6903},{"$f":"ROUND(F89*(1+$I$6),2)","v":1009.07},{"$f":"ROUND(H89*E89,2)","v":9081.6299999999992}]
[81,237271,{"$f":"VLOOKUP(B90,TAB.REF!$A$3:$D$140,2)","v":"MANILHA SAPATILHA CLASSE 50KN"},{"$f":"VLOOKUP(B90,TAB.REF!$A$3:$D$140,3)","v":"PC"},39,{"$f":"VLOOKUP(B90,TAB.REF!$A$3:$D$140,4)","v":10.91},425.49,14.35,559.65]
[82,374393,{"$f":"VLOOKUP(B91,TAB.REF!$A$3:$D$140,2)","v":"MANTA AUTO-ADESIVA PARA EMENDA CABO 15KV RDP"},{"$f":"VLOOKUP(B91,TAB.REF!$A$3:$D$140,3)","v":"PC"},14,{"$f":"VLOOKUP(B91,TAB.REF!$A$3:$D$140,4)","v":66.28},927.92,87.2,1220.8]
[83,237784,{"$f":"VLOOKUP(B92,TAB.REF!$A$3:$D$140,2)","v":"MÃO-FRANCESA PERFILADA NORMAL 38X5X726MM"},{"$f":"VLOOKUP(B92,TAB.REF!$A$3:$D$140,3)","v":"PC"},8,{"$f":"VLOOKUP(B92,TAB.REF!$A$3:$D$140,4)","v":22.64},181.12,29.79,238.32]
[84,82586,{"$f":"VLOOKUP(B93,TAB.REF!$A$3:$D$140,2)","v":"MASSA CALAFETAR 1KG"},{"$f":"VLOOKUP(B93,TAB.REF!$A$3:$D$140,3)","v":"KG"},0.1,{"$f":"VLOOKUP(B93,TAB.REF!$A$3:$D$140,4)","v":16.78},1.68,22.08,2.21]
[85,237289,{"$f":"VLOOKUP(B94,TAB.REF!$A$3:$D$140,2)","v":"OLHAL PARA PARAFUSO 50KN"},{"$f":"VLOOKUP(B94,TAB.REF!$A$3:$D$140,3)","v":"PC"},97,{"$f":"VLOOKUP(B94,TAB.REF!$A$3:$D$140,4)","v":16.760000000000002},1625.72,22.05,2138.85]
[86,66878,{"$f":"VLOOKUP(B95,TAB.REF!$A$3:$D$140,2)","v":"PARAFUSO CABEÇA ABAULADA M16X 45MM"},{"$f":"VLOOKUP(B95,TAB.REF!$A$3:$D$140,3)","v":"PC"},95,{"$f":"VLOOKUP(B95,TAB.REF!$A$3:$D$140,4)","v":2.17},206.15,2.85,270.75]
[87,66886,{"$f":"VLOOKUP(B96,TAB.REF!$A$3:$D$140,2)","v":"PARAFUSO CABEÇA ABAULADA M16X 70MM"},{"$f":"VLOOKUP(B96,TAB.REF!$A$3:$D$140,3)","v":"PC"},211,{"$f":"VLOOKUP(B96,TAB.REF!$A$3:$D$140,4)","v":2.64},557.04,3.47,732.17]
[88,66894,{"$f":"VLOOKUP(B97,TAB.REF!$A$3:$D$140,2)","v":"PARAFUSO CABEÇA ABAULADA M16X150MM"},{"$f":"VLOOKUP(B97,TAB.REF!$A$3:$D$140,3)","v":"PC"},8,{"$f":"VLOOKUP(B97,TAB.REF!$A$3:$D$140,4)","v":4.3},{"$f":"ROUND(F97*E97,2)","v":34.4},{"$f":"ROUND(F97*(1+$I$6),2)","v":5.66},{"$f":"ROUND(H97*E97,2)","v":45.28}]
[89,74799,{"$f":"VLOOKUP(B98,TAB.REF!$A$3:$D$140,2)","v":"PARAFUSO CABEÇA QUADRADA M16X125MM"},{"$f":"VLOOKUP(B98,TAB.REF!$A$3:$D$140,3)","v":"PC"},3,{"$f":"VLOOKUP(B98,TAB.REF!$A$3:$D$140,4)","v":3.99},11.97,5.25,15.75]
[90,74807,{"$f":"VLOOKUP(B99,TAB.REF!$A$3:$D$140,2)","v":"PARAFUSO CABEÇA QUADRADA M16X150MM"},{"$f":"VLOOKUP(B99,TAB.REF!$A$3:$D$140,3)","v":"PC"},8,{"$f":"VLOOKUP(B99,TAB.REF!$A$3:$D$140,4)","v":4.37},34.96,5.75,46]
[91,74831,{"$f":"VLOOKUP(B100,TAB.REF!$A$3:$D$140,2)","v":"PARAFUSO CABEÇA QUADRADA M16X300MM"},{"$f":"VLOOKUP(B100,TAB.REF!$A$3:$D$140,3)","v":"PC"},2,{"$f":"VLOOKUP(B100,TAB.REF!$A$3:$D$140,4)","v":6.75},13.5,8.8800000000000008,17.760000000000002]
[92,74864,{"$f":"VLOOKUP(B101,TAB.REF!$A$3:$D$140,2)","v":"PARAFUSO CABEÇA QUADRADA M16X450MM"},{"$f":"VLOOKUP(B101,TAB.REF!$A$3:$D$140,3)","v":"PC"},10,{"$f":"VLOOKUP(B101,TAB.REF!$A$3:$D$140,4)","v":9.7899999999999991},97.9,12.88,128.80000000000001]
[93,74872,{"$f":"VLOOKUP(B102,TAB.REF!$A$3:$D$140,2)","v":"PARAFUSO CABEÇA QUADRADA M16X500MM"},{"$f":"VLOOKUP(B102,TAB.REF!$A$3:$D$140,3)","v":"PC"},4,{"$f":"VLOOKUP(B102,TAB.REF!$A$3:$D$140,4)","v":11.41},45.64,15.01,60.04]
[94,75036,{"$f":"VLOOKUP(B103,TAB.REF!$A$3:$D$140,2)","v":"PARAFUSO CABEÇA SEXTAVADA M12X 40MM"},{"$f":"VLOOKUP(B103,TAB.REF!$A$3:$D$140,3)","v":"PC"},8,{"$f":"VLOOKUP(B103,TAB.REF!$A$3:$D$140,4)","v":12.44},99.52,16.37,130.96]
[95,289058,{"$f":"VLOOKUP(B104,TAB.REF!$A$3:$D$140,2)","v":"PÁRA-RAIOS 12KV 10KA ZNO"},{"$f":"VLOOKUP(B104,TAB.REF!$A$3:$D$140,3)","v":"PC"},3,{"$f":"VLOOKUP(B104,TAB.REF!$A$3:$D$140,4)","v":153.69},461.07,202.19,606.57000000000005]
[96,293357,{"$f":"VLOOKUP(B105,TAB.REF!$A$3:$D$140,2)","v":"PÁRA-RAIOS REDE SECUNDÁRIA ISOLADA 280V 10KA"},{"$f":"VLOOKUP(B105,TAB.REF!$A$3:$D$140,3)","v":"PC"},3,{"$f":"VLOOKUP(B105,TAB.REF!$A$3:$D$140,4)","v":59.64},178.92,78.459999999999994,235.38]
[97,236265,{"$f":"VLOOKUP(B106,TAB.REF!$A$3:$D$140,2)","v":"PINO P/ ISOLADOR POLIMÉRICO ATÉ 36,2 KV - BRAÇO C"},{"$f":"VLOOKUP(B106,TAB.REF!$A$3:$D$140,3)","v":"PC"},13,{"$f":"VLOOKUP(B106,TAB.REF!$A$3:$D$140,4)","v":15.35},199.55,20.190000000000001,262.47000000000003]
[98,75630,{"$f":"VLOOKUP(B107,TAB.REF!$A$3:$D$140,2)","v":"PORCA QUADRADA M16 24X24X13MM"},{"$f":"VLOOKUP(B107,TAB.REF!$A$3:$D$140,3)","v":"PC"},34,{"$f":"VLOOKUP(B107,TAB.REF!$A$3:$D$140,4)","v":0.68},23.12,0.89,30.26]
[99,207415,{"$f":"VLOOKUP(B108,TAB.REF!$A$3:$D$140,2)","v":"POSTE CONCRETO CIRCULAR 11M 300DAN"},{"$f":"VLOOKUP(B108,TAB.REF!$A$3:$D$140,3)","v":"PC"},9,{"$f":"VLOOKUP(B108,TAB.REF!$A$3:$D$140,4)","v":695.96},6263.64,915.6,8240.4]
[100,207449,{"$f":"VLOOKUP(B109,TAB.REF!$A$3:$D$140,2)","v":"POSTE CONCRETO CIRCULAR 11M 600DAN"},{"$f":"VLOOKUP(B109,TAB.REF!$A$3:$D$140,3)","v":"PC"},2,{"$f":"VLOOKUP(B109,TAB.REF!$A$3:$D$140,4)","v":951.41},1902.82,1251.67,2503.34]
[101,207522,{"$f":"VLOOKUP(B110,TAB.REF!$A$3:$D$140,2)","v":"POSTE CONCRETO CIRCULAR 12M 300DAN"},{"$f":"VLOOKUP(B110,TAB.REF!$A$3:$D$140,3)","v":"PC"},1,{"$f":"VLOOKUP(B110,TAB.REF!$A$3:$D$140,4)","v":765.08},765.08,1006.54,1006.54]
[102,207506,{"$f":"VLOOKUP(B111,TAB.REF!$A$3:$D$140,2)","v":"POSTE CONCRETO CIRCULAR 12M 600DAN"},{"$f":"VLOOKUP(B111,TAB.REF!$A$3:$D$140,3)","v":"PC"},1,{"$f":"VLOOKUP(B111,TAB.REF!$A$3:$D$140,4)","v":1118.3499999999999},1118.3499999999999,1471.3,1471.3]
[103,376112,{"$f":"VLOOKUP(B112,TAB.REF!$A$3:$D$140,2)","v":"REATOR LÂMPADA VS 100W INTEGRADO CONECTOR RÁPIDO"},{"$f":"VLOOKUP(B112,TAB.REF!$A$3:$D$140,3)","v":"PC"},4,{"$f":"VLOOKUP(B112,TAB.REF!$A$3:$D$140,4)","v":45.5},182,59.86,239.44]
[104,327361,{"$f":"VLOOKUP(B113,TAB.REF!$A$3:$D$140,2)","v":"RELÉ FOTOELÉTRICO ELETRÔNICO 105-305V"},{"$f":"VLOOKUP(B113,TAB.REF!$A$3:$D$140,3)","v":"PC"},13,{"$f":"VLOOKUP(B113,TAB.REF!$A$3:$D$140,4)","v":19.100000000000001},248.3,25.13,326.69]
[105,237768,{"$f":"VLOOKUP(B114,TAB.REF!$A$3:$D$140,2)","v":"SAPATILHA"},{"$f":"VLOOKUP(B114,TAB.REF!$A$3:$D$140,3)","v":"PC"},45,{"$f":"VLOOKUP(B114,TAB.REF!$A$3:$D$140,4)","v":1.99},89.55,2.62,117.9]
[106,237156,{"$f":"VLOOKUP(B115,TAB.REF!$A$3:$D$140,2)","v":"SELA PARA CRUZETA"},{"$f":"VLOOKUP(B115,TAB.REF!$A$3:$D$140,3)","v":"PC"},8,{"$f":"VLOOKUP(B115,TAB.REF!$A$3:$D$140,4)","v":8.8800000000000008},71.040000000000006,11.68,93.44]
[107,237081,{"$f":"VLOOKUP(B116,TAB.REF!$A$3:$D$140,2)","v":"SUPORTE 240MM TRANSFORMADOR POSTE CC"},{"$f":"VLOOKUP(B116,TAB.REF!$A$3:$D$140,3)","v":"PC"},2,{"$f":"VLOOKUP(B116,TAB.REF!$A$3:$D$140,4)","v":104.81},209.62,137.88999999999999,275.77999999999997]
[108,237172,{"$f":"VLOOKUP(B117,TAB.REF!$A$3:$D$140,2)","v":"SUPORTE L PARA CRUZETA"},{"$f":"VLOOKUP(B117,TAB.REF!$A$3:$D$140,3)","v":"PC"},9,{"$f":"VLOOKUP(B117,TAB.REF!$A$3:$D$140,4)","v":25.98},233.82,34.18,307.62]
[109,245837,{"$f":"VLOOKUP(B118,TAB.REF!$A$3:$D$140,2)","v":"TRANSFORMADOR TRIFÁSICO 15KV 45KVA"},{"$f":"VLOOKUP(B118,TAB.REF!$A$3:$D$140,3)","v":"PC"},1,{"$f":"VLOOKUP(B118,TAB.REF!$A$3:$D$140,4)","v":5284},5284,6951.63,6951.63]
[" VALOR TOTAL MATERIAIS",null,null,null,null,{"$f":"ROUND(SUM(G10:G118),2)","v":55889.29},null,{"$f":"ROUND(SUM(I10:I118),2)","v":73527.929999999993}]
["MÃO DE OBRA DE CONSTRUÇÃO",null,null,null,null,"PREÇO SEM BDI",null,"PREÇO COM BDI"]
["ITEM","CÓDIGO","DESCRIÇÃO","UN","QUANT.","R$.UNIT.","R$. TOTAL","R$.UNIT.","R$. TOTAL"]
[1,"US. CONST. RDA",{"$f":"VLOOKUP(B122,TAB.REF!$A$2:$D$140,2)","v":"MÃO DE OBRA DE CONSTRUÇÃO DE REDE ELÉTRICA"},"US",18.75,{"$f":"VLOOKUP(B122,TAB.REF!$A$2:$D$140,4)","v":1538.3},{"$f":"ROUND(E122*F122,2)","v":28843.13},{"$f":"F122*(1+$I$6)","v":2023.79},{"$f":"ROUND(H122*E122,2)","v":37946.06}]
[2,"US. CONST. RDS",{"$f":"VLOOKUP(B123,TAB.REF!$A$2:$D$140,2)","v":"MÃO DE OBRA DE CONSTRUÇÃO DE REDE SUBTERRÂNEA"},"US",null,{"$f":"VLOOKUP(B123,TAB.REF!$A$2:$D$140,4)","v":1538.3},{"$f":"ROUND(E123*F123,2)","v":0},{"$f":"F123*(1+$I$6)","v":2023.79},{"$f":"ROUND(H123*E123,2)","v":0}]
[" VALOR TOTAL MÃO DE OBRA",null,null,null,null,{"$f":"SUM(G122:G123)","v":28843.13},null,{"$f":"SUM(I122:I123)","v":37946.06}]
["RESUMO",null,null,null,null,"PREÇO SEM BDI",null,"PREÇO COM BDI"]
[" VALOR TOTAL MATERIAIS",null,null,null,null,{"$f":"ROUND(F119,2)","v":55889.29},null,{"$f":"ROUND(H119,2)","v":73527.929999999993}]
[" VALOR TOTAL MÃO DE OBRA",null,null,null,null,{"$f":"ROUND(F124,2)","v":28843.13},null,{"$f":"H124","v":37946.06}]
[" VALOR TOTAL",null,null,null,null,{"$f":"ROUND(SUM(F126:G127),2)","v":84732.42},null,{"$f":"SUM(H126:I127)","v":111473.99}]
[]
[]
[{"$f":"CONCATENATE(RESUMO!B18,\" \",RESUMO!C18)","v":"Patos de Minas, 4 de fevereiro de 2020"}]
[]
[]
["_______________________________________________________"]
[{"$f":"RESUMO!B21","v":"Diogo Soares Resende"}]
[{"$f":"RESUMO!B22","v":"Eng. Eletricista"}]
[{"$f":"RESUMO!B23","v":"CREA: 194.419D/MG"}]

{"sheet":"CVCTEC-83","index":7,"n_rows":132,"n_cols":9,"rows_kept":132,"cut":false,"hidden":false,"merged":[[129,0,129,8],[130,0,130,8],[131,0,131,8],[122,0,122,4],[122,5,122,6],[122,7,122,8],[125,0,125,8],[127,0,127,6],[128,0,128,8],[120,0,120,4],[120,5,120,6],[120,7,120,8],[121,0,121,4],[121,5,121,6],[121,7,121,8],[118,0,118,4],[118,5,118,6],[118,7,118,8],[119,0,119,4],[119,5,119,6],[119,7,119,8],[113,0,113,4],[113,5,113,6],[113,7,113,8],[114,0,114,4],[114,5,114,6],[114,7,114,8],[5,0,5,4],[6,0,6,8],[7,0,8,0],[7,1,8,1],[7,2,8,2],[7,3,8,3],[7,4,8,4],[7,5,7,6],[7,7,7,8],[0,0,0,8],[1,0,1,8],[2,0,2,8],[3,0,3,8],[4,0,4,4]]}
[]
["PLANILHA ORÇAMENTÁRIA "]
["OBJETO: PROJETOS DE MODIFICAÇÃO, EXTENSÃO DE REDE  E ILUMINAÇÃO PÚBLICA"]
["LOCAL: CVCTEC_PMINAS_83 - AVENIDA DOS BURITIS - B. ALTO DA COLINA"]
["RESPONSÁVEL TÉCNICO: DIOGO SOARES RESENDE",null,null,null,null,"CREA:",{"$f":"LEFT(RIGHT(RESUMO!B23,11),8)","v":"194.419D"},"ART:"]
["REFERENCIA DE PREÇOS: PREÇOS DE MERCADO",null,null,null,null,"DATA: ",{"$f":"RESUMO!E5","v":"2020-02-04"},"BDI :",{"$f":"RESUMO!F5","v":0.31559999999999999}]
[]
["ITEM","CÓDIGO ","DESCRIÇÃO","UNID.","QUANT.","PREÇO SEM BDI",null,"PREÇO COM BDI"]
[null,null,null,null,null,"UNITÁRIO ","TOTAL","UNITÁRIO ","TOTAL"]
[1,237222,{"$f":"VLOOKUP(B10,TAB.REF!$A$3:$D$140,2)","v":"AFASTADOR ARMAÇÃO SECUNDÁRIA 500MM"},{"$f":"VLOOKUP(B10,TAB.REF!$A$3:$D$140,3)","v":"PC"},1,{"$f":"VLOOKUP(B10,TAB.REF!$A$3:$D$140,4)","v":124.8},{"$f":"ROUND(F10*E10,2)","v":124.8},{"$f":"ROUND(F10*(1+$I$6),2)","v":164.19},{"$f":"ROUND(H10*E10,2)","v":164.19}]
[2,231522,{"$f":"VLOOKUP(B11,TAB.REF!$A$3:$D$140,2)","v":"ALÇA PARA ESTRIBO FECHADA 2AWG"},{"$f":"VLOOKUP(B11,TAB.REF!$A$3:$D$140,3)","v":"PC"},12,{"$f":"VLOOKUP(B11,TAB.REF!$A$3:$D$140,4)","v":8.61},103.32,11.33,135.96]
[3,237677,{"$f":"VLOOKUP(B12,TAB.REF!$A$3:$D$140,2)","v":"ALÇA PREFORMADA ESTAI CABO AÇO 9,5MM"},{"$f":"VLOOKUP(B12,TAB.REF!$A$3:$D$140,3)","v":"PC"},14,{"$f":"VLOOKUP(B12,TAB.REF!$A$3:$D$140,4)","v":12.24},171.36,16.100000000000001,225.4]
[4,228981,{"$f":"VLOOKUP(B13,TAB.REF!$A$3:$D$140,2)","v":"ALÇA PREFORMADA NEUTRO CA/CAL 16MM²"},{"$f":"VLOOKUP(B13,TAB.REF!$A$3:$D$140,3)","v":"PC"},40,{"$f":"VLOOKUP(B13,TAB.REF!$A$3:$D$140,4)","v":1.3},52,1.71,68.400000000000006]
[5,228874,{"$f":"VLOOKUP(B14,TAB.REF!$A$3:$D$140,2)","v":"ALÇA PREFORMADA NEUTRO CA/CAL 35MM²"},{"$f":"VLOOKUP(B14,TAB.REF!$A$3:$D$140,3)","v":"PC"},1,{"$f":"VLOOKUP(B14,TAB.REF!$A$3:$D$140,4)","v":4.7699999999999996},4.7699999999999996,6.28,6.28]
[6,229005,{"$f":"VLOOKUP(B15,TAB.REF!$A$3:$D$140,2)","v":"ALÇA PREFORMADA NEUTRO CA/CAL 70MM²"},{"$f":"VLOOKUP(B15,TAB.REF!$A$3:$D$140,3)","v":"PC"},11,{"$f":"VLOOKUP(B15,TAB.REF!$A$3:$D$140,4)","v":6.03},66.33,7.93,87.23]
[7,219709,{"$f":"VLOOKUP(B16,TAB.REF!$A$3:$D$140,2)","v":"ALÇA PREFORMADA OLHAL CA/CAA 34MM² (2AWG)"},{"$f":"VLOOKUP(B16,TAB.REF!$A$3:$D$140,3)","v":"PC"},16,{"$f":"VLOOKUP(B16,TAB.REF!$A$3:$D$140,4)","v":12.17},194.72,16.010000000000002,256.16000000000003]
[8,327700,{"$f":"VLOOKUP(B17,TAB.REF!$A$3:$D$140,2)","v":"ANEL ELASTOMÉRICO P/ ISOLADOR PINO POLIMÉRICO 15KV"},{"$f":"VLOOKUP(B17,TAB.REF!$A$3:$D$140,3)","v":"PC"},10,{"$f":"VLOOKUP(B17,TAB.REF!$A$3:$D$140,4)","v":4.29},42.9,5.64,56.4]
[9,237230,{"$f":"VLOOKUP(B18,TAB.REF!$A$3:$D$140,2)","v":"ARMAÇÃO SECUNDÁRIO 1 ESTRIBO"},{"$f":"VLOOKUP(B18,TAB.REF!$A$3:$D$140,3)","v":"PC"},1,{"$f":"VLOOKUP(B18,TAB.REF!$A$3:$D$140,4)","v":11},11,14.47,14.47]
[10,237248,{"$f":"VLOOKUP(B19,TAB.REF!$A$3:$D$140,2)","v":"ARMAÇÃO SECUNDÁRIO 2 ESTRIBOS"},{"$f":"VLOOKUP(B19,TAB.REF!$A$3:$D$140,3)","v":"PC"},1,{"$f":"VLOOKUP(B19,TAB.REF!$A$3:$D$140,4)","v":23.33},23.33,30.69,30.69]
[11,75721,{"$f":"VLOOKUP(B20,TAB.REF!$A$3:$D$140,2)","v":"ARRUELA QUADRADA 38X18X3MM"},{"$f":"VLOOKUP(B20,TAB.REF!$A$3:$D$140,3)","v":"PC"},53,{"$f":"VLOOKUP(B20,TAB.REF!$A$3:$D$140,4)","v":0.52},27.56,0.68,36.04]
[12,327692,{"$f":"VLOOKUP(B21,TAB.REF!$A$3:$D$140,2)","v":"BRAÇADEIRA PLÁSTICA CABO MULTIPLEXADO"},{"$f":"VLOOKUP(B21,TAB.REF!$A$3:$D$140,3)","v":"PC"},43,{"$f":"VLOOKUP(B21,TAB.REF!$A$3:$D$140,4)","v":1.1499999999999999},49.45,1.51,64.930000000000007]
[13,328138,{"$f":"VLOOKUP(B22,TAB.REF!$A$3:$D$140,2)","v":"BRAÇO ANTIBALANÇO 15KV"},{"$f":"VLOOKUP(B22,TAB.REF!$A$3:$D$140,3)","v":"PC"},7,{"$f":"VLOOKUP(B22,TAB.REF!$A$3:$D$140,4)","v":25.79},180.53,33.93,237.51]
[14,258921,{"$f":"VLOOKUP(B23,TAB.REF!$A$3:$D$140,2)","v":"BRAÇO PARA IP TIPO MÉDIO"},{"$f":"VLOOKUP(B23,TAB.REF!$A$3:$D$140,3)","v":"PC"},9,{"$f":"VLOOKUP(B23,TAB.REF!$A$3:$D$140,4)","v":166.63},1499.67,219.22,1972.98]
[15,211789,{"$f":"VLOOKUP(B24,TAB.REF!$A$3:$D$140,2)","v":"BRAÇO SUPORTE C"},{"$f":"VLOOKUP(B24,TAB.REF!$A$3:$D$140,3)","v":"PC"},6,{"$f":"VLOOKUP(B24,TAB.REF!$A$3:$D$140,4)","v":92.79},556.74,122.07,732.42]
[16,231712,{"$f":"VLOOKUP(B25,TAB.REF!$A$3:$D$140,2)","v":"BRAÇO SUPORTE COM GRAMPO DE SUSPENSÃO ITEM 2"},{"$f":"VLOOKUP(B25,TAB.REF!$A$3:$D$140,3)","v":"CJ"},8,{"$f":"VLOOKUP(B25,TAB.REF!$A$3:$D$140,4)","v":38.380000000000003},307.04000000000002,50.49,403.92]
[17,211771,{"$f":"VLOOKUP(B26,TAB.REF!$A$3:$D$140,2)","v":"BRAÇO SUPORTE L"},{"$f":"VLOOKUP(B26,TAB.REF!$A$3:$D$140,3)","v":"PC"},7,{"$f":"VLOOKUP(B26,TAB.REF!$A$3:$D$140,4)","v":72.27},505.89,95.08,665.56]
[18,225623,{"$f":"VLOOKUP(B27,TAB.REF!$A$3:$D$140,2)","v":"CABO AL 1X 16MM² 1KV"},{"$f":"VLOOKUP(B27,TAB.REF!$A$3:$D$140,3)","v":"M"},3,{"$f":"VLOOKUP(B27,TAB.REF!$A$3:$D$140,4)","v":1.85},5.55,2.4300000000000002,7.29]
[19,231548,{"$f":"VLOOKUP(B28,TAB.REF!$A$3:$D$140,2)","v":"CABO AL 1X 50MM² 15KV PROTEGIDO"},{"$f":"VLOOKUP(B28,TAB.REF!$A$3:$D$140,3)","v":"M"},829,{"$f":"VLOOKUP(B28,TAB.REF!$A$3:$D$140,4)","v":7.15},5927.35,9.41,7800.89]
[20,225656,{"$f":"VLOOKUP(B29,TAB.REF!$A$3:$D$140,2)","v":"CABO AL 1X 70MM² 1KV"},{"$f":"VLOOKUP(B29,TAB.REF!$A$3:$D$140,3)","v":"M"},6,{"$f":"VLOOKUP(B29,TAB.REF!$A$3:$D$140,4)","v":6.53},39.18,8.59,51.54]
[21,225615,{"$f":"VLOOKUP(B30,TAB.REF!$A$3:$D$140,2)","v":"CABO CU 1X 1,5MM² 1KV XLPE"},{"$f":"VLOOKUP(B30,TAB.REF!$A$3:$D$140,3)","v":"M"},104,{"$f":"VLOOKUP(B30,TAB.REF!$A$3:$D$140,4)","v":1.1499999999999999},119.6,1.51,157.04]
[22,2964,{"$f":"VLOOKUP(B31,TAB.REF!$A$3:$D$140,2)","v":"CABO DE AÇO HS 3/8P (9,5MM²) 7FIOS"},{"$f":"VLOOKUP(B31,TAB.REF!$A$3:$D$140,3)","v":"KG"},110.03,{"$f":"VLOOKUP(B31,TAB.REF!$A$3:$D$140,4)","v":7.78},856.03,10.24,1126.71]
[23,2931,{"$f":"VLOOKUP(B32,TAB.REF!$A$3:$D$140,2)","v":"CABO DE AÇO MR 1/4P (6,4MM) 7 FIOS"},{"$f":"VLOOKUP(B32,TAB.REF!$A$3:$D$140,3)","v":"KG"},31.7,{"$f":"VLOOKUP(B32,TAB.REF!$A$3:$D$140,4)","v":2.76},87.49,3.63,115.07]
[24,226373,{"$f":"VLOOKUP(B33,TAB.REF!$A$3:$D$140,2)","v":"CABO QUADRUPLEX CA 3X1X 70+70 1KV"},{"$f":"VLOOKUP(B33,TAB.REF!$A$3:$D$140,3)","v":"M"},343,{"$f":"VLOOKUP(B33,TAB.REF!$A$3:$D$140,4)","v":22.81},7823.83,30.01,10293.43]
[25,231589,{"$f":"VLOOKUP(B34,TAB.REF!$A$3:$D$140,2)","v":"CABO TRIPLEX CA 2X1X70+70 1KV"},{"$f":"VLOOKUP(B34,TAB.REF!$A$3:$D$140,3)","v":"M"},69,{"$f":"VLOOKUP(B34,TAB.REF!$A$3:$D$140,4)","v":16.079999999999998},1109.52,21.15,1459.35]
[26,223818,{"$f":"VLOOKUP(B35,TAB.REF!$A$3:$D$140,2)","v":"CANTONEIRA PARA BRAÇO C"},{"$f":"VLOOKUP(B35,TAB.REF!$A$3:$D$140,3)","v":"PC"},5,{"$f":"VLOOKUP(B35,TAB.REF!$A$3:$D$140,4)","v":60.9},304.5,80.12,400.6]
[27,231878,{"$f":"VLOOKUP(B36,TAB.REF!$A$3:$D$140,2)","v":"CARTUCHO DE APLICAÇÃO VERMELHO"},{"$f":"VLOOKUP(B36,TAB.REF!$A$3:$D$140,3)","v":"PC"},21,{"$f":"VLOOKUP(B36,TAB.REF!$A$3:$D$140,4)","v":6.54},137.34,8.6,180.6]
[28,270439,{"$f":"VLOOKUP(B37,TAB.REF!$A$3:$D$140,2)","v":"CHAVE FUSÍVEL 15KV COM PORTA FUSÍVEL 100A 7,1KA"},{"$f":"VLOOKUP(B37,TAB.REF!$A$3:$D$140,3)","v":"PC"},4,{"$f":"VLOOKUP(B37,TAB.REF!$A$3:$D$140,4)","v":243.45},973.8,320.27999999999997,1281.1199999999999]
[29,236836,{"$f":"VLOOKUP(B38,TAB.REF!$A$3:$D$140,2)","v":"CINTA DE AÇO D 170MM"},{"$f":"VLOOKUP(B38,TAB.REF!$A$3:$D$140,3)","v":"PC"},15,{"$f":"VLOOKUP(B38,TAB.REF!$A$3:$D$140,4)","v":16.28},244.2,21.42,321.3]
[30,236844,{"$f":"VLOOKUP(B39,TAB.REF!$A$3:$D$140,2)","v":"CINTA DE AÇO D 180MM"},{"$f":"VLOOKUP(B39,TAB.REF!$A$3:$D$140,3)","v":"PC"},7,{"$f":"VLOOKUP(B39,TAB.REF!$A$3:$D$140,4)","v":16.510000000000002},115.57,21.72,152.04]
[31,236851,{"$f":"VLOOKUP(B40,TAB.REF!$A$3:$D$140,2)","v":"CINTA DE AÇO D 190MM"},{"$f":"VLOOKUP(B40,TAB.REF!$A$3:$D$140,3)","v":"PC"},7,{"$f":"VLOOKUP(B40,TAB.REF!$A$3:$D$140,4)","v":17.48},122.36,23,161]
[32,236869,{"$f":"VLOOKUP(B41,TAB.REF!$A$3:$D$140,2)","v":"CINTA DE AÇO D 200MM"},{"$f":"VLOOKUP(B41,TAB.REF!$A$3:$D$140,3)","v":"PC"},6,{"$f":"VLOOKUP(B41,TAB.REF!$A$3:$D$140,4)","v":17.93},{"$f":"ROUND(F41*E41,2)","v":107.58},{"$f":"ROUND(F41*(1+$I$6),2)","v":23.59},{"$f":"ROUND(H41*E41,2)","v":141.54}]
[33,236877,{"$f":"VLOOKUP(B42,TAB.REF!$A$3:$D$140,2)","v":"CINTA DE AÇO D 210MM"},{"$f":"VLOOKUP(B42,TAB.REF!$A$3:$D$140,3)","v":"PC"},15,{"$f":"VLOOKUP(B42,TAB.REF!$A$3:$D$140,4)","v":18.52},277.8,24.36,365.4]
[34,236885,{"$f":"VLOOKUP(B43,TAB.REF!$A$3:$D$140,2)","v":"CINTA DE AÇO D 220MM"},{"$f":"VLOOKUP(B43,TAB.REF!$A$3:$D$140,3)","v":"PC"},6,{"$f":"VLOOKUP(B43,TAB.REF!$A$3:$D$140,4)","v":18.66},111.96,24.55,147.30000000000001]
[35,236893,{"$f":"VLOOKUP(B44,TAB.REF!$A$3:$D$140,2)","v":"CINTA DE AÇO D 230MM"},{"$f":"VLOOKUP(B44,TAB.REF!$A$3:$D$140,3)","v":"PC"},28,{"$f":"VLOOKUP(B44,TAB.REF!$A$3:$D$140,4)","v":19.34},541.52,25.44,712.32]
[36,236901,{"$f":"VLOOKUP(B45,TAB.REF!$A$3:$D$140,2)","v":"CINTA DE AÇO D 240MM"},{"$f":"VLOOKUP(B45,TAB.REF!$A$3:$D$140,3)","v":"PC"},7,{"$f":"VLOOKUP(B45,TAB.REF!$A$3:$D$140,4)","v":20.51},143.57,26.98,188.86]
[37,236919,{"$f":"VLOOKUP(B46,TAB.REF!$A$3:$D$140,2)","v":"CINTA DE AÇO D 250MM"},{"$f":"VLOOKUP(B46,TAB.REF!$A$3:$D$140,3)","v":"PC"},17,{"$f":"VLOOKUP(B46,TAB.REF!$A$3:$D$140,4)","v":21.79},370.43,28.67,487.39]
[38,236927,{"$f":"VLOOKUP(B47,TAB.REF!$A$3:$D$140,2)","v":"CINTA DE AÇO D 260MM"},{"$f":"VLOOKUP(B47,TAB.REF!$A$3:$D$140,3)","v":"PC"},1,{"$f":"VLOOKUP(B47,TAB.REF!$A$3:$D$140,4)","v":21.62},21.62,28.44,28.44]
[39,236935,{"$f":"VLOOKUP(B48,TAB.REF!$A$3:$D$140,2)","v":"CINTA DE AÇO D 270MM"},{"$f":"VLOOKUP(B48,TAB.REF!$A$3:$D$140,3)","v":"PC"},4,{"$f":"VLOOKUP(B48,TAB.REF!$A$3:$D$140,4)","v":22.15},88.6,29.14,116.56]
[40,236943,{"$f":"VLOOKUP(B49,TAB.REF!$A$3:$D$140,2)","v":"CINTA DE AÇO D 280MM"},{"$f":"VLOOKUP(B49,TAB.REF!$A$3:$D$140,3)","v":"PC"},1,{"$f":"VLOOKUP(B49,TAB.REF!$A$3:$D$140,4)","v":25.47},25.47,33.51,33.51]
[41,236950,{"$f":"VLOOKUP(B50,TAB.REF!$A$3:$D$140,2)","v":"CINTA DE AÇO D 290MM"},{"$f":"VLOOKUP(B50,TAB.REF!$A$3:$D$140,3)","v":"PC"},1,{"$f":"VLOOKUP(B50,TAB.REF!$A$3:$D$140,4)","v":23.93},23.93,31.48,31.48]
[42,375058,{"$f":"VLOOKUP(B51,TAB.REF!$A$3:$D$140,2)","v":"COBERTURA PROTETORA P/ BCH BT TRANSFORMADOR ITEM 1"},{"$f":"VLOOKUP(B51,TAB.REF!$A$3:$D$140,3)","v":"PC"},10,{"$f":"VLOOKUP(B51,TAB.REF!$A$3:$D$140,4)","v":8.41},84.1,11.06,110.6]
[43,39586,{"$f":"VLOOKUP(B52,TAB.REF!$A$3:$D$140,2)","v":"COBERTURA PROTETORA PARA BUCHA DE EQUIPAMENTO"},{"$f":"VLOOKUP(B52,TAB.REF!$A$3:$D$140,3)","v":"PC"},3,{"$f":"VLOOKUP(B52,TAB.REF!$A$3:$D$140,4)","v":9.67},29.01,12.72,38.159999999999997]
[44,378809,{"$f":"VLOOKUP(B53,TAB.REF!$A$3:$D$140,2)","v":"CONECTOR TERMINAL P/ BUCHA,50 MM²,RETO,COMPRESSÃO"},{"$f":"VLOOKUP(B53,TAB.REF!$A$3:$D$140,3)","v":"PC"},3,{"$f":"VLOOKUP(B53,TAB.REF!$A$3:$D$140,4)","v":12.06},36.18,15.87,47.61]
[45,231795,{"$f":"VLOOKUP(B54,TAB.REF!$A$3:$D$140,2)","v":"CONETOR CUNHA AL 50MM² COM ESTRIBO"},{"$f":"VLOOKUP(B54,TAB.REF!$A$3:$D$140,3)","v":"PC"},21,{"$f":"VLOOKUP(B54,TAB.REF!$A$3:$D$140,4)","v":14.96},314.16000000000003,19.68,413.28]
[46,227850,{"$f":"VLOOKUP(B55,TAB.REF!$A$3:$D$140,2)","v":"CONETOR CUNHA CU ITEM 1"},{"$f":"VLOOKUP(B55,TAB.REF!$A$3:$D$140,3)","v":"PC"},44,{"$f":"VLOOKUP(B55,TAB.REF!$A$3:$D$140,4)","v":3.79},166.76,4.99,219.56]
[47,227868,{"$f":"VLOOKUP(B56,TAB.REF!$A$3:$D$140,2)","v":"CONETOR CUNHA CU ITEM 2"},{"$f":"VLOOKUP(B56,TAB.REF!$A$3:$D$140,3)","v":"PC"},20,{"$f":"VLOOKUP(B56,TAB.REF!$A$3:$D$140,4)","v":2.81},56.2,3.7,74]
[48,231696,{"$f":"VLOOKUP(B57,TAB.REF!$A$3:$D$140,2)","v":"CONETOR CUNHA CU ITEM 6"},{"$f":"VLOOKUP(B57,TAB.REF!$A$3:$D$140,3)","v":"PC"},7,{"$f":"VLOOKUP(B57,TAB.REF!$A$3:$D$140,4)","v":4.2699999999999996},29.89,5.62,39.340000000000003]
[49,231688,{"$f":"VLOOKUP(B58,TAB.REF!$A$3:$D$140,2)","v":"CONETOR CUNHA CU ITEM 7"},{"$f":"VLOOKUP(B58,TAB.REF!$A$3:$D$140,3)","v":"PC"},15,{"$f":"VLOOKUP(B58,TAB.REF!$A$3:$D$140,4)","v":3.9},58.5,5.13,76.95]
[50,331728,{"$f":"VLOOKUP(B59,TAB.REF!$A$3:$D$140,2)","v":"CONETOR CUNHA ITEM 2 + COBERTURA ISOLANTE ITEM 2"},{"$f":"VLOOKUP(B59,TAB.REF!$A$3:$D$140,3)","v":"PC"},36,{"$f":"VLOOKUP(B59,TAB.REF!$A$3:$D$140,4)","v":3.63},130.68,4.78,172.08]
[51,327726,{"$f":"VLOOKUP(B60,TAB.REF!$A$3:$D$140,2)","v":"CONETOR DE PERFURAÇÃO 10-70MM²/6-35MM²"},{"$f":"VLOOKUP(B60,TAB.REF!$A$3:$D$140,3)","v":"PC"},46,{"$f":"VLOOKUP(B60,TAB.REF!$A$3:$D$140,4)","v":8.25},379.5,10.85,499.1]
[52,379679,{"$f":"VLOOKUP(B61,TAB.REF!$A$3:$D$140,2)","v":"CONETOR DE PERFURAÇÃO 35-120MM²/1,5MM²"},{"$f":"VLOOKUP(B61,TAB.REF!$A$3:$D$140,3)","v":"PC"},26,{"$f":"VLOOKUP(B61,TAB.REF!$A$3:$D$140,4)","v":5.98},155.47999999999999,7.87,204.62]
[53,327767,{"$f":"VLOOKUP(B62,TAB.REF!$A$3:$D$140,2)","v":"CONETOR DE PERFURAÇÃO 70-240MM²/70-120MM²"},{"$f":"VLOOKUP(B62,TAB.REF!$A$3:$D$140,3)","v":"PC"},10,{"$f":"VLOOKUP(B62,TAB.REF!$A$3:$D$140,4)","v":16},160,21.05,210.5]
[54,227769,{"$f":"VLOOKUP(B63,TAB.REF!$A$3:$D$140,2)","v":"CONETOR FORMATO H ITEM 1 CAA 13-34MM² / 13-34MM²"},{"$f":"VLOOKUP(B63,TAB.REF!$A$3:$D$140,3)","v":"PC"},5,{"$f":"VLOOKUP(B63,TAB.REF!$A$3:$D$140,4)","v":2.25},11.25,2.96,14.8]
[55,227777,{"$f":"VLOOKUP(B64,TAB.REF!$A$3:$D$140,2)","v":"CONETOR FORMATO H ITEM 2 CAA 27-54MM² / 13-34MM²"},{"$f":"VLOOKUP(B64,TAB.REF!$A$3:$D$140,3)","v":"PC"},45,{"$f":"VLOOKUP(B64,TAB.REF!$A$3:$D$140,4)","v":2.71},121.95,3.57,160.65]
[56,227785,{"$f":"VLOOKUP(B65,TAB.REF!$A$3:$D$140,2)","v":"CONETOR FORMATO H ITEM 3 CAA 42-67MM² / 42-67MM²"},{"$f":"VLOOKUP(B65,TAB.REF!$A$3:$D$140,3)","v":"PC"},43,{"$f":"VLOOKUP(B65,TAB.REF!$A$3:$D$140,4)","v":4.7699999999999996},205.11,6.28,270.04000000000002]
[57,231175,{"$f":"VLOOKUP(B66,TAB.REF!$A$3:$D$140,2)","v":"CONETOR PARA ATERRAMENTO DE FERRAGENS DE IP"},{"$f":"VLOOKUP(B66,TAB.REF!$A$3:$D$140,3)","v":"PC"},26,{"$f":"VLOOKUP(B66,TAB.REF!$A$3:$D$140,4)","v":1.3},33.799999999999997,1.71,44.46]
[58,377357,{"$f":"VLOOKUP(B67,TAB.REF!$A$3:$D$140,2)","v":"CONETOR TERMINAL ATERRAMENTO TEMPORÁRIO DE CHAVE"},{"$f":"VLOOKUP(B67,TAB.REF!$A$3:$D$140,3)","v":"PC"},4,{"$f":"VLOOKUP(B67,TAB.REF!$A$3:$D$140,4)","v":8.6300000000000008},{"$f":"ROUND(F67*E67,2)","v":34.520000000000003},{"$f":"ROUND(F67*(1+$I$6),2)","v":11.35},{"$f":"ROUND(H67*E67,2)","v":45.4}]
[59,227066,{"$f":"VLOOKUP(B68,TAB.REF!$A$3:$D$140,2)","v":"CONETOR TERMINAL COMP CA/CAA 54MM² / 70MM² COMPACT"},{"$f":"VLOOKUP(B68,TAB.REF!$A$3:$D$140,3)","v":"PC"},4,{"$f":"VLOOKUP(B68,TAB.REF!$A$3:$D$140,4)","v":5.48},21.92,7.21,28.84]
[60,338731,{"$f":"VLOOKUP(B69,TAB.REF!$A$3:$D$140,2)","v":"CONETOR TERMINAL COMPRESSÃO 16MM²"},{"$f":"VLOOKUP(B69,TAB.REF!$A$3:$D$140,3)","v":"PC"},3,{"$f":"VLOOKUP(B69,TAB.REF!$A$3:$D$140,4)","v":2.12},6.36,2.79,8.3699999999999992]
[61,231886,{"$f":"VLOOKUP(B70,TAB.REF!$A$3:$D$140,2)","v":"CONETOR TERMINAL COMPRESSÃO 1F 50MM²"},{"$f":"VLOOKUP(B70,TAB.REF!$A$3:$D$140,3)","v":"PC"},18,{"$f":"VLOOKUP(B70,TAB.REF!$A$3:$D$140,4)","v":1.92},34.56,2.5299999999999998,45.54]
[62,227389,{"$f":"VLOOKUP(B71,TAB.REF!$A$3:$D$140,2)","v":"CONETOR TERMINAL COMPRESSÃO 1F AÇO 6,4MM / 21MM²"},{"$f":"VLOOKUP(B71,TAB.REF!$A$3:$D$140,3)","v":"PC"},32,{"$f":"VLOOKUP(B71,TAB.REF!$A$3:$D$140,4)","v":2.0699999999999998},66.239999999999995,2.72,87.04]
[63,377705,{"$f":"VLOOKUP(B72,TAB.REF!$A$3:$D$140,2)","v":"CRUZETA DE FIBRA DE VIDRO 2400X112,5X90MM"},{"$f":"VLOOKUP(B72,TAB.REF!$A$3:$D$140,3)","v":"PC"},9,{"$f":"VLOOKUP(B72,TAB.REF!$A$3:$D$140,4)","v":210.26},1892.34,276.62,2489.58]
[64,271353,{"$f":"VLOOKUP(B73,TAB.REF!$A$3:$D$140,2)","v":"ELO FUSÍVEL BOTÃO 500MM 3H"},{"$f":"VLOOKUP(B73,TAB.REF!$A$3:$D$140,3)","v":"PC"},3,{"$f":"VLOOKUP(B73,TAB.REF!$A$3:$D$140,4)","v":4.3},12.9,5.66,16.98]
[65,231662,{"$f":"VLOOKUP(B74,TAB.REF!$A$3:$D$140,2)","v":"ESPAÇADOR LOSANGULAR 50-150MM² 15KV"},{"$f":"VLOOKUP(B74,TAB.REF!$A$3:$D$140,3)","v":"CJ"},31,{"$f":"VLOOKUP(B74,TAB.REF!$A$3:$D$140,4)","v":21.82},676.42,28.71,890.01]
[66,328120,{"$f":"VLOOKUP(B75,TAB.REF!$A$3:$D$140,2)","v":"ESTRIBO PARA BRAÇO TIPO L PARA RDAP"},{"$f":"VLOOKUP(B75,TAB.REF!$A$3:$D$140,3)","v":"PC"},7,{"$f":"VLOOKUP(B75,TAB.REF!$A$3:$D$140,4)","v":10.94},76.58,14.39,100.73]
[67,357342,{"$f":"VLOOKUP(B76,TAB.REF!$A$3:$D$140,2)","v":"FIO PARA AMARRAÇÃO ALUMÍNIO RECOZIDO 5,2MM (4AWG)"},{"$f":"VLOOKUP(B76,TAB.REF!$A$3:$D$140,3)","v":"KG"},0.16,{"$f":"VLOOKUP(B76,TAB.REF!$A$3:$D$140,4)","v":31.05},4.97,40.85,6.54]
[68,234567,{"$f":"VLOOKUP(B77,TAB.REF!$A$3:$D$140,2)","v":"GRAMPO ANCORAGEM PARA CABO 50MM² 15KV"},{"$f":"VLOOKUP(B77,TAB.REF!$A$3:$D$140,3)","v":"PC"},21,{"$f":"VLOOKUP(B77,TAB.REF!$A$3:$D$140,4)","v":20.12},422.52,26.47,555.87]
[69,378842,{"$f":"VLOOKUP(B78,TAB.REF!$A$3:$D$140,2)","v":"GRAMPO DE LINHA VIVA"},{"$f":"VLOOKUP(B78,TAB.REF!$A$3:$D$140,3)","v":"PC"},12,{"$f":"VLOOKUP(B78,TAB.REF!$A$3:$D$140,4)","v":57.96},695.52,76.25,915]
[70,222539,{"$f":"VLOOKUP(B79,TAB.REF!$A$3:$D$140,2)","v":"HASTE ATERRAMENTO 2400MM"},{"$f":"VLOOKUP(B79,TAB.REF!$A$3:$D$140,3)","v":"PC"},17,{"$f":"VLOOKUP(B79,TAB.REF!$A$3:$D$140,4)","v":40.75},692.75,53.61,911.37]
[71,219659,{"$f":"VLOOKUP(B80,TAB.REF!$A$3:$D$140,2)","v":"ISOLADOR DE ANCORAGEM POLIMÉRICO 15KV ITEM 1"},{"$f":"VLOOKUP(B80,TAB.REF!$A$3:$D$140,3)","v":"PC"},37,{"$f":"VLOOKUP(B80,TAB.REF!$A$3:$D$140,4)","v":41.77},1545.49,54.95,2033.15]
[72,375718,{"$f":"VLOOKUP(B81,TAB.REF!$A$3:$D$140,2)","v":"ISOLADOR PILAR PORCELANA 15KV"},{"$f":"VLOOKUP(B81,TAB.REF!$A$3:$D$140,3)","v":"PC"},3,{"$f":"VLOOKUP(B81,TAB.REF!$A$3:$D$140,4)","v":57.98},173.94,76.28,228.84]
[73,219642,{"$f":"VLOOKUP(B82,TAB.REF!$A$3:$D$140,2)","v":"ISOLADOR PINO POLIMÉRICO 15 KV P/BRAÇO SUPORTE C"},{"$f":"VLOOKUP(B82,TAB.REF!$A$3:$D$140,3)","v":"PC"},10,{"$f":"VLOOKUP(B82,TAB.REF!$A$3:$D$140,4)","v":20.079999999999998},200.8,26.42,264.2]
[74,219634,{"$f":"VLOOKUP(B83,TAB.REF!$A$3:$D$140,2)","v":"ISOLADOR ROLDANA PORCELANA OU VIDRO"},{"$f":"VLOOKUP(B83,TAB.REF!$A$3:$D$140,3)","v":"PC"},3,{"$f":"VLOOKUP(B83,TAB.REF!$A$3:$D$140,4)","v":5.42},16.260000000000002,7.13,21.39]
[75,230367,{"$f":"VLOOKUP(B84,TAB.REF!$A$3:$D$140,2)","v":"LAÇO PREFORMADO DE TOPO CA/CAA 34MM² (2AWG)"},{"$f":"VLOOKUP(B84,TAB.REF!$A$3:$D$140,3)","v":"PC"},3,{"$f":"VLOOKUP(B84,TAB.REF!$A$3:$D$140,4)","v":3.52},10.56,4.63,13.89]
[76,120,{"$f":"VLOOKUP(B85,TAB.REF!$A$3:$D$140,2)","v":"LUMINARIA LED POTÊNCIA ATÉ 120W FLUXO LUMINOSO APROXIMADO 13.800lm EFICIENCIA LUMINOSA ≥ 115lm/w"},{"$f":"VLOOKUP(B85,TAB.REF!$A$3:$D$140,3)","v":"PC"},9,{"$f":"VLOOKUP(B85,TAB.REF!$A$3:$D$140,4)","v":767},6903,1009.07,9081.6299999999992]
[77,237271,{"$f":"VLOOKUP(B86,TAB.REF!$A$3:$D$140,2)","v":"MANILHA SAPATILHA CLASSE 50KN"},{"$f":"VLOOKUP(B86,TAB.REF!$A$3:$D$140,3)","v":"PC"},39,{"$f":"VLOOKUP(B86,TAB.REF!$A$3:$D$140,4)","v":10.91},425.49,14.35,559.65]
[78,374393,{"$f":"VLOOKUP(B87,TAB.REF!$A$3:$D$140,2)","v":"MANTA AUTO-ADESIVA PARA EMENDA CABO 15KV RDP"},{"$f":"VLOOKUP(B87,TAB.REF!$A$3:$D$140,3)","v":"PC"},12,{"$f":"VLOOKUP(B87,TAB.REF!$A$3:$D$140,4)","v":66.28},795.36,87.2,1046.4000000000001]
[79,237784,{"$f":"VLOOKUP(B88,TAB.REF!$A$3:$D$140,2)","v":"MÃO-FRANCESA PERFILADA NORMAL 38X5X726MM"},{"$f":"VLOOKUP(B88,TAB.REF!$A$3:$D$140,3)","v":"PC"},9,{"$f":"VLOOKUP(B88,TAB.REF!$A$3:$D$140,4)","v":22.64},203.76,29.79,268.11]
[80,82586,{"$f":"VLOOKUP(B89,TAB.REF!$A$3:$D$140,2)","v":"MASSA CALAFETAR 1KG"},{"$f":"VLOOKUP(B89,TAB.REF!$A$3:$D$140,3)","v":"KG"},0.2,{"$f":"VLOOKUP(B89,TAB.REF!$A$3:$D$140,4)","v":16.78},3.36,22.08,4.42]
[81,237289,{"$f":"VLOOKUP(B90,TAB.REF!$A$3:$D$140,2)","v":"OLHAL PARA PARAFUSO 50KN"},{"$f":"VLOOKUP(B90,TAB.REF!$A$3:$D$140,3)","v":"PC"},79,{"$f":"VLOOKUP(B90,TAB.REF!$A$3:$D$140,4)","v":16.760000000000002},1324.04,22.05,1741.95]
[82,66878,{"$f":"VLOOKUP(B91,TAB.REF!$A$3:$D$140,2)","v":"PARAFUSO CABEÇA ABAULADA M16X 45MM"},{"$f":"VLOOKUP(B91,TAB.REF!$A$3:$D$140,3)","v":"PC"},105,{"$f":"VLOOKUP(B91,TAB.REF!$A$3:$D$140,4)","v":2.17},227.85,2.85,299.25]
[83,66886,{"$f":"VLOOKUP(B92,TAB.REF!$A$3:$D$140,2)","v":"PARAFUSO CABEÇA ABAULADA M16X 70MM"},{"$f":"VLOOKUP(B92,TAB.REF!$A$3:$D$140,3)","v":"PC"},266,{"$f":"VLOOKUP(B92,TAB.REF!$A$3:$D$140,4)","v":2.64},702.24,3.47,923.02]
[84,66894,{"$f":"VLOOKUP(B93,TAB.REF!$A$3:$D$140,2)","v":"PARAFUSO CABEÇA ABAULADA M16X150MM"},{"$f":"VLOOKUP(B93,TAB.REF!$A$3:$D$140,3)","v":"PC"},9,{"$f":"VLOOKUP(B93,TAB.REF!$A$3:$D$140,4)","v":4.3},38.700000000000003,5.66,50.94]
[85,74807,{"$f":"VLOOKUP(B94,TAB.REF!$A$3:$D$140,2)","v":"PARAFUSO CABEÇA QUADRADA M16X150MM"},{"$f":"VLOOKUP(B94,TAB.REF!$A$3:$D$140,3)","v":"PC"},9,{"$f":"VLOOKUP(B94,TAB.REF!$A$3:$D$140,4)","v":4.37},39.33,5.75,51.75]
[86,74872,{"$f":"VLOOKUP(B95,TAB.REF!$A$3:$D$140,2)","v":"PARAFUSO CABEÇA QUADRADA M16X500MM"},{"$f":"VLOOKUP(B95,TAB.REF!$A$3:$D$140,3)","v":"PC"},14,{"$f":"VLOOKUP(B95,TAB.REF!$A$3:$D$140,4)","v":11.41},159.74,15.01,210.14]
[87,75036,{"$f":"VLOOKUP(B96,TAB.REF!$A$3:$D$140,2)","v":"PARAFUSO CABEÇA SEXTAVADA M12X 40MM"},{"$f":"VLOOKUP(B96,TAB.REF!$A$3:$D$140,3)","v":"PC"},8,{"$f":"VLOOKUP(B96,TAB.REF!$A$3:$D$140,4)","v":12.44},99.52,16.37,130.96]
[88,289058,{"$f":"VLOOKUP(B97,TAB.REF!$A$3:$D$140,2)","v":"PÁRA-RAIOS 12KV 10KA ZNO"},{"$f":"VLOOKUP(B97,TAB.REF!$A$3:$D$140,3)","v":"PC"},15,{"$f":"VLOOKUP(B97,TAB.REF!$A$3:$D$140,4)","v":153.69},{"$f":"ROUND(F97*E97,2)","v":2305.35},{"$f":"ROUND(F97*(1+$I$6),2)","v":202.19},{"$f":"ROUND(H97*E97,2)","v":3032.85}]
[89,293357,{"$f":"VLOOKUP(B98,TAB.REF!$A$3:$D$140,2)","v":"PÁRA-RAIOS REDE SECUNDÁRIA ISOLADA 280V 10KA"},{"$f":"VLOOKUP(B98,TAB.REF!$A$3:$D$140,3)","v":"PC"},3,{"$f":"VLOOKUP(B98,TAB.REF!$A$3:$D$140,4)","v":59.64},178.92,78.459999999999994,235.38]
[90,236265,{"$f":"VLOOKUP(B99,TAB.REF!$A$3:$D$140,2)","v":"PINO P/ ISOLADOR POLIMÉRICO ATÉ 36,2 KV - BRAÇO C"},{"$f":"VLOOKUP(B99,TAB.REF!$A$3:$D$140,3)","v":"PC"},4,{"$f":"VLOOKUP(B99,TAB.REF!$A$3:$D$140,4)","v":15.35},61.4,20.190000000000001,80.760000000000005]
[91,375720,{"$f":"VLOOKUP(B100,TAB.REF!$A$3:$D$140,2)","v":"PINO PARA ISOLADOR PILAR"},{"$f":"VLOOKUP(B100,TAB.REF!$A$3:$D$140,3)","v":"PC"},3,{"$f":"VLOOKUP(B100,TAB.REF!$A$3:$D$140,4)","v":7.03},21.09,9.25,27.75]
[92,75630,{"$f":"VLOOKUP(B101,TAB.REF!$A$3:$D$140,2)","v":"PORCA QUADRADA M16 24X24X13MM"},{"$f":"VLOOKUP(B101,TAB.REF!$A$3:$D$140,3)","v":"PC"},34,{"$f":"VLOOKUP(B101,TAB.REF!$A$3:$D$140,4)","v":0.68},23.12,0.89,30.26]
[93,207415,{"$f":"VLOOKUP(B102,TAB.REF!$A$3:$D$140,2)","v":"POSTE CONCRETO CIRCULAR 11M 300DAN"},{"$f":"VLOOKUP(B102,TAB.REF!$A$3:$D$140,3)","v":"PC"},7,{"$f":"VLOOKUP(B102,TAB.REF!$A$3:$D$140,4)","v":695.96},4871.72,915.6,6409.2]
[94,207449,{"$f":"VLOOKUP(B103,TAB.REF!$A$3:$D$140,2)","v":"POSTE CONCRETO CIRCULAR 11M 600DAN"},{"$f":"VLOOKUP(B103,TAB.REF!$A$3:$D$140,3)","v":"PC"},2,{"$f":"VLOOKUP(B103,TAB.REF!$A$3:$D$140,4)","v":951.41},1902.82,1251.67,2503.34]
[95,207522,{"$f":"VLOOKUP(B104,TAB.REF!$A$3:$D$140,2)","v":"POSTE CONCRETO CIRCULAR 12M 300DAN"},{"$f":"VLOOKUP(B104,TAB.REF!$A$3:$D$140,3)","v":"PC"},1,{"$f":"VLOOKUP(B104,TAB.REF!$A$3:$D$140,4)","v":765.08},765.08,1006.54,1006.54]
[96,207506,{"$f":"VLOOKUP(B105,TAB.REF!$A$3:$D$140,2)","v":"POSTE CONCRETO CIRCULAR 12M 600DAN"},{"$f":"VLOOKUP(B105,TAB.REF!$A$3:$D$140,3)","v":"PC"},2,{"$f":"VLOOKUP(B105,TAB.REF!$A$3:$D$140,4)","v":1118.3499999999999},2236.6999999999998,1471.3,2942.6]
[97,207514,{"$f":"VLOOKUP(B106,TAB.REF!$A$3:$D$140,2)","v":"POSTE CONCRETO CIRCULAR 12M1000DAN"},{"$f":"VLOOKUP(B106,TAB.REF!$A$3:$D$140,3)","v":"PC"},1,{"$f":"VLOOKUP(B106,TAB.REF!$A$3:$D$140,4)","v":1597.78},1597.78,2102.04,2102.04]
[98,327361,{"$f":"VLOOKUP(B107,TAB.REF!$A$3:$D$140,2)","v":"RELÉ FOTOELÉTRICO ELETRÔNICO 105-305V"},{"$f":"VLOOKUP(B107,TAB.REF!$A$3:$D$140,3)","v":"PC"},9,{"$f":"VLOOKUP(B107,TAB.REF!$A$3:$D$140,4)","v":19.100000000000001},171.9,25.13,226.17]
[99,237768,{"$f":"VLOOKUP(B108,TAB.REF!$A$3:$D$140,2)","v":"SAPATILHA"},{"$f":"VLOOKUP(B108,TAB.REF!$A$3:$D$140,3)","v":"PC"},25,{"$f":"VLOOKUP(B108,TAB.REF!$A$3:$D$140,4)","v":1.99},49.75,2.62,65.5]
[100,237156,{"$f":"VLOOKUP(B109,TAB.REF!$A$3:$D$140,2)","v":"SELA PARA CRUZETA"},{"$f":"VLOOKUP(B109,TAB.REF!$A$3:$D$140,3)","v":"PC"},9,{"$f":"VLOOKUP(B109,TAB.REF!$A$3:$D$140,4)","v":8.8800000000000008},79.92,11.68,105.12]
[101,237081,{"$f":"VLOOKUP(B110,TAB.REF!$A$3:$D$140,2)","v":"SUPORTE 240MM TRANSFORMADOR POSTE CC"},{"$f":"VLOOKUP(B110,TAB.REF!$A$3:$D$140,3)","v":"PC"},2,{"$f":"VLOOKUP(B110,TAB.REF!$A$3:$D$140,4)","v":104.81},209.62,137.88999999999999,275.77999999999997]
[102,237776,{"$f":"VLOOKUP(B111,TAB.REF!$A$3:$D$140,2)","v":"SUPORTE L DE TOPO DE POSTE ITEM 1"},{"$f":"VLOOKUP(B111,TAB.REF!$A$3:$D$140,3)","v":"PC"},1,{"$f":"VLOOKUP(B111,TAB.REF!$A$3:$D$140,4)","v":32.39},32.39,42.61,42.61]
[103,237172,{"$f":"VLOOKUP(B112,TAB.REF!$A$3:$D$140,2)","v":"SUPORTE L PARA CRUZETA"},{"$f":"VLOOKUP(B112,TAB.REF!$A$3:$D$140,3)","v":"PC"},15,{"$f":"VLOOKUP(B112,TAB.REF!$A$3:$D$140,4)","v":25.98},389.7,34.18,512.70000000000005]
[104,245837,{"$f":"VLOOKUP(B113,TAB.REF!$A$3:$D$140,2)","v":"TRANSFORMADOR TRIFÁSICO 15KV 45KVA"},{"$f":"VLOOKUP(B113,TAB.REF!$A$3:$D$140,3)","v":"PC"},1,{"$f":"VLOOKUP(B113,TAB.REF!$A$3:$D$140,4)","v":5284},5284,6951.63,6951.63]
[" VALOR TOTAL MATERIAIS",null,null,null,null,{"$f":"ROUND(SUM(G10:G113),2)","v":63161.08},null,{"$f":"ROUND(SUM(I10:I113),2)","v":83096.259999999995}]
["MÃO DE OBRA DE CONSTRUÇÃO",null,null,null,null,"PREÇO SEM BDI",null,"PREÇO COM BDI"]
["ITEM","CÓDIGO","DESCRIÇÃO","UN","QUANT.","R$.UNIT.","R$. TOTAL","R$.UNIT.","R$. TOTAL"]
[1,"US. CONST. RDA",{"$f":"VLOOKUP(B117,TAB.REF!$A$2:$D$140,2)","v":"MÃO DE OBRA DE CONSTRUÇÃO DE REDE ELÉTRICA"},"US",18.850000000000001,{"$f":"VLOOKUP(B117,TAB.REF!$A$2:$D$140,4)","v":1538.3},{"$f":"ROUND(E117*F117,2)","v":28996.959999999999},{"$f":"F117*(1+$I$6)","v":2023.79},{"$f":"ROUND(H117*E117,2)","v":38148.44}]
[2,"US. CONST. RDS",{"$f":"VLOOKUP(B118,TAB.REF!$A$2:$D$140,2)","v":"MÃO DE OBRA DE CONSTRUÇÃO DE REDE SUBTERRÂNEA"},"US",null,{"$f":"VLOOKUP(B118,TAB.REF!$A$2:$D$140,4)","v":1538.3},{"$f":"ROUND(E118*F118,2)","v":0},{"$f":"F118*(1+$I$6)","v":2023.79},{"$f":"ROUND(H118*E118,2)","v":0}]
[" VALOR TOTAL MÃO DE OBRA",null,null,null,null,{"$f":"SUM(G117:G118)","v":28996.959999999999},null,{"$f":"SUM(I117:I118)","v":38148.44}]
["RESUMO",null,null,null,null,"PREÇO SEM BDI",null,"PREÇO COM BDI"]
[" VALOR TOTAL MATERIAIS",null,null,null,null,{"$f":"ROUND(F114,2)","v":63161.08},null,{"$f":"ROUND(H114,2)","v":83096.259999999995}]
[" VALOR TOTAL MÃO DE OBRA",null,null,null,null,{"$f":"ROUND(F119,2)","v":28996.959999999999},null,{"$f":"H119","v":38148.44}]
[" VALOR TOTAL",null,null,null,null,{"$f":"ROUND(SUM(F121:G122),2)","v":92158.04},null,{"$f":"SUM(H121:I122)","v":121244.7}]
[]
[]
[{"$f":"CONCATENATE(RESUMO!B18,\" \",RESUMO!C18)","v":"Patos de Minas, 4 de fevereiro de 2020"}]
[]
[]
["_______________________________________________________"]
[{"$f":"RESUMO!B21","v":"Diogo Soares Resende"}]
[{"$f":"RESUMO!B22","v":"Eng. Eletricista"}]
[{"$f":"RESUMO!B23","v":"CREA: 194.419D/MG"}]

{"sheet":"CVCTEC-84","index":8,"n_rows":99,"n_cols":9,"rows_kept":99,"cut":false,"hidden":false,"merged":[[96,0,96,8],[97,0,97,8],[98,0,98,8],[89,0,89,4],[89,5,89,6],[89,7,89,8],[92,0,92,8],[94,0,94,6],[95,0,95,8],[87,0,87,4],[87,5,87,6],[87,7,87,8],[88,0,88,4],[88,5,88,6],[88,7,88,8],[85,0,85,4],[85,5,85,6],[85,7,85,8],[86,0,86,4],[86,5,86,6],[86,7,86,8],[80,0,80,4],[80,5,80,6],[80,7,80,8],[81,0,81,4],[81,5,81,6],[81,7,81,8],[5,0,5,4],[6,0,6,8],[7,0,8,0],[7,1,8,1],[7,2,8,2],[7,3,8,3],[7,4,8,4],[7,5,7,6],[7,7,7,8],[0,0,0,8],[1,0,1,8],[2,0,2,8],[3,0,3,8],[4,0,4,4]]}
[]
["PLANILHA ORÇAMENTÁRIA "]
["OBJETO: PROJETOS DE MODIFICAÇÃO, EXTENSÃO DE REDE  E ILUMINAÇÃO PÚBLICA"]
["LOCAL: CVCTEC_PMINAS_84 - RUA SAGITÁRIO - JARDIM PELUZZO"]
["RESPONSÁVEL TÉCNICO: DIOGO SOARES RESENDE",null,null,null,null,"CREA:",{"$f":"LEFT(RIGHT(RESUMO!B23,11),8)","v":"194.419D"},"ART:"]
["REFERENCIA DE PREÇOS: PREÇOS DE MERCADO",null,null,null,null,"DATA: ",{"$f":"RESUMO!E5","v":"2020-02-04"},"BDI :",{"$f":"RESUMO!F5","v":0.31559999999999999}]
[]
["ITEM","CÓDIGO ","DESCRIÇÃO","UNID.","QUANT.","PREÇO SEM BDI",null,"PREÇO COM BDI"]
[null,null,null,null,null,"UNITÁRIO ","TOTAL","UNITÁRIO ","TOTAL"]
[1,237222,{"$f":"VLOOKUP(B10,TAB.REF!$A$3:$D$140,2)","v":"AFASTADOR ARMAÇÃO SECUNDÁRIA 500MM"},{"$f":"VLOOKUP(B10,TAB.REF!$A$3:$D$140,3)","v":"PC"},1,{"$f":"VLOOKUP(B10,TAB.REF!$A$3:$D$140,4)","v":124.8},{"$f":"ROUND(F10*E10,2)","v":124.8},{"$f":"ROUND(F10*(1+$I$6),2)","v":164.19},{"$f":"ROUND(H10*E10,2)","v":164.19}]
[2,229005,{"$f":"VLOOKUP(B11,TAB.REF!$A$3:$D$140,2)","v":"ALÇA PREFORMADA NEUTRO CA/CAL 70MM²"},{"$f":"VLOOKUP(B11,TAB.REF!$A$3:$D$140,3)","v":"PC"},4,{"$f":"VLOOKUP(B11,TAB.REF!$A$3:$D$140,4)","v":6.03},24.12,7.93,31.72]
[3,237677,{"$f":"VLOOKUP(B12,TAB.REF!$A$3:$D$140,2)","v":"ALÇA PREFORMADA ESTAI CABO AÇO 9,5MM"},{"$f":"VLOOKUP(B12,TAB.REF!$A$3:$D$140,3)","v":"PC"},6,{"$f":"VLOOKUP(B12,TAB.REF!$A$3:$D$140,4)","v":12.24},73.44,16.100000000000001,96.6]
[4,327700,{"$f":"VLOOKUP(B13,TAB.REF!$A$3:$D$140,2)","v":"ANEL ELASTOMÉRICO P/ ISOLADOR PINO POLIMÉRICO 15KV"},{"$f":"VLOOKUP(B13,TAB.REF!$A$3:$D$140,3)","v":"PC"},6,{"$f":"VLOOKUP(B13,TAB.REF!$A$3:$D$140,4)","v":4.29},25.74,5.64,33.840000000000003]
[5,327692,{"$f":"VLOOKUP(B14,TAB.REF!$A$3:$D$140,2)","v":"BRAÇADEIRA PLÁSTICA CABO MULTIPLEXADO"},{"$f":"VLOOKUP(B14,TAB.REF!$A$3:$D$140,3)","v":"PC"},9,{"$f":"VLOOKUP(B14,TAB.REF!$A$3:$D$140,4)","v":1.1499999999999999},10.35,1.51,13.59]
[6,231712,{"$f":"VLOOKUP(B15,TAB.REF!$A$3:$D$140,2)","v":"BRAÇO SUPORTE COM GRAMPO DE SUSPENSÃO ITEM 2"},{"$f":"VLOOKUP(B15,TAB.REF!$A$3:$D$140,3)","v":"CJ"},2,{"$f":"VLOOKUP(B15,TAB.REF!$A$3:$D$140,4)","v":38.380000000000003},76.760000000000005,50.49,100.98]
[7,211789,{"$f":"VLOOKUP(B16,TAB.REF!$A$3:$D$140,2)","v":"BRAÇO SUPORTE C"},{"$f":"VLOOKUP(B16,TAB.REF!$A$3:$D$140,3)","v":"PC"},4,{"$f":"VLOOKUP(B16,TAB.REF!$A$3:$D$140,4)","v":92.79},371.16,122.07,488.28]
[8,223818,{"$f":"VLOOKUP(B17,TAB.REF!$A$3:$D$140,2)","v":"CANTONEIRA PARA BRAÇO C"},{"$f":"VLOOKUP(B17,TAB.REF!$A$3:$D$140,3)","v":"PC"},2,{"$f":"VLOOKUP(B17,TAB.REF!$A$3:$D$140,4)","v":60.9},121.8,80.12,160.24]
[9,231878,{"$f":"VLOOKUP(B18,TAB.REF!$A$3:$D$140,2)","v":"CARTUCHO DE APLICAÇÃO VERMELHO"},{"$f":"VLOOKUP(B18,TAB.REF!$A$3:$D$140,3)","v":"PC"},6,{"$f":"VLOOKUP(B18,TAB.REF!$A$3:$D$140,4)","v":6.54},39.24,8.6,51.6]
[10,2964,{"$f":"VLOOKUP(B19,TAB.REF!$A$3:$D$140,2)","v":"CABO DE AÇO HS 3/8P (9,5MM²) 7FIOS"},{"$f":"VLOOKUP(B19,TAB.REF!$A$3:$D$140,3)","v":"KG"},26.8,{"$f":"VLOOKUP(B19,TAB.REF!$A$3:$D$140,4)","v":7.78},208.5,10.24,274.43]
[11,2931,{"$f":"VLOOKUP(B20,TAB.REF!$A$3:$D$140,2)","v":"CABO DE AÇO MR 1/4P (6,4MM) 7 FIOS"},{"$f":"VLOOKUP(B20,TAB.REF!$A$3:$D$140,3)","v":"KG"},4.5,{"$f":"VLOOKUP(B20,TAB.REF!$A$3:$D$140,4)","v":2.76},12.42,3.63,16.34]
[12,225623,{"$f":"VLOOKUP(B21,TAB.REF!$A$3:$D$140,2)","v":"CABO AL 1X 16MM² 1KV"},{"$f":"VLOOKUP(B21,TAB.REF!$A$3:$D$140,3)","v":"M"},3,{"$f":"VLOOKUP(B21,TAB.REF!$A$3:$D$140,4)","v":1.85},5.55,2.4300000000000002,7.29]
[13,231548,{"$f":"VLOOKUP(B22,TAB.REF!$A$3:$D$140,2)","v":"CABO AL 1X 50MM² 15KV PROTEGIDO"},{"$f":"VLOOKUP(B22,TAB.REF!$A$3:$D$140,3)","v":"M"},206.5,{"$f":"VLOOKUP(B22,TAB.REF!$A$3:$D$140,4)","v":7.15},1476.48,9.41,1943.17]
[14,225656,{"$f":"VLOOKUP(B23,TAB.REF!$A$3:$D$140,2)","v":"CABO AL 1X 70MM² 1KV"},{"$f":"VLOOKUP(B23,TAB.REF!$A$3:$D$140,3)","v":"M"},6,{"$f":"VLOOKUP(B23,TAB.REF!$A$3:$D$140,4)","v":6.53},39.18,8.59,51.54]
[15,270439,{"$f":"VLOOKUP(B24,TAB.REF!$A$3:$D$140,2)","v":"CHAVE FUSÍVEL 15KV COM PORTA FUSÍVEL 100A 7,1KA"},{"$f":"VLOOKUP(B24,TAB.REF!$A$3:$D$140,3)","v":"PC"},3,{"$f":"VLOOKUP(B24,TAB.REF!$A$3:$D$140,4)","v":243.45},730.35,320.27999999999997,960.84]
[16,236802,{"$f":"VLOOKUP(B25,TAB.REF!$A$3:$D$140,2)","v":"PINO P/ ISOLADOR POLIMÉRICO ATÉ 36,2 KV - BRAÇO C"},{"$f":"VLOOKUP(B25,TAB.REF!$A$3:$D$140,3)","v":"PC"},1,{"$f":"VLOOKUP(B25,TAB.REF!$A$3:$D$140,4)","v":15.35},15.35,20.190000000000001,20.190000000000001]
[17,236810,{"$f":"VLOOKUP(B26,TAB.REF!$A$3:$D$140,2)","v":"PINO P/ ISOLADOR POLIMÉRICO ATÉ 36,2 KV - BRAÇO C"},{"$f":"VLOOKUP(B26,TAB.REF!$A$3:$D$140,3)","v":"PC"},1,{"$f":"VLOOKUP(B26,TAB.REF!$A$3:$D$140,4)","v":15.35},{"$f":"ROUND(F26*E26,2)","v":15.35},{"$f":"ROUND(F26*(1+$I$6),2)","v":20.190000000000001},{"$f":"ROUND(H26*E26,2)","v":20.190000000000001}]
[18,236851,{"$f":"VLOOKUP(B27,TAB.REF!$A$3:$D$140,2)","v":"CINTA DE AÇO D 190MM"},{"$f":"VLOOKUP(B27,TAB.REF!$A$3:$D$140,3)","v":"PC"},3,{"$f":"VLOOKUP(B27,TAB.REF!$A$3:$D$140,4)","v":17.48},{"$f":"ROUND(F27*E27,2)","v":52.44},{"$f":"ROUND(F27*(1+$I$6),2)","v":23},{"$f":"ROUND(H27*E27,2)","v":69}]
[19,236869,{"$f":"VLOOKUP(B28,TAB.REF!$A$3:$D$140,2)","v":"CINTA DE AÇO D 200MM"},{"$f":"VLOOKUP(B28,TAB.REF!$A$3:$D$140,3)","v":"PC"},2,{"$f":"VLOOKUP(B28,TAB.REF!$A$3:$D$140,4)","v":17.93},35.86,23.59,47.18]
[20,236877,{"$f":"VLOOKUP(B29,TAB.REF!$A$3:$D$140,2)","v":"CINTA DE AÇO D 210MM"},{"$f":"VLOOKUP(B29,TAB.REF!$A$3:$D$140,3)","v":"PC"},3,{"$f":"VLOOKUP(B29,TAB.REF!$A$3:$D$140,4)","v":18.52},55.56,24.36,73.08]
[21,236885,{"$f":"VLOOKUP(B30,TAB.REF!$A$3:$D$140,2)","v":"CINTA DE AÇO D 220MM"},{"$f":"VLOOKUP(B30,TAB.REF!$A$3:$D$140,3)","v":"PC"},3,{"$f":"VLOOKUP(B30,TAB.REF!$A$3:$D$140,4)","v":18.66},55.98,24.55,73.650000000000006]
[22,236893,{"$f":"VLOOKUP(B31,TAB.REF!$A$3:$D$140,2)","v":"CINTA DE AÇO D 230MM"},{"$f":"VLOOKUP(B31,TAB.REF!$A$3:$D$140,3)","v":"PC"},6,{"$f":"VLOOKUP(B31,TAB.REF!$A$3:$D$140,4)","v":19.34},116.04,25.44,152.63999999999999]
[23,375058,{"$f":"VLOOKUP(B32,TAB.REF!$A$3:$D$140,2)","v":"COBERTURA PROTETORA P/ BCH BT TRANSFORMADOR ITEM 1"},{"$f":"VLOOKUP(B32,TAB.REF!$A$3:$D$140,3)","v":"PC"},4,{"$f":"VLOOKUP(B32,TAB.REF!$A$3:$D$140,4)","v":8.41},33.64,11.06,44.24]
[24,39586,{"$f":"VLOOKUP(B33,TAB.REF!$A$3:$D$140,2)","v":"COBERTURA PROTETORA PARA BUCHA DE EQUIPAMENTO"},{"$f":"VLOOKUP(B33,TAB.REF!$A$3:$D$140,3)","v":"PC"},3,{"$f":"VLOOKUP(B33,TAB.REF!$A$3:$D$140,4)","v":9.67},29.01,12.72,38.159999999999997]
[25,377357,{"$f":"VLOOKUP(B34,TAB.REF!$A$3:$D$140,2)","v":"CONETOR TERMINAL ATERRAMENTO TEMPORÁRIO DE CHAVE"},{"$f":"VLOOKUP(B34,TAB.REF!$A$3:$D$140,3)","v":"PC"},3,{"$f":"VLOOKUP(B34,TAB.REF!$A$3:$D$140,4)","v":8.6300000000000008},25.89,11.35,34.049999999999997]
[26,378809,{"$f":"VLOOKUP(B35,TAB.REF!$A$3:$D$140,2)","v":"CONECTOR TERMINAL P/ BUCHA,50 MM²,RETO,COMPRESSÃO"},{"$f":"VLOOKUP(B35,TAB.REF!$A$3:$D$140,3)","v":"PC"},3,{"$f":"VLOOKUP(B35,TAB.REF!$A$3:$D$140,4)","v":12.06},36.18,15.87,47.61]
[27,231795,{"$f":"VLOOKUP(B36,TAB.REF!$A$3:$D$140,2)","v":"CONETOR CUNHA AL 50MM² COM ESTRIBO"},{"$f":"VLOOKUP(B36,TAB.REF!$A$3:$D$140,3)","v":"PC"},6,{"$f":"VLOOKUP(B36,TAB.REF!$A$3:$D$140,4)","v":14.96},89.76,19.68,118.08]
[28,227850,{"$f":"VLOOKUP(B37,TAB.REF!$A$3:$D$140,2)","v":"CONETOR CUNHA CU ITEM 1"},{"$f":"VLOOKUP(B37,TAB.REF!$A$3:$D$140,3)","v":"PC"},3,{"$f":"VLOOKUP(B37,TAB.REF!$A$3:$D$140,4)","v":3.79},11.37,4.99,14.97]
[29,231696,{"$f":"VLOOKUP(B38,TAB.REF!$A$3:$D$140,2)","v":"CONETOR CUNHA CU ITEM 6"},{"$f":"VLOOKUP(B38,TAB.REF!$A$3:$D$140,3)","v":"PC"},1,{"$f":"VLOOKUP(B38,TAB.REF!$A$3:$D$140,4)","v":4.2699999999999996},4.2699999999999996,5.62,5.62]
[30,231688,{"$f":"VLOOKUP(B39,TAB.REF!$A$3:$D$140,2)","v":"CONETOR CUNHA CU ITEM 7"},{"$f":"VLOOKUP(B39,TAB.REF!$A$3:$D$140,3)","v":"PC"},12,{"$f":"VLOOKUP(B39,TAB.REF!$A$3:$D$140,4)","v":3.9},46.8,5.13,61.56]
[31,327767,{"$f":"VLOOKUP(B40,TAB.REF!$A$3:$D$140,2)","v":"CONETOR DE PERFURAÇÃO 70-240MM²/70-120MM²"},{"$f":"VLOOKUP(B40,TAB.REF!$A$3:$D$140,3)","v":"PC"},6,{"$f":"VLOOKUP(B40,TAB.REF!$A$3:$D$140,4)","v":16},96,21.05,126.3]
[32,227769,{"$f":"VLOOKUP(B41,TAB.REF!$A$3:$D$140,2)","v":"CONETOR FORMATO H ITEM 1 CAA 13-34MM² / 13-34MM²"},{"$f":"VLOOKUP(B41,TAB.REF!$A$3:$D$140,3)","v":"PC"},1,{"$f":"VLOOKUP(B41,TAB.REF!$A$3:$D$140,4)","v":2.25},2.25,2.96,2.96]
[33,227777,{"$f":"VLOOKUP(B42,TAB.REF!$A$3:$D$140,2)","v":"CONETOR FORMATO H ITEM 2 CAA 27-54MM² / 13-34MM²"},{"$f":"VLOOKUP(B42,TAB.REF!$A$3:$D$140,3)","v":"PC"},4,{"$f":"VLOOKUP(B42,TAB.REF!$A$3:$D$140,4)","v":2.71},10.84,3.57,14.28]
[34,227785,{"$f":"VLOOKUP(B43,TAB.REF!$A$3:$D$140,2)","v":"CONETOR FORMATO H ITEM 3 CAA 42-67MM² / 42-67MM²"},{"$f":"VLOOKUP(B43,TAB.REF!$A$3:$D$140,3)","v":"PC"},19,{"$f":"VLOOKUP(B43,TAB.REF!$A$3:$D$140,4)","v":4.7699999999999996},90.63,6.28,119.32]
[35,327726,{"$f":"VLOOKUP(B44,TAB.REF!$A$3:$D$140,2)","v":"CONETOR DE PERFURAÇÃO 10-70MM²/6-35MM²"},{"$f":"VLOOKUP(B44,TAB.REF!$A$3:$D$140,3)","v":"PC"},7,{"$f":"VLOOKUP(B44,TAB.REF!$A$3:$D$140,4)","v":8.25},57.75,10.85,75.95]
[36,231886,{"$f":"VLOOKUP(B45,TAB.REF!$A$3:$D$140,2)","v":"CONETOR TERMINAL COMPRESSÃO 1F 50MM²"},{"$f":"VLOOKUP(B45,TAB.REF!$A$3:$D$140,3)","v":"PC"},6,{"$f":"VLOOKUP(B45,TAB.REF!$A$3:$D$140,4)","v":1.92},{"$f":"ROUND(F45*E45,2)","v":11.52},{"$f":"ROUND(F45*(1+$I$6),2)","v":2.5299999999999998},{"$f":"ROUND(H45*E45,2)","v":15.18}]
[37,227066,{"$f":"VLOOKUP(B46,TAB.REF!$A$3:$D$140,2)","v":"CONETOR TERMINAL COMP CA/CAA 54MM² / 70MM² COMPACT"},{"$f":"VLOOKUP(B46,TAB.REF!$A$3:$D$140,3)","v":"PC"},4,{"$f":"VLOOKUP(B46,TAB.REF!$A$3:$D$140,4)","v":5.48},{"$f":"ROUND(F46*E46,2)","v":21.92},{"$f":"ROUND(F46*(1+$I$6),2)","v":7.21},{"$f":"ROUND(H46*E46,2)","v":28.84}]
[38,227389,{"$f":"VLOOKUP(B47,TAB.REF!$A$3:$D$140,2)","v":"CONETOR TERMINAL COMPRESSÃO 1F AÇO 6,4MM / 21MM²"},{"$f":"VLOOKUP(B47,TAB.REF!$A$3:$D$140,3)","v":"PC"},6,{"$f":"VLOOKUP(B47,TAB.REF!$A$3:$D$140,4)","v":2.0699999999999998},12.42,2.72,16.32]
[39,338731,{"$f":"VLOOKUP(B48,TAB.REF!$A$3:$D$140,2)","v":"CONETOR TERMINAL COMPRESSÃO 16MM²"},{"$f":"VLOOKUP(B48,TAB.REF!$A$3:$D$140,3)","v":"PC"},3,{"$f":"VLOOKUP(B48,TAB.REF!$A$3:$D$140,4)","v":2.12},6.36,2.79,8.3699999999999992]
[40,271353,{"$f":"VLOOKUP(B49,TAB.REF!$A$3:$D$140,2)","v":"ELO FUSÍVEL BOTÃO 500MM 3H"},{"$f":"VLOOKUP(B49,TAB.REF!$A$3:$D$140,3)","v":"PC"},3,{"$f":"VLOOKUP(B49,TAB.REF!$A$3:$D$140,4)","v":4.3},12.9,5.66,16.98]
[41,234567,{"$f":"VLOOKUP(B50,TAB.REF!$A$3:$D$140,2)","v":"GRAMPO ANCORAGEM PARA CABO 50MM² 15KV"},{"$f":"VLOOKUP(B50,TAB.REF!$A$3:$D$140,3)","v":"PC"},6,{"$f":"VLOOKUP(B50,TAB.REF!$A$3:$D$140,4)","v":20.12},120.72,26.47,158.82]
[42,222539,{"$f":"VLOOKUP(B51,TAB.REF!$A$3:$D$140,2)","v":"HASTE ATERRAMENTO 2400MM"},{"$f":"VLOOKUP(B51,TAB.REF!$A$3:$D$140,3)","v":"PC"},3,{"$f":"VLOOKUP(B51,TAB.REF!$A$3:$D$140,4)","v":40.75},122.25,53.61,160.83000000000001]
[43,219659,{"$f":"VLOOKUP(B52,TAB.REF!$A$3:$D$140,2)","v":"ISOLADOR DE ANCORAGEM POLIMÉRICO 15KV ITEM 1"},{"$f":"VLOOKUP(B52,TAB.REF!$A$3:$D$140,3)","v":"PC"},6,{"$f":"VLOOKUP(B52,TAB.REF!$A$3:$D$140,4)","v":41.77},250.62,54.95,329.7]
[44,219642,{"$f":"VLOOKUP(B53,TAB.REF!$A$3:$D$140,2)","v":"ISOLADOR PINO POLIMÉRICO 15 KV P/BRAÇO SUPORTE C"},{"$f":"VLOOKUP(B53,TAB.REF!$A$3:$D$140,3)","v":"PC"},6,{"$f":"VLOOKUP(B53,TAB.REF!$A$3:$D$140,4)","v":20.079999999999998},120.48,26.42,158.52000000000001]
[45,237271,{"$f":"VLOOKUP(B54,TAB.REF!$A$3:$D$140,2)","v":"MANILHA SAPATILHA CLASSE 50KN"},{"$f":"VLOOKUP(B54,TAB.REF!$A$3:$D$140,3)","v":"PC"},6,{"$f":"VLOOKUP(B54,TAB.REF!$A$3:$D$140,4)","v":10.91},65.459999999999994,14.35,86.1]
[46,374393,{"$f":"VLOOKUP(B55,TAB.REF!$A$3:$D$140,2)","v":"MANTA AUTO-ADESIVA PARA EMENDA CABO 15KV RDP"},{"$f":"VLOOKUP(B55,TAB.REF!$A$3:$D$140,3)","v":"PC"},6,{"$f":"VLOOKUP(B55,TAB.REF!$A$3:$D$140,4)","v":66.28},397.68,87.2,523.20000000000005]
[47,237289,{"$f":"VLOOKUP(B56,TAB.REF!$A$3:$D$140,2)","v":"OLHAL PARA PARAFUSO 50KN"},{"$f":"VLOOKUP(B56,TAB.REF!$A$3:$D$140,3)","v":"PC"},17,{"$f":"VLOOKUP(B56,TAB.REF!$A$3:$D$140,4)","v":16.760000000000002},284.92,22.05,374.85]
[48,66688,{"$f":"VLOOKUP(B57,TAB.REF!$A$3:$D$140,2)","v":"PARAFUSO CABEÇA ABAULADA M12X 40MM"},{"$f":"VLOOKUP(B57,TAB.REF!$A$3:$D$140,3)","v":"PC"},2,{"$f":"VLOOKUP(B57,TAB.REF!$A$3:$D$140,4)","v":1.63},3.26,2.14,4.28]
[49,66878,{"$f":"VLOOKUP(B58,TAB.REF!$A$3:$D$140,2)","v":"PARAFUSO CABEÇA ABAULADA M16X 45MM"},{"$f":"VLOOKUP(B58,TAB.REF!$A$3:$D$140,3)","v":"PC"},23,{"$f":"VLOOKUP(B58,TAB.REF!$A$3:$D$140,4)","v":2.17},49.91,2.85,65.55]
[50,66886,{"$f":"VLOOKUP(B59,TAB.REF!$A$3:$D$140,2)","v":"PARAFUSO CABEÇA ABAULADA M16X 70MM"},{"$f":"VLOOKUP(B59,TAB.REF!$A$3:$D$140,3)","v":"PC"},54,{"$f":"VLOOKUP(B59,TAB.REF!$A$3:$D$140,4)","v":2.64},142.56,3.47,187.38]
[51,75036,{"$f":"VLOOKUP(B60,TAB.REF!$A$3:$D$140,2)","v":"PARAFUSO CABEÇA SEXTAVADA M12X 40MM"},{"$f":"VLOOKUP(B60,TAB.REF!$A$3:$D$140,3)","v":"PC"},8,{"$f":"VLOOKUP(B60,TAB.REF!$A$3:$D$140,4)","v":12.44},99.52,16.37,130.96]
[52,289058,{"$f":"VLOOKUP(B61,TAB.REF!$A$3:$D$140,2)","v":"PÁRA-RAIOS 12KV 10KA ZNO"},{"$f":"VLOOKUP(B61,TAB.REF!$A$3:$D$140,3)","v":"PC"},3,{"$f":"VLOOKUP(B61,TAB.REF!$A$3:$D$140,4)","v":153.69},461.07,202.19,606.57000000000005]
[53,293357,{"$f":"VLOOKUP(B62,TAB.REF!$A$3:$D$140,2)","v":"PÁRA-RAIOS REDE SECUNDÁRIA ISOLADA 280V 10KA"},{"$f":"VLOOKUP(B62,TAB.REF!$A$3:$D$140,3)","v":"PC"},3,{"$f":"VLOOKUP(B62,TAB.REF!$A$3:$D$140,4)","v":59.64},178.92,78.459999999999994,235.38]
[54,236265,{"$f":"VLOOKUP(B63,TAB.REF!$A$3:$D$140,2)","v":"PINO P/ ISOLADOR POLIMÉRICO ATÉ 36,2 KV - BRAÇO C"},{"$f":"VLOOKUP(B63,TAB.REF!$A$3:$D$140,3)","v":"PC"},6,{"$f":"VLOOKUP(B63,TAB.REF!$A$3:$D$140,4)","v":15.35},92.1,20.190000000000001,121.14]
[55,207449,{"$f":"VLOOKUP(B64,TAB.REF!$A$3:$D$140,2)","v":"POSTE CONCRETO CIRCULAR 11M 600DAN"},{"$f":"VLOOKUP(B64,TAB.REF!$A$3:$D$140,3)","v":"PC"},2,{"$f":"VLOOKUP(B64,TAB.REF!$A$3:$D$140,4)","v":951.41},1902.82,1251.67,2503.34]
[56,237768,{"$f":"VLOOKUP(B65,TAB.REF!$A$3:$D$140,2)","v":"SAPATILHA"},{"$f":"VLOOKUP(B65,TAB.REF!$A$3:$D$140,3)","v":"PC"},9,{"$f":"VLOOKUP(B65,TAB.REF!$A$3:$D$140,4)","v":1.99},17.91,2.62,23.58]
[57,237081,{"$f":"VLOOKUP(B66,TAB.REF!$A$3:$D$140,2)","v":"SUPORTE 240MM TRANSFORMADOR POSTE CC"},{"$f":"VLOOKUP(B66,TAB.REF!$A$3:$D$140,3)","v":"PC"},2,{"$f":"VLOOKUP(B66,TAB.REF!$A$3:$D$140,4)","v":104.81},209.62,137.88999999999999,275.77999999999997]
[58,231555,{"$f":"VLOOKUP(B67,TAB.REF!$A$3:$D$140,2)","v":"SUPORTE Z PARA CHAVE FUSÍVEL"},{"$f":"VLOOKUP(B67,TAB.REF!$A$3:$D$140,3)","v":"PC"},1,{"$f":"VLOOKUP(B67,TAB.REF!$A$3:$D$140,4)","v":14.06},14.06,18.5,18.5]
[59,245837,{"$f":"VLOOKUP(B68,TAB.REF!$A$3:$D$140,2)","v":"TRANSFORMADOR TRIFÁSICO 15KV 45KVA"},{"$f":"VLOOKUP(B68,TAB.REF!$A$3:$D$140,3)","v":"PC"},1,{"$f":"VLOOKUP(B68,TAB.REF!$A$3:$D$140,4)","v":5284},5284,6951.63,6951.63]
[60,2931,{"$f":"VLOOKUP(B69,TAB.REF!$A$3:$D$140,2)","v":"CABO DE AÇO MR 1/4P (6,4MM) 7 FIOS"},{"$f":"VLOOKUP(B69,TAB.REF!$A$3:$D$140,3)","v":"KG"},1.6,{"$f":"VLOOKUP(B69,TAB.REF!$A$3:$D$140,4)","v":2.76},4.42,3.63,5.81]
[61,225615,{"$f":"VLOOKUP(B70,TAB.REF!$A$3:$D$140,2)","v":"CABO CU 1X 1,5MM² 1KV XLPE"},{"$f":"VLOOKUP(B70,TAB.REF!$A$3:$D$140,3)","v":"M"},32,{"$f":"VLOOKUP(B70,TAB.REF!$A$3:$D$140,4)","v":1.1499999999999999},36.799999999999997,1.51,48.32]
[62,236919,{"$f":"VLOOKUP(B71,TAB.REF!$A$3:$D$140,2)","v":"CINTA DE AÇO D 250MM"},{"$f":"VLOOKUP(B71,TAB.REF!$A$3:$D$140,3)","v":"PC"},6,{"$f":"VLOOKUP(B71,TAB.REF!$A$3:$D$140,4)","v":21.79},130.74,28.67,172.02]
[63,231175,{"$f":"VLOOKUP(B72,TAB.REF!$A$3:$D$140,2)","v":"CONETOR PARA ATERRAMENTO DE FERRAGENS DE IP"},{"$f":"VLOOKUP(B72,TAB.REF!$A$3:$D$140,3)","v":"PC"},8,{"$f":"VLOOKUP(B72,TAB.REF!$A$3:$D$140,4)","v":1.3},10.4,1.71,13.68]
[64,227850,{"$f":"VLOOKUP(B73,TAB.REF!$A$3:$D$140,2)","v":"CONETOR CUNHA CU ITEM 1"},{"$f":"VLOOKUP(B73,TAB.REF!$A$3:$D$140,3)","v":"PC"},4,{"$f":"VLOOKUP(B73,TAB.REF!$A$3:$D$140,4)","v":3.79},{"$f":"ROUND(F73*E73,2)","v":15.16},{"$f":"ROUND(F73*(1+$I$6),2)","v":4.99},{"$f":"ROUND(H73*E73,2)","v":19.96}]
[65,379679,{"$f":"VLOOKUP(B74,TAB.REF!$A$3:$D$140,2)","v":"CONETOR DE PERFURAÇÃO 35-120MM²/1,5MM²"},{"$f":"VLOOKUP(B74,TAB.REF!$A$3:$D$140,3)","v":"PC"},8,{"$f":"VLOOKUP(B74,TAB.REF!$A$3:$D$140,4)","v":5.98},{"$f":"ROUND(F74*E74,2)","v":47.84},{"$f":"ROUND(F74*(1+$I$6),2)","v":7.87},{"$f":"ROUND(H74*E74,2)","v":62.96}]
[66,66886,{"$f":"VLOOKUP(B75,TAB.REF!$A$3:$D$140,2)","v":"PARAFUSO CABEÇA ABAULADA M16X 70MM"},{"$f":"VLOOKUP(B75,TAB.REF!$A$3:$D$140,3)","v":"PC"},12,{"$f":"VLOOKUP(B75,TAB.REF!$A$3:$D$140,4)","v":2.64},31.68,3.47,41.64]
[67,228981,{"$f":"VLOOKUP(B76,TAB.REF!$A$3:$D$140,2)","v":"ALÇA PREFORMADA NEUTRO CA/CAL 16MM²"},{"$f":"VLOOKUP(B76,TAB.REF!$A$3:$D$140,3)","v":"PC"},48,{"$f":"VLOOKUP(B76,TAB.REF!$A$3:$D$140,4)","v":1.3},62.4,1.71,82.08]
[68,331728,{"$f":"VLOOKUP(B77,TAB.REF!$A$3:$D$140,2)","v":"CONETOR CUNHA ITEM 2 + COBERTURA ISOLANTE ITEM 2"},{"$f":"VLOOKUP(B77,TAB.REF!$A$3:$D$140,3)","v":"PC"},46,{"$f":"VLOOKUP(B77,TAB.REF!$A$3:$D$140,4)","v":3.63},166.98,4.78,219.88]
[69,227850,{"$f":"VLOOKUP(B78,TAB.REF!$A$3:$D$140,2)","v":"CONETOR CUNHA CU ITEM 1"},{"$f":"VLOOKUP(B78,TAB.REF!$A$3:$D$140,3)","v":"PC"},24,{"$f":"VLOOKUP(B78,TAB.REF!$A$3:$D$140,4)","v":3.79},90.96,4.99,119.76]
[70,227868,{"$f":"VLOOKUP(B79,TAB.REF!$A$3:$D$140,2)","v":"CONETOR CUNHA CU ITEM 2"},{"$f":"VLOOKUP(B79,TAB.REF!$A$3:$D$140,3)","v":"PC"},24,{"$f":"VLOOKUP(B79,TAB.REF!$A$3:$D$140,4)","v":2.81},67.44,3.7,88.8]
[71,327726,{"$f":"VLOOKUP(B80,TAB.REF!$A$3:$D$140,2)","v":"CONETOR DE PERFURAÇÃO 10-70MM²/6-35MM²"},{"$f":"VLOOKUP(B80,TAB.REF!$A$3:$D$140,3)","v":"PC"},46,{"$f":"VLOOKUP(B80,TAB.REF!$A$3:$D$140,4)","v":8.25},379.5,10.85,499.1]
[" VALOR TOTAL MATERIAIS",null,null,null,null,{"$f":"ROUND(SUM(G10:G80),2)","v":15148.18},null,{"$f":"ROUND(SUM(I10:I80),2)","v":19929.490000000002}]
["MÃO DE OBRA DE CONSTRUÇÃO",null,null,null,null,"PREÇO SEM BDI",null,"PREÇO COM BDI"]
["ITEM","CÓDIGO","DESCRIÇÃO","UN","QUANT.","R$.UNIT.","R$. TOTAL","R$.UNIT.","R$. TOTAL"]
[1,"US. CONST. RDA",{"$f":"VLOOKUP(B84,TAB.REF!$A$2:$D$140,2)","v":"MÃO DE OBRA DE CONSTRUÇÃO DE REDE ELÉTRICA"},"US",4.5,{"$f":"VLOOKUP(B84,TAB.REF!$A$2:$D$140,4)","v":1538.3},{"$f":"ROUND(E84*F84,2)","v":6922.35},{"$f":"F84*(1+$I$6)","v":2023.79},{"$f":"ROUND(H84*E84,2)","v":9107.06}]
[2,"US. CONST. RDS",{"$f":"VLOOKUP(B85,TAB.REF!$A$2:$D$140,2)","v":"MÃO DE OBRA DE CONSTRUÇÃO DE REDE SUBTERRÂNEA"},"US",null,{"$f":"VLOOKUP(B85,TAB.REF!$A$2:$D$140,4)","v":1538.3},{"$f":"ROUND(E85*F85,2)","v":0},{"$f":"F85*(1+$I$6)","v":2023.79},{"$f":"ROUND(H85*E85,2)","v":0}]
[" VALOR TOTAL MÃO DE OBRA",null,null,null,null,{"$f":"SUM(G84:G85)","v":6922.35},null,{"$f":"SUM(I84:I85)","v":9107.06}]
["RESUMO",null,null,null,null,"PREÇO SEM BDI",null,"PREÇO COM BDI"]
[" VALOR TOTAL MATERIAIS",null,null,null,null,{"$f":"ROUND(F81,2)","v":15148.18},null,{"$f":"ROUND(H81,2)","v":19929.490000000002}]
[" VALOR TOTAL MÃO DE OBRA",null,null,null,null,{"$f":"ROUND(F86,2)","v":6922.35},null,{"$f":"H86","v":9107.06}]
[" VALOR TOTAL",null,null,null,null,{"$f":"ROUND(SUM(F88:G89),2)","v":22070.53},null,{"$f":"SUM(H88:I89)","v":29036.55}]
[]
[]
[{"$f":"CONCATENATE(RESUMO!B18,\" \",RESUMO!C18)","v":"Patos de Minas, 4 de fevereiro de 2020"}]
[]
[]
["_______________________________________________________"]
[{"$f":"RESUMO!B21","v":"Diogo Soares Resende"}]
[{"$f":"RESUMO!B22","v":"Eng. Eletricista"}]
[{"$f":"RESUMO!B23","v":"CREA: 194.419D/MG"}]

{"sheet":"PMPATOS_004DR","index":9,"n_rows":48,"n_cols":9,"rows_kept":48,"cut":false,"hidden":false,"merged":[[45,0,45,8],[46,0,46,8],[41,0,41,8],[47,0,47,8],[38,0,38,4],[38,5,38,6],[38,7,38,8],[43,0,43,6],[44,0,44,8],[36,0,36,4],[36,5,36,6],[36,7,36,8],[37,0,37,4],[37,5,37,6],[37,7,37,8],[34,0,34,4],[34,5,34,6],[34,7,34,8],[35,0,35,4],[35,5,35,6],[35,7,35,8],[27,0,27,4],[27,5,27,6],[27,7,27,8],[30,0,30,4],[30,5,30,6],[30,7,30,8],[7,0,7,8],[8,0,9,0],[8,1,9,1],[8,2,9,2],[8,3,9,3],[8,4,9,4],[8,5,8,6],[8,7,8,8],[6,0,6,4],[2,0,2,8],[0,0,0,8],[1,0,1,8],[3,0,3,8],[4,1,4,2],[5,0,5,4]]}
[]
["PLANILHA ORÇAMENTÁRIA "]
["OBJETO: PROJETOS DE MODIFICAÇÃO, EXTENSÃO DE REDE  E ILUMINAÇÃO PÚBLICA"]
["OBRA: OBRAS DE EXTENSÃO E MODIFICAÇÃO DE REDE DE DISTRIBUIÇÃO DE ENERGIA ELÉTRICA COM INSTALAÇÃO E SUBSTITUIÇÃO DE LUMINÁRIAS PARA EFICIENTIZAÇÃO DA ILUMINAÇÃO PÚBLICA NO MUNICÍPIO DE PATOS DE MINAS-MG."]
["LOCAL:","PMPATOS_004DR - PRAÇA FREI ILDEU - SEBASTIÃO AMORIM"]
["RESPONSÁVEL TÉCNICO: DIOGO SOARES RESENDE",null,null,null,null,"CREA:",{"$f":"LEFT(RIGHT(RESUMO!B23,11),8)","v":"194.419D"},"ART:"]
["REFERENCIA DE PREÇOS: PREÇOS DE MERCADO",null,null,null,null,"DATA: ",{"$f":"RESUMO!E5","v":"2020-02-04"},"BDI :",{"$f":"RESUMO!F5","v":0.31559999999999999}]
[]
["ITEM","CÓDIGO ","DESCRIÇÃO","UNID.","QUANT.","PREÇO SEM BDI",null,"PREÇO COM BDI"]
[null,null,null,null,null,"UNITÁRIO ","TOTAL","UNITÁRIO ","TOTAL"]
[1,306555,{"$f":"VLOOKUP(B11,TAB.REF!$A$3:$D$140,2)","v":"ANEL CAIXA ZA CONCRETO PREMOLDADO"},{"$f":"VLOOKUP(B11,TAB.REF!$A$3:$D$140,3)","v":"PC"},6,{"$f":"VLOOKUP(B11,TAB.REF!$A$3:$D$140,4)","v":51.32},{"$f":"ROUND(F11*E11,2)","v":307.92},{"$f":"ROUND(F11*(1+$I$7),2)","v":67.52},{"$f":"ROUND(H11*E11,2)","v":405.12}]
[{"$f":"A11+1","v":2},299560,{"$f":"VLOOKUP(B12,TAB.REF!$A$3:$D$140,2)","v":"ARO COM TAMPA ARTICULADA CAIXA ZA"},{"$f":"VLOOKUP(B12,TAB.REF!$A$3:$D$140,3)","v":"CJ"},6,{"$f":"VLOOKUP(B12,TAB.REF!$A$3:$D$140,4)","v":139.08000000000001},834.48,182.97,1097.82]
[{"$f":"A12+1","v":3},2931,{"$f":"VLOOKUP(B13,TAB.REF!$A$3:$D$140,2)","v":"CABO DE AÇO MR 1/4P (6,4MM) 7 FIOS"},{"$f":"VLOOKUP(B13,TAB.REF!$A$3:$D$140,3)","v":"KG"},6,{"$f":"VLOOKUP(B13,TAB.REF!$A$3:$D$140,4)","v":2.76},16.559999999999999,3.63,21.78]
[4,225623,{"$f":"VLOOKUP(B14,TAB.REF!$A$3:$D$140,2)","v":"CABO AL 1X 16MM² 1KV"},{"$f":"VLOOKUP(B14,TAB.REF!$A$3:$D$140,3)","v":"M"},486,{"$f":"VLOOKUP(B14,TAB.REF!$A$3:$D$140,4)","v":1.85},899.1,2.4300000000000002,1180.98]
[5,225896,{"$f":"VLOOKUP(B15,TAB.REF!$A$3:$D$140,2)","v":"CABO CU 1X 2,5MM² 750V"},{"$f":"VLOOKUP(B15,TAB.REF!$A$3:$D$140,3)","v":"M"},396,{"$f":"VLOOKUP(B15,TAB.REF!$A$3:$D$140,4)","v":1.53},605.88,2.0099999999999998,795.96]
[6,378849,{"$f":"VLOOKUP(B16,TAB.REF!$A$3:$D$140,2)","v":"CONECTOR,PERFURAÇÃO,AL/CU,16-70/1,5-6MM²,RDS."},{"$f":"VLOOKUP(B16,TAB.REF!$A$3:$D$140,3)","v":"PC"},33,{"$f":"VLOOKUP(B16,TAB.REF!$A$3:$D$140,4)","v":84.24},2779.92,110.83,3657.39]
[7,227769,{"$f":"VLOOKUP(B17,TAB.REF!$A$3:$D$140,2)","v":"CONETOR FORMATO H ITEM 1 CAA 13-34MM² / 13-34MM²"},{"$f":"VLOOKUP(B17,TAB.REF!$A$3:$D$140,3)","v":"PC"},3,{"$f":"VLOOKUP(B17,TAB.REF!$A$3:$D$140,4)","v":2.25},6.75,2.96,8.8800000000000008]
[8,227389,{"$f":"VLOOKUP(B18,TAB.REF!$A$3:$D$140,2)","v":"CONETOR TERMINAL COMPRESSÃO 1F AÇO 6,4MM / 21MM²"},{"$f":"VLOOKUP(B18,TAB.REF!$A$3:$D$140,3)","v":"PC"},3,{"$f":"VLOOKUP(B18,TAB.REF!$A$3:$D$140,4)","v":2.0699999999999998},6.21,2.72,8.16]
[9,377568,{"$f":"VLOOKUP(B19,TAB.REF!$A$3:$D$140,2)","v":"DUTO PEAD CORRUGADO DEN 63MM"},{"$f":"VLOOKUP(B19,TAB.REF!$A$3:$D$140,3)","v":"M"},157,{"$f":"VLOOKUP(B19,TAB.REF!$A$3:$D$140,4)","v":10.5},1648.5,13.81,2168.17]
[10,3954,{"$f":"VLOOKUP(B20,TAB.REF!$A$3:$D$140,2)","v":"FITA ADESIVA ISOLANTE PVC 19MMX20M"},{"$f":"VLOOKUP(B20,TAB.REF!$A$3:$D$140,3)","v":"RL"},4,{"$f":"VLOOKUP(B20,TAB.REF!$A$3:$D$140,4)","v":4.97},19.88,6.54,26.16]
[11,222539,{"$f":"VLOOKUP(B21,TAB.REF!$A$3:$D$140,2)","v":"HASTE ATERRAMENTO 2400MM"},{"$f":"VLOOKUP(B21,TAB.REF!$A$3:$D$140,3)","v":"PC"},3,{"$f":"VLOOKUP(B21,TAB.REF!$A$3:$D$140,4)","v":40.75},122.25,53.61,160.83000000000001]
[12,150,{"$f":"VLOOKUP(B22,TAB.REF!$A$3:$D$140,2)","v":"LUMINARIA LED POTÊNCIA ATÉ 150W FLUXO LUMINOSO APROXIMADO 17.250lm EFICIENCIA LUMINOSA ≥ 115lm/w"},{"$f":"VLOOKUP(B22,TAB.REF!$A$3:$D$140,3)","v":"PC"},10,{"$f":"VLOOKUP(B22,TAB.REF!$A$3:$D$140,4)","v":1235},12350,1624.77,16247.7]
[13,82586,{"$f":"VLOOKUP(B23,TAB.REF!$A$3:$D$140,2)","v":"MASSA CALAFETAR 1KG"},{"$f":"VLOOKUP(B23,TAB.REF!$A$3:$D$140,3)","v":"KG"},2,{"$f":"VLOOKUP(B23,TAB.REF!$A$3:$D$140,4)","v":16.78},33.56,22.08,44.16]
[14,214668,{"$f":"VLOOKUP(B24,TAB.REF!$A$3:$D$140,2)","v":"POSTE CONCRETO RC IP 11,5M 150DAN"},{"$f":"VLOOKUP(B24,TAB.REF!$A$3:$D$140,3)","v":"PC"},5,{"$f":"VLOOKUP(B24,TAB.REF!$A$3:$D$140,4)","v":1122.95},5614.75,1477.35,7386.75]
[15,327361,{"$f":"VLOOKUP(B25,TAB.REF!$A$3:$D$140,2)","v":"RELÉ FOTOELÉTRICO ELETRÔNICO 105-305V"},{"$f":"VLOOKUP(B25,TAB.REF!$A$3:$D$140,3)","v":"PC"},11,{"$f":"VLOOKUP(B25,TAB.REF!$A$3:$D$140,4)","v":19.100000000000001},210.1,25.13,276.43]
[{"$f":"A25+1","v":16},"SUP3",{"$f":"VLOOKUP(B26,TAB.REF!$A$3:$D$140,2)","v":"SUPORTE IP 3 LUMINÁRIAS POSTE RC OU AÇO 10/12/14M"},{"$f":"VLOOKUP(B26,TAB.REF!$A$3:$D$140,3)","v":"PC"},1,{"$f":"VLOOKUP(B26,TAB.REF!$A$3:$D$140,4)","v":221},221,{"$f":"ROUND(F26*(1+$I$7),2)","v":290.75},{"$f":"ROUND(H26*E26,2)","v":290.75}]
[{"$f":"A26+1","v":17},354903,{"$f":"VLOOKUP(B27,TAB.REF!$A$3:$D$140,2)","v":"SUPORTE IP 2 LUMINÁRIAS POSTE RC OU AÇO 10/12/14M"},{"$f":"VLOOKUP(B27,TAB.REF!$A$3:$D$140,3)","v":"PC"},4,{"$f":"VLOOKUP(B27,TAB.REF!$A$3:$D$140,4)","v":160},{"$f":"ROUND(F27*E27,2)","v":640},{"$f":"ROUND(F27*(1+$I$7),2)","v":210.5},{"$f":"ROUND(H27*E27,2)","v":842}]
[" VALOR TOTAL MATERIAIS",null,null,null,null,{"$f":"SUM(G11:G27)","v":26316.86},null,{"$f":"SUM(I11:I27)","v":34619.040000000001}]
[]
[]
["MÃO DE OBRA DE CONSTRUÇÃO",null,null,null,null,"PREÇO SEM BDI",null,"PREÇO COM BDI"]
["ITEM","CÓDIGO","DESCRIÇÃO","UN","QUANT.","R$.UNIT.","R$. TOTAL","R$.UNIT.","R$. TOTAL"]
[1,"US. CONST. RDA",{"$f":"VLOOKUP(B33,TAB.REF!$A$2:$D$140,2)","v":"MÃO DE OBRA DE CONSTRUÇÃO DE REDE ELÉTRICA"},"US",null,{"$f":"VLOOKUP(B33,TAB.REF!$A$2:$D$140,4)","v":1538.3},{"$f":"ROUND(F33*E33,2)","v":0},{"$f":"ROUND(F33*(1+$I$7),2)","v":2023.79},{"$f":"ROUND(H33*E33,2)","v":0}]
[2,"US. CONST. RDS",{"$f":"VLOOKUP(B34,TAB.REF!$A$2:$D$140,2)","v":"MÃO DE OBRA DE CONSTRUÇÃO DE REDE SUBTERRÂNEA"},"US",6.34,{"$f":"VLOOKUP(B34,TAB.REF!$A$2:$D$140,4)","v":1538.3},{"$f":"ROUND(F34*E34,2)","v":9752.82},{"$f":"ROUND(F34*(1+$I$7),2)","v":2023.79},{"$f":"ROUND(H34*E34,2)","v":12830.83}]
[" VALOR TOTAL MÃO DE OBRA",null,null,null,null,{"$f":"SUM(G33:G34)","v":9752.82},null,{"$f":"SUM(I33:I34)","v":12830.83}]
["RESUMO",null,null,null,null,"PREÇO SEM BDI",null,"PREÇO COM BDI"]
[" VALOR TOTAL MATERIAIS",null,null,null,null,{"$f":"F28","v":26316.86},null,{"$f":"H28","v":34619.040000000001}]
[" VALOR TOTAL MÃO DE OBRA",null,null,null,null,{"$f":"F35","v":9752.82},null,{"$f":"H35","v":12830.83}]
[" VALOR TOTAL",null,null,null,null,{"$f":"SUM(F37:G38)","v":36069.68},null,{"$f":"SUM(H37:I38)","v":47449.87}]
[]
[]
[{"$f":"CONCATENATE(RESUMO!B18,\" \",RESUMO!C18)","v":"Patos de Minas, 4 de fevereiro de 2020"}]
[]
[]
["_______________________________________________________"]
[{"$f":"RESUMO!B21","v":"Diogo Soares Resende"}]
[{"$f":"RESUMO!B22","v":"Eng. Eletricista"}]
[{"$f":"RESUMO!B23","v":"CREA: 194.419D/MG"}]

{"sheet":"PMPATOS_005DR","index":10,"n_rows":49,"n_cols":9,"rows_kept":49,"cut":false,"hidden":false,"merged":[[46,0,46,8],[47,0,47,8],[42,0,42,8],[48,0,48,8],[39,0,39,4],[39,5,39,6],[39,7,39,8],[44,0,44,6],[45,0,45,8],[37,0,37,4],[37,5,37,6],[37,7,37,8],[38,0,38,4],[38,5,38,6],[38,7,38,8],[35,0,35,4],[35,5,35,6],[35,7,35,8],[36,0,36,4],[36,5,36,6],[36,7,36,8],[28,0,28,4],[28,5,28,6],[28,7,28,8],[31,0,31,4],[31,5,31,6],[31,7,31,8],[7,0,7,8],[8,0,9,0],[8,1,9,1],[8,2,9,2],[8,3,9,3],[8,4,9,4],[8,5,8,6],[8,7,8,8],[6,0,6,4],[2,0,2,8],[0,0,0,8],[1,0,1,8],[3,0,3,8],[4,1,4,2],[5,0,5,4]]}
[]
["PLANILHA ORÇAMENTÁRIA "]
["OBJETO: PROJETOS DE MODIFICAÇÃO, EXTENSÃO DE REDE  E ILUMINAÇÃO PÚBLICA"]
["OBRA: OBRAS DE EXTENSÃO E MODIFICAÇÃO DE REDE DE DISTRIBUIÇÃO DE ENERGIA ELÉTRICA COM INSTALAÇÃO E SUBSTITUIÇÃO DE LUMINÁRIAS PARA EFICIENTIZAÇÃO DA ILUMINAÇÃO PÚBLICA NO MUNICÍPIO DE PATOS DE MINAS-MG."]
["LOCAL:","PMPATOS_005DR - PRAÇA JOSÉ DE BRITO - JARDIM PELUZZO"]
["RESPONSÁVEL TÉCNICO: DIOGO SOARES RESENDE",null,null,null,null,"CREA:",{"$f":"LEFT(RIGHT(RESUMO!B23,11),8)","v":"194.419D"},"ART:"]
["REFERENCIA DE PREÇOS: PREÇOS DE MERCADO",null,null,null,null,"DATA: ",{"$f":"RESUMO!E5","v":"2020-02-04"},"BDI :",{"$f":"RESUMO!F5","v":0.31559999999999999}]
[]
["ITEM","CÓDIGO ","DESCRIÇÃO","UNID.","QUANT.","PREÇO SEM BDI",null,"PREÇO COM BDI"]
[null,null,null,null,null,"UNITÁRIO ","TOTAL","UNITÁRIO ","TOTAL"]
[1,306555,{"$f":"VLOOKUP(B11,TAB.REF!$A$3:$D$140,2)","v":"ANEL CAIXA ZA CONCRETO PREMOLDADO"},{"$f":"VLOOKUP(B11,TAB.REF!$A$3:$D$140,3)","v":"PC"},3,{"$f":"VLOOKUP(B11,TAB.REF!$A$3:$D$140,4)","v":51.32},{"$f":"ROUND(F11*E11,2)","v":153.96},{"$f":"ROUND(F11*(1+$I$7),2)","v":67.52},{"$f":"ROUND(H11*E11,2)","v":202.56}]
[{"$f":"A11+1","v":2},299560,{"$f":"VLOOKUP(B12,TAB.REF!$A$3:$D$140,2)","v":"ARO COM TAMPA ARTICULADA CAIXA ZA"},{"$f":"VLOOKUP(B12,TAB.REF!$A$3:$D$140,3)","v":"CJ"},3,{"$f":"VLOOKUP(B12,TAB.REF!$A$3:$D$140,4)","v":139.08000000000001},417.24,182.97,548.91]
[{"$f":"A12+1","v":3},2931,{"$f":"VLOOKUP(B13,TAB.REF!$A$3:$D$140,2)","v":"CABO DE AÇO MR 1/4P (6,4MM) 7 FIOS"},{"$f":"VLOOKUP(B13,TAB.REF!$A$3:$D$140,3)","v":"KG"},3,{"$f":"VLOOKUP(B13,TAB.REF!$A$3:$D$140,4)","v":2.76},8.2799999999999994,3.63,10.89]
[4,225623,{"$f":"VLOOKUP(B14,TAB.REF!$A$3:$D$140,2)","v":"CABO AL 1X 16MM² 1KV"},{"$f":"VLOOKUP(B14,TAB.REF!$A$3:$D$140,3)","v":"M"},351,{"$f":"VLOOKUP(B14,TAB.REF!$A$3:$D$140,4)","v":1.85},649.35,2.4300000000000002,852.93]
[5,225896,{"$f":"VLOOKUP(B15,TAB.REF!$A$3:$D$140,2)","v":"CABO CU 1X 2,5MM² 750V"},{"$f":"VLOOKUP(B15,TAB.REF!$A$3:$D$140,3)","v":"M"},324,{"$f":"VLOOKUP(B15,TAB.REF!$A$3:$D$140,4)","v":1.53},495.72,2.0099999999999998,651.24]
[6,378849,{"$f":"VLOOKUP(B16,TAB.REF!$A$3:$D$140,2)","v":"CONECTOR,PERFURAÇÃO,AL/CU,16-70/1,5-6MM²,RDS."},{"$f":"VLOOKUP(B16,TAB.REF!$A$3:$D$140,3)","v":"PC"},27,{"$f":"VLOOKUP(B16,TAB.REF!$A$3:$D$140,4)","v":84.24},2274.48,110.83,2992.41]
[7,227769,{"$f":"VLOOKUP(B17,TAB.REF!$A$3:$D$140,2)","v":"CONETOR FORMATO H ITEM 1 CAA 13-34MM² / 13-34MM²"},{"$f":"VLOOKUP(B17,TAB.REF!$A$3:$D$140,3)","v":"PC"},1,{"$f":"VLOOKUP(B17,TAB.REF!$A$3:$D$140,4)","v":2.25},2.25,2.96,2.96]
[8,227389,{"$f":"VLOOKUP(B18,TAB.REF!$A$3:$D$140,2)","v":"CONETOR TERMINAL COMPRESSÃO 1F AÇO 6,4MM / 21MM²"},{"$f":"VLOOKUP(B18,TAB.REF!$A$3:$D$140,3)","v":"PC"},2,{"$f":"VLOOKUP(B18,TAB.REF!$A$3:$D$140,4)","v":2.0699999999999998},4.1399999999999997,2.72,5.44]
[9,377568,{"$f":"VLOOKUP(B19,TAB.REF!$A$3:$D$140,2)","v":"DUTO PEAD CORRUGADO DEN 63MM"},{"$f":"VLOOKUP(B19,TAB.REF!$A$3:$D$140,3)","v":"M"},73,{"$f":"VLOOKUP(B19,TAB.REF!$A$3:$D$140,4)","v":10.5},766.5,13.81,1008.13]
[10,3954,{"$f":"VLOOKUP(B20,TAB.REF!$A$3:$D$140,2)","v":"FITA ADESIVA ISOLANTE PVC 19MMX20M"},{"$f":"VLOOKUP(B20,TAB.REF!$A$3:$D$140,3)","v":"RL"},3,{"$f":"VLOOKUP(B20,TAB.REF!$A$3:$D$140,4)","v":4.97},14.91,6.54,19.62]
[11,222539,{"$f":"VLOOKUP(B21,TAB.REF!$A$3:$D$140,2)","v":"HASTE ATERRAMENTO 2400MM"},{"$f":"VLOOKUP(B21,TAB.REF!$A$3:$D$140,3)","v":"PC"},2,{"$f":"VLOOKUP(B21,TAB.REF!$A$3:$D$140,4)","v":40.75},81.5,53.61,107.22]
[12,114,{"$f":"VLOOKUP(B22,TAB.REF!$A$3:$D$140,2)","v":"LUMINARIA LED POTÊNCIA ATÉ 114W FLUXO LUMINOSO APROXIMADO 13.100lm EFICIENCIA LUMINOSA ≥ 115lm/w"},{"$f":"VLOOKUP(B22,TAB.REF!$A$3:$D$140,3)","v":"PC"},9,{"$f":"VLOOKUP(B22,TAB.REF!$A$3:$D$140,4)","v":880.15},7921.35,1157.93,10421.370000000001]
[13,82586,{"$f":"VLOOKUP(B23,TAB.REF!$A$3:$D$140,2)","v":"MASSA CALAFETAR 1KG"},{"$f":"VLOOKUP(B23,TAB.REF!$A$3:$D$140,3)","v":"KG"},1,{"$f":"VLOOKUP(B23,TAB.REF!$A$3:$D$140,4)","v":16.78},16.78,22.08,22.08]
[14,214668,{"$f":"VLOOKUP(B24,TAB.REF!$A$3:$D$140,2)","v":"POSTE CONCRETO RC IP 11,5M 150DAN"},{"$f":"VLOOKUP(B24,TAB.REF!$A$3:$D$140,3)","v":"PC"},3,{"$f":"VLOOKUP(B24,TAB.REF!$A$3:$D$140,4)","v":1122.95},3368.85,1477.35,4432.05]
[15,327361,{"$f":"VLOOKUP(B25,TAB.REF!$A$3:$D$140,2)","v":"RELÉ FOTOELÉTRICO ELETRÔNICO 105-305V"},{"$f":"VLOOKUP(B25,TAB.REF!$A$3:$D$140,3)","v":"PC"},9,{"$f":"VLOOKUP(B25,TAB.REF!$A$3:$D$140,4)","v":19.100000000000001},171.9,25.13,226.17]
[16,"SINAPI34623",{"$f":"VLOOKUP(B26,TAB.REF!$A$3:$D$140,2)","v":"DISJUNTOR TIPO DIN/IEC, BIPOLAR 40A"},{"$f":"VLOOKUP(B26,TAB.REF!$A$3:$D$140,3)","v":"PC"},1,{"$f":"VLOOKUP(B26,TAB.REF!$A$3:$D$140,4)","v":51.47},51.47,67.709999999999994,67.709999999999994]
[17,214668,{"$f":"VLOOKUP(B27,TAB.REF!$A$3:$D$140,2)","v":"POSTE CONCRETO RC IP 11,5M 150DAN"},{"$f":"VLOOKUP(B27,TAB.REF!$A$3:$D$140,3)","v":"PC"},3,{"$f":"VLOOKUP(B27,TAB.REF!$A$3:$D$140,4)","v":1122.95},{"$f":"ROUND(F27*E27,2)","v":3368.85},{"$f":"ROUND(F27*(1+$I$7),2)","v":1477.35},{"$f":"ROUND(H27*E27,2)","v":4432.05}]
[18,"SUP3",{"$f":"VLOOKUP(B28,TAB.REF!$A$3:$D$140,2)","v":"SUPORTE IP 3 LUMINÁRIAS POSTE RC OU AÇO 10/12/14M"},{"$f":"VLOOKUP(B28,TAB.REF!$A$3:$D$140,3)","v":"PC"},3,{"$f":"VLOOKUP(B28,TAB.REF!$A$3:$D$140,4)","v":221},663,290.75,872.25]
[" VALOR TOTAL MATERIAIS",null,null,null,null,{"$f":"SUM(G11:G28)","v":20430.53},null,{"$f":"SUM(I11:I28)","v":26875.99}]
[]
[]
["MÃO DE OBRA DE CONSTRUÇÃO",null,null,null,null,"PREÇO SEM BDI",null,"PREÇO COM BDI"]
["ITEM","CÓDIGO","DESCRIÇÃO","UN","QUANT.","R$.UNIT.","R$. TOTAL","R$.UNIT.","R$. TOTAL"]
[1,"US. CONST. RDA",{"$f":"VLOOKUP(B34,TAB.REF!$A$2:$D$140,2)","v":"MÃO DE OBRA DE CONSTRUÇÃO DE REDE ELÉTRICA"},"US",null,{"$f":"VLOOKUP(B34,TAB.REF!$A$2:$D$140,4)","v":1538.3},{"$f":"ROUND(F34*E34,2)","v":0},{"$f":"ROUND(F34*(1+$I$7),2)","v":2023.79},{"$f":"ROUND(H34*E34,2)","v":0}]
[2,"US. CONST. RDS",{"$f":"VLOOKUP(B35,TAB.REF!$A$2:$D$140,2)","v":"MÃO DE OBRA DE CONSTRUÇÃO DE REDE SUBTERRÂNEA"},"US",10.85,{"$f":"VLOOKUP(B35,TAB.REF!$A$2:$D$140,4)","v":1538.3},{"$f":"ROUND(F35*E35,2)","v":16690.560000000001},{"$f":"ROUND(F35*(1+$I$7),2)","v":2023.79},{"$f":"ROUND(H35*E35,2)","v":21958.12}]
[" VALOR TOTAL MÃO DE OBRA",null,null,null,null,{"$f":"SUM(G34:G35)","v":16690.560000000001},null,{"$f":"SUM(I34:I35)","v":21958.12}]
["RESUMO",null,null,null,null,"PREÇO SEM BDI",null,"PREÇO COM BDI"]
[" VALOR TOTAL MATERIAIS",null,null,null,null,{"$f":"F29","v":20430.53},null,{"$f":"H29","v":26875.99}]
[" VALOR TOTAL MÃO DE OBRA",null,null,null,null,{"$f":"F36","v":16690.560000000001},null,{"$f":"H36","v":21958.12}]
[" VALOR TOTAL",null,null,null,null,{"$f":"SUM(F38:G39)","v":37121.089999999997},null,{"$f":"SUM(H38:I39)","v":48834.11}]
[]
[]
[{"$f":"CONCATENATE(RESUMO!B18,\" \",RESUMO!C18)","v":"Patos de Minas, 4 de fevereiro de 2020"}]
[]
[]
["_______________________________________________________"]
[{"$f":"RESUMO!B21","v":"Diogo Soares Resende"}]
[{"$f":"RESUMO!B22","v":"Eng. Eletricista"}]
[{"$f":"RESUMO!B23","v":"CREA: 194.419D/MG"}]