Skip to content

Instantly share code, notes, and snippets.

@phillipwilhelm
phillipwilhelm / exportSpreadsheet.gs
Created June 16, 2022 06:23 — forked from Spencer-Easton/exportSpreadsheet.gs
Example on how to export a Google sheet to various formats, includes most PDF options
function exportSpreadsheet() {
//All requests must include id in the path and a format parameter
//https://docs.google.com/spreadsheets/d/{SpreadsheetId}/export
//FORMATS WITH NO ADDITIONAL OPTIONS
//format=xlsx //excel
//format=ods //Open Document Spreadsheet
//format=zip //html zipped
@phillipwilhelm
phillipwilhelm / custom google apps scripts for tech sales
Created June 16, 2022 06:17 — forked from nvahalik/custom google apps scripts for tech sales
Some Google Apps Script functions for Spreadsheets which might be useful for those in Technical Sales or software development. They can be used to add up and manipulate hour ranges (e.g. SUMRANGE(["1-2",2,"2-5"]) would yield "5-9"). Those functions are SUMRANGE, SUMRANGEHIGH, SUMRANGELOW, RANGEMULT, and RANGEADD. There are also some functions wh…
/* Grab the values and make them globally available. */
var hoursPerDay = 8;
var hoursPerWeek = hoursPerDay * 5;
/**
* We calculate the number of hours in a given range.
*/
function SUMTIME(allData) {
var numHours = 0;
var numCells = allData.length;
@phillipwilhelm
phillipwilhelm / gist:e2edabad1d5c7a811e8e8547b15acb07
Created June 1, 2022 16:45 — forked from filipbec/gist:5998034874b119fab0e4
Scannr - Keys for obtaining US Driver's license data
@phillipwilhelm
phillipwilhelm / bing-ads-stats-to-google-sheet.js
Created March 23, 2022 17:36 — forked from krsoninikhil/bing-ads-stats-to-google-sheet.js
Bing Ads Script To Push Campaign Stats To Google Spreadsheet
function main() {
var payload = {"channel": "bing", "reports": []};
var date = new Date();
date.setDate(date.getDate() - 1);
var yesterday = date.toISOString().split('T')[0];
var rows = AdsApp.campaigns().forDateRange('YESTERDAY').withCondition('Impressions > 0').get();
while (rows.hasNext()) {
var campain = rows.next()
var row = campain.getStats();
@phillipwilhelm
phillipwilhelm / gist:8ace354784ee5a52094d1259bad75cad
Created March 23, 2022 01:43 — forked from digitaljhelms/gist:3761873
Git/GitHub commit standards & conventions

Committing Code

General Rules

  • Make atomic commits of changes, even across multiple files, in logical units. That is, as much as possible, each commit should be focused on one specific purpose.
  • As much as possible, make sure a commit does not contain unnecessary whitespace changes. This can be checked as follows:
$ git diff --check
@phillipwilhelm
phillipwilhelm / gist:16764934dd00676c5b53d341694fc716
Created March 23, 2022 01:41 — forked from digitaljhelms/gist:4287848
Git/GitHub branching standards & conventions

Branching

Quick Legend

Description, Instructions, Notes
Instance Branch
@phillipwilhelm
phillipwilhelm / Function.Date-Format-Conversion.php
Created January 19, 2022 04:59 — forked from mcaskill/Function.Date-Format-Conversion.php
PHP : Translate date/time format between `date()` and `strftime()`
<?php
/**
* Convert date/time format between `date()` and `strftime()`
*
* Timezone conversion is done for Unix. Windows users must exchange %z and %Z.
*
* Unsupported date formats : S, n, t, L, B, G, u, e, I, P, Z, c, r
* Unsupported strftime formats : %U, %W, %C, %g, %r, %R, %T, %X, %c, %D, %F, %x
*
@phillipwilhelm
phillipwilhelm / hexToCssFilters.ts
Created October 31, 2021 21:52 — forked from dwjohnston/hexToCssFilters.ts
TS Hex to CSS filters solution
//As referenced in this solution
import { number } from "prop-types";
//https://codepen.io/sosuke/pen/Pjoqqp
interface HSL {
h: number;
@phillipwilhelm
phillipwilhelm / split-string-into-rows.sql
Created October 26, 2021 06:56 — forked from duanehutchins/split-string-into-rows.sql
MySQL split comma-separated string into rows
-- split-string-into-rows.sql
-- Duane Hutchins
-- https://www.github.com/duanehutchins
-- Split a string into a mysql resultset of rows
-- This is designed to work with a comma-separated string (csv, SET, array)
-- To use a delimiter other than a comma:
-- Just change all the occurrences of ',' to the new delimiter
-- (four occurrences in SET_EXTRACT and one occurrence in SET_COUNT)