HB OLE - Generate GregoriaCalendar with the Movable Holidays
Moderator: Rathinagiri
- dhaine_adp
- Posts: 457
- Joined: Wed Aug 06, 2008 12:22 pm
- Location: Manila, Philippines
HB OLE - Generate GregoriaCalendar with the Movable Holidays
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.
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 960 times
Regards,
Danny
Manila, Philippines
Danny
Manila, Philippines
- 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
Nice effort. Thank you dhaine_adp.
East or West HMG is the Best.
South or North HMG is worth.
...the possibilities are endless.
South or North HMG is worth.
...the possibilities are endless.
- luisvasquezcl
- Posts: 1258
- Joined: Thu Jul 31, 2008 3:23 am
- Location: Chile
- Contact:
Re: HB OLE - Generate GregoriaCalendar with the Movable Holidays
Very interesting.
Thanks for your input.
Regards
Luis Vasquez
Thanks for your input.
Regards
Luis Vasquez
- 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
Hi Danydhaine_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.
Thanks, very nice
![Smile :)](./images/smilies/icon_e_smile.gif)
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 ![Very Happy :D](./images/smilies/icon_e_biggrin.gif)
![Very Happy :D](./images/smilies/icon_e_biggrin.gif)
Re: HB OLE - Generate GregoriaCalendar with the Movable Holidays
simply, a genius !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.
Is very original.
Regards, Fernando Chirico.
Saludos, Fernando Chirico.
Re: HB OLE - Generate GregoriaCalendar with the Movable Holidays
Good job
Thank you dhaine_adp.
Regards.
Juan Ortega ![Smile :)](./images/smilies/icon_e_smile.gif)
Thank you dhaine_adp.
Regards.
![Smile :)](./images/smilies/icon_e_smile.gif)
![Smile :)](./images/smilies/icon_e_smile.gif)
- Roberto Lopez
- HMG Founder
- Posts: 4004
- Joined: Wed Jul 30, 2008 6:43 pm
Re: HB OLE - Generate GregoriaCalendar with the Movable Holidays
Wow!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.
Amazing work!!!
Regards,
Roberto.
Regards/Saludos,
Roberto
(Veritas Filia Temporis)
Roberto
(Veritas Filia Temporis)
- dhaine_adp
- Posts: 457
- Joined: Wed Aug 06, 2008 12:22 pm
- Location: Manila, Philippines
Re: HB OLE - Generate GregoriaCalendar with the Movable Holidays
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
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
Danny
Manila, Philippines
- 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
Hi Dannydhaine_adp wrote:
To Esgici:
...
Would you mind to clarify which lunar calendar are we talking about?
...
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 ![Very Happy :D](./images/smilies/icon_e_biggrin.gif)
![Very Happy :D](./images/smilies/icon_e_biggrin.gif)
- dhaine_adp
- Posts: 457
- Joined: Wed Aug 06, 2008 12:22 pm
- Location: Manila, Philippines
Re: HB OLE - Generate GregoriaCalendar with the Movable Holidays
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
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
Danny
Manila, Philippines