Task Plan Result field will display error if there are any.Enter Hours Required to complete the task.Enter Project Name (that the task belongs to) and Task Name.Step 3: Enter Tasks’ information Project Planner (Advanced) Excel Template – Tasks If there are no errors in data, then it will display ‘Planned’. Project Plan Status gives instant feedback on whether there are any errors associated with the Project.This is the cost other than the resource cost which will be calculated by the template.If Preferred End Date is left blank, project will be considered completing ‘ontime’ if it is estimated to complete.Enter Preferred End Date (date by which the Project should end).If Preferred Start Date is left blank, Planning Period Start Date will be used. Enter Preferred Start Date (date before which Project should not start).If two projects are given equal priority value, the tasks are ordered based on task priority and then the order in which they appear in the TASKS table. If Project Priority is left blank, the project will not be included in plan.For example, project with Priority 1 will be given importance and scheduled first before scheduling Project of priority 2. Project Priority is used to determine the order of scheduling tasks.Step 2: Enter Projects’ information Project Planner (Advanced) Excel Template – Projects Project Planner (Advanced) Excel Template – Settings – Resource Leave This will be used to calculate the availability of resources that will drive the schedule. Enter any personal leave each resource will take. Enter hours that the resource will take for leave. Project Planner (Advanced) Excel Template – Settings – Company Weekends and HolidaysĪ. Template will not schedule any work during weekends and holidays. Choose Yes for weekdays which are usually company’s weekends.Ĭ. Project Planner (Advanced) Excel Template – Settings – ResourcesĪ. This will be used in calculating project costs. Enter the cost per hour for each of the resource. Enter their regular availability for each weekday.Ĭ. Project Planner (Advanced) Excel Template – Settings – Periodī. This is the duration in which the template will plan the projects. The Settings sheet contains important information elements that the template would use as inputs.
0 Comments
Leave a Reply. |