Completed

Write a MS Project VBA Macro to Create a Summary Schedule

This project was successfully completed by Kryptora for $250 USD in 7 days.

Get free quotes for a project like this
Employer working
Completed by:
Project Budget
$30-$250 USD
Completed In
7 days
Total Bids
6
Project Description

Overview
The task is to create a Microsoft Project Macro that will automatically create separate summary schedule from details contained within the base schedule. A numbers column is used in the base schedule to indicate the tasks and summary tasks that need to appear in the summary schedule. A text column is used in the base schedule to indicate the predecessor and successor linking that needs to appear in the base schedule.

Creating the Summary Schedule
• The summary schedule shall be created in a separate instance of Microsoft Project (i.e. not within the same project).
• The project standard calendar for the summary schedule shall be the same as the base schedule
• The summary schedule calendar options for Hours per day, Hours per week and Days per month calculations shall be the same as the base schedule
• All tasks in the summary schedule shall be auto scheduled.
• Column Number1 in the base schedule contains either a 0,1 or 2 against each task. 0 represents that the tasks is not to be included in the summary schedule. 1 represents that it is a summary task (or level 1) in the summary schedule. 2 represents that it is a normal task (level 2) in the summary schedule.
• Summary schedule level 1 task names shall be a dynamic link to the corresponding task name in the base schedule.
• Summary schedule level 2 task names, start dates, finish dates and % complete shall be a dynamic link to that of the corresponding task in the base schedule.
Predecessor Links
• The summary schedule predecessor links for each task shall be captured in the Text26 column of the base schedule.
• The predecessor text in the base schedule will indicated the base schedule task ID.
• A comma will separate multiple predecessors

Formatting
• The gantt chart bar for each group of level 2 tasks in the summary schedule shall be coloured a different colour.
• The order of colouring for each group shall be:
1. 4626167
2. 13020235
3. 10642560
4. 5880731
5. 5066944
6. 12419407
7. 8210719
8. 5474707
9. 16738047
10. 6750156
• If there are more than 10 groups of tasks in the summary schedule the colouring shall start again from the top.

Saving
• Once created the summary schedule shall be saved.
• The summary schedule file path shall be the same as the base schedule.
• The summary schedule file name shall be the same as the base schedule with the addition of the word “Summary” and the date. The format shall be: base schedule file name & “- Summary – yyyymmdd”

Rights
• I shall be able to view, update and change the macro once it has be submitted
• All rights to the code shall belong to me

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online