Projects that involve both the construction or renovation of a structure or an alteration of part of the environment are considered part of civil engineering.
5 major civil engineering projects:
Water engineering.
Construction and management engineering.
Structural engineering.
Geotechnical engineering.
Transport engineering.
Macro 51: Padding Cells with Zeros Many systems require unique identifiers (such as customer number, order number, or product num- ber) to have a fixed character length. For instance, you frequently see customer numbers that look like this: 00000045478. This concept of taking a unique identifier and forcing it to have a fixed length is […]
Macro 51: Padding Cells with Zeros Read More »
Macro 50: Truncate ZIP Codes to the Left Five U.S. ZIP codes come in either 5 or 10 digits. Some systems output a 10-digit ZIP code, which, for the purposes of a lot of Excel analysis, is too many. A common data standardization task is to truncate ZIP codes to the left five digits. Many
Macro 50: Truncate ZIP Codes to the Left Five Read More »
Macro 49: Trim Spaces from All Cells in a Range A frequent problem when you import dates from other sources is leading or trailing spaces. That is, the values that are imported have spaces at the beginning or end of the cell. This obviously makes it difficult to do things like VLOOKUP or sorting. Here
Macro 49: Trim Spaces from All Cells in a Range Read More »
Macro 48: Convert Trailing Minus Signs Legacy and mainframe systems are notorious for outputting trailing minus signs. In other words, instead of a number like -142, some systems output 142-. This obviously wreaks havoc on your spreadsheet — especially if you need to perform mathematic operations on the data. This nifty macro goes through a
Macro 48: Convert Trailing Minus Signs Read More »
Macro 47: Perform the Text to Columns Command on All Columns When you import data from other sources, you may sometimes wind up with cells where the number values are formatted as text. You typically recognize this problem because no matter what you do, you can’t format the numbers in these cells to numeric, currency,
Macro 47: Perform the Text to Columns Command on All Columns Read More »
Macro 46: Convert All Formulas in a Range to Values In some situations, you may want to apply formulas in a certain workbook, but you don’t necessarily want to keep or distribute the formulas with your workbook. In these situations, you may want to convert all the formulas in a given range to values. How
Macro 46: Convert All Formulas in a Range to Values Read More »
Macro 45: Copy and Paste a Range One of the basic data manipulation skills you’ll need to learn is copying and pasting a range of data. It’s fairly easy to do this manually. Luckily, it’s just as easy to copy and paste via VBA. How it works In this macro, we use the Copy method
Macro 45: Copy and Paste a Range Read More »
Macro 44: Dynamically Set the Print Area of a Worksheet In certain situations, you may find yourself constantly adding data to your spreadsheets. When you do, you may have to constantly resize the print area of the worksheet to encapsulate any new data that you’ve added. Why keep doing this manually when you can implement
Macro 44: Dynamically Set the Print Area of a Worksheet Read More »
Macro 43: Limit Range Movement to a Particular Area Excel gives you the ability to limit the range of cells that a user can scroll through. The macro we demonstrate here is something you can easily implement today. How it works Excel’s ScrollArea property allows you to set the scroll area for a particular worksheet.
Macro 43: Limit Range Movement to a Particular Area Read More »
Macro 42: Sort a Range on Double- Click When you distribute your Excel reports to your customers, it’s often nice to add a few bells and whistles. One of the easier enhancements to apply is the ability to sort when a column header is double-clicked. Although this may sound complicated, it’s relatively easy with this
Macro 42: Sort a Range on Double- Click Read More »
