Auto paste of JISCBIDS spreadsheet marks.
So @cardcc suggested at #rpmeet that most everyone was using an offline template spreadsheet to mark #jiscbids and that it would be a real time saver if there was a way to auto copy and paste the offline spreadsheet in one go. Well I don’t have a one go solution but I do have a three step solution that I was able to piece together over the weekend (while marking bids).
DISCLAIMER: THIS IS ONLY A PROTOTYPE AND IS NOT THE OFFICIAL WAY TO SUBMIT MARKS FOR JISCBIDS, THIS IS ONLY AN PROTOTYPE TO SHOW HOW THIS MIGHT BE ACHIEVED. YOU STILL MUST SUBMIT BIDS USING THE CURRENT APPROVED FORM.
None the less, if you would like to help me tweak this form so that it could be useable in the future then please follow the below instructions:
1.) Download this Excel Spreadsheet. This spreadsheet is the marking template. Use the template spreadsheet exactly as it is set up. If you change any of the headings rows or columns it will render the spreadsheet useless.
2.) Once you have completed filling out the template spreadsheet follow this screencast (w/audio) step by step for uploading to GoogleDocs. The above screencast will also show you how to publish an RSS feed from the document. TO NOTE: this RSS feed must be a “cell” rss feed so the data can be sliced and diced in multiple way so that it is exposed on the backend system to multiple outputs. Eventually, I’ll enable it for just the simple url for the SS, for now please just make sure you are exposing the right RSS feed.
3.) Once you have the RSS feed go to this form and fill it out. Job done, well then there is a lot of back end processing that takes place to parse your spreadsheet into the various forms it needs to go to as part of the next step in the marking workflow.
Resources used in this work:
- jQuery and the joy of arrays 🙂