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