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

{"sheet":"ORÇAMENTO","index":0,"n_rows":10,"n_cols":10,"rows_kept":10,"cut":false,"hidden":false,"merged":[[0,3,0,8],[5,8,6,8],[5,0,6,0],[5,2,6,2],[5,3,6,3],[5,4,6,4],[5,5,6,5],[5,6,6,6],[5,1,6,1],[2,1,2,6],[3,1,3,6]]}
[null,null,null,"PLANILHA ORÇAMENTÁRIA - R01 - ENGENHEIRO PLENO 50% DE DEDICAÇÃO"]
[]
[null,"OBRA: CONSTRUÇÃO DA SEDE DA CÂMARA MUNICIPAL DE IPIRANGA DO NORTE-MT"]
[null,"BANCO DE DADOS: SINAPI MT - NÃO DESONERADA - SET/24",null,null,null,null,null,"BDI:",{"$f":"BDI!C15","v":0.25}]
[]
["Item","Fonte","Código","Descricao","Unid","Qtde","Custo\nunitario","Custo total","Preço\nunitario","Preço total"]
[null,null,null,null,null,null,null,{"$f":"SUMPRODUCT($F$8:$F$9687,G8:G9687)","v":404042.46},null,{"$f":"SUMPRODUCT($F$8:$F$9687,I8:I9687)","v":505053.07500000001}]
["1.","SINAPI",93567,"ENGENHEIRO CIVIL DE OBRA PLENO COM ENCARGOS COMPLEMENTARES - REFERENTE AO ENGENHEIRO CIVIL RESIDENTE - 50% de dedicação (4 horas por dia, todos os dias)","MES",{"$f":"36*50%","v":18},21625.07,{"$f":"F8*G8","v":389251.26},{"$f":"G8*(1+$I$4)","v":27031.337500000001},{"$f":"I8*F8","v":486564.07500000001}]
["2.","SINAPI",90778,"ENGENHEIRO ELETRICISTA DE OBRA PLENO COM ENCARGOS COMPLEMENTARES - 22 HORAS MENSAIS DURANTE 4 MESES DE ACORDO COM A DEMANDA DA OBRA","H",{"$f":"22*4","v":88},123.26,{"$f":"F9*G9","v":10846.880000000001},{"$f":"G9*(1+$I$4)","v":154.07500000000002},{"$f":"I9*F9","v":13558.600000000002}]
["3.","SINAPI",90778,"ENGENHEIRO MECÂNICO DE OBRA PLENO COM ENCARGOS COMPLEMENTARES - 8 HORAS MENSAIS DURANTE 4 MESES DE ACORDO COM A DEMANDA DA OBRA","H",{"$f":"8*4","v":32},123.26,{"$f":"F10*G10","v":3944.32},{"$f":"G10*(1+$I$4)","v":154.07500000000002},{"$f":"I10*F10","v":4930.4000000000005}]

{"sheet":"BDI","index":1,"n_rows":15,"n_cols":3,"rows_kept":15,"cut":false,"hidden":false,"merged":[[2,1,2,2]]}
[]
[]
[null,"CÁLCULO DO BDI"]
[null,"BDI","%"]
[null,"ADMINISTRAÇÃO CENTRAL (AC)",0.03]
[null,"DESPESAS FINANCEIRAS (DF)",5.8999999999999999E-3]
[null,"SEGURO (S) + GARANTIA (G)",8.0000000000000002E-3]
[null,"RISCOS (R)",9.7000000000000003E-3]
[null,"TRIBUTOS (I)",8.6499999999999994E-2]
[null,"ISSQN (LOCALIDADE)",0.05]
[null,"PIS",6.4999999999999997E-3]
[null,"COFINS",0.03]
[null,"CPRB"]
[null,"LUCRO BRUTO",8.3500000000000005E-2]
[null,"TOTAL DO BDI",{"$f":"ROUND((1+(C5+C7+C8))*(1+C6)*(1+C14)/(1-C9)-1,4)","v":0.25}]

{"sheet":"CRONOGRAMA","index":2,"n_rows":21,"n_cols":40,"rows_kept":21,"cut":false,"hidden":false,"merged":[[19,2,20,3],[17,1,18,1],[17,2,18,2],[17,3,18,3],[8,0,10,0],[0,0,0,15],[2,1,2,15],[14,1,16,1],[8,1,10,1],[14,2,16,2],[11,3,13,3],[11,2,13,2],[8,2,10,2],[11,1,13,1],[8,3,10,3],[7,2,7,3],[14,3,16,3],[11,0,13,0],[14,0,16,0],[4,1,4,15]]}
["CRONOGRAMA FÍSICO/FINANCEIRO"]
[]
[null,{"$f":"ORÇAMENTO!B3","v":"OBRA: CONSTRUÇÃO DA SEDE DA CÂMARA MUNICIPAL DE IPIRANGA DO NORTE-MT"}]
[]
[null,{"$f":"ORÇAMENTO!B4","v":"BANCO DE DADOS: SINAPI MT - NÃO DESONERADA - SET/24"}]
[]
[]
[null,null,null,null,"MÊS 1","MÊS 2","MÊS 3","MÊS 4","MÊS 5","MÊS 6","MÊS 7","MÊS 8","MÊS 9","MÊS 10","MÊS 11","MÊS 12","MÊS 13","MÊS 14","MÊS 15","MÊS 16","MÊS 17","MÊS 18","MÊS 19","MÊS 20","MÊS 21","MÊS 22","MÊS 23","MÊS 24","MÊS 25","MÊS 26","MÊS 27","MÊS 28","MÊS 29","MÊS 30","MÊS 31","MÊS 32","MÊS 33","MÊS 34","MÊS 35","MÊS 36"]
["1.",{"$f":"VLOOKUP($A9,ORÇAMENTO!$A$8:$J$801,4,FALSE)","v":"ENGENHEIRO CIVIL DE OBRA PLENO COM ENCARGOS COMPLEMENTARES - REFERENTE AO ENGENHEIRO CIVIL RESIDENTE - 50% de dedicação (4 horas por dia, todos os dias)"},{"$f":"VLOOKUP($A9,ORÇAMENTO!$A$8:$J$801,10,FALSE)","v":486564.07500000001},{"$f":"C9/$C$18","v":0.96339196627997958},{"$f":"E11*$C9","v":13515.668749999999},13515.668749999999,13515.668749999999,13515.668749999999,13515.668749999999,13515.668749999999,13515.668749999999,13515.668749999999,13515.668749999999,13515.668749999999,13515.668749999999,13515.668749999999,{"$f":"Q11*$C9","v":13515.668749999999},13515.668749999999,{"$f":"S11*$C9","v":13515.668749999999},13515.668749999999,13515.668749999999,13515.668749999999,13515.668749999999,13515.668749999999,13515.668749999999,13515.668749999999,13515.668749999999,13515.668749999999,13515.668749999999,13515.668749999999,13515.668749999999,13515.668749999999,13515.668749999999,13515.668749999999,13515.668749999999,13515.668749999999,13515.668749999999,13515.668749999999,13515.668749999999,13515.668749999999]
[null,null,null,null,{"$f":"E11","v":2.7777777777777776E-2},2.7777777777777776E-2,2.7777777777777776E-2,2.7777777777777776E-2,2.7777777777777776E-2,2.7777777777777776E-2,2.7777777777777776E-2,2.7777777777777776E-2,2.7777777777777776E-2,2.7777777777777776E-2,2.7777777777777776E-2,2.7777777777777776E-2,2.7777777777777776E-2,2.7777777777777776E-2,2.7777777777777776E-2,2.7777777777777776E-2,2.7777777777777776E-2,2.7777777777777776E-2,2.7777777777777776E-2,2.7777777777777776E-2,2.7777777777777776E-2,2.7777777777777776E-2,2.7777777777777776E-2,2.7777777777777776E-2,2.7777777777777776E-2,2.7777777777777776E-2,2.7777777777777776E-2,2.7777777777777776E-2,2.7777777777777776E-2,2.7777777777777776E-2,2.7777777777777776E-2,2.7777777777777776E-2,2.7777777777777776E-2,2.7777777777777776E-2,2.7777777777777776E-2,2.7777777777777776E-2]
[null,null,null,null,{"$f":"1/36","v":2.7777777777777776E-2},2.7777777777777776E-2,2.7777777777777776E-2,2.7777777777777776E-2,2.7777777777777776E-2,2.7777777777777776E-2,2.7777777777777776E-2,2.7777777777777776E-2,2.7777777777777776E-2,2.7777777777777776E-2,2.7777777777777776E-2,2.7777777777777776E-2,2.7777777777777776E-2,2.7777777777777776E-2,2.7777777777777776E-2,2.7777777777777776E-2,2.7777777777777776E-2,2.7777777777777776E-2,2.7777777777777776E-2,2.7777777777777776E-2,2.7777777777777776E-2,2.7777777777777776E-2,2.7777777777777776E-2,2.7777777777777776E-2,2.7777777777777776E-2,2.7777777777777776E-2,2.7777777777777776E-2,2.7777777777777776E-2,2.7777777777777776E-2,2.7777777777777776E-2,2.7777777777777776E-2,2.7777777777777776E-2,2.7777777777777776E-2,2.7777777777777776E-2,2.7777777777777776E-2,{"$f":"1/36","v":2.7777777777777776E-2}]
["2.",{"$f":"VLOOKUP($A12,ORÇAMENTO!$A$8:$J$801,4,FALSE)","v":"ENGENHEIRO ELETRICISTA DE OBRA PLENO COM ENCARGOS COMPLEMENTARES - 22 HORAS MENSAIS DURANTE 4 MESES DE ACORDO COM A DEMANDA DA OBRA"},{"$f":"VLOOKUP($A12,ORÇAMENTO!$A$8:$J$801,10,FALSE)","v":13558.600000000002},{"$f":"C12/$C$18","v":2.6845891394681642E-2},{"$f":"E14*$C12","v":0},0,0,0,0,0,0,0,0,0,0,0,{"$f":"Q14*$C12","v":0},0,{"$f":"S14*$C12","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,3389.6500000000005,3389.6500000000005,3389.6500000000005,3389.6500000000005]
[null,null,null,null,{"$f":"E14","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0.25,0.25,0.25,0.25]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.25,0.25,0.25,0.25]
["3.",{"$f":"VLOOKUP($A15,ORÇAMENTO!$A$8:$J$801,4,FALSE)","v":"ENGENHEIRO MECÂNICO DE OBRA PLENO COM ENCARGOS COMPLEMENTARES - 8 HORAS MENSAIS DURANTE 4 MESES DE ACORDO COM A DEMANDA DA OBRA"},{"$f":"VLOOKUP($A15,ORÇAMENTO!$A$8:$J$801,10,FALSE)","v":4930.4000000000005},{"$f":"C15/$C$18","v":9.7621423253387782E-3},{"$f":"E17*$C15","v":0},0,0,0,0,0,0,0,0,0,0,0,{"$f":"Q17*$C15","v":0},0,{"$f":"S17*$C15","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1232.6000000000001,1232.6000000000001,1232.6000000000001,1232.6000000000001]
[null,null,null,null,{"$f":"E17","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0.25,0.25,0.25,0.25]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.25,0.25,0.25,0.25]
[null,"TOTAL",{"$f":"SUM(C9:C17)","v":505053.07500000001},{"$f":"SUM(D9:D17)","v":1},{"$f":"E9+E12+E15","v":13515.668749999999},{"$f":"F9+F12+F15","v":13515.668749999999},{"$f":"G9+G12+G15","v":13515.668749999999},13515.668749999999,13515.668749999999,13515.668749999999,13515.668749999999,13515.668749999999,13515.668749999999,13515.668749999999,13515.668749999999,13515.668749999999,13515.668749999999,13515.668749999999,{"$f":"S9+S12+S15","v":13515.668749999999},13515.668749999999,13515.668749999999,13515.668749999999,13515.668749999999,13515.668749999999,13515.668749999999,13515.668749999999,13515.668749999999,13515.668749999999,13515.668749999999,13515.668749999999,13515.668749999999,13515.668749999999,13515.668749999999,13515.668749999999,13515.668749999999,13515.668749999999,18137.918749999997,18137.918749999997,18137.918749999997,18137.918749999997]
[null,null,null,null,{"$f":"E18/$C$18","v":2.6760887952221653E-2},2.6760887952221653E-2,2.6760887952221653E-2,2.6760887952221653E-2,2.6760887952221653E-2,2.6760887952221653E-2,2.6760887952221653E-2,2.6760887952221653E-2,2.6760887952221653E-2,2.6760887952221653E-2,2.6760887952221653E-2,2.6760887952221653E-2,{"$f":"Q18/$C$18","v":2.6760887952221653E-2},2.6760887952221653E-2,{"$f":"S18/$C$18","v":2.6760887952221653E-2},2.6760887952221653E-2,2.6760887952221653E-2,2.6760887952221653E-2,2.6760887952221653E-2,2.6760887952221653E-2,2.6760887952221653E-2,2.6760887952221653E-2,2.6760887952221653E-2,2.6760887952221653E-2,2.6760887952221653E-2,2.6760887952221653E-2,2.6760887952221653E-2,2.6760887952221653E-2,2.6760887952221653E-2,2.6760887952221653E-2,2.6760887952221653E-2,2.6760887952221653E-2,3.591289638222675E-2,3.591289638222675E-2,3.591289638222675E-2,3.591289638222675E-2]
[null,null,"TOTAL ACUMULADO",null,{"$f":"E18","v":13515.668749999999},{"$f":"E20+F18","v":27031.337499999998},40547.006249999999,54062.674999999996,67578.34375,81094.012499999997,94609.681249999994,108125.34999999999,121641.01874999999,135156.6875,148672.35625000001,162188.02500000002,175703.69375000003,189219.36250000005,{"$f":"R20+S18","v":202735.03125000006},{"$f":"S20+T18","v":216250.70000000007},{"$f":"T20+U18","v":229766.36875000008},{"$f":"U20+V18","v":243282.03750000009},{"$f":"V20+W18","v":256797.7062500001},{"$f":"W20+X18","v":270313.37500000012},{"$f":"X20+Y18","v":283829.04375000013},{"$f":"Y20+Z18","v":297344.71250000014},{"$f":"Z20+AA18","v":310860.38125000015},{"$f":"AA20+AB18","v":324376.05000000016},{"$f":"AB20+AC18","v":337891.71875000017},{"$f":"AC20+AD18","v":351407.38750000019},{"$f":"AD20+AE18","v":364923.0562500002},{"$f":"AE20+AF18","v":378438.72500000021},{"$f":"AF20+AG18","v":391954.39375000022},{"$f":"AG20+AH18","v":405470.06250000023},{"$f":"AH20+AI18","v":418985.73125000024},{"$f":"AI20+AJ18","v":432501.40000000026},{"$f":"AJ20+AK18","v":450639.31875000027},{"$f":"AK20+AL18","v":468777.23750000028},{"$f":"AL20+AM18","v":486915.15625000029},{"$f":"AM20+AN18","v":505053.0750000003}]
[null,null,null,null,{"$f":"E20/$C$18","v":2.6760887952221653E-2},5.3521775904443306E-2,8.0282663856664965E-2,0.10704355180888661,0.13380443976110828,0.16056532771332993,0.18732621566555158,0.21408710361777322,0.24084799156999487,0.26760887952221657,0.29436976747443822,0.32113065542665992,{"$f":"Q20/$C$18","v":0.34789154337888156},0.37465243133110326,{"$f":"S20/$C$18","v":0.40141331928332491},0.42817420723554661,0.45493509518776831,0.48169598313998996,0.5084568710922116,0.53521775904443336,0.56197864699665501,0.58873953494887665,0.6155004229010983,0.64226131085332006,0.6690221988055417,0.69578308675776335,0.7225439747099851,0.74930486266220675,0.7760657506144284,0.80282663856665004,0.8295875265188718,0.85634841447109344,0.89226131085332028,0.928174207235547,0.96408710361777383,1.0000000000000007]

{"sheet":"ENCARGOS SOCIAIS","index":3,"n_rows":41,"n_cols":6,"rows_kept":41,"cut":false,"hidden":false,"merged":[[17,0,17,5],[29,0,29,5],[36,0,36,5],[40,0,40,1],[3,0,3,5],[4,0,5,0],[4,1,5,1],[4,2,4,3],[4,4,4,5],[6,0,6,5]]}
[]
[]
[]
["ENCARGOS   SOCIAIS   SOBRE   A   MÃO   DE   OBRA - MT"]
["CÓDIGO","DESCRIÇÃO","COM DESONERAÇÃO",null,"SEM DESONERAÇÃO"]
[null,null,"HORISTA\n%","MENSALISTA\n%","HORISTA\n%","MENSALISTA\n%"]
["GRUPO A"]
["A1","INSS",0,0,0.2,0.2]
["A2","SESI",1.4999999999999999E-2,1.4999999999999999E-2,1.4999999999999999E-2,1.4999999999999999E-2]
["A3","SENAI",0.01,0.01,0.01,0.01]
["A4","INCRA",2E-3,2E-3,2E-3,2E-3]
["A5","SEBRAE",6.0000000000000001E-3,6.0000000000000001E-3,6.0000000000000001E-3,6.0000000000000001E-3]
["A6","Salário Educação",2.5000000000000001E-2,2.5000000000000001E-2,2.5000000000000001E-2,2.5000000000000001E-2]
["A7","Seguro Contra Acidentes de Trabalho",0.03,0.03,0.03,0.03]
["A8","FGTS",0.08,0.08,0.08,0.08]
["A9","SECONCI",0,0,0,0]
["A","Total",{"$f":"SUM(C8:C16)","v":0.16799999999999998},{"$f":"SUM(D8:D16)","v":0.16799999999999998},{"$f":"SUM(E8:E16)","v":0.36800000000000005},{"$f":"SUM(F8:F16)","v":0.36800000000000005}]
["GRUPO B"]
["B1","Repouso Semanal Remunerado",0.17780000000000001,"Não incide",0.17780000000000001,"Não incide"]
["B2","Feriados",3.6700000000000003E-2,"Não incide",3.6700000000000003E-2,"Não incide"]
["B3","Auxílio - Enfermidade",9.1999999999999998E-3,6.8999999999999999E-3,9.1999999999999998E-3,6.8999999999999999E-3]
["B4","13º Salário",0.11070000000000001,8.3299999999999999E-2,0.11070000000000001,8.3299999999999999E-2]
["B5","Licença Paternidade",8.0000000000000004E-4,5.9999999999999995E-4,8.0000000000000004E-4,5.9999999999999995E-4]
["B6","Faltas Justificadas",7.4000000000000003E-3,5.5999999999999999E-3,7.4000000000000003E-3,5.5999999999999999E-3]
["B7","Dias de Chuvas",1.0999999999999999E-2,"Não incide",1.0999999999999999E-2,"Não incide"]
["B8","Auxílio Acidente de Trabalho",1.2999999999999999E-3,8.9999999999999998E-4,1.2999999999999999E-3,8.9999999999999998E-4]
["B9","Férias Gozadas",0.1376,0.1036,0.1376,0.1036]
["B10","Salário Maternidade",2.9999999999999997E-4,2.0000000000000001E-4,2.9999999999999997E-4,2.0000000000000001E-4]
["B","Total",{"$f":"SUM(C19:C28)","v":0.49280000000000013},{"$f":"SUM(D19:D28)","v":0.2011},{"$f":"SUM(E19:E28)","v":0.49280000000000013},{"$f":"SUM(F19:F28)","v":0.2011}]
["GRUPO C"]
["C1","Aviso Prévio Indenizado",8.2799999999999999E-2,6.2300000000000001E-2,8.2799999999999999E-2,6.2300000000000001E-2]
["C2","Aviso Prévio Trabalhado",2E-3,1.5E-3,2E-3,1.5E-3]
["C3","Férias Indenizadas",9.2999999999999992E-3,7.0000000000000001E-3,9.2999999999999992E-3,7.0000000000000001E-3]
["C4","Depósito Rescisão Sem Justa Causa",4.8399999999999999E-2,3.6499999999999998E-2,4.8399999999999999E-2,3.6499999999999998E-2]
["C5","Indenização Adicional",7.0000000000000001E-3,5.1999999999999998E-3,7.0000000000000001E-3,5.1999999999999998E-3]
["C","Total",{"$f":"SUM(C31:C35)","v":0.14950000000000002},{"$f":"SUM(D31:D35)","v":0.1125},{"$f":"SUM(E31:E35)","v":0.14950000000000002},{"$f":"SUM(F31:F35)","v":0.1125}]
["GRUPO D"]
["D1","Reincidência de Grupo A sobre Grupo B",{"$f":"C17*C29","v":8.2790400000000014E-2},{"$f":"D17*D29","v":3.3784799999999997E-2},{"$f":"E17*E29","v":0.18135040000000008},{"$f":"F17*F29","v":7.4004800000000009E-2}]
["D2","Reincidência de Grupo A sobre Aviso Prévio\nTrabalhado e Reincidência do FGTS sobre Aviso Prévio Indenizado",7.0000000000000001E-3,5.1999999999999998E-3,7.4000000000000003E-3,5.4999999999999997E-3]
[null,"Total",{"$f":"SUM(C38:C39)","v":8.979040000000002E-2},{"$f":"SUM(D38:D39)","v":3.89848E-2},{"$f":"SUM(E38:E39)","v":0.18875040000000007},{"$f":"SUM(F38:F39)","v":7.9504800000000014E-2}]
["TOTAL(A+B+C+D)",null,{"$f":"C17+C29+C36+C40","v":0.90009040000000007},{"$f":"D17+D29+D36+D40","v":0.52058479999999996},{"$f":"E17+E29+E36+E40","v":1.1990504000000002},{"$f":"F17+F29+F36+F40","v":0.76110480000000014}]