Continue to Site

Eng-Tips is the largest engineering community on the Internet

Intelligent Work Forums for Engineering Professionals

  • Congratulations waross 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 TomSD

  1. TomSD

    Assign functions to categories

    Hi Mutt Thought so. I have also seen posts that the method won't work as Excel4 macro functions are no longer supported and already some (e.g. Call, RegisterID) aren't allowed to work at all already due to security issues; the REGISTER function still works in the latest Excel version on XP but...
  2. TomSD

    Assign functions to categories

    Joerd & Mutt; I got excited about Longre's method some time ago but most of my documentation is at home. Laurent Longre posted this work-around method for adding descriptions of arguments for VBA user-defined functions (UDF's) in Excel, and this method simultaneously allows the user-defined...
  3. TomSD

    Information about chelant resins

    Anderson Water Systems in Dundas, Ontario design/build good value ion exchange systems using all resin types. [wavey2]
  4. TomSD

    HAZOP/HAZID Course

    joisy You should contact Ellis Knowlton: ellisknowlton@npsnet.com Ellis has been involved with the development of HAZOP since 1967, was founding leader of CMA task group on process safety, launched HAZOP training in many countries (e.g. India - post Bhopal), etc. He has trained thousands of...
  5. TomSD

    Custom connection sites on a Shape object with text

    I should have read your first post a little better to see that you have already done the freeform. oops
  6. TomSD

    Custom connection sites on a Shape object with text

    Sounds like you are using standard object shapes which I believe have eight if circular and usually four connection points if rectilinear. On the Drawing Toolbar click -> Autoshapes -> Lines -> Freeform and create a custom shape with as many vertices (points) as you want for connection sites...
  7. TomSD

    eturn data value and manually key in measured units in the same cell

    mgp is right but you can make a custom format that includes your units as text with the number; e.g. - select cell - click on Format, then Cells "Format Cells" dialogue/palette comes up - select "Number" tab Intially cells are usually "General" format - choose...
  8. TomSD

    Another CO2 question

    Hi setra; Activated carbon absorbs many, many things so the use of this material to remove CO2 is not too surprising. There experts who do much more work in this field than I have ever done and thus have better idea of what to expect, but I'm sure they would agree that only bench scale testing...
  9. TomSD

    Another CO2 question

    I'm not an expert in the CO2 separation processes using amine based absorption solutions but I am curious about the fertilization methodology. I have heard of waste heat from large boiler/power installations being used for greenhouses located close by. I also recall reading of the use of CO2...
  10. TomSD

    Cola behaves differently in various bottle sizes ???

    Gag reflex, depending upon your constitution? Biochemistry is not my field, forgotten a lot of organic chemistry as well. Might guess that carbonates, if any, e.g. calcium carbonate in milk would react with acids to release CO2 gas, may push liquid up, reflex takes over. But would also be a...
  11. TomSD

    Cola behaves differently in various bottle sizes ???

    I think you're right, azg. Milk is mainly an emulsion where most of the "fat" components aren't actually dissolved but stay dispersed for a long time throughout the solution because they are so finely divided, especially after homogenization. The tiny particles of fat would provide...
  12. TomSD

    Cola behaves differently in various bottle sizes ???

    Sorry about any rambling or hasty generalizations, azg. You seem to have covered the important factors of fizzing on ice, i.e. increased area which not only increase air-liquid contact but also allows for more nucleation sites. So according to the logic, there should be more fizzing if the ice...
  13. TomSD

    Cola behaves differently in various bottle sizes ???

    Can't help it! Have to add my two cents, pedantically. Hint: How do we spell "SUPERSATURATION"? How about "NUCLEATION SITES"? No matter how the CO2 is added to a soft drink, it is obvious that there is more CO2 in a soft drink than would be in equilibrium with the small...
  14. TomSD

    How can I rotate text boxes in Excel?

    I avoid editing any picture (created in another application) brought into Word because too many things change. However, my Word version is getting a bit old, perhaps later Office versions have better integrated graphics between applications. Regards
  15. TomSD

    How can I rotate text boxes in Excel?

    Cdoug3, I think this is what you want. I do it in a similar manner to that mentioned by pmover. The following instructions are a bit pedantic. I am presuming X-Y charts, haven't checked for the other types. 1) Select a single data point in the curve; usually have to left click a couple of times...

Part and Inventory Search