{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Sala A","Sala B","Sala C","Sala D","Sala E","Sala F","Macros"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"comments":0,"pivot_tables":0},"unopened":[{"sheet":"Macros","index":6,"reason":"part_missing"}],"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":"Sala A","index":0,"n_rows":106,"n_cols":10,"rows_kept":106,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Taxa =",6.5000000000000002E-2,null,null,"n =",{"$f":"MAX(A7:A106)","v":12},null,"Valor Presente Líquido"]
["Macros: ","Limpa dados (Ctrl-L)",null,"Exemplo (Ctrl-E)",null,null,null,"Cálculo para intervalo de taxas  (Ctrl-R)","VPL=",{"$f":"G5-C5","v":0}]
[null,"Custos",null,null,null,"Receitas"]
[null,null,{"$f":"SUM(C7:C106)","v":15357.782471168039},{"$f":"SUM(D7:D106)","v":32698.196937831664},null,null,{"$f":"SUM(G7:G106)","v":15357.782471168037},{"$f":"SUM(H7:H106)","v":32698.196937831668},"Razão Benefício/Custo"]
["Ano","Valor","Ano 0","Ano n ",null,"Valor","Ano 0","Ano n ","B/C=",{"$f":"IF(A7=\"\",0,IF(C5=0,0,G5/C5))","v":0.99999999999999989}]
[0,8000,{"$f":"IF(A7=\"\",\"\",B7/(1+$C$2)^A7)","v":8000},{"$f":"IF(A7=\"\",\"\",B7*(1+$C$2)^($G$2-A7))","v":17032.769932361101},null,null,{"$f":"IF(A7=\"\",\"\",F7/(1+$C$2)^A7)","v":0},{"$f":"IF(A7=\"\",\"\",F7*(1+$C$2)^($G$2-A7))","v":0}]
[1,2000,1877.9342723004695,{"$f":"IF(A8=\"\",\"\",B8*(1+$C$2)^($G$2-A8))","v":3998.3028010237335},null,null,0,{"$f":"IF(A8=\"\",\"\",F8*(1+$C$2)^($G$2-A8))","v":0},"IMA corte 1:",44]
[2,800,705.32742621613886,1501.7099722154869,null,null,0,0,"Preço corte 1:",51.738045287423361]
[3,500,413.92454590148998,881.28519496214028,null,null,0,0]
[4,500,388.66154544740846,827.49783564520214,null,null,0,0,"IMA corte 2:",38]
[5,500,364.94041826047743,776.99327290629321,null,null,0,0,"Preço corte 2:",56]
[6,1500,1028.0011781985281,2188.7134448064598,null,{"$f":"A13*J8*J9","v":13658.843955879767},9360.8717863161637,19930.196937831668]
[7,1200,772.20745780171137,1644.1039960987496,null,null,0,0]
[8,500,302.11559381913594,643.23317531249984,null,null,0,0]
[9,500,283.67661391468164,603.97481249999987,null,null,0,0]
[10,500,266.36301776026448,567.11249999999995,null,null,0,0]
[11,500,250.10611996268966,532.5,null,null,0,0]
[12,1500,704.52428158504142,1500,null,{"$f":"(A19-A13)*J11*J12","v":12768},5996.9106848518722,12768]
[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,"",""]
[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,"",""]
[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,"",""]
[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,"",""]
[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,"",""]
[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,{"$f":"IF(A71=\"\",\"\",B71/(1+$C$2)^A71)","v":""},"",null,null,{"$f":"IF(A71=\"\",\"\",F71/(1+$C$2)^A71)","v":""},""]
[null,null,"",{"$f":"IF(A72=\"\",\"\",B72*(1+$C$2)^($G$2-A72))","v":""},null,null,"",{"$f":"IF(A72=\"\",\"\",F72*(1+$C$2)^($G$2-A72))","v":""}]
[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,"",""]
[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,"",""]
[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,"",""]
[null,null,"","",null,null,"",""]
[null,null,"","",null,null,"",""]
[null,null,"","",null,null,"",""]
[null,null,"","",null,null,"",""]
[null,null,"",{"$f":"IF(A104=\"\",\"\",B104*(1+$C$2)^($G$2-A104))","v":""},null,null,"",{"$f":"IF(A104=\"\",\"\",F104*(1+$C$2)^($G$2-A104))","v":""}]
[null,null,"",{"$f":"IF(A105=\"\",\"\",B105*(1+$C$2)^($G$2-A105))","v":""},null,null,"",{"$f":"IF(A105=\"\",\"\",F105*(1+$C$2)^($G$2-A105))","v":""}]
[null,null,"",{"$f":"IF(A106=\"\",\"\",B106*(1+$C$2)^($G$2-A106))","v":""},null,null,"",{"$f":"IF(A106=\"\",\"\",F106*(1+$C$2)^($G$2-A106))","v":""}]

{"sheet":"Sala B","index":1,"n_rows":106,"n_cols":10,"rows_kept":106,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Taxa =",6.5000000000000002E-2,null,null,"n =",{"$f":"MAX(A7:A106)","v":12},null,"Valor Presente Líquido"]
["Macros: ","Limpa dados (Ctrl-L)",null,"Exemplo (Ctrl-E)",null,null,null,"Cálculo para intervalo de taxas  (Ctrl-R)","VPL=",{"$f":"G5-C5","v":0}]
[null,"Custos",null,null,null,"Receitas"]
[null,null,{"$f":"SUM(C7:C106)","v":15357.782471168039},{"$f":"SUM(D7:D106)","v":32698.196937831664},null,null,{"$f":"SUM(G7:G106)","v":15357.782471168041},{"$f":"SUM(H7:H106)","v":32698.196937831672},"Razão Benefício/Custo"]
["Ano","Valor","Ano 0","Ano n ",null,"Valor","Ano 0","Ano n ","B/C=",{"$f":"IF(A7=\"\",0,IF(C5=0,0,G5/C5))","v":1.0000000000000002}]
[0,8000,{"$f":"IF(A7=\"\",\"\",B7/(1+$C$2)^A7)","v":8000},{"$f":"IF(A7=\"\",\"\",B7*(1+$C$2)^($G$2-A7))","v":17032.769932361101},null,null,{"$f":"IF(A7=\"\",\"\",F7/(1+$C$2)^A7)","v":0},{"$f":"IF(A7=\"\",\"\",F7*(1+$C$2)^($G$2-A7))","v":0}]
[1,2000,1877.9342723004695,{"$f":"IF(A8=\"\",\"\",B8*(1+$C$2)^($G$2-A8))","v":3998.3028010237335},null,null,0,{"$f":"IF(A8=\"\",\"\",F8*(1+$C$2)^($G$2-A8))","v":0},"IMA corte 1:",44]
[2,800,705.32742621613886,1501.7099722154869,null,null,0,0,"Preço corte 1:",56]
[3,500,413.92454590148998,881.28519496214028,null,null,0,0]
[4,500,388.66154544740846,827.49783564520214,null,null,0,0,"IMA corte 2:",38]
[5,500,364.94041826047743,776.99327290629321,null,null,0,0,"Preço corte 2:",48.799286078154395]
[6,1500,1028.0011781985281,2188.7134448064598,null,{"$f":"A13*J8*J9","v":14784},10131.979612324694,21571.959712012467]
[7,1200,772.20745780171137,1644.1039960987496,null,null,0,0]
[8,500,302.11559381913594,643.23317531249984,null,null,0,0]
[9,500,283.67661391468164,603.97481249999987,null,null,0,0]
[10,500,266.36301776026448,567.11249999999995,null,null,0,0]
[11,500,250.10611996268966,532.5,null,null,0,0]
[12,1500,704.52428158504142,1500,null,{"$f":"(A19-A13)*J11*J12","v":11126.237225819203},5225.8028588433453,11126.237225819203]
[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,"",""]
[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,"",""]
[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,"",""]
[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,"",""]
[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,"",""]
[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,{"$f":"IF(A71=\"\",\"\",B71/(1+$C$2)^A71)","v":""},"",null,null,{"$f":"IF(A71=\"\",\"\",F71/(1+$C$2)^A71)","v":""},""]
[null,null,"",{"$f":"IF(A72=\"\",\"\",B72*(1+$C$2)^($G$2-A72))","v":""},null,null,"",{"$f":"IF(A72=\"\",\"\",F72*(1+$C$2)^($G$2-A72))","v":""}]
[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,"",""]
[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,"",""]
[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,"",""]
[null,null,"","",null,null,"",""]
[null,null,"","",null,null,"",""]
[null,null,"","",null,null,"",""]
[null,null,"","",null,null,"",""]
[null,null,"",{"$f":"IF(A104=\"\",\"\",B104*(1+$C$2)^($G$2-A104))","v":""},null,null,"",{"$f":"IF(A104=\"\",\"\",F104*(1+$C$2)^($G$2-A104))","v":""}]
[null,null,"",{"$f":"IF(A105=\"\",\"\",B105*(1+$C$2)^($G$2-A105))","v":""},null,null,"",{"$f":"IF(A105=\"\",\"\",F105*(1+$C$2)^($G$2-A105))","v":""}]
[null,null,"",{"$f":"IF(A106=\"\",\"\",B106*(1+$C$2)^($G$2-A106))","v":""},null,null,"",{"$f":"IF(A106=\"\",\"\",F106*(1+$C$2)^($G$2-A106))","v":""}]

{"sheet":"Sala C","index":2,"n_rows":106,"n_cols":10,"rows_kept":106,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Taxa =",0.09,null,null,"n =",{"$f":"MAX(A7:A106)","v":12},null,"Valor Presente Líquido"]
["Macros: ","Limpa dados (Ctrl-L)",null,"Exemplo (Ctrl-E)",null,null,null,"Cálculo para intervalo de taxas  (Ctrl-R)","VPL=",{"$f":"G5-C5","v":0}]
[null,"Custos",null,null,null,"Receitas"]
[null,null,{"$f":"SUM(C7:C106)","v":13517.045351737306},{"$f":"SUM(D7:D106)","v":38018.917414593729},null,null,{"$f":"SUM(G7:G106)","v":13517.045351737306},{"$f":"SUM(H7:H106)","v":38018.917414593729},"Razão Benefício/Custo"]
["Ano","Valor","Ano 0","Ano n ",null,"Valor","Ano 0","Ano n ","B/C=",{"$f":"IF(A7=\"\",0,IF(C5=0,0,G5/C5))","v":1}]
[0,7000,{"$f":"IF(A7=\"\",\"\",B7/(1+$C$2)^A7)","v":7000},{"$f":"IF(A7=\"\",\"\",B7*(1+$C$2)^($G$2-A7))","v":19688.653472480273},null,null,{"$f":"IF(A7=\"\",\"\",F7/(1+$C$2)^A7)","v":0},{"$f":"IF(A7=\"\",\"\",F7*(1+$C$2)^($G$2-A7))","v":0}]
[1,2000,1834.8623853211009,{"$f":"IF(A8=\"\",\"\",B8*(1+$C$2)^($G$2-A8))","v":5160.8528106108188},null,null,0,{"$f":"IF(A8=\"\",\"\",F8*(1+$C$2)^($G$2-A8))","v":0},"IMA corte 1:",42]
[2,1000,841.6799932665599,2367.3636745921185,null,null,0,0,"Preço corte 1:",60.286690391175007]
[3,600,463.31008803663849,1303.1359676653863,null,null,0,0]
[4,600,425.05512663911787,1195.5375850141158,null,null,0,0,"IMA corte 2:",38]
[5,600,389.95883177900714,1096.8234724900144,null,null,0,0,"Preço corte 2:",55]
[6,1000,596.26732687921583,1677.1001108410007,null,{"$f":"A13*J8*J9","v":15192.245978576102},9058.6398989370882,25478.917414593729]
[7,1000,547.03424484331731,1538.6239549000004,null,null,0,0]
[8,600,301.11976780366086,846.94896600000015,null,null,0,0]
[9,600,276.25666770978057,777.01740000000018,null,null,0,0]
[10,600,253.44648413741336,712.86000000000013,null,null,0,0]
[11,600,232.51971021781043,654,null,null,0,0]
[12,1000,355.53472510368567,1000,null,{"$f":"(A19-A13)*J11*J12","v":12540},4458.405452800218,12540]
[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,"",""]
[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,"",""]
[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,"",""]
[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,"",""]
[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,"",""]
[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,{"$f":"IF(A71=\"\",\"\",B71/(1+$C$2)^A71)","v":""},"",null,null,{"$f":"IF(A71=\"\",\"\",F71/(1+$C$2)^A71)","v":""},""]
[null,null,"",{"$f":"IF(A72=\"\",\"\",B72*(1+$C$2)^($G$2-A72))","v":""},null,null,"",{"$f":"IF(A72=\"\",\"\",F72*(1+$C$2)^($G$2-A72))","v":""}]
[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,"",""]
[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,"",""]
[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,"",""]
[null,null,"","",null,null,"",""]
[null,null,"","",null,null,"",""]
[null,null,"","",null,null,"",""]
[null,null,"","",null,null,"",""]
[null,null,"",{"$f":"IF(A104=\"\",\"\",B104*(1+$C$2)^($G$2-A104))","v":""},null,null,"",{"$f":"IF(A104=\"\",\"\",F104*(1+$C$2)^($G$2-A104))","v":""}]
[null,null,"",{"$f":"IF(A105=\"\",\"\",B105*(1+$C$2)^($G$2-A105))","v":""},null,null,"",{"$f":"IF(A105=\"\",\"\",F105*(1+$C$2)^($G$2-A105))","v":""}]
[null,null,"",{"$f":"IF(A106=\"\",\"\",B106*(1+$C$2)^($G$2-A106))","v":""},null,null,"",{"$f":"IF(A106=\"\",\"\",F106*(1+$C$2)^($G$2-A106))","v":""}]

{"sheet":"Sala D","index":3,"n_rows":106,"n_cols":10,"rows_kept":106,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Taxa =",0.09,null,null,"n =",{"$f":"MAX(A7:A106)","v":12},null,"Valor Presente Líquido"]
["Macros: ","Limpa dados (Ctrl-L)",null,"Exemplo (Ctrl-E)",null,null,null,"Cálculo para intervalo de taxas  (Ctrl-R)","VPL=",{"$f":"G5-C5","v":0}]
[null,"Custos",null,null,null,"Receitas"]
[null,null,{"$f":"SUM(C7:C106)","v":13517.045351737306},{"$f":"SUM(D7:D106)","v":38018.917414593729},null,null,{"$f":"SUM(G7:G106)","v":13517.045351737306},{"$f":"SUM(H7:H106)","v":38018.917414593721},"Razão Benefício/Custo"]
["Ano","Valor","Ano 0","Ano n ",null,"Valor","Ano 0","Ano n ","B/C=",{"$f":"IF(A7=\"\",0,IF(C5=0,0,G5/C5))","v":1}]
[0,7000,{"$f":"IF(A7=\"\",\"\",B7/(1+$C$2)^A7)","v":7000},{"$f":"IF(A7=\"\",\"\",B7*(1+$C$2)^($G$2-A7))","v":19688.653472480273},null,null,{"$f":"IF(A7=\"\",\"\",F7/(1+$C$2)^A7)","v":0},{"$f":"IF(A7=\"\",\"\",F7*(1+$C$2)^($G$2-A7))","v":0}]
[1,2000,1834.8623853211009,{"$f":"IF(A8=\"\",\"\",B8*(1+$C$2)^($G$2-A8))","v":5160.8528106108188},null,null,0,{"$f":"IF(A8=\"\",\"\",F8*(1+$C$2)^($G$2-A8))","v":0},"IMA corte 1:",42]
[2,1000,841.6799932665599,2367.3636745921185,null,null,0,0,"Preço corte 1:",53]
[3,600,463.31008803663849,1303.1359676653863,null,null,0,0]
[4,600,425.05512663911787,1195.5375850141158,null,null,0,0,"IMA corte 2:",38]
[5,600,389.95883177900714,1096.8234724900144,null,null,0,0,"Preço corte 2:",68.506878658777708]
[6,1000,596.26732687921583,1677.1001108410007,null,{"$f":"A13*J8*J9","v":13356},7963.7464177988068,22399.349080392403]
[7,1000,547.03424484331731,1538.6239549000004,null,null,0,0]
[8,600,301.11976780366086,846.94896600000015,null,null,0,0]
[9,600,276.25666770978057,777.01740000000018,null,null,0,0]
[10,600,253.44648413741336,712.86000000000013,null,null,0,0]
[11,600,232.51971021781043,654,null,null,0,0]
[12,1000,355.53472510368567,1000,null,{"$f":"(A19-A13)*J11*J12","v":15619.568334201318},5553.2989339384994,15619.568334201318]
[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,"",""]
[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,"",""]
[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,"",""]
[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,"",""]
[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,"",""]
[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,{"$f":"IF(A71=\"\",\"\",B71/(1+$C$2)^A71)","v":""},"",null,null,{"$f":"IF(A71=\"\",\"\",F71/(1+$C$2)^A71)","v":""},""]
[null,null,"",{"$f":"IF(A72=\"\",\"\",B72*(1+$C$2)^($G$2-A72))","v":""},null,null,"",{"$f":"IF(A72=\"\",\"\",F72*(1+$C$2)^($G$2-A72))","v":""}]
[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,"",""]
[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,"",""]
[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,"",""]
[null,null,"","",null,null,"",""]
[null,null,"","",null,null,"",""]
[null,null,"","",null,null,"",""]
[null,null,"","",null,null,"",""]
[null,null,"",{"$f":"IF(A104=\"\",\"\",B104*(1+$C$2)^($G$2-A104))","v":""},null,null,"",{"$f":"IF(A104=\"\",\"\",F104*(1+$C$2)^($G$2-A104))","v":""}]
[null,null,"",{"$f":"IF(A105=\"\",\"\",B105*(1+$C$2)^($G$2-A105))","v":""},null,null,"",{"$f":"IF(A105=\"\",\"\",F105*(1+$C$2)^($G$2-A105))","v":""}]
[null,null,"",{"$f":"IF(A106=\"\",\"\",B106*(1+$C$2)^($G$2-A106))","v":""},null,null,"",{"$f":"IF(A106=\"\",\"\",F106*(1+$C$2)^($G$2-A106))","v":""}]

{"sheet":"Sala E","index":4,"n_rows":106,"n_cols":10,"rows_kept":106,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Taxa =",6.5000000000000002E-2,null,null,"n =",{"$f":"MAX(A7:A106)","v":12},null,"Valor Presente Líquido"]
["Macros: ","Limpa dados (Ctrl-L)",null,"Exemplo (Ctrl-E)",null,null,null,"Cálculo para intervalo de taxas  (Ctrl-R)","VPL=",{"$f":"G5-C5","v":0}]
[null,"Custos",null,null,null,"Receitas"]
[null,null,{"$f":"SUM(C7:C106)","v":14888.204856467079},{"$f":"SUM(D7:D106)","v":31698.421003258129},null,null,{"$f":"SUM(G7:G106)","v":14888.204856467084},{"$f":"SUM(H7:H106)","v":31698.42100325814},"Razão Benefício/Custo"]
["Ano","Valor","Ano 0","Ano n ",null,"Valor","Ano 0","Ano n ","B/C=",{"$f":"IF(A7=\"\",0,IF(C5=0,0,G5/C5))","v":1.0000000000000004}]
[0,7530.4223852990426,{"$f":"IF(A7=\"\",\"\",B7/(1+$C$2)^A7)","v":7530.4223852990426},{"$f":"IF(A7=\"\",\"\",B7*(1+$C$2)^($G$2-A7))","v":16032.993997787564},null,null,{"$f":"IF(A7=\"\",\"\",F7/(1+$C$2)^A7)","v":0},{"$f":"IF(A7=\"\",\"\",F7*(1+$C$2)^($G$2-A7))","v":0}]
[1,2000,1877.9342723004695,{"$f":"IF(A8=\"\",\"\",B8*(1+$C$2)^($G$2-A8))","v":3998.3028010237335},null,null,0,{"$f":"IF(A8=\"\",\"\",F8*(1+$C$2)^($G$2-A8))","v":0},"IMA corte 1:",45]
[2,800,705.32742621613886,1501.7099722154869,null,null,0,0,"Preço corte 1:",50]
[3,500,413.92454590148998,881.28519496214028,null,null,0,0]
[4,500,388.66154544740846,827.49783564520214,null,null,0,0,"IMA corte 2:",40]
[5,500,364.94041826047743,776.99327290629321,null,null,0,0,"Preço corte 2:",50]
[6,1500,1028.0011781985281,2188.7134448064598,null,{"$f":"A13*J8*J9","v":13500},9252.0106037867536,19698.42100325814]
[7,1200,772.20745780171137,1644.1039960987496,null,null,0,0]
[8,500,302.11559381913594,643.23317531249984,null,null,0,0]
[9,500,283.67661391468164,603.97481249999987,null,null,0,0]
[10,500,266.36301776026448,567.11249999999995,null,null,0,0]
[11,500,250.10611996268966,532.5,null,null,0,0]
[12,1500,704.52428158504142,1500,null,{"$f":"(A19-A13)*J11*J12","v":12000},5636.1942526803314,12000]
[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,"",""]
[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,"",""]
[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,"",""]
[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,"",""]
[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,"",""]
[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,{"$f":"IF(A71=\"\",\"\",B71/(1+$C$2)^A71)","v":""},"",null,null,{"$f":"IF(A71=\"\",\"\",F71/(1+$C$2)^A71)","v":""},""]
[null,null,"",{"$f":"IF(A72=\"\",\"\",B72*(1+$C$2)^($G$2-A72))","v":""},null,null,"",{"$f":"IF(A72=\"\",\"\",F72*(1+$C$2)^($G$2-A72))","v":""}]
[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,"",""]
[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,"",""]
[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,"",""]
[null,null,"","",null,null,"",""]
[null,null,"","",null,null,"",""]
[null,null,"","",null,null,"",""]
[null,null,"","",null,null,"",""]
[null,null,"",{"$f":"IF(A104=\"\",\"\",B104*(1+$C$2)^($G$2-A104))","v":""},null,null,"",{"$f":"IF(A104=\"\",\"\",F104*(1+$C$2)^($G$2-A104))","v":""}]
[null,null,"",{"$f":"IF(A105=\"\",\"\",B105*(1+$C$2)^($G$2-A105))","v":""},null,null,"",{"$f":"IF(A105=\"\",\"\",F105*(1+$C$2)^($G$2-A105))","v":""}]
[null,null,"",{"$f":"IF(A106=\"\",\"\",B106*(1+$C$2)^($G$2-A106))","v":""},null,null,"",{"$f":"IF(A106=\"\",\"\",F106*(1+$C$2)^($G$2-A106))","v":""}]

{"sheet":"Sala F","index":5,"n_rows":106,"n_cols":10,"rows_kept":106,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Taxa =",6.5000000000000002E-2,null,null,"n =",{"$f":"MAX(A7:A106)","v":12},null,"Valor Presente Líquido"]
["Macros: ","Limpa dados (Ctrl-L)",null,"Exemplo (Ctrl-E)",null,null,null,"Cálculo para intervalo de taxas  (Ctrl-R)","VPL=",{"$f":"G5-C5","v":0}]
[null,"Custos",null,null,null,"Receitas"]
[null,null,{"$f":"SUM(C7:C106)","v":17357.782471168037},{"$f":"SUM(D7:D106)","v":36956.389420921936},null,null,{"$f":"SUM(G7:G106)","v":17357.782471168041},{"$f":"SUM(H7:H106)","v":36956.389420921958},"Razão Benefício/Custo"]
["Ano","Valor","Ano 0","Ano n ",null,"Valor","Ano 0","Ano n ","B/C=",{"$f":"IF(A7=\"\",0,IF(C5=0,0,G5/C5))","v":1.0000000000000002}]
[0,10000,{"$f":"IF(A7=\"\",\"\",B7/(1+$C$2)^A7)","v":10000},{"$f":"IF(A7=\"\",\"\",B7*(1+$C$2)^($G$2-A7))","v":21290.962415451377},null,null,{"$f":"IF(A7=\"\",\"\",F7/(1+$C$2)^A7)","v":0},{"$f":"IF(A7=\"\",\"\",F7*(1+$C$2)^($G$2-A7))","v":0}]
[1,2000,1877.9342723004695,{"$f":"IF(A8=\"\",\"\",B8*(1+$C$2)^($G$2-A8))","v":3998.3028010237335},null,null,0,{"$f":"IF(A8=\"\",\"\",F8*(1+$C$2)^($G$2-A8))","v":0},"IMA corte 1:",57.011550507308996]
[2,800,705.32742621613886,1501.7099722154869,null,null,0,0,"Preço corte 1:",50]
[3,500,413.92454590148998,881.28519496214028,null,null,0,0]
[4,500,388.66154544740846,827.49783564520214,null,null,0,0,"IMA corte 2:",40]
[5,500,364.94041826047743,776.99327290629321,null,null,0,0,"Preço corte 2:",50]
[6,1500,1028.0011781985281,2188.7134448064598,null,{"$f":"A13*J8*J9","v":17103.465152192701},11721.58821848771,24956.389420921954]
[7,1200,772.20745780171137,1644.1039960987496,null,null,0,0]
[8,500,302.11559381913594,643.23317531249984,null,null,0,0]
[9,500,283.67661391468164,603.97481249999987,null,null,0,0]
[10,500,266.36301776026448,567.11249999999995,null,null,0,0]
[11,500,250.10611996268966,532.5,null,null,0,0]
[12,1500,704.52428158504142,1500,null,{"$f":"(A19-A13)*J11*J12","v":12000},5636.1942526803314,12000]
[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,"",""]
[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,"",""]
[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,"",""]
[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,"",""]
[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,"",""]
[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,{"$f":"IF(A71=\"\",\"\",B71/(1+$C$2)^A71)","v":""},"",null,null,{"$f":"IF(A71=\"\",\"\",F71/(1+$C$2)^A71)","v":""},""]
[null,null,"",{"$f":"IF(A72=\"\",\"\",B72*(1+$C$2)^($G$2-A72))","v":""},null,null,"",{"$f":"IF(A72=\"\",\"\",F72*(1+$C$2)^($G$2-A72))","v":""}]
[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,"",""]
[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,"",""]
[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,"",""]
[null,null,"","",null,null,"",""]
[null,null,"","",null,null,"",""]
[null,null,"","",null,null,"",""]
[null,null,"","",null,null,"",""]
[null,null,"",{"$f":"IF(A104=\"\",\"\",B104*(1+$C$2)^($G$2-A104))","v":""},null,null,"",{"$f":"IF(A104=\"\",\"\",F104*(1+$C$2)^($G$2-A104))","v":""}]
[null,null,"",{"$f":"IF(A105=\"\",\"\",B105*(1+$C$2)^($G$2-A105))","v":""},null,null,"",{"$f":"IF(A105=\"\",\"\",F105*(1+$C$2)^($G$2-A105))","v":""}]
[null,null,"",{"$f":"IF(A106=\"\",\"\",B106*(1+$C$2)^($G$2-A106))","v":""},null,null,"",{"$f":"IF(A106=\"\",\"\",F106*(1+$C$2)^($G$2-A106))","v":""}]