Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations TugboatEng on being selected by the Eng-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: RonMB
  • Order by date
  1. RonMB

    Studding Outlet Calculation

    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...
  2. RonMB

    Locking Options in Excel

    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.
  3. RonMB

    Excel "Goal Seek" Not Converging

    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?
  4. RonMB

    Tractor-Trailer Turning Radius

    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.
  5. RonMB

    Lost Graphics in Excel

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

    Lost Graphics in Excel

    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.
  7. RonMB

    Allowable Compressive Stress on a Stiffened Cylinder

    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...
  8. RonMB

    Buckling of Stringer Stiffened Cylinder

    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
  9. RonMB

    Buckling of Stringer Stiffened Cylinder

    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...
  10. RonMB

    Interpolation of semi-log paper

    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.
  11. RonMB

    Interpolation of semi-log paper

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

    1% Proof Strength of Stainless Steel

    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...
  13. RonMB

    Macro For Goal Seek?

    Thanks for all your help!
  14. RonMB

    Macro For Goal Seek?

    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
  15. RonMB

    Macro For Goal Seek?

    It does it fine! Thanks a bunch!
  16. RonMB

    Macro For Goal Seek?

    I did try using the recorder but I was hoping to be able to obtain the goal from a cell also. Is that part not possible?
  17. RonMB

    Macro For Goal Seek?

    I frequently run "Goal Seek" under the Tools menu with little or no change to the dialog box entries. Is there a way to use data from cell entries to eliminate re-keying the same data.
  18. RonMB

    Macro Buttons Outside of Workspace

    Thanks for all input. The Plawrence approach works best so far although I can only get the text laid out to be read from the left side of the screen. While I see you can create a small icon by editing, I have not found a way to either format the text or use a larger graphic. To melone: I...
  19. RonMB

    Macro Buttons Outside of Workspace

    I seem to remember seeing an Excel spreadsheet where there were macro buttons to the left of the row numbers. I have now tried to find such a setting or function without success. Anyone familiar with such things?
  20. RonMB

    Too many different cell formats - Excel

    I posted the earlier replay too hastily. Upon trying it, it fails miserably. If it gives anyone else an idea,, good luck. Sorry!

Part and Inventory Search

Back
Top