{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["5 Channel - Latest 12wk","Retailer A","Retailer B","Retailer C"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"5 Channel - Latest 12wk","index":0,"n_rows":29,"n_cols":52,"rows_kept":29,"cut":false,"hidden":false,"merged":[]}
[null,null,"$ Volume",null,"Eq Volume",null,"$ Share ",null,"Eq Share ",null,"Base Dollars",null,"Incr. $ Vol",null,"Non-Promoted Dollars",null,"Promoted Dollars",null,"Dollar Sales Feature & Display",null,"Dollar Sales Feat w/o Disp",null,"Dollar Sales Disp w/o Feat",null,"Dollar Sales Any Feature",null,"Dollar Sales Any Feature Yago",null,"Dollar Sales Any Display",null,"Dollar Sales TPR Only",null,"ANI",null,"% ACV Selling",null,"$ per Point of Distribution",null,"%ACV No Promo",null,"%ACV Any Promo",null,"Avg Price per Eq",null,"Everyday (Base) Price per Eq",null,"Non Promo Price per Eq",null,"Any Promo Price per Eq",null,"% Discount Any Promo Eq"]
[null,null,"12 W/E CUR DEC3111.4","12 W/E YAGO JAN0111.4","12 W/E CUR DEC3111.4","12 W/E YAGO JAN0111.4","12 W/E CUR DEC3111.4","12 W/E YAGO JAN0111.4","12 W/E CUR DEC3111.4","12 W/E YAGO JAN0111.4","12 W/E CUR DEC3111.4","12 W/E YAGO JAN0111.4","12 W/E CUR DEC3111.4","12 W/E YAGO JAN0111.4","12 W/E CUR DEC3111.4","12 W/E YAGO JAN0111.4","12 W/E CUR DEC3111.4","12 W/E YAGO JAN0111.4","12 W/E CUR DEC3111.4","12 W/E YAGO JAN0111.4","12 W/E CUR DEC3111.4","12 W/E YAGO JAN0111.4","12 W/E CUR DEC3111.4","12 W/E YAGO JAN0111.4","12 W/E CUR DEC3111.4","12 W/E YAGO JAN0111.4","12 W/E CUR DEC3111.4","12 W/E YAGO JAN0111.4","12 W/E CUR DEC3111.4","12 W/E YAGO JAN0111.4","12 W/E CUR DEC3111.4","12 W/E YAGO JAN0111.4","12 W/E CUR DEC3111.4","12 W/E YAGO JAN0111.4","12 W/E CUR DEC3111.4","12 W/E YAGO JAN0111.4","12 W/E CUR DEC3111.4","12 W/E YAGO JAN0111.4","12 W/E CUR DEC3111.4","12 W/E YAGO JAN0111.4","12 W/E CUR DEC3111.4","12 W/E YAGO JAN0111.4","12 W/E CUR DEC3111.4","12 W/E YAGO JAN0111.4","12 W/E CUR DEC3111.4","12 W/E YAGO JAN0111.4","12 W/E CUR DEC3111.4","12 W/E YAGO JAN0111.4","12 W/E CUR DEC3111.4","12 W/E YAGO JAN0111.4","12 W/E CUR DEC3111.4","12 W/E YAGO JAN0111.4"]
[null,"Total 5 Channel Retailers"]
[null,"Total Category",194875567,189411314,30906681,31530947,100,100,100,100,167879869,164848096,26995698,24563218,121398305,118357784,73477262,71053528,6257202,5273147,22649137,23785501,11125651,8832196,28906339,29058648,29058648,26714446,17382853,14105343,33445272,33162688,51.044217687074827,49.227891156462583,98,98,1988526.1938775512,1932768.5102040817,98,98,95,95.333333333333329,6.3052893644581252,6.0071558903701812,6.7331307429984291,6.3709684849650365,6.6014447686544671,6.1426503105246759,5.8701857669853661,5.7942562974444884,17.937123783497572,17.868335452960078]
[null,"Brand A",1182,1216,157,196,6.0654089078288607E-4,6.4198910525482128E-4,5.0798078253695375E-4,6.2161152343442145E-4,1137,1336,45,-120,1093,930,89,286,0,0,0,0,0,0,0,0,0,0,0,0,89,286,0,0,0,0,0,0,0,0,0,0,7.5286624203821653,6.204081632653061,7.6308724832214763,6.6138613861386135,7.4863013698630141,5.705521472392638,7.416666666666667,8.6666666666666661,12.442129629629626,11.662075298438939]
[null,"Brand B",694756,768444,297045,271019,0.35651262531028327,0.40570121381450314,0.96110287610630207,0.85953333402894616,675175,754624,19581,13820,539030,668323,155730,100119,403,461,7402,18419,9650,13893,7805,18880,18880,60534,10053,14354,138271,67350,1.8166666666666667,1.7580645161290323,20,20.666666666666668,34737.800000000003,37206.635714285716,19.333333333333332,19.666666666666668,9.3333333333333339,4,2.3388914137588581,2.8353879248318385,2.4527290890927254,2.8760728714078816,2.4513620446586928,2.8050979421035622,2.0183783503551247,3.0556691591637417,18.882349899537235,13.94612946420172]
[null,"Brand C",19177472,16592446,2694802,2206017,9.8408806682266121,8.7600078630994567,8.7191568709690959,6.9963550412868987,16440511,14707582,2736961,1884864,11508703,10868033,7668771,5724414,561961,225910,1811180,1059288,553885,805464,2373141,1285198,1285198,2243138,1115846,1031374,4741744,3633751,6.5142857142857142,6.0647773279352224,81.666666666666671,82.333333333333329,234852.96356519122,201516.37628563031,77.666666666666671,80,64.333333333333329,57.666666666666664,7.1164679260294452,7.5214497440409573,7.5945412466855755,7.9799497251049472,7.577332728482987,7.9474837310353852,6.5212467696797614,6.826652069850061,14.565874024303794,15.625169836889571]
[null,"Brand D",460869,452621,73714,53761,0.23649398798157184,0.23896196612626847,0.23850506626706378,0.17050233220080577,394842,388166,66027,64455,325691,328961,135178,123660,14831,0,8718,2806,60381,36166,23549,2806,2806,10540,75212,36166,51249,84689,1.8,1.5,3.3333333333333335,4,141011,113155.25,3,3.3333333333333335,1,1.3333333333333333,6.2521230702444583,8.4191328286304206,6.3499839176584114,8.2261216012884901,6.2054110698294753,7.9426563971316124,6.3670105035090199,10.018634043587458,6.382624371081282,5.1670226099417516]
[null,"Brand E",16440032,18511229,4405886,5038081,8.4361689118266945,9.7730323543397191,14.255448522602604,15.978210232632723,15497893,17283970,942139,1227259,11971902,13421332,4468131,5089897,111369,98497,405105,792741,525881,515506,516474,891238,891238,1210068,637250,614003,3425776,3683152,7.8901960784313729,8.5294117647058822,85,85,193412.14117647058,217779.16470588234,84.333333333333329,84.666666666666671,59.666666666666664,63.333333333333336,3.7313793411813196,3.6742618866191314,4.0508386637419989,3.97184909153331,4.0864238617431203,3.9427587053758968,3.0267563376780147,3.1149291354580968,23.22416773240937,23.664400580199356]
[null,"Brand F",478228,509213,42203,46835,0.24540172344950767,0.26883980119582507,0.136549764110873,0.14853661071454657,468826,492637,9402,16576,413861,400369,64367,108845,0,0,136,4909,2157,3972,136,4909,4909,1523,2157,3972,62074,99963,1.5,1.6515151515151516,24,22,19926.166666666668,23146.045454545456,22.666666666666668,19.333333333333332,5.666666666666667,6.666666666666667,11.331611496813023,10.872488523540088,11.602306473965552,11.376246997967856,11.540055210105121,11.374765611682482,10.154125256349582,9.3533556758614758,16.74702230962011,17.554719714792917]
[null,"Brand G",4420069,4476097,1326049,1277813,2.2681493981233674,2.3631624243945639,4.2904930490595214,4.0525677836444309,3769420,3898907,650649,577190,3058127,2870394,1361942,1605702,207201,106526,488647,501280,66268,63446,695848,607806,607806,436752,273469,169972,599823,934451,2.2769230769230768,2.3377192982456139,65,76,68027.372523667596,58892.857252221453,60,71.666666666666671,28.333333333333332,35.333333333333336,3.3332621946851133,3.5029358755936904,3.7734991525839434,3.9510249703843399,3.7020998678049324,3.9867413904456344,2.7239003434020606,2.8784945870314633,34.082145497679484,26.210087886614968]
[null,"Brand H",1316852,1287864,361183,323086,0.67573991972015657,0.67992981665287422,1.1686243501849971,1.0246631666343546,983240,1096335,333612,191529,613762,752556,703088,535308,187150,100816,284524,100251,63390,108576,471674,201067,201067,426151,250540,209392,168024,225666,2.180327868852459,2.3650793650793651,20.333333333333332,21,64854.240476190476,61326.857142857145,18,19.666666666666668,8.6666666666666661,8.3333333333333339,3.6459412541564804,3.9861337229096896,4.5864139079489323,4.6525054743596268,4.7168920996003685,4.7074174621245293,3.0428279610843747,3.2796917025591386,31.214707267467624,28.638467585439891]
[null,"Brand I",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Brand J",14877353,15089281,1821712,1865145,7.6342833681145876,7.9664095461583679,5.8942336771780832,5.9152838003882344,11361272,11096069,3516081,3993212,7886185,7780303,6991168,7308976,958262,1225724,1559787,1216382,1955824,2017360,2518049,2442106,2442106,2210207,2914086,3243084,2517293,2849510,3.4112149532710281,2.965686274509804,71.333333333333329,68,208491.56064162753,221901.19117647057,67.666666666666671,65.666666666666671,37,26.666666666666668,8.1666877091439254,8.0901383002393921,9.1956503615930334,9.4335477179305158,9.1727237092945213,9.5310058004569314,7.2675605970670576,6.9687012849568424,21.509149969390336,24.667464256532888]
[null,"Brand K",0,278,0,11,0,1.4677053557634896E-4,0,3.4886361009074669E-5,0,366,0,-88,0,278,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,25.272727272727273,0,24.4,0,25.272727272727273,0,0,0,0]
[null,"Brand L",6795562,4248003,676960,670712,3.4871287892134775,2.2427398397120037,2.1903354811860907,2.1271546331925903,6134016,3251433,661546,996570,4814005,2253036,1981557,1994966,173081,309155,645538,613180,197805,147461,818619,922335,922335,521932,370886,456616,965129,925168,3.0042918454935621,2.2160493827160495,77.666666666666671,54,87498.596405814926,78654.453490883679,69,49.666666666666664,37.333333333333336,22.666666666666668,10.038350862680218,6.3335723827812833,10.91932113116324,6.9637551723251692,10.771128304723719,6.6281165329591287,8.6144914053193986,6.0309138728498439,28.06200003201641,23.759057888984231]
[null,"Brand M",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Brand N",180284,173911,13417,12636,9.2512367135280729E-2,9.1816584937476325E-2,4.3411325855403235E-2,4.0074914337333414E-2,179190,172790,1094,1121,139405,169475,40879,4434,0,0,0,0,645,2109,0,0,0,0,645,2109,40234,2325,1,1.0571428571428572,11,11.666666666666666,16389.454545454544,14968.409090909092,9.6666666666666661,11.333333333333334,5.666666666666667,0.66666666666666663,13.436982932101065,13.763137068692624,13.978469459396209,13.849791599871754,13.939106089391061,13.758321156031823,11.959918080748976,13.899686520376175,14.153411602619299,6.9143869931346593]
[null,"Brand O",36989339,38228540,7029368,7325610,18.981003914154101,20.182817590294526,22.743846225351732,23.233079551971592,32259890,33700146,4729449,4528394,22375353,24147220,14613985,14081320,899277,656306,4904346,6332228,1915355,1304761,5803623,6988534,6988534,4031283,2814632,1961067,6895009,5788023,9.5520833333333339,9.9791666666666661,96,96,385305.61458333337,398213.95833333337,95,95,82,81,5.2621144603611594,5.2184787341941492,5.7602050254299817,5.6113172285341406,5.7885041990893242,5.5521189003009752,4.6189971386462281,4.7309570789884896,19.74267103616577,18.160877139428969]
[null,"Brand P",74523114,71620783,8263732,8355076,38.241384052008939,37.812304601825417,26.737688204048826,26.498017963114144,63450429,62510340,11072685,9110443,44949135,42030204,29573982,29590580,2446915,2165016,10924005,12103515,4793929,3106619,13370920,14268531,14268531,14075420,7240844,5271635,11409128,12215430,16.093425605536332,15.451724137931034,96.333333333333329,96.666666666666671,773589.33000429557,740907.47454896907,96,96,86,86.666666666666671,9.0180942460379878,8.5721282487436383,9.5967950097608341,9.1148269475454846,9.4204982669722082,8.9312804733576918,8.4683079666685082,8.1089677012362991,15.669087946429846,15.057119261810293]
[null,"Brand Q",10560447,9984015,1622148,1575823,5.4190718531687461,5.2710763624183503,5.2485350982850596,4.9977027331275519,9488211,9251182,1072236,732833,7392034,7914200,3168413,2069814,213156,126852,1031852,540334,517798,171730,1245008,667186,667186,693408,730954,298582,1405610,1230899,4.331818181818182,3.5165876777251186,73.333333333333329,70.333333333333329,144024.39707515735,141933.85895372232,68.666666666666671,67,45.666666666666664,33.333333333333336,6.5101624512683181,6.3357464639112386,7.0780922697731601,6.6736318458205677,7.0753078443477717,6.5682477977754505,5.487560207211529,5.5804123405597625,23.308348929857353,25.080681098021451]
[null,"Brand R",2518362,2354751,300913,278155,1.2922923272366926,1.2431944799242562,0.97361796952574764,0.88216506786174231,1680195,1705019,838167,649732,1336798,1256567,1181567,1098185,400050,232586,349366,369375,160356,140156,749416,601961,601961,370477,560406,372742,271792,356068,1.873015873015873,1.921875,21,21.333333333333332,119922,110237.16233766233,20,19.666666666666668,8.3333333333333339,10.333333333333334,8.3690701299046566,8.4656073052794305,9.8663789306791152,9.5159956243651429,9.7946117831524813,9.44879574695271,7.1860107282303289,7.5649247768103161,28.834687764211616,21.959595046836704]
[null,"Brand S",2730896,2399125,1578298,1840179,1.4013537161382574,1.266621802750389,5.1066563892771279,5.8361044468470933,2595060,2268736,135836,130389,2205847,1706270,525048,692855,18565,13634,146825,86201,49000,65204,165390,99835,99835,245802,67565,78838,310660,527817,4.1444444444444448,4.4285714285714288,30,28,91029.866666666669,85683.03571428571,28.333333333333332,26.666666666666668,14,15.333333333333334,1.7302790727733293,1.3037454508501618,1.771122968374413,1.3326010712563443,1.7404203177789244,1.1581374449530575,1.6889197691698994,1.8884594523139151,25.801356188812758,26.038973184421447]
[null,"Brand T",207692,261128,43345,56191,0.10657672647079457,0.1378629367409383,0.14024475808321185,0.17820904649644681,205200,251554,2492,9574,196306,234037,11385,27092,0,0,1657,10660,0,223,1657,10660,10660,4783,0,223,9729,16207,1.5185185185185186,1.4838709677419355,9,10.333333333333334,23076.888888888891,25329.636363636364,9,10,0.66666666666666663,0.66666666666666663,4.7916022609297499,4.6471498994500902,4.8368847821987551,4.7562631170942922,4.8246657491152183,4.7225820772040281,4.2849077907414381,4.0844263530830691,19.831334714881422,22.134704329506985]
[null,"Brand U",25,48,1,2,1.2828699043631264E-5,2.5341675207427154E-5,3.2355463855856926E-6,6.3429747289226678E-6,25,52,0,-4,25,48,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,25,24,25,26,25,24,0,0,0,0]
[null,"Brand V",1680969,1597311,204613,173389,0.86258581610695195,0.84330284515105569,0.66203485259384531,0.54990102263658625,1492074,1182640,188895,414671,967318,801053,713649,796258,64894,11118,76175,27326,207331,287296,141069,38444,38444,155120,272225,298414,365250,470517,4.3499999999999996,4,6.666666666666667,7,253250.9523809524,228187.28571428571,6,7,3.6666666666666665,2.6666666666666665,8.2153577729665272,9.2122972045516143,9.0417219626592971,10.704174360088338,9.1816844323370006,10.518165942304915,7.1894764413729186,8.1893429050405739,18.830294985767594,25.056610076222448]
[null,"Brand W",371958,333936,23415,20534,0.19086948955483987,0.17630203441807074,7.5760318618488989E-2,6.5123321541849036E-2,360181,327107,11777,6829,312800,295319,59157,38618,62,0,739,2305,14578,8431,801,2305,2305,113,14640,8431,43778,27882,2.161290322580645,2.103448275862069,10.333333333333334,9.6666666666666661,36005.272727272728,34571.533333333333,9,8.6666666666666661,2.3333333333333335,2,15.885458039718129,16.262588876984513,16.14292757260667,16.781602708803611,16.558149383304219,17.064544088755344,13.073370165745857,11.959739857541035,12.096616232746383,19.206175542288097]
[null,"Brand X",68,978,24,341,3.4894061398677038E-5,5.1633663235132825E-4,7.7653113254056615E-5,1.081477191281315E-3,71,943,-3,35,68,975,0,3,0,0,0,0,0,0,0,0,0,0,0,0,0,3,0,0,0,0,0,0,0,0,0,0,2.8333333333333335,2.8680351906158359,2.84,2.8837920489296636,2.8333333333333335,2.8761061946902653,0,1.5,0,50]
[null,"Brand Y",450034,519241,127687,140225,0.23093402981606206,0.27413409950791007,0.41313721133628029,0.44472181568159053,443009,505318,7025,13923,390853,457042,59182,62197,23,548,3136,4303,31412,33821,3159,4851,4851,17195,31435,34369,24610,23525,1.5272727272727273,1.6557377049180328,18.333333333333332,20.333333333333332,24552.92105263158,25532.852380952383,17.333333333333332,19,2.6666666666666665,2.6666666666666665,3.5245091512839992,3.7029131752540558,3.5872045474788861,3.7706921768199861,3.5732191179697215,3.7035338351957345,3.2332823426573425,3.6978002378121286,13.642010815243891,16.502161379430021]

{"sheet":"Retailer A","index":1,"n_rows":29,"n_cols":52,"rows_kept":29,"cut":false,"hidden":false,"merged":[]}
[null,null,"$ Volume",null,"Eq Volume",null,"$ Share ",null,"Eq Share ",null,"Base Dollars",null,"Incr. $ Vol",null,"Non-Promoted Dollars",null,"Promoted Dollars",null,"Dollar Sales Feature & Display",null,"Dollar Sales Feat w/o Disp",null,"Dollar Sales Disp w/o Feat",null,"Dollar Sales Any Feature",null,"Dollar Sales Any Feature Yago",null,"Dollar Sales Any Display",null,"Dollar Sales TPR Only",null,"ANI",null,"% ACV Selling",null,"$ per Point of Distribution",null,"%ACV No Promo",null,"%ACV Any Promo",null,"Avg Price per Eq",null,"Everyday (Base) Price per Eq",null,"Non Promo Price per Eq",null,"Any Promo Price per Eq",null,"% Discount Any Promo Eq"]
[null,null,"12 W/E CUR DEC3111.4","12 W/E YAGO JAN0111.4","12 W/E CUR DEC3111.4","12 W/E YAGO JAN0111.4","12 W/E CUR DEC3111.4","12 W/E YAGO JAN0111.4","12 W/E CUR DEC3111.4","12 W/E YAGO JAN0111.4","12 W/E CUR DEC3111.4","12 W/E YAGO JAN0111.4","12 W/E CUR DEC3111.4","12 W/E YAGO JAN0111.4","12 W/E CUR DEC3111.4","12 W/E YAGO JAN0111.4","12 W/E CUR DEC3111.4","12 W/E YAGO JAN0111.4","12 W/E CUR DEC3111.4","12 W/E YAGO JAN0111.4","12 W/E CUR DEC3111.4","12 W/E YAGO JAN0111.4","12 W/E CUR DEC3111.4","12 W/E YAGO JAN0111.4","12 W/E CUR DEC3111.4","12 W/E YAGO JAN0111.4","12 W/E CUR DEC3111.4","12 W/E YAGO JAN0111.4","12 W/E CUR DEC3111.4","12 W/E YAGO JAN0111.4","12 W/E CUR DEC3111.4","12 W/E YAGO JAN0111.4","12 W/E CUR DEC3111.4","12 W/E YAGO JAN0111.4","12 W/E CUR DEC3111.4","12 W/E YAGO JAN0111.4","12 W/E CUR DEC3111.4","12 W/E YAGO JAN0111.4","12 W/E CUR DEC3111.4","12 W/E YAGO JAN0111.4","12 W/E CUR DEC3111.4","12 W/E YAGO JAN0111.4","12 W/E CUR DEC3111.4","12 W/E YAGO JAN0111.4","12 W/E CUR DEC3111.4","12 W/E YAGO JAN0111.4","12 W/E CUR DEC3111.4","12 W/E YAGO JAN0111.4","12 W/E CUR DEC3111.4","12 W/E YAGO JAN0111.4","12 W/E CUR DEC3111.4","12 W/E YAGO JAN0111.4"]
["Retailer A"]
[null,"Total Category",23716824,23206681,3748701,3853449,100,100,100,100,21811593,19509553,1905231,3697128,14072702,12330566,9644122,10876115,516101,932847,1225535,2501583,1555003,900889,1741636,3434430,3434430,1735579,2071104,1833736,6347482,6540796,66.75333333333333,58.623333333333335,100,100,237168.24,232066.81,100,100,100,100,6.3266779612457755,6.022314295582996,6.7214242462061859,6.5727104646281704,6.6642493077756901,6.701933633792283,5.8912310709027933,5.4013365137115326,14.087946025814935,15.514117481999751]
[null,"Brand A",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Brand B",34810,38799,8127,7929,0.14677344656265948,0.16718892287957937,0.2167950978218855,0.20576371972225402,35444,37329,-634,1470,34435,30011,376,8788,0,0,0,0,0,0,0,0,0,0,0,0,376,8788,1.2105263157894737,1.2807017543859649,19,19,1832.1052631578948,2042.0526315789475,19,19,0.33333333333333331,2,4.283253353020795,4.8933030646992055,4.3030229452470561,5.2171907756813418,4.2776397515527949,5.2687851123595504,4.9473684210526319,3.9372759856630823,17.797570850202419,20.598134218788829]
[null,"Brand C",3094729,2444736,414841,311922,13.048665369359741,10.534621473876424,11.066260019137296,8.0946186130918036,2655995,2338750,438734,105986,1475881,1694164,1618848,750572,228326,5536,287431,56415,253027,58619,515757,61951,61951,188206,481353,64155,850061,630002,8.0933333333333337,8.1033333333333335,100,100,30947.29,24447.360000000001,95,97.666666666666671,98,84,7.4600364959104812,7.8376517206224632,8.1491237220947212,8.2247831927808299,8.2359890401174116,8.1013963274674836,6.8699467836803283,7.3011420011283823,14.871866429964786,16.495759648727951]
[null,"Brand D",50042,53943,5062,5451,0.21099789752624551,0.23244599260014823,0.13503344225106242,0.14145769153815194,52071,51767,-2029,2176,50042,53286,0,656,0,0,0,0,0,102,0,0,0,0,0,102,0,554,1,1,4,4,12510.5,13485.75,4,4,0,0.33333333333333331,9.8858158830501779,9.8959823885525591,9.895667046750285,9.9094563552833073,9.8858158830501779,9.9007803790412492,0,9.5072463768115938,0,4.4022740011209924]
[null,"Brand E",2432493,2689467,805892,884627,10.256402796597049,11.589192784612328,21.49790020596468,22.956758996940145,2271852,2430837,160641,258630,1493717,1462472,938777,1226993,0,0,0,0,11806,45465,0,0,0,1068,11806,45465,926972,1181529,9.8866666666666667,10.876666666666667,100,100,24324.93,26894.67,100,99.666666666666671,95.333333333333329,93.666666666666671,3.0183858383009139,3.0402271239742853,3.2810033129894025,3.3774759628744513,3.4052748445222591,3.5209406689072718,2.5562759364346319,2.6147123693435477,16.556333960728921,17.648410325353932]
[null,"Brand F",75527,78675,5585,6260,0.31845326338804891,0.3390187506778759,0.14898494171714416,0.16245187103812717,76140,78023,-613,652,67606,53276,7921,25399,0,0,0,0,1134,2556,0,0,0,0,1134,2556,6788,22841,1.3062499999999999,1.2993630573248407,53.333333333333336,52.333333333333336,1416.3759608665268,1503.6948476052248,51,41,7,17,13.523187108325873,12.567891373801917,14.071336167067086,14.068337540569781,14.113987473903967,14.03477344573235,9.9510050251256281,10.308035714285714,29.411042365055586,27.402425977239307]
[null,"Brand G",913591,871373,272773,264193,3.8520798568982086,3.7548368075555483,7.2764672349168418,6.8560139241495079,916236,804484,-2645,66889,835797,362309,77794,509064,0,1492,0,55896,3688,6523,0,57388,57388,5031,3688,8015,74106,445153,3.4133333333333336,3.5084175084175082,100,99,9135.91,8801.7474747474753,96.666666666666671,91.333333333333329,39.333333333333336,89,3.3492721053769983,3.2982440867093374,3.3944347091577969,3.6109520175950447,3.3266743883362988,3.5447163221179716,3.6127803835972694,3.1427195614327519,16.783648338585785,15.547774750358801]
[null,"Brand H",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Brand I",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Brand J",2300647,2786769,293358,364807,9.7004851914404728,12.008477213954032,7.8255907846478028,9.4670255140265258,1921386,1879240,379261,907529,1399938,1184678,900709,1602090,111540,279756,117713,257787,179378,176829,229253,537543,537543,449632,290918,456585,492079,887717,5.8979591836734695,4.0442176870748296,98,98,23475.989795918365,28436.418367346938,95,90.666666666666671,62,67.333333333333329,7.8424552935321348,7.6390228257681461,8.506902444855708,9.4099385102249276,8.3693310217014414,9.2065310309454613,7.14343836496443,6.7848083039355602,20.374202024599889,31.188368578848468]
[null,"Brand K",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Brand L",658587,441775,62600,64440,2.776876870191388,1.90365438297704,1.6699117907776586,1.6722681421241077,672322,392617,-13735,49158,637639,228119,20949,213655,0,0,0,0,2876,15967,0,0,0,0,2876,15967,18074,197688,3.3727598566308243,1.864963503649635,93,91.333333333333329,7081.5806451612907,4833.1894409937886,93,85.666666666666671,15,56.666666666666664,10.52055910543131,6.8556021104903788,10.4801409153261,7.2055681985024229,10.702411923664378,7.2105130069222749,6.93216412971542,6.5134747881226751,23.105210777951125,11.358082088586125]
[null,"Brand M",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Brand N",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Brand O",3949103,4651871,761446,902069,16.651061710454993,20.045395547945869,20.312262834512541,23.409392468928484,3740031,3919787,209072,732084,2076152,2600359,1872951,2051513,23302,179077,214947,712400,240346,136810,238249,891477,891477,242817,263648,315887,1394355,1023226,10.98,9.9933333333333341,100,100,39491.03,46518.71,100,98.666666666666671,98,99,5.1863205007315027,5.1568904374277356,5.7156866790454579,5.6851928937028715,5.6956558715004872,5.7224825103265546,4.7185808112745038,4.5827583048704481,18.664346382111262,18.280194157714945]
[null,"Brand P",9027401,8242100,959021,935898,38.06327946777359,35.51606539513341,25.582755199734521,24.287281341987399,8317016,6766716,710385,1475384,5157280,3991311,3870121,4250788,149916,459682,604965,1417919,829658,430835,754881,1877601,1877601,843261,979574,890517,2285582,1942353,19.926666666666666,16.616666666666667,100,100,90274.01,82421,100,100,100,100,9.413142152257354,8.8066220891592888,9.899677430873794,9.822579380862658,9.8491859632370495,9.7959263313420681,8.8887584836757423,8.0438488263834742,11.239881433881374,18.634208910605849]
[null,"Brand Q",851866,646364,124870,80648,3.5918215693635873,2.7852496442726986,3.3310205321790134,2.0928783539110025,829408,592336,22458,54028,566072,502670,285794,143695,3016,7304,478,1165,16138,8935,3494,8469,8469,5564,19154,16239,266162,126291,3.1077441077441077,1.7912087912087913,99,91,8604.7070707070707,7102.9010989011003,92.666666666666671,89.666666666666671,66.666666666666671,55.666666666666664,6.8220229038199731,8.0146314849717282,6.9299243848435479,8.281987108681367,6.9797538901630043,8.2282169222962462,6.5298969543263192,7.3474970598762592,5.2024569157380567,14.515602672136563]
[null,"Brand R",0,30,0,3,0,1.2927311751301273E-4,0,7.7852334363319719E-5,0,30,0,0,0,30,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,10,0,10,0,10,0,0,0,0]
[null,"Brand S",112,667,43,171,4.7223861002636779E-4,2.8741723127059834E-3,1.1470640096396059E-3,4.4375830587092234E-3,110,695,2,-28,108,465,4,202,0,0,0,0,0,0,0,0,0,0,0,0,4,202,1,1,0.66666666666666663,2.6666666666666665,90,265.8,0.66666666666666663,1.3333333333333333,0,1,2.6046511627906979,3.9005847953216373,2.6190476190476191,4.2121212121212119,2.6341463414634148,3.9406779661016951,4,3.6727272727272728,33.333333333333329,22.918069584736248]
[null,"Brand T",856,1203,198,280,3.609252233772954E-3,5.1838520122718112E-3,5.2818296257823704E-3,7.2662178739098405E-3,1092,1308,-236,-105,856,1185,0,17,0,0,0,0,0,0,0,0,0,0,0,0,0,17,1,1.6666666666666667,1,1,856,1203,1,1,0,0,4.3232323232323235,4.2964285714285717,4.3162055335968379,4.3311258278145699,4.3232323232323235,4.3248175182481754,0,2.8333333333333335,0,5.55555555555555]
[null,"Brand U",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Brand V",240763,182160,28862,19776,1.0151570041587354,0.78494636953901331,0.76992003363298378,0.51320258812300357,234506,137152,6257,45008,211192,97668,29571,84492,0,0,0,0,16344,17790,0,0,0,0,16344,17790,13227,66701,3.2702702702702702,2.2564102564102564,12.333333333333334,13,19521.051282051281,14012.307692307691,11.666666666666666,11.333333333333334,4.666666666666667,3.3333333333333335,8.3418682004019118,9.2111650485436893,8.5927961599061966,9.8521657926873072,8.8769702828800803,9.4768096254608967,5.8313942023269574,8.9201858108108105,5.2560403258627506,15.544791810927999]
[null,"Brand W",81607,71508,5718,4659,0.34408907364662317,0.3081354029040172,0.15253283737486667,0.12090467526623552,83162,73208,-1555,-1700,61918,63345,19689,8163,0,0,0,0,606,457,0,0,0,0,606,457,19083,7706,2.1691176470588234,2.023076923076923,45.333333333333336,43.333333333333336,1799.0612648221345,1649.8784355179703,40.666666666666664,41.333333333333336,11.333333333333334,7.666666666666667,14.271948233648128,15.348358016741789,14.24982864976011,15.612710599274898,14.402884391719004,15.792819745699326,13.875264270613108,12.577812018489984,6.8925534773177688,16.50581935384049]
[null,"Brand X",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Brand Y",4689,5243,306,312,1.9770775378693199E-2,2.2592631837357526E-2,8.1628276034818453E-3,8.0966427737852505E-3,4821,5274,-132,-31,4070,5215,618,28,0,0,0,0,0,0,0,0,0,0,0,0,618,28,1.1304347826086956,1.0833333333333333,7.666666666666667,8,612.85714285714289,658.66666666666663,7,7.666666666666667,0.66666666666666663,0.33333333333333331,15.323529411764707,16.804487179487179,15.703583061889251,16.796178343949045,15.653846153846153,16.877022653721681,13.434782608695652,9.3333333333333339,14.161121519477998,12.499999999999989]

{"sheet":"Retailer B","index":2,"n_rows":29,"n_cols":52,"rows_kept":29,"cut":false,"hidden":false,"merged":[]}
[null,null,"$ Volume",null,"Eq Volume",null,"$ Share ",null,"Eq Share ",null,"Base Dollars",null,"Incr. $ Vol",null,"Non-Promoted Dollars",null,"Promoted Dollars",null,"Dollar Sales Feature & Display",null,"Dollar Sales Feat w/o Disp",null,"Dollar Sales Disp w/o Feat",null,"Dollar Sales Any Feature",null,"Dollar Sales Any Feature Yago",null,"Dollar Sales Any Display",null,"Dollar Sales TPR Only",null,"ANI",null,"% ACV Selling",null,"$ per Point of Distribution",null,"%ACV No Promo",null,"%ACV Any Promo",null,"Avg Price per Eq",null,"Everyday (Base) Price per Eq",null,"Non Promo Price per Eq",null,"Any Promo Price per Eq",null,"% Discount Any Promo Eq"]
[null,null,"12 W/E CUR DEC3111.4","12 W/E YAGO JAN0111.4","12 W/E CUR DEC3111.4","12 W/E YAGO JAN0111.4","12 W/E CUR DEC3111.4","12 W/E YAGO JAN0111.4","12 W/E CUR DEC3111.4","12 W/E YAGO JAN0111.4","12 W/E CUR DEC3111.4","12 W/E YAGO JAN0111.4","12 W/E CUR DEC3111.4","12 W/E YAGO JAN0111.4","12 W/E CUR DEC3111.4","12 W/E YAGO JAN0111.4","12 W/E CUR DEC3111.4","12 W/E YAGO JAN0111.4","12 W/E CUR DEC3111.4","12 W/E YAGO JAN0111.4","12 W/E CUR DEC3111.4","12 W/E YAGO JAN0111.4","12 W/E CUR DEC3111.4","12 W/E YAGO JAN0111.4","12 W/E CUR DEC3111.4","12 W/E YAGO JAN0111.4","12 W/E CUR DEC3111.4","12 W/E YAGO JAN0111.4","12 W/E CUR DEC3111.4","12 W/E YAGO JAN0111.4","12 W/E CUR DEC3111.4","12 W/E YAGO JAN0111.4","12 W/E CUR DEC3111.4","12 W/E YAGO JAN0111.4","12 W/E CUR DEC3111.4","12 W/E YAGO JAN0111.4","12 W/E CUR DEC3111.4","12 W/E YAGO JAN0111.4","12 W/E CUR DEC3111.4","12 W/E YAGO JAN0111.4","12 W/E CUR DEC3111.4","12 W/E YAGO JAN0111.4","12 W/E CUR DEC3111.4","12 W/E YAGO JAN0111.4","12 W/E CUR DEC3111.4","12 W/E YAGO JAN0111.4","12 W/E CUR DEC3111.4","12 W/E YAGO JAN0111.4","12 W/E CUR DEC3111.4","12 W/E YAGO JAN0111.4","12 W/E CUR DEC3111.4","12 W/E YAGO JAN0111.4"]
["Retailer B"]
[null,"Total Category",42322138,37737801,7047828,6768644,100,100,100,100,35320056,33646486,7002082,4091315,25574654,25105800,16747483,12632001,1100053,316982,4815607,5721098,4851762,2431070,5915660,6038080,6038080,5892497,5951815,2748052,5980060,4162852,86.11333333333333,83.32,100,100,423221.38,377378.01,100,100,100,100,6.0049901898854516,5.5753857050245221,6.3077374492385987,5.7357808099427405,6.1225405667191186,5.5246233451414133,5.8339451477969106,5.6790905003821424,14.840769305400034,12.16156372451821]
[null,"Brand A",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Brand B",245052,192053,136010,87033,0.57901611681338028,0.50891412565347938,1.9298144052323638,1.285826230482797,253381,193209,-8329,-1156,179842,190756,65211,1296,0,0,0,0,141,52,0,0,0,0,141,52,65070,1244,1.5272108843537415,1.0034129692832765,98,97.666666666666671,2500.5306122448978,1966.6394908478856,98,97.666666666666671,66,5.333333333333333,1.8017204617307552,2.2066687348477014,1.9185646788018293,2.2115149087163051,1.923382137471525,2.2076452139294269,1.5341959769438889,2.070287539936102,20.779989578691552,6.4917176145199358]
[null,"Brand C",2737919,2521512,529051,420081,6.4692360296164626,6.6816611810529185,7.506582169712428,6.2062800170905721,2342078,2292393,395841,229119,1565097,1555767,1172821,965746,9313,28107,100239,106341,55668,250036,109552,134448,134448,176623,64981,278143,1007602,581262,7.21,7.0633333333333335,100,100,27379.190000000002,25215.119999999999,100,100,100,100,5.1751513559184277,6.0024423861112499,5.3055649944046506,6.0452126537414825,5.2376613032769326,5.8856774271651826,5.0939948574506158,6.2006561839883405,5.4502291177239304,3.1508318205955885]
[null,"Brand D",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Brand E",3392330,3834898,836077,1020936,8.015497704770965,10.161954057683435,11.862903010686413,15.083316540211008,3330891,3663572,61439,171326,2794416,3140053,597914,694846,0,0,0,0,86106,96740,0,0,0,0,86106,96740,511808,598106,11.086666666666666,12.236666666666666,100,100,33923.300000000003,38348.979999999996,100,100,95,96.666666666666671,4.0574372934550285,3.7562570033772928,4.2668829854554868,3.842292388142039,4.2944965168119724,3.7657333641942365,3.22534253964829,3.7140260948115049,20.390671986695409,15.587628162918362]
[null,"Brand F",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Brand G",282994,265881,94965,87950,0.66866659713646792,0.7045482061872127,1.3474364016829015,1.2993739957368122,282330,268253,664,-2372,267010,264879,15985,1003,0,0,0,0,0,0,0,0,0,0,0,0,15985,1003,1.0193798449612403,1.0433333333333332,86,100,3309.8272151898736,2658.81,83,100,14,3,2.9799820986679304,3.0230926662876634,3.0221903467174771,3.0272078904010651,3.0033857125181376,3.0239054740567384,2.6369185087429892,2.8253521126760561,17.226190563287652,5.7658033509111624]
[null,"Brand H",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Brand I",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Brand J",1727881,1676306,204108,201597,4.0826883556780613,4.4419811318629829,2.896041163320104,2.9783956727521788,1539505,1463662,188376,212644,952979,933494,774902,742811,0,0,4026,0,603019,605471,4026,0,0,3604,603019,605471,167858,137341,2.3057553956834531,3.3191489361702127,92.666666666666671,31.333333333333332,18649.419860627178,53544.227083333331,92.333333333333329,30.333333333333332,35.333333333333336,15,8.4655231544084497,8.3151336577429227,8.6640909909504291,8.5832189812697184,8.7723824953513638,8.6357068188756401,8.1162817491489925,7.9445026737967916,4.4041155176216362,6.052809585713768]
[null,"Brand K",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Brand L",1019605,251335,90651,43988,2.4091528646307991,0.6660032999803035,1.2862260543248218,0.64987905997124384,990840,245312,28765,6023,949550,225337,70055,25997,0,0,0,0,4075,0,0,0,0,0,4075,0,65981,25997,2.4247491638795986,1,99.666666666666671,72,10234.459898989899,3490.7638888888887,99.333333333333329,71.666666666666671,31.666666666666668,24.333333333333332,11.247586899206848,5.7137173774665815,11.749694648341615,5.7851146118290728,12.281416524393398,5.7743183681836818,5.2534683164604425,5.2371071716357775,21.763943959601079,10.598548696819565]
[null,"Brand M",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Brand N",155875,140259,11577,10019,0.36830606242057057,0.37166712496046073,0.16426337305620967,0.14802078525624926,159913,141616,-4038,-1357,116953,137838,38922,2421,0,0,0,0,0,393,0,0,0,0,0,393,38922,2028,1,1,90.333333333333329,90.333333333333329,1725.0614163614164,1552.6274725274725,83,89.333333333333329,55.333333333333336,4.333333333333333,13.464196251187699,13.999301327477792,14.057049929676513,14.028330856859831,13.994615292569105,14.022177009155646,12.091332712022368,12.742105263157894,14.15895574017004,9.0823741479993316]
[null,"Brand O",8728612,7946596,1947054,1778014,20.624222717670833,21.057390174907116,27.626298485150318,26.268392901148296,6750307,6760930,1978305,1185666,4407849,4438562,4320763,3508035,400608,151159,1286474,1909109,1235943,550162,1687082,2060268,2060268,727448,1636551,701321,1397740,897604,18.016666666666666,20.326666666666668,100,100,87286.12,79465.959999999992,100,100,100,100,4.4829840363954983,4.4693663829418666,4.9450117722555698,4.7704636027004446,4.8596775171577411,4.5138301172043827,4.1544679566319367,4.4143495128282888,18.630492698428274,17.58093070081037]
[null,"Brand P",20808499,17906910,2702466,2586653,49.166937171274292,47.450857033243672,38.344664483866516,38.21523188396376,16675416,15616795,4133083,2290115,11734021,11408758,9074478,6498152,686706,137715,3287875,3705646,2613080,919646,3974581,3843361,3843361,4672081,3299786,1057361,2486816,1735144,32.479999999999997,32.130000000000003,100,100,208084.99,179069.1,100,100,100,100,7.6998189801462811,6.9228110612440092,8.1031856022982822,7.1421949789486101,7.591052355783849,7.0056849861836046,7.8451642910805512,6.7819565351253921,18.154502783299634,10.151495327744636]
[null,"Brand Q",3223293,3002049,495864,532374,7.616092079280115,7.955018364742557,7.0356995091253651,7.8652976873949942,2995317,3000743,227976,1306,2606863,2810356,616430,191693,3427,0,136994,0,253732,8569,140421,0,0,312741,257159,8569,222278,183124,9.4866666666666664,6.8866666666666667,100,100,32232.93,30020.49,100,100,83.333333333333329,60,6.5003569527128402,5.6389849992674321,6.5750075182028311,5.6557180229489905,6.5481630520514633,5.5828823889325925,6.3056731929867631,6.6132960739667421,7.5509490622803224,7.5494084062733267]
[null,"Brand R",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Brand S",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Brand T",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Brand U",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Brand V",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Brand W",8,0,0,0,1.8902636724070983E-5,0,0,0,8,0,0,0,8,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Brand X",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Brand Y",68,0,5,0,1.6067241215460333E-4,0,7.0943842556884195E-5,0,68,0,0,0,68,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,13.6,0,13.6,0,13.6,0,0,0,0,0]

{"sheet":"Retailer C","index":3,"n_rows":29,"n_cols":52,"rows_kept":29,"cut":false,"hidden":false,"merged":[]}
[null,null,"$ Volume",null,"Eq Volume",null,"$ Share ",null,"Eq Share ",null,"Base Dollars",null,"Incr. $ Vol",null,"Non-Promoted Dollars",null,"Promoted Dollars",null,"Dollar Sales Feature & Display",null,"Dollar Sales Feat w/o Disp",null,"Dollar Sales Disp w/o Feat",null,"Dollar Sales Any Feature",null,"Dollar Sales Any Feature Yago",null,"Dollar Sales Any Display",null,"Dollar Sales TPR Only",null,"ANI",null,"% ACV Selling",null,"$ per Point of Distribution",null,"%ACV No Promo",null,"%ACV Any Promo",null,"Avg Price per Eq",null,"Everyday (Base) Price per Eq",null,"Non Promo Price per Eq",null,"Any Promo Price per Eq",null,"% Discount Any Promo Eq"]
[null,null,"12 W/E CUR DEC3111.4","12 W/E YAGO JAN0111.4","12 W/E CUR DEC3111.4","12 W/E YAGO JAN0111.4","12 W/E CUR DEC3111.4","12 W/E YAGO JAN0111.4","12 W/E CUR DEC3111.4","12 W/E YAGO JAN0111.4","12 W/E CUR DEC3111.4","12 W/E YAGO JAN0111.4","12 W/E CUR DEC3111.4","12 W/E YAGO JAN0111.4","12 W/E CUR DEC3111.4","12 W/E YAGO JAN0111.4","12 W/E CUR DEC3111.4","12 W/E YAGO JAN0111.4","12 W/E CUR DEC3111.4","12 W/E YAGO JAN0111.4","12 W/E CUR DEC3111.4","12 W/E YAGO JAN0111.4","12 W/E CUR DEC3111.4","12 W/E YAGO JAN0111.4","12 W/E CUR DEC3111.4","12 W/E YAGO JAN0111.4","12 W/E CUR DEC3111.4","12 W/E YAGO JAN0111.4","12 W/E CUR DEC3111.4","12 W/E YAGO JAN0111.4","12 W/E CUR DEC3111.4","12 W/E YAGO JAN0111.4","12 W/E CUR DEC3111.4","12 W/E YAGO JAN0111.4","12 W/E CUR DEC3111.4","12 W/E YAGO JAN0111.4","12 W/E CUR DEC3111.4","12 W/E YAGO JAN0111.4","12 W/E CUR DEC3111.4","12 W/E YAGO JAN0111.4","12 W/E CUR DEC3111.4","12 W/E YAGO JAN0111.4","12 W/E CUR DEC3111.4","12 W/E YAGO JAN0111.4","12 W/E CUR DEC3111.4","12 W/E YAGO JAN0111.4","12 W/E CUR DEC3111.4","12 W/E YAGO JAN0111.4","12 W/E CUR DEC3111.4","12 W/E YAGO JAN0111.4","12 W/E CUR DEC3111.4","12 W/E YAGO JAN0111.4"]
["Retailer C"]
[null,"Total Category",22572486,20075706,3883652,3479763,100,100,100,100,22376235,20426050,196251,-350344,17746764,16081703,4825722,3994000,134134,72213,2668679,1726234,861107,714114,2802813,1798447,1798447,3340321,995241,786327,1161800,1481440,46.723333333333336,41.47,100,100,225724.86,200757.06,100,100,100,100,5.8121803910340057,5.7692739419322523,5.8321717417878434,5.8410609623857868,6.0623431829928291,6.0516180719509363,5.046364181089789,4.8568659473381484,1.4344676340540474,4.2548693102947626]
[null,"Brand A",0,10,0,2,0,4.9811448723148267E-5,0,5.7475178625670774E-5,0,10,0,0,0,10,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,5,0,5,0,5,0,0,0,0]
[null,"Brand B",1960955,2248792,686911,813294,8.6873683297444515,11.201558739702604,17.687243862220406,23.372108962593142,2002123,2305413,-41168,-56621,1248287,1541022,712665,707771,31799,18582,577012,467802,48384,63421,608811,486384,486384,424588,80183,82003,55471,157964,5.7833333333333332,5.6466666666666665,100,100,19609.55,22487.919999999998,99.666666666666671,100,93.333333333333329,94,2.8547439187900614,2.7650419159615098,2.921566166781703,2.8003665940280884,2.8744887902289853,2.7200682037215511,2.820793439067157,2.8683147251322163,6.0290786486003505,3.6724358098131704]
[null,"Brand C",2325389,1745767,344768,212211,10.301873705891323,8.695918340306438,8.8774174411095537,6.0984325656661102,2301693,1777697,23696,-31930,1792439,1041677,532949,704089,15260,12455,218999,433294,82152,40293,234259,445749,445749,431998,97412,52748,216537,218049,4.75,4.0999999999999996,100,100,23253.89,17457.669999999998,100,99.333333333333329,90.666666666666671,88.333333333333329,6.7447936003341376,8.2265622422965823,6.8042267510952659,8.3698868130626387,6.5180311057938818,8.2200451374640959,7.6385461008155247,8.2362113537730881,5.7033922598811273,3.9221045219409389]
[null,"Brand D",752807,695975,377310,349112,3.3350646446297496,3.4667523025093114,9.7153400974134652,10.032637280182586,768660,701319,-15853,-5344,389982,354210,362825,341765,1601,3860,356956,329140,2974,5031,358557,333000,333000,0,4575,8891,1296,3734,1,1,100,100,7528.07,6959.75,99,97.666666666666671,68,68.333333333333329,1.9951949325488325,1.9935579412910469,1.9998959281904514,1.9993984576568358,1.9950785790292216,1.9944705961845988,1.9953529298539885,1.9926129340702907,0.25801955878350075,0.36004734809577471]
[null,"Brand E",0,2,0,0,0,9.9622897446296533E-6,0,0,0,2,0,0,0,2,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Brand F",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Brand G",455192,423233,150917,143441,2.0165789448269011,2.1081848877444211,3.8859557962453897,4.1221485486224205,471964,414541,-16772,8692,439438,326551,15754,96683,0,552,0,69908,3873,10873,0,70460,70460,0,3873,11425,11881,15350,1.5387205387205387,1.5661016949152542,99,98.333333333333329,4597.8989898989894,4301.6842918985776,98,96,9.6666666666666661,38.666666666666664,3.0161744535075572,2.9505720121861949,3.0293717425351101,3.0045952351615219,3.0234548619472559,2.9999265063893508,2.826336562612128,2.7952758182028448,6.6890977201227537,6.9844253685656135]
[null,"Brand H",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Brand I",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Brand J",4994142,4768759,595202,553780,22.124909059640132,23.753879440155181,15.325832489625743,15.91430220966198,4978015,4750178,16127,18581,4429608,3501143,564533,1267617,20220,32416,76295,308288,344900,312568,96515,340704,340704,1926607,365120,344984,123119,614345,8.5966666666666658,7.8633333333333333,100,100,49941.42,47687.59,100,100,61.333333333333336,98.333333333333329,8.3906673700693215,8.6112878760518612,8.4427083068333495,8.8076681320841121,8.3295561815289378,8.636097462309575,8.9033229769583802,8.543563095214024,3.7148572064028986,7.9362844153419623]
[null,"Brand K",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Brand L",658422,507639,83341,67105,2.916922841374229,2.5286234018370259,2.1459440753187975,1.9284359308378185,640030,505013,18392,2626,534006,477622,124416,30017,1799,0,60591,0,46808,11544,62390,0,0,0,48607,11544,15218,18473,1.2886597938144331,1,97,86.333333333333329,6785.6816528157651,5879.125100240577,94,85.333333333333329,49.333333333333336,11.666666666666666,7.900337168980454,7.5648461366515161,7.9221438296818913,7.6024116336484617,7.8218570110295733,7.5908202348977287,8.2553247959657625,7.1742351816443595,1.3968864108994465,5.1291728120502]
[null,"Brand M",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Brand N",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Brand O",1664750,1630202,328488,304670,7.3751291727459698,8.1202723331373754,8.458224372317602,8.7554813359415569,1688160,1678465,-23410,-48263,1406041,1552951,258709,77250,1749,0,109672,0,20276,18090,111421,0,0,58116,22025,18090,127013,59159,3.6433333333333335,3.8433333333333333,100,100,16647.5,16302.02,100,100,74,33.666666666666664,5.0679172450744012,5.350713887156596,5.1526574265403857,5.3493993950925365,5.0840727803932628,5.3741279311204009,4.9818794531099559,4.9197554451662207,8.4907868173055157,6.2323838421289706]
[null,"Brand P",4863795,4142373,553506,417232,21.547449403667809,20.633760028165383,14.252203853486359,11.990241864172933,4719569,4294378,144226,-152005,3359141,3860904,1504654,281469,49355,0,1001812,0,106786,113571,1051167,0,0,499012,156141,113571,346701,167898,8.77,8.3566666666666674,100,100,48637.95,41423.729999999996,100,100,99.333333333333329,51.666666666666664,8.7872489187109082,9.92822458488323,8.9046959579931659,9.9760679074867351,9.2191395464999477,9.991496277356962,7.9551974452921366,9.1350447877450343,5.8718235931072549,6.7469537624199587]
[null,"Brand Q",4722221,3751795,747891,604758,20.920252204387236,18.688234426226405,19.257415442990258,17.379287037651704,4647067,3825292,75154,-73497,4054798,3328458,667424,423336,12353,4348,267342,117803,123784,74796,279695,122151,122151,0,136137,79144,263945,226388,11.006666666666666,7.82,100,100,47222.21,37517.950000000004,100,100,92.333333333333329,73,6.3140497746329345,6.2037955678139021,6.3569454818049254,6.2982076586944853,6.4549579093490914,6.3343578305526007,5.5747815773207936,5.3386130622848276,7.3495284460877777,11.530723147654195]
[null,"Brand R",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Brand S",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Brand T",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Brand U",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Brand V",174814,161158,15321,14156,0.7744561232644025,0.80275134533251291,0.39449981615242558,0.40680931431249773,158958,173743,15856,-12585,93023,97154,81790,64005,0,0,0,0,81170,63925,0,0,0,0,81170,63925,621,80,1.8461538461538463,1.8285714285714285,21.666666666666668,23.333333333333332,8066.681818181818,6906.9692028985519,13.666666666666666,16.333333333333332,13,12.333333333333334,11.410090725148489,11.384430630121503,11.431715210355987,11.39746785620572,11.422274066797643,11.391018876773362,11.397714604236343,11.372601279317697,0.32559436601472685,0.17544720654732324]
[null,"Brand W",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Brand X",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Brand Y",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]