Excel sheet

h e ig

h t

Real wall • Dimensions of the physical wall system

How much are you reducing it

by?

• Scaled to smaller size

Model • Dimensions for model

1. Enter height in B2 2. Enter width in B3 3. Enter depth in B4

1

2

3

Click on A1. Do not release.

Pull down gray box to G43

1

2

3

Click on All Borders4

Merge every 3 cells in columns A & G, starting in row 2.

On the Excel sheet, list the object components shown on the wall detail as the rows in column A.

The numbers group is further right on the Excel ribbon.

1. Click on the column letter (A in this example) to highlight to entire column.

2. Look at the format box in the number group on the ribbon.

3. There is a drop- down arrow in the format box.

4. Click the dialog launcher at the edge of the number group.

1.

2. 3.

4.

Choose “general” for all columns except “decimals to inches”

1

2

3

4

1. In the “decimal to inches” column, click on the “F” column header 2. Click the number group dialog launcher 3. Click on fraction 4. A type box will appear. 5. Click “up to two digits (21/25) 6. Click “ok”

5

6

Finished wall

h e ig

h t 9’ AFF to ceiling

ceiling

above finished floor (AFF)

1 0

8 ”

1’=12”

9’ = (9 x 12”) = 108”

108”

width

To determine the length of the wall, we need to calculate the number of studs behind the sheet rock (gyp board).

108”

1 2 3 4 5

6 7 8 9

From outside edge to next stud center

9 (2x4) studs

108”

9

9

1 2 3 4 5

6 7 8 9

How far apart are each of the 9 studs?

1 2 3 4 5

6 7 8 9These studs are spaced 16” apart. 1. Studs on the outside of the wall

are measured from the far edge to the next stud center.

2. Studs between the two outside studs are measured center to center.

1 2

16” 16”

1 2 3 4 5 6 7 8

9 studs have 8 units of 16” between them

8x16”= 128”

1 0

8 ”

1 2 3 4 5 6 7 8

9 studs have 8 units of 16”:

8x16”= 128”

This is different than the number (146) I gave in the first PPT.

128”

Finished wall height and length.

We will come back to the depth later.

1 0

8 ”

?

9 Wall studs (2x4) • 5 long • 4 cripple • 9 total studs

1 2 3 4 5

1 2 3 4

Enter the quantities • There will be one completed

wall • Within the wall there will be 9

studs • 5 of the studs will be full

height • 4 will be cripple studs

How can we find the stud height?

?

?

In order to find the stud height, we need to understand the difference between nominal & actual lumber measurements

AND we need to find heights of:

1. top plate (x 2) 2. header 3. board between header

& head 4. LvL head 5. bottom plate

Let’s get back to finding the long stud height:

1. We now know the top plate dimensions (x 2)

2. The bottom plate dimensions is the same as the top plates, but there is only one.

3. We need to multiply the height 3x (1 for each plate): (1.5”) x 3 = 4.5”

4. The 5 long studs are the height of the finished wall (108”) minus the combined height of the plates (4.5”) 108”-4.5”=

5. 108”-4.5”=103.5”

1. Enter the long stud height (103.5”) on the spread sheet. (There is a way for Excel to calculate this automatically, if you want to explore the sum formula function.)

2. The studs are 2x4. Which dimension is the width? Which is the height?

3. Notice in the illustration that the 4” side is nailed perpendicular to the 4” side of the top and bottom plates. That means, for this project (based on slide 3), the 2” side is the width and the 4” side is the depth nominally.

4. Fill in 1.5” as the actual width of the long studs on the spreadsheet.

5. Fill in 3.5 as the actual depth. 6. You can also fill in these measurements as the width and

depth of the cripple studs.

These are the stud dimensions we have so far. How are we going to find the height of the cripple studs?

?

These are the stud dimensions we have so far. How are we going to find the height of the cripple studs?

8 9

.5 ”

(1.5x2)=3”

(1.5x2)=3”

3 ”

3 ”

1 0

8 ”

?

89.5” + (3”x2) = 95.5” 108” – 95.5” = 12.5” Cripple stud height = 12.5”

Enter 12.5” as cripple stud height.

Now how can we find the trimmer dimensions?

• The trimmer height is the same as the rough opening = 89 ½ =89.5

• They are made from 2x4 boards. • 89.5Hx1.5Wx3.5D

89.5 1.5 3.5

.5

Recommended gypsum board is ½” (0.5”). The height and width are the same as the finished wall (108Hx128Wx0.5D).

Now we need the header width.

• The header width equals the 5 spaces between the cripple studs, (measured 16” center to center). We need to subtract ½ of the width of the two end studs because the header doesn’t extend to the center of those studs. See red lines on the wall detail vs. blue lines

• (5x16”)-1.5”=78.5”

1 2 3 4 5

Now that we have the majority of information, we can fill in the remainder of the spreadsheet.

For instance we know that the top and base plates are 3.5” deep and the gyp board is 0.5” on each side of the base plates.

That gives us 3.5” +(2 x .05”) = 3.5 + 1 = 4.5” for the depth of the finished wall.

This is also the depth of the rough opening for the pocket door.

After filling in the quantities, we can now move on to get the measurements of our scaled model.

https://support.office.com/en-us/article/use-autosum-to-sum-numbers- 543941e7-e783-44ef-8317-7d1bb85fe706

The above link will give you additional information about the AutoSum function.

Enter .25 in D2 as the factor. Place your cursor in E2. Click on AutoSum. It will automatically put a dashed box around C2-D2. The cells will show up in the comment bar above as SUM(C2:D2), which will add the two cells together.

Use your cursor to change the colon to an asterisk (* above the numeral 8). This will create the formula 108*.25 and the answer will appear in the cell.

Click on D2 and pull the tiny box at the bottom of the highlighted cell all the way down to D40. Do the same thing with E2. Your spreadsheet will look like this.

The final thing we need to look at is converting decimals back to inches so it’s easier for you to cut your model pieces.

Click on D2 and pull the tiny box at the bottom of the highlighted cell all the way down to D40. Do the same thing with E2. Your spreadsheet will look like this.

The final thing we need to look at is converting decimals back to inches so it’s easier for you to cut your model pieces.

Click in your cursor in F2.

After you click into F2, click AutoSum. A dashed highlighted box will fill E2 and enter a formula in F2. Press Enter. 27 will appear in F2 and F3 will be highlighted. Click back up into F2. Hover your cursor over the tiny green box until a cross appears. Click on the cross and pull down the highlight box to F40. This will bring the number from the model measurement from column E. It will be formatted as a fraction rather than a decimal because of the formatting we did early on.

We have what we need to begin cutting pieces for our models.

And Ta-Dah!!!

This Photo by Unknown Author is licensed under CC BY