{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Paste Special Command","Paste Special and Link","TRANSPOSE Function_1","TRANSPOSE Function_2","IF&TRANSPOSE Function","INDIRECT&ADDRESS Function","Power Query Tool","Use of VBA Macros"],"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":"Paste Special Command","index":0,"n_rows":18,"n_cols":9,"rows_kept":18,"cut":false,"hidden":false,"merged":[[1,1,1,8]]}
[]
[null,"Use of Paste Special Command"]
[]
[null,"Name","AY 2015","AY 2016","AY 2017","AY 2018","AY 2019","AY 2020","AY 2021"]
[null,"John","A+","A","A+","A-","B","A+","A+"]
[null,"Michael","A-","A+","A","A","A+","A+","A+"]
[null,"Martin","A+","A","A-","A+","A+","A+","B"]
[null,"Ricky","A-","A+","A+","A+","A+","A","B"]
[null,"Jack","B","A+","A-","A+","A","A+","A+"]
[]
[null,"Name","John","Michael","Martin","Ricky","Jack"]
[null,"AY 2015","A+","A-","A+","A-","B"]
[null,"AY 2016","A","A+","A","A+","A+"]
[null,"AY 2017","A+","A","A-","A+","A-"]
[null,"AY 2018","A-","A","A+","A+","A+"]
[null,"AY 2019","B","A+","A+","A+","A"]
[null,"AY 2020","A+","A+","A+","A","A+"]
[null,"AY 2021","A+","A+","B","B","A+"]

{"sheet":"Paste Special and Link","index":1,"n_rows":16,"n_cols":16,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,8]]}
[]
[null,"Paste Special and Link to Initial Data"]
[]
[null,"Name","AY 2015","AY 2016","AY 2017","AY 2018","AY 2019","AY 2020","AY 2021",null,{"$f":"B4","v":"Name"},{"$f":"B5","v":"John"},{"$f":"B6","v":"Michael"},{"$f":"B7","v":"Martin"},{"$f":"B8","v":"Ricky"},{"$f":"B9","v":"Jack"}]
[null,"John","A+","A","A+","A-","B","A+","A+",null,{"$f":"C4","v":"AY 2015"},{"$f":"C5","v":"A+"},{"$f":"C6","v":"A-"},{"$f":"C7","v":"A+"},{"$f":"C8","v":"A-"},{"$f":"C9","v":"B"}]
[null,"Michael","A-","A+","A","A","A+","A+","A+",null,{"$f":"D4","v":"AY 2016"},{"$f":"D5","v":"A"},{"$f":"D6","v":"A+"},{"$f":"D7","v":"A"},{"$f":"D8","v":"A+"},{"$f":"D9","v":"A+"}]
[null,"Martin","A+","A","A-","A+","A+","A+","B",null,{"$f":"E4","v":"AY 2017"},{"$f":"E5","v":"A+"},{"$f":"E6","v":"A"},{"$f":"E7","v":"A-"},{"$f":"E8","v":"A+"},{"$f":"E9","v":"A-"}]
[null,"Ricky","A-","A+","A+","A+","A+","A","B",null,{"$f":"F4","v":"AY 2018"},{"$f":"F5","v":"A-"},{"$f":"F6","v":"A"},{"$f":"F7","v":"A+"},{"$f":"F8","v":"A+"},{"$f":"F9","v":"A+"}]
[null,"Jack","B","A+","A-","A+","A","A+","A+",null,{"$f":"G4","v":"AY 2019"},{"$f":"G5","v":"B"},{"$f":"G6","v":"A+"},{"$f":"G7","v":"A+"},{"$f":"G8","v":"A+"},{"$f":"G9","v":"A"}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"H4","v":"AY 2020"},{"$f":"H5","v":"A+"},{"$f":"H6","v":"A+"},{"$f":"H7","v":"A+"},{"$f":"H8","v":"A"},{"$f":"H9","v":"A+"}]
[null,"abcB4","abcC4","abcD4","abcE4","abcF4","abcG4","abcH4","abcI4",null,{"$f":"I4","v":"AY 2021"},{"$f":"I5","v":"A+"},{"$f":"I6","v":"A+"},{"$f":"I7","v":"B"},{"$f":"I8","v":"B"},{"$f":"I9","v":"A+"}]
[null,"abcB5","abcC5","abcD5","abcE5","abcF5","abcG5","abcH5","abcI5"]
[null,"abcB6","abcC6","abcD6","abcE6","abcF6","abcG6","abcH6","abcI6"]
[null,"abcB7","abcC7","abcD7","abcE7","abcF7","abcG7","abcH7","abcI7"]
[null,"abcB8","abcC8","abcD8","abcE8","abcF8","abcG8","abcH8","abcI8"]
[null,"abcB9","abcC9","abcD9","abcE9","abcF9","abcG9","abcH9","abcI9"]

{"sheet":"TRANSPOSE Function_1","index":2,"n_rows":18,"n_cols":9,"rows_kept":18,"cut":false,"hidden":false,"merged":[[1,1,1,8]]}
[]
[null,"Use of TRANSPOSE Function as a Dynamic Array"]
[]
[null,"Name","AY 2015","AY 2016","AY 2017","AY 2018","AY 2019","AY 2020","AY 2021"]
[null,"John","A+","A","A+","A-","B","A+","A+"]
[null,"Michael","A-","A+","A","A","A+","A+","A+"]
[null,"Martin","A+","A","A-","A+","A+","A+","B"]
[null,"Ricky","A-","A+","A+","A+","A+","A","B"]
[null,"Jack","B","A+","A-","A+","A","A+","A+"]
[]
[null,{"$f":"TRANSPOSE(B4:I9)","v":"Name"},"John","Michael","Martin","Ricky","Jack"]
[null,"AY 2015","A+","A-","A+","A-","B"]
[null,"AY 2016","A","A+","A","A+","A+"]
[null,"AY 2017","A+","A","A-","A+","A-"]
[null,"AY 2018","A-","A","A+","A+","A+"]
[null,"AY 2019","B","A+","A+","A+","A"]
[null,"AY 2020","A+","A+","A+","A","A+"]
[null,"AY 2021","A+","A+","B","B","A+"]

{"sheet":"TRANSPOSE Function_2","index":3,"n_rows":18,"n_cols":9,"rows_kept":18,"cut":false,"hidden":false,"merged":[[1,1,1,8]]}
[]
[null,"Use of TRANSPOSE Function as a Dynamic Array"]
[]
[null,"Name","AY 2015","AY 2016","AY 2017","AY 2018","AY 2019","AY 2020","AY 2021"]
[null,"John","A+","A","A+","A-","B","A+","A+"]
[null,"Michael","A-","A+","A","A","A+","A+","A+"]
[null,"Martin","A+","A","A-","A+","A+","A+","B"]
[null,"Ricky","A-","A+","A+","A+","A+","A","B"]
[null,"Jack","B","A+","A-","A+","A","A+","A+"]
[]
[null,{"$f":"TRANSPOSE(B4:I9)","v":"Name"},"John","Michael","Martin","Ricky","Jack"]
[null,"AY 2015","A+","A-","A+","A-","B"]
[null,"AY 2016","A","A+","A","A+","A+"]
[null,"AY 2017","A+","A","A-","A+","A-"]
[null,"AY 2018","A-","A","A+","A+","A+"]
[null,"AY 2019","B","A+","A+","A+","A"]
[null,"AY 2020","A+","A+","A+","A","A+"]
[null,"AY 2021","A+","A+","B","B","A+"]

{"sheet":"IF&TRANSPOSE Function","index":4,"n_rows":9,"n_cols":9,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,8]]}
[]
[null,"Use of Combined IF & TRANSPOSE Function"]
[]
[null,"Name","2021-11-01","2021-11-02","2021-11-03","2021-11-04","2021-11-05","2021-11-06","2021-11-07"]
[null,"John","Present",null,"Present","Present","Present","Present","Present"]
[null,"Michael","Present",null,"Present","Present","Present",null,"Present"]
[null,"Martin","Present","Present","Present","Present","Present","Present","Present"]
[null,"Ricky","Present","Present",null,"Present","Present","Present","Present"]
[null,"Jack","Present","Present","Present","Present",null,"Present","Present"]

{"sheet":"INDIRECT&ADDRESS Function","index":5,"n_rows":18,"n_cols":9,"rows_kept":18,"cut":false,"hidden":false,"merged":[[1,1,1,8]]}
[]
[null,"Use of Combined INDIRECT & ADDRESS Function"]
[]
[null,"Name","AY 2015","AY 2016","AY 2017","AY 2018","AY 2019","AY 2020","AY 2021"]
[null,"John","A+","A","A+","A-","B","A+","A+"]
[null,"Michael","A-","A+","A","A","A+","A+","A+"]
[null,"Martin","A+","A","A-","A+","A+","A+","B"]
[null,"Ricky","A-","A+","A+","A+","A+","A","B"]
[null,"Jack","B","A+","A-","A+","A","A+","A+"]
[]
[null,{"$f":"INDIRECT(ADDRESS(COLUMN(B4)-COLUMN($B$4)+ROW($B$4),\nROW(B4)-ROW($B$4)+COLUMN($B$4)))","v":"Name"},{"$f":"INDIRECT(ADDRESS(COLUMN(C4)-COLUMN($B$4)+ROW($B$4),\nROW(C4)-ROW($B$4)+COLUMN($B$4)))","v":"John"},{"$f":"INDIRECT(ADDRESS(COLUMN(D4)-COLUMN($B$4)+ROW($B$4),\nROW(D4)-ROW($B$4)+COLUMN($B$4)))","v":"Michael"},{"$f":"INDIRECT(ADDRESS(COLUMN(E4)-COLUMN($B$4)+ROW($B$4),\nROW(E4)-ROW($B$4)+COLUMN($B$4)))","v":"Martin"},{"$f":"INDIRECT(ADDRESS(COLUMN(F4)-COLUMN($B$4)+ROW($B$4),\nROW(F4)-ROW($B$4)+COLUMN($B$4)))","v":"Ricky"},{"$f":"INDIRECT(ADDRESS(COLUMN(G4)-COLUMN($B$4)+ROW($B$4),\nROW(G4)-ROW($B$4)+COLUMN($B$4)))","v":"Jack"}]
[null,{"$f":"INDIRECT(ADDRESS(COLUMN(B5)-COLUMN($B$4)+ROW($B$4),\nROW(B5)-ROW($B$4)+COLUMN($B$4)))","v":"AY 2015"},{"$f":"INDIRECT(ADDRESS(COLUMN(C5)-COLUMN($B$4)+ROW($B$4),\nROW(C5)-ROW($B$4)+COLUMN($B$4)))","v":"A+"},{"$f":"INDIRECT(ADDRESS(COLUMN(D5)-COLUMN($B$4)+ROW($B$4),\nROW(D5)-ROW($B$4)+COLUMN($B$4)))","v":"A-"},{"$f":"INDIRECT(ADDRESS(COLUMN(E5)-COLUMN($B$4)+ROW($B$4),\nROW(E5)-ROW($B$4)+COLUMN($B$4)))","v":"A+"},{"$f":"INDIRECT(ADDRESS(COLUMN(F5)-COLUMN($B$4)+ROW($B$4),\nROW(F5)-ROW($B$4)+COLUMN($B$4)))","v":"A-"},{"$f":"INDIRECT(ADDRESS(COLUMN(G5)-COLUMN($B$4)+ROW($B$4),\nROW(G5)-ROW($B$4)+COLUMN($B$4)))","v":"B"}]
[null,{"$f":"INDIRECT(ADDRESS(COLUMN(B6)-COLUMN($B$4)+ROW($B$4),\nROW(B6)-ROW($B$4)+COLUMN($B$4)))","v":"AY 2016"},{"$f":"INDIRECT(ADDRESS(COLUMN(C6)-COLUMN($B$4)+ROW($B$4),\nROW(C6)-ROW($B$4)+COLUMN($B$4)))","v":"A"},{"$f":"INDIRECT(ADDRESS(COLUMN(D6)-COLUMN($B$4)+ROW($B$4),\nROW(D6)-ROW($B$4)+COLUMN($B$4)))","v":"A+"},{"$f":"INDIRECT(ADDRESS(COLUMN(E6)-COLUMN($B$4)+ROW($B$4),\nROW(E6)-ROW($B$4)+COLUMN($B$4)))","v":"A"},{"$f":"INDIRECT(ADDRESS(COLUMN(F6)-COLUMN($B$4)+ROW($B$4),\nROW(F6)-ROW($B$4)+COLUMN($B$4)))","v":"A+"},{"$f":"INDIRECT(ADDRESS(COLUMN(G6)-COLUMN($B$4)+ROW($B$4),\nROW(G6)-ROW($B$4)+COLUMN($B$4)))","v":"A+"}]
[null,{"$f":"INDIRECT(ADDRESS(COLUMN(B7)-COLUMN($B$4)+ROW($B$4),\nROW(B7)-ROW($B$4)+COLUMN($B$4)))","v":"AY 2017"},{"$f":"INDIRECT(ADDRESS(COLUMN(C7)-COLUMN($B$4)+ROW($B$4),\nROW(C7)-ROW($B$4)+COLUMN($B$4)))","v":"A+"},{"$f":"INDIRECT(ADDRESS(COLUMN(D7)-COLUMN($B$4)+ROW($B$4),\nROW(D7)-ROW($B$4)+COLUMN($B$4)))","v":"A"},{"$f":"INDIRECT(ADDRESS(COLUMN(E7)-COLUMN($B$4)+ROW($B$4),\nROW(E7)-ROW($B$4)+COLUMN($B$4)))","v":"A-"},{"$f":"INDIRECT(ADDRESS(COLUMN(F7)-COLUMN($B$4)+ROW($B$4),\nROW(F7)-ROW($B$4)+COLUMN($B$4)))","v":"A+"},{"$f":"INDIRECT(ADDRESS(COLUMN(G7)-COLUMN($B$4)+ROW($B$4),\nROW(G7)-ROW($B$4)+COLUMN($B$4)))","v":"A-"}]
[null,{"$f":"INDIRECT(ADDRESS(COLUMN(B8)-COLUMN($B$4)+ROW($B$4),\nROW(B8)-ROW($B$4)+COLUMN($B$4)))","v":"AY 2018"},{"$f":"INDIRECT(ADDRESS(COLUMN(C8)-COLUMN($B$4)+ROW($B$4),\nROW(C8)-ROW($B$4)+COLUMN($B$4)))","v":"A-"},{"$f":"INDIRECT(ADDRESS(COLUMN(D8)-COLUMN($B$4)+ROW($B$4),\nROW(D8)-ROW($B$4)+COLUMN($B$4)))","v":"A"},{"$f":"INDIRECT(ADDRESS(COLUMN(E8)-COLUMN($B$4)+ROW($B$4),\nROW(E8)-ROW($B$4)+COLUMN($B$4)))","v":"A+"},{"$f":"INDIRECT(ADDRESS(COLUMN(F8)-COLUMN($B$4)+ROW($B$4),\nROW(F8)-ROW($B$4)+COLUMN($B$4)))","v":"A+"},{"$f":"INDIRECT(ADDRESS(COLUMN(G8)-COLUMN($B$4)+ROW($B$4),\nROW(G8)-ROW($B$4)+COLUMN($B$4)))","v":"A+"}]
[null,{"$f":"INDIRECT(ADDRESS(COLUMN(B9)-COLUMN($B$4)+ROW($B$4),\nROW(B9)-ROW($B$4)+COLUMN($B$4)))","v":"AY 2019"},{"$f":"INDIRECT(ADDRESS(COLUMN(C9)-COLUMN($B$4)+ROW($B$4),\nROW(C9)-ROW($B$4)+COLUMN($B$4)))","v":"B"},{"$f":"INDIRECT(ADDRESS(COLUMN(D9)-COLUMN($B$4)+ROW($B$4),\nROW(D9)-ROW($B$4)+COLUMN($B$4)))","v":"A+"},{"$f":"INDIRECT(ADDRESS(COLUMN(E9)-COLUMN($B$4)+ROW($B$4),\nROW(E9)-ROW($B$4)+COLUMN($B$4)))","v":"A+"},{"$f":"INDIRECT(ADDRESS(COLUMN(F9)-COLUMN($B$4)+ROW($B$4),\nROW(F9)-ROW($B$4)+COLUMN($B$4)))","v":"A+"},{"$f":"INDIRECT(ADDRESS(COLUMN(G9)-COLUMN($B$4)+ROW($B$4),\nROW(G9)-ROW($B$4)+COLUMN($B$4)))","v":"A"}]
[null,{"$f":"INDIRECT(ADDRESS(COLUMN(B10)-COLUMN($B$4)+ROW($B$4),\nROW(B10)-ROW($B$4)+COLUMN($B$4)))","v":"AY 2020"},{"$f":"INDIRECT(ADDRESS(COLUMN(C10)-COLUMN($B$4)+ROW($B$4),\nROW(C10)-ROW($B$4)+COLUMN($B$4)))","v":"A+"},{"$f":"INDIRECT(ADDRESS(COLUMN(D10)-COLUMN($B$4)+ROW($B$4),\nROW(D10)-ROW($B$4)+COLUMN($B$4)))","v":"A+"},{"$f":"INDIRECT(ADDRESS(COLUMN(E10)-COLUMN($B$4)+ROW($B$4),\nROW(E10)-ROW($B$4)+COLUMN($B$4)))","v":"A+"},{"$f":"INDIRECT(ADDRESS(COLUMN(F10)-COLUMN($B$4)+ROW($B$4),\nROW(F10)-ROW($B$4)+COLUMN($B$4)))","v":"A"},{"$f":"INDIRECT(ADDRESS(COLUMN(G10)-COLUMN($B$4)+ROW($B$4),\nROW(G10)-ROW($B$4)+COLUMN($B$4)))","v":"A+"}]
[null,{"$f":"INDIRECT(ADDRESS(COLUMN(B11)-COLUMN($B$4)+ROW($B$4),\nROW(B11)-ROW($B$4)+COLUMN($B$4)))","v":"AY 2021"},{"$f":"INDIRECT(ADDRESS(COLUMN(C11)-COLUMN($B$4)+ROW($B$4),\nROW(C11)-ROW($B$4)+COLUMN($B$4)))","v":"A+"},{"$f":"INDIRECT(ADDRESS(COLUMN(D11)-COLUMN($B$4)+ROW($B$4),\nROW(D11)-ROW($B$4)+COLUMN($B$4)))","v":"A+"},{"$f":"INDIRECT(ADDRESS(COLUMN(E11)-COLUMN($B$4)+ROW($B$4),\nROW(E11)-ROW($B$4)+COLUMN($B$4)))","v":"B"},{"$f":"INDIRECT(ADDRESS(COLUMN(F11)-COLUMN($B$4)+ROW($B$4),\nROW(F11)-ROW($B$4)+COLUMN($B$4)))","v":"B"},{"$f":"INDIRECT(ADDRESS(COLUMN(G11)-COLUMN($B$4)+ROW($B$4),\nROW(G11)-ROW($B$4)+COLUMN($B$4)))","v":"A+"}]

{"sheet":"Power Query Tool","index":6,"n_rows":9,"n_cols":9,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,8]]}
[]
[null,"Use of Power Query Tool"]
[]
[null,"Name","AY 2015","AY 2016","AY 2017","AY 2018","AY 2019","AY 2020","AY 2021"]
[null,"John","A+","A","A+","A-","B","A+","A+"]
[null,"Michael","A-","A+","A","A","A+","A+","A+"]
[null,"Martin","A+","A","A-","A+","A+","A+","B"]
[null,"Ricky","A-","A+","A+","A+","A+","A","B"]
[null,"Jack","B","A+","A-","A+","A","A+","A+"]

{"sheet":"Use of VBA Macros","index":7,"n_rows":18,"n_cols":9,"rows_kept":18,"cut":false,"hidden":false,"merged":[[1,1,1,8]]}
[]
[null,"Use of Combined INDIRECT & ADDRESS Function"]
[]
[null,"Name","AY 2015","AY 2016","AY 2017","AY 2018","AY 2019","AY 2020","AY 2021"]
[null,"John","A+","A","A+","A-","B","A+","A+"]
[null,"Michael","A-","A+","A","A","A+","A+","A+"]
[null,"Martin","A+","A","A-","A+","A+","A+","B"]
[null,"Ricky","A-","A+","A+","A+","A+","A","B"]
[null,"Jack","B","A+","A-","A+","A","A+","A+"]
[]
[null,"Name","John","Michael","Martin","Ricky","Jack"]
[null,"AY 2015","A+","A-","A+","A-","B"]
[null,"AY 2016","A","A+","A","A+","A+"]
[null,"AY 2017","A+","A","A-","A+","A-"]
[null,"AY 2018","A-","A","A+","A+","A+"]
[null,"AY 2019","B","A+","A+","A+","A"]
[null,"AY 2020","A+","A+","A+","A","A+"]
[null,"AY 2021","A+","A+","B","B","A+"]