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 MintJulep on being selected by the Eng-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: Jkaen
  • Content: Threads
  • Order by date
  1. Jkaen

    Column lookup based on cell content

    Hi all, I am stuck trying to implement a function into excel. The part I am stuck on is using a lookup based on a cells content. I assume I want some use of the indirect function but cant quite make it to work. The main issue I have is if the cell content of f2 is 1, I want to lookup D5:D31...
  2. Jkaen

    Drag Formula to increment worksheet

    Hi all, I have a tracking spreadsheet set up to track various procurement activities with each package as a separate worksheet. I then have an index page with hyperlinks to the individual worksheets for summary purposes. What I want alongside these links is to pull up various data from the...
  3. Jkaen

    API 5CT tubing as pipeline

    Hi all, We have been asked by a client to use existing API 5CT tubing (5", L80 GRE lined, threaded ends) as pipeline material for a water injection network. I can't see anything in ASME B31.4 stopping us from using this material, but we are a bit stuck on how to handle branches off the main...
  4. Jkaen

    Conditional Grouping Data from Table

    Hi all, I am trying to group a bunch of text from column B of a table based upon an numerical value in column A of the table. I want the various qualifying text then all grouped (CONCATENATE I assume) in a second table I have attached a mock example of what I am after with random text in to...
  5. Jkaen

    Sum multiple lookup table across worksheets

    Hey all, hope you can help me. I am trying to get a framework contract tracking software sorted and have call in excel to try to obtain data from across various worksheets (circa 60) The formula I am using for a single worksheet is: {=INDEX('Sheet 2'!A8:I9,MATCH(A7&C7,'Sheet 2'!D8:D9&'Sheet...
  6. Jkaen

    Printing Multiple worksheets in Excel

    Hi guys quick question for you. Most of the spreadsheets I work with a multiple sheets, I tend to print out all these sheets at once by selecting all the tabs and hitting print. The problem comes with making pdf files, where many of my spreadsheets will try to seperate out. For example a 5...
  7. Jkaen

    LEL of Ethylene Oxide in CO2

    Hi Guys, I have read this thread http://www.eng-tips.com/viewthread.cfm?qid=33615 And while it helps in general terms with diluted hydrocarbons I am struggling to apply it to Ethylene Oxide (LEL 3%, UEL 100%) It is my thinking from a pure common sense viewpoint that as EO produces its own...
  8. Jkaen

    Missing chemical information

    Hi guys, I have posted a thread on the aspen forum (http://www.eng-tips.com/viewthread.cfm?qid=148041&page=1) but as it seems rarely used I thought I would post here in a slightly reworded form. Main problem is I am trying to model a reaction with various chemical streams, but dont have...
  9. Jkaen

    Additional components

    Hi guys another plea for help here. Currently using Aspen Plus version 11.1 and keep running into problems with components not included in the databanks, normally we can just use similar components, however in this case (2-iodoethanol) We can't even find anything similar, nor can I on the web...
  10. Jkaen

    Auto starting a spreadsheet based on date

    Wonder if you guys can help, not exactly a spreadsheet question, but couldnt find the right forum for it. Currently I have a stock take type spreadsheet I need to run a script in at the start of every month. at the moment I have the spreadsheet starting up each morning when the user turns the...
  11. Jkaen

    Re-using spreadsheets

    Hi guys hope you can help with a problem I have: I have a number of spreadhseets written for various products / design conditions, some of them (i.e. pricing, sizing spreadsheets) I have worked into single sheet pages I put into the more complex spreadsheets and act almost as standalone...
  12. Jkaen

    Paper Stock apparent viscosities

    Hi all, I was hoping you could help me with a problem we have, we have recieved an enquiry for processing paper stock, and while we have empirical data up to 6% consistency this customer has 12% consistancy stock and I am struggling to find any data that will allow me to calculate pressure drops...
  13. Jkaen

    Change of Oxygen solubility in water

    Hi guys wonder if you can help me, I have a client who wants 20mg/l oxygen dissolved into a fish lake. now in the pipe based on partial pressures I can easily acheive that with pure oxygen, however my worry is that when this rich stream is introduced into the lake (its not a great volume maybe...
  14. Jkaen

    Mixing text and cell references

    Greetings all, I have a problem I hope you can help me with. I am trying to write the output page for a design spreadsheet and want to show results of previous choices in a sentence form i.e. "Pipe of" C3 "mm diameter, of total length " C7 "mm So far the only ways i can think of doing this is...
  15. Jkaen

    Spray cooling

    I have tried to do a search on these forums and have found nothing, but it may be i am using the wrong keyword, if that is the case please direct me to the correct thread. That said I am looking for equations for calculating the length of time it takes for sprayed droplets to evaporate into a...
  16. Jkaen

    Conditional formatting based on another cell

    Using search it seems that there isnt a way to do this, but people seem to find very clever ways of getting round the problem, so maybe you can help here. I have made some design spreadsheets for our company that have to be used in the states as well and therefore I have built unit conversion...
  17. Jkaen

    Goalseeking to a minimum vlaue

    Wonder if you could all help. I have a spreadsheet working at the moment which i want to run a goalseek on, problem is I dont know the value i want, it just want the minimum for a given range of X. I can think of a very messy way of doing this using loops and if statements,and changing the x...
  18. Jkaen

    Headloss due to single tube

    Greetings all, I am trying to calculate the headloss resulting from a single tube (about 1" for example) when placed into a larger diameter water pipe (24" for example). I can find equations for tube banks in literature but all state they are not valid for single tubes, can anybody...

Part and Inventory Search

Back
Top