Recent content by RonMB

We are installing a custom studding outlet into the center of the head. The analysis would seem to be a variant on Fig. 2-13.2. The issue is equation (2) for C in Table 2-7.1. Since there is no hub, it would appear g0, g1 and h are equal to zero which makes h0 undefined. How is this to be...

Is there a way to prevent other users from changing the options in Excel? Example is to prevent a change to "Move after Enter" under the Edit tab.

All of a sudden, "Goal Seek" does not converge to the goal in Excel 2003. It moves farther and farther away. I have not knowingly changed anything. I have rebooted in an attempt to fix with no luck. Any ideas?

Can anyone tell me how to determine the total turning radius of a tractor/semi-trailer. I know the wheelbase and turning radius of the tractor and the wheelbase of the trailer. Thanks in advance.

I got a zero!! At least now I know to get on with a recreation. Thanks for your input. RonMB

All of a sudden I have lost the graphics created with the Draw menu in one sheet of an ExCel workbook. Newly created ones are not displayed. "Showall" is selected in the Tools>Options Menu. I have reinstalled ExCel.

We have a horizontal cylinder (simple beam)with longitudinal stiffeners along the top. We have a distributed load with the resulting compressive stress along the top. While the reviewing agency agrees that UG-23(b)(2) does not apply once the cylinder includes stiffeners, they do not agree that...

Prex, No vacuum, just beam loading. Is there a statement in the Code that UG-23(b) is for unstiffened cylinders? Thanks for your input. RonMB

I have a horizontal pressure vessel designed to ASME Sec VIII, Div 1. If I add longitudinal stiffeners at the point of maximum compressive load, am I still limited by the allowable compressive stress as determined for B in UG-23(b)(2) or may I use the higher limit of the tensile as in...

I am trying to write a software routine that will determine values from a table to which I have entered points from graphs of data plotted on semi-log paper.

How do I do a linear interpolation of values on semi-log paper?

Section 6.7.4.3.3 of the IMDG and ADR codes for the design of portable tanks calls for the use of the 1% proof strength for austenitic steels. Section 178.274(c)(2)(ii) of 49CFR also cites the use of 1% proof strength. What is the source of this data for SA240 Grade 304 Stainless steel? Does...

Thanks for all your help!

Okay, now that that part works, what is the syntax to bring in the addresses of the calcualted result and the changing cell. I tried the following but got an error: Range("B1").value.GoalSeek Goal:=Range("D1").Formula, ChangingCell:=Range("A1").value2

It does it fine! Thanks a bunch!