G'day and welcome back to Buildsum and in this video we've so far we've done the volume of our slab
We've done the volume of our footing and now we just have to do the volume of our rebate that we're going to take away
and
Essentially that is going to be the exact same
formula and
process as we just did for the footing except our
0.555 is going to change to
100mm
For the width of our rebate. So what I'm actually going to do I'm gonna select that whole
Area that we just heard that last calculation on I'm gonna go ctrl C or you can right-click and go copy
Going to come down here and I'm gonna paste that back into it
now this is obviously the footing that was the footing so I'm gonna change this to the rebate and
Because this is all built up on formulas. The only thing I have to change is this cell here and
That figure there changes. I need to make that three decimal places and I need to copy that down
Okay, so that's changed automatically now that's changed my links
I've got the actual length over there that's transferred over there because that's what the formula told it to do
And just need then to change my width
Which is 0.1 and my depth, which is 0.1 one
Okay, and we've now recalculated the
Rebate just done like that. So there's the answer for the rebate there. All right, just because we already had that formula
Basically built in I'll make I'm gonna make that red because that just reminds me that in the scheme of things. That is a reduction
Okay
Now the way I've set this sheet up what we can actually do now. Well, what I should do is I'll write this out properly
So we're gonna have the total
So the total is gonna be
Equals the
Volume of the slab which is that cell there
So I just hit enter on that that brings that down to there
Times no, sorry, it's gonna be plus
space plus
The volume of the footings, so if I go equals that one there
Bring that down there minus
The volume of the rebate so
Equals
Enter
Alright, and as I said, I just do that so I know what steps I've carried out
but the magic is going to be in this actual formula, so
Come over here. Again. That's where I want. My answer. I'm gonna go equals
this number
plus
this number
minus
this number
Enter
That gives me the total
volume of concrete that I'm gonna have in my
slab
So in the next video we'll go through and actually work out
How to complete the
estimate estimating sheet
G'day, I'm back
Just let you know that if you like this video you can subscribe to my youtube channel, or you can follow me on Facebook
So you don't miss out on more great videos