Batch-Create Weekly "Time-Series" Events for Multiple Calendars

What is this?

This live demo is an "easy-to-see" overview of complex time-based information!

It shows the actual weekly movie showtimes of a local discount movie theater.

Using Google Apps Script, their weekly email schedule is parsed, 

to prepare an intermediate "standardized" input data format,

which is then used to batch-generate about 20 new "time-series" events,

(these are then presented as about 150 events, per the "repeating" settings.)

By using the built-in "repeating" capability of "time-series" events on Google Calendars, many event-listings appear for each actual repeating event. 

This calendar combines about 12 separate, special-purpse calendars -- one for each movie -- to allow the different colors together. 

Each week has about 150 showtimes, to cover about 10 different films.

How was this built?

All was accomplished completely with Google tools, solely -- namely:

• • this Google Site (within this Google App), 

  • a Google Spreadsheet, 

  • 12 Google Calendars, 

  • server-side Javascript (via Google App Script).

The Google Apps Script reads data in a Google Spreadsheet, 

then creates "event series" across 12 separate Google Calendars.

Those 12 Google Calendars were then all combined, 

and embedded within this Google Site, (which you are now viewing)

 -- for this easy visual overview -- showing what happens when!

A Celebration!

Lots of learning needed, to make this work, but good fun

 -- delving deep into all these free and powerful data-juggling tools, from Google!

(My joy these days, is striving to chase the accelerating progress of Google

 -- as they provide amazing magic for computer programmers, to do so much, so easily)