|
Excel code or macro to interpolate between data points
|
|
Source：Internet Author：Unknow Pubdate：2010-03-01
|
|
stadamack (Mechanical)
3 Nov 09 15:35
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.
stadamack (Mechanical)
3 Nov 09 16:22
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. - http://files.engineering.com/getfile.aspx?folder=1ea07915-637d-4f60-a1fd-90
字串2
IRstuff (Aerospace)
3 Nov 09 16:40
Wny not use Excel's regression tools? TTFN
FAQ731-376: Eng-Tips.com Forum Policies
stadamack (Mechanical)
3 Nov 09 17:15
maybe there is a function in the regression tools to do this? have examined the trend function but this fits a line using least squares rather than linear interpolation.
IRstuff (Aerospace)
3 Nov 09 17:45
linear interpolation only requires two points, so what's the problem? TTFN
FAQ731-376: Eng-Tips.com Forum Policies
stadamack (Mechanical)
4 Nov 09 13:53
linear interpolation is no problem. am trying to set up a spreadsheet to automate the process. data is input in 2 columns. Col 1 date. Col 2 meter readings. Is there a function that can take the following inputs: 字串4
- 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.
macgyvers2000 (Electrical)
4 Nov 09 14:07
This question is more appropriate to Tek-tips.com and their Excel forums. Dan - Owner
http://www.Hi-TecDesigns.com
（Click：）
|
| Previous：USB to PS/2 converter with splitter function Next：Can anyone suggest a 3.7v high capacity battery? |
|
[ Add TO Favorites]
[TOP] [PRINT]
[CLOCE WINDOWS] |
|
|
|
