Continue to Site

Eng-Tips is the largest engineering community on the Internet

Intelligent Work Forums for Engineering Professionals

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

Recent content by InspEngr

  1. InspEngr

    API 2201 Hot Tapping

    API 2201 is the recommended practice for hot tapping. ASME B31 essentially has nothing to do with hot tapping as it's a new construction code. The piping (such as a saddle-on connection) or the special hot tap equipment (such as a split tee) might be designed to B31.x but API 2201 would be...
  2. InspEngr

    ASME Inlet PSV Pressure Drop-3% Minimum Question

    As I recall, the pressure drop is to be calculated at the PRV inlet. In other words, it does not matter how long the inlet piping is or what the geometry looks like, you have to calculate what the pressure drop will be when the PRV opens. This means you must add up the cumulative pressure...
  3. InspEngr

    CO2 CORROSION EVALUATION WITH API 581

    I cannot answer why it was not included in the current version (although I would guess it had to do with prioritization of resources available to work on the various modules), but I do know there is work on a CO2 Corrosion module for future release. Both the Base Resource Document (API-581) and...
  4. InspEngr

    Survey (inspection?) of sulphuric acid delivery lines

    Our sulphuric acid varies from ~98% down to ~89% and we employ both RT and UT (along with visual). My recommendation is much like Unclesyd's. Since you have relatively small bore piping I would suggest RT, especially at areas of turbulence (bends, reducers, tees, etc). I would also get a shot...
  5. InspEngr

    Conditional Formatting - Contains a Value??

    Along the lines of MintJuleps suggestion... If all you need to know is whether or not the cell contains anything (text, number, formula) or if it is blank, then use the "formula is" option and type in the following formula: =IF(ISBLANK(A1)=TRUE,FALSE(),TRUE()) InspEngr
  6. InspEngr

    Reference Books

    Just an fyi... The Crane Technical Paper 410 is available through Crane Valve here: http://www.cranevalve.com/tech.htm I am not affiliated with Crane in any way. Just knew it was available ($36) in both English and Metric versions. -InspEngr
  7. InspEngr

    Converting Time to Whole Numbers in Excel

    Here's another way, again presuming the time is located in cell A1: =HOUR(A1)+MINUTE(A1)/60 As KenBolen mentioned in his solution, the format must be set to "Number". -InspEngr
  8. InspEngr

    Steel Grade A-70 Clarification?

    I'm looking at the 1943 API-ASME code and get different values than metengr reported. I believe the reason would be that API & ASME used to work together for the pressure vessel code (we also have a 1934, First Edition, API-ASME code). At some point they split. I had heard that the API-ASME...
  9. InspEngr

    Manipulating Weather data again...

    Presuming this is an excel file, I know exactly how to do this. You need to use the Database functions. To make sure I still knew how to do this (it's been yearssince I did something similar) I set up a quick database. Too much to try and explain. If you could leave an email address I'd be...
  10. InspEngr

    Carriage Return

    Should have mentioned... If you make a mistake in entering data, you can shift-tab to go backwards to the previous cell(s) in the highlighted group. -InspEngr
  11. InspEngr

    Carriage Return

    Here's one method: Highlight the cells into which you wish to enter data. Then simply use the tab key after you've entered the data into a cell. The tab key moves the focus to the cell on the immediate right. When the focus is in the far right cell (of the highlighted cells), the tab key...
  12. InspEngr

    Excel Worksheets.Add

    Has Excel possibly been recently re-installed? Each time a machine is "re-imaged" (or a new machine is installed) at work, we have to install a couple of the add-ins to get some of our regularly-used functions to work (such as "EDATE" in the Analysis ToolPak). Looking at the ToolPaks available...
  13. InspEngr

    Steam Rings on flanged joints

    We've also had flange leaks at the locations mentioned, as well as various other flanges in similar (high heat) systems. One of the problems is believed to be the relaxation of the bolts due to thermal cycling (startup/shutdown, rain, etc). We now specify Bellville washers in these...
  14. InspEngr

    Excel Phone Number Hyphen Insertion

    Highlight the cells then use the following menu commands: Format-Cell-Number(tab)-Custom Type ###-###-#### into the "Type" box. -InspEngr
  15. InspEngr

    What is the best engineering advice you ever received?

    Don't burn bridges. You never know if the company you're leaving today (hopefully for better pay/advancement) is the company you may want (or need) to work for tomorrow. -InspEngr

Part and Inventory Search