OASIS Open Document Format for Office Applications (OpenDocument) TC

  • 1.  OFFICE-1148 regression type moving-average

    Posted 06-07-2018 13:45
    Hi all, this is the first draft for the feature "moving-average". I have found three type of it: "prior": Used in Excel, LibreOffice, Gnumeric, and Google Docs("einfach" in my UI) "central": Used in Google Docs ("zentriert" in my UI) "twodimensional": Used in Gnumeric. Andreas, I have called it "twodimensional", but feel free to suggest a better word for Gnumeric. I have made a .odt document with LibreOffice for to use the formula editor. Sub- and Superscript do not work well in Jira, if you switch between visual- and text-mode for and back. The diff is against the version with applied polynomial. The text would have to be merged with that from polynomial. Please review the formulas and improve the wording. Kind regards Regina --- OpenDocument-schema-v1.3_regression_curve1.rng 2018-06-05 23:59:49.276136600 +0200 +++ OpenDocument-schema-v1.3_regression_curve2.rng 2018-06-07 15:29:23.536501500 +0200 @@ -9991,10 +9991,11 @@ <rng:attribute name="chart:regression-type"> <rng:choice> <rng:value>none</rng:value> <rng:value>linear</rng:value> <rng:value>logarithmic</rng:value> + <rng:value>moving-average</rng:value> <rng:value>exponential</rng:value> <rng:value>power</rng:value> <rng:value>polynomial</rng:value> </rng:choice> </rng:attribute> @@ -10017,10 +10018,24 @@ <rng:optional> <rng:attribute name="chart:regression-name"> <rng:ref name="string"/> </rng:attribute> </rng:optional> + <optional> + <rng:attribute name="chart:regression-period"> + <rng:ref name="positiveInteger"/> + </rng:attribute> + </optional> + <optional> + <rng:attribute name="chart:regression-moving-type"> + <rng:choice> + <rng:value>prior</rng:value> + <rng:value>central</rng:value> + <rng:value>twodimensional</rng:value> + </rng:choice> + </rng:attribute> + </optional> <rng:optional> <rng:attribute name="chart:axis-position"> <rng:choice> <rng:value>start</rng:value> <rng:value>end</rng:value> Attachment: OFFICE-1148 RegressionCurveFileFormat_new_moving_average.odt Description: application/vnd.oasis.opendocument.text


  • 2.  Re: [office] OFFICE-1148 regression type moving-average

    Posted 06-10-2018 20:50
    Hi, this looks good to me with two comments/changes: 1) we need to say that the trendline in the case of moving-averages is a piecewise linear and continuous function. I have included such a sentence in the attached file. 2) In the Gnumeric interface your two-dimensional it called use averaged abscissa , so I would suggest we are using averaged-abscissa . Andreas On 2018-06-07 07:45 AM, Regina Henschel wrote: Hi all, this is the first draft for the feature moving-average . I have found three type of it: prior : Used in Excel, LibreOffice, Gnumeric, and Google Docs( einfach in my UI) central : Used in Google Docs ( zentriert in my UI) twodimensional : Used in Gnumeric. Andreas, I have called it twodimensional , but feel free to suggest a better word for Gnumeric. I have made a .odt document with LibreOffice for to use the formula editor. Sub- and Superscript do not work well in Jira, if you switch between visual- and text-mode for and back. The diff is against the version with applied polynomial. The text would have to be merged with that from polynomial. Please review the formulas and improve the wording. Kind regards Regina --------------------------------------------------------------------- To unsubscribe from this mail list, you must leave the OASIS TC that generates this mail. Follow this link to all your TCs in OASIS at: https://www.oasis-open.org/apps/org/workgroup/portal/my_workgroups.php -- Andreas J. Guelzow, PhD FTICA Registrar & Director of Enrolment Services Professor, Mathematical & Computing Sciences Direct: +1 780 479 9290 Toll-Free: +1 866 479 5200 concordia.ab.ca Attachment: OFFICE-1148 RegressionCurveFileFormat_new_moving_average.odt Description: application/vnd.oasis.opendocument.text


  • 3.  Re: [office] OFFICE-1148 regression type moving-average

    Posted 06-10-2018 21:02
    I should have noted that the central used here is what Google Docs (in Canada) calls centered but of course for even period it is not truly centered. This also differs from what was asked for in the original request for central . SO we may want to consider using the term centered as used by Google Docs in English language. Just as a note, prior is called by Google Docs trailing . GNumeric does not have a term for it (it is the default if not averaged-abscizza ). Andreas On 2018-06-07 07:45 AM, Regina Henschel wrote: Hi all, this is the first draft for the feature moving-average . I have found three type of it: prior : Used in Excel, LibreOffice, Gnumeric, and Google Docs( einfach in my UI) central : Used in Google Docs ( zentriert in my UI) twodimensional : Used in Gnumeric. Andreas, I have called it twodimensional , but feel free to suggest a better word for Gnumeric. I have made a .odt document with LibreOffice for to use the formula editor. Sub- and Superscript do not work well in Jira, if you switch between visual- and text-mode for and back. The diff is against the version with applied polynomial. The text would have to be merged with that from polynomial. Please review the formulas and improve the wording. Kind regards Regina --------------------------------------------------------------------- To unsubscribe from this mail list, you must leave the OASIS TC that generates this mail. Follow this link to all your TCs in OASIS at: https://www.oasis-open.org/apps/org/workgroup/portal/my_workgroups.php -- Andreas J. Guelzow, PhD FTICA Registrar & Director of Enrolment Services Professor, Mathematical & Computing Sciences Direct: +1 780 479 9290 Toll-Free: +1 866 479 5200 concordia.ab.ca