M
Mohan
I have created an Access DB for tracking projects. THis is a moderately
complex database. This post can also be in table design group.
Among many table, I have a table for liking the users and project (users
assigned to projects). This will tell which users are working on which
projects.
Not everyone works on the project on a full-time baisis. The project
manager will specify what percentage of each user's time (or resource's time)
are utilized in each project.
Here is what I need.
a) I need to have a talbe for traking the percent utilization of resources
on the project. I can use the already existing table (which I described
above) to track this. I just need to add more fields.
THe problem is how do I go about capturing this data? I also need to report
the percent utilzation of each resources on the project for each month
Option1: Desing a screen to capture the start_date, end_date and percent
utilization for that period keyed by the PM. The problem with this approach
is: I cannot figure out a way to calculate the percent utlization for the
month that are falling in between the start_date and end_date
For eg: if start_dt = 01/15/2007, end_dt = 06/20/2007, percent_util = 0.25
Howe do I report theat percent_util for Jan-07 = 0.25 , Feb-07 = 0.25, ....
al the way to Jun-07 = 0.25
Option2: Instead of entring start_date & end_date, I could desing the
screen such that the PM enters the month & year
I tried this with the drop down menu of all 12 months (Jan - Dec) (sotred in
a field) and the year in a different field. I have having trouble with
converting the 'Jan' text and the 2007 to a date format.
b) I also need to produce a line chart with the timeline on the X-Axis,
percent_util on the y-axis and differnt lines for each resources inside the
grap.
c) Similar graph presentd in a different way: For each users, I need a bar
chart with timeline on the x-axis, percent_util on the y-axis and the project
inside the graph ==> This will tell what percent of time is used in which
projects for the given month
Any ideas or reference would be appreciated.
Thanks
complex database. This post can also be in table design group.
Among many table, I have a table for liking the users and project (users
assigned to projects). This will tell which users are working on which
projects.
Not everyone works on the project on a full-time baisis. The project
manager will specify what percentage of each user's time (or resource's time)
are utilized in each project.
Here is what I need.
a) I need to have a talbe for traking the percent utilization of resources
on the project. I can use the already existing table (which I described
above) to track this. I just need to add more fields.
THe problem is how do I go about capturing this data? I also need to report
the percent utilzation of each resources on the project for each month
Option1: Desing a screen to capture the start_date, end_date and percent
utilization for that period keyed by the PM. The problem with this approach
is: I cannot figure out a way to calculate the percent utlization for the
month that are falling in between the start_date and end_date
For eg: if start_dt = 01/15/2007, end_dt = 06/20/2007, percent_util = 0.25
Howe do I report theat percent_util for Jan-07 = 0.25 , Feb-07 = 0.25, ....
al the way to Jun-07 = 0.25
Option2: Instead of entring start_date & end_date, I could desing the
screen such that the PM enters the month & year
I tried this with the drop down menu of all 12 months (Jan - Dec) (sotred in
a field) and the year in a different field. I have having trouble with
converting the 'Jan' text and the 2007 to a date format.
b) I also need to produce a line chart with the timeline on the X-Axis,
percent_util on the y-axis and differnt lines for each resources inside the
grap.
c) Similar graph presentd in a different way: For each users, I need a bar
chart with timeline on the x-axis, percent_util on the y-axis and the project
inside the graph ==> This will tell what percent of time is used in which
projects for the given month
Any ideas or reference would be appreciated.
Thanks