Microsoft Office Project 2010 - Employee Vacation Lisence

[Andrewmis]

Hello all, I 'll make a small introduction of me, i am andreas from cyprus and i am a student of Management Information Systems. I just finished my second year and going for my third year.
I gained a job for two months , lets say something like an internship on an IT solution company. This is my second week. My boss have assigned to me to make an application for Employee Vacation Lisences. At first he told me he want it as a database but after because he told me that he wants it a bit more comblicated such as having a calendar that he can see which employee and when will have a lisence. He show me a sample/example of it and it was very similar to Microsoft Project , and then he told me i can make it with Project.
So i will start saying the requirements. For start, We want to save employee Name (easy) as also the Start and End date of the lisence (easy) and the Type of lisence , for example Annual,Sick,Personal and Other. So far all good and easy i can make some new columns and customize it to microsoft project as also to make a drop down list to be more user friendly.
The company have around 12 employees so the data that we will enter wont be to much.
In my mind , when my boss opens the project , i want him to see the names of all the employees and each employee will be linked with their lisence information.
For example, when he click to Andreas he will see the start/end date of lisence the type of the lisence and his name.
Also i want to calculate the sum of all lisence.
Here is the problem, i dont want project to calculate the DURATION. I will post now three links to see of what i am saying for.

http://www.2shared.com/photo/ZUKo11YC/Sample.html

http://www.2shared.com/photo/K5i84oUT/sample3.html

On the first link you can see how is now my project , i customize it with the Manual control.
I dont want my boss to manual the control but i want the lisence to be calculated automaticly.
In the sample 3 u can see an example of what i am saying.
The first part of the lisence goes 2 days and the next 5 days. So in the duration i want 5+2=7 not 47 days.
What can i do for this ? also what do you think about my structure and generally any thoughts and suggetions would be perfect

 

[JulieInMaine]

Hello Andreas,

Congratulations in your internship and and working through your education.

The problem you are seeing with the '47 days' cannot be avoided in the structure you have created. You have set up each employee as a summary task and the duration of a summary task is always calculated by project.

So, another thought. Create the employees as resources. Enter in tasks such as "Annual Leave - Victor Ethimiades" with the duration and Victor assigned. Then use either filtering on the Resource Name field or view the Resource Usage view to see each employee listed with his/her leave. You can then view work totals - not duration totals for each employee.

I hope this helps.
Julie

 

[Andrewmis]

Thank you JulieInMaine for your time and suggestion. I will give it a try. Any other thoughts or suggestions would be great

 

[JulieInMaine]

You can keep the format that you have - remove the Duration field, show the Work field instead.

 

[Andrewmis]

Actually Yes i did that.
I have some new questions now regarding bar styles.
I want a structure that when a task will finished will be lets say a Black colour, when the task is on progress or so ever will be blue so lets say i can keep it normal and also when a task
have not yet started i want it to be green.
I know that those things i can customize it by the "Bar Styles".
Here are some questions that i have ,lets say the start day project is at: Mon 4/2/12 and the current day is today Fri 8/17/12.
I insert some sample data of days to see how this thing work as i also have customized the "Bar Styles" to my needs.
My first notice is at even if the days that i have insert are less than the current day , for example start day is Fri 6/1/12 and final day Mon 6/4/12 the bar of the task is still the same with the progress.
Only when i click on the 100% complete button does that task finish. I dont have any relationship nor constraints on my task so i dont know if that is the problem.
The project it seams that it cannot calculate the day. So in the sample day that i told , how is not a task finished when the finish duration day of the task is 6/4/12 and now we have 8/17/12 ? I must always click on the 100% button ? Or my customize preference in bar styles are wrong ?
Here is how i change the preferences, i have deleted almost all the bar styles as there were to many and i was getting confused. Basicly i need only three kind of bars.
The one that a task has finished another that a task is on progress and another one that a task has not yet started.

http://www.2shared.com/photo/OOfAIGfi/BarStyle.html

I would like to listen to your suggestion and correction of course as i know that i am doing something wrong but i still havent figure what it is

 

[JulieInMaine]

Andreas,
It looks like Jan is helping you on the Answers forum.

http://answers.microsoft.com/en-us/...progress/eb58ba1d-2b00-4505-b65c-9d4f1a3787e1

Please do not multi-post. Most of the people helping on these forums read all forums and posting the same question multiple times just asks the same responders to do multiple work. We are all volunteers.

Also, when asking a new question, please start a new thread. By staring a new thread with a new question, it is easier for others who may have the same question to find an answer.

Julie

 

[Andrewmis]

Sorry you are right, as for the multi-post i just like to get different answers/suggestions from all people

 

[JulieInMaine]

That's fine - but keep to one post and if others have suggestions let them reply to the one post - otherwise you may get the same answer from different people on different forums.