Max-Makhrov

scriptencoding utf-8

let s:calendar_list = [
      \ ['Australian Holidays', 'en.australian#holiday@group.v.calendar.google.com'],
      \ ['Austrian Holidays', 'en.austrian#holiday@group.v.calendar.google.com'],
      \ ['Brazilian Holidays', 'en.brazilian#holiday@group.v.calendar.google.com'],
      \ ['Canadian Holidays', 'en.canadian#holiday@group.v.calendar.google.com'],
      \ ['China Holidays', 'en.china#holiday@group.v.calendar.google.com'],
      \ ['Christian Holidays', 'en.christian#holiday@group.v.calendar.google.com'],
      \ ['Danish Holidays', 'en.danish#holiday@group.v.calendar.google.com'],

Max-Makhrov

$(".checklist-item").map(function(i, item) { 
	let text = $(item).find(".checklist-item-details-text").text(); 
	if( $(item).hasClass("checklist-item-state-complete") ) {
		text += " (DONE)";
    }
	return text;
}).get().join('\n')

Max-Makhrov

function make2DDataValidation() {
  // ............................... Settings ......................................
  
  // Sheet names
  var tsheet = 'Sheet1';     // The name of the work sheet with data validation
  var dsheet = 'data';       // The name of the data sheet 
  
  
  // The data validation range:
  var rownum = 1000;         // The number of the last row of validation

Max-Makhrov

// TODO
//  1. test
//  2. error handler
//  3. instructions on trigger installation

// AKfycbz7GZDZb3Yt1usqUkIu_lNOp4tW0xUKuFR9K_fIksIGuep2TeJ5RU0J


// the script assumes this structure of historic table:
//  ______________________________________

Max-Makhrov

=ArrayFormula(
 VLOOKUP( 
  CEILING(ROW(OFFSET(INDIRECT("A1"),,,COUNTA(A2:A)*COUNTA(B2:B)))/COUNTA(B2:B)) , 
  {ROW(A2:A)-row(A1),A2:A} , 2, )
 )

Max-Makhrov

function test_parse() {
  var file = SpreadsheetApp.getActive();
  var sheet = file.getSheetByName('Sheet1');          // change
  var sets = {
    rangeParse: sheet.getRange('L2:L16429'),          // change
    rangeResult: sheet.getRange("M2"),                // change
    func_parse: parseOkkoFilmToGetHorizontalPoster_   // change / create your function
  };
  parseUrls_(sets);
}

Max-Makhrov

// sample file:
// https://docs.google.com/spreadsheets/d/1_rk4xFsMrxiuXqo5-HQWfvOjBU6nGDw1rlJFU0sci9U/copy

function onOpen() {
  var ui = SpreadsheetApp.getUi();
  // Or DocumentApp or FormApp.
  ui.createMenu('🙂 Click me')
      .addItem('Image 🖼️ to Drive', 'showFormImages')
      .addToUi();
}

Max-Makhrov

// Copy sample file here:
// https://docs.google.com/spreadsheets/d/1hUOuDZcfXxaLvJbEA-SxzF4oGGU3lW3iJyS4wAV8YWA/copy

function onEdit(e) {
   dvl0_(e);
}

function dvl0_sets_() {
  return [
    {

Max-Makhrov

// combine data from all sheets in current file
function combineData() {
  // CHANGE SHEET NAME ↓ /////////////////////////////
  var sheetTo = 'combined';
  ////////////////////////////////////////////////////
  var file = SpreadsheetApp.getActiveSpreadsheet();
  var sheets = file.getSheets(); // get all the sheets
  // set where we want to write the results
  var outSheet = file.getSheetByName(sheetTo); 
  var outdata = [], sheet, sName, data = [];

Max-Makhrov

function readTimer() {
  
  // [ 1 ]. Get report 
  var tags = ['onMinute_admin', 'onMinute_worker', 'onMinute_importer', 'onMinute_sizif1', 'onMinute_sizif2'];
  var report = getTimerReps_(tags);
  console.log(report); 
  // => gives 2D Array with a report about executions.
  //    So U can write it on Spreadsheet.

  // [ 2 ]. Gat all data from logs