I am collecting registration information for a conference using a Formstack form, which is dumping the collected data into a Google spreadsheet. People are registering for breakout sessions, of which there are five, with twelve different streams available for each session. For each session they are asked to list their preferred streams, using 1, 2, 3.
What I need help with is (and maybe I'm just too tired at the moment to process it clearly!) that I need to:
keep track of the total number of first preferences for each stream as registrations come in (I can't just use COUNTIF in a row in Google spreadsheets as the new registrations from Formstack are always added to the very bottom of the spreadsheet)
create lists of the registrants in each stream (that I can ultimately print out and check people off against as they arrive)
create a list of streams each registrant has registered for (again ideally printable by individual registrant, to be provided to each for reference)
I'm open to any ideas on the best way to go about this, without having to pay for extra software. I have access to Excel, but not MS Access - happy to use the DB part of OpenOffice if that's the best way forward.
Thanks in advance for your suggestions.