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 81: Print All Charts on a Worksheet To print a chart, you can click any embedded chart in your worksheet and then click Print. This prints the chart on its own sheet without any of the other data on the sheet. This sounds easy enough, but it can become a chore if you’ve got […]
Macro 81: Print All Charts on a Worksheet Read More »
Macro 80: Create a Set of Disconnected Charts When you need to copy charts from a workbook and paste them elsewhere (another workbook, PowerPoint, Outlook, and so on), it’s often best to disconnect them from the original source data. This way, you won’t get any of the annoying missing link messages that Excel throws. This
Macro 80: Create a Set of Disconnected Charts Read More »
Macro 79: Align a Chart to a Specific Range Along with adjusting the size of our charts, many of us spend a good bit of time positioning them so that they align nicely in our dashboards. This macro helps easily snap your charts to defined ranges, getting perfect positioning every time. How it works Every
Macro 79: Align a Chart to a Specific Range Read More »
Macro 78: Resize All Charts on a Worksheet When building a dashboard, you often want to achieve some level of symmetry and balance. This sometimes requires some level of chart size standardization. The macro in this section gives you an easy way to set a standard height and width for all your charts at once.
Macro 78: Resize All Charts on a Worksheet Read More »
Macro 77: Transpose Entire Data Range with a PivotTable You may often encounter matrix-style data tables like the one shown in Figure 6-6. The problem is that the month headings are spread across the top of the table, pulling double duty as column labels and actual data values. In a PivotTable, this format would force
Macro 77: Transpose Entire Data Range with a PivotTable Read More »
Macro 76: Create New Workbook for Each Report Filter Item Pivot tables provide an excellent mechanism to parse large data sets into separate files. You can build a PivotTable report, complete with aggregations and analysis, and then place a field (like Region) into the report filter. With the report filter, you can select each data
Macro 76: Create New Workbook for Each Report Filter Item Read More »
Macro 75: Print Pivot Table for Each Report Filter Item Pivot tables provide an excellent mechanism to parse large data sets into printable files. You can build a PivotTable report, complete with aggregations and analysis, and then place a field (like Region) into the report filter. With the report filter, you can select each data
Macro 75: Print Pivot Table for Each Report Filter Item Read More »
Macro 74: Automatically Delete Pivot Table Drill- Down Sheets One of the coolest features of a PivotTable is that it gives you the ability to double-click on a number and drill into the details. The details are output to a new sheet that you can review. In most cases, you don’t want to keep these
Macro 74: Automatically Delete Pivot Table Drill- Down Sheets Read More »
Macro 73: Apply Pivot Field Restrictions Like PivotTable restrictions, pivot field restrictions enable us to restrict the types of actions our users can take on the pivot fields in a PivotTable. The macro outlined in this section demonstrates some of the protection settings available via VBA. How it works The PivotField object exposes several properties
Macro 73: Apply Pivot Field Restrictions Read More »
Macro 72: Apply PivotTable Restrictions We often send PivotTables to clients, coworkers, managers, and other groups of people. In some cases, we’d like to restrict the types of actions our users can take on the PivotTable reports we send them. The macro outlined in this section demonstrates some of the protection settings available via VBA.
Macro 72: Apply PivotTable Restrictions Read More »
