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

Excel Liberation.: Google Docs to Excel Asynchronously

brucemcpherson's insight:

This builds on a previous post about the implementation of promises in VBA. Here's how to use promises to get a collection of google worksheets directly into Excel in the background.

more...
No comment yet.

From around the web

desktop liberation
Your new post is loading...
Your new post is loading...
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, 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!

Google's Quantum Computing Playground turns your PC into a quantum computer - ExtremeTech

Google's Quantum Computing Playground turns your PC into a quantum computer - ExtremeTech | desktop liberation | Scoop.it
ExtremeTech
Google's Quantum Computing Playground turns your PC into a quantum computer
ExtremeTech
... not quite: You can simulate a quantum computer on your PC by running the Quantum Computing Playground web app for Chrome.
more...
No comment yet.
Scooped by brucemcpherson
Scoop.it!

APIs.io and APIs.json Launched at Gluecon to Make API Discoverability More Like Search

APIs.io and APIs.json Launched at Gluecon to Make API Discoverability More Like Search | desktop liberation | Scoop.it
A new API Discoverability search engine and a robots.txt type-format have been launched today at Gluecon.
brucemcpherson's insight:

I hope this takes off .. discoverable APIS will be a defining feature of the future web.

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

Integrating import.io with Google Apps Script

An introduction into how Google Apps Script can be used with the import.io web data extraction service.


Via Martin Hawksey
more...
Martin Hawksey's curator insight, May 22, 9:23 AM

This post has resulted in a importio client library opening the way for more easy integrations http://support.import.io/knowledgebase/articles/367423

Scooped by brucemcpherson
Scoop.it!

Eurovision results with d3.js, crossfilter and dc.js - interactively explore the voting behavior

Eurovision results with d3.js, crossfilter and dc.js - interactively explore the voting behavior | desktop liberation | Scoop.it

Here's an interactive visualization mixing up various technologies, using the historical voting data from Eurovision

brucemcpherson's insight:

Explore the political voting behavior between countries participating in the Eurovision Song contest over the years with this interactive visualization

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

Get Data From Google Docs - Desktop Liberation

Get Data From Google Docs - Desktop Liberation | desktop liberation | Scoop.it

I had to revamp Google Sheets to Excel importing since the new Sheets schema has changed a bit. If you use this, take a look at the new version

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

Universal analytics for checking co-operating processes - Desktop Liberation

Universal analytics for checking co-operating processes - Desktop Liberation | desktop liberation | Scoop.it

This shows how to use real time analytics to track the progress of a VBA process and the Google Apps Script libraries it kicks off to update a series of back end databases on its behalf.

brucemcpherson's insight:

 The short video is extremely boring, but the capability to track things happening in real time is really nice when developing these kind of distributed integrations.

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.
Scooped by brucemcpherson
Scoop.it!

Parse.com as a substitute for ScriptDB in Google Apps Script

Parse.com as a substitute for ScriptDB in Google Apps Script | desktop liberation | Scoop.it
brucemcpherson's insight:

As you will know by now, ScriptDB is now deprecated. A year or so ago, I published some articles on alternatives to ScriptDB on the desktop liberation site, one of which was Parse.com. This has turned out to be one of the most popular topics. Here's how to get started and get your data off scriptDB.

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

Rasenball World Cup 2014 Visualization

Rasenball World Cup 2014 Visualization | desktop liberation | Scoop.it
Visualization for the World Championship (Amazing #html5 #D3.js web/mobile application - Everything you need to know about the #2014 #FIFA World Cup http://t.co/jv7HRTzw2X)...
brucemcpherson's insight:

I'm not interested in football, but this is a great viz.

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

Flattening and unflattening objects to spreadsheets - Desktop Liberation

Flattening and unflattening objects to spreadsheets - Desktop Liberation | desktop liberation | Scoop.it

here's how to flatten and unflatten JavaScript objects so they fit in a Google Spreadsheet

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

Comment on Hacking the Google Trends API by curious

Comment on Hacking the Google Trends API by curious | desktop liberation | Scoop.it
Hi There.
Great article.
I am looking to analyze as much details I can get for the hot trending topics on the internet (google, Twitter, FB, Bing) etc. As much analytics as I can get would be awesome.
more...
No comment yet.
Scooped by brucemcpherson
Scoop.it!

Using crossfilter with Google Apps Script - Desktop Liberation

Using crossfilter with Google Apps Script - Desktop Liberation | desktop liberation | Scoop.it

crossfilter.js is a great library for playing around with big lumps of data. Here's a GAS library with crossfilter

brucemcpherson's insight:

if you like d3.js, you'll like crossfilter

more...
No comment yet.
Rescooped by brucemcpherson from Search engine optimization : SEO
Scoop.it!

Onsite SEO Cheat Sheet

Onsite SEO Cheat Sheet | desktop liberation | Scoop.it
Onsite SEO Cheat Sheet from colinbancmedia. For web designers, developers and SEOs that want to check if a website is search engine friendly.

Via Veille digitale
more...
No comment yet.