Hello. Can anyone tell me how to go about adding a parameter to a design table so that I can input different values for each configuration and then use the parameter to drive an equation? My final equation will be something similar to, Length@sketch1=( (new parameter -1) x a ) + b

Kevin,

If you are going to be using Design Tables, then you need to spend some time learning Excel. I'm not much of an expert at using it myself, but the most basic way I know to handle an equation like that is something like this;

Column E has your Pin Hole values, as in your design table. Somewhere else on your spreadsheet, separated by an empty row or column for a design table (so that they don't get included in the design table itself) are a couple of cells,say K2 and L2 with the values for your Spacing (68) and the Edge Width (35), say . In Column F, not D, I would have the equation that determines the Length. (That puts it after the column with the Pin Hole values. F3 would have =(E3-1)*$K$2+2*$L$2. The "=" tells Excel that you want to calculate the value for that cell. E3 is your Pin Hole value for that row, The $ before K tells Excel that you want to use Column K for the value, no matter which column you are calculating from. (Otherwise Excel uses relative locations.) the $ before 2 tells Excel that you want to use Row 2 for the value, no matter which row you are calculating from. You can then copy the equation in F3 into F4, F5 and F6. The new cells will calculate the value of Length based on E4, E5, and E6, respectively.

Jerry S.