Re: Reporting resources unavailability

Hi,

On my website there is a VBA program that turns calendar data into tasks.
If you know VBA you could modify it to turn absences into anything for
instance Excel rows, etc.
HTH

--
Jan De Messemaeker
Microsoft Project Most Valuable Professional
http://users.online.be/prom-ade/
+32-495-300 620
"Salilu" <Salilu@xxxxxxxxxxxxxxxxxxxxxxxxx> schreef in bericht
news:617DACC9-6801-45C4-B0D5-B96BFE0FCFA3@xxxxxxxxxxxxxxxx
> MSP (to my knowledge) does not provide calendar report. This is something
> that I am looking forward to since long. For the calendars I have in my
> project, I want a report that lists --
>
> Weekly Work pattern for each day of the week
> Block Exceptions (exceptions for a continuous period,)
> Daily exceptions ( including vacation)
>
> For example:
>
> Calendar Name: My Projet Calendar
>
> Weekly Pattern
> Mon - Thu -- Working -- 8:00 - 12:00, 13:00- 17:00
> Fri -- Working -- 8:00 - 12:00
> Sat - Sun --- Non-working
>
> Exceptions:
> 1. 7/1/05-7/5/05 -- 8:00 - 12:00, 13:00 - 19:00
> 2. 8/1/05 - 8/15/05 -- Non-working.
>
> A report of this nature would be extremely useful, when you have many
> resources in project and would like to quickly see their work
> pattern/vacation without going through their calendars individually within
> the application.
>
>
> "Pai_da_malta" wrote:
>
> > After entering vacation calendar for all resources, I would like to be
able
> > to print them in a consolidated report. Is it possible? How?
> > Thanks,
> >
> >
> > Pai_da_malta


.

Relevant Pages

  • Re: Reporting of Calendar Exceptions
    ... If you create a new resource report and on the Details tab, ... Calendar, you can print out the list of exceptions (non-working ...
    (microsoft.public.project)
  • @@@@every burdens will be selective think leaves@@@@
    ... Estefana's silk motivates in favour of our calendar after we ... confront through it. ... I was enjoying to report you some of my ...
    (sci.crypt)
  • Re: Combine multiple records for a single date into 1 record
    ... Check out the calendar reports at ... style report that allows any number of detail records on a date. ... day's details and the textbox that returns the date number, ...
    (microsoft.public.access.queries)
  • Re: Calendar View of MS Project 2003
    ... close but it still is not working as you describe -- the filter ... I would create the new report based upon the Monthly calendar, ... independent of how long the bars are? ...
    (microsoft.public.project)
  • Re: Count within intervals
    ... Each time the asset status changes, ... >I need to produce a report that counts the devices by type that were ... you need a calendar table that holds all dates this report could ... suggested query), we create a list of all dates each asset was IN. ...
    (microsoft.public.sqlserver.programming)