ARPC Maintenance Department Toolbar
Accordance to requirements of the petrochemical industries :
This is a completely free and open source software in order to develop ...
Thanks to Arak Petrochemical Co ( ARPC ) Maintenance Department colleagues.
Software specifications :
The software includes a toolbar and several Excel files to work with Microsoft Project.
SCurve for Microsoft Project , Jalali Date , Weighting.
- Preparation and Tracking Projects using Microsoft Project Earned Value.
- Use of Jalali Date.
Main features :
- View dates in Jalali calendar.
- The function of weighting based on three factors, Duration, Relative weight and Cost of resources.
- Ability to work with Sub-projects.
- Set physical progress by One-to-One and One-to-Many method.
- Adding and removing activity after updating actual progress without causing any problem in the scheduling calculations.
- Presenting Planned progress and Actual progress in specific date by applying weight factor.
- daily S-Curve charts is available for end of a day or specific time in a day for project summary task or specific task.
- A statistical table presents the status of major project activities.
- Update MS Project file by Excel.
MSP 2007 SP3 or MS Project 2010 SP1 or MS Project 2003 SP3
Excel 2003 or any later version
Video : /SWF/
In the name of god
ARPC Maintenance Department Toolbar
- Rabi Javadian
- Accordance to requirements of the petrochemical industries:
- Abbas Barani
- Translation editor:
- Hamid Tahmasebi
This is completely free and open source software in order to develop...
Thanks to Arak Petrochemical Co (ARPC) Maintenance Department colleagues.
A) Earned Value introduction
Earned Value in this software:
- Earned value is a method for planning and controlling projects based on weight of a cost and status date.
- Earned Value (EV) = Budgeted Cost of Work Performed (BCWP)
- Planned Value (PV) = Budgeted Cost of Work Scheduled (BCWS)
- Actual Progress = BCWP / Cost
- Baseline Progress = BCWS / Baseline Cost
- The time when BCWS change from zero to a grater number it means "planed start".
- The time when BCWS equals to Baseline Cost it means "planed finish".
- The time when BCWP change from zero to a grater number it means "actual start".
- The time when BCWP equals to Cost it means "actual finish".
C) Install Toolbar
- In order to install the toolbar first close MS Project then run setup when it finished click Install Certificate then follow Wizard until the message "The import was successful" appeared.
1. Jalali (Shamsi - Persian Calendar) Optional
- Converts date and time from Start, Finish, Baseline Start, Baseline Finish, Actual Start and Actual Finish to Jalali date. (If time equals to 00:00 just date is converted)
2. Jalali (Shamsi - Persian Calendar) Date and Time
- Converts date and time from Start, Finish, Baseline Start, Baseline Finish, Actual Start and Actual Finish to Jalali date.
3. Jalali (Shamsi - Persian Calendar) Date
- Converts date from Start, Finish, Baseline Start, Baseline Finish, Actual Start and Actual Finish to Jalali date.
4. Set Progress Date (One-To-Many)
- Specify date to set or get Actual Progress or get Planned Progress, it is necessary before you set actual value. (You can update many activities in specified date just by physical percent complete.)
5. Update Tasks One-To-One
- Set actual progress one by one, by Jalali (Shamsi - Persian Calendar) date.
6. Add Selected Tasks With Change Plan
- Add or edit task in a baseline after project is started. (Note that changed baseline must declare with new revision number.)
7. Top Down Weighting
- To weight and set baseline. (Default weight factor is duration unless use resources or Number1 field has a value.)
- Send tasks to excel with outline level.
- Subtasks numbering in order to better tracking.
- Apply setting for MS Project and tasks.
- After entering tasks and predecessors or constraints click Top Down Weighting (7) button from toolbar.
- If "Resource Sheet" has a resource even not assigned to a task, MDT assumes that the mode is "resource cost weighting", indeed cost of assigned recourse is task weight and tasks which have not resource having a zero weight.
- If there isn’t any resource in "Resource Sheet" and field "Number1" has a value then MDT assume that the mode is "comparative (relative) weighting".
- If there isn’t any resource in "Resource Sheet" and field "Number1" has not any value then MDT assume that the mode is default "duration weighting".
- After scheduling and weighting and saving and closing MS Project then open "Persian SCurve & Status for Microsoft Project.xls" and for following:
- Set MS Project file path with name and extension.
2. S-Curve for
- Set S-Curve for project summary task, task with a specific name, task with specific ID or task with specific UID.
3. Until Time
- Choose one option: until end of a day or specific time in a day.
4. Plan Curve
- Draw plan S-Curve.
- When you want to have S-Curve with a several day interval then hide related rows in "CData" worksheet then click "Recalc Daily".
Set Progress date once then apply to many tasks:
- Click set progress date and specify a date
- Set progress exclusively in a physical percent complete (actual start and actual finish will get value automatically)
Tasks are updated one by one:
- Click "Update tasks One-To-One" in a specific task you should set actual start and actual finish or progress in a specified date.
- Notice than you should not edit actual start or actual finish because they get value by physical percent complete.
- In method "One-To-Many" first set progress date then set physical percent complete.
- First set specific date by "+" or "-"buttons then click "actual curve daily" (for first day to draw actual curve it is enough to click "actual curve daily".)
- Tasks which added or canceled should be specified in added or canceled fields by set that tasks to "Yes".
- Enter major activities in TData worksheet.
- Set current progress date and click "daily activities status".
Two methods are available:
- After entering task and predecessors it is enough to set "physical present complete" in specified date in this mode task has, "remaining", "in progress" or "completed" situation but it is not roll up at summary and in order to show weight of added tasks use the "physical present complete" of similar tasks in the same group.
- After entering task and predecessor or edit previous tasks first select that tasks and click "Add selected tasks with change baseline".
- In this situation probably cumulative actual progress is less than its previous value.
- In MS Project from insert select project and insert that project, after scheduling, manually expand and collapse WBS and click "Top Down Weighting" button from toolbar then in "Persian SCurve & Status for Microsoft Project.xls" set new path and …
- For roll up statistical table use sub-projects excel files, open Status Rollup.xls then once specify excel files path and click green button after this opening the file is enough to update data.
- For converting to Jalali (Shamsi) type (1) and (3) if start time is 00:00 then the same date will be converted but if finish time is 00:00 the previous day will be converted to Jalali.
Start: 2012/02/25 00:00 Jalali start: 1390/12/06
Finish: 2012/02/25 00:00 Jalali finish: 1390/12/07
- Before entering actual progress, set progress date.
- Do not enter or edit actual start and actual finish fields and instead of it use "Update Tasks One-To-One" button from toolbar.
- Date and time in jalali fields are just text and when you click "Jalali Date" or "Top Down Weighting" button they result from Gregorian date.
- If you don’t use resources and don’t prefer to use comparative weighting then be sure that resource sheet has not any resources and field number1 has not any value.
- Before get report by excel files save MS Project, close it and don’t open it until job done because when you run excel files MS Project will be closed automatically without saving.
- Don’t use project summary task but insert summary task for the project manually.
- For beginners it's recommended that use standard calendar otherwise consider "project calendar", "task calendar" and "time scale calendar".
- Requirements to install MDT: MS Project 2007 SP3 or MS Project 2010 SP1 or MS Project 2003 SP3.
- Returning to plan for projects that have actual progress is difficult and its better to save a backup.
- In case of appearing scheduling conflict message choose continue scheduling conflict to go on.
- If you want to draw S-Curve for whole project doesn't forget to choose S-Curve for project summary task.
- Values for Actual progress and planned progress and physical percent complete are updated by progress date.
1. Parian Co.
Tracking projects by Earned Value
Babak Mahmoudy Majdabadi
2. Farasaran Co.
Persian Calendar for Excel
3. VBA Programming in Microsoft Project