2021 Apps

APPS-918

Create taylor diagram for facilitating the comparative assessment of different models.

Taylor Diagram app is capable of creating taylor diagram for facilitating the comparative assessment of different models.

• Download Taylor Diagram app from the page and install the app.

• Activate a worksheet with reference data selected, then click the app icon in the Apps gallery window, then a dialog will be brought up, and then choose test data, and set correlation coefficient range, and click OK button to create Taylor diagram.

APPS-950

Group data according to periodic date/time range using specified statistical value.

Periodic Report app is capable of grouping data according to periodic date/time range using specified statistical value.

• 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.

  1. Choose Input columns for grouping, and date/time column for periodic calculation.

  2. Select how to merge the input columns, including 1st point, last point, mean, sd, mean and sd, min, max, sum, and count.

  3. Change a start and end date/time accordingly, leave them Auto if you want to cover all the data.

  4. Consider the period for grouping you want, including second, minute, hour, day, month, quarter and year.

  5. For day period, you can also specify how many days as a period.

  6. If you have included prior periods, the result will not be merged for the same period in different "parent". For example, the period you choose is month, if not include prior periods, then all data in each month, Jan. for example, will be merged, but it does not care about the years. If include prior periods, Jan.'s data is merged by year, but not all years together.

  7. If there are some other columns need specific consideration, you can include other columns to handle them.

  8. Specify where to output the result, and then click OK button.