Hi Folks,
I need a bit of help on using named ranges for data validation lists.
The sample excel file has a snip of what I have. generally the layout cannot change from what I have (not what is in file)
Summary of what I have done so far:
1. I have a list of multiple disciplines, which have...
Hey fellow geniuses,
Just wondering if there is a way to rank in alphabetical order, a list of names but only if a value in an adjacent cell is greater than 1?
On the attached worksheet, I would like to rank the names that have a value in row B greater than one, while ignoring the names that...
Hi All,
I have searched far and wide for answers to this, and there are some that are close, but none that suits my specific needs.
I have a workbook with over 100 sheets, each named, and not in order (ie sheet 10 could be the 30th sheet). On the first sheet called "Trade List", I have all teh...
Hi All,
Can anyone advise why 316ss shouldn't be used for pressure vessels dor a domestic water system. We have a contractor stating it must be 2205 but will not/can not substantiate this (other than 2205 will cost more - more for them).
Thanks,
I have a spreadsheet for a snooker league I am trying to correct (in particular finding the maxium breaks and name of person) for each week (up to 7 matches a week for around 14 weeks at the moment).
I have attached a sample sheet here, if anyone can let me know what formula I need to put in...
Hi All,
I am trying to get a value from a list, based on it's ranking. I need to get the cell value from the cell directly above the value gained from the Large function.
I have tried using OFFSET(LARGE($B$5:$AO$5,1),-1,0,1,1), but get an error (it appears the Large function cannot be used as...
Hi All,
Just wondering (as I am about to embark on creating a spreadsheet for horizonatl vessel supports using the above), if anyone can advise if all the factors used in zick's methods, can be used direct with metric figures, or will I need to conert to imperial to use these factors, then back...
Hi,
This will no doubt be very simple for many, but I have no used charts for a very long time, and after a play, I cannot see how I can do wht I need.
I am trying to re-create the garph as attached in excel, but cannot see how to obtain a vertical line and horizontal line within the same...
Hi,
I am invilved with a project that had a new air colled chiller installed. Since the install date, we have had no-end of faults (LP being the most common).
As it turns out, in the winter months there is very little internal heat load, so the chiller in turn sits idle. In fact, the chiller...
Hi,
Just wondering if someone can confirm (or kick back) my take on the following.
For equations 3.7.5 (1) I need the Bending moment of the vessel, is this simply the maximum I get from the bending moment diagram (for horizontal vessel easy - for vertical vessel seams odd).
For equation...
Hi,
Just wondering if anyone knew of a way to sort a bunch of numbers, based on a formulea (macro is easy, but would like a formulea.
What I am trying to do is sort some numbers based on a frequency they show up.
i.e
Numbers 1 2 3 4 5 etc
Freq 4 5 1 1 0 etc
I also need...
Hi,
I am using Project 2007, and note I can add Indicators to custom feilds.
Can anyone tell me the formulae I need to enter so I can show the following:
1. start date is greater than status date (not yet reached)
2. start date is equal to or less than status date (can/should commence)
3. work...
Hi all,
I have a spreadsheet that I would like some input on (checking of my theory).
This is a simple spreadsheet for changing the pulley size to acheieve the required air flow. What I would like to know is if my cacluation of the power requirement and running amps are correct (power...
Hi, I have a spreadsheet relating to pulley changes on fans etc, and would like to know if what I have used for Power and running amps are correct. I have assumed the fan effeciency as 87%, motors are 400V, 3 phase.
Take a look and let me know if I am off the beaten path.
Thanks,
Hi all,
This is more for my general interest, and yes also specific situation.
I am curious on the running costs of an oversized pump that is on a VSD, as opposed to a correctly sized pump that is funning at full speed.
For example, assume a pump is acheiving 9m3/hr against 8.5m head, all at...
Hi,
I have a "feature pool", which we do not want ripples on the surface of due to water circulation.
Can anyone advise what the maximum water surface velocity should be, to ensure no "ripples" occur. Also, what the maximum water velocity of the suction ports should be, to ensure a vortex is...
Hey,
Just wondering if there was an easy way (and quick) to import statuary holidays into a calendar in Project 2007. I know you can generate non workings days one at a time. I thought you could import a standard statuary holiday list in earlier versions, but may be mistaken.
Cheers,
Hi all.
I am trying to create a custom line type taht will be a double line. One will be solid, the other dashed. These will be either 50mm or 25mm apart (can create two different line types).
Can this be done? I have only been able to find reference to single line linetypes.
I use both...
Hey,
Just trying not to re-invent the wheel here. Can anyone point me in the direction of stanard Flange Drawings and butterfly valve drawings in dwg. Would save me many hours trying to reproducethese myself.
Many Thanks,