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