HB OLE - Generate GregoriaCalendar with the Movable Holidays

HMG Samples and Enhancements

Moderator: Rathinagiri

Post Reply
User avatar
dhaine_adp
Posts: 457
Joined: Wed Aug 06, 2008 12:22 pm
Location: Manila, Philippines

HB OLE - Generate GregoriaCalendar with the Movable Holidays

Post by dhaine_adp »

For more details, please see the source code comments.

function Main() in EasterCalc.Prg has been renamed to Main1()
You can also localized it to suit your location.
Attachments
GregorianCalendar.zip
Generating Calendar from 1582 to any year
(35.15 KiB) Downloaded 905 times
Regards,

Danny
Manila, Philippines
User avatar
Rathinagiri
Posts: 5471
Joined: Tue Jul 29, 2008 6:30 pm
DBs Used: MariaDB, SQLite, SQLCipher and MySQL
Location: Sivakasi, India
Contact:

Re: HB OLE - Generate GregoriaCalendar with the Movable Holidays

Post by Rathinagiri »

Nice effort. Thank you dhaine_adp.
East or West HMG is the Best.
South or North HMG is worth.
...the possibilities are endless.
User avatar
luisvasquezcl
Posts: 1258
Joined: Thu Jul 31, 2008 3:23 am
Location: Chile
Contact:

Re: HB OLE - Generate GregoriaCalendar with the Movable Holidays

Post by luisvasquezcl »

Very interesting.
Thanks for your input.
Regards
Luis Vasquez
User avatar
esgici
Posts: 4543
Joined: Wed Jul 30, 2008 9:17 pm
DBs Used: DBF
Location: iskenderun / Turkiye
Contact:

Re: HB OLE - Generate GregoriaCalendar with the Movable Holidays

Post by esgici »

dhaine_adp wrote:For more details, please see the source code comments.

function Main() in EasterCalc.Prg has been renamed to Main1()
You can also localized it to suit your location.
Hi Dany

Thanks, very nice :)

Your revision history very interesting and your code-commenting style is very satisfying.

Especially your HB OLE work, programatically building an Excell sheet is impressive.

I hope that this will be a good example and starting point for developing a generic and versatile .dbf to .xls conversion routine/module.

By the way, have you a plan for working on Lunar Calendar ?

Thanks and greetings.

Regards
--

esgici
Viva INTERNATIONAL HMG :D
User avatar
fchirico
Posts: 324
Joined: Sat Aug 23, 2008 11:27 pm
Location: Argentina

Re: HB OLE - Generate GregoriaCalendar with the Movable Holidays

Post by fchirico »

dhaine_adp wrote:For more details, please see the source code comments.

function Main() in EasterCalc.Prg has been renamed to Main1()
You can also localized it to suit your location.
simply, a genius !

Is very original.

Regards, Fernando Chirico.
Saludos, Fernando Chirico.
User avatar
jortega
Posts: 26
Joined: Thu Oct 09, 2008 3:52 am
Location: Chile

Re: HB OLE - Generate GregoriaCalendar with the Movable Holidays

Post by jortega »

Good job
Thank you dhaine_adp.
Regards.
:) Juan Ortega :)
User avatar
Roberto Lopez
HMG Founder
Posts: 4004
Joined: Wed Jul 30, 2008 6:43 pm

Re: HB OLE - Generate GregoriaCalendar with the Movable Holidays

Post by Roberto Lopez »

dhaine_adp wrote:For more details, please see the source code comments.

function Main() in EasterCalc.Prg has been renamed to Main1()
You can also localized it to suit your location.
Wow!

Amazing work!!!

Regards,

Roberto.
Regards/Saludos,

Roberto


(Veritas Filia Temporis)
User avatar
dhaine_adp
Posts: 457
Joined: Wed Aug 06, 2008 12:22 pm
Location: Manila, Philippines

Re: HB OLE - Generate GregoriaCalendar with the Movable Holidays

Post by dhaine_adp »

Dear all:

Thank you very much for your appreciation, really, it's very inspiring.

To Esgici:

There are many algorithm in calculating the lunar calendar, like for example the Kuwaiti Algorithm used by Microsoft to calculate Hegira dates. Lunar calendar used by Chinese, Vietnamese and by Jewish. Would you mind to clarify which lunar calendar are we talking about?

Take note that Islamic lunar calendar used in Saudi Arabia is used mainly as civil calendar meaning they are not using it for religious purposes. To determine the begining of Ramadan, they rely on visible sightning of the crescent moon. At midnight if they sighted the moon anyone will call/or inform the nearest Mosque regarding the sigthing of the crescent moon. That would marked the beginning of Ramadan. So on the civil calendar the Begining of Ramadan is just a tentative which moved accordingly to the sighting of the moon. So as you can see they spend a week or more to watch the sky for seeing the moon.

On the otherhand, calculating the phases of the moon(full moon, new moon, waxing gibous, waxing crescent, waning gibous, waning crescent) uses a different set of algorithm much like the algorithm of calculating the sunrise and sunset. However in triangulating/calculating the position is little more complicated because of fast movement of the moon that revolves around the earth as compared with earth revolves around the sun.

Thanks,

Danny
Regards,

Danny
Manila, Philippines
User avatar
esgici
Posts: 4543
Joined: Wed Jul 30, 2008 9:17 pm
DBs Used: DBF
Location: iskenderun / Turkiye
Contact:

Re: HB OLE - Generate GregoriaCalendar with the Movable Holidays

Post by esgici »

dhaine_adp wrote:
To Esgici:
...
Would you mind to clarify which lunar calendar are we talking about?
...
Danny
Hi Danny

I am talking about a calendar allowing converting dates from "Hegira" to "Gregorian" and viceversa.

No matter this or that people take Lunar Calendar this or that way, moon is a physical object and depends
absolute rules. So all of its motions are calculate-able.

For example in my country beginning of Ramadan and other Islamic days always calculated by scientific methods.

BTW, we are using Lunar Calendar for religious and historical purposes only.

Thanks for your interest.

Regards.

--

esgici
Viva INTERNATIONAL HMG :D
User avatar
dhaine_adp
Posts: 457
Joined: Wed Aug 06, 2008 12:22 pm
Location: Manila, Philippines

Re: HB OLE - Generate GregoriaCalendar with the Movable Holidays

Post by dhaine_adp »

I am talking about a calendar allowing converting dates from "Hegira" to "Gregorian" and viceversa.

Hi Esgici

Oh, Ok I got your point. Give me a little time regarding this. I'll post the code here so that we can test the conversion.


Thanks,

Danny
Regards,

Danny
Manila, Philippines
Post Reply