Welcome to PMConnection

     

Menu
· Home
· The Project Management Search Engine
· Exclusive Articles

Related Sites

Related Books 1
   
Agile Practice Guide from PMI  

   
A Guide to the Project Management Body of Knowledge: PMBOK 6th Edition 2017

  
 
PMP Exam Master Prep: Learn Faster, Retain More, Pass the PMP
 
  
  
Microsoft Project 2019 Step by Step


 
Microsoft Project 2019
  

  
The Ultimate Application Administrators Guide for Project Online

MS Project: Deadline Variance
PMConnection Articles

Deadline Variance

There is a field (column) within Microsoft Project called Deadline. It is tightly integrated into the tool and performs multiple functions. One of the biggest benefits of this field is that it will allow Microsoft Project to notify you when a Finish date slips past its Deadline date. Let's demonstrate:

In the Wine Tasting Fundraising project below, you will see a Project Complete Milestone at the end of the schedule (Row 137). Notice that this Milestone has 0 days Duration and appears as a black diamond in the bar chart portion of the Gantt Chart view on the right. Friday 4/6/18 is the planned Finish date for this project. You will notice that the Deadline column has been added to this view and it currently displays NA for the Project Complete Milestone.


Let's assume that our project team and all stakeholders agree that this project schedule is realistic and achievable. With that consensus in place, copy the Finish date for the Project Complete Milestone and paste it into the Deadline field.

In the picture above it appears as if the black diamond changed to a green arrow. The truth is; the arrow is actually laying on top of the diamond. The diamond is still there, we just can't see it.

As the project moves forward in real life, the project schedule should be updated to stay in line with reality. After making an update to a task within the Planning phase of this project, all of a sudden a Red diamond with an exclamation point appeared in the Indicator column on the left. This is Projects way of screaming at you; "You have a problem!"


If you hover over that red diamond, you will see that it says "This task goes past its deadline". If you look at the bar chart you will see that the black diamond has now pushed out to the right of the green arrow.

With a little further investigation, we can see that the current Finish date for the Project Complete Milestone is now Thu 4/12/18 and the Deadline date is Fr 4/6/18. The moral of this story is that if you continue to follow this project schedule as it currently stands, you are going to miss the agreed upon Project Complete Finish date.

As the project manager responsible for completing this project on time, the next objective should be to get this project on track. But the question at this point is; how far are we off track? In other words, what is difference between the current Finish and our Deadline Finish? How may calendar/ working days are we off track? There are a number of fields in Microsoft Project that automatically calculate the variance between two fields. But here is the problem; there is NOT a Deadline Variance field. The good news is; we can create a Deadline Variance field. Here are those steps:

Insert Duration1 column


Right click on the Duration1 column heading and click on Custom Fields


Click on Rename, input Deadline Variance and click on OK


Click on Formula and input this formula: IIf([Deadline]=4294967295,0,(ProjDateDiff([Deadline],[Finish]))) Then click on OK 


The following dialogue box will appear letting you know that any existing data in this field will be deleted. Simply click on OK.


We can now see that our project has slipped by 4 days.

As a good project manager your next step should be to work with the team to determine how to reduce the Duration of the critical path by 4 days in order to get the project back on track.



Note:



Posted by webadmin on Saturday, April 20 @ 07:35:40 CDT (299 reads)
(Read More... | 5223 bytes more | Score: 5)

MS Project: Create Tasks in Microsoft Project using Google Assistant
PMConnection Articles


This article will guide the user through configuring a solution that will enable the user to create tasks in Microsoft Project using Google Assistant (or Google Home). Note that this solution does NOT require any custom code, Project Online or the purchase of a third-party add-on.

Watch short overview video here.

This solution does require Microsoft Project, Google Assistant, Trello, Wunderlist, an IFTTT Applet, Microsoft Flow and SharePoint.

The following image shows how the products are integrated and how the solution flows at a high level.


Contents:

Module 1 Create a SharePoint Task List

Module 2 Open SharePoint Task List In Microsoft Project

Module 3 Create Account in Wunderlist

Module 4 Create Trello Account

Module 5 Create Applet in IFTTT

Module 6 Create Workflow in Microsoft Flow

Module 7 Create a task in Microsoft Project using Google Assistant



Note: You may find this of value:




Posted by webadmin on Wednesday, February 27 @ 21:15:24 CST (625 reads)
(Read More... | 3746 bytes more | Score: 0)

MS Project: Create a task in Microsoft Project using Google Assistant
PMConnection Articles

This is "Module 7 – Create a task in Microsoft Project using Google Assistant", which is part of a series on "Create Tasks in Microsoft Project using Google Assistant".


30. Simply say "Hey Google, add 'determine painter' to My Project"

31. Click on >Save within the Quick Access Toolbar in the upper left corner. Microsoft Project downloads the latest information.

32. The "determine painter" task is then added to the schedule:



Note: You may find this helpful:

provide coaching on project, program or portfolio management

Posted by webadmin on Wednesday, February 27 @ 21:06:48 CST (84 reads)
(Read More... | 1400 bytes more | Score: 0)

MS Project: Create Workflow in Microsoft Flow
PMConnection Articles

This is "Module 6 – Create Workflow in Microsoft Flow", which is part of a series on "Create Tasks in Microsoft Project using Google Assistant".


27. From within Flow, click on Templates and type in "Wunderlist to SharePoint". Click on the option that says "When a Wunderlist task is created copy it to SharePoint online".

28. Click on Continue

29. Configure the flow as follows, then click on Save


See next article: Module 7 – Create a task in Microsoft Project using Google Assistant



Note: You may find this of value: 

provide one microsoft project schedule template


Posted by webadmin on Wednesday, February 27 @ 21:04:21 CST (90 reads)
(Read More... | 1603 bytes more | Score: 0)

MS Project: Create Applet in IFTTT
PMConnection Articles

This is "Module 5 Create Applet in IFTTT", which is part of a series on "Create Tasks in Microsoft Project using Google Assistant".


12. Visit https://ifttt.com (If This Then That) and create an account

13. When asked to choose at least three services, select Google Assistant, Wunderlist and Trello

14. Click on the dropdown arrow to the right of your user name and click on New Applet

15. Click the "+this"

16. In Step 1, search for Assistant and click on Google Assistant

17. The Choose trigger step will appear. For Step 2, click on "Say a phrase with a text ingredient"

18. Within the question for "What do you want to say", input 'add $ to my project'. Within the question for "What do you want the Assistant to say in response?', input 'Ok, adding task'.

19. Then click on Create Trigger

20. Click on the "+that"

21. In Step 3 Choose action service, type trello, then click on Trello

22. Step 4, click on Create a card

22. Within Which Board? Click on the dropdown and select the name of your Trello board (the one with no spaces). For List name, input Inbox

23. For Position, select Top of List. For Title, click on Add Ingredient and select TextField.

 

24. Click on Create action

 25. As a last step, you can change the name of your Applet if you like.

26. Click on Save.


See next article: Module 6 Create Workflow in Microsoft Flow



Note: You may find this helpful:


Posted by webadmin on Wednesday, February 27 @ 20:59:43 CST (96 reads)
(Read More... | 3433 bytes more | Score: 0)

MS Project: Create Trello Account
PMConnection Articles

This is Module 4 Create Trello Account which is part of a series on Create Tasks in Microsoft Project using Google Assistant.


11. Visit https://trello.com/ and create an account

12. Create a board* that has at least one list. In the screenshot below, my board is called "MyTrello" and the list is "Inbox". *Note that my original board name contained a space which caused a problem later. I recommend creating this board name with no space.


 

See next article: Module 5 - Create Applet in IFTTT


 



Note: You may find this helpful: 

provide a ms project schedule aligned to pmi


Posted by webadmin on Wednesday, February 27 @ 20:54:20 CST (111 reads)
(Read More... | 1438 bytes more | Score: 0)

MS Project: Create Account in Wunderlist
PMConnection Articles

This is "Module 3 – Create Account in Wunderlist", which is part of a series on "Create Tasks in Microsoft Project using Google Assistant".


9. Visit https://www.wunderlist.com and create an account

10. Your account now exists:


See next article: Module 4 – Create Gmail Account



Note: You may find this of value: 

provide microsoft project training


Posted by webadmin on Wednesday, February 27 @ 20:50:36 CST (97 reads)
(Read More... | 1186 bytes more | Score: 0)

MS Project: Open SharePoint Task List In Microsoft Project
PMConnection Articles

This is "Module 2 – Open SharePoint Task List In Microsoft Project", which is part of a series on "Create Tasks in Microsoft Project using Google Assistant".


5. From the SharePoint Task list, click on the List tab across the top, then click on "Open with Project"

6. Microsoft Project will open and will sync with the Task List:

7. Click on >Gantt Chart in the upper left corner

8. Place a checkmark in >Project Summary Task option in the upper right


See next article: Module 3 – Create Account in Wunderlist



Note: You may find this of value: 

help you with microsoft planner


Posted by webadmin on Wednesday, February 27 @ 20:43:37 CST (92 reads)
(Read More... | 1743 bytes more | Score: 0)

MS Project: Create a SharePoint Task List
PMConnection Articles
This is "Module 1 – Create a SharePoint Task List", which is part of a series on "Create Tasks in Microsoft Project using Google Assistant".


  1. Open your SharePoint site, click on the gear and choose Add an App

2. Click on Tasks and then input the name of your project. I input "My Project". Then click on Create


3. Your task list will be added to the Site Content. See "My Project" in the list below:


4. Click on the Hyperlink for "My Project". This task list will open:


See next article: Module 2 – Open SharePoint Task List In Microsoft Project



Note: You may find this of value:

Posted by webadmin on Wednesday, February 27 @ 20:40:12 CST (102 reads)
(Read More... | 1839 bytes more | Score: 0)

MS Project: Create Workflow in Microsoft Flow
PMConnection Articles

This is "Module 5 – Create Workflow in Microsoft Flow", which is part of a series on "Create Tasks in Microsoft Planner using Google Home".


21. From within Flow, click on Templates and type in Wunderlist

22. Click on the option that say "When a new task is create in Wunderlist cop to Planner"

23. Click on Continue

24. Configure the flow as follows, then click on Save



Note: You may find this of value: 

provide one microsoft project schedule template


Posted by webadmin on Sunday, January 13 @ 21:26:07 CST (124 reads)
(Read More... | 1787 bytes more | Score: 0)

Feature Product



Website Sponsors
"Study for your PMP exam on your phone and tablet"

"Over 20 templates for $20"

Survey
In today's climate, what is more valuable?

- PMP - Project Management Professional
- SPC - SAFe Program Consultant

Answer here, then see results from your peers.

Search This Site
Use Google technology to search the entire PMConnection website here.

Buzzword


Event Calendar

PDU's via the Web here

Total Hits
We received
31348938
page views since January 2006

Looking for Books?
Try this link!!

Need a Template?
Free Project Management and Microsoft Project Schedule Templates here!

The Project Management Mall - Now Open!

Latest Exclusive Articles
1. Project Management

2. Microsoft Project

3. PMP

4. PMO and Program Management

5. Microsoft Project Server

6. Portfolio Management

All Exclusive Articles...



Copyright 2005-2019 PMConnection.com. All Rights Reserved.
http://www.pmconnection.com a
PHP-Nuke Copyright © 2005 by Francisco Burzi. This is free software, and you may redistribute it under the GPL. PHP-Nuke comes with absolutely no warranty, for details, see the license.
Page Generation: 0.17 Seconds