{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["LSI2","LSI","VBA","AutoSum Feature","AVERAGE function ","SUM with COUNT Function","SUMPRODUCT and SUM Function","SUM Function Multiple","SUM function After Multiplicati","Data"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"defined_names":1,"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":"LSI2","index":0,"n_rows":12,"n_cols":4,"rows_kept":12,"cut":false,"hidden":false,"merged":[[5,1,9,1],[2,1,2,3],[11,1,11,2]]}
[]
[]
[null,"Calculating Average Rating of TV Series"]
[]
[null,"Name","Rater","Rating"]
[null,"House of Dragon","IMDB",9.6999999999999993]
[null,null,"Rotten Tomatoes",9.5]
[null,null,"IMDB",9.3000000000000007]
[null,null,"IMDB",9.1]
[null,null,"Rotten Tomatoes",9.4]
[]
[null,"Average Rating of IMDB Raters",null,{"$f":"AVERAGEIF(C6:C10,\"IMDB\",D6:D10)","v":9.3666666666666671}]

{"sheet":"LSI","index":1,"n_rows":12,"n_cols":4,"rows_kept":12,"cut":false,"hidden":false,"merged":[[2,1,2,3],[5,1,9,1],[11,1,11,2]]}
[]
[]
[null,"Calculating Average Rating of TV Series"]
[]
[null,"Name","Rating","Weight"]
[null,"House of Dragon",9.6999999999999993,0.3]
[null,null,9.5,0.1]
[null,null,9.3000000000000007,0.15]
[null,null,9.1,0.25]
[null,null,9.4,0.2]
[]
[null,"Wighted Average",null,{"$f":"SUMPRODUCT(C6:C10*D6:D10)","v":9.41}]

{"sheet":"VBA","index":2,"n_rows":12,"n_cols":3,"rows_kept":12,"cut":false,"hidden":false,"merged":[[5,1,9,1],[2,1,2,2]]}
[]
[]
[null,"Calculating Average Rating of TV Series"]
[]
[null,"Name","Rating"]
[null,"House of Dragon",9.6999999999999993]
[null,null,9.5]
[null,null,9.3000000000000007]
[null,null,9.1]
[null,null,9.4]
[]
[null,"Average Rating"]

{"sheet":"AutoSum Feature","index":3,"n_rows":11,"n_cols":3,"rows_kept":11,"cut":false,"hidden":false,"merged":[[5,1,9,1],[2,1,2,2]]}
[]
[]
[null,"Calculating Average Rating of TV Series"]
[]
[null,"Name","Rating"]
[null,"House of Dragon",9.6999999999999993]
[null,null,9.5]
[null,null,9.3000000000000007]
[null,null,9.1]
[null,null,9.4]
[null,"Average Rating",{"$f":"AVERAGE(C6:C10)","v":9.4}]

{"sheet":"AVERAGE function ","index":4,"n_rows":12,"n_cols":3,"rows_kept":12,"cut":false,"hidden":false,"merged":[[2,1,2,2],[5,1,9,1]]}
[]
[]
[null,"Calculating Average Rating of TV Series"]
[]
[null,"Name","Rating"]
[null,"House of Dragon",9.6999999999999993]
[null,null,9.5]
[null,null,9.3000000000000007]
[null,null,9.1]
[null,null,9.4]
[]
[null,"Average Rating",{"$f":"AVERAGE(C6:C10)","v":9.4}]

{"sheet":"SUM with COUNT Function","index":5,"n_rows":14,"n_cols":3,"rows_kept":14,"cut":false,"hidden":false,"merged":[[2,1,2,2],[5,1,9,1]]}
[]
[]
[null,"Calculating Average Rating of TV Series"]
[]
[null,"Name","Rating"]
[null,"House of Dragon",9.6999999999999993]
[null,null,9.5]
[null,null,9.3000000000000007]
[null,null,9.1]
[null,null,9.4]
[]
[null,"Total Subscriber",{"$f":"COUNT(C6:C10)","v":5}]
[null,"Subtotal Rating",{"$f":"SUM(C6:C10)","v":47}]
[null,"Average Rating",{"$f":"C13/C12","v":9.4}]

{"sheet":"SUMPRODUCT and SUM Function","index":6,"n_rows":14,"n_cols":4,"rows_kept":14,"cut":false,"hidden":false,"merged":[[5,1,9,1],[2,1,2,3]]}
[]
[]
[null,"Calculating Average Rating of TV Series"]
[]
[null,"Name","Rating","No. of Subscriber"]
[null,"House of Dragon",9.6999999999999993,5000]
[null,null,9.5,3500]
[null,null,9.3000000000000007,3000]
[null,null,9.1,2800]
[null,null,9.4,2900]
[]
[null,"Total Subscriber",{"$f":"SUM(D6:D10)","v":17200}]
[null,"Subtotal Rating",{"$f":"SUMPRODUCT(C6:C10,D6:D10)","v":162390}]
[null,"Average Rating",{"$f":"C13/C12","v":9.4412790697674414}]

{"sheet":"SUM Function Multiple","index":7,"n_rows":14,"n_cols":4,"rows_kept":14,"cut":false,"hidden":false,"merged":[[2,1,2,3],[5,1,9,1]]}
[]
[]
[null,"Calculating Average Rating of TV Series"]
[]
[null,"Name","Rating","No. of Subscriber"]
[null,"House of Dragon",9.6999999999999993,5000]
[null,null,9.5,3500]
[null,null,9.3000000000000007,3000]
[null,null,9.1,2800]
[null,null,9.4,2900]
[]
[null,"Total Subscriber",{"$f":"SUM(D6:D10)","v":17200}]
[null,"Subtotal Rating",{"$f":"SUM(C6:C10*D6:D10)","v":162390}]
[null,"Average Rating",{"$f":"C13/C12","v":9.4412790697674414}]

{"sheet":"SUM function After Multiplicati","index":8,"n_rows":12,"n_cols":5,"rows_kept":12,"cut":false,"hidden":false,"merged":[[5,1,9,1],[10,1,10,2],[11,1,11,3],[2,1,2,4]]}
[]
[]
[null,"Calculating Average Rating of TV Series"]
[]
[null,"Name","Rating","No. of Subscriber","Subtotal"]
[null,"House of Dragon",9.6999999999999993,5000,{"$f":"C6*D6","v":48500}]
[null,null,9.5,3500,{"$f":"C7*D7","v":33250}]
[null,null,9.3000000000000007,3000,27900.000000000004]
[null,null,9.1,2800,25480]
[null,null,9.4,2900,27260]
[null,"Total",null,{"$f":"SUM(D6:D10)","v":17200},{"$f":"SUM(E6:E10)","v":162390}]
[null,"Average Rating",null,null,{"$f":"E11/D11","v":9.4412790697674414}]

{"sheet":"Data","index":9,"n_rows":19,"n_cols":4,"rows_kept":19,"cut":false,"hidden":false,"merged":[[5,1,9,1],[2,1,2,3]]}
[]
[]
[null,"Calculating Average Rating of TV Series"]
[]
[null,"Name","Rating","No. of Subscriber"]
[null,"House of Dragon",9.6999999999999993,5000]
[null,null,9.5,3500]
[null,null,9.3000000000000007,3000]
[null,null,9.1,2800]
[null,null,9.4,2900]
[]
[null,"Method","Outcome","Formula"]
[null,"SUM Function",9.4412790697674414,"=SUM(D6:D10)"]
[null,"SUM Function Multiple Times",9.4412790697674414,"=SUM(C6:C10*D6:D10)"]
[null,"SUMPRODUCT Function",9.4412790697674414,"=SUMPRODUCT(C6:C10,D6:D10)"]
[null,"COUNT Function",9.4412790697674414,"=COUNT(C6:C10)"]
[null,"Average Function",9.4412790697674414,"=AVERAGE(C6:C10)"]
[null,"AutoSum Feature",9.4412790697674414]
[null,"VBA",9.4412790697674414]