Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
interpolation within subranges
For a given running event, a table of points are associated with times. For
example: Time Points ---------------- 2:16 150 2:00 200 1:48 250 1:38 300 1:29 350 .... 0:50 1200 What is the easiest approach to calculate the points for a time that falls between two times in the table? A simple staightline interpolation within a subrange is more than adequate. In other words, a performance of 2:08 falls in the middle of the range 2:16 to 2:00, so the points would be in the middle of 150 to 200, or 175 points. Best, Christopher |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
interpolation | Excel Worksheet Functions | |||
3D Interpolation | Excel Worksheet Functions | |||
Interpolation | New Users to Excel | |||
Interpolation | Excel Worksheet Functions | |||
help with interpolation and limit of interpolation | Excel Discussion (Misc queries) |