PHPOffice /
PhpSpreadsheet
| @@ 2064-2080 (lines=17) @@ | ||
| 2061 | * |
|
| 2062 | * @return float |
|
| 2063 | */ |
|
| 2064 | public static function SLN($cost, $salvage, $life) |
|
| 2065 | { |
|
| 2066 | $cost = Functions::flattenSingleValue($cost); |
|
| 2067 | $salvage = Functions::flattenSingleValue($salvage); |
|
| 2068 | $life = Functions::flattenSingleValue($life); |
|
| 2069 | ||
| 2070 | // Calculate |
|
| 2071 | if ((is_numeric($cost)) && (is_numeric($salvage)) && (is_numeric($life))) { |
|
| 2072 | if ($life < 0) { |
|
| 2073 | return Functions::NAN(); |
|
| 2074 | } |
|
| 2075 | ||
| 2076 | return ($cost - $salvage) / $life; |
|
| 2077 | } |
|
| 2078 | ||
| 2079 | return Functions::VALUE(); |
|
| 2080 | } |
|
| 2081 | ||
| 2082 | /** |
|
| 2083 | * SYD. |
|
| @@ 2853-2868 (lines=16) @@ | ||
| 2850 | * |
|
| 2851 | * @return int Number of permutations |
|
| 2852 | */ |
|
| 2853 | public static function PERMUT($numObjs, $numInSet) |
|
| 2854 | { |
|
| 2855 | $numObjs = Functions::flattenSingleValue($numObjs); |
|
| 2856 | $numInSet = Functions::flattenSingleValue($numInSet); |
|
| 2857 | ||
| 2858 | if ((is_numeric($numObjs)) && (is_numeric($numInSet))) { |
|
| 2859 | $numInSet = floor($numInSet); |
|
| 2860 | if ($numObjs < $numInSet) { |
|
| 2861 | return Functions::NAN(); |
|
| 2862 | } |
|
| 2863 | ||
| 2864 | return round(MathTrig::FACT($numObjs) / MathTrig::FACT($numObjs - $numInSet)); |
|
| 2865 | } |
|
| 2866 | ||
| 2867 | return Functions::VALUE(); |
|
| 2868 | } |
|
| 2869 | ||
| 2870 | /** |
|
| 2871 | * POISSON. |
|
| @@ 3138-3153 (lines=16) @@ | ||
| 3135 | * |
|
| 3136 | * @return float Standardized value |
|
| 3137 | */ |
|
| 3138 | public static function STANDARDIZE($value, $mean, $stdDev) |
|
| 3139 | { |
|
| 3140 | $value = Functions::flattenSingleValue($value); |
|
| 3141 | $mean = Functions::flattenSingleValue($mean); |
|
| 3142 | $stdDev = Functions::flattenSingleValue($stdDev); |
|
| 3143 | ||
| 3144 | if ((is_numeric($value)) && (is_numeric($mean)) && (is_numeric($stdDev))) { |
|
| 3145 | if ($stdDev <= 0) { |
|
| 3146 | return Functions::NAN(); |
|
| 3147 | } |
|
| 3148 | ||
| 3149 | return ($value - $mean) / $stdDev; |
|
| 3150 | } |
|
| 3151 | ||
| 3152 | return Functions::VALUE(); |
|
| 3153 | } |
|
| 3154 | ||
| 3155 | /** |
|
| 3156 | * STDEV. |
|
