...
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.
If there is any additional detail you think would be useful to know enter it in a comment on the corresponding sheets cell. The more background info the better especially for new designs.
What does each data field mean?
...
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.
The sections are measured as followed
Recovery section begins at the top of the parachute bodytube
Payload Bay section begins at the top plane of bulkhead lower coupler
Feedsystem begins at the top of the flat surface of the fill bulkhead.
Engine bay begins at the top face of the injector bulkhead which is where the longerons get bolted
Length: (For sections note this will be filled out by integration people):
...