{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["One by One Range","Named Range","Except Zeros","Excel Functions","VBA"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":2,"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":"One by One Range","index":0,"n_rows":12,"n_cols":15,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,11,1,14],[11,1,11,2],[11,11,11,12]]}
[]
[null,"Dataset",null,null,null,null,null,null,null,null,null,"Practice"]
[]
[null,"Player ","Game1 Score","Game2 Score","Game3 Score",null,null,null,null,null,null,"Player ","Game1 Score","Game2 Score","Game3 Score"]
[null,"P1",78,65,59,null,null,null,null,null,null,"P1",78,65,59]
[null,"P1",71,33,73,null,null,null,null,null,null,"P1",71,33,73]
[null,"P1",0,89,84,null,null,null,null,null,null,"P1",0,89,84]
[null,"P2",92,56,73,null,null,null,null,null,null,"P2",92,56,73]
[null,"P2",46,0,25,null,null,null,null,null,null,"P2",46,0,25]
[null,"P3",77,34,57,null,null,null,null,null,null,"P3",77,34,57]
[]
[null,"Average Score with Zero",null,{"$f":"AVERAGE(C5:C9,D5:D7,E5:E9)","v":60.615384615384613},null,null,null,null,null,null,null,"Average Score with Zero",null,{"$f":"AVERAGE(C5:C9,D5:D7,E5:E9)","v":60.615384615384613}]

{"sheet":"Named Range","index":1,"n_rows":12,"n_cols":15,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,11,1,14],[11,1,11,2],[11,11,11,12]]}
[]
[null,"Use of AVERAGE Function",null,null,null,null,null,null,null,null,null,"Practice"]
[]
[null,"Player ","Game1 Score","Game2 Score","Game3 Score",null,null,null,null,null,null,"Player ","Game1 Score","Game2 Score","Game3 Score"]
[null,1,78,65,59,null,null,null,null,null,null,1,78,65,59]
[null,1,71,33,73,null,null,null,null,null,null,1,71,33,73]
[null,1,0,89,84,null,null,null,null,null,null,1,0,89,84]
[null,2,92,56,73,null,null,null,null,null,null,2,92,56,73]
[null,2,46,0,25,null,null,null,null,null,null,2,46,0,25]
[null,3,77,34,57,null,null,null,null,null,null,3,77,34,57]
[]
[null,"Average Score with Zero",null,{"$f":"AVERAGE(Score)","v":60.615384615384613},null,null,null,null,null,null,null,"Average Score with Zero"]

{"sheet":"Except Zeros","index":2,"n_rows":12,"n_cols":15,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,11,1,14],[11,1,11,2],[11,11,11,12]]}
[]
[null,"Use of SUM, INDEX, And FREQUENCY Function",null,null,null,null,null,null,null,null,null,"Practice"]
[]
[null,"Player ","Game1 Score","Game2 Score","Game3 Score",null,null,null,null,null,null,"Player ","Game1 Score","Game2 Score","Game3 Score"]
[null,1,78,65,59,null,null,null,null,null,null,1,78,65,59]
[null,1,71,33,73,null,null,null,null,null,null,1,71,33,73]
[null,1,0,89,84,null,null,null,null,null,null,1,0,89,84]
[null,2,92,56,73,null,null,null,null,null,null,2,92,56,73]
[null,2,46,0,25,null,null,null,null,null,null,2,46,0,25]
[null,3,77,34,57,null,null,null,null,null,null,3,77,34,57]
[]
[null,"Average Score without Zero",null,{"$f":"SUM(C5:C9,D5:D7,E5:E9)/INDEX(FREQUENCY((C5:C9,D5:D7,E5:E9),0),2)","v":65.666666666666671},null,null,null,null,null,null,null,"Average Score without Zero"]

{"sheet":"Excel Functions","index":3,"n_rows":12,"n_cols":15,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,11,1,14],[11,1,11,2],[11,11,11,12]]}
[]
[null,"Use of SUM, INDEX, And FREQUENCY Function",null,null,null,null,null,null,null,null,null,"Practice"]
[]
[null,"Player ","Game1 Score","Game2 Score","Game3 Score",null,null,null,null,null,null,"Player ","Game1 Score","Game2 Score","Game3 Score"]
[null,1,78,65,59,null,null,null,null,null,null,1,78,65,59]
[null,1,71,33,73,null,null,null,null,null,null,1,71,33,73]
[null,1,0,89,84,null,null,null,null,null,null,1,0,89,84]
[null,2,92,56,73,null,null,null,null,null,null,2,92,56,73]
[null,2,46,0,25,null,null,null,null,null,null,2,46,0,25]
[null,3,77,34,57,null,null,null,null,null,null,3,77,34,57]
[]
[null,"Average Score without Zero",null,{"$f":"SUM(Scores)/INDEX(FREQUENCY((Scores),0),2)","v":65.666666666666671},null,null,null,null,null,null,null,"Average Score without Zero"]

{"sheet":"VBA","index":4,"n_rows":10,"n_cols":14,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,9,1,11],[3,13,3,14]]}
[]
[null,"Use of VBA Macros",null,null,null,null,null,null,null,"Practice"]
[]
[null,"Player ","Game1 Score","Game2 Score",null,"Average Score",null,null,null,"Player ","Game1 Score","Game2 Score",null,"Average Score"]
[null,1,78,65,null,53.416666666666664,null,null,null,1,78,65]
[null,1,71,33,null,null,null,null,null,1,71,33]
[null,1,0,89,null,null,null,null,null,1,0,89]
[null,2,92,56,null,null,null,null,null,2,92,56]
[null,2,46,0,null,null,null,null,null,2,46,0]
[null,3,77,34,null,null,null,null,null,3,77,34]