{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Sample Dataset","Fill Handle Icon","Excel Ribbon","Power Query","Power Query Result","Go To Special","VBA","RANDBETWEEN Function"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"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":"Sample Dataset","index":0,"n_rows":12,"n_cols":5,"rows_kept":12,"cut":false,"hidden":false,"merged":[[2,1,2,4]]}
[]
[]
[null,"Filling Down to Last Row with Data"]
[]
[null,"Code","Products","Price","Commission"]
[null,"AA01","MacBook Air M1",999,{"$f":"D6*5%","v":49.95}]
[null,"AA02","MacBook Air M2",1199,{"$f":"D7*5%","v":59.95}]
[null,"AA03","MacBook Pro 13\"",1299,64.95]
[null,"AA04","MacBook Pro 16\"",2499,124.95]
[null,"AA05","iMac 24\"",1499,74.95]
[null,"AA06","Mac Mini",699,34.950000000000003]
[null,"AA07","Mac Pro",1999,99.95]

{"sheet":"Fill Handle Icon","index":1,"n_rows":12,"n_cols":5,"rows_kept":12,"cut":false,"hidden":false,"merged":[[2,1,2,4]]}
[]
[]
[null,"Filling Down to Last Row with Data"]
[]
[null,"Code","Products","Price","Commission"]
[null,"AA01","MacBook Air M1",999,{"$f":"D6*5%","v":49.95}]
[null,"AA02","MacBook Air M2",1199,{"$f":"D7*5%","v":59.95}]
[null,"AA03","MacBook Pro 13\"",1299,64.95]
[null,"AA04","MacBook Pro 16\"",2499,124.95]
[null,"AA05","iMac 24\"",1499,74.95]
[null,"AA06","Mac Mini",699,34.950000000000003]
[null,"AA07","Mac Pro",1999,99.95]

{"sheet":"Excel Ribbon","index":2,"n_rows":12,"n_cols":5,"rows_kept":12,"cut":false,"hidden":false,"merged":[[2,1,2,4]]}
[]
[]
[null,"Filling Down to Last Row with Data"]
[]
[null,"Serial No.","Products","Price","Commission"]
[null,1,"MacBook Air M1",999,{"$f":"D6*5%","v":49.95}]
[null,2,"MacBook Air M2",1199,{"$f":"D7*5%","v":59.95}]
[null,3,"MacBook Pro 13\"",1299,{"$f":"D8*5%","v":64.95}]
[null,4,"MacBook Pro 16\"",2499,124.95]
[null,5,"iMac 24\"",1499,74.95]
[null,6,"Mac Mini",699,34.950000000000003]
[null,7,"Mac Pro",1999,99.95]

{"sheet":"Power Query","index":3,"n_rows":12,"n_cols":5,"rows_kept":12,"cut":false,"hidden":false,"merged":[[2,1,2,4]]}
[]
[]
[null,"Filling Down to Last Row with Data"]
[]
[null,"Device","Products","Price","Commission"]
[null,"Laptop","MacBook Air M1",999,{"$f":"D6*5%","v":49.95}]
[null,null,"MacBook Air M2",1199,{"$f":"D7*5%","v":59.95}]
[null,null,"MacBook Pro 13\"",1299,64.95]
[null,null,"MacBook Pro 16\"",2499,124.95]
[null,"Phone","iPhone 14 Pro",999,49.95]
[null,null,"iPhone 14",799,39.950000000000003]
[null,null,"iPhone 13 Mini",599,29.950000000000003]

{"sheet":"Power Query Result","index":4,"n_rows":10,"n_cols":5,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Device","Products","Price","Commission"]
[null,"Laptop","MacBook Air M1",999,49.95]
[null,"Laptop","MacBook Air M2",1199,59.95]
[null,"Laptop","MacBook Pro 13\"",1299,64.95]
[null,"Laptop","MacBook Pro 16\"",2499,124.95]
[null,"Phone","iPhone 14 Pro",999,49.95]
[null,"Phone","iPhone 14",799,39.950000000000003]
[null,"Phone","iPhone 13 Mini",599,29.95]

{"sheet":"Go To Special","index":5,"n_rows":12,"n_cols":5,"rows_kept":12,"cut":false,"hidden":false,"merged":[[2,1,2,4]]}
[]
[]
[null,"Filling Down to Last Row with Data"]
[]
[null,"Device","Products","Price","Commission"]
[null,"Laptop","MacBook Air M1",999,{"$f":"D6*5%","v":49.95}]
[null,{"$f":"B6","v":"Laptop"},"MacBook Air M2",1199,{"$f":"D7*5%","v":59.95}]
[null,"Laptop","MacBook Pro 13\"",1299,64.95]
[null,"Laptop","MacBook Pro 16\"",2499,124.95]
[null,"Phone","iPhone 14 Pro",999,49.95]
[null,{"$f":"B10","v":"Phone"},"iPhone 14",799,39.950000000000003]
[null,"Phone","iPhone 13 Mini",599,29.950000000000003]

{"sheet":"VBA","index":6,"n_rows":12,"n_cols":5,"rows_kept":12,"cut":false,"hidden":false,"merged":[[2,1,2,4]]}
[]
[]
[null,"Filling Down to Last Row with Data"]
[]
[null,"Device","Products","Price","Commission"]
[null,"Laptop","MacBook Air M1",999,{"$f":"D6*5%","v":49.95}]
[null,"Laptop","MacBook Air M2",1199,{"$f":"D7*5%","v":59.95}]
[null,"Laptop","MacBook Pro 13\"",1299,64.95]
[null,"Laptop","MacBook Pro 16\"",2499,124.95]
[null,"Phone","iPhone 14 Pro",999,49.95]
[null,"Phone","iPhone 14",799,39.950000000000003]
[null,"Phone","iPhone 13 Mini",599,29.950000000000003]

{"sheet":"RANDBETWEEN Function","index":7,"n_rows":12,"n_cols":5,"rows_kept":12,"cut":false,"hidden":false,"merged":[[2,1,2,4]]}
[]
[]
[null,"Filling Down to Last Row with Data"]
[]
[null,"Code","Products","Price","Commission"]
[null,"AA01","MacBook Air M1",999,{"$f":"RANDBETWEEN(50,100)","v":75}]
[null,"AA02","MacBook Air M2",1199,{"$f":"RANDBETWEEN(50,100)","v":86}]
[null,"AA03","MacBook Pro 13\"",1299,69]
[null,"AA04","MacBook Pro 16\"",2499,53]
[null,"AA05","iMac 24\"",1499,84]
[null,"AA06","Mac Mini",699,56]
[null,"AA07","Mac Pro",1999,69]