stadamack
Mechanical
- Nov 3, 2009
- 12
Electricity meter readings are recorded every 7 days and recorded in an excel spreadsheet. Date is recorded in Col 1. Corresponding meter reading is recorded in Col 2. From the data entered I would like to automatically calculate the consumption for each month. The code / macro should interpolate to determine meter readings at the beginning and end of each month - these can then be subtracted to determine consumption during any month.