{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Dataset","CELL Function ","Dataset 2","Applying VBA"],"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","index":0,"n_rows":12,"n_cols":4,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Dataset"]
[]
[null,"Name","Work Hours","Daily Pay"]
[null,"Adam ",10,150]
[null,"Layla",9,130]
[null,"Chris",7,140]
[null,"John ",10,160]
[null,"Wanda",6,180]
[null,"Tony",3,115]
[null,"Roy",8,120]
[null,"Mary",10,150]

{"sheet":"CELL Function ","index":1,"n_rows":12,"n_cols":12,"rows_kept":12,"cut":false,"hidden":false,"merged":[[5,6,7,6],[1,1,1,6],[5,5,7,5],[1,9,1,11]]}
[]
[null,"Using CELL Function to Track Cell Changes",null,null,null,null,null,null,null,"Do Yourself"]
[]
[null,"Name","Work Hours","Daily Pay",null,"Last Cell Changed",{"$f":"CELL(\"address\")","v":"$J$2"},null,null,"Name","Work Hours","Daily Pay"]
[null,"Adam ",12,150,null,"Changed To",{"$f":"CELL(\"contents\")","v":"Do Yourself"},null,null,"Adam ",12,150]
[null,"Layla",9,130,null,"Address of the File",{"$f":"CELL(\"filename\")","v":"https://d.docs.live.net/b37c59a4395d7b45/Desktop/Work(Softeko)/Excel Formula to Track Cell Changes/[Formula to Track Cell Changes.xlsm]CELL Function "},null,null,"Layla",9,130]
[null,"Chris",7,140,null,null,null,null,null,"Chris",7,140]
[null,"John ",10,160,null,null,null,null,null,"John ",10,160]
[null,"Wanda",6,180,null,null,null,null,null,"Wanda",6,180]
[null,"Tony",3,115,null,null,null,null,null,"Tony",3,115]
[null,"Roy",8,120,null,null,null,null,null,"Roy",8,120]
[null,"Mary",10,150,null,null,null,null,null,"Mary",10,150]

{"sheet":"Dataset 2","index":2,"n_rows":15,"n_cols":5,"rows_kept":15,"cut":false,"hidden":false,"merged":[[3,1,3,4],[1,1,1,4]]}
[]
[null,"Dataset"]
[]
[null,"Hourly Pay for Employees"]
[null,"1st Class",20,"2nd Class",15]
[]
[null,"Name","Work Hours","Daily Pay"]
[null,"Adam ",10,{"$f":"$C$5*C8","v":200}]
[null,"Layla",9,{"$f":"$E$5*C9","v":135}]
[null,"Chris",7,{"$f":"$E$5*C10","v":105}]
[null,"John ",10,{"$f":"$C$5*C11","v":200}]
[null,"Wanda",6,{"$f":"$E$5*C12","v":90}]
[null,"Tony",8,{"$f":"$E$5*C13","v":120}]
[null,"Roy",8,{"$f":"$C$5*C14","v":160}]
[null,"Mary",10,{"$f":"$E$5*C15","v":150}]

{"sheet":"Applying VBA","index":3,"n_rows":16,"n_cols":13,"rows_kept":16,"cut":false,"hidden":false,"merged":[[3,1,3,4],[1,1,1,4],[2,9,2,12],[4,9,4,12]]}
[]
[null,"Applying VBA Code to Track Changes in Formula Cells"]
[null,null,null,null,null,null,null,null,null,"Do Yourself"]
[null,"Hourly Pay for Employees"]
[null,"1st Class",25,"2nd Class",15,null,null,null,null,"Hourly Pay for Employees"]
[null,null,null,null,null,null,null,null,null,"1st Class",20,"2nd Class",15]
[null,"Name","Work Hours","Daily Pay"]
[null,"Adam ",10,{"$f":"$C$5*C8","v":250},null,null,null,null,null,"Name","Work Hours","Daily Pay"]
[null,"Layla",9,{"$f":"$E$5*C9","v":135},null,null,null,null,null,"Adam ",10,{"$f":"$C$5*K9","v":250}]
[null,"Chris",7,{"$f":"$E$5*C10","v":105},null,null,null,null,null,"Layla",9,{"$f":"$E$5*K10","v":135}]
[null,"John ",10,{"$f":"$C$5*C11","v":250},null,null,null,null,null,"Chris",7,{"$f":"$E$5*K11","v":105}]
[null,"Wanda",6,{"$f":"$E$5*C12","v":90},null,null,null,null,null,"John ",10,{"$f":"$C$5*K12","v":250}]
[null,"Tony",8,{"$f":"$E$5*C13","v":120},null,null,null,null,null,"Wanda",6,{"$f":"$E$5*K13","v":90}]
[null,"Roy",8,{"$f":"$C$5*C14","v":200},null,null,null,null,null,"Tony",8,{"$f":"$E$5*K14","v":120}]
[null,"Mary",10,{"$f":"$E$5*C15","v":150},null,null,null,null,null,"Roy",8,{"$f":"$C$5*K15","v":200}]
[null,null,null,null,null,null,null,null,null,"Mary",10,{"$f":"$E$5*K16","v":150}]