Results 1 to 8 of 8

Thread: Linking object in a drawing to an external Excel Spreadsheet

  1. #1
    Member
    Join Date
    2013-04
    Posts
    6
    Login to Give a bone
    0

    Default Linking object in a drawing to an external Excel Spreadsheet

    Hey Everyone, first post here,

    This may have been asked somewhere else (I'm in a bit of a hurry) but what I'm trying to do is this:

    I have a co-worker who is in charge of all the lighting here on my college campus. What he wants is to be able to open the drawing of campus and be able to click on a light and view all the information about the light (all contained within an external xls file) and that light only...Everything I've seen so far has done nothing but insert a table on the drawing and that's not what we want (as seen here on this video tutorial: http://youtu.be/QLGoxHMg8Zw). Again, we just want to be able to click on a light and see just the information for that light (basically the row corresponding to that light's ID in excel).

    Any help will be greatly appreciated!

    -BethelCAD

  2. #2
    Mod / Salary / SM Wanderer's Avatar
    Join Date
    2001-12
    Location
    St. Louis
    Posts
    5,301
    Login to Give a bone
    0

    Default Re: Linking object in a drawing to an external Excel Spreadsheet

    Quote Originally Posted by bethelcad370537 View Post
    Hey Everyone, first post here,

    This may have been asked somewhere else (I'm in a bit of a hurry) but what I'm trying to do is this:

    I have a co-worker who is in charge of all the lighting here on my college campus. What he wants is to be able to open the drawing of campus and be able to click on a light and view all the information about the light (all contained within an external xls file) and that light only...Everything I've seen so far has done nothing but insert a table on the drawing and that's not what we want (as seen here on this video tutorial: http://youtu.be/QLGoxHMg8Zw). Again, we just want to be able to click on a light and see just the information for that light (basically the row corresponding to that light's ID in excel).

    Any help will be greatly appreciated!

    -BethelCAD
    Welcome to AUGI!

    I haven't done this myself with vanilla autocad, but, while you wait for someone who can give you advice on that... I'm curious if your campus's maintenance department uses a CAFM or CMMS, those seem like much better tools to manage a lot of data?

    If they don't, AutoCAD Map3D might be a better choice than vanilla AutoCAD.

    I work on a medical campus and was wondering the same things years ago, but, based upon advice and research, decided that if we do something like this, it will be through our existing CMMS program or through adding CAFM components (there's a facilities management forum here that might contain some related topics, but, is not focused on autocad).
    Melanie Stone
    @MistresDorkness

    ARCHIBUS, FMS/FMInteract and AutoCAD Expert (I use Revit and Tririga, too)
    Technical Editor
    not all those who wander are lost

  3. #3
    Certifiable AUGI Addict cadtag's Avatar
    Join Date
    2000-12
    Location
    Cairo - no, not Illinois
    Posts
    4,761
    Login to Give a bone
    0

    Default Re: Linking object in a drawing to an external Excel Spreadsheet

    Map3d makes it feasible - , but as far as vanilla acad - it's do-able with some custom programming, just not OOTB
    Real pirates wear silk suits & ties, and write EULAs
    The only thing more dangerous to the liberty of a free people than big government, is big business.

    Toward a Sustainable Water Future: Visions for 2050 http://ascelibrary.org/doi/book/10.1061/9780784412077

  4. #4
    Certified AUGI Addict jaberwok's Avatar
    Join Date
    2000-12
    Location
    0,0,0 The Origin
    Posts
    8,569
    Login to Give a bone
    0

    Default Re: Linking object in a drawing to an external Excel Spreadsheet

    I don't know, it's just off the top of my head but -
    could you make a hyperlink point to single row in a file?
    John B

    "You can't convince a believer of anything; for their belief is not based on evidence, it's based on a deep-seated need to believe." - Carl Sagan

  5. #5
    Member
    Join Date
    2013-04
    Posts
    6
    Login to Give a bone
    0

    Default Re: Linking object in a drawing to an external Excel Spreadsheet

    Quote Originally Posted by Wanderer View Post
    Welcome to AUGI!

    I haven't done this myself with vanilla autocad, but, while you wait for someone who can give you advice on that... I'm curious if your campus's maintenance department uses a CAFM or CMMS, those seem like much better tools to manage a lot of data?

    If they don't, AutoCAD Map3D might be a better choice than vanilla AutoCAD.

    I work on a medical campus and was wondering the same things years ago, but, based upon advice and research, decided that if we do something like this, it will be through our existing CMMS program or through adding CAFM components (there's a facilities management forum here that might contain some related topics, but, is not focused on autocad).
    As far as I know we don't have any CAFM or CMMS (to be honest I've never heard about either one) and I just have access to just plain ol' AutoCAD 2012 Arch. so I may be stuck with just doing custom programming.

    And Cadtag, how would I go about doing said custom programming?

    jaberwok: I think I tried that but what it did (if I'm understanding you correctly) was open to the whole spreadsheet...I'm looking more for something along the lines of the quick properties box that pops up when double clicking a line, block, etc.

  6. #6
    Mod / Salary / SM Wanderer's Avatar
    Join Date
    2001-12
    Location
    St. Louis
    Posts
    5,301
    Login to Give a bone
    0

    Default Re: Linking object in a drawing to an external Excel Spreadsheet

    Quote Originally Posted by bethelcad370537 View Post
    As far as I know we don't have any CAFM or CMMS (to be honest I've never heard about either one) and I just have access to just plain ol' AutoCAD 2012 Arch. so I may be stuck with just doing custom programming.
    I hadn't heard of them either, until I happened to be called into a meeting one day when we got a new VP who'd come from a hospital up east who couldn't believe we didn't have CAFM.

    The CMMS (computerized maintenance management system) is usually owned by Operations/Maintenance and manages their work orders and preventative maintenance scheduling, but, since they've got so much information there already about equipment specs and history, it would be a good place to start to plug in.

    A CAFM (computer-aided facility management) is usually used first by space management, handling leases and departmental moves, etc, but, obviously, since it's got all of the space data inside, it's perfect for asset management of any stripe. We haven't gotten our CAFM installed yet, but, when we do, engineering, finance, real estate, construction, and other departments (maybe IT, telecomm and key control?) will buy a single license to plug into the program so they can use it how they need as well.
    Melanie Stone
    @MistresDorkness

    ARCHIBUS, FMS/FMInteract and AutoCAD Expert (I use Revit and Tririga, too)
    Technical Editor
    not all those who wander are lost

  7. #7
    Administrator Ed Jobe's Avatar
    Join Date
    2000-11
    Location
    Turlock, CA
    Posts
    5,656
    Login to Give a bone
    0

    Default Re: Linking object in a drawing to an external Excel Spreadsheet

    Quote Originally Posted by bethelcad370537 View Post
    As far as I know we don't have any CAFM or CMMS (to be honest I've never heard about either one) and I just have access to just plain ol' AutoCAD 2012 Arch. so I may be stuck with just doing custom programming.
    If you have ACA, then are you not using arch objects, i.e. Light styles? If you are using ACA objects, the look into property set definitions. Also, ask this in the ACA forum, not plain acad. If the lights are just plain blocks, you might be able to add schedule data to them. If so, you can customize Quick Properties to display some of the info you want.
    C:> ED WORKING....

  8. #8
    Member
    Join Date
    2013-04
    Posts
    6
    Login to Give a bone
    0

    Default Re: Linking object in a drawing to an external Excel Spreadsheet

    Quote Originally Posted by Ed Jobe View Post
    If you have ACA, then are you not using arch objects, i.e. Light styles? If you are using ACA objects, the look into property set definitions. Also, ask this in the ACA forum, not plain acad. If the lights are just plain blocks, you might be able to add schedule data to them. If so, you can customize Quick Properties to display some of the info you want.
    Sorry for the confusion, but upon further review I just have plain acad 2012...I also contacted my predecessor and he said he may have made some blocks and so I'll have to try and find those, if not just create the blocks myself.

Similar Threads

  1. Excel spreadsheet linking problem
    By tlepird2925761 in forum Inventor - General
    Replies: 15
    Last Post: 2019-03-12, 10:18 AM
  2. Linking Excel spreadsheet to AutoCAD
    By dmcdonald.156724 in forum AutoCAD General
    Replies: 6
    Last Post: 2008-01-09, 11:37 PM
  3. Linking AutoCAD Object data directly to Excel
    By Shizzjr in forum AutoCAD General
    Replies: 4
    Last Post: 2007-04-10, 08:17 PM
  4. Linking Excel Sheet as OLE object
    By jmckiness in forum AutoCAD LT - General
    Replies: 5
    Last Post: 2005-08-25, 11:43 AM
  5. Excel Spreadsheet wrong size insert & Linking
    By 3D Jack in forum AutoCAD General
    Replies: 3
    Last Post: 2005-07-11, 10:38 PM

Tags for this Thread

Posting Permissions

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