NOSE CONE SPREADSHEET
The Nose Cone Spread Sheet is an Excel document created by Kemal Payza. It is pretty much self explanatory however here are some instructions to help get you up and running. You can download the Nose Cone Spreadsheet by right clicking HERE and selecting Save Target As.. To run the Spreadsheet on-line then just click HERE
The parameter definitions are:
All these parameters are set on the Ogive page except for P, that you define on each page that you want to use. Use the same units for all parameters (for example if you enter the diameter in inches, then all entries of length, thickness, etc. must also be in inches) except for P, which is unitless. Examples of curve shapes obtainable are shown on each page of the spreadsheet, and on the first page (EQUATIONS) there is a table showing examples of parameter values and pictures of the shapes generated from them.
The Excel file is read-only to avoid compromising the formulas, displays, etc. Use the "Save As..." function to save the file for each nose cone you define.
X is the distance along longitudinal axis of nose cone measured from body tube joint (positive values are distance from the body tube joint towards the tip of the cone, negative values are distance from the joint towards the back of the rocket inside the body tube).
Y is the nose cone radius, calculated according to the values entered by the user, at each point X. The Y value is the radius at which you need to cut your nose cone block with the lathe in order to make the desired shape.
Naturally, the units of X and Y will be the same as you used to define the cone.
If you are using one type of nose cone shape, use the spreadsheet from that page to obtain your X and Y values. If you are averaging more than one shape, use the table from the "Weighted AVG" page after entering the percentage of each source shape desired.