Description

Number of Products :- 20

1. 1. Eccentric Footing Design Excel Sheet with Shortcut Key’s
   2. Checklist For E Tabs Design Excel Sheet with Shortcut Key’s
   3. Circular RCC Column Design Excel Sheet with Shortcut Key’s
   4. Column Design Excel Sheet with Shortcut Key’s
   5. Design of Column With Biaxial Bending Excel Sheets with Shortcut Key’s
   6. Dog Legged Stair Design Excel Sheets with Shortcut Key’s
   7. Doubly Reinforced Beam Design Excel Sheet With Shortcut Key’s
   8. Earthquake and Load Calculation Design Excel Sheet with Shortcut Key’s
   9. Combined Footing Design Excel Sheet with Shortcut Key’s
   10. Isolated Footing Design Excel Sheet
   11. Moment Connection of Wide Flange Beam to HSS Column Design Excel Sheet with Shortcut Key’s
   12. One Way Cantilever Slab Design Excel Sheet with Shortcut Key’s
   13. One Way Simply Supported Slab Design Excel Sheet with Shortcut Key’s
   14. One Way Slab Design Excel Sheet with Shortcut Key’s
   15. Prestressed Design With Moving load Design Excel Sheets with Shortcut Key’s
   16. Raft / MAT Foundation Design Excel Sheet
   17. Retaining Wall Design Excel Sheet with Shortcut Key’s
   18. Two Way Simply Supported Slab Design Excel Sheet with Shortcut Key’s
   19. Two Way Slab Design Excel Sheet with Shortcut Key’s
   20. Wind load Calculation Design Excel Sheet with Shortcut Key’s

Summary:

1. Name of File :- Eccentric Footing Design Excel Sheet with Shortcut Key’s (based on IS Code)

By using this excel sheet you can easily analyze and design of eccentric footing .

This sheet is better for manual calculation

Content :-

1. CHECK FOR BASE PRESSURE
2. BENDING MOMENTS AT FACE OF COLUMN
3. MAX. B.M AT FACE OF COLUMN ABOUT XX AXIS
4. MAX. B.M AT FACE OF COLUMN ABOUT ZZ AXIS
5. CHECK FOR ONE-WAY SHEAR
6. CHECK FOR TWO WAY SHEAR
7. DETAILS OF REINFORCEMENT

2. Name of File :- Checklist For E Tabs Design Excel Sheet with Shortcut Key’s (based on IS Code)

• Sheet No 1-
•  Material Properties
• Define Frame Section
• Define Slab Section
• Define Mass Source
• Preferences
• Model
• Load
• sheet no-2
• wall load calculation
• sheet no-3
• base shear check

3. Name of File :- Circular RCC Column Design Excel Sheet with Shortcut Key’s (Based on IS Code)

Circular-RCC Column-Design

Design of circular column (bi axial)

• GRADE STEEL (Fe)
• AXIAL LOAD
• Eff. length
• FACTORED LOAD
• ASSUMED DIA OF COLUMN
• ECCENTRICITY (mm)
• MOMENT
• RESULTANT MOMENT
• Mu/fck x D3
• Pu/fck x D2
• P/fck (S.P-16)
• Pt %
• AST (Req)

4. Name of File :- Design of Column With Biaxial Bending Excel Sheets with Shortcut Key’s (Based on IS Code)

• DESIGN OF COLUMN WITH BIAXIAL BENDING
• Moment carrying capacity about Y-Y direction
• Moment carrying capacity about Z-Z direction
• Calculation of PUZ
• Longitudinal reinforcement

5. Name-of File- Column Design Excel Sheet with Shortcut Key’s (Based on IS Code)

This Excel sheet is for real project You can use this excel sheet is for manually calculation and software by using this excel sheet you can compare and check your all value is correct or not

Content :-

SHEET 1

DESIGN OF RC COLUMN

• 4 Sided Equally Distributed R/F
• DESIGN DATA :
• PROPERTIES OF SECTION :
• MATERIAL SPECIFICATION :
• CHECK FOR SLENDERNESS :
• CLICK FOR EFECTIVE LENGTH
• EFFECT OF MINIMUM ECCENTRICITY : ( ECCENTRICITY ABOUT BOTH AXIS CONSIDERED )
• DESIGN FACTORED FORCES :
• UNIAXIAL BENDING CAPACITY ABOUT MAJOR AXIS = MUX1
• UNIAXIAL BENDING CAPACITY ABOUT MINOR AXIS = MUY1
• CHECK FOR INTERACTION RATIO :
• TRANSVER R/F :
• DESIGN SUMMARY :

SHEET 2

DESIGN OF RC COLUMN

• 2 Sided Equally Distributed R/F
• DESIGN DATA :
• PROPERTIES OF SECTION :
• MATERIAL SPECIFICATION :
• CHECK FOR SLENDERNESS :
• CLICK FOR EFECTIVE LENGTH
• EFFECT OF MINIMUM ECCENTRICITY : ( ECCENTRICITY ABOUT BOTH AXIS CONSIDERED )
• DESIGN FACTORED FORCES :
• UNIAXIAL BENDING CAPACITY ABOUT MAJOR AXIS = MUX1
• UNIAXIAL BENDING CAPACITY ABOUT MINOR AXIS = MUY1
• CHECK FOR INTERACTION RATIO :
• TRANSVER R/F :
• DESIGN SUMMARY :
• BAR COMBINATON
• MAJOR AXIS CONTRIBUTION
• MINOR AXIS CONTRIBUTION
• NO OF BARS & THEIR AREA IN mm2

NOTE : It is Unsupported Length of Compression Member

1. GENERAL :

The design of rectangular RCC column for axial load and uniaxial bending is carried out using Pu-Mu Interaction Diagrams using SP 16. For axial compression and biaxial bending the procedure is to use the above mentioned Interaction diagrams to calculate limiting uniaxial bending moment( Muxl and Muyl) about each axes separately for given Pu and to satisfy inequality equation of IS-456 i.e. (Mux / Muxl) a + (Muy / Muyl) a < 1.

2. Design of Columns using ‘SP 16’ :

In SP 16, Pu-Mu interaction charts are presented for steel grade Fe 250, Fe 415 and Fe500 for

d’/D = 0.05, 0.1, 0.15 and 0.2 . The reinforcement arrangement is idealized as :

1. Reinforcement on two opposite faces : Chart No. 27 to 38

2. Reinforcement on all four faces equally distributed : Chart No. 39 to 50.

Limitations of ‘SP 16’ :

1. The charts for case 1 can be used for uniaxial bending only. However small bending Moment in the other direction may be, There is no way to design a column for Biaxial Bending for this arrangement of reinforcement.

2. When the charts are used for Mux (BM @ Major axis) for case 1, the reinforcement will be on the smaller (width- b) faces. These charts do not accommodate reinf. to be provided on larger (Depth-D) faces from detailing aspects. If a Column with D = 900mm, minimum four bars are required on each D-face, the charts can not account for these internal bars which may be of smaller diameter.

3. It is evident that larger diameter bars on the highly stressed face makes efficient use of reinforcement, even larger diameter bars in corner are used with advantage for biaxial bending, it can not be accommodated by use of SP16.

4. There would be confusion in arranging the reinforcement as equally distributed for rectangular section with large D/b ratio.

5. When the analysis and design is carried out using professional software, the intricacy of Column design is such that a designer would be confident only if he checks the design by his own design tools for different cases. The column design is carried for various load combinations at junction with beam at top and bottom and at @ mid height section. More over most of the software normally use the internal forces at the nodes instead of the beam face.

An effort is made to develop a spreadsheet for design of RCC columns to over come the above mentioned limitations.

3. COLUMN DESIGN SPREADSHEET:

The formulation adopted is for Limit State of Collapse as per IS 456. The Pu-Mu has been calculated considering concrete as well as each individual reinforcement bar separately.

Concrete Grade M20, Steel Grade Fe 415 is considered.

The column cross section accommodates up to maximum three internal equally spaced reinforcement bars on each face apart from the four corner bars. No. of bars on opposite faces are same, i.e. on any face no. of bars would be 2 to 5. At a time six load combinations are included but process can be repeated for any numbers in the same sheet.

Pu, Mux and Muy input values are Positive only.

4. DESIGN PROCESS :

Give Input Data in white space, with red font. The last row will indicate whether the reinf. provided is adequate or otherwise modify grade of concrete or increase reinforcement.

In case percentage of steel < 0.8 % and > 4 %, the user will be warranted to REVISE REINF.

5. WORKSHEETS IN THIS BOOK:

* The Worksheet ‘Mux’ shows data, steps and output calculation points for Interaction diagram Pu-Mux diagram which is interpolated for Muxl.

* The Worksheet ‘Muy’ shows data, steps and output calculation points for Interaction diagram Pu-Muy diagram which is interpolated for Muyl.

* The worksheet ‘Sample Problem’ shows the design output for understanding the problem.

6. DISCLAIMER

* TO BE USED BY QUALIFIED STRUCTURAL ENGINEER FOR DESIGN AS PER OF IS – 456. CHECK BEFORE USE.

* NO LIABILITY OF DEVELOPER OF ANY TYPE UNTILL A LICENCE AGREEMENT IS SIGNED BETWEEN USER AND DEVELOPER, AND THAT THE USER IS FORMALLY TRAINED FOR USE OF THIS SPREAD SHEET, INCL. ITS ADVANTAGES AND ITS LIMITATIONS.

 

6. Name of File :- Doubly Reinforced Beam Design Excel Sheet With Shortcut Key’s (based on IS Code)

1. complete sheet for doubly reinforced design
2. this excel sheet is mainly for real live project building
3. better for manual calculations of beam result and load calculation
4. you can also compare and check your sap2000,etabs,staad result value by using this excel sheet

 

7. Name of File :- Dog Legged Stair Design Excel Sheets with Shortcut Key’s (Based on IS Code)

Content :-

• sheet no-1 Data Sheet
• sheet no-2 DESIGN OF DOG-LEGGED STAIR
• General arrangement:-
• Design Constants:-
• Loading Each Flight :-
• Design of waist slab :-
• Reinforcement:-
• Distribution steel
• sheet no-3 Drawing
• sheet no-4 VALUES OF DESIGN CONSTANTS
• Permissible Bond stress Table tbd in concrete (IS : 456-2000)
• Development Length in tension
• Permissible shear stress Table tv in concrete (IS : 456-2000)
• Permissible stress in concrete (IS : 456-2000)
• Maximum shear stress tc.max in concrete (IS : 456-2000)

8. Name of File :- Earthquake and Load Calculation Design Excel Sheet with Shortcut Key’s (based on IS Code)

 

9. Name of File :- Eccentric foundation Design Excel Sheet with Shortcut Key’s

 

10. Name of File :-  isolated footing design excel sheet

Data: –

• Footing Size Design
• Axial Load
• Self weight of footing
• Total weight footing
• Moment in x dir
• Moment in y dir
• Column size
• SBC
• Footing Size required
• Footing Size Provided
• Area Provided
• Net upward pressure
• Slab Design
• Bending Moment in x dir
• Bending Moment in y dir
• Concrete
• Steel
• Minimum Depth Required
• Depth Provided
• Clear Cover
• Effective Cover
• Effective Depth

11. Name of File :- One Way Cantilever Slab Design Excel Sheet with Shortcut Key’s

This Excel sheet is for real project You can use this excel sheet is for manually calculation and software by using this excel sheet you can compare and check your all value is correct or not.

Content:-

• One Way Cantilever Slab Design
• Calculation Of Load, BM & SF
• Design Of Member To Resist Bending Moment
• Design/ Check For Member To Resist Shear
• Max Shear Stress
• Check For Development Length
• Development Length For Single Bars
• Development Length Based On Anchorage Bond
• Development Length Based On Flexural Bond
• Check For Deflection

12. Name of File :- One Way Slab Design Excel Sheet with Shortcut Key’s (Based on IS Code)

This Excel sheet is for real project You can use this excel sheet is for manually calculation and software by using this excel sheet you can compare and check your all value is correct or not

Content :-

• One Way Simply Supported Slab Design
• Calculation Of Load, BM & SF
• Design Of Member To Resist Bending Moment
• Max Depth Of Neutral Axis
• Design/ Check For Member To Resist Shear
• Max Shear Stress
• Check For Development Length
• Development Length For Single Bars
• Development Length Based On Anchorage Bond
• Development Length Based On Flexural Bond
• Check For Deflection

13. Name of File :-  One Way Slab Design Excel Sheet with Shortcut Key’s (Based on IS Code)

Content :-

• One Way Slab Design
• (Ex 6.8 RCC Punmia)
• Calculation Of Load, BM & SF
• Design Of Member To Resist Negative Bending Moment
• Spacing Of Bars At Support
• Design Of Member To Resist Mid Span Bending Moment
• Reinforcement For Longitudinal Direction Of One Way Slab
• Design/ Check For Member To Resist Shear
• Check For Development Length
• Development Length Based On Anchorage Bond
• Check For Deflection

14. Name of File :- Two Way Simply Supported Slab Design Excel Sheet with Shortcut Key’s (Based on IS Code)

This Excel sheet is for real project You can use this excel sheet is for manually calculation and software by using this excel sheet you can compare and check your all value is correct or not

15. Name of File :- Two Way Slab Design Excel Sheet with Shortcut Key’s

Content :-

• Two Way Slab Design
• Calculation Of Load, BM & SF
• Design Of Member To Resist Bending Moment
• Max Depth Of Neutral Axis
• Design/ Check For Member To Resist Shear
• Max Shear Stress
• Check For Development Length
• Development Length For Single Bars
• Development Length Based On Anchorage Bond
• Development Length Based On Flexural Bond
• Check For Deflection

16. Name of File :- Prestressed Design With Moving load Design Excel Sheets with Shortcut Key’s (Based on IS Code)

This Excel Sheet Is For Real Project You Can Use This Excel Sheet Is For Manually Calculation And Software By Using This Excel Sheet You Can Compare And Check Your All Value Is Correct Or Not

17. Name Of Sheet :- Raft / MAT Foundation Design Excel Sheet

Data: –

Calculation of depth of raft:-

• For critical column:
• Column C2,
• ultimate load, Pu=
• size of column =
• Assume effective depth of footing, d=
• Assuming two way shear,
• total perimeter(b0)=
• Shear stress due to load, Ʈv=
• Permissible shear stress, Ʈc=
• For critical edge column:
• Column D3,
• ultimate load, Pu=
• size of column =
• Assume effective depth of footing, d=
• Assuming two way shear,
• total perimeter(b0)=
• Shear stress due to load, Ʈv=
• Permissible shear stress, Ʈc=

Design of common Raft :-

• Loads on column at base
• Moment of inertia about CM:
• Safe Bearing Capacity=
• σx,y =P/A±Mx/Ix*Y±My/Iy*X

18. Name of File :- Retaining Wall Design Excel Sheet with Shortcut Key’s

Solved example- (ex 15.1 RCC by bc punmia & ex 12.1 vazrani and ratwani)

By using this excel sheet you will be design of complete retaining wall .

And also this excel sheet is for real projects

1. Check for bearing pressure
2. Calculation of pressure
3. Design of shear key
4. Design of base slab
5. Design of toe slab
6. Spacing of main bars
7. Design/ check for toe slab to resist shear
8. Design of heel slab
9. Design of stem wall

19. Name of File :- Wind load Calculation Design Excel Sheet with Shortcut Key’s (Based on IS Code)

• Wind load Calculation Design
• Wind load Calculation
• WIND LOAD ANALYSIS
• Pz = Cc x Ci x Cz x Cg x Cp x (Vb)2
• Velocity of wind, Vb 200 km/hour
• Cg (For Exposure A) = 1.3850 Table 6.2.11 BNBC
• Cg (For Exposure B) = 1.1780 Table 6.2.11 BNBC
• Pz = Cc x Ci x Cz x Cg x Cp x (Vb)2
• Velocity of wind, Vb 200 km/hour

20.