Smart Design Excel Sheets by Civil Solution - Dailymotion

Civil Solution

Watch the playlist Smart Design Excel Sheets by Civil Solution on Dailymotion

Transcript

00:00Hello everyone, welcome back you all in this new video, where we are going to see how to

00:04design different types of slayer as one guy slab, two way slabs and cantilever type of

00:09the slabs by using this one master excel sheet.

00:12At the end of this video, we will see some dynamic feature of this excel sheet to prepare

00:17the schedule and details.

00:19Have a look over the structural framing plan of this particular floor, where different

00:22floor slabs are present as S1, S2, S3, S4 and S5.

00:29And here we need to design all these different floor slabs, in respect of the preliminary

00:33deca as given.

00:35So the material for designing of all these different slabs, we had to use as for concrete

00:40M25 and for steel AP500.

00:43The loads for these slabs as given as live load as 3Km square and floor finish load as

00:501.2Km square.

00:52The clear cover for all these slabs needed to consider as 20mm and side cover as needed

00:58to consider 30mm and the section size of the beam which is going to provide the support

01:02to all the slabs as 230x500 in mm.

01:06So these are the preliminary data that are very very essential for the designing of all these

01:11different types of the slabs.

01:12So without wasting time, we are going to look at and we are going to take the help of the

01:16advanced and master excel sheet that will help us to design all these different slabs.

01:22First of all, try to understand how to use this excel sheet.

01:25So here you have to edit the values only in euro cells.

01:28You are not allowed to edit the values in the white cells.

01:32Wherever the white cells are present, you don't need to try to edit that cells because the

01:36formulas are fitted in that white cells.

01:39So white cells are going to adjust the values on its own.

01:43You have to edit the values only in euro cells.

01:46Later, this cell will suggest the safe value, the limiting values and wherever in this excel

01:51sheet you are finding the black cells or black area, you have to skip that area.

01:57And wherever in this excel sheet you are getting the rare cells, it is the sign of the danger

02:01or failure.

02:02So while using this spirit sheet or this excel sheet, you should keep all these things in

02:07your mind.

02:08In what cells, what you had to do.

02:10Now look at this structure framing plan, where we are going to design first as S1 slab and

02:15this S1 slab is having the shorter span as 5.436 and longer span as 5.716.

02:23And the plenary data we have to follow for the resiling of this S1 slab.

02:27So I am going to put the values in our spreadsheet.

02:30So here, the grade of concrete we have to use as M25.

02:34So drop down list is there.

02:36You can choose the grade of concrete as per your need, as per your requirement.

02:40So I am going to choose the M25 grade of concrete and grade of steel we have given as Fe500.

02:47These two things we are having in respect of the material.

02:50In respect of the sectional properties, shorter the span of the slab.

02:54So how much the shorter span of the slab is.

02:56So that is actually what present here.

02:58Look at here.

02:59The shorter span of this one slab is 5.436.

03:03So that I am going to put 5.436.

03:08Longer span is 5.716.

03:125.716.

03:14So this sheet will tell you whether it is either one slab or two-way slab automatically.

03:19So here, this slab is actually what two-way slab.

03:22Now, if it is two-way slab, so IS-436-2000 has suggested nine type of the panels.

03:28Whether it is what interior panel, one shot, it discontinues, discontinues.

03:32So when you are going to use this excel sheet, so you don't need to look at the IS hood to

03:37decide the type of panel.

03:39You can directly select the type of panel here only.

03:41And accordingly, later design is going to be adjusted.

03:44So I am going to decide what type of panel it is.

03:47So here, this slab is having this shorter span, which is discontinuous from this side.

03:53On this side, it is also discontinuous.

03:55Now on this side, about this beam too.

03:58So on this side, what partly it is discontinuous, partly it is what continuous.

04:05So in this situation, what normally we are the structure...

04:08Engineers are considering that we are going to consider this completely discontinuous.

04:13Don't consider it to be what continuous.

04:16So here, we are going to consider this edge also discontinuous, this also discontinuous,

04:21this also discontinuous.

04:23So three edges are discontinuous, only one short edge is continuous.

04:29So this type of panel it is.

04:31So we have to find in our excel sheet where this type of panel is.

04:35So when you find it here, only one long edge is continuous.

04:40Second, only one short edge is continuous.

04:43Three edges are discontinuous, only one short edge is continuous.

04:47So I am going to choose this one.

04:49Thereafter, here we need to assume the trial depth of this slab.

04:52So normally, for a residential building, whose both span of this slab are within the 5 meter.

04:58So that are going to be satisfied with 120 to 130 lm thickness of this slab.

05:04So based on this expert recommendation, we are going to choose the forward depth of this slab

05:09as one, I am going to take it from the economical side as 120 mm.

05:15So I am going to take the trial depth.

05:17It is not the final one.

05:19On the ladder, it still may change.

05:21Okay.

05:22So I am going to take 120 mm trial depth of this slab.

05:24Thereafter, what is the width of the beam supporting width?

05:27That is, we have given as 230 mm, clear cover as 20 mm, side cover as what we have given

05:34the side cover.

05:35So side cover has given as 30 mm.

05:37So that only I am going to cut it out here as 30 mm as the side cover.

05:41Diameter of main reinforcement, trial diameter we have to choose from here.

05:46So any of the value you can put here as 8 mm, 10 mm, 12 mm, whatever you need.

05:51So I am going to cut it out, trial diameter of the bar as 10 mm.

05:55Now, effective depth of 11 is going to become as 95.

05:58If you have to expand along the shorter direction, 5.66.

06:02If you have to expand along the longer direction, 5.4.

06:05Sheet is going to calculate all these things.

06:07Aspect ratio is less than 1, so it's quite obvious it is a two-way slab.

06:12Now, based on the two-way slab and based on the type of panel, all these movement corporation

06:19is going to be calculated by the sheet itself.

06:21You go need to go to your IS code.

06:23Now, here we have to do the load calculation.

06:26So here we have to adjust the values of the loads.

06:30So how much is simplified?

06:32Sheet is going to calculate itself with based on overall depth you have considered and density

06:38of the concrete.

06:39Thereafter, how much the floor finish?

06:41So for the case of the floor finish, you have to adjust this value by varying these two.

06:47Density of the floor finish and thickness of the floor finish.

06:49Accordingly, this value is going to be changing.

06:52Okay, so these two parameters, the density of the floor finish is muddy again.

06:56So I am going to keep it as fixed.

06:58Now, thickness I am going to change.

07:00Thickness of the floor finish.

07:02So, floor finish we have to adjust here.

07:04How much the value is there?

07:05Floor finish is 1.2.

07:07So that I am going to set here.

07:091.2 I have to set here.

07:11So here I am going to define it as 75.

07:13I mean, I am thickness.

07:14So it is going to be the 1.5.

07:16No, it is more.

07:17No, take it 65.

07:19It is 1.3.

07:20No, take it to be 60.

07:23Yeah, it is 1.2.

07:24No, that's it.

07:25Lie good.

07:26How much the lie load has recommended?

07:283kg lie good.

07:29Okay.

07:30Total factor load is going to be calculated by the sheet itself.

07:33And maximum bending moment also, the sheet is going to be calculated.

07:37Now, along the shorter span, maximum bending moment is 16.735.

07:42Along the longer span, the maximum bending moment is what?

07:4520.11.

07:46Now, how much the area of reinforcement required along the shorter span?

07:50447.269.

07:52So, I would like to take 10 mm diameter of bar.

07:55So, because the 10 mm diameter of bar, the spacing requirement is 170 pi.

07:59So, I am going to take the year as what?

08:00For the sheet itself as 150.

08:02150 mm, center to set the spacing I am going to take.

08:06With 8 mm diameter of bar along the longer span, it is what?

08:0991.

08:10So, I am going to change it to what?

08:1210 also.

08:13In this direction, 142.

08:15So, there is to be what?

08:16What you can do with next?

08:18125 mm, center to center.

08:20Along the longer direction, long span.

08:23No.

08:24Here, check for the depth.

08:25Provided depth is safe in flexor.

08:27No.

08:28Provided depth, revise the depth for deflection check.

08:31Your provided depth is not safe for the deflection.

08:34You are getting the sign here.

08:35As earlier, I said that.

08:37If you are getting red cell anywhere in this extension, that is a sign of danger or failure.

08:42So, it is what?

08:43Your depth is not sufficient.

08:45So, you can satisfy these criteria even by reducing the spacing of the reinforcement.

08:51Also, to a certain extent.

08:52So, I am going to change the spacing as 125.

08:56So, still it is not passing.

08:57Now, if I take the spacing as 100 mm.

08:59And here also, I am going to take 100 mm.

09:01It still is not passing.

09:03So, your criteria for a deflection check is not going to be controlled by increasing the percentage of reinforcement.

09:10So, the only option is that you have to increase the depth.

09:13So, I am going to increase the depth as 130 areas.

09:16Now, move forward.

09:18This loading will be same.

09:19No chase.

09:20No.

09:20Here, 10 mm.

09:21190.

09:22So, I am going to take here.

09:23It is what?

09:24175.

09:25Here also, okay.

09:26150.

09:27I am going to take.

09:29Now, with this also, there is no any modification for the.

09:32Your depth is not safe for the deflection.

09:35We are not getting the improvement.

09:36We have to further increase the depth.

09:38Now, I will have to take 150 mm overall depth of this lad.

09:42Now, next, here what?

09:45217.

09:46So, I am going to take 200.

09:48And here, 178.

09:50So, I would like to take 175.

09:52Look at this.

09:53Student is not passing.

09:55Permissible span to effective depth ratio is 36.

09:58And here what?

10:00Actual is 45.

10:01Not possible to satisfy.

10:03Now, 175.

10:05Check it.

10:06Now, it is still close.

10:0712P spacing.

10:09It still does not passing.

10:11Here, 12P.

10:12No improvement.

10:13No.

10:14What I can do?

10:15I can increase the diameter of bar also.

10:16Increase that I am going to get 12.

10:19Now, here also increase to 12.

10:21Now, here 330.

10:23I will have to take 250.

10:25Maximum we are going to provide 250.

10:27Now, here also I am going to take 250.

10:29Spacing.

10:30Still not passing.

10:31No.

10:32225.

10:34Here also 225.

10:36Okay.

10:36To be 250 only.

10:39Passing?

10:39No.

10:40It is not going to pass.

10:41What we can do?

10:42Further, we are going to reduce the 200.

10:44Now, along the shorter span, it is going to consider.

10:47And for this direction, also I am going to reduce 200.

10:50Now, it is passing.

10:52Probably depth is shape in reflection.

10:54So, in both of the direction, we need to have the diameter of bar as 12 mm.

10:59Okay.

11:00Because why this extra demand is there?

11:02Because the span of this slab is more than of 5 meter.

11:05That's why design is what?

11:07Heavier.

11:07So, your prior depth is safe in flexor.

11:10Your prior depth is safe in deflection also.

11:12Now, your design is also safe in shear.

11:16Check for the cracking.

11:18So, here, as we have provided the percentile of reinforcement more than of the minimum percentage.

11:24Plus, the spacing we have provided less than of 300.

11:28These two criteria are there.

11:30Okay.

11:30Your spacing is less than of 300.

11:33As well as the reinforcement provided in both of the direction is more than of 0.12 percent.

11:38So, due to that reason, it is not needed to go for the design against the cracking.

11:44There is no need to go for checking against the cracking.

11:47Our design is safe against the cracking.

11:50No.

11:50This is what the design result.

11:52So, it is what?

11:53S1 slab.

11:53I have to correct it.

11:54What?

11:55S1?

11:55No.

11:56What is the overall thickness of this slab?

11:57150.

11:58What reinforcement required along the shorter span?

12:012x11 diameter of power at a specimen of 200.

12:03Center to center.

12:05Along the longer span.

12:062x11 diameter of power at a specimen of 200.

12:08Center to center.

12:09What type of this slab is?

12:11It is a 2x slab.

12:13Now, here, the schedules are present.

12:15So, previous data are actually here.

12:17It is present.

12:18I want to clear all that data.

12:20So, clear all.

12:21Now, here, no schedule is present.

12:23Now, go to slab design.

12:25I want to send this schedule to the sheet.

12:28So, just click over this same to schedule.

12:30Once you click over this same to schedule.

12:32This data is going to be transferred to schedule list.

12:35There is a dynamic feature of this Excel sheet.

12:38So, this is the first panel design we have completed.

12:41Now, have a look over the next panel.

12:44So, look at this.

12:45Next, we have to design the slab number 2.

12:47Okay.

12:48S2 we have to design.

12:49So, what is the span?

12:51Shortest span is 2.356.

12:54It means concrete.

12:55Grade is same.

12:56Steel grade is same.

12:57Shortest span is 2.356.

13:01Longer span is how much?

13:035.436.

13:055.436.

13:08Let's check.

13:09Now, it is the 1-base slab or 2-base slab.

13:11Sheet will automatically tell you about it is 1-base slab or 2-base slab.

13:14You don't need to bother about it.

13:16Now, what type of this 1-base slab?

13:18Either it is cantilever.

13:19Either it is simply supported.

13:21Or it is the continuous type of 1-base slab.

13:24So, it is actually the floor slab.

13:26So, it is the continuous type of 1-base slab.

13:28There is a continuity.

13:29There is a continuity.

13:30There is a continuity.

13:30There is a discontinuity.

13:31It is the continuous type of 1-base slab.

13:34Okay.

13:35So, we have to change it as what type of 1-base slab is.

13:39So, here it is simply supported type.

13:42Continuous type.

13:43Cantilever type.

13:44So, actually it is the continuous type.

13:46So, I am going to change it to more continuous type.

13:49That's it.

13:49What depth you should consider, so initially I am going to consider 130 mm trial depth.

13:55Width of the beam 230, covers and diameter of power and I am going to assume all these values as it is.

14:02Now moving forward and here the loadings are also same, no changes there.

14:07Now, 2 mm initially I am going to try it with 10 mm diameter of power, 10 mm diameter of power.

14:13So with 10 mm diameter of power, along the shorter span 4.

14:17So means very large demand is there.

14:19So I think we should start with 120 also, 120.

14:23Just come down, no with 120 with 8 mm diameter of power.

14:28So what 263, I will have take 250 only, no here 349.

14:34So maximum spacing we are taking as what 250, actually code is allowing as 300.

14:40But while practicing we are limiting the maximum spacing to 250 only.

14:44We are not providing the spacing more than 250.

14:47Code is allowing two and three ended.

14:48For this safe design, we are considering the maximum spacing as 250 only.

14:53So 250, just come down.

14:55Your product depth is safe in flexor, product depth is safe in deflection, product depth is safe in shear.

15:03No, it is also safe in cracking.

15:06Check for the cracking.

15:07No, this is what the design result.

15:09What type of panel is slap 11 is what?

15:11S2.

15:12Thickness is this, along the shorter span 8 mm at 250 center to center.

15:16Longer span 8 mm at 250 center to center.

15:19It is the one way slab sent to schedule.

15:23Once you click on the schedule, schedule is going to be updated for the S2 slab.

15:27Now, coming back for the third type of the panel.

15:31That is what?

15:32This S3 and S4.

15:33So these two slabs you can design on your own.

15:37Because it is the type of the two way slab.

15:40So you can design.

15:41You know very well how to design it.

15:43Now, we are going to focus over the S5 slab.

15:45How to design the S5 slab?

15:48So it is the cantilever slab.

15:49Of the cantilever portion is 2 meter and width is what?

15:535 meter.

15:542 and 5 meter.

15:55Okay.

15:56So then I am going to put here.

15:59Cantilever as 2 meter.

16:01It is the 5 meter.

16:03It is the one way slab.

16:05But it is not the continuous type.

16:07It is not the simply supported type.

16:08It is the cantilever type of the one way slab.

16:11Now, what thickness we should consider initially.

16:14So here I am going to start with 120.

16:16Or let it to be 130.

16:18Change it.

16:19Trial depth.

16:20No.

16:20Initial diameter I am going to consider as 10.

16:23Rest of all things as it is.

16:25Now moving forward.

16:27Loading are same.

16:28No need to change it.

16:29No.

16:29If suppose 8 meter diameter of bar I am going to use.

16:32So it is asking to provide 86.

16:34That is not okay.

16:35We are limiting minimum spacing as 100.

16:38We are not normally providing the spacing less than of 100.

16:41From 100 to 250 we are providing this spacing.

16:45So basically it is what less than of 100.

16:48So no option.

16:49Option is that what?

16:50You can increase the dia or you can increase the depth.

16:53Two options are there.

16:54If suppose I am going to increase the dia.

16:5610 mm.

16:57135 and okay 135 I will have to provide 125.

17:02Okay with 8 mm diameter of bar 322.

17:05So we will provide maximum as 250 you know very well.

17:08Just come down.

17:09So your product depth is safe in Fletcher.

17:12Your product depth is not safe in deflection.

17:15And great difference is there.

17:17Actual span to effective depth ratio is 19.54.

17:21And permissible is 7.

17:23So great difference.

17:24Twice difference is there.

17:25So that cannot be controlled by this spacing.

17:28Anyhow you have to increase the depth.

17:31So at least I am going to increase as 150.

17:33Once we change it to 150.

17:36Now with 10 mm 154.

17:38I would have to take again 150.

17:41Now here 250.

17:44Okay.

17:45Now it is not passing.

17:46Trying to compensate it with spacing initially.

17:51So change it to 125.

17:52Next step.

17:53No change.

17:54Then 100.

17:56No change.

17:57It is 16.

17:58It is 10.

17:59We need to increase the depth.

18:01So I am going to increase the depth to 175 mm.

18:03Overall thickness of the quantity viewer slab.

18:05Here it is what 10 mm dia.

18:07173.

18:08So I am going to provide as 150.

18:11It will be like 250 it is.

18:14Now I am going to change it to 200.

18:17Okay.

18:17239.

18:18So it is what the limit we are going to provide as 200.

18:21Now 115.

18:23It is also not working.

18:24Let's try with 125.

18:2711 and 13.

18:28Very close to pass.

18:30And it will be same.

18:31No.

18:32No difference.

18:33Okay.

18:34What we can do.

18:35So let's 200 overall thickness of this slab.

18:37No.

18:38189.

18:39I am going to change it to what.

18:41175.

18:42And this will be 200.

18:44Let's check.

18:45Still not passing.

18:46150.

18:47Still not passing.

18:48125.

18:50No it is passing.

18:52Here.

18:52Span to effect to depth ratio.

18:54Actual is 11.9.

18:55Almost 12.

18:57Permissible is 13.

18:58So actual is less than of your permissible value.

19:01That's what.

19:02Okay.

19:02Your product depth is safe in deflection also.

19:05Now just move down.

19:07Your design is safe in shear also.

19:09Your design is safe in cracking also.

19:12Your design is safe.

19:13Again the check for the cracking.

19:15Now this is what the design is done.

19:16That slab number what.

19:18It is slab number 5.

19:19So I am going to give the label.

19:21To this slab as S5.

19:23Okay.

19:24Now overall thickness is what.

19:25Two ended.

19:26And it is what.

19:2710M diet is passing of 125.

19:30Along the shorter span.

19:31Along the longer span.

19:328M diet is passing of 200.

19:34Okay.

19:35Now just click over the.

19:36Send to schedule.

19:37Previously it is what.

19:38Two slabs are there only.

19:40Now I am going to click here.

19:41The send to schedule.

19:43So it is going to be updated.

19:44The third slab.

19:45As S5.

19:46With its design values.

19:48As thickness reinforcement.

19:49Both direction and panel.

19:51Okay.

19:51So in this way.

19:52You can use this spreadsheet.

19:54For the designing of.

19:55All the different types of the slab.

19:57And this shear toe.

19:58Will also.

19:59Give the detailing for the two way slab.

20:01How to detail it in plan.

20:03And how to detail the one way slab in plan.

20:05And also.

20:06Will give the sectional details.

20:08And also.

20:09Will give the sectional detail for the cantilever slab.

20:12So on this edge.

20:14Near the.

20:14Or at the face of the.

20:16Supporting beam or column.

20:18You can use the overall depth.

20:19As two-handed.

20:20And at the cantilever edge.

20:22You can reduce the depth.

20:23For the economy purpose.

20:25Because the maximum movement.

20:26Is going to be generated.

20:28At the support.

20:29Maximum movement.

20:30So we are going to provide.

20:31The depth.

20:32Required depth.

20:32For this maximum movement.

20:34And we are going to what.

20:35Reducing the depth.

20:36Towards the edge of the slat.

20:38So this is what the option.

20:39To achieve the economy.

20:41Okay.

20:41That you can do.

20:42As for your convenience.

20:44So detail.

20:45You can see from this sheet.

20:46As well as.

20:47You will get the.

20:48Schedule from this sheet.

20:49So this sheet.

20:50Is overall.

20:51Capable of designing.

20:52All the different types of the.

20:54Slab.

20:54Hope that you all understood.

20:56And thank you for watching.

20:57This video.

All Types of Slab Design Using Smart Excel Sheet | IS 456-2000 | Civil Solution

Category

Transcript

Smart Design Excel Sheets

Recommended