{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Dataset 1","Total Price","Retail Price","Dataset 2","Without Using VBA","e00eb4de3c8a421cba9b8f4cb8546ec"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":6,"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":12,"n_cols":4,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Price List for Items in ABC Store"]
[]
[null,"Item","Stock","Unit price"]
[null,"Apple",25,2]
[null,"Melon",28,4]
[null,"Durian ",30,15]
[null,"Orange ",39,2]
[null,"Mango",10,10]
[null,"Lemon",50,1]
[null,"Cherry",20,1]
[null,"Plum ",10,5]

{"sheet":"Total Price","index":1,"n_rows":12,"n_cols":5,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Finding Total Price Using a Custom Formula"]
[]
[null,"Item","Stock","Unit price","Total price"]
[null,"Apple",25,2,{"$f":"TOTALPRICE(C5,D5)","v":50}]
[null,"Melon",28,4,{"$f":"TOTALPRICE(C6,D6)","v":112}]
[null,"Durian ",30,15,{"$f":"TOTALPRICE(C7,D7)","v":450}]
[null,"Orange ",39,2,{"$f":"TOTALPRICE(C8,D8)","v":78}]
[null,"Mango",10,10,{"$f":"TOTALPRICE(C9,D9)","v":100}]
[null,"Lemon",50,1,{"$f":"TOTALPRICE(C10,D10)","v":50}]
[null,"Cherry",20,1,{"$f":"TOTALPRICE(C11,D11)","v":20}]
[null,"Plum ",10,5,{"$f":"TOTALPRICE(C12,D12)","v":50}]

{"sheet":"Retail Price","index":2,"n_rows":12,"n_cols":6,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Calculating Retail Price Applying Custom Formula"]
[]
[null,"Item","Price1","Price2","Divisor","Retail Price"]
[null,"Apple",10,2,2,{"$f":"RETAILPRICE(C5,D5,E5)","v":6}]
[null,"Melon",8,4,3,{"$f":"RETAILPRICE(C6,D6,E6)","v":4}]
[null,"Durian ",10,15,2,{"$f":"RETAILPRICE(C7,D7,E7)","v":12.5}]
[null,"Orange ",5,2,2,{"$f":"RETAILPRICE(C8,D8,E8)","v":3.5}]
[null,"Mango",20,10,2,{"$f":"RETAILPRICE(C9,D9,E9)","v":15}]
[null,"Lemon",3,1,3,{"$f":"RETAILPRICE(C10,D10,E10)","v":1.3333333333333333}]
[null,"Cherry",4,1,3,{"$f":"RETAILPRICE(C11,D11,E11)","v":1.6666666666666667}]
[null,"Plum ",10,5,3,{"$f":"RETAILPRICE(C12,D12,E12)","v":5}]

{"sheet":"Dataset 2","index":3,"n_rows":13,"n_cols":3,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Employee List of ABC Company"]
[]
[null,"First Name","Last Name"]
[null,"Christian","Pulisic"]
[null,"James","Harrison"]
[null,"Peter","Schultz"]
[null,"Kimberly","Cruz"]
[null,"Kate","Watson"]
[null,"Jason","Green"]
[null,"James","Reyes"]
[null,"Cooper","Hale"]
[null,"Demi","Sagan"]

{"sheet":"Without Using VBA","index":4,"n_rows":13,"n_cols":4,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Creating Custom Formula Without Using VBA"]
[]
[null,"First Name","Last Name","Email"]
[null,"Christian","Pulisic",{"$f":"email_generator(B5,C5)","v":"ChristianPulisic@xyz.com"}]
[null,"James","Harrison",{"$f":"email_generator(B6,C6)","v":"JamesHarrison@xyz.com"}]
[null,"Peter","Schultz",{"$f":"email_generator(B7,C7)","v":"PeterSchultz@xyz.com"}]
[null,"Kimberly","Cruz",{"$f":"email_generator(B8,C8)","v":"KimberlyCruz@xyz.com"}]
[null,"Kate","Watson",{"$f":"email_generator(B9,C9)","v":"KateWatson@xyz.com"}]
[null,"Jason","Green",{"$f":"email_generator(B10,C10)","v":"JasonGreen@xyz.com"}]
[null,"James","Reyes",{"$f":"email_generator(B11,C11)","v":"JamesReyes@xyz.com"}]
[null,"Cooper","Hale",{"$f":"email_generator(B12,C12)","v":"CooperHale@xyz.com"}]
[null,"Demi","Sagan",{"$f":"email_generator(B13,C13)","v":"DemiSagan@xyz.com"}]

{"sheet":"e00eb4de3c8a421cba9b8f4cb8546ec","index":5,"n_rows":2,"n_cols":6,"rows_kept":2,"cut":false,"hidden":true,"merged":[]}
[{"$f":"SUM(,)","v":0},{"$f":"{1,2;3,4}","v":{"$error":"#VALUE!"}},{"$f":"LEN(\"abc\")","v":3},{"$f":"SUM(1)","v":1},{"$f":"1.5","v":1.5},"2003-01-02"]
[{"$f":"DOLLAR(1,0)","v":"$1"},{"$f":"ADDRESS(1,1,2,0)","v":"R1C[1]"},{"$f":"FIXED(1E+21, 0, FALSE)","v":"1,000,000,000,000,000,000,000"}]