lutfiihsan

## Originally coded by Trenton (http://www.hackyeah.com/?p=36)
## Amended by CirKu17 ( http://short-circuit.x10.mx )


#!/usr/bin/env perl
use warnings;
use strict;

@ARGV || die "Missing filename argument $!\n";

lutfiihsan

var getWorkingDays = function(start,endCount,holidays){		
		var weekdays = [];
		var current = start;

		var i = 0; 
		while(i < endCount){
			if (!isWeekEnd(current)) {
				weekdays.push(current);
				i++;
			}

lutfiihsan

function combineData(){
 var doc = SpreadsheetApp.getActiveSpreadsheet();
 var sheets = doc.getSheets(); // get all the sheets
 var outSheet = doc.getSheetByName("combined"); // set where we want to write the results
 for (i in sheets){ // loop across all the sheets
   if (sheets[i].getSheetName().substring(0,9) == "followers"){ // if sheetname starts with 'follower' then 
     var target = sheets[i].getSheetName().substring(12); // extract users name for target column
     var data = getRowsData(sheets[i]); // get extisting data from current sheet
     for (j in data){
       data[j]["target"] = target; // create a target column with the users name