18 Jan 2014

Calendar 2014 v4 USA


#5  Calendar 2014 v4 USA - Weekday 1 = Sunday

I made a new version (v4) of my Excel Calendar, which is almost the same as v3, except it has Sunday as the first day of the week in the calendar, see fig.1 (in stead of Monday as we have in Europe). This after having read  on:

http://www.timeanddate.com/calendar/days/

According to the international standard ISO 8601, Monday shall be the first day of the week ending with Sunday as the seventh day of the week. Although this is the international standard, countries such as the United States still have their calendars refer to Sunday as the start of the seven-day week.

On my small 'calendar-study' on internet, I found this sites which might interest you:

http://www.webexhibits.org/calendars/calendar-other.html

http://en.wikipedia.org/wiki/Workweek_and_weekend

where I saw this interesting fact:

For most Israelis, the workweek begins on Sunday and ends on Thursday or Friday midday to accommodate Jewish Sabbath, which begins Friday night. The standard workweek is 43 hours per week ..

I´m glad to live in Spain-Madrid (14 holidays) and having a workweek of 40 hours or 37 hours (in Jul., Aug., with the summer-heat)..

Note 2 (21-1-2014):
I just read that in Spain, people work on average 300 hours more then in Germany and Holland, see:
http://www.20minutos.es/noticia/2035333/0/espana/austria-alemania/horas-trabajadas-ano/
http://issuu.com/20minutos/docs/madr_22_01_14/7?e=4402717/6432229

Note (19-1-2014):
Today I read on:
http://www-01.ibm.com/software/globalization/guidelines/c11.html


that it seems that there are countries which have as the first weekday on the calender not Mon.or Sun., but e.g. Sat. (Saudi Arabia). But I hope that with the 2 calenders (with Mon. and Sun. as 1st weekday) I published in this blog, I covered the majority of the readers of my blog. But if you want a calender with a different 1st weekday, you can make it yourself using my Excel and doing some copy and pasting for the weekday-columns (circular shift).

As you can see in this small example of an Excel-calendar, creating a software-product which can be used world-wide is far from trivial (e.g. for a calendar, apart from translating the names of weekdays and months, you have to take the differences of the 1st weekday into account). For more information about 'software localization', as Microsoft names it, see:

http://msdn.microsoft.com/en-us/library/5839we2z(v=vs.110).aspx



fig.1


Download-mirrors:

* Mirror #1:

https://skydrive.live.com/redir?resid=3F963E9F1A42D952!149&authkey=!AL0dj3M1mTfvxo0&ithint=file%2c.xlsx

* Mirror #2:
https://drive.google.com/file/d/0BywxxSJoaUYxcUJ0MFhYbDIzY00/edit?usp=sharing

* Mirror #3:
http://es.scribd.com/doc/200594061/Calendar-2014-v4-USA-in-Excel

http://es.scribd.com/doc/200591920/Calendar-2014-v4-USA-in-PDF



No comments: