Track equipment capacity in MS Project
Hello, I have decent experience using MS Project desktop but currently struggling with how or if MS project is able to track equipment capacity in terms of quantity/units. Ideally, I would like project to alert/show capacity for an equipment based on task start/end date show capacity for future planning. For example, I have 70 samples to run on the equipment but capacity is 40 samples. I know that the 70 samples can't go through, but how can I set the equipment capacity in project to call this out? I have been tinkering with resource sheets, names, %, but don't understand how to manipulate it so that if I set an equipment capacity at 40 units (not %), it will show me capacity alerts. I also want to enter in tasks that are happening months out and would like capacity alerts to be called out in this situation too. This is how I'm tracking it in project. I don't want to put each sample as it's own line item as there are many projects with X samples so I keep it as a high level task with the project and associated sample count. Maybe it's how I am tracking that doesn't allow for tracking capacity in units? Any suggestions are appreciated. Thank you.How Do I Interpret This Overallocation in Resource Usage View
I have a project where I have 3 developers assigned to work on tasks each at 50% for a total of 150%. So I set up just a single resource and assigned the units at 150%. I assigned the resources to the tasks and I just don't know what to make of what I'm looking at on how I overallocated 3 people. Can someone help me interpret what this resource usage overallocation view means?Issues Trying To Export Resource Usage Info From Project To Excel
I am trying to export the resource usage info for my project to MS Excel so people who don't have Project can view this information. The left pane which displays the Resource Name, and assigned tasks below it as well as additional fields I've added export fine to excel, however, when I click in the top left corner of Resource Usage Details pane, copy and paste that info into excel, the row headers such as Work and Overalloc. as well as column headers that show the dates don't transfer over to excel. Maybe I'll recommend Microsoft Fix this. Here's an example of what I end up getting when I copy the info into Excel: Is there another way that I can get resource usage data from project into another format like excel, so that resources know how many hours they are projected to spend on a given task during a certain period?
