Advertisement
Guest User

Untitled

a guest
Jun 22nd, 2018
56
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. function onOpen() {
  2.   var spreadsheet = SpreadsheetApp.getActive();
  3.   var menuItems = [
  4.     {name: 'Filter duplicate temperatures', functionName: 'filterTemperatures'}
  5.   ];
  6.   spreadsheet.addMenu('Filter', menuItems);
  7. }
  8.    
  9. function filterTemperatures() {
  10.   var ss = SpreadsheetApp.getActiveSpreadsheet();
  11.   var sheet = ss.getActiveSheet();
  12.   var data = sheet.getDataRange().getValues();
  13.   var filtered = {};
  14.   for (var i = 0; i < 100; i++) {
  15.     var date = data[i][2];
  16.     var minutes = date.substr(-2, 2);
  17.     if (minutes % 5 === 0) {
  18.       var date_hash = Utilities.base64Encode(date);
  19.       var temperature = data[i][1];
  20.       if (!filtered[date_hash]){
  21.         filtered[date_hash] = {temperature: temperature, date: date};
  22.       }
  23.     }
  24.   }  
  25.  
  26.   insertResult(filtered);
  27. }
  28.  
  29. function insertResult(result) {
  30.   var new_sheet = SpreadsheetApp.getActiveSpreadsheet().insertSheet();
  31.   new_sheet.setName('Result');
  32.   for (var date_hash in result) {
  33.     var row = result[date_hash];
  34.     new_sheet.appendRow([row.temperature, row.date]);
  35.   }
  36. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement