{"text_format":"2","workbook":"xlsx","n_sheets":8,"sheets":["Grupo_1__Grades","Grupo_2_Registro_valvu__vent","Grupo_3_válvulas_control","Item_27_Hidrometro","Item_28_Tampa","Grupo_4_peças_de_FoFo","Grupo_5_peças_de_PVC","Grupo_6_peças_de_PRFV"],"not_rendered":{"charts":0,"images":1,"macros":0,"external_links":0,"defined_names":11,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Grupo_1__Grades","index":0,"n_rows":13,"n_cols":9,"rows_kept":13,"cut":false,"hidden":false,"merged":[[12,1,12,7]]}
[]
[null,"PROJETO:","PROJETO DE IRRIGAÇÃO BAIXIO DE IRECÊ"]
[null,"LOCAL:","XIQUE-XIQUE / BA"]
[null,"CLIENTE:","CODEVASF"]
[null,null,"PLANILHA DE FORNECIMENTO (GRUPO 1)"]
[null,"ITEM","DESCRIÇÃO","CÓDIGO CATMAT","ESPEC TÉCN","UNID","QUANT","PÇ UNITÁRIO","PÇ TOTAL"]
[null,null,"FORNECIMENTO DE GRADES"]
[null,1,"TE-10 - GRADE METÁLICA PARA DETENÇÃO DE SÓLIDOS ( 1,38 x 1,50 ) + ( 1,38 x 1,78 ) 4,53 m^2",126756,"ET-1A-07-180","un.",1,19366,{"$f":"ROUND((G8*H8),2)","v":19366}]
[null,2,"TE-12 - GRADE METÁLICA PARA DETENÇÃO DE SÓLIDOS ( 1,38 x 1,50 ) + ( 1,38 x 1,90 ) 4,69 m^2",126756,"ET-1A-07-180","un.",1,19866,19866]
[null,3,"TE-14 - GRADE METÁLICA PARA DETENÇÃO DE SÓLIDOS ( 1,18 x 1,50 ) + ( 1,18 x 1,70 ) 3,78 m^2",126756,"ET-1A-07-180","un.",1,17386,17386]
[null,null,"VALOR TOTAL DA PLANILHA",{"$nulls":5},{"$f":"SUM(I8:I10)","v":56618}]
[]
[null,"Obs.: No preço total estão inclusas todas as despesas de fabricação, testes, manuais e fornecimento do insumos no canteiro obras. "]

{"sheet":"Grupo_2_Registro_valvu__vent","index":1,"n_rows":31,"n_cols":9,"rows_kept":31,"cut":false,"hidden":false,"merged":[[30,1,30,7]]}
[]
[null,"PROJETO:","PROJETO DE IRRIGAÇÃO BAIXIO DE IRECÊ"]
[null,"LOCAL:","XIQUE-XIQUE / BA"]
[null,"CLIENTE:","CODEVASF"]
[null,null,"PLANILHA DE FORNECIMENTO (GRUPO 2)"]
[null,"ITEM","DESCRIÇÃO","CÓDIGO CATMAT","ESPEC TÉCN","UNID","QUANT","PÇ UNITÁRIO","PÇ TOTAL"]
[null,null,"FORNECIMENTO DE REGISTROS E VENTOSAS"]
[null,4,"REGISTRO DE GAVETA CHATO C/ FLANGES E CABECOTE FOFO DN 100",150710,"ET-1A-07-400","pç",18,611.4,{"$f":"ROUND((G8*H8),2)","v":11005.2}]
[null,5,"KIT REGISTRO DE GAVETA C/ BOLSAS E CUNHA BORRACHA C/ CABECOTE DN 300 FOFO, COM CABEÇOTE PARA CHAVE T, CHAVE T, TAMPA REDONDA DN 100 MM E TOCO FOFO COM PONTAS DN 100 MM L= 0,65 M",150710,"ET-1A-07-400\ne 1552-D-ADU-HID-14-04","pç",2,6312.07,12624.14]
[null,6,"KIT REGISTRO OVAL C/ BOLSAS E CUNHA METALICA C/ CABECOTE DN 400 FOFO , COM CABEÇOTE PARA CHAVE T, CHAVE T, TAMPA REDONDA DN 100 MM E TOCO FOFO COM PONTAS DN 100 MM L= 0,4M",150710,"ET-1A-07-400\ne 1552-D-ADU-HID-14-04","pç",1,16634.18,16634.18]
[null,7,"KIT REGISTRO OVAL C/ BOLSAS E CUNHA METALICA C/ CABECOTE DN 600 FOFO , COM CABEÇOTE PARA CHAVE T, CHAVE T, TAMPA REDONDA DN 100 MM E TOCO FOFO COM PONTAS DN 100 MM L=",150710,"ET-1A-07-400\ne 1552-D-ADU-HID-14-04","pç",1,54734.37,54734.37]
[null,8,"VENTOSA TRIPLICE FUNCAO C/ FLANGES PN 10 FOFO DN 100",301172,"ET-1A-07-400","pç",14,2051.7600000000002,28724.639999999999]
[null,9,"REGISTRO DE GAVETA C/ ROSCA FEMEA BRONZE DN 2\" ( 50 mm )",150710,"ET-1A-07-400","pç",4,240.94,{"$f":"ROUND((G13*H13),2)","v":963.76}]
[null,10,"REGISTRO DE GAVETA CHATO C/ FLANGES E CABECOTE FOFO DN 150",150710,"ET-1A-07-400","pç",44,1386.86,{"$f":"ROUND((G14*H14),2)","v":61021.84}]
[null,11,"REGISTRO DE GAVETA C/ ROSCA FEMEA BRONZE DN 1\" ( 25 mm )",150710,"ET-1A-07-400","pç",45,190.55,8574.75]
[null,12,"VENTOSA SIMPLES C/ ROSCA FEMEA PVC DN 1\"",301172,"ET-1A-07-400","pç",44,557.80999999999995,24543.64]
[null,13,"KIT REGISTRO DE GAVETA C/ BOLSAS E CUNHA BORRACHA C/ CABECOTE DN 150 FOFO , COM CABEÇOTE PARA CHAVE T, CHAVE T, TAMPA REDONDA DN 100 MM E TOCO FOFO COM PONTAS DN 100 MM L=0,8M",150710,"ET-1A-07-400\n1552-D-ADU-HID-17-02","pç",1,1826.4,{"$f":"ROUND((G17*H17),2)","v":1826.4}]
[null,14,"REGISTRO DE GAVETA CHATO C/ FLANGES E CABECOTE FOFO DN 50",150710,"ET-1A-07-400","pç",3,370.85,{"$f":"ROUND((G18*H18),2)","v":1112.55}]
[null,15,"VENTOSA TRIPLICE FUNCAO C/ FLANGES PN 10 FOFO DN 50",301172,"ET-1A-07-400","pç",2,1076.54,2153.08]
[null,16,"KIT REGISTRO DE GAVETA C/ BOLSAS E CUNHA BORRACHA C/ CABECOTE DN 400 FOFO , COM CABEÇOTE PARA CHAVE T, CHAVE T, TAMPA REDONDA DN 100 MM E TOCO FOFO COM PONTAS DN 100 MM L= 0,5M",150710,"ET-1A-07-400\ne 1552-D-ADU-HID-14-04","pç",3,15041.57,{"$f":"ROUND((G20*H20),2)","v":45124.71}]
[null,17,"KIT REGISTRO DE GAVETA C/ BOLSAS E CUNHA BORRACHA C/ CABECOTE DN 600 FOFO , COM CABEÇOTE PARA CHAVE T, CHAVE T, TAMPA REDONDA DN 100 MM",150710,"ET-1A-07-400\ne 1552-D-ADU-HID-14-04","pç",1,42274.19,42274.19]
[null,18,"FLANGE C/ SEXTAVADO FOGO P/ PN10 DN 50",75426,"ET-1A-07-300","pç",6,48.86,{"$f":"ROUND((G22*H22),2)","v":293.16000000000003}]
[null,19,"TUBO C/ ROSCAS FOGO DN 50 L=1,50M",75426,"ET-1A-07-300","pç",7,236.43,1655.01]
[null,20,"NIPLE DUPLO FOGO DN 1\"",214170,"ET-1A-07-300","pç",45,6.7,301.5]
[null,21,"LUVA REDUCAO C/ ROSCAS FOGO DN 2\"x1\"",75426,"ET-1A-07-300","pç",1,24.67,24.67]
[null,22,"NIPLE DUPLO FOGO DN 2\"",214173,"ET-1A-07-300","pç",1,18.32,18.32]
[null,23,"TUBO C/ ROSCAS FOGO DN 50 L=1,00M",75426,"ET-1A-07-300","pç",1,176.58,176.58]
[null,24,"VALVULA BORBOLETA WAFER C/ CABECOTE FOFO DN 200",150526,"ET-1A-07-400","pç",1,2191,2191]
[null,null,"VALOR TOTAL DA PLANILHA",{"$nulls":5},{"$f":"SUM(I8:I28)","v":315977.69}]
[]
[null,"Obs.: No preço total estão inclusas todas as despesas de fabricação, testes, manuais e fornecimento do insumos no canteiro obras. "]

{"sheet":"Grupo_3_válvulas_control","index":2,"n_rows":12,"n_cols":9,"rows_kept":12,"cut":false,"hidden":false,"merged":[[11,1,11,7]]}
[]
[null,"PROJETO:","PROJETO DE IRRIGAÇÃO BAIXIO DE IRECÊ"]
[null,"LOCAL:","XIQUE-XIQUE / BA"]
[null,"CLIENTE:","CODEVASF"]
[null,null,"PLANILHA DE FORNECIMENTO (GRUPO 3)"]
[null,"ITEM","DESCRIÇÃO","CÓDIGO CATMAT","ESPEC TÉCN","UNID","QUANT","PÇ UNITÁRIO","PÇ TOTAL"]
[null,null,"FORNECIMENTO DE VALVULAS"]
[null,25,"VALVULA LIMITADORA DE VAZAO C/ FLANGES FOFO DN 80",39314,"ET-1A-07-310","pç",33,5775.73,{"$f":"ROUND((G8*H8),2)","v":190599.09}]
[null,26,"VALVULA LIMITADORA DE VAZAO C/ FLANGES FOFO DN 200",39314,"ET-1A-07-310","pç",1,8500,{"$f":"ROUND((G9*H9),2)","v":8500}]
[null,null,"VALOR TOTAL DA PLANILHA",{"$nulls":5},{"$f":"SUM(I8:I9)","v":199099.09}]
[]
[null,"Obs.: No preço total estão inclusas todas as despesas de fabricação, testes, manuais e fornecimento do insumos no canteiro obras. "]

{"sheet":"Item_27_Hidrometro","index":3,"n_rows":11,"n_cols":9,"rows_kept":11,"cut":false,"hidden":false,"merged":[[10,1,10,7]]}
[]
[null,"PROJETO:","PROJETO DE IRRIGAÇÃO BAIXIO DE IRECÊ"]
[null,"LOCAL:","XIQUE-XIQUE / BA"]
[null,"CLIENTE:","CODEVASF"]
[null,null,"PLANILHA DE FORNECIMENTO "]
[null,"ITEM","DESCRIÇÃO","CÓDIGO CATMAT","ESPEC TÉCN","UNID","QUANT","PÇ UNITÁRIO","PÇ TOTAL"]
[null,null,"FORNECIMENTO DE HIDROMETROS"]
[null,27,"HIDROMETRO C/ TURBINA TANGENCIAL HORIZONTAL DN 3\", C/ FLANGES",26395,"ET-1A-07-160","pç",33,1840,{"$f":"ROUND((G8*H8),2)","v":60720}]
[null,null,"VALOR TOTAL DA PLANILHA",{"$nulls":5},{"$f":"SUM(I8:I8)","v":60720}]
[]
[null,"Obs.: No preço total estão inclusas todas as despesas de fabricação, testes, manuais e fornecimento do insumos no canteiro obras. "]

{"sheet":"Item_28_Tampa","index":4,"n_rows":11,"n_cols":9,"rows_kept":11,"cut":false,"hidden":false,"merged":[[10,1,10,7]]}
[]
[null,"PROJETO:","PROJETO DE IRRIGAÇÃO BAIXIO DE IRECÊ"]
[null,"LOCAL:","XIQUE-XIQUE / BA"]
[null,"CLIENTE:","CODEVASF"]
[null,null,"PLANILHA DE FORNECIMENTO"]
[null,"ITEM","DESCRIÇÃO","CÓDIGO CATMAT","ESPEC TÉCN","UNID","QUANT","PÇ UNITÁRIO","PÇ TOTAL"]
[null,null,"FORNECIMENTO DE TAMPAS"]
[null,28,"TAMPA CHAPA XADREZ 1,00x1,45mx6,3mm C/ DOBRADIÇAS E CADEADO",126594,"1552-D-ADU-HID-26-05","unid",{"$f":"121-30-9","v":82},1889.76,{"$f":"ROUND((G8*H8),2)","v":154960.32000000001}]
[null,null,"VALOR TOTAL DA PLANILHA",{"$nulls":5},{"$f":"SUM(I8:I8)","v":154960.32000000001}]
[]
[null,"Obs.: No preço total estão inclusas todas as despesas de fabricação, testes, manuais e fornecimento do insumos no canteiro obras. "]

{"sheet":"Grupo_4_peças_de_FoFo","index":5,"n_rows":54,"n_cols":9,"rows_kept":54,"cut":false,"hidden":false,"merged":[[53,1,53,7]]}
[]
[null,"PROJETO:","PROJETO DE IRRIGAÇÃO BAIXIO DE IRECÊ"]
[null,"LOCAL:","XIQUE-XIQUE / BA"]
[null,"CLIENTE:","CODEVASF"]
[null,null,"PLANILHA DE FORNECIMENTO (GRUPO 4)"]
[null,"ITEM","DESCRIÇÃO","CÓDIGO CATMAT","ESPEC TÉCN","UNID","QUANT","PÇ UNITÁRIO","PÇ TOTAL"]
[null,null,"FORNECIMENTO DE PEÇAS DE FOFO"]
[null,29,"REDUCAO PONTA E BOLSA JE FOFO 200x150",38580,"ET-1A-07-300","pç",14,293.38,{"$f":"ROUND((G8*H8),2)","v":4107.32}]
[null,30,"REDUCAO PONTA E BOLSA JE FOFO 250x150 ",38580,"ET-1A-07-300","pç",1,393.62,{"$f":"ROUND((G9*H9),2)","v":393.62}]
[null,31,"REDUCAO PONTA E BOLSA JE FOFO 300x150 ",38580,"ET-1A-07-300","pç",{"$f":"8-1","v":7},472.92,3310.44]
[null,32,"REDUCAO PONTA E BOLSA JE FOFO 300x250",38580,"ET-1A-07-300","pç",{"$f":"4-2","v":2},544.74,1089.48]
[null,33,"CURVA 45 FOFO C/ BOLSAS PN10 DN 600",38580,"ET-1A-07-300","pç",2,5014.4799999999996,10028.959999999999]
[null,34,"TUBO FOFO C/ PONTA E FLANGE PN10 DN 600 L=4,00 m",38580,"ET-1A-07-300","pç",1,9560.16,9560.16]
[null,35,"TUBO FOFO C/ PONTAS PN10 DN 600 L=4,45 m",38580,"ET-1A-07-300","pç",1,10285.549999999999,10285.549999999999]
[null,36,"TUBO FOFO C/ PONTA E BOLSA PN10 DN 600 L=6,00 m ",38580,"ET-1A-07-300","pç",5,9825.16,49125.8]
[null,37,"TUBO FOFO C/ PONTAS PN10 DN 600 L=6,00 m",38580,"ET-1A-07-300","pç",1,12013.12,12013.12]
[null,38,"TE C/ BOLSAS JGS E FLANGE PN-10 DN 300x100 FOFO",38580,"ET-1A-07-300","pç",4,981.88,3927.52]
[null,39,"TE C/ BOLSAS JGS E FLANGE PN-10 DN 400x100 FOFO",38580,"ET-1A-07-300","pç",2,1435.78,2871.56]
[null,40,"TE C/ BOLSAS JGS E FLANGE PN-10 DN 600x100 FOFO",38580,"ET-1A-07-300","pç",1,3604.37,3604.37]
[null,41,"TUBO C/ FLANGES FOFO PN10 DN 100 L=1,25 m",38580,"ET-1A-07-300","pç",2,1001.86,2003.72]
[null,42,"TUBO C/ FLANGES FOFO PN10 DN 100 L=1,26 m",38580,"ET-1A-07-300","pç",5,1109.68,5548.4]
[null,43,"TOCO C/ PONTAS L=0,40M FOFO DN 100",38580,"ET-1A-07-300","pç",1,213.76,213.76]
[null,44,"TUBO FOFO C/ PONTAS PN10 DN 100 L=0,65 m",38580,"ET-1A-07-300","pç",1,561.6,561.6]
[null,45,"TUBO C/ FLANGES FOFO PN10 DN 100 L=1,00 m",38580,"ET-1A-07-300","pç",6,904.76,5428.56]
[null,46,"TE C/ 2 BOLSAS E FLANGE, PN10 FOFO DN 150X50 mm",38580,"ET-1A-07-300","pç",3,367.69,1103.07]
[null,47,"TE C/ 2 BOLSAS E FLANGE, PN10 FOFO DN 200X50 mm",38580,"ET-1A-07-300","pç",3,496.43,1489.29]
[null,48,"TUBO C/ FLANGES FOFO PN10 DN 100 L=1,50 m",38580,"ET-1A-07-300","pç",4,1054.3800000000001,4217.5200000000004]
[null,49,"CURVA C90 C/ FLANGES PN-10 FOFO DN 150",38580,"ET-1A-07-300","pç",45,380.15,17106.75]
[null,50,"EXTREMIDADE FLANGE E BOLSA FOFO DN 150",38580,"ET-1A-07-300","pç",44,236.75,10417]
[null,51,"FLANGE CEGO FOFO DN 150 ",38580,"ET-1A-07-300","pç",44,150.37,6616.28]
[null,52,"TE C/ FLANGES PN-10 FOFO DN 150X150 ",38580,"ET-1A-07-300","pç",44,516.35,22719.4]
[null,53,"TUBO C/ FLANGES FOFO PN 10 DN 150 L=0,70m ",38580,"ET-1A-07-300","pç",36,1036.3699999999999,37309.32]
[null,54,"TUBO C/ FLANGES FOFO PN10 DN 150 L=0,80 m ",38580,"ET-1A-07-300","pç",44,1162.6600000000001,51157.04]
[null,55,"TOCO C/ FLANGES L=0,25M FOFO DN 80",38580,"ET-1A-07-300","pç",33,255.32,8425.56]
[null,56,"TUBO C/ FLANGES FOFO PN10 DN 80 L=0,70 m ",38580,"ET-1A-07-300","pç",74,772.09,57134.66]
[null,57,"CAP C/ JE JGS FOFO DN 150",38580,"ET-1A-07-300","pç",1,141.88,141.88]
[null,58,"COLAR DE TOMADA C/ FEMEA DN 2\" FOFO DN 150",38580,"ET-1A-07-300","pç",1,61.65,61.65]
[null,59,"TUBO FOFO C/ PONTAS PN10 DN 100 L=0,80 m",38580,"ET-1A-07-300","pç",1,267.67,267.67]
[null,60,"CURVA C90 C/ FLANGES PN-10 FOFO DN 200",38580,"ET-1A-07-300","pç",2,527.44000000000005,1054.8800000000001]
[null,61,"EXTREMIDADE FLANGE E BOLSA JGS FOFO DN 200",38580,"ET-1A-07-300","pç",1,345.92,345.92]
[null,62,"REDUCAO PONTA E BOLSA JE FOFO 300x200",38580,"ET-1A-07-300","pç",1,499.36,499.36]
[null,63,"TE C/ FLANGES PN-10 FOFO DN 200X50 ",38580,"ET-1A-07-300","pç",1,666.38,666.38]
[null,64,"TOCO C/ PONTAS L=0,50M FOFO DN 200",38580,"ET-1A-07-300","pç",1,536.52,536.52]
[null,65,"TUBO C/ FLANGES FOFO PN 10 DN 200 L=0,70m ",38580,"ET-1A-07-300","pç",2,1315.69,2631.38]
[null,66,"TUBO C/ FLANGES FOFO PN 10 DN 200 L=1,10m ",38580,"ET-1A-07-300","pç",1,1555.65,1555.65]
[null,67,"LUVA DE CORRER COM BOLSAS FOFO DN 300",38580,"ET-1A-07-300","pç",1,613.41999999999996,613.41999999999996]
[null,68,"REDUCAO PONTA E BOLSA JE FOFO 600x500",38580,"ET-1A-07-300","pç",1,3470,3470]
[null,69,"TUBO C/ FLANGES FOFO PN10 DN 100 L=1,24 m",38580,"ET-1A-07-300","pç",1,1030.32,1030.32]
[null,70,"REDUCAO PONTA E BOLSA JE FOFO 400x300",38580,"ET-1A-07-300","pç",1,1011.56,1011.56]
[null,71,"Toco c/ pontas pn 10 L= 0,5 m FoFo DN 100",38580,"ET-1A-07-300","un.",2,261.74,523.48]
[null,72,"FLANGE CEGO AÇO CARBONO #1/2\" DN 150 PN 10 COM ORÍFÍCO COM ROSCA DN 25",100420,"ET-1A-500-01","pç",{"$f":"45-1","v":44},1252.68,55117.919999999998]
[null,null,"VALOR TOTAL DA PLANILHA",{"$nulls":5},{"$f":"SUM(I8:I51)","v":411297.81999999995}]
[]
[null,"Obs.: No preço total estão inclusas todas as despesas de fabricação, testes, manuais e fornecimento do insumos no canteiro obras. "]

{"sheet":"Grupo_5_peças_de_PVC","index":6,"n_rows":26,"n_cols":9,"rows_kept":26,"cut":false,"hidden":false,"merged":[[25,1,25,7]]}
[]
[null,"PROJETO:","PROJETO DE IRRIGAÇÃO BAIXIO DE IRECÊ"]
[null,"LOCAL:","XIQUE-XIQUE / BA"]
[null,"CLIENTE:","CODEVASF"]
[null,null,"PLANILHA DE FORNECIMENTO (GRUPO 5)"]
[null,"ITEM","DESCRIÇÃO","CÓDIGO CATMAT","ESPEC TÉCN","UNID","QUANT","PÇ UNITÁRIO","PÇ TOTAL"]
[null,null,"FORNECIMENTO DE PEÇAS DE PVC"]
[null,73,"TUBO PVC DEFOFO PN 60 JEI DN 150",38814,"ET-1A-07-300","m",396,74.150000000000006,{"$f":"ROUND((G8*H8),2)","v":29363.4}]
[null,74,"TUBO PVC DEFOFO PN 60 JEI DN 200",274244,"ET-1A-07-300","m",775,92,{"$f":"ROUND((G9*H9),2)","v":71300}]
[null,75,"TUBO PVC DEFOFO PN 60 JEI DN 250",274244,"ET-1A-07-300","m",539,145.66,{"$f":"ROUND((G10*H10),2)","v":78510.740000000005}]
[null,76,"TUBO PVC DEFOFO PN 60 JEI DN 300",274243,"ET-1A-07-300","m",2368,189.34,{"$f":"ROUND((G11*H11),2)","v":448357.12}]
[null,77,"TOCO C/ PONTAS PVC DEFOFO L=0,50m DN 150 PN 60",38814,"ET-1A-07-300","pç",8,95,{"$f":"ROUND((G12*H12),2)","v":760}]
[null,78,"TOCO C/ PONTAS PVC DEFOFO L=0,50m DN 200 PN 60",274244,"ET-1A-07-300","pç",1,148.5,148.5]
[null,79,"TOCO C/ PONTAS PVC DEFOFO L=0,50m DN 250 PN 60",274244,"ET-1A-07-300","pç",2,174.4,348.8]
[null,80,"TUBO PONTA E BOLSA JE PVC DEFOFO L=3,00 m DN 150 PN 60",38814,"ET-1A-07-300","pç",20,208.4,4168]
[null,81,"TUBO PONTA E BOLSA JE PVC DEFOFO L=6,00 m DN 150 PN 60",38814,"ET-1A-07-300","pç",12,389.3,4671.6000000000004]
[null,82,"TUBO C/ PONTAS PVC DEFOFO L=3,00m DN 150 PN 60",38814,"ET-1A-07-300","pç",11,234.35,2577.85]
[null,83,"TUBO C/ PONTAS PVC DEFOFO L=6,00m DN 150 PN 60",38814,"ET-1A-07-300","pç",5,441.25,2206.25]
[null,84,"TOCO C/ PONTAS PVC DEFOFO L=0,50m DN 300 PN 60",274243,"ET-1A-07-300","pç",4,200,{"$f":"ROUND((G19*H19),2)","v":800}]
[null,85,"TUBO C/ PONTAS PVC DEFOFO L=1,50m DN 300 PN 60",274243,"ET-1A-07-300","pç",1,300,300]
[null,86,"TUBO PONTA E BOLSA JE PVC DEFOFO L=1,00 m DN 300 PN 60",38814,"ET-1A-07-300","pç",1,260.33999999999997,260.33999999999997]
[null,87,"TUBO C/ PONTAS PVC DEFOFO L=2,00m DN 150 PN 60",38814,"ET-1A-07-300","pç",1,162.5,{"$f":"ROUND((G22*H22),2)","v":162.5}]
[null,88,"TOCO C/ PONTAS PVC DEFOFO L=0,40m DN 100 PN 60",38814,"ET-1A-07-300","pç",1,43.75,{"$f":"ROUND((G23*H23),2)","v":43.75}]
[null,null,"VALOR TOTAL DA PLANILHA",{"$nulls":5},{"$f":"SUM(I8:I23)","v":643978.85}]
[]
[null,"Obs.: No preço total estão inclusas todas as despesas de fabricação, testes, manuais e fornecimento do insumos no canteiro obras. "]

{"sheet":"Grupo_6_peças_de_PRFV","index":7,"n_rows":53,"n_cols":9,"rows_kept":53,"cut":false,"hidden":false,"merged":[[52,1,52,7]]}
[]
[null,"PROJETO:","PROJETO DE IRRIGAÇÃO BAIXIO DE IRECÊ"]
[null,"LOCAL:","XIQUE-XIQUE / BA"]
[null,"CLIENTE:","CODEVASF"]
[null,null,"PLANILHA DE FORNECIMENTO (GRUPO 6)"]
[null,"ITEM","DESCRIÇÃO","CÓDIGO CATMAT","ESPEC TÉCN","UNID","QUANT","PÇ UNITÁRIO","PÇ TOTAL"]
[null,null,"FORNECIMENTO DE PEÇAS DE PRFV"]
[null,89,"TUBO PRFV AGUA PN10 DN 400",465086,"ET-1A-07-300","m",1401,333.73,{"$f":"ROUND((G8*H8),2)","v":467555.73}]
[null,90,"TUBO PRFV AGUA PN10 DN 600",465086,"ET-1A-07-300","m",1526,629.38,960433.88]
[null,91,"CRUZETA XR PRFV/JE PBPP 250x150 PN10",465086,"ET-1A-07-300","pç",1,1239.57,1239.57]
[null,92,"CRUZETA PRFV JE BOLSA E PONTAS 300x150 PN10",465086,"ET-1A-07-300","pç",2,1432.39,2864.78]
[null,93,"CURVA PRFV 45º BOLSA JE E PONTA DN 150 PN10",465086,"ET-1A-07-300","pç",3,435,1305]
[null,94,"CURVA PRFV 45º BOLSA JE E PONTA DN 200 PN10",465086,"ET-1A-07-300","pç",1,496,496]
[null,95,"CURVA PRFV 45º BOLSA JE E PONTA DN 300 PN10",465086,"ET-1A-07-300","pç",1,725,725]
[null,96,"LUVA DE CORRER PRFV DN 200 PN10",465086,"ET-1A-07-300","pç",{"$f":"8-4","v":4},280.12,1120.48]
[null,97,"LUVA DE CORRER PRFV DN 300 PN10",465086,"ET-1A-07-300","pç",{"$f":"4-1","v":3},442.62,1327.86]
[null,98,"REDUCAO PRFV JE BOLSA E PONTA 300x200 PN10",465086,"ET-1A-07-300","pç",3,896.1,2688.3]
[null,99,"REDUCAO PRFV JE BOLSA E PONTA 400x300 PN10",465086,"ET-1A-07-300","pç",{"$f":"5-2","v":3},1334.13,4002.39]
[null,100,"REDUCAO PRFV JE BOLSA E PONTA 500x400 PN10",465086,"ET-1A-07-300","pç",{"$f":"6-1","v":5},1873.18,9365.9]
[null,101,"REDUCAO PRFV JE BOLSA E PONTA 600x500 PN10",465086,"ET-1A-07-300","pç",1,2282,2282]
[null,102,"TE PRFV JE BOLSAS E PONTA 300x200 PN10",465086,"ET-1A-07-300","pç",{"$f":"8-1","v":7},1114.0999999999999,7798.7]
[null,103,"TE PRFV JE BOLSAS E PONTA 400x200 PN10",465086,"ET-1A-07-300","pç",1,1432.88,1432.88]
[null,104,"TE PRFV JE BOLSAS E PONTA 500x300 PN10",465086,"ET-1A-07-300","pç",{"$f":"4-1","v":3},2179,6537]
[null,105,"TE PRFV JE BOLSAS E PONTA 600x300 PN10",465086,"ET-1A-07-300","pç",3,2903,8709]
[null,106,"TE PRFV JE BOLSAS E PONTA 600x400 PN10",465086,"ET-1A-07-300","pç",1,3289,3289]
[null,107,"TOCO C/ PONTAS PRFV L=0,50m DN 400 PN10",465086,"ET-1A-07-300","pç",{"$f":"10-1","v":9},747.7,{"$f":"ROUND((G26*H26),2)","v":6729.3}]
[null,108,"TOCO C/ PONTAS PRFV L=0,50m DN 600 PN10",465086,"ET-1A-07-300","pç",4,1098.04,4392.16]
[null,109,"TUBO JE C/ PONTA E BOLSA PRFV L=1,0m DN 600 PN10",465086,"ET-1A-07-300","pç",1,1904.58,1904.58]
[null,110,"TUBO C/ PONTAS PRFV L=1,50m DN 400 PN10",465086,"ET-1A-07-300","pç",1,1616,1616]
[null,111,"CRUZETA PRFV JE BOLSA E PONTAS 500x150 PN10",465086,"ET-1A-07-300","pç",3,2040,{"$f":"ROUND((G30*H30),2)","v":6120}]
[null,112,"CRUZETA PRFV JE BOLSA E PONTAS 600x150 PN10",465086,"ET-1A-07-300","pç",1,2637,2637]
[null,113,"CURVA PRFV 22º BOLSA JE E PONTA DN 600 PN10",465086,"ET-1A-07-300","pç",1,1377.82,1377.82]
[null,114,"TE PRFV JE BOLSAS E PONTA 200x150 PN10",465086,"ET-1A-07-300","pç",4,622.91999999999996,2491.6799999999998]
[null,115,"TE PRFV JE BOLSAS E PONTA 300x300 PN10",465086,"ET-1A-07-300","pç",{"$f":"2-1","v":1},1148,1148]
[null,116,"TE PRFV JE BOLSAS E PONTA 400x300 PN10",465086,"ET-1A-07-300","pç",1,1672,1672]
[null,117,"TOCO C/ PONTA E BOLSA PRFV L=0,50m DN 600 PN10",465086,"ET-1A-07-300","pç",1,1216.18,{"$f":"ROUND((G36*H36),2)","v":1216.18}]
[null,118,"TUBO PRFV AGUA PN10 DN 500",465086,"ET-1A-07-300","m",31,428.75,{"$f":"ROUND((G37*H37),2)","v":13291.25}]
[null,119,"CURVA PRFV 90º BOLSA JE E PONTA DN 400 PN10",465086,"ET-1A-07-300","pç",1,1219,1219]
[null,120,"REDUCAO PRFV JE BOLSA E PONTA 300x150 PN10",465086,"ET-1A-07-300","pç",3,854,2562]
[null,121,"REDUCAO PRFV JE BOLSA E PONTA 250x150 PN10",465086,"ET-1A-07-300","pç",{"$f":"2-1","v":1},720,720]
[null,122,"REDUCAO PRFV JE BOLSA E PONTA 250x200 PN10",465086,"ET-1A-07-300","pç",1,688,688]
[null,123,"TE PRFV JE BOLSAS E PONTA 200x200 PN10",465086,"ET-1A-07-300","pç",1,731,731]
[null,124,"TE PRFV JE BOLSAS E PONTA 250x250 PN10",465086,"ET-1A-07-300","pç",{"$f":"5-1","v":4},975,3900]
[null,125,"TE PRFV JE BOLSAS E PONTA 300x150 PN10",465086,"ET-1A-07-300","pç",1,885.96,885.96]
[null,126,"TE PRFV JE BOLSAS E PONTA 500x500 PN10",465086,"ET-1A-07-300","pç",1,2695,2695]
[null,127,"REDUCAO PRFV JE BOLSA E PONTA 400x250 PN10",465086,"ET-1A-07-300","pç",1,1282,1282]
[null,128,"CRUZETA PRFV BOLSA JE, PONTA, PONTA, PONTA 400x150 PN10",465086,"ET-1A-07-300","pç",{"$f":"5-3","v":2},1606,3212]
[null,129,"TE PRFV BOLSA JE, PONTA E BOLSA JE 400x400 PN10",465086,"ET-1A-07-300","pç",{"$f":"2-1","v":1},1857,1857]
[null,130,"TOCO PRFV C/ PONTAS L=0,50m DN 500 PN10",465086,"ET-1A-07-300","pç",{"$f":"2-1","v":1},957.65,957.65]
[]
[null,null,"VALOR TOTAL DA PLANILHA",{"$nulls":5},{"$f":"SUM(I8:I49)","v":1548479.0499999996}]
[]
[null,"Obs.: No preço total estão inclusas todas as despesas de fabricação, testes, manuais e fornecimento do insumos no canteiro obras. "]