-

Soil Boring Log Excel Template

Description:

The boring log is the basic record of almost every geotechnical exploration and provides a detailed record of the work performed and the findings of the investigation. The field log should be written or printed legibly and should be kept as clean as is practical. All appropriate portions of the logs should be completed in the field prior to completion of the field exploration.
A wide variety of drilling forms are used by various agencies. The specific forms to be used for a given type of boring will depend on local practice. Typical boring log, core boring log and test pit log forms endorsed by the ASCE Soil Mechanics & Foundations Engineering Committee.

-Topographic survey data including boring location and surface elevation, and benchmark location and datum, if available.
-An accurate record of any deviation in the planned boring locations.
-Identification of the subsoils and bedrock including density, consistency, color, moisture, structure, geologic origin.
-The depths of the various generalized soil and rock strata encountered.
-Sampler type, depth, penetration, and recovery.
-Sampling resistance in terms of hydraulic pressure or blows per depth of sampler penetration. Size and type of hammer. The height of the drop.
-Soil sampling interval and recovery.
-Rock core run numbers, depths & lengths, core recovery, and Rock Quality Designation (RQD)
-Type of drilling operation used to advance and stabilize the hole.
-Comparative resistance to drilling.
-Loss of drilling fluid.
-Water level observations with remarks on possible variations due to tides and river levels.

Download Link

Download KPI Dashboard Excel Template

Overview:

Key Performance Indicator (KPI) is a measurable value that shows how effectively a company is achieving key objectives. Organizations use KPIs to evaluate their success in reaching their targets.

Selecting the right KPI will depend on your industry & which part of the business you are looking to track. Each department will use different KPI types to measure success based on specific business goals & targets.

Once you’ve selected your key KPI business metrics, you will want to track them in a real-time reporting tool. KPI can be done using dashboard reporting software, giving your entire organization insights into your current performance.

Download Link

Build KPI Dashboard In Excel in 5 minutes

Source : bibloteka.com

S-Curve Excel Template

Overview:

S-curve excel template is a great graphical project management tools for planning, monitoring, controlling, analyzing, and forecasting project’s status, progress, & performance. S-Curve shows the progress of work over time and forms a historical record of project trends and variations.S-curve is used for different purposes.

Progress and Performance Evaluation

The most common uses of the S-curve template is in evaluating the progress of projects and performance, especially with the use of Earned Value Management (EVM).

S-curve is generated traditionally within the EVMS process and is the basis for evaluating the project’s progress and performance.

S-Curve Excel Template

-S-Curve Excel Template used for evaluation for the progress of the project

-S-Curve Template show cumulative cost over time

Download Link

Source: bibloteka.com

Six Sigma Control Plan Dashboard Excel Template

Overview:

Six Sigma Control Plan is one of the best methods for documenting the functional elements of quality control that are to be implemented in order to assure that quality standard are met for a particular product or service. The aim of this control plan is to formalize & documentation of the system of control that will be utilized.

Most of the time, the six sigma control plan may include other items like the frequency with which the process is reviewed, verification that the measurement system is capable, typical corrective actions must be taken in the presence of out of control conditions, any requirements for special inspection & history of the process capability measures.

This six sigma control plan is a basic document for quality engineering. One should be able to review the control plan & quickly understand the elements of quality assurance being utilized.

Remember this example is a manufacturing example. The technique can be applied to any process (e.g., services industry, back-office & transactional processes). The team should use a six sigma control plan to be sure that the process does not go back into the ways of the old process.

Six Sigma Control Plan Template:

-The Six Sigma Control Plan will provide predictive information

-The Six Sigma Control Plan consists of procedures and activities necessary for the performance of a process or product

Download Link

Source : bibloteka.com

ANALYSIS OF BENTS WITH TENSION-ONLY X-BRACING

XBRACING is a spreadsheet program written in MS-Excel for the purpose of analyzing X-braced bents with tension-only systems. From 1-story up to 10-story bents may be analyzed. Specifically, given the bent width, the story heights, and the lateral story loads, all the member (segment) forces are determined, as well as the horizontal and vertical reactions at the supports, and the individual story drifts (horizontal deflections).

This program is a workbook consisting of eleven (11) worksheets, described as follows:

Doc – Documentation sheet
X(1) – Analysis of 1-story bent with tension-only X-bracing
X(2) – Analysis of 2-story bent with tension-only X-bracing
X(3) – Analysis of 3-story bent with tension-only X-bracing
X(4) – Analysis of 4-story bent with tension-only X-bracing
X(5) – Analysis of 5-story bent with tension-only X-bracing
X(6) – Analysis of 6-story bent with tension-only X-bracing
X(7) – Analysis of 7-story bent with tension-only X-bracing
X(8) – Analysis of 8-story bent with tension-only X-bracing
X(9) – Analysis of 9-story bent with tension-only X-bracing
X(10) – Analysis of 10-story bent with tension-only X-bracing

Program Assumptions and Limitations:

1. This program assumes that the vertical bent is fully braced, between every story, utilizing a tension-only X-bracing system.

2. In a tension-only bracing system, one brace is assumed effective in tension while the other brace is assumed to buckle (in compression), requiring the tension brace to take all of the load.

3. This program uses the “Method of Virtual Work” to determine the horizontal deflections at each of the story levels. The horizontal deflection at a particular story level is determined by first applying a “dummy” unit load at that level. Then, the member forces from the unit load are determined. With the member forces due to the applied lateral loads already having been calculated, the horizontal deflection at that story level is:

Dn = S F*u*L/(A*E)

where:Dn = horizontal deflection at particular story level number considered (inches)

F = force in each member due to all applied lateral story loads (kips)

u = force in each member due to unit load applied at paricular story, ‘n’

L = length of each member in bent (inches)

A = area of each member in bent (in.^2)

E = modulus of elasticity of members in bent, all assumed equal (ksi)

The horizontal deflections (story drifts) determined are for the joints at the left side of the bent, with all members (segments) assumed pinned at both ends.

* XBRACING download link provides freeware version of the software.

Download Link

Pile Group Analysis Spreadsheet

“Pile Group Analysis Spreadsheet” is a spreadsheet program written in MS-Excel for the purpose of analysis of pile groups with rigid caps using the “elastic method”. Specifically, the properties of the pile group are calculated, and then based upon the applied vertical and horizontal loadings, the vertical and horizontal pile reactions are calculated.

There is also a worksheet to check beam and punching shear in the pile cap for a single corner pile, for the purpose of estimating the required pile cap thickness and subsequent pile cap weight.

Download Link

MOVING WHEEL LOADS ANALYSIS

“Moving Load Analysis Spreadsheet” is a spreadsheet program written in MS-Excel for the purpose of analysis of simple-span members subjected to from one (1) up to eight (8) moving wheel loads with up to seven (7) wheel spacings. Specifically, the maximum moment and location from the left end of the member and wheel postioning, the maximum end shears, the maximum deflection, and the maximum center support reaction for two (2) adjacent simple-span members are calculated.

Download Link

SECTPROP – SECTION PROPERTIES ANALYSIS PROGRAM

“SECTPROP” is a spreadsheet program written in MS-Excel for the purpose of calculating section properties.Two methods of input data are provided, either by adding of deleting “shapes” or by defining a polygon by aseries of “points”. Specifically, the centroid location and total area are determined, as well as the centroidal andprincipal axes moments of inertia, radii of gyration, and rotation angle.

Download Link

AISC 13th EDITION MEMBER DIMENSIONS AND PROPERTIES VIEWER

Download Link

Terzaghi’s Consolidation Equation – Closed Form Solution

Terzaghi’s one-dimensional consolidation equation simulates the visco-elastic behaviour of soils depending on the loads applied as it happens, for example, when foundation are laid and start carrying the weight of the structure.

Its application is traditionally based on Taylor’s solution that approximates experimental results by introducing non-theoretical variables that, however, contradict the actual behaviou of soils. After careful examination of the theoretical and experimental aspects connected with consolidation, the proposal of this research is a solution consisting in a non-linear equation that can be considered correct as it meets both mathematical and experimental requirements.

The solution proposed is extended to include differential equations relating to two/three dimensional consolidation by adopting a transversally isotropic model more consistent with the inner structure of soils.

Finally, this essay is complete with application examples that give more reliable results than the traditional solution. Future developments are also highlighted considering that the uniqueness theorem has not been proven yet.