European Collaboration Summit 2017 approaching fast!!!

 

Hi all,

I’m proud to announce (as one of the Organizers) a GREAT, GREAT conference

Be part of a three-day community-driven conference in Zagreb with the most influential experts from all around the world to discuss the latest news regarding Microsoft technologies. Topics vary from novelties in Office 365, Azure, SharePoint, Exchange, Skype, and Project. Here’s what it’s all about!

The European Collaboration Summit 2017 is a nonprofit event and will take place in Zagreb, Croatia on May 29-31, 2017.

So what else do you need to know?

Well, namely that you will get to hear incredible speakers deliver the most exciting lectures, attend pre-conference workshops, and get a chance to mingle among consultants, admins, developers, business people, nerds, speakers, MVPs, masters, and fellow Microsoft employees.

What makes the ECS a special and unique event?

We’ve had this idea that we could combine the ethos of the SPC Adriatics Zagreb and Office 365 Conference Germany and Nordics. This means that we’ve decided to combine the experience gained with SharePoint and Office 365 community events, and create the best event in Europe.

Also, it’s a kind of conference that has the legendary Microsoft Office Development Patterns and Practices Team (PnP), an awesome party after the closing ceremony, and pretty cool prizes from our sponsors–you know those gadgets you know you want to but never get around to actually buy one for yourself. How cool is that?

Let’s get down to business, shall we?

I’d like to name a few interesting lectures that you will get to hear and of course much more.

· Cool Dashboards, Charts and Visualizations for Power UsersBenjamin Niaulin will discuss how to build, interesting dashboards, charts, animations, data visualizations, KPI, and much more with out of the box features and products.

· Introduction to Microsoft Flow: Power to the peopleSerge Luca and Isabelle Can Campenhoudt will give an overview of what is Microsoft Flow, its current functionalities and the roadmap.

· PowerApps & the Common Data Model for ITPros, Admins and ArchitectsNicki Borell will talk about the vision of Microsoft business application platform innovation with PowerApps and the Azure cloud platform.

· Working with OneDrive for BusinessHand Brender will explain the implementation of Next Generation Sync Client (NGSC), the limitations and the competitors.

· Exchange Server 2016 – Have you upgraded yet? Vladimir Meloski will guide you through the architecture changes in 2016 and how to prepare, test and deploy Exchange 2016 in your organization.

· Azure for Office 365 developers – the best bits – Chris O’Brien will dig into the most relevant Azure capabilities, using real scenarios to show winning combinations such as SharePoint web hooks and Azure functions.

Refer to this agenda for a detailed list of lectures and get ready for the be mind-blown with “what is new” and “best practices” sessions guiding you through the changes happening in the IT world right now.

Save your seat now, visit us in Zagreb and join in on the discussion about the perspectives for business users, developers and IT Pros, and how the digital workplace is changing as we speak!

2016-06-02-01h26m13_thumb

Posted in Uncategorized | Leave a comment

Placeholder field in MS PROJECT 2016

Hi,

in MS PROJECT 2016, there is on, not so often used, field – Placeholder. Let me create new Project with three Tasks:

image

As you can see, Task 1 and Task 2 are Manually scheduled, and Task 3 is Auto scheduled. Now I will include Placeholder field in Gant Chart View, and I will get:

SNAGHTML192f836a

First of all, if Task is Auto Scheduled, Placeholder field is always = Yes. Furthermore, Placeholder field is read only, so you can’t change it. OK. For Task 2, and Task 3 Placeholder is Yes. Why? Well, Task is placeholder if it cannot be scheduled. So if I put, for example, 3 days to Duration field for Task 1, I will get:

image

Placeholder field is still = Yes, because for Task 1 we know that it will has 3 days Duration, but we do not know when will it start and when will it finish. So, I will put 21.2.2017 into Start Date for this Task, and I will get:

image

Because MS Project knows Duration and Start date for this Manually scheduled Task, it can calculate Finish Date, so now this Task is scheduled, and Placeholder is set to No. I will put Start and End date for Task 2, and I will get:

image

Again, since MS Project knows Start and Finish date, it can calculate Duration, and Task is Scheduled, so Placeholder is set to No.

So, it is easy to understand how Placeholder is set. you may wonder when to use it? Suppose that you have a Project with, for example, 750 Tasks. Some of them are Auto scheduled, and have TBD in Start date field, or duration field, etc. Those are placeholders. And, by simple filtering Tasks where Placeholder = YES, you can find out which Tasks are not scheduled yet, and they are bottleneck for finishing your schedule.Very useful Field, from my point of View.

Regards.

Posted in PRoject Management, PMI, MICROSOFT PROJECT, Microsoft Project 2013, MS PROJECT 2016 | Tagged , , | Leave a comment

Status Indicator in MS PROJECT 2016

Hi,

there are some fields in MS PROJECT 2016, which are very useful but not so often used. One of them is Status indicator. What does it work? I will explain it in a simple example. First I will create simple Project with three Tasks:

image

Notice that Project Start Date is 06.02.2017. And Actual date (e.g. Current date) in my example is 07.02.2017:

image

Now, I will add two fields in the Gant View: Status and Stratus Indicator.

image

Before I explain Status Indicator field, I will change Current date to Wednesday, 08.02.2017, and I will make Task 1 100% Completed. So, I will get:

image

So, Status can be: On Schedule, Late, Future Task, or Complete. I do not have to explain what each of them mean. Status Indicator is graphical representation  of Status filed, and it can be:

  • If Status is Complete, Status Indicator = check mark
  • If Status is Future Task, Status Indicator = blank
  • If Status is On schedule, Status Indicator = clock with a check mark
  • If Status is Late, Status Indicator = clock with an exclamation point.

So use those fields because they are showing you status of your Tasks/Project in a simple way.

Regards

Posted in MICROSOFT PROJECT, MS PROJECT 2016, PMI, PRoject Management | Tagged , , | Leave a comment

Default Assignment units in Microsoft Project 2016

Hi,

I’ve got a question form one of my Blog readers: “I noticed that the generic resource is only used with 100% (default value) instead of the 140% or 240% (depending on the time when the task be processed). I also read one of your articles, which described that the max. units can only be manually adjusted per task. Is that the only option?”

I will explain this with MS PROJECT 2016! First of all I will create wo Resources: Developers with Max. Units = 200%, and John with Max. Units = 50%.

image

Now I will create a simple Project with three Tasks:

image

Finally I will assign Developers and John to all three Tasks, through Gantt Chart View:

image

Finally I’ll have:

image

Now I am going to Switch to Resource Usage View, and I will add two Columns on it: Max Units, and Assignment Units:

SNAGHTML4445be9c

As you can see, Microsoft Project will automatically assign Units to the Task (Assignment Units), following two rules:

  1. If Max units for Resource, at given moment is equal or greater than 100%, Assignment Units = 100%
  2. If Max units for Resource, at given moment is less than 100%, Assignment Units = Max Units at given moment for particular resource

So, Developers are assigned with 100% (see rule #1), and John is assigned with 50% (see rule #2).

Now, how can you change Assignment Units for all Tasks. For example, you want to put 200% for all Tasks for Developers. Because this is not video, I will show you one way to do that:

SNAGHTML44532e9d

and you will get:

image

So, that is the easiest way, if you do not want to deal with writing Macro.

Hope this helps!

Regards!

Posted in Micsrosoft Project 2016, MS PROJECT 2016, PMI, PRoject Management | Tagged , , , , | Leave a comment

Update the task as 100% without changing work hours automatically in MS PROJECT 2016 – is it possible?

Hi,

I’ve got very good question from one of my Blog Readers: “How can I do to update the task as 100% but without changing work hours automatically? Because I want to know that my team is more efficient than expected.”

Basically we are speaking about Work, and Actual work in MS PROJECT 2016! What is problem here. For example, if you need 40 hours for Task, and you finish it in 32 hours, you want that those 40 hours of Work remains unchanged, but % Complete, and % work Complete to be 100%. Well, this is not possible, but there is a solution in which you can see that team is more efficient than expected.

I will create Simple Project, with one Task 5 days Duration, and I will put 40 hours in work field:

image

Now I am going to create John as a Resource and I will assign him to the Task:

image

and:

image

Notice that I’ve used Task Usage View in the picture above.

Now I am going to save this as a plan, or Baseline:

image

and:

image

OK! Now let’s say that John has spent 32 hours on the Task and the Task is finished. I will use Task  Usage View, and click on John under the Task:

image

And I will get:

image

So, as you can see Actual Work and Work are equal. But this does not make comparison impossible. I will now use Work Table, and I will get:

image

and:

image

As you can see, Variance is –8 hours, and this shows that real work was 8 hours less then planned. You can also add some Custom field to see, for example, that efficiency is Baseline / Actual * 100%, so in this Case it will be 40/32 * 100 = 125%, etc.

To conclude when you change Actual work field, Work field is also changed. If Task is finished 100% then Remaining work is 0 hrs. BUT! If you save the Baseline before you put any Actuals, you can get Efficiency if you compare Actual work with Baseline Work field.

Regards

Posted in MICROSOFT PROJECT, Microsoft Project 2013, Micsrosoft Project 2016, MS PROJECT 2010, MS PROJECT 2016 | Tagged , , | Leave a comment

Units field in Resource assignment – MS PROJECT 2016

Hi,

I’ve got a question from one of my Blog readers: “Max units field in Assign Resources are always in %? I want to use QTY instead of %, like we have 10 cranes available, and how many cranes are needed per task instead of using %.”

I will explain this with MS PROJECT 2016.

First of all, you have two choices when assign resources to the Tasks: to use % (percentage), or to use Decimals.  To clarify this, and what decimals means, I will create a simple Project with only one Task:

image

Now, let’s say that we have 10 Cranes, which are going to be charged per hour, so they will be concerned as worked resource. Let’s say that we have 10 Workers, and they will also be charged per hour. Now, suppose that we need Gasoline, as a Material resource, but it depends on working hours, e.g. we need, for example, 10 liters of Gasoline per hour. And last, we need 500 bricks, no matter how long will the Task take to finish.

Before I create those resources I will change setup for assignment units from Percentage to Decimal:

image

and then:

image

and finally:

image

Now I will create Resources:

image

As you can see, Max. Units are now in Decimal, instead in Percentages (e.g. 10 instead of 1000%).

Now I will assign 500% or 5 Cranes, 500% or 5 Workers, 10 liters of Gasoline per hour, and 500 Bricks:

image

As you can see, Costs are:

  • for Bricks are fixed (500 * $5= $2500)
  • for Crane are not fixed (5 days * 8 hours per day * $500 per hour * 5 Cranes = $100.000)
  • for Gasoline 5 days * 8 hours per day * $10 per hour = $4.000)
  • for Workers are not fixed (5 days * 8 hours per day * $100 per hour * 5 Workers = $20.000)

So, yes you can put Decimals instead of percentage, and you will get same results.

Hope this helps!

Regards.

Posted in MICROSOFT PROJECT, MS PROJECT 2016, PMI, PRoject Management | Tagged , , , | Leave a comment

Task Calendar in MS PROJECT 2016 – the right way to use it

Hi,

as we all know, there are three types of Calendars in MS PROJECT 2016: Base Calendars, Resource Calendars and Task Calendars. they are prioritized in that order (from low to high importance), which means that Task Calendar has  the highest priority. When we are talking about Resource Calendars, we all know why and when to use it. For example, if 12 resources has a common days off, or working hours, we will create Resource Calendar and assign it to those resources. But why to use Task Calendar? Let’s suppose that we have few (or many) Tasks that should be, for example, done in a certain location. And that this location is for some reason available to work at only from Monday to Wednesday, and that it can not be work at Thursday and Friday. for those Task we will have to create Task calendar and Assign it to those, specific Tasks.

Let’s go.  I will first create a new Project:

image

For  Special Tasks I will create separate Calendar, and I will call it MON-WEN:

image

and then:

image

and then:

image

Finally I will assign this Calendar to the Special Task, and I will get:

image

Finally I will get:

image

As you can see in Information column I have a notice that those Tasks has specific calendar, and Finish date is moved.

Now let’s suppose that we have John as Resource who is able to work only at Thursday and Friday:

image

What will happened if I try to assign John to the Special al Task?

image

As you can see, I can not do it. Why? Because John is supposed to work at Thursday and Friday, and Task should be worked on only at Monday to Wednesday. If I now change the option mentioned above, I will get:

image

and:

image

As you can see, John is now allocated to this Task, but it is show as over allocated, because this is conflict with his Calendar. So he will work to this Task, even he is not supposed to. Now, finally, in this example we should as ourselves a question: “But what if John is really not available from Monday to Wednesday?”.  Well in this situation you will not assign it to the Task. So what are our options? Only two of them. Find another resource who will be available to work from Monday to Wednesday on those Tasks, or change Task Calendar (so make this location available on Thursdays and Fridays). If those are not options, then you are not going to be able to do the Task. As simple as that. Remember, MS Project is a tool. Real life is something else.

Posted in Micsrosoft Project 2016, MS PROJECT 2016, PMI, PRoject Management | Tagged , , | Leave a comment