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 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: *

  1. ProjEngKLS

    L7 versus B7 Bolting

    We have a low temperature piping application (-60 °C) we are installing. Our pipe specification calls for either L7 or B8 bolting. Most of this has been installed with B7 bolting instead. The person that approved the use of B7 based his approval on the fact that the material specifications...
  2. ProjEngKLS

    Acceptable pH in CarbonSteel Pipe

    We have a new process that generates a waste water stream. The waste water will be acidic, but we can adjust the pH to suite. Process piping AFTER the pH adjustment is planned to be carbon steel (grade A106). We would like to limit the final pH adjusted volume to minimal. So what is an...
  3. ProjEngKLS

    UNHIDING COLUMNS

    Pretty sure you simply re-insert it. This is all just a database - any information you may have put in the column (fields) will still be there. Its just a matter of whether its displayed or not. ProjEngKLS
  4. ProjEngKLS

    determining non numeric cells when used in iterative calculations

    You mention iterative calculation, and I think that pmover might be touching on your problem when asking for a clarification. Are you using a circular reference? You can use a circular reference, but why bother? Why not subtotal your line items (i.e. subtotal), calculate your other costs...
  5. ProjEngKLS

    Low Temperature Pipe Specification

    Dow has been good for high temperature stuff, unfortunately they don't cover the low temperature pipe specs well. I've asked, but all they provide is high temperature specs. thanks, ProjEngKLS
  6. ProjEngKLS

    Low Temperature Pipe Specification

    I am developing a pipe specification for Dow Syltherm XLT operating at -100 °F to + 200 °F and up to 150 psig in pipe sizes 1/2" through 6". I am planning to use T304 SS pipe and fittings due to the low temperatures. I'd like to use class 150 flanges and ASTM A320 Grade L7 bolting if...
  7. ProjEngKLS

    Low Temperature Pipe Specification

    I am developing a pipe specification for Dow Syltherm XLT operating at -100 °F to + 200 °F and up to 150 psig in pipe sizes 1/2" through 6". I am planning to use T304 SS pipe and fittings due to the low temperatures. I'd like to use class 150 flanges and ASTM A320 Grade L7 bolting if...
  8. ProjEngKLS

    How can I rotate text boxes in Excel?

    The only elements I'm aware of that you can freely rotate in an Excel chart are: Data point labels, Chart Title, Axis labels. For some reason MS elected to not allow free rotation of text box (only vertical, 90 °, as noted in above response) or of series legends. You can rotate data in a cell...
  9. ProjEngKLS

    VBA Excel...Sum cells in groups of Time!!!

    There are couple of threads: thread770-41751 thread770-42106 that are wanting to do something like this - count and sum based on multiple criteria. Look at these and consider if Array Formulas will do the trick. These are pretty much like the SUMIF function tomatge mentions, but they will...
  10. ProjEngKLS

    Getting 01 to display

    One way is to use a custom format 0# The single digit numbers 1 through 9 will display with leading 0. This way, the cell is still a numerical value - so it can be used in calculations. ProjEngKLS
  11. ProjEngKLS

    Excel Autofill Frustrations

    Another slightly twisted way to do this is to use the Replace function. Instead of entering the formula "=B20" just enter the text "B20". Then below this enter "B40". Then use the autofill to populate the rest of your cells. It will fill in B60, B80, B100, B120...
  12. ProjEngKLS

    Data Extraction Question

    Oh, and using Autofilters and Subtotals should work too. Refer to Excel help reference on subtotals - you can use these to do several things like sum, count, etc and they ignore data that is hidden or filtered out. Good Luck again, ProjEngKLS
  13. ProjEngKLS

    Data Extraction Question

    Set up an array formula. Suppose "Site Number" is in range A5:A4005, "Location" is in range B5:B4005, "Year" is in range C5:C4005, "Month" is in range D5:D4005, "Depth" is in range E5:E4005, "Moisture" is in range F5:F4005, etc...
  14. ProjEngKLS

    Running two workbooks with click events

    Conex: I was saying "worksheet" in my previous post, but I actual did this in two different workbooks. So please replace "Worksheet" with "workbook". ProjEngKLS
  15. ProjEngKLS

    Running two workbooks with click events

    Conex: I have not tried this before, but I just briefly worked on your problem. I set up option boxes in worksheet 1. They are linked to cells in worksheet 2. Based on the status of linked cells in worksheet 2, I generate a list in worksheet 2 that feeds a listbox in workseeht 2. I also...
  16. ProjEngKLS

    Lock excel formulas from changing

    Willyb9: The following looks to work to me: 1) Don't move the source data - as you observed the formulas will update. 2) Copy the entire range of source data. Paste the entire range of source data (1) column to the right. 3) Enter your new data in the first column. 4) Delete the last...
  17. ProjEngKLS

    Tick Lines in Excel

    Make sure both the major and minor tick mark types are indicated on the Patterns tab of the Format Axis dialog box. You indicate that you want more marks between your present minor tick marks. If I understand correctly that would be three levels of tick marks - Major, Minor and Sub-minor(???)...
  18. ProjEngKLS

    A333 Low Temperature Pipe

    I'm examining the potential for using ASTM A333 Grade 6 for a -50 °F system. Its obvious to me that this will be a more expensive system than our typical A106 piping (for warmer temps), but I don't have a good feel for how much. Does anyone have a feel for relative installed costs of A106 vs...
  19. ProjEngKLS

    Tracking down dependent cells

    I've never messed around with this before, but I tried it to see. I got an arrow from the source cell pointing to a little spreadsheet looking icon. I found that in double-clicking the arrow (arrowhead or end dot or line in between) a GOTO dialog opens giving you the path to the dependent...
  20. ProjEngKLS

    Shell & Tube Orientation

    I probably should have mentioned that this is a liquid / liquid application - no phase change. thanks

Part and Inventory Search

Back
Top