Cone-to Cylinder Analysis
Description
This program follows along with the ASME IIIV-1 code book for the analysis of a cone-to-cylinder junction of a pressure vessel under internal pressure to determine whether or not reinforcement is needed. I have included a second page which is a check against the example problem in App L of IIIV-1. I claim no responsibility for the use of this spreadsheet and suggest that it be used only for a ballpark estimate. Note: Sheets are locked, but there is no password.
Calculation Reference
Pressure Vessels
Calculation Preview
Full download access to any calculation is available to users with a paid or awarded subscription (XLC Pro).
Subscriptions are free to contributors to the site, alternatively they can be purchased.
Click here for information on subscriptions.
Comments: 3
×
johndoyle-admin
8 years ago
XlXtrFun is an Excel addin distributed from another webs site you can download it from here [http://www.xlxtrfun.com/XlXtrFun/XlXtrFun.htm](http://www.xlxtrfun.com/XlXtrFun/XlXtrFun.htm)
16 years ago
We have introduce a new policy on the site to reward contributions with free XLC Subscriptions provided they meet the upload guidelines: 1. Search the repository before you propose a calculation we do not want to repeat ourselves. 2. Consider using the XLC calculation template this helps to keep a consistent approach to site calculations and the layout is based upon a traditional pro forma calculation sheet. View the video which explains how to set out a calculation using the XLC template. 3. Display cell formulae using the XLC Add-in. It is important to show how something is calculated as well as the result of the calculation. XLC Ed or XLC Pro can be used to present your cell formulae. 4. Clearly identify any other Excel Addins that are required. 5. Always include a sketch view this video which explains how to make great sketches with Excel. 6. You must validate your calculation, say how you know it's correct. Does the calculation reproduce a result in a publication or book? Has the calculation been independently checked by another person? 7. Keep worksheets and macros unprotected. 8. Excel 2007 users please upload in *.xls format as *.xlsa format may be unreadable to some users. 9. Check other tips on the 'Earn Your Subscription' page.
If you update the calculation addressing points 2, 3, 5, 6 and 7 we'll gratefully pay the annual subscription cost for XLC Pro.
If you update the calculation addressing points 2, 3, 5, 6 and 7 we'll gratefully pay the annual subscription cost for XLC Pro.