If you have permission to edit a spreadsheet you will also have permission to save and load spreadsheet definition files.
There are three default spreadsheets, one for each level. These are called default_classcalc, default_studentcalc, and default_assesscalc.
These are the starting spreadsheets for every class. Modified Spreadsheets
When you modify a spreadsheet you begin working with an temporary copy.
You may save the spreadsheet using the
|Save as & Make This Sheet the Default|
Loading a Spreadsheet Definition from a Published File
Using the Select Spreadsheet File link opens the LON-CAPA resource browser. Only files with the extension spreadsheet can be selected. The spreadsheet definition file must be valid XML. (You must be author to create and publish a spreadsheet file .)
Setting the Assessment Level Spreadsheets used to Calculate Grades
In the student level spreadsheet every assessment in the course has a spreadsheet definition file associated with it. The spreadsheet definition used for each assessment is selected using a drop-down dialog in the Assessments row. Initially this spreadsheet is "Default", meaning the current default assessment spreadsheet will be used to compute the students grade.
Changing the spreadsheet used for an assessment modifies the student level spreadsheet, so you must use the Save as button to save the current student spreadsheet.