Talk:Date of Easter: Difference between revisions
m →Software - old school solutions and methods are dominating: Typo in my preceding comment. |
|||
Line 193: | Line 193: | ||
<font face="Arial Narrow">=EASTERSUNDAY(A2)</font><br> |
<font face="Arial Narrow">=EASTERSUNDAY(A2)</font><br> |
||
:EASTERSUNDAY(year) works in <b>LibreOffice</b> as well as OpenOffice. [[User:Roches|Roches]] ([[User talk:Roches|talk]]) 14:55, 10 July 2016 (UTC) |
:EASTERSUNDAY(year) works in <b>LibreOffice</b> as well as OpenOffice. [[User:Roches|Roches]] ([[User talk:Roches|talk]]) 14:55, 10 July 2016 (UTC) |
||
<b>Visual Basic</b> and <b>VBA</b> |
<b>Visual Basic</b> and <b>VBA</b>(Gregorian)<ref>http://www.online-excel.de/fom/fo_read.php?f=2&h=1082&bzh=1129&ao=1#a123x</ref><br> |
||
Public Function EASTERSUNDAY(y As Integer) As Long ' for 1900-9999 as serial number<br><font face="Arial Narrow"> |
Public Function EASTERSUNDAY(y As Integer) As Long ' for 1900-9999 as serial number<br><font face="Arial Narrow"> |
||
Line 203: | Line 203: | ||
End Function |
End Function |
||
<b>MS Access</b> (Gregorian)<ref>http://www.online-excel.de/fom/fo_read.php?f=2&bzh=1085&h=1082</ref><br |
<b>MS Access</b> (Gregorian)<ref>http://www.online-excel.de/fom/fo_read.php?f=2&bzh=1085&h=1082</ref><br> |
||
a) for 1900-9999 as serial number (date)<br><font face="Arial Narrow"> |
a) for 1900-9999 as serial number (date)<br><font face="Arial Narrow"> |
||
=7*((CDate([year]&-5)+,967*(18,99*([year]Mod 19+732)+([year]\100)/1,4718\1-[year]\400)Mod 29)\7)-34)</font><br> |
=7*((CDate([year]&-5)+,967*(18,99*([year]Mod 19+732)+([year]\100)/1,4718\1-[year]\400)Mod 29)\7)-34)</font><br> |
Revision as of 13:47, 17 August 2016
Christianity Start‑class Low‑importance | ||||||||||
|
Time B‑class High‑importance | ||||||||||
|
This page has archives. Sections older than 60 days may be automatically archived by Lowercase sigmabot III. |
Drift in ecclesiastical full moon
Per WP:TPO, closing section created by IP sockpuppet of banned User:Vote (X) for Change |
---|
The following discussion has been closed. Please do not modify it. |
It would be more helpful to tweak the wording, rather than nuke the section entirely. The value of delta T over 2,000 years has reached about 3 1/2 hours. The shift in the time of full moon over the same period is much the same. So the one cancels the other out. 156.61.250.250 (talk) 10:44, 14 May 2015 (UTC)
Lichtenberg describes the replacement of solar equations (common centennial years) and lunar equations (drift of one tithi in 312 1/2 years) with a unified correction cycle which provides the same number of epact corrections over the cycle. — Preceding unsigned comment added by 156.61.250.250 (talk) 16:20, 22 May 2015 (UTC)
The problem is that most of the numbers and years listed in the blanked section are nowhere mentioned in Lichtenberg's (2003) paper. Nor is the Synod of Whitby anywhere referred to in the same paper. How can you claim that your text is a selective rephrasing of Lichtenberg's paper? I am seriously beginning to doubt whether you have ever read the Lichtenberg paper you are claiming to cite. AstroLynx (talk) 15:38, 23 May 2015 (UTC)
Later, when an editor referred to the book you quoted from it instantly, thus proving that you had had a copy of it all the time. You exhorted the editor to get a copy of the book:
That's not what good faith, collegial editing is all about. The incident related to an attempt by you to exclude the other editors' sources from a description of a picture of Muhammad. You have this picture on your web profile. You are arguably obsessed with it. 156.61.250.250 (talk) 10:55, 27 May 2015 (UTC) You are the person who wants to put his original research up, so you must provide the correct references. You cannot expect that other editors will do this for you. That fact that you seem to be unable to do this clearly proves that you actually never saw the Lichtenberg paper which you claim is your source. Your editing behaviour during the past few days on this page has thus clearly shown that you are a liar and a fraud.
It is interesting that you refer to the discussion on the Islamic calendar page with IP 87.81.147.76. For any editor it should be clear that this IP's editing behaviour is exactly the same as yours, which, for me at least, makes it abundantly clear that you the same person. Yet another London-based sockpuppet of Vote (X) for Change. AstroLynx (talk) 11:21, 27 May 2015 (UTC) Wow. Every editor in a university city of ten million with an interest in calendars is a sockpuppet. You say a stable version is original research. Proof? I see that 87.81.147.76 was supported by other editors, so I suppose that makes them liar(s) and (a) fraud(s) too. An editor (not talking of me) uses the word "disingenuous":
Speaking of you he says:
And again:
And again (of one of your supporters):
And again (of another of your supporters):
As the discussion unfolded it emerged that none of your supporters had read any of the books which their arguments relied on but you did not call them "liars and frauds". 156.61.250.250 (talk) 13:42, 27 May 2015 (UTC)
|
More or less as an aside, when I was learning computer programming
(Specifically COBOL -- this was in the antediluvian days when the IBM 370 was popular), I had to write a program to determine which day of the week a given date was. The way I did it was first to work out by hand that January 1st of the year 1 was a Saturday, count the number of days since then (and I dropped the 11 days in 1752 when Britain switched from the Julian calendar to the Gregorian calendar), do modulo 7 on the number, and there we were. My instructor thought it was an ingenious way of doing it. JHobson3 (talk) 19:25, 18 January 2016 (UTC)
Do we need an algorithm for a revised Easter Day computation?
In the past weeks two editors have been adding material criticizing existing Easter Day computations and promoting a revised Easter Day algorithm recently published by one of the editors in a rather dodgy journal. I do not believe that such material belongs here but before I start deleting all this material I would like to hear the opinions of other editors. AstroLynx (talk) 13:25, 10 February 2016 (UTC)
- Wikipedia cautions strongly against primary sources. Unless these methods have been peer-reviewed in reputable sources, they may be mentioned and linked to, but should not receive the extensive coverage they occupy now. -- Michael Bednarek (talk) 18:13, 10 February 2016 (UTC)
- My understanding from reading the material is that the author believes that their algorithm produces "better" Easter dates than the Gregorian algorithm. If so, then not only are their supposed criticisms invalid (the algorithms given calculate Gregorian Easter, which is correct - see also Stockton who has tested many algorithms, including ones based on the original source), but also the content should fall under WP:FRINGE and therefore be eliminated. Arcorann (talk) 11:43, 16 February 2016 (UTC)
- Or more likely WP:UNDUE. At any rate, I've removed the content. The person is free to make their case here if they disagree. Arcorann (talk) 12:33, 16 February 2016 (UTC)
- My understanding from reading the material is that the author believes that their algorithm produces "better" Easter dates than the Gregorian algorithm. If so, then not only are their supposed criticisms invalid (the algorithms given calculate Gregorian Easter, which is correct - see also Stockton who has tested many algorithms, including ones based on the original source), but also the content should fall under WP:FRINGE and therefore be eliminated. Arcorann (talk) 11:43, 16 February 2016 (UTC)
No Full Moon
I notice that over and over again editors pervert the Easter rule by introducing an (ecclesiastic) Full Moon. This is misinformation. Surely popular and astronomical secondary sources mention a Full Moon, but canonical literature from Dionysius to Clavius has always only been based on the 14th day of the lunar month, following from the definition of Jewish Passover. That this happens to be close to the day of Full Moon for a properly aligned lunar calendar (which the ecclestiastic reckoning is not), is circumstantial. Referring to the "Full Moon" has led only to misguided attempts to "improve" the computation of Easter.
I noticed only now that my latest attempt (7 Jan. 2015) to clarify things was quickly (26 Jan.) destroyed by an anonymous editor without further comment. I may try again in the near future to repair this when I have time, but can all those editors who feel the urge to "improve" this article please first read up on the relevant literature and not put in misguided misinformation?
Tom Peters (talk) 12:41, 22 February 2016 (UTC)
- The downside of an encyclopedia that everyone can edit is sometimes that everyone can edit it. That IP editor, 156.61.250.250, has been blocked soon after their edits here. If you think the current wording is wrong, the obvious recourse is to correct it – preferably with citation of reputable sources. -- Michael Bednarek (talk) 02:33, 23 February 2016 (UTC)
Excel formulas
The Excel formulas under the Software heading deliver different results. It should be stated that they have different scopes. The formulas
=ROUND(DATE(A1,4,1)/7+MOD(19*MOD(A1,19)-7,30)*14%,0)*7-6
and
=FLOOR((4&-A1)-DAY(5)+97%*MOD(18.998*MOD(A1+8/9,19)+INT(68%*INT(A1%)-INT(A1%/4)-5/9),30),7)+DAY(1)
differ in 5802 of the 8100 calculations for the years 1900-9999. The latter formula is the correct for those years while the former is probably only intended for the years 1900-2199 for which it is also correct. The difference is always a (positive or negative) multiple of 7 days, i.e. they both get the day of week right but not the week itself. Presumably it omits correcting for the period of the orbit of the moon. The first error occurs in the year 2204 which is why it might go unnoticed for a while. Other well-known formulas that contain errors include the formula
=FLOOR(A1&"-05-"&DAY(MINUTE(A303/38)/2+56);7)-34
from "Excel 2010 Tips & Tricks" by John Walkenbach and other sources which makes 5790 errors in the year range 1900-9999, the first one occurring already in the year 2079. Thus, it is not even intended for the period 1900-2199.
A final comment about the 9999 year formula is that it is not compatible with international date standards - FLOOR((4&-A1) must be replaced by FLOOR((A1&-4) for non-US date formats. — Preceding unsigned comment added by 31.15.60.198 (talk) 17:08, 22 March 2016 (UTC)
- The scope of the longer formula is not only the full range of years, it also works in Excel files with both file formats - the 1900 (Standard) and the 1904 file format.
- In 1998/99 there was a contest in Germany, to get the shortest Excel formula for 1900-2078 in the 1900 file format. Most formulas you can find in the www, are from this and do not care about 2079-9999 or the 1904 file format.
- 13:55, 27 April 2016 (UTC) — Preceding unsigned comment added by 85.199.76.137 (talk)
Software - old school solutions and methods are dominating
Most of software solutions are based on the equation sets of Gauss and his epigones.
These sets were made for mental arithmetic.
Modern software products are able to calculate the Easter Sunday date from the year in one step, short, and efficient.
- The "mental arithmetic" algorithms will long outlive what follows
- Yes, but the "mental arithmetic" will be of use indefinitely, long after the ephemeral modern languages and applications that follow come to dwell amongst the doornails; then, the "mental arithmetic" algorithms will be needed to create programs that execute in the future. Vincent J. Lipsio (talk) 01:19, 20 July 2016 (UTC)
Open Office - Calc (Gregorian, 1583-9957)
=EASTERSUNDAY(A2)
- EASTERSUNDAY(year) works in LibreOffice as well as OpenOffice. Roches (talk) 14:55, 10 July 2016 (UTC)
Visual Basic and VBA(Gregorian)[1]
Public Function EASTERSUNDAY(y As Integer) As Long ' for 1900-9999 as serial number
EASTERSUNDAY=7*((CDate(y &-5)+.967*(18.99*(y Mod 19+732)+(y\100)/1.472\1-y\400)Mod 29)\7)-34
End Function
Public Function EASTERSUNDAY(y As Integer) As String ' for 1500-9999 as string
EASTERSUNDAY=CDate(7*((CDate(y &-5)+6*(y<1900)+.967*(18.99*(y Mod 19+732)+(y\100)/1.472\1-y\400)Mod 29)\7)-34)
End Function
MS Access (Gregorian)[2]
a) for 1900-9999 as serial number (date)
=7*((CDate([year]&-5)+,967*(18,99*([year]Mod 19+732)+([year]\100)/1,4718\1-[year]\400)Mod 29)\7)-34)
b) for 1500-9999 as string
=CDate(7*((CDate([year]&-5)+6*([year]<1900)+,967*(18,99*([year]Mod 19+732)+([year]\100)/1,4718\1-[year]\400)Mod 29)\7)-34)
MS Excel (Gregorian)[3]
a) for standard 1900 file format (1900-9999)
=FLOOR((A2&-8)-MOD(30*INT(11*MOD(A2,19)-68%*INT(A2%)+INT(A2%/4)+44.55),29.032),7)-97
b) for 1900 and 1904 file formats (1904-9999)
=FLOOR((A2&-5)-MOD(30*INT(11*MOD(A2,19)-68%*INT(A2%)+INT(A2%/4)+44.55),29.032)-DAY(6),7)+DAY(1)
15.211.201.89 (talk) 21:46, 19 July 2016 (UTC)