Hello PJ and all,
First of all, please understand that it is not my intention to be sarcastic or rude in this reply (except of course to John Luf). I sincerely hope that something that I write here will be of value.
In summation, there is no equation provided by the ASME B31 Codes for calculating the data shown in Table 121.1.4. And there never will be. The table is there in the B31.1 Code on a "take it or leave it (please)" basis and it is a little less than a "rule of thumb". What most of the replies above are saying is we understand what you are looking for but neither the table nor any underlying equation should be placed in any company's book of standards (even if it did appear in a Code book). Why? Because there are too many "except for(s)" that must be added to such a table to keep the design honest (the notes under the table at issue are but a few of the "except for(s)"). At best, such a table can be a starting point but a real analysis will eventually need to be done and the risk is that that the need for that analysis may be ignored simply because a "standard" was used. If you want to use the B31.1 table as a starting point, fine, but why do you need an equation? Most companies today are interested in limiting their liabilities and if the legal types were to understand the potential ramifications of providing design guidance based upon oversimplifications they would likely withdraw the entire company design standard from further use. I think it is not enough to think that design legitimacy of company standards can be established by simply saying "well it is in the Code".
I would further suggest that you visit the "Forward" in the B31.1 Codes and read the "the Code is not a handbook" paragraph. It would be folly to place Table 121.1.4 in your standard without a similar caveat.
There is a discussion over on Engineering-Tips (thread378-152615) in which Ed Klein posted the Kellogg equation that has been alluded to above by SUPERPIPER:
http://www.eng-tips.com/viewthread.cfm?qid=152615&page=2 But (although I suspect that this is the equation that was used by B31 MDC (circa 1950's) to create the table at issue) I don't think that is what PJ is really looking for. The Kellogg equation calculates maximum deflection ("sag"), but it is for a limited set of boundary conditions. PJ would have to have a set of three or four equations from say, ”Roark's Formulas”, to cover the set of all possible varying boundary conditions in his standard just to reduce the number of "except for(s)".
http://www.spreadsheetworld.com/ItemDetails.asp?ItemID=1000-00-0001-00 As Chuck and John (the elder) have alluded to, any span tables that the B31 Codes give you MUST be used in concert with healthy applications of common sense. That is to say, there are not many times in actual piping design where the tables will be directly applicable. You look at the span table and you can tell what the longest "typical" span between supports might be but if you have concentrated loads like valves and or flanges, the spans will be shorter. And, what material are you using? Carbon steel, stainless, steel, unobtanium,…….? Each would have its own table.
Of course, the only EQUATION (per se) that applies (and this has virtually nothing to do with the span tables) is the equation that the Codes provide for calculating stresses due to sustained pressure plus sustained weight – this will determine maximum spans. That calculated stress must be less than Sh as provided by Appendix "A" of the Code. So from a practical point of view, forget the span tables and let
CAESAR II do the stress calculation for you.
Per the Code the stresses are calculated using the modulus of elasticity of the material at the "cold" temperature (the pipe will be stiffer than it really will be at the "hot" temperature). So, the REAL (“hot”) deflections will not be calculated by your sustained stress analysis. And conversely, since the span table is based upon 750 degrees F. I guess that means the hot elastic modulus was used in the table’s development so using the span table will not always assure you that (in every possible case) the pipe stresses would necessarily comply with the Code.
Having said all of that. If you want to play around with "an equation" as an academic exercise, you can look at Table 121.1.4, note 3, and see that the B31.1 table is based (in part) upon a maximum acceptable "sag" of 0.1 inch. With that understanding, you can play with (borrow John Luf's trusty slide rule) the Kellogg equation (and others to be found in Roark) and back-calculate your own span tables. You can alternately use the hot and cold modulus of elasticity and get some feel for how that affects the allowable span. AND, your span table will be as useless as the one in paragraph 121.1.4.
I have enjoyed reading this discussion. However, I hope that nobody ever asks us to justify the inequality (equation) presented in paragraph 119.7, regarding "method of analysis". But these “points of interest” are just part of the things that make piping engineering fun for us all.
Regards, John (the younger).