Posted by Jeremy on October 31, 2001 1:55 PM
1. How do you get Excel to display degrees.minutes.seconds?
2. This is the hard one. On a single, flat-bed trailer (18-wheeler), the dimensions are 50 feet long, 8 wide, and 8.5 feet tall. I'm trying to program excel to tell me whether or not a piece of pipe will fit within those dimensions. For example, if I have an 84" piece of pipe (7' in diameter) with 4 bends, how do I program excel to tell me whether or not that particular piece of pipe will fit onto a standard trailer? There are multiple ways of positioning a piece of pipe onto a truck. What I'm looking for is a formula that will calculate the smallest dimension of that pipe (i.e., the smallest amount of space that pipe will take up based on the dimensions of that piece). Any takers?