Team:Westminster UK/Software
Project
Software
The design of the software was a result of the format used to collect data. The UCL team has created an HTML form where teams can fill in the tasks that they have completed and this information would be relayed to a google sheets document. The google sheets document would store the name of the team and the tasks that they have ticketed upon the submission of the form. This design ensured that teams could submit their responses at different timepoints, instead of requiring the teams to submit all responses in one go. In the sheet, team names are stored in a column and in all columns to the left, the task that they have completed upon the submission (ticked with an x). The table below shows how the information was organised:
Due to the fact that teams could provide multiple submissions, there would be multiple entries in the team column from the same team, each including different tasks per row. In order to condense the multiple entries of each team and merge the data in each row, a temporary list is created where team names are relisted. A loop will identify the name of each team in a cell and copy it to the temporary table, along with the data in the row. A second loop is also utilized in the temporary table to avoid having multiple entries from the same team in the same column. Once all the data has been transferred to the temporary list, the sum of each row in the temporary list is calculated. Each row being a single team, the total of tasks done is calculated. If the team has completed ten tasks, whenever a sum of ten is calculated, the details of the team are gathered and an email notification is sent to the UCL iGEM team. By using Google Scripts, all calculations are performed using Google server computers and, triggers can be implemented so that the calculations are performed without requiring the user to be monitoring. This offers the capacity to automate the monitoring of a large dataset in real time.
