Eng-Tips is the largest engineering community on the Internet

Intelligent Work Forums for Engineering Professionals

Search results for query: *

  1. TomBarsh

    Mexico City subway overpass collapses, killing at least 23 and injuring dozens

    This forum was my first stop for information (after news articles). I watched the security camera video a number of times. My first fleeting impression is that the failure occurred at mid-span of a simply supported beam, rather than at the end connections. I'll be interested in following this...
  2. TomBarsh

    Excel calculation mode - VBA concise and verbose statements

    I recently was befuddled with some VBA code and had to sort things out. The statement to change the application's calculation mode is: Application.Calculation = [something] I've always used (well, for 20 years or more?) the "somethings" as: = xlCalculationAutomatic =...
  3. TomBarsh

    Lifting Lug with Shell Corrosion (Codeware COMPRESS)

    If I recall correctly, COMPRESS performs calculations for the support lugs (and local stress in the shell) for a number of different conditions, including new versus corroded, empty versus operating, with wind or seismic, etc. As far as COMPRESS forcing a (nominal) thickness greater than your...
  4. TomBarsh

    Drafting Machine Components

    RPMG - I seem to recall a red plastic toggle control on the Mutoh, sort of with two short arms at 120°, almost like a bell crank? I seem to remember operating that a number of times a day. But this was around 1972 and further details escape me. sorry.
  5. TomBarsh

    Drafting Machine Components

    wow, this brings back memories of my early first career. "on the board" those early days of visualizing in 3-D, and doing lots and lots of trig, really paid off later in my engineering career. I actually used one of those Mutoh track machines. After using the Vemco arm machines.
  6. TomBarsh

    Time flies! Clock face falls from crane, strikes two workers - No injuries?

    I just watched the video and feel guilty now for making light (above) of the situation for the two workers. It took me several times viewing (projected on my large television screen) to finally comprehend that there was that bucket lift with some workers on it, below the lifting crane. You can...
  7. TomBarsh

    Elevator at John Hancock Center in Chicago

    John Hancock Center is one of the tallest buildings in Chicago (okay, I guess its name was officially changed earlier this year). One of the express elevators to the restaurants and observation level at the top of the building experienced broken cable(s) this week. A number of news articles...
  8. TomBarsh

    Excel: Missing embedded images ?

    By the way, this problem is a known issue with Office applications. I had found a number of discussions about this. For example, here is discussion from Microsoft's Office support (discussing PowerPoint in this case)...
  9. TomBarsh

    Excel: Missing embedded images ?

    Thank you both for the comments/direction. I am able to locate embedded images in the xml files (or their names). Funny thing is that the images that are "lost" then do not show up in the xml files. So they do seem to be permanently lost. I don't think this has happened exclusively with files...
  10. TomBarsh

    Excel: Missing embedded images ?

    On occasion I open a workbook and where I had previously pasted an image of something, instead there is a 'box' placeholder with a 'red X' in the top left, and the caption "The image part with relationship ID rID1 [the digit may vary] was not found in the file". This is worrisome as the...
  11. TomBarsh

    MAWP CLARIFICATION

    Sounds like the vessel manufacturer has met (likely) the requirements of ASME Code. But they haven't met the commercial requirements of the purchase specification. You can ask the manufacturer "How do you address this Clause in the Specification?" And you can ask your client "Well, what are you...
  12. TomBarsh

    Excel AutoCorrect ?

    Thanks Doug. My reluctance is based on not wanting to disable things in an inappropriate way, until I have (mostly) mastered the art ...I have followed the opposite approach too many times in my life and sometimes it's irreversible(!). I knew that I could remove that word pair but I thought...
  13. TomBarsh

    Excel AutoCorrect ?

    Thanks! JG
  14. TomBarsh

    Excel AutoCorrect ?

    Yep, I have tried numerous options in that dialog, and also by using the Exceptions button on that dialog. So far, nothing has worked...except to remove that word pair form the list.
  15. TomBarsh

    Excel AutoCorrect ?

    So I am documenting my investigation of "Health Savings Accounts" in the USA, commonly referred to as "HSA" Excel keeps regularly and willfully changing my typing HSA to HAS. I don't understand why. The AutoCorrect settings are set to "Ignore words in UPPERCASE". Plus I capitulated and added...
  16. TomBarsh

    Gravitational Constant in Excel Formula

    This is an important point. I work a lot with the ASME pressure vessel code and there are a lot of assumptions in it based on being on Earth with atmospheric pressure and all. I hope designers take this into account when designing pressure vessels for use on extraterrestrial human habitations; I...
  17. TomBarsh

    Gravitational Constant in Excel Formula

    Another method, that I read about in some Excel book years ago and which I use on occasion, is that the defined name (call it a Constant) can be defined in the Name Manager itself without any external reference to a cell or range. For example, open the Name Manager and define the new name...
Back
Top