Attribute value change from variable attribute

[Joe_Simes]

Good morning/afternoon,

I have a drawing border that I am putting together that requires a group of numbers to change based on an attribute value that the use will input. I have put a version of the table attached. The user will change the attributes in yellow, which will be visible elsewhere on the border, and I wish it to auto update the titles in blue ( I have linked these as an object value, so I think this works fine). By changing these numbers, I wish the attributes in red in the table, to auto update to a new number from a list (I have put an example list in the model space). Is there a straight way of doing this? I ideally want the users to change one variable (Inlet_Size/Outlet_Size) and the table to update with the correct figures.

I would accept the data being pulled from Excel, but if it can all remain within ACAD that would be preferred, as I wish to make this a template for the business to use.

Yellow Text - User input

Blue Text - Auto Update Titles

Red Text - Data associated with Yellow text (see table for example data)

Green text - Multiplier of Red text value in adjacent cell

Any thoughts?

[wispoxy]

I'm trying to understand this. So you are saying:
1. User inputs or modifies the yellow text.
2. Blue text automatically changes to match yellow text.
3. Green text populates the chart it's on based on the red text values.

Questions:
a.) If blue equals yellow, why even have the yellow text if they can just change the value where blue is?
b.) What does IFX and OFX mean, Input and output values with multipliers?
c.) So Y*R = G, Yellow value multiplied Red value equals blue value?
d.) You want to automate a calculation based on a formula because you don't want the user to do the calculations, and you want the answer to populate the chart? They input the values and it does the math for them.

[wispoxy]

1. In a Table Cell:

   • Click inside a cell.
   • On the Table Cell contextual ribbon, click Field.
   • In the Field dialog box, select Objects from the Field Category list.
   • Choose Formula from the Field Names.
   • To enter a formula, you can:
     • Click Average, Sum, or Count to perform calculations.
     • Specify a range by clicking inside the first and last cell; the result will be appended to the formula.
     • Click Cell to include the cell address in the formula.
   • Optionally, select a format and decimal separator.
   • Click OK to save your changes.
   • The cell will display the result of the calculation.

2. In Extracted Data:

   • If you’re working with extracted data, follow these steps:
     • On the Refine Data page, right-click a column label and choose Insert Formula Column.
     • In the Insert Formula Column dialog box, enter a name for the formula column.
     • Double-click a column name in the Columns list to add it to the formula.
     • Use operator buttons (+, -, *, /) to build your formula.
     • The result will display in the formula field.