I am looking for another opinion on whether the Fire Department Connections need to be "interconnected" when a large building is supplied by more than one underground service/riser. The case I have in mind is a large warehouse (200,000 sq ft) with risers at opposite ends as was commonly done in...
I have a list I want to sort in the following way:
original
--------
200
102A
300A
305B
100
101
WANT
-------
100
101
102A
200
300A
305B
unfortunately excel likes to sort all numbers first and all letters second. So I get the following undesired result:
EXCEL'S RESULT
--------------
100...
I have a list of jobs with due dates in an excel file. I want to take the data and make it into a normal looking Monthly calendar. I can find lots of templates for excel calendards that look good. But my question is how to integrate the two.
My first thought is to use the LOOKUP function...
I have a simple task of adding the number zero "0" infront of a long list of labels (text) in excel. The example is as follows:
5AAA5 --> 05AAA5
5BBB5 --> 05BBB5
5CCC5 --> 05CCC5
Of course I can do a simple find and replace for the number '5' but I don't want to replace the last 5 in the...
Background:
I have an aboveground multi-container LP installation with one group of three tanks and one group of six tanks. Each ASME tank is approximately 30,000 gallons in capacity and equipped with redundant fail-safe control measures (as defined by section 3.11). The groups are separated...
