Step 2: Prepare the Excel 2007 Spreadsheet
For CPM computations, you need three main headings: Activities List, Duration of Activities, and possible activity paths. Open Excel 2007 and enter the headings as shown in the image below. Next, under the Activities heading, enter a list of activities, as shown below. Under the Duration heading, enter the duration of each activity. For example, the Purchase Plot activity (cell B2) will take five days. Therefore, enter 5 in cell B5. Similarly, enter the duration of each activity as shown in the image below. Now, input the paths identified under the Paths heading. To do this, input 1 for all activities that are in Path 1. For example, Path 1 has the Purchase Plot, Select Design, Purchase Wood, and Assemble Shed activities. Therefore, you will input 1 in cells B8, C8, D8, and J8. For all activities that are not in Path 1, enter 0. Therefore, cells E8, F8, G8, H8, and I8 will contain 0. Refer to the image below for the inputted data as per the Precedence Diagram.