I want to calculate average payment of the house for every month, the average expense of each month. However, most of the fee is across months, they charge every 3 or 2 months. These are normal bills, e.g.: electricity bill, water bill, gas bill, etc.
I want to know the balance of each month to measure the usage of each kind of resource, so that they won't be overused, which may lead to bigger bill.
For example, I may receive a electricity bill this month, which calculate the usage of electricity in a period of time such as 18/09/2010 to 18/11/2010, and the fees is 1409.1 HKD. Of course I would not like to divide the fees into 3, ie : 1409.1 / 3 = 469.77 HKD. I would like to distribute the fee to each day in that peiod of time.
And after all, I'll get an average expense of each month.
I don't know how to do this in an Excel sheet, I don't like to open a row/column for each day.