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: *

  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
  16. InspEngr

    Filtering out non number values

    The syntax I had to use to make Aviat's (excellent) suggestion work is {=AVERAGE(IF(ISNUMBER(E1:E6),E1:E6,""))} The brackets {} indicate the array formula when you type (CTRL+SHIFT+ENTER) Keep in mind that if you put a zero (0) at the end of the IF portion, that zero is averaged into the...
  17. InspEngr

    Entry Level Civil Engineer

    Regardless of your track (we called it our "Major"), there are other venues that folks don't often think about. For instance, Civils are often hired at petrochemical plants as project and/or design engineers. Think of all those foundations and structures holding up all those large vessels...
  18. InspEngr

    Radiography before/after PWHT

    Thanks metengr, At our refinery, we "require" the RT to be done after PWHT. If an RT is done prior, it is at the contractors expense. Most contractors we've worked with will shoot RT prior because, as you alluded, they don't want to get bit and have to perform a repair and then re-PWHT. From...
  19. InspEngr

    Radiography before/after PWHT

    I've briefly looked in B31.1 and Section I and I think the answer is no; however, I'm going to ask just in case. For P1 material (drums and tubes) where PWHT is being performed, is the requisite RT required to be performed after PWHT? In my opinion, RT should be performed prior to PWHT for...
  20. InspEngr

    Look up Table Based on Data in More Than One Column

    Use the "DGET" function. For everything below I'll use the "database" exactly as you've set it up in your post with "Column A" being in cell A1 and the number 6 being in cell C5. Copy the headings (only) into another section of the spreadsheet (must be exact). You actually only need "Column...

Part and Inventory Search

Back
Top