is there a way to get statistics from the calendar?

R

Rich

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?
 
B

Bob I

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

Vince Averello

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

TechGuy

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
 
D

Diane Poremsky [MVP]

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.

Ask a Question

Top