Recent content by Statesman

Yes, Regarding the material certificates. I remember in the old days when it was the pipe you forged, not the Certs ;o))))

We currently have a number of wellheads where we have the choke valve directly onto the wing valve of the tree assembly. Presently the scale/corossion inhibitor is injected downstream of the choke valves. Ops/Process have had a 'brainwave' and decided that in order to protect the choke valves...

Some good points made guys. I tried the custom footer, but this is very very basic and doesnt really allow the kind of title bock Im after. The Access route may be one which we will have to investigate if I cant get Excel working (we prefer to keep as much info as possible as most people in our...

Hi, Looking for some help with printing in Excel. We currently have a database of line conditions (in Excel format)It maybe over 400-500 lines.It is an ideal format for us just now as we are developing the job our process department can add lines to this whenever. However, at the end of the job...

Im really looking to use something similar to the following :- Private Sub Worksheet_Activate() Load UserForm1 UserForm1.Show End Sub However, when Excel loads up, with this worksheet open, the userform doesnt activate, until you go away from this worksheet, and then go back into it. Is there...

When i look to HELP on Auto_open. There is nothing regarding it. Are you maybe thinking Im using the full VB programme ? I only have VBA which is included in Excel ?

I have written a VBA application for Excel, which involves the user filling in a form. Is there a simple way to have this form load up automatically when the workbook is opened ? At the moment Im thinking of using a button with a macro attached to it, but would obviously prefer if the form came...

I am looking at a requirement we have, possibly for a tube in tube coil heater, for a closed lube oil system we have. (To be cooled by water). We looked at sizing a shell & tube using typical design values of U from Perrys Chem Handbook of approx 30-50 BTU/°F ft² h. Which gave us a decent sized...

Thanks Austim, That method worked a treat.

How would I conditionally format a cell based on the values of two other cells ? i.e One cell has the following formula =IF(D45>45,1,0) and another cell has the formula =if (D45<=D32,1,0) How can I get a cell,say, D46 to go green and have the word &quot;Calculation Correct&quot; based on the...

Thanks for your comments but, as stated in the original post, we dont have enough information to work out the k values for each of the branches and as the plant is over 300 miles away, it isnt easy to measure the branch flows,or the pressure in the line. We require this information for a 'first...

Gents, At present we are working on an older plant with very little PID Information. We have two pumps, each with the following duty (Design Rate 387 m^3/Hr Head:90M of water (8.82 bar)) They are connected in parallel, with only one pump running at a time (second as standby). They discharge to...

Hello Gents, We are replacing a water injection spool directly from HP pump outlet. (Fluid:Water, Flow: 700 M^3/H, Diff Head:737M Outlet size 8&quot;) When we have removed the Existing 1500# Rated spool (LTCS Astm A333-6 SMLS) we have found that the RF Flange that mates to the outlet of the...

Hello, In Project how do you attach resources to a task ? Example: One of my tasks involves draughting and checking. If I have the one task (Draughting of component) which will take 15 man-days draughting and 4 days Engineering checking. How do I assign those to it ? If I want to add more than...

In the North Sea, Shell still use CuNi for Seawater systems. Another alternative is to use GRP