Results 1 to 6 of 6
  1. #1
    3 Star Lounger
    Join Date
    Nov 2005
    Location
    Asia Pacific, Bangkok Metropolis
    Posts
    378
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Events Monitoring (Excel 2003)

    Hi all,

    I am trying to set up a monitoring file for events but unsure of how can I do it using Excel.
    There are different types of events, but basically they are Rights, Tender Offers, Warrants, etc These Events consist of
    response date which owners have to revert by then. Any one event may have about 20 to 30 owners.

    I would like to have a program which monitor the responses by owners on their decision to take up or lapsed the said event, and at the same time, I can send reminders for those that have not responsed.

    Any insights or ideas are very much appreciates. I have been trying to figure this for a couple of weeks but have no idea at all.

    cheers, francis
    Hope this is helpful

    francis, <img src=/S/cheers.gif border=0 alt=cheers width=30 height=16>

    My Reading

    Pivot Table 101
    Pivot Table
    Array

  2. #2
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Events Monitoring (Excel 2003)

    Sounds like you're asking for an entire application. There is dedicated software to do stuff like this. Outlook has some of it built-in (they call it tasks). Not sure if you can use tasks in Outlook with a team of people, but I wouldn't be surprised.
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  3. #3
    3 Star Lounger
    Join Date
    Nov 2005
    Location
    Asia Pacific, Bangkok Metropolis
    Posts
    378
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Events Monitoring (Excel 2003)

    Thank Jan,

    My company use Lotus Notes, agree with you its sound like a whole application, that's because I have no idea of where to start and need some suggestions from the forum or someone might have seen or done this before. Any pointers are much appreciate.

    cheers, francis
    Hope this is helpful

    francis, <img src=/S/cheers.gif border=0 alt=cheers width=30 height=16>

    My Reading

    Pivot Table 101
    Pivot Table
    Array

  4. #4
    3 Star Lounger
    Join Date
    Feb 2003
    Posts
    363
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Events Monitoring (Excel 2003)

    Does Microsoft have a Project Management application (MS Project, or whatever) that could be adapted? Or some other PM software?

  5. #5
    5 Star Lounger
    Join Date
    Apr 2003
    Location
    Hampshire, United Kingdom
    Posts
    602
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Events Monitoring (Excel 2003)

    Project lacks the interactivity that seems to be required; it sounds to me like tasks in Outlook would do the job nicely. You can send task requests to other people, and track how complete (or otherwise) they are, request updates, etc.

    Alternatively, something like the <img src=/S/free.gif border=0 alt=free width=30 height=15> Task Manager for Excel might help.
    Waggers
    If at first you do succeed, you&#39;ve probably missed something.

  6. #6
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Events Monitoring (Excel 2003)

    I know Lotus Notes can handle stuff like this. I have worked at a client who used Notes for customer complaints handling, including automatic logging of emails, escalation of issues to other departments, path monitoring of calls etcetera. Dunno who created this though, might be a third party tool built on top of Notes. Best to get in touch with your Notes people, they might be able to find out.
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •