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 - NEEDS-DISCUSSION



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

David Wheeler  commented on OFFICE-3492:
----------------------------------------

I have a resolution for the parsec.

There is an exact equation for parsec; unfortunately, it's a pain to calculate.  So I plan to provide both the EXACT calculation AND an approximate value.  I wanted to make sure that the approximate value was correct (which also provides a check on the equation itself).  So, I re-did the parsec calculation, and it looks okay; it's equal to the IAU and Eike's measurements, within the number of digits they provide. My recalculation used http://web2.0calc.com/ to compute 149597870.691/tan(1/(3600)), and it computed a parsec as 30856775812836.81706405772751 km.  This is exactly the same as the value provided by Eike for the number of digits Eike provided, and it meets the IAU approximation (for the small number of digits they provide).  For the approximate value I'm using the set of digits reported by Eike, and making it clear that this is approximate; in this case we have two independent calculations of the approximate answer for the digits given.

So my proposed resolution is as follows:

In row "parsec" or "pc", append this to the Description:
 , exactly AU/tan(1/3600 degree) where an AU is exactly 149,597,870.691 kilometers.
  (Source: International Astronomical Union (IAU),
  "Measuring the Universe: The IAU and astronomical units", http://www.iau.org/public/measuring/).
  A parsec is approximately 3.085677581E+16 m.

I think that resolves the definition of "parsec".


> Undefined units for Convert Function - NEEDS-DISCUSSION
> -------------------------------------------------------
>
>                 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]