Microsoft Project: Add formula into custom field

I need to make report that shows how the delay of task affects the others. So, I save the baseline and shows it in the timeline of Microsoft Project. To be more visible, I want to add the custom field that shows how many days the tasks is delay from the original schedule. Here are the steps to add the calculated custom field.

Environment: Microsoft Project 2010
  • First of all, you need to save "Baseline" for the original schedule to compare with the change. Select "Project" tab. Then click at "Set Baseline..." and "Set Baseline...".
  • There will be "Set Baseline" pop-up screen. Click at drop down list and select "Baseline". You can choose any Baseline number depends on how many Baseline version you want to save. Click "OK" to save Baseline.
  • To show Baseline in Timeline, select "Format" tab. Then, select "Baseline" button and select "Baseline". You can select other choice if you save into other Baseline number. Baseline will be shown in the timeline panel.
  • To show the date value in the text panel, right click on the header of the column. Then, select "Insert Column" at the context menu.
  • Select the value that you want to show in text panel. In my case, I want to compare the original schedule that I have saved in Baseline. Therefore, I select "Baseline Finish".


  • To assign the title name, right click at the header of the column that you added. Select "Field Settings" in the context menu.


  • In "Field Settings", add title name that you want into "Title" textbox. If the title is long, you can check and "Header Text Wrapping". Click "OK" button to save the value.


  • I added "Finish" column to be side by side with Baseline and revise the new finished date.


  • Now, add the calculated field by right click at header of any column and select "Custom Fields" in the context menu.


  • Inside "Custom Fields" pop-up screen, Select "Duration" in "Type" drop down list.
  • Select "Duration1" in "Field" list. Click at "Formula..." button.
    • Another pop-up screen "Formula for " will be appear. Click at "Function" dropdown button. Select "Microsoft Project" group and then, "ProjDateDiff( date1, date2, calendar )" function.


    • The function syntax will appear in text area. Highlight "date1" in the syntax and click "Field" drop down button.


    • Select "Date" group, "Baseline Finish" group and then, "Baseline Finish". 


    • "date1" will be replaced with the selected field name. Highlight "date2" in the syntax and select "Field" drop down button again.
    • Click "Field" drop down button, select "Date" group and then, "Finish".


    • "date2" will be replaced with the selected field. Delete ", calendar" parameter and then, click "OK" button to save the value.


    • Click "OK" button to exit from "Custom Fields" pop-up screen.
    • Right click at the header area and select "Insert Column" in the context menu.
    • Scroll down until found "Duration1". Select it.
    • Right click at the header area of the field at just added. Then, select "Field Settings" in the context menu.
    • Assign name in "Title" text box. In this case, I name it like "Amount of changed day". Click "OK" button to save.

    • The column that just added will appear and show the different of day between Baseline and the revised plan.


    Reference: http://blog.jackvinson.com/archives/2009/11/05/tech_tip_how_to_show_calendar_day_duration_in_ms_project.html

    Comments

    Post a Comment

    Popular posts from this blog

    Microsoft Visio: How to set default font

    Image
    Microsoft Visio doesn't have the easy way to set its default font and size. Please follow these steps to make change of your drawing. Environment : Microsoft Visio 2007 Solution No. 1 : Set default font and size from Style Note that this solution will not apply to the drawing that you change to specific font. - From menu bar, select 'Tools' and then 'Options...'. - In 'Options' pop-up window, select 'Advanced' tab. At 'Advanced options', check 'Run in developer mode' and press 'OK' button. This option will allow you to select 'Define Styles...' sub-menu. - Draw some drawing and select it. At the menu bar, select 'Format' and then select 'Define Styles...' sub-menu. - In 'Define Styles' pop-up window, at 'Style' section, the default style name will be selected automatically follow by the style of the drawing that we selected befo
    Read more

    LINE: Change the contact name

    Image
    People use some other name to represent themselves in LINE. To search them, you might not be able to remember what name they are using. You can just change the displayed name to what you call them. Follow these steps to change it. Environment : Application: LINE version 3.1.7 O/S: Android Ice Cream Sandwich 4.0.4 Device: Samsung Galaxy S III Press at the friend that you wan to change the name. Press at the pencil sign in the pop-up screen. It will show you the textbox to override the name. Type in the name that you want to call your friend and press "Save". Scroll down or search the new name you just defined.
    Read more

    Microsoft Word: Make picture background to be transparent

    Image
    If you want to make your picture background to be transparent but don't have any tool. Microsoft Word also provide the simple tool for that. Environment : Microsoft Word 2010 - Select the picture that you want to make the background to be transparent. The menu "Picture Tools" -> "Format" will show in the main menu. - Click at "Format" menu. It will show the sub-menu. Click "Remove Background" button. - Menus under "Background Removal" will be shown as below. In the picture, purple area is the transparent area. - Adjust area that you want to make transparency. - Click at "Mark Areas to Keep" button and mark at the areas that you don't want to be transparent. - When finish marking area, click "Keep Changes" button to keep the change. - The result will be as below.
    Read more