summaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
authorteh_coderer <me@tehcoderer.com>2023-05-04 11:43:18 -0400
committerteh_coderer <me@tehcoderer.com>2023-05-04 11:43:18 -0400
commit7fcb5da38f63333a282adb80b5acf2f9c6b17eae (patch)
treed6e3d3a79c1faf65d58bd2b94725cce283e325ec
parent61093518b37e649cd43b2f56dbce0648d9ee4e6e (diff)
only format numbers over 10_000 on tables
-rw-r--r--frontend-components/tables/src/utils/utils.ts2
-rw-r--r--openbb_terminal/core/plots/table.html2
2 files changed, 2 insertions, 2 deletions
diff --git a/frontend-components/tables/src/utils/utils.ts b/frontend-components/tables/src/utils/utils.ts
index fd8fe70e9b2..68e6db700a5 100644
--- a/frontend-components/tables/src/utils/utils.ts
+++ b/frontend-components/tables/src/utils/utils.ts
@@ -11,7 +11,7 @@ export function formatNumberMagnitude(number: number) {
}
}
- if (number > 1000) {
+ if (number > 10_000) {
const magnitude = Math.min(4, Math.floor(Math.log10(Math.abs(number)) / 3));
const suffix = ["", "K", "M", "B", "T"][magnitude];
const formatted = (number / 10 ** (magnitude * 3)).toFixed(2);
diff --git a/openbb_terminal/core/plots/table.html b/openbb_terminal/core/plots/table.html
index 5993fd03414..c608901c048 100644
--- a/openbb_terminal/core/plots/table.html
+++ b/openbb_terminal/core/plots/table.html
@@ -289,7 +289,7 @@ Add a <Suspense fallback=...> component higher in the tree to provide a loading
`),l.push(` </office:body>
`),s.bookType=="fods"?l.push("</office:document>"):l.push("</office:document-content>"),l.join("")}}();function bw(e,t){if(t.bookType=="fods")return Qg(e,t);var r=Od(),n="",i=[],o=[];return n="mimetype",De(r,n,"application/vnd.oasis.opendocument.spreadsheet"),n="content.xml",De(r,n,Qg(e,t)),i.push([n,"text/xml"]),o.push([n,"ContentFile"]),n="styles.xml",De(r,n,TD(e,t)),i.push([n,"text/xml"]),o.push([n,"StylesFile"]),n="meta.xml",De(r,n,ot+Xx()),i.push([n,"text/xml"]),o.push([n,"MetadataFile"]),n="manifest.rdf",De(r,n,N3(o)),i.push([n,"application/rdf+xml"]),n="META-INF/manifest.xml",De(r,n,k3(i)),r}/*! sheetjs (C) 2013-present SheetJS -- http://sheetjs.com */function zl(e){return new DataView(e.buffer,e.byteOffset,e.byteLength)}function CD(e){return typeof TextEncoder<"u"?new TextEncoder().encode(e):yr(Gr(e))}function AD(e,t){e:for(var r=0;r<=e.length-t.length;++r){for(var n=0;n<t.length;++n)if(e[r+n]!=t[n])continue e;return!0}return!1}function Mn(e){var t=e.reduce(function(i,o){return i+o.length},0),r=new Uint8Array(t),n=0;return e.forEach(function(i){r.set(i,n),n+=i.length}),r}function RD(e,t,r){var n=Math.floor(r==0?0:Math.LOG10E*Math.log(Math.abs(r)))+6176-20,i=r/Math.pow(10,n-6176);e[t+15]|=n>>7,e[t+14]|=(n&127)<<1;for(var o=0;i>=1;++o,i/=256)e[t+o]=i&255;e[t+15]|=r>=0?0:128}function Ua(e,t){var r=t?t[0]:0,n=e[r]&127;e:if(e[r++]>=128&&(n|=(e[r]&127)<<7,e[r++]<128||(n|=(e[r]&127)<<14,e[r++]<128)||(n|=(e[r]&127)<<21,e[r++]<128)||(n+=(e[r]&127)*Math.pow(2,28),++r,e[r++]<128)||(n+=(e[r]&127)*Math.pow(2,35),++r,e[r++]<128)||(n+=(e[r]&127)*Math.pow(2,42),++r,e[r++]<128)))break e;return t&&(t[0]=r),n}function Ne(e){var t=new Uint8Array(7);t[0]=e&127;var r=1;e:if(e>127){if(t[r-1]|=128,t[r]=e>>7&127,++r,e<=16383||(t[r-1]|=128,t[r]=e>>14&127,++r,e<=2097151)||(t[r-1]|=128,t[r]=e>>21&127,++r,e<=268435455)||(t[r-1]|=128,t[r]=e/256>>>21&127,++r,e<=34359738367)||(t[r-1]|=128,t[r]=e/65536>>>21&127,++r,e<=4398046511103))break e;t[r-1]|=128,t[r]=e/16777216>>>21&127,++r}return t.slice(0,r)}function io(e){var t=0,r=e[t]&127;e:if(e[t++]>=128){if(r|=(e[t]&127)<<7,e[t++]<128||(r|=(e[t]&127)<<14,e[t++]<128)||(r|=(e[t]&127)<<21,e[t++]<128))break e;r|=(e[t]&127)<<28}return r}function lt(e){for(var t=[],r=[0];r[0]<e.length;){var n=r[0],i=Ua(e,r),o=i&7;i=Math.floor(i/8);var a=0,s;if(i==0)break;switch(o){case 0:{for(var l=r[0];e[r[0]++]>=128;);s=e.slice(l,r[0])}break;case 5:a=4,s=e.slice(r[0],r[0]+a),r[0]+=a;break;case 1:a=8,s=e.slice(r[0],r[0]+a),r[0]+=a;break;case 2:a=Ua(e,r),s=e.slice(r[0],r[0]+a),r[0]+=a;break;case 3:case 4:default:throw new Error("PB Type ".concat(o," for Field ").concat(i," at offset ").concat(n))}var u={data:s,type:o};t[i]==null?t[i]=[u]:t[i].push(u)}return t}function gt(e){var t=[];return e.forEach(function(r,n){r.forEach(function(i){i.data&&(t.push(Ne(n*8+i.type)),i.type==2&&t.push(Ne(i.data.length)),t.push(i.data))})}),Mn(t)}function mr(e){for(var t,r=[],n=[0];n[0]<e.length;){var i=Ua(e,n),o=lt(e.slice(n[0],n[0]+i));n[0]+=i;var a={id:io(o[1][0].data),messages:[]};o[2].forEach(function(s){var l=lt(s.data),u=io(l[3][0].data);a.messages.push({meta:l,data:e.slice(n[0],n[0]+u)}),n[0]+=u}),(t=o[3])!=null&&t[0]&&(a.merge=io(o[3][0].data)>>>0>0),r.push(a)}return r}function Di(e){var t=[];return e.forEach(function(r){var n=[];n[1]=[{data:Ne(r.id),type:0}],n[2]=[],r.merge!=null&&(n[3]=[{data:Ne(+!!r.merge),type:0}]);var i=[];r.messages.forEach(function(a){i.push(a.data),a.meta[3]=[{type:0,data:Ne(a.data.length)}],n[2].push({data:gt(a.meta),type:2})});var o=gt(n);t.push(Ne(o.length)),t.push(o),i.forEach(function(a){return t.push(a)})}),Mn(t)}function OD(e,t){if(e!=0)throw new Error("Unexpected Snappy chunk type ".concat(e));for(var r=[0],n=Ua(t,r),i=[];r[0]<t.length;){var o=t[r[0]]&3;if(o==0){var a=t[r[0]++]>>2;if(a<60)++a;else{var s=a-59;a=t[r[0]],s>1&&(a|=t[r[0]+1]<<8),s>2&&(a|=t[r[0]+2]<<16),s>3&&(a|=t[r[0]+3]<<24),a>>>=0,a++,r[0]+=s}i.push(t.slice(r[0],r[0]+a)),r[0]+=a;continue}else{var l=0,u=0;if(o==1?(u=(t[r[0]]>>2&7)+4,l=(t[r[0]++]&224)<<3,l|=t[r[0]++]):(u=(t[r[0]++]>>2)+1,o==2?(l=t[r[0]]|t[r[0]+1]<<8,r[0]+=2):(l=(t[r[0]]|t[r[0]+1]<<8|t[r[0]+2]<<16|t[r[0]+3]<<24)>>>0,r[0]+=4)),i=[Mn(i)],l==0)throw new Error("Invalid offset 0");if(l>i[0].length)throw new Error("Invalid offset beyond length");if(u>=l)for(i.push(i[0].slice(-l)),u-=l;u>=i[i.length-1].length;)i.push(i[i.length-1]),u-=i[i.length-1].length;i.push(i[0].slice(-l,-l+u))}}var c=Mn(i);if(c.length!=n)throw new Error("Unexpected length: ".concat(c.length," != ").concat(n));return c}function vr(e){for(var t=[],r=0;r<e.length;){var n=e[r++],i=e[r]|e[r+1]<<8|e[r+2]<<16;r+=3,t.push(OD(n,e.slice(r,r+i))),r+=i}if(r!==e.length)throw new Error("data is not a valid framed stream!");return Mn(t)}function Pi(e){for(var t=[],r=0;r<e.length;){var n=Math.min(e.length-r,268435455),i=new Uint8Array(4);t.push(i);var o=Ne(n),a=o.length;t.push(o),n<=60?(a++,t.push(new Uint8Array([n-1<<2]))):n<=256?(a+=2,t.push(new Uint8Array([240,n-1&255]))):n<=65536?(a+=3,t.push(new Uint8Array([244,n-1&255,n-1>>8&255]))):n<=16777216?(a+=4,t.push(new Uint8Array([248,n-1&255,n-1>>8&255,n-1>>16&255]))):n<=4294967296&&(a+=5,t.push(new Uint8Array([252,n-1&255,n-1>>8&255,n-1>>16&255,n-1>>>24&255]))),t.push(e.slice(r,r+n)),a+=n,i[0]=0,i[1]=a&255,i[2]=a>>8&255,i[3]=a>>16&255,r+=n}return Mn(t)}function Pc(e,t){var r=new Uint8Array(32),n=zl(r),i=12,o=0;switch(r[0]=5,e.t){case"n":r[1]=2,RD(r,i,e.v),o|=1,i+=16;break;case"b":r[1]=6,n.setFloat64(i,e.v?1:0,!0),o|=2,i+=8;break;case"s":if(t.indexOf(e.v)==-1)throw new Error("Value ".concat(e.v," missing from SST!"));r[1]=3,n.setUint32(i,t.indexOf(e.v),!0),o|=8,i+=4;break;default:throw"unsupported cell type "+e.t}return n.setUint32(8,o,!0),r.slice(0,i)}function Ic(e,t){var r=new Uint8Array(32),n=zl(r),i=12,o=0;switch(r[0]=3,e.t){case"n":r[2]=2,n.setFloat64(i,e.v,!0),o|=32,i+=8;break;case"b":r[2]=6,n.setFloat64(i,e.v?1:0,!0),o|=32,i+=8;break;case"s":if(t.indexOf(e.v)==-1)throw new Error("Value ".concat(e.v," missing from SST!"));r[2]=3,n.setUint32(i,t.indexOf(e.v),!0),o|=16,i+=4;break;default:throw"unsupported cell type "+e.t}return n.setUint32(4,o,!0),r.slice(0,i)}function ln(e){var t=lt(e);return Ua(t[1][0].data)}function FD(e,t,r){var n,i,o,a;if(!((n=e[6])!=null&&n[0])||!((i=e[7])!=null&&i[0]))throw"Mutation only works on post-BNC storages!";var s=((a=(o=e[8])==null?void 0:o[0])==null?void 0:a.data)&&io(e[8][0].data)>0||!1;if(s)throw"Math only works with normal offsets";for(var l=0,u=zl(e[7][0].data),c=0,f=[],d=zl(e[4][0].data),h=0,m=[],p=0;p<t.length;++p){if(t[p]==null){u.setUint16(p*2,65535,!0),d.setUint16(p*2,65535);continue}u.setUint16(p*2,c,!0),d.setUint16(p*2,h,!0);var g,x;switch(typeof t[p]){case"string":g=Pc({t:"s",v:t[p]},r),x=Ic({t:"s",v:t[p]},r);break;case"number":g=Pc({t:"n",v:t[p]},r),x=Ic({t:"n",v:t[p]},r);break;case"boolean":g=Pc({t:"b",v:t[p]},r),x=Ic({t:"b",v:t[p]},r);break;default:throw new Error("Unsupported value "+t[p])}f.push(g),c+=g.length,m.push(x),h+=x.length,++l}for(e[2][0].data=Ne(l);p<e[7][0].data.length/2;++p)u.setUint16(p*2,65535,!0),d.setUint16(p*2,65535,!0);return e[6][0].data=Mn(f),e[3][0].data=Mn(m),l}function DD(e,t){if(!t||!t.numbers)throw new Error("Must pass a `numbers` option -- check the README");var r=e.Sheets[e.SheetNames[0]];e.SheetNames.length>1&&console.error("The Numbers writer currently writes only the first table");var n=Jt(r["!ref"]);n.s.r=n.s.c=0;var i=!1;n.e.c>9&&(i=!0,n.e.c=9),n.e.r>49&&(i=!0,n.e.r=49),i&&console.error("The Numbers writer is currently limited to ".concat(it(n)));var o=Gl(r,{range:n,header:1}),a=["~Sh33tJ5~"];o.forEach(function(k){return k.forEach(function(b){typeof b=="string"&&a.push(b)})});var s={},l=[],u=He.read(t.numbers,{type:"base64"});u.FileIndex.map(function(k,b){return[k,u.FullPaths[b]]}).forEach(function(k){var b=k[0],D=k[1];if(b.type==2&&b.name.match(/\.iwa/)){var H=b.content,G=vr(H),J=mr(G);J.forEach(function(W){l.push(W.id),s[W.id]={deps:[],location:D,type:io(W.messages[0].meta[1][0].data)}})}}),l.sort(function(k,b){return k-b});var c=l.filter(function(k){return k>1}).map(function(k){return[k,Ne(k)]});u.FileIndex.map(function(k,b){return[k,u.FullPaths[b]]}).forEach(function(k){var b=k[0];if(k[1],!!b.name.match(/\.iwa/)){var D=mr(vr(b.content));D.forEach(function(H){H.messages.forEach(function(G){c.forEach(function(J){H.messages.some(function(W){return io(W.meta[1][0].data)!=11006&&AD(W.data,J[1])})&&s[J[0]].deps.push(H.id)})})})}});for(var f=He.find(u,s[1].location),d=mr(vr(f.content)),h,m=0;m<d.length;++m){var p=d[m];p.id==1&&(h=p)}var g=ln(lt(h.messages[0].data)[1][0].data);for(f=He.find(u,s[g].location),d=mr(vr(f.content)),m=0;m<d.length;++m)p=d[m],p.id==g&&(h=p);for(g=ln(lt(h.messages[0].data)[2][0].data),f=He.find(u,s[g].location),d=mr(vr(f.content)),m=0;m<d.length;++m)p=d[m],p.id==g&&(h=p);for(g=ln(lt(h.messages[0].data)[2][0].data),f=He.find(u,s[g].location),d=mr(vr(f.content)),m=0;m<d.length;++m)p=d[m],p.id==g&&(h=p);var x=lt(h.messages[0].data);{x[6][0].data=Ne(n.e.r+1),x[7][0].data=Ne(n.e.c+1);var w=ln(x[46][0].data),y=He.find(u,s[w].location),_=mr(vr(y.content));{for(var N=0;N<_.length&&_[N].id!=w;++N);if(_[N].id!=w)throw"Bad ColumnRowUIDMapArchive";var M=lt(_[N].messages[0].data);M[1]=[],M[2]=[],M[3]=[];for(var S=0;S<=n.e.c;++S){var C=[];C[1]=C[2]=[{type:0,data:Ne(S+420690)}],M[1].push({type:2,data:gt(C)}),M[2].push({type:0,data:Ne(S)}),M[3].push({type:0,data:Ne(S)})}M[4]=[],M[5]=[],M[6]=[];for(var A=0;A<=n.e.r;++A)C=[],C[1]=C[2]=[{type:0,data:Ne(A+726270)}],M[4].push({type:2,data:gt(C)}),M[5].push({type:0,data:Ne(A)}),M[6].push({type:0,data:Ne(A)});_[N].messages[0].data=gt(M)}y.content=Pi(Di(_)),y.size=y.content.length,delete x[46];var L=lt(x[4][0].data);{L[7][0].data=Ne(n.e.r+1);var U=lt(L[1][0].data),B=ln(U[2][0].data);y=He.find(u,s[B].location),_=mr(vr(y.content));{if(_[0].id!=B)throw"Bad HeaderStorageBucket";var V=lt(_[0].messages[0].data);for(A=0;A<o.length;++A){var Q=lt(V[2][0].data);Q[1][0].data=Ne(A),Q[4][0].data=Ne(o[A].length),V[2][A]={type:V[2][0].type,data:gt(Q)}}_[0].messages[0].data=gt(V)}y.content=Pi(Di(_)),y.size=y.content.length;var ne=ln(L[2][0].data);y=He.find(u,s[ne].location),_=mr(vr(y.content));{if(_[0].id!=ne)throw"Bad HeaderStorageBucket";for(V=lt(_[0].messages[0].data),S=0;S<=n.e.c;++S)Q=lt(V[2][0].data),Q[1][0].data=Ne(S),Q[4][0].data=Ne(n.e.r+1),V[2][S]={type:V[2][0].type,data:gt(Q)};_[0].messages[0].data=gt(V)}y.content=Pi(Di(_)),y.size=y.content.length;var ye=ln(L[4][0].data);(function(){for(var k=He.find(u,s[ye].location),b=mr(vr(k.content)),D,H=0;H<b.length;++H){var G=b[H];G.id==ye&&(D=G)}var J=lt(D.messages[0].data);{J[3]=[];var W=[];a.forEach(function(he,Ce){W[1]=[{type:0,data:Ne(Ce)}],W[2]=[{type:0,data:Ne(1)}],W[3]=[{type:2,data:CD(he)}],J[3].push({type:2,data:gt(W)})})}D.messages[0].data=gt(J);var q=Di(b),fe=Pi(q);k.content=fe,k.size=k.content.length})();var ve=lt(L[3][0].data);{var Te=ve[1][0];delete ve[2];var ie=lt(Te.data);{var Ee=ln(ie[2][0].data);(function(){for(var k=He.find(u,s[Ee].location),b=mr(vr(k.content)),D,H=0;H<b.length;++H){var G=b[H];G.id==Ee&&(D=G)}var J=lt(D.messages[0].data);{delete J[6],delete ve[7];var W=new Uint8Array(J[5][0].data);J[5]=[];for(var q=0,fe=0;fe<=n.e.r;++fe){var he=lt(W);q+=FD(he,o[fe],a),he[1][0].data=Ne(fe),J[5].push({data:gt(he),type:2})}J[1]=[{type:0,data:Ne(n.e.c+1)}],J[2]=[{type:0,data:Ne(n.e.r+1)}],J[3]=[{type:0,data:Ne(q)}],J[4]=[{type:0,data:Ne(n.e.r+1)}]}D.messages[0].data=gt(J);var Ce=Di(b),ce=Pi(Ce);k.content=ce,k.size=k.content.length})()}Te.data=gt(ie)}L[3][0].data=gt(ve)}x[4][0].data=gt(L)}h.messages[0].data=gt(x);var ee=Di(d),O=Pi(ee);return f.content=O,f.size=f.content.length,u}function PD(e){return function(r){for(var n=0;n!=e.length;++n){var i=e[n];r[i[0]]===void 0&&(r[i[0]]=i[1]),i[2]==="n"&&(r[i[0]]=Number(r[i[0]]))}}}function zd(e){PD([["cellDates",!1],["bookSST",!1],["bookType","xlsx"],["compression",!1],["WTF",!1]])(e)}function ID(e,t){return t.bookType=="ods"?bw(e,t):t.bookType=="numbers"?DD(e,t):t.bookType=="xlsb"?bD(e,t):kD(e,t)}function bD(e,t){Wi=1024,e&&!e.SSF&&(e.SSF=Xt(tt)),e&&e.SSF&&(Eu(),yu(e.SSF),t.revssf=_u(e.SSF),t.revssf[e.SSF[65535]]=0,t.ssf=e.SSF),t.rels={},t.wbrels={},t.Strings=[],t.Strings.Count=0,t.Strings.Unique=0,xa?t.revStrings=new Map:(t.revStrings={},t.revStrings.foo=[],delete t.revStrings.foo);var r=t.bookType=="xlsb"?"bin":"xml",n=gw.indexOf(t.bookType)>-1,i=zx();zd(t=t||{});var o=Od(),a="",s=0;if(t.cellXfs=[],Un(t.cellXfs,{},{revssf:{General:0}}),e.Props||(e.Props={}),a="docProps/core.xml",De(o,a,Kx(e.Props,t)),i.coreprops.push(a),Me(t.rels,2,a,be.CORE_PROPS),a="docProps/app.xml",!(e.Props&&e.Props.SheetNames))if(!e.Workbook||!e.Workbook.Sheets)e.Props.SheetNames=e.SheetNames;else{for(var l=[],u=0;u<e.SheetNames.length;++u)(e.Workbook.Sheets[u]||{}).Hidden!=2&&l.push(e.SheetNames[u]);e.Props.SheetNames=l}for(e.Props.Worksheets=e.Props.SheetNames.length,De(o,a,qx(e.Props)),i.extprops.push(a),Me(t.rels,3,a,be.EXT_PROPS),e.Custprops!==e.Props&&Tt(e.Custprops||{}).length>0&&(a="docProps/custom.xml",De(o,a,Qx(e.Custprops)),i.custprops.push(a),Me(t.rels,4,a,be.CUST_PROPS)),s=1;s<=e.SheetNames.length;++s){var c={"!id":{}},f=e.Sheets[e.SheetNames[s-1]],d=(f||{})["!type"]||"sheet";switch(d){case"chart":default:a="xl/worksheets/sheet"+s+"."+r,De(o,a,N6(s-1,a,t,e,c)),i.sheets.push(a),Me(t.wbrels,-1,"worksheets/sheet"+s+"."+r,be.WS[0])}if(f){var h=f["!comments"],m=!1,p="";h&&h.length>0&&(p="xl/comments"+s+"."+r,De(o,p,B6(h,p)),i.comments.push(p),Me(c,-1,"../comments"+s+"."+r,be.CMNT),m=!0),f["!legacy"]&&m&&De(o,"xl/drawings/vmlDrawing"+s+".vml",hw(s,f["!comments"])),delete f["!comments"],delete f["!legacy"]}c["!id"].rId1&&De(o,jx(a),ro(c))}return t.Strings!=null&&t.Strings.length>0&&(a="xl/sharedStrings."+r,De(o,a,L6(t.Strings,a,t)),i.strs.push(a),Me(t.wbrels,-1,"sharedStrings."+r,be.SST)),a="xl/workbook."+r,De(o,a,$6(e,a)),i.workbooks.push(a),Me(t.rels,1,a,be.WB),a="xl/theme/theme1.xml",De(o,a,fw(e.Themes,t)),i.themes.push(a),Me(t.wbrels,-1,"theme/theme1.xml",be.THEME),a="xl/styles."+r,De(o,a,M6(e,a,t)),i.styles.push(a),Me(t.wbrels,-1,"styles."+r,be.STY),e.vbaraw&&n&&(a="xl/vbaProject.bin",De(o,a,e.vbaraw),i.vba.push(a),Me(t.wbrels,-1,"vbaProject.bin",be.VBA)),a="xl/metadata."+r,De(o,a,U6(a)),i.metadata.push(a),Me(t.wbrels,-1,"metadata."+r,be.XLMETA),De(o,"[Content_Types].xml",Gx(i,t)),De(o,"_rels/.rels",ro(t.rels)),De(o,"xl/_rels/workbook."+r+".rels",ro(t.wbrels)),delete t.revssf,delete t.ssf,o}function kD(e,t){Wi=1024,e&&!e.SSF&&(e.SSF=Xt(tt)),e&&e.SSF&&(Eu(),yu(e.SSF),t.revssf=_u(e.SSF),t.revssf[e.SSF[65535]]=0,t.ssf=e.SSF),t.rels={},t.wbrels={},t.Strings=[],t.Strings.Count=0,t.Strings.Unique=0,xa?t.revStrings=new Map:(t.revStrings={},t.revStrings.foo=[],delete t.revStrings.foo);var r="xml",n=gw.indexOf(t.bookType)>-1,i=zx();zd(t=t||{});var o=Od(),a="",s=0;if(t.cellXfs=[],Un(t.cellXfs,{},{revssf:{General:0}}),e.Props||(e.Props={}),a="docProps/core.xml",De(o,a,Kx(e.Props,t)),i.coreprops.push(a),Me(t.rels,2,a,be.CORE_PROPS),a="docProps/app.xml",!(e.Props&&e.Props.SheetNames))if(!e.Workbook||!e.Workbook.Sheets)e.Props.SheetNames=e.SheetNames;else{for(var l=[],u=0;u<e.SheetNames.length;++u)(e.Workbook.Sheets[u]||{}).Hidden!=2&&l.push(e.SheetNames[u]);e.Props.SheetNames=l}e.Props.Worksheets=e.Props.SheetNames.length,De(o,a,qx(e.Props)),i.extprops.push(a),Me(t.rels,3,a,be.EXT_PROPS),e.Custprops!==e.Props&&Tt(e.Custprops||{}).length>0&&(a="docProps/custom.xml",De(o,a,Qx(e.Custprops)),i.custprops.push(a),Me(t.rels,4,a,be.CUST_PROPS));var c=["SheetJ5"];for(t.tcid=0,s=1;s<=e.SheetNames.length;++s){var f={"!id":{}},d=e.Sheets[e.SheetNames[s-1]],h=(d||{})["!type"]||"sheet";switch(h){case"chart":default:a="xl/worksheets/sheet"+s+"."+r,De(o,a,Tw(s-1,t,e,f)),i.sheets.push(a),Me(t.wbrels,-1,"worksheets/sheet"+s+"."+r,be.WS[0])}if(d){var m=d["!comments"],p=!1,g="";if(m&&m.length>0){var x=!1;m.forEach(function(w){w[1].forEach(function(y){y.T==!0&&(x=!0)})}),x&&(g="xl/threadedComments/threadedComment"+s+"."+r,De(o,g,fR(m,c,t)),i.threadedcomments.push(g),Me(f,-1,"../threadedComments/threadedComment"+s+"."+r,be.TCMNT)),g="xl/comments"+s+"."+r,De(o,g,pw(m)),i.comments.push(g),Me(f,-1,"../comments"+s+"."+r,be.CMNT),p=!0}d["!legacy"]&&p&&De(o,"xl/drawings/vmlDrawing"+s+".vml",hw(s,d["!comments"])),delete d["!comments"],delete d["!legacy"]}f["!id"].rId1&&De(o,jx(a),ro(f))}return t.Strings!=null&&t.Strings.length>0&&(a="xl/sharedStrings."+r,De(o,a,ow(t.Strings,t)),i.strs.push(a),Me(t.wbrels,-1,"sharedStrings."+r,be.SST)),a="xl/workbook."+r,De(o,a,Rw(e)),i.workbooks.push(a),Me(t.rels,1,a,be.WB),a="xl/theme/theme1.xml",De(o,a,fw(e.Themes,t)),i.themes.push(a),Me(t.wbrels,-1,"theme/theme1.xml",be.THEME),a="xl/styles."+r,De(o,a,uw(e,t)),i.styles.push(a),Me(t.wbrels,-1,"styles."+r,be.STY),e.vbaraw&&n&&(a="xl/vbaProject.bin",De(o,a,e.vbaraw),i.vba.push(a),Me(t.wbrels,-1,"vbaProject.bin",be.VBA)),a="xl/metadata."+r,De(o,a,dw()),i.metadata.push(a),Me(t.wbrels,-1,"metadata."+r,be.XLMETA),c.length>1&&(a="xl/persons/person.xml",De(o,a,dR(c)),i.people.push(a),Me(t.wbrels,-1,"persons/person.xml",be.PEOPLE)),De(o,"[Content_Types].xml",Gx(i,t)),De(o,"_rels/.rels",ro(t.rels)),De(o,"xl/_rels/workbook."+r+".rels",ro(t.wbrels)),delete t.revssf,delete t.ssf,o}function $D(e,t){var r="";switch((t||{}).type||"base64"){case"buffer":return[e[0],e[1],e[2],e[3],e[4],e[5],e[6],e[7]];case"base64":r=tn(e.slice(0,12));break;case"binary":r=e;break;case"array":return[e[0],e[1],e[2],e[3],e[4],e[5],e[6],e[7]];default:throw new Error("Unrecognized type "+(t&&t.type||"undefined"))}return[r.charCodeAt(0),r.charCodeAt(1),r.charCodeAt(2),r.charCodeAt(3),r.charCodeAt(4),r.charCodeAt(5),r.charCodeAt(6),r.charCodeAt(7)]}function kw(e,t){switch(t.type){case"base64":case"binary":break;case"buffer":case"array":t.type="";break;case"file":return Ja(t.file,He.write(e,{type:ke?"buffer":""}));case"string":throw new Error("'string' output type invalid for '"+t.bookType+"' files");default:throw new Error("Unrecognized type "+t.type)}return He.write(e,t)}function ND(e,t){var r=Xt(t||{}),n=ID(e,r);return MD(n,r)}function MD(e,t){var r={},n=ke?"nodebuffer":typeof Uint8Array<"u"?"array":"string";if(t.compression&&(r.compression="DEFLATE"),t.password)r.type=n;else switch(t.type){case"base64":r.type="base64";break;case"binary":r.type="string";break;case"string":throw new Error("'string' output type invalid for '"+t.bookType+"' files");case"buffer":case"file":r.type=n;break;default:throw new Error("Unrecognized type "+t.type)}var i=e.FullPaths?He.write(e,{fileType:"zip",type:{nodebuffer:"buffer",string:"binary"}[r.type]||r.type,compression:!!t.compression}):e.generate(r);if(typeof Deno<"u"&&typeof i=="string"){if(t.type=="binary"||t.type=="base64")return i;i=new Uint8Array(wu(i))}return t.password&&typeof encrypt_agile<"u"?kw(encrypt_agile(i,t.password),t):t.type==="file"?Ja(t.file,i):t.type=="string"?pa(i):i}function LD(e,t){var r=t||{},n=eD(e,r);return kw(n,r)}function Ar(e,t,r){r||(r="");var n=r+e;switch(t.type){case"base64":return Ma(Gr(n));case"binary":return Gr(n);case"string":return e;case"file":return Ja(t.file,n,"utf8");case"buffer":return ke?sn(n,"utf8"):typeof TextEncoder<"u"?new TextEncoder().encode(n):Ar(n,{type:"binary"}).split("").map(function(i){return i.charCodeAt(0)})}throw new Error("Unrecognized type "+t.type)}function BD(e,t){switch(t.type){case"base64":return Ma(e);case"binary":return e;case"string":return e;case"file":return Ja(t.file,e,"binary");case"buffer":return ke?sn(e,"binary"):e.split("").map(function(r){return r.charCodeAt(0)})}throw new Error("Unrecognized type "+t.type)}function ks(e,t){switch(t.type){case"string":case"base64":case"binary":for(var r="",n=0;n<e.length;++n)r+=String.fromCharCode(e[n]);return t.type=="base64"?Ma(r):t.type=="string"?pa(r):r;case"file":return Ja(t.file,e);case"buffer":return e;default:throw new Error("Unrecognized type "+t.type)}}function $w(e,t){d4(),T6(e);var r=Xt(t||{});if(r.cellStyles&&(r.cellNF=!0,r.sheetStubs=!0),r.type=="array"){r.type="binary";var n=$w(e,r);return r.type="array",wu(n)}var i=0;if(r.sheet&&(typeof r.sheet=="number"?i=r.sheet:i=e.SheetNames.indexOf(r.sheet),!e.SheetNames[i]))throw new Error("Sheet not found: "+r.sheet+" : "+typeof r.sheet);switch(r.bookType||"xlsb"){case"xml":case"xlml":return Ar(Z6(e,r),r);case"slk":case"sylk":return Ar(EA.from_sheet(e.Sheets[e.SheetNames[i]],r),r);case"htm":case"html":return Ar(Dw(e.Sheets[e.SheetNames[i]],r),r);case"txt":return BD(Nw(e.Sheets[e.SheetNames[i]],r),r);case"csv":return Ar(Gd(e.Sheets[e.SheetNames[i]],r),r,"\uFEFF");case"dif":return Ar(_A.from_sheet(e.Sheets[e.SheetNames[i]],r),r);case"dbf":return ks(yA.from_sheet(e.Sheets[e.SheetNames[i]],r),r);case"prn":return Ar(SA.from_sheet(e.Sheets[e.SheetNames[i]],r),r);case"rtf":return Ar(DA.from_sheet(e.Sheets[e.SheetNames[i]],r),r);case"eth":return Ar(iw.from_sheet(e.Sheets[e.SheetNames[i]],r),r);case"fods":return Ar(bw(e,r),r);case"wk1":return ks(zg.sheet_to_wk1(e.Sheets[e.SheetNames[i]],r),r);case"wk3":return ks(zg.book_to_wk3(e,r),r);case"biff2":r.biff||(r.biff=2);case"biff3":r.biff||(r.biff=3);case"biff4":return r.biff||(r.biff=4),ks(Fw(e,r),r);case"biff5":r.biff||(r.biff=5);case"biff8":case"xla":case"xls":return r.biff||(r.biff=8),LD(e,r);case"xlsx":case"xlsm":case"xlam":case"xlsb":case"numbers":case"ods":return ND(e,r);default:throw new Error("Unrecognized bookType |"+r.bookType+"|")}}function UD(e){if(!e.bookType){var t={xls:"biff8",htm:"html",slk:"sylk",socialcalc:"eth",Sh33tJS:"WTF"},r=e.file.slice(e.file.lastIndexOf(".")).toLowerCase();r.match(/^\.[a-z]+$/)&&(e.bookType=r.slice(1)),e.bookType=t[e.bookType]||e.bookType}}function HD(e,t,r){var n=r||{};return n.type="file",n.file=t,UD(n),$w(e,n)}function VD(e,t,r,n,i,o,a,s){var l=_t(r),u=s.defval,c=s.raw||!Object.prototype.hasOwnProperty.call(s,"raw"),f=!0,d=i===1?[]:{};if(i!==1)if(Object.defineProperty)try{Object.defineProperty(d,"__rowNum__",{value:r,enumerable:!1})}catch{d.__rowNum__=r}else d.__rowNum__=r;if(!a||e[r])for(var h=t.s.c;h<=t.e.c;++h){var m=a?e[r][h]:e[n[h]+l];if(m===void 0||m.t===void 0){if(u===void 0)continue;o[h]!=null&&(d[o[h]]=u);continue}var p=m.v;switch(m.t){case"z":if(p==null)break;continue;case"e":p=p==0?null:void 0;break;case"s":case"d":case"b":case"n":break;default:throw new Error("unrecognized type "+m.t)}if(o[h]!=null){if(p==null)if(m.t=="e"&&p===null)d[o[h]]=null;else if(u!==void 0)d[o[h]]=u;else if(c&&p===null)d[o[h]]=null;else continue;else d[o[h]]=c&&(m.t!=="n"||m.t==="n"&&s.rawNumbers!==!1)?p:rn(m,p,s);p!=null&&(f=!1)}}return{row:d,isempty:f}}function Gl(e,t){if(e==null||e["!ref"]==null)return[];var r={t:"n",v:0},n=0,i=1,o=[],a=0,s="",l={s:{r:0,c:0},e:{r:0,c:0}},u=t||{},c=u.range!=null?u.range:e["!ref"];switch(u.header===1?n=1:u.header==="A"?n=2:Array.isArray(u.header)?n=3:u.header==null&&(n=0),typeof c){case"string":l=Xe(c);break;case"number":l=Xe(e["!ref"]),l.s.r=c;break;default:l=c}n>0&&(i=0);var f=_t(l.s.r),d=[],h=[],m=0,p=0,g=Array.isArray(e),x=l.s.r,w=0,y={};g&&!e[x]&&(e[x]=[]);var _=u.skipHidden&&e["!cols"]||[],N=u.skipHidden&&e["!rows"]||[];for(w=l.s.c;w<=l.e.c;++w)if(!(_[w]||{}).hidden)switch(d[w]=Ft(w),r=g?e[x][w]:e[d[w]+f],n){case 1:o[w]=w-l.s.c;break;case 2:o[w]=d[w];break;case 3:o[w]=u.header[w-l.s.c];break;default:if(r==null&&(r={w:"__EMPTY",t:"s"}),s=a=rn(r,null,u),p=y[a]||0,!p)y[a]=1;else{do s=a+"_"+p++;while(y[s]);y[a]=p,y[s]=1}o[w]=s}for(x=l.s.r+i;x<=l.e.r;++x)if(!(N[x]||{}).hidden){var M=VD(e,l,x,d,n,o,g,u);(M.isempty===!1||(n===1?u.blankrows!==!1:u.blankrows))&&(h[m++]=M.row)}return h.length=m,h}var Zg=/"/g;function WD(e,t,r,n,i,o,a,s){for(var l=!0,u=[],c="",f=_t(r),d=t.s.c;d<=t.e.c;++d)if(n[d]){var h=s.dense?(e[r]||[])[d]:e[n[d]+f];if(h==null)c="";else if(h.v!=null){l=!1,c=""+(s.rawNumbers&&h.t=="n"?h.v:rn(h,null,s));for(var m=0,p=0;m!==c.length;++m)if((p=c.charCodeAt(m))===i||p===o||p===34||s.forceQuotes){c='"'+c.replace(Zg,'""')+'"';break}c=="ID"&&(c='"ID"')}else h.f!=null&&!h.F?(l=!1,c="="+h.f,c.indexOf(",")>=0&&(c='"'+c.replace(Zg,'""')+'"')):c="";u.push(c)}return s.blankrows===!1&&l?null:u.join(a)}function Gd(e,t){var r=[],n=t??{};if(e==null||e["!ref"]==null)return"";var i=Xe(e["!ref"]),o=n.FS!==void 0?n.FS:",",a=o.charCodeAt(0),s=n.RS!==void 0?n.RS:`
`,l=s.charCodeAt(0),u=new RegExp((o=="|"?"\\|":o)+"+$"),c="",f=[];n.dense=Array.isArray(e);for(var d=n.skipHidden&&e["!cols"]||[],h=n.skipHidden&&e["!rows"]||[],m=i.s.c;m<=i.e.c;++m)(d[m]||{}).hidden||(f[m]=Ft(m));for(var p=0,g=i.s.r;g<=i.e.r;++g)(h[g]||{}).hidden||(c=WD(e,i,g,f,a,l,o,n),c!=null&&(n.strip&&(c=c.replace(u,"")),(c||n.blankrows!==!1)&&r.push((p++?s:"")+c)));return delete n.dense,r.join("")}function Nw(e,t){t||(t={}),t.FS=" ",t.RS=`
-`;var r=Gd(e,t);return r}function zD(e){var t="",r,n="";if(e==null||e["!ref"]==null)return[];var i=Xe(e["!ref"]),o="",a=[],s,l=[],u=Array.isArray(e);for(s=i.s.c;s<=i.e.c;++s)a[s]=Ft(s);for(var c=i.s.r;c<=i.e.r;++c)for(o=_t(c),s=i.s.c;s<=i.e.c;++s)if(t=a[s]+o,r=u?(e[c]||[])[s]:e[t],n="",r!==void 0){if(r.F!=null){if(t=r.F,!r.f)continue;n=r.f,t.indexOf(":")==-1&&(t=t+":"+t)}if(r.f!=null)n=r.f;else{if(r.t=="z")continue;if(r.t=="n"&&r.v!=null)n=""+r.v;else if(r.t=="b")n=r.v?"TRUE":"FALSE";else if(r.w!==void 0)n="'"+r.w;else{if(r.v===void 0)continue;r.t=="s"?n="'"+r.v:n=""+r.v}}l[l.length]=t+"="+n}return l}function Mw(e,t,r){var n=r||{},i=+!n.skipHeader,o=e||{},a=0,s=0;if(o&&n.origin!=null)if(typeof n.origin=="number")a=n.origin;else{var l=typeof n.origin=="string"?dt(n.origin):n.origin;a=l.r,s=l.c}var u,c={s:{c:0,r:0},e:{c:s,r:a+t.length-1+i}};if(o["!ref"]){var f=Xe(o["!ref"]);c.e.c=Math.max(c.e.c,f.e.c),c.e.r=Math.max(c.e.r,f.e.r),a==-1&&(a=f.e.r+1,c.e.r=a+t.length-1+i)}else a==-1&&(a=0,c.e.r=t.length-1+i);var d=n.header||[],h=0;t.forEach(function(p,g){Tt(p).forEach(function(x){(h=d.indexOf(x))==-1&&(d[h=d.length]=x);var w=p[x],y="z",_="",N=Be({c:s+h,r:a+g+i});u=Ha(o,N),w&&typeof w=="object"&&!(w instanceof Date)?o[N]=w:(typeof w=="number"?y="n":typeof w=="boolean"?y="b":typeof w=="string"?y="s":w instanceof Date?(y="d",n.cellDates||(y="n",w=jt(w)),_=n.dateNF||tt[14]):w===null&&n.nullError&&(y="e",w=0),u?(u.t=y,u.v=w,delete u.w,delete u.R,_&&(u.z=_)):o[N]=u={t:y,v:w},_&&(u.z=_))})}),c.e.c=Math.max(c.e.c,s+d.length-1);var m=_t(a);if(i)for(h=0;h<d.length;++h)o[Ft(h+s)+m]={t:"s",v:d[h]};return o["!ref"]=it(c),o}function GD(e,t){return Mw(null,e,t)}function Ha(e,t,r){if(typeof t=="string"){if(Array.isArray(e)){var n=dt(t);return e[n.r]||(e[n.r]=[]),e[n.r][n.c]||(e[n.r][n.c]={t:"z"})}return e[t]||(e[t]={t:"z"})}return typeof t!="number"?Ha(e,Be(t)):Ha(e,Be({r:t,c:r||0}))}function jD(e,t){if(typeof t=="number"){if(t>=0&&e.SheetNames.length>t)return t;throw new Error("Cannot find sheet # "+t)}else if(typeof t=="string"){var r=e.SheetNames.indexOf(t);if(r>-1)return r;throw new Error("Cannot find sheet name |"+t+"|")}else throw new Error("Cannot find sheet |"+t+"|")}function XD(){return{SheetNames:[],Sheets:{}}}function KD(e,t,r,n){var i=1;if(!r)for(;i<=65535&&e.SheetNames.indexOf(r="Sheet"+i)!=-1;++i,r=void 0);if(!r||e.SheetNames.length>=65535)throw new Error("Too many worksheets");if(n&&e.SheetNames.indexOf(r)>=0){var o=r.match(/(^.*?)(\d+)$/);i=o&&+o[2]||0;var a=o&&o[1]||r;for(++i;i<=65535&&e.SheetNames.indexOf(r=a+i)!=-1;++i);}if(Aw(r),e.SheetNames.indexOf(r)>=0)throw new Error("Worksheet with name |"+r+"| already exists!");return e.SheetNames.push(r),e.Sheets[r]=t,r}function YD(e,t,r){e.Workbook||(e.Workbook={}),e.Workbook.Sheets||(e.Workbook.Sheets=[]);var n=jD(e,t);switch(e.Workbook.Sheets[n]||(e.Workbook.Sheets[n]={}),r){case 0:case 1:case 2:break;default:throw new Error("Bad sheet visibility setting "+r)}e.Workbook.Sheets[n].Hidden=r}function qD(e,t){return e.z=t,e}function Lw(e,t,r){return t?(e.l={Target:t},r&&(e.l.Tooltip=r)):delete e.l,e}function QD(e,t,r){return Lw(e,"#"+t,r)}function ZD(e,t,r){e.c||(e.c=[]),e.c.push({t,a:r||"SheetJS"})}function JD(e,t,r,n){for(var i=typeof t!="string"?t:Xe(t),o=typeof t=="string"?t:it(t),a=i.s.r;a<=i.e.r;++a)for(var s=i.s.c;s<=i.e.c;++s){var l=Ha(e,a,s);l.t="n",l.F=o,delete l.v,a==i.s.r&&s==i.s.c&&(l.f=r,n&&(l.D=!0))}return e}var bc={encode_col:Ft,encode_row:_t,encode_cell:Be,encode_range:it,decode_col:kd,decode_row:bd,split_cell:h3,decode_cell:dt,decode_range:Jt,format_cell:rn,sheet_add_aoa:Lx,sheet_add_json:Mw,sheet_add_dom:Pw,aoa_to_sheet:To,json_to_sheet:GD,table_to_sheet:Iw,table_to_book:_D,sheet_to_csv:Gd,sheet_to_txt:Nw,sheet_to_json:Gl,sheet_to_html:Dw,sheet_to_formulae:zD,sheet_to_row_object_array:Gl,sheet_get_cell:Ha,book_new:XD,book_append_sheet:KD,book_set_sheet_visibility:YD,cell_set_number_format:qD,cell_set_hyperlink:Lw,cell_set_internal_link:QD,cell_add_comment:ZD,sheet_set_array_formula:JD,consts:{SHEET_VISIBLE:0,SHEET_HIDDEN:1,SHEET_VERY_HIDDEN:2}};function eP(e){if(e%1!==0){const t=Math.max(2,e.toString().split(".")[1].length),r=Math.min(4,t);if(e<1e3)return e.toFixed(r)||0}if(e>1e3){const t=Math.min(4,Math.floor(Math.log10(Math.abs(e))/3)),r=["","K","M","B","T"][t];return`${(e/10**(t*3)).toFixed(2)} ${r}`}return e}function jd(e){return["date","day","time","timestamp","year"].some(t=>e.toLowerCase().includes(t))}function zi(e,t){const r=window.document.getElementById("loading"),n=window.document.getElementById("loading_text");return new Promise(i=>{t?r.classList.remove("show"):(n.innerHTML=e,r.classList.add("show"));let o=setInterval(function(){(t?!r.classList.contains("show"):r.classList.contains("show"))&&(clearInterval(o),i(!0))},.01)})}function tP(e,t){if(e===t)return!0;if(e==null||t==null||e.length!==t.length)return!1;for(var r=0;r<e.length;++r)if(e[r]!==t[r])return!1;return!0}const rP=(e,t,r,n)=>{const i=r4(e.getValue(t),r);return n(i),i},nP=async({fileHandle:e,blob:t})=>{e&&await iP({fileHandle:e,blob:t})},iP=async({fileHandle:e,blob:t})=>{const r=await e.createWritable();await r.write(t),await r.close()},oP=[{description:"PNG Image",accept:{"image/png":[".png"]}},{description:"JPEG Image",accept:{"image/jpeg":[".jpeg"]}}],Bw=({filename:e,is_image:t})=>{if("showSaveFilePicker"in window){const r={suggestedName:e,types:t?oP:[{description:"CSV File",accept:{"image/csv":[".csv"]}}],excludeAcceptAllOption:!0};return showSaveFilePicker(r)}return new Promise(r=>{r(null)})},Uw=(e,t,r)=>{try{if(r===null)throw new Error("Cannot access filesystem");nP({fileHandle:r,blob:e})}catch{const i=URL.createObjectURL(e),o=document.createElement("a");o.setAttribute("href",i),o.setAttribute("download",t),o.style.visibility="hidden",document.body.appendChild(o),o.click(),document.body.removeChild(o)}return new Promise(n=>{n(!0)})};async function Jg(e,t,r,n){const i=t,o=r.map(u=>i.map(c=>u[c])),a=[i,...o];if(e==="csv"){const u=a.map(d=>d.join(",")).join(`
+`;var r=Gd(e,t);return r}function zD(e){var t="",r,n="";if(e==null||e["!ref"]==null)return[];var i=Xe(e["!ref"]),o="",a=[],s,l=[],u=Array.isArray(e);for(s=i.s.c;s<=i.e.c;++s)a[s]=Ft(s);for(var c=i.s.r;c<=i.e.r;++c)for(o=_t(c),s=i.s.c;s<=i.e.c;++s)if(t=a[s]+o,r=u?(e[c]||[])[s]:e[t],n="",r!==void 0){if(r.F!=null){if(t=r.F,!r.f)continue;n=r.f,t.indexOf(":")==-1&&(t=t+":"+t)}if(r.f!=null)n=r.f;else{if(r.t=="z")continue;if(r.t=="n"&&r.v!=null)n=""+r.v;else if(r.t=="b")n=r.v?"TRUE":"FALSE";else if(r.w!==void 0)n="'"+r.w;else{if(r.v===void 0)continue;r.t=="s"?n="'"+r.v:n=""+r.v}}l[l.length]=t+"="+n}return l}function Mw(e,t,r){var n=r||{},i=+!n.skipHeader,o=e||{},a=0,s=0;if(o&&n.origin!=null)if(typeof n.origin=="number")a=n.origin;else{var l=typeof n.origin=="string"?dt(n.origin):n.origin;a=l.r,s=l.c}var u,c={s:{c:0,r:0},e:{c:s,r:a+t.length-1+i}};if(o["!ref"]){var f=Xe(o["!ref"]);c.e.c=Math.max(c.e.c,f.e.c),c.e.r=Math.max(c.e.r,f.e.r),a==-1&&(a=f.e.r+1,c.e.r=a+t.length-1+i)}else a==-1&&(a=0,c.e.r=t.length-1+i);var d=n.header||[],h=0;t.forEach(function(p,g){Tt(p).forEach(function(x){(h=d.indexOf(x))==-1&&(d[h=d.length]=x);var w=p[x],y="z",_="",N=Be({c:s+h,r:a+g+i});u=Ha(o,N),w&&typeof w=="object"&&!(w instanceof Date)?o[N]=w:(typeof w=="number"?y="n":typeof w=="boolean"?y="b":typeof w=="string"?y="s":w instanceof Date?(y="d",n.cellDates||(y="n",w=jt(w)),_=n.dateNF||tt[14]):w===null&&n.nullError&&(y="e",w=0),u?(u.t=y,u.v=w,delete u.w,delete u.R,_&&(u.z=_)):o[N]=u={t:y,v:w},_&&(u.z=_))})}),c.e.c=Math.max(c.e.c,s+d.length-1);var m=_t(a);if(i)for(h=0;h<d.length;++h)o[Ft(h+s)+m]={t:"s",v:d[h]};return o["!ref"]=it(c),o}function GD(e,t){return Mw(null,e,t)}function Ha(e,t,r){if(typeof t=="string"){if(Array.isArray(e)){var n=dt(t);return e[n.r]||(e[n.r]=[]),e[n.r][n.c]||(e[n.r][n.c]={t:"z"})}return e[t]||(e[t]={t:"z"})}return typeof t!="number"?Ha(e,Be(t)):Ha(e,Be({r:t,c:r||0}))}function jD(e,t){if(typeof t=="number"){if(t>=0&&e.SheetNames.length>t)return t;throw new Error("Cannot find sheet # "+t)}else if(typeof t=="string"){var r=e.SheetNames.indexOf(t);if(r>-1)return r;throw new Error("Cannot find sheet name |"+t+"|")}else throw new Error("Cannot find sheet |"+t+"|")}function XD(){return{SheetNames:[],Sheets:{}}}function KD(e,t,r,n){var i=1;if(!r)for(;i<=65535&&e.SheetNames.indexOf(r="Sheet"+i)!=-1;++i,r=void 0);if(!r||e.SheetNames.length>=65535)throw new Error("Too many worksheets");if(n&&e.SheetNames.indexOf(r)>=0){var o=r.match(/(^.*?)(\d+)$/);i=o&&+o[2]||0;var a=o&&o[1]||r;for(++i;i<=65535&&e.SheetNames.indexOf(r=a+i)!=-1;++i);}if(Aw(r),e.SheetNames.indexOf(r)>=0)throw new Error("Worksheet with name |"+r+"| already exists!");return e.SheetNames.push(r),e.Sheets[r]=t,r}function YD(e,t,r){e.Workbook||(e.Workbook={}),e.Workbook.Sheets||(e.Workbook.Sheets=[]);var n=jD(e,t);switch(e.Workbook.Sheets[n]||(e.Workbook.Sheets[n]={}),r){case 0:case 1:case 2:break;default:throw new Error("Bad sheet visibility setting "+r)}e.Workbook.Sheets[n].Hidden=r}function qD(e,t){return e.z=t,e}function Lw(e,t,r){return t?(e.l={Target:t},r&&(e.l.Tooltip=r)):delete e.l,e}function QD(e,t,r){return Lw(e,"#"+t,r)}function ZD(e,t,r){e.c||(e.c=[]),e.c.push({t,a:r||"SheetJS"})}function JD(e,t,r,n){for(var i=typeof t!="string"?t:Xe(t),o=typeof t=="string"?t:it(t),a=i.s.r;a<=i.e.r;++a)for(var s=i.s.c;s<=i.e.c;++s){var l=Ha(e,a,s);l.t="n",l.F=o,delete l.v,a==i.s.r&&s==i.s.c&&(l.f=r,n&&(l.D=!0))}return e}var bc={encode_col:Ft,encode_row:_t,encode_cell:Be,encode_range:it,decode_col:kd,decode_row:bd,split_cell:h3,decode_cell:dt,decode_range:Jt,format_cell:rn,sheet_add_aoa:Lx,sheet_add_json:Mw,sheet_add_dom:Pw,aoa_to_sheet:To,json_to_sheet:GD,table_to_sheet:Iw,table_to_book:_D,sheet_to_csv:Gd,sheet_to_txt:Nw,sheet_to_json:Gl,sheet_to_html:Dw,sheet_to_formulae:zD,sheet_to_row_object_array:Gl,sheet_get_cell:Ha,book_new:XD,book_append_sheet:KD,book_set_sheet_visibility:YD,cell_set_number_format:qD,cell_set_hyperlink:Lw,cell_set_internal_link:QD,cell_add_comment:ZD,sheet_set_array_formula:JD,consts:{SHEET_VISIBLE:0,SHEET_HIDDEN:1,SHEET_VERY_HIDDEN:2}};function eP(e){if(e%1!==0){const t=Math.max(2,e.toString().split(".")[1].length),r=Math.min(4,t);if(e<1e3)return e.toFixed(r)||0}if(e>1e4){const t=Math.min(4,Math.floor(Math.log10(Math.abs(e))/3)),r=["","K","M","B","T"][t];return`${(e/10**(t*3)).toFixed(2)} ${r}`}return e}function jd(e){return["date","day","time","timestamp","year"].some(t=>e.toLowerCase().includes(t))}function zi(e,t){const r=window.document.getElementById("loading"),n=window.document.getElementById("loading_text");return new Promise(i=>{t?r.classList.remove("show"):(n.innerHTML=e,r.classList.add("show"));let o=setInterval(function(){(t?!r.classList.contains("show"):r.classList.contains("show"))&&(clearInterval(o),i(!0))},.01)})}function tP(e,t){if(e===t)return!0;if(e==null||t==null||e.length!==t.length)return!1;for(var r=0;r<e.length;++r)if(e[r]!==t[r])return!1;return!0}const rP=(e,t,r,n)=>{const i=r4(e.getValue(t),r);return n(i),i},nP=async({fileHandle:e,blob:t})=>{e&&await iP({fileHandle:e,blob:t})},iP=async({fileHandle:e,blob:t})=>{const r=await e.createWritable();await r.write(t),await r.close()},oP=[{description:"PNG Image",accept:{"image/png":[".png"]}},{description:"JPEG Image",accept:{"image/jpeg":[".jpeg"]}}],Bw=({filename:e,is_image:t})=>{if("showSaveFilePicker"in window){const r={suggestedName:e,types:t?oP:[{description:"CSV File",accept:{"image/csv":[".csv"]}}],excludeAcceptAllOption:!0};return showSaveFilePicker(r)}return new Promise(r=>{r(null)})},Uw=(e,t,r)=>{try{if(r===null)throw new Error("Cannot access filesystem");nP({fileHandle:r,blob:e})}catch{const i=URL.createObjectURL(e),o=document.createElement("a");o.setAttribute("href",i),o.setAttribute("download",t),o.style.visibility="hidden",document.body.appendChild(o),o.click(),document.body.removeChild(o)}return new Promise(n=>{n(!0)})};async function Jg(e,t,r,n){const i=t,o=r.map(u=>i.map(c=>u[c])),a=[i,...o];if(e==="csv"){const u=a.map(d=>d.join(",")).join(`
`),c=new Blob([u],{type:"text/csv;charset=utf-8;"}),f=`${window.title}.csv`;try{let d=await Bw({filename:f}),h="csv";d!==null&&(h=d.name.split(".").pop()),await zi(`Saving ${h.toUpperCase()}`),Yf(async function(){Uw(c,f,d).then(async function(){await new Promise(m=>setTimeout(m,1500)),d||n(!0),await zi("",!0)})},2)()}catch(d){console.error(d)}return}const s=bc.book_new(),l=bc.aoa_to_sheet(a);bc.book_append_sheet(s,l,"Sheet1"),await zi("Saving XLSX"),Yf(async function(){await new Promise(u=>setTimeout(u,1500)),HD(s,`${window.title}.xlsx`),await zi("",!0),n&&n(!0)},2)()}async function aP(e,t){const r=document.getElementById(e),n=`${window.title}.png`;try{let i=await Bw({filename:n,is_image:!0}),o="png";i!==null&&(o=i.name.split(".").pop()),await zi(`Saving ${o.toUpperCase()}`),Yf(async function(){u4.toBlob(r).then(function(a){Uw(a,n,i).then(async function(){await new Promise(s=>setTimeout(s,1500)),i||t(!0),await zi("",!0)})})},2)()}catch(i){console.error(i)}}const Yf=(e,t)=>{let r;return function(){const n=this,i=arguments;clearTimeout(r),r=setTimeout(()=>e.apply(n,i),t)}},Hw=v.createContext({dragDropManager:void 0});function rr(e){return"Minified Redux error #"+e+"; visit https://redux.js.org/Errors?code="+e+" for the full message or use the non-minified dev environment for full errors. "}var e1=function(){return typeof Symbol=="function"&&Symbol.observable||"@@observable"}(),kc=function(){return Math.random().toString(36).substring(7).split("").join(".")},t1={INIT:"@@redux/INIT"+kc(),REPLACE:"@@redux/REPLACE"+kc(),PROBE_UNKNOWN_ACTION:function(){return"@@redux/PROBE_UNKNOWN_ACTION"+kc()}};function sP(e){if(typeof e!="object"||e===null)return!1;for(var t=e;Object.getPrototypeOf(t)!==null;)t=Object.getPrototypeOf(t);return Object.getPrototypeOf(e)===t}function Vw(e,t,r){var n;if(typeof t=="function"&&typeof r=="function"||typeof r=="function"&&typeof arguments[3]=="function")throw new Error(rr(0));if(typeof t=="function"&&typeof r>"u"&&(r=t,t=void 0),typeof r<"u"){if(typeof r!="function")throw new Error(rr(1));return r(Vw)(e,t)}if(typeof e!="function")throw new Error(rr(2));var i=e,o=t,a=[],s=a,l=!1;function u(){s===a&&(s=a.slice())}function c(){if(l)throw new Error(rr(3));return o}function f(p){if(typeof p!="function")throw new Error(rr(4));if(l)throw new Error(rr(5));var g=!0;return u(),s.push(p),function(){if(g){if(l)throw new Error(rr(6));g=!1,u();var w=s.indexOf(p);s.splice(w,1),a=null}}}function d(p){if(!sP(p))throw new Error(rr(7));if(typeof p.type>"u")throw new Error(rr(8));if(l)throw new Error(rr(9));try{l=!0,o=i(o,p)}finally{l=!1}for(var g=a=s,x=0;x<g.length;x++){var w=g[x];w()}return p}function h(p){if(typeof p!="function")throw new Error(rr(10));i=p,d({type:t1.REPLACE})}function m(){var p,g=f;return p={subscribe:function(w){if(typeof w!="object"||w===null)throw new Error(rr(11));function y(){w.next&&w.next(c())}y();var _=g(y);return{unsubscribe:_}}},p[e1]=function(){return this},p}return d({type:t1.INIT}),n={dispatch:d,subscribe:f,getState:c,replaceReducer:h},n[e1]=m,n}function Fe(e,t,...r){if(lP()&&t===void 0)throw new Error("invariant requires an error message argument");if(!e){let n;if(t===void 0)n=new Error("Minified exception occurred; use the non-minified dev environment for the full error message and additional helpful warnings.");else{let i=0;n=new Error(t.replace(/%s/g,function(){return r[i++]})),n.name="Invariant Violation"}throw n.framesToPop=1,n}}function lP(){return typeof process<"u"&&process.env.NODE_ENV==="production"}function uP(e,t,r){return t.split(".").reduce((n,i)=>n&&n[i]?n[i]:r||null,e)}function cP(e,t){return e.filter(r=>r!==t)}function Ww(e){return typeof e=="object"}function fP(e,t){const r=new Map,n=o=>{r.set(o,r.has(o)?r.get(o)+1:1)};e.forEach(n),t.forEach(n);const i=[];return r.forEach((o,a)=>{o===1&&i.push(a)}),i}function dP(e,t){return e.filter(r=>t.indexOf(r)>-1)}const Xd="dnd-core/INIT_COORDS",Ru="dnd-core/BEGIN_DRAG",Kd="dnd-core/PUBLISH_DRAG_SOURCE",Ou="dnd-core/HOVER",Fu="dnd-core/DROP",Du="dnd-core/END_DRAG";function r1(e,t){return{type:Xd,payload:{sourceClientOffset:t||null,clientOffset:e||null}}}const hP={type:Xd,payload:{clientOffset:null,sourceClientOffset:null}};function pP(e){return function(r=[],n={publishSource:!0}){const{publishSource:i=!0,clientOffset:o,getSourceClientOffset:a}=n,s=e.getMonitor(),l=e.getRegistry();e.dispatch(r1(o)),gP(r,s,l);const u=xP(r,s);if(u==null){e.dispatch(hP);return}let c=null;if(o){if(!a)throw new Error("getSourceClientOffset must be defined");mP(a),c=a(u)}e.dispatch(r1(o,c));const d=l.getSource(u).beginDrag(s,u);if(d==null)return;vP(d),l.pinSource(u);const h=l.getSourceType(u);return{type:Ru,payload:{itemType:h,item:d,sourceId:u,clientOffset:o||null,sourceClientOffset:c||null,isSourcePublic:!!i}}}}function gP(e,t,r){Fe(!t.isDragging(),"Cannot call beginDrag while dragging."),e.forEach(function(n){Fe(r.getSource(n),"Expected sourceIds to be registered.")})}function mP(e){Fe(typeof e=="function","When clientOffset is provided, getSourceClientOffset must be a function.")}function vP(e){Fe(Ww(e),"Item must be an object.")}function xP(e,t){let r=null;for(let n=e.length-1;n>=0;n--)if(t.canDragSource(e[n])){r=e[n];break}return r}function wP(e,t,r){return t in e?Object.defineProperty(e,t,{value:r,enumerable:!0,configurable:!0,writable:!0}):e[t]=r,e}function yP(e){for(var t=1;t<arguments.length;t++){var r=arguments[t]!=null?arguments[t]:{},n=Object.keys(r);typeof Object.getOwnPropertySymbols=="function"&&(n=n.concat(Object.getOwnPropertySymbols(r).filter(function(i){return Object.getOwnPropertyDescriptor(r,i).enumerable}))),n.forEach(function(i){wP(e,i,r[i])})}return e}function EP(e){return function(r={}){const n=e.getMonitor(),i=e.getRegistry();_P(n),CP(n).forEach((a,s)=>{const l=SP(a,s,i,n),u={type:Fu,payload:{dropResult:yP({},r,l)}};e.dispatch(u)})}}function _P(e){Fe(e.isDragging(),"Cannot call drop while not dragging."),Fe(!e.didDrop(),"Cannot call drop twice during one drag operation.")}function SP(e,t,r,n){const i=r.getTarget(e);let o=i?i.drop(n,e):void 0;return TP(o),typeof o>"u"&&(o=t===0?{}:n.getDropResult()),o}function TP(e){Fe(typeof e>"u"||Ww(e),"Drop result must either be an object or undefined.")}function CP(e){const t=e.getTargetIds().filter(e.canDropOnTarget,e);return t.reverse(),t}function AP(e){return function(){const r=e.getMonitor(),n=e.getRegistry();RP(r);const i=r.getSourceId();return i!=null&&(n.getSource(i,!0).endDrag(r,i),n.unpinSource()),{type:Du}}}function RP(e){Fe(e.isDragging(),"Cannot call endDrag while not dragging.")}function qf(e,t){return t===null?e===null:Array.isArray(e)?e.some(r=>r===t):e===t}function OP(e){return function(r,{clientOffset:n}={}){FP(r);const i=r.slice(0),o=e.getMonitor(),a=e.getRegistry(),s=o.getItemType();return PP(i,a,s),DP(i,o,a),IP(i,o,a),{type:Ou,payload:{targetIds:i,clientOffset:n||null}}}}function FP(e){Fe(Array.isArray(e),"Expected targetIds to be an array.")}function DP(e,t,r){Fe(t.isDragging(),"Cannot call hover while not dragging."),Fe(!t.didDrop(),"Cannot call hover after drop.");for(let n=0;n<e.length;n++){const i=e[n];Fe(e.lastIndexOf(i)===n,"Expected targetIds to be unique in the passed array.");co