Download link:
http://www.mediafire.com/file/da7x7sr9vr7vleh/Dates.xls
You specify how much you want to spend per month and it gives you a daily allowance. I've explained the functions of each column below:
Date: The date of the appointment
Name: The name of the provider
Cost: The cost of the date
Target monthly allowance: The amount of money you intend to spend this month on dates. It should remain the same for every date entry within a single month, but may vary from month to month. By default, it will remain the same until changed manually
Total cost this month: How much money you've spent on dates so far this month
Previous month's balance: The balance that was carried over from the previous month. Regardless of whether the balance is positive or negative, it will add to or subtract from your allowance for the following month
Accumulated allowance: The amount of money you have to spend on your next date. The further you let this number get below zero, the longer you'll have to wait in order to save up the funds to get back within your budget. The current amount you have to spend is displayed in this column directly below the last date entry. The formula is:
(DailyAllowance * DayOfTheMonth) - TotalCostThisMonth + PreviousMonthsBalance
DailyAllowance: Target monthly allowance / 30 (ex. a monthly allowance of $600 will give you a DailyAllowance of $20)
DayOfTheMonth: The day of the month specified by the Date field. If no date is specified, the current date is used
Multiplying DailyAllowance by DayOfTheMonth will give you the allowance you've accrued so far that month. Subtracting TotalCostThisMonth from and adding PreviousMonthsBalance to this total will give you your Accumulated allowance
If you don't add any entries for one or more months, the budgets for those months are skipped. You may add them to the Target monthly allowance for the following month to avoid this.
Days since last date: This isn't used by any of the formulas in this document. It's just here in case you want to use this number to help you figure out when you should plan your next date
Please let me know if you guys have any ideas on how this could be improved or if you have a solution that might work better.