Table calculating values given nominal dimensions

[mrkevinrosales]

Hello,

I am trying to create a dynamic block that will allow me to run up to 10 calculations given pipe diameters and elevations.

The attached image shows the basic layout of the table I want to create, ideally it would use visibility states to show up to 10 rows.
The user would enter the pertinent values and then the 'Height" parameter would be calculated.

The calculation would be RIM - INVERT - MAIN D = HEIGHT
The issue I am having is that the 'Main D' parameter needs to be entered in nominal values, but the calculation will use a completely different number.
i.e. Entering 1200 would actually need to use 1.285 in the calculation.

There is only 4 nominal values that need to be accounted for so I figured I could use a lookup table but I am at a loss as to how to go about it since look up in AutoCAD is much different than it is in Excel.

Any and all help would be greatly appreciated

[Libbya]

There are several methods that seem like they might work, but which method would be best to use (or even work) would depend on more details than what you have provided.  You say there are 4 values for MAIN D, well that's easy to deal with.  What about the other values?  Are those also to be chosen from a specific list of values or do some of them need to be infinitely variable?  If all you are looking to do is manipulate text in a table, then no visibility states are needed.  If you want to add/remove rows from the table then visibility states are probably the way to go. 

All of the above is somewhat vague, but is as detailed as possible with the information you have provided.  If you want further assistance, then post the actual file you are working with.  Within that file, give details on how you want the block to behave, including details about each variable value and whether it can be selected from a list or needs to be infinitely variable.  Give details on what formula is used for each variable that is calculated based on the other variables.   

[mrkevinrosales]

Additional Information

I have added an excel file which does the calculation that I want this block to do.

The user enters a RIM value and an INVERT value and selects the MAIN D value from a drop down (Drop down not needed this just ensures that the correct value is entered)

The HEIGHT value is then calculated based on the lookup table.

The MAIN D value is the only value that is tied to specific values, the rest of the values in the table would be unrestricted

I have also added a CAD file with two iterations of the block that I have started

I want to be able to easily add/remove rows from the table

The first block uses attributes and a distance parameter to add more rows while the second uses visibility states, I am not tied to either option

Neither option has working lookup parameters yet

[mrkevinrosales]

Thank you for your feedback, I have replied to my original post with additional information