Table of Contents

• Roofing Materials Header
  • Roofing Materials Header Walkthrough Video
• Roofing Materials Section
  • Roofing Materials Walkthrough Video
• Roofing Labor Section
  • Roofing Labor Walkthrough Video
• Window Materials Section
  • Window Materials Walkthrough Video
• Exterior Door Materials
  
  • Exterior Door Materials Walkthrough Video
• Wall Siding Area Table
  • Wall Siding Area Video Walkthrough
• Vinyl Siding Labor

Exterior Finishes: Roofing Materials Header, 4:35 mins

Step 01: Identify and Measure the Starter Course of the Roof

Starter Course refers to the area of every roof plane where a starter strip is laid down to begin finishing that section of roof.

1. Open the plans in Bluebeam. Both the Roof Plans and the Elevation Views will be useful for calculating the Starter Course in LF.
2. Use the measuring tool to do takeoffs of every roof edge that will have a starter strip on it.

• • One easy way to identify roof edges that will require starter strip is to look for horizontal edges that do not border a gable.
  • Roof Overbuilds are typically perpendicular to the main roof and come to a point as they run up the main roof, forming a triangle. There will typically still be a horizontal edge in these features. That plan of the roof simply gets wider as it comes to ridge of the overbuild.

3. Add the LF of the edges together and enter that number in the LF Starter Course cell of the Roof Materials Section Header.

• • This number will also be the exact quantity of Starter Course material needed for the project, not accounting for waste.

Step 02: Identify the Roof Slope in Inches per Foot

Slope is the ratio of Rise/Run. In construction, it is measured in inches per foot, and typically is represented by a single number (eg. a Roof Slope of 8 indicates that for every 1' of horizontal run, the roof rises 8").

1. Open the plans in Bluebeam. The Elevation Views should have an inverted right triangle present at the roof slopes. This triangle will give values for rise and run.
2. Enter the value given for rise in the Roof Slope cell of the Roofing Materials Section Header.

Exterior Finishes: Roofing Materials Section, 16:59 mins

Step 01: Write a Function to Pull the Size of Each of the Roofing Materials

This task requires you to write functions that will correctly pull size, unit, and cost data from a material database.

1. Enter a function into the Size cell for the Roofing Felt row in the Roofing Materials section. This function should pull the appropriate size data from the roofing databse, given a material being entered in appropriate cell of the row. This should be done using both IF and VLOOKUP functions, and should return an exact match.
2. Repeat the above step for the Size cell of all other items in the Roofing Materials section.

Note: If your function returns an n/a value, you are likely not referencing the correct database in the function.

Step 02: Write a Function to Pull the Units of Each of the Roofing Materials

1. Enter a similar function into the Units cell for the Roofing Felt, except to pull the unit data, given a material. This should be accomplished by changing the column the VLOOKUP function references.
2. Repeat the above step for the Units cell of all other items in the Roofing Materials section.

Note: If your function returns an n/a value, you are likely not referencing the correct database in the function.

Step 03: Write a Function to Pull the Unit Cost for Each of the Roofing Materials

1. Enter a function into the Unit Cost cell for the Roofing Felt row in the Roofing Materials section. This function should pull the appropriate cost data from the framing database, given a material and a correctly matching supplier being entered in appropriate cells of the row. This should be done using IF, OR, VLOOKUP, and MATCH functions, and should return an exact match.
2. Repeat the above step for the Unit Cost cell of all other items in the Roofing Materials section.

Note: If your function returns an n/a value, you are likely not referencing the correct database in the function.

Exterior Finishes: Roofing Labor Section, 3:47 mins

Step 01: Estimate the Labor Cost for Roofing Labor

This is the same process used for estimating labor for any other construction task using the NCE.

1. Ensure that the Quantity for both the specific materials and labor item in the Estimating Workbook is accurate.
2. Use the NCE to look up the labor cost for the specific labor item.
3. Repeat this process for all labor items in the Roofing Labor section not already completed.

Note: Look at the materials header to see what weight of felt is being used. You can also reference the roofing plans.

Exterior Finishes: Window Materials Section, 3:00 mins

Step 01: Find the Windows in the BasicInfo Tab

The BasicInfo tab has already been populated with the Window Schedule. Locate the section of that tab that includes the window information.

Step 02: Enter the Quantity for Each Window Type in the ExtFin Tab

1. Take the information from the BasicInfo tab for each window type and input it in the appropriate Quantity cells in the Window Materials section of the ExtFin tab. There are two ways to do this.

• • You can simply identify each window type and quantity, and input the number in the Quantity cells.
  • You can also create an equation so that the Quantity cells pull information from the BasicInfo tab for each window type.

Exterior Finishes: Exterior Door Materials, 0:59 mins

Step 01: Find the Doors in the BasicInfo Tab

The BasicInfo tab has already been populated with the Door Schedule. Locate the section of that tab that includes the exterior door information.

Step 02: Enter the Quantity for Each Exterior Door Type in the ExtFin Tab

1. Take the information from the BasicInfo tab for each exterior door type and input it in the appropriate Quantity cells in the Exterior Door Materials section of the ExtFin tab. There are two ways to do this.

• • You can simply identify each exterior door type and quantity, and input the number in the Quantity cells.
  • You can also create an equation so that the Quantity cells pull information from the BasicInfo tab for each exterior door type.

Exterior Finishes: Wall Siding Area, 3:15 mins

Step 01: Identify the Exterior Finishes on the Walls of the Structure

1. View the plans in Bluebeam to identify which of the exterior walls are finished with vinyl siding. You should be able to identify the following:

• • Front Gable
  • Left Elevation Wall
  • Left Gable
  • Back Wall
  • Right Elevation Wall
  • Right Gable

Note: Be sure to identify any small exterior wall sections between roof elevations that are covered in vinyl siding.

Step 02: Measure the Area of any Vinyl Siding Walls in the Plans

1. Use Bluebeam to do a basic takeoff measurement of the SF of all walls that are covered in vinyl siding.

Step 03: Input the SF Values into the Wall Siding Area Table

1. Navigate to the Vinyl Siding Materials section of the ExtFin tab.
2. Scroll to the right of that section to find the Wall Siding Area table.
3. Input the SF values of each of the following walls in the table:

• • Front Gable
  • Left Elevation Wall
  • Left Gable
  • Back Wall
  • Right Elevation Wall
  • Right Gable

Step 01: Estimate the Labor Cost for Missing Items in the Vinyl Siding Labor Section

This is the same process used for estimating labor for any other construction task using the NCE.

1. Ensure that the Quantity for both the specific materials and labor item in the Estimating Workbook is accurate.
2. Use the NCE to look up the labor cost for the specific labor item.
3. Repeat this process for all labor items in the Vinyl Siding Labor section not already completed.