// 校正数のカウント function UpdateProofreadProgress(){ var backup_time = ['-03-','-04-','-05-']; var sheetName = [sheetName_1, sheetName_2, sheetName_3]; var file_workspace = [SpreadsheetApp.openByUrl(url_1),SpreadsheetApp.openByUrl(url_2),SpreadsheetApp.openByUrl(url_3)]; var today = new Date(); var yesterday = new Date(today.getFullYear(), today.getMonth(), today.getDate() - 1); var offset = 0; var offset_today = new Date(today.getFullYear(), today.getMonth(), today.getDate() - offset); var offset_yesterday = new Date(today.getFullYear(), today.getMonth(), today.getDate() - offset -1); var folder = DriveApp.getFolderById('0B1yUXrJn16wCZ21NeU42OGJ6ZDQ'); // バックアップファイルが入っているフォルダ var count_proofread = 0; for(var i=0; i<3; i++){ var file_name_new = Utilities.formatDate(offset_today, 'JST', 'yyyy-MM-dd') + backup_time + file_workspace.getName();
var file_name_old = Utilities.formatDate(offset_yesterday, 'JST', 'yyyy-MM-dd') + backup_time + file_workspace.getName();

//Logger.log(file_name_old);
//Logger.log(file_name_new);

var file_old = folder.getFilesByName(file_name_old).next();
var file_new = folder.getFilesByName(file_name_new).next();

var spreadsheet_old = SpreadsheetApp.openById(file_old.getId());
var spreadsheet_new = SpreadsheetApp.openById(file_new.getId());

var sheet_old = spreadsheet_old.getSheetByName(sheetName);
var sheet_new = spreadsheet_new.getSheetByName(sheetName);

var text_old = sheet_old.getRange(2,8,sheet_old.getLastRow()).getValues();
var text_new = sheet_new.getRange(2,8,sheet_new.getLastRow()).getValues();

var progress_old = sheet_old.getRange(2,9,sheet_old.getLastRow()).getValues();
var progress_new = sheet_new.getRange(2,9,sheet_new.getLastRow()).getValues();

if(text_old.length > text_new.length){
var rowMax = text_new.length;
}else{
var rowMax = text_old.length;
}

for (var row = 0; row < rowMax; row++) {
if( text_new[row].toString() != text_old[row].toString() && progress_new[row].toString() != '✕' && progress_old[row].toString() != '✕' ){
count_proofread++;
// Logger.log(text_old[row]);
// Logger.log(text_new[row]);
}
}
//Logger.log(count_proofread);

}
var spreadsheet = SpreadsheetApp.openByUrl(url_0);
var sheet_output = spreadsheet.getSheetByName(sheetName_output);
var start_date = new Date(sheet_output.getRange(cell_startDate).getValue());

// 経過日数を計算、参考：http://codaholic.org/?p=65
var diff = Math.floor((offset_today - start_date)/1000/60/60/24);

// 出力
sheet_output.getRange(diff+4-1, output_column+5).setValue(count_proofread);
}[/code]