BOM Requirement: Difference between revisions
No edit summary |
No edit summary |
||
| Line 13: | Line 13: | ||
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. | 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. | ||
<html><iframe src="https://docs.google.com/spreadsheets/d/1aBJxnHVR6_PX_ehXTI6ia2kBXA_R0dVsr65m9-YcJR4/pubhtml?widget=true&headers=false" height=500></iframe></html> | <html><iframe src="https://docs.google.com/spreadsheets/d/1aBJxnHVR6_PX_ehXTI6ia2kBXA_R0dVsr65m9-YcJR4/pubhtml?widget=true&headers=false" height=500 width=100%></iframe></html> | ||
[https://docs.google.com/a/opensourceecology.org/spreadsheets/d/1qUQ65BAp5dSUTMgHGqkCsEq0jwEmNm-Uf05wg63UNEA/edit#gid=1413466213 edit] | [https://docs.google.com/a/opensourceecology.org/spreadsheets/d/1qUQ65BAp5dSUTMgHGqkCsEq0jwEmNm-Uf05wg63UNEA/edit#gid=1413466213 edit] | ||
Revision as of 11:02, 10 September 2014
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.