"use strict";(self.webpackChunkstudio_client=self.webpackChunkstudio_client||[]).push([[1867],{4916(t,n,r){r.d(n,{D_t:()=>rt,I4_:()=>it,PV:()=>at,pdR:()=>B});var e=r(6532);r(1160);new Error("#NULL!");const o=new Error("#DIV/0!"),f=new Error("#VALUE!"),u=(new Error("#REF!"),new Error("#NAME?"),new Error("#NUM!")),i=new Error("#N/A");new Error("#ERROR!"),new Error("#GETTING_DATA");function a(t){t<60&&(t+=1);const n=Math.floor(t-25569),r=new Date(1e3*(86400*n)),e=t-Math.floor(t)+1e-7;let o=Math.floor(86400*e);const f=o%60;o-=f;const u=Math.floor(o/3600),i=Math.floor(o/60)%60;let a=r.getUTCDate(),c=r.getUTCMonth();return t>=60&&t<61&&(a=29,c=1),new Date(r.getUTCFullYear(),c,a,u,i,f)}function c(t){const n=[];return l(t,t=>{n.push(t)}),n}function l(t,n){let r=-1;const e=t.length;for(;++r{const r=Array.isArray(t),e=Array.isArray(n);return r&&e?t.concat(n):r?(t.push(n),t):e?[t].concat(n):[t,n]}):[t]}function p(t){if(!t)return!1;for(let n=0;n"number"==typeof t)}function d(t){if(!isNaN(t)){if(t instanceof Date)return new Date(t);const n=parseFloat(t);return n<0||n>=2958466?u:a(n)}return"string"!=typeof t||(t=/(\d{4})-(\d\d?)-(\d\d?)$/.test(t)?new Date(t+"T00:00:00.000"):new Date(t),isNaN(t))?f:t}function E(t){return t instanceof Error?t:null==t?0:("boolean"==typeof t&&(t=+t),isNaN(t)||""===t?f:parseFloat(t))}function S(t){let n,r;if(!t||0===(n=t.length))return f;for(;n--;){if(t[n]instanceof Error)return t[n];if(r=E(t[n]),r instanceof Error)return r;t[n]=r}return t}function N(t){return null!=t}function D(){const t=[];for(let n=0;n(o=void 0===o?0:o,u=void 0===u?1:u,T(t=E(t),n=E(n),r=E(r),o=E(o),u=E(u))?f:e.beta.inv(t,n,r)*(u-o)+o)},b={DIST:(t,n,r,o)=>T(t=E(t),n=E(n),r=E(r),o=E(o))?f:o?e.binomial.cdf(t,n,r):e.binomial.pdf(t,n,r)};b.DIST.RANGE=(t,n,r,e)=>{if(e=void 0===e?r:e,T(t=E(t),n=E(n),r=E(r),e=E(e)))return f;let o=0;for(let f=r;f<=e;f++)o+=K(t,f)*Math.pow(n,f)*Math.pow(1-n,t-f);return o},b.INV=(t,n,r)=>{if(T(t=E(t),n=E(n),r=E(r)))return f;let o=0;for(;o<=t;){if(e.binomial.cdf(o,t,n)>=r)return o;o++}};const A={DIST:(t,n,r)=>T(t=E(t),n=E(n))?f:r?e.chisquare.cdf(t,n):e.chisquare.pdf(t,n)};A.DIST.RT=(t,n)=>!t|!n?i:t<1||n>Math.pow(10,10)?u:"number"!=typeof t||"number"!=typeof n?f:1-e.chisquare.cdf(t,n),A.INV=(t,n)=>T(t=E(t),n=E(n))?f:e.chisquare.inv(t,n),A.INV.RT=(t,n)=>!t|!n?i:t<0||t>1||n<1||n>Math.pow(10,10)?u:"number"!=typeof t||"number"!=typeof n?f:e.chisquare.inv(1-t,n),A.TEST=function(t,n){if(2!==arguments.length)return i;if(!(t instanceof Array&&n instanceof Array))return f;if(t.length!==n.length)return f;if(t[0]&&n[0]&&t[0].length!==n[0].length)return f;const r=t.length;let e,o,u;for(o=0;o=2;)r=r*t/e,e-=2;let o=r,f=n;for(;o>1e-10*r;)f+=2,o=o*t/f,r+=o;return 1-r}(l,c))/1e6};const v={};v.NORM=(t,n,r)=>T(t=E(t),n=E(n),r=E(r))?f:e.normalci(1,t,n,r)[1]-1,v.T=(t,n,r)=>T(t=E(t),n=E(n),r=E(r))?f:e.tci(1,t,n,r)[1]-1;const C={};C.P=(t,n)=>{if(T(t=S(s(t)),n=S(s(n))))return f;const r=e.mean(t),o=e.mean(n);let u=0;const i=t.length;for(let e=0;eT(t=S(s(t)),n=S(s(n)))?f:e.covariance(t,n);const V={DIST:(t,n,r)=>T(t=E(t),n=E(n))?f:r?e.exponential.cdf(t,n):e.exponential.pdf(t,n)},R={};function P(t){return(t=E(t))instanceof Error?t:0===t||parseInt(t,10)===t&&t<0?u:e.gammafn(t)}function F(t){return(t=E(t))instanceof Error?t:e.gammaln(t)}R.DIST=(t,n,r,o)=>T(t=E(t),n=E(n),r=E(r))?f:o?e.centralF.cdf(t,n,r):e.centralF.pdf(t,n,r),R.DIST.RT=function(t,n,r){return 3!==arguments.length?i:t<0||n<1||r<1?u:"number"!=typeof t||"number"!=typeof n||"number"!=typeof r?f:1-e.centralF.cdf(t,n,r)},R.INV=(t,n,r)=>T(t=E(t),n=E(n),r=E(r))?f:t<=0||t>1?u:e.centralF.inv(t,n,r),R.INV.RT=function(t,n,r){return 3!==arguments.length?i:t<0||t>1||n<1||n>Math.pow(10,10)||r<1||r>Math.pow(10,10)?u:"number"!=typeof t||"number"!=typeof n||"number"!=typeof r?f:e.centralF.inv(1-t,n,r)},R.TEST=(t,n)=>{if(!t||!n)return i;if(!(t instanceof Array&&n instanceof Array))return i;if(t.length<2||n.length<2)return o;const r=(t,n)=>{let r=0;for(let e=0;e1||n<=0||r<=0?u:"number"!=typeof t||"number"!=typeof n||"number"!=typeof r?f:e.gamma.inv(t,n,r)},F.PRECISE=function(t){return 1!==arguments.length?i:t<=0?u:"number"!=typeof t?f:e.gammaln(t)};const L={};L.DIST=(t,n,r,e,o)=>{if(T(t=E(t),n=E(n),r=E(r),e=E(e)))return f;function u(t,n,r,e){return K(r,t)*K(e-r,n-t)/K(e,n)}return o?function(t,n,r,e){let o=0;for(let f=0;f<=t;f++)o+=u(f,n,r,e);return o}(t,n,r,e):u(t,n,r,e)};const x={};x.DIST=(t,n,r,o)=>T(t=E(t),n=E(n),r=E(r))?f:o?e.lognormal.cdf(t,n,r):e.lognormal.pdf(t,n,r),x.INV=(t,n,r)=>T(t=E(t),n=E(n),r=E(r))?f:e.lognormal.inv(t,n,r);const q={MULT:function(){const t=S(s(arguments));if(t instanceof Error)return t;const n=t.length,r={};let e,o=[],f=0;for(let u=0;uf&&(f=r[e],o=[]),r[e]===f&&(o[o.length]=e);return o},SNGL:function(){const t=S(s(arguments));return t instanceof Error?t:q.MULT(t).sort((t,n)=>t-n)[0]}},O={DIST:(t,n,r,o)=>T(t=E(t),n=E(n),r=E(r))?f:o?e.negbin.cdf(t,n,r):e.negbin.pdf(t,n,r)},U={};U.DIST=(t,n,r,o)=>T(t=E(t),n=E(n),r=E(r))?f:r<=0?u:o?e.normal.cdf(t,n,r):e.normal.pdf(t,n,r),U.INV=(t,n,r)=>T(t=E(t),n=E(n),r=E(r))?f:e.normal.inv(t,n,r),U.S={},U.S.DIST=(t,n)=>(t=E(t))instanceof Error?f:n?e.normal.cdf(t,0,1):e.normal.pdf(t,0,1),U.S.INV=t=>(t=E(t))instanceof Error?f:e.normal.inv(t,0,1);const X={EXC:(t,n)=>{if(T(t=S(s(t)),n=E(n)))return f;const r=(t=t.sort((t,n)=>t-n)).length;if(n<1/(r+1)||n>1-1/(r+1))return u;const e=n*(r+1)-1,o=Math.floor(e);return I(e===o?t[e]:t[o]+(e-o)*(t[o+1]-t[o]))},INC:(t,n)=>{if(T(t=S(s(t)),n=E(n)))return f;const r=n*((t=t.sort((t,n)=>t-n)).length-1),e=Math.floor(r);return I(r===e?t[r]:t[e]+(r-e)*(t[e+1]-t[e]))}},G={};G.EXC=(t,n,r)=>{if(r=void 0===r?3:r,T(t=S(s(t)),n=E(n),r=E(r)))return f;t=t.sort((t,n)=>t-n);const e=D.apply(null,t),o=t.length,u=e.length,i=Math.pow(10,r);let a=0,c=!1,l=0;for(;!c&&l=e[l]&&(n{if(r=void 0===r?3:r,T(t=S(s(t)),n=E(n),r=E(r)))return f;t=t.sort((t,n)=>t-n);const e=D.apply(null,t),o=t.length,u=e.length,i=Math.pow(10,r);let a=0,c=!1,l=0;for(;!c&&l=e[l]&&(nT(t=E(t),n=E(n))?f:r?e.poisson.cdf(t,n):e.poisson.pdf(t,n);const H={EXC:(t,n)=>{if(T(t=S(M(s(t))),n=E(n)))return f;switch(n){case 1:return X.EXC(t,.25);case 2:return X.EXC(t,.5);case 3:return X.EXC(t,.75);default:return u}},INC:(t,n)=>{if(T(t=S(M(s(t))),n=E(n)))return f;switch(n){case 1:return X.INC(t,.25);case 2:return X.INC(t,.5);case 3:return X.INC(t,.75);default:return u}}},Y={};function _(){const t=S(s(arguments));if(t instanceof Error)return t;const n=e.mean(t),r=t.length;let o=0;for(let e=0;e{if(T(t=E(t),n=S(s(n))))return f;const e=(r=r||!1)?(t,n)=>t-n:(t,n)=>n-t,o=(n=(n=s(n)).sort(e)).length;let u=0;for(let r=0;r1?(2*n.indexOf(t)+u+1)/2:n.indexOf(t)+1},Y.EQ=(t,n,r)=>{if(T(t=E(t),n=S(s(n))))return f;const e=(r=r||!1)?(t,n)=>t-n:(t,n)=>n-t;return(n=n.sort(e)).indexOf(t)+1},_.P=function(){const t=S(s(arguments));if(t instanceof Error)return t;const n=e.mean(t),r=t.length;let o=0,f=0;for(let e=0;e1!==r&&2!==r?u:1===r?y.DIST.RT(t,n):y.DIST["2T"](t,n),y.DIST["2T"]=function(t,n){return 2!==arguments.length?i:t<0||n<1?u:"number"!=typeof t||"number"!=typeof n?f:2*(1-e.studentt.cdf(t,n))},y.DIST.RT=function(t,n){return 2!==arguments.length?i:t<0||n<1?u:"number"!=typeof t||"number"!=typeof n?f:1-e.studentt.cdf(t,n)},y.INV=(t,n)=>T(t=E(t),n=E(n))?f:e.studentt.inv(t,n),y.INV["2T"]=(t,n)=>(t=E(t),n=E(n),t<=0||t>1||n<1?u:T(t,n)?f:Math.abs(e.studentt.inv(t/2,n))),y.TEST=(t,n)=>{if(T(t=S(s(t)),n=S(s(n))))return f;const r=e.mean(t),o=e.mean(n);let u,i=0,a=0;for(u=0;uT(t=E(t),n=E(n),r=E(r))?f:e?1-Math.exp(-Math.pow(t/r,n)):Math.pow(t,n-1)*Math.exp(-Math.pow(t/r,n))*n/Math.pow(r,n)},j={};function B(t){if((t=E(t))instanceof Error)return t;return Math.abs(t)}function J(t,n){const r=g(t=E(t),n=E(n));return r||(0===n?0:t>0&&n<0?u:Math.ceil(t/n)*n)}function K(t,n){const r=g(t=E(t),n=E(n));return r||(t{if(T(t=S(s(t)),n=E(n)))return f;r=r||Q.S(t);const e=t.length;return 1-U.S.DIST((m(t)-n)/(r/Math.sqrt(e)),!0)},J.MATH=(t,n,r=0)=>{void 0===n&&(n=t>0?1:-1);const e=g(t=E(t),n=E(n),r=E(r));return e||(0===n?0:(n=Math.abs(n),0===r||t>0?Math.ceil(t/n)*n:Math.floor(t/n)*n))},J.PRECISE=(t,n)=>J.MATH(t,n);const W=[];function Z(t){if((t=E(t))instanceof Error)return t;const n=Math.floor(t);return 0===n||1===n?1:(W[n]>0||(W[n]=Z(n-1)*n),W[n])}function tt(t,n){const r=g(t=E(t),n=E(n));return r||(n?t>0&&n<0?u:Math.floor(t/n)*n:o)}tt.MATH=(t,n=1,r=0)=>{const e=g(t=E(t),n=E(n),r=E(r));return e||(0===n?0:(n=Math.abs(n),0===r||t>0?Math.floor(t/n)*n:Math.ceil(t/n)*n))},tt.PRECISE=(t,n)=>tt.MATH(t,n);function nt(t,n,r){const e=g(t=E(t),n=E(n));if(e)return e;const o=t>=0?1:-1;let f=(Math.abs(t)+"e"+n).split("e");f=(r(f[0]+"e"+f[1])+"e"+-n).split("e");return Number(f[0]+"e"+f[1])*o}function rt(t,n){return nt(t,n,Math.round)}function et(){let t=0;return l(c(arguments),n=>{if(t instanceof Error)return!1;if(n instanceof Error)t=n;else if("number"==typeof n)t+=n;else if("string"==typeof n){const r=parseFloat(n);!isNaN(r)&&(t+=r)}else if(Array.isArray(n)){const r=et.apply(null,n);r instanceof Error?t=r:t+=r}}),t}const ot=[[],[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]];function ft(t,n,r){return ft.INTL(t,n,1,r)}function ut(t,n,r){return ut.INTL(t,n,1,r)}ft.INTL=(t,n,r,e)=>{if((t=d(t))instanceof Error)return t;if((n=d(n))instanceof Error)return n;let o=!1;const u=[],i=[1,2,3,4,5,6,0],a=new RegExp("^[0|1]{7}$");if(void 0===r)r=ot[1];else if("string"==typeof r&&a.test(r)){o=!0,r=r.split("");for(let t=0;t0?s.getUTCDay():s.getDay();let n=o?u.includes(t):t===r[0]||t===r[1];for(let t=0;t{if((t=d(t))instanceof Error)return t;if((n=E(n))instanceof Error)return n;if(!((r=void 0===r?ot[1]:ot[r])instanceof Array))return f;void 0===e?e=[]:e instanceof Array||(e=[e]);for(let t=0;t