Mathematical tool input/output design

Hello friends,

I have designed an excel mathematical tool for automotive application. The tool needs 5 inputs ( 1 data set ) and it returns 4 outputs. The problem is that i have 20000 data sets( each data set having 5 inputs) and i need to calculate the outputs( 4 outputs for each data set) for 20000 data sets. It would be really grateful if u guys can try helping me out. I would really appreciate if someone could explain me step by step wat has to be done. Due to my work policy i wont be able to upload my the original file. I have made two mock excel files ( Tool and Data) which kinda represents the original files. The mathematical excel tool cannot be modified (Client Requisites) . The data sheet has around 50 data sets and i need the output on the same data sheet. Comprehensively speaking the mathematical tool has to get the input data from the data sheet and publish the output on the same data sheet.

PS: - Moderator could please move this query to appropriate thread.

Regards

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.