1.6 Scored Assessment
Alt & VE Log
Download Data File: SC1-Data
Alternative & Value Engineering Log: You are a Junior Estimator for a large construction company. The Lead Estimator for an upcoming project needs a place to store all of the possible cost impacting items related to the project. You are tasked with creating a spreadsheet that all items can be entered into and decisions can be managed with just a few clicks of the mouse. You will create multiple columns to keep track of each decision made for each item.
- Open the file named SC1 Data and then Save As SC1 Alt & VE Log
- Select Cells A1:A4 and set the font to Cambria.
- Select all cell locations in Sheet1 by clicking the Select All button in the upper left corner of the worksheet.
- Set font size to 12 points. Then click any cell to Deselect.
- Select cell A1 and enter your First and Last name after “Project Name”.
- Change cell A3 to read, “Date of Issue for Baseline Estimate:”.
- Enter the current date in cell A4 after, “Date of Issue:”.
- Select cells A6:J6, make these cells bold, and increase the font size to 14 points.
- Increase the width of columns B, D, E, F, G, H, I, and J so all entries in those columns are visible.
- Select cell A7, click and drag to AutoFill cells A8:A16.
- Click on Auto Fill Options and select “Fill Series”. Center the content for cells A7:A16.
- Use the Home tab of the Ribbon to change cells F7:F16 to read as prices by selecting the drop-down in ‘Number’ Format’ and select Currency. Decrease decimal setting by two since no cents are involved .
- In cell G7, enter the = sign, click on cell E7, enter the * sign, click on cell F7, then hit “Enter” to calculate the Budget Amount.
- Copy this formula for cells G8:G16.
- Put a border around cell A6:J16. Select these cells, go to the Font Tab, click the Outline drop-down and select “Thick Outside Borders”.
- Center the cell contents for cells A6:J6.
- Align cells F18:F29 to the right.
- Use a Thick Outside Border for cells D17:H29. This area will help to visually high key cells of the spreadsheet used in the future.
- Do the same for the cell ranges of I17:I29 and J17:J29.
- Decrease the decimal point for cells G18, G20, G22, G23, and G24 by two.
- Bold the following cells, G17, F19, F21, F25, F26, and F29.
- Change the color of cells D17:J17 to be White, Background 1, Darker 15%.
- Do the same for cells D19:J19, D21:J21, and D25:J25.
- Change the color of cells D26:J26 and D29:H29 to be ‘Orange’.
- Decrease the width of column D to 16.71, Increase the height of row 6 to 37.50 and Wrap Text for cell D6.
- Change name of the sheet to “VE & ALT Log”.
- Confirm that all content fits on a single page.
- Go to File, then Print, change the orientation to Landscape, change the scaling to Fit Sheet on One Page.
- Save and close the workbook.
Attribution
Adapted by Barbara Lave from How to Use Microsoft Excel: The Careers in Practice Series, adapted by The Saylor Foundation without attribution as requested by the work’s original creator or licensee, and licensed under CC BY-NC-SA 3.0.