Speaker 1: Hi, this is Adrian from Technical Project Manager. If you are a team leader, manager, or a resource coordinator of any kind, then one of your key responsibilities is to do the resource planning to make sure that your team members are providing the needed support for the ongoing projects. And of course, you have to make sure that nobody is getting too much work. So how do you manage your how do you manage the resource planning? If your organization is using some sort of resource management tool capacity planning tool, then you're well off. However, if your company is not using any kind of planning app, then how can you do the resource planning? The obvious choice for most people then is Excel. And you can do your resource planning in Excel, but you'll quickly notice that doing the planning in Excel is very manual, and it requires a lot of effort. And whenever you make a change, you add a new column, you add a new team member, you have just the formulas, the formatting, etc. It's a real pain in the neck. And you end up spending more time on fixing your Excel sheet than actually leading your team, which is your main responsibility. So for a long time, I didn't have a good solution either. And I always got questions from my followers asking me whether I would have some sort of resource planning template, but I had nothing I could give to them. So that's why last year, I hired a developer to build a good resource planning solution for me on the basis of Excel. I think Excel is a great tool, but you still need some automation to be efficient. So in this video, I'm going to give you a demo of my Excel solution. And we'll just play around with some sample data. Alright, let's open the planner. First you have to enable macros, because the planner is based on Excel macros. Now the first thing you'll see is the help tab, which contains the instructions that show you exactly how to use the planner. And you can see it's very simple. When you look at the available tabs, you'll notice that there's no actual planning sheet. So where's the planning sheet? Well, the way the planner works is that you first generate a customized planning sheet for your team, with your team members, with their working hours, the projects they're working on, the calendar you want to use, etc. And now I'm going to show you exactly what you need to do. In the leftmost section, columns A and B, you enter your team members and their standard working hours. They're working 40 hours a week, 20 hours a week, 35 hours per week. That's what you specify here. In the next section, column D, you're listing all the tasks and projects your team members are currently working on, or what they are going to be working on in the future. And you also want to add a general task called admin and meetings or something like that. Because usually your team members are going to spend a few hours every week in meetings or doing admin stuff. The next section is called assignments. And here you define what projects or tasks each team member is going to be working on. Who is going to do what. Now there are just a few more inputs that we need to make before we can generate the planning sheet. The first field is called Monday of week one. Here you specify on what day your timeline should start. The next field is the number of weeks you want to show. So 52 if you want to plan for an entire year. The country indicator is important because the planner will consider the national holidays of your country. And finally, there's a field called FTE per month. And the value to enter here are the average monthly working hours that represent a full time equivalent, a full time resource. And this information you can get from your HR department 172 hours per month. That's the standard for an employee working 40 hours per week. But if let's say in your company, you're only working 35 hours per week, then you just enter the corresponding number of average monthly working hours in here. Now we are ready to generate the planning sheet. And don't worry, you can always add new team members or new tasks later on directly in the planning sheet. Now let's click the generate planning sheet button. It takes a few seconds for the macro to generate the planning sheet. Voila, this is the planning sheet. At the top, you can see the timeline with the months and weeks and your team members with the projects they're going to work on. At the top, you can see four buttons. And you use these buttons to add further team members, change project assignments, or extend the timeline. The buttons are essentially automating the processes. So for example, when you add a new team member, it will automatically adjust the formatting and the sheet layout to make sure that your data and your sheet is always consistent. Now let's enter some data. We have our team members. And now we want to plan the team capacities for the coming months. The first team member is me. Let's assume I'm going to spend about five hours a week in meetings or doing admin work. That's probably a bit on the higher end. But that's just an example. Furthermore, I will be supporting an ERP implementation project. And in January until the first week of February, I will probably spend about 25 hours working on that project. And then I'm going to reduce my contribution to about 10 hours a week. Finally, there's also a Windows upgrade project that I'll be supporting. So let's key in the numbers here. Now one thing you'll notice the total weekly hours appear in different colors. Why is that? The numbers indicate whether we are below, at or above the available capacity. Red means we have exceeded the available capacity. We have given that specific team member too much work. Green means we still have some available capacity. And white means we are just on point. Now in week four, you see that my total capacity is 40 hours, which are my standard working hours. Why is it still red? Simple. In that week, we have a national holiday. So I'm not going to work 40 hours in that week. And there's a separate sheet where you can maintain the national holidays and non-working periods for your country. It's already pre-filled with the US and UK holidays. Now suppose you want to give one of your team members another project. How do you do that? Let's take the following example. You can see our team member, Frank Howard, is working on several projects. And in February and March, he's already working at more than 100% of his capacity. So we want our team member, Peter Norton, to take over some of Frank's work. So let's put Peter Norton also onto the plant relocation project. To assign Peter Norton another project, we just put the cursor onto the total cell for Peter and press the green button, add task for team member. The planner will automatically create a new row for Peter where we can add the new project. And then we just enter the plant capacities for Peter and reduce Frank's workload in February and March. All right. Are you still with me? One more thing I want to show you is how easy it is to add a new team member. You just press the blue button, add new team member, enter the name of your team member. Then you will be asked how many tasks you want to give that person. And finally, you enter the team member's capacity in hours per week. Press OK. And now we just assign the relevant projects. Super simple. The last feature I want to show you is the extension of the timeline. Suppose you want to add another week or another month at the end of your timeline. You just press the yellow button, add new column. And this will extend the timeline by another week. So I'm just pressing it four times and it will add automatically the next month, which in this case will be January 2022. You see, all this happened automatically. The layout is consistent. It has been formatted correctly. You don't have to do any manual corrections. It is all done automatically for you. And that is why people love the team planner. And it is used by thousands of teams across the world. Check out the link below the video. This is the page where you can read more about the planner and its features. And this is also where you can buy it from. I do charge a bit for it because I have invested quite a bit of money into the development work. But for the value you get and the time it saves you, it's a really good deal. To use the planner, you need Microsoft Excel in a desktop version, either Windows or Mac. Please note that the planner does not work with Google Sheets. That's it. Thank you for watching this video. And if you have any questions about the planner, just leave a comment below the video.