[EmileH]

For those interested, our team has created a Google Sheet allowing teams to organize what their students want for parts.

To get started with the sheet:

1. Be sure you are logged in with a Google Account
2. On the sheet (accessible here), click File>Make a copy. Your new copy of the sheet will save to your main Google Drive folder.
3. By default, we have set the sheet to not allow editing in the grayed columns by protecting them from edits (by default the main owner can edit those columns). In order to allow others to edit these columns (although it is not needed for normal use) select Data>Protected sheets and ranges and add or remove collaborators.
4. Share the sheet with your team members via the blue "Share" button - make sure to give them edit permissions. They should receive an email containing a link to the sheet.
5. Once requesters have opened the sheet, simply have them type their name, part number, quantity, and item priority for each part they want to order.
6. You (the sheet owner) can set whether or not you receive notifications when the sheet is changed. To do this, go to Tools>Notifcation rules.

Hope this helps. For any questions feel free to PM me. Kudos to Mark McLeod for the Inventory sheet.