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:

Advertisements

~ by dfflanders on May 11, 2009.

2 Responses to “Auto paste of JISCBIDS spreadsheet marks.”

  1. This sounds brilliant, just what I needed, but unfortunately my real deadline was the previous evening, as I was on a train into London on the morning of 11th. I _think_ I only made one manual transcription error in doing my cut and paste. Several other people have echoed how hard it is, especially with the way the spreadsheet is set up. So thanks very much; I’d certainly use it in the future, although I hope JISC will have a more robust solution by then!

  2. Cool site, love the info.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

 
%d bloggers like this: