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: [email protected]
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
