Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations cowski on being selected by the Eng-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by maloneb

  1. maloneb

    Selecting a maximum value from a series of values

    Oh, never mind!! I've cracked it!
  2. maloneb

    Selecting a maximum value from a series of values

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

    Trying to find a way to use an AND statement

    Cheers man, the AND works
  4. maloneb

    Trying to find a way to use an AND statement

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

    Using a Sub instead of a Function

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

    Error Catcher

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

    Error Catcher

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

    Error Catcher

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

    Submerged Pipeline weight

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

    Submerged Pipeline weight

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

    Finding a Variable through iterating. This one is killing me!

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

    Finding a Variable through iterating. This one is killing me!

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

    Finding a Variable through iterating. This one is killing me!

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

    Finding a Variable through iterating. This one is killing me!

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

    Finding a Variable through iterating. This one is killing me!

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

Part and Inventory Search

Back
Top