UPDATE:currently
View attachment 42158View attachment 42159
the plan is to import the average mark from each individual sheet to the 'Analytics' sheet –> colour indicator if your average is meeting your goals or not as well as the other pages but this requires making custom scripts
this is most definitely not a good use of my time but it's fine it's motivation woops the reds are mismatched i hate selecting in colour palettes
everything else is done (after a bit of 12am tomfoolery), and it edits automatically but:
mark colour either be green or red based off the 'goal marks'
changing time to hours minutes format
doing colour theming and stuff now
(this is not worth it in the slightest)