Continue to Site

Eng-Tips is the largest engineering community on the Internet

Intelligent Work Forums for Engineering Professionals

  • Congratulations cowski 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: iken
  • Content: Threads
  • Order by date
  1. iken

    Data Validation Lists Using Dynamic Name Range

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

    Ranking Alphabetically

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

    Hide Worksheet Based on Cell Value

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

    316ss vrs 2205ss

    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,
  5. iken

    Max If function

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

    Offset & Large Function Combined

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

    Zick analysis - Metric or Imperial

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

    Excel Chart Help Please

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

    Chiller Operation Performance

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

    AS1210 - Calculation of Torque and Bending Moment

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

    Sorting based on qty - through formulea

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

    Feild with Indicatorts

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

    AHU Pulley Change & Motor Size

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

    Electrical Motor Calculations

    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,
  15. iken

    Pump Running Costs

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

    Motor Current Draw

    Hi, Is there a way (sure there is) to calculate the new current draw from an existing motor, if i increase the pulley size on a fan? Thanks,
  17. iken

    Maximum Water Velocity without Creating Vortex

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

    Statuary Holidays on Calinder

    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,
  19. iken

    Custom Double Line Linetype

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

    Flange dwg Drawings

    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,

Part and Inventory Search