{"text_format":"3","workbook":"xlsx","n_sheets":8,"sheets":["vpl","vpl_tir","payback","Rural_agropecuária_anual","Rural_Agropecuária_mes_mes","Redidencial_anual","RESIDENCIAL_MES_MES_mono","Residencial mês_mês_tri"],"read":"whole","date_system":"1900"}

{"sheet":"vpl","index":0,"n_rows":13,"n_cols":5,"rows_kept":13}
[]
[null,"Custo de Oportunidade",null,{"v":0.07,"d":"7.00%"}]
[]
[null,"Período","Mês","Fluxo de Caixa (CF)","Valor Presente Líquido"]
[null,0,null,{"v":-5500,"d":"R$ 5,500.00"}]
[null,1,"Janeiro",{"v":1000,"d":"R$ 1,000.00"},{"$f":"NPV(D2,D6)+D5","v":{"v":-4565.420560747663,"d":"R$ 4,565.4"}}]
[null,2,"Fevereiro",{"v":1000,"d":"R$ 1,000.00"},{"$f":"NPV(D2,D7)+E6","v":{"v":-3630.8411214953267,"d":"R$ 3,630.8"}}]
[null,3,"Março",{"v":1000,"d":"R$ 1,000.00"},{"$f":"NPV(D2,D8)+E7","v":{"v":-2696.26168224299,"d":"R$ 2,696.3"}}]
[null,4,"Abril",{"v":1000,"d":"R$ 1,000.00"},{"$f":"NPV(D2,D9)+E8","v":{"v":-1761.6822429906535,"d":"R$ 1,761.7"}}]
[null,5,"Maio",{"v":1000,"d":"R$ 1,000.00"},{"$f":"NPV(D2,D10)+E9","v":{"v":-827.1028037383171,"d":"R$ 827.1"}}]
[null,6,"Junho",{"v":550,"d":"R$ 550.00"},{"$f":"NPV(D2,D11)+E10","v":{"v":-313.0841121495321,"d":"R$ 313.1"}}]
[null,7,"Julho",{"v":550,"d":"R$ 550.00"},{"$f":"NPV(D2,D12)+E11","v":{"v":200.93457943925296,"d":"R$ 200.9"}}]
[null,8,"Agosto",{"v":550,"d":"R$ 550.00"},{"$f":"NPV(D2,D11)+E12","v":{"v":714.953271028038,"d":"R$ 715.0"}}]

{"sheet":"vpl_tir","index":1,"n_rows":15,"n_cols":7,"rows_kept":15}
[]
[]
[]
[null,null,"Custo de Oportunidade",null,{"v":0.07,"d":"7.00%"}]
[]
[null,null,"Período","Mês","Fluxo de Caixa (CF)","Valor Presente Líquido","Taxa Interna de Retorno"]
[null,null,0,null,{"v":-5500,"d":"-5,500.00   "}]
[null,null,1,"Janeiro",{"v":1200,"d":"1,200.00   "},{"$f":"NPV(E4,E8)+E7","v":{"v":-4378.5046728971965,"d":"R$ 4,378.5"}},{"$f":"IRR(E7:E8)","v":{"v":-0.7818181818181819,"d":"-78%"}}]
[null,null,2,"Fevereiro",{"v":1200,"d":"1,200.00   "},{"$f":"NPV(E4,E9)+F8","v":{"v":-3257.009345794393,"d":"R$ 3,257.0"}},{"$f":"IRR(E7:E9)","v":{"v":-0.4112397833355087,"d":"-41.12%"}}]
[null,null,3,"Março",{"v":2000,"d":"2,000.00   "},{"$f":"NPV(E4,E10)+F9","v":{"v":-1387.8504672897202,"d":"R$ 1,387.9"}},{"$f":"IRR(E7:E10)","v":{"v":-0.09577650196732135,"d":"-9.58%"}}]
[null,null,4,"Abril",{"v":1000,"d":"1,000.00   "},{"$f":"NPV(E4,E11)+F10","v":{"v":-453.27102803738376,"d":"R$ 453.3"}},{"$f":"IRR(E7:E11)","v":{"v":-0.007248113290329816,"d":"-0.72%"}}]
[null,null,5,"Maio",{"v":1000,"d":"1,000.00   "},{"$f":"NPV(E4,E12)+F11","v":{"v":481.3084112149527,"d":"R$ 481.3"}},{"$f":"IRR(E7:E12)","v":{"v":0.054397575524636865,"d":"5.44%"}}]
[null,null,6,"Junho",{"v":550,"d":"550.00   "},{"$f":"NPV(E4,E13)+F12","v":{"v":995.3271028037377,"d":"R$ 995.3"}},{"$f":"IRR(E7:E13)","v":{"v":0.07932664937137202,"d":"7.93%"}}]
[null,null,7,"Julho",{"v":550,"d":"550.00   "},{"$f":"NPV(E4,E14)+F13","v":{"v":1509.3457943925227,"d":"R$ 1,509.3"}},{"$f":"IRR(E7:E14)","v":{"v":0.09884976090472697,"d":"9.88%"}}]
[null,null,8,"Agosto",{"v":550,"d":"550.00   "},{"$f":"NPV(E4,E15)+F14","v":{"v":2023.3644859813078,"d":"R$ 2,023.4"}},{"$f":"IRR(E7:E15)","v":{"v":0.11406307474886934,"d":"11.41%"}}]

{"sheet":"payback","index":2,"n_rows":14,"n_cols":6,"rows_kept":14}
[]
[]
[]
[null,"Custo de Oportunidade",null,{"v":0.07,"d":"7.00%"}]
[null,"Período","Mês","Fluxo de Caixa (CF)","Valor Presente Líquido","Taxa Interna de Retorno"]
[null,0,null,{"v":-5500,"d":"-5,500.00   "}]
[null,1,"Janeiro",{"v":1200,"d":"1,200.00   "},{"$f":"NPV(D4,D7)+D6","v":{"v":-4378.5046728971965,"d":"R$ 4,378.5"}},{"$f":"IRR(D6:D7)","v":{"v":-0.7818181818181819,"d":"-78%"}}]
[null,2,"Fevereiro",{"v":1200,"d":"1,200.00   "},{"$f":"NPV(D4,D8)+E7","v":{"v":-3257.009345794393,"d":"R$ 3,257.0"}},{"$f":"IRR(D6:D8)","v":{"v":-0.4112397833355087,"d":"-41.12%"}}]
[null,3,"Março",{"v":2000,"d":"2,000.00   "},{"$f":"NPV(D4,D9)+E8","v":{"v":-1387.8504672897202,"d":"R$ 1,387.9"}},{"$f":"IRR(D6:D9)","v":{"v":-0.09577650196732135,"d":"-9.58%"}}]
[null,4,"Abril",{"v":1100,"d":"1,100.00   "},{"$f":"NPV(D4,D10)+E9","v":{"v":-359.81308411215014,"d":"R$ 359.8"}},{"$f":"IRR(D6:D10)","v":{"v":4.929390229335695E-14,"d":"0.00%"}}]
[null,5,"Maio",{"v":1000,"d":"1,000.00   "},{"$f":"NPV(D3,D11)+E10","v":{"v":640.1869158878499,"d":"R$ 640.2"}},{"$f":"IRR(D6:D11)","v":{"v":0.05985470160260653,"d":"5.99%"}}]
[null,6,"Junho",{"v":230,"d":"230.00   "},{"$f":"NPV(D3,D12)+E11","v":{"v":870.1869158878499,"d":"R$ 870.2"}},{"$f":"IRR(D6:D12)","v":{"v":0.07051335176709661,"d":"7.05%"}}]
[null,7,"Julho",{"v":550,"d":"550.00   "},{"$f":"NPV(D3,D13)+E12","v":{"v":1420.1869158878499,"d":"R$ 1,420.2"}},{"$f":"IRR(D6:D13)","v":{"v":0.09144379356653287,"d":"9.14%"}}]
[null,8,"Agosto",{"v":550,"d":"550.00   "},{"$f":"NPV(D3,D14)+E13","v":{"v":1970.1869158878499,"d":"R$ 1,970.2"}},{"$f":"IRR(D6:D14)","v":{"v":0.10764188805875485,"d":"10.76%"}}]

{"sheet":"Rural_agropecuária_anual","index":3,"n_rows":48,"n_cols":8,"rows_kept":48,"merged":[[4,0,7,0],[4,3,11,3],[8,0,9,0]]}
[]
["Tipo Projeto","Rural/agropecuária"]
[]
[null,"Informações Importantes"]
["Dimensionamento","Tamanho do sistema a ser instalado (Wp)",18000,"Informações Financeiras","Taxa de disponibilidade (%)",{"v":0.055,"d":"5.50%"}]
[null,"Expectativa de produção mensal (kwh)",null,null,"Valor do R$/Wp",{"v":4,"d":"R$ 4.00"}]
[null,"Expectativa de produção anual de Energia (kWh)",23018,null,"Custo Total",{"$f":"F6*C5","v":{"v":72000,"d":"R$ 72,000.00"}}]
[null,"Decaimento da Produção (%/ano)",{"v":0.005,"d":"0.50%"},null,"Custo do kWh",0.386]
["Informações da instalação","Custo de disponibilidade (kWh)",100,null,"Alíquota ICMS sobre  CD",{"v":0.3,"d":"30.00%"}]
[null,"Consumo médio mensal",1894,null,"Aumento anual da tarifa",{"v":0.05,"d":"5.00%"}]
[{"$nulls":4},"Custos de manutenção diversos (R$/mês)",20]
[{"$nulls":4},"Troca do Inversor (10 anos)",{"v":10000,"d":"R$ 10,000.00"}]
[]
[]
[]
[null,"Tabela considerando valores médios de produção"]
[null,"Período","Ano","Custo","Receita","Saldo","VPL","TIR"]
[null,0,null,{"$f":"-F7","v":{"v":-72000,"d":"-R$ 72,000.00"}}]
[null,1,2018,{"v":240,"d":"R$ 240.00"},{"$f":"(C7)*F8","v":{"v":8884.948,"d":"R$ 8,884.95"}},{"$f":"E19-D19","v":{"v":8644.948,"d":"R$ 8,644.95"}},{"$f":"NPV($F$5,F19)+D18","v":{"v":-63805.736492890996,"d":"R$ 63,805.74"}},{"$f":"IRR($D$36:D37)","v":{"v":-0.8799312777777778,"d":"-88%"}}]
[null,2,2019,{"v":240,"d":"R$ 240.00"},{"$f":"(C7-C7*C8)*(F8+F8*F10)","v":{"v":9282.549423,"d":"R$ 9,282.55"}},{"$f":"E20-D20","v":{"v":9042.549423,"d":"R$ 9,042.55"}},{"$f":"NPV($F$5,F20)+G19","v":{"v":-55234.59959905213,"d":"R$ 55,234.60"}},{"$f":"IRR($D$36:D38)","v":{"v":-0.5805284556115429,"d":"-58%"}}]
[null,3,2020,{"v":240,"d":"R$ 240.00"},{"$f":"(C7-C7*2*C8)*(F8+F8*2*F10)","v":{"v":9675.708372000001,"d":"R$ 9,675.71"}},{"$f":"E21-D21","v":{"v":9435.708372000001,"d":"R$ 9,435.71"}},{"$f":"NPV($F$5,F21)+G20","v":{"v":-46290.8001943128,"d":"R$ 46,290.80"}},{"$f":"IRR($D$36:D39)","v":{"v":-0.36162066172831864,"d":"-36%"}}]
[null,4,2021,{"v":240,"d":"R$ 240.00"},{"$f":"(C7-C7*3*C8)*(F8+F8*3*F10)","v":{"v":10064.424847,"d":"R$ 10,064.42"}},{"v":9824.424847,"d":"R$ 9,824.42"},{"v":-36978.54915450237,"d":"R$ 36,978.55"},{"$f":"IRR($D$36:D40)","v":{"v":-0.21859333781187584,"d":"-22%"}}]
[null,5,2022,{"v":240,"d":"R$ 240.00"},{"$f":"(C7-C7*4*C8)*(F8+F8*4*F10)","v":{"v":10448.698848,"d":"R$ 10,448.70"}},{"v":10208.698848,"d":"R$ 10,208.70"},{"v":-27302.057355450233,"d":"R$ 27,302.06"},{"$f":"IRR($D$36:D41)","v":{"v":-0.12340775968692286,"d":"-12%"}}]
[null,6,2023,{"v":240,"d":"R$ 240.00"},{"$f":"(C7-C7*5*C8)*(F8+F8*5*F10)","v":{"v":10828.530375,"d":"R$ 10,828.53"}},{"v":10588.530375,"d":"R$ 10,588.53"},{"v":-17265.535672985778,"d":"R$ 17,265.54"},{"$f":"IRR($D$36:D42)","v":{"v":-0.057828456289648944,"d":"-6%"}}]
[null,7,2024,{"v":240,"d":"R$ 240.00"},{"$f":"(C7-C7*6*C8)*(F8+F8*6*F10)","v":{"v":11203.919428,"d":"R$ 11,203.92"}},{"v":10963.919428,"d":"R$ 10,963.92"},{"v":-6873.194982938385,"d":"R$ 6,873.19"},{"$f":"IRR($D$36:D43)","v":{"v":-0.011131898224343906,"d":"-1%"}}]
[null,8,2025,{"v":240,"d":"R$ 240.00"},{"$f":"(C7-C7*7*C8)*(F8+F8*7*F10)","v":{"v":11574.866007,"d":"R$ 11,574.87"}},{"v":11334.866007,"d":"R$ 11,334.87"},{"$f":"NPV(F5,F26)+G25","v":{"v":3870.7538388625635,"d":"R$ 3,870.75"}},{"$f":"IRR($D$36:D44)","v":{"v":0.02307611867546333,"d":"2%"}}]
[null,9,2026,{"v":240,"d":"R$ 240.00"},{"$f":"(C7-C7*8*C8)*(F8+F8*8*F10)","v":{"v":11941.370111999999,"d":"R$ 11,941.37"}},{"v":11701.370111999999,"d":"R$ 11,701.37"},{"$f":"NPV(F5,F27)+G26","v":{"v":14962.099916587682,"d":"R$ 14,962.10"}},{"$f":"IRR($D$36:D45)","v":{"v":0.048740871563397015,"d":"5%"}}]
["Inversor Novo",10,2027,{"v":10000,"d":"R$ 10,000.00"},{"$f":"(C7-C7*9*C8)*(F8+F8*9*F10)","v":{"v":12303.431743000001,"d":"R$ 12,303.43"}},{"v":2303.431743000001,"d":"R$ 2,303.43"},{"$f":"NPV(F5,F28)+G27","v":{"v":17145.447540284367,"d":"R$ 17,145.45"}},{"$f":"IRR($D$36:D46)","v":{"v":0.05286118279736285,"d":"5%"}}]
[null,11,2028,{"v":240,"d":"R$ 240.00"},{"$f":"(C7-C7*10*C8)*(F8+F8*10*F10)","v":{"v":12661.0509,"d":"R$ 12,661.05"}},{"v":12421.0509,"d":"R$ 12,421.05"},{"$f":"NPV(F5,F29)+G28","v":{"v":28918.955502369674,"d":"R$ 28,918.96"}},{"$f":"IRR($D$36:D47)","v":{"v":0.07102067844523852,"d":"7%"}}]
[null,12,2029,{"v":240,"d":"R$ 240.00"},{"$f":"(C7-C7*11*C8)*(F8+F8*11*F10)","v":{"v":13014.227583,"d":"R$ 13,014.23"}},{"v":12774.227583,"d":"R$ 12,774.23"},{"$f":"NPV(F5,F30)+G29","v":{"v":41027.228092891004,"d":"R$ 41,027.23"}},{"$f":"IRR($D$36:D48)","v":{"v":0.08499165452178925,"d":"8%"}}]
[]
[]
[]
[]
[]
[{"$nulls":3},{"$f":"D18","v":{"v":-72000,"d":"-R$ 72,000.00"}}]
[{"$nulls":3},{"$f":"F19","v":{"v":8644.948,"d":"8,644.95"}}]
[{"$nulls":3},{"$f":"F20","v":{"v":9042.549423,"d":"9,042.55"}}]
[{"$nulls":3},{"v":9435.708372000001,"d":"9,435.71"}]
[{"$nulls":3},{"v":9824.424847,"d":"9,824.42"}]
[{"$nulls":3},{"v":10208.698848,"d":"10,208.70"}]
[{"$nulls":3},{"v":10588.530375,"d":"10,588.53"}]
[{"$nulls":3},{"v":10963.919428,"d":"10,963.92"}]
[{"$nulls":3},{"v":11334.866007,"d":"11,334.87"}]
[{"$nulls":3},{"v":11701.370111999999,"d":"11,701.37"}]
[{"$nulls":3},{"v":2303.431743000001,"d":"2,303.43"}]
[{"$nulls":3},{"v":12421.0509,"d":"12,421.05"}]
[{"$nulls":3},{"v":12774.227583,"d":"12,774.23"}]

{"sheet":"Rural_Agropecuária_mes_mes","index":4,"n_rows":67,"n_cols":10,"rows_kept":67,"merged":[[4,2,11,2]]}
[]
["Rural/agropecuária"]
[]
["Informações Importantes"]
["Tamanho do sistema a ser instalado (Wp)",18000,"Informações Financeiras","Taxa de disponibilidade (%)",{"v":0.025,"d":"2.50%"}]
["Expectativa de produção mensal (kwh)",null,null,"Valor do R$/Wp",{"v":4,"d":"R$ 4.00"}]
["Expectativa de produção anual de Energia (kWh)",23018,null,"Custo Total",{"$f":"E6*B5","v":{"v":72000,"d":"R$ 72,000.00"}}]
["Decaimento da Produção (%/ano)",{"v":0.005,"d":"0.50%"},null,"Custo do kWh",0.386]
["Custo de disponibilidade (kWh)",100,null,"Alíquota ICMS sobre  CD",{"v":0.3,"d":"30.00%"}]
["Consumo médio mensal",1894,null,"Aumento anual da tarifa",{"v":0.05,"d":"5.00%"}]
[{"$nulls":3},"Custos de manutenção diversos (R$/mês)",20]
[{"$nulls":3},"Troca do Inversor (10 anos)",{"v":10000,"d":"R$ 10,000.00"}]
[]
["Mês","Consumo","Produção","Disponibilidade","Excedente*","Acumulado","Receita","Saldo","VPL","TIR"]
[]
["Janeiro",2038,{"v":2378,"d":"2378.00"},{"$f":"$B$9","v":100},{"$f":"C16-B16","v":{"v":340,"d":"340.00"}},{"$f":"E16","v":{"v":340,"d":"340.00"}},{"$f":"$E$8*(B16-D16)","v":{"v":748.068,"d":"R$ 748.07"}},{"$f":"G16-$E$11","v":{"v":728.068,"d":"R$ 728.07"}},{"$f":"NPV($E$5,H16)-E7","v":{"v":-71289.68975609756,"d":"-R$ 71,289.69"}},{"$f":"IRR($D$43:D44)","v":{"v":-0.9898879444444444,"d":"-99%"}}]
["Fevereiro",1701,{"v":2098,"d":"2098.00"},{"$f":"$B$9","v":100},{"$f":"C17-B17","v":{"v":397,"d":"397.00"}},{"$f":"F16+E17","v":{"v":737,"d":"737.00"}},{"$f":"$E$8*(B17-D17)","v":{"v":617.986,"d":"R$ 617.99"}},{"$f":"G17-$E$11","v":{"v":597.986,"d":"R$ 597.99"}},{"$f":"NPV($E$5,H17)+I16","v":{"v":-70706.28878048781,"d":"-R$ 70,706.29"}},{"$f":"IRR($D$43:D45)","v":{"v":-0.9036700738284275,"d":"-90%"}}]
["Março",1926,{"v":2112,"d":"2112.00"},100,{"v":186,"d":"186.00"},{"$f":"F17+E18","v":{"v":923,"d":"923.00"}},{"$f":"$E$8*(B18-D18)","v":{"v":704.836,"d":"R$ 704.84"}},{"v":684.836,"d":"R$ 684.84"},{"$f":"NPV($E$5,H18)+I17","v":{"v":-70038.15609756098,"d":"-R$ 70,038.16"}},{"$f":"IRR($D$43:D46)","v":{"v":-0.771452274541361,"d":"-77%"}}]
["Abril",1846,{"v":1846,"d":"1846.00"},100,{"v":0,"d":"0.00"},{"$f":"F18+E19","v":{"v":923,"d":"923.00"}},{"$f":"$E$8*(B19-D19)","v":{"v":673.956,"d":"R$ 673.96"}},{"v":653.956,"d":"R$ 653.96"},{"v":-69400.15024390243,"d":"-R$ 69,400.15"},{"$f":"IRR($D$43:D47)","v":{"v":-0.6577804812556656,"d":"-66%"}}]
["Maio",2194,{"v":1537,"d":"1537.00"},100,{"v":-657,"d":"-657.00"},{"$f":"F19+E20+D20","v":{"v":366,"d":"366.00"}},{"$f":"$E$8*(B20-D20)","v":{"v":808.284,"d":"R$ 808.28"}},{"v":788.284,"d":"R$ 788.28"},{"v":-68631.09268292683,"d":"-R$ 68,631.09"},{"$f":"IRR($D$43:D48)","v":{"v":-0.5518049319633131,"d":"-55%"}}]
["Junho",1949,{"v":1319,"d":"1319.00"},100,{"v":-630,"d":"-630.00"},{"v":0,"d":"0.00"},{"$f":"E8*(C21+F20)","v":{"v":650.41,"d":"R$ 650.41"}},{"v":630.41,"d":"R$ 630.41"},{"v":-68016.05853658536,"d":"-R$ 68,016.06"},{"$f":"IRR($D$43:D49)","v":{"v":-0.4828440527554222,"d":"-48%"}}]
["Julho",2173,{"v":1498,"d":"1498.00"},100,{"v":-675,"d":"-675.00"},0,{"$f":"$E$8*C22","v":{"v":578.2280000000001,"d":"R$ 578.23"}},{"v":558.2280000000001,"d":"R$ 558.23"},{"v":-67471.44585365853,"d":"-R$ 67,471.45"},{"$f":"IRR($D$43:D50)","v":{"v":-0.4285520846528703,"d":"-43%"}}]
["Agosto",1864,{"v":1762,"d":"1762.00"},100,{"v":-102,"d":"-102.00"},0,{"$f":"$E$8*C23","v":{"v":680.1320000000001,"d":"R$ 680.13"}},{"v":660.1320000000001,"d":"R$ 660.13"},{"v":-66827.41463414633,"d":"-R$ 66,827.41"},{"$f":"IRR($D$43:D51)","v":{"v":-0.3750453438439274,"d":"-38%"}}]
["Setembro",1819,{"v":1631,"d":"1631.00"},100,{"v":-188,"d":"-188.00"},{"v":0,"d":"0.00"},{"v":629.566,"d":"R$ 629.57"},{"v":609.566,"d":"R$ 609.57"},{"v":-66232.71609756097,"d":"-R$ 66,232.72"},{"$f":"IRR($D$43:D52)","v":{"v":-0.3344797242877652,"d":"-33%"}}]
["Outubro",2300,{"v":2006,"d":"2006.00"},100,{"v":-294,"d":"-294.00"},{"v":0,"d":"0.00"},{"v":774.316,"d":"R$ 774.32"},{"v":754.316,"d":"R$ 754.32"},{"v":-65496.79804878049,"d":"-R$ 65,496.80"},{"$f":"IRR($D$43:D53)","v":{"v":-0.2940208298993262,"d":"-29%"}}]
["Novembro",1279,{"v":2339,"d":"2339.00"},100,{"$f":"C26-B26","v":{"v":1060,"d":"1060.00"}},{"$f":"E26","v":{"v":1060,"d":"1060.00"}},{"$f":"$E$8*(B26-D26)","v":{"v":455.094,"d":"R$ 455.09"}},{"v":435.094,"d":"R$ 435.09"},{"v":-65072.31609756098,"d":"-R$ 65,072.32"},{"$f":"IRR($D$43:D54)","v":{"v":-0.2734608414388954,"d":"-27%"}}]
["Dezembro",1632,{"v":2492,"d":"2492.00"},100,{"v":860,"d":"860.00"},{"$f":"F26+E27","v":{"v":1920,"d":"1920.00"}},{"$f":"$E$8*(B27-D27)","v":{"v":591.352,"d":"R$ 591.35"}},{"v":571.352,"d":"R$ 571.35"},{"v":-64514.89951219512,"d":"-R$ 64,514.90"},{"$f":"IRR($D$43:D55)","v":{"v":-0.2486311124401689,"d":"-25%"}}]
["Janeiro",{"$f":"B16","v":2038},{"v":2492,"d":"2492.00"},100,{"v":454,"d":"454.00"},{"$f":"F27+E28","v":{"v":2374,"d":"2374.00"}},{"$f":"$E$8*(B28-D28)","v":{"v":748.068,"d":"R$ 748.07"}},{"v":728.068,"d":"R$ 728.07"},{"v":-63804.589268292686,"d":"-R$ 63,804.59"},{"$f":"IRR($D$43:D56)","v":{"v":-0.2224568331913288,"d":"-22%"}}]
["Fevereiro",{"$f":"B17","v":1701},{"$f":"C17-C17*0.005","v":2087.51},100,{"v":386.5100000000002,"d":"386.51"},{"$f":"F28+E29","v":2760.51},{"$f":"$E$8*(B29-D29)","v":{"v":617.986,"d":"R$ 617.99"}},{"v":597.986,"d":"R$ 597.99"},{"v":-63221.18829268293,"d":"-R$ 63,221.19"},{"$f":"IRR($D$43:D57)","v":{"v":-0.20433088462441995,"d":"-20%"}}]
["Março",1926,2101.44,100,{"v":175.44000000000005,"d":"175.44"},{"$f":"F29+E30","v":{"v":2935.9500000000003,"d":"2935.95"}},{"$f":"$E$8*(B30-D30)","v":{"v":704.836,"d":"R$ 704.84"}},{"v":684.836,"d":"R$ 684.84"},{"v":-62553.0556097561,"d":"-R$ 62,553.06"},{"$f":"IRR($D$43:D58)","v":{"v":-0.1863212958454602,"d":"-19%"}}]
["Abril",1846,1836.77,100,{"v":-9.230000000000018,"d":"-9.23"},{"$f":"F30+E31","v":{"v":2926.7200000000003,"d":"2926.72"}},{"$f":"$E$8*(B31-D31)","v":{"v":673.956,"d":"R$ 673.96"}},{"v":653.956,"d":"R$ 653.96"},{"v":-61915.049756097564,"d":"-R$ 61,915.05"},{"$f":"IRR($D$43:D59)","v":{"v":-0.17144708618095583,"d":"-17%"}}]
["Maio",2194,{"v":1529.315,"d":"1529.32"},100,{"v":-664.685,"d":"-664.69"},{"$f":"F31+E32","v":{"v":2262.0350000000003,"d":"2262.04"}},{"$f":"$E$8*(B32-D32)","v":{"v":808.284,"d":"R$ 808.28"}},{"v":788.284,"d":"R$ 788.28"},{"v":-61145.99219512195,"d":"-R$ 61,145.99"},{"$f":"IRR($D$43:D60)","v":{"v":-0.15608319419474814,"d":"-16%"}}]
["Junho",1949,{"v":1312.405,"d":"1312.41"},100,{"v":-636.595,"d":"-636.60"},{"$f":"F32+E34","v":{"v":1579.5450000000003,"d":"1579.55"}},{"$f":"$E$8*(B33-D33)","v":{"v":713.714,"d":"R$ 713.71"}},{"v":693.714,"d":"R$ 693.71"},{"v":-60469.19804878049,"d":"-R$ 60,469.20"},{"$f":"IRR($D$43:D61)","v":{"v":-0.1444003689271709,"d":"-14%"}}]
["Julho",2173,1490.51,100,-682.49,{"$f":"F33+E34","v":{"v":897.0550000000003,"d":"897.06"}},{"$f":"$E$8*(B34-D34)","v":{"v":800.178,"d":"R$ 800.18"}},{"v":780.178,"d":"R$ 780.18"},{"v":-59708.04878048781,"d":"-R$ 59,708.05"},{"$f":"IRR($D$43:D62)","v":{"v":-0.13287379001594046,"d":"-13%"}}]
["Agosto",1864,1753.19,100,{"v":-110.80999999999995,"d":"-110.81"},{"$f":"F34+E35","v":{"v":786.2450000000003,"d":"786.25"}},{"$f":"$E$8*(B35-D35)","v":{"v":680.904,"d":"R$ 680.90"}},{"v":660.904,"d":"R$ 660.90"},{"v":-59063.2643902439,"d":"-R$ 59,063.26"},{"$f":"IRR($D$43:D63)","v":{"v":-0.12417916737071333,"d":"-12%"}}]
["Setembro",1819,{"v":1622.845,"d":"1622.85"},100,{"v":-196.15499999999997,"d":"-196.16"},{"$f":"F35+E36","v":{"v":590.0900000000004,"d":"590.09"}},{"$f":"$E$8*(B36-D36)","v":{"v":663.534,"d":"R$ 663.53"}},{"v":643.534,"d":"R$ 643.53"},{"v":-58435.42634146341,"d":"-R$ 58,435.43"},{"$f":"IRR($D$43:D64)","v":{"v":-0.11643438606346357,"d":"-12%"}}]
["Outubro",2300,1995.97,100,-304.03,{"$f":"F36+E37","v":{"v":286.0600000000004,"d":"286.06"}},{"$f":"$E$8*(B37-D37)","v":{"v":849.2,"d":"R$ 849.20"}},{"v":829.2,"d":"R$ 829.20"},{"v":-57626.450731707315,"d":"-R$ 57,626.45"},{"$f":"IRR($D$43:D65)","v":{"v":-0.10752021870967976,"d":"-11%"}}]
["Novembro",1279,{"v":2327.305,"d":"2327.31"},100,{"v":1048.3049999999998,"d":"1048.31"},{"$f":"F37+E38","v":{"v":1334.3650000000002,"d":"1334.37"}},{"$f":"$E$8*(B38-D38)","v":{"v":455.094,"d":"R$ 455.09"}},{"v":435.094,"d":"R$ 435.09"},{"v":-57201.968780487805,"d":"-R$ 57,201.97"},{"$f":"IRR($D$43:D66)","v":{"v":-0.10318982646063324,"d":"-10%"}}]
["Dezembro",1632,2479.54,100,847.54,{"$f":"F38+E39","v":{"v":2181.905,"d":"2181.91"}},{"v":591.352,"d":"R$ 591.35"},{"v":571.352,"d":"R$ 571.35"},{"v":-56644.55219512195,"d":"-R$ 56,644.55"},{"$f":"IRR($D$43:D67)","v":{"v":-0.09774188241215853,"d":"-10%"}}]
[]
[]
["*+ significa excedente de produção e - significa excedente de consumo"]
[{"$nulls":3},-72000]
[{"$nulls":3},728.068]
[{"$nulls":3},597.986]
[{"$nulls":3},684.836]
[{"$nulls":3},653.956]
[{"$nulls":3},788.284]
[{"$nulls":3},630.41]
[{"$nulls":3},558.2280000000001]
[{"$nulls":3},660.1320000000001]
[{"$nulls":3},609.566]
[{"$nulls":3},754.316]
[{"$nulls":3},435.094]
[{"$nulls":3},571.352]
[{"$nulls":3},728.068]
[{"$nulls":3},597.986]
[{"$nulls":3},684.836]
[{"$nulls":3},653.956]
[{"$nulls":3},788.284]
[{"$nulls":3},693.714]
[{"$nulls":3},780.178]
[{"$nulls":3},660.904]
[{"$nulls":3},643.534]
[{"$nulls":3},829.2]
[{"$nulls":3},435.094]
[{"$nulls":3},571.352]

{"sheet":"Redidencial_anual","index":5,"n_rows":43,"n_cols":9,"rows_kept":43,"merged":[[1,0,4,0],[1,3,5,3],[5,0,8,0],[13,2,13,6]]}
[null,"Informações Importantes"]
["Dimensionamento","Tamanho do sistema a ser instalado (Wp)",2000,"Informações Financeiras","Taxa de interesse (%)",{"v":0.1,"d":"10.0%"}]
[null,"Expectativa de produção mensal de Energia (kWh)",null,null,"Custo do kWh*",0.4159]
[null,"Expectativa de produção anual de Energia (kWh)",3000,null,"Aumento anual da tarifa",{"v":0.1,"d":"10.00%"}]
[null,"Depreciação de Produção (%/ano)",{"v":0.005,"d":"0.50%"},null,"Custo do kWh (TUSD)*",0.4121,0.28847]
["Informações da instalação","Custo de disponibilidade (kWh)",30,null,"Valor do R$/Wp",{"v":6.5,"d":"R$ 6.50"}]
[null,"Alíquota ICMS",{"v":0.3,"d":"30.00%"}]
[null,"Consumo médio mensal",320]
[null,"Custos de manutenção diversos (R$/mês)",0]
[{"$nulls":4},"*custos com impostos"]
[]
[]
[]
[null,null,"Tabela considerando valores médios de produção"]
[null,null,"Período","Período","Custo","Receita","Saldo","VPL","TIR"]
[null,null,0,null,{"$f":"-F6*C2","v":{"v":-13000,"d":"-R$ 13,000.00"}}]
[null,null,1,2018,0,{"$f":"C4*F3+C4*G5","v":{"v":2113.11,"d":"R$ 2,113.11"}},{"$f":"F17-E17","v":{"v":2113.11,"d":"R$ 2,113.11"}},{"$f":"NPV(F2,G17)+E16","v":{"v":-11078.99090909091,"d":"-R$ 11,078.99"}},{"$f":"IRR(E31:E32)","v":{"v":-0.8168638,"d":"-82%"}}]
[null,null,2,2019,0,{"$f":"(C4-C4*C5)*(F3+F3*F4)+(C4-C4*C5)*(G5+G5*F4)","v":{"v":2312.798895,"d":"R$ 2,312.80"}},{"$f":"F18-E18","v":{"v":2312.798895,"d":"R$ 2,312.80"}},{"$f":"NPV(F2,G18)+H17","v":{"v":-8976.44645909091,"d":"-R$ 8,976.45"}},{"$f":"IRR(E31:E33)","v":{"v":-0.46153564594541385,"d":"-46%"}}]
[null,null,3,2020,0,{"$f":"(C4-C4*2*C5)*(F3+F3*2*F4)+(C4-C4*2*C5)*(G5+G5*2*F4)","v":{"v":2510.37468,"d":"R$ 2,510.37"}},{"v":2510.37468,"d":"R$ 2,510.37"},{"$f":"NPV(F2,G19)+H18","v":{"v":-6694.287659090911,"d":"-R$ 6,694.29"}},{"$f":"IRR(E31:E34)","v":{"v":-0.23091371726972532,"d":"-23%"}}]
[null,null,4,2021,0,{"$f":"(C4-C4*3*C5)*(F3+F3*3*F4)+(C4-C4*3*C5)*(G5+G5*3*F4)","v":{"v":2705.8373549999997,"d":"R$ 2,705.84"}},{"v":2705.8373549999997,"d":"R$ 2,705.84"},{"$f":"NPV(F2,G20)+H19","v":{"v":-4234.435518181821,"d":"-R$ 4,234.44"}},{"$f":"IRR(E31:E35)","v":{"v":-0.09018308174211287,"d":"-9%"}}]
[null,null,5,2022,0,{"$f":"(C4-C4*4*C5)*(F3+F3*4*F4)+(C4-C4*4*C5)*(G5+G5*4*F4)","v":{"v":2899.18692,"d":"R$ 2,899.19"}},{"v":2899.18692,"d":"R$ 2,899.19"},{"$f":"NPV(F2,G21)+H20","v":{"v":-1598.8110454545485,"d":"-R$ 1,598.81"}},{"$f":"IRR(E31:E36)","v":{"v":-0.001065857561053929,"d":"-0%"}}]
[null,null,6,2023,0,{"$f":"(C4-C4*5*C5)*(F3+F3*5*F4)+(C4-C4*5*C5)*(G5+G5*5*F4)","v":{"v":3090.4233750000003,"d":"R$ 3,090.42"}},{"v":3090.4233750000003,"d":"R$ 3,090.42"},{"$f":"NPV(F6,G22)+H21","v":{"v":-1186.7545954545485,"d":"-R$ 1,186.75"}},{"$f":"IRR(E31:E37)","v":{"v":0.05787468681532726,"d":"6%"}}]
[null,null,7,2024,0,{"$f":"(C4-C4*6*C5)*(F3+F3*6*F4)+(C4-C4*6*C5)*(G5+G5*6*F4)","v":{"v":3279.5467200000003,"d":"R$ 3,279.55"}},{"v":3279.5467200000003,"d":"R$ 3,279.55"},{"$f":"NPV(F2,G23)+H22","v":{"v":1794.6515136363605,"d":"R$ 1,794.65"}},{"$f":"IRR(E31:E38)","v":{"v":0.09835493235636439,"d":"10%"}}]
[null,null,8,2025,0,{"$f":"(C4-C4*7*C5)*(F3+F3*7*F4)+(C4-C4*7*C5)*(G5+G5*7*F4)","v":{"v":3466.556955,"d":"R$ 3,466.56"}},{"v":3466.556955,"d":"R$ 3,466.56"},{"$f":"NPV(F2,G24)+H23","v":{"v":4946.066927272725,"d":"R$ 4,946.07"}},{"$f":"IRR(E31:E39)","v":{"v":0.12703337223757027,"d":"13%"}}]
[null,null,9,2026,0,{"$f":"(C4-C4*8*C5)*(F3+F3*8*F4)+(C4-C4*8*C5)*(G5+G5*8*F4)","v":{"v":3651.4540800000004,"d":"R$ 3,651.45"}},{"v":3651.4540800000004,"d":"R$ 3,651.45"},{"$f":"NPV(F2,G25)+H24","v":{"v":8265.570636363635,"d":"R$ 8,265.57"}},{"$f":"IRR(E31:E40)","v":{"v":0.1478727888321516,"d":"15%"}}]
[null,null,10,2027,{"v":2500,"d":"R$ 2,500.00"},{"$f":"(C4-C4*9*C5)*(F3+F3*9*F4)+(C4-C4*9*C5)*(G5+G5*9*F4)","v":{"v":3834.2380950000006,"d":"R$ 3,834.24"}},{"v":1334.2380950000006,"d":"R$ 1,334.24"},{"$f":"NPV(F2,G26)+H25","v":{"v":9478.514359090908,"d":"R$ 9,478.51"}},{"$f":"IRR(E31:E41)","v":{"v":0.1481121556272782,"d":"15%"}}]
[null,null,11,2028,0,{"$f":"(C4-C4*10*C5)*(F3+F3*10*F4)+(C4-C4*10*C5)*(G5+G5*10*F4)","v":{"v":4014.909,"d":"R$ 4,014.91"}},{"v":4014.909,"d":"R$ 4,014.91"},{"$f":"NPV(F2,G27)+H26","v":{"v":13128.43163181818,"d":"R$ 13,128.43"}},{"$f":"IRR(E31:E42)","v":{"v":0.16190078990571766,"d":"16%"}}]
[null,null,12,2029,0,{"$f":"(C4-C4*11*C5)*(F3+F3*11*F4)+(C4-C4*11*C5)*(G5+G5*11*F4)","v":{"v":4193.466795,"d":"R$ 4,193.47"}},{"v":4193.466795,"d":"R$ 4,193.47"},{"$f":"NPV(F2,G28)+H27","v":{"v":16940.67417272727,"d":"R$ 16,940.67"}},{"$f":"IRR(E31:E43)","v":{"v":0.17228472905976222,"d":"17%"}}]
[]
[]
[{"$nulls":4},-10000]
[{"$nulls":4},1831.362]
[{"$nulls":4},1913.3154494999999]
[{"$nulls":4},1994.353218]
[{"$nulls":4},2074.4753055]
[{"$nulls":4},2153.681712]
[{"$nulls":4},2231.9724374999996]
[{"$nulls":4},2309.347482]
[{"$nulls":4},2385.8068455]
[{"$nulls":4},2461.350528]
[{"$nulls":4},35.97852950000015]
[{"$nulls":4},2609.69085]
[{"$nulls":4},2682.4874895000003]

{"sheet":"RESIDENCIAL_MES_MES_mono","index":6,"n_rows":67,"n_cols":10,"rows_kept":67,"merged":[[1,0,4,0],[1,3,5,3],[5,0,8,0],[13,2,13,6]]}
[null,"Informações Importantes"]
["Dimensionamento","Tamanho do sistema a ser instalado (Wp)",2000,"Informações Financeiras","Taxa de disponibilidade (%)",{"v":0.1,"d":"10.0%"}]
[null,"Expectativa de produção mensal de Energia (kWh)","Abaixo",null,"Custo do kWh*",0.4159]
[null,"Expectativa de produção anual de Energia (kWh)",2630,null,"Aumento anual da tarifa",{"v":0.1,"d":"10.00%"}]
[null,"Depreciação de Produção (%/ano)",{"v":0.005,"d":"0.50%"},null,"Custo do kWh (TUSD)*",0.4121,0.28847]
["Informações da instalação","Custo de disponibilidade (kWh)",30,null,"Valor do R$/Wp",{"v":6.5,"d":"R$ 6.50"}]
[null,"Alíquota ICMS",{"v":0.3,"d":"30.00%"}]
[null,"Consumo médio mensal",320]
[null,"Custos de manutenção diversos (R$/mês)",0]
[{"$nulls":4},"*custos com impostos"]
[]
[]
[{"$nulls":4},{"$f":"-F6*C2","v":{"v":-13000,"d":"-R$ 13,000.00"}}]
[null,null,"Tabela considerando valores médios de produção"]
["Ano","Mês","Consumo","Produção","Disponibilidade","Excedente","Receita","Saldo","VPL","TIR"]
[]
[2018,"Janeiro",295,{"v":272,"d":"272.00"},{"$f":"C6","v":30},{"$f":"D17-C17","v":{"v":-23,"d":"-23.00"}},{"$f":"(D17-($C$6+F17))*($F$3+$G$5)","v":{"v":186.65804999999997,"d":"R$ 186.66"}},{"$f":"G17","v":{"v":186.65804999999997,"d":"R$ 186.66"}},{"$f":"NPV(F2,H17)+E13","v":{"v":-12830.310863636363,"d":"-R$ 12,830.31"}},{"$f":"IRR(E43:E44)","v":{"v":-0.981334195,"d":"-98%"}}]
[null,"Fevereiro",290,{"v":228,"d":"228.00"},{"$f":"C6","v":30},{"$f":"D18-C18","v":{"v":-62,"d":"-62.00"}},{"$f":"(D18*($F$3+$G$5))","v":{"v":160.59635999999998,"d":"R$ 160.60"}},{"$f":"G18","v":{"v":160.59635999999998,"d":"R$ 160.60"}},{"$f":"NPV(0.06,H18)+I17","v":{"v":-12678.804863636364,"d":"-R$ 12,678.80"}},{"$f":"IRR(E43:E45)","v":{"v":-0.8635972778374434,"d":"-86%"}}]
[null,"Março",325,{"v":244,"d":"244.00"},{"$f":"C6","v":30},{"v":-81,"d":"-81.00"},{"$f":"(D19*($F$3+$G$5))","v":{"v":171.86628,"d":"R$ 171.87"}},{"v":171.86628,"d":"R$ 171.87"},{"$f":"NPV(0.06,H19)+I18","v":{"v":-12516.666863636363,"d":"-R$ 12,516.67"}},{"$f":"IRR(E43:E46)","v":{"v":-0.7143993464491121,"d":"-71%"}}]
[null,"Abril",309,{"v":202,"d":"202.00"},{"$f":"C6","v":30},{"v":-107,"d":"-107.00"},{"$f":"(D20*($F$3+$G$5))","v":{"v":142.28274,"d":"R$ 142.28"}},{"v":142.28274,"d":"R$ 142.28"},{"v":-12382.437863636364,"d":"-R$ 12,382.44"},{"$f":"IRR(E43:E47)","v":{"v":-0.6034270050907593,"d":"-60%"}}]
[null,"Maio",317,{"v":188,"d":"188.00"},{"$f":"C6","v":30},{"v":-129,"d":"-129.00"},{"$f":"D21*(0.4159+0.28847)","v":{"v":132.42156,"d":"R$ 132.42"}},{"v":132.42156,"d":"R$ 132.42"},{"v":-12257.511863636364,"d":"-R$ 12,257.51"},{"$f":"IRR(E43:E48)","v":{"v":-0.5140521115571803,"d":"-51%"}}]
[null,"Junho",256,{"v":155,"d":"155.00"},{"$f":"C6","v":30},{"v":-101,"d":"-101.00"},{"$f":"D22*(0.4159+0.28847)","v":{"v":109.17734999999999,"d":"R$ 109.18"}},{"v":109.17734999999999,"d":"R$ 109.18"},{"$f":"NPV(0.06,H22)+I21","v":{"v":-12154.514363636365,"d":"-R$ 12,154.51"}},{"$f":"IRR(E43:E49)","v":{"v":-0.4496115703383685,"d":"-45%"}}]
[null,"Julho",312,{"v":173,"d":"173.00"},{"$f":"C6","v":30},{"v":-139,"d":"-139.00"},{"$f":"D23*(0.4159+0.28847)","v":{"v":121.85600999999998,"d":"R$ 121.86"}},{"v":121.85600999999998,"d":"R$ 121.86"},{"v":-12039.555863636364,"d":"-R$ 12,039.56"},{"$f":"IRR(E43:E50)","v":{"v":-0.3890368536477655,"d":"-39%"}}]
[null,"Agosto",281,{"v":202,"d":"202.00"},{"$f":"C6","v":30},{"v":-79,"d":"-79.00"},{"$f":"D24*(0.4159+0.28847)","v":{"v":142.28274,"d":"R$ 142.28"}},{"v":142.28274,"d":"R$ 142.28"},{"v":-11905.326863636365,"d":"-R$ 11,905.33"},{"$f":"IRR(E43:E51)","v":{"v":-0.3341971868177217,"d":"-33%"}}]
[null,"Setembro",258,{"v":209,"d":"209.00"},{"$f":"C6","v":30},{"v":-49,"d":"-49.00"},{"$f":"D25*(0.4159+0.28847)","v":{"v":147.21332999999998,"d":"R$ 147.21"}},{"v":147.21332999999998,"d":"R$ 147.21"},{"v":-11766.446363636365,"d":"-R$ 11,766.45"},{"$f":"IRR(E43:E52)","v":{"v":-0.29039028161136227,"d":"-29%"}}]
[null,"Outubro",291,{"v":250,"d":"250.00"},{"$f":"C6","v":30},{"v":-41,"d":"-41.00"},{"$f":"D26*(0.4159+0.28847)","v":{"v":176.09249999999997,"d":"R$ 176.09"}},{"v":176.09249999999997,"d":"R$ 176.09"},{"v":-11600.321363636365,"d":"-R$ 11,600.32"},{"$f":"IRR(E43:E53)","v":{"v":-0.2501493889685602,"d":"-25%"}}]
[null,"Novembro",303,{"v":251,"d":"251.00"},{"$f":"C6","v":30},{"v":-52,"d":"-52.00"},{"$f":"D27*(0.4159+0.28847)","v":{"v":176.79686999999998,"d":"R$ 176.80"}},{"v":176.79686999999998,"d":"R$ 176.80"},{"v":-11433.531863636365,"d":"-R$ 11,433.53"},{"$f":"IRR(E43:E54)","v":{"v":-0.21875713516603001,"d":"-22%"}}]
[null,"Dezembro",314,{"v":256,"d":"256.00"},{"$f":"C6","v":30},{"v":-58,"d":"-58.00"},{"$f":"D28*(0.4159+0.28847)","v":{"v":180.31871999999998,"d":"R$ 180.32"}},{"v":180.31871999999998,"d":"R$ 180.32"},{"v":-11263.419863636365,"d":"-R$ 11,263.42"},{"$f":"IRR(E43:E55)","v":{"v":-0.19290111836332124,"d":"-19%"}}]
[2019,"Janeiro",{"$f":"C17","v":295},{"$f":"D17-D17*0.005","v":270.64},{"$f":"C6","v":30},{"v":-24.360000000000014,"d":"-24.36"},{"$f":"(D29-(C6+F29))*((F3+G5)+(F3+G5)*F4)","v":{"v":205.32385499999998,"d":"R$ 205.32"}},{"v":205.32385499999998,"d":"R$ 205.32"},{"v":-11069.718113636365,"d":"-R$ 11,069.72"},{"$f":"IRR(E43:E56)","v":{"v":-0.16910325511670243,"d":"-17%"}}]
[null,"Fevereiro",{"$f":"C18","v":290},{"$f":"D18-D18*0.005","v":226.86},{"$f":"C6","v":30},{"v":-63.139999999999986,"d":"-63.14"},{"$f":"D30*(((F3+G5)+(F3+G5)*F4))","v":{"v":175.77271602,"d":"R$ 175.77"}},{"v":175.77271602,"d":"R$ 175.77"},{"v":-10903.894796636365,"d":"-R$ 10,903.89"},{"$f":"IRR(E43:E57)","v":{"v":-0.15211104572777612,"d":"-15%"}}]
[null,"Março",325,242.78,{"$f":"C6","v":30},-82.22,{"$f":"D31*(((F3+G5)+(F3+G5)*F4))","v":{"v":188.10764346,"d":"R$ 188.11"}},{"v":188.10764346,"d":"R$ 188.11"},{"v":-10726.434755636365,"d":"-R$ 10,726.43"},{"$f":"IRR(E43:E58)","v":{"v":-0.13647568220911177,"d":"-14%"}}]
[null,"Abril",309,200.99,{"$f":"C6","v":30},{"v":-108.00999999999999,"d":"-108.01"},{"$f":"D32*(((F3+G5)+(F3+G5)*F4))","v":{"v":155.72845893,"d":"R$ 155.73"}},{"v":155.72845893,"d":"R$ 155.73"},{"v":-10579.521115136364,"d":"-R$ 10,579.52"},{"$f":"IRR(E43:E59)","v":{"v":-0.1250890370852542,"d":"-13%"}}]
[null,"Maio",317,187.06,{"$f":"C6","v":30},-129.94,{"$f":"D33*(((F3+G5)+(F3+G5)*F4))","v":{"v":144.93539742,"d":"R$ 144.94"}},{"v":144.93539742,"d":"R$ 144.94"},{"v":-10442.789608136363,"d":"-R$ 10,442.79"},{"$f":"IRR(E43:E60)","v":{"v":-0.11545425260164244,"d":"-12%"}}]
[null,"Junho",256,{"v":154.225,"d":"154.23"},{"$f":"C6","v":30},{"v":-101.775,"d":"-101.78"},{"$f":"D34*(((F3+G5)+(F3+G5)*F4))","v":{"v":119.49460957499998,"d":"R$ 119.49"}},{"v":119.49460957499998,"d":"R$ 119.49"},{"v":-10330.058844386363,"d":"-R$ 10,330.06"},{"$f":"IRR(E43:E61)","v":{"v":-0.10807297588244646,"d":"-11%"}}]
[null,"Julho",312,{"v":172.135,"d":"172.14"},{"$f":"C6","v":30},{"v":-139.865,"d":"-139.87"},{"$f":"D35*(((F3+G5)+(F3+G5)*F4))","v":{"v":133.37140294499997,"d":"R$ 133.37"}},{"v":133.37140294499997,"d":"R$ 133.37"},{"v":-10204.236766136364,"d":"-R$ 10,204.24"},{"$f":"IRR(E43:E62)","v":{"v":-0.10040229045638904,"d":"-10%"}}]
[null,"Agosto",281,200.99,{"$f":"C6","v":30},{"v":-80.00999999999999,"d":"-80.01"},{"$f":"D36*(((F3+G5)+(F3+G5)*F4))","v":{"v":155.72845893,"d":"R$ 155.73"}},{"v":155.72845893,"d":"R$ 155.73"},{"v":-10057.323125636363,"d":"-R$ 10,057.32"},{"$f":"IRR(E43:E63)","v":{"v":-0.09229189360347467,"d":"-9%"}}]
[null,"Setembro",258,{"v":207.955,"d":"207.96"},{"$f":"C6","v":30},{"v":-50.04499999999999,"d":"-50.05"},{"$f":"D37*(((F3+G5)+(F3+G5)*F4))","v":{"v":161.124989685,"d":"R$ 161.12"}},{"v":161.124989685,"d":"R$ 161.12"},{"v":-9905.318418386363,"d":"-R$ 9,905.32"},{"$f":"IRR(E43:E64)","v":{"v":-0.0848044785542722,"d":"-8%"}}]
[null,"Outubro",291,248.75,{"$f":"C6","v":30},-42.25,{"$f":"D38*(((F3+G5)+(F3+G5)*F4))","v":{"v":192.73324125,"d":"R$ 192.73"}},{"v":192.73324125,"d":"R$ 192.73"},{"v":-9723.494605886362,"d":"-R$ 9,723.49"},{"$f":"IRR(E43:E65)","v":{"v":-0.07692782553470234,"d":"-8%"}}]
[null,"Novembro",303,{"v":249.745,"d":"249.75"},{"$f":"C6","v":30},{"v":-53.254999999999995,"d":"-53.26"},{"$f":"D39*(((F3+G5)+(F3+G5)*F4))","v":{"v":193.50417421499998,"d":"R$ 193.50"}},{"v":193.50417421499998,"d":"R$ 193.50"},{"v":-9540.943498136363,"d":"-R$ 9,540.94"},{"$f":"IRR(E43:E66)","v":{"v":-0.07002053475738823,"d":"-7%"}}]
[null,"Dezembro",314,254.72,{"$f":"C6","v":30},-59.28,{"$f":"D40*(((F3+G5)+(F3+G5)*F4))","v":{"v":197.35883903999996,"d":"R$ 197.36"}},{"v":197.35883903999996,"d":"R$ 197.36"},{"v":-9354.755914136364,"d":"-R$ 9,354.76"},{"$f":"IRR(E43:E67)","v":{"v":-0.0638080415234511,"d":"-6%"}}]
[]
[]
[{"$nulls":4},-10000]
[{"$nulls":4},{"$f":"G17","v":{"v":186.65804999999997,"d":"R$ 186.66"}}]
[{"$nulls":4},{"$f":"G18","v":{"v":160.59635999999998,"d":"R$ 160.60"}}]
[{"$nulls":4},{"v":171.86628,"d":"R$ 171.87"}]
[{"$nulls":4},{"v":142.28274,"d":"R$ 142.28"}]
[{"$nulls":4},{"v":132.42156,"d":"R$ 132.42"}]
[{"$nulls":4},{"v":109.17734999999999,"d":"R$ 109.18"}]
[{"$nulls":4},{"v":121.85600999999998,"d":"R$ 121.86"}]
[{"$nulls":4},{"v":142.28274,"d":"R$ 142.28"}]
[{"$nulls":4},{"v":147.21332999999998,"d":"R$ 147.21"}]
[{"$nulls":4},{"v":176.09249999999997,"d":"R$ 176.09"}]
[{"$nulls":4},{"v":176.79686999999998,"d":"R$ 176.80"}]
[{"$nulls":4},{"v":180.31871999999998,"d":"R$ 180.32"}]
[{"$nulls":4},{"v":205.32385499999998,"d":"R$ 205.32"}]
[{"$nulls":4},{"v":175.77271602,"d":"R$ 175.77"}]
[{"$nulls":4},{"v":188.10764346,"d":"R$ 188.11"}]
[{"$nulls":4},{"v":155.72845893,"d":"R$ 155.73"}]
[{"$nulls":4},{"v":144.93539742,"d":"R$ 144.94"}]
[{"$nulls":4},{"v":119.49460957499998,"d":"R$ 119.49"}]
[{"$nulls":4},{"v":133.37140294499997,"d":"R$ 133.37"}]
[{"$nulls":4},{"v":155.72845893,"d":"R$ 155.73"}]
[{"$nulls":4},{"v":161.124989685,"d":"R$ 161.12"}]
[{"$nulls":4},{"v":192.73324125,"d":"R$ 192.73"}]
[{"$nulls":4},{"v":193.50417421499998,"d":"R$ 193.50"}]
[{"$nulls":4},{"v":197.35883903999996,"d":"R$ 197.36"}]

{"sheet":"Residencial mês_mês_tri","index":7,"n_rows":67,"n_cols":10,"rows_kept":67,"merged":[[1,0,4,0],[1,3,5,3],[5,0,8,0],[13,2,13,6]]}
[null,"Informações Importantes"]
["Dimensionamento","Tamanho do sistema a ser instalado (Wp)",2000,"Informações Financeiras","Taxa de disponibilidade (%)",{"v":0.1,"d":"10.0%"}]
[null,"Expectativa de produção mensal de Energia (kWh)","Abaixo",null,"Custo do kWh*",0.4159]
[null,"Expectativa de produção anual de Energia (kWh)",2630,null,"Aumento anual da tarifa",{"v":0.1,"d":"10.00%"}]
[null,"Depreciação de Produção (%/ano)",{"v":0.005,"d":"0.50%"},null,"Custo do kWh (TUSD)*",0.4121,0.28847]
["Informações da instalação","Custo de disponibilidade (kWh)",100,null,"Valor do R$/Wp",{"v":6.5,"d":"R$ 6.50"}]
[null,"Alíquota ICMS",{"v":0.3,"d":"30.00%"}]
[null,"Consumo médio mensal",320]
[null,"Custos de manutenção diversos (R$/mês)",0]
[{"$nulls":4},"*custos com impostos"]
[]
[]
[{"$nulls":4},{"$f":"-F6*C2","v":{"v":-13000,"d":"-R$ 13,000.00"}}]
[null,null,"Tabela considerando valores médios de produção"]
["Ano","Mês","Consumo","Produção","Disponibilidade","Excedente","Receita","Saldo","VPL","TIR"]
[]
[2018,"Janeiro",295,{"v":272,"d":"272.00"},{"$f":"C6","v":100},{"$f":"D17-C17","v":{"v":-23,"d":"-23.00"}},{"$f":"(D17-(C6+F17))*(F3+G5)","v":{"v":137.35215,"d":"R$ 137.35"}},{"$f":"G17","v":{"v":137.35215,"d":"R$ 137.35"}},{"$f":"NPV(F2,H17)+E13","v":{"v":-12875.13440909091,"d":"-R$ 12,875.13"}},{"$f":"IRR(E43:E44)","v":{"v":-0.986264785,"d":"-99%"}}]
[null,"Fevereiro",290,{"v":228,"d":"228.00"},{"$f":"C6","v":100},{"$f":"D18-C18","v":{"v":-62,"d":"-62.00"}},{"$f":"(D18-(C6+F18))*(F3+G5)","v":{"v":133.8303,"d":"R$ 133.83"}},{"$f":"G18","v":{"v":133.8303,"d":"R$ 133.83"}},{"$f":"NPV(0.06,H18)+I17","v":{"v":-12748.87940909091,"d":"-R$ 12,748.88"}},{"$f":"IRR(E43:E45)","v":{"v":-0.877243678499136,"d":"-88%"}}]
[null,"Março",325,{"v":244,"d":"244.00"},{"$f":"C6","v":100},{"v":-81,"d":"-81.00"},{"$f":"(D19-(C6+F19))*(F3+G5)","v":{"v":158.48325,"d":"R$ 158.48"}},{"v":158.48325,"d":"R$ 158.48"},{"$f":"NPV(0.06,H19)+I18","v":{"v":-12599.36690909091,"d":"-R$ 12,599.37"}},{"$f":"IRR(E43:E46)","v":{"v":-0.7261193006592597,"d":"-73%"}}]
[null,"Abril",309,{"v":202,"d":"202.00"},{"$f":"C6","v":100},{"v":-107,"d":"-107.00"},{"$f":"D20*(0.4159+0.28847)","v":{"v":142.28274,"d":"R$ 142.28"}},{"v":142.28274,"d":"R$ 142.28"},{"v":-12465.13790909091,"d":"-R$ 12,465.14"},{"$f":"IRR(E43:E47)","v":{"v":-0.6093908759651769,"d":"-61%"}}]
[null,"Maio",317,{"v":188,"d":"188.00"},{"$f":"C6","v":100},{"v":-129,"d":"-129.00"},{"$f":"D21*(0.4159+0.28847)","v":{"v":132.42156,"d":"R$ 132.42"}},{"v":132.42156,"d":"R$ 132.42"},{"v":-12340.211909090911,"d":"-R$ 12,340.21"},{"$f":"IRR(E43:E48)","v":{"v":-0.5179713926414277,"d":"-52%"}}]
[null,"Junho",256,{"v":155,"d":"155.00"},{"$f":"C6","v":100},{"v":-101,"d":"-101.00"},{"$f":"D22*(0.4159+0.28847)","v":{"v":109.17734999999999,"d":"R$ 109.18"}},{"v":109.17734999999999,"d":"R$ 109.18"},{"$f":"NPV(0.06,H22)+I21","v":{"v":-12237.214409090911,"d":"-R$ 12,237.21"}},{"$f":"IRR(E43:E49)","v":{"v":-0.4525937448792464,"d":"-45%"}}]
[null,"Julho",312,{"v":173,"d":"173.00"},{"$f":"C6","v":100},{"v":-139,"d":"-139.00"},{"$f":"D23*(0.4159+0.28847)","v":{"v":121.85600999999998,"d":"R$ 121.86"}},{"v":121.85600999999998,"d":"R$ 121.86"},{"v":-12122.25590909091,"d":"-R$ 12,122.26"},{"$f":"IRR(E43:E50)","v":{"v":-0.3913789511840299,"d":"-39%"}}]
[null,"Agosto",281,{"v":202,"d":"202.00"},{"$f":"C6","v":100},{"v":-79,"d":"-79.00"},{"$f":"(D24-(C6+F24))*(F3+G5)","v":{"v":127.49096999999999,"d":"R$ 127.49"}},{"v":127.49096999999999,"d":"R$ 127.49"},{"v":-12001.981409090911,"d":"-R$ 12,001.98"},{"$f":"IRR(E43:E51)","v":{"v":-0.3403203022413074,"d":"-34%"}}]
[null,"Setembro",258,{"v":209,"d":"209.00"},{"$f":"C6","v":100},{"v":-49,"d":"-49.00"},{"$f":"(D25-(C6+F25))*(F3+G5)","v":{"v":111.29046,"d":"R$ 111.29"}},{"v":111.29046,"d":"R$ 111.29"},{"v":-11896.990409090911,"d":"-R$ 11,896.99"},{"$f":"IRR(E43:E52)","v":{"v":-0.30319244262511236,"d":"-30%"}}]
[null,"Outubro",291,{"v":250,"d":"250.00"},{"$f":"C6","v":100},{"v":-41,"d":"-41.00"},{"$f":"(D26-(C6+F26))*(F3+G5)","v":{"v":134.53466999999998,"d":"R$ 134.53"}},{"v":134.53466999999998,"d":"R$ 134.53"},{"v":-11770.070909090911,"d":"-R$ 11,770.07"},{"$f":"IRR(E43:E53)","v":{"v":-0.2661462559118358,"d":"-27%"}}]
[null,"Novembro",303,{"v":251,"d":"251.00"},{"$f":"C6","v":100},{"v":-52,"d":"-52.00"},{"$f":"(D27-(C6+F27))*(F3+G5)","v":{"v":142.98711,"d":"R$ 142.99"}},{"v":142.98711,"d":"R$ 142.99"},{"v":-11635.177409090911,"d":"-R$ 11,635.18"},{"$f":"IRR(E43:E54)","v":{"v":-0.23470553427972007,"d":"-23%"}}]
[null,"Dezembro",314,{"v":256,"d":"256.00"},{"$f":"C6","v":100},{"v":-58,"d":"-58.00"},{"$f":"(D28-(C6+F28))*(F3+G5)","v":{"v":150.73517999999999,"d":"R$ 150.74"}},{"v":150.73517999999999,"d":"R$ 150.74"},{"v":-11492.974409090912,"d":"-R$ 11,492.97"},{"$f":"IRR(E43:E55)","v":{"v":-0.20792528532746946,"d":"-21%"}}]
[2019,"Janeiro",{"$f":"C17","v":295},{"$f":"D17-D17*0.005","v":270.64},{"$f":"C6","v":100},{"v":-24.360000000000014,"d":"-24.36"},{"$f":"(D29-(C6+F29))*(0.7+0.7*F4)","v":{"v":150.14999999999998,"d":"R$ 150.15"}},{"v":150.14999999999998,"d":"R$ 150.15"},{"v":-11351.323465694686,"d":"-R$ 11,351.32"},{"$f":"IRR(E43:E56)","v":{"v":-0.1867526886490195,"d":"-19%"}}]
[null,"Fevereiro",{"$f":"C18","v":290},{"$f":"D18-D18*0.005","v":226.86},{"$f":"C6","v":100},{"v":-63.139999999999986,"d":"-63.14"},{"$f":"(D30-(C6+F30))*(0.7+0.7*F4)","v":{"v":146.29999999999998,"d":"R$ 146.30"}},{"v":146.29999999999998,"d":"R$ 146.30"},{"v":-11213.304597770159,"d":"-R$ 11,213.30"},{"$f":"IRR(E43:E57)","v":{"v":-0.169067160502669,"d":"-17%"}}]
[null,"Março",325,242.78,{"$f":"C6","v":100},-82.22,{"$f":"(D31-(C6+F31))*(0.7+0.7*F4)","v":{"v":173.24999999999997,"d":"R$ 173.25"}},{"v":173.24999999999997,"d":"R$ 173.25"},{"v":-11049.861201543743,"d":"-R$ 11,049.86"},{"$f":"IRR(E43:E58)","v":{"v":-0.15133152880251033,"d":"-15%"}}]
[null,"Abril",309,200.99,{"$f":"C6","v":100},{"v":-108.00999999999999,"d":"-108.01"},{"$f":"(D32-(C6+F32))*(0.7+0.7*F4)","v":{"v":160.92999999999998,"d":"R$ 160.93"}},{"v":160.92999999999998,"d":"R$ 160.93"},{"v":-10898.040446826762,"d":"-R$ 10,898.04"},{"$f":"IRR(E43:E59)","v":{"v":-0.1373423209518272,"d":"-14%"}}]
[null,"Maio",317,187.06,{"$f":"C6","v":100},-129.94,{"$f":"(D33-(C6+F33))*(0.7+0.7*F4)","v":{"v":167.08999999999997,"d":"R$ 167.09"}},{"v":167.08999999999997,"d":"R$ 167.09"},{"v":-10740.408371355064,"d":"-R$ 10,740.41"},{"$f":"IRR(E43:E60)","v":{"v":-0.12475544355660273,"d":"-12%"}}]
[null,"Junho",256,{"v":154.225,"d":"154.23"},{"$f":"C6","v":100},{"v":-101.775,"d":"-101.78"},{"$f":"(D34-(C6+F34))*(0.7+0.7*F4)","v":{"v":120.11999999999999,"d":"R$ 120.12"}},{"v":120.11999999999999,"d":"R$ 120.12"},{"v":-10627.087616638084,"d":"-R$ 10,627.09"},{"$f":"IRR(E43:E61)","v":{"v":-0.11659479250968852,"d":"-12%"}}]
[null,"Julho",312,{"v":172.135,"d":"172.14"},{"$f":"C6","v":100},{"v":-139.865,"d":"-139.87"},{"$f":"(D35-(C6+F35))*(0.7+0.7*F4)","v":{"v":163.23999999999998,"d":"R$ 163.24"}},{"v":163.23999999999998,"d":"R$ 163.24"},{"v":-10473.087616638084,"d":"-R$ 10,473.09"},{"$f":"IRR(E43:E62)","v":{"v":-0.10656359152738315,"d":"-11%"}}]
[null,"Agosto",281,200.99,{"$f":"C6","v":100},{"v":-80.00999999999999,"d":"-80.01"},{"$f":"(D36-(C6+F36))*(0.7+0.7*F4)","v":{"v":139.36999999999998,"d":"R$ 139.37"}},{"v":139.36999999999998,"d":"R$ 139.37"},{"v":-10341.606484562612,"d":"-R$ 10,341.61"},{"$f":"IRR(E43:E63)","v":{"v":-0.09890842145239243,"d":"-10%"}}]
[null,"Setembro",258,{"v":207.955,"d":"207.96"},{"$f":"C6","v":100},{"v":-50.04499999999999,"d":"-50.05"},{"$f":"(D37-(C6+F37))*(0.7+0.7*F4)","v":{"v":121.65999999999998,"d":"R$ 121.66"}},{"v":121.65999999999998,"d":"R$ 121.66"},{"v":-10226.83289965695,"d":"-R$ 10,226.83"},{"$f":"IRR(E43:E64)","v":{"v":-0.09274404605532172,"d":"-9%"}}]
[null,"Outubro",291,248.75,{"$f":"C6","v":100},-42.25,{"$f":"(D38-(C6+F38))*(0.7+0.7*F4)","v":{"v":147.07,"d":"R$ 147.07"}},{"v":147.07,"d":"R$ 147.07"},{"v":-10088.087616638082,"d":"-R$ 10,088.09"},{"$f":"IRR(E43:E65)","v":{"v":-0.08591139536102288,"d":"-9%"}}]
[null,"Novembro",303,{"v":249.745,"d":"249.75"},{"$f":"C6","v":100},{"v":-53.254999999999995,"d":"-53.26"},{"$f":"(D39-(C6+F39))*(0.7+0.7*F4)","v":{"v":156.30999999999997,"d":"R$ 156.31"}},{"v":156.30999999999997,"d":"R$ 156.31"},{"v":-9940.625352487139,"d":"-R$ 9,940.63"},{"$f":"IRR(E43:E66)","v":{"v":-0.07938355055805402,"d":"-8%"}}]
[null,"Dezembro",314,254.72,{"$f":"C6","v":100},-59.28,{"$f":"(D40-(C6+F40))*(0.7+0.7*F4)","v":{"v":164.77999999999997,"d":"R$ 164.78"}},{"v":164.77999999999997,"d":"R$ 164.78"},{"v":-9785.17252229846,"d":"-R$ 9,785.17"},{"$f":"IRR(E43:E67)","v":{"v":-0.07322465656761723,"d":"-7%"}}]
[]
[]
[{"$nulls":4},-10000]
[{"$nulls":4},137.35215]
[{"$nulls":4},133.8303]
[{"$nulls":4},158.48325]
[{"$nulls":4},142.28274]
[{"$nulls":4},132.42156]
[{"$nulls":4},109.17734999999999]
[{"$nulls":4},121.85600999999998]
[{"$nulls":4},127.49096999999999]
[{"$nulls":4},111.29046]
[{"$nulls":4},134.53466999999998]
[{"$nulls":4},142.98711]
[{"$nulls":4},150.73517999999999]
[{"$nulls":4},143.325]
[{"$nulls":4},139.65]
[{"$nulls":4},165.375]
[{"$nulls":4},153.615]
[{"$nulls":4},159.495]
[{"$nulls":4},114.66]
[{"$nulls":4},155.82]
[{"$nulls":4},133.035]
[{"$nulls":4},116.13]
[{"$nulls":4},140.385]
[{"$nulls":4},149.20499999999998]
[{"$nulls":4},157.29]