Home > Standards Blog

Advanced Search 

Welcome to ConsortiumInfo.org
Thursday, September 02 2010 @ 07:44 AM PDT

Email Article To a Friend View Printable Version

OOXML Vote Tracker and Calculation Guide

OpenDocument and OOXML
Updated:  (8:45 AM EDT 4/1):  OOXML has  been adopted

Updated:  (1:45 OM EDT 3/31):
Reuters has just reported that ISO will not announce the results of the OOXML vote until Wednesday April 2

Updated (3:30 PM EDT 3/29): 
Unless thus-far unannounced votes that were formerly "approve" or "abstain" switch to "disapprove," it appears that OOXML will be approved.  See details in the cumulative "updates" section below


Like many I'm sure, I'm trying to keep track of the votes on OOXML as they become known.  I've set up a spreadsheet where I'm recording votes as they become known, whether they are formal and confirmed, or coming to light from other sources, and therefore to a greater or lesser extent possibly not accurate, what the sources are, and any associated comments (mostly from Pamela's articles at Groklaw, the most recent of which is being updated with new votes as news comes in to her).  You'll find the most information about specific country voting there, and at several of her prior blog posts, including this one, this one, this one, and this one.

For the benefit of those that want to get a quick look throughout the weekend, I'll post the running tally here of which votes have switched, what the net change has been, now many votes have come to light, and how many remain to be announced.  It is likely that it will not be possible to know the final vote until all votes are in, due to the complicated, double test way in which the vote is counted, which is complicated by the fact that the final number of abstentions, and whether they move from "yes" or "no" votes, can decrease the number of votes that need to switch to "yes" votes. For that reason, I also include an explanation of how the omplicated two-part test for approval will be calculated.

You may also want to read my last blog entry, which discusses the impact (or non-impact) of a vote to approve OOXML, called The Future of ODF and OOXML.
I.  Updates:

March 31

1.  France moves from disapprove to abstain
2.  Norway files protest with ISO relating to its own vote, asking that it be suspended pending an internal investigation (the suspended vote had previously changed from disapprove to approve)

March 30:

1.  Australia and Malaysia stay as abstain (Malaysia position reported at Open Malaysia)

March 29:
1. I
've now learned of several other sites that are tracking the results as well.  They can be found at Open Malyasia and Command Line Warriors
2.  Canada stays in the "disapprove" column (private email)
3.  The United Kingdom and Ireland have each now switched from "disapprove" to "approve"  (private email)
4.  New Zealand will maintain its "disapprove" vote; watch for a press release at www.standards.co.nz (private email)

March 30:

1.  Confirmation of the New Zealand position per anticipated press release
2.   France stays in the "disapprove" column (Open Malaysia, with this link)
3.  Further confirmation of South Africa: (Open Malyasia, with this link)



II.  Vote Tracker

Here is the current tally, as I have it.  Please let me know of any updates, new votes, inaccuracies, etc., and I'll post them promptly.

A.   Principal Countries

Gains:

No to Yes:    Czech Republic, Denmark, Korea, United Kingdom, Ireland

Abstain to Yes:  Finland,

No to Abstain: France

Losses:

Yes to No:  Venezuela

Yes to Abstain:  Kenya

Abstain to No: None so far

Limbo:  Norway - Norway had switched from "Disapprove" to "Approve," but has now filed a formal request with ISO asking that its vote be temporarily suspended, pending completion of an investigation

Reported with no change:  11

Chile, Germany, India, Poland, South Africa, USA, Canada, New Zealand

Net Change: 4 (5, counting Norway) [Five more yes votes needed, subject to what happens with abstains]

Abstain:  1 net change

Unconfirmed:  Trinidad and Tobago from Abstain to "approve" (see comment below from reader); Italy maintains abstention

B.  Observer Countries

Gains:

No to Yes: None so far

Abstain to Yes: None so far

No to Abstain: None so far

Losses:

Yes to No:  Cuba (see note below)

Yes to Abstain:  None so far

Abstain to No: None so far

Reported with no change:  10

Romania, Brazil

PJ reports that Cuba was originally recorded as an approval last summer; it has now voted to disapprove, and says that its original vote was to disapprove as well, and was inaccurately recorded
C.   Total Votes Count
Last summer:  87

Currently reported:  23

III.   How to Calculate the Final Vote

Step one: 
Count all P votes cast, and determine whether at least 50% of P members have voted 
If yes, then proceed to next step
 
If no, then the resolution fails
This step has already been satisfied under the vote last summer

Step two: Subtract all abstentions (in other words, throw them out)

This will stay in motion until we have the full, final vote
 
Step three: Determine whether 2/3's of the remaining P votes are to approve 
If No, then the resolution fails
 
If yes, then go to step four
If there is no change in abstentions, a net change five "disapprove" votes must change to "approve"

Step four: Determine whether 25% or more of the total ("yes" plus "no") votes cast by P Members, O Members, and other members of ISO/IEC JTC1 are "No" votes
If yes, then the resolution fails
 
If no, then the resolution passes
Note 1:  As you can see, Principal member votes are far more important than Observer Member votes, since the votes of P members count under both tests, while O members count only under the second.
 
Note 2:  Note also that an abstention is the next best thing to a vote to approve, since it avoids another vote in the no category, which can't exceed 25% of all votes cast.

Note 3: 
A total of 87 National Bodies registered votes of approve, disapprove, or abstain in the voting period that ended last September 2; of those, 41 were P Members, 29 were O members, and 17 neither.



For further blog entries on ODF and OOXML, click here

sign up for a free subscription to Standards Today today!

Trackback

Trackback URL for this entry: http://www.consortiuminfo.org/standardsblog/trackback.php?id=20080329071456170

Here's what others have to say about 'OOXML Vote Tracker and Calculation Guide':

The final countdown of OOXML from Wictor Wilen
Today is the last day that the national bodies can change/update the votes on the Office Open Xml, DIS 29500, approval as an ISO standard. I really hope that enough NB's change their votes so we can ... [read more]
Tracked on Saturday, March 29 2008 @ 10:07 AM PDT

Open XML appears to clear ISO standard vote — NYS Tech
Tracked on Sunday, March 30 2008 @ 11:22 AM PDT

Keeping Track of the OOXML Vote from XML Technologies & Content Strategies
Andy Updegrove is keeping a running tally over at Standards Blog. UPDATE: Updegrove is now reporting OOXML will pass the vote, and Slashdot has a roundup that includes reports of irregularities in the voting.... [read more]
Tracked on Sunday, March 30 2008 @ 06:18 PM PDT

PlasticBoy » Blog Archive » Links for March 30th
Tracked on Monday, March 31 2008 @ 06:05 AM PDT

Office Open XML diventerà (forse) ISO » Italia SW
Tracked on Monday, March 31 2008 @ 08:22 AM PDT

OOXML: Noruega reinventa la democracia at écrasez l’infâme
Tracked on Monday, March 31 2008 @ 10:04 AM PDT

OOXML y las numerosas irregularidades en su proceso de votación
Tracked on Monday, March 31 2008 @ 07:04 PM PDT

MoceaN Blog » Open XML will clear ISO standard vote
Tracked on Sunday, July 27 2008 @ 02:24 PM PDT

fsugitalia » Blog Archive » OOXML approvato come standard ISO
Tracked on Wednesday, January 14 2009 @ 10:10 AM PST

OOXML Vote Tracker and Calculation Guide | 46 comments | Create New Account
The following comments are owned by whomever posted them. This site is not responsible for what they say.
OOXML Vote Tracker and Calculation Guide
Authored by: Anonymous on Saturday, March 29 2008 @ 09:40 AM PDT
Denmark vote Yes (it was No)
http://www.ds.dk/4225
http://www.groklaw.net/article.php?story=20080328090328998

Norway vote Yes (it was No)
http://www.idg.no/computerworld/article92563.ece

Trinidad and Tobago vote Yes (it was Abstention)
http://ttcs.wordpress.com/2008/03/22/trinidad-and-tobago-bureau-of-standards-votes-approval-of-dis29500/

UK vote Yes (it was No)
http://www.channelregister.co.uk/2008/03/26/bsi_vote_yes_ooxml/

Brazil vote No
http://www.groklaw.net/article.php?story=2008032520072575

Belgium Abstention
http://www.datanews.be/fr/news/90-57-17395/la-belgique-s-abstient-a-propos-d-ooxml.html


Cuba vote No (ISO counted his September vote as Yes ... it was No)
http://www.groklaw.net/article.php?story=20080324121844682

Poland vote ??? (vote Abstention, but ...)
http://www.groklaw.net/article.php?story=20080322203811784

Netherlands Abstention
http://www2.nen.nl/nen/servlet/dispatcher.Dispatcher?id=253848&parentid=000009

Italy Abstention (no link) for sure

Not for sure (no link):
Canada probably vote No
Slovenia probably vote Yes (it was Abstention)
China probably vote No
Argentina probably Abstention
New Zealand probably vote No
Thailand probably vote No

  • Norway: Yes :( - Authored by: Anonymous on Sunday, March 30 2008 @ 01:03 PM PDT
wrong "Step four"
Authored by: Anonymous on Saturday, March 29 2008 @ 09:56 AM PDT
1) from: http://www.iso.org/iso/pressrelease.htm?refid=Ref1070
"and no more than 1/4 (i.e. 25 %) of the total number of national body votes cast negative"

so:

**
Step four: Determine whether more than 25% of the total votes cast by both P and O members are "No" votes
**

##################

2) from: http://www.iso.org/iso/pressrelease.htm?refid=Ref1070
"and 26 % of national votes cast being negative."

So:

September vote:
Yes: 51
Abstention: 18
No: 18

1800/(51+18+18) = 20.69%

1800/(51+18) = 26.09%

So:

**
Step four: Determine whether more than 25% of the total Yes and No votes cast by both P and O members are "No" votes
**
OOXML Vote Tracker and Calculation Guide
Authored by: Anonymous on Saturday, March 29 2008 @ 10:47 AM PDT
Kenya seems to be listed both in Gaines and Losses.
OOXML Vote Tracker and Calculation Guide
Authored by: Anonymous on Saturday, March 29 2008 @ 10:57 AM PDT
Why is Kenya listed twice?

It is good we now have people counting in USA, UK and Asia counting.

I am trying to keep up and I provide Python scripts for that also.

Open Malaysia is very fast.

Not live but nice.
OOXML Vote Tracker and Calculation Guide
Authored by: Anonymous on Saturday, March 29 2008 @ 11:23 AM PDT
Please, link in the article those who have already made great efforts in trying to gather all the information. I'm thinking, in particular of  OpenMalaysia (http://www.openmalaysiablog.com/2008/03/the-last-lap.html"), but there may be others.

/Mikael
OOXML Vote Tracker and Calculation Guide
Authored by: Anonymous on Saturday, March 29 2008 @ 12:02 PM PDT
Andy,<br />
<br />
OpenMalaysia has a nice table updated quite often.&nbsp; I think they have the most complete and up-to-date data currently available.<br />
http://www.openmalaysiablog.com/2008/03/the-last-lap.html<br />
<br />
Please note also that the second criteria is based on all the votes, i.e. the Yes and No (Abstain is not taken into account) by the 87 ISO/IEC &quot;members bodies&quot; that voted in Sep-07 (41&nbsp; JTC1 P-members, 29 JTC1 O-members and 17 ISO/IEC members bodies that are neither P- nor O-members of JTC1)<br />
<br />
Luc Bollen
OOXML Vote Tracker and Calculation Guide
Authored by: Anonymous on Saturday, March 29 2008 @ 03:09 PM PDT
The ISO is becoming meaningless!
For the No Countries
Authored by: Anonymous on Saturday, March 29 2008 @ 03:38 PM PDT
If indeed MS bribes, extorts and cheats it's way to becoming a "standard", the solution is simple.  Here's the mandate for government documents.

"We mandate that all documents must be saved in an ISO standard format.  The standard format must be VERIFYABLY certified at >95% complete by two or more independent software vendors".

There you go, since nobody is compliant, only partially compliant at best, MS wins the battle but loses the
war.  They can't buy or bribe or bully or bafflespeak their way past the second line.  Where and who certified that the application you want us to pay through the nose for is >95% compliant to the ISO "standard". 

For the yes countries, well, enjoy.  In the long run though, we can hope that if it passes, ISO is thoroughly re-organized, OOXML is suspended as a standard, and MS pays the price as the nuts and bolts of how they made this happen see the light of day.

TripleII
OOXML Vote Tracker and Calculation Guide
Authored by: Anonymous on Saturday, March 29 2008 @ 04:25 PM PDT
"Trinidad and Tobago from Yes to Abstain"

Andy, T&T voted Abstain in Sept.
  • Kristen Morgan - Authored by: Anonymous on Wednesday, September 17 2008 @ 11:52 PM PDT
  • Shannon Irwin - Authored by: Anonymous on Friday, September 19 2008 @ 03:08 PM PDT
  • Norberto Burton - Authored by: Anonymous on Saturday, September 20 2008 @ 01:51 PM PDT
  • Landon Daniels - Authored by: Anonymous on Monday, September 22 2008 @ 12:39 AM PDT
  • Marla Hughes - Authored by: Anonymous on Monday, September 22 2008 @ 05:51 PM PDT
  • Rodrigo Vance - Authored by: Anonymous on Wednesday, September 24 2008 @ 10:05 AM PDT
  • Alesia David - Authored by: Anonymous on Friday, September 26 2008 @ 12:45 AM PDT
  • Darcy Mueller - Authored by: Anonymous on Monday, September 29 2008 @ 04:44 PM PDT
  • Daniel Adkins - Authored by: Anonymous on Thursday, October 02 2008 @ 06:59 PM PDT
  • Kari Townsend - Authored by: Anonymous on Sunday, October 05 2008 @ 01:43 PM PDT
  • Rodger Salas - Authored by: Anonymous on Saturday, October 11 2008 @ 09:07 PM PDT
OOXML Vote Tracker and Calculation Guide
Authored by: Anonymous on Saturday, March 29 2008 @ 04:27 PM PDT
Sad Day !!!
OOXML Vote Tracker and Calculation Guide
Authored by: Anonymous on Saturday, March 29 2008 @ 10:25 PM PDT
Ummm,

Doing the math on the last vote. ISO state failed both criteria.  Only way that would work is if abstain votes don't count.

That means Doing the math this time. 14/55 =25.454545 = >25% No

Thats Fail, unless I am mistaken.

The operative words seem to be Votes Cast. Abstain means no vote cast.

Victory!
MrCopilot
Hypotheticals
Authored by: Anonymous on Sunday, March 30 2008 @ 02:43 AM PDT
Andy,

it seems likely that there will be at least one serious challenge against the registered vote of a National Body.

Let us pretend that  the vote in favour of approval was determined by the margin between a single P member moving from Abstain to Yes.

What rules and procedures are there to forestall the decision by ISO until such time as any legal challenges to a NB's vote have been resolved?

 
OOXML Vote Tracker and Calculation Guide
Authored by: Anonymous on Sunday, March 30 2008 @ 07:31 AM PDT
Trinidad and Tobago vote
http://ttcs.wordpress.com/2008/03/22/trinidad-and-tobago-bureau-of-standards-votes-approval-of-dis29500/
The question NBs can't reply
Authored by: Anonymous on Monday, March 31 2008 @ 11:03 AM PDT
I participated in OOXML process in 3 countries and closely followed all global discussions.

I can ensure the big majority of NBs simply didn't follow the voting rules so I am leaving this question that I want to see an answer.