Updated September 22, 2022
The spreadsheet is located here: https://docs.google.com/spreadsheets/d/1poRCKzhNSZfQRoP2KN2xZRwuLLkZauFutRtuNmLCAjw/edit#gid=0
First: if you are about to add something to the spreadsheet ask the following question:
...
What does each data field mean?
Source:
Everything you enter into the spreadsheet should have a source. Some examples of acceptable sources are:
Mass:
...
Measured with scale, calipers etc.
Solidworks CG calculation
Guess based on no design work
Hand calculation based on conceptual design
Hand calculation based on detailed design
Initials and Date:
Everything you enter into the spreadsheet should have a name and initials to ensure traceability. I better not have to tell you how to type your initials.
Mass: (Subcomponents):
Min: This is the minimum mass required if your design goes perfectly smoothly and no additional mass is required.
Expected: This is the current best guess at the mass you think you will need.
Max: This is the worst case maximum mass you think the system will require assuming things go pretty bad.
E.g. this may be the mass required if reverting to previous years design.
...