A Python tool for visual activity planning at the Proton Synchrotron

Abstract

This report describes the work done as a part of the CERN Summer Student Programme of 2021. The project was aimed at developing a tool for the automated creation of visual representations of activity planning data on the Proton Synchrotron. The end goal was to obtain a program that could read planning data in an Excel format as an input, and produce PowerPoint slides with the data visualisations for each day as an output. The project was implemented in Python using the Bokeh visualisation library. The final code was able to meet the goals, automatically producing slides with the relevant visual activity representations as well as generating an interactive version of the map that allowed the user to view the activities by selecting a day from a calendar interfac