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