No extrapolation added when averaging multiple curves
Optimization Solver app can be used to find solutions that minimize or maximize a function defined in a worksheet's cell. It can also be used for curve fitting by defining the residual sum of squares as the target function for minimization.
abs in the GCAS function is not necessary and so it’s removed now.
HTML Report Assistant app
Improved info. shows when mousing over the green lock
Moving Average Functions NANUM (Missing value) Ignore or Zero Issues
Improved tools that support group column with date time data so the output will be sorted by meaningful week, month, quarter, etc. order.
Enable Linear Constraints Status and Constraints are checked by default
Detrended Correspondence Analysis App can be used to perform detrended correspondence analysis (DCA). It is a multivariate method that corrects for the major problems (the arch effect and compression of the ends of the gradient) of Correspondence Analysis.
Neural Network Regression App fits data with neural network backpropagation.
Download Periodic Report app from the page and install the app.
With a worksheet window activated, click the app icon to bring up the dialog.
Choose Input columns for grouping, and date/time column for periodic calculation.
Select how to merge the input columns, including 1st point, last point, mean, sd, mean and sd
In Fitting Function Builder and NLFit dialog, there is Fitting Function Library link to download extra fitting functions provided by our website.
Makes it easier to build output range
Rank Models by Fit Reports app can be used to rank fitting functions by fit reports. It can find the optimal model by AIC, BIC, Adj. R-Square, Reduced Chi-Sqr or Residual Sum of Squares.
If all input Y has same sampling interval, no seperate X column will be created
ANOVA Result Worksheet adds Grouping Letters Table in Means Comparison
In Data Range box, user can enter (1:10)!A:B to do rowwise statistics of column A to B on sheets 1 to 10.
Buttons on summary sheet will also work if the Data source is Use Existing Data in batch processing
Support set sampling interval on locked columns
Apparent Integration App calculates apparent integral in Cartesian and polar coordinates according to the current axis scales.
In the past, Vertical cursor only worked for layers stacked vertically in same graph. Now it will work for layers even on the left or right side
Output designation not modified if column exists. Meaning: After recalculation, column designations should not be changed.
Fitting result table is wrong if using the theme for fitting.
No lock on source graph if using Dynamic input range and output to inputX newY.
Some bug fixes in Non-parametric text
Origin crashed when exporting ASCII via script during batch processing.
Output column pads top with missing values for those filtered out data
Some statistics tools failed if selecting discontinous ranges before open the dialog
Improved the speed of getting data for statistics on rows when doing batch processing with large source data.
Statistics on Rows fails to works when selecting input via Ctrl + click
Refine by Type
Refine by Category