{"text_format":"2","workbook":"xlsx","n_sheets":1,"sheets":["BDI"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":4,"defined_names":513,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"BDI","index":0,"n_rows":49,"n_cols":5,"rows_kept":49,"cut":false,"hidden":false,"merged":[[23,2,23,4],[2,0,3,4],[6,0,6,4],[9,0,9,4],[16,0,16,4],[17,0,17,1],[18,0,18,1],[19,0,19,1],[20,0,20,1],[21,0,21,1],[22,0,22,1],[23,0,23,1],[38,1,38,3],[25,1,25,3],[27,1,27,3],[28,1,28,3],[29,2,29,3],[30,1,30,3],[31,1,31,3],[32,2,32,3],[33,1,33,3],[34,1,34,3],[36,1,36,3],[37,2,37,3],[46,2,46,3],[48,0,48,3],[39,1,39,3],[40,2,40,3],[41,1,41,3],[42,1,42,3],[43,1,43,3],[44,1,44,3]]}
[{"$f":"'[4]PLANILHA ORÇ '!A6","v":"PROPONENTE : PREFEITURA MUNICIPAL DE BARRA DO CORDA - MA"}]
[{"$f":"'[4]PLANILHA ORÇ '!A7","v":"OBRA: MELHORAMENTO DE ESTRADAS VICINAIS NO MUNICIPIO DE BARRA DO CORDA/MA"}]
[{"$f":"'[4]PLANILHA ORÇ '!A8","v":"TRECHO I:"}]
[]
[]
[]
["COMPOSIÇÃO DE BDI (%)"]
[]
["* Para cálculo do BDI, deverá ser adotada a seguinte fórmula: "]
["BDI= (((1+AC+S+R+G)*(1+DF)*(1+L))/(1-I))-1"]
["Onde:"]
["AC",{"$f":"B28","v":"ADMINISTRAÇÃO CENTRAL"}]
["DF",{"$f":"B31","v":"DESPESAS FINANCEIRAS"}]
["R",{"$f":"B34","v":"SEGURO, RISCO E GARANTIA DO EMPREENDIMENTO"}]
["L",{"$f":"B39","v":"LUCRO"}]
["I",{"$f":"B42","v":"TRIBUTOS"}]
["INTERVALO ADMISSÍVEL"]
["Item componente do BDI",null,"Mínimo","Médio ","Máximo"]
["Administração Central ",null,3.8,4.01,4.67]
["Seguro e Garantia",null,0.32,0.4,0.74]
["Risco",null,0.5,0.56000000000000005,0.97]
["Despesas financeiras",null,1.02,1.1100000000000001,1.21]
["Lucro",null,6.64,7.3,8.69]
["Tributos (soma dos itens COFINS, ISS e PIS)",null,"conforme legislação específica"]
[]
["ITEM","DISCRIMINAÇÃO",null,null,"(%)"]
[]
["AC","ADMINISTRAÇÃO CENTRAL"]
[null,"Administração central",null,null,0]
[null,null,"Total AC =",null,{"$f":"SUM(E29)","v":0}]
["DF","DESPESAS FINANCEIRAS"]
[null,"Despesas financeiras",null,null,0]
[null,null,"Total DF =",null,{"$f":"SUM(E32)","v":0}]
["S, R e G","SEGURO, RISCO E GARANTIA DO EMPREENDIMENTO"]
[null,"taxa de seguros",null,null,0]
[null,"taxa de riscos",null,null,0]
[null,"taxa de garantias",null,null,0]
[null,null,"Total R=",null,{"$f":"SUM(E35:E37)","v":0}]
["L","LUCRO"]
[null,"Lucro bruto",null,null,0]
[null,null,"Total L =",null,{"$f":"SUM(E40)","v":0}]
["I","TRIBUTOS"]
[null,"PIS",null,null,0]
[null,"COFINS",null,null,0]
[null,"ISSQN",null,null,0]
[null,"CPRB",null,null,0]
[null,null,"Total I =",null,{"$f":"SUM(E43:E46)","v":0}]
[]
["TOTAL (BDI) =",null,null,null,{"$f":"(((1+E30+E35+E36+E37)*(1+E33)*(1+E41))/(1-E47))-1","v":0}]