What solutions are there to organising a LUGBULK order? I'm involved in a LUG that's made orders in each of the LUGBULK programs that have run.  Determining what goes into each order has proven to be a nightmare, with all sorts of email-spreadsheet-ad hoc solutions that led to various combinations of huge expended effort, errors, misunderstandings and recriminations.

Given rumours of the commencement of the 2013 LUGBULk program are floating around, now's a great time to find out how my LUG can do better this time. Is there a web site we can use, a program of some kind?  Should we just have one member decide what we'll order?  Some happy halfway between autocracy and democracy?

What solutions are there to organising a LUGBULK order?
For our Lug, we have assigned one person who is the contact for all things LUGBULK and is also responsible for the organization of everything. (He also happens to be the one who will spend the most).  We followed this general format to keep everything organized.  


At the most recent club meeting, we agreed on those parts that the club needed for upcoming projects. These get the highest priority.
Once we received notice of LB2013, we asked all of the members to submit their information needed to register and to get an accurate count for Lego.  We gave our members 10 days to get this in.
Within 5 days, each member was allowed to submit up to 10 part requests in order of priority.  Each member is also required to submit the ElementID along with each part in order to make things easier.
The person in charge of LUGBULK for us merged everything together and removed any duplicates.  If we were over our maximum of 100 elements on the wishlist, things get removed that were likely to be declined, or that would be cheaper on BrickLink or PAB. 
The wishlist is submitted to Lego.
Once the approved list and prices are returned to us, we create an excel sheet of available elements and add in columns for BrickLink color names and current BrickLink prices and send it to all members.
All members are required to send in their orders within 7 days.  
The coordinator merges together the orders and sends to Lego.
Once the LUGBULK order is received (on a pallette :) ), the coordinator pays Lego directly, divvies up the orders (or we have a sort party to do it) and then each member pays the coordinator.