MCPcopy Create free account
hub / github.com/simstudioai/sim / eK

Function eK

apps/sim/lib/execution/sandbox/bundles/pptxgenjs.cjs:32–32  ·  view source on GitHub ↗
($,q,Q,K,J,Z)

Source from the content-addressed store, hash-verified

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}

Callers 1

gBFunction · 0.70

Calls 9

j0Function · 0.85
testMethod · 0.80
k0Function · 0.70
R0Function · 0.70
Y0Function · 0.70
k5Function · 0.70
T1Function · 0.70
Y5Function · 0.70
toStringMethod · 0.45

Tested by

no test coverage detected