The Project Management Template is a generic, Excel-based solution to plan and manage any project. The project budget is updated as tasks are defined and modified. Automatic timing and Gantt chart creation is driven from participant availability and task dependencies. Individual participant workbooks can be generated for remote update and then batch imported to update project progress reporting. Project performance is monitored with earn value analysis throughout the project life cycle. The Excel Project Management template functions seamlessly across versions of Excel for both Mac and Windows as a cross platform project planning and management solution. The Project Planning and Management template provides the ability to define the project budget as tasks are defined. Project phases, task titles, holidays and other key project parameters can be predefined to accelerate work flow. Task dependencies and timing constraints are taken into account for the automatic calculation of task timing. A project Gantt schedule with daily, weekly or monthly intervals is created with embedded task information. The project status report details overall project progress based on Earned Value Analysis with trends displayed for cost and schedule performance indices. Individual workbooks with task lists for each project participant can be generated and subsequent batch import function used to automate the update of the project progress and status. The Project Planning and Management template is compatible with Excel 97-2013 for Windows and Excel 2011 or 2004 for Mac as a cross platform project management solution.
