Excel 2007 : Output Data list based on multiple input data

Hi All,

My problem is:
I have a data in sheet1 column A,B,C and D (all numbers and >10000rows).
For analysis on this data, i put additional input data in cell e1 and e2 (both numbers).
I uses columns F,g and h for my analysis formulas.
Out put of Analyzed data is written in cell e3.

On sheet2 i have a list of different combination of e1 and e2 s values in column A and B (around 1000 rows).

Now problem is that, I need to populate Column C Sheet2 with corresponding values of e3 and I don't know how can i do this?
One additional condition is that for each combination of e1 and e2, analysis takes around 5second to generate e3.


Thanks in Advance

agoelg

What is the relationship between e1, e2 and e3? How do these relate to your data in columns A to D ? It would be better if you could post an example workbook with a clearer explanation of what you want to achieve.

Hope this helps.

Pete

Hi Pete,

I have created a sample workbook to explain my problem.

You can see in attached workbook i manually do following things:
1. enter input data in sheet1 cell e1 and e2, taken from sheet2 column A and B (row 1,2,....)
2. when output come in sheet1 cell e3, i copy it and paste (by value) in sheet2 column C (corresponding row).

What i want is to automate this procedure.


agoelg

Put this formula in C2 of Sheet2:

=SQRT((SUM(Sheet1!C$1:C$10000)+(SUM(Sheet1!B$1:B$10000)+SUM(Sheet1!A$1:A$10000))/A2)/B2)

then copy down - an easy way to do this is with C2 selected, double-click the fill handle, which is the small black square in the bottom right corner of the cursor.

Hope this helps.

Pete

I have crated only a sample workbook for purpose of describe my problem.

In actual workbook, it contains around 20MB of data and very complex multistage analysis.
But as per my problem description final result or final smallest formula is written in Sheet1 cell e3.


I can copy last e3 formula in sheet2 as suggested above but can not copy entire analysis.


agoelg

So, what do you want me to do, then?

Pete

I requires to automate that
1. take Input data for cell e1 and e2 (sheet1) from column A, B on sheet2 and row x (2,3,4,....); then wait for 10-15 second; then copy output data in cell e3 sheet1 to column C row x of sheet2.
2. do step 1 one by one for each row in sheet2.



agoelg

Well, that seems like a strange way of doing things.

Anyway, I'm away later today for a few days, so I won't be able to help anymore on this.

Pete