Search results for query: *

Oh, never mind!! I've cracked it!

Hey guys. I have a list of 6 different calculated values which can all vary depending on the inputs. From this point in the sheet the maximum value must be used with the others becoming redundant. How do I write in code to selesct the maximum value to use from there on out? Cheers

Cheers man, the AND works

Hey guys, I'm using if statements to specify what is happening. There are two different conditions that must be completed in order to return a value. I want to say if...AND..., alas, I don't know how to do this in mathcad. The mathcad sheet is attached illustrating what I'm trying to do. Can...

Hey guys, I've got a Sub-routine that filters a table and performs a lookup selecting the appropriate data. The Sub-routine was originally a function, yet the function was not working correctly. My question is, why does the code run correctly when it is a sub-routine and not a function...

Here is a worksheet lifted straight out of the program being used. The affected cell is F13. This is the one that uses the function. The function is defined in the ASME_Lookup Module in VBA.http://files.engineering.com/getfile.aspx?folder=74ea21b5-be7d-440b-b388-ab1f813edb9f&file=PD8010_Test.xls

Cheers, I'll get on that. Sorry, still getting used to the forums

Hey guys, I've found an reeor in a program that i've been using, yet I'm struggling to fix it. The code is given below. The function essentially filters data within another sheet (containing ASME standard pipesizes) and gives the next size value of wall thickness. When a value for...

Thanks guys. As always, very helpful. The pipeline would initially contain water for the hydrotest of the pipe and eventually gontain oil or gas. The submergred weight is needed for a design tool that calculates the wall thickness required. During the analysis of the desired WT, the...

Hey guys, I'm trying to find the submerged weight of a pipeline and need to include the internal coating, the anti corrosion coating, the insulation and concrete coating. Does anyone have an equation for this please? Cheers

Occupant, Do you have the file you have used? Could you post it please?

I didn't realise I'd missed the units for E and sigma.y, my bad. The units are MPa. 5.16mm is extremely close to the desired answer, a hell of a lot closer than I had been getting. Just to clarify, is Minerr a pre-built in function to Mathcad? Thanks for all the help guys

Hey guys, sorry, I didn't lose interest in this post, but I've been away for the bank holiday weekend. I'm just looking through everything now and will reply properly shortly.

To IRstuff: I haven't altered the equation at all though, it's pulled straight out of a DNV document, so you would have thought they'd balance?!?! In the document you've presented, t_nom is still undefined earlier in the equation, and Find(t_nom) is also undefined, how do I solve this? I...

Here is the workbook in version 11.http://files.engineering.com/getfile.aspx?folder=a90f2bd7-845a-4d0b-957c-9e41250ffb13&file=Collapse.mcd

Hey guys, I'm relatively new to mathcad and have hit a wall. All the data needed is attached to this message. The formulae are lifted straight out of DNV-OS-F101 for the Local Buckling - Collapse of off shore Pipelines. The Problem is that the data provided must be used to find a value of...

By we I meant me and the team I'm working with. In the end, a missing document was discovered that illustrated the procedure for using the equation. The procedure was the same as in the original version, making everything I had been doing with the equation I posted meaningless. Was a fun...

Got it all sorted now guys. What with being a newbie at this company, I hadn't been informed of some other procedures. So finally (2 weeks in!!) the solution has been made available to me. We all have egg on our faces. But cheers anyway!

I've made a bit of progress. The job I'm doing is essentially updating an old design tool that uses old formulae to find the value of Pc and loops an increase in the nominal thickness until Pc is greater than the external pressure. This is how my model works, in the same way yet with different...

But if you rearrange the equation (which is LENGTHY) you can get a quadratic with Pc as the subject. There is only 1 real solution to the equation, which then means that the correct thickness can be found. Its being programmed in VBA on Excel, so a different function has to be made to...