Very often in ship or oil rig construction, the most efficient way to design a deck is to weld tees or angles to the plating. The plating then acts as the top flange of the beam. The question is ... what width of plating is effective as a top flange. I have seen numerous formulations from the...
Statesman's question reminded me of a recent problem I had with conditional formatting .... I have three cells one which contains an independant variable, and two others which contain calculations based on that variable. One of the two is correct for a certain range of values (of the independant...
Most calculators have an Engineering notation feature which formats output in Scientific Notation with the 10 power restricted to multiples of 3.
eg. 534.0x10^3 rather than 5.340x10^5
Does anyone know how to do this in Excel?