mogsdad

// See http://stackoverflow.com/questions/14518410/a-google-apps-script-to-move-or-restore-google-drives-files-from-the-trash

var addonName = 'Rescue Files';
var rescueFldrName = 'Rescued Files';    // The name of the folder that rescued files should be placed into

/**
 * Adds an addon menu to the active spreadsheet.
 */
function onOpen() {
  var ui = SpreadsheetApp.getUi();

mogsdad

/**
 * Retrieve a file from the given URL, store into the named folder
 * on Google Drive.
 *
 * @param {String} fileURL   URL to source file, e.g. "http://mysite.com/files/file.val1.val22.zip"
 * @param {String} folder    Name of target folder on Google Drive
 *
 * @returns {Object}         Response of operation, e.g.
 *                           {rc:200,fileName:"test.zip",fileSize:92994392}
 */

mogsdad

/**
 * Return a string with the A1 notation for the given range, with
 * the sheet reference removed. To use in spreadsheet functions,
 * enclose with INDIRECT().
 *
 * Example: 
 *   =index(INDIRECT(localizeNamedRange(NamedRange1)),12,4)
 *
 * @param {string} rangeName  The name of an existing range in the
 *                        active spreadsheet. It does not matter which

mogsdad

/**
 * Delete form response rows. If no input parameter is provided, prompt user
 * for the number of form response rows to remove. To remove all rows, input
 * -1.
 *
 * Assumes that the form responses are in the active sheet, that there is one
 * row of 'headers' followed by responses (starting in row 2).
 *
 * @param {number} thisMany (Optional) The number of rows to remove. If not
 *                          specified, user will be prompted for input.

mogsdad

// EventManagerV3 glued together by mhawksey http://www.google.com/profiles/m.hawksey
// Related blog post http://mashe.hawksey.info/eventmanagerv3/ 

// With some code (settings, importIntoCalendar, sendEmails) from  
// Romain Vialard's http://www.google.com/profiles/romain.vialard 
// Manage your events: Calendar Importer and Registration Form
// https://spreadsheets.google.com/ccc?key=tCHuQkkKh_r69bQGt4yJmNQ

var ss = SpreadsheetApp.getActiveSpreadsheet();
var BOOKING_ACTION_COL = 10;

mogsdad

/**
 * Run experiments to measure speed of various approaches to saving data in
 * Google App Script (GAS).
 */
function testSpeed() {
  var numObj = 400;
  var numAttr = 10;
  var doFlush = false;  // Set true to activate calls to SpreadsheetApp.flush()

  var arr = buildArray(numObj,numAttr);

mogsdad

function testRanges() {
  var range1 = getContiguousRange("C3").getA1Notation();
  var range2 = getContiguousRange("B8").getA1Notation();
  debugger;
}


/**
 * Return the contiguous Range that contains the given cell.
 *

mogsdad

/**
 * Retrieves a given user label by name and forwards unread messages
 * associated with that that label to a member of the Hunt Group.
 */
function huntGroupForward() {
  // get the label for given name
  var labelName = "elephant"
  var label = GmailApp.getUserLabelByName(labelName);
  if (label == null) throw new Error("No messages for label "+labelName);
  // get count of all threads in the given label

mogsdad

/**
 * Move all values from source range to destination range. Upon
 * completion, source range will be cleared. Source values will
 * be moved into a destination range starting at the "top left"
 * of the destination range, using the dimensions of the source
 * range. This is a blind copy, with no overwrite test.
 *
 * @param {Range} source Range Object to take values from.
 * @param {Range} destination Range Object to receive values.
 *

mogsdad

/**
 * Return string representation of MD5 digest of the given message.
 * 
 * @param {String} message Message to be encoded.
 * 
 * @return {String} 16-byte digest value
 */
function signMd5(message){
  return digest(Utilities.DigestAlgorithm.MD5, message);
}