PageRenderTime 61ms CodeModel.GetById 16ms RepoModel.GetById 1ms app.codeStats 0ms

/libraries/PHPExcel/PHPExcel/Calculation/Engineering.php

https://bitbucket.org/thomashii/vtigercrm-6-for-postgresql
PHP | 2509 lines | 1505 code | 212 blank | 792 comment | 320 complexity | 858d083f65fc584cb91bfb0087335e9a MD5 | raw file
Possible License(s): Apache-2.0, LGPL-3.0, LGPL-2.1, GPL-2.0, GPL-3.0 
    

  1. <?php
    2. 

  2. /**
    3. 

  3.  * PHPExcel
    4. 

  4.  *
    5. 

  5.  * Copyright (c) 2006 - 2012 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 - 2012 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.7, 2012-05-19
    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 - 2012 PHPExcel (http://www.codeplex.com/PHPExcel)
    49. 

  49.  */
    50. 

  50. class PHPExcel_Calculation_Engineering {
    51. 

  51. 

  52. 	/**
    53. 

  53. 	 * Details of the Units of measure that can be used in CONVERTUOM()
    54. 

  54. 	 *
    55. 

  55. 	 * @var mixed[]
    56. 

  56. 	 */
    57. 

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

  95. 											  'BTU'		=> array(	'Group'	=> 'Energy',		'Unit Name'	=> 'BTU',						'AllowPrefix'	=> False	),
    96. 

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

  120. 											);
    121. 

  121. 

  122. 	/**
    123. 

  123. 	 * Details of the Multiplier prefixes that can be used with Units of Measure in CONVERTUOM()
    124. 

  124. 	 *
    125. 

  125. 	 * @var mixed[]
    126. 

  126. 	 */
    127. 

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

  128. 													'Z'	=> array(	'multiplier'	=> 1E21,	'name'	=> 'zetta'	),
    129. 

  129. 													'E'	=> array(	'multiplier'	=> 1E18,	'name'	=> 'exa'	),
    130. 

  130. 													'P'	=> array(	'multiplier'	=> 1E15,	'name'	=> 'peta'	),
    131. 

  131. 													'T'	=> array(	'multiplier'	=> 1E12,	'name'	=> 'tera'	),
    132. 

  132. 													'G'	=> array(	'multiplier'	=> 1E9,		'name'	=> 'giga'	),
    133. 

  133. 													'M'	=> array(	'multiplier'	=> 1E6,		'name'	=> 'mega'	),
    134. 

  134. 													'k'	=> array(	'multiplier'	=> 1E3,		'name'	=> 'kilo'	),
    135. 

  135. 													'h'	=> array(	'multiplier'	=> 1E2,		'name'	=> 'hecto'	),
    136. 

  136. 													'e'	=> array(	'multiplier'	=> 1E1,		'name'	=> 'deka'	),
    137. 

  137. 													'd'	=> array(	'multiplier'	=> 1E-1,	'name'	=> 'deci'	),
    138. 

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

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

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

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

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

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

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

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

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

  147. 												 );
    148. 

  148. 

  149. 	/**
    150. 

  150. 	 * Details of the Units of measure conversion factors, organised by group
    151. 

  151. 	 *
    152. 

  152. 	 * @var mixed[]
    153. 

  153. 	 */
    154. 

  154. 	private static $_unitConversions = array(	'Mass'		=> array(	'g'		=> array(	'g'		=> 1.0,
    155. 

  155. 																							'sg'	=> 6.85220500053478E-05,
    156. 

  156. 																							'lbm'	=> 2.20462291469134E-03,
    157. 

  157. 																							'u'		=> 6.02217000000000E+23,
    158. 

  158. 																							'ozm'	=> 3.52739718003627E-02
    159. 

  159. 																						),
    160. 

  160. 																		'sg'	=> array(	'g'		=> 1.45938424189287E+04,
    161. 

  161. 																							'sg'	=> 1.0,
    162. 

  162. 																							'lbm'	=> 3.21739194101647E+01,
    163. 

  163. 																							'u'		=> 8.78866000000000E+27,
    164. 

  164. 																							'ozm'	=> 5.14782785944229E+02
    165. 

  165. 																						),
    166. 

  166. 																		'lbm'	=> array(	'g'		=> 4.5359230974881148E+02,
    167. 

  167. 																							'sg'	=> 3.10810749306493E-02,
    168. 

  168. 																							'lbm'	=> 1.0,
    169. 

  169. 																							'u'		=> 2.73161000000000E+26,
    170. 

  170. 																							'ozm'	=> 1.60000023429410E+01
    171. 

  171. 																						),
    172. 

  172. 																		'u'		=> array(	'g'		=> 1.66053100460465E-24,
    173. 

  173. 																							'sg'	=> 1.13782988532950E-28,
    174. 

  174. 																							'lbm'	=> 3.66084470330684E-27,
    175. 

  175. 																							'u'		=> 1.0,
    176. 

  176. 																							'ozm'	=> 5.85735238300524E-26
    177. 

  177. 																						),
    178. 

  178. 																		'ozm'	=> array(	'g'		=> 2.83495152079732E+01,
    179. 

  179. 																							'sg'	=> 1.94256689870811E-03,
    180. 

  180. 																							'lbm'	=> 6.24999908478882E-02,
    181. 

  181. 																							'u'		=> 1.70725600000000E+25,
    182. 

  182. 																							'ozm'	=> 1.0
    183. 

  183. 																						)
    184. 

  184. 																	),
    185. 

  185. 												'Distance'	=> array(	'm'		=> array(	'm'		=> 1.0,
    186. 

  186. 																							'mi'	=> 6.21371192237334E-04,
    187. 

  187. 																							'Nmi'	=> 5.39956803455724E-04,
    188. 

  188. 																							'in'	=> 3.93700787401575E+01,
    189. 

  189. 																							'ft'	=> 3.28083989501312E+00,
    190. 

  190. 																							'yd'	=> 1.09361329797891E+00,
    191. 

  191. 																							'ang'	=> 1.00000000000000E+10,
    192. 

  192. 																							'Pica'	=> 2.83464566929116E+03
    193. 

  193. 																						),
    194. 

  194. 																		'mi'	=> array(	'm'		=> 1.60934400000000E+03,
    195. 

  195. 																							'mi'	=> 1.0,
    196. 

  196. 																							'Nmi'	=> 8.68976241900648E-01,
    197. 

  197. 																							'in'	=> 6.33600000000000E+04,
    198. 

  198. 																							'ft'	=> 5.28000000000000E+03,
    199. 

  199. 																							'yd'	=> 1.76000000000000E+03,
    200. 

  200. 																							'ang'	=> 1.60934400000000E+13,
    201. 

  201. 																							'Pica'	=> 4.56191999999971E+06
    202. 

  202. 																						),
    203. 

  203. 																		'Nmi'	=> array(	'm'		=> 1.85200000000000E+03,
    204. 

  204. 																							'mi'	=> 1.15077944802354E+00,
    205. 

  205. 																							'Nmi'	=> 1.0,
    206. 

  206. 																							'in'	=> 7.29133858267717E+04,
    207. 

  207. 																							'ft'	=> 6.07611548556430E+03,
    208. 

  208. 																							'yd'	=> 2.02537182785694E+03,
    209. 

  209. 																							'ang'	=> 1.85200000000000E+13,
    210. 

  210. 																							'Pica'	=> 5.24976377952723E+06
    211. 

  211. 																						),
    212. 

  212. 																		'in'	=> array(	'm'		=> 2.54000000000000E-02,
    213. 

  213. 																							'mi'	=> 1.57828282828283E-05,
    214. 

  214. 																							'Nmi'	=> 1.37149028077754E-05,
    215. 

  215. 																							'in'	=> 1.0,
    216. 

  216. 																							'ft'	=> 8.33333333333333E-02,
    217. 

  217. 																							'yd'	=> 2.77777777686643E-02,
    218. 

  218. 																							'ang'	=> 2.54000000000000E+08,
    219. 

  219. 																							'Pica'	=> 7.19999999999955E+01
    220. 

  220. 																						),
    221. 

  221. 																		'ft'	=> array(	'm'		=> 3.04800000000000E-01,
    222. 

  222. 																							'mi'	=> 1.89393939393939E-04,
    223. 

  223. 																							'Nmi'	=> 1.64578833693305E-04,
    224. 

  224. 																							'in'	=> 1.20000000000000E+01,
    225. 

  225. 																							'ft'	=> 1.0,
    226. 

  226. 																							'yd'	=> 3.33333333223972E-01,
    227. 

  227. 																							'ang'	=> 3.04800000000000E+09,
    228. 

  228. 																							'Pica'	=> 8.63999999999946E+02
    229. 

  229. 																						),
    230. 

  230. 																		'yd'	=> array(	'm'		=> 9.14400000300000E-01,
    231. 

  231. 																							'mi'	=> 5.68181818368230E-04,
    232. 

  232. 																							'Nmi'	=> 4.93736501241901E-04,
    233. 

  233. 																							'in'	=> 3.60000000118110E+01,
    234. 

  234. 																							'ft'	=> 3.00000000000000E+00,
    235. 

  235. 																							'yd'	=> 1.0,
    236. 

  236. 																							'ang'	=> 9.14400000300000E+09,
    237. 

  237. 																							'Pica'	=> 2.59200000085023E+03
    238. 

  238. 																						),
    239. 

  239. 																		'ang'	=> array(	'm'		=> 1.00000000000000E-10,
    240. 

  240. 																							'mi'	=> 6.21371192237334E-14,
    241. 

  241. 																							'Nmi'	=> 5.39956803455724E-14,
    242. 

  242. 																							'in'	=> 3.93700787401575E-09,
    243. 

  243. 																							'ft'	=> 3.28083989501312E-10,
    244. 

  244. 																							'yd'	=> 1.09361329797891E-10,
    245. 

  245. 																							'ang'	=> 1.0,
    246. 

  246. 																							'Pica'	=> 2.83464566929116E-07
    247. 

  247. 																						),
    248. 

  248. 																		'Pica'	=> array(	'm'		=> 3.52777777777800E-04,
    249. 

  249. 																							'mi'	=> 2.19205948372629E-07,
    250. 

  250. 																							'Nmi'	=> 1.90484761219114E-07,
    251. 

  251. 																							'in'	=> 1.38888888888898E-02,
    252. 

  252. 																							'ft'	=> 1.15740740740748E-03,
    253. 

  253. 																							'yd'	=> 3.85802469009251E-04,
    254. 

  254. 																							'ang'	=> 3.52777777777800E+06,
    255. 

  255. 																							'Pica'	=> 1.0
    256. 

  256. 																						)
    257. 

  257. 																	),
    258. 

  258. 												'Time'		=> array(	'yr'	=> array(	'yr'		=> 1.0,
    259. 

  259. 																							'day'		=> 365.25,
    260. 

  260. 																							'hr'		=> 8766.0,
    261. 

  261. 																							'mn'		=> 525960.0,
    262. 

  262. 																							'sec'		=> 31557600.0
    263. 

  263. 																						),
    264. 

  264. 																		'day'	=> array(	'yr'		=> 2.73785078713210E-03,
    265. 

  265. 																							'day'		=> 1.0,
    266. 

  266. 																							'hr'		=> 24.0,
    267. 

  267. 																							'mn'		=> 1440.0,
    268. 

  268. 																							'sec'		=> 86400.0
    269. 

  269. 																						),
    270. 

  270. 																		'hr'	=> array(	'yr'		=> 1.14077116130504E-04,
    271. 

  271. 																							'day'		=> 4.16666666666667E-02,
    272. 

  272. 																							'hr'		=> 1.0,
    273. 

  273. 																							'mn'		=> 60.0,
    274. 

  274. 																							'sec'		=> 3600.0
    275. 

  275. 																						),
    276. 

  276. 																		'mn'	=> array(	'yr'		=> 1.90128526884174E-06,
    277. 

  277. 																							'day'		=> 6.94444444444444E-04,
    278. 

  278. 																							'hr'		=> 1.66666666666667E-02,
    279. 

  279. 																							'mn'		=> 1.0,
    280. 

  280. 																							'sec'		=> 60.0
    281. 

  281. 																						),
    282. 

  282. 																		'sec'	=> array(	'yr'		=> 3.16880878140289E-08,
    283. 

  283. 																							'day'		=> 1.15740740740741E-05,
    284. 

  284. 																							'hr'		=> 2.77777777777778E-04,
    285. 

  285. 																							'mn'		=> 1.66666666666667E-02,
    286. 

  286. 																							'sec'		=> 1.0
    287. 

  287. 																						)
    288. 

  288. 																	),
    289. 

  289. 												'Pressure'	=> array(	'Pa'	=> array(	'Pa'		=> 1.0,
    290. 

  290. 																							'p'			=> 1.0,
    291. 

  291. 																							'atm'		=> 9.86923299998193E-06,
    292. 

  292. 																							'at'		=> 9.86923299998193E-06,
    293. 

  293. 																							'mmHg'		=> 7.50061707998627E-03
    294. 

  294. 																						),
    295. 

  295. 																		'p'		=> array(	'Pa'		=> 1.0,
    296. 

  296. 																							'p'			=> 1.0,
    297. 

  297. 																							'atm'		=> 9.86923299998193E-06,
    298. 

  298. 																							'at'		=> 9.86923299998193E-06,
    299. 

  299. 																							'mmHg'		=> 7.50061707998627E-03
    300. 

  300. 																						),
    301. 

  301. 																		'atm'	=> array(	'Pa'		=> 1.01324996583000E+05,
    302. 

  302. 																							'p'			=> 1.01324996583000E+05,
    303. 

  303. 																							'atm'		=> 1.0,
    304. 

  304. 																							'at'		=> 1.0,
    305. 

  305. 																							'mmHg'		=> 760.0
    306. 

  306. 																						),
    307. 

  307. 																		'at'	=> array(	'Pa'		=> 1.01324996583000E+05,
    308. 

  308. 																							'p'			=> 1.01324996583000E+05,
    309. 

  309. 																							'atm'		=> 1.0,
    310. 

  310. 																							'at'		=> 1.0,
    311. 

  311. 																							'mmHg'		=> 760.0
    312. 

  312. 																						),
    313. 

  313. 																		'mmHg'	=> array(	'Pa'		=> 1.33322363925000E+02,
    314. 

  314. 																							'p'			=> 1.33322363925000E+02,
    315. 

  315. 																							'atm'		=> 1.31578947368421E-03,
    316. 

  316. 																							'at'		=> 1.31578947368421E-03,
    317. 

  317. 																							'mmHg'		=> 1.0
    318. 

  318. 																						)
    319. 

  319. 																	),
    320. 

  320. 												'Force'		=> array(	'N'		=> array(	'N'			=> 1.0,
    321. 

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

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

  323. 																							'lbf'		=> 2.24808923655339E-01
    324. 

  324. 																						),
    325. 

  325. 																		'dyn'	=> array(	'N'			=> 1.0E-5,
    326. 

  326. 																							'dyn'		=> 1.0,
    327. 

  327. 																							'dy'		=> 1.0,
    328. 

  328. 																							'lbf'		=> 2.24808923655339E-06
    329. 

  329. 																						),
    330. 

  330. 																		'dy'	=> array(	'N'			=> 1.0E-5,
    331. 

  331. 																							'dyn'		=> 1.0,
    332. 

  332. 																							'dy'		=> 1.0,
    333. 

  333. 																							'lbf'		=> 2.24808923655339E-06
    334. 

  334. 																						),
    335. 

  335. 																		'lbf'	=> array(	'N'			=> 4.448222,
    336. 

  336. 																							'dyn'		=> 4.448222E+5,
    337. 

  337. 																							'dy'		=> 4.448222E+5,
    338. 

  338. 																							'lbf'		=> 1.0
    339. 

  339. 																						)
    340. 

  340. 																	),
    341. 

  341. 												'Energy'	=> array(	'J'		=> array(	'J'			=> 1.0,
    342. 

  342. 																							'e'			=> 9.99999519343231E+06,
    343. 

  343. 																							'c'			=> 2.39006249473467E-01,
    344. 

  344. 																							'cal'		=> 2.38846190642017E-01,
    345. 

  345. 																							'eV'		=> 6.24145700000000E+18,
    346. 

  346. 																							'ev'		=> 6.24145700000000E+18,
    347. 

  347. 																							'HPh'		=> 3.72506430801000E-07,
    348. 

  348. 																							'hh'		=> 3.72506430801000E-07,
    349. 

  349. 																							'Wh'		=> 2.77777916238711E-04,
    350. 

  350. 																							'wh'		=> 2.77777916238711E-04,
    351. 

  351. 																							'flb'		=> 2.37304222192651E+01,
    352. 

  352. 																							'BTU'		=> 9.47815067349015E-04,
    353. 

  353. 																							'btu'		=> 9.47815067349015E-04
    354. 

  354. 																						),
    355. 

  355. 																		'e'		=> array(	'J'			=> 1.00000048065700E-07,
    356. 

  356. 																							'e'			=> 1.0,
    357. 

  357. 																							'c'			=> 2.39006364353494E-08,
    358. 

  358. 																							'cal'		=> 2.38846305445111E-08,
    359. 

  359. 																							'eV'		=> 6.24146000000000E+11,
    360. 

  360. 																							'ev'		=> 6.24146000000000E+11,
    361. 

  361. 																							'HPh'		=> 3.72506609848824E-14,
    362. 

  362. 																							'hh'		=> 3.72506609848824E-14,
    363. 

  363. 																							'Wh'		=> 2.77778049754611E-11,
    364. 

  364. 																							'wh'		=> 2.77778049754611E-11,
    365. 

  365. 																							'flb'		=> 2.37304336254586E-06,
    366. 

  366. 																							'BTU'		=> 9.47815522922962E-11,
    367. 

  367. 																							'btu'		=> 9.47815522922962E-11
    368. 

  368. 																						),
    369. 

  369. 																		'c'		=> array(	'J'			=> 4.18399101363672E+00,
    370. 

  370. 																							'e'			=> 4.18398900257312E+07,
    371. 

  371. 																							'c'			=> 1.0,
    372. 

  372. 																							'cal'		=> 9.99330315287563E-01,
    373. 

  373. 																							'eV'		=> 2.61142000000000E+19,
    374. 

  374. 																							'ev'		=> 2.61142000000000E+19,
    375. 

  375. 																							'HPh'		=> 1.55856355899327E-06,
    376. 

  376. 																							'hh'		=> 1.55856355899327E-06,
    377. 

  377. 																							'Wh'		=> 1.16222030532950E-03,
    378. 

  378. 																							'wh'		=> 1.16222030532950E-03,
    379. 

  379. 																							'flb'		=> 9.92878733152102E+01,
    380. 

  380. 																							'BTU'		=> 3.96564972437776E-03,
    381. 

  381. 																							'btu'		=> 3.96564972437776E-03
    382. 

  382. 																						),
    383. 

  383. 																		'cal'	=> array(	'J'			=> 4.18679484613929E+00,
    384. 

  384. 																							'e'			=> 4.18679283372801E+07,
    385. 

  385. 																							'c'			=> 1.00067013349059E+00,
    386. 

  386. 																							'cal'		=> 1.0,
    387. 

  387. 																							'eV'		=> 2.61317000000000E+19,
    388. 

  388. 																							'ev'		=> 2.61317000000000E+19,
    389. 

  389. 																							'HPh'		=> 1.55960800463137E-06,
    390. 

  390. 																							'hh'		=> 1.55960800463137E-06,
    391. 

  391. 																							'Wh'		=> 1.16299914807955E-03,
    392. 

  392. 																							'wh'		=> 1.16299914807955E-03,
    393. 

  393. 																							'flb'		=> 9.93544094443283E+01,
    394. 

  394. 																							'BTU'		=> 3.96830723907002E-03,
    395. 

  395. 																							'btu'		=> 3.96830723907002E-03
    396. 

  396. 																						),
    397. 

  397. 																		'eV'	=> array(	'J'			=> 1.60219000146921E-19,
    398. 

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

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

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

  401. 																							'eV'		=> 1.0,
    402. 

  402. 																							'ev'		=> 1.0,
    403. 

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

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

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

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

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

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

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

  410. 																						),
    411. 

  411. 																		'ev'	=> array(	'J'			=> 1.60219000146921E-19,
    412. 

  412. 																							'e'			=> 1.60218923136574E-12,
    413. 

  413. 																							'c'			=> 3.82933423195043E-20,
    414. 

  414. 																							'cal'		=> 3.82676978535648E-20,
    415. 

  415. 																							'eV'		=> 1.0,
    416. 

  416. 																							'ev'		=> 1.0,
    417. 

  417. 																							'HPh'		=> 5.96826078912344E-26,
    418. 

  418. 																							'hh'		=> 5.96826078912344E-26,
    419. 

  419. 																							'Wh'		=> 4.45053000026614E-23,
    420. 

  420. 																							'wh'		=> 4.45053000026614E-23,
    421. 

  421. 																							'flb'		=> 3.80206452103492E-18,
    422. 

  422. 																							'BTU'		=> 1.51857982414846E-22,
    423. 

  423. 																							'btu'		=> 1.51857982414846E-22
    424. 

  424. 																						),
    425. 

  425. 																		'HPh'	=> array(	'J'			=> 2.68451741316170E+06,
    426. 

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

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

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

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

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

  431. 																							'HPh'		=> 1.0,
    432. 

  432. 																							'hh'		=> 1.0,
    433. 

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

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

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

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

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

  438. 																						),
    439. 

  439. 																		'hh'	=> array(	'J'			=> 2.68451741316170E+06,
    440. 

  440. 																							'e'			=> 2.68451612283024E+13,
    441. 

  441. 																							'c'			=> 6.41616438565991E+05,
    442. 

  442. 																							'cal'		=> 6.41186757845835E+05,
    443. 

  443. 																							'eV'		=> 1.67553000000000E+25,
    444. 

  444. 																							'ev'		=> 1.67553000000000E+25,
    445. 

  445. 																							'HPh'		=> 1.0,
    446. 

  446. 																							'hh'		=> 1.0,
    447. 

  447. 																							'Wh'		=> 7.45699653134593E+02,
    448. 

  448. 																							'wh'		=> 7.45699653134593E+02,
    449. 

  449. 																							'flb'		=> 6.37047316692964E+07,
    450. 

  450. 																							'BTU'		=> 2.54442605275546E+03,
    451. 

  451. 																							'btu'		=> 2.54442605275546E+03
    452. 

  452. 																						),
    453. 

  453. 																		'Wh'	=> array(	'J'			=> 3.59999820554720E+03,
    454. 

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

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

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

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

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

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

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

  461. 																							'Wh'		=> 1.0,
    462. 

  462. 																							'wh'		=> 1.0,
    463. 

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

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

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

  466. 																						),
    467. 

  467. 																		'wh'	=> array(	'J'			=> 3.59999820554720E+03,
    468. 

  468. 																							'e'			=> 3.59999647518369E+10,
    469. 

  469. 																							'c'			=> 8.60422069219046E+02,
    470. 

  470. 																							'cal'		=> 8.59845857713046E+02,
    471. 

  471. 																							'eV'		=> 2.24692340000000E+22,
    472. 

  472. 																							'ev'		=> 2.24692340000000E+22,
    473. 

  473. 																							'HPh'		=> 1.34102248243839E-03,
    474. 

  474. 																							'hh'		=> 1.34102248243839E-03,
    475. 

  475. 																							'Wh'		=> 1.0,
    476. 

  476. 																							'wh'		=> 1.0,
    477. 

  477. 																							'flb'		=> 8.54294774062316E+04,
    478. 

  478. 																							'BTU'		=> 3.41213254164705E+00,
    479. 

  479. 																							'btu'		=> 3.41213254164705E+00
    480. 

  480. 																						),
    481. 

  481. 																		'flb'	=> array(	'J'			=> 4.21400003236424E-02,
    482. 

  482. 																							'e'			=> 4.21399800687660E+05,
    483. 

  483. 																							'c'			=> 1.00717234301644E-02,
    484. 

  484. 																							'cal'		=> 1.00649785509554E-02,
    485. 

  485. 																							'eV'		=> 2.63015000000000E+17,
    486. 

  486. 																							'ev'		=> 2.63015000000000E+17,
    487. 

  487. 																							'HPh'		=> 1.56974211145130E-08,
    488. 

  488. 																							'hh'		=> 1.56974211145130E-08,
    489. 

  489. 																							'Wh'		=> 1.17055614802000E-05,
    490. 

  490. 																							'wh'		=> 1.17055614802000E-05,
    491. 

  491. 																							'flb'		=> 1.0,
    492. 

  492. 																							'BTU'		=> 3.99409272448406E-05,
    493. 

  493. 																							'btu'		=> 3.99409272448406E-05
    494. 

  494. 																						),
    495. 

  495. 																		'BTU'	=> array(	'J'			=> 1.05505813786749E+03,
    496. 

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

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

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

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

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

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

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

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

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

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

  506. 																							'BTU'		=> 1.0,
    507. 

  507. 																							'btu'		=> 1.0,
    508. 

  508. 																						),
    509. 

  509. 																		'btu'	=> array(	'J'			=> 1.05505813786749E+03,
    510. 

  510. 																							'e'			=> 1.05505763074665E+10,
    511. 

  511. 																							'c'			=> 2.52165488508168E+02,
    512. 

  512. 																							'cal'		=> 2.51996617135510E+02,
    513. 

  513. 																							'eV'		=> 6.58510000000000E+21,
    514. 

  514. 																							'ev'		=> 6.58510000000000E+21,
    515. 

  515. 																							'HPh'		=> 3.93015941224568E-04,
    516. 

  516. 																							'hh'		=> 3.93015941224568E-04,
    517. 

  517. 																							'Wh'		=> 2.93071851047526E-01,
    518. 

  518. 																							'wh'		=> 2.93071851047526E-01,
    519. 

  519. 																							'flb'		=> 2.50369750774671E+04,
    520. 

  520. 																							'BTU'		=> 1.0,
    521. 

  521. 																							'btu'		=> 1.0,
    522. 

  522. 																						)
    523. 

  523. 																	),
    524. 

  524. 												'Power'		=> array(	'HP'	=> array(	'HP'		=> 1.0,
    525. 

  525. 																							'h'			=> 1.0,
    526. 

  526. 																							'W'			=> 7.45701000000000E+02,
    527. 

  527. 																							'w'			=> 7.45701000000000E+02
    528. 

  528. 																						),
    529. 

  529. 																		'h'		=> array(	'HP'		=> 1.0,
    530. 

  530. 																							'h'			=> 1.0,
    531. 

  531. 																							'W'			=> 7.45701000000000E+02,
    532. 

  532. 																							'w'			=> 7.45701000000000E+02
    533. 

  533. 																						),
    534. 

  534. 																		'W'		=> array(	'HP'		=> 1.34102006031908E-03,
    535. 

  535. 																							'h'			=> 1.34102006031908E-03,
    536. 

  536. 																							'W'			=> 1.0,
    537. 

  537. 																							'w'			=> 1.0
    538. 

  538. 																						),
    539. 

  539. 																		'w'		=> array(	'HP'		=> 1.34102006031908E-03,
    540. 

  540. 																							'h'			=> 1.34102006031908E-03,
    541. 

  541. 																							'W'			=> 1.0,
    542. 

  542. 																							'w'			=> 1.0
    543. 

  543. 																						)
    544. 

  544. 																	),
    545. 

  545. 												'Magnetism'	=> array(	'T'		=> array(	'T'			=> 1.0,
    546. 

  546. 																							'ga'		=> 10000.0
    547. 

  547. 																						),
    548. 

  548. 																		'ga'	=> array(	'T'			=> 0.0001,
    549. 

  549. 																							'ga'		=> 1.0
    550. 

  550. 																						)
    551. 

  551. 																	),
    552. 

  552. 												'Liquid'	=> array(	'tsp'	=> array(	'tsp'		=> 1.0,
    553. 

  553. 																							'tbs'		=> 3.33333333333333E-01,
    554. 

  554. 																							'oz'		=> 1.66666666666667E-01,
    555. 

  555. 																							'cup'		=> 2.08333333333333E-02,
    556. 

  556. 																							'pt'		=> 1.04166666666667E-02,
    557. 

  557. 																							'us_pt'		=> 1.04166666666667E-02,
    558. 

  558. 																							'uk_pt'		=> 8.67558516821960E-03,
    559. 

  559. 																							'qt'		=> 5.20833333333333E-03,
    560. 

  560. 																							'gal'		=> 1.30208333333333E-03,
    561. 

  561. 																							'l'			=> 4.92999408400710E-03,
    562. 

  562. 																							'lt'		=> 4.92999408400710E-03
    563. 

  563. 																						),
    564. 

  564. 																		'tbs'	=> array(	'tsp'		=> 3.00000000000000E+00,
    565. 

  565. 																							'tbs'		=> 1.0,
    566. 

  566. 																							'oz'		=> 5.00000000000000E-01,
    567. 

  567. 																							'cup'		=> 6.25000000000000E-02,
    568. 

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

  569. 																							'us_pt'		=> 3.12500000000000E-02,
    570. 

  570. 																							'uk_pt'		=> 2.60267555046588E-02,
    571. 

  571. 																							'qt'		=> 1.56250000000000E-02,
    572. 

  572. 																							'gal'		=> 3.90625000000000E-03,
    573. 

  573. 																							'l'			=> 1.47899822520213E-02,
    574. 

  574. 																							'lt'		=> 1.47899822520213E-02
    575. 

  575. 																						),
    576. 

  576. 																		'oz'	=> array(	'tsp'		=> 6.00000000000000E+00,
    577. 

  577. 																							'tbs'		=> 2.00000000000000E+00,
    578. 

  578. 																							'oz'		=> 1.0,
    579. 

  579. 																							'cup'		=> 1.25000000000000E-01,
    580. 

  580. 																							'pt'		=> 6.25000000000000E-02,
    581. 

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

  582. 																							'uk_pt'		=> 5.20535110093176E-02,
    583. 

  583. 																							'qt'		=> 3.12500000000000E-02,
    584. 

  584. 																							'gal'		=> 7.81250000000000E-03,
    585. 

  585. 																							'l'			=> 2.95799645040426E-02,
    586. 

  586. 																							'lt'		=> 2.95799645040426E-02
    587. 

  587. 																						),
    588. 

  588. 																		'cup'	=> array(	'tsp'		=> 4.80000000000000E+01,
    589. 

  589. 																							'tbs'		=> 1.60000000000000E+01,
    590. 

  590. 																							'oz'		=> 8.00000000000000E+00,
    591. 

  591. 																							'cup'		=> 1.0,
    592. 

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

  593. 																							'us_pt'		=> 5.00000000000000E-01,
    594. 

  594. 																							'uk_pt'		=> 4.16428088074541E-01,
    595. 

  595. 																							'qt'		=> 2.50000000000000E-01,
    596. 

  596. 																							'gal'		=> 6.25000000000000E-02,
    597. 

  597. 																							'l'			=> 2.36639716032341E-01,
    598. 

  598. 																							'lt'		=> 2.36639716032341E-01
    599. 

  599. 																						),
    600. 

  600. 																		'pt'	=> array(	'tsp'		=> 9.60000000000000E+01,
    601. 

  601. 																							'tbs'		=> 3.20000000000000E+01,
    602. 

  602. 																							'oz'		=> 1.60000000000000E+01,
    603. 

  603. 																							'cup'		=> 2.00000000000000E+00,
    604. 

  604. 																							'pt'		=> 1.0,
    605. 

  605. 																							'us_pt'		=> 1.0,
    606. 

  606. 																							'uk_pt'		=> 8.32856176149081E-01,
    607. 

  607. 																							'qt'		=> 5.00000000000000E-01,
    608. 

  608. 																							'gal'		=> 1.25000000000000E-01,
    609. 

  609. 																							'l'			=> 4.73279432064682E-01,
    610. 

  610. 																							'lt'		=> 4.73279432064682E-01
    611. 

  611. 																						),
    612. 

  612. 																		'us_pt'	=> array(	'tsp'		=> 9.60000000000000E+01,
    613. 

  613. 																							'tbs'		=> 3.20000000000000E+01,
    614. 

  614. 																							'oz'		=> 1.60000000000000E+01,
    615. 

  615. 																							'cup'		=> 2.00000000000000E+00,
    616. 

  616. 																							'pt'		=> 1.0,
    617. 

  617. 																							'us_pt'		=> 1.0,
    618. 

  618. 																							'uk_pt'		=> 8.32856176149081E-01,
    619. 

  619. 																							'qt'		=> 5.00000000000000E-01,
    620. 

  620. 																							'gal'		=> 1.25000000000000E-01,
    621. 

  621. 																							'l'			=> 4.73279432064682E-01,
    622. 

  622. 																							'lt'		=> 4.73279432064682E-01
    623. 

  623. 																						),
    624. 

  624. 																		'uk_pt'	=> array(	'tsp'		=> 1.15266000000000E+02,
    625. 

  625. 																							'tbs'		=> 3.84220000000000E+01,
    626. 

  626. 																							'oz'		=> 1.92110000000000E+01,
    627. 

  627. 																							'cup'		=> 2.40137500000000E+00,
    628. 

  628. 																							'pt'		=> 1.20068750000000E+00,
    629. 

  629. 																							'us_pt'		=> 1.20068750000000E+00,
    630. 

  630. 																							'uk_pt'		=> 1.0,
    631. 

  631. 																							'qt'		=> 6.00343750000000E-01,
    632. 

  632. 																							'gal'		=> 1.50085937500000E-01,
    633. 

  633. 																							'l'			=> 5.68260698087162E-01,
    634. 

  634. 																							'lt'		=> 5.68260698087162E-01
    635. 

  635. 																						),
    636. 

  636. 																		'qt'	=> array(	'tsp'		=> 1.92000000000000E+02,
    637. 

  637. 																							'tbs'		=> 6.40000000000000E+01,
    638. 

  638. 																							'oz'		=> 3.20000000000000E+01,
    639. 

  639. 																							'cup'		=> 4.00000000000000E+00,
    640. 

  640. 																							'pt'		=> 2.00000000000000E+00,
    641. 

  641. 																							'us_pt'		=> 2.00000000000000E+00,
    642. 

  642. 																							'uk_pt'		=> 1.66571235229816E+00,
    643. 

  643. 																							'qt'		=> 1.0,
    644. 

  644. 																							'gal'		=> 2.50000000000000E-01,
    645. 

  645. 																							'l'			=> 9.46558864129363E-01,
    646. 

  646. 																							'lt'		=> 9.46558864129363E-01
    647. 

  647. 																						),
    648. 

  648. 																		'gal'	=> array(	'tsp'		=> 7.68000000000000E+02,
    649. 

  649. 																							'tbs'		=> 2.56000000000000E+02,
    650. 

  650. 																							'oz'		=> 1.28000000000000E+02,
    651. 

  651. 																							'cup'		=> 1.60000000000000E+01,
    652. 

  652. 																							'pt'		=> 8.00000000000000E+00,
    653. 

  653. 																							'us_pt'		=> 8.00000000000000E+00,
    654. 

  654. 																							'uk_pt'		=> 6.66284940919265E+00,
    655. 

  655. 																							'qt'		=> 4.00000000000000E+00,
    656. 

  656. 																							'gal'		=> 1.0,
    657. 

  657. 																							'l'			=> 3.78623545651745E+00,
    658. 

  658. 																							'lt'		=> 3.78623545651745E+00
    659. 

  659. 																						),
    660. 

  660. 																		'l'		=> array(	'tsp'		=> 2.02840000000000E+02,
    661. 

  661. 																							'tbs'		=> 6.76133333333333E+01,
    662. 

  662. 																							'oz'		=> 3.38066666666667E+01,
    663. 

  663. 																							'cup'		=> 4.22583333333333E+00,
    664. 

  664. 																							'pt'		=> 2.11291666666667E+00,
    665. 

  665. 																							'us_pt'		=> 2.11291666666667E+00,
    666. 

  666. 																							'uk_pt'		=> 1.75975569552166E+00,
    667. 

  667. 																							'qt'		=> 1.05645833333333E+00,
    668. 

  668. 																							'gal'		=> 2.64114583333333E-01,
    669. 

  669. 																							'l'			=> 1.0,
    670. 

  670. 																							'lt'		=> 1.0
    671. 

  671. 																						),
    672. 

  672. 																		'lt'	=> array(	'tsp'		=> 2.02840000000000E+02,
    673. 

  673. 																							'tbs'		=> 6.76133333333333E+01,
    674. 

  674. 																							'oz'		=> 3.38066666666667E+01,
    675. 

  675. 																							'cup'		=> 4.22583333333333E+00,
    676. 

  676. 																							'pt'		=> 2.11291666666667E+00,
    677. 

  677. 																							'us_pt'		=> 2.11291666666667E+00,
    678. 

  678. 																							'uk_pt'		=> 1.75975569552166E+00,
    679. 

  679. 																							'qt'		=> 1.05645833333333E+00,
    680. 

  680. 																							'gal'		=> 2.64114583333333E-01,
    681. 

  681. 																							'l'			=> 1.0,
    682. 

  682. 																							'lt'		=> 1.0
    683. 

  683. 																						)
    684. 

  684. 																	)
    685. 

  685. 											);
    686. 

  686. 

  687. 

  688. 	/**
    689. 

  689. 	 * _parseComplex
    690. 

  690. 	 *
    691. 

  691. 	 * Parses a complex number into its real and imaginary parts, and an I or J suffix
    692. 

  692. 	 *
    693. 

  693. 	 * @param	string		$complexNumber	The complex number
    694. 

  694. 	 * @return	string[]	Indexed on "real", "imaginary" and "suffix"
    695. 

  695. 	 */
    696. 

  696. 	public static function _parseComplex($complexNumber) {
    697. 

  697. 		$workString = (string) $complexNumber;
    698. 

  698. 

  699. 		$realNumber = $imaginary = 0;
    700. 

  700. 		//	Extract the suffix, if there is one
    701. 

  701. 		$suffix = substr($workString,-1);
    702. 

  702. 		if (!is_numeric($suffix)) {
    703. 

  703. 			$workString = substr($workString,0,-1);
    704. 

  704. 		} else {
    705. 

  705. 			$suffix = '';
    706. 

  706. 		}
    707. 

  707. 

  708. 		//	Split the input into its Real and Imaginary components
    709. 

  709. 		$leadingSign = 0;
    710. 

  710. 		if (strlen($workString) > 0) {
    711. 

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

  712. 		}
    713. 

  713. 		$power = '';
    714. 

  714. 		$realNumber = strtok($workString, '+-');
    715. 

  715. 		if (strtoupper(substr($realNumber,-1)) == 'E') {
    716. 

  716. 			$power = strtok('+-');
    717. 

  717. 			++$leadingSign;
    718. 

  718. 		}
    719. 

  719. 

  720. 		$realNumber = substr($workString,0,strlen($realNumber)+strlen($power)+$leadingSign);
    721. 

  721. 

  722. 		if ($suffix != '') {
    723. 

  723. 			$imaginary = substr($workString,strlen($realNumber));
    724. 

  724. 

  725. 			if (($imaginary == '') && (($realNumber == '') || ($realNumber == '+') || ($realNumber == '-'))) {
    726. 

  726. 				$imaginary = $realNumber.'1';
    727. 

  727. 				$realNumber = '0';
    728. 

  728. 			} else if ($imaginary == '') {
    729. 

  729. 				$imaginary = $realNumber;
    730. 

  730. 				$realNumber = '0';
    731. 

  731. 			} elseif (($imaginary == '+') || ($imaginary == '-')) {
    732. 

  732. 				$imaginary .= '1';
    733. 

  733. 			}
    734. 

  734. 		}
    735. 

  735. 

  736. 		return array( 'real'		=> $realNumber,
    737. 

  737. 					  'imaginary'	=> $imaginary,
    738. 

  738. 					  'suffix'		=> $suffix
    739. 

  739. 					);
    740. 

  740. 	}	//	function _parseComplex()
    741. 

  741. 

  742. 

  743. 	/**
    744. 

  744. 	 * _cleanComplex
    745. 

  745. 	 *
    746. 

  746. 	 * Cleans the leading characters in a complex number string
    747. 

  747. 	 *
    748. 

  748. 	 * @param	string		$complexNumber	The complex number to clean
    749. 

  749. 	 * @return	string		The "cleaned" complex number
    750. 

  750. 	 */
    751. 

  751. 	private static function _cleanComplex($complexNumber) {
    752. 

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

  753. 		if ($complexNumber{0} == '0') $complexNumber = substr($complexNumber,1);
    754. 

  754. 		if ($complexNumber{0} == '.') $complexNumber = '0'.$complexNumber;
    755. 

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

  756. 		return $complexNumber;
    757. 

  757. 	}
    758. 

  758. 

  759. 

  760. 	private static function _nbrConversionFormat($xVal,$places) {
    761. 

  761. 		if (!is_null($places)) {
    762. 

  762. 			if (strlen($xVal) <= $places) {
    763. 

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

  764. 			} else {
    765. 

  765. 				return PHPExcel_Calculation_Functions::NaN();
    766. 

  766. 			}
    767. 

  767. 		}
    768. 

  768. 

  769. 		return substr($xVal,-10);
    770. 

  770. 	}	//	function _nbrConversionFormat()
    771. 

  771. 

  772. 

  773. 	/**
    774. 

  774. 	 * BESSELI
    775. 

  775. 	 *
    776. 

  776. 	 * Returns the modified Bessel function, which is equivalent to the Bessel function evaluated for
    777. 

  777. 	 * purely imaginary arguments
    778. 

  778. 	 *
    779. 

  779. 	 * Excel Function:
    780. 

  780. 	 *		BESSELI(x,ord)
    781. 

  781. 	 *
    782. 

  782. 	 * @access	public
    783. 

  783. 	 * @category Engineering Functions
    784. 

  784. 	 * @param	float		$x		The value at which to evaluate the function.
    785. 

  785. 	 *								If x is nonnumeric, BESSELI returns the #VALUE! error value.
    786. 

  786. 	 * @param	integer		$ord	The order of the Bessel function. If n is not an integer, it is truncated.
    787. 

  787. 	 *								If $ord is nonnumeric, BESSELI returns the #VALUE! error value.
    788. 

  788. 	 *								If $ord < 0, BESSELI returns the #NUM! error value.
    789. 

  789. 	 * @return	float
    790. 

  790. 	 *
    791. 

  791. 	 * @TODO Better handling of the approximation method to support the differences between Excel/Gnumeric and Open/Libre Office
    792. 

  792. 	 *
    793. 

  793. 	 */
    794. 

  794. 	public static function BESSELI($x, $ord) {
    795. 

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

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

  797. 

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

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

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

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

  802. 			}
    803. 

  803. 

  804. 			if (abs($x) <= 30) {
    805. 

  805. 				$fResult = $fTerm = pow($x / 2, $ord) / PHPExcel_Calculation_MathTrig::FACT($ord);
    806. 

  806. 				$ordK = 1;
    807. 

  807. 				$fSqrX = ($x * $x) / 4;
    808. 

  808. 				do {
    809. 

  809. 					$fTerm *= $fSqrX;
    810. 

  810. 					$fTerm /= ($ordK * ($ordK + $ord));
    811. 

  811. 					$fResult += $fTerm;
    812. 

  812. 				} while ((abs($fTerm) > 1e-12) && (++$ordK < 100));
    813. 

  813. 			} else {
    814. 

  814. 				$f_2_PI = 2 * M_PI;
    815. 

  815. 

  816. 				$fXAbs = abs($x);
    817. 

  817. 				$fResult = exp($fXAbs) / sqrt($f_2_PI * $fXAbs);
    818. 

  818. 				if (($ord & 1) && ($x < 0)) {
    819. 

  819. 					$fResult = -$fResult;
    820. 

  820. 				}
    821. 

  821. 			}
    822. 

  822. 			return (is_nan($fResult)) ? PHPExcel_Calculation_Functions::NaN() : $fResult;
    823. 

  823. 		}
    824. 

  824. 		return PHPExcel_Calculation_Functions::VALUE();
    825. 

  825. 	}	//	function BESSELI()
    826. 

  826. 

  827. 

  828. 	/**
    829. 

  829. 	 * BESSELJ
    830. 

  830. 	 *
    831. 

  831. 	 * Returns the Bessel function
    832. 

  832. 	 *
    833. 

  833. 	 * Excel Function:
    834. 

  834. 	 *		BESSELJ(x,ord)
    835. 

  835. 	 *
    836. 

  836. 	 * @access	public
    837. 

  837. 	 * @category Engineering Functions
    838. 

  838. 	 * @param	float		$x		The value at which to evaluate the function.
    839. 

  839. 	 *								If x is nonnumeric, BESSELJ returns the #VALUE! error value.
    840. 

  840. 	 * @param	integer		$ord	The order of the Bessel function. If n is not an integer, it is truncated.
    841. 

  841. 	 *								If $ord is nonnumeric, BESSELJ returns the #VALUE! error value.
    842. 

  842. 	 *								If $ord < 0, BESSELJ returns the #NUM! error value.
    843. 

  843. 	 * @return	float
    844. 

  844. 	 *
    845. 

  845. 	 * @TODO Better handling of the approximation method to support the differences between Excel/Gnumeric and Open/Libre Office
    846. 

  846. 	 *
    847. 

  847. 	 */
    848. 

  848. 	public static function BESSELJ($x, $ord) {
    849. 

  849. 		$x	= (is_null($x))	? 0.0 :	PHPExcel_Calculation_Functions::flattenSingleValue($x);
    850. 

  850. 		$ord	= (is_null($ord))	? 0.0 :	PHPExcel_Calculation_Functions::flattenSingleValue($ord);
    851. 

  851. 

  852. 		if ((is_numeric($x)) && (is_numeric($ord))) {
    853. 

  853. 			$ord	= floor($ord);
    854. 

  854. 			if ($ord < 0) {
    855. 

  855. 				return PHPExcel_Calculation_Functions::NaN();
    856. 

  856. 			}
    857. 

  857. 

  858. 			$fResult = 0;
    859. 

  859. 			if (abs($x) <= 30) {
    860. 

  860. 				$fResult = $fTerm = pow($x / 2, $ord) / PHPExcel_Calculation_MathTrig::FACT($ord);
    861. 

  861. 				$ordK = 1;
    862. 

  862. 				$fSqrX = ($x * $x) / -4;
    863. 

  863. 				do {
    864. 

  864. 					$fTerm *= $fSqrX;
    865. 

  865. 					$fTerm /= ($ordK * ($ordK + $ord));
    866. 

  866. 					$fResult += $fTerm;
    867. 

  867. 				} while ((abs($fTerm) > 1e-12) && (++$ordK < 100));
    868. 

  868. 			} else {
    869. 

  869. 				$f_PI_DIV_2 = M_PI / 2;
    870. 

  870. 				$f_PI_DIV_4 = M_PI / 4;
    871. 

  871. 

  872. 				$fXAbs = abs($x);
    873. 

  873. 				$fResult = sqrt(M_2DIVPI / $fXAbs) * cos($fXAbs - $ord * $f_PI_DIV_2 - $f_PI_DIV_4);
    874. 

  874. 				if (($ord & 1) && ($x < 0)) {
    875. 

  875. 					$fResult = -$fResult;
    876. 

  876. 				}
    877. 

  877. 			}
    878. 

  878. 			return (is_nan($fResult)) ? PHPExcel_Calculation_Functions::NaN() : $fResult;
    879. 

  879. 		}
    880. 

  880. 		return PHPExcel_Calculation_Functions::VALUE();
    881. 

  881. 	}	//	function BESSELJ()
    882. 

  882. 

  883. 

  884. 	private static function _Besselk0($fNum) {
    885. 

  885. 		if ($fNum <= 2) {
    886. 

  886. 			$fNum2 = $fNum * 0.5;
    887. 

  887. 			$y = ($fNum2 * $fNum2);
    888. 

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

  889. 					(-0.57721566 + $y * (0.42278420 + $y * (0.23069756 + $y * (0.3488590e-1 + $y * (0.262698e-2 + $y *
    890. 

  890. 					(0.10750e-3 + $y * 0.74e-5))))));
    891. 

  891. 		} else {
    892. 

  892. 			$y = 2 / $fNum;
    893. 

  893. 			$fRet = exp(-$fNum) / sqrt($fNum) *
    894. 

  894. 					(1.25331414 + $y * (-0.7832358e-1 + $y * (0.2189568e-1 + $y * (-0.1062446e-1 + $y *
    895. 

  895. 					(0.587872e-2 + $y * (-0.251540e-2 + $y * 0.53208e-3))))));
    896. 

  896. 		}
    897. 

  897. 		return $fRet;
    898. 

  898. 	}	//	function _Besselk0()
    899. 

  899. 

  900. 

  901. 	private static function _Besselk1($fNum) {
    902. 

  902. 		if ($fNum <= 2) {
    903. 

  903. 			$fNum2 = $fNum * 0.5;
    904. 

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

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

  906. 					(1 + $y * (0.15443144 + $y * (-0.67278579 + $y * (-0.18156897 + $y * (-0.1919402e-1 + $y *
    907. 

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

  908. 		} else {
    909. 

  909. 			$y = 2 / $fNum;
    910. 

  910. 			$fRet = exp(-$fNum) / sqrt($fNum) *
    911. 

  911. 					(1.25331414 + $y * (0.23498619 + $y * (-0.3655620e-1 + $y * (0.1504268e-1 + $y * (-0.780353e-2 + $y *
    912. 

  912. 					(0.325614e-2 + $y * (-0.68245e-3)))))));
    913. 

  913. 		}
    914. 

  914. 		return $fRet;
    915. 

  915. 	}	//	function _Besselk1()
    916. 

  916. 

  917. 

  918. 	/**
    919. 

  919. 	 * BESSELK
    920. 

  920. 	 *
    921. 

  921. 	 * Returns the modified Bessel function, which is equivalent to the Bessel functions evaluated
    922. 

  922. 	 * for purely imaginary arguments.
    923. 

  923. 	 *
    924. 

  924. 	 * Excel Function:
    925. 

  925. 	 *		BESSELK(x,ord)
    926. 

  926. 	 *
    927. 

  927. 	 * @access	public
    928. 

  928. 	 * @category Engineering Functions
    929. 

  929. 	 * @param	float		$x		The value at which to evaluate the function.
    930. 

  930. 	 *								If x is nonnumeric, BESSELK returns the #VALUE! error value.
    931. 

  931. 	 * @param	integer		$ord	The order of the Bessel function. If n is not an integer, it is truncated.
    932. 

  932. 	 *								If $ord is nonnumeric, BESSELK returns the #VALUE! error value.
    933. 

  933. 	 *								If $ord < 0, BESSELK returns the #NUM! error value.
    934. 

  934. 	 * @return	float
    935. 

  935. 	 *
    936. 

  936. 	 * @TODO Better handling of the approximation method to support the differences between Excel/Gnumeric and Open/Libre Office
    937. 

  937. 	 *
    938. 

  938. 	 */
    939. 

  939. 	public static function BESSELK($x, $ord) {
    940. 

  940. 		$x		= (is_null($x))		? 0.0 :	PHPExcel_Calculation_Functions::flattenSingleValue($x);
    941. 

  941. 		$ord	= (is_null($ord))	? 0.0 :	PHPExcel_Calculation_Functions::flattenSingleValue($ord);
    942. 

  942. 

  943. 		if ((is_numeric($x)) && (is_numeric($ord))) {
    944. 

  944. 			if (($ord < 0) || ($x == 0.0)) {
    945. 

  945. 				return PHPExcel_Calculation_Functions::NaN();
    946. 

  946. 			}
    947. 

  947. 

  948. 			switch(floor($ord)) {
    949. 

  949. 				case 0 :	return self::_Besselk0($x);
    950. 

  950. 							break;
    951. 

  951. 				case 1 :	return self::_Besselk1($x);
    952. 

  952. 							break;
    953. 

  953. 				default :	$fTox	= 2 / $x;
    954. 

  954. 							$fBkm	= self::_Besselk0($x);
    955. 

  955. 							$fBk	= self::_Besselk1($x);
    956. 

  956. 							for ($n = 1; $n < $ord; ++$n) {
    957. 

  957. 								$fBkp	= $fBkm + $n * $fTox * $fBk;
    958. 

  958. 								$fBkm	= $fBk;
    959. 

  959. 								$fBk	= $fBkp;
    960. 

  960. 							}
    961. 

  961. 			}
    962. 

  962. 			return (is_nan($fBk)) ? PHPExcel_Calculation_Functions::NaN() : $fBk;
    963. 

  963. 		}
    964. 

  964. 		return PHPExcel_Calculation_Functions::VALUE();
    965. 

  965. 	}	//	function BESSELK()
    966. 

  966. 

  967. 

  968. 	private static function _Bessely0($fNum) {
    969. 

  969. 		if ($fNum < 8.0) {
    970. 

  970. 			$y = ($fNum * $fNum);
    971. 

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

  972. 			$f2 = 40076544269.0 + $y * (745249964.8 + $y * (7189466.438 + $y * (47447.26470 + $y * (226.1030244 + $y))));
    973. 

  973. 			$fRet = $f1 / $f2 + 0.636619772 * self::BESSELJ($fNum, 0) * log($fNum);
    974. 

  974. 		} else {
    975. 

  975. 			$z = 8.0 / $fNum;
    976. 

  976. 			$y = ($z * $z);
    977. 

  977. 			$xx = $fNum - 0.785398164;
    978. 

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

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

  980. 			$fRet = sqrt(0.636619772 / $fNum) * (sin($xx) * $f1 + $z * cos($xx) * $f2);
    981. 

  981. 		}
    982. 

  982. 		return $fRet;
    983. 

  983. 	}	//	function _Bessely0()
    984. 

  984. 

  985. 

  986. 	private static function _Bessely1($fNum) {
    987. 

  987. 		if ($fNum < 8.0) {
    988. 

  988. 			$y = ($fNum * $fNum);
    989. 

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

  990. 				(-0.4237922726e7 + $y * 0.8511937935e4)))));
    991. 

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

  992. 				(0.1020426050e6 + $y * (0.3549632885e3 + $y)))));
    993. 

  993. 			$fRet = $f1 / $f2 + 0.636619772 * ( self::BESSELJ($fNum, 1) * log($fNum) - 1 / $fNum);
    994. 

  994. 		} else {
    995. 

  995. //			$z = 8.0 / $fNum;
    996. 

  996. //			$y = ($z * $z);
    997. 

  997. //			$xx = $fNum - 2.356194491;
    998. 

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

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

  1000. //			$fRet = sqrt(0.636619772 / $fNum) * (sin($xx) * $f1 + $z * cos($xx) * $f2);
    1001. 

  1001. 			#i12430# ...but this seems to work much better.
    1002. 

  1002. 			$fRet = sqrt(0.636619772 / $fNum) * sin($fNum - 2.356194491);
    1003. 

  1003. 		}
    1004. 

  1004. 		return $fRet;
    1005. 

  1005. 	}	//	function _Bessely1()
    1006. 

  1006. 

  1007. 

  1008. 	/**
    1009. 

  1009. 	 * BESSELY
    1010. 

  1010. 	 *
    1011. 

  1011. 	 * Returns the Bessel function, which is also called the Weber function or the Neumann function.
    1012. 

  1012. 	 *
    1013. 

  1013. 	 * Excel Function:
    1014. 

  1014. 	 *		BESSELY(x,ord)
    1015. 

  1015. 	 *
    1016. 

  1016. 	 * @access	public
    1017. 

  1017. 	 * @category Engineering Functions
    1018. 

  1018. 	 * @param	float		$x		The value at which to evaluate the function.
    1019. 

  1019. 	 *								If x is nonnumeric, BESSELK returns the #VALUE! error value.
    1020. 

  1020. 	 * @param	integer		$ord	The order of the Bessel function. If n is not an integer, it is truncated.
    1021. 

  1021. 	 *								If $ord is nonnumeric, BESSELK returns the #VALUE! error value.
    1022. 

  1022. 	 *								If $ord < 0, BESSELK returns the #NUM! error value.
    1023. 

  1023. 	 *
    1024. 

  1024. 	 * @TODO Better handling of the approximation method to support the differences between Excel/Gnumeric and Open/Libre Office
    1025. 

  1025. 	 *
    1026. 

  1026. 	 * @return	float
    1027. 

  1027. 	 */
    1028. 

  1028. 	public static function BESSELY($x, $ord) {
    1029. 

  1029. 		$x		= (is_null($x))		? 0.0 :	PHPExcel_Calculation_Functions::flattenSingleValue($x);
    1030. 

  1030. 		$ord	= (is_null($ord))	? 0.0 :	PHPExcel_Calculation_Functions::flattenSingleValue($ord);
    1031. 

  1031. 

  1032. 		if ((is_numeric($x)) && (is_numeric($ord))) {
    1033. 

  1033. 			if (($ord < 0) || ($x == 0.0)) {
    1034. 

  1034. 				return PHPExcel_Calculation_Functions::NaN();
    1035. 

  1035. 			}
    1036. 

  1036. 

  1037. 			switch(floor($ord)) {
    1038. 

  1038. 				case 0 :	return self::_Bessely0($x);
    1039. 

  1039. 							break;
    1040. 

  1040. 				case 1 :	return self::_Bessely1($x);
    1041. 

  1041. 							break;
    1042. 

  1042. 				default:	$fTox	= 2 / $x;
    1043. 

  1043. 							$fBym	= self::_Bessely0($x);
    1044. 

  1044. 							$fBy	= self::_Bessely1($x);
    1045. 

  1045. 							for ($n = 1; $n < $ord; ++$n) {
    1046. 

  1046. 								$fByp	= $n * $fTox * $fBy - $fBym;
    1047. 

  1047. 								$fBym	= $fBy;
    1048. 

  1048. 								$fBy	= $fByp;
    1049. 

  1049. 							}
    1050. 

  1050. 			}
    1051. 

  1051. 			return (is_nan($fBy)) ? PHPExcel_Calculation_Functions::NaN() : $fBy;
    1052. 

  1052. 		}
    1053. 

  1053. 		return PHPExcel_Calculation_Functions::VALUE();
    1054. 

  1054. 	}	//	function BESSELY()
    1055. 

  1055. 

  1056. 

  1057. 	/**
    1058. 

  1058. 	 * BINTODEC
    1059. 

  1059. 	 *
    1060. 

  1060. 	 * Return a binary value as decimal.
    1061. 

  1061. 	 *
    1062. 

  1062. 	 * Excel Function:
    1063. 

  1063. 	 *		BIN2DEC(x)
    1064. 

  1064. 	 *
    1065. 

  1065. 	 * @access	public
    1066. 

  1066. 	 * @category Engineering Functions
    1067. 

  1067. 	 * @param	string		$x		The binary number (as a string) that you want to convert. The number
    1068. 

  1068. 	 *								cannot contain more than 10 characters (10 bits). The most significant
    1069. 

  1069. 	 *								bit of number is the sign bit. The remaining 9 bits are magnitude bits.
    1070. 

  1070. 	 *								Negative numbers are represented using two's-complement notation.
    1071. 

  1071. 	 *								If number is not a valid binary number, or if number contains more than
    1072. 

  1072. 	 *								10 characters (10 bits), BIN2DEC returns the #NUM! error value.
    1073. 

  1073. 	 * @return	string
    1074. 

  1074. 	 */
    1075. 

  1075. 	public static function BINTODEC($x) {
    1076. 

  1076. 		$x	= PHPExcel_Calculation_Functions::flattenSingleValue($x);
    1077. 

  1077. 

  1078. 		if (is_bool($x)) {
    1079. 

  1079. 			if (PHPExcel_Calculation_Functions::getCompatibilityMode() == PHPExcel_Calculation_Functions::COMPATIBILITY_OPENOFFICE) {
    1080. 

  1080. 				$x = (int) $x;
    1081. 

  1081. 			} else {
    1082. 

  1082. 				return PHPExcel_Calculation_Functions::VALUE();
    1083. 

  1083. 			}
    1084. 

  1084. 		}
    1085. 

  1085. 		if (PHPExcel_Calculation_Functions::getCompatibilityMode() == PHPExcel_Calculation_Functions::COMPATIBILITY_GNUMERIC) {
    1086. 

  1086. 			$x = floor($x);
    1087. 

  1087. 		}
    1088. 

  1088. 		$x = (string) $x;
    1089. 

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

  1090. 			return PHPExcel_Calculation_Functions::NaN();
    1091. 

  1091. 		}
    1092. 

  1092. 		if (strlen($x) > 10) {
    1093. 

  1093. 			return PHPExcel_Calculation_Functions::NaN();
    1094. 

  1094. 		} elseif (strlen($x) == 10) {
    1095. 

  1095. 			//	Two's Complement
    1096. 

  1096. 			$x = substr($x,-9);
    1097. 

  1097. 			return '-'.(512-bindec($x));
    1098. 

  1098. 		}
    1099. 

  1099. 		return bindec($x);
    1100. 

  1100. 	}	//	function BINTODEC()
    1101. 

  1101. 

  1102. 

  1103. 	/**
    1104. 

  1104. 	 * BINTOHEX
    1105. 

  1105. 	 *
    1106. 

  1106. 	 * Return a binary value as hex.
    1107. 

  1107. 	 *
    1108. 

  1108. 	 * Excel Function:
    1109. 

  1109. 	 *		BIN2HEX(x[,places])
    1110. 

  1110. 	 *
    1111. 

  1111. 	 * @access	public
    1112. 

  1112. 	 * @category Engineering Functions
    1113. 

  1113. 	 * @param	string		$x		The binary number (as a string) that you want to convert. The number
    1114. 

  1114. 	 *								cannot contain more than 10 characters (10 bits). The most significant
    1115. 

  1115. 	 *								bit of number is the sign bit. The remaining 9 bits are magnitude bits.
    1116. 

  1116. 	 *								Negative numbers are represented using two's-complement notation.
    1117. 

  1117. 	 *								If number is not a valid binary number, or if number contains more than
    1118. 

  1118. 	 *								10 characters (10 bits), BIN2HEX returns the #NUM! error value.
    1119. 

  1119. 	 * @param	integer		$places	The number of characters to use. If places is omitted, BIN2HEX uses the
    1120. 

  1120. 	 *								minimum number of characters necessary. Places is useful for padding the
    1121. 

  1121. 	 *								return value with leading 0s (zeros).
    1122. 

  1122. 	 *								If places is not an integer, it is truncated.
    1123. 

  1123. 	 *								If places is nonnumeric, BIN2HEX returns the #VALUE! error value.
    1124. 

  1124. 	 *								If places is negative, BIN2HEX returns the #NUM! error value.
    1125. 

  1125. 	 * @return	string
    1126. 

  1126. 	 */
    1127. 

  1127. 	public static function BINTOHEX($x, $places=NULL) {
    1128. 

  1128. 		$x	= PHPExcel_Calculation_Functions::flattenSingleValue($x);
    1129. 

  1129. 		$places	= PHPExcel_Calculation_Functions::flattenSingleValue($places);
    1130. 

  1130. 

  1131. 		if (is_bool($x)) {
    1132. 

  1132. 			if (PHPExcel_Calculation_Functions::getCompatibilityMode() == PHPExcel_Calculation_Functions::COMPATIBILITY_OPENOFFICE) {
    1133. 

  1133. 				$x = (int) $x;
    1134. 

  1134. 			} else {
    1135. 

  1135. 				return PHPExcel_Calculation_Functions::VALUE();
    1136. 

  1136. 			}
    1137. 

  1137. 		}
    1138. 

  1138. 		if (PHPExcel_Calculation_Functions::getCompatibilityMode() == PHPExcel_Calculation_Functions::COMPATIBILITY_GNUMERIC) {
    1139. 

  1139. 			$x = floor($x);
    1140. 

  1140. 		}
    1141. 

  1141. 		$x = (string) $x;
    1142. 

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

  1143. 			return PHPExcel_Calculation_Functions::NaN();
    1144. 

  1144. 		}
    1145. 

  1145. 		if (strlen($x) > 10) {
    1146. 

  1146. 			return PHPExcel_Calculation_Functions::NaN();
    1147. 

  1147. 		} elseif (strlen($x) == 10) {
    1148. 

  1148. 			//	Two's Complement
    1149. 

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

  1150. 		}
    1151. 

  1151. 		$hexVal = (string) strtoupper(dechex(bindec($x)));
    1152. 

  1152. 

  1153. 		return self::_nbrConversionFormat($hexVal,$places);
    1154. 

  1154. 	}	//	function BINTOHEX()
    1155. 

  1155. 

  1156. 

  1157. 	/**
    1158. 

  1158. 	 * BINTOOCT
    1159. 

  1159. 	 *
    1160. 

  1160. 	 * Return a binary value as octal.
    1161. 

  1161. 	 *
    1162. 

  1162. 	 * Excel Function:
    1163. 

  1163. 	 *		BIN2OCT(x[,places])
    1164. 

  1164. 	 *
    1165. 

  1165. 	 * @access	public
    1166. 

  1166. 	 * @category Engineering Functions
    1167. 

  1167. 	 * @param	string		$x		The binary number (as a string) that you want to convert. The number
    1168. 

  1168. 	 *								cannot contain more than 10 characters (10 bits). The most significant
    1169. 

  1169. 	 *								bit of number is the sign bit. The remaining 9 bits are magnitude bits.
    1170. 

  1170. 	 *								Negative numbers are represented using two's-complement notation.
    1171. 

  1171. 	 *								If number is not a valid binary number, or if number contains more than
    1172. 

  1172. 	 *								10 characters (10 bits), BIN2OCT returns the #NUM! error value.
    1173. 

  1173. 	 * @param	integer		$places	The number of characters to use. If places is omitted, BIN2OCT uses the
    1174. 

  1174. 	 *								minimum number of characters necessary. Places is useful for padding the
    1175. 

  1175. 	 *								return value with leading 0s (zeros).
    1176. 

  1176. 	 *								If places is not an integer, it is truncated.
    1177. 

  1177. 	 *								If places is nonnumeric, BIN2OCT returns the #VALUE! error value.
    1178. 

  1178. 	 *								If places is negative, BIN2OCT returns the #NUM! error value.
    1179. 

  1179. 	 * @return	string
    1180. 

  1180. 	 */
    1181. 

  1181. 	public static function BINTOOCT($x, $places=NULL) {
    1182. 

  1182. 		$x	= PHPExcel_Calculation_Functions::flattenSingleValue($x);
    1183. 

  1183. 		$places	= PHPExcel_Calculation_Functions::flattenSingleValue($places);
    1184. 

  1184. 

  1185. 		if (is_bool($x)) {
    1186. 

  1186. 			if (PHPExcel_Calculation_Functions::getCompatibilityMode() == PHPExcel_Calculation_Functions::COMPATIBILITY_OPENOFFICE) {
    1187. 

  1187. 				$x = (int) $x;
    1188. 

  1188. 			} else {
    1189. 

  1189. 				return PHPExcel_Calculation_Functions::VALUE();
    1190. 

  1190. 			}
    1191. 

  1191. 		}
    1192. 

  1192. 		if (PHPExcel_Calculation_Functions::getCompatibilityMode() == PHPExcel_Calculation_Functions::COMPATIBILITY_GNUMERIC) {
    1193. 

  1193. 			$x = floor($x);
    1194. 

  1194. 		}
    1195. 

  1195. 		$x = (string) $x;
    1196. 

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

  1197. 			return PHPExcel_Calculation_Functions::NaN();
    1198. 

  1198. 		}
    1199. 

  1199. 		if (strlen($x) > 10) {
    1200. 

  1200. 			return PHPExcel_Calculation_Functions::NaN();
    1201. 

  1201. 		} elseif (strlen($x) == 10) {
    1202. 

  1202. 			//	Two's Complement
    1203. 

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

  1204. 		}
    1205. 

  1205. 		$octVal = (string) decoct(bindec($x));
    1206. 

  1206. 

  1207. 		return self::_nbrConversionFormat($octVal,$places);
    1208. 

  1208. 	}	//	function BINTOOCT()
    1209. 

  1209. 

  1210. 

  1211. 	/**
    1212. 

  1212. 	 * DECTOBIN
    1213. 

  1213. 	 *
    1214. 

  1214. 	 * Return a decimal value as binary.
    1215. 

  1215. 	 *
    1216. 

  1216. 	 * Excel Function:
    1217. 

  1217. 	 *		DEC2BIN(x[,places])
    1218. 

  1218. 	 *
    1219. 

  1219. 	 * @access	public
    1220. 

  1220. 	 * @category Engineering Functions
    1221. 

  1221. 	 * @param	string		$x		The decimal integer you want to convert. If number is negative,
    1222. 

  1222. 	 *								valid place values are ignored and DEC2BIN returns a 10-character
    1223. 

  1223. 	 *								(10-bit) binary number in which the most significant bit is the sign
    1224. 

  1224. 	 *								bit. The remaining 9 bits are magnitude bits. Negative numbers are
    1225. 

  1225. 	 *								represented using two's-complement notation.
    1226. 

  1226. 	 *								If number < -512 or if number > 511, DEC2BIN returns the #NUM! error
    1227. 

  1227. 	 *								value.
    1228. 

  1228. 	 *								If number is nonnumeric, DEC2BIN returns the #VALUE! error value.
    1229. 

  1229. 	 *								If DEC2BIN requires more than places characters, it returns the #NUM!
    1230. 

  1230. 	 *								error value.
    1231. 

  1231. 	 * @param	integer		$places	The number of characters to use. If places is omitted, DEC2BIN uses
    1232. 

  1232. 	 *								the minimum number of characters necessary. Places is useful for
    1233. 

  1233. 	 *								padding the return value with leading 0s (zeros).
    1234. 

  1234. 	 *								If places is not an integer, it is truncated.
    1235. 

  1235. 	 *								If places is nonnumeric, DEC2BIN returns the #VALUE! error value.
    1236. 

  1236. 	 *								If places is zero or negative, DEC2BIN returns the #NUM! error value.
    1237. 

  1237. 	 * @return	string
    1238. 

  1238. 	 */
    1239. 

  1239. 	public static function DECTOBIN($x, $places=NULL) {
    1240. 

  1240. 		$x	= PHPExcel_Calculation_Functions::flattenSingleValue($x);
    1241. 

  1241. 		$places	= PHPExcel_Calculation_Functions::flattenSingleValue($places);
    1242. 

  1242. 

  1243. 		if (is_bool($x)) {
    1244. 

  1244. 			if (PHPExcel_Calculation_Functions::getCompatibilityMode() == PHPExcel_Calculation_Functions::COMPATIBILITY_OPENOFFICE) {
    1245. 

  1245. 				$x = (int) $x;
    1246. 

  1246. 			} else {
    1247. 

  1247. 				return PHPExcel_Calculation_Functions::VALUE();
    1248. 

  1248. 			}
    1249. 

  1249. 		}
    1250. 

  1250. 		$x = (string) $x;
    1251. 

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

  1252. 			return PHPExcel_Calculation_Functions::VALUE();
    1253. 

  1253. 		}
    1254. 

  1254. 		$x = (string) floor($x);
    1255. 

  1255. 		$r = decbin($x);
    1256. 

  1256. 		if (strlen($r) == 32) {
    1257. 

  1257. 			//	Two's Complement
    1258. 

  1258. 			$r = substr($r,-10);
    1259. 

  1259. 		} elseif (strlen($r) > 11) {
    1260. 

  1260. 			return PHPExcel_Calculation_Functions::NaN();
    1261. 

  1261. 		}
    1262. 

  1262. 

  1263. 		return self::_nbrConversionFormat($r,$places);
    1264. 

  1264. 	}	//	function DECTOBIN()
    1265. 

  1265. 

  1266. 

  1267. 	/**
    1268. 

  1268. 	 * DECTOHEX
    1269. 

  1269. 	 *
    1270. 

  1270. 	 * Return a decimal value as hex.
    1271. 

  1271. 	 *
    1272. 

  1272. 	 * Excel Function:
    1273. 

  1273. 	 *		DEC2HEX(x[,places])
    1274. 

  1274. 	 *
    1275. 

  1275. 	 * @access	public
    1276. 

  1276. 	 * @category Engineering Functions
    1277. 

  1277. 	 * @param	string		$x		The decimal integer you want to convert. If number is negative,
    1278. 

  1278. 	 *								places is ignored and DEC2HEX returns a 10-character (40-bit)
    1279. 

  1279. 	 *								hexadecimal number in which the most significant bit is the sign
    1280. 

  1280. 	 *								bit. The remaining 39 bits are magnitude bits. Negative numbers
    1281. 

  1281. 	 *								are represented using two's-complement notation.
    1282. 

  1282. 	 *								If number < -549,755,813,888 or if number > 549,755,813,887,
    1283. 

  1283. 	 *								DEC2HEX returns the #NUM! error value.
    1284. 

  1284. 	 *								If number is nonnumeric, DEC2HEX returns the #VALUE! error value.
    1285. 

  1285. 	 *								If DEC2HEX requires more than places characters, it returns the
    1286. 

  1286. 	 *								#NUM! error value.
    1287. 

  1287. 	 * @param	integer		$places	The number of characters to use. If places is omitted, DEC2HEX uses
    1288. 

  1288. 	 *								the minimum number of characters necessary. Places is useful for
    1289. 

  1289. 	 *								padding the return value with leading 0s (zeros).
    1290. 

  1290. 	 *								If places is not an integer, it is truncated.
    1291. 

  1291. 	 *								If places is nonnumeric, DEC2HEX returns the #VALUE! error value.
    1292. 

  1292. 	 *								If places is zero or negative, DEC2HEX returns the #NUM! error value.
    1293. 

  1293. 	 * @return	string
    1294. 

  1294. 	 */
    1295. 

  1295. 	public static function DECTOHEX($x, $places=null) {
    1296. 

  1296. 		$x	= PHPExcel_Calculation_Functions::flattenSingleValue($x);
    1297. 

  1297. 		$places	= PHPExcel_Calculation_Functions::flattenSingleValue($places);
    1298. 

  1298. 

  1299. 		if (is_bool($x)) {
    1300. 

  1300. 			if (PHPExcel_Calculation_Functions::getCompatibilityMode() == PHPExcel_Calculation_Functions::COMPATIBILITY_OPENOFFICE) {
    1301. 

  1301. 				$x = (int) $x;
    1302. 

  1302. 			} else {
    1303. 

  1303. 				return PHPExcel_Calculation_Functions::VALUE();
    1304. 

  1304. 			}
    1305. 

  1305. 		}
    1306. 

  1306. 		$x = (string) $x;
    1307. 

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

  1308. 			return PHPExcel_Calculation_Functions::VALUE();
    1309. 

  1309. 		}
    1310. 

  1310. 		$x = (string) floor($x);
    1311. 

  1311. 		$r = strtoupper(dechex($x));
    1312. 

  1312. 		if (strlen($r) == 8) {
    1313. 

  1313. 			//	Two's Complement
    1314. 

  1314. 			$r = 'FF'.$r;
    1315. 

  1315. 		}
    1316. 

  1316. 

  1317. 		return self::_nbrConversionFormat($r,$places);
    1318. 

  1318. 	}	//	function DECTOHEX()
    1319. 

  1319. 

  1320. 

  1321. 	/**
    1322. 

  1322. 	 * DECTOOCT
    1323. 

  1323. 	 *
    1324. 

  1324. 	 * Return an decimal value as octal.
    1325. 

  1325. 	 *
    1326. 

  1326. 	 * Excel Function:
    1327. 

  1327. 	 *		DEC2OCT(x[,places])
    1328. 

  1328. 	 *
    1329. 

  1329. 	 * @access	public
    1330. 

  1330. 	 * @category Engineering Functions
    1331. 

  1331. 	 * @param	string		$x		The decimal integer you want to convert. If number is negative,
    1332. 

  1332. 	 *								places is ignored and DEC2OCT returns a 10-character (30-bit)
    1333. 

  1333. 	 *								octal number in which the most significant bit is the sign bit.
    1334. 

  1334. 	 *								The remaining 29 bits are magnitude bits. Negative numbers are
    1335. 

  1335. 	 *								represented using two's-complement notation.
    1336. 

  1336. 	 *								If number < -536,870,912 or if number > 536,870,911, DEC2OCT
    1337. 

  1337. 	 *								returns the #NUM! error value.
    1338. 

  1338. 	 *								If number is nonnumeric, DEC2OCT returns the #VALUE! error value.
    1339. 

  1339. 	 *								If DEC2OCT requires more than places characters, it returns the
    1340. 

  1340. 	 *								#NUM! error value.
    1341. 

  1341. 	 * @param	integer		$places	The number of characters to use. If places is omitted, DEC2OCT uses
    1342. 

  1342. 	 *								the minimum number of characters necessary. Places is useful for
    1343. 

  1343. 	 *								padding the return value with leading 0s (zeros).
    1344. 

  1344. 	 *								If places is not an integer, it is truncated.
    1345. 

  1345. 	 *								If places is nonnumeric, DEC2OCT returns the #VALUE! error value.
    1346. 

  1346. 	 *								If places is zero or negative, DEC2OCT returns the #NUM! error value.
    1347. 

  1347. 	 * @return	string
    1348. 

  1348. 	 */
    1349. 

  1349. 	public static function DECTOOCT($x, $places=null) {
    1350. 

  1350. 		$x	= PHPExcel_Calculation_Functions::flattenSingleValue($x);
    1351. 

  1351. 		$places	= PHPExcel_Calculation_Functions::flattenSingleValue($places);
    1352. 

  1352. 

  1353. 		if (is_bool($x)) {
    1354. 

  1354. 			if (PHPExcel_Calculation_Functions::getCompatibilityMode() == PHPExcel_Calculation_Functions::COMPATIBILITY_OPENOFFICE) {
    1355. 

  1355. 				$x = (int) $x;
    1356. 

  1356. 			} else {
    1357. 

  1357. 				return PHPExcel_Calculation_Functions::VALUE();
    1358. 

  1358. 			}
    1359. 

  1359. 		}
    1360. 

  1360. 		$x = (string) $x;
    1361. 

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

  1362. 			return PHPExcel_Calculation_Functions::VALUE();
    1363. 

  1363. 		}
    1364. 

  1364. 		$x = (string) floor($x);
    1365. 

  1365. 		$r = decoct($x);
    1366. 

  1366. 		if (strlen($r) == 11) {
    1367. 

  1367. 			//	Two's Complement
    1368. 

  1368. 			$r = substr($r,-10);
    1369. 

  1369. 		}
    1370. 

  1370. 

  1371. 		return self::_nbrConversionFormat($r,$places);
    1372. 

  1372. 	}	//	function DECTOOCT()
    1373. 

  1373. 

  1374. 

  1375. 	/**
    1376. 

  1376. 	 * HEXTOBIN
    1377. 

  1377. 	 *
    1378. 

  1378. 	 * Return a hex value as binary.
    1379. 

  1379. 	 *
    1380. 

  1380. 	 * Excel Function:
    1381. 

  1381. 	 *		HEX2BIN(x[,places])
    1382. 

  1382. 	 *
    1383. 

  1383. 	 * @access	public
    1384. 

  1384. 	 * @category Engineering Functions
    1385. 

  1385. 	 * @param	string		$x			the hexadecimal number you want to convert. Number cannot
    1386. 

  1386. 	 *									contain more than 10 characters. The most significant bit of
    1387. 

  1387. 	 *									number is the sign bit (40th bit from the right). The remaining
    1388. 

  1388. 	 *									9 bits are magnitude bits. Negative numbers are represented
    1389. 

  1389. 	 *									using two's-complement notation.
    1390. 

  1390. 	 *									If number is negative, HEX2BIN ignores places and returns a
    1391. 

  1391. 	 *									10-character binary number.
    1392. 

  1392. 	 *									If number is negative, it cannot be less than FFFFFFFE00, and
    1393. 

  1393. 	 *									if number is positive, it cannot be greater than 1FF.
    1394. 

  1394. 	 *									If number is not a valid hexadecimal number, HEX2BIN returns
    1395. 

  1395. 	 *									the #NUM! error value.
    1396. 

  1396. 	 *									If HEX2BIN requires more than places characters, it returns
    1397. 

  1397. 	 *									the #NUM! error value.
    1398. 

  1398. 	 * @param	integer		$places		The number of characters to use. If places is omitted,
    1399. 

  1399. 	 *									HEX2BIN uses the minimum number of characters necessary. Places
    1400. 

  1400. 	 *									is useful for padding the return value with leading 0s (zeros).
    1401. 

  1401. 	 *									If places is not an integer, it is truncated.
    1402. 

  1402. 	 *									If places is nonnumeric, HEX2BIN returns the #VALUE! error value.
    1403. 

  1403. 	 *									If places is negative, HEX2BIN returns the #NUM! error value.
    1404. 

  1404. 	 * @return	string
    1405. 

  1405. 	 */
    1406. 

  1406. 	public static function HEXTOBIN($x, $places=null) {
    1407. 

  1407. 		$x	= PHPExcel_Calculation_Functions::flattenSingleValue($x);
    1408. 

  1408. 		$places	= PHPExcel_Calculation_Functions::flattenSingleValue($places);
    1409. 

  1409. 

  1410. 		if (is_bool($x)) {
    1411. 

  1411. 			return PHPExcel_Calculation_Functions::VALUE();
    1412. 

  1412. 		}
    1413. 

  1413. 		$x = (string) $x;
    1414. 

  1414. 		if (strlen($x) > preg_match_all('/[0123456789ABCDEF]/',strtoupper($x),$out)) {
    1415. 

  1415. 			return PHPExcel_Calculation_Functions::NaN();
    1416. 

  1416. 		}
    1417. 

  1417. 		$binVal = decbin(hexdec($x));
    1418. 

  1418. 

  1419. 		return substr(self::_nbrConversionFormat($binVal,$places),-10);
    1420. 

  1420. 	}	//	function HEXTOBIN()
    1421. 

  1421. 

  1422. 

  1423. 	/**
    1424. 

  1424. 	 * HEXTODEC
    1425. 

  1425. 	 *
    1426. 

  1426. 	 * Return a hex value as decimal.
    1427. 

  1427. 	 *
    1428. 

  1428. 	 * Excel Function:
    1429. 

  1429. 	 *		HEX2DEC(x)
    1430. 

  1430. 	 *
    1431. 

  1431. 	 * @access	public
    1432. 

  1432. 	 * @category Engineering Functions
    1433. 

  1433. 	 * @param	string		$x		The hexadecimal number you want to convert. This number cannot
    1434. 

  1434. 	 *								contain more than 10 characters (40 bits). The most significant
    1435. 

  1435. 	 *								bit of number is the sign bit. The remaining 39 bits are magnitude
    1436. 

  1436. 	 *								bits. Negative numbers are represented using two's-complement
    1437. 

  1437. 	 *								notation.
    1438. 

  1438. 	 *								If number is not a valid hexadecimal number, HEX2DEC returns the
    1439. 

  1439. 	 *								#NUM! error value.
    1440. 

  1440. 	 * @return	string
    1441. 

  1441. 	 */
    1442. 

  1442. 	public static function HEXTODEC($x) {
    1443. 

  1443. 		$x	= PHPExcel_Calculation_Functions::flattenSingleValue($x);
    1444. 

  1444. 

  1445. 		if (is_bool($x)) {
    1446. 

  1446. 			return PHPExcel_Calculation_Functions::VALUE();
    1447. 

  1447. 		}
    1448. 

  1448. 		$x = (string) $x;
    1449. 

  1449. 		if (strlen($x) > preg_match_all('/[0123456789ABCDEF]/',strtoupper($x),$out)) {
    1450. 

  1450. 			return PHPExcel_Calculation_Functions::NaN();
    1451. 

  1451. 		}
    1452. 

  1452. 		return hexdec($x);
    1453. 

  1453. 	}	//	function HEXTODEC()
    1454. 

  1454. 

  1455. 

  1456. 	/**
    1457. 

  1457. 	 * HEXTOOCT
    1458. 

  1458. 	 *
    1459. 

  1459. 	 * Return a hex value as octal.
    1460. 

  1460. 	 *
    1461. 

  1461. 	 * Excel Function:
    1462. 

  1462. 	 *		HEX2OCT(x[,places])
    1463. 

  1463. 	 *
    1464. 

  1464. 	 * @access	public
    1465. 

  1465. 	 * @category Engineering Functions
    1466. 

  1466. 	 * @param	string		$x			The hexadecimal number you want to convert. Number cannot
    1467. 

  1467. 	 *									contain more than 10 characters. The most significant bit of
    1468. 

  1468. 	 *									number is the sign bit. The remaining 39 bits are magnitude
    1469. 

  1469. 	 *									bits. Negative numbers are represented using two's-complement
    1470. 

  1470. 	 *									notation.
    1471. 

  1471. 	 *									If number is negative, HEX2OCT ignores places and returns a
    1472. 

  1472. 	 *									10-character octal number.
    1473. 

  1473. 	 *									If number is negative, it cannot be less than FFE0000000, and
    1474. 

  1474. 	 *									if number is positive, it cannot be greater than 1FFFFFFF.
    1475. 

  1475. 	 *									If number is not a valid hexadecimal number, HEX2OCT returns
    1476. 

  1476. 	 *									the #NUM! error value.
    1477. 

  1477. 	 *									If HEX2OCT requires more than places characters, it returns
    1478. 

  1478. 	 *									the #NUM! error value.
    1479. 

  1479. 	 * @param	integer		$places		The number of characters to use. If places is omitted, HEX2OCT
    1480. 

  1480. 	 *									uses the minimum number of characters necessary. Places is
    1481. 

  1481. 	 *									useful for padding the return value with leading 0s (zeros).
    1482. 

  1482. 	 *									If places is not an integer, it is truncated.
    1483. 

  1483. 	 *									If places is nonnumeric, HEX2OCT returns the #VALUE! error
    1484. 

  1484. 	 *									value.
    1485. 

  1485. 	 *									If places is negative, HEX2OCT returns the #NUM! error value.
    1486. 

  1486. 	 * @return	string
    1487. 

  1487. 	 */
    1488. 

  1488. 	public static function HEXTOOCT($x, $places=null) {
    1489. 

  1489. 		$x	= PHPExcel_Calculation_Functions::flattenSingleValue($x);
    1490. 

  1490. 		$places	= PHPExcel_Calculation_Functions::flattenSingleValue($places);
    1491. 

  1491. 

  1492. 		if (is_bool($x)) {
    1493. 

  1493. 			return PHPExcel_Calculation_Functions::VALUE();
    1494. 

  1494. 		}
    1495. 

  1495. 		$x = (string) $x;
    1496. 

  1496. 		if (strlen($x) > preg_match_all('/[0123456789ABCDEF]/',strtoupper($x),$out)) {
    1497. 

  1497. 			return PHPExcel_Calculation_Functions::NaN();
    1498. 

  1498. 		}
    1499. 

  1499. 		$octVal = decoct(hexdec($x));
    1500. 

  1500. 

  1501. 		return self::_nbrConversionFormat($octVal,$places);
    1502. 

  1502. 	}	//	function HEXTOOCT()
    1503. 

  1503. 

  1504. 

  1505. 	/**
    1506. 

  1506. 	 * OCTTOBIN
    1507. 

  1507. 	 *
    1508. 

  1508. 	 * Return an octal value as binary.
    1509. 

  1509. 	 *
    1510. 

  1510. 	 * Excel Function:
    1511. 

  1511. 	 *		OCT2BIN(x[,places])
    1512. 

  1512. 	 *
    1513. 

  1513. 	 * @access	public
    1514. 

  1514. 	 * @category Engineering Functions
    1515. 

  1515. 	 * @param	string		$x			The octal number you want to convert. Number may not
    1516. 

  1516. 	 *									contain more than 10 characters. The most significant
    1517. 

  1517. 	 *									bit of number is the sign bit. The remaining 29 bits
    1518. 

  1518. 	 *									are magnitude bits. Negative numbers are represented
    1519. 

  1519. 	 *									using two's-complement notation.
    1520. 

  1520. 	 *									If number is negative, OCT2BIN ignores places and returns
    1521. 

  1521. 	 *									a 10-character binary number.
    1522. 

  1522. 	 *									If number is negative, it cannot be less than 7777777000,
    1523. 

  1523. 	 *									and if number is positive, it cannot be greater than 777.
    1524. 

  1524. 	 *									If number is not a valid octal number, OCT2BIN returns
    1525. 

  1525. 	 *									the #NUM! error value.
    1526. 

  1526. 	 *									If OCT2BIN requires more than places characters, it
    1527. 

  1527. 	 *									returns the #NUM! error value.
    1528. 

  1528. 	 * @param	integer		$places		The number of characters to use. If places is omitted,
    1529. 

  1529. 	 *									OCT2BIN uses the minimum number of characters necessary.
    1530. 

  1530. 	 *									Places is useful for padding the return value with
    1531. 

  1531. 	 *									leading 0s (zeros).
    1532. 

  1532. 	 *									If places is not an integer, it is truncated.
    1533. 

  1533. 	 *									If places is nonnumeric, OCT2BIN returns the #VALUE!
    1534. 

  1534. 	 *									error value.
    1535. 

  1535. 	 *									If places is negative, OCT2BIN returns the #NUM! error
    1536. 

  1536. 	 *									value.
    1537. 

  1537. 	 * @return	string
    1538. 

  1538. 	 */
    1539. 

  1539. 	public static function OCTTOBIN($x, $places=null) {
    1540. 

  1540. 		$x	= PHPExcel_Calculation_Functions::flattenSingleValue($x);
    1541. 

  1541. 		$places	= PHPExcel_Calculation_Functions::flattenSingleValue($places);
    1542. 

  1542. 

  1543. 		if (is_bool($x)) {
    1544. 

  1544. 			return PHPExcel_Calculation_Functions::VALUE();
    1545. 

  1545. 		}
    1546. 

  1546. 		$x = (string) $x;
    1547. 

  1547. 		if (preg_match_all('/[01234567]/',$x,$out) != strlen($x)) {
    1548. 

  1548. 			return PHPExcel_Calculation_Functions::NaN();
    1549. 

  1549. 		}
    1550. 

  1550. 		$r = decbin(octdec($x));
    1551. 

  1551. 

  1552. 		return self::_nbrConversionFormat($r,$places);
    1553. 

  1553. 	}	//	function OCTTOBIN()
    1554. 

  1554. 

  1555. 

  1556. 	/**
    1557. 

  1557. 	 * OCTTODEC
    1558. 

  1558. 	 *
    1559. 

  1559. 	 * Return an octal value as decimal.
    1560. 

  1560. 	 *
    1561. 

  1561. 	 * Excel Function:
    1562. 

  1562. 	 *		OCT2DEC(x)
    1563. 

  1563. 	 *
    1564. 

  1564. 	 * @access	public
    1565. 

  1565. 	 * @category Engineering Functions
    1566. 

  1566. 	 * @param	string		$x		The octal number you want to convert. Number may not contain
    1567. 

  1567. 	 *								more than 10 octal characters (30 bits). The most significant
    1568. 

  1568. 	 *								bit of number is the sign bit. The remaining 29 bits are
    1569. 

  1569. 	 *								magnitude bits. Negative numbers are represented using
    1570. 

  1570. 	 *								two's-complement notation.
    1571. 

  1571. 	 *								If number is not a valid octal number, OCT2DEC returns the
    1572. 

  1572. 	 *								#NUM! error value.
    1573. 

  1573. 	 * @return	string
    1574. 

  1574. 	 */
    1575. 

  1575. 	public static function OCTTODEC($x) {
    1576. 

  1576. 		$x	= PHPExcel_Calculation_Functions::flattenSingleValue($x);
    1577. 

  1577. 

  1578. 		if (is_bool($x)) {
    1579. 

  1579. 			return PHPExcel_Calculation_Functions::VALUE();
    1580. 

  1580. 		}
    1581. 

  1581. 		$x = (string) $x;
    1582. 

  1582. 		if (preg_match_all('/[01234567]/',$x,$out) != strlen($x)) {
    1583. 

  1583. 			return PHPExcel_Calculation_Functions::NaN();
    1584. 

  1584. 		}
    1585. 

  1585. 		return octdec($x);
    1586. 

  1586. 	}	//	function OCTTODEC()
    1587. 

  1587. 

  1588. 

  1589. 	/**
    1590. 

  1590. 	 * OCTTOHEX
    1591. 

  1591. 	 *
    1592. 

  1592. 	 * Return an octal value as hex.
    1593. 

  1593. 	 *
    1594. 

  1594. 	 * Excel Function:
    1595. 

  1595. 	 *		OCT2HEX(x[,places])
    1596. 

  1596. 	 *
    1597. 

  1597. 	 * @access	public
    1598. 

  1598. 	 * @category Engineering Functions
    1599. 

  1599. 	 * @param	string		$x			The octal number you want to convert. Number may not contain
    1600. 

  1600. 	 *									more than 10 octal characters (30 bits). The most significant
    1601. 

  1601. 	 *									bit of number is the sign bit. The remaining 29 bits are
    1602. 

  1602. 	 *									magnitude bits. Negative numbers are represented using
    1603. 

  1603. 	 *									two's-complement notation.
    1604. 

  1604. 	 *									If number is negative, OCT2HEX ignores places and returns a
    1605. 

  1605. 	 *									10-character hexadecimal number.
    1606. 

  1606. 	 *									If number is not a valid octal number, OCT2HEX returns the
    1607. 

  1607. 	 *									#NUM! error value.
    1608. 

  1608. 	 *									If OCT2HEX requires more than places characters, it returns
    1609. 

  1609. 	 *									the #NUM! error value.
    1610. 

  1610. 	 * @param	integer		$places		The number of characters to use. If places is omitted, OCT2HEX
    1611. 

  1611. 	 *									uses the minimum number of characters necessary. Places is useful
    1612. 

  1612. 	 *									for padding the return value with leading 0s (zeros).
    1613. 

  1613. 	 *									If places is not an integer, it is truncated.
    1614. 

  1614. 	 *									If places is nonnumeric, OCT2HEX returns the #VALUE! error value.
    1615. 

  1615. 	 *									If places is negative, OCT2HEX returns the #NUM! error value.
    1616. 

  1616. 	 * @return	string
    1617. 

  1617. 	 */
    1618. 

  1618. 	public static function OCTTOHEX($x, $places=null) {
    1619. 

  1619. 		$x	= PHPExcel_Calculation_Functions::flattenSingleValue($x);
    1620. 

  1620. 		$places	= PHPExcel_Calculation_Functions::flattenSingleValue($places);
    1621. 

  1621. 

  1622. 		if (is_bool($x)) {
    1623. 

  1623. 			return PHPExcel_Calculation_Functions::VALUE();
    1624. 

  1624. 		}
    1625. 

  1625. 		$x = (string) $x;
    1626. 

  1626. 		if (preg_match_all('/[01234567]/',$x,$out) != strlen($x)) {
    1627. 

  1627. 			return PHPExcel_Calculation_Functions::NaN();
    1628. 

  1628. 		}
    1629. 

  1629. 		$hexVal = strtoupper(dechex(octdec($x)));
    1630. 

  1630. 

  1631. 		return self::_nbrConversionFormat($hexVal,$places);
    1632. 

  1632. 	}	//	function OCTTOHEX()
    1633. 

  1633. 

  1634. 

  1635. 	/**
    1636. 

  1636. 	 * COMPLEX
    1637. 

  1637. 	 *
    1638. 

  1638. 	 * Converts real and imaginary coefficients into a complex number of the form x + yi or x + yj.
    1639. 

  1639. 	 *
    1640. 

  1640. 	 * Excel Function:
    1641. 

  1641. 	 *		COMPLEX(realNumber,imaginary[,places])
    1642. 

  1642. 	 *
    1643. 

  1643. 	 * @access	public
    1644. 

  1644. 	 * @category Engineering Functions
    1645. 

  1645. 	 * @param	float		$realNumber		The real coefficient of the complex number.
    1646. 

  1646. 	 * @param	float		$imaginary		The imaginary coefficient of the complex number.
    1647. 

  1647. 	 * @param	string		$suffix			The suffix for the imaginary component of the complex number.
    1648. 

  1648. 	 *										If omitted, the suffix is assumed to be "i".
    1649. 

  1649. 	 * @return	string
    1650. 

  1650. 	 */
    1651. 

  1651. 	public static function COMPLEX($realNumber=0.0, $imaginary=0.0, $suffix='i') {
    1652. 

  1652. 		$realNumber	= (is_null($realNumber))	? 0.0 :	PHPExcel_Calculation_Functions::flattenSingleValue($realNumber);
    1653. 

  1653. 		$imaginary	= (is_null($imaginary))		? 0.0 :	PHPExcel_Calculation_Functions::flattenSingleValue($imaginary);
    1654. 

  1654. 		$suffix		= (is_null($suffix))		? 'i' :	PHPExcel_Calculation_Functions::flattenSingleValue($suffix);
    1655. 

  1655. 

  1656. 		if (((is_numeric($realNumber)) && (is_numeric($imaginary))) &&
    1657. 

  1657. 			(($suffix == 'i') || ($suffix == 'j') || ($suffix == ''))) {
    1658. 

  1658. 			$realNumber	= (float) $realNumber;
    1659. 

  1659. 			$imaginary	= (float) $imaginary;
    1660. 

  1660. 

  1661. 			if ($suffix == '') $suffix = 'i';
    1662. 

  1662. 			if ($realNumber == 0.0) {
    1663. 

  1663. 				if ($imaginary == 0.0) {
    1664. 

  1664. 					return (string) '0';
    1665. 

  1665. 				} elseif ($imaginary == 1.0) {
    1666. 

  1666. 					return (string) $suffix;
    1667. 

  1667. 				} elseif ($imaginary == -1.0) {
    1668. 

  1668. 					return (string) '-'.$suffix;
    1669. 

  1669. 				}
    1670. 

  1670. 				return (string) $imaginary.$suffix;
    1671. 

  1671. 			} elseif ($imaginary == 0.0) {
    1672. 

  1672. 				return (string) $realNumber;
    1673. 

  1673. 			} elseif ($imaginary == 1.0) {
    1674. 

  1674. 				return (string) $realNumber.'+'.$suffix;
    1675. 

  1675. 			} elseif ($imaginary == -1.0) {
    1676. 

  1676. 				return (string) $realNumber.'-'.$suffix;
    1677. 

  1677. 			}
    1678. 

  1678. 			if ($imaginary > 0) { $imaginary = (string) '+'.$imaginary; }
    1679. 

  1679. 			return (string) $realNumber.$imaginary.$suffix;
    1680. 

  1680. 		}
    1681. 

  1681. 

  1682. 		return PHPExcel_Calculation_Functions::VALUE();
    1683. 

  1683. 	}	//	function COMPLEX()
    1684. 

  1684. 

  1685. 

  1686. 	/**
    1687. 

  1687. 	 * IMAGINARY
    1688. 

  1688. 	 *
    1689. 

  1689. 	 * Returns the imaginary coefficient of a complex number in x + yi or x + yj text format.
    1690. 

  1690. 	 *
    1691. 

  1691. 	 * Excel Function:
    1692. 

  1692. 	 *		IMAGINARY(complexNumber)
    1693. 

  1693. 	 *
    1694. 

  1694. 	 * @access	public
    1695. 

  1695. 	 * @category Engineering Functions
    1696. 

  1696. 	 * @param	string		$complexNumber	The complex number for which you want the imaginary
    1697. 

  1697. 	 * 										coefficient.
    1698. 

  1698. 	 * @return	float
    1699. 

  1699. 	 */
    1700. 

  1700. 	public static function IMAGINARY($complexNumber) {
    1701. 

  1701. 		$complexNumber	= PHPExcel_Calculation_Functions::flattenSingleValue($complexNumber);
    1702. 

  1702. 

  1703. 		$parsedComplex = self::_parseComplex($complexNumber);
    1704. 

  1704. 		return $parsedComplex['imaginary'];
    1705. 

  1705. 	}	//	function IMAGINARY()
    1706. 

  1706. 

  1707. 

  1708. 	/**
    1709. 

  1709. 	 * IMREAL
    1710. 

  1710. 	 *
    1711. 

  1711. 	 * Returns the real coefficient of a complex number in x + yi or x + yj text format.
    1712. 

  1712. 	 *
    1713. 

  1713. 	 * Excel Function:
    1714. 

  1714. 	 *		IMREAL(complexNumber)
    1715. 

  1715. 	 *
    1716. 

  1716. 	 * @access	public
    1717. 

  1717. 	 * @category Engineering Functions
    1718. 

  1718. 	 * @param	string		$complexNumber	The complex number for which you want the real coefficient.
    1719. 

  1719. 	 * @return	float
    1720. 

  1720. 	 */
    1721. 

  1721. 	public static function IMREAL($complexNumber) {
    1722. 

  1722. 		$complexNumber	= PHPExcel_Calculation_Functions::flattenSingleValue($complexNumber);
    1723. 

  1723. 

  1724. 		$parsedComplex = self::_parseComplex($complexNumber);
    1725. 

  1725. 		return $parsedComplex['real'];
    1726. 

  1726. 	}	//	function IMREAL()
    1727. 

  1727. 

  1728. 

  1729. 	/**
    1730. 

  1730. 	 * IMABS
    1731. 

  1731. 	 *
    1732. 

  1732. 	 * Returns the absolute value (modulus) of a complex number in x + yi or x + yj text format.
    1733. 

  1733. 	 *
    1734. 

  1734. 	 * Excel Function:
    1735. 

  1735. 	 *		IMABS(complexNumber)
    1736. 

  1736. 	 *
    1737. 

  1737. 	 * @param	string		$complexNumber	The complex number for which you want the absolute value.
    1738. 

  1738. 	 * @return	float
    1739. 

  1739. 	 */
    1740. 

  1740. 	public static function IMABS($complexNumber) {
    1741. 

  1741. 		$complexNumber	= PHPExcel_Calculation_Functions::flattenSingleValue($complexNumber);
    1742. 

  1742. 

  1743. 		$parsedComplex = self::_parseComplex($complexNumber);
    1744. 

  1744. 

  1745. 		return sqrt(($parsedComplex['real'] * $parsedComplex['real']) + ($parsedComplex['imaginary'] * $parsedComplex['imaginary']));
    1746. 

  1746. 	}	//	function IMABS()
    1747. 

  1747. 

  1748. 

  1749. 	/**
    1750. 

  1750. 	 * IMARGUMENT
    1751. 

  1751. 	 *
    1752. 

  1752. 	 * Returns the argument theta of a complex number, i.e. the angle in radians from the real
    1753. 

  1753. 	 * axis to the representation of the number in polar coordinates.
    1754. 

  1754. 	 *
    1755. 

  1755. 	 * Excel Function:
    1756. 

  1756. 	 *		IMARGUMENT(complexNumber)
    1757. 

  1757. 	 *
    1758. 

  1758. 	 * @param	string		$complexNumber	The complex number for which you want the argument theta.
    1759. 

  1759. 	 * @return	float
    1760. 

  1760. 	 */
    1761. 

  1761. 	public static function IMARGUMENT($complexNumber) {
    1762. 

  1762. 		$complexNumber	= PHPExcel_Calculation_Functions::flattenSingleValue($complexNumber);
    1763. 

  1763. 

  1764. 		$parsedComplex = self::_parseComplex($complexNumber);
    1765. 

  1765. 

  1766. 		if ($parsedComplex['real'] == 0.0) {
    1767. 

  1767. 			if ($parsedComplex['imaginary'] == 0.0) {
    1768. 

  1768. 				return 0.0;
    1769. 

  1769. 			} elseif($parsedComplex['imaginary'] < 0.0) {
    1770. 

  1770. 				return M_PI / -2;
    1771. 

  1771. 			} else {
    1772. 

  1772. 				return M_PI / 2;
    1773. 

  1773. 			}
    1774. 

  1774. 		} elseif ($parsedComplex['real'] > 0.0) {
    1775. 

  1775. 			return atan($parsedComplex['imaginary'] / $parsedComplex['real']);
    1776. 

  1776. 		} elseif ($parsedComplex['imaginary'] < 0.0) {
    1777. 

  1777. 			return 0 - (M_PI - atan(abs($parsedComplex['imaginary']) / abs($parsedComplex['real'])));
    1778. 

  1778. 		} else {
    1779. 

  1779. 			return M_PI - atan($parsedComplex['imaginary'] / abs($parsedComplex['real']));
    1780. 

  1780. 		}
    1781. 

  1781. 	}	//	function IMARGUMENT()
    1782. 

  1782. 

  1783. 

  1784. 	/**
    1785. 

  1785. 	 * IMCONJUGATE
    1786. 

  1786. 	 *
    1787. 

  1787. 	 * Returns the complex conjugate of a complex number in x + yi or x + yj text format.
    1788. 

  1788. 	 *
    1789. 

  1789. 	 * Excel Function:
    1790. 

  1790. 	 *		IMCONJUGATE(complexNumber)
    1791. 

  1791. 	 *
    1792. 

  1792. 	 * @param	string		$complexNumber	The complex number for which you want the conjugate.
    1793. 

  1793. 	 * @return	string
    1794. 

  1794. 	 */
    1795. 

  1795. 	public static function IMCONJUGATE($complexNumber) {
    1796. 

  1796. 		$complexNumber	= PHPExcel_Calculation_Functions::flattenSingleValue($complexNumber);
    1797. 

  1797. 

  1798. 		$parsedComplex = self::_parseComplex($complexNumber);
    1799. 

  1799. 

  1800. 		if ($parsedComplex['imaginary'] == 0.0) {
    1801. 

  1801. 			return $parsedComplex['real'];
    1802. 

  1802. 		} else {
    1803. 

  1803. 			return self::_cleanComplex( self::COMPLEX( $parsedComplex['real'],
    1804. 

  1804. 													   0 - $parsedComplex['imaginary'],
    1805. 

  1805. 													   $parsedComplex['suffix']
    1806. 

  1806. 													 )
    1807. 

  1807. 									  );
    1808. 

  1808. 		}
    1809. 

  1809. 	}	//	function IMCONJUGATE()
    1810. 

  1810. 

  1811. 

  1812. 	/**
    1813. 

  1813. 	 * IMCOS
    1814. 

  1814. 	 *
    1815. 

  1815. 	 * Returns the cosine of a complex number in x + yi or x + yj text format.
    1816. 

  1816. 	 *
    1817. 

  1817. 	 * Excel Function:
    1818. 

  1818. 	 *		IMCOS(complexNumber)
    1819. 

  1819. 	 *
    1820. 

  1820. 	 * @param	string		$complexNumber	The complex number for which you want the cosine.
    1821. 

  1821. 	 * @return	string|float
    1822. 

  1822. 	 */
    1823. 

  1823. 	public static function IMCOS($complexNumber) {
    1824. 

  1824. 		$complexNumber	= PHPExcel_Calculation_Functions::flattenSingleValue($complexNumber);
    1825. 

  1825. 

  1826. 		$parsedComplex = self::_parseComplex($complexNumber);
    1827. 

  1827. 

  1828. 		if ($parsedComplex['imaginary'] == 0.0) {
    1829. 

  1829. 			return cos($parsedComplex['real']);
    1830. 

  1830. 		} else {
    1831. 

  1831. 			return self::IMCONJUGATE(self::COMPLEX(cos($parsedComplex['real']) * cosh($parsedComplex['imaginary']),sin($parsedComplex['real']) * sinh($parsedComplex['imaginary']),$parsedComplex['suffix']));
    1832. 

  1832. 		}
    1833. 

  1833. 	}	//	function IMCOS()
    1834. 

  1834. 

  1835. 

  1836. 	/**
    1837. 

  1837. 	 * IMSIN
    1838. 

  1838. 	 *
    1839. 

  1839. 	 * Returns the sine of a complex number in x + yi or x + yj text format.
    1840. 

  1840. 	 *
    1841. 

  1841. 	 * Excel Function:
    1842. 

  1842. 	 *		IMSIN(complexNumber)
    1843. 

  1843. 	 *
    1844. 

  1844. 	 * @param	string		$complexNumber	The complex number for which you want the sine.
    1845. 

  1845. 	 * @return	string|float
    1846. 

  1846. 	 */
    1847. 

  1847. 	public static function IMSIN($complexNumber) {
    1848. 

  1848. 		$complexNumber	= PHPExcel_Calculation_Functions::flattenSingleValue($complexNumber);
    1849. 

  1849. 

  1850. 		$parsedComplex = self::_parseComplex($complexNumber);
    1851. 

  1851. 

  1852. 		if ($parsedComplex['imaginary'] == 0.0) {
    1853. 

  1853. 			return sin($parsedComplex['real']);
    1854. 

  1854. 		} else {
    1855. 

  1855. 			return self::COMPLEX(sin($parsedComplex['real']) * cosh($parsedComplex['imaginary']),cos($parsedComplex['real']) * sinh($parsedComplex['imaginary']),$parsedComplex['suffix']);
    1856. 

  1856. 		}
    1857. 

  1857. 	}	//	function IMSIN()
    1858. 

  1858. 

  1859. 

  1860. 	/**
    1861. 

  1861. 	 * IMSQRT
    1862. 

  1862. 	 *
    1863. 

  1863. 	 * Returns the square root of a complex number in x + yi or x + yj text format.
    1864. 

  1864. 	 *
    1865. 

  1865. 	 * Excel Function:
    1866. 

  1866. 	 *		IMSQRT(complexNumber)
    1867. 

  1867. 	 *
    1868. 

  1868. 	 * @param	string		$complexNumber	The complex number for which you want the square root.
    1869. 

  1869. 	 * @return	string
    1870. 

  1870. 	 */
    1871. 

  1871. 	public static function IMSQRT($complexNumber) {
    1872. 

  1872. 		$complexNumber	= PHPExcel_Calculation_Functions::flattenSingleValue($complexNumber);
    1873. 

  1873. 

  1874. 		$parsedComplex = self::_parseComplex($complexNumber);
    1875. 

  1875. 

  1876. 		$theta = self::IMARGUMENT($complexNumber);
    1877. 

  1877. 		$d1 = cos($theta / 2);
    1878. 

  1878. 		$d2 = sin($theta / 2);
    1879. 

  1879. 		$r = sqrt(sqrt(($parsedComplex['real'] * $parsedComplex['real']) + ($parsedComplex['imaginary'] * $parsedComplex['imaginary'])));
    1880. 

  1880. 

  1881. 		if ($parsedComplex['suffix'] == '') {
    1882. 

  1882. 			return self::COMPLEX($d1 * $r,$d2 * $r);
    1883. 

  1883. 		} else {
    1884. 

  1884. 			return self::COMPLEX($d1 * $r,$d2 * $r,$parsedComplex['suffix']);
    1885. 

  1885. 		}
    1886. 

  1886. 	}	//	function IMSQRT()
    1887. 

  1887. 

  1888. 

  1889. 	/**
    1890. 

  1890. 	 * IMLN
    1891. 

  1891. 	 *
    1892. 

  1892. 	 * Returns the natural logarithm of a complex number in x + yi or x + yj text format.
    1893. 

  1893. 	 *
    1894. 

  1894. 	 * Excel Function:
    1895. 

  1895. 	 *		IMLN(complexNumber)
    1896. 

  1896. 	 *
    1897. 

  1897. 	 * @param	string		$complexNumber	The complex number for which you want the natural logarithm.
    1898. 

  1898. 	 * @return	string
    1899. 

  1899. 	 */
    1900. 

  1900. 	public static function IMLN($complexNumber) {
    1901. 

  1901. 		$complexNumber	= PHPExcel_Calculation_Functions::flattenSingleValue($complexNumber);
    1902. 

  1902. 

  1903. 		$parsedComplex = self::_parseComplex($complexNumber);
    1904. 

  1904. 

  1905. 		if (($parsedComplex['real'] == 0.0) && ($parsedComplex['imaginary'] == 0.0)) {
    1906. 

  1906. 			return PHPExcel_Calculation_Functions::NaN();
    1907. 

  1907. 		}
    1908. 

  1908. 

  1909. 		$logR = log(sqrt(($parsedComplex['real'] * $parsedComplex['real']) + ($parsedComplex['imaginary'] * $parsedComplex['imaginary'])));
    1910. 

  1910. 		$t = self::IMARGUMENT($complexNumber);
    1911. 

  1911. 

  1912. 		if ($parsedComplex['suffix'] == '') {
    1913. 

  1913. 			return self::COMPLEX($logR,$t);
    1914. 

  1914. 		} else {
    1915. 

  1915. 			return self::COMPLEX($logR,$t,$parsedComplex['suffix']);
    1916. 

  1916. 		}
    1917. 

  1917. 	}	//	function IMLN()
    1918. 

  1918. 

  1919. 

  1920. 	/**
    1921. 

  1921. 	 * IMLOG10
    1922. 

  1922. 	 *
    1923. 

  1923. 	 * Returns the common logarithm (base 10) of a complex number in x + yi or x + yj text format.
    1924. 

  1924. 	 *
    1925. 

  1925. 	 * Excel Function:
    1926. 

  1926. 	 *		IMLOG10(complexNumber)
    1927. 

  1927. 	 *
    1928. 

  1928. 	 * @param	string		$complexNumber	The complex number for which you want the common logarithm.
    1929. 

  1929. 	 * @return	string
    1930. 

  1930. 	 */
    1931. 

  1931. 	public static function IMLOG10($complexNumber) {
    1932. 

  1932. 		$complexNumber	= PHPExcel_Calculation_Functions::flattenSingleValue($complexNumber);
    1933. 

  1933. 

  1934. 		$parsedComplex = self::_parseComplex($complexNumber);
    1935. 

  1935. 

  1936. 		if (($parsedComplex['real'] == 0.0) && ($parsedComplex['imaginary'] == 0.0)) {
    1937. 

  1937. 			return PHPExcel_Calculation_Functions::NaN();
    1938. 

  1938. 		} elseif (($parsedComplex['real'] > 0.0) && ($parsedComplex['imaginary'] == 0.0)) {
    1939. 

  1939. 			return log10($parsedComplex['real']);
    1940. 

  1940. 		}
    1941. 

  1941. 

  1942. 		return self::IMPRODUCT(log10(EULER),self::IMLN($complexNumber));
    1943. 

  1943. 	}	//	function IMLOG10()
    1944. 

  1944. 

  1945. 

  1946. 	/**
    1947. 

  1947. 	 * IMLOG2
    1948. 

  1948. 	 *
    1949. 

  1949. 	 * Returns the common logarithm (base 10) of a complex number in x + yi or x + yj text format.
    1950. 

  1950. 	 *
    1951. 

  1951. 	 * Excel Function:
    1952. 

  1952. 	 *		IMLOG2(complexNumber)
    1953. 

  1953. 	 *
    1954. 

  1954. 	 * @param	string		$complexNumber	The complex number for which you want the base-2 logarithm.
    1955. 

  1955. 	 * @return	string
    1956. 

  1956. 	 */
    1957. 

  1957. 	public static function IMLOG2($complexNumber) {
    1958. 

  1958. 		$complexNumber	= PHPExcel_Calculation_Functions::flattenSingleValue($complexNumber);
    1959. 

  1959. 

  1960. 		$parsedComplex = self::_parseComplex($complexNumber);
    1961. 

  1961. 

  1962. 		if (($parsedComplex['real'] == 0.0) && ($parsedComplex['imaginary'] == 0.0)) {
    1963. 

  1963. 			return PHPExcel_Calculation_Functions::NaN();
    1964. 

  1964. 		} elseif (($parsedComplex['real'] > 0.0) && ($parsedComplex['imaginary'] == 0.0)) {
    1965. 

  1965. 			return log($parsedComplex['real'],2);
    1966. 

  1966. 		}
    1967. 

  1967. 

  1968. 		return self::IMPRODUCT(log(EULER,2),self::IMLN($complexNumber));
    1969. 

  1969. 	}	//	function IMLOG2()
    1970. 

  1970. 

  1971. 

  1972. 	/**
    1973. 

  1973. 	 * IMEXP
    1974. 

  1974. 	 *
    1975. 

  1975. 	 * Returns the exponential of a complex number in x + yi or x + yj text format.
    1976. 

  1976. 	 *
    1977. 

  1977. 	 * Excel Function:
    1978. 

  1978. 	 *		IMEXP(complexNumber)
    1979. 

  1979. 	 *
    1980. 

  1980. 	 * @param	string		$complexNumber	The complex number for which you want the exponential.
    1981. 

  1981. 	 * @return	string
    1982. 

  1982. 	 */
    1983. 

  1983. 	public static function IMEXP($complexNumber) {
    1984. 

  1984. 		$complexNumber	= PHPExcel_Calculation_Functions::flattenSingleValue($complexNumber);
    1985. 

  1985. 

  1986. 		$parsedComplex = self::_parseComplex($complexNumber);
    1987. 

  1987. 

  1988. 		if (($parsedComplex['real'] == 0.0) && ($parsedComplex['imaginary'] == 0.0)) {
    1989. 

  1989. 			return '1';
    1990. 

  1990. 		}
    1991. 

  1991. 

  1992. 		$e = exp($parsedComplex['real']);
    1993. 

  1993. 		$eX = $e * cos($parsedComplex['imaginary']);
    1994. 

  1994. 		$eY = $e * sin($parsedComplex['imaginary']);
    1995. 

  1995. 

  1996. 		if ($parsedComplex['suffix'] == '') {
    1997. 

  1997. 			return self::COMPLEX($eX,$eY);
    1998. 

  1998. 		} else {
    1999. 

  1999. 			return self::COMPLEX($eX,$eY,$parsedComplex['suffix']);
    2000. 

  2000. 		}
    2001. 

  2001. 	}	//	function IMEXP()
    2002. 

  2002. 

  2003. 

  2004. 	/**
    2005. 

  2005. 	 * IMPOWER
    2006. 

  2006. 	 *
    2007. 

  2007. 	 * Returns a complex number in x + yi or x + yj text format raised to a power.
    2008. 

  2008. 	 *
    2009. 

  2009. 	 * Excel Function:
    2010. 

  2010. 	 *		IMPOWER(complexNumber,realNumber)
    2011. 

  2011. 	 *
    2012. 

  2012. 	 * @param	string		$complexNumber	The complex number you want to raise to a power.
    2013. 

  2013. 	 * @param	float		$realNumber		The power to which you want to raise the complex number.
    2014. 

  2014. 	 * @return	string
    2015. 

  2015. 	 */
    2016. 

  2016. 	public static function IMPOWER($complexNumber,$realNumber) {
    2017. 

  2017. 		$complexNumber	= PHPExcel_Calculation_Functions::flattenSingleValue($complexNumber);
    2018. 

  2018. 		$realNumber		= PHPExcel_Calculation_Functions::flattenSingleValue($realNumber);
    2019. 

  2019. 

  2020. 		if (!is_numeric($realNumber)) {
    2021. 

  2021. 			return PHPExcel_Calculation_Functions::VALUE();
    2022. 

  2022. 		}
    2023. 

  2023. 

  2024. 		$parsedComplex = self::_parseComplex($complexNumber);
    2025. 

  2025. 

  2026. 		$r = sqrt(($parsedComplex['real'] * $parsedComplex['real']) + ($parsedComplex['imaginary'] * $parsedComplex['imaginary']));
    2027. 

  2027. 		$rPower = pow($r,$realNumber);
    2028. 

  2028. 		$theta = self::IMARGUMENT($complexNumber) * $realNumber;
    2029. 

  2029. 		if ($theta == 0) {
    2030. 

  2030. 			return 1;
    2031. 

  2031. 		} elseif ($parsedComplex['imaginary'] == 0.0) {
    2032. 

  2032. 			return self::COMPLEX($rPower * cos($theta),$rPower * sin($theta),$parsedComplex['suffix']);
    2033. 

  2033. 		} else {
    2034. 

  2034. 			return self::COMPLEX($rPower * cos($theta),$rPower * sin($theta),$parsedComplex['suffix']);
    2035. 

  2035. 		}
    2036. 

  2036. 	}	//	function IMPOWER()
    2037. 

  2037. 

  2038. 

  2039. 	/**
    2040. 

  2040. 	 * IMDIV
    2041. 

  2041. 	 *
    2042. 

  2042. 	 * Returns the quotient of two complex numbers in x + yi or x + yj text format.
    2043. 

  2043. 	 *
    2044. 

  2044. 	 * Excel Function:
    2045. 

  2045. 	 *		IMDIV(complexDividend,complexDivisor)
    2046. 

  2046. 	 *
    2047. 

  2047. 	 * @param	string		$complexDividend	The complex numerator or dividend.
    2048. 

  2048. 	 * @param	string		$complexDivisor		The complex denominator or divisor.
    2049. 

  2049. 	 * @return	string
    2050. 

  2050. 	 */
    2051. 

  2051. 	public static function IMDIV($complexDividend,$complexDivisor) {
    2052. 

  2052. 		$complexDividend	= PHPExcel_Calculation_Functions::flattenSingleValue($complexDividend);
    2053. 

  2053. 		$complexDivisor	= PHPExcel_Calculation_Functions::flattenSingleValue($complexDivisor);
    2054. 

  2054. 

  2055. 		$parsedComplexDividend = self::_parseComplex($complexDividend);
    2056. 

  2056. 		$parsedComplexDivisor = self::_parseComplex($complexDivisor);
    2057. 

  2057. 

  2058. 		if (($parsedComplexDividend['suffix'] != '') && ($parsedComplexDivisor['suffix'] != '') &&
    2059. 

  2059. 			($parsedComplexDividend['suffix'] != $parsedComplexDivisor['suffix'])) {
    2060. 

  2060. 			return PHPExcel_Calculation_Functions::NaN();
    2061. 

  2061. 		}
    2062. 

  2062. 		if (($parsedComplexDividend['suffix'] != '') && ($parsedComplexDivisor['suffix'] == '')) {
    2063. 

  2063. 			$parsedComplexDivisor['suffix'] = $parsedComplexDividend['suffix'];
    2064. 

  2064. 		}
    2065. 

  2065. 

  2066. 		$d1 = ($parsedComplexDividend['real'] * $parsedComplexDivisor['real']) + ($parsedComplexDividend['imaginary'] * $parsedComplexDivisor['imaginary']);
    2067. 

  2067. 		$d2 = ($parsedComplexDividend['imaginary'] * $parsedComplexDivisor['real']) - ($parsedComplexDividend['real'] * $parsedComplexDivisor['imaginary']);
    2068. 

  2068. 		$d3 = ($parsedComplexDivisor['real'] * $parsedComplexDivisor['real']) + ($parsedComplexDivisor['imaginary'] * $parsedComplexDivisor['imaginary']);
    2069. 

  2069. 

  2070. 		$r = $d1/$d3;
    2071. 

  2071. 		$i = $d2/$d3;
    2072. 

  2072. 

  2073. 		if ($i > 0.0) {
    2074. 

  2074. 			return self::_cleanComplex($r.'+'.$i.$parsedComplexDivisor['suffix']);
    2075. 

  2075. 		} elseif ($i < 0.0) {
    2076. 

  2076. 			return self::_cleanComplex($r.$i.$parsedComplexDivisor['suffix']);
    2077. 

  2077. 		} else {
    2078. 

  2078. 			return $r;
    2079. 

  2079. 		}
    2080. 

  2080. 	}	//	function IMDIV()
    2081. 

  2081. 

  2082. 

  2083. 	/**
    2084. 

  2084. 	 * IMSUB
    2085. 

  2085. 	 *
    2086. 

  2086. 	 * Returns the difference of two complex numbers in x + yi or x + yj text format.
    2087. 

  2087. 	 *
    2088. 

  2088. 	 * Excel Function:
    2089. 

  2089. 	 *		IMSUB(complexNumber1,complexNumber2)
    2090. 

  2090. 	 *
    2091. 

  2091. 	 * @param	string		$complexNumber1		The complex number from which to subtract complexNumber2.
    2092. 

  2092. 	 * @param	string		$complexNumber2		The complex number to subtract from complexNumber1.
    2093. 

  2093. 	 * @return	string
    2094. 

  2094. 	 */
    2095. 

  2095. 	public static function IMSUB($complexNumber1,$complexNumber2) {
    2096. 

  2096. 		$complexNumber1	= PHPExcel_Calculation_Functions::flattenSingleValue($complexNumber1);
    2097. 

  2097. 		$complexNumber2	= PHPExcel_Calculation_Functions::flattenSingleValue($complexNumber2);
    2098. 

  2098. 

  2099. 		$parsedComplex1 = self::_parseComplex($complexNumber1);
    2100. 

  2100. 		$parsedComplex2 = self::_parseComplex($complexNumber2);
    2101. 

  2101. 

  2102. 		if ((($parsedComplex1['suffix'] != '') && ($parsedComplex2['suffix'] != '')) &&
    2103. 

  2103. 			($parsedComplex1['suffix'] != $parsedComplex2['suffix'])) {
    2104. 

  2104. 			return PHPExcel_Calculation_Functions::NaN();
    2105. 

  2105. 		} elseif (($parsedComplex1['suffix'] == '') && ($parsedComplex2['suffix'] != '')) {
    2106. 

  2106. 			$parsedComplex1['suffix'] = $parsedComplex2['suffix'];
    2107. 

  2107. 		}
    2108. 

  2108. 

  2109. 		$d1 = $parsedComplex1['real'] - $parsedComplex2['real'];
    2110. 

  2110. 		$d2 = $parsedComplex1['imaginary'] - $parsedComplex2['imaginary'];
    2111. 

  2111. 

  2112. 		return self::COMPLEX($d1,$d2,$parsedComplex1['suffix']);
    2113. 

  2113. 	}	//	function IMSUB()
    2114. 

  2114. 

  2115. 

  2116. 	/**
    2117. 

  2117. 	 * IMSUM
    2118. 

  2118. 	 *
    2119. 

  2119. 	 * Returns the sum of two or more complex numbers in x + yi or x + yj text format.
    2120. 

  2120. 	 *
    2121. 

  2121. 	 * Excel Function:
    2122. 

  2122. 	 *		IMSUM(complexNumber[,complexNumber[,...]])
    2123. 

  2123. 	 *
    2124. 

  2124. 	 * @param	string		$complexNumber,...	Series of complex numbers to add
    2125. 

  2125. 	 * @return	string
    2126. 

  2126. 	 */
    2127. 

  2127. 	public static function IMSUM() {
    2128. 

  2128. 		// Return value
    2129. 

  2129. 		$returnValue = self::_parseComplex('0');
    2130. 

  2130. 		$activeSuffix = '';
    2131. 

  2131. 

  2132. 		// Loop through the arguments
    2133. 

  2133. 		$aArgs = PHPExcel_Calculation_Functions::flattenArray(func_get_args());
    2134. 

  2134. 		foreach ($aArgs as $arg) {
    2135. 

  2135. 			$parsedComplex = self::_parseComplex($arg);
    2136. 

  2136. 

  2137. 			if ($activeSuffix == '') {
    2138. 

  2138. 				$activeSuffix = $parsedComplex['suffix'];
    2139. 

  2139. 			} elseif (($parsedComplex['suffix'] != '') && ($activeSuffix != $parsedComplex['suffix'])) {
    2140. 

  2140. 				return PHPExcel_Calculation_Functions::VALUE();
    2141. 

  2141. 			}
    2142. 

  2142. 

  2143. 			$returnValue['real'] += $parsedComplex['real'];
    2144. 

  2144. 			$returnValue['imaginary'] += $parsedComplex['imaginary'];
    2145. 

  2145. 		}
    2146. 

  2146. 

  2147. 		if ($returnValue['imaginary'] == 0.0) { $activeSuffix = ''; }
    2148. 

  2148. 		return self::COMPLEX($returnValue['real'],$returnValue['imaginary'],$activeSuffix);
    2149. 

  2149. 	}	//	function IMSUM()
    2150. 

  2150. 

  2151. 

  2152. 	/**
    2153. 

  2153. 	 * IMPRODUCT
    2154. 

  2154. 	 *
    2155. 

  2155. 	 * Returns the product of two or more complex numbers in x + yi or x + yj text format.
    2156. 

  2156. 	 *
    2157. 

  2157. 	 * Excel Function:
    2158. 

  2158. 	 *		IMPRODUCT(complexNumber[,complexNumber[,...]])
    2159. 

  2159. 	 *
    2160. 

  2160. 	 * @param	string		$complexNumber,...	Series of complex numbers to multiply
    2161. 

  2161. 	 * @return	string
    2162. 

  2162. 	 */
    2163. 

  2163. 	public static function IMPRODUCT() {
    2164. 

  2164. 		// Return value
    2165. 

  2165. 		$returnValue = self::_parseComplex('1');
    2166. 

  2166. 		$activeSuffix = '';
    2167. 

  2167. 

  2168. 		// Loop through the arguments
    2169. 

  2169. 		$aArgs = PHPExcel_Calculation_Functions::flattenArray(func_get_args());
    2170. 

  2170. 		foreach ($aArgs as $arg) {
    2171. 

  2171. 			$parsedComplex = self::_parseComplex($arg);
    2172. 

  2172. 

  2173. 			$workValue = $returnValue;
    2174. 

  2174. 			if (($parsedComplex['suffix'] != '') && ($activeSuffix == '')) {
    2175. 

  2175. 				$activeSuffix = $parsedComplex['suffix'];
    2176. 

  2176. 			} elseif (($parsedComplex['suffix'] != '') && ($activeSuffix != $parsedComplex['suffix'])) {
    2177. 

  2177. 				return PHPExcel_Calculation_Functions::NaN();
    2178. 

  2178. 			}
    2179. 

  2179. 			$returnValue['real'] = ($workValue['real'] * $parsedComplex['real']) - ($workValue['imaginary'] * $parsedComplex['imaginary']);
    2180. 

  2180. 			$returnValue['imaginary'] = ($workValue['real'] * $parsedComplex['imaginary']) + ($workValue['imaginary'] * $parsedComplex['real']);
    2181. 

  2181. 		}
    2182. 

  2182. 

  2183. 		if ($returnValue['imaginary'] == 0.0) { $activeSuffix = ''; }
    2184. 

  2184. 		return self::COMPLEX($returnValue['real'],$returnValue['imaginary'],$activeSuffix);
    2185. 

  2185. 	}	//	function IMPRODUCT()
    2186. 

  2186. 

  2187. 

  2188. 	/**
    2189. 

  2189. 	 * DELTA
    2190. 

  2190. 	 *
    2191. 

  2191. 	 * Tests whether two values are equal. Returns 1 if number1 = number2; returns 0 otherwise.
    2192. 

  2192. 	 * Use this function to filter a set of values. For example, by summing several DELTA
    2193. 

  2193. 	 * functions you calculate the count of equal pairs. This function is also known as the
    2194. 

  2194. 	 * Kronecker Delta function.
    2195. 

  2195. 	 *
    2196. 

  2196. 	 * Excel Function:
    2197. 

  2197. 	 *		DELTA(a[,b])
    2198. 

  2198. 	 *
    2199. 

  2199. 	 * @param	float		$a	The first number.
    2200. 

  2200. 	 * @param	float		$b	The second number. If omitted, b is assumed to be zero.
    2201. 

  2201. 	 * @return	int
    2202. 

  2202. 	 */
    2203. 

  2203. 	public static function DELTA($a, $b=0) {
    2204. 

  2204. 		$a	= PHPExcel_Calculation_Functions::flattenSingleValue($a);
    2205. 

  2205. 		$b	= PHPExcel_Calculation_Functions::flattenSingleValue($b);
    2206. 

  2206. 

  2207. 		return (int) ($a == $b);
    2208. 

  2208. 	}	//	function DELTA()
    2209. 

  2209. 

  2210. 

  2211. 	/**
    2212. 

  2212. 	 * GESTEP
    2213. 

  2213. 	 *
    2214. 

  2214. 	 * Excel Function:
    2215. 

  2215. 	 *		GESTEP(number[,step])
    2216. 

  2216. 	 *
    2217. 

  2217. 	 * Returns 1 if number >= step; returns 0 (zero) otherwise
    2218. 

  2218. 	 * Use this function to filter a set of values. For example, by summing several GESTEP
    2219. 

  2219. 	 * functions you calculate the count of values that exceed a threshold.
    2220. 

  2220. 	 *
    2221. 

  2221. 	 * @param	float		$number		The value to test against step.
    2222. 

  2222. 	 * @param	float		$step		The threshold value.
    2223. 

  2223. 	 *									If you omit a value for step, GESTEP uses zero.
    2224. 

  2224. 	 * @return	int
    2225. 

  2225. 	 */
    2226. 

  2226. 	public static function GESTEP($number, $step=0) {
    2227. 

  2227. 		$number	= PHPExcel_Calculation_Functions::flattenSingleValue($number);
    2228. 

  2228. 		$step	= PHPExcel_Calculation_Functions::flattenSingleValue($step);
    2229. 

  2229. 

  2230. 		return (int) ($number >= $step);
    2231. 

  2231. 	}	//	function GESTEP()
    2232. 

  2232. 

  2233. 

  2234. 	//
    2235. 

  2235. 	//	Private method to calculate the erf value
    2236. 

  2236. 	//
    2237. 

  2237. 	private static $_two_sqrtpi = 1.128379167095512574;
    2238. 

  2238. 

  2239. 	public static function _erfVal($x) {
    2240. 

  2240. 		if (abs($x) > 2.2) {
    2241. 

  2241. 			return 1 - self::_erfcVal($x);
    2242. 

  2242. 		}
    2243. 

  2243. 		$sum = $term = $x;
    2244. 

  2244. 		$xsqr = ($x * $x);
    2245. 

  2245. 		$j = 1;
    2246. 

  2246. 		do {
    2247. 

  2247. 			$term *= $xsqr / $j;
    2248. 

  2248. 			$sum -= $term / (2 * $j + 1);
    2249. 

  2249. 			++$j;
    2250. 

  2250. 			$term *= $xsqr / $j;
    2251. 

  2251. 			$sum += $term / (2 * $j + 1);
    2252. 

  2252. 			++$j;
    2253. 

  2253. 			if ($sum == 0.0) {
    2254. 

  2254. 				break;
    2255. 

  2255. 			}
    2256. 

  2256. 		} while (abs($term / $sum) > PRECISION);
    2257. 

  2257. 		return self::$_two_sqrtpi * $sum;
    2258. 

  2258. 	}	//	function _erfVal()
    2259. 

  2259. 

  2260. 

  2261. 	/**
    2262. 

  2262. 	 * ERF
    2263. 

  2263. 	 *
    2264. 

  2264. 	 * Returns the error function integrated between lower_limit and upper_limit
    2265. 

  2265. 	 *
    2266. 

  2266. 	 * Excel Function:
    2267. 

  2267. 	 *		ERF(lower[,upper])
    2268. 

  2268. 	 *
    2269. 

  2269. 	 * @param	float		$lower	lower bound for integrating ERF
    2270. 

  2270. 	 * @param	float		$upper	upper bound for integrating ERF.
    2271. 

  2271. 	 *								If omitted, ERF integrates between zero and lower_limit
    2272. 

  2272. 	 * @return	int
    2273. 

  2273. 	 */
    2274. 

  2274. 	public static function ERF($lower, $upper = null) {
    2275. 

  2275. 		$lower	= PHPExcel_Calculation_Functions::flattenSingleValue($lower);
    2276. 

  2276. 		$upper	= PHPExcel_Calculation_Functions::flattenSingleValue($upper);
    2277. 

  2277. 

  2278. 		if (is_numeric($lower)) {
    2279. 

  2279. 			if ($lower < 0) {
    2280. 

  2280. 				return PHPExcel_Calculation_Functions::NaN();
    2281. 

  2281. 			}
    2282. 

  2282. 			if (is_null($upper)) {
    2283. 

  2283. 				return self::_erfVal($lower);
    2284. 

  2284. 			}
    2285. 

  2285. 			if (is_numeric($upper)) {
    2286. 

  2286. 				if ($upper < 0) {
    2287. 

  2287. 					return PHPExcel_Calculation_Functions::NaN();
    2288. 

  2288. 				}
    2289. 

  2289. 				return self::_erfVal($upper) - self::_erfVal($lower);
    2290. 

  2290. 			}
    2291. 

  2291. 		}
    2292. 

  2292. 		return PHPExcel_Calculation_Functions::VALUE();
    2293. 

  2293. 	}	//	function ERF()
    2294. 

  2294. 

  2295. 

  2296. 	//
    2297. 

  2297. 	//	Private method to calculate the erfc value
    2298. 

  2298. 	//
    2299. 

  2299. 	private static $_one_sqrtpi = 0.564189583547756287;
    2300. 

  2300. 

  2301. 	private static function _erfcVal($x) {
    2302. 

  2302. 		if (abs($x) < 2.2) {
    2303. 

  2303. 			return 1 - self::_erfVal($x);
    2304. 

  2304. 		}
    2305. 

  2305. 		if ($x < 0) {
    2306. 

  2306. 			return 2 - self::ERFC(-$x);
    2307. 

  2307. 		}
    2308. 

  2308. 		$a = $n = 1;
    2309. 

  2309. 		$b = $c = $x;
    2310. 

  2310. 		$d = ($x * $x) + 0.5;
    2311. 

  2311. 		$q1 = $q2 = $b / $d;
    2312. 

  2312. 		$t = 0;
    2313. 

  2313. 		do {
    2314. 

  2314. 			$t = $a * $n + $b * $x;
    2315. 

  2315. 			$a = $b;
    2316. 

  2316. 			$b = $t;
    2317. 

  2317. 			$t = $c * $n + $d * $x;
    2318. 

  2318. 			$c = $d;
    2319. 

  2319. 			$d = $t;
    2320. 

  2320. 			$n += 0.5;
    2321. 

  2321. 			$q1 = $q2;
    2322. 

  2322. 			$q2 = $b / $d;
    2323. 

  2323. 		} while ((abs($q1 - $q2) / $q2) > PRECISION);
    2324. 

  2324. 		return self::$_one_sqrtpi * exp(-$x * $x) * $q2;
    2325. 

  2325. 	}	//	function _erfcVal()
    2326. 

  2326. 

  2327. 

  2328. 	/**
    2329. 

  2329. 	 * ERFC
    2330. 

  2330. 	 *
    2331. 

  2331. 	 * Returns the complementary ERF function integrated between x and infinity
    2332. 

  2332. 	 *
    2333. 

  2333. 	 * Excel Function:
    2334. 

  2334. 	 *		ERF(x)
    2335. 

  2335. 	 *
    2336. 

  2336. 	 * @param	float		$x		The lower bound for integrating ERF
    2337. 

  2337. 	 * @return	int
    2338. 

  2338. 	 */
    2339. 

  2339. 	public static function ERFC($x) {
    2340. 

  2340. 		$x	= PHPExcel_Calculation_Functions::flattenSingleValue($x);
    2341. 

  2341. 

  2342. 		if (is_numeric($x)) {
    2343. 

  2343. 			if ($x < 0) {
    2344. 

  2344. 				return PHPExcel_Calculation_Functions::NaN();
    2345. 

  2345. 			}
    2346. 

  2346. 			return self::_erfcVal($x);
    2347. 

  2347. 		}
    2348. 

  2348. 		return PHPExcel_Calculation_Functions::VALUE();
    2349. 

  2349. 	}	//	function ERFC()
    2350. 

  2350. 

  2351. 

  2352. 	/**
    2353. 

  2353. 	 * getConversionGroups
    2354. 

  2354. 	 *
    2355. 

  2355. 	 * @return	array
    2356. 

  2356. 	 */
    2357. 

  2357. 	public static function getConversionGroups() {
    2358. 

  2358. 		$conversionGroups = array();
    2359. 

  2359. 		foreach(self::$_conversionUnits as $conversionUnit) {
    2360. 

  2360. 			$conversionGroups[] = $conversionUnit['Group'];
    2361. 

  2361. 		}
    2362. 

  2362. 		return array_merge(array_unique($conversionGroups));
    2363. 

  2363. 	}	//	function getConversionGroups()
    2364. 

  2364. 

  2365. 

  2366. 	/**
    2367. 

  2367. 	 * getConversionGroupUnits
    2368. 

  2368. 	 *
    2369. 

  2369. 	 * @return	array
    2370. 

  2370. 	 */
    2371. 

  2371. 	public static function getConversionGroupUnits($group = NULL) {
    2372. 

  2372. 		$conversionGroups = array();
    2373. 

  2373. 		foreach(self::$_conversionUnits as $conversionUnit => $conversionGroup) {
    2374. 

  2374. 			if ((is_null($group)) || ($conversionGroup['Group'] == $group)) {
    2375. 

  2375. 				$conversionGroups[$conversionGroup['Group']][] = $conversionUnit;
    2376. 

  2376. 			}
    2377. 

  2377. 		}
    2378. 

  2378. 		return $conversionGroups;
    2379. 

  2379. 	}	//	function getConversionGroupUnits()
    2380. 

  2380. 

  2381. 

  2382. 	/**
    2383. 

  2383. 	 * getConversionGroupUnitDetails
    2384. 

  2384. 	 *
    2385. 

  2385. 	 * @return	array
    2386. 

  2386. 	 */
    2387. 

  2387. 	public static function getConversionGroupUnitDetails($group = NULL) {
    2388. 

  2388. 		$conversionGroups = array();
    2389. 

  2389. 		foreach(self::$_conversionUnits as $conversionUnit => $conversionGroup) {
    2390. 

  2390. 			if ((is_null($group)) || ($conversionGroup['Group'] == $group)) {
    2391. 

  2391. 				$conversionGroups[$conversionGroup['Group']][] = array(	'unit'			=> $conversionUnit,
    2392. 

  2392. 																		'description'	=> $conversionGroup['Unit Name']
    2393. 

  2393. 																	  );
    2394. 

  2394. 			}
    2395. 

  2395. 		}
    2396. 

  2396. 		return $conversionGroups;
    2397. 

  2397. 	}	//	function getConversionGroupUnitDetails()
    2398. 

  2398. 

  2399. 

  2400. 	/**
    2401. 

  2401. 	 * getConversionGroups
    2402. 

  2402. 	 *
    2403. 

  2403. 	 * @return	array
    2404. 

  2404. 	 */
    2405. 

  2405. 	public static function getConversionMultipliers() {
    2406. 

  2406. 		return self::$_conversionMultipliers;
    2407. 

  2407. 	}	//	function getConversionGroups()
    2408. 

  2408. 

  2409. 

  2410. 	/**
    2411. 

  2411. 	 * CONVERTUOM
    2412. 

  2412. 	 *
    2413. 

  2413. 	 * Converts a number from one measurement system to another.
    2414. 

  2414. 	 * For example, CONVERT can translate a table of distances in miles to a table of distances
    2415. 

  2415. 	 * in kilometers.
    2416. 

  2416. 	 *
    2417. 

  2417. 	 * Excel Function:
    2418. 

  2418. 	 *		CONVERT(value,fromUOM,toUOM)
    2419. 

  2419. 	 *
    2420. 

  2420. 	 * @param	float		$value		The value in fromUOM to convert.
    2421. 

  2421. 	 * @param	string		$fromUOM	The units for value.
    2422. 

  2422. 	 * @param	string		$toUOM		The units for the result.
    2423. 

  2423. 	 * @return	float
    2424. 

  2424. 	 */
    2425. 

  2425. 	public static function CONVERTUOM($value, $fromUOM, $toUOM) {
    2426. 

  2426. 		$value		= PHPExcel_Calculation_Functions::flattenSingleValue($value);
    2427. 

  2427. 		$fromUOM	= PHPExcel_Calculation_Functions::flattenSingleValue($fromUOM);
    2428. 

  2428. 		$toUOM		= PHPExcel_Calculation_Functions::flattenSingleValue($toUOM);
    2429. 

  2429. 

  2430. 		if (!is_numeric($value)) {
    2431. 

  2431. 			return PHPExcel_Calculation_Functions::VALUE();
    2432. 

  2432. 		}
    2433. 

  2433. 		$fromMultiplier = 1.0;
    2434. 

  2434. 		if (isset(self::$_conversionUnits[$fromUOM])) {
    2435. 

  2435. 			$unitGroup1 = self::$_conversionUnits[$fromUOM]['Group'];
    2436. 

  2436. 		} else {
    2437. 

  2437. 			$fromMultiplier = substr($fromUOM,0,1);
    2438. 

  2438. 			$fromUOM = substr($fromUOM,1);
    2439. 

  2439. 			if (isset(self::$_conversionMultipliers[$fromMultiplier])) {
    2440. 

  2440. 				$fromMultiplier = self::$_conversionMultipliers[$fromMultiplier]['multiplier'];
    2441. 

  2441. 			} else {
    2442. 

  2442. 				return PHPExcel_Calculation_Functions::NA();
    2443. 

  2443. 			}
    2444. 

  2444. 			if ((isset(self::$_conversionUnits[$fromUOM])) && (self::$_conversionUnits[$fromUOM]['AllowPrefix'])) {
    2445. 

  2445. 				$unitGroup1 = self::$_conversionUnits[$fromUOM]['Group'];
    2446. 

  2446. 			} else {
    2447. 

  2447. 				return PHPExcel_Calculation_Functions::NA();
    2448. 

  2448. 			}
    2449. 

  2449. 		}
    2450. 

  2450. 		$value *= $fromMultiplier;
    2451. 

  2451. 

  2452. 		$toMultiplier = 1.0;
    2453. 

  2453. 		if (isset(self::$_conversionUnits[$toUOM])) {
    2454. 

  2454. 			$unitGroup2 = self::$_conversionUnits[$toUOM]['Group'];
    2455. 

  2455. 		} else {
    2456. 

  2456. 			$toMultiplier = substr($toUOM,0,1);
    2457. 

  2457. 			$toUOM = substr($toUOM,1);
    2458. 

  2458. 			if (isset(self::$_conversionMultipliers[$toMultiplier])) {
    2459. 

  2459. 				$toMultiplier = self::$_conversionMultipliers[$toMultiplier]['multiplier'];
    2460. 

  2460. 			} else {
    2461. 

  2461. 				return PHPExcel_Calculation_Functions::NA();
    2462. 

  2462. 			}
    2463. 

  2463. 			if ((isset(self::$_conversionUnits[$toUOM])) && (self::$_conversionUnits[$toUOM]['AllowPrefix'])) {
    2464. 

  2464. 				$unitGroup2 = self::$_conversionUnits[$toUOM]['Group'];
    2465. 

  2465. 			} else {
    2466. 

  2466. 				return PHPExcel_Calculation_Functions::NA();
    2467. 

  2467. 			}
    2468. 

  2468. 		}
    2469. 

  2469. 		if ($unitGroup1 != $unitGroup2) {
    2470. 

  2470. 			return PHPExcel_Calculation_Functions::NA();
    2471. 

  2471. 		}
    2472. 

  2472. 

  2473. 		if (($fromUOM == $toUOM) && ($fromMultiplier == $toMultiplier)) {
    2474. 

  2474. 			//	We've already factored $fromMultiplier into the value, so we need
    2475. 

  2475. 			//		to reverse it again
    2476. 

  2476. 			return $value / $fromMultiplier;
    2477. 

  2477. 		} elseif ($unitGroup1 == 'Temperature') {
    2478. 

  2478. 			if (($fromUOM == 'F') || ($fromUOM == 'fah')) {
    2479. 

  2479. 				if (($toUOM == 'F') || ($toUOM == 'fah')) {
    2480. 

  2480. 					return $value;
    2481. 

  2481. 				} else {
    2482. 

  2482. 					$value = (($value - 32) / 1.8);
    2483. 

  2483. 					if (($toUOM == 'K') || ($toUOM == 'kel')) {
    2484. 

  2484. 						$value += 273.15;
    2485. 

  2485. 					}
    2486. 

  2486. 					return $value;
    2487. 

  2487. 				}
    2488. 

  2488. 			} elseif ((($fromUOM == 'K') || ($fromUOM == 'kel')) &&
    2489. 

  2489. 					  (($toUOM == 'K') || ($toUOM == 'kel'))) {
    2490. 

  2490. 						return $value;
    2491. 

  2491. 			} elseif ((($fromUOM == 'C') || ($fromUOM == 'cel')) &&
    2492. 

  2492. 					  (($toUOM == 'C') || ($toUOM == 'cel'))) {
    2493. 

  2493. 					return $value;
    2494. 

  2494. 			}
    2495. 

  2495. 			if (($toUOM == 'F') || ($toUOM == 'fah')) {
    2496. 

  2496. 				if (($fromUOM == 'K') || ($fromUOM == 'kel')) {
    2497. 

  2497. 					$value -= 273.15;
    2498. 

  2498. 				}
    2499. 

  2499. 				return ($value * 1.8) + 32;
    2500. 

  2500. 			}
    2501. 

  2501. 			if (($toUOM == 'C') || ($toUOM == 'cel')) {
    2502. 

  2502. 				return $value - 273.15;
    2503. 

  2503. 			}
    2504. 

  2504. 			return $value + 273.15;
    2505. 

  2505. 		}
    2506. 

  2506. 		return ($value * self::$_unitConversions[$unitGroup1][$fromUOM][$toUOM]) / $toMultiplier;
    2507. 

  2507. 	}	//	function CONVERTUOM()
    2508. 

  2508. 

  2509. }	//	class PHPExcel_Calculation_Engineering
    2510. 

  2510.