Alt & VE Log

Download Data File:  PR3 Data

1. Open the file name PR3 Data, then Save As PR3 Alt & VE Log.
2. Select cell A1 and enter your First and Last name after “Project Name”.
3. Change cell A3 to read, “Date of Issue for Baseline Estimate:”. Then put 1/25/2020.
4. Enter the current date in cell A4 after, “Date of Issue:”.
5. For cells D7, D9, D11, D13, and D15, enter 1/5/2020.
6. For cells D8, D10, D12, D14, and D16, enter 1/12/2020.
7. Center data for D7:D16.
8. In Column C, click on the arrow to the right of the cell to Approved the following Item #’s: 001, 004, 009, and 010.
9. In Column C, Rejected the following Item #’s: 002, 005, and 008 using the arrow to select Reject.
10. In Column C, select Item # 003 as Pending.
11. In Column C, select Item #’s 006 and 007 as Add Alt.
12. Enter an IF FUNCTION for Cell H7. IF C7 = Approved, then the quantity from G7 will appear in H7; otherwise use “” to leave the cell blank.  Use copy/fill and select “fill without formatting” for cells H8:H16.
13. Use the same method from  #12 but and create an IF function “Pending” and “Add Alt” for columns I and J, respectfully.
14. Bold cells H7:J16. Also, bold cells H17:J17, H19, H21, H25, H26, and H29.
15. Merge & Center cells A1:B1. Do the same for A2:B2, A3:B3, and A4:B4.
16. Change the recent Merged & Centered cells to Light Orange, 40% – Accent2. Bold these same cells.
17. Select the range C7:C16 and click on Conditional Formatting to create Highlight Cell Rule for Text that Contains “Approved“.  Use “Green Fill with Dark Green Text“
18. Save the file and confirm that all content fits on a single page.
19. Go to File, then Print, change the orientation to Landscape, change the scaling to Fit Sheet on One Page
20. Save your file; close Excel.
21. Submit file as directed by instructor.