{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["DATASET1","DATASET2","DATASET3","CONSOLIDATE","Query1","VBA"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"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":"DATASET1","index":0,"n_rows":9,"n_cols":4,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"DATASET 1"]
[]
[null,"Student No.","Name","Semester Marks"]
[null,801120,"JOEY",350]
[null,801121,"MONICA",380]
[null,801125,"CHARLIE",340]
[null,801126,"LORAINE",290]
[null,801127,"CHER",280]

{"sheet":"DATASET2","index":1,"n_rows":9,"n_cols":4,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"DATASET 2"]
[]
[null,"Student No.","Name","Semester Marks"]
[null,801128,"JAMIE",330]
[null,801129,"CARLA",340]
[null,801130,"RUBY",350]
[null,801132,"SUSANE",320]
[null,801134,"ROBERT",295]

{"sheet":"DATASET3","index":2,"n_rows":9,"n_cols":4,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"DATASET 3"]
[]
[null,"Student No.","Name","Semester Marks"]
[null,801135,"JOLIE",290]
[null,801136,"JUDY",310]
[null,801138,"ROBIN",380]
[null,801139,"BROWN",390]
[null,801140,"SIMONE",360]

{"sheet":"CONSOLIDATE","index":3,"n_rows":29,"n_cols":3,"rows_kept":29,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
["Student No.","Name","Semester Marks"]
[{"$f":"DATASET1!$B$5","v":801120},null,{"$f":"DATASET1!$D$5","v":350}]
[{"$f":"DATASET2!$B$5","v":801128},null,{"$f":"DATASET2!$D$5","v":330}]
[{"$f":"DATASET3!$B$5","v":801135},null,{"$f":"DATASET3!$D$5","v":290}]
[{"$f":"SUM(A10:A12)","v":2403383},null,{"$f":"SUM(C10:C12)","v":970}]
[{"$f":"DATASET1!$B$6","v":801121},null,{"$f":"DATASET1!$D$6","v":380}]
[{"$f":"DATASET2!$B$6","v":801129},null,{"$f":"DATASET2!$D$6","v":340}]
[{"$f":"DATASET3!$B$6","v":801136},null,{"$f":"DATASET3!$D$6","v":310}]
[{"$f":"SUM(A14:A16)","v":2403386},null,{"$f":"SUM(C14:C16)","v":1030}]
[{"$f":"DATASET1!$B$7","v":801125},null,{"$f":"DATASET1!$D$7","v":340}]
[{"$f":"DATASET2!$B$7","v":801130},null,{"$f":"DATASET2!$D$7","v":350}]
[{"$f":"DATASET3!$B$7","v":801138},null,{"$f":"DATASET3!$D$7","v":380}]
[{"$f":"SUM(A18:A20)","v":2403393},null,{"$f":"SUM(C18:C20)","v":1070}]
[{"$f":"DATASET1!$B$8","v":801126},null,{"$f":"DATASET1!$D$8","v":290}]
[{"$f":"DATASET2!$B$8","v":801132},null,{"$f":"DATASET2!$D$8","v":320}]
[{"$f":"DATASET3!$B$8","v":801139},null,{"$f":"DATASET3!$D$8","v":390}]
[{"$f":"SUM(A22:A24)","v":2403397},null,{"$f":"SUM(C22:C24)","v":1000}]
[{"$f":"DATASET1!$B$9","v":801127},null,{"$f":"DATASET1!$D$9","v":280}]
[{"$f":"DATASET2!$B$9","v":801134},null,{"$f":"DATASET2!$D$9","v":295}]
[{"$f":"DATASET3!$B$9","v":801140},null,{"$f":"DATASET3!$D$9","v":360}]
[{"$f":"SUM(A26:A28)","v":2403401},null,{"$f":"SUM(C26:C28)","v":935}]

{"sheet":"Query1","index":4,"n_rows":17,"n_cols":4,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
["Student No.","Name.1","Semester Marks","Name"]
[801120,"JOEY",350,"Table1"]
[801121,"MONICA",380,"Table1"]
[801125,"CHARLIE",340,"Table1"]
[801126,"LORAINE",290,"Table1"]
[801127,"CHER",280,"Table1"]
[801128,"JAMIE",330,"Table13"]
[801129,"CARLA",340,"Table13"]
[801130,"RUBY",350,"Table13"]
[801132,"SUSANE",320,"Table13"]
[801134,"ROBERT",295,"Table13"]
[801135,"JOLIE",290,"Table134"]
[801136,"JUDY",310,"Table134"]
[801138,"ROBIN",380,"Table134"]
[801139,"BROWN",390,"Table134"]
[801140,"SIMONE",360,"Table134"]
[null,null,null,"Query1!ExternalData_1"]

{"sheet":"VBA","index":5,"n_rows":19,"n_cols":4,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[null,"Student No.","Name","Semester Marks"]
[null,801120,"JOEY",350]
[null,801121,"MONICA",380]
[null,801125,"CHARLIE",340]
[null,801126,"LORAINE",290]
[null,801127,"CHER",280]
[null,801128,"JAMIE",330]
[null,801129,"CARLA",340]
[null,801130,"RUBY",350]
[null,801132,"SUSANE",320]
[null,801134,"ROBERT",295]
[null,801135,"JOLIE",290]
[null,801136,"JUDY",310]
[null,801138,"ROBIN",380]
[null,801139,"BROWN",390]
[null,801140,"SIMONE",360]