{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Level-1","Level-2","Level-3","Level-4","Group Sheet","VBA","Consolidation","Pivot Table"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":1},"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":"Level-1","index":0,"n_rows":9,"n_cols":5,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Creating a Summary Sheet"]
[]
[null,"Subject","Term 1","Term 2","Term 3"]
[null,"Math",85,92,84]
[null,"Physics",82,87,93]
[null,"Chemistry",86,91,84]
[null,"Economics",91,94,87]
[null,"History",81,73,79]

{"sheet":"Level-2","index":1,"n_rows":9,"n_cols":5,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Creating a Summary Sheet"]
[]
[null,"Subject","Term 1","Term 2","Term 3"]
[null,"Math",87,93,88]
[null,"Physics",78,82,75]
[null,"Chemistry",78,81,87]
[null,"Economics",93,82,86]
[null,"History",87,84,78]

{"sheet":"Level-3","index":2,"n_rows":9,"n_cols":5,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Creating a Summary Sheet"]
[]
[null,"Subject","Term 1","Term 2","Term 3"]
[null,"Math",78,93,90]
[null,"Physics",89,95,85]
[null,"Chemistry",92,87,82]
[null,"Economics",73,88,88]
[null,"History",78,74,76]

{"sheet":"Level-4","index":3,"n_rows":9,"n_cols":5,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Creating a Summary Sheet"]
[]
[null,"Subject","Term 1","Term 2","Term 3"]
[null,"Math",89,93,82]
[null,"Physics",88,77,84]
[null,"Chemistry",75,86,93]
[null,"Economics",86,88,81]
[null,"History",85,72,73]

{"sheet":"Group Sheet","index":4,"n_rows":7,"n_cols":9,"rows_kept":7,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,8,1,9]]}
[]
[null,"Using Group Sheet Technique",null,null,null,null,null,null,">> Do yourself >>"]
[]
[null,"Total Marks of Math",{"$f":"SUM('Level-1:Level-4'!C5:E5)","v":1054},null,null,null,null,null,"Total Marks of Math"]
[null,"Total Marks of Physics",{"$f":"SUM('Level-1:Level-4'!C6:E6)","v":1015},null,null,null,null,null,"Total Marks of Physics"]
[null,"Total Marks of Chemistry",{"$f":"SUM('Level-1:Level-4'!C7:E7)","v":1022},null,null,null,null,null,"Total Marks of Chemistry"]
[null,"Total Marks of Economics",{"$f":"SUM('Level-1:Level-4'!C8:E8)","v":1037},null,null,null,null,null,"Total Marks of Economics"]

{"sheet":"VBA","index":5,"n_rows":11,"n_cols":7,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Applying VBA",null,null,null,null,">> Do yourself >>"]
[]
[null,"Level-1"]
[null,"Level-2"]
[null,"Level-3"]
[null,"Level-4"]
[null,"Group Sheet"]
[null,"INDIRECT Function"]
[null,"Consolidation"]
[null,"Pivot Table"]

{"sheet":"Consolidation","index":6,"n_rows":27,"n_cols":14,"rows_kept":27,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,8,1,9]]}
[]
[null,"Using Consolidation Tool",null,null,null,null,null,null,">> Do yourself >>"]
[]
[]
[]
[]
[]
[null,null,{"$f":"'Level-1'!$C$5","v":85},null,null,null,null,null,null,{"$f":"'Level-1'!$C$5","v":85}]
[null,null,{"$f":"'Level-2'!$C$5","v":87},null,null,null,null,null,null,{"$f":"'Level-2'!$C$5","v":87}]
[null,null,{"$f":"'Level-3'!$C$5","v":78},null,null,null,null,null,null,{"$f":"'Level-3'!$C$5","v":78}]
[null,null,{"$f":"'Level-4'!$C$5","v":89},null,null,null,null,null,null,{"$f":"'Level-4'!$C$5","v":89}]
[null,"Total Marks of Math",{"$f":"SUM(C8:C11)","v":339},null,null,null,null,null,"Total Marks of Math",{"$f":"SUM(J8:J11)","v":339}]
[null,"Total Marks of Physics",null,null,null,null,null,null,"Total Marks of Physics"]
[null,"Total Marks of Chemistry",null,null,null,null,null,null,"Total Marks of Chemistry"]
[null,"Total Marks of Economics",null,null,null,null,null,null,"Total Marks of Economics"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Level-1'!$C$5","v":85},{"$f":"'Level-1'!$D$5","v":92},{"$f":"'Level-1'!$E$5","v":84}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Level-2'!$C$5","v":87},{"$f":"'Level-2'!$D$5","v":93},{"$f":"'Level-2'!$E$5","v":88}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Level-3'!$C$5","v":78},{"$f":"'Level-3'!$D$5","v":93},{"$f":"'Level-3'!$E$5","v":90}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Level-4'!$C$5","v":89},{"$f":"'Level-4'!$D$5","v":93},{"$f":"'Level-4'!$E$5","v":82}]

{"sheet":"Pivot Table","index":7,"n_rows":10,"n_cols":4,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Using Pivot Table Feature"]
[]
[null,"Row Labels","Average of Term 1","Sum of Term 2"]
[null,"Chemistry",86,91]
[null,"Economics",91,94]
[null,"History",81,73]
[null,"Math",85,92]
[null,"Physics",82,87]
[null,"Grand Total",85,437]