Timeline structure

The data source structure is described on the demo sheets.

Google spreadsheet Timeline_DEMO contains several sheets that will be described below

This image has an empty alt attribute; its file name is aLW940U7HqJnHzHS_J1pTZyJr6m7h3cdw6rwQWI5_knxZi_aO8O_a41l6OS5vLSoykk266MTV5_N6R0PXitKrtHnZkVWXlkoTLbBhA3loImLuVo_uO6Qjef1bFBG3d0FoagrXmSh

timeline sheet

The timeline sheet contains data for all three cases flagged by categories. By clicking on the Copy button the current record gets copied to the sheet edit.


~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

edit sheet

Current line can be edited in more detail and pasted back to the timeline sheet. Description button shows the contents of the description field in case html has been used.

This image has an empty alt attribute; its file name is 6EqOG9SDOZezSILSv7hKdp7iBvsI4dVfPpMru9bm0x1-XgLgQdw9Fz9t6Zg9c_GXS1zeasJrXwgXH7NPShcMZbytix3RH6gk6uZRTjhamuCKVdwoG8I_QZ0ep3TfPrF6xj8V-LO9

lists sheet

Contains various lists e.g. colors, categories etc.

gannt sheet

The sheet gets generated when the Gannt visualisation option has been chosen

config sheet

Visualisations can be generated from the config sheetby choosing the category and visualisation type, clicking on the button RUN Visualisation. Actual visualisation can be seen by pressing Result-Visualisation after the message Finished script appears.

This image has an empty alt attribute; its file name is image-1.png

Timeline sheet columns

One line of the seeht describes one event

  • category: text from the list values on the lists sheet
  • date_from: mandatory starting date of the event in the form of YYYY-MM_DD (e.g. 2021-01-20)
  • date_to: ending date of the event, not mandatory
  • headline: short text describing the event
  • description: longer text. It can include html code. Links to the url listed further in the form [urlx, text] gets translated to a hyperlink. E.g. [url1,Link] gets converted to a hyperlink to the website listed in the field url1.
  • color: pick the color from the colorlist on the lists sheet
  • note: short text useful as a caption for the photo
  • link: link to a website related to the descriptiom
  • url1 – 5: description can contain max 5 urls (see description)

Button/Macros

There are buttons on some sheets that perform specific actions by clicing on the left button.

You can move the buttons to the appropriate place by clicking on the right mouse button.

Buttons can be run also by following macro keyes.