Project for Excel™ provides Microsoft® Excel users with a tool to design, develop and manage an Project within the Microsoft® Excel environment. This will reduce training cost to learn yet another program. The program can be used to generate the following charts:

• PERT - Program Evaluation and Review Technique
• CPM – Critical Path Method
• GANTT

Project for Excel™ is a fully functional program developed using Microsoft® Excel. This product is an integral part of the Microsoft® family of products and will allow you to import and export data, charts, and reports between all Microsoft® products.

• Generates the Affinity Diagram for all Activities automatically.

• Utilizes the Affinity Diagram visualization, to check the Network Activity Diagram connectivity.

• Generates the project plan in MS Excel with dynamic Critical Path calculation

• Develops your project plan either in numbers or actual workdays with option of adding user-defined holidays.

• Creates PERT Chart, Gantt Charts with automatically generated Critical Path.

• Utilizes your knowledge of Microsoft® products in analyzing you solutions.

• Communicates your results to the World Wide Web or Intranet directly (MS Excel 2000 Version).

• Imports and Exports results to and from MS Project

Projects  can become very complex but they force the manager to contemplate personnel assignments for the project in detail. At the same time, the best- and worst-case project scenarios, can be identified by defining the duration time as part of three time estimates:

• Most Optimistic Time,

• Most Likely Time,

• Most Pessimistic Time.

Based on these data, the program automatically calculates and plots the probability of success of the project with 95% or 99.9% confidence.                            

Activity Network Diagram and PERT charts can be used within an organization for detailed evaluation planning. The Automatically generated Critical Path highlights important interim deadlines that must be met if the overall evaluation study is to be completed on time.

Enter Headers, Activity, duration and Web information in the familiar Excel workbook environment.

Generates the Affinity Diagram for all Activities automatically.

Utilizes the Affinity Diagram visualization, to check the PERT connectivity.

PERT (Program Evaluation and Review Technique) charts were first developed in the 1950s by the Navy to help manage very large, complex projects with a high degree of inter-task dependency. Arrows connecting independent tasks reflect the relationships between the tasks it connects. The relationship usually shows dependency where one task cannot begin until another is completed.

Generates the project plan in MS Excel with dynamic Critical Path calculation.

The Gantt chart, developed by Charles Gantt in 1917, focuses on the sequence of tasks necessary for completion of the project at hand. Each task on a Gantt chart is represented as a single horizontal bar. The horizontal axis is the time scale over which the project will endure. Therefore, the length of each task bar corresponds to the duration of the task, or the time necessary for completion.

Update the %done and review the Gantt chart

.

Based on these data, the program automatically calculates and plots the probability of success of the project with 95% or 99.9% confidence. 

Download and test the program from here.