I attached one datashet.I want to export this data with 1 km/h steps.How can I do this.
I attached one datashet.I want to export this data with 1 km/h steps.How can I do this.
One solution to your problem is to use helper cells to perform interpolations:
- In cell K3 enter:
This will return the address of the time-cell (A100) whose speed (130.051) is just greater than the test speed (130 kmh)PHP Code:
=TEXT(ADDRESS(MATCH(J3,B:B,-1),1,4,1),"#")
- In cell L3 enter:
The time corresponding to 130.051 kmhPHP Code:
=INDIRECT($K3)
- In cell M3, enter:
The time corresponding to the speed just below the test speed.PHP Code:
=OFFSET(INDIRECT($K3),1,0,1,1)
- In cell N3:
The speed just above the test speedPHP Code:
=OFFSET(INDIRECT($K3),0,1,1,1)
- In cell O3:
The speed just below the test speedPHP Code:
=OFFSET(INDIRECT($K3),1,1,1,1)
- in cell P3:
The desired interpolated time for the test speed, in this case, 3.91 sec at 130 kmhPHP Code:
=ROUND(FORECAST($J3,L3:M3,N3:O3),2)
Drag the formulas down to the last test row (40 kmh).
You will have to modify the formulas for the last value, since the table does not go below 40 kmh which is required for the FORECAST Function to work properly.
Ben Van Johnson
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks