[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 - NEEDS-DISCUSSION
[ http://tools.oasis-open.org/issues/browse/OFFICE-3492?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
David Wheeler updated OFFICE-3492:
-----------------------------------
Proposal:
Here are the proposed changes to CONVERT. (Editor: This includes citations for some non-obvious values, if you need to change the citation format feel free. None of these citations are normative.)
In row "ly" (light-year), append this to the Description:
, exactly (299792458 m/s) (3600 s/hr) (24 hr/day) (365.25 day).
(Source: International Astronomical Union (IAU),
"Measuring the Universe: The IAU and astronomical units", http://www.iau.org/public/measuring/).
In row "bushel", append this to the Description:
, exactly 2150.42 cubic international inches.
(Source:
National Institute of Standards and Technology (NIST),
Appendix C of NIST Handbook 44, "Specifications, Tolerances, and Other Technical Requirements for Weighing and Measuring Devices",
http://ts.nist.gov/WeightsAndMeasures/Publications/appxc.cfm)
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.
In row "HP" (horsepower), REPLACE the old Description:
Horsepower. The unit "h" is deprecated and should be replaced with "HP".
with this Description:
Mechanical horsepower aka Imperial horsepower.
Exactly 550 foot-pounds per second.
(SOURCE:
National Institute of Standards and Technology (NIST),
"The NIST Guide for the Use of the International System of Units", section B.9,
http://physics.nist.gov/Pubs/SP811/appenB9.html).
A horsepower is approximately 745.699871582 W.
("Unit Conversion Utility", http://www.metas.ch/metasweb/Themen/Masseinheiten/calculation/en_calculation_frame_umrechnungen.html)
The unit "h" is deprecated and should be replaced with "HP".
{NOTE: Wikipedia has a better description of horsepower, and we could cite a specific dated version, but some
people have a Wikipedia allergy so I'm not citing http://en.wikipedia.org/wiki/Horsepower even though it is
a far better source of information.).
After the end of the first table in CONVERT, state:
"If a conversion factor (as listed above) is not exact, an implementation may use a more accurate conversion factor instead."
** NOTE: THIS PROPOSAL WILL BE EDITED FURTHER, BUT I WANTED EVERYONE TO SEE WHERE I'M GOING.
BELOW ARE NOTES, AND NOT YET PART OF THE UPDATED PROPOSAL. **
[We will add a statement making it clear that NOT all values are exact.]
"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 factors according to
http://www.metas.ch/metasweb/Themen/Masseinheiten/calculation/en_calculation_frame_umrechnungen.html
Note: for gravitational force we could use the third CGPM (1901, CR 70) definition of standard gravity, gn=9.80665 m/s2.
was:
Here are the proposed changes to CONVERT. (Editor: This includes citations for some non-obvious values, if you need to change the citation format feel free.)
NOTE: I got the exact equation for parsec, but because it's a pain to calculate, I also checked it and provide an approximate value. I re-did the parsec calculation, and it looks okay. My recalculation used http://web2.0calc.com/ to compute 149597870.691/tan(1/(3600)), and it computed a parsec as 30856775812836.81706405772751 km. I'm using the shorter set of digits reported by Eike, and making it clear that this is approximate, so I think that resolves the definition of "parsec".
*exact* way to calculate parsec.
In row "ly" (light-year), append this to the Description:
, exactly (299792458 m/s) (3600 s/hr) (24 hr/day) (365.25 day).
(Source: International Astronomical Union (IAU),
"Measuring the Universe: The IAU and astronomical units", http://www.iau.org/public/measuring/).
In row "bushel", append this to the Description:
, exactly 2150.42 cubic international inches.
(Source:
National Institute of Standards and Technology (NIST),
Appendix C of NIST Handbook 44, "Specifications, Tolerances, and Other Technical Requirements for Weighing and Measuring Devices",
http://ts.nist.gov/WeightsAndMeasures/Publications/appxc.cfm)
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.
** NOTE: THIS PROPOSAL WILL BE EDITED FURTHER, BUT I WANTED EVERYONE TO SEE WHERE I'M GOING.
BELOW ARE NOTES, AND NOT YET PART OF THE UPDATED PROPOSAL. **
[We will add a statement making it clear that NOT all values are exact.]
"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 factors according to
http://www.metas.ch/metasweb/Themen/Masseinheiten/calculation/en_calculation_frame_umrechnungen.html
> 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]