{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["Lançamentos","gráficos","sobre"],"not_rendered":{"charts":3,"images":2,"macros":1,"defined_names":3},"read":"whole","date_system":"1900"}

{"sheet":"Lançamentos","index":0,"n_rows":77,"n_cols":15,"rows_kept":77,"merged":[[1,0,1,14],[3,0,3,1],[5,0,10,0],[12,0,17,0],[19,0,31,0],[33,0,39,0],[41,0,45,0],[47,0,51,0],[53,0,58,0],[60,0,67,0],[70,0,76,0]]}
[]
["Orçamento Pessoal"]
[]
["Mês",null,"Janeiro","Fevereiro","Março","Abril","Maio","Junho","Julho","Agosto","Setembro","Outubro","Novembro","Dezembro","Total"]
[]
["RECEITAS","Salário",{"$nulls":12},{"$f":"SUM(C6:N6)","v":{"v":0,"d":"R$ 0.00"}}]
[null,"Aluguel",{"$nulls":12},{"$f":"SUM(C7:N7)","v":{"v":0,"d":"R$ 0.00"}}]
[null,"13º salário",{"$nulls":12},{"v":0,"d":"R$ 0.00"}]
[null,"Férias",{"$nulls":12},{"v":0,"d":"R$ 0.00"}]
[null,"Outros",{"$nulls":12},{"v":0,"d":"R$ 0.00"}]
[null,"Total",{"$f":"SUM(C6:C10)","v":{"v":0,"d":"R$ 0.00"}},{"$f":"SUM(D6:D10)","v":{"v":0,"d":"R$ 0.00"}},{"v":0,"d":"R$ 0.00"},{"v":0,"d":"R$ 0.00"},{"v":0,"d":"R$ 0.00"},{"v":0,"d":"R$ 0.00"},{"v":0,"d":"R$ 0.00"},{"v":0,"d":"R$ 0.00"},{"v":0,"d":"R$ 0.00"},{"v":0,"d":"R$ 0.00"},{"v":0,"d":"R$ 0.00"},{"v":0,"d":"R$ 0.00"},{"v":0,"d":"R$ 0.00"}]
[]
["INVESTIMENTOS","Ações",{"$nulls":12},{"$f":"SUM(C13:N13)","v":{"v":0,"d":"R$ 0.00"}}]
[null,"Renda Fixa",{"$nulls":12},{"$f":"SUM(C14:N14)","v":{"v":0,"d":"R$ 0.00"}}]
[null,"Previdência",{"$nulls":12},{"v":0,"d":"R$ 0.00"}]
[null,"Tít. Capitalização",{"$nulls":12},{"v":0,"d":"R$ 0.00"}]
[null,"Total",{"$f":"SUM(C13:C16)","v":{"v":0,"d":"R$ 0.00"}},{"$f":"SUM(D13:D16)","v":{"v":0,"d":"R$ 0.00"}},{"v":0,"d":"R$ 0.00"},{"v":0,"d":"R$ 0.00"},{"v":0,"d":"R$ 0.00"},{"v":0,"d":"R$ 0.00"},{"v":0,"d":"R$ 0.00"},{"v":0,"d":"R$ 0.00"},{"v":0,"d":"R$ 0.00"},{"v":0,"d":"R$ 0.00"},{"v":0,"d":"R$ 0.00"},{"v":0,"d":"R$ 0.00"},{"v":0,"d":"R$ 0.00"}]
[null,"% sobre Receita",{"$f":"IF(C17=0,\"\",C17/$C11)","v":""},{"$f":"IF(D17=0,\"\",D17/D11)","v":""},"","","","","","","","","","",""]
[]
["MORADIA","Aluguel",{"$nulls":12},{"$f":"SUM(C20:N20)","v":{"v":0,"d":"R$ 0.00"}}]
[null,"Condomínio",{"$nulls":12},{"$f":"SUM(C21:N21)","v":{"v":0,"d":"R$ 0.00"}}]
[null,"Água",null,null,{"v":50,"d":"R$ 50.00"},{"$nulls":9},{"v":50,"d":"R$ 50.00"}]
[null,"Energia Elétrica",null,null,{"v":130,"d":"R$ 130.00"},{"$nulls":9},{"v":130,"d":"R$ 130.00"}]
[null,"Gás",null,null,{"v":0,"d":"R$ 0.00"},{"$nulls":9},{"v":0,"d":"R$ 0.00"}]
[null,"Telefone",null,null,{"v":80,"d":"R$ 80.00"},{"$nulls":9},{"v":80,"d":"R$ 80.00"}]
[null,"Internet",null,null,{"v":0,"d":"R$ 0.00"},{"$nulls":9},{"v":0,"d":"R$ 0.00"}]
[null,"Tv a Cabo",null,null,{"v":80,"d":"R$ 80.00"},{"$nulls":9},{"v":80,"d":"R$ 80.00"}]
[null,"Manutenção",{"$nulls":12},{"v":0,"d":"R$ 0.00"}]
[null,"Impostos e Taxas",{"$nulls":12},{"v":0,"d":"R$ 0.00"}]
[null,"IPTU",{"$nulls":12},{"v":0,"d":"R$ 0.00"}]
[null,"Total",{"$f":"SUM(C20:C30)","v":{"v":0,"d":"R$ 0.00"}},{"$f":"SUM(D20:D30)","v":{"v":0,"d":"R$ 0.00"}},{"v":340,"d":"R$ 340.00"},{"v":0,"d":"R$ 0.00"},{"v":0,"d":"R$ 0.00"},{"v":0,"d":"R$ 0.00"},{"v":0,"d":"R$ 0.00"},{"v":0,"d":"R$ 0.00"},{"v":0,"d":"R$ 0.00"},{"v":0,"d":"R$ 0.00"},{"v":0,"d":"R$ 0.00"},{"v":0,"d":"R$ 0.00"},{"v":340,"d":"R$ 340.00"}]
[null,"% sobre Receita",{"$f":"IF(OR(C31=0,C11=0),\"Falta valor\",C31/C11)","v":"Falta valor"},"Falta valor","Falta valor","Falta valor","Falta valor","Falta valor","Falta valor","Falta valor","Falta valor",{"$f":"IF(OR(L31=0,L11=0),\"Falta valor\",L31/L11)","v":"Falta valor"},"Falta valor",{"$f":"IF(OR(N31=0,N11=0),\"Falta valor\",N31/N11)","v":"Falta valor"},"Falta valor"]
[]
["TRANSPORTE","Prestação do Carro",null,null,{"v":1136.5,"d":"R$ 1,136.50"},{"$nulls":9},{"$f":"SUM(C34:N34)","v":{"v":1136.5,"d":"R$ 1,136.50"}}]
[null,"Seguro do Carro",{"$nulls":12},{"$f":"SUM(C35:N35)","v":{"v":0,"d":"R$ 0.00"}}]
[null,"Combustível",{"$nulls":12},{"$f":"SUM(C36:N36)","v":{"v":0,"d":"R$ 0.00"}}]
[null,"Estacionamento",{"$nulls":12},{"v":0,"d":"R$ 0.00"}]
[null,"IPVA",{"$nulls":12},{"v":0,"d":"R$ 0.00"}]
[null,"Total",{"$f":"SUM(C34:C38)","v":{"v":0,"d":"R$ 0.00"}},{"$f":"SUM(D34:D38)","v":{"v":0,"d":"R$ 0.00"}},{"v":1136.5,"d":"R$ 1,136.50"},{"v":0,"d":"R$ 0.00"},{"v":0,"d":"R$ 0.00"},{"v":0,"d":"R$ 0.00"},{"v":0,"d":"R$ 0.00"},{"v":0,"d":"R$ 0.00"},{"v":0,"d":"R$ 0.00"},{"v":0,"d":"R$ 0.00"},{"v":0,"d":"R$ 0.00"},{"v":0,"d":"R$ 0.00"},{"v":1136.5,"d":"R$ 1,136.50"}]
[null,"% sobre Receita",{"$f":"IF(OR(C39=0,C11=0),\"Falta valor\",C39/C11)","v":"Falta valor"},"Falta valor","Falta valor","Falta valor","Falta valor","Falta valor","Falta valor","Falta valor","Falta valor","Falta valor","Falta valor",{"$f":"IF(OR(N39=0,N11=0),\"Falta valor\",N39/N11)","v":"Falta valor"},"Falta valor"]
[]
["SAÚDE","Saúde",{"$nulls":12},{"$f":"SUM(C42:N42)","v":{"v":0,"d":"R$ 0.00"}}]
[null,"Plano de Saúde",{"$nulls":12},{"$f":"SUM(C43:N43)","v":{"v":0,"d":"R$ 0.00"}}]
[null,"Outros",{"$nulls":12},{"v":0,"d":"R$ 0.00"}]
[null,"Total",{"$f":"SUM(C42:C44)","v":{"v":0,"d":"R$ 0.00"}},{"$f":"SUM(D42:D44)","v":{"v":0,"d":"R$ 0.00"}},{"v":0,"d":"R$ 0.00"},{"v":0,"d":"R$ 0.00"},{"v":0,"d":"R$ 0.00"},{"v":0,"d":"R$ 0.00"},{"v":0,"d":"R$ 0.00"},{"v":0,"d":"R$ 0.00"},{"v":0,"d":"R$ 0.00"},{"v":0,"d":"R$ 0.00"},{"v":0,"d":"R$ 0.00"},{"v":0,"d":"R$ 0.00"},{"v":0,"d":"R$ 0.00"}]
[null,"% sobre Receita",{"$f":"IF(OR(C45=0,C11=0),\"Falta valor\",C45/C11)","v":"Falta valor"},"Falta valor","Falta valor","Falta valor","Falta valor","Falta valor","Falta valor","Falta valor","Falta valor","Falta valor","Falta valor","Falta valor","Falta valor"]
[]
["EDUCAÇÃO","Inglês",{"$nulls":12},{"$f":"SUM(C48:N48)","v":{"v":0,"d":"R$ 0.00"}}]
[null,"Faculdade",{"$nulls":12},{"$f":"SUM(C49:N49)","v":{"v":0,"d":"R$ 0.00"}}]
[null,"Curso",{"$nulls":12},{"v":0,"d":"R$ 0.00"}]
[null,"Total",{"$f":"SUM(C48:C50)","v":{"v":0,"d":"R$ 0.00"}},{"$f":"SUM(D48:D50)","v":{"v":0,"d":"R$ 0.00"}},{"v":0,"d":"R$ 0.00"},{"v":0,"d":"R$ 0.00"},{"v":0,"d":"R$ 0.00"},{"v":0,"d":"R$ 0.00"},{"v":0,"d":"R$ 0.00"},{"v":0,"d":"R$ 0.00"},{"v":0,"d":"R$ 0.00"},{"v":0,"d":"R$ 0.00"},{"v":0,"d":"R$ 0.00"},{"v":0,"d":"R$ 0.00"},{"v":0,"d":"R$ 0.00"}]
[null,"% sobre Receita",{"$f":"IF(OR(C51=0,C11=0),\"Falta valor\",C51/C11)","v":"Falta valor"},"Falta valor","Falta valor","Falta valor","Falta valor","Falta valor","Falta valor","Falta valor","Falta valor","Falta valor","Falta valor","Falta valor","Falta valor"]
[]
["DIVERSOS","Diversão",{"$nulls":12},{"$f":"SUM(C54:N54)","v":{"v":0,"d":"R$ 0.00"}}]
[null,"Cartão Visa",{"$nulls":12},{"$f":"SUM(C55:N55)","v":{"v":0,"d":"R$ 0.00"}}]
[null,"Cartão Amex",{"$nulls":12},{"v":0,"d":"R$ 0.00"}]
[null,"Seguro de Vida",{"$nulls":12},{"$f":"SUM(C57:N57)","v":{"v":0,"d":"R$ 0.00"}}]
[null,"Total",{"$f":"SUM(C54:C57)","v":{"v":0,"d":"R$ 0.00"}},{"$f":"SUM(D54:D57)","v":{"v":0,"d":"R$ 0.00"}},{"v":0,"d":"R$ 0.00"},{"v":0,"d":"R$ 0.00"},{"v":0,"d":"R$ 0.00"},{"v":0,"d":"R$ 0.00"},{"v":0,"d":"R$ 0.00"},{"v":0,"d":"R$ 0.00"},{"v":0,"d":"R$ 0.00"},{"v":0,"d":"R$ 0.00"},{"v":0,"d":"R$ 0.00"},{"v":0,"d":"R$ 0.00"},{"v":0,"d":"R$ 0.00"}]
[null,"% sobre Receita",{"$f":"IF(OR(C58=0,C11=0),\"Falta valor\",C58/C11)","v":"Falta valor"},"Falta valor","Falta valor","Falta valor","Falta valor","Falta valor","Falta valor","Falta valor","Falta valor","Falta valor","Falta valor","Falta valor","Falta valor"]
[]
["RESUMO EM R$","Total Receitas",{"$f":"C11","v":{"v":0,"d":"R$ 0.00"}},{"v":0,"d":"R$ 0.00"},{"v":0,"d":"R$ 0.00"},{"v":0,"d":"R$ 0.00"},{"v":0,"d":"R$ 0.00"},{"v":0,"d":"R$ 0.00"},{"v":0,"d":"R$ 0.00"},{"v":0,"d":"R$ 0.00"},{"v":0,"d":"R$ 0.00"},{"v":0,"d":"R$ 0.00"},{"v":0,"d":"R$ 0.00"},{"v":0,"d":"R$ 0.00"},{"v":0,"d":"R$ 0.00"}]
[null,"Investimentos",{"$f":"C17","v":{"v":0,"d":"R$ 0.00"}},{"v":0,"d":"R$ 0.00"},{"v":0,"d":"R$ 0.00"},{"v":0,"d":"R$ 0.00"},{"v":0,"d":"R$ 0.00"},{"v":0,"d":"R$ 0.00"},{"v":0,"d":"R$ 0.00"},{"v":0,"d":"R$ 0.00"},{"v":0,"d":"R$ 0.00"},{"v":0,"d":"R$ 0.00"},{"v":0,"d":"R$ 0.00"},{"v":0,"d":"R$ 0.00"},{"v":0,"d":"R$ 0.00"}]
[null,"Moradia",{"$f":"C31","v":{"v":0,"d":"R$ 0.00"}},{"$f":"D31","v":{"v":0,"d":"R$ 0.00"}},{"v":340,"d":"R$ 340.00"},{"v":0,"d":"R$ 0.00"},{"v":0,"d":"R$ 0.00"},{"v":0,"d":"R$ 0.00"},{"v":0,"d":"R$ 0.00"},{"v":0,"d":"R$ 0.00"},{"v":0,"d":"R$ 0.00"},{"v":0,"d":"R$ 0.00"},{"v":0,"d":"R$ 0.00"},{"v":0,"d":"R$ 0.00"},{"v":340,"d":"R$ 340.00"}]
[null,"Transporte",{"$f":"C39","v":{"v":0,"d":"R$ 0.00"}},{"$f":"D39","v":{"v":0,"d":"R$ 0.00"}},{"v":1136.5,"d":"R$ 1,136.50"},{"v":0,"d":"R$ 0.00"},{"v":0,"d":"R$ 0.00"},{"v":0,"d":"R$ 0.00"},{"v":0,"d":"R$ 0.00"},{"v":0,"d":"R$ 0.00"},{"v":0,"d":"R$ 0.00"},{"v":0,"d":"R$ 0.00"},{"v":0,"d":"R$ 0.00"},{"v":0,"d":"R$ 0.00"},{"v":1136.5,"d":"R$ 1,136.50"}]
[null,"Saúde",{"$f":"C45","v":{"v":0,"d":"R$ 0.00"}},{"$f":"D45","v":{"v":0,"d":"R$ 0.00"}},{"v":0,"d":"R$ 0.00"},{"v":0,"d":"R$ 0.00"},{"v":0,"d":"R$ 0.00"},{"v":0,"d":"R$ 0.00"},{"v":0,"d":"R$ 0.00"},{"v":0,"d":"R$ 0.00"},{"v":0,"d":"R$ 0.00"},{"v":0,"d":"R$ 0.00"},{"v":0,"d":"R$ 0.00"},{"v":0,"d":"R$ 0.00"},{"v":0,"d":"R$ 0.00"}]
[null,"Educação",{"$f":"C51","v":{"v":0,"d":"R$ 0.00"}},{"$f":"D51","v":{"v":0,"d":"R$ 0.00"}},{"v":0,"d":"R$ 0.00"},{"v":0,"d":"R$ 0.00"},{"v":0,"d":"R$ 0.00"},{"v":0,"d":"R$ 0.00"},{"v":0,"d":"R$ 0.00"},{"v":0,"d":"R$ 0.00"},{"v":0,"d":"R$ 0.00"},{"v":0,"d":"R$ 0.00"},{"v":0,"d":"R$ 0.00"},{"v":0,"d":"R$ 0.00"},{"v":0,"d":"R$ 0.00"}]
[null,"Diversos",{"$f":"C58","v":{"v":0,"d":"R$ 0.00"}},{"$f":"D58","v":{"v":0,"d":"R$ 0.00"}},{"v":0,"d":"R$ 0.00"},{"v":0,"d":"R$ 0.00"},{"v":0,"d":"R$ 0.00"},{"v":0,"d":"R$ 0.00"},{"v":0,"d":"R$ 0.00"},{"v":0,"d":"R$ 0.00"},{"v":0,"d":"R$ 0.00"},{"v":0,"d":"R$ 0.00"},{"v":0,"d":"R$ 0.00"},{"v":0,"d":"R$ 0.00"},{"v":0,"d":"R$ 0.00"}]
[null,"Total Despesas",{"$f":"SUM(C62:C67)","v":{"v":0,"d":"R$ 0.00"}},{"$f":"SUM(D62:D67)","v":{"v":0,"d":"R$ 0.00"}},{"v":1476.5,"d":"R$ 1,476.50"},{"v":0,"d":"R$ 0.00"},{"v":0,"d":"R$ 0.00"},{"v":0,"d":"R$ 0.00"},{"v":0,"d":"R$ 0.00"},{"v":0,"d":"R$ 0.00"},{"v":0,"d":"R$ 0.00"},{"v":0,"d":"R$ 0.00"},{"v":0,"d":"R$ 0.00"},{"v":0,"d":"R$ 0.00"},{"v":1476.5,"d":"R$ 1,476.50"}]
[null,"Saldo",{"$f":"C61-C68","v":{"v":0,"d":"R$ 0.00"}},{"$f":"D61-D68","v":{"v":0,"d":"R$ 0.00"}},{"v":-1476.5,"d":"-R$ 1,476.50"},{"v":0,"d":"R$ 0.00"},{"v":0,"d":"R$ 0.00"},{"v":0,"d":"R$ 0.00"},{"v":0,"d":"R$ 0.00"},{"v":0,"d":"R$ 0.00"},{"v":0,"d":"R$ 0.00"},{"v":0,"d":"R$ 0.00"},{"v":0,"d":"R$ 0.00"},{"v":0,"d":"R$ 0.00"},{"v":-1476.5,"d":"-R$ 1,476.50"}]
[]
["RESUMO DESPESAS","Investimentos",{"$f":"IF(C62=0,0,C62/C68)","v":{"v":0,"d":"0%"}},{"v":0,"d":"0%"},{"v":0,"d":"0%"},{"v":0,"d":"0%"},{"v":0,"d":"0%"},{"v":0,"d":"0%"},{"v":0,"d":"0%"},{"v":0,"d":"0%"},{"v":0,"d":"0%"},{"v":0,"d":"0%"},{"v":0,"d":"0%"},{"v":0,"d":"0%"},{"v":0,"d":"0%"}]
[null,"Moradia",{"$f":"IF(C63=0,0,C63/C68)","v":{"v":0,"d":"0%"}},{"$f":"IF(D63=0,0,D63/D68)","v":{"v":0,"d":"0%"}},{"v":0.2302742973247545,"d":"23%"},{"v":0,"d":"0%"},{"v":0,"d":"0%"},{"v":0,"d":"0%"},{"v":0,"d":"0%"},{"v":0,"d":"0%"},{"v":0,"d":"0%"},{"v":0,"d":"0%"},{"v":0,"d":"0%"},{"v":0,"d":"0%"},{"v":0.2302742973247545,"d":"23%"}]
[null,"Transporte",{"$f":"IF(C64=0,0,C64/C68)","v":{"v":0,"d":"0%"}},{"$f":"IF(D64=0,0,D64/D68)","v":{"v":0,"d":"0%"}},{"v":0.7697257026752455,"d":"77%"},{"v":0,"d":"0%"},{"v":0,"d":"0%"},{"v":0,"d":"0%"},{"v":0,"d":"0%"},{"v":0,"d":"0%"},{"v":0,"d":"0%"},{"v":0,"d":"0%"},{"v":0,"d":"0%"},{"v":0,"d":"0%"},{"v":0.7697257026752455,"d":"77%"}]
[null,"Saúde",{"$f":"IF(C65=0,0,C65/C68)","v":{"v":0,"d":"0%"}},{"$f":"IF(D65=0,0,D65/D68)","v":{"v":0,"d":"0%"}},{"v":0,"d":"0%"},{"v":0,"d":"0%"},{"v":0,"d":"0%"},{"v":0,"d":"0%"},{"v":0,"d":"0%"},{"v":0,"d":"0%"},{"v":0,"d":"0%"},{"v":0,"d":"0%"},{"v":0,"d":"0%"},{"v":0,"d":"0%"},{"v":0,"d":"0%"}]
[null,"Educação",{"$f":"IF(C66=0,0,C66/C68)","v":{"v":0,"d":"0%"}},{"$f":"IF(D66=0,0,D66/D68)","v":{"v":0,"d":"0%"}},{"v":0,"d":"0%"},{"v":0,"d":"0%"},{"v":0,"d":"0%"},{"v":0,"d":"0%"},{"v":0,"d":"0%"},{"v":0,"d":"0%"},{"v":0,"d":"0%"},{"v":0,"d":"0%"},{"v":0,"d":"0%"},{"v":0,"d":"0%"},{"v":0,"d":"0%"}]
[null,"Diversos",{"$f":"IF(C67=0,0,C67/C68)","v":{"v":0,"d":"0%"}},{"$f":"IF(D67=0,0,D67/D68)","v":{"v":0,"d":"0%"}},{"v":0,"d":"0%"},{"v":0,"d":"0%"},{"v":0,"d":"0%"},{"v":0,"d":"0%"},{"v":0,"d":"0%"},{"v":0,"d":"0%"},{"v":0,"d":"0%"},{"v":0,"d":"0%"},{"v":0,"d":"0%"},{"v":0,"d":"0%"},{"v":0,"d":"0%"}]
[null,"Soma",{"$f":"SUM(C71:C76)","v":{"v":0,"d":"0%"}},{"$f":"SUM(D71:D76)","v":{"v":0,"d":"0%"}},{"v":1,"d":"100%"},{"v":0,"d":"0%"},{"v":0,"d":"0%"},{"v":0,"d":"0%"},{"v":0,"d":"0%"},{"v":0,"d":"0%"},{"v":0,"d":"0%"},{"v":0,"d":"0%"},{"v":0,"d":"0%"},{"v":0,"d":"0%"},{"v":1,"d":"100%"}]

{"sheet":"gráficos","index":1,"n_rows":2,"n_cols":2,"rows_kept":2,"merged":[[1,1,1,15]]}
[]
[null,"Resumo das Despesas"]

{"sheet":"sobre","index":2,"n_rows":16,"n_cols":1,"rows_kept":16}
[]
[]
[]
[]
["Esta planilha foi desenvolvida por Gerson G. Viergutz para o site www.minhasplanilhas.com.br"]
[]
["Encontre mais planilhas no site www.minhasplanilhas.com.br"]
[]
["Curta a página no facebook: http://facebook.com/MinhasPlanilhasBR"]
[]
["Para entrar em contato envie para o e-mail contato@minhasplanilhas.com.br"]
[]
[]
["Acesse também a loja virtual para conhecer meus produtos."]
[]
["http://www.minhasplanilhas.com.br/lojavirtual"]