Easter dating spreadsheet for Excel/OpenOffice

  • Context: High School 
  • Thread starter Thread starter moonman239
  • Start date Start date
Click For Summary
SUMMARY

The forum discussion centers around a spreadsheet developed in OpenOffice.org that calculates the date of Easter for both the Julian and Gregorian calendars using Jean Meeus's algorithm. This tool is designed for years ranging from 1900 to 2099. The spreadsheet is user-friendly, requiring no additional instructions for operation. It is provided in a ZIP format due to attachment limitations on the forum.

PREREQUISITES
  • Familiarity with OpenOffice.org software
  • Understanding of the Julian and Gregorian calendar systems
  • Knowledge of Jean Meeus's algorithm for calculating Easter dates
  • Basic skills in handling ZIP file formats
NEXT STEPS
  • Research how to implement Jean Meeus's algorithm in other spreadsheet software
  • Explore the differences between Julian and Gregorian calendars
  • Learn about date calculations in Excel
  • Investigate the use of macros in OpenOffice for enhanced functionality
USEFUL FOR

This discussion is beneficial for developers, mathematicians, and anyone interested in calendar calculations, particularly those using OpenOffice.org for spreadsheet tasks.

moonman239
Messages
276
Reaction score
0
Here's a spreadsheet I developed in OpenOffice.org that takes a year and calculates the date of Easter on the Julian and Gregorian calendars. It uses Jean Meeus's algorithm, and works for years 1900-2099.

The spreadsheet is easy to use, I don't even need to tell you how to use it.

Note: I built this in OpenOffice, so I can't guarantee that it will work.
 

Attachments

Last edited:
Astronomy news on Phys.org
Here's the OpenOffice.org version. It's ZIPped because the .ods file extension is not currently supported by the attachment tool.
 

Attachments

Similar threads

  • · Replies 16 ·
Replies
16
Views
7K
  • · Replies 41 ·
2
Replies
41
Views
6K
  • · Replies 31 ·
2
Replies
31
Views
4K
  • · Replies 28 ·
Replies
28
Views
9K
  • · Replies 1 ·
Replies
1
Views
3K
  • · Replies 2 ·
Replies
2
Views
2K
  • · Replies 15 ·
Replies
15
Views
5K
  • · Replies 1 ·
Replies
1
Views
3K
  • · Replies 25 ·
Replies
25
Views
5K
  • · Replies 6 ·
Replies
6
Views
2K