5 simple questions on OOXML

Here are some 5 simple questions you should get an answer from your Standardisation Body, from ECMA, or from Microsoft:

According to the OOXML specification (ECMA 376),

  1. What day of the week corresponds to 1st January 1900?
  2. How many working days are there between Monday 4th June 2007 and Saturday 14th July 2007 in countries such as Algeria or Jordan?
  3. How many days did the Spanish War last, which started on 2nd May 1808 and ended on the 30th of October 1813?
  4. What is the average deviation of this dataset (5, 10)?
  5. How many days were in the month of February 1900?

Here are the answers you should get:

  1. The specification returns 1, meaning Sunday. In reality, the 1st January 1900 is a Monday.
  2. The NETWORKDAYS() function of the specification does not allows the week-end to be anything else then Saturday and Friday, thus it lacks cultural adaptability for countries such as Iraq, Algeria, Sudan, Qatar, Bangladesh, Israel, Jordan, Libya, Pakistan, Syria, United Arab Emirates, Kuwait where the week-end is not saturday and sunday. This contrary to the JTC1 Directives, 5th Edition, Version 3.0, Section 1.2.
  3. This is impossible to calculate, the specification does not support dates before 1900.
  4. The AVEDEV function of the specification returns 252, while correct average deviation is 2.5.
  5. Since 1900 is not a leap year, in the reality 28 days. Since the specification treats 1900 as a leap year, the specification gives 29 days for the month of february 1900.