Excel Liberation
Follow
Find
12.2K views | +8 today
Scooped by brucemcpherson
onto Excel Liberation
Scoop.it!

Passing parameters to Google Apps Script as a Rest Server

Passing parameters to Google Apps Script as a Rest Server | Excel Liberation | Scoop.it

In a previous post I covered how to use the Google Apps Script ScriptDB as a database from which to serve jSON responses - without the need for a server.

Of course you may need to pass arguments - here is how.

more...
No comment yet.
Excel Liberation
Liberating Excel data from the desktop
Curated by brucemcpherson
Your new post is loading...
Scooped by brucemcpherson
Scoop.it!

Accessing Google Sheets directly from Excel - Desktop Liberation

Accessing Google Sheets directly from Excel - Desktop Liberation | Excel Liberation | Scoop.it
Here's another app built with the DataHandler. This time it's actually a VBA app that accesses Google Sheets (and any other database for which there is a driver) via the DataHandler REST API Using this you can read, write and query Google Sheets directly from your VBA code.  
brucemcpherson's insight:

Using this you can read, write and query Google Sheets directly from your VBA code.  

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

Database abstraction with google apps script - Desktop Liberation

Database abstraction with google apps script - Desktop Liberation | Excel Liberation | Scoop.it

with drivers for parse.com, scriptdb and sheets - more on the way.

brucemcpherson's insight:

Sometimes you start with a particular database, or a spreadsheet, then you decide to use something else, and you have to refactor all your code. This is an early version of a Google Apps Script handler for database abstraction (with of course a heavy focus on Google options), to try to avoid some of that pain. 

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

Tutorials — Scott Murray — alignedleft

Data visualization, generative art, and tutorials by Scott Murray, code artist.
brucemcpherson's insight:

if you are just getting started with d3.js, or even checking it out, this is a very accessible few pages.

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

I've just been recognised as a Google Developer Expert

 learned last week that I had been bestowed the honor of membership of the Google Developer Experts (GDE) program.


It's a great feeling to have your work recognised in this way, even though I do feel a little out of place in the company of the august group who make up the current GDE community. GDEs are a small, but enthusiastic group who share a passion for the family of Google APIs and products, and give generously of their time to share their knowledge and ideas with others.

When I started toying with Google Apps Script a couple of years ago I never imagined it would develop such great capability - if you are not familiar with the new add-ons, for example, take a look to see just how far it has come.

I'm planning to continue to search out interesting (and even useful) things to do with Apps Script and other APIS, and I hope you will continue to find this blog and related site, and the various other channels of some help in your journey to the cloud.

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

I hear this makes sense in Japan.

I hear this makes sense in Japan. | Excel Liberation | Scoop.it
I hear this makes sense in Japan.
brucemcpherson's insight:

.. i cant make any sense of this...

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

Excel Liberation.: Google Universal Analytics - getting insight into desktop apps too

Excel Liberation.: Google Universal Analytics - getting insight into desktop apps too | Excel Liberation | Scoop.it
more...
No comment yet.
Scooped by brucemcpherson
Scoop.it!

Using script db as a deaddrop to pass data between GAS, JS and Excel

Here's how to use Google Apps Script ScriptDB as an automated short term data relay for feedback between web sites, Excel and Google Apps Script.
brucemcpherson's insight:

This is the pulling together of a whole bunch of threads. Here's how to use scriptDb to connect data from unconnected systems.

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

earth

earth | Excel Liberation | Scoop.it
An animated map of global weather conditions. Visit the community at https://www.facebook.com/EarthWindMap
brucemcpherson's insight:

This brilliant viz of weather seems to be based on d3.js _ great stuff

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

Sankey Diagram beta - Google Charts — Google Developers

brucemcpherson's insight:

Sankey diagrams now available as google charts. I was in the process of converting by Excel/D3.js  implementation of http://ramblings.mcpher.com/Home/excelquirks/d3/sankey to google spreadsheet, but this will be much easier. 

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

Are the new Google Sheets faster than the old?

Are the new Google Sheets faster than the old? | Excel Liberation | Scoop.it
brucemcpherson's insight:

Good speed improvement for writing data in the new Google Sheets.

more...
Martin Hawksey's curator insight, January 28, 4:13 AM

What's interesting is in the new Sheets known issues it states "Some methods, most notably batch-set methods like Range.setValues(), are currently slow in the new version of Sheets." https://developers.google.com/apps-script/migration/sheets#performance ... so slow but still faster???

Scooped by brucemcpherson
Scoop.it!

Apps Script custom functions - Excel Liberation

Apps Script custom functions - Excel Liberation | Excel Liberation | Scoop.it
Liberate Excel data from the desktop
brucemcpherson's insight:

I'm putting together a primer on how to do some of the more common things you do in custom excel functions, but would like to do in Google Apps Script. Register some suggestions here.

more...
Martin Hawksey's curator insight, January 17, 9:56 AM

Highlighting the difference between VBA and App Script functions

Scooped by brucemcpherson
Scoop.it!

:snips - We Scale Cities

:snips - We Scale Cities | Excel Liberation | Scoop.it
:snips - We Scale Cities (Fast interactive prototyping with Sketch and D3.js: http://t.co/35XVhxKPft)
brucemcpherson's insight:

this is a really  innovative use of d3.js. well worth a look

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

JavaScript client API for Google Apps Script API primer

An API for JavaScript/jQuery client webapps providing CRUD access to Google Apps Script scriptDB - a free noSQL databases. This adds to a VBA API for Excel alre
brucemcpherson's insight:

Here's a slideshare primer for the api i released yesterday.

 

http://ramblings.mcpher.com/Home/excelquirks/scriptdb/scriptdbjavascript

more...
Martin Hawksey's curator insight, January 12, 7:54 AM

More fantastic work by Bruce Mcpherson

Scooped by brucemcpherson
Scoop.it!

pollHandler app and library - Desktop Liberation

pollHandler app and library - Desktop Liberation | Excel Liberation | Scoop.it

Polling app based on Google Apps Script

brucemcpherson's insight:

Here's the all you need for a simple Poll app based on a Google Apps Script webapp handling a parse.com database, Google Charts and a javascript client.

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

Database caching with Google Apps Script

Database caching with Google Apps Script | Excel Liberation | Scoop.it

Using Google CacheService can make a great difference in perceived database performance. Here's an underlying database independent library you can use to make keys data driven and systematic

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

SunCalc - Apps Script library and web apps version

SunCalc -  Apps Script library and web apps version | Excel Liberation | Scoop.it

Suncalc Google Apps Script library and webapp.

brucemcpherson's insight:

Here's a Google Apps Script version of SunCalc. There's a  library to include in projects, and a  webapp to provide rest query responses. It calculates things like sunrise, sunset and so on given a location and a date. Created from Vladimir Agafonkin's https://github.com/mourner/suncalc.

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

More Apps Script APIs and Features - Google Apps Developer Blog

More Apps Script APIs and Features - Google Apps Developer Blog | Excel Liberation | Scoop.it
brucemcpherson's insight:

lots of new cool stuff in google apps script...

more...
No comment yet.
Rescooped by brucemcpherson from BIG data, Data Mining, Predictive Modeling, Visualization
Scoop.it!

These Are The Companies That Will Dominate The Post-Banner Advertising World (GOOG, YHOO)

These Are The Companies That Will Dominate The Post-Banner Advertising World (GOOG, YHOO) | Excel Liberation | Scoop.it
Investment banker Terence Kawaja of LUMA Partners passed along his latest chart on the ad tech world.
This chart looks at the world of native advertising, which is a hot topic right now.

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

ScriptDB as a dead drop - Excel Liberation

ScriptDB as a dead drop - Excel Liberation | Excel Liberation | Scoop.it
Liberate Excel data from the desktop
brucemcpherson's insight:

Here's a way to get unconnected apps to co-operate using Google Apps ScriptDb

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

Monopoly in Excel | Tableau Zen

Before Tableau I had a passion for Excel. I loved it because it was a canvas where almost anything was possible. To prove it, I set out to make one of my favorite games in it...Monopoly. It was pretty challenging and I never ...
brucemcpherson's insight:

pretty cool thing

more...
Amanda Dahlquist's curator insight, February 6, 10:22 AM

This is an amazing use of Excel's potential. The author's insight about Tableau is also interesting, though.

 

Credit: @brucemcpherson

Scooped by brucemcpherson
Scoop.it!

Visualization: Timeline - Google Charts — Google Developers

brucemcpherson's insight:

.. and another one. Timeline charts available on google charts. potential replacement for roadmaps - - http://ramblings.mcpher.com/Home/excelquirks/snippets/howtoroadmapper

and google apps script version

http://ramblings.mcpher.com/Home/excelquirks/gooscript/done

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

Keisuke Oohashi – Google+ - Hi all appsscript hackers. I've released new Chrome…

Keisuke Oohashi – Google+ - Hi all appsscript hackers. I've released new Chrome… | Excel Liberation | Scoop.it
Hi all appsscript hackers.
I've released new Chrome Extension "GAS Library Box" for users of AppsScript.

GAS Library Box is a Chrome Extension for…
brucemcpherson's insight:

Here's a brilliant way to manage all those Google Apps Script libraries.

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

Fun But Learn: Conduct Poll in Google+ and Display Result in Your Site

Fun But Learn: Conduct Poll in Google+ and Display Result in Your Site | Excel Liberation | Scoop.it

A nice tutorial to conduct polls on Google+ and how you can extract the counts and display them on your web page. This is definitely a nice way to reach to maximum people and get maximum votes.


Via Martin Hawksey
more...
brucemcpherson's comment, January 26, 4:50 AM
Haven't tried this yet, but it looks like a smart idea.
Martin Hawksey's comment, January 28, 4:24 AM
@brucemcpherson the developer was getting some stick along lines of 'why don't you use forms' ... shame they didn't see some of the creative thinking that went into this
brucemcpherson's comment, January 28, 5:30 PM
Yep.. I was really impressed by the lateral thinking here. I'm sure this idea can be applied to other problems.
Scooped by brucemcpherson
Scoop.it!

Google brings Chrome OS straight into Windows 8 in latest... - The Verge

Google brings Chrome OS straight into Windows 8 in latest... - The Verge | Excel Liberation | Scoop.it
Google brings Chrome OS straight into Windows 8 in latest...
The Verge
Just like Google's full Chrome OS, you can create multiple browser windows and arrange them using a snap to the left or right of the display or full-screen modes.
brucemcpherson's insight:

looking forward to playing with this...

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

A simple Google Apps Script RestQuery - Excel Liberation

A simple Google Apps Script RestQuery - Excel Liberation | Excel Liberation | Scoop.it
Liberate Excel data from the desktop
brucemcpherson's insight:

If you follow this site, you'll know there is a lot of content that shows how to convert VBA projects to Google Apps Script. Eventually, you'll want to leave VBA behind. 

 

Here's a 'no dependency' example of the kind of thing GAS does really well.

more...
malek's comment, January 16, 2:22 PM
True: time to kiss VBA goodbye.