Hi fastelectron,
You seem to need to tailor a script for such repetitive calculation.
I couldn't figure out the xn part. Do you want to produce n columns from the first column of B?
Anyway, for yn part, I made the following script to do the job:For(ii=1; ii<=11; ii++) {
range cx=[Book4]!wcol(ii);
range ax=[Book3]!wcol(ii);
range bx=[Book2]!wcol(ii);
cx=bx/ax[2];
}To run this, I did the following steps (Book1 is your A, Book2 is your B):
1) Transpose Book1, and insert a column at the top of the result. (Book3)
2) Duplicate Book2 (to make Book4 for output), and run the script.
This produces the result in Book4 by dividing column n in Book2 by the column n row 2 in Book3.
(The first column is unchanged as I have put 1 to the first column of Book3.)
Hope this lets you start your job easier.
--Hideo Fujii
OriginLab
calculation across 2 worksheets
Posted - 07/26/2013 : 03:22:14 AM
