{"text_format":"2","workbook":"xls","n_sheets":12,"sheets":["Erros e Omissões","À pedido","Critério de Pagamento","PLANILHA DE IMPLANTAÇÃO","Quadro","CBUQ faixa C","Usinagem Faixa C","CBUQ faixa B","Usinagem Faixa B","Base BGS","Usinagem BGS","Cerca"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":1,"defined_names":237,"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","formulas":"cached_only"}

{"sheet":"Erros e Omissões","index":0,"n_rows":70,"n_cols":12,"rows_kept":70,"cut":false,"hidden":false,"merged":[[1,10,2,10],[1,11,2,11],[0,0,0,11],[1,3,2,3],[69,5,69,8],[1,0,2,0],[1,1,2,1],[1,2,2,2],[1,4,1,6],[1,7,1,9]],"flags":["formulas_cached_only"]}
["TABELA I - PLANILHA COM ALTERAÇÃO DE QUANTITATIVOS - 1ª RPFO -  MOTIVO: ERROS & OMISSÕES"]
["Item","DISCRIMINAÇÃO DOS SERVIÇOS ","UND.","PREÇOS UNITARIOS (ADMINISTRAÇÃO)","QUANTIDADE",null,null,"CUSTO TOTAL  (R$)",null,null,"DIFERENÇA COM DEFLATOR","CÓD. CRITÉRIO DE PAGTO"]
[{"$nulls":4},"LICITAÇÃO","1ª RPFO","DIFERENÇA","LICITAÇÃO","1ª RPFO","DIFERENÇA"]
["1.0","TERRAPLENAGEM"]
["1.3","Esc. carga transp. mat 1ª cat. DMT 50 m","m3",1.44,24776,29830.98,5054.98,35677.439999999995,42956.6112,7279.171200000004,6357.737313648004,83059]
["1.4","Esc. carga transp. mat 1ª cat DMT 50 a 200m c/e","m3",4.99,59413,67696.1,8283.100000000006,296470.87,337803.53900000005,41332.66900000005,36100.573094635045,83059]
["1.5","Esc. carga transp. mat 1ª cat DMT 200 a 400m c/e","m3",5.42,69770,84052.24,14282.240000000005,378153.4,455563.1408,77409.74079999997,67610.82876083197,83059]
["1.6","Esc. carga transp. mat 1ª cat DMT 400 a 600m c/e","m3",5.86,79565,93316.72,13751.720000000001,466250.9,546835.9792000001,80585.07920000004,70384.21694946803,83059]
["1.7","Esc. carga transp. mat 1ª cat DMT 600 a 800m c/e","m3",6.26,90902,115508.24,24606.240000000005,569046.52,723081.5824,154035.06239999994,134536.53402609593,83059]
["1.8","Esc. carga transp. mat 1ª cat DMT 800 a 1000m c/e","m3",6.63,12310,17988.28,5678.279999999999,81615.3,119262.29639999999,37646.99639999999,32881.451360705985,83059]
["1.9","Esc. carga transp. mat 1ª cat DMT 1000 a 1200m c/e","m3",7.01,41710,47525.29,5815.290000000001,292387.1,333152.2829,40765.182900000014,35604.92222260351,83059]
["1.10","Esc. carga transp. mat 1ª cat DMT 1200 a 1400m c/e","m3",7.36,10375,13919.5,3544.5,76360,102447.52,26087.520000000004,22785.231280800002,83059]
["1.11","Esc. carga transp. mat 1ª cat DMT 1400 a 1600m c/e","m3",7.64,44932,63324.5,18392.5,343280.48,483799.18,140518.7,122731.14036050001,83059]
["1.12","Esc. carga transp. mat 1ª cat DMT 1600 a 1800m c/e","m3",7.78,45257,68207.82,22950.820000000007,352099.46,530656.8396000001,178557.37960000004,155954.69370333402,83059]
["1.13","Esc. carga transp. mat 1ª cat DMT 1800 a 2000m c/e","m3",8.36,16159,18411.91,2252.91,135089.24,153923.56759999998,18834.32759999999,16450.18424075399,83059]
["1.14","Esc. carga transp. mat 1ª cat DMT 2000 a 3000m c/e","m3",9.39,171632,231889.38,60257.380000000005,1611624.48,2177441.2782,565816.7982000001,494192.87879985303,83059]
["1.15","Esc. carga transp. mat 1ª cat DMT 3000 a 5000m c/e","m3",12.5,594772,649655.29,54883.29000000004,7434650,8120691.125,686041.125,599198.609191875,83059]
["1.16","Transp. local c/ basc. 10m3 rodov. não pav (const)","t/km",0.74,1263643.2,1458398.82,194755.6200000001,935095.968,1079215.1268,144119.15879999998,125875.83508330196,83059]
["1.17","Transp. local c/ basc. 10m3 rodov. não pav (const)","t/km",0.74,649824,740423.74,90599.73999999999,480869.76,547913.5676,67043.80759999994,58557.067214953946,83059]
["1.23","Esc. carga transp. mat 3ª cat DMT até 50m","m3",25.79,64,640.25,576.25,1650.56,16512.0475,14861.487500000001,12980.2461048125,83059]
["1.24","Esc. carga transp. mat 3ª cat DMT 400 a 600m","m3",32.2,5600,5124.75,-475.25,180320.00000000003,165016.95,-15303.050000000017,-13365.913415750014,83059]
["1.25","Compactação de aterros a 95% do proctor normal","m3",2.38,457519,596325.66,138806.66000000003,1088895.22,1419255.0708,330359.85080000013,288541.2490864821,83060]
["1.27","Contrução de corpo de aterro em rocha","m3",6.75,5664,5765,101,38232,38913.75,681.75,595.45067625,83060]
["1.28","Compactação de material de \"bota-fora\"","m3",1.88,174590,160877,-13713,328229.19999999995,302448.76,-25780.439999999944,-22517.023002599948,93008]
["1.31","Esc. carga transp. solos moles DMT 800 a 1000m","m3",18.53,22584,79147.15,56563.149999999994,418481.52,1466596.6895,1048115.1695000001,915439.5107688425,93010]
["1.33","Transp. local c/ basc. 10m3 rodov. não pav (const), (1,86km)","t/km",0.74,0,168331.93,168331.93,0,124565.62819999999,124565.62819999999,108797.48815430299,83059]
["PN","Esc. carga transp. Areia - camada drenante (60,39km)","m3",89.9,0,65047.6225,65047.6225,0,5847781.26275,5847781.26275,5107539.871604791,93009]
[{"$nulls":8},"TOTAL DA FAMÍLIA TERRAPLENAGEM",9591354.37745,8377232.783580491]
[]
["2.0","DRENAGEM E OAC"]
["2.2","Enrocamento de pedra arrumada","m3",131.23,7742.5,1415.2,-6327.3,1016048.2749999999,185716.696,-830331.5789999999,-725224.0560722848,93011]
["2.3","DRENAGEM SUPERFICIAL"]
["2.3.1","Valeta prot.cortes c/revest.concreto - VPC 03","m",103.92,240,635,395,24940.8,65989.2,41048.399999999994,35852.288285999995,84040]
["2.3.5","Sarjeta Triangular de Concreto - STC 03","m",36.9,43374.3,3518.32,-39855.98,1600511.6700000002,129826.008,-1470685.6620000002,-1284518.9174757302,84040]
["2.3.7","Meio fio de concreto - MFC 01","m",65.39,13590,0,-13590,888650.1,0,-888650.1,-776160.3270914999,84040]
["PN","Meio fio de concreto - MFC 03","m",31.5,null,13590,13590,null,428085,428085,373895.860275,84040]
["2.4","DRENAGEM SUBTERRÂNEA"]
["2.4.1","Dreno longitudinal prof. p/corte em rocha - DPR 02","m",59.95,555,340,-215,33272.25,20383,-12889.25,-11257.664288749998,151152]
["2.4.2","Boca saída p/dreno longitudinal prof. BSD 02","unid",223.45,4,2,-2,893.8,446.9,-446.9,-390.32916349999994,151152]
["2.4.3","Lastro de brita - Colchão Drenante","m3",84.44,1230,870.4,-359.6,103861.2,73496.576,-30364.623999999996,-26520.918070959993,151152]
["2.5","OAC"]
["2.5.1","Corpo BSTC Ø 0,80 ","m",524.44,43,169,126,22550.920000000002,88630.36000000002,66079.44000000002,57714.77408760001,132573]
["2.5.4","Corpo BDTC Ø 1,00 ","m",1492.3733962602673,18,37,19,26862.721132684812,55217.815661629895,28355.094528945083,24765.764887998568,132573]
["2.5.7","Boca BSTC Ø 0,80m - normal","unid",1370.6424213050543,4,18,14,5482.569685220217,24671.563583490977,19188.99389827076,16759.955105658155,132573]
["2.5.10","Boca BDTC Ø 1,00m - normal","unid",2948.489265590752,2,4,2,5896.978531181504,11793.957062363008,5896.978531181504,5150.5095038118925,132573]
["2.5.15","Corpo BSCC 2,00 x 2,00m alt. 0 a 1,00m","m",2304.5759690634613,20,0,-20,46091.51938126923,0,-46091.51938126923,-40257.02440039126,132573]
["2.5.18","Corpo BDCC 2,00 x 2,00m alt. 0 a 1,00m","m",4038.562970653826,88,90,2,355393.5414175367,363470.66735884437,8077.125941307691,7054.6829540272565,132573]
["2.5.23","Corpo BTCC 1,50 x 1,50m alt. 0 a 1,00m","m",3829.979782526776,55,0,-55,210648.88803897268,0,-210648.88803897268,-183983.89854655933,132573]
["2.5.27","Corpo BTCC 3,00 x 3,00m alt. 0 a 1,00m","m",9785.795617673419,73,51,-22,714363.0800901596,499075.57650134433,-215287.50358881522,-188035.33494702503,132573]
["2.5.29","Corpo BTCC 3,00 x 3,00m alt. 2,50 a 5,00m","m",10830.300135542573,34,30,-4,368230.2046084475,324909.0040662772,-43321.20054217032,-37837.38637153969,132573]
["2.5.31","Boca BSCC 2,00 x 2,00m -esc. = 30","unid",15881.506159921415,2,0,-2,31763.01231984283,0,-31763.01231984283,-27742.291405335523,132573]
["2.5.41","Boca BTCC 3,00 x 3,00m - normal","unid",40643.488762071676,10,8,-2,406434.88762071676,325147.9100965734,-81286.97752414335,-70997.26547424967,132573]
[{"$nulls":8},"TOTAL DA FAMÍLIA DRENAGEM E OAC",-3265036.1834955085,-2851731.5782077294]
[]
["4.0","PAVIMENTAÇÃO"]
["4.4","Sub-base solo estabilizado granul. s/ mistura","m³",44.70995674036256,137765.4,129487.5,-8277.899999999994,6159485.074318743,5789380.523417696,-370104.55090104695,-323254.8663252379,8440]
["4.5","Sub base de macadame ","m³",82.92,null,16555.8,16555.8,0,1372806.936,1372806.936,1199030.17000644,8440]
["4.6","Base de brita graduada","m³",112.6790820374992,132983.27,null,-132983.27,14984432.789944906,0,-14984432.789944906,-13087628.36522973,93012]
["PN","Base de brita graduada 1ªRPFO",null,106.43,null,132983.27,132983.27,0,14153409.426099999,14153409.426099999,12361800.09389713,93012]
["4.9","CBUQ FX C ","t",96.1239092288331,47627.41,null,-47627.41,4578132.835644418,0,-4578132.835644418,-3998609.890644369,93014]
["PN","CBUQ FX C 1ª RPFO",null,94.41,null,47627.41,47627.41,0,4496503.7781,4496503.7781,3927313.847349211,93014]
["4.10","CBUQ FX B","t",79.16909434874478,119734.07,null,-119734.07,9479237.884589212,0,-9479237.884589212,-8279308.556968486,93013]
["PN","CBUQ FX B 1ª RPFO",null,79.22,null,119734.07,119734.07,0,9485333.0254,9485333.0254,8284632.144379741,93013]
[{"$nulls":8},"TOTAL DA FAMÍLIA PAVIMENTAÇÃO",96145.10452041589,83974.57646469904]
[]
[{"$nulls":8},"TOTAL RPFO (ERROS & OMISSÕES)",6422463.298474908,5609475.781837461]
[]
[{"$nulls":8},"DEFLATOR (DESCONTO = 12,6585%)",0.8734149999999999]
[]
[{"$nulls":5},"Valor Contratado (PI)",null,null,null,100660000]

{"sheet":"À pedido","index":1,"n_rows":23,"n_cols":12,"rows_kept":23,"cut":false,"hidden":false,"merged":[[1,10,2,10],[1,11,2,11],[22,5,22,8],[1,0,2,0],[1,1,2,1],[1,2,2,2],[1,3,2,3],[1,4,1,6],[1,7,1,9]],"flags":["formulas_cached_only"]}
["TABELA II - PLANILHA COM ALTERAÇÃO DE QUANTIDADES - 1ª RPFO -  MOTIVO: A PEDIDO DA ADMINISTRAÇÃO"]
["Item","DISCRIMINAÇÃO DOS SERVIÇOS ","UND.","PREÇOS UNITARIOS (ADMINISTRAÇÃO)","QUANTIDADE",null,null,"CUSTO TOTAL  (R$) (Preço Administração)",null,null,"DIFERENÇA COM DEFLATOR","CÓD. CRITÉRIO DE PAGTO"]
[{"$nulls":4},"LICITAÇÃO","1ª RPFO","DIFERENÇA","LICITAÇÃO","1ª RPFO","DIFERENÇA"]
["1.0","TERRAPLENAGEM"]
["1.15","Esc. carga transp. mat 1ª cat DMT 3000 a 5000m c/e","m3",12.5,594772,692501.99,97729.98999999999,7434650,8656274.875,1221624.875,1066985.490198125,83059]
["1.25","Compactação de aterros a 95% do proctor normal","m3",2.38,457519,595244.76,137725.76,1088895.22,1416682.5288,327787.3088,286294.352315552,83060]
[{"$nulls":8},"TOTAL DA FAMÍLIA TERRAPLENAGEM",1549412.1838,1353279.842513677]
[]
["6.0","OBRAS COMPLEMENTARES"]
["6.1","Balizadores para Defensa Metálica","un.",5.724872673123519,3513.5,3513.5,null,20114.340137019484,20114.340137019484,0]
["6.2","Defensa semi-maleável simples (forn./ impl.)","m",192.03800637016957,14054,14054,null,2698902.1415263633,2698902.1415263633,0]
["6.3","Ancoragem defensa semi-maleável simples (forn/imp)","m",213.29896456983246,1368,1368,null,291792.98353153083,291792.98353153083,0]
["6.4","Cercas de arame farpado com suportes de madeira","m",17.544286935436123,137390.45,50990.45,-86400.00000000001,2410417.47698869,894591.0857670088,-1515826.3912216811,-1323945.5074888845,70020]
["PN","Cercas de arame farpado com suportes de madeira - 8 fios","m",21.02,null,86240,86240,0,1812764.8,1812764.8,1583295.967792,70020]
["6.6","Remoção de cercas","m",5.944675812405748,126767.41999999998,126767.41999999998,null,753591.2154750805,753591.2154750805,0]
["6.7","Abrigo de ônibus","un.",9021.090505058757,8,8,null,72168.72404047006,72168.72404047006,0]
[{"$nulls":8},"TOTAL DA FAMÍLIA OBRAS COMPLEMENTARES",296938.4087783189,259350.46030311543]
[]
[{"$nulls":8},"TOTAL RPFO (À PEDIDO DA ADMINISTRAÇÃO)",1846350.592578319,1612630.3028167924]
[]
[{"$nulls":8},"DEFLATOR (DESCONTO = 12,6585%)",0.8734149999999999]
[]
[{"$nulls":5},"Valor Contratado (PI)",null,null,null,100660000]

{"sheet":"Critério de Pagamento","index":2,"n_rows":111,"n_cols":12,"rows_kept":111,"cut":false,"hidden":false,"merged":[[1,11,2,11],[1,9,1,10],[110,6,110,9],[0,0,0,9],[1,3,1,5],[1,6,1,8],[1,0,2,0],[1,1,2,1],[1,2,2,2]],"flags":["formulas_cached_only"]}
["TABELA III - CRITÉRIO DE PAGAMENTO - 1ª RPFO"]
["Código","Item","Unid","CONTRATO",null,null,"1ª RPFO",null,null,"VARIAÇÃO",null,"CLASSE"]
["Código","Serviço","Unid","Qtde","Preço Unit.","Preço Total","Qtde","Preço Unit.","Preço Total","Qtde","Preço Total"]
[1,"TERRAPLANAGEM"]
[83059,"ESCAVAÇÃO, CARGA E TRANSPORTE DE MATERIAL","KM",68.52,216881.4941,14860719.97,68.52,216881.4941,14860719.97,0,0]
[83060,"COMPACTAÇÃO DE ATERRO","KM",63.42,38343.7138,2431758.32,63.42,38343.7138,2431758.32,0,0]
[83072,"EMPRÉSTIMOS PARA TERRAPLENAGEM","UND",24,7911.7399,189881.75,24,7911.7399,189881.75,0,0]
[93007,"CORPO ESTRADAL","KM",68.52,7925.1266,543029.67,68.52,7925.1266,543029.67,0,0]
[93008,"ESPALHAMENTO E COMPACTAÇÃO DE BOTA-FORA","UND",12,29706.3659,356476.39,12,29706.3659,356476.39,0,0]
[93009,"CAMADA DRENANTE EM AREIA","UND",1,2874262.58,2874262.58,1,2874262.58,2874262.58,0,0]
[93010,"ESCAVAÇÃO CARGA E TRANSPORTE DE SOLO-MOLE","UND",1,592058.11,592058.11,1,592058.11,592058.11,0,0]
[{"$nulls":5},21848186.79,null,null,21848186.79,null,0]
[]
["1.1","TERRAPLANAGEM - 1ª RPFO"]
["PN","ESCAVAÇÃO, CARGA E TRANSPORTE DE MATERIAL EST 62500 A 62725","KM",null,null,null,4.5,237107.8867106944,1066985.490198125,4.5,1066985.490198125,"APA"]
["PN","ESCAVAÇÃO, CARGA E TRANSPORTE DE MATERIAL ","KM",null,null,null,68.52,30467.50911334977,2087633.724446726,68.52,2087633.724446726,"EO"]
["PN","COMPACTAÇÃO DE ATERRO","KM",null,null,null,63.42,4559.077574309872,289136.6997627321,63.42,289136.6997627321,"EO"]
["PN","COMPACTAÇÃO DE ATERRO EST 62500 A 62725","KM",null,null,null,4.5,63620.96718123378,286294.352315552,4.5,286294.352315552,"APA"]
["PN","ESPALHAMENTO E COMPACTAÇÃO DE BOTA-FORA","UND",null,null,null,12,-1876.4185835499957,-22517.023002599948,12,-22517.023002599948,"EO"]
["PN","CAMADA DRENANTE EM AREIA","UND",null,null,null,1,5107539.871604791,5107539.871604791,1,5107539.871604791,"EO"]
["PN","ESCAVAÇÃO CARGA E TRANSPORTE DE SOLO-MOLE","UND",null,null,null,1,915439.5107688425,915439.5107688425,1,915439.5107688425,"EO"]
[{"$nulls":5},0,null,null,9730512.626094168,null,9730512.626094168]
[]
[2,"DRENAGEM  E OAC       "]
[84040,"DRENAGEM SUPERFICIAL","KM",68.52,51935.1495,3558596.44,68.52,51935.1495,3558596.44,0,0]
[93011,"ENROCAMENTO DE PEDRA ARRUMADA","KM",3.26,311827.7148,1016558.35,3.26,311827.7148,1016558.35,0,0]
[132573,"OBRAS DE ARTE CORRENTES","KM",68.52,111690.5027,7653033.24,68.52,111690.5027,7653033.24,0,0]
[151152,"DRENAGEM PROFUNDA","KM",0.28,493204.5715,138097.28,0.28,493204.5715,138097.28,0,0]
[{"$nulls":5},12366285.31,null,null,12366285.31,null,0]
[]
["2.1","DRENAGEM  E OAC - 1ª RPFO"]
[84040,"DRENAGEM SUPERFICIAL","KM",null,null,null,68.52,-24094.149095245622,-1650931.09600623,68.52,-1650931.09600623,"EO"]
[93011,"ENROCAMENTO DE PEDRA ARRUMADA","KM",null,null,null,3.26,-222461.3668933389,-725224.0560722848,3.26,-725224.0560722848,"EO"]
[132573,"OBRAS DE ARTE CORRENTES","KM",null,null,null,68.52,-6383.647323496857,-437407.51460600464,68.52,-437407.51460600464,"EO"]
[151152,"DRENAGEM PROFUNDA","KM",null,null,null,0.28,-136317.5411543214,-38168.911523209994,0.28,-38168.911523209994,"EO"]
[{"$nulls":5},0,null,null,-2851731.5782077294,null,-2851731.5782077294]
[]
[3,"PAVIMENTAÇÃO"]
[8440,"CAMADAS GRANULARES - SUB-BASE","KM",68.52,89936.682,6162461.45,68.52,89936.682,6162461.45,0,0]
[93012,"CAMADA DE BASE","KM",68.52,218792.6718,14991673.87,68.52,218792.6718,14991673.87,0,0]
[93013,"CAMADA DE BINDER (CBUQ FAIXA\"B\")","KM",68.52,308053.5888,21107831.9,68.52,308053.5888,21107831.9,0,0]
[93014,"CAPA DE ROLAMENTO (CBUQ FAIXA \"C\")","KM",68.52,124025.4299,8498222.45,68.52,124025.4299,8498222.45,0,0]
[132499,"REMOÇÃO DO REVESTIMENTO E CAMADA GRANULAR","KM",10.1,37343.6169,377170.53,10.1,37343.6169,377170.53,0,0]
[132549,"REGULARIZAÇÃO DO SUBLEITO","KM",68.52,10176.5831,697299.47,68.52,10176.5831,697299.47,0,0]
[{"$nulls":5},51834659.67,null,null,51834659.67,null,0]
[]
["3.1","PAVIMENTAÇÃO 1ª RPFO"]
[8440,"CAMADA DE SUB-BASE","KM",null,null,null,68.52,12781.309160554614,875775.3036812021,68.52,875775.3036812021,"EO"]
[93012,"CAMADA DE BASE","KM",null,null,null,68.52,-10592.940328847042,-725828.2713325992,68.52,-725828.2713325992,"EO"]
[93013,"CAMADA DE BINDER (CBUQ FAIXA\"B\")","KM",null,null,null,68.52,77.69392018760428,5323.587411254644,68.52,5323.587411254644,"EO"]
[93014,"CAPA DE ROLAMENTO (CBUQ FAIXA \"C\")","KM",null,null,null,68.52,-1040.5143504839182,-71296.04329515807,68.52,-71296.04329515807,"EO"]
[{"$nulls":5},0,null,null,83974.57646469946,null,83974.57646469946]
[]
[4,"SINALIZAÇÃO                                      "]
[3009,"SINALIZAÇÃO HORIZONTAL","KM",68.52,24531.5176,1680899.58,68.52,24531.5176,1680899.58,0,0]
[132529,"SINALIZAÇÃO VERTICAL","KM",68.52,1921.1232,131635.36,68.52,1921.1232,131635.36,0,0]
[{"$nulls":5},1812534.94,null,null,1812534.94,null,0]
[]
[5,"OBRAS COMPLEMENTARES                           "]
[70020,"OBRAS COMPLEMENTARES","KM",68.52,91214.3248,6250005.53,68.52,91214.3248,6250005.53,0,0]
[{"$nulls":5},6250005.53,null,null,6250005.53,null,0]
[]
["5.1                                                                                                                                                                                                                                                           ","OBRAS COMPLEMENTARES - 1ª RPFO                              "]
["PN","OBRAS COMPLEMENTARES","KM",null,null,null,68.52,3785.0329,259350.46,68.52,259350.46,"APA"]
[{"$nulls":8},259350.46,null,259350.46]
[]
[6,"SERVIÇOS AMBIENTAIS "]
[93015,"CORPO ESTRADAL","KM",68.52,6941.4895,475630.86,68.52,6941.4895,475630.86,0,0]
[93016,"EMPRÉSTIMOS PARA TERRAPLENAGEM E OCORRÊNCIAS PARA","UND",27,26105.7545,704855.37,27,26105.7545,704855.37,0,0]
[{"$nulls":5},1180486.23,null,null,1180486.23,null,0]
[]
[7,"OAE - DEMOLIÇÃO DAS PONTES EXISTENTES                "]
[93017,"DEMOLIÇÃO DAS PONTES EXISTENTES","UND",1,520462.28,520462.28,1,520462.28,520462.28,0,0]
[{"$nulls":5},520462.28,null,null,520462.28,null,0]
[]
[8,"PONTE SOBRE O BRAÇO DO RIACHO POÇÃO     "]
[8060,"INFRAESTRUTURA","UND",1,322952.34,322952.34,1,322952.34,322952.34,0,0]
[8061,"MESOESTRUTURA","UND",1,246294.69,246294.69,1,246294.69,246294.69,0,0]
[8062,"SUPERESTRUTURA","UND",1,861260.14,861260.14,1,861260.14,861260.14,0,0]
[8067,"ACABAMENTOS","UND",1,70886.26,70886.26,1,70886.26,70886.26,0,0]
[{"$nulls":5},1501393.43,null,null,1501393.43,null,0]
[]
[9,"PONTE SOBRE O RIACHO POÇÃO           "]
[8060,"PONTE SOBRE O RIACHO POÇÃO           ","UND",1,367084.33,367084.33,1,367084.33,367084.33,0,0]
[8061,"MESOESTRUTURA","UND",1,268001.18,268001.18,1,268001.18,268001.18,0,0]
[8062,"SUPERESTRUTURA","UND",1,870320.16,870320.16,1,870320.16,870320.16,0,0]
[8067,"ACABAMENTOS","UND",1,70886.26,70886.26,1,70886.26,70886.26,0,0]
[{"$nulls":5},1576291.93,null,null,1576291.93,null,0]
[]
[10,"PONTE SOBRE O RIACHO FRADE  "]
[8060,"INFRAESTRUTURA","UND",1,132181.33,132181.33,1,132181.33,132181.33,0,0]
[8061,"MESOESTRUTURA","UND",1,146593.79,146593.79,1,146593.79,146593.79,0,0]
[8062,"SUPERESTRUTURA","UND",1,482712.21,482712.21,1,482712.21,482712.21,0,0]
[8067,"ACABAMENTOS","UND",1,49786.82,49786.82,1,49786.82,49786.82,0,0]
[{"$nulls":5},811274.15,null,null,811274.15,null,0]
[]
[11,"PONTE SOBRE O RIACHO TOURÃO        "]
[8060,"INFRAESTRUTURA","UND",1,54802.54,54802.54,1,54802.54,54802.54,0,0]
[8061,"MESOESTRUTURA","UND",1,73100.37,73100.37,1,73100.37,73100.37,0,0]
[8062,"SUPERESTRUTURA","UND",1,765525.9,765525.9,1,765525.9,765525.9,0,0]
[8067,"ACABAMENTOS","UND",1,64990.93,64990.93,1,64990.93,64990.93,0,0]
[{"$nulls":5},958419.7400000001,null,null,958419.7400000001,null,0]
[]
[{"$nulls":5},100660000,null,null,107882106.08435115,null,7222106.084351138]
[]
[{"$nulls":9},"CONJUNTO DE ACRÉSCIMOS - À PEDIDO DA ADMINISTRAÇÃO",1612630.302513677,0.01602056728108163]
[{"$nulls":9},"CONJUNTO DE DECRÉSCIMOS - À PEDIDO DA ADMINISTRAÇÃO",0,0]
[{"$nulls":9},"CONJUNTO DE ACRÉSCIMOS - ERROS E OMISSÕES",9280848.697675548,0.09219996719327984]
[{"$nulls":9},"CONJUNTO DE DECRÉSCIMOS -ERROS E OMISSÕES",-3671372.9158380865,-0.03647300731013398]
[]
[{"$nulls":6},"Valor Contratado (PI)",null,null,null,100660000]

{"sheet":"PLANILHA DE IMPLANTAÇÃO","index":3,"n_rows":108,"n_cols":13,"rows_kept":108,"cut":false,"hidden":false,"merged":[[105,6,105,9],[0,0,0,10],[107,6,107,9],[1,0,2,0],[1,1,2,1],[1,2,2,2],[1,3,1,5],[1,6,1,8],[1,9,1,10]],"flags":["formulas_cached_only"]}
["TABELA IV - CRITÉRIO DE PAGAMENTO - 1ª RPFO - PLANILHA DE IMPLANTAÇÃO"]
["Código","Item","Unid","CONTRATO",null,null,"1ª RPFO",null,null,"VARIAÇÃO"]
["Código","Serviço","Unid","Qtde","Preço Unit.","Preço Total","Qtde","Preço Unit.","Preço Total","Qtde","Preço Total"]
[1,"TERRAPLANAGEM"]
[83059,"ESCAVAÇÃO, CARGA E TRANSPORTE DE MATERIAL","KM",68.52,216881.4941,14860719.97,68.52,216881.4941,14860719.97,0,0]
[83060,"COMPACTAÇÃO DE ATERRO","KM",63.42,38343.7138,2431758.32,63.42,38343.7138,2431758.32,0,0]
[83072,"EMPRÉSTIMOS PARA TERRAPLENAGEM","UND",24,7911.7399,189881.75,24,7911.7399,189881.75,0,0]
[93007,"CORPO ESTRADAL","KM",68.52,7925.1266,543029.67,68.52,7925.1266,543029.67,0,0]
[93008,"ESPALHAMENTO E COMPACTAÇÃO DE BOTA-FORA","UND",12,29706.3659,356476.39,0,29706.3659,0,-12,-356476.39]
[93009,"CAMADA DRENANTE EM AREIA","UND",1,2874262.58,2874262.58,1,2874262.58,2874262.58,0,0]
[93010,"ESCAVAÇÃO CARGA E TRANSPORTE DE SOLO-MOLE","UND",1,592058.11,592058.11,1,592058.11,592058.11,0,0]
[{"$nulls":5},21848186.79,null,null,21491710.4,null,-356476.39]
[]
["1.1","TERRAPLANAGEM - 1ª RPFO"]
["PN","ESCAVAÇÃO, CARGA E TRANSPORTE DE MATERIAL EST 62500 A 62725","KM",null,null,null,4.5,237107.8867106944,1066985.490198125,4.5,1066985.490198125]
["PN","ESCAVAÇÃO, CARGA E TRANSPORTE DE MATERIAL ","KM",null,null,null,68.52,30467.50911334977,2087633.724446726,68.52,2087633.724446726]
["PN","COMPACTAÇÃO DE ATERRO","KM",null,null,null,63.42,4559.077574309872,289136.6997627321,63.42,289136.6997627321,null," "]
["PN","COMPACTAÇÃO DE ATERRO EST 62500 A 62725","KM",null,null,null,4.5,63620.96718123378,286294.352315552,4.5,286294.352315552]
["PN","ESPALHAMENTO E COMPACTAÇÃO DE BOTA-FORA","UND",null,null,null,12,27829.9475,333959.37,12,333959.37]
["PN","CAMADA DRENANTE EM AREIA","UND",null,null,null,1,5107539.871604791,5107539.871604791,1,5107539.871604791]
["PN","ESCAVAÇÃO CARGA E TRANSPORTE DE SOLO-MOLE","UND",null,null,null,1,915439.5107688425,915439.5107688425,1,915439.5107688425]
[{"$nulls":5},0,null,null,10086989.01909677,null,10086989.01909677]
[]
[2,"DRENAGEM  E OAC       "]
[84040,"DRENAGEM SUPERFICIAL","KM",68.52,51935.1495,3558596.44,0,51935.1495,0,-68.52,-3558596.44]
[93011,"ENROCAMENTO DE PEDRA ARRUMADA","KM",3.26,311827.7148,1016558.35,0,311827.7148,0,-3.26,-1016558.35]
[132573,"OBRAS DE ARTE CORRENTES","KM",68.52,111690.5027,7653033.24,0,111690.5027,0,-68.52,-7653033.24]
[151152,"DRENAGEM PROFUNDA","KM",0.28,493204.5715,138097.28,0,493204.5715,0,-0.28,-138097.28]
[{"$nulls":5},12366285.31,null,null,0,null,-12366285.31]
[]
["2.1","DRENAGEM  E OAC - 1ª RPFO"]
[84040,"DRENAGEM SUPERFICIAL","KM",null,null,null,68.52,27841.000291885583,1907665.34,68.52,1907665.34]
[93011,"ENROCAMENTO DE PEDRA ARRUMADA","KM",null,null,null,3.26,89366.34662576688,291334.29,3.26,291334.29]
[132573,"OBRAS DE ARTE CORRENTES","KM",null,null,null,68.52,105306.8553706947,7215625.73,68.52,7215625.73]
[151152,"DRENAGEM PROFUNDA","KM",null,null,null,0.28,356887.0357142857,99928.37,0.28,99928.37]
[{"$nulls":5},0,null,null,9514553.729999999,null,9514553.729999999]
[]
[3,"PAVIMENTAÇÃO"]
[8440,"CAMADAS GRANULARES - SUB-BASE","KM",68.52,89936.682,6162461.45,68.52,89936.682,6162461.45,0,0]
[93012,"CAMADA DE BASE","KM",68.52,218792.6718,14991673.87,0,218792.6718,0,-68.52,-14991673.87]
[93013,"CAMADA DE BINDER (CBUQ FAIXA\"B\")","KM",68.52,308053.5888,21107831.9,68.52,308053.5888,21107831.9,0,0]
[93014,"CAPA DE ROLAMENTO (CBUQ FAIXA \"C\")","KM",68.52,124025.4299,8498222.45,0,124025.4299,0,-68.52,-8498222.45]
[132499,"REMOÇÃO DO REVESTIMENTO E CAMADA GRANULAR","KM",10.1,37343.6169,377170.53,10.1,37343.6169,377170.53,0,0]
[132549,"REGULARIZAÇÃO DO SUBLEITO","KM",68.52,10176.5831,697299.47,68.52,10176.5831,697299.47,0,0]
[{"$nulls":5},51834659.67,null,null,28344763.349999998,null,-23489896.32]
[]
["3.1","PAVIMENTAÇÃO 1ª RPFO"]
[8440,"CAMADA DE SUB-BASE","KM",null,null,null,68.52,12781.309160554614,875775.3036812021,68.52,875775.3036812021]
[93012,"CAMADA DE BASE","KM",null,null,null,68.52,208199.73146526562,14265845.6,68.52,14265845.6]
[93013,"CAMADA DE BINDER (CBUQ FAIXA\"B\")","KM",null,null,null,68.52,77.69392018760428,5323.587411254644,68.52,5323.587411254644]
[93014,"CAPA DE ROLAMENTO (CBUQ FAIXA \"C\")","KM",null,null,null,68.52,122984.91535318157,8426926.4,68.52,8426926.4]
[{"$nulls":5},0,null,null,23573870.891092457,null,23573870.891092457]
[]
[4,"SINALIZAÇÃO                                      "]
[3009,"SINALIZAÇÃO HORIZONTAL","KM",68.52,24531.5176,1680899.58,68.52,24531.5176,1680899.58,0,0]
[132529,"SINALIZAÇÃO VERTICAL","KM",68.52,1921.1232,131635.36,68.52,1921.1232,131635.36,0,0]
[{"$nulls":5},1812534.94,null,null,1812534.94,null,0]
[]
[5,"OBRAS COMPLEMENTARES                           "]
[70020,"OBRAS COMPLEMENTARES","KM",68.52,91214.3248,6250005.53,68.52,91214.3248,6250005.53,0,0]
[{"$nulls":5},6250005.53,null,null,6250005.53,null,0]
[]
["5.1                                                                                                                                                                                                                                                           ","OBRAS COMPLEMENTARES - 1ª RPFO                              "]
["PN","OBRAS COMPLEMENTARES","KM",null,null,null,68.52,3785.0329,259350.46,68.52,259350.46]
[{"$nulls":8},259350.46,null,259350.46]
[]
[6,"SERVIÇOS AMBIENTAIS "]
[93015,"CORPO ESTRADAL","KM",68.52,6941.4895,475630.86,68.52,6941.4895,475630.86,0,0]
[93016,"EMPRÉSTIMOS PARA TERRAPLENAGEM E OCORRÊNCIAS PARA","UND",27,26105.7545,704855.37,27,26105.7545,704855.37,0,0]
[{"$nulls":5},1180486.23,null,null,1180486.23,null,0]
[]
[7,"OAE - DEMOLIÇÃO DAS PONTES EXISTENTES                "]
[93017,"DEMOLIÇÃO DAS PONTES EXISTENTES","UND",1,520462.28,520462.28,1,520462.28,520462.28,0,0]
[{"$nulls":5},520462.28,null,null,520462.28,null,0]
[]
[8,"PONTE SOBRE O BRAÇO DO RIACHO POÇÃO     "]
[8060,"INFRAESTRUTURA","UND",1,322952.34,322952.34,1,322952.34,322952.34,0,0]
[8061,"MESOESTRUTURA","UND",1,246294.69,246294.69,1,246294.69,246294.69,0,0]
[8062,"SUPERESTRUTURA","UND",1,861260.14,861260.14,1,861260.14,861260.14,0,0]
[8067,"ACABAMENTOS","UND",1,70886.26,70886.26,1,70886.26,70886.26,0,0]
[{"$nulls":5},1501393.43,null,null,1501393.43,null,0]
[]
[9,"PONTE SOBRE O RIACHO POÇÃO           "]
[8060,"PONTE SOBRE O RIACHO POÇÃO           ","UND",1,367084.33,367084.33,1,367084.33,367084.33,0,0]
[8061,"MESOESTRUTURA","UND",1,268001.18,268001.18,1,268001.18,268001.18,0,0]
[8062,"SUPERESTRUTURA","UND",1,870320.16,870320.16,1,870320.16,870320.16,0,0]
[8067,"ACABAMENTOS","UND",1,70886.26,70886.26,1,70886.26,70886.26,0,0]
[{"$nulls":5},1576291.93,null,null,1576291.93,null,0]
[]
[10,"PONTE SOBRE O RIACHO FRADE  "]
[8060,"INFRAESTRUTURA","UND",1,132181.33,132181.33,1,132181.33,132181.33,0,0]
[8061,"MESOESTRUTURA","UND",1,146593.79,146593.79,1,146593.79,146593.79,0,0]
[8062,"SUPERESTRUTURA","UND",1,482712.21,482712.21,1,482712.21,482712.21,0,0]
[8067,"ACABAMENTOS","UND",1,49786.82,49786.82,1,49786.82,49786.82,0,0]
[{"$nulls":5},811274.15,null,null,811274.15,null,0]
[]
[11,"PONTE SOBRE O RIACHO TOURÃO        "]
[8060,"INFRAESTRUTURA","UND",1,54802.54,54802.54,1,54802.54,54802.54,0,0]
[8061,"MESOESTRUTURA","UND",1,73100.37,73100.37,1,73100.37,73100.37,0,0]
[8062,"SUPERESTRUTURA","UND",1,765525.9,765525.9,1,765525.9,765525.9,0,0]
[8067,"ACABAMENTOS","UND",1,64990.93,64990.93,1,64990.93,64990.93,0,0]
[{"$nulls":5},958419.7400000001,null,null,958419.7400000001,null,0]
[]
[{"$nulls":5},100660000,null,null,107882106.08018923,null,7222106.0801892225]
[]
[{"$nulls":6},"Valor Contratado (PI)",null,null,null,100660000]
[]
[{"$nulls":6},"Valor Contratado (PI) + 1ª RPFO",null,null,null,107882106.08018923]

{"sheet":"Quadro","index":4,"n_rows":14,"n_cols":8,"rows_kept":14,"cut":false,"hidden":false,"merged":[[9,0,11,1],[0,0,0,5],[1,0,1,2],[2,0,2,2],[3,0,8,0],[3,1,5,1],[6,1,8,1]],"flags":["formulas_cached_only"]}
["TABELA V - EVOLUÇÃO CONTRATUAL"]
["MOTIVO DO ADITIVO AO PREÇO GLOBAL",null,null,"ADITIVO COM DESCONTO DE 12,658% (R$)","REFLEXO %","VALOR DO CONTRATO APÓS A REVISÃO (R$)"]
["VALOR CONTRATADO A PI (SET/13)",null,null," -","-",100660000]
["1ª RPFO","Erros e Omissões","Conjunto de Acréscimos",9280848.697675548,9.219996719327984,"-"]
[null,null,"Conjunto de Decréscimos",-3671372.9158380865,-3.6473007310133982,"-"]
[null,null,"Total",5609475.7818374615,5.572695988314585,"-"]
[null,"A pedido da Administração","Conjunto de Acréscimos",1612630.302513677,1.602056728108163,"-"]
[null,null,"Conjunto de Decréscimos",0,0,"-"]
[null,null,"Total",1612630.302513677,1.602056728108163,"-"]
["Total",null,"Conjunto de Acréscimos",10893479.000189226,10.822053447436147,"-"]
[null,null,"Conjunto de Decréscimos",-3671372.9158380865,-3.6473007310133982,"-"]
[null,null,"Total",7222106.084351139,7.1747527164227485,107882106.08435114]
[]
[{"$nulls":7}," "]

{"sheet":"CBUQ faixa C","index":5,"n_rows":80,"n_cols":22,"rows_kept":80,"cut":false,"hidden":true,"merged":[[0,0,0,19],[1,0,2,19],[3,0,3,12],[3,13,3,16],[3,17,3,19],[4,13,4,16],[4,17,4,19],[75,0,75,5],[76,0,76,5],[7,15,7,16],[8,0,8,1],[8,3,8,5],[8,6,8,8],[8,15,8,16],[8,17,8,19],[5,0,5,12],[5,13,5,16],[5,17,5,19],[6,0,6,12],[6,13,6,16],[6,17,6,19],[10,15,12,16],[10,17,12,19],[13,0,14,0],[13,1,14,1],[13,2,14,4],[13,5,13,10],[13,11,13,16],[13,17,13,19],[14,5,14,7],[14,8,14,10],[14,11,14,13],[14,14,14,16],[14,17,14,19],[16,2,16,3],[16,5,16,6],[16,8,16,9],[16,11,16,12],[16,14,16,15],[16,17,16,19],[18,2,18,3],[18,5,18,6],[18,8,18,9],[18,11,18,12],[18,14,18,15],[18,17,18,19],[17,2,17,3],[17,5,17,6],[17,8,17,9],[17,11,17,12],[17,14,17,15],[17,17,17,19],[20,2,20,3],[20,5,20,6],[20,8,20,9],[20,11,20,12],[20,14,20,15],[20,17,20,19],[19,2,19,3],[19,5,19,6],[19,8,19,9],[19,11,19,12],[19,14,19,15],[19,17,19,19],[22,2,22,3],[22,5,22,6],[22,8,22,9],[22,11,22,12],[22,14,22,15],[22,17,22,19],[21,2,21,3],[21,5,21,6],[21,8,21,9],[21,11,21,12],[21,14,21,15],[21,17,21,19],[24,2,24,3],[24,5,24,6],[24,8,24,9],[24,11,24,12],[24,14,24,15],[24,17,24,19],[23,2,23,3],[23,5,23,6],[23,8,23,9],[23,11,23,12],[23,14,23,15],[23,17,23,19],[26,2,26,3],[26,5,26,6],[26,8,26,9],[26,11,26,12],[26,14,26,15],[26,17,26,19],[25,2,25,3],[25,5,25,6],[25,8,25,9],[25,11,25,12],[25,14,25,15],[25,17,25,19],[28,2,28,3],[28,5,28,6],[28,8,28,9],[28,11,28,12],[28,14,28,15],[28,17,28,19],[27,2,27,3],[27,5,27,6],[27,8,27,9],[27,11,27,12],[27,14,27,15],[27,17,27,19],[30,2,30,3],[30,5,30,6],[30,8,30,9],[30,11,30,12],[30,14,30,15],[30,17,30,19],[29,2,29,3],[29,5,29,6],[29,8,29,9],[29,11,29,12],[29,14,29,15],[29,17,29,19],[34,1,34,7],[35,1,35,7],[35,8,35,9],[35,11,35,12],[35,14,35,15],[35,17,35,19],[31,0,31,16],[31,17,31,19],[32,0,33,0],[32,1,33,1],[32,8,33,10],[32,11,33,13],[32,14,33,16],[32,17,32,19],[33,17,33,19],[36,1,36,7],[36,8,36,9],[36,11,36,12],[36,14,36,15],[36,17,36,19],[37,1,37,7],[37,8,37,9],[37,11,37,12],[37,14,37,15],[37,17,37,19],[38,1,38,7],[38,8,38,9],[38,11,38,12],[38,14,38,15],[38,17,38,19],[39,1,39,7],[39,8,39,9],[39,11,39,12],[39,14,39,15],[39,17,39,19],[40,1,40,7],[40,8,40,9],[40,11,40,12],[40,14,40,15],[40,17,40,19],[41,1,41,7],[41,8,41,9],[41,11,41,12],[41,14,41,15],[41,17,41,19],[42,1,42,7],[42,8,42,9],[42,11,42,12],[42,14,42,15],[42,17,42,19],[43,1,43,7],[43,8,43,9],[43,11,43,12],[43,14,43,15],[43,17,43,19],[44,1,44,7],[44,8,44,9],[44,11,44,12],[44,14,44,15],[44,17,44,19],[45,1,45,7],[45,8,45,9],[45,11,45,12],[45,14,45,15],[45,17,45,19],[48,0,48,7],[48,8,48,16],[48,17,48,19],[49,0,49,7],[49,8,49,16],[49,17,49,19],[46,1,46,7],[46,8,46,9],[46,11,46,12],[46,14,46,15],[46,17,46,19],[47,0,47,16],[47,17,47,19],[52,1,52,7],[53,1,53,7],[53,8,53,9],[53,11,53,12],[53,14,53,15],[53,17,53,19],[50,0,51,0],[50,1,51,1],[50,8,51,10],[50,11,51,13],[50,14,51,16],[50,17,50,19],[51,17,51,19],[54,1,54,7],[54,8,54,9],[54,11,54,12],[54,14,54,15],[54,17,54,19],[55,1,55,7],[55,8,55,9],[55,11,55,12],[55,14,55,15],[55,17,55,19],[56,1,56,7],[56,8,56,9],[56,11,56,12],[56,14,56,15],[56,17,56,19],[57,1,57,7],[57,8,57,9],[57,11,57,12],[57,14,57,15],[57,17,57,19],[58,1,58,7],[58,8,58,9],[58,11,58,12],[58,14,58,15],[58,17,58,19],[59,1,59,7],[59,8,59,9],[59,11,59,12],[59,14,59,15],[59,17,59,19],[60,1,60,7],[60,8,60,9],[60,11,60,12],[60,14,60,15],[60,17,60,19],[61,1,61,7],[61,8,61,9],[61,11,61,12],[61,14,61,15],[61,17,61,19],[64,17,64,19],[65,2,65,4],[65,5,65,7],[65,8,65,10],[65,11,65,13],[65,14,65,16],[65,17,65,19],[62,0,62,16],[62,17,62,19],[63,0,64,0],[63,1,64,1],[63,2,64,4],[63,5,64,7],[63,8,64,10],[63,11,64,13],[63,14,64,16],[63,17,63,19],[67,2,67,4],[67,5,67,7],[67,8,67,10],[67,11,67,13],[67,14,67,16],[67,17,67,19],[66,2,66,4],[66,5,66,7],[66,8,66,10],[66,11,66,13],[66,14,66,16],[66,17,66,19],[69,2,69,4],[69,5,69,7],[69,8,69,10],[69,11,69,13],[69,14,69,16],[69,17,69,19],[68,2,68,4],[68,5,68,7],[68,8,68,10],[68,11,68,13],[68,14,68,16],[68,17,68,19],[77,0,77,5],[78,0,78,5],[79,0,79,5],[73,0,73,16],[73,17,73,19],[74,0,74,19],[70,0,70,16],[70,17,70,19],[71,0,71,16],[71,17,71,19],[72,0,72,16],[72,17,72,19]],"flags":["formulas_cached_only"]}
[]
["PLANILHA DE COMPOSIÇÃO ANALÍTICA DE PREÇOS UNITÁRIOS"]
[]
[]
["DATA BASE: MARÇO 2013",{"$nulls":12},"CÓDIGO"]
["SERVIÇO: Concreto Betuminoso Usinado a Quente (faixa \"C\")",{"$nulls":12},"2 S 02 540 01"]
[]
[]
[null,null,null,"BDI: 26,70%",{"$nulls":11},"UNID.",null,"DATA"]
[]
[{"$nulls":15},"T"]
[]
[]
["CÓDIGO","A - EQUIPAMENTO","QUANT.",null,null,"UTILIZAÇÃO",{"$nulls":5},"CUSTO OPERACIONAL",{"$nulls":5},"CUSTO"]
[{"$nulls":5},"PROD.",null,null,"IMPROD.",null,null,"PROD.",null,null,"IMPROD.",null,null,"HORÁRIO"]
[]
["E 007","TRATOR DE PENEUS",1,null,null,0.24,null,null,0.76,null,null,59.14,null,null,11.85,null,null,23.1996]
["E 102","ROLO TANDEN VIB. AUTOP. 10,2 T",1,null,null,0.56,null,null,0.43999999999999995,null,null,100.65,null,null,11.85,null,null,61.57800000000001]
["E 105","ROLO COMP. DE PENEUS 25T",2,null,null,0.29,null,null,0.71,null,null,111.4,null,null,11.85,null,null,81.439]
["E 107","VASSOURA MECANICA",1,null,null,0.24,null,null,0.76,null,null,4.58,null,null,0,null,null,1.0992]
["E 149","VIBRO ACABADORA DE ASFALTO SEM ESTEIRA",1,null,null,0.81,null,null,0.18999999999999995,null,null,140.49,null,null,20.29,null,null,117.652]
["E 404","CAMINHAO BASCULANTE 10M3",1.53,null,null,1,null,null,0,null,null,115.36,null,null,13.11,null,null,176.5008]
{"$rows_empty":9}
["A) TOTAL",{"$nulls":16},461.46860000000004]
["CÓDIGO","B - MÃO DE OBRA",{"$nulls":6},"K,R",null,null,"QUANT.",null,null,"SALÁRIO BASE",null,null,"CUSTO"]
[{"$nulls":17},"HORÁRIO"]
[]
["T 511","ENCARREGADO DE PAVIMENTAÇÃO",{"$nulls":9},1,null,null,26.29,null,null,26.29]
["T 701","SERVENTE",{"$nulls":9},8,null,null,7.25,null,null,58]
[null,"ADICIONAL DE MÃO DE OBRA (15,51% MO)",{"$nulls":15},13.073378999999997]
{"$rows_empty":9}
["B) TOTAL",{"$nulls":16},97.363379]
["C) PRODUÇÃO DA EQUIPE             75,0000 T / h",{"$nulls":7},"CUSTO UNITÁRIO TOTAL (A+B)",{"$nulls":8},558.831979]
["D) CUSTO UNITÁRIO DA EXECUÇÃO",{"$nulls":7},"((A+B))/(C)=(D)",{"$nulls":8},7.451093053333334]
["CÓDIGO","C - MATERIAIS",{"$nulls":6},"UNID.",null,null,"CUSTO",null,null,"CONSUMO",null,null,"CUSTO"]
[{"$nulls":17},"UNITÁRIO"]
[]
["1 A 01 390 02","USINAGEM DE CBUQ (faixa \"C\")",{"$nulls":6},"T",null,null,58,null,null,1,null,null,58]
{"$rows_empty":8}
["E) TOTAL",{"$nulls":16},58]
["CÓDIGO","F - TRANSPORTE","D.M.T.           (T)",null,null,"D.M.T.           (P)",null,null,"TOT.              D.M.T.",null,null,"CUSTO",null,null,"CONSUMO",null,null,"CUSTO"]
[{"$nulls":17},"UNITÁRIO"]
[]
["1 A 01 390 02","CBUQ - Transporte Local",17.78,null,null,0,null,null,17.78,null,null,0.59,null,null,1,null,null,10.4902]
[]
[{"$nulls":21},0]
[]
["F) TOTAL",{"$nulls":16},10.4902]
["CUSTO DIRETO TOTAL: (D)+(E)+(F)",{"$nulls":16},75.94129305333334,null,null,75.94129305333334]
["BONIFICAÇÃO",{"$nulls":16},20.276325245240002]
["PREÇO UNITÁRIO TOTAL",{"$nulls":16},96.20761829857334]
[]
["VALOR DO EDITAL",{"$nulls":5},96.20761829857334]
["VALOR CONTRATUAL",{"$nulls":5},{"$error":"#REF!"}]
["DESCONTO",{"$nulls":5},{"$error":"#REF!"}]
["VALOR EDITAL ADEQUADO",{"$nulls":5},{"$error":"#REF!"}]
["VALOR CONTRATUAL ADEQUADO",{"$nulls":5},{"$error":"#REF!"}]

{"sheet":"Usinagem Faixa C","index":6,"n_rows":74,"n_cols":22,"rows_kept":74,"cut":false,"hidden":true,"merged":[[0,0,0,19],[1,0,2,19],[3,0,3,12],[3,13,3,16],[3,17,3,19],[4,13,4,16],[4,17,4,19],[7,15,7,16],[8,0,8,1],[8,3,8,5],[8,6,8,8],[8,15,8,16],[8,17,8,19],[5,0,5,12],[5,13,5,16],[5,17,5,19],[6,0,6,12],[6,13,6,16],[6,17,6,19],[10,15,12,16],[10,17,12,19],[13,0,14,0],[13,1,14,1],[13,2,14,4],[13,5,13,10],[13,11,13,16],[13,17,13,19],[14,5,14,7],[14,8,14,10],[14,11,14,13],[14,14,14,16],[14,17,14,19],[16,2,16,3],[16,5,16,6],[16,8,16,9],[16,11,16,12],[16,14,16,15],[16,17,16,19],[18,2,18,3],[18,5,18,6],[18,8,18,9],[18,11,18,12],[18,14,18,15],[18,17,18,19],[17,2,17,3],[17,5,17,6],[17,8,17,9],[17,11,17,12],[17,14,17,15],[17,17,17,19],[20,2,20,3],[20,5,20,6],[20,8,20,9],[20,11,20,12],[20,14,20,15],[20,17,20,19],[19,2,19,3],[19,5,19,6],[19,8,19,9],[19,11,19,12],[19,14,19,15],[19,17,19,19],[22,2,22,3],[22,5,22,6],[22,8,22,9],[22,11,22,12],[22,14,22,15],[22,17,22,19],[21,2,21,3],[21,5,21,6],[21,8,21,9],[21,11,21,12],[21,14,21,15],[21,17,21,19],[24,2,24,3],[24,5,24,6],[24,8,24,9],[24,11,24,12],[24,14,24,15],[24,17,24,19],[23,2,23,3],[23,5,23,6],[23,8,23,9],[23,11,23,12],[23,14,23,15],[23,17,23,19],[26,2,26,3],[26,5,26,6],[26,8,26,9],[26,11,26,12],[26,14,26,15],[26,17,26,19],[25,2,25,3],[25,5,25,6],[25,8,25,9],[25,11,25,12],[25,14,25,15],[25,17,25,19],[28,2,28,3],[28,5,28,6],[28,8,28,9],[28,11,28,12],[28,14,28,15],[28,17,28,19],[27,2,27,3],[27,5,27,6],[27,8,27,9],[27,11,27,12],[27,14,27,15],[27,17,27,19],[30,2,30,3],[30,5,30,6],[30,8,30,9],[30,11,30,12],[30,14,30,15],[30,17,30,19],[29,2,29,3],[29,5,29,6],[29,8,29,9],[29,11,29,12],[29,14,29,15],[29,17,29,19],[34,1,34,7],[35,1,35,7],[35,8,35,9],[35,11,35,12],[35,14,35,15],[35,17,35,19],[31,0,31,16],[31,17,31,19],[32,0,33,0],[32,1,33,1],[32,8,33,10],[32,11,33,13],[32,14,33,16],[32,17,32,19],[33,17,33,19],[36,1,36,7],[36,8,36,9],[36,11,36,12],[36,14,36,15],[36,17,36,19],[37,1,37,7],[37,8,37,9],[37,11,37,12],[37,14,37,15],[37,17,37,19],[38,1,38,7],[38,8,38,9],[38,11,38,12],[38,14,38,15],[38,17,38,19],[39,1,39,7],[39,8,39,9],[39,11,39,12],[39,14,39,15],[39,17,39,19],[40,1,40,7],[40,8,40,9],[40,11,40,12],[40,14,40,15],[40,17,40,19],[41,1,41,7],[41,8,41,9],[41,11,41,12],[41,14,41,15],[41,17,41,19],[42,1,42,7],[42,8,42,9],[42,11,42,12],[42,14,42,15],[42,17,42,19],[43,1,43,7],[43,8,43,9],[43,11,43,12],[43,14,43,15],[43,17,43,19],[44,1,44,7],[44,8,44,9],[44,11,44,12],[44,14,44,15],[44,17,44,19],[45,1,45,7],[45,8,45,9],[45,11,45,12],[45,14,45,15],[45,17,45,19],[48,0,48,7],[48,8,48,16],[48,17,48,19],[49,0,49,7],[49,8,49,16],[49,17,49,19],[46,1,46,7],[46,8,46,9],[46,11,46,12],[46,14,46,15],[46,17,46,19],[47,0,47,16],[47,17,47,19],[52,1,52,7],[53,1,53,7],[53,8,53,9],[53,11,53,12],[53,14,53,15],[53,17,53,19],[50,0,51,0],[50,1,51,1],[50,8,51,10],[50,11,51,13],[50,14,51,16],[50,17,50,19],[51,17,51,19],[54,1,54,7],[54,8,54,9],[54,11,54,12],[54,14,54,15],[54,17,54,19],[55,1,55,7],[55,8,55,9],[55,11,55,12],[55,14,55,15],[55,17,55,19],[56,1,56,7],[56,8,56,9],[56,11,56,12],[56,14,56,15],[56,17,56,19],[57,1,57,7],[57,8,57,9],[57,11,57,12],[57,14,57,15],[57,17,57,19],[58,1,58,7],[58,8,58,9],[58,11,58,12],[58,14,58,15],[58,17,58,19],[59,1,59,7],[59,8,59,9],[59,11,59,12],[59,14,59,15],[59,17,59,19],[60,1,60,7],[60,8,60,9],[60,11,60,12],[60,14,60,15],[60,17,60,19],[61,1,61,7],[61,8,61,9],[61,11,61,12],[61,14,61,15],[61,17,61,19],[64,17,64,19],[65,2,65,4],[65,5,65,7],[65,8,65,10],[65,11,65,13],[65,14,65,16],[65,17,65,19],[62,0,62,16],[62,17,62,19],[63,0,64,0],[63,1,64,1],[63,2,64,4],[63,5,64,7],[63,8,64,10],[63,11,64,13],[63,14,64,16],[63,17,63,19],[67,2,67,4],[67,5,67,7],[67,8,67,10],[67,11,67,13],[67,14,67,16],[67,17,67,19],[66,2,66,4],[66,5,66,7],[66,8,66,10],[66,11,66,13],[66,14,66,16],[66,17,66,19],[69,2,69,4],[69,5,69,7],[69,8,69,10],[69,11,69,13],[69,14,69,16],[69,17,69,19],[68,2,68,4],[68,5,68,7],[68,8,68,10],[68,11,68,13],[68,14,68,16],[68,17,68,19],[78,0,78,19],[79,0,79,19],[73,0,73,16],[73,17,73,19],[74,0,74,19],[75,0,75,19],[76,0,76,19],[77,0,77,19],[70,0,70,16],[70,17,70,19],[71,0,71,16],[71,17,71,19],[72,0,72,16],[72,17,72,19]],"flags":["formulas_cached_only"]}
[]
["PLANILHA DE COMPOSIÇÃO ANALÍTICA DE PREÇOS UNITÁRIOS"]
[]
[]
["DATA BASE: MARÇO 2013",{"$nulls":12},"CÓDIGO"]
["SERVIÇO: Usinagem de  CBUQ (faixa \"C\")",{"$nulls":12},"1 A 01 390 02"]
[]
[]
[null,null,null,"BDI: 26,70%",{"$nulls":11},"UNID.",null,"DATA"]
[]
[{"$nulls":15},"T"]
[]
[]
["CÓDIGO","A - EQUIPAMENTO","QUANT.",null,null,"UTILIZAÇÃO",{"$nulls":5},"CUSTO OPERACIONAL",{"$nulls":5},"CUSTO"]
[{"$nulls":5},"PROD.",null,null,"IMPROD.",null,null,"PROD.",null,null,"IMPROD.",null,null,"HORÁRIO"]
[]
["E 010","CARREGADEIRA DE PENEUS - 3,30 m3",1,null,null,0.26,null,null,0.74,null,null,170.56,null,null,16.38,null,null,56.466800000000006]
["E 110","TANQUE ESTOC. DE ASFALTO 20000 l",2,null,null,1,null,null,0,null,null,9.44,null,null,0,null,null,18.88]
["E 112","AQUECEDOR DE FLUIDO TERMICO",1,null,null,1,null,null,0,null,null,24.46,null,null,0,null,null,24.46]
["E 147","USINA DE ASFALTO A QUENTE 90/120",1,null,null,1,null,null,0,null,null,271.31,null,null,20.29,null,null,271.31]
["E 501","GRUPO GERADOR 36/40 Kva",1,null,null,1,null,null,0,null,null,28.94,null,null,11.85,null,null,28.94]
["E 503","GRUPO GERADOR 164/180 Kva",1,null,null,1,null,null,0,null,null,82.31,null,null,11.85,null,null,82.31]
{"$rows_empty":9}
["A) TOTAL",{"$nulls":16},482.3668]
["CÓDIGO","B - MÃO DE OBRA",{"$nulls":6},"K,R",null,null,"QUANT.",null,null,"SALÁRIO BASE",null,null,"CUSTO"]
[{"$nulls":17},"HORÁRIO"]
[]
["T 501","ENCARREGADO DE TURMA",{"$nulls":9},1,null,null,20.29,null,null,20.29]
["T 701","SERVENTE",{"$nulls":9},8,null,null,7.25,null,null,58]
[null,"ADICIONAL DE MÃO DE OBRA (15,51% MO)",{"$nulls":15},12.142778999999997]
{"$rows_empty":9}
["B) TOTAL",{"$nulls":16},90.43277899999998]
["C) PRODUÇÃO DA EQUIPE             75,0000 T / h",{"$nulls":7},"CUSTO UNITÁRIO TOTAL (A+B)",{"$nulls":8},572.799579]
["D) CUSTO UNITÁRIO DA EXECUÇÃO",{"$nulls":7},"((A+B))/(C)=(D)",{"$nulls":8},7.63732772]
["CÓDIGO","C - MATERIAIS",{"$nulls":6},"UNID.",null,null,"CUSTO",null,null,"CONSUMO",null,null,"CUSTO"]
[{"$nulls":17},"UNITÁRIO"]
[]
["M 003","OLEO COMBUSTIVEL 1 A",{"$nulls":6},"l",null,null,1.74,null,null,8,null,null,13.92]
["1A 00 716 00","AREIA COMERCIAL",{"$nulls":6},"m3",null,null,18.2,null,null,0.0533,null,null,0.9700599999999999]
["1A 01 200 01","BRITA PRODUZIDA",{"$nulls":6},"m3",null,null,29.35,null,null,0.558,null,null,16.3773]
["M 202","FILLER (cimento)",{"$nulls":6},"kg",null,null,0.38,null,null,28,null,null,10.64]
[]
[]
[]
[]
[]
["E) TOTAL",{"$nulls":16},41.907360000000004]
["CÓDIGO","F - TRANSPORTE","D.M.T.           (T)",null,null,"D.M.T.           (P)",null,null,"TOT.              D.M.T.",null,null,"CUSTO",null,null,"CONSUMO",null,null,"CUSTO"]
[{"$nulls":17},"UNITÁRIO"]
[]
["M 202","Filler - transp comercial",34.2,null,null,0,null,null,34.2,null,null,0.45,null,null,0.028,null,null,0.43092]
["M 202","Filler - transp comercial",0,null,null,489,null,null,489,null,null,0.3,null,null,0.028,null,null,4.1076]
["1A 00 716 00","Areia - Transp Comercial",40.34,null,null,0,null,null,40.34,null,null,0.46,null,null,0.08,null,null,1.484512,null,null,null,45.260000000000005]
["1A 01 200 01","Brita - Transp local",4.92,null,null,0,null,null,4.92,null,null,0.59,null,null,0.837,null,null,2.4296435999999995]
["F) TOTAL",{"$nulls":16},8.4526756]
["CUSTO DIRETO TOTAL: (D)+(E)+(F)",{"$nulls":16},57.997363320000005,null,null,57.997363320000005]
["BONIFICAÇÃO"]
["PREÇO UNITÁRIO TOTAL"]

{"sheet":"CBUQ faixa B","index":7,"n_rows":79,"n_cols":22,"rows_kept":79,"cut":false,"hidden":true,"merged":[[0,0,0,19],[1,0,2,19],[3,0,3,12],[3,13,3,16],[3,17,3,19],[4,13,4,16],[4,17,4,19],[74,0,74,5],[75,0,75,5],[7,15,7,16],[8,0,8,1],[8,3,8,5],[8,6,8,8],[8,15,8,16],[8,17,8,19],[5,0,5,12],[5,13,5,16],[5,17,5,19],[6,0,6,12],[6,13,6,16],[6,17,6,19],[9,15,11,16],[9,17,11,19],[12,0,13,0],[12,1,13,1],[12,2,13,4],[12,5,12,10],[12,11,12,16],[12,17,12,19],[13,5,13,7],[13,8,13,10],[13,11,13,13],[13,14,13,16],[13,17,13,19],[15,2,15,3],[15,5,15,6],[15,8,15,9],[15,11,15,12],[15,14,15,15],[15,17,15,19],[17,2,17,3],[17,5,17,6],[17,8,17,9],[17,11,17,12],[17,14,17,15],[17,17,17,19],[16,2,16,3],[16,5,16,6],[16,8,16,9],[16,11,16,12],[16,14,16,15],[16,17,16,19],[19,2,19,3],[19,5,19,6],[19,8,19,9],[19,11,19,12],[19,14,19,15],[19,17,19,19],[18,2,18,3],[18,5,18,6],[18,8,18,9],[18,11,18,12],[18,14,18,15],[18,17,18,19],[21,2,21,3],[21,5,21,6],[21,8,21,9],[21,11,21,12],[21,14,21,15],[21,17,21,19],[20,2,20,3],[20,5,20,6],[20,8,20,9],[20,11,20,12],[20,14,20,15],[20,17,20,19],[23,2,23,3],[23,5,23,6],[23,8,23,9],[23,11,23,12],[23,14,23,15],[23,17,23,19],[22,2,22,3],[22,5,22,6],[22,8,22,9],[22,11,22,12],[22,14,22,15],[22,17,22,19],[25,2,25,3],[25,5,25,6],[25,8,25,9],[25,11,25,12],[25,14,25,15],[25,17,25,19],[24,2,24,3],[24,5,24,6],[24,8,24,9],[24,11,24,12],[24,14,24,15],[24,17,24,19],[27,2,27,3],[27,5,27,6],[27,8,27,9],[27,11,27,12],[27,14,27,15],[27,17,27,19],[26,2,26,3],[26,5,26,6],[26,8,26,9],[26,11,26,12],[26,14,26,15],[26,17,26,19],[29,2,29,3],[29,5,29,6],[29,8,29,9],[29,11,29,12],[29,14,29,15],[29,17,29,19],[28,2,28,3],[28,5,28,6],[28,8,28,9],[28,11,28,12],[28,14,28,15],[28,17,28,19],[33,1,33,7],[34,1,34,7],[34,8,34,9],[34,11,34,12],[34,14,34,15],[34,17,34,19],[30,0,30,16],[30,17,30,19],[31,0,32,0],[31,1,32,1],[31,8,32,10],[31,11,32,13],[31,14,32,16],[31,17,31,19],[32,17,32,19],[35,1,35,7],[35,8,35,9],[35,11,35,12],[35,14,35,15],[35,17,35,19],[36,1,36,7],[36,8,36,9],[36,11,36,12],[36,14,36,15],[36,17,36,19],[37,1,37,7],[37,8,37,9],[37,11,37,12],[37,14,37,15],[37,17,37,19],[38,1,38,7],[38,8,38,9],[38,11,38,12],[38,14,38,15],[38,17,38,19],[39,1,39,7],[39,8,39,9],[39,11,39,12],[39,14,39,15],[39,17,39,19],[40,1,40,7],[40,8,40,9],[40,11,40,12],[40,14,40,15],[40,17,40,19],[41,1,41,7],[41,8,41,9],[41,11,41,12],[41,14,41,15],[41,17,41,19],[42,1,42,7],[42,8,42,9],[42,11,42,12],[42,14,42,15],[42,17,42,19],[43,1,43,7],[43,8,43,9],[43,11,43,12],[43,14,43,15],[43,17,43,19],[44,1,44,7],[44,8,44,9],[44,11,44,12],[44,14,44,15],[44,17,44,19],[47,0,47,7],[47,8,47,16],[47,17,47,19],[48,0,48,7],[48,8,48,16],[48,17,48,19],[45,1,45,7],[45,8,45,9],[45,11,45,12],[45,14,45,15],[45,17,45,19],[46,0,46,16],[46,17,46,19],[51,1,51,7],[52,1,52,7],[52,8,52,9],[52,11,52,12],[52,14,52,15],[52,17,52,19],[49,0,50,0],[49,1,50,1],[49,8,50,10],[49,11,50,13],[49,14,50,16],[49,17,49,19],[50,17,50,19],[53,1,53,7],[53,8,53,9],[53,11,53,12],[53,14,53,15],[53,17,53,19],[54,1,54,7],[54,8,54,9],[54,11,54,12],[54,14,54,15],[54,17,54,19],[55,1,55,7],[55,8,55,9],[55,11,55,12],[55,14,55,15],[55,17,55,19],[56,1,56,7],[56,8,56,9],[56,11,56,12],[56,14,56,15],[56,17,56,19],[57,1,57,7],[57,8,57,9],[57,11,57,12],[57,14,57,15],[57,17,57,19],[58,1,58,7],[58,8,58,9],[58,11,58,12],[58,14,58,15],[58,17,58,19],[59,1,59,7],[59,8,59,9],[59,11,59,12],[59,14,59,15],[59,17,59,19],[60,1,60,7],[60,8,60,9],[60,11,60,12],[60,14,60,15],[60,17,60,19],[63,17,63,19],[64,2,64,4],[64,5,64,7],[64,8,64,10],[64,11,64,13],[64,14,64,16],[64,17,64,19],[61,0,61,16],[61,17,61,19],[62,0,63,0],[62,1,63,1],[62,2,63,4],[62,5,63,7],[62,8,63,10],[62,11,63,13],[62,14,63,16],[62,17,62,19],[66,2,66,4],[66,5,66,7],[66,8,66,10],[66,11,66,13],[66,14,66,16],[66,17,66,19],[65,2,65,4],[65,5,65,7],[65,8,65,10],[65,11,65,13],[65,14,65,16],[65,17,65,19],[68,2,68,4],[68,5,68,7],[68,8,68,10],[68,11,68,13],[68,14,68,16],[68,17,68,19],[67,2,67,4],[67,5,67,7],[67,8,67,10],[67,11,67,13],[67,14,67,16],[67,17,67,19],[76,0,76,5],[77,0,77,5],[78,0,78,5],[72,0,72,16],[72,17,72,19],[73,0,73,19],[69,0,69,16],[69,17,69,19],[70,0,70,16],[70,17,70,19],[71,0,71,16],[71,17,71,19]],"flags":["formulas_cached_only"]}
[]
["PLANILHA DE COMPOSIÇÃO ANALÍTICA DE PREÇOS UNITÁRIOS"]
[]
[]
["DATA BASE: MARÇO 2013",{"$nulls":12},"CÓDIGO"]
["SERVIÇO: Concreto Betuminoso Usinado a Quente (faixa \"B\")",{"$nulls":12},"2 S 02 540 02"]
[]
[]
[null,null,null,"BDI: 26,70%",{"$nulls":11},"UNID.",null,"DATA"]
[{"$nulls":15},"T"]
[]
[]
["CÓDIGO","A - EQUIPAMENTO","QUANT.",null,null,"UTILIZAÇÃO",{"$nulls":5},"CUSTO OPERACIONAL",{"$nulls":5},"CUSTO"]
[{"$nulls":5},"PROD.",null,null,"IMPROD.",null,null,"PROD.",null,null,"IMPROD.",null,null,"HORÁRIO"]
[]
["E 007","TRATOR DE PENEUS",1,null,null,0.24,null,null,0.76,null,null,59.14,null,null,11.85,null,null,23.1996]
["E 102","ROLO TANDEN VIB. AUTOP. 10,2 T",1,null,null,0.56,null,null,0.43999999999999995,null,null,100.65,null,null,11.85,null,null,61.57800000000001]
["E 105","ROLO COMP. DE PENEUS 25T",1,null,null,0.58,null,null,0.42000000000000004,null,null,111.4,null,null,11.85,null,null,69.589]
["E 107","VASSOURA MECANICA",1,null,null,0.24,null,null,0.76,null,null,4.58,null,null,0,null,null,1.0992]
["E 149","VIBRO ACABADORA DE ASFALTO SEM ESTEIRA",1,null,null,0.81,null,null,0.18999999999999995,null,null,140.49,null,null,20.29,null,null,117.652]
["E 404","CAMINHAO BASCULANTE 10M3",1.53,null,null,1,null,null,0,null,null,115.36,null,null,13.11,null,null,176.5008]
{"$rows_empty":9}
["A) TOTAL",{"$nulls":16},449.6186]
["CÓDIGO","B - MÃO DE OBRA",{"$nulls":6},"K,R",null,null,"QUANT.",null,null,"SALÁRIO BASE",null,null,"CUSTO"]
[{"$nulls":17},"HORÁRIO"]
[]
["T 511","ENCARREGADO DE PAVIMENTAÇÃO",{"$nulls":9},1,null,null,26.29,null,null,26.29]
["T 701","SERVENTE",{"$nulls":9},8,null,null,7.25,null,null,58]
[null,"ADICIONAL DE MÃO DE OBRA (15,51% MO)",{"$nulls":15},13.073378999999997]
{"$rows_empty":9}
["B) TOTAL",{"$nulls":16},97.363379]
["C) PRODUÇÃO DA EQUIPE             75,0000 T / h",{"$nulls":7},"CUSTO UNITÁRIO TOTAL (A+B)",{"$nulls":8},546.981979]
["D) CUSTO UNITÁRIO DA EXECUÇÃO",{"$nulls":7},"((A+B))/(C)=(D)",{"$nulls":8},7.293093053333334]
["CÓDIGO","C - MATERIAIS",{"$nulls":6},"UNID.",null,null,"CUSTO",null,null,"CONSUMO",null,null,"CUSTO"]
[{"$nulls":17},"UNITÁRIO"]
[]
["1 A 01 390 02","USINAGEM DE CBUQ (faixa \"B\")",{"$nulls":6},"T",null,null,44.93,null,null,1,null,null,44.93]
{"$rows_empty":8}
["E) TOTAL",{"$nulls":16},44.93]
["CÓDIGO","F - TRANSPORTE","D.M.T.           (T)",null,null,"D.M.T.           (P)",null,null,"TOT.              D.M.T.",null,null,"CUSTO",null,null,"CONSUMO",null,null,"CUSTO"]
[{"$nulls":17},"UNITÁRIO"]
[]
["1 A 01 390 02","CBUQ - Transporte Local",17.49,null,null,0,null,null,17.49,null,null,0.59,null,null,1,null,null,10.319099999999999]
[]
[{"$nulls":21},0]
[]
["F) TOTAL",{"$nulls":16},10.319099999999999]
["CUSTO DIRETO TOTAL: (D)+(E)+(F)",{"$nulls":16},62.542193053333335,null,null,62.542193053333335]
["BONIFICAÇÃO",{"$nulls":16},16.69876554524]
["PREÇO UNITÁRIO TOTAL",{"$nulls":16},79.24095859857334]
[]
["VALOR DO EDITAL",{"$nulls":5},79.24095859857334]
["VALOR CONTRATUAL",{"$nulls":5},{"$error":"#REF!"}]
["DESCONTO",{"$nulls":5},{"$error":"#REF!"}]
["VALOR EDITAL ADEQUADO",{"$nulls":5},{"$error":"#REF!"}]
["VALOR CONTRATUAL ADEQUADO",{"$nulls":5},{"$error":"#REF!"}]

{"sheet":"Usinagem Faixa B","index":8,"n_rows":74,"n_cols":18,"rows_kept":74,"cut":false,"hidden":true,"merged":[[0,0,0,19],[1,0,2,19],[3,0,3,12],[3,13,3,16],[3,17,3,19],[4,13,4,16],[4,17,4,19],[7,15,7,16],[8,0,8,1],[8,3,8,5],[8,6,8,8],[8,15,8,16],[8,17,8,19],[5,0,5,12],[5,13,5,16],[5,17,5,19],[6,0,6,12],[6,13,6,16],[6,17,6,19],[10,15,12,16],[10,17,12,19],[13,0,14,0],[13,1,14,1],[13,2,14,4],[13,5,13,10],[13,11,13,16],[13,17,13,19],[14,5,14,7],[14,8,14,10],[14,11,14,13],[14,14,14,16],[14,17,14,19],[16,2,16,3],[16,5,16,6],[16,8,16,9],[16,11,16,12],[16,14,16,15],[16,17,16,19],[18,2,18,3],[18,5,18,6],[18,8,18,9],[18,11,18,12],[18,14,18,15],[18,17,18,19],[17,2,17,3],[17,5,17,6],[17,8,17,9],[17,11,17,12],[17,14,17,15],[17,17,17,19],[20,2,20,3],[20,5,20,6],[20,8,20,9],[20,11,20,12],[20,14,20,15],[20,17,20,19],[19,2,19,3],[19,5,19,6],[19,8,19,9],[19,11,19,12],[19,14,19,15],[19,17,19,19],[22,2,22,3],[22,5,22,6],[22,8,22,9],[22,11,22,12],[22,14,22,15],[22,17,22,19],[21,2,21,3],[21,5,21,6],[21,8,21,9],[21,11,21,12],[21,14,21,15],[21,17,21,19],[24,2,24,3],[24,5,24,6],[24,8,24,9],[24,11,24,12],[24,14,24,15],[24,17,24,19],[23,2,23,3],[23,5,23,6],[23,8,23,9],[23,11,23,12],[23,14,23,15],[23,17,23,19],[26,2,26,3],[26,5,26,6],[26,8,26,9],[26,11,26,12],[26,14,26,15],[26,17,26,19],[25,2,25,3],[25,5,25,6],[25,8,25,9],[25,11,25,12],[25,14,25,15],[25,17,25,19],[28,2,28,3],[28,5,28,6],[28,8,28,9],[28,11,28,12],[28,14,28,15],[28,17,28,19],[27,2,27,3],[27,5,27,6],[27,8,27,9],[27,11,27,12],[27,14,27,15],[27,17,27,19],[30,2,30,3],[30,5,30,6],[30,8,30,9],[30,11,30,12],[30,14,30,15],[30,17,30,19],[29,2,29,3],[29,5,29,6],[29,8,29,9],[29,11,29,12],[29,14,29,15],[29,17,29,19],[34,1,34,7],[35,1,35,7],[35,8,35,9],[35,11,35,12],[35,14,35,15],[35,17,35,19],[31,0,31,16],[31,17,31,19],[32,0,33,0],[32,1,33,1],[32,8,33,10],[32,11,33,13],[32,14,33,16],[32,17,32,19],[33,17,33,19],[36,1,36,7],[36,8,36,9],[36,11,36,12],[36,14,36,15],[36,17,36,19],[37,1,37,7],[37,8,37,9],[37,11,37,12],[37,14,37,15],[37,17,37,19],[38,1,38,7],[38,8,38,9],[38,11,38,12],[38,14,38,15],[38,17,38,19],[39,1,39,7],[39,8,39,9],[39,11,39,12],[39,14,39,15],[39,17,39,19],[40,1,40,7],[40,8,40,9],[40,11,40,12],[40,14,40,15],[40,17,40,19],[41,1,41,7],[41,8,41,9],[41,11,41,12],[41,14,41,15],[41,17,41,19],[42,1,42,7],[42,8,42,9],[42,11,42,12],[42,14,42,15],[42,17,42,19],[43,1,43,7],[43,8,43,9],[43,11,43,12],[43,14,43,15],[43,17,43,19],[44,1,44,7],[44,8,44,9],[44,11,44,12],[44,14,44,15],[44,17,44,19],[45,1,45,7],[45,8,45,9],[45,11,45,12],[45,14,45,15],[45,17,45,19],[48,0,48,7],[48,8,48,16],[48,17,48,19],[49,0,49,7],[49,8,49,16],[49,17,49,19],[46,1,46,7],[46,8,46,9],[46,11,46,12],[46,14,46,15],[46,17,46,19],[47,0,47,16],[47,17,47,19],[52,1,52,7],[53,1,53,7],[53,8,53,9],[53,11,53,12],[53,14,53,15],[53,17,53,19],[50,0,51,0],[50,1,51,1],[50,8,51,10],[50,11,51,13],[50,14,51,16],[50,17,50,19],[51,17,51,19],[54,1,54,7],[54,8,54,9],[54,11,54,12],[54,14,54,15],[54,17,54,19],[55,1,55,7],[55,8,55,9],[55,11,55,12],[55,14,55,15],[55,17,55,19],[56,1,56,7],[56,8,56,9],[56,11,56,12],[56,14,56,15],[56,17,56,19],[57,1,57,7],[57,8,57,9],[57,11,57,12],[57,14,57,15],[57,17,57,19],[58,1,58,7],[58,8,58,9],[58,11,58,12],[58,14,58,15],[58,17,58,19],[59,1,59,7],[59,8,59,9],[59,11,59,12],[59,14,59,15],[59,17,59,19],[60,1,60,7],[60,8,60,9],[60,11,60,12],[60,14,60,15],[60,17,60,19],[61,1,61,7],[61,8,61,9],[61,11,61,12],[61,14,61,15],[61,17,61,19],[64,17,64,19],[65,2,65,4],[65,5,65,7],[65,8,65,10],[65,11,65,13],[65,14,65,16],[65,17,65,19],[62,0,62,16],[62,17,62,19],[63,0,64,0],[63,1,64,1],[63,2,64,4],[63,5,64,7],[63,8,64,10],[63,11,64,13],[63,14,64,16],[63,17,63,19],[67,2,67,4],[67,5,67,7],[67,8,67,10],[67,11,67,13],[67,14,67,16],[67,17,67,19],[66,2,66,4],[66,5,66,7],[66,8,66,10],[66,11,66,13],[66,14,66,16],[66,17,66,19],[69,2,69,4],[69,5,69,7],[69,8,69,10],[69,11,69,13],[69,14,69,16],[69,17,69,19],[68,2,68,4],[68,5,68,7],[68,8,68,10],[68,11,68,13],[68,14,68,16],[68,17,68,19],[78,0,78,19],[79,0,79,19],[73,0,73,16],[73,17,73,19],[74,0,74,19],[75,0,75,19],[76,0,76,19],[77,0,77,19],[70,0,70,16],[70,17,70,19],[71,0,71,16],[71,17,71,19],[72,0,72,16],[72,17,72,19]],"flags":["formulas_cached_only"]}
[]
["PLANILHA DE COMPOSIÇÃO ANALÍTICA DE PREÇOS UNITÁRIOS"]
[]
[]
["DATA BASE: MARÇO 2013",{"$nulls":12},"CÓDIGO"]
["SERVIÇO: Usinagem de  CBUQ (faixa \"B\")",{"$nulls":12},"1 A 01 390 03"]
[]
[]
[null,null,null,"BDI: 26,70%",{"$nulls":11},"UNID.",null,"DATA"]
[]
[{"$nulls":15},"T"]
[]
[]
["CÓDIGO","A - EQUIPAMENTO","QUANT.",null,null,"UTILIZAÇÃO",{"$nulls":5},"CUSTO OPERACIONAL",{"$nulls":5},"CUSTO"]
[{"$nulls":5},"PROD.",null,null,"IMPROD.",null,null,"PROD.",null,null,"IMPROD.",null,null,"HORÁRIO"]
[]
["E 010","CARREGADEIRA DE PENEUS - 3,30 m3",1,null,null,0.27,null,null,0.73,null,null,170.56,null,null,16.38,null,null,58.0086]
["E 110","TANQUE ESTOC. DE ASFALTO 20000 l",2,null,null,1,null,null,0,null,null,9.44,null,null,0,null,null,18.88]
["E 112","AQUECEDOR DE FLUIDO TERMICO",1,null,null,1,null,null,0,null,null,24.46,null,null,0,null,null,24.46]
["E 147","USINA DE ASFALTO A QUENTE 90/120",1,null,null,1,null,null,0,null,null,271.31,null,null,20.29,null,null,271.31]
["E 501","GRUPO GERADOR 36/40 Kva",1,null,null,1,null,null,0,null,null,28.94,null,null,11.85,null,null,28.94]
["E 503","GRUPO GERADOR 164/180 Kva",1,null,null,1,null,null,0,null,null,82.31,null,null,11.85,null,null,82.31]
{"$rows_empty":9}
["A) TOTAL",{"$nulls":16},483.9086]
["CÓDIGO","B - MÃO DE OBRA",{"$nulls":6},"K,R",null,null,"QUANT.",null,null,"SALÁRIO BASE",null,null,"CUSTO"]
[{"$nulls":17},"HORÁRIO"]
[]
["T 501","ENCARREGADO DE TURMA",{"$nulls":9},1,null,null,20.29,null,null,20.29]
["T 701","SERVENTE",{"$nulls":9},8,null,null,7.25,null,null,58]
[null,"ADICIONAL DE MÃO DE OBRA (15,51% MO)",{"$nulls":15},12.142778999999997]
{"$rows_empty":9}
["B) TOTAL",{"$nulls":16},90.43277899999998]
["C) PRODUÇÃO DA EQUIPE             75,0000 T / h",{"$nulls":7},"CUSTO UNITÁRIO TOTAL (A+B)",{"$nulls":8},574.341379]
["D) CUSTO UNITÁRIO DA EXECUÇÃO",{"$nulls":7},"((A+B))/(C)=(D)",{"$nulls":8},7.657885053333333]
["CÓDIGO","C - MATERIAIS",{"$nulls":6},"UNID.",null,null,"CUSTO",null,null,"CONSUMO",null,null,"CUSTO"]
[{"$nulls":17},"UNITÁRIO"]
[]
["M 003","OLEO COMBUSTIVEL 1 A",{"$nulls":6},"l",null,null,1.74,null,null,8,null,null,13.92]
["1A 00 716 00","AREIA COMERCIAL",{"$nulls":6},"m3",null,null,18.2,null,null,0.161,null,null,2.9302]
["1A 01 200 01","BRITA PRODUZIDA",{"$nulls":6},"m3",null,null,29.35,null,null,0.473,null,null,13.88255]
[]
[]
[]
[]
[]
[]
["E) TOTAL",{"$nulls":16},30.732750000000003]
["CÓDIGO","F - TRANSPORTE","D.M.T.           (T)",null,null,"D.M.T.           (P)",null,null,"TOT.              D.M.T.",null,null,"CUSTO",null,null,"CONSUMO",null,null,"CUSTO"]
[{"$nulls":17},"UNITÁRIO"]
[]
["1A 00 716 00","Areia - Transp Comercial",40.34,null,null,0,null,null,40.34,null,null,0.46,null,null,0.2415,null,null,4.481370600000001]
["1A 01 200 01","Brita - Transp local",4.92,null,null,0,null,null,4.92,null,null,0.59,null,null,0.7095,null,null,2.0595366]
[]
[]
["F) TOTAL",{"$nulls":16},6.540907200000001]
["CUSTO DIRETO TOTAL: (D)+(E)+(F)",{"$nulls":16},44.93154225333333]
["BONIFICAÇÃO"]
["PREÇO UNITÁRIO TOTAL"]

{"sheet":"Base BGS","index":9,"n_rows":79,"n_cols":18,"rows_kept":79,"cut":false,"hidden":true,"merged":[[0,0,0,19],[1,0,2,19],[3,0,3,12],[3,13,3,16],[3,17,3,19],[4,13,4,16],[4,17,4,19],[7,15,7,16],[8,0,8,1],[8,3,8,5],[8,6,8,8],[8,15,8,16],[8,17,8,19],[5,0,5,12],[5,13,5,16],[5,17,5,19],[6,0,6,12],[6,13,6,16],[6,17,6,19],[10,15,12,16],[10,17,12,19],[13,0,14,0],[13,1,14,1],[13,2,14,4],[13,5,13,10],[13,11,13,16],[13,17,13,19],[14,5,14,7],[14,8,14,10],[14,11,14,13],[14,14,14,16],[14,17,14,19],[16,2,16,3],[16,5,16,6],[16,8,16,9],[16,11,16,12],[16,14,16,15],[16,17,16,19],[18,2,18,3],[18,5,18,6],[18,8,18,9],[18,11,18,12],[18,14,18,15],[18,17,18,19],[17,2,17,3],[17,5,17,6],[17,8,17,9],[17,11,17,12],[17,14,17,15],[17,17,17,19],[20,2,20,3],[20,5,20,6],[20,8,20,9],[20,11,20,12],[20,14,20,15],[20,17,20,19],[19,2,19,3],[19,5,19,6],[19,8,19,9],[19,11,19,12],[19,14,19,15],[19,17,19,19],[22,2,22,3],[22,5,22,6],[22,8,22,9],[22,11,22,12],[22,14,22,15],[22,17,22,19],[21,2,21,3],[21,5,21,6],[21,8,21,9],[21,11,21,12],[21,14,21,15],[21,17,21,19],[24,2,24,3],[24,5,24,6],[24,8,24,9],[24,11,24,12],[24,14,24,15],[24,17,24,19],[23,2,23,3],[23,5,23,6],[23,8,23,9],[23,11,23,12],[23,14,23,15],[23,17,23,19],[26,2,26,3],[26,5,26,6],[26,8,26,9],[26,11,26,12],[26,14,26,15],[26,17,26,19],[25,2,25,3],[25,5,25,6],[25,8,25,9],[25,11,25,12],[25,14,25,15],[25,17,25,19],[28,2,28,3],[28,5,28,6],[28,8,28,9],[28,11,28,12],[28,14,28,15],[28,17,28,19],[27,2,27,3],[27,5,27,6],[27,8,27,9],[27,11,27,12],[27,14,27,15],[27,17,27,19],[30,2,30,3],[30,5,30,6],[30,8,30,9],[30,11,30,12],[30,14,30,15],[30,17,30,19],[29,2,29,3],[29,5,29,6],[29,8,29,9],[29,11,29,12],[29,14,29,15],[29,17,29,19],[34,1,34,7],[35,1,35,7],[35,8,35,9],[35,11,35,12],[35,14,35,15],[35,17,35,19],[31,0,31,16],[31,17,31,19],[32,0,33,0],[32,1,33,1],[32,8,33,10],[32,11,33,13],[32,14,33,16],[32,17,32,19],[33,17,33,19],[36,1,36,7],[36,8,36,9],[36,11,36,12],[36,14,36,15],[36,17,36,19],[37,1,37,7],[37,8,37,9],[37,11,37,12],[37,14,37,15],[37,17,37,19],[38,1,38,7],[38,8,38,9],[38,11,38,12],[38,14,38,15],[38,17,38,19],[39,1,39,7],[39,8,39,9],[39,11,39,12],[39,14,39,15],[39,17,39,19],[40,1,40,7],[40,8,40,9],[40,11,40,12],[40,14,40,15],[40,17,40,19],[41,1,41,7],[41,8,41,9],[41,11,41,12],[41,14,41,15],[41,17,41,19],[42,1,42,7],[42,8,42,9],[42,11,42,12],[42,14,42,15],[42,17,42,19],[43,1,43,7],[43,8,43,9],[43,11,43,12],[43,14,43,15],[43,17,43,19],[44,1,44,7],[44,8,44,9],[44,11,44,12],[44,14,44,15],[44,17,44,19],[45,1,45,7],[45,8,45,9],[45,11,45,12],[45,14,45,15],[45,17,45,19],[48,0,48,7],[48,8,48,16],[48,17,48,19],[49,0,49,7],[49,8,49,16],[49,17,49,19],[46,1,46,7],[46,8,46,9],[46,11,46,12],[46,14,46,15],[46,17,46,19],[47,0,47,16],[47,17,47,19],[52,1,52,7],[53,1,53,7],[53,8,53,9],[53,11,53,12],[53,14,53,15],[53,17,53,19],[50,0,51,0],[50,1,51,1],[50,8,51,10],[50,11,51,13],[50,14,51,16],[50,17,50,19],[51,17,51,19],[54,1,54,7],[54,8,54,9],[54,11,54,12],[54,14,54,15],[54,17,54,19],[55,1,55,7],[55,8,55,9],[55,11,55,12],[55,14,55,15],[55,17,55,19],[58,1,58,7],[58,8,58,9],[58,11,58,12],[58,14,58,15],[58,17,58,19],[56,1,56,7],[56,8,56,9],[56,11,56,12],[56,14,56,15],[56,17,56,19],[57,1,57,7],[57,8,57,9],[57,11,57,12],[57,14,57,15],[57,17,57,19],[59,1,59,7],[59,8,59,9],[59,11,59,12],[59,14,59,15],[59,17,59,19],[60,1,60,7],[60,8,60,9],[60,11,60,12],[60,14,60,15],[60,17,60,19],[61,0,61,16],[61,17,61,19],[62,0,63,0],[62,1,63,1],[62,2,63,4],[62,5,63,7],[62,8,63,10],[62,11,63,13],[62,14,63,16],[62,17,62,19],[65,2,65,4],[65,5,65,7],[65,8,65,10],[65,11,65,13],[65,14,65,16],[65,17,65,19],[63,17,63,19],[64,2,64,4],[64,5,64,7],[64,8,64,10],[64,11,64,13],[64,14,64,16],[64,17,64,19],[68,17,68,19],[67,2,67,4],[67,5,67,7],[67,8,67,10],[67,11,67,13],[67,14,67,16],[67,17,67,19],[66,2,66,4],[66,5,66,7],[66,8,66,10],[66,11,66,13],[66,14,66,16],[66,17,66,19],[75,0,75,5],[76,0,76,5],[77,0,77,5],[78,0,78,5],[68,2,68,4],[68,5,68,7],[68,8,68,10],[68,11,68,13],[72,0,72,16],[68,14,68,16],[72,17,72,19],[73,0,73,19],[69,0,69,16],[69,17,69,19],[70,0,70,16],[70,17,70,19],[71,0,71,16],[71,17,71,19],[74,0,74,5]],"flags":["formulas_cached_only"]}
[]
["PLANILHA DE COMPOSIÇÃO ANALÍTICA DE PREÇOS UNITÁRIOS"]
[]
[]
["DATA BASE: MARÇO 2013",{"$nulls":12},"CÓDIGO"]
["SERVIÇO: Base de Brita Graduada Simples",{"$nulls":12},"2 S 02 230 00"]
[]
[]
[null,null,null,"BDI: 26,70%",{"$nulls":11},"UNID.",null,"DATA"]
[]
[{"$nulls":15},"m3"]
[]
[]
["CÓDIGO","A - EQUIPAMENTO","QUANT.",null,null,"UTILIZAÇÃO",{"$nulls":5},"CUSTO OPERACIONAL",{"$nulls":5},"CUSTO"]
[{"$nulls":5},"PROD.",null,null,"IMPROD.",null,null,"PROD.",null,null,"IMPROD.",null,null,"HORÁRIO"]
[]
["E 102","ROLO TANDEN VIB. AUTOP. 10,2 T",1,null,null,0.73,null,null,0.27,null,null,100.65,null,null,11.85,null,null,76.674]
["E 105","ROLO COMP. DE PENEUS 25T",1,null,null,0.75,null,null,0.25,null,null,111.4,null,null,11.85,null,null,86.51250000000002]
["E 109","DISTRIBUIDOR DE AGREGADOS",1,null,null,0.89,null,null,0.10999999999999999,null,null,138.38,null,null,16.38,null,null,124.96]
["E 404","CAMINHÃO BASC. 10M³",3.56,null,null,1,null,null,0,null,null,115.36,null,null,13.11,null,null,410.6816]
["E 407","CAMINHÃO TANQUE- 10.000 L",1,null,null,0.7,null,null,0.30000000000000004,null,null,113.69,null,null,13.11,null,null,83.516]
{"$rows_empty":10}
["A) TOTAL",{"$nulls":16},782.3440999999999]
["CÓDIGO","B - MÃO DE OBRA",{"$nulls":6},"K,R",null,null,"QUANT.",null,null,"SALÁRIO BASE",null,null,"CUSTO"]
[{"$nulls":17},"HORÁRIO"]
[]
["T 511","ENCARREGADO DE PAVIMENTAÇÃO",{"$nulls":9},1,null,null,26.29,null,null,26.29]
["T 701","SERVENTE",{"$nulls":9},3,null,null,7.25,null,null,21.75]
[null,"ADICIONAL DE MÃO DE OBRA (15,51% MO)",{"$nulls":15},7.451003999999999]
{"$rows_empty":9}
["B) TOTAL",{"$nulls":16},55.491004]
["C) PRODUÇÃO DA EQUIPE             121,000,0000 M³ / h",{"$nulls":7},"CUSTO UNITÁRIO TOTAL (A+B)",{"$nulls":8},837.8351039999999]
["D) CUSTO UNITÁRIO DA EXECUÇÃO",{"$nulls":7},"((A+B))/(C)=(D)",{"$nulls":8},6.924257057851238]
["CÓDIGO","C - MATERIAIS",{"$nulls":6},"UNID.",null,null,"CUSTO",null,null,"CONSUMO",null,null,"CUSTO"]
[{"$nulls":17},"UNITÁRIO"]
[]
["1A 00 395 51","USINAGEM DE BRITA GRADUADA",{"$nulls":6},"M³",null,null,57.3,null,null,1,null,null,57.3]
{"$rows_empty":7}
["E) TOTAL",{"$nulls":16},57.3]
["CÓDIGO","F - TRANSPORTE","D.M.T.           (P)",null,null,"D.M.T.           (T)",null,null,"TOT.              D.M.T.",null,null,"CUSTO",null,null,"CONSUMO",null,null,"CUSTO"]
[{"$nulls":17},"UNITÁRIO"]
[]
["1A 00 395 51","BRITA GRADUADA",0,null,null,17.51,null,null,17.51,null,null,0.59,null,null,2.4,null,null,24.794159999999998]
[]
[]
[]
["F) TOTAL",{"$nulls":16},24.794159999999998]
["CUSTO DIRETO TOTAL: (D)+(E)+(F)",{"$nulls":16},89.01841705785122]
["BONIFICAÇÃO",{"$nulls":16},23.76791735444628]
["PREÇO UNITÁRIO TOTAL",{"$nulls":16},112.7763344122975]
[]
["VALOR DO EDITAL",{"$nulls":5},112.7763344122975]
["VALOR CONTRATUAL",{"$nulls":5},{"$error":"#REF!"}]
["DESCONTO",{"$nulls":5},{"$error":"#REF!"}]
["VALOR EDITAL ADEQUADO",{"$nulls":5},{"$error":"#REF!"}]
["VALOR CONTRATUAL ADEQUADO",{"$nulls":5},{"$error":"#REF!"}]

{"sheet":"Usinagem BGS","index":10,"n_rows":74,"n_cols":21,"rows_kept":74,"cut":false,"hidden":true,"merged":[[0,0,0,19],[1,0,2,19],[3,0,3,12],[3,13,3,16],[3,17,3,19],[4,13,4,16],[4,17,4,19],[7,15,7,16],[8,0,8,1],[8,3,8,5],[8,6,8,8],[8,15,8,16],[8,17,8,19],[5,0,5,12],[5,13,5,16],[5,17,5,19],[6,0,6,12],[6,13,6,16],[6,17,6,19],[10,15,12,16],[10,17,12,19],[13,0,14,0],[13,1,14,1],[13,2,14,4],[13,5,13,10],[13,11,13,16],[13,17,13,19],[14,5,14,7],[14,8,14,10],[14,11,14,13],[14,14,14,16],[14,17,14,19],[16,2,16,3],[16,5,16,6],[16,8,16,9],[16,11,16,12],[16,14,16,15],[16,17,16,19],[18,2,18,3],[18,5,18,6],[18,8,18,9],[18,11,18,12],[18,14,18,15],[18,17,18,19],[17,2,17,3],[17,5,17,6],[17,8,17,9],[17,11,17,12],[17,14,17,15],[17,17,17,19],[20,2,20,3],[20,5,20,6],[20,8,20,9],[20,11,20,12],[20,14,20,15],[20,17,20,19],[19,2,19,3],[19,5,19,6],[19,8,19,9],[19,11,19,12],[19,14,19,15],[19,17,19,19],[22,2,22,3],[22,5,22,6],[22,8,22,9],[22,11,22,12],[22,14,22,15],[22,17,22,19],[21,2,21,3],[21,5,21,6],[21,8,21,9],[21,11,21,12],[21,14,21,15],[21,17,21,19],[24,2,24,3],[24,5,24,6],[24,8,24,9],[24,11,24,12],[24,14,24,15],[24,17,24,19],[23,2,23,3],[23,5,23,6],[23,8,23,9],[23,11,23,12],[23,14,23,15],[23,17,23,19],[26,2,26,3],[26,5,26,6],[26,8,26,9],[26,11,26,12],[26,14,26,15],[26,17,26,19],[25,2,25,3],[25,5,25,6],[25,8,25,9],[25,11,25,12],[25,14,25,15],[25,17,25,19],[28,2,28,3],[28,5,28,6],[28,8,28,9],[28,11,28,12],[28,14,28,15],[28,17,28,19],[27,2,27,3],[27,5,27,6],[27,8,27,9],[27,11,27,12],[27,14,27,15],[27,17,27,19],[30,2,30,3],[30,5,30,6],[30,8,30,9],[30,11,30,12],[30,14,30,15],[30,17,30,19],[29,2,29,3],[29,5,29,6],[29,8,29,9],[29,11,29,12],[29,14,29,15],[29,17,29,19],[34,1,34,7],[35,1,35,7],[35,8,35,9],[35,11,35,12],[35,14,35,15],[35,17,35,19],[31,0,31,16],[31,17,31,19],[32,0,33,0],[32,1,33,1],[32,8,33,10],[32,11,33,13],[32,14,33,16],[32,17,32,19],[33,17,33,19],[36,1,36,7],[36,8,36,9],[36,11,36,12],[36,14,36,15],[36,17,36,19],[37,1,37,7],[37,8,37,9],[37,11,37,12],[37,14,37,15],[37,17,37,19],[38,1,38,7],[38,8,38,9],[38,11,38,12],[38,14,38,15],[38,17,38,19],[39,1,39,7],[39,8,39,9],[39,11,39,12],[39,14,39,15],[39,17,39,19],[40,1,40,7],[40,8,40,9],[40,11,40,12],[40,14,40,15],[40,17,40,19],[41,1,41,7],[41,8,41,9],[41,11,41,12],[41,14,41,15],[41,17,41,19],[42,1,42,7],[42,8,42,9],[42,11,42,12],[42,14,42,15],[42,17,42,19],[43,1,43,7],[43,8,43,9],[43,11,43,12],[43,14,43,15],[43,17,43,19],[44,1,44,7],[44,8,44,9],[44,11,44,12],[44,14,44,15],[44,17,44,19],[45,1,45,7],[45,8,45,9],[45,11,45,12],[45,14,45,15],[45,17,45,19],[48,0,48,7],[48,8,48,16],[48,17,48,19],[49,0,49,7],[49,8,49,16],[49,17,49,19],[46,1,46,7],[46,8,46,9],[46,11,46,12],[46,14,46,15],[46,17,46,19],[47,0,47,16],[47,17,47,19],[52,1,52,7],[53,1,53,7],[53,8,53,9],[53,11,53,12],[53,14,53,15],[53,17,53,19],[50,0,51,0],[50,1,51,1],[50,8,51,10],[50,11,51,13],[50,14,51,16],[50,17,50,19],[51,17,51,19],[54,1,54,7],[54,8,54,9],[54,11,54,12],[54,14,54,15],[54,17,54,19],[55,1,55,7],[55,8,55,9],[55,11,55,12],[55,14,55,15],[55,17,55,19],[56,1,56,7],[56,8,56,9],[56,11,56,12],[56,14,56,15],[56,17,56,19],[57,1,57,7],[57,8,57,9],[57,11,57,12],[57,14,57,15],[57,17,57,19],[58,1,58,7],[58,8,58,9],[58,11,58,12],[58,14,58,15],[58,17,58,19],[59,1,59,7],[59,8,59,9],[59,11,59,12],[59,14,59,15],[59,17,59,19],[60,1,60,7],[60,8,60,9],[60,11,60,12],[60,14,60,15],[60,17,60,19],[61,1,61,7],[61,8,61,9],[61,11,61,12],[61,14,61,15],[61,17,61,19],[64,17,64,19],[65,2,65,4],[65,5,65,7],[65,8,65,10],[65,11,65,13],[65,14,65,16],[65,17,65,19],[62,0,62,16],[62,17,62,19],[63,0,64,0],[63,1,64,1],[63,2,64,4],[63,5,64,7],[63,8,64,10],[63,11,64,13],[63,14,64,16],[63,17,63,19],[67,2,67,4],[67,5,67,7],[67,8,67,10],[67,11,67,13],[67,14,67,16],[67,17,67,19],[66,2,66,4],[66,5,66,7],[66,8,66,10],[66,11,66,13],[66,14,66,16],[66,17,66,19],[69,2,69,4],[69,5,69,7],[69,8,69,10],[69,11,69,13],[69,14,69,16],[69,17,69,19],[68,2,68,4],[68,5,68,7],[68,8,68,10],[68,11,68,13],[68,14,68,16],[68,17,68,19],[78,0,78,19],[79,0,79,19],[73,0,73,16],[73,17,73,19],[74,0,74,19],[75,0,75,19],[76,0,76,19],[77,0,77,19],[70,0,70,16],[70,17,70,19],[71,0,71,16],[71,17,71,19],[72,0,72,16],[72,17,72,19]],"flags":["formulas_cached_only"]}
[]
["PLANILHA DE COMPOSIÇÃO ANALÍTICA DE PREÇOS UNITÁRIOS"]
[]
[]
["DATA BASE: MARÇO 2013",{"$nulls":12},"CÓDIGO"]
["SERVIÇO: Usinagem de  Base em BGS",{"$nulls":12},"1A 00 395 51"]
[]
[]
[null,null,null,"BDI: 26,70%",{"$nulls":11},"UNID.",null,"DATA"]
[]
[{"$nulls":15},"m3"]
[]
[]
["CÓDIGO","A - EQUIPAMENTO","QUANT.",null,null,"UTILIZAÇÃO",{"$nulls":5},"CUSTO OPERACIONAL",{"$nulls":5},"CUSTO"]
[{"$nulls":5},"PROD.",null,null,"IMPROD.",null,null,"PROD.",null,null,"IMPROD.",null,null,"HORÁRIO"]
[]
["E 010","CARREGADEIRA DE PNEUS-3,3 M³",1,null,null,0.98,null,null,0.020000000000000018,null,null,170.56,null,null,16.38,null,null,167.47639999999998]
["E 016","USINA MISTURADORA DE SOLOS",1,null,null,1,null,null,0,null,null,92.72,null,null,20.29,null,null,92.72]
["E 503","GRUPO GERADOR-164/180 KVA",1,null,null,1,null,null,0,null,null,82.31,null,null,11.85,null,null,82.31]
{"$rows_empty":12}
["A) TOTAL",{"$nulls":16},342.5064]
["CÓDIGO","B - MÃO DE OBRA",{"$nulls":6},"K,R",null,null,"QUANT.",null,null,"SALÁRIO BASE",null,null,"CUSTO"]
[{"$nulls":17},"HORÁRIO"]
[]
["T 501","ENCARREGADO DE TURMA",{"$nulls":9},1,null,null,20.29,null,null,20.29]
["T 701","SERVENTE",{"$nulls":9},5,null,null,7.25,null,null,36.25]
[null,"ADICIONAL DE MÃO DE OBRA (15,51% MO)",{"$nulls":15},8.769354]
{"$rows_empty":9}
["B) TOTAL",{"$nulls":16},65.309354]
["C) PRODUÇÃO DA EQUIPE             121,00 M³ / h",{"$nulls":7},"CUSTO UNITÁRIO TOTAL (A+B)",{"$nulls":8},407.81575399999997]
["D) CUSTO UNITÁRIO DA EXECUÇÃO",{"$nulls":7},"((A+B))/(C)=(D)",{"$nulls":8},3.3703781322314046]
["CÓDIGO","C - MATERIAIS",{"$nulls":6},"UNID.",null,null,"CUSTO",null,null,"CONSUMO",null,null,"CUSTO"]
[{"$nulls":17},"UNITÁRIO"]
[]
["1A 00 200 01","BRITA",{"$nulls":6},"M³",null,null,29.35,null,null,1.6,null,null,46.96000000000001]
{"$rows_empty":8}
["E) TOTAL",{"$nulls":16},46.96000000000001]
["CÓDIGO","F - TRANSPORTE","D.M.T.           (P)",null,null,"D.M.T.           (T)",null,null,"TOT.              D.M.T.",null,null,"CUSTO",null,null,"CONSUMO",null,null,"CUSTO"]
[{"$nulls":17},"UNITÁRIO"]
[]
["1A 00 717 00","BRITA (1)",4.92,null,null,0,null,null,4.92,null,null,0.59,null,null,2.4,null,null,6.966719999999999]
[]
[]
[]
["F) TOTAL",{"$nulls":16},6.966719999999999]
["CUSTO DIRETO TOTAL: (D)+(E)+(F)",{"$nulls":16},57.297098132231405,null,null,57.297098132231405]
["BONIFICAÇÃO"]
["PREÇO UNITÁRIO TOTAL"]

{"sheet":"Cerca","index":11,"n_rows":80,"n_cols":22,"rows_kept":80,"cut":false,"hidden":true,"merged":[[0,0,0,19],[1,0,2,19],[3,0,3,12],[3,13,3,16],[3,17,3,19],[4,13,4,16],[4,17,4,19],[7,15,7,16],[8,0,8,1],[8,3,8,5],[8,6,8,8],[8,15,8,16],[8,17,8,19],[5,0,5,12],[5,13,5,16],[5,17,5,19],[6,0,6,12],[6,13,6,16],[6,17,6,19],[10,15,12,16],[10,17,12,19],[13,0,14,0],[13,1,14,1],[13,2,14,4],[13,5,13,10],[13,11,13,16],[13,17,13,19],[14,5,14,7],[14,8,14,10],[14,11,14,13],[14,14,14,16],[14,17,14,19],[16,2,16,3],[16,5,16,6],[16,8,16,9],[16,11,16,12],[16,14,16,15],[16,17,16,19],[18,2,18,3],[18,5,18,6],[18,8,18,9],[18,11,18,12],[18,14,18,15],[18,17,18,19],[17,2,17,3],[17,5,17,6],[17,8,17,9],[17,11,17,12],[17,14,17,15],[17,17,17,19],[20,2,20,3],[20,5,20,6],[20,8,20,9],[20,11,20,12],[20,14,20,15],[20,17,20,19],[19,2,19,3],[19,5,19,6],[19,8,19,9],[19,11,19,12],[19,14,19,15],[19,17,19,19],[22,2,22,3],[22,5,22,6],[22,8,22,9],[22,11,22,12],[22,14,22,15],[22,17,22,19],[21,2,21,3],[21,5,21,6],[21,8,21,9],[21,11,21,12],[21,14,21,15],[21,17,21,19],[24,2,24,3],[24,5,24,6],[24,8,24,9],[24,11,24,12],[24,14,24,15],[24,17,24,19],[23,2,23,3],[23,5,23,6],[23,8,23,9],[23,11,23,12],[23,14,23,15],[23,17,23,19],[28,1,28,7],[29,1,29,7],[29,8,29,9],[29,11,29,12],[29,14,29,15],[29,17,29,19],[25,0,25,16],[25,17,25,19],[26,0,27,0],[26,1,27,1],[26,8,27,10],[26,11,27,13],[26,14,27,16],[26,17,26,19],[27,17,27,19],[32,1,32,7],[32,8,32,9],[32,11,32,12],[32,14,32,15],[32,17,32,19],[30,1,30,7],[30,8,30,9],[30,11,30,12],[30,14,30,15],[30,17,30,19],[31,1,31,7],[31,8,31,9],[31,11,31,12],[31,14,31,15],[31,17,31,19],[34,1,34,7],[34,8,34,9],[34,11,34,12],[34,14,34,15],[34,17,34,19],[35,1,35,7],[35,8,35,9],[35,11,35,12],[35,14,35,15],[35,17,35,19],[36,1,36,7],[36,8,36,9],[36,11,36,12],[36,14,36,15],[36,17,36,19],[37,1,37,7],[37,8,37,9],[37,11,37,12],[37,14,37,15],[37,17,37,19],[38,1,38,7],[38,8,38,9],[38,11,38,12],[38,14,38,15],[38,17,38,19],[39,1,39,7],[39,8,39,9],[39,11,39,12],[39,14,39,15],[39,17,39,19],[42,0,42,7],[42,8,42,16],[42,17,42,19],[43,0,43,7],[43,8,43,16],[43,17,43,19],[40,1,40,7],[40,8,40,9],[40,11,40,12],[40,14,40,15],[40,17,40,19],[41,0,41,16],[41,17,41,19],[46,1,46,7],[47,1,47,7],[47,8,47,9],[47,11,47,12],[47,14,47,15],[47,17,47,19],[44,0,45,0],[44,1,45,1],[44,8,45,10],[44,11,45,13],[44,14,45,16],[44,17,44,19],[45,17,45,19],[48,1,48,7],[48,8,48,9],[48,11,48,12],[48,14,48,15],[48,17,48,19],[49,1,49,7],[49,8,49,9],[49,11,49,12],[49,14,49,15],[49,17,49,19],[50,1,50,7],[50,8,50,9],[50,11,50,12],[50,14,50,15],[50,17,50,19],[51,1,51,7],[51,8,51,9],[51,11,51,12],[51,14,51,15],[51,17,51,19],[52,1,52,7],[52,8,52,9],[52,11,52,12],[52,14,52,15],[52,17,52,19],[53,1,53,7],[53,8,53,9],[53,11,53,12],[53,14,53,15],[53,17,53,19],[54,1,54,7],[54,8,54,9],[54,11,54,12],[54,14,54,15],[54,17,54,19],[55,1,55,7],[55,8,55,9],[55,11,55,12],[55,14,55,15],[55,17,55,19],[58,17,58,19],[59,2,59,4],[59,5,59,7],[59,8,59,10],[59,11,59,13],[59,14,59,16],[59,17,59,19],[56,0,56,16],[56,17,56,19],[57,0,58,0],[57,1,58,1],[57,2,58,4],[57,5,58,7],[57,8,58,10],[57,11,58,13],[57,14,58,16],[57,17,57,19],[67,2,67,4],[67,5,67,7],[67,8,67,10],[67,11,67,13],[67,14,67,16],[67,17,67,19],[60,2,60,4],[60,5,60,7],[60,8,60,10],[60,11,60,13],[60,14,60,16],[60,17,60,19],[66,2,66,4],[66,5,66,7],[66,8,66,10],[61,11,61,13],[62,11,62,13],[63,11,63,13],[64,11,64,13],[65,11,65,13],[66,11,66,13],[64,2,64,4],[64,5,64,7],[64,8,64,10],[69,11,69,13],[69,14,69,16],[69,17,69,19],[68,2,68,4],[68,5,68,7],[68,8,68,10],[68,11,68,13],[68,14,68,16],[68,17,68,19],[78,0,78,5],[79,0,79,5],[33,17,33,19],[33,14,33,15],[33,11,33,12],[33,8,33,9],[33,1,33,7],[61,2,61,4],[61,5,61,7],[73,0,73,16],[73,17,73,19],[74,0,74,19],[75,0,75,5],[76,0,76,5],[77,0,77,5],[70,0,70,16],[70,17,70,19],[71,0,71,16],[71,17,71,19],[72,0,72,16],[72,17,72,19],[69,2,69,4],[69,5,69,7],[69,8,69,10],[65,2,65,4],[65,5,65,7],[65,8,65,10],[61,8,61,10],[62,2,62,4],[62,5,62,7],[62,8,62,10],[63,2,63,4],[63,5,63,7],[63,8,63,10],[61,17,61,19],[62,17,62,19],[63,17,63,19],[64,17,64,19],[65,17,65,19],[66,17,66,19],[61,14,61,16],[62,14,62,16],[63,14,63,16],[64,14,64,16],[65,14,65,16],[66,14,66,16]],"flags":["formulas_cached_only"]}
[]
["PLANILHA DE COMPOSIÇÃO ANALÍTICA DE PREÇOS UNITÁRIOS"]
[]
[]
["DATA BASE: MARÇO 2013",{"$nulls":12},"CÓDIGO"]
["SERVIÇO: Cerca de arame farpado com suporte de madeira",{"$nulls":12},"2 S 06 410 00"]
[]
[]
[null,null,null,"BDI: 26,70%",{"$nulls":11},"UNID.",null,"DATA"]
[]
[{"$nulls":15},"m"]
[]
[]
["CÓDIGO","A - EQUIPAMENTO","QUANT.",null,null,"UTILIZAÇÃO",{"$nulls":5},"CUSTO OPERACIONAL",{"$nulls":5},"CUSTO"]
[{"$nulls":5},"PROD.",null,null,"IMPROD.",null,null,"PROD.",null,null,"IMPROD.",null,null,"HORÁRIO"]
[]
["E 402","Caminhão Carroceria Fixa 15T",0.01,null,null,1,null,null,0,null,null,111.18,null,null,11.85,null,null,1.1118000000000001]
{"$rows_empty":8}
["A) TOTAL",{"$nulls":16},1.1118000000000001]
["CÓDIGO","B - MÃO DE OBRA",{"$nulls":6},"K,R",null,null,"QUANT.",null,null,"SALÁRIO BASE",null,null,"CUSTO"]
[{"$nulls":17},"HORÁRIO"]
[]
["T 501","ENCARREGADO DE TURMA",{"$nulls":9},0.04,null,null,20.29,null,null,0.8116]
["T 701","SERVENTE",{"$nulls":9},0.4,null,null,7.25,null,null,2.9000000000000004]
[null,"ADICIONAL DE MÃO DE OBRA (20,51% MO)",{"$nulls":15},0.7612491600000001]
{"$rows_empty":9}
["B) TOTAL",{"$nulls":16},4.47284916]
["C) PRODUÇÃO DA EQUIPE             1",{"$nulls":7},"CUSTO UNITÁRIO TOTAL (A+B)",{"$nulls":8},5.58464916]
["D) CUSTO UNITÁRIO DA EXECUÇÃO",{"$nulls":7},"((A+B))/(C)=(D)",{"$nulls":8},5.58464916]
["CÓDIGO","C - MATERIAIS",{"$nulls":6},"UNID.",null,null,"CUSTO",null,null,"CONSUMO",null,null,"CUSTO"]
[{"$nulls":17},"UNITÁRIO"]
[]
["M 322","Grampo para cerca galvanizado 1x9",{"$nulls":6},"Kg",null,null,3.39,null,null,0.0067,null,null,0.022713]
["M 321","Arame Farpado n 16",{"$nulls":6},"m",null,null,0.35,null,null,4,null,null,1.4]
["M 403","Mourão madeira H=2,10m D=0,10m",{"$nulls":6},"unid",null,null,13.73,null,null,0.37,null,null,5.0801]
["M 404","Mourão madeira H=2,20m D=0,15m",{"$nulls":6},"unid",null,null,9.67,null,null,0.02,null,null,0.19340000000000002]
[]
[]
[]
[]
[]
["E) TOTAL",{"$nulls":16},6.696213]
["CÓDIGO","F - TRANSPORTE","D.M.T.           (T)",null,null,"D.M.T.               (P)",null,null,"TOT.              D.M.T.",null,null,"CUSTO",null,null,"CONSUMO",null,null,"CUSTO"]
[{"$nulls":17},"UNITÁRIO"]
[]
["M 403","Mourão H=2,10 - Transp Com.",32.3,{"$nulls":5},32.3,null,null,0.45,null,null,0.0487,null,null,0.7]
["M 403","Mourão H=2,10 - Transp Com.",null,null,null,5.3,null,null,5.3,null,null,0.3,null,null,0.0487,null,null,0.077433]
["M 403","Mourão H=2,10 - Transp Loc.",17.79,{"$nulls":5},17.79,null,null,0.76,null,null,0.0487,null,null,0.6584434800000001]
["M 404","Mourão H=2,20 - Transp Com.",32.3,{"$nulls":5},32.3,null,null,0.45,null,null,0.0048,null,null,0.069768]
["M 404","Mourão H=2,20 - Transp Com.",null,null,null,5.3,null,null,5.3,null,null,0.3,null,null,0.0048,null,null,0.007631999999999999]
["M 404","Mourão H=2,20 - Transp Loc.",17.79,{"$nulls":5},17.79,null,null,0.76,null,null,0.0048,null,null,0.06489792]
["M 321","Arame Farpado",32.3,{"$nulls":5},32.3,null,null,0.45,null,null,0.0002,null,null,0.002907]
["M 321","Arame Farpado",null,null,null,5.3,null,null,5.3,null,null,0.3,null,null,0.0002,null,null,0.000318]
["M 321","Arame Farpado",17.79,{"$nulls":5},17.79,null,null,0.76,null,null,0.0002,null,null,0.00270408,null,null,null,17.79]
[]
["F) TOTAL",{"$nulls":16},1.5841034800000002]
["CUSTO DIRETO TOTAL: (D)+(E)+(F)",{"$nulls":16},13.86496564,null,null,13.86496564]
["BONIFICAÇÃO",{"$nulls":16},3.70194582588]
["PREÇO UNITÁRIO TOTAL",{"$nulls":16},17.55691146588]
[]
["VALOR DO EDITAL",{"$nulls":5},17.55691146588]
["VALOR CONTRATUAL",{"$nulls":5},{"$error":"#REF!"}]
["DESCONTO",{"$nulls":5},{"$error":"#REF!"}]
["VALOR EDITAL ADEQUADO",{"$nulls":5},{"$error":"#REF!"}]
["VALOR CONTRATUAL ADEQUADO",{"$nulls":5},{"$error":"#REF!"}]