my Blog reader has a problem:
“Hi Nenad, I am Carlos Altamirano from Ecuador, South America. First of all I want to thank you very much for your always useful and concise work your are doing with your excellent blog. I have a problem importing resources excel files into project 2013, it’s simply doesn’t work; even that I have exported the resource sheet and then try to import the same sheet, do you have any ideas? The import wizard works with tasks, but doesn´t work with resources.
Thanks and best regards,
I do not know why Carlos has a Problem, but I will show you how to do it (and it will work :-)) in MS PROJECT 2013
First I’m going to create Resource sheet in excel without using any template. Suppose that I know: Resource Names, Resource Types, Max Units, Standard and Overtime Rates:
I will create new Project in MS PROJECT
and I will import my Resources form excel.
Step #7: Here you should know which Column from Excel (1,2,3,…) Matches which Field in Project:
I am going to match them
if you want to reuse this map, I can save it.
Finally I’ll get:
Simple as that.