Skip to content

Instantly share code, notes, and snippets.

View brucemcpherson's full-sized avatar

bruce mcpherson brucemcpherson

View GitHub Profile
@brucemcpherson
brucemcpherson / 0d8966d54a43723ccb464492879ef94961e1d35c
Last active March 13, 2024 15:47
filename:appsscript extension:.json
This file has been truncated, but you can view the full file.
initial
initial
@brucemcpherson
brucemcpherson / scraperwikiquery.gs
Created October 4, 2012 10:56
Proxy api query using google apps script to get scraperwiki data
// this will return data from a public scraperwiki table as json
// you call like this - ?shortname=xyz&limit=x&fielda=x&fieldy=y etc... where fielda refers to the name of a field in the scraperwiki table
// see ramblings.mcpher.com for more info
function doGet(e) {
// lets decode the arguments
var content = "";
if (!e.parameter) {
content = {error: "parameters not found"} ;
}
else if (!e.parameter.shortname) {
@brucemcpherson
brucemcpherson / cCell.cls
Last active December 14, 2022 20:12
cDataSet - VBA abstraction of Excel worksheet model
'gistThat@mcpher.com :do not modify this line - see ramblings.mcpher.com for details: updated on 14/11/2013 18:02:03 : from manifest:3414394 gist https://gist.github.com/brucemcpherson/3414216/raw/cCell.cls
' a data Cell - holds value at time of loading, or can be kept fresh if there might be formula updates
Option Explicit
' Version 2.04 -
'for more about this
' http://ramblings.mcpher.com/Home/excelquirks/classeslink/data-manipulation-classes
'to contact me
' http://groups.google.com/group/excel-ramblings
'reuse of code
' http://ramblings.mcpher.com/Home/excelquirks/codeuse
@brucemcpherson
brucemcpherson / restLibrary.xml
Last active September 28, 2022 23:26
Excel restlibrary manifest -- also needs the cdataset manifest. See Excel liberation. http://ramblings.mcpher.com
<gistThat info="this is a manifest for gistThat VBA code distribution - see ramblings.mcpher.com for details">
<manifest description="restlibrary associated classes and modules" contact="bruce@mcpher.com">
<gists>
<item3 gistid="3423912" version="" filename="cBrowser.cls" module="cBrowser" type="class"/>
<item1 gistid="3423885" version="" filename="restLibrary.vba" module="restLibrary" type="module"/>
<item18 gistid="b72f7a826d553fb46cfa" version="" filename="cDbab.cls" module="cDbab" type="class"/>
<item19 gistid="b72f7a826d553fb46cfa" version="" filename="cDbabResult.cls" module="cDbabResult" type="class"/>
<item2 gistid="3423885" version="" filename="cRest.cls" module="cRest" type="class"/>
@brucemcpherson
brucemcpherson / vEquivalents.gs
Created August 15, 2012 10:45
Google Apps Script equivalents for common VBA function
/** @description
* javaScript/Google Apps script functions that are equivalent to common VBA functions
* in general these provide the same functionality and have the same calling stack
* See http://ramblings.mcpher.com/Home/excelquirks/codeuse for more details
* @author <a href="mailto:bruce@mcpher.com">Bruce McPherson</a><a href="http://ramblings.mcpher.com"> ramblings.mcpher.com</a>
*/
/**
* Removes leading and trailing whitespace
* @param {string|number} v the item to be trimmed
@brucemcpherson
brucemcpherson / usefulStuff.vba
Last active January 25, 2022 15:58
Useful procedures and functions - usefulStuff.vba
'gistThat@mcpher.com :do not modify this line - see ramblings.mcpher.com for details: updated on 8/18/2014 3:54:19 PM : from manifest:7471153 gist https://gist.github.com/brucemcpherson/3414346/raw
Option Explicit
' v2.23 3414346
' Acknowledgement for the microtimer procedures used here to
' thanks to Charles Wheeler - http://www.decisionmodels.com/
' ---
#If VBA7 And Win64 Then
@brucemcpherson
brucemcpherson / cRest.cls
Last active July 29, 2021 21:59
Excel rest library
'gistThat@mcpher.com :do not modify this line - see ramblings.mcpher.com for details: updated on 15/10/2013 10:52:06 : from manifest:5055578 gist https://gist.github.com/brucemcpherson/3423885/raw/cRest.cls
' This is a generalized class for dealing with rest queries
Option Explicit
' v2.13
'for more about this
' http://ramblings.mcpher.com/Home/excelquirks/classeslink/data-manipulation-classes
'to contact me
' http://groups.google.com/group/excel-ramblings
'reuse of code
' http://ramblings.mcpher.com/Home/excelquirks/codeuse
@brucemcpherson
brucemcpherson / usefulColorStuff.vba
Last active July 6, 2021 00:13
useful color manipulation functions for VBA
'gistThat@mcpher.com :do not modify this line - see ramblings.mcpher.com for details: updated on 28/02/2013 09:55:55 : from manifest:3414394 gist https://gist.github.com/brucemcpherson/3414615/raw
' this is all about colors
Option Explicit
' v2.7 3414615
Public Type colorProps
' this is a single type to hold everything i know how to calculate about a color
rgb As Long
red As Long
green As Long