Hi,
I am involved with a totally voluntary organisation that rosters drivers to pick-up cancer patients for treatment from a country location to the primary treatment facilities in the city. The task is becoming quite time-consuming for a rostering officer as the demands for the task are ever increasing.
The whole rostering process of booking patients, managing drivers' availability, logging incoming and outgoing phone calls, building rosters and storing all of this information to produce reports for the management committee to survey is confined to one Excel workbook. there is a need to interact the workbook with Outlook, MSWord on a regular basis - Outlook for managing information to members of the organisation and MSWord from which patient information is gathered.
In an effort to try to establish an idea of how much time is actually spent interfacing between applications during the course of a rostering session I was seeking the possibility of some sort of an "automated" process that could update the users time spend modifying any working files used in the process of producing a roster on a daily basis.
I did have a look at the Event Manager in MMC but either I am misunderstanding the purpose of this information base (this being most likely the case) or it doesn't actually handle this approach.
Essentially, any of the applications that are called upon need to have a date/time stamp reflecting editing/modification of a files they generate. I thought of adding a worksheet to the workbook to do this manually and realised that is really only creating more work to measure work load - a bit of an oxy-moron in a sense.
Sorry about the long windedness of the question. However, I am hoping there might just be a "relatively" simple approach known to members of Mr Excel. I thank whomever that might be in anticipation.
Regards,
midframe
I am involved with a totally voluntary organisation that rosters drivers to pick-up cancer patients for treatment from a country location to the primary treatment facilities in the city. The task is becoming quite time-consuming for a rostering officer as the demands for the task are ever increasing.
The whole rostering process of booking patients, managing drivers' availability, logging incoming and outgoing phone calls, building rosters and storing all of this information to produce reports for the management committee to survey is confined to one Excel workbook. there is a need to interact the workbook with Outlook, MSWord on a regular basis - Outlook for managing information to members of the organisation and MSWord from which patient information is gathered.
In an effort to try to establish an idea of how much time is actually spent interfacing between applications during the course of a rostering session I was seeking the possibility of some sort of an "automated" process that could update the users time spend modifying any working files used in the process of producing a roster on a daily basis.
I did have a look at the Event Manager in MMC but either I am misunderstanding the purpose of this information base (this being most likely the case) or it doesn't actually handle this approach.
Essentially, any of the applications that are called upon need to have a date/time stamp reflecting editing/modification of a files they generate. I thought of adding a worksheet to the workbook to do this manually and realised that is really only creating more work to measure work load - a bit of an oxy-moron in a sense.
Sorry about the long windedness of the question. However, I am hoping there might just be a "relatively" simple approach known to members of Mr Excel. I thank whomever that might be in anticipation.
Regards,
midframe
