[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.) 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) ** 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.] "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 factors according to http://www.metas.ch/metasweb/Themen/Masseinheiten/calculation/en_calculation_frame_umrechnungen.html was: 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 bushel = 2150.42 cubic inches exactly. NOTE FROM WHEELER: I don't think the ones below are exact, and thus need work: "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 > 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]