Featured post

Adaptive Traffic Signal Control | New Way To Reduce Traffic

1. Introduction Urban areas are increasingly grappling with the problem of traffic congestion, which not only leads to longer travel times but also results in excessive fuel consumption and harmful emissions. With cities growing in both size and population, efficient traffic management has become a priority for city planners. One of the most promising solutions to address this challenge is Adaptive Traffic Signal Control (ATSC). By adjusting traffic light timings based on real-time data, ATSC significantly reduces delays and improves traffic flow, thus offering a smarter way to manage urban mobility. 2. What is Adaptive Traffic Signal Control? Adaptive Traffic Signal Control (ATSC) is an advanced traffic management system designed to optimize traffic light timings in response to real-time traffic conditions. Unlike traditional systems that operate based on fixed schedules, ATSC uses real-time data to dynamically adjust traffic signals. This results in fewer traffic jams, smoother vehic
0

ANALYSIS AND DESIGN SOLUTION OF RCC COLUMNS (with help of excel sheet)

CIVIL WORKS AND SOLUTIONS BLOG

ANALYSIS AND DESIGN SOLUTION OF RCC COLUMNS (with help of excel sheet)


General information about this blog.
     Hey there, this is a blog for engineers to get the answers to check their answers. No not rely on this work only and if any error found, feel free to comment us and help us improving our work. If you want any topic to cover by us, comment us down we will surely try to work on it.

FIRST OF ALL, HOW TO START?


So this is so simple to use and analyze, the tricky part is to design, because various design aspect is considered with parallel calculations. So finding which one is your answer might find a tricky one to you at first. But don’t worry that’s why this guide manual is given to use it.
The content and design concept is of limit state method as given in IS:456-2000. And the reference problems are taken from BOOK: Design of reinforced concrete structures, By: Dr. R. P. Rethaliya, M. D. Parmar; Pub. Atul Prakashan; First edition: 2015.

So, refer that code for more detailed understanding of this topic. Book you can choose any one for this topic covering Axially loaded column topic.

To solve problems related to columns.



THE THING YOU HAVE TO UNDERSTAND IS TO MAKE SURE TO READ BRIEFLY THIS GUIDE MANUAL BEFORE DIRECT USING EXCEL SHEET GIVEN BELOW. BECAUSE IT MAY BE FOUND TO YOU VERY COMPLICATED TO USE.


COLOR CODE OF CELLS

☐ DATA YOU HAVE TO GIVE

☐ CALCULATIONS DONE BASED ON YOUR DATA PROVIDED

☐ FINAL ANSWERS BASED ON YOUR DATA PROVIDED.

SOME REPRESENTATIVE PICTURES OF SPREAD SHEET.


PROBLEM 1. To find compressive strength of column (only rectangle or square columns) along with design of lateral ties and eccentricity check.

Data required.
1.       CHARACTERISTIC STRENGTH OF CONCRETE fck N/mm2
2.       YIELD STRENGTH OF STEEL fy N/mm2
3.       WIDTH OF COLUMN b mm
4.       BREADTH OF COLUMN d mm
5.       DIA & no OF BARS PROVIDED IN COLUMN AS MAIN STEEL Asc mm2
6.       IF ANY OTHER DIA & no OF BARS ARE USED mm
7.       LENGTH OF COLUMN IN m


Auto calculations done by formulas.
1.       AREA OF STEEL PROVIDED mm2
2.       GROSS AREA OF BEAM mm2
3.       AREA OF CONCRETE IN c/s OF BEAM mm2


Final answers form data
1.       DESIGN AXIAL LOAD ON COLUMN CAN CARRY Pu KN
2.       SAFE LOAD ON COLUMN Psafe KN
3.       DIA OF LATERAL BAR
4.       PITCH OF LATERAL TIES
5.       ECCENTRICITY OF COLUMN IN mm
6.       ECCENTRICITY CHECK

 CLICK HERE TO READ RCC DESIGN EXCEL SHEET BY MY FREIND

 

PROBLEM 2. TO FIND AREA OF STEEL REQUIRED TO CARRY AXIAL LOAD.



Data required.
1.       AXIAL LOAD.
2.       fck N/mm2
3.       fy N/mm2
4.       WIDTH OF COLUMN b mm
5.        BREADTH OF COLUMN d mm


Auto calculations done by formulas.
1.       FACTORED AXIAL LOAD KN
2.       GROSS AREA OF COLUMN mm2
3.       AREA OF STEEL REQUIRED mm2
4.       MIN AREA OF STEEL REQUIRED 0.8% OF Ag


Final answer from data.
1.       PROVIDE AREA OF STEEL MORE THAN REQUIRED AND MIN AREA OF STEEL REQUIRED IN mm2

CLICK HERE TO READ 7 TIPS TO ENJOY LONG BUS RIDES

PROBLEM 3. DESIGN OF SQUARE COLUMN ONLY ALONG WITH DESIGN OF LATERAL TIES AND ECCENTRICITY CHECK.


Data required.
1.       fck N/mm2
2.       fy N/mm2
3.       FACTORED AXIAL LOAD ON COLUMN Pu KN


Here the design can be done through two stages.
You will get from your data
From data you will get\ method of design you choose
By min % of steel as 0.8% of Ag
As your desired % of steel as % of Ag.
Calculations done automatically  
Ag required mm2
Ag required mm2
Final answers from your method
Sides of column required mm
Sides of column required mm2
Asc required mm2
Asc required mm2


So by form this requirement provide your desired dimensions as.
1.       Dia of bar mm
2.       No of bar.
3.       Dia of other bar if any provided mm.
4.       No of other bar in any provided.
5.       Sides of column you have provided mm. must be more than 400 mm for check in eccentricity.


Final answers based on your selection of data you provided.
1.       Checks as.
a.       Min Asc check
b.       Min size of column check
c.       Eccentricity check.
2.       Dia of lateral ties required mm.
3.       Pitch of lateral ties required mm.

CLICK HERE TO READ GIFT CITY (GUJARAT INTERNATIONAL FINANCE TEC-CITY) BY MY FREIND

PROBLEM 4. ANALYSIS OF CIRCULAR COLUMN (to find compressive strength of column along with design of lateral ties and spiral (helical) reinforcement.)


 
Data required.
1.       DIA OF COLUMN d mm.
2.       fck N/mm2
3.       fy N/mm2
4.       DIA OF BAR USED AS Ast mm
5.       NO OF BAR USED AS Ast mm
6.       ANY OTHER DIA OF BAR USED IF ANY IN mm
7.       NO OF ANY OTHER DIA OF BAR USED


By this data the calculations will be made automatically and you will get.
1.       AREA OF STEEL Asc mm2
2.       GROSS AREA OF CONCRETE mm2
3.       AREA OF CONCRETE mm2


For circular column the design strength is function of mode of shear reinforcement used as either lateral ties of spirals.

So by method of ties final answers you will get as.
1.       DESIGN COMPRESSIVE STRENGTH OF CIRCULAR COLUMN Pu IN KN
a.       With lateral ties
b.       With spirals
2.       SAFE COMPRESSIVE STRENGTH OF CIRCULAR COLUMN Psafe IN KN
a.       With lateral ties
b.       With spirals.
3.       DESIGN OF LATERAL TIES.
a.       DIA OF LATERAL TIES mm
b.       PITCH OF LATERAL TIES mm
4.       DESIGN OF SPIRAL OR HELICAL REINFORCEMENT
a.       DIA OF SPIRALS TIES mm
b.       PITCH OF SPIRALS (PITCH SHOULD BE IN RANGE OF MAX AND MIN PITCH REQUIRED)
                                                               i.      MAX PITCH REQUIRED mm
                                                             ii.      MIN PITCH REQUIRED mm


 


PROBLEM 5. DESIGN OF CIRCULAR COLUMN



Data required.
1.       AXIAL LOAD ON COLUMN IN KN
2.       EFFECTIVE LENGTH OF COLUMN IF GIVEN IN m
3.       fck N/mm2
4.       fy N/mm2


based on data provided the calculation done automatically you will get.
1.       FACTORED LOAD IN KN

2.       Ag REQUIRED mm2
3.       Asc REQUIRED IN mm2
4.       DIA OF COLUMN REQUIRED IN mm


So provide data based on requirements as.
1.  DIA OF BAR PROVIDED IN COLUMN AS Asc mm
2.  NO OF BAR PROVIDED IN COLUMN AS Asc (MIN 6 NOS REQUIRED)
3. DIA OF COLUMN PROVIDED (MIN 400 mm NEEDED)


FINAL ANSWERS YOU WILL GET
1. CHECKS
                a.  MIN ECCENTRICITY CHECK
                b.  SLENDERNESS OF COLUMN CHECK
 
IF YOU WANT TO FIND STRENGTH YOUR COLUMN CAN CARRY THEN NOTE DOWN YOU DATA PROVIDED AND FILL THEM IN PROVLEM 4 SO YOU CAN GET STRENGTH YOUR COLUMN CAN CARRY ALSO DESIGN OF LATERAL TIES AND SPIRALS WILL BE DONE. 

NOTE: THE PROBLEM 4 & 5. ARE DONE BASED ON MIN STEEL 0.8% OF Ag.




So after getting this info about the excel file work. You can use this all in one problems solution of columns mentioned above and solve all that problems in one excel sheet.

Remember this work is only to check your answers and might be wrong at some point so don not only rely on this file and solve examples by yourself and check answers from this sheet.

Here is the excel sheet to solve problems in RCC columns.


TO GET ANALYSIS AND DESIGN PROBLEMS SOLUTION EXCEL SHEET FOR COLUMN CLICK HERE


TO SOLVE BEAM WITH HELP OF EXCEL SHEET CLICK HERE






This work is done by me only, and if this work harms you by any means, I’m apologizing for that. Use it wisely. Good luck.


Comments

Post a Comment