Hi All,I have a 32 column spreadsheet which I need to be able to 'manually' calculate the last known Trendline y value.
I am aware of inserting Trendlines via the Calc app, but finding the FINAL y value requires multiple graph scale changes to determine the Y intercept, which is not conducive to time saving.
I have also done multiple searches on my friend Google and despite finding out that the equation for a Trendline is y=mx+b, from where to get the figures seems to be a well kept secret.
Below is a subset of my data and the Linear Trendline I would like to calculate, and have change when I expand it across the other data columns. The Trendline required is for data in column C2,f2,i2 ie Month-end Rainfall.
COLUMNS: A1: Month(Jan->Mar) B1: 2016 Monthly Rainfall to last Rain date C1: 2016 Month-end Rainfall D1: 2016 Annual Running Total E1: 2017 Monthly Rainfall to last Rain date F1: 2017 Month-end Rainfall G1: 2017 Annual Running Total H1: 2018 Monthly Rainfall to last Rain date I1: 2018 Month-end Rainfall A1 B1 C1 D1 E1 F1 G1 H1 I1 Jan 1.0 1.0 1.0 0.0 30.0 30.0 4.5 4.5 Feb 0.0 0.0 1.0 0.0 1.0 31.0 0.0 14.0 Mar 0.0 53.0 54.0 0.0 7.0 38.0 0.0 20.3 Any help appreciated Hylton -- To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy