{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Data Set","SUM_Function_1","SUM_Function_2","SUMPRODUCT_&_SUM","SUM_&_COUNT","AVERAGE_Function","AutoSum_Tool","VBA_Macro"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"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 Set","index":0,"n_rows":9,"n_cols":4,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,3],[4,1,8,1]]}
[]
[null,"Average Rating"]
[]
[null,"Name","Rating","No. of Customer"]
[null,"Money Heist",5,125]
[null,null,4,321]
[null,null,3,264]
[null,null,2,21]
[null,null,1,365]

{"sheet":"SUM_Function_1","index":1,"n_rows":11,"n_cols":5,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,4],[4,1,8,1],[9,1,9,2],[10,1,10,3]]}
[]
[null,"Average Rating Using SUM Function"]
[]
[null,"Name","Rating","No. of Customer","Subtotal Rating"]
[null,"Money Heist",5,125,{"$f":"C5:C9*D5:D9","v":625}]
[null,null,4,321,1284]
[null,null,3,264,792]
[null,null,2,21,42]
[null,null,1,365,365]
[null,"Total",null,{"$f":"SUM(D5:D9)","v":1096},{"$f":"SUM(E5:E9)","v":3108}]
[null,"Average Rating",null,null,{"$f":"E10/D10","v":2.835766423357664}]

{"sheet":"SUM_Function_2","index":2,"n_rows":13,"n_cols":4,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,3],[4,1,8,1],[10,1,10,2],[11,1,11,2],[12,1,12,2]]}
[]
[null,"Average Rating Using SUM Function (2)"]
[]
[null,"Name","Rating","No. of Customer"]
[null,"Money Heist",5,125]
[null,null,4,321]
[null,null,3,264]
[null,null,2,21]
[null,null,1,365]
[]
[null,"Total Customer",null,{"$f":"SUM(D5:D9)","v":1096}]
[null,"Subtotal Rating",null,{"$f":"SUM(C5:C9*D5:D9)","v":3108}]
[null,"Average Rating",null,{"$f":"D12/D11","v":2.835766423357664}]

{"sheet":"SUMPRODUCT_&_SUM","index":3,"n_rows":13,"n_cols":4,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,3],[4,1,8,1],[10,1,10,2],[11,1,11,2],[12,1,12,2]]}
[]
[null,"Insert SUMPRODUCT with SUM Function"]
[]
[null,"Name","Rating","No. of Customer"]
[null,"Money Heist",5,125]
[null,null,4,321]
[null,null,3,264]
[null,null,2,21]
[null,null,1,365]
[]
[null,"Total Customer",null,{"$f":"SUM(D5:D9)","v":1096}]
[null,"Subtotal Rating",null,{"$f":"SUMPRODUCT(C5:C9,D5:D9)","v":3108}]
[null,"Average Rating",null,{"$f":"D12/D11","v":2.835766423357664}]

{"sheet":"SUM_&_COUNT","index":4,"n_rows":18,"n_cols":3,"rows_kept":18,"cut":false,"hidden":false,"merged":[[4,1,13,1],[1,1,1,2]]}
[]
[null,"Combination of SUM and COUNT Function"]
[]
[null,"Name","Rating"]
[null,"Money Heist",3]
[null,null,5]
[null,null,1]
[null,null,2]
[null,null,3]
[null,null,4]
[null,null,2]
[null,null,1]
[null,null,3]
[null,null,2]
[]
[null,"Total Customer",{"$f":"COUNT(C5:C14)","v":10}]
[null,"Subtotal Rating",{"$f":"SUM(C5:C14)","v":26}]
[null,"Average Rating",{"$f":"C17/C16","v":2.6}]

{"sheet":"AVERAGE_Function","index":5,"n_rows":15,"n_cols":3,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,1,1,2],[4,1,13,1]]}
[]
[null,"AVERAGE Function to Calculate Average Rating"]
[]
[null,"Name","Rating"]
[null,"Money Heist",3]
[null,null,5]
[null,null,1]
[null,null,2]
[null,null,3]
[null,null,4]
[null,null,2]
[null,null,1]
[null,null,3]
[null,null,2]
[null,"Average Rating",{"$f":"AVERAGE(C5:C14)","v":2.6}]

{"sheet":"AutoSum_Tool","index":6,"n_rows":15,"n_cols":3,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,1,1,2],[4,1,13,1]]}
[]
[null,"AutoSum Tool to Calculate Average Rating"]
[]
[null,"Name","Rating"]
[null,"Money Heist",3]
[null,null,5]
[null,null,1]
[null,null,2]
[null,null,3]
[null,null,4]
[null,null,2]
[null,null,1]
[null,null,3]
[null,null,2]
[null,"Average Rating",{"$f":"AVERAGE(C5:C14)","v":2.6}]

{"sheet":"VBA_Macro","index":7,"n_rows":14,"n_cols":3,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,2],[4,1,13,1]]}
[]
[null,"Excel VBA to Calculate Average Rating"]
[]
[null,"Name","Rating"]
[null,"Money Heist",3]
[null,null,5]
[null,null,1]
[null,null,2]
[null,null,3]
[null,null,4]
[null,null,2]
[null,null,1]
[null,null,3]
[null,null,2]