I received an e-mail from an employee in the United States Central Command inquiring about how to use Microsoft Project to track personnel on a military base and monitor resource levels as units deactivate during a base closing. The goal was to measure the total number of personnel at any given point in time and track the resources as the base downsizes.
I developed a quick resource management model in Microsoft Project that will produce this information. Since Microsoft Project supports resource assignments and resource pools, developing an ongoing model was relatively easy. This example creates a work breakdown structure WBS that comprises teams or units that are allocated to different tasks.
This Microsoft Project tutorial is also available as a TechRepublic gallery. The base the top-level WBS deliverable was divided into regions. Each region was composed of specific buildings, and each building was further defined into specific floors. A general term "location" could also be used if resources were not assigned to a specific building but rather to another ambiguous sub-region.
The level of detail can be extended to individual offices or cube locations. The next step is to define all the resources that currently occupy the base. Since this could extend to several hundred or thousand resources, you may want to import them from an Excel extract of a resource management system. By accessing the resource model, you can view the total head count at any point in time. In Figure A , the numbers at the bottom of the graph indicate the head count.
By clicking the magnifying glass in the Standard Toolbar, the head count numbers will change to provide weekly or day-to-day head count detail. By zooming in and out of the resource graph, you can quickly develop a staffing level report by any date range. Figure A Ramp down resource model. Click the image to enlarge.
What is the current head count of engineers? Editor's Picks. The best programming languages to learn in Check for Log4j vulnerabilities with this simple-to-use script. TasksBoard is the kanban interface for Google Tasks you've been waiting for. Paging Zefram Cochrane: Humans have figured out how to make a warp bubble. You are commenting using your Google account. You are commenting using your Twitter account. You are commenting using your Facebook account.
Notify me of new comments via email. Notify me of new posts via email. Group tasks or resources by one criterion On the View menu, click the view you want. To use a view that is not on the View menu, click More Views , click the view you want to use in the Views list, and then click Apply. You can also group tasks in the Network Diagram view. To group resources, select a sheet view such as the Resource Sheet or Resource Usage view.
In the Group By box on the toolbar, click the group you want. To return the view to its ungrouped state, in the Group By box, click No Group. Group tasks or resources by multiple criteria On the View menu, click the view you want. On the Project menu, point to Group by , and then click More Groups. Do one of the following: Under Groups , click Task or Resource , select a grouping criterion, and then click Edit.
Under Groups , click Task or Resource , and then click New to create a new group.
0コメント