Hi All,
I'm working on creating a resource allocation table for my small company. Basically, we want to be able to designate a certain number of "man-months" per functional group per month per project. Additionally, this database will hold the billing milestones that are associated with the project and we will track some health indicators to each of them.
For instance, we may have a project that is going to be running from May 15th 2014 to June 5th 2015. Based on an access project template I found, I have created some pretty good quality forms/tables that are working well for project inputs and milestone tracking.
Project Table
Lists the Project Name, Project Manager, Priority, Status, Start Date, End Date, and some baseline budget info.
Resource Groups
Lists the functional groups (Electrical Engineer (EE), Mechanical Engineer (ME), etc.) There are 9
Milestone Table
Project, Title, Priority, Status, Client Billing Amount, Schedule Risk, Technical Risk, Owner, Start Date, Due Date, and some budget lines and descriptions
Alright,
So I can't for the life of me figure out how to structure the monthly allocations in a usable table/form. This is what I would like it to look like, similar to the excel document we used to track it in.
How can I create a table that will store all of the data (Project, Resource Group, Month/Year, and Man-months) with inputs from a form that will automatically show the relevant months (between project Start Date and End Date)
It's soooo simple in excel....
Thanks!