is there a way to get statistics from the calendar?

Hi,
I see a lot of students through the year and I need a record of the following:
name, number, course
how many appointmemts there were
how many were attended/missed

I have to provide statistics for the year and up till now have just had to
go through each appointment and record these things by hand

is it possible to do this using Outlook Calendar?

You could Export to an Excel spreadsheet. The "missed" appointments
would have to be noted somehow.

Rich wrote:

Hi,
I see a lot of students through the year and I need a record of the following:
name, number, course
how many appointmemts there were
how many were attended/missed

I have to provide statistics for the year and up till now have just had to
go through each appointment and record these things by hand

is it possible to do this using Outlook Calendar?

I'm not sure but I think the Business Contact Manager addin might have those
reports/options.

"Rich" Rich @discussions.microsoft.com wrote in message
...
Hi,
I see a lot of students through the year and I need a record of the
following:
name, number, course
how many appointmemts there were
how many were attended/missed

I have to provide statistics for the year and up till now have just had to
go through each appointment and record these things by hand

is it possible to do this using Outlook Calendar?

If you decide to go with the Excel solution, you can use a 3rd party
tool called WinCalendar to import Google calendars into Excel. Then
using Excel formulas you can get statistics.
This is also a good way to import many calendars into one file for
archiving. A free version of WinCalendar is available. For more info
see:
http://www.wincalendar.com/Google-Calendar-Excel.htm

TG


On Oct 14, 8:21*am, "Vince Averello" wrote:
I'm not sure but I think the Business Contact Manager addin might have those
reports/options.

"Rich" Rich @discussions.microsoft.com wrote in message

...



Hi,
I see a lot of students through the year and I need a record of the
following:
name, number, course
how many appointmemts there were
how many were attended/missed

I have to provide statistics for the year and up till now have just had to
go through each appointment and record these things by hand

is it possible to do this usingOutlookCalendar?- Hide quoted text -

- Show quoted text -

If the calendar is in Outlook, you can use a table view with the fields you
need and copy and paste it into excel to work into stats. This shows the
basic method: http://www.slipstick.com/Tutorials/copyto/excel.htm

--
Diane Poremsky [MVP - Outlook]
Outlook Tips: http://www.outlook-tips.net/
Outlook & Exchange Solutions Center: http://www.slipstick.com

Outlook Tips by email:


EMO - a weekly newsletter about Outlook and Exchange:


You can access this newsgroup by visiting
http://www.microsoft.com/office/comm...s/default.mspx or point your
newsreader to msnews.microsoft.com.


"TechGuy" wrote in message
...
If you decide to go with the Excel solution, you can use a 3rd party
tool called WinCalendar to import Google calendars into Excel. Then
using Excel formulas you can get statistics.
This is also a good way to import many calendars into one file for
archiving. A free version of WinCalendar is available. For more info
see:
http://www.wincalendar.com/Google-Calendar-Excel.htm

TG


On Oct 14, 8:21 am, "Vince Averello" wrote:
I'm not sure but I think the Business Contact Manager addin might have
those
reports/options.

"Rich" Rich @discussions.microsoft.com wrote in message

...



Hi,
I see a lot of students through the year and I need a record of the
following:
name, number, course
how many appointmemts there were
how many were attended/missed

I have to provide statistics for the year and up till now have just had
to
go through each appointment and record these things by hand

is it possible to do this usingOutlookCalendar?- Hide quoted text -

- Show quoted text -