+ Reply to Thread
Results 1 to 5 of 5

Windows XP : Roll-over data reveal for an imported .cdr file in Excel

  1. #1
    Registered User
    Join Date
    12-02-2008
    Location
    Manila, The Philippines
    Posts
    22

    Roll-over data reveal for an imported .cdr file in Excel

    Please, can anyone help?

    I produce a Corel Draw 12 .cdr file of my company's floor plan - there is a CCTV system in our building that staff can access to see what activity is going on... however we move equipment around and keep changing which camera is looking at its new location... there is no logic to the camera numbers and they can not be changed to always be associated with one piece of equipment.

    The floor plan is cluttered enough without labeling each piece of equipment with the camera looking at it and the DVR and track number to review recorded tracks.

    I want to know how to make the .cdr file (or import it to excel or word 2007 which would be easier as not all staff have Corel Draw on their computers) to show this data when you roll a mouse pointer over it.

  2. #2
    Forum Contributor BlastRanger's Avatar
    Join Date
    09-02-2010
    Location
    Indonesia
    MS-Off Ver
    2003, 2007, 2010
    Posts
    238

    Re: Roll-over data reveal for an imported .cdr file in Excel

    I suppose you just want the CCTV system to produce an output which can open by using Excel and Word 2007?

    Question is
    1. The Output of the CCTV system is movie/video (moving scene) or picture (Static).
    2. What you want to do with the output of the CCTV system, for saving purpose or you want to evaluate something

  3. #3
    Registered User
    Join Date
    12-02-2008
    Location
    Manila, The Philippines
    Posts
    22

    Re: Roll-over data reveal for an imported .cdr file in Excel

    Thanks for replying Blastranger,... sorry I'm 4 days late in responding, I've been out of the country.

    I don't think I have explained my problem clearly enough...
    1. I use Coral Draw 12 (CD12) to show location changes of equipment in our building
    2. I use CD12 as I can very quickly drag graphics of the equipment about the plan.
    3. In moving the equipment from one location to another they come under the view of one or several of the many cameras we have (over 150 cameras).
    4. Although I am tracking around 150 pieces of equipment, usually only 3 or 4 are being moved at any one time
    5. I would like to import the ** 12 .cdr file into Excel - having got it there make each piece of equipment a radio button (is that what they are called?) that when the user's mouse rolls over it (or they click on it, if activation by rolling over is not possible) a message box comes up telling them what camera is now looking at that piece of equipment (it will have other information, like DVR and track number of the recorder of that camera)
    6. If the radio buttons were numbered (so I assume they would be in some VLOOKUP list) I would then only need to edit the VLOOKUP list to make the changes.

    I think that is fairly clear... if not I'll give it another go after you reply.

    I have been able to get text boxes to show the data (using insert comment) that I want but they are linked to the cell behind the imported graphic and the cells would not always match the position of the equipment on the graphic.

    Many thanks.

  4. #4
    Forum Contributor BlastRanger's Avatar
    Join Date
    09-02-2010
    Location
    Indonesia
    MS-Off Ver
    2003, 2007, 2010
    Posts
    238

    Re: Roll-over data reveal for an imported .cdr file in Excel

    You may need a database of your camera before proceed
    Please give a Reputation as a gift for a thanks.
    By clicking the second icon at the top right corner of a user post or reply

  5. #5
    Registered User
    Join Date
    12-02-2008
    Location
    Manila, The Philippines
    Posts
    22

    Re: Roll-over data reveal for an imported .cdr file in Excel

    An ideal situation would be to be able to import my .cdr floor plan file to excel put all the 'radio buttons' on it and just drag them about when the equipment moves.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1