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.
-
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.