Hi Daniel,
For col(A)'s max modulus with col(D)[1], you can add two columns, E and F. Then, you can use the Set Col Values formula for col(E):
rmod(col(A),col(D)[1])
(Here rmod gives the modulus of col(A) divided by col(D)[1].)
then the "Before Formula Script" script for col(F):
sum(col(e));
col(f)[1]=sum.max;
Add another two columns to calculate for column B.
For automatic recalculation of Set Column Values, set the "Recalculate" mode to "Auto" in that tool so that when you change the original data, it triggers the recalculation to update the result.
Hope this is what you're looking for.
--Hideo Fujii
OriginLab
Modulus Values
Posted - 07/04/2011 : 5:48:50 PM
