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.
Am I in the right sheet? You can tell this by looking at the title and tab of the spreadsheet you are in and confirming they match the current cycle number.
Simple steps to adding information:
...
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 ):
...
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
probs Roman):
Note that lengths have been changed from being entered by each system designer to being more of an open integration conversation between Roman and all relevant parties.
If you have any issues at all or need clarification on anything please let Joel or Roman know.