...
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 . 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.
...
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, calipers etc.
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
...
Expected: Each subcomponent should have an expected CG. This value should be distance in inches from the front 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.
...