Re: [libreoffice-users] Formula returns incorrect result
At 22:41 08/06/2019 -0400, Carl "Peter" Winerich wrote: I'm trying to calculate the Equation of Time (EoT) to determine the difference between LAN (Local Apparent Noon) and GMT/UT-1 Greenwich Mean Time. Then I want to plot the EoT curve (a project for later, not now) The following is the formula I use on my calculator. The formula gives a "close enough" EoT 9.87xsin(2x360(3-81)÷365)-7.67 x sin(360(3-81)÷365+78.7) =-4.584625249 (or -4 minutes 35.1 seconds...plus or minus) Calc doesn't give the same answer. It does if you translate the formula correctly. Here's the formula in calc; =9.87*SIN(RADIANS(2*360*(3-81)/365)-7.67*SIN(RADIANS(360*(3-81)/365+78.7))) The answer it returns is: -2.1488359093 Can you tell me what the correct layout of the format in calc is? You have failed to close one set of parentheses - at the end of the first SIN() expression (perhaps you forgot to close the first RADIANS() expression, in fact) - but then added a spare closing parenthesis at the end of your expression. The effect is that the first SIN() expression includes all of the second part of your formula. Try: =9.87*SIN(RADIANS(2*360*(3-81)/365))-7.67*SIN(RADIANS(360*(3-81)/365+78.7)) instead. I trust this helps. Brian Barker -- To unsubscribe e-mail to: users+unsubscr...@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
[libreoffice-users] Message body messed up appearance
How in the world do I fix the message body appearance so it doesn't return the message disorganized and jumbled together? Thanks, Carl -- To unsubscribe e-mail to: users+unsubscr...@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
[libreoffice-users] Fwd: Formula returns incorrect result
No idea how this gibberish got returned I'm trying to calculate the Equation of Time (EoT) to determine the difference between LAN (Local Apparent Noon) and GMT/UT-1 Greenwich Mean Time. Then I want to plot the EoT curve (a project for later, not now)The following is the formula I use on my calculator. The formula gives a "close enough" EoT9.87xsin(2x360(3-81)÷365)-7.67 x sin(360(3-81)÷365+78.7)= -4.584625249 (or -4 minutes 35.1 seconds...plus or minus)Calc doesn't give the same answer. Here's the formula in calc;=9.87*SIN(RADIANS(2*360*(3-81)/365)-7.67*SIN(RADIANS(360*(3-81)/365+78.7)))The answer it returns is: -2.1488359093Can you tell me what the correct layout of the format in calc is?Thank you,Peter -- To unsubscribe e-mail to: users+unsubscr...@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
[libreoffice-users] Formula returns incorrect result
I'm trying to calculate the Equation of Time (EoT) to determine the difference between LAN (Local Apparent Noon) and GMT/UT-1 Greenwich Mean Time. Then I want to plot the EoT curve (a project for later, not now)The following is the formula I use on my calculator. The formula gives a "close enough" EoT9.87xsin(2x360(3-81)÷365)-7.67 x sin(360(3-81)÷365+78.7)= -4.584625249 (or -4 minutes 35.1 seconds...plus or minus)Calc doesn't give the same answer. Here's the formula in calc;=9.87*SIN(RADIANS(2*360*(3-81)/365)-7.67*SIN(RADIANS(360*(3-81)/365+78.7)))The answer it returns is: -2.1488359093Can you tell me what the correct layout of the format in calc is?Thank you,Peter -- To unsubscribe e-mail to: users+unsubscr...@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
[libreoffice-users] Vertical text in Writer on updated Linux Mint (19.1)
After upgrading to LO 6.2.4,2 on Linux Mint 19.1, I found to my surprise that I was neither able to attach the Vertical text icon to the Writer Toolbar, nor implement the function. I don't encounter this problem running LO 6.2.4.2 on my Windows 10 (v 1903) machines. Any suggestions ?... Henri -- To unsubscribe e-mail to: users+unsubscr...@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
