Google-sheets – How to show the ten most recent rows from another sheet’s timestamp

The following Google Apps Script (GAS) will achieve your goal automatically:

function CUMSUM(array) {  
  // set active spreadsheet
  var ss = SpreadsheetApp.getActiveSpreadsheet();

  // get active sheet
  var sh = ss.getActiveSheet();

  // get data (2D array)
  var aTest = sh.getRange(array).getValues();

  // convert 2D array to 1D array
  var aData = [].concat.apply([],aTest);

  // create new array to hold data
  var aResult = new Array(); 

  // itterate through data range  
  for(var i=0, len=aData.length; i<len; i++) {
    if(i==0) {
      aResult[i] = aData[0];
    } else {
      aResult[i] = aResult[i-1] + aData[i];
    }
  }

  // pass result to formula 
  return aResult;  
}

Add this script, via the script editor, to your spreadsheet and the function CUMSUM is available throughout the worksheet, like so: =CUMSUM("A2:A8"). Because an array is returned, use TRANSPOSE to get the right positioning.

See example file I've created: running total

As suggested in the comments, you can use the INDEX formula for that. Leaving the third parameter blank, allows for a complete row to be shown:

 INDEX(reference, [row], [column])

 INDEX(callService("geocodingServices"), 2)

I couldn't help thinking about the geocodingService you use. This is also possible from within Google Apps Script. First I had to retrieve an address from the data you provided in you question:

Code

function getReverse(lat, lng) {
  var response = Maps.newGeocoder().reverseGeocode(lat, lng);
  var result = response.results[0];
  return result.formatted_address;
}

Based on this address I was able to obtain the lat. and lng.:

function getGeo(address) {
  var response = Maps.newGeocoder().geocode(address);
  var result = response.results[0];
  return [[result.geometry.location.lat, result.geometry.location.lng]];
}

Screenshot

Example

I've created an example file for you: geocodingService