// One Dimensional Array
// ---------------------
function mapMethodOneDimArr(){
  var oneDimArr1 = ["Linda", 27, "Chicago"];
  var oneDimArr2=[3, 27, 7];

  var newOneDimArr1 = oneDimArr1.map(addDashOne_);
  var newOneDimArr2 = oneDimArr2.map(multiply_);

  Logger.log(newOneDimArr1);
  Logger.log(newOneDimArr2);
}

function addDashOne_(item){
  return item + '-';
}

function multiply_(item){
  return item * 2;
}

// Two Dimensional Array
// ---------------------
function mapMethodTwoDimArr(){
  var narray = [
    ["Linda", 27, "Chicago"],
    ["Lisa", 32, "Miami"],
    ["Pete", 31, "Los Angeles"]
  ];

  var newarray = narray.map(addDashTwo_);
  var newarrayInside = narray.map(function addDashTwo(row){
    return [row[0], row[1] + 1, row[2]];
  });

  Logger.log(newarray);
  Logger.log(newarrayInside);
}

function addDashTwo_(row){
  var textOutput = row[0] + " Is From " + row[2];
  var newAge = row[1] + 1;

  return [textOutput, newAge];
}

// Map Google Sheets
// -----------------
function mapGoogleSheets(){
  var ss = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
  var data = ss.getRange(1, 1, 4, 3).getValues();

  var newData = data.map(function(row){ return [row[0] + row[1], row[2]/4]; });
  ss.getRange(1, 6, newData.length, newData[0].length).setValues(newData)

  Logger.log(data);
}