Find this useful? Enter your email to receive occasional updates for securing PHP code.
Signing you up...
Thank you for signing up!
PHP Decode
<?php /** PHPExcel root directory */ if(!defined(base64_decode('UEhQRVhDRUxfUk9PVA=='))){/..
Decoded Output download
<?php /** PHPExcel root directory */ if(!defined(base64_decode('UEhQRVhDRUxfUk9PVA=='))){/**
* @ignore
*/ define(base64_decode('UEhQRVhDRUxfUk9PVA=='),dirname(__FILE__).base64_decode('Ly4uLy4uLw=='));require(PHPEXCEL_ROOT.base64_decode('UEhQRXhjZWwvQXV0b2xvYWRlci5waHA='));}/**
* PHPExcel_Calculation_MathTrig
*
* Copyright (c) 2006 - 2015 PHPExcel
*
* This library is free software; you can redistribute it and/or
* modify it under the terms of the GNU Lesser General Public
* License as published by the Free Software Foundation; either
* version 2.1 of the License, or (at your option) any later version.
*
* This library is distributed in the hope that it will be useful,
* but WITHOUT ANY WARRANTY; without even the implied warranty of
* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU
* Lesser General Public License for more details.
*
* You should have received a copy of the GNU Lesser General Public
* License along with this library; if not, write to the Free Software
* Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA
*
* @category PHPExcel
* @package PHPExcel_Calculation
* @copyright Copyright (c) 2006 - 2015 PHPExcel (http://www.codeplex.com/PHPExcel)
* @license http://www.gnu.org/licenses/old-licenses/lgpl-2.1.txt LGPL
* @version ##VERSION##, ##DATE##
*/ class qhgx28{private static function vvbl0($bxuf29){$jtpf2a=floor(sqrt($bxuf29));$cuor2b=array();for($awiu2c=$jtpf2a;$awiu2c>1;--$awiu2c){if(($bxuf29%$awiu2c)==0){$cuor2b=array_merge($cuor2b,self::vvbl0($bxuf29/$awiu2c));$cuor2b=array_merge($cuor2b,self::vvbl0($awiu2c));if($awiu2c<=sqrt($bxuf29)){break;}}}if(!empty($cuor2b)){rsort($cuor2b);return $cuor2b;}else{returnarray((integer)$bxuf29);}}private static function saxz1($gbqe2d,$pfsb2e){return($gbqe2d-($gbqe2d%$pfsb2e))/$pfsb2e;}/**
* ATAN2
*
* This function calculates the arc tangent of the two variables x and y. It is similar to
* calculating the arc tangent of y x, except that the signs of both arguments are used
* to determine the quadrant of the result.
* The arctangent is the angle from the x-axis to a line containing the origin (0, 0) and a
* point with coordinates (xCoordinate, yCoordinate). The angle is given in radians between
* -pi and pi, excluding -pi.
*
* Note that the Excel ATAN2() function accepts its arguments in the reverse order to the standard
* PHP atan2() function, so we need to reverse them here before calling the PHP atan() function.
*
* Excel Function:
* ATAN2(xCoordinate,yCoordinate)
*
* @access public
* @category Mathematical and Trigonometric Functions
* @param float $xCoordinate The x-coordinate of the point.
* @param float $yCoordinate The y-coordinate of the point.
* @return float The inverse tangent of the specified x- and y-coordinates.
*/ public static function bxqr2($hvjd2f=null,$nvmz30=null){$hvjd2f=PHPExcel_Calculation_Functions::mefi31($hvjd2f);$nvmz30=PHPExcel_Calculation_Functions::mefi31($nvmz30);$hvjd2f=($hvjd2f!==null)?$hvjd2f:0.0;$nvmz30=($nvmz30!==null)?$nvmz30:0.0;if(((is_numeric($hvjd2f))||(is_bool($hvjd2f)))&&((is_numeric($nvmz30)))||(is_bool($nvmz30))){$hvjd2f=(float)$hvjd2f;$nvmz30=(float)$nvmz30;if(($hvjd2f==0)&&($nvmz30==0)){return PHPExcel_Calculation_Functions::cfpi32();}return atan2($nvmz30,$hvjd2f);}return PHPExcel_Calculation_Functions::macc33();}/**
* CEILING
*
* Returns number rounded up, away from zero, to the nearest multiple of significance.
* For example, if you want to avoid using pennies in your prices and your product is
* priced at $4.42, use the formula =CEILING(4.42,0.05) to round prices up to the
* nearest nickel.
*
* Excel Function:
* CEILING(number[,significance])
*
* @access public
* @category Mathematical and Trigonometric Functions
* @param float $number The number you want to round.
* @param float $significance The multiple to which you want to round.
* @return float Rounded Number
*/ public static function zwjb3($lpcu34,$nhhy35=null){$lpcu34=PHPExcel_Calculation_Functions::mefi31($lpcu34);$nhhy35=PHPExcel_Calculation_Functions::mefi31($nhhy35);if((is_null($nhhy35))&&(PHPExcel_Calculation_Functions::trjs36()==PHPExcel_Calculation_Functions::COMPATIBILITY_GNUMERIC)){$nhhy35=$lpcu34/abs($lpcu34);}if((is_numeric($lpcu34))&&(is_numeric($nhhy35))){if(($lpcu34==0.0)||($nhhy35==0.0)){return 0.0;}elseif(self::cvpm1c($lpcu34)==self::cvpm1c($nhhy35)){return ceil($lpcu34/$nhhy35)*$nhhy35;}else{return PHPExcel_Calculation_Functions::oxaf37();}}return PHPExcel_Calculation_Functions::macc33();}/**
* COMBIN
*
* Returns the number of combinations for a given number of items. Use COMBIN to
* determine the total possible number of groups for a given number of items.
*
* Excel Function:
* COMBIN(numObjs,numInSet)
*
* @access public
* @category Mathematical and Trigonometric Functions
* @param int $numObjs Number of different objects
* @param int $numInSet Number of objects in each combination
* @return int Number of combinations
*/ public static function gjyr4($cuiq38,$ptlp39){$cuiq38=PHPExcel_Calculation_Functions::mefi31($cuiq38);$ptlp39=PHPExcel_Calculation_Functions::mefi31($ptlp39);if((is_numeric($cuiq38))&&(is_numeric($ptlp39))){if($cuiq38<$ptlp39){return PHPExcel_Calculation_Functions::oxaf37();}elseif($ptlp39<0){return PHPExcel_Calculation_Functions::oxaf37();}return round(self::tonz6($cuiq38)/self::tonz6($cuiq38-$ptlp39))/self::tonz6($ptlp39);}return PHPExcel_Calculation_Functions::macc33();}/**
* EVEN
*
* Returns number rounded up to the nearest even integer.
* You can use this function for processing items that come in twos. For example,
* a packing crate accepts rows of one or two items. The crate is full when
* the number of items, rounded up to the nearest two, matches the crate's
* capacity.
*
* Excel Function:
* EVEN(number)
*
* @access public
* @category Mathematical and Trigonometric Functions
* @param float $number Number to round
* @return int Rounded Number
*/ public static function bywf5($lpcu34){$lpcu34=PHPExcel_Calculation_Functions::mefi31($lpcu34);if(is_null($lpcu34)){return 0;}elseif(is_bool($lpcu34)){$lpcu34=(int)$lpcu34;}if(is_numeric($lpcu34)){$nhhy35=2*self::cvpm1c($lpcu34);return(int)self::zwjb3($lpcu34,$nhhy35);}return PHPExcel_Calculation_Functions::macc33();}/**
* FACT
*
* Returns the factorial of a number.
* The factorial of a number is equal to 1*2*3*...* number.
*
* Excel Function:
* FACT(factVal)
*
* @access public
* @category Mathematical and Trigonometric Functions
* @param float $factVal Factorial Value
* @return int Factorial
*/ public static function tonz6($tznm3a){$tznm3a=PHPExcel_Calculation_Functions::mefi31($tznm3a);if(is_numeric($tznm3a)){if($tznm3a<0){return PHPExcel_Calculation_Functions::oxaf37();}$bqml3b=floor($tznm3a);if(PHPExcel_Calculation_Functions::trjs36()==PHPExcel_Calculation_Functions::COMPATIBILITY_GNUMERIC){if($tznm3a>$bqml3b){return PHPExcel_Calculation_Functions::oxaf37();}}$wezh3c=1;while($bqml3b>1){$wezh3c*=$bqml3b--;}return $wezh3c;}return PHPExcel_Calculation_Functions::macc33();}/**
* FACTDOUBLE
*
* Returns the double factorial of a number.
*
* Excel Function:
* FACTDOUBLE(factVal)
*
* @access public
* @category Mathematical and Trigonometric Functions
* @param float $factVal Factorial Value
* @return int Double Factorial
*/ public static function uhsi7($tznm3a){$bqml3b=PHPExcel_Calculation_Functions::mefi31($tznm3a);if(is_numeric($bqml3b)){$bqml3b=floor($bqml3b);if($tznm3a<0){return PHPExcel_Calculation_Functions::oxaf37();}$wezh3c=1;while($bqml3b>1){$wezh3c*=$bqml3b--;--$bqml3b;}return $wezh3c;}return PHPExcel_Calculation_Functions::macc33();}/**
* FLOOR
*
* Rounds number down, toward zero, to the nearest multiple of significance.
*
* Excel Function:
* FLOOR(number[,significance])
*
* @access public
* @category Mathematical and Trigonometric Functions
* @param float $number Number to round
* @param float $significance Significance
* @return float Rounded Number
*/ public static function ekly8($lpcu34,$nhhy35=null){$lpcu34=PHPExcel_Calculation_Functions::mefi31($lpcu34);$nhhy35=PHPExcel_Calculation_Functions::mefi31($nhhy35);if((is_null($nhhy35))&&(PHPExcel_Calculation_Functions::trjs36()==PHPExcel_Calculation_Functions::COMPATIBILITY_GNUMERIC)){$nhhy35=$lpcu34/abs($lpcu34);}if((is_numeric($lpcu34))&&(is_numeric($nhhy35))){if($nhhy35==0.0){return PHPExcel_Calculation_Functions::cfpi32();}elseif($lpcu34==0.0){return 0.0;}elseif(self::cvpm1c($lpcu34)==self::cvpm1c($nhhy35)){return floor($lpcu34/$nhhy35)*$nhhy35;}else{return PHPExcel_Calculation_Functions::oxaf37();}}return PHPExcel_Calculation_Functions::macc33();}/**
* GCD
*
* Returns the greatest common divisor of a series of numbers.
* The greatest common divisor is the largest integer that divides both
* number1 and number2 without a remainder.
*
* Excel Function:
* GCD(number1[,number2[, ...]])
*
* @access public
* @category Mathematical and Trigonometric Functions
* @param mixed $arg,... Data values
* @return integer Greatest Common Divisor
*/ public static function bvvy9(){$jkbf3d=1;$jqle3e=array();foreach(PHPExcel_Calculation_Functions::mmkt3f(func_get_args())as $bxuf29){if(!is_numeric($bxuf29)){return PHPExcel_Calculation_Functions::macc33();}elseif($bxuf29==0){continue;}elseif($bxuf29<0){return PHPExcel_Calculation_Functions::oxaf37();}$kczh40=self::vvbl0($bxuf29);$onya41=array_count_values($kczh40);$jqle3e[]=$onya41;}$pqjw42=count($jqle3e);if($pqjw42==0){return 0;}$yzkl43=$jqle3e[0];for($awiu2c=1;$awiu2c<$pqjw42;++$awiu2c){$yzkl43=array_intersect_key($yzkl43,$jqle3e[$awiu2c]);}$gkbo44=count($yzkl43);if($gkbo44==0){return $jkbf3d;}elseif($gkbo44>1){foreach($yzkl43 as $husr45=>$cxcx46){foreach($jqle3e as $emzs47){foreach($emzs47 as $fdsu48=>$jeba49){if(($fdsu48==$husr45)&&($jeba49<$cxcx46)){$yzkl43[$husr45]=$jeba49;$cxcx46=$jeba49;}}}}$jkbf3d=1;foreach($yzkl43 as $gbzj4a=>$bxuf29){$jkbf3d*=pow($gbzj4a,$bxuf29);}return $jkbf3d;}else{$yott4b=array_keys($yzkl43);$gbzj4a=$yott4b[0];$bxuf29=$yzkl43[$gbzj4a];foreach($jqle3e as $jeba49){foreach($jeba49 as $husr45=>$cxcx46){if(($husr45==$gbzj4a)&&($cxcx46<$bxuf29)){$bxuf29=$cxcx46;}}}return pow($gbzj4a,$bxuf29);}}/**
* INT
*
* Casts a floating point value to an integer
*
* Excel Function:
* INT(number)
*
* @access public
* @category Mathematical and Trigonometric Functions
* @param float $number Number to cast to an integer
* @return integer Integer value
*/ public static function bzmxa($lpcu34){$lpcu34=PHPExcel_Calculation_Functions::mefi31($lpcu34);if(is_null($lpcu34)){return 0;}elseif(is_bool($lpcu34)){return(int)$lpcu34;}if(is_numeric($lpcu34)){return(int)floor($lpcu34);}return PHPExcel_Calculation_Functions::macc33();}/**
* LCM
*
* Returns the lowest common multiplier of a series of numbers
* The least common multiple is the smallest positive integer that is a multiple
* of all integer arguments number1, number2, and so on. Use LCM to add fractions
* with different denominators.
*
* Excel Function:
* LCM(number1[,number2[, ...]])
*
* @access public
* @category Mathematical and Trigonometric Functions
* @param mixed $arg,... Data values
* @return int Lowest Common Multiplier
*/ public static function xsjhb(){$jkbf3d=1;$ktns4c=array();foreach(PHPExcel_Calculation_Functions::mmkt3f(func_get_args())as $bxuf29){if(!is_numeric($bxuf29)){return PHPExcel_Calculation_Functions::macc33();}if($bxuf29==0){return 0;}elseif($bxuf29<0){return PHPExcel_Calculation_Functions::oxaf37();}$kczh40=self::vvbl0(floor($bxuf29));$onya41=array_count_values($kczh40);$iefi4d=array();foreach($onya41 as $udfg4e=>$yrug4f){$iefi4d[$udfg4e]=pow($udfg4e,$yrug4f);}foreach($iefi4d as $yhvp50=>$btyg51){if(array_key_exists($yhvp50,$ktns4c)){if($ktns4c[$yhvp50]<$btyg51){$ktns4c[$yhvp50]=$btyg51;}}else{$ktns4c[$yhvp50]=$btyg51;}}}foreach($ktns4c as $aodx52){$jkbf3d*=(integer)$aodx52;}return $jkbf3d;}/**
* LOG_BASE
*
* Returns the logarithm of a number to a specified base. The default base is 10.
*
* Excel Function:
* LOG(number[,base])
*
* @access public
* @category Mathematical and Trigonometric Functions
* @param float $number The positive real number for which you want the logarithm
* @param float $base The base of the logarithm. If base is omitted, it is assumed to be 10.
* @return float
*/ public static function ovacc($lpcu34=null,$oejj53=10){$lpcu34=PHPExcel_Calculation_Functions::mefi31($lpcu34);$oejj53=(is_null($oejj53))?10:(float)PHPExcel_Calculation_Functions::mefi31($oejj53);if((!is_numeric($oejj53))||(!is_numeric($lpcu34))){return PHPExcel_Calculation_Functions::macc33();}if(($oejj53<=0)||($lpcu34<=0)){return PHPExcel_Calculation_Functions::oxaf37();}return log($lpcu34,$oejj53);}/**
* MDETERM
*
* Returns the matrix determinant of an array.
*
* Excel Function:
* MDETERM(array)
*
* @access public
* @category Mathematical and Trigonometric Functions
* @param array $matrixValues A matrix of values
* @return float
*/ public static function amxad($suhl54){$dhjy55=array();if(!is_array($suhl54)){$suhl54=array(array($suhl54));}$oiuw56=$zgvz57=0;foreach($suhl54 as $wpti58){if(!is_array($wpti58)){$wpti58=array($wpti58);}$bdqf59=0;foreach($wpti58 as $kbnb5a){if((is_string($kbnb5a))||($kbnb5a===null)){return PHPExcel_Calculation_Functions::macc33();}$dhjy55[$bdqf59][$oiuw56]=$kbnb5a;++$bdqf59;}if($bdqf59>$zgvz57){$zgvz57=$bdqf59;}++$oiuw56;}if($oiuw56!=$zgvz57){return PHPExcel_Calculation_Functions::macc33();}try{$jccp5b=new mjyl5c($dhjy55);return $jccp5b->weww5d();}catch(PHPExcel_Exception $kvof5e){return PHPExcel_Calculation_Functions::macc33();}}/**
* MINVERSE
*
* Returns the inverse matrix for the matrix stored in an array.
*
* Excel Function:
* MINVERSE(array)
*
* @access public
* @category Mathematical and Trigonometric Functions
* @param array $matrixValues A matrix of values
* @return array
*/ public static function avrye($suhl54){$dhjy55=array();if(!is_array($suhl54)){$suhl54=array(array($suhl54));}$oiuw56=$zgvz57=0;foreach($suhl54 as $wpti58){if(!is_array($wpti58)){$wpti58=array($wpti58);}$bdqf59=0;foreach($wpti58 as $kbnb5a){if((is_string($kbnb5a))||($kbnb5a===null)){return PHPExcel_Calculation_Functions::macc33();}$dhjy55[$bdqf59][$oiuw56]=$kbnb5a;++$bdqf59;}if($bdqf59>$zgvz57){$zgvz57=$bdqf59;}++$oiuw56;}if($oiuw56!=$zgvz57){return PHPExcel_Calculation_Functions::macc33();}try{$jccp5b=new mjyl5c($dhjy55);return $jccp5b->mihp5f()->mchg60();}catch(PHPExcel_Exception $kvof5e){return PHPExcel_Calculation_Functions::macc33();}}/**
* MMULT
*
* @param array $matrixData1 A matrix of values
* @param array $matrixData2 A matrix of values
* @return array
*/ public static function dwzef($pdaj61,$nbvw62){$febc63=$himy64=array();if(!is_array($pdaj61)){$pdaj61=array(array($pdaj61));}if(!is_array($nbvw62)){$nbvw62=array(array($nbvw62));}try{$clcs65=0;foreach($pdaj61 as $wpti58){if(!is_array($wpti58)){$wpti58=array($wpti58);}$tmvz66=0;foreach($wpti58 as $kbnb5a){if((!is_numeric($kbnb5a))||($kbnb5a===null)){return PHPExcel_Calculation_Functions::macc33();}$febc63[$clcs65][$tmvz66]=$kbnb5a;++$tmvz66;}++$clcs65;}$guic67=new mjyl5c($febc63);$sqtt68=0;foreach($nbvw62 as $wpti58){if(!is_array($wpti58)){$wpti58=array($wpti58);}$vnkv69=0;foreach($wpti58 as $kbnb5a){if((!is_numeric($kbnb5a))||($kbnb5a===null)){return PHPExcel_Calculation_Functions::macc33();}$himy64[$sqtt68][$vnkv69]=$kbnb5a;++$vnkv69;}++$sqtt68;}$ywcy6a=new mjyl5c($himy64);if($tmvz66!=$sqtt68){return PHPExcel_Calculation_Functions::macc33();}return $guic67->whby6b($ywcy6a)->mchg60();}catch(PHPExcel_Exception $kvof5e){var_dump($kvof5e->rlqn6c());return PHPExcel_Calculation_Functions::macc33();}}/**
* MOD
*
* @param int $a Dividend
* @param int $b Divisor
* @return int Remainder
*/ public static function gsza10($gnqj6d=1,$hoxc6e=1){$gnqj6d=PHPExcel_Calculation_Functions::mefi31($gnqj6d);$hoxc6e=PHPExcel_Calculation_Functions::mefi31($hoxc6e);if($hoxc6e==0.0){return PHPExcel_Calculation_Functions::cfpi32();}elseif(($gnqj6d<0.0)&&($hoxc6e>0.0)){return $hoxc6e-fmod(abs($gnqj6d),$hoxc6e);}elseif(($gnqj6d>0.0)&&($hoxc6e<0.0)){return $hoxc6e+fmod($gnqj6d,abs($hoxc6e));}return fmod($gnqj6d,$hoxc6e);}/**
* MROUND
*
* Rounds a number to the nearest multiple of a specified value
*
* @param float $number Number to round
* @param int $multiple Multiple to which you want to round $number
* @return float Rounded Number
*/ public static function ttvi11($lpcu34,$gkvn6f){$lpcu34=PHPExcel_Calculation_Functions::mefi31($lpcu34);$gkvn6f=PHPExcel_Calculation_Functions::mefi31($gkvn6f);if((is_numeric($lpcu34))&&(is_numeric($gkvn6f))){if($gkvn6f==0){return 0;}if((self::cvpm1c($lpcu34))==(self::cvpm1c($gkvn6f))){$pglm70=1/$gkvn6f;return round($lpcu34*$pglm70)/$pglm70;}return PHPExcel_Calculation_Functions::oxaf37();}return PHPExcel_Calculation_Functions::macc33();}/**
* MULTINOMIAL
*
* Returns the ratio of the factorial of a sum of values to the product of factorials.
*
* @param array of mixed Data Series
* @return float
*/ public static function orwl12(){$pmac71=0;$esbb72=1;foreach(PHPExcel_Calculation_Functions::mmkt3f(func_get_args())as $ibcf73){if(is_numeric($ibcf73)){if($ibcf73<1){return PHPExcel_Calculation_Functions::oxaf37();}$pmac71+=floor($ibcf73);$esbb72*=self::tonz6($ibcf73);}else{return PHPExcel_Calculation_Functions::macc33();}}if($pmac71>0){$pmac71=self::tonz6($pmac71);return $pmac71/$esbb72;}return 0;}/**
* ODD
*
* Returns number rounded up to the nearest odd integer.
*
* @param float $number Number to round
* @return int Rounded Number
*/ public static function zvfm13($lpcu34){$lpcu34=PHPExcel_Calculation_Functions::mefi31($lpcu34);if(is_null($lpcu34)){return 1;}elseif(is_bool($lpcu34)){return 1;}elseif(is_numeric($lpcu34)){$nhhy35=self::cvpm1c($lpcu34);if($nhhy35==0){return 1;}$xbtr74=self::zwjb3($lpcu34,$nhhy35);if($xbtr74==self::bywf5($xbtr74)){$xbtr74+=$nhhy35;}return(int)$xbtr74;}return PHPExcel_Calculation_Functions::macc33();}/**
* POWER
*
* Computes x raised to the power y.
*
* @param float $x
* @param float $y
* @return float
*/ public static function vhvf14($wunv75=0,$osxx76=2){$wunv75=PHPExcel_Calculation_Functions::mefi31($wunv75);$osxx76=PHPExcel_Calculation_Functions::mefi31($osxx76);if($wunv75==0.0&&$osxx76==0.0){return PHPExcel_Calculation_Functions::oxaf37();}elseif($wunv75==0.0&&$osxx76<0.0){return PHPExcel_Calculation_Functions::cfpi32();}$xbtr74=pow($wunv75,$osxx76);return(!is_nan($xbtr74)&&!is_infinite($xbtr74))?$xbtr74:PHPExcel_Calculation_Functions::oxaf37();}/**
* PRODUCT
*
* PRODUCT returns the product of all the values and cells referenced in the argument list.
*
* Excel Function:
* PRODUCT(value1[,value2[, ...]])
*
* @access public
* @category Mathematical and Trigonometric Functions
* @param mixed $arg,... Data values
* @return float
*/ public static function senh15(){$jkbf3d=null;foreach(PHPExcel_Calculation_Functions::mmkt3f(func_get_args())as $ibcf73){if((is_numeric($ibcf73))&&(!is_string($ibcf73))){if(is_null($jkbf3d)){$jkbf3d=$ibcf73;}else{$jkbf3d*=$ibcf73;}}}if(is_null($jkbf3d)){return 0;}return $jkbf3d;}/**
* QUOTIENT
*
* QUOTIENT function returns the integer portion of a division. Numerator is the divided number
* and denominator is the divisor.
*
* Excel Function:
* QUOTIENT(value1[,value2[, ...]])
*
* @access public
* @category Mathematical and Trigonometric Functions
* @param mixed $arg,... Data values
* @return float
*/ public static function izax16(){$jkbf3d=null;foreach(PHPExcel_Calculation_Functions::mmkt3f(func_get_args())as $ibcf73){if((is_numeric($ibcf73))&&(!is_string($ibcf73))){if(is_null($jkbf3d)){$jkbf3d=($ibcf73==0)?0:$ibcf73;}else{if(($jkbf3d==0)||($ibcf73==0)){$jkbf3d=0;}else{$jkbf3d/=$ibcf73;}}}}return intval($jkbf3d);}/**
* RAND
*
* @param int $min Minimal value
* @param int $max Maximal value
* @return int Random number
*/ public static function ihgb17($optv77=0,$tdxa78=0){$optv77=PHPExcel_Calculation_Functions::mefi31($optv77);$tdxa78=PHPExcel_Calculation_Functions::mefi31($tdxa78);if($optv77==0&&$tdxa78==0){return(mt_rand(0,10000000))/10000000;}else{return mt_rand($optv77,$tdxa78);}}public static function zkjy18($uaps79,$mfzp7a=0){$uaps79=PHPExcel_Calculation_Functions::mefi31($uaps79);$mfzp7a=(is_null($mfzp7a))?0:(integer)PHPExcel_Calculation_Functions::mefi31($mfzp7a);if((!is_numeric($uaps79))||($uaps79<0)||($uaps79>=4000)){return PHPExcel_Calculation_Functions::macc33();}$uaps79=(integer)$uaps79;if($uaps79==0){return '';}$yvoj7b=array('',base64_decode('TQ=='),base64_decode('TU0='),base64_decode('TU1N'),base64_decode('TU1NTQ=='),base64_decode('TU1NTU0='));$zoon7c=array('',base64_decode('Qw=='),base64_decode('Q0M='),base64_decode('Q0ND'),base64_decode('Q0Q='),base64_decode('RA=='),base64_decode('REM='),base64_decode('REND'),base64_decode('RENDQw=='),base64_decode('Q00='));$kiio7d=array('',base64_decode('WA=='),base64_decode('WFg='),base64_decode('WFhY'),base64_decode('WEw='),base64_decode('TA=='),base64_decode('TFg='),base64_decode('TFhY'),base64_decode('TFhYWA=='),base64_decode('WEM='));$jjcz7e=array('',base64_decode('SQ=='),base64_decode('SUk='),base64_decode('SUlJ'),base64_decode('SVY='),base64_decode('Vg=='),base64_decode('Vkk='),base64_decode('VklJ'),base64_decode('VklJSQ=='),base64_decode('SVg='));$cevj7f='';while($uaps79>5999){$cevj7f.=base64_decode('TQ==');$uaps79-=1000;}$ptgw80=self::saxz1($uaps79,1000);$uaps79%=1000;$ojau81=self::saxz1($uaps79,100);$uaps79%=100;$qbqb82=self::saxz1($uaps79,10);$uaps79%=10;return $cevj7f.$yvoj7b[$ptgw80].$zoon7c[$ojau81].$kiio7d[$qbqb82].$jjcz7e[$uaps79];}/**
* ROUNDUP
*
* Rounds a number up to a specified number of decimal places
*
* @param float $number Number to round
* @param int $digits Number of digits to which you want to round $number
* @return float Rounded Number
*/ public static function fpjl19($lpcu34,$pexr83){$lpcu34=PHPExcel_Calculation_Functions::mefi31($lpcu34);$pexr83=PHPExcel_Calculation_Functions::mefi31($pexr83);if((is_numeric($lpcu34))&&(is_numeric($pexr83))){$nhhy35=pow(10,(int)$pexr83);if($lpcu34<0.0){return floor($lpcu34*$nhhy35)/$nhhy35;}else{return ceil($lpcu34*$nhhy35)/$nhhy35;}}return PHPExcel_Calculation_Functions::macc33();}/**
* ROUNDDOWN
*
* Rounds a number down to a specified number of decimal places
*
* @param float $number Number to round
* @param int $digits Number of digits to which you want to round $number
* @return float Rounded Number
*/ public static function wcqg1a($lpcu34,$pexr83){$lpcu34=PHPExcel_Calculation_Functions::mefi31($lpcu34);$pexr83=PHPExcel_Calculation_Functions::mefi31($pexr83);if((is_numeric($lpcu34))&&(is_numeric($pexr83))){$nhhy35=pow(10,(int)$pexr83);if($lpcu34<0.0){return ceil($lpcu34*$nhhy35)/$nhhy35;}else{return floor($lpcu34*$nhhy35)/$nhhy35;}}return PHPExcel_Calculation_Functions::macc33();}/**
* SERIESSUM
*
* Returns the sum of a power series
*
* @param float $x Input value to the power series
* @param float $n Initial power to which you want to raise $x
* @param float $m Step by which to increase $n for each term in the series
* @param array of mixed Data Series
* @return float
*/ public static function ljup1b(){$jkbf3d=0;$pwkh84=PHPExcel_Calculation_Functions::mmkt3f(func_get_args());$wunv75=array_shift($pwkh84);$pfsb2e=array_shift($pwkh84);$ptgw80=array_shift($pwkh84);if((is_numeric($wunv75))&&(is_numeric($pfsb2e))&&(is_numeric($ptgw80))){$awiu2c=0;foreach($pwkh84 as $ibcf73){if((is_numeric($ibcf73))&&(!is_string($ibcf73))){$jkbf3d+=$ibcf73*pow($wunv75,$pfsb2e+($ptgw80*$awiu2c++));}else{return PHPExcel_Calculation_Functions::macc33();}}return $jkbf3d;}return PHPExcel_Calculation_Functions::macc33();}/**
* SIGN
*
* Determines the sign of a number. Returns 1 if the number is positive, zero (0)
* if the number is 0, and -1 if the number is negative.
*
* @param float $number Number to round
* @return int sign value
*/ public static function cvpm1c($lpcu34){$lpcu34=PHPExcel_Calculation_Functions::mefi31($lpcu34);if(is_bool($lpcu34)){return(int)$lpcu34;}if(is_numeric($lpcu34)){if($lpcu34==0.0){return 0;}return $lpcu34/abs($lpcu34);}return PHPExcel_Calculation_Functions::macc33();}/**
* SQRTPI
*
* Returns the square root of (number * pi).
*
* @param float $number Number
* @return float Square Root of Number * Pi
*/ public static function czqr1d($lpcu34){$lpcu34=PHPExcel_Calculation_Functions::mefi31($lpcu34);if(is_numeric($lpcu34)){if($lpcu34<0){return PHPExcel_Calculation_Functions::oxaf37();}return sqrt($lpcu34*M_PI);}return PHPExcel_Calculation_Functions::macc33();}/**
* SUBTOTAL
*
* Returns a subtotal in a list or database.
*
* @param int the number 1 to 11 that specifies which function to
* use in calculating subtotals within a list.
* @param array of mixed Data Series
* @return float
*/ public static function ikds1e(){$pwkh84=PHPExcel_Calculation_Functions::mmkt3f(func_get_args());$tfof85=array_shift($pwkh84);if((is_numeric($tfof85))&&(!is_string($tfof85))){switch($tfof85){case 1:return PHPExcel_Calculation_Statistical::dqpa86($pwkh84);case 2:return PHPExcel_Calculation_Statistical::COUNT($pwkh84);case 3:return PHPExcel_Calculation_Statistical::zyga87($pwkh84);case 4:return PHPExcel_Calculation_Statistical::MAX($pwkh84);case 5:return PHPExcel_Calculation_Statistical::MIN($pwkh84);case 6:return self::senh15($pwkh84);case 7:return PHPExcel_Calculation_Statistical::mnmp88($pwkh84);case 8:return PHPExcel_Calculation_Statistical::tloz89($pwkh84);case 9:return self::qckk1f($pwkh84);case 10:return PHPExcel_Calculation_Statistical::ovep8a($pwkh84);case 11:return PHPExcel_Calculation_Statistical::pgqg8b($pwkh84);}}return PHPExcel_Calculation_Functions::macc33();}/**
* SUM
*
* SUM computes the sum of all the values and cells referenced in the argument list.
*
* Excel Function:
* SUM(value1[,value2[, ...]])
*
* @access public
* @category Mathematical and Trigonometric Functions
* @param mixed $arg,... Data values
* @return float
*/ public static function qckk1f(){$jkbf3d=0;foreach(PHPExcel_Calculation_Functions::mmkt3f(func_get_args())as $ibcf73){if((is_numeric($ibcf73))&&(!is_string($ibcf73))){$jkbf3d+=$ibcf73;}}return $jkbf3d;}/**
* SUMIF
*
* Counts the number of cells that contain numbers within the list of arguments
*
* Excel Function:
* SUMIF(value1[,value2[, ...]],condition)
*
* @access public
* @category Mathematical and Trigonometric Functions
* @param mixed $arg,... Data values
* @param string $condition The criteria that defines which cells will be summed.
* @return float
*/ public static function ppng20($pwkh84,$setu8c,$vzxz8d=array()){$jkbf3d=0;$pwkh84=PHPExcel_Calculation_Functions::mmkt3f($pwkh84);$vzxz8d=PHPExcel_Calculation_Functions::mmkt3f($vzxz8d);if(empty($vzxz8d)){$vzxz8d=$pwkh84;}$setu8c=PHPExcel_Calculation_Functions::uzjg8e($setu8c);foreach($pwkh84 as $gbzj4a=>$ibcf73){if(!is_numeric($ibcf73)){$ibcf73=str_replace(base64_decode('Ig=='),base64_decode('IiI='),$ibcf73);$ibcf73=PHPExcel_Calculation::mnvx8f(strtoupper($ibcf73));}$nudc90=base64_decode('PQ==').$ibcf73.$setu8c;if(PHPExcel_Calculation::kcsf91()->adam92($nudc90)){$jkbf3d+=$vzxz8d[$gbzj4a];}}return $jkbf3d;}/**
* SUMIFS
*
* Counts the number of cells that contain numbers within the list of arguments
*
* Excel Function:
* SUMIFS(value1[,value2[, ...]],condition)
*
* @access public
* @category Mathematical and Trigonometric Functions
* @param mixed $arg,... Data values
* @param string $condition The criteria that defines which cells will be summed.
* @return float
*/ public static function ygno21(){$enyi93=func_get_args();$vzxz8d=PHPExcel_Calculation_Functions::mmkt3f(array_shift($enyi93));while(count($enyi93)>0){$ejua94[]=PHPExcel_Calculation_Functions::mmkt3f(array_shift($enyi93));$ecwc95[]=PHPExcel_Calculation_Functions::uzjg8e(array_shift($enyi93));}foreach($ecwc95 as $rbsr96=>$setu8c){$pwkh84=$ejua94[$rbsr96];$iays97=false;if((strpos($setu8c,base64_decode('Kg=='))!==false)||(strpos($setu8c,base64_decode('Pw=='))!==false)){$setu8c=trim(ltrim($setu8c,base64_decode('PTw+')),base64_decode('Ig=='));$iays97=true;}foreach($pwkh84 as $gbzj4a=>$ibcf73){if($iays97){if(!fnmatch($setu8c,$ibcf73,FNM_CASEFOLD)){$vzxz8d[$gbzj4a]=0.0;}}else{if(!is_numeric($ibcf73)){$ibcf73=PHPExcel_Calculation::mnvx8f(strtoupper($ibcf73));}$nudc90=base64_decode('PQ==').$ibcf73.$setu8c;if(!PHPExcel_Calculation::kcsf91()->adam92($nudc90)){$vzxz8d[$gbzj4a]=0.0;}}}}return array_sum($vzxz8d);}/**
* SUMPRODUCT
*
* Excel Function:
* SUMPRODUCT(value1[,value2[, ...]])
*
* @access public
* @category Mathematical and Trigonometric Functions
* @param mixed $arg,... Data values
* @return float
*/ public static function ucck22(){$enyi93=func_get_args();$qqmg98=PHPExcel_Calculation_Functions::mmkt3f(array_shift($enyi93));$rcio99=count($qqmg98);for($awiu2c=0;$awiu2c<$rcio99;++$awiu2c){if((!is_numeric($qqmg98[$awiu2c]))||(is_string($qqmg98[$awiu2c]))){$qqmg98[$awiu2c]=0;}}foreach($enyi93 as $dhjy55){$smzu9a=PHPExcel_Calculation_Functions::mmkt3f($dhjy55);$eqtp9b=count($smzu9a);if($rcio99!=$eqtp9b){return PHPExcel_Calculation_Functions::macc33();}foreach($smzu9a as $awiu2c=>$brtm9c){if((!is_numeric($brtm9c))||(is_string($brtm9c))){$brtm9c=0;}$qqmg98[$awiu2c]*=$brtm9c;}}return array_sum($qqmg98);}/**
* SUMSQ
*
* SUMSQ returns the sum of the squares of the arguments
*
* Excel Function:
* SUMSQ(value1[,value2[, ...]])
*
* @access public
* @category Mathematical and Trigonometric Functions
* @param mixed $arg,... Data values
* @return float
*/ public static function rayn23(){$jkbf3d=0;foreach(PHPExcel_Calculation_Functions::mmkt3f(func_get_args())as $ibcf73){if((is_numeric($ibcf73))&&(!is_string($ibcf73))){$jkbf3d+=($ibcf73*$ibcf73);}}return $jkbf3d;}/**
* SUMX2MY2
*
* @param mixed[] $matrixData1 Matrix #1
* @param mixed[] $matrixData2 Matrix #2
* @return float
*/ public static function hhmd24($pdaj61,$nbvw62){$pzea9d=PHPExcel_Calculation_Functions::mmkt3f($pdaj61);$smzu9a=PHPExcel_Calculation_Functions::mmkt3f($nbvw62);$eqtp9b=min(count($pzea9d),count($smzu9a));$xbtr74=0;for($awiu2c=0;$awiu2c<$eqtp9b;++$awiu2c){if(((is_numeric($pzea9d[$awiu2c]))&&(!is_string($pzea9d[$awiu2c])))&&((is_numeric($smzu9a[$awiu2c]))&&(!is_string($smzu9a[$awiu2c])))){$xbtr74+=($pzea9d[$awiu2c]*$pzea9d[$awiu2c])-($smzu9a[$awiu2c]*$smzu9a[$awiu2c]);}}return $xbtr74;}/**
* SUMX2PY2
*
* @param mixed[] $matrixData1 Matrix #1
* @param mixed[] $matrixData2 Matrix #2
* @return float
*/ public static function pygm25($pdaj61,$nbvw62){$pzea9d=PHPExcel_Calculation_Functions::mmkt3f($pdaj61);$smzu9a=PHPExcel_Calculation_Functions::mmkt3f($nbvw62);$eqtp9b=min(count($pzea9d),count($smzu9a));$xbtr74=0;for($awiu2c=0;$awiu2c<$eqtp9b;++$awiu2c){if(((is_numeric($pzea9d[$awiu2c]))&&(!is_string($pzea9d[$awiu2c])))&&((is_numeric($smzu9a[$awiu2c]))&&(!is_string($smzu9a[$awiu2c])))){$xbtr74+=($pzea9d[$awiu2c]*$pzea9d[$awiu2c])+($smzu9a[$awiu2c]*$smzu9a[$awiu2c]);}}return $xbtr74;}/**
* SUMXMY2
*
* @param mixed[] $matrixData1 Matrix #1
* @param mixed[] $matrixData2 Matrix #2
* @return float
*/ public static function emps26($pdaj61,$nbvw62){$pzea9d=PHPExcel_Calculation_Functions::mmkt3f($pdaj61);$smzu9a=PHPExcel_Calculation_Functions::mmkt3f($nbvw62);$eqtp9b=min(count($pzea9d),count($smzu9a));$xbtr74=0;for($awiu2c=0;$awiu2c<$eqtp9b;++$awiu2c){if(((is_numeric($pzea9d[$awiu2c]))&&(!is_string($pzea9d[$awiu2c])))&&((is_numeric($smzu9a[$awiu2c]))&&(!is_string($smzu9a[$awiu2c])))){$xbtr74+=($pzea9d[$awiu2c]-$smzu9a[$awiu2c])*($pzea9d[$awiu2c]-$smzu9a[$awiu2c]);}}return $xbtr74;}/**
* TRUNC
*
* Truncates value to the number of fractional digits by number_digits.
*
* @param float $value
* @param int $digits
* @return float Truncated value
*/ public static function rukc27($bxuf29=0,$pexr83=0){$bxuf29=PHPExcel_Calculation_Functions::mefi31($bxuf29);$pexr83=PHPExcel_Calculation_Functions::mefi31($pexr83);if((!is_numeric($bxuf29))||(!is_numeric($pexr83))){return PHPExcel_Calculation_Functions::macc33();}$pexr83=floor($pexr83);$aunr9e=pow(10,$pexr83);if(($pexr83>0)&&(rtrim(intval((abs($bxuf29)-abs(intval($bxuf29)))*$aunr9e),base64_decode('MA=='))<$aunr9e/10)){return $bxuf29;}return(intval($bxuf29*$aunr9e))/$aunr9e;}}?>
Did this file decode correctly?
Original Code
<?php /** PHPExcel root directory */ if(!defined(base64_decode('UEhQRVhDRUxfUk9PVA=='))){/**
* @ignore
*/ define(base64_decode('UEhQRVhDRUxfUk9PVA=='),dirname(__FILE__).base64_decode('Ly4uLy4uLw=='));require(PHPEXCEL_ROOT.base64_decode('UEhQRXhjZWwvQXV0b2xvYWRlci5waHA='));}/**
* PHPExcel_Calculation_MathTrig
*
* Copyright (c) 2006 - 2015 PHPExcel
*
* This library is free software; you can redistribute it and/or
* modify it under the terms of the GNU Lesser General Public
* License as published by the Free Software Foundation; either
* version 2.1 of the License, or (at your option) any later version.
*
* This library is distributed in the hope that it will be useful,
* but WITHOUT ANY WARRANTY; without even the implied warranty of
* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU
* Lesser General Public License for more details.
*
* You should have received a copy of the GNU Lesser General Public
* License along with this library; if not, write to the Free Software
* Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA
*
* @category PHPExcel
* @package PHPExcel_Calculation
* @copyright Copyright (c) 2006 - 2015 PHPExcel (http://www.codeplex.com/PHPExcel)
* @license http://www.gnu.org/licenses/old-licenses/lgpl-2.1.txt LGPL
* @version ##VERSION##, ##DATE##
*/ class qhgx28{private static function vvbl0($bxuf29){$jtpf2a=floor(sqrt($bxuf29));$cuor2b=array();for($awiu2c=$jtpf2a;$awiu2c>1;--$awiu2c){if(($bxuf29%$awiu2c)==0){$cuor2b=array_merge($cuor2b,self::vvbl0($bxuf29/$awiu2c));$cuor2b=array_merge($cuor2b,self::vvbl0($awiu2c));if($awiu2c<=sqrt($bxuf29)){break;}}}if(!empty($cuor2b)){rsort($cuor2b);return $cuor2b;}else{returnarray((integer)$bxuf29);}}private static function saxz1($gbqe2d,$pfsb2e){return($gbqe2d-($gbqe2d%$pfsb2e))/$pfsb2e;}/**
* ATAN2
*
* This function calculates the arc tangent of the two variables x and y. It is similar to
* calculating the arc tangent of y x, except that the signs of both arguments are used
* to determine the quadrant of the result.
* The arctangent is the angle from the x-axis to a line containing the origin (0, 0) and a
* point with coordinates (xCoordinate, yCoordinate). The angle is given in radians between
* -pi and pi, excluding -pi.
*
* Note that the Excel ATAN2() function accepts its arguments in the reverse order to the standard
* PHP atan2() function, so we need to reverse them here before calling the PHP atan() function.
*
* Excel Function:
* ATAN2(xCoordinate,yCoordinate)
*
* @access public
* @category Mathematical and Trigonometric Functions
* @param float $xCoordinate The x-coordinate of the point.
* @param float $yCoordinate The y-coordinate of the point.
* @return float The inverse tangent of the specified x- and y-coordinates.
*/ public static function bxqr2($hvjd2f=null,$nvmz30=null){$hvjd2f=PHPExcel_Calculation_Functions::mefi31($hvjd2f);$nvmz30=PHPExcel_Calculation_Functions::mefi31($nvmz30);$hvjd2f=($hvjd2f!==null)?$hvjd2f:0.0;$nvmz30=($nvmz30!==null)?$nvmz30:0.0;if(((is_numeric($hvjd2f))||(is_bool($hvjd2f)))&&((is_numeric($nvmz30)))||(is_bool($nvmz30))){$hvjd2f=(float)$hvjd2f;$nvmz30=(float)$nvmz30;if(($hvjd2f==0)&&($nvmz30==0)){return PHPExcel_Calculation_Functions::cfpi32();}return atan2($nvmz30,$hvjd2f);}return PHPExcel_Calculation_Functions::macc33();}/**
* CEILING
*
* Returns number rounded up, away from zero, to the nearest multiple of significance.
* For example, if you want to avoid using pennies in your prices and your product is
* priced at $4.42, use the formula =CEILING(4.42,0.05) to round prices up to the
* nearest nickel.
*
* Excel Function:
* CEILING(number[,significance])
*
* @access public
* @category Mathematical and Trigonometric Functions
* @param float $number The number you want to round.
* @param float $significance The multiple to which you want to round.
* @return float Rounded Number
*/ public static function zwjb3($lpcu34,$nhhy35=null){$lpcu34=PHPExcel_Calculation_Functions::mefi31($lpcu34);$nhhy35=PHPExcel_Calculation_Functions::mefi31($nhhy35);if((is_null($nhhy35))&&(PHPExcel_Calculation_Functions::trjs36()==PHPExcel_Calculation_Functions::COMPATIBILITY_GNUMERIC)){$nhhy35=$lpcu34/abs($lpcu34);}if((is_numeric($lpcu34))&&(is_numeric($nhhy35))){if(($lpcu34==0.0)||($nhhy35==0.0)){return 0.0;}elseif(self::cvpm1c($lpcu34)==self::cvpm1c($nhhy35)){return ceil($lpcu34/$nhhy35)*$nhhy35;}else{return PHPExcel_Calculation_Functions::oxaf37();}}return PHPExcel_Calculation_Functions::macc33();}/**
* COMBIN
*
* Returns the number of combinations for a given number of items. Use COMBIN to
* determine the total possible number of groups for a given number of items.
*
* Excel Function:
* COMBIN(numObjs,numInSet)
*
* @access public
* @category Mathematical and Trigonometric Functions
* @param int $numObjs Number of different objects
* @param int $numInSet Number of objects in each combination
* @return int Number of combinations
*/ public static function gjyr4($cuiq38,$ptlp39){$cuiq38=PHPExcel_Calculation_Functions::mefi31($cuiq38);$ptlp39=PHPExcel_Calculation_Functions::mefi31($ptlp39);if((is_numeric($cuiq38))&&(is_numeric($ptlp39))){if($cuiq38<$ptlp39){return PHPExcel_Calculation_Functions::oxaf37();}elseif($ptlp39<0){return PHPExcel_Calculation_Functions::oxaf37();}return round(self::tonz6($cuiq38)/self::tonz6($cuiq38-$ptlp39))/self::tonz6($ptlp39);}return PHPExcel_Calculation_Functions::macc33();}/**
* EVEN
*
* Returns number rounded up to the nearest even integer.
* You can use this function for processing items that come in twos. For example,
* a packing crate accepts rows of one or two items. The crate is full when
* the number of items, rounded up to the nearest two, matches the crate's
* capacity.
*
* Excel Function:
* EVEN(number)
*
* @access public
* @category Mathematical and Trigonometric Functions
* @param float $number Number to round
* @return int Rounded Number
*/ public static function bywf5($lpcu34){$lpcu34=PHPExcel_Calculation_Functions::mefi31($lpcu34);if(is_null($lpcu34)){return 0;}elseif(is_bool($lpcu34)){$lpcu34=(int)$lpcu34;}if(is_numeric($lpcu34)){$nhhy35=2*self::cvpm1c($lpcu34);return(int)self::zwjb3($lpcu34,$nhhy35);}return PHPExcel_Calculation_Functions::macc33();}/**
* FACT
*
* Returns the factorial of a number.
* The factorial of a number is equal to 1*2*3*...* number.
*
* Excel Function:
* FACT(factVal)
*
* @access public
* @category Mathematical and Trigonometric Functions
* @param float $factVal Factorial Value
* @return int Factorial
*/ public static function tonz6($tznm3a){$tznm3a=PHPExcel_Calculation_Functions::mefi31($tznm3a);if(is_numeric($tznm3a)){if($tznm3a<0){return PHPExcel_Calculation_Functions::oxaf37();}$bqml3b=floor($tznm3a);if(PHPExcel_Calculation_Functions::trjs36()==PHPExcel_Calculation_Functions::COMPATIBILITY_GNUMERIC){if($tznm3a>$bqml3b){return PHPExcel_Calculation_Functions::oxaf37();}}$wezh3c=1;while($bqml3b>1){$wezh3c*=$bqml3b--;}return $wezh3c;}return PHPExcel_Calculation_Functions::macc33();}/**
* FACTDOUBLE
*
* Returns the double factorial of a number.
*
* Excel Function:
* FACTDOUBLE(factVal)
*
* @access public
* @category Mathematical and Trigonometric Functions
* @param float $factVal Factorial Value
* @return int Double Factorial
*/ public static function uhsi7($tznm3a){$bqml3b=PHPExcel_Calculation_Functions::mefi31($tznm3a);if(is_numeric($bqml3b)){$bqml3b=floor($bqml3b);if($tznm3a<0){return PHPExcel_Calculation_Functions::oxaf37();}$wezh3c=1;while($bqml3b>1){$wezh3c*=$bqml3b--;--$bqml3b;}return $wezh3c;}return PHPExcel_Calculation_Functions::macc33();}/**
* FLOOR
*
* Rounds number down, toward zero, to the nearest multiple of significance.
*
* Excel Function:
* FLOOR(number[,significance])
*
* @access public
* @category Mathematical and Trigonometric Functions
* @param float $number Number to round
* @param float $significance Significance
* @return float Rounded Number
*/ public static function ekly8($lpcu34,$nhhy35=null){$lpcu34=PHPExcel_Calculation_Functions::mefi31($lpcu34);$nhhy35=PHPExcel_Calculation_Functions::mefi31($nhhy35);if((is_null($nhhy35))&&(PHPExcel_Calculation_Functions::trjs36()==PHPExcel_Calculation_Functions::COMPATIBILITY_GNUMERIC)){$nhhy35=$lpcu34/abs($lpcu34);}if((is_numeric($lpcu34))&&(is_numeric($nhhy35))){if($nhhy35==0.0){return PHPExcel_Calculation_Functions::cfpi32();}elseif($lpcu34==0.0){return 0.0;}elseif(self::cvpm1c($lpcu34)==self::cvpm1c($nhhy35)){return floor($lpcu34/$nhhy35)*$nhhy35;}else{return PHPExcel_Calculation_Functions::oxaf37();}}return PHPExcel_Calculation_Functions::macc33();}/**
* GCD
*
* Returns the greatest common divisor of a series of numbers.
* The greatest common divisor is the largest integer that divides both
* number1 and number2 without a remainder.
*
* Excel Function:
* GCD(number1[,number2[, ...]])
*
* @access public
* @category Mathematical and Trigonometric Functions
* @param mixed $arg,... Data values
* @return integer Greatest Common Divisor
*/ public static function bvvy9(){$jkbf3d=1;$jqle3e=array();foreach(PHPExcel_Calculation_Functions::mmkt3f(func_get_args())as $bxuf29){if(!is_numeric($bxuf29)){return PHPExcel_Calculation_Functions::macc33();}elseif($bxuf29==0){continue;}elseif($bxuf29<0){return PHPExcel_Calculation_Functions::oxaf37();}$kczh40=self::vvbl0($bxuf29);$onya41=array_count_values($kczh40);$jqle3e[]=$onya41;}$pqjw42=count($jqle3e);if($pqjw42==0){return 0;}$yzkl43=$jqle3e[0];for($awiu2c=1;$awiu2c<$pqjw42;++$awiu2c){$yzkl43=array_intersect_key($yzkl43,$jqle3e[$awiu2c]);}$gkbo44=count($yzkl43);if($gkbo44==0){return $jkbf3d;}elseif($gkbo44>1){foreach($yzkl43 as $husr45=>$cxcx46){foreach($jqle3e as $emzs47){foreach($emzs47 as $fdsu48=>$jeba49){if(($fdsu48==$husr45)&&($jeba49<$cxcx46)){$yzkl43[$husr45]=$jeba49;$cxcx46=$jeba49;}}}}$jkbf3d=1;foreach($yzkl43 as $gbzj4a=>$bxuf29){$jkbf3d*=pow($gbzj4a,$bxuf29);}return $jkbf3d;}else{$yott4b=array_keys($yzkl43);$gbzj4a=$yott4b[0];$bxuf29=$yzkl43[$gbzj4a];foreach($jqle3e as $jeba49){foreach($jeba49 as $husr45=>$cxcx46){if(($husr45==$gbzj4a)&&($cxcx46<$bxuf29)){$bxuf29=$cxcx46;}}}return pow($gbzj4a,$bxuf29);}}/**
* INT
*
* Casts a floating point value to an integer
*
* Excel Function:
* INT(number)
*
* @access public
* @category Mathematical and Trigonometric Functions
* @param float $number Number to cast to an integer
* @return integer Integer value
*/ public static function bzmxa($lpcu34){$lpcu34=PHPExcel_Calculation_Functions::mefi31($lpcu34);if(is_null($lpcu34)){return 0;}elseif(is_bool($lpcu34)){return(int)$lpcu34;}if(is_numeric($lpcu34)){return(int)floor($lpcu34);}return PHPExcel_Calculation_Functions::macc33();}/**
* LCM
*
* Returns the lowest common multiplier of a series of numbers
* The least common multiple is the smallest positive integer that is a multiple
* of all integer arguments number1, number2, and so on. Use LCM to add fractions
* with different denominators.
*
* Excel Function:
* LCM(number1[,number2[, ...]])
*
* @access public
* @category Mathematical and Trigonometric Functions
* @param mixed $arg,... Data values
* @return int Lowest Common Multiplier
*/ public static function xsjhb(){$jkbf3d=1;$ktns4c=array();foreach(PHPExcel_Calculation_Functions::mmkt3f(func_get_args())as $bxuf29){if(!is_numeric($bxuf29)){return PHPExcel_Calculation_Functions::macc33();}if($bxuf29==0){return 0;}elseif($bxuf29<0){return PHPExcel_Calculation_Functions::oxaf37();}$kczh40=self::vvbl0(floor($bxuf29));$onya41=array_count_values($kczh40);$iefi4d=array();foreach($onya41 as $udfg4e=>$yrug4f){$iefi4d[$udfg4e]=pow($udfg4e,$yrug4f);}foreach($iefi4d as $yhvp50=>$btyg51){if(array_key_exists($yhvp50,$ktns4c)){if($ktns4c[$yhvp50]<$btyg51){$ktns4c[$yhvp50]=$btyg51;}}else{$ktns4c[$yhvp50]=$btyg51;}}}foreach($ktns4c as $aodx52){$jkbf3d*=(integer)$aodx52;}return $jkbf3d;}/**
* LOG_BASE
*
* Returns the logarithm of a number to a specified base. The default base is 10.
*
* Excel Function:
* LOG(number[,base])
*
* @access public
* @category Mathematical and Trigonometric Functions
* @param float $number The positive real number for which you want the logarithm
* @param float $base The base of the logarithm. If base is omitted, it is assumed to be 10.
* @return float
*/ public static function ovacc($lpcu34=null,$oejj53=10){$lpcu34=PHPExcel_Calculation_Functions::mefi31($lpcu34);$oejj53=(is_null($oejj53))?10:(float)PHPExcel_Calculation_Functions::mefi31($oejj53);if((!is_numeric($oejj53))||(!is_numeric($lpcu34))){return PHPExcel_Calculation_Functions::macc33();}if(($oejj53<=0)||($lpcu34<=0)){return PHPExcel_Calculation_Functions::oxaf37();}return log($lpcu34,$oejj53);}/**
* MDETERM
*
* Returns the matrix determinant of an array.
*
* Excel Function:
* MDETERM(array)
*
* @access public
* @category Mathematical and Trigonometric Functions
* @param array $matrixValues A matrix of values
* @return float
*/ public static function amxad($suhl54){$dhjy55=array();if(!is_array($suhl54)){$suhl54=array(array($suhl54));}$oiuw56=$zgvz57=0;foreach($suhl54 as $wpti58){if(!is_array($wpti58)){$wpti58=array($wpti58);}$bdqf59=0;foreach($wpti58 as $kbnb5a){if((is_string($kbnb5a))||($kbnb5a===null)){return PHPExcel_Calculation_Functions::macc33();}$dhjy55[$bdqf59][$oiuw56]=$kbnb5a;++$bdqf59;}if($bdqf59>$zgvz57){$zgvz57=$bdqf59;}++$oiuw56;}if($oiuw56!=$zgvz57){return PHPExcel_Calculation_Functions::macc33();}try{$jccp5b=new mjyl5c($dhjy55);return $jccp5b->weww5d();}catch(PHPExcel_Exception $kvof5e){return PHPExcel_Calculation_Functions::macc33();}}/**
* MINVERSE
*
* Returns the inverse matrix for the matrix stored in an array.
*
* Excel Function:
* MINVERSE(array)
*
* @access public
* @category Mathematical and Trigonometric Functions
* @param array $matrixValues A matrix of values
* @return array
*/ public static function avrye($suhl54){$dhjy55=array();if(!is_array($suhl54)){$suhl54=array(array($suhl54));}$oiuw56=$zgvz57=0;foreach($suhl54 as $wpti58){if(!is_array($wpti58)){$wpti58=array($wpti58);}$bdqf59=0;foreach($wpti58 as $kbnb5a){if((is_string($kbnb5a))||($kbnb5a===null)){return PHPExcel_Calculation_Functions::macc33();}$dhjy55[$bdqf59][$oiuw56]=$kbnb5a;++$bdqf59;}if($bdqf59>$zgvz57){$zgvz57=$bdqf59;}++$oiuw56;}if($oiuw56!=$zgvz57){return PHPExcel_Calculation_Functions::macc33();}try{$jccp5b=new mjyl5c($dhjy55);return $jccp5b->mihp5f()->mchg60();}catch(PHPExcel_Exception $kvof5e){return PHPExcel_Calculation_Functions::macc33();}}/**
* MMULT
*
* @param array $matrixData1 A matrix of values
* @param array $matrixData2 A matrix of values
* @return array
*/ public static function dwzef($pdaj61,$nbvw62){$febc63=$himy64=array();if(!is_array($pdaj61)){$pdaj61=array(array($pdaj61));}if(!is_array($nbvw62)){$nbvw62=array(array($nbvw62));}try{$clcs65=0;foreach($pdaj61 as $wpti58){if(!is_array($wpti58)){$wpti58=array($wpti58);}$tmvz66=0;foreach($wpti58 as $kbnb5a){if((!is_numeric($kbnb5a))||($kbnb5a===null)){return PHPExcel_Calculation_Functions::macc33();}$febc63[$clcs65][$tmvz66]=$kbnb5a;++$tmvz66;}++$clcs65;}$guic67=new mjyl5c($febc63);$sqtt68=0;foreach($nbvw62 as $wpti58){if(!is_array($wpti58)){$wpti58=array($wpti58);}$vnkv69=0;foreach($wpti58 as $kbnb5a){if((!is_numeric($kbnb5a))||($kbnb5a===null)){return PHPExcel_Calculation_Functions::macc33();}$himy64[$sqtt68][$vnkv69]=$kbnb5a;++$vnkv69;}++$sqtt68;}$ywcy6a=new mjyl5c($himy64);if($tmvz66!=$sqtt68){return PHPExcel_Calculation_Functions::macc33();}return $guic67->whby6b($ywcy6a)->mchg60();}catch(PHPExcel_Exception $kvof5e){var_dump($kvof5e->rlqn6c());return PHPExcel_Calculation_Functions::macc33();}}/**
* MOD
*
* @param int $a Dividend
* @param int $b Divisor
* @return int Remainder
*/ public static function gsza10($gnqj6d=1,$hoxc6e=1){$gnqj6d=PHPExcel_Calculation_Functions::mefi31($gnqj6d);$hoxc6e=PHPExcel_Calculation_Functions::mefi31($hoxc6e);if($hoxc6e==0.0){return PHPExcel_Calculation_Functions::cfpi32();}elseif(($gnqj6d<0.0)&&($hoxc6e>0.0)){return $hoxc6e-fmod(abs($gnqj6d),$hoxc6e);}elseif(($gnqj6d>0.0)&&($hoxc6e<0.0)){return $hoxc6e+fmod($gnqj6d,abs($hoxc6e));}return fmod($gnqj6d,$hoxc6e);}/**
* MROUND
*
* Rounds a number to the nearest multiple of a specified value
*
* @param float $number Number to round
* @param int $multiple Multiple to which you want to round $number
* @return float Rounded Number
*/ public static function ttvi11($lpcu34,$gkvn6f){$lpcu34=PHPExcel_Calculation_Functions::mefi31($lpcu34);$gkvn6f=PHPExcel_Calculation_Functions::mefi31($gkvn6f);if((is_numeric($lpcu34))&&(is_numeric($gkvn6f))){if($gkvn6f==0){return 0;}if((self::cvpm1c($lpcu34))==(self::cvpm1c($gkvn6f))){$pglm70=1/$gkvn6f;return round($lpcu34*$pglm70)/$pglm70;}return PHPExcel_Calculation_Functions::oxaf37();}return PHPExcel_Calculation_Functions::macc33();}/**
* MULTINOMIAL
*
* Returns the ratio of the factorial of a sum of values to the product of factorials.
*
* @param array of mixed Data Series
* @return float
*/ public static function orwl12(){$pmac71=0;$esbb72=1;foreach(PHPExcel_Calculation_Functions::mmkt3f(func_get_args())as $ibcf73){if(is_numeric($ibcf73)){if($ibcf73<1){return PHPExcel_Calculation_Functions::oxaf37();}$pmac71+=floor($ibcf73);$esbb72*=self::tonz6($ibcf73);}else{return PHPExcel_Calculation_Functions::macc33();}}if($pmac71>0){$pmac71=self::tonz6($pmac71);return $pmac71/$esbb72;}return 0;}/**
* ODD
*
* Returns number rounded up to the nearest odd integer.
*
* @param float $number Number to round
* @return int Rounded Number
*/ public static function zvfm13($lpcu34){$lpcu34=PHPExcel_Calculation_Functions::mefi31($lpcu34);if(is_null($lpcu34)){return 1;}elseif(is_bool($lpcu34)){return 1;}elseif(is_numeric($lpcu34)){$nhhy35=self::cvpm1c($lpcu34);if($nhhy35==0){return 1;}$xbtr74=self::zwjb3($lpcu34,$nhhy35);if($xbtr74==self::bywf5($xbtr74)){$xbtr74+=$nhhy35;}return(int)$xbtr74;}return PHPExcel_Calculation_Functions::macc33();}/**
* POWER
*
* Computes x raised to the power y.
*
* @param float $x
* @param float $y
* @return float
*/ public static function vhvf14($wunv75=0,$osxx76=2){$wunv75=PHPExcel_Calculation_Functions::mefi31($wunv75);$osxx76=PHPExcel_Calculation_Functions::mefi31($osxx76);if($wunv75==0.0&&$osxx76==0.0){return PHPExcel_Calculation_Functions::oxaf37();}elseif($wunv75==0.0&&$osxx76<0.0){return PHPExcel_Calculation_Functions::cfpi32();}$xbtr74=pow($wunv75,$osxx76);return(!is_nan($xbtr74)&&!is_infinite($xbtr74))?$xbtr74:PHPExcel_Calculation_Functions::oxaf37();}/**
* PRODUCT
*
* PRODUCT returns the product of all the values and cells referenced in the argument list.
*
* Excel Function:
* PRODUCT(value1[,value2[, ...]])
*
* @access public
* @category Mathematical and Trigonometric Functions
* @param mixed $arg,... Data values
* @return float
*/ public static function senh15(){$jkbf3d=null;foreach(PHPExcel_Calculation_Functions::mmkt3f(func_get_args())as $ibcf73){if((is_numeric($ibcf73))&&(!is_string($ibcf73))){if(is_null($jkbf3d)){$jkbf3d=$ibcf73;}else{$jkbf3d*=$ibcf73;}}}if(is_null($jkbf3d)){return 0;}return $jkbf3d;}/**
* QUOTIENT
*
* QUOTIENT function returns the integer portion of a division. Numerator is the divided number
* and denominator is the divisor.
*
* Excel Function:
* QUOTIENT(value1[,value2[, ...]])
*
* @access public
* @category Mathematical and Trigonometric Functions
* @param mixed $arg,... Data values
* @return float
*/ public static function izax16(){$jkbf3d=null;foreach(PHPExcel_Calculation_Functions::mmkt3f(func_get_args())as $ibcf73){if((is_numeric($ibcf73))&&(!is_string($ibcf73))){if(is_null($jkbf3d)){$jkbf3d=($ibcf73==0)?0:$ibcf73;}else{if(($jkbf3d==0)||($ibcf73==0)){$jkbf3d=0;}else{$jkbf3d/=$ibcf73;}}}}return intval($jkbf3d);}/**
* RAND
*
* @param int $min Minimal value
* @param int $max Maximal value
* @return int Random number
*/ public static function ihgb17($optv77=0,$tdxa78=0){$optv77=PHPExcel_Calculation_Functions::mefi31($optv77);$tdxa78=PHPExcel_Calculation_Functions::mefi31($tdxa78);if($optv77==0&&$tdxa78==0){return(mt_rand(0,10000000))/10000000;}else{return mt_rand($optv77,$tdxa78);}}public static function zkjy18($uaps79,$mfzp7a=0){$uaps79=PHPExcel_Calculation_Functions::mefi31($uaps79);$mfzp7a=(is_null($mfzp7a))?0:(integer)PHPExcel_Calculation_Functions::mefi31($mfzp7a);if((!is_numeric($uaps79))||($uaps79<0)||($uaps79>=4000)){return PHPExcel_Calculation_Functions::macc33();}$uaps79=(integer)$uaps79;if($uaps79==0){return '';}$yvoj7b=array('',base64_decode('TQ=='),base64_decode('TU0='),base64_decode('TU1N'),base64_decode('TU1NTQ=='),base64_decode('TU1NTU0='));$zoon7c=array('',base64_decode('Qw=='),base64_decode('Q0M='),base64_decode('Q0ND'),base64_decode('Q0Q='),base64_decode('RA=='),base64_decode('REM='),base64_decode('REND'),base64_decode('RENDQw=='),base64_decode('Q00='));$kiio7d=array('',base64_decode('WA=='),base64_decode('WFg='),base64_decode('WFhY'),base64_decode('WEw='),base64_decode('TA=='),base64_decode('TFg='),base64_decode('TFhY'),base64_decode('TFhYWA=='),base64_decode('WEM='));$jjcz7e=array('',base64_decode('SQ=='),base64_decode('SUk='),base64_decode('SUlJ'),base64_decode('SVY='),base64_decode('Vg=='),base64_decode('Vkk='),base64_decode('VklJ'),base64_decode('VklJSQ=='),base64_decode('SVg='));$cevj7f='';while($uaps79>5999){$cevj7f.=base64_decode('TQ==');$uaps79-=1000;}$ptgw80=self::saxz1($uaps79,1000);$uaps79%=1000;$ojau81=self::saxz1($uaps79,100);$uaps79%=100;$qbqb82=self::saxz1($uaps79,10);$uaps79%=10;return $cevj7f.$yvoj7b[$ptgw80].$zoon7c[$ojau81].$kiio7d[$qbqb82].$jjcz7e[$uaps79];}/**
* ROUNDUP
*
* Rounds a number up to a specified number of decimal places
*
* @param float $number Number to round
* @param int $digits Number of digits to which you want to round $number
* @return float Rounded Number
*/ public static function fpjl19($lpcu34,$pexr83){$lpcu34=PHPExcel_Calculation_Functions::mefi31($lpcu34);$pexr83=PHPExcel_Calculation_Functions::mefi31($pexr83);if((is_numeric($lpcu34))&&(is_numeric($pexr83))){$nhhy35=pow(10,(int)$pexr83);if($lpcu34<0.0){return floor($lpcu34*$nhhy35)/$nhhy35;}else{return ceil($lpcu34*$nhhy35)/$nhhy35;}}return PHPExcel_Calculation_Functions::macc33();}/**
* ROUNDDOWN
*
* Rounds a number down to a specified number of decimal places
*
* @param float $number Number to round
* @param int $digits Number of digits to which you want to round $number
* @return float Rounded Number
*/ public static function wcqg1a($lpcu34,$pexr83){$lpcu34=PHPExcel_Calculation_Functions::mefi31($lpcu34);$pexr83=PHPExcel_Calculation_Functions::mefi31($pexr83);if((is_numeric($lpcu34))&&(is_numeric($pexr83))){$nhhy35=pow(10,(int)$pexr83);if($lpcu34<0.0){return ceil($lpcu34*$nhhy35)/$nhhy35;}else{return floor($lpcu34*$nhhy35)/$nhhy35;}}return PHPExcel_Calculation_Functions::macc33();}/**
* SERIESSUM
*
* Returns the sum of a power series
*
* @param float $x Input value to the power series
* @param float $n Initial power to which you want to raise $x
* @param float $m Step by which to increase $n for each term in the series
* @param array of mixed Data Series
* @return float
*/ public static function ljup1b(){$jkbf3d=0;$pwkh84=PHPExcel_Calculation_Functions::mmkt3f(func_get_args());$wunv75=array_shift($pwkh84);$pfsb2e=array_shift($pwkh84);$ptgw80=array_shift($pwkh84);if((is_numeric($wunv75))&&(is_numeric($pfsb2e))&&(is_numeric($ptgw80))){$awiu2c=0;foreach($pwkh84 as $ibcf73){if((is_numeric($ibcf73))&&(!is_string($ibcf73))){$jkbf3d+=$ibcf73*pow($wunv75,$pfsb2e+($ptgw80*$awiu2c++));}else{return PHPExcel_Calculation_Functions::macc33();}}return $jkbf3d;}return PHPExcel_Calculation_Functions::macc33();}/**
* SIGN
*
* Determines the sign of a number. Returns 1 if the number is positive, zero (0)
* if the number is 0, and -1 if the number is negative.
*
* @param float $number Number to round
* @return int sign value
*/ public static function cvpm1c($lpcu34){$lpcu34=PHPExcel_Calculation_Functions::mefi31($lpcu34);if(is_bool($lpcu34)){return(int)$lpcu34;}if(is_numeric($lpcu34)){if($lpcu34==0.0){return 0;}return $lpcu34/abs($lpcu34);}return PHPExcel_Calculation_Functions::macc33();}/**
* SQRTPI
*
* Returns the square root of (number * pi).
*
* @param float $number Number
* @return float Square Root of Number * Pi
*/ public static function czqr1d($lpcu34){$lpcu34=PHPExcel_Calculation_Functions::mefi31($lpcu34);if(is_numeric($lpcu34)){if($lpcu34<0){return PHPExcel_Calculation_Functions::oxaf37();}return sqrt($lpcu34*M_PI);}return PHPExcel_Calculation_Functions::macc33();}/**
* SUBTOTAL
*
* Returns a subtotal in a list or database.
*
* @param int the number 1 to 11 that specifies which function to
* use in calculating subtotals within a list.
* @param array of mixed Data Series
* @return float
*/ public static function ikds1e(){$pwkh84=PHPExcel_Calculation_Functions::mmkt3f(func_get_args());$tfof85=array_shift($pwkh84);if((is_numeric($tfof85))&&(!is_string($tfof85))){switch($tfof85){case 1:return PHPExcel_Calculation_Statistical::dqpa86($pwkh84);case 2:return PHPExcel_Calculation_Statistical::COUNT($pwkh84);case 3:return PHPExcel_Calculation_Statistical::zyga87($pwkh84);case 4:return PHPExcel_Calculation_Statistical::MAX($pwkh84);case 5:return PHPExcel_Calculation_Statistical::MIN($pwkh84);case 6:return self::senh15($pwkh84);case 7:return PHPExcel_Calculation_Statistical::mnmp88($pwkh84);case 8:return PHPExcel_Calculation_Statistical::tloz89($pwkh84);case 9:return self::qckk1f($pwkh84);case 10:return PHPExcel_Calculation_Statistical::ovep8a($pwkh84);case 11:return PHPExcel_Calculation_Statistical::pgqg8b($pwkh84);}}return PHPExcel_Calculation_Functions::macc33();}/**
* SUM
*
* SUM computes the sum of all the values and cells referenced in the argument list.
*
* Excel Function:
* SUM(value1[,value2[, ...]])
*
* @access public
* @category Mathematical and Trigonometric Functions
* @param mixed $arg,... Data values
* @return float
*/ public static function qckk1f(){$jkbf3d=0;foreach(PHPExcel_Calculation_Functions::mmkt3f(func_get_args())as $ibcf73){if((is_numeric($ibcf73))&&(!is_string($ibcf73))){$jkbf3d+=$ibcf73;}}return $jkbf3d;}/**
* SUMIF
*
* Counts the number of cells that contain numbers within the list of arguments
*
* Excel Function:
* SUMIF(value1[,value2[, ...]],condition)
*
* @access public
* @category Mathematical and Trigonometric Functions
* @param mixed $arg,... Data values
* @param string $condition The criteria that defines which cells will be summed.
* @return float
*/ public static function ppng20($pwkh84,$setu8c,$vzxz8d=array()){$jkbf3d=0;$pwkh84=PHPExcel_Calculation_Functions::mmkt3f($pwkh84);$vzxz8d=PHPExcel_Calculation_Functions::mmkt3f($vzxz8d);if(empty($vzxz8d)){$vzxz8d=$pwkh84;}$setu8c=PHPExcel_Calculation_Functions::uzjg8e($setu8c);foreach($pwkh84 as $gbzj4a=>$ibcf73){if(!is_numeric($ibcf73)){$ibcf73=str_replace(base64_decode('Ig=='),base64_decode('IiI='),$ibcf73);$ibcf73=PHPExcel_Calculation::mnvx8f(strtoupper($ibcf73));}$nudc90=base64_decode('PQ==').$ibcf73.$setu8c;if(PHPExcel_Calculation::kcsf91()->adam92($nudc90)){$jkbf3d+=$vzxz8d[$gbzj4a];}}return $jkbf3d;}/**
* SUMIFS
*
* Counts the number of cells that contain numbers within the list of arguments
*
* Excel Function:
* SUMIFS(value1[,value2[, ...]],condition)
*
* @access public
* @category Mathematical and Trigonometric Functions
* @param mixed $arg,... Data values
* @param string $condition The criteria that defines which cells will be summed.
* @return float
*/ public static function ygno21(){$enyi93=func_get_args();$vzxz8d=PHPExcel_Calculation_Functions::mmkt3f(array_shift($enyi93));while(count($enyi93)>0){$ejua94[]=PHPExcel_Calculation_Functions::mmkt3f(array_shift($enyi93));$ecwc95[]=PHPExcel_Calculation_Functions::uzjg8e(array_shift($enyi93));}foreach($ecwc95 as $rbsr96=>$setu8c){$pwkh84=$ejua94[$rbsr96];$iays97=false;if((strpos($setu8c,base64_decode('Kg=='))!==false)||(strpos($setu8c,base64_decode('Pw=='))!==false)){$setu8c=trim(ltrim($setu8c,base64_decode('PTw+')),base64_decode('Ig=='));$iays97=true;}foreach($pwkh84 as $gbzj4a=>$ibcf73){if($iays97){if(!fnmatch($setu8c,$ibcf73,FNM_CASEFOLD)){$vzxz8d[$gbzj4a]=0.0;}}else{if(!is_numeric($ibcf73)){$ibcf73=PHPExcel_Calculation::mnvx8f(strtoupper($ibcf73));}$nudc90=base64_decode('PQ==').$ibcf73.$setu8c;if(!PHPExcel_Calculation::kcsf91()->adam92($nudc90)){$vzxz8d[$gbzj4a]=0.0;}}}}return array_sum($vzxz8d);}/**
* SUMPRODUCT
*
* Excel Function:
* SUMPRODUCT(value1[,value2[, ...]])
*
* @access public
* @category Mathematical and Trigonometric Functions
* @param mixed $arg,... Data values
* @return float
*/ public static function ucck22(){$enyi93=func_get_args();$qqmg98=PHPExcel_Calculation_Functions::mmkt3f(array_shift($enyi93));$rcio99=count($qqmg98);for($awiu2c=0;$awiu2c<$rcio99;++$awiu2c){if((!is_numeric($qqmg98[$awiu2c]))||(is_string($qqmg98[$awiu2c]))){$qqmg98[$awiu2c]=0;}}foreach($enyi93 as $dhjy55){$smzu9a=PHPExcel_Calculation_Functions::mmkt3f($dhjy55);$eqtp9b=count($smzu9a);if($rcio99!=$eqtp9b){return PHPExcel_Calculation_Functions::macc33();}foreach($smzu9a as $awiu2c=>$brtm9c){if((!is_numeric($brtm9c))||(is_string($brtm9c))){$brtm9c=0;}$qqmg98[$awiu2c]*=$brtm9c;}}return array_sum($qqmg98);}/**
* SUMSQ
*
* SUMSQ returns the sum of the squares of the arguments
*
* Excel Function:
* SUMSQ(value1[,value2[, ...]])
*
* @access public
* @category Mathematical and Trigonometric Functions
* @param mixed $arg,... Data values
* @return float
*/ public static function rayn23(){$jkbf3d=0;foreach(PHPExcel_Calculation_Functions::mmkt3f(func_get_args())as $ibcf73){if((is_numeric($ibcf73))&&(!is_string($ibcf73))){$jkbf3d+=($ibcf73*$ibcf73);}}return $jkbf3d;}/**
* SUMX2MY2
*
* @param mixed[] $matrixData1 Matrix #1
* @param mixed[] $matrixData2 Matrix #2
* @return float
*/ public static function hhmd24($pdaj61,$nbvw62){$pzea9d=PHPExcel_Calculation_Functions::mmkt3f($pdaj61);$smzu9a=PHPExcel_Calculation_Functions::mmkt3f($nbvw62);$eqtp9b=min(count($pzea9d),count($smzu9a));$xbtr74=0;for($awiu2c=0;$awiu2c<$eqtp9b;++$awiu2c){if(((is_numeric($pzea9d[$awiu2c]))&&(!is_string($pzea9d[$awiu2c])))&&((is_numeric($smzu9a[$awiu2c]))&&(!is_string($smzu9a[$awiu2c])))){$xbtr74+=($pzea9d[$awiu2c]*$pzea9d[$awiu2c])-($smzu9a[$awiu2c]*$smzu9a[$awiu2c]);}}return $xbtr74;}/**
* SUMX2PY2
*
* @param mixed[] $matrixData1 Matrix #1
* @param mixed[] $matrixData2 Matrix #2
* @return float
*/ public static function pygm25($pdaj61,$nbvw62){$pzea9d=PHPExcel_Calculation_Functions::mmkt3f($pdaj61);$smzu9a=PHPExcel_Calculation_Functions::mmkt3f($nbvw62);$eqtp9b=min(count($pzea9d),count($smzu9a));$xbtr74=0;for($awiu2c=0;$awiu2c<$eqtp9b;++$awiu2c){if(((is_numeric($pzea9d[$awiu2c]))&&(!is_string($pzea9d[$awiu2c])))&&((is_numeric($smzu9a[$awiu2c]))&&(!is_string($smzu9a[$awiu2c])))){$xbtr74+=($pzea9d[$awiu2c]*$pzea9d[$awiu2c])+($smzu9a[$awiu2c]*$smzu9a[$awiu2c]);}}return $xbtr74;}/**
* SUMXMY2
*
* @param mixed[] $matrixData1 Matrix #1
* @param mixed[] $matrixData2 Matrix #2
* @return float
*/ public static function emps26($pdaj61,$nbvw62){$pzea9d=PHPExcel_Calculation_Functions::mmkt3f($pdaj61);$smzu9a=PHPExcel_Calculation_Functions::mmkt3f($nbvw62);$eqtp9b=min(count($pzea9d),count($smzu9a));$xbtr74=0;for($awiu2c=0;$awiu2c<$eqtp9b;++$awiu2c){if(((is_numeric($pzea9d[$awiu2c]))&&(!is_string($pzea9d[$awiu2c])))&&((is_numeric($smzu9a[$awiu2c]))&&(!is_string($smzu9a[$awiu2c])))){$xbtr74+=($pzea9d[$awiu2c]-$smzu9a[$awiu2c])*($pzea9d[$awiu2c]-$smzu9a[$awiu2c]);}}return $xbtr74;}/**
* TRUNC
*
* Truncates value to the number of fractional digits by number_digits.
*
* @param float $value
* @param int $digits
* @return float Truncated value
*/ public static function rukc27($bxuf29=0,$pexr83=0){$bxuf29=PHPExcel_Calculation_Functions::mefi31($bxuf29);$pexr83=PHPExcel_Calculation_Functions::mefi31($pexr83);if((!is_numeric($bxuf29))||(!is_numeric($pexr83))){return PHPExcel_Calculation_Functions::macc33();}$pexr83=floor($pexr83);$aunr9e=pow(10,$pexr83);if(($pexr83>0)&&(rtrim(intval((abs($bxuf29)-abs(intval($bxuf29)))*$aunr9e),base64_decode('MA=='))<$aunr9e/10)){return $bxuf29;}return(intval($bxuf29*$aunr9e))/$aunr9e;}}?>
Function Calls
defined | 1 |
base64_decode | 1 |
Stats
MD5 | b19ddf8434f0069b5c3ec56a373a9d36 |
Eval Count | 0 |
Decode Time | 247 ms |