Pure Wilyam's refined and working version.
Without adapting to Clasp (only with commented test sheets ID for testers in SharedUtilities.js file)
Changes:
-Removed the evaluationStartTime property;
-The 'month' field in Submission and Evaluation Forms changed in accordance with current reporting month;
-New month-column is not reflecting colors format of previous month-column;
-Expelled ambassadors only being marked (EXPELLED), and there is a temporary logic to ignore this markings, allowing to mail them
Color code explanations (see uploaded image):
The palest tone - didn't submit (also used for past cases of didn't submit)
A medium-pale tone - didn't evaluate
The deepest tone - both violations (didn't submit and didn't evaluate)
Red - candidates for expulsion
Pure Wilyam's refined and working version. Without adapting to Clasp (only with commented test sheets ID for testers in SharedUtilities.js file) Changes: -Removed the evaluationStartTime property; -The 'month' field in Submission and Evaluation Forms changed in accordance with current reporting month; -New month-column is not reflecting colors format of previous month-column; -Expelled ambassadors only being marked (EXPELLED), and there is a temporary logic to ignore this markings, allowing to mail them
Color code explanations (see uploaded image): The palest tone - didn't submit (also used for past cases of didn't submit) A medium-pale tone - didn't evaluate The deepest tone - both violations (didn't submit and didn't evaluate) Red - candidates for expulsion