Google Sheets + Verovio Humdrum Viewer

[Craig Sapp]

Hello **HUGers,

I added a spreadsheet toolbar to VHV:

     https://doc.verovio.humdrum.org/interface/toolbar/spreadsheet

that allows you to transfer data between Verovio Humdrum View and a Google spreadsheet.  

Using a spreadsheet makes certain editing tasks much easier than is possible in a plain text editor as is used on the VHV website.  You could copy-and-paste data between VHV and a Google or Excel spreadsheet, but the bidirectional interaction that I set up automates formatting cells as text rather than numbers, and also escapes Humdrum barlines which would otherwise be treated as formulas on spreadsheets.  In addition, I added static colorization of the Humdrum data in the spreadsheet when it is uploaded (with the colors matching that of the VHV text editor).

If you go to the last toolbar by clicking on the cycle icon on the right (before the multipage button at the far right), you can see the spreadsheet controls:

(or type  6 alt-n  to go directly to the spreadsheet toolbar)

The documentation page explains how to create the Spreadsheet script ID needed for the interactive connection.  You can test out the spreadsheet functionality with the ID:

AKfycbwPSnUPffm_A_voZXkYy0sks9sWLr9-ig_m2UOPes9DP1Sod3A

And then go to the linked Google Sheet: http://bit.ly/humdrum-io-spreadsheet

The cloud icon with the up-arrow will upload Humdrum data in the VHV text editor to the spreadsheet, and the cloud icon with the down-arrow will download from the Spreadsheet into the VHV editor.

To use, you should create your own spreadsheet following the documentation instructions.  Do not do any real work with this demo script ID and spreadsheet, since other people could be playing with the same spreadsheet at the same time and overwriting or copying your data...

At the bottom of the documentation page are example cases for using spreadsheets, such as working with orchestral scores by freezing the row that contains the instrumental names:

     https://doc.verovio.humdrum.org/interface/toolbar/spreadsheet/#freezing-rows

You can also add columns for data entry or numeric processing that can be ignored when exporting back into VHV:

      https://doc.verovio.humdrum.org/interface/toolbar/spreadsheet/#ignore-columns

And doing other column-based editing such as swapping subspines, or moving spines around or deleting spines:

     https://doc.verovio.humdrum.org/interface/toolbar/spreadsheet/#moving-music-between-subspines

Once you link a spreadsheet, the VHV editor will remember its script ID if you keep using the same browser on the same computer.

-=+Craig