Civil MDC

Excel Spreadsheets Engineering

MOVING WHEEL LOADS ANALYSIS Spreadsheet 1

MOVING WHEEL LOADS ANALYSIS Spreadsheet

“MOVLOADS” Program Program Description:   “MOVLOADS” 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 […]

MOVING WHEEL LOADS ANALYSIS Spreadsheet Read More »

[Spreadsheet] Basement wall design to BS 8110:1997, BS 8002:1994, BS 8004:1986 2

[Spreadsheet] Basement wall design to BS 8110:1997, BS 8002:1994, BS 8004:1986

Description Basement walls and design differ from other structural walls because in the basement inside of wall have living space and earth filling on the outside of wall i.e. why these are structurally designed as retaining walls to overcome the lateral pressure of outside filling of soil/earth. The basement walls are either load bearing to bear the load

[Spreadsheet] Basement wall design to BS 8110:1997, BS 8002:1994, BS 8004:1986 Read More »

Excel for Scientists and Engineers: Numerical Methods Book by E. Joseph Billo 4

Excel for Scientists and Engineers: Numerical Methods Book by E. Joseph Billo

TABLE OF CONTENTS Detailed Table of Contents vii Preface xv Acknowledgments xix About the Author xix Chapter 1 Introducing Visual Basic for Applications 1 Chapter 2 Fundamentals of Programming with VBA 15 Chapter 3 Worksheet Functions for Working with Matrices 57 Chapter 4 Number Series 69 Chapter 5 Interpolation 77 Chapter 6 Differentiation 99 Chapter

Excel for Scientists and Engineers: Numerical Methods Book by E. Joseph Billo Read More »

[Spreadsheet] SP-017(14): The Reinforced Concrete Design Handbook Column Interaction Diagram 5

[Spreadsheet] SP-017(14): The Reinforced Concrete Design Handbook Column Interaction Diagram

Description SP-017(14): The Reinforced Concrete Design Handbook Column Interaction Diagram Spreadsheet DESCRIPTION The Reinforced Concrete Design Handbook is published in two volumes: Chapters 1 through 11 are published in Volume 1 and Chapters 12 through 15 are published in Volume 2.

[Spreadsheet] SP-017(14): The Reinforced Concrete Design Handbook Column Interaction Diagram Read More »

Concrete Mix design as per IS (Indian Standard) Method 6

Concrete Mix design as per IS (Indian Standard) Method

The following points should be remembered before proportioning a concrete mix a per IS-10262-2009. Concrete Mix Design This method of concrete mix design consist of following 11 steps 10. Workability measurement (using slump cone method) 11. Repeating step 9 & 10 until all requirements is fulfilled. Let us discuss all of the above steps in

Concrete Mix design as per IS (Indian Standard) Method Read More »

Concrete Slab design by Prof. Dr. Zahid Ahmad Siddiqi 9

Concrete Slab design by Prof. Dr. Zahid Ahmad Siddiqi

The coefficient method may be the simplest, easiest and the quickest approach for the design of two–way slab supported by edge beam on all slab sides. This method was provided in the American Concrete Institute (ACI) in 1963 to design two–way slabs carried by steel beams, deep beam, or walls. A concrete slab is a common structural element of modern buildings, consisting of a flat,

Concrete Slab design by Prof. Dr. Zahid Ahmad Siddiqi Read More »

FRAME (Portal and gable rigid plane frame analysis) Spreadsheet 11

FRAME (Portal and gable rigid plane frame analysis) Spreadsheet

FRAME spreadsheet program written in MS-Excel for the purpose of plane frame analysis of portal and gable rigid plane frames subjected to various types of loading. Specifically, the “stiffness matrix” method of analysis is used to determine the unknown joint displacements, support reactions, and member end forces. Individual frame members are also analyzed to determine

FRAME (Portal and gable rigid plane frame analysis) Spreadsheet Read More »

ACI 318M -08 development lengths and splices of reinforcement by M. Abushady 12

ACI 318M -08 development lengths and splices of reinforcement by M. Abushady

This sheet created by M. Abushady for comments & notes on it. Send an e-mail to m.ali.abushady@gmail.com Development, Anchorage, and Splices of Reinforcement Steel reinforcement must be bonded to the concrete sufficiently so that the steel will yield before it is freed from the concrete. Despite assumptions made in the past to the contrary, bond stress between

ACI 318M -08 development lengths and splices of reinforcement by M. Abushady Read More »

Unprotect ExcelSheet / Excel Password Remover Software (Plugin) 13

Unprotect ExcelSheet / Excel Password Remover Software (Plugin)

The Software easily and quickly remove excel Sheet or Workbook password from password protected MS Excel file. Have you ever forgotten your Excel workbook or sheet password? If you have forgotten your sheet protection password or your Workbook was Protected this is the solution for you. With it you can easily unprotect excel Sheet or

Unprotect ExcelSheet / Excel Password Remover Software (Plugin) Read More »

SIEVE ANALYSIS Sheet + ATTERBURG LIMIT + DETERMINATION OF SOIL DENSITY WEIGHT 14

SIEVE ANALYSIS Sheet + ATTERBURG LIMIT + DETERMINATION OF SOIL DENSITY WEIGHT

A sieve analysis (or gradation test) is a practice or procedure used in civil engineering and chemical engineering to assess the particle size distribution (also called gradation) of a granular material by allowing the material to pass through a series of sieves of progressively smaller mesh size and weighing the amount of material that is stopped by each sieve as a fraction of the

SIEVE ANALYSIS Sheet + ATTERBURG LIMIT + DETERMINATION OF SOIL DENSITY WEIGHT Read More »

(Concreting +Masonry +Reinforcement +Carpentry +Roof works +Tiling works +Painting work +Scaffolding work ) Estimation 17

(Concreting +Masonry +Reinforcement +Carpentry +Roof works +Tiling works +Painting work +Scaffolding work ) Estimation

Estimation is the process of finding an estimate, or approximation, which is a value that is usable for some purpose even if input data may be incomplete, uncertain, or unstable. The value is nonetheless usable because it is derived from the best information available. It is processed by predicting the probable cost of a project

(Concreting +Masonry +Reinforcement +Carpentry +Roof works +Tiling works +Painting work +Scaffolding work ) Estimation Read More »

Estimates of Unit Quantities (i,e. P.C.C rates) 18

Estimates of Unit Quantities (i,e. P.C.C rates)

Rate Analysis of Plain Cement Concrete (PCC) & Calculate Quantity and Cost Rate Analysis – Plain Cement Concrete (PCC) M10 (1:3:6) Rate analysis for Plain Cement Concrete (PCC)  requires estimation of materials for PCC, i.e. quantity of cement, sand and aggregate required for 1m3 for various proportions, i.e., PCC M10 (1:3:6), 1:2:4,  etc. So, let us first calculate quantity of

Estimates of Unit Quantities (i,e. P.C.C rates) Read More »

Bill of Quantities of Buildings (BOQ and Abstract cost) 20

Bill of Quantities of Buildings (BOQ and Abstract cost)

A bill of quantities is a document used in tendering in the construction industry in which materials, parts, and labor are itemized. It also details the terms and conditions of the construction or repair contract and itemizes all work to enable a contractor to price the work for which he or she is bidding. Bill

Bill of Quantities of Buildings (BOQ and Abstract cost) Read More »

Scroll to Top