Traducir el blog

Strategy to project the calendar

Posted on mayo 11, 2010 by Excel Pedro Wave

The first thing to do in any project is to plan the strategy to be followed and the construction of a Perpetual Calendar in Excel is no exception.

Before you start chopping code, the important thing is to understand the user needs to highlight the objectives of the project. Which is not going to plan here is the time of development or project implementation, as users are anonymous, and they will look for the results of this project in this blog when it's finished and not before. This is true in the era of Internet and its search engines, the premise is that it seeks what now exists, at this time and not something that is coming in the near or distant future.

If I hadn't proposed this project, nobody would have missed and who would have looked something like this would have satisfied for what was now finding, so the first thing I did was look for other existing calendar projects, and that an important part strategy is the current and potential market analysis.

The calendars are present in any computer application, but we will focus on serving to calculate the months of any year or multi-year.

Since immemorial time humans have created and used many types of calendars to remember and to plan their daily activities: solar, lunar, lunisolar, aztec, maya, egyptian, islamic, hebrew, chinese, buddhist, holidays, academic, anniversaries, product or space rocket launch, etc.

You can use some alternative calendars en Excel as the Hijri (lunar Islamic countries) or the Buddhist, although mainly used in the world today is the Gregorian calendar, with the peculiarity that is longer than the Tropic of Cancer, with a lag of about three days every 10,000 years. In this calendar, week is 7 days and one day is 24 hours x 60 minutes x 60 seconds = 86,400 seconds. Common years are of 365 days, the leap years of 366 days and the secular years multiples of 100 are leap years if they are multiples of 400, so that the average Gregorian year is 365.2425 days. One cycle of the Gregorian calendar of 400 years has exactly 20,871 weeks.

The ISO 8601 standard for representation of dates and times standard is based on the Gregorian calendar.

Monday is the first day of the week, except for Christian and Jewish religions and the United States that is Sunday.

Where do we find Gregorian calendars? Anywhere. Hanging on the wall, at our desk, in the newspapers, teletext on TV, calculators, computers, cell phones, etc., not to mention digital watches.

We will focus on the calendars we find in other applications, such as calendars, planners and organizers, advertising and similar to Outlook calendar, which serve to create appointments, events, meetings, parties know the local, national and global week labor, etc., but more often are out of our computer, uploaded to the cloud... We will focus on the calendars you find in other applications, such as calendars, planners and organizers, advertising and similar to the Outlook calendar, which serve to create appointments, events, meetings, parties know the local, national and global work week, etc., but more often are out of our computer, uploaded to the cloud...

I do not mean ash clouds that make the European aircrafts can stay on land, for no one knows how many days a year, but the cloud of data servers that support all types of applications, including:

Microsoft Windows Live Calendar: Free to create calendars and share them with friends or post online.

Google Calendar: A free online calendar that can be shared "at one place" in its propaganda, but I fear that is spread by multiple servers.

I left here an example with the posting dates in this blog that can be embedded on any web page like this:

On the Web there are many other calendars you can view and customize like this:
The www.timeanddate.com Calendar Generator
Enter year:

The next article will be a preview of how to make a perpetual calendar in Excel, and why not, in the clouds or is that not part of the water cycle?
Traducción al español aquí.

No Response to "Strategy to project the calendar"

Leave A Reply

Dime si te gusta lo que lees y, si no te gusta, dime por qué. Tengo habilitada la moderación de comentarios. Tu comentario se publicará pronto.

Mi lista de blogs