I'll show you over the course of this three video series how you can use Excel to solve this problem faster and with fewer chances of errors to simplify the problem a little bit I've also made some assumptions will assume that the p reload is equal to one point five times the maximum force we'll also assume that the bolts carry two percent of the joint load as the joint tries to separate some of the load is carried by the pressure vessel components themselves and some is carried by the hardware to make the problem solvable in a relatively short period of time we'll just assume the portion of the load in the bolts is 2% will neglect component deflection and assume that everything is rigid we'll also neglect the gasket which I haven't shown in the drawing and finally we'll assume that the joint uses gradate fine threaded Hardware okay now that we're in the actual spreadsheet.sign up for the latest free training series
Continue Reading about the "Excel Training for Engineers: Learn advanced engineering techniques in Excel" on the next page below
Post a Comment