Exporting estimation templates from Excel to Project

[DBaddorf]

I have been manually tranposing data from an Excel spreadsheet to the Task
Usage for monthly hours. I know I can link Excel files to Project on the
Gantt view, but how can I link templates to reflect estimated time on Task
usage view?

 

[Jack Dahlgren MVP]

You can't and shouldn't.

-Jack Dahlgren

 

[DBaddorf]

Why shouldn't you if you are trying to level resources and need to insert
hours estimated by month for the project(s)?

 

[Jack Dahlgren MVP]

I'm speaking of the method of using excel links, not the need to update
estimated hours.

-Jack Dahlgren

 

[DBaddorf]

Thanks Jack. Any suggestions when a department is using Excel spreadsheets to
determine resource hours and sending me excel templates? I am looking at
hundreds and hundreds of templates and trying to automate to cut my data
entry time down.

 

[Jack Dahlgren MVP]

I'd write some VBA to handle this.
You will probably want to use the task unique id in the spreadsheet to
ensure you can match things back up.
You will also use the timescaled values collection to update for specific
time periods and resources.


I think Rod Gill's book:
http://www.amazon.com/dp/0975982877...tiveASIN=0975982877&adid=1NSSZGYGMDB7E6XB6D4Q

Has an example of doing exactly what you want.

-Jack

Thanks Jack. Any suggestions when a department is using Excel spreadsheets
to
determine resource hours and sending me excel templates? I am looking at
hundreds and hundreds of templates and trying to automate to cut my data
entry time down.

 

[DBaddorf]

Thanks Jack....
--
DB

I'd write some VBA to handle this.
You will probably want to use the task unique id in the spreadsheet to
ensure you can match things back up.
You will also use the timescaled values collection to update for specific
time periods and resources.


I think Rod Gill's book:
http://www.amazon.com/dp/0975982877...tiveASIN=0975982877&adid=1NSSZGYGMDB7E6XB6D4Q

Has an example of doing exactly what you want.

-Jack