Skip to content

Instantly share code, notes, and snippets.

View shaoshing's full-sized avatar

Shaoshing Li shaoshing

View GitHub Profile
#
# MIT License - (c) 2011 John Mettraux
#
require 'rubygems'
require 'parslet' # gem install parslet
module MyJson
function CalculateFromOvertimeCalendars() {
var file = SpreadsheetApp.getActiveSpreadsheet();
var settingSheet = file.getSheetByName("Setting");
var settingRange = settingSheet.getRange("A2:C50");
var month = parseInt(settingSheet.getRange("G2").getValue());
var thisMonth = new Date();
var sheetName = thisMonth.getFullYear() + "-" + (month);