G'day and welcome back to Buildsum and in this video a little bit of a break from tradition
I'm not going to do any Sketchup
Instead I'm gonna show you how to use Google
sheets
to set up an estimating page and
eventually, we'll get through and put some formulas in it and
actually
combine multiple sheets
Into a summary page, but just for the first video. What I'm gonna do is I'm going to show you how to
Set up the columns and the rows and then we'll get into the calculations a little bit later on
So what I've done here is I've opened up a Google sheet
and at the top here, you can call it what you
Whatever you'd like to call it. I'll call this one Buildsum Estimates
So that's named and because this is a Google sheet
It'll be automatically saved. But if you're using Excel, you'll have to save that
Separately by hitting that at all Save button
A lot of the functions, even though I am using Google sheets will translate into Excel
Definitely the functionality. What it will do is the same there
Maybe just a different button or a different symbol or just a slightly different way of actually going about it in Excel
So if you don't have Google sheets, which you should because it's free. If you want to use Excel you can
Things will be fairly similar
Okay, so for our estimating sheet I'll need
six columns
However, one column which is going to be my particulars column. I actually want to make that up out of nine
Nine cells or one nine cells in that column. So I'm just going to three four five
Seven eight nine. So all I'm doing there
it's I'm clicking on and holding the mouse down and
I'm selecting the columns that I want
Six seven eight nine. Okay. So once I've selected the columns, I want this little symbol here. We'll merge those cells together
Okay, so they all become one cell. Okay. Now I don't need them all to be the same size. So
you can just hover over the break in the columns and you can close them up and you'll see why a
Little bit later on while closing these up like I am
And we'll be able to move them in and out as we need to
Okay, and then pretty much the rest of the columns are just what they are so this column here
I'm going to call that the item column
Okay, so that's just how we number the items so we can identify them this column here is going to have all our information
so this is going to be the
particulars
Column so I'm just selecting on the column and typing and if you want you can't select
one or multiple of those and
This little button here and horizontal align
Will let you move that into the middle of the column
and you can do that with
all of these
This column over here will be the unit. What unit of measure we're going to measure
calculate in this will be the
Quantity
And then we have the rates or the actual price and then we're gonna have a total
Okay, so that's the actual
units or the headings that we want we can select all eyes and put them all into the middle in one hit and
We can also select all of those
Select them all and if you hit the bold
Symbol we can bold them up so because they stand out as headings
And then also because they're a heading I might just put a border around them for now so you can go to borders
We want a box around everything that we've selected. So whether this option
And we want it to be a fairly thick line
It's gonna here and I'll pick the thickest line. So then we have a little particulars box
Okay, so that gives us our
heading and we can select just
by clicking and holding
as many of these as we need
And we can then put a line around them again if the borders select the pattern so I want all the line selected
And I don't want the thicker ones for this. So I'll just go back over here and
Hit the thinner line
That gives us some thinner lines for our box
Okay, and because we had that top once I liked it picked that again, so let me just go back into here
select that
because I only want the outside border I can go to this option
And select the thicker line again and it'll come back like that. Okay, so that's basically
Setting up the actual table
in the next video, I'll go into the process of
Starting to fill it out and some basic
calculations
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