For many years, when we were helping a customer select a model size, we had a
preprinted form that would guide us through the multi-step process of
gathering the hard data from the customer and plugging that data into the
various formulas. In addition, there are four different charts that provided
constants for the formulas. These constants were selected according to the
hard data provided by the customer. Someone finally put all our formulas into
an Excel program which has sped the process tremendoulsy, but the constants
must still be looked up and plugged in manually. Is there a way to put these
charts in the program? For instance, "If the motor speed is X and the tubing
size is Y, then read across the X row to the customer's X and down that
column to the customer's Y and use the number in that cell in the formula on
page 1, C35". All ideas, comments, and suggestions will be greatly
appreciated. Thanks, K.