{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["data","calculations","Interactive Sales Chart"],"not_rendered":{"charts":2,"images":2,"macros":1,"external_links":0,"defined_names":13,"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":"data","index":0,"n_rows":135,"n_cols":10,"rows_kept":135,"cut":false,"hidden":false,"merged":[]}
[null,"Data"]
[]
[null,"Year","Product","Region","Sales ($)",null,null,"Years","Products","Regions"]
[null,2001,"Biscuits","North",1140,null,null,2001,"Biscuits","North"]
[null,2001,"Biscuits","South",1800,null,null,2002,"Chocolates","South"]
[null,2001,"Chocolates","North",950,null,null,2003,"Chocochips"]
[null,2001,"Chocolates","South",1570,null,null,2004,"Cookies"]
[null,2001,"Chocochips","North",1120,null,null,2005,"Nutri Bars"]
[null,2001,"Chocochips","South",1510,null,null,2006,"Jelly Beans"]
[null,2001,"Cookies","North",1040,null,null,2007]
[null,2001,"Cookies","South",1350,null,null,2008]
[null,2001,"Nutri Bars","North",930,null,null,2009]
[null,2001,"Nutri Bars","South",1210,null,null,2010]
[null,2001,"Jelly Beans","North",920,null,null,2011]
[null,2001,"Jelly Beans","South",1320]
[null,2002,"Biscuits","North",1210]
[null,2002,"Biscuits","South",1370]
[null,2002,"Chocolates","North",1110]
[null,2002,"Chocolates","South",1370]
[null,2002,"Chocochips","North",990]
[null,2002,"Chocochips","South",1480]
[null,2002,"Cookies","North",1160]
[null,2002,"Cookies","South",1350]
[null,2002,"Nutri Bars","North",980]
[null,2002,"Nutri Bars","South",1280]
[null,2002,"Jelly Beans","North",1110]
[null,2002,"Jelly Beans","South",1740]
[null,2003,"Biscuits","North",880]
[null,2003,"Biscuits","South",1350]
[null,2003,"Chocolates","North",990]
[null,2003,"Chocolates","South",1110]
[null,2003,"Chocochips","North",1140]
[null,2003,"Chocochips","South",820]
[null,2003,"Cookies","North",970]
[null,2003,"Cookies","South",1600]
[null,2003,"Nutri Bars","North",920]
[null,2003,"Nutri Bars","South",1870]
[null,2003,"Jelly Beans","North",1080]
[null,2003,"Jelly Beans","South",1430]
[null,2004,"Biscuits","North",860]
[null,2004,"Biscuits","South",1470]
[null,2004,"Chocolates","North",1080]
[null,2004,"Chocolates","South",1950]
[null,2004,"Chocochips","North",1050]
[null,2004,"Chocochips","South",1940]
[null,2004,"Cookies","North",890]
[null,2004,"Cookies","South",1840]
[null,2004,"Nutri Bars","North",1230]
[null,2004,"Nutri Bars","South",1550]
[null,2004,"Jelly Beans","North",1000]
[null,2004,"Jelly Beans","South",1190]
[null,2005,"Biscuits","North",950]
[null,2005,"Biscuits","South",1420]
[null,2005,"Chocolates","North",1140]
[null,2005,"Chocolates","South",1090]
[null,2005,"Chocochips","North",980]
[null,2005,"Chocochips","South",1600]
[null,2005,"Cookies","North",1010]
[null,2005,"Cookies","South",1290]
[null,2005,"Nutri Bars","North",1060]
[null,2005,"Nutri Bars","South",1490]
[null,2005,"Jelly Beans","North",950]
[null,2005,"Jelly Beans","South",980]
[null,2006,"Biscuits","North",1050]
[null,2006,"Biscuits","South",1490]
[null,2006,"Chocolates","North",1030]
[null,2006,"Chocolates","South",1460]
[null,2006,"Chocochips","North",860]
[null,2006,"Chocochips","South",1050]
[null,2006,"Cookies","North",910]
[null,2006,"Cookies","South",1430]
[null,2006,"Nutri Bars","North",950]
[null,2006,"Nutri Bars","South",1320]
[null,2006,"Jelly Beans","North",1060]
[null,2006,"Jelly Beans","South",1790]
[null,2007,"Biscuits","North",1020]
[null,2007,"Biscuits","South",1480]
[null,2007,"Chocolates","North",980]
[null,2007,"Chocolates","South",1400]
[null,2007,"Chocochips","North",890]
[null,2007,"Chocochips","South",1760]
[null,2007,"Cookies","North",970]
[null,2007,"Cookies","South",1190]
[null,2007,"Nutri Bars","North",870]
[null,2007,"Nutri Bars","South",1010]
[null,2007,"Jelly Beans","North",880]
[null,2007,"Jelly Beans","South",1260]
[null,2008,"Biscuits","North",1070]
[null,2008,"Biscuits","South",1590]
[null,2008,"Chocolates","North",890]
[null,2008,"Chocolates","South",1430]
[null,2008,"Chocochips","North",1050]
[null,2008,"Chocochips","South",780]
[null,2008,"Cookies","North",1120]
[null,2008,"Cookies","South",1220]
[null,2008,"Nutri Bars","North",950]
[null,2008,"Nutri Bars","South",1260]
[null,2008,"Jelly Beans","North",1120]
[null,2008,"Jelly Beans","South",1620]
[null,2009,"Biscuits","North",850]
[null,2009,"Biscuits","South",1390]
[null,2009,"Chocolates","North",1150]
[null,2009,"Chocolates","South",1470]
[null,2009,"Chocochips","North",1080]
[null,2009,"Chocochips","South",1260]
[null,2009,"Cookies","North",1110]
[null,2009,"Cookies","South",1810]
[null,2009,"Nutri Bars","North",950]
[null,2009,"Nutri Bars","South",1460]
[null,2009,"Jelly Beans","North",1180]
[null,2009,"Jelly Beans","South",1400]
[null,2010,"Biscuits","North",1010]
[null,2010,"Biscuits","South",1420]
[null,2010,"Chocolates","North",970]
[null,2010,"Chocolates","South",1370]
[null,2010,"Chocochips","North",1100]
[null,2010,"Chocochips","South",1360]
[null,2010,"Cookies","North",1120]
[null,2010,"Cookies","South",1380]
[null,2010,"Nutri Bars","North",1020]
[null,2010,"Nutri Bars","South",980]
[null,2010,"Jelly Beans","North",1130]
[null,2010,"Jelly Beans","South",2100]
[null,2011,"Biscuits","North",1080]
[null,2011,"Biscuits","South",1360]
[null,2011,"Chocolates","North",920]
[null,2011,"Chocolates","South",1020]
[null,2011,"Chocochips","North",1200]
[null,2011,"Chocochips","South",1750]
[null,2011,"Cookies","North",1060]
[null,2011,"Cookies","South",1070]
[null,2011,"Nutri Bars","North",1080]
[null,2011,"Nutri Bars","South",1760]
[null,2011,"Jelly Beans","North",1090]
[null,2011,"Jelly Beans","South",1700]

{"sheet":"calculations","index":1,"n_rows":28,"n_cols":11,"rows_kept":28,"cut":false,"hidden":false,"merged":[]}
[null,"Calculations"]
[]
[null,"Selected year",{"$f":"valYearPicked","v":2007},2007]
[null,"Selected Product",{"$f":"valProductPicked","v":"Cookies"},"Cookies",true]
[null,"Selected Region",{"$f":"valRegionPicked","v":"South"},"South"]
[null,null,null,null,null,null,"Data for the chart"]
[null,"Product-wise Sales","Sales ($)"]
[null,"Products",{"$f":"C17","v":"North"},{"$f":"D17","v":"South"},"All Regions",null,{"$f":"B8","v":"Products"},"North","South","All Regions","Highlighted"]
[null,{"$f":"data!I4","v":"Biscuits"},{"$f":"SUMIFS(tblSales[Sales ($)],tblSales[Year],$C$3,tblSales[Product],$B9,tblSales[Region],C$8)","v":1020},{"$f":"SUMIFS(tblSales[Sales ($)],tblSales[Year],$C$3,tblSales[Product],$B9,tblSales[Region],D$8)","v":1480},{"$f":"C9+D9","v":2500},null,"Biscuits",{"$f":"IF($C$5=H$8,C9,NA())","v":{"$error":"#N/A"}},{"$f":"IF($C$5=I$8,D9,NA())","v":1480},{"$error":"#N/A"},{"$f":"IF(G9=valProductPicked,INDEX($H9:$J9,MATCH(valRegionPicked,$H$8:$J$8,0)),NA())","v":{"$error":"#N/A"}}]
[null,{"$f":"data!I5","v":"Chocolates"},{"$f":"SUMIFS(tblSales[Sales ($)],tblSales[Year],$C$3,tblSales[Product],$B10,tblSales[Region],C$8)","v":980},{"$f":"SUMIFS(tblSales[Sales ($)],tblSales[Year],$C$3,tblSales[Product],$B10,tblSales[Region],D$8)","v":1400},{"$f":"C10+D10","v":2380},null,"Chocolates",{"$f":"IF($C$5=H$8,C10,NA())","v":{"$error":"#N/A"}},1400,{"$error":"#N/A"},{"$f":"IF(G10=valProductPicked,INDEX($H10:$J10,MATCH(valRegionPicked,$H$8:$J$8,0)),NA())","v":{"$error":"#N/A"}}]
[null,{"$f":"data!I6","v":"Chocochips"},{"$f":"SUMIFS(tblSales[Sales ($)],tblSales[Year],$C$3,tblSales[Product],$B11,tblSales[Region],C$8)","v":890},{"$f":"SUMIFS(tblSales[Sales ($)],tblSales[Year],$C$3,tblSales[Product],$B11,tblSales[Region],D$8)","v":1760},2650,null,"Chocochips",{"$error":"#N/A"},1760,{"$error":"#N/A"},{"$f":"IF(G11=valProductPicked,INDEX($H11:$J11,MATCH(valRegionPicked,$H$8:$J$8,0)),NA())","v":{"$error":"#N/A"}}]
[null,{"$f":"data!I7","v":"Cookies"},{"$f":"SUMIFS(tblSales[Sales ($)],tblSales[Year],$C$3,tblSales[Product],$B12,tblSales[Region],C$8)","v":970},{"$f":"SUMIFS(tblSales[Sales ($)],tblSales[Year],$C$3,tblSales[Product],$B12,tblSales[Region],D$8)","v":1190},2160,null,"Cookies",{"$error":"#N/A"},1190,{"$error":"#N/A"},{"$f":"IF(G12=valProductPicked,INDEX($H12:$J12,MATCH(valRegionPicked,$H$8:$J$8,0)),NA())","v":1190}]
[null,{"$f":"data!I8","v":"Nutri Bars"},{"$f":"SUMIFS(tblSales[Sales ($)],tblSales[Year],$C$3,tblSales[Product],$B13,tblSales[Region],C$8)","v":870},{"$f":"SUMIFS(tblSales[Sales ($)],tblSales[Year],$C$3,tblSales[Product],$B13,tblSales[Region],D$8)","v":1010},1880,null,"Nutri Bars",{"$error":"#N/A"},1010,{"$error":"#N/A"},{"$f":"IF(G13=valProductPicked,INDEX($H13:$J13,MATCH(valRegionPicked,$H$8:$J$8,0)),NA())","v":{"$error":"#N/A"}}]
[null,{"$f":"data!I9","v":"Jelly Beans"},{"$f":"SUMIFS(tblSales[Sales ($)],tblSales[Year],$C$3,tblSales[Product],$B14,tblSales[Region],C$8)","v":880},{"$f":"SUMIFS(tblSales[Sales ($)],tblSales[Year],$C$3,tblSales[Product],$B14,tblSales[Region],D$8)","v":1260},2140,null,"Jelly Beans",{"$error":"#N/A"},1260,{"$error":"#N/A"},{"$f":"IF(G14=valProductPicked,INDEX($H14:$J14,MATCH(valRegionPicked,$H$8:$J$8,0)),NA())","v":{"$error":"#N/A"}}]
[]
[null,"Yearly Sales Break-up",null,null,null,null,"Title"]
[null,"Year","North","South","All",null,{"$f":"\"Sales in \"&valRegionPicked&\" by Product - \"&valYearPicked","v":"Sales in South by Product - 2007"}]
[null,{"$f":"data!H4","v":2001},{"$f":"SUMIFS(tblSales[Sales ($)],tblSales[Year],$B18,tblSales[Product],$C$4,tblSales[Region],C$17)","v":1040},{"$f":"SUMIFS(tblSales[Sales ($)],tblSales[Year],$B18,tblSales[Product],$C$4,tblSales[Region],D$17)","v":1350},{"$f":"C18+D18","v":2390}]
[null,{"$f":"data!H5","v":2002},{"$f":"SUMIFS(tblSales[Sales ($)],tblSales[Year],$B19,tblSales[Product],$C$4,tblSales[Region],C$17)","v":1160},{"$f":"SUMIFS(tblSales[Sales ($)],tblSales[Year],$B19,tblSales[Product],$C$4,tblSales[Region],D$17)","v":1350},{"$f":"C19+D19","v":2510},null,true]
[null,{"$f":"data!H6","v":2003},{"$f":"SUMIFS(tblSales[Sales ($)],tblSales[Year],$B20,tblSales[Product],$C$4,tblSales[Region],C$17)","v":970},{"$f":"SUMIFS(tblSales[Sales ($)],tblSales[Year],$B20,tblSales[Product],$C$4,tblSales[Region],D$17)","v":1600},2570,null,{"$f":"IF(valHelpStatus,\"Hide help\",\"Show help\")","v":"Hide help"}]
[null,{"$f":"data!H7","v":2004},{"$f":"SUMIFS(tblSales[Sales ($)],tblSales[Year],$B21,tblSales[Product],$C$4,tblSales[Region],C$17)","v":890},{"$f":"SUMIFS(tblSales[Sales ($)],tblSales[Year],$B21,tblSales[Product],$C$4,tblSales[Region],D$17)","v":1840},2730]
[null,{"$f":"data!H8","v":2005},{"$f":"SUMIFS(tblSales[Sales ($)],tblSales[Year],$B22,tblSales[Product],$C$4,tblSales[Region],C$17)","v":1010},{"$f":"SUMIFS(tblSales[Sales ($)],tblSales[Year],$B22,tblSales[Product],$C$4,tblSales[Region],D$17)","v":1290},2300]
[null,{"$f":"data!H9","v":2006},{"$f":"SUMIFS(tblSales[Sales ($)],tblSales[Year],$B23,tblSales[Product],$C$4,tblSales[Region],C$17)","v":910},{"$f":"SUMIFS(tblSales[Sales ($)],tblSales[Year],$B23,tblSales[Product],$C$4,tblSales[Region],D$17)","v":1430},2340]
[null,{"$f":"data!H10","v":2007},{"$f":"SUMIFS(tblSales[Sales ($)],tblSales[Year],$B24,tblSales[Product],$C$4,tblSales[Region],C$17)","v":970},{"$f":"SUMIFS(tblSales[Sales ($)],tblSales[Year],$B24,tblSales[Product],$C$4,tblSales[Region],D$17)","v":1190},2160]
[null,{"$f":"data!H11","v":2008},{"$f":"SUMIFS(tblSales[Sales ($)],tblSales[Year],$B25,tblSales[Product],$C$4,tblSales[Region],C$17)","v":1120},{"$f":"SUMIFS(tblSales[Sales ($)],tblSales[Year],$B25,tblSales[Product],$C$4,tblSales[Region],D$17)","v":1220},2340]
[null,{"$f":"data!H12","v":2009},{"$f":"SUMIFS(tblSales[Sales ($)],tblSales[Year],$B26,tblSales[Product],$C$4,tblSales[Region],C$17)","v":1110},{"$f":"SUMIFS(tblSales[Sales ($)],tblSales[Year],$B26,tblSales[Product],$C$4,tblSales[Region],D$17)","v":1810},2920]
[null,{"$f":"data!H13","v":2010},{"$f":"SUMIFS(tblSales[Sales ($)],tblSales[Year],$B27,tblSales[Product],$C$4,tblSales[Region],C$17)","v":1120},{"$f":"SUMIFS(tblSales[Sales ($)],tblSales[Year],$B27,tblSales[Product],$C$4,tblSales[Region],D$17)","v":1380},2500]
[null,{"$f":"data!H14","v":2011},{"$f":"SUMIFS(tblSales[Sales ($)],tblSales[Year],$B28,tblSales[Product],$C$4,tblSales[Region],C$17)","v":1060},{"$f":"SUMIFS(tblSales[Sales ($)],tblSales[Year],$B28,tblSales[Product],$C$4,tblSales[Region],D$17)","v":1070},2130]

{"sheet":"Interactive Sales Chart","index":2,"n_rows":21,"n_cols":12,"rows_kept":21,"cut":false,"hidden":false,"merged":[[18,1,18,2],[19,1,19,2],[20,1,20,2],[4,5,4,11],[0,1,0,11]]}
[null,"Interactive Sales Chart"]
[]
[]
[]
[null,"Pick an year",null,null,null,{"$f":"calculations!G17","v":"Sales in South by Product - 2007"}]
[null,{"$f":"calculations!B18","v":2001}]
[null,{"$f":"calculations!B19","v":2002}]
[null,{"$f":"calculations!B20","v":2003}]
[null,{"$f":"calculations!B21","v":2004}]
[null,{"$f":"calculations!B22","v":2005}]
[null,{"$f":"calculations!B23","v":2006}]
[null,{"$f":"calculations!B24","v":2007}]
[null,{"$f":"calculations!B25","v":2008}]
[null,{"$f":"calculations!B26","v":2009}]
[null,{"$f":"calculations!B27","v":2010}]
[null,{"$f":"calculations!B28","v":2011}]
[]
[null,"Region"]
[null,"All Regions"]
[null,{"$f":"data!J4","v":"North"}]
[null,{"$f":"data!J5","v":"South"},null,null,null,null,{"$f":"INDEX(lstProducts,COLUMNS($G$18:G18))","v":"Biscuits"},{"$f":"INDEX(lstProducts,COLUMNS($G$18:H18))","v":"Chocolates"},{"$f":"INDEX(lstProducts,COLUMNS($G$18:I18))","v":"Chocochips"},{"$f":"INDEX(lstProducts,COLUMNS($G$18:J18))","v":"Cookies"},{"$f":"INDEX(lstProducts,COLUMNS($G$18:K18))","v":"Nutri Bars"},{"$f":"INDEX(lstProducts,COLUMNS($G$18:L18))","v":"Jelly Beans"}]