+ Reply to Thread
Results 1 to 2 of 2

I want to export this data with 1 km/h steps

Hybrid View

  1. #1
    Registered User
    Join Date
    06-28-2007
    Posts
    1

    I want to export this data with 1 km/h steps

    I attached one datashet.I want to export this data with 1 km/h steps.How can I do this.
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,943
    One solution to your problem is to use helper cells to perform interpolations:
    • In cell K3 enter:
      PHP Code: 
      =TEXT(ADDRESS(MATCH(J3,B:B,-1),1,4,1),"#"
      This will return the address of the time-cell (A100) whose speed (130.051) is just greater than the test speed (130 kmh)
    • In cell L3 enter:
      PHP Code: 
      =INDIRECT($K3
      The time corresponding to 130.051 kmh
    • In cell M3, enter:
      PHP Code: 
      =OFFSET(INDIRECT($K3),1,0,1,1
      The time corresponding to the speed just below the test speed.
    • In cell N3:
      PHP Code: 
      =OFFSET(INDIRECT($K3),0,1,1,1
      The speed just above the test speed
    • In cell O3:
      PHP Code: 
      =OFFSET(INDIRECT($K3),1,1,1,1
      The speed just below the test speed
    • in cell P3:
      PHP Code: 
      =ROUND(FORECAST($J3,L3:M3,N3:O3),2
      The desired interpolated time for the test speed, in this case, 3.91 sec at 130 kmh

    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

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1