Thank you John for e-mailing me the Flange calculation spreadsheet. For people who just receive it, you can withdraw the sheet protection by copying the file.
I supposed it's a new method of flange calculation but it's the commonly used in ASME code Section VIII division 1 Appendix 2. I don't run the calculation because I have the same sheet that I used many years ago. My colleague (senior engineer) has very perfect program that calculate the stress due to external load any origin (wind, seismic, punctual, …) and the shape factor are calculated with high accuracy using appendix formulas so he doesn't get tired to use a graphics.
I'm about to finish an executable program that calculate flange stress with any load, any flange type with some features :
*High interactivity and user-friendliness.
*Material library for flange with mechanical properties (YS, TS, A%, main composition, Sr, St).
*Material library for bolting with mechanical properties(YS, TS, A%, main composition, Sr, St).
*Material library for gasket with mechanical properties (m, y, type).
*Flange type drawing display.
*Technical Report text format, can be printed.
*Calculation according to the new European code EN13445 for Unfired Pressure Vessel Part 3 Chapter 11 that is the same as EN1591 : Flanges and their joints – Design rules for gasketed circular flange connections – Part 1: Calculation method.
*Material library for Standard European steel.