View Single Post
 
Old 02-13-2020, 12:56 AM
ArviLaanemets ArviLaanemets is offline Windows 8 Office 2016
Expert
 
Join Date: May 2017
Posts: 652
ArviLaanemets is a glorious beacon of lightArviLaanemets is a glorious beacon of lightArviLaanemets is a glorious beacon of lightArviLaanemets is a glorious beacon of lightArviLaanemets is a glorious beacon of lightArviLaanemets is a glorious beacon of light
Default

Added is a simple example I gobbled together approximately in 20 minutes. I hope it gives you some ideas.


You have 2 tables - one on sheet Envelopes, another on sheet Budget.


On sheet Envelopes in column Envelopes, you define all envelopes you want to use. You can always add new ones, but don't delete old ones when there are any entries for this envelope in table on Budget sheet. In column CurrSaldo is calculated current saldo of entries from budget table for given envelope (All cells with formulas are colored yellow). Column Calculation is used to divide incoming sums between envelopes.
At top of sheet are fields for current total saldo (sum of saldos in column CurrSaldo), for balance between incoming sum (CalcTotal) and sum of fields in Calculation column, and for incoming sum. Calculation values and balance are displayed red when balance is negative, and green when balance equals 0.


Into table on sheet Budget, you enter all incoming and outgoing sums per envelope (you can use Calculation feature on Envelopes sheet to distribute entry, and then copy-paste envelopes and sums into budget table). In TypeCoef column a sum sign value (1 or -1) is calculated based on value in EntryType column. You can hide column TypeCoef.
Attached Files
File Type: xlsx BudgetCalculator.xlsx (15.4 KB, 3 views)

Last edited by ArviLaanemets; 02-13-2020 at 05:52 AM.
Reply With Quote