Wastewater Collection Systems Management MOP 7, Sixth Edition (Water Resources and Environmental Engineering Series)

Excel Accelerator

How to Install Excel Accelerator
Close all applications, run appropriate Setup file, setup will automatically add the Excel-Accelerator to your excel menu. In case after installation Excel-Accelerator does not appear on your excel menu then follow the following steps to install Excel-Accelerator manually.


Manual Installation for Excel 2003 and older versions
1- On Excel main menu go to [Tools] => [Add-ins...]

2- Use [Browse...] button to locate ‘XL-Accelerator 2003.xla’ file,

(default location of this file is ‘C:\Program Files\Excel-Accelerator\’ unless you
change the location of installation folder at the time of installation)

3- Make sure checkbox in front of ‘Excel-Accelerator 2003’ is checked then press
[OK] button.


Manual Installation for Excel 2007
1- Click the upper-left Office button,
2- Then go to [Excel options] => [Add-ins]

3- Make sure the [Manage] dropdown at the bottom shows ‘Excel Add-Ins’ => [Go...]
use [Browse...] button to locate your XL-Accelerator 2007.xlam file,

(default location of this file is ‘C:\Program Files\Excel-Accelerator\’ unless you
change the location of installation folder at the time of installation)

4- Make sure checkbox in front of Excel-Accelerator 2007 is checked then press
[OK] button.

Autodesk Subscription 2012 MegaPack

The link is for a torrent (from rutracker).

Structural Design of Concrete Lined Flood Control Channels

This manual provides guidance for the design of reinforced, concrete lined flood control channels which convey rapid and tranquil storm water flows to prevent flooding. This guidance presents provisions for coordinating the disciplines involved in the design of channels, selecting channel type, and identifying the critical aspects of designs which require quality assurance inspection during construction. Channel design involves determining the overall channel configuration including appurtenant structures, designing reinforced concrete structures and pavement or concrete lining, determining type and location of joints, designing subdrainage systems, and designing appropriate safety features.

This guidance addresses trapezoidal and rectangular flood control channels lined with reinforced concrete. Guidance is not included for the design of channel linings formed by gabions, riprap, shotcrete, gunite, or grouted mattresses.

This guidance applies to all HQUSACE elements, major subordinate commands, districts, laboratories, and field operating activities having civil works responsibilities.

Design of Precast Concrete Piers for Rapid Bridge Construction in Seismic Regions

Incorporating precast concrete components into bridge piers has the potential to reduce the construction time of a bridge and the negative impacts of that construction on traffic flow. Practical methodologies are needed to design economical and safe piers out of precast concrete components. This research developed force-based and displacement-based procedures for the design of both cast-in-place emulation and hybrid precast concrete piers. The design procedures were developed so that they require no nonlinear analysis, making them practical for use in a design office. The expected damage to piers designed with the procedures in a design-level earthquake was estimated. The evaluation considered three types of damage to the columns of a pier: cover concrete spalling, longitudinal reinforcing bar buckling, and fracture of the longitudinal reinforcing bars. Both the force-based and displacement-based design procedures were found to produce designs that are not expected to experience an excessive amount of damage in a design-level earthquake.

Concrete Society - Assessment, design and repair of fire-damaged concrete structures
(Final Draft)

The emphasis of this report is on methods for assessing a concrete structure following a fire and hence for determining the extent of the required repairs. The design approaches used to assess the strength of repaired elements, illustrated by the design examples in Appendix B, are in accordance with the relevant Eurocodes(3, 4, 5). In addition to structural damage, there may be smoke damage to partitions, electrical and mechanical systems etc. Although the associated costs of cleaning or replacing such systems can be significant, they are not considered in this report. The focus of this report is on fires in reinforced concrete buildings, including multi-storey structures, warehouses and factories, but the principles are equally applicable to civil engineering structures, such as bridges. However, tunnels are specifically excluded as an assessment of their performance will require specialised geotechnical input, which is beyond the scope of this report. There is a major difference between designing a structure to withstand a fire, allowing for safe evacuation and fire fighting, and assessing the extent of damage caused by a fire so that repair methodologies can be proposed. While designing structures is predicting performance during a future event, assessing structures is determining its residual strength after such an event. Hence, the focus in the latter case and in this report is on methodologies to measure on site the residual strength and deformations and to obtain evidence of the temperatures reached during the fire. Calculation methodologies are presented that may assist during the evaluation process, but the working party felt that any assessment needs to be based mainly on an on-site evaluation of the fire damaged structure, which is supplemented as necessary by laboratory testing, examination or numerical assessment. In all cases, it is important that the assessment work is carried out by a competent person, who is aware of the limits of applicability for any methodology and whether special considerations for certain construction methods are required. The competent person needs to be aware that material properties and calculation methodologies presented in Eurocode 2 may not be applicable to the specific situation, since effects such as cooling of the structure or restraint and residual stresses need consideration after a fire event. This means that although the structure may have served its purpose according to Building Regulations and allowed for safe evacuation and fire fighting, considerable effort may be required to strengthen the structure for future occupation after a fire. A brief chapter on repair techniques is included, which makes reference to more detailed guidance. The working party considered that techniques are common to all repairs, irrespective of the cause of the damage, and not simply to the repair of fire-damaged concrete structures. Finally appendices to the report includes summaries of a number of case studies of the assessment and repair of structures damaged by fire, worked examples and historical information on design and material properties given in British Standards and other documents.

Methods of test for masonry units

Hot Runner Technology

geoENV VII - Geostatistics for Environmental Applications (Quantitative Geology and Geostatistics)