For parallel build of the Bill of Materials, we need to have people take individual modules - develop Bills of Materials for these - and then sum these up in a master spreadsheet.
To do this effectively, we will need to sum the same materials effectively. to do this, we need to list:
MODULE - UNIQUE PART DESCRIPTION - QUANTITY - COST - TOTAL COST.
By sorting alphabetically over the UNIQUE PART DESCRIPTION - we can group same items together (they appear together if they are labeled properly, such as '2x4' being a unique identifier.
Thus, unique identifiers should be:
2x4, plywood, screws, nails, rebar, etc. Just common names. A list of common names should be kept in the main BOM page.
The BOM document should be a Google Spreadsheet with subpages - the main page is used for summing things up - all the subpages have the breakdown by module and part.