Casing Calc - Basic Casing Calculator

[Aksrockets]

For EX motors and custom casings, I do most of my calcs by hand (and some solidworks FEA). I wanted a more elegant way of doing it instead of scribbling on the back of napkins, so I made an Excel Spreadsheet to quickly test ideas.
It's still pretty crude, and it's only used for rough estimations (no heat transfer, no stress concentrations, barlow's formula for burst pressure, full circumfrence snap rings, etc).
Thought I'd throw it out there to see if anyone had any feedback, or any ways of improving it (other failure modes, improved formulas).

Here's a link to the spreadsheet download.
View attachment Casing Calc 1.0.xlsx
Also, I suggest opening with Google Sheets, which is what I made it in.

Alex

 

[dhbarr]

Can't seem to open the file, which claims to be 5 bytes. Any chance of posting the gSheets link?

 

[Danh]

There is a pretty good casing spreadsheet on this page:
https://www.nakka-rocketry.net/softw.html

Along with a lot of other good info