desktop liberation
17.8K views | +1 today
Follow
desktop liberation
Your new post is loading...
Your new post is loading...
Scooped by brucemcpherson
Scoop.it!

Using Google Visualization API to get data for parse.com

Here's how to use the Google Visualization API to get data out of Google Spreadsheets

brucemcpherson's insight:

As part of playing around with parse.com, here's how to get data into your js app so you can populate parse from Google Spreadsheets. This shows how to sync up this asynchronous activity with others using jQuery promises.

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

MessagePack: It's like JSON. but fast and small.

MessagePack: It's like JSON. but fast and small. | desktop liberation | Scoop.it
RT @oasoner: MessagePack: It's like JSON. but fast and small. http://t.co/rLCoyM6D
more...
No comment yet.
Scooped by brucemcpherson
Scoop.it!

Excel Liberation.: Executing Google Apps Script Code directly in javascript - GAS as a CDN

brucemcpherson's insight:

As you know the language of Google Apps Script is javaScript. So you probably have a lot of useful code buried away there, that could be used in web apps. One solution is to copy it to your web site. Another would be to access it directly from Google Apps Script using the Content service with the recently implemented javascript content type.

Here's how.

more...
No comment yet.
Rescooped by brucemcpherson from All Geeks
Scoop.it!

Infographic : Game of Thrones on Social Media

Infographic : Game of Thrones on Social Media | desktop liberation | Scoop.it

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

Excel Liberation.: Google Apps Script "execution time exceeded" woes

Excel Liberation.: Google Apps Script "execution time exceeded" woes | desktop liberation | Scoop.it

Here are some surprising results benchmarking GAS math operations against excel and local javaScript.

brucemcpherson's insight:
Just how slow is Google Apps Script ?

I'm a big fan of Google Apps Script, but I'm really fed up of seeing "Execution time exceeded". Obviously data access times can be unpredictable, and although it can be improved through caching it's never going to be as good as a local Excel Workbook. But once you have the data loaded, how about processing speeds - shouldn't that be comparable ?


http://excelramblings.blogspot.co.uk/2013/04/google-apps-script-execution-time.html

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

Excel Liberation.: Google Apps Script Color Space Conversions.

Excel Liberation.: Google Apps Script Color Space Conversions. | desktop liberation | Scoop.it
brucemcpherson's insight:

Here's the Google Apps Script version of how to convert between rgb, Hsl, hsv, Lch, Lab color spaces amongst others. You can use these color spaces to generate a selection of color palettes.  

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

cJobject JSON serialization - Excel Liberation

Excel VBA JSON stringify and parse.

brucemcpherson's insight:

VBA JSON serialization from cJobject is now aligned with JSON.stringify and JSON.parse.

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

Excel Liberation.: VBA procedures for CIE LabLch and HSL color scheming

Excel Liberation.: VBA procedures for CIE LabLch and HSL color scheming | desktop liberation | Scoop.it
brucemcpherson's insight:

In playing around with color in VBA I introduced a bunch of functions to manipulate various color spaces from VBA. Digging into the whole topic a little more, I wondered if it would be possible to create color palettes from a single color. After some research, I figured that I would try the cie LabLch and HSL color spaces to see how I might do this. Here are a load of VBA functions to make this possible.

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

Playing around with colors in VBA - Excel Liberation

Playing around with colors in VBA - Excel Liberation | desktop liberation | Scoop.it

VBA conversion between various color models

brucemcpherson's insight:

I've added a few conversions here lately such as RGB to HSL, CMYK and so on. Here's how.

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

Excel Liberation.: VBA string manipulation optimization with custom classes

Excel Liberation.: VBA string manipulation optimization with custom classes | desktop liberation | Scoop.it

Here's a little bit more on the subject of VBA string manipulation. I showed in a post the other day how things take longer and longer when concatenating large strings in VBA.

brucemcpherson's insight:

 One reason I was digging into this was that for very large datasets, JSON serialization  - 500k strings and above, was taking an inexplicable amount of time. It turned out that string concatenation and the interaction with the garbage collector was at the heart of the problem.

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

Excel Liberation.: Inherit link colors from cells - D3 sankey from Excel

Excel Liberation.: Inherit link colors from cells - D3 sankey from Excel | desktop liberation | Scoop.it
brucemcpherson's insight:

You asked for the capability to match d3.js links and nodes to color of the cells they came from in Excel. Here it is.

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

Excel Liberation.: Strings and the garbage collector in VBA : optimizing string concatenation

Excel Liberation.: Strings and the garbage collector in VBA : optimizing string concatenation | desktop liberation | Scoop.it
brucemcpherson's insight:

I remember reading an article on Browser optimization (unfortunately I cant remember where now) where the subject of garbage collection and strings was discussed, in particular the behavior of the garbage collector when a certain amount of strings had been allocated. The same thing happens in VBA. Here's how to avoid it.

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

Circular color ramps. Pantone Spring 2013 colors plotted - Excel Liberation

Circular color ramps. Pantone Spring 2013 colors plotted - Excel Liberation | desktop liberation | Scoop.it

How to plot circular color ramps in VBA

brucemcpherson's insight:

Following on from previous posts on color ramps, here's a circular view of a color ramp - again using the Spring Pantone Color collection plotted in Excel.

http://ramblings.mcpher.com/Home/excelquirks/colorfiesta/pantonedon

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

Building New Experiences with Glass

Timothy Jordan gave developers at SXSW in Austin, TX a sneak peek at the Google Mirror API, which is what they'll use to build services for Glass. With the p...
brucemcpherson's insight:

Interesting video on how glass api wight work.

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

Vega: A Visualization Grammar

Vega: A Visualization Grammar | desktop liberation | Scoop.it
RT @jeffrey_heer: Announcing Vega, a new visualization grammar built on #d3js! Design reusable chart components in a JSON format http://t.co/GuNbXu3jtv
more...
No comment yet.
Scooped by brucemcpherson
Scoop.it!

Query Limits on parse.com - Excel Liberation

Playing around with parse.com 

brucemcpherson's insight:

I've started to play around with incorporating Parse.com into Google Apps Script Projects as a potential alternative to scriptDB. There are a few things to get over first though, 

Here's the first one in this series,

- How to deal with query size limiting in parse.com.

http://ramblings.mcpher.com/Home/excelquirks/parse/parselimits

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

Color Matching in GAS - Excel Liberation

Color Matching in GAS - Excel Liberation | desktop liberation | Scoop.it

Google Apps Script color functions to find how close colors are to each other.

brucemcpherson's insight:

Sometimes you need to find the nearest match to a given color in a specific set of palette or scheme colors. Here's Google Apps Script Versionhttp://ramblings.mcpher.com/Home/excelquirks/gooscript/colormatch
of the original VBA implementation at
http://ramblings.mcpher.com/Home/excelquirks/colorfiesta/nearest

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

Automatic VBA to GAS skeleton - Excel Liberation

Automatic VBA to GAS skeleton - Excel Liberation | desktop liberation | Scoop.it

Automatic VBA to GAS or javaScipt skeletons

brucemcpherson's insight:

I do quite a lot of conversions from VBA to Google Apps Script. It can be kind of boring , especially to get started with a new class or module. Here's some VBA that generates skeleton GAS code right from the original VBA classes and modules and pops it in the clipboard ready to start off your new Apps Script or javaScript module.

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

more...
David Bloor's curator insight, March 13, 3:25 PM

I do quite a lot of conversions from VBA to Google Apps Script. It can be kind of boring , especially to get started with a new class or module. Here's some VBA that generates skeleton GAS code right from the original VBA classes and modules and pops it in the clipboard ready to start off your new Apps Script or javaScript module.

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

Scooped by brucemcpherson
Scoop.it!

Excel Liberation.: Automatic documentation from VBA - including function arguments

Excel Liberation.: Automatic documentation from VBA - including function arguments | desktop liberation | Scoop.it
brucemcpherson's insight:
In documenting VBA procedures automatically I showed how to create web pages that documented your VBA projects. I've updated that now to also include a popup showing the detail of function arguments too.   Hover over the procedure name and it will bring up detail on the arguments - here's the documentation for the code that does it (created by itself) http://xliberation.com/googlecharts/docsclassSerializer.html.
more...
No comment yet.
Scooped by brucemcpherson
Scoop.it!

Excel Liberation.: Using jSon/javaScript like structures in VBA

brucemcpherson's insight:

jSon /VBA functions have always been the most popular topic on the Excel Liberation site and forum. The interesting part about this though is not so much about parsing and stringifying jSon data (which after all is just a simple matter of decoding and formatting), but rather about what to do next. In javaScript, creating objects dynamically is probably its most powerful feature, but VBA doesn’t have anything like that natively. Here's how you can do it.

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

Excel Liberation.: Playing around with Color on Google Apps Script

Excel Liberation.: Playing around with Color on Google Apps Script | desktop liberation | Scoop.it
brucemcpherson's insight:

I've been on a little diversion playing around with color  in VBA, so now it's time to implement some of that in GAS. If you have been following from VBA to Google Apps Script, you'll know that the migration from VBA to Excel is actually pretty trivial for this kind of thing, with most of what's needed already implemented in a shared library.

Here's the detail, and source code on a bunch of color manipulation functions I've ported from VBA to GAS,

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

Excel Liberation Example of automatic code updating from gists for VBA

brucemcpherson's insight:

In a previous post I covered a way of automatically including and inserting VBA code in Excel from gists. You would normally use this if you wanted to include a bunch of functions and classes and excel references with dependencies on each other in some workbook. However, you can easily use it to just pull in a simple class or function, or even to set up references automatically. The main thing though, is that you can get updates directly from gist as and when required.

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

Excel dress up doll - Excel Liberation

Excel dress up doll - Excel Liberation | desktop liberation | Scoop.it

Playing around with Interactively changing the colors on clip art

brucemcpherson's insight:

Here's a bit of fun messing around with Pantone colors of the year and applying them to bits of clip art in Excel.

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

Visualizing tables - Excel Liberation

Visualizing tables - Excel Liberation | desktop liberation | Scoop.it

One liners to create google Visualization or static html tables from Excel

brucemcpherson's insight:

If you want to embed or publish Excel data to web pages, there are many solutions. Excel 2013 does fancy things with skydrive to share data, and there are plenty of activeX plugins and so on that do the same. Here's a my way to create a simple web page or google visualization table that you can either load directly on a web site, or send to someone, with the option of inheriting the Excel cell style properties.

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

Selection of pantone ramps - Excel Liberation

Selection of pantone ramps - Excel Liberation | desktop liberation | Scoop.it

Plotting all the Pantone Fashion Colors from 2004-2013 in Excel. 


http://ramblings.mcpher.com/Home/excelquirks/colorfiesta/pantoneselection

brucemcpherson's insight:

Here's all the Pantone collection colors for the past 10 years plotted VBA. Take a look to see how its done.

more...
No comment yet.