Manage Agile Projects with Microsoft Project AND Save Time Using Macros in Microsoft Project

1. MPUG India Chennai: Manage Agile Projects & Save Time Using Macros Manage Agile Projects with Microsoft Project AND Save Time Using Macros in Microsoft Project B Sai Prasad, PMP®, PMI-SP®

2. MPUG India Chennai: Manage Agile Projects & Save Time Using Macros Learning Objectives • At the end of this session, you will be able to do the following tasks. • Manage Agile Projects using Microsoft Project • Use summary tasks to define Springs with fixed dates and duration • Create Backlog of stories and move Stories to Sprints • Alias / customize Project fields to define story points, velocity • Record detailed user stories for each Story • Identify who does what and resource overallocations • Analyze and compare the planned velocity with the current velocity • Macros in Microsoft Project • Record and run a simple macro • Enable or disable macros • Describe Project Object Model objects, properties, methods and events • Use objects, properties, methods of objects in macros

3. MPUG India Chennai: Manage Agile Projects & Save Time Using Macros Topic 1 - Manage Agile Projects using Microsoft Project

4. MPUG India Chennai: Manage Agile Projects & Save Time Using Macros Agile / Scrum / XP / Lean Subway Maphttp://guide.agilealliance.org

5. MPUG India Chennai: Manage Agile Projects & Save Time Using Macros Agile Concepts • Iterative Development Process • A series of “Sprints” • Scope included in the Sprint is fluid • Story Points • Story Cards used for describing capabilities • Groomed backlog • Velocity and Burn down Charts

6. MPUG India Chennai: Manage Agile Projects & Save Time Using Macros g http://www.applitude.se/

7. MPUG India Chennai: Manage Agile Projects & Save Time Using Macros Map Agile Concepts to Microsoft Project

8. MPUG India Chennai: Manage Agile Projects & Save Time Using Macros DEMO

9. MPUG India Chennai: Manage Agile Projects & Save Time Using Macros Sprints, Backlog and Stories • Sprints and Backlog • Insert Summary for the Backlog and each Sprint • Set the Task Mode to Manually Scheduled • Schedule it to start on particular date • Enter the duration of each Sprint • Stories • Insert detail tasks in Backlog • Set the Task Mode to Auto Scheduled • Use the task id to prioritize the tasks

10. MPUG India Chennai: Manage Agile Projects & Save Time Using Macros Sprint Number, Story Points, Story Cards • Sprint Number • Alias the Number 1 field. • Type the likely Sprint where the story should be • Story Points • Alias the Duration field to Story Points • Change the label to Duration using File > Options • Story Cards • Use the Task Notes to record the details • Split the Gantt Chart and display the Task Form with Notes variant

11. MPUG India Chennai: Manage Agile Projects & Save Time Using Macros Velocity, Points Indicator • Velocity • Insert a “Number 2” column and customize the field • Write the formula = [Duration]/480 (convert it to days!!) • Rollup sum to its summary task (Sprint) • Points Indicator • Insert a “Text 1” column and customize the field • Write the formula = iif([Duration]/480=1, "No Story Points", iif([Duration]/480<=8, "Low", iif([Duration]/480>=18,"High", "Mid"))) • Use the graphical indicator to display image

12. MPUG India Chennai: Manage Agile Projects & Save Time Using Macros More … • Validate the Spring schedule • When tasks are moved into Sprint, you may be alerted • Who does what? • If resource is over allocated, red color stick man appears

13. MPUG India Chennai: Manage Agile Projects & Save Time Using Macros Topic 2 - Save Time Using Macros in Microsoft Project

14. MPUG India Chennai: Manage Agile Projects & Save Time Using Macros Macro • If you perform a task repeatedly in Microsoft Office Project, you can automate the task with a macro. • A macro is a series of commands and functions that are stored in a module and can be run whenever you need to perform the task.

15. MPUG India Chennai: Manage Agile Projects & Save Time Using Macros Developer tab • For convenience make the Developer tab visible • Choose File > Options > Customize Ribbon

16. MPUG India Chennai: Manage Agile Projects & Save Time Using Macros Record a macro • In Developer tab, click Record Macro • Type the name of the macro without spaces • Select the store location and row/column references

17. MPUG India Chennai: Manage Agile Projects & Save Time Using Macros Macro Security • You can change the macro security settings to control which macros run and under what circumstances when you open a workbook.

18. MPUG India Chennai: Manage Agile Projects & Save Time Using Macros Microsoft Visual Basic for Applications (VBA) object model in Microsoft Project  • Application object is the top of the hierarchy. • Application object methods represent the common command functionality of the user interface. • Each Project object contains summary information, tasks, and resources. • The Project object represents an individual project or a collection of projects

19. MPUG India Chennai: Manage Agile Projects & Save Time Using Macros DEMO

20. MPUG India Chennai: Manage Agile Projects & Save Time Using Macros References • Customize fields: http://office.microsoft.com/en-in/project-help/create-a-custom-field-HA010275136.aspx • Project 2010 Object Model: http://msdn.microsoft.com/en-us/library/ff870703(v=office.14).aspx • Outlook 2010 Object Model http://msdn.microsoft.com/en-us/library/office/ff870566(v=office.14).aspx