G'day and welcome back to Buildsum and in this video. We're just going to keep going with the estimating sheets
And we're actually going to do an item. We're going to work out the concrete for this little
slab and the strip footing
So the first thing I'm going to do is I've got to put a row in above this heading
so I'm just going to select on that row there and then right-click and
Go insert one above so we have a new row above and I'm gonna call that
the trade
Because we're gonna have a sheet for every trade so I'm just going to put trade there and then over here I'm gonna go concreter
Okay, and you'll see when I click out of that. Let's cut it off and that's because it doesn't fit into this little
Cell or the B column
So what I'm just going to do is just gonna select a couple of columns a couple of those cells
And I'm gonna hit the merge
And then I'll bring it up so it's in full text. Okay, so then when we do our
estimating sheets, the first row
Is where we put our description of our job so we have to label them as well
So we should tell which description we're talking about. So I'm going
to call this "A"
and you will notice it has come up centred. So if you want to Center it, I'll move it around you can
Justify it right justify it left justify it or sender justify it
Okay, and that will do it for the cell if you want to do the whole column
Select the column and do the same thing. Okay, that'll move everything over in the whole column
okay, so next thing in the particulars column, I want to write a description and
So I'm going to write it. I'm just going to select all those cells in there and I'm going to merge them all together
so my description fits and
I've already written that I'll just cut and paste it into there. So this is pretty easy my descriptions not that long
We're just doing a 30 MPA concrete to slab
and strip footing
Okay, but you could have more infromationlike you know, direct poured from truck
You know or you know pumped you know
Whatever the delivery method have to be you could have more information in there
If you got to a point where the actual text was running off the page
And what I'll do, I'll just keep cutting and pasting this in here until that happens
Okay, so see how that's gone past the end of the cell and let's cut it off
so what you can do is you could just select that cell and go up here to text wrapping and
Just go to the wrap
Item wrap symbol and select that so that wraps the word back onto the next line
Make cell cell bigger and we're all good to go
Okay, I'm just gonna make this a bit smaller. So it's not taking up too much space
Okay
So we've got our description in so then we want to firstly let's do the volume of our slab
So we'll just put it all heading up here
So this area here is going to be for the slab and we'll do the slab
volume
All in one hit
Okay
make that a Capital
Okay, so the volume is obviously the length
Times the width times the thickness so the length of our slab is 10.2 meters long
it's
Were going to times. So I always put a times symbol in there
it's 6.3 meters wide and
Times the thickness of the slab which in this case is a 110mm so 0.110m
Okay, wo thats got the italics on it so I'll take that off
Okay
so
See how some of them come up with three decimal places some haven't
You can change that around by using this one here increase or decrease the decimal points
So if I want three decimal places, I just hit that two more times
That one's all right. This one I need an extra one
so just increase so I've never all those figures showing me three decimal places, so
Then I want to equal this so I'm just gonna if I just type equals
With sheets and Excel it thinks you want to do a formula
So it actually brings up this little tab and it does all sorts of weird stuff if you keep going
So the easiest way to do an equal sign is just hit the shift key
Sorry the space key first and then the equals symbol and you'll just get an equal symbol, okay?
So I put this I just put these in so now I know what the calculations are actually doing
I'm getting you know, I'm not using these to calculate it's just there so I know one of what I've done
So over here, I'm gonna do that whole calculation in one hit
So I've got my I'm gonna select where I want my answer to appear
I'm gonna hit the equals sign and
That little symbol comes up and then I'm gonna select the first cell that I want to put in my sum
so the 10.2
and see how here it comes up with d5, which is
column D Row five and
It tells me 10.2 will be the total answer okay to multiply with sheets and Excel. You just hit the star
symbol and
Then you're going to select the next cell that you want to include in that calculation, and then I want to times again
So the star symbol and the next cell and once I've got all the cells in there
I need just gonna hit equals and that will give me my answer. So that's actually two four decimal places
So I'm just gonna decrease my decimal places and I'll get my answer to four decimal places
and
I'm gonna make that indoor italics just so it stands out a bit
So that is the volume for the slide in the next video
I'll show you how to do the volume for the actual footing
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