{"text_format":"3","workbook":"xlsx","n_sheets":5,"sheets":["Capa","Sumário","Insumos Valor","Transporte Valor","Valor total do contrato"],"not_rendered":{"images":2},"read":"whole","date_system":"1900"}

{"sheet":"Capa","index":0,"n_rows":26,"n_cols":2,"rows_kept":26,"merged":[[2,1,4,3],[6,0,6,17],[7,0,7,17],[12,1,15,16],[16,1,17,16],[20,1,21,16],[22,1,22,16],[25,1,25,16]]}
[]
[]
[]
[]
[]
[]
["PLANILHA ORÇAMENTÁRIA"]
["ATO CONVOCATÓRIO Nº 17/2026"]
[]
[]
[]
[]
[null,"AQUISIÇÃO DE INSUMOS COM TRANSPORTE, CARGA E DESCARGA PARA DAR CONTINUIDADE A IMPLANTAÇÃO DE PROJETOS DE SANEAMENTO RURAL NA BACIA HIDROGRÁFICA DO RIO DOCE, NO ÂMBITO DO SUBPROGRAMA 16.1 – INICIATIVA RIO VIVO"]
{"$rows_empty":7}
[null,"Preencher células em amarelo"]
[]
[null,"Nome da Empresa"]
[]
[]
[null,"Governador Valadares, Minas Gerais, 2026."]

{"sheet":"Sumário","index":1,"n_rows":9,"n_cols":2,"rows_kept":9,"merged":[[0,1,0,13],[1,0,2,14],[4,1,4,14],[6,1,6,14],[8,1,8,14]]}
[null,"AQUISIÇÃO DE INSUMOS COM TRANSPORTE, CARGA E DESCARGA PARA DAR CONTINUIDADE A IMPLANTAÇÃO DE PROJETOS DE SANEAMENTO RURAL NA BACIA HIDROGRÁFICA DO RIO DOCE, NO ÂMBITO DO SUBPROGRAMA 16.1 – INICIATIVA RIO VIVO"]
["SUMÁRIO EXECUTIVO"]
[]
[]
["PAINEL 1","VALOR TOTAL INSUMOS"]
[]
["PAINEL 2","VALOR TOTAL TRANSPORTE"]
[]
["PAINEL 3","VALOR TOTAL DO CONTRATO"]

{"sheet":"Insumos Valor","index":2,"n_rows":44,"n_cols":10,"rows_kept":44,"merged":[[0,0,0,4],[0,5,0,9],[2,1,2,5],[4,0,38,0],[39,0,42,0]]}
["PAINEL 1",{"$nulls":4},"VALOR TOTAL INSUMOS"]
[]
[]
["Carga","N°","Código","Órgão","Data","Descrição","Unidade","Qtd. Total","Custo Unitário (R$)","Custo Total (R$)"]
["Geral",1,35277,"SINAPI","2026-05-01","Caixa de gordura em PVC, DN 300 (un)","Un",{"v":514,"d":"514.00"},null,{"$f":"ROUND(Table_89[[#This Row],[Column24]]*Table_89[[#This Row],[Column25]],2)","v":{"v":0,"d":"R$ 0.00"}}]
[null,2,41629,"SINAPI","2026-05-02","Caixa de concreto armado, 0,60x0,60x0,50 m (un)","Un",{"v":829,"d":"829.00"},null,{"$f":"ROUND(Table_89[[#This Row],[Column24]]*Table_89[[#This Row],[Column25]],2)","v":{"v":0,"d":"R$ 0.00"}}]
[null,3,9836,"SINAPI","2026-05-03","Tubo PVC série normal, DN 100 (m)","m",{"v":17832.000000000007,"d":"17,832.00"},null,{"$f":"ROUND(Table_89[[#This Row],[Column24]]*Table_89[[#This Row],[Column25]],2)","v":{"v":0,"d":"R$ 0.00"}}]
[null,4,3520,"SINAPI","2026-05-04","Joelho PVC 90 graus, DN 100 (un)","Un",{"v":1452,"d":"1,452.00"},null,{"$f":"ROUND(Table_89[[#This Row],[Column24]]*Table_89[[#This Row],[Column25]],2)","v":{"v":0,"d":"R$ 0.00"}}]
[null,5,null,"Cotação","2026-04-01","Feno (kg)","kg",{"v":3529.999999999999,"d":"3,530.00"},null,{"$f":"ROUND(Table_89[[#This Row],[Column24]]*Table_89[[#This Row],[Column25]],2)","v":{"v":0,"d":"R$ 0.00"}}]
[null,6,null,"Cotação","2026-04-01","Muda de bananeira (un)","Un",{"v":1850,"d":"1,850.00"},null,{"$f":"ROUND(Table_89[[#This Row],[Column24]]*Table_89[[#This Row],[Column25]],2)","v":{"v":0,"d":"R$ 0.00"}}]
[null,7,13284,"SINAPI","2026-05-07","Cimento CP III-40 (kg)","kg",{"v":117149.99999999997,"d":"117,150.00"},null,{"$f":"ROUND(Table_89[[#This Row],[Column24]]*Table_89[[#This Row],[Column25]],2)","v":{"v":0,"d":"R$ 0.00"}}]
[null,8,1106,"SINAPI","2026-05-08","Cal hidratada CH-I (kg)","kg",{"v":18060,"d":"18,060.00"},null,{"$f":"ROUND(Table_89[[#This Row],[Column24]]*Table_89[[#This Row],[Column25]],2)","v":{"v":0,"d":"R$ 0.00"}}]
[null,9,43059,"SINAPI","2026-05-09","Aço CA-60, vergalhão (kg)","Kg",{"v":5423.999999999999,"d":"5,424.00"},null,{"$f":"ROUND(Table_89[[#This Row],[Column24]]*Table_89[[#This Row],[Column25]],2)","v":{"v":0,"d":"R$ 0.00"}}]
[null,10,43132,"SINAPI","2026-05-10","Arame recozido 16 BWG, D = 1,65 mm","kg",{"v":257.2,"d":"257.20"},null,{"$f":"ROUND(Table_89[[#This Row],[Column24]]*Table_89[[#This Row],[Column25]],2)","v":{"v":0,"d":"R$ 0.00"}}]
[null,11,34557,"SINAPI","2026-05-11","Tela de aço soldada, fio D = *1,20 A 1,70* mm (m)","m",{"v":7474.999999999999,"d":"7,475.00"},null,{"$f":"ROUND(Table_89[[#This Row],[Column24]]*Table_89[[#This Row],[Column25]],2)","v":{"v":0,"d":"R$ 0.00"}}]
[null,12,39961,"SINAPI","2026-05-12","Silicone acético incolor 280 g (un)","Un",{"v":871,"d":"871.00"},null,{"$f":"ROUND(Table_89[[#This Row],[Column24]]*Table_89[[#This Row],[Column25]],2)","v":{"v":0,"d":"R$ 0.00"}}]
[null,13,123,"SINAPI","2026-05-13","Aditivo impermeabilizante (L)","L",{"v":3457.3059999999996,"d":"3,457.31"},null,{"$f":"ROUND(Table_89[[#This Row],[Column24]]*Table_89[[#This Row],[Column25]],2)","v":{"v":0,"d":"R$ 0.00"}}]
[null,14,7313,"SINAPI","2026-05-14","Tinta asfáltica impermeabilizante diluída (L)","L",{"v":2808,"d":"2,808.00"},null,{"$f":"ROUND(Table_89[[#This Row],[Column24]]*Table_89[[#This Row],[Column25]],2)","v":{"v":0,"d":"R$ 0.00"}}]
[null,15,9838,"SINAPI","2026-05-15","Tubo PVC série normal, DN 50 (m)","m",{"v":1836,"d":"1,836.00"},null,{"$f":"ROUND(Table_89[[#This Row],[Column24]]*Table_89[[#This Row],[Column25]],2)","v":{"v":0,"d":"R$ 0.00"}}]
[null,16,20179,"SINAPI","2026-05-16","TE, PVC, serie r, 100 x 100 mm (un)","Un",{"v":916,"d":"916.00"},null,{"$f":"ROUND(Table_89[[#This Row],[Column24]]*Table_89[[#This Row],[Column25]],2)","v":{"v":0,"d":"R$ 0.00"}}]
[null,17,1200,"SINAPI","2026-05-17","CAP PVC, soldável, DN 100 (un)","Un",{"v":934,"d":"934.00"},null,{"$f":"ROUND(Table_89[[#This Row],[Column24]]*Table_89[[#This Row],[Column25]],2)","v":{"v":0,"d":"R$ 0.00"}}]
[null,18,37395,"SINAPI","2026-05-18","Pino de aço com furo, haste = 27 (cento)","Cento",{"v":2,"d":"2.00"},null,{"$f":"ROUND(Table_89[[#This Row],[Column24]]*Table_89[[#This Row],[Column25]],2)","v":{"v":0,"d":"R$ 0.00"}}]
[null,19,25071,"SINAPI","2026-05-19","Bloco de concreto 9x19x39 cm (un)","Un",{"v":48762,"d":"48,762.00"},null,{"$f":"ROUND(Table_89[[#This Row],[Column24]]*Table_89[[#This Row],[Column25]],2)","v":{"v":0,"d":"R$ 0.00"}}]
[null,20,null,"Cotação","2026-04-01","Pneu Irreversível (un)","Un",{"v":11515,"d":"11,515.00"},null,{"$f":"ROUND(Table_89[[#This Row],[Column24]]*Table_89[[#This Row],[Column25]],2)","v":{"v":0,"d":"R$ 0.00"}}]
[null,21,39361,"SINAPI","2026-05-21","Tanque séptico, 4 a 7 cont., cap. 1100 L (un)","Un",{"v":275,"d":"275.00"},null,{"$f":"ROUND(Table_89[[#This Row],[Column24]]*Table_89[[#This Row],[Column25]],2)","v":{"v":0,"d":"R$ 0.00"}}]
[null,22,39365,"SINAPI","2026-05-22","Filtro anaeróbio, cap. 1100 L (un)","Un",{"v":290,"d":"290.00"},null,{"$f":"ROUND(Table_89[[#This Row],[Column24]]*Table_89[[#This Row],[Column25]],2)","v":{"v":0,"d":"R$ 0.00"}}]
[null,23,39362,"SINAPI","2026-05-23","Tanque séptico, 8 a 14 cont., cap. 3000 L (un)","Un",{"v":60,"d":"60.00"},null,{"$f":"ROUND(Table_89[[#This Row],[Column24]]*Table_89[[#This Row],[Column25]],2)","v":{"v":0,"d":"R$ 0.00"}}]
[null,24,39366,"SINAPI","2026-05-24","Filtro anaeróbio, cap. 2800 L (un)","Un",{"v":39,"d":"39.00"},null,{"$f":"ROUND(Table_89[[#This Row],[Column24]]*Table_89[[#This Row],[Column25]],2)","v":{"v":0,"d":"R$ 0.00"}}]
[null,25,1379,"SINAPI","2026-05-25","Cimento CP-II 32 (kg)","kg",{"v":8899.999999999998,"d":"8,900.00"},null,{"$f":"ROUND(Table_89[[#This Row],[Column24]]*Table_89[[#This Row],[Column25]],2)","v":{"v":0,"d":"R$ 0.00"}}]
[null,26,41639,"SINAPI","2026-05-26","Anel de concreto, D = 1,50 m, H = 0,50 m (un)","Un",{"v":1975,"d":"1,975.00"},null,{"$f":"ROUND(Table_89[[#This Row],[Column24]]*Table_89[[#This Row],[Column25]],2)","v":{"v":0,"d":"R$ 0.00"}}]
[null,27,41616,"SINAPI","2026-05-27","Tampa de concreto, D = 1,50 m, E = 0,05 m (un)","Un",{"v":420,"d":"420.00"},null,{"$f":"ROUND(Table_89[[#This Row],[Column24]]*Table_89[[#This Row],[Column25]],2)","v":{"v":0,"d":"R$ 0.00"}}]
[null,28,37524,"SINAPI","2026-05-28","Tela plástica laranja, malha retangular, rolo 1.20 x 50 m (m)","m",{"v":1550,"d":"1,550.00"},null,{"$f":"ROUND(Table_89[[#This Row],[Column24]]*Table_89[[#This Row],[Column25]],2)","v":{"v":0,"d":"R$ 0.00"}}]
[null,29,7167,"SINAPI","2026-05-29","Tela de arame galvanizada, fio 2,11 mm (14 bwg), malha 5 x 5 cm, h = 2 m (m²)","m²",{"v":125.00000000000001,"d":"125.00"},null,{"$f":"ROUND(Table_89[[#This Row],[Column24]]*Table_89[[#This Row],[Column25]],2)","v":{"v":0,"d":"R$ 0.00"}}]
[null,30,7097,"SINAPI","2026-05-30","Te sanitário, PVC, DN 50 x 50 mm, serie normal, para esgoto predial (un)","Un",{"v":50,"d":"50.00"},null,{"$f":"ROUND(Table_89[[#This Row],[Column24]]*Table_89[[#This Row],[Column25]],2)","v":{"v":0,"d":"R$ 0.00"}}]
[null,31,20043,"SINAPI","2026-05-31","Redução excêntrica PVC, DN 100 x 50 mm, para esgoto predial (un)","Un",{"v":50,"d":"50.00"},null,{"$f":"ROUND(Table_89[[#This Row],[Column24]]*Table_89[[#This Row],[Column25]],2)","v":{"v":0,"d":"R$ 0.00"}}]
[null,32,20045,"SINAPI","2026-05-30","Redução excêntrica PVC, serie r, DN 75 x 50 mm, para esgoto predial (un)","Un",{"v":50,"d":"50.00"},null,{"$f":"ROUND(Table_89[[#This Row],[Column24]]*Table_89[[#This Row],[Column25]],2)","v":{"v":0,"d":"R$ 0.00"}}]
[null,33,4813,"SINAPI","2026-05-30","Placa de obra (para construção civil) em chapa galvanizada n° 22, adesivada (0,60x0,60 m) (un)","Un",{"v":240,"d":"240.00"},null,{"$f":"ROUND(Table_89[[#This Row],[Column24]]*Table_89[[#This Row],[Column25]],2)","v":{"v":0,"d":"R$ 0.00"}}]
[null,34,4813,"SINAPI","2026-05-30","Placa de obra (para construção civil) em chapa galvanizada n° 22, adesivada (1,20x1,20 m) (un)","Un",{"v":220,"d":"220.00"},null,{"$f":"ROUND(Table_89[[#This Row],[Column24]]*Table_89[[#This Row],[Column25]],2)","v":{"v":0,"d":"R$ 0.00"}}]
[null,35,null,"Composição","2026-05-30","Placa de obra (para construção civil) em chapa galvanizada n° 22, adesivada (2,4x1,2 m) com postes de fixação (m²)","m²",66.24,null,{"$f":"ROUND(Table_89[[#This Row],[Column24]]*Table_89[[#This Row],[Column25]],2)","v":{"v":0,"d":"R$ 0.00"}}]
["Granel sólido",36,370,"SINAPI","2026-05-30","Areia média (m³)","m³",{"v":2060.25,"d":"2,060.25"},null,{"$f":"ROUND(Table_89[[#This Row],[Column24]]*Table_89[[#This Row],[Column25]],2)","v":{"v":0,"d":"R$ 0.00"}}]
[null,37,4730,"SINAPI","2026-05-30","Pedra de mão ou pedra rachão (m³)","m³",{"v":1122,"d":"1,122.00"},null,{"$f":"ROUND(Table_89[[#This Row],[Column24]]*Table_89[[#This Row],[Column25]],2)","v":{"v":0,"d":"R$ 0.00"}}]
[null,38,4721,"SINAPI","2026-05-30","Pedra britada n.1 (9,5 a 19 mm) (m³)","m³",{"v":864,"d":"864.00"},null,{"$f":"ROUND(Table_89[[#This Row],[Column24]]*Table_89[[#This Row],[Column25]],2)","v":{"v":0,"d":"R$ 0.00"}}]
[null,39,4722,"SINAPI","2026-05-30","Pedra britada n. 3 (38 a 50 mm) (m³)","m³",{"v":374.7199999999999,"d":"374.72"},null,{"$f":"ROUND(Table_89[[#This Row],[Column24]]*Table_89[[#This Row],[Column25]],2)","v":{"v":0,"d":"R$ 0.00"}}]
[{"$nulls":8},"-",{"$f":"SUM(J5:J43)","v":{"v":0,"d":"R$ 0.00"}}]

{"sheet":"Transporte Valor","index":3,"n_rows":77,"n_cols":6,"rows_kept":77,"merged":[[0,1,0,5],[2,4,2,5],[3,0,6,0],[3,4,3,5],[4,4,4,5],[5,4,5,5],[6,4,6,5],[7,0,10,0],[7,4,7,5],[8,4,8,5],[9,4,9,5],[10,4,10,5],[11,0,14,0],[11,4,11,5],[12,4,12,5],[13,4,13,5],[14,4,14,5],[15,0,18,0],[15,4,15,5],[16,4,16,5],[17,4,17,5],[18,4,18,5],[19,0,22,0],[19,4,19,5],[20,4,20,5],[21,4,21,5],[22,4,22,5],[23,0,23,3],[23,4,23,5],[25,0,25,5],[49,4,49,5],[50,4,50,5],[52,0,52,5],[54,0,57,0],[58,0,61,0],[62,0,65,0],[66,0,69,0],[70,0,73,0],[74,0,74,4],[76,4,76,5],[77,4,77,5]]}
["PAINEL 2","VALOR TOTAL DO TRANPORTE"]
[]
["Lote","Município","Valor total - Carga Geral (R$)","Valor total - Carga Granel (R$)","Valor total - frete (R$)"]
["1 CH DO1 Piranga","Amparo do Serra",{"$f":"F28","v":{"v":0,"d":"R$ 0.00"}},{"$f":"F55","v":{"v":0,"d":"R$ 0.00"}},{"$f":"SUM(C4:D4)","v":{"v":0,"d":"R$ 0.00"}}]
[null,"Piranga",{"v":0,"d":"R$ 0.00"},{"$f":"F56","v":{"v":0,"d":"R$ 0.00"}},{"$f":"SUM(C5:D5)","v":{"v":0,"d":"R$ 0.00"}}]
[null,"Oratórios",{"v":0,"d":"R$ 0.00"},{"$f":"F57","v":{"v":0,"d":"R$ 0.00"}},{"v":0,"d":"R$ 0.00"}]
[null,"Ponte Nova",{"v":0,"d":"R$ 0.00"},{"v":0,"d":"R$ 0.00"},{"v":0,"d":"R$ 0.00"}]
["3 CH DO3 Santo Antônio","Dores de Ganhães",{"v":0,"d":"R$ 0.00"},{"v":0,"d":"R$ 0.00"},{"v":0,"d":"R$ 0.00"}]
[null,"Dom Joaquim",{"v":0,"d":"R$ 0.00"},{"v":0,"d":"R$ 0.00"},{"v":0,"d":"R$ 0.00"}]
[null,"Morro do Pilar",{"v":0,"d":"R$ 0.00"},{"v":0,"d":"R$ 0.00"},{"v":0,"d":"R$ 0.00"}]
[null,"Serro",{"v":0,"d":"R$ 0.00"},{"v":0,"d":"R$ 0.00"},{"v":0,"d":"R$ 0.00"}]
["4 CH DO4 Suaçuí","Água Boa",{"v":0,"d":"R$ 0.00"},{"v":0,"d":"R$ 0.00"},{"v":0,"d":"R$ 0.00"}]
[null,"Serra Azul de Minas",{"v":0,"d":"R$ 0.00"},{"v":0,"d":"R$ 0.00"},{"v":0,"d":"R$ 0.00"}]
[null,"Franciscopolis",{"v":0,"d":"R$ 0.00"},{"v":0,"d":"R$ 0.00"},{"v":0,"d":"R$ 0.00"}]
[null,"Coluna",{"v":0,"d":"R$ 0.00"},{"v":0,"d":"R$ 0.00"},{"v":0,"d":"R$ 0.00"}]
["5 CH DO5 Caratinga","Caratinga",{"v":0,"d":"R$ 0.00"},{"v":0,"d":"R$ 0.00"},{"v":0,"d":"R$ 0.00"}]
[null,"Entre Folhas",{"v":0,"d":"R$ 0.00"},{"v":0,"d":"R$ 0.00"},{"v":0,"d":"R$ 0.00"}]
[null,"Santa Bárbara do Leste",{"v":0,"d":"R$ 0.00"},{"v":0,"d":"R$ 0.00"},{"v":0,"d":"R$ 0.00"}]
[null,"Sobrália",{"v":0,"d":"R$ 0.00"},{"v":0,"d":"R$ 0.00"},{"v":0,"d":"R$ 0.00"}]
["6 CH DO6 Manhuaçu","São João do Manhuaçu",{"v":0,"d":"R$ 0.00"},{"v":0,"d":"R$ 0.00"},{"v":0,"d":"R$ 0.00"}]
[null,"Manhuaçu",{"v":0,"d":"R$ 0.00"},{"v":0,"d":"R$ 0.00"},{"v":0,"d":"R$ 0.00"}]
[null,"Luisburgo",{"v":0,"d":"R$ 0.00"},{"v":0,"d":"R$ 0.00"},{"v":0,"d":"R$ 0.00"}]
[null,"Reduto",{"v":0,"d":"R$ 0.00"},{"v":0,"d":"R$ 0.00"},{"v":0,"d":"R$ 0.00"}]
["TOTAL",{"$nulls":3},{"$f":"SUM(E4:E23)","v":{"v":0,"d":"R$ 0.00"}}]
[]
["DETALHAMENTO - CARGA GERAL"]
["Lote","Município","QTD Total de viagens (geral)","Distância Percorrida (km)","Valor Unitário da Viagem - geral (R$) ","Valor Total - geral (R$)"]
["1 CH DO1 Piranga","Amparo do Serra",{"v":8,"d":"8.00"},270,{"$f":"(Table_845[[#This Row],[Coluna4]]*$C$51+Table_845[[#This Row],[Coluna4]]*$D$51+$B$51)","v":{"v":0,"d":"R$ 0.00"}},{"$f":"Table_845[[#This Row],[Coluna5]]*Table_845[[#This Row],[Coluna3]]","v":{"v":0,"d":"R$ 0.00"}}]
[null,"Piranga",{"v":8,"d":"8.00"},333,{"$f":"(Table_845[[#This Row],[Coluna4]]*$C$51+Table_845[[#This Row],[Coluna4]]*$D$51+$B$51)","v":{"v":0,"d":"R$ 0.00"}},{"$f":"Table_845[[#This Row],[Coluna5]]*Table_845[[#This Row],[Coluna3]]","v":{"v":0,"d":"R$ 0.00"}}]
[null,"Oratórios",{"v":8,"d":"8.00"},259,{"$f":"(Table_845[[#This Row],[Coluna4]]*$C$51+Table_845[[#This Row],[Coluna4]]*$D$51+$B$51)","v":{"v":0,"d":"R$ 0.00"}},{"$f":"Table_845[[#This Row],[Coluna5]]*Table_845[[#This Row],[Coluna3]]","v":{"v":0,"d":"R$ 0.00"}}]
[null,"Ponte Nova",{"v":8,"d":"8.00"},254,{"$f":"(Table_845[[#This Row],[Coluna4]]*$C$51+Table_845[[#This Row],[Coluna4]]*$D$51+$B$51)","v":{"v":0,"d":"R$ 0.00"}},{"$f":"Table_845[[#This Row],[Coluna5]]*Table_845[[#This Row],[Coluna3]]","v":{"v":0,"d":"R$ 0.00"}}]
["3 CH DO3 Santo Antônio","Dores de Ganhães",{"v":4,"d":"4.00"},174,{"$f":"(Table_845[[#This Row],[Coluna4]]*$C$51+Table_845[[#This Row],[Coluna4]]*$D$51+$B$51)","v":{"v":0,"d":"R$ 0.00"}},{"$f":"Table_845[[#This Row],[Coluna5]]*Table_845[[#This Row],[Coluna3]]","v":{"v":0,"d":"R$ 0.00"}}]
[null,"Dom Joaquim",{"v":4,"d":"4.00"},202,{"$f":"(Table_845[[#This Row],[Coluna4]]*$C$51+Table_845[[#This Row],[Coluna4]]*$D$51+$B$51)","v":{"v":0,"d":"R$ 0.00"}},{"$f":"Table_845[[#This Row],[Coluna5]]*Table_845[[#This Row],[Coluna3]]","v":{"v":0,"d":"R$ 0.00"}}]
[null,"Morro do Pilar",{"v":4,"d":"4.00"},259,{"$f":"(Table_845[[#This Row],[Coluna4]]*$C$51+Table_845[[#This Row],[Coluna4]]*$D$51+$B$51)","v":{"v":0,"d":"R$ 0.00"}},{"$f":"Table_845[[#This Row],[Coluna5]]*Table_845[[#This Row],[Coluna3]]","v":{"v":0,"d":"R$ 0.00"}}]
[null,"Serro",{"v":4,"d":"4.00"},219,{"$f":"(Table_845[[#This Row],[Coluna4]]*$C$51+Table_845[[#This Row],[Coluna4]]*$D$51+$B$51)","v":{"v":0,"d":"R$ 0.00"}},{"$f":"Table_845[[#This Row],[Coluna5]]*Table_845[[#This Row],[Coluna3]]","v":{"v":0,"d":"R$ 0.00"}}]
["4 CH DO4 Suaçuí","Água Boa",{"v":4,"d":"4.00"},160,{"$f":"(Table_845[[#This Row],[Coluna4]]*$C$51+Table_845[[#This Row],[Coluna4]]*$D$51+$B$51)","v":{"v":0,"d":"R$ 0.00"}},{"$f":"Table_845[[#This Row],[Coluna5]]*Table_845[[#This Row],[Coluna3]]","v":{"v":0,"d":"R$ 0.00"}}]
[null,"Serra Azul de Minas",{"v":4,"d":"4.00"},223,{"$f":"(Table_845[[#This Row],[Coluna4]]*$C$51+Table_845[[#This Row],[Coluna4]]*$D$51+$B$51)","v":{"v":0,"d":"R$ 0.00"}},{"$f":"Table_845[[#This Row],[Coluna5]]*Table_845[[#This Row],[Coluna3]]","v":{"v":0,"d":"R$ 0.00"}}]
[null,"Franciscopolis",{"v":4,"d":"4.00"},150,{"$f":"(Table_845[[#This Row],[Coluna4]]*$C$51+Table_845[[#This Row],[Coluna4]]*$D$51+$B$51)","v":{"v":0,"d":"R$ 0.00"}},{"$f":"Table_845[[#This Row],[Coluna5]]*Table_845[[#This Row],[Coluna3]]","v":{"v":0,"d":"R$ 0.00"}}]
[null,"Coluna",{"v":4,"d":"4.00"},200,{"$f":"(Table_845[[#This Row],[Coluna4]]*$C$51+Table_845[[#This Row],[Coluna4]]*$D$51+$B$51)","v":{"v":0,"d":"R$ 0.00"}},{"$f":"Table_845[[#This Row],[Coluna5]]*Table_845[[#This Row],[Coluna3]]","v":{"v":0,"d":"R$ 0.00"}}]
["5 CH DO5 Caratinga","Caratinga",{"v":4,"d":"4.00"},118,{"$f":"(Table_845[[#This Row],[Coluna4]]*$C$51+Table_845[[#This Row],[Coluna4]]*$D$51+$B$51)","v":{"v":0,"d":"R$ 0.00"}},{"$f":"Table_845[[#This Row],[Coluna5]]*Table_845[[#This Row],[Coluna3]]","v":{"v":0,"d":"R$ 0.00"}}]
[null,"Entre Folhas",{"v":4,"d":"4.00"},130,{"$f":"(Table_845[[#This Row],[Coluna4]]*$C$51+Table_845[[#This Row],[Coluna4]]*$D$51+$B$51)","v":{"v":0,"d":"R$ 0.00"}},{"$f":"Table_845[[#This Row],[Coluna5]]*Table_845[[#This Row],[Coluna3]]","v":{"v":0,"d":"R$ 0.00"}}]
[null,"Santa Bárbara do Leste",{"v":4,"d":"4.00"},142,{"$f":"(Table_845[[#This Row],[Coluna4]]*$C$51+Table_845[[#This Row],[Coluna4]]*$D$51+$B$51)","v":{"v":0,"d":"R$ 0.00"}},{"$f":"Table_845[[#This Row],[Coluna5]]*Table_845[[#This Row],[Coluna3]]","v":{"v":0,"d":"R$ 0.00"}}]
[null,"Sobrália",{"v":4,"d":"4.00"},55,{"$f":"(Table_845[[#This Row],[Coluna4]]*$C$51+Table_845[[#This Row],[Coluna4]]*$D$51+$B$51)","v":{"v":0,"d":"R$ 0.00"}},{"$f":"Table_845[[#This Row],[Coluna5]]*Table_845[[#This Row],[Coluna3]]","v":{"v":0,"d":"R$ 0.00"}}]
["6 CH DO6 Manhuaçu","São João do Manhuaçu",{"v":4,"d":"4.00"},198,{"$f":"(Table_845[[#This Row],[Coluna4]]*$C$51+Table_845[[#This Row],[Coluna4]]*$D$51+$B$51)","v":{"v":0,"d":"R$ 0.00"}},{"$f":"Table_845[[#This Row],[Coluna5]]*Table_845[[#This Row],[Coluna3]]","v":{"v":0,"d":"R$ 0.00"}}]
[null,"Manhuaçu",{"v":4,"d":"4.00"},196,{"$f":"(Table_845[[#This Row],[Coluna4]]*$C$51+Table_845[[#This Row],[Coluna4]]*$D$51+$B$51)","v":{"v":0,"d":"R$ 0.00"}},{"$f":"Table_845[[#This Row],[Coluna5]]*Table_845[[#This Row],[Coluna3]]","v":{"v":0,"d":"R$ 0.00"}}]
[null,"Luisburgo",{"v":4,"d":"4.00"},210,{"$f":"(Table_845[[#This Row],[Coluna4]]*$C$51+Table_845[[#This Row],[Coluna4]]*$D$51+$B$51)","v":{"v":0,"d":"R$ 0.00"}},{"$f":"Table_845[[#This Row],[Coluna5]]*Table_845[[#This Row],[Coluna3]]","v":{"v":0,"d":"R$ 0.00"}}]
[null,"Reduto",{"v":4,"d":"4.00"},202,{"$f":"(Table_845[[#This Row],[Coluna4]]*$C$51+Table_845[[#This Row],[Coluna4]]*$D$51+$B$51)","v":{"v":0,"d":"R$ 0.00"}},{"$f":"Table_845[[#This Row],[Coluna5]]*Table_845[[#This Row],[Coluna3]]","v":{"v":0,"d":"R$ 0.00"}}]
[{"$nulls":4},"TOTAL",{"$f":"SUM(F28:F47)","v":{"v":0,"d":"R$ 0.00"}}]
[]
["Carga geral","Valor Carga e Descarga (R$)","Ida (R$/km)","Volta (R$/km)"]
[]
[]
["DETALHAMENTO - CARGA GRANEL"]
["Lote","Município","QTD Total de viagens (granel)","Distância Percorrida (km)","Valor Unitário da Viagem - granel (R$) ","Valor Total - granel (R$)"]
["1 CH DO1 Piranga","Amparo do Serra",{"v":20,"d":"20.00"},270,{"$f":"D55*$C$78+D55*$D$78+$B$78","v":{"v":0,"d":"R$ 0.00"}},{"$f":"E55*C55","v":{"v":0,"d":"R$ 0.00"}}]
[null,"Piranga",{"v":24,"d":"24.00"},333,{"v":0,"d":"R$ 0.00"},{"$f":"E56*C56","v":{"v":0,"d":"R$ 0.00"}}]
[null,"Oratórios",{"v":24,"d":"24.00"},259,{"v":0,"d":"R$ 0.00"},{"v":0,"d":"R$ 0.00"}]
[null,"Ponte Nova",{"v":20,"d":"20.00"},254,{"v":0,"d":"R$ 0.00"},{"v":0,"d":"R$ 0.00"}]
["3 CH DO3 Santo Antônio","Dores de Ganhães",{"v":8,"d":"8.00"},174,{"v":0,"d":"R$ 0.00"},{"v":0,"d":"R$ 0.00"}]
[null,"Dom Joaquim",{"v":8,"d":"8.00"},202,{"v":0,"d":"R$ 0.00"},{"v":0,"d":"R$ 0.00"}]
[null,"Morro do Pilar",{"v":8,"d":"8.00"},259,{"v":0,"d":"R$ 0.00"},{"v":0,"d":"R$ 0.00"}]
[null,"Serro",{"v":8,"d":"8.00"},219,{"v":0,"d":"R$ 0.00"},{"v":0,"d":"R$ 0.00"}]
["4 CH DO4 Suaçuí","Água Boa",{"v":16,"d":"16.00"},160,{"v":0,"d":"R$ 0.00"},{"v":0,"d":"R$ 0.00"}]
[null,"Serra Azul de Minas",{"v":16,"d":"16.00"},223,{"v":0,"d":"R$ 0.00"},{"v":0,"d":"R$ 0.00"}]
[null,"Franciscopolis",{"v":16,"d":"16.00"},150,{"v":0,"d":"R$ 0.00"},{"v":0,"d":"R$ 0.00"}]
[null,"Coluna",{"v":12,"d":"12.00"},200,{"v":0,"d":"R$ 0.00"},{"v":0,"d":"R$ 0.00"}]
["5 CH DO5 Caratinga","Caratinga",{"v":8,"d":"8.00"},118,{"v":0,"d":"R$ 0.00"},{"v":0,"d":"R$ 0.00"}]
[null,"Entre Folhas",{"v":8,"d":"8.00"},130,{"v":0,"d":"R$ 0.00"},{"v":0,"d":"R$ 0.00"}]
[null,"Santa Bárbara do Leste",{"v":8,"d":"8.00"},142,{"v":0,"d":"R$ 0.00"},{"v":0,"d":"R$ 0.00"}]
[null,"Sobrália",{"v":8,"d":"8.00"},55,{"v":0,"d":"R$ 0.00"},{"v":0,"d":"R$ 0.00"}]
["6 CH DO6 Manhuaçu","São João do Manhuaçu",{"v":8,"d":"8.00"},198,{"v":0,"d":"R$ 0.00"},{"v":0,"d":"R$ 0.00"}]
[null,"Manhuaçu",{"v":8,"d":"8.00"},196,{"v":0,"d":"R$ 0.00"},{"v":0,"d":"R$ 0.00"}]
[null,"Luisburgo",{"v":8,"d":"8.00"},210,{"v":0,"d":"R$ 0.00"},{"v":0,"d":"R$ 0.00"}]
[null,"Reduto",{"v":8,"d":"8.00"},202,{"v":0,"d":"R$ 0.00"},{"v":0,"d":"R$ 0.00"}]
["TOTAL",{"$nulls":4},{"$f":"SUM(F55:F74)","v":{"v":0,"d":"R$ 0.00"}}]
[]
["Carga granel sólido","Valor Carga e Descarga (R$)","Ida (R$/km)","Volta (R$/km)"]

{"sheet":"Valor total do contrato","index":4,"n_rows":4,"n_cols":5,"rows_kept":4,"merged":[[0,0,0,1],[0,2,0,5],[2,0,2,1],[2,2,2,3],[2,4,2,5],[3,0,6,1],[3,2,6,3],[3,4,6,5]]}
["PAINEL3",null,"VALOR TOTAL DO CONTRATO"]
[]
["VALOR INSUMOS",null,"VALOR TRANSPORTE",null,"VALOR TOTAL"]
[{"$f":"'Insumos Valor'!J44","v":{"v":0,"d":"R$ 0.00"}},null,{"$f":"'Transporte Valor'!E24","v":{"v":0,"d":"R$ 0.00"}},null,{"$f":"SUM(A4:D7)","v":{"v":0,"d":"R$ 0.00"}}]