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:
Am I a subsystem lead, team lead, Joel or do I have express permission from one of them to add information?
If no please don’t touch anything
Is it the time in a cycle to add information?
If not then don’t touch anything.
Simple steps to adding information:
Talk with your subsystem designers and make educated guesses at the values we are asking for: Min, expected, and max mass (in lbs), as well as CG (in inches) for each component. See below for more info on how to make these guesses.
Go to the sheets document and find the section of the rocket you are responsible for. There should not currently be any information in that box. If there is, ensure you are on the right sheet corresponding to the correct cycle.
Input data into all boxes you are responsible for. Boxes that need data are outlined in thick black. Input the method you came to this number by and your initials with the date in the box to the right of the data you just entered. The initials and date are important so that integration concerns can be addressed with the proper person.
What does each data field mean?
Source:
Everything you enter into the spreadsheet should have a source. See this if you’re unsure of how to calculate center of gravity. Some examples of acceptable sources are:
Measured with scale.
Solidworks CG calculation
Guess based on no design work (initial rough estimates only, not ideal)
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.
Note section values will be autofilled based on values from subcomponents after all data is entered
CG: (Subcomponents):
Expected: Each subcomponent should have an expected CG. This value should be distance in inches from the forward of the section (i.e., towards the nosecone) to the CG of the subcomponent.
Note we are assuming mass is axially symmetrical so this value should be distance in the Z axis in CAD ignoring if the part is offset of center.
This value will most likely be a fairly rough approximation unless a detailed CAD design is complete of both part and section and materials fully selected.
Length: (For sections note this will be filled out by integration people):
Min: This is the minimum expected length required for this section assuming the design goes perfectly smoothly and no additional length is required.
Expected: This is the current best guess at what length you think the section will require
Max: This is the worst case maximum length you think the section will require assuming things go pretty bad.