Write a MS Project VBA Macro to Create a Summary Schedule

IN PROGRESS
Bids
6
Avg Bid (USD)
$242
Project Budget (USD)
$30 - $250

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

Skills required:
Microsoft, Project Scheduling, Visual Basic
About the employer:
Verified
Public Clarification Board
Bids are hidden by the project creator. Log in as the employer to view bids or to bid on this project.
You will not be able to bid on this project if you are not qualified in one of the job categories. To see your qualifications click here.


Hire bharanisrihari
$ 250
in 10 days
$ 250
in 7 days
$ 350
in 15 days
Hire chirag01
$ 250
in 15 days
Hire ismarodri123
$ 150
in 5 days
$ 200
in 10 days