This file has been truncated, but you can view the full file.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
initial |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
initial |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
// 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) { |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
'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 |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<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"/> |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
/** @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 |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
'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 |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
'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 |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
'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 |
NewerOlder