Welcome Guest 

Register

Forum Home » Languages » Quenya Discussion » Lesson 24 Calendar in Excel
Author Topic:
erutan2099
Council Member
Posts: 100
Send Message
Post Lesson 24 Calendar in Excel
on: December 28, 2015 05:08
Hello everybody!

As a fun project and something that could be useful in the future, I used the information given in lesson 24 to create a functional Gregorian to Elvish Calendar converter in excel.

It is placed here:

https://drive.google.com/file/d/0BxtQt4p8XIbva3VUcnJUNVI2SFE/view?usp=docslist_api

It will take the current month and day and give you the date in the elvish calendar, and it will account for day differences in leap years.

That being said I do have a question:

While I was able to accurately synchronize the day and month, I couldn't figure out how to synchronize the years. When does the elvish calendar begin compared to the Gregorian?

Update:
Turns out pre-1900 years might break the display in the excel version...but it SHOULDN'T cause any issues with the actual result of the elvish date.

Update:
Wrote an actual program version using Visual Basic. It SHOULD work on any windows system; essentially it is the same thing as the excel file above. It will grab the system date and display the appropriate Elvish month and day. The manual override isn't functional in this program yet, but future versions will have it.
It is located here, free to download: https://drive.google.com/file/d/0BxtQt4p8XIbvVHlydXh3aVBCdWM/view?usp=sharing
Enjoy!

[Edited on 12/30/2015 by erutan2099]

[Edited on 02/03/2016 by erutan2099]
-Erunámo -"Istyallo, Ilu."
dirk_math
Quenya Workbook Mentor
Posts: 622
Send Message
Avatar
Post
on: December 28, 2015 08:53
On this site you find all the details: http://www.elvish.org/gwaith/calendars.htm

Yassë engë lómë, anarties calali.
erutan2099
Council Member
Posts: 100
Send Message
Post
on: December 28, 2015 11:11
Thanks Dirk!
-Erunámo -"Istyallo, Ilu."
Members Online
Print Friendly, PDF & Email