{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["PowerQuery","PowerQuery Result","Functions","Macros and VBA","Roots","Arcsine Transformation","Transpose Data","CSV_file","Text String","Text","Overview Image"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":3,"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":"PowerQuery","index":0,"n_rows":14,"n_cols":4,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Transform Data in Excel"]
[]
[null,"Player ID","Name","Goals"]
[null,201411001,"Alice",22]
[null,201411002,"Bob",17]
[null,201411003,"Jack",18]
[null,201411004,"Ram",22]
[null,201411005,"Smith",16]
[null,201411006,"Rafael",21]
[null,201411007,"Brook",18]
[null,201411008,"John",22]
[null,201411009,"Morgan",20]
[null,201411010,"Adam",16]

{"sheet":"PowerQuery Result","index":1,"n_rows":11,"n_cols":3,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
["Player ID","Name","Goals"]
[201411004,"Ram",22]
[201411001,"Alice",22]
[201411008,"John",22]
[201411006,"Rafael",21]
[201411009,"Morgan",20]
[201411007,"Brook",18]
[201411003,"Jack",18]
[201411002,"Bob",17]
[201411005,"Smith",16]
[201411010,"Adam",16]

{"sheet":"Functions","index":2,"n_rows":15,"n_cols":9,"rows_kept":15,"cut":false,"hidden":false,"merged":[[3,7,4,7],[3,8,4,8],[1,1,1,8],[3,1,4,1],[3,2,4,2],[3,3,3,5],[3,6,4,6]]}
[]
[null,"Transform Data in Excel"]
[]
[null,"Student ID","Name","Subject",null,null,"Total","Average","Max"]
[null,null,null,"Physics","Math","Chemistry"]
[null,201411001,"Alice",72,82,86,{"$f":"SUM(D6:F6)","v":240},{"$f":"AVERAGE(D6:F6)","v":80},{"$f":"MAX(D6:F6)","v":86}]
[null,201411002,"Bob",64,62,64,{"$f":"SUM(D7:F7)","v":190},{"$f":"AVERAGE(D7:F7)","v":63.333333333333336},{"$f":"MAX(D7:F7)","v":64}]
[null,201411003,"Jack",76,64,65,205,68.333333333333329,76]
[null,201411004,"Ram",60,70,70,200,66.666666666666671,70]
[null,201411005,"Smith",69,83,79,231,77,83]
[null,201411006,"Rafael",76,70,73,219,73,76]
[null,201411007,"Brook",89,87,84,260,86.666666666666671,89]
[null,201411008,"John",64,77,71,212,70.666666666666671,77]
[null,201411009,"Morgan",95,68,83,246,82,95]
[null,201411010,"Adam",93,73,81,247,82.333333333333329,93]

{"sheet":"Macros and VBA","index":3,"n_rows":14,"n_cols":4,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Transform Data in Excel"]
[]
[null,"Player ID","Name","Goals"]
[null,201411001,"Alice",22]
[null,201411004,"Ram",22]
[null,201411008,"John",22]
[null,201411006,"Rafael",21]
[null,201411009,"Morgan",20]
[null,201411003,"Jack",18]
[null,201411007,"Brook",18]
[null,201411002,"Bob",17]
[null,201411005,"Smith",16]
[null,201411010,"Adam",16]

{"sheet":"Roots","index":4,"n_rows":13,"n_cols":4,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Transform Data in Excel"]
[]
[null,"Number","Square Root","Cubic Root"]
[null,16,{"$f":"SQRT(B5)","v":4},{"$f":"B5^(1/3)","v":2.5198420997897459}]
[null,49,{"$f":"SQRT(B6)","v":7},{"$f":"B6^(1/3)","v":3.6593057100229709}]
[null,64,8,3.9999999999999991]
[null,81,9,4.3267487109222253]
[null,100,10,4.6415888336127793]
[null,256,16,6.3496042078727974]
[null,512,22.627416997969522,7.9999999999999982]
[null,729,27,8.9999999999999982]
[null,1000,31.622776601683793,9.9999999999999982]

{"sheet":"Arcsine Transformation","index":5,"n_rows":9,"n_cols":4,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Transform Data in Excel"]
[]
[null,"Event","Probability","Arcsine Transformation"]
[null,"Winning a Toss",0.5,{"$f":"ASIN(C5)","v":0.52359877559829893}]
[null,"Occuring rain tomorrow",0.7,{"$f":"ASIN(C6)","v":0.77539749661075308}]
[null,"Getting a 4 after rolling a dice",0.16,0.1606906529519106]
[null,"Chance of Winning a Cricket Match",0.5,0.52359877559829893]
[null,"Falling snow in the next week",0.8,0.9272952180016123]

{"sheet":"Transpose Data","index":6,"n_rows":14,"n_cols":6,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Transform Data in Excel"]
[]
[null,"Zone","Asia","Europe","Africa","North America"]
[null,"Q-1",1037469,2205226,1218307,2616111]
[null,"Q-2",2633248,2770936,1592873,2966982]
[null,"Q-3",1507423,1260533,2372492,2711968]
[null,"Q-4",1319986,1259922,1125114,2694765]
[]
[null,"Zone","Q-1","Q-2","Q-3","Q-4"]
[null,"Asia",1037469,2633248,1507423,1319986]
[null,"Europe",2205226,2770936,1260533,1259922]
[null,"Africa",1218307,1592873,2372492,1125114]
[null,"North America",2616111,2966982,2711968,2694765]

{"sheet":"CSV_file","index":7,"n_rows":11,"n_cols":3,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
["Player ID","Name","Goals"]
[201411001,"Alice",22]
[201411002,"Bob",17]
[201411003,"Jack",18]
[201411004,"Ram",22]
[201411005,"Smith",16]
[201411006,"Rafael",21]
[201411007,"Brook",18]
[201411008,"John",22]
[201411009,"Morgan",20]
[201411010,"Adam",16]

{"sheet":"Text String","index":8,"n_rows":11,"n_cols":3,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
["Player ID","Name","Goals"]
[201411008,"John",22]
[201411004,"Ram",22]
[201411001,"Alice",22]
[201411006,"Rafael",21]
[201411009,"Morgan",20]
[201411007,"Brook",18]
[201411003,"Jack",18]
[201411002,"Bob",17]
[201411010,"Adam",16]
[201411005,"Smith",16]

{"sheet":"Text","index":9,"n_rows":14,"n_cols":3,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Transform Data in Excel"]
[]
[null,"Player","Goals"]
[null,"201411001,Alice",22]
[null,"201411004,Ram",22]
[null,"201411008,John",22]
[null,"201411006,Rafael",21]
[null,"201411009,Morgan",20]
[null,"201411003,Jack",18]
[null,"201411007,Brook",18]
[null,"201411002,Bob",17]
[null,"201411005,Smith",16]
[null,"201411010,Adam",16]

{"sheet":"Overview Image","index":10,"n_rows":15,"n_cols":9,"rows_kept":15,"cut":false,"hidden":true,"merged":[[1,1,1,8],[3,1,4,1],[3,2,4,2],[3,3,3,5],[3,6,4,6],[3,7,4,7],[3,8,4,8]]}
[]
[null,"Overview of Transform Data in Excel"]
[]
[null,"Student ID","Name","Subject",null,null,"Total","Average","Max"]
[null,null,null,"Physics","Math","Chemistry"]
[null,201411001,"Alice",72,82,86,{"$f":"SUM(D6:F6)","v":240},{"$f":"AVERAGE(D6:F6)","v":80},{"$f":"MAX(D6:F6)","v":86}]
[null,201411002,"Bob",64,62,64,{"$f":"SUM(D7:F7)","v":190},{"$f":"AVERAGE(D7:F7)","v":63.333333333333336},{"$f":"MAX(D7:F7)","v":64}]
[null,201411003,"Jack",76,64,65,205,68.333333333333329,76]
[null,201411004,"Ram",60,70,70,200,66.666666666666671,70]
[null,201411005,"Smith",69,83,79,231,77,83]
[null,201411006,"Rafael",76,70,73,219,73,76]
[null,201411007,"Brook",89,87,84,260,86.666666666666671,89]
[null,201411008,"John",64,77,71,212,70.666666666666671,77]
[null,201411009,"Morgan",95,68,83,246,82,95]
[null,201411010,"Adam",93,73,81,247,82.333333333333329,93]