{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Dataset 1","Ampersand Operator","CONCATENATE Function","Dataset 2","TEXT Function","TEXTJOIN Function","Custom Number Format","Dataset 3","VBA Code"],"not_rendered":{"charts":0,"images":0,"macros":1,"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":"Dataset 1","index":0,"n_rows":14,"n_cols":3,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Report Card"]
[]
[null,"Name","Score"]
[null,"Adam",68]
[null,"Jules",81]
[null,"Fritz",88]
[null,"Marie",93]
[null,"Martin",90]
[null,"Liz",86]
[null,"Jeffery",60]
[null,"Carl",53]
[null,"Edith",49]
[null,"Zach",41]

{"sheet":"Ampersand Operator","index":1,"n_rows":14,"n_cols":12,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,9,1,11]]}
[]
[null,"Using Ampersand Operator",null,null,null,null,null,null,null,"Do Yourself"]
[]
[null,"Name","Score","Result",null,null,null,null,null,"Name","Score","Result"]
[null,"Adam",68,{"$f":"B5&\" \"&IF(C5>=65,\"passed\",\"failed\")&\" \"&\"the test\"","v":"Adam passed the test"},null,null,null,null,null,"Adam",68]
[null,"Jules",81,{"$f":"B6&\" \"&IF(C6>=65,\"passed\",\"failed\")&\" \"&\"the test\"","v":"Jules passed the test"},null,null,null,null,null,"Jules",81]
[null,"Fritz",88,"Fritz passed the test",null,null,null,null,null,"Fritz",88]
[null,"Marie",93,"Marie passed the test",null,null,null,null,null,"Marie",93]
[null,"Martin",90,"Martin passed the test",null,null,null,null,null,"Martin",90]
[null,"Liz",86,"Liz passed the test",null,null,null,null,null,"Liz",86]
[null,"Jeffery",60,"Jeffery failed the test",null,null,null,null,null,"Jeffery",60]
[null,"Carl",53,"Carl failed the test",null,null,null,null,null,"Carl",53]
[null,"Edith",49,"Edith failed the test",null,null,null,null,null,"Edith",49]
[null,"Zach",41,"Zach failed the test",null,null,null,null,null,"Zach",41]

{"sheet":"CONCATENATE Function","index":2,"n_rows":14,"n_cols":12,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,9,1,11]]}
[]
[null,"Using CONCATENATE Function",null,null,null,null,null,null,null,"Do Yourself"]
[]
[null,"Name","Score","Result",null,null,null,null,null,"Name","Score","Result"]
[null,"Adam",68,{"$f":"CONCATENATE(B5,\" \",IF(C5>=65,\"passed\",\"failed\"),\" \", \"the test\")","v":"Adam passed the test"},null,null,null,null,null,"Adam",68]
[null,"Jules",81,{"$f":"CONCATENATE(B6,\" \",IF(C6>=65,\"passed\",\"failed\"),\" \", \"the test\")","v":"Jules passed the test"},null,null,null,null,null,"Jules",81]
[null,"Fritz",88,"Fritz passed the test",null,null,null,null,null,"Fritz",88]
[null,"Marie",93,"Marie passed the test",null,null,null,null,null,"Marie",93]
[null,"Martin",90,"Martin passed the test",null,null,null,null,null,"Martin",90]
[null,"Liz",86,"Liz passed the test",null,null,null,null,null,"Liz",86]
[null,"Jeffery",60,"Jeffery failed the test",null,null,null,null,null,"Jeffery",60]
[null,"Carl",53,"Carl failed the test",null,null,null,null,null,"Carl",53]
[null,"Edith",49,"Edith failed the test",null,null,null,null,null,"Edith",49]
[null,"Zach",41,"Zach failed the test",null,null,null,null,null,"Zach",41]

{"sheet":"Dataset 2","index":3,"n_rows":13,"n_cols":4,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Time Tracker"]
[]
[null,"Name","Entry","Exit"]
[null,"Jules","09:00:00","17:00:00"]
[null,"Molly","09:00:00","18:00:00"]
[null,"Hanson","09:00:00","17:00:00"]
[null,"Mortimer","09:00:00","17:00:00"]
[null,"Jenni","09:00:00","18:00:00"]
[null,"Raymond","09:00:00","17:00:00"]
[null,"Arthur","09:00:00","18:00:00"]
[null,"Benjamin","09:00:00","18:00:00"]
[null,"Lepin","09:00:00","17:00:00"]

{"sheet":"TEXT Function","index":4,"n_rows":13,"n_cols":14,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,10,1,13]]}
[]
[null,"Using TEXT Function",null,null,null,null,null,null,null,null,"Do Yourself"]
[]
[null,"Name","Entry","Exit","Work Hour",null,null,null,null,null,"Name","Entry","Exit","Work Hour"]
[null,"Jules","09:00:00","17:00:00",{"$f":"B5&(\"'s total work hour is: \"&TEXT(IF(D5<>\"\",D5-C5,\"\"),\"h\"))&\"Hrs\"","v":"Jules's total work hour is: 8Hrs"},null,null,null,null,null,"Jules","09:00:00","17:00:00"]
[null,"Molly","09:00:00","18:00:00",{"$f":"B6&(\"'s total work hour is: \"&TEXT(IF(D6<>\"\",D6-C6,\"\"),\"h\"))&\"Hrs\"","v":"Molly's total work hour is: 9Hrs"},null,null,null,null,null,"Molly","09:00:00","18:00:00"]
[null,"Hanson","09:00:00","17:00:00","Hanson's total work hour is: 8Hrs",null,null,null,null,null,"Hanson","09:00:00","17:00:00"]
[null,"Mortimer","09:00:00","17:00:00","Mortimer's total work hour is: 8Hrs",null,null,null,null,null,"Mortimer","09:00:00","17:00:00"]
[null,"Jenni","09:00:00","18:00:00","Jenni's total work hour is: 9Hrs",null,null,null,null,null,"Jenni","09:00:00","18:00:00"]
[null,"Raymond","09:00:00","17:00:00","Raymond's total work hour is: 8Hrs",null,null,null,null,null,"Raymond","09:00:00","17:00:00"]
[null,"Arthur","09:00:00","18:00:00","Arthur's total work hour is: 9Hrs",null,null,null,null,null,"Arthur","09:00:00","18:00:00"]
[null,"Benjamin","09:00:00","18:00:00","Benjamin's total work hour is: 9Hrs",null,null,null,null,null,"Benjamin","09:00:00","18:00:00"]
[null,"Lepin","09:00:00","17:00:00","Lepin's total work hour is: 8Hrs",null,null,null,null,null,"Lepin","09:00:00","17:00:00"]

{"sheet":"TEXTJOIN Function","index":5,"n_rows":13,"n_cols":14,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,10,1,13]]}
[]
[null,"Using TEXTJOIN Function",null,null,null,null,null,null,null,null,"Do Yourself"]
[]
[null,"Name","Entry","Exit","Work Hour",null,null,null,null,null,"Name","Entry","Exit","Work Hour"]
[null,"Jules","09:00:00","17:00:00",{"$f":"_xlfn.TEXTJOIN(\" \",TRUE,B5,\"worked for\",TEXT(IF(D5<>\"\",D5-C5,\"\"),\"h\"),\"Hrs\")","v":"Jules worked for 8 Hrs"},null,null,null,null,null,"Jules","09:00:00","17:00:00"]
[null,"Molly","09:00:00","18:00:00",{"$f":"_xlfn.TEXTJOIN(\" \",TRUE,B6,\"worked for\",TEXT(IF(D6<>\"\",D6-C6,\"\"),\"h\"),\"Hrs\")","v":"Molly worked for 9 Hrs"},null,null,null,null,null,"Molly","09:00:00","18:00:00"]
[null,"Hanson","09:00:00","17:00:00","Hanson worked for 8 Hrs",null,null,null,null,null,"Hanson","09:00:00","17:00:00"]
[null,"Mortimer","09:00:00","17:00:00","Mortimer worked for 8 Hrs",null,null,null,null,null,"Mortimer","09:00:00","17:00:00"]
[null,"Jenni","09:00:00","18:00:00","Jenni worked for 9 Hrs",null,null,null,null,null,"Jenni","09:00:00","18:00:00"]
[null,"Raymond","09:00:00","17:00:00","Raymond worked for 8 Hrs",null,null,null,null,null,"Raymond","09:00:00","17:00:00"]
[null,"Arthur","09:00:00","18:00:00","Arthur worked for 9 Hrs",null,null,null,null,null,"Arthur","09:00:00","18:00:00"]
[null,"Benjamin","09:00:00","18:00:00","Benjamin worked for 9 Hrs",null,null,null,null,null,"Benjamin","09:00:00","18:00:00"]
[null,"Lepin","09:00:00","17:00:00","Lepin worked for 8 Hrs",null,null,null,null,null,"Lepin","09:00:00","17:00:00"]

{"sheet":"Custom Number Format","index":6,"n_rows":13,"n_cols":14,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,10,1,13]]}
[]
[null,"Using Custom Number Format",null,null,null,null,null,null,null,null,"Do Yourself"]
[]
[null,"Name","Entry","Exit","Work Hour",null,null,null,null,null,"Name","Entry","Exit","Work Hour"]
[null,"Jules","09:00:00","17:00:00",{"$f":"TEXT(IF(D5<>\"\",D5-C5,\"\"),\"h\")","v":"8"},null,null,null,null,null,"Jules","09:00:00","17:00:00"]
[null,"Molly","09:00:00","18:00:00",{"$f":"TEXT(IF(D6<>\"\",D6-C6,\"\"),\"h\")","v":"9"},null,null,null,null,null,"Molly","09:00:00","18:00:00"]
[null,"Hanson","09:00:00","17:00:00","8",null,null,null,null,null,"Hanson","09:00:00","17:00:00"]
[null,"Mortimer","09:00:00","17:00:00","8",null,null,null,null,null,"Mortimer","09:00:00","17:00:00"]
[null,"Jenni","09:00:00","18:00:00","9",null,null,null,null,null,"Jenni","09:00:00","18:00:00"]
[null,"Raymond","09:00:00","17:00:00","8",null,null,null,null,null,"Raymond","09:00:00","17:00:00"]
[null,"Arthur","09:00:00","18:00:00","9",null,null,null,null,null,"Arthur","09:00:00","18:00:00"]
[null,"Benjamin","09:00:00","18:00:00","9",null,null,null,null,null,"Benjamin","09:00:00","18:00:00"]
[null,"Lepin","09:00:00","17:00:00","8",null,null,null,null,null,"Lepin","09:00:00","17:00:00"]

{"sheet":"Dataset 3","index":7,"n_rows":14,"n_cols":2,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
[]
[null,"List of Staffs"]
[]
[null,"Name"]
[null,"Anderson"]
[null,"Jules"]
[null,"Molly"]
[null,"Marie"]
[null,"Martin"]
[null,"Liz"]
[null,"Joe"]
[null,"Carrie"]
[null,"Edith"]
[null,"Zach"]

{"sheet":"VBA Code","index":8,"n_rows":14,"n_cols":12,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,10,1,11]]}
[]
[null,"Applying VBA Code",null,null,null,null,null,null,null,null,"Do Yourself"]
[]
[null,"Name","ID",null,null,null,null,null,null,null,"Name","ID"]
[null,"Anderson","ID- 22001",null,null,null,null,null,null,null,"Anderson",22001]
[null,"Jules","ID- 22002",null,null,null,null,null,null,null,"Jules",22002]
[null,"Molly","ID- 22003",null,null,null,null,null,null,null,"Molly",22003]
[null,"Marie","ID- 22004",null,null,null,null,null,null,null,"Marie",22004]
[null,"Martin","ID- 22005",null,null,null,null,null,null,null,"Martin",22005]
[null,"Liz","ID- 22006",null,null,null,null,null,null,null,"Liz",22006]
[null,"Joe","ID- 22007",null,null,null,null,null,null,null,"Joe",22007]
[null,"Carrie","ID- 22008",null,null,null,null,null,null,null,"Carrie",22008]
[null,"Edith","ID- 22009",null,null,null,null,null,null,null,"Edith",22009]
[null,"Zach","ID- 22010",null,null,null,null,null,null,null,"Zach",22010]