Anuncios

The Autodesk Community Forums has a new look. Read more about what's changed on the Community Announcements board.

Anonymous
1721 Vistas, 4 Respuestas

Managing seating chart with excel/2016 AutoCAD LT

Hi all,

I’m seeing who can help me out.  I’m managing seating charts for multiple floors in an office building and am seeing the easiest ‘automated’ way of updating them.  I currently just have the floor layout, no seat numbers, names, etc… on the drawing.

 

At my previous job there we had a system to make the moves/adds/changes in excel and import to CAD via a command, it would then update the employee names in their physical spots on the drawing.

What’s the easiest way to get this going?

 

Thanks for any help!

pendean
en respuesta a: Anonymous

What was the previous system? Sounds like what you need, nothing built in will do that without a lot of setup and pre-configuration.
Anonymous
en respuesta a: Anonymous

Yah I figured it'd take a lot of setup.  Eventually I'm moving to Facilities Managemnt software, but wanted to streamline the process for now.  I have to input the intinal info anyway, so figured I'd see what I have to do to make it easier down the line.

Anonymous
en respuesta a: Anonymous

Hi Mgrantss,

I cought you chat only today..if the issue is still relevant i would  happy to intreduce you with the POC-SYSTEM solution for seating allocation system.
PLS feel free to contact me.
Best,
Offir

 

Click Here to get some more info

 

TheCADnoob
en respuesta a: Anonymous

I put together a response before i realized this was an old thread.. cest la vie

You could use data links.

 

First set up your Spread sheet that you will manage.

 

 Capture.PNG

 

next got to CAD and type in DATALINK

 

datalink dialog.png

 

create new and name it. You will have to do this for every seat location. so if there are 300 seats you will need 300 datalinks (unless you just want them all in a table)

 

datalink dialog2.png

 

Select a single cell for each link (unless you want a table)

 

datalink dialog3.png

 

once you have you data links created you place them where you want them by inserting a table in CAD and selecting datalinks as the source.

 

datalink dialog4.png

 

now you have the info in CAD linked to your excel file.

 

capture2.png

 

if you change it in excel you will get a notice in CAD.

 

Capture3.PNG

 

click on the update tables link and the chages will be reflected in CAD. 

 

Capture4.PNG

CADnoob

EESignature