sco-tt’s gists

sco-tt / GA-copy-to-archive.js

Last active March 30, 2021 10:40

This google apps script copies values from a specific sheet within a Google Apps spreadsheet to a master spreadsheet. All values are added a a master acrhive where the name of the source sheet is automatically added as the first column. Additionally, all copy operations are logged in a separate sheet.

	/* Menu set-up. From https://developers.google.com/apps-script/guides/menus#menus_for_add-ons_in_google_docs_or_sheets */
	function onOpen(e) {
	var menu = SpreadsheetApp.getUi().createAddonMenu(); // Or DocumentApp.
	if (e && e.authMode == ScriptApp.AuthMode.NONE) {
	// Add a normal menu item (works in all authorization modes).
	menu.addItem('Copy Values to Master', 'copySheetValues');
	} else {
	// Add a menu item based on properties (doesn't work in AuthMode.NONE).
	var properties = PropertiesService.getDocumentProperties();
	var workflowStarted = properties.getProperty('workflowStarted');

sco-tt / GA-sort-two-columns.js

Last active August 5, 2022 05:44

This Google Apps Script sorts two columns. Variables can be modified to define what two columns should be sorted, and whether they should be ascending or descending.

	/** Build a menu item
	From https://developers.google.com/apps-script/guides/menus#menus_for_add-ons_in_google_docs_or_sheets
	**/

	function onOpen(e) {
	var menu = SpreadsheetApp.getUi().createMenu('Sort');
	if (e && e.authMode == ScriptApp.AuthMode.NONE) {
	// Add a normal menu item (works in all authorization modes).
	menu.addItem('Sort Sheet', 'sort');
	} else {

sco-tt / Drupal Security Updates Only for Multiple Sites

Created March 16, 2015 16:08

	#!/bin/bash
	# Script to do security updates only in Drupal 6 and Drupal 7 using drush version 6.2.0
	# Note: drush up --security-only updates modules as well as core

	# run `which drush` to find this path
	drush='/usr/bin/drush'
	# where your drupal sites live
	site_dir='/var/www'
	echo "Scanning sites directory for drupal installations"
	cd $site_dir

sco-tt / README.md

Last active August 29, 2015 14:20 — forked from mbostock/.block

This simple line chart is constructed from a TSV file storing the closing value of AAPL stock over the last few years. The chart employs conventional margins and a number of D3 features:

d3.tsv - load and parse data
d3.time.format - parse dates
d3.time.scale - x-position encoding
d3.scale.linear - y-position encoding
d3.extent - compute domains
d3.svg.axis - display axes
d3.svg.line - display line shape

sco-tt / README.md

Last active August 29, 2015 14:20 — forked from mbostock/.block

This line chart is constructed from a TSV file storing the daily average temperatures of New York, San Francisco and Austin over the last year. The chart employs conventional margins and a number of D3 features:

d3.tsv - load and parse data
d3.time.format - parse dates
d3.time.scale - x-position encoding
d3.scale.linear - y-position encoding
d3.scale.category10, a d3.scale.ordinal - color encoding
d3.extent, d3.min and d3.max - compute domains
[d3.k

sco-tt / laravel-php-7

Last active November 8, 2019 19:11

Setting Up Scotchbox for Laravel on PHP 7


	# Props to @Mizener on https://github.com/scotch-io/scotch-box/issues/157

	sudo apt-get update
	sudo add-apt-repository ppa:ondrej/php
	sudo apt-get install php7.0
	sudo apt-get update
	sudo apt-get install php7.0-mysql libapache2-mod-php7.0
	sudo a2dismod php5
	sudo a2enmod php7.0

sco-tt / acqoponline.js

Created August 15, 2018 22:51

ACQ Op Online

	function __acqOp() {
	$(document).ready(function () {
	var acqOpVideos = {


	/*
	———————————————————————————————————————————————————————————————————————————————————————————————
	\|
	\| PROPERTIES
	\|

sco-tt / findSubArray.php

Last active March 10, 2019 01:11

	<?php

	namespace App\Http\Controllers;

	/**
	* Written in a Laravel controller for ease of development.
	* Nullable type hints (PHP 7.1 and up) in use.
	*/
	class TestController extends Controller
	{

sco-tt / canda_form.css

Created April 15, 2019 04:03

	html,body{margin:0;font-family:'Montserrat','helvetica neue',sans-serif!important}
	html,body{background-color: black;overflow-x: hidden}
	.screenreader-only,.screenreader-only a {position: absolute;opacity: 0;z-index: -10;}

	/* header */
	#div_Header,#gdbHeaderWrapper,.topSection,.bottomSection,#ProcessForm {width:100%;float:left;clear:both}
	#div_Header{margin-top:1em}
	.bottomSection ul li {width:90%;text-align:right;color:#EE2669;font-size:1.1em}
	.bottomSection ul li a {text-decoration: none;color: #fff}
	.bottomSection ul li a:hover {color: #00ade1!important;}

sco-tt / Sample malformed XML

Last active November 8, 2019 18:49

	<note>
	<to>Tove</to>
	<from>Jani</from>
	<heading>Reminder</heading>
	<body>Don't forget me this weekend!</body>

Scott Pinkelman sco-tt