I have an old-style gas meter (metric). I've been trying to work out my next bill on a weekly basis by doing the rather involved maths that the British Gas site details
Take the metric units used, multiply by 1.02264, multiply by 39 then divide by 3.6. Multiply the result by the kWh rate (10.08p) and finally divide by the answer by 100 to convert to pounds and pence. I get =(((((J20-J19)*1.02264)*39)/3.6)*P19)/100. The cell referencesJ20 and J19 are for the readings I take and the kWh rate is P19.
I then have the daily rate formula =((DATEDIF(K19,K20,"d")))*(P20/100) and this gives me the number of days since the last bill and calculates the daily charge so far. (This does work so I won't explain the cell references).
I add the two together and get my bill total on that particular day. If you're with me so far......how can I make these into one long formula which will calculate my bill on any particular day? I can set a cell to add the two totals together of course, which is probably simpler, but I spent ages yesterday trying to combine them and failed so I thought that maybe somebody here could tell me how.
Take the metric units used, multiply by 1.02264, multiply by 39 then divide by 3.6. Multiply the result by the kWh rate (10.08p) and finally divide by the answer by 100 to convert to pounds and pence. I get =(((((J20-J19)*1.02264)*39)/3.6)*P19)/100. The cell referencesJ20 and J19 are for the readings I take and the kWh rate is P19.
I then have the daily rate formula =((DATEDIF(K19,K20,"d")))*(P20/100) and this gives me the number of days since the last bill and calculates the daily charge so far. (This does work so I won't explain the cell references).
I add the two together and get my bill total on that particular day. If you're with me so far......how can I make these into one long formula which will calculate my bill on any particular day? I can set a cell to add the two totals together of course, which is probably simpler, but I spent ages yesterday trying to combine them and failed so I thought that maybe somebody here could tell me how.