Project FTE changes

[pib311 via AccessMonster.com]

Hi everyone,

I used to have a companion/equal to bounce some of these ideas off, but no
longer. I am looking for someone to assist in creating this dataset that I
just cannot grasp. Maybe someone else has had a similar problem.

I have a dataset that has allocated FTE resources for current month and next
month. my recordset has 3K records and I am trying to automate a process
currently done manually by my team.

So here's an example:

Project Name Allocation Month
Proj1 John .5 Current
Proj2 John .5 Current
Proj1 John .5 Next
Proj3 John .25 Next
Proj4 John .25 Next

So, the resulting dataset needs to show that Proj2 will be providing Proj3
and Proj4 with .25 fte each next month. I don't care about John at that point,
just where the resource is going to and coming from.

I built something that shows the variance between the two, but not something
that would show which project the variance came from. It looks like this.

Project1 Variance
Proj1 0
Proj2 -.5
Proj3 +.25
Proj4 +.25

What i want to show is this:

Original Project New Project FTE Added
Proj2 Proj3 +.25
Proj4 +.25

I am just lost. I hope I included all the data and information you would need
to help. Any ideas are very much welcome.

Thanks again.

 

[kc-mass]

Hi

Don't you need something like "GainingProj" and "Contibuting Project"

Regards

Kevin

 

[pib311 via AccessMonster.com]

Kevin,

If you mean in the original dataset, yes it would solve all the issues I am
currently having. If you are asking if I should create those fields, that is
where I am lost. I think I will be waiting until we receive some additional
technology in our department that will do this for me.

Thanks for the help.

Hi

Don't you need something like "GainingProj" and "Contibuting Project"

Regards

Kevin

Hi everyone,

[quoted text clipped - 42 lines]

Thanks again.