PageRenderTime 68ms CodeModel.GetById 34ms RepoModel.GetById 1ms app.codeStats 0ms

/saf/lib/Ext/PHPExcel/Calculation/Engineering.php

https://github.com/lux/sitellite
PHP | 2174 lines | 1563 code | 210 blank | 401 comment | 339 complexity | a900301b65939c4e8ed8bdf7ed621695 MD5 | raw file
Possible License(s): GPL-2.0, LGPL-2.1, Apache-2.0, GPL-3.0

Large files files are truncated, but you can click here to view the full file

    

  1. <?php
    2. 

  2. /**
    3. 

  3.  * PHPExcel
    4. 

  4.  *
    5. 

  5.  * Copyright (c) 2006 - 2011 PHPExcel
    6. 

  6.  *
    7. 

  7.  * This library is free software; you can redistribute it and/or
    8. 

  8.  * modify it under the terms of the GNU Lesser General Public
    9. 

  9.  * License as published by the Free Software Foundation; either
    10. 

  10.  * version 2.1 of the License, or (at your option) any later version.
    11. 

  11.  *
    12. 

  12.  * This library is distributed in the hope that it will be useful,
    13. 

  13.  * but WITHOUT ANY WARRANTY; without even the implied warranty of
    14. 

  14.  * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU
    15. 

  15.  * Lesser General Public License for more details.
    16. 

  16.  *
    17. 

  17.  * You should have received a copy of the GNU Lesser General Public
    18. 

  18.  * License along with this library; if not, write to the Free Software
    19. 

  19.  * Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA
    20. 

  20.  *
    21. 

  21.  * @category	PHPExcel
    22. 

  22.  * @package		PHPExcel_Calculation
    23. 

  23.  * @copyright	Copyright (c) 2006 - 2011 PHPExcel (http://www.codeplex.com/PHPExcel)
    24. 

  24.  * @license		http://www.gnu.org/licenses/old-licenses/lgpl-2.1.txt	LGPL
    25. 

  25.  * @version		1.7.6, 2011-02-27
    26. 

  26.  */
    27. 

  27. 

  28. 

  29. /** PHPExcel root directory */
    30. 

  30. if (!defined('PHPEXCEL_ROOT')) {
    31. 

  31. 	/**
    32. 

  32. 	 * @ignore
    33. 

  33. 	 */
    34. 

  34. 	define('PHPEXCEL_ROOT', dirname(__FILE__) . '/../../');
    35. 

  35. 	require(PHPEXCEL_ROOT . 'PHPExcel/Autoloader.php');
    36. 

  36. }
    37. 

  37. 

  38. 

  39. /** EULER */
    40. 

  40. define('EULER', 2.71828182845904523536);
    41. 

  41. 

  42. 

  43. /**
    44. 

  44.  * PHPExcel_Calculation_Engineering
    45. 

  45.  *
    46. 

  46.  * @category	PHPExcel
    47. 

  47.  * @package		PHPExcel_Calculation
    48. 

  48.  * @copyright	Copyright (c) 2006 - 2011 PHPExcel (http://www.codeplex.com/PHPExcel)
    49. 

  49.  */
    50. 

  50. class PHPExcel_Calculation_Engineering {
    51. 

  51. 

  52. 	private static $_conversionUnits = array( 'g'		=> array(	'Group'	=> 'Mass',			'Unit Name'	=> 'Gram',						'AllowPrefix'	=> True		),
    53. 

  53. 											  'sg'		=> array(	'Group'	=> 'Mass',			'Unit Name'	=> 'Slug',						'AllowPrefix'	=> False	),
    54. 

  54. 											  'lbm'		=> array(	'Group'	=> 'Mass',			'Unit Name'	=> 'Pound mass (avoirdupois)',	'AllowPrefix'	=> False	),
    55. 

  55. 											  'u'		=> array(	'Group'	=> 'Mass',			'Unit Name'	=> 'U (atomic mass unit)',		'AllowPrefix'	=> True		),
    56. 

  56. 											  'ozm'		=> array(	'Group'	=> 'Mass',			'Unit Name'	=> 'Ounce mass (avoirdupois)',	'AllowPrefix'	=> False	),
    57. 

  57. 											  'm'		=> array(	'Group'	=> 'Distance',		'Unit Name'	=> 'Meter',						'AllowPrefix'	=> True		),
    58. 

  58. 											  'mi'		=> array(	'Group'	=> 'Distance',		'Unit Name'	=> 'Statute mile',				'AllowPrefix'	=> False	),
    59. 

  59. 											  'Nmi'		=> array(	'Group'	=> 'Distance',		'Unit Name'	=> 'Nautical mile',				'AllowPrefix'	=> False	),
    60. 

  60. 											  'in'		=> array(	'Group'	=> 'Distance',		'Unit Name'	=> 'Inch',						'AllowPrefix'	=> False	),
    61. 

  61. 											  'ft'		=> array(	'Group'	=> 'Distance',		'Unit Name'	=> 'Foot',						'AllowPrefix'	=> False	),
    62. 

  62. 											  'yd'		=> array(	'Group'	=> 'Distance',		'Unit Name'	=> 'Yard',						'AllowPrefix'	=> False	),
    63. 

  63. 											  'ang'		=> array(	'Group'	=> 'Distance',		'Unit Name'	=> 'Angstrom',					'AllowPrefix'	=> True		),
    64. 

  64. 											  'Pica'	=> array(	'Group'	=> 'Distance',		'Unit Name'	=> 'Pica (1/72 in)',			'AllowPrefix'	=> False	),
    65. 

  65. 											  'yr'		=> array(	'Group'	=> 'Time',			'Unit Name'	=> 'Year',						'AllowPrefix'	=> False	),
    66. 

  66. 											  'day'		=> array(	'Group'	=> 'Time',			'Unit Name'	=> 'Day',						'AllowPrefix'	=> False	),
    67. 

  67. 											  'hr'		=> array(	'Group'	=> 'Time',			'Unit Name'	=> 'Hour',						'AllowPrefix'	=> False	),
    68. 

  68. 											  'mn'		=> array(	'Group'	=> 'Time',			'Unit Name'	=> 'Minute',					'AllowPrefix'	=> False	),
    69. 

  69. 											  'sec'		=> array(	'Group'	=> 'Time',			'Unit Name'	=> 'Second',					'AllowPrefix'	=> True		),
    70. 

  70. 											  'Pa'		=> array(	'Group'	=> 'Pressure',		'Unit Name'	=> 'Pascal',					'AllowPrefix'	=> True		),
    71. 

  71. 											  'p'		=> array(	'Group'	=> 'Pressure',		'Unit Name'	=> 'Pascal',					'AllowPrefix'	=> True		),
    72. 

  72. 											  'atm'		=> array(	'Group'	=> 'Pressure',		'Unit Name'	=> 'Atmosphere',				'AllowPrefix'	=> True		),
    73. 

  73. 											  'at'		=> array(	'Group'	=> 'Pressure',		'Unit Name'	=> 'Atmosphere',				'AllowPrefix'	=> True		),
    74. 

  74. 											  'mmHg'	=> array(	'Group'	=> 'Pressure',		'Unit Name'	=> 'mm of Mercury',				'AllowPrefix'	=> True		),
    75. 

  75. 											  'N'		=> array(	'Group'	=> 'Force',			'Unit Name'	=> 'Newton',					'AllowPrefix'	=> True		),
    76. 

  76. 											  'dyn'		=> array(	'Group'	=> 'Force',			'Unit Name'	=> 'Dyne',						'AllowPrefix'	=> True		),
    77. 

  77. 											  'dy'		=> array(	'Group'	=> 'Force',			'Unit Name'	=> 'Dyne',						'AllowPrefix'	=> True		),
    78. 

  78. 											  'lbf'		=> array(	'Group'	=> 'Force',			'Unit Name'	=> 'Pound force',				'AllowPrefix'	=> False	),
    79. 

  79. 											  'J'		=> array(	'Group'	=> 'Energy',		'Unit Name'	=> 'Joule',						'AllowPrefix'	=> True		),
    80. 

  80. 											  'e'		=> array(	'Group'	=> 'Energy',		'Unit Name'	=> 'Erg',						'AllowPrefix'	=> True		),
    81. 

  81. 											  'c'		=> array(	'Group'	=> 'Energy',		'Unit Name'	=> 'Thermodynamic calorie',		'AllowPrefix'	=> True		),
    82. 

  82. 											  'cal'		=> array(	'Group'	=> 'Energy',		'Unit Name'	=> 'IT calorie',				'AllowPrefix'	=> True		),
    83. 

  83. 											  'eV'		=> array(	'Group'	=> 'Energy',		'Unit Name'	=> 'Electron volt',				'AllowPrefix'	=> True		),
    84. 

  84. 											  'ev'		=> array(	'Group'	=> 'Energy',		'Unit Name'	=> 'Electron volt',				'AllowPrefix'	=> True		),
    85. 

  85. 											  'HPh'		=> array(	'Group'	=> 'Energy',		'Unit Name'	=> 'Horsepower-hour',			'AllowPrefix'	=> False	),
    86. 

  86. 											  'hh'		=> array(	'Group'	=> 'Energy',		'Unit Name'	=> 'Horsepower-hour',			'AllowPrefix'	=> False	),
    87. 

  87. 											  'Wh'		=> array(	'Group'	=> 'Energy',		'Unit Name'	=> 'Watt-hour',					'AllowPrefix'	=> True		),
    88. 

  88. 											  'wh'		=> array(	'Group'	=> 'Energy',		'Unit Name'	=> 'Watt-hour',					'AllowPrefix'	=> True		),
    89. 

  89. 											  'flb'		=> array(	'Group'	=> 'Energy',		'Unit Name'	=> 'Foot-pound',				'AllowPrefix'	=> False	),
    90. 

  90. 											  'BTU'		=> array(	'Group'	=> 'Energy',		'Unit Name'	=> 'BTU',						'AllowPrefix'	=> False	),
    91. 

  91. 											  'btu'		=> array(	'Group'	=> 'Energy',		'Unit Name'	=> 'BTU',						'AllowPrefix'	=> False	),
    92. 

  92. 											  'HP'		=> array(	'Group'	=> 'Power',			'Unit Name'	=> 'Horsepower',				'AllowPrefix'	=> False	),
    93. 

  93. 											  'h'		=> array(	'Group'	=> 'Power',			'Unit Name'	=> 'Horsepower',				'AllowPrefix'	=> False	),
    94. 

  94. 											  'W'		=> array(	'Group'	=> 'Power',			'Unit Name'	=> 'Watt',						'AllowPrefix'	=> True		),
    95. 

  95. 											  'w'		=> array(	'Group'	=> 'Power',			'Unit Name'	=> 'Watt',						'AllowPrefix'	=> True		),
    96. 

  96. 											  'T'		=> array(	'Group'	=> 'Magnetism',		'Unit Name'	=> 'Tesla',						'AllowPrefix'	=> True		),
    97. 

  97. 											  'ga'		=> array(	'Group'	=> 'Magnetism',		'Unit Name'	=> 'Gauss',						'AllowPrefix'	=> True		),
    98. 

  98. 											  'C'		=> array(	'Group'	=> 'Temperature',	'Unit Name'	=> 'Celsius',					'AllowPrefix'	=> False	),
    99. 

  99. 											  'cel'		=> array(	'Group'	=> 'Temperature',	'Unit Name'	=> 'Celsius',					'AllowPrefix'	=> False	),
    100. 

  100. 											  'F'		=> array(	'Group'	=> 'Temperature',	'Unit Name'	=> 'Fahrenheit',				'AllowPrefix'	=> False	),
    101. 

  101. 											  'fah'		=> array(	'Group'	=> 'Temperature',	'Unit Name'	=> 'Fahrenheit',				'AllowPrefix'	=> False	),
    102. 

  102. 											  'K'		=> array(	'Group'	=> 'Temperature',	'Unit Name'	=> 'Kelvin',					'AllowPrefix'	=> False	),
    103. 

  103. 											  'kel'		=> array(	'Group'	=> 'Temperature',	'Unit Name'	=> 'Kelvin',					'AllowPrefix'	=> False	),
    104. 

  104. 											  'tsp'		=> array(	'Group'	=> 'Liquid',		'Unit Name'	=> 'Teaspoon',					'AllowPrefix'	=> False	),
    105. 

  105. 											  'tbs'		=> array(	'Group'	=> 'Liquid',		'Unit Name'	=> 'Tablespoon',				'AllowPrefix'	=> False	),
    106. 

  106. 											  'oz'		=> array(	'Group'	=> 'Liquid',		'Unit Name'	=> 'Fluid Ounce',				'AllowPrefix'	=> False	),
    107. 

  107. 											  'cup'		=> array(	'Group'	=> 'Liquid',		'Unit Name'	=> 'Cup',						'AllowPrefix'	=> False	),
    108. 

  108. 											  'pt'		=> array(	'Group'	=> 'Liquid',		'Unit Name'	=> 'U.S. Pint',					'AllowPrefix'	=> False	),
    109. 

  109. 											  'us_pt'	=> array(	'Group'	=> 'Liquid',		'Unit Name'	=> 'U.S. Pint',					'AllowPrefix'	=> False	),
    110. 

  110. 											  'uk_pt'	=> array(	'Group'	=> 'Liquid',		'Unit Name'	=> 'U.K. Pint',					'AllowPrefix'	=> False	),
    111. 

  111. 											  'qt'		=> array(	'Group'	=> 'Liquid',		'Unit Name'	=> 'Quart',						'AllowPrefix'	=> False	),
    112. 

  112. 											  'gal'		=> array(	'Group'	=> 'Liquid',		'Unit Name'	=> 'Gallon',					'AllowPrefix'	=> False	),
    113. 

  113. 											  'l'		=> array(	'Group'	=> 'Liquid',		'Unit Name'	=> 'Litre',						'AllowPrefix'	=> True		),
    114. 

  114. 											  'lt'		=> array(	'Group'	=> 'Liquid',		'Unit Name'	=> 'Litre',						'AllowPrefix'	=> True		)
    115. 

  115. 											);
    116. 

  116. 

  117. 	private static $_conversionMultipliers = array(	'Y'	=> array(	'multiplier'	=> 1E24,	'name'	=> 'yotta'	),
    118. 

  118. 													'Z'	=> array(	'multiplier'	=> 1E21,	'name'	=> 'zetta'	),
    119. 

  119. 													'E'	=> array(	'multiplier'	=> 1E18,	'name'	=> 'exa'	),
    120. 

  120. 													'P'	=> array(	'multiplier'	=> 1E15,	'name'	=> 'peta'	),
    121. 

  121. 													'T'	=> array(	'multiplier'	=> 1E12,	'name'	=> 'tera'	),
    122. 

  122. 													'G'	=> array(	'multiplier'	=> 1E9,		'name'	=> 'giga'	),
    123. 

  123. 													'M'	=> array(	'multiplier'	=> 1E6,		'name'	=> 'mega'	),
    124. 

  124. 													'k'	=> array(	'multiplier'	=> 1E3,		'name'	=> 'kilo'	),
    125. 

  125. 													'h'	=> array(	'multiplier'	=> 1E2,		'name'	=> 'hecto'	),
    126. 

  126. 													'e'	=> array(	'multiplier'	=> 1E1,		'name'	=> 'deka'	),
    127. 

  127. 													'd'	=> array(	'multiplier'	=> 1E-1,	'name'	=> 'deci'	),
    128. 

  128. 													'c'	=> array(	'multiplier'	=> 1E-2,	'name'	=> 'centi'	),
    129. 

  129. 													'm'	=> array(	'multiplier'	=> 1E-3,	'name'	=> 'milli'	),
    130. 

  130. 													'u'	=> array(	'multiplier'	=> 1E-6,	'name'	=> 'micro'	),
    131. 

  131. 													'n'	=> array(	'multiplier'	=> 1E-9,	'name'	=> 'nano'	),
    132. 

  132. 													'p'	=> array(	'multiplier'	=> 1E-12,	'name'	=> 'pico'	),
    133. 

  133. 													'f'	=> array(	'multiplier'	=> 1E-15,	'name'	=> 'femto'	),
    134. 

  134. 													'a'	=> array(	'multiplier'	=> 1E-18,	'name'	=> 'atto'	),
    135. 

  135. 													'z'	=> array(	'multiplier'	=> 1E-21,	'name'	=> 'zepto'	),
    136. 

  136. 													'y'	=> array(	'multiplier'	=> 1E-24,	'name'	=> 'yocto'	)
    137. 

  137. 												 );
    138. 

  138. 

  139. 	private static $_unitConversions = array(	'Mass'		=> array(	'g'		=> array(	'g'		=> 1.0,
    140. 

  140. 																							'sg'	=> 6.85220500053478E-05,
    141. 

  141. 																							'lbm'	=> 2.20462291469134E-03,
    142. 

  142. 																							'u'		=> 6.02217000000000E+23,
    143. 

  143. 																							'ozm'	=> 3.52739718003627E-02
    144. 

  144. 																						),
    145. 

  145. 																		'sg'	=> array(	'g'		=> 1.45938424189287E+04,
    146. 

  146. 																							'sg'	=> 1.0,
    147. 

  147. 																							'lbm'	=> 3.21739194101647E+01,
    148. 

  148. 																							'u'		=> 8.78866000000000E+27,
    149. 

  149. 																							'ozm'	=> 5.14782785944229E+02
    150. 

  150. 																						),
    151. 

  151. 																		'lbm'	=> array(	'g'		=> 4.5359230974881148E+02,
    152. 

  152. 																							'sg'	=> 3.10810749306493E-02,
    153. 

  153. 																							'lbm'	=> 1.0,
    154. 

  154. 																							'u'		=> 2.73161000000000E+26,
    155. 

  155. 																							'ozm'	=> 1.60000023429410E+01
    156. 

  156. 																						),
    157. 

  157. 																		'u'		=> array(	'g'		=> 1.66053100460465E-24,
    158. 

  158. 																							'sg'	=> 1.13782988532950E-28,
    159. 

  159. 																							'lbm'	=> 3.66084470330684E-27,
    160. 

  160. 																							'u'		=> 1.0,
    161. 

  161. 																							'ozm'	=> 5.85735238300524E-26
    162. 

  162. 																						),
    163. 

  163. 																		'ozm'	=> array(	'g'		=> 2.83495152079732E+01,
    164. 

  164. 																							'sg'	=> 1.94256689870811E-03,
    165. 

  165. 																							'lbm'	=> 6.24999908478882E-02,
    166. 

  166. 																							'u'		=> 1.70725600000000E+25,
    167. 

  167. 																							'ozm'	=> 1.0
    168. 

  168. 																						)
    169. 

  169. 																	),
    170. 

  170. 												'Distance'	=> array(	'm'		=> array(	'm'		=> 1.0,
    171. 

  171. 																							'mi'	=> 6.21371192237334E-04,
    172. 

  172. 																							'Nmi'	=> 5.39956803455724E-04,
    173. 

  173. 																							'in'	=> 3.93700787401575E+01,
    174. 

  174. 																							'ft'	=> 3.28083989501312E+00,
    175. 

  175. 																							'yd'	=> 1.09361329797891E+00,
    176. 

  176. 																							'ang'	=> 1.00000000000000E+10,
    177. 

  177. 																							'Pica'	=> 2.83464566929116E+03
    178. 

  178. 																						),
    179. 

  179. 																		'mi'	=> array(	'm'		=> 1.60934400000000E+03,
    180. 

  180. 																							'mi'	=> 1.0,
    181. 

  181. 																							'Nmi'	=> 8.68976241900648E-01,
    182. 

  182. 																							'in'	=> 6.33600000000000E+04,
    183. 

  183. 																							'ft'	=> 5.28000000000000E+03,
    184. 

  184. 																							'yd'	=> 1.76000000000000E+03,
    185. 

  185. 																							'ang'	=> 1.60934400000000E+13,
    186. 

  186. 																							'Pica'	=> 4.56191999999971E+06
    187. 

  187. 																						),
    188. 

  188. 																		'Nmi'	=> array(	'm'		=> 1.85200000000000E+03,
    189. 

  189. 																							'mi'	=> 1.15077944802354E+00,
    190. 

  190. 																							'Nmi'	=> 1.0,
    191. 

  191. 																							'in'	=> 7.29133858267717E+04,
    192. 

  192. 																							'ft'	=> 6.07611548556430E+03,
    193. 

  193. 																							'yd'	=> 2.02537182785694E+03,
    194. 

  194. 																							'ang'	=> 1.85200000000000E+13,
    195. 

  195. 																							'Pica'	=> 5.24976377952723E+06
    196. 

  196. 																						),
    197. 

  197. 																		'in'	=> array(	'm'		=> 2.54000000000000E-02,
    198. 

  198. 																							'mi'	=> 1.57828282828283E-05,
    199. 

  199. 																							'Nmi'	=> 1.37149028077754E-05,
    200. 

  200. 																							'in'	=> 1.0,
    201. 

  201. 																							'ft'	=> 8.33333333333333E-02,
    202. 

  202. 																							'yd'	=> 2.77777777686643E-02,
    203. 

  203. 																							'ang'	=> 2.54000000000000E+08,
    204. 

  204. 																							'Pica'	=> 7.19999999999955E+01
    205. 

  205. 																						),
    206. 

  206. 																		'ft'	=> array(	'm'		=> 3.04800000000000E-01,
    207. 

  207. 																							'mi'	=> 1.89393939393939E-04,
    208. 

  208. 																							'Nmi'	=> 1.64578833693305E-04,
    209. 

  209. 																							'in'	=> 1.20000000000000E+01,
    210. 

  210. 																							'ft'	=> 1.0,
    211. 

  211. 																							'yd'	=> 3.33333333223972E-01,
    212. 

  212. 																							'ang'	=> 3.04800000000000E+09,
    213. 

  213. 																							'Pica'	=> 8.63999999999946E+02
    214. 

  214. 																						),
    215. 

  215. 																		'yd'	=> array(	'm'		=> 9.14400000300000E-01,
    216. 

  216. 																							'mi'	=> 5.68181818368230E-04,
    217. 

  217. 																							'Nmi'	=> 4.93736501241901E-04,
    218. 

  218. 																							'in'	=> 3.60000000118110E+01,
    219. 

  219. 																							'ft'	=> 3.00000000000000E+00,
    220. 

  220. 																							'yd'	=> 1.0,
    221. 

  221. 																							'ang'	=> 9.14400000300000E+09,
    222. 

  222. 																							'Pica'	=> 2.59200000085023E+03
    223. 

  223. 																						),
    224. 

  224. 																		'ang'	=> array(	'm'		=> 1.00000000000000E-10,
    225. 

  225. 																							'mi'	=> 6.21371192237334E-14,
    226. 

  226. 																							'Nmi'	=> 5.39956803455724E-14,
    227. 

  227. 																							'in'	=> 3.93700787401575E-09,
    228. 

  228. 																							'ft'	=> 3.28083989501312E-10,
    229. 

  229. 																							'yd'	=> 1.09361329797891E-10,
    230. 

  230. 																							'ang'	=> 1.0,
    231. 

  231. 																							'Pica'	=> 2.83464566929116E-07
    232. 

  232. 																						),
    233. 

  233. 																		'Pica'	=> array(	'm'		=> 3.52777777777800E-04,
    234. 

  234. 																							'mi'	=> 2.19205948372629E-07,
    235. 

  235. 																							'Nmi'	=> 1.90484761219114E-07,
    236. 

  236. 																							'in'	=> 1.38888888888898E-02,
    237. 

  237. 																							'ft'	=> 1.15740740740748E-03,
    238. 

  238. 																							'yd'	=> 3.85802469009251E-04,
    239. 

  239. 																							'ang'	=> 3.52777777777800E+06,
    240. 

  240. 																							'Pica'	=> 1.0
    241. 

  241. 																						)
    242. 

  242. 																	),
    243. 

  243. 												'Time'		=> array(	'yr'	=> array(	'yr'		=> 1.0,
    244. 

  244. 																							'day'		=> 365.25,
    245. 

  245. 																							'hr'		=> 8766.0,
    246. 

  246. 																							'mn'		=> 525960.0,
    247. 

  247. 																							'sec'		=> 31557600.0
    248. 

  248. 																						),
    249. 

  249. 																		'day'	=> array(	'yr'		=> 2.73785078713210E-03,
    250. 

  250. 																							'day'		=> 1.0,
    251. 

  251. 																							'hr'		=> 24.0,
    252. 

  252. 																							'mn'		=> 1440.0,
    253. 

  253. 																							'sec'		=> 86400.0
    254. 

  254. 																						),
    255. 

  255. 																		'hr'	=> array(	'yr'		=> 1.14077116130504E-04,
    256. 

  256. 																							'day'		=> 4.16666666666667E-02,
    257. 

  257. 																							'hr'		=> 1.0,
    258. 

  258. 																							'mn'		=> 60.0,
    259. 

  259. 																							'sec'		=> 3600.0
    260. 

  260. 																						),
    261. 

  261. 																		'mn'	=> array(	'yr'		=> 1.90128526884174E-06,
    262. 

  262. 																							'day'		=> 6.94444444444444E-04,
    263. 

  263. 																							'hr'		=> 1.66666666666667E-02,
    264. 

  264. 																							'mn'		=> 1.0,
    265. 

  265. 																							'sec'		=> 60.0
    266. 

  266. 																						),
    267. 

  267. 																		'sec'	=> array(	'yr'		=> 3.16880878140289E-08,
    268. 

  268. 																							'day'		=> 1.15740740740741E-05,
    269. 

  269. 																							'hr'		=> 2.77777777777778E-04,
    270. 

  270. 																							'mn'		=> 1.66666666666667E-02,
    271. 

  271. 																							'sec'		=> 1.0
    272. 

  272. 																						)
    273. 

  273. 																	),
    274. 

  274. 												'Pressure'	=> array(	'Pa'	=> array(	'Pa'		=> 1.0,
    275. 

  275. 																							'p'			=> 1.0,
    276. 

  276. 																							'atm'		=> 9.86923299998193E-06,
    277. 

  277. 																							'at'		=> 9.86923299998193E-06,
    278. 

  278. 																							'mmHg'		=> 7.50061707998627E-03
    279. 

  279. 																						),
    280. 

  280. 																		'p'		=> array(	'Pa'		=> 1.0,
    281. 

  281. 																							'p'			=> 1.0,
    282. 

  282. 																							'atm'		=> 9.86923299998193E-06,
    283. 

  283. 																							'at'		=> 9.86923299998193E-06,
    284. 

  284. 																							'mmHg'		=> 7.50061707998627E-03
    285. 

  285. 																						),
    286. 

  286. 																		'atm'	=> array(	'Pa'		=> 1.01324996583000E+05,
    287. 

  287. 																							'p'			=> 1.01324996583000E+05,
    288. 

  288. 																							'atm'		=> 1.0,
    289. 

  289. 																							'at'		=> 1.0,
    290. 

  290. 																							'mmHg'		=> 760.0
    291. 

  291. 																						),
    292. 

  292. 																		'at'	=> array(	'Pa'		=> 1.01324996583000E+05,
    293. 

  293. 																							'p'			=> 1.01324996583000E+05,
    294. 

  294. 																							'atm'		=> 1.0,
    295. 

  295. 																							'at'		=> 1.0,
    296. 

  296. 																							'mmHg'		=> 760.0
    297. 

  297. 																						),
    298. 

  298. 																		'mmHg'	=> array(	'Pa'		=> 1.33322363925000E+02,
    299. 

  299. 																							'p'			=> 1.33322363925000E+02,
    300. 

  300. 																							'atm'		=> 1.31578947368421E-03,
    301. 

  301. 																							'at'		=> 1.31578947368421E-03,
    302. 

  302. 																							'mmHg'		=> 1.0
    303. 

  303. 																						)
    304. 

  304. 																	),
    305. 

  305. 												'Force'		=> array(	'N'		=> array(	'N'			=> 1.0,
    306. 

  306. 																							'dyn'		=> 1.0E+5,
    307. 

  307. 																							'dy'		=> 1.0E+5,
    308. 

  308. 																							'lbf'		=> 2.24808923655339E-01
    309. 

  309. 																						),
    310. 

  310. 																		'dyn'	=> array(	'N'			=> 1.0E-5,
    311. 

  311. 																							'dyn'		=> 1.0,
    312. 

  312. 																							'dy'		=> 1.0,
    313. 

  313. 																							'lbf'		=> 2.24808923655339E-06
    314. 

  314. 																						),
    315. 

  315. 																		'dy'	=> array(	'N'			=> 1.0E-5,
    316. 

  316. 																							'dyn'		=> 1.0,
    317. 

  317. 																							'dy'		=> 1.0,
    318. 

  318. 																							'lbf'		=> 2.24808923655339E-06
    319. 

  319. 																						),
    320. 

  320. 																		'lbf'	=> array(	'N'			=> 4.448222,
    321. 

  321. 																							'dyn'		=> 4.448222E+5,
    322. 

  322. 																							'dy'		=> 4.448222E+5,
    323. 

  323. 																							'lbf'		=> 1.0
    324. 

  324. 																						)
    325. 

  325. 																	),
    326. 

  326. 												'Energy'	=> array(	'J'		=> array(	'J'			=> 1.0,
    327. 

  327. 																							'e'			=> 9.99999519343231E+06,
    328. 

  328. 																							'c'			=> 2.39006249473467E-01,
    329. 

  329. 																							'cal'		=> 2.38846190642017E-01,
    330. 

  330. 																							'eV'		=> 6.24145700000000E+18,
    331. 

  331. 																							'ev'		=> 6.24145700000000E+18,
    332. 

  332. 																							'HPh'		=> 3.72506430801000E-07,
    333. 

  333. 																							'hh'		=> 3.72506430801000E-07,
    334. 

  334. 																							'Wh'		=> 2.77777916238711E-04,
    335. 

  335. 																							'wh'		=> 2.77777916238711E-04,
    336. 

  336. 																							'flb'		=> 2.37304222192651E+01,
    337. 

  337. 																							'BTU'		=> 9.47815067349015E-04,
    338. 

  338. 																							'btu'		=> 9.47815067349015E-04
    339. 

  339. 																						),
    340. 

  340. 																		'e'		=> array(	'J'			=> 1.00000048065700E-07,
    341. 

  341. 																							'e'			=> 1.0,
    342. 

  342. 																							'c'			=> 2.39006364353494E-08,
    343. 

  343. 																							'cal'		=> 2.38846305445111E-08,
    344. 

  344. 																							'eV'		=> 6.24146000000000E+11,
    345. 

  345. 																							'ev'		=> 6.24146000000000E+11,
    346. 

  346. 																							'HPh'		=> 3.72506609848824E-14,
    347. 

  347. 																							'hh'		=> 3.72506609848824E-14,
    348. 

  348. 																							'Wh'		=> 2.77778049754611E-11,
    349. 

  349. 																							'wh'		=> 2.77778049754611E-11,
    350. 

  350. 																							'flb'		=> 2.37304336254586E-06,
    351. 

  351. 																							'BTU'		=> 9.47815522922962E-11,
    352. 

  352. 																							'btu'		=> 9.47815522922962E-11
    353. 

  353. 																						),
    354. 

  354. 																		'c'		=> array(	'J'			=> 4.18399101363672E+00,
    355. 

  355. 																							'e'			=> 4.18398900257312E+07,
    356. 

  356. 																							'c'			=> 1.0,
    357. 

  357. 																							'cal'		=> 9.99330315287563E-01,
    358. 

  358. 																							'eV'		=> 2.61142000000000E+19,
    359. 

  359. 																							'ev'		=> 2.61142000000000E+19,
    360. 

  360. 																							'HPh'		=> 1.55856355899327E-06,
    361. 

  361. 																							'hh'		=> 1.55856355899327E-06,
    362. 

  362. 																							'Wh'		=> 1.16222030532950E-03,
    363. 

  363. 																							'wh'		=> 1.16222030532950E-03,
    364. 

  364. 																							'flb'		=> 9.92878733152102E+01,
    365. 

  365. 																							'BTU'		=> 3.96564972437776E-03,
    366. 

  366. 																							'btu'		=> 3.96564972437776E-03
    367. 

  367. 																						),
    368. 

  368. 																		'cal'	=> array(	'J'			=> 4.18679484613929E+00,
    369. 

  369. 																							'e'			=> 4.18679283372801E+07,
    370. 

  370. 																							'c'			=> 1.00067013349059E+00,
    371. 

  371. 																							'cal'		=> 1.0,
    372. 

  372. 																							'eV'		=> 2.61317000000000E+19,
    373. 

  373. 																							'ev'		=> 2.61317000000000E+19,
    374. 

  374. 																							'HPh'		=> 1.55960800463137E-06,
    375. 

  375. 																							'hh'		=> 1.55960800463137E-06,
    376. 

  376. 																							'Wh'		=> 1.16299914807955E-03,
    377. 

  377. 																							'wh'		=> 1.16299914807955E-03,
    378. 

  378. 																							'flb'		=> 9.93544094443283E+01,
    379. 

  379. 																							'BTU'		=> 3.96830723907002E-03,
    380. 

  380. 																							'btu'		=> 3.96830723907002E-03
    381. 

  381. 																						),
    382. 

  382. 																		'eV'	=> array(	'J'			=> 1.60219000146921E-19,
    383. 

  383. 																							'e'			=> 1.60218923136574E-12,
    384. 

  384. 																							'c'			=> 3.82933423195043E-20,
    385. 

  385. 																							'cal'		=> 3.82676978535648E-20,
    386. 

  386. 																							'eV'		=> 1.0,
    387. 

  387. 																							'ev'		=> 1.0,
    388. 

  388. 																							'HPh'		=> 5.96826078912344E-26,
    389. 

  389. 																							'hh'		=> 5.96826078912344E-26,
    390. 

  390. 																							'Wh'		=> 4.45053000026614E-23,
    391. 

  391. 																							'wh'		=> 4.45053000026614E-23,
    392. 

  392. 																							'flb'		=> 3.80206452103492E-18,
    393. 

  393. 																							'BTU'		=> 1.51857982414846E-22,
    394. 

  394. 																							'btu'		=> 1.51857982414846E-22
    395. 

  395. 																						),
    396. 

  396. 																		'ev'	=> array(	'J'			=> 1.60219000146921E-19,
    397. 

  397. 																							'e'			=> 1.60218923136574E-12,
    398. 

  398. 																							'c'			=> 3.82933423195043E-20,
    399. 

  399. 																							'cal'		=> 3.82676978535648E-20,
    400. 

  400. 																							'eV'		=> 1.0,
    401. 

  401. 																							'ev'		=> 1.0,
    402. 

  402. 																							'HPh'		=> 5.96826078912344E-26,
    403. 

  403. 																							'hh'		=> 5.96826078912344E-26,
    404. 

  404. 																							'Wh'		=> 4.45053000026614E-23,
    405. 

  405. 																							'wh'		=> 4.45053000026614E-23,
    406. 

  406. 																							'flb'		=> 3.80206452103492E-18,
    407. 

  407. 																							'BTU'		=> 1.51857982414846E-22,
    408. 

  408. 																							'btu'		=> 1.51857982414846E-22
    409. 

  409. 																						),
    410. 

  410. 																		'HPh'	=> array(	'J'			=> 2.68451741316170E+06,
    411. 

  411. 																							'e'			=> 2.68451612283024E+13,
    412. 

  412. 																							'c'			=> 6.41616438565991E+05,
    413. 

  413. 																							'cal'		=> 6.41186757845835E+05,
    414. 

  414. 																							'eV'		=> 1.67553000000000E+25,
    415. 

  415. 																							'ev'		=> 1.67553000000000E+25,
    416. 

  416. 																							'HPh'		=> 1.0,
    417. 

  417. 																							'hh'		=> 1.0,
    418. 

  418. 																							'Wh'		=> 7.45699653134593E+02,
    419. 

  419. 																							'wh'		=> 7.45699653134593E+02,
    420. 

  420. 																							'flb'		=> 6.37047316692964E+07,
    421. 

  421. 																							'BTU'		=> 2.54442605275546E+03,
    422. 

  422. 																							'btu'		=> 2.54442605275546E+03
    423. 

  423. 																						),
    424. 

  424. 																		'hh'	=> array(	'J'			=> 2.68451741316170E+06,
    425. 

  425. 																							'e'			=> 2.68451612283024E+13,
    426. 

  426. 																							'c'			=> 6.41616438565991E+05,
    427. 

  427. 																							'cal'		=> 6.41186757845835E+05,
    428. 

  428. 																							'eV'		=> 1.67553000000000E+25,
    429. 

  429. 																							'ev'		=> 1.67553000000000E+25,
    430. 

  430. 																							'HPh'		=> 1.0,
    431. 

  431. 																							'hh'		=> 1.0,
    432. 

  432. 																							'Wh'		=> 7.45699653134593E+02,
    433. 

  433. 																							'wh'		=> 7.45699653134593E+02,
    434. 

  434. 																							'flb'		=> 6.37047316692964E+07,
    435. 

  435. 																							'BTU'		=> 2.54442605275546E+03,
    436. 

  436. 																							'btu'		=> 2.54442605275546E+03
    437. 

  437. 																						),
    438. 

  438. 																		'Wh'	=> array(	'J'			=> 3.59999820554720E+03,
    439. 

  439. 																							'e'			=> 3.59999647518369E+10,
    440. 

  440. 																							'c'			=> 8.60422069219046E+02,
    441. 

  441. 																							'cal'		=> 8.59845857713046E+02,
    442. 

  442. 																							'eV'		=> 2.24692340000000E+22,
    443. 

  443. 																							'ev'		=> 2.24692340000000E+22,
    444. 

  444. 																							'HPh'		=> 1.34102248243839E-03,
    445. 

  445. 																							'hh'		=> 1.34102248243839E-03,
    446. 

  446. 																							'Wh'		=> 1.0,
    447. 

  447. 																							'wh'		=> 1.0,
    448. 

  448. 																							'flb'		=> 8.54294774062316E+04,
    449. 

  449. 																							'BTU'		=> 3.41213254164705E+00,
    450. 

  450. 																							'btu'		=> 3.41213254164705E+00
    451. 

  451. 																						),
    452. 

  452. 																		'wh'	=> array(	'J'			=> 3.59999820554720E+03,
    453. 

  453. 																							'e'			=> 3.59999647518369E+10,
    454. 

  454. 																							'c'			=> 8.60422069219046E+02,
    455. 

  455. 																							'cal'		=> 8.59845857713046E+02,
    456. 

  456. 																							'eV'		=> 2.24692340000000E+22,
    457. 

  457. 																							'ev'		=> 2.24692340000000E+22,
    458. 

  458. 																							'HPh'		=> 1.34102248243839E-03,
    459. 

  459. 																							'hh'		=> 1.34102248243839E-03,
    460. 

  460. 																							'Wh'		=> 1.0,
    461. 

  461. 																							'wh'		=> 1.0,
    462. 

  462. 																							'flb'		=> 8.54294774062316E+04,
    463. 

  463. 																							'BTU'		=> 3.41213254164705E+00,
    464. 

  464. 																							'btu'		=> 3.41213254164705E+00
    465. 

  465. 																						),
    466. 

  466. 																		'flb'	=> array(	'J'			=> 4.21400003236424E-02,
    467. 

  467. 																							'e'			=> 4.21399800687660E+05,
    468. 

  468. 																							'c'			=> 1.00717234301644E-02,
    469. 

  469. 																							'cal'		=> 1.00649785509554E-02,
    470. 

  470. 																							'eV'		=> 2.63015000000000E+17,
    471. 

  471. 																							'ev'		=> 2.63015000000000E+17,
    472. 

  472. 																							'HPh'		=> 1.56974211145130E-08,
    473. 

  473. 																							'hh'		=> 1.56974211145130E-08,
    474. 

  474. 																							'Wh'		=> 1.17055614802000E-05,
    475. 

  475. 																							'wh'		=> 1.17055614802000E-05,
    476. 

  476. 																							'flb'		=> 1.0,
    477. 

  477. 																							'BTU'		=> 3.99409272448406E-05,
    478. 

  478. 																							'btu'		=> 3.99409272448406E-05
    479. 

  479. 																						),
    480. 

  480. 																		'BTU'	=> array(	'J'			=> 1.05505813786749E+03,
    481. 

  481. 																							'e'			=> 1.05505763074665E+10,
    482. 

  482. 																							'c'			=> 2.52165488508168E+02,
    483. 

  483. 																							'cal'		=> 2.51996617135510E+02,
    484. 

  484. 																							'eV'		=> 6.58510000000000E+21,
    485. 

  485. 																							'ev'		=> 6.58510000000000E+21,
    486. 

  486. 																							'HPh'		=> 3.93015941224568E-04,
    487. 

  487. 																							'hh'		=> 3.93015941224568E-04,
    488. 

  488. 																							'Wh'		=> 2.93071851047526E-01,
    489. 

  489. 																							'wh'		=> 2.93071851047526E-01,
    490. 

  490. 																							'flb'		=> 2.50369750774671E+04,
    491. 

  491. 																							'BTU'		=> 1.0,
    492. 

  492. 																							'btu'		=> 1.0,
    493. 

  493. 																						),
    494. 

  494. 																		'btu'	=> array(	'J'			=> 1.05505813786749E+03,
    495. 

  495. 																							'e'			=> 1.05505763074665E+10,
    496. 

  496. 																							'c'			=> 2.52165488508168E+02,
    497. 

  497. 																							'cal'		=> 2.51996617135510E+02,
    498. 

  498. 																							'eV'		=> 6.58510000000000E+21,
    499. 

  499. 																							'ev'		=> 6.58510000000000E+21,
    500. 

  500. 																							'HPh'		=> 3.93015941224568E-04,
    501. 

  501. 																							'hh'		=> 3.93015941224568E-04,
    502. 

  502. 																							'Wh'		=> 2.93071851047526E-01,
    503. 

  503. 																							'wh'		=> 2.93071851047526E-01,
    504. 

  504. 																							'flb'		=> 2.50369750774671E+04,
    505. 

  505. 																							'BTU'		=> 1.0,
    506. 

  506. 																							'btu'		=> 1.0,
    507. 

  507. 																						)
    508. 

  508. 																	),
    509. 

  509. 												'Power'		=> array(	'HP'	=> array(	'HP'		=> 1.0,
    510. 

  510. 																							'h'			=> 1.0,
    511. 

  511. 																							'W'			=> 7.45701000000000E+02,
    512. 

  512. 																							'w'			=> 7.45701000000000E+02
    513. 

  513. 																						),
    514. 

  514. 																		'h'		=> array(	'HP'		=> 1.0,
    515. 

  515. 																							'h'			=> 1.0,
    516. 

  516. 																							'W'			=> 7.45701000000000E+02,
    517. 

  517. 																							'w'			=> 7.45701000000000E+02
    518. 

  518. 																						),
    519. 

  519. 																		'W'		=> array(	'HP'		=> 1.34102006031908E-03,
    520. 

  520. 																							'h'			=> 1.34102006031908E-03,
    521. 

  521. 																							'W'			=> 1.0,
    522. 

  522. 																							'w'			=> 1.0
    523. 

  523. 																						),
    524. 

  524. 																		'w'		=> array(	'HP'		=> 1.34102006031908E-03,
    525. 

  525. 																							'h'			=> 1.34102006031908E-03,
    526. 

  526. 																							'W'			=> 1.0,
    527. 

  527. 																							'w'			=> 1.0
    528. 

  528. 																						)
    529. 

  529. 																	),
    530. 

  530. 												'Magnetism'	=> array(	'T'		=> array(	'T'			=> 1.0,
    531. 

  531. 																							'ga'		=> 10000.0
    532. 

  532. 																						),
    533. 

  533. 																		'ga'	=> array(	'T'			=> 0.0001,
    534. 

  534. 																							'ga'		=> 1.0
    535. 

  535. 																						)
    536. 

  536. 																	),
    537. 

  537. 												'Liquid'	=> array(	'tsp'	=> array(	'tsp'		=> 1.0,
    538. 

  538. 																							'tbs'		=> 3.33333333333333E-01,
    539. 

  539. 																							'oz'		=> 1.66666666666667E-01,
    540. 

  540. 																							'cup'		=> 2.08333333333333E-02,
    541. 

  541. 																							'pt'		=> 1.04166666666667E-02,
    542. 

  542. 																							'us_pt'		=> 1.04166666666667E-02,
    543. 

  543. 																							'uk_pt'		=> 8.67558516821960E-03,
    544. 

  544. 																							'qt'		=> 5.20833333333333E-03,
    545. 

  545. 																							'gal'		=> 1.30208333333333E-03,
    546. 

  546. 																							'l'			=> 4.92999408400710E-03,
    547. 

  547. 																							'lt'		=> 4.92999408400710E-03
    548. 

  548. 																						),
    549. 

  549. 																		'tbs'	=> array(	'tsp'		=> 3.00000000000000E+00,
    550. 

  550. 																							'tbs'		=> 1.0,
    551. 

  551. 																							'oz'		=> 5.00000000000000E-01,
    552. 

  552. 																							'cup'		=> 6.25000000000000E-02,
    553. 

  553. 																							'pt'		=> 3.12500000000000E-02,
    554. 

  554. 																							'us_pt'		=> 3.12500000000000E-02,
    555. 

  555. 																							'uk_pt'		=> 2.60267555046588E-02,
    556. 

  556. 																							'qt'		=> 1.56250000000000E-02,
    557. 

  557. 																							'gal'		=> 3.90625000000000E-03,
    558. 

  558. 																							'l'			=> 1.47899822520213E-02,
    559. 

  559. 																							'lt'		=> 1.47899822520213E-02
    560. 

  560. 																						),
    561. 

  561. 																		'oz'	=> array(	'tsp'		=> 6.00000000000000E+00,
    562. 

  562. 																							'tbs'		=> 2.00000000000000E+00,
    563. 

  563. 																							'oz'		=> 1.0,
    564. 

  564. 																							'cup'		=> 1.25000000000000E-01,
    565. 

  565. 																							'pt'		=> 6.25000000000000E-02,
    566. 

  566. 																							'us_pt'		=> 6.25000000000000E-02,
    567. 

  567. 																							'uk_pt'		=> 5.20535110093176E-02,
    568. 

  568. 																							'qt'		=> 3.12500000000000E-02,
    569. 

  569. 																							'gal'		=> 7.81250000000000E-03,
    570. 

  570. 																							'l'			=> 2.95799645040426E-02,
    571. 

  571. 																							'lt'		=> 2.95799645040426E-02
    572. 

  572. 																						),
    573. 

  573. 																		'cup'	=> array(	'tsp'		=> 4.80000000000000E+01,
    574. 

  574. 																							'tbs'		=> 1.60000000000000E+01,
    575. 

  575. 																							'oz'		=> 8.00000000000000E+00,
    576. 

  576. 																							'cup'		=> 1.0,
    577. 

  577. 																							'pt'		=> 5.00000000000000E-01,
    578. 

  578. 																							'us_pt'		=> 5.00000000000000E-01,
    579. 

  579. 																							'uk_pt'		=> 4.16428088074541E-01,
    580. 

  580. 																							'qt'		=> 2.50000000000000E-01,
    581. 

  581. 																							'gal'		=> 6.25000000000000E-02,
    582. 

  582. 																							'l'			=> 2.36639716032341E-01,
    583. 

  583. 																							'lt'		=> 2.36639716032341E-01
    584. 

  584. 																						),
    585. 

  585. 																		'pt'	=> array(	'tsp'		=> 9.60000000000000E+01,
    586. 

  586. 																							'tbs'		=> 3.20000000000000E+01,
    587. 

  587. 																							'oz'		=> 1.60000000000000E+01,
    588. 

  588. 																							'cup'		=> 2.00000000000000E+00,
    589. 

  589. 																							'pt'		=> 1.0,
    590. 

  590. 																							'us_pt'		=> 1.0,
    591. 

  591. 																							'uk_pt'		=> 8.32856176149081E-01,
    592. 

  592. 																							'qt'		=> 5.00000000000000E-01,
    593. 

  593. 																							'gal'		=> 1.25000000000000E-01,
    594. 

  594. 																							'l'			=> 4.73279432064682E-01,
    595. 

  595. 																							'lt'		=> 4.73279432064682E-01
    596. 

  596. 																						),
    597. 

  597. 																		'us_pt'	=> array(	'tsp'		=> 9.60000000000000E+01,
    598. 

  598. 																							'tbs'		=> 3.20000000000000E+01,
    599. 

  599. 																							'oz'		=> 1.60000000000000E+01,
    600. 

  600. 																							'cup'		=> 2.00000000000000E+00,
    601. 

  601. 																							'pt'		=> 1.0,
    602. 

  602. 																							'us_pt'		=> 1.0,
    603. 

  603. 																							'uk_pt'		=> 8.32856176149081E-01,
    604. 

  604. 																							'qt'		=> 5.00000000000000E-01,
    605. 

  605. 																							'gal'		=> 1.25000000000000E-01,
    606. 

  606. 																							'l'			=> 4.73279432064682E-01,
    607. 

  607. 																							'lt'		=> 4.73279432064682E-01
    608. 

  608. 																						),
    609. 

  609. 																		'uk_pt'	=> array(	'tsp'		=> 1.15266000000000E+02,
    610. 

  610. 																							'tbs'		=> 3.84220000000000E+01,
    611. 

  611. 																							'oz'		=> 1.92110000000000E+01,
    612. 

  612. 																							'cup'		=> 2.40137500000000E+00,
    613. 

  613. 																							'pt'		=> 1.20068750000000E+00,
    614. 

  614. 																							'us_pt'		=> 1.20068750000000E+00,
    615. 

  615. 																							'uk_pt'		=> 1.0,
    616. 

  616. 																							'qt'		=> 6.00343750000000E-01,
    617. 

  617. 																							'gal'		=> 1.50085937500000E-01,
    618. 

  618. 																							'l'			=> 5.68260698087162E-01,
    619. 

  619. 																							'lt'		=> 5.68260698087162E-01
    620. 

  620. 																						),
    621. 

  621. 																		'qt'	=> array(	'tsp'		=> 1.92000000000000E+02,
    622. 

  622. 																							'tbs'		=> 6.40000000000000E+01,
    623. 

  623. 																							'oz'		=> 3.20000000000000E+01,
    624. 

  624. 																							'cup'		=> 4.00000000000000E+00,
    625. 

  625. 																							'pt'		=> 2.00000000000000E+00,
    626. 

  626. 																							'us_pt'		=> 2.00000000000000E+00,
    627. 

  627. 																							'uk_pt'		=> 1.66571235229816E+00,
    628. 

  628. 																							'qt'		=> 1.0,
    629. 

  629. 																							'gal'		=> 2.50000000000000E-01,
    630. 

  630. 																							'l'			=> 9.46558864129363E-01,
    631. 

  631. 																							'lt'		=> 9.46558864129363E-01
    632. 

  632. 																						),
    633. 

  633. 																		'gal'	=> array(	'tsp'		=> 7.68000000000000E+02,
    634. 

  634. 																							'tbs'		=> 2.56000000000000E+02,
    635. 

  635. 																							'oz'		=> 1.28000000000000E+02,
    636. 

  636. 																							'cup'		=> 1.60000000000000E+01,
    637. 

  637. 																							'pt'		=> 8.00000000000000E+00,
    638. 

  638. 																							'us_pt'		=> 8.00000000000000E+00,
    639. 

  639. 																							'uk_pt'		=> 6.66284940919265E+00,
    640. 

  640. 																							'qt'		=> 4.00000000000000E+00,
    641. 

  641. 																							'gal'		=> 1.0,
    642. 

  642. 																							'l'			=> 3.78623545651745E+00,
    643. 

  643. 																							'lt'		=> 3.78623545651745E+00
    644. 

  644. 																						),
    645. 

  645. 																		'l'		=> array(	'tsp'		=> 2.02840000000000E+02,
    646. 

  646. 																							'tbs'		=> 6.76133333333333E+01,
    647. 

  647. 																							'oz'		=> 3.38066666666667E+01,
    648. 

  648. 																							'cup'		=> 4.22583333333333E+00,
    649. 

  649. 																							'pt'		=> 2.11291666666667E+00,
    650. 

  650. 																							'us_pt'		=> 2.11291666666667E+00,
    651. 

  651. 																							'uk_pt'		=> 1.75975569552166E+00,
    652. 

  652. 																							'qt'		=> 1.05645833333333E+00,
    653. 

  653. 																							'gal'		=> 2.64114583333333E-01,
    654. 

  654. 																							'l'			=> 1.0,
    655. 

  655. 																							'lt'		=> 1.0
    656. 

  656. 																						),
    657. 

  657. 																		'lt'	=> array(	'tsp'		=> 2.02840000000000E+02,
    658. 

  658. 																							'tbs'		=> 6.76133333333333E+01,
    659. 

  659. 																							'oz'		=> 3.38066666666667E+01,
    660. 

  660. 																							'cup'		=> 4.22583333333333E+00,
    661. 

  661. 																							'pt'		=> 2.11291666666667E+00,
    662. 

  662. 																							'us_pt'		=> 2.11291666666667E+00,
    663. 

  663. 																							'uk_pt'		=> 1.75975569552166E+00,
    664. 

  664. 																							'qt'		=> 1.05645833333333E+00,
    665. 

  665. 																							'gal'		=> 2.64114583333333E-01,
    666. 

  666. 																							'l'			=> 1.0,
    667. 

  667. 																							'lt'		=> 1.0
    668. 

  668. 																						)
    669. 

  669. 																	)
    670. 

  670. 											);
    671. 

  671. 

  672. 

  673. 	public static function _parseComplex($complexNumber) {
    674. 

  674. 		$workString = (string) $complexNumber;
    675. 

  675. 

  676. 		$realNumber = $imaginary = 0;
    677. 

  677. 		//	Extract the suffix, if there is one
    678. 

  678. 		$suffix = substr($workString,-1);
    679. 

  679. 		if (!is_numeric($suffix)) {
    680. 

  680. 			$workString = substr($workString,0,-1);
    681. 

  681. 		} else {
    682. 

  682. 			$suffix = '';
    683. 

  683. 		}
    684. 

  684. 

  685. 		//	Split the input into its Real and Imaginary components
    686. 

  686. 		$leadingSign = 0;
    687. 

  687. 		if (strlen($workString) > 0) {
    688. 

  688. 			$leadingSign = (($workString{0} == '+') || ($workString{0} == '-')) ? 1 : 0;
    689. 

  689. 		}
    690. 

  690. 		$power = '';
    691. 

  691. 		$realNumber = strtok($workString, '+-');
    692. 

  692. 		if (strtoupper(substr($realNumber,-1)) == 'E') {
    693. 

  693. 			$power = strtok('+-');
    694. 

  694. 			++$leadingSign;
    695. 

  695. 		}
    696. 

  696. 

  697. 		$realNumber = substr($workString,0,strlen($realNumber)+strlen($power)+$leadingSign);
    698. 

  698. 

  699. 		if ($suffix != '') {
    700. 

  700. 			$imaginary = substr($workString,strlen($realNumber));
    701. 

  701. 

  702. 			if (($imaginary == '') && (($realNumber == '') || ($realNumber == '+') || ($realNumber == '-'))) {
    703. 

  703. 				$imaginary = $realNumber.'1';
    704. 

  704. 				$realNumber = '0';
    705. 

  705. 			} else if ($imaginary == '') {
    706. 

  706. 				$imaginary = $realNumber;
    707. 

  707. 				$realNumber = '0';
    708. 

  708. 			} elseif (($imaginary == '+') || ($imaginary == '-')) {
    709. 

  709. 				$imaginary .= '1';
    710. 

  710. 			}
    711. 

  711. 		}
    712. 

  712. 

  713. 		return array( 'real'		=> $realNumber,
    714. 

  714. 					  'imaginary'	=> $imaginary,
    715. 

  715. 					  'suffix'		=> $suffix
    716. 

  716. 					);
    717. 

  717. 	}	//	function _parseComplex()
    718. 

  718. 

  719. 

  720. 	private static function _cleanComplex($complexNumber) {
    721. 

  721. 		if ($complexNumber{0} == '+') $complexNumber = substr($complexNumber,1);
    722. 

  722. 		if ($complexNumber{0} == '0') $complexNumber = substr($complexNumber,1);
    723. 

  723. 		if ($complexNumber{0} == '.') $complexNumber = '0'.$complexNumber;
    724. 

  724. 		if ($complexNumber{0} == '+') $complexNumber = substr($complexNumber,1);
    725. 

  725. 		return $complexNumber;
    726. 

  726. 	}
    727. 

  727. 

  728. 

  729. 	private static function _nbrConversionFormat($xVal,$places) {
    730. 

  730. 		if (!is_null($places)) {
    731. 

  731. 			if (strlen($xVal) <= $places) {
    732. 

  732. 				return substr(str_pad($xVal,$places,'0',STR_PAD_LEFT),-10);
    733. 

  733. 			} else {
    734. 

  734. 				return PHPExcel_Calculation_Functions::NaN();
    735. 

  735. 			}
    736. 

  736. 		}
    737. 

  737. 

  738. 		return substr($xVal,-10);
    739. 

  739. 	}	//	function _nbrConversionFormat()
    740. 

  740. 

  741. 

  742. 	/**
    743. 

  743. 	 * BESSELI
    744. 

  744. 	 *
    745. 

  745. 	 * Returns the modified Bessel function, which is equivalent to the Bessel function evaluated for purely imaginary arguments
    746. 

  746. 	 *
    747. 

  747. 	 * @param	float		$x
    748. 

  748. 	 * @param	float		$n
    749. 

  749. 	 * @return	int
    750. 

  750. 	 */
    751. 

  751. 	public static function BESSELI($x, $n) {
    752. 

  752. 		$x	= (is_null($x))	? 0.0 :	PHPExcel_Calculation_Functions::flattenSingleValue($x);
    753. 

  753. 		$n	= (is_null($n))	? 0.0 :	PHPExcel_Calculation_Functions::flattenSingleValue($n);
    754. 

  754. 

  755. 		if ((is_numeric($x)) && (is_numeric($n))) {
    756. 

  756. 			$n	= floor($n);
    757. 

  757. 			if ($n < 0) {
    758. 

  758. 				return PHPExcel_Calculation_Functions::NaN();
    759. 

  759. 			}
    760. 

  760. 			$f_2_PI = 2 * M_PI;
    761. 

  761. 

  762. 			if (abs($x) <= 30) {
    763. 

  763. 				$fTerm = pow($x / 2, $n) / PHPExcel_Calculation_MathTrig::FACT($n);
    764. 

  764. 				$nK = 1;
    765. 

  765. 				$fResult = $fTerm;
    766. 

  766. 				$fSqrX = ($x * $x) / 4;
    767. 

  767. 				do {
    768. 

  768. 					$fTerm *= $fSqrX;
    769. 

  769. 					$fTerm /= ($nK * ($nK + $n));
    770. 

  770. 					$fResult += $fTerm;
    771. 

  771. 				} while ((abs($fTerm) > 1e-10) && (++$nK < 100));
    772. 

  772. 			} else {
    773. 

  773. 				$fXAbs = abs($x);
    774. 

  774. 				$fResult = exp($fXAbs) / sqrt($f_2_PI * $fXAbs);
    775. 

  775. 				if (($n && 1) && ($x < 0)) {
    776. 

  776. 					$fResult = -$fResult;
    777. 

  777. 				}
    778. 

  778. 			}
    779. 

  779. 			return $fResult;
    780. 

  780. 		}
    781. 

  781. 		return PHPExcel_Calculation_Functions::VALUE();
    782. 

  782. 	}	//	function BESSELI()
    783. 

  783. 

  784. 

  785. 	/**
    786. 

  786. 	 * BESSELJ
    787. 

  787. 	 *
    788. 

  788. 	 * Returns the Bessel function
    789. 

  789. 	 *
    790. 

  790. 	 * @param	float		$x
    791. 

  791. 	 * @param	float		$n
    792. 

  792. 	 * @return	int
    793. 

  793. 	 */
    794. 

  794. 	public static function BESSELJ($x, $n) {
    795. 

  795. 		$x	= (is_null($x))	? 0.0 :	PHPExcel_Calculation_Functions::flattenSingleValue($x);
    796. 

  796. 		$n	= (is_null($n))	? 0.0 :	PHPExcel_Calculation_Functions::flattenSingleValue($n);
    797. 

  797. 

  798. 		if ((is_numeric($x)) && (is_numeric($n))) {
    799. 

  799. 			$n	= floor($n);
    800. 

  800. 			if ($n < 0) {
    801. 

  801. 				return PHPExcel_Calculation_Functions::NaN();
    802. 

  802. 			}
    803. 

  803. 			$f_PI_DIV_2 = M_PI / 2;
    804. 

  804. 			$f_PI_DIV_4 = M_PI / 4;
    805. 

  805. 

  806. 			$fResult = 0;
    807. 

  807. 			if (abs($x) <= 30) {
    808. 

  808. 				$fTerm = pow($x / 2, $n) / PHPExcel_Calculation_MathTrig::FACT($n);
    809. 

  809. 				$nK = 1;
    810. 

  810. 				$fResult = $fTerm;
    811. 

  811. 				$fSqrX = ($x * $x) / -4;
    812. 

  812. 				do {
    813. 

  813. 					$fTerm *= $fSqrX;
    814. 

  814. 					$fTerm /= ($nK * ($nK + $n));
    815. 

  815. 					$fResult += $fTerm;
    816. 

  816. 				} while ((abs($fTerm) > 1e-10) && (++$nK < 100));
    817. 

  817. 			} else {
    818. 

  818. 				$fXAbs = abs($x);
    819. 

  819. 				$fResult = sqrt(M_2DIVPI / $fXAbs) * cos($fXAbs - $n * $f_PI_DIV_2 - $f_PI_DIV_4);
    820. 

  820. 				if (($n && 1) && ($x < 0)) {
    821. 

  821. 					$fResult = -$fResult;
    822. 

  822. 				}
    823. 

  823. 			}
    824. 

  824. 			return $fResult;
    825. 

  825. 		}
    826. 

  826. 		return PHPExcel_Calculation_Functions::VALUE();
    827. 

  827. 	}	//	function BESSELJ()
    828. 

  828. 

  829. 

  830. 	private static function _Besselk0($fNum) {
    831. 

  831. 		if ($fNum <= 2) {
    832. 

  832. 			$fNum2 = $fNum * 0.5;
    833. 

  833. 			$y = ($fNum2 * $fNum2);
    834. 

  834. 			$fRet = -log($fNum2) * self::BESSELI($fNum, 0) +
    835. 

  835. 					(-0.57721566 + $y * (0.42278420 + $y * (0.23069756 + $y * (0.3488590e-1 + $y * (0.262698e-2 + $y *
    836. 

  836. 					(0.10750e-3 + $y * 0.74e-5))))));
    837. 

  837. 		} else {
    838. 

  838. 			$y = 2 / $fNum;
    839. 

  839. 			$fRet = exp(-$fNum) / sqrt($fNum) *
    840. 

  840. 					(1.25331414 + $y * (-0.7832358e-1 + $y * (0.2189568e-1 + $y * (-0.1062446e-1 + $y *
    841. 

  841. 					(0.587872e-2 + $y * (-0.251540e-2 + $y * 0.53208e-3))))));
    842. 

  842. 		}
    843. 

  843. 		return $fRet;
    844. 

  844. 	}	//	function _Besselk0()
    845. 

  845. 

  846. 

  847. 	private static function _Besselk1($fNum) {
    848. 

  848. 		if ($fNum <= 2) {
    849. 

  849. 			$fNum2 = $fNum * 0.5;
    850. 

  850. 			$y = ($fNum2 * $fNum2);
    851. 

  851. 			$fRet = log($fNum2) * self::BESSELI($fNum, 1) +
    852. 

  852. 					(1 + $y * (0.15443144 + $y * (-0.67278579 + $y * (-0.18156897 + $y * (-0.1919402e-1 + $y *
    853. 

  853. 					(-0.110404e-2 + $y * (-0.4686e-4))))))) / $fNum;
    854. 

  854. 		} else {
    855. 

  855. 			$y = 2 / $fNum;
    856. 

  856. 			$fRet = exp(-$fNum) / sqrt($fNum) *
    857. 

  857. 					(1.25331414 + $y * (0.23498619 + $y * (-0.3655620e-1 + $y * (0.1504268e-1 + $y * (-0.780353e-2 + $y *
    858. 

  858. 					(0.325614e-2 + $y * (-0.68245e-3)))))));
    859. 

  859. 		}
    860. 

  860. 		return $fRet;
    861. 

  861. 	}	//	function _Besselk1()
    862. 

  862. 

  863. 

  864. 	/**
    865. 

  865. 	 * BESSELK
    866. 

  866. 	 *
    867. 

  867. 	 * Returns the modified Bessel function, which is equivalent to the Bessel functions evaluated for purely imaginary arguments.
    868. 

  868. 	 *
    869. 

  869. 	 * @param	float		$x
    870. 

  870. 	 * @param	float		$ord
    871. 

  871. 	 * @return	float
    872. 

  872. 	 */
    873. 

  873. 	public static function BESSELK($x, $ord) {
    874. 

  874. 		$x		= (is_null($x))		? 0.0 :	PHPExcel_Calculation_Functions::flattenSingleValue($x);
    875. 

  875. 		$ord	= (is_null($ord))	? 0.0 :	PHPExcel_Calculation_Functions::flattenSingleValue($ord);
    876. 

  876. 

  877. 		if ((is_numeric($x)) && (is_numeric($ord))) {
    878. 

  878. 			if (($ord < 0) || ($x == 0.0)) {
    879. 

  879. 				return PHPExcel_Calculation_Functions::NaN();
    880. 

  880. 			}
    881. 

  881. 

  882. 			switch(floor($ord)) {
    883. 

  883. 				case 0 :	return self::_Besselk0($x);
    884. 

  884. 							break;
    885. 

  885. 				case 1 :	return self::_Besselk1($x);
    886. 

  886. 							break;
    887. 

  887. 				default :	$fTox	= 2 / $x;
    888. 

  888. 							$fBkm	= self::_Besselk0($x);
    889. 

  889. 							$fBk	= self::_Besselk1($x);
    890. 

  890. 							for ($n = 1; $n < $ord; ++$n) {
    891. 

  891. 								$fBkp	= $fBkm + $n * $fTox * $fBk;
    892. 

  892. 								$fBkm	= $fBk;
    893. 

  893. 								$fBk	= $fBkp;
    894. 

  894. 							}
    895. 

  895. 			}
    896. 

  896. 			return $fBk;
    897. 

  897. 		}
    898. 

  898. 		return PHPExcel_Calculation_Functions::VALUE();
    899. 

  899. 	}	//	function BESSELK()
    900. 

  900. 

  901. 

  902. 	private static function _Bessely0($fNum) {
    903. 

  903. 		if ($fNum < 8.0) {
    904. 

  904. 			$y = ($fNum * $fNum);
    905. 

  905. 			$f1 = -2957821389.0 + $y * (7062834065.0 + $y * (-512359803.6 + $y * (10879881.29 + $y * (-86327.92757 + $y * 228.4622733))));
    906. 

  906. 			$f2 = 40076544269.0 + $y * (745249964.8 + $y * (7189466.438 + $y * (47447.26470 + $y * (226.1030244 + $y))));
    907. 

  907. 			$fRet = $f1 / $f2 + M_2DIVPI * self::BESSELJ($fNum, 0) * log($fNum);
    908. 

  908. 		} else {
    909. 

  909. 			$z = 8.0 / $fNum;
    910. 

  910. 			$y = ($z * $z);
    911. 

  911. 			$xx = $fNum - 0.785398164;
    912. 

  912. 			$f1 = 1 + $y * (-0.1098628627e-2 + $y * (0.2734510407e-4 + $y * (-0.2073370639e-5 + $y * 0.2093887211e-6)));
    913. 

  913. 			$f2 = -0.1562499995e-1 + $y * (0.1430488765e-3 + $y * (-0.6911147651e-5 + $y * (0.7621095161e-6 + $y * (-0.934945152e-7))));
    914. 

  914. 			$fRet = sqrt(M_2DIVPI / $fNum) * (sin($xx) * $f1 + $z * cos($xx) * $f2);
    915. 

  915. 		}
    916. 

  916. 		return $fRet;
    917. 

  917. 	}	//	function _Bessely0()
    918. 

  918. 

  919. 

  920. 	private static function _Bessely1($fNum) {
    921. 

  921. 		if ($fNum < 8.0) {
    922. 

  922. 			$y = ($fNum * $fNum);
    923. 

  923. 			$f1 = $fNum * (-0.4900604943e13 + $y * (0.1275274390e13 + $y * (-0.5153438139e11 + $y * (0.7349264551e9 + $y *
    924. 

  924. 				(-0.4237922726e7 + $y * 0.8511937935e4)))));
    925. 

  925. 			$f2 = 0.2499580570e14 + $y * (0.4244419664e12 + $y * (0.3733650367e10 + $y * (0.2245904002e8 + $y *
    926. 

  926. 				(0.1020426050e6 + $y * (0.3549632885e3 + $y)))));
    927. 

  927. 			$fRet = $f1 / $f2 + M_2DIVPI * ( self::BESSELJ($fNum, 1) * log($fNum) - 1 / $fNum);
    928. 

  928. 		} else {
    929. 

  929. 			$z = 8.0 / $fNum;
    930. 

  930. 			$y = ($z * $z);
    931. 

  931. 			$xx = $fNum - 2.356194491;
    932. 

  932. 			$f1 = 1 + $y * (0.183105e-2 + $y * (-0.3516396496e-4 + $y * (0.2457520174e-5 + $y * (-0.240337019e6))));
    933. 

  933. 			$f2 = 0.04687499995 + $y * (-0.2002690873e-3 + $y * (0.8449199096e-5 + $y * (-0.88228987e-6 + $y * 0.105787412e-6)));
    934. 

  934. 			$fRet = sqrt(M_2DIVPI / $fNum) * (sin($xx) * $f1 + $z * cos($xx) * $f2);
    935. 

  935. 			#i12430# ...but this seems to work much better.
    936. 

  936. //			$fRet = sqrt(M_2DIVPI / $fNum) * sin($fNum - 2.356194491);
    937. 

  937. 		}
    938. 

  938. 		return $fRet;
    939. 

  939. 	}	//	function _Bessely1()
    940. 

  940. 

  941. 

  942. 	/**
    943. 

  943. 	 * BESSELY
    944. 

  944. 	 *
    945. 

  945. 	 * Returns the Bessel function, which is also called the Weber function or the Neumann function.
    946. 

  946. 	 *
    947. 

  947. 	 * @param	float		$x
    948. 

  948. 	 * @param	float		$n
    949. 

  949. 	 * @return	int
    950. 

  950. 	 */
    951. 

  951. 	public static function BESSELY($x, $ord) {
    952. 

  952. 		$x		= (is_null($x))		? 0.0 :	PHPExcel_Calculation_Functions::flattenSingleValue($x);
    953. 

  953. 		$ord	= (is_null($ord))	? 0.0 :	PHPExcel_Calculation_Functions::flattenSingleValue($ord);
    954. 

  954. 

  955. 		if ((is_numeric($x)) && (is_numeric($ord))) {
    956. 

  956. 			if (($ord < 0) || ($x == 0.0)) {
    957. 

  957. 				return PHPExcel_Calculation_Functions::NaN();
    958. 

  958. 			}
    959. 

  959. 

  960. 			switch(floor($ord)) {
    961. 

  961. 				case 0 :	return self::_Bessely0($x);
    962. 

  962. 							break;
    963. 

  963. 				case 1 :	return self::_Bessely1($x);
    964. 

  964. 							break;
    965. 

  965. 				default:	$fTox	= 2 / $x;
    966. 

  966. 							$fBym	= self::_Bessely0($x);
    967. 

  967. 							$fBy	= self::_Bessely1($x);
    968. 

  968. 							for ($n = 1; $n < $ord; ++$n) {
    969. 

  969. 								$fByp	= $n * $fTox * $fBy - $fBym;
    970. 

  970. 								$fBym	= $fBy;
    971. 

  971. 								$fBy	= $fByp;
    972. 

  972. 							}
    973. 

  973. 			}
    974. 

  974. 			return $fBy;
    975. 

  975. 		}
    976. 

  976. 		return PHPExcel_Calculation_Functions::VALUE();
    977. 

  977. 	}	//	function BESSELY()
    978. 

  978. 

  979. 

  980. 	/**
    981. 

  981. 	 * BINTODEC
    982. 

  982. 	 *
    983. 

  983. 	 * Return a binary value as Decimal.
    984. 

  984. 	 *
    985. 

  985. 	 * @param	string		$x
    986. 

  986. 	 * @return	string
    987. 

  987. 	 */
    988. 

  988. 	public static function BINTODEC($x) {
    989. 

  989. 		$x	= PHPExcel_Calculation_Functions::flattenSingleValue($x);
    990. 

  990. 

  991. 		if (is_bool($x)) {
    992. 

  992. 			if (PHPExcel_Calculation_Functions::getCompatibilityMode() == PHPExcel_Calculation_Functions::COMPATIBILITY_OPENOFFICE) {
    993. 

  993. 				$x = (int) $x;
    994. 

  994. 			} else {
    995. 

  995. 				return PHPExcel_Calculation_Functions::VALUE();
    996. 

  996. 			}
    997. 

  997. 		}
    998. 

  998. 		if (PHPExcel_Calculation_Functions::getCompatibilityMode() == PHPExcel_Calculation_Functions::COMPATIBILITY_GNUMERIC) {
    999. 

  999. 			$x = floor($x);
    1000. 

  1000. 		}
    1001. 

  1001. 		$x = (string) $x;
    1002. 

  1002. 		if (strlen($x) > preg_match_all('/[01]/',$x,$out)) {
    1003. 

  1003. 			return PHPExcel_Calculation_Functions::NaN();
    1004. 

  1004. 		}
    1005. 

  1005. 		if (strlen($x) > 10) {
    1006. 

  1006. 			return PHPExcel_Calculation_Functions::NaN();
    1007. 

  1007. 		} elseif (strlen($x) == 10) {
    1008. 

  1008. 			//	Two's Complement
    1009. 

  1009. 			$x = substr($x,-9);
    1010. 

  1010. 			return '-'.(512-bindec($x));
    1011. 

  1011. 		}
    1012. 

  1012. 		return bindec($x);
    1013. 

  1013. 	}	//	function BINTODEC()
    1014. 

  1014. 

  1015. 

  1016. 	/**
    1017. 

  1017. 	 * BINTOHEX
    1018. 

  1018. 	 *
    1019. 

  1019. 	 * Return a binary value as Hex.
    1020. 

  1020. 	 *
    1021. 

  1021. 	 * @param	string		$x
    1022. 

  1022. 	 * @return	string
    1023. 

  1023. 	 */
    1024. 

  1024. 	public static function BINTOHEX($x, $places=null) {
    1025. 

  1025. 		$x	= floor(PHPExcel_Calculation_Functions::flattenSingleValue($x));
    1026. 

  1026. 		$places	= PHPExcel_Calculation_Functions::flattenSingleValue($places);
    1027. 

  1027. 

  1028. 		if (is_bool($x)) {
    1029. 

  1029. 			if (PHPExcel_Calculation_Functions::getCompatibilityMode() == PHPExcel_Calculation_Functions::COMPATIBILITY_OPENOFFICE) {
    1030. 

  1030. 				$x = (int) $x;
    1031. 

  1031. 			} else {
    1032. 

  1032. 				return PHPExcel_Calculation_Functions::VALUE();
    1033. 

  1033. 			}
    1034. 

  1034. 		}
    1035. 

  1035. 		if (PHPExcel_Calculation_Functions::getCompatibilityMode() == PHPExcel_Calculation_Functions::COMPATIBILITY_GNUMERIC) {
    1036. 

  1036. 			$x = floor($x);
    1037. 

  1037. 		}
    1038. 

  1038. 		$x = (string) $x;
    1039. 

  1039. 		if (strlen($x) > preg_match_all('/[01]/',$x,$out)) {
    1040. 

  1040. 			return PHPExcel_Calculation_Functions::NaN();
    1041. 

  1041. 		}
    1042. 

  1042. 		if (strlen($x) > 10) {
    1043. 

  1043. 			return PHPExcel_Calculation_Functions::NaN();
    1044. 

  1044. 		} elseif (strlen($x) == 10) {
    1045. 

  1045. 			//	Two's Complement
    1046. 

  1046. 			return str_repeat('F',8).substr(strtoupper(dechex(bindec(substr($x,-9)))),-2);
    1047. 

  1047. 		}
    1048. 

  1048. 		$hexVal = (string) strtoupper(dechex(bindec($x)));
    1049. 

  1049. 

  1050. 		return self::_nbrConversionFormat($hexVal,$places);
    1051. 

  1051. 	}	//	function BINTOHEX()
    1052. 

  1052. 

  1053. 

  1054. 	/**
    1055. 

  1055. 	 * BINTOOCT
    1056. 

  1056. 	 *
    1057. 

  1057. 	 * Return a binary value as Octal.
    1058. 

  1058. 	 *
    1059. 

  1059. 	 * @param	string		$x
    1060. 

  1060. 	 * @return	string
    1061. 

  1061. 	 */
    1062. 

  1062. 	public static function BINTOOCT($x, $places=null) {
    1063. 

  1063. 		$x	= floor(PHPExcel_Calculation_Functions::flattenSingleValue($x));
    1064. 

  1064. 		$places	= PHPExcel_Calculation_Functions::flattenSingleValue($places);
    1065. 

  1065. 

  1066. 		if (is_bool($x)) {
    1067. 

  1067. 			if (PHPExcel_Calculation_Functions::getCompatibilityMode() == PHPExcel_Calculation_Functions::COMPATIBILITY_OPENOFFICE) {
    1068. 

  1068. 				$x = (int) $x;
    1069. 

  1069. 			} else {
    1070. 

  1070. 				return PHPExcel_Calculation_Functions::VALUE();
    1071. 

  1071. 			}
    1072. 

  1072. 		}
    1073. 

  1073. 		if (PHPExcel_Calculation_Functions::getCompatibilityMode() == PHPExcel_Calculation_Functions::COMPATIBILITY_GNUMERIC) {
    1074. 

  1074. 			$x = floor($x);
    1075. 

  1075. 		}
    1076. 

  1076. 		$x = (string) $x;
    1077. 

  1077. 		if (strlen($x) > preg_match_all('/[01]/',$x,$out)) {
    1078. 

  1078. 			return PHPExcel_Calculation_Functions::NaN();
    1079. 

  1079. 		}
    1080. 

  1080. 		if (strlen($x) > 10) {
    1081. 

  1081. 			return PHPExcel_Calculation_Functions::NaN();
    1082. 

  1082. 		} elseif (strlen($x) == 10) {
    1083. 

  1083. 			//	Two's Complement
    1084. 

  1084. 			return str_repeat('7',7).substr(strtoupper(decoct(bindec(substr($x,-9)))),-3);
    1085. 

  1085. 		}
    1086. 

  1086. 		$octVal = (string) decoct(bindec($x));
    1087. 

  1087. 

  1088. 		return self::_nbrConversionFormat($octVal,$places);
    1089. 

  1089. 	}	//	function BINTOOCT()
    1090. 

  1090. 

  1091. 

  1092. 	/**
    1093. 

  1093. 	 * DECTOBIN
    1094. 

  1094. 	 *
    1095. 

  1095. 	 * Return an octal value as binary.
    1096. 

  1096. 	 *
    1097. 

  1097. 	 * @param	string		$x
    1098. 

  1098. 	 * @return	string
    1099. 

  1099. 	 */
    1100. 

  1100. 	public static function DECTOBIN($x, $places=null) {
    1101. 

  1101. 		$x	= PHPExcel_Calculation_Functions::flattenSingleValue($x);
    1102. 

  1102. 		$places	= PHPExcel_Calculation_Functions::flattenSingleValue($places);
    1103. 

  1103. 

  1104. 		if (is_bool($x)) {
    1105. 

  1105. 			if (PHPExcel_Calculation_Functions::getCompatibilityMode() == PHPExcel_Calculation_Functions::COMPATIBILITY_OPENOFFICE) {
    1106. 

  1106. 				$x = (int) $x;
    1107. 

  1107. 			} else {
    1108. 

  1108. 				return PHPExcel_Calculation_Functions::VALUE();
    1109. 

  1109. 			}
    1110. 

  1110. 		}
    1111. 

  1111. 		$x = (string) $x;
    1112. 

  1112. 		if (strlen($x) > preg_match_all('/[-0123456789.]/',$x,$out)) {
    1113. 

  1113. 			return PHPExcel_Calculation_Functions::VALUE();
    1114. 

  1114. 		}
    1115. 

  1115. 		$x = (string) floor($x);
    1116. 

  1116. 		$r = decbin($x);
    1117. 

  1117. 		if (strlen($r) == 32) {
    1118. 

  1118. 			//	Two's Complement
    1119. 

  1119. 			$r = substr($r,-10);
    1120. 

  1120. 		} elseif (strlen($r) > 11) {
    1121. 

  1121. 			return PHPExcel_Calculation_Functions::NaN();
    1122. 

  1122. 		}
    1123. 

  1123. 

  1124. 		return self::_nbrConversionFormat($r,$places);
    1125. 

  1125. 	}	//	function DECTOBIN()
    1126. 

  1126. 

  1127. 

  1128. 	/**
    1129. 

  1129. 	 * DECTOHEX
    1130. 

  1130. 	 *
    1131. 

  1131. 	 * Return an octal value as binary.
    1132. 

  1132. 	 *
    1133. 

  1133. 	 * @param	string		$x
    1134. 

  1134. 	 * @return	string
    1135. 

  1135. 	 */
    1136. 

  1136. 	public static function DECTOHEX($x, $places=null) {
    1137. 

  1137. 		$x	= PHPExcel_Calculation_Functions::flattenSingleValue($x);
    1138. 

  1138. 		$places	= PHPExcel_Calculation_Functions::flattenSingleValue($places);
    1139. 

  1139. 

  1140. 		if (is_bool($x)) {
    1141. 

  1141. 			if (PHPExcel_Calculation_Functions::getCompatibilityMode() == PHPExcel_Calculation_Functions::COMPATIBILITY_OPENOF…
    1142.

Large files files are truncated, but you can click here to view the full file