desktop liberation
Follow
Find
16.6K views | +2 today
 
Scooped by brucemcpherson
onto desktop liberation
Scoop.it!

Excel Liberation.: Playing around with awarding badges on sites

Excel Liberation.: Playing around with awarding badges on sites | desktop liberation | Scoop.it
brucemcpherson's insight:

I've been looking at the Mozilla Open Badges initiative lately, as a way to improve engagement with a particular site or Blog. My idea is that you could assign a set of earnable badges to a particular page of a site, perhaps different ones on different pages, and present the opportunity to earn one by answering a few questions - using the Open badges infrastructure to store the badges earned. Here's the beginnings of a page specific badge earning widget with quiz data served up by google apps script.

more...
Martin Hawksey's curator insight, December 21, 2012 8:51 AM

Wonderful example of Google Apps Script ScriptDb Service

From around the web

desktop liberation
Your new post is loading...
Your new post is loading...
Rescooped by brucemcpherson from FrankensTeam's Excel Collection
Scoop.it!

Meeting in Milano, trip to the Alps and an Excel chart - E90E50fx

Meeting in Milano, trip to the Alps and an Excel chart - E90E50fx | desktop liberation | Scoop.it
“ FrankensTeam meeting in Milano, Alps Excel chart”
Via Kris
brucemcpherson's insight:
Very impressive work from the Frankens team
more...
No comment yet.
Scooped by brucemcpherson
Scoop.it!

Desktop Liberation: GitHub and VBA integration

brucemcpherson's insight:

Here's how to get your vba projects to and from github.

more...
No comment yet.
Rescooped by brucemcpherson from Google Apps Script
Scoop.it!

Some best practise notes on DbAbstraction usage

Some best practise notes on DbAbstraction usage | desktop liberation | Scoop.it

"Since we have a lot of operations going through the database abstraction libraries nowadays (over 3 million since I released this in summer last year),  I thought I'd give a few hints."


Via Martin Hawksey
more...
No comment yet.
Scooped by brucemcpherson
Scoop.it!

Desktop Liberation: A year in apps script and my bucket list

brucemcpherson's insight:

For my first post of 2015 in this community, here's a look back at what came and went in 2014. How do you think Apps Script should develop in 2015 and beyond?

more...
No comment yet.
Rescooped by brucemcpherson from Google Apps Script
Scoop.it!

Big Data, Small Insights | LinkedIn

Big Data, Small Insights | LinkedIn | desktop liberation | Scoop.it

"The integration to Virtual PBX is a custom gateway designed to harvest PBX call data logs and filter them based on calls associated with reservations extensions. I used Google Apps Script to automate the update of call data in near-real-time despite the fact that a formal API is not available from this PBX provider.

 

The data is stored into a 13 column spreadsheet capable of handling approximately 25,000 calls per month with a ceiling of about two years worth of data. All processes and integration with Virtual PBX is handled by Google Apps Scripts (GAS) and available as an installable service"


Via Martin Hawksey
brucemcpherson's insight:

great mash up of GAS & Analytics and other stuff.

more...
Martin Hawksey's curator insight, November 27, 2014 4:48 AM
Bill French, Founder and Editor at iPadCTO outlines how they use Google Apps Script for custom data collection and reporting
Scooped by brucemcpherson
Scoop.it!

Do something useful in Apps Script 5. Get your analytics pageviews to…

Here's how to build on previous tutorials to get your Google Analytics PageView data into a Spreadsheet.
more...
No comment yet.
Scooped by brucemcpherson
Scoop.it!

Do something in 5 with gas 3-simple invoicing app

quick 5 minute tutorial. join multiple databases and create personalized email invoices with google apps script
more...
No comment yet.
Scooped by brucemcpherson
Scoop.it!

Do something in 5 minutes with gas 1-use spreadsheet as database

Here's one in a series of tutorials where you can do something useful from scratch in 5 minutes using Google Apps Script. This example shows how to use a Googl…
more...
No comment yet.
Scooped by brucemcpherson
Scoop.it!

Back end performance linearity - Google Apps Script

Back end performance linearity - Google Apps Script | desktop liberation | Scoop.it

I have a number of backends database all abstracted so they use the same code. Google Apps Script code. Here's the top 5 measured for performance linearity

more...
No comment yet.
Rescooped by brucemcpherson from Google Apps Script
Scoop.it!

Parallel processing in Apps Script - Desktop Liberation

Parallel processing in Apps Script - Desktop Liberation | desktop liberation | Scoop.it

" There's no getting away from the fact  that Apps Script is slower than the equivalent client based JavaScript processing. It is fundamentally synchronous in implementation, and also has limits on processing time and a host of other quotas. For a cloud based, free service that's about extending Drive capabilities rather than being scalable in the manner of Google App Engine, I suppose it's normal. But let's see if we can at least subvert at least these two things: * get over the 6 minute maximum execution time for Apps Script *run things in parallel "


Via Martin Hawksey
more...
Martin Hawksey's curator insight, June 30, 2014 7:54 PM
More magic from Bruce Mcpherson
Scooped by brucemcpherson
Scoop.it!

EzyOauth2 - taking some pain out of Apps Script API authentication

EzyOauth2 - taking some pain out of Apps Script API authentication | desktop liberation | Scoop.it
Liberate Excel data from the desktop
brucemcpherson's insight:
If you are writing Apps Script webapps and accessing some of the Google JSON APIs services, you're going to need to deal with oAuth2. This library using the statetokenbuilder should help get it right first time.  
more...
No comment yet.
Scooped by brucemcpherson
Scoop.it!

C3.js | D3-based reusable chart library

D3 based reusable chart library (C3.js is a D3-based reusable chart library.
brucemcpherson's insight:

Another d3.js library . looks good.

more...
No comment yet.
Scooped by brucemcpherson
Scoop.it!

Chaining JavaScript - Google Apps Script

Chaining JavaScript - Google Apps Script | desktop liberation | Scoop.it

Chaining examples for GAS

brucemcpherson's insight:

This example shows how to get data from a Fusion table, summarize and sort it, and write it out to a spreadsheet in 'one line' of code. 

more...
No comment yet.
Scooped by brucemcpherson
Scoop.it!

ChromeTrace library for apps script

A library to use chrome tracing tool for profiling apps script

brucemcpherson's insight:

This is is super useful if you use apps script and would like to do profiling and logging using chrome tools.

more...
No comment yet.
Rescooped by brucemcpherson from Google Apps Script
Scoop.it!

Getting your apps scripts to Github - Desktop Liberation

Getting your apps scripts to Github - Desktop Liberation | desktop liberation | Scoop.it

"You can get all your apps scripts, libraries and dependencies up to git hub and documented automatically with this apps script project. No need for local files as everything happens on drive, and no need for local git software or any particular OS as it all happens with the github API." - Bruce MacPherson


Via Martin Hawksey
more...
No comment yet.
Scooped by brucemcpherson
Scoop.it!

Embedding feeds in google sites - Desktop Liberation

Embedding feeds in google sites - Desktop Liberation | desktop liberation | Scoop.it
Liberate Excel data from the desktop
brucemcpherson's insight:

Here's a Google Sites Gadget for displaying RSS feeds. It's  bit different than some of the others since it's dynamic height adjusting itself to the number of feed items you've selected

more...
No comment yet.
Scooped by brucemcpherson
Scoop.it!

Do something in 5 with gas 7-email log

number 7 in do something useful with Google Apps script, covers how to search gmail for threads matching a topic and log recipients to a spreadsheet.
more...
No comment yet.
Rescooped by brucemcpherson from Google Apps Script
Scoop.it!

TwtrService Example: EasyTweetSheet (lets you send tweets from Google Sheet)

TwtrService Example: EasyTweetSheet (lets you send tweets from Google Sheet) | desktop liberation | Scoop.it
Very basic Google Sheet template to let you draft tweets which are published to Twitter when you click a link.

Via Martin Hawksey
more...
Martin Hawksey's curator insight, October 30, 2014 12:21 PM

Following the publication of TwtrService (Google Apps Script client library for Twitter) here's a basic Google Sheet template we use at +ALT to draft tweets we send during events (instead of just sending them on a schedule we have to control to click a link to send)

Scooped by brucemcpherson
Scoop.it!

Do something in 5 with gas 4- Get your analytics profiles to a spread…

Another in the 'do something useful with Google Apps Script' series. This time you'll see how to use the Analytics service and use exponential backoff to mitig…
more...
No comment yet.
Scooped by brucemcpherson
Scoop.it!

Do something in 5 with gas 2-graduate to a database

Here's how to migrate your backend Google Apps Script spreadsheet to a parse.com database in a few minutes.
more...
No comment yet.
Scooped by brucemcpherson
Scoop.it!

Google apps script database abstraction exposed version

Database abstraction – GoogleApps Script Desktop liberation
brucemcpherson's insight:

Here's a VBA API that uses Google Apps Script to access a variety of cloud based databases directly from Excel/VBA.

 

http://ramblings.mcpher.com/Home/excelquirks/dbabstraction/jsaonapivba

more...
No comment yet.
Scooped by brucemcpherson
Scoop.it!

Datastore driver - Desktop Liberation

Datastore driver - Desktop Liberation | desktop liberation | Scoop.it

the Google Cloud Datastore driver for Google Apps Script database abstraction.

more...
No comment yet.
Scooped by brucemcpherson
Scoop.it!

Using named locks with Google Apps Scripts - Desktop Liberation

Using named locks with Google Apps Scripts - Desktop Liberation | desktop liberation | Scoop.it
Liberate Excel data from the desktop
brucemcpherson's insight:

Here's a gas library to  enable locking of named resources. Sounds obscure, but actually very useful.

more...
No comment yet.
Scooped by brucemcpherson
Scoop.it!

Minimizing maps directionfinder api calls

Minimizing maps directionfinder api calls | desktop liberation | Scoop.it
Liberate Excel data from the desktop
brucemcpherson's insight:

If you are using the Maps.Directions API, and plotting many source/destination points, you may be hitting quota problems (too many calls in too short a time, maximum daily allowance). Here's how to automate the use of waypoints to make your quota go further - reducing the number of API calls required by as much as x 20. 

more...
No comment yet.
Rescooped by brucemcpherson from Data Visualization Topics
Scoop.it!

World JS: History Simulation

World JS: History Simulation | desktop liberation | Scoop.it
A brief history of humankind in Javascript

Via Siarhei Mardovich
more...
No comment yet.