Category: Excel Sheets Templates

Professional tools for calculations and dimensioning of mechanical engineering problems using Excel spreadsheets.

Terzaghi’s Consolidation Equation – Finite Difference Solution

Terzaghi’s Consolidation Equation – Finite Difference 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.

 

Download Link

Design Curved Beam Spreadsheet

Design Curved Beam Spreadsheet

 

Curved Beam is a beam in which the neutral axis in the unloaded condition is curved instead of straight. Or If the beam is originally curved before applying the bending moment.
Curved beams have applications in many machine members such as c – clampers , crane hooks, frames of  presses, chains, links, rings, etc
The main difference between curved beams and straight ones that the Neutral axis does not coincide with the cross section, but is shifted towards the center of curvature of the beam.
This spreadsheet will help you to design easily curved beams

Download Link

Design of Precast Prestressed Composite Beams Excel Sheet

Design of Precast Prestressed Composite Beams Excel Sheet

 

The precast prestressed concrete units are erected first and can be used to support the formwork needed for the cast in situ slab without additional scaffolding (or shoring).

In addition to its contribution to the strength and stiffness of the composite member, the cast in situ slab provides an effective means to distribute loads in the lateral direction.

The cast in situ slab can be poured continuously over the supports of precast units placed in series, thus providing continuity to a simple span system.Pre-tensioning in plant is more cost-effective than post-tensioning on site.

Because the precast 4 prestressed concrete element is factory-produced and contains the bulk of reinforcement, rigorous quality control and higher mechanical properties can be achieved at relatively low cost. The cast in situ concrete slab does not need to have high mechanical properties and thus is suitable to field conditions.

 

Download Link

Beam Analysis Excel Spreadsheet

Beam Analysis Excel Spreadsheet

 

Shear Force, calculates flexible moment and deficit in 31 locations along the length of member “Embalal”. Members’ length can only be supported with single size or medium support, which is supported by 2, 3 or 4 lengths. The results of the analysis are produced in a tabular form and are imprinted in 3 graphs for quick understanding.
The program uses a common equation for the default equation with Shear Force, Bending Moment, and Member Time. When the middle support is specified, the solution setup is set up and the middle support response account is set up.

Spreadsheet Download

The program works internally consistent force and length unit. Permitted use of mixed units to help refine the results. The pregnancy and elastic modules of the member’s section can be defined in any unit. Similarly, any desired unit can set the reflection value. To make the unit specific, go to unit sheets and describe the ball, distance, intensity, modulus and deficit units. You need to calculate and count the conversion elements of the centralized unit from the selected unit. Sample Value This sheet is provided for your guidance. Units can not be mixed in one project file. All beams of the selected unit file apply. This means that if the units change between the formation of data files, then bees must be redefined bee characteristics in conjunction with selected bees.

Download Link

 

ICE Load Analysis on Structural Steel

ICE Load Analysis on Structural Steel

 

According to the ASCE705I ASCE 7-05 code, the Spreadsheet Program written in MS-Excel for determining ice load due to the frozen rain on structural steel members. Specifically, quality and related and necessary parameters are determined to calculate the level of snow loading of different types of structural steel members.

 

Program ideas and limitations:

1. This program specifically follows section 10.0, Ice Load – ASCE 7-5 standard, “atmospheric torque,” and “minimum design load for building and other structures”.

2. This program sets the ice load based on the ASCE 7-05 code, which determines the specific diameter for a specific size and for comparative purposes, it calculates the size of ice load based on the actual size of the size.

3. This program uses the Database and Database Properties database from AISC version 13.0 “Shape Database” CD-ROM version (12/2005), and AISC 13th Edition manual list (12/2005).

 

Download Link

Wind Load Calculator Excel Spreadsheet

Wind Load Calculator Excel Spreadsheet

 

ASCE705W ASCE 7-05 Written for analysis of air load for code and structures for Spreadsheets program written in MS-Excel. In particular, air pressure is calculated by coefficients and corresponding parameters and net design calculations or calculation of air pressure.

Wind Load Calculator

This program is a workbook with the nine (9) worksheets described below.

*Simplified – Analysis using simplified method for improving home with <= 60 ‘
*MWFRS (low-rise) – main air-power resistance system for low-end house <= 60 ‘
*MWFRS (any HT) – the main wind power protection system for any height building
*Wall C and C wall components and cladding analysis
*Roof C and C – Roof material and cladding analysis
*Stack and Tank – Condensed Chimney, Stack and Vertical Tank Analysis
*Open framework (no roof) – Analyze the open framework without ceiling
*Wind Maps – Basic Wind Speed ​​Maps (Figure 6-1 for code ASCE 7-05)
*For more information on load type, read more about load count topics.

Program ideas and limitations:

1. This program uses the “ASCE 7-02 Air Load Regulation Usage Guidelines” to determine the external air pressure group used in outdoor air pressure assistants, ‘GCP’, Wall C and C and Roof C and C worksheets. . (Note: A version of this document that was applicable to the SSC 7-05 code was not available.)

2. Workshops for “MWFRS (any HT)”, “Wall C and C”, and “Roof C and C” are applicable for home with an average ceiling height of up to 500 feet.
3. For “simplified” analysis, it is applicable to low-growth house by meeting the criteria of Section 6.4.1.

4. In the worksheet for simplified analysis, the design is calculated for each side of the MWFRS air load. MDFRS design design is considered to be loaded in total length of the building length or length.

5. Worksheet for “MWFRS (Low-Rise)” is applicable for low-rise home defined in section 6.2.
6. The “open structures” worksheet is applicable for open frames without a 500 ft tall roof. It can be used for open-process-type structure and pipe / utility racks and bridges.
5. User defined steps can be used to define air pressure distribution in the worksheet for ‘Z’, “MWFRS (any HT)”, “Wall C and C”, and “Roof C and C”.

7. “May MWFRS (no HT)”, “Stack and Tank” and “Open Structures” worksheets can handle “strict” and “flexible” buildings and structures. For “strict” buildings or structures, this program uses a counting value of 0.85 or a glass effect factor, ‘g’ code code code 6.5.8.1. For “flexible” buildings or structures, this program calculates the ‘gf’ according to the vibration section 12.8.2.1, code based on the approximate time of code 6.5.8.2, where the formula X ‘X’ = City * H ^ X 0.75 is considered to be.

8. Workshops for “Wall C and C” and “Roof C and C” for flat roof buildings, Galilei roof buildings with roof corners <= 45 degrees and ceiling corners with monosclosure roof buildings <= 3 degrees.

9. “Stack and Tank” worksheet is applicable to the 600 feet long arch welded structure.

10. This program has several “comment boxes” that contain information including input or output items, usage of equations, data tables, etc. (Note: The appearance of the “Comment Box” is indicated by the “red triangle” in the top right corner of a cell, in particular the mouse pointer to move the contents of the “comment box” to the desired room.)

 

Download Link

Excel Sheet to Make a Gantt Chart in Microsoft Excel 2013

Excel Sheet to Make a Gantt Chart in Microsoft Excel 2013

 

This Gantt Chart spreadsheet is designed to to help you create a simple project schedule. You only need to know some basic spreadsheet operations, such as how to insert, delete, copy and and paste rows and cells. For more advanced uses, such as defining task dependencies, you will need to know how to enter formulas.

 

Download Link

error: Content is protected !!
Exit mobile version