I work in an organization that is project-orientied. Specifically, we manage construction projects. Naturally, we use MS Project for some aspects of our project work.

We also have a need to manage staff resources in our organization but not on a project-by-project basis. We want to look at staff resources distributed across projects to see where we might be short overall, rather on a single project basis.

We are wondering if Project can be used to do that sort of thing. My thinking was to setup projects as tasks, with "Lead," "Lead Backup," and "Assistant" being sub-tasks of each. So, you'd have Project 1 with Lead, Backup, & Assistant being subtasks. Project 2 would be the same and so-on.

Has anyone used Project for this purpose? I've looked for templates that might suit this use but haven't found anything.

Or, would something like Access or Excel be better suited to the task?