Improved trend lines (CorelPolyGUI)
CorelPolyGUI plots extra trend lines such as linear and polynomial with forced intercept option, or moving average.
Project Description
Français Polski
CorelPolyGUI try to answer the some main issues about trend lines:
- issue 20819 for OOo or issue 35712 for LibO: polynomial trend line: from Xdata and Ydata, find ai coefficients to fit equation Ycalc = sum ai . Xdatai
- issue 34093 for OOo or issue 40314 for LibO: forced intercept option: fix (or not) the intercept value for linear or polynomial regressions
- issue 66819 for OOo or issue 40315 for LibO: moving average trend line
However it is "just" an extension: it is not integrated in LibreOffice trend line dialog box, but available through menu Tools > Add-ons. A Java environment is required.
How-to
French readers can follow this How-To.
Available functionalities
- negative degrees available for polynom
- choose value of forced intercept (0,Y)
- several options for moving average:
- simple: average with prior and next points
- cumulative: average with all points from the begining
- weighted: linear weighting of N previous points
- exponential: exponential weighting of all previous points
- give polynomial equation and determination coefficient (R²)
- plot experimental points and calculated curve on new or existing chart
- all classic regressions also available with same options
- spline interpolation
- t-statistics on results
- English, Polish and French localization
Limitations
- Xdata and Ydata must be in the same sheet
- Xdata and Ydata must start from the same row
Known problems
- If the installation freezes: kill LibO/OOo, start installation again without removing previous broken, the second time it should go without problems.
- If it does not work on MacOS, please use the standalone version.
Help wanted
This extension may be improved with translation in other languages (English, French and Polish localization available right now). If you can translate this extension in your own language, please let us know!
Acknowledgment
This extension is the result of co-operation the following persons: Marcin Gutman (coding), Laurent Balland-Poirier (QA), Laurent Godard (CorelPoly) and Björn Vennberg (SLAMLib).
=====================================================
Français : Amélioration des courbes de tendance (CorelPolyGUI)
Description du projet
CorelPolyGUI propose quelques fonctionnalités manquantes concernant les courbes de tendance :
- issue 20819 pour OOo ou issue 35712 pour LibO : courbe de tendance polynomiale : à partir de données Xdata et Ydata, trouver les coefficients ai pour suivre l'équation Ycalc = sum ai . Xdatai
- issue 34093 pour OOo ou issue 40314 pour LibO : fixer l'ordonnée à l'origine : fixer (ou pas) la valeur de l'ordonnée à l'origine pour les régressions polynomiale ou linéaire
- issue 66819 pour OOo ou issue 40315 pour LibO: courbe tendance moyenne mobile
Cependant, il ne s'agit "que" d'une extension : elle n'est pas intégrée dans la boite de dialogue des courbe de tendance de LibreOffice. Un environnement Java est requis.
Tutoriel
Un tutoriel en français est disponible sur le wiki.
Fonctionnalités disponibles
- degrés négatifs pour les courbes polynomiales
- choix de la valeur de l'ordonnée à l'origine (0,Y)
- plusieurs options pour la moyenne mobile :
- arithmétique : moyenne sur les points précédents et/ou suivants
- cumulative : moyenne sur tous les points depuis le début
- pondérée : pondération linéaire des N précédents points
- exponentielle : pondération exponentielle de tous les points
- coefficients de la régression polynomiale et le coefficient de détermination (R²)
- trace les points expérimentaux et la courbe calculée sur un nouveau diagramme ou un diagramme existant
- toutes les régressions classiques sont également disponibles avec les mêmes options
- interpolation par spline
- statistiques sur les résultats
- localisation en anglais, polonais et français.
Limitations
- Xdata et Ydata doivent dans la même feuille
- Xdata et Ydata doivent démarrer de la même ligne
Problèmes connus
- Si l'installation fige : tuer le processus LibO/OOo, redémarrer l'installation de CorelPolyGUI sans retirer l'installation précédente défectueuse ; le second essai devrait bon.
- Si l'extension ne fonctionne pas en environnement MacOS, utilisez la version Standalone.
On recherche de l'aide
Si vous pouvez traduire cette extension dans votre langue, n'hésitez pas à laisser un commentaire !
Remerciements
Cette extension est le fruit des travaux conjugués de Marcin Gutman (programmation), Laurent Balland-Poirier (Assurance Qualité), Laurent Godard (CorelPoly) et Björn Vennberg (SLAMLib).
=====================================================
Polski: Ulepszona regresja (CorelPolyGUI)
Opis projektu
CorelPolyGUI jest rozwiązaniem następujących problemów:
- issue 20819 for OOo or issue 35712 for LibO: polynomial trend line: from Xdata and Ydata, find ai coefficients to fit equation Ycalc = sum ai . Xdatai
- issue 34093 for OOo or issue 40314 for LibO: forced intercept option: fix (or not) the intercept value for linear or polynomial regressions
- issue 66819 for OOo or issue 40315 for LibO: moving average trend line
CorelPolyGUI jest niezależnym rozszerzeniem i nie jest zintegrowany z oknem regresji. Rozszerzenie uruchamia się poprzez menu Narzędzia > Dodatki. W systemie musi być zainstalowana Java.
Praktyczny poradnik
French readers can follow this How-To.
Dostępne funkcje
- ujemne wykładniki wielomianu
- wymuszenie przecięcia (0,Y)
- średnie ruchome:
- prosta: uwzględnia punkty przed/za wybranym punktem
- skumulowana: uwzględnia wszystkie punkty przed wybranym punktem
- ważona: uwzglęnia N punktów z wagami przed wybranym punktem
- wykładnicza: uwzględnia wszystkie punkty z wagami wykładniczymi przed wybranym punktem
- wypisanie współczynników wielomianu i współczynnika determinacji (R²)
- utworzenie wykresu z danymi eksperymentalnymi i obliczonymi
- odmiany regresji liniowej (logarytmiczna, wykładnicza, potęgowa)
- interpolacja przy użyciu funkcji sklejanych
- wypisanie statystyki t-studenta
- języki: polski, angielski, francuski
Ograniczenia
- dane X i Y muszą być w tym samym arkuszu
- dane X i Y muszą zaczynać się w jednym wierszu/li>
Znane problemy
- Jeżeli proces instalacji zawiesi się należy zamknąć i uruchomić ponownie LibO/OOo, rozpocząć instalację jeszcze raz bez usuwania poprzedniej uszkodzonej.
- Wersja w formie pliku "oxt" nie działa pod MacOS. W takim przypadku pobierz wersję samodzielną.
Help wanted
This extension may be improved with translation in other languages (English, French and Polish localization available right now). If you can translate this extension in your own language, please let us know!
Acknowledgment
Rozszerzenie jest efektem współpracy następujących osób: Marcin Gutman (coding), Laurent Balland-Poirier (QA), Laurent Godard (CorelPoly) and Björn Vennberg (SLAMLib).
Current Release
Improved trend lines (CorelPolyGUI) 1.4.4
Released Feb 19, 2012 — tested with LibreOffice 3.3, LibreOffice 3.4, LibreOffice 3.5
Add moving average trend line.
For MacOS users, if extension does not work, please try the standalone version.
More about this release…
-
Get
Improved trend lines (CorelPolyGUI)
for
All platforms
- Extension Package
-
Get
Improved trend lines (CorelPolyGUI)
for
All platforms
- Standalone Version
-
Get
Improved trend lines (CorelPolyGUI)
for
All platforms
- Source code
- If you don't know, how to install an extension in LibreOffice, see our howto about installing extension for detailed instructions.
All Releases
| Version | Released | Description | Compatibility | Licenses | Status |
|---|---|---|---|---|---|
| 1.4.4 | Feb 19, 2012 | Add moving average trend line. For MacOS users, if extension does not work, please try the standalone version. More about this release… |
LibreOffice 3.3
LibreOffice 3.4
LibreOffice 3.5
|
GPL-v3 GPL-v3 |
final |
| 1.4.3 | Feb 15, 2012 | Add moving average trend line. For MacOS users, if extension does not work, please try the standalone version. More about this release… |
LibreOffice 3.3
LibreOffice 3.4
LibreOffice 3.5
|
GPL-v3 |
final |
| 1.0.1 | Oct 05, 2011 | Fixed inconsistency in function naming convention (parameters a/b) More about this release… |
LibreOffice 3.3
LibreOffice 3.4
LibreOffice 3.5
|
GPL-v3 |
final |
| 1.0.0 | Oct 04, 2011 | Totally new version : more user friendly interface all regressions available (exp, ln,...) force intercept option with all regression more robust polynomial regression t-statistic on results More about this release… |
LibreOffice 3.3
LibreOffice 3.4
|
GPL-v3 |
final |
| 0.3.3 | Oct 04, 2011 | Correction of wrong "Invalid Output Range" error message. More about this release… |
LibreOffice 3.3
LibreOffice 3.4
|
GPL-v3 |
final |
| 0.3.2 | Same as last version of OOo extension website More about this release… |
LibreOffice 3.3
LibreOffice 3.4
|
GPL-v3 |
beta |
Legal Disclaimer and Limitations for Downloads
Responsibility of Website User
The Document Foundation has not reviewed, and cannot review, all of the material, including computer software, available on or by means of The Document Foundation's websites, and cannot therefore be responsible for that material's content, use or effects. By operating its websites, The Document Foundation does not represent or imply that it endorses the material there available, or that it believes such material to be accurate, useful or nonharmful. You are responsible for taking precautions as necessary to protect yourself and your computer systems from viruses, worms, Trojan horses and other harmful or destructive content.
- The Document Foundation's websites may contain content that is offensive, indecent or otherwise objectionable, as well as content containing technical inaccuracies, typographical mistakes and other errors.
- The Document Foundation's websites may also contain material that violates the privacy or publicity rights, or infringes the proprietary rights, of third parties, or the downloading, copying or use of which is subject to additional terms and conditions, stated or unstated. The Document Foundation disclaims any responsibility for any harm resulting from the use by The Document Foundation's visitors of The Document Foundation's websites, or from any downloading by those visitors of content available on or by means of The Document Foundation's websites.
Changes
Content contained on The Document Foundation's websites, including these Legal Disclaimers and Limitations, may be changed at the sole discretion of The Document Foundation and without notice. You are bound by any such updates or changes, and so should periodically review these Legal Disclaimers and Limitations.
If you believe any file is present on the site contrary to any TDF rule or applicable law, please supply full details to info@documentfoundation.org for impartial consideration.
Extension version is 1.0.1 and LibreOffice version is 3.3.2
Thanks!