decode-xlsx v1.7.3
xlsx on js "decode-xlsx": "file:../decode-xlsx",
import DecodeXLSX from 'decode-xlsx'
const styles = [
{
'name': 'style1',
'property' : {
'font' : {
'family': 'Calibri',
'weight': 'bold',
'style': 'minor',
'size': '12',
'color': '#242424'
},
'align': {
'horizontal' : 'center',
'vertical': 'center',
},
'theme': 5,
'shade': .3 //20%
}
},
{
'name': 'style2',
'property' : {
'font' : {
'family': 'Calibri',
'weight': 'bold',
'style': 'minor',
'size': '12',
'color': 'FFFFFF',
'numFmtId': 10
},
'align': {
'horizontal' : 'center',
'vertical': 'center',
}
}
},
{
'name': 'style3',
'property' : {
'font' : {
'family': 'Calibri',
'weight': 'bold',
'style': 'minor',
'size': '16',
'color': '#000000'
},
'align': {
'horizontal' : 'center',
'vertical': 'center',
},
'background': {
color: '#BDE9F3'
}
}
},
{
'name': 'report-header',
'property' : {
'font' : {
'family': 'Calibri',
'weight': 'bold',
'style': 'minor',
'size': '24',
'color': '#FFFFFF'
},
'align': {
'horizontal' : 'center',
'vertical': 'center',
},
'background': {
color: '#263643'
}
}
},
{
'name': 'style5',
'property' : {
'font' : {
'family': 'Calibri',
'weight': 'bold',
'style': 'minor',
'size': '16',
'color': '#000000'
},
'align': {
'horizontal' : 'center',
'vertical': 'center',
},
'background': {
color: '#95DBE9'
}
}
},
{
'name': 'style6',
'property' : {
'font' : {
'family': 'Calibri',
'weight': 'bold',
'style': 'minor',
'size': '16',
'color': '#000000'
},
'align': {
'horizontal' : 'center',
'vertical': 'center',
},
'background': {
color: '#72CEE2'
}
}
},
{
'name': 'style7',
'property' : {
'font' : {
'family': 'Calibri',
'weight': 'bold',
'style': 'minor',
'size': '16',
'color': '#000000'
},
'align': {
'horizontal' : 'center',
'vertical': 'center',
},
'background': {
color: '#D1D7DD'
}
}
},
{
'name': 'style8',
'property' : {
'font' : {
'family': 'Calibri',
'weight': 'bold',
'style': 'minor',
'size': '16',
'color': '#000000'
},
'align': {
'horizontal' : 'center',
'vertical': 'center',
},
'background': {
color: '#B3BFC5'
}
}
},
{
'name': 'style9',
'property' : {
'font' : {
'family': 'Calibri',
'weight': 'bold',
'style': 'minor',
'size': '16',
'color': '#000000'
},
'align': {
'horizontal' : 'center',
'vertical': 'center',
},
'background': {
color: '#93A3AC'
}
}
},
{
'name': 'style10',
'property' : {
'font' : {
'family': 'Calibri',
'weight': 'bold',
'style': 'minor',
'size': '16',
'color': '#000000'
},
'align': {
'horizontal' : 'center',
'vertical': 'center',
},
'background': {
color: '#BBE9F3'
}
}
},
{
'name': 'style11',
'property' : {
'font' : {
'family': 'Calibri',
'weight': 'bold',
'style': 'minor',
'size': '16',
'color': '#000000'
},
'align': {
'horizontal' : 'center',
'vertical': 'center',
},
'background': {
color: '#72CDE1'
}
}
},
{
'name': 'style12',
'property' : {
'font' : {
'family': 'Calibri',
'weight': 'bold',
'style': 'minor',
'size': '16',
'color': '#000000'
},
'align': {
'horizontal' : 'center',
'vertical': 'center',
},
'background': {
color: '#D1D7DD'
}
}
},
{
'name': 'style13',
'property' : {
'font' : {
'family': 'Calibri',
'weight': 'bold',
'style': 'minor',
'size': '16',
'color': '#000000'
},
'align': {
'horizontal' : 'center',
'vertical': 'center',
},
'background': {
color: '#94A3AB'
}
}
},
{
'name': 'style14',
'property' : {
'font' : {
'family': 'Calibri',
'weight': 'bold',
'style': 'minor',
'size': '16',
'color': '#000000'
},
'align': {
'horizontal' : 'center',
'vertical': 'center',
},
'background': {
color: '#BBE9F4'
}
}
},
{
'name': 'style15',
'property' : {
'font' : {
'family': 'Calibri',
'weight': 'bold',
'style': 'minor',
'size': '16',
'color': '#000000'
},
'align': {
'horizontal' : 'center',
'vertical': 'center',
},
'background': {
color: '#71CDE2'
}
}
},
{
'name': 'style16',
'property' : {
'font' : {
'family': 'Calibri',
'weight': 'bold',
'style': 'minor',
'size': '14',
'color': '#000000'
},
'align': {
'horizontal' : 'center',
'vertical': 'center',
},
'background': {
color: '#A4C6DE'
}
}
}
]config = {"parameters":{"status":"success","filename":"FabricUtilization","sheets":[{'name':"Dashboard",'showGridLines':false,'color':"2B803F",'charts':[{'title':"ORDER STATUS",'type':"Pie3D",'position':{'from':1,1,'to':17,5},'data':{'heading':'\'Fabric Utilization Report\'!$E$1','legends':'\'Fabric Utilization Report\'!$A$9:$A$10','data':'\'Fabric Utilization Report\'!$C$9:$C$10'}},{'title':"FABRIC UTILIZATION",'type':"Pie3D",'position':{'from':1,6,'to':17,10},'data':{'heading':'\'Fabric Utilization Report\'!$E$1','legends':'\'Fabric Utilization Report\'!$T$13,\'Fabric Utilization Report\'!$AB$13,\'Fabric Utilization Report\'!AO13','data':'\'Fabric Utilization Report\'!$T$34,\'Fabric Utilization Report\'!$AB$34,\'Fabric Utilization Report\'!AO34'}},{'title':"WASTAGE SUMMARY",'type':"Pie3D",'position':{'from':1,11,'to':17,15},'data':{'heading':'\'Fabric Utilization Report\'!$E$1','legends':'\'Fabric Utilization Report\'!$V$13,\'Fabric Utilization Report\'!$W$13,\'Fabric Utilization Report\'!X13,\'Fabric Utilization Report\'!Y13,\'Fabric Utilization Report\'!AC13,\'Fabric Utilization Report\'!AD13','data':'\'Fabric Utilization Report\'!$V$34,\'Fabric Utilization Report\'!$W$34,\'Fabric Utilization Report\'!X34,\'Fabric Utilization Report\'!Y34,\'Fabric Utilization Report\'!AC34,\'Fabric Utilization Report\'!AD34'}},{'title':"ENDBITS SUMMARY",'type':"Pie3D",'position':{'from':18,1,'to':35,5},'data':{'heading':'\'Fabric Utilization Report\'!$E$1','legends':'\'Fabric Utilization Report\'!$Y$13,\'Fabric Utilization Report\'!$Z$13,\'Fabric Utilization Report\'!AA13','data':'\'Fabric Utilization Report\'!$Y$34,\'Fabric Utilization Report\'!$Z$34,\'Fabric Utilization Report\'!AA34'}},{'title':"FABRIC STATUS",'type':"ColumnClustered",'position':{'from':18,6,'to':35,10},'data':{'heading':'\'Fabric Utilization Report\'!$E$1','legends':'\'Fabric Utilization Report\'!$P$13,\'Fabric Utilization Report\'!$R$13','data':'\'Fabric Utilization Report\'!$P$34,\'Fabric Utilization Report\'!$R$34', lableX: 'Fabric', lableY: 'Length in yards'}},{'title':"COMPLIANCE STATUS",'type':"Pie3D",'position':{'from':18,11,'to':35,15},'data':{'heading':'\'Fabric Utilization Report\'!$E$1','legends':'\'Fabric Utilization Report\'!$AR$13,\'Fabric Utilization Report\'!$AS$13','data':'\'Fabric Utilization Report\'!$AR$34,\'Fabric Utilization Report\'!$AS$34'}},{'title':"BUYING SUMMARY",'type':"Pie3D",'position':{'from':36,1,'to':52,5},'data':{'heading':'\'Fabric Utilization Report\'!$E$1','legends':'\'Fabric Utilization Report\'!$BA$13,\'Fabric Utilization Report\'!$BB$13,\'Fabric Utilization Report\'!$BC$13','data':'\'Fabric Utilization Report\'!$BA$34,\'Fabric Utilization Report\'!$BB$34,\'Fabric Utilization Report\'!$BC$34'}}],data:[]},{"name":"Fabric Utilization Report","hiddenColumn":{min:52,max:55},"data":[{"value":"Fabric Utilization Report",colspan:11,"style":"report-header"},{"value":"Overall Result","style":"style3","colspan":3},{"value":"Result Commentary","style":"style5","colspan":4},{"value":"Impact","style":"style6","colspan":4},{"value":"Extra pieces cut",colspan:2},{"value":0.0},{"value":"You have cut 66.9277 % less pieces than order quantity",colspan:4},{"value":"You are cutting 66.9277 % less pieces than target quantity",colspan:4},{"value":"Savings from BOM",colspan:2},{"value":0.4158,"style":"style2"},{"value":"Saving of 0.4158 % (BOM vs Achieved consumption)",colspan:4},{"value":"You can drop your buying by 0.4158 % without impacting extra pieces cut and save fabric",colspan:4},{"value":"Current process compliance",colspan:2},{"value":"0.0 ","style":"style2"},{"value":"Current process compliance score of the factory",colspan:4},{"value":"Improve the compliance to get better results",colspan:4},{"value":"Extra saving possible with 100% compliance",colspan:2},{"value":"NA"},{"value":"Order(s) not completed yet",colspan:4},{"value":"Order(s) need to be completed",colspan:4},{"value":"Wastage",colspan:2},{"value":0.7739,"style":"style2"},{"value":"All wastages on floor controlled to just 0.7739 %",colspan:4},{"value":"Wastages have been significantly reduced",colspan:4},{"value":"Physical fabric saving",colspan:2},{"value":"6.5556 yd"},{"value":"intelloCut has saved 6.5556 yd fabric",colspan:4},{"value":"intelloCut has saved $ 19.6667",colspan:4},{"value":"Completed orders",colspan:2},{"value":78},{"value":"Running orders",colspan:2},{"value":178},[],{"value":"Order Data","style":"style7","colspan":8},{"value":"Quantity Data","style":"style8","colspan":5},{"value":"Marker Data","style":"style9","colspan":2},{"value":"Fabric Data","style":"style10","colspan":4},{"value":"On-Floor Fabric Usage Data","style":"style11","colspan":12},{"value":"Savings Data","style":"style12","colspan":7},{"value":"Wastage Data","style":"style13","colspan":4},{"value":"Compliance Data","style":"style14","colspan":5},{"value":"$ Value Impact","style":"style15","colspan":4},{"value":"Buying Summary","style":"style7","colspan":4},{"value":"Order","style":"style16"},{"value":"Style","style":"style16"},{"value":"Product","style":"style16"},{"value":"Fit","style":"style16"},{"value":"Customer","style":"style16"},{"value":"Part","style":"style16"},{"value":"Color","style":"style16"},{"value":"Fabric","style":"style16"},{"value":"Order Quantity","style":"style16"},{"value":"Extra % Entered","style":"style16"},{"value":"Target Quantity","style":"style16"},{"value":"Cut Quantity","style":"style16"},{"value":"Extra % Cut","style":"style16"},{"value":"Marker Consumption","style":"style16"},{"value":"Marker Efficiency (%)","style":"style16"},{"value":"Total Fabric Uploaded (yd)","style":"style16"},{"value":"Unaccounted (yd)","style":"style16"},{"value":"Accounted Fabric (yd)","style":"style16"},{"value":"Unaccounted(%)","style":"style16"},{"value":"Used in Markers (yd)","style":"style16"},{"value":"Used in Trims (yd)","style":"style16"},{"value":"Used in Part Change (yd)","style":"style16"},{"value":"Wasted in Endloss (yd)","style":"style16"},{"value":"Wasted in Splicing (yd)","style":"style16"},{"value":"Unusable Endbits (yd)","style":"style16"},{"value":"Endbits Reuse Opportunity (yd)","style":"style16"},{"value":"Savings(Endbits) (yd)","style":"style16"},{"value":"Left/Savings (yd)","style":"style16"},{"value":"Damages (yd)","style":"style16"},{"value":"Used in Other Issues (yd)","style":"style16"},{"value":"Total Used Fabric (yd)","style":"style16"},{"value":"Achieved Consumption","style":"style16"},{"value":"BOM Consumption","style":"style16"},{"value":"Approved Consumption","style":"style16"},{"value":"Savings from BOM (%)","style":"style16"},{"value":"Savings from Approved Consumption (%)","style":"style16"},{"value":"Savings from Accounted (yd)","style":"style16"},{"value":"Savings from Accounted (%)","style":"style16"},{"value":"Preventable Wastage (yd)","style":"style16"},{"value":"Non Preventable wastage (yd)","style":"style16"},{"value":"Total Wastage (yd)","style":"style16"},{"value":"Wastage (%)","style":"style16"},{"value":"Total Usable Endbits Generated (yd)","style":"style16"},{"value":"Total Usable Endbits Used In Replanning (yd)","style":"style16"},{"value":"Usable Endbits Not Planned (yd)","style":"style16"},{"value":"Extra Fabric That Could Have Been Saved (%)","style":"style16"},{"value":"Current Compliance Score","style":"style16"},{"value":"Physical Fabric Value Saved ($)","style":"style16"},{"value":"Extra Pcs Possible From Reusable Endbits","style":"style16"},{"value":"Total Physical Fabric Saving Potential ($)","style":"style16"},{"value":"Saving if Compliance is 100% and Buying is Correct ($)","style":"style16"},{"value":"Ach+1%","style":"style16"},{"value":"Correct Buy","style":"style16"},{"value":"Short Buy","style":"style16"},{"value":"Excess Buy","style":"style16"},{"value":"MARS18PO8-J43630"},{"value":"J43630"},{"value":"PULL-OVER"},{"value":"REGULAR"},{"value":"MARMOT"},{"value":"Body"},{"value":"VARSITY BLUE"},{"value":"GC-2A748-BZ/VARSITYBLUE/GC-2A748-BZ.CL266377"},{"value":"329"},{"value":"0.0"},{"value":"329"},{"value":329},{"value":0.0},{"value":"0.9501"},{"value":"87.2857"},{"value":"326.46"},{"value":"12.5973"},{"value":"313.8627"},{"value":"3.8588"},{"value":"310.138"},{"value":"0.0"},{"value":"0.0"},{"value":"3.058"},{"value":"0.0"},{"value":"0.6667"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"313.8627"},{"value":"0.954"},{"value":"0.9792"},{"value":"--"},{"value":"2.5746"},{"value":"--"},{"value":"0.0"},{"value":"0.0"},{"value":"0.6667"},{"value":"3.058"},{"value":"3.7247"},{"value":"1.1867"},{"value":"NA"},{"value":"NA"},{"value":"NA"},{"value":"NA"},{"value":"NA"},{"value":"NA"},{"value":"NA"},{"value":"NA"},{"value":"NA"},{"value":0},{"value":0},{"value":0},{"value":0},{"value":"MARS18PO8-J43630"},{"value":"J43630"},{"value":"PULL-OVER"},{"value":"REGULAR"},{"value":"MARMOT"},{"value":"Body"},{"value":"SLATE GREY"},{"value":"GC-2A748-BZ/SLATE GREY/GC-2A748-BZ.CL52883"},{"value":"304"},{"value":"0.0"},{"value":"304"},{"value":"304"},{"value":"0.0"},{"value":"0.9501"},{"value":"87.9803"},{"value":"292.73"},{"value":"2.5963"},{"value":"290.1337"},{"value":"0.8869"},{"value":"286.165"},{"value":"0.0"},{"value":"0.0"},{"value":"2.552"},{"value":"0.0"},{"value":"1.4167"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"290.1337"},{"value":"0.9544"},{"value":"0.9792"},{"value":"--"},{"value":"2.534"},{"value":"--"},{"value":"0.0"},{"value":"0.0"},{"value":"1.4167"},{"value":"2.552"},{"value":"3.9687"},{"value":"1.3679"},{"value":"NA"},{"value":"NA"},{"value":"NA"},{"value":"NA"},{"value":"NA"},{"value":"NA"},{"value":"NA"},{"value":"NA"},{"value":"NA"},{"value":1.19382},{"value":0},{"value":0},{"value":0},{"value":"MARS18PO8-J43630"},{"value":"J43630"},{"value":"PULL-OVER"},{"value":"REGULAR"},{"value":"MARMOT"},{"value":"Body"},{"value":"DEEP TEAL"},{"value":"GC-2A748-BZ/DEEP TEAL/GC-2A748-BZ.CL39156"},{"value":"301"},{"value":"0.0"},{"value":"301"},{"value":"301"},{"value":"0.0"},{"value":"0.9501"},{"value":"88.1694"},{"value":"311.8"},{"value":"16.5167"},{"value":"295.2833"},{"value":"5.2972"},{"value":"291.118"},{"value":"0.0"},{"value":"0.0"},{"value":"2.332"},{"value":"0.0"},{"value":"1.8333"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"295.2833"},{"value":"0.981"},{"value":"0.9792"},{"value":"--"},{"value":"-0.1846"},{"value":"--"},{"value":"0.0"},{"value":"0.0"},{"value":"1.8333"},{"value":"2.332"},{"value":"4.1653"},{"value":"1.4106"},{"value":"NA"},{"value":"NA"},{"value":"NA"},{"value":"NA"},{"value":"NA"},{"value":"NA"},{"value":"NA"},{"value":"NA"},{"value":"NA"},{"value":1.43117},{"value":0},{"value":0},{"value":0},{"value":"TNFF18P03::NF0A3CRC"},{"value":"A3CRC"},{"value":"AO"},{"value":"BO"},{"value":"TNF"},{"value":"A"},{"value":"COSMIC BLUE"},{"value":"LF2T-FA1573DWE3RBR/COSMIC BLUE/LF2T.CL103103"},{"value":"2402"},{"value":"0.0"},{"value":"2402"},{"value":"2402"},{"value":"0.0"},{"value":"1.1705"},{"value":"0.0"},{"value":"2828.6"},{"value":"-6.5189"},{"value":"2835.1189"},{"value":"-0.2305"},{"value":"2811.52"},{"value":"0.0"},{"value":"0.0"},{"value":"12.21"},{"value":"0.0"},{"value":"4.8333"},{"value":"6.5556"},{"value":"0.0"},{"value":"6.5556"},{"value":"0.0"},{"value":"0.0"},{"value":"2828.5633"},{"value":"1.1776"},{"value":"1.1777"},{"value":"--"},{"value":"0.0096"},{"value":"--"},{"value":"6.5556"},{"value":"0.2312"},{"value":"4.8333"},{"value":"12.21"},{"value":"17.0433"},{"value":"0.6011"},{"value":"NA"},{"value":"NA"},{"value":"NA"},{"value":"NA"},{"value":"NA"},{"value":"NA"},{"value":"NA"},{"value":"NA"},{"value":"NA"},{"value":0},{"value":0},{"value":0},{"value":0},{"value":"A3C6X-R-F18P09"},{"value":"A3C6X"},{"value":"Trousers."},{"value":"BO"},{"value":"TNF"},{"value":"A"},{"value":"TNF BLACK-TNF BLACK"},{"value":" LA0K-SW-7622C6 -SSA-T1610049 (SW-7622R) MPS# 824-TNF BLACK-LA0K.CL53204"},{"value":"684"},{"value":"0.0"},{"value":"684"},{"value":"0"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"500.0"},{"value":"500.0"},{"value":"0.0"},{"value":"100.0"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"1.111"},{"value":"--"},{"value":"100.0"},{"value":"--"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"NA"},{"value":"NA"},{"value":"NA"},{"value":"NA"},{"value":"NA"},{"value":"NA"},{"value":"NA"},{"value":"NA"},{"value":"NA"},{"value":0.95344},{"value":0},{"value":0},{"value":0},{"value":"A3C6X-R-F18P09"},{"value":"A3C6X"},{"value":"Trousers."},{"value":"BO"},{"value":"TNF"},{"value":"A"},{"value":"VANADIS GREY-MID GREY"},{"value":"LA0K-SW-7622C6 - SSA-T1610049 (SW-7622R) MPS# 824-VANADISGREY-LA0K.CL103266"},{"value":"658"},{"value":"0.0"},{"value":"658"},{"value":"0"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"500.0"},{"value":"500.0"},{"value":"0.0"},{"value":"100.0"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"1.111"},{"value":"--"},{"value":"100.0"},{"value":"--"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"NA"},{"value":"NA"},{"value":"NA"},{"value":"NA"},{"value":"NA"},{"value":"NA"},{"value":"NA"},{"value":"NA"},{"value":"NA"},{"value":0.4848},{"value":0},{"value":0},{"value":0},{"value":"A3C6X-S-F18P09"},{"value":"A3C6X"},{"value":"Trousers."},{"value":"BO"},{"value":"TNF"},{"value":"A"},{"value":"TNF BLACK-TNF BLACK"},{"value":" LA0K-SW-7622C6-SSA-T1610049 (SW-7622R) MPS# 824-TNF BLACK-LA0K.CL53204"},{"value":"187"},{"value":"0.0"},{"value":"187"},{"value":"0"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"1.0"},{"value":"1.0"},{"value":"0.0"},{"value":"100.0"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"1.111"},{"value":"--"},{"value":"100.0"},{"value":"--"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"NA"},{"value":"NA"},{"value":"NA"},{"value":"NA"},{"value":"NA"},{"value":"NA"},{"value":"NA"},{"value":"NA"},{"value":"NA"},{"value":1.01303},{"value":0},{"value":0},{"value":0},{"value":"A3C6X-S-F18P09"},{"value":"A3C6X"},{"value":"Trousers."},{"value":"BO"},{"value":"TNF"},{"value":"A"},{"value":"VANADIS GREY-MID GREY"},{"value":"LA0K-SW-7622C6 - SSA-T1610049 (SW-7622R) MPS# 824-VANADISGREY-A0K.CL103266"},{"value":"183"},{"value":"0.0"},{"value":"183"},{"value":"0"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"500.0"},{"value":"500.0"},{"value":"0.0"},{"value":"100.0"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"1.111"},{"value":"--"},{"value":"100.0"},{"value":"--"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"NA"},{"value":"NA"},{"value":"NA"},{"value":"NA"},{"value":"NA"},{"value":"NA"},{"value":"NA"},{"value":"NA"},{"value":"NA"},{"value":1.03727},{"value":0},{"value":0},{"value":0},{"value":"A3C6X-L-F18P09"},{"value":"A3C6X"},{"value":"Trousers."},{"value":"BO"},{"value":"TNF"},{"value":"A"},{"value":"TNF BLACK-TNF BLACK"},{"value":" LA0K-SW-7622C6 - SSA-T1610049 (SW-7622R) MPS# 824-TNF BLACK-LA0K.CL53204"},{"value":"58"},{"value":"0.0"},{"value":"58"},{"value":"0"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"500.0"},{"value":"500.0"},{"value":"0.0"},{"value":"100.0"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"1.111"},{"value":"--"},{"value":"100.0"},{"value":"--"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"NA"},{"value":"NA"},{"value":"NA"},{"value":"NA"},{"value":"NA"},{"value":"NA"},{"value":"NA"},{"value":"NA"},{"value":"NA"},{"value":1.01707},{"value":0},{"value":0},{"value":0},{"value":"A3C6X-L-F18P09"},{"value":"A3C6X"},{"value":"Trousers."},{"value":"BO"},{"value":"TNF"},{"value":"A"},{"value":"VANADIS GREY-MID GREY"},{"value":"LA0K-SW-7622C6 - SSA-T1610049 (SW-7622R) MPS# 824-VANADISGREY-LA0K.CL103266"},{"value":"71"},{"value":"0.0"},{"value":"71"},{"value":"0"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"144.0"},{"value":"144.0"},{"value":"0.0"},{"value":"100.0"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"1.111"},{"value":"--"},{"value":"100.0"},{"value":"--"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"NA"},{"value":"NA"},{"value":"NA"},{"value":"NA"},{"value":"NA"},{"value":"NA"},{"value":"NA"},{"value":"NA"},{"value":"NA"},{"value":1.515},{"value":0},{"value":0},{"value":0},{"value":"TNFF18P03::NF0A3F4T"},{"value":"A3F4T"},{"value":"Jacket"},{"value":"AO"},{"value":"TNF"},{"value":"A"},{"value":"ASPHALT GREY"},{"value":"LAZN-FN1563DWE4R/ASPHALTGREY/LAZN.4831"},{"value":"491"},{"value":"0.0"},{"value":"491"},{"value":"0"},{"value":"0.0"},{"value":"0.9127"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"0.9172"},{"value":"--"},{"value":"100.0"},{"value":"--"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"NA"},{"value":"NA"},{"value":"NA"},{"value":"NA"},{"value":"NA"},{"value":"NA"},{"value":"NA"},{"value":"NA"},{"value":"NA"},{"value":0},{"value":0},{"value":0},{"value":1},{"value":"TNFF18P03::NF0A3F4T"},{"value":"A3F4T"},{"value":"Jacket"},{"value":"AO"},{"value":"TNF"},{"value":"B"},{"value":"ASPHALT GREY"},{"value":"LI5H-MELAN102SP/ASPHALTGREY WHITE HEATHER/LI5H*.CL282050"},{"value":"491"},{"value":"0.0"},{"value":"491"},{"value":"0"},{"value":"0.0"},{"value":"0.8004"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"0.8148"},{"value":"--"},{"value":"100.0"},{"value":"--"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"NA"},{"value":"NA"},{"value":"NA"},{"value":"NA"},{"value":"NA"},{"value":"NA"},{"value":"NA"},{"value":"NA"},{"value":"NA"},{"value":0},{"value":0},{"value":1},{"value":0},{"value":"TNFF18P03::NF0A3F4T"},{"value":"A3F4T"},{"value":"Jacket"},{"value":"AO"},{"value":"TNF"},{"value":"C"},{"value":"ASPHALT GREY"},{"value":"LEHH- MELAN102PU (SOLID)/ASPHALTGREY/LEHH.4831"},{"value":"491"},{"value":"0.0"},{"value":"491"},{"value":"0"},{"value":"0.0"},{"value":"0.2365"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"0.2437"},{"value":"--"},{"value":"100.0"},{"value":"--"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"NA"},{"value":"NA"},{"value":"NA"},{"value":"NA"},{"value":"NA"},{"value":"NA"},{"value":"NA"},{"value":"NA"},{"value":"NA"},{"value":0},{"value":0},{"value":0},{"value":1},{"value":"TNFF18P03::NF0A3F4T"},{"value":"A3F4T"},{"value":"Jacket"},{"value":"AO"},{"value":"TNF"},{"value":"D"},{"value":"ASPHALT GREY"},{"value":"HXU2-SS196SW/ASPHALTGREY/HXU2.4831"},{"value":"491"},{"value":"0.0"},{"value":"491"},{"value":"0"},{"value":"0.0"},{"value":"0.0993"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"0.1042"},{"value":"--"},{"value":"100.0"},{"value":"--"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"NA"},{"value":"NA"},{"value":"NA"},{"value":"NA"},{"value":"NA"},{"value":"NA"},{"value":"NA"},{"value":"NA"},{"value":"NA"},{"value":0},{"value":0},{"value":1},{"value":0},{"value":"TNFF18P03::NF0A3F4T"},{"value":"A3F4T"},{"value":"Jacket"},{"value":"AO"},{"value":"TNF"},{"value":"F"},{"value":"ASPHALT GREY"},{"value":"LC6K-TH16786DWE4R/ASPHALTGREY/LC6K.4831"},{"value":"491"},{"value":"0.0"},{"value":"491"},{"value":"0"},{"value":"0.0"},{"value":"0.3501"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"0.3493"},{"value":"--"},{"value":"100.0"},{"value":"--"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"NA"},{"value":"NA"},{"value":"NA"},{"value":"NA"},{"value":"NA"},{"value":"NA"},{"value":"NA"},{"value":"NA"},{"value":"NA"},{"value":0},{"value":0},{"value":1},{"value":0},{"value":"TNFF18P03::NF0A3F4T"},{"value":"A3F4T"},{"value":"Jacket"},{"value":"AO"},{"value":"TNF"},{"value":"H"},{"value":"ASPHALT GREY"},{"value":"JCM5-M598-0112KPJA/ASPHALTGREY/JCM5.4831"},{"value":"491"},{"value":"0.0"},{"value":"491"},{"value":"0"},{"value":"0.0"},{"value":"1.171"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"1.204"},{"value":"--"},{"value":"100.0"},{"value":"--"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"NA"},{"value":"NA"},{"value":"NA"},{"value":"NA"},{"value":"NA"},{"value":"NA"},{"value":"NA"},{"value":"NA"},{"value":"NA"},{"value":0},{"value":0},{"value":1},{"value":0},{"value":"TNFF18P03::NF0A3F4T"},{"value":"A3F4T"},{"value":"Jacket"},{"value":"AO"},{"value":"TNF"},{"value":"P"},{"value":"ASPHALT GREY"},{"value":"TE00-A0402/WHITE/TE00*.4845"},{"value":"491"},{"value":"0.0"},{"value":"491"},{"value":"0"},{"value":"0.0"},{"value":"0.0628"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0651"},{"value":"--"},{"value":"100.0"},{"value":"--"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"NA"},{"value":"NA"},{"value":"NA"},{"value":"NA"},{"value":"NA"},{"value":"NA"},{"value":"NA"},{"value":"NA"},{"value":"NA"},{"value":0},{"value":0},{"value":1},{"value":0},{"value":"TNFF18P03::NF0A3F4T"},{"value":"A3F4T"},{"value":"Jacket"},{"value":"AO"},{"value":"TNF"},{"value":"E1"},{"value":"ASPHALT GREY"},{"value":"L98E-60G/WHITE/L98E-60G.4845"},{"value":"491"},{"value":"0.0"},{"value":"491"},{"value":"0"},{"value":"0.0"},{"value":"0.3344"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"0.3564"},{"value":"--"},{"value":"100.0"},{"value":"--"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"NA"},{"value":"NA"},{"value":"NA"},{"value":"NA"},{"value":"NA"},{"value":"NA"},{"value":"NA"},{"value":"NA"},{"value":"NA"},{"value":0},{"value":0},{"value":1},{"value":0},{"value":"TNFF18P03::NF0A3F4T"},{"value":"A3F4T"},{"value":"Jacket"},{"value":"AO"},{"value":"TNF"},{"value":"E2"},{"value":"ASPHALT GREY"},{"value":"L6UH-40G/WHITE/L6UH-40G.4845"},{"value":"491"},{"value":"0.0"},{"value":"491"},{"value":"0"},{"value":"0.0"},{"value":"0.5838"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"0.586"},{"value":"--"},{"value":"100.0"},{"value":"--"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"NA"},{"value":"NA"},{"value":"NA"},{"value":"NA"},{"value":"NA"},{"value":"NA"},{"value":"NA"},{"value":"NA"},{"value":"NA"},{"value":"TNFF18P03::NF0A3F4T"},{"value":"A3F4T"},{"value":"Jacket"},{"value":"AO"},{"value":"TNF"},{"value":"G"},{"value":"ASPHALT GREY"},{"value":"TGP2 - PF 40GR/WHITE/TGP2.4845"},{"value":"491"},{"value":"0.0"},{"value":"491"},{"value":"0"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0377"},{"value":"--"},{"value":"100.0"},{"value":"--"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"0.0"},{"value":"NA"},{"value":"NA"},{"value":"NA"},{"value":"NA"},{"value":"NA"},{"value":"NA"},{"value":"NA"},{"value":"NA"},{"value":"NA"},{"value":0},{"value":0},{"value":1},{"value":0},{"value":"Total","colspan":8},{"value":10087,"formula":"SUM(I14:I33)"},{},{"value":10087,"formula":"SUM(K14:K33)"},{"value":3336,"formula":"SUM(L14:L33)"},{},{},{},{"value":5904.59,"formula":"SUM(P14:P33)"},{"value":2170.1914,"formula":"SUM(Q14:Q33)"},{"value":3734.3986,"formula":"SUM(R14:R33)"},{},{"value":3698.941,"formula":"SUM(T14:T33)"},{"value":0,"formula":"SUM(U14:U33)"},{"value":0,"formula":"SUM(V14:V33)"},{"value":20.152,"formula":"SUM(W14:W33)"},{"value":0,"formula":"SUM(X14:X33)"},{"value":8.75,"formula":"SUM(Y14:Y33)"},{"value":6.5556,"formula":"SUM(Z14:Z33)"},{"value":0,"formula":"SUM(AA14:AA33)"},{"value":6.5556,"formula":"SUM(AB14:AB33)"},{"value":0,"formula":"SUM(AC14:AC33)"},{"value":0,"formula":"SUM(AD14:AD33)"},{"value":3727.843,"formula":"SUM(AE14:AE33)"},{},{},{},{},{},{"value":6.556,"formula":"SUM(AK14:AK33)"},{"value":0.175546338,"formula":"(SUM(AK14:AK33)/R34)100"},{"value":8.75,"formula":"SUM(AM14:AM33)"},{"value":20.152,"formula":"SUM(AN14:AN33)"},{"value":28.902,"formula":"SUM(AO14:AO33)"},{"value":0.773939879,"formula":"(SUM(AO14:AO33)/R34)100"},{"value":0,"formula":"SUM(AQ14:AQ33)"},{"value":0,"formula":"SUM(AR14:AR33)"},{"value":0,"formula":"SUM(AS14:AS33)"},{"value":0,"formula":"(AS34/R34)100"},{"value":0,"formula":"(SUM(AS14:AS33)/AR14)100"},{"value":0,"formula":"SUM(AV14:AV33)"},{"value":0,"formula":"SUM(AW14:AW33)"},{"value":0,"formula":"SUM(AX14:AX33)"},{},{},{"value":0,"formula":"SUM(BA14:BA33)"},{"value":7,"formula":"SUM(BB14:BB33)"},{"value":2,"formula":"SUM(BC14:BC33)"}]}]}} config = config.parameters config.styles = styles DecodeXLSX(config)