Data Visualization II Write all code and calculations in Jupyter. If is isnt possible to create visualization in jupyter, use python instead. You may use existing code from the previous two projects. You will see that there is a lot of redundancy and therefore it will save you work and time! All words/metrics marked red – please see additional sheet with equations. All graphs should be interactive = redrawn / recalculated on the fly as in the crossfilter. 1) Create a small database for fit files! Use the Dashboard project template and add a menu point „fit files“. Here create a folder for each athlete where we can: a) either drag and drop files (bulk!!) or where files from the plattform Garmin Connect and/or Strava can be pushed to automatically (!) (this part is already programmed in the Jupyter project CP19). Allow the user to enter and edit a name of each file (click in cell in table) and also edit the preselected body weight (see below point 3). Always use the body weight which is time wise the most approximate to another file (regardless if the entered body weight is older or newer as and regardless if it comes from the “old” database of the previous visualization project, OR if the user entered it manually here in the folder fit files. 2) Create another tab in the menu named „events“. Here a simple table is presented. In this table the user sees all names of all athletes (similar to the dashboards project). Create two drop down menus: 1) named year – here the user can choose the year. Each year is one table. 2) team – here the user can choose a main team (this isn’t the subteams of the previous project). For each combination – year and main team – the user gets presented one table as shown below. Vertically the athlete are already filled in the cells for Athletes (sorted by Alphabet – last name / first name). The horizontal cells for name of event as well as start and end date, the user enters manually (needs an option to save this). Now the user simply checks a cell (for example event 5, athlete 6) -like a checkbox – to assign an athlete to an event.