Profile

Cover photo
Bruce Mcpherson
Works at Pepada
Lives in London
888 followers|1,221,353 views
AboutPostsPhotosYouTube

Stream

Bruce Mcpherson

Shared publicly  - 
1
Add a comment...
 
If you're fed up with writing client side JavaScript and Server side Apps Script in separate environments when using the HTMLService, here's how to use your Apps Script code in HTMLService templates.

#gde   #googleappsscript   #blogpost  
12
1
Web Apps R&D's profile photoBruce Mcpherson's profile photoRiël Notermans's profile photoJames Swansburg's profile photo
5 comments
 
True, thanks for that.

I never had these kind of calculations (at least not that they became too slow) so hard to imaging where it would benefit, but I see now.
Add a comment...
 
Just about to go through the Add-on publishing process on this Sheets Add-on. Any testing  volunteers?

#gde   #googleappscript   #blogpost  
8
2
Michael Ellis's profile photoHolger Hubbs's profile photoBruce Mcpherson's profile photoGoogle Developer Experts's profile photo
5 comments
 
I tested it with only 100 rows, 2 columns.
Works well.  Merge is great.

I love "Help" links/texts: a short very simple description of what it does, some  screenshots, some tips, evtl. developer's email. 

Thank you for sharing.
Add a comment...
 
Many of you in this community who use vba and my libraries, are already using cjobject, either directly or behind the scenes.

Cjobject is a vba class that behaves rather like a JavaScript object, and allows you to work easily with JSON or JSON like data structures from within vba, I use it for almost everything.

If you are thinking of moving to google apps script, or to office with JavaScript, playing around with cjobject in vba is a gentle introduction.

Recently I added the ability to store non-JSON-stringify able objects as values in cjobject and it has really enhanced its usefulness.

Here's a deep dive into how cjobject works.

http://ramblings.mcpher.com/Home/excelquirks/json/cjobjectadvaanced
2
Add a comment...
 
 
Here's a handy couple of lines of Apps Script to convert column numbers to A style labels. so 1 = A , 28 = AB etc..

#gde   #googleappsscript   #blogpost  
2 comments on original post
1
Add a comment...

Bruce Mcpherson

Shared publicly  - 
 
Interesting use of sankey/flow diagrams.
 
Chord progressions of 25,000 songs
What interests us here is the type of chords used, regardless of the song’s scale, so that 1->5->6 in the figure above includes songs in key of C major that have the chord progression C->G->Am and songs in the key of A major that have A->E->F#m (if the songs have the same Roman numerals and are in the same relative major.  In reality, the API blends songs into rough categories regardless of the song’s mode, so it’s impossible to know for sure what we’re dealing with). The chord progressions start from the left, and continue to the right. So for example, the transition 4->1->5->6 is one of the most popular ones.    http://amitkohli.com/?p=246

#Music   #MusicTheory   #Acoustics  
7 comments on original post
6
2
Andrew Hyland's profile photoNathan Burnham's profile photo
Add a comment...
Have him in circles
888 people
Ivan Cholakov's profile photo
Davide Monfrecola's profile photo
Masoud Jabbari's profile photo
Prudhvi Penmethsa's profile photo
Arco de Bonte's profile photo
Tien Khoa Do's profile photo
Romano Keogh's profile photo
punitha agnous's profile photo
Dmitry Gorelenkov's profile photo
 
 
Just about to go through the Add-on publishing process on this Sheets Add-on. Any testing  volunteers?

#gde   #googleappscript   #blogpost  
5 comments on original post
1
Bruce Mcpherson's profile photoEdouard Brasier's profile photo
15 comments
 
yes the best approach isn't obvious perhaps a) with an alert asking the user to select back the original color sheet before they can apply the change. 
Add a comment...
 
Very interesting comparison of Ms and google big data solutions
 
Christo Olivier comparing Hadoop (on Azure) vs Google BigQuery w/ 63GB of data.

Monthly costs $4840 vs $1, while magnitudes faster.

Discuss on http://www.reddit.com/r/bigquery/comments/33b5lm/hdinsight_hive_vs_bigquery_a_detailed_comparison/
A while ago I wrote about using Google BigQuery to deliver BI projects faster and for a fraction of cost. Google wrote the original white paper that gave rise to the Hadoop ecosystem we use today f...
View original post
2
Web Apps R&D's profile photo
 
Ups.
Add a comment...
 
Here's a handy couple of lines of Apps Script to convert column numbers to A style labels. so 1 = A , 28 = AB etc..

#gde   #googleappsscript   #blogpost  
10
1
Jean-Pierre Verhulst's profile photoFrédéric Morel's profile photoBruce Mcpherson's profile photo
2 comments
 
Nice. I keep a post-it on my monitor enumerating the alphabet 1-26 and 0-25.
Add a comment...

Bruce Mcpherson

Shared publicly  - 
1
Add a comment...
 
If you follow the Excel/VBA part of this community you will probably be using the cJobject class since pretty much all my code uses it one way or the other. Primarily it's about JSON and JSON structured objects, but it has a lot more handy uses than that. Here's a deep dive that I hope you find useful. It's now downloadable standalone as it's a very handy baseline class for many different jobs. 
1
Add a comment...
People
Have him in circles
888 people
Ivan Cholakov's profile photo
Davide Monfrecola's profile photo
Masoud Jabbari's profile photo
Prudhvi Penmethsa's profile photo
Arco de Bonte's profile photo
Tien Khoa Do's profile photo
Romano Keogh's profile photo
punitha agnous's profile photo
Dmitry Gorelenkov's profile photo
Places
Map of the places this user has livedMap of the places this user has livedMap of the places this user has lived
Currently
London
Previously
Allentown, pa - Singapore - Aberdeen - Tunis - Copenhagen - Bangkok
Links
Contributor to
Story
Tagline
Google Developer Expert - Google Apps Script
Introduction
You can find my desktop liberation blog at excelramblings.mcpher.com, and my site at www.mcpher.com. The content is mainly about getting off the desktop to the cloud I'm on google plus +brucemcpherson and on twitter @brucemcpherson. I'm happy to connect
Bragging rights
Too modest to have any.
Work
Employment
  • Pepada
    Consultant, 2015 - present
  • motorola solutions
    head of architecture, 2007 - 2015
  • Agere
    Head of operations, 2003 - 2005
  • Morse
    Cio, 2005 - 2007
  • Lucent
    Head of infrastructure, 2000 - 2003
  • Taylor Nelson sofres
    Cio, 1979 - 2000
Basic Information
Gender
Male