Search results for query: *

I'll re post if I find anything of use, I think some hand calcs will be best, who knows maybe I'll get bored and build a model! Thanks again guys. Nick

Hi Mike, Thank you for your reply. I have just had a look through apx 1-6 and yes you are right in that we have as per fig (d). In this case we are dealing with an existing piece of equipment and wanted to calculate the maximum bolt load we could apply to the joint. In reality it is likely...

Hi all, Can anyone point me in the right direction for assessing moment loads on a dished/ellipsoidal end, such as over rotation of the dished end flange due to excessive bolt load? (in this case for a floating head heat exchanger) Can you use ASME VIII flange design calcs and if so how does...

Hi, I had not changed the next node to be starting from 601 and it was still connected to 60. This appears to have been the problem. Cheers, Nick

Hi Guys, I am modelling a section of pipework that is connected to a nozzle on a heat exchanger vessel with the aim of checking nozzle loads with and without a spring hanger. In order to account for the thermal expansion of the vessel I have modelled the exchanger as rigid elements fixed to an...

Hi guys, Weldstan yes I believe these sort of checks will be done as part of the planned inspection regime in anycase. DSB123 yes I believe you are right and this is currently what I am doing using S. Using S must, I think, assume that there is no damage pre existing. The verification is I...

Hi DSB123 thank you for your reply, Yes another typo apologies its ASME B31.3 I’m just used to typing BS a lot of the time. Your approach to fatigue is part of what I was asking about. In my assessment by displacement stress I mean that I have included wellhead movements at the end of the...

Not sure if this is closed but just a few general points. The seating width calculations I believe were derived experimentally based on testing done on rubber gaskets a long time ago and are not necessarily the best way to design newer gaskets as kammprofiles for example won’t rotate or deform...

Thanks for the advice Weldstan, its good to hear you have had some experience with this material at LT. You are correct in assuming this would be a temporary deviation from the norm although could go on for extended periods of time depending on how the well is flowing. I beleive the method you...

Hi Weldstan thanks for the reply. Sorry -36deg is the design temp thats a typo I'll change this additionally: Unfortunatley we no longer have acess to the fabrication records or materials certs and so I cannot be sure of the exact material properties. I contacted the supplier of the manifold...

Hi everyone, thanks for taking the time to read this thread. Background: Production manifold produced Circa 1990 by hot isostatic press method and welding sections together. Certified to B 31.3 as opposed to a pressure vessel code. Material S31803. Op temp -36deg and charpy testing would have...

Hi Cowski, I am also on excel 2010 just checked and yes in the actual Cell it reads correct as: <ProjectInput xmlns="http://tempuri.org/ProjectInput.xsd"> somehow when exporting my worksheet as a text file its adding extra " marks ? The relvant code for exporting the worksheet is essentially...

Hi Alin 09, I presume you mean that the file is too large to be read as a single string into a single cell in excel? Assuming the text file is in distinct lines I would just write some code along the lines of: Open file Make a loop that runs until EOF and has a counter i that increments...

Hi Guys thanks for the responses, I tried using Cells (1,1) = "<ProjectInput xmlns=""http://tempuri.org/ProjectInput.xsd"">" and as you say "" is essentially saying " as text so I would expect to yield <ProjectInput xmlns="http://tempuri.org/ProjectInput.xsd"> but it outputted "<ProjectInput...

Hi IRstuff, yeah I know its strange I dont understand why its putting in extra quotation marks (especially at the front?) when I program it in the VBA :S I really dont want to go through and manually change hundereds of files! Cheers Nick

Hi CajunCenturion thanks for the quick reply! yes Chr(39) works fine and Cells(1, 1).Value = "<ProjectInput xmlns=" & Chr(39) & "http://tempuri.org/ProjectInput.xsd" & Chr(39) & ">" gives <ProjectInput xmlns='http://tempuri.org/ProjectInput.xsd'> So I dont see why Chr(34) does not work...

Hi guys, So this is driving me insane I have a macro which is exporting to a text file and I need the first line to be: <ProjectInput xmlns="http://tempuri.org/ProjectInput.xsd"> I have tried the following codes with the following responses: As expected Cells(1, 1).Value = "<ProjectInput...

Ok I managed to get it working how I wanted in the first place. For those interested the Excel with code is attached or see below: Sub test() Dim i As Integer Worksheets("Sheet1").Activate For i = 3 To 6 Step 1 If InStr(1, Worksheets("Sheet1").Cells(i, 3).Value, "Channel", 0) <> 0 Then...

Hi everyone, Thank you so much for your help, I managed to sort this by just using two blocks of code as opposed to one thanks to your tips. Essentially I just set one check to ascertain my first variable and assign a value. Then in a second seperate loop/piece of code checked the other value...

In the excel file it should read check the value in column I not U (sorry typo)