{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Formulas","Formulas Exercise","Totals","Totals 2","Workers","Emp"],"not_rendered":{"charts":0,"images":1,"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":"Formulas","index":0,"n_rows":6,"n_cols":4,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
["Formulas - An expression that you build! "]
[]
["Example",6,10,{"$f":"B3+C3","v":16}]
[null,null,null,{"$f":"5+10","v":15}]
[null,null,null,{"$f":"SUM(B3:C3)","v":16}]
["Functions - Built in formulas"]

{"sheet":"Formulas Exercise","index":1,"n_rows":8,"n_cols":3,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
[1,"<---","Absolute!!!"]
[2,"<----","Relative (Change) "]
[3,null,"=sum($A$1:Last Cell)"]
[4]
[5]
[6]
[7]
[{"$f":"AVERAGE($A$1:A7)","v":4}]

{"sheet":"Totals","index":2,"n_rows":6,"n_cols":4,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
["Product","Price","Qty","Total"]
["Computer",150,2,{"$f":"B2*C2","v":300}]
["Keyboard",20,3,{"$f":"B3*C3","v":60}]
["Mouse",5,4,20]
["Tape",20,4,80]
["Mic",34,6,204]

{"sheet":"Totals 2","index":3,"n_rows":6,"n_cols":4,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
["Product","Price","Qty","Total"]
["Computer",150,2,{"$f":"B2*C2","v":300}]
["Keyboard",20,5,{"$f":"B3*C3","v":100}]
["Mouse",5,4,20]
["Printer",400,1,400]
["Scanner",250,3,750]

{"sheet":"Workers","index":4,"n_rows":6,"n_cols":4,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
["First Name","Last Name","Full Name","Date of Birth"]
["Ruth","Weiss",{"$f":"_xlfn.CONCAT(A2,\" \",B2)","v":"Ruth Weiss"},"1985-11-08"]
["Jenny","Johnson",{"$f":"_xlfn.CONCAT(A3,\" \",B3)","v":"Jenny Johnson"},"1990-09-23"]
["Nicole","Prichard","Nicole Prichard","1997-06-16"]
["Dave","Graham","Dave Graham","1999-05-01"]
["Michael","Levin","Michael Levin","1999-05-01"]

{"sheet":"Emp","index":5,"n_rows":16,"n_cols":4,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
["First Name","Last Name","Full Name","Date of Birth"]
["Ruth","Weiss",{"$f":"_xlfn.CONCAT(A2,\" \",B2)","v":"Ruth Weiss"},"1985-11-08"]
["Jenny","Johnson",{"$f":"_xlfn.CONCAT(A3,\" \",B3)","v":"Jenny Johnson"},"1990-09-23"]
["Nicole","Prichard","Nicole Prichard","1997-06-16"]
["Dave","Graham","Dave Graham","1999-05-01"]
["Michael","Levin","Michael Levin","1999-05-01"]
["Ruth","Weiss","Ruth Weiss","1985-11-08"]
["Jenny","Johnson","Jenny Johnson","1990-09-23"]
["Nicole","Prichard","Nicole Prichard","1997-06-16"]
["Dave","Graham","Dave Graham","1999-05-01"]
["Michael","Levin","Michael Levin","1999-05-01"]
["Ruth","Weiss","Ruth Weiss","1985-11-08"]
["Jenny","Johnson","Jenny Johnson","1990-09-23"]
["Nicole","Prichard","Nicole Prichard","1997-06-16"]
["Dave","Graham","Dave Graham","1999-05-01"]
["Michael","Levin","Michael Levin","1999-05-01"]