1"use strict";(self.webpackChunk_N_E=self.webpackChunk_N_E||[]).push([[14727],{7855:(e,t,n)=>{n.d(t,{DZ:()=>s,FM:()=>x,Ly:()=>M,N6:()=>i,U0:()=>f,WD:()=>o,ZV:()=>w,d9:()=>r,kT:()=>k,ln:()=>y,nO:()=>c,oJ:()=>h,pP:()=>v,rd:()=>u,sK:()=>S,wl:()=>l,xj:()=>T,zi:()=>C});let r={0:"General",1:"0",2:"0.00",3:"#,##0",4:"#,##0.00",9:"0%",10:"0.00%",11:"0.00E+00",12:"# ?/?",13:"# ??/??",14:"m/d/yyyy",15:"d-mmm-yy",16:"d-mmm",17:"mmm-yy",18:"h:mm AM/PM",19:"h:mm:ss AM/PM",20:"h:mm",21:"h:mm:ss",22:"m/d/yy h:mm",37:"#,##0 ;(#,##0)",38:"#,##0 ;(#,##0)",39:"#,##0.00;(#,##0.00)",40:"#,##0.00;(#,##0.00)",45:"mm:ss",46:"[h]:mm:ss",47:"mm:ss.0",48:"##0.0E+0",49:"@"},i=/^#(DIV\/0!|N\/A|NAME\?|NULL!|NUM!|REF!|VALUE!|SPILL!|CALC!|GETTING_DATA)$/,a="#NUM!",l=e=>String(e).padStart(2,"0");function s(e){return e.replace(/\u0000/g,"").replace(/\r\n?/g,"\n")}function o(e){if(!Number.isSafeInteger(e)||e<0)return"#REF!";let t=e+1,n="";for(;t>0;)n=String.fromCharCode(65+(t-1)%26)+n,t=Math.floor((t-1)/26);return n}function u(e){let t=/^([A-Za-z]+)(\d+)$/.exec(e),n=t?.[1],r=t?.[2];if(!n||!r)return null;let i=0;for(let e of n.toUpperCase())i=26*i+(e.charCodeAt(0)-64);let a=Number(r);return Number.isSafeInteger(i)&&Number.isSafeInteger(a)&&!(a<1)?{c:i-1,r:a-1}:null}function c(e){let t=[],n="",r=0;for(;r<e.length;){let i=e[r];if(void 0===i)break;if('"'===i){let t=e.indexOf('"',r+1),i=t<0?e.length-1:t;n+=e.slice(r,i+1),r=i+1;continue}if("["===i){let t=e.indexOf("]",r+1),i=t<0?e.length-1:t;n+=e.slice(r,i+1),r=i+1;continue}if("\\"===i){n+=e.slice(r,r+2),r+=2;continue}if(";"===i){t.push(n),n="",r++;continue}n+=i,r++}return t.push(n),t}function m(e){let t="",n=0;for(;n<e.length;){let r=e[n];if(void 0===r)break;if('"'===r){let t=e.indexOf('"',n+1);n=(t<0?e.length:t)+1;continue}if("["===r){let t=e.indexOf("]",n+1);n=(t<0?e.length:t)+1;continue}if("\\"===r||"_"===r||"*"===r){n+=2;continue}t+=r,n++}return t}function h(e){let t=e.trim();return!(""===t||/^general$/i.test(t))&&"@"!==t&&/[ymdhs]/i.test(m(t))}let d=/\[\s*(?:h+|m+|s+)\s*\]/i;function f(e){let t=c(e)[0]??e;if(!h(t))return null;if(d.test(t))return"duration";let n=m(t),r=/[yd]/i.test(n),i=/[hs]/i.test(n);return r&&i?"datetime":i&&!r?"time":"date"}let p=["January","February","March","April","May","June","July","August","September","October","November","December"],$=["Sunday","Monday","Tuesday","Wednesday","Thursday","Friday","Saturday"];function g(e,t){return new Date(Math.round(((t?e+1462:e<61?e+1:e)-25569)*864e5))}let b=/^(yyyy|yyy|yy|y|mmmmm|mmmm|mmm|mm|m|dddd|ddd|dd|d|hh|h|ss|s|am\/pm|a\/p|\.0+)/i;function x(e,t,n){let r=g(e,n);if(Number.isNaN(r.getTime()))return String(e);let i=function(e){let t=[],n=0;for(;n<e.length;){let r=e[n];if(void 0===r)break;if('"'===r){let r=e.indexOf('"',n+1),i=r<0?e.length:r;t.push({lit:!0,v:e.slice(n+1,i)}),n=i+1;continue}if("["===r){let t=e.indexOf("]",n+1);n=(t<0?e.length:t)+1;continue}if("\\"===r){let r=e[n+1];void 0!==r&&t.push({lit:!0,v:r}),n+=2;continue}if("_"===r){t.push({lit:!0,v:" "}),n+=2;continue}if("*"===r){n+=2;continue}let i=b.exec(e.slice(n))?.[1];if(i){t.push({lit:!1,v:i.toLowerCase()}),n+=i.length;continue}t.push({lit:!0,v:r}),n++}return t}(t),a=i.some(e=>!e.lit&&("am/pm"===e.v||"a/p"===e.v)),s=new Set;for(let e=0;e<i.length;e++){let t=i[e];if(!t||t.lit||"m"!==t.v&&"mm"!==t.v)continue;let n=null;for(let t=e-1;t>=0;t--){let e=i[t];if(e&&!e.lit){n=e.v;break}}let r=null;for(let t=e+1;t<i.length;t++){let e=i[t];if(e&&!e.lit){r=e.v;break}}("h"===n||"hh"===n||"s"===r||"ss"===r)&&s.add(e)}let o=r.getUTCHours(),u=a?o%12||12:o,c=p[r.getUTCMonth()]??"",m=$[r.getUTCDay()]??"",h="";for(let e=0;e<i.length;e++){let t=i[e];if(t){if(t.lit){h+=t.v;continue}switch(t.v){case"yyyy":case"yyy":h+=String(r.getUTCFullYear());break;case"yy":case"y":h+=l(r.getUTCFullYear()%100);break;case"mmmmm":h+=c.charAt(0);break;case"mmmm":h+=c;break;case"mmm":h+=c.slice(0,3);break;case"mm":h+=s.has(e)?l(r.getUTCMinutes()):l(r.getUTCMonth()+1);break;case"m":h+=s.has(e)?String(r.getUTCMinutes()):String(r.getUTCMonth()+1);break;case"dddd":h+=m;break;case"ddd":h+=m.slice(0,3);break;case"dd":h+=l(r.getUTCDate());break;case"d":h+=String(r.getUTCDate());break;case"hh":h+=l(u);break;case"h":h+=String(u);break;case"ss":h+=l(r.getUTCSeconds());break;case"s":h+=String(r.getUTCSeconds());break;case"am/pm":h+=o<12?"AM":"PM";break;case"a/p":h+=o<12?"A":"P";break;default:if(t.v.startsWith(".")){let e=t.v.length-1;h+=(r.getUTCMilliseconds()/1e3).toFixed(e).slice(1)}}}}return h}function k(e,t){if(!Number.isFinite(e))return a;let n="",r="",i="",l=!1,s=0,o=0,u=e=>{l?r+=e:n+=e};for(;o<t.length;){let e=t[o];if(void 0===e)break;if('"'===e){let e=t.indexOf('"',o+1),n=e<0?t.length:e;u(t.slice(o+1,n)),o=n+1;continue}if("["===e){var c;let e=t.indexOf("]",o+1),n=e<0?t.length:e;u((c=t.slice(o,n+1),/^\[\$([^\]-]*)(?:-[^\]]*)?\]$/.exec(c)?.[1]??"")),o=n+1;continue}if("\\"===e){let e=t[o+1];void 0!==e&&u(e),o+=2;continue}if("_"===e){u(" "),o+=2;continue}if("*"===e){o+=2;continue}if("%"===e){s++,u("%"),o++;continue}if("#"===e||"0"===e||"?"===e){l=!0,i+=e,o++;continue}if((","===e||"."===e)&&l){if(""===r){i+=e,o++;continue}u(e),o++;continue}u(e),o++}if(""===i)return n+r;let m=Math.abs(e)*Math.pow(100,s),h=0;for(;i.endsWith(",");)h++,i=i.slice(0,-1);h>0&&(m/=Math.pow(1e3,h));let d=i.indexOf("."),f=d<0?i:i.slice(0,d),p=d<0?"":i.slice(d+1).replace(/[^#0?]/g,""),$=f.includes(","),g=(f.match(/0/g)||[]).length,b=Math.min(20,p.length),x=(function(e,t){if(1e21>Math.abs(e))return e.toFixed(t);let n=BigInt(Math.trunc(e)).toString();return t>0?`${n}.${"0".repeat(t)}`:n})(m,b).split("."),k=x[0]??"0",y=x[1]??"";if(y){let e=y.length;for(;e>0&&"0"===y[e-1]&&"0"!==p[e-1];)e--;y=y.slice(0,e)}k.length<g&&(k=k.padStart(g,"0")),0===g&&"0"===k&&b>0&&(k=""),$&&(k=function(e){let t="";for(let n=0;n<e.length;n++){let r=e.length-n;t+=e[n]??"",r>
11&&(r-1)%3==0&&(t+=",")}return t}(k));let w=y?`${k}.${y}`:k;return n+w+r}function y(e){if(!Number.isFinite(e))return String(e);if(0===e)return"0";let t=Math.abs(e);return t>=1e11||t<1e-9?e.toExponential(5).replace(/\.?0+e/,"e").replace("e","E"):String(Number(e.toPrecision(11)))}function w(e,t){if(!Number.isFinite(e))return a;if(/^general$/i.test(t.trim())||""===t.trim()||"@"===t.trim())return y(e);let n=c(t),r=n[1];if(e<0&&void 0!==r)return k(e,r);let i=n[2];if(0===e&&void 0!==i)return k(e,i);let l=k(e,n[0]??t);return e<0?`-${l}`:l}function T(e,t){let n=Number.isInteger(t)&&t>0?Math.min(t,400):0,r=/^([-+]?)(\d*)(?:\.(\d*))?$/.exec(e.trim());if(!r)return e;let i="-"===r[1]?"-":"",a=r[2]??"",l=r[3]??"";for(let e=0;e<n;e++){let e=l.charAt(0);a+=""===e?"0":e,l=l.slice(1)}return a=a.replace(/^0+(?=\d)/,""),l=l.replace(/0+$/,""),`${i}${""===a?"0":a}${""===l?"":`.${l}`}`}function v(e){let t=c(e)[0]??e,n=0;for(;n<t.length;){let e=t[n];if(void 0===e)break;if('"'===e){let e=t.indexOf('"',n+1);n=(e<0?t.length:e)+1;continue}if("["===e){let e=t.indexOf("]",n+1);n=(e<0?t.length:e)+1;continue}if("\\"===e){n+=2;continue}if("%"===e)return!0;n++}return!1}function M(e){let t=Math.round(86400*e)%86400,n=Math.floor(t/3600),r=Math.floor((t-3600*n)/60);return`${l(n)}:${l(r)}:${l(t-3600*n-60*r)}`}function S(e,t){let n=g(e,t);if(Number.isNaN(n.getTime()))return String(e);let r=`${n.getUTCFullYear()}-${l(n.getUTCMonth()+1)}-${l(n.getUTCDate())}`;return e-Math.floor(e)<1e-9?r:`${r} ${l(n.getUTCHours())}:${l(n.getUTCMinutes())}:${l(n.getUTCSeconds())}`}function C(e,t,n){let r=g(e,n);if(Number.isNaN(r.getTime()))return String(e);let i=`${r.getUTCFullYear()}-${l(r.getUTCMonth()+1)}-${l(r.getUTCDate())}`,a=`${l(r.getUTCHours())}:${l(r.getUTCMinutes())}:${l(r.getUTCSeconds())}`;return"time"===t?a:"datetime"===t?`${i}T${a}`:i}},14727:(e,t,n)=>{n.d(t,{I$:()=>M,PX:()=>A,Pk:()=>y,UM:()=>C,X1:()=>u,_5:()=>d,dc:()=>c,ir:()=>h,j7:()=>b,lg:()=>o,lp:()=>x,nr:()=>S,y$:()=>s});var r=n(21530),i=n(7855);let a=/[\p{L}_]/u,l=/[\p{L}\p{N}\p{M}._·-]/u;function s(e,t){let n=e.replace(/\s+/g," ").trim();if(""===n)return{name:t,reason:"the header is blank"};let r=[],i="",s=0,o=0;for(let e of n){if(l.test(e)){i+=e;continue}if(":"===e){i+="_",o++;continue}i+="_",s++}o>0&&r.push("a colon in an XML name means a namespace prefix"),s>0&&r.push(`${s} character${1===s?"":"s"} an XML name cannot hold became underscores`);let u=i.charAt(0);return(""!==u&&a.test(u)||(i=`_${i}`,r.push("an XML name cannot start with a digit, a dot or a hyphen")),/^xml/i.test(i)&&(i=`_${i}`,r.push("names beginning with the letters xml are reserved by the spec")),""===i)?{name:t,reason:"nothing legal was left of the header"}:{name:i,reason:i===n?"":r.join(", ")}}function o(e){let t="",n=0;for(let r=0;r<e.length;r++){let i=e.charCodeAt(r),a=e.charAt(r);if(9===i||10===i||13===i){t+=a;continue}if(i<32){n++;continue}if(i>=55296&&i<=56319){let i=e.charCodeAt(r+1);if(i>=56320&&i<=57343){t+=a+e.charAt(r+1),r++;continue}n++;continue}if(i>=56320&&i<=57343||65534===i||65535===i){n++;continue}t+=a}return{text:t,removed:n}}function u(e){return e.replace(/&/g,"&").replace(/</g,"<").replace(/>/g,">").replace(/\r/g," ")}function c(e){return u(e).replace(/"/g,""").replace(/\n/g," ").replace(/\t/g,"	")}function m(e){return c(o(e).text)}let h={string:"xs:string",integer:"xs:integer",decimal:"xs:decimal",double:"xs:double",boolean:"xs:boolean",date:"xs:date",dateTime:"xs:dateTime",time:"xs:time",duration:"xs:duration"},d=["string","integer","decimal","double","boolean","date","dateTime","time","duration"];function f(e){if(!e)return"blank";if("error"===e.kind)return"error";if("bool"===e.kind)return"boolean";if("date"===e.kind){let t=e.dateKind??"date";return"datetime"===t?"dateTime":"time"===t?"time":"duration"===t?"duration":"date"}if("number"===e.kind){let t=(0,r.V)(e).trim();return/[eE]/.test(t)?"double":/^[-+]?\d+$/.test(t)?"integer":"decimal"}return""===e.shown.trim()?"blank":"string"}let p={text:"",kind:"blank",note:""};function $(e){return{text:e.shown,kind:"refused",note:""}}function g(e,t,n){let a=f(e);if(!e||"blank"===a)return p;if("error"===a)return{text:e.shown,kind:"error",note:""};let l=()=>{let t=(0,r.V)(e).trim();return n&&e.code&&(0,i.pP)(e.code)?(0,i.xj)(t,2):t};switch(t){case"integer":{if("number"!==e.kind)return $(e);let t=l();if(!/^[-+]?\d+$/.test(t))return $(e);
1return{text:t.replace(/^\+/,""),kind:"ok",note:""}}case"decimal":{if("number"!==e.kind)return $(e);let t=l();if(/[eE]/.test(t))return $(e);return{text:t.replace(/^\+/,""),kind:"ok",note:""}}case"double":if("number"!==e.kind)return $(e);return{text:l().replace(/^\+/,""),kind:"ok",note:""};case"boolean":if("bool"===e.kind)return{text:"TRUE"===e.shown?"true":"false",kind:"ok",note:"xs:boolean only takes true and false in lower case, so the sheet TRUE and FALSE were lowered"};if("number"===e.kind){let t=(0,r.V)(e).trim();if("1"===t||"0"===t)return{text:t,kind:"ok",note:""}}return $(e);case"date":case"dateTime":case"time":{if("date"!==e.kind)return $(e);let n=e.dateKind??"date";if("duration"===n||"time"===t&&"time"!==n||"time"!==t&&"time"===n)return $(e);let r=e.iso??"";if(""===r)return $(e);if("dateTime"===t&&!r.includes("T"))return{text:`${r}T00:00:00`,kind:"ok",note:"midnight was added to make a legal xs:dateTime"};if("date"===t&&r.includes("T"))return{text:r.slice(0,10),kind:"ok",note:"the clock time was dropped to fit xs:date"};return{text:r,kind:"ok",note:""}}case"duration":{let t=e.days??e.value??null;if(null===t||"text"===e.kind)return $(e);return{text:function(e){let t=Math.round(86400*Math.abs(e)),n=Math.floor(t/3600),r=Math.floor((t-3600*n)/60),i=t-3600*n-60*r,a="";return n>0&&(a+=`${n}H`),r>0&&(a+=`${r}M`),(i>0||""===a)&&(a+=`${i}S`),`${e<0?"-":""}PT${a}`}(t),kind:"ok",note:"an elapsed time past 24 hours is not a legal xs:time, so it was written as an xs:duration"}}
1default:if("number"===e.kind)return{text:l(),kind:"ok",note:""};if("date"===e.kind)return{text:e.iso??e.shown,kind:"ok",note:""};return{text:e.shown,kind:"ok",note:""}}}function b(e,t,n){let a=[],l=[],u=[],c=new Set;for(let m=0;m<e.width;m++){let h=t[m]??{},d=(e.headers[m]??"").replace(/\s+/g," ").trim(),p=`column${m+1}`,$=s(d,p),b=h.name??$.name,x=""===b.trim()?$.name:s(b,p).name,k="";if(c.has(x)){let e=x,t=2;for(;c.has(`${e}_${t}`);)t++;x=`${e}_${t}`,k=`${e} was already taken, so column ${(0,i.WD)(m)} became ${x}`,u.push(k)}if(c.add(x),""!==$.reason&&void 0===h.name){let e=""===d?`column ${(0,i.WD)(m)}`:d;l.push(`${e} became ${x}, because ${$.reason}`)}let y=new Map,w=[],T=new Set,v=0,M=0,S=0,C=0,U=0,N=0,A=!1,D=0,E=0,L=0;e.rows.forEach((t,a)=>{let l=t[m]??null,s=f(l);if(y.set(s,(y.get(s)??0)+1),"blank"===s)return void M++;if("error"===s?S++:v++,!l)return;let u=`${(0,i.WD)(m)}${e.rowRefs[a]??a+1}`;if(!T.has(s)&&w.length<4&&(T.add(s),w.push({ref:u,value:l.shown.slice(0,32),cls:s})),l.code&&(0,i.pP)(l.code)&&(A=!0),"integer"===s||"decimal"===s){let e=(0,r.V)(l).trim().replace(/^[-+]/,""),t=e.indexOf("."),a=t<0?e:e.slice(0,t),s=t<0?"":e.slice(t+1),o=n&&l.code&&(0,i.pP)(l.code)?2:0,u=Math.max(1,a.replace(/^0+(?=\d)/,"").length+o),c=Math.max(0,s.length-o);U=Math.max(U,u+c),N=Math.max(N,c)}let c=(0,r.a)(l),h=o(c);C=Math.max(C,h.text.length),L=Math.max(L,h.text.length),/[\n\t]/.test(c)&&D++,h.removed>0&&E++});let O=function(e){let t=[...e.keys()].filter(e=>"blank"!==e&&"error"!==e);if(0===t.length)return"string";let n=e=>t.every(t=>e.includes(t));return n(["integer"])?"integer":n(["integer","decimal"])?"decimal":n(["integer","decimal","double"])?"double":n(["date"])?"date":n(["date","dateTime"])?"dateTime":n(["time"])?"time":n(["duration"])?"duration":n(["boolean"])?"boolean":"string"}(y),F=h.type??O,P=h.placement??"element",_=0,j=[];"string"!==F&&e.rows.forEach((t,r)=>{let a=t[m]??null;if(a&&"refused"===g(a,F,n).kind&&(_++,j.length<8)){let t=`${(0,i.WD)(m)}${e.rowRefs[r]??r+1}`,n=""===a.shown.trim()?"(no text)":a.shown.slice(0,30);j.push(`${t} ${n}`)}}),a.push({c:m,header:""===d?`column ${(0,i.WD)(m)}`:d,name:x,input:h.name??$.name,placement:P,type:F,auto:O,evidence:w,filled:v,blanks:M,errors:S,mismatches:_,mismatchRefs:j,maxLength:C,totalDigits:U,fractionDigits:N,percent:A,newlines:D,illegal:E,longest:L,renamed:void 0===h.name?$.reason:"",clash:k})}return{columns:a,renames:l,clashes:u}}let x={root:"records",record:"record",structure:"sheet",namespace:"",pretty:!0,indent:2,blanks:"omit",errors:"nil",cdata:!1,declaration:!0,version:"1.0",percentX100:!1,sheetAttribute:!0,limits:!0,limit:0};class k{add(e,t){let n=this.map.get(e);if(n){n.count++,n.refs.length<6&&n.refs.push(t);return}this.map.set(e,{label:e,count:1,refs:[t]})}list(){return[...this.map.values()].sort((e,t)=>t.count-e.count)}constructor(){this.map=new Map}}function y(e,t,n){let a=n.pretty?" ".repeat(Math.max(0,n.indent)):"",l=n.pretty?"\n":"",o=[],u=[],c=new k,d=[],f=new Set,p="flat"===n.structure,$="workbook"===n.structure,b=s(n.root,"records").name,x=s(n.record,"record").name,y=0;for(let t of e)y+=t.rows.length;let T=n.limit>0?n.limit:1/0,M=!1,S=new Set,C=0,U=0;for(let l=0;l<e.length;l++){let s=e[l],d=t[l];if(!s||!d)continue;let b=d.filter(e=>"skip"!==e.placement),k=$?2:1;$&&o.push(`${a}<sheet name="${m(s.name)}">`);for(let t=0;t<s.rows.length&&!(C>=T);t++){let l=s.rows[t];if(!l)continue;let d=s.rowRefs[t]??t+1,$=[],y=[];for(let t of(p&&n.sheetAttribute&&e.length>1&&$.push(`sheet="${m(s.name)}"`),b)){let e=l[t.c]??null,a=`${(0,i.WD)(t.c)}${d}`,s="attribute"===t.placement,o=g(e,t.type,n.percentX100);if("refused"===o.kind){c.add(`${t.name}: a cell is not ${h[t.type]}, so it was left out rather than written as a value the schema rejects`,a);continue}if("error"===o.kind){if("omit"===n.errors){c.add(`${t.name}: an error cell was left out`,a);continue}if("text"===n.errors){let i=e?(0,r.a)(e):"",l=w(o.text,t,s,n,c,a);s?$.push(l):y.push(l),u.push(v(a,U,t,s,i,o.text,n)),c.add(`${t.name}: an error cell was written as its literal text`,a);continue}if(s){c.add(`${t.name}: an error cell in an attribute cannot be nil, because only an element can be, so it was left out`,a);continue}f.add(t.name),M=!0,y.push(`<${t.name} xsi:nil="true"/>`),c.add(`${t.name}: an error cell became xsi:nil, so the value is absent rather than wrong`,a);continue}if("blank"===o.kind){if("omit"===n.blanks)continue;if("empty"===n.blanks){"string"!==t.type&&S.add(`${t.name} (${h[t.type]})`),s?$.push(`${t.name}=""`):y.push(`<${t.name}/>`);continue}if(s){c.add(`${t.name}: a blank cell in an attribute cannot be nil, so it was left out`,a);continue}f.add(t.name),M=!0,y.push(`<${t.name} xsi:nil="true"/>`);continue}let m=e?(0,r.a)(e):"";""!==o.note&&c.add(`${t.name}: ${o.note}`,a);let p=w(o.text,t,s,n,c,a);s?$.push(p):y.push(p),u.push(v(a,U,t,s,m,o.text,n))}let T=$.length>0?`<${x} ${$.join(" ")}`:`<${x}`;if(0===y.length)o.push(`${a.repeat(k)}${T}/>`);
1else if(n.pretty){for(let e of(o.push(`${a.repeat(k)}${T}>`),y))o.push(`${a.repeat(k+1)}${e}`);o.push(`${a.repeat(k)}</${x}>`)}else o.push(`${T}>${y.join("")}</${x}>`);C++,U++}if($&&o.push(`${a}</sheet>`),C>=T)break}let N=[];n.declaration&&N.push(`<?xml version="${n.version}" encoding="UTF-8"?>`);let A=""===n.namespace.trim()?"":` xmlns="${m(n.namespace.trim())}"`,D=M?' xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"':"";return N.push(`<${b}${A}${D}>`),o.unshift(...N),o.push(`</${b}>`),S.size>0&&d.push(`An empty element is not a legal value for a typed element, so ${[...S].join(", ")} will fail validation while blanks are written as empty elements. Leaving them out or marking them nil both validate.`),"1.1"===n.version&&d.push("XML 1.1 lets the control characters through as references, and plenty of parsers refuse a 1.1 document outright. Pick it only if the system reading the file asked for it."),{xml:o.join(l),records:C,totalRecords:y,slots:u,changes:c.list(),notices:d,nillable:f}}function w(e,t,n,r,i,a){let l=T(e,r,t,i,a);if(n)return/[\n\t]/.test(l)&&i.add(`${t.name}: a line break inside an attribute is written as a character reference, because a literal one comes back as a space`,a),`${t.name}="${c(l)}"`;let s=r.cdata&&"string"===t.type?`<![CDATA[${l.split("]]>").join("]]]]><![CDATA[>")}]]>`:u(l);return`<${t.name}>${s}</${t.name}>`}function T(e,t,n,r,i){if("1.0"!==t.version)return e;let a=o(e);return a.removed>0&&r&&r.add(`${n.name}: ${1===a.removed?"a character":`${a.removed} characters`} XML 1.0 does not allow at all ${1===a.removed?"was":"were"} removed`,i),a.text}function v(e,t,n,r,i,a,l){return{ref:e,record:t,name:n.name,attribute:r,stored:i,written:T(a,l,n,null,e)}}let M=12;function S(e,t,n,r){let i={ran:!1,wellFormed:!1,parseError:"",checked:0,skipped:t.length,losses:[],lost:0,deliberate:0};if("undefined"==typeof DOMParser)return i;let a=new DOMParser().parseFromString(e,"application/xml"),l=a.getElementsByTagName("parsererror")[0];if(l)return{...i,ran:!0,parseError:(l.textContent??"The document could not be parsed.").replace(/\s+/g," ").slice(0,240)};let s=[],o=a.documentElement;for(let e of Array.from(o?.children??[])){if(e.localName===n){s.push(e);continue}if("sheet"===e.localName)for(let t of Array.from(e.children))t.localName===n&&s.push(t)}let u=[],c=0,m=0,h=0;for(let e of t){if(m>=r)break;let t=s[e.record];if(!t)continue;m++;let n=null;if(e.attribute)n=t.getAttribute(e.name);else{let r=t.children;for(let t=0;t<r.length;t++){let i=r[t];if(i&&i.localName===e.name){n=i.textContent??"";break}}}if(null===n){c++,u.length<M&&u.push({ref:e.ref,name:e.name,written:e.written,read:"",reason:"it is not in the document that came back"});continue}if(n===e.written){e.written!==e.stored&&h++;continue}let i="the text that came back is not the text that went in";e.attribute&&e.written.replace(/[\n\t\r]/g," ")===n?i="attribute value normalization replaced its line breaks with spaces":e.written.replace(/\r\n?/g,"\n")===n?i="the carriage returns were normalized away":e.written.trim()===n.trim()&&(i="the whitespace around it changed"),c++,u.length<M&&u.push({ref:e.ref,name:e.name,written:e.written,read:n,reason:i})}return{ran:!0,wellFormed:!0,parseError:"",checked:m,skipped:Math.max(0,t.length-m),losses:u,lost:c,deliberate:h}}function C(e,t,n){let r=" ".repeat(Math.max(1,t.indent)),i=s(t.root,"records").name,a=s(t.record,"record").name,l=[];l.push('<?xml version="1.0" encoding="UTF-8"?>');let o=['xmlns:xs="http://www.w3.org/2001/XMLSchema"'];if(""!==t.namespace.trim()){let e=m(t.namespace.trim());o.push(`targetNamespace="${e}"`),o.push(`xmlns="${e}"`),o.push('elementFormDefault="qualified"')}l.push(`<xs:schema ${o.join(" ")}>`);let u="flat"===t.structure,c=e=>e.columns.filter(e=>"skip"!==e.placement),d=e=>c(e).filter(e=>"element"===e.placement).map(e=>e.name),f=[];{let t=new Set;for(let n of e)for(let e of c(n))t.has(e.name)||(t.add(e.name),f.push(e))}let p=new Set(e.length>0?d(e[0]):[]);for(let t of e.slice(1)){let e=new Set(d(t));for(let t of[...p])e.has(t)||p.delete(t)}let $=!(e.length<=1||1===new Set(e.map(e=>d(e).join("â"))).size),g=(e,i,a)=>{let l=[],s=e.filter(e=>"element"===e.placement),o=e.filter(e=>"attribute"===e.placement);if(l.push(`${i}<xs:complexType>`),s.length>0){let e=$?"xs:all":"xs:sequence";for(let a of(l.push(`${i}${r}<${e}>`),s)){let e=$&&!p.has(a.name);l.push(...function(e,t,n,r,i,a=!1){let l=a||N(e,i)?' minOccurs="0"':"",s=r.has(e.name)||e.blanks>0&&"nil"===i.blanks||e.errors>0&&"nil"===i.errors?' nillable="true"':"",o=U(e,i);return 0===o.length?[`${t}<xs:element name="${e.name}" type="${h[e.type]}"${l}${s}/>`]:[`${t}<xs:element name="${e.name}"${l}${s}>`,`${t}${n}<xs:simpleType>`,`${t}${n}${n}<xs:restriction base="${h[e.type]}">`,...o.map(e=>`${t}${n.repeat(3)}${e}`),`${t}${n}${n}</xs:restriction>`,`${t}${n}</xs:simpleType>`,`${t}</xs:element>`]}(a,`${i}${r}${r}`,r,n,t,e))}l.push(`${i}${r}</${e}>`)}for(let e of(a&&l.push(`${i}${r}<xs:attribute name="sheet" type="xs:string" use="optional"/>`),o))l.push(...function(e,t,n,r){let i=N(e,r)||e.blanks>0||e.errors>0?' use="optional"':' use="required"',a=U(e,r);return 0===a.length?[`${t}<xs:attribute name="${e.name}" type="${h[e.type]}"${i}/>`]:[`${t}<xs:attribute name="${e.name}"${i}>`,`${t}${n}<xs:simpleType>`,`${t}${n}${n}<xs:restriction base="${h[e.type]}">`,...a.map(e=>`${t}${n.repeat(3)}${e}`),`${t}${n}${n}</xs:restriction>`,`${t}${n}</xs:simpleType>`,`${t}</xs:attribute>`]}(e,`${i}${r}`,r,t));return l.push(`${i}</xs:complexType>`),l};if(l.push(`${r}<xs:element name="${i}">`),l.push(`${r.repeat(2)}<xs:complexType>`),l.push(`${r.repeat(3)}<xs:sequence>`),"workbook"===t.structure)l.push(`${r.repeat(4)}<xs:element name="sheet" maxOccurs="unbounded">`),l.push(`${r.repeat(5)}<xs:complexType>`),l.push(`${r.repeat(6)}<xs:sequence>`),l.push(`${r.repeat(7)}<xs:element name="${a}" minOccurs="0" maxOccurs="unbounded">`),l.push(...g(f,r.repeat(8),!1)),l.push(`${r.repeat(7)}</xs:element>`),l.push(`${r.repeat(6)}</xs:sequence>`),l.push(`${r.repeat(6)}<xs:attribute name="name" type="xs:string" use="required"/>`),l.push(`${r.repeat(5)}</xs:complexType>`),l.push(`${r.repeat(4)}</xs:element>`);else{let n=u?f:(e[0]?.columns??[]).filter(e=>"skip"!==e.placement);l.push(`${r.repeat(4)}<xs:element name="${a}" minOccurs="0" maxOccurs="unbounded">`),l.push(...g(n,r.repeat(5),u&&t.sheetAttribute&&e.length>1)),l.push(`${r.repeat(4)}</xs:element>`)}return l.push(`${r.repeat(3)}
1</xs:sequence>`),l.push(`${r.repeat(2)}</xs:complexType>`),l.push(`${r}</xs:element>`),l.push("</xs:schema>"),$&&l.splice(1,0,"\x3c!-- These sheets do not carry the same columns in the same order, so a record is described"," by xs:all: every column from every sheet, each at most once, and the ones that are not"," on every sheet marked optional. Element ORDER is therefore not constrained here. Put"," the same columns in the same order on every sheet to get an ordered xs:sequence back. --\x3e"),l.join("\n")}function U(e,t){let n=[];return t.limits&&("string"===e.type&&e.maxLength>0&&n.push(`<xs:maxLength value="${e.maxLength}"/>`),"decimal"===e.type&&e.totalDigits>0&&(n.push(`<xs:totalDigits value="${e.totalDigits}"/>`),n.push(`<xs:fractionDigits value="${e.fractionDigits}"/>`))),n}function N(e,t){return!!(e.mismatches>0)||!!(e.blanks>0)&&"omit"===t.blanks||!!(e.errors>0)&&"omit"===t.errors}function A(e){let t=[];if(e.newlines>0){let n=e.newlines;t.push(`as an attribute, the ${n} cell${1===n?"":"s"} holding a line break ${1===n?"is":"are"} written as a character reference so the text survives, though many readers still show it on one line`)}if(e.errors>0){let n=e.errors;t.push(`as an attribute, the ${n} error cell${1===n?"":"s"} cannot be nil, because only an element can be`)}if(e.longest>2e3&&t.push(`as an attribute, the longest value here runs to ${e.longest.toLocaleString("en-US")} characters, which is legal and unreadable`),e.illegal>0){let n=e.illegal;t.push(`${n} cell${1===n?"":"s"} hold a character XML 1.0 forbids outright, which is removed either way`)}return t}},21530:(e,t,n)=>{function r(e){return e.text??e.raw}function i(e){return"number"===e.kind?r(e).trim():"date"===e.kind?e.iso??e.raw:e.shown}n.d(t,{V:()=>r,a:()=>i})}}]);
Line numbers count LF bytes from the start of the resource, as the search results do. Vendor segments are library code the classifier recognised; they are stored but not indexed. Bytes are shown as Latin1 characters, one per byte.