OASIS Mailing List ArchivesView the OASIS mailing list archive below
or browse/search using MarkMail.


Help: OASIS Mailing Lists Help | MarkMail Help

office message

[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]

Subject: [OASIS Issue Tracker] Commented: (OFFICE-3492) Undefined units forConvert Function

    [ http://tools.oasis-open.org/issues/browse/OFFICE-3492?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=22943#action_22943 ] 

David Wheeler  commented on OFFICE-3492:

Hmm, this is after the deadline, but can we remove the word "exact" on Imperial gallon?

I completely agree with Andreas Guelzow's desire to
"confirm that 'The Weights and Measures Act of 1985 switched to a gallon of exactly 4.54609 l.' is a correct statement."
Unfortunately, was not able to get airtight proof that this is correct.
When I wrote my proposal yesterday, I had a
preponderance of evidence shows that it's true, as shown below.
But since that time, I've found several sources that have:
  1 Imperial gallon = 4.54609188 liters
instead of:
  1 Imperial gallon = 4.54609 liters
If we remove the word "exact" we're fine, and we might be wrong otherwise.

We have that value from Wikipedia, of course.  Indeed, the Wikipedia entries
show a number of previous gallon definitions, which would explain why some older
sources have other values.  Other sources agree with this Wikipedia value, and
in general seem to confirm it.

This site:
which *exists* to do metric conversions reports that:
1 gal(UK) = 4.54609 L

This also agrees:

Answers.com agrees:
though that often quotes Wikipedia, so it's not a strong source.

NIST "Appendix C"
reports that 1 gallon (gal) (British Imperial)] is 4.546 liters,
but it does NOT say that this is exact (as it does many other places).
So the NIST value is *consistent* with the value given above, 4.54609.

HOWEVER, we also have some counter-evidence.

One piece of potential counter-evidence is that Google, when asked for
"Imperial gallon", reports that:
  1 Imperial gallon = 4.54609188 liters
This starts with the same value, but then adds ...188.
If this is true, we could remove the word 'exact'.

A search on "4.54609188" found many other sources that claimed that
  1 Imperial gallon = 4.54609188 liters
such as: http://www.aqua-calc.com/what-is/volume/Imperial-gallon

This is nuts.  You'd think you could go to 1 authoritative source and get a clear answer.
So, I propose that we just remove the term "exact", and leave it at that.

> Undefined units for Convert Function
> ------------------------------------
>                 Key: OFFICE-3492
>                 URL: http://tools.oasis-open.org/issues/browse/OFFICE-3492
>             Project: OASIS Open Document Format for Office Applications (OpenDocument) TC
>          Issue Type: Bug
>          Components: OpenFormula
>    Affects Versions: ODF 1.2 CD 05
>            Reporter: Eric Patterson
>            Assignee: David Wheeler 
>            Priority: Critical
>             Fix For: ODF 1.2 CD 06
> There are still a number of units that are undefined and cannot be implemented as described.  These should all be defined with numbers.
> "ly" *	Light-year, the distance light travels, in a vacuum, in a Julian year of 365.25 days
> "parsec" or "pc" *	Distance from sun to a point having heliocentric parallax of one second (used for stellar distance)*
> "PS"	Pferdestärke (German "horse strength", close but not identical to "HP")
> "bushel"	U.S. bushel (not Imperial bushel), interpreted as volume
> "uk_gal"	U.K. / Imperial gallon
> "uk_qt"	U.K. / Imperial quart
> Also, for "pond", there is a need to specify what to use for acceleration due to gravity
> "pond" *	Pond, gravitational force on a mass of one gram

This message is automatically generated by JIRA.
If you think it was sent incorrectly contact one of the administrators: http://tools.oasis-open.org/issues/secure/Administrators.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira

[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]