Lesson finished
Up next: Choosing a Concrete Bridge Form by Span, Site and Construction
Unlock all 48 lessons of Design of RCC and PSC Superstructures using LUSASFull course ₹40,000 · paid
Cracking Moment and Ultimate Capacity of a Concrete Beam in Excel
A free lesson from Skill-Lync's Design of RCC and PSC Superstructures using LUSAS course, on Grow by Skill-Lync · Last updated 16 Nov 2026 · Session: “Practical Example of Concrete Section Analysis”
What will you learn in this free Design of RCC and PSC Superstructures using LUSAS lesson?
The instructor works an Excel example for a 500 mm by 300 mm beam in 40 MPa concrete with five 20 mm bars. The lesson finds a cracking moment of 26.3 kNm, an ultimate capacity of 264 kNm, checks it against a 213 kNm design moment, and tests for over-reinforcement.
- Cracking moment from I, tensile strength and extreme fibre
- Stress in steel versus concrete using strain compatibility
- Ultimate moment with a rectangular stress block
- Checking over-reinforced versus under-reinforced sections
What comes after lesson 2?
The next free lesson is lesson 3, “Choosing a Concrete Bridge Form by Span, Site and Construction” (34 min). Later in Skill-Lync's Design of RCC and PSC Superstructures using LUSAS course (paid): lesson 4, Skill Link Course on Bridge Superstructure Design; lesson 5, Performing Analysis and Adjusting Beam Dimensions in Simulation; lesson 6, Structural Checks and Calculation of Ultimate Capacity. The full course has 48 lessons (22 h 51 min of video); see the course overview or its price and syllabus.
Lesson transcript
Machine transcript of the lesson audio (lightly cleaned). Technical terms may contain errors; the video is the reference.
Okay, let's continue. So far the course has been fairly theoretical. But don't worry, we'll now look at a practical example. First, let's do a simple uncracked section calculation. Let's have a look at the section we saw earlier in the slides. It's a simply supported beam. Don't worry about the analysis of it yet. But let's have a look closer at the section that's in the middle. Let's assume a section of a given height and a given width with some reinforcement in it. We can assume, as it's uncracked, that the strains are linear and the stress is roughly proportional.
We'll ignore the fact that the reinforcement is adding to the stiffness of the section. And it's almost always safe to do that, because it's only a small area of the section. Let's assume that this section doesn't have any reinforcement and consider it as a simple rectangular concrete section. If you follow that assumption, what you can do is to calculate a very simple rectangular moment of inertia. And from your studies, you might already know that it's a simple formula of I equals W H cubed over 12.
You can find these sort of formulas in the internet for other shapes. But for rectangle, it's a really well-known example. We're assuming a 40 mpa concrete. So our FCK is 40 mpa. What we can do is also calculate the distance to the extreme fiber, which is y. It's going down from our neutral axis to the very bottom of the section, which is where the biggest stress is. We can calculate the moment of inertia from this formula. Note, I'm using Excel here to demonstrate all the calculations.
And the reason I'm doing it is because once you build this calculation, it's very easy to reuse it in other applications. A good engineer would have developed a number of similar spreadsheets for themselves to do simple calculations. You can always find other people's work, but it's always to have your own one, because you will understand it much better. Okay, now that we have moment of inertia, what we can do is apply simple beam theory to calculate a moment at which the concrete section will crack. Let's first calculate what the tensile strength of concrete is.
And from previous slides, you found that it is related to the compressive strength, FCK. And using this formula from the slide, we can derive a characteristic tensile strength, which is about 2 MPa. Now, that's a lot less than what you would expect from a compression. That's 20 times less than the compressive strength. That's the weakness of concrete. It's not very good at tension. So 2 MPa is roughly multiplied by 1,000 is 2,000 kilonewton per meter squared. And I'm converting this, because it's very useful to look at moments in kilonewton meters.
And not to do that, we need to do a unit conversion. I always recommend to stick to the same set of units. But you'll find many people use slightly different units. Always check the units when you're doing calculations. But the main thing is being consistent. So now that we know the tensile strength of concrete and the moment of inertia, we can use simple beam theory. And the Bernoulli formula for concrete, in fact, it's valid for all simple beam calculations. So what it tells us is the moment of inertia equals stress over the distance to the extreme fiber.
We can derive from this a cracking moment. So a moment will be stress times moment of inertia divided by the distance to extreme fiber. That can be calculated as 26.3 kilonewton meters. So what we've done here is we've substituted, instead of stress, a stress at which the concrete will crack, because we've just arrived it. We know that this section can not only take 26 kilonewton meters before it cracks. So if you didn't have any reinforcement, that would be your absolute limit for the section. But we rarely design sections in bending without any reinforcement.
In fact, it's very dangerous because this failure would be very brittle. We can also use this formula to derive stresses under applied moment. We can use rearrange it again to derive stress. So if you do a simple swapping, you'll see that the stress is equals to moment times the distance to the extreme fiber divided by the moment of inertia. And so we know if we apply 30 kilonewton meters to the section, we'll see 2.4 MPa of stress at the bottom fiber, which is more than our FCTK.
And that means the section will crack. But not to worry. We know that there is steel inside. What we can also use in this simple example is to derive the stresses at the reinforcing bar. So far, we have been looking at stresses here at the extreme fiber, but nothing stops us really to calculate the stress at any section using the same formula. All we have to do is use a different y value. So we can use a y value for steel, which is distance between the centroid and the steel fiber.
Assuming the cover is 50 millimeters, as we specified below, above, we can derive ys, which is going to be 200 millimeters of 0.2 meters. And if we substitute it into this formula, we're getting 1.9 MPa of stress at the reinforcing bar. So, that's less than a cracking moment, so the crack won't propagate as much. But that's a very big simplification, because as soon as the section cracks, your i value will reduce. So you need to do some clever iterative calculations to derive the real-life answer. But it is good enough for the purposes of this calculation.
What we can then do is, using similar formulas, and applying Hooke's law, which defines the relationship between the stress and strain. So that's your linear stress-strain relationship. Your stress is equal to Young modulus times the strain. And, again, this is a simplification, because both steel and concrete will behave plastically at some point. Although, for this smaller magnitude of force, that's a pretty accurate assumption, because we are assuming linear behavior. What we can then do, using this Hooke's law, is derive a stress in steel. So the stress in steel will be related to the strain in steel, to the Young modulus of steel.
But we know the strain in steel will be the same as the strain in concrete, because they're compatible. Otherwise, the two would slide against each other. That's the reason we are providing a really good bond between steel and concrete, because we don't want them to slide relative to each other, and we want that strain to be actually compatible at this point. So we're safe to use the same strain, and then we can derive the strain of concrete by taking this in reverse. So, in fact, we have Young modulus of steel divided by Young modulus of concrete multiplied by the stress in concrete.
And let's take some typical values for the Young modulus of concrete, Young modulus of steel, substitute them into the equation, and you'll find that for the same point in space, the stress in steel is 11 mPa, whereas the stress in concrete was only 1.9. But what we have learned from previous slides is that the steel is much stronger. The strength of steel is in the order of 500 mPa, and this 11 mPa value is very small comparing to that. That means that we can push the section much more by utilizing the steel in a cracked condition.
If we go back to this diagram and see what happens once the concrete cracks, you'll see that all of this tensile stress disappears, and what you'll find is all of that stress will transfer into the steel. But because you don't have the section in here anymore, what will happen is that the neutral axis will shift, your stress in concrete will increase, because your triangle is a bit smaller, and you'll start seeing that the stresses rise. What happens once the stresses rise in here is at this point you'll most likely find that the concrete will plastify, and so you'll no longer have a linear distribution.
You'll start having this sort of quadratic distribution. So what we have now is instead of this really nice linear relationship, of course ignoring the steel for simplification, now we have a much more complex non-linear relationship between steel and concrete. That requires some more clever calculations, and it's typically done by computer analysis, because it requires, rather than a few equations, It actually requires some iterations. You can set up spreadsheets to do this sort of calculation, but in most cases we're not really interested in the intermediate values between this condition and a fully utilized condition.
So this sort of calculation is useful to find out how much force it takes to crack the section. But once the section is cracked, all we really need to know is the ultimate capacitance, which is going to be calculated in the next example. Okay, now let's look at the cracked section example, where we'll calculate the ultimate capacity of a section. Let's go back to our calculation. So now we have the same beam, but what we found out is that it's going to crack in the middle.
So what we'll do is we'll ignore all of the concrete and assume that all of the tension is actually taken by the steel. But we also know that the stresses at this point are becoming way too high for concrete to act linearly. So we have to assume some non-linear behavior. Let's remind ourselves what happens when the concrete becomes non-linear. This graph becomes very handy. As we've discussed before, as the strains increase, the stresses in concrete will rise and will become non-linear. And at some point, they will reach a peak value of FCD and flatten out.
This is the assumption that is defined by the codes. But what we can do is actually simplify this diagram by assuming a rectangular section or a rectangular profile for the stress-strain relationship. And this is the easiest way to do the calculation by hand, because in order to find ultimate capacity, we need to integrate this area. And integrating something like this can be a little bit tricky. So what the scientists have done is they have derived a simplified square relationship to replace that non-linear stress block. And what we'll typically find is the height of that rectangle is 0.8 of this value of X.
And that is a well-known defined value used for the calculations. This is not precise, but engineering or civil engineering is all about making reasonable assumptions. So you can proceed with your design safely and swiftly. Okay. Using this simplification, we can calculate ultimate capacity of the concrete section. We'll use a very similar example as before. Simple beam with a rectangular section, height, width. But we also need to introduce some extra parameters, which is the depth, the effective depth. So this is calculated from the top of the section to the reinforcement.
Note that I'm assuming the cover of the bar. I'm giving it to the center of the bar rather than to the face of the bar. We'll need to also define a few other terms, such as Z, which is the lever arm between the tension stress block and the compression stress block. And X, the distance from top of the section to the neutral axis. Keeping these definitions in mind, let's go into the actual calculation. Let's first define the reinforcement, because that will affect what the capacity of the section is.
The more reinforcement, the more the capacity. The less reinforcement, the less the capacity. Let's assume five number of 20 millimeter bars. Let's define height of the section, which will be the same as the previous example. Half a meter high section by 300 mil wide. The cover is going to be 50 mil, and again, that's the center of the bar. It's just to simplify this calculation a little bit. So our distance to the center from the top is 0.45, also known as effective depth. The characteristic strength of concrete, 40 mPa, as before.
And then now we need to calculate the design of the compressive strength of concrete for this calculation, because that will define how far this block extends. What we're assuming is the steel reaches its yield capacity, and the concrete is reaching its ultimate capacity here. So this point is defined by the FCD, which is from the previous slide, defined as 0.67 times the characteristic value divided by factor of safety. What you'll notice is this is a lot less, less than half of the characteristic compressive strength of concrete.
And that is because concrete is such an unpredictable material on site, and that's why we want to be safe and apply a good factor in it to make sure that the capacity is definitely on the safe side of that probability curve. The yield stress of steel will assume as 500 mPa. And again, we need to apply some factors of safety, just to make sure that we're on the safe side. And that's typically defined as 1.15, giving us the strength of 435 mPa. Notice the difference in terms of the magnitude of reduction from the factor of safety.
In concrete, it's less than half, but for steel, it's only a small reduction, 15% reduction. The average of the bars and the number of bars. This allows us to calculate the area of steel, using normal geometric formula. And then, assuming that the bars have yielded, we can calculate the amount of tension that's in these bars. And the amount of tension in these bars is going to be defined by the design yield strength and the bar area. This gives us about 682 kN, or 680,000 N of force.
So what we can do now is that, because of equilibrium, that tension must be resistant by equivalent compression in the concrete. So we can assume that this value C is equal to T, otherwise the section would move sideways, which is not happening, as we know from physics. So we're assuming the same 682,000 N for the concrete. What we're looking at now, forgive this remark, this should be here. And what we can do is, now that we know this compressive force, we can calculate how far this block actually extends into the concrete.
Because we know that this block will be at the maximum capacity of concrete in terms of stress, and we know the widths of the section, we can now derive a height of this section, which is going to be defined by the compressive force divided by the stress. So we'll find first the area of this concrete here. And once we know the area, we can then calculate the height, hx, which is going to be that 0.8 of x here. So that's the height of block C. That allows us to derive the lever arm Z, which is the effective depth minus half that height.
So we know the lever arm Z is the distance between this tensile force and the compressive force. Now that we know this, we can calculate the ultimate moment capacity, which is going to be lever arm times the force, and it's equal to 264 kNm. Note how this is a lot more than what we've calculated here for uncracked section. Now uncracked section, the cracking moment is about 26 kNm, whereas the full capacity is almost 10 times that. Now let's do a simple calculation to actually verify this beam.
Assume this beam is carrying its self-weight and some live load. We know the area of concrete, so we can calculate the weight of concrete. We know that the weight of concrete with the reinforcement can be assumed as 25 kNm3. The pure concrete can vary in density depending on the aggregate size and cement. It also depends on the amount of reinforcement you put in. The more reinforcement, the denser your concrete is going to be, the heavier it is going to be. But a common value to assume is 25 kNm3.
So our dead load can be calculated by area times density. This gives us weight per unit of length. Let's consider now the factor of safety for dead load. If you remember from earlier slides, we need to apply the factor of safety in ultimate limit state to make sure that we are on the safe side, even with our loading. Let's put some live load in it. Let's say 8 kNm per meter. And we need to apply some factor to it as well. A typical live load factor is 1.5.
So let's use that. Our total load is going to be dead load times the factor of safety for dead load plus live load times the factor of safety for live load. That gives us... 17.1 kN per meter of factored load. Assume that the beam is 10 meters length, and the design moment can be calculated from our usual formula, W, or Q, L squared over 8. That's a formula you can find on the internet, and I'm sure you've come across it in your previous studies. That's to calculate the moment in the center of a simply supported beam.
That gives us 213 kNm, which is less than our design resistance of 264 kNm. That means that our beam is okay, and it's not fully utilized, which is always good to know. In theory, you'll find that you can push the beam to the limit of 1, but in practice, you'll often want a little bit of extra room just to be on the safe side. Now you know how to calculate ultimate capacity of concrete. And the beauty of doing this sort of calculation in Excel is, for example, if you put more live load on it, you'll know that this section is still okay.
Or if you put even more, you know that it will fail. So it's a really good exercise to do, and I strongly recommend that you go through it step by step and understand how it works. The key assumptions here is that we're assuming that the steel has yielded, and the concrete has reached its strength. So this is the very, very limit of this section, and this has given us the ultimate capacity. There are ways to derive intermediate steps between the ultimate and the cracking moment, but those steps are requiring some iterative computations.
And in reality, all you really need to know is the ultimate capacity. Another check that we need to do before we completely satisfy ourselves with this is the check of over-reinforced versus under-reinforced section. As we've seen from previous slides, if the concrete section is over-reinforced, it can fail in a very brittle way, because the concrete will crash before the steel yields, and we definitely want to prevent that. So far, we've only satisfied that we have enough reinforcement so that it doesn't fail. But having too much reinforcement is totally possible.
And the way we can do it is to make sure that this x, which is the distance from our top of section to the neutral axis, is less than about 0.4 or 0.45, depending on the code of practice. We can use our previous calculations to derive this value of x, because we know the depth of compression block, and this is equal to 0.8x, we know that x is going to be 160 mil, whereas the depth of the section is about 450. The ratio is 0.35, which is okay, which is less than 0.45, defined by some codes.
If, for example, you put too much reinforcement, like 25 millimeter bars, what will happen is the x becomes much deeper, and it actually is exceeding 0.45 deep. And that means that you're risking of crushing the concrete before the reinforcement yields, and it's not a really good way of designing a section. What you'll find is, because of different detailing rules, like the spacing of bars and other requirements, you'll rarely reach this limit. So if you reinforce your section sensibly, you'll never reach that. But it's always worth checking to make sure that your structure will show signs of failure before it actually fails.
You can also scroll down and see that because we increased the size of the bars, our utilization has reduced considerably. We can also reduce the size of the bars from the original calculation to, say, 16, and you will see that the capacity is exceeded, and that's not enough reinforcement. So this is really a fine balance between not being over-enforced and not being under capacity. This is the end of the example. Let's go back to our slides, where I can tell you more about how to apply this knowledge in concrete bridges.
Let's go back to our slides.