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

# office message

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

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

• From: OASIS Issues Tracker <workgroup_mailer@lists.oasis-open.org>
• To: office@lists.oasis-open.org
• Date: Wed, 27 Oct 2010 15:57:15 -0400 (EDT)

```
[ http://tools.oasis-open.org/issues/browse/OFFICE-3492?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Eike Rathke updated OFFICE-3492:
--------------------------------

Proposal:
Conversion factors according to
http://www.metas.ch/metasweb/Themen/Masseinheiten/calculation/en_calculation_frame_umrechnungen.html

"ly": The exact value of one light year is
(299792458 m/s) (3600 s/hr) (24 hr/day) (365.25 day/year)
1 ly = 9.4607304725808E+15 m
1 m  = 1.05700083402462E-16 ly

"pc": 1 pc = 3.085677581E+16 m
1 m  = 3.24077928996043E-17 pc

"HP": 1 HP = 745.699871582 W
1 W  = 0.00134102208959551 HP

"PS": 1 PS = 735.49875 W
1 W  = 0.0013596216173039 PS
(METAS lists this as CV instead of PS)

Conversion factors according to OOo implementation:

"uk_gal": 1 L = 0.219969461940207 uk_gal

"uk_qt":  1 L = 0.87987784776083 uk_qt  (1 uk_qt = 1/4 uk_gal)

"uk_pt":  1 L = 1.75975569552166 uk_pt  (1 uk_pt = 1/8 uk_gal)

"pond":   1 N = 101.9716 pond

Conversion factor according to David's comment:

"bushel": 1 L = 0.0283775933 bushel

was:Numbers should be added for these, or they should be removed.

For "bushel" I observed:

Conversion factors according to
http://www.unitconversion.org/volume-dry/bushels-us-to-liters-conversion.html

1 bushel = 35.23907017 L
1 L      = 0.028377593 bushel

Conversion factors according to
http://www.onlineconversion.com/volume.htm

1 bushel = 35.2390704 L
1 L      = 0.028377593071 bushel

Conversion factor according to OOo implementation

1 L      = 0.02837759 bushel

Excel and Gnumeric apparently don't have a conversion from liter to bushel.

For both, unitconversion.org and onlineconversion.com factors, taking the reciprocal value does not result in the corresponding value given.

Per David's comment, 1 bushel = 2150.42 cubic inch, using =1/CONVERT(2150.42;"in3";"l") gives 0.0283775933, I used that in the proposal.

For "pond" and acceleration due to gravity, in the editor revision we say in the Rationale under Force/Weight that "The standard acceleration of gravity in free fall is 9.80665 m/s2." Do we really need to specify common school knowledge? I don't think so, else we would also have to say that for Newton..

> 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: Needs Discussion, OpenFormula
>    Affects Versions: ODF 1.2 CD 05
>            Reporter: Eric Patterson
>            Assignee: Eike Rathke
>            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]