G'day and welcome back to Buildsum and in this video
We've actually been through now and we've set up all our formulas and we've actually come up with a total
For our sheet, and I'm just going to bold that answer. I like the main answer to be bold and
Italicize it so it stands out and when I did that I realized I made a mistake
I actually realized that I had a 110mmfor the thickness of our slab when the plan
quite clearly says a 150 so
This is a really good mistake to make because I can actually show you how the sheet works now
So the idea is that because we've set this all up to calculate itself if I just change that
150
You'll see that that answer there changed
they've actually
taken that
down to here
all right, and it's calculated our new total so
You know a silly mistake that would take ages to recalculate in on a calculator
it's very quick to fix in in a
sheet or an Excel type program
Okay. So now that that's been fixed. What we want to do next is we actually just want to finish off
with the the total up here
so in a
Estimating sheet the total or the answer. It doesn't go at the end of your description or end of your calc
So it goes back up
next to your description
So the unit is what you're going to basically what you're gonna buy or purchase the material and so concrete is meters
Cubed, okay, it's priced in meters cubed. I'm just going to justify that and I can vertically align it as well
Put it up there and should do that for all of these
so Center
and vertically aligned and
So the quantity when we do a quantity in an estimated street, we don't worry about point anything
We just want to round it up to the next whole number
So there's lots of little functions in this function tab
so there's a few ones I use quite often, but there are
hundreds
of Functions that you can do, okay
And you can look through there and you can do you know google help and find out what they all do
But if you know what some of them do you can you can pick them up pretty quick so I know
In here that there's a roundup function. So if I just go equals and start typing roundup
It'll come up
Okay
So you can actually put in some rules and a bit later and some other videos
We might look at that. But all I want to do in this case just simply round up to the next whole number
so I'm just going to select the roundup function and
Then I'm gonna scroll down and select the cell where I want my answer to come from
So that's it there that tells me straight away that that's going to round that up to 17, which is what I want
So I'm just going to hit enter on that
Go back up and my quantity there is 17. Okay. It's that cell down there rounded up
In here, I'm gonna put in my rate
So I'm gonna say $300 a cubic meter for the concrete and we want to put that in dollar signs
So if you come over here, these are our formats
You can see you got the old pound sign there and it's percentages and that sort of thing if you go on the more formats
area
Once you've used it once or twice
Ones that you use commonly will come up here
Alright, so I could just pick Australian dollar but you guys probably won't have it there. You'll have to get into this more formats
go to more currencies and
Search through find Australian dollars sitting there at the top for me and apply that
So that's come up as $300 with the right money symbol on it, and then we just need to get a total
so our total for this particular job is going to be the 17 times the 300 so
Select where we want the answer hit the equals sign
17
star for times the 300
equals and we get some a total of
$5,100 for this particular job. Okay. So in the next video, we'll just have a look at completing our
Estimating sheet the next
item and
Totaling up those items and then we can have a look at
creating a summary 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