{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Sheet1","Sheet2"],"not_rendered":{"charts":1,"images":0,"macros":1,"external_links":0,"defined_names":8,"comments":0,"pivot_tables":1},"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":"Sheet1","index":0,"n_rows":27,"n_cols":25,"rows_kept":27,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cubeset","Cube Harvester","Modified Harvester","Format"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CUBESET(\"ThisWorkbookDataModel\",Slicer_Series_1_Measure,\"Slicer 1 Set\")","v":"Slicer 1 Set"},{"$f":"CUBERANKEDMEMBER(\"ThisWorkbookDataModel\",V2,1)","v":"Total Cost"},{"$f":"IF(W2=\"All\",\"\",W2)","v":"Total Cost"},{"$f":"INDEX(Selector1[Format],MATCH(X2,Selector1[Series 1 Measure]))","v":"$"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CUBESET(\"ThisWorkbookDataModel\",Slicer_Series_2_Measure,\"Slicer 2 Set\")","v":"Slicer 2 Set"},{"$f":"CUBERANKEDMEMBER(\"ThisWorkbookDataModel\",V3,1)","v":"Chg vs LY %"},{"$f":"IF(W3=\"All\",\"\",W3)","v":"Chg vs LY %"},{"$f":"INDEX(Selector2[Format],MATCH(X3,Selector2[Series 2 Measure]))","v":"%"}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CUBESET(\"ThisWorkbookDataModel\",Slicer_CalendarYear,\"Year Cube set\")","v":"Year Cube set"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(CUBERANKEDMEMBER(\"ThisWorkbookDataModel\",$V$6,ROW(F1)),\"\")","v":"2003"}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CUBESET(\"ThisWorkbookDataModel\",Slicer_Category,\"Category Cube set\")","v":"Category Cube set"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(W12,W13,W14,W15)","v":"All Categories"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(CUBERANKEDMEMBER(\"ThisWorkbookDataModel\",$V$10,ROW(F1)),\"\")","v":"All"},{"$f":"IF(V12<>\"\",IF(V12=\"All\",\"All Categories\",V12),\"\")","v":"All Categories"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(CUBERANKEDMEMBER(\"ThisWorkbookDataModel\",$V$10,ROW(F2)),\"\")","v":""},{"$f":"IF(V13<>\"\",IF(V13=\"All\",\"All Branches\",\", \"&V13),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"IF(V14<>\"\",IF(V14=\"All\",\"All Branches\",\", \"&V14),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"IF(V15<>\"\",\", \"&\"& \"&V8-3&\" Others\",\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Same Axis",null,"Second Axis"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CUBESETCOUNT(V18)","v":8}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CUBESET(\"ThisWorkbookDataModel\",Slicer_Sub_Category,\"SubCategory Cube set\")","v":"SubCategory Cube set"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(W20,W21,W22,W23,W24)","v":"Fenders, Gloves, Helmets, Hydration Packs and 4 others"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(CUBERANKEDMEMBER(\"ThisWorkbookDataModel\",$V$18,ROW(F1)),\"\")","v":"Fenders"},{"$f":"IF(V20<>\"\",IF(V20=\"All\",\"All SubCategories\",V20),\"\")","v":"Fenders"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(CUBERANKEDMEMBER(\"ThisWorkbookDataModel\",$V$18,ROW(F2)),\"\")","v":"Gloves"},{"$f":"IF(V21<>\"\",IF(V21=\"All\",\"All Branches\",\", \"&V21),\"\")","v":", Gloves"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Helmets",{"$f":"IF(V22<>\"\",IF(V22=\"All\",\"All Branches\",\", \"&V22),\"\")","v":", Helmets"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hydration Packs",", Hydration Packs"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Jerseys",{"$f":"IF(V24<>\"\",\" and \"&V17-4&\" others\",\"\")","v":" and 4 others"},"<=subtract 4 from the total because there are 4 subcategories already named above"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Chart Title",{"$f":"\"Sales for year \"&V7&CHAR(10)&V11&CHAR(10)&V19","v":"Sales for year 2003\nAll Categories\nFenders, Gloves, Helmets, Hydration Packs and 4 others"}]

{"sheet":"Sheet2","index":1,"n_rows":30,"n_cols":10,"rows_kept":30,"cut":false,"hidden":false,"merged":[]}
[null,"ID","Series 1 Measure","Format",null,"ID","Series 2 Measure","Format"]
[null,6,"Chg vs LY","$",null,6,"Chg vs LY","$",null,{"$f":"F2&\", \"&\"[\"&G2&\"],\"","v":"6, [Chg vs LY],"}]
[null,7,"Chg vs LY %","%",null,7,"Chg vs LY %","%",null,{"$f":"F3&\", \"&\"[\"&G3&\"],\"","v":"7, [Chg vs LY %],"}]
[null,2,"Total Cost","$",null,2,"Total Cost","$",null,"2, [Total Cost],"]
[null,3,"Total Margin","$",null,3,"Total Margin","$",null,"3, [Total Margin],"]
[null,4,"Total Margin %","%",null,4,"Total Margin %","%",null,"4, [Total Margin %],"]
[null,1,"Total Sales","$",null,1,"Total Sales","$",null,"1, [Total Sales],"]
[null,5,"Total Sales LY","$",null,5,"Total Sales LY","$",null,{"$f":"F8&\", \"&\"[\"&G8&\"]\"","v":"5, [Total Sales LY]"}]
[]
[]
[]
[]
[null,null,null,{"$f":"Sheet1!Y2","v":"$"},{"$f":"Sheet1!Y3","v":"%"}]
["Row Labels","Series 1","Series 2",{"$f":"Sheet1!$X$2","v":"Total Cost"},{"$f":"Sheet1!$X$3","v":"Chg vs LY %"}]
["January",255136.96610000034,-0.26457024879477314,{"$f":"B15","v":255136.96610000034},{"$f":"C15","v":-0.26457024879477314}]
["February",283903.86150000046,-0.11206333989579498,{"$f":"B16","v":283903.86150000046},{"$f":"C16","v":-0.11206333989579498}]
["March",281677.73700000031,-0.2461601374345759,{"$f":"B17","v":281677.73700000031},{"$f":"C17","v":-0.2461601374345759}]
["April",293781.16390000033,-0.23699691035794671,{"$f":"B18","v":293781.16390000033},{"$f":"C18","v":-0.23699691035794671}]
["May",324100.26099999994,-0.16447570917147916,{"$f":"B19","v":324100.26099999994},{"$f":"C19","v":-0.16447570917147916}]
["June",319748.51980000024,-0.18021715789860598,{"$f":"B20","v":319748.51980000024},{"$f":"C20","v":-0.18021715789860598}]
["July",437358.30940000183,0.48526299758022767,{"$f":"B21","v":437358.30940000183},{"$f":"C21","v":0.48526299758022767}]
["August",388882.10039999947,0.21930796088249901,{"$f":"B22","v":388882.10039999947},{"$f":"C22","v":0.21930796088249901}]
["September",466679.02509999956,1.2823864160819514,{"$f":"B23","v":466679.02509999956},{"$f":"C23","v":1.2823864160819514}]
["October",464249.31969999947,0.92206086228169526,{"$f":"B24","v":464249.31969999947},{"$f":"C24","v":0.92206086228169526}]
["November",520103.95999999973,1.6662880780084455,{"$f":"B25","v":520103.95999999973},{"$f":"C25","v":1.6662880780084455}]
["December",728109.61550000554,1.1605066212977493,{"$f":"B26","v":728109.61550000554},{"$f":"C26","v":1.1605066212977493}]
[]
[]
[]
[{"$f":"Sheet1!H35","v":0}]