export excel, personal mapping

[Devnulle]

Hi

I want to generate a excel files that would have the following mapping :

Name_ressource1 Name_ressource2 ...
Name_task begin_task | end_task begin_task | end_task

task1 01/01/04 | 02/01/04 01/01/04 | 02/01/04
task2 01/01/04 | 02/01/04 01/01/04 | 02/01/04
task3 01/01/04 | 02/01/04 01/01/04 | 02/01/04
task4 02/01/04 | 03/01/04 01/01/04 | 05/01/04
task5 01/01/04 | 02/01/04 01/01/04 | 02/01/04
task6 01/01/04 | 02/01/04 01/01/04 | 10/01/04



etc ...

I don't know how to generate this mapping. ...

thx a lot

 

[Guest]

This is possible, but you will have to write some visual basic code to do
this.
You can look at my "export heirarchy to excel" macro at:
http://masamiki.com/project/macros.htm
for a start. You would basically
1) create a list of resources
2) loop through all tasks
3) check each assignment on each task
4) write the start and finish for the assignment under each resource (the
hard part will be figuring out how far to the right to shift for each
resource. - my suggestion is to create an array of resources with a field
for which row they are in and use that to control the cell navigation in
excel.

Post back if you think you need some help with this.

-Jack