Creating a dynamic legend with fields

[Anonymous]

Hello

I am trying to create a legend using insertable blocks. The aim is to have a block that when inserted will prompt for a few entries of information and calculate some values. Namely:

Field entries:

1. Item no - to be entered by user
2. Quantity - to be entered by user
3. Power value one - to be entered by user
4. Power value two - to be entered by user
5. Total power - to be calculated as quantity x (sum of 3+4)

Can anyone suggest how I might achieve the above?

Thank you

[pendean]

You will need to customize with LISP if a simpler predefined TABLE object (where you users are trained to enter the required data) is not an option.

Can you show us a sample as a DWG file?

[Anonymous]

Hello - file attached. The aim would be to add in another "column" for the load total. Then make each option for connections a pull down option list of standard text. Unless you could add pull down options in a cell within a table, much like callouts in excel?

[jeff_rivers]

How about creating the entire legend & calculations in Excel, then using the <Link Data> command on the Annotate ribbon to link to and insert the Excel as a table in your drawing.  Then if any entries have to be edited or updated, once the Excel file is edited and saved, the Data Link will update the drawing automatically.  

[Anonymous]

Hello

Yes that is the way we currently do it. Unfortunately this causes us a lot of problems when transferring drawings to other companies. Some don't use excel, some only use cad 2010 etc.