...
When populating a cell,
If the cell column has NO equivalent Assessment Component values, the cell is not editable. You cannot provide a value and the background colour of the cell will be grey indicating the cell is read-only.
If the cell has an equivalent Assessment Component record and the weighting field is empty or not empty, you can edit and update a value in the cell. When the cell is updated, the equivalent Assessment Component record will be automatically updated.
For each column, all cells under a column will be summed up and the total will display to the cell aligned to Assessment Weightings. Every time a cell is populated/updated, the Assessment Weightings will be auto-calculated.
...