Mathematical tool input/output design

Originally Posted by mikeTRON

I don't see where the output is or how that is related to the TOOL workbook.

Calculating what you have done in the TOOL workbook into the DATA workbook is rather simple

J4:

=A4*B4*C4

K4:

=B4*C4*D4

L4:

=C4*D4*E4

M4:

=SUM(J4:L4)

hi miketron,

Thank you for the reply. Actually the tool uploaded is simple, the actual tool is really complicated. Its a cluster of many results. so it would be difficult for me to put in the formula in the data work book. i would like the a,b,c,d and e values to be imported from the data workbook to the tool workbook, the tool workbook does the calculation and it exports the outputs( output1, output2 , output 3 and output 4) back to the data work sheet.