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...
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...
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
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...
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
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...
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...
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...
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...
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
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...
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
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...
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
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...
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...
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(???)...
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...
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...
