0
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.
I suggest you start by dividing the electricity bill amount by 2 if it's from mid september to mid november. – Daniel Beck – 2011-05-22T17:43:36.777
Also, I got the impression from the question title this was about mortgage payments. Since your question applies to mobile phone bills, car insurance payments and online game subscriptions as well, consider editing it to broaden its scope; this might attract more attention. – Daniel Beck – 2011-05-22T17:47:02.093
NO, just normal bills, ie: electricity bill, water bill, gas bill, etc. – lamwaiman1988 – 2011-05-22T18:32:50.050
I had the impression you were just looking for any solution that could handle recurring, fixed-interval bills with varying amounts payable as input. Didn't realize that the types of bills (electricity, water, and gas) had to be hard-coded in the software. My apologies. – Daniel Beck – 2011-05-22T18:37:09.467
Arr, nothing about business/company, just personal need, 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. – lamwaiman1988 – 2011-05-22T18:50:08.000