| 24 | |================================================|`),console.log(`| FINAL: tableRowSlides.length = ${V.length}`),V.forEach((D)=>console.log(D)),console.log(`|================================================| |
| 25 | |
| 26 | `);return V}function LB($,q,Q={},K){let J=Q||{};J.slideMargin=J.slideMargin||J.slideMargin===0?J.slideMargin:0.5;let Z=J.w||$.presLayout.width,G=[],W=[],B=[],V=[],U=[],w=[0.5,0.5,0.5,0.5],F=0;if(!document.getElementById(q))throw Error('tableToSlides: Table ID "'+q+'" does not exist!');if(K===null||K===void 0?void 0:K._margin){if(Array.isArray(K._margin))w=K._margin;else if(!isNaN(K._margin))w=[K._margin,K._margin,K._margin,K._margin];J.slideMargin=w}else if(J===null||J===void 0?void 0:J.slideMargin){if(Array.isArray(J.slideMargin))w=J.slideMargin;else if(!isNaN(J.slideMargin))w=[J.slideMargin,J.slideMargin,J.slideMargin,J.slideMargin]}if(Z=(J.w?v0(J.w):$.presLayout.width)-v0(w[1]+w[3]),J.verbose)console.log("[[VERBOSE MODE]]"),console.log("|-- `tableToSlides` ----------------------------------------------------|"),console.log(`| tableProps.h .................................... = ${J.h}`),console.log(`| tableProps.w .................................... = ${J.w}`),console.log(`| pptx.presLayout.width ........................... = ${($.presLayout.width/L0).toFixed(1)}`),console.log(`| pptx.presLayout.height .......................... = ${($.presLayout.height/L0).toFixed(1)}`),console.log(`| emuSlideTabW .................................... = ${(Z/L0).toFixed(1)}`);let M=document.querySelectorAll(`#${q} tr:first-child th`);if(M.length===0)M=document.querySelectorAll(`#${q} tr:first-child td`);if(M.forEach((f)=>{let L=f;if(L.getAttribute("colspan"))for(let D=0;D<Number(L.getAttribute("colspan"));D++)U.push(Math.round(L.offsetWidth/Number(L.getAttribute("colspan"))));else U.push(L.offsetWidth)}),U.forEach((f)=>{F+=f}),U.forEach((f,L)=>{let D=Number((Number(Z)*(f/F*100)/100/L0).toFixed(2)),z=0,N=document.querySelector(`#${q} thead tr:first-child th:nth-child(${L+1})`);if(N)z=Number(N.getAttribute("data-pptx-min-width"));let H=document.querySelector(`#${q} thead tr:first-child th:nth-child(${L+1})`);if(H)z=Number(H.getAttribute("data-pptx-width"));V.push(z>D?z:D)}),J.verbose)console.log(`| arrColW ......................................... = [${V.join(", ")}]`);["thead","tbody","tfoot"].forEach((f)=>{document.querySelectorAll(`#${q} ${f} tr`).forEach((L)=>{let D=L,z=[];switch(Array.from(D.cells).forEach((N)=>{let H=window.getComputedStyle(N).getPropertyValue("color").replace(/\s+/gi,"").replace("rgba(","").replace("rgb(","").replace(")","").split(","),v=window.getComputedStyle(N).getPropertyValue("background-color").replace(/\s+/gi,"").replace("rgba(","").replace("rgb(","").replace(")","").split(",");if(window.getComputedStyle(N).getPropertyValue("background-color")==="rgba(0, 0, 0, 0)"||window.getComputedStyle(N).getPropertyValue("transparent"))v=["255","255","255"];let j={align:null,bold:window.getComputedStyle(N).getPropertyValue("font-weight")==="bold"||Number(window.getComputedStyle(N).getPropertyValue("font-weight"))>=500,border:null,color:g7(Number(H[0]),Number(H[1]),Number(H[2])),fill:{color:g7(Number(v[0]),Number(v[1]),Number(v[2]))},fontFace:(window.getComputedStyle(N).getPropertyValue("font-family")||"").split(",")[0].replace(/"/g,"").replace("inherit","").replace("initial","")||null,fontSize:Number(window.getComputedStyle(N).getPropertyValue("font-size").replace(/[a-z]/gi,"")),margin:null,colspan:Number(N.getAttribute("colspan"))||null,rowspan:Number(N.getAttribute("rowspan"))||null,valign:null};if(["left","center","right","start","end"].includes(window.getComputedStyle(N).getPropertyValue("text-align"))){let n=window.getComputedStyle(N).getPropertyValue("text-align").replace("start","left").replace("end","right");j.align=n==="center"?"center":n==="left"?"left":n==="right"?"right":null}if(["top","middle","bottom"].includes(window.getComputedStyle(N).getPropertyValue("vertical-align"))){let n=window.getComputedStyle(N).getPropertyValue("vertical-align");j.valign=n==="top"?"top":n==="middle"?"middle":n==="bottom"?"bottom":null}if(window.getComputedStyle(N).getPropertyValue("padding-left"))j.margin=[0,0,0,0],["padding-top","padding-right","padding-bottom","padding-left"].forEach((d,_)=>{j.margin[_]=Math.round(Number(window.getComputedStyle(N).getPropertyValue(d).replace(/\D/gi,"")))});if(window.getComputedStyle(N).getPropertyValue("border-top-width")||window.getComputedStyle(N).getPropertyValue("border-right-width")||window.getComputedStyle(N).getPropertyValue("border-bottom-width")||window.getComputedStyle(N).getPropertyValue("border-left-width"))j.border=[null,null,null,null],["top","right","bottom","left"].forEach((d,_)=>{let X=Math.round(Number(window.getComputedStyle(N).getPropertyValue("border-"+d+"-width").replace("px",""))),P=[];P=window.getComputedStyle(N).getPropertyValue("border-"+d+"-color").replace(/\s+/gi,"").replace("rgba(","").replace("rgb(","").replace(")","").split(",");let g=g7(Number(P[0]),Number(P[1]),Number(P[2]));j.border[_]={pt:X,color:g}});z.push({_type:D0.tablecell,text:N.innerText,options:j})}),f){case"thead":G.push(z);break;case"tbody":W.push(z);break;case"tfoot":B.push(z);break;default:console.log(`table parsing: unexpected table part: ${f}`);break}})}),J._arrObjTabHeadRows=G||null,J.colW=V,ZJ([...G,...W,...B],J,$.presLayout,K).forEach((f,L)=>{let D=$.addSlide({masterName:J.masterSlideName||null});if(L===0)J.y=J.y||w[0];if(L>0)J.y=J.autoPageSlideStartY||J.newSlideStartY||w[0];if(J.verbose)console.log(`| opts.autoPageSlideStartY: ${J.autoPageSlideStartY} / arrInchMargins[0]: ${w[0]} => opts.y = ${J.y}`);if(D.addTable(f.rows,{x:J.x||w[3],y:J.y,w:Number(Z)/L0,colW:V,autoPage:!1}),J.addImage)if(J.addImage.options=J.addImage.options||{},!J.addImage.image||!J.addImage.image.path&&!J.addImage.image.data)console.warn("Warning: tableToSlides.addImage requires either `path` or `data`");else D.addImage({path:J.addImage.image.path,data:J.addImage.image.data,x:J.addImage.options.x,y:J.addImage.options.y,w:J.addImage.options.w,h:J.addImage.options.h});if(J.addShape)D.addShape(J.addShape.shapeName,J.addShape.options||{});if(J.addTable)D.addTable(J.addTable.rows,J.addTable.options||{});if(J.addText)D.addText(J.addText.text,J.addText.options||{})})}var HB=0;function vB($,q){if($.bkgd)q.bkgd=$.bkgd;if($.objects&&Array.isArray($.objects)&&$.objects.length>0)$.objects.forEach((Q,K)=>{let J=Object.keys(Q)[0],Z=q;if(W1[J]&&J==="chart")GJ(Z,Q[J].type,Q[J].data,Q[J].opts);else if(W1[J]&&J==="image")WJ(Z,Q[J]);else if(W1[J]&&J==="line")E7(Z,B1.LINE,Q[J]);else if(W1[J]&&J==="rect")E7(Z,B1.RECTANGLE,Q[J]);else if(W1[J]&&J==="text")L5(Z,[{text:Q[J].text}],Q[J].options,!1);else if(W1[J]&&J==="placeholder")Q[J].options.placeholder=Q[J].options.name,delete Q[J].options.name,Q[J].options._placeholderType=Q[J].options.type,delete Q[J].options.type,Q[J].options._placeholderIdx=100+K,L5(Z,[{text:Q[J].text}],Q[J].options,!0)});if($.slideNumber&&typeof $.slideNumber==="object")q._slideNumberProps=$.slideNumber}function GJ($,q,Q,K){var J;function Z(w){if(!w||w.style==="none")return;if(w.size!==void 0&&(isNaN(Number(w.size))||w.size<=0))console.warn("Warning: chart.gridLine.size must be greater than 0."),delete w.size;if(w.style&&!["solid","dash","dot"].includes(w.style))console.warn("Warning: chart.gridLine.style options: `solid`, `dash`, `dot`."),delete w.style;if(w.cap&&!["flat","square","round"].includes(w.cap))console.warn("Warning: chart.gridLine.cap options: `flat`, `square`, `round`."),delete w.cap}let G=++HB,W={_type:null,text:null,options:null,chartRid:null},B=null,V=[];if(Array.isArray(q))q.forEach((w)=>{V=V.concat(w.data)}),B=Q||K;else V=Q,B=K;V.forEach((w,F)=>{if(w._dataIndex=F,w.labels!==void 0&&!Array.isArray(w.labels[0]))w.labels=[w.labels]});let U=B&&typeof B==="object"?B:{};if(U._type=q,U.x=typeof U.x<"u"&&U.x!=null&&!isNaN(Number(U.x))?U.x:1,U.y=typeof U.y<"u"&&U.y!=null&&!isNaN(Number(U.y))?U.y:1,U.w=U.w||"50%",U.h=U.h||"50%",U.objectName=U.objectName?k0(U.objectName):`Chart ${$._slideObjects.filter((w)=>w._type===D0.chart).length}`,!["bar","col"].includes(U.barDir||""))U.barDir="col";if(U._type===q0.AREA){if(!["stacked","standard","percentStacked"].includes(U.barGrouping||""))U.barGrouping="standard"}if(U._type===q0.BAR){if(!["clustered","stacked","percentStacked"].includes(U.barGrouping||""))U.barGrouping="clustered"}if(U._type===q0.BAR3D){if(!["clustered","stacked","standard","percentStacked"].includes(U.barGrouping||""))U.barGrouping="standard"}if((J=U.barGrouping)===null||J===void 0?void 0:J.includes("tacked")){if(!U.barGapWidthPct)U.barGapWidthPct=50}if(U.dataLabelPosition){if(U._type===q0.AREA||U._type===q0.BAR3D||U._type===q0.DOUGHNUT||U._type===q0.RADAR)delete U.dataLabelPosition;if(U._type===q0.PIE){if(!["bestFit","ctr","inEnd","outEnd"].includes(U.dataLabelPosition))delete U.dataLabelPosition}if(U._type===q0.BUBBLE||U._type===q0.BUBBLE3D||U._type===q0.LINE||U._type===q0.SCATTER){if(!["b","ctr","l","r","t"].includes(U.dataLabelPosition))delete U.dataLabelPosition}if(U._type===q0.BAR){if(!["stacked","percentStacked"].includes(U.barGrouping||"")){if(!["ctr","inBase","inEnd"].includes(U.dataLabelPosition))delete U.dataLabelPosition}if(!["clustered"].includes(U.barGrouping||"")){if(!["ctr","inBase","inEnd","outEnd"].includes(U.dataLabelPosition))delete U.dataLabelPosition}}}if(U.dataLabelBkgrdColors=U.dataLabelBkgrdColors||!U.dataLabelBkgrdColors?U.dataLabelBkgrdColors:!1,!["b","l","r","t","tr"].includes(U.legendPos||""))U.legendPos="r";if(!["cone","coneToMax","box","cylinder","pyramid","pyramidToMax"].includes(U.bar3DShape||""))U.bar3DShape="box";if(!["circle","dash","diamond","dot","none","square","triangle"].includes(U.lineDataSymbol||""))U.lineDataSymbol="circle";if(!["gap","span"].includes(U.displayBlanksAs||""))U.displayBlanksAs="span";if(!["standard","marker","filled"].includes(U.radarStyle||""))U.radarStyle="standard";if(U.lineDataSymbolSize=U.lineDataSymbolSize&&!isNaN(U.lineDataSymbolSize)?U.lineDataSymbolSize:6,U.lineDataSymbolLineSize=U.lineDataSymbolLineSize&&!isNaN(U.lineDataSymbolLineSize)?Y0(U.lineDataSymbolLineSize):Y0(0.75),U.layout)["x","y","w","h"].forEach((w)=>{let F=U.layout[w];if(isNaN(Number(F))||F<0||F>1)console.warn("Warning: chart.layout."+w+" can only be 0-1"),delete U.layout[w]});if(U.catGridLine=U.catGridLine||(U._type===q0.SCATTER?{color:"D9D9D9",size:1}:{style:"none"}),U.valGridLine=U.valGridLine||(U._type===q0.SCATTER?{color:"D9D9D9",size:1}:{}),U.serGridLine=U.serGridLine||(U._type===q0.SCATTER?{color:"D9D9D9",size:1}:{style:"none"}),Z(U.catGridLine),Z(U.valGridLine),Z(U.serGridLine),c7(U.shadow),U.showDataTable=U.showDataTable||!U.showDataTable?U.showDataTable:!1,U.showDataTableHorzBorder=U.showDataTableHorzBorder||!U.showDataTableHorzBorder?U.showDataTableHorzBorder:!0,U.showDataTableVertBorder=U.showDataTableVertBorder||!U.showDataTableVertBorder?U.showDataTableVertBorder:!0,U.showDataTableOutline=U.showDataTableOutline||!U.showDataTableOutline?U.showDataTableOutline:!0,U.showDataTableKeys=U.showDataTableKeys||!U.showDataTableKeys?U.showDataTableKeys:!0,U.showLabel=U.showLabel||!U.showLabel?U.showLabel:!1,U.showLegend=U.showLegend||!U.showLegend?U.showLegend:!1,U.showPercent=U.showPercent||!U.showPercent?U.showPercent:!0,U.showTitle=U.showTitle||!U.showTitle?U.showTitle:!1,U.showValue=U.showValue||!U.showValue?U.showValue:!1,U.showLeaderLines=U.showLeaderLines||!U.showLeaderLines?U.showLeaderLines:!1,U.catAxisLineShow=typeof U.catAxisLineShow<"u"?U.catAxisLineShow:!0,U.valAxisLineShow=typeof U.valAxisLineShow<"u"?U.valAxisLineShow:!0,U.serAxisLineShow=typeof U.serAxisLineShow<"u"?U.serAxisLineShow:!0,U.v3DRotX=!isNaN(U.v3DRotX)&&U.v3DRotX>=-90&&U.v3DRotX<=90?U.v3DRotX:30,U.v3DRotY=!isNaN(U.v3DRotY)&&U.v3DRotY>=0&&U.v3DRotY<=360?U.v3DRotY:30,U.v3DRAngAx=U.v3DRAngAx||!U.v3DRAngAx?U.v3DRAngAx:!0,U.v3DPerspective=!isNaN(U.v3DPerspective)&&U.v3DPerspective>=0&&U.v3DPerspective<=240?U.v3DPerspective:30,U.barGapWidthPct=!isNaN(U.barGapWidthPct)&&U.barGapWidthPct>=0&&U.barGapWidthPct<=1000?U.barGapWidthPct:150,U.barGapDepthPct=!isNaN(U.barGapDepthPct)&&U.barGapDepthPct>=0&&U.barGapDepthPct<=1000?U.barGapDepthPct:150,U.chartColors=Array.isArray(U.chartColors)?U.chartColors:U._type===q0.PIE||U._type===q0.DOUGHNUT?NB:z8,U.chartColorsOpacity=U.chartColorsOpacity&&!isNaN(U.chartColorsOpacity)?U.chartColorsOpacity:null,U.border=U.border&&typeof U.border==="object"?U.border:null,U.border&&(!U.border.pt||isNaN(U.border.pt)))U.border.pt=v6.pt;if(U.border&&(!U.border.color||typeof U.border.color!=="string"))U.border.color=v6.color;if(U.plotArea=U.plotArea||{},U.plotArea.border=U.plotArea.border&&typeof U.plotArea.border==="object"?U.plotArea.border:null,U.plotArea.border&&(!U.plotArea.border.pt||isNaN(U.plotArea.border.pt)))U.plotArea.border.pt=v6.pt;if(U.plotArea.border&&(!U.plotArea.border.color||typeof U.plotArea.border.color!=="string"))U.plotArea.border.color=v6.color;if(U.border)U.plotArea.border=U.border;if(U.plotArea.fill=U.plotArea.fill||{color:null,transparency:null},U.fill)U.plotArea.fill.color=U.fill;if(U.chartArea=U.chartArea||{},U.chartArea.border=U.chartArea.border&&typeof U.chartArea.border==="object"?U.chartArea.border:null,U.chartArea.border)U.chartArea.border={color:U.chartArea.border.color||v6.color,pt:U.chartArea.border.pt||v6.pt};if(U.chartArea.roundedCorners=typeof U.chartArea.roundedCorners==="boolean"?U.chartArea.roundedCorners:!0,U.dataBorder=U.dataBorder&&typeof U.dataBorder==="object"?U.dataBorder:null,U.dataBorder&&(!U.dataBorder.pt||isNaN(U.dataBorder.pt)))U.dataBorder.pt=0.75;if(U.dataBorder&&U.dataBorder.color){let w=typeof U.dataBorder.color==="string"&&U.dataBorder.color.length===6&&/^[0-9A-Fa-f]{6}$/.test(U.dataBorder.color),F=Object.values(D5).includes(U.dataBorder.color);if(!w&&!F)U.dataBorder.color="F9F9F9"}if(!U.dataLabelFormatCode&&U._type===q0.SCATTER)U.dataLabelFormatCode="General";if(!U.dataLabelFormatCode&&(U._type===q0.PIE||U._type===q0.DOUGHNUT))U.dataLabelFormatCode=U.showPercent?"0%":"General";if(U.dataLabelFormatCode=U.dataLabelFormatCode&&typeof U.dataLabelFormatCode==="string"?U.dataLabelFormatCode:"#,##0",!U.dataLabelFormatScatter&&U._type===q0.SCATTER)U.dataLabelFormatScatter="custom";if(U.lineSize=typeof U.lineSize==="number"?U.lineSize:2,U.valAxisMajorUnit=typeof U.valAxisMajorUnit==="number"?U.valAxisMajorUnit:null,U._type===q0.AREA||U._type===q0.BAR||U._type===q0.BAR3D||U._type===q0.LINE)U.catAxisMultiLevelLabels=!!U.catAxisMultiLevelLabels;else delete U.catAxisMultiLevelLabels;return W._type="chart",W.options=U,W.chartRid=a2($),$._relsChart.push({rId:a2($),data:V,opts:U,type:U._type,globalId:G,fileName:`chart${G}.xml`,Target:`/ppt/charts/chart${G}.xml`}),$._slideObjects.push(W),W}function WJ($,q){let Q={_type:null,text:null,options:null,image:null,imageRid:null,hyperlink:null},K=q.x||0,J=q.y||0,Z=q.w||0,G=q.h||0,W=q.sizing||null,B=q.hyperlink||"",V=q.data||"",U=q.path||"",w=a2($),F=q.objectName?k0(q.objectName):`Image ${$._slideObjects.filter((k)=>k._type===D0.image).length}`;if(!U&&!V)return console.error("ERROR: addImage() requires either 'data' or 'path' parameter!"),null;else if(U&&typeof U!=="string")return console.error(`ERROR: addImage() 'path' should be a string, ex: {path:'/img/sample.png'} - you sent ${String(U)}`),null;else if(V&&typeof V!=="string")return console.error(`ERROR: addImage() 'data' should be a string, ex: {data:'image/png;base64,NMP[...]'} - you sent ${String(V)}`),null;else if(V&&typeof V==="string"&&!V.toLowerCase().includes("base64,"))return console.error("ERROR: Image `data` value lacks a base64 header! Ex: 'image/png;base64,NMP[...]')"),null;let M=(U.substring(U.lastIndexOf("/")+1).split("?")[0].split(".").pop().split("#")[0]||"png").toLowerCase();if(V&&/image\/(\w+);/.exec(V)&&/image\/(\w+);/.exec(V).length>0)M=/image\/(\w+);/.exec(V)[1];else if(V===null||V===void 0?void 0:V.toLowerCase().includes("image/svg+xml"))M="svg";if(Q._type=D0.image,Q.image=U||"preencoded.png",Q.options={x:K||0,y:J||0,w:Z||1,h:G||1,altText:q.altText||"",rounding:typeof q.rounding==="boolean"?q.rounding:!1,sizing:W,placeholder:q.placeholder,rotate:q.rotate||0,flipV:q.flipV||!1,flipH:q.flipH||!1,transparency:q.transparency||0,objectName:F,shadow:c7(q.shadow)},M==="svg")$._relsMedia.push({path:U||V+"png",type:"image/png",extn:"png",data:V||"",rId:w,Target:`../media/image-${$._slideNum}-${$._relsMedia.length+1}.png`,isSvgPng:!0,svgSize:{w:H0(Q.options.w,"X",$._presLayout),h:H0(Q.options.h,"Y",$._presLayout)}}),Q.imageRid=w,$._relsMedia.push({path:U||V,type:"image/svg+xml",extn:M,data:V||"",rId:w+1,Target:`../media/image-${$._slideNum}-${$._relsMedia.length+1}.${M}`}),Q.imageRid=w+1;else{let k=$._relsMedia.filter((f)=>f.path&&f.path===U&&f.type==="image/"+M&&!f.isDuplicate)[0];$._relsMedia.push({path:U||"preencoded."+M,type:"image/"+M,extn:M,data:V||"",rId:w,isDuplicate:!!(k===null||k===void 0?void 0:k.Target),Target:(k===null||k===void 0?void 0:k.Target)?k.Target:`../media/image-${$._slideNum}-${$._relsMedia.length+1}.${M}`}),Q.imageRid=w}if(typeof B==="object")if(!B.url&&!B.slide)throw Error("ERROR: `hyperlink` option requires either: `url` or `slide`");else w++,$._rels.push({type:D0.hyperlink,data:B.slide?"slide":"dummy",rId:w,Target:B.url||B.slide.toString()}),B._rId=w,Q.hyperlink=B;$._slideObjects.push(Q)}function fB($,q){let Q=q.x||0,K=q.y||0,J=q.w||2,Z=q.h||2,G=q.data||"",W=q.link||"",B=q.path||"",V=q.type||"audio",U="",w=q.cover||YB,F=q.objectName?k0(q.objectName):`Media ${$._slideObjects.filter((k)=>k._type===D0.media).length}`,M={_type:D0.media};if(!B&&!G&&V!=="online")throw Error("addMedia() error: either `data` or `path` are required!");else if(G&&!G.toLowerCase().includes("base64,"))throw Error("addMedia() error: `data` value lacks a base64 header! Ex: 'video/mpeg;base64,NMP[...]')");else if(!w.toLowerCase().includes("base64,"))throw Error("addMedia() error: `cover` value lacks a base64 header! Ex: 'data:image/png;base64,iV[...]')");if(V==="online"&&!W)throw Error("addMedia() error: online videos require `link` value");if(U=q.extn||(G?G.split(";")[0].split("/")[1]:B.split(".").pop())||"mp3",M.mtype=V,M.media=B||"preencoded.mov",M.options={},M.options.x=Q,M.options.y=K,M.options.w=J,M.options.h=Z,M.options.objectName=F,V==="online"){let k=a2($);$._relsMedia.push({path:B||"preencoded"+U,data:"dummy",type:"online",extn:U,rId:k,Target:W}),M.mediaRid=k,$._relsMedia.push({path:"preencoded.png",data:w,type:"image/png",extn:"png",rId:a2($),Target:`../media/image-${$._slideNum}-${$._relsMedia.length+1}.png`})}else{let k=$._relsMedia.filter((L)=>L.path&&L.path===B&&L.type===V+"/"+U&&!L.isDuplicate)[0],f=a2($);$._relsMedia.push({path:B||"preencoded"+U,type:V+"/"+U,extn:U,data:G||"",rId:f,isDuplicate:!!(k===null||k===void 0?void 0:k.Target),Target:(k===null||k===void 0?void 0:k.Target)?k.Target:`../media/media-${$._slideNum}-${$._relsMedia.length+1}.${U}`}),M.mediaRid=f,$._relsMedia.push({path:B||"preencoded"+U,type:V+"/"+U,extn:U,data:G||"",rId:a2($),isDuplicate:!!(k===null||k===void 0?void 0:k.Target),Target:(k===null||k===void 0?void 0:k.Target)?k.Target:`../media/media-${$._slideNum}-${$._relsMedia.length+0}.${U}`}),$._relsMedia.push({path:"preencoded.png",type:"image/png",extn:"png",data:w,rId:a2($),Target:`../media/image-${$._slideNum}-${$._relsMedia.length+1}.png`})}$._slideObjects.push(M)}function RB($,q){$._slideObjects.push({_type:D0.notes,text:[{text:q}]})}function E7($,q,Q){let K=typeof Q==="object"?Q:{};K.line=K.line||{type:"none"};let J={_type:D0.text,shape:q||B1.RECTANGLE,options:K,text:null};if(!q)throw Error("Missing/Invalid shape parameter! Example: `addShape(pptxgen.shapes.LINE, {x:1, y:1, w:1, h:1});`");let Z={type:K.line.type||"solid",color:K.line.color||JJ,transparency:K.line.transparency||0,width:K.line.width||1,dashType:K.line.dashType||"solid",beginArrowType:K.line.beginArrowType||null,endArrowType:K.line.endArrowType||null};if(typeof K.line==="object"&&K.line.type!=="none")K.line=Z;if(K.x=K.x||(K.x===0?0:1),K.y=K.y||(K.y===0?0:1),K.w=K.w||(K.w===0?0:1),K.h=K.h||(K.h===0?0:1),K.objectName=K.objectName?k0(K.objectName):`Shape ${$._slideObjects.filter((G)=>G._type===D0.text).length}`,typeof K.line==="string"){let G=Z;G.color=String(K.line),K.line=G}if(typeof K.lineSize==="number")K.line.width=K.lineSize;if(typeof K.lineDash==="string")K.line.dashType=K.lineDash;if(typeof K.lineHead==="string")K.line.beginArrowType=K.lineHead;if(typeof K.lineTail==="string")K.line.endArrowType=K.lineTail;g6($,J),$._slideObjects.push(J)}function IB($,q,Q,K,J,Z,G){let W=[$],B=Q&&typeof Q==="object"?Q:{};B.objectName=B.objectName?k0(B.objectName):`Table ${$._slideObjects.filter((F)=>F._type===D0.table).length}`;{if(q===null||q.length===0||!Array.isArray(q))throw Error("addTable: Array expected! EX: 'slide.addTable( [rows], {options} );' (https://gitbrent.github.io/PptxGenJS/docs/api-tables.html)");if(!q[0]||!Array.isArray(q[0]))throw Error("addTable: 'rows' should be an array of cells! EX: 'slide.addTable( [ ['A'], ['B'], {text:'C',options:{align:'center'}} ] );' (https://gitbrent.github.io/PptxGenJS/docs/api-tables.html)")}let V=[];if(q.forEach((F)=>{let M=[];if(Array.isArray(F))F.forEach((k)=>{let f={_type:D0.tablecell,text:"",options:typeof k==="object"&&k.options?k.options:{}};if(typeof k==="string"||typeof k==="number")f.text=k.toString();else if(k.text){if(typeof k.text==="string"||typeof k.text==="number")f.text=k.text.toString();else if(k.text)f.text=k.text;if(k.options&&typeof k.options==="object")f.options=k.options}f.options.border=f.options.border||B.border||[{type:"none"},{type:"none"},{type:"none"},{type:"none"}];let L=f.options.border;if(!Array.isArray(L)&&typeof L==="object")f.options.border=[L,L,L,L];if(!f.options.border[0])f.options.border[0]={type:"none"};if(!f.options.border[1])f.options.border[1]={type:"none"};if(!f.options.border[2])f.options.border[2]={type:"none"};if(!f.options.border[3])f.options.border[3]={type:"none"};[0,1,2,3].forEach((z)=>{f.options.border[z]={type:f.options.border[z].type||H6.type,color:f.options.border[z].color||H6.color,pt:typeof f.options.border[z].pt==="number"?f.options.border[z].pt:H6.pt}}),M.push(f)});else console.log("addTable: tableRows has a bad row. A row should be an array of cells. You provided:"),console.log(F);V.push(M)}),B.x=H0(B.x||(B.x===0?0:L0/2),"X",J),B.y=H0(B.y||(B.y===0?0:L0/2),"Y",J),B.h)B.h=H0(B.h,"Y",J);if(B.fontSize=B.fontSize||k2,B.margin=B.margin===0||B.margin?B.margin:KJ,typeof B.margin==="number")B.margin=[Number(B.margin),Number(B.margin),Number(B.margin),Number(B.margin)];if(JSON.stringify({arrRows:V}).indexOf("hyperlink")===-1){if(!B.color)B.color=B.color||Q2}if(typeof B.border==="string")console.warn("addTable `border` option must be an object. Ex: `{border: {type:'none'}}`"),B.border=null;else if(Array.isArray(B.border))[0,1,2,3].forEach((F)=>{B.border[F]=B.border[F]?{type:B.border[F].type||H6.type,color:B.border[F].color||H6.color,pt:B.border[F].pt||H6.pt}:{type:"none"}});if(B.autoPage=typeof B.autoPage==="boolean"?B.autoPage:!1,B.autoPageRepeatHeader=typeof B.autoPageRepeatHeader==="boolean"?B.autoPageRepeatHeader:!1,B.autoPageHeaderRows=typeof B.autoPageHeaderRows<"u"&&!isNaN(Number(B.autoPageHeaderRows))?Number(B.autoPageHeaderRows):1,B.autoPageLineWeight=typeof B.autoPageLineWeight<"u"&&!isNaN(Number(B.autoPageLineWeight))?Number(B.autoPageLineWeight):0,B.autoPageLineWeight){if(B.autoPageLineWeight>1)B.autoPageLineWeight=1;else if(B.autoPageLineWeight<-1)B.autoPageLineWeight=-1}let U=M8;if(K&&typeof K._margin<"u"){if(Array.isArray(K._margin))U=K._margin;else if(!isNaN(Number(K._margin)))U=[Number(K._margin),Number(K._margin),Number(K._margin),Number(K._margin)]}if(B.colW){let F=V[0].reduce((M,k)=>{var f;if(((f=k===null||k===void 0?void 0:k.options)===null||f===void 0?void 0:f.colspan)&&typeof k.options.colspan==="number")M+=k.options.colspan;else M+=1;return M},0);if(typeof B.colW==="string"||typeof B.colW==="number")B.w=Math.floor(Number(B.colW)*F),B.colW=null;else if(B.colW&&Array.isArray(B.colW)&&B.colW.length===1&&F>1)B.w=Math.floor(Number(B.colW)*F),B.colW=null;else if(B.colW&&Array.isArray(B.colW)&&B.colW.length!==F)console.warn("addTable: mismatch: (colW.length != data.length) Therefore, defaulting to evenly distributed col widths."),B.colW=null}else if(B.w)B.w=H0(B.w,"X",J);else B.w=Math.floor(J._sizeW/L0-U[1]-U[3]);if(B.x&&B.x<20)B.x=v0(B.x);if(B.y&&B.y<20)B.y=v0(B.y);if(B.w&&typeof B.w==="number"&&B.w<20)B.w=v0(B.w);if(B.h&&typeof B.h==="number"&&B.h<20)B.h=v0(B.h);V.forEach((F)=>{F.forEach((M,k)=>{if(typeof M==="number"||typeof M==="string")F[k]={_type:D0.tablecell,text:String(F[k]),options:B};else if(typeof M==="object"){if(typeof M.text==="number")F[k].text=F[k].text.toString();else if(typeof M.text>"u"||M.text===null)F[k].text="";F[k].options=M.options||{},F[k]._type=D0.tablecell}})});let w=[];if(B&&!B.autoPage)g6($,V),$._slideObjects.push({_type:D0.table,arrTabRows:V,options:Object.assign({},B)});else{if(B.autoPageRepeatHeader)B._arrObjTabHeadRows=V.filter((F,M)=>M<B.autoPageHeaderRows);ZJ(V,B,J,K).forEach((F,M)=>{if(!G($._slideNum+M))W.push(Z({masterName:(K===null||K===void 0?void 0:K._name)||null}));if(M>0)B.y=v0(B.autoPageSlideStartY||B.newSlideStartY||U[0]);{let k=G($._slideNum+M);if(B.autoPage=!1,g6(k,F.rows),k.addTable(F.rows,Object.assign({},B)),M>0)w.push(k)}})}return w}function L5($,q,Q,K){let J={_type:K?D0.placeholder:D0.text,shape:(Q===null||Q===void 0?void 0:Q.shape)||B1.RECTANGLE,text:!q||q.length===0?[{text:"",options:null}]:q,options:Q||{}};function Z(G){{if(!G.placeholder)G.color=G.color||J.options.color||$.color||Q2;if(G.placeholder||K)G.bullet=G.bullet||!1;if(G.placeholder&&$._slideLayout&&$._slideLayout._slideObjects){let W=$._slideLayout._slideObjects.filter((B)=>B._type==="placeholder"&&B.options&&B.options.placeholder&&B.options.placeholder===G.placeholder)[0];if(W===null||W===void 0?void 0:W.options)G=Object.assign(Object.assign({},G),W.options)}if(G.objectName=G.objectName?k0(G.objectName):`Text ${$._slideObjects.filter((W)=>W._type===D0.text).length}`,G.shape===B1.LINE){let W={type:G.line.type||"solid",color:G.line.color||JJ,transparency:G.line.transparency||0,width:G.line.width||1,dashType:G.line.dashType||"solid",beginArrowType:G.line.beginArrowType||null,endArrowType:G.line.endArrowType||null};if(typeof G.line==="object")G.line=W;if(typeof G.line==="string"){let B=W;if(typeof G.line==="string")B.color=G.line;G.line=B}if(typeof G.lineSize==="number")G.line.width=G.lineSize;if(typeof G.lineDash==="string")G.line.dashType=G.lineDash;if(typeof G.lineHead==="string")G.line.beginArrowType=G.lineHead;if(typeof G.lineTail==="string")G.line.endArrowType=G.lineTail}if(G.line=G.line||{},G.lineSpacing=G.lineSpacing&&!isNaN(G.lineSpacing)?G.lineSpacing:null,G.lineSpacingMultiple=G.lineSpacingMultiple&&!isNaN(G.lineSpacingMultiple)?G.lineSpacingMultiple:null,G._bodyProp=G._bodyProp||{},G._bodyProp.autoFit=G.autoFit||!1,G._bodyProp.anchor=!G.placeholder?I6.ctr:null,G._bodyProp.vert=G.vert||null,G._bodyProp.wrap=typeof G.wrap==="boolean"?G.wrap:!0,G.inset&&!isNaN(Number(G.inset))||G.inset===0)G._bodyProp.lIns=v0(G.inset),G._bodyProp.rIns=v0(G.inset),G._bodyProp.tIns=v0(G.inset),G._bodyProp.bIns=v0(G.inset);if(typeof G.underline==="boolean"&&G.underline===!0)G.underline={style:"sng"}}{if((G.align||"").toLowerCase().indexOf("c")===0)G._bodyProp.align=R6.center;else if((G.align||"").toLowerCase().indexOf("l")===0)G._bodyProp.align=R6.left;else if((G.align||"").toLowerCase().indexOf("r")===0)G._bodyProp.align=R6.right;else if((G.align||"").toLowerCase().indexOf("j")===0)G._bodyProp.align=R6.justify;if((G.valign||"").toLowerCase().indexOf("b")===0)G._bodyProp.anchor=I6.b;else if((G.valign||"").toLowerCase().indexOf("m")===0)G._bodyProp.anchor=I6.ctr;else if((G.valign||"").toLowerCase().indexOf("t")===0)G._bodyProp.anchor=I6.t}return c7(G.shadow),G}J.options=Z(J.options),J.text.forEach((G)=>G.options=Z(G.options||{})),g6($,J.text||""),$._slideObjects.push(J)}function CB($){($._slideLayout._slideObjects||[]).forEach((q)=>{if(q._type===D0.placeholder){if($._slideObjects.filter((Q)=>Q.options&&Q.options.placeholder===q.options.placeholder).length===0)L5($,[{text:""}],q.options,!1)}})}function BJ($,q){var Q;if(q.bkgd){if(!q.background)q.background={};if(typeof q.bkgd==="string")q.background.color=q.bkgd;else{if(q.bkgd.data)q.background.data=q.bkgd.data;if(q.bkgd.path)q.background.path=q.bkgd.path;if(q.bkgd.src)q.background.path=q.bkgd.src}}if((Q=q.background)===null||Q===void 0?void 0:Q.fill)q.background.color=q.background.fill;if($&&($.path||$.data)){$.path=$.path||"preencoded.png";let K=($.path.split(".").pop()||"png").split("?")[0];if(K==="jpg")K="jpeg";q._relsMedia=q._relsMedia||[];let J=q._relsMedia.length+1;q._relsMedia.push({path:$.path,type:D0.image,extn:K,data:$.data||null,rId:J,Target:`../media/${(q._name||"").replace(/\s+/gi,"-")}-image-${q._relsMedia.length+1}.${K}`}),q._bkgdImgRid=J}}function g6($,q,Q){let K=[];if(typeof q==="string"||typeof q==="number")return;else if(Array.isArray(q))K=q;else if(typeof q==="object")K=[q];K.forEach((J,Z)=>{if(Q&&Q[Z]&&Q[Z].hyperlink)J.options=Object.assign(Object.assign({},J.options),Q[Z]);if(Array.isArray(J)){let G=[];J.forEach((W)=>{if(W.options&&!W.text.options)G.push(W.options)}),g6($,J,G)}else if(Array.isArray(J.text))g6($,J.text,Q&&Q[Z]?[Q[Z]]:void 0);else if(J&&typeof J==="object"&&J.options&&J.options.hyperlink&&!J.options.hyperlink._rId)if(typeof J.options.hyperlink!=="object")console.log("ERROR: text `hyperlink` option should be an object. Ex: `hyperlink: {url:'https://github.com'}` ");else if(!J.options.hyperlink.url&&!J.options.hyperlink.slide)console.log("ERROR: 'hyperlink requires either: `url` or `slide`'");else{let G=a2($);$._rels.push({type:D0.hyperlink,data:J.options.hyperlink.slide?"slide":"dummy",rId:G,Target:k0(J.options.hyperlink.url)||J.options.hyperlink.slide.toString()}),J.options.hyperlink._rId=G}else if(J&&typeof J==="object"&&J.options&&J.options.hyperlink&&J.options.hyperlink._rId){if($._rels.filter((G)=>G.rId===J.options.hyperlink._rId).length===0)$._rels.push({type:D0.hyperlink,data:J.options.hyperlink.slide?"slide":"dummy",rId:J.options.hyperlink._rId,Target:k0(J.options.hyperlink.url)||J.options.hyperlink.slide.toString()})}})}class zJ{constructor($){var q;this.addSlide=$.addSlide,this.getSlide=$.getSlide,this._name=`Slide ${$.slideNumber}`,this._presLayout=$.presLayout,this._rId=$.slideRId,this._rels=[],this._relsChart=[],this._relsMedia=[],this._setSlideNum=$.setSlideNum,this._slideId=$.slideId,this._slideLayout=$.slideLayout||null,this._slideNum=$.slideNumber,this._slideObjects=[],this._slideNumberProps=((q=this._slideLayout)===null||q===void 0?void 0:q._slideNumberProps)?this._slideLayout._slideNumberProps:null}set bkgd($){if(this._bkgd=$,!this._background||!this._background.color){if(!this._background)this._background={};if(typeof $==="string")this._background.color=$}}get bkgd(){return this._bkgd}set background($){if(this._background=$,$)BJ($,this)}get background(){return this._background}set color($){this._color=$}get color(){return this._color}set hidden($){this._hidden=$}get hidden(){return this._hidden}set slideNumber($){this._slideNumberProps=$,this._setSlideNum($)}get slideNumber(){return this._slideNumberProps}get newAutoPagedSlides(){return this._newAutoPagedSlides}addChart($,q,Q){let K=Q||{};return K._type=$,GJ(this,$,q,Q),this}addImage($){return WJ(this,$),this}addMedia($){return fB(this,$),this}addNotes($){return RB(this,$),this}addShape($,q){return E7(this,$,q),this}addTable($,q){return this._newAutoPagedSlides=IB(this,$,q,this._slideLayout,this._presLayout,this.addSlide,this.getSlide),this}addText($,q){return L5(this,typeof $==="string"||typeof $==="number"?[{text:$,options:q}]:$,q,!1),this}}function jB($,q){return W2(this,void 0,void 0,function*(){let Q=$.data;return yield new Promise((K,J)=>{var Z,G;let W=new _7.default,B=(Q.length-1)*2+1,V=((G=(Z=Q[0])===null||Z===void 0?void 0:Z.labels)===null||G===void 0?void 0:G.length)>1;W.folder("_rels"),W.folder("docProps"),W.folder("xl/_rels"),W.folder("xl/tables"),W.folder("xl/theme"),W.folder("xl/worksheets"),W.folder("xl/worksheets/_rels"),W.file("[Content_Types].xml",'<?xml version="1.0" encoding="UTF-8" standalone="yes"?><Types xmlns="http://schemas.openxmlformats.org/package/2006/content-types"> <Default Extension="rels" ContentType="application/vnd.openxmlformats-package.relationships+xml"/> <Default Extension="xml" ContentType="application/xml"/> <Override PartName="/xl/workbook.xml" ContentType="application/vnd.openxmlformats-officedocument.spreadsheetml.sheet.main+xml"/> <Override PartName="/xl/worksheets/sheet1.xml" ContentType="application/vnd.openxmlformats-officedocument.spreadsheetml.worksheet+xml"/> <Override PartName="/xl/theme/theme1.xml" ContentType="application/vnd.openxmlformats-officedocument.theme+xml"/> <Override PartName="/xl/styles.xml" ContentType="application/vnd.openxmlformats-officedocument.spreadsheetml.styles+xml"/> <Override PartName="/xl/sharedStrings.xml" ContentType="application/vnd.openxmlformats-officedocument.spreadsheetml.sharedStrings+xml"/> <Override PartName="/xl/tables/table1.xml" ContentType="application/vnd.openxmlformats-officedocument.spreadsheetml.table+xml"/> <Override PartName="/docProps/core.xml" ContentType="application/vnd.openxmlformats-package.core-properties+xml"/> <Override PartName="/docProps/app.xml" ContentType="application/vnd.openxmlformats-officedocument.extended-properties+xml"/></Types>\n'),W.file("_rels/.rels",`<?xml version="1.0" encoding="UTF-8" standalone="yes"?><Relationships xmlns="http://schemas.openxmlformats.org/package/2006/relationships"><Relationship Id="rId1" Type="http://schemas.openxmlformats.org/package/2006/relationships/metadata/core-properties" Target="docProps/core.xml"/><Relationship Id="rId2" Type="http://schemas.openxmlformats.org/officeDocument/2006/relationships/extended-properties" Target="docProps/app.xml"/><Relationship Id="rId3" Type="http://schemas.openxmlformats.org/officeDocument/2006/relationships/officeDocument" Target="xl/workbook.xml"/></Relationships> |
| 27 | `),W.file("docProps/app.xml",`<?xml version="1.0" encoding="UTF-8" standalone="yes"?><Properties xmlns="http://schemas.openxmlformats.org/officeDocument/2006/extended-properties" xmlns:vt="http://schemas.openxmlformats.org/officeDocument/2006/docPropsVTypes"><Application>Microsoft Macintosh Excel</Application><DocSecurity>0</DocSecurity><ScaleCrop>false</ScaleCrop><HeadingPairs><vt:vector size="2" baseType="variant"><vt:variant><vt:lpstr>Worksheets</vt:lpstr></vt:variant><vt:variant><vt:i4>1</vt:i4></vt:variant></vt:vector></HeadingPairs><TitlesOfParts><vt:vector size="1" baseType="lpstr"><vt:lpstr>Sheet1</vt:lpstr></vt:vector></TitlesOfParts><Company></Company><LinksUpToDate>false</LinksUpToDate><SharedDoc>false</SharedDoc><HyperlinksChanged>false</HyperlinksChanged><AppVersion>16.0300</AppVersion></Properties> |
| 28 | `),W.file("docProps/core.xml",'<?xml version="1.0" encoding="UTF-8" standalone="yes"?><cp:coreProperties xmlns:cp="http://schemas.openxmlformats.org/package/2006/metadata/core-properties" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:dcterms="http://purl.org/dc/terms/" xmlns:dcmitype="http://purl.org/dc/dcmitype/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"><dc:creator>PptxGenJS</dc:creator><cp:lastModifiedBy>PptxGenJS</cp:lastModifiedBy><dcterms:created xsi:type="dcterms:W3CDTF">'+new Date().toISOString()+'</dcterms:created><dcterms:modified xsi:type="dcterms:W3CDTF">'+new Date().toISOString()+"</dcterms:modified></cp:coreProperties>"),W.file("xl/_rels/workbook.xml.rels",'<?xml version="1.0" encoding="UTF-8" standalone="yes"?><Relationships xmlns="http://schemas.openxmlformats.org/package/2006/relationships"><Relationship Id="rId3" Type="http://schemas.openxmlformats.org/officeDocument/2006/relationships/styles" Target="styles.xml"/><Relationship Id="rId2" Type="http://schemas.openxmlformats.org/officeDocument/2006/relationships/theme" Target="theme/theme1.xml"/><Relationship Id="rId1" Type="http://schemas.openxmlformats.org/officeDocument/2006/relationships/worksheet" Target="worksheets/sheet1.xml"/><Relationship Id="rId4" Type="http://schemas.openxmlformats.org/officeDocument/2006/relationships/sharedStrings" Target="sharedStrings.xml"/></Relationships>'),W.file("xl/styles.xml",'<?xml version="1.0" encoding="UTF-8" standalone="yes"?><styleSheet xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main"><numFmts count="1"><numFmt numFmtId="0" formatCode="General"/></numFmts><fonts count="4"><font><sz val="9"/><color indexed="8"/><name val="Geneva"/></font><font><sz val="9"/><color indexed="8"/><name val="Geneva"/></font><font><sz val="10"/><color indexed="8"/><name val="Geneva"/></font><font><sz val="18"/><color indexed="8"/><name val="Arial"/></font></fonts><fills count="2"><fill><patternFill patternType="none"/></fill><fill><patternFill patternType="gray125"/></fill></fills><borders count="1"><border><left/><right/><top/><bottom/><diagonal/></border></borders><dxfs count="0"/><tableStyles count="0"/><colors><indexedColors><rgbColor rgb="ff000000"/><rgbColor rgb="ffffffff"/><rgbColor rgb="ffff0000"/><rgbColor rgb="ff00ff00"/><rgbColor rgb="ff0000ff"/><rgbColor rgb="ffffff00"/><rgbColor rgb="ffff00ff"/><rgbColor rgb="ff00ffff"/><rgbColor rgb="ff000000"/><rgbColor rgb="ffffffff"/><rgbColor rgb="ff878787"/><rgbColor rgb="fff9f9f9"/></indexedColors></colors></styleSheet>\n'),W.file("xl/theme/theme1.xml",'<?xml version="1.0" encoding="UTF-8" standalone="yes"?><a:theme xmlns:a="http://schemas.openxmlformats.org/drawingml/2006/main" name="Office Theme"><a:themeElements><a:clrScheme name="Office"><a:dk1><a:sysClr val="windowText" lastClr="000000"/></a:dk1><a:lt1><a:sysClr val="window" lastClr="FFFFFF"/></a:lt1><a:dk2><a:srgbClr val="44546A"/></a:dk2><a:lt2><a:srgbClr val="E7E6E6"/></a:lt2><a:accent1><a:srgbClr val="4472C4"/></a:accent1><a:accent2><a:srgbClr val="ED7D31"/></a:accent2><a:accent3><a:srgbClr val="A5A5A5"/></a:accent3><a:accent4><a:srgbClr val="FFC000"/></a:accent4><a:accent5><a:srgbClr val="5B9BD5"/></a:accent5><a:accent6><a:srgbClr val="70AD47"/></a:accent6><a:hlink><a:srgbClr val="0563C1"/></a:hlink><a:folHlink><a:srgbClr val="954F72"/></a:folHlink></a:clrScheme><a:fontScheme name="Office"><a:majorFont><a:latin typeface="Calibri Light" panose="020F0302020204030204"/><a:ea typeface=""/><a:cs typeface=""/><a:font script="Jpan" typeface="Yu Gothic Light"/><a:font script="Hang" typeface="맑은 고딕"/><a:font script="Hans" typeface="DengXian Light"/><a:font script="Hant" typeface="新細明體"/><a:font script="Arab" typeface="Times New Roman"/><a:font script="Hebr" typeface="Times New Roman"/><a:font script="Thai" typeface="Tahoma"/><a:font script="Ethi" typeface="Nyala"/><a:font script="Beng" typeface="Vrinda"/><a:font script="Gujr" typeface="Shruti"/><a:font script="Khmr" typeface="MoolBoran"/><a:font script="Knda" typeface="Tunga"/><a:font script="Guru" typeface="Raavi"/><a:font script="Cans" typeface="Euphemia"/><a:font script="Cher" typeface="Plantagenet Cherokee"/><a:font script="Yiii" typeface="Microsoft Yi Baiti"/><a:font script="Tibt" typeface="Microsoft Himalaya"/><a:font script="Thaa" typeface="MV Boli"/><a:font script="Deva" typeface="Mangal"/><a:font script="Telu" typeface="Gautami"/><a:font script="Taml" typeface="Latha"/><a:font script="Syrc" typeface="Estrangelo Edessa"/><a:font script="Orya" typeface="Kalinga"/><a:font script="Mlym" typeface="Kartika"/><a:font script="Laoo" typeface="DokChampa"/><a:font script="Sinh" typeface="Iskoola Pota"/><a:font script="Mong" typeface="Mongolian Baiti"/><a:font script="Viet" typeface="Times New Roman"/><a:font script="Uigh" typeface="Microsoft Uighur"/><a:font script="Geor" typeface="Sylfaen"/></a:majorFont><a:minorFont><a:latin typeface="Calibri" panose="020F0502020204030204"/><a:ea typeface=""/><a:cs typeface=""/><a:font script="Jpan" typeface="Yu Gothic"/><a:font script="Hang" typeface="맑은 고딕"/><a:font script="Hans" typeface="DengXian"/><a:font script="Hant" typeface="新細明體"/><a:font script="Arab" typeface="Arial"/><a:font script="Hebr" typeface="Arial"/><a:font script="Thai" typeface="Tahoma"/><a:font script="Ethi" typeface="Nyala"/><a:font script="Beng" typeface="Vrinda"/><a:font script="Gujr" typeface="Shruti"/><a:font script="Khmr" typeface="DaunPenh"/><a:font script="Knda" typeface="Tunga"/><a:font script="Guru" typeface="Raavi"/><a:font script="Cans" typeface="Euphemia"/><a:font script="Cher" typeface="Plantagenet Cherokee"/><a:font script="Yiii" typeface="Microsoft Yi Baiti"/><a:font script="Tibt" typeface="Microsoft Himalaya"/><a:font script="Thaa" typeface="MV Boli"/><a:font script="Deva" typeface="Mangal"/><a:font script="Telu" typeface="Gautami"/><a:font script="Taml" typeface="Latha"/><a:font script="Syrc" typeface="Estrangelo Edessa"/><a:font script="Orya" typeface="Kalinga"/><a:font script="Mlym" typeface="Kartika"/><a:font script="Laoo" typeface="DokChampa"/><a:font script="Sinh" typeface="Iskoola Pota"/><a:font script="Mong" typeface="Mongolian Baiti"/><a:font script="Viet" typeface="Arial"/><a:font script="Uigh" typeface="Microsoft Uighur"/><a:font script="Geor" typeface="Sylfaen"/></a:minorFont></a:fontScheme><a:fmtScheme name="Office"><a:fillStyleLst><a:solidFill><a:schemeClr val="phClr"/></a:solidFill><a:gradFill rotWithShape="1"><a:gsLst><a:gs pos="0"><a:schemeClr val="phClr"><a:lumMod val="110000"/><a:satMod val="105000"/><a:tint val="67000"/></a:schemeClr></a:gs><a:gs pos="50000"><a:schemeClr val="phClr"><a:lumMod val="105000"/><a:satMod val="103000"/><a:tint val="73000"/></a:schemeClr></a:gs><a:gs pos="100000"><a:schemeClr val="phClr"><a:lumMod val="105000"/><a:satMod val="109000"/><a:tint val="81000"/></a:schemeClr></a:gs></a:gsLst><a:lin ang="5400000" scaled="0"/></a:gradFill><a:gradFill rotWithShape="1"><a:gsLst><a:gs pos="0"><a:schemeClr val="phClr"><a:satMod val="103000"/><a:lumMod val="102000"/><a:tint val="94000"/></a:schemeClr></a:gs><a:gs pos="50000"><a:schemeClr val="phClr"><a:satMod val="110000"/><a:lumMod val="100000"/><a:shade val="100000"/></a:schemeClr></a:gs><a:gs pos="100000"><a:schemeClr val="phClr"><a:lumMod val="99000"/><a:satMod val="120000"/><a:shade val="78000"/></a:schemeClr></a:gs></a:gsLst><a:lin ang="5400000" scaled="0"/></a:gradFill></a:fillStyleLst><a:lnStyleLst><a:ln w="6350" cap="flat" cmpd="sng" algn="ctr"><a:solidFill><a:schemeClr val="phClr"/></a:solidFill><a:prstDash val="solid"/><a:miter lim="800000"/></a:ln><a:ln w="12700" cap="flat" cmpd="sng" algn="ctr"><a:solidFill><a:schemeClr val="phClr"/></a:solidFill><a:prstDash val="solid"/><a:miter lim="800000"/></a:ln><a:ln w="19050" cap="flat" cmpd="sng" algn="ctr"><a:solidFill><a:schemeClr val="phClr"/></a:solidFill><a:prstDash val="solid"/><a:miter lim="800000"/></a:ln></a:lnStyleLst><a:effectStyleLst><a:effectStyle><a:effectLst/></a:effectStyle><a:effectStyle><a:effectLst/></a:effectStyle><a:effectStyle><a:effectLst><a:outerShdw blurRad="57150" dist="19050" dir="5400000" algn="ctr" rotWithShape="0"><a:srgbClr val="000000"><a:alpha val="63000"/></a:srgbClr></a:outerShdw></a:effectLst></a:effectStyle></a:effectStyleLst><a:bgFillStyleLst><a:solidFill><a:schemeClr val="phClr"/></a:solidFill><a:solidFill><a:schemeClr val="phClr"><a:tint val="95000"/><a:satMod val="170000"/></a:schemeClr></a:solidFill><a:gradFill rotWithShape="1"><a:gsLst><a:gs pos="0"><a:schemeClr val="phClr"><a:tint val="93000"/><a:satMod val="150000"/><a:shade val="98000"/><a:lumMod val="102000"/></a:schemeClr></a:gs><a:gs pos="50000"><a:schemeClr val="phClr"><a:tint val="98000"/><a:satMod val="130000"/><a:shade val="90000"/><a:lumMod val="103000"/></a:schemeClr></a:gs><a:gs pos="100000"><a:schemeClr val="phClr"><a:shade val="63000"/><a:satMod val="120000"/></a:schemeClr></a:gs></a:gsLst><a:lin ang="5400000" scaled="0"/></a:gradFill></a:bgFillStyleLst></a:fmtScheme></a:themeElements><a:objectDefaults/><a:extraClrSchemeLst/><a:extLst><a:ext uri="{05A4C25C-085E-4340-85A3-A5531E510DB2}"><thm15:themeFamily xmlns:thm15="http://schemas.microsoft.com/office/thememl/2012/main" name="Office Theme" id="{62F939B6-93AF-4DB8-9C6B-D6C7DFDC589F}" vid="{4A3C46E8-61CC-4603-A589-7422A47A8E4A}"/></a:ext></a:extLst></a:theme>'),W.file("xl/workbook.xml",`<?xml version="1.0" encoding="UTF-8" standalone="yes"?><workbook xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main" xmlns:r="http://schemas.openxmlformats.org/officeDocument/2006/relationships" xmlns:mc="http://schemas.openxmlformats.org/markup-compatibility/2006" mc:Ignorable="x15" xmlns:x15="http://schemas.microsoft.com/office/spreadsheetml/2010/11/main"><fileVersion appName="xl" lastEdited="7" lowestEdited="6" rupBuild="10507"/><workbookPr/><bookViews><workbookView xWindow="0" yWindow="500" windowWidth="20960" windowHeight="15960"/></bookViews><sheets><sheet name="Sheet1" sheetId="1" r:id="rId1"/></sheets><calcPr calcId="0" concurrentCalc="0"/></workbook> |
| 29 | `),W.file("xl/worksheets/_rels/sheet1.xml.rels",`<?xml version="1.0" encoding="UTF-8" standalone="yes"?><Relationships xmlns="http://schemas.openxmlformats.org/package/2006/relationships"><Relationship Id="rId1" Type="http://schemas.openxmlformats.org/officeDocument/2006/relationships/table" Target="../tables/table1.xml"/></Relationships> |
| 30 | `);{let U='<?xml version="1.0" encoding="UTF-8" standalone="yes"?>';if($.opts._type===q0.BUBBLE||$.opts._type===q0.BUBBLE3D)U+=`<sst xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main" count="${B}" uniqueCount="${B}">`;else if($.opts._type===q0.SCATTER)U+=`<sst xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main" count="${Q.length}" uniqueCount="${Q.length}">`;else if(V){let w=Q.length;Q[0].labels.forEach((F)=>w+=F.filter((M)=>M&&M!=="").length),U+=`<sst xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main" count="${w}" uniqueCount="${w}">`,U+="<si><t/></si>"}else{let w=Q.length+Q[0].labels.length*Q[0].labels[0].length+Q[0].labels.length,F=Q.length+Q[0].labels.length*Q[0].labels[0].length+1;U+=`<sst xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main" count="${w}" uniqueCount="${F}">`,U+='<si><t xml:space="preserve"></t></si>'}if($.opts._type===q0.BUBBLE||$.opts._type===q0.BUBBLE3D)Q.forEach((w,F)=>{if(F===0)U+="<si><t>X-Axis</t></si>";else U+=`<si><t>${k0(w.name||`Y-Axis${F}`)}</t></si>`,U+=`<si><t>${k0(`Size${F}`)}</t></si>`});else Q.forEach((w)=>{U+=`<si><t>${k0((w.name||" ").replace("X-Axis","X-Values"))}</t></si>`});if($.opts._type!==q0.BUBBLE&&$.opts._type!==q0.BUBBLE3D&&$.opts._type!==q0.SCATTER)Q[0].labels.slice().reverse().forEach((w)=>{w.filter((F)=>F&&F!=="").forEach((F)=>{U+=`<si><t>${k0(F)}</t></si>`})});U+=`</sst> |
| 31 | `,W.file("xl/sharedStrings.xml",U)}{let U='<?xml version="1.0" encoding="UTF-8" standalone="yes"?>';if($.opts._type===q0.BUBBLE||$.opts._type===q0.BUBBLE3D){U+=`<table xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main" id="1" name="Table1" displayName="Table1" ref="A1:${j0(B)}${B}" totalsRowShown="0">`,U+=`<tableColumns count="${B}">`;let w=1;Q.forEach((F,M)=>{if(M===0)U+=`<tableColumn id="${M+1}" name="X-Values"/>`;else U+=`<tableColumn id="${M+w}" name="${F.name}"/>`,w++,U+=`<tableColumn id="${M+w}" name="Size${M}"/>`})}else if($.opts._type===q0.SCATTER)U+=`<table xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main" id="1" name="Table1" displayName="Table1" ref="A1:${j0(Q.length)}${Q[0].values.length+1}" totalsRowShown="0">`,U+=`<tableColumns count="${Q.length}">`,Q.forEach((w,F)=>{U+=`<tableColumn id="${F+1}" name="${F===0?"X-Values":"Y-Value "}${F}"/>`});else U+=`<table xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main" id="1" name="Table1" displayName="Table1" ref="A1:${j0(Q.length+Q[0].labels.length)}${Q[0].labels[0].length+1}'" totalsRowShown="0">`,U+=`<tableColumns count="${Q.length+Q[0].labels.length}">`,Q[0].labels.forEach((w,F)=>{U+=`<tableColumn id="${F+1}" name="Column${F+1}"/>`}),Q.forEach((w,F)=>{U+=`<tableColumn id="${F+Q[0].labels.length+1}" name="${k0(w.name)}"/>`});U+="</tableColumns>",U+='<tableStyleInfo showFirstColumn="0" showLastColumn="0" showRowStripes="1" showColumnStripes="0"/>',U+="</table>",W.file("xl/tables/table1.xml",U)}{let U='<?xml version="1.0" encoding="UTF-8" standalone="yes"?>';if(U+='<worksheet xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main" xmlns:r="http://schemas.openxmlformats.org/officeDocument/2006/relationships" xmlns:mc="http://schemas.openxmlformats.org/markup-compatibility/2006" mc:Ignorable="x14ac" xmlns:x14ac="http://schemas.microsoft.com/office/spreadsheetml/2009/9/ac">',$.opts._type===q0.BUBBLE||$.opts._type===q0.BUBBLE3D)U+=`<dimension ref="A1:${j0(B)}${Q[0].values.length+1}"/>`;else if($.opts._type===q0.SCATTER)U+=`<dimension ref="A1:${j0(Q.length)}${Q[0].values.length+1}"/>`;else U+=`<dimension ref="A1:${j0(Q.length+1)}${Q[0].values.length+1}"/>`;if(U+='<sheetViews><sheetView tabSelected="1" workbookViewId="0"><selection activeCell="B1" sqref="B1"/></sheetView></sheetViews>',U+='<sheetFormatPr baseColWidth="10" defaultRowHeight="16"/>',$.opts._type===q0.BUBBLE||$.opts._type===q0.BUBBLE3D){U+="<sheetData>",U+=`<row r="1" spans="1:${B}">`,U+='<c r="A1" t="s"><v>0</v></c>';for(let w=1;w<B;w++)U+=`<c r="${j0(w+1)}1" t="s"><v>${w}</v></c>`;U+="</row>",Q[0].values.forEach((w,F)=>{U+=`<row r="${F+2}" spans="1:${B}">`,U+=`<c r="A${F+2}"><v>${w}</v></c>`;let M=2;for(let k=1;k<Q.length;k++)U+=`<c r="${j0(M)}${F+2}"><v>${Q[k].values[F]||""}</v></c>`,M++,U+=`<c r="${j0(M)}${F+2}"><v>${Q[k].sizes[F]||""}</v></c>`,M++;U+="</row>"})}else if($.opts._type===q0.SCATTER){U+="<sheetData>",U+=`<row r="1" spans="1:${Q.length}">`;for(let w=0;w<Q.length;w++)U+=`<c r="${j0(w+1)}1" t="s"><v>${w}</v></c>`;U+="</row>",Q[0].values.forEach((w,F)=>{U+=`<row r="${F+2}" spans="1:${Q.length}">`,U+=`<c r="A${F+2}"><v>${w}</v></c>`;for(let M=1;M<Q.length;M++)U+=`<c r="${j0(M+1)}${F+2}"><v>${Q[M].values[F]||Q[M].values[F]===0?Q[M].values[F]:""}</v></c>`;U+="</row>"})}else if(U+="<sheetData>",!V){U+=`<row r="1" spans="1:${Q.length+Q[0].labels.length}">`,Q[0].labels.forEach((w,F)=>{U+=`<c r="${j0(F+1)}1" t="s"><v>0</v></c>`});for(let w=0;w<Q.length;w++)U+=`<c r="${j0(w+1+Q[0].labels.length)}1" t="s"><v>${w+1}</v></c>`;U+="</row>",Q[0].labels[0].forEach((w,F)=>{U+=`<row r="${F+2}" spans="1:${Q.length+Q[0].labels.length}">`;for(let M=Q[0].labels.length-1;M>=0;M--)U+=`<c r="${j0(Q[0].labels.length-M)}${F+2}" t="s">`,U+=`<v>${Q.length+F+1}</v>`,U+="</c>";for(let M=0;M<Q.length;M++)U+=`<c r="${j0(Q[0].labels.length+M+1)}${F+2}"><v>${Q[M].values[F]||""}</v></c>`;U+="</row>"})}else{U+=`<row r="1" spans="1:${Q.length+Q[0].labels.length}">`;for(let k=0;k<Q[0].labels.length;k++)U+=`<c r="${j0(k+1)}1" t="s"><v>0</v></c>`;for(let k=Q[0].labels.length-1;k<Q.length+Q[0].labels.length-1;k++)U+=`<c r="${j0(k+Q[0].labels.length)}1" t="s"><v>${k}</v></c>`;U+="</row>";let w=Q.length,F=Q[0].labels[0].length,M=Q[0].labels.length;for(let k=0;k<F;k++){U+=`<row r="${k+2}" spans="1:${w+M}">`;let f=w,L=Q[0].labels.slice().reverse();L.forEach((D,z)=>{if(D[k]){let H=z===0?1:L[z-1].filter((v)=>v&&v!=="").length;f+=H,U+=`<c r="${j0(k+1+z)}${k+2}" t="s"><v>${f}</v></c>`}});for(let D=0;D<w;D++)U+=`<c r="${j0(M+D+1)}${k+2}"><v>${Q[D].values[k]||0}</v></c>`;U+="</row>"}}U+="</sheetData>",U+='<pageMargins left="0.7" right="0.7" top="0.75" bottom="0.75" header="0.3" footer="0.3"/>',U+=`</worksheet> |
| 32 | `,W.file("xl/worksheets/sheet1.xml",U)}W.generateAsync({type:"base64"}).then((U)=>{q.file(`ppt/embeddings/Microsoft_Excel_Worksheet${$.globalId}.xlsx`,U,{base64:!0}),q.file("ppt/charts/_rels/"+$.fileName+".rels",`<?xml version="1.0" encoding="UTF-8" standalone="yes"?><Relationships xmlns="http://schemas.openxmlformats.org/package/2006/relationships"><Relationship Id="rId1" Type="http://schemas.openxmlformats.org/officeDocument/2006/relationships/package" Target="../embeddings/Microsoft_Excel_Worksheet${$.globalId}.xlsx"/></Relationships>`),q.file(`ppt/charts/${$.fileName}`,gB($)),K("")}).catch((U)=>{J(U)})})})}function gB($){var q,Q,K,J;let Z='<?xml version="1.0" encoding="UTF-8" standalone="yes"?>',G=!1;{if(Z+='<c:chartSpace xmlns:c="http://schemas.openxmlformats.org/drawingml/2006/chart" xmlns:a="http://schemas.openxmlformats.org/drawingml/2006/main" xmlns:r="http://schemas.openxmlformats.org/officeDocument/2006/relationships">',Z+='<c:date1904 val="0"/>',Z+=`<c:roundedCorners val="${$.opts.chartArea.roundedCorners?"1":"0"}"/>`,Z+="<c:chart>",$.opts.showTitle)Z+=H5({title:$.opts.title||"Chart Title",color:$.opts.titleColor,fontFace:$.opts.titleFontFace,fontSize:$.opts.titleFontSize||MB,titleAlign:$.opts.titleAlign,titleBold:$.opts.titleBold,titlePos:$.opts.titlePos,titleRotate:$.opts.titleRotate},$.opts.x,$.opts.y),Z+='<c:autoTitleDeleted val="0"/>';else Z+='<c:autoTitleDeleted val="1"/>';if($.opts._type===q0.BAR3D)Z+=`<c:view3D><c:rotX val="${$.opts.v3DRotX}"/><c:rotY val="${$.opts.v3DRotY}"/><c:rAngAx val="${!$.opts.v3DRAngAx?0:1}"/><c:perspective val="${$.opts.v3DPerspective}"/></c:view3D>`;if(Z+="<c:plotArea>",$.opts.layout)Z+="<c:layout>",Z+=" <c:manualLayout>",Z+=' <c:layoutTarget val="inner" />',Z+=' <c:xMode val="edge" />',Z+=' <c:yMode val="edge" />',Z+=' <c:x val="'+($.opts.layout.x||0)+'" />',Z+=' <c:y val="'+($.opts.layout.y||0)+'" />',Z+=' <c:w val="'+($.opts.layout.w||1)+'" />',Z+=' <c:h val="'+($.opts.layout.h||1)+'" />',Z+=" </c:manualLayout>",Z+="</c:layout>";else Z+="<c:layout/>"}if(Array.isArray($.opts._type))$.opts._type.forEach((W)=>{let B=Object.assign(Object.assign({},$.opts),W.options),V=B.secondaryValAxis?N5:o2,U=B.secondaryCatAxis?x7:B8;G=G||B.secondaryValAxis,Z+=eK(W.type,W.data,B,V,U)});else Z+=eK($.opts._type,$.data,$.opts,o2,B8);if($.opts._type!==q0.PIE&&$.opts._type!==q0.DOUGHNUT){if($.opts.valAxes&&$.opts.valAxes.length>1&&!G)throw Error("Secondary axis must be used by one of the multiple charts");if($.opts.catAxes){if(!$.opts.valAxes||$.opts.valAxes.length!==$.opts.catAxes.length)throw Error("There must be the same number of value and category axes.");Z+=A7(Object.assign(Object.assign({},$.opts),$.opts.catAxes[0]),B8,o2)}else Z+=A7($.opts,B8,o2);if($.opts.valAxes){if(Z+=X7(Object.assign(Object.assign({},$.opts),$.opts.valAxes[0]),o2),$.opts.valAxes[1])Z+=X7(Object.assign(Object.assign({},$.opts),$.opts.valAxes[1]),N5)}else if(Z+=X7($.opts,o2),$.opts._type===q0.BAR3D)Z+=AB($.opts,VJ,o2);if(((q=$.opts)===null||q===void 0?void 0:q.catAxes)&&((Q=$.opts)===null||Q===void 0?void 0:Q.catAxes[1]))Z+=A7(Object.assign(Object.assign({},$.opts),$.opts.catAxes[1]),x7,N5)}{if($.opts.showDataTable)Z+="<c:dTable>",Z+=` <c:showHorzBorder val="${!$.opts.showDataTableHorzBorder?0:1}"/>`,Z+=` <c:showVertBorder val="${!$.opts.showDataTableVertBorder?0:1}"/>`,Z+=` <c:showOutline val="${!$.opts.showDataTableOutline?0:1}"/>`,Z+=` <c:showKeys val="${!$.opts.showDataTableKeys?0:1}"/>`,Z+=" <c:spPr>",Z+=" <a:noFill/>",Z+=' <a:ln w="9525" cap="flat" cmpd="sng" algn="ctr"><a:solidFill><a:schemeClr val="tx1"><a:lumMod val="15000"/><a:lumOff val="85000"/></a:schemeClr></a:solidFill><a:round/></a:ln>',Z+=" <a:effectLst/>",Z+=" </c:spPr>",Z+=" <c:txPr>",Z+=' <a:bodyPr rot="0" spcFirstLastPara="1" vertOverflow="ellipsis" vert="horz" wrap="square" anchor="ctr" anchorCtr="1"/>',Z+=" <a:lstStyle/>",Z+=" <a:p>",Z+=' <a:pPr rtl="0">',Z+=` <a:defRPr sz="${Math.round(($.opts.dataTableFontSize||k2)*100)}" b="0" i="0" u="none" strike="noStrike" kern="1200" baseline="0">`,Z+=' <a:solidFill><a:schemeClr val="tx1"><a:lumMod val="65000"/><a:lumOff val="35000"/></a:schemeClr></a:solidFill>',Z+=' <a:latin typeface="+mn-lt"/>',Z+=' <a:ea typeface="+mn-ea"/>',Z+=' <a:cs typeface="+mn-cs"/>',Z+=" </a:defRPr>",Z+=" </a:pPr>",Z+=' <a:endParaRPr lang="en-US"/>',Z+=" </a:p>",Z+=" </c:txPr>",Z+="</c:dTable>";if(Z+=" <c:spPr>",Z+=((K=$.opts.plotArea.fill)===null||K===void 0?void 0:K.color)?B2($.opts.plotArea.fill):"<a:noFill/>",Z+=$.opts.plotArea.border?`<a:ln w="${Y0($.opts.plotArea.border.pt)}" cap="flat">${B2($.opts.plotArea.border.color)}</a:ln>`:"<a:ln><a:noFill/></a:ln>",Z+=" <a:effectLst/>",Z+=" </c:spPr>",Z+="</c:plotArea>",$.opts.showLegend){if(Z+="<c:legend>",Z+='<c:legendPos val="'+$.opts.legendPos+'"/>',Z+='<c:overlay val="0"/>',$.opts.legendFontFace||$.opts.legendFontSize||$.opts.legendColor){if(Z+="<c:txPr>",Z+=" <a:bodyPr/>",Z+=" <a:lstStyle/>",Z+=" <a:p>",Z+=" <a:pPr>",Z+=$.opts.legendFontSize?`<a:defRPr sz="${Math.round(Number($.opts.legendFontSize)*100)}">`:"<a:defRPr>",$.opts.legendColor)Z+=B2($.opts.legendColor);if($.opts.legendFontFace)Z+='<a:latin typeface="'+$.opts.legendFontFace+'"/>';if($.opts.legendFontFace)Z+='<a:cs typeface="'+$.opts.legendFontFace+'"/>';Z+=" </a:defRPr>",Z+=" </a:pPr>",Z+=' <a:endParaRPr lang="en-US"/>',Z+=" </a:p>",Z+="</c:txPr>"}Z+="</c:legend>"}}if(Z+=' <c:plotVisOnly val="1"/>',Z+=' <c:dispBlanksAs val="'+$.opts.displayBlanksAs+'"/>',$.opts._type===q0.SCATTER)Z+='<c:showDLblsOverMax val="1"/>';return Z+="</c:chart>",Z+="<c:spPr>",Z+=((J=$.opts.chartArea.fill)===null||J===void 0?void 0:J.color)?B2($.opts.chartArea.fill):"<a:noFill/>",Z+=$.opts.chartArea.border?`<a:ln w="${Y0($.opts.chartArea.border.pt)}" cap="flat">${B2($.opts.chartArea.border.color)}</a:ln>`:"<a:ln><a:noFill/></a:ln>",Z+=" <a:effectLst/>",Z+="</c:spPr>",Z+='<c:externalData r:id="rId1"><c:autoUpdate val="0"/></c:externalData>',Z+="</c:chartSpace>",Z}function eK($,q,Q,K,J,Z){let G=-1,W=1,B=null,V="";switch($){case q0.AREA:case q0.BAR:case q0.BAR3D:case q0.LINE:case q0.RADAR:if(V+=`<c:${$}Chart>`,$===q0.AREA&&Q.barGrouping==="stacked")V+='<c:grouping val="'+Q.barGrouping+'"/>';if($===q0.BAR||$===q0.BAR3D)V+='<c:barDir val="'+Q.barDir+'"/>',V+='<c:grouping val="'+(Q.barGrouping||"clustered")+'"/>';if($===q0.RADAR)V+='<c:radarStyle val="'+Q.radarStyle+'"/>';V+='<c:varyColors val="0"/>',q.forEach((U)=>{var w;G++,V+="<c:ser>",V+=` <c:idx val="${U._dataIndex}"/><c:order val="${U._dataIndex}"/>`,V+=" <c:tx>",V+=" <c:strRef>",V+=" <c:f>Sheet1!$"+j0(U._dataIndex+U.labels.length+1)+"$1</c:f>",V+=' <c:strCache><c:ptCount val="1"/><c:pt idx="0"><c:v>'+k0(U.name)+"</c:v></c:pt></c:strCache>",V+=" </c:strRef>",V+=" </c:tx>";let F=Q.chartColors?Q.chartColors[G%Q.chartColors.length]:null;if(V+=" <c:spPr>",F==="transparent")V+="<a:noFill/>";else if(Q.chartColorsOpacity)V+="<a:solidFill>"+R0(F,`<a:alpha val="${Math.round(Q.chartColorsOpacity*1000)}"/>`)+"</a:solidFill>";else V+="<a:solidFill>"+R0(F)+"</a:solidFill>";if($===q0.LINE||$===q0.RADAR)if(Q.lineSize===0)V+="<a:ln><a:noFill/></a:ln>";else V+=`<a:ln w="${Y0(Q.lineSize)}" cap="${k5(Q.lineCap)}"><a:solidFill>${R0(F)}</a:solidFill>`,V+='<a:prstDash val="'+(Q.lineDash||"solid")+'"/><a:round/></a:ln>';else if(Q.dataBorder)V+=`<a:ln w="${Y0(Q.dataBorder.pt)}" cap="${k5(Q.lineCap)}"><a:solidFill>${R0(Q.dataBorder.color)}</a:solidFill><a:prstDash val="solid"/><a:round/></a:ln>`;if(V+=T1(Q.shadow,P1),V+=" </c:spPr>",V+=' <c:invertIfNegative val="0"/>',$!==q0.RADAR){if(V+="<c:dLbls>",V+=`<c:numFmt formatCode="${k0(Q.dataLabelFormatCode)||"General"}" sourceLinked="0"/>`,Q.dataLabelBkgrdColors)V+=`<c:spPr><a:solidFill>${R0(F)}</a:solidFill></c:spPr>`;if(V+="<c:txPr><a:bodyPr/><a:lstStyle/><a:p><a:pPr>",V+=`<a:defRPr b="${Q.dataLabelFontBold?1:0}" i="${Q.dataLabelFontItalic?1:0}" strike="noStrike" sz="${Math.round((Q.dataLabelFontSize||k2)*100)}" u="none">`,V+=`<a:solidFill>${R0(Q.dataLabelColor||Q2)}</a:solidFill>`,V+=`<a:latin typeface="${Q.dataLabelFontFace||"Arial"}"/>`,V+="</a:defRPr></a:pPr></a:p></c:txPr>",Q.dataLabelPosition)V+=`<c:dLblPos val="${Q.dataLabelPosition}"/>`;V+='<c:showLegendKey val="0"/>',V+=`<c:showVal val="${Q.showValue?"1":"0"}"/>`,V+=`<c:showCatName val="0"/><c:showSerName val="${Q.showSerName?"1":"0"}"/><c:showPercent val="0"/><c:showBubbleSize val="0"/>`,V+=`<c:showLeaderLines val="${Q.showLeaderLines?"1":"0"}"/>`,V+="</c:dLbls>"}if($===q0.LINE||$===q0.RADAR){if(V+="<c:marker>",V+=' <c:symbol val="'+Q.lineDataSymbol+'"/>',Q.lineDataSymbolSize)V+=`<c:size val="${Q.lineDataSymbolSize}"/>`;V+=" <c:spPr>",V+=` <a:solidFill>${R0(Q.chartColors[U._dataIndex+1>Q.chartColors.length?Math.floor(Math.random()*Q.chartColors.length):U._dataIndex])}</a:solidFill>`,V+=` <a:ln w="${Q.lineDataSymbolLineSize}" cap="flat"><a:solidFill>${R0(Q.lineDataSymbolLineColor||F)}</a:solidFill><a:prstDash val="solid"/><a:round/></a:ln>`,V+=" <a:effectLst/>",V+=" </c:spPr>",V+="</c:marker>"}if(($===q0.BAR||$===q0.BAR3D)&&q.length===1&&(Q.chartColors&&Q.chartColors!==z8&&Q.chartColors.length>1||((w=Q.invertedColors)===null||w===void 0?void 0:w.length)))U.values.forEach((M,k)=>{let f=M<0?Q.invertedColors||Q.chartColors||z8:Q.chartColors||[];if(V+=" <c:dPt>",V+=` <c:idx val="${k}"/>`,V+=' <c:invertIfNegative val="0"/>',V+=' <c:bubble3D val="0"/>',V+=" <c:spPr>",Q.lineSize===0)V+="<a:ln><a:noFill/></a:ln>";else if($===q0.BAR)V+="<a:solidFill>",V+=' <a:srgbClr val="'+f[k%f.length]+'"/>',V+="</a:solidFill>";else V+="<a:ln>",V+=" <a:solidFill>",V+=' <a:srgbClr val="'+f[k%f.length]+'"/>',V+=" </a:solidFill>",V+="</a:ln>";V+=T1(Q.shadow,P1),V+=" </c:spPr>",V+=" </c:dPt>"});{if(V+="<c:cat>",Q.catLabelFormatCode)V+=" <c:numRef>",V+=` <c:f>Sheet1!$A$2:$A$${U.labels[0].length+1}</c:f>`,V+=" <c:numCache>",V+=" <c:formatCode>"+(Q.catLabelFormatCode||"General")+"</c:formatCode>",V+=` <c:ptCount val="${U.labels[0].length}"/>`,U.labels[0].forEach((M,k)=>V+=`<c:pt idx="${k}"><c:v>${k0(M)}</c:v></c:pt>`),V+=" </c:numCache>",V+=" </c:numRef>";else V+=" <c:multiLvlStrRef>",V+=` <c:f>Sheet1!$A$2:$${j0(U.labels.length)}$${U.labels[0].length+1}</c:f>`,V+=" <c:multiLvlStrCache>",V+=` <c:ptCount val="${U.labels[0].length}"/>`,U.labels.forEach((M)=>{V+="<c:lvl>",M.forEach((k,f)=>V+=`<c:pt idx="${f}"><c:v>${k0(k)}</c:v></c:pt>`),V+="</c:lvl>"}),V+=" </c:multiLvlStrCache>",V+=" </c:multiLvlStrRef>";V+="</c:cat>"}if(V+="<c:val>",V+=" <c:numRef>",V+=`<c:f>Sheet1!$${j0(U._dataIndex+U.labels.length+1)}$2:$${j0(U._dataIndex+U.labels.length+1)}$${U.labels[0].length+1}</c:f>`,V+=" <c:numCache>",V+=" <c:formatCode>"+(Q.valLabelFormatCode||Q.dataTableFormatCode||"General")+"</c:formatCode>",V+=` <c:ptCount val="${U.labels[0].length}"/>`,U.values.forEach((M,k)=>V+=`<c:pt idx="${k}"><c:v>${M||M===0?M:""}</c:v></c:pt>`),V+=" </c:numCache>",V+=" </c:numRef>",V+="</c:val>",$===q0.LINE)V+='<c:smooth val="'+(Q.lineSmooth?"1":"0")+'"/>';V+="</c:ser>"});{if(V+=" <c:dLbls>",V+=` <c:numFmt formatCode="${k0(Q.dataLabelFormatCode)||"General"}" sourceLinked="0"/>`,V+=" <c:txPr>",V+=" <a:bodyPr/>",V+=" <a:lstStyle/>",V+=" <a:p><a:pPr>",V+=` <a:defRPr b="${Q.dataLabelFontBold?1:0}" i="${Q.dataLabelFontItalic?1:0}" strike="noStrike" sz="${Math.round((Q.dataLabelFontSize||k2)*100)}" u="none">`,V+=" <a:solidFill>"+R0(Q.dataLabelColor||Q2)+"</a:solidFill>",V+=' <a:latin typeface="'+(Q.dataLabelFontFace||"Arial")+'"/>',V+=" </a:defRPr>",V+=" </a:pPr></a:p>",V+=" </c:txPr>",Q.dataLabelPosition)V+=' <c:dLblPos val="'+Q.dataLabelPosition+'"/>';V+=' <c:showLegendKey val="0"/>',V+=' <c:showVal val="'+(Q.showValue?"1":"0")+'"/>',V+=' <c:showCatName val="0"/>',V+=' <c:showSerName val="'+(Q.showSerName?"1":"0")+'"/>',V+=' <c:showPercent val="0"/>',V+=' <c:showBubbleSize val="0"/>',V+=` <c:showLeaderLines val="${Q.showLeaderLines?"1":"0"}"/>`,V+=" </c:dLbls>"}if($===q0.BAR)V+=` <c:gapWidth val="${Q.barGapWidthPct}"/>`,V+=` <c:overlap val="${(Q.barGrouping||"").includes("tacked")?100:Q.barOverlapPct?Q.barOverlapPct:0}"/>`;else if($===q0.BAR3D)V+=` <c:gapWidth val="${Q.barGapWidthPct}"/>`,V+=` <c:gapDepth val="${Q.barGapDepthPct}"/>`,V+=' <c:shape val="'+Q.bar3DShape+'"/>';else if($===q0.LINE)V+=' <c:marker val="1"/>';V+=`<c:axId val="${J}"/><c:axId val="${K}"/><c:axId val="${VJ}"/>`,V+=`</c:${$}Chart>`;break;case q0.SCATTER:V+="<c:"+$+"Chart>",V+='<c:scatterStyle val="lineMarker"/>',V+='<c:varyColors val="0"/>',G=-1,q.filter((U,w)=>w>0).forEach((U,w)=>{G++,V+="<c:ser>",V+=` <c:idx val="${w}"/>`,V+=` <c:order val="${w}"/>`,V+=" <c:tx>",V+=" <c:strRef>",V+=` <c:f>Sheet1!$${j0(w+2)}$1</c:f>`,V+=' <c:strCache><c:ptCount val="1"/><c:pt idx="0"><c:v>'+k0(U.name)+"</c:v></c:pt></c:strCache>",V+=" </c:strRef>",V+=" </c:tx>",V+=" <c:spPr>";{let F=Q.chartColors[G%Q.chartColors.length];if(F==="transparent")V+="<a:noFill/>";else if(Q.chartColorsOpacity)V+="<a:solidFill>"+R0(F,'<a:alpha val="'+Math.round(Q.chartColorsOpacity*1000).toString()+'"/>')+"</a:solidFill>";else V+="<a:solidFill>"+R0(F)+"</a:solidFill>";if(Q.lineSize===0)V+="<a:ln><a:noFill/></a:ln>";else V+=`<a:ln w="${Y0(Q.lineSize)}" cap="${k5(Q.lineCap)}"><a:solidFill>${R0(F)}</a:solidFill>`,V+=`<a:prstDash val="${Q.lineDash||"solid"}"/><a:round/></a:ln>`;V+=T1(Q.shadow,P1)}V+=" </c:spPr>";{if(V+="<c:marker>",V+=' <c:symbol val="'+Q.lineDataSymbol+'"/>',Q.lineDataSymbolSize)V+=`<c:size val="${Q.lineDataSymbolSize}"/>`;V+="<c:spPr>",V+=`<a:solidFill>${R0(Q.chartColors[w+1>Q.chartColors.length?Math.floor(Math.random()*Q.chartColors.length):w])}</a:solidFill>`,V+=`<a:ln w="${Q.lineDataSymbolLineSize}" cap="flat"><a:solidFill>${R0(Q.lineDataSymbolLineColor||Q.chartColors[G%Q.chartColors.length])}</a:solidFill><a:prstDash val="solid"/><a:round/></a:ln>`,V+="<a:effectLst/>",V+="</c:spPr>",V+="</c:marker>"}if(Q.showLabel){let F=Y5("-xxxx-xxxx-xxxx-xxxxxxxxxxxx");if(U.labels[0]&&(Q.dataLabelFormatScatter==="custom"||Q.dataLabelFormatScatter==="customXY"))V+="<c:dLbls>",U.labels[0].forEach((M,k)=>{if(Q.dataLabelFormatScatter==="custom"||Q.dataLabelFormatScatter==="customXY"){if(V+=" <c:dLbl>",V+=` <c:idx val="${k}"/>`,V+=" <c:tx>",V+=" <c:rich>",V+=" <a:bodyPr>",V+=" <a:spAutoFit/>",V+=" </a:bodyPr>",V+=" <a:lstStyle/>",V+=" <a:p>",V+=" <a:pPr>",V+=" <a:defRPr/>",V+=" </a:pPr>",V+=" <a:r>",V+=' <a:rPr lang="'+(Q.lang||"en-US")+'" dirty="0"/>',V+=" <a:t>"+k0(M)+"</a:t>",V+=" </a:r>",Q.dataLabelFormatScatter==="customXY"&&!/^ *$/.test(M))V+=" <a:r>",V+=' <a:rPr lang="'+(Q.lang||"en-US")+'" baseline="0" dirty="0"/>',V+=" <a:t> (</a:t>",V+=" </a:r>",V+=' <a:fld id="{'+Y5("xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx")+'}" type="XVALUE">',V+=' <a:rPr lang="'+(Q.lang||"en-US")+'" baseline="0"/>',V+=" <a:pPr>",V+=" <a:defRPr/>",V+=" </a:pPr>",V+=" <a:t>["+k0(U.name)+"</a:t>",V+=" </a:fld>",V+=" <a:r>",V+=' <a:rPr lang="'+(Q.lang||"en-US")+'" baseline="0" dirty="0"/>',V+=" <a:t>, </a:t>",V+=" </a:r>",V+=' <a:fld id="{'+Y5("xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx")+'}" type="YVALUE">',V+=' <a:rPr lang="'+(Q.lang||"en-US")+'" baseline="0"/>',V+=" <a:pPr>",V+=" <a:defRPr/>",V+=" </a:pPr>",V+=" <a:t>["+k0(U.name)+"]</a:t>",V+=" </a:fld>",V+=" <a:r>",V+=' <a:rPr lang="'+(Q.lang||"en-US")+'" baseline="0" dirty="0"/>',V+=" <a:t>)</a:t>",V+=" </a:r>",V+=' <a:endParaRPr lang="'+(Q.lang||"en-US")+'" dirty="0"/>';if(V+=" </a:p>",V+=" </c:rich>",V+=" </c:tx>",V+=" <c:spPr>",V+=" <a:noFill/>",V+=" <a:ln>",V+=" <a:noFill/>",V+=" </a:ln>",V+=" <a:effectLst/>",V+=" </c:spPr>",Q.dataLabelPosition)V+=' <c:dLblPos val="'+Q.dataLabelPosition+'"/>';V+=' <c:showLegendKey val="0"/>',V+=' <c:showVal val="0"/>',V+=' <c:showCatName val="0"/>',V+=' <c:showSerName val="0"/>',V+=' <c:showPercent val="0"/>',V+=' <c:showBubbleSize val="0"/>',V+=' <c:showLeaderLines val="1"/>',V+=" <c:extLst>",V+=' <c:ext uri="{CE6537A1-D6FC-4f65-9D91-7224C49458BB}" xmlns:c15="http://schemas.microsoft.com/office/drawing/2012/chart"/>',V+=' <c:ext uri="{C3380CC4-5D6E-409C-BE32-E72D297353CC}" xmlns:c16="http://schemas.microsoft.com/office/drawing/2014/chart">',V+=` <c16:uniqueId val="{${"00000000".substring(0,8-(k+1).toString().length).toString()}${k+1}${F}}"/>`,V+=" </c:ext>",V+=" </c:extLst>",V+="</c:dLbl>"}}),V+="</c:dLbls>";if(Q.dataLabelFormatScatter==="XY"){if(V+="<c:dLbls>",V+=" <c:spPr>",V+=" <a:noFill/>",V+=" <a:ln>",V+=" <a:noFill/>",V+=" </a:ln>",V+=" <a:effectLst/>",V+=" </c:spPr>",V+=" <c:txPr>",V+=" <a:bodyPr>",V+=" <a:spAutoFit/>",V+=" </a:bodyPr>",V+=" <a:lstStyle/>",V+=" <a:p>",V+=" <a:pPr>",V+=" <a:defRPr/>",V+=" </a:pPr>",V+=' <a:endParaRPr lang="en-US"/>',V+=" </a:p>",V+=" </c:txPr>",Q.dataLabelPosition)V+=' <c:dLblPos val="'+Q.dataLabelPosition+'"/>';V+=' <c:showLegendKey val="0"/>',V+=` <c:showVal val="${Q.showLabel?"1":"0"}"/>`,V+=` <c:showCatName val="${Q.showLabel?"1":"0"}"/>`,V+=` <c:showSerName val="${Q.showSerName?"1":"0"}"/>`,V+=' <c:showPercent val="0"/>',V+=' <c:showBubbleSize val="0"/>',V+=" <c:extLst>",V+=' <c:ext uri="{CE6537A1-D6FC-4f65-9D91-7224C49458BB}" xmlns:c15="http://schemas.microsoft.com/office/drawing/2012/chart">',V+=' <c15:showLeaderLines val="1"/>',V+=" </c:ext>",V+=" </c:extLst>",V+="</c:dLbls>"}}if(q.length===1&&Q.chartColors!==z8)U.values.forEach((F,M)=>{let k=F<0?Q.invertedColors||Q.chartColors||z8:Q.chartColors||[];if(V+=" <c:dPt>",V+=` <c:idx val="${M}"/>`,V+=' <c:invertIfNegative val="0"/>',V+=' <c:bubble3D val="0"/>',V+=" <c:spPr>",Q.lineSize===0)V+="<a:ln><a:noFill/></a:ln>";else V+="<a:solidFill>",V+=' <a:srgbClr val="'+k[M%k.length]+'"/>',V+="</a:solidFill>";V+=T1(Q.shadow,P1),V+=" </c:spPr>",V+=" </c:dPt>"});V+="<c:xVal>",V+=" <c:numRef>",V+=` <c:f>Sheet1!$A$2:$A$${q[0].values.length+1}</c:f>`,V+=" <c:numCache>",V+=" <c:formatCode>General</c:formatCode>",V+=` <c:ptCount val="${q[0].values.length}"/>`,q[0].values.forEach((F,M)=>{V+=`<c:pt idx="${M}"><c:v>${F||F===0?F:""}</c:v></c:pt>`}),V+=" </c:numCache>",V+=" </c:numRef>",V+="</c:xVal>",V+="<c:yVal>",V+=" <c:numRef>",V+=` <c:f>Sheet1!$${j0(w+2)}$2:$${j0(w+2)}$${q[0].values.length+1}</c:f>`,V+=" <c:numCache>",V+=" <c:formatCode>General</c:formatCode>",V+=` <c:ptCount val="${q[0].values.length}"/>`,q[0].values.forEach((F,M)=>{V+=`<c:pt idx="${M}"><c:v>${U.values[M]||U.values[M]===0?U.values[M]:""}</c:v></c:pt>`}),V+=" </c:numCache>",V+=" </c:numRef>",V+="</c:yVal>",V+='<c:smooth val="'+(Q.lineSmooth?"1":"0")+'"/>',V+="</c:ser>"});{if(V+=" <c:dLbls>",V+=` <c:numFmt formatCode="${k0(Q.dataLabelFormatCode)||"General"}" sourceLinked="0"/>`,V+=" <c:txPr>",V+=" <a:bodyPr/>",V+=" <a:lstStyle/>",V+=" <a:p><a:pPr>",V+=` <a:defRPr b="${Q.dataLabelFontBold?"1":"0"}" i="${Q.dataLabelFontItalic?"1":"0"}" strike="noStrike" sz="${Math.round((Q.dataLabelFontSize||k2)*100)}" u="none">`,V+=" <a:solidFill>"+R0(Q.dataLabelColor||Q2)+"</a:solidFill>",V+=' <a:latin typeface="'+(Q.dataLabelFontFace||"Arial")+'"/>',V+=" </a:defRPr>",V+=" </a:pPr></a:p>",V+=" </c:txPr>",Q.dataLabelPosition)V+=' <c:dLblPos val="'+Q.dataLabelPosition+'"/>';V+=' <c:showLegendKey val="0"/>',V+=' <c:showVal val="'+(Q.showValue?"1":"0")+'"/>',V+=' <c:showCatName val="0"/>',V+=' <c:showSerName val="'+(Q.showSerName?"1":"0")+'"/>',V+=' <c:showPercent val="0"/>',V+=' <c:showBubbleSize val="0"/>',V+=" </c:dLbls>"}V+=`<c:axId val="${J}"/><c:axId val="${K}"/>`,V+="</c:"+$+"Chart>";break;case q0.BUBBLE:case q0.BUBBLE3D:V+="<c:bubbleChart>",V+='<c:varyColors val="0"/>',G=-1,q.filter((U,w)=>w>0).forEach((U,w)=>{G++,V+="<c:ser>",V+=` <c:idx val="${w}"/>`,V+=` <c:order val="${w}"/>`,V+=" <c:tx>",V+=" <c:strRef>",V+=" <c:f>Sheet1!$"+j0(W+1)+"$1</c:f>",V+=' <c:strCache><c:ptCount val="1"/><c:pt idx="0"><c:v>'+k0(U.name)+"</c:v></c:pt></c:strCache>",V+=" </c:strRef>",V+=" </c:tx>";{V+="<c:spPr>";let F=Q.chartColors[G%Q.chartColors.length];if(F==="transparent")V+="<a:noFill/>";else if(Q.chartColorsOpacity)V+=`<a:solidFill>${R0(F,'<a:alpha val="'+Math.round(Q.chartColorsOpacity*1000).toString()+'"/>')}</a:solidFill>`;else V+="<a:solidFill>"+R0(F)+"</a:solidFill>";if(Q.lineSize===0)V+="<a:ln><a:noFill/></a:ln>";else if(Q.dataBorder)V+=`<a:ln w="${Y0(Q.dataBorder.pt)}" cap="flat"><a:solidFill>${R0(Q.dataBorder.color)}</a:solidFill><a:prstDash val="solid"/><a:round/></a:ln>`;else V+=`<a:ln w="${Y0(Q.lineSize)}" cap="flat"><a:solidFill>${R0(F)}</a:solidFill>`,V+=`<a:prstDash val="${Q.lineDash||"solid"}"/><a:round/></a:ln>`;V+=T1(Q.shadow,P1),V+="</c:spPr>"}V+="<c:xVal>",V+=" <c:numRef>",V+=` <c:f>Sheet1!$A$2:$A$${q[0].values.length+1}</c:f>`,V+=" <c:numCache>",V+=" <c:formatCode>General</c:formatCode>",V+=` <c:ptCount val="${q[0].values.length}"/>`,q[0].values.forEach((F,M)=>{V+=`<c:pt idx="${M}"><c:v>${F||F===0?F:""}</c:v></c:pt>`}),V+=" </c:numCache>",V+=" </c:numRef>",V+="</c:xVal>",V+="<c:yVal>",V+=" <c:numRef>",V+=`<c:f>Sheet1!$${j0(W+1)}$2:$${j0(W+1)}$${q[0].values.length+1}</c:f>`,W++,V+=" <c:numCache>",V+=" <c:formatCode>General</c:formatCode>",V+=` <c:ptCount val="${q[0].values.length}"/>`,q[0].values.forEach((F,M)=>{V+=`<c:pt idx="${M}"><c:v>${U.values[M]||U.values[M]===0?U.values[M]:""}</c:v></c:pt>`}),V+=" </c:numCache>",V+=" </c:numRef>",V+="</c:yVal>",V+=" <c:bubbleSize>",V+=" <c:numRef>",V+=`<c:f>Sheet1!$${j0(W+1)}$2:$${j0(W+1)}$${U.sizes.length+1}</c:f>`,W++,V+=" <c:numCache>",V+=" <c:formatCode>General</c:formatCode>",V+=` <c:ptCount val="${U.sizes.length}"/>`,U.sizes.forEach((F,M)=>{V+=`<c:pt idx="${M}"><c:v>${F||""}</c:v></c:pt>`}),V+=" </c:numCache>",V+=" </c:numRef>",V+=" </c:bubbleSize>",V+=' <c:bubble3D val="'+($===q0.BUBBLE3D?"1":"0")+'"/>',V+="</c:ser>"});{if(V+="<c:dLbls>",V+=`<c:numFmt formatCode="${k0(Q.dataLabelFormatCode)||"General"}" sourceLinked="0"/>`,V+="<c:txPr><a:bodyPr/><a:lstStyle/><a:p><a:pPr>",V+=`<a:defRPr b="${Q.dataLabelFontBold?1:0}" i="${Q.dataLabelFontItalic?1:0}" strike="noStrike" sz="${Math.round(Math.round(Q.dataLabelFontSize||k2)*100)}" u="none">`,V+=`<a:solidFill>${R0(Q.dataLabelColor||Q2)}</a:solidFill>`,V+=`<a:latin typeface="${Q.dataLabelFontFace||"Arial"}"/>`,V+="</a:defRPr></a:pPr></a:p></c:txPr>",Q.dataLabelPosition)V+=`<c:dLblPos val="${Q.dataLabelPosition}"/>`;V+='<c:showLegendKey val="0"/>',V+=`<c:showVal val="${Q.showValue?"1":"0"}"/>`,V+=`<c:showCatName val="0"/><c:showSerName val="${Q.showSerName?"1":"0"}"/><c:showPercent val="0"/><c:showBubbleSize val="0"/>`,V+="<c:extLst>",V+=' <c:ext uri="{CE6537A1-D6FC-4f65-9D91-7224C49458BB}" xmlns:c15="http://schemas.microsoft.com/office/drawing/2012/chart">',V+=' <c15:showLeaderLines val="'+(Q.showLeaderLines?"1":"0")+'"/>',V+=" </c:ext>",V+="</c:extLst>",V+="</c:dLbls>"}V+=`<c:axId val="${J}"/><c:axId val="${K}"/>`,V+="</c:bubbleChart>";break;case q0.DOUGHNUT:case q0.PIE:if(B=q[0],V+="<c:"+$+"Chart>",V+=' <c:varyColors val="1"/>',V+="<c:ser>",V+=' <c:idx val="0"/>',V+=' <c:order val="0"/>',V+=" <c:tx>",V+=" <c:strRef>",V+=" <c:f>Sheet1!$B$1</c:f>",V+=" <c:strCache>",V+=' <c:ptCount val="1"/>',V+=' <c:pt idx="0"><c:v>'+k0(B.name)+"</c:v></c:pt>",V+=" </c:strCache>",V+=" </c:strRef>",V+=" </c:tx>",V+=" <c:spPr>",V+=' <a:solidFill><a:schemeClr val="accent1"/></a:solidFill>',V+=' <a:ln w="9525" cap="flat"><a:solidFill><a:srgbClr val="F9F9F9"/></a:solidFill><a:prstDash val="solid"/><a:round/></a:ln>',Q.dataNoEffects)V+="<a:effectLst/>";else V+=T1(Q.shadow,P1);if(V+=" </c:spPr>",B.labels[0].forEach((U,w)=>{if(V+="<c:dPt>",V+=` <c:idx val="${w}"/>`,V+=' <c:bubble3D val="0"/>',V+=" <c:spPr>",V+=`<a:solidFill>${R0(Q.chartColors[w+1>Q.chartColors.length?Math.floor(Math.random()*Q.chartColors.length):w])}</a:solidFill>`,Q.dataBorder)V+=`<a:ln w="${Y0(Q.dataBorder.pt)}" cap="flat"><a:solidFill>${R0(Q.dataBorder.color)}</a:solidFill><a:prstDash val="solid"/><a:round/></a:ln>`;V+=T1(Q.shadow,P1),V+=" </c:spPr>",V+="</c:dPt>"}),V+="<c:dLbls>",B.labels[0].forEach((U,w)=>{if(V+="<c:dLbl>",V+=` <c:idx val="${w}"/>`,V+=` <c:numFmt formatCode="${k0(Q.dataLabelFormatCode)||"General"}" sourceLinked="0"/>`,V+=" <c:spPr/><c:txPr>",V+=" <a:bodyPr/><a:lstStyle/>",V+=" <a:p><a:pPr>",V+=` <a:defRPr sz="${Math.round((Q.dataLabelFontSize||k2)*100)}" b="${Q.dataLabelFontBold?1:0}" i="${Q.dataLabelFontItalic?1:0}" u="none" strike="noStrike">`,V+=" <a:solidFill>"+R0(Q.dataLabelColor||Q2)+"</a:solidFill>",V+=` <a:latin typeface="${Q.dataLabelFontFace||"Arial"}"/>`,V+=" </a:defRPr>",V+=" </a:pPr></a:p>",V+=" </c:txPr>",$===q0.PIE&&Q.dataLabelPosition)V+=`<c:dLblPos val="${Q.dataLabelPosition}"/>`;V+=' <c:showLegendKey val="0"/>',V+=' <c:showVal val="'+(Q.showValue?"1":"0")+'"/>',V+=' <c:showCatName val="'+(Q.showLabel?"1":"0")+'"/>',V+=' <c:showSerName val="'+(Q.showSerName?"1":"0")+'"/>',V+=' <c:showPercent val="'+(Q.showPercent?"1":"0")+'"/>',V+=' <c:showBubbleSize val="0"/>',V+=" </c:dLbl>"}),V+=` <c:numFmt formatCode="${k0(Q.dataLabelFormatCode)||"General"}" sourceLinked="0"/>`,V+=" <c:txPr>",V+=" <a:bodyPr/>",V+=" <a:lstStyle/>",V+=" <a:p>",V+=" <a:pPr>",V+=` <a:defRPr sz="1800" b="${Q.dataLabelFontBold?"1":"0"}" i="${Q.dataLabelFontItalic?"1":"0"}" u="none" strike="noStrike">`,V+=' <a:solidFill><a:srgbClr val="000000"/></a:solidFill><a:latin typeface="Arial"/>',V+=" </a:defRPr>",V+=" </a:pPr>",V+=" </a:p>",V+=" </c:txPr>",V+=$===q0.PIE?'<c:dLblPos val="ctr"/>':"",V+=' <c:showLegendKey val="0"/>',V+=' <c:showVal val="0"/>',V+=' <c:showCatName val="1"/>',V+=' <c:showSerName val="0"/>',V+=' <c:showPercent val="1"/>',V+=' <c:showBubbleSize val="0"/>',V+=` <c:showLeaderLines val="${Q.showLeaderLines?"1":"0"}"/>`,V+="</c:dLbls>",V+="<c:cat>",V+=" <c:strRef>",V+=` <c:f>Sheet1!$A$2:$A$${B.labels[0].length+1}</c:f>`,V+=" <c:strCache>",V+=` <c:ptCount val="${B.labels[0].length}"/>`,B.labels[0].forEach((U,w)=>{V+=`<c:pt idx="${w}"><c:v>${k0(U)}</c:v></c:pt>`}),V+=" </c:strCache>",V+=" </c:strRef>",V+="</c:cat>",V+=" <c:val>",V+=" <c:numRef>",V+=` <c:f>Sheet1!$B$2:$B$${B.labels[0].length+1}</c:f>`,V+=" <c:numCache>",V+=` <c:ptCount val="${B.labels[0].length}"/>`,B.values.forEach((U,w)=>{V+=`<c:pt idx="${w}"><c:v>${U||U===0?U:""}</c:v></c:pt>`}),V+=" </c:numCache>",V+=" </c:numRef>",V+=" </c:val>",V+=" </c:ser>",V+=` <c:firstSliceAng val="${Q.firstSliceAng?Math.round(Q.firstSliceAng):0}"/>`,$===q0.DOUGHNUT)V+=`<c:holeSize val="${typeof Q.holeSize==="number"?Q.holeSize:"50"}"/>`;V+="</c:"+$+"Chart>";break;default:V+="";break}return V}function A7($,q,Q){let K="";if($._type===q0.SCATTER||$._type===q0.BUBBLE||$._type===q0.BUBBLE3D)K+="<c:valAx>";else K+="<c:"+($.catLabelFormatCode?"dateAx":"catAx")+">";if(K+=' <c:axId val="'+q+'"/>',K+=" <c:scaling>",K+='<c:orientation val="'+($.catAxisOrientation||($.barDir==="col"?"minMax":"minMax"))+'"/>',$.catAxisMaxVal||$.catAxisMaxVal===0)K+=`<c:max val="${$.catAxisMaxVal}"/>`;if($.catAxisMinVal||$.catAxisMinVal===0)K+=`<c:min val="${$.catAxisMinVal}"/>`;if(K+="</c:scaling>",K+=' <c:delete val="'+($.catAxisHidden?"1":"0")+'"/>',K+=' <c:axPos val="'+($.barDir==="col"?"b":"l")+'"/>',K+=$.catGridLine.style!=="none"?b7($.catGridLine):"",$.showCatAxisTitle)K+=H5({color:$.catAxisTitleColor,fontFace:$.catAxisTitleFontFace,fontSize:$.catAxisTitleFontSize,titleRotate:$.catAxisTitleRotate,title:$.catAxisTitle||"Axis Title"});if($._type===q0.SCATTER||$._type===q0.BUBBLE||$._type===q0.BUBBLE3D)K+=' <c:numFmt formatCode="'+($.valAxisLabelFormatCode?k0($.valAxisLabelFormatCode):"General")+'" sourceLinked="1"/>';else K+=' <c:numFmt formatCode="'+(k0($.catLabelFormatCode)||"General")+'" sourceLinked="1"/>';if($._type===q0.SCATTER)K+=' <c:majorTickMark val="none"/>',K+=' <c:minorTickMark val="none"/>',K+=' <c:tickLblPos val="nextTo"/>';else K+=' <c:majorTickMark val="'+($.catAxisMajorTickMark||"out")+'"/>',K+=' <c:minorTickMark val="'+($.catAxisMinorTickMark||"none")+'"/>',K+=' <c:tickLblPos val="'+($.catAxisLabelPos||($.barDir==="col"?"low":"nextTo"))+'"/>';if(K+=" <c:spPr>",K+=` <a:ln w="${$.catAxisLineSize?Y0($.catAxisLineSize):w8}" cap="flat">`,K+=!$.catAxisLineShow?"<a:noFill/>":"<a:solidFill>"+R0($.catAxisLineColor||u1.color)+"</a:solidFill>",K+=' <a:prstDash val="'+($.catAxisLineStyle||"solid")+'"/>',K+=" <a:round/>",K+=" </a:ln>",K+=" </c:spPr>",K+=" <c:txPr>",$.catAxisLabelRotate)K+=`<a:bodyPr rot="${S1($.catAxisLabelRotate)}"/>`;else K+="<a:bodyPr/>";if(K+=" <a:lstStyle/>",K+=" <a:p>",K+=" <a:pPr>",K+=` <a:defRPr sz="${Math.round(($.catAxisLabelFontSize||k2)*100)}" b="${$.catAxisLabelFontBold?1:0}" i="${$.catAxisLabelFontItalic?1:0}" u="none" strike="noStrike">`,K+=" <a:solidFill>"+R0($.catAxisLabelColor||Q2)+"</a:solidFill>",K+=' <a:latin typeface="'+($.catAxisLabelFontFace||"Arial")+'"/>',K+=" </a:defRPr>",K+=" </a:pPr>",K+=' <a:endParaRPr lang="'+($.lang||"en-US")+'"/>',K+=" </a:p>",K+=" </c:txPr>",K+=' <c:crossAx val="'+Q+'"/>',K+=` <c:${typeof $.valAxisCrossesAt==="number"?"crossesAt":"crosses"} val="${$.valAxisCrossesAt||"autoZero"}"/>`,K+=' <c:auto val="1"/>',K+=' <c:lblAlgn val="ctr"/>',K+=` <c:noMultiLvlLbl val="${$.catAxisMultiLevelLabels?0:1}"/>`,$.catAxisLabelFrequency)K+=' <c:tickLblSkip val="'+$.catAxisLabelFrequency+'"/>';if($.catLabelFormatCode||$._type===q0.SCATTER||$._type===q0.BUBBLE||$._type===q0.BUBBLE3D){if($.catLabelFormatCode){if(["catAxisBaseTimeUnit","catAxisMajorTimeUnit","catAxisMinorTimeUnit"].forEach((J)=>{if($[J]&&(typeof $[J]!=="string"||!["days","months","years"].includes($[J].toLowerCase())))console.warn(`"${J}" must be one of: 'days','months','years' !`),$[J]=null}),$.catAxisBaseTimeUnit)K+='<c:baseTimeUnit val="'+$.catAxisBaseTimeUnit.toLowerCase()+'"/>';if($.catAxisMajorTimeUnit)K+='<c:majorTimeUnit val="'+$.catAxisMajorTimeUnit.toLowerCase()+'"/>';if($.catAxisMinorTimeUnit)K+='<c:minorTimeUnit val="'+$.catAxisMinorTimeUnit.toLowerCase()+'"/>'}if($.catAxisMajorUnit)K+=`<c:majorUnit val="${$.catAxisMajorUnit}"/>`;if($.catAxisMinorUnit)K+=`<c:minorUnit val="${$.catAxisMinorUnit}"/>`}if($._type===q0.SCATTER||$._type===q0.BUBBLE||$._type===q0.BUBBLE3D)K+="</c:valAx>";else K+="</c:"+($.catLabelFormatCode?"dateAx":"catAx")+">";return K}function X7($,q){let Q=q===o2?$.barDir==="col"?"l":"b":$.barDir!=="col"?"r":"t";if(q===N5)Q="r";let K=q===o2?B8:x7,J="";if(J+="<c:valAx>",J+=' <c:axId val="'+q+'"/>',J+=" <c:scaling>",$.valAxisLogScaleBase)J+=`<c:logBase val="${$.valAxisLogScaleBase}"/>`;if(J+='<c:orientation val="'+($.valAxisOrientation||($.barDir==="col"?"minMax":"minMax"))+'"/>',$.valAxisMaxVal||$.valAxisMaxVal===0)J+=`<c:max val="${$.valAxisMaxVal}"/>`;if($.valAxisMinVal||$.valAxisMinVal===0)J+=`<c:min val="${$.valAxisMinVal}"/>`;if(J+=" </c:scaling>",J+=` <c:delete val="${$.valAxisHidden?1:0}"/>`,J+=' <c:axPos val="'+Q+'"/>',$.valGridLine.style!=="none")J+=b7($.valGridLine);if($.showValAxisTitle)J+=H5({color:$.valAxisTitleColor,fontFace:$.valAxisTitleFontFace,fontSize:$.valAxisTitleFontSize,titleRotate:$.valAxisTitleRotate,title:$.valAxisTitle||"Axis Title"});if(J+=`<c:numFmt formatCode="${$.valAxisLabelFormatCode?k0($.valAxisLabelFormatCode):"General"}" sourceLinked="0"/>`,$._type===q0.SCATTER)J+=' <c:majorTickMark val="none"/>',J+=' <c:minorTickMark val="none"/>',J+=' <c:tickLblPos val="nextTo"/>';else J+=' <c:majorTickMark val="'+($.valAxisMajorTickMark||"out")+'"/>',J+=' <c:minorTickMark val="'+($.valAxisMinorTickMark||"none")+'"/>',J+=' <c:tickLblPos val="'+($.valAxisLabelPos||($.barDir==="col"?"nextTo":"low"))+'"/>';if(J+=" <c:spPr>",J+=` <a:ln w="${$.valAxisLineSize?Y0($.valAxisLineSize):w8}" cap="flat">`,J+=!$.valAxisLineShow?"<a:noFill/>":"<a:solidFill>"+R0($.valAxisLineColor||u1.color)+"</a:solidFill>",J+=' <a:prstDash val="'+($.valAxisLineStyle||"solid")+'"/>',J+=" <a:round/>",J+=" </a:ln>",J+=" </c:spPr>",J+=" <c:txPr>",J+=` <a:bodyPr${$.valAxisLabelRotate?' rot="'+S1($.valAxisLabelRotate).toString()+'"':""}/>`,J+=" <a:lstStyle/>",J+=" <a:p>",J+=" <a:pPr>",J+=` <a:defRPr sz="${Math.round(($.valAxisLabelFontSize||k2)*100)}" b="${$.valAxisLabelFontBold?1:0}" i="${$.valAxisLabelFontItalic?1:0}" u="none" strike="noStrike">`,J+=" <a:solidFill>"+R0($.valAxisLabelColor||Q2)+"</a:solidFill>",J+=' <a:latin typeface="'+($.valAxisLabelFontFace||"Arial")+'"/>',J+=" </a:defRPr>",J+=" </a:pPr>",J+=' <a:endParaRPr lang="'+($.lang||"en-US")+'"/>',J+=" </a:p>",J+=" </c:txPr>",J+=' <c:crossAx val="'+K+'"/>',typeof $.catAxisCrossesAt==="number")J+=` <c:crossesAt val="${$.catAxisCrossesAt}"/>`;else if(typeof $.catAxisCrossesAt==="string")J+=' <c:crosses val="'+$.catAxisCrossesAt+'"/>';else J+=' <c:crosses val="'+(Q==="r"||Q==="t"?"max":"autoZero")+'"/>';if(J+=' <c:crossBetween val="'+($._type===q0.SCATTER||!!(Array.isArray($._type)&&$._type.filter((Z)=>Z.type===q0.AREA).length>0)?"midCat":"between")+'"/>',$.valAxisMajorUnit)J+=` <c:majorUnit val="${$.valAxisMajorUnit}"/>`;if($.valAxisDisplayUnit)J+=`<c:dispUnits><c:builtInUnit val="${$.valAxisDisplayUnit}"/>${$.valAxisDisplayUnitLabel?"<c:dispUnitsLbl/>":""}</c:dispUnits>`;return J+="</c:valAx>",J}function AB($,q,Q){let K="";if(K+="<c:serAx>",K+=' <c:axId val="'+q+'"/>',K+=' <c:scaling><c:orientation val="'+($.serAxisOrientation||($.barDir==="col"?"minMax":"minMax"))+'"/></c:scaling>',K+=' <c:delete val="'+($.serAxisHidden?"1":"0")+'"/>',K+=' <c:axPos val="'+($.barDir==="col"?"b":"l")+'"/>',K+=$.serGridLine.style!=="none"?b7($.serGridLine):"",$.showSerAxisTitle)K+=H5({color:$.serAxisTitleColor,fontFace:$.serAxisTitleFontFace,fontSize:$.serAxisTitleFontSize,titleRotate:$.serAxisTitleRotate,title:$.serAxisTitle||"Axis Title"});if(K+=` <c:numFmt formatCode="${k0($.serLabelFormatCode)||"General"}" sourceLinked="0"/>`,K+=' <c:majorTickMark val="out"/>',K+=' <c:minorTickMark val="none"/>',K+=` <c:tickLblPos val="${$.serAxisLabelPos||$.barDir==="col"?"low":"nextTo"}"/>`,K+=" <c:spPr>",K+=' <a:ln w="12700" cap="flat">',K+=!$.serAxisLineShow?"<a:noFill/>":`<a:solidFill>${R0($.serAxisLineColor||u1.color)}</a:solidFill>`,K+=' <a:prstDash val="solid"/>',K+=" <a:round/>",K+=" </a:ln>",K+=" </c:spPr>",K+=" <c:txPr>",K+=" <a:bodyPr/>",K+=" <a:lstStyle/>",K+=" <a:p>",K+=" <a:pPr>",K+=` <a:defRPr sz="${Math.round(($.serAxisLabelFontSize||k2)*100)}" b="${$.serAxisLabelFontBold?"1":"0"}" i="${$.serAxisLabelFontItalic?"1":"0"}" u="none" strike="noStrike">`,K+=` <a:solidFill>${R0($.serAxisLabelColor||Q2)}</a:solidFill>`,K+=` <a:latin typeface="${$.serAxisLabelFontFace||"Arial"}"/>`,K+=" </a:defRPr>",K+=" </a:pPr>",K+=' <a:endParaRPr lang="'+($.lang||"en-US")+'"/>',K+=" </a:p>",K+=" </c:txPr>",K+=' <c:crossAx val="'+Q+'"/>',K+=' <c:crosses val="autoZero"/>',$.serAxisLabelFrequency)K+=' <c:tickLblSkip val="'+$.serAxisLabelFrequency+'"/>';if($.serLabelFormatCode){if(["serAxisBaseTimeUnit","serAxisMajorTimeUnit","serAxisMinorTimeUnit"].forEach((J)=>{if($[J]&&(typeof $[J]!=="string"||!["days","months","years"].includes(J.toLowerCase())))console.warn(`"${J}" must be one of: 'days','months','years' !`),$[J]=null}),$.serAxisBaseTimeUnit)K+=` <c:baseTimeUnit val="${$.serAxisBaseTimeUnit.toLowerCase()}"/>`;if($.serAxisMajorTimeUnit)K+=` <c:majorTimeUnit val="${$.serAxisMajorTimeUnit.toLowerCase()}"/>`;if($.serAxisMinorTimeUnit)K+=` <c:minorTimeUnit val="${$.serAxisMinorTimeUnit.toLowerCase()}"/>`;if($.serAxisMajorUnit)K+=` <c:majorUnit val="${$.serAxisMajorUnit}"/>`;if($.serAxisMinorUnit)K+=` <c:minorUnit val="${$.serAxisMinorUnit}"/>`}return K+="</c:serAx>",K}function H5($,q,Q){let K=$.titleAlign==="left"||$.titleAlign==="right"?`<a:pPr algn="${$.titleAlign.substring(0,1)}">`:"<a:pPr>",J=$.titleRotate?`<a:bodyPr rot="${S1($.titleRotate)}"/>`:"<a:bodyPr/>",Z=$.fontSize?`sz="${Math.round($.fontSize*100)}"`:"",G=$.titleBold?1:0,W="<c:layout/>";if($.titlePos&&typeof $.titlePos.x==="number"&&typeof $.titlePos.y==="number"){let B=$.titlePos.x+q,V=$.titlePos.y+Q,U=B===0?0:B*(B/5)/10;if(U>=1)U=U/10;if(U>=0.1)U=U/10;let w=V===0?0:V*(V/5)/10;if(w>=1)w=w/10;if(w>=0.1)w=w/10;W=`<c:layout><c:manualLayout><c:xMode val="edge"/><c:yMode val="edge"/><c:x val="${U}"/><c:y val="${w}"/></c:manualLayout></c:layout>`}return`<c:title> |
| 33 | <c:tx> |
| 34 | <c:rich> |
| 35 | ${J} |