Anuncios

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

Managing seating chart with excel/2016 AutoCAD LT

Anonymous

Managing seating chart with excel/2016 AutoCAD LT

Anonymous
No aplicable

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!

0 Me gusta
Responder
1.723 Vistas
4 Respuestas
Respuestas (4)

pendean
Community Legend
Community Legend
What was the previous system? Sounds like what you need, nothing built in will do that without a lot of setup and pre-configuration.
0 Me gusta

Anonymous
No aplicable

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.

0 Me gusta

Anonymous
No aplicable

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

 

0 Me gusta

TheCADnoob
Mentor
Mentor

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

0 Me gusta