{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Overview","Keyboard","AutoFill","Custom","Flash Fill","ROW","CHAR","OFFSET","VBA"],"not_rendered":{"charts":0,"images":0,"macros":0,"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":"Overview","index":0,"n_rows":14,"n_cols":3,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Overview"]
[]
[null,"Name","ID"]
[null,"Bob","S5001"]
[null,"John","S5002"]
[null,"Ben","S5003"]
[null,"Costa","S5004"]
[null,"Brine","S5005"]
[null,"Herry","S5006"]
[null,"Ema","S5007"]
[null,"Rose","S5008"]
[null,"Anny","S5009"]
[null,"Cathy","S5010"]

{"sheet":"Keyboard","index":1,"n_rows":14,"n_cols":4,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Keyboard shortcut to Make Numbered"]
[]
[null,"Name","ID","Remarks"]
[null,"Bob","S5001","• 5001"]
[null,"John","S5002","• 5002"]
[null,"Ben","S5003","• 5003"]
[null,"Costa","S5004","• 5004"]
[null,"Brine","S5005","• 5005"]
[null,"Herry","S5006","• 5006"]
[null,"Ema","S5007","• 5007"]
[null,"Rose","S5008","• 5008"]
[null,"Anny","S5009","• 5009"]
[null,"Cathy","S5010","• 5010"]

{"sheet":"AutoFill","index":2,"n_rows":14,"n_cols":3,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"AutoFill Option"]
[]
[null,"Name","ID"]
[null,"Bob",5001]
[null,"John",5002]
[null,"Ben",5003]
[null,"Costa",5004]
[null,"Brine",5005]
[null,"Herry",5006]
[null,"Ema",5007]
[null,"Rose",5008]
[null,"Anny",5009]
[null,"Cathy",5010]

{"sheet":"Custom","index":3,"n_rows":14,"n_cols":3,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Custom Format to Make a Numbered List"]
[]
[null,"Name","ID"]
[null,"Bob","S5001"]
[null,"John","S5002"]
[null,"Ben","S5003"]
[null,"Costa","S5004"]
[null,"Brine","S5005"]
[null,"Herry","S5006"]
[null,"Ema","S5007"]
[null,"Rose","S5008"]
[null,"Anny","S5009"]
[null,"Cathy","S5010"]

{"sheet":"Flash Fill","index":4,"n_rows":14,"n_cols":12,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Flash Fill"]
[]
[null,"Name","ID","Remarks"]
[null,"Bob","S5001",5001]
[null,"John","S5002",5002]
[null,"Ben","S5003",5003]
[null,"Costa","S5004",5004]
[null,"Brine","S5005",5005]
[null,"Herry","S5006",5006]
[null,"Ema","S5007",5007]
[null,"Rose","S5008",5008]
[null,"Anny","S5009",5009]
[null,"Cathy","S5010",5010,null,null,null,null,null,null,null,"•"]

{"sheet":"ROW","index":5,"n_rows":14,"n_cols":4,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Row Function"]
[]
[null,"Name","ID","Position"]
[null,"Bob","S5001",{"$f":"ROW()","v":5}]
[null,"John","S5002",{"$f":"ROW()","v":6}]
[null,"Ben","S5003",{"$f":"ROW()","v":7}]
[null,"Costa","S5004",{"$f":"ROW()","v":8}]
[null,"Brine","S5005",{"$f":"ROW()","v":9}]
[null,"Herry","S5006",{"$f":"ROW()","v":10}]
[null,"Ema","S5007",{"$f":"ROW()","v":11}]
[null,"Rose","S5008",{"$f":"ROW()","v":12}]
[null,"Anny","S5009",{"$f":"ROW()","v":13}]
[null,"Cathy","S5010",{"$f":"ROW()","v":14}]

{"sheet":"CHAR","index":6,"n_rows":13,"n_cols":4,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"CHAR Function"]
[]
[null,"Name","ID","Numbered"]
[null,"Bob","S5001",{"$f":"CHAR(49)","v":"1"}]
[null,"John","S5002",{"$f":"CHAR(50)","v":"2"}]
[null,"Ben","S5003",{"$f":"CHAR(51)","v":"3"}]
[null,"Costa","S5004",{"$f":"CHAR(52)","v":"4"}]
[null,"Brine","S5005",{"$f":"CHAR(53)","v":"5"}]
[null,"Herry","S5006",{"$f":"CHAR(54)","v":"6"}]
[null,"Ema","S5007",{"$f":"CHAR(55)","v":"7"}]
[null,"Rose","S5008",{"$f":"CHAR(56)","v":"8"}]
[null,"Anny","S5009",{"$f":"CHAR(57)","v":"9"}]

{"sheet":"OFFSET","index":7,"n_rows":16,"n_cols":11,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"OFFSET Function"]
[]
[null,"Name","ID","Numbered"]
[null,"Bob","S5001",{"$f":"OFFSET(D5,-1,1)+1","v":1}]
[null,"John","S5002",{"$f":"OFFSET(D6,-1,0)+1","v":2}]
[null,"Ben","S5003",{"$f":"OFFSET(D7,-1,0)+1","v":3}]
[null,"Costa","S5004",4]
[null,"Brine","S5005",5]
[null,"Herry","S5006",6]
[null,"Ema","S5007",7]
[null,"Rose","S5008",8]
[null,"Anny","S5009",9]
[null,"Cathy","S5010",10]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"OFFSET(K16,-1,1)+1","v":1}]

{"sheet":"VBA","index":8,"n_rows":10,"n_cols":2,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
[null,1]
[null,2]
[null,3]
[null,4]
[null,5]
[null,6]
[null,7]
[null,8]
[null,9]
[null,10]