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 (2×4) 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
8×16= 128
1 0
8
1 2 3 4 5 6 7 8
9 studs have 8 units of 16:
8×16= 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 (2×4) 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
Lets 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 2×4. 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.5×2)=3
(1.5×2)=3
3
3
1 0
8
?
89.5 + (3x2) = 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 2×4 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 doesnt extend to the center of those studs. See red lines on the wall detail vs. blue lines
(5×16)-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.
https://support.office.com/en-us/article/use-autosum-to-sum-numbers-543941e7-e783-44ef-8317-7d1bb85fe706
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 its 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 its 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
https://creativecommons.org/licenses/by/3.0/
Finding the right measurements
Why use Excel
Process
Measurements of physical wall
Open new spreadsheet to record measurements
Columns
Objects Column
Slide Number 8
Copy and Paste
Add borders to cells
Slide Number 11
Rows
Slide Number 13
Tools:??We are going to format columns using a group (called numbers) and the group dialog launcher
Slide Number 15
Format the cells in each column
Slide Number 17
Entering measurements
Slide Number 19
Slide Number 20
Slide Number 21
Slide Number 22
Slide Number 23
Slide Number 24
Slide Number 25
Slide Number 26
Slide Number 27
Slide Number 28
Slide Number 29
Slide Number 30
Slide Number 31
Slide Number 32
Slide Number 33
Slide Number 34
Slide Number 35
Nominal vs. Actual
We have 2 top plates. What are the dimensions?
Slide Number 38
Slide Number 39
Slide Number 40
Slide Number 41
Slide Number 42
Slide Number 43
Slide Number 44
Slide Number 45
Slide Number 46
Slide Number 47
Slide Number 48
Slide Number 49
Slide Number 50
Applied Sciences
Architecture and Design
Biology
Business & Finance
Chemistry
Computer Science
Geography
Geology
Education
Engineering
English
Environmental science
Spanish
Government
History
Human Resource Management
Information Systems
Law
Literature
Mathematics
Nursing
Physics
Political Science
Psychology
Reading
Science
Social Science
Liberty University
New Hampshire University
Strayer University
University Of Phoenix
Walden University
Home
Homework Answers
Blog
Archive
Tags
Reviews
Contact
twitterfacebook
Copyright © 2022 SweetStudy.comSWEETSTUDY.COM YOUR HOMEWORK ANSWERS
chat0
Home.Literature.
Help.
Log in / Sign up
Excel sheet
profile
ahmed98
Findingtherightmeasurementss1.pdf
Home>Architecture and Design homework help>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 (2×4) 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
8×16= 128
1 0
8
1 2 3 4 5 6 7 8
9 studs have 8 units of 16:
8×16= 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 (2×4) 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
Lets 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 2×4. 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.5×2)=3
(1.5×2)=3
3
3
1 0
8
?
89.5 + (3x2) = 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 2×4 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 doesnt extend to the center of those studs. See red lines on the wall detail vs. blue lines
(5×16)-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.
https://support.office.com/en-us/article/use-autosum-to-sum-numbers-543941e7-e783-44ef-8317-7d1bb85fe706
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 its 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 its 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
https://creativecommons.org/licenses/by/3.0/
Finding the right measurements
Why use Excel
Process
Measurements of physical wall
Open new spreadsheet to record measurements
Columns
Objects Column
Slide Number 8
Copy and Paste
Add borders to cells
Slide Number 11
Rows
Slide Number 13
Tools:??We are going to format columns using a group (called numbers) and the group dialog launcher
Slide Number 15
Format the cells in each column
Slide Number 17
Entering measurements
Slide Number 19
Slide Number 20
Slide Number 21
Slide Number 22
Slide Number 23
Slide Number 24
Slide Number 25
Slide Number 26
Slide Number 27
Slide Number 28
Slide Number 29
Slide Number 30
Slide Number 31
Slide Number 32
Slide Number 33
Slide Number 34
Slide Number 35
Nominal vs. Actual
We have 2 top plates. What are the dimensions?
Slide Number 38
Slide Number 39
Slide Number 40
Slide Number 41
Slide Number 42
Slide Number 43
Slide Number 44
Slide Number 45
Slide Number 46
Slide Number 47
Slide Number 48
Slide Number 49
Slide Number 50
Applied Sciences
Architecture and Design
Biology
Business & Finance
Chemistry
Computer Science
Geography
Geology
Education
Engineering
English
Environmental science
Spanish
Government
History
Human Resource Management
Information Systems
Law
Literature
Mathematics
Nursing
Physics
Political Science
Psychology
Reading
Science
Social Science
Liberty University
New Hampshire University
Strayer University
University Of Phoenix
Walden University
Home
Homework Answers
Blog
Archive
Tags
Reviews
Contact
twitterfacebook
Copyright © 2022 SweetStudy.com
