Excel code or macro to interpolate between data points
Excel code or macro to interpolate between data points
(OP)
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.





RE: Excel code or macro to interpolate between data points
RE: Excel code or macro to interpolate between data points
TTFN
FAQ731-376: Eng-Tips.com Forum Policies
RE: Excel code or macro to interpolate between data points
RE: Excel code or macro to interpolate between data points
TTFN
FAQ731-376: Eng-Tips.com Forum Policies
RE: Excel code or macro to interpolate between data points
- a value in the range in Col 1
- an array containing Col 1 + Col 2
and return a corresponding value from col 2.
A function that conducts linear interpolation as required.
RE: Excel code or macro to interpolate between data points
Dan - Owner

http://www.Hi-TecDesigns.com