Origin Pro Ver.8.5.0 SR1 b161 and Service Release (Select Help-->About Origin): Operating System:W7
Hello, I have two workbooks with multiple columns of type XYYYYY.., named reference and sample respectively. I want to divide the data of column in sample book with corresponding column in reference book. for example column A, row 3 in sample is divided by column A, row 3 in reference and so on. How can I do that? Please see the pictures. Nitya
For LT, simply loop through all columns and do calculations one by one.
For GUI method, convert both wks directly into two matrixes in the same Mbook, divide one by the other, then convert the result matrix back to wks.
OriginLab Zheng
I was able to create Mbook for both sheets separately and then I copied the reference Mbook data and put into the Mbook for Sample in Msheet2. But I don't get the option to divide Msheet1 by Msheet2. Am I doing it correctly or its wrong? I am not so familiar with Origin. Can you break down the steps please. Thank you.
int colnum = wks.ncols; // Number of columns for calculation
for ( ii = 1; ii <= colnum; ii++)
{
vmathtool -r 2 ix1:=[Sample]Sheet1!wcol(ii) operator:=div operand:=data ix2:=[Reference]Sheet1!wcol(ii) ox:=[Results]<active>!<new>;
// Sample, Reference are the workbook short names, Results is the destination workbook for results
}
dividing workbook 1 with workbook 2, column wise
Posted - 04/09/2015 : 07:08:58 AM
