{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Dashboard","Data","Calculation","Final Image"],"not_rendered":{"charts":2,"images":7,"macros":1,"external_links":0,"defined_names":3,"comments":0,"pivot_tables":2},"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":"Dashboard","index":0,"n_rows":25,"n_cols":16,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[null,{"$f":"IF(COUNTA(Calculation!A6:A8)>1,\"Please only select 1 Division!\",\"\")","v":""}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"Current",null,null,"PY"]
[null,null,null,null,null,null,null,null,null,null,"Revenue ","% ∆ PY"," ","Revenue ","% ∆ PY"," "]
[null,null,null,null,null,null,null,null,null,"Game",43784,1.1904047225974286,1.1904047225974286,19989]
[null,null,null,null,null,null,null,null,null,"Productivity",29276,-8.3836645282428415E-2,-8.3836645282428415E-2,31955]
[null,null,null,null,null,null,null,null,null,"Utility",46994,0.1959282351444204,0.1959282351444204,39295]
[null,null,null,null,null,null,null,null,null,"Total",120054,0.31581889323644496,0.31581889323644496,91239]

{"sheet":"Data","index":1,"n_rows":31,"n_cols":4,"rows_kept":31,"cut":false,"hidden":false,"merged":[]}
["Year","Division","Region","Revenue"]
["Current","Utility","North America",40000]
["Current","Utility","South America",20898]
["Current","Utility","Asia",46994]
["Current","Utility","Europe",43695]
["Current","Utility","Australia",34196]
["Current","Productivity","North America",34155]
["Current","Productivity","South America",24396]
["Current","Productivity","Asia",29276]
["Current","Productivity","Europe",45540]
["Current","Productivity","Australia",29277]
["Current","Game","North America",44675]
["Current","Game","South America",42569]
["Current","Game","Asia",43784]
["Current","Game","Europe",46336]
["Current","Game","Australia",49656]
["PY","Utility","North America",24325]
["PY","Utility","South America",33681]
["PY","Utility","Asia",39295]
["PY","Utility","Europe",59878]
["PY","Utility","Australia",29938]
["PY","Productivity","North America",52311]
["PY","Productivity","South America",31955]
["PY","Productivity","Asia",31955]
["PY","Productivity","Europe",31955]
["PY","Productivity","Australia",11598]
["PY","Game","North America",53963]
["PY","Game","South America",65965]
["PY","Game","Asia",19989]
["PY","Game","Europe",39979]
["PY","Game","Australia",19998]

{"sheet":"Calculation","index":2,"n_rows":24,"n_cols":15,"rows_kept":24,"cut":false,"hidden":false,"merged":[]}
[]
["Selected Information",null,null,null,null,"Data Table by Region for Chart",null,null,null,null,"For Header Text"]
[]
[null,null,null,null,null,null,"Revenue","Max","Average"]
["Division","Year",null,null,null,"North America",{"$f":"SUMIFS(RawData[Revenue],RawData[Year],$B$6,RawData[Division],$A$6,RawData[Region],$F5)","v":40000},{"$f":"IF(G5=MAX($G$5:$G$9),G5,\"\")","v":""},{"$f":"AVERAGE($G$5:$G$9)","v":37156.6},null,"Total Revenue for",{"$f":"SUM(G5:G9)","v":185783},{"$f":"A6&\" Apps sold\"","v":"Utility Apps sold"}]
["Utility","Current",null,null,null,"South America",{"$f":"SUMIFS(RawData[Revenue],RawData[Year],$B$6,RawData[Division],$A$6,RawData[Region],$F6)","v":20898},{"$f":"IF(G6=MAX($G$5:$G$9),G6,\"\")","v":""},37156.6,null,"Max",{"$f":"INDEX(F5:F9,MATCH(MAX(G5:G9),G5:G9,0))&\" bought the most \"&A6&\" apps\"","v":"Asia bought the most Utility apps"}]
[null,null,null,null,null,"Asia",{"$f":"SUMIFS(RawData[Revenue],RawData[Year],$B$6,RawData[Division],$A$6,RawData[Region],$F7)","v":46994},46994,37156.6,null,"Min",{"$f":"INDEX(F5:F9,MATCH(MIN(G5:G9),G5:G9,0))&\" bought the least \"&A6&\" apps\"","v":"South America bought the least Utility apps"}]
[null,null,null,null,null,"Europe",{"$f":"SUMIFS(RawData[Revenue],RawData[Year],$B$6,RawData[Division],$A$6,RawData[Region],$F8)","v":43695},"",37156.6]
[null,null,null,null,null,"Australia",{"$f":"SUMIFS(RawData[Revenue],RawData[Year],$B$6,RawData[Division],$A$6,RawData[Region],$F9)","v":34196},"",37156.6]
[]
[]
["Revenue by Region - Pivot Table",null,null,null,null,null,null,null,null,null,"For Chart - Div. Revenue by Region"]
[]
["Moved to main Dashboard"]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Revenue","Stack 1","Stack 2","Stack 3"]
[null,null,null,null,null,null,null,null,null,null,"Utility",{"$f":"GETPIVOTDATA(\"Revenue \",Dashboard!$J$20,\"Year\",\"Current\",\"Division\",K17)","v":46994},{"$f":"MIN($L$17:$L$19)/2","v":14638},{"$f":"L17-M17-O17","v":17718},14638]
[null,null,null,null,null,null,null,null,null,null,"Productivity",{"$f":"GETPIVOTDATA(\"Revenue \",Dashboard!$J$20,\"Year\",\"Current\",\"Division\",K18)","v":29276},14638,{"$f":"L18-M18-O18","v":0},14638]
[null,null,null,null,null,null,null,null,null,null,"Game",{"$f":"GETPIVOTDATA(\"Revenue \",Dashboard!$J$20,\"Year\",\"Current\",\"Division\",K19)","v":43784},14638,14508,14638]
[]
[]
[]
[]
["Select Logo"]

{"sheet":"Final Image","index":3,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}