!function(r,n){"object"==typeof exports&&"object"==typeof module?module.exports=n():"function"==typeof define&&define.amd?define([],n):"object"==typeof exports?exports.formulajs=n():r.formulajs=n()}("undefined"!=typeof self?self:this,function(){return function(r){function n(t){if(e[t])return e[t].exports;var a=e[t]={i:t,l:!1,exports:{}};return r[t].call(a.exports,a,a.exports,n),a.l=!0,a.exports}var e={};return n.m=r,n.c=e,n.d=function(r,e,t){n.o(r,e)||Object.defineProperty(r,e,{configurable:!1,enumerable:!0,get:t})},n.n=function(r){var e=r&&r.__esModule?function(){return r.default}:function(){return r};return n.d(e,"a",e),e},n.o=function(r,n){return Object.prototype.hasOwnProperty.call(r,n)},n.p="",n(n.s=11)}([function(r,n){n.nil=new Error("#NULL!"),n.div0=new Error("#DIV/0!"),n.value=new Error("#VALUE!"),n.ref=new Error("#REF!"),n.name=new Error("#NAME?"),n.num=new Error("#NUM!"),n.na=new Error("#N/A"),n.error=new Error("#ERROR!"),n.data=new Error("#GETTING_DATA")},function(r,n,e){var t=e(0);n.flattenShallow=function(r){return r&&r.reduce?r.reduce(function(r,n){var e=Array.isArray(r),t=Array.isArray(n);return e&&t?r.concat(n):e?(r.push(n),r):t?[r].concat(n):[r,n]}):r},n.isFlat=function(r){if(!r)return!1;for(var n=0;n=0?n.ROUND(Math.ceil(r/e)*e,o):0===u?-n.ROUND(Math.floor(Math.abs(r)/e)*e,o):-n.ROUND(Math.ceil(Math.abs(r)/e)*e,o)},n.CEILING.MATH=n.CEILING,n.CEILING.PRECISE=n.CEILING,n.COMBIN=function(r,e){return r=t.parseNumber(r),e=t.parseNumber(e),t.anyIsError(r,e)?a.value:n.FACT(r)/(n.FACT(e)*n.FACT(r-e))},n.COMBINA=function(r,e){return r=t.parseNumber(r),e=t.parseNumber(e),t.anyIsError(r,e)?a.value:0===r&&0===e?1:n.COMBIN(r+e-1,r-1)},n.COS=function(r){return r=t.parseNumber(r),r instanceof Error?r:Math.cos(r)},n.COSH=function(r){return r=t.parseNumber(r),r instanceof Error?r:(Math.exp(r)+Math.exp(-r))/2},n.COT=function(r){return r=t.parseNumber(r),r instanceof Error?r:1/Math.tan(r)},n.COTH=function(r){if((r=t.parseNumber(r))instanceof Error)return r;var n=Math.exp(2*r);return(n+1)/(n-1)},n.CSC=function(r){return r=t.parseNumber(r),r instanceof Error?r:1/Math.sin(r)},n.CSCH=function(r){return r=t.parseNumber(r),r instanceof Error?r:2/(Math.exp(r)-Math.exp(-r))},n.DECIMAL=function(r,n){return arguments.length<1?a.value:parseInt(r,n)},n.DEGREES=function(r){return r=t.parseNumber(r),r instanceof Error?r:180*r/Math.PI},n.EVEN=function(r){return r=t.parseNumber(r),r instanceof Error?r:n.CEILING(r,-2,-1)},n.EXP=function(r){return arguments.length<1?a.na:"number"!=typeof r||arguments.length>1?a.error:r=Math.exp(r)};var f=[];n.FACT=function(r){if((r=t.parseNumber(r))instanceof Error)return r;var e=Math.floor(r);return 0===e||1===e?1:f[e]>0?f[e]:(f[e]=n.FACT(e-1)*e,f[e])},n.FACTDOUBLE=function(r){if((r=t.parseNumber(r))instanceof Error)return r;var e=Math.floor(r);return e<=0?1:e*n.FACTDOUBLE(e-2)},n.FLOOR=function(r,e){if(r=t.parseNumber(r),e=t.parseNumber(e),t.anyIsError(r,e))return a.value;if(0===e)return 0;if(!(r>0&&e>0||r<0&&e<0))return a.num;e=Math.abs(e);var u=-Math.floor(Math.log(e)/Math.log(10));return r>=0?n.ROUND(Math.floor(r/e)*e,u):-n.ROUND(Math.ceil(Math.abs(r)/e),u)},n.FLOOR.MATH=function(r,e,u){if(e=void 0===e?1:e,u=void 0===u?0:u,r=t.parseNumber(r),e=t.parseNumber(e),u=t.parseNumber(u),t.anyIsError(r,e,u))return a.value;if(0===e)return 0;e=e?Math.abs(e):1;var o=-Math.floor(Math.log(e)/Math.log(10));return r>=0?n.ROUND(Math.floor(r/e)*e,o):0===u||void 0===u?-n.ROUND(Math.ceil(Math.abs(r)/e)*e,o):-n.ROUND(Math.floor(Math.abs(r)/e)*e,o)},n.FLOOR.PRECISE=n.FLOOR.MATH,n.GCD=function(){var r=t.parseNumberArray(t.flatten(arguments));if(r instanceof Error)return r;for(var n=r.length,e=r[0],a=e<0?-e:e,u=1;ui?a%=i:i%=a;a+=i}return a},n.INT=function(r){return r=t.parseNumber(r),r instanceof Error?r:Math.floor(r)},n.ISO={CEILING:n.CEILING},n.LCM=function(){var r=t.parseNumberArray(t.flatten(arguments));if(r instanceof Error)return r;for(var n,e,a,u,o=1;void 0!==(a=r.pop());)for(;a>1;){if(a%2){for(n=3,e=Math.floor(Math.sqrt(a));n<=e&&a%n;n+=2);u=n<=e?n:a}else u=2;for(a/=u,o*=u,n=r.length;n;r[--n]%u==0&&1==(r[n]/=u)&&r.splice(n,1));}return o},n.LN=function(r){return r=t.parseNumber(r),r instanceof Error?r:Math.log(r)},n.LN10=function(){return Math.log(10)},n.LN2=function(){return Math.log(2)},n.LOG10E=function(){return Math.LOG10E},n.LOG2E=function(){return Math.LOG2E},n.LOG=function(r,n){return r=t.parseNumber(r),n=t.parseNumber(n),t.anyIsError(r,n)?a.value:(n=void 0===n?10:n,Math.log(r)/Math.log(n))},n.LOG10=function(r){return r=t.parseNumber(r),r instanceof Error?r:Math.log(r)/Math.log(10)},n.MOD=function(r,n){if(r=t.parseNumber(r),n=t.parseNumber(n),t.anyIsError(r,n))return a.value;if(0===n)return a.div0;var e=Math.abs(r%n);return n>0?e:-e},n.MROUND=function(r,n){return r=t.parseNumber(r),n=t.parseNumber(n),t.anyIsError(r,n)?a.value:r*n<0?a.num:Math.round(r/n)*n},n.MULTINOMIAL=function(){var r=t.parseNumberArray(t.flatten(arguments));if(r instanceof Error)return r;for(var e=0,a=1,u=0;u0?n:-n},n.PI=function(){return Math.PI},n.E=function(){return Math.E},n.POWER=function(r,n){if(r=t.parseNumber(r),n=t.parseNumber(n),t.anyIsError(r,n))return a.value;var e=Math.pow(r,n);return isNaN(e)?a.num:e},n.PRODUCT=function(){var r=t.parseNumberArray(t.flatten(arguments));if(r instanceof Error)return r;for(var n=1,e=0;e0?1:-1)*Math.floor(Math.abs(r)*Math.pow(10,n))/Math.pow(10,n)},n.ROUNDUP=function(r,n){return r=t.parseNumber(r),n=t.parseNumber(n),t.anyIsError(r,n)?a.value:(r>0?1:-1)*Math.ceil(Math.abs(r)*Math.pow(10,n))/Math.pow(10,n)},n.SEC=function(r){return r=t.parseNumber(r),r instanceof Error?r:1/Math.cos(r)},n.SECH=function(r){return r=t.parseNumber(r),r instanceof Error?r:2/(Math.exp(r)+Math.exp(-r))},n.SERIESSUM=function(r,n,e,u){if(r=t.parseNumber(r),n=t.parseNumber(n),e=t.parseNumber(e),u=t.parseNumberArray(u),t.anyIsError(r,n,e,u))return a.value;for(var o=u[0]*Math.pow(r,n),i=1;i=n)},n.LT=function(r,n){return 2!==arguments.length?a.na:(r=t.parseNumber(r),n=t.parseNumber(n),t.anyIsError(r,n)?a.error:r0?1:-1)*Math.floor(Math.abs(r)*Math.pow(10,n))/Math.pow(10,n)}},function(r,n,e){var t=e(2),a=e(4),u=e(8),o=e(1),i=e(5),f=e(0),s=e(9);n.AVEDEV=function(){var r=o.parseNumberArray(o.flatten(arguments));return r instanceof Error?r:u.sum(u(r).subtract(u.mean(r)).abs()[0])/r.length},n.AVERAGE=function(){for(var r,n=o.numbers(o.flatten(arguments)),e=n.length,t=0,a=0,u=0;u=e)return t;t++}},n.CHISQ={},n.CHISQ.DIST=function(r,n,e){return r=o.parseNumber(r),n=o.parseNumber(n),o.anyIsError(r,n)?f.value:e?u.chisquare.cdf(r,n):u.chisquare.pdf(r,n)},n.CHISQ.DIST.RT=function(r,n){return!r|!n?f.na:r<1||n>Math.pow(10,10)?f.num:"number"!=typeof r||"number"!=typeof n?f.value:1-u.chisquare.cdf(r,n)},n.CHISQ.INV=function(r,n){return r=o.parseNumber(r),n=o.parseNumber(n),o.anyIsError(r,n)?f.value:u.chisquare.inv(r,n)},n.CHISQ.INV.RT=function(r,n){return!r|!n?f.na:r<0||r>1||n<1||n>Math.pow(10,10)?f.num:"number"!=typeof r||"number"!=typeof n?f.value:u.chisquare.inv(1-r,n)},n.CHISQ.TEST=function(r,n){if(2!==arguments.length)return f.na;if(!(r instanceof Array&&n instanceof Array))return f.value;if(r.length!==n.length)return f.value;if(r[0]&&n[0]&&r[0].length!==n[0].length)return f.value;var e,t,a,u=r.length;for(t=0;t=2;)e=e*r/t,t-=2;for(var a=e,u=n;a>1e-10*e;)u+=2,a=a*r/u,e+=a;return 1-e}(s,i))/1e6},n.COLUMN=function(r,n){if(2!==arguments.length)return f.na;if(n<0)return f.num;if(!(r instanceof Array)||"number"!=typeof n)return f.value;if(0!==r.length)return u.col(r,n)},n.COLUMNS=function(r){return 1!==arguments.length?f.na:r instanceof Array?0===r.length?0:u.cols(r):f.value},n.CONFIDENCE={},n.CONFIDENCE.NORM=function(r,n,e){return r=o.parseNumber(r),n=o.parseNumber(n),e=o.parseNumber(e),o.anyIsError(r,n,e)?f.value:u.normalci(1,r,n,e)[1]-1},n.CONFIDENCE.T=function(r,n,e){return r=o.parseNumber(r),n=o.parseNumber(n),e=o.parseNumber(e),o.anyIsError(r,n,e)?f.value:u.tci(1,r,n,e)[1]-1},n.CORREL=function(r,n){return r=o.parseNumberArray(o.flatten(r)),n=o.parseNumberArray(o.flatten(n)),o.anyIsError(r,n)?f.value:u.corrcoeff(r,n)},n.COUNT=function(){return o.numbers(o.flatten(arguments)).length},n.COUNTA=function(){var r=o.flatten(arguments);return r.length-n.COUNTBLANK(r)},n.COUNTIN=function(r,n){var e=0;r=o.flatten(r);for(var t=0;t1?f.num:u.centralF.inv(r,n,e)},n.F.INV.RT=function(r,n,e){return 3!==arguments.length?f.na:r<0||r>1||n<1||n>Math.pow(10,10)||e<1||e>Math.pow(10,10)?f.num:"number"!=typeof r||"number"!=typeof n||"number"!=typeof e?f.value:u.centralF.inv(1-r,n,e)},n.F.TEST=function(r,n){if(!r||!n)return f.na;if(!(r instanceof Array&&n instanceof Array))return f.na;if(r.length<2||n.length<2)return f.div0;var e=function(r,n){for(var e=0,t=0;tn[u-1]&&r[i]<=n[u]&&(a[u]+=1):u===t&&r[i]>n[t-1]&&(a[t]+=1)}return a},n.GAMMA=function(r){return r=o.parseNumber(r),r instanceof Error?r:0===r?f.num:parseInt(r,10)===r&&r<0?f.num:u.gammafn(r)},n.GAMMA.DIST=function(r,n,e,t){return 4!==arguments.length?f.na:r<0||n<=0||e<=0?f.value:"number"!=typeof r||"number"!=typeof n||"number"!=typeof e?f.value:t?u.gamma.cdf(r,n,e,!0):u.gamma.pdf(r,n,e,!1)},n.GAMMA.INV=function(r,n,e){return 3!==arguments.length?f.na:r<0||r>1||n<=0||e<=0?f.num:"number"!=typeof r||"number"!=typeof n||"number"!=typeof e?f.value:u.gamma.inv(r,n,e)},n.GAMMALN=function(r){return r=o.parseNumber(r),r instanceof Error?r:u.gammaln(r)},n.GAMMALN.PRECISE=function(r){return 1!==arguments.length?f.na:r<=0?f.num:"number"!=typeof r?f.value:u.gammaln(r)},n.GAUSS=function(r){return r=o.parseNumber(r),r instanceof Error?r:u.normal.cdf(r,0,1)-.5},n.GEOMEAN=function(){var r=o.parseNumberArray(o.flatten(arguments));return r instanceof Error?r:u.geomean(r)},n.GROWTH=function(r,n,e,t){if((r=o.parseNumberArray(r))instanceof Error)return r;var a;if(void 0===n)for(n=[],a=1;a<=r.length;a++)n.push(a);if(void 0===e)for(e=[],a=1;a<=r.length;a++)e.push(a);if(n=o.parseNumberArray(n),e=o.parseNumberArray(e),o.anyIsError(n,e))return f.value;void 0===t&&(t=!0);var u=r.length,i=0,s=0,l=0,c=0;for(a=0;au&&(u=t[n],a=[]),t[n]===u&&(a[a.length]=n);return a},n.MODE.SNGL=function(){var r=o.parseNumberArray(o.flatten(arguments));return r instanceof Error?r:n.MODE.MULT(r).sort(function(r,n){return r-n})[0]},n.NEGBINOM={},n.NEGBINOM.DIST=function(r,n,e,t){return r=o.parseNumber(r),n=o.parseNumber(n),e=o.parseNumber(e),o.anyIsError(r,n,e)?f.value:t?u.negbin.cdf(r,n,e):u.negbin.pdf(r,n,e)},n.NORM={},n.NORM.DIST=function(r,n,e,t){return r=o.parseNumber(r),n=o.parseNumber(n),e=o.parseNumber(e),o.anyIsError(r,n,e)?f.value:e<=0?f.num:t?u.normal.cdf(r,n,e):u.normal.pdf(r,n,e)},n.NORM.INV=function(r,n,e){return r=o.parseNumber(r),n=o.parseNumber(n),e=o.parseNumber(e),o.anyIsError(r,n,e)?f.value:u.normal.inv(r,n,e)},n.NORM.S={},n.NORM.S.DIST=function(r,n){return r=o.parseNumber(r),r instanceof Error?f.value:n?u.normal.cdf(r,0,1):u.normal.pdf(r,0,1)},n.NORM.S.INV=function(r){return r=o.parseNumber(r),r instanceof Error?f.value:u.normal.inv(r,0,1)},n.PEARSON=function(r,n){if(n=o.parseNumberArray(o.flatten(n)),r=o.parseNumberArray(o.flatten(r)),o.anyIsError(n,r))return f.value;for(var e=u.mean(r),t=u.mean(n),a=r.length,i=0,s=0,l=0,c=0;c1-1/(e+1))return f.num;var t=n*(e+1)-1,a=Math.floor(t);return o.cleanFloat(t===a?r[t]:r[a]+(t-a)*(r[a+1]-r[a]))},n.PERCENTILE.INC=function(r,n){if(r=o.parseNumberArray(o.flatten(r)),n=o.parseNumber(n),o.anyIsError(r,n))return f.value;r=r.sort(function(r,n){return r-n});var e=r.length,t=n*(e-1),a=Math.floor(t);return o.cleanFloat(t===a?r[t]:r[a]+(t-a)*(r[a+1]-r[a]))},n.PERCENTRANK={},n.PERCENTRANK.EXC=function(r,n,e){if(e=void 0===e?3:e,r=o.parseNumberArray(o.flatten(r)),n=o.parseNumber(n),e=o.parseNumber(e),o.anyIsError(r,n,e))return f.value;r=r.sort(function(r,n){return r-n});for(var t=s.UNIQUE.apply(null,r),a=r.length,u=t.length,i=Math.pow(10,e),l=0,c=!1,m=0;!c&&m=t[m]&&(n=t[m]&&(n=0?n[r.indexOf(e)]:0;for(var a=r.sort(function(r,n){return r-n}),u=a.length,i=0,s=0;s=e&&a[s]<=t&&(i+=n[r.indexOf(a[s])]);return i},n.QUARTILE={},n.QUARTILE.EXC=function(r,e){if(r=o.parseNumberArray(o.flatten(r)),e=o.parseNumber(e),o.anyIsError(r,e))return f.value;switch(e){case 1:return n.PERCENTILE.EXC(r,.25);case 2:return n.PERCENTILE.EXC(r,.5);case 3:return n.PERCENTILE.EXC(r,.75);default:return f.num}},n.QUARTILE.INC=function(r,e){if(r=o.parseNumberArray(o.flatten(r)),e=o.parseNumber(e),o.anyIsError(r,e))return f.value;switch(e){case 1:return n.PERCENTILE.INC(r,.25);case 2:return n.PERCENTILE.INC(r,.5);case 3:return n.PERCENTILE.INC(r,.75);default:return f.num}},n.RANK={},n.RANK.AVG=function(r,n,e){if(r=o.parseNumber(r),n=o.parseNumberArray(o.flatten(n)),o.anyIsError(r,n))return f.value;n=o.flatten(n),e=e||!1;var t=e?function(r,n){return r-n}:function(r,n){return n-r};n=n.sort(t);for(var a=n.length,u=0,i=0;i1?(2*n.indexOf(r)+u+1)/2:n.indexOf(r)+1},n.RANK.EQ=function(r,n,e){if(r=o.parseNumber(r),n=o.parseNumberArray(o.flatten(n)),o.anyIsError(r,n))return f.value;e=e||!1;var t=e?function(r,n){return r-n}:function(r,n){return n-r};return n=n.sort(t),n.indexOf(r)+1},n.ROW=function(r,n){if(2!==arguments.length)return f.na;if(n<0)return f.num;if(!(r instanceof Array)||"number"!=typeof n)return f.value;if(0!==r.length)return u.row(r,n)},n.ROWS=function(r){return 1!==arguments.length?f.na:r instanceof Array?0===r.length?0:u.rows(r):f.value},n.RSQ=function(r,e){return r=o.parseNumberArray(o.flatten(r)),e=o.parseNumberArray(o.flatten(e)),o.anyIsError(r,e)?f.value:Math.pow(n.PEARSON(r,e),2)},n.SKEW=function(){var r=o.parseNumberArray(o.flatten(arguments));if(r instanceof Error)return r;for(var n=u.mean(r),e=r.length,t=0,a=0;a1||n<1?f.num:o.anyIsError(r,n)?f.value:Math.abs(u.studentt.inv(r/2,n))},n.T.TEST=function(r,e){if(r=o.parseNumberArray(o.flatten(r)),e=o.parseNumberArray(o.flatten(e)),o.anyIsError(r,e))return f.value;var t,a=u.mean(r),i=u.mean(e),s=0,l=0;for(t=0;t-1;)r[n]="TRUE";for(var e=0;(e=r.indexOf(!1))>-1;)r[e]="FALSE";return r.join("")},n.DBCS=function(){throw new Error("DBCS is not implemented")},n.DOLLAR=function(){throw new Error("DOLLAR is not implemented")},n.EXACT=function(r,n){return 2!==arguments.length?a.na:r===n},n.FIND=function(r,n,e){return arguments.length<2?a.na:(e=void 0===e?0:e,n?n.indexOf(r,e-1)+1:null)},n.FIXED=function(){throw new Error("FIXED is not implemented")},n.HTML2TEXT=function(r){var n="";return r&&(r instanceof Array?r.forEach(function(r){""!==n&&(n+="\n"),n+=r.replace(/<(?:.|\n)*?>/gm,"")}):n=r.replace(/<(?:.|\n)*?>/gm,"")),n},n.LEFT=function(r,n){return n=void 0===n?1:n,n=t.parseNumber(n),n instanceof Error||"string"!=typeof r?a.value:r?r.substring(0,n):null},n.LEN=function(r){return 0===arguments.length?a.error:"string"==typeof r?r?r.length:0:r.length?r.length:a.value},n.LOWER=function(r){return"string"!=typeof r?a.value:r?r.toLowerCase():r},n.MID=function(r,n,e){if(n=t.parseNumber(n),e=t.parseNumber(e),t.anyIsError(n,e)||"string"!=typeof r)return e;var a=n-1,u=a+e;return r.substring(a,u)},n.NUMBERVALUE=function(r,n,e){return n=void 0===n?".":n,e=void 0===e?",":e,Number(r.replace(n,".").replace(e,""))},n.PRONETIC=function(){throw new Error("PRONETIC is not implemented")},n.PROPER=function(r){return void 0===r||0===r.length?a.value:(!0===r&&(r="TRUE"),!1===r&&(r="FALSE"),isNaN(r)&&"number"==typeof r?a.value:("number"==typeof r&&(r=""+r),r.replace(/\w\S*/g,function(r){return r.charAt(0).toUpperCase()+r.substr(1).toLowerCase()})))},n.REGEXEXTRACT=function(r,n){if(arguments.length<2)return a.na;var e=r.match(new RegExp(n));return e?e[e.length>1?e.length-1:0]:null},n.REGEXMATCH=function(r,n,e){if(arguments.length<2)return a.na;var t=r.match(new RegExp(n));return e?t:!!t},n.REGEXREPLACE=function(r,n,e){return arguments.length<3?a.na:r.replace(new RegExp(n),e)},n.REPLACE=function(r,n,e,u){return n=t.parseNumber(n),e=t.parseNumber(e),t.anyIsError(n,e)||"string"!=typeof r||"string"!=typeof u?a.value:r.substr(0,n-1)+u+r.substr(n-1+e)},n.REPT=function(r,n){return n=t.parseNumber(n),n instanceof Error?n:new Array(n+1).join(r)},n.RIGHT=function(r,n){return n=void 0===n?1:n,n=t.parseNumber(n),n instanceof Error?n:r?r.substring(r.length-n):a.na},n.SEARCH=function(r,n,e){var t;return"string"!=typeof r||"string"!=typeof n?a.value:(e=void 0===e?0:e,t=n.toLowerCase().indexOf(r.toLowerCase(),e-1)+1,0===t?a.value:t)},n.SPLIT=function(r,n){return r.split(n)},n.SUBSTITUTE=function(r,n,e,t){if(arguments.length<2)return a.na;if(!(r&&n&&e))return r;if(void 0===t)return r.replace(new RegExp(n,"g"),e);for(var u=0,o=0;r.indexOf(n,u)>0;)if(u=r.indexOf(n,u+1),++o===t)return r.substring(0,u)+e+r.substring(u+n.length)},n.T=function(r){return"string"==typeof r?r:""},n.TEXT=function(){throw new Error("TEXT is not implemented")},n.TRIM=function(r){return"string"!=typeof r?a.value:r.replace(/ +/g," ").trim()},n.UNICHAR=n.CHAR,n.UNICODE=n.CODE,n.UPPER=function(r){return"string"!=typeof r?a.value:r.toUpperCase()},n.VALUE=function(){throw new Error("VALUE is not implemented")}},function(r,n){function e(r,n){if(-1===m.indexOf(n))throw new Error("Unsupported token type: "+n);return{value:r,type:n}}function t(r){return"string"!=typeof r?r:(/^\d+(\.\d+)?$/.test(r)&&(r=-1===r.indexOf(".")?parseInt(r,10):parseFloat(r)),r)}function a(r){for(var n=r.length,e=[],t=0,a="",u="";t":case"<":case"=":u+=o,a.length>0&&(e.push(a),a="");break;default:u.length>0&&(e.push(u),u=""),a+=o}t++}return a.length>0&&e.push(a),u.length>0&&e.push(u),e}function u(r){for(var n="",a=[],u=0;u=0?a.push(e(o,l)):n+=o}return n.length>0&&a.push(e(t(n),c)),a.length>0&&a[0].type!==l&&a.unshift(e(f,l)),a}function o(r){for(var n,e=[],t=0;t":e=r[0]>r[1];break;case">=":e=r[0]>=r[1];break;case"<":e=r[0]":e=r[0]!=r[1]}return e}var f="=",s=[">",">=","<","<=","=","<>"],l="operator",c="literal",m=[l,c];n.TOKEN_TYPE_OPERATOR=l,n.TOKEN_TYPE_LITERAL=c,n.parse=function(r){return u(a(r))},n.createToken=e,n.compute=o},function(r,n,e){var t=e(0);n.CELL=function(){throw new Error("CELL is not implemented")},n.ERROR={},n.ERROR.TYPE=function(r){switch(r){case t.nil:return 1;case t.div0:return 2;case t.value:return 3;case t.ref:return 4;case t.name:return 5;case t.num:return 6;case t.na:return 7;case t.data:return 8}return t.na},n.INFO=function(){throw new Error("INFO is not implemented")},n.ISBLANK=function(r){return null===r},n.ISBINARY=function(r){return/^[01]{1,10}$/.test(r)},n.ISERR=function(r){return[t.value,t.ref,t.div0,t.num,t.name,t.nil].indexOf(r)>=0||"number"==typeof r&&(isNaN(r)||!isFinite(r))},n.ISERROR=function(r){return n.ISERR(r)||r===t.na},n.ISEVEN=function(r){return!(1&Math.floor(Math.abs(r)))},n.ISFORMULA=function(){throw new Error("ISFORMULA is not implemented")},n.ISLOGICAL=function(r){return!0===r||!1===r},n.ISNA=function(r){return r===t.na},n.ISNONTEXT=function(r){return"string"!=typeof r},n.ISNUMBER=function(r){return"number"==typeof r&&!isNaN(r)&&isFinite(r)},n.ISODD=function(r){return!!(1&Math.floor(Math.abs(r)))},n.ISREF=function(){throw new Error("ISREF is not implemented")},n.ISTEXT=function(r){return"string"==typeof r},n.N=function(r){return this.ISNUMBER(r)?r:r instanceof Date?r.getTime():!0===r?1:!1===r?0:this.ISERROR(r)?r:0},n.NA=function(){return t.na},n.SHEET=function(){throw new Error("SHEET is not implemented")},n.SHEETS=function(){throw new Error("SHEETS is not implemented")},n.TYPE=function(r){return this.ISNUMBER(r)?1:this.ISTEXT(r)?2:this.ISLOGICAL(r)?4:this.ISERROR(r)?16:Array.isArray(r)?64:void 0}},function(r,n,e){function t(r){return 1===new Date(r,1,29).getMonth()}function a(r,n){return Math.ceil((n-r)/1e3/60/60/24)}function u(r){var n=r>-22038912e5?2:1;return Math.ceil((r-f)/864e5)+n}var o=e(0),i=e(1),f=new Date(Date.UTC(1900,0,1)),s=[void 0,0,1,void 0,void 0,void 0,void 0,void 0,void 0,void 0,void 0,void 0,1,2,3,4,5,6,0],l=[[],[1,2,3,4,5,6,7],[7,1,2,3,4,5,6],[6,0,1,2,3,4,5],[],[],[],[],[],[],[],[7,1,2,3,4,5,6],[6,7,1,2,3,4,5],[5,6,7,1,2,3,4],[4,5,6,7,1,2,3],[3,4,5,6,7,1,2],[2,3,4,5,6,7,1],[1,2,3,4,5,6,7]],c=[[],[6,0],[0,1],[1,2],[2,3],[3,4],[4,5],[5,6],void 0,void 0,void 0,[0,0],[1,1],[2,2],[3,3],[4,4],[5,5],[6,6]];n.DATE=function(r,n,e){return r=i.parseNumber(r),n=i.parseNumber(n),e=i.parseNumber(e),i.anyIsError(r,n,e)?o.value:r<0||n<0||e<0?o.num:new Date(r,n-1,e)},n.DATEVALUE=function(r){var n,e=2;return"string"!=typeof r?o.value:(n=Date.parse(r),isNaN(n)?o.value:(n<=-22038912e5&&(e=1),Math.ceil((n-f)/864e5)+e))},n.DAY=function(r){var n=i.parseDate(r);return n instanceof Error?n:n.getDate()},n.DAYS=function(r,n){return r=i.parseDate(r),n=i.parseDate(n),r instanceof Error?r:n instanceof Error?n:u(r)-u(n)},n.DAYS360=function(r,n,e){if(e=i.parseBool(e),r=i.parseDate(r),n=i.parseDate(n),r instanceof Error)return r;if(n instanceof Error)return n;if(e instanceof Error)return e;var t,a,u=r.getMonth(),o=n.getMonth();if(e)t=31===r.getDate()?30:r.getDate(),a=31===n.getDate()?30:n.getDate();else{var f=new Date(r.getFullYear(),u+1,0).getDate(),s=new Date(n.getFullYear(),o+1,0).getDate();t=r.getDate()===f?30:r.getDate(),n.getDate()===s?t<30?(o++,a=1):a=30:a=n.getDate()}return 360*(n.getFullYear()-r.getFullYear())+30*(o-u)+(a-t)},n.EDATE=function(r,n){return(r=i.parseDate(r))instanceof Error?r:isNaN(n)?o.value:(n=parseInt(n,10),r.setMonth(r.getMonth()+n),u(r))},n.EOMONTH=function(r,n){return(r=i.parseDate(r))instanceof Error?r:isNaN(n)?o.value:(n=parseInt(n,10),u(new Date(r.getFullYear(),r.getMonth()+n+1,0)))},n.HOUR=function(r){return r=i.parseDate(r),r instanceof Error?r:r.getHours()},n.INTERVAL=function(r){if("number"!=typeof r&&"string"!=typeof r)return o.value;r=parseInt(r,10);var n=Math.floor(r/94608e4);r%=94608e4;var e=Math.floor(r/2592e3);r%=2592e3;var t=Math.floor(r/86400);r%=86400;var a=Math.floor(r/3600);r%=3600;var u=Math.floor(r/60);r%=60;var i=r;return n=n>0?n+"Y":"",e=e>0?e+"M":"",t=t>0?t+"D":"",a=a>0?a+"H":"",u=u>0?u+"M":"",i=i>0?i+"S":"","P"+n+e+t+"T"+a+u+i},n.ISOWEEKNUM=function(r){if((r=i.parseDate(r))instanceof Error)return r;r.setHours(0,0,0),r.setDate(r.getDate()+4-(r.getDay()||7));var n=new Date(r.getFullYear(),0,1);return Math.ceil(((r-n)/864e5+1)/7)},n.MINUTE=function(r){return r=i.parseDate(r),r instanceof Error?r:r.getMinutes()},n.MONTH=function(r){return r=i.parseDate(r),r instanceof Error?r:r.getMonth()+1},n.NETWORKDAYS=function(r,n,e){return this.NETWORKDAYS.INTL(r,n,1,e)},n.NETWORKDAYS.INTL=function(r,n,e,t){if((r=i.parseDate(r))instanceof Error)return r;if((n=i.parseDate(n))instanceof Error)return n;if(!((e=void 0===e?c[1]:c[e])instanceof Array))return o.value;void 0===t?t=[]:t instanceof Array||(t=[t]);for(var a=0;a0?l.getUTCDay():l.getDay(),p=!1;m!==e[0]&&m!==e[1]||(p=!0);for(var h=0;hl||o===l&&u>=s))return(f===c&&t(f)||function(r,n){var e=r.getFullYear(),a=new Date(e,2,1);if(t(e)&&r=a)return!0;var u=n.getFullYear(),o=new Date(u,2,1);return t(u)&&n>=o&&re?n:e;return r.pow(10,17-~~(r.log(t>0?t:-t)*r.LOG10E))}function t(r){return"[object Function]"===m.call(r)}function a(r){return"number"==typeof r&&r-r==0}function u(r){return l.apply([],r)}function o(){return new o._init(arguments)}function i(){return 0}function f(){return 1}function s(r,n){return r===n?1:0}var l=Array.prototype.concat,c=Array.prototype.slice,m=Object.prototype.toString,p=Array.isArray||function(r){return"[object Array]"===m.call(r)};o.fn=o.prototype,o._init=function(r){if(p(r[0]))if(p(r[0][0])){t(r[1])&&(r[0]=o.map(r[0],r[1]));for(var n=0;n=0;n--,t++)e[t]=[r[t][n]];return e},o.transpose=function(r){var n,e,t,a,u,o=[];for(p(r[0])||(r=[r]),e=r.length,t=r[0].length,u=0;u0&&(o[t][0]=r[t][0]),i=1;ie&&t>0)return[];if(t>0)for(a=r;ae;a+=t)u.push(a);return u},o.slice=function(){function r(r,e,t,a){var u,i=[],f=r.length;if(e===n&&t===n&&a===n)return o.copy(r);if(e=e||0,t=t||r.length,e=e>=0?e:f+e,t=t>=0?t:f+t,a=a||1,e===t||0===a)return[];if(et&&a>0)return[];if(a>0)for(u=e;ut;u+=a)i.push(r[u]);return i}function e(n,e){var t,u;if(e=e||{},a(e.row)){if(a(e.col))return n[e.row][e.col];var i=o.rowa(n,e.row);return t=e.col||{},r(i,t.start,t.end,t.step)}if(a(e.col)){var f=o.cola(n,e.col);return u=e.row||{},r(f,u.start,u.end,u.step)}return u=e.row||{},t=e.col||{},r(n,u.start,u.end,u.step).map(function(n){return r(n,t.start,t.end,t.step)})}return e}(),o.sliceAssign=function(e,t,u){var i,f;if(a(t.row)){if(a(t.col))return e[t.row][t.col]=u;t.col=t.col||{},t.col.start=t.col.start||0,t.col.end=t.col.end||e[0].length,t.col.step=t.col.step||1,i=o.arange(t.col.start,r.min(e.length,t.col.end),t.col.step);var s=t.row;return i.forEach(function(r,n){e[s][r]=u[n]}),e}if(a(t.col)){t.row=t.row||{},t.row.start=t.row.start||0,t.row.end=t.row.end||e.length,t.row.step=t.row.step||1,f=o.arange(t.row.start,r.min(e[0].length,t.row.end),t.row.step);var l=t.col;return f.forEach(function(r,n){e[r][l]=u[n]}),e}return u[0].length===n&&(u=[u]),t.row.start=t.row.start||0,t.row.end=t.row.end||e.length,t.row.step=t.row.step||1,t.col.start=t.col.start||0,t.col.end=t.col.end||e[0].length,t.col.step=t.col.step||1,f=o.arange(t.row.start,r.min(e.length,t.row.end),t.row.step),i=o.arange(t.col.start,r.min(e[0].length,t.col.end),t.col.step),f.forEach(function(r,n){i.forEach(function(t,a){e[r][t]=u[n][a]})}),e},o.diagonal=function(r){var n=o.zeros(r.length,r.length);return r.forEach(function(r,e){n[e][e]=r}),n},o.copy=function(r){return r.map(function(r){return a(r)?r:r.map(function(r){return r})})};var h=o.prototype;return h.length=0,h.push=Array.prototype.push,h.sort=Array.prototype.sort,h.splice=Array.prototype.splice,h.slice=Array.prototype.slice,h.toArray=function(){return this.length>1?c.call(this):c.call(this)[0]},h.map=function(r,n){return o(o.map(this,r,n))},h.cumreduce=function(r,n){return o(o.cumreduce(this,r,n))},h.alter=function(r){return o.alter(this,r),this},function(r){for(var n=0;n=0;)n+=r[e];return n},r.sumsqrd=function(r){for(var n=0,e=r.length;--e>=0;)n+=r[e]*r[e];return n},r.sumsqerr=function(n){for(var e,t=r.mean(n),a=0,u=n.length;--u>=0;)e=n[u]-t,a+=e*e;return a},r.sumrow=function(r){for(var n=0,e=r.length;--e>=0;)n+=r[e];return n},r.product=function(r){for(var n=1,e=r.length;--e>=0;)n*=r[e];return n},r.min=function(r){for(var n=r[0],e=0;++en&&(n=r[e]);return n},r.unique=function(r){for(var n={},e=[],t=0;to?(f=[a[n]],o=u,i=0):u===o&&(f.push(a[n]),i++),u=1);return 0===i?f[0]:f},r.range=function(n){return r.max(n)-r.min(n)},r.variance=function(n,e){return r.sumsqerr(n)/(n.length-(e?1:0))},r.pooledvariance=function(n){return n.reduce(function(n,e){return n+r.sumsqerr(e)},0)/(n.reduce(function(r,n){return r+n.length},0)-n.length)},r.deviation=function(n){for(var e=r.mean(n),t=n.length,a=new Array(t),u=0;u=0;u--)a.push(n.abs(e[u]-t));return r.mean(a)},r.meddev=function(e){for(var t=r.median(e),a=[],u=e.length-1;u>=0;u--)a.push(n.abs(e[u]-t));return r.median(a)},r.coeffvar=function(n){return r.stdev(n)/r.mean(n)},r.quartiles=function(r){var t=r.length,a=r.slice().sort(e);return[a[n.round(t/4)-1],a[n.round(t/2)-1],a[n.round(3*t/4)-1]]},r.quantiles=function(r,a,u,o){var i,f,s,l,c,m,p=r.slice().sort(e),h=[a.length],v=r.length;for(void 0===u&&(u=3/8),void 0===o&&(o=3/8),i=0;i1){for(f=!0===e?this:this.transpose();i1){for("sumrow"!==n&&(f=!0===e?this:this.transpose());i1){for(i=i.transpose();o=0;i--)o*=t,o+=s[i];if(u=o/e+.5*n.log(a)+(e-.5)*n.log(e)-e,r<=7)for(i=1;i<=f;i++)u-=n.log(e-1),e-=1;return u},r.gammafn=function(r){var e,t,a,u,o=[-1.716185138865495,24.76565080557592,-379.80425647094563,629.3311553128184,866.9662027904133,-31451.272968848367,-36144.413418691176,66456.14382024054],i=[-30.8402300119739,315.35062697960416,-1015.1563674902192,-3107.771671572311,22538.11842098015,4755.846277527881,-134659.9598649693,-115132.2596755535],f=!1,s=0,l=0,c=0,m=r;if(m<=0){if(!(u=m%1+3.6e-16))return 1/0;f=(1&m?-1:1)*n.PI/n.sin(n.PI*u),m=1-m}for(a=m,t=m<1?m++:(m-=s=(0|m)-1)-1,e=0;e<8;++e)c=(c+o[e])*t,l=l*t+i[e];if(u=c/l+1,am)for(e=0;e=1?e:1/e)+.4*e+17);if(t<0||e<=0)return NaN;if(t170||t>170?n.exp(r.combinationln(e,t)):r.factorial(e)/r.factorial(t)/r.factorial(e-t)},r.combinationln=function(n,e){return r.factorialln(n)-r.factorialln(e)-r.factorialln(n-e)},r.permutation=function(n,e){return r.factorial(n)/r.factorial(n-e)},r.betafn=function(e,t){if(!(e<=0||t<=0))return e+t>170?n.exp(r.betaln(e,t)):r.gammafn(e)*r.gammafn(t)/r.gammafn(e+t)},r.betaln=function(n,e){return r.gammaln(n)+r.gammaln(e)-r.gammaln(n+e)},r.betacf=function(r,e,t){var a,u,o,i,f=1,s=e+t,l=e+1,c=e-1,m=1,p=1-s*r/l;for(n.abs(p)<1e-30&&(p=1e-30),p=1/p,i=p;f<=100&&(a=2*f,u=f*(t-f)*r/((c+a)*(e+a)),p=1+u*p,n.abs(p)<1e-30&&(p=1e-30),m=1+u/m,n.abs(m)<1e-30&&(m=1e-30),p=1/p,i*=p*m,u=-(e+f)*(s+f)*r/((e+a)*(l+a)),p=1+u*p,n.abs(p)<1e-30&&(p=1e-30),m=1+u/m,n.abs(m)<1e-30&&(m=1e-30),p=1/p,o=p*m,i*=o,!(n.abs(o-1)<3e-7));f++);return i},r.gammapinv=function(e,t){var a,u,o,i,f,s,l,c=0,m=t-1,p=r.gammaln(t);if(e>=1)return n.max(100,t+100*n.sqrt(t));if(e<=0)return 0;for(t>1?(s=n.log(m),l=n.exp(m*(s-1)-p),f=e<.5?e:1-e,o=n.sqrt(-2*n.log(f)),a=(2.30753+.27061*o)/(1+o*(.99229+.04481*o))-o,e<.5&&(a=-a),a=n.max(.001,t*n.pow(1-1/(9*t)-a/(3*n.sqrt(t)),3))):(o=1-t*(.253+.12*t),a=e1?l*n.exp(-(a-m)+m*(n.log(a)-s)):n.exp(-a+m*n.log(a)-p),i=u/o,a-=o=i/(1-.5*n.min(1,i*((t-1)/a-1))),a<=0&&(a=.5*(a+o)),n.abs(o)<1e-8*a)break}return a},r.erf=function(r){var e,t,a,u,o=[-1.3026537197817094,.6419697923564902,.019476473204185836,-.00956151478680863,-.000946595344482036,.000366839497852761,42523324806907e-18,-20278578112534e-18,-1624290004647e-18,130365583558e-17,1.5626441722e-8,-8.5238095915e-8,6.529054439e-9,5.059343495e-9,-9.91364156e-10,-2.27365122e-10,9.6467911e-11,2.394038e-12,-6.886027e-12,8.94487e-13,3.13092e-13,-1.12708e-13,3.81e-16,7.106e-15,-1.523e-15,-9.4e-17,1.21e-16,-2.8e-17],i=o.length-1,f=!1,s=0,l=0;for(r<0&&(r=-r,f=!0),e=2/(2+r),t=4*e-2;i>0;i--)a=s,s=t*s-l+o[i],l=a;return u=e*n.exp(-r*r+.5*(o[0]+t*s)-l),f?u-1:1-u},r.erfc=function(n){return 1-r.erf(n)},r.erfcinv=function(e){var t,a,u,o,i=0;if(e>=2)return-100;if(e<=0)return 100;for(o=e<1?e:2-e,u=n.sqrt(-2*n.log(o/2)),t=-.70711*((2.30753+.27061*u)/(1+u*(.99229+.04481*u))-u);i<2;i++)a=r.erfc(t)-o,t+=a/(1.1283791670955126*n.exp(-t*t)-t*a);return e<1?t:-t},r.ibetainv=function(e,t,a){var u,o,i,f,s,l,c,m,p,h,v,g=t-1,N=a-1,E=0;if(e<=0)return 0;if(e>=1)return 1;for(t>=1&&a>=1?(i=e<.5?e:1-e,f=n.sqrt(-2*n.log(i)),c=(2.30753+.27061*f)/(1+f*(.99229+.04481*f))-f,e<.5&&(c=-c),m=(c*c-3)/6,p=2/(1/(2*t-1)+1/(2*a-1)),h=c*n.sqrt(m+p)/p-(1/(2*a-1)-1/(2*t-1))*(m+5/6-2/(3*p)),c=t/(t+a*n.exp(2*h))):(u=n.log(t/(t+a)),o=n.log(a/(t+a)),f=n.exp(t*u)/t,s=n.exp(a*o)/a,h=f+s,c=e=1&&(c=.5*(c+f+1)),n.abs(f)<1e-8*c&&E>0)break}return c},r.ibeta=function(e,t,a){var u=0===e||1===e?0:n.exp(r.gammaln(t+a)-r.gammaln(t)-r.gammaln(a)+t*n.log(e)+a*n.log(1-e));return!(e<0||e>1)&&(e<(t+1)/(t+a+2)?u*r.betacf(e,t,a)/t:1-u*r.betacf(1-e,a,t)/a)},r.randn=function(e,t){var a,u,o,i,f;if(t||(t=e),e)return r.create(e,t,function(){return r.randn()});do{a=r._random_fn(),u=1.7156*(r._random_fn()-.5),o=a-.449871,i=n.abs(u)+.386595,f=o*o+i*(.196*i-.25472*o)}while(f>.27597&&(f>.27846||u*u>-4*n.log(a)*a*a));return u/a},r.randg=function(e,t,a){var u,o,i,f,s,l,c=e;if(a||(a=t),e||(e=1),t)return l=r.zeros(t,a),l.alter(function(){return r.randg(e)}),l;e<1&&(e+=1),u=e-1/3,o=1/n.sqrt(9*u);do{do{s=r.randn(),f=1+o*s}while(f<=0);f*=f*f,i=r._random_fn()}while(i>1-.331*n.pow(s,4)&&n.log(i)>.5*s*s+u*(1-f+n.log(f)));if(e==c)return u*f;do{i=r._random_fn()}while(0===i);return n.pow(i,1/c)*u*f},function(n){for(var e=0;ea;)c=f,u=-(e+l)*(e+t+l)*r/(e+2*l)/(e+2*l+1),o=f+u*o,i=s+u*i,l+=1,u=l*(t-l)*r/(e+2*l-1)/(e+2*l),f=o+u*f,s=i+u*s,o/=s,i/=s,f/=s,s=1;return f/e}function t(r){return r/n.abs(r)}function a(e,t,a){var u=[.9815606342467192,.9041172563704749,.7699026741943047,.5873179542866175,.3678314989981802,.1252334085114689],o=[.04717533638651183,.10693932599531843,.16007832854334622,.20316742672306592,.2334925365383548,.24914704581340277],i=.5*e;if(i>=8)return 1;var f=2*r.normal.cdf(i,0,1,1,0)-1;f=f>=n.exp(-50/a)?n.pow(f,a):0;var s;s=e>3?2:3;for(var l=i,c=(8-i)/s,m=l+c,p=0,h=a-1,v=1;v<=s;v++){for(var g=0,N=.5*(m+l),E=.5*(m-l),I=1;I<=12;I++){var b,d;660)break;var T=2*r.normal.cdf(y,0,1,1,0),R=2*r.normal.cdf(y,e,1,1,0),w=.5*T-.5*R;w>=n.exp(-30/h)&&(w=o[b-1]*n.exp(-.5*A)*n.pow(w,h),g+=w)}g*=2*E*a/n.sqrt(2*n.PI),p+=g,l=m,m+=c}return(f+=p)<=n.exp(-30/t)?0:(f=n.pow(f,t),f>=1?1:f)}function u(r,e,t){var a=.5-.5*r,u=n.sqrt(n.log(1/(a*a))),o=u+((((-453642210148e-16*u-.204231210125)*u-.342242088547)*u-1)*u+.322232421088)/((((.0038560700634*u+.10353775285)*u+.531103462366)*u+.588581570495)*u+.099348462606);t<120&&(o+=(o*o*o+o)/t/4);var i=.8832-.2368*o;return t<120&&(i+=-1.214/t+1.208*o/t),o*(i*n.log(e-1)+1.4142)}!function(n){for(var e=0;e1||e<0?0:1==t&&1==a?1:t<512&&a<512?n.pow(e,t-1)*n.pow(1-e,a-1)/r.betafn(t,a):n.exp((t-1)*n.log(e)+(a-1)*n.log(1-e)-r.betaln(t,a))},cdf:function(n,e,t){return n>1||n<0?1*(n>1):r.ibeta(n,e,t)},inv:function(n,e,t){return r.ibetainv(n,e,t)},mean:function(r,n){return r/(r+n)},median:function(n,e){return r.ibetainv(.5,n,e)},mode:function(r,n){return(r-1)/(r+n-2)},sample:function(n,e){var t=r.randg(n);return t/(t+r.randg(e))},variance:function(r,e){return r*e/(n.pow(r+e,2)*(r+e+1))}}),r.extend(r.centralF,{pdf:function(e,t,a){var u,o;return e<0?0:t<=2?0===e&&t<2?1/0:0===e&&2===t?1:1/r.betafn(t/2,a/2)*n.pow(t/a,t/2)*n.pow(e,t/2-1)*n.pow(1+t/a*e,-(t+a)/2):(u=t*e/(a+e*t),o=a/(a+e*t),t*o/2*r.binomial.pdf((t-2)/2,(t+a-2)/2,u))},cdf:function(n,e,t){return n<0?0:r.ibeta(e*n/(e*n+t),e/2,t/2)},inv:function(n,e,t){return t/(e*(1/r.ibetainv(n,e/2,t/2)-1))},mean:function(r,n){return n>2?n/(n-2):void 0},mode:function(r,n){return r>2?n*(r-2)/(r*(n+2)):void 0},sample:function(n,e){return 2*r.randg(n/2)/n/(2*r.randg(e/2)/e)},variance:function(r,n){if(!(n<=4))return 2*n*n*(r+n-2)/(r*(n-2)*(n-2)*(n-4))}}),r.extend(r.cauchy,{pdf:function(r,e,t){return t<0?0:t/(n.pow(r-e,2)+n.pow(t,2))/n.PI},cdf:function(r,e,t){return n.atan((r-e)/t)/n.PI+.5},inv:function(r,e,t){return e+t*n.tan(n.PI*(r-.5))},median:function(r){return r},mode:function(r){return r},sample:function(e,t){return r.randn()*n.sqrt(1/(2*r.randg(.5)))*t+e}}),r.extend(r.chisquare,{pdf:function(e,t){return e<0?0:0===e&&2===t?.5:n.exp((t/2-1)*n.log(e)-e/2-t/2*n.log(2)-r.gammaln(t/2))},cdf:function(n,e){return n<0?0:r.lowRegGamma(e/2,n/2)},inv:function(n,e){return 2*r.gammapinv(n,.5*e)},mean:function(r){return r},median:function(r){return r*n.pow(1-2/(9*r),3)},mode:function(r){return r-2>0?r-2:0},sample:function(n){return 2*r.randg(n/2)},variance:function(r){return 2*r}}),r.extend(r.exponential,{pdf:function(r,e){return r<0?0:e*n.exp(-e*r)},cdf:function(r,e){return r<0?0:1-n.exp(-e*r)},inv:function(r,e){return-n.log(1-r)/e},mean:function(r){return 1/r},median:function(r){return 1/r*n.log(2)},mode:function(){return 0},sample:function(e){return-1/e*n.log(r._random_fn())},variance:function(r){return n.pow(r,-2)}}),r.extend(r.gamma,{pdf:function(e,t,a){return e<0?0:0===e&&1===t?1/a:n.exp((t-1)*n.log(e)-e/a-r.gammaln(t)-t*n.log(a))},cdf:function(n,e,t){return n<0?0:r.lowRegGamma(e,n/t)},inv:function(n,e,t){return r.gammapinv(n,e)*t},mean:function(r,n){return r*n},mode:function(r,n){if(r>1)return(r-1)*n},sample:function(n,e){return r.randg(n)*e},variance:function(r,n){return r*n*n}}),r.extend(r.invgamma,{pdf:function(e,t,a){return e<=0?0:n.exp(-(t+1)*n.log(e)-a/e-r.gammaln(t)+t*n.log(a))},cdf:function(n,e,t){return n<=0?0:1-r.lowRegGamma(e,t/n)},inv:function(n,e,t){return t/r.gammapinv(1-n,e)},mean:function(r,n){return r>1?n/(r-1):void 0},mode:function(r,n){return n/(r+1)},sample:function(n,e){return e/r.randg(n)},variance:function(r,n){if(!(r<=2))return n*n/((r-1)*(r-1)*(r-2))}}),r.extend(r.kumaraswamy,{pdf:function(r,e,t){return 0===r&&1===e?t:1===r&&1===t?e:n.exp(n.log(e)+n.log(t)+(e-1)*n.log(r)+(t-1)*n.log(1-n.pow(r,e)))},cdf:function(r,e,t){return r<0?0:r>1?1:1-n.pow(1-n.pow(r,e),t)},inv:function(r,e,t){return n.pow(1-n.pow(1-r,1/t),1/e)},mean:function(n,e){return e*r.gammafn(1+1/n)*r.gammafn(e)/r.gammafn(1+1/n+e)},median:function(r,e){return n.pow(1-n.pow(2,-1/e),1/r)},mode:function(r,e){if(r>=1&&e>=1&&1!==r&&1!==e)return n.pow((r-1)/(r*e-1),1/r)},variance:function(){throw new Error("variance not yet implemented")}}),r.extend(r.lognormal,{pdf:function(r,e,t){return r<=0?0:n.exp(-n.log(r)-.5*n.log(2*n.PI)-n.log(t)-n.pow(n.log(r)-e,2)/(2*t*t))},cdf:function(e,t,a){return e<0?0:.5+.5*r.erf((n.log(e)-t)/n.sqrt(2*a*a))},inv:function(e,t,a){return n.exp(-1.4142135623730951*a*r.erfcinv(2*e)+t)},mean:function(r,e){return n.exp(r+e*e/2)},median:function(r){return n.exp(r)},mode:function(r,e){return n.exp(r-e*e)},sample:function(e,t){return n.exp(r.randn()*t+e)},variance:function(r,e){return(n.exp(e*e)-1)*n.exp(2*r+e*e)}}),r.extend(r.noncentralt,{pdf:function(e,t,a){return n.abs(a)<1e-14?r.studentt.pdf(e,t):n.abs(e)<1e-14?n.exp(r.gammaln((t+1)/2)-a*a/2-.5*n.log(n.PI*t)-r.gammaln(t/2)):t/e*(r.noncentralt.cdf(e*n.sqrt(1+2/t),t+2,a)-r.noncentralt.cdf(e,t,a))},cdf:function(e,t,a){if(n.abs(a)<1e-14)return r.studentt.cdf(e,t);var u=!1;e<0&&(u=!0,a=-a);for(var o=r.normal.cdf(-a,0,1),i=1e-14+1,f=i,s=e*e/(e*e+t),l=0,c=n.exp(-a*a/2),m=n.exp(-a*a/2-.5*n.log(2)-r.gammaln(1.5))*a;l<200||f>1e-14||i>1e-14;)f=i,l>0&&(c*=a*a/(2*l),m*=a*a/(2*(l+.5))),i=c*r.beta.cdf(s,l+.5,t/2)+m*r.beta.cdf(s,l+1,t/2),o+=.5*i,l++;return u?1-o:o}}),r.extend(r.normal,{pdf:function(r,e,t){return n.exp(-.5*n.log(2*n.PI)-n.log(t)-n.pow(r-e,2)/(2*t*t))},cdf:function(e,t,a){return.5*(1+r.erf((e-t)/n.sqrt(2*a*a)))},inv:function(n,e,t){return-1.4142135623730951*t*r.erfcinv(2*n)+e},mean:function(r){return r},median:function(r){return r},mode:function(r){return r},sample:function(n,e){return r.randn()*e+n},variance:function(r,n){return n*n}}),r.extend(r.pareto,{pdf:function(r,e,t){return r1e100?1e100:t,1/(n.sqrt(t)*r.betafn(.5,t/2))*n.pow(1+e*e/t,-(t+1)/2)},cdf:function(e,t){var a=t/2;return r.ibeta((e+n.sqrt(e*e+t))/(2*n.sqrt(e*e+t)),a,a)},inv:function(e,t){var a=r.ibetainv(2*n.min(e,1-e),.5*t,.5);return a=n.sqrt(t*(1-a)/a),e>.5?a:-a},mean:function(r){return r>1?0:void 0},median:function(){return 0},mode:function(){return 0},sample:function(e){return r.randn()*n.sqrt(e/(2*r.randg(e/2)))},variance:function(r){return r>2?r/(r-2):r>1?1/0:void 0}}),r.extend(r.weibull,{pdf:function(r,e,t){return r<0||e<0||t<0?0:t/e*n.pow(r/e,t-1)*n.exp(-n.pow(r/e,t))},cdf:function(r,e,t){return r<0?0:1-n.exp(-n.pow(r/e,t))},inv:function(r,e,t){return e*n.pow(-n.log(1-r),1/t)},mean:function(n,e){return n*r.gammafn(1+1/e)},median:function(r,e){return r*n.pow(n.log(2),1/e)},mode:function(r,e){return e<=1?0:r*n.pow((e-1)/e,1/e)},sample:function(e,t){return e*n.pow(-n.log(r._random_fn()),1/t)},variance:function(e,t){return e*e*r.gammafn(1+2/t)-n.pow(r.weibull.mean(e,t),2)}}),r.extend(r.uniform,{pdf:function(r,n,e){return re?0:1/(e-n)},cdf:function(r,n,e){return r=a)return 1;if(u<0||u>1||a<=0)return NaN;t=n.floor(t);var i=u,f=t+1,s=a-t,l=f+s,c=n.exp(r.gammaln(l)-r.gammaln(s)-r.gammaln(f)+f*n.log(i)+s*n.log(1-i));return o=i<(f+1)/(l+2)?c*e(i,f,s,1e-10):1-c*e(1-i,s,f,1e-10),n.round(1e10*(1-o))/1e10}}),r.extend(r.negbin,{pdf:function(e,t,a){return e===e>>>0&&(e<0?0:r.combination(e+t-1,t-1)*n.pow(1-a,e)*n.pow(a,t))},cdf:function(n,e,t){var a=0,u=0;if(n<0)return 0;for(;u<=n;u++)a+=r.negbin.pdf(u,e,t);return a}}),r.extend(r.hypgeom,{pdf:function(e,t,a,u){if(e!==e|0)return!1;if(e<0||eu||e>a)return 0;if(2*a>t)return 2*u>t?r.hypgeom.pdf(t-a-u+e,t,t-a,t-u):r.hypgeom.pdf(u-e,t,t-a,u);if(2*u>t)return r.hypgeom.pdf(a-e,t,a,t-u);if(a1&&i=u||e>=a)return 1;if(2*a>t)return 2*u>t?r.hypgeom.cdf(t-a-u+e,t,t-a,t-u):1-r.hypgeom.cdf(u-e-1,t,t-a,u);if(2*u>t)return 1-r.hypgeom.cdf(a-e-1,t,a,t-u);if(a1&&fu);return a-1},sampleLarge:function(e){var t,a,u,o,i,f,s,l,c,m,p=e;for(o=n.sqrt(p),i=n.log(p),s=.931+2.53*o,f=.02483*s-.059,l=1.1239+1.1328/(s-3.4),c=.9277-3.6224/(s-2);;){if(a=n.random()-.5,u=n.random(),m=.5-n.abs(a),t=n.floor((2*f/m+s)*a+p+.43),m>=.07&&u<=c)return t;if(!(t<0||m<.013&&u>m)&&n.log(u)+n.log(l)-n.log(f/(m*m)+s)<=t*i-p-r.loggam(t+1))return t}},sample:function(r){return r<10?this.sampleSmall(r):this.sampleLarge(r)}}),r.extend(r.triangular,{pdf:function(r,n,e,t){return e<=n||te?NaN:re?0:rt?NaN:r<=e?0:r>=t?1:r<=a?n.pow(r-e,2)/((t-e)*(a-e)):1-n.pow(t-r,2)/((t-e)*(t-a))},inv:function(r,e,t,a){return t<=e||at?NaN:r<=(a-e)/(t-e)?e+(t-e)*n.sqrt(r*((a-e)/(t-e))):e+(t-e)*(1-n.sqrt((1-r)*(1-(a-e)/(t-e))))},mean:function(r,n,e){return(r+n+e)/3},median:function(r,e,t){return t<=(r+e)/2?e-n.sqrt((e-r)*(e-t))/n.sqrt(2):t>(r+e)/2?r+n.sqrt((e-r)*(t-r))/n.sqrt(2):void 0},mode:function(r,n,e){return e},sample:function(e,t,a){var u=r._random_fn();return u<(a-e)/(t-e)?e+n.sqrt(u*(t-e)*(a-e)):t-n.sqrt((1-u)*(t-e)*(t-a))},variance:function(r,n,e){return(r*r+n*n+e*e-r*n-r*e-n*e)/18}}),r.extend(r.arcsine,{pdf:function(r,e,t){return t<=e?NaN:r<=e||r>=t?0:2/n.PI*n.pow(n.pow(t-e,2)-n.pow(2*r-e-t,2),-.5)},cdf:function(r,e,t){return r25e3)return a(e,1,o);var s,l=.5*u,c=l*n.log(u)-u*n.log(2)-r.gammaln(l),m=l-1,p=.25*u;s=u<=100?1:u<=800?.5:u<=5e3?.25:.125,c+=n.log(s);for(var h=0,v=1;v<=50;v++){for(var g=0,N=(2*v-1)*s,E=1;E<=16;E++){var I,b;8=-30){d=8=1&&g<=1e-14)break;h+=g}if(g>1e-14)throw new Error("tukey.cdf failed to converge");return h>1&&(h=1),h},inv:function(e,t,a){var o=t;if(a<2||o<2)return NaN;if(e<0||e>1)return NaN;if(0===e)return 0;if(1===e)return 1/0;var i,f=u(e,o,a),s=r.tukey.cdf(f,t,a)-e;i=s>0?n.max(0,f-1):f+1;for(var l,c=r.tukey.cdf(i,t,a)-e,m=1;m<50;m++){l=i-c*(i-f)/(c-s),s=c,f=i,l<0&&(l=0,c=-e),c=r.tukey.cdf(l,t,a)-e,i=l;if(n.abs(i-f)<1e-4)return l}throw new Error("tukey.inv failed to converge")}})}(r,Math),function(r,n){function e(n){return a(n)||n instanceof r}var t=Array.prototype.push,a=r.utils.isArray;r.extend({add:function(n,t){return e(t)?(e(t[0])||(t=[t]),r.map(n,function(r,n,e){return r+t[n][e]})):r.map(n,function(r){return r+t})},subtract:function(n,t){return e(t)?(e(t[0])||(t=[t]),r.map(n,function(r,n,e){return r-t[n][e]||0})):r.map(n,function(r){return r-t})},divide:function(n,t){return e(t)?(e(t[0])||(t=[t]),r.multiply(n,r.inv(t))):r.map(n,function(r){return r/t})},multiply:function(n,t){var a,u,o,i,f,s,l,c;if(void 0===n.length&&void 0===t.length)return n*t;if(f=n.length,s=n[0].length,l=r.zeros(f,o=e(t)?t[0].length:s),c=0,e(t)){for(;c=0;f--){for(p=0,s=f+1;s<=l-1;s++)p+=h[s]*e[f][s];h[f]=(e[f][a-1]-p)/e[f][f]}return h},gauss_jordan:function(e,t){var a,u,o,i=r.aug(e,t),f=i.length,s=i[0].length,l=0;for(u=0;un.abs(i[c][u])&&(c=o);var m=i[u];for(i[u]=i[c],i[c]=m,o=u+1;o=0;u--){for(l=i[u][u],o=0;ou-1;a--)i[o][a]-=i[u][a]*i[o][u]/l;for(i[u][u]/=l,a=f;ac?(p[l][c]=e[l][c],h[l][c]=v[l][c]=0):lu;)o=s,s=r.add(r.multiply(f,o),i),l++;return s},gauss_seidel:function(e,t,a,u){for(var o,i,f,s,l,c=0,m=e.length,p=[],h=[],v=[];co?(p[c][o]=e[c][o],h[c][o]=v[c][o]=0):cu;)i=l,l=r.add(r.multiply(s,i),f),c+=1;return l},SOR:function(e,t,a,u,o){for(var i,f,s,l,c,m=0,p=e.length,h=[],v=[],g=[];mi?(h[m][i]=e[m][i],v[m][i]=g[m][i]=0):mu;)f=c,c=r.add(r.multiply(l,f),s),m++;return c},householder:function(e){for(var t,a,u,o,i,f=e.length,s=e[0].length,l=0,c=[],m=[];l0?-1:1,t=i*n.sqrt(t),a=n.sqrt((t*t-e[l+1][l]*t)/2),c=r.zeros(f,1),c[l+1][0]=(e[l+1][l]-t)/(2*a),u=l+2;u0?n.PI/4:-n.PI/4:n.atan(2*e[o][i]/(e[o][o]-e[i][i]))/2,l=r.identity(m,m),l[o][o]=n.cos(s),l[o][i]=-n.sin(s),l[i][o]=n.sin(s),l[i][i]=n.cos(s),p=r.multiply(p,l),t=r.multiply(r.multiply(r.inv(l),e),l),e=t,c=0,a=1;a.001&&(c=1)}for(a=0;a=c;)o=u(r,t+a),i=u(r,t),p[m]=(e[o]-2*e[i]+e[2*i-o])/(a*a),a/=2,m++;for(s=p.length,f=1;1!=s;){for(l=0;lt);a++);return a-=1,e[a]+(t-n[a])*m[a]+r.sq(t-n[a])*l[a]+(t-n[a])*r.sq(t-n[a])*p[a]},gauss_quadrature:function(){throw new Error("gauss_quadrature not yet implemented")},PCA:function(n){var e,t,a=n.length,u=n[0].length,o=0,i=[],f=[],s=[],l=[],c=[],m=[],p=[],h=[],v=[],g=[];for(o=0;o1||t>1||r<=0||t<=0)throw new Error("Proportions should be greater than 0 and less than 1");var u=(r*e+t*a)/(e+a);return(r-t)/n.sqrt(u*(1-u)*(1/e+1/a))}var t=[].slice,a=r.utils.isNumber,u=r.utils.isArray;r.extend({zscore:function(){var n=t.call(arguments);return a(n[1])?(n[0]-n[1])/n[2]:(n[0]-r.mean(n[1]))/r.stdev(n[1],n[2])},ztest:function(){var e,a=t.call(arguments);return u(a[1])?(e=r.zscore(a[0],a[1],a[3]),1===a[2]?r.normal.cdf(-n.abs(e),0,1):2*r.normal.cdf(-n.abs(e),0,1)):a.length>2?(e=r.zscore(a[0],a[1],a[2]),1===a[3]?r.normal.cdf(-n.abs(e),0,1):2*r.normal.cdf(-n.abs(e),0,1)):(e=a[0],1===a[1]?r.normal.cdf(-n.abs(e),0,1):2*r.normal.cdf(-n.abs(e),0,1))}}),r.extend(r.fn,{zscore:function(r,n){return(r-this.mean())/this.stdev(n)},ztest:function(e,t,a){var u=n.abs(this.zscore(e,a));return 1===t?r.normal.cdf(-u,0,1):2*r.normal.cdf(-u,0,1)}}),r.extend({tscore:function(){var e=t.call(arguments);return 4===e.length?(e[0]-e[1])/(e[2]/n.sqrt(e[3])):(e[0]-r.mean(e[1]))/(r.stdev(e[1],!0)/n.sqrt(e[1].length))},ttest:function(){var e,u=t.call(arguments);return 5===u.length?(e=n.abs(r.tscore(u[0],u[1],u[2],u[3])),1===u[4]?r.studentt.cdf(-e,u[3]-1):2*r.studentt.cdf(-e,u[3]-1)):a(u[1])?(e=n.abs(u[0]),1==u[2]?r.studentt.cdf(-e,u[1]-1):2*r.studentt.cdf(-e,u[1]-1)):(e=n.abs(r.tscore(u[0],u[1])),1==u[2]?r.studentt.cdf(-e,u[1].length-1):2*r.studentt.cdf(-e,u[1].length-1))}}),r.extend(r.fn,{tscore:function(r){return(r-this.mean())/(this.stdev(!0)/n.sqrt(this.cols()))},ttest:function(e,t){return 1===t?1-r.studentt.cdf(n.abs(this.tscore(e)),this.cols()-1):2*r.studentt.cdf(-n.abs(this.tscore(e)),this.cols()-1)}}),r.extend({anovafscore:function(){var e,a,u,o,i,f,s,l,c=t.call(arguments);if(1===c.length){for(i=new Array(c[0].length),s=0;s.5?1-t:t)}),f=r.studentt.inv(.975,e.df_resid),s=e.coef.map(function(r,n){var e=f*u[n];return[r-e,r+e]});return{se:u,t:o,p:i,sigmaHat:a,interval95:s}}function a(n){var e=n.R2/n.df_model/((1-n.R2)/n.df_resid);return{F_statistic:e,pvalue:1-function(n,e,t){return r.beta.cdf(n/(t/e+n),e/2,t/2)}(e,n.df_model,n.df_resid)}}function u(r,n){var u=e(r,n),o=t(u),i=a(u),f=1-(1-u.R2)*((u.nobs-1)/u.df_resid);return u.t=o,u.f=i,u.adjust_R2=f,u}return{ols:u}}(),r.extend({buildxmatrix:function(){for(var n=new Array(arguments.length),e=0;e1){for(o=[],t=0;t=u.length?o.REPT("0",n-u.length)+u:a.num)},n.BIN2OCT=function(r,n){if(!t(r))return a.num;var e=r.toString();if(10===e.length&&"1"===e.substring(0,1))return(1073741312+parseInt(e.substring(1),2)).toString(8);var u=parseInt(r,2).toString(8);return void 0===n?u:isNaN(n)?a.value:n<0?a.num:(n=Math.floor(n),n>=u.length?o.REPT("0",n-u.length)+u:a.num)},n.BITAND=function(r,n){return r=i.parseNumber(r),n=i.parseNumber(n),i.anyIsError(r,n)?a.value:r<0||n<0?a.num:Math.floor(r)!==r||Math.floor(n)!==n?a.num:r>0xffffffffffff||n>0xffffffffffff?a.num:r&n},n.BITLSHIFT=function(r,n){return r=i.parseNumber(r),n=i.parseNumber(n),i.anyIsError(r,n)?a.value:r<0?a.num:Math.floor(r)!==r?a.num:r>0xffffffffffff?a.num:Math.abs(n)>53?a.num:n>=0?r<>-n},n.BITOR=function(r,n){return r=i.parseNumber(r),n=i.parseNumber(n),i.anyIsError(r,n)?a.value:r<0||n<0?a.num:Math.floor(r)!==r||Math.floor(n)!==n?a.num:r>0xffffffffffff||n>0xffffffffffff?a.num:r|n},n.BITRSHIFT=function(r,n){return r=i.parseNumber(r),n=i.parseNumber(n),i.anyIsError(r,n)?a.value:r<0?a.num:Math.floor(r)!==r?a.num:r>0xffffffffffff?a.num:Math.abs(n)>53?a.num:n>=0?r>>n:r<<-n},n.BITXOR=function(r,n){return r=i.parseNumber(r),n=i.parseNumber(n),i.anyIsError(r,n)?a.value:r<0||n<0?a.num:Math.floor(r)!==r||Math.floor(n)!==n?a.num:r>0xffffffffffff||n>0xffffffffffff?a.num:r^n},n.COMPLEX=function(r,n,e){if(r=i.parseNumber(r),n=i.parseNumber(n),i.anyIsError(r,n))return r;if("i"!==(e=void 0===e?"i":e)&&"j"!==e)return a.value;if(0===r&&0===n)return 0;if(0===r)return 1===n?e:n.toString()+e;if(0===n)return r.toString();var t=n>0?"+":"";return r.toString()+t+(1===n?e:n.toString()+e)},n.CONVERT=function(r,n,e){if((r=i.parseNumber(r))instanceof Error)return r;for(var t,u=[["a.u. of action","?",null,"action",!1,!1,1.05457168181818e-34],["a.u. of charge","e",null,"electric_charge",!1,!1,1.60217653141414e-19],["a.u. of energy","Eh",null,"energy",!1,!1,4.35974417757576e-18],["a.u. of length","a?",null,"length",!1,!1,5.29177210818182e-11],["a.u. of mass","m?",null,"mass",!1,!1,9.10938261616162e-31],["a.u. of time","?/Eh",null,"time",!1,!1,2.41888432650516e-17],["admiralty knot","admkn",null,"speed",!1,!0,.514773333],["ampere","A",null,"electric_current",!0,!1,1],["ampere per meter","A/m",null,"magnetic_field_intensity",!0,!1,1],["ångström","Å",["ang"],"length",!1,!0,1e-10],["are","ar",null,"area",!1,!0,100],["astronomical unit","ua",null,"length",!1,!1,1.49597870691667e-11],["bar","bar",null,"pressure",!1,!1,1e5],["barn","b",null,"area",!1,!1,1e-28],["becquerel","Bq",null,"radioactivity",!0,!1,1],["bit","bit",["b"],"information",!1,!0,1],["btu","BTU",["btu"],"energy",!1,!0,1055.05585262],["byte","byte",null,"information",!1,!0,8],["candela","cd",null,"luminous_intensity",!0,!1,1],["candela per square metre","cd/m?",null,"luminance",!0,!1,1],["coulomb","C",null,"electric_charge",!0,!1,1],["cubic ångström","ang3",["ang^3"],"volume",!1,!0,1e-30],["cubic foot","ft3",["ft^3"],"volume",!1,!0,.028316846592],["cubic inch","in3",["in^3"],"volume",!1,!0,16387064e-12],["cubic light-year","ly3",["ly^3"],"volume",!1,!0,8.46786664623715e-47],["cubic metre","m?",null,"volume",!0,!0,1],["cubic mile","mi3",["mi^3"],"volume",!1,!0,4168181825.44058],["cubic nautical mile","Nmi3",["Nmi^3"],"volume",!1,!0,6352182208],["cubic Pica","Pica3",["Picapt3","Pica^3","Picapt^3"],"volume",!1,!0,7.58660370370369e-8],["cubic yard","yd3",["yd^3"],"volume",!1,!0,.764554857984],["cup","cup",null,"volume",!1,!0,.0002365882365],["dalton","Da",["u"],"mass",!1,!1,1.66053886282828e-27],["day","d",["day"],"time",!1,!0,86400],["degree","°",null,"angle",!1,!1,.0174532925199433],["degrees Rankine","Rank",null,"temperature",!1,!0,.555555555555556],["dyne","dyn",["dy"],"force",!1,!0,1e-5],["electronvolt","eV",["ev"],"energy",!1,!0,1.60217656514141],["ell","ell",null,"length",!1,!0,1.143],["erg","erg",["e"],"energy",!1,!0,1e-7],["farad","F",null,"electric_capacitance",!0,!1,1],["fluid ounce","oz",null,"volume",!1,!0,295735295625e-16],["foot","ft",null,"length",!1,!0,.3048],["foot-pound","flb",null,"energy",!1,!0,1.3558179483314],["gal","Gal",null,"acceleration",!1,!1,.01],["gallon","gal",null,"volume",!1,!0,.003785411784],["gauss","G",["ga"],"magnetic_flux_density",!1,!0,1],["grain","grain",null,"mass",!1,!0,647989e-10],["gram","g",null,"mass",!1,!0,.001],["gray","Gy",null,"absorbed_dose",!0,!1,1],["gross registered ton","GRT",["regton"],"volume",!1,!0,2.8316846592],["hectare","ha",null,"area",!1,!0,1e4],["henry","H",null,"inductance",!0,!1,1],["hertz","Hz",null,"frequency",!0,!1,1],["horsepower","HP",["h"],"power",!1,!0,745.69987158227],["horsepower-hour","HPh",["hh","hph"],"energy",!1,!0,2684519.538],["hour","h",["hr"],"time",!1,!0,3600],["imperial gallon (U.K.)","uk_gal",null,"volume",!1,!0,.00454609],["imperial hundredweight","lcwt",["uk_cwt","hweight"],"mass",!1,!0,50.802345],["imperial quart (U.K)","uk_qt",null,"volume",!1,!0,.0011365225],["imperial ton","brton",["uk_ton","LTON"],"mass",!1,!0,1016.046909],["inch","in",null,"length",!1,!0,.0254],["international acre","uk_acre",null,"area",!1,!0,4046.8564224],["IT calorie","cal",null,"energy",!1,!0,4.1868],["joule","J",null,"energy",!0,!0,1],["katal","kat",null,"catalytic_activity",!0,!1,1],["kelvin","K",["kel"],"temperature",!0,!0,1],["kilogram","kg",null,"mass",!0,!0,1],["knot","kn",null,"speed",!1,!0,.514444444444444],["light-year","ly",null,"length",!1,!0,9460730472580800],["litre","L",["l","lt"],"volume",!1,!0,.001],["lumen","lm",null,"luminous_flux",!0,!1,1],["lux","lx",null,"illuminance",!0,!1,1],["maxwell","Mx",null,"magnetic_flux",!1,!1,1e-18],["measurement ton","MTON",null,"volume",!1,!0,1.13267386368],["meter per hour","m/h",["m/hr"],"speed",!1,!0,.00027777777777778],["meter per second","m/s",["m/sec"],"speed",!0,!0,1],["meter per second squared","m?s??",null,"acceleration",!0,!1,1],["parsec","pc",["parsec"],"length",!1,!0,0x6da012f958ee1c],["meter squared per second","m?/s",null,"kinematic_viscosity",!0,!1,1],["metre","m",null,"length",!0,!0,1],["miles per hour","mph",null,"speed",!1,!0,.44704],["millimetre of mercury","mmHg",null,"pressure",!1,!1,133.322],["minute","?",null,"angle",!1,!1,.000290888208665722],["minute","min",["mn"],"time",!1,!0,60],["modern teaspoon","tspm",null,"volume",!1,!0,5e-6],["mole","mol",null,"amount_of_substance",!0,!1,1],["morgen","Morgen",null,"area",!1,!0,2500],["n.u. of action","?",null,"action",!1,!1,1.05457168181818e-34],["n.u. of mass","m?",null,"mass",!1,!1,9.10938261616162e-31],["n.u. of speed","c?",null,"speed",!1,!1,299792458],["n.u. of time","?/(me?c??)",null,"time",!1,!1,1.28808866778687e-21],["nautical mile","M",["Nmi"],"length",!1,!0,1852],["newton","N",null,"force",!0,!0,1],["œrsted","Oe ",null,"magnetic_field_intensity",!1,!1,79.5774715459477],["ohm","Ω",null,"electric_resistance",!0,!1,1],["ounce mass","ozm",null,"mass",!1,!0,.028349523125],["pascal","Pa",null,"pressure",!0,!1,1],["pascal second","Pa?s",null,"dynamic_viscosity",!0,!1,1],["pferdestärke","PS",null,"power",!1,!0,735.49875],["phot","ph",null,"illuminance",!1,!1,1e-4],["pica (1/6 inch)","pica",null,"length",!1,!0,.00035277777777778],["pica (1/72 inch)","Pica",["Picapt"],"length",!1,!0,.00423333333333333],["poise","P",null,"dynamic_viscosity",!1,!1,.1],["pond","pond",null,"force",!1,!0,.00980665],["pound force","lbf",null,"force",!1,!0,4.4482216152605],["pound mass","lbm",null,"mass",!1,!0,.45359237],["quart","qt",null,"volume",!1,!0,.000946352946],["radian","rad",null,"angle",!0,!1,1],["second","?",null,"angle",!1,!1,484813681109536e-20],["second","s",["sec"],"time",!0,!0,1],["short hundredweight","cwt",["shweight"],"mass",!1,!0,45.359237],["siemens","S",null,"electrical_conductance",!0,!1,1],["sievert","Sv",null,"equivalent_dose",!0,!1,1],["slug","sg",null,"mass",!1,!0,14.59390294],["square ångström","ang2",["ang^2"],"area",!1,!0,1e-20],["square foot","ft2",["ft^2"],"area",!1,!0,.09290304],["square inch","in2",["in^2"],"area",!1,!0,64516e-8],["square light-year","ly2",["ly^2"],"area",!1,!0,8.95054210748189e31],["square meter","m?",null,"area",!0,!0,1],["square mile","mi2",["mi^2"],"area",!1,!0,2589988.110336],["square nautical mile","Nmi2",["Nmi^2"],"area",!1,!0,3429904],["square Pica","Pica2",["Picapt2","Pica^2","Picapt^2"],"area",!1,!0,1792111111111e-17],["square yard","yd2",["yd^2"],"area",!1,!0,.83612736],["statute mile","mi",null,"length",!1,!0,1609.344],["steradian","sr",null,"solid_angle",!0,!1,1],["stilb","sb",null,"luminance",!1,!1,1e-4],["stokes","St",null,"kinematic_viscosity",!1,!1,1e-4],["stone","stone",null,"mass",!1,!0,6.35029318],["tablespoon","tbs",null,"volume",!1,!0,147868e-10],["teaspoon","tsp",null,"volume",!1,!0,492892e-11],["tesla","T",null,"magnetic_flux_density",!0,!0,1],["thermodynamic calorie","c",null,"energy",!1,!0,4.184],["ton","ton",null,"mass",!1,!0,907.18474],["tonne","t",null,"mass",!1,!1,1e3],["U.K. pint","uk_pt",null,"volume",!1,!0,.00056826125],["U.S. bushel","bushel",null,"volume",!1,!0,.03523907],["U.S. oil barrel","barrel",null,"volume",!1,!0,.158987295],["U.S. pint","pt",["us_pt"],"volume",!1,!0,.000473176473],["U.S. survey mile","survey_mi",null,"length",!1,!0,1609.347219],["U.S. survey/statute acre","us_acre",null,"area",!1,!0,4046.87261],["volt","V",null,"voltage",!0,!1,1],["watt","W",null,"power",!0,!0,1],["watt-hour","Wh",["wh"],"energy",!1,!0,3600],["weber","Wb",null,"magnetic_flux",!0,!1,1],["yard","yd",null,"length",!1,!0,.9144],["year","yr",null,"time",!1,!0,31557600]],o={Yi:["yobi",80,1.2089258196146292e24,"Yi","yotta"],Zi:["zebi",70,0x400000000000000000,"Zi","zetta"],Ei:["exbi",60,0x1000000000000000,"Ei","exa"],Pi:["pebi",50,0x4000000000000,"Pi","peta"],Ti:["tebi",40,1099511627776,"Ti","tera"],Gi:["gibi",30,1073741824,"Gi","giga"],Mi:["mebi",20,1048576,"Mi","mega"],ki:["kibi",10,1024,"ki","kilo"]},f={Y:["yotta",1e24,"Y"],Z:["zetta",1e21,"Z"],E:["exa",1e18,"E"],P:["peta",1e15,"P"],T:["tera",1e12,"T"],G:["giga",1e9,"G"],M:["mega",1e6,"M"],k:["kilo",1e3,"k"],h:["hecto",100,"h"],e:["dekao",10,"e"],d:["deci",.1,"d"],c:["centi",.01,"c"],m:["milli",.001,"m"],u:["micro",1e-6,"u"],n:["nano",1e-9,"n"],p:["pico",1e-12,"p"],f:["femto",1e-15,"f"],a:["atto",1e-18,"a"],z:["zepto",1e-21,"z"],y:["yocto",1e-24,"y"]},s=null,l=null,c=n,m=e,p=1,h=1,v=0;v=0)&&(s=u[v]),(u[v][1]===m||t.indexOf(m)>=0)&&(l=u[v]);if(null===s){var g=o[n.substring(0,2)],N=f[n.substring(0,1)];"da"===n.substring(0,2)&&(N=["dekao",10,"da"]),g?(p=g[2],c=n.substring(2)):N&&(p=N[1],c=n.substring(N[2].length));for(var E=0;E=0)&&(s=u[E])}if(null===l){var I=o[e.substring(0,2)],b=f[e.substring(0,1)];"da"===e.substring(0,2)&&(b=["dekao",10,"da"]),I?(h=I[2],m=e.substring(2)):b&&(h=b[1],m=e.substring(b[2].length));for(var d=0;d=0)&&(l=u[d])}return null===s||null===l?a.na:s[3]!==l[3]?a.na:r*s[6]*p/(l[6]*h)},n.DEC2BIN=function(r,n){if((r=i.parseNumber(r))instanceof Error)return r;if(!/^-?[0-9]{1,3}$/.test(r)||r<-512||r>511)return a.num;if(r<0)return"1"+o.REPT("0",9-(512+r).toString(2).length)+(512+r).toString(2);var e=parseInt(r,10).toString(2);return void 0===n?e:isNaN(n)?a.value:n<0?a.num:(n=Math.floor(n),n>=e.length?o.REPT("0",n-e.length)+e:a.num)},n.DEC2HEX=function(r,n){if((r=i.parseNumber(r))instanceof Error)return r;if(!/^-?[0-9]{1,12}$/.test(r)||r<-549755813888||r>549755813887)return a.num;if(r<0)return(1099511627776+r).toString(16);var e=parseInt(r,10).toString(16);return void 0===n?e:isNaN(n)?a.value:n<0?a.num:(n=Math.floor(n),n>=e.length?o.REPT("0",n-e.length)+e:a.num)},n.DEC2OCT=function(r,n){if((r=i.parseNumber(r))instanceof Error)return r;if(!/^-?[0-9]{1,9}$/.test(r)||r<-536870912||r>536870911)return a.num;if(r<0)return(1073741824+r).toString(8);var e=parseInt(r,10).toString(8);return void 0===n?e:isNaN(n)?a.value:n<0?a.num:(n=Math.floor(n),n>=e.length?o.REPT("0",n-e.length)+e:a.num)},n.DELTA=function(r,n){return n=void 0===n?0:n,r=i.parseNumber(r),n=i.parseNumber(n),i.anyIsError(r,n)?a.value:r===n?1:0},n.ERF=function(r,n){return n=void 0===n?0:n,r=i.parseNumber(r),n=i.parseNumber(n),i.anyIsError(r,n)?a.value:u.erf(r)},n.ERF.PRECISE=function(){throw new Error("ERF.PRECISE is not implemented")},n.ERFC=function(r){return isNaN(r)?a.value:u.erfc(r)},n.ERFC.PRECISE=function(){throw new Error("ERFC.PRECISE is not implemented")},n.GESTEP=function(r,n){return n=n||0,r=i.parseNumber(r),i.anyIsError(n,r)?r:r>=n?1:0},n.HEX2BIN=function(r,n){if(!/^[0-9A-Fa-f]{1,10}$/.test(r))return a.num;var e=10===r.length&&"f"===r.substring(0,1).toLowerCase(),t=e?parseInt(r,16)-1099511627776:parseInt(r,16);if(t<-512||t>511)return a.num;if(e)return"1"+o.REPT("0",9-(512+t).toString(2).length)+(512+t).toString(2);var u=t.toString(2);return void 0===n?u:isNaN(n)?a.value:n<0?a.num:(n=Math.floor(n),n>=u.length?o.REPT("0",n-u.length)+u:a.num)},n.HEX2DEC=function(r){if(!/^[0-9A-Fa-f]{1,10}$/.test(r))return a.num;var n=parseInt(r,16);return n>=549755813888?n-1099511627776:n},n.HEX2OCT=function(r,n){if(!/^[0-9A-Fa-f]{1,10}$/.test(r))return a.num;var e=parseInt(r,16);if(e>536870911&&e<0xffe0000000)return a.num;if(e>=0xffe0000000)return(e-0xffc0000000).toString(8);var t=e.toString(8);return void 0===n?t:isNaN(n)?a.value:n<0?a.num:(n=Math.floor(n),n>=t.length?o.REPT("0",n-t.length)+t:a.num)},n.IMABS=function(r){var e=n.IMREAL(r),t=n.IMAGINARY(r);return i.anyIsError(e,t)?a.value:Math.sqrt(Math.pow(e,2)+Math.pow(t,2))},n.IMAGINARY=function(r){if(void 0===r||!0===r||!1===r)return a.value;if(0===r||"0"===r)return 0;if(["i","j"].indexOf(r)>=0)return 1;r=r.replace("+i","+1i").replace("-i","-1i").replace("+j","+1j").replace("-j","-1j");var n=r.indexOf("+"),e=r.indexOf("-");0===n&&(n=r.indexOf("+",1)),0===e&&(e=r.indexOf("-",1));var t=r.substring(r.length-1,r.length),u="i"===t||"j"===t;return n>=0||e>=0?u?n>=0?isNaN(r.substring(0,n))||isNaN(r.substring(n+1,r.length-1))?a.num:Number(r.substring(n+1,r.length-1)):isNaN(r.substring(0,e))||isNaN(r.substring(e+1,r.length-1))?a.num:-Number(r.substring(e+1,r.length-1)):a.num:u?isNaN(r.substring(0,r.length-1))?a.num:r.substring(0,r.length-1):isNaN(r)?a.num:0},n.IMARGUMENT=function(r){var e=n.IMREAL(r),t=n.IMAGINARY(r);return i.anyIsError(e,t)?a.value:0===e&&0===t?a.div0:0===e&&t>0?Math.PI/2:0===e&&t<0?-Math.PI/2:0===t&&e>0?0:0===t&&e<0?-Math.PI:e>0?Math.atan(t/e):e<0&&t>=0?Math.atan(t/e)+Math.PI:Math.atan(t/e)-Math.PI},n.IMCONJUGATE=function(r){var e=n.IMREAL(r),t=n.IMAGINARY(r);if(i.anyIsError(e,t))return a.value;var u=r.substring(r.length-1);return u="i"===u||"j"===u?u:"i",0!==t?n.COMPLEX(e,-t,u):r},n.IMCOS=function(r){var e=n.IMREAL(r),t=n.IMAGINARY(r);if(i.anyIsError(e,t))return a.value;var u=r.substring(r.length-1);return u="i"===u||"j"===u?u:"i",n.COMPLEX(Math.cos(e)*(Math.exp(t)+Math.exp(-t))/2,-Math.sin(e)*(Math.exp(t)-Math.exp(-t))/2,u)},n.IMCOSH=function(r){var e=n.IMREAL(r),t=n.IMAGINARY(r);if(i.anyIsError(e,t))return a.value;var u=r.substring(r.length-1);return u="i"===u||"j"===u?u:"i",n.COMPLEX(Math.cos(t)*(Math.exp(e)+Math.exp(-e))/2,Math.sin(t)*(Math.exp(e)-Math.exp(-e))/2,u)},n.IMCOT=function(r){var e=n.IMREAL(r),t=n.IMAGINARY(r);return i.anyIsError(e,t)?a.value:n.IMDIV(n.IMCOS(r),n.IMSIN(r))},n.IMDIV=function(r,e){var t=n.IMREAL(r),u=n.IMAGINARY(r),o=n.IMREAL(e),f=n.IMAGINARY(e);if(i.anyIsError(t,u,o,f))return a.value;var s=r.substring(r.length-1),l=e.substring(e.length-1),c="i";if("j"===s?c="j":"j"===l&&(c="j"),0===o&&0===f)return a.num;var m=o*o+f*f;return n.COMPLEX((t*o+u*f)/m,(u*o-t*f)/m,c)},n.IMEXP=function(r){var e=n.IMREAL(r),t=n.IMAGINARY(r);if(i.anyIsError(e,t))return a.value;var u=r.substring(r.length-1);u="i"===u||"j"===u?u:"i";var o=Math.exp(e);return n.COMPLEX(o*Math.cos(t),o*Math.sin(t),u)},n.IMLN=function(r){var e=n.IMREAL(r),t=n.IMAGINARY(r);if(i.anyIsError(e,t))return a.value;var u=r.substring(r.length-1);return u="i"===u||"j"===u?u:"i",n.COMPLEX(Math.log(Math.sqrt(e*e+t*t)),Math.atan(t/e),u)},n.IMLOG10=function(r){var e=n.IMREAL(r),t=n.IMAGINARY(r);if(i.anyIsError(e,t))return a.value;var u=r.substring(r.length-1);return u="i"===u||"j"===u?u:"i",n.COMPLEX(Math.log(Math.sqrt(e*e+t*t))/Math.log(10),Math.atan(t/e)/Math.log(10),u)},n.IMLOG2=function(r){var e=n.IMREAL(r),t=n.IMAGINARY(r);if(i.anyIsError(e,t))return a.value;var u=r.substring(r.length-1);return u="i"===u||"j"===u?u:"i",n.COMPLEX(Math.log(Math.sqrt(e*e+t*t))/Math.log(2),Math.atan(t/e)/Math.log(2),u)},n.IMPOWER=function(r,e){e=i.parseNumber(e);var t=n.IMREAL(r),u=n.IMAGINARY(r);if(i.anyIsError(e,t,u))return a.value;var o=r.substring(r.length-1);o="i"===o||"j"===o?o:"i";var f=Math.pow(n.IMABS(r),e),s=n.IMARGUMENT(r);return n.COMPLEX(f*Math.cos(e*s),f*Math.sin(e*s),o)},n.IMPRODUCT=function(){var r=arguments[0];if(!arguments.length)return a.value;for(var e=1;e=0)return 0;var n=r.indexOf("+"),e=r.indexOf("-");0===n&&(n=r.indexOf("+",1)),0===e&&(e=r.indexOf("-",1));var t=r.substring(r.length-1,r.length),u="i"===t||"j"===t;return n>=0||e>=0?u?n>=0?isNaN(r.substring(0,n))||isNaN(r.substring(n+1,r.length-1))?a.num:Number(r.substring(0,n)):isNaN(r.substring(0,e))||isNaN(r.substring(e+1,r.length-1))?a.num:Number(r.substring(0,e)):a.num:u?isNaN(r.substring(0,r.length-1))?a.num:0:isNaN(r)?a.num:r},n.IMSEC=function(r){if(!0===r||!1===r)return a.value;var e=n.IMREAL(r),t=n.IMAGINARY(r);return i.anyIsError(e,t)?a.value:n.IMDIV("1",n.IMCOS(r))},n.IMSECH=function(r){var e=n.IMREAL(r),t=n.IMAGINARY(r);return i.anyIsError(e,t)?a.value:n.IMDIV("1",n.IMCOSH(r))},n.IMSIN=function(r){var e=n.IMREAL(r),t=n.IMAGINARY(r);if(i.anyIsError(e,t))return a.value;var u=r.substring(r.length-1);return u="i"===u||"j"===u?u:"i",n.COMPLEX(Math.sin(e)*(Math.exp(t)+Math.exp(-t))/2,Math.cos(e)*(Math.exp(t)-Math.exp(-t))/2,u)},n.IMSINH=function(r){var e=n.IMREAL(r),t=n.IMAGINARY(r);if(i.anyIsError(e,t))return a.value;var u=r.substring(r.length-1);return u="i"===u||"j"===u?u:"i",n.COMPLEX(Math.cos(t)*(Math.exp(e)-Math.exp(-e))/2,Math.sin(t)*(Math.exp(e)+Math.exp(-e))/2,u)},n.IMSQRT=function(r){var e=n.IMREAL(r),t=n.IMAGINARY(r);if(i.anyIsError(e,t))return a.value;var u=r.substring(r.length-1);u="i"===u||"j"===u?u:"i";var o=Math.sqrt(n.IMABS(r)),f=n.IMARGUMENT(r);return n.COMPLEX(o*Math.cos(f/2),o*Math.sin(f/2),u)},n.IMCSC=function(r){if(!0===r||!1===r)return a.value;var e=n.IMREAL(r),t=n.IMAGINARY(r);return i.anyIsError(e,t)?a.num:n.IMDIV("1",n.IMSIN(r))},n.IMCSCH=function(r){if(!0===r||!1===r)return a.value;var e=n.IMREAL(r),t=n.IMAGINARY(r);return i.anyIsError(e,t)?a.num:n.IMDIV("1",n.IMSINH(r))},n.IMSUB=function(r,n){var e=this.IMREAL(r),t=this.IMAGINARY(r),u=this.IMREAL(n),o=this.IMAGINARY(n);if(i.anyIsError(e,t,u,o))return a.value;var f=r.substring(r.length-1),s=n.substring(n.length-1),l="i";return"j"===f?l="j":"j"===s&&(l="j"),this.COMPLEX(e-u,t-o,l)},n.IMSUM=function(){if(!arguments.length)return a.value;for(var r=i.flatten(arguments),n=r[0],e=1;e511)return a.num;if(e)return"1"+o.REPT("0",9-(512+t).toString(2).length)+(512+t).toString(2);var u=t.toString(2);return void 0===n?u:isNaN(n)?a.value:n<0?a.num:(n=Math.floor(n),n>=u.length?o.REPT("0",n-u.length)+u:a.num)},n.OCT2DEC=function(r){if(!/^[0-7]{1,10}$/.test(r))return a.num;var n=parseInt(r,8);return n>=536870912?n-1073741824:n},n.OCT2HEX=function(r,n){if(!/^[0-7]{1,10}$/.test(r))return a.num;var e=parseInt(r,8);if(e>=536870912)return"ff"+(e+3221225472).toString(16);var t=e.toString(16);return void 0===n?t:isNaN(n)?a.value:n<0?a.num:(n=Math.floor(n),n>=t.length?o.REPT("0",n-t.length)+t:a.num)}},function(r,n,e){var t=[e(12),e(14),e(10),e(15),e(2),e(4),e(7),e(16),e(6),e(17),e(3),e(9)];for(var a in t){var u=t[a];for(var o in u)n[o]=n[o]||u[o]}},function(r,n,e){function t(r,n){if(n)for(var e in n)r[e]=n[e];return r}var a=e(2),u=e(3),o=e(10),i=e(7);n.BETADIST=u.BETA.DIST,n.BETAINV=u.BETA.INV,n.BINOMDIST=u.BINOM.DIST,n.CEILING=n.ISOCEILING=t(a.CEILING.MATH,a.CEILING),n.CEILINGMATH=a.CEILING.MATH,n.CEILINGPRECISE=a.CEILING.PRECISE,n.CHIDIST=u.CHISQ.DIST,n.CHIDISTRT=u.CHISQ.DIST.RT,n.CHIINV=u.CHISQ.INV,n.CHIINVRT=u.CHISQ.INV.RT,n.CHITEST=u.CHISQ.TEST,n.CONFIDENCE=t(u.CONFIDENCE.NORM,u.CONFIDENCE),n.COVAR=u.COVARIANCE.P,n.COVARIANCEP=u.COVARIANCE.P,n.COVARIANCES=u.COVARIANCE.S,n.CRITBINOM=u.BINOM.INV,n.EXPONDIST=u.EXPON.DIST,n.ERFCPRECISE=o.ERFC.PRECISE,n.ERFPRECISE=o.ERF.PRECISE,n.FDIST=u.F.DIST,n.FDISTRT=u.F.DIST.RT,n.FINVRT=u.F.INV.RT,n.FINV=u.F.INV,n.FLOOR=t(a.FLOOR.MATH,a.FLOOR),n.FLOORMATH=a.FLOOR.MATH,n.FLOORPRECISE=a.FLOOR.PRECISE,n.FTEST=u.F.TEST,n.GAMMADIST=u.GAMMA.DIST,n.GAMMAINV=u.GAMMA.INV,n.GAMMALNPRECISE=u.GAMMALN.PRECISE,n.HYPGEOMDIST=u.HYPGEOM.DIST,n.LOGINV=u.LOGNORM.INV,n.LOGNORMINV=u.LOGNORM.INV,n.LOGNORMDIST=u.LOGNORM.DIST,n.MODE=t(u.MODE.SNGL,u.MODE),n.MODEMULT=u.MODE.MULT,n.MODESNGL=u.MODE.SNGL,n.NEGBINOMDIST=u.NEGBINOM.DIST,n.NETWORKDAYSINTL=i.NETWORKDAYS.INTL,n.NORMDIST=u.NORM.DIST,n.NORMINV=u.NORM.INV,n.NORMSDIST=u.NORM.S.DIST,n.NORMSINV=u.NORM.S.INV,n.PERCENTILE=t(u.PERCENTILE.EXC,u.PERCENTILE),n.PERCENTILEEXC=u.PERCENTILE.EXC,n.PERCENTILEINC=u.PERCENTILE.INC,n.PERCENTRANK=t(u.PERCENTRANK.INC,u.PERCENTRANK),n.PERCENTRANKEXC=u.PERCENTRANK.EXC,n.PERCENTRANKINC=u.PERCENTRANK.INC,n.POISSON=t(u.POISSON.DIST,u.POISSON),n.POISSONDIST=u.POISSON.DIST,n.QUARTILE=t(u.QUARTILE.INC,u.QUARTILE),n.QUARTILEEXC=u.QUARTILE.EXC,n.QUARTILEINC=u.QUARTILE.INC,n.RANK=t(u.RANK.EQ,u.RANK),n.RANKAVG=u.RANK.AVG,n.RANKEQ=u.RANK.EQ,n.SKEWP=u.SKEW.P,n.STDEV=t(u.STDEV.S,u.STDEV),n.STDEVP=u.STDEV.P,n.STDEVS=u.STDEV.S,n.TDIST=u.T.DIST,n.TDISTRT=u.T.DIST.RT,n.TINV=u.T.INV,n.TTEST=u.T.TEST,n.VAR=t(u.VAR.S,u.VAR),n.VARP=u.VAR.P,n.VARS=u.VAR.S,n.WEIBULL=t(u.WEIBULL.DIST,u.WEIBULL),n.WEIBULLDIST=u.WEIBULL.DIST,n.WORKDAYINTL=i.WORKDAY.INTL,n.ZTEST=u.Z.TEST},function(r,n,e){var t;!function(r){r("undefined"==typeof DO_NOT_EXPORT_BESSEL?n:t={})}(function(r){function n(r,n){for(var e=0,t=0;eo)i=e(u,o,r(u),t(u),-1);else{for(var f=2*a.floor((o+a.floor(a.sqrt(40*o)))/2),s=!1,l=0,c=0,m=1,p=0,h=2/u,v=f;v>0;v--)p=v*h*m-l,l=m,m=p,a.abs(m)>1e10&&(m*=1e-10,l*=1e-10,i*=1e-10,c*=1e-10),s&&(c+=m),s=!s,v==o&&(i=l);c=2*c-m,i/=c}return i}}(),o=function(){function r(r){var e=0,t=0,c=0,m=r*r,p=r-.785398164;return r<8?(t=n(i,m),c=n(f,m),e=t/c+o*u(r,0)*a.log(r)):(m=64/m,t=n(s,m),c=n(l,m),e=a.sqrt(o/r)*(a.sin(p)*t+a.cos(p)*c*8/r)),e}function e(r){var e=0,t=0,i=0,f=r*r,s=r-2.356194491;return r<8?(t=r*n(c,f),i=n(m,f),e=t/i+o*(u(r,1)*a.log(r)-1/r)):(f=64/f,t=n(p,f),i=n(h,f),e=a.sqrt(o/r)*(a.sin(s)*t+a.cos(s)*i*8/r)),e}var o=.636619772,i=[-2957821389,7062834065,-512359803.6,10879881.29,-86327.92757,228.4622733].reverse(),f=[40076544269,745249964.8,7189466.438,47447.2647,226.1030244,1].reverse(),s=[1,-.001098628627,2734510407e-14,-2073370639e-15,2.093887211e-7].reverse(),l=[-.01562499995,.0001430488765,-6911147651e-15,7.621095161e-7,-9.34945152e-8].reverse(),c=[-4900604943e3,127527439e4,-51534381390,734926455.1,-4237922.726,8511.937935].reverse(),m=[249958057e5,424441966400,3733650367,22459040.02,102042.605,354.9632885,1].reverse(),p=[1,.00183105,-3516396496e-14,2457520174e-15,-2.40337019e-7].reverse(),h=[.04687499995,-.0002002690873,8449199096e-15,-8.8228987e-7,1.05787412e-7].reverse();return t(r,e,"BESSELY",1,-1)}(),i=function(){function r(r){return r<=3.75?n(t,r*r/14.0625):a.exp(a.abs(r))/a.sqrt(a.abs(r))*n(u,3.75/a.abs(r))}function e(r){return r<3.75?r*n(o,r*r/14.0625):(r<0?-1:1)*a.exp(a.abs(r))/a.sqrt(a.abs(r))*n(i,3.75/a.abs(r))}var t=[1,3.5156229,3.0899424,1.2067492,.2659732,.0360768,.0045813].reverse(),u=[.39894228,.01328592,.00225319,-.00157565,.00916281,-.02057706,.02635537,-.01647633,.00392377].reverse(),o=[.5,.87890594,.51498869,.15084934,.02658733,.00301532,32411e-8].reverse(),i=[.39894228,-.03988024,-.00362018,.00163801,-.01031555,.02282967,-.02895312,.01787654,-.00420059].reverse();return function n(t,u){if(0===(u=Math.round(u)))return r(t);if(1===u)return e(t);if(u<0)return NaN;if(0===a.abs(t))return 0;if(t==1/0)return 1/0;var o,i=0,f=2/a.abs(t),s=0,l=1,c=0,m=2*a.round((u+a.round(a.sqrt(40*u)))/2);for(o=m;o>0;o--)c=o*f*l+s,s=l,l=c,a.abs(l)>1e10&&(l*=1e-10,s*=1e-10,i*=1e-10),o==u&&(i=s);return i*=n(t,0)/l,t<0&&u%2?-i:i}}(),f=function(){function r(r){return r<=2?-a.log(r/2)*i(r,0)+n(u,r*r/4):a.exp(-r)/a.sqrt(r)*n(o,2/r)}function e(r){return r<=2?a.log(r/2)*i(r,1)+1/r*n(f,r*r/4):a.exp(-r)/a.sqrt(r)*n(s,2/r)}var u=[-.57721566,.4227842,.23069756,.0348859,.00262698,1075e-7,74e-7].reverse(),o=[1.25331414,-.07832358,.02189568,-.01062446,.00587872,-.0025154,53208e-8].reverse(),f=[1,.15443144,-.67278579,-.18156897,-.01919402,-.00110404,-4686e-8].reverse(),s=[1.25331414,.23498619,-.0365562,.01504268,-.00780353,.00325614,-68245e-8].reverse();return t(r,e,"BESSELK",2,1)}();r.besselj=u,r.bessely=o,r.besseli=i,r.besselk=f})},function(r,n,e){function t(r){var n=[];return f.arrayEach(r,function(r){r&&n.push(r)}),n}function a(r,n){for(var e={},t=1;ta&&(a=n[t].length);for(var u=1;u1?u.num:i[o[0]]},n.DMAX=function(r,e,t){if(isNaN(e)&&"string"!=typeof e)return u.value;var o=a(r,t),i=[];if("string"==typeof e){var s=n.FINDFIELD(r,e);i=f.rest(r[s])}else i=f.rest(r[e]);var l=i[o[0]];return f.arrayEach(o,function(r){li[r]&&(l=i[r])}),l},n.DPRODUCT=function(r,e,o){if(isNaN(e)&&"string"!=typeof e)return u.value;var i=a(r,o),s=[];if("string"==typeof e){var l=n.FINDFIELD(r,e);s=f.rest(r[l])}else s=f.rest(r[e]);var c=[];f.arrayEach(i,function(r){c.push(s[r])}),c=t(c);var m=1;return f.arrayEach(c,function(r){m*=r}),m},n.DSTDEV=function(r,e,i){if(isNaN(e)&&"string"!=typeof e)return u.value;var s=a(r,i),l=[];if("string"==typeof e){var c=n.FINDFIELD(r,e);l=f.rest(r[c])}else l=f.rest(r[e]);var m=[];return f.arrayEach(s,function(r){m.push(l[r])}),m=t(m),o.STDEV.S(m)},n.DSTDEVP=function(r,e,i){if(isNaN(e)&&"string"!=typeof e)return u.value;var s=a(r,i),l=[];if("string"==typeof e){var c=n.FINDFIELD(r,e);l=f.rest(r[c])}else l=f.rest(r[e]);var m=[];return f.arrayEach(s,function(r){m.push(l[r])}),m=t(m),o.STDEV.P(m)},n.DSUM=function(r,e,t){if(isNaN(e)&&"string"!=typeof e)return u.value;var o=a(r,t),s=[];if("string"==typeof e){var l=n.FINDFIELD(r,e);s=f.rest(r[l])}else s=f.rest(r[e]);var c=[];return f.arrayEach(o,function(r){c.push(s[r])}),i.SUM(c)},n.DVAR=function(r,e,t){if(isNaN(e)&&"string"!=typeof e)return u.value;var i=a(r,t),s=[];if("string"==typeof e){var l=n.FINDFIELD(r,e);s=f.rest(r[l])}else s=f.rest(r[e]);var c=[];return f.arrayEach(i,function(r){c.push(s[r])}),o.VAR.S(c)},n.DVARP=function(r,e,t){if(isNaN(e)&&"string"!=typeof e)return u.value;var i=a(r,t),s=[];if("string"==typeof e){var l=n.FINDFIELD(r,e);s=f.rest(r[l])}else s=f.rest(r[e]);var c=[];return f.arrayEach(i,function(r){c.push(s[r])}),o.VAR.P(c)}},function(r,n,e){var t=e(0),a=e(1),u=e(6);n.AND=function(){for(var r=a.flatten(arguments),n=!0,e=0;e254?t.value:arguments.length0){var n=arguments[0],e=arguments.length-1,a=Math.floor(e/2),u=!1,o=e%2!=0,i=e%2==0?null:arguments[arguments.length-1];if(a)for(var f=0;fo)return u.num;if(0!==f&&1!==f)return u.num;var s=n.PMT(r,e,t,0,f),l=0;1===a&&0===f&&(l=-t,a++);for(var c=a;c<=o;c++)l+=1===f?n.FV(r,c-2,s,t,1)-s:n.FV(r,c-1,s,t,0);return l*=r},n.CUMPRINC=function(r,e,t,a,o,f){if(r=i.parseNumber(r),e=i.parseNumber(e),t=i.parseNumber(t),i.anyIsError(r,e,t))return u.value;if(r<=0||e<=0||t<=0)return u.num;if(a<1||o<1||a>o)return u.num;if(0!==f&&1!==f)return u.num;var s=n.PMT(r,e,t,0,f),l=0;1===a&&(l=0===f?s+t*r:s,a++);for(var c=a;c<=o;c++)l+=f>0?s-(n.FV(r,c-2,s,t,1)-s)*r:s-n.FV(r,c-1,s,t,0)*r;return l},n.DB=function(r,n,e,t,a){if(a=void 0===a?12:a,r=i.parseNumber(r),n=i.parseNumber(n),e=i.parseNumber(e),t=i.parseNumber(t),a=i.parseNumber(a),i.anyIsError(r,n,e,t,a))return u.value;if(r<0||n<0||e<0||t<0)return u.num;if(-1===[1,2,3,4,5,6,7,8,9,10,11,12].indexOf(a))return u.num;if(t>e)return u.num;if(n>=r)return 0;for(var o=(1-Math.pow(n/r,1/e)).toFixed(3),f=r*o*a/12,s=f,l=0,c=t===e?e-1:t,m=2;m<=c;m++)l=(r-s)*o,s+=l;return 1===t?f:t===e?(r-s)*o:l},n.DDB=function(r,n,e,t,a){if(a=void 0===a?2:a,r=i.parseNumber(r),n=i.parseNumber(n),e=i.parseNumber(e),t=i.parseNumber(t),a=i.parseNumber(a),i.anyIsError(r,n,e,t,a))return u.value;if(r<0||n<0||e<0||t<0||a<=0)return u.num;if(t>e)return u.num;if(n>=r)return 0;for(var o=0,f=0,s=1;s<=t;s++)f=Math.min(a/e*(r-o),r-n-o),o+=f;return f},n.DISC=function(){throw new Error("DISC is not implemented")},n.DOLLARDE=function(r,n){if(r=i.parseNumber(r),n=i.parseNumber(n),i.anyIsError(r,n))return u.value;if(n<0)return u.num;if(n>=0&&n<1)return u.div0;n=parseInt(n,10);var e=parseInt(r,10);e+=r%1*Math.pow(10,Math.ceil(Math.log(n)/Math.LN10))/n;var t=Math.pow(10,Math.ceil(Math.log(n)/Math.LN2)+1);return e=Math.round(e*t)/t},n.DOLLARFR=function(r,n){if(r=i.parseNumber(r),n=i.parseNumber(n),i.anyIsError(r,n))return u.value;if(n<0)return u.num;if(n>=0&&n<1)return u.div0;n=parseInt(n,10);var e=parseInt(r,10);return e+=r%1*Math.pow(10,-Math.ceil(Math.log(n)/Math.LN10))*n},n.DURATION=function(){throw new Error("DURATION is not implemented")},n.EFFECT=function(r,n){return r=i.parseNumber(r),n=i.parseNumber(n),i.anyIsError(r,n)?u.value:r<=0||n<1?u.num:(n=parseInt(n,10),Math.pow(1+r/n,n)-1)},n.FV=function(r,n,e,t,a){if(t=t||0,a=a||0,r=i.parseNumber(r),n=i.parseNumber(n),e=i.parseNumber(e),t=i.parseNumber(t),a=i.parseNumber(a),i.anyIsError(r,n,e,t,a))return u.value;var o;if(0===r)o=t+e*n;else{var f=Math.pow(1+r,n);o=1===a?t*f+e*(1+r)*(f-1)/r:t*f+e*(f-1)/r}return-o},n.FVSCHEDULE=function(r,n){if(r=i.parseNumber(r),n=i.parseNumberArray(i.flatten(n)),i.anyIsError(r,n))return u.value;for(var e=n.length,t=r,a=0;a0&&(t=!0),r[o]<0&&(a=!0);if(!t||!a)return u.num;n=void 0===n?.1:n;var f,s,l,c=n,m=!0;do{l=function(r,n,e){for(var t=e+1,a=r[0],u=1;u1e-10&&Math.abs(l)>1e-10}while(m);return c},n.ISPMT=function(r,n,e,t){return r=i.parseNumber(r),n=i.parseNumber(n),e=i.parseNumber(e),t=i.parseNumber(t),i.anyIsError(r,n,e,t)?u.value:t*r*(n/e-1)},n.MDURATION=function(){throw new Error("MDURATION is not implemented")},n.MIRR=function(r,e,t){if(r=i.parseNumberArray(i.flatten(r)),e=i.parseNumber(e),t=i.parseNumber(t),i.anyIsError(r,e,t))return u.value;for(var a=r.length,o=[],f=[],s=0;s1e-10&&h<50;)v=(l*c-s*m)/(l-s),c=m,m=v,Math.abs(v)<1e-10?f=e*(1+r*v)+n*(1+v*a)*r+t:(p=Math.exp(r*Math.log(1+v)),f=e*p+n*(1/v+a)*(p-1)+t),s=l,l=f,++h;return v},n.RECEIVED=function(){throw new Error("RECEIVED is not implemented")},n.RRI=function(r,n,e){return r=i.parseNumber(r),n=i.parseNumber(n),e=i.parseNumber(e),i.anyIsError(r,n,e)?u.value:0===r||0===n?u.num:Math.pow(e/n,1/r)-1},n.SLN=function(r,n,e){return r=i.parseNumber(r),n=i.parseNumber(n),e=i.parseNumber(e),i.anyIsError(r,n,e)?u.value:0===e?u.num:(r-n)/e},n.SYD=function(r,n,e,t){return r=i.parseNumber(r),n=i.parseNumber(n),e=i.parseNumber(e),t=i.parseNumber(t),i.anyIsError(r,n,e,t)?u.value:0===e?u.num:t<1||t>e?u.num:(t=parseInt(t,10),(r-n)*(e-t+1)*2/(e*(e+1)))},n.TBILLEQ=function(r,n,e){return r=i.parseDate(r),n=i.parseDate(n),e=i.parseNumber(e),i.anyIsError(r,n,e)?u.value:e<=0?u.num:r>n?u.num:n-r>31536e6?u.num:365*e/(360-e*o.DAYS360(r,n,!1))},n.TBILLPRICE=function(r,n,e){return r=i.parseDate(r),n=i.parseDate(n),e=i.parseNumber(e),i.anyIsError(r,n,e)?u.value:e<=0?u.num:r>n?u.num:n-r>31536e6?u.num:100*(1-e*o.DAYS360(r,n,!1)/360)},n.TBILLYIELD=function(r,n,e){return r=i.parseDate(r),n=i.parseDate(n),e=i.parseNumber(e),i.anyIsError(r,n,e)?u.value:e<=0?u.num:r>n?u.num:n-r>31536e6?u.num:360*(100-e)/(e*o.DAYS360(r,n,!1))},n.VDB=function(){throw new Error("VDB is not implemented")},n.XNPV=function(r,n,e){if(r=i.parseNumber(r),n=i.parseNumberArray(i.flatten(n)),e=i.parseDateArray(i.flatten(e)),i.anyIsError(r,n,e))return u.value;for(var t=0,a=0;au&&(a=o+1,u=n[o]):(a=o+1,u=n[o]))}else if(0===e){if("string"==typeof r){if(r=r.replace(/\?/g,"."),n[o].toLowerCase().match(r.toLowerCase()))return o+1}else if(n[o]===r)return o+1}else if(-1===e){if(n[o]===r)return o+1;n[o]>r&&(u?n[o]