Daily Film Planner
Budget: £20 – £250 GBP
I have a spreadsheet of data that lists various Films which will be playing at various cinemas at certain times of the day over the course of 10 days.
I want to visualise this data so that I can more clearly see what films are playing where and when and for how long on each day.
Ideally, Column A lists the cinemas and Row 1 the time of day, going up in increments of 5 mins e.g. B2 = 8:30, B3=8:35 etc. Then drawing from my data in another tab, I want this sheet to be automated in showing what films are playing at what cinemas at what times. E.g. X film is playing at cinema 1 at 9:00, X film is playing at Cinema 2 at 11:00 etc.
Ideally as well, I want to use the run times of films to help display how long a film is playing for in this spreadsheet, rounded to the nearest 5 mins and highlighted in terms of if that film has been ranked more or less of a priority. E.g. Green for High, Orange for Medium etc.
I want to visualise this data so that I can more clearly see what films are playing where and when and for how long on each day.
Ideally, Column A lists the cinemas and Row 1 the time of day, going up in increments of 5 mins e.g. B2 = 8:30, B3=8:35 etc. Then drawing from my data in another tab, I want this sheet to be automated in showing what films are playing at what cinemas at what times. E.g. X film is playing at cinema 1 at 9:00, X film is playing at Cinema 2 at 11:00 etc.
Ideally as well, I want to use the run times of films to help display how long a film is playing for in this spreadsheet, rounded to the nearest 5 mins and highlighted in terms of if that film has been ranked more or less of a priority. E.g. Green for High, Orange for Medium etc.