grapesmoker / qems2

A new implementation of the QEMS submission system for quizbowl questions.
GNU General Public License v2.0
9 stars 4 forks source link

Allow input of category spreadsheet and restrict packet dropdowns to legal values #337

Open mbentley00 opened 6 years ago

mbentley00 commented 6 years ago

At least for NSC sets, QEMS should be able to read in a packet spreadsheet like Ophir developed. It should then use this to restrict what you can select from the packet dropdowns to legal values. In other words, you can only set a World Geography tossup to Packet 8 if that's where the tossup is going to end up during packetization.

mweiner1 commented 6 years ago

Lately I've been mapping out the entire template for the set in Excel (tossup 1 of packet 1 is world geography, tossup 2 of packet 1 is chemistry, etc...) and then summing up the results to create the distribution for QEMS2. Is this the same thing you're referring to? If editors can just upload a table in a standard format that would definitely save the annoyance of typing values in all the distribution boxes. Supporting this feature request.