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 TugboatEng 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 mgp

  1. mgp

    Din Metric Flanges

    DIN 2636 no longer exist European standard EN 1092-1 contains dimensions for all PN designated flanges Available at www.beuth.de Regards Mogens
  2. mgp

    Delete Sheet in excel

    Thanks BurattoN Works perfect Regards Mogens
  3. mgp

    Delete Sheet in excel

    I'm trying to write a code to copy a worksheet, do something and then delete it. Problem is I get this prompt before the sheet is deleted: "Data may exist in the sheet(s) selected for deletion.To permanently delete the data, press delete." How do I get my code to avoid that prompt or...
  4. mgp

    AD Merkblatt S2

    You can buy it from here: http://www.beuth.de/index_en.php No standards are for free regards Mogens
  5. mgp

    Alexander Keilland

    Try this link http://alpha.lib.uwo.ca:5701/search/dAccidents+--+Ontario+--+Statistics./daccidents+ontario+statistics/-5,-1,0,B/frameset&FF=daccidents+offshore+oil+well+drilling+north+sea&1,1, If you cant get the document from there you may find enough information to search for it somewhere...
  6. mgp

    Overview of ASME

    Try the Casti guidebook series. http://www.casti.ca/books.html There is even a free downloadable "light" version of some of these books, e.g. http://www.casti.ca/books_ebooks/lite/section_VIII_lite.pdf regards Mogens
  7. mgp

    Energy Calculation in a Pressurized Pipeline

    Try this thread: Thread794-26767 Regards Mogens
  8. mgp

    Entering arrays in a single cell

    Thanks folks I figured I might have to use a "text separating" formula or function to make it work. As IRStuff questioned - I don't HAVE to have it all in one cell but I just think it makes a neater spreadsheet in this case as I already have a lot of columns in there. My spreadsheet is for...
  9. mgp

    Passive fire Protection

    I'm not an expert on this but the purpose of passive fire and explosion protection in wellhead areas and other areas on an offshore platform is to ensure maximum possibilities for evacuating personnel from the area, and to minimise escalation of the accident (platform collapse etc) I think the...
  10. mgp

    Hydrotest vs. Testing with Air

    There was a thread about equivalent energy from a gas contained vessel which might be of interest: thread794-26767 Regards Mogens
  11. mgp

    Entering arrays in a single cell

    Is it possible to enter a serie of numbers - comma separated - in one cell and then use this "string" as an array in another formula? For example: In cell A1 I enter 1,0,0,1,1,1,0 In cell B1 I enter =sum(A1) and the result should have been 4. I know this doesn't work, but the question is is...
  12. mgp

    Hydrotest vs. Testing with Air

    I agree with moltenmetal and others that a hydrotest should always be preferred unless there are good reasons not to do so - there may well be. In 1995 there was an incident in a british construction yard where three workers were killed during a nitrogen pressure test. Here's the story as I...
  13. mgp

    QUICK OVERVIEW

    Try this http://api-ep.api.org/filelibrary/Catalog_web.pdf regards Mogens
  14. mgp

    How to draw?

    Alshaiji Try to download the "Beams" file from http://www.mxl.dk/Download%20Files/Sampleexcel.htm There's a neat little pump arrangement also in one of the other files. These are just a couple of samples. I think you will find that they can be made to look quite ok with a little effort...
  15. mgp

    Wait messages for Excel

    Have your macro to include a progress indicator. I haven't tried myself but there are several tips out there if you search for them, e.g. http://www.j-walk.com/ss/excel/tips/tip34.htm http://www.cpearson.com/excel/Progress.htm Hope this helps Regards Mogens
See more

Part and Inventory Search

Back
Top