R
Rod
Can anyone offer me any assistance using Microsoft Project.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
J
JulieS
Hi Rod,
You don't give us much to go on but off the top of my head, I'd say the
Project is not the product for vacation rosters. Project is best used to
create schedules of tasks that are dependent upon one another. I assume the
vacations of you and your staff are really not.
I'd suggest using Excel or perhaps Visio to create a "Gantt chart like" look
much more easily.
I hope this helps. Let us know how you get along.
Julie
Visit http://project.mvps.org/ for the FAQs and additional information about
Microsoft Project
You don't give us much to go on but off the top of my head, I'd say the
Project is not the product for vacation rosters. Project is best used to
create schedules of tasks that are dependent upon one another. I assume the
vacations of you and your staff are really not.
I'd suggest using Excel or perhaps Visio to create a "Gantt chart like" look
much more easily.
I hope this helps. Let us know how you get along.
Julie
Visit http://project.mvps.org/ for the FAQs and additional information about
Microsoft Project
R
Rod
Hello Julie
Many thanks for your suggestion.
What I wanted to do is enter the date for the commencement of the employee's
vacation and have the program caculate the employee's return to duty date.
The vacation time is based on a 5 day week - Monday to Friday and any public
holidays which may occur during the employee's absence has to be included as
an additional days vacation.
Some employees will want to "split" their vacation - that is take 2 weeks on
one occasion and then the remaining 3 weeks at another time in the year.
Additionally, when I print the chart out, I would like the week to start on
a Sunday and, if possible, have the whole 12 months - start of January to end
December displayed in the notice board. I know its going to be a big
print-out but we have about 150 emplyees to consider and I want to use
something which will aid in the planning of the employee's vacation times.
Any advice would be greatly appreciated by me.
Many thanks for your suggestion.
What I wanted to do is enter the date for the commencement of the employee's
vacation and have the program caculate the employee's return to duty date.
The vacation time is based on a 5 day week - Monday to Friday and any public
holidays which may occur during the employee's absence has to be included as
an additional days vacation.
Some employees will want to "split" their vacation - that is take 2 weeks on
one occasion and then the remaining 3 weeks at another time in the year.
Additionally, when I print the chart out, I would like the week to start on
a Sunday and, if possible, have the whole 12 months - start of January to end
December displayed in the notice board. I know its going to be a big
print-out but we have about 150 emplyees to consider and I want to use
something which will aid in the planning of the employee's vacation times.
Any advice would be greatly appreciated by me.
J
JulieS
Hi Rod,
Sorry for the delay in replying.
I'm still not sure if you are looking to use MS Project for the vacation
roster or not, but some comments/suggestions for using Project for your
scenario are embedded below.
I hope this helps. Let us know how you get along.
Julie
Visit http://project.mvps.org/ for the FAQs and additional information about
Microsoft Project
[Julie]: Assuming you choose to use Project:
I guess I would create a summary task for each resource and then list
his/her specific vacation times (Vacation 1, Vacation 2, etc) as subtasks
under the summary task.
As far as entering the actual vacation, you will need to specify the start
date of the vacation and constrain the date with a Must start on constraint.
Then specify the duration of the vacation to have Project calculate the
finish date for you.
[Julie] In order to have Project not count the public holidays towards the
vacation time subtasks, you will need to modify the project calendar with
those public holidays. Go to Tools > Change Working time and then select
the date in the calendar and choose the Nonworking time radio button.
[Julie] In that case, I would just create another vacation subtask for that
resource summary task, one with 2 weeks duration and the other with 3 weeks
duration.
[Julie] You'll have to experiment with the timescale in Project. From what
I understand, you are looking at a project file with potentially over 450
lines. 150 summary tasks = 150 employees and two vacation slots per
employee. I doubt you'll be able to print out the Gantt chart showing every
single day, but depending upon what size print outs you can create you may
be able to adjust the scale so it is still meaningful.
for what you are wanting to do, but if you don't have another tool, I hope
these suggestions give you a starting point. Do post back with any further
questions you have.
Sorry for the delay in replying.
I'm still not sure if you are looking to use MS Project for the vacation
roster or not, but some comments/suggestions for using Project for your
scenario are embedded below.
I hope this helps. Let us know how you get along.
Julie
Visit http://project.mvps.org/ for the FAQs and additional information about
Microsoft Project
Rod said:Hello Julie
Many thanks for your suggestion.
What I wanted to do is enter the date for the commencement of the
employee's
vacation and have the program caculate the employee's return to duty date.
[Julie]: Assuming you choose to use Project:
I guess I would create a summary task for each resource and then list
his/her specific vacation times (Vacation 1, Vacation 2, etc) as subtasks
under the summary task.
As far as entering the actual vacation, you will need to specify the start
date of the vacation and constrain the date with a Must start on constraint.
Then specify the duration of the vacation to have Project calculate the
finish date for you.
The vacation time is based on a 5 day week - Monday to Friday and any
public
holidays which may occur during the employee's absence has to be included
as
an additional days vacation.
[Julie] In order to have Project not count the public holidays towards the
vacation time subtasks, you will need to modify the project calendar with
those public holidays. Go to Tools > Change Working time and then select
the date in the calendar and choose the Nonworking time radio button.
Some employees will want to "split" their vacation - that is take 2 weeks
on
one occasion and then the remaining 3 weeks at another time in the year.
[Julie] In that case, I would just create another vacation subtask for that
resource summary task, one with 2 weeks duration and the other with 3 weeks
duration.
Additionally, when I print the chart out, I would like the week to start
on
a Sunday and, if possible, have the whole 12 months - start of January to
end
December displayed in the notice board. I know its going to be a big
print-out but we have about 150 emplyees to consider and I want to use
something which will aid in the planning of the employee's vacation times.
[Julie] You'll have to experiment with the timescale in Project. From what
I understand, you are looking at a project file with potentially over 450
lines. 150 summary tasks = 150 employees and two vacation slots per
employee. I doubt you'll be able to print out the Gantt chart showing every
single day, but depending upon what size print outs you can create you may
be able to adjust the scale so it is still meaningful.
[Julie] I do hope these ideas have helped. Again, project is not designedAny advice would be greatly appreciated by me.
for what you are wanting to do, but if you don't have another tool, I hope
these suggestions give you a starting point. Do post back with any further
questions you have.
R
Rod
Thank you very much for your help Julie.
JulieS said:Hi Rod,
Sorry for the delay in replying.
I'm still not sure if you are looking to use MS Project for the vacation
roster or not, but some comments/suggestions for using Project for your
scenario are embedded below.
I hope this helps. Let us know how you get along.
Julie
Visit http://project.mvps.org/ for the FAQs and additional information about
Microsoft Project
Rod said:Hello Julie
Many thanks for your suggestion.
What I wanted to do is enter the date for the commencement of the
employee's
vacation and have the program caculate the employee's return to duty date.
[Julie]: Assuming you choose to use Project:
I guess I would create a summary task for each resource and then list
his/her specific vacation times (Vacation 1, Vacation 2, etc) as subtasks
under the summary task.
As far as entering the actual vacation, you will need to specify the start
date of the vacation and constrain the date with a Must start on constraint.
Then specify the duration of the vacation to have Project calculate the
finish date for you.The vacation time is based on a 5 day week - Monday to Friday and any
public
holidays which may occur during the employee's absence has to be included
as
an additional days vacation.
[Julie] In order to have Project not count the public holidays towards the
vacation time subtasks, you will need to modify the project calendar with
those public holidays. Go to Tools > Change Working time and then select
the date in the calendar and choose the Nonworking time radio button.Some employees will want to "split" their vacation - that is take 2 weeks
on
one occasion and then the remaining 3 weeks at another time in the year.
[Julie] In that case, I would just create another vacation subtask for that
resource summary task, one with 2 weeks duration and the other with 3 weeks
duration.Additionally, when I print the chart out, I would like the week to start
on
a Sunday and, if possible, have the whole 12 months - start of January to
end
December displayed in the notice board. I know its going to be a big
print-out but we have about 150 emplyees to consider and I want to use
something which will aid in the planning of the employee's vacation times.
[Julie] You'll have to experiment with the timescale in Project. From what
I understand, you are looking at a project file with potentially over 450
lines. 150 summary tasks = 150 employees and two vacation slots per
employee. I doubt you'll be able to print out the Gantt chart showing every
single day, but depending upon what size print outs you can create you may
be able to adjust the scale so it is still meaningful.[Julie] I do hope these ideas have helped. Again, project is not designedAny advice would be greatly appreciated by me.
for what you are wanting to do, but if you don't have another tool, I hope
these suggestions give you a starting point. Do post back with any further
questions you have.
J
JulieS
You're most welcome Rod and thanks for the feedback. Do let us know if you
have any additional questions.
Julie
Visit http://project.mvps.org/ for the FAQs and additional information about
Microsoft Project
have any additional questions.
Julie
Visit http://project.mvps.org/ for the FAQs and additional information about
Microsoft Project
Rod said:Thank you very much for your help Julie.
JulieS said:Hi Rod,
Sorry for the delay in replying.
I'm still not sure if you are looking to use MS Project for the vacation
roster or not, but some comments/suggestions for using Project for your
scenario are embedded below.
I hope this helps. Let us know how you get along.
Julie
Visit http://project.mvps.org/ for the FAQs and additional information
about
Microsoft Project
Rod said:Hello Julie
Many thanks for your suggestion.
What I wanted to do is enter the date for the commencement of the
employee's
vacation and have the program caculate the employee's return to duty
date.
[Julie]: Assuming you choose to use Project:
I guess I would create a summary task for each resource and then list
his/her specific vacation times (Vacation 1, Vacation 2, etc) as subtasks
under the summary task.
As far as entering the actual vacation, you will need to specify the
start
date of the vacation and constrain the date with a Must start on
constraint.
Then specify the duration of the vacation to have Project calculate the
finish date for you.The vacation time is based on a 5 day week - Monday to Friday and any
public
holidays which may occur during the employee's absence has to be
included
as
an additional days vacation.
[Julie] In order to have Project not count the public holidays towards
the
vacation time subtasks, you will need to modify the project calendar with
those public holidays. Go to Tools > Change Working time and then select
the date in the calendar and choose the Nonworking time radio button.Some employees will want to "split" their vacation - that is take 2
weeks
on
one occasion and then the remaining 3 weeks at another time in the
year.
[Julie] In that case, I would just create another vacation subtask for
that
resource summary task, one with 2 weeks duration and the other with 3
weeks
duration.Additionally, when I print the chart out, I would like the week to
start
on
a Sunday and, if possible, have the whole 12 months - start of January
to
end
December displayed in the notice board. I know its going to be a big
print-out but we have about 150 emplyees to consider and I want to use
something which will aid in the planning of the employee's vacation
times.
[Julie] You'll have to experiment with the timescale in Project. From
what
I understand, you are looking at a project file with potentially over 450
lines. 150 summary tasks = 150 employees and two vacation slots per
employee. I doubt you'll be able to print out the Gantt chart showing
every
single day, but depending upon what size print outs you can create you
may
be able to adjust the scale so it is still meaningful.[Julie] I do hope these ideas have helped. Again, project is notAny advice would be greatly appreciated by me.
designed
for what you are wanting to do, but if you don't have another tool, I
hope
these suggestions give you a starting point. Do post back with any
further
questions you have.:
Hi Rod,
You don't give us much to go on but off the top of my head, I'd say
the
Project is not the product for vacation rosters. Project is best used
to
create schedules of tasks that are dependent upon one another. I
assume
the
vacations of you and your staff are really not.
I'd suggest using Excel or perhaps Visio to create a "Gantt chart
like"
look
much more easily.
I hope this helps. Let us know how you get along.
Julie
Visit http://project.mvps.org/ for the FAQs and additional information
about
Microsoft Project
Can anyone offer me any assistance using Microsoft Project.
S
Steve House
It's kind of kludgy - heck, it's very kludgy and goes against my every
instinct <g> - but this might work.
Project Calendar is the standard calendar customized with statutory and
company recognized holidays.
Each employee is a summary task with 1 or more vacation periods as subtasks
underneath it
Each vacation period subtask has a duration equal to the employee's
entitlement. In the event they break their vacation into multiple segments,
it'll be a manual process to insure the total duration doesn't exceed their
entitlement. The summary task duration won't do it.
Enter a start date for the first date on the segment - this sets a Start No
Earlier Than constraint on the "task."
Project will calculate the return date when the input "duration" ie number
of work day, will have elapsed and draw the Gantt chart bar between the
start and computed return dates.
instinct <g> - but this might work.
Project Calendar is the standard calendar customized with statutory and
company recognized holidays.
Each employee is a summary task with 1 or more vacation periods as subtasks
underneath it
Each vacation period subtask has a duration equal to the employee's
entitlement. In the event they break their vacation into multiple segments,
it'll be a manual process to insure the total duration doesn't exceed their
entitlement. The summary task duration won't do it.
Enter a start date for the first date on the segment - this sets a Start No
Earlier Than constraint on the "task."
Project will calculate the return date when the input "duration" ie number
of work day, will have elapsed and draw the Gantt chart bar between the
start and computed return dates.
Ask a Question
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.