info card on hover or click
Apps Script

4 ways to customize scrviz info card behavior

Info Card customization By default the info card appears when you hover over a node in the scrviz visualization. Although the info card is they key tool for investigating scrviz entries, it can be annoying […]

Apps Script

Enrich your developer profile on scrviz

In Showcase your Apps Script work and get hired via vizzy I showed how scrviz could be used to show off your Apps Script work to potential clients, so they could see what kind of […]

gapi and vuex
Apps Script & Java Script

Google gapi, Vue and Vuex together

Motivation JavaScript authentication with Gapi is both impressive and frustrating. Frustrating because in most of the examples you come across, and indeed in Google’s own guides, gapi is the center of the universe.  They are […]

D3

cv-viz: Virus infection simulation with D3.js

The coronavirus is with us, and naturally, there’s much interest in data on its mortality, reach and spread, and of course much discussion on lockdowns, health capacity, social distancing and how they might affect those […]

D3

Emulating worksheet functions in apps script with d3

For setting up D3Gas you’ll need the library, and for background on D3 and Apps Script read Using D3 in server side Gas Set up You’ll need the d3Gas library.  1vZzEtFKAG_PHn44HgEdSBave5NQ-SprisJ0Ngid0ovahwEOMkBO1s6DX Then you can do this […]

No Picture
D3

Using D3 in server side Gas

There are plenty of examples on this site of using D3 for its visualization capabilities, whether from Excel, Apps Script or some other platform. I like D3 a lot, and now with the release of […]

Apps Script & Java Script

HTML service without caja

If you are reading this in 2015, you probably won’t have come across caja, since you’ll be using this, as was announced today

For those of us still in 2014, this represents a major step […]

No Picture
D3

Focus node explorer with d3.js

There’s a lot of different things going on in this topic. Most of them have been covered before, and lead to this mashup, but I am introducing a new kind of d3 chart (for me […]

D3

D3 force from GAS Site

In Site data to sheets i showed how to get basic data from Analyzing site content with GAS into Excel and Google Sheets. To be able to use Excel tables to d3.js Force diagram, we are going to focus on […]

Apps Script & Java Script

Zoomable Partition Charts

How to create a d3 zoomable partition chart straight from Excel. As always, acknowledgement to Mike Bostock on whose zoomable partition chart this is based.  A partition chart is a way of showong heirarchical data. The zoomable part is […]

D3

Making sense of joins in D3

I come back to D3 about once every 6 months, and every single time I’ve forgotten how joins work. To avoid that next time, I’m writing it down to explain to myself, and hopefully you […]

D3

Flight data from Fusion

I’ve been playing around with the live integration of large cloud based data sets with D3.js. Most visualizations with D3 use some kind of static data, but I became interested in pulling different source into d3. […]

No Picture
Apps Script & Java Script

Developer information for d3.js force diagrams

To develop Excel applications that generate web pages incorporating d3.js force diagrams from Excel data, first read this Excel tables to d3.js Force diagram. You will also need to be familiar with How to use cDataSet and How to […]

Apps Script & Java Script

Adding markers to d3.js force diagrams

How to add markers to links In Excel tables to d3.js Force diagram I showed how to create a basic force diagram. Since that time, I’ve added the capability to add markers (arrows) to the end of […]

D3

Excel tables to d3.js Force diagram

How to create d3.js force diagrams from  excel tables In Sankey diagrams from Excel and Creating d3.js Tree diagrams the input data for these d3.js visualizations was of a specific layout. We are now going to look at a more generalized […]

D3

Eurovision results with crossfilter and dc.js

Since the 50’s, there has been an annual song contest involving many European countries. It’s a fairly bizarre event, but one of the most interesting things about it is the voting system. Countries vote for […]

Apps Script & Java Script

Creating d3.js Tree diagrams

Acknowledgement d3.js is from Mike Bostok’s site. If you use any of this material, please be sure to maintain the acknowledgement for his work. I also found out how to create tree diagrams on Pavan Podila’s blog. […]

D3

Big quiz score reports

‘m showing score reports for the BigQuiz app. This is an individual players score compared to the maximum he could have got as well as the number of questions that were correctly answered, and also comparing […]

D3

Quick doughnut and pie charts with a radial timer

If you’ve been trying out the Configurable circular timer with D3 or playing around with Example of clock using d3 configurable timer you’ll have seen how easy it is to create a versatile timer by just configuring a few […]

D3

Example of clock using d3 configurable timer

In Configurable circular timer with D3 I showed a circular timer made with D3.js . Although it’s not really what it’s for, this simple example shows how to make a complex viz. This is a clock […]

D3

Configurable circular timer with D3

I don’t use jQuery, neither in regular webapps nor in Apps Script HtmlService apps. No particular reason – I just prefer to use vanilla JavaScript. I often use d3.js, mainly for visualization as in these examples elsewhere […]

Apps Script & Java Script

Color scheme explorer

In this section, we’ll build an application that pulls together many concepts already covered elsewhere on this site. You can run it standalone at xliberation.com, or below, embedded in this page  The target application Pulling together Playing […]

Apps Script & Java Script

d3.js and parse mashup

This is an interesting d3.js and parse.com mashup of a number of topics covered on this site. The target is to build an app that Retrieves color scheme data from a parse.com database, much like […]

Apps Script & Java Script

Configurable canvas meter

Here’s a very simple, but nice looking meter in JavaScript. It’s configurable for a number of uses. There’s no need for any css (styling is by configuration) or additional libraries (it uses Chroma-js), as everything […]

Add-ons

Chord Snip

Chord snip is an add-on for Google Sheets that creates a Chord diagram as you type, gives you the SVG code to embed it in a web site and the ability to embed it in […]

Apps Script & Java Script

Sankey diagram from Excel

Acknowledgement Much of the JavaScript and d3.js came from Mike Bostok’s site. If you use any of this material, please be sure to maintain the acknowledgement for his work. There have been a few features added […]

D3

d3.js

What is d3.js d3.js is a javaScript library that provides a ‘declarative framework’ for DOM manipulation and simplified access to SVG. d3 is the work of Mike Bostok and you should spend some time taking a look at […]

No Picture
D3

parse.com and d3.js mashup

Today’s post pulls together a number of concepts I’ve been playing around with lately. As usual my source data and post theme is based on data associated with color schemes – pantone, paint colors etc […]