The default question states are claimed, written, edited, rewrite, and final. The first three are based on writer tags while the latter two are based on cell formatting (underline and bold, respectively). These states can be renamed or even left unused to fit your particular production desires.
You probably want the master copy of the spreadsheet. To use the master copy, simply go to File > Make a Copy and create a copy for your own use. There is an extensive README included in the file. You may have to close and re-open the file (and wait a few seconds) for the “qams²” menu to pop-up. To authorize the script, you’ll need to select a function from the menu (it won’t execute), click continue, choose the Google account you’ll use the script with, and select “Allow”.
qams² includes all of the features from qams, including packet template generation. Subcategory completion is based on a formula rather than requiring a dedicated function. Packet template generation is set up for up to 30 questions and up to 30 packets. It should work for non-standard distributions, including side events, because templates are based on satisfying user-generated constraints. See the sheet for details.
If you have questions that can’t be answered by the answer spreadsheet or reading the script, this is the thread for them. Direct feature requests to [email protected].
Some screenshots: