PDA

View Full Version : Tables - Can you have formulas in them?



hardwired
6th Mar 2008, 11:33 am
Hi,

Having never worked with acad tables, can they have formulas in them, like in excel?

NBC
6th Mar 2008, 11:48 am
Yes, I believe they can.
http://forums.augi.com/archive/index.php/t-26778.html

ReMark
6th Mar 2008, 11:48 am
I believe you can. Take a look at this:

http://jtbworld.blogspot.com/2005/04/autocad-2006-and-formulas-in-fields.html

dbroada
6th Mar 2008, 12:00 pm
as the others have said, yes it can - I've done it

but I can't find the drawing I did it on. I had a bit of trouble getting the syntax but once found it was pretty straightforward. I don't think I would trust it for multiple linked cells but for this cell = that one * the other one it worked well enough for me. If I was to go any more complex I would use a linked excel sheet. (with 2008 )

hardwired
6th Mar 2008, 12:18 pm
Brilliant thanks,

I just want simple formulae, like -, +, *, / really, maybe the odd occasional SUM as in excel, maybe a bit of bracketed maths but nothing STEPHEN HAWKING'esque

dbroada
6th Mar 2008, 12:29 pm
oh look, it's easy :oops:

ReMark
6th Mar 2008, 12:35 pm
Use formulas in table cells (a how to):

http://www.kxcad.net/autodesk/autocad/AutoCAD_2008_Users_Guide/d0e95342.htm

SLW210
6th Mar 2008, 05:52 pm
Does anyone know if you can Paste Formulae from Excel into the AutoCAD Table? Haven't tried yet, but is something I have need to do in the near future. Hoping not to need to retype them.

ReMark
6th Mar 2008, 06:03 pm
SLW210: AutoCAD 2008 and Excel. Might be worth a look. I didn't read all the way through so I cannot answer your question.

http://www.dscohn.com/speaking/2008%20AutoCAD%20Tables.pdf

SLW210
6th Mar 2008, 06:09 pm
SLW210: AutoCAD 2008 and Excel. Might be worth a look. I didn't read all the way through so I cannot answer your question.

http://www.dscohn.com/speaking/2008%20AutoCAD%20Tables.pdf

Thanks I will read through it later. :thumbsup:

dbroada
6th Mar 2008, 07:32 pm
my (home) internet is flakey atm so I can't read through that but excel does work better with 2008 than before. You can create a table from an excel file and then change the data in either application. When the data is out of sync AutoCAD doesn't update but will prompt you. You can then declare whether AutoCAD or excel has the master data set.

SLW210
6th Mar 2008, 11:09 pm
my (home) internet is flakey atm so I can't read through that but excel does work better with 2008 than before. You can create a table from an excel file and then change the data in either application. When the data is out of sync AutoCAD doesn't update but will prompt you. You can then declare whether AutoCAD or excel has the master data set.

That's what I was thinking and hoping for. http://img126.exs.cx/img126/997/36_1_11.gif