[google apps script] My spreadsheet snippets.

spread_snippets.js

/**
* Simple Check sum
* @param {Array} arguments - 1D Array ex [A0:A6]
* @return {Number} checksum
*/
function CHECK_SUM() {
  var arr = arguments[0].map(function(v){return v[0]});
  var sum = arr.reduce(function(a, b){ return a + b});
  return sum & 0xff;
}

/**
* Convert Date to Unix Time
* @param {DateTiem} arguments - DateTime object
* @return {Number} unixtime
*/
function DATE2UNIXTIME() {
  var dt = arguments[0];
  var unixtime = Math.floor(dt.getTime() / 1000);
  return unixtime;
}