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